OBJECTIVES
- Learn further common types of modelling structures that require functions in order to create.
- Gain further hands-on experience with using many of the core functions.
DESCRIPTION
- Overview. This course describes some important modelling structures and calculations that require functions in order to create them. These include flags, updating with actuals, allocations, general waterfalls, capital-return waterfalls, triangle calculations, and core aspects of balancing financial statement forecasts.
- Practical work and exercises. Students are required to conduct numerous hands-on modelling exercises and can also follow along by replicating other examples that are shown in the text.
- Assessment tests. There are several tests which cover both the key concepts and require one to do practical exercises in Excel.
KEY TOPICS
- Conditional Flags, Updates and Allocations. Flag variables, linear and non-linear allocations, and triangles. Automated updating with new data.
- Waterfalls. General waterfalls for category allocations. Capital-return based waterfalls.
- Balancing Financial Statement Forecasts. Introduction to integrated financial statement models, and the need to balance forecasts.