PepsiCo, Inc. (PEP) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
PepsiCo, Inc. (PEP) Bundle
Streamline your analysis and improve precision with our [Symbol] DCF Calculator! Equipped with real-time PepsiCo, Inc. (PEP) data and customizable assumptions, this tool empowers you to forecast, analyze, and value PepsiCo, Inc. (PEP) like a seasoned investor.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2019 |
AY2 2020 |
AY3 2021 |
AY4 2022 |
AY5 2023 |
FY1 2024 |
FY2 2025 |
FY3 2026 |
FY4 2027 |
FY5 2028 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 67,161.0 | 70,372.0 | 79,468.0 | 86,403.0 | 91,471.0 | 98,857.0 | 106,839.5 | 115,466.5 | 124,790.1 | 134,866.6 |
| Revenue Growth, % | 0 | 4.78 | 12.93 | 8.73 | 5.87 | 8.07 | 8.07 | 8.07 | 8.07 | 8.07 |
| EBITDA | 12,936.0 | 12,880.0 | 14,274.0 | 14,248.0 | 15,215.0 | 17,527.3 | 18,942.6 | 20,472.1 | 22,125.2 | 23,911.8 |
| EBITDA, % | 19.26 | 18.3 | 17.96 | 16.49 | 16.63 | 17.73 | 17.73 | 17.73 | 17.73 | 17.73 |
| Depreciation | 2,432.0 | 2,548.0 | 2,710.0 | 2,763.0 | 2,948.0 | 3,375.5 | 3,648.1 | 3,942.7 | 4,261.0 | 4,605.1 |
| Depreciation, % | 3.62 | 3.62 | 3.41 | 3.2 | 3.22 | 3.41 | 3.41 | 3.41 | 3.41 | 3.41 |
| EBIT | 10,504.0 | 10,332.0 | 11,564.0 | 11,485.0 | 12,267.0 | 14,151.8 | 15,294.5 | 16,529.5 | 17,864.2 | 19,306.7 |
| EBIT, % | 15.64 | 14.68 | 14.55 | 13.29 | 13.41 | 14.32 | 14.32 | 14.32 | 14.32 | 14.32 |
| Total Cash | 5,738.0 | 9,551.0 | 5,988.0 | 5,348.0 | 10,003.0 | 9,248.3 | 9,995.1 | 10,802.2 | 11,674.4 | 12,617.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 7,822.0 | 8,404.0 | 8,680.0 | 10,163.0 | 10,815.0 | 11,486.6 | 12,414.2 | 13,416.6 | 14,499.9 | 15,670.8 |
| Account Receivables, % | 11.65 | 11.94 | 10.92 | 11.76 | 11.82 | 11.62 | 11.62 | 11.62 | 11.62 | 11.62 |
| Inventories | 3,338.0 | 4,172.0 | 4,347.0 | 5,222.0 | 5,334.0 | 5,584.2 | 6,035.1 | 6,522.4 | 7,049.1 | 7,618.3 |
| Inventories, % | 4.97 | 5.93 | 5.47 | 6.04 | 5.83 | 5.65 | 5.65 | 5.65 | 5.65 | 5.65 |
| Accounts Payable | 8,013.0 | 8,853.0 | 9,834.0 | 10,732.0 | 11,635.0 | 12,263.6 | 13,253.8 | 14,324.0 | 15,480.7 | 16,730.7 |
| Accounts Payable, % | 11.93 | 12.58 | 12.37 | 12.42 | 12.72 | 12.41 | 12.41 | 12.41 | 12.41 | 12.41 |
| Capital Expenditure | -4,232.0 | -4,240.0 | -4,625.0 | -5,207.0 | -5,518.0 | -5,972.0 | -6,454.2 | -6,975.4 | -7,538.6 | -8,147.4 |
| Capital Expenditure, % | -6.3 | -6.03 | -5.82 | -6.03 | -6.03 | -6.04 | -6.04 | -6.04 | -6.04 | -6.04 |
| Tax Rate, % | 20.52 | 20.52 | 20.52 | 20.52 | 20.52 | 20.52 | 20.52 | 20.52 | 20.52 | 20.52 |
| EBITAT | 8,250.2 | 8,111.6 | 8,970.0 | 9,559.2 | 9,749.6 | 11,245.9 | 12,154.0 | 13,135.4 | 14,196.0 | 15,342.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 3,303.2 | 5,843.6 | 7,585.0 | 5,655.2 | 7,318.6 | 8,356.1 | 8,959.7 | 9,683.1 | 10,465.0 | 11,310.0 |
| WACC, % | 6.4 | 6.4 | 6.39 | 6.43 | 6.4 | 6.4 | 6.4 | 6.4 | 6.4 | 6.4 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 40,262.5 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 11,649 | |||||||||
| Terminal Value | 342,347 | |||||||||
| Present Terminal Value | 251,016 | |||||||||
| Enterprise Value | 291,279 | |||||||||
| Net Debt | 34,950 | |||||||||
| Equity Value | 256,329 | |||||||||
| Diluted Shares Outstanding, MM | 1,383 | |||||||||
| Equity Value Per Share | 185.34 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real PEP financials.
- Real-World Data: Historical data and forward-looking estimates (as illustrated in the highlighted cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effects of your inputs on PepsiCo’s valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Customizable Financial Inputs: Adjust essential parameters such as sales growth, operating margin, and capital investments.
- Instant DCF Valuation: Quickly computes intrinsic value, NPV, and additional financial metrics.
- High-Precision Results: Incorporates PepsiCo’s actual financial data for accurate valuation insights.
- Effortless Scenario Testing: Evaluate various assumptions and analyze results with ease.
- Efficiency Booster: Remove the hassle of constructing intricate valuation models from the ground up.
How It Works
- Download the Template: Get instant access to the Excel-based PEP DCF Calculator.
- Input Your Assumptions: Adjust yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically updates PepsiCo’s intrinsic value.
- Test Scenarios: Simulate different assumptions to evaluate potential valuation changes.
- Analyze and Decide: Use the results to guide your investment or financial analysis.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool favored by analysts, CFOs, and industry consultants.
- Accurate Data: PepsiCo’s historical and projected financials are preloaded for precise analysis.
- Flexible Scenario Testing: Easily simulate various forecasts and assumptions.
- Clear Results: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance makes the process straightforward.
Who Should Use This Product?
- Investors: Accurately estimate PepsiCo’s fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis.
- Consultants: Quickly adapt the template for valuation reports for clients.
- Entrepreneurs: Gain insights into financial modeling used by leading consumer goods companies.
- Educators: Use it as a teaching tool to demonstrate valuation methodologies.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations.
- Real-World Data: PepsiCo, Inc.'s (PEP) historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to test scenarios.
- Financial Statements: Full annual and quarterly breakdowns for deeper insights.
- Key Ratios: Built-in analysis for profitability, efficiency, and leverage.
- Dashboard with Visual Outputs: Charts and tables for clear, actionable results.