Income, expenditure, Savings, Budget planning with Excel
The three basic elements of a budget planner, the income, expenditure and remaining Budget are:
- Your monthly Budget is normally made up of your revenue. What you count is what you decide for yourself. In the following example, we list examples of alimony payments, salary and interest.
- To make your budget planner clearly, you should disconnect Fixausgaben and variable expenses each other. Rent, insurance, memberships, and contracts are always the same expenditure. Food, train tickets and other expenses vary. We list them so an extra.
- What remains at the end of the month, your Savings. At the same time, this field will show you the beginning of a month, how much money you have and how much you have in the current month.
So you create your budget planner in Excel
This short guide will show you how to create a budget planner. Instead of our information, you can simply insert your own information. Keep in mind, however, that the specified in the manual fields differ.
Copy Of Budget Planner
1) Monthly Budget calculate
- You can write to the field A2 "Monthly Budget".
- In the adjacent field B2 put the formula "=sum (B3:B14)".
- Then, click lists in the row A under the "Monthly Budget" the names of all of their revenue. In our example, the "content", "maintenance" and "interest".
- In the adjacent row B, enter the respective sum of money. In the example, 600€, 400€ and 5€.
- In the field B2 should now appear in your monthly budget.
Monthly Budget
2) Monthly expenses to calculate
- Write to box D2 'expenditure', to D3 "fixed expenses" and in the field D9 "Variable expenses".
- In the adjacent fields E2, E3 and E9, put successively the formulas "=SUM(E3+:E9)", "=SUM(E4:E8)" and "=SUM(E10:E15)".
- Among the fixed expenses, list your rent and other monthly equal payments. In the example, rent, insurance, mobile phone contract, tuition fees, and a membership of xy are.
- Next to each name you enter, as in the case of the statement of revenue of the amount.
- With the variable expenses as described in point 3 and 4 above.
Monthly Expenditure
3) calculation of your remaining budget
So far, the table only shows you how much money you get per month and how much you spend. Now you can complement the item that gives you an Overview of your remaining budget. Thus, this indicates a reliable how much money you have available, you need to keep the table, of course, always up to date and new issues enter.
- Write to box A15 "residual budget".
- In the field B15 you put the formula "=SUM(B2-E2)". So you subtract your expenses from your revenue.
The manual refers to the Microsoft Excel 2007. As an example we calculate with a student budget. Who is it more comfortable, and possibly even more detailed I would like to be a Excel template for budget planning, advised.
