challenge $3$

You are getting close!

Now you just need to calculate the value of this bond. You need to do this $3$ ways:

Using a formula

Using a financial calculator

Using Excel

First, use the formula and clues you collected. Assume an annual yield to maturity of $4\%.$ Enter your answer into the space below, then click "Submit" to check your work.

Face Value $($FV$)$

$$5000$

$[$:$=CPN[\frac{1}{y}(1-\frac{1}{(1+y{)}^x})]+\frac{FV}{(1+y{)}^x}$