Financial Analysis · Lesson 9
Testing Management’s
Story
Big Idea
Every investment comes wrapped in a story about the future: earnings guidance, a growth plan, a founder’s pitch model. The question is never whether the forecast is optimistic — forecasts always are. The question is whether it is supportable.
Forecasts are not facts. They are assumptions translated into dollars — and assumptions can be tested.
What to Test in Any Projection
| Component | The support you want to see |
|---|---|
| Revenue | Contracts, order books, market evidence, actual capacity to deliver |
| Costs | Labour, materials, utilities, insurance, financing — with inflation, not frozen at today’s prices |
| Capital spending | Quotes, installation, freight, training, permits — plus contingency |
| Working capital | Inventory build, receivable timing, payroll — growth consumes cash first |
| Debt service | Existing debt plus any new borrowing — principal and interest both |
The most common forecast failures are omissions, not lies: working capital, taxes, and loan principal quietly missing from an otherwise impressive model.
Sensitivity Analysis: Rain on the Forecast
Take the story and ask what happens when the weather turns:
- What if sales are 15% lower than projected?
- What if costs run 10% higher?
- What if the expansion is delayed six months?
- What if customers pay more slowly?
- What if interest rates or input costs rise?
Here is why thin cushions matter. A company projects EBITDA of $150,000 against annual debt payments of $130,000 — covered, barely. Now rain on it:
| Scenario | EBITDA | Debt payments | Covered? |
|---|---|---|---|
| As projected | $150,000 | $130,000 | Barely (1.15×) |
| Sales 15% lower | $90,000 | $130,000 | No (0.69×) |
At a 33% gross margin, a $180,000 revenue shortfall removes about $60,000 of gross profit — and the coverage that looked adequate fails under a modest downside. For the equity holder that means dilution, an emergency raise, or the lenders taking the wheel.
A sound investment should survive more than one version of the future.
Red Flags: Not “Walk Away,” but “Dig Deeper”
- 🚩 Negative operating cash flow or a weak cash balance
- 🚩 Negative working capital or a current ratio below 1.0
- 🚩 Receivables and inventory growing faster than sales
- 🚩 High debt-to-equity or rising reliance on the credit line
- 🚩 Projected margins improving without clear support
- 🚩 Debt payments, taxes, or working capital omitted from projections
- 🚩 Profit driven by one-off items rather than operations
- 🚩 A model whose three statements don’t reconcile
What you do about red flags depends on which side of the table you sit:
- Public stock — the flags feed your decision and your price: pass, size the position smaller, or demand a bigger discount before the risk is worth owning.
- Private deal — you can negotiate protection the way a professional would: staged funding tied to milestones, a board seat, regular reporting requirements, dividend restrictions, or founder capital committed alongside yours.
Interactive Checks
Check 1 of 3
A pitch model shows revenue tripling and margins doubling, but contains no working capital line and no loan principal repayments.
What is the most important problem?
Check 2 of 3
Projected EBITDA is $150,000 against debt payments of $130,000. A sensitivity run at 15% lower sales drops EBITDA to $90,000.
What does this sensitivity result tell an equity investor?
Check 3 of 3
Due diligence on a private investment reveals several red flags: thin cash, fast-growing receivables, and an aggressive forecast.
Which response best reflects how a professional investor uses red flags?
Common Beginner Mistakes
- ❌ Judging a forecast by its polish. Beautiful slides and a reconciling model are different things.
- ❌ Testing only the upside. The downside scenario is the one that decides whether you survive to enjoy the upside.
- ❌ Accepting margin expansion without a mechanism. “Scale” is a word, not a calculation.
- ❌ Forgetting who absorbs forecast misses. In a leveraged company, the answer is the shareholder.
Key Takeaways
- The test is not optimism — it is supportability
- Check the five components: revenue, costs, capex, working capital, debt service
- The deadliest forecast errors are omissions
- Sensitivity analysis: a sound investment survives more than one future
- Red flags mean dig deeper — then price or structure the risk
Next Lesson
Capstone: ACME Inc. — everything you’ve learned applied to one company, ending with the investor’s decision and a scored final test.