The RealReal, Inc. (REAL) DCF Valuation
- ✓ Totalmente Editável: Adapte-Se Às Suas Necessidades No Excel Ou Planilhas
- ✓ Design Profissional: Modelos Confiáveis E Padrão Da Indústria
- ✓ Pré-Construídos Para Uso Rápido E Eficiente
- ✓ Não É Necessária Experiência; Fácil De Seguir
The RealReal, Inc. (REAL) Bundle
Simplify The RealReal, Inc. (REAL) valuation with this customizable DCF Calculator! Featuring real The RealReal, Inc. (REAL) financials and adjustable forecast inputs, you can test scenarios and uncover The RealReal, Inc. (REAL) fair value in minutes.
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 | 318.0 | 298.3 | 467.7 | 603.5 | 549.3 | 646.3 | 760.5 | 894.8 | 1,052.8 | 1,238.7 |
Revenue Growth, % | 0 | -6.22 | 56.8 | 29.04 | -8.98 | 17.66 | 17.66 | 17.66 | 17.66 | 17.66 |
EBITDA | -84.2 | -135.6 | -171.6 | -138.5 | -109.0 | -195.7 | -230.3 | -271.0 | -318.8 | -375.1 |
EBITDA, % | -26.48 | -45.45 | -36.68 | -22.95 | -19.85 | -30.28 | -30.28 | -30.28 | -30.28 | -30.28 |
Depreciation | 13.4 | 34.9 | 43.0 | 47.3 | 31.7 | 50.0 | 58.9 | 69.3 | 81.5 | 95.9 |
Depreciation, % | 4.22 | 11.7 | 9.19 | 7.83 | 5.77 | 7.74 | 7.74 | 7.74 | 7.74 | 7.74 |
EBIT | -97.6 | -170.5 | -214.5 | -185.8 | -140.7 | -245.8 | -289.2 | -340.2 | -400.3 | -471.0 |
EBIT, % | -30.69 | -57.15 | -45.87 | -30.79 | -25.62 | -38.02 | -38.02 | -38.02 | -38.02 | -38.02 |
Total Cash | 363.3 | 354.9 | 418.2 | 293.8 | 175.7 | 478.4 | 562.9 | 662.3 | 779.2 | 916.9 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 7.8 | 7.2 | 7.8 | 12.2 | 17.2 | 15.1 | 17.8 | 20.9 | 24.6 | 28.9 |
Account Receivables, % | 2.45 | 2.42 | 1.66 | 2.02 | 3.14 | 2.34 | 2.34 | 2.34 | 2.34 | 2.34 |
Inventories | 23.6 | 42.3 | 71.0 | 43.0 | 22.2 | 62.0 | 72.9 | 85.8 | 101.0 | 118.8 |
Inventories, % | 7.42 | 14.19 | 15.18 | 7.12 | 4.05 | 9.59 | 9.59 | 9.59 | 9.59 | 9.59 |
Accounts Payable | 11.2 | 14.3 | 4.5 | 11.9 | 9.0 | 16.7 | 19.6 | 23.1 | 27.1 | 31.9 |
Accounts Payable, % | 3.51 | 4.81 | 0.96281 | 1.97 | 1.63 | 2.58 | 2.58 | 2.58 | 2.58 | 2.58 |
Capital Expenditure | -34.0 | -28.6 | -47.4 | -36.9 | -42.1 | -57.2 | -67.2 | -79.1 | -93.1 | -109.5 |
Capital Expenditure, % | -10.7 | -9.58 | -10.14 | -6.12 | -7.67 | -8.84 | -8.84 | -8.84 | -8.84 | -8.84 |
Tax Rate, % | -0.16826 | -0.16826 | -0.16826 | -0.16826 | -0.16826 | -0.16826 | -0.16826 | -0.16826 | -0.16826 | -0.16826 |
EBITAT | -97.8 | -170.6 | -214.6 | -186.0 | -141.0 | -245.8 | -289.2 | -340.2 | -400.3 | -471.0 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -138.7 | -179.2 | -258.1 | -144.6 | -138.7 | -282.8 | -308.2 | -362.6 | -426.7 | -502.0 |
WACC, % | 13.13 | 13.13 | 13.13 | 13.13 | 13.13 | 13.13 | 13.13 | 13.13 | 13.13 | 13.13 |
PV UFCF | ||||||||||
SUM PV UFCF | -1,272.7 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -512 | |||||||||
Terminal Value | -4,601 | |||||||||
Present Terminal Value | -2,483 | |||||||||
Enterprise Value | -3,756 | |||||||||
Net Debt | 402 | |||||||||
Equity Value | -4,158 | |||||||||
Diluted Shares Outstanding, MM | 102 | |||||||||
Equity Value Per Share | -40.84 |
What You Will Get
- Authentic The RealReal Data: Preloaded financials – from revenue to EBIT – based on actual and projected figures for The RealReal, Inc. (REAL).
- Comprehensive Customization: Modify all key parameters (yellow cells) such as WACC, growth %, and tax rates to fit your analysis.
- Real-Time Valuation Updates: Automatic recalculations to assess the impact of changes on The RealReal's fair value.
- Flexible Excel Template: Designed for quick adjustments, scenario testing, and in-depth forecasts.
- Efficient and Precise: Avoid the hassle of building models from the ground up while ensuring accuracy and adaptability.
Key Features
- 🔍 Real-Life REAL Financials: Pre-filled historical and projected data for The RealReal, Inc. (REAL).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate The RealReal’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize The RealReal’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the prebuilt Excel template with The RealReal’s data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including The RealReal’s intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose This Calculator for The RealReal, Inc. (REAL)?
- Accurate Data: Utilizes real financials from The RealReal, ensuring trustworthy valuation outcomes.
- Customizable: Tailor essential parameters like growth rates, WACC, and tax rates to align with your forecasts.
- Time-Saving: Pre-configured calculations save you the hassle of starting from the ground up.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants focused on The RealReal, Inc. (REAL).
- User-Friendly: Designed with an intuitive interface and clear instructions for users of all levels.
Who Should Use This Product?
- Fashion Enthusiasts: Discover the value of luxury items and understand market trends.
- Students: Explore concepts of sustainability and resale in the fashion industry.
- Investors: Analyze the growth potential and valuation of The RealReal, Inc. (REAL).
- Retail Analysts: Utilize detailed reports and insights to enhance your market analysis.
- Small Business Owners: Learn how to effectively price and market pre-owned luxury goods.
What the Template Contains
- Historical Data: Includes The RealReal's past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate The RealReal'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 The RealReal's financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.