Companion files · The Equity Research Analyst

A Buy at initiation, a Hold after a good quarter

The Equity Research Analyst: Earnings Models, Price Targets and Ratings by the Numbers, With the Models Supplied.

These are the companion files of the book. The analyst initiates on Halvorsen Flow Technologies at $86.20 with a Buy and a $101 price target, twenty times FY2027 adjusted EPS of $5.06: an expected total return of 18.4 percent. One quarter later the company beats and raises guidance, the estimates move 0.9 percent and the shares 5.6 percent, and the firm's own grid turns the Buy into a Hold. Every figure in the book is a live formula here. No sign-up, no email is asked for.

All the companion files and the read-me, in one archive334 KB

The archive holds the four workbooks, seven working documents to print and three new worked cases, with 00_START_HERE.md at its root. Last revised 16 November 2026. No macros, no circular references, no external links in any workbook. They recalculate in Excel, LibreOffice or Google Sheets.

Get an email if these files are corrected

Optional. When a workbook on this page is corrected or a new worked case goes up, readers on the list get one email, plus a short note when a new book comes out. The downloads do not need it.

Join the reader list

Run by MailerLite, off this site. How your address is used.

The files

The documents the chapters describe

Seven pages to print and use. A4, with margins wide enough for US Letter.

Three cases the book does not work

New material, not a restatement. Each case takes a situation the book names and does not compute. Each is one workbook: the note is the first sheet, then the book’s base model rebuilt in live formulas (it reproduces $5.06 of FY2027E adjusted EPS and $724.6 million of net debt in FY2028E), the case beside it, and a checks sheet. Any value the book does not give is marked ADDED.

Three numbers to reproduce first

The targetTwenty times FY2027 adjusted EPS of $5.06: $101. From $86.20, with the dividend, a total return that clears the 15 percent Buy line
The quarterEstimates up 0.9 percent, shares up 5.6 percent: the rest is a higher multiple
The downgradeA $102 target from $93.25 leaves 10.6 percent of expected return: a Hold on the firm's grid

The files are provided as they are, without warranty of any kind. The models are illustrative: Halvorsen Flow Technologies, Pellmore Brands, the analyst, the brokers and every figure are fictional, and nothing here is a recommendation to buy or sell any security. The rules cited in the book are described as they stood when it was written; your compliance department has the current text.

What changed, and when

16 Nov 2026Added seven working documents to print (first week of coverage, the model checklist, the consensus worksheet, the pre-publication checklist, the earnings-day sequence and variance table, the questions before a rating change, the recommendation log) and three new worked cases: a point of price that falls to profit, the buyback against repaying debt, and a fourth restructuring. The four workbooks are unchanged and their checks still pass.
25 Sep 2026Companion files published with the book.

Also by Julian R. Sterling

More in corporate finance, markets and banking, with free companion files. The full list of titles is on the author page.