Tabellab
Excel Intermediate

Financial Model Structure in Excel: Input Blocks, Monthly Timelines, Timing Flags, Corkscrews, Escalation, Scenario Selectors, Annual Roll-Ups & Check Panels

Build a fictional fitness-studio roll-out model in 20 hands-on labs – monthly timelines, timing flags, corkscrews, escalation indices, scenario selectors, annual roll-ups, check panels and a model summary – with every cell checked as you go.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

In 20 hands-on labs you build a fictional fitness-studio roll-out model step by step. You set up a monthly timeline with EOMONTH, switch studios on and off with timing and part-month flags, escalate prices with an index, and build corkscrews for members, fit-out assets and a loan with interest on the opening balance. You turn receivable and payable days into working capital, drive the model from a scenario selector, run sensitivities in a prepared comparison table and roll months up to years with SUMIFS and INDEX/MATCH. Check panels, seeded error hunts, an input register, version comparisons and a cash low-point analysis lead to a model summary dashboard.

Lessons

  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

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy