answer the following using excel / excel formula
LOI, LO3, 15. Comparing Investment Criteria Consider the following two mutually exclusive projects: LO4, L06 Year Cash Flow (A) Cash Flow (B) 0 -$245,000 -$53,000 1 34.000 31,900 2 49,000 21,800 3 51.000 17,300 4 325,000 16,200 Whichever project you choose, if any, you require a return of 13 percent on your investment. a. If you apply the payback criterion, which investment will you choose? Why? b. If you apply the NPV criterion, which investment will you choose? Why? c. If you apply the IRR criterion, which investment will you choose? Why? d. If you apply the profitability index criterion, which investment will you choose? Why? e. Based on your answers in parts (a) through (d), which project will you finally choose? Why? LO4, L06 17. NPV and Profitability Index Coore Manufacturing has the following two possible projects. The required return is 12 percent Year Project Y -$47,600 Project Z -$81,000 0 1 23.900 34.000 2 18,600 32.800 3 20,700 30,500 4 14,600 27,300 a. What is the profitability index for each project? b. What is the NPV for each project? c. Which, if either, of the projects should the company accept? LOI. LO4 21. NPV and Payback Period Kaleb Konstruction, Inc., has the following mutually exclusive projects available. The company has historically used a three-year cutoff for projects. The required return is 10 percent. Year Project G 0 Project F -$195,000 98,400 -$298.000 1 71,600 2 86,300 94,500 3 81,600 123,600 4 72.000 166,800 S 64.800 187.200 a. Calculate the payback period for both projects. b. Calculate the NPV for both projects. c. Which project, if any, should the company accept? LO3, L04 25. Calculating IRR A project has the following cash flows: Year 0 Cash Flow $112.000 - 67.000 - 57,000 1 2 What is the IRR for this project? If the required return is 10 percent, should the firm accept the project? What is the NPV of this project? What is the NPV of the project if the required return is 0 percent? 24 percent? What is going on here? Sketch the NPV profile to help you with your answer. LO4 28. NPV Valuation The Yurdone Corporation wants to set up a private cemetery business. According to the CFO, Barry M. Deep. business is "looking up." As a result, the cemetery project will provide a net cash inflow of $164,000 for the firm during the first year, and the cash flows are projected to grow at a rate of 4.7 percent per year forever. The project requires an initial investment of $1.825.000 a. If the company requires a return of 12 percent on such undertakings, should the cemetery business be started? b. The company is somewhat unsure about the assumption of a 4.7 percent growth rate in its cash flows. At what constant growth rate would the company just break even if it still required a return of 12 percent on its investment
