How to calculate deferred tuition:
- Go to www.climbcredit.com/school-portal and sign in.
- Click the "download" button toward the center of the page to download a CSV of the loan information displayed.
- Navigate to the downloaded excel sheet to calculate an estimate of the outstanding holdback amount owed to your school.
- In the sheet, create a new column and label it “Deferred Tuition Balance.”
- In the first cell of this column, enter the formula “=(T2-Y2).” This will display the subtraction of the “Advanced Tuition Amt” (Column Y) from “Tuition” (Column T). Note: Column numbers may differ. This calculation should always be (Tuition - Advance Tuition Amt) regardless of column numbers.
- Drag this formula down the column to view the balance for each student.
- In the column labeled “Status” (Column G), add a filter to the column and select “loan funded,” “refund in progress,” and “refunded” to view the deferred tuition amounts for those students.
- Say you want to view deferred tuition information for loans funded in March of 2017. To view data for these specific funding dates, navigate to the Column labeled “Actual Funding Date” (Column AA), add a filter, and check that month.