Your 21 year old client just graduated from college and started a job with monthly salary of $5,000 per month. He wants to retire when he is 60 years old and wants to start saving for retirement right away. We cannot be sure of how long we live after retirement, but the client wants to be extra careful and save for 30 years of after retirement life. Market expectation for average annual inflation for the future is 1.7% (Let’s assume inflation to be 0 after retirement period). Because of inflation, he will need substantially higher retirement monthly income to maintain the same purchasing power. He plans to purchase a lifetime annuity from an insurance company one month before he retires, where the retirement annuity will begin in exactly 39 years (468 months). The insurance company will add a 2.00 percent premium to the pure premium cost of the purchase price of the annuity. The pure premium is an actuarial cost of his anticipated lifetime annuity. He has just learned the concept of time value of money and never saved anything earlier. He will make the first payment in a month from now and the last payment one month before he retires (a total of 467 monthly payments).

1) Given a rate of return of 4% for the foreseeable future, how much does he need to save each month until the month before he retires?

2) He also wants to take big vacation as soon as he retires. He is anticipating that he will need $50,000 for that (at the end of 467 months of saving). How much should he save every month?

3) What are the non-quantifiable factors (list 5) that he should be aware of. Explain each point.

For example (do not include this as one of your answer): We are assuming the inflation rate is 0 after the retirement. If the actual inflation after retirement is not 0, then the client would need more money in the later years during retirement to maintain the same purchasing power. Which means he did not save enough.

Please show work in excel and explain how you found the answer