Formulas MUST be included!

2 3 4 5 6 7 8 9 A company is considering a $294,000 investment in machinery with the following net cash flows. The company requires a 12% return on its investments. Initial investment Required rate of return Required: $294,000 12% (a) Compute the net present value of this investment. Period Net Cash Flows 10 11 12 13 14 15 16 17 18 19 1 2 3 4 5 Totals Initial investment Net present value $73,000 59,000 176,000 98,000 51,000 Present Value of Net Cash Flows Formula must include the PV function. (294,000) 20 Verify the value of cell C18 using the NPV function