Question: Using Excel, complete the following problems. Round the decimals to 2 places. Include a brief written response to each problem, explaining in a sentence or

Using Excel, complete the following problems. Round the decimals to 2 places.
Include a brief written response to each problem, explaining in a sentence or two, the result of your calculation. This can be done in a similar
fashion to how I completed this in the video.
Your company plans to deposit $50,000 into a long-term savings account, with an annual rate of return of 4%. You plan to leave this in the
savings account for 7 years, and use the funds to purchase new computers for your entire company. How much money will your company have
at the end of 7 years?
Your nonprofit organization will receive a donation of $25,000,5 years from now. The current interest rates are 3%. What is the present value
of this future cash flow?
Your parents will retire in 15 years. They currently have $350,000 saved, and they think they will need $1,500,000 at retirement. What annual
interest rate must they earn to reach their goal, assuming they don't save any additional funds?
You have recently found an investment opportunity that will provide a 6.5% annual rate of return. How many years will it take to double your
money?
Your business opens a long-term savings account. You deposit 125,000 for 5 years, with a 2.5% rate of return, compounded quarterly. How
much will you have after 5 years?
You know that you'll need to purchase a new piece of sound equipment in 3 years, with an anticipated cost of $70,000. You have found a
stock that has averaged a 7.5% rate of return. How much do you need to invest today in order to have the $70,000 at the end of year 3?
 Using Excel, complete the following problems. Round the decimals to 2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!