Abstract
Duration is significant in that it summarizes a bond or a portfolio's sensitivity to interest rates. Based on the constructivist learning approach, we propose an Excelbased assignment that encourages student interaction and active learning which leads to individual discovery regarding the properties of bonds and their effects on duration. Students receive immediate feedback by constructing dynamic Excel tables and figures to calculate duration for bonds with various maturity terms, coupon rates, yields to maturity, and frequencies of coupon payments. The constructivist approach to teaching bond duration is valuable because it requires students to actively acquire and construct knowledge.
Recommended Citation
(2026)
"Bond Duration: Constructivist Learning Using Excel,"
Journal of Economics and Finance Education: Vol. 15:
Iss.
1, Article 5.
Available at:
https://scholarship.rollins.edu/jefe/vol15/iss1/5
