Please show work in your excel. Thank you very much I really appreciate your help!

3. A professional athlete is in contract negotiations. The team has offered the following salary structure: Year-Payment 0 $7,500,000 4,200,000 5,100,000 5,900,000 6,800,000 5 7,400,000 8,100,000 2 Currently, each year's salary is to be paid as a lump sum at the end of the year. However, the player has asked you, as his agent, to renegotiate the terms. He wants a $9 million signing bonus payable today and a contract value increase of $750,000. He also wants an equal salary paid every three months, with the first paycheck three months from now. A. If the B. What is the present value of the annual payments, assuming quarterly compounding? C. Under the renegotiated terms, how much would the professional athlete receive each quarter? The present interest rate is 7% and compounding is quarterly, what is the effective annual rate? value of the quarterly payments equals the present value of the annual payments, plus the $750,000 contract- increase, minus the $9 million signing bonus