Audit 301306

FY End
2023-06-30
Total Expended
$209.65M
Findings
0
Programs
30
Organization: City of Memphis (TN)
Year: 2023 Accepted: 2024-03-30

Organization Exclusion Status:

Checking exclusion status...

Findings

No findings recorded

Programs

ALN Program Spent Major Findings
21.023 Emergency Rental Assistance Program $52.01M - 0
66.958 Water Infrastructure Finance and Innovation (wifia) (e) $24.53M Yes 0
66.458 Capitalization Grants for Clean Water State Revolving Funds $19.33M Yes 0
14.218 Community Development Block Grants/entitlement Grants $3.02M Yes 0
93.137 Community Programs to Improve Minority Health Grant Program $2.98M Yes 0
97.083 Staffing for Adequate Fire and Emergency Response (safer) $2.35M Yes 0
14.231 Emergency Solutions Grant Program $2.03M - 0
14.241 Housing Opportunities for Persons with Aids $2.02M - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $1.54M - 0
97.044 Assistance to Firefighters Grant $1.53M Yes 0
14.905 Lead Hazard Reduction Demonstration Grant Program $1.23M - 0
16.000 Lead Hazard Reduction Demonstration Grant Program $605,201 - 0
97.025 National Urban Search and Rescue (us&r) Response System $420,215 Yes 0
16.833 National Sexual Assault Kit Initiative $331,040 - 0
93.568 Low-Income Home Energy Assistance $291,379 Yes 0
81.042 Weatherization Assistance for Low-Income Persons $239,711 - 0
15.904 Historic Preservation Fund Grants-in-Aid $201,131 - 0
20.205 Highway Planning and Construction $101,035 Yes 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $91,425 - 0
14.239 Home Investment Partnerships Program $79,795 - 0
95.001 High Intensity Drug Trafficking Areas Program $51,286 - 0
20.607 Alcohol Open Container Requirements $47,830 - 0
45.310 Grants to States $27,387 - 0
45.024 Promotion of the Arts_grants to Organizations and Individuals $23,479 - 0
93.568 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $21,813 Yes 0
16.034 Coronavirus Emergency Supplemental Funding Program $19,812 Yes 0
16.582 Public Safety Partnership and Community Policing Grants $19,379 - 0
97.056 Port Security Grant Program $18,908 - 0
16.582 Crime Victim Assistance/discretionary Grants $14,938 - 0
11.609 Measurement and Engineering Research and Standards $958 - 0

Contacts

Name Title Type
LSWERD3XLNU8 Crystal Givens Auditee
9016366000 Christopher Hearn Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: The expenditures presented in the associated schedules of expenditures of federal awards and state financial assistance were developed from agency records and federal and state financial reports which have been reconciled to the central accounting records of the government. Governmental funds are reported using a modified accrual basis of accounting. Proprietary funds are reported using the accrual basis of accounting. Federal and state revenues and expenditures are included in the general fund, special revenue funds, capital projects funds, and enterprise funds in the government's basic financial statements. The City of Memphis has not elected to use the 10% de minimis indirect cost rate under the Uniform Guidance. De Minimis Rate Used: Y Rate Explanation: The City of Memphis has not elected to use the 10% de minimis indirect cost rate under the Uniform Guidance The accompanying schedule of expenditures of federal awards and state financial assistance includes the federal and state grant activity of the City of Memphis and is presented on the modified accrual basis of accounting. 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). Therefore, some amounts presented in this schedule may differ from those presented in, or used in, preparing the general‐purpose financial statements. In compliance with Tennessee state law, the accompanying schedule of expenditures of state financial assistance is included in this report. The schedule presents all state‐funded financial awards, as defined by the State Comptroller of the Treasury's Office, and is prepared and presented in a manner consistent with the schedule of expenditures of federal awards.
Title: Basis of Accounting Accounting Policies: The expenditures presented in the associated schedules of expenditures of federal awards and state financial assistance were developed from agency records and federal and state financial reports which have been reconciled to the central accounting records of the government. Governmental funds are reported using a modified accrual basis of accounting. Proprietary funds are reported using the accrual basis of accounting. Federal and state revenues and expenditures are included in the general fund, special revenue funds, capital projects funds, and enterprise funds in the government's basic financial statements. The City of Memphis has not elected to use the 10% de minimis indirect cost rate under the Uniform Guidance. De Minimis Rate Used: Y Rate Explanation: The City of Memphis has not elected to use the 10% de minimis indirect cost rate under the Uniform Guidance The expenditures presented in the associated schedules of expenditures of federal awards and state financial assistance were developed from agency records and federal and state financial reports which have been reconciled to the central accounting records of the government. Governmental funds are reported using a modified accrual basis of accounting. Proprietary funds are reported using the accrual basis of accounting. Federal and state revenues and expenditures are included in the general fund, special revenue funds, capital projects funds, and enterprise funds in the government's basic financial statements. The City of Memphis has not elected to use the 10% de minimis indirect cost rate under the Uniform Guidance.
Title: Federal loans Accounting Policies: The expenditures presented in the associated schedules of expenditures of federal awards and state financial assistance were developed from agency records and federal and state financial reports which have been reconciled to the central accounting records of the government. Governmental funds are reported using a modified accrual basis of accounting. Proprietary funds are reported using the accrual basis of accounting. Federal and state revenues and expenditures are included in the general fund, special revenue funds, capital projects funds, and enterprise funds in the government's basic financial statements. The City of Memphis has not elected to use the 10% de minimis indirect cost rate under the Uniform Guidance. De Minimis Rate Used: Y Rate Explanation: The City of Memphis has not elected to use the 10% de minimis indirect cost rate under the Uniform Guidance The City of Memphis was approved by the Environmental Protection Agency, Office of Water, to receive a loan totaling $100,000,000 (SRF 13‐311) to improve its sewer system. The amount listed for this loan, $84,843,844, includes proceeds during the year and the outstanding loan balance from prior years. The City of Memphis was approved by the Environmental Protection Agency, Office of Water, to receive a loan totaling $7,000,000 (SRF 06‐195) to improve its sewer system. The amount listed for this loan, $2,267,189, includes proceeds during the year and the outstanding loan balance from prior years. This loan has been closed out and no further draws will be made on it. The City of Memphis was approved by the Environmental Protection Agency, Office of Water, to receive a loan totaling $22,000,000 (SRF 13‐309) to improve its sewer system. The amount listed for this loan, $8,788,961, includes proceeds during the year and the outstanding balance from prior years. The City of Memphis was approved by the Environmental Protection Agency, Office of Water, to receive a loan totaling $25,000,000 (SRF 15‐355) to improve its sewer system. The amount listed for this loan, $22,370,986, includes proceeds during the year. The City of Memphis was approved by the Environmental Protection Agency, Office of Water, to receive a loan totaling $11,000,000 (SRF 18‐409) to improve its sewer system. The amount listed for this loan, $9,758,199, includes proceeds during the year. The City of Memphis was approved by the Environmental Protection Agency, Office of Water, to receive a loan totaling $6,500,000 (SRF 19‐421) to improve its sewer system. The amount listed for this loan, $5,729,176, includes proceeds during the year. The City of Memphis was approved by the Environmental Protection Agency, Office of Water, to receive a loan totaling $48,000,000 (SRF 19‐434) to improve its sewer system. The amount listed for this loan, $41,435,415, includes proceeds during the year. The City of Memphis was approved by the Environmental Protection Agency, Office of Water, to receive a loan totaling $15,000,000 (SRF 21‐451) to improve its sewer system. The amount listed for this loan, $12,427,474, includes proceeds during the year. The City of Memphis was approved by the Environmental Protection Agency, to receive a Water Infrastructure Finance and Innovation Act (WIFIA) loan totaling $156,000,000 (18157TN) to improve its sewer system. The amount listed for this loan, $64,589,594, includes proceeds during the year. Both the current and prior year loans are also reported on the City of Memphis's Statement of Net Position for Proprietary Funds. Also, the current loan payable and the long‐term loan payable equal the total loan amounts. (see Exhibit A‐9)
Title: Contingencies Accounting Policies: The expenditures presented in the associated schedules of expenditures of federal awards and state financial assistance were developed from agency records and federal and state financial reports which have been reconciled to the central accounting records of the government. Governmental funds are reported using a modified accrual basis of accounting. Proprietary funds are reported using the accrual basis of accounting. Federal and state revenues and expenditures are included in the general fund, special revenue funds, capital projects funds, and enterprise funds in the government's basic financial statements. The City of Memphis has not elected to use the 10% de minimis indirect cost rate under the Uniform Guidance. De Minimis Rate Used: Y Rate Explanation: The City of Memphis has not elected to use the 10% de minimis indirect cost rate under the Uniform Guidance The federal and state awards received by the City of Memphis are subject to audit and adjustment. If any expenditures are disallowed by the grantor agencies because of such an audit, the grantor agencies could make a claim for reimbursement, which would become a liability of the City of Memphis.