Loading...
HomeMy WebLinkAbout2019-10 Financial ReportDETAILED CASH LISTING FOR FIDUCIARY FUNDS SUMMARY OF BANK COLLATERAL REPORTS: BALANCE SHEET REVENUE & EXPENSE SUMMARY TOWN OF ITHACA FINANCIAL REPORTS FOR THE MONTH ENDED OCTOBER 31, 2019 and CASH & CASH EQUIVALENTS 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,838,878 1,356,093 822,988 2,861,889 1,715 3,227,597 REVENUE OVER (UNDER) (684,858)$ (241,057)$ 9,238$ (330,111)$ (13,285)$ 53,597$ % OF BUDGET EARNED 87.6% 84.9% 101.1% 89.7% 11.4% 101.7% EXPENSE BUDGETED EXPENSE 5,938,282$ 1,857,520$ 714,840$ 3,440,050$ 15,000$ 3,415,000$ ACTUAL & ACCRUED 3,526,405 1,213,070 505,718 2,143,673 15,286 2,615,294 EXPENSE OVER (UNDER) (2,411,877)$ (644,450)$ (209,122)$ (1,296,377)$ 286$ (799,706)$ % OF BUDGET EXPENDED 59.4% 65.3% 70.7% 62.3% 101.9% 76.6% 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,838,878 1,356,093 822,988 2,861,889 1,715 3,227,597 LESS: EXPENSE 3,526,405 1,213,070 505,718 2,143,673 15,286 2,615,294 FUND BALANCE - 10/31/2019 5,574,535$ 1,366,992$ 560,395$ 3,388,546$ 135,651$ 2,622,654$ CASH and CASH EQUIVALENTS UNRESERVED CASH CASH (CHECKING/SAVINGS) 33,296$ 19,714$ 30,606$ (5,719)$ 8$ 272$ CASH - SJC OPERATING - - - - - - INVESTMENTS 4,646,128 1,485,568 529,789 3,163,398 135,643 2,622,382 PETTY CASH 700 - - 200 - - TOTAL - UNRESERVED CASH 4,680,125$ 1,505,282$ 560,395$ 3,157,880$ 135,651$ 2,622,654$ RESERVED CASH PARKS & OPEN SPACE PLAN 248$ -$ -$ -$ -$ -$ GENERAL PURPOSE BENEFIT 195 96 - 144 - - HIGHWAY EQUIPMENT - - - 24 - - PRESERVE MAINTENANCE 190 - - - - - LAND STEWARDSHIP 757 - - - - - INVESTMENTS 1,164,853 70,317 - 367,971 - - FIDUCIARY FUNDS 229 - - - - - TOTAL - RESERVED CASH 1,166,471$ 70,413$ -$ 368,139$ -$ -$ TOTAL CASH - 10/31/2019 5,846,595$ 1,575,695$ 560,395$ 3,526,019$ 135,651$ 2,622,654$ Page 1 of 4 RISK RETENTION FUND FIRE PROTECTION FUND FOR THE MONTH ENDED OCTOBER 31, 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 135,628 3,675,147 2,369,593 18,057 837,201 - REVENUE OVER (UNDER) 114,941$ (2,966,675)$ (463,852)$ 57$ (782,642)$ -$ % OF BUDGET EARNED 0.0% 55.3% 83.6% 100.3% 51.7% EXPENSE BUDGETED EXPENSE 67,257$ 6,715,128$ 2,876,445$ 17,500$ 1,688,194$ -$ ACTUAL & ACCRUED 287,486 4,143,498 1,780,471 10,867 373,709 - EXPENSE OVER (UNDER) 220,229$ (2,571,630)$ (1,095,974)$ (6,633)$ (1,314,485)$ -$ % OF BUDGET EXPENDED 0.0% 61.7% 61.9% 62.1% 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 135,628 3,675,147 2,369,593 18,057 837,201 - LESS: EXPENSE 287,486 4,143,498 1,780,471 10,867 373,709 - FUND BALANCE - 10/31/2019 848,018$ 5,792,446$ 6,007,961$ 21,679$ 561,657$ -$ CASH and CASH EQUIVALENTS UNRESERVED CASH CASH (CHECKING/SAVINGS) 1,803$ 20,631$ 17,993$ 16,660$ 150$ -$ CASH - SJC OPERATING - - 126 - - - INVESTMENTS 886,089 1,832,900 2,858,060 5,018 561,508 - PETTY CASH - - - - - - TOTAL - UNRESERVED CASH 887,892$ 1,853,531$ 2,876,179$ 21,679$ 561,657$ -$ RESERVED CASH PARKS & OPEN SPACE PLAN -$ -$ -$ -$ -$ -$ GENERAL PURPOSE BENEFIT - 48 50 - - - HIGHWAY EQUIPMENT - - - - - - PRESERVE MAINTENANCE - - - - - - LAND STEWARDSHIP - - - - - - INVESTMENTS - 24,115 12,159 - - 30,397 FIDUCIARY FUNDS - - - - - 452,025 TOTAL - RESERVED CASH -$ 24,163$ 12,209$ -$ -$ 482,422$ TOTAL CASH - 10/31/2019 887,892$ 1,877,694$ 2,888,388$ 21,679$ 561,657$ 482,422$ Page 2 of 4 FOR THE MONTH ENDED OCTOBER 31, 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 107,731 497 1,807 - - 4,906 - 6 20,671 7 5 135,628 -----------REVENUE OVER (UNDER) 107,731$ 497$ 1,807$ -$ -$ 4,906$ -$ 1$ 0$ 1$ 0$ 114,941$ % 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 28,331 17,016 174,880 - - - - 5,933 48,264 7,733 5,329 287,486 EXPENSE OVER (UNDER) 28,331$ 17,016$ 174,880$ -$ -$ -$ -$ 1$ 0$ 1$ 0$ 220,229$ % 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 107,731 497 1,807 - - 4,906 - 6 20,671 7 5 135,628 LESS: EXPENSE 28,331 17,016 174,880 - - - - 5,933 48,264 7,733 5,329 287,486 FUND BALANCE - 10/31/2019 259,850$ 56,107$ 166,289$ -$ -$ 365,772$ -$ -$ -$ -$ -$ 848,018$ CASH andCASH EQUIVALENTSCASH (CHECKING/SAVINGS) 108$ 35$ 649$ -$ -$ 1,012$ -$ -$ -$ -$ -$ 1,803$ INVESTMENTS 259,741 55,947 205,641 - - 364,760 - - - - - 886,089 TOTAL CASH - 10/31/2019 259,850$ 55,982$ 206,289$ -$ -$ 365,772$ -$ -$ -$ -$ -$ 887,892$ Page 3 of 4TOWN OF ITHACAREVENUE and EXPENSE SUMMARY for CAPITAL PROJECTSFOR THE MONTH ENDED OCTOBER 31, 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,328 903 1,303 2,705 301 1,002 1,103 3,308 2,105 18,057 REVENUE OVER (UNDER) 28$ 3$ 3$ 5$ 1$ 2$ 3$ 8$ 5$ 57$ % OF BUDGET EARNED 100.5% 100.3% 100.2% 100.2% 100.2% 100.2% 100.2% 100.2% 100.2% 100.3%EXPENSEBUDGETED EXPENSE 4,800$ 1,100$ 1,300$ 2,600$ 300$ 900$ 1,100$ 3,300$ 2,100$ 17,500$ ACTUAL & ACCRUED 2,214 715 894 1,801 212 659 725 2,289 1,359 10,867 EXPENSE OVER (UNDER) (2,586)$ (385)$ (406)$ (799)$ (88)$ (241)$ (375)$ (1,011)$ (741)$ (6,633)$ % OF BUDGET EXPENDED 46.1% 65.0% 68.7% 69.3% 70.8% 73.2% 65.9% 69.4% 64.7% 62.1%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,328 903 1,303 2,705 301 1,002 1,103 3,308 2,105 18,057 LESS: EXPENSE 2,214 715 894 1,801 212 659 725 2,289 1,359 10,867 FUND BALANCE - 10/31/2019 8,763$ 1,192$ 1,246$ 2,322$ 290$ 776$ 1,258$ 3,375$ 2,454$ 21,679$ CASH andCASH EQUIVALENTSCASH (CHECKING/SAVINGS) 3,745$ 1,192$ 1,246$ 2,322$ 290$ 776$ 1,258$ 3,375$ 2,454$ 16,660$ INVESTMENTS 5,018 - - - - - - - - 5,018 TOTAL CASH - 10/31/2019 8,763$ 1,192$ 1,246$ 2,322$ 290$ 776$ 1,258$ 3,375$ 2,454$ 21,679$ Page 4 of 4TOWN OF ITHACAREVENUE and EXPENSE SUMMARY for LIGHT DISTRICTSFOR THE MONTH ENDED OCTOBER 31, 2019Glenside Clover Lane GENERAL GENERAL HIGHWAY HIGHWAY DESCRIPTION TOWNWIDE PART-TOWN TOWNWIDE PART-TOWN FUND FUND FUND FUND ASSETS UNRESERVED CASH: CASH 33,296$ 19,714$ 30,606$ (5,719)$ 8$ 272$ INVESTMENTS 4,646,128 1,485,568 529,789 3,163,398 135,643 2,622,382 PETTY CASH 700 - - 200 - - TOTAL - UNRESERVED CASH 4,680,125$ 1,505,282$ 560,395$ 3,157,880$ 135,651$ 2,622,654$ RESERVED CASH: PARKS & OPEN SPACE PLAN 248$ -$ -$ -$ -$ -$ GENERAL PURPOSE BENEFIT 195 96 - 144 - - HIGHWAY EQUIPMENT - - - 24 - - PRESERVE MAINTENANCE 190 - - - - - LAND STEWARDSHIP 757 - - - - - INVESTMENTS 1,164,853 70,317 - 367,971 - - FIDUCIARY FUNDS 229 - - - - - TOTAL - RESERVED CASH 1,166,471$ 70,413$ -$ 368,139$ -$ -$ OTHER ASSETS: ACCOUNTS RECEIVABLE 5,550$ -$ -$ -$ -$ -$ WATER & SEWER RECEIVABLES - - - - - - DUE FROM OTHER FUNDS - - - - - - STATE & FEDERAL AID RECEIVABLE - - - - - - DUE FROM OTHER GOV'TS - 1,033 - - - - PREPAID EXPENSES 10,981 - - - - - TAXES RECEIVABLE - CURRENT - - - - - - TOTAL - OTHER ASSETS 16,531$ 1,033$ -$ -$ -$ -$ TOTAL ASSETS 5,863,127$ 1,576,729$ 560,395$ 3,526,019$ 135,651$ 2,622,654$ 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,166,471 70,413 - 368,139 - - UNRESERVED FUND BALANCE 4,408,064 1,296,578 560,395 3,020,407 135,651 2,622,654 TOTAL LIABILITIES & FUND BALANCE 5,863,127$ 1,576,729$ 560,395$ 3,526,019$ 135,651$ 2,622,654$ 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,838,878 1,356,093 822,988 2,861,889 1,715 3,227,597 LESS: EXPENSE 3,526,405 1,213,070 505,718 2,143,673 15,286 2,615,294 FUND BALANCE - 10/31/2019 5,574,535$ 1,366,992$ 560,395$ 3,388,546$ 135,651$ 2,622,654$ Page 1 of 4 RISK RETENTION FUND FIRE PROTECTION FUND FOR THE MONTH ENDED OCTOBER 31, 2019 BALANCE SHEET TOWN OF ITHACA CAPITAL LIGHTING DEBT TRUST & DESCRIPTION PROJECTS DISTRICT SERVICE AGENCY FUNDS FUNDS FUND FUND ASSETS UNRESERVED CASH: CASH 1,803$ 20,631$ 18,119$ 16,660$ 150$ -$ INVESTMENTS 886,089 1,832,900 2,858,060 5,018 561,508 - PETTY CASH - - - - - - TOTAL - UNRESERVED CASH 887,892$ 1,853,531$ 2,876,179$ 16,660$ 561,657$ -$ RESERVED CASH: PARKS & OPEN SPACE PLAN -$ -$ -$ -$ -$ -$ GENERAL PURPOSE BENEFIT - 48 50 - - - HIGHWAY EQUIPMENT - - - - - - PRESERVE MAINTENANCE - - - - - - LAND STEWARDSHIP - - - - - - INVESTMENTS - 24,115 12,159 - - 30,397 FIDUCIARY FUNDS - - - - - 452,025 TOTAL - RESERVED CASH -$ 24,163$ 12,209$ -$ -$ 482,422$ 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 888,018$ 18,813,791$ 6,432,614$ 16,660$ 561,657$ 482,422$ LIABILITIES and FUND BALANCE ACCRUED LIABILITIES - 258,319 - - - 482,422 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,163 12,209 - - - UNRESERVED FUND BALANCE 848,018 5,768,283 5,995,752 16,660 561,657 - TOTAL LIABILITIES & FUND BALANCE 888,018$ 18,813,791$ 6,432,614$ 16,660$ 561,657$ 482,422$ ESTIMATED FUND BALANCE FUND BALANCE - 01/01/2019 999,875$ 6,260,797$ 5,418,840$ 14,488$ 98,165$ -$ ADD: REVENUE 135,628 3,675,147 2,369,593 18,057 837,201 - LESS: EXPENSE 287,486 4,143,498 1,780,471 10,867 373,709 - FUND BALANCE - 10/31/2019 848,018$ 5,792,446$ 6,007,961$ 21,679$ 561,657$ -$ FOR THE MONTH ENDED OCTOBER 31, 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 108$ 35$ 649$ -$ -$ 1,012$ -$ -$ -$ -$ -$ 1,803$ INVESTMENTS 259,741 55,947 205,641 - - 364,760 - - - - - 886,089 TOTAL - UNRESERVED CASH 259,850$ 55,982$ 206,289$ -$ -$ 365,772$ -$ -$ -$ -$ -$ 887,892$ 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 259,850$ 56,107$ 206,289$ -$ -$ 365,772$ -$ -$ -$ -$ -$ 888,018$ LIABILITIES & FUND BALANCEACCOUNTS PAYABLE -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ ACCRUED LIABILIITES - - - - - - - - - - - - DUE TO OTHER FUNDS - - - - - - - - - - - - RETAINAGE - - 40,000 - - - - - - - - 40,000 BAN PAYABLE - - - - - - - - - - - - RESERVED FUND BALANCE - - - - - - - - - - - - UNRESERVED FUND BALANCE 259,850 56,107 166,289 - - 365,772 - - - - - 848,018 TOTAL LIAB & FUND BALANCE 259,850$ 56,107$ 206,289$ -$ -$ 365,772$ -$ -$ -$ -$ -$ 888,018$ 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 107,731 497 1,807 - - 4,906 - 6 20,671 7 5 135,628 LESS: EXPENSE 28,331 17,016 174,880 - - - - 5,933 48,264 7,733 5,329 287,486 FUND BALANCE - 10/31/2019 259,850$ 56,107$ 166,289$ -$ -$ 365,772$ -$ -$ -$ -$ -$ 848,018$ Page 3 of 4TOWN OF ITHACABALANCE SHEET for CAPITAL PROJECTSFOR THE MONTH ENDED OCTOBER 31, 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 3,745$ 1,192$ 1,246$ 2,322$ 290$ 776$ 1,258$ 3,375$ 2,454$ 16,660$ INVESTMENTS 5,018 - - - - - - - - 5,018 TOTAL - UNRESERVED CASH 8,763$ 1,192$ 1,246$ 2,322$ 290$ 776$ 1,258$ 3,375$ 2,454$ 21,679$ OTHER ASSETS: ACCOUNTS RECEIVABLE -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ CUSTOMER RECEIVABLE - - - - - - - - - - DUE FROM OTHER FUNDS - - - - - - - - - - STATE & FEDERAL AID RECEIVABLE - - - - - - - - - - PREPAID EXPENSES - - - - - - - - - - TAXES RECEIVABLE - CURRENT - - - - - - - - - - TOTAL - OTHER ASSETS -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ TOTAL ASSETS 8,763$ 1,192$ 1,246$ 2,322$ 290$ 776$ 1,258$ 3,375$ 2,454$ 21,679$ LIABILITIES and FUND BALANCEACCOUNTS PAYABLE -$ -$ -$ -$ -$ -$ -$ -$ -$ -$ ACCRUED LIABILIITES - - - - - - - - - - DUE TO OTHER FUNDS - - - - - - - - - - DEFERRED REVENUE - - - - - - - - - - RESERVED FUND BALANCE - - - - - - - - - - UNRESERVED FUND BALANCE 8,763 1,192 1,246 2,322 290 776 1,258 3,375 2,454 21,679 TOTAL LIABILITIES & FUND BALANCE 8,763$ 1,192$ 1,246$ 2,322$ 290$ 776$ 1,258$ 3,375$ 2,454$ 21,679$ 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,328 903 1,303 2,705 301 1,002 1,103 3,308 2,105 18,057 LESS: EXPENSE 2,214 715 894 1,801 212 659 725 2,289 1,359 10,867 FUND BALANCE - 10/31/2019 8,763$ 1,192$ 1,246$ 2,322$ 290$ 776$ 1,258$ 3,375$ 2,454$ 21,679$ Page 4 of 4TOWN OF ITHACABALANCE SHEET for LIGHT DISTRICTSFOR THE MONTH ENDED OCTOBER 31, 2019Glenside Clover Lane AMOUNT TRUST & AGENCY FUND TA200C DISBURSEMENTS CHECKING -$ TA200P PAYROLL CHECKING 225,085.60 TA201 CASH IN TIME DEPOSITS 30,396.65 TA202 ON-LINE COLLECTIONS 15.73 TA203 CASH IN SHORT TERM INVESTMENTS 206,251.12 TA205 ROAD USE AGREEMENTS 36.03 TA206 ITHACA TOWERS OPTION ESCROW 43.36 TA207 UNCLAIMED BAIL - ITHACA TOWN COURT 3,400.58 TA209 EMPLOYEE FLEXIBLE SPENDING 11,397.45 TA210 STORMWATER COALITION 1,866.49 TA211 PLANNING DEPOSITS 41.78 TA212 CAYUGA LAKE WATERSHED INTERMUNICIPAL ORG 13.09 TA214 LAKE VIEW CEMETERY - PERMANENT MAINT FUND 2,341.73 TA215 LAKE VIEW CEMETERY - FERRIS MEMORIAL FUND 1,522.47 TA217 TIER 6 RETIREMENT ESCROW 9.59 TOTAL CASH: TRUST & AGENCY FUND 482,421.67$ GENERAL TOWNWIDE FUND A237 INLET VALLEY CEMETERY 228.74$ TOTAL CASH: FIDUCIARY FUNDS 482,650.41$ 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 41.86 Total - Road Use Agreements 36,477.86$ 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 32.42 Total - Planning Deposits 27,624.17$ TA43 - TOWN OF ITHACA DETAILED CASH LISTING - FIDUCIARY FUNDS FOR THE MONTH ENDED OCTOBER 31, 2019 DESCRIPTION TOMPKINS TRUST COMPANY: CASH & CASH EQUIVALENTS 590,446$ INVESTMENTS 20,396,295$ TOTAL CASH ON DEPOSIT 20,986,741$ LESS: FDIC INSURANCE 250,000$ LESS: FMV OF COLLATERAL ON DEPOSIT @ 10/31/2019 U.S. GOVERNMENT AGENCY OBLIGATIONS 25,241,150$ OVER (UNDER) COLLATERALIZED 4,504,409$ CASH ASSETS COLLATERALIZED @ FMV 10/31/19 122% 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 OCTOBER 31, 2019 NOTE: