Whilst there isn’t one agreed-upon ‘best’ methodology when it comes to project finance financial modelling, there is widespread agreement on what constitutes good modelling practice, and probably without exception many experts would recognise and accept the three principles described here.  These principles help you mitigate the risk of error and increase the level of assurance you can provide to model sponsors and users.

Three key project finance financial modelling principles to remember and apply:

1. The Principle of Error Reduction
2. The Feedback Principle
3. The Top-Down Approach

1. Principle of Error Reduction – quality assurance and quality control

This principle of error reduction is a simple concept based on our own experience and that of others in the business, where we recognise that certain modelling operations are more error-prone than others.

I believe in adopting a pragmatic approach that accepts that errors are inevitable and seeks to minimise their occurrence and enhance their detection.

The principle of error reduction forces us to recognise the inherent limitations of the spreadsheet model (and perhaps the modellers themselves), and to implement a framework which provides the resources and controls to minimise or mitigate the whole process of model specification, development, testing and use.

2. The Feedback Principle – a fundamental part of the quality control framework

The feedback principle means that we actively seek to test and validate our work continuously throughout the modelling process.

We use both positive and negative feedback – the former is the system of checks and controls we impose in order to detect and remedy problems in our models; the latter is that received from others (such as auditors) who have found errors in our work.

To obtain feedback we implement a number of feedback controls, which can be elements such as the audit workbook and report, the internal audit sheet and the various checks and test carried out during model development and use, and the use of peer review and external audit.

3. The Top-Down Principle – retain a view of the model’s overall purpose

The top down principle helps us make sense of the complexities of the modelling environment. Rather than becoming immersed in immense amounts of detail (bottom-up), we retain a view of the model’s overall purpose and results.

The audit profession refers to two approaches to audit: ‘controls testing’ and ‘substantive testing’, and this is essentially what the top-down principle provides – the key results are the controls; if they look reasonable then we can be selective in our choice of substantive tests to run, rather than analyse each formula in turn. In reviewing a 50Mb spreadsheet our immediate concern is that the key results are correct; we are less concerned with layout, hidden content or bizarre formulas.

To summarise

• The three principles of Error Reduction, Feedback and the Top-Down approach allow you to mitigate the risk of errors with appropriate systems and controls.

• Structure your model by content: inputs, workings, outputs.

• Keep formulas short.

• Consider using an audit sheet to record the tests and checks in your model.

• Accept that errors are inevitable, and use methods and techniques that serve to minimise their occurrence and enhance their detection.

• Never forget the model’s overall purpose and results – and who will be using it.

 

If you are looking to brush up on your modelling skills please take a look at our in-house training courses here.

Share now

Authors

CONTACT US

Please get in touch with either of our regional offices.

https://www.operis.com/wp-content/uploads/2022/11/22_09_Chris_A-0376.jpg
Chris Aldred
Director

+44 207 562 0433

[javascript protected email address]
https://www.operis.com/wp-content/uploads/2021/03/Jun-Tao-500x500.png
Jun Tao
Director

+44 207 562 0428

[javascript protected email address]
https://www.operis.com/wp-content/uploads/2021/04/019A5891_Michael.jpg
Michael Jarman
Director

+1 647 243 8016

[javascript protected email address]
https://www.operis.com/wp-content/uploads/2021/05/Philip-Allen-500x500.jpg
Philip Allen
Head of Training [javascript protected email address]

Operis Europe

View Google Map
+44 207 562 0400
[javascript protected email address]

Operis North America

View Google Map
+1 647 846 7382
[javascript protected email address]

CONTACT US

Discuss your requirements with us

https://www.operis.com/wp-content/uploads/2022/11/22_09_Chris_A-0376.jpg
Chris Aldred
Director

+44 207 562 0433

[javascript protected email address]
Name(Required)
This field is for validation purposes and should be left unchanged.