Federal Loan Funding Gaps Modeling Tool
NASFAA has created a tool to help institutions estimate potential future funding gaps for currently enrolled students resulting from the changes to student and parent loan limits from the One Big Beautiful Bill Act. The goal of this tool is to help members use data from their internal systems to estimate Unsubsidized and Graduate PLUS loan funding gaps for Graduate and Professional students, as well as Parent PLUS funding gaps for undergraduate students.
The tool is in Excel format and is designed to be downloaded from NASFAA’s site to ensure that your institutional data is only accessed by the individuals you permit.
All materials have been updated to reflect final rules published on May 1, 2026.
- Instructions for Using Federal Loan Funding Gaps Modeling Tool (.pdf)
- Please read the instructions carefully to understand how the tool works, assumptions used in modeling results, how to enter institutional data, and how to understand results.
- Federal Loan Funding Gaps Modeling Tool with Sample Data (.xlsx)
- Open this copy of the funding gaps modeling tool with sample data included to gain a sense of what you can learn from modeling your own students’ estimated funding gaps.
- Federal Loan Funding Gaps Modeling Tool (.xlsx)
- Download the funding gaps modeling tool and enter your own institutional data to estimate future federal loan funding gaps for your students.
Questions
Questions regarding the model may be directed to NASFAA's Policy Department at [email protected]. Please note, NASFAA is unable to assist individual institutions in obtaining data from their internal systems or in interpreting their results. Blue Icon Advisors may be of assistance to institutions in using this tool to model their loan funding gaps.
Publication Date: 5/19/2026
Related Content
Let's Talk: Direct Loan Repayments
Let's Talk: Direct Loan Repayments: Let's Talk: Direct Loan Repayments
Graduate and Professional Community Update
When Must the New Annual, Aggregate, and Lifetime Loan Limits Be Applied? (Award Year: 2026-27>)
Part 685: Federal Direct Loan Program
How Does A School Indicate A Summer Term Is Mandatory?
If a Student Withdraws, Will COD Pick This Up and End the Student's Interim Exception Eligibility?
Can a School Use Two Different Award Year SAIs When Originating a BBAY Direct Loan?
What Action Is Required For Comment Code 352?
2025-26 Top AskRegs OBBA Webinar Handout
Loan Changes from the One Big Beautiful Bill Act: Brief for Campus Leadership
Changes to Student Loans: What Health Professions Students Need to Know
Changes to Student Loans: What Professional Students Need to Know
Changes to Student Loans: What Graduate Students Need to Know
OB3 Loan Changes Planning & Implementation Checklist
2026-27 & Beyond Graduate/Professional Student Loan Borrowing Limits
Graduate & Professional Reference Sheet
Comparison of Sub and Unsub for Undergrads
How Is Expected Time to Credential Calculated For Transfer Students? (Award Year: 2026-27>)
Can a Student Cancel Or Reverse a Total and Permanent Disability Discharge?
What Are the Direct Loan Interest Rates For 2026-27? (Award Year: 2026-27)
Is Overpayment Resolution Required When the Student Exceeds the Aggregate Loan Limit By Cents?
Private Education Loans Administrator Reference & Best Practices
Health Professions Loans & Scholarships Reference Sheet
When Is the Earliest We Can Originate and Disburse Title IV Funds For 2026-27? (Award Year: 2026-27)
Off the Cuff - Episode 360 Transcript
Graduate and Professional Community Update
Private Loan Request for Information Template
Graduate and Professional Community Update Webinar
Statement on Department of Education’s Reversal on Grad PLUS Guidance
Changes to Student Loans: What Health Professions Students Need to Know
House Bill Would Restore Graduate Student Eligibility for Direct Subsidized Loans
Advertisement