Dell Technologies Inc. Financial Ratios — DELL UN 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
Return on Common Equity (%)	- -	-123.35	-14.25	-20.63	- -	- -	- -	- -	- -	109.91	73.87	57.24
Return on Assets (%)	- -	-4.89	-1.43	-2.35	-1.96	4	2.68	5.15	2.68	3.95	5.67	6.56
Return on Capital (%)	- -	- -	- -	- -	- -	- -	9.43	18.08	11.78	14.99	18.64	18.75
Return on Invested Capital (%)	- -	- -	- -	- -	- -	- -	6.53	10.5	16.74	19.47	25.73	26.51
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	10.45	10.23	10.11
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 (%)	- -	- -	- -	- -	- -	-44.04	71.11	6.7	100.72	-1.17	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 (%)	- -	-123.35	-14.25	-20.63	- -	- -	- -	- -	- -	74.8	53.22	43.17

Credit (USD)

API Chat

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
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.81	2.51	2.75
Net Debt/EBITDA	- -	3.1	15.67	6.1	5.8	5.02	3.27	1.9	2.35	2.02	2.14	1.74
Total Debt/EBIT	- -	-26.52	-20.67	-21.47	-280.21	22.76	10.64	5.79	5.13	4.38	3.69	3.73
Net Debt/EBIT	- -	-14.22	-16.7	-15.7	-229.55	18.07	8.06	3.75	3.64	3.14	3.15	2.37
EBITDA to Interest Expense	3.16	3.36	1.42	2.47	2.88	3.55	4.42	5.97	6.97	6.15	6.92	7.36
EBITDA-CapEx/Interest Expense	3.16	3.36	1.42	2.47	2.88	3.55	4.42	5.97	6.97	6.15	6.92	7.36
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.97	12.34	10.49	-4.68	-0.67	2.51	-0.31	1.89	5.45	9.98	12.62
Long-Term Debt/Equity (%)	- -	677.48	223.81	246.23	19,370.47	1,207.16	409.53	- -	- -	- -	- -	- -
Long-Term Debt/Capital (%)	- -	69.06	61.74	62.26	92.64	79.06	69.34	78.94	73.35	62.21	59.36	53.09
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 (%)	- -	88.39	70.81	73.4	100.78	93.2	82.76	100.69	94.3	85.05	75.31	71.14
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 (%)	- -	80.33	66.23	66.87	100.95	88.2	78.43	101.07	92.14	80.31	72.22	60.98
EBITDA	2,661	2,358	2,548	6,218	7,555	8,509	9,075	9,210	8,927	9,236	9,779	11,475
EBITDA-CapEx	2,661	2,358	2,548	6,218	7,555	8,509	9,075	9,210	8,927	9,236	9,779	11,475
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)

API Chat

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
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.17	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.97	12.34	10.49	-4.68	-0.67	2.51	-0.31	1.89	5.45	9.98	12.62
Long-Term Debt/Equity (%)	- -	677.48	223.81	246.23	19,370.47	1,207.16	409.53	- -	- -	- -	- -	- -
Long-Term Debt/Capital (%)	- -	69.06	61.74	62.26	92.64	79.06	69.34	78.94	73.35	62.21	59.36	53.09
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 (%)	- -	88.39	70.81	73.4	100.78	93.2	82.76	100.69	94.3	85.05	75.31	71.14
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.48	0.93	1.06	1.1	0.94	0.85	1.68	1.78	1.95	2.39	2.24

Working Capital (USD)

API Chat

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
Accounts Receivable Turnover	- -	20.84	8.69	7.48	7.52	6.82	7.47	8.56	8.06	8.1	9.73	8.14
Days Sales Outstanding	- -	17.52	42	48.81	48.52	53.48	48.88	42.64	45.3	45.04	37.51	44.82
Inventory Turnover	- -	52.53	23.34	22.43	20.73	18.52	19.91	17.05	14.92	16.04	14.38	10.59
Days Inventory Outstanding	- -	6.95	15.64	16.27	17.61	19.71	18.34	21.4	24.47	22.75	25.39	34.46
Accounts Payable Turnover	- -	6.85	3.62	3.58	3.54	3.25	3.2	3.36	3.43	3.5	3.86	3.47
Accounts Payable Turnover Days	- -	53.25	100.8	101.94	102.98	112.34	114.01	108.68	106.35	104.27	94.44	105.12
Cash Conversion Cycle	- -	-28.79	-43.16	-36.85	-36.85	-39.15	-46.79	-44.64	-36.58	-36.47	-31.54	-25.84
Inventory to Cash Days	- -	10.57	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)

API Chat

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
Market Capitalization	- -	- -	12,702	14,455	17,695	17,890	27,468	43,289	29,815	58,541	72,119	74,589
- 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	- -	7,309	56,409	55,963	66,363	67,165	62,256	60,871	50,893	77,264	93,148	94,564
Total Capital	- -	15,421	69,746	70,666	53,109	57,777	47,394	26,769	31,377	30,562	32,621	44,285
Total Debt/Capital (%)	- -	88.39	70.81	73.4	100.78	93.2	82.76	100.69	94.3	85.05	75.31	71.14
Total Debt / EV	- -	1.86	0.88	0.93	0.81	0.8	0.63	0.44	0.58	0.34	0.26	0.33
EV/Sales	- -	0.14	0.91	0.71	0.73	0.79	0.72	0.6	0.5	0.87	0.97	0.83
EV/EBITDA	- -	3.1	22.14	9	8.78	7.89	6.86	6.61	5.7	8.37	9.53	8.24
EV/EBIT	- -	- -	- -	- -	- -	28.39	16.89	13.07	8.82	13.02	13.99	11.2
EV/Cash Flow to Firm	- -	2.61	15.69	6.67	7.05	- -	4.66	5.25	11.24	7.79	16.05	7.59
EV/Free Cash Flow to Firm	- -	2.61	15.69	6.67	7.05	- -	4.66	5.25	11.24	7.79	16.05	7.59
Diluted Market Cap	- -	- -	12,702	14,455	17,695	18,557	28,318	44,937	30,587	58,541	74,566	78,262
Diluted Enterprise Value	- -	7,309	58,384	58,150	66,363	67,832	63,106	62,519	51,665	77,264	95,595	98,237
EV per Share	- -	10.17	78.52	77.9	92.3	92.77	83.68	79.88	69.34	109.39	133.81	145.09
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	9,236	9,779	11,475
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	3,318	2,800	3,596	8,389	9,410	-15,186	13,371	11,594	4,527	9,914	5,803	12,460
TTM Free Cash Flow to Firm	3,318	2,800	3,596	8,389	9,410	-15,186	13,371	11,594	4,527	9,914	5,803	12,460

Multiples (USD)

API Chat

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
Price/Free Cash Flow	- -	- -	5.37	2.11	2.53	2	2.48	4.36	8.58	6.75	16.49	7
EV/EBIT	- -	- -	- -	- -	- -	28.39	16.89	13.07	8.82	13.02	13.99	11.2
Enterprise Value	- -	7,309	56,409	55,963	66,363	67,165	62,256	60,871	50,893	77,264	93,148	94,564
Low Price	- -	- -	11.79	16.82	18.23	22.47	12.92	36.83	32.9	35.96	80.49	66.25
EV/Sales	- -	0.14	0.91	0.71	0.73	0.79	0.72	0.6	0.5	0.87	0.97	0.83
EV/EBITDA	- -	3.1	22.14	9	8.78	7.89	6.86	6.61	5.7	8.37	9.53	8.24
Price/Earnings	- -	- -	- -	- -	- -	3.88	8.45	7.78	12.21	17.28	15.71	12.57
Price/Earnings Average	- -	- -	-8.83	-5.05	-7.58	4.34	6.62	6.96	13.45	11.98	18.23	13.24
Price/Earnings High	- -	- -	-10.88	-6.54	-9.37	5.61	9.01	8.33	18.5	18.02	27.24	18.46
Price/Earnings Low	- -	- -	-7.26	-4.24	-5.67	3.52	2.96	5.04	9.89	7.5	12.2	7.27
Price/Book Value	- -	- -	0.87	1.11	-3.38	-22.36	8.87	-149.27	17.62	13.09	9.06	5.84
Price/Book Value Average	- -	- -	0.71	1.1	-3.35	-25.06	6.94	-133.42	19.41	9.07	10.52	6.15
Price/Book Value High	- -	- -	0.87	1.43	-4.13	-32.34	9.45	-159.78	26.7	13.65	15.72	8.57
Price/Book Value Low	- -	- -	0.58	0.93	-2.5	-20.34	3.1	-96.77	14.27	5.68	7.04	3.38
Price/Tangible Book Value	- -	- -	-0.23	-0.29	-0.28	-0.32	-1.3	-1.5	-1.02	-2.13	-2.83	-2.81
Price/Tangible Book Value Average	- -	- -	-0.19	-0.29	-0.28	-0.36	-1.02	-1.34	-1.13	-1.47	-3.28	-2.96
Price/Tangible Book Value High	- -	- -	-0.23	-0.37	-0.35	-0.46	-1.39	-1.61	-1.55	-2.22	-4.91	-4.13
Price/Tangible Book Value Low	- -	- -	-0.15	-0.24	-0.21	-0.29	-0.46	-0.97	-0.83	-0.92	-2.2	-1.63
Price/Sales	- -	- -	0.2	0.18	0.2	0.21	0.32	0.43	0.29	0.66	0.75	0.66
Price/Sales Average	- -	- -	0.17	0.18	0.19	0.24	0.25	0.38	0.32	0.46	0.88	0.69
Price/Sales High	- -	- -	0.2	0.24	0.24	0.31	0.34	0.46	0.44	0.69	1.31	0.96
Price/Sales Low	- -	- -	0.14	0.15	0.14	0.19	0.11	0.28	0.24	0.29	0.59	0.38
Price/Cash Flow	- -	- -	5.37	2.11	2.53	1.93	2.41	4.2	8.36	6.75	15.95	6.67
Price/Cash Flow Average	- -	- -	4.36	2.1	2.51	2.16	1.89	3.75	9.21	4.68	18.51	7.02
Price/Cash Flow High	- -	- -	5.37	2.72	3.09	2.79	2.57	4.5	12.67	7.04	27.67	9.79
Price/Cash Flow Low	- -	- -	3.58	1.77	1.87	1.75	0.84	2.72	6.77	2.93	12.39	3.86
Price/Free Cash Flow Average	- -	- -	4.36	2.1	2.51	2.24	1.94	3.9	9.45	4.68	19.14	7.37
Price/Free Cash Flow High	- -	- -	5.37	2.72	3.09	2.89	2.65	4.67	13	7.04	28.61	10.28
Price/Free Cash Flow Low	- -	- -	3.58	1.77	1.87	1.82	0.87	2.83	6.95	2.93	12.81	4.05
EV/Sales Average	- -	0.14	0.9	0.73	0.73	0.82	0.65	0.56	0.53	0.67	1.1	0.87
EV/Sales High	- -	0.14	0.94	0.79	0.78	0.89	0.74	0.63	0.65	0.9	1.53	1.14
EV/Sales Low	- -	0.14	0.87	0.71	0.68	0.77	0.51	0.45	0.44	0.5	0.81	0.56
EV/EBITDA Average	- -	3.1	21.97	9.34	8.76	8.15	6.2	6.11	6.04	6.42	10.71	8.59
EV/EBITDA High	- -	3.1	22.91	10.02	9.31	8.83	7.06	6.94	7.42	8.64	14.94	11.29
EV/EBITDA Low	- -	3.1	21.25	8.97	8.18	7.7	4.89	4.96	5.07	4.78	7.88	5.5
EV/EBIT Average	- -	-14.22	-23.43	-24.04	-346.5	29.3	15.28	12.08	9.34	10	15.73	11.67
EV/EBIT High	- -	-14.22	-24.43	-25.8	-368.08	31.76	17.39	13.72	11.48	13.45	21.95	15.34
EV/EBIT Low	- -	-14.22	-22.66	-23.09	-323.43	27.7	12.05	9.8	7.84	7.44	11.58	7.48
Last Price	- -	- -	17.68	20.12	24.61	24.71	36.92	56.81	40.62	82.88	103.6	114.44
High Price	- -	- -	17.68	25.93	30.09	35.74	39.37	60.81	61.54	86.45	179.7	168.08
Enterprise Value Average	- -	7,309	55,992	58,080	66,182	69,326	56,297	56,275	53,928	59,312	104,728	98,548
Enterprise Value High	- -	7,309	58,384	62,324	70,303	75,151	64,079	63,919	66,248	79,786	146,124	129,525
Enterprise Value Low	- -	7,309	54,152	55,779	61,775	65,543	44,400	45,646	45,227	44,123	77,061	63,155

	2015 Y	2016 Y	2017 Y	2018 Y	2019 Y	2020 Y	2021 Y	2022 Y	2023 Y	2024 Y	2025 Y	2026 Y
Shares Outstanding	- -	718	718	718	719	745	753	757	716	706	696	652
Diluted Weighted Avg Shares	718	718	718	718	719	751	767	791	753	706	720	684
Basic Weighted Avg Shares	718	718	718	718	719	724	744	762	734	706	696	652
Revenue per Share	75.36	70.86	86.53	110.02	126.04	117.15	116.49	132.8	139.37	125.19	137.28	174.2
EBITDA per Share	3.7	3.28	3.55	8.65	10.51	11.75	12.2	12.09	12.16	13.08	14.05	17.61
Operating Income per Share	-0.44	-0.72	-3.33	-3.36	-0.27	3.27	4.95	6.11	7.86	8.4	9.56	12.96
Basic EPS, GAAP	-1.7	-1.54	-1.62	-3.97	-3.21	6.38	4.37	7.3	3.33	4.8	6.6	9.11
Basic EPS from Cont Ops	-1.54	-1.63	-4.28	-4.07	-3.03	0.72	3.02	6.49	3.3	4.77	6.57	9.11
Diluted EPS, GAAP	-1.7	-1.54	-1.62	-3.97	-3.21	6.15	4.24	7.03	3.24	4.8	6.38	8.68
Diluted EPS from Cont Ops	-1.54	-1.63	-4.28	-4.07	-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.83	2.24
Cash Flow per Share	3.55	3.01	3.29	9.52	9.72	12.83	15.33	13.53	4.86	12.28	6.49	17.16
Free Cash Flow per Basic Share	3.55	3.01	3.29	9.52	9.72	12.83	15.33	13.53	4.86	12.28	6.49	17.16
Cash & Equivalents per Share	- -	8.8	15.94	22.45	13.46	12.85	12.78	12.44	11.73	10.43	5.22	17.69
Book Value per Share	- -	2.49	20.31	18.14	-7.28	-1.1	4.16	-0.38	2.31	6.33	11.43	19.61
Tangible Book Value per Share	- -	-21.45	-76.17	-70.04	-86.38	-77.37	-28.38	-37.81	-39.74	-38.98	-36.62	-40.74

Dell Technologies Inc.

Profitability (USD)

Credit (USD)

Liquidity (USD)

Working Capital (USD)

Enterprise Value (USD)

Multiples (USD)

Per Share Data Items (USD)