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 is included. In this article, we’ll discuss how to calculate the percentage of the budget spent in Excel.
How to Calculate Percentage of Budget Spent in Excel: 3 Simple Steps
Excel offers some simple steps to calculate the percentage of the budget spent. We just need to organize the information properly and use simple arithmetic formulas to calculate it. We 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.
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.
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.
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.
How to Calculate Percentage Increase of Budget
We can calculate the percentage increase of a budget very easily using Excel with a simple arithmetic formula. In the following dataset, we have column headers as Fiscal Year, Total Budget (Billion). We need to calculate the 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.
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.
Download Practice Workbook
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.
Related Articles
- How to Calculate Error Percentage in Excel
- How to Calculate Cumulative Percentage in Excel
- How to Calculate Mean Percentage Error in Excel
- How to Calculate Remaining Shelf Life Percentage in Excel
- How to Calculate Percentage of Completion in Excel
- How to Calculate Utilization Percentage in Excel
- How to Calculate Absenteeism Percentage in Excel
- How to Calculate Savings Percentage in Excel
- How to Calculate Productivity Percentage in Excel
- How to Calculate Variance Percentage in Excel
- How to Calculate Accuracy Percentage in Excel
- How to Calculate Grade Percentage in Excel
- How to Calculate Win-Loss Percentage in Excel
- How to Calculate SLA Percentage in Excel