Loading...
HomeMy WebLinkAboutInvestment Report and Transaction Reporting for April 30, 2017 Menchaca, Clarissa From Lam, Lisa Sent: Monday May 15, 2O178:O1 AM To: Liu, Annie; Snyder, Ashley; Gullickson, CarVK|; Christy Patterson, Butte County Schools JPA;Worsham, Colette; Houser, David; Heather Naylor, Gridley UmifiedSchool District; Cook, Holly; Kevin BuUtema, Chico Unified School District; Honea, Kory; Lisa Anderson, TOC 84ember(8COE rep); Lam' Lisa; Sandoval, Maritza; Mark Milburn, TOC Member; ]essee, Meegam| Menchaco, Clarissa; Mia Osborne-Ng, Executive Assistant to the Butte County Superintendent ofSchools; Ramsey, Mike; Moak, Peggy; Bennett, Robin; Hubbard, Sheryl; Connelly, Bill; Kirk, Maumeen,; Lambert, Steve;Teeter, Doug; Wahl, Larry; Peterson, Susan; Susan Watts, TOC Member (OUHSDrep);Tim Taylor, Butte County Superintendent of Schools;VVi|Uann (Jim) Nicholas, Director of Business Services Subject: Investment Report and Transaction Reporting for April 3O, 2O17 Attachments: Investment Report April 30, 2017.pdf,, Transaction Reporting April 30, 2017.pdf Greetings! The Treasurer's Investment Report for the month ending April 3O, 2817is attached, for your reference. Additionally,the information provided in the attached "Transaction Reporting April 30, 2017" consists of spreadsheets and statements detailing transaction activity for the month. |fyou have any questions Vrconcerns, please,feel free to contact me, orPeggy Moak at538'7443. Best regards, [4w L am Assistant Treasurer-Tax Collector, Treasury Division Butte County Treasurer-Tax Collector 25 County Center Drive, Suite 125, Orovil�le, CA 95965 T: 5K538.7539 1 F 530.5383648 Treasurer-Tax Collector Peggy Moak, Treasurer-Tax Collector Treasury Division utte County 25 County Center Drive, Suite 125 T: 530.538.7576 buttecounty.net/ttc Oroville, California 95965-3384 ( F: 530.538.7648 TREASURER-TAX COLLECTOR May 15, 2017 Butte County Board of Supervisors Butte County Chief Administrative Officer Investment Pool Oversight Committee The attached investment report for April 30, 2017 is submitted in accordance with the Butte County Statement of Investment Policy dated July 1, 2016. All investments are in compliance with this policy. The Investment Report demonstrates that sufficient liquidity is available to meet anticipated expenditures during the next six months. The Local Agency Investment Fund (LAIF) is used as a comparison against Butte's portfolio performance. A look at the 5-year moving average for the Butte County Treasury apportioned yields vs. LAIF apportioned yields demonstrates that, over time, a medium term, laddered portfolio will generally outperform a shorter-term investment strategy, which LAW usually mirrors. The 5-year moving average for Butte County's FY 14/15 and FY 15116 performance compared to LAIF shows margins of 1.092% and 0.865%, respectively. Using $350,000,000 as a baseline portfolio (actively invested balance), this translates to enhanced earnings averaging $3,027,500 per year for the past five years. NOTE: Fair values are trending lower than cost carried due to an increasing yield environment. Investments are marked to market monthly based on a current market price determined by U.S. Bancorp Investments. Copies of statements reflecting investment and cash management transactions are provided to the Board of Supervisors monthly and are available upon request. Quarterly Investment Reports are made available on the Treasurer-Tax Collector website at http://www.buftecoun!y.net/ftc. Respectfully, -i Peggy Moak Butte County Treasurer-Tax Collector cc: Butte County Auditor-Controller Butte-Glenn Community College Butte County Board of Supervisors Chico Unified and Gridley Unified School Districts Butte County District Attorney Jessee, Meegan--Butte County Deputy Administrative Officer Butte County Schools-JPA Liu,Annie—Butte County Manager,Gov't.Accounting Butte County Sheriff Butte County Superintendent of Schools Butte County Special Districts(Quarterly) iii R9 r. UuE � �„� BUTTE COUNTY TREASURER'S INVESTMENT REPORT April 30,2017 YIELD TO WEIGHTED AVERAGE ACTIVELY MANAGED PORTFOLIO: MATURITY MATURITY(DAYS)' PAR VALUE FAIR VALUE COST CARRIED LOCAL AGENCY INVESTMENT FUND(LAIF) 0.884% 1 100„132,123.05 100„132,123.05 100,132,123.05 CALTRUST SHORT TERM 1,038% 1 4,577.18 4„577.18 4,573.22 CAMP SHORT TERM 0,960% 1 40„136,317.16 40,136,.397.16 40,136,317.16 BANK MONEY MARKET(COLLATERALIZED) 0.810% 1 1„003,340,21 1,003,340.21 1,003„340.21 U.S.TREASURY NOTES” 1.407% 1,091' 9,000,000.00 8;991,483.00 9,006,036.56 MUNICIPAL BOND$- 1.777% 1,157 38,760,000,00 38,727,262.10 38,931,643.48 CORPORATE NOTES” 1.560% 781 52,527,000'.00 52,772„428.53 52,934,927.99 NEGOTIABLE CDS— 1.775% 1,208 6,750,000.00 6,753,745.86 6,747„205.24 FEDERAL AGENCY NOTES— 1.354% 913 202,465,000.00 201,635,840.98 202,256„329.56 TOTAL ACTIVELY MANAGED'PORTFOLIO: 1.282% 641 450,778,357.60 450,157,118.07 451,152.,496.47 INVESTMENT OF NOTEIBOND PROCEEDS AND OPERATING CASH SCHOOL BOND PROCEEDS rice pane 2 t©,dctai¢s} $7,630,948,23 $7„830,948.23 87,630„946.23 OPERATING ACCOUNTS U.S.BANK CHECKING ACCOUNT DEPOSITS 24,020,872,.06 24,020,872.06 24,020,672.06 OPERATING CASH 36,428.53 36,428.53 36,428.53 OTHER 0,00 0,00 0.00 TOTAL TREASURER'S FUND LEDGER BALANCE: 562,466,606,42 561,845,366.89 562„840,745.29 INVESTMENTS UNDER MANAGEMENT OF TRUSTEES n.uc u dv do.d.; 2,229,655.46 2,229,655.46 2,221,433.58 PAR VALUE FAIR VALUE COST CARRIED TOTAL CASH AND INVESTMENTS: 564,696,261.88 564,075,022.35 565,062,178.87 SIX MONTH LIQUIDITY PROJECTIONS Estimated Cash Receipts for Next Six Months 412,809,065 Estimated Disbursements for Next Six Months -500,043,500 Estimated Net Cash Flow for Next Six Months— -87,234,435(Al) Prudent Reserve -30,000,000(A2) Securities Maturing 15,;500,000(B) Local Agency Investment Fund/Cal Trust I MMF/CAMP 141,276,354(C) Total Liquidity for Next Sax Months 39,541,919(A1+A2+8+C) Estimated Cash Available for Long Term Investment -30,000,000 Remaining Available Liquidity 9,541,919 Total Par Value of actively managed investments maturing in less than 12 months; 211,541,358 Total Par Value of actively managed Investments maturing In more than 12 months: 239,237,000 Actual Weighted Average Maturity will be shorter,and actual dollar amount of investments maturing in less than 12 months wll be higher than skater!,due to call features on investments. Seepage 5 for detailed list of investments. ” Includes TRAN(Tax and Revenue Anticipation Notes)receipts and disbursements,if applicable. 1 BUTTE COUNTY TREASURER'S INVESTMENT REPORT INVESTMENT OF SCHOOL BOND PROCEEDS April 30,2017 INVESTMENT MATURITY ANNUAL PAR FAIR COST BOND/NOTE DESCRIPTION TYPE DATE DESCRIPTION YIELD` VALUE VALUE CARRIED BONDS-LOCAL AGENCY INVESTMENT FUND(LAIF) Butte-Glenn CCD 2016 GO Bond Series A LAW 0.884% 41,815,000.00 41,815,000.00 41,815,000.00 Chico Unified 2012 GO Bond Measure E Series A LAIF 0.884% 965,948.23 965,948.23 965,946.23 Chico Unified 2016 GO Bond Series A LAIF 0,884% 44,850,000.00 44,850,000.90 44,850,000.00 PAR FAIR COST VALUE VALUE CARRIED GRAND TOTAL 87,630,948.23 87,630,948.23 87,630,948.23 Yields quoted above are a snapshot per Investment type,Actual yields earned on school bands are calculated by the Treasurers office and are a composite of Investment earnings less Treasury costs. 2 BUTTE COUNTY TREASURER'S INVESTMENT REPORT DEPOSITS AND INVESTMENTS UNDER MANAGEMENT OF TRUSTEES/FISCAL AGENTS April 30, 2017 INVESTMENT MATURITY ANNUAL PAR FAIR COST FINANCING PROGRAM TYPE DATE DESCRIPTION YIELD VALUE VALUE CARRIED 2004 PENSION OBLIGATION BONDS WELLS FARGO BANK,TRUSTEE Series A Band Fund#XXXX1106 Money Market HERITAGE MM#3106 0.603% 1,118,412.66 1,118,412.66 1,118,412.66 Int.Rate Stabilization Fund#XXXX1109 Money Market HERITAGE MM#3106 0.603% 1,009.91 1,009,91 1,009.91 Pooled Agency Funds Local Agency Investment Fund 0.884% 1,648.11 1,648.11 1,648.11 Principal Account Fund#XXXX1140 Cash Cash 0.000% 11.54 11.54 11.54 Interest Account Fund#XXXX1141 Cash Cash 0.000% 5.62 5.62 5.62 Surplus Account Fund 4XXXX1142 Cash Cash 0.000% 624.34 624.34 624.34 Series a Interest Fund#XXXX1301 Money Market HERITAGE MM#3106 0.603% 20,792.44 20,792.44 20,792.44 Series B Bond Fund#XXXX1305 Money Market HERITAGE MM#3106 0.603% 845,332.95 845,332.95 845,332.95 Series B Interest Fund#XXXX1307 Money Market HERITAGE MM#3106 0.603% 19.02 19.02 19.02 SUBTOTAL 1,987,856.59 1,987,856.59 1,987,856.59 DEPOSITS WITH FISCAL AGENTS Discovery Benefits Plan Year Cash Balance 1/01116-12131116' NA 38,221.88 38,221.88 "30,000.00 York Risk Services Group-Claim Administrators Umpqua Bank#XXXXX2601 Commercial Bank Business Checking NA 203,576.99 203,576.99 203,576.99 SUBTOTAL 241,798.87 241,798.87 233,576.99 PAR FAIR COST VALUE VALUE CARRIED GRAND TOTAL 2,229,655.46 2,229,655.46 2,221,433.58 Represents the most current data available(source:Auditor-Controller) "Benefits can be paid in advance of receipt of offsetting payroll deductions 3 BUTTE COUNTY TREASURER'S INVESTMENT REPORT ACTIVELY MANAGED PORTFOLIO"AT-A-GLANCE" April 30,2017 INVESTMENTS BY TYPE* INVESTMENTS BY MATURITY&YIELD* Local Agency Investment FuncVCsiTtusVMMF1CAMP LAIFICT/MMFICAMP $ 141,276,358 Federal Home Loan Bank FHLB $ 48,700,000 LAIF/CALTRUSTIMMF/CAMP(1 day) 0.884% $ 141,276,358 Federal Home Loan Mortgage Corp FHLMC $ 13,000,000 01-12 months 0.998% $ 70,265,000 Federal National Mortgage Assn FNMA $ 30,000,000 13-36 months 1.629% $ 98,022,000 Federal Farm Credit Bank FFCB $ 38,000,000 37-60 months 1.678% $ 141,215,000 Federal Agricultural Mortgage Corp FAMCA $ 29,265,000 TOTAL PAR VALUE $ 450,778,358 Corporate Nates CORP $ 52,527,000 U.S.Treasury Notes UST $ 9,000,000 'Investments managed by Trustees&School Bond Proceeds not included. Supranational SUPRA $ 43,500,000 Final maturity dates are used;probable call dales are not considered. Certificates of Deposit(CollateralizedlNegotiable) COS $ 6,750,000 Amounts quoted at Par Value. Municipal Bonds MUNI $ 38,760,000 $ 450,778,358 9% 196 30% 2% tt •LAIF/CALTRUST/MMF/CAMP(1 day( •LAiF/CT/MMF/CAMP•FHLB •FHLMC •FNMA .01.12 months FFCB FAMCA •CORP •UST 13.36 months •SUPRA "Cos •MUNI •37-60 months Butte County Pooled Treasury Portfolio Balance" Net of Tax and Revenue Anticipation Notes(TRAM) and Bond Proceeds $500,000,oD0 $475,000,000zot2 $450,000,000 �e�2ols $425,000,000 —.�sota $400,D00,000 , 2013 ..�•.zotz $375,000,000 —2011 $350,000,000 2010 ��2009 $325,000,000 ••o�zo0s $300,000,000 $275,000,000 $250,000,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC This chart does not Include deposits from TRAN,Bond Proceeds,or Investments under Management of Trustees. It is Intended to demonstrate cash flow trends and establish a basellne for the portfolio,enabling medium term investments. 4 BUTTE COUNTY TREASURER'S INVESTMENT REPORT MANAGED PORTFOLIO-DETAILS OF SECURITIES HELD April 30,2017 Clb0 RUTIN Pvnr .. MMV46Y Tim,. •$51082 p..crldbn ME 121 FIS. Cllr 992 M.wluxLll P.V41,w EdLYtB1t Ce.1Ga.feT aMWTBH7 TOYOTAMOTOR CREDIT CORP M. A43 A Y12A55 2168017 1000 4,6W,VOO.W 4,50,10.00 4,5W131.W -swwRF3 INTL BK RECON a DEVELOP AAA A4a MR 2167015 7111201T 0699 3.00066x00 1,98624400 3.60.069.41 31MMTKO FEDERAL NOME LOAN BANK M. A.a NR 1213112014 62211011 1.070 SW6 w 5002.410.00 4.999.612.= 3,MFEOK+ FEBEAALFARMCAEOITM5 M. Au AM 2852015 6258017 1.000 3,0)0,X003 ].0)0.246.0) 3,w0000.m 313]61020 FEDERALROMELOAN BANK M. A.. NR IVI98012 12162011 0.657 S.XOWO.w 4,990.6W.W A,9B6.646.26 31MSCRZ FEDERAL FARM CREOIT OANK M. Au AM 12221012 122&]017 0910 10,000,00000 10,000,01000 9,999,347.27 31311IFT86 FARMER MAC MR MR MR VI 1=1a IMTM17 0.969 4,765,690.69 x,283,259.60 4,284,015.48 313/E.0N6 FHLMC.7501116 M. AAA MA 11141]01] 11122016 692 5,690,69069 4,X7,335.69 4,894.220.56 3+65CWE1 FEDERAL NATL MORTGAGE ASSN M. A44 AAA 233472013 1.2016 +.WO 10000000 0M."w 10==oo 48124JS27 JP MORGAN G HAS E BAN K NA HR MR NR 72&2013 212&0016 1.125 250,0009D 249.7%.69 2W.w0.w 3+31SPONA FMMFR MAG MR NR MR 172013 3WO,A 0940 1.000,OOOw 9,990,6]00) 0399,965x5 31315P FARMER MAG HR MR NR 9121013 382018 0.976 SWOXOw 4.966.69.69 4.991.410.10 64952WO0 NEW YORK LIFE GLOBAL FOG M. AMI AAA 4272015 42T8Ot6 IIX 5M0 w 4,969,66069 5X3,393.19 91X6LONG ALLY BANK HR MR NR 4!62615 4602016 LAW 200Ww 260.51750 260.X950 3INECHYD FEDERALFARM CREDIT BANK M. Au MA 262013 98265a 0.968 5,69006969 4,991,54600 4.896.215.87 31N4 Swa FEDERAL HOME LOAN WO COMP M. AA+ AM 62&2013 22&2016 1.000 5,000.00069 4.M.7-000 5,000,000.00 17275RAU6 CISCO SYSTEMS INC - Al MR 1111212015 &158016 1.365 6WO,wOw 5011ADOO) 5.015101.73 a93367CP0 TOYOTA MOTOR CREDIT CORP M. w A S'162015 7/138016 1.Am 5,0)=w 5,0)!0160) 4,99106].25 W117J3E0 GOLDMAN SACHS BANK USA NR HR MR &17M14 62112016 1.650 20.690.00 251.28280 250.690.69 07567CAY8 AMER CAM EAPR FSS SK FAB NR NR NR &468014 &4&4016 100) 2.000)00 251,2nw M.,xoX 459W6ER0 i HTL BK RECO N 60 EVELOP AAA Aa. AAA 1X21018 1632016 1.261 2,600W0w 2.46601500 2,x80,62977 7PII450RM9 SMLIE MAE OWN K,OALT LKE NRNR HR 1125"101] 118&X16 2.069 2910Xw 252,999,50 250,00000 866+64WJ7 ORIENTAL BANK xft x12 x12 17/1&2015 'V1740+6 1760 2SODIOW 25680050 M.ixow W230TB150 TOYOTA MOTOR C REDIT COR P M. A4] A 0`162015 11172019 1,075 S,OD00mm 5.040.595.69 5,016.540.19 OW120502 APALF INC M. N1 NR +.17M,7 2292019 1150 1549,0)60) 1,347,71676 1516625.24 691635KW N EW YORK BT UR BN DEV CORP REV AM k1 M. 12/162014 3'152018 1.969 5,690000.00 S.W7.w OO 50X.669.71 I] KU CALIFORNNSTODUNLTDTAOL M. W.] M. 1184X14 912019 1900 ],000,69000 3069,23000 3,020,691.0 31MEFMD FE O ERAL FARM C RED=BM K M. ANI AM 222'016 5232019 1.266 S,X0000.w 4.66$.51500 4,086.414.53 SMOlaAC0 MICROSOFTCORP AAA ANI M. 8282015 &112019 1.569 21500100.00 2.541.10000 2.6=.19.46 3t3379EE5 FEDERAL HOME LOAN BANK M. Ata HR &182014 &142018 1765 5,C00Aw00 5525mm 4,MI ITT 91412WM UNN OFGALIFDRNM CA REV 7%SL M A.2 M &22015 71112019 Lew 5,000.90000 5.17.06000 5.010.206.92 31315PI,T1 FEDERAL AGRIC MTO CORP NR NR MR 7,1740+4 7117=19 1613 50m.DD6m S.M.1bm 4,991,21RIA1 45X56£V1 INTL BK RECON S DEVELOP MA Au AAA 1862018 7262019 1.741 5,X000000 4.866.16600 4,064,yya0 31315PT01 FARMER MAL NR NR HR &792014 &230019 1.T63 3,000,69000 5004650w 4,961,70901 86360AM3 ORACLEC09P AW- A+ A. +0'679+5 +w62010 +.645 4'62,00000 4.21704215 4.20156857 45905UZA INTL BK RECON S DEVELOP NR AA. HR 1288016 IDG5801B 1.573 5,00,00.00 4.983,WW 4,967.00600 31MEESMa F9DFRAL FARM CREDIT SANK M. Au AAA 11,2M14 +14137016 1.669 500,00000 5,175,4150) S,000,wOm 066504AM WHITNI IUMS NR NR NR 1!152917 1812010 1.700 269.969.00 2..919.75 2W.MOD 025870KF9 AMERICAN EVR CENTURION MR NR MR +220+5 11.101626 1950 291,0X00 252,914'. 2'W.=W 66260aEMO TEM99T TECH UNN REV M. M M. 11151915 1152410 1.790 2,510.90000 2.56313560 2,601,644,25 912526.164 US TREASURY U07E M. M. AAA 468015 1]12020 1.]30 SPx%Mw 4,690,23569 5,01*,269.41 130830604 CAL.FOR MIA ST GO UMLTD TABL AM 169 42&29+5 -+2010 1,650 6069,00.00 ..M.mw SOI.Tm.63 71270OM52 PEOPLES UNITED BARK NA NR NR HR 4132015 4122[80 1,60 20.00.00 253.069.25 250.690.69 078n801 APPLE INC M. Mt MR 22120+5 582010 1.690 9,625,Dmm 9,692x15.]0 9S9I116.X 313802H" FEDERAL HATL MORTGAGE ASSN M. AA. AAA 9162915 9192020 1.869 5000.69.00 I.M.535w 5,XO.XO.X 912678.]3 USTREASURYNOTE M. M. AAA &18015 9]12020 1,50] 40W.690W 4,X1.2MW 3,889,614,59 Ia6420RN0 CAPITALCHEMANKUSANA MR NR MR &102015 61102410 2O M.000.W 152AU00 24622277 313367HU8 FEDERAL HOME LOAN BARK M. ,lf. HR &52015 &1212020 VIC 5,000.000.00 5.05705600 4995.SXIX 1'=HMA FEDEAALHOMELO-UAMK M. NR 7820+5 &1212020 III% 5,00.00600 S,m.mw 4,991 OS 3135634H1 FHLB 1.375 11620 M. As. NR 7238915 &12802 1.705 5,200.900.00 5.155.191,60 5.135.116.42 6621172%1 TEIVSATAAM UNNREV AM AMI AAA &10.00+5 7+8020 190] 3,00WO0Q 2,866,]5069 2,966713.42 459056FMO INTL BK RECON 6 DEVELOP AM AMA AAA 6232018 &102690 1.140 50W000.w 4.81+.75500 4,907,60286 OSSEOACW2 BMWBANKNORTHAMERCA MR NR NR 9`168015 &162020 220 M'mw 254,868.50 250.X669 2033AMR. COMEMITYCAP1TA BANK MR MR MR 02+1415 6212070 2-260 250,00.00 254.6600) =.0)Ww 31MIN26 FANN{EMAE M. AAM, AAA X21017 62&2010 1.8'17 5,000.000.69 5.015.MW 500].732.= 2546 73 DISCOVER BANK kR NR MR 10.412013 1218020 22W 291,0X00 25.Mn YO,OOOw 14042ASL4 CAPITALONEMA MR NR NR 1{1132015 102&210 2.277 25000000 254.M SO 249,71962 511916806 MCROSOFTCORP AM M. M. 8022016 11732020 136E 5,GW,690w 5,=,IIS00 51104,.1,32 9406816906 WELLSPMGOSANKNA MR NR MR 17138015 1X22010 1.650 2w.W0.w 152,2-60 256,00000 2828&6LW ENERBIWKUSA MR NR NR 11268016 188F1r81 1.690 20,000.00 293519.25 245.5=.69 310A7CV5 FEDERAL HOME LOAN BANK M. HR W401a 1162021 '3's S,IXO=o0 49x1.0460) 5010,988.79 31]602228 FNMASTEP-UP M. Nn AAA 22&1718 2aIm21 1.003 5,690.6900 5069.69669 5.01 45!11 055 INTER-ANERICANOEVELDK AAA A. MA I7,12.10 TISaQ21 1574 60)06900) 6,0)4,'6900 6056.012.78 mm-a7 CALIFORHIAST CO UHLTO M, Aa3 M. &1y 16 .18411 1,430 5,100.00000 4.668.06000 5013.+37.+5 3134WY79 FREDDIE SNC M. NR MA 4282018 4860021 1.328 3,690,69069 2,96900669 2.90,01.50 4500S8FB0 INTL OK RECON 6 DEVSTEP�UP MR NR NR 41820+0 4268011 1250 3,00000)m 6�9,B66w ]00)00).00 12682w2 CAtDWELL BK B TRUST CO NR NR HR 2132016 9121021 1.400 250,00Ow 24&IW.W 250.6900) 9141MFW UMNOFCALIFCRNIACAREVTK9L M A.2 AA 652010 9124021 1417 5M.=w 49.,75000 3,090,124.47 450)56FN1 INTL SK RECON 6 DEVELOP AAA Au AAA &131016 5242021 1.412 5,M.000w 4.691.295.00 4991.7X.16 31]6G]1AV4 FEDERAL HAT.MORTGAGE ASSN Me M. AAA 9321010 9]21421 1375 3,000,00000 4,IIOIL 500 5,690,69000 77113FB£0 EAST 9037011 SAVINGS BMIK MR NR HR &732016 II.1 01 1.569 25000090 N5.739.W 260.00000 31331!0 2 FEDERAL FARM CREDIT BATIK M. Aa. AAI, 78 16 7wn, l,Sw 5,00,00000 4,020,875.00 SOOO.Mco 31302095 FEDERAL HOME LOAM BANK M. Ala NR 74148018 VI4 l 1101 54000Ww 40660T5X ..91U.M 78 566933452 MECAtLION BINK UTAH NR NR NR 7882016 712&1021 1.400 251 2..669.69 269.X0.69 98a80YJN8 WESTERN STATE RANK MR NR MR 78620+8 72118021 120 YM,00w 2.,0)5.91 230,DOO.m 5141 MCROSOFTCORP MA As, M. 6+192016 17&1021 1.541 5=M.w 49W.7W.W 6X1.641.86 74257GVM6 PRNATEHA,A&TRUSTCD NR NR NR 6802018 2308021 1500 MIXXI 0 2.,381.0) 7W,XOW 055730OR8 BExEFICIALSANN MR MR MR &162918 V112991 1.669 26DOWCO 2..60650 250.0)006 67165FNG SYCHRONYUANK NR NR HR 1&]10018 12,84]1 1.70) 2%mw 211,856.25 250.00.00 31XA2F4 FE BER At MOM E LOAN BAN K M. Au MR 11832010 1+82102+ 1700 5900,0000 ..4.w5.w 5,0)0,0)0.0) 150MC21 INT L BK R ECON 60EVELOP NR NR HR 122&201!1 12887021 2.050 5.000,00,0 4.965.600.00 5069069.00 064001GS8 BERKSHIRE RIOPTTAFIELD NR NR NR 12302010 +2136.402+ 2.20) EA,690.w 251565.91 ]xxt X.69 456956FY4 INT L SK R ECON 6 DEVELOP NR AA. AM 91102917 1262077 2.165 5.690 w 5.011.659.69 4,963,056'0 31WAALZ9 FH LB ST E RU M. A.. HR 187M17 18T8072 1000 3,569,690.69 3,469,]58.50 3,500,000.00 3IMEHAK9 FEDERAL FARM CREDIT BANK M. Ax AM 7832917 ]832922 2.000 S.XOXO.w 64132,61500 5,000.00900 94M7AH3 WASHINGTONFIRST BAN.HAR NR HR HR 222.17 7/417022 2.050 25000,0 250,690.00 2W.M.w 25W1 DOLLAR BAN K FSB PA MR NR MR 162017 162017 2050 250069.0 2X.,0000 2500X00 574193171.6 MMYLANDSTGOUMLT AAA A4. AAA 3878017 1152077 2.757 5.190=w 5356.106.60 5.19O.M.00 966760050 EBNA NR MR MR .58017 418022 2102 2690w.w 24.81542 24.61542 "EP'eGtiMe Dura23an:2.239 1.453 309,502,000.00 309,690,760.47 309,813,041.06 Sourc4: U.S.B4.a Ssr.n PIN •v.wA.4..yeer.4rta.4+u....4.r.ca.lc.,4Mn e,,.m.�4.IaA 3300'0)006,0)4. ea+tlEae.Pallo9o2.174N NAI- F4tl.n1 A&in IMaS942.C,APanlM.uwUm N.U,-dh'.U.S.Gow4wn.d.9a4KY.ntl.nfwl 3374.. N.gq'o W CDt a..dA nlotl,lrA.o FDIC 4uwoa, 5 =ry Treasurer-Tax Collector Peggy Moak, Treasurer-Tax Collector v Treasury Division Butte 25 County Center Drive, Suite 125 T: 530.538.7576 County Oroville, California 95965-3384 F: 530.538.7648 I buttecounty.net/ttc TREASURER-TAX COLLECTOR May 15, 2017 Butte County Board of Supervisors Butte County Chief Administrative Officer Investment Pool Oversight Committee The attached statements showing investment transactions for the month ending April 30, 2017 are submitted in accordance with Government Code, and with Local Agency Investment Guidelines as provided by the California Debt and Investment Advisory Commission. The Investment Policy effective July 1, 2016 includes a provision for monthly reporting of investment transactions to the Board of Supervisors. In addition to the above, Investment Reports are submitted on a monthly basis. Quarterly Investment Reports are also made available on the Treasurer-Tax Collector website at hftp://www.buftecounty.net/ftc. If you have any questions regarding investment reporting, please feel free to contact me, or Lisa Lam, at 538-7539. Yours truly, 4�A4� Peggy Moak Butte County Treasurer-Tax Collector Monthly Investment Transaction Reporting Table of Contents Funds Under Management of Trustees • Wells Fargo Bank -- 2004 Pension Obligation Bonds • Umpqua Bank - York Risk Services Group Local Agency Investment Fund • Butte County Treasurer • Butte Community College District • Paradise Unified School District • Oroville Union School District • Chico Unified School District • Butte County Office of Education CalTrust CAMP Five Star Bank US Bank Safekeeping Butte County Treasurer Monthly Investment Transaction Reporting Funds Under Management of Trustees Wells Fargo Bank,Trustee 2004 Pension Obligation Bonds Transaction Activity Series A Series B 750,00' With Transaction&Month End Date XXXXit06 XXXX7109 XXXX1140 mmmmmmXXXX1141 XXXX1142 XXXX1301 XXXX1305 XXXX13071013112016 Fair Value 1,95Q989.35 2,650.27 11.64 66,79 824,20 13,887,78 952,861.03 18.98interest Eametl 446.24 0.23 0.01 0.92 220.39 Wire Transfer From Butte County 0TransferTo XXXXI307 0TransferTo XXXX1301 (14,459.19) 9)TransferTo XXXX1140 0 Transfer To XXXX1141 (834P921 40) (934 921,40) 'rransrar To XXXX1142 0,00 Principal Paid to Bondholder 0.00 Interest Paid to Bondholder (13.88719) (13.88719) Transfer from XXXX1106 834,921.40 834.921,40 Transfer from XXXX1305 14,459,19 14,459.19 1113012016 Fair Value 1,116,514.19 2,650.50 11.54 834,978.20 624.20 14,480.70 938,422.23 18.98 2,907,680.54 Interest Earned 396.92 0.21 5.62 0.19 196.36 599.30 Wire Transfer From Butte County 0,00 Transfer To XXXX1307 0100 Transfer To XXXX13D1 (17,512.22) (17,51222) Transfer To XXXX7140 0.00 Transfer To XXX0141 0,00 Transfer To XXXX7142 0.00 Principal Paid to Bondholder 0,00 Interest Paid to Bondholder (834,978.20) 414,460.70) H11,4438.90) Transfer from XXXX7106 0.00 Transfer from XXXX7305 17,512.22 512.22 1213112016 FaE[Value 1,116,911.11 2,650.71 11.54 5.62 624.20 17,512.41 921,106.37 18.98Interest Earned 297.96 3.07 0.03 0.70 249.69 0.01551A6Wire Transfer From Butte County 0.00 Transfet To XXXXi 307 0.00 Transfer To XXXXi 301 (17,980.86) 17,990.86) Transfer To XXXX1146 0.00 Transfer To XXXX1141 0.00 Transfer To XXXX1142 0.00 Principal Paid to Bondholder 0.00 Interest Paid to Bondholder (17,512.41) (17,512.41) Transferfrom XXXX11 D6 0.00 Transfer from XXXX1305 17,990.66 17,980.86 113112017 Fair Value 1,117,209.07 2,663.76 11.54 5.62 624.23 17,981.66 903,375.20 18.99 2,041,819.88 Interest Earned 374.62 0.34 0.02 1.75 307.65 0.01 684.29 Wire Transfer From Butte County 0.00 Transfer To XXXK1307 0.00 Transfer To XXXK1301 (17,503,85) (17,503.65) Transfer To XXXX1140 0.00 Transfer To XXXX1141 0.00 Transfer To XXXX1142 0.00 Principal Paid to Bondholder 0.00 Interest Paid to Bondhoder (17.981.56) (17.981.56) Transfer from XXXX1106 0.00 Transfer from XXXX1305 17.503.65 17.503.85 212 812 01 7 Felr Value 1,117,583.69 2,654.12 11.54 5.62 624.25 17,505.60 886,178.90 19.00 2,024,582.72 Interest Earned 356.56 0.32 0.02 1.41 286.91 0.01 645.23 Wire Transfer From Butte County 0.00 Transfer To XXXX1307 I I0.1111 Transfer To XXXX1301 (20,715.01) (20,715.01) Transfer To XXXX1140 0.00 Transfer To XXXX1141 0,00 Transfer To XXXX1142 0,00 Pdnclpai Paid to Bondholder 0,00 Interest Paid to Bondholder (17 505,60) (17,505.60) Transfer from XXXX1106 0.00 Transfer from XXXXI305 20,715.01 20,715.01 3!3112017 Felr Value 1,1177940.25 2,654.44 11.64 5.62 524.27 20,716.42 866,760.80 19.01 2,007,722.36 Interest Earned 472.41 3.58 0.07 2.58 372.01 0.01 850.66 Wire Transfer From Butte County 0.00 Transfer To XXXX1307 0.00 Transfer To XXXX1301 (20,789.86) (20,789.86) Transfer To XXXX1140 0.00 Transfer To XXXX1141 0.01) Transfer To XXXX1142 0.00 Principal Paid to Bondholder 0.00 Interest Paid to Bondholder (20.716.42) (20,716.42) Transfer from XXXX1106 0.00 Transfer tram XXXX1305 2D,789.86 20,789.86 413012017 Fair Value 1,118,412.66 2,658.02 11.54 5.62 824.34 20,792.44 845,332.95 1 19.021 1,987,856.59 Sources:1)Wells Fargo Bank Statements,2)Butte County Administration Office Butte County Treasurer Monthly Investment Transaction Reports Investments Under Management of Trustees York Risk Services Group, Claims Administrator Umpqua Bank WORKERS' COMPENSATION Account#XXXXX2601 Transaction Activity-Current Month Beginning Balance-3/31/2017 1,404,064.32 Deposits/Additions 4110117 134,540.59 4/21/17 26,672.13 4/28/17 42,057.27 ACH and Electronic Payments/Subtractions (127,983.08) Withdrawals/Subtractions Disbursements Checks Paid (1,275,672.20) Maintenance Fee 4120117 (102.04) Ending Balance-4/30/2017 203,576.99 Source: Umpqua Bank Statement LAIF Regular Monthly Statement Page 1 of 1 Local Agency Investment Fund P.O.Rox 942809 rvw►v.trcasurcr.ru.�ovlumia-laiflluif.asn Sacramento,CA 94209-0001 (916)653-3001 May O1,2017 BUTTE COUNTY CHIEF DEPUTY TREASURER PMA Avei:gUjV,11qn1hly Yields 25 COUNTY CENTER DRIVE OROVILLE,CA 95965-3384 Account Number: Tran Type Delinitions April 2017 Statement Effective Transaction Tran Confirm Date Date 'Type Number Authorized Caller Amount 4/7/2017 4/7/2017 RD 1532363 COLETTE WORSHAM 15,000,000.00 4/14/2017 4/13/2017 QRD 1532903 SYSTEM 24,597.29 4/14/2017 4/14/2017 RD 1535174 COLETTE WORSHAM 5,000,000.00 4/28/2017 4/27/2017 RW 1536196 LISA LAM -5,000,000.00 Account Summary Total Deposit: 20,024,597.29 Beginning Balance: 8,352,195.07 Total Withdrawal: -5,000,000.00 Ending Balance: 23,376,792.36 https:l/laifms.tlreasurer.ca.gov/RegularStatement.aspx 5/1/2017 LAIF Regular Monthly Statement Page 1 of 1 Local Agency Investment Fund P.O.Box 942809 Sacramento,CA 94209-0001 www.treasurer.ca.tov/nmia-laifll,2001717 2 (916)653-3001 May 01, BUTTE COMMUNITY COLLEGE DISTRICT BUTTE COUNTY TREASURER I'MIA Average Monthly Yields 25 COUNTY CENTER DRIVE,SUITE 125 OROVILLE,CA 95965-3384 Account Number: 'Iran Type Definitions April 2017 Stntement Effective Transaction Tran Confirm Date Date Type Number Authorized Caller Amount 4/6/2017 4/6/2017 RD 1532277 COLETTE WORSHAM 41,815,000.00 4/14/2017 4/13/2017 QRD 1533018 SYSTEM 22,919.48 Account Summary Total Deposit: 41,837,919.48 Beginning Balance: 13,651,781.30 Total Withdrawal: 0.00 Ending Balance: 55,489,700.78 https://laifms.treasurer.ca.gov/RegularStatement.aspx 5/1/2017 LAIF Regular Monthly Statement Page 1 of 1 Local Agency Investment I�und P.O.Box 942809 ►v Sacramento,CA 94209-0001 rv►v.trcaxurcr.ca.ao►/timia-laifll,2017 (916)653-3001 May 41,2017 PARADISE UNIFIED SCHOOL DISTRICT BUTTE COUNTY TREASURER I'MIA Average Monthly Yields 25 COUNTY CENTER DRIVE,SUITE 125 OROVILLE„CA 95965 Account Number: Trfla T V•Definitions April 2017 Statement Effective Transaction Tran Confirm Date Date Type Number Authorized Caller Amount 4/14/2017 4/13/2017 QRD 1533019 SYSTEM 21,898.99 4/17/2017 4/17/2017 RD 1535289 LISA LAM 5,000,000.00 Account_Summary Total Deposit: 5,021,898.99 Beginning Balance: 13,173,870.37 'total Withdrawal: 0.00 Ending Balance: 18,195,769.36 https:/llaifms.treasurer.ca.gov/RegularStatement.aspx 5/1/2017 LAIF Regular Monthly Statement Page 1 of 1 Local Agency Investment Fund P.O.Box 942809 Sacramento,CA 94209-0001 www.treasuict,.ca.i!ov/iiniia-laif/laiEasp 01,12017 (916)653-3001 May 01,2017 OROVILLE UNION 1-110H SCHOOL DISTRICT BUTTE COUNTY TREASURER PM1A Averoee Monthly Yields 25 COUNTY CENTER DRIVE,SUITE 125 OROVILLE,CA 95965-3384 Account Number: TE-1111Tune 1)elini[iai3s April 2017 Statement Effective 'Transaction Tran Confirm Date Date Type Number Authorized Caller Amount 4/14/2017 4/13/2017 QRD 1533020 SYSTEM 20,909.35 4/18/2017 4/18/2017 RD 1535392 LISA LAM 3,500,000W Account Summary Total Deposit: 3,520,909.35 Beginning Balance: 13,567,318.81 Total Withdrawal: 0.00 Ending Balance: 17,086,228.16 https://Iaif-is.treasurer.ca.gov/RegularStateinent.aspx 5/1/2017 LAT Regular Monthly Statement Page 1 of 1 Local Agency Investment Fund P.O.Box 942809 w►v�r.treasurer.ca.Qovinmia-laif/laif.asn Sacramento,CA 94209-0001 (916)653-300I May 01,20/7 CHICO UNIFIED SCHOOL DISTRICT BUTTE COUNTY TREASURER PMIA Avernac Monthly Yields 25 COUNTY CENTER DRIVE,SUITE 125 OROVILLE,CA 95965-3384 Account Number: Tran'Unc Detiniti0ns April 2017 Statement Effective Transaction Tran Confirm Date Date Type Number Authorized Caller Amount 4/14/2017 4/13/2017 QRD 1533022 SYSTEM 25,600.81 4/20/2017 4/20/2017 RD 1535566 LISA LAM 6,000,000.00 4/25/2017 4/25/2017 RD 1535898 LISA LAM 44,000,000.00 4/28/2017 4/28/2017 RW 1536248 LISA LAM -3,000,000.00 Account Summary Total Deposit: 50,025,600.81 Beginning Balance: 14,502,797.78 Total Withdrawal: -3,000,000.00 Ending Balance: 61,528,398.59 https://Iaifms.treasurer.ca.gov/RegularStatement.aspx 5/l/2017 LAIF Regular Monthly Statement Page I of I Local Agency Investment Fund P.O.Box 942809 �Y55'W.tl'Ca5111'e1'.Ca.LrOVlnmlA-Iaifllaif.asn Sacramento,CA 94209-0001 (916)653-3001 May 01,2017 BUTTE COUNTY OFFICE OF EDUCATION BUTIT COUNTY'FREASURL'R PMIA Average Monthly Yields 25 COUNTY CENTER DRIVE,SUN-E 125 OROVILLE,CA 95965-3384 Account Number: Tran'l'vna Ddinitivas April 2017 Statement Effective Transaction Tran Confirm Date Date Type Number Authorised Caller Amount 4/13/2017 4/13/2017 RD 1532708 COLETTE WORSHAM 5,000,000.00 4/14/2017 4/13/2017 QRD 1533023 SYSTEM 19,342.00 Account Summary. Total Deposit: 5,019,342.00 Beginning Balance: 7,054,840.03 Total Withdrawal: 0.00 Ending Balance: 12,084,182.03 https:Hlaifrns.treasurer.ca.gov/RegularStatement.aspx 5/1/2017 COUNTY OF BUTTE STATEMENT FOR PERIOD April 01, 2017 -April 30, 2017 CalTrust Short Term Fund - BUTTE, COUNTY OF Price Per Average Average Realized Date Transaction Shares Share Amount Cost NAV Cost Amount Gain1Loss" 03/3112017 BALANCE FORWARD 456.409 10.02 4,573.22 10.01974107 4,573.10 04/0312017 INCOME DISTRIBUTION-MARCH 0.395 10.02 3.96 10.01974589 3.96 0.00 04/3012017 UNREALIZED GAIN(LOSS) 0.000 0.00 0.00 04/3012017 ENDING BALANCE 456.804 10.02 4,577.18 41577.06 INCOME DISTRIBUTION PAID-MARCH 0.00 INCOME ACCRUAL-APRIL 3.90 CUMULATIVE UNREALIZED GAIN(LOSS) 0.12 "Please note that this information should not be construed as tax advice and it is recommended that you consult with a tax professional regarding your account. For Inquiries About Your Account,Contact: COUNTY OF BUTTE Nottingham Investment Administration BUTTE,COUNTY OF 116 South Franklin Street ATTN: PEGGY MOAK Rocky Mount,NC 27804 25 COUNTY CENTER DR,STE 125 Attention:CaITRUST Shareholder Services OROVILLECA 95965 Phone:800.773.3863 Fax:252-972-1908 Email:caltrustsupport@ncfunds.com Page 1 of 1 LQY1 �?t+ M c.�1 1R c M a C _ 40/ 11.1 0 CO M M O N 0 Ln CL II I I� II IE �':: IIS IIII ..x I�IIII I II II II ;�:C;:ir_j II II IIU II II II - a$ o � a = U D IQ %D C71000 16 c C F� CO 0 0 o uj co L M 61 M 00 13N H m C-4 ri N -4 O 1Q Ti � g 3 r E x CD „`I m c > fu to rn a m E G d CL 5m p W m 0CLmm6 u (5 a to 14 CD p M � n-i o A Q' m Q CP CP Q L a Ln O O r+ y M 0} tD Ql O O ti O .� O -� O E Go ON 40 ai1 R V O fV CC M G O N 3;qW O O O O O 10 ++ V O R ?3 CM tm g IV �u O. l'? 000 M O a p4MOQ Lo M �+ 0 n c o Q N N a c O i. rn o o to C� r, ODoa ui 00 O rn en y = } M N M N -� O Q E N N o g � u c 2 J �= F a J I t C rl ^ ^ tl7 ,moo` � yWa O ,moi O V_ tin Lcm ip W o o V !g ss' y W V 4L1 W 06 u ro R C 1r4C 10 Of G Q fA CL c CL o a � a 0 v OaG� u FIVE STAR BANK county of Butte Date 4/28!17 Pa� 25 county center Drive, Suite 125 Account number oroville CA 95965-3384 Enclosures Use Five Star Bank's mobile banking app on your smart device to check your balance,transaction history,deposit checks, activate your debit card,and morel Call(916)626-5012 to enroll. 1111 1 Public Funds MMA Number of Enc osures 0 Account Number statement Dates 4/01/17 thru 4/30/17 Previous Balance 1,00 , Days in the statement period 30 Deposits/Credits .00 Average Ledger 1,003,340 checks/Debits .00 Average collected 1,003,340 Electronic DR .00 Service charge .00 Interest Earned 665.17 Interest Paid 665.17 Annual Percentage Yield Earned 0.810/0 Ending Balance 1,004,005.38 2017 Interest Paid 2,482.76 MEMEM 4/30 INTEREST PAID 30 DAYS 665.17 IE 4/01 1,003,340.21 4 30 1,004,005.38 z5a Ml 3/31 .78% 4/11 .82% r r- orno � t-- Cl) cpvco N t0 N m V' a) N C) , O Vi N ' YOrnvOI�+ Z EL O co co u°5 vi vi F 0. E ; N d O O 4 � r O , N W cm LO 6 n T n m a M O N O C) O O ++ O t0 m fA Wi 7r Q O 4 r: `o V co m LJ_ m r n Go on ,C M o ` M a dCD 0 v O o LLo C c - CO of Cl) o O N M Q D N yo 0 L OO 00 O L O O CD � O C6 O x a M CD W O M LU COQ LU N C D O D rn 0 2 o o n '' O m N tIl U U c cm U E E n H E E N f6 3 OF z z Z C: c 0 0 a a 0 + C) O o 0 0 CD a r- °r° o o m o o in M �+ p p 0 0 c 0 0 0 0 (D o N m 04 a) r- o o v O O O O O O N st '� rr- h O O O O O O 40 00 U W p O Q O O Ln w NCo N N N N N N C7 r C) t M CSV r 7 M m m 4 N .. CL n r 0 N_ 4 oO O et h O p Ch N N CD Ln v o 2 2 (n m p w a 2 z N m d a U U m co x d N LL ¢ p N N 0 M co U7 m O rl to t+1 Cn N N 00 00 W CD h O O h CD CD 0 C) u0 V' m LO LO O O 00 O m N '-r O m m O Q. h h M M 00 in m >n h C? In V Lq LLi V) r r a) CD r- N 00 N Nr r O LL. m< G o m Z o 0 pp O N V 6 Cn O m IL (x O m O to N h N N N N m N N N N m co N Z O O 0 O 0 Q 0 Q C? 4 Q 0 0 O •' N N N N N N N N N N N N N N •� O r O r O r O r O r O CC) O 00 O to O r O r O r O LO O h O 00 OO OO OO OO to COr ON OLO N ON Ou0 N N V 16 W 9 q CD V � '� p � �d CV Q O � � CV O np NpN) C`� D C7 � NO a CC r O r 0 r 0 r 0 N O r r N O N +^ •^ r N O r r r p CV r r U � d Q U m m min m o o M a z � � Y � o ° F c�7 ca7 ~ 55 2 ,c V) U) 53 z cn w d U) Fm Fm D � W a �i ¢ a IL C ma d r� � � cal 00 co:7 � 06 a � © Y � � C, .6m aF � wZ wz COJ o Z � LL o zo ¢ o ao og LLw zo c �o U, o a aL o o m � } w OF L) Q Jw zW a = J 0 z zz a W U a W ¢ Z ¢ a CCU YU pa M v <O Q O O O z L� 1 °r I J L� > L� z t� L� d m o g Q L� rnU) rnU) LL LL ¢ F ml;, U aF 0 — 2F W � 0° u, } LL � F C) fnz UJz J JCa Zix � o ¢ O � UCC UIx n � rN � � SL Cr! m ¢ O ¢ O a aX co Ll Fp fY W W W } W 0 L FQ W CC ¢ W W O U U U UF- NU Z o 4. 0 oU UJU C-) (.5 Z .- zLL UU � a [r F-- m OCA N N Q y N N N N N N N N W Ix L N M hM r- m hN h C0 hm hh h0 hm hr r— m h c^ h C•0 h � hr E E h h m u7 m m CD r C0 r N Ch h O r u] m = Om Om OL6 Om O00 OCO ON O00 Om OO Or ON Oh O z z N m N m N v N LO N m N N N m N co N a) N O N m N NN 'W N m i-,5 C'0 CoV Ch CD iC] MC? X00 6 F-- (2 V _ ?R C? iB00 ti ; h and 2 s_O� N s_O� N 5204C_� OQO pN ON t� N N NN CQN � n Q N NN NN ¢ Q DF OM `" M c`�i CmO r 9I 9co `rM M � M 8Cl) csr- " M 8M C M T q Q N O O O N E f+ n W O Q 00N sh N Q r r M O N 0- C)0 N CD N O O cLL co O 7 cr) to O tU m O LL ma � z aaCO 0` CD 0 }+ r r A N N Q Q 0 � o > o Z N Z } U H � m F � a � a 06 co N z C)4 o Q o U o � CD W _ *� W } of N ❑ OD V N 0 � m � m E p W GI u m Z o Z) Ln s Q W IY F- z O LU m E E � c � cr) m m om 0r- Z Z U U l0 L1 NV to Q Q GI F- o f- a f-