2021 Annual Comprehensive Financial Report

Schedule 24 Page 4 of 4

State and Federal Grants Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual From Project Inception and For the Fiscal Year Ended June 30, 2021

Actual Current

Project

Prior Years

Total

Authorization

Year

To Date

Expenditures: (Continued) Neighborhood Development (continued): Fair Housing Assistance - 2016-17 Fair Housing Assistance - 2017-18 Fair Housing Assistance - 2018-19 Fair Housing Assistance - 2019-20

$

76,950 59,700 68,300 81,100 1,500 182,064 177,564 183,371 195,930

$

34,443

$

34,709 32,283

$

69,152 32,283

Traid Korean Church Grant Emergency Solutions - FY18 Emergency Solutions - FY19 Emergency Solutions - FY20 Emergency Solutions - FY21 Emergency Solutions - COVID LFPP Implementation Grant

1,000

1,000

182,064 170,031 173,796

182,064 177,564 183,371 152,250 631,467 694,907 685,642 325,096 370,437 419,625 28,138 10,000 22,000 10,000 11,800 500,000

7,533 9,575

152,250 631,467

2,556,468 820,300 1,000,000 325,096 370,437 419,625 474,056 533,970

694,907 685,642 325,096 370,437 169,805

EPA RLF Brownsfield Cleanup Grant

HOPWA - FY16-17 HOPWA - FY17-18 HOPWA - FY18-19 HOPWA - FY19-20 HOPWA - FY20-21 HOPWA - COVID

249,820

77,708 10,000 22,000 10,000

28,138

Historic Preservation - FY 17 Historic Preservation - FY 19 Historic Preservation - FY 21 Tornado Recovery Grant

10,000 11,460

10,540 10,000 11,800

1,000,000 500,000 2,900,000 2,698,441 15,138,034

Building Reuse Grant

500,000 1,025,886

1,310,635

Lead Paint & Healthy Homes Grant - FY17 Lead Paint & Healthy Homes Grant - FY21 Total Neighborhood Development

284,749 73,413 1,538,887

73,413

4,736,102

6,274,989

Total Expenditures

66,602,032

28,067,503

12,915,759

40,983,262

Excess of Revenues Under Expenditures

(3,903,913)

(4,014,320)

(3,401,551)

(7,415,871)

Other Financing Sources: Transfers In

3,903,913

1,358,641

137,986

1,496,627

Excess of Revenues and Other Financing Sources Under Expenditures

$

(2,655,679)

(3,263,565)

(5,919,244)

Fund Balance - July 1

(2,655,679)

Fund Balance - June 30

(2,655,679) $

(5,919,244) $

(5,919,244) $

Reconciliation of Budgetary Basis to GAAP Basis: Excess of Revenues and Other Financing Sources Over Expenditures and Other Financing (Uses) Difference in Loan Treatment Required by Governmental Accounting Standards Beginning Balance - July 1

(5,919,244) $

133,872 (14,864)

Current Year Activity Fund Balance - June 30

(5,800,236) $

-84-