Updated Free Graham Net Net Spreadsheet

February 9th, 2010 | Comments (3)

Free Graham Net Net Spreadsheet

Free Graham Net Net Spreadsheet

Calculations – Free Graham Net Net Spreadsheet | Flickr: bumbledad

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

Screenshot

How to Install

Full credit goes to Randy from the SMF yahoo groups for the add-in that is required to run the spreadsheet.

Download and read the install guide. It has ALL the details of how to install.

About Jae Jun


Jae Jun is the founder of Old School Value. He is on a mission to provide practical and actionable value investing tools, tutorials and educational material to help empower the individual investor. Keep in touch with Jae via any of the methods linked below.

Get Tips and Strategies to Achieve Higher Returns
Bonus: Get 9 FREE Investing Spreadsheet Calculators
  • Alan

    Thanks for this update. I currently have the premium version of the stock value spreadsheet. When I download this net-net spreadsheet, it downloads but what I saw appeared to be a screen shot in excel of the spreadsheet with another icon at the top to enable downloading. I click that, and I get directed to the premium spreadsheet page, where there is no mention that I can find of the net net spreadsheet. I went back to the excel spreadsheet and yes, I can put another symbol in the program and gather information on that company, so it works, in a way. But it is not installed in the sense that it is available to me if I close excel and open it again. I have to go back to the download files and click on the downloaded file to open it. In the install guide there does not seem to me to be an answer to this situation. I use Windows Vista and excel 2007. I need some instruction. Thanks.

  • http://www.oldschoolvalue.com Jae Jun

    @ Alan,

    The icon you see at the top of the spreadsheet is a form of ad that is in the free version so you can ignore that.

    First, make sure you save it to your computer and don’t just “open it”. Then just enter the ticker in the yellow box labeled “Ticker” and click the run button.

    That’s all there is.

    The future upgrade to the premium version will include this spreadsheet as well but in a better way.

x
Receive Email Tips and Strategies on Achieving Higher Stock Returns

Bonus: FREE Set of 9 Investing Spreadsheets