Loading...
HomeMy WebLinkAboutInvestment Report and Transaction Reporting for June 30, 2018 Menchaca, Clarissa From: Lam, Lisa Sent: Monday,July 16, 2018 3:37 PM To: Snyder, Ashley; Gullickson, Caroll; Childs, Heather; Christy Patterson, Butte County Schools JPA;Worsham, Colette; Houser, David; Heather Naylor, Gridley Unified School District; Cook, Holly; Beene, Dana; Bruffett, Jim; Kevin, Bultema, Chico Unified School District; Honea, Kory;Jordan, Kurt; Lisa Anderson, TOC Member(BCOE rep); Lam, Lisa; Sandoval, Maritza;Jessee, Meegan; Menchaca, Clarissa; Mia Osborne-Ng, Executive Assistant to the Butte County Superintendent of Schools; Ramsey, Mike; Moak, Peggy; Bennett, Robin; Hubbard, Sheryl; Connelly, Bill; Kirk, Maureen; Lambert, Steve;Teeter Doug; Wahl, Larry; Peterson, Susan; Susan Watts, TOC Member(OUHSD rep); Tim Taylor, Butte County Superintendent of Schools;William (Jim) Nicholas, Director of Business Services; Bangor Cemetery District - Theresa Phillips,Trustee; Starkey, Darlene; BCOE, Leslie Romero Arana; BCOE, Travis H:askill; Butte Co Resource Conservation; Reynolds, Sarah:; Butte County Resource Conservation District; Butte Creek Drainage, Drainage District#2; Hobbs, Debbie; CARD; Radcliffe, Heidi; Smith, Cheryl; Christy Patterson, Executive Director, Butte Schools Self-Funded Programs; Quigley, Cindy; Drainage District#11; Drainage District#100; Drainage District #200; Amador, Aaron;Weinreich, Anita; Durham Recreation & Park; Cyr, Kirsten; Dwayne Long, Lake Oroville Area Public Utility District; El Medio, Fire; El Medio Fire; Feather River Rec & Park Dist. Randy Murphy, General Manager; Peltzer, Deborah;Teague, Pat; Broderson, Jill;Jane Avram, Nancy; Cahn, Jeff, Spreen, Misty; Knight,Jay; Richardson Springs, Carlos Penning; Compton, Vickie; Ravert, Rochelle; Behr, Paul; Minasian, Paul; Dehart, Denise;Valentine, Gwen; Larson, Marvin Subject, Investment Report June 30, 2018 Including FYE FIVIV and Transaction Reporting Attachments: Investment Report Including FYE FMV Report, June 30, 2018.pdf; Transaction Reporting June 30, 2018.pdf Greetings! The Treasurer's Investment Report including FYE FMV Report for the month ending June 30, 2018 is attached, for your reference. Additionally, the information provided in the attached "Transaction Reportingi June 30, 2018" consists of spreadsheets and statements detailing transaction activity for the month. If you have any questions or concerns, please feel free to contact me, or Peggy Moak at 552-3737. Kind regards, Wal La4n Assistant Treasurer-Tax Collector, Treasury Division Butte County Treasurer-Tax Collector 25 County Center Drive, Suite 125, Oroville, CA 95965 ATTENTION: THIS IS A NEW PHONE NUMBER. PLEASE UPIDATE YOUR RECORDS T: 530,552.3731 1 F 530,538,7648 Twitter I Facebook I YouTub,e I Pinterest Treasurer—Tax Collector Peggy Moak, Treasurer-Tax Collector Treasury Division ■ 25 County Center Drive, Suite 125 T: 530.552.3730 e 0roville, California 95965-3384 I F: 530.538.7648 buttecounty.net/ttc TREASURER-TAX COLLECTOR July 16, 2018 Butte County Board of Supervisors Butte County Chief Administrative Officer Investment Pool Oversight Committee The attached investment report for June 30, 2018 is submitted in accordance with the Butte County Statement of Investment Policy dated July 1, 2017. 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 LAIF usually mirrors. The 5-year moving average for Butte County's FY 15116 and FY 16117 performance compared to LAIF shows margins of 0.865% and 0.697%, respectively. Using $375,000,000 as a baseline portfolio (actively invested balance), this translates to enhanced earnings averaging $2,613,750 per year for the past five years. NOTE: Fair values are trending lowerthan 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. The fair value of the pooled Treasury portfolio is 98.88% of the cost-carried balance as of 6-30-18. Quarterly Investment Reports are made available on the Treasurer-Tax Collector website at http://www.buttecounty.net/ftc. Respectfully, Peggy Moak Butte County Treasurer-Tax Collector cc: Butte County Auditor-Controller Butte County Special Districts(Quarterly) Butte County Board of Supervisors Butte-Glenn Community College Butte County District Attorney Chico Unified and Gridley Unified School Districts Butte County Schools-JPA Jessee, Meegan—Butte County Deputy Administrative Officer Butte County Sheriff Beene, Dana—Internal Auditor Butte County Superintendent of Schools ButLe County BUTTE COUNTY TREASURER'S INVESTMENT REPORT • C A L I F O R N I A Butte Counly Pooled Treasury Fair Value as of 6130118* Investment Cost Carried CC Fair Value JFVj Percentage FV1CC LAIF $ 56,867,083.10 $ 56,727,076.40 99.7638001% CalTrust $ 4,645.46 $ 4,652.92 100.1605869% CAMP $ 50,086,441.88 $ 50,086,441.88 100.0000000% Five Star Bank $ 5,066,889.41 $ 5,066,889.41 100.0000000% Negotiable CDs $ 10,496,818.41 $ 10,500,000.00 100.0303100% Municipal Bonds $ 43,966,049.72 $ 43,179,941.40 98.2120106% Corporate Notes $ 38,316,087.81 $ 37,822,682.96 98.7122776% Federal Agency 1 Supranational Notes $ 193,051,286.36 $ 189,558,743.59 98,1908731% Treasury Notes $ 78,376,020.17 $ 77,181,141.00 98.4754531% School Bonds LAIF $ 65,869,613.24 $ 65,707,442.32 99.7538001% Investments under Mgmt of Trustees LAIF $ 1,667.59 $ 1,663.4B 99.7538001% Money Market Funds $ 320,401.83 $ 320,401.83 900.0000000% Cash $ 19,048.35 $ 19,048.35 100.0000000% Discovery Benefits- $ 30,000.00 $ 43,300.67 144.3355667% Umpqua Bank-Workers'Comp Admin $ 174,282.72 $ 174,282.72 100.0000000% Cash on Nand US Bank Checking Accounts $ 13,225,826.19 $ 13,225,825.19 100.0000000% Operating Cash $ 63,322.30 $ 63,322.30 100.0000000% TOTAL $ 555,935,484.54 $ 549,682,857.42 98.8752963% 98.88% * The fair value of the pooled Treasury portfolio,Including cash on hand,is 98.88%of the cost-carried balance as of 6.30-18 *"Represents the most current available data as of 1213112017(source:Auditor-Controller) (Please refer to attached"Treasurer's Investment Report-Introduction"for additional information) Treasurer-Tax Collector Peggy Moak, Treasurer-Tax Collector 7" 25 County Center Drive, Suite 12S T: 530.552.3730 buttecounty.net/ttc Oroville,California 95965-3384 F: 530.538.6462 Butte TREASURER-TAX COLLEaOR Treasurer's Investment Report - Introduction The Butte County Treasurer's office manages investments on behalf of the County, various Trust and Agency Funds, School Districts and Special Districts within the County. "Pooling" deposits from local agencies and other participants is in the public interest because banking and investment activities are consolidated, thereby reducing duplication, achieving economies of scale and carrying out coherent investment strategies. Butte County's portfolio management is an active management strategy in that a broad range of market analysis techniques, investment options and cash management tools are employed in making investment decisions. The medium term, laddered maturity portfolio allows participants to benefit from higher earnings than might otherwise be possible. The objective of this strategy is to obtain the highest return feasible, consistent with a high degree of safety of principal and the level of liquidity necessary to meet the needs of the County and agencies participating in the Treasury. Earnings on the pooled investments are paid quarterly, on a pro-rata basis and less Treasury costs, to pool participants. The Treasurer's Investment Report is designed to provide specific and general investment information to pool participants and to interested members of the public. The cover letter indicates compliance with the Butte County Treasurer's Statement of Investment Policy, identifies U.S. Bank as the source of the market value of investments held in the investment pool, and states our ability to meet estimated liquidity needs for the next six months. The cover letter also compares the portfolio yield and that of the State Treasurer on a five- year rolling average basis, which serves to effectively demonstrate the bottom line in terms of enhanced earnings to pool participants. The Butte County Pooled Treasury Portfolio's medium term, laddered investment strategy outperformed the State of California's Local Agency Investment Fund (LAIF) in Fiscal Year (FY) 15116 by a margin of 0.658% and by 0.502% in FY 16117.* Market conditions (lowering interest rates) allowed the portfolio to significantly outperform LAIF over the past five years. In a rising market, the portfolio's yield will more closely approximate that of LAIF and may drop below LAIF's yield, from time to time. A look at the 5 year moving average for the Butte County Treasury yields vs. LAW yields demonstrates that, over time, a medium term, laddered portfolio will generally outperform a shorter term investment strategy, which LAIF usually mirrors. The 5 year moving average for Butte County's FY 15116 and FY 16117 performance compared to LAIF shows margins of 0.865% and 0.697%, respectively.* Looking at a ten year average, the portfolio exceeded tA1F's yields by a healthy 1.016%. Page 1 of the Investment Report shows the portfolio balance (separately identifying the actively managed portfolio), the average number of days to maturity and the yield to maturity for the investments held by the pool. The balances invested are shown in three different ways: Par Value (the value at maturity of the instrument), Fair Value (the value if sold as of the date of the report) and Cost Carried (the amount paid for the investment, amortized to reach Par Value by maturity). The difference between the fair value of the investments and the cost carried is considered to be "unrealized" gain or loss. A gain or loss is only realized if a security is sold prior to maturity (T-Bills, Corporate Notes, Agency Notes, Negotiable CDs and Commercial Paper are redeemed at a pre-established Par Value at maturity). It is important to note that the Butte County Pooled Treasury typically uses a "buy and hold" investment strategy; however, we occasionally sell securities when it is advantageous to the pool's earnings to do so. Cash flow and liquidity needs are carefully analyzed prior to making investments to ensure liquidity needs are met. The bottom portion of page 1 indicates the ability of the pool to meet projected cash flow requirements for the next six months. Please note, however, that the projected and actual results will vary, sometimes materially, because events and circumstances do not always occur as predicted. School Bond Proceeds and, if applicable, Tax and Revenue Anticipation Notes (TRAN) proceeds are separately accounted for in the report, and are invested in the State Treasurer's Local Agency Investment Fund (LAIF) or other securities as deemed appropriate. Note that the annual portfolio yields quoted (the yield method used is "weighted yield to maturity") exclude separately invested Bond and TRAN proceeds, as well as investments managed by Trustees, as they are not part of the actively managed portfolio. Investments of School Bond Proceeds are detailed on page 2 of the report, and investments managed by outside Trustees as part of financing agreements are detailed on page 3. Page 4 of the Report contains chart information that is very helpful in providing a quick overview of the diversification of the portfolio by type of instrument and maturity ranges. Included is a chart showing the Treasury Portfolio balance fluctuations from 2008 through the current month (Investments Managed by Trustees, TRAN and Bond proceeds are not included in the charted information). An analysis of this chart clearly demonstrates that the Treasury maintains a stable average balance of approximately $375,000,000, which supports the philosophy of medium term investment of funds not anticipated to be drawn upon to meet ongoing liquidity needs. Page 5 & 6 provides a listing of specific investment instruments (listed in order of maturity date), credit ratings, purchase and maturity dates, balances invested and yields obtained. The Investment Pool Oversight Committee and the Board of Supervisors receive the Treasurer's Investment Report on a monthly basis. The Investment Pool Oversight Committee was established in November 2015 and serves to ensure that representatives of pool participants are involved in the oversight of the Butte County Treasury pooled investment portfolio. The committee is subject to the Brown Act. Questions regarding the Investment Report may be directed to Lisa Lam, Assistant Treasurer-Tax Collector), at 530-552-3731, or Ilam@buttecounty.net. The margins quoted represent the difference between the annual yields of the Butte County Pooled Treasury Investment Portfolio and the Local Agency Investment Fund. Butte County BUTTE COUNTY TREASURER'S INVESTMENT REPORT tKA3UAEA-Ux COMCT6R June 30,2018 YIELDTO WEIGHTED AVERAGE ACTIVELY MANAGED PORTFOLIO: MATURITY MATURITY(DAYS]' PARVALUE FAIRVALUE COSTCARRIED LOCAL AGENCY INVESTMENT FUND(LAIF) 1.854% 1 56,867,083.10 56,727,076.40 56,867,083.10 CALTRUSTSHORT TERM 1.954% 1 4,652.92 4,662.92 4,645.46 CAMP SHORT TERM 2.050% 1 50,086,441.88 50,086,441.88 50,086,441.88 BANK MONEY MARKET(COLLATERALIZED) 1.750% 1 5,066,889.41 5,066,889.41 5,066,889.41 U.S.TREASURY NOTES" 1.860% 898 79,000,000.00 77,181,141.00 78,376,020.17 MUNICIPAL BONDS" 1.877% 759 43,760,000.00 43,179,941.40 43,965,049,72 CORPORATE NOTES" 1.962% 708 38,359,000.00 37,822,682.96 38,316,087.81 NEGOTIABLE COS" 2.032% 1,062 10,500,000.00 10,500,000.00 10,496,818.41 FEDERAL AGENCY /SUPRANATIONAL NOTES" 1.916% 1,011 193,485,000.00 189,558,743.59 193,051,286.36 TOTAL ACTIVELY MANAGED PORTFOLIO: 1.914% 708 477,129,067.31 470,127,569.56 476,231,322.32 INVESTMENT OF NOTE/BOND PROCEEDS AND OPERATING CASH SCHOOL BOND PROCEEDS J.-p.yezrwdemd.) 65,869,613.24 65,707,442.32 55,869,613.24 OPERATING ACCOUNTS U.S.BANK CHECKING ACCOUNT DEPOSITS 13,225,826.19 13,225,826.19 13,225,826.19 OPERATING CASH 63,322.30 63,322.30 63,322.30 OTHER 0.00 0.00 0.00 TOTAL TREASURER'S FUND LEDGER BALANCE: 556,287,829.04 549,124,160.37 555,390,084.05 INVESTMENTS UNDER MANAGEMENT OF TRUSTEES(.eea.¢.3rerd.Ws) 558,701.16 558,697.05 545,400.49 PAR VALUE FAIR VALUE COST CARRIED TOTAL CASH AND INVESTMENTS: 556,846,530.20 549,682,857.42 555,935,484.54 SIX MONTH LIQUIDITY PROJECTIONS Estimated Cash Receipts for Next Six Months 540,342,599 Estimated Disbursements for Next Six Months -479,708,574 Estimated Net Cash Flow for Next Six Months— 60,634,025(Al) Prudent Reserve -30,000,000(A2) Securities Maturing 38,500,000(H) Loral Agency Investment Fund 1 Cal Trust!MMF/CAMP 112,025,060(C) Total Liquidity for Next Six Months 181,159,085(A1+A2+8+C) Estimated Cash Available for Long Term Investment -30,000,000 Remaining Available Liquidity 151,159,085 Total Par Value of actively managed investments maturing in less than 12 months: 180,722,067 Total Par Value of actively managed investments maturing in more than 12 months: 296,407,000 Actual Weighted Average Maturity will be shorter,and actual dollar amount of investmenis maluring in less than 12 months will be higher than staled,due to call features on investments. Seepage 5 for detailed list of investments. "' Includes TRAIN(fax and Revenue Anticipat#on Notes)receipts and disbursements,if applicable. 1 BUTTE COUNTY TREASURER'S INVESTMENT REPORT INVESTMENT OF SCHOOL BOND PROCEEDS June 30,2018 INVESTMENT MATURITY ANNUAL PAR FAIR COST BONDINOTE DESCRIPTION TYPE DATE DESCRIPTION YIELD' VALUE VALUE CARRIED BONDS-LOCAL AGENCY INVESTMENT FUND(LAIF) Butte-Glenn CCD 2016 GO Bond Series A LAW 1.854% 36,906,373.00 36,815,504.55 36,906,373.00 Chico Unified 2012 GO Band Measure E Series A LAIF 1.854% 1,578,201.64 1,574,316.11 1,578,201.64 Chico Onilied 2016 GO Bond Series A LAIF 1.854% 27,365,038.60 27,317,616.66 27,385,038.60 PAR FAIR COST VALUE VALUE CARRIED GRAND TOTAL 65,869,613.24 65,707,442.32 65,869,613.24 Yields quoted above are a snapshot per investment type.Actual*Ida esmed on school bonds are Wcolated by the Tseasurcrs office and are a composite of Investment eamin0s less Treasury costs. 2 BUTTE COUNTY TREASURER'S INVESTMENT REPORT DEPOSITS AND INVESTMENTS UNDER MANAGEMENT OF TRUSTEESIFISCAL AGENTS June 30, 2018 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 Bond Fund NXXXX1106 Money Market WF GOVT MMP#1751 1.910% 0.00 0.00 0.00 Int.Rate Slabllization Fund#XXXX1109 Money Market WF GOVT MMF 41751 1.910% 1,021.89 1,021.89 1,021.89 Pooled Agency Funds Local Agency Investment Fund 1.854% 1,667.59 1,663.48 1,667.59 Principal Account Fund#XXXX1140 Cash Cash 0.000% 11.69 11.69 11.69 Interest Account Fund#XXXX1141 Cash Cash 0.000% 194.70 194.70 194.70 Surplus Account Fund#XXXX1142 Cash Cash 0.000% 18,841.96 18,841.96 18.841,96 Sinking Account Fund#XXXX1143 Cash Cash 0.000% 0.00 0.00 0.00 Series 8 Interest Fund NXXXX1301 Money Market WF GOVT MMF#1751 1.910% 39,068.50 39,068.50 39,068.50 Series B Band Fund NXXXX1305 Money Market WF GOVT MMF#1751 1.910% 280,243.89 280,243.89 280,243.89 Series S Interest Fund#XXXX1307 Money Market WF GOVT MMF 41751 1,910% 67.55 67.55 67.55 SUBTOTAL 341,117.77 341,113.66 341,117.77 DEPOSITS WITH FISCAL AGENTS Discovery Benefits Plan Year Cash Balance 1/01117-12!311171 NA 43,300.67 43,300.67 1130,000.00 York Risk Services Group-Claim Administrators Umpqua Bank#XXXXX2601 Commercial Bank Business Checking NA 174,282.72 174,282.72 174,282.72 SUBTOTAL 217,583.39 217,583.39 204,282.72 PAR FAIR COST VALUE VALUE CARRIED GRAND TOTAL 558,701.16 558,697.05 545,400.49 Represents the most wrrent data available{source:Auditor-Controtlor) 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" June 30,2018 INVESTMENTS BY TYPE" INVESTMENTS BY MATURITY&YIELD" Local Agency investment Fund1Ca7ruSVMMF/CAMP LAIFICT/MMFICAMP $ 112,025,067 Federal Home Loan Bank FHLB $ 45,200,000 LAI FICALTRUST/MM F/CAMP(I day) 1.9$7% $ 112,025,067 Federal Home Loan Mortgage Corp FHLMC $ 13,075,000 01-12 months 1.765% $ 68,697,000 Federal National Mortgage Assn FNMA $ 15,000,000 13-36 months 1.697% $ 151,934000 Federal Farm Credit Bank FFCB $ 34,560,000 37-60 months 2.163% $ 144,475,000 Federal Agricultural Mortgage Corp FAMCA $ 15,000,000 TOTAL PAR VALUE $ 477,129,067 Corporate Notes CORP $ 38,359,000 U.S.Treasury Notes UST $ 79,000,000 •investments managed by Trustees&School Bond Proceeds not incWded. Tennessee Valley Authority TVA $ 5,000,000 Supranallonat SUPRA $ 65,650,000 Final maturity dates are used;probable call dates are not considered. Certificates of Deposit gCoPaterslizedrllegogabley CDs $ 10,500,000 Amounts quoted at Par Value. Municipal Bonds MUNI $ 43,760,000 $ 477,129,067 zss 9sc 14% 1% 17 8% •LAIF/CALTRUST/MMF/CAMP Il day) •LAIF/CT/MMF/CAMP•FHLB =FHLMC •FNMA .01-12 months •FFCB =FAMCA •CORP •UST -13.36 months •TVA •SUPRA •CDs •MUNI .37-60 months Butte County Pooled Treasury Portfolio Balance" Net of Tax and Revenue Anticipation Notes (TRAN)and Bond Proceeds $550,000,000 $525,000,000 .•�.•2o2e $500,000,000 --e-2027 $475,000,000 --tr-2c2s —a—ems $450,000,000 —it-2ma $425,000,000 $2013 $400,000,000 —,-2022 $375,000,000 —2011 $350,000,000 —•2020 —o—loos $325,000,000 - --0--20c0 $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 TRAM,Hand Proceeds,or Investments under Management of Trustees. H is intended to demonstrate cash flow trends and establish a baseline forthe portfolio,enabling medlum term Investments. 4 BUTTE COUNTY TREASURER'S INVESTMENT REPORT MANAGED PORTFOLIO-DETAILS OF SECURITIES HELD June 30,2018 Page 1 of 2 Credit Rating Purchase Maturity Yield to .s-ecurIty Description S&P Mcad s Fitch Date Date Maturity NA) varvame "irvacue Cost Carried' 89236TCPB TOYOTA MOTOR CREDIT CORP AA- Aa3 A 9118!2015 7/1312018 1.600 5,000,000.00 4,998,310,00 4,999,918.42 912828XK1 U S TREASURY NOTE AA+ Aaa AAA 1!2!2018 7/15/2018 1.509 5,000,000.00 4,997,965.00 4,998,784.02 912828VQO U S TREASURY NOTE AA+ Aaa AAA 113!2018 7/31/2018 1.552 5,000,000.00 4,998,035.00 4,999,271.08 38147,130 GOLDMAN SACHS BANK USA NR NR NR 8!2712014 8/27/2018 1.650 250,000.00 250,000.00 250,000.00 02567CAY6 AMERICAN EXPRESS SK FSB NR NR NR 8!2812014 8/28/2018 1.600 250,000.00 250,000.00 250,000.00 91282BL40 U$TREASURY NOTE AA+ Aaa AAA 318!2018 9/1512018 1.860 5,000,000.00 4,990,020.00 4,991,194.35 45905BERO INTL BK RECON&DEVELOP AAA Aaa AAA 121512016 10/512018 1.261 2.50,000.00 2,492 625.00 2,498,322.95 880591EQ1 TENN VALLEY AUTHORITY AA+ Aaa AAA 7!2812017 10115/2018 1,363 5,000,000,00 4,995,100.00 5,005,52126 912828RP7 U S TREASURY NOTE AA+ Aaa AAA 3/2712018 10131/2018 1.962 5,000,004.00 4,995,115.00 4,996,50229 79545ORM9 SALLIE MAE BANK6ALT LKE NR NR NR 11/25/2013 11120/2018 2.050 250,000.00 250,000.00 250,000.00 912828A34 U S TREASURY NOTE AA+ Aaa AAA 3/2712018 1113012016 2.012 5,00D,000.00 4,982,225.00 4,984,318.30 686184WJ7 ORIENTALBANK NR NR NR 12116/2015 12/17/2018 1.750 250,000.00 250,000.00 250,000.00 89236TBBO TOYOTA MOTOR CREDIT CORP AA- Aa3 A 911812015 1/1712019 1.875 5,0D0,000.06 4,988,950.00 5,005,901,25 037B33BQ2 APPLE INC AA+ Aal NR 1117/2017 212=19 1.450 1,540,000.00 1,532,349.28 1,542,421.86 30231GAP7 EXXON MOBIL CORPORATION AA+ Aaa NR 3/2972018 31112019 2,304 3,157,000.00 3,141,533.86 3,144,653.47 650035KSO NEW YORK ST URBAN DEV CORP REV AAA Aal AA+ 1211812414 3/1512019 1.980 5,000,000.00 4,983,850.00 5,000,324.36 13063CKL3 CALIFORNIA ST GO UNLTD TXBL AA- Aa3 AA- 1112412014 5/112019 1.900 3,000,000.00 2,995,980.00 3,008,346.27 3133EFD20 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 212312016 512312019 1.266 5,000,000.00 4,947,410.00 4,999,311.97 594918AC8 MICROSOFT CORP AAA Aaa AA+ 9/28/2015 6/112019 1.580 2,500,000.00 2,538,325.00 2.558092.97 45905UF58 INTL BK RECON&DEVELOP NR NR NR 52512018 62812019 2.472 5,000,000.00 4,958,685.06 4,957,550.61 91412GSB2 UNIV OF CALIFORNIA CA REV TXBL AA Aa2 AA 8124/2015 7/1/2019 1.698 5,000,000.00 4,962,400.0D 5,004,710.69 31315PM71 FEDERAL AGRIC MTG CORP NR NR NR 7117/2014 7117/2019 1.813 5,000,000.00 4,964,405.00 4,995,874.44 459058EV1 INTL BK RECON&DEVELOP AAA Aaa AAA 1/28/2016 712612019 1.392 5,0W,000.00 4,935,940.00 4,992,609.10 31315PT01 FARMER MAC NR NR NR 82512014 612312019 1.765 5,000,000.00 4,952,BOO.00 4,990.982.06 459058FQ1 INTL BK RECON&DEVELOP NR Aaa AAA 511612018 9/3012019 2.525 5,000,000.00 4,917,685.00 4,919,252.71 6B3B9XAX3 ORACLE CORP AA- Al A+ 101612015 10/812019 1.845 4,162,000.00 4,138,230.82 4,182,524.03 45905UZJ6 INTL BK RECON&DEVELOP AAA Aaa NR 121212016 10/252019 1.573 5,000,000.00 4,912,855.00 4,982,503.36 3133EEBN9 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 1111212014 111122019 1.800 5,000,600-00 4,954,64D.00 5,000,000.00 9W594AW3 WHITNEY BANKIMS NR NR NR 1252017 1/272020 1.700 250,060.00 250,000.00 250,000.00 02587DXE3 AMERICAN EXPR CENTURION NR NR NR 1!302015 11302020 1.950 250,000.00 250,000.00 250,000.00 8B2BDBEMO TEXAS ST TECH UNIV REV AA+ Aal AA+ 11162015 2/152020 1,790 2,570,000,00 2,548,514.80 2,582,531.71 474D67AK1 JEFFERSON FIN CRED UNION NR NR NR 2272016 2272020 2.400 250,000.DD 250,000.00 250,000.00 91282$,184 U S TREASURY NOTE AA+ Aaa AAA 4/612015 3/31/2020 1.330 5,000,000.00 4,902,735-06 5,003,773.64 13063CSQ4 CALIFORNIA ST GO UNLTD TXBL AA. Aa3 AA- 41292015 4112020 1.680 5,000,000.00 4,918,100.00 5,410,025.96 13063DFZ6 CALIFORNIA ST GO UNLT TXBL AA. AQ AA- 42512018 4112020 2.523 3,000,000.00 2,991,510.00 3,003,883,19 71270GMS2 PEOPLES UNITED BANK NA NR NR NR 411512015 4115/2020 1.800 250,000.00 250,000,D6 250,000.00 3136G2HF7 FEDERAL NAIL MORTGAGE ASSN AA+ Aaa AAA 511912015 5/1912020 1.600 5,000,000.00 4,912,765A0 5,000,000.00 91262$XE5 U S TREASURY NOTE AA+ Aaa AAA 6112015 5/31/2020 1.503 4,000,000.00 3,922,656.00 3,999,760.41 140420RX0 CAPITAL ONE BANK USA NA NR NR NR 6/1012015 6/1012020 2.005 250,000.00 250,000.00 249,514.23 313383HUB FEDERAL HOME LOAN BANK AA- Aaa NR 6152015 6/1212020 1.780 5,000,000.00 4,918,790.00 4,997,206.86 3133834H1 FHLB 1.375 06120 AA+ Aaa NR 72312015 611212020 1,795 5,200,004.00 6,084,701.60 5,159,444.82 8821172X1 TEXAS ST A&M UNIV REV AAA Aaa AAA B11D12015 71120217 1.963 3,000,004.00 2,936,280.00 2,987,856.90 459058FMO INTL BK RECON&DEVELOP AAA Aaa AAA 81232016 81102020 1.140 5,000,000.00 4,843,295.00 4,998,430.94 313DADSS2 FEDERAL HOME LOAN BANK AA+ Aaa NR 4152018 M202D 2.419 5,000,000.00 4,980,295.00 5,002,163.84 05580ACW2 BMW BANK NORTH AMERICA NR NR NR 9/182015 91182020 2.200 250,000.00 250,000.00 250,000,00 2DO33AMR4 COMENITY CAPITAL BANK NR NR NR 9212015 92112020 2.250 250,000.00 250,000.00 250,000.00 49305SYWO KEY BANK NA NR NR NR 9/2712017 926/2020 1.850 250,000.6D 250,000.00 250,000.DD 3136GIH28 FANNIEMAE AA+ Aaa AAA 213/2017 92812020 1.677 5,000,000.00 4,904,540.00 5,002,454.75 912828222 U S TREASURY NOTE AA+ Aaa AAA 101312017 10/152020 1.712 5,000,000.00 4,895,510.00 4,990,312.50 254672VT2 DISCOVER BANK NR NR NR 10212015 101212020 2.2DD 250,000.00 250,000.00 250000.00 14042RBL4 CAPITAL ONE NA NR NR NR 11/132015 101282020 2.277 250,000.00 250,000.00 249,853.33 59491SBOB MICROSOFT CORP AAA Aaa AA+ 8!2212016 11/312020 1.382 5,00,000.00 4,919,440.00 5,066,836.33 94966TWG8 WELLS FARGO BANK NA NR NR NR 1213/2015 121312020 1.500 250,000.00 250,000.00 250,000.00 29266NX93 ENERBANK USA NR NR NR 1262015 1/2812021 1.903 250,000-00 250,1700.00 249,677.75 89677DET9 TRISTATE CAPITAL BANK NR NR NR 113112018 2!12021 2.350 250,000.00 250,000.00 250,000.00 313DA7CV5 FEDERAL HOME LOAN BANK AA- Aaa NR 4172Di6 2/182021 1.315 5,006,000.00 4,841,220.00 5,007,598.72 4581XOCS5 INTER-AMERICAN DEVEL 8K AAA Aaa AAA 111152016 3/1512021 1.574 5,000,000.00 4,888,230.00 5,039,178.53 13063CP87 CALIFORNIA ST GO UNLTD AA- Aa3 AA- 61132016 4112021 1.430 5,000,000.00 4,819,550.00 5,009,223.96 3134GBY29 FREDDIE MAC AA+ NR AAA 4282016 4/28/2021 1.375 3,000,000.00 2,936,068.00 2,997,457.50 459058FOO INTL BK RECON&DEV STEP-UP NR NR NR 42812016 4/28/2021 1.500 3,000,000.00 2,919,900.00 3,000,000.00 02007GCP6 ALLY BANK NR NR NR 511012018 5/1012021 2.850 250,000.00 250,000,00 250,000,00 128829AC2 CALDWELL BK&TRUST CO NR NR NR 511312016 5/13/2021 1.4D6 250,000.00 250,000.00 250,000.00 91412OF59 UNIV OF CALIFORNIA CA REV TXBL AA Aa2 AA 8152016 511512021 1.417 5,000,000.00 4,856,200.00 5,062,373.50 459058FH1 INTL SK RECON&DEVELOP AAA Aaa AAA 6/1312016 52412021 1.412 5,000,000.00 4,812,085.00 4,994,817.21 3138G3MV4 FEDERAL NATL MORTGAGE ASSN AA+ Aaa AAA 5/2512016 52512021 1.375 5,000,000.00 4,803,575.00 5,000,000.00 313DAD5K4 FEDERAL HOME LOAN BANK AA+ Aaa NR 12/262017 622/2021 2.197 5,00,000.00 4,918,940.00 4,997,569.78 27113PBED EAST BOSTON SAVINGS BANK NR NR NR 6/232016 62312021 1.500 250,000.00 250,000.00 250,000.00 91282BS27 U S TREASURY NOTE AA+ Aaa AAA 12/152017 613012021 2.027 5,000,000.00 4,785,155.00 4,669,992.57 5 BUTTE COUNTY TREASURER'S INVESTMENT REPORT MANAGED PORTFOLIO-DETAILS OF SECURITIES HELI] June 30,2018 Page 2 of 2 Credit Rating Purchase Maturity Yield to Securl Descrinticn S&P Mood s Fitch Date Date Maturity(%I Par Value Fair Value Cost Carried" 3133EGKA2 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 716!2016 716/2021 1.500 5,000,000.00 4,811,145.00 5,000,000.00 313OA8QS5 FEDERAL HOME LOAN BANK AA+ Aaa NR 771412016 7114!2021 1.201 5,000,000.00 4,785,765.00 4,988,827.11 584036452 MEDALLION BANK UTAH NR NR NR 7!2812016 712612021 '1.400 250,000.00 250.000.00 250,000.00 88413QBN7 THIRD FED SAV&LN CLEVLND NR NR NR 7/2812017 7/2812021 2.OW 250,000.00 250,000.00 250,003.00 95960NJNB WESTERN STATE BANK NR NR NR 712912016 7/29)2021 1.400 250,000.00 250.000.00 250,004.00 594918BP8 MICROSOFT CORP AAA Aaa AA+ 8/1912016 8/8/2021 1,541 5,000,000,00 4,796,135.00 5,001,328.62 74267GVM6 PRIVATEBANK&TRUST CO NR NR NR 8/3012016 8/3012021 1.500 250,000.00 250,000.00 250,000.00 08173QBR6 BENEFICIAL BANK NR NR NR 9116/2016 9/1312021 1.500 250,000,00 250,000.00 250,000.00 459058FP3 INTL BK RECON&DEVELOP AAA Aaa AAA 511912017 9/2012021 1.899 5,150,000.00 4,926,747.50 5,066,948,48 87165FNC4 SYCHRONY BANK NR NR NR 101212016 10/212021 1.700 250,000.00 250,000.00 250,000.00 912828T67 U S TREASURY NOTE AA+ Aaa AAA I V2712017 10!31!2021 1.955 5,000,000,00 4,777,150.00 4,887,373.22 3130AA2F4 FEDERAL HOME LOAN BANK AA- Aaa NR 51!2312016 11!2312021 1.700 5,000,000.00 4,827,540.00 5,000,000.00 45906UC28 INTL BK RECON&DEVELOP NR NR NR 12/2812016 12128!2021 2.050 5,000,000.00 4,815,500.00 5,000,000.00 084601GS6 BERKSHIRE BKIPITTSFIELD NR NR NR 121302016 121302021 2.200 250,000.00 25D,000.00 250,000.00 469058FY4 INTL 6K RECON&DEVELOP NR Aaa AAA 311012017 12612022 2.165 5,000,000.00 4,662,240.00 4,972,155.89 3133EFZL4 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 62812018 211612022 2.831 4,560,000.00 4,429,702.56 4,43D,292.58 3133EHAK9 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 2232017 2/2312022 2.000 6,000,000.00 4,872,465.00 5,000,000.00 940727AH3 WASHINGTONFIRST BANKSHAR NR NR NR 2!232017 223/2022 2.050 250,000.00 250,000.00 250,000.00 256650AV7 DOLLAR BANK FSB PA NR NR NR 3182017 3162022 2.050 250,000.00 250,000.00 250,000.00 574193NC8 MARYLAND ST GOUNLT AAA Aaa AAA 322/2017 311512022 2.250 5,190,000.00 5,092,116.60 5,190,000.00 96878BQS0 ZBNA NR NR NR 4132017 4112022 2,102 250,000.00 250,000.00 249,098.68 3132XOSKS FARMER MAC NR NR NR 5152017 5152022 1.975 5,000,000.00 4,853,790.00 5,000,000.00 58740X269 MERCANTILE BANK OF MI NR NR NR 51102017 5110/2022 2.100 250,000.00 250,000.00 250,000.00 92834CCO2 VISIONSANK OF IOWA NR NR NR 111282017 513112022 2.150 250,000.00 280,000.00 250,000.00 912828XW5 U$TREASURY NOTE AA+ Aaa AAA 7212017 6/302022 1.810 5,000,OWDO 4,821,485.00 4,988,625.35 06740KKOB BARCLAYS BANKIDELAWARE NR NR NR 7112!2017 7/12/2022 2.200 250,000,00 250,000.00 250,000.00 912828XQB U S TREASURY NOTE AA+ Aaa AAA 71312017 713112022 1.823 5,000,000.00 4,864,845.00 5,034,447.73 010878ANG ALAMEDA CNTY CA GO UNLTD TXBL AAA Aaa AAA 3292018 8112022 2.830 2,000,000.00 2,075,440.00 2,089,254.03 319141HG5 FIRST BANK OF HIGHLAND NR NR NR 8!162017 81162022 2.200 250,000.00 250,000.00 250.000,00 87270LAJ2 TIAA FSB NR NR NR 811612017 81162022 2.200 250,000.00 250,000.00 250,000.00 912828124 U S TREASURY NOTE AA+ Asa AAA 1011WOW 8/312022 1.935 5,000,000,00 4,836,625.00 4,988,016.17 4581XOCZ9 INTER-AMERICAN OEV BK NR Aaa AAA 9/142017 91142022 1.803 5,000,000.00 4,788,640.00 4,989,493.06 3361ORRF2 FIRST PREMIER BANK NR NR NR 911512017 91152022 2.000 250,000.00 250,000.00 250,000.00 912B282W9 U S TREASURY NOTE AA+ Aaa AAA 101612017 91302022 1.930 5,000,000.00 4,834,160.00 4,986,871.65 66612ABXS NORTHFIELDBANK NR NR NR 102512017 1012512022 2.2D3 250.000.00 250.000,00 249,460.23 33708UCK3 FIRST STATE COMMUNITY BK NR NR NR 101272017 10272022 2.150 250,000.00 250,000.00 250,000.00 912B28M49 U S TREASURY NOTE AA+ Aaa AAA 101312017 101312022 2.037 5,000,000.00 4,830,665.00 4,966,813.13 3134GB6A5 FEDERAL HOME LOAN MTG CORP AA+ Aaa AAA 12/282017 12282022 2.440 5,000,000.00 4,896,700.00 5,000,000.00 58733AET2 MERCANTIL BANK NA NR NR NR 121292017 121292022 2.650 250,000.00 250,000.00 2501000.00 61747MF63 MORGAN STANLEY BANK NA NR NR NR 111112018 11112023 2.650 250.000.00 250,000.00 250,000.00 4581XODA3 INTER-AMERICAN DEVEL SK AAA Aaa NR 4162018 1/182023 2.749 5,000,000.00 4,923,575.00 4,947,192.01 3133EJBY4 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 21712018 2172023 2.780 5,000,000.00 4,962,780.00 5,000,000.00 3130ADLH3 FHLBSTEP-UP AA+ Aaa NR 22812018 22&2023 2.OW 5,0130,00D.00 4,996,870.00 5,000,000.00 080515CM9 BELMONT SAVINGS BANK NR NR NR 311412018 31142023 2.854 250,000.00 250,000.00 249,412.31 3134GSEW5 FHLMCSTEP-UPAA+ Aaa AAA 4123/2018 31142023 2.300 5,075,000.00 5,064,438.93 5,060,362.90 OB4670BRB BERKSHIRE HATHAWAY INC AA Aa2 A+ 32012018 3/152023 3.101 1,000,000.00 978,002.00 984,796.47 084670BRB BERKSHIRE HATHAWAY INC AA Aa2 A+ 4!1912018 31152023 3.123 1,00,000.00 978,002.00 983,808.20 3130ADT51 FEDERAL HOME LOAN BANK AA+ Aaa NR 32912018 3292623 3.OW 5,000,000.00 4,968,660.00 5,000,000.00 3133EJKK4 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 411812018 41102023 3.000 5,000,000.00 4,976.815.00 4,993,333.12 17312QJ26 CITIBANKNA NR NR NR 4/1112018 4/152023 2,90 250,000.00 250,OGD.00 250,000.00 037833AK6 APPLE INC AA+ Aat NR 5172018 5132023 3.180 5,000,000.00 4,813,405.00 4,826,721.44 912828869 U S TREASURY NOTE AA+ Aaa AAA 627/2018 513112023 2.732 5,000,0WOO 4,746,875.00 4,747,063.65 "Effective Duration:2.224 7.907 366,104,000.00 358,242,608.96 364,166,627.00 Source: U.S.Bank Safekeeping Values may differ from Treasurers Cost Carried due to accretien method vacation. Bond Edge Portfolio-Analysis Notes: Federal Agricultural Mortgage Corporation sacurilias are issued by a U.S.Government agency and are not rated. Nagauame ws are not rano,our are ruin msureo. 6 rr �• Treasurer—Tax Collector Peggy Moak,Treasurer-Tax Collector Treasury Division . 25 County Center Drive, Suite 125 T: 530.552.3730 buttecounty.net/ttc Oroville, California 95965-3384 I F: 530.538.7648 TREASURER-TAX COLLECTOR July 16, 2018 Butte County Board of Supervisors Butte County Chief Administrative Officer Investment Pool Oversight Committee The attached statements showing investment transactions for the month ending June 30, 2018 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, 2017 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 http://www.buttecounty.net/ttr.. If you have any questions regarding investment reporting, please feel free to contact me, or Lisa Lam, at 552-3731. Yours truly, 4 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 Fantle Bank,Trustee 2004 Pension Obligation Bonds Transacflon ActivIty Series A Series B I Total Cash With Transactl(n&Month End Date XXXXJ106 XXXXII091 XXXX1140 XXXX1141 I XXXX1142 XXXX1143 I XXXX1301 XX)(X1305 XXXX1307 I Flacal A ent 1 213112 01 7 Falr Value 1,202,604.97 2,671.63 11.62 84.79 5,214.02 11.60 30,094.39 994,853.38 80.91 2,235,615.71 Interest Earned 1.069.57 5.93 0.01 0.08 3.52 2.83 908.73 0.07 1 990,74 Wire Transfer From Butte County 0.00 Transfer To XXXX1307 0.00 Transfer To XXXX1301 (31,722.88) 31.722.88 Transfer To XXXX1140 0.00 Transfer To XXXX1141 0.00 Transfer To X)=1142 0.00 Transfer To XXXX1143 1 0.00 Principal Peal 10 Bondholder 0.00 Interest Pad to Bondholder (30 091.70) (30,091.70 Transfer from XXXX1106 9.00 Transfer from XXXX1305 31,722.88 31.722.88 113112018 Falr Value 1,203,674,64 2,677.56 11.63 94.87 5,217.54 0.00 31,728.40 964,039.23 80.96 2,207,514.75 Interest Earned 1,183.90 1.00 0.01 8.08 3.72 1.913 9713.37 0.013 2,169.14 Wire Transfer From Suite County 0.00 Transfer To XXXX7307 1 0.00 Transfer To XXXX7301 (29,723,37) (29,723.37) Transfer To XXXX1140 0.00 Transfer To XXXX1141 0.00 Transfer To XXXX7142 0.00 Transfer To XXXX1143 0.00 Principal Paid to Bondholder 0.00 Interest Paid to Bondholder (31.728.4C) (31,728,40) Transfer from XXXX1166 a00 Transfer from XXXX7305 29,723.37 29.723.37 212812018 Fair Value 1,204,858.44 2,678.56 11.64 84.95 5,221.26 0.00 29,726.35 936,294.23 81.06 2,177,955.49 Interest Earned 1,110,07 0.94 0.01 0.0a 3.72 3.02 886.09 0.07 2,004.00 Wire Transfer From Butte County 0.00 Transfer To XXXX1307 0.00 Transfer To XXXX1301 (35.505.94) (35,585.94) Transfer To XXXX1140 0.00 Transfer To XXXXi 141 0.00 Transfer To XXXX1142 0.00 Transfer To XXXX1143 0.00 Principal Paid to Bondholder 0.40 Interest Paid to Bondholder (29,723.37) (29.723-37) Translef from XXXX1106 0.00 Transfer from XXXX1305 35,585.94 35,585.94 3131@018 Fair Value 1,205,968.51 2,679.50 11.65 85.03 5,224.98 0.00 35,50.94 900,694.38 81.13 2,950,236.12 Interest Earned 1.388.84 7.35 0.01 0.10 4.64 4.39 1,073.76 0.09 2,479.18 Wire Transfer From Butte County 0.00 Transfer To XXXX1307 0.00 Transfer To XXXX1301 (35,911,30) 35.811 30 Transfer To XXXX1140 0.00 Transfer To XXXX1141 0.00 Transfer To XXXX1142 0,013 Transfer To XXXX1143 0.01) Principal Pald to Bondholder 0.00 Interest Paid to Bondholder (35,590.94) 35.590.94 Transfer from XXXXtt06 0.00 Transfer from XXXX1305 35,911.30 35,911.30 03012016 Falr Value 1,207,357.35 2,686.85 11.66 85.13 5,229.62 0.00 35,915.69 865,766.84 81.22 2,117,124.36 Interest Earned 1,492.44 1.26 0.01 0.11 4.93 17.91 1.098.12 0.10 2,614.88 Wire Transfer From Butte County 0.00 Transfer To XXXX1307 (509,918.60) 509.918.88 Transfer To XXXK1301 (38.719.00) (38.719.0n) Transfer To XXXX1140 0.00 Transfer To XXXX1141 (826,723.80) 826.723.80 Transfer To XXXX1142 0.00 Transfer To XXXX1143 (370,000,00) (370,000,00) Pnnc{pal Paid to Bondholder 0.00 Interest Paid to Bondholder (35,911.30) (35.911.30 Transfer from XXXX1106 826,723.80 370,000.00 1,196,723.80 Transfer from XXXX1305 38,719.00 1 509,918.68 648,637.68 513112018 Fair Value 12,126.99 2,688.11 11.67 826,809.04 5,234.55 370,900.00 38,741.30 318,217.29 510.000.00 2,083,827.94 Interest Earned 1,462.88 1.37 0.02 109.46 5.50 13.04 5.15 1.089.96 6755 2,754.93 Wire Transfer From Butte Count 0.00 Transfer To XXXX1307 0.00 Transfer To XXXX1301 0.00 Transfer To XXXX1106 (13.04) (13,04) Transfer To X)W(1140 0.00 Transfer To XXXXl 141 0100 Transfer TO XXXX1142 (13.601.91) 13,601.91 Transfer To XXXX7143 0.00 Pnncipal Paid to Bondholder (510.000.00) (510.000.00) Interest Paid to Bondholder (826,723.80) (370,000.00) (38.741.39) 0,235,465.10 Transfer from XXXX1106 13.601.91 13,601.91 Transfer from XXXX7143 1 13.04 13.04 Transfer from XXXXt305 39.063.35 (39.06335 6.00 613012018 Felr Value 0.00 2,689.48 11.68 194.70 18,841,96 0.00 39,068.50 280,243.89 67.55 341,117.77 rauruy:]i WelhLudo Bonk Statemenlo.319�ISe ia�nty/Wm�nhlrlb�a�rKe 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 5/31/2018 $ 130,624.73 Deposits/Additions 6112118 $ 5,847.88 6118118 $ 82,525.48 6129118 $ 92,084.75 ACH and Electronic Payments/Subtractions $ (42,346.54) Withdrawals/Subtractions Disbursements Checks Paid $ (94,366.76) Maintenance Pee 6120118 $ (86.82) Ending Balance 6/30/2018 $ 174,282.72 Source: Umpqua Bank Statement I-IAIV V\CrWCL1 1V1V11LILly OLCLLl,111V11L ' "C7" ' - Local Agency Investment Fund P.O.Box 942809 www.treasurer.ca.gov/nmia-laif/laiEasi3 Sacramento,CA 94209-0001 July 02,2018 (916)653-3001 -'. BU IT COUNTY CHIEF DEPUTY TREASURER PMIA Average Monthly Yields 25 COUNTY CENTER DR]VE OROVILL E,CA 95965-3384 Account Number: 1 fun'r Sic De illitions .lune 2018 Statement Effective Transaction Tran Confirm Date Date Type Number Authorized Callcr Amount 6/1/2018 0/1/2018 RD 1571991 LORIS EDWARDS 1,000,000.00 6/8/2018 6/8/2018 RW 1572408 LISA LAM -3,000,000.00 6/14/2018 6/14/2018 RD 1572784 COLE`I"I'E WORSHAM 3,500,000.00 6/20/2018 6/20/2018 RW 1573127 COLETTE WORSHAM -2,500,000.00 6/22/2018 6/22/2018 RD 1573333 COLE"TTE WORSHAM 5,000,000.00 6/16/2018 6/26/2018 RW 1573529 LISA LAM -3,000,000.00 Account Summary Total Deposit, 9,500,000.00 Beginning Balance: 8,127,069.05 'Fatal Withdrawal: .8,500,000.00 Ending Balance: 9,127,069.05 https:Hlaifins.treasurer.ca.gov/Regulat-Statei,nent,aspx 7/2/2018 LAIF Regular Monthly Statement Page 1 of 1 Focal Agency Investment Fund 1'.U.Box 942809 Sacramento,CA 94209-0001 tyrvw.treasurer.ca.eo_v_/11mia-Ily 02,12asp 018 (916)653-3001( duly 02,201$ 1301713 COMMUNITY COLLEGI?DISTRICT BUTTE COUNTY TRI ASURER PMMA Average Monthly Yields 25 COUNTY CENTER DRIVE,SUITE 125 OROVILLE,CA 95965-3384 Account Nmnber: Cr.n1- yjjq UCI nllions June 2018 Slatenlent Effective "Transaction Tran Confirm Date Date 'Type Number Authorized Caller Amount 6/1/2018 6/1/2018 RD 1571988 LORIF LDWAIO)S 3,000,000.00 6/7/2018 6/7/2018 RW 1572303 LISA LAM -2,000,000.00 6/20/2018 6/20/2018 RW 1573122 COLI I'TE WORSI]AM 2,500,000.00 6/22/2018 0)22!2018 10D 1573327 COLI FTE WORSHAM 5,000,000.00 Account Summary Total Deposit: 8,000,000.00 Beginning Balance: 45,088,378.64 "Total Withdrawal: -4,500,000.00 Ending Balance: 48,588,378.64 https:Hlaifms.treasurer.ca.gov/Regtilai-Statement.aspx 7/2/2018 LAID' Regular Monthly Statement Page 1 of I 1,ocal Agency Investment punct P.U.]lox 942809 www.treasurer.ca.eovinmia-IRifllait:asn Sacramento,CA 94209-0001 July 02,2018 (916)653-3001 4 PARADISE UNIFfED SCHOOL DISTRICT 13UTTE COUNTY TREASURER PMIA Average Monthly_Yields 25 COUNTY CENTHR DRIVE,SUITH 125 OROVIL,LL"„CA 95965 Account Number: 'I_rani r Definitions Junc 2018 Slaipmenl Effective Transaction Tran Confirm Dale Date Type Number Authorized Caller Amount 6/6/2018 6/6/2018 RW 1572237 C01j"I"IT WORSHAM -2,500,000.00 6/15/2018 6/15/2018 RD 1572907 COL f'TE WORSHAM 2,000,000.00 6/21/2018 6/21/2018 RW 1573228 COLE TTP WORSHAM -3,000,000.00 6/25/2018 6/25/2018 It 1) [573449 LISA LAM 5,000,000.00 6/29/2018 6/29/2018 RW 1573904 LISA LAM -2,500,000.00 Account Summary Total Dcposit: 7,000,000.00 Beginning Balance: 10,412,078.14 Total Withdrawal: -8,000,000.00 Ending Balance: 9,412,078.14 https:Hlaifms.treasurer.ca.gov/RegiilarStatement.aspx 7/2/2018 LAII~ Regular Monthly Statement Page 1 of I 1,oca1 Agency Investment Dune! P.O.Box 942809 Sacramento,CA 94209-0001 w+vw.trcasurer.ca. ovl min-lly 02,20 ► {916)653-3001 } July 42,2018 OROVIL.I.I UNION 11101.1 SC1aooL€ ISTRICr 13U'1`1'13 COUNTY TRL•ASURI31t I'MIA Average MuntLly Vidds 25 COUNTY CENTER DRIVE,SUITE; 125 OROVII..LX,CA 95965-3384 AccoumNumber: Tran Type Definitims .lune 2018 Statement Effective Transaction'I'ran Confirm Date Date 'Type Number Authorized Caller Amount 6/8/2018 6/8/2018 RW 1572409 LISA LAM -2,000,000.00 6/25/2018 6/25/2018 RD €573450 LISA LAM 5,000,000.00 Account Summary Total Deposit• 5,000,000.00 Beginning Balance: 8,704,290.54 "Total Withdrawal: -2,000,000.00 Boding Balance: 11,704,290.54 https://Iaiflns.treasurer.ca.gov/RegularStatenient.aspx 7/2/2018 LAIF Regular Monthly Statement Page 1 of 1 Local Agency Investment Pund 11.0.Box 942809 wivw.treasurer.ca.Lov/poria-laif/iaif.asn Sacramento,CA 94209-0001 July 02,2018 (916)653-3001 ty: CHICO UNIFIP.13 SCHOOL J)IS'J'IUCT 13U'r7'1?COUNTY TREASURI`sR I'N11A Average Monthly Fields 25 COUNTY C I:N'1'1 R OJOVE,SUIT)"' 125 OROVJLLL,CA 95965-3384 Account Number: De1'iniiiotts June 2018 Stnicment Effective Transaction Tran Confirm Dale Date Type Number Authorized Caller Amount 6/7/2018 6/7!2018 RW 1572302 LISA LAM -3,000,000.00 6/13/2019 6/13/2018 RW 1572693 COLI n'IL WORSHAM -4,000,000.00 Account Summary Total Deposit: 0.00 Beginning Balance: 42,709,728.72 "Total Withdrawal: -7,000,000.00 Ending Balance: 35,709,728.72 https://laifii-ks,treasurer.ca.gov/RegularStatenient.aspx 7/2/2018 LAZE Regular Monthly Statement Page 1 ot'1 Local Agency Investment Fund P.O.Box 942809 Sacramento,CA 94209-0002 tivww.treasurer.ca.iovlumia-lly 02, IRJERS (916)653-30011: July 02,2018 BUTTE COUNTY OI FWT OFEDUCATION BU'T'TE:COUNTY"TREASURE,It fMIA Average Monthly Yields 25 COUNTY CENTER DRIVE,SUITE 125 OROVIL1.13,CA 95965-3384 Account Dumber: Trmi'Tvnc Delinidoos lunC 2018 Statwnonl Effective Transaction Tran Confirm Date Date 'Type Number Authorized Caller Amount 6/112018 6/1/2018 RD 1571990 LORIS I DWARDS 2,000,000.01) 6/6/2018 6/6/2018 RW 1572238 COLE VIT WORSHAM -2,500,000.0f) Account Summar TO(al Deposit: 2,000,000.00 Beginning Balance: 8,695,151.25 Total Withdrawal: -2,500,000.00 Ending Balance: 8,195,151.25 littps://Iaifms.treasurer.ca.gov/RegularStateinent.aspx 7/2/2018 CalTRUST clo Gemini Fund Services LLC PO Box 541150 Investment Account Summary Omaha, SEE 68154-9150 06/01/2018 through 06/30/2018 CaITRUST www.caltrust.org Email: Ca1TRUSTSupport@thegeminicompanies.com Fax: 402-963-9094 Phone: 833-CALTRUST(225-8787) SUMMARY OF INVESTMENTS Account Total Shares Net Asset Value Value on Average Cost cumulative Fund Number Owned per Share on Jun 301$) Amount($) Unrealized Jun 30 ($) Ga€n1(Loss)($) COUNTY OF BUTTE - CaITRUST Shorl Term Fund 464.827 10.01 4,652.92 4,657.41 (4.49) Portfolios Total value as of 0613012018 4,652.92 DETAIL OF TRANSACTION ACTIVITY Activity Activity Amount Amount Balance Price per Average Realized Description Date ($) In Shares in Shares Share($) Balance($) Cost Amt($) Gain/(Loss)($) 00TRU57 Short Term Fund ,. CQEJNTY OF F3U7TE Account tVumhei:- _._ Beginning Balance 06!0112018 464.082 10.01 4,645.46 Accrual Income Div Reinvestment 0612912018 7.46 0.745 464.827 10.01 4,652.92 0.00 0.00 Unrealized Gainf(Loss) 0.00 Closing Balance as of Jun 30 464.827 10.01 4,652.92 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. 0000015-0000030 PDFT 717959 Page 1 of 2 co CO cc OC: O 00 O N r m M f o C1!.ci? < LL1OD CD .:ry.. D V y I M 00 M Ln LM + Ry o0 - S a 3 a � u ° O COao 0o o; ai o 0 o p 0) 0�0 N W O O 1 0 co co N Ln 4 a q3> 3 m 'o 2 Y 'd Qi N G 7 N 7 VI rL `F' ami a m .� N LL CD \ 2 co 2 0 0 \ § V4 / Ch } o $ � m \ ; � $ § 0 2 \ k © b / - R \ § 2 R \ t / \ 2 �\ / ( R $ / i S G m $ kro )kQ \ / \ � @ \ � / ¢ — � � 2 § 2 B ] § � 22 c � 3 \ § cc ■ '_ cnr- .2 Q $ § § « z < gG8 2 e Ii Ln d Q \ kin � \ / / = 2 m C-4 \ ƒ k \ J / _ Cl) § k } CL) 7 2 0 E ©ChR 0 % \ 0) r \ \ R 00 \ E � / r c 2 E @ a \� .2r- � ° " Ln o k \ k \ u «� ■ E / 7 (A � ■ 6' § o \ . Aj@ 2 § c § 2 B A §� � § § \ yo . � \ f 2 m a 0 � 2 § O 2 e ' ■ • CO■ _ • 2 < 2 2 ; » 0 ■ CL c § 4 � � a , w M wLL ' :/ \m CL CL 0 J 2 u u J ICL FIVE STAR BANK County of Butte Date 6/29/18 P� 25 County Center Drive, suite 125 Account Num er Oroville CA 95965-3384 Enclosures Use Five Star Bank's mobile banking app on your smart device to check your balance or transaction history,deposit checks,activate your debit card,and more! Call(916)626-5012 to enroll. Public Funds MMANumber of Enclosures 0 Account Number Statement Dates 6/01/18 thru 6/30/18 Previous Balance 5,066, Days in the statement period 30 Deposits/Credits .00 Average Ledger 5,066,889 Checks/Debits .00 Average collected 5,066,889 Electronic DR .00 service charge .00 Interest Earned 7,222.45 Interest Paid 7222.45 Annual Percentage Yield Earned 1.75% Endin Balance 5,074:111.86 2018 .Interest Paid 26 832.83 e • ® o ae ® m .,_:<:. -•-",5�; 6/30 INTEREST PAID 30 DAYS 7,222.45 :.,.-,,�:�."A�',, !•q-;,ri,'�,5='.�3-:�:l is=,4:1i"l�:i.a.:.;, r,�t.T ..x.^��. Y..6:f;ii€�c,.»�'ar..k,?:., r5- .n4.;,,.- ..,t,.;c. 5'.--.r .t.�:.y.�>,wy��'. .,.�:1��.�`.SL.b`'3.,r/,c. 6/01 5,066,889,41 ._ 6 30 5,074,111.86 --------------- 5/31 e; a,. ,i ,.7.�. i 1�,� 5/31 1.66% 6/08 1.76% co (DLoomCD 0 o CJ o o Ln m [V 16 ao � V Noc DI CC) to ro o z 0 q: Ig0!c Ln rl. N m M co a.. r r N O d a) O w 'o z > N LLI Q 0000to Ln LLJco �z mrao0 L d N add -� CD p YLU CV m V CO00o - ami 1- LL LL p U .r L6:f O N CV Cl)x¢C) v Cl) U) C%4 LLn' • Lv¢ co o L IL I i6m v ADo M 'o a oQ N Co W L e W P CL N T T LL o E L rn U U U O N m ccnQQ2U d o 0 0 0 0 0 0 0 0 0 U) E voodoo Io 0 0 0 0 o LLoo 000 } CD CD ci CD CD CD 000 C O CO O C? o OO Ln C7 m oa nW) W) ` Ili a oo co Cli cn Oooi F;- fgco h v CD co L yJ o0o CDC)OOwoo o00oOo00 oOOO N C O O O o O N o 0 00 0 0 Cl 0 0 0 0 0 0 0 0 0 0 0 P7 Q � 00000c0000000000c0a000a0 r+ O LO w o 0 w E o H a N co Ci Oct M uy00000 � o (= 000 L Qm o O O C7 C3 C7 C7 0 l6 OO C7 C70 6 0 0 0 0 (lJ0000 0 L 0 0 0 0 C7 R00Ln0 m aoc MU) Lo Ln q ap CD cl omtitom • Y r• �2 co co co �k W ca m J Q D g Q v L) y }� m N c m _ E 7 rna a 0aoi E v 0 U 2 a)N � N a3i 7 � a � af� a� ? '0 EQEoto m - m - 0 w Q -p (A 0, m C t w a •�' L' ayi ®m 2 - o o a a c Y aa) aoi o d ami N o s `o Gs tfli � ma� t �' .� o � wmwaa > > � n3vyN Q () r m � OQ N ca m "S" m m d? w' =� m m tc m m co is o 0 o m L o fA o 0 HELrlp) C) (L c c cg0aa � aac� minUU z Ua>- � zc� EE z_ z z 0 a a Q 0 N C� o 0 N is a rn C, > rn vi h_ N O L (*] M Cl) O N O O a O C rr p t Q N a ♦t o `o C1 rn o LL co ui o M r� M roo 0 CD 0 CC) qt _ n C m O a D � CD0 LO O SU o O O O O O (h0 O M 4 Rr d a r., In �a M W Q' Q W z N �. C U T 7 o O w .. U v U E E N U E°- to =3 Vr z z Z c c G 0 o J Q Q 2 0 m m 0 O O O v0 to (n a 0 M CO a W v O 0 0 O (C7 ], 0 00 co a a p O 6 ca o 6 6 O O of ri o O NO CO (O LS) CC) uo 0 0 (D Ch V) O V) co M h h N 0 V' C(7 co It N O (�7 Q � r N L6 (Yi co V CD N r V) LO COD (D � O f� (0 O )f1 .�.r co O N (D O C) co U` �O�(( M Z) Lo D `1 W (0 N Q T In w U3 0m- co N co co LO co (1)Q M N [n U •7 a) co co M n r- M a r Ca O N V 0 M M N N (D O co N_ m LO cl (/I LO m r M M r ((D N M N m M O LL w Q O O Z O O N d1 O m u CD IL orn 0 0 0 Lo 0 a a a a Co co W a r v- M r N r N N N N T T w' N N N N N N 0 y CD 0 0 o O o o a a 0 0 a 0 •, N N N N N N N N- C, N N N N N N M O O w N_ O N C) u7 O u7 0 1� 0 O N 0 r] tt7 O m 0 co V id N NCp CqN a? CD cl0 r-: 0 cq (p qto � N Nrn OCp ')? 0 dip ON v N Q art V' O � r ra r0 r0 r0 r0 rr NO CVO r0 rp Nr CV r N N H � H � U Q Of 0 U N zH Q — Ye Q m � O z0 U) 0 C° 0 ¢ 0 m 00 W z 0G as Z a ma Z Za W w Z a ¢ 0 Z0 0 z z n a0 0 Qn z 06 O ON � w m0 m0 N W W 2LU Z0 a0 W � 0 r Z LL W N UIX 0W W W O 0 Wa' W W QW ¢ W Z W a' ry 0 � N CO (0j Q Q Q Q n = 0 U ~ U m Q U Q O .- O ¢ n FW„ W W U2 uo f a U) LL J r Q oIt C's lLU wa- ii a LL Lu 0 Y m a m () ' -CD 0� �i)I fY Cl OC m ❑ r Z) OU D W x ❑ N C1QQS LY ~ N oJE] WO C7 LU © � U) �i U U V LL LL CD U(D U co O U UU U LL uj Lu 00 W U D � Z U LL j � N 2 2 W V N N (D N 4) N N N 0) N 01 d Q C C C C C C C C C G C C m i.: N E co a 0 co co en co O O to O (D 0 (D M M CO r co m co 0 CO co CO co O E r M — 0 r CD r � r 0 r V r V r a) r M r � r N r 0 r CD C'6 =3 O N 0 (m O m ON ar- as 007 as a Of+ a M Om coOal(7 N m N O N N co N � N O N O N r N 0 N N h N 10 N N N (Z� Z � yNC) NC) ,no u'� o � Q ; CD N m L ti hm co CD U U W V ~ ~ r N r r co r ~ r r ~ N ^ N N N N N N N N N N Q Q � F 0 ti n � 0 (m� o � 01- o1- CD � oti or occo o n ora') C) c* occ03 o # c I 7 > § k f § \ k � 7 § 7 § ± # m C� LO\ g - 5 D < { Cl) \ Cl) � m a 2 LL § 2 E° k § \ � ta) I GL 2 ¥ # § 2 / \ a ' R $ oS o \ 2 0 �2 04 ) § ) § § ) q % R � � v � « @ 2 � § o E E @ § S < E § \ 7 e < o 0 } j j < g < e k ) . � q « °k < LL ua q ) U ; 22 e 'o w ƒ o ± d Z- 8 w 30 _ « § � D / # \ } \ \ \ 2 + i � CO \ \ a \ CD _ _ § 1:3 § \ < < k ) kk § / kk