Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2020-02 Monthly Financial Report
TOWN OF ITHACA FINANCIAL REPORTS FOR THE MONTH ENDED FEBRUARY 29, 2020 REPORTS: BALANCE SHEET REVENUE & EXPENSE SUMMARY and CASH & CASH EQUIVALENTS DETAILED CASH LISTING FOR FIDUCIARY FUNDS SUMMARY OF BANK COLLATERAL TOWN OF ITHACA REVENUE and EXPENSE SUMMARY FOR THE MONTH ENDED FEBRUARY29,2020 Page 1 of 4 GENERAL GENERAL HIGHWAY HIGHWAY RISK FIRE DESCRIPTION TOWNWIDE PART -TOWN TOWNWIDE PART -TOWN RETENTION PROTECTION FUND FUND FUND FUND FUND FUND REVENUE BUDGETED REVENUE $ 6,696,930 $ 1,585,650 $ 818,000 $ 2,978,500 $ 17,000 $ 3,296,000 ACTUAL & ACCRUED 3,175,706 25,027 804,011 1,462,717 398 3,224,443 REVENUE OVER UNDER $ 3,521,224 $ 1,560,623 $ 13,989 $ (1,515,783)' $ 16,602 $ 71,557 % OF BUDGET EARNED 47.4% 1.6% 98.3% 49.1% 2.3% 97.6% EXPENSE BUDGETED EXPENSE $ 6,918,847 $ 1,835,780 $ 802,523 $ 2,849,244 $ 17,000 $ 3,515,000 ACTUAL & ACCRUED 521,640 196,800 231,223 210,597 1,300 359,377 EXPENSE OVER UNDER $ (6,397,207) $1,638,980 $571 300 $ (2,638,647) $ (15,700) $ (3,155,623 % OF BUDGET EXPENDED 7.5% 10.7% 28.8% 7.4% 7.6% 10.2% ESTIMATED FUND BALANCE S 3,975,397 $ 1,848,152 $ 430,854 $ 3,734,597 $ 150,393 $ 1,807,884 FUND BALANCE - 01/01/2020 ACTUAL & ACCRUED ADD: REVENUE 3,175,706 25,027 804,011 1,462,717 398 3,224,443 LESS: EXPENSE 521,640 196,800 231,223 210,597 1,300 359,377 FUND BALANCE - 02/29/2020 $ 6,629,462 $ 1,676,379 ;$ 1,003,642 $ 4,986,717 $ 149,491 $ 4,672,950 CASH and CASH EQUIVALENTS UNRESERVED CASH CASH(CHECKING/SAVINGS) $ 27,006 S 4,645 $ 2,057 $ 7,440 $ 43 $ 156 CASH -SJC OPERATING - - - INVESTMENTS 5,551,957 1,691,004 995,014 4,641,786 149,448 4,964,085 PETTY CASH 700 - 200 TOTAL -UNRESERVED CASH $ 5,579,663 $ 1,695,649 $ 997,071 $ 4,649,426 $ 149,491 $ 4,964,241 RESERVED CASH PARKS & OPEN SPACE PLAN $ 31 $ - $ - $ - $ - $ - GENERAL PURPOSE BENEFIT 0 0 - 0 HIGHWAY EQUIPMENT - 49 - PRESERVE MAINTENANCE 20 - LAND STEWARDSHIP 27 - - - INVESTMENTS 1,185,825 70,943 452,937 - - FIDUCIARY FUNDS 29 - - - - - TOTAL -RESERVED CASH $ 1,185,931 $ 70,943 $ - $ 452,987 $ - $ TOTAL CASH - 02129/2020 $ 6,765,594 1$ 1,766,592 $ 997,071 1$ 5,102,413 1 $ 149,491 $ 4,964,241 Page 1 of 4 TOWN OF ITHACA REVENUE and EXPENSE SUMMARY FOR THE MONTH ENDED FEBRUARY29,2020 Page 2 of 4 CAPITAL LIGHTING DEBT TRUST& SEWER DESCRIPTION PROJECTS WATER FUND DISTRICT SERVICE AGENCY FUND FUNDS FUNDS FUND FUND REVENUE BUDGETED REVENUE $ - $ 5,552,798 $ 3,136,530 $ 32,750 $ 1,584,733 $ ACTUAL & ACCRUED 2,071 878,808 251,631 32,759 145 REVENUE OVER UNDER $ 2,071 $ 4673990 $ 2884,899 $ 9 $ 1,584,588 $ % OF BUDGET EARNED 0.0% 15.8% 1 8.0% 100.0% 0.0% EXPENSE BUDGETED EXPENSE $ - $ 5,460,007 $ 3,121,458 $ 87,345 $ 1,609,626 $ - ACTUAL & ACCRUED - (191,307) 72,532 1,205 15,804 - EXPENSE OVER UNDER $ - !$ (5,651,314) $ 3,048 926 $ (86,140) $ 1,593,822 $ % OF BUDGET EXPENDED 0.0% -3.5% 2.3% 1.4% 1.0% ESTIMATED FUND BALANCE $ 874,713 $ 7,133,504 $ 5,881,562 $ 15,619 $ 93,363 $ FUND BALANCE -01/01/2020 ACTUAL & ACCRUED ADD: REVENUE 2,071. 878,808 251,631 32,759 145 LESS: EXPENSE - (191,307) 72,532 1,205 15,804 - FUND BALANCE - 02/29/2020 $ 876,785 $ 8,203,618 i $ 6,060,661 $ 47,173 $ 77,704 $ CASH and CASH EQUIVALENTS UNRESERVED CASH CASH (CHECKING/SAVINGS) $ 104 $ 6,855 $ 4,707 $ 4,361 $ 17 $ CASH - SJC OPERATING - 126 INVESTMENTS 844,277 2,953,23 4 3,362,076 42,786 77,68 6 PETTY CASH TOTAL - UNRESERVED CASH $ 844,381 $ 2,960,089 $ 3,366,910 $ 47,146 $ 77,704 $ RESERVED CASH PARKS & OPEN SPACE PLAN $ - $ - $ - $ - $ - $ GENERAL PURPOSE BENEFIT - 0 0 - - HIGHWAY EQUIPMENT - - - PRESERVE MAINTENANCE - - - LAND STEWARDSHIP - - - INVESTMENTS - 24,345 12,301 - 249,674 FIDUCIARY FUNDS - - - - 25,311 $ - $ 24,345 $ 12,301 $ - $ - $ 274,985 TOTAL - RESERVED CASH TOTAL CASH .02129/2020 $ 644,381 $ 2,984 433 1$ 3,379.211 1 $ 47,146 1$ 77,704 i$ 274,985 Page 2 of 4 TOWN OF ITHACA REVENUE and EXPENSE SUMMARY for CAPITAL PROJECTS FOR THE MONTH ENDED FEBRUARY29,2020 ACTIVE CAPITAL PROJECTS DESCRIPTION FUND H7 Route 96B Sidewalk FUND H9 Gateway Trail (Grant Funding) FUND H10 Ellis Hollow Water Tank FUND H14 FUND H15 Muriel Street Water Main FUND H21 Sand Bank Rd Improvements 1 FUND H22 PWF Office Expansion TOTAL CAPITAL I PROJECTS Winthrop Dr I Water Main REVENUE BUDGETED REVENUE $ - $ - $ - $ - $ - $ - $ - $ - ACTUAL 8 ACCRUED 523 124 371 - - 1,053 - 2,071 REVENUE OVER UNDER $ 523 $ 124 $ 371 $ - $ - $ 1,053 $ h OF BUDGET EARNED 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% EXPENSE BUDGETED EXPENSE $ - $ - $ - $ - $ - $ - S - S - ACTUAL 8 ACCRUED - - - - - - - - EXPENSEOVER UNDER $ - $ - $ - $ - $ - $ $ b k OF BUDGET EXPENDED 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% FUND BALANCE -0110112020 $ 270,795 $ 69,717 $ 166,732 $ - $ - $ 367,469 $ - $ 874,713 ACTUAL & ACCRUED 12 S - $ 104 INVESTMENTS ADD: REVENUE 523 124 371 - - 1,053 2,071 Less: EXPENSE - - - - - - - FUNDBALANCE -02129/1020 $ 271,318 $ 69,841 $ 167,103 $ - $ - $ 368,522 $ S 876,785 CASH and CASH(CHECKINGISAMNGS) $ 20 $ 23 $ 49 $ - $ - 5 12 S - $ 104 INVESTMENTS 253,113 55,550 167,103 - - 368,510 - 844,277 TOTAL CASH - 0212912020 $ 253,134 $ 55,573 $ 167,152 $ $ - $ 368,522 $ - $ 844,381 Page 3 of 4 TOWN OF ITHACA REVENUE and EXPENSE SUMMARY for LIGHT DISTRICTS FOR THE MONTH ENDED FEBRUARY 29, 2020 DESCRIPTION FUNDSLA FUND SL -2 FUND SL -3 FUND SL -4 FUND SL -5 FUND SL -6 FUND SL -7 FUND SL -8 FUND SL -9 TOTAL LIGHT Forest $ 2,241 Renwick Eastwood $ 635 $ 1,503 Winner's Burleigh Westhaven Coddington ACTUAL & ACCRUED 8,159 Glenside 3,143 4,208 Clover Lane 2,273 6,485 4,111 32,759 REVENUE OVER UNDER $ 7 Home $ 0 Heigh[s Commons $ 0 Circle Drive Road Road DISTRICTS REVENUE CASH EQUIVALENTS BUDGETED REVENUE $ 8,152 $ 2,241 $ 3,143 $ 4,208 $ 635 $ 1,503 $ 2,273 $ 6,484 $ 4,111 $ 32,750 ACTUAL & ACCRUED 8,159 2,241 3,143 4,208 635 1,503 2,273 6,485 4,111 32,759 REVENUE OVER UNDER $ 7 $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 1 $ 0 $ 9 OF BUDGET EARNED 100.1% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% EXPENSE CASH EQUIVALENTS BUDGETED EXPENSE $ 20,150 $ 7,240 $ 9,743 $ 9,508 $ 11835 $ 3,203 $ 6,473 $ 17,883 $ 11,310 $ 87,345 ACTUAL & ACCRUED 219 81 102 204 24 74 82 262 155 1,205 EXPENSE OVER UNDER $ 19,931 $ 7,159 $ 9,641 $ 9,304 $ (1,811) $ 3,129 $ 6,391 $ 17,621 $ 11,155 $(EK140fl 1,503 % OF BUDGET EXPENDED 1.1% 1.1% 1.0% 2.1% 1.3% 2.3% 1.3% 1.5% 1.4% 1.4% ESTIMATED FUND BALANCE CASH EQUIVALENTS FUND BALANCE -0110112020 $ 5,576 $ 955 $ 949 $ 1,724 $ 220 $ 557 $ 1,018 $ 2,615 $ 2,004 $ 15,619 ACTUAL & ACCRUED 849 $ 4,361 INVESTMENTS 13,188 2,741 3,643 5,108 735 1,703 2,773 7,784 5,111 42,786 TOTAL CASH - 0212912020 ADD: REVENUE 8,159 2,241 3,143 4,208 635 1,503 2,273 6,485 4,111 32,759 LESS: EXPENSE 219 81 102 204 24 74 82 262 155 1,205 FUND BALANCE -0212912020 $ 13,516 $ 31115 $ 3,990 $ 5,729 $ 831 $ 1,987 $ 3,208 $ 8,838 $ 5,960 $ 47,173 CASH and CASH EQUIVALENTS CASH (CHECKING/SAVINGS) $ 328 $ 347 $ 347 $ 621 $ 96 $ 284 $ 435 $ 1,054 $ 849 $ 4,361 INVESTMENTS 13,188 2,741 3,643 5,108 735 1,703 2,773 7,784 5,111 42,786 TOTAL CASH - 0212912020 $ 13,516 $ 3 088 $ 3,990 $ 5,729 $ 831 $ 1,987 $ 3,208 $ 8,838 $ 5960 $ 47,146 Page 4 of 4 TOWN OF ITHACA BALANCE SHEET FOR THE MONTH ENDED FEBRUARY29,2020 Page 1 of 4 GENERAL GENERAL HIGHWAY HIGHWAY RISK FIRE DESCRIPTION TOWNWIDE PART -TOWN TO NWIDE PART -TOWN RETENTION PROTECTION FUND FUND FUND FUND FUND FUND ASSETS UNRESERVED CASH: CASH $ 27,006 $ 4,645 $ 2,057 $ 7,440 $ 43 $ 156 INVESTMENTS 5,551,957 1,691,004 995,014 4,641,786 149,448 4,964,085 PETTY CASH 700 - 200 TOTAL - UNRESERVED CASH $ 5,579,663 $ 1,695,649 $ 997,071 $ 4,649,426 $ 149,491 $ 4,964,241 RESERVED CASH: PARKS & OPEN SPACE PLAN $ 31 $ - $ $ - $ - $ GENERAL PURPOSE BENEFIT 0 0 0 HIGHWAY EQUIPMENT - - _ 49 _ PRESERVE MAINTENANCE 20 - - - LAND STEWARDSHIP 27 - - - INVESTMENTS 1,185,825 70,943 - 452,937 - - FIDUCIARY FUNDS 29 - - - TOTAL - RESERVED CASH $ 1,185,931 $ 70,943 $ - $ 452,987 $ - $ - OTHER ASSETS: ACCOUNTS RECEIVABLE $ 18,338 $ 10,000 $ - $ - $ - $ WATER & SEWER RECEIVABLES DUE FROM OTHER FUNDS - STATE & FEDERAL AID RECEIVABLE 146,434 48,605 - - DUE FROM OTHER GOVTS - - PREPAID EXPENSES 70,839 29,262 6,571 21,969 - TAXES RECEIVABLE - CURRENT - - _ _ _ TOTAL - OTHER ASSETS $ 235,610 $ 87,867 $ 6,571 $ 21,969 $ - $ TOTALASSETS $ 7,001,205 $ 1,854,459 $ 1,003,642 $ 5,124,382 $ 149,491 $ 4,964,241 LIABILITIES and FUND BALANCE $ - $ - $ - $ - $ - $ ACCOUNTS PAYABLE ACCRUED LIABILITIES 371,743 178,080 122,490 - 291,291 DUE TO OTHER FUNDS - - - - _ DUE TO OTHER GOVERNMENTS - - - - _ RETAINAGE - - - 15,478 - DEFERRED REVENUE - RESERVED FUND BALANCE 1,185,931 70,943 - 452,987 - UNRESERVED FUND BALANCE 5,443,531 1,605,436 1,003,642 4,533,427 149,491 4,672,950 TOTAL LIABILITIES & FUND BALANCE $ 7,001,205 $ 1,854,459. $ 1,003,642 $ 5,124,382 $ 149,491 $ 4,964,241 ESTIMATED FUND BALANCE $ 3,975,397 $ 1,848,152 $ 430,854 $ 3,734,597 $ 150,393 $ 1,807,884 FUND BALANCE -01/0112020 ADD: REVENUE 3,175,706 25,027 804,011 1,462,717 398 3,224,443 LE58: EXPENSE 521,640 196,800 231,223 210,597 1,300 359,377 FUND BALANCE - 02/29/2020 $ 6,629,462 $ 1,676,379 $ 1,003,642 $ 4,986,717 $ 149,491 $ 4,672,950 Page 1 of 4 TOWN OF ITHACA BALANCE SHEET FOR THE MONTH ENDED FEBRUARY29,2020 Pape 2 of 4 CAPITAL LIGHTING DEBT TRUST & DESCRIPTION PROJECTS WATER FUND SEWER DISTRICT SERVICE AGENCY FUND FUNDS FUNDS FUND FUND ASSETS UNRESERVED CASH: CASH $ 104 $ 6,855 $ 4,833 $ 4,361 $ 17 $ INVESTMENTS 844,277 2,953,234 3,362,076 42,786 77,686 PETTY CASH - TOTAL - UNRESERVED CASH $ 844,381 $ 2,960,089 $ 3,366,910 $ 47,146 $ 77,704 $ RESERVED CASH: PARKS & OPEN SPACE PLAN $ - $ - $ - $ - $ - $ GENERAL PURPOSE BENEFIT - 0 0 - HIGHWAY EQUIPMENT - - PRESERVE MAINTENANCE - - - - LAND STEWARDSHIP - - - - - INVESTMENTS - 24,345 12,301 - - 249,674 FIDUCIARY FUNDS - - - - - 25,311 $ - $ 24,345 $ 12,301 S - $ - $ 274,985 TOTAL • RESERVED CASH OTHER ASSETS: FIXED ASSETS $ - $ 15,848,766 $ 3,020,828 $ - $ - $ WATER & SEWER RECEIVABLES - 169,210 96,099 - - - TAXES RECEIVABLE - - - - - - STATE & FEDERAL AID RECEIVABLE 32,333 - - - - DUE FROM OTHER GOV'TS 126 1,596,187 - - - PREPAID EXPENSES - - - - - DEFERRED OUTFLOW OF RESOURCE - 69,936 53,093 - - $ 32,459 $ 17,684,098 $ 3,170,020 $ - $ - $ - TOTAL - OTHER ASSETS TOTAL ASSETS $ 876,840 $ 20,668,532 $ 6,549,231 1$ 47,146 $ 77,704 $ 274,985 LIABILITIES and FUND BALANCE - 322,990 93,700 - - 274,985 ACCRUED LIABILITIES DUE TO OTHER GOVERNMENTS - - 8,000 - - DUE TO OTHER FUNDS - - - - RETAINAGE - 44,700 4,890 - - - BONDS PAYABLE - 11,589,861 - - BOND INTEREST PAYABLE 45,988 - BOND PREMIUM 93,484 NET PENSION LIABILITY 44,263 25,230 - OPEB LIABILITY - 462,363 321,983 - - COMPENSATED ABSENCES - 12,619 6,561 - - - DEFERRED INFLOW OF RESOURCES - 52,897 51,799 - - - RESERVED FUND BALANCE - 24,345 12,301 - - UNRESERVED FUND BALANCE 876,840 7,975,022 6,022,767 47,146 77,704 TOTAL LIABILITIES & FUND BALANCE $ 876,840 $ 20,668,532 $ 6,549,231 $ 47,146 $ 77,704 $ 274,985 ESTIMATED FUND BALANCE $ 874,713 $ 7,133,504 $ 5,881,562 $ 15,619 $ 93,363 $ FUND BALANCE - 01/01/2020 ADD: REVENUE 2,071 878,808 251,631 32,759 145 LESS: EXPENSE - (191,307] 72,532 1,205 15,804 - FUND BALANCE - 02/29/2020 $ 876,785 $ 8,203,618 $ 6,060,661 $ 47,173 $ 77,704 1$ Pape 2 of 4 TOWN OF ITHACA BALANCE SHEET for CAPITAL PROJECTS FOR THE MONTH ENDED FEBRUARY 29. 2020 ACTIVE CAPITAL PROJECTS ASSETS CASH $ 20 $ 23 $ 49 $ - $ - $ 12 $ - $ 104 INVESTMENTS 253,113 55,550 167,103 368,510 844,277 TOTAL • UNRESERVED CASH $ 253,134 $ 55,573 $ 167,152 $ - $ - $ 368,522 $ - $ 844,381 OTHER ASSETS: FUND H7 FUND HB FUND H10 FUND H14 FUND HIS FUND H21 FUND H22 TOTAL DESCRIPTION Roure 968 Gatewry Trail Ellis Hollow I Wlnlhm. or Muriel Street Band Bank Rd PWF Office CAPITAL CUSTOMER RECEIVABLE Sidewalk (Grant Funding) Water Tank Watm Main Water Main Improvement Expansion PROJECTS ASSETS CASH $ 20 $ 23 $ 49 $ - $ - $ 12 $ - $ 104 INVESTMENTS 253,113 55,550 167,103 368,510 844,277 TOTAL • UNRESERVED CASH $ 253,134 $ 55,573 $ 167,152 $ - $ - $ 368,522 $ - $ 844,381 OTHER ASSETS: FUND BALANCE -0110112020 $ 270,795 $ 69.717 S ACCOUNTS RECEIVABLE $ - $ - $ $ - $ - $ - $ - $ - CUSTOMER RECEIVABLE - - - - - - - - 69,841 $ DUE FROM OTHER FUNDS - $ - $ 368.522 $ - - - - - - - - STATEIFEDERAL RECEIVABLE 18,190 14,143 - - - - - 32,333 DUE FROM OTHER GOV'rS - 126 - - - - - 126 PREPAID EXPENSES - - - - - BAN LOANS TOTAL -OTHER ASSETS $ 18,190 $ 14,268 $ - $ - $ - $ - $ - $ 32,459 TOTAL ASSETS $ 271,324 $ 69,841 $ 167,152 $ - $ - $ 368,522 $ - S 878840 LIABILITIES 6 FUND BALANCE ACCOUNTS PAYABLE $ - $ - $ - $ - $ - $ - $ $ - ACCRUED LIABILUTES - - - - - - - DUE TO OTHER FUNDS - - - - - - RETAINAGE - - - - - - - BAN PAYABLE - - - - - - - RESERVEDFUNDBALANCE - - - - - - - UNRESERVEDFUNDBALANCE 271,324 69,841 167,152 - 368,522 - 876,840 TOTAL LIAB 8 FUND BALANCE $ 271,324 $ 69,941 $ 167.152 $ - $ $ 368.522 $ S 878,840 ES77PAATED FUND BALANCE FUND BALANCE -0110112020 $ 270,795 $ 69.717 S 166,732 $ - $ - $ 367,469 $ - $ 874,713 ADD: REVENUE 523 124 371 - 1,053 - 2,071 LE65: EXPENSE - - - - - - - FUNDBALANCE -0212912020 $ 271,316 $ 69,841 $ 167,103 $ - $ - $ 368.522 $ - 8 878,785 Page 3 of 4 TOWN OF ITHACA BALANCE SHEET for LIGHT DISTRICTS FOR THE MONTH ENDED FEBRUARY 29, 2020 DESCRIPTION FUND SL -1 FUND SL -2 FUND SL -3 FUNDSLA FUND SL -5 FUNDS FUND SL -7 FUND SL -8 FUND SL -9 TOTAL LIGHT DISTRICTS Forest Home Glenside I Remvick I Heights Eastwood Commons Clover Lane I Winner's I Circle Burleigh Drive Westhaven Road Coddington Road 2,004 $ 15,619 DUE FROM OTHER FUNDS 8,159 2,241 3,143 4,208 635 1,503 2,273 6,485 ASSETS UNRESERVED CASH: CASH $ 328 $ 347 $ 347 $ 621 $ 96 $ 284 $ 435 $ 1,054 $ 849 $ 4,361 INVESTMENTS 13,188 2,741 3,643 5,108 735 1,703 2,773 7,784 5,111 42,786 TOTAL -UNRESERVED CASH $ 13,516 $ 3,088 $ 3,990 $ 5,729 $ 831 $ 1,987 $ 3,208 $ 8,838 $ 5,960 $ 47,146 OTHER ASSETS ACCOUNTS RECEIVABLE $ - $ - $ - $ - $ - $ - $ - $ CUSTOMER RECEIVABLE $ 5,576 $ 955 $ 949 $ 1,724 $ 220 $ 557 $ 1,018 $ 2,615 $ 2,004 $ 15,619 DUE FROM OTHER FUNDS 8,159 2,241 3,143 4,208 635 1,503 2,273 6,485 4,111 32,759 STATE & FEDERAL AID RECEIVABLE 219 81 102 204 24 74 82 262 155 1,205 PREPAID EXPENSES $ 13,516 $ 3,115 $ 3,990 $ 5,729 $ 831 $ 1987 E 3,208 $ 8,838 $ 5,960 $ 47,173 TAXES RECEIVABLE - CURRENT - - - TOTAL - OTHER ASSETS $ - $ - $ $ - $ - $ _ $ $ _ $ $ TOTAL ASSETS $ 13,516 $ 3,088 $ 3,990 $ 5,729 $ 831 $ 1,987 $ 3,208 $ 8,838 $ 5,960 $ 47,146 LIABIL177ES and FUND BALANCE ACCOUNTSPAYABLE $- ACCRUED LIABILIITES DUE TO OTHER FUNDS DEFERRED REVENUE RESERVED FUND BALANCE UNRESERVED FUND BALANCE 13,516 3,088 3,990 5,729 831 1,987 3,208 8,838 51960 47,146 TOTAL LIABILITIES & FUND BALANCE $ 13,516 $ 3,088 $ 3,990 $ 5,729 $ 831 $ 1,987 $ 3,208 $ 8,838 $ 5,960 $ 47,146 ESTIMATED FUND BALANCE FUND BALANCE - 0110112 0 20 $ 5,576 $ 955 $ 949 $ 1,724 $ 220 $ 557 $ 1,018 $ 2,615 $ 2,004 $ 15,619 ADD: REVENUE 8,159 2,241 3,143 4,208 635 1,503 2,273 6,485 4,111 32,759 LESS: EXPENSE 219 81 102 204 24 74 82 262 155 1,205 FUND BALANCE -0212912020 $ 13,516 $ 3,115 $ 3,990 $ 5,729 $ 831 $ 1987 E 3,208 $ 8,838 $ 5,960 $ 47,173 Page 4 of 4 TOWN OF ITHACA DETAILED CASH LISTING - FIDUCIARY FUNDS FOR THE MONTH ENDED FEBRUARY 29, 2020 DESCRIPTION AMOUNT TRUST & AGENCY FUND TA200C DISBURSEMENTS CHECKING $ - TA200P PAYROLL CHECKING 10,287.08 TA201 CASH IN TIME DEPOSITS 30,625.59 TA202 ON-LINE COLLECTIONS 16.49 TA203 CASH IN SHORT TERM INVESTMENTS 2199048.01 TA205 ROAD USE AGREEMENTS 36.05 TA206 ITHACA TOWERS OPTION ESCROW 43.39 TA207 UNCLAIMED BAIL - ITHACA TOWN COURT 2.52 TA209 EMPLOYEE FLEXIBLE SPENDING 14,832.07 TA210 STORMWATER COALITION 9.81 TA211 PLANNING DEPOSITS 41.91 TA212 CAYUGA LAKE WATERSHED INTERMUNICIPAL ORG 8.10 TA214 LAKE VIEW CEMETERY - PERMANENT MAINT FUND 17.88 TA215 LAKE VIEW CEMETERY - FERRIS MEMORIAL FUND 13.04 TA217 TIER 6 RETIREMENT ESCROW 2.90 TOTAL CASH: TRUST & AGENCY FUND $ 274,984.84 GENERAL TOWNWIDE FUND A237 INLET VALLEY CEMETERY $ 28.87 TOTAL..CASH;, FIDUCIARY FUNDS$ 275;013.1 Road Use Agreements: $ 1,750.00 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 Bid 1,000.00 R B Robinson Contracting - Snyder Hill Road 1,000.00 Walczak Excavating -104 Grove Place 1,000.00 Accrued Interest - transfer to General Fund 207.39 Total - Road Use Agreements $ 36,643.39 TA38 Plannina Deposits: Nextel Site Lease Deposit $ 4,510.32 Wireless One Site Lease Deposit 4,601.43 History Center Lease Deposit 400.00 Accrued Interest - transfer to General Fund 102.65 Total - Planning Deposits $ 9,614.40 TA43 Unclaimed Bail - Ithaca Town Court: TB Resolution No. 2016-166, adopted 12/12/2016 $ 1,750.00 Exp. 12112/2022 TB Resolution No. 2017-075c, adopted 6/26/2017 1,400.00 Exp. 6/26/2023 TB Resolution No. 2018-147, adopted 11/19/2018 250.00 Exp. 10109/2024 Accrued Interest - transfer to General Fund 2.52 Total - Unclaimed Bail - Ithaca Town Court $ 3,402.52 TA35 TOWN OF ITHACA SUMMARY OF BANK COLLATERAL FOR THE MONTH ENDED FEBRUARY 29, 2020 TOMPKINS TRUST COMPANY.- CASH OMPANY.CASH & CASH EQUIVALENTS $ 83,886 INVESTMENTS TOTAL CASH ON DEPOSIT LESS: FDIC INSURANCE $ 27,269,377 $ 27,353,263 $ 250,000 LESS: FMV OF COLLATERAL ON DEPOSIT @ 11/3012019 U.S. GOVERNMENT AGENCY OBLIGATIONS $ 36,660,510 OVER (UNDER) COLLATERALIZED $ 9,557,247 CASH ASSETS COLLATERALIZED @ FMV 11/30/19 135% 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. NOTE: For deposits in excess of FDIC coverage, General Municipal Law, section 10 requires that the excess amounts are to be secured by eligible collateral.