i need this question answer General accounting The CFO of Horizon Industries is evaluating four potentialinvestment projects P, Q, R, and S. The initial investment andpresent value of expected cash inflows for each project are as follows:-Project Initial Investment Present Value of Cash InflowsP$240,000Q$180,000R$320,000S$150,000$273,600$212,400$358,400$177,000Rank the projects according to the profitability index, from mostprofitable to least profitable.a. P, Q, R, Sb. Q, P, R, Sc. S, R, P, Qd. R, P, Q, S

Step 1: Define Profitability Index (PI)The Profitability Index (PI) is a financial metric used to…

Answered: The CFO of Horizon Industries is…

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter12: Capital Investment Analysis

Section: Chapter Questions

Problem 2PA

See similar textbooks

Similar questions

There are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment of $35,000 and is expected to generate the following cash flows: Use the information from the previous exercise to calculate the internal rate of return on both projects and make a recommendation on which one to accept. For further instructions on internal rate of return in Excel, see Appendix C.
Project S has a cost of $10,000 and is expected to produce benefits (cash flows) of $3,000 per year for 5 years. Project L costs $25,000 and is expected to produce cash flows of $7,400 per year for 5 years. Calculate the two projects’ NPVs, IRRs, MIRRs, and PIs, assuming a cost of capital of 12%. Which project would be selected, assuming they are mutually exclusive, using each ranking method? Which should actually be selected?
Fenton, Inc., has established a new strategic plan that calls for new capital investment. The company has a 9.8% required rate of return and an 8.3% cost of capital. Fenton currently has a return of 10% on its other investments. The proposed new investments have equal annual cash inflows expected. Management used a screening procedure of calculating a payback period for potential investments and annual cash flows, and the IRR for the 7 possible investments are displayed in image. Each investment has a 6-year expected useful life and no salvage value. A. Identify which project(s) is/are unacceptable and briefly state the conceptual justification as to why each of your choices is unacceptable. B. Assume Fenton has $330,000 available to spend. Which remaining projects should Fenton invest in and in what order? C. If Fenton was not limited to a spending amount, should they invest in all of the projects given the company is evaluated using return on investment?
Carmen, Inc. is considering three different independent investment opportunities. The present value of future cash flows, initial investment, net present value, and profitability index for each of the projects are as follows: Project A Project B Project C Present value of future cash flows $450,100 $313,100 $405,000 Initial investment 200,000 155,000 190, еее Net present value $250, 100 $158,100 $215,000 Profitability index 2.25 2.02 2.13 In what order should Carmen prioritize investment in the projects? Multiple Cholce С, В, А O A, B, C А, С, В C, A, B
What is the correct option? General accounting question
The management of NUBD Co. is considering three investment projects-W, X, and Y. Project W would require an investment of P21,000, Project X of P66,000, and Project Y of P95,000. The present value of the cash inflows would be P22,470 for Project W, P73,920 for Project X, and P98,800 for Project Y. Rank the projects according to the profitability index, from most profitable to least profitable. *
The management of Winstead Corporation is considering the following three investment projects (Ignore income taxes.): Project Q Project R Project S Investment required $ 57,200 $ 97,200 $ 176,000 Present value of cash inflows $ 62,092 $ 111,792 $ 193,320 The only cash outflows are the initial investments in the projects. Required: Rank the investment projects using the project profitability index.
I need help finding the Profitability index for each project (D) using Excel
A company is considering three alternative investment projects with different net cash flows. The present value of net cash flows is calculated using Excel and the results follow. Potential Projects Present value of net cash flows (excluding initial investment) Initial investment Project A $ 11,226 (10,000) Project B $ 10,568 (10,000) a. Compute the net present value of each project. b. If the company accepts all positive net present value projects, which of these will it accept? c. If the company can choose only one project, which will it choose on the basis of net present value? Complete this question by entering your answers in the tabs below. Required A Required B Required C Compute the net present value of each project. Potential Projects Project A Project B Project C Present value of net cash flows Initial investment Net present value $ $ $
The net cash flow per year for the investment projects A and B, is presented in the table below. Expected Net Cash Flow ($) Project 0 1 2 3 4 A -10,000 6500 3000 3000 1000 B -10,000 3500 3500 3500 3500 Calculate the NPV, IRR, PI, and PVR for the cash flows given in the following table. Assume the minimum acceptable rate of return of 8%. Which projects should be accepted if they are independent projects? Would the selection of the projects change if the cost of capital were 12%?
Jill Harrington, a manager at Jennings Company, is considering several potential capital investment projects. Data on these projects follow: Initial investment Annual cash inflows PV of cash inflows Required: Project X $ 40,000 25,000 45,000 Project Y $ 20,000 10,000 33,000 Project Z $ 50,000 25,400 70,000 1. Compute the payback period for each project and rank order them based on this criterion. 2. Compute the NPV of each project and rank order them based on this criterion. 3. Compute the profitability index of each project and rank order them based on this criterion. 4. If Jennings has limited funds to invest, which ranking should Jill recommend?
Consider the following project-balance profiles for proposed investment projects, where the project-balance figures are rounded to the nearest dollar: (a) Compute the net present worth of each investment.(b) Determine the project balance at the end of period 2 for Project C ifA2 = $500.(c) Determine the cash flows for each project.(d) Identify the net future worth of each project.

SEE MORE QUESTIONS

Recommended textbooks for you

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Intermediate Financial Management (MindTap Course…

Finance

ISBN:

9781337395083

Author:

Eugene F. Brigham, Phillip R. Daves

Publisher:

Cengage Learning

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

Intermediate Financial Management (MindTap Course…

Finance

ISBN:

9781337395083

Author:

Eugene F. Brigham, Phillip R. Daves

Publisher:

Cengage Learning

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

SEE MORE TEXTBOOKS