Companion files · The Equity Research Analyst
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.
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.
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 listRun by MailerLite, off this site. How your address is used.
Chapters 3 to 21 · Appendix A
The whole case in one workbook: three segments from FY2023A to FY2028E built from volume, price and margins, reported and adjusted EPS, free cash flow and net debt, the scenarios and sensitivities, nine brokers' estimates and the cleaned consensus, the price target by multiples, sum of the parts and a DCF control, the rating grid, the first quarter and the revision that followed, the record of twelve past calls and the position size a fund would take. The Checks sheet puts every printed figure beside its formula, with the gap.
Download the workbook197 KBChapter 22
Pellmore Brands as a candidate receives it: three years of history, the consensus, the price, the time allowed and the marking scheme, and an empty answer layout. Two hours for the model, one for the one-page pitch.
Download the test11 KBChapter 22
The same test solved with live formulas: FY2027 EPS of $3.30, a $53 target and a total return of 8.0 percent, which the grid calls a Hold. Open it after the two hours, not before.
Download the answer key19 KBChapters 4 to 10, 15, 17 and 20
A three-segment earnings model with its formulas in place and its inputs empty, a consensus tracker that flags stale estimates, an earnings-day variance sheet, a rating-grid calculator and a recommendation log scored by the book's rules.
Download the workbook28 KBRead first
What each file is, which chapters each sheet serves, how the Checks sheet works, and the conventions.
Download the read-me3 KBSeven pages to print and use. A4, with margins wide enough for US Letter.
Chapters 10, 14 to 18 and 20 · Appendix B
Appendix B’s first week of coverage with the segment sheet and the three questions, the model-building checklist, Chapter 10’s consensus worksheet (the stale rule, the distance three ways, the bridge), the pre-publication checklist with the four valuation methods and the rating arithmetic, the earnings-day sequence with an empty variance table, the questions to answer before changing a rating, and the recommendation log scored by Chapter 20’s rules. Halvorsen’s figures are printed beside an empty column for yours.
Download the PDF20 KBNew 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.
Chapters 5 and 9 · Case one
The model applies each segment margin to revenue, so a point of price earns $0.13 of FY2027E EPS, like a point of volume. Chapter 9 says a real price increase falls almost entirely to profit. It does the sums: $0.70, five and a half times as much. A point a year short of plan, with costs as planned, takes the estimate to $4.37 and the rating to Hold; about a quarter of a point is enough to lose the initiation Buy.
Chapters 6 and 8 · Case two
Chapter 8 leaves the test to the reader. With $55.0 million a year on the debt and the share count held at 55.6 million, adjusted EPS is $4.35, $4.99 and $5.65, the target $1.43 lower, and leverage 1.07x instead of 1.39x in FY2028E. The Buy holds either way, and the buyback keeps its lead on EPS as long as it retires a net 0.25 million shares a year.
Chapters 7, 8 and 16 · Case three
Restructuring continues at the book’s three-year average, $16.3 million a year (ADDED). Adjusted EPS does not move in FY2027E; conversion falls to 85.3 percent and net debt ends $25.6 million higher. Valued on restructuring-inclusive earnings, the target is $96.54 and the initiation is a Hold: a recurring charge of $11.1 million a year is enough to lose the Buy.
Download the three cases71 KB| The target | Twenty 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 quarter | Estimates up 0.9 percent, shares up 5.6 percent: the rest is a higher multiple |
| The downgrade | A $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.
| 16 Nov 2026 | Added 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 2026 | Companion files published with the book. |
More in corporate finance, markets and banking, with free companion files. The full list of titles is on the author page.