An Introduction to Financial Modelling in Excel by Dan Stockdale

Author:Dan Stockdale
Language: eng
Format: epub
Publisher: Bookboon.com Ltd.
Published: 2021-05-27T00:00:00+00:00

3.3 How to Use the Timeline

The most obvious way in which the Timeline is used throughout the model is, of course, as a reference for time when reading and operating the model. However, it can and should play a vital role in the calculations of the model too; the Timeline, and more specifically its counters, should be fully utilised in calculation logic.

For example, the Period # counter in Figure 3.3 is utilised in a depreciation calculation to spread the capital expenditure (Capex), on a laptop, over 12 months. Examination of the SUMIFS function used, shows that Capex from only the most recent 12 months is being summed, and then divided by 12, to calculate the depreciation for the month.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.