DouYu International Holdings Limited (DOYU) DCF Valuation

DouYu International Holdings Limited (DOYU) 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

DouYu International Holdings Limited (DOYU) Bundle

DCF model
Get Full Bundle:
$25 $15
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7
$12 $7

TOTAL:

Whether you're an investor or analyst, this (DOYU) DCF Calculator is your essential tool for accurate valuation. Equipped with real data from DouYu International Holdings Limited, you can 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 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
Account Receivables, % 2.91 2.17 2.49 2.04 2.49
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

  1. Step 1: Download the Excel file.
  2. Step 2: Review pre-entered DouYu International data (historical and projected).
  3. Step 3: Adjust key assumptions (yellow cells) based on your analysis.
  4. Step 4: View automatic recalculations for DouYu’s intrinsic value.
  5. 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.