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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access