Model structure

The structure of an Excel model separates assumptions (inputs), calculations and results (outputs) into distinct areas or sheets. No constant is written directly into formulas: they point to assumption cells. This organization makes the model easier to modify, check and reuse.

Example

An Assumptions sheet (rates, prices), a Calculations sheet and a Summary sheet.

Related concepts

The whole glossary