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.
Let's create some data. Start from income of your household. We can also create graph to show it like this:
Let's also think about expenses. Monthly expenses can look like this:
Then you know about inflows and outflows of money. Yours cash flow sheet can look like this:
Lets create final budget sheet. It can look like this:
Here you can check free Budget Sheet.