Financial Modelling: Managing circular references

By Joshua Grimm

Wednesday 10th April 2024

A common challenge faced by financial modellers is how to deal with circular references in their models. Common across both the project finance and corporate finance space, this free webinar will cover off the best practice approach to circumventing errors arising from circularities.

We’ll first review the most common errors and how to avoid them. Then we’ll step into circular logic and work to simplify our approach to these calculations.

Key learning outcomes:

  • Understand the different types of circular references in financial models
  • Demonstrate the best practice approach to minimising the impact of circularities
  • Gain insight into the rationale behind circular logic, particularly in project finance models
  • Learn to maintain dynamic, simple financial models free from unnecessary VBA macros.