No preview available
HomeMy WebLinkAbout2018-02 Financial Report N TOWN OF IT"HACA FINANCIAL REPORTS FOR THE MONTH ENDED FEBRUARY 28, 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 FEBRUARY 28, 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,872,095 $ 953,663 $ 667,842 $ 2,601,549 $ 603,480 $ 2,459,376 INVESTMENTS PETTY CASH 700 200 TOTAL-UNRESERVED CASH $ 5,872,795 $ 953,663 $ 667,842 $ 2,601,749 $ 603,480 $ 2,459,376 RESERVED CASH: PARKS&OPEN SPACE PLAN $ 827,795 $ - $ - $ - $ - $ GENERAL PURPOSE BENEFIT 165,465 69,398 79,332 23,814 12,036 HIGHWAY EQUIPMENT 250,032 PRESERVE MAINTENANCE 40,134 LAND STEWARDSHIP 9,845 INVESTMENTS FIDUCIARY FUNDS 4,421 TOTAL-RESERVED CASH $ 1,047,661 $ 69,398 $ - $ 329,364 $ 23,814 $ 12,036 OTHER ASSETS: ACCOUNTS RECEIVABLE $ - $ - $ - $ - $ - $ 2,259 WATER&SEWER RECEIVABLES 1,344 99,386 DUE FROM OTHER FUNDS 92,213 87,149 1,980,305 STATE&FEDERAL AID RECEIVABLE DUE FROM OTHER GOV'TS 70,791 59,400 240,704 24,737 PREPAID EXPENSES 24,174 7,250 17,107 2,241 961 TAXES RECEIVABLE-CURRENT TOTAL-OTHER ASSETS $ 187,178 $ 66,650 $ - S 344,9601 $ 2,OD8,626 1 $ 102,606 TOTAL ASSETS 7107 634 S 1.089.712 S 667 842 3 276,073 2.635,9191 $ 2574 018 LIABILITIES and FUND BALANCE j ACCOUNTS PAYABLE $ - $ $ _ $ - $ - $ ACCRUED LIABILITIES 228,668 194,262 103,934 24,000 DUE TO OTHER FUNDS 56,088 10,085 55,046 58,144 RETAINAGE _ DEFERRED REVENUE RESERVED FUND BALANCE 1,047,661 69,398 329,364 23,814 12,036 UNRESERVED FUND BALANCE 5,775,217 826,052 667,842 2,832,690 2,557,060 2,479,838 TOTAL LIABILITIES&FUND BALANCE S -7,107,634 1,089.712 667 842 S 3,276,073 - 2635 91 2,574,018 ESTIMATED FUND BALANCE FUND BALANCE-01/01/2018 $ 3,997,002 $ 1,072,768 $ - $ 2,267,511 $ 2,820,416 $ 2,838,426 ADD: REVENUE 3,444,824 95,517 955,238 1,405,193 958,405 202,863 LESS: EXPENSE 618,949 272,835 287,394 760,282 1,197,947 556,551 FUND BALANCE-02/28/2018 6.822.877 895 450 667 844 2 912 423 2.580-073 2 484 738 Page 1 of 4 TOWN OF ITHACA BALANCE SHEET FOR THE MONTH ENDED FEBRUARY 28, 2018 CAPITAL RISK FIRE LIGHTING DEBT TRUST& DESCRIPTION PROJECTS RETENTION PROTECTION DISTRICT SERVICE AGENCY FUNDS FUND FUND FUNDS FUND FUND ASSETS UNRESERVED CASH: CASH $ 548,923 $ 150,729 $ 5,284,042 $ 26,524 $ 1,330,469 $ INVESTMENTS PETTY CASH TOTAL-UNRESERVED CASH $ 548,923 $ 150,729 $ 5,284,042 $ 26,524 $ 1,330,469 $ RESERVED CASH: PARKS&OPEN SPACE PLAN $ $ - $ _ $ - $ _ $ GENERAL PURPOSE BENEFIT _ HIGHWAY EQUIPMENT _ PRESERVE MAINTENANCE LAND STEWARDSHIP FUNDS FOR BOND REFUNDING FIDUCIARY FUNDS 215,312 TOTAL-RESERVED CASH $ - $ - $ - $ - $ - $ 215,312 OTHER ASSETS: ACCOUNTS RECEIVABLE $ $ - $ - $ $ - $ CUSTOMER RECEIVABLE DUE FROM OTHER FUNDS _ STATE&FEDERAL AID RECEIVABLE DUE FROM OTHER GOWTS PREPAID EXPENSES TAXES RECEIVABLE-CURRENT TOTAL-OTHER ASSETS $ - $ _ $ - Is $ - Is TOTAL ASSETS 548,923 150 729 S 5.284.042 26,524 1,330,469 $ 215.312 UABILME-8 aad FUND BALANCE ACCOUNTS PAYABLE $ - $ - $ _ $ - $ $ ACCRUED LIABILITIES 215,312 DUE TO OTHER FUNDS 1,980,305 RETAINAGE 23,098 DEFERRED REVENUE RESERVED FUND BALANCE UNRESERVED FUND BALANCE {1,454,480} 150,729 5,284,042 26,524 1,330,469 TOTAL LIABILITIES&FUND BALANCE 548 923 150,729 528 4 042 26 524 1,330,469 215 312 +ESTIMATED FUND BALANCE FUND BALANCE-0110112018 $ (1,454,426) $ 151,706 $ 2,078,828 $ 8,809 $ 228,128 $ ADD: REVENUE 71 20 3,250,805 19,002 1,207,773 - LEss: EXPENSE 997 45,591 1,287 105,431 FUND BALANCE-02/2812018 (1,454,354 150,729 5 284 042 261 1330 469 Page 2 of 4 M , M r r , r tp i t a? qp r r uy b r • aepD iO r sf W r 00 R th "ri 0 a p. CO) N N N N N N N N U! I �aj Q N N N N N N N N N UA fl L1 N NIM N N N N N N ry 10 01 P c7 O rb V P r try r � i , r 2 8 N t9 Y W u� y r r N N tc Q ¢"' m r � dry � • � � � r r r RqHCO � � C9 r=N r Oi +' w fa "" Q w O 4 St�Y•'O fr0 © ml N ar]F N NN pPf//p�y R LL C? p p � a3 r •- y. 2 N N N N N N N N y) z LU p Wm�. � Na w Fu � N N N N N Ili N N N �"" .% • 9p i n r r , . r W 4 IX 0r r " S LL , �W FFF '� y N N N N N N HY N in +.� r pp . pp r , r r r , r CO r r r , r r CO pp yry N r R� O U? Lq w r r Ing °} w ar a rn m w U7 N N N N NN N N N 4fiJ R iVY to tuu?Ow wo =s mow er �j tlx q CCgYY HE ww o w acnon ay �' z tws 1E 2RA W W, w 8RU. rwwzti »baa w m a w 0 g w ra c3Q akin +scam $loan cc cc ; 2 p of tri rr h st tC! to ©© to 97 by CSD G N t 10 40 IN 'V W N to Ff) 4A Vl dY f/! fR 49 q �tUp) r in Y I 1 1 / Q© to ' 1 I 4 Y U) i T CO (n M cii M O T N M PJ C4 to to 0 r N co 1L V 411 M t/! b9140 to df 40 v! In I Co 1 1 I t 00 aVCq) I Y Y I qppp C9 -tt Q rte„ RJ OM'I i0 U M CO tt) tD t" M C fo N M 4 6940 to I pp I I I 1 Y 00 qr I 1 Y I w to to CR m D N71 rA 4'1 4A to to Fry 6s f9 w [w Im © Y O O M a) h T CD 2 � y prp N N9 to tiS f/! 44 to M cU fi1 F I to I 1 1 I 1 CCDco a M I 1 , I I e+s to 0 K u7 to to tR u> 69LAU N Fn LL. .� to r ttt�[nl�y I I 1 l I O ttO ' I I Y I Id'1 Lo (D 0w cq 4ttnnn.. J O 'I " to t0 4 O C b 00 O W N 4 E M ch cY N tp� to 0 r N M 0 E lu yr 69 �✓ `�. y 1 1 1 1 Y I (� I , 1 I I 41 h [y�ry� co CD (� G v r3 O O N i= O cq I� y 3 T T t^r M m M T r m x 2ccx a lFY� 4f (F} !a Vd 10 69 y y Ii 1toI 1 , I I .� In . 1 t r I Lo to O1 c w to CTD, 4 C TW coTOD co C W w r r r T c1[ cf N r r y w i to 40 � t7 r :WS{ c! 01 4 O c!clT T capt N h h w to V tr 1d' T to h dZ O s r r tL I* c/) 43 to lf! to 69 w w w ui > z ss�� O f4J O co Crv�O W m C9=G I w N r V� x �' A LL' W�RwA w � a m Ww5 oui'% a m��z oa a to c o U Nwr WWx w?W cc CL M N ?a WWz U. F= W W W W �m� Lu M IC a j Wim"' Yui "`= z Z uZt xa ac o°LL�a�,ua ��0 a v w m x w m w NwM- w �M7waW H a a �ccRus w W a A w x M x =gNIp I— C)WLL (a a -' U_F- et U 0 U)IL — O c�q�w w x p a O aaae oc j- LL LL TOWN OF ITHACA REVENUE and EXPENSE SUMMARY FOR THE MONTH ENDED FEBRUARY 28, 2018 GENERAL GENERAL HIGHWAY HIGHWAY DESCRIPTION TOWNWIDE PART-TOWN TOWNWIDE PART-TOWN WATER SEWER FUND FUND FUND FUND FUND FUND FUND REVENUE BUDGETED REVENUE $ 4,560,7781 $ 1,643,150 $ 810,750 f $ 3,171,750 $ 7,081,208 $ 2,663,584 ACTUAL&ACCRUED 3,444,824 95,517 f 955,238 1,405,193 958,4, 051 202,863 REVENUE OVER JLANDER) $ (11115,964)1 (1,447633 $ 144,488A (1,766,667) $,f6,-122j06-3 j7 f2,460j721) % OF BUDGET EARNED 75.5% 6.2% 117.8% 44.3% 13.0/51 7.6% EXPENSE BUDGETED EXPENSE $ 4,978,222 I $ 1,894,070 $ 773,185 $ 3,490,313 $ 7,040,519 $ 3,302,208 ACTUAL&ACCRUED 618,949 272,835 287,394 J 760,282 1,197,947 656,551 EXPENSE,OVERtUNDER). t4i459`27314, 41MIL215114L',, %OF BUDGET EXPENDED 12A% 14.4% 37.2% 21.8% 17.00/.� 16.9% ES77MATkO FUND BALANCE FUND BALANCE-01/01/2018 $ 3,997,002 $ 1,072,768 $ - $ 2,267,511 $ 2,820,416 $ 2,838,426 ACTUAL&ACCRUED ADD: REVENUE 3,444,824 95:517 955,238 1,405,193 958,405 202,863 I-Ess: EXPENSE 618,949 272835 287,394 760,282 1,197,147 556,551 FUND BALANCE-0212812018 1 $ 6,822,877 1 $ 895.450 1 $ 667,844 $ 2,912,423 [-$ 2,580,973 1 $ 2,484i738 CASH and CASH EQUIVALENTS UNRESERVED CASH CASH(CHECKINGISAVINGS) $ 5,872,095 $ 963,663 $ 667,842 2,601,549 $ 603,480 $ 949,312 CASH-SJC OPERATING - 1,510,064 INVESTMENTS - PETTY CASH 700 200 TOTAL-UNRESERVED CASH $ 6,872,795 $ 953,663 $ 667,842 $ 2,601,749 $ 603,480 $ 2,459,376 RESERVED CASH PARKS&OPEN SPACE PLAN $ 827,795 $ $ - $ $ $ GENERAL PURPOSE BENEFIT 165,465 : 69,398 79,332 23,014 12,036 HIGHWAY EQUIPMENT - 250,032 - PRESERVE MAINTENANCE 40,134 LAND STEWARDSHIP 9,845 INVESTMENTS IIII FIDUCIARY FUNDS 4.421 TOTAL-RESERVED CASH $ 1,047,661 J $ 69,3981 $ - 1 $ 329,364 $ 23,814 $ 12,036 i I !TOTAL CASH-0212012010 6-920,466 1 $ 1.023.061 1 S 667.8!L2 I S 2,931,113 1 $ 627 2,04 1 $ 2.471 Al 2 Page 1 of 4 TOWN OF ITHACA REVENUE and EXPENSE SUMMARY FOR THE MONTH ENDED FEBRUARY 28, 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 71 20 1 3,250,805 19,002 1,207,773 REVENUE OVER(UNDER) $ 711 (371) $ -� �14�98 % OF BUDGET EARNED 0.0% 0.1% 99.3% 100.0% 100.0% EXPENSE BUDGETED EXPENSE $ $ 15,000 $ 3,382,500 $ 17,850 $ 1,341,144 $ ACTUAL&ACCRUED 997 45,591 1,287 105,431 EXPENSE.OVER JUNDE!!)'..' I $ --. - ,$ � � (14,004 . 0,3364969 S , 11 6.86311S (1.235,71'3) %OF BUDGET EXPENDED 0.0% 6.6% 1.3% 7.2% 7.9% ES TIMA!ED FUND D BAL ANCE FUND BALANCE-01/0112018 (1,454,426) $ 151,706 $ 2,078,828 $ 8,809 $ 228,128 $ ACTUAL&ACCRUED ADD: REVENUE 71 2D 3,250,805 19,002 1,207,773 LESS: EXPENSE 997 45,591 1,287 105,431 FUND BALANCE-02/28/2018 $ 0 A54 354 150,72914 5,284,042 $ 26,524 $ 1,330L469 $ CASH and CASH EQUIVALENTS UNRESERVED CASH CASH(CHECKING/SAVINGS) $ 548,923 $ 150,729 $ 6,284,042 $ 26,324 $ 1,330,469 $ CASH-SJC OPERATING INVESTMENTS PETTY CASH TOTAL-UNRESERVED CASH $ 648,923 $ 150,729 $ 5,284,042 $ 26,524 $ 1,330,469 $ RESERVED CASH PARKS&OPEN SPACE PLAN $ $ - $ $ $ $ GENERAL PURPOSE BENEFIT HIGHWAY EQUIPMENT PRESERVE MAINTENANCE LAND STEWARDSHIP FUNDS FOR BOND REFUNDING FIDUCIARY FUNDS 215. 312 TOTAL-RESERVED CASH $ $ $ $ $ 215,312 TOTAL SASH-0212812018 648.923 $ 150 729 1 9 S.2_84.042 A_......26,624 l 3 ,A—1 _-04-69 j$ 215 3— A _ 12: :: Page 2 of 4 Nix a (A M dl d9 d! N a cC d o a G � o A va ti n I CCv a a p p N x 'R In toe9 to fa w to U ui p"t' G 1N0 N N cc 0. N cn en a9 �n u9fA W ' N N ¢ C dadae 4 cy w D Lu ai ag o p 2 rn inai ui en ar46 z W r I II I I h r r e ❑ o F W Q F! X6 u W W ¢ en vi to d► to 'a 'x o ® lu z WE W w GO 0 en W I o w ' toRT w o o f c ' ` N N LL 1+ C O O a'n 6% rn an 40 0 49 of fA Co x ' N N " 2' Nr ' :wA co ' [d G w w ID eq, CI � C m CJ q q O d 5 f!Y Mlto N infA IM! N CO EO � G1 p o7 Z W W 0 zw W W N 9 W c` � N WU D O c�7 4 a 0 0 �� JQr � z W � �R x � �d o W a1J 7 L7 11S a $ " yj >W W q $ � i o AdU. i Z0 y� co ¢ m ¢ t1t w 2 z r 0 40 0 w v 0 0 Ono AIR co 0 N r: to d gr 'r 16 10- to 0 CD aC4 C; C4 of CY M m 69 40 a fa o " VC .8 �= 4 0 go co K r: q N 0) OD J1 C6 q O co fa M 0 4S 45 to O 0 d Lon to to W 69 cp a) Ctl n n M 00 I co LoN z 0 to Im CY to 49 ii 0y m 0 0 0 0 cc :1 0 0 . to S. Q) U, 0 el ► 9 to Z Cd l I to w Eq 4N 0) z ui Z wB m 0 cc Z IL 0 0 40 0 0 cc 0 co 'M a 00 MC9 C! zt7 SO 2 ; I 0 Fn z LL. w 0 CD a) 0 in > co W 0 W 0W 0 RI 00 op z t7 z 9 C, Y rpp E cc C6 Ln O 'D U. tri rn 69 co co z CC p w lu L5 0 w z Lu w a n 0 z Z w 0 a Z ff w ir 0) W LU iL X cc MA w KU lu Q Lu m W m w ul o X4 '0. 0ul> tu 0 z z z X lt3u -%( 0 w u [L 06 -6 x Q) < z m U) Z) tj 4CC Z M w U. M O 0 OL, w qA in t0 4 z m > U. z i TOWN OF ITHACA DETAILED CASH LISTING - FIDUCIARY FUNDS FOR THE MONTH ENDED FEBRUARY 28, 2018 DESCRIPTION AMOUNT TRUST&AGENCY FUND TA200C DISBURSEMENTS CHECKING TA200P PAYROLL CHECKING 8,771.34 TA202 ON-LINE COLLECTIONS 10.40 TA205 ROAD USE AGREEMENTS 31,480.70 TA206 ITHACA TOWERS OPTION ESCROW 11,874.69 TA207 UNCLAIMED BAIL-ITHACA TOWN COURT 3,152.17 TA209 EMPLOYEE FLEXIBLE SPENDING 13,669.43 TA210 STORMWATER COALITION 67,963.98 TA211 PLANNING DEPOSITS 9,120.07 TA212 CAYUGA LAKE WATERSHED INTERMUNICIPAL ORG 36,993.46 TA214 LAKE VIEW CEMETERY-PERMENANT MAINT FUND 18,771.13 TA215 LAKE VIEW CEMETERY-FERRIS MEMORIAL FUND 11,504.55 TOTAL CASH: TRUST&AGENCY FUND $ 215,311.92 GENERALTOWNWIDE FUND A237 INLET VALLEY CEMETERY $ 4,421.14 TOTAL CASH; FIDUCIARY FUNDS $ 219,73326 t i 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 44.70 Total-Road Use Agreements $ 31,480.70 Unclaimed Bail-Ithaca Town Court: TB Resolution No.2016-166,adopted 12/12/2016 $ 1,750.00 Exp. IW612022 TB Resolution No.2017-075c,adopted 6/26/2017 1,400.00 Exp. 612612023 Accrued Interest-transfer to General Fund 2.17 Total-Unclaimed Bail-Ithaca Town Court $ 3,152.17 Planninn Deposits: Nextel Site Lease Deposit S 4,510.32 Wireless One Site Lease Deposit 4,601.43 Accrued Interest-transfer to General Fund 8.32 Total-Planning Deposits $ 9,120.07 TOWN OF ITHACA SUMMARY OF BANK COLLATERAL FOR THE MONTH ENDED FEBRUARY 28, 2018 7'OMPKWS TRUST COMPANY. CASH&CASH EQUIVALENTS $ 21,648,254 INVESTMENTS TOTAL CASH ON DEPOSIT $ 21,648,254 LESS: FDIC INSURANCE $ 250,000 LESS: FMV OF COLLATERAL ON DEPOSIT @ 02128)2018 U.S. GOVERNMENT AGENCY OBLIGATIONS $ 31,570,645 OVER(UNDER)COLLATERALIZED $ 10,172,381 CASH ASSETS COLLATERALIZED @ FMV 02/28/2018 148% Collateral is held by the Bank of New York,pledged for the Town of Ithaca,New York,for all deposits andlor 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.