In: Finance
Consider an investment opportunity with an option to grow that requires a $10m investment today. In one year we will find out whether the project is successful or not. The probability that the project will generate $1M per year in perpetuity (starting from one year after the investment is made; that is, starting from year 1) is 50%. Otherwise, the project will generate nothing. You can double the size of the project in year 1 if the original project is successful. Proceeding with the extension will require an additional $10m investment which will allow the firm to generate an incremental annual cash flow $1M in perpetuity starting from year 2 (that is, there is no uncertainty about future cash flows from the extended project). Assume the risk-adjusted discount rate is 6% p.a. and do not consider any other factors.
(a) What is the NPV of the project without growth option?
(b) What is the NPV of the project with growth option? (Hint: compute the PV of the growth option first by considering cash flows from the expanded project only)
Formula sheet
A | B | C | D | E | F | G | H | I | J | K | L | M | N |
2 | |||||||||||||
3 | To calculate NPV of the project, free cash flow needs to be calculated as follows: | ||||||||||||
4 | Free Cash Flow = Operating Cash Flow - Capital Expenditures - Change in working capital | ||||||||||||
5 | All numbers in million $ | ||||||||||||
6 | Probability | Cash Flow | |||||||||||
7 | 0.5 | 1 | |||||||||||
8 | 0.5 | 0 | |||||||||||
9 | |||||||||||||
10 | Expected Cash Flow from the project | =0.5*1+0.5*0 | |||||||||||
11 | 0.5 | =C7*D7+C8*D8 | |||||||||||
12 | |||||||||||||
13 | Calculation of NPV without growth option: | ||||||||||||
14 | Free Cash flow of project without growth option can be represented as below: | ||||||||||||
15 | Year | 0 | 1 | 2 | 3 | 4 | … | ||||||
16 | Investment | ($10) | |||||||||||
17 | Expected Cash flow | $0.5 | $0.5 | $0.5 | $0.5 | $0.5 | |||||||
18 | Free Cash Flow | ($10) | $0.5 | $0.5 | $0.5 | $0.5 | $0.5 | ||||||
19 | |||||||||||||
20 | NPV of the project is present value of future cash flows discounted at required rate of return less the initial investment. | ||||||||||||
21 | |||||||||||||
22 | Year | 0 | 1 | 2 | 3 | 4 | … | ||||||
23 | Free cash flow | ($10) | $0.5 | $0.5 | $0.5 | $0.5 | $0.5 | ||||||
24 | Required rate of retun | 6% | |||||||||||
25 | Project Life | Perpetuity | |||||||||||
26 | Present value of future cash flows | =0.5*(1/6%) | (Using perpetuity formula C/r) | ||||||||||
27 | $8.33 | =E23/D24 | |||||||||||
28 | |||||||||||||
29 | Net Present Value | =Present Value of future cash flows - Initial investment | |||||||||||
30 | Net Present Value | ($1.67) | =D27+D23 | ||||||||||
31 | |||||||||||||
32 | Hence NPV of the project without the growth option is | ($1.67) | |||||||||||
33 | |||||||||||||
34 | |||||||||||||
35 | Calculation of NPV with growth option: | ||||||||||||
36 | First present value of growth option needs to be calculated as below: | ||||||||||||
37 | Since growth option will be persued only if project is successful in year 1. | ||||||||||||
38 | Therefore growth option will also be considered successful and will have fixed cash flow of 1 million $ in perpetuity. | ||||||||||||
39 | |||||||||||||
40 | Cash flow for growth option is as below: | ||||||||||||
41 | Year | 0 | 1 | 2 | 3 | 4 | … | ||||||
42 | Investment | ($10) | |||||||||||
43 | Cash flow | $1.0 | $1.0 | $1.0 | $1.0 | ||||||||
44 | Free Cash Flow | ($10) | $1.0 | $1.0 | $1.0 | $1.0 | |||||||
45 | Required rate of retun | 6% | |||||||||||
46 | Project Life | Perpetuity | |||||||||||
47 | Present value of Growth Option | =(-10+1*(1/6%))*(P/F,6%,1) | |||||||||||
48 | $6.29 | =(E44+F44*(1/D45))*(1/(1+D45)) | |||||||||||
49 | |||||||||||||
50 | Thus project will have additional value of 6.29 million $ at year zero if the project is successful. | ||||||||||||
51 | |||||||||||||
52 | Now project with growth option cash flows can be represented as follows: | ||||||||||||
53 | Year | Probability | 0 | 1 | 2 | 3 | 4 | … | |||||
54 | Cash Flow if project is successful | 0.5 | ($3.7) | $1.0 | $1.0 | $1.0 | $1.0 | $1.0 | |||||
55 | Cash Flow If project is not successful | 0.5 | ($10.0) | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | |||||
56 | Expected Cash Flow | ($6.9) | $0.5 | $0.5 | $0.5 | $0.5 | $0.5 | =$D$54*J54+$D$55*J55 | |||||
57 | |||||||||||||
58 | Calculation of NPV for project with growth option: | ||||||||||||
59 | Year | 0 | 1 | 2 | 3 | 4 | … | ||||||
60 | Free cash flow | ($6.9) | $0.5 | $0.5 | $0.5 | $0.5 | $0.5 | ||||||
61 | Required rate of retun | 6% | |||||||||||
62 | Project Life | Perpetuity | |||||||||||
63 | Present value of future cash flows | =0.5*(1/6%) | (Using perpetuity formula C/r) | ||||||||||
64 | $8.33 | =E60/D61 | |||||||||||
65 | |||||||||||||
66 | Net Present Value | =Present Value of future cash flows - Initial investment | |||||||||||
67 | Net Present Value | $1.48 | =D64+D60 | ||||||||||
68 | |||||||||||||
69 | Hence NPV of the project with the growth option is | $1.48 | |||||||||||
70 |