Trading Comparables Analysis

Trading comps you can defend line by line: a clean EV bridge and share count, calendarised and cleaned EBITDA and EPS, a peer set with reasons, multiple ranges, footnotes and refresh routines.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Trading Comparables Analysis, and click Install. It goes into your own files, and works offline from then on.

What it installs.

1

Pillar

1

Area

50

Projects

198

Starter tasks

🏦 Investment Banking & Advisory

Trading Comparables Analysis

Running trading comps: choosing the peer set, calendarisation, clean EBITDA and EPS, multiple ranges and footnotes that explain every adjustment.

  1. Comps data sources and access set-up
  2. Enterprise value bridge from market cap
  3. Fully diluted share count with treasury stock method
  4. Spreading a company from annual and interim filings
  5. Last twelve months calculation from quarterly filings
  6. First peer set for a practice company
  7. Comps output page layout and footnote conventions
  8. Personal comps standards sheet
  9. Choosing the pricing date and share price basis
  10. Weekly refresh of a live comps sheet
  11. Earnings season comps update routine
  12. Consensus estimates quality log
  13. Corporate actions watch for the peer set
  14. Comps quality checklist before sending
  15. Footnote library of standard adjustments
  16. Sector multiples tracker for your coverage group
  17. Quarterly peer set review
  18. Source and version log for every comps file
  19. Calendarisation of non-December year ends
  20. Clean EBITDA and non-recurring items
  21. Clean EPS and adjusted net income
  22. Lease accounting effects on EBITDA and EV
  23. Minorities, associates and pensions in the bridge
  24. Convertibles and complex dilution
  25. Choosing the right multiples for a sector
  26. Reading equity research to sharpen comps
  27. Cross-border comps across currencies and standards
  28. Tiering peers into core and secondary groups
  29. Setting the selected multiple range
  30. Outlier treatment and mean versus median
  31. Regression of multiples against growth
  32. Operating benchmarking pages beside the comps
  33. Rebuilding a personal comps model with built-in checks
  34. Data provider figures versus filings check
  35. First live comps for a client pitch
  36. Walking a senior through your comps
  37. Timed comps exercise for a modelling test
  38. Same-day comps refresh after a peer announcement
  39. Comps questions in a technical interview
  40. Student comps for a stock pitch or finance society
  41. Summer intern's first comps request
  42. Moving into comps from audit or accounting
  43. First ninety days of comps as a new analyst
  44. Reviewing junior comps as an associate
  45. Comps in a small bank without a data terminal
  46. Loss-making and high-growth company comps
  47. Financial institutions comps on book value
  48. Real estate and natural resources comps
  49. Sum-of-the-parts comps for conglomerates
  50. Comps in small and thinly traded markets

Where it starts.

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

Make it yours.

Install Trading Comparables Analysis, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.