To calculate the bond's coupon rate, divide the total annual interest payments by the face value. In this case, the total annual interest payment equals $10 x 2 = $20. The annual coupon rate for IBM bond is thus $20 / $1,000 or 2%.
Yield to Maturity vs. Coupon Rate: What's the Difference? - Investopedia
www.investopedia.com > ask > answers > what-difference-between-yield-m...
To calculate the current yield of a bond in Microsoft Excel, enter the bond value, the coupon rate, and the bond price into adjacent cells (e.g., A1 through A3). In cell A4, enter the formula "= A1 * A2 / A3" to render the current yield of the bond.
How Do I Calculate Yield in Excel? - Investopedia
www.investopedia.com > ask > answers > how-do-i-calculate-yield-excel
YIELD is an Excel function that returns the yield to maturity of a bond given its coupon rate, current price, principal amount and coupon payment frequency per year. In the context of debt securities, yield is the return that a debt-holder earns by investing in a security at its current price.
Excel YIELD Function - XPLAIND.com
xplaind.com > Finance > Excel PV Function