Get Started With Our Free Course: Essential Financial Modelling

Killer Errors – Base Dates

KillerErrorsBaseDates

Another group of killer errors that can cause big problems are base dates for indexation, discounting, and NPV calculations.

This is one close to my heart as many years ago, believe it or not, I had included an incorrect base date in an NPV calc!

Thankfully it came to light before the bid went in, but not before it caused me as the modeller serious embarrassment and lots of awkward conversations with my client.

The problem was, the key evaluation metric in the bid was the target NPV of the availability payment. Lots of work had gone into fine-tuning and shaving off costs so that, after a lot of effort, the NPV of the availability payment was just scraping in below the target NPV.

Trouble was that the target NPV was being calculated at base date 2009 in the model rather than 2008 (shows how long the scars remain…) as per the bid documents. This meant that a year of discounting at 6% was missing. This meant that the target NPV was overstated by 6%!

With only a couple of weeks to go to bid submission, my client had to try and find another 6% in cost reductions – not an easy task, and I was not very popular.

In my defence (I still feel the need to defend myself even after all these years…), the base date I used was the same as the forecast financial close date, and was consistent with the cost indexation base date which would be pretty normal. BUT it was not right, it was not consistent with the bid documents and I had not checked it.

It is all too easy to be tripped up by base dates within Project Finance models and the impact can be large.

Learn from my mistake, double-check your base dates, and then check them again!

 

Read our previous blog in our killer errors series here.

Oliver Durston

Author

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 cassandra.brightley@gridlines.com 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.