With no taxes or inflation (Spreadsheet 21.1), what would be your retirement annuity if you Increase the savings rate by 0.5%?

SPREADSHEET 21.1 The savings plan excel Please visit us at www.mhhe.com/bkm 1 Retirement Years Income Growth 12 25 .07 3 Age Income 30 50.000 5 31 53.500 9 35 70,128 19 45 137052 29 55 271.372 39 85 533.829 40 Total 7,445,573 D Savings Rate FOR .15 .06 Savings Cumulative Savings Consumption 7,500 7,500 42,500 8,025 15,975 45,475 10,519 61,658 59,608 20,693 308,850 117,259 40,706 9443,477 230.000 80,074 2,457,518|| 453, 755 1,116.851 Petirement Annuity 192,244 A D 1 Retirement Years Income Growth Savings Rate ROR 2 25 .07 He .15 06 3 Age Income Savings Cumulative Savings Consumption 4 30 150000 B4 SC32 -C4 B4-C4 5 31 =B4*(1+$B$9) -B5-$C$2 15041+$D$2)+C5 B5C5 99 65 EB38" (1490821 TEB39"$CS2 1038"(148082)+C30 1330-C39 40 Total 1-SUM(B4:B39) SUM(C4:C39) Retirement Annuity EPMT($D$2:$A$2,-90330,0,0) Te to search O 0 1x = ENG 4:57 PM 10/10/2020 SPREADSHEET 21.1 The savings plan excel Please visit us at www.mhhe.com/bkm 1 Retirement Years Income Growth 12 25 .07 3 Age Income 30 50.000 5 31 53.500 9 35 70,128 19 45 137052 29 55 271.372 39 85 533.829 40 Total 7,445,573 D Savings Rate FOR .15 .06 Savings Cumulative Savings Consumption 7,500 7,500 42,500 8,025 15,975 45,475 10,519 61,658 59,608 20,693 308,850 117,259 40,706 9443,477 230.000 80,074 2,457,518|| 453, 755 1,116.851 Petirement Annuity 192,244 A D 1 Retirement Years Income Growth Savings Rate ROR 2 25 .07 He .15 06 3 Age Income Savings Cumulative Savings Consumption 4 30 150000 B4 SC32 -C4 B4-C4 5 31 =B4*(1+$B$9) -B5-$C$2 15041+$D$2)+C5 B5C5 99 65 EB38" (1490821 TEB39"$CS2 1038"(148082)+C30 1330-C39 40 Total 1-SUM(B4:B39) SUM(C4:C39) Retirement Annuity EPMT($D$2:$A$2,-90330,0,0) Te to search O 0 1x = ENG 4:57 PM 10/10/2020