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

Scenario Starting salary Increase rate Saving rate Return rate

$1$ $ $56,8002\%15\%7\%$

$2$ $ $71,8002\%10\%7\%$

$3$ $ $69,8003\%15\%7\%$

$4$ $ $73,8003\%10\%7\%$

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?Retirement Calculator

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

d$.$ For Scenario $4,$ if Claire would like to have $$1$ million 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$ decimal places.