Stock Analysis on Net

Cisco Systems Inc. (NASDAQ:CSCO)

Adjustments to Financial Statements

Microsoft Excel

Adjustments to Current Assets

Cisco Systems Inc., adjusted current assets

US$ in millions

Microsoft Excel
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
As Reported
Current assets 36,862 43,348 36,717 39,112 43,573 47,755
Adjustments
Add: Allowance for credit loss 87 85 83 109 143 136
After Adjustment
Adjusted current assets 36,949 43,433 36,800 39,221 43,716 47,891

Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).


Adjustments to Total Assets

Cisco Systems Inc., adjusted total assets

US$ in millions

Microsoft Excel
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
As Reported
Total assets 124,413 101,852 94,002 97,497 94,853 97,793
Adjustments
Add: Operating lease right-of-use asset (before adoption of FASB Topic 842)1 1,095
Add: Allowance for credit loss 87 85 83 109 143 136
Less: Deferred tax assets2 6,262 6,576 4,449 4,360 3,990 4,065
After Adjustment
Adjusted total assets 118,238 95,361 89,636 93,246 91,006 94,959

Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).

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

2 Deferred tax assets. See details »


Adjustments to Current Liabilities

Cisco Systems Inc., adjusted current liabilities

US$ in millions

Microsoft Excel
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
As Reported
Current liabilities 40,584 31,309 25,640 26,257 25,331 31,712
Adjustments
Less: Current deferred revenue 16,249 13,908 12,784 12,148 11,406 10,668
After Adjustment
Adjusted current liabilities 24,335 17,401 12,856 14,109 13,925 21,044

Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).


Adjustments to Total Liabilities

Cisco Systems Inc., adjusted total liabilities

US$ in millions

Microsoft Excel
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
As Reported
Total liabilities 78,956 57,499 54,229 56,222 56,933 64,222
Adjustments
Add: Operating lease liability (before adoption of FASB Topic 842)1 1,095
Less: Deferred tax liabilities2 76 62 55 134 81 95
Less: Deferred revenue 28,475 25,550 23,264 22,164 20,446 18,467
Less: Product warranty liability 362 329 333 336 331 342
Less: Restructuring liability 274 213 9 34 73 33
After Adjustment
Adjusted total liabilities 49,769 31,345 30,568 33,554 36,002 46,380

Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).

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

2 Deferred tax liabilities. See details »


Adjustments to Stockholders’ Equity

Cisco Systems Inc., adjusted equity

US$ in millions

Microsoft Excel
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
As Reported
Equity 45,457 44,353 39,773 41,275 37,920 33,571
Adjustments
Less: Net deferred tax assets (liabilities)1 6,186 6,514 4,394 4,226 3,909 3,970
Add: Allowance for credit loss 87 85 83 109 143 136
Add: Deferred revenue 28,475 25,550 23,264 22,164 20,446 18,467
Add: Product warranty liability 362 329 333 336 331 342
Add: Restructuring liability 274 213 9 34 73 33
After Adjustment
Adjusted equity 68,469 64,016 59,068 59,692 55,004 48,579

Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).

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


Adjustments to Capitalization Table

Cisco Systems Inc., adjusted capitalization table

US$ in millions

Microsoft Excel
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
As Reported
Short-term debt 11,341 1,733 1,099 2,508 3,005 10,191
Long-term debt, excluding current portion 19,621 6,658 8,416 9,018 11,578 14,475
Total reported debt 30,962 8,391 9,515 11,526 14,583 24,666
Equity 45,457 44,353 39,773 41,275 37,920 33,571
Total reported capital 76,419 52,744 49,288 52,801 52,503 58,237
Adjustments to Debt
Add: Operating lease liability (before adoption of FASB Topic 842)1 1,095
Add: Operating lease liabilities (included in Other current liabilities)2 364 313 322 337 341
Add: Operating lease liabilities (included in Other long-term liabilities)3 906 707 724 831 661
Adjusted total debt 32,232 9,411 10,561 12,694 15,585 25,761
Adjustments to Equity
Less: Net deferred tax assets (liabilities)4 6,186 6,514 4,394 4,226 3,909 3,970
Add: Allowance for credit loss 87 85 83 109 143 136
Add: Deferred revenue 28,475 25,550 23,264 22,164 20,446 18,467
Add: Product warranty liability 362 329 333 336 331 342
Add: Restructuring liability 274 213 9 34 73 33
Adjusted equity 68,469 64,016 59,068 59,692 55,004 48,579
After Adjustment
Adjusted total capital 100,701 73,427 69,629 72,386 70,589 74,340

Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).

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

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

3 Operating lease liabilities (included in Other long-term liabilities). See details »

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


Adjustments to Revenues

Cisco Systems Inc., adjusted revenue

US$ in millions

Microsoft Excel
12 months ended: Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
As Reported
Revenue 53,803 56,998 51,557 49,818 49,301 51,904
Adjustment
Add: Increase (decrease) in deferred revenue 2,925 2,286 1,100 1,718 1,979 (1,218)
After Adjustment
Adjusted revenue 56,728 59,284 52,657 51,536 51,280 50,686

Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).


Adjustments to Reported Income

Cisco Systems Inc., adjusted net income

US$ in millions

Microsoft Excel
12 months ended: Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
As Reported
Net income 10,320 12,613 11,812 10,591 11,214 11,621
Adjustments
Add: Deferred income tax expense (benefit)1 (972) (2,084) (309) (384) (38) (350)
Add: Increase (decrease) in allowance for credit loss 2 2 (26) (34) 7 7
Add: Increase (decrease) in deferred revenue 2,925 2,286 1,100 1,718 1,979 (1,218)
Add: Increase (decrease) in product warranty liability 33 (4) (3) 5 (11) (17)
Add: Increase (decrease) in restructuring liability 61 204 (25) (38) 40 (40)
Add: Other comprehensive income (loss) 145 47 (1,205) 102 273 225
After Adjustment
Adjusted net income 12,514 13,064 11,344 11,960 13,464 10,228

Based on: 10-K (reporting date: 2024-07-27), 10-K (reporting date: 2023-07-29), 10-K (reporting date: 2022-07-30), 10-K (reporting date: 2021-07-31), 10-K (reporting date: 2020-07-25), 10-K (reporting date: 2019-07-27).

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