Use Excel to solve the following questions. Please show the Excel functions you use.

1. XYZ companys current years net income is $10 million, which is expected to grow at a 3% per year. If the discount rate is 10%, what is the present value of XYZs future net income?

2. You are 20 years old now and you plan to retire after 40 years when you are 60 years old. After you retire, you need $50,000 at beginning of each year until you die. Suppose you will die at the age of 80. In order to cover the living expenses, you want to save certain amount of money at the end of each year from now until you retire. Assuming 10% interest, how much do you have to save annually?