TemplateVault

Premium templates, guides, and digital tools to save you hours and level up your workflow.
2 joined
Profile picture
Ethan SibbernProfile picture@esibbern·Apr 27

5 Red Flags Every Analyst Should Spot in a 10-K Filing

Reading a 10-K isn't about reading every word — it's about knowing where to look for trouble. These five red flags have preceded some of the biggest blowups in corporate history. Train yourself to spot them early.


1. Revenue Recognition Changes


Where to look: Accounting policies section + MD&A


Revenue recognition is the #1 area where companies get creative. Watch for:


  • Switching from point-in-time to over-time recognition — this can artificially smooth or accelerate revenue

  • Changes in how "performance obligations" are defined — sometimes companies unbundle or rebundle contracts to shift when revenue hits

  • Significant increase in unbilled receivables or contract assets — revenue is being recognized before cash is collected

  • Sudden improvement in revenue growth without corresponding cash flow growth — the profit might not be real


The question to ask: "If I only looked at cash collected from customers, would the growth story look the same?"


2. Related Party Transactions


Where to look: Footnotes (usually Note 15-20+)


Related party transactions aren't always bad, but they deserve heavy scrutiny:


  • Leasing office space from a company owned by the CEO

  • Purchasing services from firms where board members have financial interests

  • Loans to executives or their family members

  • Revenue from entities with shared ownership


Why it matters: These transactions may not be at arm's length. They can be used to inflate revenue, hide expenses, or siphon value. Enron's off-balance-sheet entities were technically "related parties."


The question to ask: "Would this transaction exist if the related party were a stranger?"


3. Going Concern Language


Where to look: Auditor's report + Footnote 1 (Basis of Presentation)


This is the most serious red flag on this list. If the auditor includes "substantial doubt about the company's ability to continue as a going concern," it means the company might not survive the next 12 months.


Watch for softer versions too:

  • "The company's continued operations are dependent upon..."

  • "Management's plans to address these conditions include..."

  • Waivers on debt covenants mentioned in the debt footnote


The question to ask: "Can this company pay its bills for the next 12 months without raising new capital?"


4. Off-Balance Sheet Obligations


Where to look: Footnotes on leases, commitments, variable interest entities (VIEs), and guarantees


Just because something isn't on the balance sheet doesn't mean it can't hurt you:


  • Operating leases (less of an issue post-ASC 842, but legacy structures remain)

  • Purchase commitments — long-term contracts to buy materials at fixed prices

  • Variable Interest Entities (VIEs) — entities the company doesn't consolidate but still bears risk from

  • Guarantees and contingent liabilities — lawsuits, environmental obligations, product warranties


The question to ask: "If I added all off-balance sheet obligations to the balance sheet, how would the leverage ratios change?"


5. Auditor Changes or Qualified Opinions


Where to look: The auditor's report (very first or last section of the 10-K)


This is one of the fastest red flags to check:


  • Auditor change — when a company switches auditors, ask why. Sometimes it's routine; sometimes the auditor was asking too many hard questions

  • Qualified opinion — the auditor found something they couldn't sign off on cleanly

  • Material weakness in internal controls — the company's own systems for preventing errors or fraud have gaps

  • Disclaimer of opinion — the auditor couldn't get enough evidence to form an opinion at all (extremely rare and extremely bad)


The question to ask: "Did the company leave the auditor, or did the auditor leave the company?"


Building the Habit


You don't need to read every 10-K cover to cover. But every time you open one, run through these five checks. It takes 15 minutes and can save you from catastrophic mistakes.


The analysts who catch problems early aren't smarter — they just have a systematic checklist they run every single time. Build yours, and make it a habit.


What's the biggest red flag you've personally caught in a filing? Share it in the comments.

Profile picture
Ethan SibbernProfile picture@esibbern·Apr 27

Market Sizing Questions: A Step-by-Step Framework That Actually Works

Market sizing questions show up in consulting interviews, VC pitches, and strategic planning. Most people overthink them. Here's a repeatable framework that works every time — plus the anchor numbers you should have memorized.


Two Approaches: Top-Down vs. Bottom-Up


Top-Down: Start with a large known number and narrow it down.

"US population → relevant demographic → usage rate → price = market size"


Bottom-Up: Start with the unit economics and scale up.

"Number of locations × customers per location × average spend × frequency = market size"


Which to use? Top-down works better for broad consumer markets. Bottom-up works better for niche or B2B markets. In interviews, state which approach you're using and why. Bonus points if you triangulate with both.


Anchor Numbers You Should Memorize


These are your building blocks. Memorize them:


Data Point

Number

US Population

~335 million

US Households

~130 million

US GDP

~$28 trillion

Average US Household Income

~$75,000

US Life Expectancy

~78 years

US Workforce

~165 million

US Number of Businesses

~33 million

US Smartphone Penetration

~85% of adults

World Population

~8.1 billion

Average Americans per Household

~2.5


With just these 10 numbers, you can size almost any consumer market in the US.


Worked Example: "How big is the US dog grooming market?"


Step 1: Establish the base

  • US households: ~130 million

  • % that own dogs: ~45% → ~58 million dog-owning households

  • Average dogs per household: ~1.5 → ~87 million dogs


Step 2: Estimate usage

  • % of dog owners who use professional grooming: ~40% → ~35 million dogs groomed professionally

  • Average grooming frequency: ~4x per year


Step 3: Apply pricing

  • Average cost per grooming session: ~$55


Step 4: Calculate

  • 35 million dogs × 4 visits × $55 = ~$7.7 billion


(For reference, actual estimates put the US pet grooming market at $8-10 billion — we're in the right ballpark.)


Step 5: Sanity check

Always gut-check your answer. $7.7B for a mature, fragmented services industry serving 87 million dogs? That passes the smell test. If you'd gotten $500 billion or $200 million, you'd know something was off.


Common Mistakes to Avoid


1. Not stating assumptions explicitly

Every number should come with a brief justification. "I'll assume 40% of dog owners groom professionally because grooming is more common for certain breeds, and many owners do it themselves."


2. False precision

Don't say "$7,722,500,000." Say "roughly $7-8 billion." You're estimating, not auditing.


3. Forgetting to segment

Not all customers are the same. Segment by geography, income level, or use case when it matters. A premium grooming salon in Manhattan charges very differently than a mobile groomer in rural Texas.


4. Skipping the sanity check

Always compare your answer to something known. "The US restaurant industry is ~$900B, so $8B for dog grooming — a much smaller niche — feels reasonable."


5. Not considering the supply side

Sometimes it's faster to size from supply. "There are ~X grooming salons in the US × average revenue per salon = total market." This can be a great cross-check.


The Formula


When in doubt, every market sizing follows this skeleton:


Number of potential customers × % who buy × frequency × price = market size


That's it. The art is in how you estimate each variable and how clearly you communicate your logic.


Practice this framework on 3-4 random markets this week — coffee shops, tutoring, car washes — and it'll become second nature fast.

Profile picture
Ethan SibbernProfile picture@esibbern·Apr 27

The LBO Model Explained: What PE Firms Actually Look For

Leveraged buyouts sound intimidating, but at their core, they follow a simple logic: buy a company using mostly debt, improve it, and sell it for more than you paid. Here's how it actually works — and what PE firms care about when they evaluate a deal.


The Basic Mechanics


An LBO has four moving pieces:


1. Sources & Uses

This is the foundation. "Uses" = what you're spending (purchase price + fees + financing costs). "Sources" = where the money comes from (equity from the PE fund + various layers of debt).


A typical deal might be 60-70% debt and 30-40% equity. The more debt you can use, the less equity required, and the higher your potential return — but also the higher the risk.


2. The Operating Model

Project the company's revenue, EBITDA, and free cash flow over a 5-7 year hold period. This drives everything downstream. PE firms obsess over EBITDA because that's what services the debt and ultimately determines the exit value.


3. Debt Paydown Schedule

Excess cash flow pays down debt over the hold period. As debt decreases, equity value increases — even if the company doesn't grow at all. This is the "magic" of leverage.


4. Exit & Returns

At exit (usually year 5), apply an exit multiple to the projected EBITDA. Subtract remaining debt. What's left is equity value. Compare that to the initial equity check to calculate your IRR and MOIC (multiple on invested capital).


The 3 Value Creation Levers


Every PE return comes from some combination of these three drivers:


1. Operational Improvement (EBITDA Growth)

  • Revenue growth through pricing, new markets, or add-on acquisitions

  • Margin expansion via cost cuts, procurement optimization, or operational efficiency

  • This is the "real" value creation and what the best firms focus on


2. Multiple Expansion

  • Buy at 8x EBITDA, sell at 10x EBITDA — instant value creation

  • Driven by market conditions, improved growth profile, or repositioning the business

  • Least controllable but often the biggest driver in bull markets


3. Debt Paydown (Financial Engineering)

  • Using free cash flow to reduce debt over the hold period

  • Even with zero growth, paying down 50% of the debt meaningfully increases equity value

  • This is why PE firms love companies with stable, predictable cash flows


What Makes a Great LBO Candidate?


PE firms screen for these characteristics:


  • Stable, predictable cash flows — you need to service debt payments without fail

  • Low capex requirements — more free cash flow available for debt paydown

  • Market leadership or defensible niche — downside protection

  • Margin improvement opportunities — clear operational upside

  • Strong management team (or a clear plan to upgrade it)

  • Reasonable valuation — entry multiple matters enormously for returns


The Numbers That Matter


When you're building or reviewing an LBO model, focus on:


  • Entry multiple — every turn of EBITDA at entry dramatically impacts returns

  • Leverage ratio (Debt / EBITDA) — typically 4-6x for a standard deal

  • IRR target — most firms target 20-25%+ IRR

  • MOIC target — typically 2.0-3.0x+ over a 5-year hold

  • Debt paydown as % of total return — tells you how much is "real" vs. financial engineering


Key Takeaway


An LBO model isn't just a finance exercise — it's a framework for thinking about business value creation. Understanding what drives returns helps you evaluate any investment, not just PE deals.


The difference between a passing grade and an impressive one? Clean, well-structured models that clearly show your assumptions and let the reviewer stress-test scenarios instantly.


What part of the LBO model trips you up the most? Let me know below.

Profile picture
Ethan SibbernProfile picture@esibbern·Apr 27

How to Break Down Any Company's Financials in 30 Minutes

Whether you're prepping for an interview, evaluating a stock, or working on a case study — the ability to quickly dissect a company's financials is a superpower. Here's the exact framework I use to break down any public company in 30 minutes flat.


The 3-Statement Waterfall (10 Minutes)


Don't read financials top-to-bottom like a novel. Follow this priority order:


1. Income Statement — "How does this company make money?"

  • Start with revenue: is it growing? What's the mix (product vs. service, recurring vs. one-time)?

  • Jump to gross margin — this tells you the business model's fundamental economics

  • Then operating income — how efficiently does management run the business?

  • Finally, net income and EPS — the bottom line after interest, taxes, and one-time items


2. Cash Flow Statement — "Is the profit real?"

  • Compare net income to operating cash flow. A persistent gap is a red flag

  • Check capex intensity: FCF = Operating Cash Flow − Capex

  • Look at the financing section — are they issuing debt or buying back shares?


3. Balance Sheet — "How healthy is the foundation?"

  • Cash & equivalents vs. total debt — can they weather a downturn?

  • Working capital trends (current assets minus current liabilities)

  • Goodwill & intangibles as a % of total assets — high numbers mean acquisition-heavy strategy


The 6 Ratios to Calculate First (10 Minutes)


These six numbers give you 80% of the picture in 20% of the time:


Ratio

Formula

What It Tells You

Gross Margin

Gross Profit / Revenue

Business model quality

Operating Margin

Operating Income / Revenue

Management efficiency

ROE

Net Income / Shareholders' Equity

Return on invested capital

Debt-to-Equity

Total Debt / Total Equity

Leverage risk

Current Ratio

Current Assets / Current Liabilities

Short-term liquidity

FCF Yield

Free Cash Flow / Market Cap

Valuation sanity check


Pro tip: Don't just calculate these once — compare them across 3-5 years to spot the trend. A declining gross margin over 3 years tells a much bigger story than a single snapshot.


Pattern Recognition (10 Minutes)


Spend your last 10 minutes asking:


  • Revenue quality: Is growth organic or acquisition-driven? Recurring or lumpy?

  • Margin trajectory: Expanding margins = operating leverage. Compressing margins = competitive pressure.

  • Capital allocation: Are they investing in growth (capex, R&D), returning cash (dividends, buybacks), or paying down debt?

  • Cash conversion: High net income + low FCF = aggressive accounting. Be skeptical.


The Bottom Line


This framework works whether you're analyzing Apple or a small-cap industrial company. The key is consistency — run the same process every time, and you'll start spotting patterns instantly.


Having structured templates for this workflow cuts the 30 minutes down to 15. When your formulas, formatting, and ratio calculations are already built, you just plug in numbers and focus on what matters: the analysis.


What's your go-to first thing to look at when you open a 10-K? Drop it in the comments.

Profile picture
Ethan SibbernProfile picture@esibbern·Apr 27

The 3 Slides That Actually Matter in a Consulting Pitch Deck

I've reviewed over 200 pitch decks from MBA students and junior consultants. Most of them are 30+ slides of noise.


Here's the truth: decision-makers spend 80% of their attention on just 3 slides.


1. The Problem Framing Slide

Not "here's the problem." That's lazy. The best slide reframes the problem in a way the client hadn't considered. It shows you've done the thinking they haven't.


2. The "So What?" Slide

Most decks bury the insight 15 slides deep. Put your key finding on one slide, front and center. If someone only sees this slide, they should understand your entire recommendation.


3. The Implementation Roadmap

Consultants love to recommend things. Clients want to know how. A clear 90-day roadmap with owners, milestones, and quick wins beats a fancy framework diagram every time.


Everything else is supporting evidence. Important, but not the main event.


I built TemplateVault because I got tired of watching smart people lose deals over formatting. Every template in the vault is structured around these principles — clear framing, sharp insights, actionable next steps.


If you're prepping for case competitions, client presentations, or just want your work to look as sharp as your thinking — check it out.