Creating a Timing Sheet
Discover how to create a Timing Sheet.
When to use
When constructing a basic Financial Model.
- Cell H15 is not an assumption cell. It is a constant and if the sheet were to be protected it would not be possible to change this date. In fact, once the model build has commenced this cell should not be revised (this is why the heading in cell C13 reads “Data (do not change once modelling has commenced)”. This is because if data is entered for a particular time period and then the dates were to change, input values may become associated with the wrong period and / or duration.
- Cell H15 is so important it is even given its own range name: Model_Start_Date. Even if output analysis were to change (i.e. the dates on an output sheet started with a later date), the calculations would work using a LOOKUP arrangement so that on input and calculation sheets the Model_Start_Date would always start in the first column reserved for time series
- Cell H17 (Number of Months in a Full Period) should be 12 and the Example Reporting Month (cell H19) should be set to the value 6 (i.e. June will be the period end). With five time periods, this will give us five full years from 1 July 2020 to 30 June 2025 inclusive
Lesson notes are only available for subscribers.