Question: Build a retirement planning spreadsheet in stages. a . First, enter parameters for an annual deposit and interest rate that will apply over 3 0

Build a retirement planning spreadsheet in stages.
a. First, enter parameters for an annual deposit and interest rate that will apply over 30 years. Then build the model with 30 rows showing the interest earned and balance as of EOY.
b. Next build a data table with multiple annual deposits and multiple possible interest rates to see how things COULD look in 30 years.
c. Then build in a goal seek to get to 1,000,000 by the end of 30 years in two ways:a--Change the amount deposited annually.
-- Change the interest rate earned.
Please show the excel steps **in detail** or perform the entire problem. Thank you!

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!