Skip to content

Lisburn studio · financial modelling in Excel · taught live, online, on UK time

+44 7292105861 [email protected]

Admitora

Curriculum

Eight weeks, one workbook, no parallel versions.

Each Tuesday adds sheets to the same file. You do not keep a hero version, a backup version and a version you quite liked on Thursday. The curriculum below is the whole course. Office hours on Thursdays are for the build, not for a hidden extra syllabus.

A flat lay of a notebook with empty boxes and arrows, a pen, coffee and a calculator
The structure is drawn before it is formula-ed. Boxes first, functions second.

Week 01

Model hygiene

First Tuesday of the cohort

A shell that a second person can navigate in two minutes.

We start with an empty workbook and a bad habit list. You set the colour key, the sign convention, the units, and a timeline of thirty-six months plus annual formulas. Sheet order is fixed for the rest of the course so that later weeks are additions, not rearrangements. Protection is discussed as a review aid, not as a way to hide work.

Excel in the room
Sheet structure, named ranges used sparingly, freeze panes, print titles, GROUP and outline, custom number format for pounds: £#,##0; (£#,##0); "—".
You leave with
Cover, Index, Time, and blank statement sheets with the check rows already waiting.

Week 02

Mapping a pack

Historicals before forecasts

Three years of history that tie to the source, with one-offs visible.

You are given a fictional UK management pack: a profit and loss, a balance sheet, and a cash flow that do not yet agree with each other in convenient ways. You map lines into the historical block, you build a tie-out checklist, and you park restructuring, grants and other one-offs on a bridge instead of smoothing them into the run-rate. We talk about month-end (including a 31 March year and a chosen trading year-end) without pretending to be your auditor.

Excel in the room
SUMIFS for mapping, INDEX with MATCH as the classic alternative to XLOOKUP, paste-as-values discipline, and a source column so every historical number names its page.
You leave with
A History sheet that a colleague could re-perform against the pack.

Week 03

Drivers

Nothing on the profit and loss is typed

Revenue and cost that come from operations, not from a growth percentage you cannot explain.

Volume, price, mix, utilisation, wage rates, employer on-costs, and a materials ratio. You choose an index for inflation and you write the choice on the cover. Seasonality is a set of factors that sum to twelve, not a freehand wiggle. We look at a simple cohort of contracts for a services firm so that revenue does not appear from nowhere in month seven.

Excel in the room
EDATE and EOMONTH for the timeline, SUMPRODUCT where a mix table needs it, IF and IFS for switches, and a note on SEQUENCE for learners on current Microsoft 365, with a non-spilled equivalent beside it.
You leave with
A Drivers sheet and a Workings sheet that feed every profit and loss line.

Week 04

Working capital

Profit is not cash

Debtor days, creditor days, stock days, and a VAT lag that sits on the balance sheet.

You calculate a cash conversion cycle from the history, then you decide which days are a policy and which are a hope. VAT is modelled as a collected and paid balance, not as a cost of sale. Payroll accruals and prepaid insurance get one row each so the balance sheet is not a single plug called other. We are explicit that this is a teaching treatment, not a VAT return.

Excel in the room
Day-count with average balances, MIN and MAX to stop nonsense negatives where the case forbids them, and a roll-forward that shows opening, movement, closing.
You leave with
A working-capital block whose closing balances land on the balance sheet by formula.

Week 05

Debt, cash and a lease

Funding has a schedule

Interest calculated on a stated base, a revolver that funds the gap, and a lease you can unwind.

Opening cash, a minimum-cash rule, a revolver draw and repay, a term loan with a straight-line principal, and interest on average debt. You also build a short lease block in the spirit of an IFRS 16 mechanic: opening liability, interest, payment, closing liability, and a right-of-use depreciation. The covenant in the case (minimum cash, and a leverage illustration) is labelled as a teaching flag. It is not legal wording from a facility agreement.

Excel in the room
Circular references introduced and then contained, iteration settings, a corkscrew, and flags that turn red when headroom is gone.
You leave with
Debt and Leases sheets that the balance sheet and the cash flow both reference.

Week 06

Integration

The week the file either works or it does not

Cash flow built from profit, and a balance sheet that balances without a plug.

You construct the cash flow: profit, non-cash items, working-capital movements, capital expenditure, tax paid, and funding. Closing cash on the cash flow is the cash on the balance sheet. Retained earnings move by profit and dividends only. If the balance sheet does not balance, you find the difference. A plug line is forbidden in this course. Circularity for interest is switched on only after the non-circular fallback balances.

Excel in the room
Sign checks, a differences column, conditional formatting on the check row, and the iteration switch documented on the cover.
You leave with
An integrated file whose Checks sheet shows zeros across the forecast.

Week 07

Scenarios and the one-page read

From engine to decision

Three cases from one engine, and a page that does not require the engine to be open.

Base, downside and upside are toggles that change named inputs, not copies of the workbook. You build one two-way data table (price against debtor days is the usual pair) and you learn what a data table does to calculation. The dashboard carries revenue, EBITDA, closing cash, revolver headroom, and the three sensitivities you are prepared to talk about. Anything else stays in the engine.

Excel in the room
CHOOSE or a scenario index, data tables, and camera-free dashboard layout using ordinary cells so the page still prints.
You leave with
Scenarios and Dashboard sheets a director could be sent as a PDF.

Week 08

Harrow & Glen Services

Marked work

A full case, built under a clock, then a note on what would change the decision.

Harrow & Glen is a fictional facilities business used only inside the course: contract cleaning and small works, about forty staff, a small fleet, a term loan and one van on a lease. You receive a pack the weekend before, you build during the evening and the days around it, and you submit the file plus a one-page note. The note answers three questions: what has to be true for cash to stay positive, which input moves cash the most, and what you refused to model because you did not have the fact. We mark against the checklist, not against a secret forecast.

Excel in the room
No new function. The test is whether weeks one to seven are still standing when the pack is messy.
You leave with
A marked case file and written review notes you keep.
Hands at a keyboard beside a brass pen and a blurred printed table

Between the evenings

The homework is the model.

Expect four to six hours between Tuesdays in the heavy weeks (four, five and six), and less at the start. Thursday office hours run 12:30 to 13:15 UK time on the eight teaching weeks. Bring a specific cell, not a general worry. Replays do not replace the build: watching week six without opening the file will not make the checks equal zero.

Choose a cohort