Time-Value Concepts, Bond Valuation, and Corresponding Spreadsheet Functions

This paper extends the coverage of bond valuation in introductory finance textbooks. Specifically, it extends the basic model for bond valuation to a more versatile model, which can accommodate valuation dates besides those matching the coupon dates of a bond. Such an extension allows the accrued interest to be properly recognized. Various spreadsheet-based exercises with data from bond quotations are proposed, in order to make the bond model more practically relevant and to enhance the learning experience of students. Connections between some bond-specific spreadsheet functions and the underlying time-value concepts are also established.