Concept explainers
Comparing Investment Criteria The treasurer of Amaro Canned Fruits, Inc., has projected the cash flows of Projects A, B, and C as follows:
Suppose the relevant discount rate is 12 percent per year.
- a. Compute the profitability index for each of the three projects.
- b. Compute the
NPV for each of the three projects. - c. Suppose these three projects are independent. Which project(s) should Amaro accept based on the profitability index rule?
- d. Suppose these three projects are mutually exclusive. Which project(s) should Amaro accept based on the profitability index rule?
- e. Suppose Amaro’s budget for these projects is $450,000. The projects are not divisible. Which project(s) should Amaro accept?
a)
To determine: The profitability index.
Profitability Index:
Profitability index shows whether a project is worth following or not by dividing net present value cash inflow from initial investment.
Explanation of Solution
Project A
Given,
PV of the entire cash inflow is $278,858.41.
Initial investment is $225,000.
Formula to calculate profitability index:
Substitute $278,858.41 for PV of the entire cash inflow and $225,000 for initial investment.
The profitability index is 1.23.
For Project B
Given,
PV of the entire cash inflow is $507,015.30.
Initial investment is $450,000.
Formula to calculate profitability index:
Substitute $507,015.30for PV of the entire cash inflow and $450,000 for initial investment.
The profitability index is 1.12.
For Project C
Given,
PV of the entire cash inflow is $275,206.61.
Initial investment is $225,000.
Formula to calculate profitability index:
Substitute $275,206.61 for PV of the entire cash inflow and $225,000 for initial investment.
The profitability index is 1.22.
Working notes:
Calculation for present value of Project A,
Calculation for present value of Project B,
Calculation for present value of Project C,
Hence, the profitability index of project A, B and C is 1.23, 1.12 and 1.22 respectively.
b)
To determine: The Net present value.
Net Present Value (NPV):
Net present value refers to the present value of all the future cash flow that is adjusted according to the time value of money.
Explanation of Solution
For Project A
Given,
PV of the entire cash inflow is $278,858.41.
Initial investment is $225,000.
Formula to calculate NPV:
Substitute $278,858.41for PV of the entire cash flow and $225,000 for initial investment.
The NPV of this project is $53,858.41.
For Project B
Given,
PV of the entire cash inflow is $507,015.30.
Initial investment is $450,000.
Formula to calculate NPV:
Substitute $507,015.30 for PV of the entire cash flow and $450,000 for initial investment.
The NPV of this project is $57,015.3.
For Project C
Given,
PV of the entire cash inflow is $275,206.61.
Initial investment is $225,000.
Formula to calculate NPV:
Substitute$275,206.61 for PV of the entire cash flow and $225,000 for initial investment.
The NPV of this project is $50,206.61.
Hence, the NPV of project A, B and C is$53,858.41, $57,015.3 and $275,206.61 respectively.
c)
To determine: Whether to choose project A or B or C on the basis of profitability index, if these projects are independent.
Answer to Problem 17QP
Solution:
Company AC should choose Project A first then Project C and at last Project B.
Explanation of Solution
Profitability index shows the dollar earned for the par dollar invested and higher the profitability index means higher the money he is earning on his investment. On the basis of this, Company AC should choose Project A first then Project C and at last Project B because the profitability index is highest for Project A and at second for Project C and at last for Project B.
Hence, Company AC should choose Project A first then Project C and at lastProject B.
d)
To determine: Whether to choose project A or B or C on the basis of profitability index, if the projects are mutually exclusive.
Answer to Problem 17QP
Solution:
A should choose Project A.
Explanation of Solution
Profitability index shows the dollar earned for the par dollar invested and higher the profitability index means higher the money he is earning on his investment. On the basis of this, A should choose Project A because project A has the highest profitability index of 1.23.
Hence, Company AC should choose Project A.
e)
To determine: Whether to choose project A or B or C, if total budget is $450,000.
Answer to Problem 17QP
Solution:
Company AC should choose Project A and Project C.
Explanation of Solution
Company AC should choose Project A and C because the total; NPV of Project A and C is $104,065.02 which is far above than the NPV of Project B which is $57,015.3.
Hence, Company AC should choose Project A and Project C.
Want to see more full solutions like this?
Chapter 5 Solutions
FINANCE 601 ACCESS CODE (CUSTOM)
- 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?arrow_forwardThere 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.arrow_forwardNet present value method, present value index, and analysis for a service company First United Bank Inc. is evaluating three capital investment projects by using the net present value method. Relevant data related to the projects are summarized as follows: Instructions 1. Assuming that the desired rate of return is 15%, prepare a net present value analysis for each project. Use the present value table appearing in Exhibit 2 of this chapter. 2. Determine a present value index for each project. (Round to two decimal places.) 3. Which project offers the largest amount of present value per dollar of investment? Explain.arrow_forward
- Clearcast Communications Inc. is considering allocating a limited amount of capital investment funds among four proposals. The amount of proposed investment, estimated operating income, and net cash flow for each proposal are as follows: The companys capital rationing policy requires a maximum cash payback period of three years. In addition, a minimum average rate of return of 12% is required on all projects. If the preceding standards are met, the net present value method and present value indexes are used to rank the remaining proposals. Instructions 1. Compute the cash payback period for each of the four proposals. 2. Giving effect to straight-line depreciation on the investments and assuming no estimated residual value, compute the average rate of return for each of the four proposals. Round to one decimal place. 3. Using the following format, summarize the results of your computations in parts (1) and (2). By placing the computed amounts in the first two columns on the left and by placing a check mark in the appropriate column to the right, indicate which proposals should be accepted for further analysis and which should be rejected. 4. For the proposals accepted for further analysis in part (3), compute the net present value. Use a rate of 12% and the present value table appearing in Exhibit 2 of this chapter. 5. Compute the present value index for each of the proposals in part (4). Round to two decimal places. 6. Rank the proposals from most attractive to least attractive, based on the present values of net cash flows computed in part (4). 7. Rank the proposals from most attractive to least attractive, based on the present value indexes computed in part (5). 8. Based on the analyses, comment on the relative attractiveness of the proposals ranked in parts (6) and (7).arrow_forwardBuena Vision Clinic is considering an investment that requires an outlay of 600,000 and promises a net cash inflow one year from now of 810,000. Assume the cost of capital is 10 percent. Required: 1. Break the 810,000 future cash inflow into three components: a. The return of the original investment b. The cost of capital c. The profit earned on the investment 2. Now, compute the present value of the profit earned on the investment. 3. Compute the NPV of the investment. Compare this with the present value of the profit computed in Requirement 2. What does this tell you about the meaning of NPV?arrow_forwardThere are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment or $28.000 and is expected to generate the following cash flows: If the discount rate is 5% compute the NPV of each project and make a recommendation of the project to be chosen.arrow_forward
- Scenario Analysis Shao Industries is considering a proposed project for its capital budget. The company estimates the projects NPV is 12 million. This estimate assumes that the economy and market conditions will be average over the next few years. The companys CFO, however, forecasts there is only a 50% chance that the economy will be average. Recognizing this uncertainty, she has also performed the following scenario analysis: What are the projects expected NPV, standard deviation, and coefficient of variation?arrow_forwardCapital rationing decision for a service company involving four proposals Renaissance Capital Group is considering allocating a limited amount of capital investment funds among four proposals. The amount of proposed investment, estimated operating income, and net cash flow for each proposal are as follows: The companys capital rationing policy requires a maximum cash payback period of three years. In addition, a minimum average rate of return of 12% is required on all projects. If the preceding standards are met, the net present value method and present value indexes are used to rank the remaining proposals. Instructions 1. Compute the cash payback period for each of the four proposals. 2. Giving effect to straight-line depreciation on the investments and assuming no estimated residual value, compute the average rate of return for each of the four proposals. (Round to one decimal place.) 3. Using the following format, summarize the results of your computations in parts (1) and (2). By placing the computed amounts in the first two columns on the left and by placing a check mark in the appropriate column to the right, indicate which proposals should be accepted for further analysis and which should be rejected. 4. For the proposals accepted for further analysis in part (3), compute the net present value. Use a rate of 15% and the present value table appearing in Exhibit 2 of this chapter. 5. Compute the present value index for each of the proposals in part (4). Round to two decimal places. 6. Rank the proposals from most attractive to least attractive, based on the present values of net cash flows computed in part (4). 7. Rank the proposals from most attractive to least attractive, based on the present value indexes computed in part (5). 8. Based on the analyses, comment on the relative attractiveness of the proposals ranked in parts (6) and (7).arrow_forwardThere 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: If the discount rate is 12%, compute the NPV of each project.arrow_forward
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENTCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubIntermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College