Concept explainers
LO3 LO4 10.
Year | Cash Flow (A) | Cash Flow (B) |
0 | –$78,500 | –$78,500 |
1 | 43,000 | 21,000 |
o | 29,000 | 28,000 |
3 | 23,000 | 34,000 |
4 | 21,000 | 41,000 |
a. What is the IRR for each of these projects? If you apply the IRR decision rule, which project should the company accept? Is this decision necessarily correct?
b. If the required return is 11 percent, what is the NPV for each of these projects? Which project will you choose if you apply the NPV decision rule?
c. Over what range of discount rates would you choose Project A? Project B? At what discount rate would you be indifferent between these two projects? Explain.
a)
To calculate: The IRR (Internal Rate of Return) for the proposed projects of Company Z, the project that the company must accept and discuss whether the taken decision is appropriate
Introduction:
The IRR (Internal Rate of Return) is a rate of discount which makes the predictable investment’s NPV equal to zero.
The NPV (Net Present Value) is a capital budgeting technique which is used to assess the investment that, in turn, is utilized to identify the profitability in a proposed investment.
Answer to Problem 10QP
As IRR is higher in Project A when compared to Project B, Project A can be accepted. However, it is not the appropriate decision because the criterion of IRR has a problem in ranking for mutually exclusive projects.
Explanation of Solution
Given information:
Company Z has identified two mutually exclusive projects where the cash flows of Project A are $43,000, $29,000, $23,000, and $21,000 for year1, 2, 3, and 4 respectively. The cash flows of Project B are $21,000, $28,000, $34,000, and $41,000 for year 1, 2, 3, and 4 respectively. The initial costs for both the projects are $78,500 respectively.
Note:
- NPV is the difference between the present values of the cash inflows from the present value of cash outflows.
- The IRR is the rate of interest which makes the project’s NPV equal to zero. Hence, using the available information, assume that NPV is equal to zero and form an equation to compute the IRR.
Equation of NPV to compute IRR assuming that NPV is equal to zero:
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 the 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:
- The value appears to be 20.7045842372508%.
Hence, the IRR value is 20.70%.
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 the 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:
- The value appears to be 18.7276140101209%.
Hence, the IRR value is 18.73%.
b)
To calculate: The NPV for the projects to choose the best project for the company
Introduction:
The IRR (Internal Rate of Return) is a rate of discount which makes the predictable investment’s NPV equal to zero.
The NPV (Net Present Value) is a capital budgeting technique which is used to assess the investment that, in turn, is utilized to identify the profitability in a proposed investment.
Answer to Problem 10QP
As NPV is greater in Project B, the company must accept Project B.
Explanation of Solution
Given information:
Company Z has identified two mutually exclusive projects where the cash flows of Project A are $43,000, $29,000, $23,000, and $21,000 for year1, 2, 3, and 4 respectively. The cash flows of Project B are $21,000, $28,000, $34,000, and $41,000 for year 1, 2, 3, and 4 respectively. The initial costs for both the projects are $78,500 respectively.
Note:
- NPV is the difference between the present values of the cash inflows from the present value of cash outflows.
- The IRR is the rate of interest which makes the project’s NPV equal to zero. Hence, using the available information, assume that NPV is equal to zero and form an equation to compute the IRR.
Formula to calculate the NPV:
Compute NPV for Project A:
Hence, the NPV for Project A is $14,426.54.
Compute NPV for Project B:
Note: The rate is given at 11%.
Hence, the NPV for project B is $15,012.82.
c)
To calculate: The rates of discount at which the company will select Project A and Project B and the discount rate in which the company will be indifferent in selecting between the two projects
Introduction:
The IRR (Internal Rate of Return) is a rate of discount which makes the predictable investment’s NPV equal to zero.
The NPV (Net Present Value) is a capital budgeting technique which is used to assess the investment that, in turn, is utilized to identify the profitability in a proposed investment.
Answer to Problem 10QP
At the rate of discount above 12.21%, the company must choose Project A, and for the rate below 12.21%, the company should choose Project B. Hence, it is indifferent at the discount rate of 12.21%.
Explanation of Solution
Given information:
Company Z has identified two mutually exclusive projects where the cash flows of Project A are $43,000, $29,000, $23,000, and $21,000 for year1, 2, 3, and 4 respectively. The cash flows of Project B are $21,000, $28,000, $34,000, and $41,000 for year 1, 2, 3, and 4 respectively. The initial costs for both the projects are $78,500 respectively.
Note:
- NPV is the difference between the present values of the cash inflows from the present value of cash outflows.
- The IRR is the rate of interest which makes the project’s NPV equal to zero. Hence, using the available information, assume that NPV is equal to zero and form an equation to compute the IRR.
Equation to calculate the crossover rates:
Compute the discount rate using spreadsheet
Step 1:
- Type the equation of NPV in H6 in the spreadsheet and consider the R value as H7.
Step 2:
- Assume the R value as 10%.
Step 3:
- In the spreadsheet, go to data and select the what-if analysis.
- In the 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 R value.
Step 5:
- The value appears to be 12.2118690243115%.
Hence, the R value is 12.21%.
Want to see more full solutions like this?
Chapter 8 Solutions
Essentials of Corporate Finance (Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
- 11. IRR rule (S5.3) Consider the following two mutually exclusive projects: Cash flows ($) Project A B Co -50 -50 C₁ +60 0 C₂ +60 0 0 +140 Page 142 a. Calculate the NPV of each project for discount rates of 0%, 10%, and 20%. Plot these on a graph with NPV on the vertical axis and discount rate on the horizontal axis. b. What is the approximate IRR for each project? c. In what circumstances should the company accept project A? d. Calculate the NPV of the incremental investment (B – A) for discount rates of 0%, 10%, and 20%. Plot these on your graph. Show that the circumstances in which you would accept A are also those in which the IRR on the incremental investment is less than the opportunity cost of capital.arrow_forwardConsider the following information: Cash Flows ($) Project C0 C1 C2 C3 C4 A –5,300 1,300 1,300 2,700 0 B –700 0 600 2,300 3,300 C –5,200 3,400 1,700 800 300 a. What is the payback period on each of the above projects? (Round your answers to 2 decimal places.) b. Given that you wish to use the payback rule with a cutoff period of two years, which projects would you accept?multiple choice 1 Project A Project B and Project C Project A and Project B Project A, Project B, and Project C Project C Project A and Project C Project B None c. If you use a cutoff period of three years, which projects would you accept?multiple choice 2 Project A, Project B, and Project C Project A Project B Project A and Project C Project C Project A and Project B Project B and Project C d. If the opportunity cost of capital is 10%, which projects have positive NPVs?multiple choice 3 Project B Project C Project A,…arrow_forwardHere is the cash flow for two mutually exclusive projects. Project C0 C1 C2 C3 A -$20,000 $8,000 $8,000 $8,000 B -$20,000 0 0 $25,000 At what interest rate would you prefer project A to B? ( NPV Value) 2. What is the IRR of each project? Explain you answer using formulas.arrow_forward
- 7. Consider the two mutually exclusive investment projects in the table, which have unequal service lives. 11 0 1 2 3 4 5 Project's Cash Flow A2 -$1,800 -$300 -$300 -$300 -$300 -$300 A1 -$900 -$400 -$400 -$400 $200 WAL -$300 + $500 a. What assumption(s) do you need in order to compare a set of mutually exclusive service projects with unequal service lives? b. With the assumption(s) defined in part (a) and using 10%, determine which project should be selected. c. If your analysis period (study period) is just three years, what should be the salvage value of project A2 at the end of year 3 to make the two alternatives economically indifferent?arrow_forwardSuppose that you could invest in the following projects but have only $24,480 to invest. Which projects would you choose? Project Cost NPV w $ 7,970 $ 3,000 x 10,990 7,530 y 8,500 4,280 z 6,750 3,890 You should invest in project(s)?arrow_forwardThe Weiland Computer Corporation is trying to choose between the following mutually exclusive design projects, P1 and P2: Year 1 3 Cash flows (P1) -$53,000 27,000 27,000 27,000 Cash flows (P2) -$16,000 9,100 9,100 9,100 a. If the discount rate is 10 percent and the firm applies the Net Present Value (NPV) decision rule, which project should the firm accept? b. If the firm applies the profitability index (PI) decision rule, which project should it take?arrow_forward
- Consider two mutually exclusive projects A and B: Cash Flows (dollars) Project Co A -39,500 B -59,500 C₁ 28,600 42,500 C₂ NPV at 11% 28,600 +$ 9,478 42,500 +13,282 a. Calculate IRRS for A and B. Note: Do not round intermediate calculations. Enter your answers as a perc Project A B IRR % % b. Which project does the IRR rule suggest is best? Project A Project B c. Which project is really best? Project A Project B Parrow_forwardA firm is considering the following independent projects. Project Investment Present value offuture cash flows NPV A $130 $176 $46 B $103 $115 $12 C $183 $287 $104 D $161 $199 $38 E $184 $273 $89 What is the Profitability Index of Project B? Question 5Answer a. 0.85 b. 1.12 c. 0.89 d. 1.18arrow_forwardConsider the following two projects: Cash flows Project A Project B C0�0 −$ 240 −$ 240 C1�1 100 123 C2�2 100 123 C3�3 100 123 C4�4 100 a. If the opportunity cost of capital is 8%, which of these two projects would you accept (A, B, or both)? b. Suppose that you can choose only one of these two projects. Which would you choose? The discount rate is still 8%. c. Which one would you choose if the cost of capital is 16%? d. What is the payback period of each project? e. Is the project with the shortest payback period also the one with the highest NPV? f. What are the internal rates of return on the two projects? g. Does the IRR rule in this case give the same answer as NPV? h. If the opportunity cost of capital is 8%, what is the profitability index for each project? i. Is the project with the highest profitability index also the one with the highest NPV? j. Which measure should you use to choose between the projects?arrow_forward
- Consider two mutually exclusive projects, A and B, whose costs and cash flows areshown in the following table:Year Project A Project B1 $(14,000) $(22,840)2 8,000 8,0003 6,000 8,0004 2,000 8,0005 3,000 8,000Calculate the cross over rate. Please use equations and not excelarrow_forward4. Consider the two projects depicted in Table 2: The net present value (NPV) of project A is ________ TABLE 2 Project Year 0 Year 1 Year 2 Year 3 Year 4 Discount Cash Flow Cash Flow Cash Flow Cash Flow. Cash Flow. Rate A. -100. 40. 70 60 0. 0.11 B -80 50 30 30 30 0.11 5 Consider the two projects depicted in Table 2: The net present value (NPV) of project B is ________.arrow_forwardProblem 6.a: A manufacturing firm is considering the mutually exclusive alternatives given in the table below. Determine the IRR on incremental investment (IRR of the difference). do not use % sign in your answer n 0 1 2 Net Cash Flow Project A1 - $4,000 2,600 2,800 Project A2 - $5,000 3,600 3,200arrow_forward
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning