TreeHouse Foods, Inc. (THS) 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
TreeHouse Foods, Inc. (THS) Bundle
Explore TreeHouse Foods, Inc. (THS) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate TreeHouse Foods, Inc. (THS) intrinsic value and refine your investment approach.
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 | 4,288.9 | 4,349.7 | 4,327.6 | 3,454.0 | 3,431.6 | 3,260.7 | 3,098.2 | 2,943.9 | 2,797.2 | 2,657.9 |
| Revenue Growth, % | 0 | 1.42 | -0.50808 | -20.19 | -0.64852 | -4.98 | -4.98 | -4.98 | -4.98 | -4.98 |
| EBITDA | 163.7 | 306.7 | 93.9 | 213.7 | 319.4 | 186.1 | 176.8 | 168.0 | 159.6 | 151.7 |
| EBITDA, % | 3.82 | 7.05 | 2.17 | 6.19 | 9.31 | 5.71 | 5.71 | 5.71 | 5.71 | 5.71 |
| Depreciation | 210.6 | 203.2 | 148.9 | 139.6 | 141.9 | 138.2 | 131.4 | 124.8 | 118.6 | 112.7 |
| Depreciation, % | 4.91 | 4.67 | 3.44 | 4.04 | 4.14 | 4.24 | 4.24 | 4.24 | 4.24 | 4.24 |
| EBIT | -46.9 | 103.5 | -55.0 | 74.1 | 177.5 | 47.8 | 45.4 | 43.2 | 41.0 | 39.0 |
| EBIT, % | -1.09 | 2.38 | -1.27 | 2.15 | 5.17 | 1.47 | 1.47 | 1.47 | 1.47 | 1.47 |
| Total Cash | 202.3 | 364.6 | 308.6 | 43.0 | 320.3 | 200.9 | 190.9 | 181.4 | 172.4 | 163.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 270.6 | 308.8 | 151.3 | 158.8 | 175.6 | 173.6 | 164.9 | 156.7 | 148.9 | 141.5 |
| Account Receivables, % | 6.31 | 7.1 | 3.5 | 4.6 | 5.12 | 5.32 | 5.32 | 5.32 | 5.32 | 5.32 |
| Inventories | 544.0 | 598.6 | 677.8 | 589.5 | 534.0 | 487.4 | 463.1 | 440.0 | 418.1 | 397.3 |
| Inventories, % | 12.68 | 13.76 | 15.66 | 17.07 | 15.56 | 14.95 | 14.95 | 14.95 | 14.95 | 14.95 |
| Accounts Payable | 508.4 | 627.7 | 625.9 | 618.7 | 534.9 | 484.2 | 460.1 | 437.2 | 415.4 | 394.7 |
| Accounts Payable, % | 11.85 | 14.43 | 14.46 | 17.91 | 15.59 | 14.85 | 14.85 | 14.85 | 14.85 | 14.85 |
| Capital Expenditure | -146.8 | -105.7 | -115.9 | -94.8 | -140.8 | -100.3 | -95.3 | -90.5 | -86.0 | -81.8 |
| Capital Expenditure, % | -3.42 | -2.43 | -2.68 | -2.74 | -4.1 | -3.08 | -3.08 | -3.08 | -3.08 | -3.08 |
| Tax Rate, % | 36.33 | 36.33 | 36.33 | 36.33 | 36.33 | 36.33 | 36.33 | 36.33 | 36.33 | 36.33 |
| EBITAT | -33.2 | 297.8 | -47.3 | 153.0 | 113.0 | 40.2 | 38.2 | 36.3 | 34.5 | 32.8 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -275.6 | 421.8 | 62.2 | 271.4 | 69.0 | 76.1 | 83.1 | 78.9 | 75.0 | 71.3 |
| WACC, % | 4.55 | 5.16 | 4.87 | 5.16 | 4.4 | 4.83 | 4.83 | 4.83 | 4.83 | 4.83 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 335.1 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 73 | |||||||||
| Terminal Value | 4,012 | |||||||||
| Present Terminal Value | 3,169 | |||||||||
| Enterprise Value | 3,504 | |||||||||
| Net Debt | 1,281 | |||||||||
| Equity Value | 2,223 | |||||||||
| Diluted Shares Outstanding, MM | 56 | |||||||||
| Equity Value Per Share | 39.41 |
What You Will Receive
- Pre-Filled Financial Model: TreeHouse Foods' actual data allows for accurate DCF valuation.
- Comprehensive Forecast Control: Modify revenue growth, profit margins, WACC, and other essential parameters.
- Real-Time Calculations: Automatic updates provide immediate results as adjustments are made.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation presentations.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- Comprehensive Historical Data: TreeHouse Foods’ (THS) past financial statements and pre-populated projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins to fit your analysis.
- Real-Time Insights: Watch TreeHouse Foods’ intrinsic value update instantly as you adjust inputs.
- Intuitive Visualizations: Interactive dashboard charts showcase valuation outcomes and essential metrics.
- Designed for Precision: A robust tool tailored for analysts, investors, and finance professionals.
How It Works
- Download the Template: Gain immediate access to the Excel-based THS DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model will automatically refresh TreeHouse Foods’ intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for TreeHouse Foods, Inc. (THS)?
- Accuracy: Utilizes real TreeHouse Foods financial data for precise results.
- Flexibility: Allows users to easily test and adjust inputs as needed.
- Time-Saving: Avoid the complexities of creating a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and detail expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without advanced financial modeling skills.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for analyzing portfolios involving TreeHouse Foods, Inc. (THS).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in TreeHouse Foods, Inc. (THS) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Food Industry Enthusiasts: Gain insights into how food companies like TreeHouse Foods, Inc. (THS) are valued in the marketplace.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled TreeHouse Foods, Inc. (THS) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for TreeHouse Foods, Inc. (THS).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.