No preview available
HomeMy WebLinkAbout2018-05 Financial Report c ? TOWN OF ITHACA FINANCIAL REPORTS FOR THE MONTH ENDED MAY 319 2018 REPORTS: BALANCE SHEET REVENUE & EXPENSE SUMMARY and CASH & CASH EQUIVALENTS DETAILED CASH LISTING FOR FIDUCIARY FUNDS SUMMARY OF BANK COLLATERAL TOWN OF ITHACA BALANCE SHEET FOR THE MONTH ENDED MAY 31, 2018 GENERAL GENERAL HIGHWAY HIGHWAY WATER SEWER DESCRIPTION TOWNWIDE PART-TOWN TOWNWIDE PART-TOWN FUND FUND FUND FUND FUND FUND ASSETS UNRESERVED CASH: CASH $ 5,364,218 $ 1,070,477 $ 548,456 $ 2,882,482 $ 594,273 $ 2,493,142 INVESTMENTS - PETTY CASH 700 200 TOTAL-UNRESERVED CASH $ 5,364,918 $ 1,070,477 $ 548,456 $ 2,882,682 $ 594,273 $ 2,493,142 RESERVED CASH: PARKS&OPEN SPACE PLAN $ 828,004 $ - $ - $ - $ - $ GENERAL PURPOSE BENEFIT 165,499 69,413 79,348 23,819 12,038 HIGHWAY EQUIPMENT 256,683 - - PRESERVE MAINTENANCE 40,142 LAND STEWARDSHIP 9,847 - INVESTMENTS - FIDUCIARY FUNDS 4,422 - TOTAL-RESERVED CASH $ 1,047,913 $ 69,413 $ - $ 336,031 $ 23,819 $ 12,038 OTHER ASSETS: ACCOUNTS RECEIVABLE $ - $ - $ - $ - $ - $ 2,259 WATER&SEWER RECEIVABLES - - 11,027 32,624 DUE FROM OTHER FUNDS - 1,985,305 STATE&FEDERAL AID RECEIVABLE DUE FROM OTHER GOV'TS 48,000 59,400 24,737 - PREPAID EXPENSES 7,104 (374) - (374) (187) (187) TAXES RECEIVABLE-CURRENT - TOTAL-OTHER ASSETS $ 55,1041 $ 59,026 $ - $ (374)1 $ 2,020,881 $ 34,695 TOTAL ASSETS 6 467 935 1,198,915 648,456. 3 218 339 2,638,973 2,639875 LIABILITIES and FUND BALANCE ACCOUNTS PAYABLE $ - $ - $ - $ - $ - $ _ ACCRUED LIABILITIES 228,668 194,262 103,934 - 24,000 DUE TO OTHER FUNDS RETAINAGE - DEFERRED REVENUE RESERVED FUND BALANCE 1,047,913 69,413 336,031 23,819 12,038 UNRESERVED FUND BALANCE 5,191,354 935,241 548,456 2,778,374 2,615,154 2,503,837 TOTAL LIABILITIES&FUND BALANCE 6,467.935 1.198,915 548.4561 $ 3,218.339 2,-6378 973 2 539 875 ESTIMATED FUND BALANCE FUND BALANCE-01/01/2018 $ 3,997,002 $ 1,072,768 $ - $ 2,267,511 $ 2,820,416 $ 2,763,256 ADD: REVENUE 3,796,008 542,258 958,477 1,984,114 1,676,228 807,023 LESS: EXPENSE 1,553,744 610,373 410,021 1,137,220 1,857,671 1,054,404 FUND BALANCE-06/31/2018 65,239.267 1,004.6631 $ 648,4561 $ 3114 405 2 638,973 2,5g&75 Page t of 4 T , TOWN OF ITHACA BALANCE SHEET FOR THE MONTH ENDED MAY 31, 2018 CAPITAL RISK FIRE LIGHTING DEBT TRUST& DESCRIPTION PROJECTS RETENTION PROTECTION DISTRICT SERVICE AGENCY FUNDS FUND FUND FUNDS FUND FUND ASSETS UNRESERVED CASH: CASH $ 553,630 $ 146,977 $ 4,474,324 $ 23,871 $ 1,153,468 $ INVESTMENTS PETTY CASH - TOTAL-UNRESERVED CASH $ 553,630 $ 146,977 $ 4,474,324 $ 23,871 $ 1,153,468 $ RESERVED CASH: PARKS&OPEN SPACE PLAN $ - $ - $ - $ - $ - $ GENERAL PURPOSE BENEFIT HIGHWAY EQUIPMENT - PRESERVE MAINTENANCE LAND STEWARDSHIP - - FUNDS FOR BOND REFUNDING FIDUCIARY FUNDS - 436,883 TOTAL-RESERVED CASH $ - $ - $ - $ - $ - $ 436,883 OTHER ASSETS: ACCOUNTS RECEIVABLE $ - $ - $ - $ _ $ _ $ CUSTOMER RECEIVABLE DUE FROM OTHER FUNDS STATE&FEDERAL AID RECEIVABLE DUE FROM OTHER GOV'TS PREPAID EXPENSES - TAXES RECEIVABLE-CURRENT - TOTAL-OTHER ASSETS $ - I $ - Is - Is - $ - Is TOTAL ASSETS 553,630T$ 146 977 $ 4,474,324 23 871 1,153.468 436,883 LIABILITIES and FUND BALANCE ACCOUNTS PAYABLE $ - $ ACCRUED LIABILITIES - 436,883 DUE TO OTHER FUNDS 1,985,305 - RETAINAGE 23,098 DEFERRED REVENUE RESERVED FUND BALANCE - UNRESERVED FUND BALANCE (1,454,773) 146,977 4,474,324 23,871 1,153,468 TOTAL LIABILITIES&FUND BALANCE S 553 630 146,9771 $ 4.474.324 23.871 1,153.468 $ 436,883 ESTIM4TED FUND BALANCE FUND BALANCE-01/01/2018 $ (1,454,426) $ 151,706 $ 2,078,828 $ 81809 $ 228,128 $ ADD: REVENUE 183 50 3,252,378 19,007 1,208,187 LESS: EXPENSE 404 4,778 856,883 3,945 282,847 FUND BALANCE-05/31/2018 1 $ (1,454,647)1 $ 146,9771 $ 4.474.3-24 23,871 1,153.468 Page 2 of 4 TOWN OF ITHACA BALANCE SHEET for CAPITAL PROJECTS FOR THE MONTH ENDED MAY 31, 2018 ACTIVE CAPITAL PROJECTS. I I L I CLOSED CAPrrALPROJECTS FUND"7 1 FUND 118 FUND H9 I FIND HI I FUND 1111 FUND H12 FUND H73 FUND H21 TOTAL DESCRIPTION Route 96B Gateway Trall Trumansburg Ellis Hollow Perk Lane Sapsucker Wds Chdstopher Cir Sand Bank Rd CAPITAL Sidewalk (Grant Funding) Water Tank Water Tank Water Main Water Main Water Mein Im memento PROJECTS UNRESERVED CASH: CASH $ 95,537 $ 72,445 $ 1,238 S 4,597 S 12,023 S 4,745 S 2,464 $ 380,582 $ - $ - S 553,630 INVESTMENTS TOTAL-UNRESERVED CASH S 95,637 $ 72,445 $ 1,238 $ 4,597 S 12,023 $ 4,745 $ 2,464 $ 360,582 S - $ S 553,630 OTHER ASSETS: ACCOUNTS RECEIVABLE S - S - S - S - S - $ - S - S - $ - S - S CUSTOMER RECEIVABLE DUE FROM OTHER FUNDS STATEIFEDERAL RECEIVABLE DUE FROM OTHER GOV'TS - 126 _ _ _ _ _ _ _ 146 PREPAIDEXPENSES BAN LOANS TOTAL-OTHER ASSETS S - S 125 S - $ - S - 5 - 5 - S - 5 - S - $ 126 TOTAL ASSETS $ 95,537 7&570 S 1 238 S 4 597 $ 12 023 5 4,745 S 2,464 S 360,582 - $ - $ 653 756 LIABILITIES&FUND BALANCE ACCOUNTS PAYABLE $ - $ - $ - S - S $ $ - S - $ - S - S - ACCRUED LIABILIITES _ _ - DUE TO OTHER FUNDS - - 700,024 5,000 454,542 460,877 364,862 - - - 1,985,305 RETAINAGE - .- - - 23,098 - - _ _ BAN PAYABLE _ - - - - - 23,098 RESERVED FUND BALANCE UNRESERVED FUND BALANCE 95,537 72,570 (698,785) (403) (465,617) (456,132) (362,398) 360,582 - - (1,454,647) TOTAL UAB A FUND BALANCE S 9S.537 $ 72,570' S 1 8 $ 4.597 S 12,023 $ 4,745 S 2,464 S 360,S82 S - S - $ 653 756 ESTIMATED FUND BALANCE FUND BALANCE-01/01/2018 $ 95,S05 $ 72,546 $ (698,786) S S (465,621) S (456,134) $ (362,399) S 360,462 S - $ - S (1,454,426) ADD:REVENUE 32 24 0 1 4 2 1 119 - - 183 LE65:EXPENSE _ _ _ 404 _ _ - - - 404 FUND BALANCE-05K;1h018 S 95,537t 72,570 S 698785 $ 403 48581 $ 458132 S 362 98 360,592 S - $ - $ 145q 4 Page 3 of 4 TOWN OF ITHACA BALANCE SHEET for LIGHT DISTRICTS FOR THE MONTH ENDED MAY 31, 2018 FUND SL-1 FUND SL-2 FUND SL-3 FUND SL-4 FUND SL-5 FUND SL-6 FUND SL-7 FUND SL-B FUND SL-9 TOTAL DESCRIPTION Forest Glenelde Renwick Eastwood Clover Lane Winner's Burlelgh Weathaven Coddington LIGHT Home Heights Commons Circle Drive Road Road DISTRICTS ASSETS UNRESERVED CASH: CASH $ 7,351 $ 1,639 $ 1,623 $ 3,016 $ 391 $ 1,017 $ 1,524 $ 4,393 $ 2,917 $ 23,871 INVESTMENTS TOTAL-UNRESERVED CASH $ 7,351 $ 1,639 $ 1,623 $ 3,016 $ 391 $ 1,017 $ 1,524 $ 4,393 $ 2,917 $ 23,871 OTHER ASSETS: ACCOUNTS RECEIVABLE $ $ _ $ _ $ _ $ $ $ $ $ $ CUSTOMER RECEIVABLE DUE FROM OTHER FUNDS STATE&FEDERAL AID RECEIVABLE PREPAID EXPENSES . TAXES RECEIVABLE-CURRENT 6.300 1,000 1,200 2,600 300 900 1 100 3,500 2,100 19,000 TOTAL-OTHER ASSETS $ 6,300 $ 11000 $ 1,200 $ 2,600 $ 300 $ 900 $ 1,100 $ 3,500 $ 2,100 $ 19,000 TOTAL ASSETS $ 13,651 2,639 $ 2 823 $ 5 616 c 691 $ 1,917 $ 2,624 $ 7,893 $ 5,017 42 871 LIABILITIES and FUND BALANCE ACCOUNTS PAYABLE $ - $ _ $ $ $ $ $ $ $ $ ACCRUED LIABIUITES DUE TO OTHER FUNDS DEFERRED REVENUE RESERVED FUND BALANCE - UNRESERVED FUND BALANCE 13,651 2,639 2,823 5,616 691 1,917 2,624 7,893 5,017 42,871 TOTAL LIABILITIES&FUND BALANCE 13,651 2,639 2,823 5,616 691 1,917 $ 2,624 7,893 $ 5,017 42 871 ESTIMATED FUND BALANCE FUND BALANCE-01/01/2018 $ 1,790 $ 899 $ 757 $ 1,066 $ 168 $ 341 $ 691 $ 1,764 $ 1,331 $ 8,809 ADD: REVENUE 6,302 1,001 1,201 2,601 300 900 1,101 3,501 2,101 19,007 LESS: EXPENSE 741 261 335 651 78 225 267 872 516 3,945 FUND BALANCE-05/31/2018 7.351 1,639 1,623 $ 3,016 $ 391 1 017 1,524 $ 4,393 2-917 23,871 Page 4 of 4 ., TOWN OF ITHACA REVENUE and EXPENSE SUMMARY FOR THE MONTH ENDED MAY 31, 2018 GENERAL GENERAL HIGHWAY HIGHWAY WATER SEWER DESCRIPTION TOWNWIDE ( PART-TOWN TOWNWIDE I PART-TOWN I FUND I FUND FUND FUND FUND FUND REVENUE BUDGETED REVENUE $ 4,560,781 1 $ 1,543,150 $ 810,750 $ 3,171,750 $ 7,081,208 $ 2,663,584 ACTUAL&ACCRUED 3,796,008 542,258 ! 958,477 1,984,114 1,676,2281 807,023 REVENUE OVER UNDER $ (764.773)1 $ (1,000,892)1 $ 147,727T$-(1,187,636)1 $ (5,04,980)1 $ (1,856,561 % OF BUDGET EARNED 83.2% 35.1% 118.2% 62.6% I 23.7% ( 30.3% I EXPENSE BUDGETED EXPENSE $ 5,003,206 $ 1,894,070 i $ 773,185 $ 3,490,313 $ 7,040,519 $ 3,302,208 ACTUAL&ACCRUED 1,553,744 610,3731 410,021 1 1,137,2201 1,857,671 1,054,404 EXPENSE OVER UNDER (3,449,463)1 1283 697 t$ (363,164)1 $ (2,353,003)1 $ (5182 848 I $ U,247,004) %OF BUDGET EXPENDED 31.1% i 32.2% 53.0% 32.6% 26.4% 31.9% ESTIMATED FUND BALANCE FUND BALANCE-01/01/2018 $ 3,997,002 i $ 1,072,768 ! $ - $ 2,267,511 ; $ 2,820,416 $ 2,763,256 ACTUAL&ACCRUED ADD: REVENUE 3,796,008 542,258 j 958,477 1,984,114 1,676,228 807,023 LESS: EXPENSE 1,553,744 ! 610,373 410,021 1,137,220 1,857,671 1,054,404 FUND BALANCE-05/31/2018 $ 6.239,267 1 $ 1,004,65i 1 $ 548,456 3,114,405 2,638,973 $ 2,515,875 CASH and CASH EQUIVALENTS UNRESERVED CASH CASH(CHECKING/SAVINGS) $ 5,364,218 $ 1,070,477 $ 548,456 $ 2,882,482 $ 594,273 ! $ 982,583 CASH-SJC OPERATING - 1,510,559 INVESTMENTS - - I PETTY CASH 700 i - 200 - TOTAL-UNRESERVED CASH $ 5,364,918 $ 1,070,477 ' $ 548,456 $ 2,882,682 $ 594,273 $ 2,493,142 RESERVED CASH PARKS&OPEN SPACE PLAN $ 828,004 $ - $ - ! $ - $ - $ GENERAL PURPOSE BENEFIT 165,499 69,413 79,348 23,819 12,038 HIGHWAY EQUIPMENT - - 256,683 PRESERVE MAINTENANCE 40,142 LAND STEWARDSHIP 9,847 INVESTMENTS - FIDUCIARY FUNDS 4,422 - - TOTAL-RESERVED CASH $ 1,047,913 i $ 69,413 $ - $ 336,031 $ 23,819 ! $ 12,038 TOTAL CASH-05/31/2018 6,412,832 1,139,889 548,456 3,218,713 618,092 1 2,505180 Page 1 of 4 r TOWN OF ITHACA REVENUE and EXPENSE SUMMARY FOR THE MONTH ENDED MAY 31, 2018 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,274,000 $ 19,000 $ 1,208,144 $ ACTUAL&ACCRUED 183 50 3,252,378 19,007 1,208,187 REVENUE OVER UNDER $ 183 (14,950)11 L21,6?? $ 71 $ 43 - % OF BUDGET EARNED 0.0% 0.3% 99.3% 100.0% 100.0% EXPENSE BUDGETED EXPENSE $ - $ 15,000 $ 3,382,500 $ 17,850 $ 1,341,144 $ ACTUAL&ACCRUED 404 4,778 856,883 3,945 2829847 EXPENSE OVER UNDER $' 4041 $ (10,222) $ 2 525 617 13 905) $ (1.058,298)1 $ % BUDGET EXPENDED 0.0% 31.9% 25.3% 22.1% 21.1% ESTIMATED FUND BALANCE FUND BALANCE-01/01/2018 $ (1,454,426) $ 151,706 $ 2,078,828 $ 8,809 $ 228,128 $ - ACTUAL&ACCRUED ADD: REVENUE 183 50 3,252,378 19,007 1,208,187 LESS: EXPENSE 404 4,778 856,8831 3,945 282,847 FUND BALANCE-05/31/2018 $ 1 454 647 $ 146,977 , $ 4,474,3 4 $ 23,871 $ 1,153,4681 $ CASH and CASH EQUIVALENTS UNRESERVED CASH CASH(CHECKING/SAVINGS) $ 553,630 $ 146,977 $ 4,474,324 $ 23,871 $ 1,153,468 $ CASH-SJC OPERATING _ INVESTMENTS PETTY CASH - TOTAL-UNRESERVED CASH $ 553,630 $ 146,977 $ 4,474,324 $ 23,871 $ 1,153,468 $ RESERVED CASH PARKS&OPEN SPACE PLAN $ - $ - $ - $ - $ _ $ GENERAL PURPOSE BENEFIT - HIGHWAY EQUIPMENT _ PRESERVE MAINTENANCE LAND STEWARDSHIP FUNDS FOR BOND REFUNDING - - FIDUCIARY FUNDS - 436.8 TOTAL-RESERVED CASH $ - $ - $ - $ - $ - $ 436,883 TOTAL CASH-05/31/2018 653,630 IS 146.9771 $ 4,474.324 $ 23,871 1,163.468 436 883 Page 2 of 4 TOWN OF ITHACA REVENUE and EXPENSE SUMMARY for CAPITAL PROJECTS FOR THE MONTH ENDED MAY 31, 2018 ACTIVE CAPITAL PROJECTS ICLOSED CAPITAL PROJECTS FAD N7 FFf1NO HQ FUND Hg FUND H70 FUND HII FUND H12 II13 FUND N21 TOTAL DESCRIPTION Routs 988 GMeway Trall Tmmansburg Ellis Hollow Park lana Sapsucker Christopher Send Bank Rd CAPITAL Sidewalk Grant Funding Water Tank Water Tank Water Mein Water Main Water Mein Improvements PROJECTS REVENUE BUDGETED REVENUE $ - $ - S - $ - S - $ - $ - S - S - S $ - ACTUAL&ACCRUED 32 24 0 1 4 2 1 119 - - 183 REVENUE OVER(UNDER) 32 24 0 1 S 4 S 2 S 1 $ 119 - S 183 %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% EXP SE BUDGETED EXPENSE $ - $ - $ - S - S - $ - S - $ - $ - $ - $ _ ACTUAL&ACCRUED - - - S 404 - _ _ _ _ _ 404 EXPENSE OVER UNDER $ 404 _ $ _ $ _ $ - $ - $ 111 404 % BUDGET EXPENDED 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% ESTIMATED FUND BALANCE FUND BALANCE-01/01/2018 $ 95,505 $ 72,546 S (698,786) S - $ (465,621) S (456,134) $ (362,399) $ 360,462 $ - S - $ (1,454,426) ACTUAL&ACCRUED ADD:REVENUE 32 24 0 1 4 2 1 119 - - 183 LESS:EXPENSE - _ _ 404 _ _ _ _ _ _ 404 FUND BALANCE-05/31/2018 S 95 37 $ 72,S70 $ (698,785) S 403 $ (465,617) $ 456132 (362,398) 360,582 1 454 647 CASH and CASH EQUIVALENTS CASH(CHECKINGISAVINGS) $ 95,537 S 72,445 $ 1,238 $ 4,597 S 12,023 S 4,745 S 2,464 $ 360,582 S - S - $ 553,630 INVESTMENTS TOTAL CASH-06M=018 95,537 72,445 111 1,238 S 4,597 S 12,023 $ 4,745 2,464 360,582 $ - $ - $ 553 630 Page 3 of 4 t O h h O N N Cl h Lf) W O O to v O p p h h h j O O o ccGf RO O 19i OD m O —0 HI Ol Ol Op ti r � co Ol M N N N Nr O N o N m Q 0- 0 O O y O O O r CO M O T r r r j r r n C' to 't0 n (h r to Ol In O W N N p N r r N N N N V T t9 to 49 N co J 7 'q H ao V 0~0 N \ ti W m t09 M l07 QL a M M p M T m It d Q C N LL 49 0 C4 Q T r O h M r r h '0 x V ' h O O LO w m O O lD N N N N CO u IO r N tq U) tO 07 m > r r p r N r r r r Z Q O M m m r N LL U) 69 4n to 69 � F O O O O O h r O to h h ' h V CD m O O Lf) N N V O 9 r r T O of u c0 N 40 \ M W N O O O CO d — O L r r r U) Q e 416i T p 3 V N LL N fe 4A49Go (7 T y O O O O CO N m O CO T W O O O h N c0 p h O tit O J co j Cy M Cl) M N o r M M M M J O ciO V z p N QW IL Cj fA 64) 169 (a df c O r r O T Ol tp r r cO tD to U. g Z OtOa m 0 t r r O W as c c to t0 o en to R , o to m a p O Z = Q N N C N 3 � O W to U T N LL Q W N( A N t9 C9 CL O r r O to h T O M x W to O O O co tO O O M N N N W H y v .m. N N a M M Cil h N M w /D t0 ,a MIR Z o d O to W to fA C9 Z O r r O r Ql W r r W Ol ' til W N O O try OI O t0 M M M > 1 O O N CD co O N wCD iD LU q T T T � r n T T T T IL Q O N (S r 69 40 49 69 O N N O T Ol p N r 0 0 O t7 to Ql p v O LO tro j M n M h M O h N c M M M wm t0 IO p to a? Q o 0 o v z LL x r r LL 4w 49 40 40 CO CF} to U z ¢ ¢ w R N N a to O W to A w W W D Z o M �� a Z Z = Q Z Z w P to a Z o W mWl LL, > N to N Ul W V W � x4 X V W w Q V V = (A w QO Z Oi w LUW W Z W N x O a 0 O C a o @S Z a w a Ux v N O > H to J m W J N m m Q w@ v w V GLu O O F W LL t- p ,Hr► Q 2 CL Z U 0 W Z N > F m Q OC o m Q w CO0° LL Q Q J LL V Z O TOWN OF ITHACA DETAILED CASH LISTING - FIDUCIARY FUNDS FOR THE MONTH ENDED MAY 31, 2018 DESCRIPTION AMOUNT TRUST&AGENCY FUND TA200C DISBURSEMENTS CHECKING $ TA200P PAYROLL CHECKING TA202 ON-LINE COLLECTIONS 219,762.41 TA205 ROAD USE AGREEMENTS 163.59 TA206 ITHACA TOWERS OPTION ESCROW 31,487.05 TA207 UNCLAIMED BAIL-ITHACA TOWN COURT 11,877.09 TA209 EMPLOYEE FLEXIBLE SPENDING 3,152.80 TA210 STORMWATER COALITION 8,454.71 TA211 PLANNING DEPOSITS 64,742.40 TA212 CAYUGA LAKE WATERSHED INTERMUNICIPAL ORG 39,126.64 27,189.72 TA214 LAKE VIEW CEMETERY-PERMENANT MAINT FUND TA215 LAKE VIEW CEMETERY-FERRIS MEMORIAL FUND 19,419.92 11,506.87 TOTAL CASH:TRUST&AGENCY FUND $ 436,883.20 GENERAL TOWNWIDE FUND A237 INLET VALLEY CEMETERY $ 4,422.03 TOTAL CASH:FIDUCIARY FUNDS $ 441,305.23 Road Use Agreements: Conifer Realty-Cayuga Meadows RUA $ 30,436.00 Jeff Simmons-120 Maple Avenue 1,000.00 Accrued Interest-transfer to General Fund 51.05 Total-Road Use Agreements $ 31•,487.05 Unclaimed Bail-Ithaca Town Court: TB Resolution No.2016-166,adopted 12/12/2016 $ 1,750.00 Exp. 12/26/2022 TB Resolution No.2017-075c,adopted 6/26/2017 1,400.00 Exp. 6/26/2023 Accrued Interest-transfer to General Fund 2.80 Total-Unclaimed Bail-Ithaca Town Court $ 3,152.80 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) 30,000.00 Accrued Interest-transfer to General Fund 14.89 Total-Planning Deposits $ 39,126.64 A f TOWN OF ITHACA SUMMARY OF BANK COLLATERAL FOR THE MONTH ENDED MAY 31, 2018 TOMPKINS TRUST COMPANY: CASH&CASH EQUIVALENTS $ 20,678,685 INVESTMENTS TOTAL CASH ON DEPOSIT $ 20,678,685 LESS: FDIC INSURANCE $ 250,000 LESS: FMV OF COLLATERAL ON DEPOSIT @ 05/31/2018 U.S.GOVERNMENT AGENCY OBLIGATIONS $ 23,646,350 OVER(UNDER)COLLATERALIZED $ 3,217,665 CASH ASSETS COLLATERALIZED @ FMV 05/31/2018 116% Collateral Is held by the Bank of New York,pledged for the Town of Ithaca,New York,for i all deposits and/or repurchase agreements of Tompkins Trust Company. p Y. 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. li