COG Comprehensive Annual Financial Report

Schedule 29 Page 3 of 3

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

Actual Current Year

Project Authorization

Prior Years

Total To Date

Expenditures: (Continued) Culture and Recreation:

Seniors General Purpose - FY 16 Seniors General Purpose - FY 17 Seniors General Purpose - FY 18 Ruth Wicker - Memorial to Women Grant

$

15,200 14,504 14,585 900,000 26,200 130,058 20,000 5,589 10,000 37,965 15,000 13,000

$

15,200 14,208

$

$

15,200 14,504 14,585 759,169 26,200 127,620 20,000 5,589 10,000 37,965

296 14,585

759,169 26,200 127,620

National Recreation & Parks Association-Out of School Grant Special Events,Tourism,Culturally-Related Activities - FY 15 Special Events,Tourism,Culturally-Related Activities Volleyball Special Events,Tourism,Culturally-Related Activities Swim Special Events,Tourism,Culturally-Related Activities - FY 18

20,000 379 10,000 37,965

5,210

Duke Energy Grant USTA Grant - FY 17 USTA Build it Forward - FY 17 USTA Rasie the Net - FY 17 Carolina Panthers Grant - FY 18 LWCF Keeley Park Phase 2 Grant Total Culture and Recreation Planning and Community Development: Fair Housing Assistance - FY 09 Fair Housing Assistance - FY 10 Fair Housing Assistance - FY 11 Fair Housing Assistance - FY 12 Fair Housing Assistance - FY 13 Fair Housing Assistance - FY 14 Fair Housing Assistance - FY 15 Fair Housing Assistance - FY 16 Fair Housing Assistance - FY 17 Emergency Solutions - FY15 Emergency Solutions - FY16 Emergency Solutions - FY17 Emergency Solutions - FY18 Lead Paint Grant - FY 11 LFPP Implementation Grant EPA RLF Brownsfield Cleanup Grant

7,000 4,000 250,000 1,463,101

3,757

3,757

947,607

86,982

1,034,589

98,330 118,292 154,725 72,562 20,854 67,788 39,275 38,250 76,950

97,536 118,067 146,151 22,873

794 225 8,574 38,966 782 (1,161)

98,330 118,292 154,725 61,839 7,282 5,360 1,433 14,788 3,189

6,500 6,521 1,433 9,491

5,297 3,189

164,178 177,108 177,096 182,064 3,100,000 820,300 1,000,000 316,966 321,182 325,096 370,437 10,000 2,900,000 10,551,453

164,178 177,108 177,096

164,178 177,108 177,096 120,749 2,903,110

120,749

2,903,110 128,921 684,989 316,966 321,182 29,899

200,727 653

329,648 685,642 316,966 321,182 229,263

HOPWA - FY 15 HOPWA - FY 16 HOPWA - FY 17 HOPWA - FY 18 Historic Preservation - FY 17

199,364

Lead Paint & Healthy Homes Grant - FY 18 Total Planning and Community Development

102,555 680,714

102,555 5,992,735

5,312,021

Total Expenditures

36,697,611

18,605,639

4,805,948

23,411,587

Excess of Revenues Over (Under) Expenditures

(1,195,660)

(2,540,769)

1,623,081

(917,688)

Other Financing Sources: Transfers In

1,195,660

1,181,421

12,806

1,194,227

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

$

(1,359,348)

1,635,887

276,539

Fund Balance - July 1

(1,359,348)

Fund Balance - June 30

$ (1,359,348)

$

276,539

$ 276,539

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

$

276,539

143,000 419,539

Current Year Activity Fund Balance - June 30

$

-86-