Please use excel and show your work. Please set up each problem as if it were a small Table $2\mathrm{.}4$ Yield Curve on March $15,2000$

Yields calculated based on data from CRSP $($Daily Treasuries$).$model. That is$,$ you should have separate input and calculation sections. I should be able to change the inputs and still get the correct answer. You will also have to type some tables of interest rates into Excel. Also, use text boxes and the equation editor to summarize all calculations.

Question:

Using the semi$-$annually compounded yield curve in Table $2\mathrm{.}4,$ price the following

securities:

$($c$)4-$year coupon bond paying $7\%$ quarterly

$($d$)31/4-$year coupon bond paying $9\%$ semiannually

$($e$)4-$year floating rate bond with zero spread and semiannual payments

$($h$)71/4-$year floating rate bond with $40$ basis point spread with semiannual payments