A company is evaluating the purchase of a machine to improve product quality and output levels. The new machine would cost $1,600,000 and would be depreciated for tax purposes using the straight-line method over an estimated six-year life to its expected salvage value of $100,000. The new machine would require an addition of $70,000 to working capital at the beginning of the project, which will of course be returned to the firm at the end of the project. The machine would increase the company's annual pre-tax cash receipts by $400,000 from their current level. Cash operating costs pertaining to the machine will be $15,000 per year. In addition, at the end of the 4th year, a major repair of the machine costing $40,000 (pre-tax) would be required. The company has an overall cost of capital of 8%, and is in the 35% marginal tax bracket. Required: A. Prepare a cash flow spreadsheet that identifies and summarizes the incremental cash flows for each year of the machine's life. B. Calculate the machine's net present value. C. Calculate the machine's internal rate of return. D. Based on your analysis, should the firm purchase the machine? Your answers to this problem should be placed in the space below this line.A Time Year Year Year Year Year Year Zero 1 2 3 4 5 6 Purchase of machine Annual cash revenues Annual cash costs Major repair Depreciation Earnings before tax Income tax Net income Add back depreciation Working capital imartment Sale of machine Net cash flow B Net cash flow from above Present value factors Present value Net present valueC IRR using Excel or calculator D Double click and put your answer here