Question

Problem 8.09 (Excel Video) Helen Martin is looking to invest in a three-year bond that makes semi-annual coupon payments at a rate of 5.775 percent. If these bonds have a market price of $981.68, what yield to maturity can she expect to earn? (Round intermediate calculations to 5 decimal places, e.g. 1.25145 and final answer to 2 decimal places, e.g. 15.25%.) Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem.) Yield to maturity

Answer 1

Answer:

Given

Face Value F=$1000

Current Market Price P=$981.68

Coupon rate =5.775%

Coupon payment per semiannual C=5.775%*1000/2=$28.875

Period N=2*3=6 semiannual

let r be the semiannual discount rate

So P=C*(1-(1+r)^-6)/r + F/(1+r)^6

981.68=28.875*(1-(1+r)^-6)/r + 1000/(1+r)^6

So solving for r we get r=3.23%

YTM =2* r=2*3.23%=6.46%