could i please get the answer in excel formula because rhe program is marking wrong the excel formula that I am using

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 percent compounded monthly which do you prefer? Years for contract Periods per year 2 12 Amount per year in Option 1 $ 75,000 Amount per year in Option 2 Signing bonus in Option 2 64,000 20,000 $ APR 7% Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Present value of Option 1 --pv(D1+27.06-DI-D9/07,0,0)*1 Present value of Option 2 Excluding bonus --pv(D14/07,D6*D7.-D11/07,0,0)-1 Including bonus $ 139,120.53 Chant