Stock Analysis on Net

Dell Technologies Inc. (NYSE:DELL)

Financial Reporting Quality: Aggregate Accruals

Microsoft Excel

Earnings can be decomposed into cash and accrual components. The accrual component (aggregate accruals) has been found to have less persistence than the cash component, and therefore (1) earnings with higher accrual component are less persistent than earnings with smaller accrual component, all else equal; and (2) the cash component of earnings should receive a higher weighting evaluating company performance.


Balance-Sheet-Based Accruals Ratio

Dell Technologies Inc., balance sheet computation of aggregate accruals

US$ in millions

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
Operating Assets
Total assets 82,089 89,611 92,735 123,415 118,861 111,820
Less: Cash and cash equivalents 7,366 8,607 9,477 14,201 9,302 9,676
Operating assets 74,723 81,004 83,258 109,214 109,559 102,144
Operating Liabilities
Total liabilities 84,398 92,636 94,315 115,390 115,077 111,566
Less: Short-term debt 6,982 6,573 5,823 6,362 7,737 4,320
Less: Long-term debt 19,012 23,015 21,131 41,622 44,319 49,201
Operating liabilities 58,404 63,048 67,361 67,406 63,021 58,045
 
Net operating assets1 16,319 17,956 15,897 41,808 46,538 44,099
Balance-sheet-based aggregate accruals2 (1,637) 2,059 (25,911) (4,730) 2,439
Financial Ratio
Balance-sheet-based accruals ratio3 -9.55% 12.16% -89.81% -10.71% 5.38%
Benchmarks
Balance-Sheet-Based Accruals Ratio, Competitors4
Apple Inc. -12.64% -9.04% -2.12% 36.09% -11.31%
Arista Networks Inc. 17.14% 106.22% 24.14% 89.72%
Cisco Systems Inc. 75.07% -12.09% 5.96% 20.24% -7.26%
Super Micro Computer Inc. 3.74% 58.35% 8.42% 20.97% -16.37%
Balance-Sheet-Based Accruals Ratio, Sector
Technology Hardware & Equipment 0.00% -6.96% -13.35% 22.01% 200.00%
Balance-Sheet-Based Accruals Ratio, Industry
Information Technology 0.00% 9.02% 18.05% 19.29% 200.00%

Based on: 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), 10-K (reporting date: 2019-02-01).

1 2024 Calculation
Net operating assets = Operating assets – Operating liabilities
= 74,72358,404 = 16,319

2 2024 Calculation
Balance-sheet-based aggregate accruals = Net operating assets2024 – Net operating assets2023
= 16,31917,956 = -1,637

3 2024 Calculation
Balance-sheet-based accruals ratio = 100 × Balance-sheet-based aggregate accruals ÷ Avg. net operating assets
= 100 × -1,637 ÷ [(16,319 + 17,956) ÷ 2] = -9.55%

4 Click competitor name to see calculations.

Financial ratio Description The company
Balance-sheet-based accruals ratio Ratio is found by dividing balance-sheet-based aggregate accruals by average net operating assets. Using the balance-sheet-based accruals ratio, Dell Technologies Inc. improved earnings quality from 2023 to 2024.

Cash-Flow-Statement-Based Accruals Ratio

Dell Technologies Inc., cash flow statement computation of aggregate accruals

US$ in millions

Microsoft Excel
Feb 2, 2024 Feb 3, 2023 Jan 28, 2022 Jan 29, 2021 Jan 31, 2020 Feb 1, 2019
Net income (loss) attributable to Dell Technologies Inc. 3,211 2,442 5,563 3,250 4,616 (2,310)
Less: Change in cash from operating activities 8,676 3,565 10,307 11,407 9,291 6,991
Less: Change in cash from investing activities (2,783) (3,024) 1,306 (460) (4,686) 3,389
Cash-flow-statement-based aggregate accruals (2,682) 1,901 (6,050) (7,697) 11 (12,690)
Financial Ratio
Cash-flow-statement-based accruals ratio1 -15.65% 11.23% -20.97% -17.42% 0.02%
Benchmarks
Cash-Flow-Statement-Based Accruals Ratio, Competitors2
Apple Inc. -25.90% -14.62% 0.00% 4.86% -20.46%
Arista Networks Inc. 36.37% 52.90% 147.50% 164.55%
Cisco Systems Inc. 46.78% -7.65% -10.18% 1.64% -32.20%
Super Micro Computer Inc. 0.89% 56.84% 5.08% 19.76% -21.24%
Cash-Flow-Statement-Based Accruals Ratio, Sector
Technology Hardware & Equipment 0.00% -10.03% -4.10% -0.72% -32.83%
Cash-Flow-Statement-Based Accruals Ratio, Industry
Information Technology 0.00% 1.41% 2.96% 8.76% -15.45%

Based on: 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), 10-K (reporting date: 2019-02-01).

1 2024 Calculation
Cash-flow-statement-based accruals ratio = 100 × Cash-flow-statement-based aggregate accruals ÷ Avg. net operating assets
= 100 × -2,682 ÷ [(16,319 + 17,956) ÷ 2] = -15.65%

2 Click competitor name to see calculations.

Financial ratio Description The company
Cash-flow-statement-based accruals ratio Ratio is found by dividing cash-flow-statement-based aggregate accruals by average net operating assets. Using the cash-flow-statement-based accruals ratio, Dell Technologies Inc. deteriorated earnings quality from 2023 to 2024.