In this article we will create a budget calculator in Excel.

Let us try to create the data required for the budget calculator:

Let us create 3 tabs in Excel file named as:

  • Monthly Income
  • Monthly Expenses
  • Cash flow

And a final Budget sheet at the start.

Monthly Income

Let's create some data. Start from income of your household. We can also create graph to show it like this:

budget calculator simple graph

Monthly Expenses

Let's also think about expenses. Monthly expenses can look like this:

budget calculator monthly expenses

Cash flow

Then you know about inflows and outflows of money. Yours cash flow sheet can look like this:

budget calculator cash flow

Budget calculator

Lets create final budget sheet. It can look like this:

budget sheet

Here you can check free Budget Sheet.