Cash flow Etsy, Inc.

Equities

ETSY

US29786A1060

Department Stores

Market Closed - Nasdaq Other stock markets 04:00:00 2024-09-17 pm EDT			5-day change	1st Jan Change
54.09 ^USD	+0.39%		+2.87%	-33.26%

Sep. 10	Transcript : Etsy, Inc. Presents at Goldman Sachs Communacopia + Technology Conference 2024, Sep-10-2024 08:50 AM
Sep. 09	The market burns its idols

aeb4215d.R71XRwQHzcMjZrOfYIP_o7KEeO6GxsIygbat03BbF6Q.FvAVLU5r_aQXEsXVMveX1cjbS4bMvKpq6fXmnUMxVeAi9z0OaEiXtXQf9g

Published financial data: ETSY, INC.

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: December	2019	2020	2021	2022	2023
Revenues	818M	1.73B	2.33B	2.57B	2.75B
Total Revenues	818M	1.73B	2.33B	2.57B	2.75B
Cost of Goods Sold, Total	271M	465M	655M	745M	823M
Gross Profit	547M	1.26B	1.67B	1.82B	1.93B
Selling General & Admin Expenses, Total	333M	655M	901M	1.02B	1.09B
R&D Expenses	122M	180M	272M	412M	456M
Other Operating Expenses, Total	455M	835M	1.17B	1.43B	1.55B
Operating Income	92.68M	426M	502M	389M	376M
Interest Expense, Total	-24.32M	-42.02M	-9.88M	-14.17M	-14.04M
Interest And Investment Income	13.2M	7.1M	2.14M	10.96M	36M
Net Interest Expenses	-11.12M	-34.92M	-7.75M	-3.21M	21.96M
Currency Exchange Gains (Loss)	3.01M	-6.52M	13.67M	-206K	-6.35M
Other Non Operating Income (Expenses)	-	-	-	-	-
EBT, Excl. Unusual Items	84.56M	384M	508M	386M	391M
Restructuring Charges	-	-	-	-	-26.58M
Merger & Related Restructuring Charges	-3.92M	-1.8M	-36.7M	-2.83M	-1.2M
Impairment of Goodwill	-	-	-	-1.05B	-
Gain (Loss) On Sale Of Assets	-	-	-	-	-2.63M
Asset Writedown	-	-	-	-	-68.09M
Other Unusual Items	-	-16.86M	-	-	-
EBT, Incl. Unusual Items	80.65M	366M	472M	-662M	293M
Income Tax Expense	-15.25M	16.46M	-21.85M	32.31M	-14.75M
Earnings From Continuing Operations	95.89M	349M	494M	-694M	308M
Net Income to Company	95.89M	349M	494M	-694M	308M
Net Income - (IS)	95.89M	349M	494M	-694M	308M
Preferred Dividend and Other Adjustments	-	-	-	-	-
Net Income to Common Incl Extra Items	95.89M	349M	494M	-694M	308M
Net Income to Common Excl. Extra Items	95.89M	349M	494M	-694M	308M
Per Share Items
Net EPS - Basic	0.8	2.88	3.88	-5.48	2.51
Basic EPS - Continuing Operations	0.8	2.88	3.88	-5.48	2.51
Basic Weighted Average Shares Outstanding	120M	121M	127M	127M	123M
Net EPS - Diluted	0.76	2.69	3.4	-5.48	2.24
Diluted EPS - Continuing Operations	0.76	2.69	3.4	-5.48	2.24
Diluted Weighted Average Shares Outstanding	126M	136M	147M	127M	140M
Normalized Basic EPS	0.44	1.98	2.5	1.9	2
Normalized Diluted EPS	0.42	1.76	2.17	1.9	1.75
American Depositary Receipts Ratio (ADR)	0.07	0.07	0.07	0.07	0.07
Supplemental Items
EBITDA	118M	451M	547M	449M	433M
EBITA	102M	441M	531M	431M	415M
EBIT	92.68M	426M	502M	389M	376M
EBITDAR	125M	458M	554M	458M	441M
Effective Tax Rate - (Ratio)	-18.91	4.5	-4.63	-4.88	-5.04
Current Domestic Taxes	-2.91M	8.81M	35.87M	62.74M	8.1M
Current Foreign Taxes	352K	5.46M	31.23M	24.88M	27.24M
Total Current Taxes	-2.56M	14.26M	67.1M	87.61M	35.34M
Deferred Domestic Taxes	-21.3M	-12.23M	-68.17M	-26.62M	-15.75M
Deferred Foreign Taxes	8.61M	14.43M	-20.78M	-28.68M	-34.34M
Total Deferred Taxes	-12.69M	2.2M	-88.95M	-55.3M	-50.09M
Normalized Net Income	52.85M	240M	318M	241M	245M
Interest on Long-Term Debt	24.3M	42.02M	9.49M	13.78M	13.58M
Supplemental Operating Expense Items
Marketing Expenses	216M	496M	643M	691M	733M
Selling and Marketing Expenses	216M	501M	655M	710M	756M
General and Administrative Expenses	111M	147M	238M	300M	330M
Research And Development Expense From Footnotes	146M	213M	302M	450M	504M
Net Rental Expense, Total	6.55M	7.17M	7.51M	9.47M	8.22M
Imputed Operating Lease Interest Expense	2.21M	2.4M	332K	441K	379K
Imputed Operating Lease Depreciation	4.35M	4.77M	7.18M	9.03M	7.84M
Stock-Based Comp., COGS (Total)	-	7.73M	13.08M	23.28M	31.25M
Stock-Based Comp., R&D Exp. (Total)	-	33.03M	58.9M	125M	146M
Stock-Based Comp., S&M Exp. (Total)	-	5.18M	11.34M	19.57M	22.78M
Stock-Based Comp., G&A Exp. (Total)	-	19.17M	56.59M	63.48M	84.51M
Stock-Based Comp., Other (Total)	44.4M	-	-	-	-
Total Stock-Based Compensation	44.4M	65.11M	140M	231M	285M

Fiscal Period: December	2019	2020	2021	2022	2023
Assets
Cash And Equivalents	443M	1.24B	780M	921M	914M
Short Term Investments	374M	425M	204M	250M	236M
Total Cash And Short Term Investments	817M	1.67B	985M	1.17B	1.15B
Accounts Receivable, Total	15.39M	22.6M	27.27M	27.89M	24.73M
Total Receivables	15.39M	22.6M	27.27M	27.89M	24.73M
Prepaid Expenses	38.61M	56.15M	109M	80.2M	130M
Deferred Tax Assets Current	-	-	-	-	-
Other Current Assets, Total	49.79M	147M	220M	234M	265M
Total Current Assets	921M	1.89B	1.34B	1.51B	1.57B
Gross Property Plant And Equipment	183M	178M	478M	493M	536M
Accumulated Depreciation	-63.27M	-145M	-157M	-204M	-244M
Net Property Plant And Equipment	120M	32.89M	321M	289M	292M
Long-term Investments	89.34M	39.09M	85.03M	29.14M	86.68M
Goodwill	139M	141M	1.37B	138M	138M
Other Intangibles, Total	249M	287M	607M	535M	457M
Deferred Tax Assets Long-Term	14.26M	115K	95.86M	122M	138M
Deferred Charges Long-Term	-	-	-	-	-
Other Long-Term Assets, Total	10.52M	10.18M	10.16M	8.92M	3.04M
Total Assets	1.54B	2.4B	3.83B	2.63B	2.69B
Liabilities
Accounts Payable, Total	26.32M	40.88M	28.01M	28.76M	29.92M
Accrued Expenses, Total	88.34M	123M	182M	192M	192M
Current Portion of Leases	12.41M	13.05M	6.44M	8.96M	11.02M
Current Income Taxes Payable	-	-	9.69M	10.13M	10.62M
Unearned Revenue Current, Total	7.62M	11.26M	12.34M	14.01M	14.64M
Other Current Liabilities	53.83M	267M	377M	378M	452M
Total Current Liabilities	189M	455M	616M	632M	711M
Long-Term Debt	785M	1.06B	2.28B	2.28B	2.28B
Long-Term Leases	75.93M	62.18M	154M	144M	141M
Deferred Tax Liability Non Current	64.5M	58.48M	79.48M	44.74M	13.19M
Other Non Current Liabilities	21.63M	24.44M	78.67M	82.32M	80.6M
Total Liabilities	1.14B	1.66B	3.2B	3.18B	3.23B
Preferred Stock Convertible	-	-	-	-	-
Preferred Stock - Others	-	-	-	-	-
Total Preferred Equity	-	-	-	-	-
Common Stock, Total	119K	126K	127K	125K	119K
Additional Paid In Capital	643M	883M	632M	815M	1.08B
Retained Earnings	-227M	-147M	71.74M	-1.05B	-1.36B
Comprehensive Income and Other	-8.7M	5.95M	-75.01M	-314M	-267M
Total Common Equity	407M	742M	629M	-547M	-544M
Total Equity	407M	742M	629M	-547M	-544M
Total Liabilities And Equity	1.54B	2.4B	3.83B	2.63B	2.69B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	118M	126M	127M	125M	118M
ECS Total Common Shares Outstanding	118M	126M	127M	125M	119M
Book Value / Share	3.44	5.9	4.95	-4.38	-4.57
Tangible Book Value	19.27M	315M	-1.35B	-1.22B	-1.14B
Tangible Book Value Per Share	0.16	2.5	-10.63	-9.76	-9.57
Total Debt	873M	1.14B	2.44B	2.43B	2.44B
Net Debt	56.22M	-532M	1.45B	1.26B	1.29B
Debt Equivalent Oper. Leases	52.43M	57.35M	60.1M	75.77M	65.74M
Account Code - Inventory Valuation	3	3	3	3	3
Buildings, Total	-	66.65M	133M	133M	133M
Machinery, Total	12.79M	40.15M	15.21M	24.22M	29.54M
Full Time Employees	1.24K	1.41K	2.4K	2.79K	2.42K
Assets under Capital Lease - Gross	-	-	-	-	-
Assets under Capital Lease - Accumulated Depreciation	-	-	-	-	-
Accumulated Allowance for Doubtful Accounts (Supple)	5.03M	9.76M	7.73M	8.3M	10.15M

Fiscal Period: December	2019	2020	2021	2022	2023
Net Income	95.89M	349M	494M	-694M	308M
Depreciation & Amortization - CF	15.89M	10.29M	15.87M	18.1M	17.32M
Amortization of Goodwill and Intangible Assets - (CF)	9.6M	15.2M	28.4M	41.3M	39.7M
Depreciation & Amortization, Total	25.49M	25.49M	44.27M	59.4M	57.02M
Amortization of Deferred Charges, Total - (CF)	24.54M	35.45M	33.72M	37.3M	34.3M
(Gain) Loss From Sale Of Asset	1.67M	-795K	-	-	2.63M
Asset Writedown & Restructuring Costs	-	-	-	1.05B	68.09M
Stock-Based Compensation (CF)	44.4M	65.11M	140M	231M	285M
Tax Benefit from Stock Options	-	-	-	-	-
Provision and Write-off of Bad Debts	10.96M	15.03M	16.03M	12.46M	19.63M
Other Operating Activities, Total	-6.03M	65.22M	-99.77M	-47.64M	-44.59M
Change In Accounts Receivable	-12.66M	-22.54M	-19.26M	-14.06M	-16.07M
Change In Accounts Payable	-953K	14.55M	-14.17M	532K	2.58M
Change in Unearned Revenues	191K	3.31M	1.44M	1.9M	457K
Change in Other Net Operating Assets	23.41M	129M	55.87M	52.08M	-10.68M
Cash from Operations	207M	679M	652M	684M	706M
Capital Expenditure	-9.49M	-2.32M	-13.18M	-16.69M	-12.94M
Cash Acquisitions	-270M	-	-1.7B	-	-
Sale (Purchase) of Intangible assets	-7.75M	-5.66M	-16.92M	-20.51M	-26.97M
Investment in Marketable and Equity Securities, Total	-201M	-3.39M	172M	7.18M	-33.4M
Other Investing Activities, Total	-	-	-	-	-
Cash from Investing	-488M	-11.38M	-1.56B	-30.02M	-73.31M
Long-Term Debt Issued, Total	650M	650M	1B	-	-
Total Debt Issued	650M	650M	1B	-	-
Long-Term Debt Repaid, Total	-10.83M	-146M	-52.76M	-6.35M	-6.37M
Total Debt Repaid	-10.83M	-146M	-52.76M	-6.35M	-6.37M
Issuance of Common Stock	9.79M	25.32M	22.71M	15.02M	14.23M
Repurchase of Common Stock	-210M	-316M	-421M	-505M	-660M
Other Financing Activities, Total	-79.82M	-93.29M	-96.25M	-10.27M	-3.98M
Cash from Financing	360M	119M	453M	-506M	-657M
Foreign Exchange Rate Adjustments	-1.85M	13.95M	-10.23M	-6.02M	12.03M
Net Change in Cash	76.31M	801M	-464M	141M	-12.3M
Supplemental Items
Cash Interest Paid	3.21M	3.4M	6.05M	9.53M	9.32M
Cash Income Tax Paid (Refund)	2.08M	8.54M	94.16M	41.68M	42.66M
Levered Free Cash Flow	140M	502M	532M	553M	561M
Unlevered Free Cash Flow	153M	525M	534M	562M	570M
Change In Net Working Capital	-20.16M	-144M	-36.22M	-28.48M	981K
Net Debt Issued / Repaid	639M	504M	947M	-6.35M	-6.37M

Fiscal Period: December	2019	2020	2021	2022	2023
Profitability
Return on Assets	4.74	13.49	10.07	7.52	8.83
Return on Total Capital	5.9	16.84	12.7	9.83	12.43
Return On Equity %	23.75	60.79	71.99	-1.71K	-56.38
Return on Common Equity	23.75	60.79	71.99	-1.71K	-56.38
Margin Analysis
Gross Profit Margin %	66.88	73.07	71.9	70.98	70.05
SG&A Margin	40.66	37.96	38.67	39.74	39.8
EBITDA Margin %	14.44	26.15	23.47	17.49	15.74
EBITA Margin %	12.5	25.56	22.79	16.78	15.11
EBIT Margin %	11.32	24.68	21.57	15.17	13.67
Income From Continuing Operations Margin %	11.72	20.24	21.19	-27.06	11.19
Net Income Margin %	11.72	20.24	21.19	-27.06	11.19
Net Avail. For Common Margin %	11.72	20.24	21.19	-27.06	11.19
Normalized Net Income Margin	6.46	13.92	13.64	9.4	8.9
Levered Free Cash Flow Margin	17.12	29.07	22.83	21.56	20.41
Unlevered Free Cash Flow Margin	18.73	30.43	22.94	21.91	20.73
Asset Turnover
Asset Turnover	0.67	0.87	0.75	0.79	1.03
Fixed Assets Turnover	7.82	34.61	10.28	8.42	9.47
Receivables Turnover (Average Receivables)	59.24	90.84	93.41	93.05	104.46
Short Term Liquidity
Current Ratio	4.89	4.17	2.18	2.4	2.21
Quick Ratio	4.42	3.72	1.64	1.9	1.65
Operating Cash Flow to Current Liabilities	1.1	1.49	1.06	1.08	0.99
Days Sales Outstanding (Average Receivables)	6.16	4.03	3.91	3.92	3.49
Average Days Payable Outstanding	35.6	26.46	19.21	13.91	13.01
Long Term Solvency
Total Debt/Equity	214.8	153.22	387.5	-444.46	-447.95