Excel Assignment: FV$,$ PV$,$ and PMT $($Annuities: PMT FVa PVa RATE NPER$).$ This is an individual assignment, not a team assignment. Future Value of an Annual PMT $($or Annuity$)($FVa$)$ Create an Excel model that will calculate FVa, based on a known annual PMT$.$ 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$]$ PMT $($Annual Payment$)$: $($input field$)$ Please enter the value $$6,000$ NPER $($Number of Periods$)$: $($input field$)$ Please enter the value $30\mathrm{.}0(30$ years$)$ RATE $($Interest Rate$)$: $($input field$)$ Please enter the value $8\mathrm{.}50\%($annual rate of interest$)$ FVa $($Future Value$)$: Calculation Field. Please use the Excel function $$FV$.$ You must set up the calculation in this field correctly. Future Value of a MONTLY PMT $($or Annuity$)($FVa$)$ Create an Excel model that will calculate FVa, based on a known MONTHLY PMT$.$ 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$]$ PMT $($MONTHLY Payment$)$: $($input field$)$ Please enter the value $$500$ NPER $($Number of Periods$)$: $($input field$)$ Please enter the value $30\mathrm{.}0(30$ years$)$ RATE $($Interest Rate$)$: $($input field$)$ Please enter the value $8\mathrm{.}50\%($annual rate of interest$)$ FVa $($Future Value$)$: Calculation Field. Please use the Excel function $$FV$.$ You must set up the calculation in this field correctly. Monthly Payment $($PMT$)$ to achieve a known FV Create an Excel model that will calculate a monthly PMT$,$ 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 $$50,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 $9\mathrm{.}50\%($annual rate of interest$)$ PMT $($Payment$--$Monthly$)$: Calculation Field. Please use the Excel function $$PMT$.$ Yo