Skip to content

Automated self-checks in financial models

John Yeldham sets out how automated integrity and commercial checks make a model more accurate, easier to review and quicker to act on.

Webinar · Recording · Presented by John Yeldham · 12 July 2022

Automated checks make a financial model more accurate, easier to build and easier to review, and the benefit lasts long after the model is finished. This webinar sets out our approach to error management and shows how to bring the commercial outputs that matter to a decision maker’s attention.

What you will learn

  • Number formats and hyperlinks that make checks quick to build and follow
  • What integrity checks and commercial checks each do, and why a model needs both
  • How to organise and present checks so every flag traces back to its source
  • How to put critical commercial information in front of decision makers quickly
  • How checks help you build quality models faster

Learn financial modelling in a room

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

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

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

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

Integrity checks in financial models

How to build integrity checks that hold up as a model grows.

Financial model review pitfalls and how to avoid them

How to review a financial model you did not build.

Services

Financial Model Audit

An independent opinion on the model behind your transaction.

Learn to build these models yourself

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