Audit 29416

FY End
2022-12-31
Total Expended
$25.09M
Findings
0
Programs
28
Organization: City of Aurora, Colorado (CO)
Year: 2022 Accepted: 2023-07-14
Auditor: Forvis LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
21.023 Emergency Rental Assistance Program $2.03M Yes 0
14.231 Emergency Solutions Grant Program $2.00M - 0
14.239 Home Investment Partnerships Program $794,914 Yes 0
95.001 High Intensity Drug Trafficking Areas Program $518,997 Yes 0
16.835 Body Worn Camera Policy and Implementation $506,793 - 0
20.205 Highway Planning and Construction $409,073 - 0
97.083 Staffing for Adequate Fire and Emergency Response (safer) $365,827 - 0
97.044 Assistance to Firefighters Grant $365,310 - 0
14.218 Community Development Block Grants/entitlement Grants $340,529 Yes 0
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $278,501 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $203,973 - 0
20.600 State and Community Highway Safety $171,745 - 0
59.037 Small Business Development Centers $155,000 - 0
16.609 Project Safe Neighborhoods $142,997 - 0
45.310 Grants to States $119,431 - 0
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $103,986 - 0
16.741 Dna Backlog Reduction Program $103,657 - 0
59.075 Shuttered Venue Operators Grant Program $94,131 - 0
20.616 National Priority Safety Programs $72,120 - 0
97.025 National Urban Search and Rescue (us&r) Response System $63,070 - 0
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $57,276 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $53,570 Yes 0
97.042 Emergency Management Performance Grants $47,340 - 0
16.922 Equitable Sharing Program $32,559 - 0
16.543 Missing Children's Assistance $12,287 - 0
16.034 Coronavirus Emergency Supplemental Funding Program $11,054 - 0
14.169 Housing Counseling Assistance Program $5,765 - 0
97.047 Pre-Disaster Mitigation $387 - 0

Contacts

Name Title Type
KVZATDBDECG8 Nancy Wishmeyer Auditee
3037917000 Marcie Ardan Auditor
No contacts on file

Notes to SEFA

Title: Pass-through Entity Identifying Number Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal grant activity of the primary government of the City of Aurora, Colorado (the City). The Citys reporting entity is defined in Note 1 in the Citys basic financial statements for the year ended December 31, 2022.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 this Schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position or cash flows of the City. The schedule of expenditures of federal awards includes federally funded projects received directly from federal agencies and the federal amount of pass-through awards received by the City through the state of Colorado or other non-federal entities. Expenditures reported on the Schedule are recognized on the accrual or modified accrual basis of accounting. The Citys summary of significant accounting policies is presented in Note 1 to the Citys basic financial statements for the year ended December 31, 2022. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable regulatory guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Therefore, some amounts presented in the schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements or reports to federal agencies. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior periods. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. For federal awards expended by the City as a subrecipient, the Schedule includes identification of the pass-through grantor and the identifying number assigned to the grant by the pass-through grantor where the pass-through grantor has supplied such number to the City.
Title: Revolving Loan Funds Not Subject to Compliance Accounting Policies: The accompanying Schedule of Expenditures of Federal Awards (the Schedule) includes the federal grant activity of the primary government of the City of Aurora, Colorado (the City). The Citys reporting entity is defined in Note 1 in the Citys basic financial statements for the year ended December 31, 2022.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 this Schedule presents only a selected portion of the operations of the City, it is not intended to and does not present the financial position, changes in net position or cash flows of the City. The schedule of expenditures of federal awards includes federally funded projects received directly from federal agencies and the federal amount of pass-through awards received by the City through the state of Colorado or other non-federal entities. Expenditures reported on the Schedule are recognized on the accrual or modified accrual basis of accounting. The Citys summary of significant accounting policies is presented in Note 1 to the Citys basic financial statements for the year ended December 31, 2022. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable regulatory guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Therefore, some amounts presented in the schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements or reports to federal agencies. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior periods. De Minimis Rate Used: N Rate Explanation: The City has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance. The City has certain revolving loan funds, which were originally financed with federal financial assistance through the Community Development Block Grant Program, the HOME Investment Partnership Program and the Brownfields Grant Program. The outstanding balances of these loan funds at December 31, 2022 were $2,683,595 for the Community Development Block Grant Program, $10,870,972 for the HOME Investment Partnership Program, and $920,621 for the Brownfields Grant Program. Since there are no continuing compliance requirements other than continued loan payments, the outstanding loan balances have not been included in the Schedule. New loans made during the year under these programs are included in the Schedule.