ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
@
2
Reverse DCF
3
A reverse DCF shows you the expectations that are implied in the current stock price.
4
InputsInputs
5
Current stock price800,00Formula
6
Shares outstanding (million)1.133,2
7
Perpetuity growth rate 3,50%
8
Desired return (discount rate)10,00%
9
FCF year 1 (million)3.826,2
10
Growth rate year 1-100,1
11
12
13
Cash flow estimatesYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
14
FCF3.826,20 4.208,82 4.629,70 5.092,67 5.601,94 6.162,13 6.778,35 7.456,18 8.201,80 9.021,98
15
Growth10,00%10,00%10,00%10,00%10,00%10,00%10,00%10,00%10,00%
16
17
Discounted FCFsYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
18
FCF3.826,20 4.208,82 4.629,70 5.092,67 5.601,94 6.162,13 6.778,35 7.456,18 8.201,80 9.021,98
19
Present value3.478,36 3.478,36 3.478,36 3.478,36 3.478,36 3.478,36 3.478,36 3.478,36 3.478,36 3.478,36
20
Sum discounted CFs34.783,64
21
22
Terminal value
23
TV143.657,67
24
Present Value TV55.386,25
25
26
Total equity value
27
Total equity value90.169,89
28
29
Value per share
30
Intrinsic Value79,57
31
32
Upside/downside-90,05%
33
-900,54
34
35
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