1. An employee plans to invest $50,000 per year in a retirement fund at the beginning of each of the next 10 years. The employee believes she will earn 14% on her investments in each of the first 3 years and 7% in each of the final 7 years before she retires.
   1. How much money will the employee have in the retirement fund at the end of 10 years?
   2. What would be the internal rate of return associated with her investments and her final retirement position?
   3. Using Solver or Goal Seek determine the annual investment amount that would result in a retirement fund of $1,200,000 at the end of 10 years?