Balance Sheet Snowflake Inc.

Equities

SNOW

US8334451098

IT Services & Consulting

Market Closed - Nyse Other stock markets 04:00:02 2024-09-06 pm EDT			5-day change	1st Jan Change
108.56 ^USD	-2.85%		-4.96%	-45.45%

Sep. 05	Transcript : Snowflake Inc. Presents at Citi's 2024 Global TMT Conference, Sep-05-2024 05:50 PM
Aug. 29	Tranche Update on Snowflake Inc.'s Equity Buyback Plan announced on March 1, 2023.	CI

3a.wSUg6paczlnb4OBpV-9hr705Y6lrYDdDZ-qJG2MLrSU.qVx4j-L5pQO3t5k_Dr8C5tlfVuwyIRomJKDeQ1Jn3VD0YGWw3c6FGqrQuQ

Published financial data: SNOWFLAKE INC.

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: January	2020	2021	2022	2023	2024
Revenues	265M	592M	1.22B	2.07B	2.81B
Total Revenues	265M	592M	1.22B	2.07B	2.81B
Cost of Goods Sold, Total	117M	243M	458M	718M	899M
Gross Profit	148M	349M	761M	1.35B	1.91B
Selling General & Admin Expenses, Total	401M	655M	1.01B	1.4B	1.71B
R&D Expenses	105M	238M	467M	788M	1.29B
Other Operating Expenses, Total	506M	893M	1.48B	2.19B	3B
Operating Income	-358M	-544M	-715M	-837M	-1.09B
Interest And Investment Income	11.55M	7.51M	9.13M	73.84M	201M
Net Interest Expenses	11.55M	7.51M	9.13M	73.84M	201M
Currency Exchange Gains (Loss)	-	-	1.33M	-1.13M	-1.92M
Other Non Operating Income (Expenses)	-1M	-610K	-	-	-
EBT, Excl. Unusual Items	-348M	-537M	-705M	-764M	-896M
Merger & Related Restructuring Charges	-	-	-	-5.3M	-
Gain (Loss) On Sale Of Investments	-	-	27.62M	-46.44M	46.81M
EBT, Incl. Unusual Items	-348M	-537M	-677M	-816M	-849M
Income Tax Expense	993K	2.06M	2.99M	-18.47M	-11.23M
Earnings From Continuing Operations	-349M	-539M	-680M	-798M	-838M
Net Income to Company	-349M	-539M	-680M	-798M	-838M
Minority Interest	-	-	-	821K	1.89M
Net Income - (IS)	-349M	-539M	-680M	-797M	-836M
Net Income to Common Incl Extra Items	-349M	-539M	-680M	-797M	-836M
Net Income to Common Excl. Extra Items	-349M	-539M	-680M	-797M	-836M
Per Share Items
Net EPS - Basic	-7.77	-3.81	-2.26	-2.5	-2.55
Basic EPS - Continuing Operations	-7.77	-3.81	-2.26	-2.5	-2.55
Basic Weighted Average Shares Outstanding	44.85M	142M	300M	319M	328M
Net EPS - Diluted	-7.77	-3.81	-2.26	-2.5	-2.55
Diluted EPS - Continuing Operations	-7.77	-3.81	-2.26	-2.5	-2.55
Diluted Weighted Average Shares Outstanding	44.85M	142M	300M	319M	328M
Normalized Basic EPS	-4.84	-2.37	-1.47	-1.5	-1.7
Normalized Diluted EPS	-4.84	-2.37	-1.47	-1.5	-1.7
Supplemental Items
EBITDA	-355M	-534M	-694M	-784M	-994M
EBITA	-358M	-541M	-707M	-798M	-1.01B
EBIT	-358M	-544M	-715M	-837M	-1.09B
EBITDAR	-328M	-507M	-664M	-742M	-941M
Effective Tax Rate - (Ratio)	-0.29	-0.38	-0.44	2.26	1.32
Current Domestic Taxes	194K	704K	288K	626K	754K
Current Foreign Taxes	1.4M	1.39M	3.42M	7.57M	14.78M
Total Current Taxes	1.59M	2.09M	3.7M	8.2M	15.53M
Deferred Domestic Taxes	-601K	-30K	-	-26.06M	-20.08M
Deferred Foreign Taxes	-	-	-717K	-607K	-6.69M
Total Deferred Taxes	-601K	-30K	-717K	-26.66M	-26.76M
Normalized Net Income	-217M	-336M	-440M	-477M	-558M
Supplemental Operating Expense Items
Advertising Expense	-	41M	-	-	-
Selling and Marketing Expenses	294M	479M	744M	1.11B	1.39B
General and Administrative Expenses	108M	149M	265M	291M	323M
Research And Development Expense From Footnotes	105M	238M	467M	788M	1.29B
Net Rental Expense, Total	26.69M	27.05M	29.05M	41.36M	52.62M
Stock-Based Comp., COGS (Total)	3.65M	33.64M	87.34M	106M	123M
Stock-Based Comp., R&D Exp. (Total)	15.74M	99.22M	233M	408M	645M
Stock-Based Comp., S&M Exp. (Total)	20.76M	97.88M	186M	247M	300M
Stock-Based Comp., G&A Exp. (Total)	38.25M	70.7M	98.92M	101M	100M
Total Stock-Based Compensation	78.4M	301M	605M	862M	1.17B

Fiscal Period: January	2020	2021	2022	2023	2024
Assets
Cash And Equivalents	127M	820M	1.09B	940M	1.76B
Short Term Investments	307M	3.09B	2.77B	3.07B	2.08B
Total Cash And Short Term Investments	434M	3.91B	3.85B	4.01B	3.85B
Accounts Receivable, Total	179M	294M	546M	716M	927M
Other Receivables	-	-	14.1M	19.4M	24.2M
Total Receivables	179M	294M	560M	735M	951M
Prepaid Expenses	25.33M	66.2M	135M	174M	156M
Other Current Assets, Total	26.36M	32.37M	51.4M	67.9M	86.1M
Total Current Assets	665M	4.3B	4.6B	4.98B	5.04B
Gross Property Plant And Equipment	228M	255M	302M	395M	481M
Accumulated Depreciation	-4.93M	-6.45M	-13.75M	-26.95M	-44.64M
Net Property Plant And Equipment	223M	248M	288M	368M	436M
Long-term Investments	23.53M	1.21B	1.46B	1.28B	1.15B
Goodwill	7.05M	8.45M	8.45M	657M	976M
Other Intangibles, Total	4.8M	23.45M	44.6M	210M	395M
Deferred Charges Long-Term	69.52M	86.16M	125M	145M	187M
Other Long-Term Assets, Total	19.52M	47.82M	122M	80.92M	39.44M
Total Assets	1.01B	5.92B	6.65B	7.72B	8.22B
Liabilities
Accounts Payable, Total	8.49M	5.65M	13.44M	23.67M	51.72M
Accrued Expenses, Total	54.52M	97.8M	148M	198M	343M
Current Portion of Leases	18.09M	19.65M	25.1M	27.3M	33.94M
Current Income Taxes Payable	2.35M	4.5M	12.71M	20M	37.11M
Unearned Revenue Current, Total	327M	639M	1.16B	1.67B	2.2B
Other Current Liabilities	5.94M	23.02M	40.13M	50.93M	66.64M
Total Current Liabilities	416M	789M	1.4B	1.99B	2.73B
Long-Term Leases	193M	185M	181M	224M	254M
Unearned Revenue Non Current	2.91M	4.19M	11.18M	11.46M	14.4M
Other Non Current Liabilities	8.47M	6.92M	11.18M	24.37M	33.12M
Total Liabilities	621M	985M	1.6B	2.25B	3.03B
Preferred Stock Convertible	936M	-	-	-	-
Total Preferred Equity	936M	-	-	-	-
Common Stock, Total	6K	28K	31K	32K	34K
Additional Paid In Capital	155M	6.18B	6.98B	8.21B	9.33B
Retained Earnings	-700M	-1.24B	-1.92B	-2.72B	-4.08B
Treasury Stock	-	-	-	-	-67.14M
Comprehensive Income and Other	216K	439K	-16.29M	-38.27M	-8.22M
Total Common Equity	-545M	4.94B	5.05B	5.46B	5.18B
Minority Interest	-	-	-	12.18M	10.29M
Total Equity	392M	4.94B	5.05B	5.47B	5.19B
Total Liabilities And Equity	1.01B	5.92B	6.65B	7.72B	8.22B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	55.45M	289M	315M	325M	334M
ECS Total Common Shares Outstanding	55.45M	288M	312M	323M	334M
Book Value / Share	-9.82	17.15	16.16	16.88	15.51
Tangible Book Value	-557M	4.9B	5B	4.59B	3.81B
Tangible Book Value Per Share	-10.04	17.03	15.99	14.19	11.41
Total Debt	211M	205M	206M	252M	288M
Net Debt	-223M	-4.87B	-4.9B	-4.83B	-4.47B
Debt Equivalent Oper. Leases	213M	216M	232M	331M	421M
Minority Interest, Total (Incl. Fin. Div)	-	-	-	12.18M	10.29M
Account Code - Inventory Valuation	3	3	3	3	3
Machinery, Total	3.04M	10.44M	17.22M	34.85M	47.45M
Full Time Employees	-	2.5K	3.99K	5.88K	7K
Accumulated Allowance for Doubtful Accounts (Supple)	-	2.6M	1.3M	2.2M	2.5M

Fiscal Period: January	2020	2021	2022	2023	2024
Net Income	-349M	-539M	-680M	-797M	-836M
Depreciation & Amortization - CF	3.52M	7.03M	13.7M	14.54M	18.7M
Amortization of Goodwill and Intangible Assets - (CF)	-	2.8M	7.8M	38.8M	82.2M
Depreciation & Amortization, Total	3.52M	9.83M	21.5M	53.34M	101M
Amortization of Deferred Charges, Total - (CF)	16.99M	28.84M	37.88M	67.64M	93.79M
(Gain) Loss on Sale of Investments - (CF)	-5.46M	8.63M	20.38M	49.93M	-108M
Stock-Based Compensation (CF)	78.4M	301M	605M	862M	1.17B
Other Operating Activities, Total	29.19M	38.06M	36.85M	20.37M	39.13M
Change In Accounts Receivable	-117M	-116M	-252M	-167M	-212M
Change In Accounts Payable	1.12M	-2.88M	7.37M	8.02M	19.21M
Change in Unearned Revenues	223M	313M	526M	514M	528M
Change in Other Net Operating Assets	-57.87M	-86.82M	-214M	-65.83M	55.56M
Cash from Operations	-177M	-45.42M	110M	546M	848M
Capital Expenditure	-18.58M	-35.04M	-16.22M	-25.13M	-35.09M
Cash Acquisitions	-6.31M	-6.04M	-	-363M	-276M
Sale (Purchase) of Intangible assets	-4.26M	-13.67M	-37.11M	-24.71M	-62.88M
Investment in Marketable and Equity Securities, Total	168M	-3.98B	32.53M	-185M	1.21B
Cash from Investing	138M	-4.04B	-20.8M	-598M	832M
Long-Term Debt Issued, Total	-	2.09M	-	-	-
Total Debt Issued	-	2.09M	-	-	-
Issuance of Common Stock	33.74M	4.3B	179M	80.82M	118M
Repurchase of Common Stock	-391K	-	-	-185M	-973M
Issuance of Preferred Stock	24.12M	479M	-	-	-
Other Financing Activities, Total	-	-1.19M	-1.06M	11.2M	-
Cash from Financing	57.47M	4.78B	178M	-92.62M	-854M
Foreign Exchange Rate Adjustments	-	-11K	-236K	-933K	-2.03M
Net Change in Cash	19.41M	693M	267M	-146M	824M
Supplemental Items
Cash Income Tax Paid (Refund)	1.43M	1.2M	1.48M	6.55M	12.45M
Levered Free Cash Flow	-31.16M	161M	413M	774M	1.1B
Unlevered Free Cash Flow	-31.16M	161M	413M	774M	1.1B
Change In Net Working Capital	-117M	-210M	-248M	-364M	-515M
Net Debt Issued / Repaid	-	2.09M	-	-	-

Fiscal Period: January	2020	2021	2022	2023	2024
Profitability
Return on Assets	-25.19	-9.8	-7.11	-7.28	-8.58
Return on Total Capital	-36.75	-11.84	-8.6	-9.53	-12.22
Return On Equity %	-70.4	-20.24	-13.62	-15.17	-15.72
Return on Common Equity	81.32	-24.55	-13.62	-15.17	-15.72
Margin Analysis
Gross Profit Margin %	55.97	59.03	62.4	65.26	67.98
SG&A Margin	151.51	110.71	82.75	67.63	61.1
EBITDA Margin %	-133.93	-90.21	-56.88	-37.94	-35.41
EBITA Margin %	-135.26	-91.4	-58	-38.64	-36.08
EBIT Margin %	-135.26	-91.87	-58.64	-40.52	-39.01
Income From Continuing Operations Margin %	-131.65	-91.06	-55.76	-38.61	-29.86
Net Income Margin %	-131.65	-91.06	-55.76	-38.57	-29.79
Net Avail. For Common Margin %	-131.65	-91.06	-55.76	-38.57	-29.79
Normalized Net Income Margin	-82.05	-56.69	-36.12	-23.08	-19.89
Levered Free Cash Flow Margin	-11.77	27.24	33.84	37.45	39.03
Unlevered Free Cash Flow Margin	-11.77	27.24	33.84	37.45	39.03
Asset Turnover
Asset Turnover	0.3	0.17	0.19	0.29	0.35
Fixed Assets Turnover	2.15	2.52	4.55	6.3	6.98
Receivables Turnover (Average Receivables)	2.18	2.5	2.9	3.28	3.42
Short Term Liquidity
Current Ratio	1.6	5.45	3.29	2.5	1.85
Quick Ratio	1.47	5.32	3.16	2.38	1.76
Operating Cash Flow to Current Liabilities	-0.42	-0.06	0.08	0.27	0.31
Days Sales Outstanding (Average Receivables)	167.38	146.35	125.67	111.45	106.82
Average Days Payable Outstanding	26.22	10.66	7.6	9.44	15.31
Long Term Solvency
Total Debt/Equity	53.93	4.14	4.09	4.6	5.55
Total Debt / Total Capital	35.04	3.98	3.93	4.4	5.26
LT Debt/Equity	49.31	3.75	3.59	4.1	4.89
Long-Term Debt / Total Capital	32.04	3.6	3.45	3.92	4.64
Total Liabilities / Total Assets	61.32	16.64	24.07	29.18	36.88
Total Debt / EBITDA	-0.64	-0.4	-0.31	-0.34	-0.31
Net Debt / EBITDA	0.68	9.6	7.38	6.51	4.75
Total Debt / (EBITDA - Capex)	-0.61	-0.38	-0.3	-0.33	-0.29
Net Debt / (EBITDA - Capex)	0.64	8.98	7.2	6.29	4.58
Growth Over Prior Year
Total Revenues, 1 Yr. Growth %	173.88	123.63	105.95	69.41	35.86
Gross Profit, 1 Yr. Growth %	229.95	135.82	117.73	77.18	41.53
EBITDA, 1 Yr. Growth %	92.59	50.64	29.85	12.31	26.83
EBITA, 1 Yr. Growth %	93.08	51.5	30.69	12.86	26.86
EBIT, 1 Yr. Growth %	93.08	51.9	31.46	17.05	30.8
Earnings From Cont. Operations, 1 Yr. Growth %	95.78	54.68	26.13	17.29	5.07
Net Income, 1 Yr. Growth %	95.78	54.68	26.13	17.17	4.94
Normalized Net Income, 1 Yr. Growth %	96.12	54.53	31.2	8.28	17.05
Diluted EPS Before Extra, 1 Yr. Growth %	66.59	-51.02	-40.52	10.39	1.98
Accounts Receivable, 1 Yr. Growth %	183.24	63.84	85.58	31.19	29.49
Net Property, Plant and Equip., 1 Yr. Growth %	880.45	12.45	15.92	27.76	18.6
Total Assets, 1 Yr. Growth %	32.5	484.74	12.29	16.13	6.49
Tangible Book Value, 1 Yr. Growth %	78.12	-977.71	1.86	-8.15	-16.98
Common Equity, 1 Yr. Growth %	74.34	-1.01K	2.28	8.07	-5.06
Cash From Operations, 1 Yr. Growth %	22.62	-74.28	-342.59	395.23	55.44
Capital Expenditures, 1 Yr. Growth %	802.96	88.54	-53.7	54.91	39.63
Levered Free Cash Flow, 1 Yr. Growth %	-	-617.47	155.91	87.45	41.61
Unlevered Free Cash Flow, 1 Yr. Growth %	-	-617.47	155.91	87.45	41.61
Compound Annual Growth Rate Over Two Years
Total Revenues, 2 Yr. CAGR %	-	147.48	114.61	86.79	51.71
Gross Profit, 2 Yr. CAGR %	-	178.94	126.6	96.41	58.35
EBITDA, 2 Yr. CAGR %	-	70.33	39.86	20.8	19.35
EBITA, 2 Yr. CAGR %	-	70.81	40.71	21.45	19.66
EBIT, 2 Yr. CAGR %	-	71.26	41.31	24.05	23.74
Earnings From Cont. Operations, 2 Yr. CAGR %	-	74.02	39.67	21.63	11.02
Net Income, 2 Yr. CAGR %	-	74.02	39.67	21.57	10.89
Normalized Net Income, 2 Yr. CAGR %	-	74.09	42.38	19.19	12.58
Diluted EPS Before Extra, 2 Yr. CAGR %	-	-9.66	-46.02	-18.97	6.1
Accounts Receivable, 2 Yr. CAGR %	-	115.42	74.37	56.03	30.34
Net Property, Plant and Equip., 2 Yr. CAGR %	-	230.41	14.17	21.7	23.1
Total Assets, 2 Yr. CAGR %	-	178.35	156.25	14.2	11.2
Tangible Book Value, 2 Yr. CAGR %	-	296.17	199.01	-3.27	-12.68
Common Equity, 2 Yr. CAGR %	-	297.47	204.44	5.13	1.29
Cash From Operations, 2 Yr. CAGR %	-	-43.84	-21	246.61	177.45
Capital Expenditures, 2 Yr. CAGR %	-	312.61	-6.57	-15.31	47.07
Levered Free Cash Flow, 2 Yr. CAGR %	-	-	263.91	119.02	62.92
Unlevered Free Cash Flow, 2 Yr. CAGR %	-	-	263.91	119.02	62.92
Compound Annual Growth Rate Over Three Years