9. An employee plans to invest $40,000 per year in a retirement fund at the beginning of each of the next 12 years. The employee believes she will earn 12% on her investments in each of the first 4 years, 9% in each of the next 4 years, and 6% in each of the final 4 years before she retires.

a. How much money will the employee have in the retirement fund when she retires?

b. What would be the internal rate of return associated with her investments and her final retirement position?

c. Using Solver or Goal Seek determine the annual investment amount that would result in a retirement fund of $1,000,000 at the end of 12 years?