For Excel Please! Including formulas!

You've just joined the investment banking firm of Dewey, Cheatum, and Howe. They've offered you two different salary arrangements. You can have $75,000 per year for the next two years or you can have $64,000 per year for the next two years along with a $20,000 signing bonus today. The bonus is paid immediately, and the salary is paid in equal amounts at the end of each month. If the interest rate is 7% compounded monthly what is the OV for both the options? Round answers to 2 decimal places.

Years for contract - 2 (D6)

Periods per Year- 12 (D7)

Amount per year for Option 1- $75,000 (D9)

Amount per year for Option 2- $64,000 (D11)

Signing bonus in Option 2- $20,000. (D12)

APR- 7% (D14)

Present Value for Option 1?

Present Value for Option 2 excluding bonus?

Present Value for Option 2 including bonus?