Lesson 6 of 7

Building a comps table

Step 4 of 6

Do it yourself

Small and practical. Do it now while it is fresh.

Part 1, about 10 minutes. Rebuild Broadcom's row. The inputs, from its 10-K and 10-Qs:

  • Revenue: FY2025 $63.887B; first 9 months of FY2025 $45.872B; first 9 months of FY2026 $71.089B
  • Diluted EPS: FY2025 $4.77; first 9 months of FY2025 $3.02; first 9 months of FY2026 $6.09
  • Diluted shares (quarter to 2 Aug 2026) 4.887B; debt $59.419B; cash $23.975B
  • Close on 19 Nov 2026: $346.65
  1. Work out TTM revenue and TTM EPS.
  2. Work out P/E, market cap, EV and EV/Sales.
  3. After Broadcom reports in December 2026, which inputs would you replace?
Show answers (prices of 19 Nov 2026)
TTM revenue = 63.887 − 45.872 + 71.089 = $89.10B
TTM EPS     = 4.77 − 3.02 + 6.09       = $7.84
P/E         = 346.65 ÷ 7.84            = 44.2
market cap  = 346.65 × 4.887B          = $1,694B
EV          = 1,694 + 59.42 − 23.98    = $1,730B
EV/Sales    = 1,730 ÷ 89.10            = 19.4

After December, use full-year fiscal 2026 revenue and EPS directly, plus the new debt, cash and share count.

Part 2, your own company: about an hour the first time (two sittings is fine). Use the company from your sheet (Module 5 lesson 08), or any listed company you know.

  1. Pick three peers (Module 8 lesson 04).
  2. For all four, from the latest 10-K or 10-Q: TTM revenue, operating income and diluted EPS; debt; cash and investments; diluted shares.
  3. Take each closing price on one date from stockanalysis.com/stocks/TICKER/history/ (free, no sign-in).
  4. Compute market cap, EV, P/E and EV/operating income (EV/Sales if profit is tiny or negative).
  5. Apply each peer's multiples to your company, walking to a value per share.
  6. Write two sentences: what this peer set would imply, and why the peers may not be comparable.
No single answer: completion checklist
  • Same date, GAAP, TTM and diluted shares on every row; sources noted.
  • Round trip: your company's own EV/operating income, walked the same way, lands on (or very near) its close.
  • EV is near market cap unless debt or cash is large.
  • Many large companies' P/Es sit between about 10 and 50 (US market: 34.2 in January 2026). Far outside that, look for a loss, a one-off or a thin margin.
  • Your note gives a range: "what these peers would imply", not "what it's worth".

Next lesson: Multiple traps, four ways a multiple can look cheap or expensive for the wrong reason.