Campbell Soup Company (CPB) DCF Valuation
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
Campbell Soup Company (CPB) Bundle
Looking to assess the intrinsic value of Campbell Soup Company? Our (CPB) DCF Calculator integrates real-world data with extensive customization features, allowing you to optimize your forecasts and enhance your investment choices.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 8,691.0 | 8,476.0 | 8,562.0 | 9,357.0 | 9,636.0 | 9,896.4 | 10,163.8 | 10,438.4 | 10,720.4 | 11,010.1 |
| Revenue Growth, % | 0 | -2.47 | 1.01 | 9.29 | 2.98 | 2.7 | 2.7 | 2.7 | 2.7 | 2.7 |
| EBITDA | 1,617.0 | 1,926.0 | 1,531.0 | 1,703.0 | 1,417.0 | 1,823.2 | 1,872.5 | 1,923.1 | 1,975.0 | 2,028.4 |
| EBITDA, % | 18.61 | 22.72 | 17.88 | 18.2 | 14.71 | 18.42 | 18.42 | 18.42 | 18.42 | 18.42 |
| Depreciation | 328.0 | 317.0 | 337.0 | 387.0 | 411.0 | 392.9 | 403.5 | 414.4 | 425.6 | 437.1 |
| Depreciation, % | 3.77 | 3.74 | 3.94 | 4.14 | 4.27 | 3.97 | 3.97 | 3.97 | 3.97 | 3.97 |
| EBIT | 1,289.0 | 1,609.0 | 1,194.0 | 1,316.0 | 1,006.0 | 1,430.3 | 1,468.9 | 1,508.6 | 1,549.4 | 1,591.3 |
| EBIT, % | 14.83 | 18.98 | 13.95 | 14.06 | 10.44 | 14.45 | 14.45 | 14.45 | 14.45 | 14.45 |
| Total Cash | 859.0 | 69.0 | 109.0 | 189.0 | 108.0 | 299.1 | 307.2 | 315.5 | 324.0 | 332.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 575.0 | 595.0 | 541.0 | 529.0 | 630.0 | 636.3 | 653.4 | 671.1 | 689.2 | 707.9 |
| Account Receivables, % | 6.62 | 7.02 | 6.32 | 5.65 | 6.54 | 6.43 | 6.43 | 6.43 | 6.43 | 6.43 |
| Inventories | 871.0 | 933.0 | 1,246.0 | 1,291.0 | 1,386.0 | 1,262.0 | 1,296.1 | 1,331.2 | 1,367.1 | 1,404.1 |
| Inventories, % | 10.02 | 11.01 | 14.55 | 13.8 | 14.38 | 12.75 | 12.75 | 12.75 | 12.75 | 12.75 |
| Accounts Payable | 1,049.0 | 1,070.0 | 1,334.0 | 1,306.0 | 1,311.0 | 1,342.7 | 1,379.0 | 1,416.2 | 1,454.5 | 1,493.8 |
| Accounts Payable, % | 12.07 | 12.62 | 15.58 | 13.96 | 13.61 | 13.57 | 13.57 | 13.57 | 13.57 | 13.57 |
| Capital Expenditure | -299.0 | -275.0 | -242.0 | -370.0 | -517.0 | -372.7 | -382.8 | -393.1 | -403.7 | -414.7 |
| Capital Expenditure, % | -3.44 | -3.24 | -2.83 | -3.95 | -5.37 | -3.77 | -3.77 | -3.77 | -3.77 | -3.77 |
| Tax Rate, % | 25.1 | 25.1 | 25.1 | 25.1 | 25.1 | 25.1 | 25.1 | 25.1 | 25.1 | 25.1 |
| EBITAT | 996.2 | 1,206.8 | 927.0 | 1,001.0 | 753.5 | 1,089.6 | 1,119.0 | 1,149.3 | 1,180.3 | 1,212.2 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 628.2 | 1,187.8 | 1,027.0 | 957.0 | 456.5 | 1,259.2 | 1,124.7 | 1,155.1 | 1,186.3 | 1,218.4 |
| WACC, % | 4.66 | 4.62 | 4.67 | 4.64 | 4.62 | 4.64 | 4.64 | 4.64 | 4.64 | 4.64 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 5,199.2 | |||||||||
| Long Term Growth Rate, % | 1.00 | |||||||||
| Free cash flow (T + 1) | 1,231 | |||||||||
| Terminal Value | 33,794 | |||||||||
| Present Terminal Value | 26,935 | |||||||||
| Enterprise Value | 32,134 | |||||||||
| Net Debt | 7,434 | |||||||||
| Equity Value | 24,700 | |||||||||
| Diluted Shares Outstanding, MM | 300 | |||||||||
| Equity Value Per Share | 82.33 |
What You Will Get
- Pre-Filled Financial Model: Campbell Soup Company’s (CPB) actual data enables precise DCF valuation.
- Full Forecast Control: Adjust revenue growth, margins, WACC, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- Real Campbell Soup Financials: Access accurate pre-loaded historical data and future projections for Campbell Soup Company (CPB).
- Customizable Forecast Assumptions: Edit yellow-highlighted cells such as WACC, growth rates, and margins to tailor your analysis.
- Dynamic Calculations: Automatic updates to DCF, Net Present Value (NPV), and cash flow analysis for informed decision-making.
- Visual Dashboard: User-friendly charts and summaries to help visualize your valuation results effectively.
- For Professionals and Beginners: A straightforward, intuitive structure designed for investors, CFOs, and consultants alike.
How It Works
- 1. Open the Template: Download and open the Excel file containing Campbell Soup Company's (CPB) preloaded data.
- 2. Edit Assumptions: Modify key inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically calculates the intrinsic value and NPV.
- 4. Test Scenarios: Evaluate multiple forecasts to explore various valuation outcomes.
- 5. Use with Confidence: Present professional valuation insights to back your decisions.
Why Choose This Calculator for Campbell Soup Company (CPB)?
- Accurate Data: Up-to-date Campbell Soup Company financials provide trustworthy valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from square one.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the food industry.
- User-Friendly: Simple design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling Campbell Soup Company (CPB) stock.
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for Campbell Soup Company (CPB).
- Consultants: Deliver professional valuation insights on Campbell Soup Company (CPB) to clients quickly and accurately.
- Business Owners: Understand how large companies like Campbell Soup Company (CPB) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios related to Campbell Soup Company (CPB).
What the Template Contains
- Preloaded CPB Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.