ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
Reverse DCF
3
4
Data you need to fill in:
5
Current stock price $ 447,00
The current stock price of the company
6
Shares outstanding2473
The current shares outstanding of the company
7
Perpetuity growth rate 3,5%
The growth rate at which the stock will grow after year 10
8
Desired return (discount rate)10,00%
Your required return as an investor
9
Free cash flow in year 1 $ 7.500,00
The free cash flow of the company this year
10
* Make sure that the shares outstanding and free cash flow in year 0 use the same multiple (thousands, millions, billions, …)
11
12
Fill in the growth rate in cell C12 to get to +/- 0% upside in cell G23
13
Growth rate year 1-1039,00%
The growth rate between year 1 and 10 to justify the current stock price
14
15
16
Output reverse DCF
17
Value free cash flow12345678910
18
Free cash flow $ 7.500,00 $ 10.425,00 $ 14.490,75 $ 20.142,14 $ 27.997,58 $ 38.916,63 $ 54.094,12 $ 75.190,83 $ 104.515,25 $ 145.276,20
19
Growth39,00%39,00%39,00%39,00%39,00%39,00%39,00%39,00%39,00%
20
21
22
Discounted free cash flow12345678910
23
Free cash flow $ 7.500,00 $ 10.425,00 $ 14.490,75 $ 20.142,14 $ 27.997,58 $ 38.916,63 $ 54.094,12 $ 75.190,83 $ 104.515,25 $ 145.276,20 Sum FCFs
24
Present value $ 6.818,18 $ 8.615,70 $ 10.887,11 $ 13.757,35 $ 17.384,29 $ 21.967,43 $ 27.758,84 $ 35.077,08 $ 44.324,67 $ 56.010,26 $ 242.600,92
25
26
Perpetuity value
27
Perpetuity value $ 2.313.244,08
28
Disocunted Perpetuity value $ 891.855,73
29
30
Total equity value
31
Total equity value $ 1.134.456,65
32
33
Intrinsic value per share
34
Intrinsic value per share $ 458,74
35
Upside/downside2,63%
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100