Your 23 years 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% (Lets 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 37 years (444 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 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 443 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 443 months of saving). How much should he save every month?
3. Starting from 1) again, you anticipate a gift $20,000 in 10 years from now. In that case, how much do you need to save every month?
4. Starting from 1) again, if he decides to save $200 more every month (compared to the answer in number 1), how much can he receive as the first month retirement income?
5. What are the non-quantifiable factors (list 4) that he should be aware of? Please write full sentences, how will it affect the savings plan?

Please post the calculations from each part and screenshot how do I do them in excel.

Thank you