Intrinsic Valuation of CSCO
CSCO Free Cash Flow Average and Growth over past 5Y   Key Statistics
Year   FCF FCF Growth
2021 $14,762,000,000 0.72% EPS (FY) 2.50   Market Cap 186B
2020 $14,656,000,000 -1.78% P/E Ratio 15.89 Total Asset 93B
2019 $14,922,000,000 16.29% Net Income 11B Total Debt 13B
2018 $12,832,000,000 -0.62% EBITDA 16B Total Liab 56B
2017 $12,912,000,000 3.93% Opr Margin 0.2755 Debt/Equity 0.26
2016 $12,424,000,000 PreTax Margin 0.2868   BV/Share 9.79
5Y Average FCF   $14,016,800,000 3.71%
Overall Market Assumptions:
Assumptions: P/E for No-Growth Company: 7.00  
Perpetual Growth Rate (g): 2.50% Historical US Bond Yield: 4.40%  
Discount Rete (WACC): 6.73% Current US Bond Yield: 1.48%  
Forcasting Future Free Cash Flow for next 6Y Modified Benjamin Graham's Intrinsic Value
Year   FCF Projection  
2022 $15,309,267,484 MBG Intrinsic Value $52.53
2023 $15,876,823,663
2024 $16,465,420,692
2025 $17,075,838,614
2026 $17,708,886,388
2027 $18,365,402,965
Terminal Value   $445,161,056,078   Net Worth/Share $8.66
DCF Valuation DCF Valuation "What If" Scenario Table
Enterprise Value $362,393,062,715 Growth Rate
(+) Cash & Cash Equivalents $24,532,000,000 88.64 1.50% 2.00% 2.50% 3.00% 3.50%
(-) Total Debt $12,694,000,000 WACC 6.63% 76.8 83.0 90.7 100.6 113.6
Equity Value $374,231,062,715 6.68% 76.0 82.1 89.7 99.3 111.9
Shares Outstanding 4222000000 6.73% 75.3 81.3 88.6 97.9 110.2
7.23% 68.8 73.5 79.3 86.5 95.5
DCF Intrinsic Value $88.64 7.73% 63.3 67.2 71.8 77.5 84.4
© Swarnadeep Seth (2022)