With no taxes or Inflation (Spreadsheet 211), what would be your retirement annuity if you Increase the savings rate by 2.5%? Retirement annuity E T- 1 Retirement Years Income Growth 2 25 .07 3 Age Income 4 30 50,000 5 31 53,500 9 35 70,128 19 45 137,952 29 55 271,372 39 65 533,8291 40 Total 7.445,673 C Savings Rate .15 Savings 7,500 8,025 10,519 20,693 40,706 80,074 1,116,851 D ROR .06 Cumulative Savings 7,500 15,975 61,658 308,859 943,477 2.457 518 Recimomannuity Consumption 42,500 45,475 59,608 117 259 230,666 453 755 192.244 1 2 3 A Retirement Years 25 Age 30 31 65 Total Income Growth 07 Income 50000 =B4*(1+$B$2) EB38*(1+$B$2) =SUM(B4:B39) 4 D E ROR .06 Cumulative Savings Consumption E04 -B4-04 ED4"(14$D$2)405 EB5-65 =D38*(1+$D$24639 EB39 C39 Retirement An EPMT($D$2,SA$2:$D$39,0,0) Savings Rate 115 Savings EB4"$C$2 =B5 $C$2 =B39"$C$2 ESUMC4:C39) 5 39 40