Module VI· Model Architecture & DesignAdvanced
Question
What is the three-section layout for complex models, and when do you use it?
Answer
The three-section layout separates inputs, calculations, and outputs. Inputs contain assumptions, calculations process them, and outputs show summary tables / charts. It is useful for complex models because users can change assumptions without touching formulas and reviewers can audit logic separately from presentation. It also reduces accidental overwrites.