I was browsing through the SMF Yahoo Groups and I came across a nice looking spreadsheet that graphs up to 10 years of information. When I look for or create spreadsheets my focus is on ease of use and pleasing aesthetics. If at first glance the spreadsheet is overwhelming, no one will want to use it, including myself. With that in mind, I bring you this new spreadsheet.
What It Does
Enter any ticker (not all information for financial companies will be displayed) and the spreadsheet will grab the following data and more.
- Cash Flow (Continuing Operations)
- Enterprise Value
- EPS (Diluted, Total Operations)
- Market CapitalizationMagic Formula Investing — Earnings Yield
- Magic Formula Investing — Return on Capital
- Net Income (Continuing Operations)Net Profit
- Net Profit Margin
- Operating Revenue
- Piotroski F-score
- Return on Assets (ROA)
- Return on Equity (ROE)
- Stock Price
- Current Ratio
- Quick Ratio
How To Use
All the formulas and data have been updated in the Data tab so it should work for everyone from the get go.
Installation of the SMF-addin is required and the installation instructions can be found here.
There is only one input field and that is the yellow box in the top left corner. To change the chart type, select or click on the title of each graph and a drop down box will appear which will allow you to select which charts you want to display.
Recommended Additional Usage
Full credit goes to the SMF add-in group for providing the template.
You can now download the premium version with the 10 year charts incorporated. Click here.