Dell Technologies Inc. Financial Ratios — DELL Stock

Profitability (USD)

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	01/31/2015	01/31/2016	01/31/2017	01/31/2018	01/31/2019	01/31/2020	01/31/2021	01/31/2022	01/31/2023	01/31/2024	01/31/2025	01/31/2026

Return on Common Equity (%)	- -	- -	-15.51	-22.28	- -	- -	- -	- -	- -	- -	- -	- -
Return on Assets (%)	- -	- -	-1.43	-2.35	-1.96	4	2.68	5.15	2.68	3.95	5.67	6.56
Return on Capital (%)	- -	- -	- -	- -	- -	- -	9.46	18.47	13.19	18.41	25.04	27.62
Return on Invested Capital (%)	- -	- -	- -	- -	- -	- -	6.53	10.5	16.74	17.76	24.11	25.58
Gross Margin (%)	16.43	16.47	21.96	25.98	27.65	24.33	23.24	21.63	22.18	23.83	22.24	20
EBITDA Margin (%)	4.91	4.63	4.1	7.87	8.34	10.03	10.47	9.1	8.73	9.85	9.79	9.85
Operating Margin (%)	-0.58	-1.01	-3.84	-3.06	-0.21	2.79	4.25	4.6	5.64	6.71	6.96	7.44
Incremental Operating Margin (%)	- -	6.13	- -	- -	19.21	- -	71.11	6.7	100.72	- -	10.12	9.96
Pretax Margin (%)	-2.24	-2.53	-7.23	-6.03	-2.61	-0.06	2.71	5.85	3.15	4.62	5.28	6.4
Profit Margin (%)	-2.26	-2.17	-1.88	-3.6	-2.55	5.44	3.75	5.5	2.39	3.83	4.81	5.23
Net Income to Common Margin (%)	-2.26	-2.17	-1.88	-3.6	-2.55	5.44	3.75	5.5	2.39	3.83	4.81	5.23
Effective Tax Rate (%)	- -	- -	- -	- -	- -	- -	4.31	16.56	24.9	17.49	9.35	18.27
Dvd Payout Ratio (%)	- -	- -	- -	- -	-104	- -	- -	- -	40.13	31.94	27.96	24.58
Sustainable Growth Rate (%)	- -	- -	-15.51	-22.28	- -	- -	- -	- -	- -	- -	- -	- -

Credit (USD)

Credit Ratios API ChatGPT

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	01/31/2015	01/31/2016	01/31/2017	01/31/2018	01/31/2019	01/31/2020	01/31/2021	01/31/2022	01/31/2023	01/31/2024	01/31/2025	01/31/2026

Total Debt	- -	13,631	49,390	51,871	53,521	53,848	39,222	26,954	29,588	25,994	24,567	31,503
ST Debt	- -	2,981	6,329	7,873	4,320	8,169	6,357	5,823	6,573	6,982	5,204	7,990
LT Debt	- -	10,650	43,061	43,998	49,201	45,679	32,865	21,131	23,015	19,012	19,363	23,513
Total Debt/EBITDA	- -	5.78	19.38	8.34	7.08	6.33	4.32	2.93	3.31	2.98	2.62	2.82
Net Debt/EBITDA	- -	3.1	15.67	6.1	5.8	5.02	3.27	1.9	2.35	2.14	2.24	1.79
Total Debt/EBIT	- -	-26.52	-20.67	-21.47	-280.21	22.76	10.64	5.79	5.13	4.8	3.94	3.87
Net Debt/EBIT	- -	-14.22	-16.7	-15.7	-229.55	18.07	8.06	3.75	3.64	3.44	3.36	2.45
EBITDA to Interest Expense	3.16	3.36	1.42	2.47	2.88	3.55	4.42	5.97	6.97	5.81	6.62	7.17
EBITDA-CapEx/Interest Expense	3.16	3.36	1.42	2.47	2.88	3.55	4.42	5.97	6.97	5.81	6.62	7.17
EBIT to Interest Expense	-0.38	-0.73	-1.33	-0.96	-0.07	0.99	1.8	3.02	4.51	3.95	4.71	5.41
Interest Expense	841	702	1,796	2,519	2,619	2,396	2,052	1,542	1,281	1,501	1,414	1,560
Common Equity/Total Assets	- -	3.48	11.4	9.75	-4.09	-0.8	2.39	-1.82	-3.48	-2.71	-1.86	-2.44
Long-Term Debt/Equity (%)	- -	677.48	223.81	246.23	19,370.47	1,207.16	409.53	- -	- -	- -	- -	- -
Long-Term Debt/Capital (%)	- -	70.05	62.74	63.09	91.49	79.26	69.56	83.28	86.64	79.67	83.53	80.99
Long-Term Debt/Total Assets (%)	- -	23.6	36.43	35.43	44	38.43	26.63	22.79	25.68	23.15	24.28	23.21
Total Debt/Equity (%)	- -	867.11	256.7	290.28	21,071.26	1,423.04	488.75	-1,705.95	-978.12	-1,219.23	-1,771.23	-1,275.43
Total Debt/Capital (%)	- -	89.66	71.97	74.38	99.53	93.43	83.01	106.23	111.39	108.93	105.98	108.51
Total Debt/Total Assets (%)	- -	30.21	41.78	41.77	47.86	45.3	31.78	29.07	33.02	31.65	30.81	31.1
Net Debt to Equity	- -	464.95	207.46	212.26	17,261.81	1,129.86	370.27	-1,106.14	-693.59	-873.73	-1,509.3	-808.7
Net Debt/Capital (%)	- -	82.3	67.48	67.98	99.42	88.46	78.74	109.94	116.85	112.92	107.1	114.11
EBITDA	2,661	2,358	2,548	6,218	7,555	8,509	9,075	9,210	8,927	8,714	9,360	11,178
EBITDA-CapEx	2,661	2,358	2,548	6,218	7,555	8,509	9,075	9,210	8,927	8,714	9,360	11,178
Operating Income (Loss)	-316	-514	-2,390	-2,416	-191	2,366	3,685	4,659	5,771	5,933	6,656	8,446

Liquidity (USD)

Liquidity Ratios API ChatGPT

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	01/31/2015	01/31/2016	01/31/2017	01/31/2018	01/31/2019	01/31/2020	01/31/2021	01/31/2022	01/31/2023	01/31/2024	01/31/2025	01/31/2026

Cash Ratio	- -	0.25	0.3	0.35	0.22	0.18	0.18	0.17	0.17	0.15	0.08	0.18
Current Ratio	- -	0.93	0.81	0.88	0.8	0.7	0.8	0.8	0.82	0.74	0.78	0.91
Quick Ratio	- -	0.56	0.63	0.69	0.59	0.51	0.47	0.49	0.52	0.44	0.41	0.59
CFO/Avg Current Liab	- -	- -	0.07	0.16	0.15	0.19	0.21	0.19	0.07	0.17	0.1	0.2
Common Equity/Total Assets	- -	3.48	11.4	9.75	-4.09	-0.8	2.39	-1.82	-3.48	-2.71	-1.86	-2.44
Long-Term Debt/Equity (%)	- -	677.48	223.81	246.23	19,370.47	1,207.16	409.53	- -	- -	- -	- -	- -
Long-Term Debt/Capital (%)	- -	70.05	62.74	63.09	91.49	79.26	69.56	83.28	86.64	79.67	83.53	80.99
Long-Term Debt/Total Assets (%)	- -	23.6	36.43	35.43	44	38.43	26.63	22.79	25.68	23.15	24.28	23.21
Total Debt/Equity (%)	- -	867.11	256.7	290.28	21,071.26	1,423.04	488.75	-1,705.95	-978.12	-1,219.23	-1,771.23	-1,275.43
Total Debt/Capital (%)	- -	89.66	71.97	74.38	99.53	93.43	83.01	106.23	111.39	108.93	105.98	108.51
Total Debt/Total Assets (%)	- -	30.21	41.78	41.77	47.86	45.3	31.78	29.07	33.02	31.65	30.81	31.1
CFO/Total Liabilities	- -	4.96	2.39	6.44	6.27	8.07	9.89	10.93	3.85	10.3	5.57	10.78
CFO/CapEx	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
Altman's Z-Score	- -	- -	- -	- -	1.19	1.04	1	1.67	1.77	1.95	2.41	2.23

Working Capital (USD)

Working Capital Ratios API ChatGPT

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	01/31/2015	01/31/2016	01/31/2017	01/31/2018	01/31/2019	01/31/2020	01/31/2021	01/31/2022	01/31/2023	01/31/2024	01/31/2025	01/31/2026

Accounts Receivable Turnover	- -	- -	8.69	7.48	7.52	6.82	7.47	8.56	8.06	8.1	9.73	8.14
Days Sales Outstanding	- -	- -	42	48.81	48.52	53.48	48.88	42.64	45.3	45.04	37.51	44.82
Inventory Turnover	- -	- -	23.34	22.43	20.73	18.52	19.91	17.05	14.92	16.04	14.38	10.59
Days Inventory Outstanding	- -	- -	15.64	16.27	17.61	19.71	18.34	21.4	24.47	22.75	25.39	34.46
Accounts Payable Turnover	- -	- -	3.62	3.58	3.54	3.25	3.2	3.36	3.43	3.5	3.86	3.47
Accounts Payable Turnover Days	- -	- -	100.8	101.94	102.98	112.34	114.01	108.68	106.35	104.27	94.44	105.12
Cash Conversion Cycle	- -	- -	-43.16	-36.85	-36.85	-39.15	-46.79	-44.64	-36.58	-36.47	-31.54	-25.84
Inventory to Cash Days	- -	- -	26.36	32.54	30.91	33.77	30.55	21.23	20.83	22.29	12.12	10.35
Inventories	- -	1,619	2,538	2,678	3,649	3,281	3,403	5,898	4,776	3,622	6,716	10,437
Raw Materials	- -	657	925	967	1,794	1,590	1,718	3,653	3,225	2,321	4,432	6,696
Work In Process	- -	189	503	514	702	563	677	855	708	607	1,128	2,772
Finished Goods	- -	773	1,110	1,197	1,153	1,128	1,008	1,390	843	694	1,156	969
Other Inventory	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -

Enterprise Value (USD)

Enterprise Value API ChatGPT

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	01/31/2015	01/31/2016	01/31/2017	01/31/2018	01/31/2019	01/31/2020	01/31/2021	01/31/2022	01/31/2023	01/31/2024	01/31/2025	01/31/2026

Market Capitalization	- -	- -	- -	- -	35,077	36,002	55,186	42,669	28,663	58,329	73,868	74,223
- Cash & Cash Equivalents	- -	6,322	9,474	13,942	9,676	9,302	9,508	9,477	8,607	7,366	3,633	11,528
+ Preferred Equity and Hybrid Capital	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -	- -
+ Minority/Non Controlling Interest	- -	- -	5,766	5,766	4,823	4,729	5,074	105	97	95	95	- -
+ Total Debt	- -	13,631	49,390	51,871	53,521	53,848	39,222	26,954	29,588	25,994	24,567	31,503
Enterprise Value	- -	- -	- -	- -	83,745	85,277	89,974	60,251	49,741	77,052	94,897	94,198
Total Capital	- -	15,203	68,630	69,740	53,775	57,632	47,247	25,374	26,563	23,862	23,180	29,033
Total Debt/Capital (%)	- -	89.66	71.97	74.38	99.53	93.43	83.01	106.23	111.39	108.93	105.98	108.51
Total Debt / EV	- -	- -	- -	- -	0.64	0.63	0.44	0.45	0.59	0.34	0.26	0.33
EV/Sales	- -	- -	- -	- -	0.92	1.01	1.04	0.6	0.49	0.87	0.99	0.83
EV/EBITDA	- -	- -	- -	- -	11.08	10.02	9.91	6.54	5.57	8.84	10.14	8.43
EV/EBIT	- -	- -	- -	- -	- -	36.04	24.42	12.93	8.62	14.24	15.22	11.56
EV/Cash Flow to Firm	- -	- -	- -	- -	- -	- -	6.73	5.2	10.99	7.77	16.35	7.56
EV/Free Cash Flow to Firm	- -	- -	- -	- -	- -	- -	6.73	5.2	10.99	7.77	16.35	7.56
Diluted Market Cap	- -	- -	- -	- -	35,077	36,292	56,212	44,585	30,145	58,329	76,401	77,893
Diluted Enterprise Value	- -	- -	- -	- -	83,745	85,567	91,000	62,167	51,223	77,052	97,430	97,868
EV per Share	- -	- -	- -	- -	116.47	114.47	119.49	79.59	69.47	109.09	136.32	144.53
TTM Sales	54,142	50,911	62,164	79,040	90,621	84,815	86,670	101,197	102,301	88,425	95,567	113,538
TTM EBITDA	2,661	2,358	2,548	6,218	7,555	8,509	9,075	9,210	8,927	8,714	9,360	11,178
TTM Operating Income	-316	-514	-2,390	-2,416	-191	2,366	3,685	4,659	5,771	5,933	6,656	8,446
TTM Cash Flow to Firm	- -	- -	- -	- -	- -	- -	13,371	11,594	4,527	9,914	5,803	12,460
TTM Free Cash Flow to Firm	- -	- -	- -	- -	- -	- -	13,371	11,594	4,527	9,914	5,803	12,460

Multiples (USD)

Valuation Multiples API ChatGPT

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	01/31/2015	01/31/2016	01/31/2017	01/31/2018	01/31/2019	01/31/2020	01/31/2021	01/31/2022	01/31/2023	01/31/2024	01/31/2025	01/31/2026

Price/Free Cash Flow	- -	- -	- -	- -	5.02	3.91	4.93	4.33	8.46	6.72	16.9	6.96
EV/EBIT	- -	- -	- -	- -	- -	36.04	24.42	12.93	8.62	14.24	15.22	11.56
Enterprise Value	- -	- -	- -	- -	83,745	85,277	89,974	60,251	49,741	77,052	94,897	94,198
Low Price	- -	- -	- -	- -	43.09	45.17	28.31	53.25	33.93	36.17	81.25	65.8
EV/Sales	- -	- -	- -	- -	0.92	1.01	1.04	0.6	0.49	0.87	0.99	0.83
EV/EBITDA	- -	- -	- -	- -	11.08	10.02	9.91	6.54	5.57	8.84	10.14	8.43
Price/Earnings	- -	- -	- -	- -	- -	7.58	16.78	7.72	12.03	17.22	16.29	12.95
Price/Earnings Average	- -	- -	- -	- -	- -	8.57	13.24	11.86	13.47	12.04	18.51	13.73
Price/Earnings High	- -	- -	- -	- -	- -	11.04	17.65	15.68	18.33	17.77	27.42	19.12
Price/Earnings Low	- -	- -	- -	- -	- -	7.09	6.48	7.29	10.2	7.54	12.47	7.48
Price/Book Value	- -	- -	- -	- -	-7.68	-38.1	18.7	-25.32	-9.18	-26.19	-49.84	-30.05
Price/Book Value Average	- -	- -	- -	- -	-7.09	-43.06	14.76	-38.88	-10.28	-18.31	-56.64	-31.87
Price/Book Value High	- -	- -	- -	- -	-7.68	-55.48	19.67	-51.42	-13.99	-27.03	-83.89	-44.37
Price/Book Value Low	- -	- -	- -	- -	-6.78	-35.61	7.22	-23.92	-7.78	-11.47	-38.16	-17.36
Price/Tangible Book Value	- -	- -	- -	- -	-0.52	-0.59	-2.11	-1.48	-0.98	-2.11	-2.89	-2.8
Price/Tangible Book Value Average	- -	- -	- -	- -	-0.48	-0.67	-1.66	-2.27	-1.1	-1.48	-3.28	-2.96
Price/Tangible Book Value High	- -	- -	- -	- -	-0.52	-0.86	-2.22	-3	-1.49	-2.18	-4.86	-4.13
Price/Tangible Book Value Low	- -	- -	- -	- -	-0.46	-0.55	-0.81	-1.39	-0.83	-0.92	-2.21	-1.62
Price/Sales	- -	- -	- -	- -	0.39	0.41	0.63	0.42	0.29	0.66	0.78	0.68
Price/Sales Average	- -	- -	- -	- -	0.36	0.47	0.5	0.65	0.32	0.46	0.89	0.72
Price/Sales High	- -	- -	- -	- -	0.39	0.6	0.66	0.86	0.44	0.68	1.32	1
Price/Sales Low	- -	- -	- -	- -	0.34	0.39	0.24	0.4	0.24	0.29	0.6	0.39
Price/Cash Flow	- -	- -	- -	- -	5.02	3.77	4.78	4.17	8.24	6.72	16.55	6.87
Price/Cash Flow Average	- -	- -	- -	- -	4.64	4.26	3.77	6.4	9.22	4.7	18.8	7.29
Price/Cash Flow High	- -	- -	- -	- -	5.02	5.48	5.03	8.46	12.56	6.94	27.85	10.15
Price/Cash Flow Low	- -	- -	- -	- -	4.43	3.52	1.85	3.94	6.99	2.94	12.67	3.97
Price/Free Cash Flow Average	- -	- -	- -	- -	4.64	4.41	3.89	6.64	9.46	4.7	19.2	7.39
Price/Free Cash Flow High	- -	- -	- -	- -	5.02	5.69	5.18	8.78	12.88	6.94	28.44	10.28
Price/Free Cash Flow Low	- -	- -	- -	- -	4.43	3.65	1.9	4.09	7.17	2.94	12.94	4.02
EV/Sales Average	- -	- -	- -	- -	0.89	1.06	0.9	0.82	0.52	0.67	1.1	0.87
EV/Sales High	- -	- -	- -	- -	0.92	1.2	1.07	1.03	0.63	0.89	1.52	1.14
EV/Sales Low	- -	- -	- -	- -	0.88	0.98	0.65	0.57	0.44	0.5	0.81	0.55
EV/EBITDA Average	- -	- -	- -	- -	10.73	10.57	8.63	9.02	5.95	6.83	11.21	8.83
EV/EBITDA High	- -	- -	- -	- -	11.08	11.95	10.23	11.32	7.25	9.06	15.53	11.59
EV/EBITDA Low	- -	- -	- -	- -	10.54	9.75	6.18	6.29	5.08	5.08	8.29	5.62
EV/EBIT Average	- -	- -	- -	- -	- -	38.02	21.26	17.84	9.21	11	16.83	12.11
EV/EBIT High	- -	- -	- -	- -	- -	42.99	25.19	22.37	11.22	14.58	23.3	15.9
EV/EBIT Low	- -	- -	- -	- -	- -	35.05	15.23	12.43	7.86	8.18	12.44	7.71
Last Price	- -	- -	- -	- -	48.79	48.32	73.29	56.37	40.03	82.58	106.11	113.88
High Price	- -	- -	- -	- -	48.79	70.38	77.08	114.46	60.99	85.22	178.59	168.15
Enterprise Value Average	- -	- -	- -	- -	81,072	89,963	78,330	83,100	53,158	59,498	104,969	98,685
Enterprise Value High	- -	- -	- -	- -	83,745	101,707	92,830	104,229	64,747	78,914	145,350	129,572
Enterprise Value Low	- -	- -	- -	- -	79,650	82,928	56,106	57,892	45,372	44,270	77,587	62,862

Per Share Data Items (USD)

Per-Share Data API ChatGPT

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
As of date	01/31/2015	01/31/2016	01/31/2017	01/31/2018	01/31/2019	01/31/2020	01/31/2021	01/31/2022	01/31/2023	01/31/2024	01/31/2025	01/31/2026

Shares Outstanding	720	718	718	718	719	745	753	757	716	706	696	652
Diluted Weighted Avg Shares	750	750	750	750	719	751	767	791	753	706	720	684
Basic Weighted Avg Shares	720	720	720	720	719	724	744	762	734	706	705	675
Revenue per Share	75.2	70.71	86.34	109.78	126.04	117.15	116.49	132.8	139.37	125.19	135.56	168.2
EBITDA per Share	3.7	3.28	3.54	8.64	10.51	11.75	12.2	12.09	12.16	12.34	13.28	16.56
Operating Income per Share	-0.44	-0.71	-3.32	-3.36	-0.27	3.27	4.95	6.11	7.86	8.4	9.44	12.51
Basic EPS, GAAP	-1.7	-1.53	-1.62	-3.96	-3.21	6.38	4.37	7.3	3.33	4.8	6.51	8.79
Basic EPS from Cont Ops	-1.54	-1.62	-4.27	-4.06	-3.03	0.72	3.02	6.49	3.3	4.77	6.49	8.79
Diluted EPS, GAAP	-1.63	-1.47	-1.56	-3.8	-3.21	6.15	4.24	7.03	3.24	4.8	6.38	8.68
Diluted EPS from Cont Ops	-1.48	-1.56	-4.1	-3.9	-3.03	0.69	2.93	6.25	3.22	4.77	6.36	8.68
Dividend per Share	- -	- -	- -	- -	2.97	- -	- -	- -	1.31	1.52	1.81	2.16
Cash Flow per Share	3.54	3	3.29	9.5	9.72	12.83	15.33	13.53	4.86	12.28	6.41	16.57
Free Cash Flow per Basic Share	3.54	3	3.29	9.5	9.72	12.83	15.33	13.53	4.86	12.28	6.41	16.57
Cash & Equivalents per Share	- -	8.8	15.94	22.45	13.46	12.49	12.63	12.52	12.02	10.43	5.22	17.69
Book Value per Share	- -	2.19	18.75	16.85	-6.35	-1.27	3.92	-2.23	-4.36	-3.15	-2.13	-3.79
Tangible Book Value per Share	- -	-21.45	-84.2	-78.06	-93.08	-81.53	-34.78	-38.2	-40.87	-39.11	-36.76	-40.74