Inputs in one place. Drivers sit on the Assumptions sheet. Detailed schedules such as a rent roll, a claims register or a programme sheet carry their own inputs, and the cover lists every sheet that has them. Formulas carry no hardcoded numbers.
Three font colours. Blue for inputs, black for formulas, green for links to other sheets. Check rows are shaded and should read zero.
No circular references. Interest is charged on opening balances, as each cover states, so the workbook calculates without iteration. Each page shows whether every check reads zero.
Sensitivities as formulas. Each cell of a sensitivity grid recalculates the output in closed form, so it can be traced, and the centre cell is checked against the main sheet.
Tagged schedules. Rows are tagged to the schedule they belong to, which lets a starter workbook clear one schedule, such as the debt schedule, and leave the rest of the model intact.
Illustrative data. Each model uses illustrative data for a fictional company, property, project or transaction, except a Deal in Focus model, built from a real transaction’s published documents with every undisclosed term labelled, and a Model the business model, built from a real company’s filings with every assumption labelled. The inputs are starting assumptions, not forecasts or market data.