Build a retirement planning spreadsheet in stages. a . First, enter parameters for an annual deposit and
Fantastic news! We've Found the answer you've been seeking!
Question:
Build a retirement planning spreadsheet in stages.
a First, enter parameters for an annual deposit and interest rate that will apply over years. Then build the model with 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 years.
c Then build in a goal seek to get to by the end of years in two ways:aChange the amount deposited annually.
Change the interest rate earned.
Please show the excel steps in detail or perform the entire problem. Thank you!
Posted Date: