Uncertain Cash Flows [LO 8–4]The Cambro Foundation, a nonprofit organization, is planning to… 1 answer below »

Complete Problems E8-12 and P8-23 in the textbook and present your responses in an Excel spreadsheet.

APA style is not required, but solid academic writing is expected.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

EXERCISE 8–12 Uncertain Cash Flows [LO 8–4]The Cambro Foundation, a nonprofit organization, is planning to invest $104,950 in a project that will last for three years. The project will produce net cash inflows as follows:ProjectInvestmentRequiredNetPresentValueLife oftheProject(years)InternalRate ofReturn(percent)A ………………….$160,000$44,323 718%B ………………….$135,000$42,0001216%C ………………….$100,000$35,035 720%D ………………….$175,000$38,136 322%Year 1 ………………..$30,000Year 2………………..$40,000Year 3………………..?Required:Assuming that the project will yield exactly a 12% rate of return, what is the expected net cash inflow for Year 3?

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:Product AProduct BInitial investment: Cost of equipment (zero salvage value) ……$170,000$380,000Annual revenues and costs: Sales revenues ………………………$250,000$350,000Variable expenses …………………….$120,000$170,000Depreciation expense …………………$34,000$76,000Fixed out-of-pocket operating costs ………$70,000$50,000The company’s discount rate is 16%.Required: 1. 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. 4. Calculate the project profitability index for each product. 5. Calculate the simple rate of return for each product. 6. Which of the two products should Lou’s division pursue? Why?