Audit 349151

FY End
2024-06-30
Total Expended
$14.45M
Findings
2
Programs
10
Organization: Coe College (IA)
Year: 2024 Accepted: 2025-03-27

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
538145 2024-002 Significant Deficiency Yes L
1114587 2024-002 Significant Deficiency Yes L

Contacts

Name Title Type
MYBRQL7HA4T1 Mary K. Conrad Auditee
3193998699 Nicki Donlon Auditor
No contacts on file

Notes to SEFA

Title: 1. 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% de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal awards activity of Coe College (the College) under programs of the federal government for the year ended June 30, 2024. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations 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 position or cash flows of the College.
Title: 2. 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% 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.
Title: 3. Indirect Cost Rate 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% de minimis indirect cost rate allowed under the Uniform Guidance. The College has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance.
Title: 4. Loan and Loan Guarantee 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% de minimis indirect cost rate allowed under the Uniform Guidance. The Federal Perkins Loan Program is administered directly by the College, and balances and transactions relating to this program 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. Federal Perkins loans outstanding at June 30, 2024 totaled $1,228,690.

Finding Details

Significant Deficiency - Enrollment Reporting Program: Student Financial Assistance Cluster Assistance Listing Number: 84.268 Federal Agency: U.S. Department of Education Federal Award Identification Number: P268K230130 Federal Award Year: June 30, 2024 Repeat of prior year finding 2023-002 Criteria: Title IV regulations (34 CFR 685.309(b)) require that upon receipt of an enrollment report from the Secretary, institutions must update all information included in the report and return the report to the Secretary: (i) in the manner and format prescribed by the Secretary; and (ii) within the timeframe prescribed by the Secretary. Unless it expects to submit its next updated enrollment report to the Secretary within the next 60 days, an institution must notify the Secretary within 30 days after the date the institution discovers that: (i) a loan under Title IV of the Act was made to or on behalf of a student who was enrolled or accepted for enrollment at the institution and the student has ceased to be enrolled on at least a half-time basis or failed to enroll on at least a half-time basis for the period for which the loan was intended; or (ii) a student who is enrolled at the institution and who received a loan under Title IV of the Act has changed his or her permanent address. Condition/Context: The change in student status for 1 of 25 students tested was not reported to the National Student Loan Data System (NSLDS) timely when the student withdrew at the end of the spring term. The sample was not a statistically valid sample. Questioned Costs: Not applicable. Cause: The Registrar's data collection was not reviewed after submission to National Student Clearinghouse (NSC) by another responsible individual to ascertain the accuracy of withdrawn students being reported. The College received a response from NSC of no errors, therefore the withdrawn student in question was not reported in a timely manner. Effect: The accuracy of Title IV student loan records depends heavily on the accuracy of the enrollment information reported by schools. If an Institution does not review, update and verify student enrollment statuses, effective dates of the enrollment status and the anticipated completion dates, then the Title IV student loan records will be inaccurate. Recommendation: It is recommended that the College review policies and procedures in place to resolve reporting issues with the third-party servicer in a timely manner or implement an alternative reporting method to facilitate compliance with Title IV regulations. Management’s Response: The Registrar will run a report on the 15th of the month to verify any students that have exited the institution from the prior two submission periods (last two months) have valid exit dates in the National Student Loan Clearinghouse. The Assistant Registrar will review the work of the Registrar and verify any discrepancies between Coe's records and those stored in the National Student Clearinghouse for correction. The Registrar will then ensure timely and accurate submission of student records from the Clearinghouse to NSLDS after all the data has been reviewed. This error occurred during a turnover of staff in the Office of the Registrar. When there are staffing changes in the future, existing staff in the Office of the Registrar will execute the written policy for verification and reporting this data.
Significant Deficiency - Enrollment Reporting Program: Student Financial Assistance Cluster Assistance Listing Number: 84.268 Federal Agency: U.S. Department of Education Federal Award Identification Number: P268K230130 Federal Award Year: June 30, 2024 Repeat of prior year finding 2023-002 Criteria: Title IV regulations (34 CFR 685.309(b)) require that upon receipt of an enrollment report from the Secretary, institutions must update all information included in the report and return the report to the Secretary: (i) in the manner and format prescribed by the Secretary; and (ii) within the timeframe prescribed by the Secretary. Unless it expects to submit its next updated enrollment report to the Secretary within the next 60 days, an institution must notify the Secretary within 30 days after the date the institution discovers that: (i) a loan under Title IV of the Act was made to or on behalf of a student who was enrolled or accepted for enrollment at the institution and the student has ceased to be enrolled on at least a half-time basis or failed to enroll on at least a half-time basis for the period for which the loan was intended; or (ii) a student who is enrolled at the institution and who received a loan under Title IV of the Act has changed his or her permanent address. Condition/Context: The change in student status for 1 of 25 students tested was not reported to the National Student Loan Data System (NSLDS) timely when the student withdrew at the end of the spring term. The sample was not a statistically valid sample. Questioned Costs: Not applicable. Cause: The Registrar's data collection was not reviewed after submission to National Student Clearinghouse (NSC) by another responsible individual to ascertain the accuracy of withdrawn students being reported. The College received a response from NSC of no errors, therefore the withdrawn student in question was not reported in a timely manner. Effect: The accuracy of Title IV student loan records depends heavily on the accuracy of the enrollment information reported by schools. If an Institution does not review, update and verify student enrollment statuses, effective dates of the enrollment status and the anticipated completion dates, then the Title IV student loan records will be inaccurate. Recommendation: It is recommended that the College review policies and procedures in place to resolve reporting issues with the third-party servicer in a timely manner or implement an alternative reporting method to facilitate compliance with Title IV regulations. Management’s Response: The Registrar will run a report on the 15th of the month to verify any students that have exited the institution from the prior two submission periods (last two months) have valid exit dates in the National Student Loan Clearinghouse. The Assistant Registrar will review the work of the Registrar and verify any discrepancies between Coe's records and those stored in the National Student Clearinghouse for correction. The Registrar will then ensure timely and accurate submission of student records from the Clearinghouse to NSLDS after all the data has been reviewed. This error occurred during a turnover of staff in the Office of the Registrar. When there are staffing changes in the future, existing staff in the Office of the Registrar will execute the written policy for verification and reporting this data.