Now that many of i3invetors have received my spreadsheet for Kumpulan Fima, any mistakes have you found? I am sure there are. Any suggestions for improvement? Any thing you want to discuss about the spreadsheet? Any questions? Have you discovered any good stocks to invest using the spreadsheet for analysis? Please share.
KC
Thank you, Bro KC, now need to pull up the socks....and practice...... to check on sendiri punya counter........can see any hidden gems or not...may be by dec 2013 can share a bit loh...
Hi all, Tan KW has been posting many good articles on fundamental investing in i3investors. Very good start for those who want to embark on doing investing basing on fundamental analysis. What I have been doing my spreadsheet are based on those theories, principles and practices.
Dear kcchongnz, Your coverage on KFima has been impressive and would be grateful if you could e-mail me a copy of the KFima spreadsheet for me to decide on the stock, thanks you very much cheah6638@gmail.com
KC, I am a newbies. perhap with your fundamental analysis I will be on the right track to start with. Could you share with me as well azahah.ebiz@gmail.com
if only we have more like kcchongnz & Tan KW at this site, investing in shares would be v rewarding. kc, would it be possible, if it is not too troblesome, to forward a copy to me. tq chua-ls@hotmail.com
Posted by Fat Cat Tim Buddy > Jun 17, 2013 10:32 PM | Report Abuse kcchong.. how you get all this information? u key in one by one or...?
All information is in the Bursa website; the annual reports and quarterly financial reports etc. Yes for the three spreadsheets of "Income statement, balance sheet and Cash flows", I have to key in the figures from the reports one by one, adjusting the figures a bit to suit the spreadsheet, and to suit the analysis and valuations. The analysis and valuation spreadsheets have to be created mostly by myself, for example the ratio analysis, EPV, hybrid PER valuation, Altman Z-score, Pitroski Score, sustainable growth etc. For the spreadsheet on "strategies", I have the "Peter Lynch famous numbers" and the strategies of investing basing high dividend, low PE, EV/Ebitda, P/B, growth strategy stock strategy which I summarize after reading the books from "One Up Wall Street", and Books and valuation materials from Professor Aswath Damodaran and a US finance blogger Jae Jun etc. I have borrowed a couple of valuation spreadsheets from Aswath too, with some modifications to suit my analysis.
Generally if you want to use the spreadsheet, you have to key in the numbers in the financial statements, may have to make some adjustments, then the ratio analysis, valuations, strategies etc may come up automatically, hopefully.
So as I have said the spreadsheets were done by a non-professional like me; both in the sense of accounting and IT, there are bound to to mistakes and errors here and there and some features may not be properly linked to each other. That is why I appreciate feedback so that I can improve it. I particularly happy to see this post below:
Posted by Bzzing > Jun 17, 2013 11:01 PM | Report Abuse Dear KC, forward me a copy please. Based on my knowledge, I should have be able to give you some precious suggestion. My email: alvinphang@hotmail.com
arv18, to assess the good governance criteria and management quality, it is mostly qualitative, time consuming and highly subjective. If I am interested in a company and think of investing in it, what I try to do is to read its financial reports and assess accordingly. Tan KW has posted a good article below which you can refer to:
I have recently commended on the thread "In Search of Excellence" about the management of Pintaras, Willowglen, MBL etc which is a small part of what is posted in the article above.
Hence I tend to rely more on quantitative criteria by reading its annual reports to watch out things below:
1) Any regular RPT not at arm-length? 2) Any financial shenanigans in their financial reports? 3) Is the interest of management aligned with shareholders? Do they own substantial shares in the company? How do they reward themselves, too much pay, too many options granted etc? 4) How well they have been creating shareholder value in term of earnings growth, how much dividends paid out and how equity to shareholders increases throughout the years? Creating free cash flows? How much is the cash return? 5) How well is the asset allocation? Simply invest and destroy value? Increase value by proper capital expenses? 6) Efficiency in operations. ROE, ROIC? Do they earn return above cost of capital? Above cost of equity? 7) etc
KC, I am new to the stock market. I have read books and all, but those are only books. Would be great if I can continue learning from your spreadsheet. Thank you.
This book is the result of the author's many years of experience and observation throughout his 26 years in the stockbroking industry. It was written for general public to learn to invest based on facts and not on fantasies or hearsay....
Posted by kcchongnz > 2013-06-17 16:21 | Report Abuse
Now that many of i3invetors have received my spreadsheet for Kumpulan Fima, any mistakes have you found? I am sure there are. Any suggestions for improvement? Any thing you want to discuss about the spreadsheet? Any questions? Have you discovered any good stocks to invest using the spreadsheet for analysis? Please share. KC