My In-Progress Stocks Analysis Sheet

Update (6-Jan-2014): I have done for Julius Berger, Dangote Cement, Nestle, GSK, Total Nigeria, PZ, Unilever, Dangote Sugar, Dangote Salt (NASCON) and Oando. Next will be Japaul, Okomu Oil and the banks.
I have also added new ratio analysis: ROIC, Operating Profit Margin, New Cash Flow as a % of Rev, ROA, ROE, Interest Income as a % of Rev and Income tax as a % of Rev.


Today I'll be sharing with you my Stocks Analysis sheet. I'm still working on it, but you will find it useful. I have it in my Dropbox public folder and here is the shared link, My Stock Analysis Sheet, any new data and improvement I make to it is immediately available to you. All you have to do is click on the download link, My Stock Analysis Sheet, once in a month or whenever you feel I must have updated it.

And why am I sharing for free what has taken me great effort to make and that holds all the quantitative data I consider in stock purchase? It's because it's me. I always share. There's joy in sharing. Besides, I'll get the opportunity to be positively criticized and I'll be forced to make it error-free and almost perfect, which will benefit me immensely in the long run.

So here are the snapshots of the analysis sheet. I have done some analysis on Julius Berger Nigeria and Nestle. I'm yet to complete for Dangote Cement and GSK.

It's got the Income Statement part

The Balance Sheet part

The Statement of Cash Flow part

And the Ratios and Projection part (I'm still working on adding some useful Ratios like the Current Ratio, Quick Ratio, Debt to Equity, Intrinsic Value, Margin of Safety, Dividend Yield e.t.c.)

I will also like to issue a disclaimer. I'm not liable for any financial decision (or any decision) you make based on My Stocks Analysis Sheet.