Bilibili Inc. (BILI) DCF Valuation
- ✓ 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
Bilibili Inc. (BILI) Bundle
Whether you're an investor or an analyst, this [BILI] DCF Calculator is your go-to tool for accurate valuation. Loaded with real data from Bilibili Inc., you can easily adjust forecasts and observe the effects in real-time.
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 | 928.6 | 1,644.0 | 2,655.8 | 3,000.4 | 3,086.6 | 4,278.2 | 5,929.8 | 8,219.1 | 11,392.1 | 15,790.1 |
| Revenue Growth, % | 0 | 77.03 | 61.54 | 12.98 | 2.87 | 38.61 | 38.61 | 38.61 | 38.61 | 38.61 |
| EBITDA | -54.5 | -147.2 | -541.8 | -688.0 | -228.6 | -560.9 | -777.5 | -1,077.6 | -1,493.6 | -2,070.3 |
| EBITDA, % | -5.87 | -8.95 | -20.4 | -22.93 | -7.41 | -13.11 | -13.11 | -13.11 | -13.11 | -13.11 |
| Depreciation | 160.0 | 249.1 | 356.7 | 488.6 | 397.3 | 641.5 | 889.1 | 1,232.4 | 1,708.2 | 2,367.6 |
| Depreciation, % | 17.23 | 15.15 | 13.43 | 16.28 | 12.87 | 14.99 | 14.99 | 14.99 | 14.99 | 14.99 |
| EBIT | -214.5 | -396.2 | -898.5 | -1,176.5 | -625.9 | -1,202.4 | -1,666.6 | -2,310.0 | -3,201.8 | -4,437.9 |
| EBIT, % | -23.1 | -24.1 | -33.83 | -39.21 | -20.28 | -28.11 | -28.11 | -28.11 | -28.11 | -28.11 |
| Total Cash | 1,105.4 | 1,747.6 | 4,139.9 | 2,680.5 | 2,060.6 | 3,902.5 | 5,409.1 | 7,497.4 | 10,391.8 | 14,403.7 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 150.5 | 193.5 | 480.0 | 415.0 | 343.4 | 607.5 | 842.1 | 1,167.2 | 1,617.7 | 2,242.3 |
| Account Receivables, % | 16.2 | 11.77 | 18.07 | 13.83 | 11.12 | 14.2 | 14.2 | 14.2 | 14.2 | 14.2 |
| Inventories | 9.6 | 21.9 | 62.4 | 59.9 | 25.6 | 64.5 | 89.4 | 124.0 | 171.8 | 238.2 |
| Inventories, % | 1.03 | 1.33 | 2.35 | 2 | 0.82785 | 1.51 | 1.51 | 1.51 | 1.51 | 1.51 |
| Accounts Payable | 264.4 | 429.9 | 616.7 | 588.0 | 636.2 | 1,010.1 | 1,400.0 | 1,940.5 | 2,689.7 | 3,728.1 |
| Accounts Payable, % | 28.47 | 26.15 | 23.22 | 19.6 | 20.61 | 23.61 | 23.61 | 23.61 | 23.61 | 23.61 |
| Capital Expenditure | -214.4 | -306.8 | -505.2 | -375.2 | -182.2 | -677.5 | -939.0 | -1,301.5 | -1,804.0 | -2,500.5 |
| Capital Expenditure, % | -23.09 | -18.66 | -19.02 | -12.5 | -5.9 | -15.84 | -15.84 | -15.84 | -15.84 | -15.84 |
| Tax Rate, % | -1.89 | -1.89 | -1.89 | -1.89 | -1.89 | -1.89 | -1.89 | -1.89 | -1.89 | -1.89 |
| EBITAT | -220.6 | -403.3 | -911.3 | -1,193.1 | -637.7 | -1,202.4 | -1,666.6 | -2,310.0 | -3,201.8 | -4,437.9 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | -170.6 | -350.9 | -1,199.9 | -1,040.8 | -268.5 | -1,167.6 | -1,586.0 | -2,198.3 | -3,046.9 | -4,223.2 |
| WACC, % | 8.02 | 8.02 | 8.02 | 8.02 | 8.02 | 8.02 | 8.02 | 8.02 | 8.02 | 8.02 |
| PV UFCF | ||||||||||
| SUM PV UFCF | -9,292.7 | |||||||||
| Long Term Growth Rate, % | 2.00 | |||||||||
| Free cash flow (T + 1) | -4,308 | |||||||||
| Terminal Value | -71,513 | |||||||||
| Present Terminal Value | -48,617 | |||||||||
| Enterprise Value | -57,910 | |||||||||
| Net Debt | 62 | |||||||||
| Equity Value | -57,972 | |||||||||
| Diluted Shares Outstanding, MM | 413 | |||||||||
| Equity Value Per Share | -140.30 |
What You Will Get
- Real BILI Financials: Access to historical and projected data for precise valuation.
- Customizable Inputs: Adjust WACC, tax rates, revenue growth, and capital expenditures as needed.
- Dynamic Calculations: Intrinsic value and NPV are computed automatically.
- Scenario Analysis: Evaluate various scenarios to assess Bilibili’s future performance.
- User-Friendly Interface: Designed for professionals while remaining accessible to newcomers.
Key Features
- Comprehensive DCF Calculator: Offers detailed unlevered and levered DCF valuation models tailored for Bilibili Inc. (BILI).
- WACC Calculator: Features a pre-built Weighted Average Cost of Capital sheet with adjustable inputs specific to Bilibili Inc. (BILI).
- Customizable Forecast Assumptions: Easily modify growth rates, capital expenditures, and discount rates to suit your analysis of Bilibili Inc. (BILI).
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios for Bilibili Inc. (BILI).
- Visual Dashboard and Charts: Present visual outputs that summarize key valuation metrics for straightforward analysis of Bilibili Inc. (BILI).
How It Works
- Download: Obtain the pre-formatted Excel file containing Bilibili Inc.'s (BILI) financial data.
- Customize: Modify projections, including user growth, revenue percentages, and discount rates.
- Update Automatically: The intrinsic value and net present value calculations refresh in real-time.
- Test Scenarios: Develop various forecasts and analyze results instantly.
- Make Decisions: Leverage the valuation insights to inform your investment approach.
Why Choose This Calculator for Bilibili Inc. (BILI)?
- All-in-One Solution: Features DCF, WACC, and financial ratio analyses tailored for Bilibili Inc.
- Flexible Inputs: Modify the highlighted cells to explore different financial scenarios for Bilibili Inc.
- In-Depth Analysis: Automatically computes Bilibili’s intrinsic value and Net Present Value.
- Preloaded Information: Historical and projected data provide reliable starting points for analysis.
- High Standards: Perfect for financial analysts, investors, and consultants focusing on Bilibili Inc.
Who Should Use This Product?
- Investors: Assess Bilibili Inc.'s (BILI) fair value to inform investment choices.
- CFOs: Utilize a robust DCF model for accurate financial reporting and analysis.
- Consultants: Easily customize the template for client valuation reports.
- Entrepreneurs: Discover financial modeling techniques employed by leading tech companies.
- Educators: Implement it as a resource to teach valuation methods effectively.
What the Template Contains
- Pre-Filled DCF Model: Bilibili Inc.’s (BILI) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate Bilibili Inc.’s (BILI) 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.