|
Ramaco Resources, Inc. (METC) DCF Valoración
US | Energy | Coal | 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
Ramaco Resources, Inc. (METC) Bundle
¡Descubra el verdadero potencial de Ramaco Resources, Inc. (METC) con nuestra calculadora DCF avanzada! Ajuste los supuestos clave, explore varios escenarios y evalúe cómo los diferentes cambios afectan la valoración de Ramaco Resources, Inc. (METC), todo dentro de una sola plantilla 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 | 230.2 | 168.9 | 283.4 | 565.7 | 693.5 | 976.8 | 1,375.7 | 1,937.5 | 2,728.7 | 3,843.1 |
Revenue Growth, % | 0 | -26.63 | 67.77 | 99.61 | 22.6 | 40.84 | 40.84 | 40.84 | 40.84 | 40.84 |
EBITDA | 49.6 | 14.3 | 73.8 | 192.7 | 150.9 | 218.5 | 307.8 | 433.5 | 610.5 | 859.8 |
EBITDA, % | 21.53 | 8.47 | 26.04 | 34.06 | 21.76 | 22.37 | 22.37 | 22.37 | 22.37 | 22.37 |
Depreciation | 20.0 | 21.5 | 26.8 | 42.3 | 55.7 | 90.6 | 127.6 | 179.7 | 253.2 | 356.5 |
Depreciation, % | 8.7 | 12.72 | 9.46 | 7.48 | 8.02 | 9.28 | 9.28 | 9.28 | 9.28 | 9.28 |
EBIT | 29.5 | -7.2 | 47.0 | 150.4 | 95.2 | 127.9 | 180.1 | 253.7 | 357.3 | 503.2 |
EBIT, % | 12.83 | -4.24 | 16.57 | 26.58 | 13.73 | 13.09 | 13.09 | 13.09 | 13.09 | 13.09 |
Total Cash | 5.5 | 5.3 | 21.9 | 35.6 | 42.0 | 50.0 | 70.5 | 99.2 | 139.8 | 196.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 19.3 | 20.3 | 44.5 | 41.2 | 96.9 | 112.0 | 157.7 | 222.1 | 312.8 | 440.5 |
Account Receivables, % | 8.36 | 12.02 | 15.69 | 7.28 | 13.97 | 11.46 | 11.46 | 11.46 | 11.46 | 11.46 |
Inventories | 15.3 | 11.9 | 15.8 | 45.0 | 37.2 | 63.7 | 89.6 | 126.3 | 177.8 | 250.4 |
Inventories, % | 6.63 | 7.07 | 5.57 | 7.95 | 5.36 | 6.52 | 6.52 | 6.52 | 6.52 | 6.52 |
Accounts Payable | 10.7 | 11.7 | 15.3 | 34.8 | 51.6 | 59.8 | 84.2 | 118.6 | 167.0 | 235.2 |
Accounts Payable, % | 4.63 | 6.95 | 5.42 | 6.16 | 7.44 | 6.12 | 6.12 | 6.12 | 6.12 | 6.12 |
Capital Expenditure | -45.7 | -24.8 | -29.5 | -123.0 | -82.9 | -153.6 | -216.3 | -304.6 | -429.0 | -604.2 |
Capital Expenditure, % | -19.86 | -14.65 | -10.4 | -21.75 | -11.95 | -15.72 | -15.72 | -15.72 | -15.72 | -15.72 |
Tax Rate, % | 21.35 | 21.35 | 21.35 | 21.35 | 21.35 | 21.35 | 21.35 | 21.35 | 21.35 | 21.35 |
EBITAT | 24.5 | -4.2 | 42.0 | 119.4 | 74.9 | 99.5 | 140.1 | 197.3 | 277.9 | 391.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -25.1 | -4.1 | 15.0 | 32.2 | 16.6 | 3.1 | 4.1 | 5.8 | 8.2 | 11.6 |
WACC, % | 8.86 | 8.47 | 8.97 | 8.8 | 8.79 | 8.78 | 8.78 | 8.78 | 8.78 | 8.78 |
PV UFCF | ||||||||||
SUM PV UFCF | 24.3 | |||||||||
Long Term Growth Rate, % | 0.50 | |||||||||
Free cash flow (T + 1) | 12 | |||||||||
Terminal Value | 140 | |||||||||
Present Terminal Value | 92 | |||||||||
Enterprise Value | 117 | |||||||||
Net Debt | 59 | |||||||||
Equity Value | 58 | |||||||||
Diluted Shares Outstanding, MM | 45 | |||||||||
Equity Value Per Share | 1.29 |
What You Will Get
- Real METC Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Automatic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Ramaco Resources' future performance.
- User-Friendly Design: Designed for professionals while remaining easy to navigate for newcomers.
Key Features
- 🔍 Real-Life METC Financials: Pre-filled historical and projected data for Ramaco Resources, Inc. (METC).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) such as WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Ramaco's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Ramaco's valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-formatted Excel file containing Ramaco Resources, Inc. (METC) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: Watch the intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and instantly compare the results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose This Calculator for Ramaco Resources, Inc. (METC)?
- Designed for Industry Experts: A sophisticated tool tailored for analysts, CFOs, and consultants in the mining sector.
- Accurate Financial Data: Ramaco's historical and projected financials are preloaded for precise calculations.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential metrics.
- User-Friendly Interface: Step-by-step guidance to streamline your calculation process.
Who Should Use This Product?
- Investors: Accurately assess Ramaco Resources, Inc.’s (METC) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial analysis and reporting related to Ramaco Resources, Inc. (METC).
- Consultants: Easily modify the template for valuation reports tailored to Ramaco Resources, Inc. (METC) clients.
- Entrepreneurs: Acquire knowledge on financial modeling practices employed by leading resource companies like Ramaco Resources, Inc. (METC).
- Educators: Implement it as a teaching resource to illustrate valuation techniques relevant to Ramaco Resources, Inc. (METC).
What the Template Contains
- Preloaded METC Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.