Automated Stock Valuation Suite

What's inside

• Dashboard: live price, key stats including enterprise value and free cash flow yield, five-year financials, and the valuation snapshot up top: Fair Value, margin of safety, analyst target, and the verdict. The snapshot ends with the growth rate the current price already implies, from the reverse DCF.
• Verdict Board: type up to twenty tickers and get each one's value, price, margin of safety, and verdict side by side, from the same model as the DCF tab at the suite's default assumptions. Each row's growth starts from the higher of the analysts' forward estimate and the company's own historical record, and a base-case growth you set on the DCF tab applies to every row while it is filled in.
• Valuation: the Graham formula, discounted cash flow, multiples, and the dividend discount model side by side, with the margin of safety and the acceptable buy price. The Graham value and the multiples earnings leg run on the latest fiscal year's reported earnings per share; the multiples free-cash-flow leg runs on trailing-twelve-month free cash flow per share when the feed carries it, and on the latest fiscal year when it does not. The headline fair value is the strongest value the figures support, taken in a fixed order: the discounted cash flow value when that model can run, then the multiples value, then the forward-estimate model, then the revenue-build value, then the middle of the Models bench. A basis line under the headline names the model and the base it rests on. Three kinds of company take a headline built for their kind first: a real estate investment trust on its funds from operations, a fast grower on a forward discounted cash flow built from analyst estimates, and a cyclical company on the discounted cash flow run over the average free cash flow to firm of the five-year record. A confidence line grades the headline High, Medium, or Low. When the price stands above the fair value, the margin line reads Fair value vs price and shows how far the fair value sits below the price.
• DCF: five years of history, your assumptions, a ten-year projection, bear case, base case, and bull case scenarios, a sensitivity grid, and a reverse DCF that shows the growth the current price already implies. The base starts from trailing twelve-month free cash flow to firm per share. The growth assumption starts from the higher of the analysts' forward growth estimate and the middle of the company's own per-share growth record (free cash flow, earnings, and revenue), held between 0% and 15%, and stays yours to change. Three cells beside the scenario table take your own growth expectations, for the bear case, the base case, and the bull case: fill one in and that scenario runs at your figure, and the base case you set also drives the Verdict Board and the Tracker while it is filled in. Where the discounted cash flow model cannot run on a company's figures, it says NO RELIABLE VALUE instead of printing a number built on nothing, and the headline falls to the next model that can run: NO RELIABLE VALUE is the headline only when no model can compute a value at all.
• Models: the wider bench on one tab. The per-share record: earnings, free cash flow, revenue, and dividends per share over five years, with growth rates and margins. Dividends are summed by fiscal year and by calendar year side by side. Earnings per share run on the basis the filings report: preferred dividends deducted, diluted share counts, each year on its own year's figures, restated where the filings restate them, and the ten-year earnings record on the tab runs on the same basis. Today's P/E and price-to-free-cash-flow against their own five-year range and average. Nine more models: exit-multiple and revenue-build DCF, Peter Lynch fair value, two-stage and H-model dividend models, earnings power value, and the growth sticker group: growth sticker price, margin-of-safety buy price, free cash flow (10% return), and payback time. The bench also carries the Graham Number, residual income, justified price to book, economic value added, tangible book value, net current asset value, the strict net-net value, free cash flow to equity, adjusted present value, a buyout entry price, and a DCF with an EBITDA-exit terminal value, plus analyst growth value, an options-based value, and a moat-adjusted value. For a real estate investment trust, the tab adds funds from operations and adjusted funds from operations per share, with the latest year's build-up printed line by line. Around the models: a balance-sheet record by year, quality records (a nine-check Piotroski score, the Altman Z-Score, the Sloan accruals reading, and a five-factor DuPont breakdown), ten years of P/E and price-to-free-cash-flow history with a monthly valuation band, the latest filed quarter set against the same quarter a year earlier and the prior quarter, automatically selected peers with an eight-check scorecard, and the company profile, recent filings, dividend history, and analyst estimate summary. A probability-weighted scenario value at weights you set, buy prices at margins of safety of 15, 25, 33, and 50 percent, and the range, median, and a published-weight blend across the whole bench: residual income and justified price to book are one model in two forms, so both rows print and the bench count, the median, and the blend count that model once. The bench prints more than twenty values for a fully covered company. Quality pillars, a predictability score, and the If You Bought, dividend reinvestment, and income-target calculators round out the tab. Every model that cannot run says why, in words, beside the blank, and a second explanation card states how each newer model works, in plain language. The three dividend models stand aside when the trailing dividend yield is under one percent of the price.
• Risk: compound growth, volatility, volatility drag, Sharpe and Sortino ratios, and maximum drawdown from five years of monthly prices, with the math shown in full. Every Risk figure is a total return: the math runs on dividend-adjusted prices, so dividends are included.
• Tracker: your holdings with live prices, gains, and weights. A holding shaded green is trading at or below its acceptable buy price. Your holdings never leave your spreadsheet.
• Earnings: the next earnings date for every holding, with analyst EPS and revenue estimates, plus watchlist rows for tickers you do not own yet.
• Summary: the whole analysis of the current company on one page, set to print on a single sheet: the verdict, the headline model values, margin of safety, acceptable buy price, and the key figures.

Built for Google Sheets. Provided as an .xlsx file: open it in Google Sheets, save your own copy, and type a ticker. For Google Sheets only. Does not work in Excel. Every sheet is protected except the input cells, so nothing breaks by accident. Delivery includes the suite, a README, and a full How-To Guide (PDF) that tours every tab. Free updates for a year.

Secure checkout and delivery handled by Gumroad.