2023 Annual Comprehensive Report

Schedule 23 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, 2023

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 Fair Housing Assistance - 2020-21 Fair Housing Assistance - 2021-22 Triad Korean Church Grant Emergency Solutions - FY20 Emergency Solutions - FY21 Emergency Solutions - FY22 Emergency Solutions - FY23 Emergency Solutions - COVID EPA RLF Brownsfield Cleanup Grant

$

76,950 59,700 68,300 81,100 75,700 120,620 183,371 195,930 192,761 196,979 1,500

$

76,950 59,700 46,190 15,071

$

$

76,950 59,700 55,100 57,234 40,121 183,371 195,930 192,761 20,296 1,000

8,910 42,163 40,121

1,000

183,371 195,870 98,003

60

94,758 20,296 881,032 50,549 249,923

2,556,468 1,000,000 474,056 533,970 599,557 1,120,999

1,392,663 699,090 224,133

2,273,695 749,639 474,056

HOPWA - FY19-20 HOPWA - FY20-21 HOPWA - FY21-22 HOPWA - FY22-23 HOPWA - COVID

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

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

23,176

62,511 22,000 10,000 45,250 486,488 483,568 300,000 50,000

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 US 421 Corridor Land Use Building Reuse Grant

45,250 137,485

1,000,000 500,000 500,000

100,000

50,000 100,000 200,000 666,667

17,382

17,382

Industrial Development Fund - U-530 LT Apparel Lead Paint & Healthy Homes Grant - FY17 Lead Paint & Healthy Homes Grant - FY21

2,900,000 2,698,441 16,632,815

1,310,635 451,082 6,198,576

1,310,635 1,135,298 8,603,023

684,216 2,404,447

Total Neighborhood Development

Total Expenditures

75,710,928

38,790,801

12,585,693

51,376,494

Excess of Revenues Over (Under) Expenditures

8,532,763

2,517,673

(3,739,894)

(1,222,221)

Other Financing Sources (Uses): Transfers In

5,035,596 (13,568,359)

4,052,207 (10,010,633)

665,816

4,718,023 (13,478,208)

Transfers Out

(3,467,575)

Lease Liability Issued

84,878

84,878 61,066

IT Subscription Liability Issued

61,066

Total Other Financing Sources (Uses)

(8,532,763)

(5,873,548)

(2,740,693)

(8,614,241)

Excess of Revenues and Other Financing Sources Under Expenditures

$

(3,355,875)

(6,480,587)

(9,836,462)

Fund Balance - July 1

(3,355,875)

Fund Balance - June 30

$ (3,355,875)

$ (9,836,462)

$ (9,836,462)

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

$ (9,836,462)

103,974

Current Year Activity Fund Balance - June 30

9,444

$ (9,723,044)

-88