Get Started With Our Free Course: Essential Financial Modelling

Killer Errors – Adding when you mean to subtract!


It still surprises me when we are completing a financial model audit, how often we encounter errors where rather than adding a number it is subtracted by mistake (or vice versa).

Where you get a sign wrong, it’s especially bad news as it gives you twice the problem compared to missing it out completely.

If you add on $100, rather than subtract $100, it gives you a $200 problem!

This sounds obvious, like an easy error to avoid, but it can be surprisingly easy to do, especially if you have picked up someone else’s model.

Imagine you are entering costs into an input sheet in a model. Is it always 100% clear as to whether the input should be positive or negative?

I’ve seen plenty of models where sometimes it’s positive, and sometimes it’s negative, and the only way to know is to trace through the impact in the model. This really is asking for trouble.

The best way to avoid these kinds of errors is to ensure your model adopts a clear sign convention throughout.

The Two alternative approaches we recommend are:

1) Everything Positive – where all inputs are positive.
2) Cash in positive, cash out negative.

There are pros and cons to each, and some items will change between positive and negative during your forecasts. But the main thing to reduce the risk of error is that you have a convention and know which one you are dealing with.

If you would like to talk to us in detail for how we navigate potential errors then contact us today.

Oliver Durston


Oliver Durston

View Profile

Related Articles


Building a robust and flexible financial model

Building a robust and flexible financial model is a critical task for businesses. Whether you’re trying to secure funding for your startup, track your company finances, or plan for your company’s future, having a solid model is essential.


What Does the UK Spring Budget Mean for Tax?

The UK Chancellor, Rishi Sunak, delivered his Spring Statement today (23 March 2022). In terms of measures relating to companies involved in the project finance arena, one of the main items of note was the announcement of the government’s Tax Plan for the remainder of this

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.

Find out more about what we do.