Please solve both questions! Please show work in Excel and do not hard code the values in the calculations! Thank you :)

B D E F H 1 Question 18 (2 points) 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 salry is paid in equal amounts at the end of each month. If the interest rate is 7 percent compounded monthly, which do you prefer? 2 3 4 5 Complete your analysis setting up the spread sheet. Do not hard code values in your calculations All answers should be positive. 6 7 8 9 10 11 Question 16 (2 points) Investment X offers to pay you $4,700 per year for eight years, whereas Investment Y offers to pay you 56,700 per year for five years. Which of these cash flow streams has the higher present value if the discount rate is 5 percent? If the discount rate is 15 percent? Complete your analysis setting up the spread sheet. Do not hard code values in your calculations. All answers should be positive