HighPeak Energy, Inc. (HPK) 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
HighPeak Energy, Inc. (HPK) Bundle
Enhance your investment strategies with the HighPeak Energy, Inc. (HPK) DCF Calculator! Explore authentic financial data, adjust growth projections and expenses, and witness the immediate effects on the intrinsic value of HighPeak Energy, Inc. (HPK) as you make changes.
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 | 8.1 | 24.6 | 220.1 | 755.7 | 1,111.3 | 2,075.5 | 3,876.3 | 7,239.5 | 13,520.9 | 25,252.2 |
Revenue Growth, % | 0 | 203.43 | 793.98 | 243.3 | 47.06 | 86.76 | 86.76 | 86.76 | 86.76 | 86.76 |
EBITDA | -7.2 | -12.8 | 140.3 | 540.9 | 854.6 | 295.3 | 551.5 | 1,030.0 | 1,923.7 | 3,592.7 |
EBITDA, % | -89.19 | -51.9 | 63.74 | 71.58 | 76.9 | 14.23 | 14.23 | 14.23 | 14.23 | 14.23 |
Depreciation | 4.3 | 16.4 | 65.4 | 178.1 | 424.4 | 878.2 | 1,640.2 | 3,063.2 | 5,721.0 | 10,684.9 |
Depreciation, % | 53.49 | 66.61 | 29.7 | 23.57 | 38.19 | 42.31 | 42.31 | 42.31 | 42.31 | 42.31 |
EBIT | -11.6 | -29.2 | 74.9 | 362.8 | 430.2 | -328.9 | -614.2 | -1,147.2 | -2,142.5 | -4,001.4 |
EBIT, % | -142.69 | -118.51 | 34.05 | 48.01 | 38.71 | -15.85 | -15.85 | -15.85 | -15.85 | -15.85 |
Total Cash | 22.7 | 19.6 | 34.9 | 30.5 | 194.5 | 899.9 | 1,680.7 | 3,138.9 | 5,862.3 | 10,948.6 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 7.6 | 11.3 | 39.4 | 96.6 | 94.6 | 740.0 | 1,382.0 | 2,581.0 | 4,820.5 | 9,002.9 |
Account Receivables, % | 93.11 | 45.97 | 17.89 | 12.78 | 8.51 | 35.65 | 35.65 | 35.65 | 35.65 | 35.65 |
Inventories | .2 | .1 | 3.3 | 13.3 | 7.3 | 27.7 | 51.7 | 96.6 | 180.3 | 336.8 |
Inventories, % | 2.27 | 0.49141 | 1.5 | 1.76 | 0.65275 | 1.33 | 1.33 | 1.33 | 1.33 | 1.33 |
Accounts Payable | 11.1 | 7.6 | 38.1 | 105.6 | 63.6 | 696.6 | 1,300.9 | 2,429.7 | 4,537.8 | 8,475.0 |
Accounts Payable, % | 137.01 | 30.79 | 17.33 | 13.97 | 5.72 | 33.56 | 33.56 | 33.56 | 33.56 | 33.56 |
Capital Expenditure | -71.9 | -124.7 | -291.0 | -1,311.3 | -1,125.9 | -2,075.5 | -3,876.3 | -7,239.5 | -13,520.9 | -25,252.2 |
Capital Expenditure, % | -886.3 | -506.4 | -132.2 | -173.53 | -101.32 | -100 | -100 | -100 | -100 | -100 |
Tax Rate, % | 23.39 | 23.39 | 23.39 | 23.39 | 23.39 | 23.39 | 23.39 | 23.39 | 23.39 | 23.39 |
EBITAT | -11.6 | -28.0 | 57.5 | 275.2 | 329.6 | -279.6 | -522.3 | -975.4 | -1,821.7 | -3,402.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -75.8 | -143.5 | -168.8 | -857.8 | -405.9 | -1,509.8 | -2,820.1 | -5,266.9 | -9,836.7 | -18,371.4 |
WACC, % | 9.76 | 9.55 | 8.58 | 8.54 | 8.57 | 9 | 9 | 9 | 9 | 9 |
PV UFCF | ||||||||||
SUM PV UFCF | -26,734.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -18,739 | |||||||||
Terminal Value | -267,699 | |||||||||
Present Terminal Value | -173,987 | |||||||||
Enterprise Value | -200,721 | |||||||||
Net Debt | 956 | |||||||||
Equity Value | -201,677 | |||||||||
Diluted Shares Outstanding, MM | 123 | |||||||||
Equity Value Per Share | -1,639.39 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to generate various scenarios.
- Real-World Data: HighPeak Energy, Inc.’s (HPK) financial data pre-loaded to kickstart your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value for you.
- Customizable and Professional: A sleek Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for assessing projections, validating strategies, and enhancing efficiency.
Key Features
- Customizable Production Metrics: Adjust essential inputs such as oil production rates, operating costs, and capital investments.
- Instant DCF Valuation: Quickly calculates intrinsic value, NPV, and other financial metrics.
- Industry-Leading Precision: Incorporates HighPeak Energy’s actual financial data for accurate valuation results.
- Effortless Scenario Analysis: Easily evaluate various assumptions and analyze outcomes side by side.
- Efficiency Booster: Remove the hassle of developing intricate valuation models from the ground up.
How It Works
- Step 1: Download the prebuilt Excel template with HighPeak Energy, Inc.'s (HPK) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including HighPeak Energy, Inc.'s (HPK) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for HighPeak Energy, Inc. (HPK)?
- Accurate Data: Real HighPeak Energy financials ensure reliable valuation results.
- Customizable: Adjust key parameters like growth rates, WACC, and tax rates to align with your projections.
- Time-Saving: Pre-built calculations save you from starting from scratch.
- Professional-Grade Tool: Tailored for investors, analysts, and consultants in the energy sector.
- User-Friendly: Intuitive design and step-by-step guidance make it accessible for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing HighPeak Energy, Inc. (HPK).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in HighPeak Energy, Inc. (HPK).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Energy Sector Enthusiasts: Gain insights into how companies like HighPeak Energy, Inc. (HPK) are valued in the energy market.
What the Template Contains
- Historical Data: Includes HighPeak Energy's (HPK) past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate HighPeak Energy's (HPK) intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital for HighPeak Energy (HPK).
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions for HighPeak Energy (HPK).
- Quarterly and Annual Statements: A complete breakdown of HighPeak Energy's (HPK) financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically for HighPeak Energy (HPK).