|
Riot Blockchain, Inc. (Riot) DCF Valoración
US | Technology | Software - Application | NASDAQ
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Riot Blockchain, Inc. (RIOT) Bundle
Ya sea que sea un inversionista o analista, esta calculadora DCF (Riot) es su herramienta esencial para una valoración precisa. Con datos reales de Riot Blockchain, Inc., puede ajustar las previsiones y observar los efectos en tiempo real.
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 | 6.8 | 12.1 | 213.2 | 259.2 | 280.7 | 425.6 | 645.4 | 978.6 | 1,483.9 | 2,250.1 |
| Revenue Growth, % | 0 | 76.7 | 1665.11 | 21.54 | 8.3 | 51.63 | 51.63 | 51.63 | 51.63 | 51.63 |
| EBITDA | -17.9 | -7.8 | 11.7 | 25.4 | -2.8 | -128.0 | -194.0 | -294.2 | -446.1 | -676.5 |
| EBITDA, % | -261.93 | -64.61 | 5.49 | 9.79 | -0.9926 | -30.07 | -30.07 | -30.07 | -30.07 | -30.07 |
| Depreciation | 2.4 | 4.9 | 26.6 | 120.1 | 252.4 | 190.9 | 289.5 | 439.0 | 665.7 | 1,009.4 |
| Depreciation, % | 35.34 | 40.24 | 12.47 | 46.35 | 89.91 | 44.86 | 44.86 | 44.86 | 44.86 | 44.86 |
| EBIT | -20.3 | -12.7 | -14.9 | -94.8 | -255.1 | -284.7 | -431.7 | -654.6 | -992.6 | -1,505.0 |
| EBIT, % | -297.26 | -104.85 | -6.98 | -36.56 | -90.9 | -66.89 | -66.89 | -66.89 | -66.89 | -66.89 |
| Total Cash | 11.3 | 235.0 | 482.7 | 339.7 | 908.3 | 425.6 | 645.4 | 978.6 | 1,483.9 | 2,250.1 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .0 | .0 | 25.3 | 46.7 | 40.1 | 37.6 | 57.0 | 86.4 | 131.0 | 198.6 |
| Account Receivables, % | 0 | 0 | 11.85 | 18.01 | 14.27 | 8.83 | 8.83 | 8.83 | 8.83 | 8.83 |
| Inventories | .0 | .0 | -169.4 | 24.3 | .0 | -59.6 | -90.4 | -137.1 | -207.9 | -315.3 |
| Inventories, % | 0 | 0 | -79.44 | 9.37 | 0 | -14.01 | -14.01 | -14.01 | -14.01 | -14.01 |
| Accounts Payable | .7 | .7 | 20.0 | 18.4 | 23.2 | 35.1 | 53.2 | 80.6 | 122.3 | 185.4 |
| Accounts Payable, % | 10.49 | 5.94 | 9.4 | 7.12 | 8.25 | 8.24 | 8.24 | 8.24 | 8.24 | 8.24 |
| Capital Expenditure | -5.0 | -41.3 | -422.0 | -352.9 | -424.1 | -402.7 | -610.6 | -925.9 | -1,404.0 | -2,128.9 |
| Capital Expenditure, % | -73.07 | -341.66 | -197.89 | -136.15 | -151.11 | -94.61 | -94.61 | -94.61 | -94.61 | -94.61 |
| Tax Rate, % | 9.33 | 9.33 | 9.33 | 9.33 | 9.33 | 9.33 | 9.33 | 9.33 | 9.33 | 9.33 |
| EBITAT | -20.2 | -12.7 | -15.4 | -92.6 | -231.3 | -277.7 | -421.1 | -638.5 | -968.2 | -1,468.1 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -22.0 | -49.1 | -247.3 | -542.1 | -367.5 | -415.4 | -712.6 | -1,080.6 | -1,638.6 | -2,484.7 |
| WACC, % | 23.51 | 23.51 | 23.51 | 23.51 | 23.51 | 23.51 | 23.51 | 23.51 | 23.51 | 23.51 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -2,945.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -2,534 | |||||||||
| Terminal Value | -11,783 | |||||||||
| Present Terminal Value | -4,100 | |||||||||
| Enterprise Value | -7,045 | |||||||||
| Net Debt | -576 | |||||||||
| Equity Value | -6,470 | |||||||||
| Diluted Shares Outstanding, MM | 175 | |||||||||
| Equity Value Per Share | -36.96 |
What You Will Get
- Real RIOT 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 in real-time.
- Scenario Analysis: Evaluate various scenarios to assess Riot Blockchain’s future potential.
- User-Friendly Design: Designed for professionals while remaining approachable for newcomers.
Key Features
- Accurate Financial Data: Gain access to reliable pre-loaded historical figures and future forecasts for Riot Blockchain, Inc. (RIOT).
- Flexible Forecasting Assumptions: Modify yellow-highlighted fields such as WACC, growth rates, and profit margins.
- Automated Calculations: Real-time 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 accessible, intuitive layout tailored for investors, CFOs, and consultants alike.
How It Works
- Download the Template: Gain immediate access to the Excel-based RIOT DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and more.
- Instant Calculations: The model automatically recalculates Riot Blockchain’s intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Utilize the results to inform your investment or financial analysis.
Why Choose This Calculator for Riot Blockchain, Inc. (RIOT)?
- Accurate Data: Up-to-date financials of Riot Blockchain ensure dependable valuation outcomes.
- Customizable: Tailor essential parameters such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations allow you to avoid starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the blockchain sector.
- User-Friendly: Clear layout and guided instructions make it accessible for all users.
Who Should Use Riot Blockchain, Inc. (RIOT)?
- Investors: Gain insights into the cryptocurrency market with a cutting-edge blockchain investment tool.
- Financial Analysts: Streamline your analysis with a customizable financial model tailored for blockchain assets.
- Consultants: Effortlessly modify the template for client reports or strategic presentations.
- Crypto Enthusiasts: Enhance your knowledge of blockchain technology and its market implications through practical examples.
- Educators and Students: Utilize it as an engaging resource in courses focused on finance and blockchain technology.
What the Template Contains
- Comprehensive DCF Model: Editable template with detailed valuation calculations tailored for Riot Blockchain, Inc. (RIOT).
- Real-World Data: Riot's historical and projected financials preloaded for thorough analysis.
- Customizable Parameters: Adjust WACC, growth rates, and tax assumptions for scenario testing.
- Financial Statements: Complete annual and quarterly breakdowns for enhanced insights.
- Key Ratios: In-built analysis for profitability, efficiency, and leverage specific to Riot Blockchain.
- Dashboard with Visual Outputs: Charts and tables providing clear, actionable results for informed decision-making.