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.

Coupon Rate of Bond – Excel Template Cover

    By continuing you agree to 365 Data Science’s Terms of Use and Privacy Policy