Projected Income Statement: PepsiCo, Inc.

Forecast Balance Sheet: PepsiCo, Inc.

Forecast Balance Sheet - PepsiCo, Inc.
Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
Net Debt 1 34,346 33,723 34,102 35,040 39,652 38,338 37,721 36,857
Change - -1.81% 1.12% 2.75% 13.16% -3.31% -1.61% -2.29%
Announcement Date 2/10/22 2/9/23 2/9/24 2/4/25 2/3/26 - - -
1USD in Million
Estimates

Cash Flow Forecast: PepsiCo, Inc.

Fiscal Period: December 2021 2022 2023 2024 2025 2026 2027 2028
CAPEX 1 4,625 5,207 5,518 5,318 4,415 4,446 4,459 4,627
Change - 12.58% 5.97% -3.62% -16.98% 0.69% 0.31% 3.76%
Free Cash Flow (FCF) 1 6,991 5,604 7,924 7,189 7,672 10,522 11,652 12,586
Change - -19.84% 41.4% -9.28% 6.72% 37.14% 10.75% 8.01%
Announcement Date 2/10/22 2/9/23 2/9/24 2/4/25 2/3/26 - - -
1USD in Million
Estimates

Forecast Financial Ratios: PepsiCo, Inc.

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

Profitability

        
EBITDA Margin (%) 17.77% 17.46% 18.39% 19.44% 19.55% 19.59% 19.7% 20.02%
EBIT Margin (%) 14.36% 14.27% 15.17% 16% 15.88% 16.05% 16.15% 16.37%
EBT Margin (%) 12.36% 12.39% 12.48% 13.01% 10.91% 15.17% 14.09% 14.09%
Net margin (%) 9.59% 10.31% 9.92% 10.43% 8.77% 11.52% 11.2% 11.42%
FCF margin (%) 8.8% 6.49% 8.66% 7.83% 8.17% 10.64% 11.47% 11.96%
FCF / Net Income (%) 91.77% 62.9% 87.33% 75.06% 93.11% 92.36% 102.42% 104.75%

Profitability

        
ROA 8.22% 9.66% 9.42% 9.58% 7.97% 10.26% 10.29% 10.52%
ROE 51.65% 53.69% 50.9% 52.42% 54.77% 52.4% 47.72% 45.91%

Financial Health

        
Leverage (Debt/EBITDA) 2.43x 2.24x 2.03x 1.96x 2.16x 1.98x 1.88x 1.75x
Debt / Free cash flow 4.91x 6.02x 4.3x 4.87x 5.17x 3.64x 3.24x 2.93x

Capital Intensity

        
CAPEX / Current Assets (%) 5.82% 6.03% 6.03% 5.79% 4.7% 4.5% 4.39% 4.4%
CAPEX / EBITDA (%) 32.75% 34.51% 32.8% 29.78% 24.04% 22.95% 22.28% 21.96%
CAPEX / FCF (%) 66.16% 92.92% 69.64% 73.97% 57.55% 42.25% 38.27% 36.76%

Items per share

        
Cash flow per share 1 8.363 7.795 9.72 9.076 8.803 10.86 11.04 11.39
Change - -6.79% 24.7% -6.62% -3.01% 23.38% 1.64% 3.2%
Dividend per Share 1 4.248 4.525 4.945 - 5.622 5.856 6.141 6.516
Change - 6.53% 9.28% - - 4.16% 4.86% 6.11%
Book Value Per Share 1 11.6 12.45 13.47 13.15 14.93 17.47 19.44 21.05
Change - 7.36% 8.16% -2.38% 13.52% 17.04% 11.27% 8.26%
EPS 1 5.49 6.42 6.56 6.95 6 8.544 8.471 8.906
Change - 16.94% 2.18% 5.95% -13.67% 42.4% -0.86% 5.14%
Nbr of stocks (in thousands) 1,398,745 1,393,956 1,391,178 1,387,929 1,367,340 1,364,892 1,364,892 1,364,892
Announcement Date 2/10/22 2/9/23 2/9/24 2/4/25 2/3/26 - - -
1USD
Estimates
2026 *2027 *
P/E 14.7x 14.8x
PBR 7.2x 6.47x
EV / Sales 2.12x 2.06x
Yield 4.66% 4.89%

EPS & Dividend

EPS & Dividend - PepsiCo, Inc.


Y-o-Y evolution of P/E

Valuation ratios - P/E - PepsiCo, Inc.
 

Year-on-year evolution of the Yield

Valuation ratios - Yield - PepsiCo, Inc.
Trader
Investor
Global
Quality
ESG MSCI
-
Ratings Surperformance© - PepsiCo, Inc.
Sell
Consensus
Buy
Mean consensus
HOLD
Number of Analysts
24
Last Close Price
125.71USD
Average target price
148.64USD
Spread / Average Target
+18.24%

Quarterly revenue - Rate of surprise

Rate of surprise - Net sales - Quarterly - PepsiCo, Inc.