In: Finance
- Langton Inc. is considering Projects S and L, whose cash flows are shown below. These projects are mutually exclusive, equally risky, and not repeatable. The CEO believes the IRR is the best selection criterion, while the CFO advocates the NPV. If the decision is made by choosing the project with the higher IRR rather than the one with the higher NPV, how much, if any, value will be forgone? In other words, what's the NPV of the chosen project versus the maximum possible NPV? You must show each project's IRR as well as its NPV. The firm's cost of capital is 7%.
Year | CF from S | CF from L |
0 | -1200 | -2650 |
1 | 550 | 725 |
2 | 700 | 750 |
3 | 200 | 800 |
4 | 300 | 1400 |
What is the crossover point for the two projects? What is the significance of this?
Computation of NPV:
NPV = PV of future cash flows – Initial investment
Year |
Cash Flow (CS) |
Computation of PV Factor |
PV Factor @ 7 % (F) |
PV (CS x F) |
0 |
-$ 1,200 |
1/ (1+0.07)0 |
1 |
-$ 1,200.00 |
1 |
$ 550 |
1/ (1+0.07)1 |
0.934579439252336 |
$ 514.01869 |
2 |
$ 700 |
1/ (1+0.07)2 |
0.873438728273212 |
$ 611.40711 |
3 |
$ 200 |
1/ (1+0.07)3 |
0.816297876890852 |
$ 163.25958 |
4 |
$ 300 |
1/ (1+0.07)4 |
0.762895212047525 |
$ 228.86856 |
NPV |
$ 317.55394 |
NPV of Project L is $ 317.55
Year |
Cash Flow (CL) |
Computation of PV Factor |
PV Factor @ 7 % (F) |
PV (CL x F) |
0 |
-$ 2,650 |
1/ (1+0.07)0 |
1 |
-$ 2,650.00 |
1 |
$ 725 |
1/ (1+0.07)1 |
0.934579439252336 |
$ 677.57009 |
2 |
$ 750 |
1/ (1+0.07)2 |
0.873438728273212 |
$ 655.07905 |
3 |
$ 800 |
1/ (1+0.07)3 |
0.816297876890852 |
$ 653.03830 |
4 |
$ 1,400 |
1/ (1+0.07)4 |
0.762895212047525 |
$ 1,068.05330 |
NPV |
$ 403.74074 |
NPV of Project L is $ 403.74
Computation of IRR:
Project S:
Computation of NPV of Project S at discount rate of 20 %.
Year |
Cash Flow (CS) |
Computation of PV Factor |
PV Factor @ 20 % (F) |
PV (CS x F) |
0 |
-$ 1,200 |
1/ (1+0.2)0 |
1 |
-$ 1,200.00 |
1 |
$ 550 |
1/ (1+0.2)1 |
0.833333333333333 |
$ 458.33333 |
2 |
$ 700 |
1/ (1+0.2)2 |
0.694444444444445 |
$ 486.11111 |
3 |
$ 200 |
1/ (1+0.2)3 |
0.578703703703704 |
$ 115.74074 |
4 |
$ 300 |
1/ (1+0.2)4 |
0.482253086419753 |
$ 144.67593 |
NPVS1 |
$ 4.86111 |
As NPV is positive let’s compute NPV at discount rate of 21 %.
Year |
Cash Flow (CS) |
Computation of PV Factor |
PV Factor @ 21 % (F) |
PV (CS x F) |
0 |
-$ 1,200 |
1/ (1+0.21)0 |
1 |
-$ 1,200.00 |
1 |
$ 550 |
1/ (1+0.21)1 |
0.826446280991736 |
$ 454.54545 |
2 |
$ 700 |
1/ (1+0.21)2 |
0.683013455365071 |
$ 478.10942 |
3 |
$ 200 |
1/ (1+0.21)3 |
0.564473930053777 |
$ 112.89479 |
4 |
$ 300 |
1/ (1+0.21)4 |
0.466507380209733 |
$ 139.95221 |
NPV S2 |
-$ 14.49813 |
IRR S = R1 + [NPVS1 x (R2 – R1)/ (NPVS1 – NPVS2)]
= 20 % + [$ 4.86111 x (22 % – 21 %)/ ($ 4.86111 – (- $ 14.49813)]
= 20 % + [$ 4.86111 x 1 %/ ($ 4.86111 + $ 14.49813)]
= 20 % + ($ 0.0486111/ $ 19.35924)
= 20 % + 0.002511
= 20 % + 0.2511 % = 20.25 %
IRR of Project S is 20.25 %
Project L:
Computation of NPV of Project L at discount rate of 12 %.
Year |
Cash Flow (CL) |
Computation of PV Factor |
PV Factor @ 12 % (F) |
PV (CL x F) |
0 |
-$ 2,650 |
1/ (1+0.12)0 |
1 |
-$ 2,650.00 |
1 |
$ 725 |
1/ (1+0.12)1 |
0.892857142857143 |
$ 647.32143 |
2 |
$ 750 |
1/ (1+0.12)2 |
0.797193877551020 |
$ 597.89541 |
3 |
$ 800 |
1/ (1+0.12)3 |
0.711780247813411 |
$ 569.42420 |
4 |
$ 1,400 |
1/ (1+0.12)4 |
0.635518078404831 |
$ 889.72531 |
NPVL1 |
$ 54.36634 |
As NPV is positive let’s compute NPV at discount rate of 13 %.
Year |
Cash Flow (CL) |
Computation of PV Factor |
PV Factor @ 13 % (F) |
PV (CL x F) |
0 |
-$ 2,650 |
1/ (1+0.13)0 |
1 |
-$ 2,650.00 |
1 |
$ 725 |
1/ (1+0.13)1 |
0.884955752212389 |
$ 641.59292 |
2 |
$ 750 |
1/ (1+0.13)2 |
0.783146683373796 |
$ 587.36001 |
3 |
$ 800 |
1/ (1+0.13)3 |
0.693050162277696 |
$ 554.44013 |
4 |
$ 1,400 |
1/ (1+0.13)4 |
0.613318727679377 |
$ 858.64622 |
NPVL2 |
-$ 7.96072 |
IRR L = R1 + [NPVL1 x (R2 – R1)/ (NPVL1 – NPVL2)]
= 12 % + [$ 54.36634 x (13 % – 12 %)/ ($ 54.36634 – (- $ 7.96072)]
= 12 % + [$ 54.36634 x 1 %/ ($ 54.36634 + $ 7.96072)]
= 12 % + ($ 0.5436634 / $ 62.32706)
= 12 % + 0.008722751
= 12 % + 0.8722751 % = 12.87 %
IRR of Project L is 12.87 %
Project L should be accepted based on NPV decision.
Project S should be accepted based on IRR decision.
Forgone value if we choose Project S based on IRR rule = $ 403.74 - $ 317.55 = $ 86.19
Computation of Crossover rate:
Year |
Cash Flow (CL) |
Cash Flow (CS) |
Cash Flow CL - CS |
0 |
-$ 2,650 |
-$ 1,200 |
-$ 1,450 |
1 |
$ 725 |
$ 550 |
$ 175 |
2 |
$ 750 |
$ 700 |
$ 50 |
3 |
$ 800 |
$ 200 |
$ 600 |
4 |
$ 1,400 |
$ 300 |
$ 1,100 |
Computation of NPV at discount rate of 8 %
Year |
Cash Flow CL - CS |
Computation of PV Factor |
PV Factor @ 8 % (F) |
PV (CL - CS x F) |
0 |
-$ 1,450 |
1/ (1+0.08)0 |
1 |
-$ 1,450.00 |
1 |
$ 175 |
1/ (1+0.08)1 |
0.925925925925926 |
$ 162.03704 |
2 |
$ 50 |
1/ (1+0.08)2 |
0.857338820301783 |
$ 42.86694 |
3 |
$ 600 |
1/ (1+0.08)3 |
Related SolutionsNast Inc. is considering Projects S and L, whose cash flows are shown below. These projects...Nast Inc. is considering Projects S and L, whose cash flows are
shown below. These projects are mutually exclusive, equally risky,
and not repeatable. If the decision is made by choosing the project
with the higher MIRR rather than the one with the higher NPV, how
much value will be forgone? Note that under some conditions
choosing projects on the basis of the MIRR will cause $0.00 value
to be lost. WACC: 10.75% 0 1 2 3 4 CFS -$1,100...
Yonan Inc. is considering Projects S and L, whose cash flows are shown below. These projects...Yonan Inc. is considering Projects S and L, whose cash flows are
shown below. These projects are mutually
exclusive, equally risky, and not repeatable. If the decision is
made by choosing the project with the shorter
payback, some value may be forgone. How much value will be lost in
this instance? Note that under some
conditions choosing projects on the basis of the shorter payback
will not cause value to be lost
WACC 11.75%
0
1
2
3
4
CFs...
Nast Inc. is considering Projects S and L, whose cash flows are shown below. These projects...Nast Inc. is considering Projects S and L, whose cash flows are
shown below. These projects are mutually exclusive, equally risky,
and not repeatable. If the decision is made by choosing the project
with the higher MIRR rather than the one with the higher NPV, how
much value will be forgone? Note that under some conditions
choosing projects on the basis of the MIRR will cause $0.00 value
to be lost.
WACC:
10.75%
0
1
2
3
4
CFS
-$1,100...
Poston Inc. is considering Projects S and L, whose cash flows are shown below. These projects...Poston Inc. is considering Projects S and L, whose cash
flows are shown below. These projects are mutually exclusive (must
choose one or the other), equally risky, and not repeatable. If the
decision is made by choosing the project with the higher IRR, how
much value will be forgone? You must calculate the IRR and NPV for
both projects select the project with the higher IRR and then
calculate how much less the NPV is by selecting the project with...
Nast Inc. is considering Projects S and L, whose cash flows are shown below. These projects...Nast Inc. is considering Projects S and L, whose cash flows are
shown below. These projects are mutually exclusive, equally risky,
and not repeatable. If the decision is made by choosing the project
with the higher MIRR rather than the one with the higher NPV, how
much value will be forgone? Note that under some conditions
choosing projects on the basis of the MIRR will cause $0.00 value
to be lost.
WACC:
10.75%
0
1
2
3
4
CFS
-$1,100...
Sexton Inc. is considering Projects S and L, whose cash flows are shown below. These projects...Sexton Inc. is considering Projects S and L, whose cash flows
are shown below. These projects are mutually exclusive, equally
risky, and not repeatable. If the decision is made by choosing the
project with the higher IRR, how much value will be forgone? Note
that under certain conditions choosing projects on the basis of the
IRR will not cause any value to be lost because the one with the
higher IRR will also have the higher NPV, so no value...
Sexton Inc. is considering Projects S and L, whose cash flows are shown below. These projects...Sexton Inc. is considering Projects S and L, whose cash flows
are shown below. These projects are mutually exclusive, equally
risky, and not repeatable. If the decision is made by choosing the
project with the higher IRR, how much value will be forgone? Note
that under certain conditions choosing projects on the basis of the
IRR will not cause any value to be lost because the one with the
higher IRR will also have the higher NPV, so no value...
Charlestown Inc. is considering Projects S and L, whose cash flows are shown below. These projects...Charlestown Inc. is considering Projects S and L, whose cash
flows are shown below. These projects are mutually exclusive,
equally risky, and not repeatable.
WACC:
9.00%
0
1
2
3
4
CFS
-$2,000
$950
$950
$950
$950
CFL
-$9,000
$3,200
$3,200
$3,200
$3,200
If the decision is made by choosing the project with the higher
IRR, how much value will be forgone?
What is the payback period for Project S?
What is the discounted payback period for Project L?
What...
A firm is considering Projects S and L, whose cash flows are shown below. These projects...A firm is considering Projects S and L, whose cash flows are
shown below. These projects are mutually exclusive, equally risky,
and not repeatable. The CEO wants to use the IRR criterion, while
the CFO favors the NPV method. You were hired to advise the firm on
the best procedure. If the wrong decision criterion is used, how
much potential value would the firm lose? WACC: 6.75% 0 1 2 3 4 CFS
-$1,025 $380 $380 $380 $380 CFL -$2,150...
A firm is considering Projects S and L, whose cash flows are shown below. These projects...
A firm is considering Projects S and L, whose cash flows are
shown below. These projects are mutually exclusive, equally risky,
and not repeatable. The CEO wants to use the IRR criterion, while
the CFO favors the NPV method. You were hired to advise the firm on
the best procedure. If the wrong decision criterion is used, how
much potential value would the firm lose?
WACC:
7.75%
0
1
2
3
4
CF S
-$1,025
$380
$380
$380
$380
CF...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
ADVERTISEMENT
|