Answer:
YTM is 7.46%
Step-by-step explanation:
Given:
Face value of bond (FV) = $1,000
Years to maturity (nper) = 10
Coupon rate = 10%
Coupon payment (pmt) = $100 (0.1×1,000)
Price of bond (PV) = $1,175
If the bonds are held till maturity, then yield to maturity is calculated using excel function =Rate(nper,pmt,PV,FV)
Yield of bond if held till maturity is 7.46%