Answer the following questions, using the spreadsheet model to do the calculations. Fill out all hishlighted cells. a. Find the FV of $1,000 invested to earn 10% annually 5 years from now. Answer this question by using a math formula and alse by using the Excel function, fx. Irouts PV = WR = N = PMT = Outputs Use Formula: FV=PV(1+1)WN= Use Excel FV Function: b. What would the FV for part (a) be if the interest rate were 10% with semiannual compounding rather than 10N with annual compounding? Inguts PV=WR=N=PMT= Ouputs Use Formula: FV=PV(1+T)N= Uso Excel FV Function: c. Use information in part (o) to create a tabile that shows the FV at 0%,5%, and 20%, for 0,1,2,3,4, and 5 years. Then create a graph with years on the horlacental axis and FV on the vertieal oxis to disploy your rosults. Piece your graph here : d. Find the PV of 81,000 due in 5 years if the discount rate is 10% per year. Apain, work the problem with a formula and also by uning the function wixard. e. What would the PV for part (d) be if the interest rate were 10% with semiannual compounding rather than 103 with annual compounding? Inouts AV=WR=N=PMT= Outputs Formula: PV = FVII 1+17NN= Uso Excel PV Function: Switch To Light Mode colputs Formax: PV = FVic1+1KN = Use Excel IPN Functien: whth annual compounding? Inputs F=WR=N=PMT= Outpots Formula: PV=FVir1+H/N * Use Excel IF Functien: provide? Inpouts PV=PV=N=PMT= Outpits Une Excel RATE Function: Note: Une zero for Pmit ince there are no periodik poymenta. Nobe har the PVis given a negative sign because it is an outlow (cost to bey the securty) invesment to double? \begin{tabular}{|c|c|c|} \hline \multirow[t]{4}{*}{ Inputs } & hous: & PV= \\ \hline & & FV= \\ \hline & & \\ \hline & & PMT : \\ \hline Outputs & & \\ \hline \end{tabular} Use Excel NPER Funstien: * Yours bodite. h. Find the PV of an ordinary annully that poys 31,000 at be end ef each of the next 5 years if the intereat rate is 19.5. \begin{tabular}{|c|c|c|} \hline \multirow[t]{4}{*}{ Inpule: } & PMT = & \\ \hline & PV= & \\ \hline & N= & \\ \hline & WR= & \\ \hline PV: US & \multicolumn{2}{|r|}{PN=} \\ \hline \end{tabular} Inpots: PV: Use turction wiard (PV) \begin{tabular}{|r|r|} \hline Youl & Proment \\ \hline 1 & 160 \\ 2 & 200 \\ 3. & 400 \\ Rate = & W \end{tabular} To find the PV, use the NPV function