What savings rate from real income (Soreadsheet 213) will produce the same retirement annuity as a 15% Savings rate from nominal income? (Round your answer to 1 decimal place.) Savings rate SPREADSHEET 21.3 Backloading the real savings plan Rotiromont Yoars Income Growth Rate of Inflation Savings Rato 07 .03 Age Income Doflator Savings 50,000 1.00 5,000 53,500 1.03 6 ,511 70,1281 . 168 ,130 45 137,952 1 .561 21,492 271,372 2.09 56,819 65 533,829 MEI 2.81 150,212 Total7 ,445,673 LAURA 1,572,466 E ROR TROR 06 .0291 Cumulativo Savings Consumption 5,000 45,000 10,811 46,592 44,35153,480 260,927 74,751 947,114 102,471 2 ,964,669 136,331 Roal Annuity 59,918 TROR .06 A C D Retirement Years Income Growth Rate of inflation Savings Rato ROR 25 07 .03 1 Ago Income Deflator Savings Cumulative Savings 30 50000 11 -B4"04"$D$2 -04 31 -B4 (1+$B$2) C4" 1+$C$2) -B5*C5 $D$ 2 T-E4"(14$E$2)+05 65 -B38" (14$B$2) -C391+$C$2) -839-C39'$D$2 E39 1SE62)+D30 Total SUMB4:B39) ESUM D4:D39) RON Annuity (E2-C2/(1+C2) Consumption =(B4-0404 -(B5-D5y/05 (B39-D30VC30 PMT $F$2.SA$2,-$E$39/$C$39,0,0)