Matador Resources Company (MTDR) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
Matador Resources Company (MTDR) Bundle
Designed for accuracy, our (MTDR) DCF Calculator enables you to evaluate Matador Resources Company's valuation using real-world financial information, while offering complete flexibility to modify all essential parameters for enhanced projections.
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 | 983.7 | 862.1 | 1,663.0 | 3,058.0 | 2,817.6 | 3,920.5 | 5,455.0 | 7,590.1 | 10,560.9 | 14,694.6 |
| Revenue Growth, % | 0 | -12.36 | 92.89 | 83.89 | -7.86 | 39.14 | 39.14 | 39.14 | 39.14 | 39.14 |
| EBITDA | 587.8 | -353.7 | 1,140.0 | 2,228.0 | 1,938.5 | 1,795.2 | 2,497.8 | 3,475.5 | 4,835.9 | 6,728.7 |
| EBITDA, % | 59.76 | -41.02 | 68.55 | 72.86 | 68.8 | 45.79 | 45.79 | 45.79 | 45.79 | 45.79 |
| Depreciation | 352.4 | 363.8 | 347.0 | 468.8 | 720.6 | 1,096.1 | 1,525.1 | 2,122.0 | 2,952.5 | 4,108.2 |
| Depreciation, % | 35.82 | 42.2 | 20.86 | 15.33 | 25.58 | 27.96 | 27.96 | 27.96 | 27.96 | 27.96 |
| EBIT | 235.5 | -717.4 | 793.1 | 1,759.3 | 1,217.9 | 699.1 | 972.8 | 1,353.5 | 1,883.3 | 2,620.5 |
| EBIT, % | 23.94 | -83.22 | 47.69 | 57.53 | 43.22 | 17.83 | 17.83 | 17.83 | 17.83 | 17.83 |
| Total Cash | 40.0 | 57.9 | 48.1 | 505.2 | 52.7 | 251.5 | 349.9 | 486.8 | 677.4 | 942.5 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 189.4 | 137.1 | 241.4 | 453.8 | 473.0 | 637.5 | 887.0 | 1,234.2 | 1,717.3 | 2,389.5 |
| Account Receivables, % | 19.26 | 15.91 | 14.52 | 14.84 | 16.79 | 16.26 | 16.26 | 16.26 | 16.26 | 16.26 |
| Inventories | 10.7 | 10.6 | 12.2 | 15.2 | 41.8 | 39.5 | 54.9 | 76.4 | 106.3 | 147.9 |
| Inventories, % | 1.09 | 1.23 | 0.7329 | 0.49653 | 1.48 | 1.01 | 1.01 | 1.01 | 1.01 | 1.01 |
| Accounts Payable | 25.2 | 14.0 | 26.3 | 58.8 | 68.2 | 79.3 | 110.3 | 153.5 | 213.5 | 297.1 |
| Accounts Payable, % | 2.56 | 1.62 | 1.58 | 1.92 | 2.42 | 2.02 | 2.02 | 2.02 | 2.02 | 2.02 |
| Capital Expenditure | -925.9 | -780.5 | -733.5 | -1,084.0 | -1,549.8 | -2,502.9 | -3,482.6 | -4,845.7 | -6,742.3 | -9,381.3 |
| Capital Expenditure, % | -94.13 | -90.53 | -44.11 | -35.45 | -55 | -63.84 | -63.84 | -63.84 | -63.84 | -63.84 |
| Tax Rate, % | 22.83 | 22.83 | 22.83 | 22.83 | 22.83 | 22.83 | 22.83 | 22.83 | 22.83 | 22.83 |
| EBITAT | 182.7 | -662.8 | 648.5 | 1,267.2 | 939.9 | 560.6 | 780.1 | 1,085.4 | 1,510.2 | 2,101.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -565.8 | -1,038.3 | 168.4 | 469.2 | 74.2 | -997.3 | -1,411.4 | -1,963.8 | -2,732.5 | -3,802.0 |
| WACC, % | 15.82 | 16.02 | 15.87 | 15.74 | 15.81 | 15.85 | 15.85 | 15.85 | 15.85 | 15.85 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -6,514.0 | |||||||||
| Long Term Growth Rate, % | 0.50 | |||||||||
| Free cash flow (T + 1) | -3,821 | |||||||||
| Terminal Value | -24,889 | |||||||||
| Present Terminal Value | -11,926 | |||||||||
| Enterprise Value | -18,440 | |||||||||
| Net Debt | 2,216 | |||||||||
| Equity Value | -20,656 | |||||||||
| Diluted Shares Outstanding, MM | 120 | |||||||||
| Equity Value Per Share | -172.16 |
What You Will Receive
- Adjustable Forecast Inputs: Effortlessly modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Comprehensive Data: Matador Resources Company’s (MTDR) financial data pre-filled to kickstart your analysis.
- Automated DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically for you.
- Tailored and Professional: A refined Excel model that caters to your valuation requirements.
- Designed for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- 🔍 Real-Life MTDR Financials: Pre-filled historical and projected data for Matador Resources Company (MTDR).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate Matador's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize Matador's valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download the Template: Gain immediate access to the Excel-based MTDR DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other key variables.
- Instant Calculations: The model will automatically refresh to display Matador Resources Company's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose Matador Resources Company (MTDR) Calculator?
- Accuracy: Utilize authentic Matador financials for precise data.
- Flexibility: Tailored for users to effortlessly adjust and test various inputs.
- Time-Saving: Eliminate the need to construct a model from the ground up.
- Professional-Grade: Crafted with the expertise and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Professional Investors: Create comprehensive and trustworthy valuation models for analyzing portfolios with Matador Resources (MTDR).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding Matador Resources (MTDR) stock.
- Students and Educators: Utilize real-world data for hands-on practice and teaching in financial modeling.
- Energy Sector Enthusiasts: Gain insights into how companies like Matador Resources (MTDR) are valued in the energy market.
What the Template Contains
- Historical Data: Includes Matador Resources Company's past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Matador Resources Company's 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 Matador Resources Company's financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.