Obsidian Energy Ltd. (OBE) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Obsidian Energy Ltd. (OBE) Bundle
Explore the financial future of Obsidian Energy Ltd. (OBE) with our user-friendly DCF Calculator! Enter your assumptions for growth, margins, and costs to calculate the intrinsic value of Obsidian Energy Ltd. (OBE) and refine your investment strategy.
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 | 288.7 | 198.9 | 345.3 | 638.6 | 453.5 | 565.1 | 704.2 | 877.5 | 1,093.4 | 1,362.6 |
Revenue Growth, % | 0 | -31.13 | 73.65 | 84.92 | -28.99 | 24.61 | 24.61 | 24.61 | 24.61 | 24.61 |
EBITDA | 111.4 | 107.9 | 318.8 | 430.7 | 266.3 | 351.9 | 438.5 | 546.4 | 680.9 | 848.5 |
EBITDA, % | 38.58 | 54.28 | 92.32 | 67.45 | 58.72 | 62.27 | 62.27 | 62.27 | 62.27 | 62.27 |
Depreciation | 176.4 | 93.1 | 87.2 | 128.9 | 146.5 | 209.9 | 261.5 | 325.9 | 406.1 | 506.0 |
Depreciation, % | 61.11 | 46.84 | 25.27 | 20.18 | 32.3 | 37.14 | 37.14 | 37.14 | 37.14 | 37.14 |
EBIT | -65.0 | 14.8 | 231.6 | 301.8 | 119.8 | 142.0 | 176.9 | 220.5 | 274.8 | 342.4 |
EBIT, % | -22.52 | 7.43 | 67.06 | 47.26 | 26.42 | 25.13 | 25.13 | 25.13 | 25.13 | 25.13 |
Total Cash | .7 | 5.6 | 5.1 | .6 | .3 | 5.3 | 6.6 | 8.2 | 10.3 | 12.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 48.9 | 28.3 | 47.8 | 57.3 | 48.6 | 73.2 | 91.2 | 113.6 | 141.6 | 176.4 |
Account Receivables, % | 16.95 | 14.24 | 13.85 | 8.98 | 10.71 | 12.95 | 12.95 | 12.95 | 12.95 | 12.95 |
Inventories | 59.0 | .6 | 1.2 | 4.3 | .0 | 24.6 | 30.6 | 38.2 | 47.6 | 59.3 |
Inventories, % | 20.43 | 0.27923 | 0.36181 | 0.67391 | 0 | 4.35 | 4.35 | 4.35 | 4.35 | 4.35 |
Accounts Payable | 77.0 | 51.4 | 74.8 | 128.8 | 134.3 | 140.1 | 174.6 | 217.6 | 271.2 | 337.9 |
Accounts Payable, % | 26.68 | 25.86 | 21.67 | 20.17 | 29.62 | 24.8 | 24.8 | 24.8 | 24.8 | 24.8 |
Capital Expenditure | -71.5 | -39.7 | -97.9 | -221.7 | -203.4 | -172.5 | -215.0 | -267.9 | -333.8 | -416.0 |
Capital Expenditure, % | -24.76 | -19.97 | -28.34 | -34.72 | -44.86 | -30.53 | -30.53 | -30.53 | -30.53 | -30.53 |
Tax Rate, % | 24.79 | 24.79 | 24.79 | 24.79 | 24.79 | 24.79 | 24.79 | 24.79 | 24.79 | 24.79 |
EBITAT | -66.4 | 15.4 | 101.7 | 433.7 | 90.1 | 119.0 | 148.3 | 184.8 | 230.3 | 287.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 7.6 | 122.3 | 94.3 | 382.4 | 51.6 | 113.1 | 205.3 | 255.8 | 318.8 | 397.3 |
WACC, % | 14.8 | 14.8 | 12.78 | 14.8 | 13.91 | 14.22 | 14.22 | 14.22 | 14.22 | 14.22 |
PV UFCF | ||||||||||
SUM PV UFCF | 819.8 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 405 | |||||||||
Terminal Value | 3,317 | |||||||||
Present Terminal Value | 1,707 | |||||||||
Enterprise Value | 2,527 | |||||||||
Net Debt | 158 | |||||||||
Equity Value | 2,369 | |||||||||
Diluted Shares Outstanding, MM | 84 | |||||||||
Equity Value Per Share | 28.16 |
What You Will Get
- Pre-Filled Financial Model: Obsidian Energy Ltd.’s (OBE) actual data enables precise DCF valuation.
- Full Forecast Control: Adjust production levels, operating costs, discount rates, and other key drivers.
- Instant Calculations: Automatic updates ensure you see results as you make changes.
- Investor-Ready Template: A refined Excel file designed for professional-grade valuation.
- Customizable and Reusable: Tailored for flexibility, allowing repeated use for detailed forecasts.
Key Features
- Comprehensive OBE Data: Pre-loaded with Obsidian Energy's historical performance metrics and future projections.
- Customizable Parameters: Modify production rates, operating costs, discount rates, tax implications, and capital investments.
- Interactive Valuation Model: Instant updates to Net Present Value (NPV) and intrinsic value based on your modifications.
- Scenario Analysis: Develop various forecast scenarios to assess different valuation possibilities.
- Intuitive Interface: Clean, organized, and crafted for both industry professionals and newcomers.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Obsidian Energy Ltd. (OBE) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Obsidian Energy Ltd.'s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Obsidian Energy Ltd. (OBE)?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your financial analysis.
- Real-Time Valuation: Observe immediate updates to Obsidian Energy’s valuation with input changes.
- Pre-Configured Data: Comes with Obsidian Energy’s actual financial metrics for swift evaluations.
- Endorsed by Experts: Utilized by investors and analysts for making strategic decisions.
Who Should Use Obsidian Energy Ltd. (OBE)?
- Investors: Empower your investment strategies with insights from a leading energy company.
- Financial Analysts: Enhance your analysis with comprehensive data and reports specific to the energy sector.
- Consultants: Tailor presentations and recommendations using detailed information from Obsidian Energy Ltd. (OBE).
- Energy Sector Enthusiasts: Expand your knowledge of the oil and gas industry through real-time updates and case studies.
- Educators and Students: Utilize resources from Obsidian Energy Ltd. (OBE) as a practical example in energy finance courses.
What the Template Contains
- Preloaded OBE 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.