Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Troy and Tammy are starting to take their retirement planning seriously. They are both 46 and plan to retire in 20 years at the age

Troy and Tammy are starting to take their retirement planning seriously. They are both 46 and plan to retire in 20 years at the age of 66. They expect to live 15 years in retirement (a life expectancy of 81). Between their 401k and IRA accounts they currently have $87,432 in retirement savings. They currently have a combined income of $95,000 per year and expect to be able to live comfortably in retirement 20 years from now with 80% of their current purchasing power. They expect inflation to be 3.0% per year for the rest of their lives. They also expect to earn 11.0% per year (the average return on Blue Chip stocks) on their investments, both now and in retirement. Conduct an analysis of their retirement planning needs and provide them with a professionally written letter. In the letter and attached schedules, provide information that answers the following questions. Please include a description of the relevant assumptions and any explanatory comments that make the results easier to understand. What amount of annual income will they need (after adjusting for inflation) in each of the fifteen years of retirement to have the purchasing power of 80% of their current income? Assuming they will continue to earn 11.0% on their investments, how much money will they need to have in their retirement accounts when they retire so that it will provide the fifteen years of income? (Remember to consider that they will continue to earn interest on their investments during retirement). Taking into account what they currently have in savings, how much will they have to save each month to meet their retirement needs? Sensitivity analysis: Redo the analysis assuming they only earn 9% per year on their investments, instead of 11.0%. Determine the needed amounts so they have the money they need in retirement. Note: Assume that all payments will be made at the end of the period (ordinary annuity). When submitting the letter, please include your Excel file.

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

Handbook For Surviving The Global Financial Crisis

Authors: Barbara Goldsmith

1st Edition

1514811995, 978-1514811993

More Books

Students also viewed these Finance questions

Question

What was Termans contribution to the measurement of intelligence?

Answered: 1 week ago

Question

Define organisation chart

Answered: 1 week ago

Question

What are the advantages of planning ?

Answered: 1 week ago

Question

Explain the factors that determine the degree of decentralisation

Answered: 1 week ago

Question

What Is acidity?

Answered: 1 week ago

Question

Explain the principles of delegation

Answered: 1 week ago

Question

1. Write down two or three of your greatest strengths.

Answered: 1 week ago

Question

What roles have these individuals played in your life?

Answered: 1 week ago

Question

2. Write two or three of your greatest weaknesses.

Answered: 1 week ago