The RealReal, Inc. (REAL) DCF Valuation

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

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

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
Account Receivables, % 2.45 2.42 1.66 2.02 3.14
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.