A company is considering investing in a project. This project requires $4,000 in upfront costs (Year O), and then costs of $1,000 in the remaining five years. The project will make no money at first (Year O) and then it will earn $2,000 in revenue in the remaining five years. There are two scenarios for this project. In the first scenario, the company has a yearly interest rate of 8% which is compounded annually. In the second scenario, the company has a yearly interest rate of 5% which compounds monthly 1. Calculate the effective annual interest rate for scenario #2, format your answer to three decimal places, and input it into cell A11 (and highlight this cell yellow). Use this rate (with three decimal places) when filling in the table in this assignment. 2. Fill in the missing values for the below table. Be sure to use the proper formula for calculating present value. Year Costs Revenue Profit Present Value Present Value of Profits of Profits under under Scenario #1 Scenario #2 4000 1000 Total