You are planning for retirement 34 years from now. You plan to invest $4,200 per year for the first 7

years, $6,900 per year for the next 11 years, and $14,500 per year for the following 16 years (assume all

cash flows occur at the end of each year). If you believe you will earn an effective annual rate of return of

9.7%, what will your retirement investment be worth 34 years from now?

Answer in Microsoft Excel