Question

In: Finance

Consider the following projects, X and Y where the firm can only choose one. Project X...

Consider the following projects, X and Y where the firm can only choose one. Project X costs $1500 and has cash flows of $678, $652, $347, $111, $54, $16 in each of the next 6 years. Project Y also costs $1500, and generates cash flows of $738, $693, $405 for the next 3 years, respectively. WACC=9.5%.

  1. A) Draw the timelines for both projects: X and Y.

  2. B) Calculate the projects’ NPVs, IRRs, payback periods.

  3. C) If the two projects are independent, which project(s) should be chosen?

  4. D) If the two projects are mutually exclusive, which projects should be chosen?

  5. E) Plot NPV profiles for the two projects. Identify the projects’ IRRs on the graph.

  6. F) If the WACC were 5.5 percent, would this change your recommendation if the projects were

    mutually exclusive? If the WACC were 16.5 percent, would this change your recommendation? Explain your answers.

  7. G) There is a “crossover rate” of X’s and Y’s NPV curves, and mark it on the graph with Point O. Explain in words what this rate is and how it affects the choice between mutually exclusive projects.

  8. H) If it possible for conflicts to exist between the NPV and the IRR when independent projects are being evaluated? Explain your answer.

Solutions

Expert Solution

Part A

Project X timeline:

Project Y timeline:

Part B:

NPV, IRR and Payback of project X:

NPV is the surplus earned by a project in absolute terms after discounting the cash flows by an appropriate rate(in this case WACC) to its present value. This can be calculated using NPV function on Excel.

Internal rate of Return(IRR) is the discount rate that makes the NPV of all cash flows equal to Zero. It can be calculate using IRR function on Excel.

Calculation on Excel is as follows:

The formulas used are as follows:

Payback period signifies the amount of time a project will take to recover the initial costs. It can be used by calculating cumulative cash flows. Firstly, we need to count the number of years before the initial investment is fully recovered. Then, we need to divide the remaining initial cost to be recovered by the cash flows of the next year. This will give us the fraction of the year.

So, from the calculate cumulative cash flows above, we can derive that the project is recovering the initial costs between year 2 and year 3. To calculate the fraction of the year, we need to divide the remaining cost to be recovered, i.e. $170, by cash flow in the year 3, i.e. $347. So, $170/$347= 0.48. Now, we need add this figure to the full years it took to recover the costs, i.e. 2 years

So, the payback period will be 2.48 years.

NPV, IRR and Payback of project Y:

The formulas used are as follows:

Payback period of project Y

In project Y, initial cost is being recovered between Year 2 and Year 3. For calculation of fraction of the year, we need to divide the costs remaining to be recovered in year 2. i.e. $69 by cash flow in Year 3, i.e. $405 which is equal to 0.17.

So, the payback period is 2.17 years.

Part C:

If the projects X and Y are independent, both of them could be chosen as both the projects have positive NPV. This means that both the projects will be profitable for the firm.

Part D:

If the projects X and Y are mutually exclusive, Project Y should be chosen as it has a higher NPV which signifies that Project Y will be more profitable for the firm.


Related Solutions

Consider the following projects, X and Y where the firm can only choose one.
3Consider the following projects, X and Y where the firm can only choose one. Project X costs $600 and has cash flows of $400 in each of the next 2 years. Project also costs $600 and generates cash flows of $500 for the next 2 years respectively. Which investment should the firm choose the cost of capital is 25 percent? Another since both the projects have negative NPV Another, since both the projects have positive NPV Project X sine X has a higher...
Consider the following projects X and Y where the firm can choose only once. Project X...
Consider the following projects X and Y where the firm can choose only once. Project X costs $600 and has cash flows of $400 in each of the next two years. Project B also costs $ 600 and generates cash flows $500 and $275 for the next two years, respectively. Sketch a net present value profile (graphs) for each of these projects. For graphs you may use approximation Which project should the firm choose if the cost of capital is...
"Consider the following cash flows for projects X and Y. Assume the firm can only select...
"Consider the following cash flows for projects X and Y. Assume the firm can only select one of the projects. What is the MARR such that the firm is indifferent between selecting Project X or Y? Enter your answer as a percent between 0 and 100, rounded to the nearest tenth of a percent. You might consider an incremental approach. Project X (for n = 0 through 4) $ : -11,100 8,400 4,574 1,340 610 IRR : 21.1% Project Y...
Company B has three Projects it can choose from: Projects X, Y and Z. The following...
Company B has three Projects it can choose from: Projects X, Y and Z. The following information is available regarding Project X: Years 0 1 2 3 CF -100 80 60 40 The company’s capital structure is distributed equally between debt and preferred stock and the remaining 40% goes to common stock. It has also the following information: 1- After tax cost of debt: 3%. Tax rate: 40% 2- Preferred stocks are selling at $70 per share and pay a...
Company B has three Projects it can choose from: Projects X, Y and Z. The following...
Company B has three Projects it can choose from: Projects X, Y and Z. The following information is available regarding Project X: Years 0 1 2 3 CF -100 80 60 40 The company’s capital structure is distributed equally between debt and preferred stock and the remaining 40% goes to common stock. It has also the following information: 1- After tax cost of debt: 3%. Tax rate: 40% 2- Preferred stocks are selling at $70 per share and pay a...
Company B has three Projects it can choose from: Projects X, Y and Z. The following...
Company B has three Projects it can choose from: Projects X, Y and Z. The following information is available regarding Project X: Years 0 1 2 3 CF -100 80 60 40 The company’s capital structure is distributed equally between debt and preferred stock and the remaining 40% goes to common stock. It has also the following information: 1- After tax cost of debt: 3%. Tax rate: 40% 2- Preferred stocks are selling at $70 per share and pay a...
If projects are mutually exclusive, only one project can be chosen.
7. Understanding the NPV profile If projects are mutually exclusive, only one project can be chosen. The internal rate of return (IRR) and the net present value (NPV) methods will not always choose the same project. If the crossover rate on the NPV profile is below the horizontal axis, the methods will _______ agree. Projects W and X are mutually exclusive projects. Their cash flows and NPV profiles are shown as follows. YearProject WProject X0-$1,000-$1,5001$200$3502$350$5003$400$6004$600$750If the required rate of return...
Consider the following premerger information about Firm X and Firm Y: Firm X Firm Y Total...
Consider the following premerger information about Firm X and Firm Y: Firm X Firm Y Total earnings $ 88,000 $ 18,500 Shares outstanding 45,000 20,000 Per-share values: Market $ 45 $ 16 Book $ 16 $ 7 Assume that Firm X acquires Firm Y by paying cash for all the shares outstanding at a merger premium of $5 per share, and that neither firm has any debt before or after the merger. Construct the postmerger balance sheet for Firm X...
Company B’s WACC is 10%. It has three Projects it can choose from: Projects X, Y...
Company B’s WACC is 10%. It has three Projects it can choose from: Projects X, Y and Z. The following information is available regarding Project X. Years 0 1 2 3 Project X cash flows -$100 80 60 40 And the following information is available regarding Projects Y and Z. Criteria Project Y Project Z NPV $40 $67 MIRR 10% 20% IRR 2.0% 18.7% Regular Payback 2.23 years 1.77 years 5) Assuming the three projects X, Y & Z are...
ompany B’s WACC is 10%. It has three Projects it can choose from: Projects X, Y...
ompany B’s WACC is 10%. It has three Projects it can choose from: Projects X, Y and Z. The following information is available regarding Project X. Years 0 1 2 3 Project X cash flows -$100 80 60 40 And the following information is available regarding Projects Y and Z. Criteria Project Y Project Z NPV $40 $67 MIRR 10% 20% IRR 2.0% 18.7% Regular Payback 2.23 years 1.77 years 9) If IRR for Project X is 17.95%, and the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT