PepsiCo Financial Model
Beverages Company Financials Example (Free Excel Download)
PepsiCo is a global leader in the convenient foods and beverages industry, manufacturing and distributing a massive portfolio of iconic brands including Lay's, Doritos, Pepsi, and Gatorade.
professionals from Deloitte
Used by professionals from
About this model
This financial model projects PepsiCo's consolidated earnings and cash flows to determine its intrinsic equity value and assess its capacity for continued dividend growth and share repurchases.
PepsiCo is a global leader in the convenient foods and beverages industry, manufacturing and distributing a massive portfolio of iconic brands including Lay's, Doritos, Pepsi, and Gatorade. The company operates through seven distinct business segments: PepsiCo Beverages North America (PBNA, ~30% of revenue), Frito-Lay North America (FLNA, ~30%), Europe (~18%), Latin America (~13%), Africa, Middle East and South Asia (AMESA, ~7%), Asia Pacific, Australia and New Zealand and China Region (APAC, ~5%), and Quaker Foods North America (QFNA, ~3%). North America accounts for approximately 60% of total revenue, while international markets contribute the remaining 40%. The business model blends asset-heavy manufacturing with direct-store-delivery (DSD) distribution networks and franchise bottling operations. PepsiCo holds a dominant global market share in savoury snacks and operates in a rational duopoly with Coca-Cola in the beverage sector. Recent major events include the ongoing "pep+" sustainability and productivity transformation programme, as well as a significant product recall in the Quaker Foods division during 2023 and 2024 that temporarily depressed segment volumes.
The downloadable PepsiCo financial model includes SEC-sourced historical financials, forecast assumptions, core operating schedules, and valuation outputs in an Excel workbook built for review and scenario analysis.
A turnkey financial model
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
Historicals & AssumptionsPepsiCo financial modelCompany, Historicals & Assumptions used
Source: SEC EDGAR · values in USD
| Line item | FY2021 | FY2022 | FY2023 | FY2024 | FY2025 |
|---|---|---|---|---|---|
| Revenue | $79.47B | $86.39B | $91.47B | $91.85B | $93.92B |
| Gross profit | $42.40B | $45.82B | $49.59B | $50.11B | $50.86B |
| Operating income | $11.16B | $11.51B | $11.99B | $12.89B | $11.50B |
| Net income | $7.62B | $8.91B | $9.07B | $9.58B | $8.24B |
Forecast assumptions
Defaults used in the downloadable model. Forecast horizon: FY2026–FY2030.
See 8 moreSee less
How to build a detailed financial model for PepsiCo
A complete walkthrough of every driver, margin, working-capital input, and capital-allocation assumption used in the downloadable model.
Revenue Deep Dive
Frito-Lay North America (FLNA)
- Segment name: Frito-Lay North America
- Revenue driver formula: Snack Volume (Pounds/Servings) x Effective Net Pricing per Unit
- Historical growth rate: 5-8% CAGR
- Key growth levers and headwinds: Premiumisation, portion-control packaging, and spicy flavour innovations drive growth, while consumer pushback on cumulative inflation serves as a headwind.
- Pricing dynamics: High pricing power due to dominant market share and direct-store-delivery execution.
- Revenue recognition notes: Recognised upon delivery to retail customers, net of significant trade promotions and slotting fees.
- Seasonality: Strongest in the fourth quarter due to holiday gatherings and the lead-up to the Super Bowl.
PepsiCo Beverages North America (PBNA)
- Segment name: PepsiCo Beverages North America
- Revenue driver formula: Beverage Volume (Physical Cases) x Effective Net Pricing per Case
- Historical growth rate: 4-6% CAGR
- Key growth levers and headwinds: Transition to zero-sugar variants and expansion in sports nutrition (Gatorade) and energy drinks drive growth, offset by secular declines in traditional sugary carbonated soft drinks.
- Pricing dynamics: Highly competitive but rational pricing environment shared with primary competitor Coca-Cola.
- Revenue recognition notes: Recognised upon delivery; includes concentrate sales to independent bottlers and finished goods sales.
- Seasonality: Strongest in the second and third quarters due to warmer summer weather driving hydration needs.
Quaker Foods North America (QFNA)
- Segment name: Quaker Foods North America
- Revenue driver formula: Volume x Effective Net Pricing
- Historical growth rate: Flat to 2% CAGR
- Key growth levers and headwinds: Convenience breakfast trends provide a lever, but the segment faced severe headwinds from a major product recall in 2023 and 2024.
- Pricing dynamics: Highly competitive grocery aisle environment with significant private label pressure.
- Revenue recognition notes: Standard point-of-sale recognition net of trade spend.
- Seasonality: Strongest in the first and fourth quarters due to colder weather driving hot cereal consumption.
International Segments (Latin America, Europe, AMESA, APAC)
- Segment names: Latin America; Europe; Africa, Middle East and South Asia (AMESA); Asia Pacific, Australia and New Zealand and China Region (APAC)
- Revenue driver formula: Local Currency Volume x Local Currency Pricing x Foreign Exchange Translation Rate
- Historical growth rate: 6-12% organic CAGR (highly variable on a reported basis due to FX)
- Key growth levers and headwinds: Expanding middle classes and per capita consumption in emerging markets drive growth, while strong US Dollar translation and geopolitical disruptions act as headwinds.
- Pricing dynamics: Pricing is frequently used to offset high local inflation, particularly in Latin America and AMESA.
- Revenue recognition notes: Mix of franchise concentrate sales and direct finished goods distribution depending on the specific country model.
- Seasonality: Varies by hemisphere, but generally smooths out consolidated global seasonality.
Cost Structure
Variable Costs / COGS
- COGS primarily consists of raw agricultural materials (potatoes, corn, oats, vegetable oils, sugar), packaging materials (PET plastic, aluminium, cardboard), direct manufacturing labour, and plant overhead.
- Gross margin range over the last 5 years has been 53.0% to 54.9%, averaging approximately 54.1%.
- The company is highly exposed to agricultural and energy commodity cycles but uses forward purchase contracts and derivatives to smooth input costs.
- COGS scales linearly with volume but exhibits some operating leverage due to fixed manufacturing plant overhead.
Operating Expenses
- R&D: Typically runs at 0.8% to 1.0% of revenue, covering product formulation, flavour innovation, and packaging sustainability research.
- SG&A: This is the largest expense category, heavily driven by advertising and marketing (A&M) spend, direct-store-delivery (DSD) fleet fuel and maintenance, and corporate headcount.
- Depreciation & Amortisation: Typically 3.0% of revenue, heavily weighted towards tangible depreciation of manufacturing equipment and distribution fleets.
- Stock-Based Compensation: Typically 0.3% to 0.4% of revenue.
- Restructuring / one-time charges: Frequent and material. The company regularly implements multi-year productivity programmes (such as the pep+ initiative) resulting in severance and asset impairment charges.
Margin Profile
- Gross margin: 53.0% to 54.9%.
- Operating margin: 13.5% to 14.5% (core operating margins have been slowly expanding).
- Net margin: 8.5% to 10.5%.
- Segment margins: FLNA is the most profitable segment with operating margins exceeding 25%, while PBNA operates at lower margins of 10% to 12% due to the capital intensity of beverage distribution.
Balance Sheet Structure
- Total assets are approximately $100 billion.
- Key assets are Property, Plant & Equipment (manufacturing facilities and delivery fleets) and Goodwill & Intangible Assets from historical acquisitions.
- Goodwill and intangibles represent approximately 30% to 35% of total assets, reflecting acquisitions like SodaStream, Pioneer Foods, and Rockstar Energy.
- Working capital profile:
- Days Sales Outstanding (DSO): 35 to 40 days.
- Days Inventory Outstanding (DIO): 45 to 50 days.
- Days Payable Outstanding (DPO): 90 to 100 days.
- Net working capital as a % of revenue is structurally negative.
- The company uses its scale to stretch supplier payables, meaning it funds its growth from working capital (a negative NWC advantage).
- PP&E consists of land, buildings, machinery, and vehicles, with useful lives ranging from 5 to 40 years. Maintenance capex is roughly 40% of total capex.
- Right-of-use assets for operating leases are material, typically representing $3 billion to $4 billion for warehouses and vehicles.
Capital Expenditure & Investment
- Capex as a % of revenue typically runs between 5.0% and 6.0%.
- The estimated split is 40% maintenance capex and 60% growth and productivity capex.
- Major capex programmes underway include manufacturing automation, digitisation of the supply chain, and investments in sustainable packaging infrastructure.
- Capitalised software costs are moderate, primarily related to global ERP system upgrades.
- M&A pattern: PepsiCo is a strategic bolt-on acquirer, occasionally making multi-billion dollar purchases to enter new categories or geographies, but primarily relies on organic growth.
- Typical acquisition multiples paid range from 15x to 20x EBITDA for high-growth assets.
Debt & Capital Structure
- Total debt is approximately $44 billion to $49 billion, with net debt around $35 billion to $40 billion.
- The Debt/EBITDA ratio currently sits between 2.5x and 2.8x, aligning with management targets.
- Credit rating is strong investment grade: A+ by S&P and A1 by Moody's.
- Key debt instruments include senior unsecured notes and a highly active commercial paper programme for short-term working capital needs.
- The maturity profile is well-laddered, with an average maturity of over 8 years.
- The interest rate profile is predominantly fixed via interest rate swaps, with a weighted average cost of debt around 3.0% to 3.5%.
- The company has an active share repurchase programme, typically buying back $1.0 billion annually (roughly 0.4% of market cap).
- Dividend policy is aggressive; PepsiCo is a Dividend Aristocrat with 53 consecutive years of increases, a payout ratio of 65% to 70%, and a yield of approximately 3.0%.
Cash Flow Characteristics
- Operating cash flow conversion (OCF / Net Income) is excellent, typically ranging from 1.2x to 1.3x.
- Free cash flow margin (FCF / Revenue) typically runs between 8.0% and 10.0%.
- Major non-cash items bridging net income to OCF include depreciation, amortisation, deferred income taxes, and periodic impairment charges.
- Working capital is a consistent source of cash during periods of growth due to the negative net working capital cycle.
- Capex intensity is moderate but essential for maintaining the proprietary DSD network.
- The cash tax rate is typically 19% to 21%, tracking closely with the GAAP effective tax rate.
Sheet Structure
- Assumptions: Hardcoded inputs for macroeconomic drivers, segment volume and pricing growth, margin targets, and capital allocation policies.
- Scenarios: Scenario manager toggling Base, Bull, and Bear cases for organic growth and commodity inflation.
- Revenue_Build: Volume, pricing, and foreign exchange translation drivers detailed for FLNA, QFNA, PBNA, Latin America, Europe, AMESA, and APAC.
- Income_Statement: Consolidated P&L from Net Revenue down to Net Income Attributable to PepsiCo, mirroring the 10-K format.
- Working_Capital: Schedules for Accounts Receivable, Inventory, Prepaid Expenses, Accounts Payable, and Accrued Liabilities.
- Fixed_Assets: PP&E roll-forward, Capital Expenditures, and Depreciation schedules.
- Intangibles: Goodwill and other intangible assets roll-forward, including amortisation of finite-lived brands.
- Debt_Schedule: Short-term commercial paper and long-term debt tranches, interest expense calculation, and debt paydown logic.
- Equity_Schedule: Share count roll-forward, dividends paid, share repurchases, and retained earnings.
- Cash_Flow: Indirect method cash flow statement split into Operating, Investing, and Financing activities.
- Balance_Sheet: Consolidated assets, liabilities, and shareholders' equity.
- Valuation: DCF model, WACC calculation, and terminal value assumptions.
- Outputs: Summary dashboard with key charts, credit metrics, and per-share data.
Key Financial Relationships
- FLNA Net Revenue = FLNA Prior Year Revenue * (1 + FLNA Organic Volume Growth + FLNA Effective Net Pricing Growth)
- PBNA Net Revenue = PBNA Prior Year Revenue * (1 + PBNA Organic Volume Growth + PBNA Effective Net Pricing Growth)
- International Segment Revenue = Segment Prior Year Revenue * (1 + Organic Volume Growth + Effective Net Pricing Growth) * (1 + Foreign Exchange Translation Impact)
- Consolidated Net Revenue = Sum of all 7 segment net revenues
- Segment Operating Profit = Segment Net Revenue * Segment Core Operating Margin
- Consolidated Operating Profit = Sum of Segment Operating Profits + Corporate Unallocated Expenses
- Accounts Receivable = (Consolidated Net Revenue / 365) * Days Sales Outstanding
- Inventory = (Cost of Sales / 365) * Days Inventory Outstanding
- Accounts Payable = (Cost of Sales / 365) * Days Payable Outstanding
- Interest Expense = Average Total Debt Balance * Weighted Average Interest Rate
- Dividends Paid = Prior Period Share Count * Annualised Dividend Per Share
- Share Repurchases = Allocated Buyback Capital / Average Share Price
- Free Cash Flow = Net Cash Provided by Operating Activities + Capital Spending (where Capital Spending is a negative value)
Cross-Sheet Dependencies
- The Assumptions sheet feeds the Revenue_Build, Working_Capital, and Fixed_Assets sheets.
- The Revenue_Build sheet feeds the top line of the Income_Statement.
- The Income_Statement provides Net Income to the Cash_Flow and Equity_Schedule, and Cost of Sales to the Working_Capital sheet.
- The Working_Capital changes feed the Operating Cash Flow section of the Cash_Flow sheet.
- The Fixed_Assets sheet provides Depreciation to the Income_Statement and Capex to the Cash_Flow sheet.
- The Debt_Schedule provides Interest Expense to the Income_Statement and debt balances to the Balance_Sheet.
- The Cash_Flow sheet provides the ending cash balance to the Balance_Sheet.
- Circularity risk: Interest expense on the Debt_Schedule depends on the average debt balance, which depends on the commercial paper draw required to balance the Balance_Sheet, which depends on Net Income from the Income_Statement, which requires Interest Expense.
Sign Convention
- Revenue and income items are positive.
- Expense items on the Income Statement are negative.
- Assets on the Balance Sheet are positive.
- Liabilities and Equity on the Balance Sheet are positive.
- Cash inflows on the Cash Flow Statement are positive.
- Cash outflows (including Capital Expenditures, dividends, and share repurchases) on the Cash Flow Statement are negative.
Things Most Likely to Go Wrong
- Failing to separate organic growth from foreign exchange translation; PepsiCo has massive international exposure and strong US Dollar translation can severely distort underlying performance.
- Mismodelling the Quaker Foods North America (QFNA) segment baseline due to the severe 2023/2024 product recall impacts which artificially depressed historical comparables.
- Overestimating gross margin expansion; PepsiCo faces structural limits on gross margin due to agricultural commodity inflation and competitive pricing ceilings.
- Ignoring the negative working capital dynamic; assuming working capital consumes cash as revenue grows will artificially depress Free Cash Flow.
- Miscalculating the dividend burden; PepsiCo is a Dividend Aristocrat and the model must force dividend per share growth regardless of short-term earnings volatility.
- Double-counting restructuring charges; the company frequently reports "core" versus "GAAP" earnings, and the model must clearly define which basis is being projected to avoid margin distortion.
- Incorrectly handling mark-to-market commodity hedges which create noise in GAAP gross margins but are excluded from management's core results.
- Forgetting to deduct non-controlling interests when calculating Net Income Attributable to PepsiCo.
Validation Checks
- Consolidated Gross Margin must remain between 53.0% and 55.0% based on historical commodity cycles; flag if outside this band.
- Capital Expenditures as a % of revenue must equal 5.0% to 6.0%.
- Operating Cash Flow divided by Net Income must be greater than 1.1x (company has strong cash conversion).
- Total Debt to EBITDA must not exceed 3.0x to maintain the current rating agency guidance.
- The Balance Sheet must balance exactly: Total Assets minus (Total Liabilities plus Shareholders' Equity) equals zero in every period.
- Dividend payout ratio should remain between 60% and 75% of Net Income based on stated policy.
- Effective tax rate should remain between 19.0% and 22.0%.
- Return on Invested Capital (ROIC) should remain in the 15% to 18% range.
Key Assumptions (Default Values)
| Assumption | Default Value | Unit | Rationale |
|---|---|---|---|
| FLNA Organic Revenue Growth | 3.0 | % | Normalised growth following recent pricing-led surges |
| PBNA Organic Revenue Growth | 2.5 | % | Stable volume with moderate price mix improvements |
| International Organic Revenue Growth | 6.0 | % | Higher growth in emerging markets (LatAm, AMESA) |
| Foreign Exchange Impact | -2.0 | % | Historical average headwind from strong USD |
| Consolidated Gross Margin | 54.5 | % | FY24 actual core gross margin |
| SG&A as % of Revenue | 40.5 | % | Historical average reflecting heavy advertising spend |
| Core Operating Margin | 14.0 | % | FY24 actual core operating margin |
| Days Sales Outstanding (DSO) | 38 | Days | Based on FY24 Accounts Receivable and Net Revenue |
| Days Inventory Outstanding (DIO) | 48 | Days | Based on FY24 Inventory and Cost of Sales |
| Days Payable Outstanding (DPO) | 98 | Days | Based on FY24 Accounts Payable and Cost of Sales |
| Capex as % of Revenue | 5.5 | % | Management guidance and historical average |
| Weighted Average Interest Rate | 3.5 | % | Blended rate on existing fixed and floating debt |
| Effective Tax Rate | 20.0 | % | Management guidance for core effective tax rate |
| Annual Dividend Per Share | 5.69 | USD | Announced rate effective June 2025 |
| Share Repurchases | 1.0 | USD Billions | Management guidance for FY25 |
| WACC | 7.5 | % | Based on current risk-free rate and low beta |
| Terminal Growth Rate | 2.5 | % | Long-term global GDP and population growth proxy |
Data Sources & Benchmarks
- SEC EDGAR: PepsiCo 10-K and 10-Q filings for historical financial statements.
- PepsiCo Investor Relations: Earnings call transcripts, "pep+" strategy presentations, and core non-GAAP reconciliations.
- Direct Peers for benchmarking: The Coca-Cola Company (KO), Keurig Dr Pepper (KDP), Mondelez International (MDLZ), Kellanova (K).
- Industry Data: NielsenIQ or Circana for US scanner data on snack and beverage market share.
- Macro Data: Bloomberg or FRED for agricultural commodity price indices (corn, potatoes, sugar) and foreign exchange rates.
Sources
Do more with the PepsiCo model
Frequently asked
What is PepsiCo's primary business model and product portfolio?+
PepsiCo is a global leader in the convenient foods and beverages industry, manufacturing and distributing a massive portfolio of iconic brands including Lay's, Doritos, Pepsi, and Gatorade. Its business model blends asset-heavy manufacturing with direct-store-delivery distribution networks and franchise bottling operations across seven distinct business segments.
How does PepsiCo generate its revenue across different regions and segments?+
PepsiCo generates revenue globally through seven business segments, with North America accounting for approximately 60% of total revenue and international markets contributing the remaining 40%. Key segments like PepsiCo Beverages North America and Frito-Lay North America each contribute around 30% of total revenue.
What is the typical capital expenditure as a percentage of revenue for PepsiCo?+
PepsiCo's capital expenditure typically runs between 5.0% and 6.0% of revenue. This capex is estimated to be split 40% for maintenance and 60% for growth and productivity initiatives, including manufacturing automation and digitisation of the supply chain.
Why is PepsiCo's net working capital structurally negative in its financial model?+
PepsiCo's net working capital as a percentage of revenue is structurally negative because the company uses its scale to stretch supplier payables. This means PepsiCo effectively funds its growth from working capital, leveraging its strong operational efficiency.
What is the purpose of the PepsiCo financial model and what does it aim to determine?+
The PepsiCo financial model projects the company's consolidated earnings and cash flows over a forecast horizon from FY2026 to FY2030. Its primary purpose is to determine PepsiCo's intrinsic equity value and assess its capacity for continued dividend growth and share repurchases.
Can I download an Excel financial model for PepsiCo (PEP)?+
Yes, a downloadable Excel financial model for PepsiCo (PEP) is available, offering a general corporate model for analysis. This model includes key assumptions such as a revenue growth rate of approximately 8.03% and COGS as a percentage of revenue at about 45.89%.
Have more financial modelling questions? Contact us
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Other Beverages Company Financial Models
Browse another company in the same sector.
Brown–Forman
Brown-Forman is a global leader in the production and distribution of premium spirits, with a portfolio heavily anchored by the Jack Daniel's family of brands.
Keurig Dr Pepper
Keurig Dr Pepper is a leading North American beverage company that manufactures, markets, and distributes non-alcoholic beverages and single-serve coffee systems.
Coca-Cola
The Coca-Cola Company is a global beverage leader that manufactures, markets, and sells non-alcoholic beverages across multiple categories including sparkling soft drinks, water, sports, coffee, and tea.
Monster Beverage
Monster Beverage Corporation develops, markets, and distributes energy drinks and alternative beverages globally.
Constellation Brands
Constellation Brands is a leading international producer and marketer of beer, wine, and spirits, primarily serving the United States market.
Molson Coors Beverage
Molson Coors Beverage Company is a leading global brewer that manufactures, markets, and sells beer and other malt beverage products under brands such as Coors Light, Miller Lite, Molson Canadian, Carling, and Staropramen.
Explore more Consumer financial model templates.
