Introducing the Enhanced Valuation Spreadsheet!

This month marks the start of the third volume of the ModernGraham Stocks & Screens publication.  Thank you to all members for helping to support my continued efforts on this site by being premium members.  To commemorate the occasion, I’ve created new premium content, the Enhanced Valuation Spreadsheet!  More on that in a little bit, but first – the January edition of Stocks & Screens is now available!  Get it here if you’re currently a premium member!

You may notice that I’ve also added two new screens to the list – Companies Trading Below Their Graham Number, and Dividend Growth Companies.  In addition, I’ve removed the mock portfolios from the PDF report for now, but do plan to continue them in a different format (and possibly add a couple of other mock portfolios to the site!).

Now, a little bit about both the Stocks & Screens publication and the Enhanced Valuation Spreadsheet:

Stocks & Screens

Stocks & ScreensBasic Premium Members get access to the Stocks & Screens publication.  Inside this monthly PDF report and spreadsheet is a listing of all the companies reviewed by ModernGraham (currently 552 different companies) in a handy table with some key figures, including dividend yield information.  It then proceeds to screen the companies regarding different topics.  This is a great tool for your research into value investing opportunities.

You can also download the raw data in a monthly spreadsheet including each company’s rating regarding Defensive Investors, Enterprising Investors, or Speculative, the MG Value, the price as a percent of the MG Value, the PEmg ratio, the dividend yield, the beta, the current ratio, the Net Current Asset Value, the market-implied growth rate, consecutive years of dividend growth (not yet available for all companies covered), Graham Number (not yet available for all companies covered) and a link to the latest ModernGraham valuation!

Inside the PDF report, you will find screens for:

  • Undervalued Companies
  • Fairly Valued Companies
  • Lowest PEmg Ratio – Defensive Investor
  • Lowest PEmg Ratio – Enterprising Investor
  • Stocks Trading Closest to NCAV
  • Companies Trading Close to 52 Week High
  • Companies Trading Close to 52 Week Low
  • Companies With the Highest Beta
  • Companies With the Lowest Beta
  • Undervalued Companies with a High Dividend Yield
  • Companies Trading Below Their Graham Number
  • Dividend Growth Companies

In addition, you can review ModernGraham’s Glance at the Dow, a valuation of the Dow Jones Industrial Average as a whole and its individual components!

Preview the Stocks & Screens Content:

Download the September 2014 PDF or the September 2014 spreadsheet.

Enhanced Valuation Spreadsheet

Advanced Premium Members also get access to our Enhanced Valuation Spreadsheet, which is released weekly.  This spreadsheet outlines all of the most recent ModernGraham valuations, provides an overview of the market, gives an opportunity to create a “watch list”, summarizes the latest ModernGraham valuations, and provides a tool for evaluating companies not covered by ModernGraham using the ModernGraham formula.

Please note that this month is considered a beta period, where feedback on the tool is greatly appreciated!  If you have comments on what you would like to see in the spreadsheet, or if you become a member and have any trouble with the spreadsheet, let me know by email or commenting on this post.  For a limited time, the price to become an Advanced Premium Member is discounted.  Early adopters can lock in a subscription rate by signing up now and (hopefully, though not required to lock in the rate) providing me with feedback!

If you are already a premium member and would like to become an advanced premium member to gain access to the Enhanced Valuation Spreadsheet, please upgrade your subscription!

Here’s a sample of what you can find in the Enhanced Valuation Spreadsheet:

Market Overview

This page provides a summary of all of the companies reviewed by ModernGraham.

Enhanced Spreadsheet 1

Watch List

Enter tickers of companies covered by ModernGraham to generate an easy to read summary of those company valuations.

Enhanced Spreadsheet 2

MG Universe

See the key details of every individual valuation by ModernGraham.  The spreadsheet also includes sheets showing only the latest company valuations, the Dow Jones Industrial Average components, and the S&P 500 components.

Enhanced Spreadsheet 3

Valuation Calculator

If a company is not covered by ModernGraham, you now have the opportunity to input financial data and generate a ModernGraham valuation on your own.  All you need is basic balance sheet figures, and Earnings Per Share data, and let the spreadsheet do the rest!  *Note – this part of the spreadsheet “expires” weekly, in order to require you to verify your continued membership by downloading a new version of the spreadsheet.

Enhanced Spreadsheet 4

Also included in premium membership: Access to all individual ModernGraham valuations!

With a premium membership, you can access every ModernGraham valuation of over 550 companies.  The ModernGraham approach is three-fold, and the new design will highlight that fact.  This will enable you to conduct your research as efficiently as possible.  Stage 1 looks to determine if the company is suitable for either the Defensive Investor or the Enterprising Investor; Stage 2 presents ModernGraham’s calculation of intrinsic value and gives some brief comments; and, Stage 3 provides some data to assist with your further research.

The PDF Version

In addition, a PDF version of the entire valuation is included and can easily be printed for your quick reference.  This PDF has all of the information from the valuation, from the Stage 1 analysis to useful links for research purposes.  But don’t just listen to what it includes – take a look for yourself!  Here’s a free sample valuation!

The Data

ModernGraham has always utilized ten years worth of financial data when calculating the intrinsic value of a company.  Now, we download twenty years worth of data in order to provide you with more historical context.  This means that we can look back on the company to calculate the intrinsic value for up to fifteen years, giving you an opportunity to compare how the company’s price has moved in relation to the intrinsic value over time.

Purchasing Options:

There are two tiers of premium membership, each with different billing options.

Basic Membership – Stocks & Screens only!

Single Month – $9.99

Monthly Recurring – $7.99 – 20% off a single month’s price!

Annual Recurring – $74.99 – 22% off the monthly recurring price!

Advanced Membership – Stocks & Screens and the Enhanced Valuation Spreadsheet!

Single Month – $29.99 – only $19.99 for a limited time!  (NOTE:  This offer expired at the end of January 2016).

Monthly Recurring – $19.99 – only $14.99 for a limited time!  (NOTE:  This offer expired at the end of January 2016).

Annual Recurring – $159.99 – only $119.99 for a limited time!  (NOTE:  This offer expired at the end of January 2016).

To become a subscriber, follow these steps:

  1. Register through this page, following the directions to pay.  Acceptable payment options are Visa, Mastercard, American Express, Discover, Paypal, and more.
  2. Once your payment is complete, visit the Subscriber Content page to access the issues.
  3. When you return later, you can login to your account here.


With so much talk about stocks being overvalued, I’m glad to find someone that helps with the legwork of determining value investments. When the downturn occurs I feel confident ill be better prepared than most. I purchased your March screens and am looking forward to April. Thanks.

Excellent modernizing application of Graham’s life work. Thank you!

I just discovered your web site and find it intriguing. I inherited some div stocks 20 yrs ago and just recently decided to reallocate using “Seeking Alpha as ” as a tool and discovered a whole different world. And now with MG further frontiers seem to be unfolding. I’m looking forward to spending my mornings with MG and making my investments with sound tried and true, (and profitable) assistance.

Although Canada based, I’ve just started to dip a toe into
the U.S. market, so, as a novice in that market and Defensive investor, I’ve found your MG summaries very
useful and illuminating.

History shows that people who save and invest grow and prosper. ModernGraham gives us the knowledge and wisdom to help us invest wisely in order to grow our investments.

Invest with knowledge on your side. ModernGraham provides that.

Before I buy a stock, I always check first to see if MG has evaluated it. Buying within your criteria for a defensive investor, I always feel that at a minimum, I will be able to sleep at night and very possibly earn a handsome gain in the process. Thanks for helping me plot an even course through all the “vicissitudes” and profit from Mr. Market’s emotional ups and downs. Keep up the great work!

Since I’ve been using Modern Graham’s recommendations my portfolio is moving into the black! I thoroughly recommend this service as a way to improve buying choices in a volatile market.

Cancellation and Refunds:

If you are unhappy with your subscription for any reason, please send an email to to cancel.  If immediate cancellation is requested, a refund of the most recent month’s subscription fee will be issued.  If you would like to simply cancel at the end of your current billing cycle, the recurring payment will be stopped.

Help improve the product!

Finally, please leave a review or a comment with suggestions for improvements.  I want this product to be a valuable tool for your enjoyment!*

*As always, ModernGraham makes no recommendations for investments in specific situations.  Please consult a registered broker or investment advisor regarding your individual investment decisions.

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.