Concept explainers
Comparing Investment Criteria [LO1, 2, 3, 5, 7] Consider the following two mutually exclusive projects:
Year | Cash Flow (A) | Cash Flow (B) |
0 | −$455,000 | −$65,000 |
1 | 58,000 | 31,000 |
2 | 85,000 | 28,000 |
3 | 85,000 | 25,500 |
4 | 572,000 | 19,000 |
Whichever project you choose, if any, you require a return of 11 percent on your investment
a. If you apply the payback criterion, which investment will you choose? Why?
b. If you apply the discounted payback criterion, which investment will you choose? Why?
c. If you apply the
d. If you apply the
e. If you apply the profitability index criterion, which investment will you choose? Why?
f. Based on your answers in (a) through (e), which project will you finally choose? Why?
a)
To compute: The payback period.
Introduction:
Capital budgeting is a process, where the business identifies and assesses the potential investments or expenses that are larger in general.
Answer to Problem 17QP
Here, Project B must be accepted as it pays back sooner than Project A.
Explanation of Solution
Given information:
The cash flows for two mutually exclusive projects are $58,000, $85,000, $85,000, $572,000 for Project A respectively for year 1, year 2, year 3, and year 4. Project A has an initial investment of $455,000. The cash flows of Project B are $31,000, $28,000, $25,500, and $19,000 respectively for year 1, year 2, year 3, and year 4. The initial investment for Project B is $65,000. The rate of return is 11%.
Formula to compute the payback period of a project:
Compute the payback period of a project for Project A:
Hence, the payback period is 3.40 years for Project A.
Compute the payback period of a project for Project B:
Hence, the payback period is 2.24 years for Project B.
b)
To compute: The discounted payback period.
Introduction:
Capital budgeting is a process, where the business identifies and assesses the potential investments or expenses that are larger in general.
Answer to Problem 17QP
Here, Project B must be accepted as it pays back sooner than Project A.
Explanation of Solution
Given information:
The cash flows for two mutually exclusive projects are $58,000, $85,000, $85,000, $572,000 for Project A respectively for year 1, year 2, year 3, and year 4. Project A has an initial investment of $455,000. The cash flows of Project B are $31,000, $28,000, $25,500, and $19,000 respectively for year 1, year 2, year 3, and year 4. The initial investment for Project B is $65,000. The rate of return is 11%.
Table showing the calculation of discounted payback period for Project A:
Year | Net Cash Inflows | ||
Annual | Today’s value (discounted) at 11% | Accumulated | |
1 | $58,000 | $52,252.25
| $52,252.25 |
2 | $85,000 | $68,987.91
| $121,240.16 |
3 | $85,000 | $62,151.27
| $183,391.43 |
4 | $572,000 | $376,794.12
| $560,185.55 |
Formula to compute the discounted payback period:
By the end of the year 3, the recovery amount is shorter than the initial investment. In the year 4, the recovery amount is higher than initial investment. It means the discounted payback period will be in between the year 3 and 4.
Calculate discounted payback period, if initial cost is $455,000:
Hence, the discounted payback period for Project A is 3.72 years.
Table showing the calculation of discounted payback period for Project B:
Year | Net Cash Inflows | ||
Annual | Today’s value (discounted) at 11% | Accumulated | |
1 | $31,000 | $27,927.93
| $27,927.93 |
2 | $28,000 | $22,725.43
| $50,653.36 |
3 | $25,500 | $18,645.38
| $69,298.74 |
4 | $19,000 | $12,515.89
| $81,814.63 |
Formula to calculate the discounted payback period for Project B, if initial cost is $65,000:
By the end of the year 2, the recovery amount is shorter than the initial investment. In the year 3, the recovery amount is higher than initial investment. It means the discounted payback period will be in between the year 2 and 3.
Calculate the discounted payback period for Project B, if initial cost is $65,000:
Hence, the discounted payback period for Project B is 2.77 years.
c)
To compute: The NPV (Net present value).
Introduction:
Capital budgeting is a process, where the business identifies and assesses the potential investments or expenses that are larger in general.
Answer to Problem 17QP
Here, Project A must be accepted as the NPV is higher in Project A.
Explanation of Solution
Given information:
The cash flows for two mutually exclusive projects are $58,000, $85,000, $85,000, $572,000 for Project A respectively for year 1, year 2, year 3, and year 4. Project A has an initial investment of $455,000. The cash flows of Project B are $31,000, $28,000, $25,500, and $19,000 respectively for year 1, year 2, year 3, and year 4. The initial investment for Project B is $65,000. The rate of return is 11%.
Formula to calculate the NPV:
Calculate the NPV for Project A:
Hence, the NPV for Project A is $105,185.54.
Calculate the NPV for Project B:
Hence, the NPV for Project B is $16,814.63.
d)
To compute: The IRR for the project.
Introduction:
Capital budgeting is a process, where the business identifies and assesses the potential investments or expenses that are larger in general.
Answer to Problem 17QP
Here, Project B must be accepted as the IRR is higher in Project B.
Explanation of Solution
Given information:
The cash flows for two mutually exclusive projects are $58,000, $85,000, $85,000, $572,000 for Project A respectively for year 1, year 2, year 3, and year 4. Project A has an initial investment of $455,000. The cash flows of Project B are $31,000, $28,000, $25,500, and $19,000 respectively for year 1, year 2, year 3, and year 4. The initial investment for Project B is $65,000. The rate of return is 11%.
Equation of IRR of Project A:
Compute IRR for Project A using a spreadsheet:
Step 1:
- Type the equation of NPV in H6 in the spreadsheet and consider the IRR value as H7
Step 2:
- Assume the IRR value as 10%
Step 3:
- In the spreadsheet go to data and select the what-if analysis
- In what-if analysis select goal seek
- In set cell select H6 (the Formula)
- The “To value” is considered as 0 (the assumption value for NPV)
- The H7 cell is selected for the by changing cell
Step 4:
- Following the previous step click OK in the goal seek. The goal seek status appears with the IRR value
Step 5:
- Thevalue appears to be 18.1542216674247%
Hence, the IRRvalue is 18.15%.
Equation of IRR of Project B:
Compute IRR for Project B using a spreadsheet:
Step 1:
- Type the equation of NPV in H6 in the spreadsheet and consider the IRR value as H7
Step 2:
- Assume the IRR value as 10%
Step 3:
- In the spreadsheet go to data and select the what-if analysis
- In what-if analysis select goal seek
- In set cell select H6 (the Formula)
- The “To value” is considered as 0 (the assumption value for NPV)
- The H7 cell is selected for the by changing cell
Step 4:
- Following the previous step click OK in the goal seek. The goal seek status appears with the IRR value
Step 5:
- Thevalue appears to be 23.6503617037489%
Hence, the IRRvalue is 23.65%.
e)
To compute: The profitability index.
Introduction:
Capital budgeting is a process, where the business identifies and assesses the potential investments or expenses that are larger in general.
Answer to Problem 17QP
Here, Project B must be accepted as the PI is higher in Project B.
Explanation of Solution
Given information:
The cash flows for two mutually exclusive projects are $58,000, $85,000, $85,000, $572,000 for Project A respectively for year 1, year 2, year 3, and year 4. Project A has an initial investment of $455,000. The cash flows of Project B are $31,000, $28,000, $25,500, and $19,000 respectively for year 1, year 2, year 3, and year 4. The initial investment for Project B is $65,000. The rate of return is 11%.
Formula to compute the profitability index:
Compute the profitability index for Project A:
Hence, the profitability index for Project A is $1.23.
Compute the profitability index for Project B:
Hence, the profitability index for Project B is $1.26.
f)
To discuss: The project that Person X will select with a reason.
Introduction:
Capital budgeting is a process, where the business identifies and assesses the potential investments or expenses that are larger in general.
Explanation of Solution
Given information:
The cash flows for two mutually exclusive projects are $58,000, $85,000, $85,000, $572,000 for Project A respectively for year 1, year 2, year 3, and year 4. Project A has an initial investment of $455,000. The cash flows of Project B are $31,000, $28,000, $25,500, and $19,000 respectively for year 1, year 2, year 3, and year 4. The initial investment for Project B is $65,000. The rate of return is 11%.
Explanation:
In this case, the criteria of NPV denote that Project A must be accepted, while payback period, discounted payback, profitability index, and IRR denote that Project B must be accepted. The overall decision must be based on the NPV as it does not have the ranking problem when compared with the other techniques of capital budgeting. Hence, Project A must be accepted.
Want to see more full solutions like this?
Chapter 9 Solutions
Fundamentals of Corporate Finance
- Start with the partial model in the file Ch10 P23 Build a Model.xlsx on the textbooks Web site. Gardial Fisheries is considering two mutually exclusive investments. The projects expected net cash flows are as follows: a. If each projects cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what project is the proper choice? b. Construct NPV profiles for Projects A and B. c. What is each projects IRR? d. What is the crossover rate, and what is its significance? e. What is each projects MIRR at a cost of capital of 12%? At r = 18%? (Hint: Consider Period 7 as the end of Project Bs life.) f. What is the regular payback period for these two projects? g. At a cost of capital of 12%, what is the discounted payback period for these two projects? h. What is the profitability index for each project if the cost of capital is 12%?arrow_forwardProject 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?arrow_forwardConsider the following two mutually exclusive projects: YEAR CASH FLOW (A) CASH FLOW (B)0 -$300,000 -$39,0001 20,000 18,0002 70,000 12,0003 80,000 18,0004 400,000 19,000 Whichever project you choose, if any, you require a 15 percent return on your investment.i) If you apply the payback period (PBP) criterion, which investment will you choose? Why?ii) If you apply the net present value (NPV) criterion, which investment will you choose? Why?iii) If you apply the profitability index (PI) criterion, which investment will you choose? Why?iv) If you apply the internal rate of return (IRR) criterion, which investment will you choose?Why?v) Based on your answers in (i) through (iv), which project will you finally…arrow_forward
- Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) -$ 15,456 5,225 8,223 13,013 8,705 0 1 234 -$ 276,363 26,400 51,000 57,000 402,000 Whichever project you choose, if any, you require a 6 percent return on your investment. a. What is the payback period for Project A? Payback period b. What is the payback period for Project B? Payback period c. What is the discounted payback period for Project A? Discounted payback periodarrow_forwardConsider two mutually exclusive projects with the following expected cash flows : Cash Flows Year Project C Project D 0 -15,000 -21,000 1 6,000 6,000 2 12,000 16,000 3 8,000 14,000 Whichever project you choose, if any, you require a return of 12% on your investment. a. If you apply the discounted payback criterion, which project will you choose? Why? b. If you apply the NPV criterion, which project will you choose? Why? c. Based on your answers in (a) and (b), which project will you finally choose? Why ? (i.e clearly explain the strengths and the weaknesses of each method therefore the reason(s) for choosing the project based on the chosen method)arrow_forwardConsider two mutually exclusive projects with the following expected cash flows and a required rate of return of 12% Cash Flows Year Project A Project B 0 -75,000 -100,000 1 60,000 60,000 2 30,000 50,000 3 30,000 60,000 (a) If you apply the discounted payback criterion, which investment will you choose? Why? (b) If you apply the NPV criterion, which investment will you choose? Why? (c) Based on your answers in (a) and (b), which project will you finally choose? Why ? (i.e clearly explain the strengths and the weaknesses of each method therefore the reason(s) for choosing the project based on the chosen method)arrow_forward
- Consider the following two mutually exclusive projects: Cash Flow (B) Cash Flow (A) $-300,000 20,000 50,000 50,000 390,000 Year $-40,000 19,000 12,000 18,000 4 10,500 Whichever project you choose, if any, you require 15 percent return 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, which investment will you choose? Why?arrow_forwardConsider the following two mutually exclusive projects: Cash Flow (A) $-300,000 20,000 50,000 50,000 Cash Flow (B) $-40,000 19,000 12,000 18,000 10,500 Year 2 3 4 390,000 Whichever project you choose, if any, you require 15 percent return 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, which investment will you choose? Why?arrow_forwardQ4: Consider the following two mutually exclusive projects, you require a 15 percent return on your investment: Year Cash Flow (A) Cash Flow (B) -18,000 10,000 -170,000 10,000 25,000 25,000 380,000 1 6,000 10,000 3 4 8,000 a) If you apply the payback criterion, which investment will you choose? Why? b) If you apply the discounted payback criterion, which investment will you choose? Why? c) If you apply the NPV criterion, which investment will you choose? Why? d) If you apply the IRR criterion, which investment will you choose? Why? e) If you apply the profitability index criterion, which investment will you choose? Why? f) Based on your answers in (a) through (e), which project will you finally choose? Why? g) What is the relationship between IRR and NPV? Are there any situations in which you might prefer one method over the other? Explainarrow_forward
- can you please answer from question e and f and below because an expert already answered previous one thank you Consider the following two mutually exclusive projects: Year Cash Flow(A) Cash Flow(B) 0 –$ 342,000 –$ 50,500 1 53,000 24,800 2 73,000 22,800 3 73,000 20,300 4 448,000 15,400 Whichever project you choose, if any, you require a return of 14 percent on your investment. a-1 What is the payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) a-2 If you apply the payback criterion, which investment will you choose? Project A Project B b-1 What is the discounted payback period for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) b-2 If you apply the discounted payback criterion, which…arrow_forward17: Consider the following 2 mutually exclusive projects: Year Cash flow A Cash Flow B 0 -291000 -41600 1 37000 20000 2 55000 17600 3 55000 17200 4 366000 14000 Whichever project you choose, if any, you require a return of 11% on your investment. If you apply the payback criterion, which investment will you choose? Why? If you apply the discounted payback criterion, which investment will you choose? Why? If you apply the NPV criterion, which investment will you choose? Why? If you apply the IRR criterion, which investment will you choose? Why? If you apply the profitability index criterion, which investment will you choose? Why? Based on your answers in parts A through E, which project will you finally choose? Why?arrow_forwardConsider the following two mutually exclusive projects: Year Cash Flow(A) -$ 63,000 39,000 33,000 22,500 14,600 Cash Flow(B) -$ 63,000 25,700 29,700 35,000 24,700 4 1-What is the IRR for each project? Project A Project B % % 2.IF you apply the IRR decision rule, which project should ti 3.Assume the required return is 14 percent. What is the NP Project A Project B 0123arrow_forward
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT