If you are looking for how to calculate the percentage of budget spent in Excel, then you are in the right place. Every independent nation as well as different organizations makes their budget every year where each and every detail of financial income and expenditure are included. In this article, we’ll discuss how to calculate the percentage of the budget spent in Excel.
Download Practice Workbook
Steps to Calculate Percentage of Budget Spent in Excel
Excel offers some simple steps to calculate the percentage of budget spent. We just need to organize the information properly and use simple arithmetic formulas to calculate it. We just need to follow the steps below.
1. Determining Budget Sectors
In the first step, we need to specify the budget sectors. A country’s budget includes many sectors necessary for the proper running of that country. Here, in the following dataset, we have included 9 different budget sectors in Column B.
We’ll find out the percentage spent on these sectors.
Read More: How to Apply Percentage Formula for Multiple Cells in Excel (5 Methods)
2. Input the Budget of Different Sectors
Secondly, in this step, we have to include the Budget (Million) of the mentioned sectors. We need to collect them from the country’s annual budget data. Here, the Budget is placed in Column C.
Read More: Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)
3. Determining Budget Spent
Thirdly, we need to add the budget spent in Column D. You can collect these data from the annual budget data.
Read More: How to Use IF and Percentage Formula in Excel (2 Easy Ways)
Similar Readings
- How to Calculate Percentage of Percentage in Excel (2 Examples)
- Calculate Annual Growth Rate in Excel (3 Methods)
- How to Calculate Percentage of Completion in Excel (3 Methods)
- Calculate Gross Profit Margin Percentage with Formula in Excel
- How to Show One Number as a Percentage of Another in Excel
4. Calculating Percentage of Budget Spent
This step is the primary step to calculate the percentage of the budget spent.
Firstly, write the following formula in the E5 cell like this.
=D5/C5
Here, D5 and C5 refer to the Budget Spent and Budget in Education.
Secondly, press ENTER to get the output as 0.5.
Thirdly, use the Fill Handle by dragging down the cursor while holding the right-bottom corner of the E5 cell like this.
Eventually, we’ll get the output like this.
Fourthly, select the cells E5:E13 > go to Home > click % sign in the Number box.
Consequently, the output is like this.
Read More: Percentage Formula in Excel (6 Examples)
How to Calculate Percentage Increase of Budget
We can calculate the percentage increase of a budget very easily using Excel with simple arithmetic formula. In the following dataset, we have column headers as Fiscal Year, Total Budget (Billion). We need to calculate Percentage Increase in Column D. We just need to follow some simple steps.
Firstly, write the following formula in the D6 cell like this.
=(C6-C5)/C5
Here, C6 and C5 refer to the Total Budget of $145 and $130 respectively.
Secondly, press ENTER to get the output and then use the Fill Handle to get other outputs like this.
Thirdly, select the cells D6:D10 > go to Home > click % sign in the Number box.
Finally, we’ll get a percentage increase like this.
Read More: How to Calculate Growth Percentage with Formula in Excel
How to Calculate Percentage Decrease of Budget
We can also calculate percentage decreases by using Excel. Suppose, we need to find out the percentage change in Column D which has a column header as Percentage Decrease.
Firstly, write the formula in the D5 cell.
=(C6-C5)/C5
Here, C6 and C5 refer to the Total Budget of $120 and $130 respectively.
Secondly, press ENTER and use the Fill Handle to get the output like this.
Here, the outputs are negative which actually means the percentage change is negative. It actually means the percentage decreases.
Now, select the cells D6:D10 > go to Home > click % sign in the Number box.
Eventually, the negative percentage increase i.e. percentage decrease is like this.
Read More: How to Calculate Minus Percentage in Excel (2 Methods)
Conclusion
That’s all about today’s session. And these are the ways to calculate the percentage of the budget spent in Excel. We strongly believe this article would be highly beneficial for you. Don’t forget to share your thoughts and queries in the comments section and explore our website ExcelDemy, a one-stop Excel solution provider.
Related Articles
- Calculate Percentage in Excel Based on Cell Color (4 Methods)
- How to Calculate Percentage of a Number in Excel (5 Easy Ways)
- Calculate Total Percentage in Excel (5 Ways)
- How to Calculate Average Percentage in Excel (3 Easy Methods)
- Percentage Difference Between Two Percentages in Excel
- How to Use Excel Formula to Calculate Percentage of Grand Total
- Calculate Contribution Percentage with Formula in Excel