### How can I calculate a bond's coupon rate in Excel?

### FREE

For example, if a bond has a par value of $1,000 and generates two $30 coupon payments each year, the coupon rate is ($30 x 2) ÷ $1,000, or 0.06. Once the cell format is adjusted, the formula

*Actived: Monday May 18, 2015*

*Link: https://www.investopedia.com/ask/answers/051815/how-can-i-calculate-bonds-coupon-rate-excel.asp*