|
B. Riley Financial, Inc. (RILY) DCF Valuation
US | Financial Services | Financial - Conglomerates | NASDAQ
|
- ✓ Entièrement Modifiable: Adapté À Vos Besoins Dans Excel Ou Sheets
- ✓ Conception Professionnelle: Modèles Fiables Et Conformes Aux Normes Du Secteur
- ✓ Pré-Construits Pour Une Utilisation Rapide Et Efficace
- ✓ Aucune Expertise N'Est Requise; Facile À Suivre
B. Riley Financial, Inc. (RILY) Bundle
Whether you’re an investor or an analyst, this (RILY) DCF Calculator is your go-to tool for accurate valuation. Preloaded with real data from B. Riley Financial, Inc., you can easily adjust forecasts and observe the effects in real-time.
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 | 652.1 | 902.7 | 1,740.6 | 1,080.7 | 1,643.6 | 2,241.1 | 3,055.9 | 4,166.9 | 5,681.8 | 7,747.4 |
| Revenue Growth, % | 0 | 38.43 | 92.81 | -37.91 | 52.09 | 36.36 | 36.36 | 36.36 | 36.36 | 36.36 |
| EBITDA | 137.4 | 378.8 | 709.1 | -74.7 | 102.2 | 462.1 | 630.0 | 859.1 | 1,171.4 | 1,597.3 |
| EBITDA, % | 21.07 | 41.97 | 40.74 | -6.91 | 6.22 | 20.62 | 20.62 | 20.62 | 20.62 | 20.62 |
| Depreciation | 533.7 | 565.3 | 1,027.6 | 1,048.7 | 49.6 | 1,360.7 | 1,855.3 | 2,529.8 | 3,449.6 | 4,703.7 |
| Depreciation, % | 81.85 | 62.62 | 59.04 | 97.04 | 3.02 | 60.71 | 60.71 | 60.71 | 60.71 | 60.71 |
| EBIT | -396.3 | -186.5 | -318.5 | -1,123.4 | 52.6 | -880.9 | -1,201.1 | -1,637.8 | -2,233.2 | -3,045.1 |
| EBIT, % | -60.77 | -20.66 | -18.3 | -103.95 | 3.2 | -39.31 | -39.31 | -39.31 | -39.31 | -39.31 |
| Total Cash | 104.3 | 103.6 | 278.9 | 268.6 | 232.0 | 369.6 | 504.0 | 687.2 | 937.1 | 1,277.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 329.5 | 46.5 | 121.9 | 265.3 | 751.8 | 596.0 | 812.7 | 1,108.2 | 1,511.1 | 2,060.4 |
| Account Receivables, % | 50.52 | 5.15 | 7 | 24.55 | 45.74 | 26.59 | 26.59 | 26.59 | 26.59 | 26.59 |
| Inventories | 27.8 | 1.4 | .9 | 101.7 | 110.5 | 92.4 | 126.0 | 171.7 | 234.2 | 319.3 |
| Inventories, % | 4.27 | 0.15896 | 0.05325869 | 9.41 | 6.72 | 4.12 | 4.12 | 4.12 | 4.12 | 4.12 |
| Accounts Payable | 4.5 | 2.7 | 6.3 | 81.4 | 44.6 | 52.0 | 70.9 | 96.6 | 131.7 | 179.6 |
| Accounts Payable, % | 0.68654 | 0.30153 | 0.36345 | 7.53 | 2.71 | 2.32 | 2.32 | 2.32 | 2.32 | 2.32 |
| Capital Expenditure | -3.5 | -2.0 | -.7 | -3.9 | -7.7 | -7.3 | -9.9 | -13.6 | -18.5 | -25.2 |
| Capital Expenditure, % | -0.53074 | -0.22654 | -0.03883805 | -0.36255 | -0.46915 | -0.32556 | -0.32556 | -0.32556 | -0.32556 | -0.32556 |
| Tax Rate, % | 29.8 | 29.8 | 29.8 | 29.8 | 29.8 | 29.8 | 29.8 | 29.8 | 29.8 | 29.8 |
| EBITAT | -277.4 | -136.9 | -230.6 | -798.0 | 36.9 | -629.0 | -857.7 | -1,169.5 | -1,594.7 | -2,174.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -99.9 | 733.9 | 725.1 | 77.7 | -453.3 | 905.7 | 756.3 | 1,031.3 | 1,406.2 | 1,917.4 |
| WACC, % | 5.6 | 5.84 | 5.77 | 5.67 | 5.61 | 5.7 | 5.7 | 5.7 | 5.7 | 5.7 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 4,987.3 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | 1,956 | |||||||||
| Terminal Value | 52,899 | |||||||||
| Present Terminal Value | 40,099 | |||||||||
| Enterprise Value | 45,086 | |||||||||
| Net Debt | 2,223 | |||||||||
| Equity Value | 42,863 | |||||||||
| Diluted Shares Outstanding, MM | 29 | |||||||||
| Equity Value Per Share | 1,464.66 |
What You Will Get
- Real B. Riley Financial Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures.
- Full Customization: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- Instant Valuation Updates: Automatic recalculations to analyze the impact of changes on B. Riley Financial’s fair value.
- Versatile Excel Template: Tailored for quick edits, scenario testing, and detailed projections.
- Time-Saving and Accurate: Skip building models from scratch while maintaining precision and flexibility.
Key Features
- 🔍 Real-Life RILY Financials: Pre-filled historical and projected data for B. Riley Financial, Inc. (RILY).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate B. Riley's intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize B. Riley's valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- 1. Access the Template: Download and open the Excel file containing B. Riley Financial, Inc.'s (RILY) curated data.
- 2. Adjust Assumptions: Modify essential inputs such as growth rates, WACC, and capital expenditures.
- 3. View Results Instantly: The DCF model automatically computes intrinsic value and NPV in real-time.
- 4. Explore Scenarios: Evaluate various forecasts to assess different valuation possibilities.
- 5. Present with Confidence: Deliver professional valuation analyses to enhance your decision-making process.
Why Choose This Calculator for B. Riley Financial, Inc. (RILY)?
- Accurate Data: Up-to-date B. Riley financials provide dependable valuation outcomes.
- Customizable: Modify essential variables such as growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Built-in calculations save you from starting from the ground up.
- Professional-Grade Tool: Tailored for investors, analysts, and financial consultants.
- User-Friendly: Streamlined design and clear instructions ensure accessibility for all users.
Who Should Use This Product?
- Finance Students: Master financial analysis techniques and practice with real-world data.
- Academics: Integrate advanced financial models into your teaching or research initiatives.
- Investors: Validate your investment hypotheses and evaluate valuation scenarios for B. Riley Financial, Inc. (RILY).
- Analysts: Enhance your productivity with a customizable financial modeling toolkit.
- Small Business Owners: Understand the analytical approaches used for evaluating companies like B. Riley Financial, Inc. (RILY).
What the Template Contains
- Preloaded RILY 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.