This workbook contains a tool to ESTIMATE your maximum loan eligibility.
Simply fill in the red boxes on the tab named "2008-2009 Est Loan Eligibility."
The worksheet will then automatically calculate your ESTIMATED maximum
eligibility.
When completed, send the worksheet via email to mpeterso@tiu.edu.
There are two ways to do this:
1. Manual Method
1. Save the completed worksheet to your hard drive.
2. Send the file you have just saved as an email attachment to mpeterso@tiu.edu.
3. Please use the subject line "Loan Eligibility Worksheet for [Your Name]"
2. Automatic Method
1. This method requires macros to be enabled in your Excel settings.
How To Enable Macros
2. When the worksheet is complete, simply click the "Send Email" button.
To use the automatic email function of this workbook, macros must be enabled
in your Excel settings. Macros can be used by malicious programmers to
propagate computer viruses, and as a security measure they are disabled by
default. Never enable macros in a file from a source you don't know to be safe.
To enable macros, follow the steps below.
In Excel versions prior to 2007:
1. Go to Tools / Macro / Security.
2. Change the setting from High to Medium .
3. Close this workbook and reopen it.
4. Excel now asks you whether to enable macros. Select "Enable."
In Excel 2007:
1. Click the Office button in the upper left corner.
2. Click the Excel Options button at the bottom of the menu.
3. Select Trust Center on the left.
4. Click the Trust Center Settings button at the bottom right.
5. In the window that comes up, select Macro Settings on the left.
6. Select "Disable all macros with notification," then click OK.
7. Close this workbook and reopen it.
8. On the Security Warning strip underneath the Office ribbon, select Options.
9. On the dialog box, select "Enable this content," then click OK.
ESTIMATED LOAN ELIGIBILITY WORKSHEET FOR 2011-2012
WHAT THIS FORM CALCULATES:
After inputing your information, BOX 1 will provide you with the maximum amount you can request in loans (Subsidized and Plu s Loans). Box 2 Will provide you with a schedule of
your disbursments. If you have questions about how to apply for these loans please visit www.tiu.edu/law/financialaid/
S FILL IN THE RED BOXES TO REVIEW YOUR LOAN OPTIONS
T Date 11/7/2011
A Full Name
R *Estimated Family Contribution from FAFSA (also known as EFC) 0
T 0 Notes
ENTER ANTICIPATED ENROLLMENT *) Refer to your FAFSA results (SAR)
H Fall 2011 0 0 **) Awarded when accepted
E Spring 2012 0
R Summer 2012 0 0
E 0
IF AWARDED-ENTER YOUR AWARDED SCHOLARSHIP
Enter the annual dollar amount of your scholarship**
or select the scholarship percentage here 0%
THIS BOX TELLS YOU THE MAXIMUM DOLLAR AMOUNT YOU ARE ALLOWED TO REQUEST IN LOANS
1 (THIS IS WHAT THE SCHOOL IS LIMITED TO IN CERTIFYING YOUR LOAN FOR EACH KIND OF LOAN)
ELIGIBILITY SOURCE 1: DIRECT SUBSIDIZED LOANS (NOT CREDIT BASED) $ 910
Subsidized. Elg: $ 910
UnSub Elg: $ -
ELIGIBILITY SOURCE 2: DIRECT PLUS LOANS- (CREDIT PERMITTING) $ -
TOTAL ELIGIBILITY (Max. you can apply for in loans) $ 910
VISIT: http://www.tiu.edu/law/financialaid/ to learn how to apply
DISBURSEMENT SCHEDULE
2 (Select YES for Direct Plus Loan if you plan on or know you will procure this loan)
Fall Spring Summer Totals Confirmed by Student
Units 0 0 0
Tuition & Fees (Not including books) $ - $ - $ - $ -
Less Scholarship $ - $ - $ - $ -
Less Direct Student Loan $ (910) $ - $ - $ (910) Yes
Less Direct Plus Loan (Credit Based) Include in Calculation? No $ - $ - $ - $ - No
Balance Not Covered by Loans (Out of Pocket) $ - $ - $ -
Financial Aid Check to Student 2nd Week of School $ (910.00) $ - $ -
MISC SNAPSHOT OF ESTIMATED EXPENSES ALLOWED TO BORROW AGAINST BASED ON PROJECTED UNIT LOAD
Number of months eligible for loan coverage 0
Tuition and Fees ($750/unit) $ -
Reasonable Expenses $ 910
Cost of Attendance (COA) $ 910
Total Student Need (COA - EFC) $ 910.00
RATES/COSTS USED IN CALCULATIONS
SEMESTER RATES/EXPECTATIONS MONTHLY REASONABLE
EXPENSES USED IN
$/unit-Law $ 775.00 ELIGIBILITY
Food $ 310.91
ASB/ExamSoft $ 85.00 Housing $ 1,305.00
Books & Supplies Budget $ 440.84 Transportation $ 137.76
Loan fees $ 455.00 Personal/misc $ 305.80
HOW THE LOANS ARE CALCULATED
Subsidized Direct Unsubsidized Direct
$8,500 max $12,000 max Direct Loan-Plus Eligibility
COA COA COA
- EFC - Scholarship(s) - Direct Student Loan Total
- Scholarship(s) - Sub Eligibility - Scholarships'
= Sub Eligibility = Unsub Eligibility = Plus/Eligibility
TLS Rev. 1/5/2011
0%
50%
100%
Yes
No