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,449 39,668 39,721
Change - -0.73% -1.81% 1.12% 2.75% 12.58% 0.56% 0.13%
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 5,044 5,234
Change - 9.08% 12.58% 5.97% -3.62% -12.44% 8.32% 3.76%
Free Cash Flow (FCF) 1 6,373 6,991 5,604 7,924 7,189 9,134 10,934 11,780
Change - 9.7% -19.84% 41.4% -9.28% 27.05% 19.71% 7.73%
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.83% 20.26%
EBIT Margin (%) 14.96% 14.36% 14.27% 15.17% 16% 15.79% 16.24% 16.59%
EBT Margin (%) 12.89% 12.36% 12.39% 12.48% 13.01% 11.51% 14.09% 14.45%
Net margin (%) 10.12% 9.59% 10.31% 9.92% 10.43% 9.29% 11.12% 11.3%
FCF margin (%) 9.06% 8.8% 6.49% 8.66% 7.83% 9.78% 11.3% 11.81%
FCF / Net Income (%) 89.51% 91.77% 62.9% 87.33% 75.06% 105.2% 101.59% 104.51%

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.77% 50.87%

Financial Health

        
Leverage (Debt/EBITDA) 2.65x 2.43x 2.24x 2.03x 1.96x 2.17x 2.07x 1.97x
Debt / Free cash flow 5.43x 4.91x 6.02x 4.3x 4.87x 4.32x 3.63x 3.37x

Capital Intensity

        
CAPEX / Current Assets (%) 6.03% 5.82% 6.03% 6.03% 5.79% 4.98% 5.21% 5.25%
CAPEX / EBITDA (%) 32.42% 32.75% 34.51% 32.8% 29.78% 25.65% 26.29% 25.9%
CAPEX / FCF (%) 66.53% 66.16% 92.92% 69.64% 73.97% 50.98% 46.13% 44.43%

Items per share

        
Cash flow per share 1 7.624 8.363 7.795 9.72 9.076 9.915 10.88 11.24
Change - 9.69% -6.79% 24.7% -6.62% 9.24% 9.7% 3.33%
Dividend per Share 1 4.022 4.248 4.525 4.945 - 5.612 5.899 6.219
Change - 5.59% 6.53% 9.28% - - 5.12% 5.43%
Book Value Per Share 1 9.749 11.6 12.45 13.47 13.15 14.93 16.94 18.7
Change - 18.98% 7.36% 8.16% -2.38% 13.57% 13.42% 10.42%
EPS 1 5.12 5.49 6.42 6.56 6.95 6.273 8.014 8.34
Change - 7.23% 16.94% 2.18% 5.95% -9.75% 27.76% 4.07%
Nbr of stocks (in thousands) 1,381,956 1,398,745 1,393,956 1,391,178 1,387,929 1,383,174 1,383,174 1,383,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.9x 18.7x
PBR 10x 8.84x
EV / Sales 2.64x 2.55x
Yield 3.75% 3.94%
More valuation ratios * Estimated data

EPS & Dividend

Y-o-Y evolution of P/E

Year-on-year evolution of the Yield

Sell
Consensus
Buy
Mean consensus
HOLD
Number of Analysts
24
Last Close Price
149.70USD
Average target price
155.14USD
Spread / Average Target
+3.63%
Consensus

Quarterly revenue - Rate of surprise

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