15% Kashe Duk Sayi
In cell B2, enter the formula “=A3/B1” to yield the annual coupon rate of your bond in decimal form. Finally, select cell B2 and hit CTRL+SHIFT+% to apply percentage formatting. 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.
Sami Code