Use Excel to Solve and show me the excel function used.Thank you.

1. Suppose you won the lottery but not all of your winnings will come in one year. Instead, you will get a series of annual payments over the next five years. The table below tells you what your payment will be every year for the next five years. Use the information in the table to make the following computations:

A. The present and future value of your lottery ticket if the interest rate is 8%

B. The present and future value of your lottery ticket if the interest rate is 10%

Year	Payment
1	5000
2	6000
3	7000
4	8000
5	9000