Loading...
HomeMy WebLinkAboutInvestment Report & Transaction Reporting for 07-31-15 Sweeney, Kathleen From: Lam, Lisa Sent: Friday, August 14, 2.015 11:13 AM To: Liu, Annie-, Gullickson, Caroll; Childs, Heather; Christy Patterson, Butte County Schools JPA; Worsham, Colette; Houser, David; Heather Naylor, Gridley Unified School District; Cook, Holly; Sweeney, Kathleen;; Kevin Bultema, Chico Unified School Disthct;, Honea, Lary; Lisa Anderson, TOC Member(BCOE rep)- Lam, Lisa; Mark Milburn, TOC Member; Jessee, Meegan; 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; Wahi, Larry; Akins, Susan; Peterson,, Susan-, Susan Watts, TOC Member (OUHSD rep); Borzage, Susie-, Tad Alexander, Asst Superintendent of Admin Svcs, BCOE-1 Tim Taylor, Butte County Superintendent of Schools; Bienn, Tina; Trevor Stewart, Butte-Glenn Community College Subject" Investment Report and Transaction Reporting for July 31, 2015 Attachments: July 31, 2015 Treasurer's Investment Report,pdf; Transaction Reporting July 31, 2015 _Redacted.pdf Greetings! The Treasurer's Investment Report for the month ending July 31, 2015 is attached, for your reference. Additionally, the information provided in the attached "July 31, 2015 Transaction Reporting" 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 538-7443. Thanks, LISA LAM AssiSTANT TREASURER-TAX COLLEcTOR eeft, Buttel...Ounty Treasurer-Tax Collector's De,pa,rtment 25 County Center Drive, Suite 125, Oroville, CA 95965 Direct- 530.538.7539 [ blain Line: 530.538.7576 www.buttec"o�u"rity.riet/ftc 0 COUNTY OF BUTTE E - MAIL DISCLAIMER: This 9-mail and any attachment thereto may contain private,confidential and privileged material for the sole use of the intended recipient.Any review,copying or distribution of this e-mail(or any attachments thereto)by other than the County of Butte or the intended recipient is strictly prohibited.If you are NOT the lintended recipient,please contact the sender immediately and permanently delete the original and any copies of this a- mail and any attachments thereto. r as ar r Tax Collector Peggy Moak, Treasurer-Tax C ollector 25 County Center Drive, Suite x.25 1": 530,538,7701 �!Utteccaktjty j9jZttc Oroville, California 95965-3354 F: 530.53&7648 TFkE�54JRE6t-'rAX CE'YI.LELT4?R', August 14, 2015 Butte County Board of Supervisors Butte County Chief Administrative Officer Treasury Oversight Committee The attached investment report for July 31„ 2015 is submitted in accordance with the Butte County Statement of Investment Policy dated July 1„ 2015. 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 benchmark for portfolio performance. A loo . 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 F`( 13/14 and FY 14/15 performance compared to LAIF shows margins of 1.386 and 1.092%, respectively. Using $350,000,000 as a baseline portfolio (actively invested balance), this translates to enhanced earnings averaging $3,322,000 per year for the past five years. Investments are marked to market monthly based on a current market price determined by U3, 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 4 ./� __,!u R county.inet/ttc. Respectfully, Leggy Moak Butte County Treasurer-Tax Collector cc: Butte County Auditor-Controller Butte-Glenn Community College Butte County Beard of Supervisors Chico Unified and Gridliey unified School Districts Butte County District Attorney Jessee, M:eegan—Butte County Deputy Administrative Officer Butte County Schoois-JPA Liu Annie—Butte County Manager, Gov't. Accounting Butte County Sheriff Childs, Heather—Butte County Internal Auditor Butte County Superintendent of Schools Butte County Special Districts(Quarterly) ASTAXBUTTE COUNTY TREASURER'S INVESTMENT REPORT July 31,2015 YrELD TO WEIGHTED AVERAGE ACTIVELY MANAGED PORTFOLIO: MATURITY MATURITY(DAYS)' PAR VALUE FAIR VALUE COST CARRIED LOCAL AGENCY INVESTMENT FUND(LAIF) 0.32019 1 52,710,421.77 52„710,421.77 52,7110,421.77 CALTRUST SHORT TERM 0.495% 1 4,520.49 4,520.49 4,518.63 BANK MONEY MARKET(COLLATERALIZED) 0.200% 1 7,948,342.17 7,948,342.17 7,948,342.17 U.S,TREASURYNOTES 1.354% 1,526 14,000,000.00 13,975,236.00 14,031,376.35 MUNICIPAL BONDS 1.704% 1,385 15,000,000,.00 15,013,460.00 15,078,742.98 CORPORATE NOTES** 1,120% 832 34,325,000.00 34,299,330.85 34,529,866.65 NEGOTIABLE COS** 11.637% 916 3,250,000.00 3,250,857.60 3,248,750.00 CERTIFICATES OF DEPOSIT(COLLATERALIZED) 1.000% 67 5,500,000.00 5,500,000.00 5,500,000.00 FEDERAL AGENCY NOTES** 1.233% 1,164 260,629,000.00 260,620,989,86 260,805,790,.39 TOTAL ACTIVELY MANAGED PORTFOLIO: 1,.102% 959 383,367,284.43 393,323,158,.74 393,857,808.94 mangmmmmmmmxxmwm INVESTMENT OF NOTEIBOND PROCEEDS AND OPERATING CASH SCHOOL BOND PROCEEDS(see page 2for detwos) 8,451,250:85 8,451„250.85 8,451,250.85 OPERATING ACCOUNTS U.S.BANK CHECKING ACCOUNT DEPOSITS 14,144,064.19 14,144,064.19 14,144,064.19 OPERATING CASH 36,328.65 36,328.85 36,328.85 OTHER 4,000.00 4,000.001 4,000.00 TOTAL TREASURER'S,FUND LEDGER BALANCE: 416,002,928.12 415,958,802.43 416,493,452.63 INVESTMENTS UNDER MANAGEMENT OF TRUSTEES l eepagesPorddailsp 4,,172,081.66 4,,172,189.66 4,164,5650.11 PAR VALUE FAIR VALUE COST CARRIED TOTAL CASH AND INVESTMENTS: 420,175,009.78 420,130,992.09 420,658,102.74 SIX MONTH LIQUIDITY PROJECTIONS Estimated Cash Receipts for Next Six Months 496,846,276 Estimated Disbursements for Next Six Months -445,987,674 Estimated Net Cash Flow for Next Six Months`°* 50,858,602 (Al) Prudent Reserve -30,000,440(A2) Securities Maturing, 114,900,000(E) Local Agency Investment Fund 1 Cal Trust f MMF' 60,663,283(C) Total Liquidity for Next Six Months 96,421,885(At+A2+8+C) Estimated Cash Available for Long Term Investment -30,000,000 Remaining Available Liquidity 66,421,885 Total Par Valine of actively manacled investments maturing In less than 12 month's: 82,563,284 Total Par Value of actively managed investments maturing in more than 12 months: 310„804,000 Actual Weighted Average Maturity Will be shorter,and actual dollar amount of investments maturing in less than 12 months will be higher than stated due to call features on Investments.. See page 5 for detailed list of investments. Induces TRAM(Tax and Revenue Anticipation Notes)receipts and disbursements,if applicable, 1 BUTTE COUNTY TREASURER'S INVESTMENT REPORT INVESTMENT OF SCHOOL BOND PROCEEDS July 31, 2015 INVESTMENT MATURITY ANNUAL PAR FAIR COST BOND/NOTE DESCRIPTION TYPE DATE DESCRIPTION YIELD* VALUE VALUE CARRIED BONDS-LOCAL AGENCY INVESTMENT FUND(LAIF) Chico Unined Measure E Series LAIF 0.320% 8,451,250.85 8,451,250.85 8,451,250.85 PAR FAIR COST VALUE VALUE CARRIED GRAND TOTAL 8,451,250.85 8,451,250.85 8,451,250.85 "Yields quoted above are a snapshot per investment type. Actual yields earned on school bonds are calculated by the Treasurer's office and are a composite cf investment eamings less Treasury costs. 2 BUTTE COUNTY TREASURER'S INVESTMENT REPORT DEPOSITS AND INVESTMENTS UNDER MANAGEMENT OF TRUSTEES/FISCAL AGENTS July 31, 2015 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#XXXX1 106 Money Market HERITAGE MM#3106 0.047% 1,881,132,40 1,881,132.40 1,881,132A0 Int.Rate Stabilization Fund#XXXX1 109 Money Market HERITAGE MM#3106 0.047% 1,00510 1,005.10 1,005.10 Pooled Agency Funds Local Agency Investment Fund 0.320% 1,632.73 1,632.73 1,632.73 Principal Account Fund#XXXX1140 Cash Cash 0.000% 0.00 0.00 0.00 Interest Account Fund 9XXXXI 141 Cash Cash 0.000% 0.00 0.00 0.00 Surplus Account Fund#XXXX1 142 Cash Cash 0.000% 186.44 166.44 186.44 Series B Interest Fund#XXXX 1301 Money Market HERITAGE MM#3106 0.047% 61,596.09 61,596.09 61,596.09 Series 0 Bond Fund#XXXX1305 Money Market HERITAGE MM 93106 0.047% 906,205,70 908,205.70 908,205.70 SUBTOTAL 2,853,758.46 2,853,758.46 2,853,768.46 2006 COP-NEAL ROAD RECYCLING&WASTE FACILITY WELLS FARGO BANK,TRUSTEE Certificate Reserve Fund 9XXXX0800 Money Market Gov MMF Service Fund#743 0.011% 2,50014 2,500.14 2,500.14 US Treas/Agency 8!0712017 FHLMC#3134G3ZR4 1.000°./ 1,200,000L00 1,200,108,00 1,200,000r00 Base Rental Payment Fund#XXXX0801 Money Market Gov MMF Service Fund#743 0.011% 4.71 4.71 4.71 Expense Fund#XXXX0802 Money Market Gov MMF Service Fund#743 0.011% 4,231.32 4,231,32 4,231 32 SUBTOTAL 1,206,736.17 1,206,844.17 1,206,736.17 DEPOSITS WITH FISCAL AGENTS Discovery Benefits Plan Year Cash Balance 1101/13-12131113* 37,431.55 37,431.55 30,000.00 York Risk Services Group-Claim Administrators Umpqua Bank#XXXXX2601 Commercial Bank Business Checking NA 74,155r48 74,155.48 74,155.48 SUBTOTAL 111,587.03 111,587.03 104,155.48 PAR FAIR COST VALUE VALUE CARRIED GRAND TOTAL 4,172,081.66 4,172,189.66 4,164,650.11 Represents the most current data available(source:Auditor-Controller) 3 BUTTE COUNTY TREASURER'S INVESTMENT REPORT ACTIVELY MANAGED PORTFOLIO"AT-A-GLANCE" July 31, 2015 OEM INVESTMENTS BY TYPE* INVESTMENTS BY—MATURITY&YIELD* Local Agency investment Fund I CalTrust/MMF LAIF/CT/MMF 610,663,284 Federal Home ILoan Bank l 59,000,000 LA I F/CALTRU ST/MMF(1 day) 0.320010 $ 60,663,284 Federal Home Loan Mortgage Corp FHLMC 46,055,000 01-12 monthS 1.028% $ 21,900,000 Faderal National Mortgage Assn FNMA 48,100,000 13-36 months1035% $ 159,999,000 Federal Farm:Credit Bank FFCB $ 58,625,000 37-60 mci 1.647% $ 150,805,000 Federal AgricururM Mortgage Corp FAMCA $ 40,849,000 TOTAL PAR VALUE $ 393,367,284 Corporate Notes CORP $ 34,325,000 U.S.'I`reasurp Notes UST $ 14,000,000 Investments managed by Trustees&School Bond Proceeds not included,. Final maturely are used;probable call dates are nol considered. Tennessee Valley Authority TVA $ 5,000,000 Supranatiol SUPRA $ 3,000,000 certificates of Deposit(Collateralized/Negoiliable) CDs $ 8,750,000 MunlcipaIi Bonds MUNI $ 15,0100,000 $ 393,3671284 2% 4% LAlF CALI'RUST MMF(I day) `HLMC `NMA 11,01-12 months ,i FK8 a rAMCA CORP LIST 13-36 monl:lis -IVA SUPRA CD� MUNI 37-63 rnondh5 MEN= Buttle County Pooled Treasury Portfolio Balance" Net of Tax and Revenue Anticipation Notes (TRAN) and Bond Proceeds –.4--2015 $500,000,000 —----- $475,000,000 $450,000,000 - 0 $425,000,000 $400,000,000 - . -.....8-2010 $375,000,000 vu $ —325,000,0130 2007 $300,000,000 f $275,000,000 5250,000,000 ...... '00 $225,000,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC This chart does not include deposits from TRAM,Bond Proceeds,or Investments under Management of Trustees. It is intended to demonstrate cash flowtrends and establish a baseline for the portfolio,enabling medium term investments. 4 BUTTE COUNTY TREASURER'S INVESTMENT REPORT MANAGED PORTFOLIO-DETAILS OF SECURITIES HELD July 31,2015 Credit Rating purchase matuedy Yleid is ZMPHv ➢esAd-tl,n SMP Mootl s filch Dale Oat- Mat-WI%I P-,VMg2 Falr Value cost OaMed• 254670R87 DISCOVER BANK NR NR NR 8242011 82412075 7,50E250,00000 2M 39044 250 am GO 3696204FB GENERAL ELLC CORP AA. Al NR 914!211392121115 0970 5.000000.00 5.026,87000 5,023,354,82 05740KFG7 BARCLAYS BANK DELAWARE NR NR NR 17212011 1221121)15 1,600 250.000.00 251.981.58 250,000.00 31315PWQ8 FARMER MAC NR MR NR 5J9r012 1/1972016 0.675 1.400.000.00 1.02.136.40 1,400,000.0 16b764AC4 CHEVRON CORP AA Aa1 NR 10/302014 6848016 0.435 10,OW,OW.cu 10,027,920.0 10,040,565,32 36160XUB1 GE CAPITAL FINANCIAL INC CO MR NR NR 5`19/X11 8719r2016 1.850 250,OD3.00 250,000.00 250,00000 3133EEE04 FEDERAL FARM CREDIT BANK AA, Aaa AAA 3192015 916201& 0610 5,000,000.00 5005.29000 4,995,071,69 17284AKX1 017 BANK NR NR NR 9182111 RMM16 1,800 25000000 250,00000 250,OW.00 36157PSP5 GE CAPITAL RETAIL BANK NR NR NR 107112013 10/12018 1200 250,000.00 25.0,00000 250,000,00 BOD591 CSB TENNESSEE VALLEY AUTHORITY AA. Aaa AAA W72312 121152016 0970 5,000,000.00 5,279.820.00 5.261,036,01 3131SPYBO FARMER MAC NR NR NR 1!302012 1162017 1.150 3.000.00.00 3,020.394.00 3,009,561.43 3133EELRS FEDERAL FARM CREDIT BANK AA+ Aaa AAA 2142015 1272017 0.635 2,625,OW.W 2,623,461.75 2,624,605,33 3137EADC0 FREDDIE MAC AA. Aaa AAA 2/1412013 VMU17 0.753 5,000,000.00 5028,14500 5,019,450.10 575a2PM80 MASSACHU SETTS ST G O LTD TXBL AA+ Aal AA+ 41BM13 4112017 0760 2,000,00000 2,001,240.00 2,007201,67 8923670117 TOYOTA MOTO R CREDIT CO RP AA Aa3 A 31132035 &162017 1-000 4,500,000,00 4,503,573.00 4,509,934.48 3133EMH8 FEDERAL FARM CREDIT BANK AA+ Aaa NR 101151012 71112017 0.842 500,0)0.00 4,978.220.0) 4.997.940.42 45905URFJ INTL SK R ECON&DEVELO P AAA A. NR 2/192015 7117/2017 0.890 3,000,000.00 3,005,487.00 3,00,561,22 3135G02F3 FEDERAL NATL MORTGAGE ASSN AA+ Aaa AAA 4!62015 7282017 0.530 5,OW,000.00 5,01324500 5,021 Wg60 3133EDV74 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 9/18/2014 91188017 1.220 5,000,00000 5,00527500 5,00000000 313DA3TKO FEDERAL HOME LOAN BANK AA+ Aaa NR 12/312014 9r4rZO17 1.970 5,000,000.00 5,017,950.0) 4.997.680.14 3133FEQXI FEDERAL FARM CREDIT BANK AA. Asa AAA 2/252015 9252017 1.000 3.000.000.00 3,006879.00 3,000,000.00 3134G5JJ5 FEDERAL HOME LOAN MTG CORP AA+ Asa AAA 9/298014 9r292017 1-100 1.625000 w 1,620,363.25 1,625,000,00 3130A3FV1 F£OERAL HOME LOAN BANK AA+ Asa NR 11292014 11127!2017 1.100 5.000.000.) 5,011.485.00 5.000.000.00 313381820 FEDERAL HOME LOAN BANK AA+ Aad NR 12!192012 12!62017 0.857 5Co0W0.W 4,971,295.00 4,957,690.33 3133ECS45 FEDERAL FARM CREDIT BANK AA+ Aga AAA 12!282012 12126017 0.910 le.000.00C.c0 9,951,68000 9,997,597.22 31316PTSS FARMER MAC NR NR NR 1/11/2013 1212711017 0.906 4,265,OW.W 4,270,877,17 4,264,689.50 31315PSY1 FARMER MAC NR NR NR 1/621715 1181m18 1.320 3,184,DW.W 3,107925.87 3,154,00000 3137EADN6 FHLMC.7501118 AA+ Aaa AAA 11142013 1!1212018 0.920 E.000.000 00 4.971 40500 4.979.714.46 31315PB40 FARMER MAC NR NR NR 21261X13 1242018 1422 1.000.000.00 599,514.00 998,737.27 313SG1056 FNMA STEP-UP AA, pad APA 1129=13 189V2016 0.800 9.200.0W.W 9.198,031 20 9,200,000.00 3134G34K3 FEDERAL HOME LOAN MTC CORP AA+ Ana AAA 17308013 11301+018 1.000 5,000,001).0 4,9BI OC 5,OW,000.00 3135GOUE1 FEDERAL NATL MORTGAGE ASSN AA, Asa AAA 2/148013 2/148015 1000 ICAW000.00 9,988,95000 10.DOO,WO.0O 481 JP MORGAN CHASE BANKNA NR NR NR 220=13 2!212018 1.125 250 am ED 250,00000 250,000.00 313382309 FEDERAL HOME LOAN BANK AA+ Asa NR 2222013 2122r3018 1,150 5X0,000,00 4.985,965,00 5.000.000.00 3133ECGC2 FEDERAL FARM CREDIT BANK AA, An AAA 371372013 2126!2018 1080 5,000000.00 4,98758500 50X.0W.00 31315POM4 FARMER MAC NR NR NR 312/2013 3/612018 0940 1C,000,000,00 9.983,670 00 9,999,946.03 31315PM FARMER MAC NR NR NR SH 512Q13 3192018 0.975 6,06.000,00 4.945,220 00 4.973.839.86 3134G36D7 FEDERAL HOME LOAN MTG CORP AA+ Asa AAA 31202013 31202016 1.200 850400.00 648,979.15 abe,OW.W 313404283 FEDERAL HOME LOAN MTG CORP AA+ As- AAA 4252013 41252018 1.100 SBI,OD 4,965.085,00 5,000,00000 64952W676 NEW YORK LIFE GL06AL FOG AA. Pae AAA 4272015 41278018 1230 - 5000,ODD.DO 4,97199D00 5,009.40152 02UWLUNU ALLY BANK NR NR NR 4r308D15 41302018 1-150 25,WO.W 250000.00 250,OW,W 3133LONY6 FEDERAL FARM CREDIT BANK AA+ Asa AAA 5182073 5182018 0986 5,000,000,00 4,970.535-00 4,995,153.47 3134G45W4 FEDERAL HOME LOAN MTG CORP AA+ Aad AAA 529/2013 5292018 1.000 6,0OOW.W 4.963.96.00 51100,11110.0 313OA46K3 FEDERAL HOME LOAN DANK AA+ pea NR 2272015 6848018 1.350 5,000,0x0.00 4,994,&M.W 5,1100,000,00 38147J3EO GOLDMAN SACHS BANK USA NR NR NR 8/27/2014 82712018 1e 250,000.W 750,DW,W 250,00000 02567CAYU AMERICAN EXPRESS BK FSB MR NR NR 81288014 8/288018 1000 25D.0-00 2m. w 250,00000 912B28RH5 US TREASURY NOTE AA. Asa AAA 2!122115 9/302018 1.260 5,X0400.00 5436,330.00 5,017 708 33 7954SORMS SALLIE MAE BANKSALT LIKE NR NR NR 11251X13 11r2012018 2050, 250,000.00 250,000.00 250000.00 550D35K80 NEW YORK ST URBAN DEV CORP REV AAA Aal A-L. 12/188014 31152019 1980 5000000-W 5,011,750,00 5,001 665 23 313OA4UU4 FEDERAL HOME LOAN BANK AA. NR NR 429!2015 4292019 0,626 4,700,000.00 4.749.726.00 4,747,864.60 13063CKO CALIFORNIA ST GC UNLTO TXBL AA- Aa3 A. 11242014 5!12019 1,900 3.00.000.00 3.039,870.00 3,037,558,23 313379EE5 FEDERAL HOME LOAN BANK AA- An NR 6/162014 61148019 1.785 51 5,018,650.00 4.970482,04 31315PM71 FEDERAL AGRIC MTG CORP NR NR NR 71170014 71172019 I,8I3 5.000.000.00 5.050,060.00 4.984,353.61 31315PY94 FEDERAL AGRIC MORTGAGE ASSN NR MR NR &1420T4 8/142019 1940 3,000,00000 3.001,992,00 3.000000,00 31315PTOI FARMER MAC MR NR NR &252014 8/2372019 1 765 5.000J000.00 5.020,490.00 4,967,999.44 313OA2TJ5 FEDERAL HOME LOAN BANK AA. Asa NR 812512014 &72672019 0,820 3.000.000.00 3.040.782.00 3,028,472.22 3134G5GG6 FHLMC STEP-UP 1915 AA- Aaa AAA 81272014 87272019 1.500 2,581),000.00 2,582,229.12 2,580000,00 3136G2508 FEDERAL NATL MORTGAGE ASSN AA+ Aaa AAA 51120015 9192019 0.600 5.000000.00 5.007,86500 5,008,36581 3133EOUY6 FEDERAL FARM CREDIT BANK AA, Aaa AAA. &118014 91412019 1630 5,000OD0.00 507570500 5,X3,823-33 3133EEBN9 FEDERAL FARM CREDIT BANK AA+ Asa AAA 111122014 111122'713 LOW 5,000,000.00 5,044850.00 5,0).000.) 313403222 FEDERAL HOME LOAN M7G CORP AA+ Aaa AAA. 4717015 1!82020 1.600 5.OW.000.0) 4.96T.445.00 4.993,559.73 02581 AMERICAN EXPR CENTURION NR MR MR 1!308015 11302]20 1 950 25,OW.X 2SC.W W 250,000,00 3136G2CF0 FEDERAL NAIL MORTGAGE ASSN AA+ Aea AAA 1/302015 1130!2020 1700 4,250,ODD.00 4,227,449.50 4,26,000.W 3134G3C99 FEDERAL HOME LOAN M7G CORP AAs Asa AAA N132015 211311020 1.800 6.OW.OW.00 5,938.824.00 5,961,104.00 313GODC84 FEDERAL MATL MORTGAGE ASSN AA- A-a AAA 21278015 2272020 2.000 5,000,000.00 4,981 5,000,000.00 3130A403 FEDERAL HOME LOAN BANK AA. Aaa MR 31_'02015 37308020 1.500 5,GW,00000 5,014,01003 5,000,0X.00 9128MJ84 u 5 TREASURY NOTE AA. Aaa AAA 4188015 3!318020 1.330 5,000,00000 4,957,03000 5010,063.06 130630604 CALIFOR NIA ST GO U NLTD TXBL AA Aa3 A+ 41292015 41172020 1,680 5,000,000.00 4,96,600.00 5.026.735.89 3133EEYJ3 FEDERAL FARM CREDIT BANK AA+ Ass AAA M132015 4132020 1.680 4.000.000.00 3,967,984.00 4,000,000.W 71270QMS2 PEOPLES UNITED BANK NA NR NR NR 4/158015 4tlsQ 20 1.BW 2'A,W1).W 250,000.00 250,CW.W 313DA4VG4 FEDERAL HOME LOAN BANK AA- A. NR 4228015 4222020 1.740 1,100,001),00 1,08550970 1,IOD.DDD.) 037833501 APPLE INC AA+ AM NR 512112115 SWD20 1.992 9,825,00000 9,760 977 35 9,872,953.71 3138G2HF7 FEDERAL NATL MORTGAGEASSN AA+ Aaa AAA 5119MIS 51192020 1,600 5.000.00,00 4.938,270,00 5,000.00.00 912828XE5 US TREASURY NOTE AA+ A- AAA 6!12015 502020 1.503 4.0X.000.00 3.981,876.00 3,999,395.88 3133EEU65 FEDERAL FARM CREDIT BANK AA- An AAA 61&2015 6/872020 1850 4.000000.00 3.03,656.X 4,000,000,) 140420RXU CAPITAL ONE BANK USA NA NR NR NR G7102D15 6!102020 2,006 26,00,00 248,785,58 248,785.58 313wiHU6 FEDERAL HOME LOAN BANK M. Asa NR 6672015 6122020 1.76 5.0W.000 DO 4.991,270 00 4,993,07).13 313383HUS FEDERAL HOME LOAN BANK AA+ Aaa NR 7/2072016 6128020 1.806 5,WO,0W,W 4,991,270,00 4,986932.09 3133834H1 FHLB 1.37506120 AA- Asa NR 723/2015 6121X20 1.795 5.200000,DO 5.09135120 569869083 3134GTBKG FHLMC STEP-UP AA+ Pea AAA &302015 8242020 1000 5,000,WO.W 4,899,065,00 5,000000,00 3136G2L70 FEDERAL NATL MORTGAGE ASSN AA+ Asa AAA &302015 G13orxY 0 2,000 4,6`0,0),00 4.648637 55 4,66.000.00 "Effective Duration:2.432 1.252 327,204,000.00 327,159,874.31 327,512,159.12 sou M-: U.S.84RK Safekeeping V-lues may differ from Treasurer's Cast Earned due t,acct 1-m ftd sarst- B,ndEd9a P,rtialla•Aralyaia Nees: Federal/giin4 I Mw g-Ee C,rpoiafion aecur4iea are issued by.U.S.G,Nerrmenl apen:y and are mt raletl, NeVIable CDs are not rased,but are FDIC ima,d, 5 Treasurer Tax Collector Peggy Moak, Treasurer-'Tax Colliector 60 25 County Center Drive, Suite 125 T: 5303383701 � Oroville, Californua 95965-3364 F: 530.538.7648 'CR�ASUkER—�'a�,X CS�X.LEGT�}R August 14, 2015 Butte County Board of Supervisors Butte County Chief Administrative Officer The attached statements showing investment transactions for the month ending July 31, 2015 are submitted in accordance with Government Code, and with Local Agency Investment Guidelines as recently revised by the California Debt and Investment Advisory Commission. The Investment Policy effective July 1, 2015 includes a provision for monthly reporting of investment transactions to the Board of'Supervisors. In addition to the above, Investment Reports will continue to be submitted on a monthly basis going forward. As has been our practice, Quarterly Investment Reports are also made available on the Treasurer-Tax Collector website at httY/1)8 .Ibtd ecountj.ne "ttc. If you have any questions regarding recent changes to investment reporting, please feel free to contact me, or Lisa Lam, at 533-7530. "yours truly, Peggy cloak Butte County'Treasurer-'Fax Collector Monthly Investment Transaction Reporting Table of Contents Funds Under Management of Trustees • Wells Fargo Bank — 2004 Pension Obligation Bonds • Wells Fargo Bank — 2006 Certificates of Participation • 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 Rabobank CalTrust 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 Totall Cash With Transaction&Month End Date XXXXII06 XXXX1109 XXXX1140 I XXXX1141 XXXX1142 XXXX1301 XXXX1305 XXXX1307 Fiscal Agent 113112015 Fair Val.. 969,080M t22,635.46, -0,00 [-0-00 -0-00 457,762.87 428,629.23 0.00 1,1558,107,63 interest Earned 14.68 0.02 1 6.94 6.49 28,13 CSCDA Issuer Fees Wire Transfer From Butte County 0.00 Wire Transfer From Butte County 0.00 interest Paid to Bondholder k8,72^1.411.) Transfer From XXXX1301 0.00 Transfer To XXXXI 1.41 0.00 272802015 Fair Value EO94-75 _L135 48 01,00 0.00 449,045.20 428,635.72 0.00 1,849,411.15 interest Earned 18.95 0.02 8 78 8.38 1 36.13 CSCDA Issuer Fees 0.00 Wire Transfer From Butte County 0.00 Wire Transfer From Butte County 0100 Interest Paid to Bondholder 67'903.7r*� Transfer rrorn XXXX1301 0.00 Transfer To XXXX1141 0.00 3-f31/2015 Fair Value 969,11170 2,635.50 0100 Mo 0,00 441,150.19 428,644.10 0.00 1,841,543.49 Interest Earned'.. 25.65 1.08 -11.69 11.35 49.75 CSCDA Issuer Fees 0.00 Wire Transfer From Butte County 0.00 Wire Transfer,From Butte County 0.00 interest Paid to Bondholder (8,44Ur 141. 49'4815'30) Transfer From XXXX1301 0,00 Transfer To XXXX1141- 0.00 473012015 Fair Value 169,139.35 2,636.58 0.00 (M 0.00 432,675.53 4213,655.45 0.00 1,833.10(5.91 lriterest Earned 28.54 0.03 14.77 12 7S2 53.93 CSCDA Issuer Fees 0'Q0 Wire Transfer From Butte County 0= Wire Transfer From Butte County 0.00 rransfer To 15281140 (1 25,0M00) 125,000m 0.00 Transfer To 16281141 )844,008,70 844,008,70 0.00 interest Paid to Bondholder In`a7.) Q J,t;ur",I Transfer Fromi XXXX1301 0.00 TransEer To XXXX1141 0.00 E712015 Fair Value 1=5 91,9 2,636.61 -725-,100M 844 1=11 10 0.00 424,069.761. .428,668.07 0.00 1,824,542.33 Interest Earned 27.25 0.03 12.99, 13,13 53.40 CSCDA Issuer Fees 0.00 Wire Transfer From Butte County 0.00 Transfer from XXXX1301 345,0010,00 0.00 Transfer To XXXX1307 pls'000'00( i345,(!rr)G 00� Transfer To XXXXI 142 (186.114), jJ415 44) Principal Palo to Bondholder (125,000 W Interest Paid to Bondholder (8,91124381 08� Transfer from XXXXII06 186.44 186.44 7/3-012015F.I.rV.iva �0.00 2,636.64 0A0 L OdOO 86.44 70,158',37 428,681.20 0.00 501,662.65 Interest Earned 1.19 1 2.50 15,25 1U.94 CSCDA issuer Fees100 Wire"rransfer From BUtte COUntry 1,881,132,40 479,509.25 2,360,641.65 Transfer from XXXX1301 0.00 Transfer To XXXX1307 020 Ta-nsforT.X-XXX1142 q.00 Principal Pald to Bondholder 0.00 Interest Paid to Bondholder (8,S64)8(j (8,55'l m) 1Transfer from XXXX1106 0,00 '17131,12015 Fair Value 11881J32A0 1 2,637,83 ---6-.0-0T 0.221 186-4-4 61,596709 908,20510 L 01,00 2,13S3,758.46 Sources: 1)Wells Fargo Bank Statements,2)Butte CountyAdmimstration Office Butte County Treasurer Monthly Investment Transaction Reports Investments Under Management of Trustees Wells Fargo Bank, Trustee 2006 Certificates of Participation Transaction Activity Base Rental Reserve Fund Payment Fund Expense Fund Total With 'Date Transaction XXXX0800 XXXX0801 XXXX0802 Fiscal Agent 113112015 =11-Val.. 1,202,392.07. 072 5,731,32 1,208,1271-1 Transfer to another ac000nl (1)05) (1'6.05) ,Transfer from another account 0.05 0.05 Trustee Fee (1,500-00) Debt Service Wire Transfer-AC 573 0.00 Interest Earned 1 0.02 0,04 0.05 0.11 Interest Paid to Bondholder 0100 Principal Paid to Bondholder 0.00 Unrealized Gain/Loss 6,216.00 6,216.00 12/281201:5 IFair Value 1,208,608.09 0.81 4,231.32 1,212,840.22 Transfer to another account (0m) (0.6,10) Transfer from another account 0.03 0.03 Trustee Fee 0100 Debt Service Wire rrar sfer-AC 573 0.00 Interest Earned 005 003 0108 Interest Paid to Bondholder 0.00 Principal Paid to Bondholder 0.00. Unrealized Gain/Loss 864.00 864.00 3/31112015 [F-ir-Value 1,209,47214 0,84 4,231.32 1,213,704,30 Transfer to another account (,0 041 I10,04) Transfer from another account 0.04 0.04 Trustee Fee 0.00 Debt Service Wire Transfer-AC 573 GM Interest Earned 0.07 0.04 0.11 interest Paid to Bondholder 0.00 Principal Paid to Bondholder 0,00 Unrealized Gain/Loss (804.00) �8(m.aq 413012015 [Fair Value 1,208,668.21 0.88 4,231.32 1,212,900.41 Transfer to another account (0M) (GM� Transfer from another account 0.03 OM Trustee Fee M10 Debt Service Wire Transfer-AG 573 0.00 Interest Earned 0.07 0.03 0.10 Interest Paid to Bondholder 0100 Principal Paid to Bondholder 0.00 Unrealized Gain/Loss 1,308m 1,308.00 5131/2015 Fair Value 1,209,976.28 0,91 4,23132 1,214,208.51 Transfer to another account (0.04) 10,04) Transfer from another account 0,04 0.04 Trustee Fee 0.00 AC 1275 1,058,948.81 1,058,948.81 Interest Earned 0,07 0.04 0.11 Interest Paid to Bondholder 0.00 Principal Paid to Bondholder 0.00 Unrealized Gain/Loss 6,4„56x00) I456XH)) 6130(2015 [Fair Value 1,209,520.35 1,058,949.76 4,231.32 2,272,701.43 Transfer to another account (6JA0.28) (o ol) (6,000,31) Transfer from another account 8,000.28 6,000.29 Transfer from another account 0.03 0.03 Trustee Fee 0.00 AG 1275 Mo Interest Earned 0.07 4.64 OM 4.74 Interest Paid to Bondholder ✓,1 4%mo.M 1149,9150 00) Principal Paid to Bondholder 1915,OMGo Unrealized Gain/Loss 601 P2 00) (912 00) Fair Value 1,202,608.14 4,231.32 1,206,944.17 Sources: 1)Wells Fargo Bank,2)Butte County Administration Office Butte County Treasurer Monthly Investment Transaction Reports Investments Under Managemient of Trustees York Risk Services G,rp, 'laims Administrator Umpqua Bank WORKERS' COMPENSATION Account# XXXXX2601 Transaction Activity - Current Month Beginning BNance -6/30/2015 164,669.25 Deposits/Additions 7/14/15 10,000.00 Other Deposits/Additions 7/9/15 77,481,80 7/9/15 4,904.40 719115 0.54 7/20/2015 78,877.35 7/27/2015 4124 7/29/2015 0.01 Disbursements Checks Paid (261,695 7,9) Maintenance Fee 7/211/2015 (124,31); Debit Memo Correction 7/31/2015 iii it n 74.155.481 Source: Umpqua Bank Statement LAI F'Regular Monthly Statement Page I of I Local Agency Inveifinent Fund J`M.Rox 942809 Sacramento,CA 94209-0001 =Mkmmma;�o.*area areaiar-Imali7laaiN"..rx�> (916)6-53-MKI I August 03,2,015 HUTIT COUNTY CIIII-I'DITUTY 25 COUNTY CENTI.iR D[UVL,' OROVILLE,CA 95965-3384 Account Number: T On.WiRlIkfil I i—fi Km—N Rfly 2015 Statement Effective TransactionTran Confirm Date Date Type Number Authorized:('alter Amount 7/1,5/2015 7/14/2015 QRD 1472306 SYSTEM 13,910,74 7/24/2015 7/24/2015 RW 1475229 COLl.,,TTL WORSHAM -5,0t10,000.00 7/29/2015 7/29/2015 RD 1475542 COI,l-,',YlT,,'WORSHAM 10,000,000,00 Account SuminaLy Total Deposit: W,013,M.74 Beginning Balance: 10,657,468.74 Total Withdrawal; -5�,000,000.00 Lnding Man= 15,671,379.48 https://Iaift-ns.treastirer.ca.gov/RegularSt,itement.aspx 8/3/2015 LAIF Regular Monthly Statement Page I of I Local Agency ljrtnrr ,%tjjjVjt j,'tjWjgj P.0,Box 942809, Sacraincom,C,%94209-0001 (916)653-3001 August 03,2015 BUTTE",COMMUNITY COLLEGE I)ISTRICT 25 CUNI FR DRI VE,SUTM 125 OROWIF,CA, 95965-3384 Account Numbeir Pauly 20715 Statonloit Effective TransactionTrall Confirm Date Date TYPe Nixintwr Authorized Caller Amount 7/1512015 7114/2015 ORD 1472469 SYSTEM 9,48199 -A-ccountSuMm"MMM "I'Mal Deposit: 9,482.99 Beginning Babice: 6,547,01930 Total Withdrawt& 0.00 1"Indine Balance: 6,556,50129 hups:Mai f'rns.treasurer.cagov/Rcgtilai-Stateiiient,.asl)x 8/3/2015 I.AIF Regular Monthly Statement Page I of I Local Agency Investment Fund 11-0.Box 942809 sacrallicilto,CA 94209-0001 castWer.c;na yj) 11)101653-3001 August 03,2015 PARAINSE UNIFIED SCHOOL DISTRK,"T' BUTTF,COUNTY TREASURE'R 25COtJN'I'YCI',N'1"1--RDRIVI-�',,SUI'1'13 125 OROVILLE,,CA 95965 Account Number: ON=, JA�L I ys-1 b LEI L'Lli n!n5, July 2015 Statement Effective Transaction 1ran Confirm Date Date Type Number Authorized("aller Amount 7/14/2015 7/14/2015 RW 1471924 COLE-I-I'E WORSHAM -5,000,0100,0:0 7/15/2015 7114/2015 QRD 1472470 SYSTEM 8,403.84 Account Suininaa Total Deposit: 8,403.84 Beginning Balance: 10,075,381.65 Total Withdrawal: -5,000,000 00 Ending Balance: 5,083,785.49 https://Iaifnis.treasurcr.ca.gov/RegLilai,Stateti,ient.aspx 8/3/2015 LAI F Regular Monthly Statement Page I of I Locid Agency Investonent Fmid P.R Rom 9421019 Sacramento,CA 94209-0001 L,,iu,—vLm�im mr-m t-mn—lp-m Laja!1/L�a LI.�lw (916)653-,3001 August 03,2015 OROVILLE UNION I 110tt SO Ml,DISTI<tC I' INYTTE'COUNTY]REASORER 25 COUNTY CfhNTLR DRIVE",Will,, W OROVILLF,CA 95965-3384 Account Numbcr-. I Wy 2,0115 StAwnent Effectivc Tramp mKfionl"ran Confirm Date Datc Type Number Authorized Caller Amount 7/151,2015 7114/2015 QRD 1!472471 SYSTUM 9190.84 7/20/2015 7/20/2,015 RW 147'4806 COLEI M WC RSt IAM -5,000,000mo Lk(--C ma as n—tS t ToUd Deposit: 9,190A4 Beginning Balance: 10,474,,473,24 Tolail Withdrawal: -5,0001,000,00 Ending Balance: 5,483,,664,08 littps:Hlaifiiis.treasurei",ca.gov/Regi�ilarSt,aterncnt.aspx 8/3/2015 LAT F Regular Monthly Statement Page I of I Local Agency Investment Fund 11.0,Box 942809 Sacramento,(,,'A 94209-0001 (916)653-3001 August 03,2015 CHICO UNIFIED SCHOOL DISTRICT BUTTI,COUNTY]REASURER 25 COUNTY T CENER[AUVI3,SUIT17� 125 OROVILLF',CA 95965-3384 Account Number: ME= —k MR* July 2015 Statement Effective Transaction Tran Confirm Date Date Type Number Authorized Caller Amount 7(112015 7/1/2015 RW 1471116 LISA LAM -5,000,000.00 7/8120'15 7/8/2015 RD 14714(A COL F,1711 WORSHAM 5,000,000.00 7/1512015 711412015 QlkD 1472413 SYS-1-F!,M 16,063.36 Account Sunuggar Total Deposit: 5,0 16,063.36 Beginning Balance: 19,867,052.00 Total Withdrawal: -5,000,000.00 Ending Man= 19,883,115.36 https://Iaifiiis.treaSLirer.ca.gov/RegularStatct,nent.aspx 8/3/2015 I AIF Regular Monthly nthl StaDt.0°Ment Page I til°I. Local A lency lauveal;uaaeaut Fund P.O.IWx 9428W) wrewa wa wl�a�wauu�a°° �°�a:tt�rd tvunw� la�7l ru3�2aw� lucrau 653-300 nto,A 9420% 0010 August 03„2015 k311`1 1 t::Cm IItJ 1"5 4�gµls"11w f;OF 181J111,'A 1'ld'N Ci1.8`k 1"[:C'CSI.IC~�"1'Y`1"Mtl?:�hSgllt,lal� �"511��u 5.�5'�"M �� ;�llluululwl�°�a8m1D{�" 25 Cl)l lbs TY"Cls"N,rER i7R1"Vls.SUITE 125 1.)&DCJwd1lWLE',CA 95965u3384 Account Number: 1 u�aua.�' laa k9 8°do,luuaa lu_:µ July 2015 SlaatcmeW lC�l''f tl a Transaction"Tabs C,`saalDrura Date Date TYPO, Number ,Atukhoria xd Caller Amount 7/1512015 7/14/2015 QRD) 1472474 `aY"*;°1°1'"M 9,703. 1 lccasuuuut uuauunaa,rt Total Dclaaaslt: 9,703,11 Beginning Balance: 9„47.3,522.81 "k'crtaWithdrawal: 0.00 En(fing 13alarucca 8,493,22 ,92 htIs:Hlaifins.trcasr.lrer,ca,gov/RegiiirStatt:;ment,*spx 8/3/2015 Account Number:. Last Statement: June 30,2015 n Rabob nk,N.A. This Statement: July 31,2015 P.O.Box 6002Total days in statement period: 31 RabObank Arroyo Grande,rA 93421-6002 Page 1 of 1 Direct inquiries to: 800-942-6222 RABOBANK, N.A. 2227 MYERS STREET OROVILLE CA 95966 RETURN SERVICE REQUESTED BUTTE COUNTY TREASURER'S INVESTMENT POOH. 25 COUNTY CENTER DR ST 128 OROVII_LE CA 38955-3384 Need a credit caret for your business? You can get cash back and more with Rabobank's new Visa bonus rewards card. Redeem rewards for cash back„ travel, merchandise and gift cards. Get a,low rate and more rewards with fewer rules. Plus,you can get cards for your employees with individual limits.Apply today at your local branch or rabobankamerica.com and start earning automatic bonus points right away. Public Investment Money Market Account number MEN= Beginning balance $7,948,342.17 Avg collected balance $7,960,854.00 Total additions $13,864.77 Interest paid year to date $10,040.23 Total subtractions $0.00 Ending balance $7,962,206.94 CREDITS Date Description Additions 07-01 CD INTEREST PYMT-FROM ACCT NO. FROM CD N4. 0000000002 12,512.50 07-31 INTEREST CREDIT 1,352.27 DAILY BALANCES Date Amount Date Amount Date Amount 06-30 7,948,342.17 07-01 7,960,854.67 07-31 7„962,206.94 INTEREST INFORMATION Annual percentage yield earned 0.20% Interest-bearing days 31 Average balance for APY $7,960,854.67 Interest earned $1,352.27 OVERDRAFT/RETURN ITEM FEES Total for Total this eriod ear-to-date Total overdraft fees $0.00 $0.00 Total returned item fees $0.00 $0.00 Thank you for franking with Rab bank ip-�.a Rabobank,N.A.•Member FDC wew mra.babankarnerica.eom 3036 rev 02-14 ............ COUNTY OF BUTTE, STATEMENT FOR PERIOD July 01, 2015 -July 31, 2015 Caffrust Short Term Fund miss= Date Transaction Shares Amount Price Per Average Average Reallized Share Cost NAV CostAmount Gain/l 06/30/2015 BALANCE FORWARD 450.961 10.02 4,518.63 10.01971346 4,518.50 07/0112015 INCOME DISTRIBUTION-JUNE 0.186 10.02 1.86 10.01970533 1.86 0.00 07/3112015 UNREALIZED GAIN(LOSS) 0.000 0.00 0.00 — --------- 07/3112015 ENDING BALANCE 451.147 10.02 4,520.49 41520.36 INCOME DISTRIBUTION PAID-JUNE 0.00 INCOME ACCRUAL-JULY 1,90 CUMULATIVE UNREALIZED GAIN(LOSS) 0A3 'Please note that this information should nok be construed'as tax advice and it is recommended that you consult with,a tax proressiorel regarding your account. For Inquiries About Your Account,Contact: COUNTY OF BUTTE BUTTE, COUNTY OF Nottingham Investment Administration ATTN: PEGGY MOAK 116 South Franklin Street 25 COUNTY CENTER DR, STE 125 Rocky Mount,NC 27804 Attention:Cal Shareholder Services OROVILLE CA 95965 Phone:800.773.3863 Fax:252-972-1908 Email:caltrustsupport@nefunds.corn Page 1 of I [Mbank. Acct Name: BUTTE COUNTY TREASURER SUMMARY-USD Page 1 Acct Number: For period 0710112015.0713112015 ACTIVITY-Settled/Cleared Cash Activity Transaction Type Amount Your Sales Representative is:SAFEKEEPING OPERATIONS Purwases 0.00 (800)236-4221 Purchase Reversals 0.00 Sales 0.00 Statement Contents Sale Reversals 0.00 *Summary Withdrawals 20,255.405 27 "Activity-Settled/Cleared Cash Activity Receipts (10,102,456.1 7) *Activity-Projected Activity for Next Statement Period Deliveries O.OD 'Holdings Principal Reversals a.OD 'Cash Flow Projections Interest 376,630.00 Interest Reversals 0.00 Interest Adjustments 0.00 Maturities 5,250,000.00 Calls 1,985,000.00 Puts 0.00 Paydowns 0.00 Paydown Adjustments 0.00 Payups 0.00 Payup Adjustments 0-00 Cash Dividends 0.00 Balance Changes 0.00 Stock Dividends 0.00 Closeouts 0.00 Closeout Dividends 0.00 Net Activity 17,764,570.10 HOLDINGS-Custody Category ParlShares Original Face Principal Cost Market Value Domestic Time Deposits 3,250,30000 3,250,0W 00 3,248,750.00 502,072.02 Treasury Obligations 14,000,000.00 14,000,000.00 54,030,429.69 13,975,236.00 US Government Agency Securities 257,829,000,00 257,529,000.00 258,415,675.25 257,615,502.86 Nan US Government Agency Securities 3,000,000.00 3,D00,000.00 3,000,690.00 3,065,487.00 Corporate Securities 34,325,00000 34,325,000.00 34,816,121.00 34,299,330.85 Municipal Securities 15.000,000 00 15,000,000.40 15,091,780.00 15,013,460 Oil Total Custody Holdings 327,204,000.00 327,204,000.00 — 328 603,445.94 324,411,088.73 Cobank. Acct Name: BUTTE COUNTY TREASURER ACTIVITY-USD Page 2 Acct Number: Settled/Cleared Cash Activity For period 07101/2015-07/3112015 Date Activity Description Rate Par Security ID Amount Ticket Maturity Price 07/0612015 Interest FARMER MAC 1.380 31315PY89 20,700.00 392124032 01106/17 NOTES 01106f2017 07/0712015 Withdrawal FEDERAL AGRiC MTG CORP 1.730 5,000,000.D0 31315PM71 5,074,287.22 392187403 07117!2019 NOTES 07117/2019 100,668800 07 10 712 01 5 Withdrawal FEDERAL HOME LOAN MTG CORP 1.100 5,000,000.00 3134G5JJ5 5,030,972.22 757007770 09/29117 09129f2017 100.320000 0710712015 Withdrawal FHLB 1.25 06118 1.250 5,000,000.00 313379DT3 5,033,034.72 757007771 06108/2018 100.560000 07106/2015 Interest FARMER MAC 1.320 31315P5Y1 21,014.46 392160724 O V08118 01/08/2018 0710812015 Interest FEDERAL HOME LOAN MTG CORP 1.570 3134G32Z2 39,250.00 392163895 01!0812020 01f0812020 07113r2015 Interest FEDERAL FARM CREDIT BANK -820 3133EA4H8 20,500.00 392133377 07/11117 07/1112017 07/1312015 Interest FH.M0 75 01118 .750 3137EADN6 18,750.00 392136545 01/12116 01/1212016 07/1812015 Interest INTL BK RECON&DEVELOP -900 45905URF3 13,50D.00 392162382 07/17117 0711712017 0 711 712 01 5 Interest FEDERAL AGRIC MTG CORP 1.730 31315PM71 43,250.00 519051051 07/1712019 NOTES 07117!2019 07120/2015 Interest FARMER MAC .675 31315PWOS 4,725,00 392127551 01119116 NOTES D1119/2016 07120f2015 Rsce[pt FEDERAL HOME LOAN BANK 1,750 5,000,003.00 313383HU8 (4,995,085.11) 392167440 06112120 0611272020 99.737000 07122!2015 Interest FARMER MAC 2.375 31315PDZ9 23,750,00 392126850 07122115 0712212015 0 712 212 0 1 5 Maturity FARMER MAC 2.375 31315POZ9 2,000,000.00 392128850 07/22115 0712212015 (Mbank, Acct Name: BUTTE COUNTY TREASURER ACTIVITY-USD Page 3 Acct Number: Settled/Cleared Cash Activity For period 07101 t20 1 5-07!3112015 Date Activity Description Rate Par Security ID Amount Ticket Maturity Price 0712312015 Receipt FHLB 1.375 06120 1.375 5,200,004.00 3133834H1 (5,106,379.06) 757008249 06/4212920 98.043000 0712312015 Withdrawal FEDERAL HOME LOAN BANK 2.000 5,00Q000.00 313383VN8 5,117,111.11 757008251 09/13/19 09!1312019 101.620000 0712 412 01 5 Interest NEW YORK LIFE GLOBAL FDG .75D 64952W31-15 12,187.59 392138721 PRIV PLACEMENT 07!2412015 07!2412015 Maturity NEW YORK LIFE GLOBAL FDG 75D 64952WBH5 3,250,000.00 392138721 PRIV PLACEMENT 0 712 4/201 5 0712412015 Interest FEDERAL FARM CREDIT BANK 1.900 3133EDR20 18,857.50 392155951 07124/2019 BONDS 07124/2019 0712412015 Call FEDERAL FARM CREDIT BANK 1.900 1,985,000.00 3133EDR20 1,985,400.00 392155951 0712412019 BONDS 0704/2019 100.036600 07/24Q015 Interest FARMER MAC .970 31315PB40 4,850.00 575007832 01724118 01124!2018 0712 712 01 5 interest FEDERAL FARM CREDIT BANK _625 3133EELR9 8,203.13 392161767 01727117 0112712017 0712812015 Interest FEDERAL NATL MORTGAGE ASSN 1.070 3135GOZF3 26,750.00 392163845 0712812017 0712812017 07/2 912 01 5 Interest FNMA STEP-UP Variable 3136GIC56 36,800.00 392137058 01129118 0112912018 07/3012015 Interest FEDERAL HOME.LOAN MTG CORP 1.000 3134G34K3 25,000.00 392137165 01130118 01130QO18 0713012015 Interest AMERICAN EXPR CENTURION 1.950 02587OXE3 2,417.47 519054355 CERT OF DEPOSIT 01130/2020 0713012015 Interest FEDERAL NATL MORTGAGE ASSN 1,700 3136G2CP0 36,125.00 519x54366 0113D120 0113612020 Net Activity 17,764,570.10 (Mbank, Acta Name: BUTTE COUNTY TREASURER ACTIVITY-USD Page 4 Acct Number: Projected Activity for Next Statement Period Date Activity Description Rate Par Security ID Amount Ticket Maturity Price 08/1312015 Interest FEDERAL HOME LOAN MTG CORP 1.650 3134=99 49,500,90 392162049 02113!20 02/1312020 08114/2015 Interest FEDERAL NATL MORTGAGE ASSN 1.000 3135GOUE1 50,000.00 392137699 02114/18 02114/2018 0811412015 Interest FEDERAL AGRiCMORTGAGEASSN 1,940 31315PY94 29,100.00 519051564 08/14/2019 NOTES 0811 412 01 0 0811 912 0 1 5 Interest GE CAPITAL FINANCIAL INC CD 1,850 36160XUB1 2,293.49 392118584 08119!2016 0 812 012 0 1 5 Interest JP MORGAN CHASE BANK NA 1.125 48124JS72 1,394 69 392138051 CERTIFICATE OF DEPOSIT 02!202018 0 812 412 0 1 5 Interest DISCOVER BANK 1.500 254570887 1,859.59 392118875 CERTIFICATE OF DEPOSIT 0612412015 0812412015 Maturity DISCOVER BANK 1.500 264670R87 250,000,90 392118875 CERTIFICATE OF DEPOSIT 08/2412015 OW412015 Interest FEDERAL HOME LOAN BANK 1.150 3133823A9 28,750,D0 392138200 02122118 02/2212018 08/2412015 Interest FARMER MAC 1.600 31315PTD1 40,000.00 392156238 08/23119 0812312019 D8124=15 Interest FEDERAL HOME LOAN BANK 1.350 3130A46K3 33,187.50 392162470 08124/18 08/2412018 0812 612 01 5 Interest FEDERAL FARM CREDIT BANK 1.080 3133ECGC2 27,000.00 392138963 02126718 0226/2018 08 2 6120 1 5 Interest FEDERAL HOME LOAN BANK 2.500 3130A2TJ5 37,500-00 519051565 08126!2019 BONDS 08126/2019 013/2712015 Interest GOLDMAN SACHS BANK USA 1.650 38147J3E0 2,04555 392156519 CERTIFICATE OF DEPOSIT 0$12712016 0812712015 Interest FEDERAL NATL MORTGAGE ASSN 2.000 3135GOG84 50,000.00 392162471 02!27120 02/2712020 (Mbank. Acct Name: BUTTE COUNTY TREASURER ACTIVITY-USD Page 5 Acct Number. Projected Activity for Next Statement Period Date Activity Description Rate Par Security ID Amount Ticket Maturity Price 08!2712015 Interest FHLMC STEP-UP 19-15 Variable 3134G5G66 19,350.00 519051568 05127!2019 NOTES CM712019 08128/2015 Interest AMERICAN EXPRESS BK FSB 1.600 02587CAY6 1,983.56 392156524 CERT OF DEPOSIT 08!2812018 Net Projected Activity 623,964.38