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 To Find The Right Financial Model Auditor For You - Gridlines

How To Find The Right Financial Model Auditor For You

If you are in the market for a financial model auditor, here are some of the things you should know. Choosing a reputable model auditor You need to be sure that you are choosing a credible provider.  Your board and investors will want confidence that you

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.