I.c Modelling Structures and Calculations (II)

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.

Scroll to Top