Model Architecture, Assumptions & Driver Growth
Apply the golden rule of no hardcoded constants inside formulas and build transparent multi-year driver projections.
Key takeaways while you watch
- Color-code conventions: Blue font for hardcoded inputs, Black for same-sheet formulas, Green for cross-sheet links.
- Compound driver growth cleanly using Prior Period * (1 + Growth Rate).
- Keep time periods aligned vertically across columns (e.g. FY25 in Col B, FY26 in Col C) on every sheet.
Drill: Project Next Year Revenue from Assumption Cell
Write a formula in C2 growing B2 (FY26 Revenue) by the locked Growth Rate assumption in cell $E$1.
| Line Item | FY26 (B) | FY27 Proj (C) | Annual Growth ($E$1) | |
|---|---|---|---|---|
| Subscription Revenue | 1200000 | =? | 0.15 | |
| Services Revenue | 300000 | =? |
Module 01 Knowledge Check
Answer all 3 questions and check your score to unlock credit toward completion.