Skip to content
Contact Visit forvismazars.com (opens in a new tab)
Register

Waterfall and tornado charts in Excel

How to build waterfall and tornado charts in Excel to compare scenarios and explain what moves a model's outputs, and when each chart is the right choice.

Browse coursesView more resources

Webinar · Recording · Presented by Shaun Comley · 25 June 2020

Finding clear ways to present a model’s outputs is hard, especially when you compare scenarios or analyse movements from year to year. This webinar shows how waterfall and tornado charts help you assess scenarios critically, when each chart is the right choice and how to set them up clearly.

The recording is in two parts. Part 1 is at the top of this page and part 2 follows the learning points.

What you will learn

  1. Building the charts

    How to build waterfall and tornado charts and add them to your model.

  2. When to use them

    The analysis each chart suits best.

  3. What to avoid

    The dos and don’ts of setting up these charts.

Part 2 of the recording

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

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

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

Browse all training courses

More on this topic

Webinars

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.

Delta sheets for analysing financial models

How delta sheets compare two versions of a model, explain what moved the outputs and support a systematic review, in any sector and without add-ins.

Services

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.

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.

Learn to build these models yourself

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

Browse all training coursesSend enquiry