Proiect_Analysis: Use the following information to answer questions 3 and 4, below (Hint: Using Excel will be helpful): A project requires an initial investment (i.e., at t-0) in equipment of $200,000. At t-3, the project will end and the company plans to sell the equipment for $5,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 n the initial cost of the equipment (i.e. , when calculating depreciation, ignore any salvage value.) This project is expected to produce sales revenue of $300,000 the first year (i.e., at t#1); this revenue will increase by 10% per year over the next two years (i.e., t-2 and t=3). Manufacturing costs are estimated to be 60% of sales. A key marketing study was completed last year; the cost of this study was $50,000 This project requires working capital. Specifically, at each point in time, the working capital required is equal to 20% of the predicted revenue the next year. So, for example, working capital required at t-0 is 20% of $300,000, or $60,000. working capital will be fully recovered at t-3. The corporate tax rate is 358. The company's tax situation is such that it can make use of all applicable tax shields and deductions. The opportunity cost of capital for this project is 10% 3. Calculate the cash flows generated by the project for t-0, t-l, t-2, t-3, and t-4. 4. A. Calculate the Net Present Value of the project B. Keeping all other assumptions the same, what must t=1 Revenue be in order for this project to have a zero NPV? C. Keeping all other assumptions the same, what must t-l Revenue be in order for this project to have zero Profit After Tax at t-1? What is the project' s NPV now