Get Started With Our Free Course: Essential Financial Modelling

Killer Errors – Base Dates


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


Oliver Durston

View Profile

Related Articles


What’s really going on at OpenAI?

“I have not failed. I’ve just found 10,000 ways that don’t work” – Thomas Eddison If you have modelling or AI-related news, resources, or events that you’d like to share with 48,000+ of the world’s best modellers, please email AI // What’s really going on

Autumn Statement 2023: Boosting Business Growth in the UK

Autumn Statement 2023: Boosting Business Growth in the UK

Minimum tax has been discussed in the international tax arena for some time now, and certain jurisdictions already apply some form of ‘minimum tax’ in the domestic setting, such as corporate minimum tax (CMT) in Ontario, Canada and the corporate alternative minimum tax (CAMT) in the

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.