College budget template for Excel.xlsx

	B	C	D	E	F	G
1	COLLEGE BUDGET TEMPLATE

2	SUMMARY	Semester 1	Semester 2	Semester 3	Semester 4	TOTAL
3	Total Income	$ 3,250.00	$ 3,150.00	$ -	$ -	$ 100.00
4	Total Expenses	$ 2,458.00	$ 900.00	$ -	$ -	$ 1,558.00
5	Balance	$ 792.00	$ 2,250.00	$ -	$ -
6
7	INCOME
8
9	Salary/Wages	$ 800.00	$ 800.00
10	From Parents	$ 500.00	$ 500.00
11	From Student Loans	$ 750.00	$ 750.00
12	From Scholarships	$ 200.00	$ 200.00
13	From Grants	$ 500.00	$ 500.00
14	From Financial Aid	$ 300.00	$ 200.00
15	Transfer from Savings	$ 200.00	$ 200.00
16	Other
17
18	TOTAL	$ 3,250.00	$ 3,150.00	$ -	$ -
19
20	EXPENSES
21	HOME & SCHOOL
22	Tuition	$ 750.00	$ 750.00
23	Fees (class, parking, labs, clubs, etc.)	$ 25.00
24	Housing/Rent	$ 40.00
25	Food Plan	$ 44.00
26	Dorm/Room Furnishings	$ 20.00
27	Textbooks	$ 15.00
28	School Supplies
29	Internet	$ 29.00
30	Cell Phone
31	Other
32		$ 923.00	$ 750.00	$ -	$ -
33	TRANSPORTATION
34	Car Payments	$ 250.00
35	Auto Insurance	$ 100.00
36	Fuel	$ 100.00	$ 150.00
37	Public Transportation
38	Repairs/Maintenance
39	Registration/License	$ 100.00
40		$ 550.00	$ 150.00	$ -	$ -
41	DAILY LIVING
42	Groceries	$ 250.00
43	Dining Out	$ 100.00
44	Clothing
45	Cleaning
46	Salon/Barber	$ 100.00
47		$ 450.00	$ -	$ -	$ -
48	ENTERTAINMENT
49	Video/DVD/Movies	$ 250.00
50	Concerts/Plays	$ 100.00
51	Sports	$ 100.00
52	Outdoor Recreation
53		$ 450.00	$ -	$ -	$ -
54	HEALTH
55	Student Health Insurance	$ 65.00
56	Gym Membership	$ 20.00
57	Doctors/Dentist Visits
58	Medicine/Prescriptions
59		$ 85.00	$ -	$ -	$ -
60
61	TOTAL	$ 2,458.00	$ 900.00	$ -	$ -
62
63	COLLEGE EXPENSE ESTIMATOR
64	Total Needed Each Month:	$ 555.00
65	Description	Amount	Add to Total?	Notes
66	Laundry	$25.00	NO	Take to Mom's
67	Food (main meals)	$95.00	YES
68	Food (snacks, coffee, etc.)	$25.00	YES
69	Heath Insurance	$0.00	NO	On Mom's plan
70	Medical Expenses	$50.00	YES	Asthma prescription
71	Clubs/Organizations	$10.00	YES	Breakfast club
72	Clothes	$60.00	NO	Get Mom to buy
73	Entertainment	$50.00	YES	Includes music downloads
74	Hygiene (deodorant/shampoo/etc.)	$20.00	YES
75	Haircut/Manicure/Pedicure	$10.00	YES	Go to beauty school
76	Parking	$15.00	YES
77	Car Payment	$175.00	YES	See if Dad will pay half
78	Car Insurance	$0.00	NO	Mom will cover cost
79	Gas	$50.00	YES	Will take bus most of the time
80	Other Transportation	$15.00	YES	Bus pass
81	Cell Phone	$20.00	NO	Get Mom to cover cost
82	Cable	$50.00	NO	Get Dad to cover cost
83	Internet Service	$0.00	NO	Included in dorm cost
84	Utilities (electricity/natural gas)	$0.00	NO	Included in dorm cost
85	Gym Membership	$35.00	NO	Can use campus facility instead
86	Computer Supplies (printer ink/paper)	$10.00	YES
87	Emergency Money	$30.00	YES
88	Other
89
90	CLICK HERE TO CREATE IN SMARTSHEET
91
92
93
94
95
96
97
98
99
100