Monthly Budget Spreadsheet

	A	B	C	E
1
2		Monthly Scenario
3		Good	Bad	Comments
4
5	Income #1	4000	4000	* After tax income is what is important here
6	Income #2	2500	2500
7	Total Income	6500	6500
8
9	Individual Expenses #1:
10	Shopping	-75	-125
11	Credit Cards	-125	-150
12	Student Loans	-350	-350
13	Entertainment	-100	-125
14	Other Items	0	0
15	Other Items	0	0
16	Other Items	0	0
17	Individual Expenses #1	-650	-750
18
19	Person #1 Net	3350	3250	* How much Person #1 should have to go towards the household expenses
20
21	Individual Expenses #2:
22	Shopping	-50	-75
23	Credit Cards	-90	-110
24	Student Loans	-225	-250
25	Entertainment	-75	-100
26	Other Items	0	0
27	Other Items	0	0
28	Other Items	0	0
29	Individual Expenses #2:	-440	-535
30
31	Person #2 Net	2060	1965	* How much Person #2 should have to go towards the household expenses
32
33	Total Net	5410	5215	* This is how much the both of you should have towards household expenses
34
35	General Expenses:
36	TV & Internet	-135	-150
37	Cell phone	-120	-135
38	Commuting Expenses	-220	-220
39	Gasoline	-250	-300
40	Groceries	-500	-550
41	Restaurants	-150	-200
42	Pet Expenses	-75	-100
43	Car Lease	-250	-250
44	Car Insurance	-75	-75
45	Pharmacy	-35	-55
46	Shopping for Home	-50	-70
47	Utilities	-350	-450
48	Other Items	0	0
49	Other Items	0	0
50	General Expenses	-2210	-2555
51
52	Money Left for Mortgage	3200	2660	* What do you think?
53				* Mortgage can include principal, interest, taxes, insurance, and other expenses
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