Starting to take retirement planning

Assignment Help Financial Management

Reference no: EM131979527

Barry and Samantha Harris – Retirement Savings

You must work on your own spreadsheet with Excel skills or concepts.

Barry and Samantha are starting to take their retirement planning seriously. They are both 45 and plan to retire in 20 years at the age of 65. They expect to live 15 years in retirement (a life expectancy of 80). Between their 401k accounts they currently have $66,000 in retirement savings.

They currently have a combined income of $80,000 per year and expect to be able to live comfortably in retirement with 80% of their current purchasing power. They expect inflation to be 2% per year for the rest of their lives. They also expect to earn an averaged 11% per year on their investments, both now and in retirement.

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% 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?

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 that they only earn 8% per year on their investments, instead of 11%. 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).

Reference no: EM131979527

Questions Cloud

What is fixed factory overhead spending variance in december : What is the total factory overhead flexible-budget variance for Gerhan Company in May? What is the fixed factory overhead spending variance in December

Calculate the change in gdp : Calculate the change in GDP and Suppose that exports fall by $150 billion with an MPC of .7. Calculate the change in GDP.

What is the allocated cost of the sold items : If 1,096 pounds of tails and 324 pounds of flakes are sold, what is (1) the allocated cost of the sold items and (2) the allocated cost of the ending inventory

Central predictions of the median voter theorem : Should any of the assumptions that give rise to that theorem be modified in order to make it more realistic?

Starting to take retirement planning : Barry and Samantha Harris–Retirement Savings. Barry and Samantha are starting to take their retirement planning seriously.

What selling price per unit will this company require : Sam Company has just received a special, one-time order for 1,000 units. What selling price per unit will this company require to earn $3,000 on the order

Can workers be both capital resources and human resources : Can workers be both capital resources and human resources? (can you provide an example with your explanations).

Considering investing in project with the cash flows : Suppose your firm is considering investing in a project with the cash flows shown below,

What is the amount of capp co owner equity : The total assets of Capp Co. are $600,000 and its liabilities are equal to two-thirds of its total assets. What is the amount of Capp Co.'s owner's equity

User Account

All Pages