Audit 6092

FY End

2023-05-31

Total Expended

$11.96M

Findings

Programs

Organization: MacAlester College (MN)

Year: 2023 Accepted: 2023-12-11

Auditor: Cliftonlarsonallen LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID	Ref	Severity	Repeat	Requirement
3862	2023-001	Significant Deficiency	-	L
3863	2023-001	Significant Deficiency	-	L
3864	2023-001	Significant Deficiency	-	L
3865	2023-001	Significant Deficiency	-	L
3866	2023-001	Significant Deficiency	-	L
3867	2023-001	Significant Deficiency	-	L
580304	2023-001	Significant Deficiency	-	L
580305	2023-001	Significant Deficiency	-	L
580306	2023-001	Significant Deficiency	-	L
580307	2023-001	Significant Deficiency	-	L
580308	2023-001	Significant Deficiency	-	L
580309	2023-001	Significant Deficiency	-	L

Programs

ALN	Program	Spent	Major	Findings
84.063	Federal Pell Grant Program	$1.95M	Yes	1
84.038	Federal Perkins Student Loans Programs	$1.54M	Yes	1
84.268	Federal Direct Student Loans	$1.38M	Yes	1
97.036	Disaster Grants - Public Assistance (presidentially Declared Disasters)	$963,385	Yes	0
84.033	Federal Work-Study Program	$375,729	Yes	1
84.007	Federal Supplemental Educational Opportunity Grants	$346,517	Yes	1
47.050	Geosciences	$206,727	-	0
47.079	Office of International Science and Engineering	$166,964	-	0
47.074	Biological Sciences	$111,321	-	0
93.859	Biomedical Research and Research Training	$80,745	-	0
47.075	Social, Behavioral, and Economic Sciences	$49,772	-	0
16.525	Grants to Reduce Domestic Violence, Dating Violence, Sexual Assault, and Stalking on Campus	$47,298	-	0
12.431	Basic Scientific Research	$41,029	-	0
10.310	Agriculture and Food Research Initiative (afri)	$25,368	-	0
43.008	Education	$7,273	-	0
93.361	Nursing Research	$7,027	-	0
15.808	U.s. Geological Survey_ Research and Data Collection	$3,742	-	0
47.049	Mathematical and Physical Sciences	$2,067	-	0

Contacts

Name	Title	Type
MNFCECSHS166	Patricia M Langer	Auditee
6516966562	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: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES 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. 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. The College has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance.

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, 2023 consists of: Federal Perkins Loan Program (84.038) - Balances outstanding to the end of the audit period were 954912.

Finding Details

Finding 2023-001

Federal Agency: Department of Education Federal Program Title: Student Financial Assistance Cluster Assistance Listing Number: 84.038, 84.268, 84.033, 84.007, 84.063 Award Period: June 1, 2022 to May 31, 2023 Type of Finding: 􀁸 Significant Deficiency in Internal Control over Compliance 􀁸 Other matter Criteria or Specific Requirement: The Department of Education requires the College to report the disbursement dates and amounts to the Common Origination and Disbursement (COD) system within 15 days of disbursing Pell (34 CFR 690.83(b)(2) and Direct Loan (34 CFR 685.309) funds to a student. Condition: During our testing, we noted 10 of the 40 students tested had an applied date outside of the 15 day requirement to be applied to the student account. Questioned Costs: None reported Context: During our testing, it was noted the College had a password issue that resulted in delayed reporting. Cause: The College was unable to meet the requirement that disbursements made to students must be reported to COD within 15 days of the disbursement date due to a password issue. Effect: Students interest accrues based on disbursement date reported to COD for Direct Loan disbursements, thus interest calculation could be skewed due to the discrepancy in disbursement dates reported. Repeat Finding: No Recommendation: We recommend the College evaluate the circumstances that delayed reporting disbursements to COD to ensure that it will not happen again. Views of Responsible Officials: There is no disagreement with the audit finding.

Finding 2023-001