A | B | C | D | E | F | |
---|---|---|---|---|---|---|
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 | Tuition | With All Financial Aid: | ||||
6 | Fees | total financial aid - total expenses: | $0.00 | |||
7 | Room/board | total financial aid - total billed expenses (red only): | $0.00 | |||
8 | Health insurance | |||||
9 | Additional fees (loan fee) | Without Loans: | ||||
10 | Books/supplies | total financial aid w/out loans - total expenses: | $0.00 | |||
11 | Personal | total 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 |