(Excel Formulas) Mr. Van Trapp is 30 years old today and has begun to plan for his retirement. He wants to set aside an equal amount at the end of each month in the next 30 years so that he can retire at age 60. He expects to live to a maximum age of 60 and wants to be able to get an after tax payment of $2,500 per month from his account after retirement His retirement account is expected to eam 10% per annum with monthly compounding for the entire period of time. He has 56.000 in his savings account now, and also hopes to have $20,000 left at age 80. Suppose Mr. Van Trapp's company wil deposit $100 into his retirement account each month as well Type in the Excel formulas you should enter in the cells with bold borders in the table below to solve the following problems. Determine the pre-tax payment per month that Mr. Von Trapp needs after retirement, assuming a tax rate of 15%. (2 Points) Determine the amount of funds needed by Mr. Van Trump so that he will be able to get an after-tax payment of $2.500 per month after retirement and have 520.000 left at the end of age 80. (4 Points) Determine the amount of the monthly deposits that must be made by Mr. Van Trapp before he retires. 44 Points) B 1 Mr. Van Trapp's Retirement - Monthly Interest Rate (with monthly compounding) 1096 4 5 After Retirement Monthly Payments after Retirement Tax Rate Pro-tax Payment $2,500 159 6 8 9 20 10 Number of Years in Retirement Amount Left at 80 b. Amount Needed at Age 60 $20,000 11 13 Before Retirement Number of years to Invest 15 Current Savings 16 Company Monthly Deposits 17 e. Monthly Investments Needed 30 $6,000 $100