With no taxes or inflation (Spreadsheet 21.1), what would be your retirement annuity if you decrease the ROR by 0.2% Retirement annuity D ROR Savings Rate Retirement Years Income Growth .07 Income 50,000 53,500 70,128 137,952 271,372 533,829 7,445,673 1 .06 .15 2 25 Consumption 42,500 45,475 Cumulative Savings 7,500 15,975 61,658 308,859 Savings 7,500 8,025 10,519 20,693 40,706 80,074 1,116,851 3 Age 30 4 5 31 59,608 117,259 35 19 45 55 230,666 453,755 192,244 29 943,477 2,457,518 Retirement Annuity 39 65 Total 40 A E Income Growth Retirement Years Savings Rate ROR 1 2 25 .07 Income 50000 B4*(1+$B$2) B38(1+SB$2) SUM(B4:B39) .15 06 Cumulative Savings C4 D4'(14$D$2)+C5 D38 (1+$D$2)+C39 Retirement Annuity =PMT(SD$2,$A$2,-$D$39,0,0) 3 Age Savings B4'$C$2 B5*$C$2 B39 $C$2 -SUM(C4:C39 Consumption B4-C4 85-C5 839-C39 30 5 39 31 65 Total 40