$123561011127$ Required:$1314151617121921232425$Acompany requires a $6\%$ return on its investments.Initial investment$26$A company is considering a $$169,000$ investment in machiney with the following net cash flows. TheRequired rate of return$20$ Verify the value of cell C$18$ using the NPVfunction$22($b$)$ Should the machinery be purchased?Perioda$)$ Compute the net present value of this investment.TotalsInitial investmentNet present valueBS$169,0006\%$Net Cash Flows$$27,00036,00084,00052,00074,000$$$273,000$Present Value of NetCash FlowsFormula must incdudethe PV function.$o$(169,000)($$$169,000)$DYes

please note thst cells c$11$ to c$15$ need to use excel PV formula