Casella Waste Systems, Inc. (CWST) 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
Casella Waste Systems, Inc. (CWST) Bundle
Looking to determine Casella Waste Systems, Inc.'s (CWST) intrinsic value? Our CWST DCF Calculator integrates real-world data with comprehensive customization features, enabling you to adjust forecasts and enhance your investment strategies.
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 | 743.3 | 774.6 | 889.2 | 1,085.1 | 1,264.5 | 1,446.6 | 1,654.8 | 1,893.0 | 2,165.4 | 2,477.1 |
Revenue Growth, % | 0 | 4.21 | 14.8 | 22.03 | 16.54 | 14.39 | 14.39 | 14.39 | 14.39 | 14.39 |
EBITDA | 141.9 | 151.5 | 208.8 | 248.3 | 274.2 | 308.6 | 353.1 | 403.9 | 462.0 | 528.5 |
EBITDA, % | 19.08 | 19.55 | 23.48 | 22.88 | 21.68 | 21.34 | 21.34 | 21.34 | 21.34 | 21.34 |
Depreciation | 96.3 | 97.9 | 124.7 | 148.2 | 170.7 | 193.2 | 221.0 | 252.8 | 289.2 | 330.8 |
Depreciation, % | 12.96 | 12.64 | 14.03 | 13.65 | 13.5 | 13.36 | 13.36 | 13.36 | 13.36 | 13.36 |
EBIT | 45.5 | 53.6 | 84.0 | 100.1 | 103.5 | 115.4 | 132.1 | 151.1 | 172.8 | 197.7 |
EBIT, % | 6.13 | 6.92 | 9.45 | 9.23 | 8.18 | 7.98 | 7.98 | 7.98 | 7.98 | 7.98 |
Total Cash | 3.5 | 154.3 | 33.8 | 71.2 | 220.9 | 139.5 | 159.6 | 182.6 | 208.8 | 238.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 80.2 | 74.2 | 87.0 | 100.9 | 160.4 | 150.8 | 172.5 | 197.4 | 225.8 | 258.3 |
Account Receivables, % | 10.79 | 9.58 | 9.78 | 9.3 | 12.69 | 10.43 | 10.43 | 10.43 | 10.43 | 10.43 |
Inventories | 7.7 | 7.9 | 9.7 | 13.5 | 17.9 | 16.8 | 19.2 | 21.9 | 25.1 | 28.7 |
Inventories, % | 1.03 | 1.02 | 1.09 | 1.24 | 1.41 | 1.16 | 1.16 | 1.16 | 1.16 | 1.16 |
Accounts Payable | 64.4 | 49.2 | 63.1 | 74.2 | 116.8 | 110.5 | 126.4 | 144.6 | 165.4 | 189.2 |
Accounts Payable, % | 8.66 | 6.35 | 7.09 | 6.84 | 9.24 | 7.64 | 7.64 | 7.64 | 7.64 | 7.64 |
Capital Expenditure | -103.2 | -108.1 | -123.3 | -131.0 | -154.9 | -191.0 | -218.5 | -250.0 | -285.9 | -327.1 |
Capital Expenditure, % | -13.88 | -13.96 | -13.87 | -12.07 | -12.25 | -13.2 | -13.2 | -13.2 | -13.2 | -13.2 |
Tax Rate, % | 31.44 | 31.44 | 31.44 | 31.44 | 31.44 | 31.44 | 31.44 | 31.44 | 31.44 | 31.44 |
EBITAT | 48.4 | 127.5 | 59.5 | 70.9 | 70.9 | 94.7 | 108.3 | 123.9 | 141.8 | 162.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 18.1 | 107.8 | 60.2 | 81.6 | 65.4 | 101.2 | 102.6 | 117.4 | 134.3 | 153.6 |
WACC, % | 8.39 | 8.39 | 8.19 | 8.19 | 8.17 | 8.27 | 8.27 | 8.27 | 8.27 | 8.27 |
PV UFCF | ||||||||||
SUM PV UFCF | 474.5 | |||||||||
Long Term Growth Rate, % | 4.00 | |||||||||
Free cash flow (T + 1) | 160 | |||||||||
Terminal Value | 3,744 | |||||||||
Present Terminal Value | 2,517 | |||||||||
Enterprise Value | 2,992 | |||||||||
Net Debt | 898 | |||||||||
Equity Value | 2,094 | |||||||||
Diluted Shares Outstanding, MM | 55 | |||||||||
Equity Value Per Share | 37.88 |
What You Will Get
- Pre-Filled Financial Model: Casella Waste Systems, Inc.'s ([CWST]) actual data allows for accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, margins, WACC, and other essential drivers.
- Instant Calculations: Real-time updates ensure you view results as you implement changes.
- Investor-Ready Template: A polished Excel file crafted for professional-level valuation.
- Customizable and Reusable: Designed for adaptability, enabling repeated use for in-depth forecasts.
Key Features
- Accurate Financial Data: Gain access to precise pre-loaded historical figures and future forecasts for Casella Waste Systems, Inc. (CWST).
- Adjustable Forecast Parameters: Modify the highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Instant updates to DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear and concise charts and summaries to help visualize your valuation outcomes.
- Designed for All Skill Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the pre-built Excel file featuring Casella Waste Systems, Inc.'s (CWST) financial data.
- Customize: Modify projections, including revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose This Calculator for Casella Waste Systems, Inc. (CWST)?
- Designed for Industry Experts: A specialized tool utilized by environmental analysts, CFOs, and waste management consultants.
- Comprehensive Data: Casella's historical and projected financials are preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions to see different outcomes.
- Detailed Results: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance ensures a smooth and straightforward experience.
Who Should Use This Product?
- Investors: Assess Casella Waste Systems, Inc.'s (CWST) valuation before making investment decisions.
- CFOs and Financial Analysts: Optimize valuation methods and evaluate financial forecasts.
- Startup Founders: Discover how leading waste management companies like Casella are valued.
- Consultants: Provide comprehensive valuation reports for clients in the waste management sector.
- Students and Educators: Utilize industry-specific data to learn and teach valuation strategies.
What the Template Contains
- Historical Data: Includes Casella Waste Systems, Inc.'s (CWST) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Casella Waste Systems, Inc.'s (CWST) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of Casella Waste Systems, Inc.'s (CWST) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.