ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
How to use this: To enter your own information, make a copy of this spreadsheet (File > Make a copy...)
2
Award Letter Analyzer
3
School 1School 2School 3School 4School 5School 6School 7
4
5
Cost of Attendance
6
This is the cost of attendance for the entire year, as calculated by each school. Cost of attendance includes direct costs (money to be paid directly to the school) and estimated indirect costs (money spent on books, personal expenses, transportation to and from campus, etc) associated with attending each school.
7
8
Tuition & Fees$0.00$0.00$0.00$0.00$0.00$0.00$0.00
9
Room & Board$0.00$0.00$0.00$0.00$0.00$0.00$0.00
10
Books$0.00$0.00$0.00$0.00$0.00$0.00$0.00
11
Personal Expenses$0.00$0.00$0.00$0.00$0.00$0.00$0.00
12
Transportation to/from Campus$0.00$0.00$0.00$0.00$0.00$0.00$0.00
13
14
Total Direct Costs$0.00$0.00$0.00$0.00$0.00$0.00$0.00
15
Total Indirect Costs$0.00$0.00$0.00$0.00$0.00$0.00$0.00
16
17
Total Cost of Attendance$0.00$0.00$0.00$0.00$0.00$0.00$0.00
18
19
Gift Aid
20
Money that does not have to be repaid
21
*If your award letter does not include some of these categories, enter a 0.
22
23
Pell Grant$0.00
24
State Grant$0.00
25
SEOG Grant$0.00
26
College Grants/Scholarships$0.00$0.00$0.00$0.00$0.00$0.00$0.00
27
Other Grants/Scholarships$0.00$0.00$0.00$0.00$0.00$0.00$0.00
28
29
Total Gift Aid$0.00$0.00$0.00$0.00$0.00$0.00$0.00
30
31
Loans
32
Money that will need to be repaid, with interest
33
*If your award letter does not include some of these categories, enter a 0.
34
35
Direct Subsudized Loan$0.00$0.00$0.00$0.00$0.00$0.00$0.00
36
Direct Unsubsudized Loan $0.00$0.00$0.00$0.00$0.00$0.00$0.00
37
Other Loan (do not include Parent PLUS loans)$0.00$0.00$0.00$0.00$0.00$0.00$0.00
38
39
Total Loans$0.00$0.00$0.00$0.00$0.00$0.00$0.00
40
41
Estimated Bill
42
This is the amount you can expect to pay the college directly, calculated by subtracting scholarships, grants, and loans, from the Direct Cost calculated above. If you do not want to take out loans, simply delete that information above to see how much you would owe without loans.
43
*Colleges will typically bill students before the fall semester and again before the spring semester, splitting the costs evenly
44
Fall Semester$0.00$0.00$0.00$0.00$0.00$0.00$0.00
45
Spring Semester000000$0.00
46
47
Total Net Cost for 2019-20000000$0.00
48
49
Indirect Costs
50
This is the money that is not directly paid to the college but needs to be budgeted for, like money for your books, school supplies, travel to and from campus, etc. Schools may offer you a work study, which you will receive in paychecks as you work throughout the semester--like a regular job. Work Study (sometimes combined with a summer job and parent contribution) is a great way for students to earn money to cover these additional costs.
51
52
Indirect Costs$0.00$0.00$0.00$0.00$0.00$0.00$0.00
53
Additional Indirect Costs$0.00$0.00$0.00$0.00$0.00$0.00$0.00
54
55
Work Study$0.00$0.00$0.00$0.00$0.00$0.00$0.00
56
Summer job estimate$0.00$0.00$0.00$0.00$0.00$0.00$0.00
57
Family contribution estimate$0.00$0.00$0.00$0.00$0.00$0.00$0.00
58
59
Total Student & Family contribution $0.00$0.00$0.00$0.00$0.00$0.00$0.00
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