Show HN: I put employees inside S&P 500 market-cap bubbles

(bigwhalehunting.com)

104 points | by vfxGer 2 hours ago

17 comments

  • paxy 1 hour ago
    Number of employees isn't a straightforward calculation.

    - A lot of companies have part time, seasonal and contract workers (e.g. Amazon and Walmart). For some this even makes up the majority of their workforce.

    - Some companies operate on a franchise model, and corporate employees are very limited. For example the 414K employees listed for Marriott aren't directly employed by them. But then you don't apply the same logic to McDonalds, where you are only counting the corporate employees.

    - Holding companies (like Berkshire Hathaway) show the full employee count of their portfolio companies even through they may only own a small share. And again the logic isn't consistent because you are only counting 714 employees for Welltower, which is also a holding company.

    Collecting incomplete or incorrect data and adding a hunded disclaimers at the end of the report is standard LLM behavior. Actually valuable analysis of this sort needs a lot more human effort.

    • vfxGer 1 hour ago
      Fair point, I was aware of that and mention it in the accompanying blog https://bigwhalehunting.com/blog/workforce/
    • Grombobulous 1 hour ago
      The blog post OP linked puts more context into it, and I think it also makes it clear that they’re not trying to make an apples to apples comparison. It’s a tool that can aid in visualizing how different companies can be structured.
      • malfist 18 minutes ago
        Except this visualization is literally an apples to apples comparison
    • t1234s 38 minutes ago
      I imagine Tesla has a vast amount of contract workers with all the construction they do.
    • vfxGer 40 minutes ago
      Berkshire reports employees across its consolidated subsidiaries, while Welltower's 335,000+ operating-partner employees work for separate companies. I'm using reported employee counts consistently, but you're right that different corporate structures make comparisons imperfect.
    • mbesto 1 hour ago
      > Collecting incomplete or incorrect data and adding a hunded disclaimers at the end of the report is standard LLM behavior. Actually valuable analysis of this sort needs a lot more human effort.

      Or it's classic modern journalism that gets clicks. LLMs are just mimic'n human behavior.

      • vfxGer 35 minutes ago
        No one is calling this journalism especially not me.
  • tomrod 33 minutes ago
    Alphabet and Meta are misclassed, they are information technology.

    Tesla should (probably) be in industrials, as a car and battery tech company.

    Amazon is hard to class, you might check if they break out to subsidiaries for AWS versus consumer retail. Part is definitely competing with Walmart.

    • eep_social 14 minutes ago
      At a glance, I think the author used S&P sector categorizations. They were set in 2018 and intentionally split the mega caps/FAANG/MAG7 across multiple sectors based on some hand waving about “primary” revenue source at that time.

      From a finance perspective I think they’re a _little_ weird but functional (NVDA moves with semis, MSFT with software, etc) whereas from a tech perspective I’d say very weird until you learn about the backstory and what motivated it.

  • beefman 5 minutes ago
    There's a linear relationship between revenue and employees across sectors. The desired visualization is the linear fit where outliers can be seen.

    Market cap is a function of earnings and earnings growth.

  • soared 1 hour ago
    1. The legend uses different icons than the visualization 2. Why would you purposefully make every bubble empty? Change the scale to 1000 employees otherwise it’s deceptive. 10k employees is arbitrary.
    • QuantumNomad_ 1 hour ago
      1000 or 10k per stick figure is equally arbitrary.

      What they actually need to do is scale the size of the stick people correctly.

      For example, one meaningful measure might be to scale it so that one stick person fits inside a circle with area corresponding to the amount of money they have to earn in total for that number of people to cover all their living expenses and some amount of savings left over. I am sure some statistical bureau has some meaningful dollar amount of some sort that makes sense to use.

      • mlyle 1 hour ago
        Just make it so that the companies that employ the most per market cap are filled, so we can see how empty the rest are.
        • jameshart 9 minutes ago
          That rather appears to be what they have done, given that the company with lowest market cap per employee has a circle full of people.
  • fhdkweig 1 hour ago
    Curious why the comment by the poster got flagged but not the full post. I like when the poster includes a comment describing the content and reasons why he liked it.
    • codingdave 1 hour ago
      I dislike that. IMO, if the content cannot stand on its own, it did not need to be posted. A comment that adds something to it, to initiate a discussion, is fine. But a comment that just says what that post is? That is neither interesting nor engaging.

      Such comments also encourage the idea that people "own" the threads they start. I've seen people get mad when people take the conversation in a direction they did not want, or add instructions telling people what to talk about and putting constraints around discussion. Such things stifle interesting conversation.

      So I land heavily the opposite direction. Just post, and leave it at that. If the community finds it interesting, discussion will ensue.

      Now, Show HNs are their own thing. An initial explanation is absolutely appropriate for a show HN. But it should be part of the post, not a comment.

      • fwipsy 59 minutes ago
        Even so, not sure it qualifies for flagging
    • ThrowawayR2 8 minutes ago
      [delayed]
    • dmayle 1 hour ago
      I suspect it was one of the content review bots. In my first Show HN post, I handwrote the comment, but using a bulleted list style suggested by an AI agent, and that got flagged. I reached out to the mods, and they told me to switch to prose, which passed muster.
  • RussianBot9580 17 minutes ago
    Definitely some strange inclusions and exclusions. "Information technology" has NetApp but not Everpure, even though they have the same market cap and are in the same space. Qnity and Jabil are included with half the market cap.
  • yoz-y 45 minutes ago
    TIL that Broadcom is a 1.6T company.
  • delichon 35 minutes ago
    A very useful perspective of the market. I love how now you can just delegate a bot to keep it up to date. I hope you do, and add visualizations for the trends.
  • iandanforth 29 minutes ago
    Very cool! It would be nice to have a constant dollars option. I always like to be able to correct for inflation.
  • wastedpotencial 40 minutes ago
    Offtopic: It's infuriating how I clicked the site and it wasn't loading. Scrolled the comments looking for a "hug to death" mention but found none, then realized I live in Spain and today is football day...

    I'll check the site when a football private company allows me to.

  • NooneAtAll5 20 minutes ago
    how do I zoom? there's no + and - buttons and I don't see people icons
  • samayashar 1 hour ago
    Welltower and Palantir are doing an amazing job! A comparison with NVIDIA in terms of market cap per employee isn't realistic here, but perks to them for the utility that each employee is bringing to the table.
    • willio58 42 minutes ago
      > Welltower and Palantir are doing an amazing job!

      It’s funny to read that from this becuase I read it as these companies are so good at exploiting capitalism that they can make this much profit and benefit so few actual people in the country. It’s like they’re a leech on the country, rather than companies to be proud of.

      If we have hundreds of hyper-successful companies but we have people going into medical bankruptcy for a cancer diagnosis, I’d say America is failing at taxing these companies enough to fund what actually matters in society.

  • fnord77 43 minutes ago
    I think revenue per employee is more interesting. By this measure, tech companies are minuscule compared to energy and real estate companies.

    https://i.imgur.com/4DPs1Io.png

    https://i.imgur.com/LgFx831.png

  • brador 1 hour ago
    What will this look like after the coming AI investment crash/growth stagnation inflection point?

    It’s gonna be a wild ride to 2030.

  • insiderprint 58 minutes ago
    [flagged]
  • aburayhan 1 hour ago
    [flagged]