$(7)$ You want to be able to make annual withdrawals of $$100,000$ during your $20-$year retirement period. If you can earn $7\%$ per year, what amount do you need at the beginning of your retirement period? Enter the inputs into the appropriate cells in column B and set this up so that your answers are displayed as positive values.

$(8)$ It's been determined that you need to have $$2$ million by the time you retire. If you can earn $5\%$ per year, how much must you save or invest each year of your $35-$year working life? Enter the values from this question linto the relevant cells in column B and make sure that your answer is displayed as a positive value.

$(9)$ Assume that you have accumulated $$1\mathrm{.}5$ million by the time that you retire and you can earn $6\%$ per year. What size equal annual withdrawals could you make during your retirement just leaving you with a zero balance after $25$ years? Enter the values from this question into the relevant cells in column B and make sure that your answer is displayed as a positive value.

ANNUAL WITHDRAWALS

RETIREMENT PERIOD $($YEARS$)$

RATE $(\%)$

ANSWER #$7$

RETIREMENT TARGET GOAL

RATE

WORKING YEARS

ANSWER #$8$

RETIREMENT NEST EGG

YEARS OF RETIREMENT

RATE $(\%)$

ANSWER #$9$