Can you help with a problem like this. All the work needs to be shown and it can be written.

1

Capital Needs Analysis FIN 536 Retirement Planning Homework Spring 2017

1. $75,000 /year needed during retirement Retirement will last 25 years 30 years until retirement 6.0% return before and after retirement 3.35% inflation rate

Use the present value of an annuity (annuity due) to calculate the lump sum needed at retirement assuming the principal will be liquidated.

Inflate to the amount needed in dollars on the retirement date.

Use the future value of an annuity (ordinary annuity and annuity due) to calculate the required annual savings.

How much must be saved if the principal is not liquidated?

• Calculate the present value of the lump sum needed at retirement for the length of the retirement period and add it to the lump sum needed at retirement.
• Use the new future value to calculate the annual savings (ordinary annuity and annuity due). What if the principal is not liquidated and it is to keep its purchasing power?

Calculate the present value of the lump sum needed at retirement for the length of the retirement period and add it to the lump sum needed at retirement (using the inflation- adjusted rate of return).

Use the new future value to calculate the annual savings (ordinary annuity and annuity due).

2. Your clients, Tom and Melissa Sampson (age50), want to retire when they are 70 and want to provide 30 years of income during retirement. Based on their current level of living, they

would like to provide for $100,000/year (in current dollars) during retirement. They currently have $250,000 in Roth IRAs. Social Security will provide $35,000/year in current dollars. They have made the following rate estimates: 3.25% inflation before and after retirement, 6.0% return on investments before retirement, and 4.0% return on investments after retirement. Assuming they are willing to liquidate the principal during retirement and they will save at the end of the period and withdrawal at the beginning, find:

1. a) How much they will need to save each year toward retirement in order to take annual distributions, and
2. b) How much they will need to save each month in order to take monthly distributions.

3. Using the information in Problem 2, redo the needs analysis for an ordinary annuity and an annuity due assuming Tom and Melissa have a gross need of $120,000/year for 10 years after which their gross needs would decrease to $100,000 for the remainder of their lives.

4. Redo Problem 2 changing the rate of return on investment to 5% before and after retirement and calculate the annual savings needed to make annual distributions using:

1. a) The present and future values, then
2. b) The cash flow calculator.