Waste Connections, Inc. (WCN) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Waste Connections, Inc. (WCN) Bundle
Discover the real potential of Waste Connections, Inc. (WCN) with our advanced DCF Calculator! Adjust critical assumptions, explore various scenarios, and evaluate how different changes affect Waste Connections, Inc. (WCN) valuation – everything you need is available in a single Excel template.
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).