R2T4 Extrapolation Formula Calculations

Regent Award calculates the Step 2 dates based on the individual student's rate of successful completion in the R2T4 Payment Period. The following formulas describe Regent Award's formulas for projecting the R2T4 end dates.

Successful Completion Ratio

The Successful Completion Ratio is the proportion of how quickly the student is earning units, compared to the number of units in a normal nonterm PP for that program.

Successful courses are all completed, non-transfer, progression courses with positive Quality Points. Courses must be financial aid eligible (i.e., either Program Applicable or Qualified Remedial).  Successfully completed units will have the following attributes:

• Completed= True
• Transfer = False
• Counts Toward Progression = True
• Quality Points > 0.
• Program Applicable or Qualified Remedial = True

The normal PP length is one-half the Academic Year units and weeks, defined in the Program Attributes in Program Setup.

If the student has positive Successful completed units:

• Formula:
  1. (Total successful units in PP) /  (Total units in one-half the program's AY definition)
  2. Round to four decimals using standard rounding
• Example:
  • Program AY definition is 9 units; normal PP length is 4.5 units
  • A student completes 1.5 successful units
  • Successful Completion Ratio is (1.5 successful units) / (4.5 units) = 0.3333  333  or 33.33%3% (round first to three decimal places and then convert to a percentage)

Days of Attendance

Days of Attendance include all instructional days with attendance in any courses (including withdrawn courses). The system does not include any days that are during breaks in instruction of 5 days or longer.

• Example: A school has an institutional break for 14 days in late December. A course starts December 1 and ends January 5. Regent Award will only include the non-break days when counting days of attendance.
• Example: A student has a leave of absence for 32 days, then returns and continues attending before withdrawing later in the payment period. The system would not include the 32 LOA days.
• Example: A school does not schedule any classes for Thanksgiving weekend, Thursday through Sunday. A student withdraws the following Monday. Because the gap was only 4 days long, Regent Award will still count all four days (Thurs-Sun) as days of attendance.

Calculating Projected PP Days

Projected PP Days are the estimated total days in the R2T4 payment period. The days are estimating what a student would have needed to finish all expected units in the PP, if they had kept attending and completing courses at their current successful completion rate.  

Regent Award estimates the Projected PP days using the student's successful completion ratio. The resulting Projected PP Days are rounded using standard rounding.

• Formula: (Student's days of attendance in the PP) / Successful Completion Ratio = Projected Days

• Example: A student has 100 days of attendance and a successful completion ratio of 33.33%3%. When the student withdraws, Regent Award will calculate  (100 days) / 0.3333 333 = 300 projected days in the R2T4 PP.

Projected PP Days cannot be less than the minimum payment period length for the program.

• Example: A program's AY definition is 18 units in 48 weeks, with a normal PP length of 9 units in 24 weeks. A fast-progressing student in PP1 completes 15 units in 70 days , and then withdraws. The completion ratio would have been (15 units / 9) or 1.6666. 667 which would have resulted in 42 days, which is less than the minimum payment period length.  The Projected Days will instead use the program's minimum PP length, (24 weeks x 7 days) = 168 Projected Days.

R2T4 Days Calculator

For the calculations discussed throughout this page, it may be useful to utilize the attached Days Count Calculator for R2T4 file to which provides a formula for counting the number of Instructional Days between known dates as well as a formula for counting out days from a known start date.

Breaks Between Courses

For the "R2T4 Only" extrapolation method for nonterm R2T4, any period of time > 4 days between courses, whether it is a Student Break, Institutional Break, or Gap Between Courses, will be counted as break days in the numerator and denominator.

Break Day – a day in the PP that is not counted as a day of instruction for the purposes of the R2T4 Numerator and Denominator.  These days will, however, be counted as break days when determining the Scheduled PP End Date on Step 2 of the R2T4 wizard. The total number of days considered to be “Break Days” are subtracted from the Step 2 instructional day counts for both the Numerator and Denominator.

If a gap between courses is adjacent to a student or institutional break, and the total number of days between both are > 4 days, the time period counts as a break. When gaps between courses are treated as breaks, Regent Award will skip those break days , through the end of the numerator, when counting out the required number of instructional days. For instance, after 5 instructional days, there is a 5-day break, Regent would count the first 5 days as instructional days, then "skip" or "count as break days" the next 5 days; then the 11th day would be instructional day #6.

When the denominator of the R2T4 is extrapolated for a nonterm student, these same "break" periods that are calculated for the numerator must also be "skipped over" when determining the end date of the R2T4 denominator. Breaks between courses are not considered for the denominator after the end of the numerator.

Example: Student enrolls in 3 courses, each course has a 5-day "gap" in between each course. The student withdrawals 2 weeks into the 3rd course (4/4/2019).

Image Added

The "R2T4 only" extrapolation formula resulted in a value of 168 days, PP Start Date is 1/1/2019, and the Successful Completion Ratio = 50%. The R2T4 Wizard would appear as follows:

• Completed Days (Numerator): PP Start Date of 1/1/2019 through the 4/4/2019 WDD = 84 instructional days + 10 break days = 94 calendar days. Since there are "10 break days" those are subtracted from the numerator to arrive at 84 days.
• Extrapolated Days: 84 / 50% = 168 days
• Scheduled PP Days (Denominator): PP Start Date of 1/1/2019 + 168 extrapolated days - 1 day (to avoid double-counting the start date) + 10 break days = 6/27/2019 for the Scheduled PP End Date;
  • Since there are "10 break days" those are subtracted from the denominator to arrive at 168 days.

Image Added

Counting Institutional Breaks for Projected PP Days

For the “R2T4 Only” extrapolation method for nonterm R2T4 payment period denominators, the treatment of institutional/student-level breaks must apply throughout the denominator/payment period. Rather than ending the consideration of breaks from the total days count for the denominator on the End Date of the Numerator, Regent Award will extend the consideration of institutional/student-level breaks > 4 consecutive days in length for the total days counts for the full denominator.  However, these break days will not count as instructional days throughout the denominator (through to the last extrapolated day).  When determining the end date of the denominator, if an Institutional/Student-level Break of >4 days in length falls within any of the instructional days determined by the “R2T4 Only” extrapolation formula, the break days must be considered when establishing the end date of the R2T4 Period of enrollment for the denominator.

If any institutional/student-level breaks > 4 consecutive days in length days fall within the denominator, then those "break days" must be added to the number of instructional days in the full denominator, meaning it will push out the end date of the R2T4 period by the number of days in the break.  But the break days will NOT change the instructional days count - the days of the break do not count as days of instruction.

If any institutional/student-level breaks > 4 consecutive days in length days fall ON the final instructional day in the denominator, then that break MUST be counted in the full denominator, meaning it will push out the end date of the R2T4 period by the number of days in the break.  But the break days will NOT change the instructional days count - the days of the break do not count as days of instruction.

Any institutional/student-level breaks > 4 consecutive days in length days fall AFTER the end of the denominator day are ignored.

Example 1: The Payment Period starts on 01/14/2019.  The student withdrawals on 03/29/19. 

• If the “R2T4 Only” extrapolation formula results in 140 days, and there are no institutional/student-level breaks > 4 consecutive days in length in that 140 day period, the end date of the R2T4 denominator would be June 2, 2019.  
• Image Added
• But if a 7-day institutional/student-level break occurs on March 15, 2019, and another 7-day institutional/student-level break occurs on May 18, 2019 (which is after the numerator end date), that will change the resulting number of days in the numerator, the extrapolated denominator days, and extend the end date of the R2T4 denominator period. Image Added

Projected Days when Zero Units Completed

Regent Award only calculates Projected Days if the student has positive Successful Completed Units. If the student has zero Successful completed units, Regent Award will substitute the value from the program's configuration.

• Projected Days = the configured value of "Days in R2T4 PP when 0 Units Completed" from Program Setup.

• Example:
  • Program AY definition is 9 units; normal PP length is 4.5 units; Days in R2T4 PP when 0 Units Completed = 336 days
  • A student attends and completes a course but earns zero quality points. The student attends another course and withdraws.
    • Because the student did not complete any courses with quality points, the successful completion ratio is 0 (zero).
  • The student's Projected Days will use the 336 days.

Setting the R2T4 Wizard Step 2 End Dates

If the program is configured to use the formulas, Regent Award will populate the Step 2 end dates on the R2T4 wizard.  R2T4 Wizard - R2T4 Tab. Users may edit the dates.

The system only populates the dates for the first Period of Attendance. If a user adds additional periods of attendance, the user must calculate those dates. The system will still apply the AY and LP override dates to all loans in the Payment Period.

Scheduled PP End Date

If the R2T4-only Payment Period Extrapolation Formula configuration setting is not enabled, Regent Award will initially set the Scheduled PP End Date to the default/existing value from the Academic Plan. A user may still edit the date.

If the R2T4-only Payment Period Extrapolation Formula is enabled for the program, Regent Award will set the Scheduled PP End Date by adding the Projected Days to the PP start date. The system subtracts one to avoid double-counting the first day in the PP. A user may also edit the date. 

• Formula: PP Start Date + Projected PP Days - 1
• Example: PP1 starts 1/1/2019, Projected Days 300, Scheduled PP1 End Date is 10/27/2019

AY End Date Override

If the R2T4-only Payment Period Extrapolation Formula configuration setting is not enabled, Regent Award will not calculate the AY End Date Override value. A user may still enter a date.

If the R2T4-only Payment Period Extrapolation Formula is enabled for the program, Regent Award will calculate and set the AY End Date Override. A user may also edit the date.

The formula formula varies depending on if the R2T4 is in the first payment period ( PP1 ) or second payment period (PP2)PP2, and will need to consider student level and institutional break days beyond the end of the numerator, through the last day of the denominator or calculated AY End Date Override.

PP1: Assume the student would have needed two payment periods of the same length (both PPs would be the same Projected PP Days in length). The Academic Year would end with the PP2 end date. Regent Award will add on two times the Projected Day PP lengths.

• Formula: (Scheduled PP1 Start Date) + (2 x Projected Days) + (student level and institutional break days beyond the end of the numerator, through the calculated AY End Date Override) - 1 
• Example: PP1 starts 1/1/2019, Projected Days 300, but there is a 7-day Institutional break after the end date of the numerator.  The AY End Date Override is 1/1/2019 + (2 x 300) +7 - 1 = 8/2229/2020

PP2: End with the projected PP2 Scheduled PP End Date.

• Formula: Scheduled PP2 Start Date + Projected Days + (student level and institutional break days beyond the end of the numerator, through the last day of the denominator or calculated AY End Date Override) - 1
• Example: PP1 starts 1/1/2019, PP2 starts 5/1/2019, 300 Projected Days, but there is a 7-day Institutional break after the end date of the numerator. 
  • PP2 start 5/1/2019 + 300 +7 - 1 = 3/2
  /24
  • /2020 = AY End Date Override

LP End Date Override

If the R2T4-only Payment Period Extrapolation Formula configuration setting is not enabled, Regent Award will not calculate the LP End Date Override value. A user may still enter a date.

If the Extrapolation Formula is enabled, Regent Award will calculate the value end date for the R2T4. The LP End Date calculation varies depending on if the R2T4 is in PP1 or PP2, and if the student has any loans retained after the adjustments for R2T4 calculation. The loan period dates will only include PP2 if PP2 still contains loan money after the R2T4 calculation. A user may also edit the date.  

R2T4 is in PP1: Loan Period is truncated ends with the Scheduled PP1 end date. No loans are awarded for PP2 Use calculated Scheduled PP end date (which will consider student level and institutional break days beyond the end of the numerator, through the last day of the denominator per the requirements of this ticket). 

R2T4 is in PP2: Loan Period will be either the end date of PP1 or PP2, depending on the loan dollars in PP2.Depends on loan dollars

• If R2T4 is in PP2, and student retains $0 or has a refund of all loans, then Loan Period will match Scheduled PP1 End Date.
• If R2T4 is in PP2, and student has at least $1 in loans, then Loan Period will match AY End Date Override.

Example: PP1 is 1/1/2019 - 4/30/2019, PP2 starts 5/1/2019, Projected Days 300

• If loans retained (student keeps $1 or more in PP2  loans), LP End Date Override = projected PP2 end date: 5/1/2019 + 300 - 1 1 = 2/24/2020
• If all PP2 loans refunded or $0, LP End Date Override = PP1 end date, e.g. 4/30/2019.

When reporting the AY End Date to COD, Regent Award will use the LP End Date Override value as the Financial Award End Date. Note that the LP End Date Override will be calculated for nonterm R2T4s using the Extrapolation formula even if the result of the R2T4 is "No Action Required."

Special Situations

A few special cases apply.

• If a student is progressing faster than expected, the system will use the minimum payment period length in weeks.

• If the PP had a nonterm substantially equal program change (SE PC), the successful units are totaled across all programs in the payment period. Regent Award does not count transfer units toward the formulas.

  • Regent Award applies the calculations and configuration settings using the current active program for the payment period.

• If a student is in a shortened remaining period of study, or a short program less than an AY in length, then the school may wish to manually adjust the dates. A permanent message appears on the R2T4 Wizard as a reminder.If the payment period is in a manual AY containing an Abbreviated Period, Regent Award will not calculate or auto-populate the R2T4 Wizard dates. Users may still enter the dates.