Discounted Cash Flow (DCF) Analysis Unlevered

JOYY Inc. (YY)

$37.67

+0.29 (+0.78%)
All numbers are in Millions, Currency in USD
Stock DCF: -14.02 | 37.67 | overvalue

Operating Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 2,291.553,655.412,025.152,619.052,411.522,630.492,869.343,129.883,414.083,724.08
Revenue (%)
EBITDA 486.02245.66-340.40-20.79158.7188.9697.03105.84115.46125.94
EBITDA (%)
EBIT 454.0376.48-555.59-203.72-4.67-71.03-77.48-84.51-92.19-100.56
EBIT (%)
Depreciation 31.99169.18215.20182.93163.38159.99174.51190.36207.64226.50
Depreciation (%)

Balance Sheet Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 2,080.283,756.953,552.354,387.933,937.633,681.594,015.884,380.534,778.295,212.17
Total Cash (%)
Account Receivables 276.74126.43143.60171.36119.72179.57195.88213.67233.07254.23
Account Receivables (%)
Inventories 31.5994.0397.62297.31351.11182.47199.03217.11236.82258.32
Inventories (%)
Accounts Payable 16.6617.8020.9318.015627.6630.1732.9135.9039.16
Accounts Payable (%)
Capital Expenditure -57.11-156.15-161.83-184.88-69.22-129.86-141.65-154.52-168.55-183.85
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 37.67
Beta 0.540
Diluted Shares Outstanding 73.64
Cost of Debt
Tax Rate 5.45
After-tax Cost of Debt 3.91%
Risk-Free Rate
Market Risk Premium
Cost of Equity 6.686
Total Debt 907.58
Total Equity 2,774.11
Total Capital 3,681.69
Debt Weighting 24.65
Equity Weighting 75.35
Wacc

Build Up Free Cash

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 2,291.553,655.412,025.152,619.052,411.522,630.492,869.343,129.883,414.083,724.08
EBITDA 486.02245.66-340.40-20.79158.7188.9697.03105.84115.46125.94
EBIT 454.0376.48-555.59-203.72-4.67-71.03-77.48-84.51-92.19-100.56
Tax Rate 12.84%18.13%163.39%-33.18%5.45%33.33%33.33%33.33%33.33%33.33%
EBIAT 395.7262.62352.18-271.31-4.41-47.36-51.66-56.35-61.47-67.05
Depreciation 31.99169.18215.20182.93163.38159.99174.51190.36207.64226.50
Accounts Receivable -150.30-17.16-27.7651.64-59.85-16.31-17.79-19.40-21.16
Inventories --62.45-3.59-199.68-53.80168.65-16.57-18.07-19.71-21.50
Accounts Payable -1.143.13-2.9237.99-28.342.512.742.993.26
Capital Expenditure -57.11-156.15-161.83-184.88-69.22-129.86-141.65-154.52-168.55-183.85
UFCF 370.61164.65387.92-503.62125.5763.22-49.16-53.63-58.50-63.81
WACC
PV UFCF 59.64-43.75-45.03-46.33-47.68
SUM PV UFCF -123.15

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 6.00
Free cash flow (t + 1) -65.08
Terminal Value -1,627.07
Present Value of Terminal Value -1,215.84

Intrinsic Value

Enterprise Value -1,338.99
Net Debt -306.87
Equity Value -1,032.13
Shares Outstanding 73.64
Equity Value Per Share -14.02