Loading...
02-13-2018 CC Rpt 14COUNCIL AGENDA STAFF REPORTCOUNCIL AGENDA STAFF REPORT TO: HONORABLE MAYOR AND CITY COUNCIL MEMBERS DATE: FEBRUARY 13, 2018 FROM: CITY MANAGER ITEM NO:14 SUBJECT:INVESTMENT REPORT FOR DECEMBER 2017 RECOMMENDATION: Receive and file the Investment Report for the month ended December 31, 2017. BACKGROUND/ANALYSIS: The Investment Report presents the City's cash and investments for the month ended December 31, 2017. 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 City's Investment Policy was last revised and adopted by the City Council on June 13, 2017. 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 December 31, 2017, the City's investment portfolio had a market value of $222,854,016. 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 regulations (14 California Code 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. 26/231 REVIEWED BY OTHERS: None. Respectfully Submitted,Recommended By: Attachments Investment Report for December 2017 27/231 28/231 Attachment No. 1 Description Cost Value Market Value Maturity Date % of Portfolio Funds Held by Fiscal Agents - Bond Reserves US Bank CHFA Water Revenue Bonds Series 2012 Bond Fund First American Treasury Obligations Fund Class D 644 644 0.57%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.50% CHFA Water Revenue Bonds Series 2012 Acquisition Fund First American Treasury Obligations Fund Class D 740,798 740,798 0.57%n/a 0.33% CHFA Water Revenue Bonds Series 2012 Principal Account First American Treasury Obligations Fund Class D 12 12 0.58%n/a 0.00% CHFA Water Revenue Bonds Series 2012 Interest Account First American Treasury Obligations Fund Class D 3 3 0.57%n/a 0.00% CHFA Revenue Bonds CFD #1 Rolling Ridge Bond Fund First American Treasury Obligations Fund Class D 10 10 0.51%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.32% CHFA Revenue Bonds CFD #1 Rolling Ridge Reserve First American Treasury Obligations Fund Class D 36 36 0.56%n/a 0.00% CHFA Revenue Bonds CFD #2 Los Ranchos Bond Fund First American Treasury Obligations Fund Class D 73 73 0.56%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.75% CHFA Revenue Bonds CFD #2 Los Ranchos Reserve First American Treasury Obligations Fund Class D 83 83 0.57%n/a 0.00% CHFA Revenue Bonds CFD #4 Oaks Area Bond Fund First American Treasury Obligations Fund Class D 177,195 177,195 0.57%n/a 0.08% CHFA Revenue Bonds CFD #5 Soquel Canyon Bond Fund First American Treasury Obligations Fund Class D 67 67 0.57%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.90% CHFA Revenue Bonds CFD #5 Soquel Canyon Reserve First American Treasury Obligations Fund Class D 98 98 0.57%n/a 0.00% CFD #6 (Carbon Canyon Area) Special Tax Series 2006 Bond Fund First American Treasury Obligations Fund Class D 12 12 0.56%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% CFD #6 (Carbon Canyon Area) Special Tax Series 2006 Reserve First American Treasury Obligations Fund Class D 9 9 0.55%n/a 0.00% CHFA Revenue Bonds CFD #8 (Butterfield Area) Bond Fund First American Treasury Obligations Fund Class D 78,620 78,620 0.57%n/a 0.04% 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% Reassessment District 10-1 LOIB Reserve First American Treasury Obligations Fund Class D 15 15 0.55%n/a 0.00% Reassessment District 10-1 LOIB Redemption First American Treasury Obligations Fund Class D 40 40 0.57%n/a 0.00% CFD #9 (Rincon Village Area) Special Tax Refunding Series 2011 Bond First American Treasury Obligations Fund Class D 238 238 0.57%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.22% CFD #10 (Fairfield Ranch) Special Tax Refunding Series 2010 Improvement First American Treasury Obligations Fund Class D 344,465 344,465 0.58%n/a 0.15% CFD #10 (Fairfield Ranch) Special Tax Refunding Series 2010 Bond First American Treasury Obligations Fund Class D 28 28 0.58%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.44% Total Bond Reserve Funds 8,815,757 8,815,757 3.95% Bond Reserves Supplemental Interest/ Yield to Maturity 29/231 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 December 1, 2017 through December 31, 2017 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 30/231 ACCOUNT SUMMARY Beg. Values as of 11/30/17 End Values as of 12/31/17 Market Value 169,789,923 189,674,515 Accrued Interest 647,820 795,106 Total Market Value 170,437,743 190,469,621 Income Earned 236,973 277,757 Cont/WD 19,989,362 Par 171,277,008 191,514,636 Book Value 171,068,477 191,188,190 Cost Value 170,933,107 191,040,457 TOP ISSUERS Issuer % Portfolio Government of United States 24.2 % Federal National Mortgage Assoc 18.1 % Federal Home Loan Mortgage Corp 13.1 % Federal Home Loan Bank 8.0 % John Deere ABS 2.5 % Toyota ABS 1.8 % Nissan ABS 1.7 % Bank of Nova Scotia Houston 1.6 % 71.1 % PORTFOLIO CHARACTERISTICS Average Duration 2.48 Average Coupon 1.68 % Average Purchase YTM 1.72 % Average Market YTM 2.05 % Average S&P/Moody Rating AA/Aa1 Average Final Maturity 2.70 yrs Average Life 2.56 yrs CREDIT QUALITY (S&P)MATURITY DISTRIBUTIONSECTOR ALLOCATION PERFORMANCE REVIEW Total Rate of Return Current Latest Year Annualized Since As of 12/31/2017 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.30 %1.07 %1.07 %1.20 %1.00 %N/A 1.11 %7.85 % BAML 1-5 Yr US Treasury/Agency Index*0.00 %-0.37 %0.67 %0.67 %0.91 %0.76 %N/A 0.85 %5.94 % *BAML 1-3 Yr US Treasury/Agency Index to 7/31/12 Portfolio Summary As of 12/31/2017 City of Chino Hills Account #10150 Chandler Asset Management - CONFIDENTIAL Page 1 31/231 Execution Time: 1/2/2018 9:32:31 PM CategoryStandardCommentMunicipal Securities/ Local Agency Bonds No LimitationCompliesTreasury IssuesNo LimitationCompliesAgency IssuesNo Limitation (except for SBAs)CompliesMedium Term Notes30% maximum; "A" rated or better by a NRSRO; Issued by corporations organized and operating within the US or by depository institutions licensed by the US or any state and operating within the USCompliesAsset Backed Securities 20% maximum; AA-rated issue; A-rated issuerComplies Money Market Funds and Mutual Funds Highest rating or AAA rated by 2 NRSROs ; SEC registered with AUM >$500 million and experience greater than 5 years; 10% per one Mutual Fund; 20% maximum combined of total portfolio in these securitiesCompliesCollateralized/ FDIC Insured Certificates of Deposit/ Time Deposit30 maximum CompliesNegotiable Certificates of Deposit 30% maximum; Issued by nationally or state-chartered bank or a state or federal association or by a federally licensed or state-licensed branch of a foreign bank.CompliesLocal Agency Investment Fund - LAIF Currently not used by investment adviser CompliesProhibited Securities - per state Code Inverse floaters; Ranges notes, Interest-only strips from mortgaged backed securities; Zero interest accrual securitiesCompliesProhibited Securities -per City restrictions Guaranteed Small Business Administration (SBA) Notes; Bankers Acceptance; Commercial Paper; Reverse Repurchase Agreements; Mortgage-Backed Securities; Supranational Securities that are unsecured unsubordinated obligations issued by IBRD, IFC, or IADBCompliesMaximum maturity 5 years Complies City of Chino HillsDecember 31, 2017COMPLIANCE WITH INVESTMENT POLICY Assets managed by Chandler Asset Management are in full compliance with state law and with the City's investment policy.32/231 BOOK VALUE RECONCILIATION Beginning Book Value $171,068,477.31 Acquisition + Security Purchases $24,874,634.26 + Money Market Fund Purchases $2,738,433.91 + Money Market Contributions $20,000,000.00 + Security Contributions $0.00 + Security Transfers $0.00 Total Acquisitions $47,613,068.17 Dispositions - Security Sales $1,374,903.75 - Money Market Fund Sales $23,593,420.63 - MMF Withdrawals $10,638.11 - Security Withdrawals $0.00 - Security Transfers $0.00 - Other Dispositions $0.00 - Maturites $1,715,000.00 - Calls $0.00 - Principal Paydowns $821,746.91 Total Dispositions $27,515,709.40 Amortization/Accretion +/- Net Accretion $22,473.52 $22,473.52 Gain/Loss on Dispositions +/- Realized Gain/Loss ($119.30) ($119.30) Ending Book Value $191,188,190.30 CASH TRANSACTION SUMMARY BEGINNING BALANCE $945,707.50 Acquisition Contributions $20,000,000.00 Security Sale Proceeds $1,374,903.75 Accrued Interest Received $8,559.38 Interest Received $201,437.06 Dividend Received $249.94 Principal on Maturities $1,715,000.00 Interest on Maturities $0.00 Calls/Redemption (Principal)$0.00 Interest from Calls/Redemption $0.00 Principal Paydown $821,746.91 Total Acquisitions $24,121,897.04 Disposition Withdrawals $10,638.11 Security Purchase $24,874,634.26 Accrued Interest Paid $102,249.50 Total Dispositions $24,987,521.87 Ending Book Value $80,082.67 Reconciliation Summary As of 12/31/2017 City of Chino Hills Account #10150 Chandler Asset Management - CONFIDENTIAL Page 3 33/231 Execution Time: 1/2/2018 9:32:31 PM Holdings Report As of 12/31/17 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 89236WAC2 Toyota Auto Receivables Owner 2015-A 1.12% Due 2/15/2019 152,889.69 02/24/2015 1.13 % 152,866.58 152,888.73 99.93 1.64 % 152,775.57 76.11 0.08 % (113.16) Aaa / AAA NR 1.13 0.14 47788NAB4 John Deere Owner Trust 2016-B A2 1.09% Due 2/15/2019 315,238.65 07/19/2016 1.10 % 315,219.43 315,230.20 99.94 1.81 % 315,043.77 152.72 0.17 % (186.43) Aaa / NR AAA 1.13 0.09 43813NAC0 Honda Auto Receivables 2015-2 A3 1.04% Due 2/21/2019 218,722.33 05/13/2015 1.05 % 218,688.76 218,712.16 99.86 1.84 % 218,424.71 63.19 0.11 % (287.45) NR / AAA AAA 1.14 0.17 43814RAB2 Honda Auto Receivables 2016-4 A2 1.04% Due 4/18/2019 914,537.02 10/18/2016 1.05 % 914,511.50 914,523.71 99.81 1.73 % 912,809.39 343.46 0.48 % (1,714.32) NR / AAA AAA 1.30 0.27 65478WAB1 Nissan Auto Receivables Owner 2016-C A2A 1.07% Due 5/15/2019 289,509.45 08/02/2016 1.08 % 289,498.05 289,503.81 99.93 1.46 % 289,298.61 137.68 0.15 % (205.20) Aaa / NR AAA 1.37 0.19 89231LAB3 Toyota Auto Receivables Owner 2016-D 1.06% Due 5/15/2019 581,589.05 10/04/2016 1.07 % 581,542.52 581,564.48 99.85 1.70 % 580,701.45 273.99 0.31 % (863.03) Aaa / AAA NR 1.37 0.24 43814TAB8 Honda Auto Receivables 2017-1 A2 1.42% Due 7/22/2019 677,297.32 03/21/2017 1.43 % 677,281.13 677,286.47 99.86 1.78 % 676,380.21 267.16 0.36 % (906.26) Aaa / NR AAA 1.56 0.38 89238MAB4 Toyota Auto Receivables Owner 2017-A 1.42% Due 9/16/2019 928,341.76 03/07/2017 1.43 % 928,252.17 928,280.76 99.84 1.86 % 926,817.34 585.89 0.49 % (1,463.42) Aaa / AAA NR 1.71 0.40 47787XAB3 John Deere Owner Trust 2017-A A2 1.5% Due 10/15/2019 749,197.47 02/22/2017 1.50 % 749,194.47 749,195.43 99.87 1.84 % 748,215.97 499.46 0.39 % (979.46) Aaa / NR AAA 1.79 0.39 654747AB0 Nissan Auto Receivables 2017-A A2A 1.47% Due 1/15/2020 664,273.95 03/21/2017 1.47 % 664,270.56 664,271.48 99.82 1.84 % 663,076.25 433.99 0.35 % (1,195.23) Aaa / NR AAA 2.04 0.49 47788MAC4 John Deere Owner Trust 2016-A A3 1.36% Due 4/15/2020 932,956.98 02/23/2016 1.37 % 932,810.14 932,875.51 99.72 1.87 % 930,351.18 563.92 0.49 % (2,524.33) Aaa / NR AAA 2.29 0.55 47788BAB0 John Deere Owner Trust 2017-B A2A 1.59% Due 4/15/2020 2,490,000.00 Various 1.79 % 2,485,660.55 2,485,787.70 99.75 1.95 % 2,483,817.33 1,759.60 1.30 % (1,970.37) Aaa / NR AAA 2.29 0.69 89237RAB4 Toyota Auto Receivable 2017-C A2A 1.58% Due 7/15/2020 1,850,000.00 07/25/2017 1.59 % 1,849,982.43 1,849,984.91 99.70 1.93 % 1,844,400.05 1,299.11 0.97 % (5,584.86) Aaa / AAA NR 2.54 0.88 65478VAD9 NAROT 2016-B A3 1.32% Due 1/15/2021 2,340,000.00 12/06/2017 0.00 % 2,325,154.69 2,340,000.00 99.31 2.06 % 2,323,821.24 343.20 1.22 % (16,178.76) Aaa / NR AAA 3.04 0.94 47788BAD6 John Deere Owner Trust 2017-B A3 1.82% Due 10/15/2021 345,000.00 07/11/2017 1.83 % 344,974.75 344,977.47 99.25 2.22 % 342,425.61 279.07 0.18 % (2,551.86) Aaa / NR AAA 3.79 1.89 Total ABS 13,449,553.67 1.21 % 13,429,907.73 13,445,082.82 1.90 % 13,408,358.68 7,078.55 7.04 % (36,724.14) Aaa / AAA AAA 2.19 0.63 AGENCY 3135G0ZA4 FNMA Note 1.875% Due 2/19/2019 2,155,000.00 Various 1.78 % 2,164,027.03 2,157,256.87 100.03 1.85 % 2,155,558.15 14,815.63 1.14 % (1,698.72) Aaa / AA+ AAA 1.14 1.11 3137EADZ9 FHLMC Note 1.125% Due 4/15/2019 2,900,000.00 07/28/2016 0.92 % 2,916,034.10 2,907,595.95 99.08 1.85 % 2,873,456.30 6,887.50 1.51 % (34,139.65) Aaa / AA+ AAA 1.29 1.27 3137EADG1 FHLMC Note 1.75% Due 5/30/2019 2,150,000.00 Various 1.78 % 2,147,365.90 2,149,244.01 99.85 1.85 % 2,146,848.10 3,239.93 1.13 % (2,395.91) Aaa / AA+ AAA 1.41 1.39 Chandler Asset Management - CONFIDENTIAL Page 4 34/231 Execution Time: 1/2/2018 9:32:31 PM Holdings Report As of 12/31/17 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 3135G0ZE6 FNMA Note 1.75% Due 6/20/2019 1,900,000.00 10/17/2014 1.55 % 1,916,606.00 1,905,213.74 99.83 1.86 % 1,896,847.90 1,015.97 1.00 % (8,365.84) Aaa / AA+ AAA 1.47 1.44 3137EAEB1 FHLMC Note 0.875% Due 7/19/2019 3,100,000.00 09/29/2016 0.97 % 3,091,692.00 3,095,415.15 98.44 1.90 % 3,051,528.40 12,206.25 1.61 % (43,886.75) Aaa / AA+ AAA 1.55 1.52 3137EADK2 FHLMC Note 1.25% Due 8/1/2019 2,225,000.00 Various 1.81 % 2,167,581.20 2,206,396.77 99.02 1.88 % 2,203,237.28 11,588.54 1.16 % (3,159.49) Aaa / AA+ AAA 1.58 1.55 3135G0ZG1 FNMA Note 1.75% Due 9/12/2019 1,900,000.00 10/07/2014 1.80 % 1,895,725.00 1,898,529.88 99.72 1.92 % 1,894,619.20 10,067.36 1.00 % (3,910.68) Aaa / AA+ AAA 1.70 1.66 3137EADM8 FHLMC Note 1.25% Due 10/2/2019 2,500,000.00 09/30/2015 1.31 % 2,494,100.00 2,497,423.03 98.81 1.94 % 2,470,227.50 7,725.69 1.30 % (27,195.53) Aaa / AA+ AAA 1.75 1.72 3137EAEE5 FHLMC Note 1.5% Due 1/17/2020 3,150,000.00 02/14/2017 1.61 % 3,140,487.00 3,143,342.68 99.05 1.97 % 3,120,194.70 21,525.00 1.65 % (23,147.98) Aaa / AA+ AAA 2.05 1.99 3135G0A78 FNMA Note 1.625% Due 1/21/2020 3,500,000.00 12/08/2017 1.88 % 3,481,485.00 3,481,989.30 99.34 1.95 % 3,477,068.00 25,277.78 1.84 % (4,921.30) Aaa / AA+ AAA 2.06 2.00 3137EADR7 FHLMC Note 1.375% Due 5/1/2020 2,550,000.00 Various 1.59 % 2,525,807.60 2,537,837.19 98.50 2.03 % 2,511,874.95 5,843.75 1.32 % (25,962.24) Aaa / AA+ AAA 2.33 2.28 313383HU8 FHLB Note 1.75% Due 6/12/2020 2,500,000.00 09/15/2015 1.66 % 2,510,425.00 2,505,378.12 99.32 2.03 % 2,483,080.00 2,309.03 1.30 % (22,298.12) Aaa / AA+ NR 2.45 2.38 3135G0D75 FNMA Note 1.5% Due 6/22/2020 2,625,000.00 09/29/2015 1.49 % 2,626,417.50 2,625,741.17 98.81 1.99 % 2,593,854.38 984.38 1.36 % (31,886.79) Aaa / AA+ AAA 2.48 2.41 3137EAEK1 FHLMC Note 1.875% Due 11/17/2020 3,350,000.00 11/21/2017 1.96 % 3,341,319.58 3,341,637.84 99.48 2.06 % 3,332,442.65 8,026.04 1.75 % (9,195.19) Aaa / AA+ AAA 2.88 2.78 3135G0F73 FNMA Note 1.5% Due 11/30/2020 2,700,000.00 12/16/2015 1.90 % 2,648,970.00 2,670,002.25 98.53 2.02 % 2,660,326.20 3,487.50 1.40 % (9,676.05) Aaa / AA+ AAA 2.92 2.83 3130A7CV5 FHLB Note 1.375% Due 2/18/2021 2,235,000.00 02/17/2016 1.46 % 2,225,970.60 2,229,346.12 97.76 2.12 % 2,185,005.29 11,353.49 1.15 % (44,340.83) Aaa / AA+ AAA 3.14 3.03 3135G0J20 FNMA Note 1.375% Due 2/26/2021 3,500,000.00 Various 1.59 % 3,472,861.80 3,477,178.61 97.89 2.07 % 3,426,321.50 16,710.07 1.81 % (50,857.11) Aaa / AA+ AAA 3.16 3.05 3135G0K69 FNMA Note 1.25% Due 5/6/2021 2,875,000.00 Various 1.29 % 2,869,786.50 2,871,464.80 97.27 2.10 % 2,796,374.50 5,490.45 1.47 % (75,090.30) Aaa / AA+ AAA 3.35 3.25 313379RB7 FHLB Note 1.875% Due 6/11/2021 1,695,000.00 08/30/2017 1.67 % 1,707,780.30 1,706,641.19 99.15 2.13 % 1,680,599.28 1,765.63 0.88 % (26,041.91) Aaa / AA+ AAA 3.45 3.31 3130A8QS5 FHLB Note 1.125% Due 7/14/2021 2,800,000.00 07/22/2016 1.29 % 2,778,272.00 2,784,556.96 96.68 2.10 % 2,706,975.60 14,612.50 1.43 % (77,581.36) Aaa / AA+ AAA 3.54 3.42 3137EAEC9 FHLMC Note 1.125% Due 8/12/2021 3,200,000.00 09/26/2016 1.28 % 3,176,448.00 3,182,547.70 96.53 2.13 % 3,088,934.40 13,900.00 1.63 % (93,613.30) Aaa / AA+ AAA 3.62 3.50 3135G0N82 FNMA Note 1.25% Due 8/17/2021 3,200,000.00 09/28/2016 1.28 % 3,195,072.00 3,196,340.62 96.90 2.14 % 3,100,883.20 14,888.89 1.64 % (95,457.42) Aaa / AA+ AAA 3.63 3.50 3130AABG2 FHLB Note 1.875% Due 11/29/2021 3,375,000.00 02/27/2017 1.89 % 3,373,110.00 3,373,444.43 99.16 2.10 % 3,346,805.25 5,625.00 1.76 % (26,639.18) Aaa / AA+ AAA 3.92 3.74 Chandler Asset Management - CONFIDENTIAL Page 5 35/231 Execution Time: 1/2/2018 9:32:31 PM Holdings Report As of 12/31/17 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 3135G0S38 FNMA Note 2% Due 1/5/2022 3,400,000.00 Various 2.02 % 3,396,588.25 3,397,232.58 99.34 2.17 % 3,377,604.20 33,244.45 1.79 % (19,628.38) Aaa / AA+ AAA 4.02 3.80 3135G0T45 FNMA Note 1.875% Due 4/5/2022 3,485,000.00 06/19/2017 1.88 % 3,484,473.77 3,484,532.41 98.75 2.18 % 3,441,590.84 15,609.90 1.82 % (42,941.57) Aaa / AA+ AAA 4.26 4.05 3135G0T78 FNMA Note 2% Due 10/5/2022 3,500,000.00 12/08/2017 2.22 % 3,465,595.00 3,466,005.75 98.75 2.28 % 3,456,299.00 16,527.78 1.82 % (9,706.75) Aaa / AA+ AAA 4.76 4.49 3130A3KM5 FHLB Note 2.5% Due 12/9/2022 2,750,000.00 12/15/2017 2.25 % 2,782,010.00 2,781,763.36 101.15 2.25 % 2,781,534.25 4,201.39 1.46 % (229.11) Aaa / AA+ NR 4.94 4.62 Total Agency 75,220,000.00 1.64 % 74,996,011.13 75,074,058.48 2.04 % 74,260,091.02 288,929.90 39.14 % (813,967.46) Aaa / AA+ AAA 2.87 2.77 MONEY MARKET FUND FI 31846V401 First American Govt Obligation MMKT Class-D 80,082.67 Various 0.73 % 80,082.67 80,082.67 1.00 0.73 % 80,082.67 0.00 0.04 % 0.00 Aaa / AAA AAA 0.00 0.00 Total Money Market Fund FI 80,082.67 0.73 % 80,082.67 80,082.67 0.73 % 80,082.67 0.00 0.04 % 0.00 Aaa / AAA AAA 0.00 0.00 NEGOTIABLE CD 96121T3U0 Westpac Banking Corp Yankee CD 1.51% Due 7/20/2018 1,500,000.00 07/24/2017 1.51 % 1,499,996.25 1,499,997.92 100.00 1.51 % 1,499,997.92 10,318.33 0.79 % 0.00 P-1 / A-1+ F-1+ 0.55 0.55 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 18,907.60 1.58 % 0.00 P-1 / A-1 NR 0.61 0.60 06371ETT4 Bank of Motreal 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 7,421.33 1.45 % 0.00 P-1 / A-1 F-1+ 0.85 0.84 Total Negotiable CD 7,250,000.00 1.63 % 7,249,996.25 7,249,997.92 1.63 % 7,249,997.92 36,647.26 3.83 % 0.00 P-1 / A-1 F-1+ 0.69 0.68 US CORPORATE 89236TCA1 Toyota Motor Credit Corp Note 1.45% Due 1/12/2018 1,755,000.00 Various 1.43 % 1,755,583.65 1,755,007.72 99.99 1.76 % 1,754,826.26 11,946.19 0.93 % (181.46) Aa3 / AA- A 0.03 0.03 931142DF7 Wal-Mart Stores Note 1.125% Due 4/11/2018 645,000.00 04/04/2013 1.14 % 644,406.60 644,967.50 99.98 1.21 % 644,838.75 1,612.50 0.34 % (128.75) Aa2 / AA AA 0.28 0.28 713448CR7 PepsiCo Inc Note 1.25% Due 4/30/2018 1,180,000.00 Various 1.26 % 1,179,528.40 1,179,948.75 99.92 1.50 % 1,179,015.88 2,499.31 0.62 % (932.87) A1 / A+ A 0.33 0.33 037833AJ9 Apple Inc Note 1% Due 5/3/2018 1,800,000.00 Various 1.25 % 1,783,023.40 1,798,526.21 99.75 1.73 % 1,795,550.40 2,899.99 0.94 % (2,975.81) Aa1 / AA+ NR 0.34 0.34 02665WAC5 American Honda Finance Note 2.125% Due 10/10/2018 1,770,000.00 Various 1.84 % 1,787,921.40 1,773,679.18 100.16 1.92 % 1,772,791.29 8,462.82 0.94 % (887.89) A2 / A+ NR 0.78 0.76 74005PBH6 Praxair Note 1.25% Due 11/7/2018 1,400,000.00 01/08/2015 1.68 % 1,377,978.00 1,395,102.71 99.59 1.74 % 1,394,234.80 2,625.00 0.73 % (867.91) A2 / A NR 0.85 0.84 Chandler Asset Management - CONFIDENTIAL Page 6 36/231 Execution Time: 1/2/2018 9:32:31 PM Holdings Report As of 12/31/17 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 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,050.11 100.01 1.93 % 140,013.86 348.83 0.07 % (36.25) A1 / A+ AA 0.87 0.78 24422ESF7 John Deere Capital Corp Note 1.95% Due 12/13/2018 1,095,000.00 Various 1.78 % 1,100,497.65 1,096,711.79 99.96 2.00 % 1,094,519.30 1,067.63 0.58 % (2,192.49) A2 / A A 0.95 0.94 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,003,696.14 100.12 2.18 % 1,001,246.00 10,669.44 0.53 % (2,450.14) A2 / A A+ 1.04 1.01 17275RAR3 Cisco Systems Note 2.125% Due 3/1/2019 2,230,000.00 Various 1.67 % 2,256,499.90 2,241,592.77 100.11 2.03 % 2,232,504.30 15,795.82 1.18 % (9,088.47) A1 / AA- NR 1.16 1.14 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,705,009.49 100.28 1.96 % 1,704,812.71 6,856.66 0.90 % (196.78) A1 / A+ AA 1.32 1.21 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,208,285.20 99.99 2.25 % 2,199,879.00 1,100.00 1.16 % (8,406.20) A2 / A AA- 1.48 1.44 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,818,002.46 100.26 2.13 % 1,819,731.71 12,755.41 0.96 % 1,729.25 A1 / A AA- 1.70 1.57 94974BGF1 Wells Fargo Corp Note 2.15% Due 1/30/2020 2,025,000.00 Various 2.15 % 2,024,153.60 2,025,033.47 99.78 2.26 % 2,020,559.18 18,261.56 1.07 % (4,474.29) A2 / A A+ 2.08 2.01 22160KAG0 Costco Wholesale Corp Note 1.75% Due 2/15/2020 900,000.00 02/05/2015 1.77 % 899,055.00 899,598.48 99.36 2.06 % 894,280.50 5,950.00 0.47 % (5,317.98) A1 / A+ A+ 2.13 2.06 747525AD5 Qualcomm Inc Note 2.25% Due 5/20/2020 1,930,000.00 Various 2.35 % 1,918,856.25 1,925,512.23 99.23 2.58 % 1,915,117.78 4,945.62 1.01 % (10,394.45) A1 / A NR 2.39 2.30 437076BQ4 Home Depot Note 1.8% Due 6/5/2020 875,000.00 05/24/2017 1.82 % 874,492.50 874,589.74 99.20 2.14 % 868,042.00 1,137.50 0.46 % (6,547.74) A2 / A A 2.43 2.36 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,766,376.47 100.66 2.29 % 1,761,607.75 16,486.46 0.93 % (4,768.72) A1 / A AA- 2.63 2.51 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,138.60 99.61 2.14 % 1,021,009.68 3,302.78 0.54 % (4,128.92) Aaa / AAA AA+ 2.84 2.66 00440EAT4 ACE 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,482,634.08 99.84 2.36 % 2,471,059.80 9,171.25 1.30 % (11,574.28) A3 / A A 2.84 2.65 92826CAB8 Visa Inc Note 2.2% Due 12/14/2020 1,800,000.00 Various 1.60 % 1,845,865.00 1,830,430.38 99.92 2.23 % 1,798,581.60 1,870.00 0.95 % (31,848.78) A1 / A+ NR 2.96 2.84 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,534,409.27 100.30 2.40 % 2,532,479.05 28,406.25 1.34 % (1,930.22) A1 / AA- AA 3.05 2.89 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,808,501.96 99.78 2.30 % 1,790,982.79 13,294.97 0.95 % (17,519.17) Aaa / AA+ NR 3.17 3.02 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,004,653.00 99.56 2.29 % 995,583.00 2,568.06 0.52 % (9,070.00) A1 / A+ A+ 3.38 3.23 Chandler Asset Management - CONFIDENTIAL Page 7 37/231 Execution Time: 1/2/2018 9:32:31 PM Holdings Report As of 12/31/17 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 857477AV5 State Street Bank Note 1.95% Due 5/19/2021 920,000.00 05/16/2016 1.96 % 919,521.60 919,676.70 98.56 2.40 % 906,720.72 2,093.00 0.48 % (12,955.98) A1 / A AA- 3.38 3.24 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,223,952.72 97.37 2.31 % 1,192,749.43 7,542.26 0.63 % (31,203.29) Aaa / AAA AA+ 3.61 3.45 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,520,175.86 98.42 2.35 % 2,524,519.17 14,349.75 1.33 % 4,343.31 A1 / AA- A+ 3.71 3.53 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,775,737.02 100.58 2.50 % 1,760,190.25 22,543.40 0.94 % (15,546.77) A2 / A A 4.02 3.74 91159HHP8 US Bancorp Note 2.625% Due 1/24/2022 1,000,000.00 01/19/2017 2.66 % 998,280.00 998,602.15 100.57 2.48 % 1,005,742.00 11,447.92 0.53 % 7,139.85 A1 / A+ AA 4.07 3.79 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,805.45 99.16 2.64 % 2,345,107.99 24,625.56 1.24 % (19,697.46) A2 / A A+ 4.58 4.25 44932HAC7 IBM Credit Corp Note 2.2% Due 9/8/2022 2,200,000.00 11/29/2017 2.58 % 2,162,776.00 2,163,438.42 97.93 2.67 % 2,154,420.40 15,192.22 1.14 % (9,018.02) A1 / A+ A+ 4.69 4.39 Total US Corporate 48,855,000.00 2.00 % 48,943,371.87 48,903,846.03 2.20 % 48,692,717.35 281,828.16 25.71 % (211,128.68) A1 / A+ A+ 2.37 2.25 US TREASURY 912828SD3 US Treasury Note 1.25% Due 1/31/2019 1,400,000.00 12/28/2017 1.83 % 1,391,250.00 1,391,315.95 99.38 1.83 % 1,391,250.00 7,323.37 0.73 % (65.95) Aaa / AA+ AAA 1.08 1.07 912828UB4 US Treasury Note 1% Due 11/30/2019 3,000,000.00 Various 1.52 % 2,938,545.21 2,971,034.11 98.36 1.88 % 2,950,665.00 2,637.37 1.55 % (20,369.11) Aaa / AA+ AAA 1.92 1.88 912828H52 US Treasury Note 1.25% Due 1/31/2020 2,400,000.00 Various 1.49 % 2,375,218.98 2,388,462.06 98.68 1.90 % 2,368,219.20 12,554.35 1.25 % (20,242.86) Aaa / AA+ AAA 2.08 2.03 912828J84 US Treasury Note 1.375% Due 3/31/2020 2,250,000.00 10/23/2015 1.35 % 2,252,204.80 2,251,117.39 98.83 1.91 % 2,223,632.25 7,904.36 1.17 % (27,485.14) Aaa / AA+ AAA 2.25 2.19 912828VF4 US Treasury Note 1.375% Due 5/31/2020 2,350,000.00 07/10/2015 1.62 % 2,323,478.58 2,336,902.82 98.72 1.92 % 2,319,891.80 2,840.66 1.22 % (17,011.02) Aaa / AA+ AAA 2.42 2.36 912828XM7 US Treasury Note 1.625% Due 7/31/2020 2,500,000.00 02/27/2017 1.57 % 2,504,695.88 2,503,541.65 99.23 1.93 % 2,480,762.50 17,000.68 1.31 % (22,779.15) Aaa / AA+ AAA 2.58 2.50 912828L32 US Treasury Note 1.375% Due 8/31/2020 3,500,000.00 12/11/2017 1.91 % 3,451,054.69 3,452,040.50 98.54 1.94 % 3,448,868.50 16,351.86 1.82 % (3,172.00) Aaa / AA+ AAA 2.67 2.59 912828L99 US Treasury Note 1.375% Due 10/31/2020 2,650,000.00 11/23/2015 1.71 % 2,608,499.12 2,626,199.72 98.39 1.96 % 2,607,247.55 6,240.68 1.37 % (18,952.17) Aaa / AA+ AAA 2.84 2.75 912828N89 US Treasury Note 1.375% Due 1/31/2021 3,200,000.00 Various 1.48 % 3,186,303.70 3,190,062.40 98.09 2.02 % 3,139,001.60 18,413.04 1.66 % (51,060.80) Aaa / AA+ AAA 3.09 2.98 912828B90 US Treasury Note 2% Due 2/28/2021 2,150,000.00 Various 1.55 % 2,194,878.30 2,179,597.83 99.94 2.02 % 2,148,740.10 14,610.50 1.14 % (30,857.73) Aaa / AA+ AAA 3.16 3.03 912828Q37 US Treasury Note 1.25% Due 3/31/2021 3,200,000.00 Various 1.59 % 3,155,350.56 3,165,800.46 97.53 2.04 % 3,120,998.40 10,219.78 1.64 % (44,802.06) Aaa / AA+ AAA 3.25 3.15 Chandler Asset Management - CONFIDENTIAL Page 8 38/231 Execution Time: 1/2/2018 9:32:31 PM Holdings Report As of 12/31/17 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 912828T34 US Treasury Note 1.125% Due 9/30/2021 3,200,000.00 11/09/2016 1.48 % 3,145,885.73 3,158,527.55 96.49 2.10 % 3,087,625.60 9,197.80 1.63 % (70,901.95) Aaa / AA+ AAA 3.75 3.63 912828F96 US Treasury Note 2% Due 10/31/2021 2,800,000.00 01/27/2017 1.94 % 2,807,337.51 2,805,916.53 99.57 2.12 % 2,787,968.40 9,591.16 1.47 % (17,948.13) Aaa / AA+ AAA 3.84 3.66 912828J43 US Treasury Note 1.75% Due 2/28/2022 3,610,000.00 03/13/2017 2.14 % 3,544,721.85 3,555,247.10 98.47 2.14 % 3,554,723.68 21,465.54 1.88 % (523.42) Aaa / AA+ AAA 4.16 3.97 912828XG0 US Treasury Note 2.125% Due 6/30/2022 3,600,000.00 08/15/2017 1.82 % 3,651,058.94 3,647,124.70 99.82 2.17 % 3,593,390.40 211.33 1.89 % (53,734.30) Aaa / AA+ AAA 4.50 4.27 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,512.41 98.59 2.19 % 1,232,422.50 7,963.57 0.65 % (18,089.91) Aaa / AA+ AAA 4.67 4.41 912828L57 US Treasury Note 1.75% Due 9/30/2022 3,600,000.00 10/17/2017 1.99 % 3,560,062.50 3,561,719.20 98.00 2.20 % 3,527,859.60 16,096.15 1.86 % (33,859.60) Aaa / AA+ AAA 4.75 4.50 Total US Treasury 46,660,000.00 1.71 % 46,341,087.65 46,435,122.38 2.03 % 45,983,267.08 180,622.20 24.24 % (451,855.30) Aaa / AA+ AAA 3.22 3.10 TOTAL PORTFOLIO 191,514,636.34 1.72 % 191,040,457.30 191,188,190.30 2.05 % 189,674,514.72 795,106.07 100.00 % (1,513,675.58) Aa1 / AA AAA 2.70 2.48 TOTAL MARKET VALUE PLUS ACCRUED 190,469,620.79 Chandler Asset Management - CONFIDENTIAL Page 9 39/231 Execution Time: 1/2/2018 9:32:31 PM Cash And Equivalents 186,064.96 186,064.96 3.36 Mutual Funds-Equity 2,766,832.09 2,380,464.96 49.90 Mutual Funds-Fixed Income 2,591,963.77 2,556,199.69 46.74 Accrued Income 162.30 162.30 0.00 00269801 40- -01-B -62 -006-01 0102 -19-00748-01 PARS/CITY OF CHINO HILLS 115P Page 5 of 21 ACCOUNT 6746053100 Period from December 1, 2017 to December 31, 2017 12/31/2017 12/31/2017 % OF ASSETS MARKET BOOK VALUE MARKET Total Assets 5,544,860.82 5,122,729.61 100.00 Grand Total 5,545,023.12 5,122,891.91 100.00 Estimated Annual Income 116,244.41 ASSET SUMMARY CASH EQUIV & ACCR MUTUAL FUNDS 40/231 First Am Govt 185,407.410 185,407.41 185,407.41 .00 185,407.41 162.26 Ob Fd Cl Z 1.0000 .00 .00 1.17 31846V567 Asset Minor Code 1 Cash 657.55 657.55 657.55 Ishares Core 2,840.000 763,534.00 646,598.47 116,935.53 691,284.40 .00 S P 500 Etf 268.8500 - 5,766.58 72,249.60 1.75 464287200 Asset Minor Code 94 Ishares S P 1,531.000 233,890.87 189,237.07 44,653.80 209,517.35 .00 500 Growth Etf 152.7700 - 1,059.27 24,373.52 1.30 464287309 Asset Minor Code 94 Ishares S P 3,292.000 376,078.08 342,993.45 33,084.63 347,921.94 .00 500 Value Etf 114.2400 4,249.45 28,156.14 2.12 464287408 Asset Minor Code 94 00269801 40- -01-B -62 -006-01 0102 -19-00748-01 PARS/CITY OF CHINO HILLS 115P Page 6 of 21 ACCOUNT 6746053100 Period from December 1, 2017 to December 31, 2017 UNREALIZED GAIN (LOSS) ADJ PRIOR MARKET / SHARES/MARKET SINCE INCEPTION/ ADJ PRIOR MARKET ENDING ACCRUAL DESCRIPTION FACE AMOUNT PRICE/UNIT BOOK VALUE CURRENT PERIOD UNREALIZED GAIN/LOSS YIELD ON MARKET Money Markets Total Money Markets 185,407.410 185,407.41 185,407.41 .00 185,407.41 162.26 .00 .00 1.17 Cash Total Cash .000 657.55 657.55 .00 657.55 .00 .00 .00 0.00 Total Cash And 185,407.410 186,064.96 186,064.96 .00 186,064.96 162.26 Equivalents .00 .00 1.16 Mutual Funds-Equity ASSET DETAIL Cash And Equivalents Mutual Funds 41/231 Ishares Msci 7,296.000 512,981.76 423,173.78 89,807.98 475,922.63 .00 Eafe Etf 70.3100 1,466.54 37,059.13 2.57 464287465 Asset Minor Code 94 Ishares 959.000 199,596.67 175,808.29 23,788.38 184,213.54 .00 Russell Mid Cap Etf 208.1300 177.41 15,383.13 1.52 464287499 Asset Minor Code 94 Ishares 1,822.000 229,116.50 219,417.25 9,699.25 217,390.61 .00 Russell 2000 Value Etf 125.7500 - 3,526.21 11,725.89 1.78 464287630 Asset Minor Code 94 Ishares 992.000 185,206.40 156,740.85 28,465.55 167,289.46 .00 Russell 2000 Growth Etf 186.7000 - 4,930.74 17,916.94 0.73 464287648 Asset Minor Code 94 Vanguard Ftse 4,041.000 185,522.31 147,079.09 38,443.22 165,587.70 .00 Emerging Markets Etf 45.9100 5,779.18 19,934.61 2.30 922042858 Asset Minor Code 94 Vanguard Reit 975.000 80,905.50 79,416.71 1,488.79 81,162.65 .00 Index Fund Etf 82.9800 - 1,388.00 - 257.15 4.23 922908553 Asset Minor Code 94 Ishares Core 19,764.000 2,160,798.12 2,124,608.66 36,189.46 2,164,493.81 .00 U.S. Aggregate Bond Etf 109.3300 4,714.49 - 3,695.69 2.32 464287226 Asset Minor Code 95 Powershares 3,599.000 82,920.96 84,107.89 - 1,186.93 83,279.69 .00 Senior Loan Etf 23.0400 - 38.85 - 358.73 3.50 73936Q769 Asset Minor Code 95 Vanguard 32,760.554 348,244.69 347,483.14 761.55 349,852.08 .04 Short Term Invt Grade #539 10.6300 - 645.09 - 1,607.39 2.09 922031836 Asset Minor Code 99 00269801 40- -01-B -62 -006-01 0102 -19-00748-01 PARS/CITY OF CHINO HILLS 115P Page 7 of 21 ACCOUNT 6746053100 Period from December 1, 2017 to December 31, 2017 UNREALIZED GAIN (LOSS) ADJ PRIOR MARKET / SHARES/MARKET SINCE INCEPTION/ ADJ PRIOR MARKET ENDING ACCRUAL DESCRIPTION FACE AMOUNT PRICE/UNIT BOOK VALUE CURRENT PERIOD UNREALIZED GAIN/LOSS YIELD ON MARKET Total Mutual Funds-Equity 23,748.000 2,766,832.09 2,380,464.96 386,367.13 2,540,290.28 .00 - 4,998.22 226,541.81 1.94 Mutual Funds-Fixed Income ASSET DETAIL (continued) 42/231 Time 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 not publicly 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 less frequently than statement generation. For further information, please contact your account manager or relationship manager. 00269801 40- -01-B -62 -006-01 0102 -19-00748-01 PARS/CITY OF CHINO HILLS 115P Page 8 of 21 ACCOUNT 6746053100 Period from December 1, 2017 to December 31, 2017 UNREALIZED GAIN (LOSS) ADJ PRIOR MARKET / SHARES/MARKET SINCE INCEPTION/ ADJ PRIOR MARKET ENDING ACCRUAL DESCRIPTION FACE AMOUNT PRICE/UNIT BOOK VALUE CURRENT PERIOD UNREALIZED GAIN/LOSS YIELD ON MARKET Total Mutual Funds-Fixed 56,123.554 2,591,963.77 2,556,199.69 35,764.08 2,597,625.58 .04 Income 4,030.55 - 5,661.81 2.32 Total Mutual Funds 79,871.554 5,358,795.86 4,936,664.65 422,131.21 5,137,915.86 .04 - 967.67 220,880.00 2.12 Total Assets 265,278.964 5,544,860.82 5,122,729.61 422,131.21 5,323,980.82 162.30 - 967.67 220,880.00 2.09 Accrued Income .000 162.30 162.30 Grand Total 265,278.964 5,545,023.12 5,122,891.91 ASSET DETAIL (continued) ASSET DETAIL MESSAGES 43/231