Iris Energy Limited (IREN) 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
Iris Energy Limited (IREN) Bundle
Designed for accuracy, our (IREN) DCF Calculator enables you to evaluate Iris Energy Limited's valuation using up-to-date financial data, while providing complete flexibility to modify all essential parameters for improved projections.
Discounted Cash Flow (DCF) - (USD MM)
| Year | AY1 2020 |
AY2 2021 |
AY3 2022 |
AY4 2023 |
AY5 2024 |
FY1 2025 |
FY2 2026 |
FY3 2027 |
FY4 2028 |
FY5 2029 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue | 1.4 | 4.9 | 36.7 | 46.9 | 117.4 | 213.6 | 388.7 | 707.2 | 1,287.0 | 2,342.1 |
| Revenue Growth, % | 0 | 260.53 | 653.22 | 27.9 | 149.98 | 81.98 | 81.98 | 81.98 | 81.98 | 81.98 |
| EBITDA | -.8 | -27.0 | -234.5 | -76.0 | 15.8 | -147.0 | -267.5 | -486.8 | -885.9 | -1,612.2 |
| EBITDA, % | -57.63 | -553.51 | -638.78 | -161.92 | 13.46 | -68.84 | -68.84 | -68.84 | -68.84 | -68.84 |
| Depreciation | .5 | .6 | 4.8 | 19.2 | 31.5 | 54.5 | 99.3 | 180.6 | 328.7 | 598.1 |
| Depreciation, % | 35.06 | 11.92 | 13.01 | 40.86 | 26.83 | 25.54 | 25.54 | 25.54 | 25.54 | 25.54 |
| EBIT | -1.3 | -27.6 | -239.3 | -95.2 | -15.7 | -173.5 | -315.6 | -574.4 | -1,045.2 | -1,902.1 |
| EBIT, % | -92.69 | -565.43 | -651.79 | -202.78 | -13.38 | -81.21 | -81.21 | -81.21 | -81.21 | -81.21 |
| Total Cash | 1.2 | 24.3 | 68.4 | 42.8 | 255.6 | 205.5 | 374.0 | 680.7 | 1,238.7 | 2,254.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | .0 | 4.1 | 18.3 | 10.3 | 18.8 | 34.3 | 62.4 | 113.5 |
| Account Receivables, % | 0 | 0 | 0 | 8.67 | 15.56 | 4.84 | 4.84 | 4.84 | 4.84 | 4.84 |
| Inventories | .0 | .1 | .0 | .0 | .0 | .9 | 1.6 | 3.0 | 5.5 | 9.9 |
| Inventories, % | 0.03293468 | 2.08 | 0 | 0 | 0 | 0.42358 | 0.42358 | 0.42358 | 0.42358 | 0.42358 |
| Accounts Payable | .5 | .3 | 8.2 | 7.2 | 17.0 | 40.0 | 72.8 | 132.5 | 241.1 | 438.8 |
| Accounts Payable, % | 34.54 | 6.95 | 22.41 | 15.29 | 14.49 | 18.74 | 18.74 | 18.74 | 18.74 | 18.74 |
| Capital Expenditure | -2.7 | -50.5 | -183.0 | -72.2 | -298.4 | -213.6 | -388.7 | -707.2 | -1,287.0 | -2,342.1 |
| Capital Expenditure, % | -199.42 | -1036.28 | -498.41 | -153.71 | -254.25 | -100 | -100 | -100 | -100 | -100 |
| Tax Rate, % | -13.54 | -13.54 | -13.54 | -13.54 | -13.54 | -13.54 | -13.54 | -13.54 | -13.54 | -13.54 |
| EBITAT | -1.2 | -28.1 | -240.8 | -96.5 | -17.8 | -173.3 | -315.3 | -573.7 | -1,044.1 | -1,899.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -3.0 | -78.3 | -411.0 | -154.6 | -289.1 | -302.3 | -581.1 | -1,057.5 | -1,924.3 | -3,501.8 |
| WACC, % | 20.49 | 20.49 | 20.49 | 20.49 | 20.49 | 20.49 | 20.49 | 20.49 | 20.49 | 20.49 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -3,547.8 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -3,572 | |||||||||
| Terminal Value | -19,320 | |||||||||
| Present Terminal Value | -7,608 | |||||||||
| Enterprise Value | -11,156 | |||||||||
| Net Debt | -251 | |||||||||
| Equity Value | -10,905 | |||||||||
| Diluted Shares Outstanding, MM | 100 | |||||||||
| Equity Value Per Share | -109.45 |
What You Will Receive
- Comprehensive Financial Model: Utilize Iris Energy Limited’s (IREN) actual data for accurate DCF valuation.
- Complete Forecasting Control: Modify revenue growth, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Instant updates ensure you receive immediate results as alterations are made.
- Professional-Grade Template: A polished Excel file crafted for high-quality valuation presentations.
- Flexible and Reusable: Designed for adaptability, allowing for repeated applications in detailed forecasting.
Key Features
- Accurate Financial Data: Gain access to reliable pre-loaded historical figures and future forecasts for Iris Energy Limited (IREN).
- Adjustable Forecast Parameters: Modify highlighted cells for key metrics such as WACC, growth rates, and profit margins.
- Real-Time Calculations: Enjoy automatic updates 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 Levels: An intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Step 1: Download the prebuilt Excel template featuring Iris Energy Limited’s (IREN) 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 Iris Energy Limited’s (IREN) intrinsic value.
- Step 5: Utilize the outputs to make informed investment decisions or create reports.
Why Choose This Calculator for Iris Energy Limited (IREN)?
- Accuracy: Utilizes real Iris Energy financials to ensure precise data.
- Flexibility: Built to allow users to easily test and adjust inputs.
- Time-Saving: Eliminate the need to create a DCF model from the ground up.
- Professional-Grade: Crafted with the precision and usability expected at the CFO level.
- User-Friendly: Intuitive design makes it accessible for users without extensive financial modeling skills.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for analyzing portfolios involving Iris Energy Limited (IREN).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the company.
- Consultants and Advisors: Deliver precise valuation insights to clients regarding Iris Energy Limited (IREN) stock.
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Energy Sector Enthusiasts: Gain insights into how renewable energy companies like Iris Energy Limited (IREN) are valued in the market.
What the Template Contains for Iris Energy Limited (IREN)
- Preloaded IREN 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.