I would like to know why Profit attributable to Shareholder (Exc. Exceptional Items) is negative after my calculation.
I got the value of “profit attributed to share owners”, is 11.4mil in 2016 and 21.8mil in 2017. However after deducting the exceptional items, I am having a negative profit, this causes net profit margin to be negative. Am I doing something wrong?
For the exceptional items I remove Management Fee income, Income from mall operation and Rental Income, as I feel is recurring. Should I include gov grant as well? After deducting the exceptional items. the value is 16.5mil for 2017 and 16mil for 2016. This causes the profit in 2016 to be negative.
Hope to seek your advice, thank you.
Hi Qi Jie,
You are right to remove the exception item in Breadtalk (Do note that government grant is also exception item).
My rough calculation of exceptional item is as follows:
Exceptional Items (EI): $33.2 – $13.5 (management fee) – $0.5 (Income from mall operation) = $19.2
Profit exclue EI: $20.2-$19.2= $1m
Exceptional Items (EI): $29.5 – $11 (management fee) – $0.6 (Income from mall operation) = $17.9m
Profit exclude EI: $10.8-$17.9 = -$7.1m
Breadtalk is a special type of companies because they are growing the business, hence they have to constantly spend their money on capex which will cause depreciation amount in their profit and loss. On the P&L statement shows that Breadtalk is only making $1m profit excluding EI but if you look at the cash flow statement, their operating cash flow is actually making $77.6 million. Hence, it is better to look at breadtalk on a cash flow basis rather then a profit basis because their profit is always understated.
If you want to understand more about Breadtalk depreciation you can look at the case studies video 1 which you can find it here. https://investmentquadrant.com/case-studies/
As for the share split, you do not need to double the price, I believe google price should be correct price. What you need to do is to double the share count.
Hi Qi Jie,
1.So sorry, Just realised I took the wrong figure. Yes you are right so take the profit attributed to owners of the company. As for the exceptional item portion, rental income can be remove from the exceptional item. As for governement grant, I think it is an exceptional item.
2.For the price, the method you just suggested is valid.
3.I think CAGR is usually calculated so that you can use it for the Discounted cash flow model but for Breadtalk, it is better to value them at Price to Cash flow
Please login or Register to submit your answer