2022 Annual Comprehensive Financial Report

Schedule 20

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

Variance Positive (Negative)

Final

Budget

Actual

Revenues: Taxes:

Ad Valorem Taxes

2,013,000 $

2,048,649 $

$

35,649

Charges for Current Services: Mortgage Collections

75,000 28,000 15,304 118,304

804,645

729,645 (28,000) (3,793) 697,852

Sale of Real Estate Other Revenue

11,511 816,156

Total Charges for Current Services

Investment Income (Loss)

35,000

(130,840)

(165,840)

Appropriated Fund Balance

1,886,483

(1,886,483)

Total Revenues

4,052,787

2,733,965

(1,318,822)

Expenditures: Neighborhood Development: Administration

1,895,264 617,694 200,000

1,646,388 429,388 100,000

248,876 188,306 100,000

Homeless Prevention

Mass Housing Displacement Program

Total Expenditures

2,712,958

2,175,776

537,182

Excess of Revenues Over Expenditures

1,339,829

558,189

(781,640)

Other Financing Sources (Uses): Transfers In

4,037

4,037

Transfers Out

(1,339,829) (1,339,829)

(1,339,829) (1,335,792)

Total Other Financing Sources (Uses)

4,037

Excess of Revenues and Other Financing Sources Under Expenditures and Other Financing (Uses) $

(777,603)

(777,603)

Fund Balance - July 1

2,983,225

2,983,225

Fund Balance - June 30

2,205,622 $

2,205,622 $

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

2,205,622 $

16,994,426 1,082,090 20,282,138 $

Current Year Activity Fund Balance - June 30

-7 9