Please show work in an excel file.

Question 1:

• If you want your retirement saving be large enough to allow you to withdraw $80,000 at the beginning of each year for 30 year, with 5% annual compounding interest rate, how much saving do you need to have on the day your retire? Rounded your answer to two decimalswithoutthousand separators and $.

Question 2:

• Your answer to the previous is your financial goal. If you can contribute a constant amount to your investment account and are able to earn 8% on your investment each year for 35 years, how much do you need to contribute to your retirement account at the end of each year to achieve the financial goal? Round your answer to two decimals without thousand separator and $ sign.

Question 3:

• Mary is going to law school in a year. The first year tuition $80,675 is due a year from now. The second and third tuition is $85,300 and$90,225, respectively. Assuming the discount rate is 4%
• What is the total cost in terms of present value?Do not include thousand separator and $.

Question 4:

• Which Excel function can allow you to calculate the implied interest rate on a financial asset that is tied to a stream of non-constant payments?