ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBHBIBJ
1
ZMthousandsQ2 2021Q3 2021Q4 2021Q1 2022Q2 2022Q3 2022Q4 20222022Run-RateRun Rate
2
CAC 18,420
2022 S&M (6 mos lag)/Enterprise cust net adds
Total Revenue663,520777,196882,485956,2371,021,4951,050,7561,071,3764,099,8644,285,50416,399,456
3
ARPU (per month) 851
2022 Rev from enterprise cust/Enterprise cust
Revenue share enterprise customers
42%44%44%45%46%49%50%48%50%48%
4
Churn (per month)-2.50%
>130% Net Dollar Expansion 12 quarters in a row
Revenue enterprise customers278,678341,966388,293430,307469,888514,870535,6881,950,7532,142,7527,803,011
5
Gross Margin74%
2022 Reported
6
Annual Discount Rate15%my hurdleSales & Marketing159,173190,157214,018245,667271,179293,698325,415921,0211,084,7161,174,792
7
COGS (per month)219
Attributed to enterprise customers
159,173190,157214,018245,667271,179293,698325,415921,0211,084,7161,174,792
8
Monthly Discount Rate1.17%% of revs24%24%24%26%27%28%30%100%100%15%
9
10
LTV per subscriber 56,524 Enterprise customers100122141160173184191
11
LTV:CAC 3.07 Net Adds23221919131175028200
12
CAC/ARPU*GM (payback period months)
29.1
13
NPV per user 39,265
14
IRR5.22%
Excludes last period with terminal value
15
16
Time 0Year12345
17
JanFebMarAprMayJuneJulyAugustSeptemberOctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJuneJulyAugust
September
OctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJuneJulyAugust
September
OctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJuneJulyAugust
September
OctoberNovemberDecemberJanuaryFebruaryMarchAprilMayJuneJulyAugust
September
OctoberNovemberDecember
18
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960
19
CAC-18,420000000000000000000000000000000000000000000000000000000000000
20
ARPU851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851851
21
COGS-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219-219
22
Monthly Cash Flow-18,420632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632632
23
Remaining fraction of users100%103%105%108%110%113%116%119%122%125%128%131%134%138%141%145%148%152%156%160%164%168%172%176%181%185%190%195%200%205%210%215%220%226%232%237%243%249%256%262%269%275%282%289%296%304%311%319%327%335%344%352%361%370%379%389%399%409%419%429%
24
Net Cash Flow-18,42063264866468169871573375277079080983085087289491693996298610111036106210891116114411721202123212631294132613601394142814641501153815771616165716981740178418291874192119692018206921212174222822842341239924592521258426482714
25
Present Value625633642650659667676685694703712722731741750760770780790801811822833844855866877889901912924937949961974987100010131026104010531067108110951110112411391154116911851200121612321248126412811298131513321350
26
Discounted Revenue as % of starting value
99%100%101%103%104%106%107%108%110%111%113%114%116%117%119%120%122%123%125%127%128%130%132%133%135%137%139%141%142%144%146%148%150%152%154%156%158%160%162%164%167%169%171%173%175%178%180%182%185%187%190%192%195%197%200%203%205%208%211%213%
27
Sum of PV 56,524
28
Less: Initial Outlay (CAC) (18,420)
29
NPV excluding residual value 38,104
30
31
ROI207%
32
33
Residual Value Calculation
34
K 48,046
35
Discounted Residual Value 1,161
36
NPV 39,265
37
38
39
Total Customers 191,000
40
NPV/Customer 39,265
41
Present value of current customer base
7,499,599,245
42
Multiple16.67
43
Capitalization 125,018,319,407
44
45
Market Cap 25,364,768,175
46
Cash5,419,000,000
47
Debt85,000,000
48
Enterprise Value20,030,768,175
49
Under(over) valued524%
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