0-1. With a 3.0% inflation rate (Spreadsheet 212), by how much would your retirement annuity grow if you increase the savings rate by 0.8%? (Round your answer to 2 decimal places.) Growth in retirement annuity 52.98% 7,500 C D 1 Retirement Years Income Growth Rate of Inflation Savings Rate E 2 25 ROR TROR .07 .03 15 06 3 Income 0291 Deflator Saving 4 30 Cumulative Savings 50,000 Consumption 1.00 5 7,500 31 42,500 53,500 1.03 9 8,025 35 15,975 70,128 44,150 1.16 10,519 19 45 61,658 51,419 137,952 1.56 20,693 308,859 29 75,264 55 271,372 2.09 40,706 943,477 39 110.167 65 533,829 2.81 80,074 2,457,518 40 161.257 Total 7,445,6731 1,116,851 Roal Annuity 49.668 Bla8a82828 .07 1 2 3 4 5 Retirement Years 25 Age 30 31 65 Total B D E F Income Growth Rate of Inflation Savings Rate ROR TROR .03 .15 .06 E2-C21.02) Income Deflator Savings Cumulativo Savings Consumption 50000 1 B4'$D$2 D4 (B4-D4C4 -B4(1+$B$2) -C414$C$ 2B5 SDS2 E4R1+$E2)+D5 (B5-D5YC5 -B381+$B$2) C38*(1+$C$2) B39$D$2 E38*(1.SE$2.039 (B39-0397C30 ESUM B4:B39) SUM(D4:39 Real Annuity EPMT (SFS2.SAS2. SE$39/SCS39.0.0) 39 40 0-1. With a 3.0% inflation rate (Spreadsheet 212), by how much would your retirement annuity grow if you increase the savings rate by 0.8%? (Round your answer to 2 decimal places.) Growth in retirement annuity 52.98% 7,500 C D 1 Retirement Years Income Growth Rate of Inflation Savings Rate E 2 25 ROR TROR .07 .03 15 06 3 Income 0291 Deflator Saving 4 30 Cumulative Savings 50,000 Consumption 1.00 5 7,500 31 42,500 53,500 1.03 9 8,025 35 15,975 70,128 44,150 1.16 10,519 19 45 61,658 51,419 137,952 1.56 20,693 308,859 29 75,264 55 271,372 2.09 40,706 943,477 39 110.167 65 533,829 2.81 80,074 2,457,518 40 161.257 Total 7,445,6731 1,116,851 Roal Annuity 49.668 Bla8a82828 .07 1 2 3 4 5 Retirement Years 25 Age 30 31 65 Total B D E F Income Growth Rate of Inflation Savings Rate ROR TROR .03 .15 .06 E2-C21.02) Income Deflator Savings Cumulativo Savings Consumption 50000 1 B4'$D$2 D4 (B4-D4C4 -B4(1+$B$2) -C414$C$ 2B5 SDS2 E4R1+$E2)+D5 (B5-D5YC5 -B381+$B$2) C38*(1+$C$2) B39$D$2 E38*(1.SE$2.039 (B39-0397C30 ESUM B4:B39) SUM(D4:39 Real Annuity EPMT (SFS2.SAS2. SE$39/SCS39.0.0) 39 40