Today is your 40th birthday (this is beginning of period, i.e., time 0). You expect to retire at age 65 and actuarial tables suggest that you will live to be 85. You want to move to Hawaii when you retire (on your 65th birthday). You estimate that it will cost you $50,000 to make the move on your 65th birthday. Starting on your 65th birthday and ending on your 84th birthday (all withdrawals are at the beginning of the year), you will withdraw $40,000 for annual living expenses. Assume the interest rate is 4%. a. How much will you need to have saved by your retirement date? Use the timeline method to solve this. (Hint: the present value, on your 65th birthday, of those costs. Cost at time 65 should include $50,000 besides the annual cost of $40,000.) b. What is your savings calculated in (1) worth today? (Hint: Find the present value of the amount you will need at age 65. c. You start saving for this goal today till your 65th birthday. How much would you need to save each year? (Hint: Need to find the future value of an annuity when the payment starts at the beginning of the year.)

Please use excel and show all formulas