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 36,969 36,863 37,468
Change - -0.73% -1.81% 1.12% 2.75% 5.51% -0.29% 1.64%
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,757 5,029 5,079
Change - 9.08% 12.58% 5.97% -3.62% -10.55% 5.72% 1%
Free Cash Flow (FCF) 1 6,373 6,991 5,604 7,924 7,189 9,589 10,654 10,738
Change - 9.7% -19.84% 41.4% -9.28% 33.39% 11.1% 0.79%
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.3% 19.65% 20.01%
EBIT Margin (%) 14.96% 14.36% 14.27% 15.17% 16% 15.82% 16.19% 16.43%
EBT Margin (%) 12.89% 12.36% 12.39% 12.48% 13.01% 13.63% 14.61% 15.14%
Net margin (%) 10.12% 9.59% 10.31% 9.92% 10.43% 10.56% 11.45% 11.83%
FCF margin (%) 9.06% 8.8% 6.49% 8.66% 7.83% 10.43% 11.25% 10.96%
FCF / Net Income (%) 89.51% 91.77% 62.9% 87.33% 75.06% 98.78% 98.26% 92.65%

Profitability

        
ROA 8.3% 8.22% 9.66% 9.42% 9.58% 10.21% 10.47% 10.46%
ROE 50.42% 51.65% 53.69% 50.9% 52.42% 54.71% 52.14% 51.31%

Financial Health

        
Leverage (Debt/EBITDA) 2.65x 2.43x 2.24x 2.03x 1.96x 2.08x 1.98x 1.91x
Debt / Free cash flow 5.43x 4.91x 6.02x 4.3x 4.87x 3.86x 3.46x 3.49x

Capital Intensity

        
CAPEX / Current Assets (%) 6.03% 5.82% 6.03% 6.03% 5.79% 5.17% 5.31% 5.18%
CAPEX / EBITDA (%) 32.42% 32.75% 34.51% 32.8% 29.78% 26.81% 27.02% 25.91%
CAPEX / FCF (%) 66.53% 66.16% 92.92% 69.64% 73.97% 49.61% 47.2% 47.3%

Items per share

        
Cash flow per share 1 7.624 8.363 7.795 9.72 9.076 9.804 10.92 10.86
Change - 9.69% -6.79% 24.7% -6.62% 8.02% 11.38% -0.52%
Dividend per Share 1 4.022 4.248 4.525 4.945 - 5.629 5.884 6.191
Change - 5.59% 6.53% 9.28% - - 4.53% 5.22%
Book Value Per Share 1 9.749 11.6 12.45 13.47 13.15 15.12 16.87 17.92
Change - 18.98% 7.36% 8.16% -2.38% 14.95% 11.62% 6.18%
EPS 1 5.12 5.49 6.42 6.56 6.95 7.284 8.023 8.551
Change - 7.23% 16.94% 2.18% 5.95% 4.8% 10.15% 6.58%
Nbr of stocks (in thousands) 1,381,956 1,398,745 1,393,956 1,391,178 1,387,929 1,371,080 1,371,080 1,371,080
Announcement Date 11/02/21 10/02/22 09/02/23 09/02/24 04/02/25 - - -
1USD
Estimates
2025 *2026 *
P/E ratio 18.5x 16.8x
PBR 8.93x 8x
EV / Sales 2.42x 2.34x
Yield 4.17% 4.36%
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
A
More Ratings
Sell
Consensus
Buy
Mean consensus
HOLD
Number of Analysts
23
Last Close Price
135.04USD
Average target price
148.83USD
Spread / Average Target
+10.21%
Consensus

Quarterly revenue - Rate of surprise

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