Loading...
HomeMy WebLinkAbout2019-11 Financial ReportTOWN OF ITHACA FINANCIAL REPORTS FOR THE MONTH ENDED NOVEMBER 30, 2019 and CASH & CASH EQUIVALENTS DETAILED CASH LISTING FOR FIDUCIARY FUNDS SUMMARY OF BANK COLLATERAL REPORTS: BALANCE SHEET REVENUE & EXPENSE SUMMARY GENERAL GENERAL HIGHWAY HIGHWAY DESCRIPTION TOWNWIDE PART-TOWN TOWNWIDE PART-TOWN FUND FUND FUND FUND REVENUE BUDGETED REVENUE 5,523,736$ 1,597,150$ 813,750$ 3,192,000$ 15,000$ 3,174,000$ ACTUAL & ACCRUED 4,904,405 1,375,886 823,603 2,867,879 1,945 3,231,609 REVENUE OVER (UNDER) (619,331)$ (221,264)$ 9,853$ (324,121)$ (13,055)$ 57,609$ % OF BUDGET EARNED 88.8% 86.1% 101.2% 89.8% 13.0% 101.8% EXPENSE BUDGETED EXPENSE 5,938,282$ 1,857,520$ 714,840$ 3,440,050$ 15,000$ 3,415,000$ ACTUAL & ACCRUED 3,945,370 1,332,963 522,230 2,423,311 15,286 2,881,294 EXPENSE OVER (UNDER) (1,992,912)$ (524,557)$ (192,610)$ (1,016,739)$ 286$ (533,706)$ % OF BUDGET EXPENDED 66.4% 71.8% 73.1% 70.4% 101.9% 84.4% ESTIMATED FUND BALANCE FUND BALANCE - 01/01/2019 4,262,061$ 1,223,969$ 243,125$ 2,670,329$ 149,222$ 2,010,351$ ACTUAL & ACCRUED ADD: REVENUE 4,904,405 1,375,886 823,603 2,867,879 1,945 3,231,609 LESS: EXPENSE 3,945,370 1,332,963 522,230 2,423,311 15,286 2,881,294 FUND BALANCE - 11/30/2019 5,221,096$ 1,266,892$ 544,498$ 3,114,897$ 135,881$ 2,360,665$ CASH and CASH EQUIVALENTS UNRESERVED CASH CASH (CHECKING/SAVINGS) 42,708$ 19,395$ 9,096$ 27,817$ 1,008$ 274$ CASH - SJC OPERATING - - - - - - INVESTMENTS 4,262,955 1,385,653 535,401 2,855,534 134,873 2,360,392 PETTY CASH 700 - - 200 - - TOTAL - UNRESERVED CASH 4,306,362$ 1,405,049$ 544,498$ 2,883,551$ 135,881$ 2,360,666$ RESERVED CASH PARKS & OPEN SPACE PLAN 248$ -$ -$ -$ -$ -$ GENERAL PURPOSE BENEFIT 195 96 - 144 - - HIGHWAY EQUIPMENT - - - 24 - - PRESERVE MAINTENANCE 190 - - - - - LAND STEWARDSHIP 757 - - - - - INVESTMENTS 1,166,763 70,451 - 368,651 - - FIDUCIARY FUNDS 229 - - - - - TOTAL - RESERVED CASH 1,168,382$ 70,547$ -$ 368,819$ -$ -$ TOTAL CASH - 11/30/2019 5,474,744$ 1,475,595$ 544,498$ 3,252,370$ 135,881$ 2,360,666$ Page 1 of 4 RISK RETENTION FUND FIRE PROTECTION FUND FOR THE MONTH ENDED NOVEMBER 30, 2019 TOWN OF ITHACA REVENUE and EXPENSE SUMMARY CAPITAL LIGHTING DEBT TRUST & DESCRIPTION PROJECTS DISTRICT SERVICE AGENCY FUNDS FUNDS FUND FUND REVENUE BUDGETED REVENUE 20,687$ 6,641,822$ 2,833,445$ 18,000$ 1,619,843$ -$ ACTUAL & ACCRUED 136,904 3,289,656 2,139,398 18,065 549,519 - REVENUE OVER (UNDER) 116,217$ (3,352,166)$ (694,047)$ 65$ (1,070,324)$ -$ % OF BUDGET EARNED 0.0% 49.5% 75.5% 100.4% 33.9% EXPENSE BUDGETED EXPENSE 67,257$ 6,715,128$ 2,876,445$ 17,500$ 1,688,194$ -$ ACTUAL & ACCRUED 297,984 3,741,163 1,830,734 14,577 373,709 - EXPENSE OVER (UNDER) 230,727$ (2,973,965)$ (1,045,711)$ (2,923)$ (1,314,485)$ -$ % OF BUDGET EXPENDED 0.0% 55.7% 63.6% 83.3% 22.1% ESTIMATED FUND BALANCE FUND BALANCE - 01/01/2019 999,875$ 6,260,797$ 5,418,840$ 14,488$ 98,165$ -$ ACTUAL & ACCRUED ADD: REVENUE 136,904 3,289,656 2,139,398 18,065 549,519 - LESS: EXPENSE 297,984 3,741,163 1,830,734 14,577 373,709 - FUND BALANCE - 11/30/2019 838,796$ 5,809,290$ 5,727,504$ 17,977$ 273,975$ -$ CASH and CASH EQUIVALENTS UNRESERVED CASH CASH (CHECKING/SAVINGS) 1,706$ 17,815$ 9,429$ 12,953$ 62$ -$ CASH - SJC OPERATING - - 126 - - - INVESTMENTS 876,964 1,754,927 2,875,084 5,024 273,914 - PETTY CASH - - - - - - TOTAL - UNRESERVED CASH 878,670$ 1,772,742$ 2,884,639$ 17,977$ 273,975$ -$ RESERVED CASH PARKS & OPEN SPACE PLAN -$ -$ -$ -$ -$ -$ GENERAL PURPOSE BENEFIT - 48 50 - - - HIGHWAY EQUIPMENT - - - - - - PRESERVE MAINTENANCE - - - - - - LAND STEWARDSHIP - - - - - - INVESTMENTS - 24,161 12,182 - - 30,454 FIDUCIARY FUNDS - - - - - 263,711 TOTAL - RESERVED CASH -$ 24,209$ 12,233$ -$ -$ 294,165$ TOTAL CASH - 11/30/2019 878,670$ 1,796,950$ 2,896,872$ 17,977$ 273,975$ 294,165$ Page 2 of 4 FOR THE MONTH ENDED NOVEMBER 30, 2019 TOWN OF ITHACA REVENUE and EXPENSE SUMMARY WATER FUND SEWER FUND FUND H7FUND H8FUND H10FUND H14FUND H15FUND H21FUND H22FUND H9FUND H11FUND H12FUND H13TOTALDESCRIPTIONRoute 96B Gateway Trail Ellis Hollow Winthrop Dr Muriel Street Sand Bank Rd PWF Office Trumansburg Park Lane Sapsucker Christopher CAPITALSidewalk(Grant Funding)Water Tank Water Main Water Main Improvements Expansion Water Tank Water Main Water Main Water Main PROJECTS REVENUEBUDGETED REVENUE -$ -$ -$ -$ -$ -$ -$ 5$ 20,671$ 6$ 4$ 20,687$ ACTUAL & ACCRUED 108,018 560 2,040 - - 5,597 - 6 20,671 7 5 136,904 -----------REVENUE OVER (UNDER) 108,018$ 560$ 2,040$ -$ -$ 5,597$ -$ 1$ 0$ 1$ 0$ 116,217$ % OF BUDGET EARNED 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%EXPENSEBUDGETED EXPENSE -$ -$ -$ -$ -$ -$ -$ 5,932$ 48,264$ 7,733$ 5,329$ 67,257$ ACTUAL & ACCRUED 38,829 17,016 174,880 - - - - 5,933 48,264 7,733 5,329 297,984 EXPENSE OVER (UNDER) 38,829$ 17,016$ 174,880$ -$ -$ -$ -$ 1$ 0$ 1$ 0$ 230,727$ % OF BUDGET EXPENDED 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%ESTIMATED FUND BALANCEFUND BALANCE - 01/01/2019 180,450$ 72,627$ 339,363$ -$ -$ 360,866$ -$ 5,927$ 27,592$ 7,727$ 5,325$ 999,875$ ACTUAL & ACCRUED ADD: REVENUE 108,018 560 2,040 - - 5,597 - 6 20,671 7 5 136,904 LESS: EXPENSE 38,829 17,016 174,880 - - - - 5,933 48,264 7,733 5,329 297,984 FUND BALANCE - 11/30/2019 249,639$ 56,171$ 166,522$ -$ -$ 366,463$ -$ -$ -$ -$ -$ 838,796$ CASH andCASH EQUIVALENTSCASH (CHECKING/SAVINGS)10$ 35$ 649$ -$ -$ 1,012$ -$ -$ -$ -$ -$ 1,706$ INVESTMENTS 249,629 56,011 205,874 - - 365,451 - - - - - 876,964 TOTAL CASH - 11/30/2019 249,639$ 56,045$ 206,522$ -$ -$ 366,463$ -$ -$ -$ -$ -$ 878,670$ Page 3 of 4TOWN OF ITHACAREVENUE and EXPENSE SUMMARY for CAPITAL PROJECTSFOR THE MONTH ENDED NOVEMBER 30, 2019ACTIVE CAPITAL PROJECTS CLOSED CAPITAL PROJECTS FUND SL-1FUND SL-2FUND SL-3FUND SL-4FUND SL-5FUND SL-6FUND SL-7FUND SL-8FUND SL-9TOTALDESCRIPTIONForest Renwick Eastwood Winner's Burleigh Westhaven Coddington LIGHTHome Heights Commons Circle Drive Road Road DISTRICTS REVENUEBUDGETED REVENUE 5,300$ 900$ 1,300$ 2,700$ 300$ 1,000$ 1,100$ 3,300$ 2,100$ 18,000$ ACTUAL & ACCRUED 5,334 903 1,303 2,706 301 1,002 1,103 3,308 2,105 18,065 REVENUE OVER (UNDER) 34$ 3$ 3$ 6$ 1$ 2$ 3$ 8$ 5$ 65$ % OF BUDGET EARNED 100.7% 100.4% 100.2% 100.2% 100.3% 100.2% 100.3% 100.2% 100.3% 100.4%EXPENSEBUDGETED EXPENSE 4,800$ 1,100$ 1,300$ 2,600$ 300$ 900$ 1,100$ 3,300$ 2,100$ 17,500$ ACTUAL & ACCRUED 4,989 792 990 1,996 235 731 803 2,535 1,505 14,577 EXPENSE OVER (UNDER) 189$ (308)$ (310)$ (604)$ (65)$ (169)$ (297)$ (765)$ (595)$ (2,923)$ % OF BUDGET EXPENDED 103.9% 72.0% 76.1% 76.8% 78.5% 81.2% 73.0% 76.8% 71.7% 83.3%ESTIMATED FUND BALANCEFUND BALANCE - 01/01/2019 5,649$ 1,004$ 836$ 1,418$ 202$ 433$ 881$ 2,357$ 1,708$ 14,488$ ACTUAL & ACCRUED ADD: REVENUE 5,334 903 1,303 2,706 301 1,002 1,103 3,308 2,105 18,065 LESS: EXPENSE 4,989 792 990 1,996 235 731 803 2,535 1,505 14,577 FUND BALANCE - 11/30/2019 5,994$ 1,115$ 1,150$ 2,127$ 267$ 704$ 1,180$ 3,130$ 2,309$ 17,977$ CASH andCASH EQUIVALENTSCASH (CHECKING/SAVINGS) 971$ 1,115$ 1,150$ 2,127$ 267$ 704$ 1,180$ 3,130$ 2,309$ 12,953$ INVESTMENTS 5,024 - - - - - - - - 5,024 TOTAL CASH - 11/30/2019 5,994$ 1,115$ 1,150$ 2,127$ 267$ 704$ 1,180$ 3,130$ 2,309$ 17,977$ Page 4 of 4TOWN OF ITHACAREVENUE and EXPENSE SUMMARY for LIGHT DISTRICTSFOR THE MONTH ENDED NOVEMBER 30, 2019Glenside Clover Lane GENERAL GENERAL HIGHWAY HIGHWAY DESCRIPTION TOWNWIDE PART-TOWN TOWNWIDE PART-TOWN FUND FUND FUND FUND ASSETS UNRESERVED CASH: CASH 42,708$ 19,395$ 9,096$ 27,817$ 1,008$ 274$ INVESTMENTS 4,262,955 1,385,653 535,401 2,855,534 134,873 2,360,392 PETTY CASH 700 - - 200 - - TOTAL - UNRESERVED CASH 4,306,362$ 1,405,049$ 544,498$ 2,883,551$ 135,881$ 2,360,666$ RESERVED CASH: PARKS & OPEN SPACE PLAN 248$ -$ -$ -$ -$ -$ GENERAL PURPOSE BENEFIT 195 96 - 144 - - HIGHWAY EQUIPMENT - - - 24 - - PRESERVE MAINTENANCE 190 - - - - - LAND STEWARDSHIP 757 - - - - - INVESTMENTS 1,166,763 70,451 - 368,651 - - FIDUCIARY FUNDS 229 - - - - - TOTAL - RESERVED CASH 1,168,382$ 70,547$ -$ 368,819$ -$ -$ OTHER ASSETS: ACCOUNTS RECEIVABLE -$ -$ -$ -$ -$ -$ WATER & SEWER RECEIVABLES - - - - - - DUE FROM OTHER FUNDS - - - - - - STATE & FEDERAL AID RECEIVABLE - - - - - - DUE FROM OTHER GOV'TS 24,503 1,033 - - - - PREPAID EXPENSES 10,441 - - - - - TAXES RECEIVABLE - CURRENT - - - - - - TOTAL - OTHER ASSETS 34,944$ 1,033$ -$ -$ -$ -$ TOTAL ASSETS 5,509,688$ 1,476,629$ 544,498$ 3,252,370$ 135,881$ 2,360,666$ LIABILITIES and FUND BALANCE ACCOUNTS PAYABLE -$ -$ -$ -$ -$ -$ ACCRUED LIABILITIES 288,592 209,737 - 135,473 - (0) DUE TO OTHER FUNDS - - - - - - DUE TO OTHER GOVERNMENTS - - - - - - RETAINAGE - - - 2,000 - - DEFERRED REVENUE - - - - - - RESERVED FUND BALANCE 1,168,382 70,547 - 368,819 - - UNRESERVED FUND BALANCE 4,052,714 1,196,345 544,498 2,746,078 135,881 2,360,666 TOTAL LIABILITIES & FUND BALANCE 5,509,688$ 1,476,629$ 544,498$ 3,252,370$ 135,881$ 2,360,666$ ESTIMATED FUND BALANCE FUND BALANCE - 01/01/2019 4,262,061$ 1,223,969$ 243,125$ 2,670,329$ 149,222$ 2,010,351$ ADD: REVENUE 4,904,405 1,375,886 823,603 2,867,879 1,945 3,231,609 LESS: EXPENSE 3,945,370 1,332,963 522,230 2,423,311 15,286 2,881,294 FUND BALANCE - 11/30/2019 5,221,096$ 1,266,892$ 544,498$ 3,114,897$ 135,881$ 2,360,665$ Page 1 of 4 RISK RETENTION FUND FIRE PROTECTION FUND FOR THE MONTH ENDED NOVEMBER 30, 2019 BALANCE SHEET TOWN OF ITHACA CAPITAL LIGHTING DEBT TRUST & DESCRIPTION PROJECTS DISTRICT SERVICE AGENCY FUNDS FUNDS FUND FUND ASSETS UNRESERVED CASH: CASH 1,706$ 17,815$ 9,555$ 12,953$ 62$ -$ INVESTMENTS 876,964 1,754,927 2,875,084 5,024 273,914 - PETTY CASH - - - - - - TOTAL - UNRESERVED CASH 878,670$ 1,772,742$ 2,884,639$ 12,953$ 273,975$ -$ RESERVED CASH: PARKS & OPEN SPACE PLAN -$ -$ -$ -$ -$ -$ GENERAL PURPOSE BENEFIT - 48 50 - - - HIGHWAY EQUIPMENT - - - - - - PRESERVE MAINTENANCE - - - - - - LAND STEWARDSHIP - - - - - - INVESTMENTS - 24,161 12,182 - - 30,454 FIDUCIARY FUNDS - - - - - 263,711 TOTAL - RESERVED CASH -$ 24,209$ 12,233$ -$ -$ 294,165$ OTHER ASSETS: FIXED ASSETS -$ 14,659,879$ 3,007,757$ -$ -$ -$ WATER & SEWER RECEIVABLES - 487,371 470,369 - - - DUE FROM OTHER FUNDS - - - - - - STATE & FEDERAL AID RECEIVABLE - - - - - - DUE FROM OTHER GOV'TS 126 1,694,237 - - - - PREPAID EXPENSES - (6,844) (3,913) - - - DEFERRED OUTFLOW OF RESOURCE - 101,454 70,013 - - - TOTAL - OTHER ASSETS 126$ 16,936,097$ 3,544,226$ -$ -$ -$ TOTAL ASSETS 878,796$ 18,733,047$ 6,441,098$ 12,953$ 273,975$ 294,165$ LIABILITIES and FUND BALANCE ACCRUED LIABILITIES - 258,319 - - - 294,165 DUE TO OTHER GOVERNMENTS - - 16,000 - - - DUE TO OTHER FUNDS - - - - - - RETAINAGE 40,000 - 7,190 - - - BONDS PAYABLE - 12,031,911 - - - - BOND INTEREST PAYABLE - 52,802 - - - - BOND PREMIUM - 104,397 - - - - NET PENSION LIABILITY - 16,372 9,115 - - - OPEB LIABILITY - 477,330 341,305 - - - COMPENSATED ABSENCES - 8,928 11,526 - - - DEFERRED INFLOW OF RESOURCES - 71,285 39,517 - - - RESERVED FUND BALANCE - 24,209 12,233 - - - UNRESERVED FUND BALANCE 838,796 5,687,494 6,004,212 12,953 273,975 - TOTAL LIABILITIES & FUND BALANCE 878,796$ 18,733,047$ 6,441,098$ 12,953$ 273,975$ 294,165$ ESTIMATED FUND BALANCE FUND BALANCE - 01/01/2019 999,875$ 6,260,797$ 5,418,840$ 14,488$ 98,165$ -$ ADD: REVENUE 136,904 3,289,656 2,139,398 18,065 549,519 - LESS: EXPENSE 297,984 3,741,163 1,830,734 14,577 373,709 - FUND BALANCE - 11/30/2019 838,796$ 5,809,290$ 5,727,504$ 17,977$ 273,975$ -$ Page 2 of 4 FOR THE MONTH ENDED NOVEMBER 30, 2019 TOWN OF ITHACA BALANCE SHEET WATER FUND SEWER FUND FUND H7FUND H8FUND H10FUND H14FUND H15FUND H21FUND H22FUND H9FUND H11FUND H12FUND H13TOTALDESCRIPTIONRoute 96B Gateway Trail Ellis Hollow Winthrop Dr Muriel Street Sand Bank Rd PWF Office Trumansburg Park Lane Sapsucker Christopher CAPITALSidewalk(Grant Funding)Water Tank Water Main Water Main Improvements Expansion Water Tank Water Main Water Main Water Main PROJECTSASSETS UNRESERVED CASH: CASH 10$ 35$ 649$ -$ -$ 1,012$ -$ -$ -$ -$ -$ 1,706$ INVESTMENTS 249,629 56,011 205,874 - - 365,451 - - - - - 876,964 TOTAL - UNRESERVED CASH 249,639$ 56,045$ 206,522$ -$ -$ 366,463$ -$ -$ -$ -$ -$ 878,670$ OTHER ASSETS: ACCOUNTS RECEIVABLE -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ CUSTOMER RECEIVABLE - - - - - - - - - - - - DUE FROM OTHER FUNDS - - - - - - - - - - - - STATE/FEDERAL RECEIVABLE - - - - - - - - - - - - DUE FROM OTHER GOV'TS - 126 - - - - - - - - - 126 PREPAID EXPENSES - - - - - - - - - - - - BAN LOANS - - - - - - - - - - - - TOTAL - OTHER ASSETS -$ 126$ -$ -$ -$ -$ -$ -$ -$ -$ -$ 126$ TOTAL ASSETS 249,639$ 56,171$ 206,522$ -$ -$ 366,463$ -$ -$ -$ -$ -$ 878,796$ LIABILITIES & FUND BALANCEACCOUNTS PAYABLE -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ ACCRUED LIABILIITES - - - - - - - - - - - - DUE TO OTHER FUNDS - - - - - - - - - - - - RETAINAGE - - 40,000 - - - - - - - - 40,000 BAN PAYABLE - - - - - - - - - - - - RESERVED FUND BALANCE - - - - - - - - - - - - UNRESERVED FUND BALANCE 249,639 56,171 166,522 - - 366,463 - - - - - 838,796 TOTAL LIAB & FUND BALANCE 249,639$ 56,171$ 206,522$ -$ -$ 366,463$ -$ -$ -$ -$ -$ 878,796$ ESTIMATED FUND BALANCEFUND BALANCE - 01/01/2019 180,450$ 72,627$ 339,363$ -$ -$ 360,866$ -$ 5,927$ 27,592$ 7,727$ 5,325$ 999,875$ ADD: REVENUE 108,018 560 2,040 - - 5,597 - 6 20,671 7 5 136,904 LESS: EXPENSE 38,829 17,016 174,880 - - - - 5,933 48,264 7,733 5,329 297,984 FUND BALANCE - 11/30/2019 249,639$ 56,171$ 166,522$ -$ -$ 366,463$ -$ -$ -$ -$ -$ 838,796$ Page 3 of 4TOWN OF ITHACABALANCE SHEET for CAPITAL PROJECTSFOR THE MONTH ENDED NOVEMBER 30, 2019ACTIVE CAPITAL PROJECTS CLOSED CAPITAL PROJECTS FUND SL-1FUND SL-2FUND SL-3FUND SL-4FUND SL-5FUND SL-6FUND SL-7FUND SL-8FUND SL-9TOTALDESCRIPTIONForest Renwick Eastwood Winner's Burleigh Westhaven Coddington LIGHTHome Heights Commons Circle Drive Road Road DISTRICTS ASSETS UNRESERVED CASH: CASH 971$ 1,115$ 1,150$ 2,127$ 267$ 704$ 1,180$ 3,130$ 2,309$ 12,953$ INVESTMENTS 5,024 - - - - - - - - 5,024 TOTAL - UNRESERVED CASH 5,994$ 1,115$ 1,150$ 2,127$ 267$ 704$ 1,180$ 3,130$ 2,309$ 17,977$ OTHER ASSETS: ACCOUNTS RECEIVABLE -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ CUSTOMER RECEIVABLE - - - - - - - - - - DUE FROM OTHER FUNDS - - - - - - - - - - STATE & FEDERAL AID RECEIVABLE - - - - - - - - - - PREPAID EXPENSES - - - - - - - - - - TAXES RECEIVABLE - CURRENT - - - - - - - - - - TOTAL - OTHER ASSETS -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ TOTAL ASSETS 5,994$ 1,115$ 1,150$ 2,127$ 267$ 704$ 1,180$ 3,130$ 2,309$ 17,977$ LIABILITIES and FUND BALANCEACCOUNTS PAYABLE -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ ACCRUED LIABILIITES - - - - - - - - - - DUE TO OTHER FUNDS - - - - - - - - - - DEFERRED REVENUE - - - - - - - - - - RESERVED FUND BALANCE - - - - - - - - - - UNRESERVED FUND BALANCE 5,994 1,115 1,150 2,127 267 704 1,180 3,130 2,309 17,977 TOTAL LIABILITIES & FUND BALANCE 5,994$ 1,115$ 1,150$ 2,127$ 267$ 704$ 1,180$ 3,130$ 2,309$ 17,977$ ESTIMATED FUND BALANCEFUND BALANCE - 01/01/2019 5,649$ 1,004$ 836$ 1,418$ 202$ 433$ 881$ 2,357$ 1,708$ 14,488$ ADD: REVENUE 5,334 903 1,303 2,706 301 1,002 1,103 3,308 2,105 18,065 LESS: EXPENSE 4,989 792 990 1,996 235 731 803 2,535 1,505 14,577 FUND BALANCE - 11/30/2019 5,994$ 1,115$ 1,150$ 2,127$ 267$ 704$ 1,180$ 3,130$ 2,309$ 17,977$ Page 4 of 4TOWN OF ITHACABALANCE SHEET for LIGHT DISTRICTSFOR THE MONTH ENDED NOVEMBER 30, 2019Glenside Clover Lane AMOUNT TRUST & AGENCY FUND TA200C DISBURSEMENTS CHECKING -$ TA200P PAYROLL CHECKING 20,530.39 TA201 CASH IN TIME DEPOSITS 30,454.25 TA202 ON-LINE COLLECTIONS 15.74 TA203 CASH IN SHORT TERM INVESTMENTS 216,170.60 TA205 ROAD USE AGREEMENTS 36.03 TA206 ITHACA TOWERS OPTION ESCROW 43.37 TA207 UNCLAIMED BAIL - ITHACA TOWN COURT 3,401.14 TA209 EMPLOYEE FLEXIBLE SPENDING 13,069.46 TA210 STORMWATER COALITION 6,016.68 TA211 PLANNING DEPOSITS 41.79 TA212 CAYUGA LAKE WATERSHED INTERMUNICIPAL ORG 13.09 TA214 LAKE VIEW CEMETERY - PERMANENT MAINT FUND 2,342.11 TA215 LAKE VIEW CEMETERY - FERRIS MEMORIAL FUND 1,522.72 TA217 TIER 6 RETIREMENT ESCROW 507.50 TOTAL CASH: TRUST & AGENCY FUND 294,164.87$ GENERAL TOWNWIDE FUND A237 INLET VALLEY CEMETERY 228.81$ TOTAL CASH: FIDUCIARY FUNDS 294,393.68$ Road Use Agreements: Conifer Realty - Cayuga Meadows RUA 30,436.00$ Jeff Simmons - 120 Maple Avenue 1,000.00 Enslow Landscape - 119 Grove Road Lot 10 1,000.00 EE Root LLC - Elm/Elm Crest/Hallern 1,000.00 Cornell University - 102 Humphreys S Bld 1,000.00 R B Robinson Contracting - Snyder Hill Road 1,000.00 10/10/2019 Walczak Excavating - 104 Grove Place 1,000.00 10/10/2019 Accrued Interest - transfer to General Fund 83.16 Total - Road Use Agreements 36,519.16$ TA38 - Planning Deposits: Nextel Site Lease Deposit 4,510.32$ Wireless One Site Lease Deposit 4,601.43 Maplewood Traffic Calming Deposit (Rec. 3/19/18)18,080.00 History Center Lease Deposit 400.00 Accrued Interest - transfer to General Fund 63.69 Total - Planning Deposits 27,655.44$ TA43 - TOWN OF ITHACA DETAILED CASH LISTING - FIDUCIARY FUNDS FOR THE MONTH ENDED NOVEMBER 30, 2019 DESCRIPTION TOMPKINS TRUST COMPANY: CASH & CASH EQUIVALENTS 408,981$ INVESTMENTS 18,993,382$ TOTAL CASH ON DEPOSIT 19,402,363$ LESS: FDIC INSURANCE 250,000$ LESS: FMV OF COLLATERAL ON DEPOSIT @ 11/30/2019 U.S. GOVERNMENT AGENCY OBLIGATIONS 23,137,190$ OVER (UNDER) COLLATERALIZED 3,984,827$ CASH ASSETS COLLATERALIZED @ FMV 11/30/19 121% Collateral is held by the Bank of New York, pledged for the Town of Ithaca, New York, for all deposits and/or repurchase agreements of Tompkins Trust Company. For deposits in excess of FDIC coverage, General Municipal Law, section 10 requires that the excess amounts are to be secured by eligible collateral. TOWN OF ITHACA SUMMARY OF BANK COLLATERAL FOR THE MONTH ENDED NOVEMBER 30, 2019 NOTE: