present value $(PV)=,$$$903\mathrm{.}00$

$2$ future value $(FV)=,$$$1,541\mathrm{.}59$

$3$ number $of$ periods $=,13$

$4$ interest rate per period $=,4\mathrm{.}2\%$

In the following excercises, always reference the values in cells B$1$:B$4,$ never hardcode them in your formula

$(1)$ use the equation $PV=C_0=\frac{C_t}{(1+r{)}^t}$ to calculate the PV based on the other three numbers given.

$(2)$ re$-$calculate the PV using the PV excel function.

Enter your function here

Format as Currency with $2$ decimal places

$(3)$ use equation $FV=C_t=C_0(1+r{)}^t$ to calculate the $FV$ based on the other three numbers given.

Enter your function here

Format as Currency' with $2$ decimal places

$(4)$ re$-$calculate the FV using the FV excel' function.

D$18$

Enter your function here

Format as Currency with $2$ decimal places

$(5)$ calculate the number of periods using the NPER excel function.

Enter your function here

Format as Number with $1$ decimal place

$(6)$ calculate the interest rate using the RATE excel function.

Enter your function here

Format as Percentage with $1$ decimal place

Sheet$1$

Edit if Accessibility: Investigate

esc

B

$I$

u

MacBook

ck