COG Comprehensive Annual Financial Report

Schedule 25

Housing Partnership Revolving Fund Schedule of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual For the Fiscal Year Ended June 30, 2018

Variance Positive (Negative)

Final Budget

Actual

Revenues: Taxes:

Ad Valorem Taxes

$

1,882,000

$

1,891,719

$

9,719

Charges for Current Services: Mortgage Collections Sale of Real Estate Other Revenue

60,000 28,000 3,760 91,760

71,226 4,950 881 77,057

11,226 (23,050) (2,879) (14,703)

Total Charges for Current Services

Investment Income

20,000

23,372

3,372

Appropriated Fund Balance

918,989

(918,989)

Total Revenues

2,912,749

1,992,148

(920,601)

Expenditures: Neighborhood Development: Administration Homeless Prevention Housing Programs

2,022,663 581,895 670,846

1,539,169 560,383 536,876

483,494 21,512 133,970

Total Expenditures

3,275,404

2,636,428

638,976

Excess of Revenues Under Expenditures

(362,655)

(644,280)

(281,625)

Other Financing Sources: Transfers In

362,655

362,655

Excess of Revenues and Other Financing Sources Under Expenditures

$

(281,625)

(281,625)

Fund Balance - July 1

2,797,536

2,797,536

Fund Balance - June 30

$ 2,515,911

$ 2,515,911

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 Current Year Activity Fund Balance - June 30

$ 2,515,911

9,370,002 (103,263) $ 11,782,650

-79-