by CI Staff
SmartStockResearch.com developed a free and easy-to-use stock valuation and analysis spreadsheet, which takes a company’s financial statements and restates them in an easy-to-understand format. The spreadsheet requires Excel 2007 or better to work properly; however, there is also an OpenOffice version of the spreadsheet.
After downloading and opening the spreadsheet, there will be directions on how to analyze a new stock using the spreadsheet on the Scorecard tab. The first step is to manually download a public company’s income statement, balance sheet and cash flow statement from Morningstar.com; users will need a free Morningstar account to access this information. The statements must be downloaded from Morningstar.com because the spreadsheet relies on a consistent format.
...To continue reading this article you must be a Computerized Investing Subscriber.
Already a CI subscriber? Login to read the rest of this article.
A subscription to Computerized Investing includes a monthly email and access to the CI Website, all of which aim to benefit your investing skills with respect to computers and the Internet.