Skip to content

Delta sheets for analysing financial models

How delta sheets show what moved a model's outputs between versions, catch errors and support a systematic review, in any sector and without add-ins.

Webinar · Recording · Presented by Tom Brichieri-Colombi and Jerome Brice · 20 March 2019

In this webinar, Tom Brichieri-Colombi and Jerome Brice show how to use delta sheets to interrogate your own infrastructure models, or models given to you to review, and draw commercial insight from them.

Delta sheets work on any model in any sector and need no external software.

Case studies in the webinar

  • Sensitivities after financial close on an infrastructure project
  • Support for an independent model review
  • Managing new versions of a model received from an adviser or sponsor

What you will learn

  1. Drivers and outputs

    A full understanding of how the main model drivers affect the main outputs.

  2. Finding errors

    How delta sheets bring potential errors in a model to the surface.

  3. Delta sheets for your work

    How to build delta sheets for your industry or application, for commercial and technical insight.

  4. Systematic review

    A systematic review in place of spot checks, with conditional formatting and sparklines to read the results quickly.

Learn financial modelling in a room

Hands-on courses in person and online, taught to more than 20,000 people on one modelling standard.

Financial Model Review

Error classes, testing technique and where AI-assisted financial model review earns its place. 1-day course from our award-winning Model Audit team.

View full course details: Financial Model Review

Best Practice Project Finance Modelling

Build and sensitise robust cashflow models from scratch, faster in Excel. Hands-on, practitioner-led, in person or online. See dates and book your place.

View full course details: Best Practice Project Finance Modelling

Advanced Project Finance Modelling

Debt sizing, covenant monitoring, DSRAs and integrated three-way statements. Hands-on, practitioner-led training, in person or online. See dates and book.

View full course details: Advanced Project Finance Modelling

Browse all training courses

More on this topic

Webinars

Reviewing a spreadsheet with sparklines

How Excel sparklines help you review a spreadsheet, with the features to use and real examples of errors that sparklines helped our team find.

Sensitivity tables for infrastructure project analysis

How sensitivity and scenario tables in Excel support credit and investment submissions and test whether a model holds up when its inputs move.

Services

Financial Model Audit

An independent opinion on your transaction model from the number one ranked global model audit practice. Red flag report in under 5 working days.

Financial Model Development

Transaction and operational models built to your specification, lender-ready and documented, then handed over to your team with the logic explained.

Learn to build these models yourself

We run public and in-house courses across the full financial modelling curriculum.