Software for Volunteer Treasurers

Budgeting Exercise 15

Monitoring Budget Performance

This exercise is about monitoring actual financial performace against budgeted financial performance by calculating the magnitude of the variance (difference) in both dollar and percent terms.

You are provided with an Excel template that compares actual income and expenditure with budgeted income and expenditure.  Your task is to calculate the variance (difference) in dollar and percent terms.

Budgeting Exercise on Variance Analysis for monitoring actual against budget performance

Advice is also given on how to signify whether a variance is favourable or adverse by the use of brackets, and how to achieve bracketing around negative numbers in MS Excel.

Online higher education
help with Excel
answers to budgeting exercises