I just need to know the formula for Excel. For example =PV(rate, pmt,-FV)

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 Amount per year in Option 1 $ 75,000 A Amount per year in Option 2 Signing bonus in Option 2 64,000 20,000 A APR 7% Complete the following analysis. Do not hard code values in your calculations. All answers should be nositive Clipboard Font Styles A1 D E F G H Years for contract Periods per year Amount per year in Option 1 $ 75,000 A Amount per year in Option 2 Signing bonus in Option 2 64,000 20,000 A 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 ... + READY 0 0 0 - + 100%