share_log

Calculating The Fair Value Of Qingdao Citymedia Co,. Ltd. (SHSE:600229)

Calculating The Fair Value Of Qingdao Citymedia Co,. Ltd. (SHSE:600229)

计算青岛城市媒体有限公司的公允价值有限公司(上海证券交易所股票代码:600229)
Simply Wall St ·  05/28 18:30

Key Insights

主要见解

  • The projected fair value for Qingdao Citymedia Co is CN¥6.35 based on 2 Stage Free Cash Flow to Equity
  • Current share price of CN¥7.28 suggests Qingdao Citymedia Co is potentially trading close to its fair value
  • When compared to theindustry average discount of -771%, Qingdao Citymedia Co's competitors seem to be trading at a greater premium to fair value
  • 基于2阶段自由现金流估值,青岛城市传媒股份有限公司的预估公允价值为6.35元人民币。
  • 青岛城市传媒股份有限公司当前股价为7.28元人民币,可能接近其公允价值。
  • 与-771%的行业平均折价相比,青岛城市传媒股份有限公司的竞争对手似乎更接近于其公允价值。

In this article we are going to estimate the intrinsic value of Qingdao Citymedia Co,. Ltd. (SHSE:600229) by estimating the company's future cash flows and discounting them to their present value. Our analysis will employ the Discounted Cash Flow (DCF) model. There's really not all that much to it, even though it might appear quite complex.

本文将通过估算青岛城市传媒股份有限公司未来现金流并将其折现至当前价值来估计公司的内在价值。(上海证券交易所:600229)我们的分析将采用折现现金流量模型(DCF)。虽然它看起来很复杂,但实际上并没有那么难。

Companies can be valued in a lot of ways, so we would point out that a DCF is not perfect for every situation. Anyone interested in learning a bit more about intrinsic value should have a read of the Simply Wall St analysis model.

公司的估值可以用很多种方式来估算,因此我们指出DCF并不适用于每种情况。任何对内在价值想要了解更多的人都应该阅读简单华尔街分析模型的报告。

Step By Step Through The Calculation

通过计算的步骤:

We use what is known as a 2-stage model, which simply means we have two different periods of growth rates for the company's cash flows. Generally the first stage is higher growth, and the second stage is a lower growth phase. To begin with, we have to get estimates of the next ten years of cash flows. Seeing as no analyst estimates of free cash flow are available to us, we have extrapolate the previous free cash flow (FCF) from the company's last reported value. We assume companies with shrinking free cash flow will slow their rate of shrinkage, and that companies with growing free cash flow will see their growth rate slow, over this period. We do this to reflect that growth tends to slow more in the early years than it does in later years.

我们使用的是2阶段模型,这意味着公司现金流有两个不同的增长阶段。一般来说,第一阶段是高增长,第二阶段是低增长。首先,我们必须对未来十年的现金流进行估计。由于没有自由现金流的分析师估计数据可供我们使用,因此我们必须推断出公司上一期的自由现金流(FCF)的数据,并假定自由现金流在此期间呈收缩趋势的公司的收缩速率会降低,自由现金流呈增长趋势的公司的增长率也会放缓。我们这样做是为了反映增长趋势在早期相较于后期会放缓。

A DCF is all about the idea that a dollar in the future is less valuable than a dollar today, and so the sum of these future cash flows is then discounted to today's value:

DCF的核心概念是未来的每一美元都比现在的每一美元更不值钱,因此我们将这些未来的现金流贴现到当今的价值:

10-year free cash flow (FCF) forecast

10年自由现金流(FCF)预测

2024 2025 2026 2027 2028 2029 2030 2031 2032 2033
Levered FCF (CN¥, Millions) CN¥237.7m CN¥230.6m CN¥227.9m CN¥227.9m CN¥230.0m CN¥233.4m CN¥237.9m CN¥243.1m CN¥249.0m CN¥255.4m
Growth Rate Estimate Source Est @ -5.46% Est @ -2.96% Est @ -1.20% Est @ 0.03% Est @ 0.89% Est @ 1.49% Est @ 1.92% Est @ 2.21% Est @ 2.42% Est @ 2.56%
Present Value (CN¥, Millions) Discounted @ 7.7% CN¥221 CN¥199 CN¥182 CN¥169 CN¥159 CN¥149 CN¥141 CN¥134 CN¥128 CN¥121
2024 2025 2026 2027 2028 2029 2030 2031 2032 2033
杠杆自由现金流量(人民币,百万) 237.7万元人民币 230.6万元人民币 227.9万元人民币 227.9万元人民币 230.0万元人民币 233.4万元人民币 237.9万元人民币 243.1万元人民币 人民币249.0万元 255.4万元人民币
创业板增长率预测来源 预计-5.46%时 预估-2.96% 预计为-1.20% 预估0.03% 以0.89%估算 预期为1.49% 预计为1.92% 估值上涨2.21% 按照2.42%的估算 223美元
现值(人民币百万)以7.7%贴现 221元人民币 199元人民币 182元人民币 人民币169 CN¥159 149元人民币 141人民币 134元人民币 128元人民币 121元人民币

("Est" = FCF growth rate estimated by Simply Wall St)
Present Value of 10-year Cash Flow (PVCF) = CN¥1.6b

("Est" = FCF增长率估计由Simply Wall St)
十年现金流的现值(PVCF) = 人民币1.6亿

The second stage is also known as Terminal Value, this is the business's cash flow after the first stage. The Gordon Growth formula is used to calculate Terminal Value at a future annual growth rate equal to the 5-year average of the 10-year government bond yield of 2.9%. We discount the terminal cash flows to today's value at a cost of equity of 7.7%.

第二阶段也被称为终止阶段,这是企业在第一阶段后的现金流。使用戈登增长法计算以未来年增长率为2.9%的10年期政府债券收益率的5年平均值为终止价值。我们以7.7%的权益成本将终止性现金流贴现为今天的价值。

Terminal Value (TV)= FCF2033 × (1 + g) ÷ (r – g) = CN¥255m× (1 + 2.9%) ÷ (7.7%– 2.9%) = CN¥5.5b

终止价值(TV)= FCF2033× (1 + g) ÷ (r – g) = 人民币2.55亿× (1 + 2.9%) ÷ (7.7%– 2.9%) = 人民币5.5亿

Present Value of Terminal Value (PVTV)= TV / (1 + r)10= CN¥5.5b÷ ( 1 + 7.7%)10= CN¥2.6b

终止价值现值(PVTV)= TV / (1 + r)10= 人民币5.5亿÷ ( 1 + 7.7%)10= 人民币2.6亿

The total value is the sum of cash flows for the next ten years plus the discounted terminal value, which results in the Total Equity Value, which in this case is CN¥4.2b. To get the intrinsic value per share, we divide this by the total number of shares outstanding. Compared to the current share price of CN¥7.3, the company appears around fair value at the time of writing. Valuations are imprecise instruments though, rather like a telescope - move a few degrees and end up in a different galaxy. Do keep this in mind.

总价值等于未来十年现金流和折现终止价值之和,结果为总股权价值。在本例中,总股权价值为人民币4.2亿。要获得每股内在价值,我们将其除以总流通股数。与目前的股价人民币7.3相比,在撰写本文时,公司似乎在公平价值左右。然而,估值是不精确的工具,就像望远镜一样,稍微移动几度,就会进入不同的星系。请记住这一点。

dcf
SHSE:600229 Discounted Cash Flow May 28th 2024
SHSE:600229折现现金流2024年5月28日

The Assumptions

假设

Now the most important inputs to a discounted cash flow are the discount rate, and of course, the actual cash flows. If you don't agree with these result, have a go at the calculation yourself and play with the assumptions. The DCF also does not consider the possible cyclicality of an industry, or a company's future capital requirements, so it does not give a full picture of a company's potential performance. Given that we are looking at Qingdao Citymedia Co as potential shareholders, the cost of equity is used as the discount rate, rather than the cost of capital (or weighted average cost of capital, WACC) which accounts for debt. In this calculation we've used 7.7%, which is based on a levered beta of 0.856. Beta is a measure of a stock's volatility, compared to the market as a whole. We get our beta from the industry average beta of globally comparable companies, with an imposed limit between 0.8 and 2.0, which is a reasonable range for a stable business.

现金流折现的最重要因素是折现率和实际现金流量。如果您不同意这些结果,请亲自进行计算并调整假定。DCF也不考虑行业可能的周期性或公司未来的资本需求,因此它不能全面展现公司的潜在表现。鉴于我们考虑了青岛城市传媒有限公司的潜在股东身份,因此使用权益成本作为折现率,而不是考虑负债的资本成本(或加权平均资本成本,WACC)。在这个计算中,我们使用的是7.7%,这基于一个杠杆贝塔为0.856。贝塔是股票相对于整个市场的波动性度量。我们从全球可比公司的行业平均贝塔中获取贝塔,并施加了在0.8到2.0之间的限制,这是一个稳定企业的合理范围。

Looking Ahead:

展望未来:

Valuation is only one side of the coin in terms of building your investment thesis, and it shouldn't be the only metric you look at when researching a company. It's not possible to obtain a foolproof valuation with a DCF model. Instead the best use for a DCF model is to test certain assumptions and theories to see if they would lead to the company being undervalued or overvalued. For instance, if the terminal value growth rate is adjusted slightly, it can dramatically alter the overall result. For Qingdao Citymedia Co, there are three pertinent elements you should assess:

在构建您的投资论点方面,估值只是其中一方面,并且在研究一家公司时,估值不应该是您关注的唯一指标。使用DCF模型无法获得一种确凿无误的估值。相反,DCF模型的最佳用途是测试某些假设和理论,以查看它们是否会导致公司被低估或高估。例如,如果终止价值增长率略有调整,可能会极大地改变总结果。对于青岛城市传媒有限公司,有三个值得评估的要点。

  1. Risks: We feel that you should assess the 3 warning signs for Qingdao Citymedia Co we've flagged before making an investment in the company.
  2. Future Earnings: How does 600229's growth rate compare to its peers and the wider market? Dig deeper into the analyst consensus number for the upcoming years by interacting with our free analyst growth expectation chart.
  3. Other High Quality Alternatives: Do you like a good all-rounder? Explore our interactive list of high quality stocks to get an idea of what else is out there you may be missing!
  1. 风险:在投资该公司之前,我们认为你应该评估青岛城市传媒有限公司的三个警示信号。
  2. 未来收益:600229的增长率与其同行和更广泛市场相比如何?通过与我们的免费分析师增长预期图表互动,更深入地了解即将到来的多年分析师共识数字。
  3. 其他高质量选择:你喜欢一个好的多面手吗?浏览我们的高质量股票交互列表,了解还有哪些你可能错过的好东西!

PS. The Simply Wall St app conducts a discounted cash flow valuation for every stock on the SHSE every day. If you want to find the calculation for other stocks just search here.

PS。Simply Wall St应用程序每天为SHSE上的每只股票进行贴现现金流估值。如果您想找到其他股票的计算,请在此搜索。

Have feedback on this article? Concerned about the content? Get in touch with us directly. Alternatively, email editorial-team (at) simplywallst.com.
This article by Simply Wall St is general in nature. We provide commentary based on historical data and analyst forecasts only using an unbiased methodology and our articles are not intended to be financial advice. It does not constitute a recommendation to buy or sell any stock, and does not take account of your objectives, or your financial situation. We aim to bring you long-term focused analysis driven by fundamental data. Note that our analysis may not factor in the latest price-sensitive company announcements or qualitative material. Simply Wall St has no position in any stocks mentioned.

对本文有反馈?关于内容有所顾虑?直接和我们联系。或者,发送电子邮件至editorial-team (at) simplywallst.com。
这篇文章是Simply Wall St的一般性文章。我们根据历史数据和分析师预测提供评论,只使用公正的方法论,我们的文章并不意味着提供任何金融建议。文章不构成买卖任何股票的建议,也不考虑您的目标或您的财务状况。我们的目标是带给您基本数据驱动的长期关注分析。请注意,我们的分析可能不考虑最新的价格敏感公司公告或定性材料。Simply Wall St没有任何股票头寸。

声明:本内容仅用作提供资讯及教育之目的,不构成对任何特定投资或投资策略的推荐或认可。 更多信息
    抢沙发