Get Started With Our Free Course: Essential Financial Modelling

Are you relying on Excel based analysis to make business critical decisions?

Excel Error

In many businesses, Excel is used for critical reporting and decision making. As has been widely trailed, the flexibility and open structure of Excel models can leave them prone to error.

When making decisions based upon an analysis of complex data it’s worth pausing for reflection before pushing the button on that multi-million dollar investment. Take a moment to think the unthinkable, and ask yourself…

“What if the numbers are wrong?”.

It cannot be taken for granted that the numbers presented to support decision making are accurate. If you are working with bad data, you run the risk of making a bad decision.

At best, you will you make yourself look dumb, at worst you could lose millions of dollars and even kill your business (It has happened).

The follow-up question should be:

“Have we done all we can to minimise modelling risk?”.

If the answer is a resounding “yes”. Then relax, take out your cheque book (do they still exist?) and go right ahead.

If the answer is, “I don’t know” or “Dave in accounts is a spreadsheet whizz, I’m sure it will be fine”.

It might be a good idea to put that chequebook away until you can be confident that you are not putting your career and your business at risk.

The risk of spreadsheet error is consistently underestimated by decision-makers and has led to some pretty spectacular financial losses (measured in Billions $).

Excel has many benefits and is often the right tool for the job, but where it is used to support critical decision making, please handle with caution.

In the remainder of this series of blogs, I will share our tried and tested approaches to minimising modelling risk.

Find out more about our approach to financial modelling here.

Oliver Durston

Author

Oliver Durston

View Profile

Related Articles

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

East Africa smallholder farmers are set to benefit from AI-powered soil carbon project by Boomitra

East Africa’s AI-Powered Agricultural Revolution

“Agriculture is our wisest pursuit, because it will in the end contribute most to real wealth, good morals, and happiness.” – Thomas Jefferson 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

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.