RumbleON, Inc. (RMBL) DCF Valuation
- ✓ 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
RumbleON, Inc. (RMBL) Bundle
Explore RumbleON, Inc.'s (RMBL) financial outlook with our user-friendly DCF Calculator! Enter your projections for growth, margins, and expenses to calculate RumbleON, Inc.'s (RMBL) intrinsic value and inform your investment decisions.
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 | 840.6 | 416.4 | 934.7 | 1,793.4 | 1,366.4 | 1,768.1 | 2,287.8 | 2,960.4 | 3,830.7 | 4,956.8 |
Revenue Growth, % | 0 | -50.46 | 124.46 | 91.86 | -23.81 | 29.4 | 29.4 | 29.4 | 29.4 | 29.4 |
EBITDA | -36.2 | -16.2 | -8.9 | -230.4 | -55.9 | -92.3 | -119.4 | -154.5 | -199.9 | -258.6 |
EBITDA, % | -4.31 | -3.89 | -0.95022 | -12.85 | -4.09 | -5.22 | -5.22 | -5.22 | -5.22 | -5.22 |
Depreciation | 1.8 | 2.1 | 6.1 | 23.0 | 22.0 | 15.1 | 19.6 | 25.3 | 32.7 | 42.4 |
Depreciation, % | 0.21251 | 0.5146 | 0.65292 | 1.28 | 1.61 | 0.85452 | 0.85452 | 0.85452 | 0.85452 | 0.85452 |
EBIT | -38.0 | -18.4 | -15.0 | -253.4 | -77.9 | -107.4 | -138.9 | -179.8 | -232.6 | -301.0 |
EBIT, % | -4.52 | -4.41 | -1.6 | -14.13 | -5.7 | -6.07 | -6.07 | -6.07 | -6.07 | -6.07 |
Total Cash | .0 | 1.5 | 49.0 | 48.6 | 58.9 | 44.6 | 57.7 | 74.7 | 96.7 | 125.1 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 8.5 | 9.4 | 40.2 | 28.0 | 50.3 | 45.3 | 58.6 | 75.8 | 98.1 | 127.0 |
Account Receivables, % | 1.01 | 2.26 | 4.3 | 1.56 | 3.68 | 2.56 | 2.56 | 2.56 | 2.56 | 2.56 |
Inventories | 57.4 | 21.4 | 201.7 | 331.7 | 347.5 | 273.9 | 354.4 | 458.6 | 593.4 | 767.9 |
Inventories, % | 6.83 | 5.13 | 21.57 | 18.5 | 25.43 | 15.49 | 15.49 | 15.49 | 15.49 | 15.49 |
Accounts Payable | 8.7 | 7.3 | 10.0 | 13.7 | 7.1 | 18.2 | 23.6 | 30.5 | 39.5 | 51.1 |
Accounts Payable, % | 1.04 | 1.76 | 1.07 | 0.76393 | 0.51961 | 1.03 | 1.03 | 1.03 | 1.03 | 1.03 |
Capital Expenditure | -3.2 | -2.3 | -9.6 | -12.6 | -15.8 | -13.5 | -17.5 | -22.6 | -29.3 | -37.9 |
Capital Expenditure, % | -0.38132 | -0.55708 | -1.03 | -0.7037 | -1.16 | -0.76486 | -0.76486 | -0.76486 | -0.76486 | -0.76486 |
Tax Rate, % | -38.94 | -38.94 | -38.94 | -38.94 | -38.94 | -38.94 | -38.94 | -38.94 | -38.94 | -38.94 |
EBITAT | -44.0 | -23.2 | -4.6 | -198.3 | -108.2 | -87.9 | -113.7 | -147.1 | -190.4 | -246.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -102.6 | 10.3 | -216.5 | -302.2 | -146.7 | 3.4 | -200.1 | -259.0 | -335.1 | -433.6 |
WACC, % | 10.49 | 10.49 | 4.35 | 8.56 | 10.49 | 8.87 | 8.87 | 8.87 | 8.87 | 8.87 |
PV UFCF | ||||||||||
SUM PV UFCF | -888.3 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -442 | |||||||||
Terminal Value | -6,434 | |||||||||
Present Terminal Value | -4,206 | |||||||||
Enterprise Value | -5,094 | |||||||||
Net Debt | 713 | |||||||||
Equity Value | -5,807 | |||||||||
Diluted Shares Outstanding, MM | 18 | |||||||||
Equity Value Per Share | -327.33 |
What You Will Get
- Real RMBL Financial Data: Pre-filled with RumbleON’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See RumbleON’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Real-Time RMBL Data: Pre-filled with RumbleON's historical financials and future projections.
- Fully Customizable Inputs: Modify revenue growth, profit margins, WACC, tax rates, and capital expenditures.
- Dynamic Valuation Model: Automatic adjustments to Net Present Value (NPV) and intrinsic value based on your inputs.
- Scenario Testing: Develop multiple forecast scenarios to evaluate various valuation outcomes.
- User-Friendly Design: Intuitive, organized, and suitable for both professionals and novices.
How It Functions
- Download the Template: Gain immediate access to the Excel-based RMBL DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates RumbleON’s intrinsic value.
- Test Scenarios: Experiment with different assumptions to assess possible valuation shifts.
- Analyze and Decide: Utilize the findings to inform your investment or financial analysis.
Why Choose This Calculator for RumbleON, Inc. (RMBL)?
- Comprehensive Tool: Offers DCF, WACC, and financial ratio analyses all in one convenient platform.
- Customizable Inputs: Modify the yellow-highlighted cells to explore different financial scenarios.
- Detailed Insights: Automatically computes RumbleON's intrinsic value and Net Present Value.
- Preloaded Data: Access to historical and projected data for accurate analysis.
- Professional Quality: Perfect for financial analysts, investors, and business consultants focused on RumbleON, Inc. (RMBL).
Who Should Use This Product?
- Professional Investors: Develop comprehensive and trustworthy valuation models for RumbleON, Inc. (RMBL) portfolio analysis.
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within the organization.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in RumbleON, Inc. (RMBL).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Automotive Enthusiasts: Gain insights into how companies like RumbleON, Inc. (RMBL) are valued in the automotive market.
What the Template Contains
- Historical Data: Includes RumbleON, Inc.’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate RumbleON, Inc.’s intrinsic value.
- WACC Sheet: Pre-built calculations for Weighted Average Cost of Capital.
- Editable Inputs: Modify key drivers like growth rates, EBITDA %, and CAPEX assumptions.
- Quarterly and Annual Statements: A complete breakdown of RumbleON, Inc.’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.