2022 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, 2022

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 Traid Korean Church Grant Emergency Solutions - FY18 Emergency Solutions - FY19 Emergency Solutions - FY20 Emergency Solutions - FY21 Emergency Solutions - FY22 Emergency Solutions - COVID LFPP Implementation Grant EPA RLF Brownsfield Cleanup Grant

$

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

$

69,152 32,283

$

7,798 27,417 46,190 15,071

$

76,950 59,700 46,190 15,071 1,000 182,064 177,564 183,371 195,870 98,003

1,000

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

43,620 98,003 761,196

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

1,392,663 694,907 699,090 325,096 370,437 419,625 224,133

13,448

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

224,133

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

11,197

39,335 10,000 22,000 10,000 349,003 483,568 200,000 50,000

Historic Preservation - FY 17 Historic Preservation - FY 19 Historic Preservation - FY 21 Historic Preservation - FY 22 Tornado Recovery Grant One NC Fund - Fresh Market One NC Fund - Pactiv LLC NC Bioteck Award - Syngenta Building Reuse Grant

1,000,000 500,000 500,000 50,000 100,000 2,900,000 2,698,441 16,630,352

337,203 (16,432) 200,000 50,000

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

1,310,635

1,310,635 451,082 8,471,685

73,413

377,669 2,196,696

6,274,989

Total Expenditures

85,367,733

40,983,262

11,406,511

52,389,773

Excess of Revenues Over (Under) Expenditures

5,262,975

(7,415,871)

9,886,172

2,470,301

Other Financing Sources: Transfers In

4,747,658 (10,010,633)

1,496,627

2,602,952 (10,010,633)

4,099,579 (10,010,633)

Transfers Out

Lease Liabilities Issued

84,878

84,878

Total Other Financing Sources (Uses)

(5,262,975)

1,496,627

(7,322,803)

(5,826,176)

Excess of Revenues and Other Financing Sources Over (Under) Expenditures

$

(5,919,244)

2,563,369

(3,355,875)

Fund Balance - July 1

(5,919,244)

Fund Balance - June 30

(5,919,244) $

(3,355,875) $

(3,355,875) $

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

(3,355,875) $

119,008 (15,034)

Current Year Activity Fund Balance - June 30

(3,251,901) $

-8 7