Data Table - X More Info Henderson Manufacturing, Inc. has a manufacturing machine that needs attention. (Click the icon to view additional information.) Henderson expects the following net cash inflows from the two options: (Click the icon to view the net cash flows.) Henderson uses straight-line depreciation and requires an annual return of 10%. Year Refurbish Current Purchase New Machine Machine The company is considering two options. Option 1 is to refurbish the current machine at a cost of $1,200,000. If refurbished, Henderson expects the machine to last another eight years and then have no residual value. Option 2 is to replace the machine at a cost of $4,600,000. A new machine would last 10 years and have no residual value. 1 $ 350,000 $ 3,780,000 2 340,000 (Round your answer LU VITE Uelial place.) 510,000 3 270,000 440,000 The payback for Option 1 (refurbish current machine) is 4.3 years Print Done 4 200.000 370,000 Now complete the payback schedule for Option 2 (purchase). 5 130,000 300,000 6 Net Cash Outflows Net Cash Inflows 130,000 300,000 7 Amount Invested Year Annual Accumulated 130,000 300,000 8 130,000 300,000 0 $ 4,600,000 1 300,000 300,000 2 10 $ 1,680,000 $ 6.900.000 3 Total Print Done 7 8 9 10 Enter any number in the edit fields and then click Check