Stock Analysis on Net

Cisco Systems Inc. (NASDAQ:CSCO)

Economic Value Added (EVA)

Microsoft Excel

EVA is registered trademark of Stern Stewart.

Economic value added or economic profit is the difference between revenues and costs,where costs include not only expenses, but also cost of capital.


Economic Profit

Cisco Systems Inc., economic profit calculation

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
Net operating profit after taxes (NOPAT)1 12,178 12,636 12,468 11,686 12,905 9,686
Cost of capital2 11.57% 12.45% 12.26% 12.24% 11.82% 11.61%
Invested capital3 91,785 58,979 59,063 57,460 53,498 53,469
 
Economic profit4 1,561 5,295 5,229 4,655 6,583 3,478

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 NOPAT. See details »

2 Cost of capital. See details »

3 Invested capital. See details »

4 2024 Calculation
Economic profit = NOPAT – Cost of capital × Invested capital
= 12,17811.57% × 91,785 = 1,561

Item Description The company
Economic profit Economic profit is a measure of corporate performance computed by taking the spread between the return on invested capital and the cost of capital, and multiplying by the invested capital. Cisco Systems Inc. economic profit increased from 2022 to 2023 but then decreased significantly from 2023 to 2024.

Net Operating Profit after Taxes (NOPAT)

Cisco Systems Inc., NOPAT calculation

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
Net income 10,320 12,613 11,812 10,591 11,214 11,621
Deferred income tax expense (benefit)1 (972) (2,084) (309) (384) (38) (350)
Increase (decrease) in allowance for credit loss2 2 2 (26) (34) 7 7
Increase (decrease) in deferred revenue3 2,925 2,286 1,100 1,718 1,979 (1,218)
Increase (decrease) in product warranty liability4 33 (4) (3) 5 (11) (17)
Increase (decrease) in restructuring liability5 61 204 (25) (38) 40 (40)
Increase (decrease) in equity equivalents6 2,049 404 737 1,267 1,977 (1,618)
Interest expense 1,006 427 360 434 585 859
Interest expense, operating lease liability7 51 32 23 20 15 35
Adjusted interest expense 1,057 459 383 454 600 894
Tax benefit of interest expense8 (222) (96) (80) (95) (126) (188)
Adjusted interest expense, after taxes9 835 362 303 359 474 706
(Gain) loss on marketable securities 67 21 (9) (53) (42) 13
Interest income (1,365) (962) (476) (618) (920) (1,308)
Investment income, before taxes (1,298) (941) (485) (671) (962) (1,295)
Tax expense (benefit) of investment income10 273 198 102 141 202 272
Investment income, after taxes11 (1,025) (743) (383) (530) (760) (1,023)
Net operating profit after taxes (NOPAT) 12,178 12,636 12,468 11,686 12,905 9,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).

1 Elimination of deferred tax expense. See details »

2 Addition of increase (decrease) in allowance for credit loss.

3 Addition of increase (decrease) in deferred revenue.

4 Addition of increase (decrease) in product warranty liability.

5 Addition of increase (decrease) in restructuring liability.

6 Addition of increase (decrease) in equity equivalents to net income.

7 2024 Calculation
Interest expense on capitalized operating leases = Operating lease liability × Discount rate
= 1,270 × 4.00% = 51

8 2024 Calculation
Tax benefit of interest expense = Adjusted interest expense × Statutory income tax rate
= 1,057 × 21.00% = 222

9 Addition of after taxes interest expense to net income.

10 2024 Calculation
Tax expense (benefit) of investment income = Investment income, before tax × Statutory income tax rate
= 1,298 × 21.00% = 273

11 Elimination of after taxes investment income.

Item Description The company
NOPAT Net operating profit after taxes is income from operations, but after removement of taxes calculated on cash basis that are relevant to operating income. Cisco Systems Inc. NOPAT increased from 2022 to 2023 but then decreased significantly from 2023 to 2024.

Cash Operating Taxes

Cisco Systems Inc., cash operating taxes calculation

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
Provision for income taxes 1,914 2,705 2,665 2,671 2,756 2,950
Less: Deferred income tax expense (benefit) (972) (2,084) (309) (384) (38) (350)
Add: Tax savings from interest expense 222 96 80 95 126 188
Less: Tax imposed on investment income 273 198 102 141 202 272
Cash operating taxes 2,835 4,688 2,953 3,009 2,718 3,216

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).

Item Description The company
Cash operating taxes Cash operating taxes are estimated by adjusting income tax expense for changes in deferred taxes and tax benefit from the interest deduction. Cisco Systems Inc. cash operating taxes increased from 2022 to 2023 but then decreased significantly from 2023 to 2024.

Invested Capital

Cisco Systems Inc., invested capital calculation (financing approach)

US$ in millions

Microsoft Excel
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
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
Operating lease liability1 1,270 1,020 1,046 1,168 1,002 1,095
Total reported debt & leases 32,232 9,411 10,561 12,694 15,585 25,761
Equity 45,457 44,353 39,773 41,275 37,920 33,571
Net deferred tax (assets) liabilities2 (6,186) (6,514) (4,394) (4,226) (3,909) (3,970)
Allowance for credit loss3 87 85 83 109 143 136
Deferred revenue4 28,475 25,550 23,264 22,164 20,446 18,467
Product warranty liability5 362 329 333 336 331 342
Restructuring liability6 274 213 9 34 73 33
Equity equivalents7 23,012 19,663 19,295 18,417 17,084 15,008
Accumulated other comprehensive (income) loss, net of tax8 1,430 1,575 1,622 417 519 792
Adjusted equity 69,899 65,591 60,690 60,109 55,523 49,371
Marketable securities9 (10,346) (16,023) (12,188) (15,343) (17,610) (21,663)
Invested capital 91,785 58,979 59,063 57,460 53,498 53,469

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 Addition of capitalized operating leases.

2 Elimination of deferred taxes from assets and liabilities. See details »

3 Addition of allowance for doubtful accounts receivable.

4 Addition of deferred revenue.

5 Addition of product warranty liability.

6 Addition of restructuring liability.

7 Addition of equity equivalents to equity.

8 Removal of accumulated other comprehensive income.

9 Subtraction of marketable securities.

Item Description The company
Invested capital Capital is an approximation of the economic book value of all cash invested in going-concern business activities. Cisco Systems Inc. invested capital decreased from 2022 to 2023 but then increased from 2023 to 2024 exceeding 2022 level.

Cost of Capital

Cisco Systems Inc., cost of capital calculations

Capital (fair value)1 Weights Cost of capital
Equity2 196,065 196,065 ÷ 228,591 = 0.86 0.86 × 12.82% = 10.99%
Debt3 31,256 31,256 ÷ 228,591 = 0.14 0.14 × 5.14% × (1 – 21.00%) = 0.56%
Operating lease liability4 1,270 1,270 ÷ 228,591 = 0.01 0.01 × 4.00% × (1 – 21.00%) = 0.02%
Total: 228,591 1.00 11.57%

Based on: 10-K (reporting date: 2024-07-27).

1 US$ in millions

2 Equity. See details »

3 Debt. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 230,275 230,275 ÷ 239,995 = 0.96 0.96 × 12.82% = 12.30%
Debt3 8,700 8,700 ÷ 239,995 = 0.04 0.04 × 4.78% × (1 – 21.00%) = 0.14%
Operating lease liability4 1,020 1,020 ÷ 239,995 = 0.00 0.00 × 3.10% × (1 – 21.00%) = 0.01%
Total: 239,995 1.00 12.45%

Based on: 10-K (reporting date: 2023-07-29).

1 US$ in millions

2 Equity. See details »

3 Debt. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 186,418 186,418 ÷ 197,764 = 0.94 0.94 × 12.82% = 12.08%
Debt3 10,300 10,300 ÷ 197,764 = 0.05 0.05 × 3.98% × (1 – 21.00%) = 0.16%
Operating lease liability4 1,046 1,046 ÷ 197,764 = 0.01 0.01 × 2.20% × (1 – 21.00%) = 0.01%
Total: 197,764 1.00 12.26%

Based on: 10-K (reporting date: 2022-07-30).

1 US$ in millions

2 Equity. See details »

3 Debt. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 247,159 247,159 ÷ 262,027 = 0.94 0.94 × 12.82% = 12.09%
Debt3 13,700 13,700 ÷ 262,027 = 0.05 0.05 × 3.36% × (1 – 21.00%) = 0.14%
Operating lease liability4 1,168 1,168 ÷ 262,027 = 0.00 0.00 × 1.70% × (1 – 21.00%) = 0.01%
Total: 262,027 1.00 12.24%

Based on: 10-K (reporting date: 2021-07-31).

1 US$ in millions

2 Equity. See details »

3 Debt. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 173,359 173,359 ÷ 191,761 = 0.90 0.90 × 12.82% = 11.59%
Debt3 17,400 17,400 ÷ 191,761 = 0.09 0.09 × 3.11% × (1 – 21.00%) = 0.22%
Operating lease liability4 1,002 1,002 ÷ 191,761 = 0.01 0.01 × 1.50% × (1 – 21.00%) = 0.01%
Total: 191,761 1.00 11.82%

Based on: 10-K (reporting date: 2020-07-25).

1 US$ in millions

2 Equity. See details »

3 Debt. See details »

4 Operating lease liability. See details »

Capital (fair value)1 Weights Cost of capital
Equity2 205,557 205,557 ÷ 232,945 = 0.88 0.88 × 12.82% = 11.31%
Debt3 26,293 26,293 ÷ 232,945 = 0.11 0.11 × 3.22% × (1 – 21.00%) = 0.29%
Operating lease liability4 1,095 1,095 ÷ 232,945 = 0.00 0.00 × 3.22% × (1 – 21.00%) = 0.01%
Total: 232,945 1.00 11.61%

Based on: 10-K (reporting date: 2019-07-27).

1 US$ in millions

2 Equity. See details »

3 Debt. See details »

4 Operating lease liability. See details »


Economic Spread Ratio

Cisco Systems Inc., economic spread ratio calculation, comparison to benchmarks

Microsoft Excel
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
Selected Financial Data (US$ in millions)
Economic profit1 1,561 5,295 5,229 4,655 6,583 3,478
Invested capital2 91,785 58,979 59,063 57,460 53,498 53,469
Performance Ratio
Economic spread ratio3 1.70% 8.98% 8.85% 8.10% 12.30% 6.51%
Benchmarks
Economic Spread Ratio, Competitors4
Apple Inc. 167.64% 140.81% 202.30% 198.63% 146.56% 90.62%
Arista Networks Inc. 28.25% 23.71% 38.70% 21.05% 26.54%
Dell Technologies Inc. -5.16% 1.39% 5.60% 0.99% -0.44% -5.79%
Super Micro Computer Inc. 9.98% 0.34% -7.12% -9.92% -4.82%

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 Economic profit. See details »

2 Invested capital. See details »

3 2024 Calculation
Economic spread ratio = 100 × Economic profit ÷ Invested capital
= 100 × 1,561 ÷ 91,785 = 1.70%

4 Click competitor name to see calculations.

Performance ratio Description The company
Economic spread ratio The ratio of economic profit to invested capital, also equal to the difference between return on invested capital (ROIC) and cost of capital. Cisco Systems Inc. economic spread ratio improved from 2022 to 2023 but then deteriorated significantly from 2023 to 2024.

Economic Profit Margin

Cisco Systems Inc., economic profit margin calculation, comparison to benchmarks

Microsoft Excel
Jul 27, 2024 Jul 29, 2023 Jul 30, 2022 Jul 31, 2021 Jul 25, 2020 Jul 27, 2019
Selected Financial Data (US$ in millions)
Economic profit1 1,561 5,295 5,229 4,655 6,583 3,478
 
Revenue 53,803 56,998 51,557 49,818 49,301 51,904
Add: Increase (decrease) in deferred revenue 2,925 2,286 1,100 1,718 1,979 (1,218)
Adjusted revenue 56,728 59,284 52,657 51,536 51,280 50,686
Performance Ratio
Economic profit margin2 2.75% 8.93% 9.93% 9.03% 12.84% 6.86%
Benchmarks
Economic Profit Margin, Competitors3
Apple Inc. 21.43% 22.15% 23.91% 23.08% 19.21% 17.69%
Arista Networks Inc. 21.37% 16.37% 22.73% 16.45% 19.52%
Dell Technologies Inc. -3.16% 0.77% 2.93% 0.85% -0.38% -4.96%
Super Micro Computer Inc. 3.38% 0.15% -2.57% -3.68% -1.56%

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 Economic profit. See details »

2 2024 Calculation
Economic profit margin = 100 × Economic profit ÷ Adjusted revenue
= 100 × 1,561 ÷ 56,728 = 2.75%

3 Click competitor name to see calculations.

Performance ratio Description The company
Economic profit margin The ratio of economic profit to sales. It is the company profit margin covering income efficiency and asset management. Economic profit margin is not biased in favor of capital-intensive business models, because any added capital is a cost to the economic profit margin. Cisco Systems Inc. economic profit margin deteriorated from 2022 to 2023 and from 2023 to 2024.