How to Calculate the Percentage of an Over-Budgeted Amount

By Markets Fool.com

Let's face it: Even the best budgets can't always predict your actual expenses. Things happen. Unexpected costs arise. That's life.

Continue Reading Below

That's why it's so useful to review your budget after a project is complete to understand why certain expenses were higher or lower than anticipated. One way to do that is to calculate the percentage over budget. Here's how it's done.

How to calculate the percentage of an over-budgeted amount
Calculating an over-budgeted amount is pretty straightforward. All you need is your original budget, the actual expenses, and maybe a calculator.

First, subtract the budgeted amount from the actual expense. If this expense was over budget, then the result will be positive.

Next, divide that number by the original budgeted amount and then multiply the result by 100 to get the percentage over budget. If your expenses were lower than your budgeted amount, then this number will be negative, describing the percentage under budget.

A practical example calculating the percentage over budget
To use this tool in a real-world setting, start by first analyzing the percentage over budget for the entire budget. After that, repeat the process for specific line items to see which were over budget and which were under budget.

Continue Reading Below

Here's an example for a generic home-improvement project.

Item

Budgeted Amount

Actual Expense

Materials

$500

$527

Labor

$200

$200

Equipment rental

$150

$157

Total budget

$850

$884

First, calculate the percentage over budget for the total budget to get an understanding of the overall project. Start by finding the difference between the actual total expenses and total budgeted amount. In this case, that's $34. Next, divide by the total original budget and multiply by 100, yielding a percentage over budget of 4%.

In other words, this project cost 4% more than anticipated, so it was just slightly over budget.

Scanning the individual line items, the labor expense was squarely on budget, while the materials and equipment rental contributed to the budget overage. It makes sense to calculate their percentage overages next.

Using the same math, the materials cost was 5.4% over budget, and the equipment rental was 4.7% over budget. Neither of these overages is substantial; each is small enough that the discrepancy could be attributed to something as simple as forgetting to include sales tax in the original budget.

Calculating percentages over budget is an indispensable budgeting tool
This example is admittedly very simple. However, this process is just as important for larger or more complex budgets. Whether you're planning for a family vacation, a home improvement project, or the operating budget of a Fortune500 company, the percentage difference between the budgeted amount and actual expense is a core analytical tool for every budget.

And now you have everything you need to know to put this tool to use in your budgets, big and small.

This article is part of The Motley Fool's Knowledge Center, which was created based on the collected wisdom of a fantastic community of investors. We'd love to hear your questions, thoughts, and opinions on the Knowledge Center in general or this page in particular. Your input will help us help the world invest, better! Email us atknowledgecenter@fool.com. Thanks -- and Fool on!

The article How to Calculate the Percentage of an Over-Budgeted Amount originally appeared on Fool.com.

Try any of our Foolish newsletter services free for 30 days. We Fools may not all hold the same opinions, but we all believe that considering a diverse range of insights makes us better investors. The Motley Fool has a disclosure policy.