Free Graham Net Net Spreadsheet
How to use the Free Graham Net Net Spreadsheet
Of the free stock spreadsheets that I offer, the Free Graham net net spreadsheet has been downloaded hundreds of times and is a favorite among many people because of its ease of use. All you have to do is enter a single ticker and that’s it. Just make sure the numbers are up to date by verifying with the latest filings from the SEC.
Since the initial version, I’ve gotten some more experience with building spreadsheets since then so I’ve cleaned it up a little on the back end to support future variations I have planned for the premium stock value spreadsheets.
The main change to the spreadsheet is the addition of NCAV (Net Current Asset Value) and a data tab where most of the relevant information is stored in case you want to expand on the spreadsheet yourself.
Benjamin Graham Asset Valuation
If you are new to the Graham concept, here are the formulas used to value the assets of a company.
NCAV = Current assets (cash, inventories and accounts receivable) – Total Liabilities
Net Net Working Capital = Cash and short-term investments + (0.75 * accounts receivable) + (0.5 * inventory) – Total Liabilities
How to Install
Download and read the install guide. It has ALL the details of how to install.
What is Old School Value?
Old School Value is a suite of value investing tools designed to fatten your portfolio by identifying what stocks to buy and sell.
It is a stock grader, value screener, and valuation tools for the busy investor designed to help you pick stocks 4x faster.
Check out the live preview of AMZN, MSFT, BAC, AAPL and FB.