Sensitivity Switches & a Prepared Comparison Table
Lessons in this course
- A 24-Month Timeline with Opening Flags & RevenueFree
- Layout: Inputs, Calculations & Outputs in One Place Locked
- The Timeline Row: Periods, Dates, Days, Years & Quarters Locked
- Timing Flags: Construction, Operations & First Month Locked
- Part-Month Flags: Pro-Rata Opening Months from Days Locked
- Escalation Index: Annual Price Steps from a Base Month Locked
- Corkscrew I: Opening + Joins − Leavers = Closing Locked
- Corkscrew II: Fit-Out Capex, Depreciation & Book Value Locked
- Debt Corkscrew: Drawdowns, Repayments & Interest Locked
- Working-Capital Days: Receivables, Payables & Cash Impact Locked
- Scenario Selector: One Live Case from a Scenario Table Locked
- Sensitivity Switches & a Prepared Comparison Table Locked
- Annual Roll-Up: Flows by SUMIFS, Balances at Year-End Locked
- Signs & Units: Cost Signs, Thousands & Consistency Checks Locked
- The Check Panel: Balance Checks, Cross-Sums & One OK Flag Locked
- Error Hunt: Let the Checks Find Seeded Mistakes Locked
- The Input Register: Units, Sources & Completeness Locked
- Version Comparison: v1 vs v2 Outputs & Explanations Locked
- Cash & Funding: Cumulative Cash, Low Point & Funding Need Locked
- Final Project: The Model Summary Dashboard Locked