• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

4. Analyzing Company Fundamentals > Find the Best Excel Tools for Fundamental A...

Find the Best Excel Tools for Fundamental Analysis for a Fee

If you’re willing to spend money to make money, some stock analysis spreadsheets for a fee offer comprehensive analysis features that are worth the price.

If you don’t want to build your own spreadsheet, a few spreadsheet tools can help you evaluate company fundamentals, while relieving you of only a small amount of cash. None of the products is perfect. However, each one offers some intriguing views of fundamental measures that might augment your current analysis.

Spredgar (http://www.spredgar.com

Spredgar is an Excel add-in that combines SEC filing data and ratio analysis in one product. It collects data for more than 8,000 companies from SEC filings and updates the downloadable data available on the Spredgar web site once a week. The spreadsheet calculates 70 financial ratios, and displays them in tables as well as graphs. By collating data for companies within a SIC code, Spredgar can compare a company’s ratios to the averages for the industry. Spredgar calculates free cash flow from company balance sheets [Hack #39] to track down the real sources and uses of company cash. The spreadsheet also calculates the sustainable growth rate, which indicates how quickly a company can grow from funds generated by the business and not by borrowing money. With several periods of financial data, the spreadsheet can show trends in values. However, it doesn’t provide any advice or instruction on how to evaluate the numbers and trends you see.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint