With a 3.0% inflation (Spreadsheet 21.2), by how much would your retirement annuity grow if you increase the savings rate by 1.2%?

SPREADSHEET 21.2 A real retirement plan e cel Please visit us at www.mhhe.com/bkmm ROR 0291 1 Retirement Years Income Growth Rate of Inflation Savings Rate ROR 07 Income 15 Savin Deflator Cumulative SavingsrConsumption 50,000 53,500 70,128 137,952 271,372 533,829 7,445,673 1.00 1.03 1.16 1.56 2.09 2.81 8,025 10,519 20,693 40,706 80,074 1,116,851 7,500 15,975 61,658 308,859 943,477 2,457,518 44,150 51,419 75,264 110,167 161,257 49,668 31 19 45 39 40 Total Real Annuit 1Retirement Years Income Growth Rate of Inflation Savings Rate ROR ROR 07 03 15 Savin (E2-C2V(1+C2 rConsumption 25 30 31 65 Total 50000 -D4 E4 (1+$E$2)+D5(B5-D5VC5 E38 (1+$ -(B4-D4/C4 B4 (1+$B$2)C4 (1+$C$2)B5*$D$2 39 =(B39-D39)/C39 PMT(SF$2,SA$2,-SE$39/SC$39,0,0 +D39 SUM( B4:B39 SUMOD4:D39 Real Annult