IN EXCEL (SHOW FUNCTION)

Question 2: John is 40 years old today (this is time 0). He is hoping to retire at age 65 (exactly on his 65th birthday) and actuarial tables suggest that he is likely to live until the age of 85. He wants to move to a Caribbean Island when he retires at age 65 (on his 65th birthday). He estimates that it will cost him $50,000 to make the move on his 65th birthday. Starting on his 65th birthday and ending on his 84th birthday (all withdrawals are at the beginning of the year), he will withdraw $40,000 per year for annual living expenses. Assume interest rate to be 5.5% for all calculations.

Use the timeline method to solve this question. (16) What is the total amount required on the 65th birthday so that this amount can be used to make all the expenditures in retirement?