Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fiduciary Finance Investment Funds And The Crisis In Financial Markets

Authors: Martin Gold

1st Edition

1848448953, 9781848448957

More Books

Students also viewed these Finance questions

Question

What are the primary uses of the employee earnings record?

Answered: 1 week ago