|
Huya Inc. (Huya) DCF Valoración
CN | Communication Services | Entertainment | 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
HUYA Inc. (HUYA) Bundle
¡Agilice su análisis y mejore la precisión con nuestra calculadora DCF (Huya)! Equipado con datos reales de Huya Inc. y suposiciones personalizables, esta herramienta le permite pronosticar, analizar y valorar Huya como un inversor experimentado.
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 | 1,147.6 | 1,495.6 | 1,555.5 | 1,263.5 | 958.5 | 1,152.1 | 1,384.9 | 1,664.7 | 2,001.0 | 2,405.3 |
| Revenue Growth, % | 0 | 30.33 | 4 | -18.77 | -24.14 | 20.2 | 20.2 | 20.2 | 20.2 | 20.2 |
| EBITDA | 35.8 | 99.3 | 13.0 | -81.2 | -41.5 | -.4 | -.5 | -.5 | -.7 | -.8 |
| EBITDA, % | 3.12 | 6.64 | 0.83552 | -6.43 | -4.33 | -0.03265723 | -0.03265723 | -0.03265723 | -0.03265723 | -0.03265723 |
| Depreciation | 12.0 | 18.0 | 17.1 | 19.7 | 19.2 | 15.9 | 19.2 | 23.0 | 27.7 | 33.3 |
| Depreciation, % | 1.05 | 1.2 | 1.1 | 1.56 | 2.01 | 1.38 | 1.38 | 1.38 | 1.38 | 1.38 |
| EBIT | 23.8 | 81.4 | -4.1 | -100.9 | -60.8 | -16.3 | -19.6 | -23.6 | -28.3 | -34.1 |
| EBIT, % | 2.07 | 5.44 | -0.26579 | -7.98 | -6.34 | -1.42 | -1.42 | -1.42 | -1.42 | -1.42 |
| Total Cash | 1,380.8 | 1,435.4 | 1,501.8 | 1,326.0 | 1,009.0 | 1,134.9 | 1,364.2 | 1,639.8 | 1,971.1 | 2,369.3 |
| Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
| Account Receivables | 15.6 | 18.6 | 30.7 | 17.6 | 29.0 | 20.7 | 24.9 | 29.9 | 36.0 | 43.3 |
| Account Receivables, % | 1.36 | 1.24 | 1.97 | 1.39 | 3.03 | 1.8 | 1.8 | 1.8 | 1.8 | 1.8 |
| Inventories | .2 | 22.6 | 7.6 | -1,244.0 | .0 | -222.2 | -267.1 | -321.1 | -385.9 | -463.9 |
| Inventories, % | 0.01662189 | 1.51 | 0.49042 | -98.45 | 0 | -19.29 | -19.29 | -19.29 | -19.29 | -19.29 |
| Accounts Payable | .5 | 1.4 | 1.7 | 3.1 | 2.1 | 1.6 | 2.0 | 2.4 | 2.8 | 3.4 |
| Accounts Payable, % | 0.04448026 | 0.09238276 | 0.11081 | 0.24428 | 0.2139 | 0.14117 | 0.14117 | 0.14117 | 0.14117 | 0.14117 |
| Capital Expenditure | -9.8 | -58.7 | -13.4 | -154.7 | -18.0 | -45.5 | -54.7 | -65.8 | -79.1 | -95.1 |
| Capital Expenditure, % | -0.85254 | -3.92 | -0.86391 | -12.24 | -1.88 | -3.95 | -3.95 | -3.95 | -3.95 | -3.95 |
| Tax Rate, % | -6.91 | -6.91 | -6.91 | -6.91 | -6.91 | -6.91 | -6.91 | -6.91 | -6.91 | -6.91 |
| EBITAT | 19.6 | 69.7 | -3.3 | -107.0 | -65.0 | -14.6 | -17.5 | -21.1 | -25.3 | -30.4 |
| Depreciation | ||||||||||
| Changes in Account Receivables | ||||||||||
| Changes in Inventories | ||||||||||
| Changes in Accounts Payable | ||||||||||
| Capital Expenditure | ||||||||||
| UFCF | 6.6 | 4.4 | 3.6 | 1,024.1 | -1,320.2 | 185.9 | -12.1 | -14.5 | -17.4 | -21.0 |
| WACC, % | 7.29 | 7.29 | 7.28 | 7.3 | 7.3 | 7.29 | 7.29 | 7.29 | 7.29 | 7.29 |
| PV UFCF | ||||||||||
| SUM PV UFCF | 123.2 | |||||||||
| Long Term Growth Rate, % | 3.00 | |||||||||
| Free cash flow (T + 1) | -22 | |||||||||
| Terminal Value | -503 | |||||||||
| Present Terminal Value | -354 | |||||||||
| Enterprise Value | -231 | |||||||||
| Net Debt | -59 | |||||||||
| Equity Value | -172 | |||||||||
| Diluted Shares Outstanding, MM | 243 | |||||||||
| Equity Value Per Share | -0.71 |
What You Will Receive
- Customizable Excel Template: A fully adjustable Excel-based DCF Calculator featuring pre-filled real HUYA financials.
- Actual Data Insights: Historical performance data and forward-looking estimates (highlighted in the yellow cells).
- Forecast Adaptability: Modify forecast assumptions such as revenue growth, EBITDA %, and WACC.
- Instant Calculations: Quickly observe how your inputs affect HUYA’s valuation.
- Professional Resource: Designed for investors, CFOs, consultants, and financial analysts.
- Intuitive Layout: Organized for clarity and ease of navigation, complete with step-by-step guidance.
Key Features
- Real-Time HUYA Data: Pre-loaded with HUYA Inc.'s historical financial performance and future projections.
- Comprehensive Input Customization: Modify revenue growth rates, profit margins, WACC, tax rates, and capital expenditures.
- Interactive Valuation Model: Instantaneous updates to Net Present Value (NPV) and intrinsic value based on your adjustments.
- Scenario Analysis: Develop various forecasting scenarios to evaluate different valuation possibilities.
- Intuitive User Interface: Clean, organized, and tailored for both seasoned professionals and newcomers.
How It Works
- Download the Template: Gain immediate access to the Excel-based HUYA DCF Calculator.
- Input Your Assumptions: Modify the yellow-highlighted cells for growth rates, WACC, profit margins, and more.
- Instant Calculations: The model automatically recalculates HUYA's intrinsic value.
- Test Scenarios: Experiment with various assumptions to assess potential valuation shifts.
- Analyze and Decide: Leverage the results to inform your investment or financial analysis.
Why Choose This Calculator for HUYA Inc. (HUYA)?
- User-Friendly Interface: Tailored for both novices and seasoned professionals.
- Customizable Parameters: Adjust inputs easily to suit your specific analysis needs.
- Real-Time Valuation: Witness immediate updates to HUYA's valuation as you modify inputs.
- Preloaded Data: Comes with HUYA's actual financial information for fast and efficient analysis.
- Relied Upon by Experts: Utilized by investors and analysts for making well-informed decisions.
Who Should Use This Product?
- Individual Investors: Make informed decisions about buying or selling HUYA stock (HUYA).
- Financial Analysts: Streamline valuation processes with ready-to-use financial models for HUYA Inc. (HUYA).
- Consultants: Deliver professional valuation insights related to HUYA Inc. (HUYA) to clients quickly and accurately.
- Business Owners: Understand how companies like HUYA Inc. (HUYA) are valued to guide your own strategy.
- Finance Students: Learn valuation techniques using real-world data and scenarios from HUYA Inc. (HUYA).
What the Template Contains
- Pre-Filled Data: Includes HUYA Inc.'s historical financials and forecasts.
- Discounted Cash Flow Model: Editable DCF valuation model with automatic calculations.
- Weighted Average Cost of Capital (WACC): A dedicated sheet for calculating WACC based on custom inputs.
- Key Financial Ratios: Analyze HUYA Inc.'s profitability, efficiency, and leverage.
- Customizable Inputs: Edit revenue growth, margins, and tax rates with ease.
- Clear Dashboard: Charts and tables summarizing key valuation results.