Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Required: a-1. With a 3.0% inflation rate (Spreadsheet 21.2 ), by how much would your retirement annulty grow if you increase the savings rate by

image text in transcribed
image text in transcribed
Required: a-1. With a 3.0% inflation rate (Spreadsheet 21.2 ), by how much would your retirement annulty grow if you increase the savings rate by 1.19 ? (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 & 44,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 & =(B2C2)/(1+C2) \\ \hline 3 & Age & Income & Deflator & Savings & Cumulative Savings & rConsumption \\ \hline 4 & 30 & 50000 & 1 & =B4SD52 & =D4 & =(B4D4)/C4 \\ \hline 5 & 31 & =B4(1+$B$2) & =C4(1+$CS2) & =B5 SD $2 & =E4(1+SES2)+DS & =(B5D5)/C5 \\ \hline 39 & 65 & =B38(1+ SB $2) & =C38(1+5Cs2) & =B39SD$2 & = E 38(1+ SES 2)+ D 39 & =(B39D39)/C39 \\ \hline 40 & Total & =SUM(B4:B39) & & =SUM(D4:D39) & Real Annuity & \begin{tabular}{l} =PMT($F$2,$A$2, \\ $E$39/$C$39,0,0) \end{tabular} \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

School Finance A Policy Perspective

Authors: Allan Odden, Lawrence Picus

6th Edition

1259922316, 9781259922312

More Books

Students also viewed these Finance questions

Question

What is a verb?

Answered: 1 week ago