Required: a-1. With a 3.0% inflation rate (Spreadsheet 21.2 ), by how much would your retirement annuity grow if you increase the savings rate by 1.5% ? (Round your percentage answer to 2 decimal places.) a-2. Is the benefit greater in the face of inflation? Yes No \begin{tabular}{|c|c|c|c|c|c|c|} \hline= & A & B & C & D & E & F \\ \hline 1 & Retirement Years & Income Growth & Rate of Inflation & Savings Rate & ROR & rROR \\ \hline 2 & 25 & 0.07 & 0.03 & 0.15 & 0.06 & 0.0291 \\ \hline 3 & Age & Income & Deflator & Saving & Cumulative Savings & rConsumption \\ \hline 4 & 30 & 50,000 & 1.00 & 7,500 & 7,500 & 42,500 \\ \hline 5 & 31 & 53,500 & 1.03 & 8,025 & 15,975 & 34,150 \\ \hline 9 & 35 & 70,128 & 1.16 & 10,519 & 61,658 & 51.419 \\ \hline 19 & 45 & 137,952 & 1.56 & 20,693 & 308,859 & 75,264 \\ \hline 29 & 55 & 271,372 & 2.09 & 40,706 & 943,477 & 110.167 \\ \hline 39 & 65 & 533,829 & 2.81 & 80,074 & 2,457,518 & 161.257 \\ \hline 40 & Total & 7,445,673 & & 1,116,851 & Real Annuity & 49,668 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|} \hline & A & B & C & D & E & F \\ \hline 1 & Retirement Years & Income Growth & Rate of Inflation & Savings Rate & ROR & rROR \\ \hline 2 & 25 & 0.07 & 0.03 & 0.15 & 0.06 & (E2C2)(1+C2) \\ \hline 3 & Age & Income & Deflator & Savings: & Cumulative Savings & rConsumption \\ \hline 4 & 30 & 50000 & 1 & B45D52 & -104 & =(B4D4)/CA \\ \hline 5 & 31 & 134(1+5BS2) & =C4(1+SCS2) & B551052 & E(1+5E22)+DS & (B5D5)/C5 \\ \hline 39 & 65 & B38(1+5452) & C38(1+5CS2) & B39 SDS2 & E38(1+ SE 52)+ D39 & (B39D39)/C39 \\ \hline 40 & Total & -SUM(B4:B39) & & = SUM(D4:D39) & Real Annuity & \begin{tabular}{l} = PMT(SFS2,SAS2,- \\ S1SS39/SCS39,0,0) \end{tabular} \\ \hline \end{tabular}