All tools

Variance analysis

Measure the gap between actual and baseline, in both amount and percentage.

Result

Variance amount
140000.00
Variance percent
12.7273

Download the workbook

The method

  1. Absolute variance = actual less baseline; relative variance = that difference divided by the baseline.
  2. A zero baseline leaves the percentage undefined, and it is shown as undefined rather than as a misleading zero.

Built forAn accountant or analyst who needs an evidenced decision from period figures

When you need it

You need to explain a figure or compare alternatives before taking the analysis to management. Measure the gap between actual and baseline, in both amount and percentage.

The decision it supports

Use the result to explain a trend, gap or scenario effect, then connect it to an operating cause. The tool shows its method beside the result so you can review it.

What you receive

Variance analysis result

A shareable interactive result with findings, calculation method and an Excel workpaper carrying the same figures.

An example you can inspect

A ready-to-run example

The tool opens with: Actual = 1240000.00, Baseline = 1100000.00. Change any value to see its effect immediately.

Continue the workflow