Loading...
09-11-2018 CC Rpt 12COUNCIL AGENDA STAFF REPORTCOUNCIL AGENDA STAFF REPORT TO: HONORABLE MAYOR AND CITY COUNCIL MEMBERS DATE: SEPTEMBER 11, 2018 FROM: CITY MANAGER ITEM NO:12 SUBJECT:INVESTMENT REPORT FOR JULY 2018 RECOMMENDATION: Receive and file the Investment Report for the month ended July 31, 2018. BACKGROUND/ANALYSIS: The Investment Report presents the City's cash and investments for the month ended July 31, 2018. This report is in compliance with California Government Code Section 53646 regarding the reporting of detailed information on all securities, investments, and monies of the City, as well as reporting of the market value of the investments held. All of the investments contained within the portfolio are in full compliance with Government Code Section 53601 and the City's Investment Policy as to the types of investments allowed. The Fiscal Year 2018-19 Investment Policy was last revised and adopted by the City Council on May 8, 2018. As stated in the attached report, there are sufficient funds to meet the budgeted expenditures over the next six months. The City's Investment Policy has set primary goals of the portfolio management of safety, liquidity, and yield. The City currently utilizes Chandler Asset Management who uses an active investment management approach in which securities are purchased but not necessarily held to maturity, and may be actively traded based on market conditions and the City's investment goals. The City's cash flow requirements are evaluated on an ongoing basis with short-term needs accommodated through the City's pooled investment funds with the Los Angeles County Investment Pool (LACIP) and the State of California Local Agency Investment Fund (LAIF). On July 31, 2018, the City's investment portfolio had a market value of $231,952,594. ENVIRONMENTAL (CEQA) REVIEW: This proposed action is exempt from review under the California Environmental Quality Act (California Public Resources Code §§ 21000, et seq., "CEQA") and CEQA Guidelines (Title 14 California Code of Regulations §§ 15000, et seq.) because it does not involve any commitment to a specific project which could result in a potentially significant physical impact on the environment; and constitutes an organizational or administrative activity that will not result in direct or indirect physical changes in the environment. Accordingly, this action does not constitute a "project" that requires environmental review (see specifically 14 CCR § 15378(b)(4-5)). FISCAL IMPACT: None. 38/131 REVIEWED BY OTHERS: None. Respectfully Submitted,Recommended By: Attachments July 2018 Investment Report 39/131 40/131 Attachment No. 1 Description Cost Value Market Value Maturity Date % of Portfolio Funds Held by Fiscal Agents US Bank CHFA Water Revenue Bonds Series 2012 Bond Fund First American Treasury Obligations Fund Class D 1,486$ 1,486$ 1.33%n/a 0.00% CHFA Water Revenue Bonds Series 2012 Reserve Fund U.S Bank N.A. Certificate of Deposit 1,120,375 1,120,375 1.26%9/5/2018 0.48% CHFA Water Revenue Bonds Series 2012 Acquisition Fund First American Treasury Obligations Fund Class D 479,139 479,139 1.33%n/a 0.21% CHFA Water Revenue Bonds Series 2012 Interest Account First American Treasury Obligations Fund Class D 6 6 1.27%n/a 0.00% CHFA Water Revenue Bonds Series 2012 Principal Account First American Treasury Obligations Fund Class D 62 62 1.33%n/a 0.00% CHFA Revenue Bonds CFD #1 Rolling Ridge Bond Fund First American Treasury Obligations Fund Class D 4 4 1.40%n/a 0.00% CHFA Revenue Bonds CFD #1 Rolling Ridge Reserve U.S Bank N.A. Certificate of Deposit 721,576 721,576 1.26%9/5/2018 0.31% CHFA Revenue Bonds CFD #2 Los Ranchos Bond Fund First American Treasury Obligations Fund Class D 14 14 1.35%n/a 0.00% CHFA Revenue Bonds CFD #2 Los Ranchos Reserve Fund U.S Bank N.A. Certificate of Deposit 1,676,714 1,676,714 1.26%9/5/2018 0.72% CHFA Revenue Bonds CFD #4 Oaks Area Bond Fund First American Treasury Obligations Fund Class D 178,189 178,189 1.33%n/a 0.08% CHFA Revenue Bonds CFD #5 Soquel Canyon Bond Fund First American Treasury Obligations Fund Class D 41 41 1.33%n/a 0.00% CHFA Revenue Bonds CFD #5 Soquel Canyon Reserve U.S Bank N.A. Certificate of Deposit 1,999,913 1,999,913 1.26%9/5/2018 0.86% CFD #6 (Carbon Canyon Area) Special Tax Series 2006 Bond Fund First American Treasury Obligations Fund Class D 2 2 1.44%n/a 0.00% CFD #6 (Carbon Canyon Area) Special Tax Series 2006 Reserve U.S Bank N.A. Certificate of Deposit 185,340 185,340 1.26%9/5/2018 0.08% CHFA Revenue Bonds CFD #8 (Butterfield Area) Bond Fund First American Treasury Obligations Fund Class D 79,061 79,061 1.33%n/a 0.03% Reassessment District 10-1 LOIB Redemption First American Treasury Obligations Fund Class D 13 13 1.33%n/a 0.00% Reassessment District 10-1 LOIB Reserve U.S Bank N.A. Certificate of Deposit 296,143 296,143 1.26%9/5/2018 0.13% CFD #9 (Rincon Village Area) Special Tax Refunding Series 2011 Bond First American Treasury Obligations Fund Class D 1 1 1.65%n/a 0.00% CFD #9 (Rincon Village Area) Special Tax Refunding Series 2011 Reserve U.S Bank N.A. Certificate of Deposit 491,500 491,500 1.26%9/5/2018 0.21% CFD #9 (Rincon Village Area) Special Tax Refunding Series 2011 Interest First American Treasury Obligations Fund Class D 7 7 1.31%n/a 0.00% CFD #10 (Fairfield Ranch) Special Tax Refunding Series 2010 Improvement First American Treasury Obligations Fund Class D 133,619 133,619 1.33%n/a 0.06% CFD #10 (Fairfield Ranch) Special Tax Refunding Series 2010 Bond First American Treasury Obligations Fund Class D 5 5 1.30%n/a 0.00% CFD #10 (Fairfield Ranch) Special Tax Refunding Series 2010 Interest First American Treasury Obligations Fund Class D 33 33 1.33%n/a 0.00% CFD #10 (Fairfield Ranch) Special Tax Refunding Series 2010 Reserve U.S Bank N.A. Certificate of Deposit 981,750 981,750 1.26%9/5/2018 0.42% Total Funds Held by Fiscal Agents 8,344,993$ 8,344,993$ 3.59% Funds Held by Fiscal Agents Supplemental Interest/ Yield to Maturity 41/131 Monthly Account Statement (503) 464-3685 Christopher Isles US Bank CustodianChandler Team For questions about your account, please call (800) 317-4747 or Email operations@chandlerasset.com City of Chino Hills July 1, 2018 through July 31, 2018 Information contained herein is confidential. We urge you to compare this statement to the one you receive from your qualified custodian. Prices are provided by IDC, an independent pricing source. In the event IDC does not provide a price or if the price provided is not reflective of fair market value, Chandler will obtain pricing from an alternative approved third party pricing source in accordance with our written valuation policy and procedures. Our valuation procedures are also disclosed in Item 5 of our Form ADV Part 2A. 6225 Lusk Boulevard | San Diego, CA 92121 | Phone 800.317.4747 | Fax 858.546.3741 | www.chandlerasset.com 42/131 ACCOUNT SUMMARY Beg. Values as of 6/30/18 End Values as of 7/31/18 Market Value 189,101,573 189,273,387 Accrued Interest 921,127 774,279 Total Market Value 190,022,700 190,047,667 Income Earned 302,228 310,104 Cont/WD -11,273 Par 193,217,822 193,626,192 Book Value 192,637,620 193,043,766 Cost Value 192,471,011 192,859,019 TOP ISSUERS Issuer % Portfolio Government of United States 23.6 % Federal National Mortgage Assoc 17.5 % Federal Home Loan Mortgage Corp 11.7 % Federal Home Loan Bank 7.9 % John Deere ABS 3.0 % Toyota ABS 2.1 % State Street Bank 1.6 % Bank of Nova Scotia Houston 1.6 % 69.1 % PORTFOLIO CHARACTERISTICS Average Duration 2.35 Average Coupon 1.85 % Average Purchase YTM 1.97 % Average Market YTM 2.80 % Average S&P/Moody Rating AA/Aa1 Average Final Maturity 2.60 yrs Average Life 2.46 yrs CREDIT QUALITY (S&P)MATURITY DISTRIBUTIONSECTOR ALLOCATION PERFORMANCE REVIEW Total Rate of Return Current Latest Year Annualized Since As of 7/31/2018 Month 3 Months To Date 1 Yr 3 Yrs 5 Yrs 10 Yrs 2/28/2011 2/28/2011 City of Chino Hills 0.02 %0.46 %-0.18 %-0.40 %0.77 %1.01 %N/A 1.00 %7.65 % ICE BAML 1-5 Yr US Treasury/Agency Index*-0.09 %0.38 %-0.33 %-0.70 %0.42 %0.76 %N/A 0.74 %5.59 % *ICE BAML 1-3 Yr US Treasury/Agency Index to 7/31/12 Portfolio Summary As of 7/31/2018 City of Chino Hills Account #10150 Execution Time: 8/1/2018 10:05:03 PMChandler Asset Management - CONFIDENTIAL Page 1 43/131 CategoryStandardCommentTreasury IssuesNo LimitationCompliesAgency Issues25% max per Agency/GSE issuer; 20% max agency callable securitiesCompliesSupranationals"AA" rated or better by a NRSRO; 30% maximum; 10% max per issuer; U.S. dollar denominated senior unsecured unsubordinated obligations issued or unconditionally guaranteed by the International Bank for Reconstruction and Development ("IBRD"), the International Finance Corporation ("IFC") or the Inter-American Development Bank ("IADB") CompliesMunicipal Issues"A" rated or better by a NRSRO; 30% maximum; 5% max per issuerCompliesBanker’s Acceptances"A1" short-term rated or better by a NRSRO; or "A" long-term debt rated or better by a NRSRO; 40% maximum; 5% max per issuer; 180 days max maturity Complies Commercial Paper "A-1" rated or better by a NRSRO; "A" long-term issuer rated or better by a NRSRO; 25% maximum; 5% max per issuer; 270 days max maturity; Issuer is a corporation organized and operating in the U.S. and have $500 million total assetsComplies Negotiable Certificates of Deposit No rating required if amount of the NCD is insured up to the FDIC limit; If above FDIC insured limit, requires "A-1" short-term or "A" long-term rated issuer or higher by a NRSRO; 30% maximum; (inclusive of CDARS); 5% max per issuerComplies Time Deposits (TD)/Certificates of Deposit (CD)20% maximum (combination of FDIC and Collateralized TDs/ CDs); For federally insured time deposits, amount per institution is limited to maximum covered under FDIC; Collateralized if in excess of insured amountsComplies Corporate Medium Term Notes "A" rated or better by a NRSRO; 30% maximum; 5% max per issuer; Issued by corporations organized and operating within the U.S. or by depository institutions licensed by the U.S. or any state and operating within the U.S. Complies Asset-Backed (ABS), Mortgage-Backed Securities; Pass-Throughs; CMOs"AA" rated or better by a NRSRO; "A" long-term debt issuer rated or better by a NRSRO; 20% maximum (combined ABS, MBS, MPTs, CMOs); 5% max per issuer; No issuer limitation where the issuer is the US Treasury or Federal Agency/GSE.Complies Mutual Fund & Money Market Mutual FundHighest rating or "AAA" rated by two NRSROs; SEC registered adviser with AUM >$500 million and experience > 5 years; 20% maximum in Mutual Funds and Money Market Mutual Funds; 10% max per one Mutual Fund; 20% max per one Money Market Mutual Fund CompliesLAIF Maximum amount permitted by LAIF CompliesLGIP Los Angles County Investment Pool (LACIP) CompliesRepurchase Agreements102% collateralized; 1 year max maturityCompliesProhibitedInverse floaters, Range notes, Mortgage-derived, Interest-only strips; Zero interest accrual securities; Reverse Repurchase Agreements; Foreign currency denominated securities CompliesMax Callables 20% maximum callable securities (does not include "make whole call" securities) CompliesMax Per Issuer 5% of portfolio (except U.S. Government, U.S. Agencies, Supranationals, Mutual Funds or Money Market Funds, LAIF, LACIP, or unless otherwise specified in the investment policy)CompliesMaximum maturity 5 yearsCompliesCity of Chino HillsJuly 31, 2018COMPLIANCE WITH INVESTMENT POLICYAssets managed by Chandler Asset Management are in full compliance with state law and the Client's investment policy.44/131 BOOK VALUE RECONCILIATION Beginning Book Value $192,637,620.43 Acquisition + Security Purchases $6,394,724.07 + Money Market Fund Purchases $3,284,237.97 + Money Market Contributions $0.00 + Security Contributions $0.00 + Security Transfers $0.00 Total Acquisitions $9,678,962.04 Dispositions - Security Sales $3,653,517.76 - Money Market Fund Sales $3,247,038.45 - MMF Withdrawals $11,273.30 - Security Withdrawals $0.00 - Security Transfers $0.00 - Other Dispositions $0.00 - Maturites $1,500,000.00 - Calls $0.00 - Principal Paydowns $837,556.34 Total Dispositions $9,249,385.85 Amortization/Accretion +/- Net Accretion $16,102.19 $16,102.19 Gain/Loss on Dispositions +/- Realized Gain/Loss ($39,533.24) ($39,533.24) Ending Book Value $193,043,765.57 CASH TRANSACTION SUMMARY BEGINNING BALANCE $224,263.92 Acquisition Contributions $0.00 Security Sale Proceeds $3,653,517.76 Accrued Interest Received $3,783.14 Interest Received $425,386.79 Dividend Received $809.14 Principal on Maturities $1,500,000.00 Interest on Maturities $22,901.67 Calls/Redemption (Principal)$0.00 Interest from Calls/Redemption $0.00 Principal Paydown $837,556.34 Total Acquisitions $6,443,954.84 Disposition Withdrawals $11,273.30 Security Purchase $6,394,724.07 Accrued Interest Paid $12,031.25 Total Dispositions $6,418,028.62 Ending Book Value $250,190.14 Reconciliation Summary As of 7/31/2018 City of Chino Hills Account #10150 Execution Time: 8/1/2018 10:05:03 PMChandler Asset Management - CONFIDENTIAL Page 3 45/131 Holdings Report As of 7/31/18 City of Chino Hills Account #10150 CUSIP Security Description Par Value/Units Purchase Date Book Yield Cost Value Book Value Mkt Price Mkt YTM Market Value Accrued Int. % of Port. Gain/Loss Moody/S&P Fitch Maturity Duration ABS 43814TAB8 Honda Auto Receivables 2017-1 A2 1.42% Due 7/22/2019 133,955.00 03/21/2017 1.43 % 133,951.80 133,953.66 99.89 2.61 % 133,813.29 52.84 0.07 % (140.37) Aaa / NR AAA 0.98 0.09 89238MAB4 Toyota Auto Receivables Owner 2017-A 1.42% Due 9/16/2019 291,537.46 03/07/2017 1.43 % 291,509.33 291,524.82 99.88 2.35 % 291,181.64 183.99 0.15 % (343.18) Aaa / AAA NR 1.13 0.13 47787XAB3 John Deere Owner Trust 2017-A A2 1.5% Due 10/15/2019 231,845.47 02/22/2017 1.50 % 231,844.54 231,845.04 99.86 2.48 % 231,531.16 154.56 0.12 % (313.88) Aaa / NR AAA 1.21 0.14 654747AB0 Nissan Auto Receivables 2017-A A2A 1.47% Due 1/15/2020 284,604.73 03/21/2017 1.47 % 284,603.27 284,603.97 99.77 2.56 % 283,949.12 185.94 0.15 % (654.85) Aaa / NR AAA 1.46 0.21 47788MAC4 John Deere Owner Trust 2016-A A3 1.36% Due 4/15/2020 451,012.77 02/23/2016 1.37 % 450,941.79 450,983.39 99.59 2.59 % 449,181.21 272.61 0.24 % (1,802.18) Aaa / NR AAA 1.71 0.33 47788BAB0 John Deere Owner Trust 2017-B A2A 1.59% Due 4/15/2020 1,434,406.72 Various 1.79 % 1,431,906.90 1,432,596.24 99.64 2.62 % 1,429,279.82 1,013.64 0.75 % (3,316.42) Aaa / NR AAA 1.71 0.35 89237RAB4 Toyota Auto Receivable 2017-C A2A 1.58% Due 7/15/2020 1,359,805.00 07/25/2017 1.59 % 1,359,792.08 1,359,796.44 99.51 2.64 % 1,353,151.79 954.89 0.71 % (6,644.65) Aaa / AAA NR 1.96 0.46 89238BAB8 Toyota Auto Receivables Owner 2018-A A2A 2.1% Due 10/15/2020 2,380,000.00 01/23/2018 2.12 % 2,379,756.76 2,379,801.57 99.64 2.63 % 2,371,508.95 2,221.33 1.25 % (8,292.62) Aaa / AAA NR 2.21 0.68 65478VAD9 NAROT 2016-B A3 1.32% Due 1/15/2021 1,863,834.85 12/06/2017 1.73 % 1,852,010.41 1,854,471.22 99.10 2.76 % 1,847,121.17 273.36 0.97 % (7,350.05) Aaa / NR AAA 2.46 0.62 43811BAC8 Honda Auto Receivables 2017-2 A3 1.68% Due 8/16/2021 2,250,000.00 04/27/2018 2.62 % 2,215,019.53 2,217,721.51 98.58 2.89 % 2,218,034.25 1,680.00 1.17 % 312.74 Aaa / AAA NR 3.05 1.18 47788BAD6 John Deere Owner Trust 2017-B A3 1.82% Due 10/15/2021 1,145,000.00 Various 2.73 % 1,132,937.25 1,133,502.16 98.50 2.97 % 1,127,788.36 926.18 0.59 % (5,713.80) Aaa / NR AAA 3.21 1.31 47788CAC6 John Deere Owner Trust 2016-B A4 2.66% Due 4/18/2022 620,000.00 02/21/2018 2.68 % 619,955.42 619,959.97 98.96 3.26 % 613,534.64 732.98 0.32 % (6,425.33) Aaa / NR AAA 3.72 1.78 02587AAJ3 American Express Credit 2017-1 1.93% Due 9/15/2022 925,000.00 06/21/2018 3.75 % 910,619.14 911,501.55 98.52 2.94 % 911,289.35 793.44 0.48 % (212.20) Aaa / NR AAA 4.13 1.49 47788EAC2 John Deere Owner Trust 2018-B A3 3.08% Due 11/15/2022 1,910,000.00 07/18/2018 3.10 % 1,909,855.22 1,909,855.86 99.87 3.16 % 1,907,519.67 980.47 1.00 % (2,336.19) Aaa / NR AAA 4.30 2.16 Total ABS 15,281,002.00 2.29 % 15,204,703.44 15,212,117.40 2.81 % 15,168,884.42 10,426.23 7.99 % (43,232.98) Aaa / AAA AAA 2.73 0.98 AGENCY 3137EAEB1 FHLMC Note 0.875% Due 7/19/2019 1,900,000.00 09/29/2016 0.97 % 1,894,908.00 1,898,246.20 98.51 2.44 % 1,871,758.40 554.17 0.99 % (26,487.80) Aaa / AA+ AAA 0.97 0.95 3137EADK2 FHLMC Note 1.25% Due 8/1/2019 2,225,000.00 Various 1.81 % 2,167,581.20 2,213,231.93 98.81 2.46 % 2,198,587.03 13,906.25 1.16 % (14,644.90) Aaa / AA+ AAA 1.00 0.98 3135G0ZG1 FNMA Note 1.75% Due 9/12/2019 1,900,000.00 10/07/2014 1.80 % 1,895,725.00 1,899,033.38 99.15 2.53 % 1,883,889.90 12,838.19 1.00 % (15,143.48) Aaa / AA+ AAA 1.12 1.09 3137EADM8 FHLMC Note 1.25% Due 10/2/2019 2,500,000.00 09/30/2015 1.31 % 2,494,100.00 2,498,277.99 98.52 2.54 % 2,462,987.50 10,329.86 1.30 % (35,290.49) Aaa / AA+ AAA 1.17 1.15 Execution Time: 8/1/2018 10:05:03 PMChandler Asset Management - CONFIDENTIAL Page 4 46/131 Holdings Report As of 7/31/18 City of Chino Hills Account #10150 CUSIP Security Description Par Value/Units Purchase Date Book Yield Cost Value Book Value Mkt Price Mkt YTM Market Value Accrued Int. % of Port. Gain/Loss Moody/S&P Fitch Maturity Duration AGENCY 3137EAEE5 FHLMC Note 1.5% Due 1/17/2020 3,150,000.00 02/14/2017 1.61 % 3,140,487.00 3,145,234.58 98.45 2.58 % 3,101,319.90 1,837.50 1.63 % (43,914.68) Aaa / AA+ AAA 1.47 1.43 3135G0A78 FNMA Note 1.625% Due 1/21/2020 3,500,000.00 12/08/2017 1.88 % 3,481,485.00 3,487,080.32 98.56 2.63 % 3,449,568.50 1,579.86 1.82 % (37,511.82) Aaa / AA+ AAA 1.48 1.44 3137EADR7 FHLMC Note 1.375% Due 5/1/2020 2,550,000.00 Various 1.59 % 2,525,807.60 2,540,867.17 97.78 2.68 % 2,493,397.65 8,765.63 1.32 % (47,469.52) Aaa / AA+ AAA 1.75 1.71 313383HU8 FHLB Note 1.75% Due 6/12/2020 2,500,000.00 09/15/2015 1.66 % 2,510,425.00 2,504,101.34 98.26 2.71 % 2,456,512.50 5,954.86 1.30 % (47,588.84) Aaa / AA+ NR 1.87 1.81 3135G0D75 FNMA Note 1.5% Due 6/22/2020 2,625,000.00 09/29/2015 1.49 % 2,626,417.50 2,625,567.16 97.83 2.68 % 2,568,097.88 4,265.63 1.35 % (57,469.28) Aaa / AA+ AAA 1.90 1.84 3137EAEK1 FHLMC Note 1.875% Due 11/17/2020 3,350,000.00 11/21/2017 1.96 % 3,341,319.58 3,343,324.59 98.05 2.76 % 3,284,584.55 12,911.46 1.74 % (58,740.04) Aaa / AA+ AAA 2.30 2.22 3135G0F73 FNMA Note 1.5% Due 11/30/2020 2,700,000.00 12/16/2015 1.90 % 2,648,970.00 2,675,979.25 97.17 2.76 % 2,623,492.80 6,862.50 1.38 % (52,486.45) Aaa / AA+ AAA 2.34 2.26 3130A7CV5 FHLB Note 1.375% Due 2/18/2021 2,235,000.00 02/17/2016 1.46 % 2,225,970.60 2,230,393.87 96.60 2.76 % 2,159,101.64 13,914.43 1.14 % (71,292.23) Aaa / AA+ AAA 2.56 2.46 3135G0J20 FNMA Note 1.375% Due 2/26/2021 3,500,000.00 Various 1.59 % 3,472,861.80 3,481,378.37 96.51 2.79 % 3,377,906.00 20,720.49 1.79 % (103,472.37) Aaa / AA+ AAA 2.58 2.48 3135G0K69 FNMA Note 1.25% Due 5/6/2021 2,875,000.00 Various 1.29 % 2,869,786.50 2,872,078.62 95.99 2.77 % 2,759,741.25 8,485.24 1.46 % (112,337.37) Aaa / AA+ AAA 2.77 2.68 313379RB7 FHLB Note 1.875% Due 6/11/2021 1,695,000.00 08/30/2017 1.67 % 1,707,780.30 1,704,677.84 97.32 2.86 % 1,649,531.63 4,414.06 0.87 % (55,146.21) Aaa / AA+ AAA 2.87 2.75 3130A8QS5 FHLB Note 1.125% Due 7/14/2021 2,800,000.00 07/22/2016 1.29 % 2,778,272.00 2,787,094.88 95.32 2.79 % 2,668,934.80 1,487.50 1.41 % (118,160.08) Aaa / AA+ AAA 2.96 2.87 3137EAEC9 FHLMC Note 1.125% Due 8/12/2021 3,200,000.00 09/26/2016 1.28 % 3,176,448.00 3,185,352.77 95.11 2.82 % 3,043,622.40 16,900.00 1.61 % (141,730.37) Aaa / AA+ AAA 3.04 2.93 3135G0N82 FNMA Note 1.25% Due 8/17/2021 3,200,000.00 09/28/2016 1.28 % 3,195,072.00 3,196,926.56 95.47 2.81 % 3,055,088.00 18,222.22 1.62 % (141,838.56) Aaa / AA+ AAA 3.05 2.94 3130AABG2 FHLB Note 1.875% Due 11/29/2021 3,375,000.00 02/27/2017 1.89 % 3,373,110.00 3,373,675.37 96.95 2.84 % 3,271,978.13 10,898.44 1.73 % (101,697.24) Aaa / AA+ AAA 3.33 3.18 3135G0S38 FNMA Note 2% Due 1/5/2022 3,400,000.00 Various 2.02 % 3,396,588.25 3,397,633.05 97.09 2.90 % 3,300,924.00 4,911.11 1.74 % (96,709.05) Aaa / AA+ AAA 3.44 3.28 3135G0T45 FNMA Note 1.875% Due 4/5/2022 3,485,000.00 06/19/2017 1.88 % 3,484,473.77 3,484,596.16 96.47 2.89 % 3,361,871.47 21,055.21 1.78 % (122,724.69) Aaa / AA+ AAA 3.68 3.50 3135G0T78 FNMA Note 2% Due 10/5/2022 3,500,000.00 12/08/2017 2.22 % 3,465,595.00 3,470,152.34 96.40 2.92 % 3,374,003.50 22,555.56 1.79 % (96,148.84) Aaa / AA+ AAA 4.18 3.94 3130A3KM5 FHLB Note 2.5% Due 12/9/2022 2,750,000.00 12/15/2017 2.25 % 2,782,010.00 2,778,028.57 98.22 2.94 % 2,701,110.50 9,930.56 1.43 % (76,918.07) Aaa / AA+ NR 4.36 4.08 3135G0T94 FNMA Note 2.375% Due 1/19/2023 3,500,000.00 04/11/2018 2.71 % 3,448,410.00 3,451,695.42 97.72 2.92 % 3,420,105.50 2,770.83 1.80 % (31,589.92) Aaa / AA+ AAA 4.47 4.20 Execution Time: 8/1/2018 10:05:03 PMChandler Asset Management - CONFIDENTIAL Page 5 47/131 Holdings Report As of 7/31/18 City of Chino Hills Account #10150 CUSIP Security Description Par Value/Units Purchase Date Book Yield Cost Value Book Value Mkt Price Mkt YTM Market Value Accrued Int. % of Port. Gain/Loss Moody/S&P Fitch Maturity Duration AGENCY 3137EAEN5 FHLMC Note 2.75% Due 6/19/2023 3,750,000.00 07/20/2018 2.86 % 3,731,175.00 3,731,269.55 99.06 2.96 % 3,714,693.75 14,322.92 1.96 % (16,575.80) Aaa / AA+ AAA 4.89 4.52 Total Agency 72,165,000.00 1.79 % 71,834,779.10 71,975,897.28 2.77 % 70,252,809.18 250,394.48 37.10 % (1,723,088.10) Aaa / AA+ AAA 2.75 2.63 MONEY MARKET FUND FI 31846V401 First American Govt Obligation MMKT Class-D 250,190.14 Various 1.35 % 250,190.14 250,190.14 1.00 1.35 % 250,190.14 0.00 0.13 % 0.00 Aaa / AAA AAA 0.00 0.00 Total Money Market Fund FI 250,190.14 1.35 % 250,190.14 250,190.14 1.35 % 250,190.14 0.00 0.13 % 0.00 Aaa / AAA AAA 0.00 0.00 NEGOTIABLE CD 06417GXH6 Bank of Nova Scotia Yankee CD 1.57% Due 8/9/2018 2,990,000.00 08/08/2017 1.57 % 2,990,000.00 2,990,000.00 100.00 1.57 % 2,990,000.00 46,551.81 1.60 % 0.00 P-1 / A-1 NR 0.02 0.02 06371ETT4 Bank of Montreal Chicago Yankee CD 1.76% Due 11/7/2018 2,760,000.00 11/06/2017 1.76 % 2,760,000.00 2,760,000.00 100.00 1.76 % 2,760,000.00 36,027.20 1.47 % 0.00 P-1 / A-1 F-1+ 0.27 0.27 Total Negotiable CD 5,750,000.00 1.66 % 5,750,000.00 5,750,000.00 1.66 % 5,750,000.00 82,579.01 3.07 % 0.00 P-1 / A-1 F-1+ 0.14 0.14 US CORPORATE 02665WAC5 American Honda Finance Note 2.125% Due 10/10/2018 1,770,000.00 Various 1.84 % 1,787,921.40 1,770,913.28 99.94 2.40 % 1,769,008.80 11,597.18 0.94 % (1,904.48) A2 / A+ NR 0.19 0.19 74005PBH6 Praxair Note 1.25% Due 11/7/2018 1,400,000.00 01/08/2015 1.68 % 1,377,978.00 1,398,451.82 99.63 2.64 % 1,394,806.00 4,083.33 0.74 % (3,645.82) A2 / A NR 0.27 0.26 91159HHE3 US Bancorp Callable Note Cont 10/15/2018 1.95% Due 11/15/2018 140,000.00 02/12/2014 1.90 % 140,296.80 140,013.09 99.84 2.49 % 139,780.76 576.33 0.07 % (232.33) A1 / A+ AA- 0.29 0.29 24422ESF7 John Deere Capital Corp Note 1.95% Due 12/13/2018 1,095,000.00 Various 1.78 % 1,100,497.65 1,095,662.94 99.79 2.52 % 1,092,687.36 2,847.00 0.58 % (2,975.58) A2 / A A 0.37 0.36 36962G7G3 General Electric Capital Corp Note 2.3% Due 1/14/2019 1,000,000.00 09/10/2015 1.93 % 1,011,900.00 1,001,623.17 99.87 2.58 % 998,747.00 1,086.11 0.53 % (2,876.17) A2 / A A 0.46 0.45 17275RAR3 Cisco Systems Note 2.125% Due 3/1/2019 2,230,000.00 Various 1.67 % 2,256,499.90 2,235,796.39 99.80 2.47 % 2,225,553.38 19,744.80 1.18 % (10,243.01) A1 / AA- NR 0.58 0.57 91159HHH6 US Bancorp Callable Note Cont 3/25/2019 2.2% Due 4/25/2019 1,700,000.00 Various 1.95 % 1,712,152.45 1,702,628.99 99.75 2.54 % 1,695,750.00 9,973.34 0.90 % (6,878.99) A1 / A+ AA- 0.73 0.72 40434CAC9 HSBC USA Inc Note 2.25% Due 6/23/2019 2,200,000.00 06/20/2017 1.99 % 2,211,242.00 2,205,020.40 99.55 2.76 % 2,190,058.20 5,225.00 1.16 % (14,962.20) A2 / A AA- 0.90 0.88 Execution Time: 8/1/2018 10:05:03 PMChandler Asset Management - CONFIDENTIAL Page 6 48/131 Holdings Report As of 7/31/18 City of Chino Hills Account #10150 CUSIP Security Description Par Value/Units Purchase Date Book Yield Cost Value Book Value Mkt Price Mkt YTM Market Value Accrued Int. % of Port. Gain/Loss Moody/S&P Fitch Maturity Duration US CORPORATE 06406HCW7 Bank of New York Callable Note Cont 8/11/2019 2.3% Due 9/11/2019 1,815,000.00 Various 2.19 % 1,822,288.25 1,816,917.23 99.44 2.82 % 1,804,768.85 16,234.16 0.96 % (12,148.38) A1 / A AA- 1.12 1.08 94974BGF1 Wells Fargo Corp Note 2.15% Due 1/30/2020 2,025,000.00 Various 2.15 % 2,024,153.60 2,025,024.11 98.66 3.07 % 1,997,935.88 120.93 1.05 % (27,088.23) A2 / A- A+ 1.50 1.46 22160KAG0 Costco Wholesale Corp Note 1.75% Due 2/15/2020 900,000.00 02/05/2015 1.77 % 899,055.00 899,708.31 98.36 2.85 % 885,258.90 7,262.50 0.47 % (14,449.41) A1 / A+ A+ 1.55 1.49 747525AD5 Qualcomm Inc Note 2.25% Due 5/20/2020 1,930,000.00 Various 2.36 % 1,918,856.25 1,926,605.82 98.47 3.13 % 1,900,384.16 8,564.38 1.00 % (26,221.66) A2 / A- NR 1.81 1.74 437076BQ4 Home Depot Note 1.8% Due 6/5/2020 875,000.00 05/24/2017 1.82 % 874,492.50 874,687.91 98.15 2.84 % 858,777.50 2,450.00 0.45 % (15,910.41) A2 / A A 1.85 1.79 857477AS2 State Street Bank Note 2.55% Due 8/18/2020 1,750,000.00 01/21/2016 2.17 % 1,778,420.00 1,762,760.00 99.10 3.01 % 1,734,176.50 20,205.21 0.92 % (28,583.50) A1 / A AA- 2.05 1.96 594918BG8 Microsoft Callable Note Cont. 10/03/20 2% Due 11/3/2020 1,025,000.00 Various 1.99 % 1,025,086.50 1,025,107.46 98.25 2.80 % 1,007,110.68 5,011.11 0.53 % (17,996.78) Aaa / AAA AA+ 2.26 2.18 00440EAT4 Chubb INA Holdings Inc Callable Note Cont 10/3/2020 2.3% Due 11/3/2020 2,475,000.00 Various 2.18 % 2,484,922.25 2,481,025.30 98.25 3.10 % 2,431,754.33 13,915.00 1.29 % (49,270.97) A3 / A A 2.26 2.17 92826CAB8 Visa Inc Note 2.2% Due 12/14/2020 1,800,000.00 Various 1.60 % 1,845,865.00 1,824,445.93 98.33 2.93 % 1,769,918.40 5,170.00 0.93 % (54,527.53) A1 / A+ NR 2.38 2.28 78012KKU0 Royal Bank of Canada Note 2.5% Due 1/19/2021 2,525,000.00 12/11/2017 2.37 % 2,534,569.75 2,532,618.64 98.06 3.32 % 2,476,116.00 2,104.17 1.30 % (56,502.64) Aa2 / AA- AA 2.47 2.37 30231GAV4 Exxon Mobil Corp Callable Note Cont 2/1/2021 2.222% Due 3/1/2021 1,795,000.00 Various 1.97 % 1,815,422.45 1,806,023.68 98.29 2.91 % 1,764,305.50 16,618.71 0.94 % (41,718.18) Aaa / AA+ NR 2.59 2.47 369550BE7 General Dynamics Corp Note 3% Due 5/11/2021 2,390,000.00 Various 3.25 % 2,373,224.70 2,374,404.79 99.57 3.16 % 2,379,651.30 15,933.34 1.26 % 5,246.51 A2 / A+ NR 2.78 2.63 22160KAJ4 Costco Wholesale Corp Note 2.15% Due 5/18/2021 1,000,000.00 08/14/2017 2.01 % 1,005,170.00 1,003,852.97 97.82 2.97 % 978,193.00 4,359.72 0.52 % (25,659.97) A1 / A+ A+ 2.80 2.68 857477AV5 State Street Bank Note 1.95% Due 5/19/2021 1,420,000.00 Various 2.33 % 1,403,476.60 1,405,460.71 96.84 3.14 % 1,375,191.90 5,538.00 0.73 % (30,268.81) A1 / A AA- 2.80 2.69 594918BP8 Microsoft Callable Note Cont 7/8/21 1.55% Due 8/8/2021 1,225,000.00 Various 1.57 % 1,223,545.75 1,224,121.56 96.03 2.93 % 1,176,362.60 9,124.54 0.62 % (47,758.96) Aaa / AAA AA+ 3.02 2.90 68389XBK0 Oracle Corp Callable Note Cont 8/01/21 1.9% Due 9/15/2021 2,565,000.00 Various 2.40 % 2,507,672.07 2,527,199.30 96.50 3.08 % 2,475,142.92 18,411.00 1.31 % (52,056.38) A1 / AA- A+ 3.13 2.98 24422ETL3 John Deere Capital Corp Note 2.65% Due 1/6/2022 1,750,000.00 09/21/2017 2.26 % 1,777,457.50 1,772,015.16 98.56 3.10 % 1,724,807.00 3,220.49 0.91 % (47,208.16) A2 / A A 3.44 3.24 89236TDP7 Toyota Motor Credit Corp Note 2.6% Due 1/11/2022 2,000,000.00 Various 3.04 % 1,968,104.46 1,971,292.42 97.73 3.30 % 1,954,670.00 2,888.89 1.03 % (16,622.42) Aa3 / AA- A 3.45 3.26 91159HHP8 US Bancorp Callable Cont 12/23/2021 2.625% Due 1/24/2022 1,000,000.00 01/19/2017 2.66 % 998,280.00 998,801.84 97.70 3.33 % 977,007.00 510.42 0.51 % (21,794.84) A1 / A+ AA- 3.49 3.29 Execution Time: 8/1/2018 10:05:03 PMChandler Asset Management - CONFIDENTIAL Page 7 49/131 Holdings Report As of 7/31/18 City of Chino Hills Account #10150 CUSIP Security Description Par Value/Units Purchase Date Book Yield Cost Value Book Value Mkt Price Mkt YTM Market Value Accrued Int. % of Port. Gain/Loss Moody/S&P Fitch Maturity Duration US CORPORATE 674599CK9 Occidental Petroleum Callable Note Cont 3/15/2022 2.6% Due 4/15/2022 2,350,000.00 06/18/2018 3.27 % 2,293,929.00 2,295,617.16 97.58 3.30 % 2,293,075.95 17,990.56 1.22 % (2,541.21) A3 / A A 3.71 3.47 69353RFE3 PNC Bank Callable Note Cont 6/28/2022 2.45% Due 7/28/2022 2,365,000.00 07/25/2017 2.45 % 2,364,787.15 2,364,830.16 96.34 3.44 % 2,278,419.72 482.85 1.20 % (86,410.44) A2 / A A+ 3.99 3.76 44932HAC7 IBM Credit Corp Note 2.2% Due 9/8/2022 2,400,000.00 Various 2.63 % 2,354,504.00 2,360,342.65 95.36 3.42 % 2,288,652.00 20,973.34 1.22 % (71,690.65) A1 / A+ A+ 4.11 3.84 48128BAB7 JP Morgan Chase & Co Callable Note 1X 1/15/2022 2.972% Due 1/15/2023 2,400,000.00 Various 3.23 % 2,372,445.00 2,374,878.37 97.51 3.58 % 2,340,350.40 3,170.14 1.23 % (34,527.97) A3 / A- AA- 4.46 4.12 02665WCJ8 American Honda Finance Note 3.45% Due 7/14/2023 755,000.00 07/11/2018 3.49 % 753,693.85 753,705.31 100.14 3.42 % 756,020.76 1,085.31 0.40 % 2,315.45 A2 / A+ NR 4.96 4.51 Total US Corporate 54,070,000.00 2.31 % 54,017,909.83 53,951,556.87 3.03 % 53,134,442.75 256,477.86 28.09 % (817,114.12) A1 / A+ A+ 2.36 2.24 US TREASURY 912828H52 US Treasury Note 1.25% Due 1/31/2020 2,400,000.00 Various 1.49 % 2,375,218.98 2,391,680.54 98.04 2.59 % 2,352,844.80 81.52 1.24 % (38,835.74) Aaa / AA+ AAA 1.50 1.47 912828J84 US Treasury Note 1.375% Due 3/31/2020 2,250,000.00 10/23/2015 1.35 % 2,252,204.80 2,250,828.50 97.96 2.64 % 2,204,032.50 10,397.03 1.17 % (46,796.00) Aaa / AA+ AAA 1.67 1.62 912828VF4 US Treasury Note 1.375% Due 5/31/2020 2,350,000.00 07/10/2015 1.62 % 2,323,478.58 2,340,054.47 97.71 2.66 % 2,296,114.50 5,473.70 1.21 % (43,939.97) Aaa / AA+ AAA 1.84 1.79 912828XM7 US Treasury Note 1.625% Due 7/31/2020 2,500,000.00 02/27/2017 1.57 % 2,504,695.88 2,502,744.59 97.96 2.68 % 2,448,925.00 110.39 1.29 % (53,819.59) Aaa / AA+ AAA 2.00 1.95 912828L32 US Treasury Note 1.375% Due 8/31/2020 3,500,000.00 12/11/2017 1.91 % 3,451,054.69 3,462,490.05 97.35 2.69 % 3,407,169.50 20,139.27 1.80 % (55,320.55) Aaa / AA+ AAA 2.09 2.02 912828L99 US Treasury Note 1.375% Due 10/31/2020 2,650,000.00 11/23/2015 1.71 % 2,608,499.12 2,631,079.47 97.10 2.71 % 2,573,089.05 9,208.39 1.36 % (57,990.42) Aaa / AA+ AAA 2.25 2.19 912828N89 US Treasury Note 1.375% Due 1/31/2021 3,200,000.00 Various 1.48 % 3,186,303.70 3,191,933.42 96.72 2.74 % 3,095,126.40 119.56 1.63 % (96,807.02) Aaa / AA+ AAA 2.51 2.43 912828B90 US Treasury Note 2% Due 2/28/2021 2,150,000.00 Various 1.55 % 2,194,878.30 2,174,160.44 98.14 2.75 % 2,110,106.75 17,994.57 1.12 % (64,053.69) Aaa / AA+ AAA 2.58 2.48 912828Q37 US Treasury Note 1.25% Due 3/31/2021 3,200,000.00 Various 1.59 % 3,155,350.56 3,171,918.86 96.17 2.75 % 3,077,376.00 13,442.62 1.63 % (94,542.86) Aaa / AA+ AAA 2.67 2.58 912828T34 US Treasury Note 1.125% Due 9/30/2021 3,200,000.00 11/09/2016 1.48 % 3,145,885.73 3,164,954.57 95.01 2.78 % 3,040,249.60 12,098.36 1.61 % (124,704.97) Aaa / AA+ AAA 3.17 3.06 912828F96 US Treasury Note 2% Due 10/31/2021 2,800,000.00 01/27/2017 1.94 % 2,807,337.51 2,805,019.96 97.55 2.79 % 2,731,531.60 14,152.17 1.44 % (73,488.36) Aaa / AA+ AAA 3.25 3.10 912828J43 US Treasury Note 1.75% Due 2/28/2022 3,610,000.00 03/13/2017 2.14 % 3,544,721.85 3,562,888.71 96.45 2.80 % 3,481,675.33 26,437.36 1.85 % (81,213.38) Aaa / AA+ AAA 3.58 3.41 Execution Time: 8/1/2018 10:05:03 PMChandler Asset Management - CONFIDENTIAL Page 8 50/131 Holdings Report As of 7/31/18 City of Chino Hills Account #10150 CUSIP Security Description Par Value/Units Purchase Date Book Yield Cost Value Book Value Mkt Price Mkt YTM Market Value Accrued Int. % of Port. Gain/Loss Moody/S&P Fitch Maturity Duration US TREASURY 912828XG0 US Treasury Note 2.125% Due 6/30/2022 3,600,000.00 08/15/2017 1.82 % 3,651,058.94 3,641,036.68 97.46 2.81 % 3,508,732.80 6,652.17 1.85 % (132,303.88) Aaa / AA+ AAA 3.92 3.72 912828L24 US Treasury Note 1.875% Due 8/31/2022 1,250,000.00 09/26/2017 1.87 % 1,250,541.30 1,250,448.63 96.36 2.82 % 1,204,492.50 9,808.08 0.64 % (45,956.13) Aaa / AA+ AAA 4.09 3.86 912828L57 US Treasury Note 1.75% Due 9/30/2022 3,600,000.00 10/17/2017 1.99 % 3,560,062.50 3,566,402.14 95.80 2.83 % 3,448,688.40 21,172.13 1.83 % (117,713.74) Aaa / AA+ AAA 4.17 3.95 912828N30 US Treasury Note 2.125% Due 12/31/2022 3,850,000.00 01/25/2018 2.46 % 3,790,144.53 3,796,362.85 97.06 2.84 % 3,736,906.25 7,114.13 1.97 % (59,456.60) Aaa / AA+ AAA 4.42 4.17 Total US Treasury 46,110,000.00 1.78 % 45,801,436.97 45,904,003.88 2.75 % 44,717,060.98 174,401.45 23.62 % (1,186,942.90) Aaa / AA+ AAA 2.94 2.81 TOTAL PORTFOLIO 193,626,192.14 1.97 % 192,859,019.48 193,043,765.57 2.80 % 189,273,387.47 774,279.03 100.00 % (3,770,378.10) Aa1 / AA AAA 2.60 2.35 TOTAL MARKET VALUE PLUS ACCRUED 190,047,666.50 Execution Time: 8/1/2018 10:05:03 PMChandler Asset Management - CONFIDENTIAL Page 9 51/131 Transaction Ledger 6/30/18 Thru 7/31/18 City of Chino Hills Account #10150 Transaction Type Settlement Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase 07/02/2018 31846V401 809.14 First American Govt Obligation MMKT Class-D 1.000 1.35 %809.14 0.00 809.14 0.00 Purchase 07/05/2018 31846V401 34,000.00 First American Govt Obligation MMKT Class-D 1.000 1.35 %34,000.00 0.00 34,000.00 0.00 Purchase 07/06/2018 31846V401 23,187.50 First American Govt Obligation MMKT Class-D 1.000 1.35 %23,187.50 0.00 23,187.50 0.00 Purchase 07/11/2018 31846V401 26,000.00 First American Govt Obligation MMKT Class-D 1.000 1.35 %26,000.00 0.00 26,000.00 0.00 Purchase 07/13/2018 31846V401 497,584.03 First American Govt Obligation MMKT Class-D 1.000 1.35 %497,584.03 0.00 497,584.03 0.00 Purchase 07/14/2018 31846V401 27,250.00 First American Govt Obligation MMKT Class-D 1.000 1.35 %27,250.00 0.00 27,250.00 0.00 Purchase 07/15/2018 31846V401 35,664.00 First American Govt Obligation MMKT Class-D 1.000 1.35 %35,664.00 0.00 35,664.00 0.00 Purchase 07/16/2018 02665WCJ8 755,000.00 American Honda Finance Note 3.45% Due 7/14/2023 99.827 3.49 %753,693.85 0.00 753,693.85 0.00 Purchase 07/16/2018 31846V401 1,487.71 First American Govt Obligation MMKT Class-D 1.000 1.35 %1,487.71 0.00 1,487.71 0.00 Purchase 07/16/2018 31846V401 3,150.00 First American Govt Obligation MMKT Class-D 1.000 1.35 %3,150.00 0.00 3,150.00 0.00 Purchase 07/16/2018 31846V401 55,583.21 First American Govt Obligation MMKT Class-D 1.000 1.35 %55,583.21 0.00 55,583.21 0.00 Purchase 07/16/2018 31846V401 132,109.01 First American Govt Obligation MMKT Class-D 1.000 1.35 %132,109.01 0.00 132,109.01 0.00 Purchase 07/16/2018 31846V401 1,736.58 First American Govt Obligation MMKT Class-D 1.000 1.35 %1,736.58 0.00 1,736.58 0.00 Purchase 07/16/2018 31846V401 1,374.33 First American Govt Obligation MMKT Class-D 1.000 1.35 %1,374.33 0.00 1,374.33 0.00 Purchase 07/16/2018 31846V401 47,885.88 First American Govt Obligation MMKT Class-D 1.000 1.35 %47,885.88 0.00 47,885.88 0.00 Purchase 07/16/2018 31846V401 51,810.00 First American Govt Obligation MMKT Class-D 1.000 1.35 %51,810.00 0.00 51,810.00 0.00 Purchase 07/16/2018 31846V401 137,850.19 First American Govt Obligation MMKT Class-D 1.000 1.35 %137,850.19 0.00 137,850.19 0.00 Purchase 07/16/2018 31846V401 38,081.66 First American Govt Obligation MMKT Class-D 1.000 1.35 %38,081.66 0.00 38,081.66 0.00 Purchase 07/16/2018 31846V401 122,003.18 First American Govt Obligation MMKT Class-D 1.000 1.35 %122,003.18 0.00 122,003.18 0.00 Purchase 07/16/2018 31846V401 4,165.00 First American Govt Obligation MMKT Class-D 1.000 1.35 %4,165.00 0.00 4,165.00 0.00 Execution Time: 8/1/2018 10:05:03 PMChandler Asset Management - CONFIDENTIAL Page 10 52/131 Transaction Ledger 6/30/18 Thru 7/31/18 City of Chino Hills Account #10150 Transaction Type Settlement Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase 07/16/2018 31846V401 84,383.65 First American Govt Obligation MMKT Class-D 1.000 1.35 %84,383.65 0.00 84,383.65 0.00 Purchase 07/17/2018 31846V401 23,625.00 First American Govt Obligation MMKT Class-D 1.000 1.35 %23,625.00 0.00 23,625.00 0.00 Purchase 07/18/2018 31846V401 103,701.66 First American Govt Obligation MMKT Class-D 1.000 1.35 %103,701.66 0.00 103,701.66 0.00 Purchase 07/19/2018 31846V401 85,763.89 First American Govt Obligation MMKT Class-D 1.000 1.35 %85,763.89 0.00 85,763.89 0.00 Purchase 07/20/2018 31846V401 1,522,901.67 First American Govt Obligation MMKT Class-D 1.000 1.35 %1,522,901.67 0.00 1,522,901.67 0.00 Purchase 07/21/2018 31846V401 28,437.50 First American Govt Obligation MMKT Class-D 1.000 1.35 %28,437.50 0.00 28,437.50 0.00 Purchase 07/23/2018 3137EAEN5 3,750,000.00 FHLMC Note 2.75% Due 6/19/2023 99.498 2.86 %3,731,175.00 12,031.25 3,743,206.25 0.00 Purchase 07/23/2018 31846V401 72,515.68 First American Govt Obligation MMKT Class-D 1.000 1.35 %72,515.68 0.00 72,515.68 0.00 Purchase 07/24/2018 31846V401 13,125.00 First American Govt Obligation MMKT Class-D 1.000 1.35 %13,125.00 0.00 13,125.00 0.00 Purchase 07/25/2018 47788EAC2 1,910,000.00 John Deere Owner Trust 2018-B A3 3.08% Due 11/15/2022 99.992 3.10 %1,909,855.22 0.00 1,909,855.22 0.00 Purchase 07/28/2018 31846V401 28,971.25 First American Govt Obligation MMKT Class-D 1.000 1.35 %28,971.25 0.00 28,971.25 0.00 Purchase 07/30/2018 31846V401 21,768.75 First American Govt Obligation MMKT Class-D 1.000 1.35 %21,768.75 0.00 21,768.75 0.00 Purchase 07/31/2018 31846V401 57,312.50 First American Govt Obligation MMKT Class-D 1.000 1.35 %57,312.50 0.00 57,312.50 0.00 Subtotal 9,699,237.97 9,678,962.04 12,031.25 9,690,993.29 0.00 Short Sale 07/16/2018 31846V401 -753,693.85 First American Govt Obligation MMKT Class-D 1.000 -753,693.85 0.00 -753,693.85 0.00 Short Sale 07/25/2018 31846V401 -1,909,855.22 First American Govt Obligation MMKT Class-D 1.000 -1,909,855.22 0.00 -1,909,855.22 0.00 Subtotal -2,663,549.07 -2,663,549.07 0.00 -2,663,549.07 0.00 TOTAL ACQUISITIONS 7,035,688.90 7,015,412.97 12,031.25 7,027,444.22 0.00 DISPOSITIONS Closing Purchase 07/16/2018 31846V401 -753,693.85 First American Govt Obligation MMKT Class-D 1.000 -753,693.85 0.00 -753,693.85 0.00 Execution Time: 8/1/2018 10:05:03 PMChandler Asset Management - CONFIDENTIAL Page 11 53/131 Transaction Ledger 6/30/18 Thru 7/31/18 City of Chino Hills Account #10150 Transaction Type Settlement Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/Sold Total Amount Gain/Loss DISPOSITIONS Closing Purchase 07/25/2018 31846V401 -1,909,855.22 First American Govt Obligation MMKT Class-D 1.000 -1,909,855.22 0.00 -1,909,855.22 0.00 Subtotal -2,663,549.07 -2,663,549.07 0.00 -2,663,549.07 0.00 Sale 07/13/2018 3135G0ZE6 500,000.00 FNMA Note 1.75% Due 6/20/2019 99.405 2.40 %497,025.00 559.03 497,584.03 -3,852.08 Sale 07/16/2018 31846V401 753,693.85 First American Govt Obligation MMKT Class-D 1.000 1.35 %753,693.85 0.00 753,693.85 0.00 Sale 07/23/2018 3135G0ZE6 1,400,000.00 FNMA Note 1.75% Due 6/20/2019 99.398 2.42 %1,391,572.00 2,245.83 1,393,817.83 -10,812.01 Sale 07/23/2018 3137EAEB1 1,200,000.00 FHLMC Note 0.875% Due 7/19/2019 98.487 2.43 %1,181,844.00 116.67 1,181,960.67 -17,020.02 Sale 07/23/2018 31846V401 583,489.38 First American Govt Obligation MMKT Class-D 1.000 1.35 %583,489.38 0.00 583,489.38 0.00 Sale 07/23/2018 912828UB4 595,000.00 US Treasury Note 1% Due 11/30/2019 97.996 2.51 %583,076.76 861.61 583,938.37 -7,849.13 Sale 07/25/2018 31846V401 1,909,855.22 First American Govt Obligation MMKT Class-D 1.000 1.35 %1,909,855.22 0.00 1,909,855.22 0.00 Subtotal 6,942,038.45 6,900,556.21 3,783.14 6,904,339.35 -39,533.24 Paydown 07/16/2018 02587AAJ3 0.00 American Express Credit 2017-1 1.93% Due 9/15/2022 100.000 0.00 1,487.71 1,487.71 0.00 Paydown 07/16/2018 43811BAC8 0.00 Honda Auto Receivables 2017-2 A3 1.68% Due 8/16/2021 100.000 0.00 3,150.00 3,150.00 0.00 Paydown 07/16/2018 47787XAB3 55,224.37 John Deere Owner Trust 2017-A A2 1.5% Due 10/15/2019 100.000 55,224.37 358.84 55,583.21 0.00 Paydown 07/16/2018 47788BAB0 130,036.12 John Deere Owner Trust 2017-B A2A 1.59% Due 4/15/2020 100.000 130,036.12 2,072.89 132,109.01 0.00 Paydown 07/16/2018 47788BAD6 0.00 John Deere Owner Trust 2017-B A3 1.82% Due 10/15/2021 100.000 0.00 1,736.58 1,736.58 0.00 Paydown 07/16/2018 47788CAC6 0.00 John Deere Owner Trust 2016-B A4 2.66% Due 4/18/2022 100.000 0.00 1,374.33 1,374.33 0.00 Paydown 07/16/2018 47788MAC4 47,321.10 John Deere Owner Trust 2016-A A3 1.36% Due 4/15/2020 100.000 47,321.10 564.78 47,885.88 0.00 Paydown 07/16/2018 654747AB0 51,398.40 Nissan Auto Receivables 2017-A A2A 1.47% Due 1/15/2020 100.000 51,398.40 411.60 51,810.00 0.00 Execution Time: 8/1/2018 10:05:03 PMChandler Asset Management - CONFIDENTIAL Page 12 54/131 Transaction Ledger 6/30/18 Thru 7/31/18 City of Chino Hills Account #10150 Transaction Type Settlement Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/Sold Total Amount Gain/Loss DISPOSITIONS Paydown 07/16/2018 65478VAD9 135,650.76 NAROT 2016-B A3 1.32% Due 1/15/2021 100.000 135,650.76 2,199.43 137,850.19 0.00 Paydown 07/16/2018 89231LAB3 38,048.05 Toyota Auto Receivables Owner 2016-D 1.06% Due 5/15/2019 100.000 38,048.05 33.61 38,081.66 0.00 Paydown 07/16/2018 89237RAB4 120,054.70 Toyota Auto Receivable 2017-C A2A 1.58% Due 7/15/2020 100.000 120,054.70 1,948.48 122,003.18 0.00 Paydown 07/16/2018 89238BAB8 0.00 Toyota Auto Receivables Owner 2018-A A2A 2.1% Due 10/15/2020 100.000 0.00 4,165.00 4,165.00 0.00 Paydown 07/16/2018 89238MAB4 83,939.34 Toyota Auto Receivables Owner 2017-A 1.42% Due 9/16/2019 100.000 83,939.34 444.31 84,383.65 0.00 Paydown 07/18/2018 43814RAB2 103,611.86 Honda Auto Receivables 2016-4 A2 1.04% Due 4/18/2019 100.000 103,611.86 89.80 103,701.66 0.00 Paydown 07/23/2018 43814TAB8 72,271.64 Honda Auto Receivables 2017-1 A2 1.42% Due 7/22/2019 100.000 72,271.64 244.04 72,515.68 0.00 Subtotal 837,556.34 837,556.34 20,281.40 857,837.74 0.00 Maturity 07/20/2018 96121T3U0 1,500,000.00 Westpac Banking Corp Yankee CD 1.51% Due 7/20/2018 100.000 1,500,000.00 22,901.67 1,522,901.67 0.00 Subtotal 1,500,000.00 1,500,000.00 22,901.67 1,522,901.67 0.00 Security Withdrawal 07/05/2018 31846V401 11,169.13 First American Govt Obligation MMKT Class-D 1.000 11,169.13 0.00 11,169.13 0.00 Security Withdrawal 07/25/2018 31846V401 104.17 First American Govt Obligation MMKT Class-D 1.000 104.17 0.00 104.17 0.00 Subtotal 11,273.30 11,273.30 0.00 11,273.30 0.00 TOTAL DISPOSITIONS 6,627,319.02 6,585,836.78 46,966.21 6,632,802.99 -39,533.24 OTHER TRANSACTIONS Interest 07/05/2018 3135G0S38 3,400,000.00 FNMA Note 2% Due 1/5/2022 0.000 34,000.00 0.00 34,000.00 0.00 Interest 07/06/2018 24422ETL3 1,750,000.00 John Deere Capital Corp Note 2.65% Due 1/6/2022 0.000 23,187.50 0.00 23,187.50 0.00 Interest 07/11/2018 89236TDP7 2,000,000.00 Toyota Motor Credit Corp Note 2.6% Due 1/11/2022 0.000 26,000.00 0.00 26,000.00 0.00 Interest 07/14/2018 3130A8QS5 2,800,000.00 FHLB Note 1.125% Due 7/14/2021 0.000 15,750.00 0.00 15,750.00 0.00 Execution Time: 8/1/2018 10:05:03 PMChandler Asset Management - CONFIDENTIAL Page 13 55/131 Transaction Ledger 6/30/18 Thru 7/31/18 City of Chino Hills Account #10150 Transaction Type Settlement Date CUSIP Quantity Security Description Price Acq/Disp Yield Amount Interest Pur/Sold Total Amount Gain/Loss OTHER TRANSACTIONS Interest 07/14/2018 36962G7G3 1,000,000.00 General Electric Capital Corp Note 2.3% Due 1/14/2019 0.000 11,500.00 0.00 11,500.00 0.00 Interest 07/15/2018 48128BAB7 2,400,000.00 JP Morgan Chase & Co Callable Note 1X 1/15/2022 2.972% Due 1/15/2023 0.000 35,664.00 0.00 35,664.00 0.00 Interest 07/17/2018 3137EAEE5 3,150,000.00 FHLMC Note 1.5% Due 1/17/2020 0.000 23,625.00 0.00 23,625.00 0.00 Interest 07/19/2018 3135G0T94 3,500,000.00 FNMA Note 2.375% Due 1/19/2023 0.000 40,638.89 0.00 40,638.89 0.00 Interest 07/19/2018 3137EAEB1 3,100,000.00 FHLMC Note 0.875% Due 7/19/2019 0.000 13,562.50 0.00 13,562.50 0.00 Interest 07/19/2018 78012KKU0 2,525,000.00 Royal Bank of Canada Note 2.5% Due 1/19/2021 0.000 31,562.50 0.00 31,562.50 0.00 Interest 07/21/2018 3135G0A78 3,500,000.00 FNMA Note 1.625% Due 1/21/2020 0.000 28,437.50 0.00 28,437.50 0.00 Interest 07/24/2018 91159HHP8 1,000,000.00 US Bancorp Callable Cont 12/23/2021 2.625% Due 1/24/2022 0.000 13,125.00 0.00 13,125.00 0.00 Interest 07/28/2018 69353RFE3 2,365,000.00 PNC Bank Callable Note Cont 6/28/2022 2.45% Due 7/28/2022 0.000 28,971.25 0.00 28,971.25 0.00 Interest 07/30/2018 94974BGF1 2,025,000.00 Wells Fargo Corp Note 2.15% Due 1/30/2020 0.000 21,768.75 0.00 21,768.75 0.00 Interest 07/31/2018 912828H52 2,400,000.00 US Treasury Note 1.25% Due 1/31/2020 0.000 15,000.00 0.00 15,000.00 0.00 Interest 07/31/2018 912828N89 3,200,000.00 US Treasury Note 1.375% Due 1/31/2021 0.000 22,000.00 0.00 22,000.00 0.00 Interest 07/31/2018 912828XM7 2,500,000.00 US Treasury Note 1.625% Due 7/31/2020 0.000 20,312.50 0.00 20,312.50 0.00 Subtotal 42,615,000.00 405,105.39 0.00 405,105.39 0.00 Dividend 07/02/2018 31846V401 224,263.92 First American Govt Obligation MMKT Class-D 0.000 809.14 0.00 809.14 0.00 Subtotal 224,263.92 809.14 0.00 809.14 0.00 TOTAL OTHER TRANSACTIONS 42,839,263.92 405,914.53 0.00 405,914.53 0.00 Execution Time: 8/1/2018 10:05:03 PMChandler Asset Management - CONFIDENTIAL Page 14 56/131 Cash And Equivalents 212,315.28 212,315.28 3.06Mutual Funds-Equity 3,550,516.62 3,087,466.25 51.04Mutual Funds-Fixed Income 3,192,969.43 3,233,824.45 45.90Accrued Income345.72345.72 0.00 00300101 40- -01-B -62 -218-010102 -19-00748-01PARS/CITY OF CHINO HILLS 115P Page 5 of 19ACCOUNT 6746053100 Period from July 1, 2018 to July 31, 201807/31/201807/31/2018 % OFASSETSMARKET BOOK VALUE MARKETTotal Assets 6,955,801.33 6,533,605.98 100.00Grand Total 6,956,147.05 6,533,951.70 100.00Estimated Annual Income 152,561.12ASSET SUMMARYCASH EQUIV & ACCRMUTUAL FUNDS57/131 1010101010101010101010111101010111011011101000010001100000101001110101010001010110010010011001000010100011101100000011011010001000010101110010010010110001010101110010000010011001101100101000010000010110000000111111000000101010001110111100111000001110000110010010100011001101111111100011000011110001001000100100000010000110100011110101101010110101101100101101011010111111111011101011111111111111111111First Am Govt 211,046.020 211,046.02 211,046.02.00 211,046.02345.72Ob Fd Cl Z1.0000.00.00 1.7831846V567 Asset Minor Code 1Cash1,269.261,269.261,269.26Ishares Core 3,687.000 1,044,453.36 880,310.89 164,142.47 1,007,734.42.00S P 500 Etf 283.280036,718.9436,718.94 1.79464287200 Asset Minor Code 94Ishares S P 2,084.000 350,487.12 279,275.6971,211.43 339,238.29.00500 Growth Etf 168.180011,248.8311,248.83 1.20464287309 Asset Minor Code 94Ishares S P 4,196.000 480,525.92 448,111.4032,414.52 462,882.11.00500 Value Etf 114.520017,643.8117,643.81 2.30464287408 Asset Minor Code 94 00300101 40- -01-B -62 -218-010102 -19-00748-01PARS/CITY OF CHINO HILLS 115P Page 6 of 19ACCOUNT 6746053100 Period from July 1, 2018 to July 31, 2018UNREALIZEDGAIN (LOSS) ADJ PRIOR MARKET /SHARES/MARKETSINCE INCEPTION/ ADJ PRIOR MARKET ENDING ACCRUALDESCRIPTIONFACE AMOUNTPRICE/UNIT BOOK VALUE CURRENT PERIOD UNREALIZED GAIN/LOSS YIELD ON MARKETMoney MarketsTotal Money Markets 211,046.020 211,046.02 211,046.02.00 211,046.02345.72.00.00 1.78CashTotal Cash.0001,269.261,269.26.001,269.26.00.00.00 0.00Total Cash And 211,046.020 212,315.28 212,315.28.00 212,315.28345.72Equivalents.00.00 1.76Mutual Funds-EquityASSET DETAILCash And EquivalentsMutual Funds58/131 Ishares Msci 6,801.000 468,452.88 413,973.3654,479.52 455,462.97.00Eafe Etf68.88004,693.2112,989.91 3.04464287465 Asset Minor Code 94Ishares 1,290.000 279,259.20 246,607.2932,651.91 274,201.38.00Russell Mid Cap Etf 216.48005,057.825,057.82 1.55464287499 Asset Minor Code 94Ishares 2,536.000 338,987.12 308,698.8830,288.24 334,549.12.00Russell 2000 Value Etf 133.67003,551.184,438.00 1.66464287630 Asset Minor Code 94Ishares 1,232.000 255,701.60 205,471.2350,230.37 251,734.56.00Russell 2000 Growth Etf 207.55001,150.683,967.04 0.62464287648 Asset Minor Code 94Vanguard Ftse 5,383.000 236,206.04 210,894.9525,311.09 227,289.09.00Emerging Markets Etf43.88008,916.958,916.95 2.50922042858 Asset Minor Code 94Vanguard Real 1,177.00096,443.3894,122.562,320.8295,866.65.00Estate Etf81.9400447.81576.73 4.34922908553 Asset Minor Code 94Ishares Core 24,991.000 2,650,545.46 2,684,555.43- 34,009.97 2,657,091.39.00U.S. Aggregate Bond Etf 106.0600- 6,545.93- 6,545.93 2.49464287226 Asset Minor Code 95Vanguard 51,906.600 542,423.97 549,269.02- 6,845.05 542,943.04.00Short Term Invt Grade #53910.4500- 519.07- 519.07 2.38922031836 Asset Minor Code 99 00300101 40- -01-B -62 -218-010102 -19-00748-01PARS/CITY OF CHINO HILLS 115P Page 7 of 19ACCOUNT 6746053100 Period from July 1, 2018 to July 31, 2018UNREALIZEDGAIN (LOSS) ADJ PRIOR MARKET /SHARES/MARKETSINCE INCEPTION/ ADJ PRIOR MARKET ENDING ACCRUALDESCRIPTIONFACE AMOUNTPRICE/UNIT BOOK VALUE CURRENT PERIOD UNREALIZED GAIN/LOSS YIELD ON MARKETTotal Mutual Funds-Equity 28,386.000 3,550,516.62 3,087,466.25 463,050.37 3,448,958.59.0089,429.23 101,558.03 1.96Mutual Funds-Fixed IncomeTotal Mutual Funds-Fixed 76,897.600 3,192,969.43 3,233,824.45- 40,855.02 3,200,034.43.00Income- 7,065.00- 7,065.00 2.47ASSET DETAIL (continued)59/131 1010101010101010101010111101010110011011101000010001100000101001110101010000110110010010011001001110100011101000000000011010001000010110000010010010110110100001110010000011000100101100101001100011010110000000111011010000101010000000101000111000001001011000010010100001000000001111100010010110010010001000100000011011101110101110110010110010110010000101111111011010111111111000001011111111111111111111Time of trade execution and trading party (if not disclosed) will be provided upon request.Publicly traded assets are valued in accordance with market quotations or valuation methodologies from financial industry services believed by us to be reliable. Assets that are notpublicly traded may be reflected at values from other external sources. Assets for which a current value is not available may be reflected at a previous value or as not valued, at par value,or at a nominal value. Values shown do not necessarily reflect prices at which assets could be bought or sold. Values are updated based on internal policy and may be updated lessfrequently than statement generation.For further information, please contact your account manager or relationship manager. 00300101 40- -01-B -62 -218-010102 -19-00748-01PARS/CITY OF CHINO HILLS 115P Page 8 of 19ACCOUNT 6746053100 Period from July 1, 2018 to July 31, 2018UNREALIZEDGAIN (LOSS) ADJ PRIOR MARKET /SHARES/MARKETSINCE INCEPTION/ ADJ PRIOR MARKET ENDING ACCRUALDESCRIPTIONFACE AMOUNTPRICE/UNIT BOOK VALUE CURRENT PERIOD UNREALIZED GAIN/LOSS YIELD ON MARKETTotal Mutual Funds 105,283.600 6,743,486.05 6,321,290.70 422,195.35 6,648,993.02.0082,364.2394,493.03 2.20Total Assets 316,329.620 6,955,801.33 6,533,605.98 422,195.35 6,861,308.30345.7282,364.2394,493.03 2.19Accrued Income.000345.72345.72Grand Total 316,329.620 6,956,147.05 6,533,951.70ASSET DETAIL (continued)ASSET DETAIL MESSAGES60/131 101010101010101010101011110101010101101110100001000110000010100111010101000001011001001001100100111010001110010000000001101000100001001001001001001011011011011111001000001111010100110010100100010011011000000010011100100010101001011101010011100000100011101101001010010100010010101110001110100010011000100010110001110111011011110011011100000011001111110101101101101011111111100010101111111111111111111107/02/2018 Interest From 6/1/18 To 6/30/18303.4607/02/2018 1.281212 USD/Share On 3,582 Shares Due 7/2/184,589.3007/09/2018 0.229163 USD/Share On 24,576 Shares Due 7/9/185,631.9107/10/2018 0.899778 USD/Share On 1,174 Shares Due 7/10/181,056.3407/10/2018 0.315209 USD/Share On 1,307 Shares Due 7/10/18411.9807/10/2018 0.629927 USD/Share On 2,623 Shares Due 7/10/181,652.3007/02/2018 0.480301 USD/Share On 2,034 Shares Due 7/2/18976.93 00300101 40- -01-B -62 -218-010102 -19-00748-01PARS/CITY OF CHINO HILLS 115P Page 10 of 19ACCOUNT 6746053100 Period from July 1, 2018 to July 31, 2018DATE DESCRIPTIONCASHInterestFirst Am Govt Ob Fd Cl Z31846V567Total Interest303.46DividendsIshares Core S P 500 Etf464287200Ishares Core U.S. Aggregate Bond Etf464287226Ishares Russell Mid Cap Etf464287499Ishares Russell 2000 Growth Etf464287648Ishares Russell 2000 Value Etf464287630Ishares S P 500 Growth Etf464287309Ishares S P 500 Value Etf464287408INVESTMENT ACTIVITY61/131 07/02/2018 0.713343 USD/Share On 3,902 Shares Due 7/2/182,783.4607/31/2018 Dividend From 7/1/18 To 7/31/181,269.2607/27/2018 Income Payments.06Interest Earned On Income Payments 00300101 40- -01-B -62 -218-010102 -19-00748-01PARS/CITY OF CHINO HILLS 115P Page 11 of 19ACCOUNT 6746053100 Period from July 1, 2018 to July 31, 2018DATE DESCRIPTIONCASHVanguard Short Term Invt Grade #539922031836Total Dividends18,371.48Other EarningsInterest-Bank CompensationTotal Other Earnings.06INVESTMENT ACTIVITY (continued)62/131 101010101010101010101011110101010001101110100001000110000010100111010101000111011001001001100100001010001110000000001101101000100001000110001001001011000100001111001000001010100000110010100011011111011000000010001101100010101001100100000011100000111110010101001010011100100101101110001011110100010100100010100000010001111011000111000001100011010001010000100101101011111111101100101111111111111111111107/26/2018 Collected- 1,794.66Charged For Period 06/01/2018 Thru 06/30/2018 00300101 40- -01-B -62 -218-010102 -19-00748-01PARS/CITY OF CHINO HILLS 115P Page 12 of 19ACCOUNT 6746053100 Period from July 1, 2018 to July 31, 2018DATE DESCRIPTIONCASHTrust FeesTrust FeesTotal Trust Fees- 1,794.66Total Trust Fees- 1,794.66Total Plan Expenses- 1,794.66PLAN EXPENSES63/131 07/30/2018 Paid To # 6746050100- 1,427.64Per Directive Dated 7/27/2018 00300101 40- -01-B -62 -218-010102 -19-00748-01PARS/CITY OF CHINO HILLS 115P Page 13 of 19ACCOUNT 6746053100 Period from July 1, 2018 to July 31, 2018DATE DESCRIPTIONCASHTransfers OutTransfer To Another AccountTotal Transfer To Another Account- 1,427.64Total Transfers Out- 1,427.64Total Other Activity- 1,427.64OTHER ACTIVITY64/131 101010101010101010101011110101001101101110100001000110000010100111010101000001011001001000100100111010001111110001000001101000100001000111001001001011011011100111001000001000111100110010100100001011011000000011100011100010101001011101011011100000110001001000001010001110110010101110001100000000001100100110011011101001111011101010100111111011010000010110101101101011001111100010101111111111111111111107/02/2018Purchased 8,349.690 .00 - 8,349.69 8,349.698,349.69 Units OfFirst Am Govt Ob Fd Cl ZTrade Date 7/2/1831846V56707/03/2018Purchased 303.46 303.460 .00 - 303.46 303.46Units OfFirst Am Govt Ob Fd Cl ZTrade Date 7/3/1831846V56707/05/2018Purchased 1,202.440 .00 - 1,202.44 1,202.441,202.44 Units OfFirst Am Govt Ob Fd Cl ZTrade Date 7/5/1831846V56707/09/2018Purchased 5,631.910 .00 - 5,631.91 5,631.915,631.91 Units OfFirst Am Govt Ob Fd Cl ZTrade Date 7/9/1831846V56707/10/2018Purchased 3,120.620 .00 - 3,120.62 3,120.623,120.62 Units OfFirst Am Govt Ob Fd Cl ZTrade Date 7/10/1831846V56707/30/2018Purchased 0.06 .060 .00 - .06 .06Units OfFirst Am Govt Ob Fd Cl ZTrade Date 7/30/1831846V567 00300101 40- -01-B -62 -218-010102 -19-00748-01PARS/CITY OF CHINO HILLS 115P Page 14 of 19ACCOUNT 6746053100 Period from July 1, 2018 to July 31, 2018SHARES/DATEDESCRIPTIONFACE AMOUNTCOMMISSIONCASHBOOK VALUECash And EquivalentsTotal First Am Govt Ob Fd Cl Z 18,608.180 .00 - 18,608.18 18,608.18Total Cash And Equivalents 18,608.180 .00 - 18,608.18 18,608.18PURCHASES65/131 07/17/2018Purchased 105 105.000 3.68 - 29,669.32 29,669.32Shares OfIshares Core S P 500 EtfTrade Date 7/17/18Purchased Through Sanford C. Bernstein & Co., Ll105 Shares At 282.5299 USD46428720007/17/2018Purchased 116 116.000 4.06 - 25,149.02 25,149.02Shares OfIshares Russell Mid Cap EtfTrade Date 7/17/18Purchased Through Sanford C. Bernstein & Co., Ll116 Shares At 216.7669 USD46428749907/17/2018Purchased 50 50.000 1.75 - 8,489.55 8,489.55Shares OfIshares S P 500 Growth EtfTrade Date 7/17/18Purchased Through Sanford C. Bernstein & Co., Ll50 Shares At 169.7559 USD46428730907/17/2018Purchased 294 294.000 10.29 - 33,154.85 33,154.85Shares OfIshares S P 500 Value EtfTrade Date 7/17/18Purchased Through Sanford C. Bernstein & Co., Ll294 Shares At 112.7366 USD464287408 00300101 40- -01-B -62 -218-010102 -19-00748-01PARS/CITY OF CHINO HILLS 115P Page 15 of 19ACCOUNT 6746053100 Period from July 1, 2018 to July 31, 2018SHARES/DATEDESCRIPTIONFACE AMOUNTCOMMISSIONCASHBOOK VALUEMutual Funds-EquityTotal Ishares Core S P 500 Etf 105.000 3.68 - 29,669.32 29,669.32Total Ishares Russell Mid Cap Etf 116.000 4.06 - 25,149.02 25,149.02Total Ishares S P 500 Growth Etf 50.000 1.75 - 8,489.55 8,489.55PURCHASES (continued)66/131 101010101010101010101011110101001001101110100001000110000010100111010101000111011001001000100100001010001111100001001101101000100001001000001001001011000100110111001000001101001000110010100011000111011000000011110010100010101001100100001011100000101100110000001010000110000101101110001001010110000000100110001010001111011011011110111010011011001110110011100101101011001111101100101111111111111111111107/17/2018 Purchased 164164.0005.74- 7,047.297,047.29Shares OfVanguard Ftse Emerging Markets EtfTrade Date 7/17/18Purchased Through Sanford C. Bernstein & Co., Ll164 Shares At 42.9363 USD92204285807/17/2018 Purchased 415415.00014.53- 44,171.0744,171.07Shares OfIshares Core U.S. Aggregate Bond EtfTrade Date 7/17/18Purchased Through Sanford C. Bernstein & Co., Ll415 Shares At 106.4013 USD46428722607/17/2018 Purchased 1,136.512.00- 11,887.9211,887.921,136.512 Shares OfVanguard Short Term Invt Grade #539Trade Date 7/17/181,136.512 Shares At 10.46 USD922031836 00300101 40- -01-B -62 -218-010102 -19-00748-01PARS/CITY OF CHINO HILLS 115P Page 16 of 19ACCOUNT 6746053100 Period from July 1, 2018 to July 31, 2018SHARES/DATE DESCRIPTIONFACE AMOUNT COMMISSIONCASH BOOK VALUETotal Ishares S P 500 Value Etf294.00010.29- 33,154.8533,154.85Total Vanguard Ftse Emerging Markets Etf164.0005.74- 7,047.297,047.29Total Mutual Funds-Equity729.00025.52 - 103,510.03 103,510.03Mutual Funds-Fixed IncomeTotal Ishares Core U.S. Aggregate Bond Etf415.00014.53- 44,171.0744,171.07Total Vanguard Short Term Invt Grade #539 1,136.512.00- 11,887.9211,887.92Total Mutual Funds-Fixed Income 1,551.51214.53- 56,058.9956,058.99Total Purchases 20,888.69240.05 - 178,177.20 178,177.20PURCHASES (continued)67/131 07/18/2018Sold - 11,887.920 .00 11,887.92 - 11,887.92 .00 - 11,887.9211,887.92 Units Of .00First Am Govt Ob Fd Cl ZTrade Date 7/18/1831846V56707/19/2018Sold - 20,809.110 .00 20,809.11 - 20,809.11 .00 - 20,809.1120,809.11 Units Of .00First Am Govt Ob Fd Cl ZTrade Date 7/19/1831846V56707/26/2018Sold - 1,794.660 .00 1,794.66 - 1,794.66 .00 - 1,794.661,794.66 Units Of .00First Am Govt Ob Fd Cl ZTrade Date 7/26/1831846V56707/30/2018Sold - 1,427.640 .00 1,427.64 - 1,427.64 .00 - 1,427.641,427.64 Units Of .00First Am Govt Ob Fd Cl ZTrade Date 7/30/1831846V567 00300101 40- -01-B -62 -218-010102 -19-00748-01PARS/CITY OF CHINO HILLS 115P Page 17 of 19ACCOUNT 6746053100 Period from July 1, 2018 to July 31, 2018PRIOR MARKET /SHARES/TRANSACTIONREALIZEDPRIOR MARKETDATEDESCRIPTIONFACE AMOUNTCOMMISSIONPROCEEDSBOOK VALUEGAIN/LOSSREALIZED GAIN/LOSSCash And EquivalentsTotal First Am Govt Ob Fd - 35,919.330 .00 35,919.33 - 35,919.33 .00 - 35,919.33Cl Z .00Total Cash And - 35,919.330 .00 35,919.33 - 35,919.33 .00 - 35,919.33Equivalents .00Mutual Funds-EquitySALES AND MATURITIES68/131 101010101010101010101011110101000101101110100001000110000010100111010101000101011001001000100100001010001111010001001101101000100001011001001001001011000101101111001000001110001110110010100001011001011000000010000011000010101000111011111011100000101010111100001010010110010111111110001110101101010000100110111010010110111010010110101101010011001001010001110101101011001111101110101111111111111111111107/17/2018 Sold 1,360 - 1,360.00047.6092,279.15- 82,782.509,496.65- 91,079.20Shares Of1,199.95Ishares Msci Eafe EtfTrade Date 7/17/18Sold Through Sanford C. Bernstein & Co., LlPaid 47.60 USD BrokeragePaid 1.20 USD Sec Fee1,360 Shares At 67.8882 USD46428746507/17/2018 Sold 75 - 75.0002.6315,880.67- 12,508.393,372.28- 15,324.75Shares Of555.92Ishares Russell 2000 Growth EtfTrade Date 7/17/18Sold Through Sanford C. Bernstein & Co., LlPaid 2.63 USD BrokeragePaid 0.21 USD Sec Fee75 Shares At 211.7801 USD46428764807/17/2018 Sold 87 - 87.0003.0511,625.51- 10,590.221,035.29- 11,477.04Shares Of148.47Ishares Russell 2000 Value EtfTrade Date 7/17/18Sold Through Sanford C. Bernstein & Co., LlPaid 3.05 USD BrokeragePaid 0.16 USD Sec Fee87 Shares At 133.6634 USD464287630 00300101 40- -01-B -62 -218-010102 -19-00748-01PARS/CITY OF CHINO HILLS 115P Page 18 of 19ACCOUNT 6746053100 Period from July 1, 2018 to July 31, 2018PRIOR MARKET /SHARES/TRANSACTIONREALIZED PRIOR MARKETDATE DESCRIPTION FACE AMOUNT COMMISSIONPROCEEDS BOOK VALUEGAIN/LOSS REALIZED GAIN/LOSSTotal Ishares Msci Eafe- 1,360.00047.6092,279.15- 82,782.509,496.65- 91,079.20Etf1,199.95Total Ishares Russell- 75.0002.6315,880.67- 12,508.393,372.28- 15,324.752000 Growth Etf555.92Total Ishares Russell- 87.0003.0511,625.51- 10,590.221,035.29- 11,477.042000 Value Etf148.47SALES AND MATURITIES (continued)69/131 Realizedgain/lossshouldnotbeusedfortaxpurposes.07/17/2018Sold 87 - 87.000 3.05 7,086.66 - 6,957.23 129.43 - 7,086.15Shares Of .51Vanguard Real Estate EtfTrade Date 7/17/18Sold Through Sanford C. Bernstein & Co., LlPaid 3.05 USD BrokeragePaid 0.09 USD Sec Fee87 Shares At 81.492 USD922908553 00300101 40- -01-B -62 -218-010102 -19-00748-01PARS/CITY OF CHINO HILLS 115P Page 19 of 19ACCOUNT 6746053100 Period from July 1, 2018 to July 31, 2018PRIOR MARKET /SHARES/TRANSACTIONREALIZEDPRIOR MARKETDATEDESCRIPTIONFACE AMOUNTCOMMISSIONPROCEEDSBOOK VALUEGAIN/LOSSREALIZED GAIN/LOSSTotal Vanguard Real - 87.000 3.05 7,086.66 - 6,957.23 129.43 - 7,086.15Estate Etf .51Total Mutual Funds-Equity - 1,609.000 56.33 126,871.99 - 112,838.34 14,033.65 - 124,967.14 1,904.85Total Sales And - 37,528.330 56.33 162,791.32 - 148,757.67 14,033.65 - 160,886.47Maturities 1,904.85SALES AND MATURITIES (continued)SALES AND MATURITIES MESSAGES70/131