Waste Management, Inc. (WM) 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 Management, Inc. (WM) Bundle
Enhance your investment strategy with the Waste Management, Inc. (WM) DCF Calculator! Utilize real financial data from Waste Management, adjust growth projections and expenses, and instantly observe how these modifications affect the intrinsic value of WM.
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 | 15,455.0 | 15,218.0 | 17,931.0 | 19,698.0 | 20,426.0 | 21,950.0 | 23,587.7 | 25,347.6 | 27,238.8 | 29,271.1 |
| Revenue Growth, % | 0 | -1.53 | 17.83 | 9.85 | 3.7 | 7.46 | 7.46 | 7.46 | 7.46 | 7.46 |
| EBITDA | 4,344.0 | 4,149.0 | 4,956.0 | 5,466.0 | 5,722.0 | 6,092.1 | 6,546.7 | 7,035.1 | 7,560.0 | 8,124.1 |
| EBITDA, % | 28.11 | 27.26 | 27.64 | 27.75 | 28.01 | 27.75 | 27.75 | 27.75 | 27.75 | 27.75 |
| Depreciation | 1,672.0 | 1,774.0 | 2,110.0 | 2,150.0 | 2,071.0 | 2,427.5 | 2,608.7 | 2,803.3 | 3,012.4 | 3,237.2 |
| Depreciation, % | 10.82 | 11.66 | 11.77 | 10.91 | 10.14 | 11.06 | 11.06 | 11.06 | 11.06 | 11.06 |
| EBIT | 2,672.0 | 2,375.0 | 2,846.0 | 3,316.0 | 3,651.0 | 3,664.6 | 3,938.0 | 4,231.8 | 4,547.6 | 4,886.9 |
| EBIT, % | 17.29 | 15.61 | 15.87 | 16.83 | 17.87 | 16.7 | 16.7 | 16.7 | 16.7 | 16.7 |
| Total Cash | 3,561.0 | 553.0 | 118.0 | 351.0 | 458.0 | 1,376.6 | 1,479.3 | 1,589.7 | 1,708.3 | 1,835.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 2,319.0 | 2,624.0 | 2,546.0 | 2,752.0 | 2,870.0 | 3,269.2 | 3,513.1 | 3,775.2 | 4,056.8 | 4,359.5 |
| Account Receivables, % | 15 | 17.24 | 14.2 | 13.97 | 14.05 | 14.89 | 14.89 | 14.89 | 14.89 | 14.89 |
| Inventories | 106.0 | 124.0 | 135.0 | 164.0 | 173.0 | 172.7 | 185.5 | 199.4 | 214.3 | 230.3 |
| Inventories, % | 0.68586 | 0.81482 | 0.75289 | 0.83257 | 0.84696 | 0.78662 | 0.78662 | 0.78662 | 0.78662 | 0.78662 |
| Accounts Payable | 1,065.0 | 1,121.0 | 1,375.0 | 1,766.0 | 1,709.0 | 1,723.4 | 1,852.0 | 1,990.2 | 2,138.7 | 2,298.2 |
| Accounts Payable, % | 6.89 | 7.37 | 7.67 | 8.97 | 8.37 | 7.85 | 7.85 | 7.85 | 7.85 | 7.85 |
| Capital Expenditure | -1,818.0 | -1,632.0 | -1,904.0 | -2,587.0 | -2,895.0 | -2,652.1 | -2,850.0 | -3,062.6 | -3,291.1 | -3,536.7 |
| Capital Expenditure, % | -11.76 | -10.72 | -10.62 | -13.13 | -14.17 | -12.08 | -12.08 | -12.08 | -12.08 | -12.08 |
| Tax Rate, % | 23.73 | 23.73 | 23.73 | 23.73 | 23.73 | 23.73 | 23.73 | 23.73 | 23.73 | 23.73 |
| EBITAT | 2,119.8 | 1,876.9 | 2,200.2 | 2,543.3 | 2,784.5 | 2,848.4 | 3,060.9 | 3,289.3 | 3,534.7 | 3,798.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 613.8 | 1,751.9 | 2,727.2 | 2,262.3 | 1,776.5 | 2,239.4 | 2,691.4 | 2,892.2 | 3,108.0 | 3,339.8 |
| WACC, % | 7.25 | 7.25 | 7.23 | 7.23 | 7.23 | 7.24 | 7.24 | 7.24 | 7.24 | 7.24 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 11,479.1 | |||||||||
| Long Term Growth Rate, % | 3.50 | |||||||||
| Free cash flow (T + 1) | 3,457 | |||||||||
| Terminal Value | 92,496 | |||||||||
| Present Terminal Value | 65,222 | |||||||||
| Enterprise Value | 76,701 | |||||||||
| Net Debt | 15,771 | |||||||||
| Equity Value | 60,930 | |||||||||
| Diluted Shares Outstanding, MM | 407 | |||||||||
| Equity Value Per Share | 149.74 |
What You Will Get
- Pre-Filled Financial Model: Waste Management, Inc.’s (WM) actual data provides accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, profit margins, WACC, and other essential drivers.
- Instant Calculations: Automatic updates ensure you see immediate results as you adjust inputs.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for adaptability, allowing for repeated use in comprehensive forecasts.
Key Features
- Comprehensive WM Data: Pre-loaded with Waste Management, Inc.'s historical performance metrics and future projections.
- Fully Customizable Inputs: Tailor revenue growth, operating margins, WACC, tax rates, and capital expenditures to suit your analysis.
- Dynamic Valuation Model: Real-time adjustments to Net Present Value (NPV) and intrinsic value based on your specified parameters.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- User-Friendly Interface: Intuitive layout designed for both experienced professionals and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Waste Management, Inc.'s (WM) pre-filled financial data and forecasts.
- Step 3: Modify critical inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose Waste Management, Inc. (WM)?
- Streamlined Processes: Benefit from efficient waste management solutions tailored to your needs.
- Enhanced Sustainability: Our services promote environmentally responsible practices and waste reduction.
- Comprehensive Services: From collection to recycling, we offer a full range of waste management options.
- User-Friendly Interface: Access our services easily through our intuitive online platform.
- Industry Leader: Trusted by communities and businesses for reliable and effective waste solutions.
Who Should Use This Product?
- Investors: Accurately assess Waste Management, Inc.’s (WM) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Waste Management, Inc. (WM).
- Consultants: Efficiently customize the template for valuation reports tailored to Waste Management, Inc. (WM) clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading waste management firms.
- Educators: Employ it as a teaching resource to illustrate valuation techniques relevant to Waste Management, Inc. (WM).
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Waste Management, Inc. (WM).
- Real-World Data: Waste Management’s historical and projected financials preloaded for analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions to explore different scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: Integrated analysis for profitability, efficiency, and leverage metrics.
- Dashboard with Visual Outputs: Charts and tables designed for clear, actionable results.