2022 Annual Comprehensive Financial Report

Schedule 24 Page 2 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) Public Safety (continued):

Police Equipment & Training - FY 18 Supplemental Body Cameras BJA Body Worn Cameras - FY 16-18 Safe Guilford Traffic Grant - FY 14

$

185,000 254,360 600,000 1,500 42,920 40,000 330,000 125,311 225,000 56,670 880,557 69,000 69,000 69,000 69,000 69,000 145,800 25,000 34,020 30,000 36,978 60,000

$

184,999 254,244 600,000 1,036 42,920 40,000 125,311 217,654 44,834 845,400 68,997 68,739 69,000 68,671 124,951 25,000 16,593 30,000 36,978

$

$

184,999 254,244 600,000 1,036 42,920 40,000 95,955 125,311 217,654 44,834 880,556 68,997 68,739 69,000 68,671 69,000 124,951 25,000 16,593 30,000 36,978 485,651 565,134 675,655 632,189 743,738 127,981 11,484 64,515 989,097 176,000 171,534 166,355 232,036 244,152 320,675 163,626 159,708 84,878 1,065 101

CFAT Grant FY 19

Railroad Tresspassing Grant FY 20

STAR Program

95,955

Lifeline Grant Program - Coronavirus Relief Fund

Colonial Pipeline-Bldg

DNA Cold Case Grant - FY 14

Metro Medical Response System - FY 03 RRT Homeland Security Grant - FY 17 RRT Homeland Security Grant - FY 18 RRT Homeland Security Grant - FY 19 RRT Homeland Security Grant - FY 20 RRT Homeland Security Grant - FY 21

35,156

69,000

Tank Farm Protection Grant Duke Energy Foundation Grant Homeland Security Grant - FY17 Homeland Security Grant - FY18 Homeland Security Grant - FY21 AFG Grant - FY 17

COPS Technology Program - CAD FY 2022

3,000,000

Program Leases

84,878

Debt Service:

Principal Maturities

1,065

Interest, Fees on Long-term Debt

101

Total Public Safety

12,520,940

6,682,321

1,040,551

7,722,872

Transportation: State Planning & Research/PL 104(f) - FY 18 State Planning & Research/PL 104(f) - FY 19 State Planning & Research/PL 104(f) - FY 20 State Planning & Research/PL 104(f) - FY 21 State Planning & Research/PL 104(f) - FY 22

486,789 565,135 808,691 771,866

485,651 565,134 675,655 632,118

71

1,064,910 300,000 988,800 99,806 375,784 1,050,000 176,000 176,000 176,000 244,152 244,152 320,705 163,626 186,817

743,738 45,695 11,484

Safe Routes to School Grant Travel Survey Grant Vision Zero Greensboro Gaylon Depot Renovations

82,286

64,515

Eckerson US 29 Environmental Study Section 5303 Metro Planning - FY 18 Section 5303 Metro Planning - FY 19 Section 5303 Metro Planning - FY 20 Section 5303 Metro Planning - FY 21 Section 5303 Metro Planning - FY 22 NCDOT Advanced Technology Grant FY 20

989,097 176,000 171,534 166,355 142,036 320,675 163,626 159,708

90,000 244,152

Clean Fuel Technology Grant GDOT(Signal) Master Arm Project Greenway Phase 3A-Corner Park Randleman Road FYA Installation Streets Improvement - U-5306-A Streets Improvement - U-5306-B Streets Improvement - U-5306-C Streets Improvement - U-5306-D

NCDOT Project - Market Street-Fanta SC Driveway

32,621 34,690 12,000

34,691

34,691

4,836,025 12,959,788 1,580,000

4,625,049 10,265,874 1,414,270

4,625,049 12,373,817 1,414,270

2,107,943

325,000

319,672

319,672

Total Transportation

27,979,357

21,389,431

3,307,598

24,697,029

-8 5