Loading...
CM2018-083 INVESTMENT REPORT FOR NOVEMBER 2018CM2018-083 4 e* ce&i,t) 44-• MEMORANDUM DATE: DECEMBER 11, 2018 TO: FROM: KONRADT BARTLAM, CITY MANAGE HONORABLE MAYOR AND CITY COUNCIL MEMBERS SUBJECT: INVESTMENT REPORT FOR NOVEMBER 2018 Attached is the Investment Report for November 2018. The City Treasurer is required to forward the monthly Investment Report to the City Council within 30 days following the end of the month for which the Investment Report is prepared. The Investment Report will be presented to the City Council at a regular council meeting for formal approval. This presentation generally occurs at the first council meeting of the second month following the month for which the Investment Report is being prepared. KB:CB:EC:NL:rb Attachment cc: Robin Butler, Administrative Assistant II Attachment No. 1 City of Chino Hills Investment Report For the Month Ended November 30, 2018 Description Cash and Cash Equivalents Citizens Business Bank - Checking Citizens Business Bank - Payroll Citizens Business Bank - Certificate of Deposit Citizens Business Bank - Credit Card State of California Local Agency Investment Fund (LAIF) Los Angeles County Investment Pool (LACIP) * Investments - US Bank / Chandler Asset Management Asset -Backed Securities Federal Agencies Collateralized Mortgage Obligation Money Market Funds Supranational US Corporate US Treasury Description Restricted Funds - Pension Stabilization Fund US Bank Money Markets Cash Mutual Funds - Equity Mutual Funds - Fixed Income Funds Held by Fiscal Agents US Bank First AmericanTreasury Obligations Fund Class D US Bank N.A. Certificate of Deposit US Bank N.A. Certificate of Deposit (See Attached Supplemental) Total Investment Portfolio $ 222,186,258 Cost Value $ 3,554,172 456,218 1,094,766 3,039,718 15,598,578 67,173,640 5,887,283 623,560 5,340,925 58,520,128 45,801,437 Cost Value 206,148 1,371 3,191,406 3,170,180 1 Blended Yield of Cash and Investments * Benchmarks: LAI F LACIP * 6mo U.S. Treasury 2yr U.S. Treasury 5yr U.S. Treasury 1,132,782 232,056 7,161,890 2.13%1 2.21% 1.91% 2.52% 2.80% 2.84% Market Value $ 3,554,172 456,218 1,092,715 3,039,718 15,581,415 65,735,777 5,849,918 623,560 5,330,140 57,491,589 44,807,162 Market Value 206,148 1,371 3,491,440 3,106,004 1,132,782 232,056 7,161,890 $ 218,894,075 Interest/ Book % of Yield Maturity Date Portfolio 0.00% n/a 1.62% 0.00% n/a 0.00% 0.36% 4/29/2019 0.21% 0.00% n/a 0.00% 2.21% n/a 0.50% 1.91% n/a 1.39% 2.47% See attached 7.12% 1.81% See attached 30.03% 3.17% See attached 2.67% 1.66% n/a 0.28% 2.83% See attached 2.44% 2.50% See attached 26.26% 1.78% See attached 20.47% Market Yield to % of Maturity Maturity Date Portfolio 2.08% 0.00% 2.07% 2.62% 1.70% 2.02% 2.30% To ensure timely submission of the Investment Report, the prior month's LACIP percentage yield is used. n/a n/a n/a n/a n/a 1/4/2019 6/3/2019 0.09% 0.00% 1.60% 1.42% 0.52% 0.11% 3.27% 100.00% I hereby certify that the investments are in compliance with the investment policy adopted by the City Council. The investment portfolio provides sufficient funds to meet the budgeted expenditures over the next six months. This report meets the requirements of Government Code Section 53646. PREARED BY: gg,, Toni Holle, Senior Account Technician APPROVE Christa Buhagiar, Finance Director REVIEWED BY: -1(\a- AM-177S7 Nicole Lugotoff,Accoditting(Srvisor Attachment No. 1 Funds Held by Fiscal Agents Supplemental Interest/ Yield to % of Description Cost Value Market Value Maturity Maturity Date Portfolio Funds Held by Fiscal Agents US Bank CHFA Water Revenue Bonds Series 2012 Bond Fund First American Treasury Obligations Fund Class D $ 152,369 $ 152,369 1.70% n/a 0.07% CHFA Water Revenue Bonds Series 2012 Reserve Fund U.S Bank N.A. Certificate of Deposit 1,120,375 1,120,375 2.30% 6/3/2019 0.51% CHFA Water Revenue Bonds Series 2012 Acquisition Fund First American Treasury Obligations Fund Class D 479,139 479,139 1.70% n/a 0.22% CHFA Water Revenue Bonds Series 2012 Interest Account First American Treasury Obligations Fund Class D 6 6 1.73% n/a 0.00% CHFA Water Revenue Bonds Series 2012 Principal Account First American Treasury Obligations Fund Class D 62 62 1.70% n/a 0.00% CHFA Revenue Bonds CFD #1 Rolling Ridge Bond Fund First American Treasury Obligations Fund Class D 45 45 1.70% n/a 0.00% CHFA Revenue Bonds CFD #1 Rolling Ridge Reserve U.S Bank N.A. Certificate of Deposit 721,303 721,303 2.30% 6/3/2019 0.33% CHFA Revenue Bonds CFD #1 Rolling Ridge Reserve First American Treasury Obligations Fund Class D 9,514 9,514 1.70% n/a 0.00% CHFA Revenue Bonds CFD #2 Los Ranchos Bond Fund First American Treasury Obligations Fund Class D 435 435 1.70% n/a 0.00% CHFA Revenue Bonds CFD #2 Los Ranchos Reserve Fund U.S Bank N.A. Certificate of Deposit 1,676,080 1,676,080 2.30% 6/3/2019 0.77% CHFA Revenue Bonds CFD #2 Los Ranchos Reserve First American Treasury Obligations Fund Class D 22,107 22,107 1.70% n/a 0.01% CHFA Revenue Bonds CFD #4 Oaks Area Bond Fund First American Treasury Obligations Fund Class D 179,057 179,057 1.70% n/a 0.08% CHFA Revenue Bonds CFD #5 Soquel Canyon Bond Fund First American Treasury Obligations Fund Class D 572 572 1.70% n/a 0.00% CHFA Revenue Bonds CFD #5 Soquel Canyon Reserve U.S Bank N.A. Certificate of Deposit 1,999,156 1,999,156 2.30% 6/3/2019 0.91% CHFA Revenue Bonds CFD #5 Soquel Canyon Reserve First American Treasury Obligations Fund Class D 26,368 26,368 1.70% n/a 0.01% CFD #6 (Carbon Canyon Area) Special Tax Series 2006 Bond Fund First American Treasury Obligations Fund Class D 47 47 1.71% n/a 0.00% CFD #6 (Carbon Canyon Area) Special Tax Series 2006 Reserve U.S Bank N.A. Certificate of Deposit 171,726 171,726 2.30% 6/3/2019 0.08% CFD #6 (Carbon Canyon Area) Special Tax Series 2006 Reserve First American Treasury Obligations Fund Class D 16,020 16,020 1.72% n/a 0.01% CHFA Revenue Bonds CFD #8 (Butterfield Area) Bond Fund First American Treasury Obligations Fund Class D 79,446 79,446 1.70% n/a 0.04% Reassessment District 10-1 LOIB Redemption First American Treasury Obligations Fund Class D 99 99 1.72% n/a 0.00% Reassessment District 10-1 LOIB Reserve First American Treasury Obligations Fund Class D 13,796 13,796 1.72% n/a 0.01% Reassessment District 10-1 LOIB Reserve U.S Bank N.A. Certificate of Deposit 232,056 232,056 2.02% 1/4/2019 0.11% CFD #9 (Rincon Village Area) Special Tax Refunding Series 2011 Bond First American Treasury Obligations Fund Class D 6,360 6,360 1.70% 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 2.30% 6/3/2019 0.22% CFD #9 (Rincon Village Area) Special Tax Refunding Series 2011 Interest First American Treasury Obligations Fund Class D 13 13 1.69% n/a 0.00% CFD #9 (Rincon Village Area) Special Tax Refunding Series 2011 Principal First American Treasury Obligations Fund Class D 167 167 1.70% n/a 0.00% CFD #10 (Fairfield Ranch) Special Tax Refunding Series 2010 Improvement First American Treasury Obligations Fund Class D 146,842 146,842 1.72% n/a 0.07% CFD #10 (Fairfield Ranch) Special Tax Refunding Series 2010 Bond First American Treasury Obligations Fund Class D 86 86 1.70% n/a 0.00% CFD #10 (Fairfield Ranch) Special Tax Refunding Series 2010 Interest First American Treasury Obligations Fund Class D 63 63 1.70% n/a 0.00% CFD #10 (Fairfield Ranch) Special Tax Refunding Series 2010 Principal First American Treasury Obligations Fund Class D 170 170 1.70% 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 2.30% 6/3/2019 0.45% Total Funds Held by Fiscal Agents $ 8,526,728 $ 8,526,728 3.90% ICity of Chino Hills -Account #10150 MONTHLY ACCOUNT STATEMENT NUVtIVIbtti 1, LUla i nrwu n N OVEMBER 30, 2018 Chandler Team: For questions about your account, please call (800) 317-4747, or contact operations@chandlerasset.com Custodian US Bank Christopher Isles (503) 464-3685 CHANDLER ASSET MANAGEMENT chandlerassetcom Information contained herein is confidential. We urge you to compare this statement to the one you receive from your qualified custodian. Please see Important Disclosures. City of Chino Hills Account#10150 PORTFOLIO CHARACTERISTICS Average Modified Duration Average Coupon Average Purchase YTM Average Market YTM Average S&P/Moody Rating Average Final Maturity Average Life SECTOR ALLOCATION Agency US Corp US Treasury 2.36 1.99% 2.12% 3.03% AA/Aa1 2.63 yrs 2.49 yrs ABS CMOI 3.0% Supras , 2.7% Money Mkt Fd 10,3% 7.9% PERFORMANCE REVIEW 22.9% 33.6% 29.5% Portfolio Summary As of November 30, 2018 ACCOUNT SUMMARY Beg. Values as of 10/31/18 End Values as of 11/30/18 Market Value Accrued Interest Total Market Value Income Earned Cont/WD Par Book Value Cost Value MATURITY DISTRIBUTION 35% 30% 25% 20% 15% 10% 5% 2.5% 194,655,581 943,572 195,599,153 334,007 199,391,931 198,791,640 198,592,671 31.3 % 195,419,561 924,769 196,344,330 339,115 -11,549 199,886,868 199,138,009 198,945,551 0-.25 .25-.5 .5-1 1-2 2-3 3-4 4-5 Maturity (Yrs) 5+ TOP ISSUERS Government of United States Federal National Mortgage Assoc Federal Home Loan Mortgage Corp Federal Home Loan Bank John Deere ABS Honda ABS State Street Bank Toyota ABS Total CREDIT QUALITY (S&P) AA (65.1%) A (19.3%) Annualized CM 22.9% 16.7% 12.3% 7.7% 2.4% 2.0% 1.6% 1.5% 67.0% BBB (0.5%) AAA (5.8%) NR (9.3%) TOTAL RATE OF RETURN 1M 3M YTD 1YR 2YRS 3YRS SYRS 10YRS 2/28/2011 City of Chino Hills ICE BAML 1-5 Yr US Treasury/Agency Index* *ICE BAML 1-3 Yr US Treasury/Agency Index to 7/31/12 0.39% 0.25% 0.51% 0.53% 0.48% 0.33% 0.43% 0.43% 0.82% 0.56% 0.95% 1.00% 0.68% 0.79% N/A N/A 1.05% 0.80% Chandler Asset Management - CONFIDENTIAL Page 1 Execution Time: 12/4/2018 12:47:29 PM Statement of Compliance As of November 30, 2018 City of Chino Hills Assets managed by Chandler Asset Management are in full compliance with state law and the Client's investment policy. CA Category Standard Comment Treasury Issues No Limitation Complies Agency Issues 25% max per Agency/GSE issuer; 20% max agency callable securities Complies "AA" rated or better by a NRSRO; 30% maximum; 10% max per issuer; U.S. dollar denominated senior unsecured Supranationals unsubordinated obligations issued or unconditionally guaranteed by the International Bank for Reconstruction and Complies Development ("IBRD"), the International Finance Corporation ("IFC") or the Inter -American Development Bank ("IADB") Municipal Issues "A" rated or better by a NRSRO; 30% maximum; 5% max per issuer Complies "Al" short-term rated or better by a NRSRO; or "A" long-term debt rated or better by a NRSRO; 40% maximum; 5% max per Banker's Acceptances issuer; 180 days max maturity Complies "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 Commercial Paper Complies days max maturity; Issuer is a corporation organized and operating in the U.S. and have $500 million total assets No rating required if amount of the NCD is insured up to the FDIC limit; If above FDIC insured limit, requires "A-1" short - Negotiable Certificates of Deposit Complies term or "A" long-term rated issuer or higher by a NRSRO; 30% maximum; (inclusive of CDARS); 5% max per issuer Time Deposits (TD)/Certificates of Deposit 20% maximum (combination of FDIC and Collateralized TDs/ CDs); For federally insured time deposits, amount per (CD) institution is limited to maximum covered under FDIC; Collateralized if in excess of insured amounts Complies "A" rated or better by a NRSRO; 30% maximum; 5% max per issuer; Issued by corporations organized and operating within Corporate Medium Term Notes Complied at time of purchase* the U.S. or by depository institutions licensed by the U.S. or any state and operating within the U.S. Asset -Backed (ABS), Mortgage -Backed "AA" rated or better by a NRSRO; "A" long-term debt issuer rated or better by a NRSRO; 20% maximum (combined ABS, Complies Securities; Pass-Throughs; CMOs MBS, MPTs, CMOs); 5% max per issuer; No issuer limitation where the issuer is the US Treasury or Federal Agency/GSE. Highest rating or "AAA" rated by two NRSROs; SEC registered adviser with AUM >$500 million and experience > 5 years; 20% Mutual Fund & Money Market Mutual Fund maximum in Mutual Funds and Money Market Mutual Funds; 10% max per one Mutual Fund; 20% max per one Money Complies Market Mutual Fund LAIF Maximum amount permitted by LAIF Complies LGIP Los Angles County Investment Pool (LACIP) Complies Repurchase Agreements 102% collateralized; 1 year max maturity Complies Inverse floaters, Range notes, Mortgage -derived, Interest -only strips; Zero interest accrual securities; Reverse Repurchase Prohibited Complies Agreements; Foreign currency denominated securities Max Callables 20% maximum callable securities (does not include "make whole call" securities) Complies 5% of portfolio (except U.S. Government, U.S. Agencies, Supranationals, Mutual Funds or Money Market Funds, LAIF, LACIP, Max Per Issuer Complies or unless otherwise specified in the investment policy) Maximum maturity 5 years Complies * General Electric (36962G7G3) rated Baa1/888+/888+ was downgraded November 2018 and October 2018; Complied at time of purchase City of Chino Hills Account#10150 Reconciliation Summary As of November 30, 2018 BOOK VALUE RECONCILIATION BEGINNING BOOK VALUE Acquisition + Security Purchases + Money Market Fund Purchases + Money Market Contributions + Security Contributions + Security Transfers Total Acquisitions Dispositions - Security Sales - Money Market Fund Sales - MMF Withdrawals - Security Withdrawals - Security Transfers - Other Dispositions - Maturites - Calls - Principal Paydowns Total Dispositions Amortization/Accretion +/- Net Accretion Gain/Loss on Dispositions +/- Realized Gain/Loss $4,819,699.15 $5,371,120.55 $0.00 $0.00 $0.00 $0.00 $4,836,938.81 $11,549.25 $0.00 $0.00 $0.00 $4,160,000.00 $0.00 $852,695.25 $16,732.23 $0.00 ENDING BOOK VALUE $198,791,640.04 $10,190,819.70 $9,861,183.31 $16,732.23 $0.00 $199,138,008.66 IMIr CM CASH TRANSACTION SUMMARY BEGINNING BALANCE Acquisition Contributions Security Sale Proceeds Accrued Interest Received Interest Received Dividend Received Principal on Maturities Interest on Maturities Calls/Redemption (Principal) Interest from Calls/Redemption Principal Paydown Total Acquisitions Dispositions Withdrawals Security Purchase Accrued Interest Paid Total Dispositions $0.00 $0.00 $0.00 $308,208.81 $965.83 $4,160,000.00 $49,250.66 $0.00 $0.00 $852,695.25 $5,371,120.55 $11,549.25 $4,819,699.15 $17,239.66 $4,848,488.06 ENDING BOOK VALUE $100,927.02 I $623,559.51 Chandler Asset Management - CONFIDENTIAL Page 3 Execution Time: 12/4/2018 12:47:29 PM City of Chino Hills Account#10150 Holdings Report As of November 30, 2018 CM CUSIP Security Description Par Value/Units Purchase Date Cost Value Mkt Price Market Value % of Port. Moody/S&P Maturity Book Yield Book Value Mkt YTM Accrued Int. Gain/Loss Fitch Duration ABS 654747AB0 Nissan Auto Receivables 2017-A A2A 86,540.77 03/21/2017 86,540.32 1.47% 86,540.59 1.47% Due 1/15/2020 99.92 86,472.08 0.04% Aaa / NR 1.13 2.86% 56.54 (68.51) AAA 0.06 47788MAC4 John Deere Owner Trust 2016-A A3 227,955.40 02/23/2016 227,919.53 99.72 227,314.66 0.12% Aaa / NR 1.38 1.36% Due 4/15/2020 1.37% 227,943.46 2.77% 137.79 (628.80) AAA 0.20 47788BAB0 John Deere Owner Trust 2017-B A2A 796,551.12 Various 795,162.92 99.76 794,678.64 0.41% Aaa / NR 1.38 1.59% Due 4/15/2020 1.79% 795,742.61 2.87% 562.90 (1,063.97) AAA 0.18 89237RAB4 Toyota Auto Receivable 2017-C A2A 895,411.88 07/25/2017 895,403.37 99.54 891,331.40 0.45% Aaa / AAA 1.62 1.58% Due 7/15/2020 1.59% 895,407.21 3.01% 628.78 (4,075.81) NR 0.32 89238BAB8 Toyota Auto Receivables Owner 2018-A 2,011,306.47 01/23/2018 2,011,100.91 99.62 2,003,576.82 1.02% Aaa / AAA 1.88 A2A 2.12% 2,011,164.16 3.00% 1,877.22 (7,587.34) NR 0.43 2.1% Due 10/15/2020 65478VAD9 NAROT 2016-B A3 1,345,543.23 12/06/2017 1,337,006.90 99.22 1,334,996.85 0.68% Aaa / NR 2.13 1.32% Due 1/15/2021 1.73% 1,339,701.79 3.01% 197.35 (4,704.94) AAA 0.46 161571HF4 Chase CHAIT 2016-A5 1,000,000.00 09/27/2018 988,320.31 98.99 989,899.00 0.50% NR / AAA 2.62 1.27% Due 7/15/2021 2.11% 989,052.44 2.96% 564.44 846.56 AAA 0.60 43811BAC8 Honda Auto Receivables 2017-2 A3 2,250,000.00 04/27/2018 2,215,019.53 98.79 2,222,743.50 1.13% Aaa / AAA 2.71 1.68% Due 8/16/2021 2.62% 2,221,266.04 3.05% 1,680.00 1,477.46 NR 0.89 47788BAD6 John Deere Owner Trust 2017-B A3 1,145,000.00 Various 1,132,937.25 98.73 1,130,431.02 0.58% Aaa / NR 2.88 1.82% Due 10/15/2021 2.73% 1,134,700.06 3.06% 926.18 (4,269.04) AAA 1.03 47788CAC6 John Deere Owner Trust 2016-B A4 620,000.00 02/21/2018 619,955.42 99.33 615,828.02 0.31% Aaa / NR 3.38 2.66% Due 4/18/2022 2.68% 619,963.57 3.13% 732.98 (4,135.55) AAA 1.49 43815HAC1 Honda Auto Receivables Owner 2018-3 1,680,000.00 08/21/2018 1,679,769.50 99.70 1,674,879.36 0.85% Aaa / NR 3.73 A3 2.98% 1,679,784.55 3.12% 1,376.67 (4,905.19) AAA 1.97 2.95% Due 8/22/2022 02587AAJ3 American Express Credit 2017-1 1,725,000.00 Various 1,699,587.14 98.63 1,701,305.40 0.87% Aaa / NR 3.79 1.93% Due 9/15/2022 3.01% 1,701,077.00 3.12% 1,479.66 228.40 AAA 1.16 47788EAC2 John Deere Owner Trust 2018-B A3 1,910,000.00 07/18/2018 1,909,855.22 99.89 1,907,958.21 0.97% Aaa / NR 3.96 3.08% Due 11/15/2022 3.10% 1,909,867.09 3.16% 2,614.58 (1,908.88) AAA 1.86 15,598,578.32 15,581,414.96 7.94% Aaa / AAA 2.81 Total ABS 15,693,308.87 2.47% 15,612,210.57 3.05% 12,835.09 (30,795.61) AAA 0.99 Chandler Asset Management - CONFIDENTIAL Paee 4 Execution Time: 12/4/2018 12:47:29 PM City of Chino Hills Account#10150 Holdings Report As of November 30, 2018 CM CUSIP Security Description Par Value/Units Purchase Date Cost Value Mkt Price Market Value % of Port. Moody/S&P Maturity Book Yield Book Value Mkt YTM Accrued Int. Gain/Loss Fitch Duration AGENCY 3135G0ZG1 FNMA Note 1.75% Due 9/12/2019 3137EADM8 FHLMC Note 1.25% Due 10/2/2019 3137EAEE5 FHLMC Note 1.5% Due 1/17/2020 3135G0A78 FNMA Note 1.625% Due 1/21/2020 3137EADR7 FHLMC Note 1.375% Due 5/1/2020 313383HU8 FHLB Note 1.75% Due 6/12/2020 3135G0D75 FNMA Note 1.5% Due 6/22/2020 3137EAEK1 FHLMC Note 1.875% Due 11/17/2020 3135G0F73 FNMA Note 1.5% Due 11/30/2020 3130A7CV5 FHLB Note 1.375% Due 2/18/2021 3135G0J20 FNMA Note 1.375% Due 2/26/2021 3135G0K69 FNMA Note 1.25% Due 5/6/2021 313379RB7 FHLB Note 1.875% Due 6/11/2021 3130A8QS5 FHLB Note 1.125% Due 7/14/2021 3137EAEC9 FHLMC Note 1.125% Due 8/12/2021 3135G0N82 FNMA Note 1.25% Due 8/17/2021 1,300,000.00 10/07/2014 1,297,075.00 99.26 1,290,393.00 0.66% Aaa / AA+ 0.78 1.80% 1,299,536.88 2.71% 4,992.36 (9,143.88) AAA 0.77 2,500,000.00 09/30/2015 2,494,100.00 98.76 2,469,005.00 1.26% Aaa / AA+ 0.84 1.31% 2,498,769.99 2.75% 5,121.53 (29,764.99) AAA 0.82 3,150,000.00 02/14/2017 3,140,487.00 98.61 3,106,328.40 1.59% Aaa / AA+ 1.13 1.61% 3,146,323.31 2.75% 17,587.50 (39,994.91) AAA 1.10 3,500,000.00 12/08/2017 3,481,485.00 98.72 3,455,133.50 1.77% Aaa / AA+ 1.14 1.88% 3,490,010.06 2.77% 20,538.19 (34,876.56) AAA 1.11 2,550,000.00 Various 2,525,807.60 98.04 2,499,956.25 1.27% Aaa / AA+ 1.42 1.59% 2,542,610.84 2.79% 2,921.88 (42,654.59) AM 1.39 2,500,000.00 09/15/2015 2,510,425.00 98.36 2,458,925.00 1.26% Aaa / AA+ 1.53 1.66% 2,503,366.59 2.85% 20,538.19 (44,441.59) NR 1.49 2,625,000.00 09/29/2015 2,626,417.50 98.03 2,573,416.12 1.32% Aaa / AA+ 1.56 1.49% 2,625,467.03 2.79% 17,390.63 (52,050.91) AAA 1.52 3,350,000.00 11/21/2017 3,341,319.58 98.11 3,286,788.85 1.68% Aaa / AA+ 1.97 1.96% 3,344,295.27 2.87% 2,442.71 (57,506.42) AAA 1.91 2,700,000.00 12/16/2015 2,648,970.00 97.38 2,629,152.00 1.34% Aaa / AA+ 2.00 1.90% 2,679,418.84 2.86% 112.50 (50,266.84) AAA 1.95 2,235,000.00 02/17/2016 2,225,970.60 96.88 2,165,189.78 1.11% Aaa / AA+ 2.22 1.46% 2,230,996.82 2.84% 8,792.55 (65,807.04) AAA 2.15 3,500,000.00 Various 3,472,861.80 96.77 3,386,796.00 1.73% Aaa / AA+ 2.24 1.59% 3,483,795.23 2.88% 12,699.66 (96,999.23) AAA 2.17 2,875,000.00 Various 2,869,786.50 96.33 2,769,568.00 1.41% Aaa / AA+ 2.43 1.29% 2,872,431.84 2.82% 2,495.66 (102,863.84) AAA 2.37 1,695,000.00 08/30/2017 1,707,780.30 97.39 1,650,743.55 0.85% Aaa / AA+ 2.53 1.67% 1,703,547.98 2.95% 15,007.81 (52,804.43) AAA 2.42 2,800,000.00 07/22/2016 2,778,272.00 95.76 2,681,176.40 1.37% Aaa / AA+ 2.62 1.29% 2,788,555.39 2.81% 11,987.50 (107,378.99) AAA 2.54 3,200,000.00 09/26/2016 3,176,448.00 95.54 3,057,212.80 1.56% Aaa / AA+ 2.70 1.28% 3,186,967.01 2.85% 10,900.00 (129,754.21) AAA 2.62 3,200,000.00 09/28/2016 3,195,072.00 95.86 3,067,644.80 1.57% Aaa / AA+ 2.72 1.28% 3,197,263.76 2.84% 11,555.56 (129,618.96) AAA 2.63 Chandler Asset Management - CONFIDENTIAL Page 5 Execution Time: 12/4/2018 12:47:29 PM City of Chino Hills Account#10150 Holdings Report As of November 30, 2018 CM CUSIP Security Description Par Value/Units Purchase Date Book Yield Cost Value Book Value Mkt Price Mkt YTM Market Value Accrued Int. % of Port. Moody/S&P Maturity Gain/Loss Fitch Duration AGENCY 3130AABG2 FHLB Note 1.875% Due 11/29/2021 3135G0S38 FNMA Note 2% Due 1/5/2022 3135GOT45 FNMA Note 1.875% Due 4/5/2022 3135GOT78 FNMA Note 2% Due 10/5/2022 3130A3KM5 FHLB Note 2.5% Due 12/9/2022 3135GOT94 FNMA Note 2.375% Due 1/19/2023 3137EAEN5 FHLMC Note 2.75% Due 6/19/2023 Total Agency 3,375,000.00 3,400,000.00 3,485,000.00 3,500,000.00 2,750,000.00 3,500,000.00 3,750,000.00 67,440,000.00 02/27/2017 1.89% Various 2.02% 06/19/2017 1.88% 12/08/2017 2.22% 12/15/2017 2.25% 04/11/2018 2.71% 07/20/2018 2.86% 1.81% 3,373,110.00 3,373,808.27 3,396,588.25 3,397,863.51 3,484,473.77 3,484,632.84 3,465,595.00 3,472,538.59 2,782,010.00 2,775,879.30 3,448,410.00 3,455,306.43 3,731,175.00 3,732,551.16 67,173,639.90 67,285,936.94 97.13 2.88% 97.40 2.88% 96.75 2.90% 96.60 2.94% 98.26 2.96% 97.90 2.92% 99.14 2.95% 2.86% 3,278,164.50 351.56 3,311,654.40 27,577.78 3,371,591.13 10,164.58 3,380,898.50 10,888.89 2,702,092.25 32,847.22 3,426,328.50 30,479.17 3,717,618.75 48,697.92 65,735,777.48 326,091.35 1.67% (95,643.77) 1.70% (86,209.11) 1.72% (113,041.71) 1.73% (91,640.09) 1.39% (73,787.05) 1.76% (28,977.93) 1.92% (14,932.41) 33.65% (1,550,159.46) Aaa / AA+ 3.00 AAA 2.89 Aaa / AA+ 3.10 AAA 2.95 Aaa / AA+ 3.35 AAA 3.20 Aaa / AA+ 3.85 AAA 3.65 Aaa / AA+ 4.03 NR 3.75 Aaa / AA+ 4.14 AAA 3.87 Aaa / AA+ 4.55 AAA 4.19 Aaa / AA+ 2.54 AAA 2.43 CMO 3137B5JM6 FHLMC K034 A2 3.531% Due 7/25/2023 3137B7MZ9 FHLMC K036 A2 3.527% Due 10/25/2023 Total CMO 3,100,000.00 08/28/2018 3.03% 2,695,000.00 10/29/2018 3.32% 5,795,000.00 3.17% 3,165,753.91 3,162,372.49 2,721,528.91 2,721,071.01 5,887,282.82 5,883,443.50 100.95 3,129,558.50 1.60% NR / NR 3.27% 9,121.75 (32,813.99) AAA 100.94 2,720,359.95 1.39% Aaa / NR 3.28% 1,584.21 (711.06) AAA 5,849,918.45 2.98% Aaa / NR 3.28% 10,705.96 (33,525.05) AAA 4.65 4.15 4.90 4.32 4.77 4.23 MONEY MARKET FUND Fl 31846V401 First American Govt Obligation MMKT Class-D Total Money Market Fund Fl 623,559.51 623,559.51 Various 1.66% 1.66% 623,559.51 623,559.51 623,559.51 623,559.51 1.00 1.66% 1.66% 623,559.51 0.00 623,559.51 0.00 0.32% Aaa / AAA 0.00 AAA 0.32% Aaa / AAA 0.00 AAA 0.00 0.00 0.00 0.00 Chandler Asset Management - CONFIDENTIAL Paee 6 Execution Time: 12/4/2018 12:47:29 PM City of Chino Hills Account#10150 Holdings Report As of November 30, 2018 CM CUSIP Security Description Par Value/Units Purchase Date Cost Value Mkt Price Market Value % of Port. Moody/S&P Maturity Book Yield Book Value Mkt YTM Accrued Int. Gain/Loss Fitch Duration SUPRANATIONAL 45950KCM0 International Finance Corp Note 2.25% Due 1/25/2021 2,500,000.00 08/27/2018 2,468,725.00 2.79% 2,472,065.74 4581X0CZ9 Inter -American Dev Bank Note 3,000,000.00 08/21/2018 2,872,200.00 1.75% Due 9/14/2022 Total Supranational 2.87% 2,880,817.67 5,340,925.00 5,500,000.00 2.83% 5,352,883.41 98.64 2,465,997.50 1.27% Aaa / AAA 2.16 2.91% 19,687.50 (6,068.24) NR 2.07 95.47 2,864,142.00 1.46% NR / NR 3.02% 11,229.17 (16,675.67) AAA 5,330,139.50 2.73% Aaa / AAA 2.97% 30,916.67 (22,743.91) AAA 3.79 3.61 3.03 2.90 US CORPORATE 24422ESF7 John Deere Capital Corp Note 1,095,000.00 Various 1,100,497.65 99.98 1,094,762.39 0.56% A2 / A 0.04 1.95% Due 12/13/2018 1.78% 1,095,059.37 2.53% 9,964.50 (296.98) A 0.04 36962G7G3 General Electric Capital Corp Note 1,000,000.00 09/10/2015 1,011,900.00 99.77 997,738.00 0.51% Baal / BBB+ 0.12 2.3% Due 1/14/2019 1.93% 1,000,430.24 4.12% 8,752.78 (2,692.24) BBB+ 0.12 17275RAR3 Cisco Systems Note 2,230,000.00 Various 2,256,499.90 99.84 2,226,498.90 1.14% Al / AA- 0.25 2.125% Due 3/1/2019 1.67% 2,232,460.74 2.74% 11,846.88 (5,961.84) NR 0.25 91159HHH6 US Bancorp Callable Note Cont 1,700,000.00 Various 1,712,152.45 99.67 1,694,432.51 0.86% Al / A+ 0.40 3/25/2019 1.95% 1,701,259.06 3.02% 3,740.00 (6,826.55) AA- 0.40 2.2% Due 4/25/2019 40434CAC9 HSBC USA Inc Note 2,200,000.00 06/20/2017 2,211,242.00 99.49 2,188,846.00 1.13% A2 / A 0.56 2.25% Due 6/23/2019 1.99% 2,203,141.60 3.16% 21,725.00 (14,295.60) AA- 0.55 06406HCW7 Bank of New York Callable Note Cont 1,815,000.00 Various 1,822,288.25 99.40 1,804,086.41 0.92% Al / A 0.78 8/11/2019 2.19% 1,816,292.70 3.08% 9,276.67 (12,206.29) AA- 0.76 2.3% Due 9/11/2019 94974BGF1 Wells Fargo Corp Note 2,025,000.00 Various 2,024,153.60 98.68 1,998,217.35 1.03% A2 / A- 1.17 2.15% Due 1/30/2020 2.15% 2,025,018.74 3.31% 14,633.44 (26,801.39) A+ 1.13 22160KAG0 Costco Wholesale Corp Note 900,000.00 02/05/2015 899,055.00 98.31 884,824.20 0.45% Aa3 / A+ 1.21 1.75% Due 2/15/2020 1.77% 899,771.52 3.18% 4,637.50 (14,947.32) A+ 1.18 747525AD5 Qualcomm Inc Note 1,930,000.00 Various 1,918,856.25 98.36 1,898,425.20 0.97% A2 / A- 1.47 2.25% Due 5/20/2020 2.36% 1,927,235.13 3.40% 1,326.88 (28,809.93) NR 1.43 437076BQ4 Home Depot Note 875,000.00 05/24/2017 874,492.50 98.05 857,915.63 0.44% A2 / A 1.52 1.8% Due 6/5/2020 1.82% 874,744.40 3.13% 7,700.00 (16,828.77) A 1.46 857477AS2 State Street Bank Note 1,750,000.00 01/21/2016 1,778,420.00 98.58 1,725,228.75 0.89% Al / A 1.72 2.55% Due 8/18/2020 2.17% 1,760,678.82 3.40% 12,767.71 (35,450.07) AA- 1.65 Chandler Asset Management - CONFIDENTIAL Paee 7 Execution Time: 12/4/2018 12:47:29 PM City of Chino Hills Account#10150 Holdings Report As of November 30, 2018 CM CUSIP Security Description Par Value/Units Purchase Date Cost Value Mkt Price Market Value % of Port. Moody/S&P Maturity Book Yield Book Value Mkt YTM Accrued Int. Gain/Loss Fitch Duration US CORPORATE 594918BG8 Microsoft Callable Note Cont. 10/03/20 1,025,000.00 2% Due 11/3/2020 Various 1.99% 1,025,086.50 1,025,089.54 00440EAT4 Chubb INA Holdings Inc Callable Note 2,475,000.00 Various 2,484,922.25 Cont 10/3/2020 2.18% 2,480,099.51 2.3% Due 11/3/2020 98.24 1,006,983.58 0.51% Aaa / AAA 1.93 2.95% 1,594.44 (18,105.96) AA+ 1.87 98.03 2,426,227.65 1.24% A3 / A 1.93 3.37% 4,427.50 (53,871.86) A 1.86 92826CAB8 Visa Inc Note 1,800,000.00 Various 1,845,865.00 98.18 1,767,306.60 0.91% Al / AA- 2.04 2.2% Due 12/14/2020 1.60% 1,821,002.05 3.13% 18,370.00 (53,695.45) NR 1.95 78012KKU0 Royal Bank of Canada Note 2,525,000.00 12/11/2017 2,534,569.75 98.26 2,481,143.28 1.28% Aa2 / AA- 2.14 2.5% Due 1/19/2021 2.37% 2,531,588.18 3.35% 23,145.83 (50,444.90) AA 2.04 30231GAV4 Exxon Mobil Corp Callable Note Cont 1,795,000.00 Various 1,815,422.45 97.73 1,754,174.52 0.90% Aaa / AA+ 2.25 2/1/2021 1.97% 1,804,597.50 3.28% 9,971.23 (50,422.98) NR 2.16 2.222% Due 3/1/2021 3695506E7 General Dynamics Corp Note 2,390,000.00 Various 2,373,224.70 99.42 2,376,185.80 1.21% A2 / A+ 2.45 3% Due 5/11/2021 3.25% 2,376,281.13 3.25% 3,983.34 (95.33) NR 2.34 22160KAJ4 Costco Wholesale Corp Note 1,000,000.00 08/14/2017 1,005,170.00 97.55 975,462.00 0.50% Aa3 / A+ 2.47 2.15% Due 5/18/2021 2.01% 1,003,392.58 3.19% 776.39 (27,930.58) A+ 2.38 857477AV5 State Street Bank Note 1,420,000.00 Various 1,403,476.60 96.54 1,370,876.52 0.70% Al / A 2.47 1.95% Due 5/19/2021 2.33% 1,407,196.32 3.42% 923.00 (36,319.80) AA- 2.38 594918BP8 Microsoft Callable Note Cont 7/8/21 1,225,000.00 Various 1,223,545.75 96.12 1,177,498.18 0.60% Aaa / AAA 2.69 1.55% Due 8/8/2021 1.57% 1,224,218.72 3.06% 5,959.97 (46,720.54) AA+ 2.59 68389XBK0 Oracle Corp Callable Note Cont 8/01/21 2,565,000.00 Various 2,507,672.07 96.13 2,465,837.10 1.26% Al / AA- 2.79 1.9% Due 9/15/2021 2.40% 2,531,241.10 3.36% 10,288.50 (65,404.00) A 2.68 24422ETL3 John Deere Capital Corp Note 1,750,000.00 09/21/2017 1,777,457.50 97.43 1,705,077.50 0.88% A2 / A 3.10 2.65% Due 1/6/2022 2.26% 1,769,873.33 3.53% 18,678.82 (64,795.83) A 2.91 89236TDP7 Toyota Motor Credit Corp Note 2,000,000.00 Various 1,968,104.46 97.78 1,955,572.00 1.01% Aa3 / AA- 3.12 2.6% Due 1/11/2022 3.04% 1,974,074.25 3.36% 20,222.22 (18,502.25) A+ 2.93 91159HHP8 US Bancorp Callable Cont 12/23/2021 1,000,000.00 01/19/2017 998,280.00 97.57 975,666.00 0.50% Al / A+ 3.15 2.625% Due 1/24/2022 2.66% 998,916.76 3.45% 9,260.42 (23,250.76) AA- 2.96 674599CK9 Occidental Petroleum Callable Note 2,350,000.00 06/18/2018 2,293,929.00 96.69 2,272,203.25 1.16% A3 / A 3.38 Cont 3/15/2022 3.27% 2,300,520.86 3.65% 7,807.22 (28,317.61) A 3.18 2.6% Due 4/15/2022 69353RFE3 PNC Bank Callable Note Cont 6/28/2022 2,365,000.00 07/25/2017 2,364,787.15 95.78 2,265,277.41 1.16% A2 / A 3.66 2.45% Due 7/28/2022 2.45% 2,364,844.38 3.69% 19,797.02 (99,566.97) A+ 3.43 Chandler Asset Management - CONFIDENTIAL Page 8 Execution Time: 12/4/2018 12:47:29 PM City of Chino Hills Account#10150 Holdings Report As of November 30, 2018 CM CUSIP Security Description Par Value/Units Purchase Date Cost Value Mkt Price Market Value % of Port. Moody/S&P Maturity Book Yield Book Value Mkt YTM Accrued Int. Gain/Loss Fitch Duration US CORPORATE 44932HAC7 IBM Credit Corp Note 2,400,000.00 Various 2,354,504.00 94.47 2,267,354.40 1.16% Al / A 2.2% Due 9/8/2022 2.63% 2,363,570.27 3.79% 12,173.33 (96,215.87) A 3.78 3.55 48128BAB7 JP Morgan Chase & Co Callable Note 1X 2,400,000.00 Various 2,372,445.00 96.75 2,322,115.20 1.20% A2 / A- 4.13 1/15/2022 3.23% 2,376,760.95 3.83% 26,946.14 (54,645.75) AA- 3.79 2.972% Due 1/15/2023 084670BR8 Berkshire Hathaway Callable Note Cont 2,400,000.00 11/26/2018 2,328,216.00 96.88 2,325,079.20 1.19% Aa2 / AA 4.29 1/15/2023 3.51% 2,328,353.34 3.54% 13,933.33 (3,274.14) A+ 3.98 2.75% Due 3/15/2023 037833AK6 Apple Inc Note 1,785,000.00 11/28/2018 1,702,515.15 95.34 1,701,744.03 0.87% Aa1 / AA+ 4.42 2.4% Due 5/3/2023 3.54% 1,702,566.22 3.55% 3,332.00 (822.19) NR 4.14 02665WCJ8 American Honda Finance Note 755,000.00 07/11/2018 753,693.85 99.45 750,876.95 0.39% A2 / A+ 4.62 3.45% Due 7/14/2023 3.49% 753,792.67 3.58% 9,767.81 (2,915.72) NR 4.18 69371RP59 Paccar Financial Corp Note 1,910,000.00 08/06/2018 1,909,216.90 100.08 1,911,451.60 0.98% Al / A+ 4.69 3.4% Due 8/9/2023 3.41% 1,909,265.79 3.38% 20,203.56 2,185.81 NR 4.26 02665WCQ2 American Honda Finance Note 1,870,000.00 10/03/2018 1,868,466.60 99.81 1,866,501.23 0.96% A2 / A+ 4.86 3.625% Due 10/10/2023 3.64% 1,868,510.27 3.67% 9,603.23 (2,009.04) NR 4.40 58,520,128.28 57,491,589.34 29.46% Al / A+ 2.49 Total US Corporate 58,725,000.00 2.50% 58,451,848.04 3.37% 357,536.66 (960,258.70) A+ 2.35 US TREASURY 912828H52 US Treasury Note 2,400,000.00 Various 2,375,218.98 98.27 2,358,468.00 1.21% Aaa / AA+ 1.17 1.25% Due 1/31/2020 1.49% 2,393,532.69 2.76% 10,027.17 (35,064.69) AAA 1.14 912828J84 US Treasury Note 2,250,000.00 10/23/2015 2,252,204.80 98.15 2,208,339.00 1.13% Aaa / AA+ 1.33 1.375% Due 3/31/2020 1.35% 2,250,662.26 2.80% 5,269.57 (42,323.26) AAA 1.30 912828VF4 US Treasury Note 2,350,000.00 07/10/2015 2,323,478.58 97.90 2,300,704.05 1.17% Aaa / AA+ 1.50 1.375% Due 5/31/2020 1.62% 2,341,868.15 2.81% 88.77 (41,164.10) AAA 1.47 912828XM7 US Treasury Note 2,500,000.00 02/27/2017 2,504,695.88 98.06 2,451,562.50 1.26% Aaa / AA+ 1.67 1.625% Due 7/31/2020 1.57% 2,502,285.90 2.82% 13,578.46 (50,723.40) AAA 1.62 912828L32 US Treasury Note 3,500,000.00 12/11/2017 3,451,054.69 97.54 3,414,005.00 1.75% Aaa / AA+ 1.75 1.375% Due 8/31/2020 1.91% 3,468,503.47 2.82% 12,230.66 (54,498.47) AAA 1.70 912828L99 US Treasury Note 2,650,000.00 11/23/2015 2,608,499.12 97.30 2,578,574.55 1.31% Aaa / AA+ 1.92 1.375% Due 10/31/2020 1.71% 2,633,887.62 2.83% 3,120.34 (55,313.07) AAA 1.87 Chandler Asset Management - CONFIDENTIAL Page 9 Execution Time: 12/4/2018 12:47:29 PM City of Chino Hills Account#10150 Holdings Report As of November 30, 2018 CM CUSIP Security Description Par Value/Units Purchase Date Book Yield Cost Value Book Value Mkt Price Mkt YTM Market Value Accrued Int. % of Port. Moody/S&P Maturity Gain/Loss Fitch Duration US TREASURY 912828N89 US Treasury Note 1.375% Due 1/31/2021 912828B90 US Treasury Note 2% Due 2/28/2021 912828Q37 US Treasury Note 1.25% Due 3/31/2021 912828T34 US Treasury Note 1.125% Due 9/30/2021 912828F96 US Treasury Note 2% Due 10/31/2021 912828J43 US Treasury Note 1.75% Due 2/28/2022 912828XG0 US Treasury Note 2.125% Due 6/30/2022 912828L24 US Treasury Note 1.875% Due 8/31/2022 912828L57 US Treasury Note 1.75% Due 9/30/2022 912828N30 US Treasury Note 2.125% Due 12/31/2022 Total US Treasury TOTAL PORTFOLIO TOTAL MARKET VALUE PLUS ACCRUED 3,200,000.00 2,150,000.00 3,200,000.00 3,200,000.00 2,800,000.00 3,610,000.00 3,600,000.00 1,250,000.00 3,600,000.00 3,850,000.00 46,110,000.00 199,886,868.38 Various 1.48% Various 1.55% Various 1.59% 11/09/2016 1.48% 01/27/2017 1.94% 03/13/2017 2.14% 08/15/2017 1.82% 09/26/2017 1.87% 10/17/2017 1.99% 01/25/2018 2.46% 1.78% 2.12% 3,186,303.70 3,193,010.14 2,194,878.31 2,171,031.39 3,155,350.56 3,175,439.82 3,145,885.73 3,168,653.13 2,807,337.51 2,804,504.00 3,544,721.85 3,567,286.25 3,651,058.94 3,637,533.20 1,250,541.30 1,250,411.92 3,560,062.50 3,569,097.03 3,790,144.53 3,800,419.72 45,801,436.98 45,928,126.69 198,945,550.81 199,138,008.66 96.98 2.82% 98.21 2.82% 96.52 2.80% 95.43 2.82% 97.68 2.83% 96.63 2.84% 97.52 2.86% 96.52 2.86% 96.00 2.86% 97.19 2.86% 2.83% 3,103,251.20 14,706.52 2,111,618.20 10,928.18 3,088,624.00 6,813.18 3,053,625.60 6,131.87 2,735,031.60 4,795.58 3,488,162.50 16,055.52 3,510,842.40 32,013.59 1,206,493.75 5,956.49 3,456,140.40 10,730.77 3,741,718.75 34,236.75 44,807,161.50 186,683.42 1.59% (89,758.94) 1.08% (59,413.19) 1.58% (86,815.82) 1.56% (115,027.53) 1.40% (69,472.40) 1.78% (79,123.75) 1.80% (126,690.80) 0.62% (43,918.17) 1.77% (112,956.63) 1.92% (58,700.97) 22.92% (1,120,965.19) Aaa / AA+ 2.17 AAA 2.10 Aaa / AA+ 2.25 AAA 2.17 Aaa / AA+ 2.33 AAA 2.27 Aaa / AA+ 2.84 AAA 2.75 Aaa / AA+ 2.92 AAA 2.80 Aaa / AA+ 3.25 AAA 3.11 Aaa / AA+ 3.58 AAA 3.39 Aaa / AA+ 3.75 AAA 3.57 Aaa / AA+ 3.84 AAA 3.66 Aaa / AA+ 4.09 AAA 3.84 Aaa / AA+ 2.60 AAA 2.50 195,419,560.74 100.00% Aa1 / AA 3.03% 924,769.15 (3,718,447.92) AAA 196,344,329.89 2.63 2.36 Chandler Asset Management - CONFIDENTIAL Page 10 Execution Time: 12/4/2018 12:47:29 PM City of Chino Hills Account#10150 Transaction Ledger As of November 30, 2018 CAS Transaction Type Settlement Date CUSIP Quantity Security Description Acq/Disp Price Yield Amount Interest Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase 11/01/2018 31846V401 17,531.25 First American Govt Obligation MMKT 1.000 1.62% 17,531.25 0.00 17,531.25 Class-D 0.00 Purchase 11/01/2018 31846V401 965.83 First American Govt Obligation MMKT 1.000 1.62% 965.83 0.00 965.83 0.00 Class-D Purchase 11/03/2018 31846V401 38,712.50 First American Govt Obligation MMKT 1.000 1.62% 38,712.50 0.00 38,712.50 0.00 Class-D Purchase 11/06/2018 31846V401 17,968.75 First American Govt Obligation MMKT 1.000 1.62% 17,968.75 0.00 17,968.75 0.00 Class-D Purchase 11/07/2018 31846V401 8,750.00 First American Govt Obligation MMKT 1.000 1.62% 8,750.00 0.00 8,750.00 0.00 Class-D Purchase 11/07/2018 31846V401 4,209,250.66 First American Govt Obligation MMKT 1.000 1.62% 4,209,250.66 0.00 4,209,250.66 0.00 Class-D Purchase 11/11/2018 31846V401 35,850.00 First American Govt Obligation MMKT 1.000 1.62% 35,850.00 0.00 35,850.00 0.00 Class-D Purchase 11/15/2018 31846V401 1,487.71 First American Govt Obligation MMKT 1.000 1.62% 1,487.71 0.00 1,487.71 0.00 Class-D Purchase 11/15/2018 31846V401 1,058.33 First American Govt Obligation MMKT 1.000 1.62% 1,058.33 0.00 1,058.33 0.00 Class-D Purchase 11/15/2018 31846V401 3,150.00 First American Govt Obligation MMKT 1.000 1.62% 3,150.00 0.00 3,150.00 0.00 Class-D Purchase 11/15/2018 31846V401 44,787.71 First American Govt Obligation MMKT 1.000 1.62% 44,787.71 0.00 44,787.71 0.00 Class-D Purchase 11/15/2018 31846V401 198,575.27 First American Govt Obligation MMKT 1.000 1.62% 198,575.27 0.00 198,575.27 0.00 Class-D Purchase 11/15/2018 31846V401 1,736.58 First American Govt Obligation MMKT 1.000 1.62% 1,736.58 0.00 1,736.58 0.00 Class-D Purchase 11/15/2018 31846V401 1,374.33 First American Govt Obligation MMKT 1.000 1.62% 1,374.33 0.00 1,374.33 0.00 Class-D Purchase 11/15/2018 31846V401 4,902.33 First American Govt Obligation MMKT 1.000 1.62% 4,902.33 0.00 4,902.33 0.00 Class-D Purchase 11/15/2018 31846V401 63,350.64 First American Govt Obligation MMKT 1.000 1.62% 63,350.64 0.00 63,350.64 0.00 Class-D Chandler Asset Management - CONFIDENTIAL Page 11 Execution Time: 12/4/2018 12:47:29 PM City of Chino Hills Account#10150 Transaction Ledger As of November 30, 2018 CM Transaction Type Settlement Date CUSIP Quantity Security Description Acq/Disp Price Yield Amount Interest Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase 11/15/2018 31846V401 51,201.09 Purchase 11/15/2018 31846V401 134,295.16 Purchase 11/15/2018 31846V401 118,362.61 Purchase 11/15/2018 31846V401 200,604.35 Purchase 11/15/2018 31846V401 50,272.01 Purchase 11/17/2018 31846V401 31,406.25 Purchase 11/18/2018 31846V401 10,750.00 Purchase 11/19/2018 31846V401 13,845.00 Purchase 11/20/2018 31846V401 21,712.50 Purchase 11/21/2018 31846V401 4,130.00 Purchase 11/25/2018 31846V401 7,921.06 Purchase 11/26/2018 31846V401 9,121.75 Purchase 11/28/2018 084670BR8 2,400,000.00 First American Govt Class-D First American Govt Class-D First American Govt Class-D First American Govt Class-D First American Govt Class-D First American Govt Class-D First American Govt Class-D First American Govt Class-D First American Govt Class-D First American Govt Class-D First American Govt Class-D First American Govt Class-D Obligation MMKT Obligation MMKT Obligation MMKT Obligation MMKT Obligation MMKT Obligation MMKT Obligation MMKT Obligation MMKT Obligation MMKT Obligation MMKT Obligation MMKT Obligation MMKT Berkshire Hathaway 1/15/2023 2.75% Due 3/15/202 Purchase 11/29/2018 31846V401 31,640.63 First American Govt Class-D Callable Note Cont 3 Obligation MMKT 1.000 1.62% 51,201.09 0.00 51,201.09 1.000 1.62% 134,295.16 0.00 134,295.16 1.000 1.62% 118,362.61 0.00 118,362.61 1.000 1.62% 200,604.35 0.00 200,604.35 1.000 1.62% 50,272.01 0.00 50,272.01 1.000 1.62% 31,406.25 0.00 31,406.25 1.000 1.62% 10,750.00 0.00 10,750.00 1.000 1.62% 13,845.00 0.00 13,845.00 1.000 1.62% 21,712.50 0.00 21,712.50 1.000 1.62% 4,130.00 0.00 4,130.00 1.000 1.62% 7,921.06 0.00 7,921.06 1.000 1.62% 9,121.75 0.00 9,121.75 97.009 3.51% 2,328,216.00 13,383.33 2,341,599.33 1.000 1.62% 31,640.63 0.00 31,640.63 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Chandler Asset Management - CONFIDENTIAL Paee 12 Execution Time: 12/4/2018 12:47:29 PM City of Chino Hills Account#10150 Transaction Ledger As of November 30, 2018 CAS Transaction Type Settlement Date CUSIP Quantity Security Description Acq/Disp Price Yield Amount Interest Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase Purchase Purchase Subtotal TOTAL ACQUISITIONS 11/30/2018 02587AAJ3 11/30/2018 037833AK6 11/30/2018 31846V401 800,000.00 American Express Credit 2017-1 1.93% Due 9/15/2022 1,785,000.00 Apple Inc Note 2.4% Due 5/3/2023 36,406.25 10,356,120.55 10,356,120.55 First American Govt Obligation MMKT Class-D 98.621 3.11% 788,968.00 95.379 3.54% 1,702,515.15 1.000 1.66% 36,406.25 10,190,819.70 643.33 3,213.00 0.00 17,239.66 789,611.33 1,705,728.15 36,406.25 10,208,059.36 10,190,819.70 17,239.66 10,208,059.36 0.00 0.00 0.00 0.00 0.00 DISPOSITIONS Sale 11/28/2018 31846V401 Sale 11/30/2018 31846V401 Sale 11/30/2018 31846V401 Subtotal Paydown 11/15/2018 02587AAJ3 Paydown 11/15/2018 161571HF4 Paydown 11/15/2018 43811BAC8 Paydown 11/15/2018 47787XAB3 Paydown 11/15/2018 47788BAB0 2,341,599.33 First American Govt Obligation MMKT Class-D 1,705,728.15 First American Govt Obligation MMKT Class-D 789,611.33 First American Govt Obligation MMKT Class-D 4,836,938.81 0.00 American Express Credit 2017-1 1.93% Due 9/15/2022 0.00 Chase CHAIT 2016-A5 1.27% Due 7/15/2021 0.00 Honda Auto Receivables 2017-2 A3 1.68% Due 8/16/2021 44,731.80 John Deere Owner Trust 2017-A A2 1.5% Due 10/15/2019 197,258.47 John Deere Owner Trust 2017-B A2A 1.59% Due 4/15/2020 1.000 1.62% 2,341,599.33 0.00 2,341,599.33 1.000 1.66% 1,705,728.15 0.00 1,705,728.15 1.000 1.66% 789,611.33 0.00 789,611.33 4,836,938.81 0.00 4,836,938.81 100.000 0.00 1,487.71 1,487.71 100.000 0.00 1,058.33 1,058.33 100.000 0.00 3,150.00 3,150.00 100.000 44,731.80 55.91 44,787.71 100.000 197,258.47 1,316.80 198,575.27 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Chandler Asset Management - CONFIDENTIAL Page 13 Execution Time: 12/4/2018 12:47:29 PM City of Chino Hills Account#10150 Transaction Ledger As of November 30, 2018 CM Transaction Type Settlement Date CUSIP Quantity Security Description c Price Aq/Disp Yield Amount Interest Pur/Sold Total Amount Gain/Loss DISPOSITIONS Paydown 11/15/2018 47788BAD6 Paydown 11/15/2018 47788CAC6 Paydown 11/15/2018 47788EAC2 Paydown 11/15/2018 47788MAC4 Paydown 11/15/2018 654747AB0 Paydown 11/15/2018 65478VAD9 Paydown 11/15/2018 89237RAB4 Paydown 11/15/2018 89238BAB8 Paydown Paydown Paydown 11/15/2018 89238MAB4 11/21/2018 43815HAC1 11/26/2018 3137B5JM6 0.00 John Deere Owner Trust 2017-B A3 1.82% Due 10/15/2021 0.00 John Deere Owner Trust 2016-B A4 2.66% Due 4/18/2022 0.00 John Deere Owner Trust 2018-B A3 3.08% Due 11/15/2022 63,020.87 John Deere Owner Trust 2016-A A3 1.36% Due 4/15/2020 51,032.56 132,669.13 117,029.56 Toyota Auto Receivable 2017-C A2A 1.58% Due 7/15/2020 Nissan Auto Receivables 2017-A A2A 1.47% Due 1/15/2020 NAROT 2016-B A3 1.32% Due 1/15/2021 196,740.27 Toyota Auto Receivables Owner 2018-A A2A 2.1% Due 10/15/2020 100.000 100.000 100.000 100.000 100.000 100.000 100.000 100.000 50,212.59 Toyota Auto Receivables Owner 2017-A 100.000 1.42% Due 9/16/2019 0.00 Honda Auto Receivables Owner 2018-3 A3 2.95% Due 8/22/2022 0.00 FHLMC K034 A2 3.531% Due 7/25/2023 100.000 100.000 0.00 0.00 63,020.87 51,032.56 132,669.13 117,029.56 196,740.27 50,212.59 0.00 1,736.58 1,374.33 4,902.33 329.77 168.53 1,626.03 1,333.05 3,864.08 59.42 0.00 4,130.00 0.00 9,121.75 1,736.58 1,374.33 4,902.33 63,350.64 51, 201.09 134,295.16 118,362.61 200,604.35 50,272.01 4,130.00 9,121.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Subtotal 852,695.25 Maturity Maturity 11/07/2018 06371ETT4 11/07/2018 74005PBH6 2,760,000.00 Bank of Montreal Chicago Yankee CD 1.76% Due 11/7/2018 1,400,000.00 Praxair Note 1.25% Due 11/7/2018 Subtotal 4,160,000.00 100.000 100.000 Security Withdrawal 11/05/2018 31846V401 11,445.08 First American Govt Obligation MMKT Class-D 1.000 852,695.25 35,714.62 888,409.87 0.00 2,760,000.00 1,400,000.00 49,250.66 2,809,250.66 0.00 1,400,000.00 0.00 0.00 4,160,000.00 49,250.66 4,209,250.66 0.00 11,445.08 0.00 11,445.08 0.00 Chandler Asset Management - CONFIDENTIAL Paee 14 Execution Time: 12/4/2018 12:47:29 PM City of Chino Hills Account#10150 Transaction Ledger As of November 30, 2018 CM Transaction Type Settlement Date CUSIP Quantity Security Description c Price Aq/Disp Yield Amount Interest Pur/Sold Total Amount Gain/Loss DISPOSITIONS Security Withdrawal 11/26/2018 31846V401 104.17 First American Govt Obligation MMKT Class-D 1.000 104.17 0.00 104.17 0.00 Subtotal 11,549.25 TOTAL DISPOSITIONS 9,861,183.31 11,549.25 0.00 11,549.25 0.00 9,861,183.31 84,965.28 9,946,148.59 0.00 OTHER TRANSACTIONS Interest 11/01/2018 3137EADR7 Interest 11/03/2018 00440EAT4 Interest 11/03/2018 594918BG8 Interest 11/06/2018 3135GOK69 Interest 11/07/2018 74005PBH6 Interest 11/11/2018 3695506E7 Interest 11/17/2018 3137EAEK1 Interest 11/18/2018 22160KAJ4 Interest 11/19/2018 857477AV5 Interest 11/20/2018 747525AD5 2,550,000.00 FHLMC Note 1.375% Due 5/1/2020 2,475,000.00 1,025,000.00 2,875,000.00 1,400,000.00 2,390,000.00 3,350,000.00 1,000,000.00 1,420,000.00 1,930,000.00 0.000 Chubb INA Holdings Inc Callable Note 0.000 Cont 10/3/2020 2.3% Due 11/3/2020 Microsoft Callable Note Cont. 10/03/20 0.000 2% Due 11/3/2020 FNMA Note 0.000 1.25% Due 5/6/2021 Praxair Note 0.000 1.25% Due 11/7/2018 General Dynamics Corp Note 0.000 3% Due 5/11/2021 FHLMC Note 0.000 1.875% Due 11/17/2020 Costco Wholesale Corp Note 0.000 2.15% Due 5/18/2021 State Street Bank Note 0.000 1.95% Due 5/19/2021 Qualcomm Inc Note 0.000 2.25% Due 5/20/2020 17,531.25 28,462.50 10, 250.00 17,968.75 8,750.00 35,850.00 31,406.25 10,750.00 13,845.00 21,712.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 17,531.25 28,462.50 10, 250.00 17,968.75 8,750.00 35,850.00 31,406.25 10,750.00 13,845.00 21,712.50 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Chandler Asset Management - CONFIDENTIAL Page 15 Execution Time: 12/4/2018 12:47:29 PM City of Chino Hills Account#10150 Transaction Ledger As of November 30, 2018 CAS I Transaction Type Settlement Date CUSIP Quantity Security Description Acq/Disp Price Yield Amount Interest Pur/Sold Total Amount Gain/Loss OTHER TRANSACTIONS Interest Interest Interest Interest Subtotal Dividend 11/01/2018 31846V401 Subtotal TOTAL OTHER TRANSACTIONS 11/25/2018 3137B7MZ9 2,695,000.00 11/29/2018 3130AABG2 3,375,000.00 11/30/2018 3135G0F73 2,700,000.00 11/30/2018 912828VF4 2,350,000.00 31,535,000.00 FHLMC K036 A2 3.527% Due 10/25/2023 FHLB Note 1.875% Due 11/29/2021 FNMA Note 1.5% Due 11/30/2020 US Treasury Note 1.375% Due 5/31/2020 118,458.27 First American Govt Obligation MMKT Class-D 118,458.27 31,653,458.27 0.000 0.000 0.000 0.000 0.000 7,921.06 31,640.63 20,250.00 16,156.25 272,494.19 965.83 965.83 273,460.02 0.00 7,921.06 0.00 31,640.63 0.00 20,250.00 0.00 16,156.25 0.00 272,494.19 0.00 965.83 0.00 965.83 0.00 273,460.02 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Chandler Asset Management - CONFIDENTIAL Page 16 Execution Time: 12/4/2018 12:47:29 PM 00293301 40- -01-B -62-340-01 0102-19-00748-01 PARS/CITY OF CHINO HILLS 115P ACCOUNT 6746053100 ASSET SU M ASSETS Cash And Equivalents Mutual Funds -Equity Mutual Funds -Fixed Income Total Assets Accrued Income Grand Total 11/30/2018 MARKET 207,519.26 3,491,439.98 3,106,004.14 6,804,963.38 357.04 6,805,320.42 Estimated Annual Income 158,470.33 11/30/2018 % OF BOOK VALUE MARKET 207,519.26 3,191,406.31 3,170,179.64 6,569,105.21 357.04 6,569,462.25 3.05 51.30 45.64 99.99 0.01 100.00 MUTUAL FUNDS mbank Page 5of18 Period from November 1, 2018 to November 30, 2018 CASH EQUIV & ACCR 00293301 40- -01-B -62-340-01 0102-19-00748-01 PARS/CITY OF CHINO HILLS 115P ACCOUNT 6746053100 ASS ET DETAIL DESCRIPTION SHARES/ FACE AMOUNT MARKET PRICE/UNIT mbank C� Page 6 of 18 Period from November 1, 2018 to November 30, 2018 UNREALIZED GAIN (LOSS) ADJ PRIOR MARKET / SINCE INCEPTION/ ADJ PRIOR MARKET ENDING ACCRUAL BOOK VALUE CURRENT PERIOD UNREALIZED GAIN/LOSS YIELD ON MARKET Cash And Equivalents Money Markets First Am Govt 206,147.790 206,147.79 206,147.79 .00 206,147.79 357.04 Ob Fd CI Z 1.0000 .00 .00 2.09 31846V567 Asset Minor Code 1 Total Money Markets 206,147.790 206,147.79 206,147.79 .00 206,147.79 357.04 .00 .00 2.08 Cash Cash 1,371.47 1,371.47 1,371.47 Total Cash .000 1,371.47 1,371.47 .00 1,371.47 .00 .00 .00 0.00 Total Cash And 206,147.790 207,519.26 207,519.26 .00 207,519.26 357.04 Equivalents .00 .00 2.07 Mutual Funds Mutual Funds -Equity (shares Core 3,716.000 S P 500 Etf 464287200 Asset Minor Code 94 (shares S P 2,137.000 500 Growth Etf 464287309 Asset Minor Code 94 (shares S P 4,146.000 500 Value Etf 464287408 Asset Minor Code 94 1,033,048.00 891,860.85 141,187.15 1,015,379.07 .00 278.0000 19,559.26 17,668.93 1.82 352,904.18 289,476.15 63,428.03 347,683.61 .00 165.1400 5,009.60 5,220.57 1.18 466,051.86 442,925.57 23,126.29 457,210.86 .00 112.4100 11,428.87 8,841.00 2.37 00293301 40- -01-B -62-340-01 0102-19-00748-01 PARS/CITY OF CHINO HILLS 115P ACCOUNT 6746053100 ASS ET'DETAIL (continuied) DESCRIPTION SHARES/ FACE AMOUNT MARKET PRICE/UNIT BOOK VALUE mbank Page 7 of 18 Period from November 1, 2018 to November 30, 2018 UNREALIZED GAIN (LOSS) ADJ PRIOR MARKET / SINCE INCEPTION/ ADJ PRIOR MARKET ENDING ACCRUAL CURRENT PERIOD UNREALIZED GAIN/LOSS YIELD ON MARKET (shares Msci 7,166.000 449,809.82 436,691.22 13,118.60 Eafe Etf 62.7700 2,238.25 464287465 Asset Minor Code 94 (shares 5,327.000 275,938.60 255,238.30 20,700.30 Russell Mid Cap Etf 51.8000 6,569.84 464287499 Asset Minor Code 94 (shares 2,712.000 333,738.72 329,985.83 3,752.89 Russell 2000 Value Etf 123.0600 5,192.49 464287630 Asset Minor Code 94 (shares 1,360.000 259,433.60 229,565.51 29,868.09 Russell 2000 Growth Etf 190.7600 4,168.78 464287648 Asset Minor Code 94 Vanguard Ftse 5,696.000 226,074.24 223,552.83 2,521.41 Emerging Markets Etf 39.6900 10,499.98 922042858 Asset Minor Code 94 Vanguard Real 1,152.000 94,440.96 92,110.05 2,330.91 Estate Etf 81.9800 4,348.89 922908553 Asset Minor Code 94 Total Mutual Funds -Equity 33,412.000 3,491,439.98 3,191,406.31 300,033.67 69, 015.96 Mutual Funds -Fixed Income (shares Core 21,754.000 2,281,559.52 2,335,869.31 - 54,309.79 U.S. Aggregate Bond Etf 104.8800 15,944.52 464287226 Asset Minor Code 95 Vanguard 79,349.819 824,444.62 834,310.33 - 9,865.71 Short Term Invt Grade #539 10.3900 - 1,037.44 922031836 Asset Minor Code 99 Total Mutual Funds -Fixed 101,103.819 3,106,004.14 3,170,179.64 - 64,175.50 Income 14,907.08 478,089.32 - 28,279.50 .00 3.34 282,404.58 .00 - 6,465.98 1.80 355,836.07 .00 - 22,097.35 1.91 275,190.47 .00 - 15,756.87 0.69 239,790.18 .00 - 13,715.94 2.65 93,739.57 .00 701.39 4.69 3,545,323.73 .00 - 53,883.75 2.07 2,312,467.32 .00 - 30,907.80 2.59 828,063.37 .00 - 3,618.75 2.72 3,140, 530.69 .00 - 34,526.55 2.62 00293301 40- -01-B -62-340-01 0102-19-00748-01 PARS/CITY OF CHINO HILLS 115P ACCOUNT 6746053100 ASSET DETAI DESCRIPTION Total Mutual Funds Total Assets Accrued Income Grand Total L (continued) SHARES/ FACE AMOUNT BOOK VALUE 134,515.819 6,597,444.12 6,361,585.95 340,663.609 6,804,963.38 6,569,105.21 .000 357.04 357.04 340, 663.609 ASSET DETAIL MESSAGES MARKET PRICE/UNIT 6,805,320.42 6,569,462.25 Time of trade execution and trading party (if not disclosed) will be provided upon request. mbank Page 8 of 18 Period from November 1, 2018 to November 30, 2018 UNREALIZED GAIN (LOSS) ADJ PRIOR MARKET / SINCE INCEPTION/ ADJ PRIOR MARKET ENDING ACCRUAL CURRENT PERIOD UNREALIZED GAIN/LOSS YIELD ON MARKET 235,858.17 83,923.04 235,858.17 83,923.04 6,685,854.42 - 88,410.30 6,893,373.68 - 88,410.30 .00 2.33 357.04 2.32 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. 00293301 40- -01-B -62-340-01 0102-19-00748-01 PARS/CITY OF CHINO HILLS 115P ACCOUNT 6746053100 INCOME ACCRUAL DETAIL SHARES/ FACE AMOUNT DESCRIPTION Cash And Equivalents 206,147.790 First Am Govt Ob Fd CI Z 31846V567 Total Cash And Equivalents Mutual Funds -Fixed Income EX PAY ANN DATE DATE RATE 12/03/18 BEGINNING ACCRUAL mbank Page 9 of 18 Period from November 1, 2018 to November 30, 2018 INCOME EARNED INCOME RECEIVED ENDING ACCRUAL 0.02 399.77 357.04 399.77 357.04 399.77 357.04 399.77 357.04 21,754.000 Ishares Core U.S. Aggregate Bond Etf 2.72 .00 6,462.84 6,462.84 .00 464287226 11 /01 /18 11/07/18 79,349.819 Vanguard Short Term Invt Grade #539 0.28 .00 1,371.47 1,371.47 .00 922031836 11/30/18 12/03/18 Total Mutual Funds -Fixed Income Grand Total .00 7,834.31 7,834.31 .00 399.77 8,191.35 8,234.08 357.04 00293301 40- -01-B -62-340-01 0102-19-00748-01 PARS/CITY OF CHINO HILLS 115P ACCOUNT 6746053100 INVESTM DATE Interest ENT ACTIVITY' DESCRIPTION First Am Govt Ob Fd CI Z 31846V567 11/01/2018 Interest From 10/1/18 To 10/31/18 mbank Page 10 of 18 Period from November 1, 2018 to November 30, 2018 CASH 399.77 Total Interest 399.77 Dividends (shares Core U.S. Aggregate Bond Etf 464287226 11/07/2018 0.25634 USD/Share On 25,212 Shares Due 11/7/18 6,462.84 Vanguard Short Term Invt Grade #539 922031836 11/30/2018 Dividend From 11/1/18 To 11/30/18 Total Dividends 1,371.47 7,834.31 00293301 40- -01-B -62-340-01 0102-19-00748-01 PARS/CITY OF CHINO HILLS 115P ACCOUNT 6746053100 PLAN EXPENSES DATE DESCRIPTION Trust Fees Trust Fees 11/27/2018 Collected Charged For Period 10/01/2018 Thru 10/31/2018 Total Trust Fees Total Trust Fees Total Plan Expenses mbank Page 11 of 18 Period from November 1, 2018 to November 30, 2018 CASH - 1,775.31 - 1,775.31 - 1,775.31 - 1,775.31 00293301 40- -01-B -62-340-01 0102-19-00748-01 PARS/CITY OF CHINO HILLS 115P ACCOUNT 6746053100 OTHER ACTI /IT`Yr DATE DESCRIPTION Transfers Out Transfer To Another Account 11/29/2018 Paid To # 6746050100 Per Dir Dtd 11/28/18 Total Transfer To Another Account Total Transfers Out Total Other Activity mbank Page 12 of 18 Period from November 1, 2018 to November 30, 2018 CASH - 1,401.22 - 1,401.22 - 1,401.22 - 1,401.22 00293301 40- -01-B -62-340-01 0102-19-00748-01 PARS/CITY OF CHINO HILLS 115P ACCOUNT 6746053100 PURCHASES' DATE DESCRIPTION Cash And Equivalents 11/02/2018 Purchased 1,771.48 Units Of First Am Govt Ob Fd CI Z Trade Date 11/2/18 31846V567 11/07/2018 Purchased 6,462.84 Units Of First Am Govt Ob Fd CI Z Trade Date 11/7/18 31846V567 Total First Am Govt Ob Fd CI Z Total Cash And Equivalents Mutual Funds -Equity 11/28/2018 Purchased 65 Shares Of Ishares Core S P 500 Etf Trade Date 11/28/18 Purchased Through J.P. Morgan Securities LLC 65 Shares At 271.38 USD 464287200 SHARES/ FACE AMOUNT 1,771.480 6,462.840 8,234.320 8,234.320 mbank Page 13 of 18 Period from November 1, 2018 to November 30, 2018 COMMISSION .00 - 1,771.48 CASH BOOK VALUE 1,771.48 .00 - 6,462.84 6,462.84 .00 - 8,234.32 8,234.32 .00 - 8,234.32 8,234.32 65.000 2.28 - 17,641.98 17,641.98 Total (shares Core S P 500 Etf 65.000 11/28/2018 Purchased 233 Shares Of (shares Msci Eafe Etf Trade Date 11/28/18 Purchased Through J.P. Morgan Securities LLC 233 Shares At 62.3529 USD 464287465 Total (shares Msci Eafe Etf 233.000 2.28 - 17,641.98 8.16 - 14,536.39 233.000 8.16 17, 641.98 14,536.39 - 14,536.39 14,536.39 00293301 40- -01-B -62-340-01 0102-19-00748-01 PARS/CITY OF CHINO HILLS 115P ACCOUNT 6746053100 PURCHASES (continued) DATE DESCRIPTION 11/28/2018 Purchased 139 Shares Of (shares Russell Mid Cap Etf Trade Date 11/28/18 Purchased Through J.P. Morgan Securities LLC 139 Shares At 50.7814 USD 464287499 Total (shares Russell Mid Cap Etf SHARES/ FACE AMOUNT 139.000 mbank Page 14 of 18 Period from November 1, 2018 to November 30, 2018 COMMISSION 4.87 CASH - 7,063.48 BOOK VALUE 7,063.48 139.000 4.87 - 7,063.48 7,063.48 11/28/2018 Purchased 119 119.000 4.17 - 22,093.33 22,093.33 Shares Of (shares Russell 2000 Growth Etf Trade Date 11/28/18 Purchased Through J.P. Morgan Securities LLC 119 Shares At 185.6232 USD 464287648 Total (shares Russell 2000 Growth Etf 11/28/2018 Purchased 118 Shares Of (shares Russell 2000 Value Etf Trade Date 11/28/18 Purchased Through J.P. Morgan Securities LLC 118 Shares At 121.0085 USD 464287630 119.000 4.17 118.000 4.13 Total (shares Russell 2000 Value Etf 118.000 11/28/2018 Purchased 71 Shares Of (shares S P 500 Growth Etf Trade Date 11/28/18 Purchased Through J.P. Morgan Securities LLC 71 Shares At 160.31 USD 464287309 Total (shares S P 500 Growth Etf 71.000 - 22,093.33 22,093.33 - 14,283.13 14,283.13 4.13 - 14,283.13 2.49 - 11, 384.50 71.000 2.49 14,283.13 11, 384.50 - 11,384.50 11,384.50 00293301 40- -01-B -62-340-01 0102-19-00748-01 PARS/CITY OF CHINO HILLS 115P ACCOUNT 6746053100 PU FRGHASES' (continued) DATE DESCRIPTION Total Mutual Funds -Equity Mutual Funds -Fixed Income 11/29/2018 Purchased 27,478.192 Shares Of Vanguard Short Term Invt Grade #539 Trade Date 11/29/18 27,478.192 Shares At 10.39 USD 922031836 SHARES/ FACE AMOUNT 745.000 27,478.192 mbank Page 15 of 18 Period from November 1, 2018 to November 30, 2018 COMMISSION 26.10 .00 CASH - 87,002.81 - 285,498.42 BOOK VALUE 87,002.81 285,498.42 Total Vanguard Short Term Invt Grade #539 27,478.192 .00 - 285,498.42 285,498.42 Total Mutual Funds -Fixed Income 27,478.192 .00 - 285,498.42 285,498.42 Total Purchases 36,457.512 26.10 - 380,735.55 380,735.55 00293301 40- -01-B -62-340-01 0102-19-00748-01 PARS/CITY OF CHINO HILLS 115P ACCOUNT 6746053100 SALES AND MATURITIES DATE DESCRIPTION Cash And Equivalents SHARES/ FACE AMOUNT 11/27/2018 Sold 1,775.31 Units Of First Am Govt Ob Fd CI Z Trade Date 11/27/18 31846V567 11/29/2018 Sold 1,401.22 Units Of First Am Govt Ob Fd CI Z Trade Date 11/29/18 31846V567 11/30/2018 Sold 1,516.01 Units Of First Am Govt Ob Fd CI Z Trade Date 11/30/18 31846V567 - 1,775.310 - 1,401.220 - 1,516.010 COMMISSION .00 TRANSACTION PROCEEDS 1,775.31 mbank Page 16 of 18 Period from November 1, 2018 to November 30, 2018 BOOK VALUE - 1,775.31 .00 1,401.22 - 1,401.22 .00 1,516.01 - 1,516.01 PRIOR MARKET / REALIZED PRIOR MARKET GAIN/LOSS REALIZED GAIN/LOSS .00 .00 .00 - 1,775.31 .00 - 1,401.22 .00 - 1,516.01 .00 Total First Am Govt Ob Fd - 4,692.540 .00 4,692.54 - 4,692.54 .00 - 4,692.54 CI Z .00 Total Cash And - 4,692.540 .00 4,692.54 - 4,692.54 .00 - 4,692.54 Equivalents .00 Mutual Funds -Equity 11/28/2018 Sold 5 - 5.000 .18 552.01 - 534.16 17.85 - 551.39 Shares Of (shares S P 500 Value Etf Trade Date 11/28/18 Sold Through J.P. Morgan Securities LLC Paid 0.18 USD Brokerage Paid 0.01 USD Sec Fee 5 Shares At 110.44 USD 464287408 .62 Total (shares S P 500 - 5.000 .18 552.01 - 534.16 17.85 - 551.39 Value Etf .62 00293301 40- -01-B -62-340-01 0102-19-00748-01 PARS/CITY OF CHINO HILLS 115P ACCOUNT 6746053100 SALES AND MATURITIES (continued) DATE DESCRIPTION 11/28/2018 Sold 55 Shares Of Vanguard Ftse Emerging Markets Etf Trade Date 11/28/18 Sold Through J.P. Morgan Securities LLC Paid 1.93 USD Brokerage Paid 0.03 USD Sec Fee 55 Shares At 39.235 USD 922042858 SHARES/ FACE AMOUNT - 55.000 COMMISSION TRANSACTION PROCEEDS mbank Page 17 of 18 Period from November 1, 2018 to November 30, 2018 BOOK VALUE 1.93 2,155.97 - 2,158.60 PRIOR MARKET / REALIZED PRIOR MARKET GAIN/LOSS REALIZED GAIN/LOSS - 2.63 - 2,315.39 - 159.42 Total Vanguard Ftse - 55.000 1.93 2,155.97 - 2,158.60 - 2.63 - 2,315.39 - 159.42 Emerging Markets Etf 11/28/2018 Sold 81 - 81.000 2.84 6,530.53 - 6,476.49 54.04 - 6,591.06 Shares Of - 60.53 Vanguard Real Estate Etf Trade Date 11/28/18 Sold Through J.P. Morgan Securities LLC Paid 2.84 USD Brokerage Paid 0.09 USD Sec Fee 81 Shares At 80.66 USD 922908553 Total Vanguard Real - 81.000 Estate Etf Total Mutual Funds -Equity - 141.000 Mutual Funds -Fixed Income 11/28/2018 Sold 3,458 - 3,458.000 Shares Of (shares Core U.S. Aggregate Bond Etf Trade Date 11/28/18 Sold Through Sanford C. Bernstein & Co., LI Paid 121.03 USD Brokerage Paid 4.70 USD Sec Fee 3,458 Shares At 104.6479 USD 464287226 2.84 6,530.53 - 6,476.49 54.04 - 6,591.06 - 60.53 4.95 9,238.51 - 9,169.25 69.26 - 9,457.84 - 219.33 121.03 361,746.71 - 371,308.08 - 9,561.37 - 367,588.12 - 5,841.41 00293301 40- -01-B -62-340-01 0102-19-00748-01 PARS/CITY OF CHINO HILLS 115P ACCOUNT 6746053100 SALES AND MATURITIES (continued) DATE DESCRIPTION Total (shares Core U.S. Aggregate Bond Etf Total Mutual Funds -Fixed Income Total Sales And Maturities SHARES/ FACE AMOUNT COMMISSION - 3,458.000 121.03 - 3,458.000 121.03 - 8,291.540 125.98 SALES AND MATURITIES MESSAGES Realized gain/loss should not be used for tax purposes. TRANSACTION PROCEEDS mbank Page 18 of 18 Period from November 1, 2018 to November 30, 2018 BOOK VALUE 361,746.71 - 371,308.08 361,746.71 - 371,308.08 375,677.76 - 385,169.87 PRIOR MARKET / REALIZED PRIOR MARKET GAIN/LOSS REALIZED GAIN/LOSS - 9,561.37 - 367,588.12 - 5,841.41 - 9,561.37 - 367,588.12 - 5,841.41 - 9,492.11 - 381,738.50 - 6,060.74