In short, the coupon rate is affected by both prevailing interest rates and by the issuer’s creditworthiness. The prevailing interest rate directly affects the coupon rate of a bond, as well as its market price.

What must the coupon rate be on the bonds?

A bond’s coupon rate is equal to its yield to maturity if its purchase price is equal to its par value. The par value of a bond is its face value, or the stated value of the bond at the time of issuance, as determined by the issuing entity. Most bonds have par values of $100 or $1,000.

How do you calculate coupon rate in Excel?

Moving down the spreadsheet, enter the par value of your bond in cell B1. Most bonds have par values of $100 or $1,000, though some municipal bonds have pars of $5,000. In cell B2, enter the formula “=A3/B1” to yield the annual coupon rate of your bond in decimal form.