Indonesia Energy Corporation Limited (INDO) 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
Indonesia Energy Corporation Limited (INDO) Bundle
Whether you're an investor or analyst, this (INDO) DCF Calculator is your go-to tool for accurate valuation. Featuring real data from Indonesia Energy Corporation Limited, you can adjust forecasts and observe the effects in real-time.
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 | 4.2 | 2.0 | 2.5 | 4.1 | 3.5 | 3.7 | 4.0 | 4.2 | 4.5 | 4.7 |
| Revenue Growth, % | 0 | -52.65 | 23.82 | 67.07 | -13.96 | 6.07 | 6.07 | 6.07 | 6.07 | 6.07 |
| EBITDA | -.7 | -6.6 | -5.3 | -3.5 | -2.4 | -2.8 | -2.9 | -3.1 | -3.3 | -3.5 |
| EBITDA, % | -17.33 | -331.73 | -215.72 | -84.41 | -67.52 | -73.85 | -73.85 | -73.85 | -73.85 | -73.85 |
| Depreciation | .9 | .8 | .9 | 1.6 | 1.2 | 1.3 | 1.3 | 1.4 | 1.5 | 1.6 |
| Depreciation, % | 22.33 | 38.95 | 36.28 | 38.29 | 33.33 | 33.84 | 33.84 | 33.84 | 33.84 | 33.84 |
| EBIT | -1.7 | -7.3 | -6.2 | -5.0 | -3.6 | -3.3 | -3.5 | -3.7 | -3.9 | -4.2 |
| EBIT, % | -39.66 | -370.68 | -252 | -122.7 | -100.85 | -87.93 | -87.93 | -87.93 | -87.93 | -87.93 |
| Total Cash | 12.2 | 6.9 | .6 | 5.9 | 2.0 | 2.9 | 3.0 | 3.2 | 3.4 | 3.6 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .4 | 1.1 | 1.0 | .7 | .9 | 1.1 | 1.2 | 1.2 | 1.3 | 1.4 |
| Account Receivables, % | 8.38 | 57.15 | 41.05 | 15.99 | 25.25 | 29.56 | 29.56 | 29.56 | 29.56 | 29.56 |
| Inventories | .2 | .3 | .1 | .1 | .1 | .3 | .3 | .3 | .3 | .3 |
| Inventories, % | 5.94 | 14.97 | 5.57 | 2.97 | 4.21 | 6.73 | 6.73 | 6.73 | 6.73 | 6.73 |
| Accounts Payable | .9 | .3 | 1.6 | .7 | .8 | 1.1 | 1.1 | 1.2 | 1.3 | 1.3 |
| Accounts Payable, % | 21.93 | 15 | 65.41 | 17.55 | 21.38 | 28.25 | 28.25 | 28.25 | 28.25 | 28.25 |
| Capital Expenditure | -.5 | -.4 | -.3 | .0 | -.4 | -.4 | -.4 | -.5 | -.5 | -.5 |
| Capital Expenditure, % | -13.04 | -18.04 | -12.7 | -0.0410992 | -11.9 | -11.14 | -11.14 | -11.14 | -11.14 | -11.14 |
| Tax Rate, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| EBITAT | -1.7 | -7.2 | -6.2 | 1.6 | -3.6 | -2.6 | -2.8 | -2.9 | -3.1 | -3.3 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -1.0 | -8.2 | -4.0 | 2.6 | -3.0 | -1.8 | -1.9 | -2.0 | -2.1 | -2.3 |
| WACC, % | 5.36 | 5.36 | 5.36 | 5.2 | 5.36 | 5.33 | 5.33 | 5.33 | 5.33 | 5.33 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -8.6 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -2 | |||||||||
| Terminal Value | -69 | |||||||||
| Present Terminal Value | -53 | |||||||||
| Enterprise Value | -62 | |||||||||
| Net Debt | -1 | |||||||||
| Equity Value | -61 | |||||||||
| Diluted Shares Outstanding, MM | 10 | |||||||||
| Equity Value Per Share | -6.02 |
What You Will Get
- Real INDO Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically in real-time.
- Scenario Analysis: Explore various scenarios to assess Indonesia Energy Corporation's future performance.
- User-Friendly Design: Tailored for professionals while remaining easy to navigate for newcomers.
Key Features
- Comprehensive Financial Data: Gain access to precise pre-loaded historical data and future forecasts for Indonesia Energy Corporation Limited (INDO).
- Adjustable Forecast Parameters: Modify editable fields highlighted in yellow, including WACC, growth rates, and margins.
- Real-Time Calculations: Automatic recalculations for DCF, Net Present Value (NPV), and cash flow assessments.
- User-Friendly Dashboard: Clear and concise charts and summaries to help visualize your valuation outcomes.
- Designed for All Users: An intuitive layout suitable for investors, CFOs, and consultants, regardless of experience level.
How It Works
- Step 1: Download the prebuilt Excel template featuring Indonesia Energy Corporation Limited’s (INDO) data.
- Step 2: Navigate through 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 see the recalculated results, including Indonesia Energy Corporation Limited’s (INDO) intrinsic value.
- Step 5: Make well-informed investment decisions or create reports based on the outputs.
Why Choose This Calculator for Indonesia Energy Corporation Limited (INDO)?
- Accuracy: Utilizes real financial data from Indonesia Energy Corporation for precise calculations.
- Flexibility: Allows users to easily adjust and experiment with various input parameters.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the expertise and standards expected at the CFO level.
- User-Friendly: Intuitive design ensures accessibility for users with varying levels of financial knowledge.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and precise valuation models for portfolio assessments related to Indonesia Energy Corporation Limited (INDO).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver clients accurate valuation insights for Indonesia Energy Corporation Limited (INDO) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Energy Sector Enthusiasts: Gain insights into how energy companies like Indonesia Energy Corporation Limited (INDO) are valued in the market.
What the Template Contains
- Pre-Filled Data: Includes Indonesia Energy Corporation Limited’s (INDO) historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze Indonesia Energy Corporation Limited’s (INDO) profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.