In: Finance
Yield to maturity. What is the yield of each of the following bonds,, if interest (coupon) is paid semiannually?
a. What is the yield of the following bond if interest (coupon) is paid semiannually?
(Round to two decimal places.)
Par Value | Coupon Rate | Years to Maturity | Yield to Maturity | Price | ||
$5,000.00 | 11% | 30 | ? | $6,030.00 | ||
$5,000.00 | 8% | 5 | ? | $5,000.00 | ||
$1,000.00 | 12% | 5 | ? | $1,200.00 | ||
$1,000.00 | 6% | 20 | ? | $590.00 |
Ans:- we will use the RATE function of excel to find the YTM.
RATE function of excel is given by =RATE(nper,pmt,pv,fv), where nper is the number of periods, pmt is the periodic payment, pv is the price of the bond and fv is the future or par value of the bond.
Pmt is calculated by Par Value * coupon rate / 2.