Saving time with Gurufocus and Google Sheets. Plus, the usefulness of Free Cash Flow.

Gurufocus is a website that presents historical financial data in one giant table.  You can use Google Sheets to pull that data into a spreadsheet and perform your own calculations.  This is much faster than going into a 10-K to copy+paste the financial data.  Here is my spreadsheet that automatically pulls data from Gurufocus.  (EDIT 9/9/2017: unfortunately the spreadsheet does not work very well anymore due to changes to the Gurufocus website.)  To use it, sign in to your Google account (registration is free) and then make a copy of the spreadsheet.

Calculations that I like to perform

Continue reading

Advertisements