What is their expected combined salary in their last year

Reference no: EM132198506

Question - Martha and Duane Johnson are worried about having enough annual income when they retire. After talking with them, you document the following:

They are both 30 years old.

They both expect to retire in 40 years (at approximately age 70).

Together they currently make $ 125,000 per year.

They agree with the common assumption that, with the expected Social Security payments, they can live quite well after retirement on 80% of their combined salary in their last year of work.

They have no dependents and do not expect to have any.

They currently have no retirement savings account.

Prepare an analysis of their retirement by answering the following questions for the Johnsons. Copy the needed excel calculators from your template to a new file to show your calculations.

1: What is their expected combined salary in their last year of work if inflation averages 2.5% each year? Assume 40 years for the number of periods. What is 80% of that amount?

2: How much would they need in their retirement savings account to provide this target annual income starting at age 70 if they can earn a 6% APR and expect to live 25 years (approximately age 95)? Assume 25 years for the number of periods, ordinary annuity.

3: How much would they need to save annually to reach this amount in their retirement savings account if they can earn 8% APR? What percentage is this annual payment of their current annual income? Assume 40 years for the number of periods, ordinary annuity.

4: They just purchased a lottery ticket. They want to know (if they win) how much they would need to deposit today to reach the retirement savings amount needed at age 70 if they can earn 8% APR? Assume 40 years for the number of periods.

5: If stocks return 10% APR and bonds return 5% APR and they rebalance their portfolio every year, what percentage of their portfolio should be in a well-diversified stock portfolio/fund and what percentage should be in a well-diversified bond portfolio/fund to earn an average return of 8%? Show the formula and each step toward the solution.

Reference no: EM132198506

Questions Cloud

Contractual requirements on order quantities or frequencies : When doing all calculations assume that there are 4 weeks in 1 month and there are no other contractual requirements on order quantities or frequencies.

What are potential ethical issues related to transferring : You have traditionally purchased large rolls of rubber (about 40 inches wide) and slit them into 2" strips for use in your die cutting process.

Project authorization or project initiation document : Projects documents are organized and archived. Project charters are sometimes called a project authorization or project initiation document.

What is the nature of the world around us : Write an 800-1,000-word essay on your personal worldview. Briefly discuss the various possible meanings of the term "spirituality," and your understanding.

What is their expected combined salary in their last year : They are both 30 years old. What is their expected combined salary in their last year of work if inflation averages 2.5% each year

How much arbitrage profit can you make : How much arbitrage profit can you make if you can borrow up to $1 million us dollars? (Assume there is no transaction cost in the money market

Identify three biases that can influence the outcome : Identify three biases that can influence the outcome of an analysis. Explain what they are and how they arise.

Are you for or against globalization : How does this impact pricing? Are you truly helping?" As your team ponders these questions, you start to think about your position on the topic.

Discuss hybrid car facts and their marketing purpose : Describe and discuss Hybrid car facts and their marketing purpose

User Account

All Pages