Holmes Industries is deciding whether to automate one phase of its production process. The manufacturing equipment has a six-year life and will cost $910,000. Projected net cash inflows are as follows: (Click the icon to view the projected net cash inflows.) (Click the icon to view Present Value of $1 table.) Read the requirements. (Click the icon to view Present Value of Ordinary Annuity of $1 table.) Requirement 1. Compute this project's NPV using Holmes's 14% hurdle rate. Should Holmes invest in the equipment? Use the following table to calculate the net present value of the project. (Enter any factor amounts to three decimal places, X.XXX. Use parentheses or a minus sign for a negative net present value.) Net Cash PV Factor (i Inflow Years Year 1 Present value of each year's inflow: (n = 1) Year 2 Present value of each year's inflow: (n = 2) Year 3 Present value of each year's inflow: (n = 3) Year 4 Present value of each year's inflow: (n = 4) Year 5 Present value of each year's inflow: (n = 5) Year 6 Present value of each year's inflow: (n = 6) Total PV of cash inflows Year 0 Initial investment Net present value of the project = 14%) Present Value Data table Year 1 $ 262,000 Year 2 254,000 Year 3 222,000 Year 4 215,000 Year 5 200,000 Year 6 175,000 Print Done