Stock Analysis on Net

Dell Technologies Inc. (NYSE:DELL)

Analysis of Short-term (Operating) Activity Ratios 

Microsoft Excel

Short-term Activity Ratios (Summary)

Dell Technologies Inc., short-term (operating) activity ratios

Microsoft Excel
Jan 31, 2025 Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020
Turnover Ratios
Inventory turnover 11.07 18.65 16.67 13.45 19.05 19.27
Receivables turnover 9.28 9.46 8.20 7.84 7.37 7.38
Payables turnover 3.57 3.48 4.28 2.92 2.99 3.15
Working capital turnover
Average No. Days
Average inventory processing period 33 20 22 27 19 19
Add: Average receivable collection period 39 39 45 47 50 49
Operating cycle 72 59 67 74 69 68
Less: Average payables payment period 102 105 85 125 122 116
Cash conversion cycle -30 -46 -18 -51 -53 -48

Based on: 10-K (reporting date: 2025-01-31), 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31).

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Dell Technologies Inc. inventory turnover ratio improved from 2023 to 2024 but then deteriorated significantly from 2024 to 2025.
Receivables turnover An activity ratio equal to revenue divided by receivables. Dell Technologies Inc. receivables turnover ratio improved from 2023 to 2024 but then slightly deteriorated from 2024 to 2025.
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Dell Technologies Inc. payables turnover ratio decreased from 2023 to 2024 but then slightly increased from 2024 to 2025.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Dell Technologies Inc. number of days of inventory outstanding improved from 2023 to 2024 but then deteriorated significantly from 2024 to 2025.
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover.
Operating cycle Equal to average inventory processing period plus average receivables collection period. Dell Technologies Inc. operating cycle improved from 2023 to 2024 but then deteriorated significantly from 2024 to 2025.
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Dell Technologies Inc. number of days of payables outstanding increased from 2023 to 2024 but then slightly decreased from 2024 to 2025.
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. Dell Technologies Inc. cash conversion cycle improved from 2023 to 2024 but then slightly deteriorated from 2024 to 2025 not reaching 2023 level.

Inventory Turnover

Dell Technologies Inc., inventory turnover calculation, comparison to benchmarks

Microsoft Excel
Jan 31, 2025 Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020
Selected Financial Data (US$ in millions)
Cost of net revenue 74,317 67,556 79,615 79,306 64,807 63,221
Inventories 6,716 3,622 4,776 5,898 3,402 3,281
Short-term Activity Ratio
Inventory turnover1 11.07 18.65 16.67 13.45 19.05 19.27
Benchmarks
Inventory Turnover, Competitors2
Apple Inc. 28.87 33.82 45.20 32.37 41.75
Arista Networks Inc. 1.37 1.15 1.32 1.64 1.74
Cisco Systems Inc. 5.63 5.83 7.52 11.50 13.74
Super Micro Computer Inc. 2.98 4.04 2.84 2.90 3.30
Inventory Turnover, Sector
Technology Hardware & Equipment 15.27 17.81 20.20 22.66 25.52
Inventory Turnover, Industry
Information Technology 7.86 8.01 8.61 10.44 11.17

Based on: 10-K (reporting date: 2025-01-31), 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31).

1 2025 Calculation
Inventory turnover = Cost of net revenue ÷ Inventories
= 74,317 ÷ 6,716 = 11.07

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Inventory turnover An activity ratio calculated as cost of goods sold divided by inventory. Dell Technologies Inc. inventory turnover ratio improved from 2023 to 2024 but then deteriorated significantly from 2024 to 2025.

Receivables Turnover

Dell Technologies Inc., receivables turnover calculation, comparison to benchmarks

Microsoft Excel
Jan 31, 2025 Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020
Selected Financial Data (US$ in millions)
Net revenue 95,567 88,425 102,301 101,197 94,224 92,154
Accounts receivable, net of allowance 10,298 9,343 12,482 12,912 12,788 12,484
Short-term Activity Ratio
Receivables turnover1 9.28 9.46 8.20 7.84 7.37 7.38
Benchmarks
Receivables Turnover, Competitors2
Apple Inc. 11.70 12.99 13.99 13.92 17.03
Arista Networks Inc. 6.14 5.72 4.75 5.71 5.95
Cisco Systems Inc. 8.05 9.74 7.79 8.64 9.01
Super Micro Computer Inc. 5.48 6.20 6.23 7.67 8.27
Receivables Turnover, Sector
Technology Hardware & Equipment 10.41 11.11 11.25 11.27 12.09
Receivables Turnover, Industry
Information Technology 6.98 7.46 7.43 7.53 7.92

Based on: 10-K (reporting date: 2025-01-31), 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31).

1 2025 Calculation
Receivables turnover = Net revenue ÷ Accounts receivable, net of allowance
= 95,567 ÷ 10,298 = 9.28

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Receivables turnover An activity ratio equal to revenue divided by receivables. Dell Technologies Inc. receivables turnover ratio improved from 2023 to 2024 but then slightly deteriorated from 2024 to 2025.

Payables Turnover

Dell Technologies Inc., payables turnover calculation, comparison to benchmarks

Microsoft Excel
Jan 31, 2025 Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020
Selected Financial Data (US$ in millions)
Cost of net revenue 74,317 67,556 79,615 79,306 64,807 63,221
Accounts payable 20,832 19,389 18,598 27,143 21,696 20,065
Short-term Activity Ratio
Payables turnover1 3.57 3.48 4.28 2.92 2.99 3.15
Benchmarks
Payables Turnover, Competitors2
Apple Inc. 3.05 3.42 3.49 3.89 4.01
Arista Networks Inc. 6.59 5.13 7.33 5.27 6.23
Cisco Systems Inc. 8.24 9.19 8.47 7.59 7.94
Super Micro Computer Inc. 8.78 7.52 6.71 4.94 6.74
Payables Turnover, Sector
Technology Hardware & Equipment 3.38 3.81 3.48 3.76 3.90
Payables Turnover, Industry
Information Technology 4.27 4.79 4.25 4.63 4.91

Based on: 10-K (reporting date: 2025-01-31), 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31).

1 2025 Calculation
Payables turnover = Cost of net revenue ÷ Accounts payable
= 74,317 ÷ 20,832 = 3.57

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Payables turnover An activity ratio calculated as cost of goods sold divided by payables. Dell Technologies Inc. payables turnover ratio decreased from 2023 to 2024 but then slightly increased from 2024 to 2025.

Working Capital Turnover

Dell Technologies Inc., working capital turnover calculation, comparison to benchmarks

Microsoft Excel
Jan 31, 2025 Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020
Selected Financial Data (US$ in millions)
Current assets 36,229 35,947 42,351 45,033 43,567 36,868
Less: Current liabilities 46,527 48,494 51,654 56,219 54,132 52,456
Working capital (10,298) (12,547) (9,303) (11,186) (10,565) (15,588)
 
Net revenue 95,567 88,425 102,301 101,197 94,224 92,154
Short-term Activity Ratio
Working capital turnover1
Benchmarks
Working Capital Turnover, Competitors2
Apple Inc. 39.10 7.16
Arista Networks Inc. 0.76 0.90 1.03 0.80 0.76
Cisco Systems Inc. 4.73 4.65 3.88 2.70
Super Micro Computer Inc. 2.28 3.95 3.89 3.96 3.77
Working Capital Turnover, Sector
Technology Hardware & Equipment 59.87 31.78 9.38
Working Capital Turnover, Industry
Information Technology 8.94 5.77 6.47 4.33 3.30

Based on: 10-K (reporting date: 2025-01-31), 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31).

1 2025 Calculation
Working capital turnover = Net revenue ÷ Working capital
= 95,567 ÷ -10,298 =

2 Click competitor name to see calculations.


Average Inventory Processing Period

Dell Technologies Inc., average inventory processing period calculation, comparison to benchmarks

Microsoft Excel
Jan 31, 2025 Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020
Selected Financial Data
Inventory turnover 11.07 18.65 16.67 13.45 19.05 19.27
Short-term Activity Ratio (no. days)
Average inventory processing period1 33 20 22 27 19 19
Benchmarks (no. days)
Average Inventory Processing Period, Competitors2
Apple Inc. 13 11 8 11 9
Arista Networks Inc. 267 318 276 222 210
Cisco Systems Inc. 65 63 49 32 27
Super Micro Computer Inc. 122 90 128 126 110
Average Inventory Processing Period, Sector
Technology Hardware & Equipment 24 20 18 16 14
Average Inventory Processing Period, Industry
Information Technology 46 46 42 35 33

Based on: 10-K (reporting date: 2025-01-31), 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31).

1 2025 Calculation
Average inventory processing period = 365 ÷ Inventory turnover
= 365 ÷ 11.07 = 33

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average inventory processing period An activity ratio equal to the number of days in the period divided by inventory turnover over the period. Dell Technologies Inc. number of days of inventory outstanding improved from 2023 to 2024 but then deteriorated significantly from 2024 to 2025.

Average Receivable Collection Period

Dell Technologies Inc., average receivable collection period calculation, comparison to benchmarks

Microsoft Excel
Jan 31, 2025 Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020
Selected Financial Data
Receivables turnover 9.28 9.46 8.20 7.84 7.37 7.38
Short-term Activity Ratio (no. days)
Average receivable collection period1 39 39 45 47 50 49
Benchmarks (no. days)
Average Receivable Collection Period, Competitors2
Apple Inc. 31 28 26 26 21
Arista Networks Inc. 59 64 77 64 61
Cisco Systems Inc. 45 37 47 42 41
Super Micro Computer Inc. 67 59 59 48 44
Average Receivable Collection Period, Sector
Technology Hardware & Equipment 35 33 32 32 30
Average Receivable Collection Period, Industry
Information Technology 52 49 49 48 46

Based on: 10-K (reporting date: 2025-01-31), 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31).

1 2025 Calculation
Average receivable collection period = 365 ÷ Receivables turnover
= 365 ÷ 9.28 = 39

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average receivable collection period An activity ratio equal to the number of days in the period divided by receivables turnover.

Operating Cycle

Dell Technologies Inc., operating cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Jan 31, 2025 Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020
Selected Financial Data
Average inventory processing period 33 20 22 27 19 19
Average receivable collection period 39 39 45 47 50 49
Short-term Activity Ratio
Operating cycle1 72 59 67 74 69 68
Benchmarks
Operating Cycle, Competitors2
Apple Inc. 44 39 34 37 30
Arista Networks Inc. 326 382 353 286 271
Cisco Systems Inc. 110 100 96 74 68
Super Micro Computer Inc. 189 149 187 174 154
Operating Cycle, Sector
Technology Hardware & Equipment 59 53 50 48 44
Operating Cycle, Industry
Information Technology 98 95 91 83 79

Based on: 10-K (reporting date: 2025-01-31), 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31).

1 2025 Calculation
Operating cycle = Average inventory processing period + Average receivable collection period
= 33 + 39 = 72

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Operating cycle Equal to average inventory processing period plus average receivables collection period. Dell Technologies Inc. operating cycle improved from 2023 to 2024 but then deteriorated significantly from 2024 to 2025.

Average Payables Payment Period

Dell Technologies Inc., average payables payment period calculation, comparison to benchmarks

Microsoft Excel
Jan 31, 2025 Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020
Selected Financial Data
Payables turnover 3.57 3.48 4.28 2.92 2.99 3.15
Short-term Activity Ratio (no. days)
Average payables payment period1 102 105 85 125 122 116
Benchmarks (no. days)
Average Payables Payment Period, Competitors2
Apple Inc. 120 107 105 94 91
Arista Networks Inc. 55 71 50 69 59
Cisco Systems Inc. 44 40 43 48 46
Super Micro Computer Inc. 42 49 54 74 54
Average Payables Payment Period, Sector
Technology Hardware & Equipment 108 96 105 97 94
Average Payables Payment Period, Industry
Information Technology 85 76 86 79 74

Based on: 10-K (reporting date: 2025-01-31), 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31).

1 2025 Calculation
Average payables payment period = 365 ÷ Payables turnover
= 365 ÷ 3.57 = 102

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Average payables payment period An estimate of the average number of days it takes a company to pay its suppliers; equal to the number of days in the period divided by payables turnover ratio for the period. Dell Technologies Inc. number of days of payables outstanding increased from 2023 to 2024 but then slightly decreased from 2024 to 2025.

Cash Conversion Cycle

Dell Technologies Inc., cash conversion cycle calculation, comparison to benchmarks

No. days

Microsoft Excel
Jan 31, 2025 Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020
Selected Financial Data
Average inventory processing period 33 20 22 27 19 19
Average receivable collection period 39 39 45 47 50 49
Average payables payment period 102 105 85 125 122 116
Short-term Activity Ratio
Cash conversion cycle1 -30 -46 -18 -51 -53 -48
Benchmarks
Cash Conversion Cycle, Competitors2
Apple Inc. -76 -68 -71 -57 -61
Arista Networks Inc. 271 311 303 217 212
Cisco Systems Inc. 66 60 53 26 22
Super Micro Computer Inc. 147 100 133 100 100
Cash Conversion Cycle, Sector
Technology Hardware & Equipment -49 -43 -55 -49 -50
Cash Conversion Cycle, Industry
Information Technology 13 19 5 4 5

Based on: 10-K (reporting date: 2025-01-31), 10-K (reporting date: 2024-02-02), 10-K (reporting date: 2023-02-03), 10-K (reporting date: 2022-01-28), 10-K (reporting date: 2021-01-29), 10-K (reporting date: 2020-01-31).

1 2025 Calculation
Cash conversion cycle = Average inventory processing period + Average receivable collection period – Average payables payment period
= 33 + 39102 = -30

2 Click competitor name to see calculations.

Short-term activity ratio Description The company
Cash conversion cycle A financial metric that measures the length of time required for a company to convert cash invested in its operations to cash received as a result of its operations; equal to average inventory processing period plus average receivables collection period minus average payables payment period. Dell Technologies Inc. cash conversion cycle improved from 2023 to 2024 but then slightly deteriorated from 2024 to 2025 not reaching 2023 level.