|
MDU Resources Group, Inc. (MDU) DCF Valoración
US | Industrials | Conglomerates | 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
MDU Resources Group, Inc. (MDU) Bundle
¡Optimice su tiempo y mejore la precisión con nuestra calculadora DCF (MDU)! Utilizando datos reales de MDU Resources Group, Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y evaluar (MDU) al igual que un inversor experimentado.
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,336.8 | 5,532.7 | 5,680.7 | 6,973.9 | 4,657.3 | 4,609.5 | 4,562.2 | 4,515.3 | 4,469.0 | 4,423.1 |
| Revenue Growth, % | 0 | 3.67 | 2.68 | 22.76 | -33.22 | -1.03 | -1.03 | -1.03 | -1.03 | -1.03 |
| EBITDA | 752.5 | 856.1 | 859.3 | 590.7 | 867.7 | 661.9 | 655.1 | 648.4 | 641.7 | 635.2 |
| EBITDA, % | 14.1 | 15.47 | 15.13 | 8.47 | 18.63 | 14.36 | 14.36 | 14.36 | 14.36 | 14.36 |
| Depreciation | 256.0 | 285.1 | 299.2 | 210.0 | 213.6 | 210.3 | 208.2 | 206.0 | 203.9 | 201.8 |
| Depreciation, % | 4.8 | 5.15 | 5.27 | 3.01 | 4.59 | 4.56 | 4.56 | 4.56 | 4.56 | 4.56 |
| EBIT | 496.4 | 571.0 | 560.0 | 380.6 | 654.1 | 451.6 | 447.0 | 442.4 | 437.8 | 433.3 |
| EBIT, % | 9.3 | 10.32 | 9.86 | 5.46 | 14.04 | 9.8 | 9.8 | 9.8 | 9.8 | 9.8 |
| Total Cash | 66.5 | 59.5 | 54.2 | 80.5 | 48.9 | 50.5 | 50.0 | 49.5 | 49.0 | 48.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 836.6 | 874.0 | 946.7 | 1,064.3 | 942.8 | 771.1 | 763.2 | 755.4 | 747.6 | 739.9 |
| Account Receivables, % | 15.68 | 15.8 | 16.67 | 15.26 | 20.24 | 16.73 | 16.73 | 16.73 | 16.73 | 16.73 |
| Inventories | 278.4 | 291.2 | 335.6 | 387.5 | 87.4 | 219.6 | 217.3 | 215.1 | 212.9 | 210.7 |
| Inventories, % | 5.22 | 5.26 | 5.91 | 5.56 | 1.88 | 4.76 | 4.76 | 4.76 | 4.76 | 4.76 |
| Accounts Payable | 403.4 | 426.3 | 478.9 | 525.6 | 247.6 | 336.9 | 333.5 | 330.0 | 326.7 | 323.3 |
| Accounts Payable, % | 7.56 | 7.7 | 8.43 | 7.54 | 5.32 | 7.31 | 7.31 | 7.31 | 7.31 | 7.31 |
| Capital Expenditure | -576.1 | -558.0 | -659.4 | -656.6 | -519.7 | -489.2 | -484.2 | -479.2 | -474.3 | -469.4 |
| Capital Expenditure, % | -10.79 | -10.09 | -11.61 | -9.41 | -11.16 | -10.61 | -10.61 | -10.61 | -10.61 | -10.61 |
| Tax Rate, % | 23.19 | 23.19 | 23.19 | 23.19 | 23.19 | 23.19 | 23.19 | 23.19 | 23.19 | 23.19 |
| EBITAT | 418.1 | 469.0 | 453.9 | 302.7 | 502.4 | 364.6 | 360.9 | 357.2 | 353.5 | 349.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -613.6 | 168.8 | 29.1 | -266.7 | 340.0 | 214.6 | 91.6 | 90.7 | 89.7 | 88.8 |
| WACC, % | 6.14 | 6.1 | 6.08 | 6.05 | 6 | 6.07 | 6.07 | 6.07 | 6.07 | 6.07 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 496.7 | |||||||||
| Long Term Growth Rate, % | 4.00 | |||||||||
| Free cash flow (T + 1) | 92 | |||||||||
| Terminal Value | 4,459 | |||||||||
| Present Terminal Value | 3,321 | |||||||||
| Enterprise Value | 3,818 | |||||||||
| Net Debt | 2,419 | |||||||||
| Equity Value | 1,399 | |||||||||
| Diluted Shares Outstanding, MM | 204 | |||||||||
| Equity Value Per Share | 6.86 |
What You Will Get
- Editable Excel Template: A fully customizable Excel-based DCF Calculator featuring pre-filled real MDU financials.
- Real-World Data: Historical data and forward-looking estimates (as displayed in the yellow cells).
- Forecast Flexibility: Adjust forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Automatic Calculations: Instantly observe the effect of your inputs on MDU's valuation.
- Professional Tool: Designed for investors, CFOs, consultants, and financial analysts.
- User-Friendly Design: Organized for clarity and ease of use, complete with step-by-step instructions.
Key Features
- Comprehensive DCF Calculator: Features robust unlevered and levered DCF valuation models tailored for MDU Resources Group, Inc. (MDU).
- WACC Calculator: Ready-to-use Weighted Average Cost of Capital sheet with adjustable parameters.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates as per your analysis needs.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for MDU Resources Group, Inc. (MDU).
- Interactive Dashboard and Charts: Visual representations highlight essential valuation metrics for straightforward interpretation.
How It Works
- Step 1: Download the Excel file for MDU Resources Group, Inc. (MDU).
- Step 2: Review MDU's pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch 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 This Calculator for MDU Resources Group, Inc. (MDU)?
- Designed for Experts: A sophisticated tool utilized by financial analysts, CFOs, and industry consultants.
- Accurate Data: MDU’s historical and projected financials integrated for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Step-by-step guidance simplifies the calculation process.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio assessments of MDU Resources Group, Inc. (MDU).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in MDU Resources Group, Inc. (MDU).
- Students and Educators: Utilize real-world data to enhance financial modeling skills and education.
- Energy Sector Enthusiasts: Gain insights into how companies like MDU Resources Group, Inc. (MDU) are valued in the energy market.
What the Template Contains
- Pre-Filled DCF Model: MDU Resources Group, Inc.'s (MDU) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate MDU's 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.