Projected Income Statement: PepsiCo, Inc.

Forecast Balance Sheet: PepsiCo, Inc.

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
Net Debt 1 34,599 34,346 33,723 34,102 35,040 39,450 39,668 39,846
Change - -0.73% -1.81% 1.12% 2.75% 12.59% 0.55% 0.45%
Announcement Date 11/02/21 10/02/22 09/02/23 09/02/24 04/02/25 - - -
1USD in Million
Estimates

Cash Flow Forecast: PepsiCo, Inc.

Fiscal Period: December 2020 2021 2022 2023 2024 2025 2026 2027
CAPEX 1 4,240 4,625 5,207 5,518 5,318 4,656 4,923 5,197
Change - 9.08% 12.58% 5.97% -3.62% -12.44% 5.73% 5.57%
Free Cash Flow (FCF) 1 6,373 6,991 5,604 7,924 7,189 9,136 10,368 12,015
Change - 9.7% -19.84% 41.4% -9.28% 27.08% 13.49% 15.88%
Announcement Date 11/02/21 10/02/22 09/02/23 09/02/24 04/02/25 - - -
1USD in Million
Estimates

Forecast Financial Ratios: PepsiCo, Inc.

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

Profitability

        
EBITDA Margin (%) 18.59% 17.77% 17.46% 18.39% 19.44% 19.43% 19.9% 20.37%
EBIT Margin (%) 14.96% 14.36% 14.27% 15.17% 16% 15.85% 16.37% 16.76%
EBT Margin (%) 12.89% 12.36% 12.39% 12.48% 13.01% 12.69% 14.35% 14.85%
Net margin (%) 10.12% 9.59% 10.31% 9.92% 10.43% 9.3% 10.75% 11.37%
FCF margin (%) 9.06% 8.8% 6.49% 8.66% 7.83% 9.78% 10.7% 12.02%
FCF / Net Income (%) 89.51% 91.77% 62.9% 87.33% 75.06% 105.21% 99.47% 105.69%

Profitability

        
ROA 8.3% 8.22% 9.66% 9.42% 9.58% 9.43% 10.62% 10.8%
ROE 50.42% 51.65% 53.69% 50.9% 52.42% 57.87% 53.83% 50.99%

Financial Health

        
Leverage (Debt/EBITDA) 2.65x 2.43x 2.24x 2.03x 1.96x 2.17x 2.06x 1.96x
Debt / Free cash flow 5.43x 4.91x 6.02x 4.3x 4.87x 4.32x 3.83x 3.32x

Capital Intensity

        
CAPEX / Current Assets (%) 6.03% 5.82% 6.03% 6.03% 5.79% 4.98% 5.08% 5.2%
CAPEX / EBITDA (%) 32.42% 32.75% 34.51% 32.8% 29.78% 25.65% 25.52% 25.52%
CAPEX / FCF (%) 66.53% 66.16% 92.92% 69.64% 73.97% 50.97% 47.48% 43.26%

Items per share

        
Cash flow per share 1 7.624 8.363 7.795 9.72 9.076 9.915 10.75 11.43
Change - 9.69% -6.79% 24.7% -6.62% 9.24% 8.45% 6.26%
Dividend per Share 1 4.022 4.248 4.525 4.945 - 5.61 5.899 6.219
Change - 5.59% 6.53% 9.28% - - 5.15% 5.43%
Book Value Per Share 1 9.749 11.6 12.45 13.47 13.15 14.93 16.94 18.77
Change - 18.98% 7.36% 8.16% -2.38% 13.57% 13.42% 10.79%
EPS 1 5.12 5.49 6.42 6.56 6.95 6.273 7.862 8.403
Change - 7.23% 16.94% 2.18% 5.95% -9.75% 25.34% 6.87%
Nbr of stocks (in thousands) 13,81,956 13,98,745 13,93,956 13,91,178 13,87,929 13,83,174 13,83,174 13,83,174
Announcement Date 11/02/21 10/02/22 09/02/23 09/02/24 04/02/25 - - -
1USD
Estimates
2025 *2026 *
P/E ratio 23.5x 18.8x
PBR 9.89x 8.72x
EV / Sales 2.61x 2.52x
Yield 3.8% 3.99%
More valuation ratios * Estimated data

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Trader
Investor
Global
Quality
ESG MSCI
BBB
More Ratings
Sell
Consensus
Buy
Mean consensus
HOLD
Number of Analysts
24
Last Close Price
147.66USD
Average target price
157.27USD
Spread / Average Target
+6.51%
Consensus

Quarterly revenue - Rate of surprise

  1. Stock Market
  2. Equities
  3. PEP Stock
  4. Financials PepsiCo, Inc.