|
Dawson GeoPhysical Company (DWSN) DCF Valoración
US | Energy | Oil & Gas Equipment & Services | 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
Dawson Geophysical Company (DWSN) Bundle
¡Simplifique la valoración de Dawson Geophysical Company (DWSN) con esta calculadora DCF personalizable! Con la Real Dawson Geophysical Company (DWSN) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de la compañía geofísica de Dawson (DWSN) en minutos.
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 | 145.8 | 86.1 | 24.7 | 37.5 | 96.8 | 106.4 | 116.9 | 128.5 | 141.2 | 155.1 |
| Revenue Growth, % | 0 | -40.94 | -71.32 | 51.77 | 158.39 | 9.88 | 9.88 | 9.88 | 9.88 | 9.88 |
| EBITDA | 8.0 | 3.9 | -16.3 | -5.7 | -3.7 | -15.9 | -17.5 | -19.2 | -21.1 | -23.2 |
| EBITDA, % | 5.49 | 4.55 | -65.9 | -15.15 | -3.78 | -14.96 | -14.96 | -14.96 | -14.96 | -14.96 |
| Depreciation | 23.0 | 18.4 | 13.9 | 12.8 | 8.5 | 29.1 | 31.9 | 35.1 | 38.5 | 42.4 |
| Depreciation, % | 15.8 | 21.32 | 56.4 | 34.23 | 8.77 | 27.3 | 27.3 | 27.3 | 27.3 | 27.3 |
| EBIT | -15.0 | -14.4 | -30.2 | -18.5 | -12.2 | -40.2 | -44.2 | -48.6 | -53.4 | -58.6 |
| EBIT, % | -10.3 | -16.77 | -122.31 | -49.38 | -12.55 | -37.8 | -37.8 | -37.8 | -37.8 | -37.8 |
| Total Cash | 28.6 | 41.5 | 25.6 | 14.2 | 11.0 | 46.2 | 50.8 | 55.8 | 61.3 | 67.4 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 24.4 | 7.3 | 8.9 | 13.4 | 17.1 | 24.4 | 26.8 | 29.5 | 32.4 | 35.6 |
| Account Receivables, % | 16.75 | 8.53 | 36.06 | 35.77 | 17.61 | 22.94 | 22.94 | 22.94 | 22.94 | 22.94 |
| Inventories | 1.4 | -7.3 | -8.9 | 5.0 | .0 | -6.4 | -7.1 | -7.8 | -8.6 | -9.4 |
| Inventories, % | 0.95628 | -8.53 | -36.06 | 13.34 | 0 | -6.06 | -6.06 | -6.06 | -6.06 | -6.06 |
| Accounts Payable | 4.0 | 1.6 | 2.6 | 2.1 | 3.9 | 5.3 | 5.8 | 6.4 | 7.0 | 7.7 |
| Accounts Payable, % | 2.71 | 1.86 | 10.45 | 5.71 | 4.01 | 4.95 | 4.95 | 4.95 | 4.95 | 4.95 |
| Capital Expenditure | -4.4 | -2.8 | -.5 | -.9 | -3.7 | -3.1 | -3.4 | -3.8 | -4.1 | -4.5 |
| Capital Expenditure, % | -3.02 | -3.31 | -2.04 | -2.39 | -3.84 | -2.92 | -2.92 | -2.92 | -2.92 | -2.92 |
| Tax Rate, % | 0.78412 | 0.78412 | 0.78412 | 0.78412 | 0.78412 | 0.78412 | 0.78412 | 0.78412 | 0.78412 | 0.78412 |
| EBITAT | -14.8 | -14.5 | -30.2 | -18.6 | -12.1 | -40.0 | -44.0 | -48.3 | -53.1 | -58.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -18.0 | 24.5 | -15.8 | -25.5 | -4.2 | -13.6 | -16.7 | -18.4 | -20.2 | -22.2 |
| WACC, % | 7.51 | 7.52 | 7.52 | 7.52 | 7.52 | 7.52 | 7.52 | 7.52 | 7.52 | 7.52 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -72.5 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -23 | |||||||||
| Terminal Value | -410 | |||||||||
| Present Terminal Value | -285 | |||||||||
| Enterprise Value | -358 | |||||||||
| Net Debt | -5 | |||||||||
| Equity Value | -353 | |||||||||
| Diluted Shares Outstanding, MM | 27 | |||||||||
| Equity Value Per Share | -13.21 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: Dawson Geophysical Company’s (DWSN) financial data pre-loaded to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A sleek Excel model that tailors to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive Financial Data: Gain access to precise historical data and future forecasts for Dawson Geophysical Company (DWSN).
- Adjustable Assumptions: Modify highlighted cells for parameters such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Intuitive charts and summaries to effectively illustrate your valuation outcomes.
- Designed for All Users: An accessible and straightforward layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download: Obtain the pre-configured Excel file containing Dawson Geophysical Company's (DWSN) financial data.
- Customize: Tailor forecasts, such as revenue growth, EBITDA %, and WACC to your preferences.
- Update Automatically: Watch as the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various projections and analyze results instantly.
- Make Decisions: Leverage the valuation outcomes to inform your investment approach.
Why Choose This Calculator for Dawson Geophysical Company (DWSN)?
- Accurate Data: Utilize real financials from Dawson Geophysical to ensure dependable valuation outcomes.
- Customizable: Modify essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the geophysical sector.
- User-Friendly: Simple design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Investors: Accurately assess Dawson Geophysical Company's (DWSN) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to (DWSN).
- Consultants: Easily modify the template for valuation reports tailored to (DWSN) clients.
- Entrepreneurs: Obtain insights into financial modeling practices used by leading companies like (DWSN).
- Educators: Employ it as a teaching resource to illustrate valuation methodologies relevant to (DWSN).
What the Template Contains
- Historical Data: Includes Dawson Geophysical Company's (DWSN) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Dawson Geophysical Company's (DWSN) 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 Dawson Geophysical Company's (DWSN) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.