Discounted Cash Flow (DCF) Analysis Unlevered

Glory Star New Media Group Holdings... (GSMG)

$0.405

+0.06 (+17.12%)
All numbers are in Millions, Currency in USD
Stock DCF: -134.85 | 0.405 | 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 57.8065.78123.76153.01157.08207.44273.95361.78477.77630.95
Revenue (%)
EBITDA 14.0826.8934.5638.5530.3557.1275.4399.62131.55173.73
EBITDA (%)
EBIT 13.7825.8431.2036.0327.0153.5570.7293.40123.34162.88
EBIT (%)
Depreciation 0.301.053.362.523.343.574.716.228.2110.85
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.446.9219.4677.3070.4852.2168.9591.06120.26158.81
Total Cash (%)
Account Receivables 35.5551.0681.1163.1498.03127.92168.94223.10294.63389.09
Account Receivables (%)
Inventories 7.032.17-1.737.177.369.7212.8416.9622.4029.58
Inventories (%)
Accounts Payable 0.814.557.8912.886.4011.2714.8919.6625.9634.29
Accounts Payable (%)
Capital Expenditure -0.15-15.32-2.78-2.79-7.99-13.57-17.92-23.67-31.25-41.28
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 0.405
Beta -0.856
Diluted Shares Outstanding 31.29
Cost of Debt
Tax Rate -0.14
After-tax Cost of Debt 4.11%
Risk-Free Rate
Market Risk Premium
Cost of Equity 0.070
Total Debt 5.10
Total Equity 12.67
Total Capital 17.77
Debt Weighting 28.70
Equity Weighting 71.30
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 57.8065.78123.76153.01157.08207.44273.95361.78477.77630.95
EBITDA 14.0826.8934.5638.5530.3557.1275.4399.62131.55173.73
EBIT 13.7825.8431.2036.0327.0153.5570.7293.40123.34162.88
Tax Rate 2.89%1.02%5.31%2.87%-0.14%2.39%2.39%2.39%2.39%2.39%
EBIAT 13.3925.5729.543527.0552.2769.0391.16120.39158.99
Depreciation 0.301.053.362.523.343.574.716.228.2110.85
Accounts Receivable --15.51-30.0517.97-34.90-29.89-41.01-54.16-71.53-94.46
Inventories -4.873.90-8.90-0.19-2.36-3.12-4.12-5.44-7.18
Accounts Payable -3.743.344.99-6.474.873.614.776.308.32
Capital Expenditure -0.15-15.32-2.78-2.79-7.99-13.57-17.92-23.67-31.25-41.28
UFCF 13.534.407.3148.79-19.1714.8915.3020.2126.6935.25
WACC
PV UFCF 14.7114.9319.4825.4233.16
SUM PV UFCF 107.69

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 1.23
Free cash flow (t + 1) 35.95
Terminal Value -4,668.95
Present Value of Terminal Value -4,392.11

Intrinsic Value

Enterprise Value -4,284.42
Net Debt -65.38
Equity Value -4,219.03
Shares Outstanding 31.29
Equity Value Per Share -134.85