|
Douglas Dynamics, Inc. (Plough) Valoración de DCF
US | Consumer Cyclical | Auto - Parts | 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
Douglas Dynamics, Inc. (PLOW) Bundle
¡Descubra el verdadero valor de Douglas Dynamics, Inc. (Plough) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los cambios afectan la valoración de Douglas Dynamics, Inc. (Plough), todo dentro de una plantilla de Excel integral.
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 | 571.7 | 480.2 | 541.5 | 616.1 | 568.2 | 572.1 | 576.0 | 580.0 | 584.0 | 588.0 |
Revenue Growth, % | 0 | -16.01 | 12.77 | 13.78 | -7.77 | 0.68978 | 0.68978 | 0.68978 | 0.68978 | 0.68978 |
EBITDA | 98.0 | -62.2 | 72.8 | 79.2 | 66.6 | 48.3 | 48.6 | 48.9 | 49.3 | 49.6 |
EBITDA, % | 17.14 | -12.95 | 13.44 | 12.85 | 11.72 | 8.44 | 8.44 | 8.44 | 8.44 | 8.44 |
Depreciation | 19.2 | 19.7 | 22.1 | 22.0 | 21.7 | 21.7 | 21.8 | 22.0 | 22.1 | 22.3 |
Depreciation, % | 3.36 | 4.11 | 4.08 | 3.57 | 3.81 | 3.79 | 3.79 | 3.79 | 3.79 | 3.79 |
EBIT | 78.8 | -81.9 | 50.7 | 57.2 | 44.9 | 26.6 | 26.8 | 27.0 | 27.2 | 27.4 |
EBIT, % | 13.78 | -17.06 | 9.36 | 9.28 | 7.9 | 4.65 | 4.65 | 4.65 | 4.65 | 4.65 |
Total Cash | 35.7 | 41.0 | 37.0 | 20.7 | 24.2 | 33.4 | 33.7 | 33.9 | 34.1 | 34.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 87.9 | 83.2 | 72.3 | 86.8 | 88.6 | 86.6 | 87.2 | 87.8 | 88.4 | 89.0 |
Account Receivables, % | 15.37 | 17.33 | 13.35 | 14.08 | 15.59 | 15.14 | 15.14 | 15.14 | 15.14 | 15.14 |
Inventories | 84.5 | 87.6 | 106.7 | 137.7 | 142.6 | 114.6 | 115.4 | 116.2 | 117.0 | 117.8 |
Inventories, % | 14.78 | 18.25 | 19.7 | 22.35 | 25.1 | 20.04 | 20.04 | 20.04 | 20.04 | 20.04 |
Accounts Payable | 16.1 | 11.1 | 27.4 | 49.3 | 31.4 | 27.1 | 27.3 | 27.5 | 27.7 | 27.9 |
Accounts Payable, % | 2.82 | 2.31 | 5.06 | 7.99 | 5.52 | 4.74 | 4.74 | 4.74 | 4.74 | 4.74 |
Capital Expenditure | -11.5 | -14.5 | -11.2 | -12.0 | -10.5 | -12.5 | -12.6 | -12.7 | -12.7 | -12.8 |
Capital Expenditure, % | -2.02 | -3.02 | -2.07 | -1.96 | -1.85 | -2.18 | -2.18 | -2.18 | -2.18 | -2.18 |
Tax Rate, % | 18.85 | 18.85 | 18.85 | 18.85 | 18.85 | 18.85 | 18.85 | 18.85 | 18.85 | 18.85 |
EBITAT | 61.9 | -71.7 | 45.0 | 46.6 | 36.4 | 22.2 | 22.4 | 22.5 | 22.7 | 22.8 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -86.7 | -70.0 | 64.0 | 32.9 | 23.0 | 57.1 | 30.4 | 30.6 | 30.8 | 31.0 |
WACC, % | 8.42 | 8.6 | 8.62 | 8.48 | 8.47 | 8.51 | 8.51 | 8.51 | 8.51 | 8.51 |
PV UFCF | ||||||||||
SUM PV UFCF | 145.2 | |||||||||
Long Term Growth Rate, % | 3.00 | |||||||||
Free cash flow (T + 1) | 32 | |||||||||
Terminal Value | 580 | |||||||||
Present Terminal Value | 385 | |||||||||
Enterprise Value | 531 | |||||||||
Net Debt | 233 | |||||||||
Equity Value | 298 | |||||||||
Diluted Shares Outstanding, MM | 23 | |||||||||
Equity Value Per Share | 12.98 |
What You Will Get
- Real Douglas Dynamics Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on Douglas Dynamics' fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- Comprehensive PLOW Data: Pre-loaded with Douglas Dynamics’ historical performance metrics and future growth estimates.
- Customizable Financial Inputs: Modify revenue projections, profit margins, discount rates, tax assumptions, and capital investment plans.
- Interactive Valuation Model: Automatically recalculates Net Present Value (NPV) and intrinsic value based on user-defined parameters.
- Multiple Scenario Analysis: Develop various forecasting models to explore different valuation possibilities.
- Intuitive User Interface: Clean, organized layout suitable for both seasoned professionals and newcomers.
How It Works
- Download the Template: Gain immediate access to the Excel-based PLOW DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and additional variables.
- Instant Calculations: The model automatically recalculates Douglas Dynamics’ intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for Douglas Dynamics, Inc. (PLOW)?
- User-Friendly Interface: Tailored for both novices and seasoned users.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Feedback: Observe immediate updates to Douglas Dynamics' valuation as you tweak the inputs.
- Pre-Configured: Comes with Douglas Dynamics' latest financial metrics for swift evaluations.
- Relied Upon by Experts: Utilized by financial analysts and investors for strategic decision-making.
Who Should Use This Product?
- Investors: Accurately assess Douglas Dynamics, Inc.'s (PLOW) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to Douglas Dynamics, Inc. (PLOW).
- Consultants: Efficiently customize the template for valuation reports tailored to clients interested in Douglas Dynamics, Inc. (PLOW).
- Entrepreneurs: Acquire knowledge of financial modeling practices used by leading companies, including Douglas Dynamics, Inc. (PLOW).
- Educators: Employ it as a teaching resource to illustrate valuation techniques relevant to Douglas Dynamics, Inc. (PLOW).
What the Template Contains
- Historical Data: Includes Douglas Dynamics’ past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Douglas Dynamics’ 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 Douglas Dynamics’ financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.