Calculation blocks: Part 2
Calculation block components
Topic
Financial Modelling Handbook
How to build a three statement financial model from scratch.
Calculation blocks: Part 1
Why we use calculation blocks
How to navigate around your model
Keyboard shortcuts for efficient model navigation
How to ensure all worksheets have a consistent structure
Using a "Template sheet" in your model saves time when creating new sheet
Hiding unused columns at the end of the timeline
This gives a hard stop when copying across the timeline
Model structure 2: Worksheet level
Each column should have a purpose. That purpose should be the same across the workbook.
Model structure 1: Workbook level
When we're reading a book, the order that the chapters appear makes a difference. It's the same with models.
Understand the building blocks and you understand the model
Well built models should be made up of simple building blocks.
Eliminating unnecessary thinking time
Your time is expensive. The amount of it you waste on unnecessary thinking increases in proportion to the model's inconsistency and complexity.
Good financial modelling is like good business writing.
"Write to express, not to impress" - Mini Qarabaghi