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.