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 FORMULAS USED)

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

In goal seek on excel please identify the..

i. Set Objective (Cell)

ii. To Value

iii. By Changing Variables Cell

iv. Subject to (if used)