Unit 3 • Lesson 50.8h
Link the Three Statements: Cross‑Sheet References and Integrity Checks
Students move from building individual statements (Lessons 02–04) to linking them into one model. Cross‑sheet links are the backbone of any three‑statement financial model.
What You'll Learn
- ▶Link Net Income from the Income Statement into Retained Earnings on the Balance Sheet
- ▶Link Balance Sheet cash into the Cash Flow Statement ending cash
- ▶Build visible integrity checks that prove the three statements tie together
- ▶Explain how a change on one statement ripples through the others
Key Concepts
Cross‑sheet references (e.g., ='Income Statement'!B12) pull values between tabs
Named ranges make cross‑sheet formulas readable and harder to break
Integrity checks (A=L+E, NI→RE, cash tie) prove the model is correct
+1 more concepts
Lesson Phases
This lesson follows a structured 6-phase learning model designed for authentic project-based learning.
Hook
Open with a business scenario where linked statements matter for investor confidence
Introduction
Name cross‑sheet linking patterns, explain parts, teach common failure modes
Guided Practice
Practice linking logic in a simulator before touching the live workbook
Independent Practice
Build cross‑sheet links and statement checks in the real workbook
Assessment
Technical check and brief artifact task on trustworthiness and communication
Closing
Reflect on tool use, name what is faster now, preview next workbook layer
How You'll Learn
Excel‑lesson skill: business pressure → tool anatomy → safe rehearsal → workbook sprint → audit → reflection