Research Analyst Price Targets
Show what the Street thought the company was worth before the deal, honestly discounted.
Seat
IB · ER/HF
Level
Analyst
Runtime
~20 min
Output
Analyst targets page: Excel + slide
What this helps you accomplish
Broker, date, rating and published target per house, with the high, low, median and mean against the offer. Targets are forward-looking and undiscounted, so the honest version of this page discounts them a year at the cost of equity before comparing them with cash today. A board that sees only the undiscounted column is being shown a flattering page.
What you get
Not a description of an output. The file itself, in the conventions a banker, a PE associate or a hedge fund analyst already reads without being told.
{TICKER}_analyst-targets.xlsx
Excel workbook
- 1
Inputs
Shares, net debt, the current price, the offer and the cost of equity the targets are discounted at
- 2
Broker targets ($ per share, highest first)
House, date, rating and published target, with the target discounted one year at the cost of equity beside it
- 3
Offer against the targets ($ per share)
High, low, median and mean on both bases, and where the offer falls against each
- 4
PowerPoint
One slide: a horizontal bar chart of targets sorted high to low, with the offer as a reference line
Where the numbers come from
From the filings: the header only, which is shares, net debt and prices. Every filed figure resolves to its form, period, page, the printed value and a link into the filing on EDGAR. Not from filings: every broker, rating and target, which arrive as illustrative placeholders the build warns about. Replace them from your own research feed. Assumptions are listed on the slide’s source line under "Not from filings", so an assumed input is never read as a filed one.
Run it yourself
python3 skills/deal-slides/build.py analyst-targets --ticker BSX --offer 60Delegate · Verify · Decide
The core L3VLUP principle: AI output is never automatically correct. Know what to hand off, what to check, and what only you can own.
Delegate
AI is good enough to do this.
- • Filling the header from the filings with a citation on each figure
- • Discounting each target a year at the cost of equity
- • Computing the high, low, median and mean on both bases
- • Building the branded slide with the sorted bar chart
Verify
AI accelerates you here, but a professional checks the work.
- • Each broker, rating, target and date against the note it came from
- • That the cost of equity in the column header matches the WACC page
- • That the targets are on the same share class and currency as the offer
- • That no target predates the last set of results without a footnote
Decide
Judgment the human owns. This is the skill.
- • Which houses belong on the page and whether a bank on the deal stays in the set
- • Whether to lead with the discounted or undiscounted median
- • What to say when the offer sits above every target, or below the median
Inputs required
- Company name or ticker
- The offer per share
- The broker list: house, date, rating and published target
- The cost of equity used to discount the targets
- Your own numbers where you would rather not use the default
The workflow
- 1
Resolve the company
A ticker or a name fills the header. The broker rows are placeholders, and the page says so until you replace them.
- 2
Pull the targets
One row per house with the date of publication. A target published before the last set of results is a different kind of evidence.
- 3
Set the cost of equity
It belongs in the discounted column header and it should be the cost of equity the WACC page builds, not a rounder number chosen for this slide.
- 4
Build and compare
The offer against the undiscounted median and the discounted median. The second comparison is the fair one, because a target is a price twelve months out.
- 5
Footnote the stale ones
Anything published before the last results either comes out or carries a footnote.
Run this skill
Any listed company, anywhere. Ticker or name.
Quality checklist
The output isn’t done until every box ticks.
- verify reports zero errors and every derived cell is a formula on blue inputs
- Units are on every table header and chart title, and the subtitle names the currency and period
- The cost of equity is stated on the slide and agrees with the WACC build elsewhere in the book
- The offer falls inside or near the target range, or the notes explain why it does not
- Every target date is after the last results, or the stale ones are footnoted