4. Sensitivity Analysis Use the following information to answer parts A-D below. (Using excel may help on certain parts, but please also show written work when you can. If you do use excel for certain parts, please show formulas/steps as well). A three-year project requires an initial investment (i.e., at t=0) in equipment of $100,000. At t=3, the company plans to sell the equipment for $10,000. The equipment can be depreciated according to the three year schedule, which allows depreciation of 33.33% at t=1, 44.45% at t=2, 14.81% at t=3, and 7.41% at t=4. Depreciation will be based solely on the initial cost of the equipment (i.e., when calculating depreciation, ignore any salvage value). This project is expected to produce sales revenue of $400,000 per year for each of the three years of the project (i.e., sales revenue will be $400,000 for t=1, t=2, and t=3). Manufacturing costs are estimated to be $300,000 per year. The corporate tax rate is 35%. The company's tax situation is such that it can make use of all applicable tax shields and deductions. The opportunity cost of capital is 20%. a. Calculate the Net Present Value (NPV) of the project. b. How will the project NPV change if the revenue is 20% higher than estimated? How will the project NPV change if the revenue is 20% lower than estimated? C. How will the project NPV change if the manufacturing costs are 10% higher than estimated? How will the project NPV change if the manufacturing costs are 10% lower than estimated? d. Based on your answers to parts A-C, prepare a sensitivity table for this project.is the project decision to accept or reject more sensitive to the revenue estimate or to the cost estimate