Skip to content

Sensitivity analysis of a model you didn’t build

A systematic process for sensitivity and scenario analysis on a financial model built by someone else, with less manual work and less risk of error.

Webinar · Recording · Presented by Rickard Wärnelid · 23 August 2018

If you work in credit analysis, project finance or investment, you run scenario and sensitivity analysis on financial models built by someone else as a matter of routine. Done inefficiently, it takes a long time, and the repetition creates a high risk of manual error.

This webinar shows several approaches that give you a systematic process for sensitivity and scenario analysis on a third‑party model.

What you will learn

  • Build a structured sensitivity and scenario process into a model someone else built
  • Understand what is expected of you, and what the model auditor’s role is
  • Extract the outputs you need to assess the risk in an investment or credit
  • Use sensitivities to check that the model responds sensibly to changes in assumptions
  • Add flex cells quickly with little risk of coding errors
  • Read the outputs with a commercial mindset to find issues and opportunities

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

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

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

Browse all training courses

More on this topic

Webinars

Sensitivity tables for infrastructure project analysis

Our webinar on building sensitivity tables to test a model’s outputs.

Waterfall and tornado charts in Excel

Our webinar on waterfall and tornado charts to present a model’s sensitivities.

Services

Financial Model Audit

From bid submissions and financial close to buy‑side reviews and corporate models, our team signs an independent opinion. More than 100 model audit professionals across seven offices.

Learn to build these models yourself

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