The URL can be used to link to this page

Home My WebLink About2019-03 Financial ReportFINANCIAL REPORTS FOR THE MONTH ENDED MARCH 31, 2019 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 MARCH 31, 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 $ 5,051,006 $ 518,911 $ 689,436 $ 2,169,828 $ 2,810,282 $ 1,608,584 INVESTMENTS 1,000,000 500,000 1,000,000 1,000,000 PETTY CASH 700 - 200 TOTAL - UNRESERVED CASH $ 6,051,706 $ 1,018,911 $ 689,436 $ 3,170,028 $ 2,810,282 $ 2,608,584 RESERVED CASH: PARKS & OPEN SPACE PLAN $ 383,214 $ - $ - $ - $ - $ - GENERAL PURPOSE BENEFIT 194 96 144 48 50 HIGHWAY EQUIPMENT - 23,021 PRESERVE MAINTENANCE 190 LAND STEWARDSHIP 756 INVESTMENTS 764,500 69,400 340,300 23,800 12,000 FIDUCIARY FUNDS 4,428 TOTAL - RESERVED CASH $ 1,153,281 $ 69,496 $ - $ 363,465 $ 23,848 $ 12,050 OTHER ASSETS: ACCOUNTS RECEIVABLE $ - $ - $ - $ - $ _ $ WATER & SEWER RECEIVABLES - 136,763 168,870 DUE FROM OTHER FUNDS STATE & FEDERAL AID RECEIVABLE_ DUE FROM OTHER GOV'TS 10,815 24,737 PREPAID EXPENSE=S 9,129 6,747 22,556 6,844 3,913 TAXES RECEIVABLE - CURRENT TOTAL - OTHER ASSETS $ 9,129 $ 10,815 $ 6,747 $ 22,556 $ 168,343 $ 172,783 TOTAL ASSETS 7,214,116 1.099.221 696183 3,556,048 3.002473 2,7931418 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,281 69,496 363,465 23,848 12,050 UNRESERVED FUND BALANCE 5,772,243 819,988 696,183 3,055,111 2,978,754 2,758,178 TOTAL LIABILITIES &FUND BALANCE 7 214116 1.099.221 696,183 3 556 048 3, 02,4731$ 2.79 418 -3 ESTIMATED FUND BALANCE FUND BALANCE - 01/01/2019 $ 4,262,061 $ 1,223,969 $ 2431125 $ 2,670,329 $ 3,057,301 $ 2,512,811 ADD: REVENUE 3,720,032 71,989 808,635 1,450,713 2,050,067 841,420 LEss: EXPENSE 1,056,569 406,474 362,323 725,022 2,111,610 587,916 FUND BALANCE - 03/31/2019 6,926.524 889 484 688 436 3,396,019 2,995,758 2,766,3:1:6:j Page 1 of 4 TOWN OF ITHACA BALANCE SHEET FOR THE MONTH ENDED MARCH 31, 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 $ 512,748 $ 47,567 $ 3,354,895 $ 28,992 $ 1,592,612 $ INVESTMENTS 360,000 100,000 1,500,000 PETTY CASH TOTAL - UNRESERVED CASH $ 672,748 $ 147,567 $ 4,854,895 $ 28,992 $ 1,592,612 $ RESERVED CASH: PARKS & OPEN SPACE PLAN $ - $ - $ GENERAL PURPOSE BENEFIT HIGHWAY EQUIPMENT PRESERVE MAINTENANCE LAND STEWARDSHIP INVESTMENTS FIDUCIARY FUNDS 30,000 227,477 TOTAL - RESERVED CASH $ - $ - $ - $ - $ - $ 257,477 OTHER ASSETS: ACCOUNTS RECEIVABLE $ - $ - $ $ - $ _ $ CUSTOMER RECEIVABLE DUE FROM OTHER FUNDS STATE & FEDERAL AID RECEIVABLE DUE FROM OTHER GOWTS 1,034 PREPAID EXPENSES TAXES RECEIVABLE - CURRENT TOTAL - OTHER ASSETS $ 1,034 $ - Is $ - $ - $ TOTAL ASSETS 873,782 147,567_ 4,854,895 28 992 1.592.6121$ 257.477 LIABILITIES and FUND BALANCE $ - $ - $ $ - $ - $ 257,477 ACCOUNTS PAYABLE ACCRUED LIABILITIES DUE TO OTHER FUNDS RETAINAGE 90,131 DEFERRED REVENUE RESERVED FUND BALANCE UNRESERVED FUND BALANCE 783,651 147,567 4,854,895 28,992 1,592,612 TOTAL LIABILITIES & FUND BALANCE 873,7821$ 147,667 4,85 ,4 895 28.992 1,592,61g_ 257 477 ESTIMATED FUND BALANCE FUND BALANCE - 0110112019 $ 999,875 $ 149,222 $ 2,010,351 $ 14,488 $ 98,165 $ ADD: REVENUE 426 64 3,157,171 18,012 1,620,206 LESS: EXPENSE 216,651 1,720 312,626 3,508 125,759 FUND BALANCE - 03/31/2019 783.651 147,567- 4 854 895 28,992,11 1,592 612 Page 2 of 4 I IN 0) to to (a (0) to coo C* 0 w Ct ct 0 03 cq U) 40 44 69 0) ui m W co Of W) U) ItY U) to LO w % 4A to H fA tI1 fA fn to to 69 ffl try M to fo UY v1in 0 rn H1 ISI Go C11 N 69 to co U) in ui U) vi ui U) 40 to 69 fA V) 44 w 49 6% vs Z rz 0 fft fis to uj 41 A UJ uj >> LAJOW cc tj MW x per, Mo L", 20 11 � UJ om 0 U. c, � 0, Q)w w ul L B=gu,- w z 'o 1 8 5 LU a) In cl oom�. w z R(in m m R IT 0 V) W C71 I- CQ14 fi I - U1 i i C ..J W LLa Q° z W z W i © N O U a rz W Q � O W N ' C4 . . . . r r . N . . . r . m mom+ m m qroLn N co N RAW N M tg (0 Ff$ u3 CA e+i v . . r a , ,� . . . r , co eq to M I 4to 7 Sto �9 h r Rt cf C,co Cq M M r C+t C9 to :fJ d!to {g Vhf . Uri e . , . r r r C r . r . .GoCl- N r Oft Q4f CL7 M In +x t! ct v eP CV Cl) to to C9 UD. 69 69 dj • M r . , a r r r �rj r r , , r � r ^ n m N (0 49 cFs of tEa to to to . r r to r r to to Ch r m N N N C N O o N r r r r r r 69 b3 CR d3 b3 �. CV • CNCS� r e . , . r r Cy . r r . , 60 4f? FFy N34A, to to 4A to. r r r r... to r I to w co eq Rt CY un try In O to � ham. Ln Chi M M M M " N 64 41. CA fi} Vi di 440� t% � . . . . r �J' C+� CL1 CCS tJC7 CES W p5 M N T r A r A r b'C 6-3 CA b449 to {g * . p N n ti o o rtdi so to o w N +U4 f$ 69 4s 69iA fig Cg N. s�)} V) C Y CJ CV CV 3 Ch to C7 6 O O O in Cil r A r r r (a M i9 i9 49 44 69«q U J 0) L) M (.) i WWNW M Cq W z p 4 r U -j -i �i ups SWI=<toma m�Sa in z w o w w ww=ww?w w c+s }mM> z LL P W z �m JUrL XCW.y W� 0.J � idt W .l Ct�J 4 mocdom r N '�' NpCiW W y0.' ' W X N= pOwwRtn a "°� °q4 ��o[ y W J W m CC W a Q r M a W .t -+� .. ac Q w W N WH W 8UlW Qwy�M Q + %WU.w CC1 Rr0GiddE-GCQO 1- CiUWu, u1 tC F- C> _h O QC?pNfiF-F- F GQmmw 3 l j It O st TOWN OF ITHACA REVENUE and EXPENSE SUMMARY FOR THE MONTH ENDED MARCH 31, 2019 D E GENERAL T. "kwhlbhl FUN GENERAL PART -40 N'`:� '.,T HIGHWAY WNWID5 6"' FU 0� "HIGHWAY-- f,'PA§T-foWN ATER,-.�:, FUND: SEWER REVENUE BUDGETED REVENUE $ 5,523,736 $ 1,697,150 $ 813,750 $ 3,117,000 6,641,822 $ 2,833,445 ACTUAL & ACCRUED 3,720,032 71,9891 808,635 1,450,713 2,050,067 841,420 `8 - J .1 4 -- - I % OF BUDGET EARNED 67.3% 4.5% 99.4% 46.5% 30.9% 29.7% EXPENSE BUDGETED EXPENSE $ 5,938,282 $ 1,857,520 $ 714,840 $ 3,440,050 6,694,528 $ 2,876,445 ACTUAL & ACCRUED 1,056,569 406,474 362,323 725,022 2,111,610 587,916 % OF BUDGET EXPENDED 17.8% 21.9% 50.7% 21.1% 31.5% 20.40/6 ESTIMATED FUND BALANCE $ 4,262,061 $ 1,223,969 $ 243,125 $ 2,670,329 $ 3,057,301 $ 2,512,811 FUND BALANCE - 01/01/2019 ACTUAL & ACCRUED ADD: REVENUE 3,720,032 71,989 808,635 1,450,713 2,050,067 841,420 LESS: EXPENSE 1,056,569 406,474 362,323 725,0221 2,111,610 587,916 AN FUND SALA, $ ?SL925A24j. CASH and CASH EQUIVALENTS UNRESERVED CASH CASH (CHECKING/SAVINGS) $ 5,051,006 $ 518,911 $ 689,436 $ 2,169,828 $ 2,810,282 $ 1,094,506 CASH - SJC OPERATING 514,078 INVESTMENTS 1,000,000 500,000 1,000,000 1,000,000 PETTY CASH 700 - 200 - - TOTAL - UNRESERVED CASH $ 6,051,706 $ 1,018,911 $ 689,436 $ 3,170,028 $ 2,810,282 $ 2,608,584 RESERVED CASH PARKS & OPEN SPACE PLAN $ 383,214 $ $ $ - $ - $ GENERAL PURPOSE BENEFIT 194 96 144 48 50 HIGHWAY EQUIPMENT 23,021 PRESERVE MAINTENANCE 190 LAND STEWARDSHIP 756 INVESTMENTS 764,500 69,400 340,300 23,800 12,000 FIDUCIARY FUNDS 4,428 .1 TOTAL - RESERVED CASH $ 1,153,281 $ 69,4961$ -1$ 363,465 1 $ 23,848 1 $ 12,050 TOTALCASH -.'05%31/201'9 Page 1 of 4 TOWN OF ITHACA REVENUE and EXPENSE SUMMARY FOR THE MONTH ENDED MARCH 31, 2019 Page 2 of 4 .".CAPITAL. RISK FIRE LIGHTING DEBT. TRUST,,& PONESORIP t PROJECTS' Fiji iihi PROTECT[ ON DISTRICT SERVICE AG INCY FUNDS, FU ND F6 ND r N REVENUE BUDGETED REVENUE $ - $ 15,000 3,174,000 $ 18,000 1,619,843 $ ACTUAL & ACCRUED 426 64 3,157,171 18,012 1,620,206 4,9".#16 % OF BUDGET EARNED 0.0% 0.4% 99.6% 100.1% 100.0% ,EXPENSE BUDGETED EXPENSE $ - $ 15,000 $ 3,415,000 $ 17,600 $ 1,688,194 $ ACTUAL & ACCRUED 216,651 1,720 312,626 3,508 126,759 �JWWI, % OF BUDGET EXPENDED 0.0% 11.5% 9.2% 20.0% 7.0% ESTIMATED FUND BALANCE 999,875 149,222 $ 2,010,351 $ 14,488 $ 98,165 $ FUND BALANCE - 01101/2019 ACTUAL & ACCRUED ADD: REVENUE 426 64 3,157,171 18,012 1,620,206 LESS: EXPENSE 216,651 1,720 312,626 3,608 125,7591 fUNOBA- " . F4— '89s, CASH and CASH EQUIVALENTS UNRESERVED CASH CASH (CHECKING/SAVINGS) $ 512,748 $ 47,567 $ 3,354,895 $ 28,992 $ 1,592,612 $ CASH - SJC OPERATING - - - - INVESTMENTS 360,000 100,000 1,500,000 PETTY CASH - TOTAL - UNRESERVED CASH $ 872,748 $ 147,567 $ 4,854,895 $ 28,992 $ 1,592,612 $ RESERVED CASH PARKS & OPEN SPACE PLAN $ - $ - $ - $ - $ $ GENERAL PURPOSE BENEFIT HIGHWAY EQUIPMENT PRESERVE MAINTENANCE LAND STEWARDSHIP INVESTMENTS 30,000 FIDUCIARY FUNDS 227.477 TOTAL- RESERVED CASH $ -Is $ -1$ 257,4771 jTOTAL 'CASH .;03/3j/20j9 872 748 147 567: 4854805j 28A92 1,402,612 1:$L�, '�267477:1 Page 2 of 4 ci Lo V) rY C7 45 , 44 f9 W fl* C7 C7 Q> IA 44 19 to 0 to CID to N U) M Hi Y9 M t9 N1 b4 fA to 40 Im q CY N P5 C9 irk; Q C LO 4 La ui L6 C5 to CRrw to .10r 4 IJi CQ 1 40 4D V5 fll to 45 M 69 I -A uj w UA ui z CL im w = 1 ili, S CL m w W MW 0 z z (Ull w ru 0 x LU uj 0 U. 0 C w UO W t 5 pqq131 m v 5. a IN 0 " W 1w o cc 0 0 co m w co ti cm 0 0 Y",� wl q It N Am LU z w 0 O w uj z m 11 w ui ui 0. 5 . 1 w oz = W W 0: = w go z w0 0 cm 8 z z 00 cli to Rr ri to eq IN Um 0 LLx 0 'Ul in -C w ag C4 e- >1 z 0 Cq SRV CO 1 0 a C, 2 0) Cl)( co co 0 co im cm CV 40 44 4w A5§ 0 N j co N V w 1 Lo 19 UC), Ln ci ci ci C^J CS C4 N fo> O M Mco co OD r y., TZ r 4V Im 0 ImtCr C4 40 69, O co 0N i0a) Pi C4 o 0 0 CD Go (a -T (Ii is , Ln V) to w W) . Vk 69 v (D tm 12 LU z w 0 w uj z m 11 w ui ui 0. 5 . 1 w oz = W W 0: = w go z w0 H ru -0 8 z z co as Um 0 LLx 0 'Ul in -C w ag m 4 e- >1 z v (D tm 12 kPATi71ZW01a b d:TT�71 DETAILED CASH LISTING - FIDUCIARY FUNDS FOR THE MONTH ENDED MARCH 31, 2019 DESCRIPTION AMOUNT TRUST & AGENCY FUND TA200C DISBURSEMENTS CHECKING $ TA200P PAYROLL CHECKING 7,741.59 TA201 CASH IN TIME DEPOSITS 30,000.00 TA202 ON-LINE COLLECTIONS 7,626.83 TA205 ROAD USE AGREEMENTS 31,451.71 TA206 ITHACA TOWERS OPTION ESCROW 11,892.31 TA207 UNCLAIMED BAIL - ITHACA TOWN COURT 3,401.54 TA209 EMPLOYEE FLEXIBLE SPENDING 11,766.09 TA210 STORMWATER COALITION 68,280.93 TA211 PLANNING DEPOSITS 39,146.95 TA212 CAYUGA LAKE WATERSHED INTERMUNICIPAL ORG 43,309.05 TA214 LAKE VIEW CEMETERY - PERMANENT MAINT FUND 1,339.67 TA215 LAKE VIEW CEMETERY - FERRIS MEMORIAL FUND 1,520.68 TOTAL CASH: TRUST & AGENCY FUND $ 257,477.35 GENERAL TOWNWIDE FUND A237 INLET VALLEY CEMETERY $ 4,427.70 TOTAL CASH:.FIDUCIARY FUNDS $ 261,905.05 Road Use Agreements: Conifer Realty - Cayuga Meadows RUA Jeff Simmons -120 Maple Avenue Accrued Interest - transfer to General Fund Total - Road Use Agreements Unclaimed Ball - Ithaca Town Court: TB Resolution No. 2016-166, adopted 12/12/2016 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 15.71 $ 31,451.71 $ 1,750.00 Exp. 1211212022 1,400.00 Exp. 612612023 250.00 Exp. 10/09/2024 1.54 $ 3,401.54 $ 4,510.32 4,601.43 30,000.00 35.20 $ 39,146.95 TOWN OF ITHACA SUMMARY OF BANK COLLATERAL FOR THE MONTH ENDED MARCH 31, 2019 TOMPKINS TRUST COMPANY. CASH & CASH EQUIVALENTS $ 18 152 630 INVESTMENTS TOTAL CASH ON DEPOSIT LESS: FDIC INSURANCE $ 6,700,000 $ 24,852,630 $ 250,000 LESS: FMV OF COLLATERAL ON DEPOSIT @ 3131/2019 U.S. GOVERNMENT AGENCY OBLIGATIONS $ 28,015,230 OVER (UNDER) COLLATERALIZED $ 3,412,600 CASH ASSETS COLLATERALIZED @ FMV 3/31/2019 114°/d 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.