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 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019 Jul 28, 2018
As Reported
Current assets 43,348 36,717 39,112 43,573 47,755 61,837
Adjustments
Add: Allowance for credit loss 85 83 109 143 136 129
After Adjustment
Adjusted current assets 43,433 36,800 39,221 43,716 47,891 61,966

Based on: 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), 10-K (reporting date: 2018-07-28).


Adjustments to Total Assets

Cisco Systems Inc., adjusted total assets

US$ in millions

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

Based on: 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), 10-K (reporting date: 2018-07-28).

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 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019 Jul 28, 2018
As Reported
Current liabilities 31,309 25,640 26,257 25,331 31,712 27,035
Adjustments
Less: Current deferred revenue 13,908 12,784 12,148 11,406 10,668 11,490
After Adjustment
Adjusted current liabilities 17,401 12,856 14,109 13,925 21,044 15,545

Based on: 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), 10-K (reporting date: 2018-07-28).


Adjustments to Total Liabilities

Cisco Systems Inc., adjusted total liabilities

US$ in millions

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

Based on: 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), 10-K (reporting date: 2018-07-28).

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 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019 Jul 28, 2018
As Reported
Equity 44,353 39,773 41,275 37,920 33,571 43,204
Adjustments
Less: Net deferred tax assets (liabilities)1 6,514 4,394 4,226 3,909 3,970 3,078
Add: Allowance for credit loss 85 83 109 143 136 129
Add: Deferred revenue 25,550 23,264 22,164 20,446 18,467 19,685
Add: Product warranty liability 329 333 336 331 342 359
Add: Restructuring liability 213 9 34 73 33 73
After Adjustment
Adjusted equity 64,016 59,068 59,692 55,004 48,579 60,372

Based on: 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), 10-K (reporting date: 2018-07-28).

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


Adjustments to Capitalization Table

Cisco Systems Inc., adjusted capitalization table

US$ in millions

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

Based on: 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), 10-K (reporting date: 2018-07-28).

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 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019 Jul 28, 2018
As Reported
Revenue 56,998 51,557 49,818 49,301 51,904 49,330
Adjustment
Add: Increase (decrease) in deferred revenue 2,286 1,100 1,718 1,979 (1,218) 1,191
After Adjustment
Adjusted revenue 59,284 52,657 51,536 51,280 50,686 50,521

Based on: 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), 10-K (reporting date: 2018-07-28).


Adjustments to Reported Income

Cisco Systems Inc., adjusted net income

US$ in millions

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

Based on: 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), 10-K (reporting date: 2018-07-28).

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