Workbooks
Fifteen sheets. One job each. Nothing orphaned.
You receive the shell in week one and you add to it. By week eight the file has the sheets below. The names do not change between cohorts, so a learner from winter and a learner from spring can still talk about the Checks sheet and mean the same page.
- 01 Cover Purpose of the file, currency, units, sign convention, scenario currently selected, version, author, and the iteration switch. A reviewer who skips this page is working blind, so it is one screen, not a novel.
- 02 Index Every sheet named, with a one-line job and a hyperlink. The colour key is repeated here so it cannot be lost when the cover is printed alone.
- 03 Time The month-end dates, a year flag, a forecast flag, and the partial-period counter. Annual columns elsewhere read this sheet. They do not invent their own calendar.
- 04 History Three years of mapped actuals with a source column. One-off items sit on a bridge. Nothing in the forecast may type over this block.
- 05 Drivers Volume, price, mix, headcount, wage rate, inflation index, debtor days, creditor days, stock days, tax rate used for the teaching cash tax, dividend, and capital expenditure. Yellow cells live here.
- 06 Workings The revenue build, the staff cost build, and operating costs that are too wide for the profit and loss face. The profit and loss only links.
- 07 IS Profit and loss, monthly and annual. Revenue down to profit after the teaching tax line. No balance sheet items hiding here.
- 08 BS Balance sheet that balances. Cash is a link from the cash flow, not a plug. Retained earnings roll forward from profit and dividends.
- 09 CF Cash flow built from profit, non-cash, working capital, capital expenditure, tax paid and funding. Closing cash is the number the balance sheet must show.
- 10 Debt Opening balance, draw, mandatory repay, optional repay, interest on the stated base, closing balance, and headroom against the limit in the case.
- 11 Leases A short schedule: opening liability, interest, payment, closing liability, and depreciation of the right-of-use asset. Labelled as a teaching mechanic.
- 12 Tax A simple cash tax: a rate on a defined profit base, paid with a lag. The sheet says, in the first row, that it is not a corporation tax computation.
- 13 Scenarios The index that switches base, downside and upside, and the two-way data table. The live case used in class is price against debtor days.
- 14 Checks A single page of differences that must be zero: balance sheet, cash tie, retained earnings, debt tie, lease tie, and a count of blank inputs that the case requires.
- 15 Dashboard Revenue, EBITDA, closing cash, revolver headroom, and three sensitivities. Printable. No sparklines that break when the file is opened on the other operating system.
What you may do with the file afterwards
Use the structure in models you build for yourself or your employer. Keep your marked case. Quote a technique in an internal note. You may not upload the teaching workbooks or the Harrow & Glen pack to a public repository, resell them, or use them as the materials of another course. The line is drawn in the terms.
How files arrive
By email, the Friday before each Tuesday, as a macro-free workbook. We do not use a portal that needs another password. If your employer blocks attachments, say so when you enrol and we will agree a transfer method before week one. Version names look like Integrated-Model-W06-yourname.xlsx. Do not send us a file called final-final.
A check you can run tonight
If you already have a forecast, tick what is true. The list stays on this device only.
0 of 6 true in the file you have open.
The review is a checklist, not a vibe.
Week eight is marked against the Checks sheet and against whether the note you write matches the file. A beautiful dashboard with a balance sheet that does not balance is a fail on that part. We would rather you submit an ugly file that ties.
Back to the weeks