Red Hook WatchIndependent Community Resource

Annual Financial Report for the Fiscal Period 06/01/2022 - 05/31/2023

Meetings/Documents/wd::dc_afr_fy22_23
Working document2023-05-31
Original file not available online (local: data/sources/village_docs/dc_afr_fy22_23.pdf)View version history →Meeting on 2023-05-31 →

Village of Red Hook Annual Financial Report For the Fiscal Period 06/01/2022 - 05/31/2023

Village of Red Hook Annual Financial Report For the Fiscal Period 06/01/2022 - 05/31/2023

Authorization

Article 3, Section 30 of the General Municipal Law

  1. Every Municipal Corporation shall annually make a report of its financial condition to the Comptroller. Such report shall be made by the Chief Fiscal Officer of such Municipal Corporation***

  2. All reports shall be certified by the officer making the same and shall be filed with the Comptroller*** it shall be the duty of the incumbent officer at the time such reports are required to be filed with the Comptroller to file such report***

Certification Statement

I, Lori Urbin (LG130470304160A), hereby certify that I am the Chief Financial Officer of the Village of Red Hook, and that the information provided in the Annual Financial Report of the Village of Red Hook for the fiscal year ended 05/31/2023, is true and correct to the best of my knowledge and belief.

Table of contents

Financial Statements

Financial Statements.....................................................................................................................1
A - General..................................................................................................................2
ES - Enterprise Sewer..................................................................................................................19
EW - Enterprise Water..................................................................................................................29
H - Capital Projects..................................................................................................................39
TE - Private Purpose Trust..................................................................................................................44
K - General Fixed Assets..................................................................................................................49
W - General Long Term Debt..................................................................................................................50
Supplemental Schedules.....................................................................................................................51
Statement of Indebtedness..................................................................................................................52
Bond Repayment..................................................................................................................54
Bank Reconciliation..................................................................................................................58
Employee and Retiree Benefits..................................................................................................................61

Village of Red Hook Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

Financial Statements

Financial information for the following funds and accounts groups are included in the Annual Financial Report filed by your government for the fiscal year ended 2023 and has been used by the OSC as the basis for preparing this Annual Financial Report for the fiscal year ended 2023:

List of funds being used

  • A - General

  • ES - Enterprise Sewer

  • EW - Enterprise Water

  • H - Capital Projects

  • TE - Private Purpose Trust

  • K - General Fixed Assets

  • W - General Long Term Debt

All amounts included in this Annual Financial Report for 2023 represent data filed by your government with OSC as reviewed and adjusted where necessary.

OSC Municipality Code 130470304160

1

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Balance Sheet

05/31/202305/31/202205/31/2021
Assets and Deferred Outflows
Assets
Cash and Cash Equivalents
200 - Cash$681,766.03$524,337.44$393,563.34
Total for Cash and Cash Equivalents$681,766.03$524,337.44$393,563.34
Restricted Cash and Cash Equivalents
230 - Cash Special Reserves$72,177.95$63,398.69$56,189.16
Total for Restricted Cash and Cash Equivalents$72,177.95$63,398.69$56,189.16
Net Other Receivables
380 - Accounts Receivable$7,769.00$0.00$2,487.00
Total for Net Other Receivables$7,769.00$0.00$2,487.00
Due From
391 - Due From Other Funds$144,845.00$144,844.79$79,700.36
440 - Due from Other Governments$76,803.23$76,107.40$102,652.76
sales tax, mortgage tax, town & school police
Total for Due From$221,648.23$220,952.19$182,353.12
Other Assets
480 - Prepaid Expenses$5,053.18$11,826.39$16,179.85
Total for Other Assets$5,053.18$11,826.39$16,179.85

OSC Municipality Code 130470304160

2

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Balance Sheet

05/31/202305/31/202205/31/2021
Total for Assets$988,414.39$820,514.71$650,772.47
Total for Assets and Deferred Outflows$988,414.39$820,514.71$650,772.47

OSC Municipality Code 130470304160

3

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Balance Sheet

05/31/202305/31/202205/31/2021
Liabilities, Deferred Inflows and Fund Balances
Liabilities
Payables
600 - Accounts Payable$85,455.38$151,191.96$86,778.09
601 - Accrued Liabilities$38,375.76$34,253.99$24,189.76
730 - Guaranty & Bid Deposits$7,834.79$13,123.09$14,764.54
Total for Payables$131,665.93$198,569.04$125,732.39
Payroll Liabilities
710 - Consolidated Payroll$13,270.37$16,796.54$15,603.84
Total for Payroll Liabilities$13,270.37$16,796.54$15,603.84
Due to
630 - Due To Other Funds$77,829.60$47,538.45$15,968.95
718 - State Retirement$137.38--
Total for Due to$77,966.98$47,538.45$15,968.95
Other Liabilities
688 - Other Liabilities$145,113.14$68,115.16-
ARPA
Total for Other Liabilities$145,113.14$68,115.16$0.00
Total for Liabilities$368,016.42$331,019.19$157,305.18
Fund Balance

OSC Municipality Code 130470304160

4

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Balance Sheet

05/31/202305/31/202205/31/2021
Nonspendable Fund Balance
806 - Not In Spendable Form$5,053.18$11,826.39$16,179.85
Total for Nonspendable Fund Balance$5,053.18$11,826.39$16,179.85
Restricted Fund Balance
815 - Unemployment Insurance Reserve$7,068.25$4,544.44$4,543.98
867 - Reserve for Employee Benefits and Accrued Liabilities$3,969.72$1,096.18$3,693.29
878 - Capital Reserve$61,139.98--
899 - Other Restricted Fund Balance-$57,758.07$47,951.89
Total for Restricted Fund Balance$72,177.95$63,398.69$56,189.16
Unassigned Fund Balance
917 - Unassigned Fund Balance$543,166.84$414,270.44$421,098.28
Total for Unassigned Fund Balance$543,166.84$414,270.44$421,098.28
Total for Fund Balance$620,397.97$489,495.52$493,467.29
Total for Liabilities, Deferred Inflows and Fund Balances$988,414.39$820,514.71$650,772.47

OSC Municipality Code 130470304160

5

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Results of Operations

05/31/202305/31/202205/31/2021
Revenues and Other Sources
Revenues
Property Taxes
1001 - Real Property Taxes$1,311,680.00$1,296,285.93$1,275,560.00
Total for Property Taxes$1,311,680.00$1,296,285.93$1,275,560.00
Property Tax Items
1081 - Other Payments In Lieu of Taxes$14,206.80$13,357.80$12,121.28
1090 - Interest and Penalties on Real Prop Taxes$6,473.53$4,099.64$45.35
Total for Property Tax Items$20,680.33$17,457.44$12,166.63
Non-Property Tax Items
1120 - Non Property Tax Distribution by County$189,156.94$176,946.94$140,298.76
1170 - Franchise Tax$42,202.21$39,396.72$41,383.03
Total for Non-Property Tax Items$231,359.15$216,343.66$181,681.79
Departmental Income
1255 - Clerk Fees$520.00$387.00$330.00
1289 - Other General Departmental Income$8,246.25$0.00$14,000.00
1520 - Police Fees$707.50$747.50$225.00
1689 - Other Health Departmental Income$9,360.43$15,847.90$15,570.70
2110 - Zoning Fees$35,769.85$27,448.75$27,556.60
2130 - Refuse and Garbage Charges$32,617.20$35,361.06$36,516.00
Total for Departmental Income$87,221.23$79,792.21$94,198.30

OSC Municipality Code 130470304160

6

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Results of Operations

05/31/202305/31/202205/31/2021
Intergovernmental Charges
2260 - Public Safety Services Other Governments$244,559.52$186,956.57$156,644.86
Police (Town of Red Hook & Village of Tivoli, RHCSD)
2262 - Fire Protection Services Other Governments$24,779.54$37,757.05$41,826.70
RH Fire Co
2389 - Miscellaneous Revenue Other Governments$641.92--
NYCOM Scholarship
Total for Intergovernmental Charges$269,980.98$224,713.62$198,471.56
Use of Money and Property
2401 - Interest and Earnings$2,549.98$88.65$129.13
2410 - Rental of Real Property$124,612.61$124,495.51$122,123.63
2414 - Rental of Equipment$250.00--
2440 - Rental Other$5,000.00--
Solar
Total for Use of Money and Property$132,412.59$124,584.16$122,252.76
Licenses and Permits
2590 - Permits Other-$10.00$25.00
Total for Licenses and Permits$0.00$10.00$25.00
Fines and Forfeitures
2610 - Fines and Forfeited Bail$40,772.50$32,327.00$33,029.00
2625 - Forfeiture of Crime Proceeds-$32.96-
Total for Fines and Forfeitures$40,772.50$32,359.96$33,029.00
Sales of Property and Compensation for Loss

OSC Municipality Code 130470304160

7

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Results of Operations

05/31/202305/31/202205/31/2021
2650 - Sales of Scrap and Excess Materials$4,014.60$21,848.95$4,832.75
2665 - Sales of Equipment$585.00--
2680 - Insurance Recoveries$12,427.23$16,291.37$21,073.79
Total for Sales of Property and Compensation for Loss$17,026.83$38,140.32$25,906.54
Other Revenues
2701 - Refunds of Prior Year Expenditures$112.44$1,407.67$2,034.69
2705 - Gifts and Donations-$276.00-
2706 - Grants From Local Governments-$17,881.00$0.00
2750 - AIM Related Payments$9,582.00$9,582.00$9,582.00
2770 - Unclassified$1,807.50--
OSC 3/29/23
Total for Other Revenues$11,501.94$29,146.67$11,616.69
State Aid
3001 - State Aid Revenue Sharing--$0.00
3005 - State Aid Mortgage Tax$25,061.00$18,625.04$19,511.76
3501 - State Aid Consolidated Highway Aid$146,768.21$36,040.80$60,495.17
Total for State Aid$171,829.21$54,665.84$80,006.93
Total for Revenues$2,294,464.76$2,113,499.81$2,034,915.20
Other Sources
Operating Transfers
5031 - Interfund Transfers-$65,000.00$65,000.00

OSC Municipality Code 130470304160

8

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Results of Operations

05/31/202305/31/202205/31/2021
Total for Operating Transfers$0.00$65,000.00$65,000.00
Proceeds of Obligations
5710 - Serial Bonds-$0.00-
Total for Proceeds of Obligations$0.00$0.00$0.00
Total for Other Sources$0.00$65,000.00$65,000.00
Total for Revenues and Other Sources$2,294,464.76$2,178,499.81$2,099,915.20

OSC Municipality Code 130470304160

9

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Results of Operations

05/31/202305/31/202205/31/2021
Expenditures and Other Uses
Expenditures
General Government Support
Legislative Board
10101 - Legislative Board - Personal Services$29,230.49$23,907.52$29,076.57
10104 - Legislative Board - Contractual$455.00$12.00-
Total for Legislative Board$29,685.49$23,919.52$29,076.57
Judicial
11101 - Municipal Court - Personal Services$47,997.28$46,109.77$47,200.69
11104 - Municipal Court - Contractual$9,127.59$7,232.47$7,162.47
Total for Judicial$57,124.87$53,342.24$54,363.16
Executive
12101 - Mayor - Personal Services$13,672.49$13,724.87$14,143.95
12104 - Mayor - Contractual$1,103.25$275.14$357.07
Total for Executive$14,775.74$14,000.01$14,501.02
Finance
13204 - Auditor - Contractual$10,000.00$2,800.00$5,038.25
13251 - Treasurer - Personal Services$28,949.63$14,542.82$9,623.60
13254 - Treasurer - Contractual$15,274.55-$51.01
Total for Finance$54,224.18$17,342.82$14,712.86

OSC Municipality Code 130470304160

10

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Results of Operations

05/31/202305/31/202205/31/2021
Municipal Staff
14101 - Clerk - Personal Services$25,294.67$37,409.06$39,635.58
14104 - Clerk - Contractual$20,314.96$22,707.66$30,415.12
14204 - Law - Contractual$43,974.06$30,690.25$28,746.32
14404 - Engineer - Contractual-$0.00$3,001.25
14501 - Elections - Personal Services$300.00$300.00-
14504 - Elections - Contractual$159.07$224.94$270.00
14804 - Public Information and Services - Contractual$11,111.40$11,084.90$10,935.00
Total for Municipal Staff$101,154.16$102,416.81$113,003.27
Shared Services
16204 - Operation of Plant - Contractual$71,197.06$60,383.14$56,575.84
16404 - Central Garage - Contractual$11,362.69$7,511.83$9,728.35
16704 - Central Printing and Mailing - Contractual$183.95--
16804 - Central Data Processing - Contractual$18,689.92$38,782.72$13,214.62
Total for Shared Services$101,433.62$106,677.69$79,518.81
Special Items
19104 - Unallocated Insurance - Contractual$49,994.84$39,766.75$39,689.55
19204 - Municipal Association Dues - Contractual$1,816.00$2,266.00$1,241.00
19894 - General Government Support, Other - Contractual$10,127.97$13,503.96$13,503.96
Cell Tower
Total for Special Items$61,938.81$55,536.71$54,434.51
Total for General Government Support$420,336.87$373,235.80$359,610.20

OSC Municipality Code 130470304160

11

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Results of Operations

05/31/202305/31/202205/31/2021
Public Safety
Law Enforcement
31201 - Police - Personal Services$484,144.18$414,686.38$387,005.13
31202 - Police - Equipment and Capital Outlay-$6,900.16$0.00
31204 - Police - Contractual$63,010.97$51,023.47$40,375.75
Total for Law Enforcement$547,155.15$472,610.01$427,380.88
Traffic Control
33101 - Traffic Control - Personal Services-$2,212.75$3,877.66
Total for Traffic Control$0.00$2,212.75$3,877.66
Fire Protection
34104 - Fire Protection - Contractual$120,305.00$117,153.55$87,815.34
Total for Fire Protection$120,305.00$117,153.55$87,815.34
Total for Public Safety$667,460.15$591,976.31$519,073.88
Transportation
Highway
51101 - Maintenance of Roads - Personal Services$138,761.42$165,912.59$135,907.69
51102 - Maintenance of Roads - Equipment and Capital Outlay$7,855.18$34,465.23$0.00
51104 - Maintenance of Roads - Contractual-$53,432.29$79,967.78
51122 - Permanent Improvements Highway - Equipment and$146,768.21$36,040.80$47,560.39
Capital Outlay
51124 - Permanent Improvements Highway - Contractual$66,194.98-$12,934.78

OSC Municipality Code 130470304160

12

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Results of Operations

05/31/202305/31/202205/31/2021
51404 - Brush And Weeds - Contractual$9,000.00$8,400.00-
51421 - Snow Removal - Personal Services$8,885.28$9,094.11$12,727.00
51424 - Snow Removal - Contractual$25,439.29$22,463.36$31,636.77
51824 - Street Lighting - Contractual$63,639.74$61,540.58$58,040.46
Total for Highway$466,544.10$391,348.96$378,774.87
Total for Transportation$466,544.10$391,348.96$378,774.87
Culture and Recreation
Recreation
71104 - Parks - Contractual$1,914.31$401.52$716.17
Total for Recreation$1,914.31$401.52$716.17
Culture
75504 - Celebrations - Contractual$5,566.95$2,540.07$1,669.35
76104 - Programs for the Aging - Contractual$1,500.00-$1,500.00
76204 - Adult Recreation - Contractual$2,000.00$1,000.00$1,000.00
79894 - Culture And Recreation, Other - Contractual$1,215.54$170.00-
Public Art Space
Total for Culture$10,282.49$3,710.07$4,169.35
Total for Culture and Recreation$12,196.80$4,111.59$4,885.52
Home and Community Services
General Environment
80101 - Zoning - Personal Services$65,049.88$70,627.86$71,815.23

OSC Municipality Code 130470304160

13

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Results of Operations

05/31/202305/31/202205/31/2021
80104 - Zoning - Contractual$2,118.50$19,619.60$9,158.62
Total for General Environment$67,168.38$90,247.46$80,973.85
Sanitation
81601 - Refuse and Garbage - Personal Services$17,673.96$16,337.91$16,494.71
81604 - Refuse and Garbage - Contractual$13,170.01$14,142.81$11,572.61
Total for Sanitation$30,843.97$30,480.72$28,067.32
Community Environment
85104 - Community Beautification - Contractual$6,749.22$3,208.69$1,994.94
85604 - Shade Trees - Contractual$12,859.90$8,900.00$14,200.00
Total for Community Environment$19,609.12$12,108.69$16,194.94
Community Development
86764 - Provisions for Public Services - Contractual$2,996.25--
Total for Community Development$2,996.25$0.00$0.00
Total for Home and Community Services$120,617.72$132,836.87$125,236.11
Employee Benefits
Employee Benefits
90108 - State Retirement System - Employee Benefits$27,599.52$48,274.16$48,130.34
90158 - Police Retirement - Employee Benefits$86,721.00$81,438.00$75,263.84
90308 - Social Security - Employee Benefits$65,699.49$61,223.83$57,801.33
90408 - Workers' Compensation - Employee Benefits$71,085.72$69,164.01$80,856.15

OSC Municipality Code 130470304160

14

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Results of Operations

05/31/202305/31/202205/31/2021
90458 - Life Insurance - Employee Benefits-$0.00$1,794.65
90558 - Disability Insurance - Employee Benefits$3,669.28--
90608 - Hospital, Medical and Dental Insurance - Employee$184,606.39$155,512.59$117,155.32
Benefits
90898 - Employee Benefits, Other (Specify) - Employee Benefits$10,995.00$11,316.23$4,635.72
losap
Total for Employee Benefits$450,376.40$426,928.82$385,637.35
Total for Employee Benefits$450,376.40$426,928.82$385,637.35
Debt Service
Debt Service
97106 - Serial Bonds - Debt Principal$23,144.07$245,144.09$249,108.20
97107 - Serial Bonds - Debt Interest$3,203.16$9,248.79$17,554.41
Total for Debt Service$26,347.23$254,392.88$266,662.61
Total for Debt Service$26,347.23$254,392.88$266,662.61
Total for Expenditures$2,163,879.27$2,174,831.23$2,039,880.54
Total for Expenditures and Other Uses$2,163,879.27$2,174,831.23$2,039,880.54

OSC Municipality Code 130470304160

15

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Changes in Fund Balance

05/31/202305/31/202205/31/2021
Analysis of Changes in Fund Balance
8021 - Fund Balance - Beginning of Year$489,495.52$493,467.19$437,399.05
8012 - Prior Period Adjustment OR Change in Accounting$316.96--
Principle - Increase in Fund Balance
Voided check done in prior period
8015 - Prior Period Adjustment OR Change in Accounting-$7,640.25$3,966.52
Principle - Decrease in Fund Balance
8022 - Restated Fund Balance - Beginning of Year$489,812.48$485,826.94$433,432.53
Add Revenues and Other Sources$2,294,464.76$2,178,499.81$2,099,915.20
Deduct Expenditures and Other Uses$2,163,879.27$2,174,831.23$2,039,880.54
8029 - Fund Balance - End of Year$620,397.97$489,495.52$493,467.19

OSC Municipality Code 130470304160

16

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Adopted Budget Summary

05/31/202405/31/202305/31/2022
Estimated Revenues and Other Sources
Estimated Revenue
1049 - Est Rev - Property Taxes$1,369,370.00$1,311,680.00$1,291,680.00
1099 - Est Rev - Property Tax Items$18,100.00$17,100.00$17,600.00
1199 - Est Rev - Non-Property Tax Items$173,000.00$140,000.00$109,500.00
2399 - Est Rev - Intergovernmental Charges$369,850.00$395,050.00$404,500.00
2499 - Est Rev - Use of Money and Property$131,000.00$125,750.00$135,600.00
2649 - Est Rev - Fines and Forfeitures$41,900.00$42,000.00$48,500.00
2699 - Est Rev - Sales of Property and Compensation for Loss$4,500.00$7,000.00$5,000.00
2799 - Est Rev - Other Revenues$79,600.00$1,000.00$1,000.00
2801 - Est Rev - Interfund Revenues--$65,000.00
3099 - Est Rev - State Aid-$123,500.00$123,100.00
Total for Estimated Revenue$2,187,320.00$2,163,080.00$2,201,480.00
Total for Estimated Revenues and Other Sources$2,187,320.00$2,163,080.00$2,201,480.00

OSC Municipality Code 130470304160

17

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

A - General Adopted Budget Summary

05/31/202405/31/202305/31/2022
Estimated Appropriations and Other Uses
Estimated Appropriations
1999 - App - General Government Support$438,020.00$488,950.00$387,400.00
2999 - App - Education$17,000.00$14,000.00$16,000.00
3999 - App - Public Safety$682,183.70$602,795.00$553,000.00
5999 - App - Transportation$394,500.00$424,900.00$403,300.00
7999 - App - Culture and Recreation$12,800.00$10,500.00$8,500.00
8999 - App - Home and Community Services$154,400.00$129,225.00$111,750.00
9199 - App - Employee Benefits$456,500.00$465,000.00$458,350.00
9899 - App - Debt Service$19,416.30$27,710.00$263,180.00
Total for Estimated Appropriations$2,174,820.00$2,163,080.00$2,201,480.00
Estimated Other Uses
962 - Other Budgetary Purposes$12,500.00--
Total for Estimated Other Uses$12,500.00$0.00$0.00
Total for Estimated Appropriations and Other Uses$2,187,320.00$2,163,080.00$2,201,480.00

OSC Municipality Code 130470304160

18

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

ES - Enterprise Sewer Statement of Net Position

05/31/202305/31/202205/31/2021
Assets and Deferred Outflows
Assets
Current Assets
Cash and Cash Equivalents
200 - Cash$55,779.11$3,395.72$29,148.54
Total for Cash and Cash Equivalents$55,779.11$3,395.72$29,148.54
Net Other Receivables
380 - Accounts Receivable$66,855.85--
Total for Net Other Receivables$66,855.85$0.00$0.00
Due From
391 - Due From Other Funds$23,830.21--
Total for Due From$23,830.21$0.00$0.00
Total for Current Assets$146,465.17$3,395.72$29,148.54
Non-Current Assets
Non-Depreciable Capital Assets
105 - Construction Work In Progress$7,743,831.01$1,609,964.56$746,582.72
Total for Non-Depreciable Capital Assets$7,743,831.01$1,609,964.56$746,582.72
Total for Non-Current Assets$7,743,831.01$1,609,964.56$746,582.72

OSC Municipality Code 130470304160

19

Village of Red Hook Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

ES - Enterprise Sewer Statement of Net Position

05/31/202305/31/202205/31/2021
Total for Assets$7,890,296.18$1,613,360.28$775,731.26
Total for Assets and Deferred Outflows$7,890,296.18$1,613,360.28$775,731.26

OSC Municipality Code 130470304160

20

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

ES - Enterprise Sewer Statement of Net Position

05/31/202305/31/202205/31/2021
Liabilities, Deferred Inflows and Net Position
Liabilities
Current Liabilities
Payables
600 - Accounts Payable$443,869.18$393,759.34$27,898.90
Total for Payables$443,869.18$393,759.34$27,898.90
Total for Current Liabilities$443,869.18$393,759.34$27,898.90
Long-Term Obligations
Notes Payable
626 - Bond Anticipation Notes Payable$6,770,617.73$690,634.24$165,342.79
Total for Notes Payable$6,770,617.73$690,634.24$165,342.79
Total for Long-Term Obligations$6,770,617.73$690,634.24$165,342.79
Total for Liabilities$7,214,486.91$1,084,393.58$193,241.69
Net Position
Restricted Net Position
920 - Net Assets Invested in Capital Assets Net of Related Debt$973,213.28$1,609,964.56$578,239.43
Total for Restricted Net Position$973,213.28$1,609,964.56$578,239.43

OSC Municipality Code 130470304160

21

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

ES - Enterprise Sewer Statement of Net Position

05/31/202305/31/202205/31/2021
Unrestricted Net Position
924 - Net Assets Unrestricted Deficit($297,404.01)($1,080,997.86)$4,250.14
Total for Unrestricted Net Position($297,404.01)($1,080,997.86)$4,250.14
Total for Net Position$675,809.27$528,966.70$582,489.57
Total for Liabilities, Deferred Inflows and Net Position$7,890,296.18$1,613,360.28$775,731.26

OSC Municipality Code 130470304160

22

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

ES - Enterprise Sewer Results of Operations

05/31/202305/31/202205/31/2021
Revenues and Other Sources
Revenues
Property Taxes
1030 - Special Assessments$12,000.00$3,000.00-
Total for Property Taxes$12,000.00$3,000.00$0.00
Departmental Income
2120 - Sewer Rents$15,617.96--
2122 - Sewer Charges$140,724.61$0.00-
2128 - Interest and Penalties on Sewer Accounts$481.86--
Total for Departmental Income$156,824.43$0.00$0.00
Total for Revenues$168,824.43$3,000.00$0.00
Other Sources
Operating Transfers
5031 - Interfund Transfers$44,468.45$23,000.00$25,000.00
Total for Operating Transfers$44,468.45$23,000.00$25,000.00
Total for Other Sources$44,468.45$23,000.00$25,000.00
Total for Revenues and Other Sources$213,292.88$26,000.00$25,000.00

OSC Municipality Code 130470304160

23

Village of Red Hook Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

ES - Enterprise Sewer Results of Operations

05/31/202305/31/202205/31/2021
Expenditures and Other Uses
Expenditures
General Government Support
Self Insurance
17104 - Self Insurance, Administration - Contractual--$0.00
Total for Self Insurance$0.00$0.00$0.00
Special Items
19504 - Taxes and Assessments on Municipal Property -$263.99--
Contractual
Total for Special Items$263.99$0.00$0.00
Total for General Government Support$263.99$0.00$0.00
Home and Community Services
Sewage
81201 - Sanitary Sewers - Personal Services-$21,508.99-
81204 - Sanitary Sewers - Contractual$52,755.93$13,128.09$42,704.89
81304 - Sewage Treatment and Disposal - Contractual$3,930.89$2,274.00-
Total for Sewage$56,686.82$36,911.08$42,704.89
Total for Home and Community Services$56,686.82$36,911.08$42,704.89
Debt Service

OSC Municipality Code 130470304160

24

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

ES - Enterprise Sewer Results of Operations

05/31/202305/31/202205/31/2021
Debt Service
97107 - Serial Bonds - Debt Interest$9,500.00$3,500.00$0.00
Total for Debt Service$9,500.00$3,500.00$0.00
Total for Debt Service$9,500.00$3,500.00$0.00
Total for Expenditures$66,450.81$40,411.08$42,704.89
Total for Expenditures and Other Uses$66,450.81$40,411.08$42,704.89

OSC Municipality Code 130470304160

25

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

ES - Enterprise Sewer Changes in Net Position

05/31/202305/31/202205/31/2021
Analysis of Changes in Net Position
8021 - Net Position - Beginning of Year$528,966.70$582,490.17$600,195.06
8012 - Prior Period Adjustment OR Change in Accounting-$0.00-
Principle - Increase in Net Position
8015 - Prior Period Adjustment OR Change in Accounting-$39,112.39-
Principle - Decrease in Net Position
8022 - Restated Net Position - Beginning of Year$528,966.70$543,377.78$600,195.06
Add Revenues and Other Sources$213,292.88$26,000.00$25,000.00
Deduct Expenditures and Other Uses$66,450.81$40,411.08$42,704.89
8029 - Net Position - End of Year$675,808.77$528,966.70$582,490.17

OSC Municipality Code 130470304160

26

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

ES - Enterprise Sewer Adopted Budget Summary

05/31/202405/31/202305/31/2022
Estimated Revenues and Other Sources
Estimated Revenue
2199 - Est Rev - Departmental Income$315,965.00--
Total for Estimated Revenue$315,965.00$0.00$0.00
Estimated Other Sources
5099 - Est Rev - Operating Transfers$25,000.00--
Total for Estimated Other Sources$25,000.00$0.00$0.00
Total for Estimated Revenues and Other Sources$340,965.00$0.00$0.00

OSC Municipality Code 130470304160

27

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

ES - Enterprise Sewer Adopted Budget Summary

05/31/202405/31/202305/31/2022
Estimated Appropriations and Other Uses
Estimated Appropriations
1999 - App - General Government Support$41,500.00--
8999 - App - Home and Community Services$299,465.00--
Total for Estimated Appropriations$340,965.00$0.00$0.00
Total for Estimated Appropriations and Other Uses$340,965.00$0.00$0.00

OSC Municipality Code 130470304160

28

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

EW - Enterprise Water Statement of Net Position

05/31/202305/31/202205/31/2021
Assets and Deferred Outflows
Assets
Current Assets
Cash and Cash Equivalents
200 - Cash$323,405.45$200,977.20$172,318.74
Total for Cash and Cash Equivalents$323,405.45$200,977.20$172,318.74
Restricted Cash and Cash Equivalents
230 - Cash Special Reserves$152,558.24$151,762.80$151,731.58
Total for Restricted Cash and Cash Equivalents$152,558.24$151,762.80$151,731.58
Net Other Receivables
380 - Accounts Receivable$98,353.22$96,727.40$94,594.86
Total for Net Other Receivables$98,353.22$96,727.40$94,594.86
Due From
391 - Due From Other Funds$71,772.29$47,393.66$15,969.10
Total for Due From$71,772.29$47,393.66$15,969.10
Total for Current Assets$646,089.20$496,861.06$434,614.28
Non-Current Assets
Non-Depreciable Capital Assets

OSC Municipality Code 130470304160

29

Village of Red Hook Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

EW - Enterprise Water Statement of Net Position

05/31/202305/31/202205/31/2021
105 - Construction Work In Progress$3,950,203.00$3,950,203.00$3,950,203.00
Total for Non-Depreciable Capital Assets$3,950,203.00$3,950,203.00$3,950,203.00
Depreciable Capital Assets
104 - Machinery and Equipment$4,801,285.00$16,748.00$16,915.00
106 - Infrastructure$15,498.00$5,114,580.00$5,427,885.00
Total for Depreciable Capital Assets$4,816,783.00$5,131,328.00$5,444,800.00
Total for Non-Current Assets$8,766,986.00$9,081,531.00$9,395,003.00
Total for Assets$9,413,075.20$9,578,392.06$9,829,617.28
Deferred Outflows
Deferred Outflows of Resources
496 - Deferred Outflow of Resources Pensions$193,831.00$7,848.00$7,848.00
Total for Deferred Outflows of Resources$193,831.00$7,848.00$7,848.00
Total for Deferred Outflows$193,831.00$7,848.00$7,848.00
Total for Assets and Deferred Outflows$9,606,906.20$9,586,240.06$9,837,465.28

OSC Municipality Code 130470304160

30

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

EW - Enterprise Water Statement of Net Position

05/31/202305/31/202205/31/2021
Liabilities, Deferred Inflows and Net Position
Liabilities
Current Liabilities
Payables
600 - Accounts Payable$46,994.58$18,719.20$55,540.90
601 - Accrued Liabilities$576.67$259.78($1,959.09)
Total for Payables$47,571.25$18,978.98$53,581.81
Due to
630 - Due To Other Funds$162,617.69$144,700.00$79,700.00
Total for Due to$162,617.69$144,700.00$79,700.00
Total for Current Liabilities$210,188.94$163,678.98$133,281.81
Long-Term Obligations
Other Long-Term Obligations
638 - Net Pension Liability Proportionate Share$193,831.00$2,944.00$2,944.00
683 - Other Post Employment Benefits$42,231.00$42,231.00$42,231.00
Total for Other Long-Term Obligations$236,062.00$45,175.00$45,175.00
Debt Obligations
628 - Bonds Payable$2,396,000.00$2,442,000.00$2,444,000.00
Total for Debt Obligations$2,396,000.00$2,442,000.00$2,444,000.00

OSC Municipality Code 130470304160

31

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

EW - Enterprise Water Statement of Net Position

05/31/202305/31/202205/31/2021
Total for Long-Term Obligations$2,632,062.00$2,487,175.00$2,489,175.00
Total for Liabilities$2,842,250.94$2,650,853.98$2,622,456.81
Deferred Inflows
Deferred Inflows of Resources
697 - Deferred Inflow of Resources Pensions$4,726.00$9,630.00$9,630.00
Total for Deferred Inflows of Resources$4,726.00$9,630.00$9,630.00
Total for Deferred Inflows$4,726.00$9,630.00$9,630.00
Net Position
Restricted Net Position
920 - Net Assets Invested in Capital Assets Net of Related Debt$6,370,986.00$6,639,642.67$6,951,003.00
921 - Net Assets Restricted for Capital Projects$152,558.24$151,731.58$151,731.58
Total for Restricted Net Position$6,523,544.24$6,791,374.25$7,102,734.58
Unrestricted Net Position
924 - Net Assets Unrestricted Deficit$236,382.02$134,381.83$102,643.89
Total for Unrestricted Net Position$236,382.02$134,381.83$102,643.89
Total for Net Position$6,759,926.26$6,925,756.08$7,205,378.47
Total for Liabilities, Deferred Inflows and Net Position$9,606,903.20$9,586,240.06$9,837,465.28

OSC Municipality Code 130470304160

32

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

EW - Enterprise Water Results of Operations

05/31/202305/31/202205/31/2021
Revenues and Other Sources
Revenues
Departmental Income
2140 - Metered Water Sales$574,205.80$550,563.19$530,939.29
2142 - Unmetered Water Sales$1,945.65$1,600.00$2,252.67
2144 - Water Service Charges$5,000.00$2,500.00$21,607.98
2148 - Interest and Penalties on Water Rents$5,960.71$2,249.60$3,856.43
Total for Departmental Income$587,112.16$556,912.79$558,656.37
Use of Money and Property
2401 - Interest and Earnings$1,478.33$48.09$170.14
Total for Use of Money and Property$1,478.33$48.09$170.14
Federal Aid
4989 - Federal Aid Other Home and Community Services$23,053.00--
Total for Federal Aid$23,053.00$0.00$0.00
Total for Revenues$611,643.49$556,960.88$558,826.51
Total for Revenues and Other Sources$611,643.49$556,960.88$558,826.51

OSC Municipality Code 130470304160

33

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

EW - Enterprise Water Results of Operations

05/31/202305/31/202205/31/2021
Expenditures and Other Uses
Expenditures
General Government Support
Special Items
19104 - Unallocated Insurance - Contractual$26,500.00$25,500.00$24,800.00
19944 - Depreciation - Contractual$314,545.00$313,305.00$313,472.00
Total for Special Items$341,045.00$338,805.00$338,272.00
Total for General Government Support$341,045.00$338,805.00$338,272.00
Home and Community Services
Water
83101 - Water Administration - Personal Services$51,475.70$53,388.35$44,835.71
83104 - Water Administration - Contractual$34,543.89$32,563.31$18,167.40
83108 - Water Administration - Employee Benefits$57,847.56$56,078.76$50,838.71
83204 - Water Source of Supply, Power and Pumping -$124,958.82$134,657.75$149,407.81
Contractual
83304 - Water Purification - Contractual$43,580.45$21,698.00$4,844.26
83404 - Water Transportation and Distribution - Contractual$14,560.00--
Total for Water$326,966.42$298,386.17$268,093.89
Total for Home and Community Services$326,966.42$298,386.17$268,093.89
Debt Service

OSC Municipality Code 130470304160

34

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

EW - Enterprise Water Results of Operations

05/31/202305/31/202205/31/2021
Debt Service
97107 - Serial Bonds - Debt Interest$64,949.53$65,836.23$63,218.71
Total for Debt Service$64,949.53$65,836.23$63,218.71
Total for Debt Service$64,949.53$65,836.23$63,218.71
Total for Expenditures$732,960.95$703,027.40$669,584.60
Other Uses
Interfund Transfers
Interfund Transfers
99019 - Transfers to Other Funds - Interfund Transfer$44,468.45$88,000.00$90,000.00
To sewer
Total for Interfund Transfers$44,468.45$88,000.00$90,000.00
Total for Interfund Transfers$44,468.45$88,000.00$90,000.00
Total for Other Uses$44,468.45$88,000.00$90,000.00
Total for Expenditures and Other Uses$777,429.40$791,027.40$759,584.60

OSC Municipality Code 130470304160

35

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

EW - Enterprise Water Changes in Net Position

05/31/202305/31/202205/31/2021
Analysis of Changes in Net Position
8021 - Net Position - Beginning of Year$6,925,754.56$7,205,379.00$7,431,475.23
8015 - Prior Period Adjustment OR Change in Accounting-$45,557.92$25,339.53
Principle - Decrease in Net Position
8022 - Restated Net Position - Beginning of Year$6,925,754.56$7,159,821.08$7,406,135.70
Add Revenues and Other Sources$611,643.49$556,960.88$558,826.51
Deduct Expenditures and Other Uses$777,429.40$791,027.40$759,584.60
8029 - Net Position - End of Year$6,759,968.65$6,925,754.56$7,205,379.00

OSC Municipality Code 130470304160

36

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

EW - Enterprise Water Adopted Budget Summary

05/31/202405/31/202305/31/2022
Estimated Revenues and Other Sources
Estimated Revenue
2199 - Est Rev - Departmental Income$556,000.00--
2499 - Est Rev - Use of Money and Property$100.00--
Total for Estimated Revenue$556,100.00$0.00$0.00
Total for Estimated Revenues and Other Sources$556,100.00$0.00$0.00

OSC Municipality Code 130470304160

37

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

EW - Enterprise Water Adopted Budget Summary

05/31/202405/31/202305/31/2022
Estimated Appropriations and Other Uses
Estimated Appropriations
1999 - App - General Government Support$38,280.00--
8999 - App - Home and Community Services$271,789.75--
9199 - App - Employee Benefits$84,500.00--
Total for Estimated Appropriations$394,569.75$0.00$0.00
Estimated Other Uses
9899 - App - Debt Service$136,530.25--
9999 - App - Interfund Transfers$25,000.00--
Total for Estimated Other Uses$161,530.25$0.00$0.00
Total for Estimated Appropriations and Other Uses$556,100.00$0.00$0.00

OSC Municipality Code 130470304160

38

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

H - Capital Projects Balance Sheet

05/31/202305/31/202205/31/2021
Assets and Deferred Outflows
Total for Assets and Deferred Outflows$0.00$0.00$0.00

OSC Municipality Code 130470304160

39

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

H - Capital Projects Balance Sheet

05/31/202305/31/202205/31/2021
Liabilities, Deferred Inflows and Fund Balances
Total for Liabilities, Deferred Inflows and Fund Balances$0.00$0.00$0.00

OSC Municipality Code 130470304160

40

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

H - Capital Projects Results of Operations

05/31/202305/31/202205/31/2021
Revenues and Other Sources
Other Sources
Proceeds of Obligations
5710 - Serial Bonds-$40,000.00-
Total for Proceeds of Obligations$0.00$40,000.00$0.00
Total for Other Sources$0.00$40,000.00$0.00
Total for Revenues and Other Sources$0.00$40,000.00$0.00

OSC Municipality Code 130470304160

41

Village of Red Hook Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

H - Capital Projects Results of Operations

05/31/202305/31/202205/31/2021
Expenditures and Other Uses
Expenditures
Public Safety
Law Enforcement
31202 - Police - Equipment and Capital Outlay-$40,000.00-
Total for Law Enforcement$0.00$40,000.00$0.00
Total for Public Safety$0.00$40,000.00$0.00
Total for Expenditures$0.00$40,000.00$0.00
Total for Expenditures and Other Uses$0.00$40,000.00$0.00

OSC Municipality Code 130470304160

42

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

H - Capital Projects Changes in Fund Balance

05/31/202305/31/202205/31/2021
Analysis of Changes in Fund Balance
8021 - Fund Balance - Beginning of Year$0.00$0.00$0.00
8022 - Restated Fund Balance - Beginning of Year$0.00$0.00-
Add Revenues and Other Sources$0.00$40,000.00$0.00
Deduct Expenditures and Other Uses$0.00$40,000.00$0.00
8029 - Fund Balance - End of Year$0.00$0.00$0.00

OSC Municipality Code 130470304160

43

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

TE - Private Purpose Trust Statement of Net Position

05/31/202305/31/202205/31/2021
Assets and Deferred Outflows
Assets
Cash and Cash Equivalents
200 - Cash$16,254.60$15,594.57$6,603.77
Total for Cash and Cash Equivalents$16,254.60$15,594.57$6,603.77
Total for Assets$16,254.60$15,594.57$6,603.77
Total for Assets and Deferred Outflows$16,254.60$15,594.57$6,603.77

OSC Municipality Code 130470304160

44

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

TE - Private Purpose Trust Statement of Net Position

05/31/202305/31/202205/31/2021
Liabilities, Deferred Inflows and Net Position
Net Position
Restricted Net Position
923 - Net Assets Restricted for Other Purposes$16,254.60$15,594.57$6,603.77
Village Green & Hardscrabble
Total for Restricted Net Position$16,254.60$15,594.57$6,603.77
Total for Net Position$16,254.60$15,594.57$6,603.77
Total for Liabilities, Deferred Inflows and Net Position$16,254.60$15,594.57$6,603.77

OSC Municipality Code 130470304160

45

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

TE - Private Purpose Trust Results of Operations

05/31/202305/31/202205/31/2021
Revenues and Other Sources
Revenues
Miscellaneous
2705 - Gifts and Donations$2,900.08$25,523.35-
Total for Miscellaneous$2,900.08$25,523.35$0.00
Total for Revenues$2,900.08$25,523.35$0.00
Total for Revenues and Other Sources$2,900.08$25,523.35$0.00

OSC Municipality Code 130470304160

46

Village of Red Hook Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

TE - Private Purpose Trust Results of Operations

05/31/202305/31/202205/31/2021
Expenditures and Other Uses
Expenditures
General Government Support
Special Items
19454 - Other Private-Purpose Activities - Contractual$2,240.05$16,532.55-
Hard Scrabble
Total for Special Items$2,240.05$16,532.55$0.00
Total for General Government Support$2,240.05$16,532.55$0.00
Total for Expenditures$2,240.05$16,532.55$0.00
Total for Expenditures and Other Uses$2,240.05$16,532.55$0.00

OSC Municipality Code 130470304160

47

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

TE - Private Purpose Trust Changes in Net Position

05/31/202305/31/202205/31/2021
Analysis of Changes in Net Position
8021 - Net Position - Beginning of Year$15,594.57$6,603.77$0.00
8012 - Prior Period Adjustment OR Change in Accounting--$6,603.77
Principle - Increase in Net Position
8022 - Restated Net Position - Beginning of Year$15,594.57$6,603.77$6,603.77
Add Revenues and Other Sources$2,900.08$25,523.35$0.00
Deduct Expenditures and Other Uses$2,240.05$16,532.55$0.00
8029 - Net Position - End of Year$16,254.60$15,594.57$6,603.77

OSC Municipality Code 130470304160

48

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

K - General Fixed Assets Schedule of Non-Current Government Assets

05/31/202305/31/202205/31/2021
Non-Current Assets
Depreciable Capital Assets
102 - Buildings$1,356,690.00$1,421,233.00$2,663,300.00
104 - Machinery and Equipment$1,043,880.00$1,050,800.00$769,799.00
106 - Infrastructure$6,976,393.00$6,976,393.00$12,829,420.60
Total for Depreciable Capital Assets$9,376,963.00$9,448,426.00$16,262,519.60
Accumulated Depreciation
112 - Accumulated Depreciation Buildings($1,306,610.00)($1,242,068.00)($754,612.00)
114 - Accumulated Depreciation Machinery and Equipment($1,142,875.00)($1,135,955.00)($773,670.00)
116 - Accumulated Depreciation Infrastructure($5,786,861.00)($5,786,861.00)($6,951,621.00)
Total for Accumulated Depreciation($8,236,346.00)($8,164,884.00)($8,479,903.00)
Other Non-Current Assets
108 - Net Pension Asset Proportionate Share$73,748.00$74,369.00-
Total for Other Non-Current Assets$73,748.00$74,369.00$0.00
Total for Non-Current Assets$1,214,365.00$1,357,911.00$7,782,616.60

OSC Municipality Code 130470304160

49

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

W - General Long Term Debt Schedule of Non-Current Government Liabilities

05/31/202305/31/202205/31/2021
Long-Term Obligations
Debt Obligations
628 - Bonds Payable$28,927.50$47,812.50$298,990.00
Total for Debt Obligations$28,927.50$47,812.50$298,990.00
Other Long-Term Obligations
638 - Net Pension Liability Proportionate Share$73,748.00$70,804.00$240,699.00
687 - Compensated Absences$33,363.34$173,572.99$148,308.00
Total for Other Long-Term Obligations$107,111.34$244,376.99$389,007.00
Total for Long-Term Obligations$136,038.84$292,189.49$687,997.00

OSC Municipality Code 130470304160

50

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

Supplemental Schedules

The Supplemental Schedules includes the following schedules:

  • Statement of Indebtedness

  • Bond Repayment

  • Bank Reconciliation

  • Employee and Retiree Benefits

OSC Municipality Code 130470304160

51

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

Statement of Indebtedness Debt Summary

|Debt Type|Beginning Balance|Debt Issued|Principal Paid|Paid From debt Proceeds|Accreted Interest|Prior Year Adjustment|Ending Balance| |---|---|---|---|---|---|---|---| |Bond|$0.00|$0.00|$71,144.07|$0.00|$0.00|$2,496,071.57|$2,424,927.50| |Bond Anticipation Note|$0.00|$6,079,983.49|$0.00|$0.00|$0.00|$690,634.24|$6,770,617.73| |Total|$0.00|$6,079,983.49|$71,144.07|$0.00|$0.00|$3,186,705.81|$9,195,545.23|

OSC Municipality Code 130470304160

52

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

Statement of Indebtedness Debt Records

|Debt Type/ Purpose|Lender Name|Issue Date|Maturity Date|Beginning Balance|Debt Issued|Principal Paid|Paid From Debt Proceeds|Prior Year Adjustment|Accreted Interest|Ending Balance| |---|---|---|---|---|---|---|---|---|---|---| |Bond Backhoe||1/31/17|1/31/23|$0.00|$0.00|$6,258.57|$0.00|$6,258.57|$0.00|$0.00| |Bond Snowplow||12/12/17|12/12/27|$0.00|$0.00|$8,885.50|$0.00|$53,313.00|$0.00|$44,427.50| |Bond Police Truck||6/14/21|6/14/26|$0.00|$0.00|$8,000.00|$0.00|$40,000.00|$0.00|$32,000.00| |Bond Water System|USDA|9/24/14|5/31/53|$0.00|$0.00|$24,000.00|$0.00|$1,023,000.00|$0.00|$999,000.00| |Bond Water Phase 2|USDA|8/22/18|5/31/68|$0.00|$0.00|$24,000.00|$0.00|$1,373,500.00|$0.00|$1,349,500.00| |Bond Anticipation Note Sewer System|EFC|3/23/22|9/11/23|$0.00|$6,079,983.49|$0.00|$0.00|$690,634.24|$0.00|$6,770,617.73|

OSC Municipality Code 130470304160

53

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

Bond Repayment

Fiscal Year EndingBond Principal DueBond Interest DueTotal DueRemaining Principal Balance
2024$67,885.50$62,322.05$130,207.55$2,357,042.00
2025$69,385.50$60,492.85$129,878.35$2,287,656.50
2026$70,385.50$58,888.38$129,273.88$2,217,271.00
2027$72,385.50$49,192.49$121,577.99$2,144,885.50
2028$64,885.50$55,575.31$120,460.81$2,080,000.00
2029$58,000.00$54,126.88$112,126.88$2,022,000.00
2030$59,000.00$52,645.18$111,645.18$1,963,000.00
2031$61,000.00$51,112.05$112,112.05$1,902,000.00
2032$62,000.00$49,557.50$111,557.50$1,840,000.00
2033$64,000.00$47,951.88$111,951.88$1,776,000.00
2034$66,000.00$46,295.01$112,295.01$1,710,000.00
2035$67,500.00$44,596.88$112,096.88$1,642,500.00
2036$69,500.00$42,849.69$112,349.69$1,573,000.00

OSC Municipality Code 130470304160

54

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

Fiscal Year EndingBond Principal DueBond Interest DueTotal DueRemaining Principal Balance
2037$70,500.00$41,053.44$111,553.44$1,502,500.00
2038$73,000.00$39,865.94$112,865.94$1,429,500.00
2039$75,000.00$37,319.38$112,319.38$1,354,500.00
2040$76,500.00$35,373.75$111,873.75$1,278,000.00
2041$79,000.00$33,379.06$112,379.06$1,199,000.00
2042$82,000.00$30,587.50$112,587.50$1,117,000.00
2043$83,500.00$29,478.76$112,978.76$1,033,500.00
2044$86,000.00$26,277.19$112,277.19$947,500.00
2045$88,500.00$24,030.62$112,530.62$859,000.00
2046$91,000.00$21,717.19$112,717.19$768,000.00
2047$93,000.00$19,346.88$112,346.88$675,000.00
2048$95,500.00$16,911.88$112,411.88$579,500.00
2049$98,000.00$12,585.62$110,585.62$481,500.00
2050$101,000.00$10,044.30$111,044.30$380,500.00

OSC Municipality Code 130470304160

55

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

Fiscal Year EndingBond Principal DueBond Interest DueTotal DueRemaining Principal Balance
2051$104,000.00$7,083.62$111,083.62$276,500.00
2052$86,500.00$6,890.62$93,390.62$190,000.00
2053$61,500.00$4,992.21$66,492.21$128,500.00
2054$63,500.00$3,039.07$66,539.07$65,000.00
2055$65,000.00$1,023.44$66,023.44$0.00
2056$0.00$0.00$0.00$0.00
2057$0.00$0.00$0.00$0.00
2058$0.00$0.00$0.00$0.00
2059$0.00$0.00$0.00$0.00
2060$0.00$0.00$0.00$0.00
2061$0.00$0.00$0.00$0.00
2062$0.00$0.00$0.00$0.00
2063$0.00$0.00$0.00$0.00
2064$0.00$0.00$0.00$0.00

OSC Municipality Code 130470304160

56

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

Fiscal Year EndingBond Principal DueBond Interest DueTotal DueRemaining Principal Balance
2065$0.00$0.00$0.00$0.00
2066$0.00$0.00$0.00$0.00
2067$0.00$0.00$0.00$0.00
2068$0.00$0.00$0.00$0.00
Total$2,424,927.50$1,076,606.62$3,501,534.12
$2,424,927.50 Total Bond Ending Balance for Statement of Indebtedness.

OSC Municipality Code 130470304160

57

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

Bank Reconciliation

Accounts

Account No.Account TypeAssociated Fund(s)Bank BalanceDeposits In TransitOutstanding ChecksAdjustmentsTotal
3874CheckingA$7,834.79$0.00$0.00$0.00$7,834.79
182CheckingA$3,969.72$0.00$0.00$0.00$3,969.72
410CheckingEW$326,359.54$102.94($3,057.03)$0.00$323,405.45
1088CheckingES$58,254.11$0.00($2,475.00)$0.00$55,779.11
5772CheckingTE$8,580.60$0.00$0.00$0.00$8,580.60
493CheckingTE$7,674.32$0.00$0.00$0.00$7,674.32
3258SavingsEW$17,805.46$0.00$0.00$0.00$17,805.46
3943SavingsEW$134,752.78$0.00$0.00$0.00$134,752.78
399CheckingA$35,383.03$0.00($1,046.98)$0.00$34,336.05
366CheckingA$657,056.29$0.00($17,461.10)$0.00$639,595.19
4066SavingsA$5,060.34$2,500.00$0.00$0.00$7,560.34
3938SavingsA$14,663.45$2,500.00$0.00$0.00$17,163.45

OSC Municipality Code 130470304160

58

Village of Red Hook

Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

AccountsAccountsAccountsAccountsAccountsAccountsAccountsAccounts
Account No.Account TypeAssociated Fund(s)Bank BalanceDeposits In TransitOutstanding ChecksAdjustmentsTotal
4058SavingsA$26,325.51$2,500.00$0.00$0.00$28,825.51
3844SavingsA$3,296.89$0.00$0.00$0.00$3,296.89
3422SavingsA$3,316.11$0.00$0.00$0.00$3,316.11
3406SavingsA$4,568.25$2,500.00$0.00$0.00$7,068.25
3399SavingsA$977.68$0.00$0.00$0.00$977.68
Total$1,315,878.87$10,102.94($24,040.11)$0.00$1,301,941.70
$1,301,941.38
Total Cash From Financials

OSC Municipality Code 130470304160

59

Village of Red Hook Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

Bank Reconciliation

Collateralization of Cash

Investments and Collateralization of Investments

Collateralization of Cash
Total Bank Balance$1,315,878.87
FDIC Insurance$500,000.00
Collateralized with Securities held in possession of the
municipality or its agent or otherwise secured$1,718,563.00
Total of FDIC Insurance and Collateralized with
securities held in possession of the municipality or its
agent or otherwise secured$2,218,563.00
Investments and Collateralization of Investments
Investments From Financials$0.00
Market Value as of Fiscal Year End Date$0.00
Collateralized with Securities held in possession of the
municipality or its agent or otherwise secured$0.00

OSC Municipality Code 130470304160

60

Village of Red Hook Annual Financial Report

For the Fiscal Period 06/01/2022 - 05/31/2023

Employee and Retiree Benefits

Total Number

Full Time EmployeesPart Time EmployeesPart Time EmployeesVolunteers with Paid BenefitsVolunteers with Paid BenefitsVolunteers with Paid BenefitsRetirees with Paid BenefitsRetirees with Paid BenefitsRetirees with Paid Benefits
9172
Number Receving Benefits
BenefitAmountFull TimePart TimeVolunteerRetiree
State Retirement System$27,599.526
Police Retirement$86,721.0036
Fire Retirement
Local Pension Fund
Social Security$65,699.49917
Worker's Compensation$71,085.72917
Life Insurance
Unemployment Insurance
Disability Insurance$3,669.28000
Hospital, Medical and Dental Insurance$184,606.39602
Union Welfare Benefits
Supplemental Benefit Payments to Disabled Firefighters
Employee Benefits,Other$10,995.00000
Total Employee Benefits Paid
$450,376.40

OSC Municipality Code 130470304160

61