Calculating The Fair Value Of Qingdao Citymedia Co,. Ltd. (SHSE:600229)
Calculating The Fair Value Of Qingdao Citymedia Co,. Ltd. (SHSE:600229)
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相比,在撰寫本文時,公司似乎在公平價值左右。然而,估值是不精確的工具,就像望遠鏡一樣,稍微移動幾度,就會進入不同的星系。請記住這一點。

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模型的最佳用途是測試某些假設和理論,以查看它們是否會導致公司被低估或高估。例如,如果終止價值增長率略有調整,可能會極大地改變總結果。對於青島城市傳媒有限公司,有三個值得評估的要點。
- 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.
- 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.
- 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!
- 風險:在投資該公司之前,我們認爲你應該評估青島城市傳媒有限公司的三個警示信號。
- 未來收益:600229的增長率與其同行和更廣泛市場相比如何?通過與我們的免費分析師增長預期圖表互動,更深入地了解即將到來的多年分析師共識數字。
- 其他高質量選擇:你喜歡一個好的多面手嗎?瀏覽我們的高質量股票交互列表,了解還有哪些你可能錯過的好東西!
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沒有任何股票頭寸。