Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Pat is the type to plan everything in advance, and she is already starting to plan for retirement. She plans to work for 40 years,

Pat is the type to plan everything in advance, and she is already starting to plan for retirement. She plans to work for 40 years, and then retire for the following 30 years. She expects to spend $120,000 in your first year of retirement, with a 4% growth rate. She will increase her working-years savings rate by 7.5% per year. While working, she expects her account will have a 6.75% return, and during retirement, it will have a 4.75% return. After the 30th year of retirement (end of Year 70), she wants to have $600,000 in her account for safety net and bequest reasons (It is fine if the amount is not exactly $600,000 due to rounding error).

To solve the problem, determine how much Pat needs to save in year 1 to accomplish her retirement goals (use Solver or Goal Seek).

Money that needed to save in Year 1
Spending in Year 41 $120,000.00
Growth rate of spending during retirement 4%
Work year saving rate 7.50%
Investment return during work years 6.75%
Investment return during retirement years 4.75%
Ending balance at year 70 $600,000.00

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

Personal Finance Terms Financial Education Is Your Best Investment

Authors: Thomas Herold

1st Edition

1090822871, 978-1090822871

More Books

Students also viewed these Finance questions

Question

6. How can physical activity be used to manage ADHD and ASD?

Answered: 1 week ago

Question

I am paid fairly for the work I do.

Answered: 1 week ago

Question

I receive the training I need to do my job well.

Answered: 1 week ago