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$

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.

Face

Value

$($fv$)$

$$5000$

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.

Answer: $

$99$

Not quite!

Please try agahf.