Friday, 1 January 2016

A new measure for the spreadsheet

I was doing some reading while sipping my cup of tea in bed this morning and the article was emphasising the importance of free cash flow, and the ratio of free cash flow to operating cash flow. I immediately saw an opportunity for a new column on the analysis spreadsheet, so set about trying to find this information.

It's not easy to find!

Most of my analysis is done using the advfn.com financials - although they sometimes contain errors so have to be cross referenced with actual financial statements before buying. However, when ploughing through the A-Z of shares, I need something quick so I can eliminate rubbish straight away

Unfortunately advfn.com doesn't really deal with cash flow very well - there was no way I could create my ratio using their figures

After about 2 hours of frustration I found this route into a site that seems to have no way of navigating to this screen, other than saving the URL and typing in the relevant stock code

http://www.marketwatch.com/investing/stock/shb/financials/cash-flow?countryCode=UK

This one's for Shaftesbury, which I recently sold. It makes very interesting reading - they are investing heavily in property, but to such an extent that they never have any free cash flow. I hadn't picked this up from my previous research.

Applied to my existing portfolio it makes interesting reading, and will have an influence on what I keep and what I top up with.

Still no sign of the transfer from StockTrade into my bank account, so still no way to top up the pension. Hopefully it will be there in time to make a trade on Monday...

No comments:

Post a Comment