Template College Expense Worksheet

	A	B	D	F	H	J
1
2
3
4			College A	College B	College C	College D
5	Tuition		23,800.00	30,270.00	33,864.00	28,210.00
6	Room		5,800.00	4,172.00	8,512.00	10,100.00
7	Dining		3,780.00	3,060.00
8	Board
9	Activity Fee		770.00
10	Book Fees			1,248.00	655.00
11	Health Fee		340.00
12	Misc. Fees		655.00		229.00	600.00
13
14	Total College		35,145.00	38,750.00	43,260.00	38,910.00
15
16	Years	4	4	4	4	4
17
18	Total College		140,580.00	155,000.00	173,040.00	155,640.00
19
20	Spending	1,500.00	1,500.00	1,500.00	1,500.00	1,500.00
21
22	Total College & Spending 4 years		146,580.00	161,000.00	179,040.00	161,640.00
23
24
25	Summer Before	3,500.00	-3,500.00	-3,500.00	-3,500.00	-3,500.00
26	Summer after 1st Year	3,500.00	-3,500.00	-3,500.00	-3,500.00	-3,500.00
27	Summer after 2nd Year	3,500.00	-3,500.00	-3,500.00	-3,500.00	-3,500.00
28	Summer after 3rd Year	3,500.00	-3,500.00	-3,500.00	-3,500.00	-3,500.00
29	Intial College Savings	8,500.00	-8,500.00	-8,500.00	-8,500.00	-8,500.00
30
31
32	Total Savings & Summer Earnings		-22,500.00	-22,500.00	-22,500.00	-22,500.00
33
34	Merit Scholarships		-2,250.00	-9,000.00	-11,000.00	-10,000.00
35
36	Total Merit	x 4 years	-9,000.00	-36,000.00	-44,000.00	-40,000.00
37
38	Art / Music Scholarship	150.00	-150.00	-150.00	-150.00	-150.00
39
40	Total Savings & Scholarships		-31,650.00	-58,650.00	-66,650.00	-62,650.00
41
42	Total Loan Needed		114,930.00	102,350.00	112,390.00	98,990.00
43
44	Interest Rate	6.80%
45
46	Term	10
47
48	Monthly Payment		$1,323	$1,178	$1,293	$1,139
49		12
50			$15,871	$14,134	$15,521	$13,670
51
52	Annual Salary	50000	31.74%	28.27%	31.04%	27.34%
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