| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
1 |  | UC Berkeley - Center for Educational Partnerships (CEP) >>Financial Aid Comparison Tool | ||||||||
2 | For additional college planning information and resources visit our resource page: https://cep.berkeley.edu/resource-directory Copyright © The Regents of the University of California. All Rights Reserved. Created by Center for Educational Partnerships Make a copy of this spreadsheet and use it to compare your financial aid awards! | |||||||||
3 | Financial Aid Packages | University: | University: | University: | University: | University: | University: | University: Example A | University: Example B | Example A: COA = $700 Total Gift Aid = $100 Net Cost (COA-Gift/Aid) = $600 Contribution/Loan = $200 Out of Pocket Expense = ($600-$200) = $400 Students needs to pay $400 not currently availalbe via loan or parent contribution (will likely get via work). |
4 | Cost of Attendance (COA) - if living with your parents, don't include costs for housing & meals (room & board). | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $700.00 | $800.00 | |
5 | ENTER ANY AMOUNT GIVEN TO YOU IN FORM OF GRANTS OR SCHOLARSHIPS: | |||||||||
6 | Federal Pell Grant Award (Awarded for FAFSA applicants only) | $0 | $0 | $0 | $0 | $0 | $0 | $100 | $100 | |
7 | Institutional/University Grant | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
8 | ALL Other Scholarships (via university or won independently) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
9 | Cal Grant Award (State Grant) (Awarded for Dream App and FAFSA Applicants) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
10 | Total Gift Aid (Grants & Scholarships) | $0 | $0 | $0 | $0 | $0 | $0 | $100 | $100 | |
11 | CALCULATE THE AMOUNT OF MONEY THAT NEEDS TO BE CONTRIBUTED BY STUDENT AND/OR PARENT (TOTAL NET COST): | |||||||||
12 | TOTAL Net Cost: (COA - Total Gift Aid) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $600.00 | $700.00 | Example B: COA = $800 Total Gift Aid = $100 Net Cost (COA-Gift/Aid) = $700 Contribution/Loan = $1000 Out of Pocket Expense = ($700-$1000) = - $300 The Out of Pocket Expense is a NEGATIVE number, meaning the student is taking out $300 dollars in loans that they don't need (considering taking out less in loans). |
13 | USING AWARD LETTERS, BREAK DOWN HOW YOU WILL PAY A PORTION OF YOUR TOTAL NET COST: | |||||||||
14 | PARENT Contribution (EFC) | $0 | $0 | $0 | $0 | $0 | $0 | $100 | $0 | |
15 | Federal Direct Subsidized Loan | $0 | $0 | $0 | $0 | $0 | $0 | $100 | $1,000 | |
16 | Federal Direct Unsubsidized Loan | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
17 | Federal Direct Plus Loan | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
18 | Federal Work-Study | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
19 | Total from 7 rows above: | $0 | $0 | $0 | $0 | $0 | $0 | $200 | $1,000 | |
20 | OUT OF POCKET EXPENSE: Difference between the Total Net Cost and contributions (loans, parent contributions, work study). If the amount is negavite, consider taking out less loans. | $0 | $0 | $0 | $0 | $0 | $0 | $400 | -$300 | |
21 | ||||||||||