My mission is to demystify financial models. Models should never be black boxes: they are simply made up of many layers, which themselves must always be clear and logical. Good layout of sheets is crucial for accessible models.
I find that using separate sheets for different elements of the model helps clarity.
Here is the structure of the model which we create on my three-day standard financial modelling course:
A black box? Definitely not.