I have $300,000 in the bank now. I plan to withdraw $25,000 at the end of this year. Each

subsequent end of year withdrawal will increase by 4%. If I earn 8% per year on my investments

in each of the first 4 years, then 6% per year in each of the next 3 years, and 4% per year in each

of the following 2 years, (USE EXCEL AND SHOW ALL FORMULAS USED)

A. Determine the initial withdrawal amount at the end of this year that will leave me with

no money at the end of 9 years using either Solver or Goal Seek

...If you use Goal Seek to determine an answer, please identify the

i. Set Cell

ii. To Value

iii. By Changing Cell

...If you use Solver to determine an answer, please identify the

i. Set Objective (Cell)

ii. To Value

iii. By Changing Variables Cell

iv. Subject to (if used)