Please show all equations used to calculate NPV, IRR, and all other required equations in EXCEL. I am having a hard time understanding how everyone is arriving at these present value decimal places. It is not making sense to me, and I am needing a bit more confirmation as to how you are actually getting there.

PROBLEM 8-23 Comprehensive Problem [LO 8-1, LO 8-2, LO 8-3, LO 8-5, LO 8-6 Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his divi- sion's return on investment (ROI), which has exceeded 18% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Required: Calculate the payback period for each product. 2. Calculate the net present value for each product. 3. Calculate the internal rate of return for each product. Product A Product B 4. 5. 6. Calculate the project profitability index for each product. Calculate the simple rate of return for each product. Which of the two products should Lou's division pursue? Why? Inltial Investment: Cost of equipment (zero salvage value) Annual revenues and costs: Sales revenues Varlable expenses Deprecation expense Flxed out-of-pocket operating costs $170,000 $380,000 . .. $250,000 $120,000 $34,000 $70,000 $350,000 $170,000 $76,000 $50,000 The company's discount rate is 16%