Four Key Tips to Build an Effective Financial Model

Four Key Tips to Build an Effective Financial Model

David Colver

30 years: Financial modelling

In this video, David explains some good practice methods for making the story that these models tell as effective as possible, with a key focus on cash flows.

In this video, David explains some good practice methods for making the story that these models tell as effective as possible, with a key focus on cash flows.

Speak to an expert

Speak to an expert today to access this and all of the content on our platform.

Four Key Tips to Build an Effective Financial Model

9 mins 29 secs

Overview

For financial modelling to be effective, it must be clearly understood by all stakeholders involved. David outlines four steps to ensuring that financial models are clear, decluttered of any unnecessary information and accessible to all. He sums up why cash flows are one of the most important elements to any financial model and why small details such as printing format can make or break a project.

Key learning objectives:

  • Learn how to effectively tell a story through cash flows

  • Learn how to present cash flows directly

  • Understand how to present a model in a digestible way

Speak to an expert

Speak to an expert today to access this and all of the content on our platform.

Summary

Why is it important to concentrate on cash flows in a financial model? 

The central character in the storytelling role of a project is its cash flows. The cash flow prompts three key questions: 

  • How much money gets made?
  • Where does it come from?
  • Where does it go, and in what priority order? 

These are the questions that people want to understand the answers to. Inputting cash flow centre stage, project finance is quite different from most other branches of finance. 

What are the three financial statements that are present in the annual accounts of businesses of all sizes? 

  • The income statement - used to be called the profit and loss account
  • The statement of financial position - used to be called the balance sheet
  • The statement of cash flows 

Why is a non-traditional direct presentation of a cash flow beneficial? 

Cash flows can either be presented directly (non-standard) or indirectly (standard). A direct cash flow is preferred. Starting with revenue and deducting costs, first the ones that vary with revenue, then the ones that are more nearly fixed, and then deduct capital costs, taxes and financing. 

There might be some people involved in the project who have accountancy backgrounds and who are much more comfortable with what for them is the conventional cash flow presentation. If a spreadsheet model provides a direct cash flow, it can easily be extended to deliver an indirect one.

Why does good printed output and presentation style matter? 

Financial models must be easily accessible and readable to people who spend their days reading spreadsheets and equally, those who don’t. The people reading the financial model will have a wide range of excel literacy. The cash flow must fit neatly onto one page and the financial model must be formatted so that it prints out correctly. Clients do not want to be in a situation where hundreds of sheets are produced by the printer with only a few numbers on each. 

How can a spreadsheet be effectively ‘decluttered’? 

If a model is to tell an effective story, then the numbers need to be laid out in a way that is lean and devoid of clutter.This means the removal of figures with too many digits. A balance sheet in which some of the numbers have eight significant figures can be hard to read. It is important to scale output in millions or billions so that there are just two, three or four digits visible for most of the numbers on the page. Other forms of clutter could include showing figures with too much labelling. 

Speak to an expert

Speak to an expert today to access this and all of the content on our platform.

David Colver

David Colver

David Colver has spent the years since 1990 building Operis, which offers various kinds of financial advice about project finance. He started out in the 1980s at Rothschild, working in project finance and contributing analysis to deals of other kinds.

There are no available videos from "David Colver"