please include excel functions!

Font Styles B1 so D 2 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? 5 7 2 12 Years for contract Periods per year Amount per year in Option 1 Amount per year in Option 2 Signing bonus in Option 2 $ 9 10 11 12 13 14 75,000 $ S 64,000 20,000 APR 7% 15 16 17 18 19 20 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. Present value of Option 1 Present value of Option 2 Excluding bonus Including bonus 21 22 23 24 26 Sheeti