Student Sample Budget

	A	B	C	D	E	H	I	J	K	M
1	Sample Personal Budget
2	Cells highlighted in green or blue are calculated using a formula
3
4	Gross yearly income:	45,000.00
5	Taxes (15.8%):		[15.8% of the Gross yearly income]
6	Net yearly income:		[Gross yearly income - taxes]
7
8	Monthly income:	100,000.00	[Net yearly income / 12]							Average of Jan..April
9						Actual Expenses:				Actual Expenses
10						Jan	Feb	Mar	April
11	Monthly expenses:			Car Payment	300.00	300.00	300.00	300.00	300.00
12				Car Taxes, Sticker	20.00	20.00	20.00	20.00	20.00
13				Car Insurance	80.00	80.00	80.00	80.00	80.00
14				Car Repair	30.00	0.00	0.00	0.00	150.00
15				Car: Gas	80.00	90.00	40.00	40.00	52.00
16				[Sum of car expenses]
17			800.00	Rent (1 roomate)		800.00	800.00	800.00	800.00
18			60.00	Utilities (Gas, Electric)		90.00	75.00	65.00	45.00
19			45.00	Medical		45.00	45.00	45.00	45.00
20			100.00	Parking		100.00	112.00	94.00	70.00
21			300.00	Food		350.00	324.00	230.00	305.00
22			50.00	Clothes		75.00	0.00	45.00	60.00
23			100.00	Travel (2 x year)		0.00	0.00	900.00	0.00
24			700.00	Student Loan: $56K, 5yrs.		700.00	700.00	700.00	700.00
25			[Monthly expenses sum]
26
27	Amount remaining / month:		[Monthly income - monthly expenses]			99,300.00
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