Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.
Comps data sources and access set-up
Comps live or die on where the numbers come from: company filings, a market data terminal for prices and consensus, and the investor relations pages for presentations and reconciliations. Getting logins, plug-ins and a folder of bookmarked filing sources sorted on day one means the first live request is spent on judgement, not on hunting for a password or the right annual report.
First tasks
- List every data source your team uses for comps and request any missing access
- Install and test the terminal spreadsheet plug-in with one price pull
- Bookmark the filing sites for the three countries you cover most
- Write down which terminal fields you will always check against filings
Enterprise value bridge from market cap
Every EV multiple rests on the bridge from equity value to enterprise value, and most comps errors seen in review sit here: cash counted twice, preferred equity missed, a minority interest left out. Building the bridge by hand for three companies, from the latest balance sheet, fixes the logic so each later line item has a clear reason to be in or out.
First tasks
- Write the bridge line items in order on one sheet with a sign for each
- Bridge one familiar listed company from its latest balance sheet
- Repeat for two more companies with minorities or preferred equity
- Compare each result to the terminal EV and explain every gap
Fully diluted share count with treasury stock method
The basic share count on the cover of a filing is rarely the one a buyer or investor would use. Options, restricted units and convertible instruments add shares, and the treasury stock method needs the current price, so the diluted count moves every time the price does. Getting this right once, with a table you can reuse, protects every equity value and P/E on the page.
First tasks
- Find the most recent basic share count and note its date
- Copy the option table from the share-based payment note
- Build the treasury stock calculation linked to the live share price
- Check the result by hand at two different share prices