Tabellab

Lessons in this course

  1. A 24-Month Timeline with Opening Flags & RevenueLabFree
  2. Layout: Inputs, Calculations & Outputs in One PlaceLab Locked
  3. The Timeline Row: Periods, Dates, Days, Years & QuartersLab Locked
  4. Timing Flags: Construction, Operations & First MonthLab Locked
  5. Part-Month Flags: Pro-Rata Opening Months from DaysLab Locked
  6. Escalation Index: Annual Price Steps from a Base MonthLab Locked
  7. Corkscrew I: Opening + Joins − Leavers = ClosingLab Locked
  8. Corkscrew II: Fit-Out Capex, Depreciation & Book ValueLab Locked
  9. Debt Corkscrew: Drawdowns, Repayments & InterestLab Locked
  10. Working-Capital Days: Receivables, Payables & Cash ImpactLab Locked
  11. Scenario Selector: One Live Case from a Scenario TableLab Locked
  12. Sensitivity Switches & a Prepared Comparison TableLab Locked
  13. Annual Roll-Up: Flows by SUMIFS, Balances at Year-EndLab Locked
  14. Signs & Units: Cost Signs, Thousands & Consistency ChecksLab Locked
  15. The Check Panel: Balance Checks, Cross-Sums & One OK FlagLab Locked
  16. Error Hunt: Let the Checks Find Seeded MistakesLab Locked
  17. The Input Register: Units, Sources & CompletenessLab Locked
  18. Version Comparison: v1 vs v2 Outputs & ExplanationsLab Locked
  19. Cash & Funding: Cumulative Cash, Low Point & Funding NeedLab Locked
  20. Final Project: The Model Summary DashboardLab Locked