JOYY Inc. (YY) DCF Valuation

JOYY Inc. (YY) DCF Valuation
  • Fully Editable: Tailor To Your Needs In Excel Or Sheets
  • Professional Design: Trusted, Industry-Standard Templates
  • Pre-Built For Quick And Efficient Use
  • No Expertise Is Needed; Easy To Follow

JOYY Inc. (YY) 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:

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
Account Receivables, % 4.63 10.51 10.45 9.55 12.86
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.