|
Lion Group Holding Ltd. (LGHL) DCF Valuation
SG | 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
Lion Group Holding Ltd. (LGHL) Bundle
Looking to determine the intrinsic value of Lion Group Holding Ltd.? Our (LGHL) DCF Calculator integrates real-world data with extensive customization features, allowing you to adjust forecasts and enhance your investment strategies.
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 | 18.5 | 10.2 | 27.1 | -2.5 | 19.9 | 12.7 | 8.1 | 5.2 | 3.3 | 2.1 |
| Revenue Growth, % | 0 | -44.78 | 164.5 | -109.17 | -902.74 | -36.2 | -36.2 | -36.2 | -36.2 | -36.2 |
| EBITDA | 9.1 | -2.4 | 2.1 | -30.1 | -1.1 | 3.3 | 2.1 | 1.3 | .8 | .5 |
| EBITDA, % | 48.94 | -22.98 | 7.88 | 1213.68 | -5.27 | 25.71 | 25.71 | 25.71 | 25.71 | 25.71 |
| Depreciation | .1 | .0 | 1.3 | 2.7 | 2.4 | -2.1 | -1.3 | -.9 | -.5 | -.3 |
| Depreciation, % | 0.28532 | 0.39643 | 4.79 | -108.52 | 11.85 | -16.54 | -16.54 | -16.54 | -16.54 | -16.54 |
| EBIT | 9.0 | -2.4 | .8 | -32.8 | -3.4 | 2.8 | 1.8 | 1.2 | .7 | .5 |
| EBIT, % | 48.65 | -23.37 | 3.09 | 1322.2 | -17.12 | 22.25 | 22.25 | 22.25 | 22.25 | 22.25 |
| Total Cash | 6.6 | 3.4 | 31.0 | 22.3 | 33.5 | 4.3 | 2.7 | 1.8 | 1.1 | .7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 3.4 | .7 | .1 | .5 | 13.9 | 1.9 | 1.2 | .8 | .5 | .3 |
| Account Receivables, % | 18.41 | 7.08 | 0.24891 | -21.53 | 69.86 | 14.81 | 14.81 | 14.81 | 14.81 | 14.81 |
| Inventories | 15.1 | -11.1 | -103.9 | -52.1 | .0 | -.5 | -.3 | -.2 | -.1 | -.1 |
| Inventories, % | 81.33 | -108.92 | -384.01 | 2098.96 | 0 | -3.73 | -3.73 | -3.73 | -3.73 | -3.73 |
| Accounts Payable | 3.9 | 9.1 | 89.1 | 48.8 | 37.6 | 5.3 | 3.4 | 2.2 | 1.4 | .9 |
| Accounts Payable, % | 20.96 | 88.63 | 329.15 | -1965.47 | 188.72 | 41.92 | 41.92 | 41.92 | 41.92 | 41.92 |
| Capital Expenditure | .0 | .0 | -10.2 | .0 | -7.9 | -2.0 | -1.3 | -.8 | -.5 | -.3 |
| Capital Expenditure, % | -0.13328 | -0.05067382 | -37.82 | 0 | -39.39 | -15.48 | -15.48 | -15.48 | -15.48 | -15.48 |
| Tax Rate, % | 9.73 | 9.73 | 9.73 | 9.73 | 9.73 | 9.73 | 9.73 | 9.73 | 9.73 | 9.73 |
| EBITAT | 8.9 | -2.4 | .9 | -32.8 | -3.1 | 2.8 | 1.8 | 1.1 | .7 | .5 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -5.6 | 31.7 | 165.4 | -122.7 | -85.2 | -21.1 | -2.2 | -1.4 | -.9 | -.6 |
| WACC, % | 89.07 | 89.75 | 89.75 | 89.75 | 81.19 | 87.91 | 87.91 | 87.91 | 87.91 | 87.91 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -12.2 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -1 | |||||||||
| Terminal Value | -1 | |||||||||
| Present Terminal Value | 0 | |||||||||
| Enterprise Value | -12 | |||||||||
| Net Debt | -27 | |||||||||
| Equity Value | 14 | |||||||||
| Diluted Shares Outstanding, MM | 2 | |||||||||
| Equity Value Per Share | 5.93 |
What You Will Receive
- Customizable Excel Template: A complete Excel-based DCF Calculator featuring pre-filled financials for Lion Group Holding Ltd. (LGHL).
- Accurate Data: Access to historical figures and future projections (highlighted in the yellow cells).
- Adjustable Forecasts: Modify key assumptions such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect Lion Group Holding Ltd.'s (LGHL) valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for simplicity and ease of navigation, complete with step-by-step guidance.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for Lion Group Holding Ltd. (LGHL).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for precise calculations.
- Customizable Forecast Assumptions: Easily alter growth rates, capital expenditures, and discount rates to suit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for Lion Group Holding Ltd. (LGHL).
- Interactive Dashboard and Charts: Visual representations that summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the Excel file for Lion Group Holding Ltd. (LGHL).
- Step 2: Review LGHL’s pre-filled financial data and forecasts.
- Step 3: Modify key inputs such as revenue growth, WACC, and tax rates (highlighted cells).
- Step 4: Observe the DCF model update in real-time as you adjust your assumptions.
- Step 5: Analyze the outputs and leverage the results for your investment decisions.
Why Choose This Calculator for Lion Group Holding Ltd. (LGHL)?
- User-Friendly Interface: Perfect for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters effortlessly to suit your analytical needs.
- Real-Time Insights: Monitor immediate changes to Lion Group's valuation as you tweak inputs.
- Preloaded Data: Comes equipped with Lion Group's latest financial information for swift evaluations.
- Preferred by Experts: Widely utilized by investors and analysts for strategic decision-making.
Who Should Use This Product?
- Finance Students: Master valuation techniques and apply them to real-world data for Lion Group Holding Ltd. (LGHL).
- Academics: Enhance your curriculum or research with professional models relevant to Lion Group Holding Ltd. (LGHL).
- Investors: Validate your own assumptions and evaluate valuation outcomes for Lion Group Holding Ltd. (LGHL).
- Analysts: Optimize your analysis process with a customizable DCF model tailored for Lion Group Holding Ltd. (LGHL).
- Small Business Owners: Discover how major companies like Lion Group Holding Ltd. (LGHL) are assessed in the market.
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled Lion Group Holding Ltd. (LGHL) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), including parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models showing intrinsic value with detailed calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to support analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for Lion Group Holding Ltd. (LGHL).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to analyze results easily.