Lesson ProgressPhase 1 of 6
Phase 1Hook
Hook: Link the Three Statements: Cross‑Sheet References and Integrity Checks
Open with a business scenario where linked statements matter for investor confidence
Phase 1: Tool Pressure
Sarah's Investor Meeting: The Three-Statement Problem
Sarah built three separate statements in Lessons 02–04. Now an investor asks: “If I change one assumption, how does the whole picture shift?” Without cross-sheet links, Sarah has to update every statement by hand—and risk errors.
The Problem: Three Separate Workbooks
Sarah has three tabs: Income Statement, Balance Sheet, and Cash Flow. Each one was built independently. When she updates revenue from $16,500 to $18,000:
- Net Income changes on the Income Statement—but Retained Earnings on the Balance Sheet does not update
- Ending Cash on the Balance Sheet stays the same even though cash flow changed
- She has to recalculate and re-enter numbers on two other tabs by hand
- One typo and the Balance Sheet no longer balances—and nobody notices
The Solution: Cross-Sheet Links
With cross-sheet references, one change flows everywhere:
- Net Income on the Income Statement links to Retained Earnings on the Balance Sheet
- Ending Cash on the Balance Sheet links to the Cash Flow Statement
- Integrity checks flag any mismatch automatically
- One update, three statements, zero manual re-entry
Diagnostic: Will Your Model Hold Up?
Predict which patterns protect the three-statement story when numbers change.
1. Sarah changes a revenue number on her Income Statement. How should the Balance Sheet and Cash Flow Statement respond in a linked model?
2. An investor asks Sarah: 'How do you know your Balance Sheet still balances after you updated the Income Statement?' What proves reliability?
3. Which cross-sheet reference pattern is clearest and least likely to break?
0 of 3 questions answered
Turn and Talk
Discussion Prompt (3 minutes):
- What happens to investor trust if Sarah's statements don't tie together?
- Which two numbers must flow between statements for the model to be credible?
- What would you check first if the Balance Sheet suddenly didn't balance?