Sheet 1 has two company lists - one list is by industry and one list is alphabetical. Each list indicates the Sheet # and the Column where you will find the company. For example, Exxon-Mobil can be found in Column A on Sheet 1.

Each company’s ticker, company web site address and Yahoo! Finance Profile address are below the company’s numbers.

Only the historical columns appear. If you decide you want to look more closely at a particular company and possibly do a projection of one or more years in your copy of the Free Cash Flow Worksheet, you will have to manually transfer the numbers to a copy of the Free Cash Flow Worksheet. You MUST double check my inputs to make sure (1) I did not make any errors in transferring data from the company’s financial statements to the worksheet and (2) you agree with my treatment of each item in the company’s financial statements. I am not responsible for any errors or omissions in the 100 Companies Worksheet.

Be sure to note that in ROW 121, some companies have “expense” after the ROW title: “Interest paid”. In those cases, to save time I inputted the interest expense rather than the cash interest paid amount because the company did not provide the cash interest paid number in the GAAP Cash Flow Statement. If you are going to analyze one of these companies, obtain the cash interest paid number in the Notes.

The worksheet's cells are locked and the formulas are hidden.

In addition to comparing companies within an industry, be sure to compare industries by scrolling across worksheets 1 and 2 and looking at just the Percentages (especially the OCFM). Then return to Exxon-Mobil and scroll across again, looking at the Per Share Data, then the Incremental Data and Company’s Reinvestment Return.