A | B | C | D | F | G | H | I | J | K | L | M | N | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Fill in the colored cells to auto populate the rest of the information. | ||||||||||||
2 | % Of Budget | Person 1 Income | Joint Income | Monthly Income | |||||||||
3 | Gross Monthly Income | 100 | $10,000.00 | $10,000.00 | $833.33 | Annual Spending | Annual Balance | ||||||
4 | Needs | 50 | $5,000.00 | $5,000.00 | $416.67 | $6,144.00 | -$1,144.00 | ||||||
5 | Wants | 30 | $3,000.00 | $3,000.00 | $250.00 | $11,340.00 | -$8,340.00 | ||||||
6 | Savings | 20 | $2,000.00 | $2,000.00 | $166.67 | $2,400.00 | -$400.00 | ||||||
7 | |||||||||||||
8 | Expenses (Monthly) | Description | Person 1 | Monthly Spending | Annual Spending | Notes | |||||||
9 | Needs | Mortgage/Rent | $1,250.00 | $0.00 | $0.00 | ||||||||
10 | Needs | Car Payment | $192.00 | $192.00 | $0.00 | ||||||||
11 | Needs | Insurance | $123.00 | $123.00 | $1,476.00 | ||||||||
12 | Needs | Gas/Repair/Transit | $0.00 | $0.00 | |||||||||
13 | Needs | Groceries | $0.00 | $0.00 | |||||||||
14 | Needs | Electricity | $100.00 | $100.00 | $0.00 | ||||||||
15 | Needs | Child care | $0.00 | $0.00 | $0.00 | ||||||||
16 | Needs | Loan repayment | $89.00 | $89.00 | $1,068.00 | ||||||||
17 | Needs | Gas/Sewer/Trash | $0.00 | $0.00 | |||||||||
18 | Needs | Phone | $50.00 | $50.00 | $600.00 | ||||||||
19 | Needs | Personal Care | $250.00 | $250.00 | $3,000.00 | ||||||||
20 | Needs | Taxes | $0.00 | $0.00 | |||||||||
21 | Wants | Clothes | $150.00 | $150.00 | $1,800.00 | ||||||||
22 | Wants | Internet | $45.00 | $45.00 | $540.00 | ||||||||
23 | Wants | Cable/Satellite | $0.00 | $0.00 | |||||||||
24 | Wants | Improvements | $150.00 | $150.00 | $1,800.00 | ||||||||
25 | Wants | Dining out | $150.00 | $150.00 | $1,800.00 | ||||||||
26 | Wants | Entertainment | $100.00 | $100.00 | $1,200.00 | ||||||||
27 | Wants | Vacations | $0.00 | $0.00 | |||||||||
28 | Wants | Cash Spending | $250.00 | $250.00 | $3,000.00 | ||||||||
29 | Wants | Gift/Charity | $100.00 | $100.00 | $1,200.00 | ||||||||
30 | Wants | Other | $0.00 | $0.00 | |||||||||
31 | Savings | Retirement | $0.00 | $0.00 | |||||||||
32 | Savings | Emergency | $100.00 | $100.00 | $1,200.00 | ||||||||
33 | Savings | Other | $100.00 | $100.00 | $1,200.00 | ||||||||
34 | |||||||||||||
35 | |||||||||||||
36 | |||||||||||||
37 | |||||||||||||
38 | |||||||||||||
39 | |||||||||||||
40 | |||||||||||||
41 | |||||||||||||
42 | |||||||||||||
43 | |||||||||||||
44 | |||||||||||||
45 | |||||||||||||
46 | |||||||||||||
47 | |||||||||||||
48 | |||||||||||||
49 | |||||||||||||
50 | |||||||||||||
51 | |||||||||||||
52 | |||||||||||||
53 | |||||||||||||
54 | |||||||||||||
55 | |||||||||||||
56 | |||||||||||||
57 | |||||||||||||
58 |