You are 47 years old today and want to plan for retirement at age 65. You...

You are 47 years old today and want to plan for retirement at age 65. You want to set aside an equal amount every year from now to retirement. You expect to live to age 87 and want to withdraw a fixed amount each year during retirement that at age 65 will have the same purchasing power as $73,868 has today. You plan on withdrawing the money starting the day you retire. You have not saved any money for retirement. Inflation is assumed to be 4.0% in the future. You expect to earn an 8.5% return on your investments in the future. How much do you need to save each year until retirement to meet your goal?

Solutions

Expert Solution

First, we find out how much money we need to have at retirement to satisfy the assumed conditions.

Here, we find the annual requirement considering the inflation factor

Annual requirement = $73,868*(1.04^(Age-47))

Total value required at year 65 = Value of all the future cash-flows discounted at 8.5%

Total Value required at year 65	$2,070,160.35
Age	Annual requirement
65	149643.0144
66	155628.7349
67	161853.8843
68	168328.0397
69	175061.1613
70	182063.6077
71	189346.1521
72	196919.9981
73	204796.7981
74	212988.67
75	221508.2168
76	230368.5455
77	239583.2873
78	249166.6188
79	259133.2835
80	269498.6149
81	280278.5594
82	291489.7018
83	303149.2899
84	315275.2615
85	327886.272
86	341001.7228
87	354641.7917

Now, we have the future value required after 18 years (65-47) = $2070160.35

This is the future value at age 65 of the annual savings

We need to find annual installment to achieve this FV

We use PMT function in excel

PV = .0

FV = 2070160.35

N = 18

I/Y = 0.085

We get PMT = $52645.03

Hence, $52645.03 is the amount you need to save each year until retirement to meet your goal

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

You are 40 years old today and want to plan for retirement at age 65. You...

You are 40 years old today and want to plan for retirement at age 65. You want to set aside an equal amount every year from now to retirement. You expect to live to age 95 and want to withdraw a fixed amount each year during retirement that at age 65 will have the same purchasing power as $70,000 has today. You plan on withdrawing the money starting the day you retire. You have $15,000 saved for retirement today. Inflation...

You are 30 years old and want to retire at the age of age 65 and...

You are 30 years old and want to retire at the age of age 65 and expect to live another 25 years. On the day you retire, you want to have $900,000 in your retirement savings account. a) If you invest monthly starting one month from today and your investment earns 6.0 percent per year, How much money do you need to invest every month until you retire? b) You're retired with $900,000 and you have 25 more years. You...

1. You are now 50 years old and plan to retire at age 65. You currently...

1. You are now 50 years old and plan to retire at age 65. You currently have a stock portfolio worth $150,000, a 401(k) retirement plan worth $250,000, and a money market account worth $50,000. Your stock portfolio is expected to provide annual returns of 12 percent, your 401(k) investment will earn 9.5 percent annually, and the money market account earns 5.25 percent, compounded monthly. (12 points) a. If you do not save another penny, what will be the total...

Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40 years until retirement at age 65.

Consider a person who begins contributing to a retirement plan at age 25 and contributes for 40 years until retirement at age 65. For the first 10 years, she contributes $3,000 per year. She increases the contribution rate to $5,000 per year in years 11 through 20. This is followed by increases to $10,000 per year in years 21 through 30 and to $15,000 per year for the last ten years. This money earns a 9 percent return.First compute the...

You are 30 years old today. You wish to retire at age 65. How much money...

You are 30 years old today. You wish to retire at age 65. How much money must you deposit at the end of each year so that when you retire at age 65, you will be able to withdraw $2,500 at the end of each month until age 85? Assume you can earn interest at the rate of 5.5% compounded daily during the entire period from age 30 to 85.

You are 30 years old today. You wish to retire at age 65. How much money...

You are 40 years old and want to retire at age 65. Each year, starting one...

You are 40 years old and want to retire at age 65. Each year, starting one year from now, you will deposit an equal amount into an investment account that pays 4% interest. The last deposit will be on your 65th birthday. On your 65th birthday, you will switch the accumulated savings into a safer bank account that pays only 4.2% interest. You will withdraw your annual income of $110,000 at the end of that year (on your 66th birthday)...

Jack and Jill are 41 years old and plan on retiring at age 65 and expect...

Jack and Jill are 41 years old and plan on retiring at age 65 and expect to live until age 95. Theycurrently earn $200,000 and expect to need $100,000 in retirement. They also expect that SocialSecurity will provide $24,000 of benefits in today’s dollars at age 65. They are saving $20,000 each intheir 401(k) plans and IRAs. Their son, Parker, is expected to go to college in 10 years. They want tosave for Parker’s college education, which they expect will...

Assume you are now 25 years old. You plan to retire when you are 65 years...

Assume you are now 25 years old. You plan to retire when you are 65 years old. You think you will live until you are 80 years. a.) If the rate of return during your working years (a.k.a. the "savings period") is 8% and you plan to save $2,000 per year, how much will you have saved up by retirement age? b.) If the rate of return during your retirement is 6% on the amount of savings you have accumulated,...

You are 30 years old today and planning to retire at age 62. You want to plan your finances for living 35 years past age 62 and die dead broke. You determine you will need $3000 per month from age 62 for the 35 years.

You are 30 years old today and planning to retire at age 62. You want to plan your finances for living 35 years past age 62 and die dead broke. You determine you will need $3000 per month from age 62 for the 35 years.Your plan is to go live in the tropics, on the beach, and live on coconuts and fishing. Also, you need to conclude your retirement savings at age 55 because all your spare money then will...

Subjects