Future Value $($FV$)$

Create an Excel model that will calculate FV$,$ based on a known PV$.$ Note that on the template, this model is found under its own tab. $$Keep it this way. $$Please account for the following:

$[$Note: $$For input fields, enter the values given here. $$For calculation fields, YOU set up the spreadsheet to complete the correct calculation$]$

$$

PV$($Present Value$)$: $($input field$)$Please enter the value $$1,000$

NPER$($Number of Periods$)$: $($input field$)$ Please enter the value $25\mathrm{.}0(25$ years$)$

RATE$($Interest Rate$)$: $($input field$)$ Please enter the value $8\mathrm{.}50\%($annual rate of interest$)$

FV$($Future Value$)$: $$Calculation Field. $$Please use the Excel function $$FV$.$You must set up the calculation in this field correctly.

Present Value $($PV$)$

Create an Excel model that will calculate PV$,$ based on a known FV$.$ Note that on the template, this model is found under its own tab. $$Keep it this way. $$Please account for the following:

$[$Note: $$For input fields, enter the values given here. $$For calculation fields, YOU set up the spreadsheet to complete the correct calculation$]$

$$

FV$($Future Value$)$: $($input field$)$Please enter the value $$3,000$

NPER$($Number of Periods$)$: $($input field$)$ Please enter the value $15\mathrm{.}0(15$ years$)$

RATE$($Interest Rate$)$: $($input field$)$ Please enter the value $7\mathrm{.}50\%($annual rate of interest$)$

PV$($Present Value$)$: $$Calculation Field. $$Please use the Excel function $$PV$.$You must set up the calculation in this field correctly.

Rate of Interest $($RATE$)$

Create an Excel model that will calculate RATE, based on a known PV and FV$.$ Note that on the template, this model is found under its own tab. $$Keep it this way. $$Please account for the following:

$[$Note: $$For input fields, enter the values given here. $$For calculation fields, YOU set up the spreadsheet to complete the correct calculation$]$

$$

PV$($Present Value$)$: $($input field$)$Please enter the value $$1,000$

NPER$($Number of Periods$)$: $($input field$)$ Please enter the value $25\mathrm{.}0(25$ years$)$

FV$($Future Value$)$: $($input field$)$Please enter the value $$7,000$

RATE$($Rate of Interest$)$: $$Calculation Field. $$Please use the Excel function $$RATE$.$You must set up the calculation in this field correctly.

Number of Periods $($NPER$)$

Create an Excel model that will calculate NPER, based on a known PV and FV$.$ Note that on the template, this model is found under its own tab. $$Keep it this way. $$Please account for the following:

$[$Note: $$For input fields, enter the values given here. $$For calculation fields, YOU set up the spreadsheet to complete the correct calculation$]$

$$

PV$($Present Value$)$: $($input field$)$Please enter the value $$1,000$

RATE$($Interest Rate$)$: $($input field$)$ Please enter the value $6\mathrm{.}50\%($annual rate of interest$)$

FV$($Future Value$)$: $($input field$)$Please enter the value $$4,000$

NPER$($Number of Periods$)$: $$Calculation Field. $$Please use the Excel function $$NPER$.$You must set up the calculation in this field correctly. $\backslash$begin$\{$tabular$\}\{|$l$|$l$|$l$|$l$|$l$|$l$|$l$|$l$|\}$

$\backslash$hline & A & B & C & D & E & F & G $\backslash \backslash$

$\backslash$hline $1$ & $\backslash$multicolumn$\{3\}\{|$l$|\}\{$Numer of Periods $($NPER$)\}$ & & & & $\backslash$begin$\{$tabular$\}\{|$l$|$l$|$c$|\}$

$\backslash$hline & $\backslash$multicolumn$\{1\}\{$c$\}\{$ A $\}$ & $\backslash$multi $\backslash$begin$\{$tabula