ABCDEF
1
Directions: First, go to "File" and "Make a Copy" to use this document. You will then be able to edit the spreadsheet and it will save to your Google Drive. Please modify amounts for each school you have received a financial aid award letter. You may need to add or subtract lines. Make sure to check that the formulas are working properly.
2
Color coding- Feel free to remove colors. I use them to indicate which costs are non-negotiable and which costs are flexible. I also use them to represent which financial aid items are free money and which have to be paid back.
3
4
Costs for Year
5
TuitionWith All Financial Aid:
6
Feestotal financial aid - total expenses:$0.00
7
Room/boardtotal financial aid - total billed expenses (red only):$0.00
8
Health insurance
9
Additional fees (loan fee)Without Loans:
10
Books/suppliestotal financial aid w/out loans - total expenses:$0.00
11
Personaltotal financial aid w/out loans - billed expenses:$0.00
12
Transportation
13
14
Total Expenses$0.00
15
Total billed expenses (red)$0.00
16
17
Financial Aid
18
Scholarship A
19
Scholarship B
20
Grant A
21
Grant B
22
Work Study
23
Federal Stafford Loan
24
Parent Plus Loan
25
26
Total Financial Aid:$0.00
27
Total Financial Aid w/out loans (green and peach):$0.00
28
Total financial aid w/out work study and loans (green only):$0.00
29
30
31