Audit 323740

FY End
2024-05-31
Total Expended
$10.80M
Findings
6
Programs
18
Organization: MacAlester College (MN)
Year: 2024 Accepted: 2024-10-03

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
501689 2024-001 Significant Deficiency - N
501690 2024-001 Significant Deficiency - N
501691 2024-001 Significant Deficiency - N
1078131 2024-001 Significant Deficiency - N
1078132 2024-001 Significant Deficiency - N
1078133 2024-001 Significant Deficiency - N

Programs

Contacts

Name Title Type
MNFCECSHS166 Matthew Walters Auditee
6516966538 Deirdre Hodgson Auditor
No contacts on file

Notes to SEFA

Title: BASIS OF PRESENTATION Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement De Minimis Rate Used: N Rate Explanation: The College has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The purpose of the schedule of expenditures of federal awards (the Schedule) is to present a summary of those activities of Macalester College (the College) that have been financed by the U.S. government (federal awards). Federal awards received directly from federal agencies are included in the Schedule, as are federal guaranteed loans disbursed by other sources. Additionally, all federal awards passed through from other entities have been included in the Schedule. The College is required to match certain grant agreements, as defined in the grants, and these matching amounts are not included in the Schedule. The information in the Schedule is presented in accordance with requirements of 2 CFR Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the College, it is not intended to and does not present the financial position, changes in net assets, or cash flows of Macalester College.
Title: FEDERAL STUDENT LOAN PROGRAMS Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement De Minimis Rate Used: N Rate Explanation: The College has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The federal student loan programs listed subsequently are administered directly by the College, and balances and transactions relating to these programs are included in the College’s basic financial statements. Loans outstanding at the beginning of the year and loans made during the year are included in the federal expenditures presented in the Schedule. The balance of loans outstanding at May 31, 2024 consists of: Grant Description / Assistance Listing Number / Amount Outstanding: Federal Perkins Loan Program / 84.038 / $703,891
Title: STUDENT FINANCIAL AID INSTITUTIONAL AND PROGRAM ELIGIBILITY METRICS Accounting Policies: Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement De Minimis Rate Used: N Rate Explanation: The College has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The College is in compliance with the following institutional and program eligibility requirements under the Higher Education Act of 1965 and Federal regulations under 34 CFR 668.23: • Correspondence courses the institution offers under 34 CFR 600.7(b) and (g) • Regular students that enroll in correspondence courses under 34 CFR 600.7(b) and (g) • Institution’s regular students that are incarcerated under 34 CFR 600.7(c) and (g) • Completion rates for confined or incarcerated individuals enrolled in non-degree programs at nonprofit institutions under 34 CFR 600.7(c)(3)(ii) and (g) • Institution’s regular students that lack a high school diploma or its equivalent under 34 CFR 600.7(d) and (g) • Completion rates for short-term programs under 34 CFR 668.8(f) and (g) • Placement rates for short-term programs under https://www.ecfr.gov/current/title-34/subtitle-B/chapter-VI/part-668/subpart-A/section-668.8 34 CFR 668.8(e)(2)

Finding Details

Federal Agency: Department of Education Federal Program Title: Student Financial Assistance Cluster Assistance Listing Number: 84.063, 84.268 Award Period: June 1, 2023 to May 31, 2024 Type of Finding: • Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: The Code of Federal Regulations, 34 CFR 668.22(f)(2)(i), states that scheduled breaks of at least five consecutive days are excluded from the total number of calendar days in a payment period or period of enrollment and the number of calendar days completed in that period. Condition: During our testing, we noted 3 of the 8 students tested did not have the break of 5 days for Thanksgiving included in their calculation and funds returned to ED that should not have been. Questioned Costs: $152.06 Context: During our testing, it was noted the College calculated the refund calculation without factoring in breaks of 5 or more days. Cause: There was a change in the calendar from historical trends Effect: More aid funds were returned to Department of Education that were supposed to go to the students. It was noted that $124.84 in Pell, $27.22 subsidized loans, and $54.64 in unsubsidized loans were returned when they should not have been. Repeat Finding: No Recommendation: We recommend the College update its procedures to identify changes in breaks for purposes of refund calculations. Views of Responsible Officials: There is no disagreement with the audit finding.
Federal Agency: Department of Education Federal Program Title: Student Financial Assistance Cluster Assistance Listing Number: 84.063, 84.268 Award Period: June 1, 2023 to May 31, 2024 Type of Finding: • Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: The Code of Federal Regulations, 34 CFR 668.22(f)(2)(i), states that scheduled breaks of at least five consecutive days are excluded from the total number of calendar days in a payment period or period of enrollment and the number of calendar days completed in that period. Condition: During our testing, we noted 3 of the 8 students tested did not have the break of 5 days for Thanksgiving included in their calculation and funds returned to ED that should not have been. Questioned Costs: $152.06 Context: During our testing, it was noted the College calculated the refund calculation without factoring in breaks of 5 or more days. Cause: There was a change in the calendar from historical trends Effect: More aid funds were returned to Department of Education that were supposed to go to the students. It was noted that $124.84 in Pell, $27.22 subsidized loans, and $54.64 in unsubsidized loans were returned when they should not have been. Repeat Finding: No Recommendation: We recommend the College update its procedures to identify changes in breaks for purposes of refund calculations. Views of Responsible Officials: There is no disagreement with the audit finding.
Federal Agency: Department of Education Federal Program Title: Student Financial Assistance Cluster Assistance Listing Number: 84.063, 84.268 Award Period: June 1, 2023 to May 31, 2024 Type of Finding: • Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: The Code of Federal Regulations, 34 CFR 668.22(f)(2)(i), states that scheduled breaks of at least five consecutive days are excluded from the total number of calendar days in a payment period or period of enrollment and the number of calendar days completed in that period. Condition: During our testing, we noted 3 of the 8 students tested did not have the break of 5 days for Thanksgiving included in their calculation and funds returned to ED that should not have been. Questioned Costs: $152.06 Context: During our testing, it was noted the College calculated the refund calculation without factoring in breaks of 5 or more days. Cause: There was a change in the calendar from historical trends Effect: More aid funds were returned to Department of Education that were supposed to go to the students. It was noted that $124.84 in Pell, $27.22 subsidized loans, and $54.64 in unsubsidized loans were returned when they should not have been. Repeat Finding: No Recommendation: We recommend the College update its procedures to identify changes in breaks for purposes of refund calculations. Views of Responsible Officials: There is no disagreement with the audit finding.
Federal Agency: Department of Education Federal Program Title: Student Financial Assistance Cluster Assistance Listing Number: 84.063, 84.268 Award Period: June 1, 2023 to May 31, 2024 Type of Finding: • Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: The Code of Federal Regulations, 34 CFR 668.22(f)(2)(i), states that scheduled breaks of at least five consecutive days are excluded from the total number of calendar days in a payment period or period of enrollment and the number of calendar days completed in that period. Condition: During our testing, we noted 3 of the 8 students tested did not have the break of 5 days for Thanksgiving included in their calculation and funds returned to ED that should not have been. Questioned Costs: $152.06 Context: During our testing, it was noted the College calculated the refund calculation without factoring in breaks of 5 or more days. Cause: There was a change in the calendar from historical trends Effect: More aid funds were returned to Department of Education that were supposed to go to the students. It was noted that $124.84 in Pell, $27.22 subsidized loans, and $54.64 in unsubsidized loans were returned when they should not have been. Repeat Finding: No Recommendation: We recommend the College update its procedures to identify changes in breaks for purposes of refund calculations. Views of Responsible Officials: There is no disagreement with the audit finding.
Federal Agency: Department of Education Federal Program Title: Student Financial Assistance Cluster Assistance Listing Number: 84.063, 84.268 Award Period: June 1, 2023 to May 31, 2024 Type of Finding: • Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: The Code of Federal Regulations, 34 CFR 668.22(f)(2)(i), states that scheduled breaks of at least five consecutive days are excluded from the total number of calendar days in a payment period or period of enrollment and the number of calendar days completed in that period. Condition: During our testing, we noted 3 of the 8 students tested did not have the break of 5 days for Thanksgiving included in their calculation and funds returned to ED that should not have been. Questioned Costs: $152.06 Context: During our testing, it was noted the College calculated the refund calculation without factoring in breaks of 5 or more days. Cause: There was a change in the calendar from historical trends Effect: More aid funds were returned to Department of Education that were supposed to go to the students. It was noted that $124.84 in Pell, $27.22 subsidized loans, and $54.64 in unsubsidized loans were returned when they should not have been. Repeat Finding: No Recommendation: We recommend the College update its procedures to identify changes in breaks for purposes of refund calculations. Views of Responsible Officials: There is no disagreement with the audit finding.
Federal Agency: Department of Education Federal Program Title: Student Financial Assistance Cluster Assistance Listing Number: 84.063, 84.268 Award Period: June 1, 2023 to May 31, 2024 Type of Finding: • Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: The Code of Federal Regulations, 34 CFR 668.22(f)(2)(i), states that scheduled breaks of at least five consecutive days are excluded from the total number of calendar days in a payment period or period of enrollment and the number of calendar days completed in that period. Condition: During our testing, we noted 3 of the 8 students tested did not have the break of 5 days for Thanksgiving included in their calculation and funds returned to ED that should not have been. Questioned Costs: $152.06 Context: During our testing, it was noted the College calculated the refund calculation without factoring in breaks of 5 or more days. Cause: There was a change in the calendar from historical trends Effect: More aid funds were returned to Department of Education that were supposed to go to the students. It was noted that $124.84 in Pell, $27.22 subsidized loans, and $54.64 in unsubsidized loans were returned when they should not have been. Repeat Finding: No Recommendation: We recommend the College update its procedures to identify changes in breaks for purposes of refund calculations. Views of Responsible Officials: There is no disagreement with the audit finding.