The Metals by Design Company is evaluating the proposed acquisition of a new milling machine. The machine's base price is $100,000, and it would cost another $9,000 to modify it for special use by the firm. The machine falls into the MACRS 3 - year class, and it would be sold after three years for $70,000. The machine would require net working capital (inventory) investment of 15.00% of the following year's forecasted revenues (adjust for the amount invested in NWC at the end of the previous period). The milling machine will result in an increase in production of 2,500; 25,000; and 25,000 units in each of the next three years, respectively. The current price per unit is $3.00. You should assume that price per unit will increase by 1%, 2%, and 3% annually over the next three years, respectively. The new milling machine is expected to save the firm $25,000, 40,000, and 40,000 per year for years 1 - 3 in before - tax operating costs, mainly labor. Metals by Design's tax rate is 40%. a. (1) what is the initial investment excluding the investment in NWC at t=0? what is the NWC investment in each year, 0 - 3? b. (1) Calculate the Depreciation Schedule including depreciation expense and book value. Use cost allocation to four decimal positions. Ex. 0.3333 c. (1) what are the incremental after - tax operating cash flows for years 1, 2, and 3? d. (1) what is the net proceeds from the sale of the milling machine at the end of year 3? e. (3) Assuming the project's required rate of return is 22%, should the machine be purchased? You must use nested = IF() logical statements to automatically report your recommendation and why. i. Calculate the payback period and decide whether to accept or reject. Must use a nested =IF() for this calculation and recommendation. Be careful. what if you aren't given a maximum payback period? ii. Calculate the net present value and decide whether to accept or reject and why. iii. Calculate the internal rate of return and decide whether to accept or reject and why. iv. Calculate the profitability index and decide whether to accept or reject and why. v. Calculate the modified internal rate of return and decide whether to accept or reject and why