|
Douyu International Holdings Limited (Doyu) DCF Valoración de DCF
CN | Communication Services | Internet Content & Information | 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
DouYu International Holdings Limited (DOYU) Bundle
Ya sea que sea un inversor o analista, esta calculadora DCF (doyu) es su herramienta esencial para una valoración precisa. Equipado con datos reales de Douyu International Holdings Limited, puede ajustar las previsiones y observar los efectos en tiempo real.
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.9 | 1,315.6 | 1,255.7 | 973.9 | 757.7 | 724.9 | 693.4 | 663.3 | 634.6 | 607.0 |
Revenue Growth, % | 0 | 31.84 | -4.55 | -22.44 | -22.2 | -4.34 | -4.34 | -4.34 | -4.34 | -4.34 |
EBITDA | -5.7 | 32.7 | -76.7 | -15.1 | -7.3 | -9.7 | -9.3 | -8.9 | -8.5 | -8.1 |
EBITDA, % | -0.56985 | 2.48 | -6.11 | -1.55 | -0.96247 | -1.34 | -1.34 | -1.34 | -1.34 | -1.34 |
Depreciation | 12.3 | 15.2 | 12.2 | 12.0 | 13.3 | 9.2 | 8.8 | 8.4 | 8.0 | 7.7 |
Depreciation, % | 1.24 | 1.16 | 0.96813 | 1.23 | 1.75 | 1.27 | 1.27 | 1.27 | 1.27 | 1.27 |
EBIT | -18.0 | 17.5 | -88.9 | -27.0 | -20.6 | -18.9 | -18.1 | -17.3 | -16.6 | -15.8 |
EBIT, % | -1.81 | 1.33 | -7.08 | -2.78 | -2.71 | -2.61 | -2.61 | -2.61 | -2.61 | -2.61 |
Total Cash | 1,108.7 | 1,029.0 | 895.1 | 897.8 | 843.5 | 640.3 | 612.5 | 586.0 | 560.5 | 536.2 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 29.1 | 28.6 | 31.3 | 19.9 | 18.8 | 17.6 | 16.8 | 16.1 | 15.4 | 14.7 |
Account Receivables, % | 2.91 | 2.17 | 2.49 | 2.04 | 2.49 | 2.42 | 2.42 | 2.42 | 2.42 | 2.42 |
Inventories | 12.8 | 10.7 | 12.5 | 4.4 | .0 | 5.1 | 4.9 | 4.7 | 4.5 | 4.3 |
Inventories, % | 1.28 | 0.81372 | 0.99745 | 0.45188 | 0 | 0.70856 | 0.70856 | 0.70856 | 0.70856 | 0.70856 |
Accounts Payable | 121.9 | 135.1 | 112.9 | 91.4 | 73.2 | 73.3 | 70.1 | 67.0 | 64.1 | 61.3 |
Accounts Payable, % | 12.22 | 10.27 | 8.99 | 9.38 | 9.66 | 10.11 | 10.11 | 10.11 | 10.11 | 10.11 |
Capital Expenditure | -16.7 | -11.3 | -16.8 | -22.7 | -2.2 | -9.4 | -9.0 | -8.6 | -8.2 | -7.9 |
Capital Expenditure, % | -1.67 | -0.85769 | -1.34 | -2.33 | -0.29478 | -1.3 | -1.3 | -1.3 | -1.3 | -1.3 |
Tax Rate, % | 2.92 | 2.92 | 2.92 | 2.92 | 2.92 | 2.92 | 2.92 | 2.92 | 2.92 | 2.92 |
EBITAT | -158.2 | 33.3 | -49.8 | -27.7 | -20.0 | -17.1 | -16.4 | -15.7 | -15.0 | -14.4 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | -82.5 | 52.9 | -81.1 | -40.4 | -21.6 | -21.2 | -18.8 | -18.0 | -17.2 | -16.5 |
WACC, % | 8.8 | 8.8 | 8.78 | 8.8 | 8.8 | 8.8 | 8.8 | 8.8 | 8.8 | 8.8 |
PV UFCF | ||||||||||
SUM PV UFCF | -72.4 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | -17 | |||||||||
Terminal Value | -247 | |||||||||
Present Terminal Value | -162 | |||||||||
Enterprise Value | -234 | |||||||||
Net Debt | -605 | |||||||||
Equity Value | 371 | |||||||||
Diluted Shares Outstanding, MM | 32 | |||||||||
Equity Value Per Share | 11.60 |
What You Will Get
- Real DOYU Financial Data: Pre-filled with DouYu International'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 DouYu'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
- 🔍 Real-Life DOYU Financials: Pre-filled historical and projected data for DouYu International Holdings Limited.
- ✏️ Fully Customizable Inputs: Adjust all critical parameters (yellow cells) like WACC, growth %, and tax rates.
- 📊 Professional DCF Valuation: Built-in formulas calculate DouYu’s intrinsic value using the Discounted Cash Flow method.
- ⚡ Instant Results: Visualize DouYu’s valuation instantly after making changes.
- Scenario Analysis: Test and compare outcomes for various financial assumptions side-by-side.
How It Works
- Step 1: Download the Excel file.
- Step 2: Review pre-entered DouYu International data (historical and projected).
- Step 3: Adjust key assumptions (yellow cells) based on your analysis.
- Step 4: View automatic recalculations for DouYu’s intrinsic value.
- Step 5: Use the outputs for investment decisions or reporting.
Why Choose This Calculator for DouYu International Holdings Limited (DOYU)?
- Accurate Data: Up-to-date DouYu financials provide dependable valuation outcomes.
- Customizable: Tailor essential parameters like growth rates, WACC, and tax rates to fit your forecasts.
- Time-Saving: Ready-made calculations save you from starting from scratch.
- Professional-Grade Tool: Crafted for investors, analysts, and consultants in the industry.
- User-Friendly: Simple design and clear instructions make it accessible for all users.
Who Should Use This Product?
- Professional Investors: Develop comprehensive valuation models for analyzing investments in DouYu International Holdings Limited (DOYU).
- Corporate Finance Teams: Evaluate valuation scenarios to inform strategic decisions within their organizations.
- Consultants and Advisors: Deliver precise valuation insights to clients interested in DouYu International Holdings Limited (DOYU).
- Students and Educators: Utilize real-world data to enhance learning and practice in financial modeling.
- Gaming Industry Enthusiasts: Gain insights into how companies like DouYu International Holdings Limited (DOYU) are valued in the competitive gaming market.
What the Template Contains
- Pre-Filled DCF Model: DouYu International Holdings Limited’s (DOYU) financial data preloaded for immediate use.
- WACC Calculator: Detailed calculations for Weighted Average Cost of Capital.
- Financial Ratios: Evaluate DouYu’s 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.