Valuation Calculator

Please note that this calculator is currently disabled for maintenance and update.

Use this form to calculate a value. You will need the diluted earnings per share data for the last 9 years.  Also, here’s some background information and explanation of where this formula comes from.

Current Year EPS:
Previous Year EPS:
2 Years Prior EPS:
3 Years Prior EPS:
4 Years Prior EPS:
5 Years Prior EPS:
6 Years Prior EPS:
7 Years Prior EPS:
8 Years Prior EPS:
9 Years Prior EPS: (for reference only, not needed for calculation)
EPSmg =
Value based on ModernGraham’s estimate of growth =
Value based on 3% growth =
Value based on no growth =

 

21 thoughts on “Valuation Calculator

  1. Hi Ben –

    How do I read the NCAV number published in Stocks and Screens as a dollar figure? I’m used to it representing the price relative to value and that it shouldn’t be higher than about 67% ideally, but I could obviously be misunderstanding that.

    Thanks!

    1. John,

      The NCAV number is the Net Current Asset Value, and its normal unit of measurement is the dollar. What you’ve seen other places is probably actually the Price / NCAV calculation mislabeled as the NCAV itself. The formula for NCAV is NCAV = (Current Assets – Total Liabilities) / Outstanding Shares. To get the percentage figure you’re used to, just take the current price and divide it by the NCAV.

      If a company is trading below its NCAV, there is clearly an opportunity for profit, as theoretically investors could purchase the entire company, pay off all liabilities with the company’s current assets (cash, inventory, etc.) and still have cash left over in addition to any of the non-current assets.

      Obviously, most companies will not trade below NCAV, and in fact most companies don’t even have a positive NCAV to begin with.

      I hope that answers your question. Thanks for asking!

  2. Discover Financial Services (DFS) would be a great company to evaluate! Based on the Modern Graham valuation It is worth $132 but it’s currently trading at $59.

  3. Please tell me what exactly is the meaning of the PEmg Ratio?
    I imagine the lower the number the better it is, but is there a threshold above which we need not dare to go?
    thanks!

    1. Fer,

      The PEmg ratio is the Price / EPSmg. EPSmg is the normalized earnings per share, which is a weighted-average of the last 5 years of earnings data. The PEmg ratio is very similar to the traditional PE ratio, and you are correct that the lower the number is better. The Defensive Investor requires a PEmg ratio less than 20.

  4. Is there any chance of your evaluating PMI,Inc. (Phillip Morris International) ? Have there been back-issues of a stock-evaluation of this stock. I do not mean Altria,Inc., the domestic USA company that sells Phillip Morris products, such as cigarettes, beer, and real estate.

  5. Ben,

    Although it’s not needed for the Valuation Calculator section, I’m wondering where you find your Book Value? I’ve used Yahoo Finance and that gets me close to your numbers but always a little over (which makes them less conservative and therefore undesirable to me).

    Do you calculate it yourself from the official financial reports?

    This website is an incredible resource for a new investor trying to get off on the right foot and I appreciate everything you do here.

    1. Kevin,

      I calculate book value by taking the Total Assets less the Total Liabilities, divided by the outstanding shares. The figures I use for each part of the equation come from MSN Money or the company’s official filings with the SEC.

      I’m glad you’re enjoying the site!

  6. Hi Benjamin –

    I like the new version of the monthly stocks and screens spreadsheet. I don’t know how new it is, I last got one in March I think when there was multiple tables to deal with and this is much nicer.

    Question though, since the new version doesn’t have a column explicitly labeled NCAV, can I assume that the MG Value is the same thing?

    Thanks!

    1. John,

      The spreadsheet is the raw data, and does not include the NCAV. You can find the NCAV by opening the pdf version, which includes all the different screens that you’ve seen before.

      MG Value is the intrinsic value estimate calculated by the ModernGraham valuation model, based on Benjamin Graham’s formula from The Intelligent Investor.

      Hope that helps, and I’m glad you’re enjoying the content!

      -Ben

  7. Hello, I would like to receive a monthly list of stocks that are currently priced below their NCAV. Is this the right site? I subscribed but haven’t received anything yet.

    Thank you!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top