Model Architecture
Executive Summary
Key Takeaways
- ✓ Model architecture is the concrete layout of a model's worksheets, colour conventions, and navigation structure, distinct from the broader engineering principles those layout choices implement.
- ✓ A well-architected model has a worksheet sequence that follows its actual information flow, not an arbitrary or historically accumulated order.
- ✓ Architecture decisions made before construction begins are significantly cheaper than the same decisions retrofitted onto a model that has already grown to many interconnected tabs.
Definition¶
Model architecture is the set of layout decisions that determine how a financial model's worksheets are ordered, how a reader navigates between them, and how different categories of cell content — inputs, calculations, outputs — are visually distinguished. It is the concrete, practical implementation of the broader principles addressed in Spreadsheet Engineering, not a synonym for them: architecture is the specific tab order, colour convention, and navigation structure a builder actually chooses, rather than the underlying engineering principle that choice is meant to satisfy.
Why It Matters¶
A model's structural soundness and its navigability are related but separate properties. Good architecture — a worksheet sequence that follows the model's actual information flow, a colour convention applied without exception, clear naming — makes a structurally sound model usable by a reader who did not build it. See Workbook Design and Model Architecture for the full technical treatment of these layout decisions.
Continue Reading¶
Prerequisites¶
- Financial Modelling Best Practices — the parent pillar
Related Technical Guides¶
Related Glossary¶
How OXXON tests thisRun a free structural check with FMAE
Frequently Asked Questions
What is model architecture in financial modelling?
The layout of a financial model's worksheets, colour conventions, and navigation structure — the concrete decisions a builder makes about how the model is organised, distinct from the broader engineering principles those decisions implement.
Is model architecture the same as spreadsheet engineering?
No. Spreadsheet engineering is the broader discipline of applying software-engineering principles to model construction. Model architecture is the specific, concrete layout — tab order, colour scheme, naming convention — a builder chooses to implement those principles in practice.
Why does model architecture matter for auditing?
A well-architected model is faster for an independent reviewer or auditor to navigate, because its structure does not need to be reverse-engineered before substantive review can begin.
Related Articles
Workbook Design and Model Architecture
Workbook design and model architecture is the specific skill of deciding how a financial model's worksheets are ordered, how a reader moves through them, how cell types are visually distinguished, and how sheets and files are named. It is distinct from the broader engineering principles covered in Spreadsheet Engineering and the policy-level standards covered in Model Standards — this guide addresses the concrete layout decisions a model builder makes before entering a single formula. A well-architected workbook is not a matter of taste — it determines how quickly a reviewer, lender, or successor analyst can navigate the model and trust what they find.
Financial Modelling Best Practices — Standards Compared
Financial modelling best practice is not a single document but a landscape of named institutional standards, each publishing its own conventions for how a model should be structured, formatted, and documented. This page defines that landscape — what a named modelling standard actually is, how the FAST Standard and the ICAEW Financial Modelling Code differ in approach and scope, and how a practitioner chooses between them or applies more than one. It sits beside, not instead of, the Knowledge Centre's structural-foundation page on what makes an Excel financial model reliable — this page is about who has codified that discipline into a named standard, and how those standards compare to one another.
Spreadsheet Engineering
Spreadsheet engineering is the application of systematic engineering principles to the construction and maintenance of spreadsheet-based financial models. It treats a financial model as a software artefact subject to design principles, structural requirements, and quality standards analogous to those applied in software engineering, rather than as an ad hoc calculation tool built without formal discipline. The core principles of spreadsheet engineering are: separation of inputs, calculations, and outputs; consistent formula construction; avoidance of circular dependencies; complete documentation; and systematic version control. These principles are codified in recognised standards including the ICAEW Financial Modelling Code and the FAST Standard.