Can someone show me how to do this question? Detailed steps please (use formulas) Will rate a thumb up for good response, thanks so much!

Keebler Company is operating at full capacity. It can only meet the increased demand for its product by investing in new plant and equipment. It is considering a proposal for an investment of $6.0 million in fixed assets. This would allow the firm to sell 250,000 units per year. The estimated sale price of the each unit is $20, and the variable cost of each additional unit is $10. Insurance, maintenance, license fees and other fixed costs associated with the new assets would amount to $200,000 per year. The fixed assets' useful life is estimated at four (4) years, but their residual value at the end of four years is antipated to be at least $1.0 million. In addition to the investment in fixed assets, the increase in sales would require additional workiing capital in the form of inventory and accounts receivable, partially funded by higher accounts payable. This initial investment in working capital is estimated at 20% of sales. For tax purposes, the new assets fall into the five-year MACRS asset class. The company's tax rate is 20%. The company's required rate of return is 15%. Calculate the NPV and IRR of the project. For IRR, please use the hit and trial method or you can use the Excel formula. Modified Accelerated Cost Recover System (MACRS) Depreciation Rates Applicable to Asset Classes Recovery Year Fifteen- Three-Year Five-Year Seven-Year Ten-Year Year Asset Class Asset Class Asset Class Asset Class Asset Class 1 2 2. 3 4 0.3333 0.4445 0.1481 0.0741 3 4 5 0.2000 0.3200 0.1920 0.1152 0.1152 0.0576 0.1429 0.2449 0.1749 0.1249 0.0893 0.0892 0.0893 0.0446 6 7 8 9 10 11 12 0.1000 0.1800 0.1440 0.1152 0.0922 0.0737 0.0655 0.0655 0.0656 0.0655 0.0328 0.0500 0.0950 0.0855 0.0770 0.0693 0.0623 0.0590 0.0590 0.0591 0.0590 0.0591 0.0590 0.0591 0.0590 0.0591 0.0295 13 14 15 16 5. You have been provided with the facts concerning ABC's proposed investment. Use this information to complete the four templates below necessary to evaluate this investment. a. Tax depreciation schedule Depreciation End of Year Amount Tax Basis Year Asset Cost Rate 1 2 2 3 3 4 5 6 b. Residual Value Computation