How to Calculate Percentage of Budget Spent in Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

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.

how to calculate percentage of budget spent in excel

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.

Input the Budget of Different Sectors


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.

Determining Budget Spent


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.

Calculating Percentage of Budget Spent

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.

how to calculate percentage of budget spent in excel

Eventually, we’ll get the output like this.

how to calculate percentage of budget spent in excel

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.

How to Calculate Percentage Increase of Budget

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.

how to calculate percentage of budget spent in excel

Secondly, press ENTER to get the output and then use the Fill Handle to get other outputs like this.

how to calculate percentage of budget spent in excel

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.

How to Calculate Percentage Decrease of Budget

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.

how to calculate percentage of budget spent in excel

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.

how to calculate percentage of budget spent in excel


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

What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Shajratul Alam Towhid
Shajratul Alam Towhid

Hello, myself Shajratul Alam Towhid. Basically, I am a Naval Architect who wants to expand knowledge in the field of Microsoft Excel. I wish all of my articles will be beneficial for the readers.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo