Excel – http://1drv.ms/1AG006N
Notes – http://tinyurl.com/kdtolbw
- 5-Y DCF:
- Good Scenario: 10.88 (Fair value uncertainty: VERY HIGH)
- Base Scenario: 9.5 (Fair value uncertainty: EXTREME)
- Bad Scenario: 8.28 (Fair value uncertainty: EXTREME)
- Ugly Scenario: 7.2 (Fair value uncertainty: EXTREME)
- At current price (13.16), based on RDCF, assumption of FCFF growth rate in the next 5 years is 15.8%.
- Absolute EY%:
- FY14 (EPS: 0.692) – Fair value 12.69 (Fair Value Uncertainty: HIGH)
- R4Q (EPS: 0.692) – Fair value 12.69 (Fair Value Uncertainty: HIGH)
- FY15 (EPS: 0.713) – Fair value 13.07 (Fair Value Uncertainty: HIGH)
- FY16 (EPS: 0.756) – Fair value 13.86 (Fair Value Uncertainty: HIGH)
- EPS applied to reach the current stock price (13.16): 0.718
- 5-Y DCF:
- Going forward, I remain conservative and skeptical above volume growth in the brewery sector as some reports show that the industry is saturated, coupled with several other external factors such as rising fuel costs, inflation as well as potential exposure to excise duty hike in the near future. However, earnings should be sustainable at current levels.
- CARLSBG is determined to move away from a single star beer product company to become a star beer portfolio company. Over the past 10 years, CARLSBG has been trying to launch a couple of new products into the market. To date, however, its Carlsberg Green Label is still viewed as the group’s only crown jewel. As such, a reshuffle has been undertaken in its top management team over the last 2 to 3 years with the aim of bringing good changes to the group. Besides, it has also appointed a few brand managers to oversee the brand building efforts across a few main products, whereby premium brands are expected to form a larger proportion of its new product portfolio. While efforts are being made to build market share for its premium products, the Carlsberg Green Label will remain as the bread and butter of the group. Whether or not CARLSBG will be able to return to its former glory, it is still too early to tell, but the good efforts warrant CARLSBG a buy/hold call for the long term. There are downside risks if things do not turn out as expected.
- Valuation wise, CARLSBG is fully or over valued, but its Dividend Yield is 5.3%. You basically pay premium to buy an outstanding dividend counter.
Latest Financial – Q4 2014 Financial Report (27 Feb 2015) http://www.bursamalaysia.com/market/listed-companies/company-announcements/1888157
At the time of writing, I owned shares of CARLSBG.