Audit 5974

FY End
2023-02-28
Total Expended
$11.26M
Findings
4
Programs
1
Year: 2023 Accepted: 2023-12-10
Auditor: Mahoney

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
3819 2023-001 Significant Deficiency Yes P
3820 2023-002 Significant Deficiency - N
580261 2023-001 Significant Deficiency Yes P
580262 2023-002 Significant Deficiency - N

Programs

ALN Program Spent Major Findings
14.126 Mortgage Insurance_cooperative Projects $11.26M Yes 2

Contacts

Name Title Type
SFHLVBVMFEX3 Jesse Lambrecht Auditee
5072855082 Darren Fetzer Auditor
No contacts on file

Notes to SEFA

Title: Insured Mortgage Loan Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal grant activity of the Cooperative under programs of the federal government for the year ended February 28, 2023. 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 (the Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Cooperative, it is not intended to and does not present the financial position, results of operations, or cash flows of the Cooperative. De Minimis Rate Used: N Rate Explanation: The Cooperative’s federal award is not based on eligible costs incurred. Accordingly, the Cooperative has not made an election related to use of the 10% de minimis indirect cost rate described in the Uniform Guidance. Federal expenditures for the mortgage insurance program represent the principal balance of the insured loan as of February 28, 2022. The loan is outstanding from a previous period. The federal government imposes continuing compliance requirements on this loan. The loan balance at February 28, 2023 was $11,089,827.

Finding Details

2023-001 – Significant deficiency – segregation of duties Criteria - Good internal control requires a segregation of duties and responsibilities such that no one employee has access to both physical assets and the related accounting records, or to all phases of a transaction. Condition - The Cooperative has one employee that performs day to day management and accounting functions. Cause - The size of the Cooperative’s accounting and administrative staff precludes certain internal controls that would be preferred if the office staff were large enough to provide optimum segregation of duties. Effect - The lack of segregation of duties may result in undetected errors in financial statements and increases the possibility of misappropriation of Cooperative assets. Repeat Finding - This finding was reported in the prior year as finding 2022-001. Recommendation - The Board of Directors should remain involved in the financial affairs of the Cooperative on a regular ongoing basis to provide oversight and independent review functions and mitigate the weakness created by the lack of segregation. Auditee’s comment - The Board of Directors is and will remain involved in the financial affairs of the Cooperative. Status - Outstanding Auditor’s non-compliance code - S - Internal Control Deficiencies
2023-002 – Significant Deficiency and Noncompliance – Required Payments to General Operating Reserve Department of Housing and Urban Development Assistance Listing Number 14.126 – Mortgage Insurance - Cooperative Projects Significant Deficiency and Noncompliance Category of Finding – Special Tests and Provisions Criteria - The Cooperative’s regulatory agreement with HUD requires monthly payments to a General Operating Reserve. Deposits are 3% of member carrying charges until the balance of the reserve exceeds 15% of current annual member carrying charges. The required deposit is then reduced to 2% of monthly charges until the balance of the reserve exceeds 25% of annual carrying charges. Condition - Deposits to the segregated account for the General Operating Reserve during the period ended February 28, 2023 were $5,437 less than the required amount for the year. Cause - The Cooperative inadvertently omitted making $5,437 of monthly deposits to the General Operating Reserve in 2023. The control in place to assure the required monthly deposits were made failed to work; however, a monitoring control identified the error and corrected the deficiency prior to the conclusion of the audit. Effect - The Cooperative was out of compliance with their HUD regulatory agreement at February 28, 2023, because the General Operating Reserve was underfunded. Recommendation - We recommend that the Cooperative implement a control process to ensure adherence to the regulatory agreement and make the required monthly deposits to the General Operating Reserve. Auditee’s comment - On May 18, 2023, prior to the conclusion of the audit, the Cooperative made a deposit of $5,437 to the General Operating Reserve to fund the reserve to its proper balance. The CFO of the management agent will implement a process to ensure deposits are made as required by the regulatory agreement. Status - Resolved Auditor’s non-compliance code - Z - Other Responsible party for corrective action – Craig Brinkman, CFO of Real Estate Equities Development, LLC (Management Agent)
2023-001 – Significant deficiency – segregation of duties Criteria - Good internal control requires a segregation of duties and responsibilities such that no one employee has access to both physical assets and the related accounting records, or to all phases of a transaction. Condition - The Cooperative has one employee that performs day to day management and accounting functions. Cause - The size of the Cooperative’s accounting and administrative staff precludes certain internal controls that would be preferred if the office staff were large enough to provide optimum segregation of duties. Effect - The lack of segregation of duties may result in undetected errors in financial statements and increases the possibility of misappropriation of Cooperative assets. Repeat Finding - This finding was reported in the prior year as finding 2022-001. Recommendation - The Board of Directors should remain involved in the financial affairs of the Cooperative on a regular ongoing basis to provide oversight and independent review functions and mitigate the weakness created by the lack of segregation. Auditee’s comment - The Board of Directors is and will remain involved in the financial affairs of the Cooperative. Status - Outstanding Auditor’s non-compliance code - S - Internal Control Deficiencies
2023-002 – Significant Deficiency and Noncompliance – Required Payments to General Operating Reserve Department of Housing and Urban Development Assistance Listing Number 14.126 – Mortgage Insurance - Cooperative Projects Significant Deficiency and Noncompliance Category of Finding – Special Tests and Provisions Criteria - The Cooperative’s regulatory agreement with HUD requires monthly payments to a General Operating Reserve. Deposits are 3% of member carrying charges until the balance of the reserve exceeds 15% of current annual member carrying charges. The required deposit is then reduced to 2% of monthly charges until the balance of the reserve exceeds 25% of annual carrying charges. Condition - Deposits to the segregated account for the General Operating Reserve during the period ended February 28, 2023 were $5,437 less than the required amount for the year. Cause - The Cooperative inadvertently omitted making $5,437 of monthly deposits to the General Operating Reserve in 2023. The control in place to assure the required monthly deposits were made failed to work; however, a monitoring control identified the error and corrected the deficiency prior to the conclusion of the audit. Effect - The Cooperative was out of compliance with their HUD regulatory agreement at February 28, 2023, because the General Operating Reserve was underfunded. Recommendation - We recommend that the Cooperative implement a control process to ensure adherence to the regulatory agreement and make the required monthly deposits to the General Operating Reserve. Auditee’s comment - On May 18, 2023, prior to the conclusion of the audit, the Cooperative made a deposit of $5,437 to the General Operating Reserve to fund the reserve to its proper balance. The CFO of the management agent will implement a process to ensure deposits are made as required by the regulatory agreement. Status - Resolved Auditor’s non-compliance code - Z - Other Responsible party for corrective action – Craig Brinkman, CFO of Real Estate Equities Development, LLC (Management Agent)