Tabellab

Scenario Toggle: Base, Upside and Downside with CHOOSE

Lesson 9 of 20 Lab 🔒 Locked

Lessons in this course

  1. Monthly P&L Variance: What to Explain to Your ManagerLabFree
  2. Budget vs Forecast: Rolling the Latest Estimate (6+6)Lab Locked
  3. Revenue Bridge: Volume and Price Effects in a WaterfallLab Locked
  4. Headcount Cost Model: Salaries, Start Months and On-CostsLab Locked
  5. Driver-Based Forecast: Sessions × Conversion × Order ValueLab Locked
  6. KPI Pack: Margins, Year-on-Year Growth and Run-RateLab Locked
  7. Trailing Twelve Months (TTM): A Moving SUMLab Locked
  8. Ratio Snapshot: Liquidity, Leverage and Working Capital DaysLab Locked
  9. Scenario Toggle: Base, Upside and Downside with CHOOSELab Locked
  10. Sensitivity Table: EBITDA for Price and Volume ChangesLab Locked
  11. Reconciling Two Exports: XLOOKUP and the Difference ColumnLab Locked
  12. One-Page Management Dashboard: KPIs, Chart and HighlightsLab Locked
  13. From Trial Balance to P&L: Account Mapping with XLOOKUP and the Tie-Out CheckLab Locked
  14. Budget Phasing: Seasonal Monthly Budgets, YTD Variance and What Is Left to SpendLab Locked
  15. Forecast Accuracy: Errors, MAPE and Bias by Product LineLab Locked
  16. Allocating Shared Costs: Drivers, Department Contribution and Why the Driver MattersLab Locked
  17. Cash Conversion: From EBITDA to Free Cash Flow with Working Capital and a WaterfallLab Locked
  18. Capex Request: Payback, NPV and IRR for a New Store Fit-OutLab Locked
  19. Group Reporting in USD: FX Translation, Reported vs Constant-Currency GrowthLab Locked
  20. Final Project: Month-End Board Pack – YTD vs Budget and Last Year, Margins & a Combo ChartLab Locked