340 likes | 524 Views
Session C-17. National Student Loan Database System- NSLDS Aggregate Calculations Brenda Seidel U.S. Department of Education Jim Yoder Vangent.
E N D
Session C-17 National Student Loan Database System- NSLDS Aggregate Calculations Brenda Seidel U.S. Department of Education Jim Yoder Vangent The PDF embedded document is the NSLDS Aggregate Calculations Participant Workbook used by participants in this session. It also contains a blank Aggregate Worksheet for FAAs to use when hand calculating consolidation loans. To view each Adobe Acrobat Document embedded in the various slides that follow, escape out of presentation mode and double click the Adobe Acrobat Document:
Objectives • Understand aggregate loan terms • Identify loan types that impact aggregate limit calculations • Hand calculate aggregates using NSLDS methodology
Defining & Using Aggregates • NSLDS Loan Terms • Outstanding Principal Balance (OPB) • Aggregate amounts • Aggregate Loan Information • Loan Level Aggregate Principal Balance • Net Loan Amount • Loan Amount less Cancellations and Refunds • Why are NSLDS Aggregate amounts used?
NSLDS Aggregate Totals Calculation Process
Calculate Each Loan Type’s Loan Level Aggregate OPB • NSLDS reviews loans in student’s financial aid history • Categorizes each loan into respective loan type (e.g., Sub or Unsub)
Calculate Each Loan Type’s Loan Level Aggregate OPB, cont. • Three main loan groupings: • Recent loans • Older loans • Consolidation Loans
Recent Loans • May have adjustments not yet posted • May have additional disbursements or adjustments not yet reported to NSLDS • Included at end of calculation as Pending Disbursements
Components of Recent Loans Loan Status (“in school”) Greater of: Disbursement Amount or OPB Loan Period End Date + 90 Days has not passed Pending Disbursement Amount = Net Loan Amount – Disbursement Amount
Hand Calc a Recent Loan • Review Student’s FAH • Exercise #1 Determine Recent Loans Agg OPB and Pending Disbursements: 1) Find the recent loan and determine the Agg OPB. Fill in section A of the worksheet. 2) Determine the recent loans pending disbursements and fill in section B of the worksheet.
Older Loans Included in Aggregate OPB calculations
Components of Older Loans Loan Status Loan Period End Date + 90 days have passed Lesser of: Disbursement Amount, OPB or Net Loan Amount
Hand Calc an Older Loan • Review Student’s FAH • Exercise #2 Determine Older Loan’s Agg OPB: 1) Find the older loan and determine the Agg OPB. Fill in section C of the worksheet.
Consolidation Loans (CL) & Aggregate OPB • Process to determine impact of CL on Aggregate OPB: • A. Identify underlying loans • B. Determine number of CLs & Totals • C. Determine Calculated Agg. OPBs • D. Determine CL’s Unallocated Agg. OPB • E. Calculate CL’s Combined Loans Agg. OPB
Identify Underlying Loans • Review Student’s FAH • Exercise #3 Identify the underlying loans: 1) Find the consolidation loan’s underlying loans and fill in section E of the worksheet. Enter the underlying loan number and its corresponding disbursement amount.
Consolidation Loans (CL) & Aggregate OPB • Process to determine impact of CL on Aggregate OPB: • B. Determine number of CLs & Total Amounts
Determine Calculated Agg. OPBs • Why is the ratio (%) important? • NSLDS determines the loan type amounts based on percentages / portions of the overall totals. 47% of the Consolidation loan is the Subsidized portion 35% of Consolidation loan is Unsub portion
Determine Calculated Agg. OPBs • Calculate ratio for each Loan Type - percentage of CL attributable to Loan Type Sum of Underlying Loans’ Disb Amts Ratio = Sum of CL Disb Amts
Example to determine a ratio • Determine ratio for subsidized loans • Total of underlying Sub Disbursement Amounts = $18,625 • Total of CL Disbursement Amounts = $39,000 • Ratio = $18625/$39,000 = 0.47756
Ratios for Loan Types/Amounts • Review Student’s FAH • Exercise #4 Determine totals to get your ratios: 1) Determine the totals for the underlying loan disbursements in section E of the worksheet. 2) Fill in the amounts for each consolidation loan in section D of the worksheet, and then total the disbursement amounts. 3) In section F, determine the Subsidized amounts and fill in columns 2 through 4. Do the same for the other loan types in sections G and H.
Example of applying ratios • Determine ratio for subsidized loans • Total of underlying Sub Disbursement Amounts = $18,625 • Total of CL Disbursement Amounts = $39,000 • Ratio = $18625/$39,000 = 0.47756 • Determine Calculated Subsidized Aggregates(Ratio CL Agg OPB Amount) • Calculated Subsidized Aggregate for CL #4= $8,119(0.47756 $17,000) • Calculated Subsidized Aggregate for CL #5= $10,506(0.47756 $22,000)
Determine Calculated Agg. OPBs • Determine each Loan Type’s Calculated Agg. OPB amount for each CL Ratio CL Agg. OPB Amt Aggregate =
Apply Ratios to Loan Types • Review Student’s FAH • Exercise #5 Apply the ratios to each loan type: 1) In section F, fill in column 5 then multiple the ratio for each consolidation loan to get their individual Subsidized calculated amounts. Do the same for the other loan types in section G and H. Total each sections calculated amounts.
Sum Loan Level Agg. OPBs by Loan Type • Collect all loan level Agg. OPB numbers • Roll individual calculated numbers into respective loan types
Sum Loan Level Agg. OPBs by Loan Type, cont. • Add in respective loan type’s pending disbursements • Display each loan type’s Aggregate OPB Totals in Aggregate Loan Information section
Subsidized Loan Aggregate Calculation Components • Subsidized OPB- Loan Types • (from Loan Summary- Agg. OPBs) • FFEL Subsidized (SF) • Recent or Older Loans • Direct Stafford Subsidized (D1) • Recent or Older Loans • Direct Consolidation Subsidized (D6) • Calc’d Sub Amounts • FFEL Consolidation (CL) • Calc’d Sub Amounts
Unsubsidized Loan Aggregate Calculation Components • Unsubsidized OPB- Loan Types • (from Loan Summary- Agg. OPBs) • FFEL Unsub Supplemental Loan (SL) • Older Loans • Federally Insured (FISL) FFEL Refinanced Loan (FI) • Older Loans • Direct Stafford Unsubsidized (D2) • Recent or Older Loans • Direct Consolidation Unsubsidized (D5) • Calc’d Unsub Amounts • FFEL Consolidation (CL) • Calc’d Unsub Amounts
Adding up the Agg. OPBs • Review Student’s FAH • Exercise #6 Adding up the Agg OPBs to get your Aggregate Totals and compare them to loan limits: 1) Determine the unallocated amounts for each consolidation loan by filling in the totals in section J of the worksheet. 2) Determine Mary’s aggregate total information by filling in the totals in section K of the worksheet. Add up each section’s total amounts, by the respective loan types. 3) Compare the Subsidized and Combined totals to the loan limit chart to determine which two warning icons Mary would receive when displaying her NSLDS Financial Aid History web page.
Additional NSLDS Resources • NSLDS for Financial Aid Professionals http://nsldsfap.ed.gov • Information for Financial Aid Professionals (IFAP) • Dear Colleague Letter GEN-96-13 • Dear Partner Letter GEN-03-12 • NSLDS Newsletters
Contact Information We appreciate your feedback and comments. We can be reached at: NSLDS Customer Service • Phone: 800-999-8219 • Fax: 785-838-2154 • Web: www.nsldsfap.ed.gov • Email: nslds@ed.gov