Finding 619695 (2022-001)

Material Weakness
Requirement
N
Questioned Costs
$1
Year
2022
Accepted
2023-03-29
Audit: 49806
Organization: Concordia University, St. Paul (MN)

AI Summary

  • Core Issue: The University failed to perform required R2T4 calculations for students who withdrew, leading to questioned costs of $3,437.
  • Impacted Requirements: Compliance with 34 CFR 668.22, which mandates accurate determination of earned and unearned Title IV aid upon student withdrawal.
  • Recommended Follow-Up: Establish a review process for R2T4 calculations to ensure compliance and prevent future errors.

Finding Text

Federal Agency: U.S. Department of Education Federal Program Name: Student Financial Assistance Cluster Assistance Listing Number: 84.007 ? Federal Supplemental Education Opportunity Grants 84.033 ? Federal Work Study Program 84.038 ? Federal Perkins Loans 84.063 ? Federal Pell Grant Program 84.268 ? Federal Direct Student Loans 84.379 ? Teacher Education Assistance for College and Higher Education Grants Award Period: July 1, 2021 to June 30, 2022 Type of Finding: ? Material Weakness in Internal Control over Compliance ? Other Matters Criteria or specific requirement: The Code of Federal Regulations 34 CFR 668.22, states that when students withdraw from a school, institutions is required to determine earned and unearned portions of Title IV aid as of the date the student ceased attendance based on the amount of time the student spent in attendance. Up through the 60% point in each payment period or period of enrollment, a pro rate schedule is used to determine the amount of Title IV funds the students earned at the time of withdrawal. After the 60% point in the payment period or period of enrollment, a student has earned 100% of the Title IV funds the student was scheduled to receive during the period. Condition: During our testing it was noted that: 1) There was no review process in place for R2T4 calculations. 2) 9 of 40 students tested did not have an R2T4 calculation performed when necessary. 3) A net of $3,437 should have been returned to U.S. Department of Education based on individual students? R2T4 calculation but was not. This includes $10,060 of funds that were under returned offset by $6,624 in funds that were overall returned for respective students tested. Questioned costs: $3,437 Context: The University had instances where students left the school but the University did not perform a R2T4 calculation, calculated the R2T4 incorrectly or under/over return federal funds. Cause: The University has had significant turnover and there were no oversight over the withdrawal process and calculation of R2T4 which includes review of the R2T4 calculations. Effect: There are questioned costs of $3,437. Additionally, with no review in place, there could be potential for additional R2T4 amounts not being calculated appropriately. Repeat Finding: No. Auditors? Recommendation We recommend that the University implement a review process as it relates to R2T4 calculations. Views of responsible officials and planned corrective actions: There is no disagreement with the audit finding.

Categories

Questioned Costs Student Financial Aid Material Weakness Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 43249 2022-001
    Material Weakness
  • 43250 2022-002
    Significant Deficiency Repeat
  • 43251 2022-003
    Significant Deficiency Repeat
  • 43252 2022-005
    Significant Deficiency
  • 43253 2022-001
    Material Weakness
  • 43254 2022-002
    Significant Deficiency Repeat
  • 43255 2022-003
    Significant Deficiency Repeat
  • 43256 2022-005
    Significant Deficiency
  • 43257 2022-001
    Material Weakness
  • 43258 2022-002
    Significant Deficiency Repeat
  • 43259 2022-003
    Significant Deficiency Repeat
  • 43260 2022-005
    Significant Deficiency
  • 43261 2022-001
    Material Weakness
  • 43262 2022-002
    Significant Deficiency Repeat
  • 43263 2022-003
    Significant Deficiency Repeat
  • 43264 2022-005
    Significant Deficiency
  • 43265 2022-001
    Material Weakness
  • 43266 2022-002
    Significant Deficiency Repeat
  • 43267 2022-003
    Significant Deficiency Repeat
  • 43268 2022-005
    Significant Deficiency
  • 43269 2022-001
    Material Weakness
  • 43270 2022-002
    Significant Deficiency Repeat
  • 43271 2022-003
    Significant Deficiency Repeat
  • 43272 2022-005
    Significant Deficiency
  • 43273 2022-004
    Significant Deficiency Repeat
  • 43274 2022-004
    Significant Deficiency Repeat
  • 619691 2022-001
    Material Weakness
  • 619692 2022-002
    Significant Deficiency Repeat
  • 619693 2022-003
    Significant Deficiency Repeat
  • 619694 2022-005
    Significant Deficiency
  • 619696 2022-002
    Significant Deficiency Repeat
  • 619697 2022-003
    Significant Deficiency Repeat
  • 619698 2022-005
    Significant Deficiency
  • 619699 2022-001
    Material Weakness
  • 619700 2022-002
    Significant Deficiency Repeat
  • 619701 2022-003
    Significant Deficiency Repeat
  • 619702 2022-005
    Significant Deficiency
  • 619703 2022-001
    Material Weakness
  • 619704 2022-002
    Significant Deficiency Repeat
  • 619705 2022-003
    Significant Deficiency Repeat
  • 619706 2022-005
    Significant Deficiency
  • 619707 2022-001
    Material Weakness
  • 619708 2022-002
    Significant Deficiency Repeat
  • 619709 2022-003
    Significant Deficiency Repeat
  • 619710 2022-005
    Significant Deficiency
  • 619711 2022-001
    Material Weakness
  • 619712 2022-002
    Significant Deficiency Repeat
  • 619713 2022-003
    Significant Deficiency Repeat
  • 619714 2022-005
    Significant Deficiency
  • 619715 2022-004
    Significant Deficiency Repeat
  • 619716 2022-004
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $33.05M
84.063 Federal Pell Grant Program $5.54M
84.038 Federal Perkins Loan Program $1.24M
84.007 Federal Supplemental Educational Opportunity Grants $278,339
84.033 Federal Work-Study Program $133,000
84.425 Education Stabilization Fund $103,990
84.379 Teacher Education Assistance for College and Higher Education Grants (teach Grants) $60,966