1.2 Overview of Model Used in this Chapter
Some of the most fundamental of the Excel functions (notably IF and SUM) have so many potential uses that it is not possible to list them all. Generally, they will be used in specific contexts where the need for them is self-evident, and without needing to make any particular comments on why or how they are used. Nevertheless, on occasion it is useful to point out some contexts or structures in which their use is quite frequent.
This chapter shows some such examples in a model which has multiple time periods (i.e. a revenue forecast over 5 years, similar to the models built earlier):
By way of explanation:
- The main part of the forecast is in columns H to L, and uses the single growth rate assumption that is in cell E5.
- Columns F and G contain the actual historical data for the Sales Revenue, as well for the implied growth rate (cell G5, which serves as information).
- Cell C4 contains the SUM function. This is discussed in the next section.