Book · Julian R. Sterling
The analyst's estimate was $0.93. The company reported $0.94, the consensus was $0.92, and the shares rose 5.6 percent by the close. By the afternoon the analyst's own rating grid said the Buy published at initiation had to become a Hold: the price had moved 5.6 percent, the estimates 0.9 percent. Equity research is a set of calculations, and this book shows every one of them.It follows one analyst covering one company, Halvorsen Flow Technologies, a fictional industrial technology business with three segments, from the first model to the initiation note and through a full earnings quarter. Every figure is computed: the segment revenue and margins, reported and adjusted EPS, free cash flow and net debt, the consensus and the distance from it, the price target by four methods, the rating, and the revision after the quarter. It is written for junior sell-side and buy-side analysts, candidates preparing for equity research interviews, and advanced private investors who can read financial statements and want to know what an analyst actually does with them.The models are not described, they are supplied. A companion Excel workbook reproduces every figure the book prints by live formula, with a Checks sheet, alongside blank templates and a timed recruiting test with its answer key. Nothing is locked. The closing pages say where to find them.What you will be able to do:- Build a segment earnings model from volume, price and margins, and test it with incremental margins- Bridge reported EPS to adjusted EPS and decide which adjustments to accept- Clean a consensus, measure your distance from it and explain that distance line by line- Set a price target with multiples, a sum of the parts and a DCF control, and treat their disagreement as a question- Apply a rating grid, including when it is inconvenient- Write the first page of an initiation note- Preview, read and model an earnings quarter in a few hours- Keep an honest record of your calls- Pass a timed modeling test and pitch a stockTwenty-two chapters in four parts: the job, its rules and the company; the earnings model; from estimate to rating; and publishing and living with the call, including information channels, the buy side and the recruiting test. Four appendices give the model conventions, checklists, the rules of the job with their dates, and a glossary.Where the numbers are unflattering, the book says so: the price target is a multiple times an estimate and the multiple is a judgment, the DCF puts four fifths of its value in the terminal year, a distributor survey said orders were up while volume fell, and the analyst's own record is eight right calls out of twelve.
How this book was made: written with the help of artificial intelligence tools, under the author's direction; every figure was checked against its source.
Related titles. The full list is on the author page.