Budget Example

	A	C	E	G	H
1	Budget categories in Excel
2		Budget	Balance
3	Mortgage	$1,200.00	$800.00
4	Water/sewer/trash	$50.00	$50.00
5	Electric/gas	$150.00	-$200.00		Guideline percentages %
6	short term house repairs	$100.00	$100.00	Housing	30%
7	LT house repairs	$300.00	-$5,000.00	Auto	14%
8	Car repairs	$150.00	$500.00	Food	12%
9	Groceries/eating out	$700.00	$500.00	Insurance	5%
10	Life insurance	$100.00	$600.00	Giving	5%
11	Worldvision	$200.00	$50.00	Entertainment	7%
12	Travel	$200.00	$200.00	Clothing	6%
13	Date Nights	$100.00	$100.00	Savings	5%
14	Cable/internet/cell phones	$100.00	$100.00	Medical	4%
15	Clothes & haircuts	$100.00	$600.00	Misc.	5%
16	Car savings	$300.00	$1,500.00	Invest/pay down debt	7%
17	Emg fund	$100.00	$1,500.00
18	Kids	$100.00	$200.00		100%
19	Misc (incl AAA)	$100.00	$100.00
20	Gifts	$100.00	$100.00
21	His fun money	$50.00	$15.00
22	Her fun money	$50.00	-$45.00
23	Roth IRA	$250.00	$130.00
24
25	Net Pay	$4,500.00	$1,900.00
26
27		net pay	current zero balance budget (each dollar is accounted for)
28
29
30
31
32
33
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
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100