ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
REVERSE DCF SCENARIO ANALYSIS
2
3
This DCF will calculate intrinsic value for 9 different combinations of Base FCF and 10Y FCF growth rates
4
If the output is 100%, it means the intrinsic value equals the current entreprise value. The growth rates and base FCF correspond to what the market is pricing in.
5
If the output is > 100%, it means the company is overvalued
6
If the output is < 100%, it means the company is undervalued
7
8
Please provide inputs in the salmon cells
9
10
Stock TickerINMD
11
Perpetuity growth rate2%
12
Discount rate10%
13
Current Entreprise Value789
14
15
16
10Y FCF CAGR
17
-15%-10%-5%
18
19
Base FCF150109%84%64%
20
158103%80%61%
21
16798%76%57%
22
23
24
25
26
27
28
29
30
31
32
33
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