Coupon Rate of Bond – Excel Template

Ivan Kitov
Ivan Kitov

Investors in fixed income securities have two primary concerns— the price of a bond and the yield it generates. The coupon rate is the annual interest rate investors expect to receive while holding the bond.  To calculate the coupon yield of a bond, you divide the total annual interest payments by the face value. Use the template to calculate the annual interest rate of a bond after its issue date.

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

Coupon Rate of Bond 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—Holding Period Yield, Bank Discount Yield, and Effective Annual Yield.