Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

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

Microsoft Corp., balance sheet computation of aggregate accruals

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Operating Assets
Total assets 411,976 364,840 333,779 301,311 286,556 258,848
Less: Cash and cash equivalents 34,704 13,931 14,224 13,576 11,356 11,946
Less: Short-term investments 76,558 90,826 116,110 122,951 122,463 121,822
Operating assets 300,714 260,083 203,445 164,784 152,737 125,080
Operating Liabilities
Total liabilities 205,753 198,298 191,791 183,007 184,226 176,130
Less: Current portion of long-term debt 5,247 2,749 8,072 3,749 5,516 3,998
Less: Current finance lease liabilities 1,197 1,060 791 540 317 176
Less: Long-term debt, excluding current portion 41,990 47,032 50,074 59,578 66,662 72,242
Less: Long-term finance lease liabilities 15,870 13,842 11,750 8,956 6,257 4,125
Operating liabilities 141,449 133,615 121,104 110,184 105,474 95,589
 
Net operating assets1 159,265 126,468 82,341 54,600 47,263 29,491
Balance-sheet-based aggregate accruals2 32,797 44,127 27,741 7,337 17,772
Financial Ratio
Balance-sheet-based accruals ratio3 22.96% 42.27% 40.52% 14.41% 46.31%
Benchmarks
Balance-Sheet-Based Accruals Ratio, Competitors4
Accenture PLC 16.32% 21.70% 27.93% 3.73% 42.14%
Adobe Inc. 1.85% -8.24% 14.14% 8.20% 2.25%
International Business Machines Corp. 2.42% 1.55% -7.39% -9.64%
Intuit Inc. -1.74% 85.68% 139.73% -1.39% 29.27%
Oracle Corp. 51.77% 9.90% 5.62% 1.35% 2.79%
Palo Alto Networks Inc. 137.01% -124.73% 85.21% 69.06%
Salesforce Inc. -2.30% 57.74% 10.87% 65.87%
ServiceNow Inc. 61.79% 12.89% 34.89% 19.95%
Synopsys Inc. 13.85% 5.01% 0.36% 8.40% 7.93%
Balance-Sheet-Based Accruals Ratio, Sector
Software & Services 18.82% 29.21% 17.08% 8.21% 200.00%
Balance-Sheet-Based Accruals Ratio, Industry
Information Technology 9.17% 21.79% 21.33% 2.87% 200.00%

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

1 2023 Calculation
Net operating assets = Operating assets – Operating liabilities
= 300,714141,449 = 159,265

2 2023 Calculation
Balance-sheet-based aggregate accruals = Net operating assets2023 – Net operating assets2022
= 159,265126,468 = 32,797

3 2023 Calculation
Balance-sheet-based accruals ratio = 100 × Balance-sheet-based aggregate accruals ÷ Avg. net operating assets
= 100 × 32,797 ÷ [(159,265 + 126,468) ÷ 2] = 22.96%

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, Microsoft Corp. improved earnings quality from 2022 to 2023.

Cash-Flow-Statement-Based Accruals Ratio

Microsoft Corp., cash flow statement computation of aggregate accruals

US$ in millions

Microsoft Excel
Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019 Jun 30, 2018
Net income 72,361 72,738 61,271 44,281 39,240 16,571
Less: Net cash from operations 87,582 89,035 76,740 60,675 52,185 43,884
Less: Net cash used in investing (22,680) (30,311) (27,577) (12,223) (15,773) (6,061)
Cash-flow-statement-based aggregate accruals 7,459 14,014 12,108 (4,171) 2,828 (21,252)
Financial Ratio
Cash-flow-statement-based accruals ratio1 5.22% 13.42% 17.68% -8.19% 7.37%
Benchmarks
Cash-Flow-Statement-Based Accruals Ratio, Competitors2
Accenture PLC -0.19% 11.87% 11.80% -13.65% -1.28%
Adobe Inc. -21.73% -19.93% 9.21% -0.48% -9.78%
International Business Machines Corp. 0.99% -7.22% -1.64% -13.41%
Intuit Inc. -8.74% 25.60% 58.72% -34.22% -15.95%
Oracle Corp. 42.79% -30.58% 25.81% -31.35% -74.80%
Palo Alto Networks Inc. -37.95% -196.64% -68.30% -488.47%
Salesforce Inc. -8.49% 21.96% 10.57% -5.62%
ServiceNow Inc. 15.44% 8.80% -21.14% -12.82%
Synopsys Inc. 0.20% -4.64% -4.88% 0.92% -0.96%
Cash-Flow-Statement-Based Accruals Ratio, Sector
Software & Services 6.92% 2.20% 12.17% -14.79% -3.07%
Cash-Flow-Statement-Based Accruals Ratio, Industry
Information Technology 1.25% 3.82% 10.69% -8.36% -22.15%

Based on: 10-K (reporting date: 2023-06-30), 10-K (reporting date: 2022-06-30), 10-K (reporting date: 2021-06-30), 10-K (reporting date: 2020-06-30), 10-K (reporting date: 2019-06-30), 10-K (reporting date: 2018-06-30).

1 2023 Calculation
Cash-flow-statement-based accruals ratio = 100 × Cash-flow-statement-based aggregate accruals ÷ Avg. net operating assets
= 100 × 7,459 ÷ [(159,265 + 126,468) ÷ 2] = 5.22%

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, Microsoft Corp. improved earnings quality from 2022 to 2023.