Audit 50153

FY End
2022-06-30
Total Expended
$14.80M
Findings
4
Programs
15
Organization: Claremont McKenna College (CA)
Year: 2022 Accepted: 2022-11-08
Auditor: Moss Adams LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
61304 2022-001 Significant Deficiency - L
61305 2022-001 Significant Deficiency - L
637746 2022-001 Significant Deficiency - L
637747 2022-001 Significant Deficiency - L

Contacts

Name Title Type
L45FLFHWMGQ9 Erin Watkins Auditee
9096077085 Matt Parsons Auditor
No contacts on file

Notes to SEFA

Title: NOTE 5 - FEDERAL STUDENT LOAN PROGRAM: Accounting Policies: NOTE 2 - SUMMARY OF SIGNIFICANT 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 Uniform Guidance, wherein certain types of expenditures are not allowable or are limited to reimbursement. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: NOTE 4 - INDIRECT COSTS: For the year ended June 30, 2022, the College has an approved 3-year predetermined indirect cost rate which is effective from July 1, 2019 through June 30, 2023. The base rates for on-campus and off-campus research for the year ended June 30, 2022 are 55.9% and 24.5%, respectively. Therefore, the College has elected not to use the 10 percent de minimus indirect cost rate as allowed under UniformGuidance. The federal student loan program 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 made during the year are included in the federal expenditures presented in the Schedule. The balance of loans outstanding at June 30, 2022 consists of: (See Note 5 - Federal Student Loan Program, for table).
Title: NOTE 1 - BASIS OF PRESENTATION: Accounting Policies: NOTE 2 - SUMMARY OF SIGNIFICANT 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 Uniform Guidance, wherein certain types of expenditures are not allowable or are limited to reimbursement. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: NOTE 4 - INDIRECT COSTS: For the year ended June 30, 2022, the College has an approved 3-year predetermined indirect cost rate which is effective from July 1, 2019 through June 30, 2023. The base rates for on-campus and off-campus research for the year ended June 30, 2022 are 55.9% and 24.5%, respectively. Therefore, the College has elected not to use the 10 percent de minimus indirect cost rate as allowed under UniformGuidance. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal grant activity of Claremont McKenna College (the College) under programs of the federal government for the year ended June 30, 2022. The information in this schedule is presented in accordance with the requirements of the Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards ('Uniform Guidance'). 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 the College.
Title: NOTE 3 - RECONCILIATION OF THE SEFA TO THE CONSOLIDATED STMT OF ACTIVITIES Accounting Policies: NOTE 2 - SUMMARY OF SIGNIFICANT 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 Uniform Guidance, wherein certain types of expenditures are not allowable or are limited to reimbursement. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: NOTE 4 - INDIRECT COSTS: For the year ended June 30, 2022, the College has an approved 3-year predetermined indirect cost rate which is effective from July 1, 2019 through June 30, 2023. The base rates for on-campus and off-campus research for the year ended June 30, 2022 are 55.9% and 24.5%, respectively. Therefore, the College has elected not to use the 10 percent de minimus indirect cost rate as allowed under UniformGuidance. The following schedule is a reconciliation of total expenditures as shown in the Schedule of Expenditures of Federal Awards to the revenue caption shown as Federal Grants - Net Assets Without Donor Restriction in the Consolidated Statement of Activities, which is included as part of the Colleges consolidated financial statements: (See Note 3 - RECONCILIATION OF THE SEFA TO THE CONSOLIDATED STMT OF ACTIVITIES, for table).
Title: NOTE 6 ADMINISTRATIVE COST ALLOWANCE RECEIVED UNDER CAMPUS BASED PROGRAMS Accounting Policies: NOTE 2 - SUMMARY OF SIGNIFICANT 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 Uniform Guidance, wherein certain types of expenditures are not allowable or are limited to reimbursement. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: NOTE 4 - INDIRECT COSTS: For the year ended June 30, 2022, the College has an approved 3-year predetermined indirect cost rate which is effective from July 1, 2019 through June 30, 2023. The base rates for on-campus and off-campus research for the year ended June 30, 2022 are 55.9% and 24.5%, respectively. Therefore, the College has elected not to use the 10 percent de minimus indirect cost rate as allowed under UniformGuidance. During the year ended June 30, 2022, the College claimed no administrative cost allowance for the Federal Work-Study program.

Finding Details

FINDING 2022-001 ? Reporting ? Significant Deficiency in Internal Control over Compliance "See Schedule of Findings and Questioned Costs for chart/table" Criteria ? 86 FR 26213 requires Education Stabilization Fund recipients to post certain quarterly information to the institution?s website within 10 days of the end of the quarter in which the funds were expended. Separate quarterly reporting is required to summarize COVID-19 assistance awarded to students and other reporting requires the College to summarize institutional expenditures that were used to cover lost revenue resulting from the pandemic or to reimburse for additional health and safety costs arising in response to the pandemic. Additionally, an annual report was required to be prepared and posted to the College?s website by May 6, 2022. These reports should remain online for a period of at least three years after the submission of the last quarterly or annual performance report. Condition/Context/Effect ? We selected two quarterly reports summarizing COVID-19 assistance awarded to students, three quarterly reports summarizing the College?s institutional expenditures, and the 2021 annual report for testing. We noted an exception in that one quarterly institutional report (out of the 6 reports tested) was not posted within the required timeframe. However, it has since been captured on the College?s website and no exceptions with the information reported were noted as a result of our testing. Questioned Costs ? No questioned costs were identified as part of this finding. Cause ? The College believed that it had completed its reporting requirements in December 2021; however, carryover expenditures occurred in early 2022 requiring one remaining quarterly report to be completed. Repeat Finding ? This is not a repeat finding. Recommendation ? We noted that the College has a tracking mechanism for reporting requirements and followed that throughout the course this award. One additional control that may have aided in preventing this exception is a reconciliation of the award amount to total expenditures incurred to date to help conclude if further reports will be needed. Views of Responsible Officials and Planned Corrective Actions ? Management agrees with the finding related to the timing of posting certain quarterly information to the College?s website within 10 days of the end of the quarter in which Education Stabilization Funds were expended. To address this issue, management has instituted a reconciliation of the award amount to the reported expenditures and implemented regular checks of the College?s COVID-19 response website to ensure reports continue to be posted in a timely manner. The College has now expended all Education Stabilization Funds, so they do not anticipate any additional quarterly reports needing to be posted on the College?s website.
FINDING 2022-001 ? Reporting ? Significant Deficiency in Internal Control over Compliance "See Schedule of Findings and Questioned Costs for chart/table" Criteria ? 86 FR 26213 requires Education Stabilization Fund recipients to post certain quarterly information to the institution?s website within 10 days of the end of the quarter in which the funds were expended. Separate quarterly reporting is required to summarize COVID-19 assistance awarded to students and other reporting requires the College to summarize institutional expenditures that were used to cover lost revenue resulting from the pandemic or to reimburse for additional health and safety costs arising in response to the pandemic. Additionally, an annual report was required to be prepared and posted to the College?s website by May 6, 2022. These reports should remain online for a period of at least three years after the submission of the last quarterly or annual performance report. Condition/Context/Effect ? We selected two quarterly reports summarizing COVID-19 assistance awarded to students, three quarterly reports summarizing the College?s institutional expenditures, and the 2021 annual report for testing. We noted an exception in that one quarterly institutional report (out of the 6 reports tested) was not posted within the required timeframe. However, it has since been captured on the College?s website and no exceptions with the information reported were noted as a result of our testing. Questioned Costs ? No questioned costs were identified as part of this finding. Cause ? The College believed that it had completed its reporting requirements in December 2021; however, carryover expenditures occurred in early 2022 requiring one remaining quarterly report to be completed. Repeat Finding ? This is not a repeat finding. Recommendation ? We noted that the College has a tracking mechanism for reporting requirements and followed that throughout the course this award. One additional control that may have aided in preventing this exception is a reconciliation of the award amount to total expenditures incurred to date to help conclude if further reports will be needed. Views of Responsible Officials and Planned Corrective Actions ? Management agrees with the finding related to the timing of posting certain quarterly information to the College?s website within 10 days of the end of the quarter in which Education Stabilization Funds were expended. To address this issue, management has instituted a reconciliation of the award amount to the reported expenditures and implemented regular checks of the College?s COVID-19 response website to ensure reports continue to be posted in a timely manner. The College has now expended all Education Stabilization Funds, so they do not anticipate any additional quarterly reports needing to be posted on the College?s website.
FINDING 2022-001 ? Reporting ? Significant Deficiency in Internal Control over Compliance "See Schedule of Findings and Questioned Costs for chart/table" Criteria ? 86 FR 26213 requires Education Stabilization Fund recipients to post certain quarterly information to the institution?s website within 10 days of the end of the quarter in which the funds were expended. Separate quarterly reporting is required to summarize COVID-19 assistance awarded to students and other reporting requires the College to summarize institutional expenditures that were used to cover lost revenue resulting from the pandemic or to reimburse for additional health and safety costs arising in response to the pandemic. Additionally, an annual report was required to be prepared and posted to the College?s website by May 6, 2022. These reports should remain online for a period of at least three years after the submission of the last quarterly or annual performance report. Condition/Context/Effect ? We selected two quarterly reports summarizing COVID-19 assistance awarded to students, three quarterly reports summarizing the College?s institutional expenditures, and the 2021 annual report for testing. We noted an exception in that one quarterly institutional report (out of the 6 reports tested) was not posted within the required timeframe. However, it has since been captured on the College?s website and no exceptions with the information reported were noted as a result of our testing. Questioned Costs ? No questioned costs were identified as part of this finding. Cause ? The College believed that it had completed its reporting requirements in December 2021; however, carryover expenditures occurred in early 2022 requiring one remaining quarterly report to be completed. Repeat Finding ? This is not a repeat finding. Recommendation ? We noted that the College has a tracking mechanism for reporting requirements and followed that throughout the course this award. One additional control that may have aided in preventing this exception is a reconciliation of the award amount to total expenditures incurred to date to help conclude if further reports will be needed. Views of Responsible Officials and Planned Corrective Actions ? Management agrees with the finding related to the timing of posting certain quarterly information to the College?s website within 10 days of the end of the quarter in which Education Stabilization Funds were expended. To address this issue, management has instituted a reconciliation of the award amount to the reported expenditures and implemented regular checks of the College?s COVID-19 response website to ensure reports continue to be posted in a timely manner. The College has now expended all Education Stabilization Funds, so they do not anticipate any additional quarterly reports needing to be posted on the College?s website.
FINDING 2022-001 ? Reporting ? Significant Deficiency in Internal Control over Compliance "See Schedule of Findings and Questioned Costs for chart/table" Criteria ? 86 FR 26213 requires Education Stabilization Fund recipients to post certain quarterly information to the institution?s website within 10 days of the end of the quarter in which the funds were expended. Separate quarterly reporting is required to summarize COVID-19 assistance awarded to students and other reporting requires the College to summarize institutional expenditures that were used to cover lost revenue resulting from the pandemic or to reimburse for additional health and safety costs arising in response to the pandemic. Additionally, an annual report was required to be prepared and posted to the College?s website by May 6, 2022. These reports should remain online for a period of at least three years after the submission of the last quarterly or annual performance report. Condition/Context/Effect ? We selected two quarterly reports summarizing COVID-19 assistance awarded to students, three quarterly reports summarizing the College?s institutional expenditures, and the 2021 annual report for testing. We noted an exception in that one quarterly institutional report (out of the 6 reports tested) was not posted within the required timeframe. However, it has since been captured on the College?s website and no exceptions with the information reported were noted as a result of our testing. Questioned Costs ? No questioned costs were identified as part of this finding. Cause ? The College believed that it had completed its reporting requirements in December 2021; however, carryover expenditures occurred in early 2022 requiring one remaining quarterly report to be completed. Repeat Finding ? This is not a repeat finding. Recommendation ? We noted that the College has a tracking mechanism for reporting requirements and followed that throughout the course this award. One additional control that may have aided in preventing this exception is a reconciliation of the award amount to total expenditures incurred to date to help conclude if further reports will be needed. Views of Responsible Officials and Planned Corrective Actions ? Management agrees with the finding related to the timing of posting certain quarterly information to the College?s website within 10 days of the end of the quarter in which Education Stabilization Funds were expended. To address this issue, management has instituted a reconciliation of the award amount to the reported expenditures and implemented regular checks of the College?s COVID-19 response website to ensure reports continue to be posted in a timely manner. The College has now expended all Education Stabilization Funds, so they do not anticipate any additional quarterly reports needing to be posted on the College?s website.