national student loan data system at aggregate calculation16 part 3 - you make the call this loan is...

7/30/2009

1

A t

National Student Loan Data System

AggregateCalculation

1

Objectives

• Understand aggregate loan terms

• Identify loan types that impact aggregate limit calculations

• Calculate aggregate limits using NSLDS methodology

• Apply aggregate information to eligibility decisions

2

Defining and Using Aggregates

• NSLDS Terms– Outstanding Principal Balance (OPB)– Aggregate Amounts

• Aggregate Loan Information• Loan Level Aggregate OPB

• Why are NSLDS aggregate amounts used?

3

NSLDS Aggregate Calculation

7/30/2009

2

NSLDS Aggregate Totals Calculation Process

4

Aggregate OPB

5

2. Calculate Each Loan Type’s Loan Level Aggregate OPB

• NSLDS reviews loans in student’s financial aid history

• Categorizes each loan into respective

6

g ploan type (e.g., bucket)

• Three main loan groupings:– Recent loans– Older loans– Consolidation Loans


7/30/2009

3

Recent Loans

• May have adjustments not yet posted

• May have additional disbursements or adjustments not yet reported to

7

adjustments not yet reported to NSLDS

• Included at end of calculation as Pending Disbursements

Recent Loans, continued

Recent loansPeriod End Date Loan Period End Date plus 90 days

has not yet passedLoan Status IA, ID, IG, IMAggregate Greater of

8

Aggregate Outstanding Principal Balance (Agg. OPB)

Greater of –OPB, or–Disbursed Amount

Not to exceed Net Loan Amount

Older Loans

Older loansPeriod End Date 90 days or older

Loan Status

Included in Aggregate OPB calculations

9

Aggregate Outstanding Principal Balance (Agg. OPB)

Lesser of –Net Loan Amount, or–Disbursed Amount, or –OPB

If all are greater than zero


7/30/2009

4

Subsidized Loan Aggregate Calculation Components

Loan Types / Bucket:

Subsidized(from Loan Summary)

SF – FFEL Sub• Loan Category:

Recent or Old LOlder Loans

D1 – Direct Stafford Subsidized• Recent or Older Loans

D6 – Direct Consolidation Subsidized• Calc’d Sub

CL – FFEL Consol. Calc’dSub Aggr. OPB amount(s)

You Make the Call - Part 1

This loan is a(n) ________ loan with a loan level Aggregate OPB of _______.

11

Part 1 - You make the call

Fill in the blanks for the following statement: This loan is a(an) ________loan with a loan level Agg. OPB of _________.

Live Meeting Poll

• Recent, $4,500• Older, $1,500• Recent, $1,500• Older, $4,500

Changes directly made to this slide will not be displayed in Live Meeting. Edit this slide by selecting Properties in the Live Meeting Presentation menu.


7/30/2009

5

You Make the Call - Part 2

What is the loan level Pending Disbursement?

13


What is the loan level Pending Disbursement?

• $0• $3,000

Live Meeting Poll

• $4,500• $6,000


Unsubsidized Loan Aggregate Calculation Components

Loan Types/ Bucket:Unsubsidized(from Loan Summary)SU – FFEL Unsub.• Loan Category:

Recent or Older LoansSL – Supplemental Loan (SLS)• Loan Category:

Recent or Older LoansFI F d ll I d (FISL)

15

FI – Federally Insured (FISL)• Loan Category:

Recent or Older LoansRF – FFEL Refinanced Loan• Loan Category:

Recent or Older LoansD2 – Direct Stafford Unsubsidized• Loan Category:

Recent or Older LoansD5 – Direct Consolidation Unsub• Calc’d UnsubCL – FFEL Consol. Calc’dUnsub Aggr. OPB amount(s)

Qu c e a d aTIFF (LZW) decompressor

are needed to see this picture.


7/30/2009

6

You Make the Call - Part 3True or False:

This loan is an older loan with a loan level Agg. OPB of $1,333 and a loan level Pending Disbursement of $4,000.

16


This loan is an older loan with a loan level Agg. OPB of $1,333 and a loan level Pending Disbursement of $4,000.

Live Meeting Poll

• True• False


Consolidation Loan Components

• When no underlying loans reported within 60 days of FAH review, loan level Agg. OPB is zero

• If CL over 60 days old and has no underlying loans then whole CL treated as

18

underlying loans, then whole CL treated as Subsidized

• CL falls under older loan category


7/30/2009

7

Consolidation Loans & Aggregate OPB

Process to determine impact of Consolidation Loans (CL) on Aggregate OPB:

2A. Identify underlying loans

19

2B. Determine number of CLs & Totals2C. Determine Calculated Agg. OPBs2D. Determine CL;s Unallocated Agg. OPB2E. Calculate CL’s Combined Loans Agg.

OPB

2A. Identify CL’s Underlying Loans

Step 1: Determine Loan Status

Loan Status is one of these: PC PN DNDP PF

Step 2: Determine Loan Status

Loan Status Date: ________

I L St t D t ithi 210 d

20

Loan Status Date Is Loan Status Date within 210 days

(before or after) Consolidation Loan Date? Yes No

Step 3: Underlying Loan?

If Loan Status is one listed in Step 1 and the answer to Step 2 is Yes, then loan is underlying loan.

You Make the Call - Part 4Which are Underlying Loans? Included in Agg OPB totals for loan limit comparison?

21


7/30/2009

8


Which loans are included in the Subsidized Aggregate OPB?

Live Meeting Poll

• 6, 9, 11, 12• 7• 8, 10, 13• 11


2B. Determine Number of CLs and Totals

Perkins Loan Types

FFEL Consolidation Loan Types

23

Subsidized Loan Types Unsubsidized Loan Types

Consolidation Loans & Totals• Determine number of CLs = 2

• Sum Disbursed Amt of Loan Types– Total CL Disbursed Amt: $38,700– Total Subsidized Disbursed Amt: $18,725– Total Unsub Disbursed Amt: $11,700

24

Total Unsub Disbursed Amt: $11,700

• Loans Not Factored into Aggregate OPB Loan Limits– Total Perkins Disbursed Amt: $ 4,000– Total PLUS Disbursed Amt: $ 0– Total D8 Unsub Disbursed Amt: $ 0


7/30/2009

9

Direct Unsubsidized Loans (TEACH)

2C: Determine Calculated Agg. OPBs• Calculate ratio for each Loan

Type - percentage of CL attributable to Loan Type

Sum of CL Disb AmtsSum of Underlying Loans’ Disb AmtsRatio =

27

Sum of CL Disb Amts

• Determine Calculated Agg. OPB amount for each CL

Aggregate = Ratio CL Guaranteed Amt


7/30/2009

10

Calculate CL Subsidized Agg. OPB• Determine ratio for subsidized loans

– Total of underlying Sub Disbursement Amounts = $18,725– Total of CL Disbursement Amounts = $38,700– Ratio = $18725/$38,700 = 0.48385

• Determine Calculated Subsidized Aggregates(Ratio Guaranteed Amount)– Calculated Subsidized Aggregate for CL #4= $8,322

(0.48385 $17,200)

28

( )

– Calculated Subsidized Aggregate for CL #5= $10,403(0.48385 $21,500)

Activity

Individual ActivityP ti i t W kb k 16

29

Participant Workbook page 16

Debrief: Calculate CL Unsubsidized Agg. OPB

• Determine ratio for Unsubsidized loans– Total of underlying Unsub Disbursement Amounts = $11,700– Total of CL Disbursement Amounts = $38,700– Ratio = $11,700/$38,700 = 0.30233

• Determine Calculated Unsub Aggregates(Ratio Guaranteed Amount)

– Calculated Unsubsidized Aggregate for CL #4= $5,200

30

gg g $ ,(0.30233 $17,200)

– Calculated Unsubsidized Aggregate for CL #5= $6,500(0.30233 $21,500)


7/30/2009

11

Calculate Perkins Share of CL’s Agg. OPB

• Determine ratio for Perkins loans– Total of underlying Perkins Disbursement Amounts = $4,000– Total of CL Disbursement Amounts = $38,700– Ratio = $4,000/$38,700 = 0.10336

• Determine Perkins Share of CL’s Aggregate OPB(Ratio Guaranteed Amount)

Perkins Share of CL #4 Aggregate OPB = $1 778

31

– Perkins Share of CL #4 Aggregate OPB = $1,778(0.10336 $17,200)

– Perkins Share of CL #5 Aggregate OPB = $2,222(0.10336 $21,500)

2D: Calculate CL Unallocated Amounts

Guaranteed Amount $17,200- Total Perkins Share $1,778- Total PLUS Share $0- Calculated Sub Aggregate OPB $8,322- Calculated Unsub Aggregate OPB $5,200= Calculated Consolidation, Unallocated Aggregate $1,900

32

, gg gOPB for CL #4

$ ,

$17,200

11/2/2008

11/2/2008

$21,000

1/15/2003

$8,322

$5,200

$13,522

$1,900

CL Unallocated Amounts, cont.

Guaranteed Amount $21,500- Total Perkins Share $2,222- Total PLUS Share $0- Calculated Sub Aggregate OPB $10,403- Calculated Unsub Aggregate OPB $6,500= Calculated Consolidation, Unallocated

A t OPB f CL #5$2,375

33

Aggregate OPB for CL #5

11/02/2008

11/02/2008

$10,403

$6,500

$16,903

$2,375

$21,500

$25,000


7/30/2009

12

$21,500

$25,00011/02/2008

11/02/2008

$10,403

$6,500

$16,903

2E. Calculate CL Combined Agg. OPB• Combined Agg. OPB = Calculated Sub Agg. OPB + Calculated

Unsub Agg. OPB

$2,375

34

• Combined Agg. OPB (older loans) ‘adjusted’ when:– Underlying Perkins loans are factored out of Unallocated

Amount– Underlying PLUS loans are factored out of Unallocated

Amount (for PLUS Borrower)

3. Sum Loan Level Agg OPBs by Loan Type

• Collect all loan level Agg. OPB numbers

• Roll individual calculated numbers into respective loan types

35

p yp

• Add in respective loan type’s pending disbursements

• Display each loan type’s Aggregate OPB Totals in Aggregate Loan Information section

+ =

Subsidized Roll-Up• Roll up Loan

Level Summary amounts to Aggregate: Subsidized Loan Type

• Roll up Loan Level Summary amounts to Aggregate: Subsidized Loan Type

$8,322

$10,403


7/30/2009

13

+ =

Unsubsidized Roll-Up

• Roll up Loan Level Summary amounts to Aggregate: Unsubsidized

• Roll up Loan Level Summary amounts to Aggregate: Unsubsidized Loan TypeLoan Type

$5,200

$6,500

Unallocated Amount Roll-Up

• Roll up Loan Level Summary amounts to Aggregate: Unallocated

• Roll up Loan Level Summary amounts to Aggregate: UnallocatedUnallocated AmountUnallocated Amount

$1,900

$2,375

Combined Loan Amounts Roll-Up


7/30/2009

14

4. Evaluate Totals for Eligibility

Reduce pending disbursement on the recent subsidized loan from $3,000 to $2,775

Increase the recent unsubsidized loans from

Resolving NSLDS Warning on Page 20

Increase the recent unsubsidized loans from $6,000 to $6,225


Wrap Up

42


7/30/2009

15

Contact Information

Margaret Day, Training OfficerU.S. Department of Education

[email protected] (303) 844-3677

B H T i i Offi

43

Bruce Honer, Training OfficerU.S. Department of Education

[email protected] (415)486-5521


national student loan data system at aggregate calculation16 part 3 - you make the call this loan is...

Documents