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: rate, nper, pmt$,[$fv$],[$type$])$

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

Hint: Don't forget to enter the yield per payment

period $($semiannual$).$ You may enter this number

as a percent $(3\mathrm{.}625\%)$ or a decimal $(\mathrm{.}03625).$

Make sure you include the $"="$ before the formula.

Check out an example.

Not quite!

Answer: $

Please try again.