Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need to find the value of the investment at each five year interval using formulas that reference the % return. I can't get the

image text in transcribed

image text in transcribedI need to find the value of the investment at each five year interval using formulas that reference the % return. I can't get the value of the investment at each five year increment. Format the solution like this in an Excel sheet please.

2. a. Create a chart showing the $5000 annual investment; # Periods, Age of the Investor, 7% Return, 8% Return, 9% Return and 10% Return. Place the rates of return to the right side of the data and use cell references to them (show all of these values in a table along with the graph from part 2b on 1 page). b. Create a chart showing time on the X-axis and Future Value on the Y-axis for each of the returns, 7%,8%,9% and 10%. \begin{tabular}{|c|c|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F & G & H \\ \hline 1 & Investment & Period & Age & 7% Return & 8% Return & 9% Return & 10% Return & Return \\ \hline 2 & $5,000.00 & 1 & 25 & $5,350.00 & $5,400.00 & $5,450.00 & $5,500.00 & 7% \\ \hline 3 & $5,000.00 & 5 & 30 & & & & & 8% \\ \hline 4 & $5,000.00 & 10 & 35 & & & & & 9% \\ \hline 5 & $5,000.00 & 15 & 40 & & & & & 10% \\ \hline 6 & $5,000.00 & 20 & 45 & & & & & \\ \hline 7 & $5,000.00 & 25 & 50 & & & & & \\ \hline 8 & $5,000.00 & 30 & 55 & & & & & \\ \hline 9 & $5,000.00 & 35 & 60 & & & & & \\ \hline 10 & $5,000.00 & 40 & 65 & & & & & \\ \hline 11 & $5,000.00 & 45 & 70 & & & & & \\ \hline 12 & $5,000.00 & 50 & 75 & & & & & \\ \hline 13 & & & & & & & & \\ \hline \end{tabular}

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

Legal Handbook For Financial Planning In 2019

Authors: Allen Buckley

1st Edition

1091578826, 978-1091578821

More Books

Students also viewed these Finance questions

Question

Describe four issues that affect career management

Answered: 1 week ago

Question

=+c) Find the standard deviation of the net revenue.

Answered: 1 week ago

Question

What is the relationship between humans?

Answered: 1 week ago

Question

What is the orientation toward time?

Answered: 1 week ago