Balance Sheet Coupang, Inc.

Equities

CPNG

US22266T1097

Department Stores

Market Closed - Nyse Other stock markets 16:00:02 2024-09-17 EDT			5-day change	1st Jan Change
24.24 ^USD	+1.21%		+5.39%	+49.72%

09-11	Coupang Files Lawsuit Against FTC's KRW162.8 Billion Fine over Search Algorithm Manipulation	MT
09-10	Coupang Launches Pet Fair, Offering Discounts on Pet Supplies	MT

7d0425.RbPZzLPT3V_jEadR2giYJ8lDrbeQAnV6TXwXW8Hislk.Eeuj9OWYjBOyWJAakHjZQ413ndryZlhCNzIlbYapwBothJS54ZXuNrVm8g

Published financial data: COUPANG, INC.

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: December	2019	2020	2021	2022	2023
Revenues	5.79B	11.05B	16.49B	18.34B	21.22B
Other Revenues, Total	486M	922M	1.92B	2.24B	3.16B
Total Revenues	6.27B	11.97B	18.41B	20.58B	24.38B
Cost of Goods Sold, Total	5.24B	9.98B	15.3B	15.87B	18.19B
Gross Profit	1.03B	1.99B	3.11B	4.71B	6.19B
Selling General & Admin Expenses, Total	1.68B	2.51B	4.31B	4.82B	5.72B
Other Operating Expenses, Total	1.68B	2.51B	4.31B	4.82B	5.72B
Operating Income	-644M	-528M	-1.2B	-112M	473M
Interest Expense, Total	-96.91M	-108M	-45.36M	-27.17M	-48M
Interest And Investment Income	19.14M	10.99M	8.64M	52.8M	178M
Net Interest Expenses	-77.77M	-96.77M	-36.71M	25.63M	130M
Currency Exchange Gains (Loss)	23.28M	2.44M	-2.93M	9.23M	-
Other Non Operating Income (Expenses)	-1.11M	150M	-7.98M	-15.94M	-19M
EBT, Excl. Unusual Items	-699M	-472M	-1.25B	-93.1M	584M
Gain (Loss) On Sale Of Assets	398K	-2.37M	-	-	-
Other Unusual Items	-	-	-296M	-	-
EBT, Incl. Unusual Items	-699M	-475M	-1.54B	-93.1M	584M
Income Tax Expense	-241K	292K	1M	-1.06M	-776M
Earnings From Continuing Operations	-699M	-475M	-1.54B	-92.04M	1.36B
Net Income to Company	-699M	-475M	-1.54B	-92.04M	1.36B
Net Income - (IS)	-699M	-475M	-1.54B	-92.04M	1.36B
Preferred Dividend and Other Adjustments	71.42M	92.73M	-	-	-
Net Income to Common Incl Extra Items	-770M	-568M	-1.54B	-92.04M	1.36B
Net Income to Common Excl. Extra Items	-770M	-568M	-1.54B	-92.04M	1.36B
Per Share Items
Net EPS - Basic	-11.14	-7.23	-1.08	-0.05	0.76
Basic EPS - Continuing Operations	-11.14	-7.23	-1.08	-0.05	0.76
Basic Weighted Average Shares Outstanding	69.12M	78.54M	1.42B	1.76B	1.78B
Net EPS - Diluted	-11.14	-7.23	-1.08	-0.05	0.75
Diluted EPS - Continuing Operations	-11.14	-7.23	-1.08	-0.05	0.75
Diluted Weighted Average Shares Outstanding	69.12M	78.54M	1.42B	1.76B	1.8B
Normalized Basic EPS	-6.32	-3.76	-0.55	-0.03	0.2
Normalized Diluted EPS	-6.32	-3.76	-0.55	-0.03	0.2
Supplemental Items
EBITDA	-573M	-400M	-996M	119M	748M
EBITA	-644M	-528M	-1.2B	-112M	473M
EBIT	-644M	-528M	-1.2B	-112M	473M
EBITDAR	-441M	-203M	-618M	568M	1.25B
Total Revenues (As Reported)	6.27B	11.97B	18.41B	20.58B	24.38B
Effective Tax Rate - (Ratio)	0.03	-0.06	-0.06	1.14	-132.88
Current Domestic Taxes	-641K	-	2K	3K	62M
Current Foreign Taxes	400K	292K	1M	39.4M	46M
Total Current Taxes	-241K	292K	1M	39.4M	108M
Deferred Domestic Taxes	-	-	-	-40.46M	21M
Deferred Foreign Taxes	-	-	-	-	-905M
Total Deferred Taxes	-	-	-	-40.46M	-884M
Normalized Net Income	-437M	-295M	-778M	-58.19M	365M
Interest on Long-Term Debt	75.9M	91M	20M	-	-
Non-Cash Pension Expense	-	-	7.43M	17.87M	18M
Supplemental Operating Expense Items
Advertising Expense	252M	128M	-	-	-
Selling and Marketing Expenses	252M	128M	-	-	-
Net Rental Expense, Total	132M	197M	379M	450M	499M
Imputed Operating Lease Interest Expense	92.45M	96.52M	63.1M	43.2M	73.85M
Imputed Operating Lease Depreciation	39.25M	100M	316M	406M	425M
Stock-Based Comp., COGS (Total)	483K	677K	10.98M	15.92M	14M
Stock-Based Comp., SG&A Exp. (Total)	22.25M	42.39M	238M	246M	312M
Total Stock-Based Compensation	22.74M	43.07M	249M	262M	326M

Fiscal Period: December	2019	2020	2021	2022	2023
Assets
Cash And Equivalents	1.22B	1.25B	3.49B	3.51B	5.24B
Short Term Investments	-	-	-	17.75M	-
Total Cash And Short Term Investments	1.22B	1.25B	3.49B	3.53B	5.24B
Accounts Receivable, Total	63.85M	71.26M	175M	184M	314M
Total Receivables	63.85M	71.26M	175M	184M	314M
Inventory	632M	1.16B	1.42B	1.66B	1.67B
Prepaid Expenses	-	-	-	285M	316M
Restricted Cash	144M	145M	320M	176M	353M
Other Current Assets, Total	93.04M	212M	232M	-	-
Total Current Assets	2.16B	2.84B	5.64B	5.83B	7.89B
Gross Property Plant And Equipment	1.21B	2.36B	3.13B	3.76B	4.7B
Accumulated Depreciation	-207M	-336M	-409M	-539M	-637M
Net Property Plant And Equipment	1B	2.03B	2.72B	3.23B	4.07B
Goodwill	3.99M	4.25M	9.74M	-	-
Deferred Tax Assets Long-Term	-	-	-	-	925M
Other Long-Term Assets, Total	67.51M	193M	273M	458M	463M
Total Assets	3.23B	5.07B	8.64B	9.51B	13.35B
Liabilities
Accounts Payable, Total	1.59B	2.91B	3.44B	3.62B	5.1B
Accrued Expenses, Total	58.96M	116M	304M	299M	352M
Short-term Borrowings	323K	157M	7.81M	175M	282M
Current Portion of Long-Term Debt	14.38M	67.58M	342M	129M	203M
Current Portion of Leases	96.82M	210M	287M	326M	386M
Unearned Revenue Current, Total	28.91M	65.26M	93.97M	92.36M	97M
Other Current Liabilities	91.86M	210M	267M	419M	526M
Total Current Liabilities	1.88B	3.73B	4.74B	5.06B	6.94B
Long-Term Debt	769M	943M	283M	538M	529M
Long-Term Leases	396M	865M	1.2B	1.23B	1.39B
Other Non Current Liabilities	248M	130M	237M	265M	381M
Total Liabilities	3.29B	5.67B	6.47B	7.1B	9.24B
Preferred Stock Convertible	3.47B	3.47B	-	-	-
Total Preferred Equity	3.47B	3.47B	-	-	-
Common Stock, Total	-	54.95M	175K	177K	-
Additional Paid In Capital	25.04M	25.04M	7.87B	8.15B	8.49B
Retained Earnings	-3.57B	-4.12B	-5.65B	-5.74B	-4.38B
Comprehensive Income and Other	7.64M	-31.09M	-47.74M	2.22M	-17M
Total Common Equity	-3.53B	-4.07B	2.18B	2.41B	4.09B
Minority Interest	-	-	-	-	15M
Total Equity	-64.36M	-603M	2.18B	2.41B	4.1B
Total Liabilities And Equity	3.23B	5.07B	8.64B	9.51B	13.35B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	70.7M	106M	1.76B	1.77B	1.79B
ECS Total Common Shares Outstanding	70.7M	106M	1.75B	1.77B	1.79B
Book Value / Share	-49.97	-38.45	1.24	1.36	2.28
Tangible Book Value	-3.54B	-4.07B	2.17B	2.41B	4.09B
Tangible Book Value Per Share	-50.03	-38.49	1.23	1.36	2.28
Total Debt	1.28B	2.24B	2.12B	2.4B	2.79B
Net Debt	54.16M	990M	-1.37B	-1.13B	-2.46B
Debt Equivalent of Unfunded Proj. Benefit Obligation	-	165M	283M	304M	396M
Debt Equivalent Oper. Leases	1.05B	1.58B	3.03B	3.6B	3.99B
Minority Interest, Total (Incl. Fin. Div)	-	-	-	-	15M
Account Code - Inventory Valuation	6	6	6	6	6
Inventories - Finished Goods, Total	-	-	1.42B	1.66B	1.67B
Land - (BS)	94.12M	142M	141M	296M	323M
Buildings, Total	172M	182M	320M	303M	751M
Machinery, Total	344M	628M	720M	782M	993M
Full Time Employees	-	50K	68K	63K	78K

Fiscal Period: December	2019	2020	2021	2022	2023
Net Income	-699M	-475M	-1.54B	-92.04M	1.36B
Depreciation & Amortization - CF	70.91M	128M	201M	231M	275M
Depreciation & Amortization, Total	70.91M	128M	201M	231M	275M
Stock-Based Compensation (CF)	22.74M	43.07M	249M	262M	326M
Other Operating Activities, Total	236M	222M	750M	583M	-247M
Change In Accounts Receivable	-39.98M	-4.31M	-120M	-33.83M	-133M
Change In Inventories	-279M	-504M	-528M	-367M	-44M
Change In Accounts Payable	417M	1.07B	728M	444M	1.51B
Change in Unearned Revenues	7.75M	31.89M	14.02M	-	-
Change in Other Net Operating Assets	-47.97M	-206M	-163M	-462M	-399M
Cash from Operations	-312M	302M	-411M	565M	2.65B
Capital Expenditure	-218M	-485M	-674M	-824M	-896M
Sale of Property, Plant, and Equipment	3.54M	507K	1.86M	13.18M	19M
Other Investing Activities, Total	-3.94M	-36.53M	-3.73M	-37.17M	-50M
Cash from Investing	-218M	-521M	-676M	-848M	-927M
Short Term Debt Issued, Total	104M	145M	24.72M	177M	10M
Long-Term Debt Issued, Total	28.77M	142M	409M	524M	572M
Total Debt Issued	132M	287M	434M	701M	582M
Short Term Debt Repaid, Total	-346M	-2.98M	-166M	-24.82M	-
Long-Term Debt Repaid, Total	-3.71M	-37M	-170M	-446M	-392M
Total Debt Repaid	-350M	-39.98M	-336M	-471M	-392M
Issuance of Common Stock	1.52B	28.61M	3.49B	17.77M	9M
Repurchase of Common Stock	-115M	-97.04M	-	-	-
Other Financing Activities, Total	-	-	-14.76M	-	-
Cash from Financing	1.18B	179M	3.58B	247M	199M
Foreign Exchange Rate Adjustments	-22.41M	70.36M	-81.7M	-87.61M	-14M
Net Change in Cash	632M	29.77M	2.41B	-123M	1.91B
Supplemental Items
Cash Interest Paid	19.06M	23.66M	21.46M	19.34M	31M
Cash Income Tax Paid (Refund)	2.54M	857K	2.59M	5.91M	110M
Levered Free Cash Flow	-425M	161M	-772M	-247M	1.28B
Unlevered Free Cash Flow	-364M	228M	-743M	-230M	1.31B
Change In Net Working Capital	-162M	-872M	-228M	-171M	-1.31B
Net Debt Issued / Repaid	-218M	247M	98.06M	230M	190M

Fiscal Period: December	2019	2020	2021	2022	2023
Profitability
Return on Assets	-16.48	-7.95	-10.92	-0.77	2.59
Return on Total Capital	-57.82	-23.14	-25.26	-1.54	5.05
Return On Equity %	171.07	142.27	-196.17	-4.01	41.73
Return on Common Equity	24.43	14.93	162.99	-4.01	41.83
Margin Analysis
Gross Profit Margin %	16.47	16.6	16.89	22.88	25.39
SG&A Margin	26.73	21.01	23.4	23.43	23.45
EBITDA Margin %	-9.13	-3.34	-5.41	0.58	3.07
EBITA Margin %	-10.26	-4.41	-6.51	-0.54	1.94
EBIT Margin %	-10.26	-4.41	-6.51	-0.54	1.94
Income From Continuing Operations Margin %	-11.14	-3.97	-8.38	-0.45	5.58
Net Income Margin %	-11.14	-3.97	-8.38	-0.45	5.58
Net Avail. For Common Margin %	-12.28	-4.74	-8.38	-0.45	5.58
Normalized Net Income Margin	-6.97	-2.47	-4.23	-0.28	1.5
Levered Free Cash Flow Margin	-6.77	1.34	-4.19	-1.2	5.26
Unlevered Free Cash Flow Margin	-5.8	1.91	-4.04	-1.12	5.39
Asset Turnover
Asset Turnover	2.57	2.88	2.69	2.27	2.13
Fixed Assets Turnover	9.11	7.89	7.75	6.92	6.69
Receivables Turnover (Average Receivables)	128.93	163.5	133.72	101.93	85.23
Inventory Turnover (Average Inventory)	10.25	11.13	11.85	10.31	10.95
Short Term Liquidity
Current Ratio	1.15	0.76	1.19	1.15	1.14
Quick Ratio	0.68	0.35	0.77	0.73	0.8
Operating Cash Flow to Current Liabilities	-0.17	0.08	-0.09	0.11	0.38
Days Sales Outstanding (Average Receivables)	2.83	2.24	2.73	3.58	4.28
Days Outstanding Inventory (Average Inventory)	35.63	32.87	30.81	35.39	33.33
Average Days Payable Outstanding	92.42	78.32	74.5	80.04	87.44
Cash Conversion Cycle (Average Days)	-53.96	-43.21	-40.96	-41.07	-49.82
Long Term Solvency
Total Debt/Equity	-1.98K	-371.6	97.48	99.5	67.91
Total Debt / Total Capital	105.31	136.82	49.36	49.87	40.44
LT Debt/Equity	-1.81K	-299.69	68.22	73.39	46.69
Long-Term Debt / Total Capital	96.11	110.34	34.55	36.79	27.8
Total Liabilities / Total Assets	101.99	111.9	74.82	74.62	69.25
EBIT / Interest Expense	-6.64	-4.9	-26.41	-4.12	9.85
EBITDA / Interest Expense	-4.55	-1.89	-13.62	20.92	25.98
(EBITDA - Capex) / Interest Expense	-6.8	-6.38	-28.47	-9.42	7.31
Total Debt / EBITDA	-2.89	-11.03	-3.43	4.23	2.23
Net Debt / EBITDA	-0.12	-4.87	2.21	-1.98	-1.97
Total Debt / (EBITDA - Capex)	-1.94	-3.26	-1.64	-9.39	7.94
Net Debt / (EBITDA - Capex)	-0.08	-1.44	1.06	4.4	-7
Growth Over Prior Year
Total Revenues, 1 Yr. Growth %	54.76	90.77	53.8	11.82	18.46
Gross Profit, 1 Yr. Growth %	401.86	92.25	56.53	51.49	31.42
EBITDA, 1 Yr. Growth %	-42.64	-30.15	156.51	-111.94	528.57
EBITA, 1 Yr. Growth %	-38.82	-18.03	132.17	-90.65	-522.32
EBIT, 1 Yr. Growth %	-38.82	-18.03	132.17	-90.65	-522.32
Earnings From Cont. Operations, 1 Yr. Growth %	-36.33	-32.04	233.06	-94.03	-1.58K
Net Income, 1 Yr. Growth %	-36.33	-32.04	233.06	-94.03	-1.58K
Normalized Net Income, 1 Yr. Growth %	-36.13	-32.48	169.1	-92.53	-727.96
Diluted EPS Before Extra, 1 Yr. Growth %	-32.88	-35.14	-94.35	-95.19	-1.54K
Accounts Receivable, 1 Yr. Growth %	146.37	11.6	146.08	5.2	70.65
Inventory, 1 Yr. Growth %	61.48	83.81	22.42	16.56	0.54
Net Property, Plant and Equip., 1 Yr. Growth %	168.24	102.25	34.15	18.48	26.08
Total Assets, 1 Yr. Growth %	95.49	56.89	70.54	10.08	40.29
Tangible Book Value, 1 Yr. Growth %	27.38	15.16	-153.18	10.94	69.39
Common Equity, 1 Yr. Growth %	27.43	15.17	-153.48	10.94	69.39
Cash From Operations, 1 Yr. Growth %	-55.1	-196.7	-236.15	-237.72	369.38
Capital Expenditures, 1 Yr. Growth %	133.21	122.49	39.01	22.36	8.74
Levered Free Cash Flow, 1 Yr. Growth %	-	-137.89	-535.35	-67.94	-585.36
Unlevered Free Cash Flow, 1 Yr. Growth %	-	-162.69	-403.89	-69	-630.55
Compound Annual Growth Rate Over Two Years
Total Revenues, 2 Yr. CAGR %	-	71.82	71.29	31.14	15.1
Gross Profit, 2 Yr. CAGR %	-	210.62	73.47	53.99	41.1
EBITDA, 2 Yr. CAGR %	-	-36.7	32.1	-44.67	-13.38
EBITA, 2 Yr. CAGR %	-	-29.19	36.61	-53.41	-37.16
EBIT, 2 Yr. CAGR %	-	-29.19	36.61	-53.41	-37.16
Earnings From Cont. Operations, 2 Yr. CAGR %	-	-34.22	48.78	-55.42	-6.12
Net Income, 2 Yr. CAGR %