• Tools and Solutions

What’s Trending With Your Borrowers? Getting the Most out of Borrower Connect’s Trending Report

Kim Fish

The Borrower Connect cohort management system is well recognized for its sophisticated reporting features. After all, it is a patented method. But with so many features and customization options available, it’s a good idea for users to be sure they’re familiar with its core reporting features. Today, we’ll review the Trending Report, which identifies shifts in delinquency and default rates in real time.

The Trending Report is one of the many ways you can use Borrower Connect to help monitor your cohorts’ repayment trends. It is part of the Borrower Connect dashboard, providing visibility about how each cohort is performing relative to other cohort years for the entire 36-month cohort period. This paints the “big picture” while providing context through historical and predicted performance for each active cohort.

The report does this by graphically displaying data from NSLDS and servicers to track a 36-month trend that includes best- and worst-case default rates by each cohort year. This allows users to quickly compare cohorts in terms of how each performed at any individual point in time. It also highlights differences in how each cohort is forecasting, which makes it simple to measure progress and identify potential risks.

To translate so much raw data into an intelligible display, the Trending Report depicts cohort years in different colors on the line graph. By rolling over any month in the three-year timeline, users can view the exact rate for that point in time. The Cohort Trend Analysis dashboard allows users to select a best-case view – defaults as reported by NSLDS, or worst-case view – defaults and delinquencies as reported by NSLDS and the servicers. Borrower Connect refreshes servicer data when weekly servicer files are imported.

The graphic below depicts the best-case default rates for 2013, 2014, 2015, 2016, and 2017 cohort years for sample data. The cursor has been placed over the 21st month of the 2016 cohort year, to display the current rate of 4.88 percent. 

Best Case

Additionally, the Trending dashboard gives users the flexibility of using filters to focus on certain cohort period months. This can be helpful when wanting to just show a segment of CDR performance data. 

The graphic below shows the user could choose to only view the 13th through 36th month of the worst-case cohort for 2013-2015 cohort years. The cursor has been placed over the 21st month of the 2016 cohort year, to display the current worst case rate of 40 percent.

Worst Case Subset

Pete McEwen, our director of customer strategy and data management, is a frequent user of the report, along with the Borrower Connect customers he works with. He tells me his favorite part of the Cohort Default Rate Trend charts is the Worst-Case filter. As Pete explains, “This is where the efforts being made with reducing delinquency, which lead to preventing defaults, meets the pavement! Worst-case trends provide a holistic view of year-over-year performance by adding the percentage of borrowers who can affect the default rate and those that have already defaulted. When you see improvements from the prior year, you can expect to see improvement in your default rates!”

Users can generate on-demand reports that they can share with their management and other colleagues for analysis. Such information provides a concrete way of determining if current default prevention efforts are working or if additional steps are required to address projected rates. Reports can be viewed online or exported to Microsoft Excel or CSV files for additional filtering or sorting.

If you have any questions about using the report – or any aspect of Borrower Connect, contact Customer Support or your account representative. If you’re not a Borrower Connect customer, contact us for a demo!

Headshot-FishKim Fish is a Student Connections product manager.