Shawna Carter wants to invest her recent bonus in an 8-year bond that pays a coupon of 5 percent semiannually. The bonds are selling at $988.15 today. If she buys this bond and holds it to maturity, what would be her yield? (Round to the closest answer.)
Yield = 5.1828%
Use RATE function in excel as follows and then multiply by 2 to annualise (semi-annual payments)
Nper = 8 * 2
Pmt = 1000 * 5% / 2
Get Answers For Free
Most questions answered within 1 hours.