Output sheet structure

The Output sheet is the most useful sheet in the financial model.

Using a Standard Monetary Unit

Ensuring unit consitency througout the model

Managing inputs - Part 4: Input sheet mechanics

Using the INDEX function to acheive case selection

Managing inputs - Part 3: Running scenarios

Running a scenario involves changing some but not all the base case assumptions.

Managing inputs - Part 2: Using and comparing cases

Assumptions will change quickly. Sometimes chaotically. It will be up to you to keep track.

Managing inputs - Part 1: Cases, scenarios & sensitivities.

Most of the models we build have a similar input sheet structure. This structure has stood the test of time across thousands of model builds.

Stay Positive: Sign convention in modelling

There are two approaches to sign convention in models. Both are acceptable. One is better.

How to model balances

All balances share the same structure. We, therefore, model them in a standard way.

The five types of flags

There are only five types. You'll never have to build one from scratch.

Dealing with time: An introduction to flags

To model anything, we have to answer two central questions: "How much?" and "When?"