ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBABBBCBDBEBFBGBH
1
2
Model Introduction
3
1
4
Key Inputs1
5
Units ($ in thousands)
6
Company nameSnowflake
7
TickerSNOW
8
SectorCloud Data Storage
9
Valuation date8/3/2026
10
Stub period250.8%
11
Latest shares of outstanding329,300,000
12
Md-year conventionNo
13
Fiscal year end1/31/2023
14
First fiscal year end1/31/2024
15
Date of latest 10K filing1/31/2023
16
Date of latest 10Q filing10/31/2023
17
18
WACC Information
19
After tax cost of debt0.0%
20
Cost of equity8.47%
21
Weighted average cost of capital
8.98%
22
23
Final year multiples
24
EV/ Revenues2.80 X
25
EV/EBIT14.02 X
26
27
28
Other assumptions
29
Effective tax rate of Snowflake as of the latest filing
2.3%
30
Use growth or margins?
(Not used in this file)
Margins
31
32
33
Background and operations of Snowflake:
34
Snowflake provides a cloud based data platform for organizations, corporations, and enterprises both in the US and the
35
international market. The company offers Data Cloud, which enables customers to consolidate data and drive insights and
36
information about their businesses, industry and consumers. The platform also allows companies to build data driven
37
applications and share data and products.
38
Snowflake was founded in 2012 by three ex-Oracle data warehouse experts, Beniot Dageville, Thierry Cruanes, and Marcin
39
Zukowski. he company anointed Bob Muglia- a Microsoft executive- as its CEO, and successfully raised $26M in 2014,
40
and came out of stealth mode. Snowflake (SNOW) had its IPO on Sep 16, 2020, and by the end of its debut trading day, the
41
price was 112% more than its expected offering range of $100-$110/ share. The company sold nearly 28 million of its shares
42
and raked in $3.4B, making it one of the biggest software IPO ever.
43
44
45
46
47
Case Manager
48
49
Active CaseBase Case
50
51
52
Output:
53
Share price as of the valuation $ 197.85
54
 $ 196.71
55
Analysis Overvalued
56
Additional notes:
57
Some rows or columns may be hidden throughout the workbook.
58
These prices are based on my assumptions and what I think about the company. DCFs are extremely prone to
59
assumptions, and so my advice would be to put in what you think will happen and see what the value comes out to.
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