|
Waste Connections, Inc. (WCN) DCF Valoración
CA | Industrials | Waste Management | NYSE
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Waste Connections, Inc. (WCN) Bundle
¡Descubra el potencial real de Waste Connections, Inc. (WCN) con nuestra calculadora DCF avanzada! Ajuste los supuestos críticos, explore varios escenarios y evalúe cómo los diferentes cambios afectan la valoración de Waste Connections, Inc. (WCN): todo lo que necesita está disponible en una sola plantilla de Excel.
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 | 5,388.7 | 5,446.0 | 6,151.4 | 7,211.9 | 8,022.0 | 8,874.1 | 9,816.7 | 10,859.4 | 12,012.9 | 13,288.9 |
| Revenue Growth, % | 0 | 1.06 | 12.95 | 17.24 | 11.23 | 10.62 | 10.62 | 10.62 | 10.62 | 10.62 |
| EBITDA | 1,650.8 | 1,597.6 | 1,891.0 | 2,090.6 | 2,282.9 | 2,629.5 | 2,908.8 | 3,217.7 | 3,559.5 | 3,937.6 |
| EBITDA, % | 30.63 | 29.33 | 30.74 | 28.99 | 28.46 | 29.63 | 29.63 | 29.63 | 29.63 | 29.63 |
| Depreciation | 785.9 | 792.2 | 805.9 | 882.5 | 1,003.2 | 1,188.6 | 1,314.9 | 1,454.6 | 1,609.1 | 1,780.0 |
| Depreciation, % | 14.58 | 14.55 | 13.1 | 12.24 | 12.51 | 13.39 | 13.39 | 13.39 | 13.39 | 13.39 |
| EBIT | 864.9 | 805.4 | 1,085.1 | 1,208.0 | 1,279.6 | 1,440.8 | 1,593.9 | 1,763.2 | 1,950.5 | 2,157.6 |
| EBIT, % | 16.05 | 14.79 | 17.64 | 16.75 | 15.95 | 16.24 | 16.24 | 16.24 | 16.24 | 16.24 |
| Total Cash | 326.7 | 617.3 | 147.4 | 78.6 | 78.4 | 388.0 | 429.2 | 474.8 | 525.3 | 581.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 662.8 | 630.3 | 709.6 | 833.9 | 857.0 | 1,023.2 | 1,131.9 | 1,252.2 | 1,385.2 | 1,532.3 |
| Account Receivables, % | 12.3 | 11.57 | 11.54 | 11.56 | 10.68 | 11.53 | 11.53 | 11.53 | 11.53 | 11.53 |
| Inventories | -2.8 | 36.7 | 44.3 | 55.2 | 61.7 | 51.0 | 56.4 | 62.4 | 69.1 | 76.4 |
| Inventories, % | -0.05279585 | 0.67442 | 0.71947 | 0.76524 | 0.7688 | 0.57503 | 0.57503 | 0.57503 | 0.57503 | 0.57503 |
| Accounts Payable | 437.0 | 290.8 | 392.9 | 638.7 | 642.5 | 651.4 | 720.6 | 797.1 | 881.8 | 975.4 |
| Accounts Payable, % | 8.11 | 5.34 | 6.39 | 8.86 | 8.01 | 7.34 | 7.34 | 7.34 | 7.34 | 7.34 |
| Capital Expenditure | -666.1 | -664.6 | -744.3 | -912.7 | -934.0 | -1,082.0 | -1,196.9 | -1,324.0 | -1,464.7 | -1,620.2 |
| Capital Expenditure, % | -12.36 | -12.2 | -12.1 | -12.66 | -11.64 | -12.19 | -12.19 | -12.19 | -12.19 | -12.19 |
| Tax Rate, % | 22.44 | 22.44 | 22.44 | 22.44 | 22.44 | 22.44 | 22.44 | 22.44 | 22.44 | 22.44 |
| EBITAT | 694.5 | 649.2 | 870.2 | 962.4 | 992.5 | 1,147.8 | 1,269.8 | 1,404.6 | 1,553.8 | 1,718.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 591.3 | 623.6 | 946.9 | 1,042.9 | 1,035.9 | 1,107.8 | 1,342.8 | 1,485.5 | 1,643.3 | 1,817.8 |
| WACC, % | 7.26 | 7.26 | 7.26 | 7.26 | 7.25 | 7.26 | 7.26 | 7.26 | 7.26 | 7.26 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 5,926.1 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 1,854 | |||||||||
| Terminal Value | 35,260 | |||||||||
| Present Terminal Value | 24,838 | |||||||||
| Enterprise Value | 30,764 | |||||||||
| Net Debt | 6,944 | |||||||||
| Equity Value | 23,821 | |||||||||
| Diluted Shares Outstanding, MM | 258 | |||||||||
| Equity Value Per Share | 92.27 |
What You Will Get
- Real WCN Financial Data: Pre-filled with Waste Connections’ historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Waste Connections’ intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Waste Connections, Inc. (WCN).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to Waste Connections, Inc. (WCN).
- Customizable Forecast Assumptions: Easily adjust growth rates, capital expenditures, and discount rates for accurate projections.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios pertinent to Waste Connections, Inc. (WCN).
- Visual Dashboard and Charts: Graphical representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template featuring Waste Connections, Inc.'s (WCN) data.
- Step 2: Navigate through the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly see the recalculated results, including Waste Connections, Inc.'s (WCN) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Waste Connections, Inc. (WCN)?
- Designed for Industry Experts: A specialized tool favored by waste management analysts, CFOs, and environmental consultants.
- Comprehensive Data: Waste Connections' historical and projected financials preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly simulate various forecasts and assumptions tailored to the waste management sector.
- Insightful Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Clear, step-by-step instructions make navigation simple and efficient.
Who Should Use This Product?
- Environmental Analysts: Develop comprehensive models to assess the valuation of waste management services.
- Corporate Finance Teams: Evaluate financial scenarios to inform strategic decisions within the waste management sector.
- Consultants and Advisors: Deliver precise valuation insights for Waste Connections, Inc. (WCN) to clients.
- Students and Educators: Utilize real-time data to enhance learning in financial modeling and environmental economics.
- Industry Enthusiasts: Gain insights into the valuation methods applied to companies like Waste Connections, Inc. (WCN) in the waste management industry.
What the Template Contains
- Historical Data: Includes Waste Connections, Inc.'s (WCN) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Waste Connections, Inc.'s (WCN) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital for Waste Connections, Inc. (WCN).
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions for Waste Connections, Inc. (WCN).
- Quarterly and Annual Statements: A complete breakdown of Waste Connections, Inc.'s (WCN) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically for Waste Connections, Inc. (WCN).