The Smith Company is considering the replacement of three manually operated milling machines with one new machine, a state of the art automated model. The old machines required three operators, one for each machine. The new machine could produce the same output but with only one operator. The old machines were purchased three years ago and had an expected useful life of eight years. If the new machine is purchased, the old machines will be sold in the used equipment market. New technology becomes obsolete more quickly now and the expected useful life of the new machines is five years. The firm depreciates equipment to zero book value using the straight line methiod for tax reporting purposes. The senior management team has asked you to calculate the NPV for this project. Data is provided below. Old Machines New Machine acquisiton date 31-Dec-16 acquisiton date 31-Dec-19 acquisition cost** $240,000 acquisition cost $540,000 estimated residual value at end of useful life (31-Dec24) $0 estimated residual value at end of useful life (31-Dec24) $60,000 estimated useful life (years) 8 estimated useful life (years) 5 estimated value in used equipment market on 31-Dec-19** $48,000 annual wages for machine operators $75,000 ** totals * both new and old machines cost of capital 18.0% income tax rate 35.0% Complete the cash flow template below. Use positive numbers for cash inflows and negative numbers for cash outlows. Similarly, use positive numbers for items that increase income and negative numbers for items that decrease income. There is a section below this template where you need to clearly show your work for income taxes on investing activities. (20 points)