Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

With a 3.0% inflation rate (Spreadsheet 21.2), by how much would your retirement annuity grow if you increase the savings rate by 0.5%? (Round your percentage answer to 2 decimal places.)

SPREADSHEET 21.2

A real retirement plan

A B C D E F
1 Retirement Years Income Growth Rate of Inflation Savings Rate ROR rROR
2 25 0.07 0.03 0.15 0.06 0.0291
3 Age Income Deflator Saving Cumulative Savings rConsumption
4 30 50,000 1.00 7,500 7,500 42,500
5 31 53,500 1.03 8,025 15,975 44,150
9 35 70,128 1.16 10,519 61,658 51,419
19 45 137,952 1.56 20,693 308,859 75,264
29 55 271,372 2.09 40,706 943,477 110,167
39 65 533,829 2.81 80,074 2,457,518 161,257
40 Total 7,445,673 1,116,851 Real Annuity 49,668

A B C D E F
1 Retirement Years Income Growth Rate of Inflation Savings Rate ROR rROR
2 25 0.07 0.03 0.15 0.06 =(E2C2)/(1+C2)
3 Age Income Deflator Savings Cumulative Savings rConsumption
4 30 50000 1 =B4*$D$2 =D4 =(B4D4)/C4
5 31 =B4*(1+$B$2) =C4*(1+$C$2) =B5*$D$2 =E4*(1+$E$2)+D5 =(B5D5)/C5
39 65 =B38*(1+$B$2) =C38*(1+$C$2) =B39*$D$2 =E38*(1+$E$2)+D39 =(B39D39)/C39
40 Total =SUM(B4:B39) =SUM(D4:D39) Real Annuity =PMT($F$2,$A$2,$E$39/$C$39,0,0)

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

Step: 3

blur-text-image

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

ISE Financial Institutions Management A Risk Management Approach

Authors: Anthony Saunders Professor, Marcia Millon Cornett, Otgo Erhemjamts

10th International Edition

1260571475, 9781260571479

More Books

Students also viewed these Finance questions