💡 How to Read the Costco Scenario Model
- What it represents: How many dollars investors are willing to pay today for every $1 of Costco's future earnings.
- How to read it: Think of this as a "hype" or "confidence" meter.
- At 45x+: The market views Costco as an untouchable monopoly. Investors are willing to pay a massive premium because they trust its stability.
- At 30x–35x: The market is treating Costco like a normal retail store (like Walmart or Target). This reflects a drop in investor enthusiasm, even if Costco's actual sales remain completely healthy.
- What it represents: The percentage of total sales revenue Costco keeps as profit after paying for inventory, employee wages, transport, and overhead.
- How to read it: Costco intentionally keeps this low (~3.0%) to pass savings to customers.
- If you slide this up to 3.5% or 4.0%, you are simulating Costco raising prices on groceries or successfully cutting operational costs.
- Because Costco does hundreds of billions in sales, a tiny fraction of a percentage change here shifts net profits by billions of dollars.
- What it represents: An immediate increase in the annual membership price across its 84.1 million subscriber households.
- How to read it: This is Costco’s secret weapon. Selling a gallon of milk has a tiny margin, but a membership fee has roughly a 90% profit margin. When you move this slider up, you are injecting pure, near-100% untaxed cash straight into Costco's bottom line without needing to build a single new warehouse.
- Modelled EPS (Earnings Per Share): This is the net result of your operational changes (Net Margin + Membership Fees) divided by Costco's total shares. It tells you exactly how much profit Costco makes per shareunder your custom scenario.
- Implied Share Price: This is the grand finale math equation:This shows you what the stock would actually trade for in the real world under your selected conditions.
ModelledEPS×TargetP/EMultiple=ImpliedSharePrice
- The Flawless Execution Drop: Leave the Net Margin at 3.00% and Membership Fees at $0 (meaning Costco matches its exact financial targets). Now, slide the P/E Multiple down from 45x to 35x.
- The Lesson: Notice how the stock price plummets well below today's price. This proves that a stock can crash purely because investors changed their minds, even if the business performed perfectly.
- The Price-Hike Rescue: Drop the P/E Multiple down to a low 35x. Now, try to slide Net Margin and Membership Fees up until the Implied Share Price climbs back to $1,000.
- The Lesson: This highlights the massive operational scale Costco needs to overcome a bad mood on Wall Street.