ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
2
3
4
5
Valuation
6
7
AssumptionsInputsScenarios
8
LowBaseHigh
9
Year 1 Revenue (USD)$1,248,848
10
Year 2 Revenue (USD)$17,616,851
11
Year 1 EBITDA (USD)$160,963
12
Year 2 EBITDA (USD)$14,049,166
13
Revenue Multiple (Base)
8 5 8 12
14
Discount Rate (%)40%45%40%35%
15
Terminal Margin (%)25%20%25%30%
16
FCF/TV Multiple 20 15 20 25
17
Comp Weight (%)50%
18
DCF Weight (%)30%
19
FCF Weight (%)20%
20
21
Valuation Outputs
22
LowBaseHigh
23
Comparable Valuation$88,084,254 $140,934,806 $211,402,209
24
Normalized FCF$3,523,370 $4,404,213 $5,285,055
25
FCF Valuation$52,850,552 $88,084,254 $132,126,381
26
DCF Valuation$0 $97,015,946 $0
27
Blended Valuation$54,612,237 $117,189,038 $132,126,381
28
29
Valuation
30
LowBaseHigh
31
Execution Probability (%)
20%30%40%
32
Time Discount (2 years)
50%
33
True Forward Value (USD)
$101,309,219
34
Valuation$10,130,922 $15,196,383 $20,261,844
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