|
Stronghold Digital Mining, Inc. (SDIG) DCF Valuation
US | Financial Services | Financial - Capital Markets | NASDAQ
|
- ✓ 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
Stronghold Digital Mining, Inc. (SDIG) Bundle
Evaluate Stronghold Digital Mining, Inc. (SDIG) financial prospects like an expert! This (SDIG) DCF Calculator provides pre-filled financial data along with the flexibility to modify revenue growth, WACC, margins, and other essential assumptions to align with your forecasts.
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 | 11.0 | 4.1 | 30.9 | 106.0 | 75.0 | 95.2 | 120.9 | 153.5 | 195.0 | 247.6 |
| Revenue Growth, % | 0 | -62.73 | 650.66 | 242.98 | -29.3 | 26.99 | 26.99 | 26.99 | 26.99 | 26.99 |
| EBITDA | -1.2 | .6 | -15.0 | -134.0 | -56.5 | -41.8 | -53.1 | -67.4 | -85.6 | -108.7 |
| EBITDA, % | -10.63 | 15.03 | -48.6 | -126.35 | -75.38 | -43.92 | -43.92 | -43.92 | -43.92 | -43.92 |
| Depreciation | .5 | .6 | 7.6 | 47.3 | 35.5 | 25.6 | 32.5 | 41.3 | 52.4 | 66.6 |
| Depreciation, % | 4.38 | 13.56 | 24.61 | 44.59 | 47.31 | 26.89 | 26.89 | 26.89 | 26.89 | 26.89 |
| EBIT | -1.7 | .1 | -22.6 | -181.3 | -92.0 | -54.6 | -69.3 | -88.1 | -111.8 | -142.0 |
| EBIT, % | -15.01 | 1.47 | -73.21 | -170.95 | -122.69 | -57.35 | -57.35 | -57.35 | -57.35 | -57.35 |
| Total Cash | .1 | .3 | 31.8 | 13.3 | 4.2 | 24.1 | 30.6 | 38.9 | 49.4 | 62.8 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .1 | .1 | 2.1 | 10.9 | .6 | 4.0 | 5.0 | 6.4 | 8.1 | 10.3 |
| Account Receivables, % | 1.24 | 1.6 | 6.83 | 10.29 | 0.80612 | 4.15 | 4.15 | 4.15 | 4.15 | 4.15 |
| Inventories | .5 | .4 | 3.4 | 4.5 | 4.2 | 6.7 | 8.5 | 10.8 | 13.7 | 17.4 |
| Inventories, % | 4.79 | 9.64 | 10.91 | 4.22 | 5.6 | 7.03 | 7.03 | 7.03 | 7.03 | 7.03 |
| Accounts Payable | 7.9 | 7.8 | 28.7 | 27.5 | 11.9 | 58.3 | 74.1 | 94.0 | 119.4 | 151.7 |
| Accounts Payable, % | 71.79 | 188.93 | 92.68 | 25.97 | 15.82 | 61.25 | 61.25 | 61.25 | 61.25 | 61.25 |
| Capital Expenditure | .0 | -2.0 | -253.7 | -84.6 | -23.9 | -49.5 | -62.8 | -79.8 | -101.4 | -128.7 |
| Capital Expenditure, % | 0 | -48.23 | -820.51 | -79.78 | -31.9 | -51.98 | -51.98 | -51.98 | -51.98 | -51.98 |
| Tax Rate, % | 29.88 | 29.88 | 29.88 | 29.88 | 29.88 | 29.88 | 29.88 | 29.88 | 29.88 | 29.88 |
| EBITAT | -4.2 | .7 | -13.4 | -127.4 | -64.5 | -43.6 | -55.4 | -70.4 | -89.4 | -113.5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 3.5 | -.7 | -243.6 | -175.7 | -58.0 | -26.9 | -72.9 | -92.5 | -117.5 | -149.2 |
| WACC, % | 17.44 | 17.44 | 12.67 | 13.97 | 13.95 | 15.09 | 15.09 | 15.09 | 15.09 | 15.09 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -280.0 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -152 | |||||||||
| Terminal Value | -1,163 | |||||||||
| Present Terminal Value | -576 | |||||||||
| Enterprise Value | -856 | |||||||||
| Net Debt | 53 | |||||||||
| Equity Value | -909 | |||||||||
| Diluted Shares Outstanding, MM | 7 | |||||||||
| Equity Value Per Share | -133.27 |
What You Will Get
- Comprehensive SDIG Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Real-Time Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate multiple scenarios to assess Stronghold Digital Mining's future potential.
- User-Friendly Interface: Designed for professionals while remaining easy to navigate for newcomers.
Key Features
- Customizable Mining Parameters: Adjust essential factors such as hash rate, energy costs, and equipment efficiency.
- Instant Profitability Analysis: Quickly computes profit margins, ROI, and other key metrics.
- Industry-Leading Precision: Leverages Stronghold’s actual operational data for accurate financial assessments.
- Effortless Scenario Testing: Evaluate various mining strategies and analyze their potential impacts with ease.
- Efficiency Booster: Streamlines the valuation process, removing the need for complex financial modeling.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Stronghold Digital Mining, Inc. (SDIG) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Stronghold Digital Mining, Inc. (SDIG)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose Stronghold Digital Mining, Inc. (SDIG)?
- Optimize Efficiency: Instantly access mining data without the need for complex setups.
- Enhance Reliability: Our robust analytics ensure accurate assessments of mining performance.
- Completely Adaptable: Modify parameters to align with your operational strategies and forecasts.
- User-Friendly Insights: Intuitive visualizations facilitate straightforward interpretation of results.
- Endorsed by Industry Leaders: Built for professionals who prioritize accuracy and functionality.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for assessing investments in Stronghold Digital Mining, Inc. (SDIG).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Offer clients precise valuation insights concerning Stronghold Digital Mining, Inc. (SDIG).
- Students and Educators: Utilize real-world data for practicing and teaching financial modeling related to digital mining.
- Tech Enthusiasts: Gain insights into how digital mining companies like Stronghold Digital Mining, Inc. (SDIG) are valued in the financial market.
What the Template Contains
- Pre-Filled DCF Model: Stronghold Digital Mining, Inc.'s (SDIG) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Stronghold Digital Mining, Inc.'s (SDIG) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.