Use the following template to answer the question below: Assume you buy $$100$ face value of bonds. Cash flow in year $0($i$.$e$.,$ when yo make the investment$)$ is the $$100$ Bonds x price. Note this is entered as a negative numebr. All other numbers are entered as positives. Each time period thereafter is the coupon x $100/2/$ You divide by $2$ because the coupon is paid every six months. The last time period $($i$.$e$.,$ when the bonds is repaid$)$ is the semi annual coupon $+$ $$100$ face value of the bonds $+$ any call or make whole payment. Once you have inputted all teh cash flows in excel, use the IRR formual to calculate the semi$-$annual yield. The annual yield is just semi$-$annual yieldmultiple by $2.*$Note for each question you need to run this table $5$ times with different assumptions on when the bonds is paid down.

$----$

You are going to buy a bond due in $5$ years with no call protection.

Coupon: $,8\%,($note the bond pays $\frac{1}{2}$ the coupon every $6$ months$).$

Your boss wants you to fill in the following IRR table at purchase prices of the bonds ranging from $85\%$ to

$105\%$ and prepayment starting at $1$ year till maturity. IRR Table: