Skip to content

Managing circular references in financial models

The circular references that appear in project finance and corporate finance models, the errors they cause and the best practice ways to manage them.

Webinar · Recording · Presented by Joshua Grimm · 10 April 2024

Circular references webinar slides

The slides from this session.

Download the slides (opens in a new tab)

Circularity without the errors

Circular references are a common challenge in both project finance and corporate finance models. This recorded webinar covers the best practice approach to avoiding the errors they cause.

It starts with the most common errors and how to avoid them, then works through circular logic and how to simplify the calculations behind it.

What you will learn

  • The different types of circular reference in financial models
  • The best practice approach to keeping the effect of circularity to a minimum
  • Why circular logic arises, particularly in project finance models
  • How to keep a model dynamic and simple, without unnecessary VBA macros

Learn financial modelling in a room

Hands-on courses in person and online, taught to more than 20,000 people on one modelling standard.

Best Practice Project Finance Modelling

Build and sensitise robust cashflow models from scratch, faster in Excel. Hands-on, practitioner-led, in person or online. See dates and book your place.

View full course details: Best Practice Project Finance Modelling

Advanced Project Finance Modelling

Debt sizing, covenant monitoring, DSRAs and integrated three-way statements. Hands-on, practitioner-led training, in person or online. See dates and book.

View full course details: Advanced Project Finance Modelling

Financial Model Review

Error classes, testing technique and where AI-assisted financial model review earns its place. 1-day course from our award-winning Model Audit team.

View full course details: Financial Model Review

Browse all training courses

More on this topic

More

Circular references in project finance models

Managing circular references in project finance models: how to trace them, when to remove them with algebra and when a circularity break is better.

Working capital in financial models

Six ways to calculate working capital in a financial model, the errors model auditors find most often and how to model a working capital facility.

Services

Financial Model Audit

An independent opinion on the model behind your transaction, with a red flag report on any show-stopper issues in under 5 working days.

Financial Modelling Support

Experienced modellers who work alongside your team when you need them, to update a model, add a refinancing case or check work before it goes out.

Learn to build these models yourself

We run public and in-house courses across the full financial modelling curriculum.