How do I calculate a budget in Excel?

To calculate the total planned budget, input the formula “**=SUM(Planned Expenses Total, Planned Funds Total, Planned Savings Total)**”. Then, to calculate your planned balance use the formula “=SUM(Total Planned Spending – Total Planned Income)”.

**How do you calculate budget variance in Excel?**

Each worksheet should include 2017 budget, 2018 budget, and the variance for each of the 4 budget categories; the formula to calculate the variance for each budget category is as follows:

variance = (2018 budget 2017 budget)/2017 budget.

__How does excel calculate budget vs actual?__