No preview available
HomeMy WebLinkAbout2018-01 Financial Report r TOWN OF ITHACA FINANCIAL REPORTS FOR THE MONTH ENDED JANUARY 31 , 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 JANUARY 31, 2018 GENERAL GENERAL HIGHWAY HIGHWAY WATER SEWER DESCRIPTION TOWNWIDE PART-TOWN TOWNWIDE 1 PART-TOWN: FUND FUND FUND FUND FUND J FUND ASSETS UNRESERVED CASH: CASH $ 2,826,761 $ 966,389 $ 96,403 S 1,391,783 $ 529,321 $ 2,376,172 INVESTMENTS PETTY CASH 700 - 200 TOTAL-UNRESERVED CASH 2,827,461 $ 966,389 S 96,403 1,391,983 529,321 $ 2,376,172 RESERVED CASH: PARKS&OPEN SPACE PLAN $ 827,731 S - $ $ - GENERAL PURPOSE BENEFIT 165,455 69,,394 79,327 23,812 i 12,035 HIGHWAY EQUIPMENT 250,017 PRESERVE MAINTENANCE 40,131 LAND STEWARDSHIP 9,845 INVESTMENTS FIDUCIARY FUNDS 4421 TOTAL-RESERVED CASH $ 1,047,584 = $ 69,39423,812 329,344 $ 1 $ 12,035 OTHER ASSETS: ACCOUNTS RECEIVABLE $ $ - $ � $ . $ 2,259 WATER&SEWER RECEIVABLES - - 201,590 185,383 DUE FROM OTHER FUNDS 92,213 87,149 1,980,305 STATE& FEDERAL AID RECEIVABLE 95,809 1 163,210 240,704 24, DUE FROM OTHER GOVT 737 PREPAID EXPENSES 44,634 15,249 17,107 4,855 2,297 TAXES RECEIVABLE-CURRENT 2,750,189 - i 800 000 1,400,000 991,864 197,894 TOTAL-OTHER ASSETS $ 2,982,846 $ 178,459 $ 800,000 $ 1,744,960 $ 3,203,350 $ 38 832 TOTAL ASSETS $ 6,857,8 Al $ ..,.-896,403 i $ 3,466,287 S 3 75483 $ 2,776,039 LIABILITIES'and FUND BALANCE ACCOUNTS PAYABLE $ $ ACCRUED LIABILITIES 247,317 207,175 130,435 3,139 27,048 DUE TO OTHER FUNDS 56,088 10,08555,046 58,144 RETAINAGE DEFERRED REVENUE RESERVED FUND BALANCE 1,047,584 69,394 329,344 23,812 12,035 UNRESERVED FUND BALANCE 5,5016,902 937,672 896,403 2,996,423 3,674,486 2,678,812 TOTAL LIABILITIES&FUND BALANCE 6 857 890 1 214 241 $ 896,403 $ 3,466,,287 3,756,483:[:$�2 776�039 ES TIMA TED FUND BA LA NCE : FUND BALANCE-01101/2018 $ 3,997,0102 $ 1,072,768 1 $ $ 2,267,511 2,820,,416 $ 2,838„426426 ADD: REVENUE 2,833,413, 40,348 950,006 f 1,402,462 9991,573 202,642 LESS. EXPENSE 275,931 1016,050 i 53,603 344,207 121,691 350,221 ,FUND BALANCE-01/31/2018 1 $ 6,554,485 1 $ 1,0017,066 $ 896,403 $ 3,3i5,767 3,698 299 $ 26=9 0 8=4 7 Page 1 of 4 TOWN OF ITHACA BALANCE SHEET FOR THE MONTH ENDED JANUARY 31, 2018 _—EA—PITAL _iRISK FIRE LIGHTING DEBT TRUST& DESCRIPTION PROJECTS RETENTION PROTECTION DISTRICT SERVICE AGENCY FUNDS FUND FUND A FUNDS FUND FUND ASSETS UNRESERVED CASH: CASH $ 548,889 $ 151,257 i $ 2,178,131 $ 8,809 $ 228,143 I $ INVESTMENTS PETTY CASH TOTAL-UNRESERVED CASH $ 548',889 $ 151,257 S 2,178,131 $ 8,809, 143 $ RESERVED CASH: PARKS& OPEN SPACE PLAN $ : $ GENERAL PURPOSE BENEFIT HIGHWAY EQUIPMENT PRESERVE MAINTENANCE LAND STEWARDSHIP FUNDS FOR BOND REFUNDING FIDUCIARY FUNDS 212,919 TOTAL-RESERVED CASH $ is ' s is is $ 212,919 OTHER ASSETS: ACCOUNTS RECEIVABLE $ i $ CUSTOMER RECEIVABLE $ DUE FROM OTHER FUNDS STATE&FEDERAL AID RECEIVABLE DUE FROM OTHER GOV'TS PREPAID EXPENSES TAXES RECEIVABLE-CURRENT 3 250 000 i TOTAL-OTHER ASSETS $ $ 3,250,000 $ $ - $ - TOTAL ASSETS ---548889 1151,957 1 5�428131 8 809 228,143 $ 212,919 LIABILITIES and FUND BALANCE ACCOUNTS PAYABLE $ $ $ 99,036 f� $ ACCRUED LIABILITIES $ 2212,919 DUE TO OTHER FUNDS 1,980,305 RETAINAGE 23,098 DEFERRED,REVENUE RESERVED FUND BALANCE UNRESERVED FUND BALANCE (1,454,514) 151,257 5,329,095 8,809 228,143 TOTAL LIABILITIES&FUND BALANCE_ 548889 I 151,1257 1 $ 5,428,1 jl is 8.809 228,143 i 212,919 .......... ESTIMATED FUND BALANCE FUND BALANCE-01/01/2018 $ (1,454,426) $ 151,706 $ 2,078,828 $ 8,809 $ 228,128 $ ADD. REVENUE 38 10 3,250,267 j 19,001 16 LESS: EXPENSE 459 IFUND BALANCE-01131/20,18 1454 38�811 $ 151.2571 $ 5,329,095 $ 27 809 S 228.143_L$ Page 2 of 4 T heYJ t'C1 +W G t'nR vl d e} Sa m 'T an 'kC Ln reF 4') 0. � 4P1 t! to Ch TT tY , E—�4 O' wn arY !10- '4Y f/9 U9 G"P mfi Ch 42 uI C5. Cr& U7 4r} in wn AA U) Cn 0) uj 4) 0 -i i� 6Pf 'V5 U! an am ark CJ4 fn G5 pa. w eco co m C wS * a. Cv x E0 10 cR 'CY et C3 �° r7' cro ru' to i a°°n 4ID all *^• arY '.L'6 afl Sdn Crkwn G!i an Q%�I w r r a t r wc0 r Ib n , w C1 m 5 G — a 04 C-4 C14 z L aTr Sp cl a5 Sr9 co LL cn r ca crn err err W wn ur wn u> CA 0 z ar t y a (L CC 42 i to u9 yr an 0 en to w,n in cn Q H m e C14 N � It 0 r � N E—L ""> 6 m o 04ro a atr 'ua ua F-^ �i y tq hi CV' li r6 ti ra ren an ve ca as w aC m U 0 z r v r LL ui 0 q 0 � LLr� 1 w Z �j: an aro- ao CA rn wo-ro va aro- ul uj tu 0 Cl7' 0' ? Lu m 225 an W an wn m+a cn w»... Jcli CV N: ICC o, m C6 xo M 0 ZU. .. 4 yr an ua wa ern an wo- vs ara'..... r1 I1 cu av ra t u us' c ur i v aq r to- is n n to Ca u n n n r n z LL K7 t" wrn ern wn aai. V) rn.. wrY'.. en '.,ern r rr sw n r a N! uy er n ,m .. in nn acr tea Lq y (n rn cn nLn LM ar S �s LLI 1=0Ta (A wn ara an w an 0) 4r? an to ara ana 4 'n4 U) lu z z m' CD a ®m > z -j .'a wRr3 Cn Lu CCwna CL Uul 7.. ua ua to au 0 1 � M h^= ® z.2 '.,Z Crn '=C C'" 0 w fn ua to < W , Cn °b ?-m m Z U- yam. �y W - � iA! Com] W Z x p�: � o LOU W CL` -j LL W Mme. Z ul z ',y^ 4u ' 0 6 au 4u °W Z 0 I h✓f—°F-W M a > w C ¢ � L9. C C7 a a Kt u7 w w2 a C7 t7'¢ w Cc - x J. irl J. 'O R LL w d ^a `� m ��4:b 2 d "� 441 .J� 9 � � aar w "�F w ...�W w � � "� ICY cc.�-,w�is w w � W a a Ul ica Z 4.1 aC t.i C7.&I')C3 2 XTl C.7 u U.�0.Y1 4 w Z C�: � 4 J C a a hl 2X7 W co 0 0 co co co 00 a co C6 0; fl: C6 6' — N N. 04 — CN 1IIII C7 W w (n U) (10 to afr V5 Cr? I of r 11 Ol . . N. . . CY 0 04 N C'l ;; 0 1 04 Cl) m 0 C9 Cl) in Cil'a Ict �5 0 c m 04 Of M rn m m z M CC M 0 U- U V) W tll� Ui > Cl) cl Ln an ul r M LO z CC U)i U) Cfr 010 0) C, -I 00 01 0) to w to z LL sf? c7 (n U) (n W air U) all IT -It Itt Cl) co C) 0) Ncolala N Ci m 0) Cs C 03 z err cra as xrr 'try cn U) MY (n 04 cor, co coW co ID (0 to tD o (0 (n -T It �r Cl) lzr CC < z D m 0 LL C, 0 r CL La as ars sa ur IR, IR o 22y 2a 0 cli CN MCf) m U. E 0 VE Zw 0 LU z Lia l Lia 0 :c F- F- (n z LO M oo to Ln LO in C m uj 0 x f- N of0 :E in 0 Z UJ Z cu :) m LL V) Gly 0 C) n C) . . . r r o n m o 0) 0) m cs U� 03 C) 0) 0 0 03 'co a) 0) 0 C) M co 00 Ci Cap ai ca ca 27 00 z m U) U� cn 0) C) 0 CD m 00 0) cn E to w w w w C6 0i 0 0 0 Z LL uj ua m z > z wdo z w LLJ z co 0 z C) _j -J Z Z m C4 04 M w (n W UJ U) uj cn w a w (1) en x cc _j W -J cn Z =) (n U'1 en< LLJI III < Cl)M < a M -- m z 03 z cn 0 C) IL L'i 0 1 cc m <73 U. w 0 :3 w w u 0) w cn Lu Uj uj CL r uj w �: Ld (D 0) > nfr> z U. p 0 cc cc Cc UJ F- <Lu W M a z U 0 ui X z z Lu z m 'n uj w ZZ uJ cn cc n LL W w M CC LL Uj 0 cr 2 0 z m 0.6 2 cr w 0 Lu w X —1 ul F- < =�0 CC uj <(1) -� 4 z w < w w U) (n Lt 0 F_ LL F- (L w < -j D = 0 X > w CC w (D W LLJ 0)W LU F- .4 Clew M X .I > w ui 6 (n cc < = m=) m 0 w LL U) 0: F- Z cn Z L) Z F- 0 0 U)CL 0 m w w z LU Z 0 =) -i 0 In x =) U- lum TOWN OF ITHACA REVENUE and EXPENSE SUMMARY FOR THE MONTH ENDED JANUARY 31, 2018 GENERAL GENERAL HIGHWAY HIGHWAY WATER SEWER DESCRIPTION TCI£N PART-TOWN TOWNWIDE PART TOWN FUND� FUND FUND FUND FUND FUND REVENUE BUDGETED REVENUE $ 4,560,778 $ 1,543,150 $ 810,750 $ 3,171,750 $ 7,081,208 $ 2,663,584 ACTUAL&ACCRUED 2,8,33,413 40,348 950,006 1,402,462 999,573 202,642 REVENUE OVER(UNDER) (1,727,3651 $ (1,502,802 $ 139 256 1 769 288 ,LS6 0�81635)' $ (2,460,9L21 % OF BUDGET EARNED 62.1% 2.6% 117.2% 44.2% 141% 7.,6% EXPENSE BUDGETED EXPENSE $ 4,978,222 $ 1,894,070 $ 773,185 $ 3,490,313 i $ 7,040,519 $ 3,302,208 ACTUAL&ACCRUED 275,931 106,050 53,603 344,207 121,691 350,221 EXPENSE OVER(UNDER) $ (4,792,991 1,788,02 32Y $ (3 146 106)' $ (6,�918�828): $ (2,951,987) %OF BUDGET EXPENDED 5.5% 5.6% 6.9% 9.9% 1.7% 10.6% ESTIMATED 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 2,833,413 40,348 950,006 1,402,462 9199,573 202,642 LESS: EXPENSE 275,931 106,050 53,603 344,207 121,691 350,221 FUND BALANCE-01/3112018 JS 6,554,485 $ 1,007,066 $ 896,403 $ 3,325,767 3,698,299 $ 2.690.847 CASH'and' CASH EQUIVALENTS :UNRESERVED CASH CASH(CHECKINGIS,AVINGS) $ 2,826,761 $ 966,389 96,403 $ 1,391,783 529,321 $ 866,259 CASH-SJC OPERATING - - - 1,509,913 INVESTMENTS - PETTY CASH 700 - 200 - TOTAL-UNRESERVED CASH $ 2,827,461 $ 966,389 $ 96,403 $ 1,391,983 $ 529,321 $ 2,376,,172 RESERVED CASH PARKS&OPEN SPACE PLAN $ 827,731 $ - $ - $ $ - $ GENERAL PURPOSE BENEFIT 165,455 69,394 79,327 23,812 12,035 HIGHWAY EQUIPMENT - - 250,017 PRESERVE MAINTENANCE 40,131 LAND STEWARDSHIP 9,845 INVESTMENTS - FIDUCIARY FUNDS 4,421 - - TOTAL-RESERVED CASH $ 1,047,584 $ 69,394 $ $ 329,,344 $ 23,812 12,035 ITOTAL CASH-01/31/2018 $ 3.875 0145 $ 1,0'35,783 S 96Z403............. ...........1,721,327 ; $ 553.133 2,,388,2,07 Page 1 of 4 TOWN OF ITHACA REVENUE and EXPENSE SUMMARY FOR THE MONTH ENDED JANUARY 31, 2018 CAPITAL RISK FIRE LIGHTING DEBT TRUST& DESCRIPTION PROJECTS RETENTION PROTECTION DISTRICT SERVICE AGENCY FUNDS FUND FUND FUNDS FUND j FUND REVENUE BUDGETED REVENUE $ $ 15,000 II $ 3,274,000 $ 19,000 $ 1,2018,144 ACTUAL&ACCRUED 38 10 1 3,250,267 19,001 j 16 REVENUE OVER(UNDER) $ 3,8 1 $ (10 F33)j $ —.1 1 $ 208 1129 % OF BUDGET EARNED 0.0% 0.1% 99.3% I 100.0% 0.01% EXPENSE BUDGETED EXPENSE $ 15,000 $ 3,382,500 17,850, $ 1,341,144 ACTUAL&ACCRUED 4591 EXPENSE OVER(UNDER) 1 $ 14,541L$�3 382 500 $ (17,85-07) 144 - %, %,OF BUDGET EXPENDED 0.0% 3,1% 0.0% 0.0% 0.01% ESTIMATED FUND BALANCE FUND BALANCE-0//0112918 $ (1,454,426)� $ 151,706 $ 2,078,82. 1 $ 8,809 $ 228,128 ACTUAL&ACCRUED ADD. REVENUE 38 i 10 3,250,267 19,001 16 LESS: EXPENSE 459 FUND BALANCE-01/31/2018 (1,454,388)1 $ 151,257 $ 5,329,095 27, 228,143 CASH and CASH EQUIVALENTS UNRESERVED CASH CASH(CHECKING/SAVINGS) 548,889 $ 151,257 2,178,131 8,809 $ 228,143 CASH-SJC OPERATING INVESTMENTS PETTY CASH TOTAL-UNRESERVED CASH $ 548,889 $ 151,257 $ 2,178,131 8,809 228,143 1 $ RESERVED CASH PARKS&OPEN SPACE PLAN $ $ GENERAL PURPOSE BENEFIT HIGHWAY EQUIPMENT PRESERVE MAINTENANCE I LAND STEWARDSHIP . FUNDS FOR BOND REFUNDING . FIDUCIARY FUNDS . 212,91 TOTAL-RESERVED CASH i $ . $ � s - f $ 212,919 [TOTAL CASH 0113112018 1 $ 548,889 51,257 2,178.131 8,809 $ 228,143 212,91 Q Page 2 of 4 00 " cc (n � mco CiLUITc Kr« o � � a OL ¢h as v m Ln C14 rw y-. „ rk rx _ Kw cq to N a, m m a to tip w C? Ka an Kra eaa'. to '..(0 vs art'.. sn cry U) LS C a cq p Z c co act </x raa to en 4+'r tilt ar} N 0 0 Cl) z COLP M em. C3 d +et Q L. I w 40 In 0Y'. to ata 4/y 4r9 7 F— cy IR ca ca uo ca ra to v A nLL . .. sn K an v'�I an a^i crf uj z d UJ 0. X a r°aa CL 2 = i c a x ca cu uj (n rrr cro aaa sn un va vs ca ca co az' F— Cl) ' UJ Q c c sea rn W w, LU to raa ua tip, fn an K0 w uj to ua Kn sn m rp m a in .., H ru cv ra 44 G o r- fi^• h" M, a7 C fA (A (n an W Sty W V) " w w ' Ln Km 3t .® Iq 6Cl i[S t!# 0 �'q$�. C °�.y m Chi � C � fAY LU 47 rC d5: tL' aAy C3 "S + waa tl a ua toLLJ ui to LLJ� tn 0 � c a ca uj a art an z w Kti a s wUui rIL occarw a tui �1i u Gil cry c� a: U > w �, as "x C a 4 a ¢ T wLli pm �' LU - UJ = �' a� w Mux �r �, »a > rta m a 'wu o U. ca z cn a) Lf) Lr) 0 0 00 C! Cq t3S C� co 00 co co w r, 0 C6 06 0 U) (n W U) a_ mo - 8 - C IN C%l 0 0 R Cl) ' Cl) m i5l N CV Cli W cl C� cNi 0 C4 Cq Of ca 0 �a cc 6 Z B M C) U. U W (00 ara Ld ersto co c a 0 0 0 w np Ui Vi lzr �@ w rz -0 t- LO 04 cl m C'i vi ci L6 IZ D :5 'oCj z (41 m U., W 0 Ln LO ma) m 1: Jr z :3 n m LL U) W Vy 0 m 4j) V) w .1 Ln LO cc a) co U) CO z C 04 M,U.1§ U) V) co 0 CO Do co cc co co Cl) r cn 4. 0 d p2> 0 C7 C7 >- < LL. m z Z W n; LL LLJ a w (D to C) to tD 0 z 0 0 LJ A E CV o4 cl� vi z LU en E U) 0 Cr7 C7Z 0 W z to Ud U) U) CL w x M LulLn u Cl C"L m co cmi C) r- 0 Cry Z 0 a 0 LU cr 0 LL w Ln m ti cn V Cco (a 00 co Zas V) V) (n V) C) M CD (n Ln to (0 CO 0 U) ca w z cc UJ Q co w 0 0 LLJ z tu ui z Lu UJ z :) a z cr cQ 0 Z LLJ W LU =) Z Z Lu < UA L'i X, w Q > 0- CC =) LU LLJ uj ui cn uj w f— x CC LU cr =, cn Ul C7 p tr > w w U U z z ui uj > ui z Z �e 0 0 a o a > 0- U Z w w yj ca uj a -J LLJ UJ U, UJ X ca M cc LU LUd z m WG' m M m W U. w U. rA > 0 U) z (1) UJ < 0 z m m u uj m 5 1 n _wj < > m < mil a9 ca < w LL LL L) Z TOWN OF ITHACA DETAILED CASH LISTING - FIDUCIARY FUNDS FOR THE MONTH ENDED JANUARY 31, 2018 DESCRIPTION AMOUNT TRUST&AGENCY FUND TA200C DISBURSEMENTS CHECKING $ TA200P PAYROLL CHECKING 7,810.82 TA202 ON-LINE COLLECTIONS 346.07 TA205 ROAD USE AGREEMENTS 31,478.77 TA206 ITHACA TOWERS OPTION ESCROW 11,873.97 TA207 UNCLAIMED BAIL-ITHACA TOWN COURT 3,151.97 TA209 EMPLOYEE FLEXIBLE SPENDING 13,413.06 TA210 STORMWATER COALITION 66,459.83 TA211 PLANNING DEPOSITS 9,119.51 TA212 CAYUGA LAKE WATERSHED INTERMUNICIPAL ORG 38,991.07 TA214 LAKE VIEW CEMETERY-PERMENANT MAINT FUND 18,769.97 TA215 LAKE VIEW CEMETERY-FERRIS MEMORIAL FUND 11;503.84 TOTAL CASH:TRUST&AGENCY FUND $ 212,918.88 GENERAL TOWNWIDE FUND A237 INLET VALLEY CEMETERY $ 4;420.87 TOTAL CASH: FIDUCIARY FUNDS $ 217,339.75 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 42.77 Total-Road Use Agreements $ 31,478.77 Unclaimed Bail-Ithaca Town Court: TB Resolution No.2016-166,adopted 1 2/1 21201 6 $ 1,750.00 Exp. 12/26/2022 TB Resolution No.2017-075c,adopted 6/26/2017 1,400.00 Exp. 612612023 Accrued Interest-transfer to General Fund 1.97 Total-Unclaimed Bail-Ithaca Town Court S 3,151.97 Planninq Deposits: Nextel Site Lease Deposit $ 4,510.32 Wireless One Site Lease Deposit 4,601.43 Accrued Interest-transfer to General Fund 7.76 Total-Planning Deposits $ 9,119.51 TOWN OF ITHACA SUMMARY OF BANK COLLATERAL FOR THE MONTH ENDED JANUARY 31, 2018 TOMPKINS TRUST COMPANY: CASH&CASH EQUIVALENTS $ 12,449,156 INVESTMENTS _ TOTAL CASH ON DEPOSIT $ 12,449,156 LESS: FDIC INSURANCE $ 250,000 LESS: FMV OF COLLATERAL ON DEPOSIT @ 01/31/2018 U.S.GOVERNMENT AGENCY OBLIGATIONS $ 17,571,650 OVER(UNDER)COLLATERALIZED $ 5,372,494 CASH ASSETS COLLATERALIZED @ FMV 01/31/2018 144% 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.