Compute the missing parameters for bonds A$,$ B and C$.$ All responses should be positive values. Use the $=$PV function in excel to compute prices and $=$rate function to compute yields. No need to enter $[$type$]$ or $[$guess$]$ parameters.

Bond A Bond B Bond C

Years to maturity $($nper$)123012$

Number of coupon payment per year $111$

Coupon rate $($multiply by par value to give pmt$)7\%8\%6\%$

PROVIDE FORMULASSSSSSS. just give the answer for the yellow boxes.

Par value $([$fv$])$ $$1,000$ $$1,000$ $$1,000$

Yield to maturity $($rate$)7\%7\%$

Price $($pv$)$ $$1,000$

Which bond will change the most in value if interest rate levels change?

$($Refer to section $8\mathrm{.}4$ in your text. Decision making example $8\mathrm{.}1$ may be helpful.$)$