Baozun Inc. (BZUN) 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
Baozun Inc. (BZUN) Bundle
Evaluate Baozun Inc.'s financial prospects like an expert! This (BZUN) DCF Calculator comes with pre-filled financial data and offers the flexibility to modify revenue growth, WACC, margins, and other critical assumptions to align with your predictions.
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 | 997.5 | 1,213.2 | 1,287.8 | 1,151.4 | 1,207.7 | 1,274.4 | 1,344.7 | 1,418.9 | 1,497.2 | 1,579.8 |
Revenue Growth, % | 0 | 21.62 | 6.15 | -10.6 | 4.9 | 5.52 | 5.52 | 5.52 | 5.52 | 5.52 |
EBITDA | 72.6 | 82.2 | 15.0 | -44.8 | 10.4 | 31.1 | 32.8 | 34.6 | 36.5 | 38.5 |
EBITDA, % | 7.28 | 6.78 | 1.17 | -3.89 | 0.86185 | 2.44 | 2.44 | 2.44 | 2.44 | 2.44 |
Depreciation | 16.5 | 20.8 | 28.4 | 26.9 | 34.5 | 27.4 | 28.9 | 30.5 | 32.2 | 34.0 |
Depreciation, % | 1.65 | 1.71 | 2.2 | 2.34 | 2.86 | 2.15 | 2.15 | 2.15 | 2.15 | 2.15 |
EBIT | 56.1 | 61.4 | -13.3 | -71.7 | -24.1 | 3.7 | 3.9 | 4.1 | 4.3 | 4.5 |
EBIT, % | 5.63 | 5.06 | -1.03 | -6.23 | -1.99 | 0.28689 | 0.28689 | 0.28689 | 0.28689 | 0.28689 |
Total Cash | 272.5 | 689.2 | 631.4 | 416.6 | 393.4 | 514.6 | 543.0 | 573.0 | 604.6 | 638.0 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 292.8 | 351.0 | 372.8 | 327.0 | 311.3 | 360.4 | 380.3 | 401.3 | 423.5 | 446.8 |
Account Receivables, % | 29.35 | 28.94 | 28.95 | 28.4 | 25.78 | 28.28 | 28.28 | 28.28 | 28.28 | 28.28 |
Inventories | 122.9 | 140.6 | 147.1 | 129.2 | 143.2 | 148.9 | 157.1 | 165.8 | 174.9 | 184.6 |
Inventories, % | 12.32 | 11.59 | 11.43 | 11.23 | 11.86 | 11.68 | 11.68 | 11.68 | 11.68 | 11.68 |
Accounts Payable | 149.1 | 57.8 | 67.7 | 65.1 | 77.2 | 94.3 | 99.5 | 105.0 | 110.8 | 116.9 |
Accounts Payable, % | 14.95 | 4.76 | 5.26 | 5.65 | 6.4 | 7.4 | 7.4 | 7.4 | 7.4 | 7.4 |
Capital Expenditure | -12.5 | -15.2 | -39.1 | -28.4 | -22.6 | -25.2 | -26.6 | -28.0 | -29.6 | -31.2 |
Capital Expenditure, % | -1.25 | -1.25 | -3.04 | -2.46 | -1.87 | -1.98 | -1.98 | -1.98 | -1.98 | -1.98 |
Tax Rate, % | -32.1 | -32.1 | -32.1 | -32.1 | -32.1 | -32.1 | -32.1 | -32.1 | -32.1 | -32.1 |
EBITAT | 45.3 | 47.7 | -18.1 | -75.0 | -31.8 | 3.4 | 3.5 | 3.7 | 3.9 | 4.2 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -217.3 | -114.0 | -47.3 | -15.4 | -6.1 | -32.1 | -17.0 | -17.9 | -18.9 | -20.0 |
WACC, % | 4.39 | 4.3 | 4.98 | 4.98 | 4.98 | 4.73 | 4.73 | 4.73 | 4.73 | 4.73 |
PV UFCF | ||||||||||
SUM PV UFCF | -93.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -20 | |||||||||
Terminal Value | -747 | |||||||||
Present Terminal Value | -593 | |||||||||
Enterprise Value | -687 | |||||||||
Net Debt | 83 | |||||||||
Equity Value | -770 | |||||||||
Diluted Shares Outstanding, MM | 60 | |||||||||
Equity Value Per Share | -12.93 |
What You Will Get
- Real BZUN Financial Data: Pre-filled with Baozun Inc.’s historical and projected data for precise analysis.
- Fully Editable Template: Modify key inputs like revenue growth, WACC, and EBITDA % with ease.
- Automatic Calculations: See Baozun Inc.’s intrinsic value update instantly based on your changes.
- Professional Valuation Tool: Designed for investors, analysts, and consultants seeking accurate DCF results.
- User-Friendly Design: Simple structure and clear instructions for all experience levels.
Key Features
- Comprehensive Data: Baozun Inc.'s historical financial statements and pre-filled projections.
- Customizable Parameters: Modify WACC, tax rates, revenue growth, and EBITDA margins as needed.
- Real-Time Insights: Observe Baozun Inc.'s intrinsic value update instantly.
- Intuitive Visualizations: Dashboard graphs showcase valuation outcomes and essential metrics.
- Designed for Precision: A reliable resource for analysts, investors, and finance professionals.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered Baozun Inc. (BZUN) data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for Baozun Inc. (BZUN)’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for Baozun Inc. (BZUN)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Inputs: Adjust parameters easily to suit your analysis needs.
- Real-Time Feedback: Observe immediate updates to Baozun’s valuation with input changes.
- Pre-Configured Data: Comes with Baozun’s latest financial metrics for swift evaluations.
- Relied Upon by Experts: Utilized by investors and analysts to guide strategic decisions.
Who Should Use This Product?
- Professional Investors: Develop comprehensive and accurate valuation models for portfolio assessment related to Baozun Inc. (BZUN).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights for clients interested in Baozun Inc. (BZUN).
- Students and Educators: Utilize real-world data to enhance learning and practice financial modeling techniques.
- Tech Enthusiasts: Gain insights into how e-commerce companies like Baozun Inc. (BZUN) are valued in the market.
What the Template Contains
- Pre-Filled DCF Model: Baozun Inc.’s (BZUN) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Baozun Inc.’s (BZUN) profitability, leverage, and efficiency.
- Editable Inputs: Change assumptions such as growth, margins, and CAPEX to fit your scenarios.
- Financial Statements: Annual and quarterly reports to support detailed analysis.
- Interactive Dashboard: Easily visualize key valuation metrics and results.