A company is considering a $$169,000$ investment in machinery with the following net cash flows. TheCompany requires a $6\%$ return on its investments.Required rate of return$4$Initial investment$69$Required:$21($a$)$ Compute the net present value ofthis investment$232425$Period$262320$ Verify the value of cell C$18$ using the NPV function$29422($b$)$ Should the machinery be purchased?$5$TotalsInitial investmentNet present value$$169,0006\%$Net CashFlows$$27,00036,00084,00052,00074,000$$$273,00$OPresent Value of NetCash Flows$(169,000)($S$169,000)$Yes$27$ Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used t$28$ Nothing in this area will be graded, but it will be submitted with your assignment.