How do you get these answers with Excel formulas?

Show me how to do it with EXCEL

You just won the $40 million lottery. You will receive $1.4 million a year for the next 20 years plus an additional payment of $12 million at the end of 20 years. The interest rate is 11 percent. How much is your lottery prize worth today? (Enter your answer as a positive number rounded to 2 decimal places.) You need to have $24,856 available at the end of 9 years. How much to do you have invest each year, starting at the end of this year, for 9 years to achieve this goal if the interest rate is 10\%? (Enter your answer as a positive number rounded to 2 decimal places.)