Loading...
HomeMy WebLinkAboutInvestment Report & Transaction Reporting for 07-31-16 Treasurer – Tax Collector Peggy Moak, Treasurer-Tax Collector 25 County Center Drive, Suite 125 T: 530.538.7701 Oroville, California 95965-3384 F: 530.538.7648 __________________________________________________________________________________________ August 15, 2016 Butte County Board of Supervisors Butte County Chief Administrative Officer Investment Pool Oversight Committee The attached investment report for July 31, 2016 is submitted in accordance with the Butte County Statement of Investment Policy dated July 1, 2016. All investments are in compliance with this policy. The Investment Report demonstrates that sufficient liquidity is available to meet anticipated expenditures during the next six months. The Local Agency Investment Fund (LAIF) is used as a benchmark for 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 14/15 and FY 15/16 performance compared to LAIF shows margins of 1.092% and 0.865%, respectively. Using $350,000,000 as a baseline portfolio (actively invested balance), this translates to enhanced earnings averaging $3,027,500 per year for the past five years. Investments are marked to market monthly based on a current market price determined by U.S. Bancorp Investments. Copies of statements reflecting investment and cash management transactions are provided to the Board of Supervisors monthly and are available upon request. Quarterly Investment Reports are made available on the Treasurer-Tax Collector website at HUhttp://www.buttecounty.net/ttcUH. Respectfully, Peggy Moak Butte County Treasurer-Tax Collector cc: Butte County Auditor-Controller Butte-Glenn Community College Butte County Board of Supervisors Chico Unified and Gridley Unified School Districts Butte County District Attorney Jessee, Meegan – Butte County Deputy Administrative Officer Butte County Schools-JPA Liu Annie – Butte County Manager, Gov’t. Accounting Butte County Sheriff Childs, Heather – Butte County Internal Auditor Butte County Superintendent of Schools Butte County Special Districts (Quarterly) buttecounty.net/ttc 1 BUTTE COUNTY TREASURER'S INVESTMENT REPORT July 31, 2016 YIELD TO WEIGHTED AVERAGE ACTIVELY MANAGED PORTFOLIO: MATURITY MATURITY (DAYS)*PAR VALUE FAIR VALUE COST CARRIED LOCAL AGENCY INVESTMENT FUND (LAIF)0.588%1 72,574,376.33 72,574,376.33 72,574,376.33 CALTRUST SHORT TERM 0.732%1 4,552.09 4,552.09 4,549.38 CAMP SHORT TERM 0.550%1 20,028,836.57 20,028,836.57 20,028,836.57 BANK MONEY MARKET (COLLATERALIZED)0.590%1 1,002,734.71 1,002,734.71 1,002,734.71 U.S. TREASURY NOTES**1.407%1,365 9,000,000.00 9,156,404.00 9,008,132.08 MUNICIPAL BONDS**1.691%1,194 30,570,000.00 31,062,646.70 30,674,884.70 CORPORATE NOTES**1.588%902 40,987,000.00 41,795,266.29 41,336,005.59 NEGOTIABLE CDS**1.726%1,142 5,500,000.00 5,499,620.07 5,498,182.91 CERTIFICATES OF DEPOSIT (COLLATERALIZED)1.100%267 500,000.00 500,000.00 500,000.00 FEDERAL AGENCY NOTES**1.227%953 200,340,000.00 201,337,038.54 200,209,098.87 TOTAL ACTIVELY MANAGED PORTFOLIO:1.156%744 380,507,499.70 382,961,475.30 380,836,801.14 INVESTMENT OF NOTE/BOND PROCEEDS AND OPERATING CASH SCHOOL BOND PROCEEDS (see page 2 for details)3,057,041.88 3,057,041.88 3,057,041.88 OPERATING ACCOUNTS U.S. BANK CHECKING ACCOUNT DEPOSITS 24,552,829.18 24,552,829.18 24,552,829.18 OPERATING CASH 19,645.61 19,645.61 19,645.61 OTHER 1,544.75 1,544.75 1,544.75 TOTAL TREASURER'S FUND LEDGER BALANCE: 408,138,561.12 410,592,536.72 408,467,862.56 INVESTMENTS UNDER MANAGEMENT OF TRUSTEES (see page 3 for details)6,071,792.96 6,071,792.96 6,083,660.51 PAR VALUE FAIR VALUE COST CARRIED TOTAL CASH AND INVESTMENTS:414,210,354.08 416,664,329.68 414,551,523.07 Estimated Cash Receipts for Next Six Months 487,499,377 Estimated Disbursements for Next Six Months -473,114,992 Estimated Net Cash Flow for Next Six Months***14,384,385 (A1) Prudent Reserve -30,000,000 (A2) Securities Maturing 13,750,000 (B) Local Agency Investment Fund / Cal Trust / MMF /CAMP 93,610,497 (C) Total Liquidity for Next Six Months 91,744,882 (A1+A2+B+C) Estimated Cash Available for Long Term Investment -30,000,000 Remaining Available Liquidity 61,744,882 Total Par Value of actively managed investments maturing in less than 12 months:127,360,500 Total Par Value of actively managed investments maturing in more than 12 months:253,147,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. *** Includes TRAN (Tax and Revenue Anticipation Notes) receipts and disbursements, if applicable. SIX MONTH LIQUIDITY PROJECTIONS 2 INVESTMENT MATURITY ANNUAL PAR FAIR COST BOND/NOTE DESCRIPTION DATE YIELD* VALUE VALUE CARRIED BONDS - LOCAL AGENCY INVESTMENT FUND (LAIF) Chico Unified Measure E Series A 0.588%3,057,041.88 3,057,041.88 3,057,041.88 PAR FAIR COST VALUE VALUE CARRIED GRAND TOTAL 3,057,041.88 3,057,041.88 3,057,041.88 * 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 of investment earnings less Treasury costs. BUTTE COUNTY TREASURER'S INVESTMENT REPORT INVESTMENT OF SCHOOL BOND PROCEEDS July 31, 2016 TYPE DESCRIPTION LAIF 3 INVESTMENT MATURITY ANNUAL PAR FAIR COST FINANCING PROGRAM DATE YIELD VALUE VALUE CARRIED 2004 PENSION OBLIGATION BONDS WELLS FARGO BANK, TRUSTEE Series A Bond Fund #XXXX1106 Money Market HERITAGE MM #3106 0.346%0.00 0.00 0.00 Int. Rate Stabilization Fund #XXXX1109 Money Market HERITAGE MM #3106 0.346%1,007.28 1,007.28 1,007.28 Pooled Agency Funds Local Agency Investment Fund 0.588%1,639.67 1,639.67 1,639.67 Principal Account Fund #XXXX1140 Cash Cash 0.000%11.54 11.54 11.54 Interest Account Fund #XXXX1141 Cash Cash 0.000%56.73 56.73 56.73 Surplus Account Fund #XXXX1142 Cash Cash 0.000%624.20 624.20 624.20 Series B Interest Fund #XXXX1301 Money Market HERITAGE MM #3106 0.346%13,756.17 13,756.17 13,756.17 Series B Bond Fund #XXXX1305 Money Market HERITAGE MM #3106 0.346%429,979.92 429,979.92 429,979.92 Series B Interest Fund #XXXX1307 Money Market HERITAGE MM #3106 0.346%18.96 18.96 18.96 SUBTOTAL 447,094.47 447,094.47 447,094.47 2006 COP - NEAL ROAD RECYCLING & WASTE FACILITY WELLS FARGO BANK, TRUSTEE Certificate Reserve Fund #XXXX0800 Money Market Gov MMF Service Fund #743 0.000%11,314.59 11,314.59 11,314.59 US Treas/Agency 06/11/21 FHLB #3130A1W95 0.000%0.00 0.00 0.00 Base Rental Payment Fund #XXXX0801 Money Market Gov MMF Service Fund #743 0.000%5.03 5.03 5.03 Expense Fund #XXXX0802 Money Market Gov MMF Service Fund #743 0.000%0.00 0.00 0.00 Escrow Fund #XXXX1300 Cash Cash 0.000%5,393,155.83 5,393,155.83 5,393,155.83 SUBTOTAL 5,404,475.45 5,404,475.45 5,404,475.45 DEPOSITS WITH FISCAL AGENTS Discovery Benefits Plan Year Cash Balance 1/01/14 - 12/31/14*NA 18,132.45 18,132.45 **30,000.00 York Risk Services Group - Claim Administrators Umpqua Bank #XXXXX2601 Commercial Bank Business Checking NA 202,090.59 202,090.59 202,090.59 SUBTOTAL 220,223.04 220,223.04 232,090.59 PAR FAIR COST VALUE VALUE CARRIED GRAND TOTAL 6,071,792.96 6,071,792.96 6,083,660.51 * Represents the most current data available (source: Auditor-Controller) ** Benefits can be paid in advance of receipt of offsetting payroll deductions BUTTE COUNTY TREASURER'S INVESTMENT REPORT DEPOSITS AND INVESTMENTS UNDER MANAGEMENT OF TRUSTEES/FISCAL AGENTS July 31, 2016 TYPE DESCRIPTION 4 Local Agency Investment Fund/CalTrust/MMF/CAMP LAIF/CT/MMF/CAMP 93,610,500$ Federal Home Loan Bank FHLB 40,200,000$ LAIF/CALTRUST/MMF/CAMP (1 day) 0.588%93,610,500$ Federal Home Loan Mortgage Corp FHLMC 24,625,000$ 01-12 months 1.079%33,750,000$ Federal National Mortgage Assn FNMA 34,250,000$ 13-36 months 1.338%130,890,000$ Federal Farm Credit Bank FFCB 48,000,000$ 37-60 months 1.650%122,257,000$ Federal Agricultural Mortgage Corp FAMCA 32,265,000$ TOTAL PAR VALUE 380,507,500$ Corporate Notes CORP 40,987,000$ U.S. Treasury Notes UST 9,000,000$ * Investments managed by Trustees & School Bond Proceeds not included. Tennessee Valley Authority TVA 5,000,000$ Final maturity dates are used; probable call dates are not considered. Supranational SUPRA 16,000,000$ Amounts quoted at Par Value. Certificates of Deposit (Collateralized/Negotiable)CDs 6,000,000$ Municipal Bonds MUNI 30,570,000$ 380,507,500$ NR -1 ** This chart does not include deposits from TRAN, Bond Proceeds, or Investments under Management of Trustees. It is intended to demonstrate cash flow trends and establish a baseline for the portfolio, enabling medium term investments. INVESTMENTS BY MATURITY & YIELD*INVESTMENTS BY TYPE* BUTTE COUNTY TREASURER'S INVESTMENT REPORT July 31, 2016 ACTIVELY MANAGED PORTFOLIO "AT-A-GLANCE" 25% 11% 6% 9%13% 8% 11% 2% 1%4%2%8% LAIF/CT/MMF/CAMP FHLB FHLMC FNMA FFCB FAMCA CORP UST TVA SUPRA CDs MUNI $250,000,000 $275,000,000 $300,000,000 $325,000,000 $350,000,000 $375,000,000 $400,000,000 $425,000,000 $450,000,000 $475,000,000 $500,000,000 JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Butte County Pooled Treasury Portfolio Balance** Net of Tax and Revenue Anticipation Notes (TRAN) and Bond Proceeds 2016 2015 2014 2013 2012 2011 2010 2009 2008 2007 2006 LAIF/CALTRUST/MMF/CAMP (1 day) 01-12 months 13-36 months 37-60 months 5 Purchase Maturity Yield to Security Description S&P Moody's Fitch Date Date Maturity (%) Par Value Fair Value Cost Carried* 36160XUB1 GE CAPITAL FINANCIAL INC CD NR NR NR 8/19/2011 8/19/2016 1.850 250,000.00 250,354.61 250,000.00 3133EESQ4 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 3/9/2015 9/6/2016 0.610 5,000,000.00 5,001,270.00 4,999,563.31 17284AXX1 CIT BANK NR NR NR 9/8/2011 9/8/2016 1.800 250,000.00 250,558.47 250,000.00 36157PSP5 GE CAPITAL RETAIL BANK NR NR NR 10/11/2013 10/11/2016 1.200 250,000.00 250,499.66 250,000.00 880591DS8 TENNESSEE VALLEY AUTHORITY AA+ Aaa AAA 1/27/2012 12/15/2016 0.970 5,000,000.00 5,080,960.00 5,070,807.34 31315PYB9 FARMER MAC NR NR NR 1/30/2012 1/6/2017 1.150 3,000,000.00 3,012,045.00 3,002,877.71 3137EADC0 FREDDIE MAC AA+ Aaa AAA 2/14/2013 3/8/2017 0.753 5,000,000.00 5,013,605.00 5,007,314.86 57582PM80 MASSACHUSETTS ST GO LTD TXBL AA+ Aa1 AA+ 4/8/2013 4/1/2017 0.780 2,000,000.00 2,004,100.00 2,002,880.67 89236TBH7 TOYOTA MOTOR CREDIT CORP AA- Aa3 A 3/13/2015 5/16/2017 1.000 4,500,000.00 4,504,581.00 4,504,389.66 3133EA4H8 FEDERAL FARM CREDIT BANK AA+ Aaa NR 10/15/2012 7/11/2017 0.842 5,000,000.00 4,995,230.00 4,999,003.52 45905URF3 INTL BK RECON & DEVELOP AAA Aaa NR 2/19/2015 7/17/2017 0.890 3,000,000.00 3,009,567.00 3,000,275.05 3130A3TK0 FEDERAL HOME LOAN BANK AA+ Aaa NR 12/31/2014 9/22/2017 1.070 5,000,000.00 5,015,815.00 4,998,869.96 3133EEQX1 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 2/25/2015 9/25/2017 1.000 3,000,000.00 3,008,376.00 3,000,000.00 3134G5JJ5 FEDERAL HOME LOAN MTG CORP AA+ Aaa AAA 9/29/2014 9/29/2017 1.100 1,625,000.00 1,627,016.63 1,625,000.00 313381B20 FEDERAL HOME LOAN BANK AA+ Aaa NR 12/19/2012 12/8/2017 0.857 5,000,000.00 4,997,450.00 4,992,922.30 3133ECB45 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 12/26/2012 12/26/2017 0.910 10,000,000.00 10,000,000.00 9,998,597.22 31315PTS8 FARMER MAC NR NR NR 1/11/2013 12/27/2017 0.903 4,265,000.00 4,267,704.01 4,264,818.75 3137EADN6 FHLMC .75 01/18 AA+ Aaa AAA 1/14/2013 1/12/2018 0.920 5,000,000.00 4,996,280.00 4,988,003.67 3134G34K3 FEDERAL HOME LOAN MTG CORP AA+ Aaa AAA 1/30/2013 1/30/2018 1.000 5,000,000.00 5,000,495.00 5,000,000.00 3135G0UE1 FEDERAL NATL MORTGAGE ASSN AA+ Aaa AAA 2/14/2013 2/14/2018 1.000 10,000,000.00 10,023,260.00 10,000,000.00 48124JSZ2 JP MORGAN CHASE BANK NA NR NR NR 2/20/2013 2/20/2018 1.125 250,000.00 250,000.00 250,000.00 31315PQM4 FARMER MAC NR NR NR 3/7/2013 3/6/2018 0.940 10,000,000.00 10,013,570.00 9,999,968.04 31315PZZ5 FARMER MAC NR NR NR 5/15/2013 3/9/2018 0.976 5,000,000.00 4,988,175.00 4,983,880.00 64952WBZ5 NEW YORK LIFE GLOBAL FDG AA+ Aaa AAA 4/27/2015 4/27/2018 1.230 5,000,000.00 5,009,020.00 5,005,970.19 02006LQN6 ALLY BANK NR NR NR 4/30/2015 4/30/2018 1.150 250,000.00 250,000.00 250,000.00 3133ECNY6 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 5/8/2013 5/8/2018 0.986 5,000,000.00 5,000,225.00 4,996,903.47 3134G45W4 FEDERAL HOME LOAN MTG CORP AA+ Aaa AAA 5/29/2013 5/29/2018 1.000 5,000,000.00 5,013,840.00 5,000,000.00 17275RAU6 CISCO SYSTEMS INC AA- A1 NR 11/12/2015 6/15/2018 1.365 5,000,000.00 5,060,945.00 5,026,078.67 89236TCP8 TOYOTA MOTOR CREDIT CORP AA- Aa3 A 9/18/2015 7/13/2018 1.600 5,000,000.00 5,043,640.00 4,995,227.78 38147J3E0 GOLDMAN SACHS BANK USA NR NR NR 8/27/2014 8/27/2018 1.650 250,000.00 250,000.00 250,000.00 02587CAY6 AMERICAN EXPRESS BK FSB NR NR NR 8/28/2014 8/28/2018 1.600 250,000.00 250,000.00 250,000.00 795450RM9 SALLIE MAE BANK/SALT LKE NR NR NR 11/25/2013 11/20/2018 2.050 250,000.00 250,000.00 250,000.00 686184WJ7 ORIENTAL BANK NR NR NR 12/16/2015 12/17/2018 1.750 250,000.00 250,000.00 250,000.00 89236TBB0 TOYOTA MOTOR CREDIT CORP AA- Aa3 A 9/18/2015 1/17/2019 1.875 5,000,000.00 5,105,195.00 5,026,676.06 650035K80 NEW YORK ST URBAN DEV CORP REV AAA Aa1 AA+ 12/18/2014 3/15/2019 1.980 5,000,000.00 5,104,650.00 5,001,205.50 13063CKL3 CALIFORNIA ST GO UNLTD TXBL AA- Aa3 A+11/24/2014 5/1/2019 1.900 3,000,000.00 3,054,780.00 3,027,542.71 3133EFD20 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 2/23/2016 5/23/2019 1.266 5,000,000.00 5,000,100.00 4,997,837.61 594918AC8 MICROSOFT CORP AAA Aaa AA+ 9/28/2015 6/1/2019 1.580 2,500,000.00 2,717,550.00 2,679,560.09 313379EE5 FEDERAL HOME LOAN BANK AA+ Aaa NR 6/16/2014 6/14/2019 1.785 5,000,000.00 5,091,665.00 4,978,110.51 91412GSB2 UNIV OF CALIFORNIA CA REV TXBL AA Aa2 AA 8/24/2015 7/1/2019 1.698 5,000,000.00 5,066,500.00 5,013,740.09 31315PM71 FEDERAL AGRIC MTG CORP NR NR NR 7/17/2014 7/17/2019 1.813 5,000,000.00 5,111,580.00 4,988,303.61 459058EV1 INTL BK RECON & DEVELOP AAA Aaa AAA 1/28/2016 7/26/2019 1.392 5,000,000.00 5,038,930.00 4,979,363.08 31315PTD1 FARMER MAC NR NR NR 8/25/2014 8/23/2019 1.765 5,000,000.00 5,097,765.00 4,975,879.19 68389XAX3 ORACLE CORP AA- A1 A+10/6/2015 10/8/2019 1.845 4,162,000.00 4,291,904.34 4,213,512.17 3133EEBN9 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 11/12/2014 11/12/2019 1.800 5,000,000.00 5,128,435.00 5,000,000.00 02587DXE3 AMERICAN EXPR CENTURION NR NR NR 1/30/2015 1/30/2020 1.950 250,000.00 250,000.00 250,000.00 3136G2CP0 FEDERAL NATL MORTGAGE ASSN AA+ Aaa AAA 1/30/2015 1/30/2020 1.700 4,250,000.00 4,271,734.50 4,250,000.00 882806EM0 TEXAS ST TECH UNIV REV AA+ Aa1 AA+ 11/6/2015 2/15/2020 1.790 2,570,000.00 2,640,186.70 2,597,338.02 912828J84 U S TREASURY NOTE AA+ Aaa AAA 4/8/2015 3/31/2020 1.330 5,000,000.00 5,076,560.00 5,007,901.62 13063CSQ4 CALIFORNIA ST GO UNLTD TXBL AA- Aa3 A+4/29/2015 4/1/2020 1.680 5,000,000.00 5,107,200.00 5,021,006.77 71270QMS2 PEOPLES UNITED BANK NA NR NR NR 4/15/2015 4/15/2020 1.800 250,000.00 250,000.00 250,000.00 037833BD1 APPLE INC AA+ Aa1 NR 5/21/2015 5/6/2020 1.892 9,825,000.00 10,062,430.95 9,862,887.62 3136G2HF7 FEDERAL NATL MORTGAGE ASSN AA+ Aaa AAA 5/19/2015 5/19/2020 1.600 5,000,000.00 5,014,365.00 5,000,000.00 912828XE5 U S TREASURY NOTE AA+ Aaa AAA 6/1/2015 5/31/2020 1.503 4,000,000.00 4,079,844.00 3,999,521.15 140420RX0 CAPITAL ONE BANK USA NA NR NR NR 6/10/2015 6/10/2020 2.006 250,000.00 249,035.99 249,035.99 313383HU8 FEDERAL HOME LOAN BANK AA+ Aaa NR 6/5/2015 6/12/2020 1.780 5,000,000.00 5,121,300.00 4,994,457.55 313383HU8 FEDERAL HOME LOAN BANK AA+ Aaa NR 7/20/2015 6/12/2020 1.806 5,000,000.00 5,121,300.00 4,989,618.81 3133834H1 FHLB 1.375 06/20 AA+ Aaa NR 7/23/2015 6/12/2020 1.795 5,200,000.00 5,255,494.40 5,119,526.02 8821172X1 TEXAS ST A&M UNIV REV AAA Aaa AAA 8/10/2015 7/1/2020 1.963 3,000,000.00 3,051,930.00 2,976,219.76 3133EFCH8 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 9/8/2015 9/8/2020 1.850 5,000,000.00 5,006,530.00 5,000,000.00 05580ACW2 BMW BANK NORTH AMERICA NR NR NR 9/18/2015 9/18/2020 2.200 250,000.00 250,000.00 250,000.00 20033AMR4 COMENITY CAPITAL BANK NR NR NR 9/21/2015 9/21/2020 2.250 250,000.00 250,000.00 250,000.00 254672VT2 DISCOVER BANK NR NR NR 10/21/2015 10/21/2020 2.200 250,000.00 250,000.00 250,000.00 14042RBL4 CAPITAL ONE NA NR NR NR 11/13/2015 10/28/2020 2.277 250,000.00 249,732.71 249,732.71 94986TWG8 WELLS FARGO BANK NA NR NR NR 12/3/2015 12/3/2020 1.500 250,000.00 250,000.00 250,000.00 29266NX93 ENERBANK USA NR NR NR 1/28/2016 1/28/2021 1.903 250,000.00 249,438.63 249,438.63 3130A7CV5 FEDERAL HOME LOAN BANK AA+ Aaa NR 4/7/2016 2/18/2021 1.315 5,000,000.00 5,046,755.00 5,013,135.27 3136G2Z26 FNMA STEP-UP AA+ Aaa AAA 2/26/2016 2/26/2021 1.000 5,000,000.00 5,000,820.00 5,000,000.00 3136G3AV7 FNMA STEP-UP AA+ NR AAA 3/10/2016 3/10/2021 1.000 5,000,000.00 5,005,005.00 5,000,000.00 13063CP87 CALIFORNIA ST GO UNLTD AA- Aa3 A+6/13/2016 4/1/2021 1.430 5,000,000.00 5,033,300.00 5,015,652.78 3134G8Y29 FREDDIE MAC AA+ NR AAA 4/28/2016 4/28/2021 1.326 3,000,000.00 3,001,116.00 2,995,732.50 459058FD0 INTL BK RECON & DEV STEP-UP NR NR NR 4/28/2016 4/28/2021 1.250 3,000,000.00 3,000,000.00 3,000,000.00 128829AC2 CALDWELL BK & TRUST CO NR NR NR 5/13/2016 5/13/2021 1.400 250,000.00 250,000.00 250,000.00 459058FH1 INTL BK RECON & DEVELOP AAA Aaa AAA 6/13/2016 5/24/2021 1.412 5,000,000.00 5,016,795.00 4,991,388.52 3136G3MV4 FEDERAL NATL MORTGAGE ASSN AA+ Aaa AAA 5/25/2016 5/25/2021 1.375 5,000,000.00 5,018,840.00 5,000,000.00 27113PBE0 EAST BOSTON SAVINGS BANK NR NR NR 6/23/2016 6/23/2021 1.500 250,000.00 250,000.00 250,000.00 3133EGKA2 FEDERAL FARM CREDIT BANK AA+ Aaa AAA 7/6/2016 7/6/2021 1.500 5,000,000.00 4,959,410.00 5,000,000.00 3130A8QS5 FEDERAL HOME LOAN BANK AA+ Aaa NR 7/14/2016 7/14/2021 1.201 5,000,000.00 4,964,215.00 4,981,773.78 58403B4S2 MEDALLION BANK UTAH NR NR NR 7/28/2016 7/26/2021 1.400 250,000.00 250,000.00 250,000.00 95960NJN8 WESTERN STATE BANK NR NR NR 7/29/2016 7/29/2021 1.400 250,000.00 250,000.00 250,000.00 **Effective Duration: 2.193 1.343 286,397,000.00 288,850,975.60 286,659,450.29 Source: U.S. Bank Safekeeping *Values may differ from Treasurer's Cost Carried due to accretion method variation. **BondEdge Portfolio-Analysis Notes: Federal Agricultural Mortgage Corporation securities are issued by a U.S. Government agency and are not rated. Negotiable CDs are not rated, but are FDIC insured. Credit Rating BUTTE COUNTY TREASURER'S INVESTMENT REPORT MANAGED PORTFOLIO - DETAILS OF SECURITIES HELD July 31, 2016 Treasurer – Tax Collector Peggy Moak, Treasurer-Tax Collector 25 County Center Drive, Suite 125 T: 530.538.7701 Oroville, California 95965-3384 F: 530.538.7648 __________________________________________________________________________________________ August 15, 2016 Butte County Board of Supervisors Butte County Chief Administrative Officer Investment Pool Oversight Committee The attached statements showing investment transactions for the month ending July 31, 2016 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, 2016 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 http://www.buttecounty.net/ttc. If you have any questions regarding recent changes to investment reporting, please feel free to contact me, or Lisa Lam, at 538-7539. Yours truly, Peggy Moak Butte County Treasurer-Tax Collector buttecounty.net/ttc 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 CalTrust CAMP River City Bank US Bank Safekeeping Butte County Treasurer Monthly Investment Transaction Reporting Funds Under Management of Trustees Sources: 1) Wells Fargo Bank Statements, 2) Butte County Administration Office Wells Fargo Bank, Trustee 2004 Pension Obligation Bonds Transaction Activity Total Cash With Transaction & Month End Date XXXX1106 XXXX1109 XXXX1140 XXXX1141 XXXX1142 XXXX1301 XXXX1305 XXXX1307 Fiscal Agent 1/31/2016 Fair Value 71.86 2,641.09 0.00 23.84 1,041,094.42 12,015.47 902,908.74 0.00 1,958,755.42 Interest Earned 0.02 0.26 0.01 0.03 2.19 232.41 234.92 CSCDA Issuer Fees 0.00 Wire Transfer From Butte County 0.00 Transfer from XXXX1301 0.00 Transfer To XXXX1301 (12,420.17)(12,420.17) Transfer To XXXX1142 0.00 Principal Paid to Bondholder 0.00 Interest Paid to Bondholder (12,015.47)(12,015.47) Transfer from XXXX1305 12,420.17 12,420.17 2/29/2016 Fair Value 71.88 2,641.35 0.00 23.85 1,041,094.45 12,422.36 890,720.98 0.00 1,946,974.87 Interest Earned 0.02 0.28 0.01 0.03 0.71 246.93 247.98 CSCDA Issuer Fees 0.00 Wire Transfer From Butte County 0.00 Transfer from XXXX1301 0.00 Transfer To XXXX1301 (13,503.28)(13,503.28) Transfer To XXXX1142 0.00 Principal Paid to Bondholder 0.00 Interest Paid to Bondholder (12,422.36)(12,422.36) Transfer from XXXX1305 13,503.28 13,503.28 3/31/2016 Fair Value 71.90 2,641.63 0.00 23.86 1,041,094.48 13,503.99 877,464.63 0.00 1,934,800.49 Interest Earned 0.02 2.20 0.01 0.03 0.39 271.74 274.39 CSCDA Issuer Fees 0.00 Wire Transfer From Butte County 0.00 Transfer from XXXX1301 0.00 Transfer To XXXX1301 (13,421.31)(13,421.31) Transfer To XXXX1142 0.00 Principal Paid to Bondholder 0.00 Interest Paid to Bondholder (13,503.99)(13,503.99) Transfer from XXXX1305 13,421.31 13,421.31 4/30/2016 Fair Value 71.92 2,643.83 0.00 23.87 1,041,094.51 13,421.70 864,315.06 0.00 1,921,570.89 Interest Earned 0.02 0.30 0.01 0.03 0.65 259.78 260.79 CSCDA Issuer Fees 0.00 Wire Transfer From Butte County 0.00 Transfer To XXXX1307 (395,000.00)(395,000.00) Transfer To XXXX1301 (13,073.03)(13,073.03) Transfer To XXXX1140 (200,000.00)(200,000.00) Transfer To XXXX1141 (840,542.32)(840,542.32) Principal Paid to Bondholder 0.00 Interest Paid to Bondholder (13,421.70)(13,421.70) Transfer from XXXX1142 200,000.00 840,542.32 1,040,542.32 Transfer from XXXX1305 13,073.03 395,000.00 408,073.03 5/31/2016 Fair Value 71.94 2,644.13 200,000.00 840,566.20 552.22 13,073.68 456,501.81 395,000.00 1,908,409.98 Interest Earned 0.02 0.30 11.54 56.71 0.02 0.76 241.54 18.95 329.84 CSCDA Issuer Fees 0.00 Wire Transfer From Butte County 0.00 Transfer To XXXX1307 0.00 Transfer To XXXX1301 (13,139.73)(13,139.73) Transfer To XXXX1140 0.00 Transfer To XXXX1141 0.00 Transfer To XXXX1142 (71.96) (71.96) Principal Paid to Bondholder (200,000.00)(395,000.00)(595,000.00) Interest Paid to Bondholder (840,566.20)(13,073.68)(853,639.88) Transfer from XXXX1106 71.96 71.96 Transfer from XXXX1305 13,139.73 13,139.73 6/30/2016 Fair Value 0.00 2,644.43 11.54 56.71 624.20 13,140.49 443,603.62 18.95 460,099.94 Interest Earned 2.52 0.02 0.52 131.95 0.01 135.02 CSCDA Issuer Fees 0.00 Transfer To XXXX1307 0.00 Transfer To XXXX1301 (13,755.65)(13,755.65) Transfer To XXXX1140 0.00 Transfer To XXXX1141 0.00 Transfer To XXXX1142 0.00 Principal Paid to Bondholder 0.00 Interest Paid to Bondholder (13,140.49)(13,140.49) Transfer from XXXX1106 0.00 Transfer from XXXX1305 13,755.65 13,755.65 7/31/2016 Fair Value 0.00 2,646.95 11.54 56.73 624.20 13,756.17 429,979.92 18.96 447,094.47 Series A Series B Butte County Treasurer Monthly Investment Transaction Reports Investments Under Management of Trustees Sources: 1) Wells Fargo Bank , 2) Butte County Administration Office Wells Fargo Bank, Trustee 2006 Certificates of Participation Transaction Activity Base Rental Reserve Fund Payment Fund Expense Fund Escrow Fund Total With Date Transaction XXXX0800 XXXX0801 XXXX0802 XXXX1300 Fiscal Agent 1/31/2016 Fair Value 1,221,067.90 14,850.53 2,231.32 0.00 1,238,149.75 Transfer to another account (0.02)(0.02) Transfer from another account 0.02 0.02 Transfer from another account 0.00 ACH TRF 907064 0.00 Interest Earned 0.14 0.19 0.02 0.35 Interest Paid to Bondholder 0.00 Principal Paid to Bondholder 0.00 Unrealized Gain/Loss 3,474.90 3,474.90 2/29/2016 Fair Value 1,224,542.94 14,850.74 2,231.32 0.00 1,241,625.00 Transfer to another account (0.02)(0.02) Transfer from another account 0.02 0.02 Transfer from another account 0.00 ACH TRF 907064 0.00 Interest Earned 0.09 0.12 0.02 0.23 Interest Paid to Bondholder 0.00 Principal Paid to Bondholder 0.00 Unrealized Gain/Loss 3,357.90 3,357.90 3/31/2016 Fair Value 1,227,900.93 14,850.88 2,231.32 0.00 1,244,983.13 Transfer to another account (0.02)(0.02) Transfer from another account 0.02 0.02 Transfer from another account 0.00 ACH TRF 907064 0.00 Interest Earned 0.10 0.13 0.02 0.25 Interest Paid to Bondholder 0.00 Principal Paid to Bondholder 0.00 Unrealized Gain/Loss (2,632.50)(2,632.50) 4/30/2016 Fair Value 1,225,268.53 14,851.03 2,231.32 0.00 1,242,350.88 `Transfer to another account (0.02)(0.02) Transfer from another account 0.02 0.02 Transfer from another account 0.00 ACH TRF 907064 0.00 Interest Earned 0.09 0.12 0.02 0.23 Interest Paid to Bondholder 0.00 Principal Paid to Bondholder 0.00 Unrealized Gain/Loss 6,838.65 6,838.65 5/31/2016 Fair Value 1,232,107.27 14,851.17 2,231.32 0.00 1,249,189.76 `Transfer to another account (0.02)(0.02) Transfer from another account 0.02 0.02 Transfer from another account 0.00 ACH TRF FOR DEBIT SERVICE 1,081,650.00 1,081,650.00 Interest Earned 4.44 0.13 0.02 4.59 Interest Paid to Bondholder 0.00 Principal Paid to Bondholder 0.00 Unrealized Gain/Loss 0.00 6/30/2016 Fair Value 1,232,111.71 1,096,501.32 2,231.32 0.00 2,330,844.35 `Transfer to another account (0.02)(0.02) Transfer from another account 0.02 4,155,266.09 4,155,266.11 Transfer from another account 1,237,889.74 1,237,889.74 ACH TRF FOR DEBIT SERVICE 0.00 Interest Earned 10.13 4.86 0.02 15.01 Interest Paid to Bondholder (131,650.00)(131,650.00) Principal Paid to Bondholder (950,000.00)(950,000.00) TRANFSER TO REFUNDING ESCROW ACCOUNT (1,220,807.25)(14,851.17)(2,231.32)(1,237,889.74) 7/31/2016 Fair Value 11,314.59 5.03 0.00 5,393,155.83 5,404,475.45 Butte County Treasurer Monthly Investment Transaction Reports Investments Under Management of Trustees Source: Umpqua Bank Statement York Risk Services Group, Claims Administrator Umpqua Bank WORKERS' COMPENSATION Account # XXXXX2601 Transaction Activity - Current Month Beginning Balance - 6/30/2016 187,014.72 Deposits/Additions 7/1/16 75,465.62 7/12/16 74,968.37 7/18/16 40,834.00 7/18/16 2,295.00 7/18/16 576.35 7/22/16 130,424.84 Withdrawals/Subtractions Disbursements Checks Paid (309,371.20) Maintenance Fee 7/20/16 (117.11) Ending Balance - 7/31/2016 202,090.59 STATEMENT FOR PERIOD July 01, 2016 - July 31, 2016 COUNTY OF BUTTE Date Transaction Shares Price Per Share Amount Average Cost NAV Average Cost Amount Realized Gain/Loss* CalTrust Short Term Fund - BUTTE, COUNTY OF 06/30/2016 BALANCE FORWARD 453.577 10.03 4,549.38 10.01966590 4,544.69 07/01/2016 INCOME DISTRIBUTION - JUNE 0.270 10.03 2.71 10.01967623 0.00 2.71 07/31/2016 UNREALIZED GAIN (LOSS) 0.000 0.00 0.00 07/31/2016 ENDING BALANCE 453.847 10.03 4,547.40 4,552.09 INCOME DISTRIBUTION PAID - JUNE 0.00 2.83INCOME ACCRUAL - JULY 4.69CUMULATIVE UNREALIZED GAIN (LOSS) * Please note that this information should not be construed as tax advice and it is recommended that you consult with a tax professional regarding your account. For Inquiries About Your Account, Contact: Nottingham Investment Administration 116 South Franklin Street Rocky Mount, NC 27804 Attention: CalTRUST Shareholder Services Phone: 800.773.3863 Fax: 252-972-1908 Email: caltrustsupport@ncfunds.com COUNTY OF BUTTE BUTTE, COUNTY OF ATTN: PEGGY MOAK 25 COUNTY CENTER DR, STE 125 OROVILLE CA 95965 Page 1 of 1 For the Month Ending July 31, 2016Account Statement - Transaction Summary Butte County - Butte County - Opening Market Value Purchases Redemptions Change in Value Closing Market Value 20,028,836.57 9,289.27 0.00 0.00 $20,038,125.84 CAMP Pool Unsettled Trades 0.00 9,289.27 Cash Dividends and Income July 31, 2016 June 30, 2016 Asset Summary CAMP Pool 20,038,125.84 20,028,836.57 $20,038,125.84 $20,028,836.57 Total Asset Allocation 100.00% CAMP Pool Account Page 1 For the Month Ending July 31, 2016Account Statement Butte County - Butte County - Total Settlement Dollar AmountShare or Trade Shares OwnedDate Transaction Description of TransactionUnit PriceDate CAMP Pool 20,028,836.57 Opening Balance 07/29/16 08/01/16 Accrual Income Div Reinvestment - Distributions 1.00 9,289.27 20,038,125.84 20,038,125.84 20,038,125.84 20,038,125.84 20,029,735.53 38,125.84 0.00 0.00 20,038,125.84 0.00 9,289.27 20,038,125.84 0.00 0.00 9,289.27 20,028,836.57 Monthly Distribution Yield Average Monthly Balance Closing Balance Fiscal YTDMonth of Cash Dividends and Income Closing Balance Check Disbursements Redemptions (Excl. Checks) Purchases Opening Balance Closing Balance July January-July 0.55% Account Page 2 Acct Name: BUTTE COUNTY TREASURER **SUMMARY - USD Page 1 Acct Number:For period 07/01/2016 - 07/31/2016 ACTIVITY - Settled/Cleared Cash Activity Transaction Type Amount Your Sales Representative is:SAFEKEEPING OPERATIONS Purchases 0.00 (800) 236-4221 Purchase Reversals 0.00 Sales 0.00 Statement Contents Sale Reversals 0.00 *Summary Withdrawals 0.00 *Activity - Settled/Cleared Cash Activity Receipts (10,481,628.77) *Activity - Projected Activity for Next Statement Period Deliveries 0.00 *Holdings Principal Reversals 0.00 *Cash Flow Projections Interest 372,403.90 Interest Reversals 0.00 Interest Adjustments (2.78) Maturities 0.00 Calls 11,809,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 1,699,772.35 HOLDINGS - Custody Category Par/Shares Original Face Principal Cost Market Value Domestic Time Deposits 5,500,000.00000 5,500,000.00 5,497,812.50 751,412.74 Treasury Obligations 9,000,000.00000 9,000,000.00 9,010,117.19 9,156,404.00 US Government Agency Securities 184,340,000.00000 184,340,000.00 184,975,954.25 185,271,746.54 Non US Government Agency Securities 16,000,000.00000 16,000,000.00 15,967,690.00 13,065,292.00 Corporate Securities 40,987,000.00000 40,987,000.00 41,422,231.72 41,795,266.29 Account Name: BUTTE COUNTY TREASURER **SUMMARY - USD Page 2 Account Number:For period 07/01/2016 - 07/31/2016 HOLDINGS - Custody Category Par/Shares Original Face Principal Cost Market Value Municipal Securities 30,570,000.00 30,570,000.00 30,699,354.50 31,062,646.70 Total Custody Holdings 286,397,000.00000 286,397,000.00 287,573,160.16 281,102,768.27 Acct Name: BUTTE COUNTY TREASURER **ACTIVITY - USD Page 3 Acct Number:Settled/Cleared Cash Activity For period 07/01/2016 - 07/31/2016 Date Activity Description Rate Par/Shares Security ID Amount Ticket Maturity Price/NAV 07/01/2016 Interest FEDERAL FARM CREDIT BANK .625 3133EELR9 7,018.23 392161787 01/27/17 01/27/2017 07/01/2016 Call FEDERAL FARM CREDIT BANK .625 2,625,000.00000 3133EELR9 2,625,000.00 392161787 01/27/17 01/27/2017 100.000000 07/01/2016 Interest UNIV OF CALIFORNIA CA REV TXBL 1.796 91412GSB2 44,900.00 392168055 NTS SER AH 07/01/2019 07/01/2016 Interest TEXAS ST A&M UNIV REV 1.750 8821172X1 26,250.00 757008663 PERM UNIV FUND TXBL-REF-SER B 07/01/2020 07/06/2016 Interest FARMER MAC 1.380 31315PYB9 20,700.00 392124032 01/06/17 NOTES 01/06/2017 07/06/2016 Receipt FEDERAL FARM CREDIT BANK 1.500 5,000,000.00000 3133EGKA2 (5,000,000.00) 392177903 3133EGKA2 07/6/21 07/06/2021 100.000000 07/08/2016 Interest FARMER MAC 1.320 31315P5Y1 21,014.40 392160724 01/08/18 01/08/2018 07/08/2016 Call FARMER MAC 1.320 3,184,000.00000 31315P5Y1 3,184,000.00 392160724 01/08/18 01/08/2018 100.024300 07/11/2016 Interest FEDERAL FARM CREDIT BANK .820 3133EA4H8 20,500.00 392133377 07/11/17 07/11/2017 07/12/2016 Interest FHLMC .75 01/18 .750 3137EADN6 18,750.00 392136545 01/12/18 01/12/2018 07/13/2016 Interest TOYOTA MOTOR CREDIT CORP 1.550 89236TCP8 38,750.00 392168972 SR UNSECURED 07/13/2018 07/14/2016 Receipt FEDERAL HOME LOAN BANK 1.125 5,000,000.00000 3130A8QS5 (4,981,600.00) 392178292 07/14/21 07/14/2021 99.632000 07/18/2016 Interest INTL BK RECON & DEVELOP .900 45905URF3 13,500.00 392162382 07/17/17 07/17/2017 07/18/2016 Interest TOYOTA MOTOR CREDIT CORP 2.100 89236TBB0 52,500.00 392168979 01/17/2019 Acct Name: BUTTE COUNTY TREASURER **ACTIVITY - USD Page 4 Acct Number:Settled/Cleared Cash Activity For period 07/01/2016 - 07/31/2016 Date Activity Description Rate Par/Shares Security ID Amount Ticket Maturity Price/NAV 07/18/2016 Interest FEDERAL AGRIC MTG CORP 1.730 31315PM71 43,250.00 519051051 07/17/2019 NOTES 07/17/2019 07/21/2016 Interest COMENITY CAPITAL BANK 2.250 20033AMR4 462.33 757009131 CERTIFICATE OF DEPOSIT 09/21/2020 07/25/2016 Interest FARMER MAC .970 31315PB40 4,850.00 575007832 01/24/18 01/24/2018 07/25/2016 Call FARMER MAC .970 1,000,000.00000 31315PB40 1,000,000.00 575007832 01/24/18 01/24/2018 99.736300 07/26/2016 Interest INTL BK RECON & DEVELOP 1.250 459058EV1 30,902.78 392172905 07/26/19 07/26/2019 07/28/2016 Interest FEDERAL NATL MORTGAGE ASSN 1.070 3135G0ZF3 26,750.00 392163845 07/28/2017 07/28/2017 07/28/2016 Call FEDERAL NATL MORTGAGE ASSN 1.070 5,000,000.00000 3135G0ZF3 5,000,000.00 392163845 07/28/2017 07/28/2017 100.002100 07/28/2016 Interest ENERBANK USA 1.850 29266NX93 2,306.16 392172787 CERTIFICATE OF DEPOSIT 01/28/2021 07/28/2016 Receipt MEDALLION BANK UTAH 1.400 250,000.00000 58403B4S2 (250,028.77) 392178542 CERTIFICATE OF DEPOSIT 07/26/2021 100.000000 07/29/2016 Int-Adj INTL BK RECON & DEVELOP 1.250 459058EV1 (2.78) 392172905 07/26/19 07/26/2019 07/29/2016 Receipt WESTERN STATE BANK 1.400 250,000.00000 95960NJN8 (250,000.00) 392178610 CERTIFICATE OF DEPOSIT 07/29/2021 100.000000 Net Activity 1,699,772.35