Risk modeling the budget

Arkivert som Modelling av i 2013 0 kommentarer

Using risk modeling in the budget process will contribute to turning the budget into more of a strategic tool for management, as it will provide significantly more information and decision support than what a traditional static budget will do.

In traditional budgeting, the focus is on putting static assumptions on variables for the year or years to come, and then calculate one number for the expected result for the year or years.  Behind this number are assumptions that describe the economic reality the business is part of. Very few of these assumptions are essentially static, and really, the only thing you can be sure of is that the actual number will not be equal to the one number.

pinning jelly to the wall

Like pinning jelly to a wall

The traditional budget approach is much like pinning jelly to a wall.  You know it’s not going to stay there, even if you manage to pin it up there in the first place.

It is almost impossible (very low probability indeed) to nail all of these budget assumptions with deterministic parameters. Nevertheless, the whole organization uses a lot of resources and a high degree of apparent precision on setting these assumptions.  Often they are also set as a mix of neutral assumptions and goals, making it very difficult to measure the results after the fact.

Alternative to traditional budgeting

An alternative way to budget is to use risk modeling. Focus will shift from «one number» to the expected economic result with a distributed outcome. The distribution of the result describes how well – or bad – the business’ results may become, taking into account that most assumptions are indeed uncertain. Focus will be on describing and quantify the uncertainty in key assumptions, and in turn get a quantification of what this uncertainty may mean in economic terms.

Key assumptions, the drivers of value creation, are described by their

  • Expected value
  • High value
  • Low value

A traditional Excel-based budget model can, using the tool Excel @ Risk or another simulation tools, turn the budget into a risk model. The model will calculate what the expected outcome is – given the uncertainty in assumptions.  It can also describe the best and worst outcomes for the financial variables the budget model calculates. The outcomes can be show as a probability distribution. In addition, such a model can be used to assess which variables are the main drivers of value creation.

The value creation goals of the business would then be given probabilities for the target being reached. The business will thus have an assessment of whether its goals are realistic.

How to do it

The basic procedure for this kind of modeling is:

  1. Establish a base scenario
    which is like the traditional budget, but with neutral values ​​- ie no built-in targets
  2. Set high and low values ​​for key assumptions
    which must be realistic and based on experience and historical analysis as well as assumptions about future development
  3. Calculate the expected value given uncertainty in assumptions
    using a simulation model that gives the expected budget value and its distribution
  4. Setting goals for the year or years at a given probability level
    for example 40-60, at the level where it is 40% likely that the result will be better and 60% likely that it will be worse

In the example below, the expected result is 2.75 while the targeted result is 2.85 with a probability of 40% for it being at that level or higher.

budget expected and target

A budget model like this will in addition be able to provide answers to questions like

  • How likely is it that the result will be significantly worse than expected?
  • How much capital will the company need?
  • How likely is it that the company gets a result which puts refinancing (or financing) at risk?
  • What is the probability of being able to meet the owners’ demands for return?

Using this kind of modeling , the business focus moves from «one number» to a discussion on probable outcomes and what measures can be taken if the results most likely will not meet the business’ requirements for return on capital.

The budget will to a greater degree become a strategic tool for management, because it provides essential information for decision-makers in a way the traditional budget approach will not.

Legg igjen en kommentar