Ben Graham Valuation Model

Graham's intrinsic value formula is implemented here, valuing a company from its earnings per share and an assumed growth rate rather than from a multiple borrowed off a comparable. Enter the ticker and the sheet fills in company name, sector, quarterly earnings per share, market capitalization and the current ask price, leaving the growth assumption as the input you own.

Output is a value estimate to set against the market price. It is a blunt instrument by design, better at flagging a gap worth investigating than at producing a precise valuation.