|
Valoración de DCF de Atrenew Inc. (Rere)
CN | Consumer Cyclical | Specialty Retail | NYSE
|
- ✓ 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
ATRenew Inc. (RERE) Bundle
¡Simplifique la valoración de Atrenew Inc. (RERE) con esta calculadora DCF personalizable! Con el Real Atrenew Inc. (Rere) Financials y las entradas de pronóstico ajustables, puede probar escenarios y descubrir el valor razonable de Atrenew Inc. (RERE) en minutos.
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 | 538.7 | 665.7 | 1,066.0 | 1,352.3 | 1,776.5 | 2,406.9 | 3,260.9 | 4,418.0 | 5,985.6 | 8,109.5 |
| Revenue Growth, % | 0 | 23.56 | 60.15 | 26.85 | 31.37 | 35.48 | 35.48 | 35.48 | 35.48 | 35.48 |
| EBITDA | -66.6 | -17.6 | -71.4 | -296.2 | 26.4 | -202.8 | -274.7 | -372.2 | -504.2 | -683.1 |
| EBITDA, % | -12.35 | -2.65 | -6.7 | -21.9 | 1.48 | -8.42 | -8.42 | -8.42 | -8.42 | -8.42 |
| Depreciation | 32.2 | 49.4 | 51.2 | 55.5 | 45.7 | 119.8 | 162.3 | 219.8 | 297.8 | 403.5 |
| Depreciation, % | 5.97 | 7.43 | 4.8 | 4.11 | 2.57 | 4.98 | 4.98 | 4.98 | 4.98 | 4.98 |
| EBIT | -98.7 | -67.0 | -122.6 | -351.7 | -19.4 | -322.5 | -437.0 | -592.0 | -802.1 | -1,086.7 |
| EBIT, % | -18.32 | -10.07 | -11.5 | -26.01 | -1.09 | -13.4 | -13.4 | -13.4 | -13.4 | -13.4 |
| Total Cash | 73.5 | 139.2 | 255.8 | 340.6 | 327.4 | 491.8 | 666.3 | 902.7 | 1,223.0 | 1,657.0 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | .2 | 1.7 | 55.5 | 43.3 | 124.7 | 75.7 | 102.5 | 138.9 | 188.2 | 255.0 |
| Account Receivables, % | 0.03555571 | 0.25392 | 5.21 | 3.2 | 7.02 | 3.14 | 3.14 | 3.14 | 3.14 | 3.14 |
| Inventories | 9.0 | 24.3 | 65.6 | 59.4 | 139.4 | 114.1 | 154.6 | 209.4 | 283.7 | 384.4 |
| Inventories, % | 1.67 | 3.64 | 6.15 | 4.39 | 7.84 | 4.74 | 4.74 | 4.74 | 4.74 | 4.74 |
| Accounts Payable | 4.9 | 3.7 | 5.7 | 10.0 | 72.9 | 33.0 | 44.7 | 60.5 | 82.0 | 111.1 |
| Accounts Payable, % | 0.90899 | 0.5599 | 0.53097 | 0.74305 | 4.11 | 1.37 | 1.37 | 1.37 | 1.37 | 1.37 |
| Capital Expenditure | -14.2 | -5.2 | -10.1 | -8.4 | -11.7 | -27.1 | -36.8 | -49.8 | -67.5 | -91.4 |
| Capital Expenditure, % | -2.63 | -0.77887 | -0.95009 | -0.62276 | -0.65698 | -1.13 | -1.13 | -1.13 | -1.13 | -1.13 |
| Tax Rate, % | 21.4 | 21.4 | 21.4 | 21.4 | 21.4 | 21.4 | 21.4 | 21.4 | 21.4 | 21.4 |
| EBITAT | -94.7 | -60.8 | -104.1 | -336.5 | -15.2 | -287.6 | -389.6 | -527.8 | -715.1 | -968.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -80.9 | -34.5 | -156.3 | -266.6 | -79.7 | -160.6 | -319.7 | -433.2 | -586.9 | -795.1 |
| WACC, % | 5.32 | 5.3 | 5.28 | 5.31 | 5.26 | 5.29 | 5.29 | 5.29 | 5.29 | 5.29 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -1,903.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -811 | |||||||||
| Terminal Value | -24,620 | |||||||||
| Present Terminal Value | -19,022 | |||||||||
| Enterprise Value | -20,926 | |||||||||
| Net Debt | -215 | |||||||||
| Equity Value | -20,710 | |||||||||
| Diluted Shares Outstanding, MM | 243 | |||||||||
| Equity Value Per Share | -85.14 |
What You Will Receive
- Comprehensive Financial Model: ATRenew Inc.'s (RERE) actual figures provide an accurate DCF valuation.
- Complete Forecast Control: Modify revenue growth rates, profit margins, WACC, and other essential factors.
- Real-Time Calculations: Automatic updates allow you to view results instantly as adjustments are made.
- Professional-Grade Template: A polished Excel document crafted for high-quality valuation analysis.
- Flexible and Reusable: Designed for adaptability, making it easy to use for in-depth forecasts repeatedly.
Key Features
- 🔍 Real-Life RERE Financials: Pre-filled historical and projected data for ATRenew Inc. (RERE).
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate ATRenew’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize ATRenew’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Download: Obtain the pre-prepared Excel file featuring ATRenew Inc.'s (RERE) financial data.
- Customize: Modify projections, such as revenue growth, EBITDA %, and WACC.
- Update Automatically: The intrinsic value and NPV calculations refresh in real-time.
- Test Scenarios: Generate various forecasts and instantly compare results.
- Make Decisions: Leverage the valuation outcomes to inform your investment strategy.
Why Choose ATRenew Inc. (RERE) Calculator?
- Save Time: Skip the hassle of building a model from the ground up – it's ready for immediate use.
- Enhance Accuracy: Dependable financial data and calculations minimize valuation errors.
- Completely Customizable: Adjust the model to align with your specific assumptions and forecasts.
- User-Friendly: Intuitive charts and outputs simplify result analysis.
- Endorsed by Professionals: Crafted for experts who prioritize both precision and functionality.
Who Should Use This Product?
- Investors: Accurately estimate ATRenew Inc.'s (RERE) fair value before making investment decisions.
- CFOs: Leverage a professional-grade DCF model for financial reporting and analysis related to ATRenew Inc. (RERE).
- Consultants: Quickly adapt the template for valuation reports tailored to ATRenew Inc. (RERE) for clients.
- Entrepreneurs: Gain insights into financial modeling practices used by industry leaders, including ATRenew Inc. (RERE).
- Educators: Use it as a teaching tool to demonstrate valuation methodologies applicable to ATRenew Inc. (RERE).
What the Template Contains
- Operating and Balance Sheet Data: Pre-filled ATRenew Inc. (RERE) historical data and forecasts, including revenue, EBITDA, EBIT, and capital expenditures.
- WACC Calculation: A dedicated sheet for Weighted Average Cost of Capital (WACC), encompassing parameters like Beta, risk-free rate, and share price.
- DCF Valuation (Unlevered and Levered): Editable Discounted Cash Flow models illustrating intrinsic value with comprehensive calculations.
- Financial Statements: Pre-loaded financial statements (annual and quarterly) to facilitate analysis.
- Key Ratios: Includes profitability, leverage, and efficiency ratios for ATRenew Inc. (RERE).
- Dashboard and Charts: Visual summary of valuation outputs and assumptions to simplify results analysis.