Bond Valuation – Excel Template

Ivan Kitov
Ivan Kitov

Bond valuation is based on the time value of money principle. In fact, bond pricing is simply an application of discounted cash flow analysis—all you must do is solve a time value of money problem. The bond price identifies the present value of all future cash flows until maturity, discounted by the yield to maturity (YTM). You can use the template to determine the theoretical fair value of a bond.

This open-access Excel template is a useful tool for bankers, investment professionals, corporate finance practitioners, portfolio managers, and anyone preparing a corporate presentation.

Bond Valuation is among the topics included in the Fixed Income module of the CFA Level 1 Curriculum. Gain valuable insights into the subject with our Fixed Income Investments course.

You can also explore other related templates such as—Yield to Maturity, Current Yield of a Bond, and Coupon Rate of Bond.