JOYY Inc. (YY) 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
JOYY Inc. (YY) Bundle
Discover the true value of JOYY Inc. (YY) with our professional-grade DCF Calculator! Adjust key assumptions, explore various scenarios, and evaluate how changes affect JOYY Inc. (YY) valuation – all within a single Excel template.
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 | 500.9 | 277.5 | 358.9 | 330.4 | 310.7 | 288.1 | 267.1 | 247.6 | 229.6 | 212.8 |
Revenue Growth, % | 0 | -44.6 | 29.33 | -7.92 | -5.96 | -7.29 | -7.29 | -7.29 | -7.29 | -7.29 |
EBITDA | 146.3 | 40.1 | 16.4 | 21.7 | 57.9 | 42.3 | 39.2 | 36.4 | 33.7 | 31.3 |
EBITDA, % | 29.22 | 14.45 | 4.57 | 6.58 | 18.63 | 14.69 | 14.69 | 14.69 | 14.69 | 14.69 |
Depreciation | 23.2 | 27.9 | 25.1 | 22.4 | 17.0 | 19.5 | 18.1 | 16.8 | 15.6 | 14.4 |
Depreciation, % | 4.63 | 10.04 | 6.98 | 6.77 | 5.47 | 6.78 | 6.78 | 6.78 | 6.78 | 6.78 |
EBIT | 123.1 | 12.2 | -8.6 | -.6 | 40.9 | 22.8 | 21.1 | 19.6 | 18.2 | 16.8 |
EBIT, % | 24.59 | 4.41 | -2.41 | -0.19349 | 13.16 | 7.91 | 7.91 | 7.91 | 7.91 | 7.91 |
Total Cash | 514.8 | 486.7 | 601.2 | 539.5 | 505.0 | 288.1 | 267.1 | 247.6 | 229.6 | 212.8 |
Total Cash, percent | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 | .0 |
Account Receivables | 23.2 | 29.2 | 37.5 | 31.6 | 40.0 | 27.7 | 25.6 | 23.8 | 22.0 | 20.4 |
Account Receivables, % | 4.63 | 10.51 | 10.45 | 9.55 | 12.86 | 9.6 | 9.6 | 9.6 | 9.6 | 9.6 |
Inventories | 12.9 | 13.4 | 40.7 | 48.1 | .3 | 19.2 | 17.8 | 16.5 | 15.3 | 14.2 |
Inventories, % | 2.57 | 4.82 | 11.35 | 14.56 | 0.09462624 | 6.68 | 6.68 | 6.68 | 6.68 | 6.68 |
Accounts Payable | 2.4 | 2.9 | 2.5 | 7.7 | 9.1 | 4.3 | 4.0 | 3.7 | 3.4 | 3.2 |
Accounts Payable, % | 0.47242 | 1.03 | 0.68769 | 2.32 | 2.94 | 1.49 | 1.49 | 1.49 | 1.49 | 1.49 |
Capital Expenditure | -21.4 | -22.2 | -25.3 | -9.5 | -11.2 | -14.9 | -13.8 | -12.8 | -11.9 | -11.0 |
Capital Expenditure, % | -4.27 | -7.99 | -7.06 | -2.87 | -3.62 | -5.16 | -5.16 | -5.16 | -5.16 | -5.16 |
Tax Rate, % | -4.81 | -4.81 | -4.81 | -4.81 | -4.81 | -4.81 | -4.81 | -4.81 | -4.81 | -4.81 |
EBITAT | 100.8 | -7.7 | -11.5 | -.6 | 42.9 | 17.2 | 15.9 | 14.7 | 13.7 | 12.7 |
Depreciation | ||||||||||
Changes in Account Receivables | ||||||||||
Changes in Inventories | ||||||||||
Changes in Accounts Payable | ||||||||||
Capital Expenditure | ||||||||||
UFCF | 68.9 | -8.0 | -47.9 | 16.1 | 89.5 | 10.3 | 23.3 | 21.6 | 20.1 | 18.6 |
WACC, % | 5.7 | 5.62 | 5.72 | 5.71 | 5.72 | 5.69 | 5.69 | 5.69 | 5.69 | 5.69 |
PV UFCF | ||||||||||
SUM PV UFCF | 79.1 | |||||||||
Long Term Growth Rate, % | 2.00 | |||||||||
Free cash flow (T + 1) | 19 | |||||||||
Terminal Value | 514 | |||||||||
Present Terminal Value | 389 | |||||||||
Enterprise Value | 469 | |||||||||
Net Debt | -79 | |||||||||
Equity Value | 547 | |||||||||
Diluted Shares Outstanding, MM | 73 | |||||||||
Equity Value Per Share | 7.48 |
What You Will Get
- Editable Forecast Inputs: Easily modify assumptions (growth %, margins, WACC) to explore various scenarios.
- Real-World Data: JOYY Inc.’s (YY) financial data pre-loaded to streamline your analysis.
- Automatic DCF Outputs: The template computes Net Present Value (NPV) and intrinsic value automatically.
- Customizable and Professional: A refined Excel model that adjusts to your valuation requirements.
- Built for Analysts and Investors: Perfect for testing forecasts, validating strategies, and enhancing efficiency.
Key Features
- Comprehensive DCF Calculator: Features detailed unlevered and levered DCF valuation models tailored for JOYY Inc. (YY).
- WACC Calculator: Pre-configured Weighted Average Cost of Capital sheet with adjustable inputs for precise calculations.
- Customizable Forecast Assumptions: Adjust growth rates, capital expenditures, and discount rates to fit your analysis.
- Integrated Financial Ratios: Evaluate profitability, leverage, and efficiency ratios specifically for JOYY Inc. (YY).
- Interactive Dashboard and Charts: Visual representations summarize essential valuation metrics for straightforward analysis.
How It Works
- Step 1: Download the prebuilt Excel template with JOYY Inc.'s (YY) data included.
- Step 2: Explore the pre-filled sheets and familiarize yourself with the key metrics.
- Step 3: Update forecasts and assumptions in the editable yellow cells (WACC, growth, margins).
- Step 4: Instantly view recalculated results, including JOYY Inc.'s (YY) intrinsic value.
- Step 5: Make informed investment decisions or generate reports using the outputs.
Why Choose JOYY Inc. (YY)?
- Diverse Offerings: A wide range of platforms catering to different user needs and preferences.
- Strong Growth Potential: Consistent expansion in user base and revenue streams enhances investment opportunities.
- Innovative Technology: Cutting-edge features and tools that keep JOYY ahead in the digital landscape.
- Global Reach: A robust international presence that opens doors to various markets.
- Backed by Expertise: A team of seasoned professionals dedicated to driving success and value.
Who Should Use This Product?
- Investors: Accurately assess JOYY Inc.'s (YY) fair value prior to making investment choices.
- CFOs: Utilize a professional-grade DCF model for financial reporting and analysis specific to JOYY Inc. (YY).
- Consultants: Efficiently customize the template for valuation reports tailored to JOYY Inc. (YY) clients.
- Entrepreneurs: Acquire insights into financial modeling practices employed by leading companies like JOYY Inc. (YY).
- Educators: Implement it as a teaching resource to illustrate valuation methodologies relevant to JOYY Inc. (YY).
What the Template Contains
- Preloaded YY Data: Historical and projected financial data, including revenue, EBIT, and capital expenditures.
- DCF and WACC Models: Professional-grade sheets for calculating intrinsic value and Weighted Average Cost of Capital.
- Editable Inputs: Yellow-highlighted cells for adjusting revenue growth, tax rates, and discount rates.
- Financial Statements: Comprehensive annual and quarterly financials for deeper analysis.
- Key Ratios: Profitability, leverage, and efficiency ratios to evaluate performance.
- Dashboard and Charts: Visual summaries of valuation outcomes and assumptions.