Projected Income Statement: Comcast Corporation

Forecast Balance Sheet: Comcast Corporation

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 92,020 91,309 90,062 90,875 91,771 89,819 89,815 90,808
Change - -0.77% -1.37% 0.9% 0.99% -2.13% -0% 1.11%
Announcement Date 28/01/21 27/01/22 26/01/23 25/01/24 30/01/25 - - -
1USD in Million
Estimates

Cash Flow Forecast: Comcast Corporation

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 9,179 9,174 10,626 12,242 12,181 11,145 11,252 11,222
Change - -0.05% 15.83% 15.21% -0.5% -8.51% 0.97% -0.27%
Free Cash Flow (FCF) 1 13,280 17,089 12,646 12,962 12,543 15,794 15,301 14,926
Change - 28.68% -26% 2.5% -3.23% 25.92% -3.12% -2.45%
Announcement Date 28/01/21 27/01/22 26/01/23 25/01/24 30/01/25 - - -
1USD in Million
Estimates

Forecast Financial Ratios: Comcast Corporation

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027

Profitability

        
EBITDA Margin (%) 29.77% 29.82% 30.03% 30.96% 30.77% 30.76% 30.36% 30.5%
EBIT Margin (%) 16.89% 17.89% 18.63% 19.18% 18.83% 18.33% 18.25% 18.33%
EBT Margin (%) 13.58% 16.41% 7.65% 16.84% 15.09% 14.92% 15.12% 14.94%
Net margin (%) 10.17% 12.17% 4.42% 12.66% 13.09% 11.24% 11.3% 11.17%
FCF margin (%) 12.82% 14.68% 10.41% 10.66% 10.14% 12.9% 12.15% 11.88%
FCF / Net Income (%) 126.07% 120.69% 235.49% 84.23% 77.46% 114.79% 107.55% 106.4%

Profitability

        
ROA 3.92% 5.15% 6.06% 5.89% 6.38% 5.56% 5.51% 5.61%
ROE 12.17% 16.14% 18.24% 20.16% 20.13% 16.77% 17.54% 17.04%

Financial Health

        
Leverage (Debt/EBITDA) 2.99x 2.63x 2.47x 2.41x 2.41x 2.39x 2.35x 2.37x
Debt / Free cash flow 6.93x 5.34x 7.12x 7.01x 7.32x 5.69x 5.87x 6.08x

Capital Intensity

        
CAPEX / Current Assets (%) 8.86% 7.88% 8.75% 10.07% 9.84% 9.11% 8.94% 8.93%
CAPEX / EBITDA (%) 29.78% 26.43% 29.15% 32.53% 32% 29.61% 29.43% 29.29%
CAPEX / FCF (%) 69.12% 53.68% 84.03% 94.45% 97.11% 70.56% 73.54% 75.18%

Items per share

        
Cash flow per share 1 5.35 6.263 5.962 6.871 7.081 8.069 8.356 8.739
Change - 17.06% -4.79% 15.24% 3.06% 13.96% 3.55% 4.59%
Dividend per Share 1 0.92 1 1.08 1.16 1.24 1.318 1.406 1.502
Change - 8.7% 8% 7.41% 6.9% 6.29% 6.66% 6.87%
Book Value Per Share 1 19.53 20.65 18.27 19.94 21.89 24.22 26.98 29.87
Change - 5.7% -11.5% 9.12% 9.81% 10.61% 11.42% 10.69%
EPS 1 2.28 3.04 1.21 3.71 4.14 3.687 4.047 4.292
Change - 33.33% -60.2% 206.61% 11.59% -10.95% 9.77% 6.06%
Nbr of stocks (in thousands) 4,575,323 4,568,923 4,323,409 4,025,080 3,826,540 3,733,704 3,733,704 3,733,704
Announcement Date 28/01/21 27/01/22 26/01/23 25/01/24 30/01/25 - - -
1USD
Estimates
2025 *2026 *
P/E ratio 9.52x 8.68x
PBR 1.45x 1.3x
EV / Sales 1.8x 1.75x
Yield 3.75% 4%
More valuation ratios * Estimated data

EPS & Dividend

Year-on-year evolution of the PER

Year-on-year evolution of the Yield

Trading Rating
Investor Rating
ESG MSCI
BBB
More Ratings
Sell
Consensus
Buy
Mean consensus
OUTPERFORM
Number of Analysts
29
Last Close Price
35.11USD
Average target price
40.17USD
Spread / Average Target
+14.42%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. CMCSA Stock
  4. Financials Comcast Corporation