Loading...
HomeMy WebLinkAbout2019-04 Financial ReportF_11:11 ��� • REPORTS: BALANCE SHEET REVENUE & EXPENSE SUMMARY and CASH & CASH EQUIVALENTS DETAILED CASH LISTING FOR FIDUCIARY FUNDS TOWN OF ITHACA BALANCE SHEET FOR THE MONTH ENDED APRIL 30, 2019 Page 1 of 4 GENERAL GENERAL HIGHWAY HIGHWAY DESCRIPTION TOWNWIDE PART -TOWN TOWNWIDE PART -TOWN WATER SEWER FUND FUND FUND FUND FUND FUND ASSETS UNRESERVED CASH: CASH $ 1,930,981 $ 427,072 $ 286,157 $ 672,707 $ 693,232 $ 317,394 INVESTMENTS 4,002,470 775,226 375,309 2,751,441 2,101,729 2,251,029 PETTY CASH 700 200 TOTAL - UNRESERVED CASH $ 5,934,151 $ 1,202,298 $ 661,466 $ 3,424,348 $ 2,794,961 $ 2,568,423 RESERVED CASH: PARKS & OPEN SPACE PLAN $ 33,239 $ - $ - $ - $ $ - GENERAL PURPOSE BENEFIT 194 96 144 48 50 HIGHWAY EQUIPMENT - 3,023 PRESERVE MAINTENANCE 190 LAND STEWARDSHIP 756 - INVESTMENTS 1,118,291 69,400 360,316 23,800 12,000 FIDUCIARY FUNDS 928 TOTAL - RESERVED CASH $ 1,153,597 $ 69,496 $ - $ 363,483 $ 23,848 $ 12,050 OTHER ASSETS: ACCOUNTS RECEIVABLE $ - $ - $ - $ _ $ - $ WATER & SEWER RECEIVABLES 66,835 45,078 DUE FROM OTHER FUNDS 5,476 STATE & FEDERAL AID RECEIVABLE DUE FROM OTHER GOWTS 10,815 24,737 PREPAID EXPENSES 8,315 TAXES RECEIVABLE - CURRENT TOTAL - OTHER ASSETS $ 13,791 $ 10,815 $ - $ -1$ 91,571 $ 45,078 TOTAL ASSETS 7101 539 1,282,609 661.466 3.787.830 2.910,381 2,62§.,552 LIABILITIES and FUND BALANCE $ - $ - $ - $ $ _ $ ACCOUNTS PAYABLE ACCRUED LIABILITIES 288,592 209,737 135,473. (130) 16,000 DUE TO OTHER FUNDS RETAINAGE 2,000 7,190 DEFERRED REVENUE RESERVED FUND BALANCE 1,153,597 695496 363,483 23,848 12,050 UNRESERVED FUND BALANCE 5,659,350 1,003,376 661,466 3,286,875 2,886,662 2,590,311 TOTAL LIABILITIES & FUND BALANCE 7101 539 1,282,609 661 466 S 3-797-930 2 910 381 2 625 552 ESTIMATED FUND BALANCE FUND BALANCE - 01/01/2019 $ 4,262,061 $ 1,223,969 $ 243,125 $ 2,670,329 $ 3,057,301 $ 2,512,811 ADD: REVENUE 4,054,151 395,773 814,216 1,861,326 2,061,630 995,351 LESS: EXPENSE 1,503,265 546,870 3951875 881,298 2,208,421 905,800 FUND BALANCE - 04/3012019 6 812 948 1,072,872 661,466 3,650,557 2 910 510 2,602.361j Page 1 of 4 TOWN OF ITHACA BALANCE SHEET FOR THE MONTH ENDED APRIL 30, 2019 Page 2 of 4 CAPITAL RISK FIRE LIGHTING DEBT TRUST & DESCRIPTION PROJECTS RETENTION PROTECTION DISTRICT SERVICE AGENCY FUNDS FUND FUND FUNDS FUND FUND ASSETS UNRESERVED CASH: CASH $ 70,717 $ 7,280 $ 42,639 $ 28,752 $ 58,277 $ INVESTMENTS PETTY CASH 795,358 140,033 4,502,470 1,501,235 TOTAL - UNRESERVED CASH $ 866,075 $ 147,313 $ 4,545,109 $ 28,752 $ 1,559,512 $ RESERVED CASH: PARKS & OPEN SPACE PLAN GENERAL PURPOSE BENEFIT $ - $ - $ _ $ _ $ _ $ HIGHWAY EQUIPMENT PRESERVE MAINTENANCE LAND STEWARDSHIP INVESTMENTS FIDUCIARY FUNDS TOTAL - RESERVED CASH 30,000 443,824 $ - $ - $ - $ - $ - $ 473,824 OTHER ASSETS: ACCOUNTS RECEIVABLE CUSTOMER RECEIVABLE $ - $ - $ $ _ $ _ $ DUE FROM OTHER FUNDS STATE & FEDERAL AID RECEIVABLE _ DUE FROM OTHER GOUTS 1,034 PREPAID EXPENSES TAXES RECEIVABLE - CURRENT TOTAL - OTHER ASSETS $ 1,034 is $ - $ - $ _ $ _ $ TOTAL ASSETS 867,109 147.313 4.545.109 28.752 1.559.512 473,824 LIABILITIES and FUND BALANCE $ - $ _ $ _ $ _ $ _ $ 473,824 ACCOUNTS PAYABLE ACCRUED LIABILITIES DUE TO OTHER FUNDS RETAINAGE 90,131 DEFERRED REVENUE RESERVED FUND BALANCE UNRESERVED FUND BALANCE 776,978 147,313 4,545,109 28,752 1,559,512 TOTAL LIABILITIES & FUND BALANCE 867109 147.313 4.545.109 28.752 ".559,512 473.824 ESTIMATED FUND BALANCE $ 999,875 $ 149,222 $ 2,010,351 $ 14,488 $ 98,165 $ FUND BALANCE - 01/01/2019 ADD: REVENUE 821 101 3,160,010 18,017 1,621,621 LESS: EXPENSE 223,717 2,010 625,253 35753 160,274 FUND BALANCE - 04/30/2019 776,9791$ 147.3131$ 4. 545109 28 752 1 559 512 Page 2 of 4 TOWN OF ITHACA BALANCE SHEET for CAPITAL PROJECTS FOR THE MONTH ENDED APRIL 30, 2019 .,ACTIV I -,PROJECTS, -PROJECTSl ,,,E;2ETAL JCLOSEDCAPITAL FUND H7 FUND He FUND H9 FUND H10 I FUND HlI FUND H12 FUND H13 I FUND H21 1 1 TOTAL DESCRIPTION Route 968 Gateway Trail T-sburg Ellis Hollow I ParkLano Sapsuckerwds Christopher Cir Sand Bank Rd I I CAPITAL ASSETS $ $ $ $ $ $ $ $ $ $ ACCRUED LIABILUTES $ 180A50 $ 72,627 S 5,927 $ 339,363 $ 27,592 $ 7,727 $ 5,325 $ 360,866 $ S $ 999,875 DUE TO OTHER FUNDS 202 83 - 821 RETAINAGE UNRESERVED CASH: 8,361 90,131 BAN PAYABLE 173586 $ 72,711 5-931 $ 123,040 $ 27,641 S 77-32 S 6.328 $ 361,011 $ - RESERVED FUND BALANCE - - UNRESERVED FUND BALANCE 173,586 72,711 6,930 123,040 CASH $ 22,554 $ 22,644 $ 5,930 $ 4,646 S 973 $ 7,732 $ 5,328 $ 1,011 S $ $ 70,717 INVESTMENTS 150,124 50,041 . 200,166 35,029 - 360,000 795,358 TOTAL - UNRESERVED CASH $ 172,677 $ 72,586 $ 5,930 $ 204,811 S 36,002 $ 7,732 S 5,328 $ 361,011 $ $ $ 866,075 OTHER ASSETS: ACCOUNTS RECEIVABLE $ - $ $ $ $ - $ $ $ $ $ $ CUSTOMER RECEIVABLE DUE FROM OTHER FUNDS STATE/FEDERAL RECEIVABLE - DUE FROM OTHER GOVTS 909 126 1,034 PREPAID EXPENSES BAN LOANS TOTAL - OTHER ASSETS $ 909 $ 126 $ $ $ $ $ $ $ $ - 1,034 ITOTAL ASSETS $ 173 S6 $ 72,711 $ 5 -9" $ 204,811 $ 36,002 $ 7,732 $ 5,328 $ 361,011 $ $ $ 867-109 ACCOUNTS PAYABLE $ $ $ $ $ $ $ $ $ $ ACCRUED LIABILUTES $ 180A50 $ 72,627 S 5,927 $ 339,363 $ 27,592 $ 7,727 $ 5,325 $ 360,866 $ S $ 999,875 DUE TO OTHER FUNDS 202 83 - 821 RETAINAGE 81,771 8,361 90,131 BAN PAYABLE 173586 $ 72,711 5-931 $ 123,040 $ 27,641 S 77-32 S 6.328 $ 361,011 $ - RESERVED FUND BALANCE - - UNRESERVED FUND BALANCE 173,586 72,711 6,930 123,040 27,641 7,732 5,328 361,011 776,978 TOTAL LIAR & FUNO BALANCE $ 173,586 $ 72,711 5 93 $ 2G4,811 $ 36,002 $ 7;732 S 5,328 $ 361,011 $ $ 8767:1-09 ESTIMATED FUND BALANCE,, FUND BALANCE -01/0112019 $ 180A50 $ 72,627 S 5,927 $ 339,363 $ 27,592 $ 7,727 $ 5,325 $ 360,866 $ S $ 999,875 Am: REVENUE 202 83 4 328 49 5 4 145 821 LESS: EXPENSE 7,066 - 216,651 223,717 IFUND BALANCE - 041=01_9S 173586 $ 72,711 5-931 $ 123,040 $ 27,641 S 77-32 S 6.328 $ 361,011 $ $ $ 776 979 Page 3 of 4 TOWN OF ITHACA BALANCE SHEET for LIGHT DISTRICTS FOR THE MONTH ENDED APRIL 30, 2019 DESCRIPTION FUNDSL-I Forest Home I FUND SL -2 Glenside � FUND SL -3 Renwick Heights I FUND SL -4 Eastwood Commons FUND SL -5 Clover Lane FUND SL -6 Winner' a Circle FUND SL -7 It Burleigh Drive FUND SL -8 Westhaven I Road 'SL4-r I Cuddington Road ad TOTAL LIGHT DISTRICTS DISTRICTS ASSETS STATE & FEDERAL AID RECEIVABLE 1,004 $ 836 $ 1,418 $ PREPAID EXPENSES 433 $ 881 $ 2,357 $ TAXES RECEIVABLE - CURRENT 14,488 UNRESERVED CASH: 5,304 TOTAL - OTHER ASSETS $ $ $ $ $ $ $ $ $ $ TOTAL ASSETS $ 10,243 $ 1,656 1 1,821 $ 3,493 $ 428 $ 1,209 1 1,727 § 4,847 $ 3,328 1:: 28 752 18,017 CASH $ 10,243 $ 1,656 $ 1,821 $ 3,493 $ 428 $ 1,209 $ 1,727 $ 4,847 $ - 3,328 $ 28,752 INVESTMENTS - - 1 A21 $ 3,493 $ 428 $ - 1,727 $ 4-847 1 3,328�28 752 TOTAL - UNRESERVED CASH $ 10,243 $ 1,656 $ 1,821 $ 3,493 $ 428 $ 1,209 $ 1,727 $ 4,847 $ 3,328 $ 28,752 OTHER ASSETS: ACCOUNTS RECEIVABLE $ $ $ $ $ $ $ $ $ $ CUSTOMER RECEIVABLE DUE FROM OTHER FUNDS FUND BALANCE - 01/01/2019 STATE & FEDERAL AID RECEIVABLE 1,004 $ 836 $ 1,418 $ PREPAID EXPENSES 433 $ 881 $ 2,357 $ TAXES RECEIVABLE - CURRENT 14,488 ADD: REVENUE 5,304 TOTAL - OTHER ASSETS $ $ $ $ $ $ $ $ $ $ TOTAL ASSETS $ 10,243 $ 1,656 1 1,821 $ 3,493 $ 428 $ 1,209 1 1,727 § 4,847 $ 3,328 1:: 28 752 LIABILITIES and FUND BALANCE ACCOUNTS PAYABLE $ $ $ $ $ $ $ $ $ $ ACCRUED LIABILIITES DUE TO OTHER FUNDS DEFERRED REVENUE RESERVED FUND BALANCE UNRESERVED FUND BALANCE 10,243 1,656 1,821 3,493 428 1,209 1,727 4,847 3,328 28,752 [TOTAL LIABILITIES FUND BALANCE 10,243 1,656 $ 1,821 3,493 428 $ 1,209 $ 1.727 S 4,847 $ 3 328 28 752 ESTIMATED FUND BALANCE FUND BALANCE - 01/01/2019 $ 5,649 $ 1,004 $ 836 $ 1,418 $ 202 $ 433 $ 881 $ 2,357 $ 1,708 $ 14,488 ADD: REVENUE 5,304 901 1,301 2,702 300 1,001 1,101 3,303 2,102 18,017 LESS: EXPENSE 710 250 317 627 74 225 254 813 482 3,753 FUND BALANCE - 04130/2019 $ 10,243 $ 1,656 S 1 A21 $ 3,493 $ 428 $ 1,209 $ 1,727 $ 4-847 1 3,328�28 752 Page 4 of 4 REVENUE and EXPENSE SUMMARY Page 1 of 4 GENERAL GENERAL HIGHWAY HIGHWAY WATER SEWER DESCRIPTION TOWNWIDE PART -TOWN TOWNWIDE PART -TOWN FUND FUND FUND FUND . - FUND ' FUND REVENUE , BUDGETED REVENUE $ 5,523,736 $ 1,597,150 $ 813,750 $ 3,117,000 I $ 6,641,822 $ 2,833,445 ACTUAL & ACCRUED 4,054,151 395,773 814,216 1,861,326 fl 2,061,630 995,351 REVENUE OVER UNDER) $ (1,469,585)1$ 1 01 377 I $ 466f$ 1 255 674 $ K660,102) $ 838 094 % OF BUDGET EARNED 73.4% i 24.8% 100.1% 59.7% 31.0% 35.1% EXPENSE ! BUDGETED EXPENSE $ 5,938,282 $ 1,857,520 $ 714,840 $ 3,440,050 $ 6,694,528 $ 2,876,445 ACTUAL & ACCRUED 1,503,265 546,870 395,875 881,2981 2,208,421 905,800 EXPENSE OVER:` UNDER 4 435 `017 1 3i.0"650: 318 96'5 = 2 558 752 =:4%4861;07. .:: 1 9.711545 ' % BUDGET EXPENDED 25.3% 29.4% 55.4% 25.6% 33.0% 31.5% ESTIMATED FUND BALANCE $ 4,262,061 $ 1,223,969 $ 243,125 $ 2,670,329 $ 3,057,301 $ 2,512,811 FUND BALANCE - 01101/2019 ACTUAL & ACCRUED ADD: REVENUE 4,054,151 395,773 814,216 1,861,326 2,061,630 995,351 LESS: EXPENSE 1,503,265 546,870 395,875 881,298 2,208,421 905,800 FUND BALANCE-: 04/3072019 $ 6812 948 1,072,-872'1 $ 661,466] $ 3650 367 $ `2 9i0 51`0. $ 9,602,361, CASH and I I CASH EQUIVALENTS ! UNRESERVED CASH ! CASH (CHECKING/SAVINGS) $ 1,930,981 $ 427,072 $ 286,157 $ 672,707 $ 693,232 $ 303,272 CASH - SJC OPERATING 14,122 INVESTMENTS 4,002,470 775,226 375,3091 2,751,2441 2,101,729 2,251,029 PETTY CASH 700 00 TOTAL - UNRESERVED CASH $ 5,934,151 1$ 1,202,298 1 $ 661,4661$ 3,424,348 $ 2,794,961 $ 2,568,423 RESERVED CASH PARKS & OPEN SPACE PLAN $ 33,239 $ - $ - $ - $ - $ GENERAL PURPOSE BENEFIT 194 961 144 48 50 HIGHWAY EQUIPMENT - 3,023 PRESERVE MAINTENANCE 190 - - LAND STEWARDSHIP 756 INVESTMENTS 1,118,291 69,400 360,31623,800 12,000 FIDUCIARY FUNDS 928 - - TOTAL - RESERVED CASH $ 1,153,597 $ 69,496 $ - $ 363,4831$ 23,8481$ 12,050 TOTAL GASH -0413012019 7,087,748 1,271.794 661.466 3.787A301 $ 2.818.809 2.50,47" Page 1 of 4 TOWN OF ITHACA REVENUE and EXPENSE SUMMARY FOR THE MONTH ENDED APRIL 30, 2019 Page 2 of 4 CAPITAL RISK FIRE ' LIGHTING DEBT TRUST & DESCRIPTION PROJECTS RETENTION PROTECTION DISTRICT SERVICE AGENCY FUNDS FUND FUND FUNDS FUND FUND REVENUE BUDGETED REVENUE $ - $ 15,000 $ 3,174,000 $ 18,000 $ 1,619,843 $ ACTUAL & ACCRUED 821 101 3,160,010 18,017 1,621,621 REVENUE OV15FI UNDER .. :1$821 �` 14 899 $ 13990 x;17 1 1 778 $ % OF BUDGET EARNED 0.0% 0.7% 99.6% 100.1% 100.1% EXPENSE BUDGETED EXPENSE $ - $ 15,000 $ 3,415,000 $ 17,500 $ 1,688,194 $ ACTUAL & ACCRUED 223,717 2,010 625,253 3,753 160,274 EXPENSE OVET3; U( DEFT '•` :223717:;' $ . 1206 2 789 747 :.-03147W;$ •.` 1 527 92U. Y % OF BUDGET EXPENDED 0.0% 13.4% 18.3% 21.4% 9.5% ESTIMATED FUND BALANCE $ 999,875 $ 149,222 $ 2,010,351 $ 14,488 $ 98,165 $ FUND BALANCE - 01/01/2019 ACTUAL & ACCRUED ADD: REVENUE 821 101 3,160,010 18,017 1,621,621 LESS: EXPENSE J$ 223,7171 2,010 625,253 3,753 160,274 FUND BALANCE - 04/3012019 776,9791$ 147,313 $ 4 545 , 09 $ 28,752 $ ' 1,550.'51'2 $ CASH and CASH EQUIVALENTS UNRESERVED CASH CASH (CHECKING/SAVINGS) $ 70,717 $ 7,280 $ 42,639 $ 28,752 $ 58,277 $ CASH - SJC OPERATING INVESTMENTS 795,358 140,033 4,502,470 1,501,235 PETTY CASH TOTAL - UNRESERVED CASH $ 866,075 $ 147,313 $ 4,545,109 $ 28,752 $ 1,559,512 $ RESERVED CASH PARKS & OPEN SPACE PLAN $ - $ - $ - $ _ $ _ $ _ GENERAL PURPOSE BENEFIT HIGHWAY EQUIPMENT - PRESERVE MAINTENANCE LAND STEWARDSHIP INVESTMENTS FIDUCIARY FUNDS443,$24 30,000 $ - $ - $ - $ - $ - $ 473,824 TOTAL - RESERVED CASH TOTAL CASH -04130/2019 $ 866,075 $ 147,313 $ - 4,545,109 1 $ 28,752 $ ` 1,559,512 473824' Page 2 of 4 TOWN OF ITHACA REVENUE and EXPENSE SUMMARY for CAPITAL PROJECTS FOR THE MONTH ENDED APRIL 30, 2019 I ruNunf ] t... ME I rUNU Me I I 'FUNLIK10- I .FUND H11 I FUND H12 I FUND H19 1FUNDH21 I I I TOTALI DESCRIPTION Routs 96B -GatewsyTraff Trumansburg EffiHs How Park Lene Sapsuak.r. , Christopher Send Bank Rd CAPITAL -Rldlk (r-. P -Al -1 W.- - - 071- REVENUE BUDGETED REVENUE $ $ $ $ - - $ $ $ $ $ ACTUAL & ACCRUED 202 83 4 328 49 6 4 145 821 IREVENUE OVER (UNDER) 202 83 $ 4 $ 328 49 5 $ 4 $ 145 $ 82=1 % 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% EXPENSE BUDGETED EXPENSE $ - $ . $ $ ACTUAL & ACCRUED 7,066 216,651 223,717 IEXP,ENSSOVlM, UNDER 7066 :S, "- '1, 1"",$ -,$ 223$1 7: j % OF BUDGET EXPENDED 0.0% 0.0% 0.0% 0.0% 0.0% 1 0.0% 1 0.0% 0.0% 0.0% 0.0% 0.0% ESTIMATED FUND BALANCE FUND BALANCE -01/0112019 $ 180,460 $ 72,627 $ 6,927 $ 339,363 $ 27,592 $ 7,727 $ 6,326 $ 360,866 $ $ $ 999,875 ACTUAL & ACCRUED ADD: REVENUE 202 83 4 328 49 5 4 145 821 LESS: EXPENSE 7,066 - - 216,651 223,717 FUND BALANCE - 12019 $ 173,686 § 72,711 1 59-31 $ 123,040 $ 27,641 1_7 732 $ 5.328 $ 361,011 $ $ $ 776 979 CASHan CASH EQUIVALENTS CASH (CHECKINGISAVINGS) $ 22,664 $ 22,544 $ 5,930 $ 4,646 $ 973 $ 7,732 $ 5,328 $ 1,011 $ $ 70,717 INVESTMENTS 150,124 50,041 200,165 35,029 360,000 795,358 [TOTAL CASH -04130/2019 $ 172 6_77 $ M585 $ 5,930 $ 204,811 $ ----36 002-j_7,732 J5.328 $ 361,011 $ $ 8766 0=75 DIVIncentes, Contracts Payments: 40,000 3,759 2,919 Approx Page 3 o14 TOWN OF ITHACA REVENUE and EXPENSE SUMMARY for LIGHT DISTRICTS FOR THE MONTH ENDED APRIL 30, 2019 FUND SL -11 I FUND SL -2 I FUND SW I FUND SL -4 I FUND SL -5 I FUND SL -6 I FUND Sl -7 FUND SL -8 FUND SL -9 I TOTAL DESCRIPTION Forest I Glenside Renwick Eastwood Winner's Surleigh Westhaven Coddington LIGHT I Home Heights.Clover Lane Commons Circle Drive Road 14-1 nlqrrurm REVENUE BUDGETED REVENUE $ 5,300 $ 900 $ 1,300 $ 2,700 $ . 300 $ 1,000 $ 1,100 $ 3,300 $ 2,100 $ 18,000 ACTUAL & ACCRUED 5,304 901 1,301 2,702 300 1,001 1,101 3,303 2,102 18,017 IREVENUE OVER (UNDER) 4 1 $ 1 $ 2 $ 0 $ 1 $ 1 $ 3 $ , -2 17 % OF BUDGET EARNED 100.1% 100.1% 100.1% 100.1% 100.1% 100.1% 100.1% 100.1% 100.1% 100.1% EXPENSE BUDGETED EXPENSE $ 4,800 $ 1,100 $ 1,340 $ 2,600 $ 300 $ 900 $ 1,100 $ 3,300 $ 2,100 $ 17,500 ACTUAL & ACCRUED 710 250 317 627 74 225 254 813 482 3,753 1EXP.ENSFO.V,ER'.fUNDgR J:, j- '(4QM 850 m;, $ 167&14. 846),2L4n- 1'648. I3747' % OF BUDGET EXPENDED 14.8% 22.7% 24.4% 24.1% 24.8% 25.0% 23.1% 24.6% 22.9% 21.4% ES77MATED FUND BALANCE FUND BALANCE - 01/0112019 $ 5,649 $ 1,004 $ 836 $ 1,418 $ 202 $ 433 $ 881 $ 2,357 $ 1,708 $ 14,488 ACTUAL & ACCRUED ADD: REVENUE 5,304 901 1,301 2,702 300 1,001 1,101 3,303 2,102 18,017 I -Ess: EXPENSE 710 250 317 627 74 225 254 813 482 3,753 FUND BALANCE - 413212919----k 10,243 $ 1,656 ; 1821 3,493 $ 428 $ 1,209 S 1,727 $ 4,847 $ 3,328 28,752 CASH attat CASH EQUIVALENTS CASH (CHECKJN()ISAVINGS) $ 10,243 $ 1,656 $ 1,821 $ 3,493 $ 428 $ 1,209 $ 1,727 $ 4,847 $ 3,328 $ 28,752 INVESTMENTS - - - TOTAL CASH -04130/2019 $ 10,243 9 1,656 $ L821 A 3 493 428 $ 1209, $ 1,727 $ 4,847 4-3 328 28 752 Page 4 of 4 TOWN OF ITHACA DETAILED CASH LISTING - FIDUCIARY FUNDS FOR THE MONTH ENDED APRIL 30, 2019 TA200C DISBURSEMENTS CHECKING TA200P PAYROLL CHECKING TA201 CASH IN TIME DEPOSITS TA202 ON-LINE COLLECTIONS TA203 CASH IN SHORT TERM INVESTMENTS TA205 ROAD USE AGREEMENTS TA206 ITHACA TOWERS OPTION ESCROW TA207 UNCLAIMED BAIL - ITHACA TOWN COURT TA209 EMPLOYEE FLEXIBLE SPENDING TA210 STORMWATER COALITION TA211 PLANNING DEPOSITS TA212 CAYUGA LAKE WATERSHED INTERMUNICIPAL ORG TA214 LAKE VIEW CEMETERY - PERMANENT MAINT FUND TA215 LAKE VIEW CEMETERY - FERRIS MEMORIAL FUND TA217 TIER 6 RETIREMENT ESCROW GENERAL TOWNWIDE FUND AMOUNT 238,229.83 30,000.00 300.97 101,583.57 9,454.47 393.01 3,402.10 6,845.49 68,292.15 11,150.32 1,311.69 1,339.89 1,520.93 $ 473,824.42 $ 928.04 TOTAL CASH: FIDUCIARY FUNDS $ 474,752.46 Road Use Agreements: Conifer Realty - Cayuga Meadows RUA Jeff Simmons -120 Maple Avenue Accrued Interest - transfer to General Fund Total - Road Use Agreements Unclaimed Bail - Ithaca Town Court: TB Resolution No. 2016-166, adopted 12/1212016 TB Resolution No. 2017-075c, adopted 6/26/2017 TB Resolution No. 2018-147, adopted 11/19/2018 Accrued Interest - transfer to General Fund Total - Unclaimed Bail - Ithaca Town Court Planning Deposits: Nextel Site Lease Deposit Wireless One Site Lease Deposit Maplewood Traffic Calming Deposit (Rec. 3/19/18) Accrued Interest - transfer to General Fund Total - Planning Deposits $ 30,436.00 1,000.00 RR AR $ 31,472.58 $ 1,750.00 Exp. 1211212022 1,400.00 Exp. 612612023 250.00 Exp. 1010912024 2.10 $ 3,402.10 $ 4,510.32 4,601.43 30,000.00 61.63 $ 39,173.38 0 TOWN OF ITHACA SUMMARY OF BANK COLLATERAL FOR THE MONTH ENDED APRIL 30, 2019 TOMPKINS TRUST COMPANY. CASH & CASH EQUIVALENTS $ 4152 524 INVESTMENTS TOTAL CASH ON DEPOSIT LESS: FDIC INSURANCE 1 $ 20,810,108 $ 24,962,632 $ 250,000 LESS: FMV OF COLLATERAL ON DEPOSIT @ 4/30/2019 U.S. GOVERNMENT AGENCY OBLIGATIONS $ 28,464,390 OVER (UNDER) COLLATERALIZED $ 3,751,758 CASH ASSETS COLLATERALIZED @ FMV 4/30/2019 115% 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.