Lesson ProgressPhase 6 of 6
Phase 6Closing
Closing: Link the Three Statements: Cross‑Sheet References and Integrity Checks
Reflect on tool use, name what is faster now, preview next workbook layer
Phase 6: Reflection and Handoff
What You Can Do Now
You built the links that turn three separate statements into one connected financial model. Reflect on what changed in your understanding and what comes next.
What You Built Today
- Net Income flows from the Income Statement into Retained Earnings on the Balance Sheet
- Ending Cash on the Cash Flow Statement links to Cash on the Balance Sheet
- Integrity checks prove the model balances and ties across all three statements
- One change on any statement ripples through the entire model automatically
What Is Faster Now
Before today, Sarah had to update each statement by hand when a number changed. Now she can:
- Change one assumption and see the impact across all three statements instantly
- Show an investor that the model ties without manual recalculation
- Spot errors immediately through visible integrity checks instead of hunting for them
CAP Reflection: Cross-Sheet Links and Model Trustworthiness
Reflect on your learning journey and growth in the CAP framework
0/3 Complete
🦁COURAGE
What was the most challenging part of this unit that required you to step outside your comfort zone?
0 characters
🌊ADAPTABILITY
How did you adjust your approach when you encountered unexpected problems or feedback?
0 characters
⚡PERSISTENCE
Describe a time when you wanted to give up but kept working. What motivated you to continue?
0 characters
Progress: 0/3 reflections completed
Preview: Lesson 06 — KPI Dashboard
Now that your three statements are linked, the next lesson adds a KPI dashboardon top of the model. You will build:
- Key ratio cards (Current Ratio, Return on Assets, Profit Margin)
- A visual summary page that investors can read in 30 seconds
- Dashboard links that pull from your now-connected statements
Keep your linked workbook saved. You will use it as the starting point for Lesson 06.