|
Valoración de DCF de PHX Minerals Inc. (PHX)
US | Energy | Oil & Gas Exploration & Production | 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
PHX Minerals Inc. (PHX) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (PHX)! Equipado con datos reales de PHX Minerals Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, evaluar y evaluar (PHX) como 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 | 47.1 | 25.0 | 22.0 | 53.5 | 35.7 | 36.4 | 37.1 | 37.9 | 38.6 | 39.4 |
Revenue Growth, % | 0 | -46.95 | -12 | 143.47 | -33.22 | 1.96 | 1.96 | 1.96 | 1.96 | 1.96 |
EBITDA | 24.1 | 6.3 | 1.8 | 28.8 | 25.3 | 15.3 | 15.6 | 15.9 | 16.2 | 16.5 |
EBITDA, % | 51.22 | 25.1 | 8.32 | 53.88 | 70.93 | 41.89 | 41.89 | 41.89 | 41.89 | 41.89 |
Depreciation | 18.2 | 11.3 | 7.7 | 7.3 | 8.6 | 11.4 | 11.7 | 11.9 | 12.1 | 12.4 |
Depreciation, % | 38.66 | 45.31 | 35.25 | 13.61 | 24.09 | 31.38 | 31.38 | 31.38 | 31.38 | 31.38 |
EBIT | 5.9 | -5.0 | -5.9 | 21.5 | 16.7 | 3.8 | 3.9 | 4.0 | 4.1 | 4.1 |
EBIT, % | 12.56 | -20.22 | -26.94 | 40.28 | 46.84 | 10.51 | 10.51 | 10.51 | 10.51 | 10.51 |
Total Cash | 6.2 | 10.7 | 2.4 | 3.4 | .8 | 5.5 | 5.6 | 5.7 | 5.8 | 6.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 5.9 | 6.7 | 8.8 | 13.2 | 4.9 | 8.6 | 8.8 | 8.9 | 9.1 | 9.3 |
Account Receivables, % | 12.5 | 27.03 | 40.25 | 24.59 | 13.72 | 23.62 | 23.62 | 23.62 | 23.62 | 23.62 |
Inventories | 2.3 | .0 | .0 | .0 | .0 | .3 | .4 | .4 | .4 | .4 |
Inventories, % | 4.8 | 0.000004005065 | 0.000004551316 | 0.000001869332 | 0.000002799351 | 0.959 | 0.959 | 0.959 | 0.959 | 0.959 |
Accounts Payable | .7 | 1.0 | .8 | .6 | .6 | .9 | .9 | .9 | .9 | .9 |
Accounts Payable, % | 1.41 | 4 | 3.52 | 1.21 | 1.57 | 2.34 | 2.34 | 2.34 | 2.34 | 2.34 |
Capital Expenditure | -9.2 | -10.7 | -21.4 | -44.1 | -30.1 | -23.8 | -24.2 | -24.7 | -25.2 | -25.7 |
Capital Expenditure, % | -19.52 | -42.82 | -97.2 | -82.4 | -84.15 | -65.22 | -65.22 | -65.22 | -65.22 | -65.22 |
Tax Rate, % | 25.38 | 25.38 | 25.38 | 25.38 | 25.38 | 25.38 | 25.38 | 25.38 | 25.38 | 25.38 |
EBITAT | 4.4 | -3.7 | -5.4 | 17.9 | 12.5 | 3.0 | 3.1 | 3.2 | 3.2 | 3.3 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 6.0 | -1.4 | -21.3 | -23.4 | -.8 | -13.0 | -9.6 | -9.8 | -10.0 | -10.2 |
WACC, % | 6.33 | 6.32 | 6.46 | 6.39 | 6.32 | 6.37 | 6.37 | 6.37 | 6.37 | 6.37 |
PV UFCF | ||||||||||
SUM PV UFCF | -44.2 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -10 | |||||||||
Terminal Value | -238 | |||||||||
Present Terminal Value | -175 | |||||||||
Enterprise Value | -219 | |||||||||
Net Debt | 33 | |||||||||
Equity Value | -252 | |||||||||
Diluted Shares Outstanding, MM | 36 | |||||||||
Equity Value Per Share | -7.00 |
What You Will Get
- Editable Forecast Inputs: Seamlessly adjust assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: PHX Minerals Inc. (PHX) financial data pre-loaded to facilitate your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that caters to your valuation requirements.
- Built for Analysts and Investors: Perfect for evaluating projections, confirming strategies, and enhancing efficiency.
Key Features
- Accurate PHX Financials: Gain access to reliable pre-loaded historical data and future forecasts for PHX Minerals Inc. (PHX).
- Adjustable Forecast Parameters: Modify highlighted cells for key inputs such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Automatic updates for DCF, Net Present Value (NPV), and cash flow assessments.
- Interactive Dashboard: User-friendly charts and summaries to help visualize your valuation insights.
- Designed for All Skill Levels: An intuitive layout suitable for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template featuring PHX Minerals Inc. (PHX) data.
- Step 2: Review the pre-filled sheets to familiarize yourself with the essential metrics.
- Step 3: Modify forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view the updated results, including the intrinsic value of PHX Minerals Inc. (PHX).
- Step 5: Make well-informed investment choices or create reports based on the outputs.
Why Choose PHX Minerals Inc. (PHX)?
- Optimize Efficiency: Access a comprehensive resource without the hassle of building from the ground up.
- Enhance Precision: Utilize dependable geological data and calculations to minimize valuation discrepancies.
- Completely Adaptable: Adjust the model to suit your specific forecasts and expectations.
- Simple to Analyze: User-friendly visuals and outputs facilitate straightforward interpretation of results.
- Endorsed by Industry Leaders: Crafted for professionals who prioritize accuracy and functionality.
Who Should Use PHX Minerals Inc. (PHX)?
- Investors: Make informed investment choices with comprehensive data on mineral assets.
- Financial Analysts: Streamline your analysis with detailed reports and insights tailored for the mineral sector.
- Consultants: Easily modify presentations and reports to meet client needs in the mining industry.
- Energy Sector Enthusiasts: Enhance your knowledge of mineral valuation through case studies and real-time data.
- Educators and Students: Utilize it as a hands-on resource for courses related to energy and mineral economics.
What the Template Contains
- Comprehensive DCF Model: Editable template featuring detailed valuation calculations tailored for PHX Minerals Inc. (PHX).
- Real-World Data: PHX Minerals’ historical and projected financials preloaded for in-depth analysis.
- Customizable Parameters: Modify WACC, growth rates, and tax assumptions to explore various scenarios.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights into PHX's performance.
- Key Ratios: Integrated analysis for assessing profitability, efficiency, and leverage specific to PHX.
- Dashboard with Visual Outputs: Graphs and tables providing clear, actionable results for stakeholders.