Stock Analysis on Net

Microsoft Corp. (NASDAQ:MSFT)

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Microsoft Corp., adjusted current assets

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
As Reported
Current assets 159,734 184,257 169,684 184,406 181,915 175,552
Adjustments
Add: Allowance for doubtful accounts 830 650 633 751 788 411
After Adjustment
Adjusted current assets 160,564 184,907 170,317 185,157 182,703 175,963

Based on: 10-K (reporting date: 2024-06-30), 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).


Adjustments to Total Assets

Microsoft Corp., adjusted total assets

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
As Reported
Total assets 512,163 411,976 364,840 333,779 301,311 286,556
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1
Add: Allowance for doubtful accounts 830 650 633 751 788 411
Less: Long-term deferred income tax assets (included in Other long-term assets)2 22,270 20,163 13,515 7,181 6,405 7,536
After Adjustment
Adjusted total assets 490,723 392,463 351,958 327,349 295,694 279,431

Based on: 10-K (reporting date: 2024-06-30), 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).

1 Operating lease right-of-use asset (before adoption of FASB Topic 842). See details »

2 Long-term deferred income tax assets (included in Other long-term assets). See details »


Adjustments to Current Liabilities

Microsoft Corp., adjusted current liabilities

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
As Reported
Current liabilities 125,286 104,149 95,082 88,657 72,310 69,420
Adjustments
Less: Short-term unearned revenue 57,582 50,901 45,538 41,525 36,000 32,676
After Adjustment
Adjusted current liabilities 67,704 53,248 49,544 47,132 36,310 36,744

Based on: 10-K (reporting date: 2024-06-30), 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).


Adjustments to Total Liabilities

Microsoft Corp., adjusted total liabilities

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
As Reported
Total liabilities 243,686 205,753 198,298 191,791 183,007 184,226
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1
Less: Long-term deferred income tax liabilities2 2,618 433 230 198 204 233
Less: Unearned revenue 60,184 53,813 48,408 44,141 39,180 37,206
After Adjustment
Adjusted total liabilities 180,884 151,507 149,660 147,452 143,623 146,787

Based on: 10-K (reporting date: 2024-06-30), 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).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Long-term deferred income tax liabilities. See details »


Adjustments to Stockholders’ Equity

Microsoft Corp., adjusted stockholders’ equity

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
As Reported
Stockholders’ equity 268,477 206,223 166,542 141,988 118,304 102,330
Adjustments
Less: Net deferred income tax assets (liabilities)1 19,652 19,730 13,285 6,983 6,201 7,303
Add: Allowance for doubtful accounts 830 650 633 751 788 411
Add: Unearned revenue 60,184 53,813 48,408 44,141 39,180 37,206
After Adjustment
Adjusted stockholders’ equity 309,839 240,956 202,298 179,897 152,071 132,644

Based on: 10-K (reporting date: 2024-06-30), 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).

1 Net deferred income tax assets (liabilities). See details »


Adjustments to Capitalization Table

Microsoft Corp., adjusted capitalization table

US$ in millions

Microsoft Excel
Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
As Reported
Short-term debt 6,693
Current portion of long-term debt 2,249 5,247 2,749 8,072 3,749 5,516
Current finance lease liabilities 2,349 1,197 1,060 791 540 317
Long-term debt, excluding current portion 42,688 41,990 47,032 50,074 59,578 66,662
Long-term finance lease liabilities 24,796 15,870 13,842 11,750 8,956 6,257
Total reported debt 78,775 64,304 64,683 70,687 72,823 78,752
Stockholders’ equity 268,477 206,223 166,542 141,988 118,304 102,330
Total reported capital 347,252 270,527 231,225 212,675 191,127 181,082
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1
Add: Operating lease liabilities (included in Other current liabilities)2 3,580 2,409 2,228 1,962 1,616 1,515
Add: Long-term operating lease liabilities3 15,497 12,728 11,489 9,629 7,671 6,188
Adjusted total debt 97,852 79,441 78,400 82,278 82,110 86,455
Adjustments to Equity
Less: Net deferred income tax assets (liabilities)4 19,652 19,730 13,285 6,983 6,201 7,303
Add: Allowance for doubtful accounts 830 650 633 751 788 411
Add: Unearned revenue 60,184 53,813 48,408 44,141 39,180 37,206
Adjusted stockholders’ equity 309,839 240,956 202,298 179,897 152,071 132,644
After Adjustment
Adjusted total capital 407,691 320,397 280,698 262,175 234,181 219,099

Based on: 10-K (reporting date: 2024-06-30), 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).

1 Operating lease liability (before adoption of FASB Topic 842). See details »

2 Operating lease liabilities (included in Other current liabilities). See details »

3 Long-term operating lease liabilities. See details »

4 Net deferred income tax assets (liabilities). See details »


Adjustments to Revenues

Microsoft Corp., adjusted revenue

US$ in millions

Microsoft Excel
12 months ended: Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
As Reported
Revenue 245,122 211,915 198,270 168,088 143,015 125,843
Adjustment
Add: Increase (decrease) in unearned revenue 6,371 5,405 4,267 4,961 1,974 4,486
After Adjustment
Adjusted revenue 251,493 217,320 202,537 173,049 144,989 130,329

Based on: 10-K (reporting date: 2024-06-30), 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).


Adjustments to Reported Income

Microsoft Corp., adjusted net income

US$ in millions

Microsoft Excel
12 months ended: Jun 30, 2024 Jun 30, 2023 Jun 30, 2022 Jun 30, 2021 Jun 30, 2020 Jun 30, 2019
As Reported
Net income 88,136 72,361 72,738 61,271 44,281 39,240
Adjustments
Add: Deferred income tax expense (benefit)1 (4,738) (6,059) (5,702) (150) 11 (6,463)
Add: Increase (decrease) in allowance for doubtful accounts 180 17 (118) (37) 377 34
Add: Increase (decrease) in unearned revenue 6,371 5,405 4,267 4,961 1,974 4,486
Add: Other comprehensive income (loss), net of tax 753 (1,665) (6,500) (1,374) 3,523 1,914
After Adjustment
Adjusted net income 90,702 70,059 64,685 64,671 50,166 39,211

Based on: 10-K (reporting date: 2024-06-30), 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).

1 Deferred income tax expense (benefit). See details »