Here's one of the key spreadsheets I use for analysing stocks:
It makes a lot of the work easier, because all I need to do is to input the relevant financial information from the company's annual report(s), and the financial ratios are then automatically calculated for me.
If you want a solid strategy and investment framework to follow for spotting profitable stocks, I would highly recommend you use this as well.
Where can I get it?
This spreadsheet was designed and formulated by The Fifth Person for Investment Quadrant, which I feel is Singapore's most underrated course teaching value investing.
In case you're not familiar with value investing, it is/was the method that make Warren Buffett rich - his total net worth is over 88 billion dollars now!
Value investing is also my favourite method to invest, because I've gotten returns ranging from 30% - 50% on undervalued stocks in a...