The URL can be used to link to this page

Home My WebLink AboutAudit Committee Agenda Packet - 01/19/2016City of Colleyville Page 1 City of Colleyville Audit Committee Agenda City Hall 100 Main Street Colleyville, Texas 76034 817.503.1000 www.colleyville.com Tuesday, January 19, 2016 5:00 p.m. City Manager’s Conference Room Third Floor – City Hall 1.CALL TO ORDER 2.REGULAR AGENDA ITEMS 2a Meet with representatives from the City's audit firm Pattillo, Brown and Hill, L.L.P. to discuss the interim progress of the Fiscal Year ended September 30, 2015 audit 3.PRESENTATIONS 3a Presentation of the Quarterly Investment Report for quarter ending December 31, 2015 4.ADJOURNMENT I hereby certify this agenda was posted on City Hall bulletin boards Friday, January 15, 2016, by 5:00 p.m. Amy Shelley, TRMC City Secretary A quorum of the Colleyville City Council and/or any other Colleyville Board, Commission, or Committee may be in attendance at this meeting. Any matter on this agenda may, at the discretion of the governing body, be opened for public comment and discussion. If you plan to attend this public meeting and have a disability that requires special accommodations, please advise Executive Secretary at least 48 hours in advance at 817.503.1111, and reasonable accommodations will be made to assist you. City of Colleyville Page 1 City of Colleyville Audit Committee Agenda Briefing City Hall 100 Main Street Colleyville, Texas 76034 www.colleyville.com Agenda Number 2a Agenda Date 01/19/2016 Number Type Regular Agenda Items Department Finance Title Meet with representatives from the City's audit firm Pattillo, Brown and Hill, L.L.P. to discuss the interim progress of the Fiscal Year ended September 30, 2015 audit Strategy Map Connection Explanation John Manning, partner with Pattillo, Brown & Hill, L.L.P., will meet with the Audit Committee to discuss the interim progress of the Fiscal Year September 30, 2015 audit. Attachments F1- Protect and preserve the City’s top financial ratings F4- Adhere to the City’s financial and budgetary policies City of Colleyville Page 1 City of Colleyville Audit Committee Agenda Briefing City Hall 100 Main Street Colleyville, Texas 76034 www.colleyville.com Agenda Number 3a Agenda Date 01/19/2016 Number Type Presentation Department City Manager Title Presentation of the Quarterly Investment Report for quarter ending December 31, 2015 Strategy Map Connection Explanation During the period of October 1, 2015 through December 31, 2015, the City of Colleyville had an average of $48,489,442 invested on a daily basis, which earned $46,941, with an average yield of 0.39%. The average yield on investments for this quarter is 0.06% higher than the prior quarter's average of 0.33%. As of December 31, 2015, the City had $49,462,899 invested in the LOGIC Investment Pool, CDARS Certificates of Deposit, and various debt instruments in the following percentages: Logic 48.24%FFCB Notes 13.95% FHLB Notes 21.94%FHLMC Notes 2.02% Treasury Note 2.63%CDARS CD's 9.20% FNMA Notes 2.02% These percentages are within the guidelines for portfolio diversification in the City's investment policy. The market value of the City's investments on December 31, 2015 was $21,001,631 as compared to a purchase price of $21,082,161 (this excludes LOGIC Investment Pool and CDARS Certificates of Deposit). The Colleyville Economic Development Corporation currently holds a Treasury Note ($500,000) with a market value of $497,207 and a purchase price of $499,750. Additionally, $999,588 was invested in the Corporation's name in the LOGIC Investment Pool. These funds earned interest of $1,265 for the quarter. Attachments 1.Quarterly Investment Report for Quarter Ending December 31, 2015 F2- Invest to provide and maintain high quality public assets F4- Adhere to the City’s financial and budgetary policies B4- Cultivate a culture of transparency and consistent communication QUARTERLY INVESTMENT REPORT FOR QUARTER ENDING DECEMB ER 3 1, 2015 THIS REPORT IS IN COMPLIANCE WITH THE PUBLIC FUNDS INVESTMENT ACT AND ADOPTED INVESTMENT POLICY STRATEGY '{fa OUTS TANDING INVEST MENTS AT DECE MB ER 31 2015 PURCHASE PAR MARKET VALUE MATURITY YIELD ON PRICE VALUE @ 12/311 15 DATE INVESTMENT FFCBNOTE $1 ,004,070 S1 .000.000 $1 ,000,731 51912016 0 375% FHLBNOTE $1 ,198200 $1,200000 $1199.263 6110/2016 0450% FHLB NO TE $1,000,590 $1 ,000000 $997,854 10/17120 18 0470% FFCB NOTE $1 ,01 5 ,700 $1 ,000.000 $1 ,009,373 1112212016 0375% FHLBNOTE $1 .201.548 $1.200.000 $1197 849 11/23/2016 0560% FHLB NOTE $1 ,301,014 51,300.000 $1 .298.8 17 12/1212016 0.660% TREASURY NOTE $1 ,301 ,219 Sl ,300,000 $1 297.969 12/1 512016 0562% FHLB NOTE $1.000.000 S I 000,000 $1 000.281 312312017 0750% FH LB NOTE $1 .003,800 $1 000,000 $998,973 4fl/2017 0 735% FHLB NOTE $750,000 $750.000 $748143 611212017 0 820% FFCBNOTE $1 .001 230 $1 .000000 $996990 6116/2017 0 735% FH LB NOTE $1.000,390 $1,000,000 $998.640 6/3012017 0710% FHLMCNOTE $1.()04,385 SI 000.000 $997 ,162 7128/201 7 0600% FFCBNOTE $1 .003690 $1,000000 $995 886 812812017 o~ FFC B NOTE $1 ,000,000 $1,000,000 $998.0 11 9/141201 7 0 780% FFCBNOTE $897.660 $900,000 $893.387 10/1312017 0785% FHLB NOTE $1 .199.868 $1.200.000 SI , 189 264 10126120 17 0630% FN MA NOTE $999 ,800 $1,000,000 $995,870 10/2612017 0885% FFCBNOTE $999000 S1 000000 $993,135 111612017 0811 % FHLB NOTE $1 .200,000 $1,200,000 $1 , 198.253 1212912017 1010% TOTAL OUTSTANDING INVESTMENTS $21 ,082 161 $2 1,050 000 $21,001 631 CITY OF COLLEYVILLE BALANCES AT DECE MBER 31 . 2015 INVESTMENT PUR CHASES $21,050.000 CDAR'S CERTIFICATES OF DEPOSIT $4,549663 LOGIC INVESTMENT POOL $23 863.236 TOTAL CITY INVESTMENTS HELD AT DECE MBER 31, 2015 $49462,899 COLLEYVILLE ECONOMIC DEVELOPMENT CORPORATIO N (CEDC) BALANCES AT DECE MB ER 3 1, 2015 INVESTMENT PURCHASES $500.000 LOGIC INVESTMENT POOL $999.588 TOTA L CEDC INVEST MENTS HELD AT DEC 3 1 2015 $1 ,499 .588 TOTAL INVES TMENTS HELD BY CITY OF COLLEYVILLE AND COLLEYVI LLE ECONOMIC DEVELOP MENT CORPORATION AT DECE MBER 31 , 2015 $50,962.487 INTEREST EARNINGS ON CITY OF COLLEYVILLE INVESTMENTS FOR THE PERIOD OF OCTOBER 1 . DECEMBER 31, 2015 PURCHASE PAR MATURITY YIELD ON INTEREST PRICE VALUE DATE INVESTMENT EARNED FFCB NOTE $1 ,400.000 $1 ,400,000 11/412015 0350% S470 FFCBNOTE $500 478 $500000 1114/2015 0300% $t44 FHLBNOTE S1 .000.000 $1.000.000 1111312015 0330% S398 FFCBNOTE'' $1199.280 St 200.000 1112712015 0250% $156 FHLB NOTE St ,000,000 $1,000,000 t211 t/201 5 0.390% $769 FFCB NOTE $750.285 $750 .000 t21t7/2015 0268% $430 FFCB NOTE" $999 600 $1 ,000 000 4/2512016 0330% $172 FFCBNOTE $1 .004,070 St.000,000 519/20 16 0375% $945 FHLBNOTE $1 198,200 St 200,000 6/t0/2016 0450% St .36t FFCB NOTE " $999.500 S1 000.000 814/2016 0575% $347 FHLBNOTE St.000.590 St 000.000 10/t7/20t6 0470% St.t8!> FFCB NOTE $1 ,015,700 $1 ,000,000 1t/22f.10t6 0375% $360 FHLBNOTE St.20t .546 St 200.000 t t/23/2016 0560% St.694 FHLB NOTE $t,301.0t4 St .300,000 12112(.1016 0.660% $2,164 TREASURY NOTE $1 ,301,2t9 $1 ,300,000 12115/2016 0562% $1 ,842 FHLBNOTE St,000.000 $1 000,000 3123/2017 0750% $1 .890 FHLB NOTE $1 ,003,800 $1 000,000 4n12ot1 0735% $1 ,853 FHLBNOTE" $999.500 St .000.000 511212017 0745% $878 FHLB NOTE $750.000 $750.000 61 1212 01 7 0 820% $1,550 FFCBNOTE S1.00t 230 $1.000000 6/t6/2017 0735% $1 .853 FHLBNOTE $100.390 $1 ,000 000 613012017 0710% St,790 FHLMC NOTE $1 ,004 385 St .000000 712812017 0600% $362 FFCBNOTE St ,003.690 St,000000 812812017 0580% $302 FFC B NOTE $1,000,000 $1 ,000.000 9/14/20 17 0 780% $1,966 FFCBNOTE S897,660 S900000 10/1312017 0785% $678 FHLBNOTE $1.199,868 $1,200,000 10/2612017 0630% $394 FNMA NOTE $999,800 St .000,000 t0/26/20t7 0885% St,067 FFCB NOTE $999,000 St ,000,000 t t/612017 0.8t1% S955 FHLBNOTE St,200,000 St,200,000 12/2912017 1 Ot0% $2,988 TOTAL INTEREST EARNED ON CITY I NVESTMENTS HELO OCTOBER 1, 2015 THROUGH DECEMBER 31 , 2015 $30,963 •• EARLY CALL ON INVESTMENT RECAP OF MARKET VALUES ON CITY OF COLLEYVILLE INVESTM ENTS HELD OCTOBER 1 • DECEMBER 31 , 2015 INVESTMENT FFCBNOTE FFCB NOTE FHLB NOTE FFCBNOTE FFCBNOTE .. FFCB NOTE .. FHLB NOTE FFCB Nore·· FFCB NOTE FHLB NOTE FFCB NOTE FHLBNOTE FHLBNOTE FHLB NOTE FHLB NOTE .. TREASURY NOTE FHLB NOTE FHLB NOTE F FCB NOTE FHLBNOTE FFCBNOTE FFCBNOTE FHLB NOTE FHLMC NOTE FFCB NOTE FFCB NOTE F FCB NOTE FNMA NOTE FH LB NOTE TOTALS PURCHASE DATE MATURITY PURCHASE DATE PRICE 11 11/2013 11 1412015 $1,400,000 121312013 11 1412015 $500.478 11312014 1211 112015 $1,222,800 312712014 1111312015 $1 ,000,000 4/25/2014 4125/2016 $1 ,000,000 512712014 1112712015 $1, 199,280 611212014 611012016 $1 ,198,200 81412014 8/4/2016 $999,500 101612014 1211712015 $750,285 1012212014 1011712016 $1,000,590 1111412014 51912016 $1 ,004,070 1112412014 1112312016 $1 ,201 ,546 1211812014 1211212016 $1 ,301 ,014 312312015 312312017 $1 ,000,000 511212015 511212017 $999,500 6115/2015 12115/2016 $1 ,301 .219 611912015 611212017 $750,000 612412015 417/2017 $1,003,800 711512015 6116/2017 $1 ,001 .230 71612015 613012017 $1 ,000,390 911612015 911412017 $1 ,000,000 101191201 5 812812017 $1.003.690 10119/2015 10126/2017 $1 ,199,868 1012212015 7128/2017 $1 .004 .385 111412015 11 12212016 $1,015,700 111412015 1011312017 $897,660 11 11212015 11161201 7 $999,000 1111312015 1012612017 $999 ,800 1212912015 1212912017 $1,200,000 PAR VALUE $1 ,400.000 $500 000 $1,200.000 $1,000,000 $1 ,000,000 $1 ,200,000 $1,200,000 $1 ,000,000 $750,000 $1 ,000 ,000 $1,000,000 $1 ,200,000 $1,300,000 $1,000,000 $1 ,000.000 $1 ,300,000 $750,000 $1,000.000 $1 ,000,000 $1 ,000 000 $1,000.000 $1 ,000,000 $1 ,200,000 $1 ,000,000 $1 ,000,000 $900,000 $1 ,000,000 $1 ,000,000 $1 .200,000 MARKET VALUE @9·30·15 $1 .400 288 $500,103 $1 ,203,000 $1 ,000,160 $999,793 $1 ,200,012 $1 , 199,980 $1 ,000.036 $750,320 $1 ,000,491 $1,002,328 $1 ,201 ,771 $1 ,302,313 $1 ,002.144 $999,593 $1 ,302 .742 $751 ,738 $1,004,563 $1 ,001 ,879 $1 ,001.485 $1 ,001,447 NIA NIA NI A NIA NIA NIA NIA NIA $21 ,826, 185 LESS MATURITY PROCEEDS $1 ,400,000 $500,000 $1,200.000 $1 ,000,000 $1 ,000,000 $1 ,200,000 NIA $1 ,000.000 $750,000 NIA NIA NIA NIA NIA $1 ,000,000 NIA NIA NIA NIA NIA NIA NIA NIA NI A NIA NIA NI A NI A NIA $9,050,000 PLUS PERIOD PURCHASES NIA NIA NIA NI A NIA NIA NIA NI A NIA NIA NIA NIA NIA NIA NIA NIA NI A NIA NI A NIA NIA $1,003,690 $1 ,199.868 $1,004,385 $1 ,015,700 $897,660 $999.000 $999,800 $1 ,200,000 $8,320.103 MARKET VALUE @ 12·31-15 $0 so $0 so $0 $0 $1 , 199,263 so $0 $997.854 $1 ,000,731 $1 ,197,649 $1 ,298,817 $1.000,261 $0 $1 .297 969 $748.143 $998,973 $996,990 $996,640 $996,011 $995.886 $1 ,189,264 $997 .162 $1,009,373 $893.387 $993, 135 $995.870 $1, 198,253 $21 ,001 ,631 LISTING OF INVESTMENTS BY GENERAL LEDGER ACCOUNT NUMBER OUTSTAN D ING INVESTMENTS AT 12-3 1-15 INVESTMENT- ACCOUNT ALLOCATION OF I NVESTMENT GIL TOTAL 001-1172 GEN ERAL FUND OPERATING $3,751 ,538.90 002-1166 UTILITY DEBT SERVICE RESERVE $643 ,699.78 002-1172 UTI LITY FUND OPERATING $3 ,675.701 87 002-11 78 CUSTOMER DEPOSITS $197.802.63 002-1186 UTILITY LINE RENEWAL $2.492,826.00 002-1557 THE RESERVE LIFT STATIO N 562.103 77 003-1180 BEDFORD BRIDGE ESCROW $35,907 83 003-1188 TOWN CENTER/HWY26 $36,326 67 003-1192 MCDONWELL WOODS EST ESCROW $10,996.31 003-1200 LO NGWOOD-PARKING ESCROW $13,380 01 003-1204 BEDFORD LAKES/SO MERSET $227,978.36 003-123 1 LAKEWOOD ESCROW $26, 103.65 003-1236 E. GLADE CRANBROOK ESCROW $117,794 .09 003-1247 GLADE/WAYSIDE ESCROW $42,420 01 003-1250 REATTA PLACE $98.462 36 003-1301 LAKEWOOD PH IV $77.530 57 003-1304 VILLAS DEL MAR $60,324.37 003-1307 STREET RECON STRUCTION $247,919 86 003-1309 COVENANT CHRISTIAN $140,343 10 003-1319 REMINGTON PARK $27.855 96 003-1323 SHALIMAR $69.691 .33 003-1325 PECAN GARDENS $32 ,389 .09 003-1330 REMINGTON PARK $81 ,068 37 003-1340 CAST LETON MANOR $81 .309 57 003-1 357 CITGO/LO LOC KE TT $56,809 28 003-1 392 CLAIRMONT-PH I $104 ,974 96 003-1404 TAN GLEWOOD $26, 111 .30 003-1418 CLAIRMONT -PH II $147,050 32 003-1429 WARWICK PARC $89, 131 .60 003-1434 ROCKR IMMON $65,055.06 003-1486 CHANEL'S COURT $47,895.39 003-1563 VILLAS OF CO LLEYVILLE $52,979.48 005-1172 VOLU NTARY PARK FUND $849.801 .56 011-1172 LIBRARY DONATIONS FUND $359.642 52 012-1172 PARK LAND DEDICATION FU N D $2, 114 ,816.14 017-1172 DRAINAG E FUND OPERATI NG $219.440 95 024-1172 CEDC OPERATING $499, 750.00 026-11 72 TIF OPERATING $3,87 1,536.57 032-1519 CAP ITAL EQUIPMENT RESERVE $450,000.00 034-1172 COLLEYVILLE TOMO RROW $375,441 .76 PER GENERAL LEDGER $21 ,581 ,911 35 MARKET VALUE $21 498.838 00 VALUE AT MATURITY $21 .550,000 00 INTEREST RECEIVED TO MATURITY $269.967.41 OUTSTANDING INVESTMENTS AT 12-31 -15 INVESTMENT FHLB NOTE FHLB NOTE FFCB NOTE FHLB NOTE FHLB NOTE DATE ACQUIRED 12-Jun-14 22 -0ct-14 14-Nov-14 24-Nov-14 18-Dec-14 MATURITY DA TE 10-Jun-16 17-0ct-16 09-May-16 23-Nov-16 12-Dec-16 26 WEEK T-BILL AUCTION DISCOUNT/WEEK OF PURCHASE 0.060% 0.060% 0.070% 0080% 0.120% YIELD TO MATURITY 0.451% 0.470% 0.375% 0.560% 0.660% ACCOUNT ALLOCATION OF INVESTMENT 001 -1172 GENERAL FUND OPERATING 0.00 0.00 0.00 1.060.29 002-1166 UTILITY DEBT SERVICE RESERVE 002-1172 UTILITY FUND OPERATING 449,796 .28 0 00 002-1178 CUSTOMER DEPOSITS 002-1186 UTILITY LINE RENEWAL 1,301,014 00 002-1557 THE RESERVE LIFT STATION 003-1180 BEDFORD BRIDGE ESCROW 003-1188 TOWN CENTER/HWY26 003-1192 MCDONWELL WOODS EST ESCROW 003-1200 LONGWOOD-PARKING ESCROW 003-1204 BEDFORD LAKES/SOMERSET 003-1231 LAKEWOOD ESCROW 003-1236 E. GLADE CRANBROOK ESCROW 003-1247 GLADE/WAYSIDE ESCROW 003-1250 REATIAPLACE 003-1301 LAKEWOOD PH IV 003-1304 VILLAS DEL MAR 003-1307 STREET RECONSTRUCTION 204 ,070.00 003-1309 COVENANT CHRISTIAN 003-1319 REMINGTON PARK 003-1323 SHALIMAR 003-1325 PECAN GARDENS 003-1330 REMINGTON PARK 003-1340 CASTLETON MANOR 003-1357 CITGO/LO LOCKETI 003-1392 CLAIRMONT-PH I 003-1404 TANGLEWOOD 003-14 18 CLAIRMONT-PH II 003-1429 WARWICK PARC 003-1434 ROCKRIMMON 003-1486 CHANEL'S COURT 003-1563 VILLAS OF COLLEYVILLE 005-1172 VOLUNTARY PARK FUND 200,374 .33 0 1 1-1172 LIBRARY DONATIONS FUND 359 ,642 52 0 12-1172 PARK LAND DEDICATION FUND 115 .983.26 100,187.16 017-1172 DRAINAGE FUND OPERATING 024-1172 CEDC OPERATING 026-1172 TIF OPERATING 847,850.00 499.872.46 800,000.00 450.127.54 032-1519 CAPITAL EQUIPMENT RESERVE 034-1172 COLLEYVILLE TOMORROW 350,350.00 25,091-76 PER GENERAL LEDGER $1,198 .200.00 $1 .000,590.00 $1 ,004,070.00 $1,201,545.60 $1,301 ,014.00 MARKET VALUE $1 .199 .263 20 $997,854.00 $1 ,000,73 1.00 $1,197,649.20 $1 .298.817 00 VALUE AT MATURITY $1,200 .000 .00 $1 ,000.000.00 $1 ,000,000.00 $1.200,000.00 S1 .300,000.00 INTEREST RECEIVED TO MATURITY $10 ,809.17 $9,350.80 $5 ,570.05 $13,441.03 $17 ,051.37 OUTSTANDING INVESTMENTS AT 12-31-15 INVESTMENT FHLBNOTE TREASURY FHLBNOTE FHLB NOTE FHLB NOTE DATE ACQUIRED 23-Mar-15 15-Jun-15 19-Jun-15 24-Jun-15 06-Jul-15 MATURITY DATE 23-Mar-17 15-Dec-16 12-Jun-17 07-Apr-17 30-Jun-17 26 WEEK T-BILL AUCTION DISCOUNT/WEEK OF PURCHASE 0.110% 0 110% 0.050% 0.080% 0.080% YIELD TO MATURITY 0 750% 0.562% 0 .820% 0.735% 0.7 10% ACCOUNT ALLOCATION OF INVESTMENT 001-1172 GENERAL FUND OPERATING 40,000 00 848.240 00 002-1166 UTILITY DEBT SERVICE RESERVE 002-1172 UTILITY FUND OPERATING 190,762 23 002·1178 CUSTOMER DEPOSITS 002-1186 UTILITY LINE RENEWAL 37.511 00 1,003,800 00 002-1557 THE RESERVE LI FT STATION 003-1 180 BEDFORD BRIDGE ESCROW 35,907.83 003-1188 TOWN CENTER/HWY26 003-1192 MCDONWELL WOODS EST ESCROW 003-1200 LONGWOOD-PARKING ESCROW 003-1204 BEDFORD LAKES/SOMERSET 003-1231 LAKEWOOD ESCROW 003-1236 E GI.ADE CRANBROOK ESCROW 003-1247 GI.ADE/WAYSIDE ESCROW 003-1250 REATTA PLACE 003-1301 LAKEWOOD PH IV 003-1304 V ILLAS DEL MAR 003-1307 STREET RECONSTRUCTION 003-1309 COVENANT CHRISTIAN 140 .343 10 003-1319 REMINGTON PARK 003-1323 SHALIMAR 003-1325 PECAN GARDENS 32,389 09 003-1330 REMINGTON PARK 81 ,068 37 003-1340 CASTLETON MANOR 003-1357 CITGO/LO LOCKETT 003-1392 CLAIRMONT-PH I 003-1404 TA NGLEWOOD 003-1418 Cl.AIRMONT-PH II 003-1429 WARWICK PARC 89,131 .60 003-1 434 ROCKRIMMON 65.055 06 003-1486 CHANEL'S COURT 003-1563 VILLAS OF COLLEYVILLE 005-1172 VOLUNTARY PARK FUND 250,000.00 199,427 23 011-1172 LIBRARY DONATIONS FUND 012-1172 PARK LAND DEDICATI ON FUND 7 10,000 00 461,448.71 227 ,1 97.01 017 -1172 DRAINAGE FUND OPERATING 69,440.95 024-1172 CEDC OPERATING 026-1 172 TIF OPERATING 421.536.57 152 ,150 00 032-1519 CAPITAL EQUIPMENT RESERVE 034-1172 COLLEYVILLE TOMORROW PER GENERAL LEDGER $1 ,000,000 00 $1 ,301.218 75 $750,000 00 $1 ,003,800 00 $1 ,000.390 00 MARKET VALUE $1 ,000.261 .00 s 1,297 ,969 40 $748,143 00 $998.973 00 $996,640 00 VALUE A T MATURITY $1,000,000.00 $1,300,000.00 $750,000.00 $1,000,000.00 $1.000.000 00 INTEREST RECEIVED TO MATURITY $15,020 55 $10,991 .92 $12,198.6 7 $13, 155.46 $14, 105 76 OUTSTANDING INVESTMENTS AT 12·31 ·15 INVESTMENT FFCB NOTE TREASURY NOTE FFCB NOTE FHLB FFCB NOTE DA TE ACQUIRED 15-Jul-15 31 -Jul-15 16-Sep-15 19-0ct-15 19-0ct-15 MATURITY DATE 16-Jun-17 31 -Jul-17 14-Sep-17 26-0ct-17 28-Aug-17 26 WEEK T-BILL AUCTION DISCOUNT/WEEK OF PURCHASE 0.110% 0.140% 0.240% 0 120% 0.120% YIELD TO MATURITY 0.7 35% 0.650% 0.7 80% 0630% 0.5 80% ACCOUNT ALLOCATION OF INV ESTM ENT 001-1172 GENERAL FUND OPERATING 1,000.000.00 0 00 002-1166 UTILITY DEBT SERVICE RESERVE 002-1172 UTILITY FUND OPERA TING 850,72900 499.868 00 6,363.67 002-1178 CUSTOMER DEPOSITS 002-1186 UTILITY LINE RENEWAL 150,501 .00 002-1557 THE RESERVE LIFT STATION 62.103.77 003·1180 BEDFORD BRIDGE ESCROW 003-1188 TOWN CENTER/HWY26 36 ,326.67 003·1192 MCDONWELL WOODS EST ESCROW 10.996 31 003-1200 LONGWOOD-PARKING ESCROW 13,380 01 003-1204 BEDFORD LAKES/SOMERSET 227,978 36 003-1231 LAKEWOOD ESCROW 26.103 65 003-1236 E GLADE CRANBROOK ESCROW 117,794 09 003-1247 GLADE/WAYSIDE ESCROW 42,420.01 003-1250 REAITAPLACE 98,462.36 003-1301 LAKEWOOD PH IV 003-1304 V ILLAS DEL MAR 60,324.37 003-1307 STREET RECONSTRUCTION 43,849.86 003-1309 COVENANT CHRISTIAN 003-1319 REMINGTON PARK 003-1323 SHALIMAR 69,691 33 003-1325 PECAN GARDENS 003-1330 REMINGTON PARK 003-1340 CASTLETON MANOR 003-1357 CITGO/LO LOCKEIT 56.809 28 003-1392 CLAIRMONT-PH I 104.974.96 003-1404 TANGLEWOOD 26 .111 .30 003-1418 CLAIRMONT-PH II 003-1429 WARWICK PARC 003-1 434 ROCKRIMMON 003-1486 CHANEL'S COURT 003-1563 VILLAS OF COLLEYVILLE 005-11 72 VOLUNTARY PARK FUND 011 -1 172 LIBRARY DONATIONS FUND 012-1172 PARK LANO DEDICATION FUND 017-1172 DRAINAGE FUND OPERATING 024-1172 CEOC OPERATING 499,7 50 00 026-1172 TIF OPERATING 700,000 00 032-1519 CAPITAL EQUIPMENT RESERVE 034-1172 COLLEYVILLE TOMORROW PER GENERAL LEDGER S1 ,001 .230.00 $499,750 00 $1 ,000,000.00 $1 ,199 868 00 $1 ,003.690 00 MARKET VALUE $996 .990.00 $497 .207 00 $996,011 .00 $1.189.263.60 $995.886 00 VALUE AT MATURITY $1 ,000,000.00 $500.000 00 $1 ,000.000.00 $1,200,000.00 $1.000,000.00 INTEREST RECEIVED TO MATUR ITY $14,141 .86 $6,510 95 $15.578.55 $15.297 81 $10.791 .19 OUTSTANDING INVESTMENTS AT 12-31-15 INVESTMENT F HLMC FFCBNOTE FF CB NOTE FF CB NOTE FNMA NOTE DA TE ACQUIRED 22 -0ct-15 04-Nov-15 04-Nov-15 12-Nov-15 13-Nov-15 MA TURITY DATE 28-Jul-17 22 -Nov-16 13-0ct-17 06-Nov-17 26-0ct-17 26 WEEK T-B ILL AUCTION DISCOUNT/WEEK OF PURCHASE 0.110% 0 .270% 0.270% 0.340% 0.300% YI ELD TO MATURITY 0.600% 0 375% 0.785% 0.811% 0.885% A CCOU NT ALLOCATI ON OF INVESTM ENT 001-1172 GENERAL FUND OPERATING 513.360.00 999.800.00 002-1166 UTILITY DEBT SERVICE RESERVE 002-1172 UTILI TY FUND OPERA TING 1.004,385.00 280,000.00 20,000.00 198,690.95 002-1178 CUSTOMER DEPOSITS 165,687.76 002-1186 UTILITY LINE RE NEWAL 002-1557 THE RESERVE LI FT STATION 003-1180 BEDFORD BRIDGE ESCROW 003-1188 TOWN CENTER/HWY26 003-1192 MCDONWELL WOODS EST ESCROW 003-1200 LONGWOOD-PARKING ESCROW 003-1204 BEDFORD LAKES/SOMERSET 003-1231 LAKEWOOD ESCROW 003-1236 E . GLADE CRANBROOK ESCROW 003-1247 GLADE/WAYSIDE ESCROW 003-1250 REATTA PLACE 003 -1 301 LAKEWOOD PH IV 77,530.57 003 -1304 VILLAS DEL MAR 003-1 307 STREET RECONSTRUCTION 003-1309 COVENANT CHRISTIAN 003-13 19 REMINGTON PARK 27,855.96 003-1323 SHALIMAR 003-1325 PECAN GARDENS 003-1330 REMINGTON PARK 003-1340 CASTLETON MANOR 81,309 57 003-135 7 CITGO/LO LOCKETT 003-1392 CLAIRMONT-PH I 003-1404 TANGLEWOOD 003-1418 CLAIRMONT-PH II 147,050 32 003 -1 429 WARWICK PARC 003-1434 ROCKRIMMON 003-1486 CHANEL'S COURT 47 ,895.39 003-1563 V ILLAS OF COLLEYVILLE 52,979.4 8 005-1 172 VOLUNTARY PARK FUND 200,000.00 011-11 72 LIBRARY DONATIONS FUND 0 12-1172 PARK LAND DEDICATION FUND 300,000.00 200,000.00 0 17-1172 DRAINAGE FUND OPERATING 150,000.00 024 -1172 CEDC OPERA TING 026-1 172 TIF OPERATING 032-151 9 CAPITAL EQUIPMENT RESERVE 85,700.00 364,300.00 034-1172 COLLEYVILLE TOMORROW PER GENERAL LEDGER $1 ,004,385.00 $1 ,015,700.00 $897,660.00 $999 ,000.00 $999,800.00 MARKET VA LUE $997, 162.00 $1 ,009,373.00 $893 .386.80 $993, 135.00 $995,870.00 VALUE AT MATURITY $1 ,000,000.00 $1 ,000,000.00 $900,000.00 $1 ,000,000.00 s 1,000,000.00 INTEREST RECEIVED TO MATURITY $10,602.95 $3,948.73 $13 ,726.27 $16,107 24 $17,293 .88 OUTSTANDING INVESTMENTS AT 12·31-15 INVESTMENT FHLB NOTE DATE ACQUIRED 29-Dec-15 MATURITY DATE 29-Dec-17 26 WEEK T-BILL AUCTION DISCOUNT/WEEK OF PURCHASE 0.490% YIELD TO MAT URITY 1010% ACCOUNT ALLOCA TION OF INVESTM ENT 001-1172 GENERAL FUND OPERATING 349,078 61 002-1166 UTILITY DEBT SERVICE RESERVE 643 699 78 002-1172 UTILITY FUND OPERA TI NG 175,106 74 002-1178 CUSTOMER DEPOSITS 32,114 87 002-1186 UTILITY LI NE RENEWAL 002-1557 THE RESERVE LIFT ST A TION 003-1 180 BEDFORD BRIDGE ESCROW 003-1188 TOWN CENTER/HWY26 003-1192 MCDONWELL WOODS EST ESCROW 003-1200 LONGWOOD-PARKING ESCROW 003-1204 BEDFORD LAKES/SOMERSET 003-1231 LAKEWOOD ESCROW 003-1236 E GLADE CRANBROOK ESCROW 003-1247 GLADE/WAYSIDE ESCROW 003-1250 REATIA PLACE 003-1301 LAKEWOOD PH IV 003-1304 V ILLAS DEL MAR 003-1307 STREET RECONSTRUCTI ON 003-1309 COVENANT CHRISTIAN 003-1319 REMINGTON PARK 003-1323 SHALIMAR 003-1325 PECAN GARDENS 003-1330 REMINGTON PARK 003-1340 CASTLETON MANOR 003-1357 CITGO/LO LOCKED 003-1392 CLAIRMONT-PH I 003-1404 TANGLEW OOD 003-1418 CLAIRMONT-PH II 003-1429 WARWICK PARC 003-1434 ROCKRIMMON 003-1 486 CHANEL'S COURT 003-1563 VILLAS OF COLLEYVILLE 005-1172 VOLUNTARY PARK FUND 01 1-1 172 LIBRARY DONATIONS FUND 012 -1172 PARK LANO DEDICATI ON FUND 0 17-1 172 DRAINAGE FUND OPERATING 024-1172 CEOC OPERATING 026-1 172 TIF OPERATING 032-1519 CAPITAL EQUIPMENT RESERVE 034-1172 COLLEYVILLE TOMORROW PER GENERAL LEDGER $1 ,200,000 00 MARKET VALUE $1 ,198,252 80 VALUE AT MATURITY $1,200,000 00 IN TE REST RECEIVED TO MATURITY $24 ,273 21 CDARS CERTIFICATE OF DEPOSIT ALLOCATION II CDARS CERTIFICATES OF DEPOSIT II INTEREST EARNED FUND PURCHASE MATURITY INTEREST DURING ALLOCATION AMOUNT DATE DATE RATE QUARTER UTILITY FUND $508 ,338 .65 7/30/2015 7/27/2017 0.40% $501 .38 GENERAL FUND $505 ,871 .92 6/26/2014 6/23/2016 0.50% $623.68 GENERAL FUND $506 ,7 68.95 3/26/2015 3/24/2016 0.30% $374.87 GENERAL FUND $1 ,518,932.34 9/24/2015 9/22/2016 0.40% $1 ,495.20 GENERAL FUND $504 ,998.83 9/25/2014 9/22/2016 0.50% $622 .60 GENERAL FUND $504 ,752 .03 9/24/2015 9/21/2017 0.40% $497.84 GENERAL FUND $500 ,000.00 3/27/2014 3/24/2016 0 .50% $616.44 TOTAL $4 ,549 ,662.72 $4 ,732.00 LOGIC INVESTMENT POOL ALLOCATION AND GENERAL INFORMATION L OC A L GOVER NMENT INVESTM ENT COOPERATIVE I "LOGIC" ACCOUNT ALLOCATION AT DEC EM BER 31 , 2015 ACCT# DESCRIPTION BALANCE GENERAL FUND 001-1115 GENERAL OPERATING $1 ,014,916 62 UTILITY FUND 002-1115 UTILITY OPNS $886,581 .35 002-1116 IMPACT FEES WATER $1 ,24711047 002-1119 UTILITY LINE RESTORATION s 1,3 64,8 44.63 002-11 30 UTILITY INTEREST & SINKING FUND $533,905 78 002-1294 IMPACT FEES SEWER $365.792 45 CAPITAL PROJECTS FUND 003-1 11 3 IMPACT FEES/SA I $21 220 21 OOJ.1508 MICRO-RESURFAC ING $304.781 61 003-1509 STREET RESURFACING $13,771 .84 DEBT SERVICE FUND 004-1115 DEBT SERVICE OPERATING $829,141 09 DRAINAGE FUND 017-1115 DRAINAGE OPERATING $697,987 70 017-1159 DRAINAGE INT & SINKING FUND $241 ,292 73 017-1380 2001 DRAINAGE BONDS $2,328 90 TIFFUND 026-1115 TIF OPERATING $11 ,575.713 54 026-1383 2001 TIF BONDS $123.426 84 CCCPDFUND 027-1 115 CCCPD OPERA TING $914 ,443 96 027-1147 99 POLICE/COURT BLDG FUND $80 90 SALES TAX INCENTIVE AGREEMENT FUND 031-1115 SALES TAX INCENTIVE AGREEMENT OPERATING $354 ,642 39 CAPITAL EQUIPMEN T REPl.ACEMENT FUND 032-1 115 CAPITAL EQU IP MENT REPLACEMENT FUND S81 ,964 26 COLLEYVILLE TOMORROW FUND 034-1115 COLLEYVILLE TOMORROW FUND $1 ,646,083. 15 PARKS TOMORROW FUND 035-1115 PARKS TOMORROW FUND $1 ,196 ,857 59 STRATEGIC INITIATIVES FUND 036-111 5 STRATEGIC INITIATIVES FUND $296,371 17 TOTAL LOGIC POOL BALANCE $23 ,7 13,259 16 Ne w s Pe r f o r m a n c e New Participants We would like to welcome the following entity who joined the LOGIC program in December: City of Leonard Holiday Reminder In observance of Martin Luther King Jr. holiday, LOGIC will be closed Monday, January 18, 2016. All ACH transactions initiated on Friday, January 15th will settle on Tuesday, January 19th. In observance of Presidents’ Day, LOGIC will be closed Monday, February 15, 2016. All ACH transactions initi- ated on Friday, February 12th will settle on Tuesday, February 16th. LOGIC Newsletter December 2015 Ch a n g e o f A d d r e s s E c o n o m i c C o m m e n t a r y Markets entered the fourth quarter uncertain about the next move by the Federal Reserve. However as the fourth quarter got under way, U.S. labor markets showed strength, inﬂ ation stabilized and appeared to resurface in wages, and financial conditions improved, doubts began to fade as the Fed set the stage for a hike in rates at its December 16th meeting. U.S. Treasury yields moved higher as the meeting approached, leading to a muted reaction in the bond market during and after the announcement. The growing divergence between the manufacturing and service sectors remains unsustainable. The industrial side of the U.S., while small will need to stabilize in order for the economy to experience growth at or above 2.5% in 2016. The domestic service economy should remain the source of stability in the year ahead. The pace of job gains is likely to slow in 2016 as labor market slack erodes, but this should be supplemented by stronger wage gains and accelerating total income. Against the backdrop of solid income growth, elevated savings, high conﬁ dence, improved access to credit and lower energy prices, the consumer is expected to increase spending in 2016. The outlook for global growth remains a concern, particularly for China. China’s expected currency devaluation will exert downward pressure on U.S. net trade. The U.S. economy is not growing at a pace that can withstand a more pronounced global slowdown. After raising rates in December for the ﬁ rst time since 2006, the Fed is expected to follow a gradual pace of tightening in 2016. The Fed is forecasted to raise rates three times in 2016. Only a large miss on the economic data front or some signiﬁ cant unforeseen event will likely deter the Fed from achieving its goal. This information is an excerpt from an economic report dated December 2015 provided to LOGIC by JPMorgan Asset Management, Inc., the investment manager of the LOGIC pool. *Definition of Weighted Average Maturity (1) & (2) (1) This weighted average maturity calculation uses the SEC Rule 2a-7 deﬁ nition for stated maturity for any ﬂ oating rate instrument held in the portfolio to determine the weighted average maturity for the pool. This Rule speciﬁ es that a variable rate instrument to be paid in 397 calendar days or less shall be deemed to have a maturity equal to the period remaining until the next readjustment of the interest rate. (2) This weighted average maturity calculation uses the ﬁ nal maturity of any ﬂ oating rate instruments held in the portfolio to calculate the weighted average maturity for the pool. Rates reﬂ ect historical information and are not an indication of future performance. As of December 31, 2015 Current Invested Balance $3,937,397,581.06 Weighted Average Maturity (1)* 29 Days Weighted Average Maturity (2)* 39 Days Net Asset Value 0.999960 Total Number of Participants 486 Management Fee on Invested Balance 0.0875% Interest Distributed $1,012,017.03 Management Fee Collected $275,325.37 % of Portfolio Invested Beyond 1 Year 1.52% Standard & Poor’s Current Rating AAAm December Averages: Average Invested Balance $3,705,044,375.58 Average Monthly Yield, on a simple basis 0.2331% Average Weighted Average Maturity (1)* 37 Days Average Weighted Average Maturity (2)* 48 Days LOGIC Participant Services will be moving effective January 22, 2016. After this date, please use our new address listed below when sending any correspondence to LOGIC. In addition, please provide this new address to your auditors for any audit conﬁ rmations they may send to LOGIC regarding your account. There will be no changes to our phone numbers, fax number or website address. New Address: LOGIC Participant Services 1201 Elm Street, Suite 3500 Dallas, Texas 75270 Distribution of Participants by Type As of December 31, 2011 Portfolio by Maturity As of December 31, 2011 In f o r m a t i o n a t a G l a n c e Hi s t o r y Historical Program Information Average Book Market Net Number of Month Rate Value Value Asset Value WAM (1)* WAM (2)* Participants Dec 15 0.2331% $3,937,397,581.06 $3,937,328,740.05 0.999960 37 48 486 Nov 15 0.1637% 3,408,876,009.37 3,408,877,369.21 1.000000 41 55 485 Oct 15 0.1635% 3,299,010,020.32 3,299,149,338.22 1.000037 45 60 483 Sep 15 0.1354% 3,298,434,843.78 3,298,608,218.16 1.000052 37 48 482 Aug 15 0.1354% 3,481,714,713.30 3,481,787,250.61 1.000020 41 43 482 Jul 15 0.1265% 3,695,302,543.37 3,695,464,092.30 1.000035 45 47 482 Jun 15 0.1249% 3,654,155,351.53 3,654,410,680.14 1.000069 50 52 479 May 15 0.1122% 3,946,893,410.17 3,947,118,664.62 1.000057 50 53 477 Apr 15 0.1130% 3,998,470,171.80 3,998,712,647.13 1.000060 53 56 477 Mar 15 0.0999% 4,066,005,418.39 4,066,212,104.05 1.000050 54 54 476 Feb 15 0.0921% 4,259,905,573.48 4,260,112,636.65 1.000044 56 56 475 Jan 15 0.0843% 4,685,467,403.35 4,685,649,495.36 1.000035 53 53 474 As s e t s Book Value Market Value Uninvested Balance $ 19.61 $ 19.61 Accrual of Interest Income 601,899.12 601,899.12 Interest and Management Fees Payable (1,001,525.81) (1,001,525.81) Payable for Investment Purchased 0.00 0.00 Receivable for Investment Sold 0.00 0.00 Repurchase Agreements 536,918,999.94 536,918,999.94 Commercial Paper 2,835,720,779.24 2,835,749,531.19 Government Securities 565,157,408.96 565,059,816.00 Total $ 3,937,397,581.06 $ 3,937,328,740.05 Market value of collateral supporting the Repurchase Agreements is at least 102% of the Book Value. The portfolio is managed by J.P. Morgan Chase & Co. and the assets are safekept in a separate custodial account at the Federal Reserve Bank in the name of LOGIC. The only source of payment to the Participants are the assets of LOGIC. There is no secondary source of payment for the pool such as insurance or guarantee. Should you require a copy of the portfolio, please contact LOGIC Participant Services. Portfolio Asset Summary as of December 31, 2015 Commercial Paper 72.01% Repurchase Agreements 13.64% 8 to 30 days 29.46% 1 to 7 days 27.93% 181+ days 0.26% 31 to 90 days 40.44%Utility District 9.88% Other 6.79% School District 38.89%Health Care 1.65% County 10.49% Higher Education 2.88% City 29.42% Distribution of Participants by Type As of December 31, 2015 Portfolio by Type of Investment As of December 31, 2015 Portfolio by Maturity As of December 31, 2015 91 to 180 days 1.91% Agencies 11.75% Treasuries 2.60% Mny Mkt Fund Daily Allocation LOGIC Invested Market Value WAM WAM Date Equiv. [SEC Std.] Factor Balance Per Share Days (1)* Days (2)* 12/1/2015 0.1718% 0.000004708 $3,406,636,651.58 0.999998 39 51 12/2/2015 0.1847% 0.000005061 $3,416,342,863.97 0.999987 44 56 12/3/2015 0.1849% 0.000005066 $3,415,192,934.60 0.999979 43 56 12/4/2015 0.1852% 0.000005075 $3,404,107,647.74 0.999953 41 53 12/5/2015 0.1852% 0.000005075 $3,404,107,647.74 0.999953 41 53 12/6/2015 0.1852% 0.000005075 $3,404,107,647.74 0.999953 41 53 12/7/2015 0.1903% 0.000005214 $3,409,886,807.67 0.999951 40 53 12/8/2015 0.1863% 0.000005105 $3,672,155,105.39 0.999935 40 51 12/9/2015 0.2022% 0.000005541 $3,665,772,756.48 0.999935 41 52 12/10/2015 0.1906% 0.000005223 $3,901,714,130.63 0.999933 39 49 12/11/2015 0.1866% 0.000005113 $3,885,450,372.53 0.999903 37 47 12/12/2015 0.1866% 0.000005113 $3,885,450,372.53 0.999903 37 47 12/13/2015 0.1866% 0.000005113 $3,885,450,372.53 0.999903 37 47 12/14/2015 0.1885% 0.000005165 $3,883,715,657.56 0.999915 36 47 12/15/2015 0.2070% 0.000005672 $3,816,073,669.83 0.999929 37 47 12/16/2015 0.2152% 0.000005897 $3,808,811,833.52 0.999928 36 47 12/17/2015 0.2499% 0.000006846 $3,753,359,782.86 0.999920 36 47 12/18/2015 0.2464% 0.000006752 $3,739,304,053.69 0.999888 34 45 12/19/2015 0.2464% 0.000006752 $3,739,304,053.69 0.999888 34 45 12/20/2015 0.2464% 0.000006752 $3,739,304,053.69 0.999888 34 45 12/21/2015 0.2619% 0.000007176 $3,747,565,512.79 0.999915 36 46 12/22/2015 0.2740% 0.000007507 $3,805,099,750.85 0.999945 37 47 12/23/2015 0.2892% 0.000007923 $3,789,518,595.90 0.999952 38 47 12/24/2015 0.2920% 0.000008001 $3,788,611,123.17 0.999930 35 45 12/25/2015 0.2920% 0.000008001 $3,788,611,123.17 0.999930 35 45 12/26/2015 0.2920% 0.000008001 $3,788,611,123.17 0.999930 35 45 12/27/2015 0.2920% 0.000008001 $3,788,611,123.17 0.999930 35 45 12/28/2015 0.3045% 0.000008343 $3,671,912,650.40 0.999963 36 47 12/29/2015 0.3025% 0.000008288 $3,673,903,408.78 0.999973 35 46 12/30/2015 0.3000% 0.000008220 $3,840,285,234.70 0.999981 33 43 12/31/2015 0.3006% 0.000008236 $3,937,397,581.06 0.999960 29 39 Average 0.2331% 0.000006388 $3,705,044,375.58 37 48 Da i l y R a t e s Daily Summary for December 2015 LOGIC versus 90-Day Treasury Bill This material is for information purposes only. This information does not represent an offer to buy or sell a security. The above rate information is obtained from sources that are believed to be reliable; however, its accuracy or completeness may be subject to change. The LOGIC management fee may be waived in full or in part at the discretion of the LOGIC co-administrators and the LOGIC rate for the period shown reﬂ ects waiver of fees. This table represents historical investment performance/return to the customer, net of fees, and is not an indication of future performance. An investment in the security is not insured or guaranteed by the Federal Deposit Insurance Corporation or any other government agency. Although the issuer seeks to preserve the value of an investment at $1.00 per share, it is possible to lose money by investing in the security. Information about these and other program details are in the fund’s Information Statement which should be read carefully before investing. The yield on the 90-Day Treasury Bill (“T-Bill Yield”) is shown for comparative purposes only. When comparing the investment returns of the LOGIC pool to the T-Bill Yield, you should know that the LOGIC pool consist of allocations of speciﬁ c diversiﬁ ed securities as detailed in the respective Information Statements. The T-Bill Yield is taken from Bloomberg Finance L.P. and represents the daily closing yield on the then current 90-day T-Bill. Da i l y R a t e s Da i l y S u m m a r y -0.02 0.01 0.04 0.07 0.10 0.13 0.16 0.19 0.22 0.25 0.28 0.31 90 Day T-BILL Rate LOGIC Rate Co n t a c t s For more information contact LOGIC Participant Services  1-800-895-6442  www.logic.org LO G I C B o a r d LOGIC Board Members Philip G. Roberson Arlington ISD Board President Fred L. Werner Municipal Finance Director Board Vice President Judd R. Sanderson North Texas Municipal Water District Board Treasurer / Investment Ofﬁ cer Sandra Newby Tarrant Regional Water District Board Member Greg Jordan City of Grapevine Board Member L O G I C P a r t i c i p a n t S e r v i c e s c / o F i r s t S o u t h w e s t C o m p a n y , L L C 3 2 5 N o r t h S t . P a u l S t r e e t , S u i t e 8 0 0 D a l l a s , T X 7 5 2 0 1