|
Valoración de DCF de Columbus McKinnon Corporation (CMCO)
US | Industrials | Agricultural - Machinery | NASDAQ
|
- ✓ 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
Columbus McKinnon Corporation (CMCO) Bundle
¡Descubra el verdadero potencial de Columbus McKinnon Corporation (CMCO) con nuestra calculadora DCF avanzada! Ajuste los supuestos críticos, explore varios escenarios y evalúe cómo los diferentes factores afectan la valoración de Columbus McKinnon Corporation (CMCO), todo dentro de una plantilla integral 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 | 809.2 | 649.6 | 906.6 | 936.2 | 1,013.5 | 1,093.0 | 1,178.7 | 1,271.1 | 1,370.8 | 1,478.3 |
| Revenue Growth, % | 0 | -19.71 | 39.55 | 3.27 | 8.26 | 7.84 | 7.84 | 7.84 | 7.84 | 7.84 |
| EBITDA | 128.7 | 56.3 | 105.6 | 146.7 | 145.4 | 144.8 | 156.1 | 168.4 | 181.6 | 195.8 |
| EBITDA, % | 15.9 | 8.67 | 11.65 | 15.67 | 14.35 | 13.25 | 13.25 | 13.25 | 13.25 | 13.25 |
| Depreciation | 37.0 | 35.6 | 49.9 | 49.8 | 45.9 | 55.6 | 59.9 | 64.6 | 69.7 | 75.1 |
| Depreciation, % | 4.58 | 5.48 | 5.5 | 5.32 | 4.53 | 5.08 | 5.08 | 5.08 | 5.08 | 5.08 |
| EBIT | 91.6 | 20.7 | 55.7 | 96.9 | 99.5 | 89.2 | 96.2 | 103.8 | 111.9 | 120.7 |
| EBIT, % | 11.32 | 3.19 | 6.14 | 10.35 | 9.82 | 8.16 | 8.16 | 8.16 | 8.16 | 8.16 |
| Total Cash | 114.5 | 202.1 | 115.4 | 133.2 | 114.1 | 182.5 | 196.8 | 212.2 | 228.8 | 246.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 123.7 | 105.5 | 147.5 | 151.5 | 171.2 | 176.8 | 190.6 | 205.6 | 221.7 | 239.1 |
| Account Receivables, % | 15.29 | 16.23 | 16.27 | 16.18 | 16.89 | 16.17 | 16.17 | 16.17 | 16.17 | 16.17 |
| Inventories | 127.4 | 111.5 | 172.1 | 179.4 | 186.1 | 195.4 | 210.8 | 227.3 | 245.1 | 264.3 |
| Inventories, % | 15.74 | 17.16 | 18.99 | 19.16 | 18.36 | 17.88 | 17.88 | 17.88 | 17.88 | 17.88 |
| Accounts Payable | 57.3 | 68.6 | 90.9 | 76.7 | 83.1 | 96.3 | 103.9 | 112.0 | 120.8 | 130.3 |
| Accounts Payable, % | 7.08 | 10.56 | 10.02 | 8.2 | 8.2 | 8.81 | 8.81 | 8.81 | 8.81 | 8.81 |
| Capital Expenditure | -9.4 | -12.3 | -13.1 | -12.6 | -24.8 | -18.1 | -19.6 | -21.1 | -22.8 | -24.5 |
| Capital Expenditure, % | -1.17 | -1.89 | -1.45 | -1.35 | -2.45 | -1.66 | -1.66 | -1.66 | -1.66 | -1.66 |
| Tax Rate, % | 24.22 | 24.22 | 24.22 | 24.22 | 24.22 | 24.22 | 24.22 | 24.22 | 24.22 | 24.22 |
| EBITAT | 70.9 | 18.7 | 43.0 | 63.0 | 75.4 | 68.8 | 74.2 | 80.0 | 86.3 | 93.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -95.3 | 87.5 | -.7 | 74.9 | 76.4 | 104.5 | 92.9 | 100.2 | 108.1 | 116.5 |
| WACC, % | 8.21 | 8.51 | 8.21 | 7.94 | 8.18 | 8.21 | 8.21 | 8.21 | 8.21 | 8.21 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 412.4 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | 120 | |||||||||
| Terminal Value | 2,305 | |||||||||
| Present Terminal Value | 1,554 | |||||||||
| Enterprise Value | 1,966 | |||||||||
| Net Debt | 485 | |||||||||
| Equity Value | 1,481 | |||||||||
| Diluted Shares Outstanding, MM | 29 | |||||||||
| Equity Value Per Share | 51.01 |
What You Will Get
- Real CMCO Financials: Includes historical and forecasted data for precise valuation.
- Adjustable Inputs: Customize WACC, tax rates, revenue growth, and capital expenditures.
- Automatic Calculations: Intrinsic value and NPV are computed dynamically.
- Scenario Analysis: Evaluate multiple scenarios to assess Columbus McKinnon's future performance.
- Clear and Intuitive Design: Designed for professionals while remaining user-friendly for beginners.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Columbus McKinnon Corporation (CMCO).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs specific to CMCO.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates according to CMCO's performance.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios relevant to Columbus McKinnon Corporation (CMCO).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis of CMCO.
How It Works
- Step 1: Download the Excel file for Columbus McKinnon Corporation (CMCO).
- Step 2: Review CMCO's pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust assumptions.
- Step 5: Evaluate the outputs and utilize the findings for your investment decisions.
Why Choose This Calculator?
- Designed for Experts: A sophisticated tool utilized by analysts, CFOs, and industry consultants.
- Accurate Data: Columbus McKinnon Corporation’s (CMCO) historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Easily simulate various forecasts and assumptions.
- Comprehensive Outputs: Instantly calculates intrinsic value, NPV, and essential metrics.
- User-Friendly: Step-by-step guidance ensures a smooth experience throughout the process.
Who Should Use This Product?
- Engineering Students: Explore mechanical design principles and apply them with real-world examples.
- Researchers: Utilize advanced lifting solutions in your studies or projects.
- Manufacturers: Assess your production needs and evaluate equipment options for Columbus McKinnon Corporation (CMCO).
- Supply Chain Analysts: Optimize operations with a comprehensive understanding of material handling solutions.
- Facility Managers: Learn how to implement safety and efficiency improvements in your operations.
What the Template Contains
- Pre-Filled DCF Model: Columbus McKinnon Corporation’s (CMCO) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Columbus McKinnon’s (CMCO) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.