PepsiCo (PEP) Financial Forecast Calculator
Interactive 5-year forecast and DCF for PepsiCo. Adjust revenue growth, gross margin, capex intensity, WACC, and terminal growth - see revenue, free cash flow, and enterprise value update in real time. Seeded from PepsiCo’s most recent SEC filings.
Assumptions
Need this as an Excel model?
Keep iterating on the PepsiCo forecast in Excel. The downloadable sample has every assumption you see here plus a fully integrated income statement, balance sheet, cash flow, and debt schedule - five years of SEC historicals and live formulas in a fully editable workbook.
Other Staples forecasts
Run the same calculator on a peer.
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
