as a All answers must be entered formula. Click OK to begin. OK C5 Excel Saved A B D E F G H 7 3 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? 15 points 4 eBook 5 6 Print Years for contract Periods per year 2. 12 7 References D 00 Amount per year in Option 1 $ 75,000 10 11 Amount per year in Option 2 Signing bonus in Option 2 $ $ 64,000 20,000 12 13 14 APR 7% 15 16 17 Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. 18 18 19 Present value of Option 1 20 21 Present value of Option 2 Excluding bonus 22 23 24 Including bonus 25 26 27 28 Sheet1 READY + 100%