Get Started With Our Free Course: Essential Financial Modelling

Killer Errors – Indexation

indexation assumptions

To help in our mission to save our friends and colleagues from the horrors of modelling errors, we plan to share a series of the most common errors we uncover in our role as model auditors.

We hope this helps you dodge a bullet sometime soon.

No 1. Indexation

Some of the biggest errors we come across, especially in Project Finance and infrastructure deals, are due to the incorrect application of indexation assumptions.

Within Project Finance models, revenues and costs tend to be indexed to take into account the impact of inflation over the life of the project.

The problem with indexation errors is that they compound and get much, much worse over time. Over 30 years (the ball-park in which a typical infrastructure project often sits), indexation at 2.5% (remember those days?) will pretty much double any costs from the beginning of the project. Obviously, missing inflation from a cost can cause you a big problem.

Although it sounds like a schoolboy error, making this kind of mistake is actually easier than it sounds.

Typically not all costs and not all revenues will be subject to indexation over the life of the project, and some may be indexed at different rates to others. Most template models will include arrays of flags and switches to choose between, and it can be all too easy to leave the wrong switch unchecked.

To make matters worse, some investors are interested in real returns (excluding inflation) and others in nominal returns (including inflation). Again, it can be all too easy to confuse the two and wind up with a very big misunderstanding.

When you are reviewing your model (or someone else’s), double- and triple-checking that all indexation assumptions are correctly applied should be one of your top priorities.

If you need an expert error killing machine to audit your models then we should talk.

Oliver Durston


Oliver Durston

View Profile

Related Articles

How Google taught Bard to doubt itself

“Knowledge is the antidote to fear” – Ralph Waldo Emerson Welcome to the new look Miscellany. If you have modelling-related news, resourcesor events that you’d like to share with 48,000 of the world’s best modellers, pleaseemail AI : How Google taught Bard to doubt itself

Where Does Model Audit 2.0 Rank? Inframation League Table

Once England’s lionesses get over the heartbreak of losing out to Spain in the World Cup final, I’m sure they will reflect on their journey and feel proud of how far they have come. It is with similar mixed emotions that we take in the H1

Our Work

We have the privilege of serving clients who are doing big, innovative things and who push us to do our best work. We like that. We support them with financial modelling, valuations and due diligence.