Читать книгу See-Through Modelling - Dominic Robertson - Страница 63

The time dimension within a financial model deserves some respect. Excel does not understand the passage of time. Each formula must be coded to deal with time, and formulas can change substantially between a quarterly, semi-annual or annual timeline (this is known as periodicity). In Excel, time creates large amounts of logic and therefore can add substantial bulk and complexity to a model file.

Since each timeline requires all the calculations that form the basis of an individual model it is generally preferable to have only one timeline in a model.