Balance Sheet Dell Technologies Inc.

Equities

DELL

US24703L2025

Computer Hardware

Market Closed - Nyse Other stock markets 01:30:02 11/09/2024 am IST			Pre-market 06:39:52 pm
106.64 ^USD	+0.71%		106.94	+0.28%

01:25pm	Analyst recommendations: Exxon Mobil, Accenture, Citigroup, Morgan Stanley...
12:59pm	Dell Technologies to Continue Workforce Reduction in Fiscal 2025	MT

ca5efcaf73.ScfHxRutgWDmqbH7ChBiysFasJ-b2-bQPU2s_oVo5PY.C_-YslSa5FSt092CRXUUmqMs5tHT7N--ZWDBjdMcl7ktlbGVLuSyDojk5A

Published financial data: DELL TECHNOLOGIES INC.

Annual

Quarterly

Halfyear

YTD

LTM

Fiscal Period: February	2020	2021	2022	2023	2024
Revenues	92.15B	94.22B	101B	102B	88.42B
Total Revenues	92.15B	94.22B	101B	102B	88.42B
Cost of Goods Sold, Total	63.23B	64.81B	79.31B	79.62B	67.47B
Gross Profit	28.93B	29.42B	21.89B	22.69B	20.96B
Selling General & Admin Expenses, Total	20.46B	19.24B	14.66B	14.14B	12.34B
R&D Expenses	4.99B	5.28B	2.58B	2.78B	2.76B
Other Operating Expenses, Total	25.46B	24.51B	17.23B	16.92B	15.1B
Operating Income	3.47B	4.91B	4.66B	5.77B	5.86B
Interest Expense, Total	-2.68B	-2.39B	-1.54B	-1.22B	-1.32B
Interest And Investment Income	160M	54M	42M	100M	-
Net Interest Expenses	-2.52B	-2.34B	-1.5B	-1.12B	-1.32B
Currency Exchange Gains (Loss)	-162M	-127M	-221M	-265M	-
Other Non Operating Income (Expenses)	-143M	-52M	20M	-59M	-
EBT, Excl. Unusual Items	653M	2.39B	2.96B	4.32B	4.54B
Restructuring Charges	-	-	-	-	-648M
Merger & Related Restructuring Charges	-	-	-	-	-
Impairment of Goodwill	-207M	-	-	-	-
Gain (Loss) On Sale Of Investments	194M	582M	569M	-206M	-
Gain (Loss) On Sale Of Assets	-	458M	3.97B	-	-
Asset Writedown	-412M	-	-	-	-
Legal Settlements	-237M	237M	-	-894M	-
Other Unusual Items	5M	-	-1.57B	-	-
EBT, Incl. Unusual Items	-4M	3.67B	5.92B	3.22B	3.89B
Income Tax Expense	-5.53B	165M	981M	803M	692M
Earnings From Continuing Operations	5.53B	3.5B	4.94B	2.42B	3.2B
Earnings Of Discontinued Operations	-	-	615M	-	-
Net Income to Company	5.53B	3.5B	5.56B	2.42B	3.2B
Minority Interest	-913M	-255M	6M	20M	16M
Net Income - (IS)	4.62B	3.25B	5.56B	2.44B	3.21B
Net Income to Common Incl Extra Items	4.62B	3.25B	5.56B	2.44B	3.21B
Net Income to Common Excl. Extra Items	4.62B	3.25B	4.95B	2.44B	3.21B
Per Share Items
Net EPS - Basic	6.38	4.37	7.3	3.33	4.46
Basic EPS - Continuing Operations	6.38	4.37	6.49	3.33	4.46
Basic Weighted Average Shares Outstanding	724M	744M	762M	734M	720M
Net EPS - Diluted	6.03	4.22	7.02	3.24	4.36
Diluted EPS - Continuing Operations	6.03	4.22	6.25	3.24	4.36
Diluted Weighted Average Shares Outstanding	751M	767M	791M	753M	736M
Normalized Basic EPS	-0.7	1.67	2.43	3.71	3.96
Normalized Diluted EPS	-0.67	1.62	2.34	3.62	3.87
Dividend Per Share	-	-	-	1.32	1.48
Payout Ratio	-	-	-	39.48	33.39
American Depositary Receipts Ratio (ADR)	1	1	1	1	1
Supplemental Items
EBITDA	9.34B	9.98B	8.95B	8.61B	8.75B
EBITA	7.88B	8.3B	6.3B	6.74B	6.68B
EBIT	3.47B	4.91B	4.66B	5.77B	5.86B
EBITDAR	10.01B	10.68B	9.38B	9.01B	9.12B
Total Revenues (As Reported)	92.15B	94.22B	101B	102B	88.42B
Effective Tax Rate - (Ratio)	138K	4.5	16.56	24.9	17.8
Current Domestic Taxes	-81M	-497M	242M	781M	182M
Current Foreign Taxes	887M	1.06B	960M	739M	601M
Total Current Taxes	806M	564M	1.2B	1.52B	783M
Deferred Domestic Taxes	-1.01B	-122M	-54M	-586M	-148M
Deferred Foreign Taxes	-5.33B	-277M	-167M	-131M	57M
Total Deferred Taxes	-6.34B	-399M	-221M	-717M	-91M
Normalized Net Income	-505M	1.24B	1.85B	2.72B	2.85B
Non-Cash Pension Expense	-	-	-	-	-
Supplemental Operating Expense Items
Advertising Expense	1.3B	1.3B	1.3B	1.1B	900M
Selling and Marketing Expenses	1.3B	1.3B	1.3B	1.1B	900M
Research And Development Expense From Footnotes	5.26B	5.59B	2.84B	3.1B	3.22B
Net Rental Expense, Total	671M	696M	431M	396M	371M
Imputed Operating Lease Interest Expense	307M	307M	216M	200M	209M
Imputed Operating Lease Depreciation	364M	389M	215M	196M	162M
Stock-Based Comp., COGS (Total)	129M	194M	133M	152M	149M
Stock-Based Comp., Other (Total)	1.13B	1.42B	675M	779M	729M
Total Stock-Based Compensation	1.26B	1.61B	808M	931M	878M

Fiscal Period: February	2020	2021	2022	2023	2024
Assets
Cash And Equivalents	9.3B	14.2B	9.48B	8.61B	7.37B
Short Term Investments	-	-	-	-	-
Total Cash And Short Term Investments	9.3B	14.2B	9.48B	8.61B	7.37B
Accounts Receivable, Total	12.48B	12.79B	13.04B	12.86B	9.34B
Other Receivables	600M	1B	-	-	-
Total Receivables	13.08B	13.79B	13.04B	12.86B	9.34B
Inventory	3.28B	3.4B	5.9B	4.78B	3.62B
Prepaid Expenses	885M	887M	886M	641M	589M
Finance Division Loans and Leases Current	4.9B	5.16B	5.09B	5.28B	4.64B
Restricted Cash	730M	891M	534M	272M	136M
Other Current Assets, Total	4.69B	5.24B	10.11B	9.91B	10.25B
Total Current Assets	36.87B	43.57B	45.03B	42.35B	35.95B
Gross Property Plant And Equipment	16.41B	17.3B	13.18B	13.82B	14.32B
Accumulated Depreciation	-8.57B	-8.75B	-6.89B	-6.88B	-7.18B
Net Property Plant And Equipment	7.84B	8.55B	6.29B	6.93B	7.14B
Long-term Investments	865M	1.63B	1.87B	1.65B	1.36B
Goodwill	41.69B	40.83B	19.77B	19.68B	19.7B
Other Intangibles, Total	18.79B	15.04B	8.13B	7.14B	6.35B
Finance Division Loans and Leases Long-Term	4.85B	5.34B	5.52B	5.64B	5.88B
Deferred Tax Assets Long-Term	5.96B	6.23B	-	3.02B	2.92B
Deferred Charges Long-Term	998M	1.09B	2.31B	2.54B	-
Other Long-Term Assets, Total	1.01B	1.14B	3.81B	668M	2.8B
Total Assets	119B	123B	92.74B	89.61B	82.09B
Liabilities
Accounts Payable, Total	20.06B	21.7B	28.56B	20.66B	19.39B
Accrued Expenses, Total	5.1B	5.34B	6.84B	7.93B	6.23B
Current Portion of Long-Term Debt	3.58B	1.47B	20M	1.17B	1.12B
Current Portion of Leases	432M	436M	287M	260M	253M
Finance Division Debt Current	4.15B	4.89B	5.8B	5.4B	5.86B
Current Income Taxes Payable	1.77B	1.62B	-	-	-
Unearned Revenue Current, Total	14.88B	16.52B	14.26B	15.54B	15.32B
Other Current Liabilities	2.47B	2.15B	449M	682M	326M
Total Current Liabilities	52.46B	54.13B	56.22B	51.65B	48.49B
Long-Term Debt	40.71B	36.84B	17.32B	18.23B	15.41B
Long-Term Leases	1.36B	1.79B	720M	630M	576M
Finance Division Debt Non Current	3.61B	4.78B	3.84B	4.89B	3.63B
Unearned Revenue Non Current	12.92B	14.28B	13.31B	14.74B	13.83B
Pension & Other Post Retirement Benefits	-	-	266M	247M	213M
Deferred Tax Liability Non Current	3.11B	2.17B	-	1.66B	1.49B
Other Non Current Liabilities	1.54B	1.87B	2.63B	590M	761M
Total Liabilities	116B	116B	94.32B	92.64B	84.4B
Common Stock, Total	16.09B	16.85B	7.9B	8.42B	8.93B
Retained Earnings	-16.89B	-13.75B	-8.19B	-6.73B	-4.63B
Treasury Stock	-65M	-305M	-964M	-3.81B	-5.9B
Comprehensive Income and Other	-709M	-314M	-431M	-1B	-800M
Total Common Equity	-1.57B	2.48B	-1.68B	-3.12B	-2.4B
Minority Interest	4.73B	5.07B	105M	97M	95M
Total Equity	3.16B	7.55B	-1.58B	-3.02B	-2.31B
Total Liabilities And Equity	119B	123B	92.74B	89.61B	82.09B
Supplemental Items
ECS Total Shares Outstanding on Filing Date	739M	763M	760M	731M	714M
ECS Total Common Shares Outstanding	743M	753M	757M	716M	705M
Book Value / Share	-2.12	3.29	-2.23	-4.36	-3.41
Tangible Book Value	-62.05B	-53.39B	-29.59B	-29.94B	-28.45B
Tangible Book Value Per Share	-83.51	-70.9	-39.09	-41.81	-40.36
Total Debt	53.85B	50.21B	28B	30.58B	26.85B
Net Debt	44.55B	36.01B	18.52B	21.97B	19.48B
Debt Equivalent of Unfunded Proj. Benefit Obligation	241M	363M	266M	247M	213M
Debt Equivalent Oper. Leases	5.37B	5.57B	3.45B	3.17B	2.97B
Minority Interest, Total (Incl. Fin. Div)	4.73B	5.07B	105M	97M	95M
Account Code - Inventory Valuation	5	5	5	5	5
Inventories - Raw Materials, Total	1.59B	1.72B	3.65B	3.22B	2.32B
Inventories - Work In Process, Total	563M	677M	855M	708M	607M
Inventories - Finished Goods, Total	1.13B	1.01B	1.39B	843M	694M
Land - (BS)	4.7B	4.74B	3.1B	3.06B	2.88B
Machinery, Total	9.93B	10.44B	9.21B	10.03B	3.55B
Full Time Employees	165K	158K	133K	133K	120K
Accumulated Allowance for Doubtful Accounts (Supple)	94M	104M	90M	78M	71M
Order Backlog	-	-	-	-	-

Fiscal Period: February	2020	2021	2022	2023	2024
Net Income	4.62B	3.25B	5.56B	2.44B	3.21B
Depreciation & Amortization - CF	1.46B	1.68B	2.65B	1.87B	2.07B
Amortization of Goodwill and Intangible Assets - (CF)	4.41B	3.39B	1.64B	970M	819M
Depreciation & Amortization, Total	5.87B	5.08B	4.29B	2.84B	2.89B
Amortization of Deferred Charges, Total - (CF)	273M	315M	263M	317M	416M
(Gain) Loss From Sale Of Asset	-	-	-3.97B	-	-
Asset Writedown & Restructuring Costs	619M	-	-	-	-
Stock-Based Compensation (CF)	1.26B	1.61B	1.62B	931M	878M
Provision and Write-off of Bad Debts	178M	-	-	-	-
Other Operating Activities, Total	-5.28B	-232M	617M	224M	502M
Change In Accounts Receivable	-286M	-396M	-2.19B	113M	2.98B
Change In Inventories	311M	-243M	-2.51B	875M	975M
Change In Accounts Payable	894M	1.6B	5.74B	-8.55B	-335M
Change in Unearned Revenues	3.73B	2.82B	2.6B	3.21B	-1.02B
Change in Other Net Operating Assets	-2.89B	-2.38B	-1.71B	1.16B	-1.81B
Cash from Operations	9.29B	11.41B	10.31B	3.56B	8.68B
Capital Expenditure	-2.25B	-2.08B	-2.8B	-3B	-2.76B
Sale of Property, Plant, and Equipment	-	-	-	-	-
Cash Acquisitions	-2.46B	-424M	-16M	-70M	-126M
Divestitures	-	2.19B	3.96B	-	-
Sale (Purchase) of Intangible assets	-335M	-	-	-	-
Investment in Marketable and Equity Securities, Total	316M	-169M	99M	8M	54M
Net (Increase) Decrease in Loans Originated / Sold - Investing	-	-	-	-	-
Other Investing Activities, Total	40M	28M	62M	41M	45M
Cash from Investing	-4.69B	-460M	1.31B	-3.02B	-2.78B
Long-Term Debt Issued, Total	20.48B	16.39B	20.42B	12.48B	7.78B
Total Debt Issued	20.48B	16.39B	20.42B	12.48B	7.78B
Long-Term Debt Repaid, Total	-22.12B	-20.92B	-26.72B	-9.82B	-11.25B
Total Debt Repaid	-22.12B	-20.92B	-26.72B	-9.82B	-11.25B
Issuance of Common Stock	658M	452M	334M	5M	10M
Repurchase of Common Stock	-547M	-241M	-663M	-3.27B	-2.45B
Common Dividends Paid	-	-	-	-964M	-1.07B
Common & Preferred Stock Dividends Paid	-	-	-	-964M	-1.07B
Other Financing Activities, Total	-3.08B	-1.63B	-9.98B	-48M	-109M
Cash from Financing	-4.6B	-5.95B	-16.61B	-1.62B	-7.09B
Foreign Exchange Rate Adjustments	-90M	36M	-106M	-104M	-186M
Net Change in Cash	-89M	5.03B	-5.1B	-1.19B	-1.39B
Supplemental Items
Cash Interest Paid	2.5B	2.28B	1.82B	1.17B	1.44B
Cash Income Tax Paid (Refund)	1.41B	1.42B	1.26B	1.21B	1.38B
Levered Free Cash Flow	8.89B	8.47B	6.59B	48.12M	6.32B
Unlevered Free Cash Flow	10.56B	9.97B	7.55B	812M	7.15B
Change In Net Working Capital	-3.57B	-1.98B	-2.08B	3.88B	-2.06B
Net Debt Issued / Repaid	-1.64B	-4.53B	-6.3B	2.65B	-3.47B

Fiscal Period: February	2020	2021	2022	2023	2024
Profitability
Return on Assets	1.88	2.53	2.69	3.96	4.27
Return on Total Capital	3.96	5.34	7.82	13.37	14.06
Return On Equity %	499.68	65.46	165.48	-105.19	-119.8
Return on Common Equity	-125.79	718.23	1.25K	-101.6	-116.21
Margin Analysis