Rent the Runway, Inc. (RENT) DCF Valuation
- ✓ Fully Editable: Tailor To Your Needs In Excel Or Sheets
- ✓ Professional Design: Trusted, Industry-Standard Templates
- ✓ Pre-Built For Quick And Efficient Use
- ✓ No Expertise Is Needed; Easy To Follow
Rent the Runway, Inc. (RENT) Bundle
Save time and improve precision with our (RENT) DCF Calculator! Equipped with real Rent the Runway data and customizable assumptions, this tool enables you to forecast, analyze, and value Rent the Runway, Inc. like a seasoned investor.
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.