Using the accompanying Retirement$\_$Calculator spreadsheet model, Claire wants to use Scenario Manager to compare the following

retirement saving scenarios:

Click here for the Excel Data File

a$.$ Which scenario generates the highest retirement savings at the end of $10$ years? What is the amount?

Note: Round "Amount" to $2$ decimal places.

b$.$ Which scenario generates the lowest retirement savings at the end of $20$ years? What is the amount?

Note: Round "Amount" to $2$ decimal places.

c$.$ Which scenario generates the second highest retirement savings at the end of $30$ years? What is the amount?

Note: Round "Amount" to $2$ decimal places.

d$.$ For $5$ cenario $4,$ if Caire would the to have $$1$ milian at the end of $30$ years, what would her saving rate need to be$?$ How about at$,$

the end of $20$ years?

Note: Round your answers to $2$ decimhl places.

Savings rave an end of $30$ yeass