1. Calculate the value of your retirement plan. Future Value of Multiple Annuities Excel) ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri 11 AA 96 M Paste Clipboard BIU G Font Alignment Number Conditional Format as Cell Formatting Table Styles- Cells Editing 2 Styles A1 B 7 5698 v C D E F G Assume that you contribute $330 per month to a retirement plan for 15 years. Then you are able to increase the contribution to $530 per month for the next 25 years. Given an 8 percent interest rate. What is the value of your retirement plan after the 40 years? (Do not round intermediate calculations and round your final answer to 2 decimal places.) Initial monthly contribution Number of years Subsequent monthly contribution 330 15 530 25 8.00% Complete the following analysis. Do not hard code values in your calculations. Value at end of first set of contributions Value at end of second set of contributions 9 10 Number of years 11 Interest rate earned 12 13 14 15 16 17 18 19 20 21 22 Sheet1