Please help with this by showing Excel and the function that you use. (step by step)

Problem 2.

An MLB baseball player is offered a five-year contract in the payment schedule as follows:

Year
0	$ 2,000,000.00	(signing bonus)
1	$ 2,500,000.00
2	$ 2,500,000.00
3	$ 3,000,000.00
4	$ 3,000,000.00
5	$ 2,800,000.00

Tabulate the original pay schedule. Assume the interest rate is 8%. What is present value of his contract? Hint: NPV function (10%)

The player wants to see his paycheck increase 5% each year. That is, his Year 1s pay must be 5% higher than his newly designed signing bonus, and Year 2s pay is 5% higher than Year 1s pay and so on. If you are the manager of the team, how should you rearrange his payment schedule that can simultaneously satisfy the players demand and keep the cost of the contract the same, that is, the PV being the same? Tabulate the new payment schedule and compute the PV. (20%)

Note:

You must specify the input data

The output answers must contain Excel functions by referring to the input data, not directly entering numbers to compute the answer.