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.
- 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
- 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
Learner reviews
Be the first to review this course.