Comstock Inc. (LODE) DCF Valuation
- ✓ 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
Comstock Inc. (LODE) Bundle
Engineered for accuracy, our (LODE) DCF Calculator enables you to evaluate Comstock Inc. valuation using real-world financial data, offering complete flexibility to modify all essential parameters for improved projections.
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 | .2 | .2 | .9 | .2 | 1.3 | 1.7 | 2.3 | 3.0 | 4.0 | 5.4 |
Revenue Growth, % | 0 | 12.29 | 327.45 | -79.34 | 615.38 | 33.24 | 33.24 | 33.24 | 33.24 | 33.24 |
EBITDA | -1.5 | -4.2 | -28.8 | -41.4 | 15.1 | -1.0 | -1.4 | -1.8 | -2.4 | -3.2 |
EBITDA, % | -832.98 | -2100.31 | -3341.72 | -23216.41 | 1182.85 | -60 | -60 | -60 | -60 | -60 |
Depreciation | 1.4 | 1.2 | 1.4 | 3.7 | 2.9 | 1.7 | 2.3 | 3.0 | 4.0 | 5.4 |
Depreciation, % | 796.09 | 613.75 | 156.78 | 2091.94 | 227.7 | 100 | 100 | 100 | 100 | 100 |
EBIT | -2.9 | -5.5 | -30.2 | -45.1 | 12.2 | -1.0 | -1.4 | -1.8 | -2.4 | -3.2 |
EBIT, % | -1629.07 | -2714.06 | -3498.5 | -25308.35 | 955.16 | -60 | -60 | -60 | -60 | -60 |
Total Cash | 1.0 | 6.4 | 6.8 | 2.5 | 22.7 | 1.7 | 2.3 | 3.0 | 4.0 | 5.4 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | 5.0 | .0 | .3 | .5 | .6 | .8 | 1.1 |
Account Receivables, % | 0 | 0 | 0 | 2801.01 | 0 | 20 | 20 | 20 | 20 | 20 |
Inventories | .0 | 6.8 | .9 | 22.5 | .0 | 1.0 | 1.4 | 1.8 | 2.4 | 3.2 |
Inventories, % | 0 | 3393.95 | 106.54 | 12626.69 | 0 | 60 | 60 | 60 | 60 | 60 |
Accounts Payable | .9 | .3 | .6 | .7 | 1.3 | 1.6 | 2.1 | 2.9 | 3.8 | 5.1 |
Accounts Payable, % | 513.58 | 139.85 | 73.45 | 400.83 | 104.67 | 94.69 | 94.69 | 94.69 | 94.69 | 94.69 |
Capital Expenditure | -2.4 | -.1 | -.1 | -3.2 | -13.8 | -1.3 | -1.7 | -2.3 | -3.0 | -4.0 |
Capital Expenditure, % | -1356.3 | -64.82 | -9.1 | -1790.65 | -1084.32 | -74.79 | -74.79 | -74.79 | -74.79 | -74.79 |
Tax Rate, % | 12.96 | 12.96 | 12.96 | 12.96 | 12.96 | 12.96 | 12.96 | 12.96 | 12.96 | 12.96 |
EBITAT | -5.5 | -5.5 | -24.4 | -69.7 | 10.6 | -1.0 | -1.3 | -1.7 | -2.3 | -3.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -5.5 | -11.9 | -16.9 | -95.7 | 27.8 | -1.6 | -.6 | -.8 | -1.1 | -1.5 |
WACC, % | 14.01 | 14.01 | 13.63 | 14.01 | 13.75 | 13.88 | 13.88 | 13.88 | 13.88 | 13.88 |
PV UFCF | ||||||||||
SUM PV UFCF | -3.9 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -1 | |||||||||
Terminal Value | -13 | |||||||||
Present Terminal Value | -7 | |||||||||
Enterprise Value | -10 | |||||||||
Net Debt | 7 | |||||||||
Equity Value | -18 | |||||||||
Diluted Shares Outstanding, MM | 105 | |||||||||
Equity Value Per Share | -0.17 |
What You Will Get
- Comprehensive LODE Financials: Access to both historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures to fit your analysis.
- Dynamic Calculations: Intrinsic value and NPV are computed in real-time.
- Scenario Testing: Evaluate various scenarios to assess Comstock Inc.'s future performance.
- User-Friendly Design: Designed for industry professionals while remaining approachable for newcomers.
Key Features
- Comprehensive Data: Access Comstock Inc.'s (LODE) historical financial reports and projected forecasts.
- Customizable Parameters: Adjust WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Analysis: Watch the intrinsic value of Comstock Inc. (LODE) update instantly.
- Intuitive Visualizations: Dashboard graphs showcase valuation results and essential metrics.
- Designed for Precision: A reliable tool tailored for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review Comstock Inc.'s pre-filled financial data and forecasts.
- Step 3: Modify key inputs like revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Watch the DCF model update instantly as you adjust assumptions.
- Step 5: Analyze the outputs and utilize the results for investment decisions regarding Comstock Inc. (LODE).
Why Choose This Calculator for Comstock Inc. (LODE)?
- Designed for Experts: A sophisticated tool tailored for investors, analysts, and financial advisors.
- Accurate Data: Comstock Inc.'s historical and projected financials are preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly: Detailed instructions lead you step-by-step through the calculation process.
Who Should Use This Product?
- Investors: Evaluate Comstock Inc.’s (LODE) fair value to inform your investment choices.
- CFOs: Utilize a sophisticated DCF model for accurate financial reporting and analysis.
- Consultants: Easily customize the template for client valuation reports.
- Entrepreneurs: Discover financial modeling techniques employed by leading companies.
- Educators: Implement it as a resource to teach valuation methods effectively.
What the Template Contains
- Preloaded LODE 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.