Course
Project: household budget
Build a real six-month budget step by step: add up the expenses, see what is left, put savings aside at a fixed rate and find out how much of your income you spend.
Exercise 1 of 7
Step 1: monthly expenses
This is your budget for six months. In G2:G7, add up each month’s expenses, rent to other (C2:F2 for January), with SUM.
| Month | Income ($) | Rent ($) | Groceries ($) | Transport ($) | Other ($) | Expenses ($) | Savings rate | ||||
| Jan | 3,200.00 | 1,100.00 | 420.00 | 160.00 | 420.00 | 10% | |||||
| Feb | 3,200.00 | 1,100.00 | 385.00 | 145.00 | 485.00 | ||||||
| Mar | 3,350.00 | 1,100.00 | 460.00 | 170.00 | 330.00 | ||||||
| Apr | 3,200.00 | 1,100.00 | 410.00 | 150.00 | 390.00 | ||||||
| May | 3,200.00 | 1,100.00 | 395.00 | 165.00 | 520.00 | ||||||
| Jun | 3,450.00 | 1,100.00 | 440.00 | 155.00 | 365.00 |