Saved Comparing cash flow streams - Excel ? 6 HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign Arial - 12 -A % BIU- Cells Editing Font A. Alignment Number Conditional Format as Cell Formatting Table Styles Styles fx X B D E F G - 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 Sheet1 . 2/2 100% Hint Saved Comparing cash flow streams - Excel ? HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Arial - 12 -A BIU- 88 - % Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Font v X > B c D E F H - Periods per year 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 Present value of Option 2 Excluding bonus Including bonus Sheet1 2/2 + 100% Hint Please write the specific steps