FP Academy · INSIGHTS
How to calculate a budget variance in Excel
Calculate the difference between budget and actual in DKK and percent, then explain what the sign means.
A budget variance measures the difference between a plan and the actual outcome. The arithmetic is straightforward. Interpretation depends on what the item represents.
Choose a definition
Here, variance means actual minus budget. State the convention and use it consistently. A fictional company budgets DKK 100,000 for wages and spends DKK 110,000. Its variance is 110,000 − 100,000 = DKK 10,000.
Calculate the amount
Put budget in B2 and actual in C2. In D2 enter =C2-B2. The result is 10,000. Apply a number or currency format so the amount is easy to read.
Calculate the percentage
In E2 enter =D2/B2 and format the cell as a percentage. The result is 10%. The percentage format already scales the display by 100.
If the budget is zero, the percentage is undefined. In English-language Excel, use this formula to flag it:
=IF(B2=0,"Not calculable",D2/B2)
Show the DKK variance and explain the circumstances separately.
Interpret the sign
A positive cost variance under this convention means spending exceeded budget. A positive revenue variance means income exceeded budget. Higher spending may reflect additional activity that also generated income. Assess the cause before judging performance.
Add a brief explanation
- Which item differs from budget?
- Does price, activity or timing explain the movement?
- Is the cause documented or does it need investigation?
- Does it affect the outlook for the rest of the year?
FP Academy teaches budget variance analysis as part of a practical Excel review. The aim is to calculate the difference and explain it in terms the reader can use. The figures are fictional and use the convention stated above.
