PHX Minerals Inc. (PHX) DCF Valuation

PHX Minerals Inc. (PHX) DCF Valuation
  • ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
  • ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
  • ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
  • ✓ Aucune Expertise N'Est Requise; Facile À Suivre

PHX Minerals Inc. (PHX) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Streamline your analysis and improve precision with our (PHX) DCF Calculator! Equipped with real data from PHX Minerals Inc. and customizable assumptions, this tool empowers you to forecast, evaluate, and appraise (PHX) like a seasoned investor.


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
Account Receivables, % 12.5 27.03 40.25 24.59 13.72
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.

No products were found matching.