Budget against actual
Build the monthly budget review that finance teams run: variances, percentages and highlighted overspends.
1. Download your workbook
Each download has its own data, so your answers are yours alone.
2. Do the work in Excel
- Calculate the variance. In D2:D9, add formulas for Actual minus Budget.
- Calculate the percent. In E2:E9, add formulas for the variance as a percent of Budget.
- Highlight overspends. Add conditional formatting to column D that highlights positive variances.
- Total it up. In B10, C10 and D10, add formulas for the totals.
Save the file as an Excel Workbook (.xlsx) when you’re done.