Leading Advisors in Project Finance

Blog

  • Building a project finance model: three principles

    By Jonathan Swan / 7 May 2019 / Comments

    Building a project finance model: three principles

    I have taught practical financial modelling for over two decades.

    The methodology I teach is based on that used by my colleagues, who have worked on some of the most complex financial modelling assignments in the industry world-wide. As a teacher and writer I have also found it helpful to read and explore modelling methodologies used by other firms and practitioners.

    From this I have learned that there is no one agreed ‘best’ methodology but 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 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 which accepts that errors are inevitable and but then seeks to minimise their occurrence and to 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.

     

    For more guidance see my book, and take a look at the courses we have available. Learn the fundamentals and develop your skills.

    In the meantime you can sign up for my webinar sessions for more efficient ways to build, review, read & interpret your spreadsheets.

Call

+44 207 562 0400

Email
Contact
[contact-form-7 404 "Not Found"]