Your last challenge is to value the bond using Excel.

Use the PV formula $($see below$)$ and assume an annual yield to maturity of $7\mathrm{.}25\%.$

Enter your answer into the space below,

then click "Submit" to check your work.

Present Value function: $=PV($rate$,$ nper, pmt$,[$fv$],[$type$])$

You can ignore $[$type$]$ for bond valuation.

Face

Value

$($fv$)$

$$5000$