Question

In: Finance

Year Project A Expected Cash Flows ($) 0 (1,250,000) 1 75,000 2 218,750 3 535,000 4...

Year Project A Expected Cash Flows ($) 0 (1,250,000) 1 75,000 2 218,750 3 535,000 4 775,000 5 775,000 Year Project B Expected Cash Flows ($) 0 (1,050,000) 1 650,000 2 500,000 3 226,250 4 137,500 5 62,500 Metrics Payback Period (in years) (A)3.54 (B)1.8 Discounted payback period (in years) (A)4.58 (B)2.72 Net Present Value (NPV) (A)$160,816 (B)$151,742 Internal Rate of Return (A)18.90% (B)23.84% Profitability Index (A)1.13 (B)1.14 Modified Internal Rate of Return (MIRR) (A)17.82% (B)18.15% a). What are some approaches that can be used to solve this problem. b). What are some various criteria or metrics that can be used to help make a decision. c). Rank the projects based on each of the following metrics: Payback period, Discounted payback period, NPV,IRR, Profitability Index and MIRR

Solutions

Expert Solution

A. The solution to this problem varies from analyst to analyst/Comapny to company. However, there is no set of rules to follow in cases like these,but there are certain guidelined to follow.

B. First of all, Both of these projects are profitable and would be taken up by a company if they aren't mutually exclusive.

In case they are mutually exclusive, then i as a decision maker would go for Project A (Which again might differ from analyst to analyst or company to company)

The reasons behind this is -

1. The payback and discounted payback period for project B Is lower than project A. Which would make you choose project B. But if you remember the drawbacks of these two methods, they tend to ignore the cash flows after the discounted payback period is reached. Which (cash flows after PP/DPP are significantly higher in project A than project B, Considering a little difference in the initial investment).

2. NPV/IRR/MIRR - Coming to the main indicator. NPV for project A is significantly higher than project B and there is a very little difference between the intial outlays of the projects which takes away one of the big drawbacks of NPV.

PI again is not a really good measure of profitability in project, and is only marginally higher in project B.

Coming to IRR/MIRR, yes they are higher for project B. But as we are taught that we have to always chose NPV against IRR in case of conflicting results. I would suggest choosing Project A.

C.

The one highlighted in green colour is the better than other

As you can see the image all the methods of capital budgeting are in favour of project B, Except NPV. But still NPV is the best way to analyst a project given that the initial cash outlays lie on the same/similar scale.


Related Solutions

You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project...
You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project 1 -$ 152 $22 $39 $58 $82 Project 2          −826 0 0 7,010 −6,506 Project 3 21 41 61 80   −247 a. For which of these projects is the IRR rule​ reliable? b. Estimate the IRR for each project​ (to the nearest1%​). c. What is the NPV of each project if the cost of capital is 5%​?20 %50%​? a. For which of these...
You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project...
You have 3 projects with the following cash​ flows: Year 0 1 2 3 4 Project 1 −$151 $ 21 $ 39 $ 59 $ 80 Project 2                                                −824 00 00 6,999 −6,501 Project 3 2020 40 62 81 −245 a. For which of these projects is the IRR rule​ reliable? b. Estimate the IRR for each project​ (to the nearest 1%​). c. What is the NPV of each project if the cost of capital is 5%​? 20%​? 50%​? a....
Consider cash flows for projects A and B Year: 0, 1, 2, 3, 4, 5 Project...
Consider cash flows for projects A and B Year: 0, 1, 2, 3, 4, 5 Project A: -$1000, 375, 375, 375, 375,-100 Project B: -$1000, 900, 700, 500, -200, 200 The cost of capital for both projects is 10% 1. Find the NPV and MIRR of projects A and B. If project A and B are mutually exclusive. 2. Find the crossover rate for projects A and B. 3. What is the profitability index for projects A and B? How...
​​ Considering the following projects. Project Year 0 1 2 3 4 A Cash flows -$100...
​​ Considering the following projects. Project Year 0 1 2 3 4 A Cash flows -$100 $35 $35 $35 $35 B Cash flows -$100 $60 $50 $40 $30 If project B is risker than project A, in which project A has WACC = 6.00% while project B has WACC = 8.50%. If these two projects are mutually exclusive, which project should the company accept? Compute: NPV, IRR, MIRR, payback, and discounted payback period for each project. # please with details.
4. A project has the following cash flows Year Cash Flow 0 58000 1 -34000 2...
4. A project has the following cash flows Year Cash Flow 0 58000 1 -34000 2 -45000 a) What is the IRR for this project? If the required rate of return is 12%, should the firm accept the project? b) What is the NPV for this project? What is the NPV for the project if the required rate of return is 0%? 24%? What is going on here? Sketch the NPV profile to help with your answer
TABLE 4 Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cash...
TABLE 4 Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow A -15000 6000 7000 6000 6000 6000 B -15000 7000 7000 7000 7000 7000 C -18000 12000 2000 2000 2000 2000 "Consider the cash flow of the three projects depicted in Table 4. The cost of capital is 7.5%. If an investor decided to take projects with a payback period of 2 years...
A project has the following cash flows : Year Cash Flows 0 −$12,000 1 5,290 2...
A project has the following cash flows : Year Cash Flows 0 −$12,000 1 5,290 2 7,630 3 5,040 4 −1,580 Assuming the appropriate interest rate is 10 percent, what is the MIRR for this project using the discounting approach? 19.21% 15.23% 13.96% 11.63% 17.77%
A project has the following cash flows : Year Cash Flows 0 −$11,700 1 5,110 2...
A project has the following cash flows : Year Cash Flows 0 −$11,700 1 5,110 2 7,360 3 4,800 4 −1,640 Assuming the appropriate interest rate is 7 percent, what is the MIRR for this project using the discounting approach?
Determine the rate of return for this project. Year 0 1 2 3 4 5 Cash...
Determine the rate of return for this project. Year 0 1 2 3 4 5 Cash flow -$12,300 $4000 $4000 $3000 $3000 $3000 14.21% 12.75% 13.11% 13.85%
Projects A and B have the following cash flows respectively: Year 0 1 2 3 4...
Projects A and B have the following cash flows respectively: Year 0 1 2 3 4 CFA −$2,050    $750    $760    $770    $780 CFB −$4,300 $1,500 $1,518 $1,536 $1,554 Both projects have a required return of 10.25%. What are NPV and IRR of the two projects? If project A and B are mutually exclusive, what is your decision with regard to accepting vs. rejecting each project? Why? What is the crossover rate?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT