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

Year

$0$ $ $2,000,000\mathrm{.}00($signing bonus$)$

$1$ $ $2,500,000\mathrm{.}00$

$2$ $ $2,500,000\mathrm{.}00$

$3$ $ $3,000,000\mathrm{.}00$

$4$ $ $3,000,000\mathrm{.}00$

$5$ $ $2,800,000\mathrm{.}00$

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

B$.$ The player wants to see his paycheck increase $5\%$ each year. That is$,$ his Year $1$s pay must be $5\%$ higher than his newly designed signing bonus, and Year $2$s pay is $5\%$ higher than Year $1$s pay and so on$.$ If you are the manager of the team, how should you rearrange his payment schedule that can simultaneously satisfy the player$$s 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:

$(1)$ You must specify the input data

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