Problem 8-17 NPV and Profitability Index [LO 4, 6]Coore Manufacturing has the following two possible projects. The required return is 10%.Please help me solve this question using Excel Problem 8-17 NPV and Profitability Index [LO 4, 6]Coore Manufacturing has the following two possible projects. The requiredreturn is 10 percent.Year1234Project Y-$ 28,40014,40012,80015, 20010,800Project Z-$ 64,00015,00035,00013,00033,000a. What is the profitability index for each project?Note: Do not round intermediate calculations and round your answersto 3 decimal places, e.g., 32.161.b. What is the NPV for each project?Note: Do not round intermediate calculations and round your answersto 2 decimal places, e.g., 32.16.c. Which, if either, of the projects should the company accept?a. Project YProject Zb. Project YProject Zc. Accept project

Initial Investment of Project Y = 28,400 Initial Investment of Project Z = 64,000 Year Project Y…

a. What is the profitability index for each project? Note: Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161. b. What is the NPV for each project? Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. c. Which, if either, of the projects should the company accept?

a. What is the profitability index for each project? Note: Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161. b. What is the NPV for each project? Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. c. Which, if either, of the projects should the company accept?

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter10: Project Cash Flows And Risk

Section: Chapter Questions

Problem 16PROB

See similar textbooks

Similar questions

Problem 8-14 Problems with Profitability Index [LO 4, 6] The Michner Corporation is trying to choose between the following two mutually exclusive design projects: Year Cash Flow (I) Cash Flow (II) 0 −$ 82,000 −$ 40,000 1 32,000 13,200 2 42,000 29,500 3 48,000 22,500 a-1. If the required return is 15 percent, what is the profitability index for each project? Note: Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161. a-2. If the company applies the profitability index decision rule, which project should it take? b-1. If the required return is 15 percent, what is the NPV for each project? Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. b-2. If the company applies the net present value decision rule, which project should it take?
Problem 8-12 Profitability Index (LO5) What is the profitability index of a project that costs $10,000 and provides cash flows of $3,000 in years 1 and 2 and $5,000 in years 3 and 4? The discount rate is 10%.
Ch 7. Decision Trees. For questions 12 and 13, please use the following information: Ang Electronics, Inc., has developed a new DVDR. If the DVDR is successful, the present value of the payoff (when the product is brought to market) is $28.6 million. If the DVDR fails, the present value of the payoff is $10.2 million. If the product goes directly to market, there is a 40 percent chance of success. Alternatively, the company can delay the launch by one year and spend $1.42 million to test market the DVDR. Test marketing would allow the firm to improve the product and increase the probability of success to 70 percent. The appropriate discount rate is 11 percent. Calculate the NPV of test marketing before going to market. Format answer as "XX,XXX,XXX.XX"
Ch 7. Decision Trees. For questions 12 and 13, please use the following information: Ang Electronics, Inc., has developed a new DVDR. If the DVDR is successful, the present value of the payoff (when the product is brought to market) is $28.6 million. If the DVDR fails, the present value of the payoff is $10.2 million. If the product goes directly to market, there is a 40 percent chance of success. Alternatively, the company can delay the launch by one year and spend $1.32 million to test market the DVDR. Test marketing would allow the firm to improve the product and increase the probability of success to 70 percent. The appropriate discount rate is 12 percent. Calculate the NPV of going directly to market. Format answer as "XX,XXX,XXX.XX"
Q No 1: Project K costs $52,125, its expected net cash inflows are $12,000 per year for 8 years, and its WACC is 12 percent. What is the project's, payback, discounted payback, and profitability index?Net present value (NPV) = $7,486.6772021MIRR = 13.89% IRR = 16%DONOT SOLVE ON EXCEL
QUESTION 32 Advanced Products is considering the purchase of a computer-aided manufacturing system that requires an initial investment of $1,750,000 and is expected to provide and is expected to provide an increase in net income of $200,000 and average annual cash benefits and savings of $250,000 each year for the next 10 years. Their current cost of capital is 10%. Following are selected factors from tables for 10 years at 10%: FV of $1 FVOA PV of $1 PVOA 2.59374 15.93742 0.38554 6.14457 Required: What is the present value of the cash outflows/Investment $1,750,000 $963,850 $(963,850) $(1,750,000)
aj.7 Steve's Stoves Company, which desires a minimum rate of return on its investment projects of 15%, has two proposals under consideration. Their costs and expected cash flows are: A B Initial Investment $96,000 $132,000 Expected after-tax cash flows: Year 1 $40,000 $52,000 Year 2 $32,000 $56,000 Year 3 $48,000 $40,000 Year 4 $24,000 $32,000 In addition, proposal B has an expected cash salvage value at the end of four years of $8,000. The present value of $1 due in 1, 2, 3, and 4 years at 15% is .86957, .75614, .65752, and .57175, respectively.Using the profitability index method, determine which project, if either, should be accepted by the company.
QUESTION 34 Advanced Products is considering the purchase of a computer-aided manufacturing system that requires an initial investment of $1,750,000 and is expected to provide an increase in net income of $200,000 and average annual cash benefits and savings of $250,000 each year for the next 10 years. Their current cost of capital is 10%. Following are selected factors from tables for 10 years at 10%: FV of $1 FVOA PV of $1 PVOA 2.59374 15.93742 0.38554 6.14457 Required: Compute the net present value of the investment $0 $750,000 $(213,857.50) $1,000,000
Ch 5. ABC Company has the following mutually exclusive projects. Year Project A Project B 0 -$19,520 -$16,800 1 11,500 9,500 2 8,750 7,100 3 2,500 3,500 If the company uses the Profitability Index to rank these two projects, which project should be chosen if the appropriate discount rate is 15 percent? Group of answer choices Project B Both projects Project A Neither projects
P10–24 ALL TECHNIQUES, CONFLICTING RANKINGS Nicholson Roofing Materials Inc. is considering two mutually exclusive projects that both cost $150,000. The company’s board of directors has set a maximum four-year payback requirement, the cost of capital is 9%. The project cash flows appear below. a. Calculate the payback period for each project. b. Calculate the NPV of each project at 0%. c. Calculate the NPV of each project at 9%.
Chapter 4 Exercise Pg.170 Question 2Perform a financial analysis for a project using the format provided in Figure 4-5. Assume the projected costs and benefits for this project are spread over four years as follows: Estimated costs are $200,000 in year 1 and $30,000 each year in years 2, 3, and 4. Estimated benefits are $0 in year 1 and $100,000 each year in years 2, 3, and 4. Use a 9 percent discount rate and round the discount factors to two decimal places. Create a spreadsheet (or use the business case financials template provided on the companion Web site) to calculate and clearly display the NPV, ROI, and year in which payback occurs. In addition, write a paragraph explaining whether you would recommend investing in this project, based on your financial.
QUESTION 35 Advanced Products is considering the purchase of a computer-aided manufacturing system that requires an initial investment of $1,750,000 and is expected to provide an increase in net income of $200,000 and average annual cash benefits and savings of $250,000 each year for the next 10 years. Their current cost of capital is 10%. Following are selected factors from tables for 10 years at 10%: FV of $1 FVOA PV of $1 PVOA 2.59374 15.93742 0.38554 6.14457 Required: Compute the payback period of the investment 8 years 10 years 7 years 9 years