I am able to find the answer, but not sure how to compute this in excel.

The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $1,080,000, and it would cost another s22,500 to install it. The machine falls into the MACRS 3 year dass, and it would be sold after 3 years for $605.000. The MACRS rates for the first 3 years are 0.3333, 0.4445, 0.1481. The machine would re an increase net working capital (inventory) of S15,500. The sprayer would not change revenue, but itis expected to save the firm S380.000 per year in before-tax operating costs, mainly labor. Campbell's marginal tax rate is 35% (a) What is the Year-0 net cash flow? b) What are the net operating cash flowsin Years 1,2, and 3? (d) If the project's cost of capital is 12%, should the machine be purchased? 59 sprayer's base price 1,080,000 cost to install 22,500 MACRS rate 1st year 0.3333 MACRS rate 2nd year 04445 MACRS rate 3rd year sold after 3 years 605,000 increase in inventory 15,500 before tax op cost (savings) 380,000 rate 0.35 (a) Year-0 Net Cash Flow base price instal cost-inaease in inventory 70 Answer -$1,118,000