Problem $8\mathrm{.}20$ Bond valuation Givens: Par Value Years to Maturity Coupon Rate $\%$ a$.$ Hypothetical Market Rate b$.$ Hypothetical Market Rate c$.$ Hypothetical Market Rate Market Coupon Par Value $=$ Payment x PVFA$($k$,$n$)+$ Value x PVF$($k$,$n$)$ a$.$ MV $=$ #VALUE! x PVFA$(,)+$ $$0\mathrm{.}00$ x PVF$(,)$ MV $=$ #VALUE! x $0\mathrm{.}0000+$ $$0\mathrm{.}00$ x $1\mathrm{.}0000$ MV $=$ #VALUE! $+$ $$0\mathrm{.}00$ MV $=$ #VALUE! b$.$ MV $=$ #VALUE! x PVFA$(,)+$ $$0\mathrm{.}00$ x PVF$(,)$ MV $=$ #VALUE! x $0\mathrm{.}0000+$ $$0\mathrm{.}00$ x $1\mathrm{.}0000$ MV $=$ #VALUE! $+$ $$0\mathrm{.}00$ MV $=$ #VALUE! c$.$ MV $=$ #VALUE! x PVFA$(,)+$ $$0\mathrm{.}00$ x PVF$(,)$ MV $=$ #VALUE! x $0\mathrm{.}0000+$ $$0\mathrm{.}00$ x $1\mathrm{.}0000$ MV $=$ #VALUE! $+$ $$0\mathrm{.}00$ MV $=$ #VALUE! d$.$ When the market rate equals the coupon rate $($part a$),$ When the market rate is below the coupon rate $($part b$),$ When the market rate is above the coupon rate $($part c$),$