A Look At The Intrinsic Value Of Qingdao Citymedia Co,. Ltd. (SHSE:600229)
A Look At The Intrinsic Value Of Qingdao Citymedia Co,. Ltd. (SHSE:600229)
Key Insights
主要見解
- Qingdao Citymedia Co's estimated fair value is CN¥7.71 based on 2 Stage Free Cash Flow to Equity
- Qingdao Citymedia Co's CN¥8.37 share price indicates it is trading at similar levels as its fair value estimate
- When compared to theindustry average discount of -1,714%, Qingdao Citymedia Co's competitors seem to be trading at a greater premium to fair value
- 青島城市傳媒有限公司的估計公允價值爲人民幣7.71,這是基於兩階段自由現金流對股東的估算。
- 青島城市傳媒有限公司的人民幣8.37的股票價格表明其交易水平與公允價值估算相似。
- 與行業平均折扣 -1,714% 相比,青島城市傳媒有限公司的競爭對手似乎以更高的溢價交易於公允價值。
Today we'll do a simple run through of a valuation method used to estimate the attractiveness of Qingdao Citymedia Co,. Ltd. (SHSE:600229) as an investment opportunity by taking the forecast future cash flows of the company and discounting them back to today's value. This will be done using the Discounted Cash Flow (DCF) model. Believe it or not, it's not too difficult to follow, as you'll see from our example!
今天我們將簡單介紹一種估值方法,該方法用於評估青島城市傳媒有限公司(SHSE: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. For those who are keen learners of equity analysis, the Simply Wall St analysis model here may be something of interest to you.
公司的估值有很多方式,所以我們會指出DCF並非適用於每種情況。如果你是股票分析的狂熱者,可以考慮嘗試Simply Wall Street的分析模型。
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 start off with, we need to estimate 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段模型,這意味着我們有兩個不同的現金流增長期。通常,第一個階段是較高的增長,第二個階段是較低的增長階段。首先,我們需要估計接下來10年的現金流。由於沒有分析師對自由現金流的估計可用,我們必須從公司上次報告的價值中推斷出以前的自由現金流(FCF)。我們假設自由現金流縮水的公司將減緩其縮水速度,而自由現金流增長的公司在這一時期內將看到其增長速度減緩。我們這樣做是爲了反映出,在早期年份增長往往比後期年份增長更慢。
Generally we assume that a dollar today is more valuable than a dollar in the future, so we discount the value of these future cash flows to their estimated value in today's dollars:
通常我們認爲今天的一美元比未來的一美元更有價值,因此我們將這些未來的現金流折現爲今天的估計價值:
10-year free cash flow (FCF) estimate
10年自由現金流 (FCF) 預估值
2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | |
Levered FCF (CN¥, Millions) | CN¥287.7m | CN¥269.4m | CN¥259.6m | CN¥255.2m | CN¥254.3m | CN¥255.8m | CN¥259.0m | CN¥263.5m | CN¥268.9m | CN¥275.0m |
Growth Rate Estimate Source | Est @ -10.32% | Est @ -6.38% | Est @ -3.63% | Est @ -1.70% | Est @ -0.35% | Est @ 0.59% | Est @ 1.26% | Est @ 1.72% | Est @ 2.04% | Est @ 2.27% |
Present Value (CN¥, Millions) Discounted @ 7.2% | CN¥269 | CN¥235 | CN¥211 | CN¥194 | CN¥180 | CN¥169 | CN¥160 | CN¥152 | CN¥144 | CN¥138 |
2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | |
槓桿自由現金流量(人民幣,百萬) | 人民幣287.7百萬 | 人民幣269.4百萬 | CN¥259.6m | CN¥255.2m | CN¥254.3m | 255.8百萬人民幣 | 人民幣259.0百萬 | 人民幣263.5百萬 | 人民幣268.9百萬 | 275.0百萬人民幣 |
增長率估計來源 | 預計 @ -10.32% | 預計 @ -6.38% | 估計值爲-3.63%。 | 預計爲-1.70% | 預測下跌0.35% | 估計值爲0.59% | 估計 @ 1.26% | 預計爲1.72% | 預計漲幅爲2.04%。 | 預計爲2.27% |
現值(CN¥萬)折現率爲7.2% | 人民幣269 | CN¥235 | CN¥211 | 人民幣194元 | CN¥180 | 人民幣169 | 人民幣160元 | CN¥152 | CN¥144 | 138元人民幣 |
("Est" = FCF growth rate estimated by Simply Wall St)
Present Value of 10-year Cash Flow (PVCF) = CN¥1.8b
("Est" = Simply Wall St 估計的自由現金流增長率)
10年現金流的現值(PVCF)= 18億人民幣
The second stage is also known as Terminal Value, this is the business's cash flow after the first stage. For a number of reasons a very conservative growth rate is used that cannot exceed that of a country's GDP growth. In this case we have used the 5-year average of the 10-year government bond yield (2.8%) to estimate future growth. In the same way as with the 10-year 'growth' period, we discount future cash flows to today's value, using a cost of equity of 7.2%.
第二階段也稱爲終值,這是業務在第一階段之後的現金流。出於多種原因,採用了一個非常保守的增長率,該增長率不能超過一個國家GDP增長率。在這種情況下,我們使用了10年期政府債券收益率的5年平均值(2.8%)來估計未來增長。與10年「增長」期間的方式相同,我們使用7.2%的股本成本將未來的現金流折現爲今天的價值。
Terminal Value (TV)= FCF2034 × (1 + g) ÷ (r – g) = CN¥275m× (1 + 2.8%) ÷ (7.2%– 2.8%) = CN¥6.5b
終值 (TV)= 自由現金流2034 × (1 + g) ÷ (r – g) = CN¥275百萬× (1 + 2.8%) ÷ (7.2%– 2.8%) = CN¥6.5億
Present Value of Terminal Value (PVTV)= TV / (1 + r)10= CN¥6.5b÷ ( 1 + 7.2%)10= CN¥3.2b
終值現值 (PVTV)= TV / (1 + r)10= CN¥6.5億÷ ( 1 + 7.2%)10= CN¥3.2億
The total value, or equity value, is then the sum of the present value of the future cash flows, which in this case is CN¥5.1b. The last step is to then divide the equity value by the number of shares outstanding. Compared to the current share price of CN¥8.4, the company appears around fair value at the time of writing. Remember though, that this is just an approximate valuation, and like any complex formula - garbage in, garbage out.
總價值或股權價值是未來現金流現值的總和,在本案例中爲CN¥51億。最後一步是將股權價值除以流通在外的股票數。與當前股價CN¥8.4相比,該公司在寫作時似乎接近公平價值。不過請記住,這只是一個近似估值,像任何複雜公式一樣——輸入越爛,輸出越爛。
The Assumptions
假設
We would point out that the most important inputs to a discounted cash flow are the discount rate and of course the actual cash flows. Part of investing is coming up with your own evaluation of a company's future performance, so try the calculation yourself and check your own 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.2%, which is based on a levered beta of 0.876. 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.
我們要指出,貼現現金流中最重要的輸入是折現率和實際現金流。當然,投資的一部分是自己評估公司的未來表現,因此請自己嘗試計算並檢查自己的假設。這種貼現現金流也沒有考慮行業的可能週期性或公司的未來資本需求,因此無法全面反映公司的潛在表現。考慮到我們正在審視青島城媒股份有限公司作爲潛在股東,使用股權成本作爲折現率,而不是資本成本(或加權平均資本成本,WACC),後者考慮債務。在這個計算中,我們使用了7.2%,這是基於0.876的槓桿貝塔。貝塔是衡量一隻股票與整個市場波動性的指標。我們從全球可比公司的行業平均貝塔中獲取我們的貝塔,並設定了0.8到2.0之間的限制,這是一個穩定業務的合理區間。
Moving On:
接下來:
Although the valuation of a company is important, it is only one of many factors that you need to assess for a company. The DCF model is not a perfect stock valuation tool. 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. If a company grows at a different rate, or if its cost of equity or risk free rate changes sharply, the output can look very different. For Qingdao Citymedia Co, we've compiled three pertinent factors you should consider:
雖然公司的估值很重要,但它只是評估公司時需要考慮的衆多因素之一。現金流折現模型並不是一個完美的股票估值工具。相反,現金流折現模型最好的用途是測試某些假設和理論,以查看它們是否會導致公司被低估或高估。如果公司的增長率不同,或者其股本成本或無風險利率急劇變化,輸出結果會有很大的不同。對於青島市傳媒公司,我們整理了三個相關因素供您考慮:
- Risks: Case in point, we've spotted 2 warning signs for Qingdao Citymedia Co you should be aware of.
- Other Solid Businesses: Low debt, high returns on equity and good past performance are fundamental to a strong business. Why not explore our interactive list of stocks with solid business fundamentals to see if there are other companies you may not have considered!
- Other Environmentally-Friendly Companies: Concerned about the environment and think consumers will buy eco-friendly products more and more? Browse through our interactive list of companies that are thinking about a greener future to discover some stocks you may not have thought of!
- 風險:舉個例子,我們發現青島市傳媒公司有兩個您需要注意的警告信號。
- 其他優秀企業:低負債,高股本回報率和良好的過去業績是構建強大企業基礎的基礎。爲什麼不探索我們交互式的股票列表,其中包括具有堅實業務基礎的其他公司?
- 其他環保型公司:擔心環境問題,並認爲消費者將越來越多地購買環保產品?瀏覽我們的交互式公司列表,了解一些您可能沒有想到的股票!
PS. Simply Wall St updates its DCF calculation for every Chinese stock every day, so if you want to find the intrinsic value of any other stock just search here.
PS. Simply Wall St每天都會更新其所覆蓋的每隻中國股票的DCF計算,因此,如果您想找到任何其他股票的內在價值,只需在此搜索即可。
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 @ simplywallst.com。
Simply Wall St的這篇文章是一般性質的。我們僅基於歷史數據和分析師預測提供評論,使用公正的方法,我們的文章並非意在提供財務建議。這並不構成買入或賣出任何股票的建議,並且不考慮您的目標或財務狀況。我們旨在爲您帶來基於基礎數據驅動的長期聚焦分析。請注意,我們的分析可能未考慮最新的價格敏感公司公告或定性材料。Simply Wall St對提及的任何股票都沒有持倉。