|
Rent the Runway, Inc. (alquiler) Valoración de DCF
US | Consumer Cyclical | Apparel - Retail | NASDAQ
|
- ✓ Completamente Editable: Adáptelo A Sus Necesidades En Excel O Sheets
- ✓ Diseño Profesional: Plantillas Confiables Y Estándares De La Industria
- ✓ Predeterminadas Para Un Uso Rápido Y Eficiente
- ✓ No Se Necesita Experiencia; Fáciles De Seguir
Rent the Runway, Inc. (RENT) Bundle
¡Ahorre tiempo y mejore la precisión con nuestra calculadora DCF (alquiler)! Equipado con el alquiler real de los datos de la pista y los supuestos personalizables, esta herramienta le permite pronosticar, analizar y valorar el alquiler de la pista, Inc. como un inversor experimentado.
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 | 256.9 | 157.5 | 203.3 | 296.4 | 298.2 | 325.6 | 355.6 | 388.3 | 424.0 | 463.0 |
Revenue Growth, % | 0 | -38.69 | 29.08 | 45.79 | 0.60729 | 9.2 | 9.2 | 9.2 | 9.2 | 9.2 |
EBITDA | -61.6 | -52.2 | -67.2 | -4.7 | 25.7 | -54.1 | -59.1 | -64.6 | -70.5 | -77.0 |
EBITDA, % | -23.98 | -33.14 | -33.05 | -1.59 | 8.62 | -16.63 | -16.63 | -16.63 | -16.63 | -16.63 |
Depreciation | 68.5 | 72.3 | 91.9 | 97.4 | 105.0 | 121.0 | 132.2 | 144.3 | 157.6 | 172.1 |
Depreciation, % | 26.66 | 45.9 | 45.2 | 32.86 | 35.21 | 37.17 | 37.17 | 37.17 | 37.17 | 37.17 |
EBIT | -130.1 | -124.5 | -159.1 | -102.1 | -79.3 | -175.2 | -191.3 | -208.9 | -228.1 | -249.1 |
EBIT, % | -50.64 | -79.05 | -78.26 | -34.45 | -26.59 | -53.8 | -53.8 | -53.8 | -53.8 | -53.8 |
Total Cash | 31.4 | 95.3 | 247.6 | 154.5 | 84.0 | 164.8 | 179.9 | 196.5 | 214.6 | 234.3 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables, % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Inventories | .0 | .0 | .0 | -.9 | .0 | -.2 | -.2 | -.2 | -.3 | -.3 |
Inventories, % | 0 | 0 | 0 | -0.30364 | 0 | -0.06072874 | -0.06072874 | -0.06072874 | -0.06072874 | -0.06072874 |
Accounts Payable | 12.7 | 7.2 | 15.9 | 12.4 | 5.8 | 15.3 | 16.7 | 18.2 | 19.9 | 21.7 |
Accounts Payable, % | 4.94 | 4.57 | 7.82 | 4.18 | 1.95 | 4.69 | 4.69 | 4.69 | 4.69 | 4.69 |
Capital Expenditure | -161.5 | -78.7 | -41.1 | -71.0 | -82.5 | -120.3 | -131.3 | -143.4 | -156.6 | -171.0 |
Capital Expenditure, % | -62.86 | -49.97 | -20.22 | -23.95 | -27.67 | -36.93 | -36.93 | -36.93 | -36.93 | -36.93 |
Tax Rate, % | -0.17699 | -0.17699 | -0.17699 | -0.17699 | -0.17699 | -0.17699 | -0.17699 | -0.17699 | -0.17699 | -0.17699 |
EBITAT | -129.9 | -124.5 | -158.9 | -102.0 | -79.4 | -175.0 | -191.1 | -208.7 | -227.9 | -248.9 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -210.2 | -136.4 | -99.4 | -78.2 | -64.4 | -164.6 | -188.9 | -206.2 | -225.2 | -245.9 |
WACC, % | 9.43 | 9.45 | 9.43 | 9.43 | 9.45 | 9.44 | 9.44 | 9.44 | 9.44 | 9.44 |
PV UFCF | ||||||||||
SUM PV UFCF | -779.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -251 | |||||||||
Terminal Value | -3,372 | |||||||||
Present Terminal Value | -2,148 | |||||||||
Enterprise Value | -2,927 | |||||||||
Net Debt | 273 | |||||||||
Equity Value | -3,200 | |||||||||
Diluted Shares Outstanding, MM | 3 | |||||||||
Equity Value Per Share | -936.05 |
What You Will Get
- Pre-Filled Financial Model: Rent the Runway’s actual data allows for accurate DCF valuation.
- Full Forecast Control: Modify revenue growth, margins, WACC, and other critical drivers.
- Instant Calculations: Automatic updates ensure immediate visibility of results as you make adjustments.
- Investor-Ready Template: A polished Excel file crafted for high-quality valuation.
- Customizable and Reusable: Designed for flexibility, enabling repeated use for in-depth forecasts.
Key Features
- Comprehensive Rental Management Tool: Streamlined platform for managing clothing and accessory rentals.
- Dynamic Pricing Calculator: Integrated tool for optimizing rental prices based on demand and inventory.
- Customizable Subscription Plans: Flexible options for users to tailor their rental experience.
- In-Depth Analytics Dashboard: Insights into customer behavior, rental trends, and inventory performance.
- User-Friendly Interface: Intuitive design for seamless navigation and enhanced user experience.
How It Works
- Download the Template: Gain immediate access to the Excel-based RENT DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, margins, and other variables.
- Instant Calculations: The model automatically recalculates Rent the Runway’s intrinsic value.
- Test Scenarios: Explore various assumptions to assess potential changes in valuation.
- Analyze and Decide: Leverage the results to inform your investment or financial strategy.
Why Choose This Calculator?
- Designed for Industry Experts: A sophisticated tool tailored for fashion analysts, investors, and consultants.
- Accurate Financial Insights: Rent the Runway’s historical and projected financial data preloaded for precision.
- Flexible Scenario Analysis: Effortlessly test various forecasts and assumptions.
- Comprehensive Outputs: Automatically computes intrinsic value, NPV, and essential financial metrics.
- User-Friendly Interface: Step-by-step guidance simplifies the entire calculation process.
Who Should Use This Product?
- Fashion Enthusiasts: Make informed choices about renting or purchasing from Rent the Runway, Inc. (RENT).
- Market Analysts: Enhance trend analysis with comprehensive data on rental fashion models.
- Stylists: Provide clients with curated fashion options and rental insights quickly and efficiently.
- Retail Business Owners: Gain insights into the rental market to inform your own business strategies.
- Students of Fashion Business: Explore industry practices and rental models using real-world case studies.
What the Template Contains
- Historical Data: Includes Rent the Runway’s past financials and baseline forecasts.
- DCF and Levered DCF Models: Detailed templates to calculate Rent the Runway’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 Rent the Runway’s financials.
- Interactive Dashboard: Visualize valuation results and projections dynamically.