Loading...
CM2019-038 Investment Report June 2019 CM2019-038 eib alawrea ii City of -41111Whi MEMORANDUM Chino Hills DATE: JULY 29, 2019 TO: HONORABLE MAYOR AND CITY COUNCIL MEMBERS�B/� FROM: BENJAMIN MONTGOMERY, CITY MANAGERI 7 4 L RE: INVESTMENT REPORT FOR JUNE 2019 Attached is the Investment Report for June 2019. 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. BM:CB:EC:TH:rb Attachment cc: Robin Butler, Administrative Assistant II Attachment No.1 City of Chino Hills Investment Report For the Month Ended June 30,2019 Interest/ Book %of Description Cost Value Market Value Yield Maturity Date Portfolio Cash and Cash Equivalents Citizens Business Bank-Checking $ 2,591,533 $ 2,591,533 0.00% n/a 1.09% Citizens Business Bank-Payroll - - 0.00% n/a 0.00% Citizens Business Bank-Certificate of Deposit 456,218 456,218 0.66% 4/29/2020 0.19% Citizens Business Bank-Credit Card - - 0.00% n/a 0.00% State of California Local Agency Investment Fund(LAIF) 15,267,265 15,293,399 2.43% n/a 6.44% Los Angeles County Investment Pool(LACIP)* 9,536 9,536 2.19% n/a 0.00% Investments-US Bank/Chandler Asset Management Asset-Backed Securities 10,945,918 11,058,205 2.69% See attached 4.67% Federal Agencies 70,498,443 71,033,156 1.92% See attached 29.99% Collateralized Mortgage Obligation 15,308,412 15,647,058 2.77% See attached 6.61% Foreign Corporate 2,329,118 2,380,990 2.97% See attached 1.01% Money Market Funds 168,766 168,766 1.85% n/a 0.07% Supranational 5,340,925 5,508,791 2.83% See attached 2.33% US Corporate 52,223,442 53,036,445 2.68% See attached 22.39% US Treasury 44,364,410 44,667,671 1.84% See attached 18.86% Market Yield to %of Description Cost Value Market Value Maturity Maturity Date Portfolio Restricted Funds-Pension Stabilization Fund US Bank Money Markets 245,179 245,179 2.27% n/a 0.10% Cash 1,826 1,826 0.00% n/a 0.00% Mutual Funds-Equity 3,257,658 3,737,360 2.07% n/a 1.58% Mutual Funds-Fixed Income 3,176,817 3,278,926 2.75% n/a 1.38% Funds Held by Fiscal Agents US Bank Federal Home Loan Banks Discount Note 7,481,099 7,494,319 2.29% 8/30/2019 3.18% First AmericanTreasury Obligations Fund Class D 277,976 277,976 1.31% n/a 0.11% (See Attached Supplemental) Total Investment Portfolio $ 233,944,541 $ 236,887,354 100.00% 'Blended Yield of Cash and Investments* 2.26%I Benchmarks: LAIF 2.43% LACIP* 2.19% 6mo U.S.Treasury 2.09% 2yr U.S.Treasury 1.75% 5yr U.S.Treasury 1.76% *To ensure timely submission of the Investment Report,the prior month's LACIP percentage yield is used. 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. PREPARED BY: REVIEWED BY: 14CAix - Aka Toni Holle,Senior Account Technician Nicole Lugoto ,Ac untie ervisor APPRO Q • Christa Buhagiar,Finance Director Attachment No.1 • City of Chino Hills Funds Held by Fiscal Agents Supplemental For the Month Ended June 30,2019 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 $ 19,510 $ 19,510 1.79% n/a 0.01% CHFA Water Revenue Bonds Series 2012 Reserve Fund Federal Home Loan Banks Discount Note 1,119,877 1,121,856 2.29% 8/30/2019 0.47% CHFA Water Revenue Bonds Series 2012 Acquisition Fund First American Treasury Obligations Fund Class D 498 498 1.79% n/a 0.00% CHFA Water Revenue Bonds Series 2012 Interest Account First American Treasury Obligations Fund Class D 16 16 1.80% n/a 0.00% CHFA Water Revenue Bonds Series 2012 Principal Account First American Treasury Obligations Fund Class D 92 92 1.79% n/a 0.00% CHFA Revenue Bonds CFD#1 Rolling Ridge Bond Fund First American Treasury Obligations Fund Class D 2 2 1.96% n/a 0.00% CHFA Revenue Bonds CFD#1 Rolling Ridge Reserve Federal Home Loan Banks Discount Note 730,009 731,299 2.29% 8/30/2019 0.31% CHFA Revenue Bonds CFD#1 Rolling Ridge Reserve First American Treasury Obligations Fund Class D 13,398 13,398 1.79% n/a 0.01% CHFA Revenue Bonds CFD#2 Los Ranchos Bond Fund First American Treasury Obligations Fund Class D 8 8 1.84% n/a 0.00% CHFA Revenue Bonds CFD#2 Los Ranchos Reserve Fund Federal Home Loan Banks Discount Note 1,697,718 1,700,718 2.29% 8/30/2019 0.72% CHFA Revenue Bonds CFD#2 Los Ranchos Reserve First American Treasury Obligations Fund Class D 29,724 29,724 1.79% n/a 0.01% CHFA Revenue Bonds CFD#5 Soquel Canyon Bond Fund First American Treasury Obligations Fund Class D 32 32 1.81% n/a 0.00% CHFA Revenue Bonds CFD#5 Soquel Canyon Reserve Federal Home Loan Banks Discount Note 2,024,929 2,028,508 2.29% 8/30/2019 0.86% CHFA Revenue Bonds CFD#5 Soquel Canyon Reserve First American Treasury Obligations Fund Class D 35,489 35,489 1.79% n/a 0.01% CFD#6(Carbon Canyon Area)Special Tax Series 2006 Bond Fund First American Treasury Obligations Fund Class D 1 1 1.90% n/a 0.00% CFD#6(Carbon Canyon Area)Special Tax Series 2006 Reserve Federal Home Loan Banks Discount Note 186,978 187,308 2.29% 8/30/2019 0.08% CFD#6(Carbon Canyon Area)Special Tax Series 2006 Reserve First American Treasury Obligations Fund Class D 3,912 3,912 1.79% n/a 0.00% Reassessment District 10-1 LOIB Redemption First American Treasury Obligations Fund Class D 4 4 1.88% n/a 0.00% Reassessment District 10-1 LOIB Reserve Federal Home Loan Banks Discount Note 248,641 249,080 2.29% 8/30/2019 0.11% Reassessment District 10-1 LOIB Reserve First American Treasury Obligations Fund Class D 690 690 1.79% n/a 0.00% CFD#9(Rincon Village Area)Special Tax Refunding Series 2011 Bond First American Treasury Obligations Fund Class D 8,518 8,518 1.79% n/a 0.00% CFD#9(Rincon Village Area)Special Tax Refunding Series 2011 Reserve Federal Home Loan Banks Discount Note 491,314 492,182 2.29% 8/30/2019 0.21% CFD#9(Rincon Village Area)Special Tax Refunding Series 2011 Reserve First American Treasury Obligations Fund Class D 186 186 1.79% n/a 0.00% CFD#9(Rincon Village Area)Special Tax Refunding Series 2011 Interest First American Treasury Obligations Fund Class D 5 5 1.89% n/a 0.00% CFD#9(Rincon Village Area)Special Tax Refunding Series 2011 Principal First American Treasury Obligations Fund Class D 168 168 1.79% n/a 0.00% CFD#10(Fairfield Ranch)Special Tax Refunding Series 2010 Improvement First American Treasury Obligations Fund Class D 165,404 165,404 1.79% n/a 0.07% CFD#10(Fairfield Ranch)Special Tax Refunding Series 2010 Interest First American Treasury Obligations Fund Class D 30 30 1.79% n/a 0.00% CFD#10(Fairfield Ranch)Special Tax Refunding Series 2010 Principal First American Treasury Obligations Fund Class D 172 172 1.79% n/a 0.00% CFD#10(Fairfield Ranch)Special Tax Refunding Series 2010 Reserve Federal Home Loan Banks Discount Note 981,633 983,368 2.29% 8/30/2019 0.42% CFD#10(Fairfield Ranch)Special Tax Refunding Series 2010 Reserve First American Treasury Obligations Fund Class D 117 117 1.79% n/a 0.00% Total Funds Held by Fiscal Agents $ 7,759,075 $ 7,772,295 3.29% City of Chino Hills Portfolio Summary Account#10150 As of June 30, 2019 Cilkii. PORTFOLIO CHARACTERISTICS ACCOUNT SUMMARY TOP ISSUERS Average Modified Duration 2.41 Beg.Values End Values Government of United States 21.9% as of 5/31/19 as of 6/30/19 Federal National Mortgage Assoc 15.6% Average Coupon 2.17% Market Value 202,129,494 203,501,081 Federal Home Loan Mortgage Corp 14.0% Average Purchase YTM 2.24% Accrued Interest 1,016,152 971,515 ° Total Market Value 203,145,646 204,472,596 Federal Home Loan Bank 12.9/° Average Market YTM 1.99% Income Earned 378,690 374,831 John Deere ABS 1.7% Average S&P/Moody Rating AA/Aa1 Cont/WD -11,885 Honda ABS 1.6% Par 201,529,497 201,645,566 State Street Bank 1.6% Average Final Maturity 2.66 yrs Book Value 201,082,138 201,515,107 Inter-American Dev Bank 1.5% Average Life 2.52 yrs Cost Value 200,756,475 201,179,433 Total 70.8% SECTOR ALLOCATION MATURITY DISTRIBUTION CREDIT QUALITY(S&P) Agency 34.9% 30% 26.4% 25.7% US Corp 26.1% 25% 22.0% AA(64.4%) US Treasury 21.9% 20% 17.6% CMO 7.7% 15% ABS■ 5.4% 10% 8.3% AAA(5,8%) Supras, 2.7% 5% 0.1% NR(I1.1%) Foreign Corp' 1.2% 0-.25 .25-.5 .5-1 1-2 2-3 3-4 4-5 5+ i MoneyMkt Fd 0.1% Maturity(Yrs) A(18.6%)- - PERFORMANCE REVIEW Annualized TOTAL RATE OF RETURN 1M 3M YTD 1YR 2YRS 3YRS 5YRS 10YRS 2/28/2011 City of Chino Hills 0.66% 1.73% 3.20% 4.92% 2.37% 1.59% 1.72% N/A 1.47% ICE BAML 1-5 Yr US Treasury/Agency Index* 0.65% 1.81% 3.05% 4.88% 2.24% 1.32% 1.54% N/A 1.24% *ICE BAML 1-3 Yr US Treasury/Agency Index to 7/31/12 Chandler Asset Management-CONFIDENTIAL Paee 1 Execution Time:7/1/2019 9:19:56 PM Statement of Compliance CAI As of June 30, 2019 City of Chino Hills Assets managed by Chandler Asset Management are in full compliance with state law and the Client's investment policy. 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 Securities "A"rating category or better by a NRSRO;30%maximum; 5%max per issuer Complies Banker's Acceptances "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 Complies issuer; 180 days max maturity "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 days max maturity;Issuer is a corporation organized and operating in the U.S.and have$500 million total assets; 10%max Complies of the outstanding commercial paper of any single issuer. 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 Complies (CD) institution is limited to maximum covered under FDIC; Collateralized if in excess of insured amounts "A"rating category or better by a NRSRO;30%maximum;5%max per issuer; Issued by corporations organized and Corporate Medium Term Notes Complies operating within 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; 20%maximum(combined ABS,MBS,MPTs,CMOs); 5%max per issuer;Issuers not Complies Securities;Pass-Throughs;CMOs defined in sections 4(U.S.Treasuries)and 5(Federal Agencies)of the Authorized Investments section of the policy. Mutual Fund&Money Market Mutual Highest rating or"AAA"rated by two NRSROs;SEC registered adviser with AUM>$500 million and experience>5 years;20% 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; Securities on margin; Prohibited Reverse Repurchase Agreements; Foreign currency denominated securities; No credit union may act as selected depository Complies institution under Section 53601.8 or Section 53635.8 for certificates of deposit 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 Mutual Funds,LAIF, Max Per Issuer Complies LACIP,or unless otherwise specified in the investment policy) Maximum maturity 5 years Complies City of Chino Hills Reconciliation Summary Cat Account#10150 As of June 30, 2019 BOOK VALUE RECONCILIATION CASH TRANSACTION SUMMARY BEGINNING BOOK VALUE $201,082,137.67 BEGINNING BALANCE $829,611.50 Acauisition - Acauisition +Security Purchases $8,908,134.81 Contributions $0.00 +Money Market Fund Purchases $5,527,632.75 Security Sale Proceeds $5,083,656.97 +Money Market Contributions $0.00 Accrued Interest Received $21,231.66 +Security Contributions $0.00 Interest Received $394,210.93 +Security Transfers $0.00, Dividend Received $1,003.26 Total Acquisitions $14,435,767.56 Principal on Maturities $2,200,000.00 Disoositions Interest on Maturities $0.00 -Security Sales $5,083,656.97 Calls/Redemption(Principal) $0.00 -Money Market Fund Sales $6,176,593.52 Interest from Calls/Redemption $0.00 -MMF Withdrawals $11,884.90 Principal Paydown $573,085.48 -Security Withdrawals $0.00 Total Acquisitions $8,273,188.30 -Security Transfers $0.00 Dispositions -Other Dispositions $0.00 Withdrawals $11,884.90 -Maturites $2,200,000.00 Security Purchase $8,908,134.81 -Calls $0.00 Accrued Interest Paid $14,014.26 -Principal Paydowns $573,085.48 Total Dispositions $8,934,033.97 Total Dispositions $14,045,220.87 ENDING BOOK VALUE I $168,765.83 Amortization/Accretion +/-Net Accretion $17,037.05 $17,037.05 Gain/Loss on Dispositions +/-Realized Gain/Loss $25,385.35 I $25,385.35 ENDING BOOK VALUE $201,515,106.76 Chandler Asset Management-CONFIDENTIAL Page 3 Execution Time:7/1/2019 9:19:56 PM City of Chino Hills Holdings Report Account#10150 As of June 30, 2019 A 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 89237RAB4 Toyota Auto Receivable 2017-C A2A 185,616.97 07/25/2017 185,615.20 99.93 185,482.90 0.09% Aaa/AAA 1.04 1.58%Due 7/15/2020 1.59% 185,616.35 2.60% 130.34 (133.45) NR 0.07 89238BAB8 Toyota Auto Receivables Owner 2018-A 793,721.73 01/23/2018 793,640.61 99.93 793,157.29 0.39% Aaa/AAA 1.30 A2A 2.12% 793,682.98 2.49% 740.81 (525.69) NR 0.19 2.1%Due 10/15/2020 65478VAD9 NAROT 2016-B A3 583,878.88 12/06/2017 580,174.65 99.73 582,293.29 0.28% Aaa/NR 1.55 1.32%Due 1/15/2021 1.73% 582,036.56 2.47% 85.63 256.73 AAA 0.24 161571HF4 Chase CHAIT 2016-A5 1,000,000.00 09/27/2018 988,320.31 99.96 999,584.00 0.49% NR/AAA 2.04 1.27%Due 7/15/2021 2.11% 991,477.60 2.54% 564.44 8,106.40 AAA 0.03 43811BAC8 Honda Auto Receivables 2017-2 A3 1,595,532.39 04/27/2018 1,570,726.85 99.71 1,590,959.48 0.78% Aaa/AAA 2.13 1.68%Due 8/16/2021 2.62% 1,579,524.16 2.16% 1,191.33 11,435.32 NR 0.60 47788BAD6 John Deere Owner Trust 2017-B A3 928,050.43 Various 918,273.28 99.74 925,664.25 0.45% Aaa/NR 2.30 1.82%Due 10/15/2021 2.73% 921,389.26 2.27% 750.69 4,274.99 AM 0.58 47788CAC6 John Deere Owner Trust 2016-B A4 620,000.00 02/21/2018 619,955.42 100.46 622,839.60 0.30% Aaa/NR 2.80 2.66%Due 4/18/2022 2.68% 619,969.83 2.21% 732.98 2,869.77 AAA 0.97 43815HAC1 Honda Auto Receivables Owner 2018-3 1,680,000.00 08/21/2018 1,679,769.50 101.25 1,701,006.72 0.83% Aaa/NR 3.15 A3 2.98% 1,679,818.13 2.10% 1,376.67 21,188.59 AAA 1.44 2.95%Due 8/22/2022 02587AAJ3 American Express Credit 2017-1 1,725,000.00 Various 1,699,587.14 99.80 1,721,472.38 0.84% Aaa/NR 3.21 1.93%Due 9/15/2022 3.01% 1,704,741.50 2.27% 1,479.66 16,730.88 MA 0.61 47788EAC2 John Deere Owner Trust 2018-B A3 1,910,000.00 07/18/2018 1,909,855.22 101.35 1,935,744.85 0.95% Aaa/NR 3.38 3.08%Due 11/15/2022 3.10% 1,909,886.59 2.13% 2,614.58 25,858.26 AAA 1.38 10,945,918.18 11,058,204.76 5.41% Aaa/AAA 2.61 Total ABS 11,021,800.40 2.69% 10,968,142.96 2.26% 9,667.13 90,061.80 AAA 0.78 AGENCY 3135G0A78 FNMA Note 3,000,000.00 12/08/2017 2,984,130.00 99.74 2,992,242.00 1.47% Aaa/AA+ 0.56 1.625%Due 1/21/2020 1.88% 2,995,800.93 2.09% 21,666.67 (3,558.93) AAA 0.55 3137EADR7 FHLMC Note 2,550,000.00 Various 2,525,807.60 99.43 2,535,439.50 1.24% Aaa/AA+ 0.84 1.375%Due 5/1/2020 1.59% 2,545,640.83 2.07% 5,843.75 (10,201.33) AAA 0.82 313383HU8 FHLB Note 2,500,000.00 09/15/2015 2,510,425.00 99.75 2,493,700.00 1.22% Aaa/AA+ 0.95 1.75%Due 6/12/2020 1.66% 2,502,089.82 2.02% 2,309.03 (8,389.82) NR 0.94 Chandler Asset Management-CONFIDENTIAL Page 4 Execution Time:7/1/2019 9:19:56 PM City of Chino Hills Holdings Report CAI Account#10150 As of June 30, 2019 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 3135GOD75 FNMA Note 2,625,000.00 09/29/2015 2,626,417.50 99.49 2,611,604.63 1.28% Aaa/AM- 0.98 1.5%Due 6/22/2020 1.49% 2,625,293.02 2.03% 984.38 (13,688.39) AAA 0.96 3137EAEK1 FHLMC Note 3,350,000.00 11/21/2017 3,341,319.58 99.97 3,348,944.75 1.64% Aaa/AA+ 1.39 1.875%Due 11/17/2020 1.96% 3,345,982.02 1.90% 7,677.08 2,962.73 AAA 1.35 3135G0F73 FNMA Note 2,700,000.00 12/16/2015 2,648,970.00 99.51 2,686,756.50 1.32% Aaa/AA+ 1.42 1.5%Due 11/30/2020 1.90% 2,685,395.83 1.85% 3,487.50 1,360.67 AAA 1.39 3130A7CV5 FHLB Note 2,235,000.00 02/17/2016 2,225,970.60 99.27 2,218,590.63 1.09% Aaa/AA+ 1.64 1.375%Due 2/18/2021 1.46% 2,232,044.56 1.83% 11,353.49 (13,453.93) AAA 1.60 3135G0120 FNMA Note 3,500,000.00 Various 3,472,861.80 99.23 3,473,085.00 1.71% Aaa/AA+ 1.66 1.375%Due 2/26/2021 1.59% 3,487,994.99 1.85% 16,710.07 (14,909.99) AAA 1.62 3135GOK69 FNMA Note 2,875,000.00 Various 2,869,786.50 98.97 2,845,462.25 1.39% Aaa/AA+ 1.85 1.25%Due 5/6/2021 1.29% 2,873,045.65 1.82% 5,490.45 (27,583.40) AAA 1.81 313379RB7 FHLB Note 1,695,000.00 08/30/2017 1,707,780.30 100.03 1,695,449.18 0.83% Aaa/AA+ 1.95 1.875%Due 6/11/2021 1.67% 1,701,584.63 1.86% 1,765.63 (6,135.45) AAA 1.90 3130A8QS5 FHLB Note 2,800,000.00 07/22/2016 2,778,272.00 98.75 2,765,106.40 1.36% Aaa/AA+ 2.04 1.125%Due 7/14/2021 1.29% 2,791,093.32 1.75% 14,612.50 (25,986.92) AAA 1.99 3137EAEC9 FHLMC Note 3,200,000.00 09/26/2016 3,176,448.00 98.58 3,154,508.80 1.55% Aaa/AA+ 2.12 1.125%Due 8/12/2021 1.28% 3,189,772.08 1.81% 13,900.00 (35,263.28) AAA 2.07 3135GON82 FNMA Note 3,200,000.00 09/28/2016 3,195,072.00 98.86 3,163,673.60 1.55% Aaa/AA+ 2.13 1.25%Due 8/17/2021 1.28% 3,197,849.70 1.80% 14,888.89 (34,176.10) AAA 2.08 3130AABG2 FHLB Note 3,375,000.00 02/27/2017 3,373,110.00 100.21 3,382,111.13 1.66% Aaa/AA+ 2.42 1.875%Due 11/29/2021 1.89% 3,374,039.20 1.79% 5,625.00 8,071.93 AAA 2.35 3135G0S38 FNMA Note 3,400,000.00 Various 3,396,588.25 100.52 3,417,836.40 1.69% Aaa/AA+ 2.52 2%Due 1/5/2022 2.02% 3,398,263.98 1.79% 33,244.45 19,572.42 AAA 2.42 3135G0T45 FNMA Note 3,485,000.00 06/19/2017 3,484,473.77 100.18 3,491,245.12 1.72% Aaa/AA+ 2.77 1.875%Due 4/5/2022 1.88% 3,484,696.59 1.81% 15,609.90 6,548.53 AAA 2.67 3135G0178 FNMA Note 3,500,000.00 12/08/2017 3,465,595.00 100.70 3,524,493.00 1.73% Aaa/AA+ 3.27 2%Due 10/5/2022 2.22% 3,476,685.18 1.78% 16,722.22 47,807.82 AAA 3.13 3130A3KM5 FHLB Note 2,750,000.00 12/15/2017 2,782,010.00 102.42 2,816,660.00 1.38% Aaa/AA+ 3.45 2.5%Due 12/9/2022 2.25% 2,772,144.51 1.77% 4,201.39 44,515.49 NR 3.29 3135G0T94 FNMA Note 3,500,000.00 04/11/2018 3,448,410.00 101.97 3,568,792.50 1.76% Aaa/AA+ 3.56 2.375%Due 1/19/2023 2.71% 3,461,581.29 1.80% 37,406.25 107,211.21 AAA 3.36 Chandler Asset Management-CONFIDENTIAL Page 5 Execution Time:7/1/2019 9:19:56 PM City of Chino Hills Holdings Report CAI% Account#10150 As of June 30, 2019 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 3137EAEN5 FHLMC Note 3,750,000.00 07/20/2018 3,731,175.00 103.54 3,882,731.25 1.90% Aaa/AA+ 3.97 2.75%Due 6/19/2023 2.86% 3,734,778.22 1.82% 3,437.50 147,953.03 AAA 3.75 3130A0F70 FHLB Note 3,500,000.00 01/16/2019 3,602,165.00 106.39 3,723,548.50 1.82% Aaa/AA+ 4.44 3.375%Due 12/8/2023 2.73% 3,592,726.46 1.87% 7,546.88 130,822.04 AAA 4.12 3130AB3H7 FHLB Note 3,500,000.00 04/29/2019 3,500,245.00 102.18 3,576,209.00 1.76% Aaa/AA+ 4.69 2.375%Due 3/8/2024 2.37% 3,500,236.44 1.89% 26,092.01 75,972.56 NR 4.39 3130A1XJ2 FHLB Note 3,500,000.00 06/18/2019 3,651,410.20 104.71 3,664,965.51 1.79% Aaa/AA+ 4.96 2.875%Due 6/14/2024 1.96% 3,650,412.99 1.87% 4,751.74 14,552.52 NR 4.61 70,498,443.10 71,033,155.65 34.87% Aaa/AA+ 2.56 Total Agency 70,490,000.00 1.92% 70,619,152.24 1.86% 275,326.78 414,003.41 AAA 2.44 CMO 3137BFDQ1 FHLMC K717 A2 2,500,000.00 12/28/2018 2,501,562.50 101.51 2,537,730.00 1.24% NR/NR 2.24 2.991%Due 9/25/2021 2.89% 2,501,277.84 2.15% 6,231.25 36,452.16 AAA 1.96 3137BM6P6 FHLMC K721 A2 3,500,000.00 06/26/2019 3,595,976.56 102.62 3,591,609.00 1.76% Aaa/NR 3.16 3.09%Due 8/25/2022 2.09% 3,595,727.05 2.11% 9,012.50 (4,118.05) NR 2.79 3137B5JM6 FHLMC K034 A2 3,100,000.00 08/28/2018 3,165,753.91 105.34 3,265,397.40 1.60% NR/NR 4.07 3.531%Due 7/25/2023 3.03% 3,154,580.52 2.08% 9,121.75 110,816.88 AAA 3.68 3137B7MZ9 FHLMC K036 A2 2,695,000.00 10/29/2018 2,721,528.91 105.49 2,843,055.22 1.39% Aaa/NR 4.32 3.527%Due 10/25/2023 3.32% 2,717,986.86 2.10% 1,584.21 125,068.36 AAA 3.86 3137BYPQ7 FHLMC K726 A2 3,300,000.00 04/22/2019 3,323,589.84 103.31 3,409,266.17 1.67% NR/AAA 4.82 2.905%Due 4/25/2024 2.72% 3,322,724.75 2.12% 7,988.75 86,541.42 NR 4.30 15,308,411.72 15,647,057.79 7.67% Aaa/AAA 3.77 Total CMO 15,095,000.00 2.77% 15,292,297.02 2.11% 33,938.46 354,760.77 AAA 3.36 FOREIGN CORPORATE 89114QCB2 Toronto Dominion Bank Note 2,300,000.00 03/26/2019 2,329,118.00 103.52 2,380,989.90 1.18% Aa3/A 4.70 3.25%Due 3/11/2024 2.97% 2,327,589.71 2.45% 22,840.28 53,400.19 AA- 4.31 2,329,118.00 2,380,989.90 1.18% Aa3/A 4.70 Total Foreign Corporate 2,300,000.00 2.97% 2,327,589.71 2.45% 22,840.28 53,400.19 AA- 4.31 Chandler Asset Management-CONFIDENTIAL Paae 6 Execution Time:7/1/2019 9:19:56 PM City of Chino Hills Holdings Report CM Account#10150 As of June 30, 2019 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 MONEY MARKET FUND FI 31846V401 First American Govt Obligation MMKT 168,765.83 Various 168,765.83 1.00 168,765.83 0.08% Aaa/AAA 0.00 Class-D 1.85% 168,765.83 1.85% 0.00 0.00 AAA 0.00 168,765.83 168,765.83 0.08% Aaa/AAA 0.00 Total Money Market Fund Fl 168,765.83 1.85% 168,765.83 1.85% 0.00 0.00 AAA 0.00 SUPRANATIONAL 45950KCM0 International Finance Corp Note 2,500,000.00 08/27/2018 2,468,725.00 100.53 2,513,225.00 1.24% Aaa/AAA 1.58 2.25%Due 1/25/2021 2.79% 2,479,600.17 1.91% 24,375.00 33,624.83 NR 1.52 4581XOCZ9 Inter-American Dev Bank Note 3,000,000.00 08/21/2018 2,872,200.00 99.85 2,995,566.00 1.47% NR/NR 3.21 1.75%Due 9/14/2022 2.87% 2,899,087.12 1.80% 15,604.17 96,478.88 AAA 3.09 • 5,340,925.00 5,508,791.00 2.71% Aaa/AAA 2.46 Total Supranational 5,500,000.00 2.83% 5,378,687.29 1.85% 39,979.17 130,103.71 AAA 2.37 US CORPORATE 94974BGF1 Wells Fargo Corp Note 2,025,000.00 Various 2,024,153.60 99.91 2,023,098.53 1.00% A2/A- 0.59 2.15%Due 1/30/2020 2.15% 2,025,009.39 2.31% 18,261.56 (1,910.86) A+ 0.57 747525AD5 Qualcomm Inc Note 1,930,000.00 Various 1,918,856.25 99.97 1,929,370.82 0.95% A2/A- 0.89 2.25%Due 5/20/2020 2.36% 1,928,328.70 2.29% 4,945.62 1,042.12 NR 0.87 857477AS2 State Street Bank Note 1,750,000.00 01/21/2016 1,778,420.00 100.44 1,757,777.00 0.87% Al/A 1.14 2.55%Due 8/18/2020 2.17% 1,757,062.35 2.15% 16,486.46 714.65 AA- 1.10 594918BG8 Microsoft Callable Note Cont.10/03/20 1,025,000.00 Various 1,025,086.50 99.96 1,024,592.05 0.50% Aaa/AAA 1.35 2%Due 11/3/2020 1.99% 1,025,058.40 2.03% 3,302.78 (466.35) AA+ 1.31 00440EAT4 Chubb INA Holdings Inc Callable Note 2,475,000.00 Various 2,484,922.25 100.04 2,476,059.30 1.22% A3/A 1.35 Cont 10/3/2020 2.18% 2,478,490.73 2.26% 9,171.25 (2,431.43) A 1.23 2.3%Due 11/3/2020 92826CAB8 Visa Inc Note 1,800,000.00 Various 1,845,865.00 100.16 1,802,824.20 0.88% Aa3/AA- 1.46 2.2%Due 12/14/2020 1.60% 1,815,017.59 2.09% 1,870.00 (12,193.39) NR 1.42 78012KKU0 Royal Bank of Canada Note 2,525,000.00 12/11/2017 2,534,569.75 100.42 2,535,723.68 1.25% Aa2/AA- 1.56 2.5%Due 1/19/2021 2.37% 2,529,797.54 2.22% 28,406.25 5,926.14 AA 1.50 Chandler Asset Management-CONFIDENTIAL Page 7 Execution Time:7/1/2019 9:19:56 PM City of Chino Hills Holdings Report Cil kii Account#10150 As of June 30, 2019 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 30231GAV4 Exxon Mobil Corp Callable Note Cont 1,795,000.00 Various 1,815,422.45 100.28 1,799,973.95 0.89% Aaa/AA+ 1.67 2/1/2021 1.97% 1,802,119.22 2.05% 13,294.97 (2,145.27) NR 1.62 2.222%Due 3/1/2021 3695506E7 General Dynamics Corp Note 2,390,000.00 Various 2,373,224.70 101.62 2,428,698.88 1.19% A2/A+ 1.87 3%Due 5/11/2021 3.25% 2,379,541.67 2.11% 9,958.34 49,157.21 NR 1.80 22160KAJ4 Costco Wholesale Corp Note 1,000,000.00 08/14/2017 1,005,170.00 100.10 1,001,010.00 0.49% Aa3/A+ 1.88 2.15%Due 5/18/2021 2.01% 1,002,592.55 2.09% 2,568.06 (1,582.55) NR 1.83 857477AV5 State Street Bank Note 1,420,000.00 Various 1,403,476.60 99.74 1,416,299.48 0.69% Al/A 1.89 1.95%Due 5/19/2021 2.33% 1,410,212.30 2.09% 3,230.50 6,087.18 AA- 1.84 594918BP8 Microsoft Callable Note Cont 7/8/21 1,225,000.00 Various 1,223,545.75 99.15 1,214,570.35 0.60% Aaa/AAA 2.11 1.55%Due 8/8/2021 1.57% 1,224,387.56 1.96% 7,542.26 (9,817.21) AA+ 2.05 68389XBK0 Oracle Corp Callable Note Cont 8/01/21 2,565,000.00 Various 2,507,672.07 99.49 2,552,015.97 1.26% Al/AA- 2.21 1.9%Due 9/15/2021 2.40% 2,538,264.54 2.14% 14,349.75 13,751.43 A 2.14 24422ETL3 John Deere Capital Corp Note 1,750,000.00 09/21/2017 1,777,457.50 101.07 1,768,793.25 0.88% A2/A 2.52 2.65%Due 1/6/2022 2.26% 1,766,151.47 2.21% 22,543.40 2,641.78 A 2.39 89236TDP7 Toyota Motor Credit Corp Note 2,500,000.00 Various 2,464,204.46 101.05 2,526,157.50 1.25% Aa3/AA- 2.54 2.6%Due 1/11/2022 3.01% 2,475,442.83 2.17% 30,694.44 50,714.67 A+ 2.41 91159HHP8 US Bancorp Callable Cont 12/23/2021 1,000,000.00 01/19/2017 998,280.00 101.07 1,010,690.00 0.50% Al/A+ 2.57 2.625%Due 1/24/2022 2.66% 999,116.45 2.18% 11,447.92 11,573.55 AA- 2.37 69353RFE3 PNC Bank Callable Note Cont 6/28/2022 2,365,000.00 07/25/2017 2,364,787.15 101.03 2,389,425.72 1.18% A2/A 3.08 2.45%Due 7/28/2022 2.45% 2,364,869.10 2.09% 24,625.56 24,556.62 A+ 2.85 44932HAC7 IBM Credit Corp Note 2,400,000.00 Various 2,354,504.00 99.75 2,394,062.40 1.18% Al/A 3.19 2.2%Due 9/8/2022 2.63% 2,369,178.91 2.28% 16,573.33 24,883.49 A 3.04 48128BAB7 JP Morgan Chase&Co Callable Note 1X 2,400,000.00 Various 2,372,445.00 101.45 2,434,831.20 1.21% A2/A- 3.55 1/15/2022 3.23% 2,380,032.32 2.38% 32,890.14 54,798.88 AA- 2.95 2.972%Due 1/15/2023 24422ETG4 John Deere Capital Corp Note 1,000,000.00 02/19/2019 992,320.00 102.15 1,021,526.00 0.50% A2/A 3.68 2.8%Due 3/6/2023 3.00% 992,997.34 2.19% 8,944.44 28,528.66 A 3.46 084670BR8 Berkshire Hathaway Callable Note Cont 2,400,000.00 11/26/2018 2,328,216.00 101.62 2,438,774.40 1.20% Aa2/AA 3.71 1/15/2023 3.51% 2,338,058.83 2.27% 19,433.33 100,715.57 A+ 3.34 2.75%Due 3/15/2023 037833AK6 Apple Inc Note 1,785,000.00 11/28/2018 1,702,515.15 100.99 1,802,675.07 0.88% Aa1/AA+ 3.84 2.4%Due 5/3/2023 3.54% 1,713,393.96 2.13% 6,902.00 89,281.11 NR 3.64 Chandler Asset Management-CONFIDENTIAL Page 8 Execution Time:7/1/2019 9:19:56 PM City of Chino Hills Holdings Report Account#10150 As of June 30, 2019 CA 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 097023BQ7 Boeing Co Callable Note Cont 1,700,000.00 02/13/2019 1,624,469.00 98.16 1,668,745.50 0.82% A2/A 3.96 4/15/2023 2.98% 1,630,966.29 2.36% 1,416.67 37,779.21 A 3.78 1.875%Due 6/15/2023 02665WCJ8 American Honda Finance Note 755,000.00 07/11/2018 753,693.85 104.30 787,438.58 0.39% A2/A 4.04 3.45%Due 7/14/2023 3.49% 753,944.48 2.33% 12,083.15 33,494.10 NR 3.71 69371RP59 Paccar Financial Corp Note 1,910,000.00 08/06/2018 1,909,216.90 103.47 1,976,255.99 0.98% Al/A+ 4.11 3.4%Due 8/9/2023 3.41% 1,909,356.71 2.51% 25,615.22 66,899.28 NR 3.78 06406RAJ6 Bank of NY Mellon Corp Note 2,400,000.00 05/16/2019 2,463,120.00 104.28 2,502,679.20 1.24% Al/A 4.12 3.45%Due 8/11/2023 2.79% 2,461,403.01 2.35% 32,200.00 41,276.19 AA- 3.78 02665WCQ2 American Honda Finance Note 1,870,000.00 10/03/2018 1,868,466.60 105.24 1,968,014.18 0.97% A2/A 4.28 3.625%Due 10/10/2023 3.64% 1,868,688.30 2.33% 15,252.19 99,325.88 NR 3.93 06051GHF9 Bank of America Corp Callable Note 1X 2,300,000.00 03/06/2019 2,309,361.00 103.67 2,384,361.70 1.18% A2/A- 4.68 3/5/2023 3.41% 2,308,770.81 2.50% 26,309.44 75,590.89 A+ 3.41 3.55%Due 3/5/2024 52,223,441.53 53,036,444.90 26.14% Al/A+ 2.66 Total US Corporate 52,460,000.00 2.68% 52,248,253.35 2.23% 420,319.03 788,191.55 A+ 2.44 US TREASURY 912828VF4 US Treasury Note 2,350,000.00 07/10/2015 2,323,478.58 99.42 2,336,414.65 1.14% Aaa/AA+ 0.92 1.375%Due 5/31/2020 1.62% 2,345,019.80 2.01% 2,736.85 (8,605.15) AAA 0.91 912828XM7 US Treasury Note 2,500,000.00 02/27/2017 2,504,695.88 99.67 2,491,700.00 1.23% Aaa/AA+ 1.09 1.625%Due 7/31/2020 1.57% 2,501,488.85 1.93% 16,945.79 (9,788.85) AAA 1.06 912828L32 US Treasury Note 3,500,000.00 12/11/2017 3,451,054.69 99.38 3,478,398.00 1.71% Aaa/AA+ 1.17 1.375%Due 8/31/2020 1.91% 3,478,953.02 1.91% 16,085.26 (555.02) AAA 1.15 912828L99 US Treasury Note 2,650,000.00 11/23/2015 2,608,499.12 99.35 2,632,817.40 1.29% Aaa/AA+ 1.34 1.375%Due 10/31/2020 1.71% 2,638,767.37 1.87% 6,138.93 (5,949.97) AAA 1.31 912828N89 US Treasury Note 3,200,000.00 Various 3,186,303.70 99.30 3,177,500.80 1.56% Aaa/AA+ 1.59 1.375%Due 1/31/2021 1.48% 3,194,881.16 1.83% 18,353.59 (17,380.36) AAA 1.55 912828B90 US Treasury Note 2,150,000.00 Various 2,194,878.31 100.30 2,156,467.20 1.06% Aaa/AM- 1.67 2%Due 2/28/2021 1.55% 2,165,594.01 1.82% 14,372.28 (9,126.81) AAA 1.62 912828Q37 US Treasury Note 3,200,000.00 Various 3,155,350.56 99.06 3,170,000.00 1.56% Aaa/AA+ 1.75 1.25%Due 3/31/2021 1.59% 3,181,558.22 1.80% 10,054.64 (11,558.22) AAA 1.72 Chandler Asset Management-CONFIDENTIAL Page 9 Execution Time:7/1/2019 9:19:56 PM City of Chino Hills Holdings Report CM Account#10150 As of June 30, 2019 Purchase Date Cost Value Mkt Price Market Value %of Port. Moody/S&P Maturity CUSIP Security Description Par Value/Units Book Yield Book Value Mkt YTM Accrued Int. Gain/Loss Fitch Duration US TREASURY 912828T34 US Treasury Note 3,200,000.00 11/09/2016 3,145,885.73 98.68 3,157,750.40 1.55% Aaa/AA+ 2.25 1.125%Due 9/30/2021 1.48% 3,175,080.15 1.73% 9,049.18 (17,329.75) AAA 2.20 912828F96 US Treasury Note 2,800,000.00 01/27/2017 2,807,337.51 100.61 2,816,954.00 1.38% Aaa/AA+ 2.34 2%Due 10/31/2021 1.94% 2,803,607.43 1.73% 9,434.78 13,346.57 AAA 2.27 912828/43 US Treasury Note 3,610,000.00 03/13/2017 3,544,721.85 100.06 3,612,256.25 1.78% Aaa/AA+ 2.67 1.75%Due 2/28/2022 2.14% 3,574,927.86 1.73% 21,115.56 37,328.39 AAA 2.58 912828XG0 US Treasury Note 3,600,000.00 08/15/2017 3,651,058.94 101.18 3,642,469.20 1.78% Aaa/AA+ 3.00 2.125%Due 6/30/2022 1.82% 3,631,445.19 1.72% 207.88 11,024.01 AAA 2.90 912828L24 US Treasury Note 1,250,000.00 09/26/2017 1,250,541.30 100.45 1,255,615.00 0.62% Aaa/AA+ 3.17 1.875%Due 8/31/2022 1.87% 1,250,348.13 1.73% 7,833.73 5,266.87 AAA 3.05 912828L57 US Treasury Note 3,600,000.00 10/17/2017 3,560,062.50 100.07 3,602,530.80 1.77% Aaa/AA+ 3.25 1.75%Due 9/30/2022 1.99% 3,573,779.97 1.73% 15,836.07 28,750.83 AAA 3.13 912828N30 US Treasury Note 3,850,000.00 01/25/2018 3,790,144.53 101.36 3,902,487.05 1.91% Aaa/AA+ 3.51 2.125%Due 12/31/2022 2.46% 3,807,469.36 1.72% 222.32 95,017.69 AAA 3.36 912828666 US Treasury Note 1,500,000.00 04/29/2019 1,529,648.44 104.42 1,566,328.50 0.77% Aaa/AA+ 4.63 2.75%Due 2/15/2024 2.31% 1,528,599.24 1.75% 15,497.24 37,729.26 AAA 4.30 912828X70 US Treasury Note 1,650,000.00 Various 1,660,748.05 101.09 1,667,981.70 0.82% Aaa/AA+ 4.84 2%Due 4/30/2024 1.86% 1,660,698.60 1.76% 5,559.78 7,283.10 AAA 4.58 44,364,409.69 44,667,670.95 21.93% Aaa/AA+ 2.37 Total US Treasury 44,610,000.00 1.84% 44,512,218.36 1.79% 169,443.88 155,452.59 AAA 2.28 201,179,433.05 203,501,080.78 100.00% Aa1/AA 2.66 TOTAL PORTFOLIO 201,645,566.23 2.24% 201,515,106.76 1.99% 971,514.73 1,985,974.02 AAA 2.41 TOTAL MARKET VALUE PLUS ACCRUED 204,472,595.51 Chandler Asset Management-CONFIDENTIAL Page 10 Execution Time:7/1/2019 9:19:56 PM City of Chino Hills Transaction Ledger CAI k Account#10150 As of June 30, 2019 Transaction Settlement Acq/Disp Interest Type Date CUSIP Quantity Security Description Price Yield Amount Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase 06/03/2019 31846V401 1,003.26 First American Govt Obligation MMKT 1.000 1.86% 1,003.26 0.00 1,003.26 0.00 Class-D Purchase 06/08/2019 31846V401 59,062.50 First American Govt Obligation MMKT 1.000 1.86% 59,062.50 0.00 59,062.50 0.00 Class-D Purchase 06/09/2019 31846V401 34,375.00 First American Govt Obligation MMKT 1.000 1.86% 34,375.00 0.00 34,375.00 0.00 Class-D Purchase 06/11/2019 31846V401 15,890.63 First American Govt Obligation MMKT 1.000 1.86% 15,890.63 0.00 15,890.63 0.00 Class-D Purchase 06/11/2019 912828X70 800,000.00 US Treasury Note 100.352 1.92% 802,812.50 1,826.09 804,638.59 0.00 2%Due 4/30/2024 Purchase 06/12/2019 31846V401 21,875.00 First American Govt Obligation MMKT 1.000 1.86% 21,875.00 0.00 21,875.00 0.00 Class-D Purchase 06/13/2019 31846V401 799,151.11 First American Govt Obligation MM KT 1.000 1.86% 799,151.11 0.00 799,151.11 0.00 Class-D Purchase 06/14/2019 31846V401 19,800.00 First American Govt Obligation MMKT 1.000 1.86% 19,800.00 0.00 19,800.00 0.00 Class-D Purchase 06/15/2019 31846V401 15,937.50 First American Govt Obligation MMKT 1.000 1.86% 15,937.50 0.00 15,937.50 0.00 Class-D Purchase 06/17/2019 31846V401 2,774.38 First American Govt Obligation M MKT 1.000 1.86% 2,774.38 0.00 2,774.38 0.00 Class-D Purchase 06/17/2019 31846V401 1,058.33 First American Govt Obligation MMKT 1.000 1.86% 1,058.33 0.00 1,058.33 0.00 Class-D Purchase 06/17/2019 31846V401 133,030.93 First American Govt Obligation M M KT 1.000 1.86% 133,030.93 0.00 133,030.93 0.00 Class-D Purchase 06/17/2019 31846V401 77,180.89 First American Govt Obligation M MKT 1.000 1.86% 77,180.89 0.00 77,180.89 0.00 Class-D Purchase 06/17/2019 31846V401 1,374.33 First American Govt Obligation MMKT 1.000 1.86% 1,374.33 0.00 1,374.33 0.00 Class-D Purchase 06/17/2019 31846V401 4,902.33 First American Govt Obligation MMKT 1.000 1.86% 4,902.33 0.00 4,902.33 0.00 Class-D Purchase 06/17/2019 31846V401 101,451.21 First American Govt Obligation MMKT 1.000 1.86% 101,451.21 0.00 101,451.21 0.00 Class-D Chandler Asset Management-CONFIDENTIAL Page 11 Execution Time:7/1/2019 9:19:56 PM City of Chino Hills Transaction Ledger ciiii Account#10150 As of June 30,2019 Transaction Settlement Acq/Disp Interest Type Date CUSIP Quantity Security Description Price Yield Amount Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase 06/17/2019 31846V401 96,521.26 First American Govt Obligation MMKT 1.000 1.86% 96,521.26 0.00 96,521.26 0.00 Class-D Purchase 06/17/2019 31846V401 171,650.56 First American Govt Obligation MMKT 1.000 1.86% 171,650.56 0.00 171,650.56 0.00 Class-D Purchase 06/19/2019 3130A1X12 1,315,000.00 FHLB Note 104.331 1.96% 1,371,952.65 525.09 1,372,477.74 0.00 2.875%Due 6/14/2024 Purchase 06/19/2019 3130A1XJ2 2,185,000.00 FHLB Note 104.323 1.96% 2,279,457.55 872.48 2,280,330.03 0.00 2.875%Due 6/14/2024 Purchase 06/19/2019 31846V401 51,562.50 First American Govt Obligation MM KT 1.000 1.86% 51,562.50 0.00 51,562.50 0.00 Class-D Purchase 06/21/2019 31846V401 4,130.00 First American Govt Obligation MMKT 1.000 1.86% 4,130.00 0.00 4,130.00 0.00 Class-D Purchase 06/22/2019 31846V401 19,687.50 First American Govt Obligation M M KT 1.000 1.86% 19,687.50 0.00 19,687.50 0.00 Class-D Purchase 06/23/2019 31846V401 24,612.50 First American Govt Obligation M M KT 1.000 1.86% 24,612.50 0.00 24,612.50 0.00 Class-D Purchase 06/23/2019 31846V401 2,200,000.00 First American Govt Obligation MMKT 1.000 1.86% 2,200,000.00 0.00 2,200,000.00 0.00 Class-D Purchase 06/24/2019 31846V401 810,879.18 First American Govt Obligation M M KT 1.000 1.86% 810,879.18 0.00 810,879.18 0.00 Class-D Purchase 06/25/2019 31846V401 749,302.79 First American Govt Obligation MMKT 1.000 1.86% 749,302.79 0.00 749,302.79 0.00 Class-D Purchase 06/25/2019 31846V401 9,121.75 First American Govt Obligation MMKT 1.000 1.86% 9,121.75 0.00 9,121.75 0.00 Class-D Purchase 06/25/2019 31846V401 7,921.06 First American Govt Obligation MMKT 1.000 1.86% 7,921.06 0.00 7,921.06 0.00 Class-D Purchase 06/25/2019 31846V401 6,231.25 First American Govt Obligation MMKT 1.000 1.86% 6,231.25 0.00 6,231.25 0.00 Class-D Purchase 06/25/2019 31846V401 7,988.75 First American Govt Obligation MMKT 1.000 1.86% 7,988.75 0.00 7,988.75 0.00 Class-D Chandler Asset Management-CONFIDENTIAL Page 12 Execution Time:7/1/2019 9:19:56 PM City of Chino Hills Transaction Ledger GU Account#10150 As of June 30, 2019 Transaction Settlement Acq/Disp Interest Type Date CUSIP Quantity Security Description Price Yield Amount Pur/Sold Total Amount Gain/Loss ACQUISITIONS Purchase 06/27/2019 912828X70 850,000.00 US Treasury Note 100.934 1.80% 857,935.55 2,679.35 860,614.90 0.00 2%Due 4/30/2024 Purchase 06/28/2019 3137BM6P6 3,500,000.00 FHLMC K721 A2Due 8/25/2022 102.742 2.09% 3,595,976.56 8,111.25 3,604,087.81 0.00 Purchase 06/30/2019 31846V401 79,156.25 First American Govt Obligation MMKT 1.000 1.85% 79,156.25 0.00 79,156.25 0.00 Class-D Subtotal 14,177,632.75 14,435,76756 14,014.26 14,449,781.82 0.00 TOTAL ACQUISITIONS 14,177,632.75 14,435,767.56 14,014.26 14,449,781.82 0.00 DISPOSITIONS Sale 06/11/2019 31846V401 804,638.59 First American Govt Obligation MMKT 1.000 1.86% 804,638.59 0.00 804,638.59 0.00 Class-D Sale 06/13/2019 674599CK9 800,000.00 Occidental Petroleum Callable Note 99.475 2.79% 795,800.00 3,351.11 799,151.11 9,989.43 Cont 3/15/2022 2.6%Due 4/15/2022 Sale 06/19/2019 3135G0A78 500,000.00 FNMA Note 99.657 2.21% 498,285.00 3,340.28 501,625.28 -973.99 1.625%Due 1/21/2020 Sale 06/19/2019 31846V401 907,252.22 First American Govt Obligation MMKT 1.000 1.86% 907,252.22 0.00 907,252.22 0.00 Class-D Sale 06/19/2019 912828J84 2,250,000.00 US Treasury Note 99.430 2.11% 2,237,167.97 6,762.30 2,243,930.27 -13,221.75 1.375%Due 3/31/2020 Sale 06/24/2019 674599CK9 805,000.00 Occidental Petroleum Callable Note 100.232 2.51% 806,867.60 4,011.58 810,879.18 15,994.26 Cont 3/15/2022 2.6%Due 4/15/2022 Sale 06/25/2019 674599CK9 745,000.00 Occidental Petroleum Callable Note 100.072 2.57% 745,536.40 3,766.39 749,302.79 13,597.40 Cont 3/15/2022 2.6%Due 4/15/2022 Sale 06/27/2019 31846V401 860,614.90 First American Govt Obligation MMKT 1.000 1.86%' 860,614.90 0.00 860,614.90 0.00 Class-D Chandler Asset Management-CONFIDENTIAL Page 13 Execution Time:7/1/2019 9:19:56 PM City of Chino Hills Transaction Ledger CM Account#10150 As of June 30, 2019 Transaction Settlement Acq/Disp Interest Type Date CUSIP Quantity Security Description Price Yield Amount Pur/Sold Total Amount Gain/Loss DISPOSITIONS Sale 06/28/2019 31846V401 3,604,087.81 First American Govt Obligation MMKT 1.000 1.85% 3,604,087.81 0.00 3,604,087.81 0.00 Class-D Subtotal 11,276,593.52 11,260,250.49 21,231.66 11,281,482.15 25,385.35 Paydown 06/17/2019 02587AAJ3 0.00 American Express Credit 2017-1 100.000 0.00 2,774.38 2,774.38 0.00 1.93%Due 9/15/2022 Paydown 06/17/2019 161571HF4 0.00 Chase CHAIT 2016-A5 100.000 0.00 1,058.33 1,058.33 0.00 1.27%Due 7/15/2021 Paydown 06/17/2019 43811BAC8 130,614.32 Honda Auto Receivables 2017-2 A3 100.000 130,614.32 2,416.61 133,030.93 0.00 1.68%Due 8/16/2021 Paydown 06/17/2019 47788BAD6 75,658.60 John Deere Owner Trust 2017-B A3 100.000 75,658.60 1,522.29 77,180.89 0.00 1.82%Due 10/15/2021 Paydown 06/17/2019 47788CAC6 0.00 John Deere Owner Trust 2016-B A4 100.000 0.00 1,374.33 1,374.33 0.00 2.66%Due 4/18/2022 Paydown 06/17/2019 47788EAC2 0.00 John Deere Owner Trust 2018-B A3 100.000 0.00 4,902.33 4,902.33 0.00 3.08%Due 11/15/2022 Paydown 06/17/2019 65478VAD9 100,698.18 NAROT 2016-B A3 100.000 100,698.18 753.03 101,451.21 0.00 1.32%Due 1/15/2021 Paydown 06/17/2019 89237RAB4 96,150.27 Toyota Auto Receivable 2017-C A2A 100.000 96,150.27 370.99 96,521.26 0.00 1.58%Due 7/15/2020 Paydown 06/17/2019 89238BAB8 169,964.11 Toyota Auto Receivables Owner 2018-A 100.000 169,964.11 1,686.45 171,650.56 0.00 A2A 2.1%Due 10/15/2020 Paydown 06/21/2019 43815HAC1 0.00 Honda Auto Receivables Owner 2018-3 100.000 0.00 4,130.00 4,130.00 0.00 A3 2.95%Due 8/22/2022 Paydown 06/25/2019 3137B5JM6 0.00 FHLMC K034 A2 100.000 0.00 9,121.75 9,121.75 0.00 3.531%Due 7/25/2023 Paydown 06/25/2019 3137B7MZ9 0.00 FHLMC K036 A2Due 10/25/2023 100.000 0.00 7,921.06 7,921.06 0.00 Paydown 06/25/2019 3137BFDQ1 0.00 FHLMC K717 A2 100.000 0.00 6,231.25 6,231.25 0.00 2.991%Due 9/25/2021 Chandler Asset Management-CONFIDENTIAL Page 14 Execution Time:7/1/2019 9:19:56 PM City of Chino Hills Transaction Ledger Account#10150 As of June 30, 2019 A Transaction Settlement Acq/Disp Interest Type Date CUSIP Quantity Security Description Price Yield Amount Pur/Sold Total Amount Gain/Loss DISPOSITIONS Paydown 06/25/2019 3137BYPQ7 0.00 FHLMC K726 A2 100.000 0.00 7,988.75 7,988.75 0.00 2.905%Due 4/25/2024 Subtotal 573,085.48 573,085.48 52,251.55 625,337.03 0.00 Maturity 06/23/2019 40434CAC9 2,200,000.00 HSBC USA Inc Note 100.000 2,200,000.00 0.00 2,200,000.00 0.00 2.25%Due 6/23/2019 Subtotal 2,200,000.00 2,200,000.00 0.00 2,200,000.00 0.00 Security 06/05/2019 31846V401 11,780.73 First American Govt Obligation MMKT 1.000 11,780.73 0.00 11,780.73 0.00 Withdrawal Class-D Security 06/25/2019 31846V401 104.17 First American Govt Obligation MMKT 1.000 104.17 0.00 104.17 0.00 Withdrawal Class-D Subtotal 11,884.90 11,884.90 0.00 11,884.90 0.00 TOTAL DISPOSITIONS 14,061,563.90 14,045,220.87 73,483.21 14,118,704.08 25,385.35 OTHER TRANSACTIONS Interest 06/08/2019 3130A0F70 3,500,000.00 FHLB Note 0.000 59,062.50 0.00 59,062.50 0.00 3.375%Due 12/8/2023 Interest 06/09/2019 3130A3KM5 2,750,000.00 FHLB Note 0.000 34,375.00 0.00 34,375.00 0.00 2.5%Due 12/9/2022 Interest 06/11/2019 313379RB7 1,695,000.00 FHLB Note 0.000 15,890.63 0.00 15,890.63 0.00 1.875%Due 6/11/2021 Interest 06/12/2019 313383HU8 2,500,000.00 FHLB Note 0.000 21,875.00 0.00 21,875.00 0.00 1.75%Due 6/12/2020 Interest 06/14/2019 92826CAB8 1,800,000.00 Visa Inc Note 0.000 19,800.00 0.00 19,800.00 0.00 2.2%Due 12/14/2020 Interest 06/15/2019 097023BQ7 1,700,000.00 Boeing Co Callable Note Cont 0.000 15,937.50 0.00 15,937.50 0.00 4/15/2023 1.875%Due 6/15/2023 Interest 06/19/2019 3137EAEN5 3,750,000.00 FHLMC Note 0.000 51,562.50 0.00 51,562.50 0.00 2.75%Due 6/19/2023 Chandler Asset Management-CONFIDENTIAL Page 15 Execution Time:7/1/2019 9:19:56 PM City of Chino Hills Transaction Ledger Citit Account#10150 As of June 30, 2019 Transaction Settlement Acq/Disp Interest Type Date CUSIP Quantity Security Description Price Yield Amount Pur/Sold Total Amount Gain/Loss OTHER TRANSACTIONS Interest 06/22/2019 3135G0D75 2,625,000.00 FNMA Note 0.000 19,687.50 0.00 19,687.50 0.00 1.5%Due 6/22/2020 Interest 06/23/2019 40434CAC9 2,200,000.00 HSBC USA Inc Note 0.000 24,612.50 0.00 24,612.50 0.00 2.25%Due 6/23/2019 Interest 06/30/2019 912828N30 3,850,000.00 US Treasury Note 0.000 40,906.25 0.00 40,906.25 0.00 2.125%Due 12/31/2022 Interest 06/30/2019 912828XG0 3,600,000.00 US Treasury Note 0.000 38,250.00 0.00 38,250.00 0.00 2.125%Due 6/30/2022 Subtotal 29,970,000.00 341,959.38 0.00 341,959.38 0.00 Dividend 06/03/2019 31846V401 829,611.50 First American Govt Obligation MMKT 0.000 1,003.26 0.00 1,003.26 0.00 Class-D Subtotal 829,611.50 1,003.26 0.00 1,003.26 0.00 TOTAL OTHER TRANSACTIONS 30,799,611.50 342,962.64 0.00 342,962.64 0.00 Chandler Asset Management-CONFIDENTIAL Page 16 Execution Time:7/1/2019 9:19:56 PM 00335501 40--01-f3- 2-18 bank. 0102 -19-02877-01-01 PARS/CITY OF CHINO HILLS 115P Page 5 of 21 ACCOUNT,� * 6746■0�531 00 w Period from June 1,2019 to June 30,2019 AssE f! u�lA� FA ''�iiAs?! s !":!' ! ' s s ! i '' ii i i 's ' '' ' jmoig ' ' ' N,,!!!ii!ii ii! ii�i';!!i!its is! iiNii,i ii ! ! !!!ii N:i* li h! 1 i !i! 1i l ! '' is! S s ' ' s i iiii l i i 06/30/2019 06/30/2019 %OF ASSETS ITT 0OOK VALUE MARKET Cash And Equivalents 247,005.42 247,005.42 3.40 Mutual Funds-Equity 3,737,359.77 3,257,658.06 51.44 Mutual Funds-Fixed Income 3,278,925.97 3,176,816.60 45.13 Total Assets 7,263,291.16 6,681,480.08 99.97 MUTUAL FUNDS y12f1 4 L CASH EQUIV BACCR Accrued Income 2,072.78 2,072.78 0.03 ' Grand Total 7,265,363.94 6,683,552.86 100.00 Estimated Annual Income 173,596.46 ,''' � il ��i �E'�i,.,,.....,, !� ✓� �'�'�''i!i`i!'i!''''!'`''"i'i;3''„i�"`�i� ','i�i�!���! i�i'i� i'ieiii Estimated Annual Income is an estimate provided for informational purposes only and should not be relied on for making investment,trading,or tax decisions.The estimates may not represent the actual value earned by your investments and they provide no guarantee of what your investments may earn in the future. 00335501 40--01-B-62-185-01 [embank® 7LA 0102 -19-02877-01 PARS/CITY OF CHINO HILLS 115P Page 6 of 21 ACCOUNT� + 6746053100� � Period from June 1,2019 to June 30,2019 iiiiiiM S.SASTT,iili Y!!Ei;Ai;iR'A!IViij 1ij( ?h j!?"''u" r l ? ! !!i !u r r ti? ` a1j1l ? ? jit i 'i ''rig'! j1[Ij iiliill4? iI? !ti?! l '!!` ' j ii i$iUVI! iiii lS iiii ;i !! 'ii i i i2 Nj i IGi ?Ir? i UNREALIZED GAIN(LOSS) ADJ PRIOR MARKET/ SHARES/ MARKET SINCE INCEPTION/ ADJ PRIOR MARKET ENDING ACCRUAL DESCRIPTION FADE AMOUNT PRICE/UNIT BOOK VALUE CURRENT PERIOD UNREALIZED GAIN/LOSS YIELD ON MARKET Cash And Equivalents Money Markets First Am Govt 245,179.330 245,179.33 245,179.33 .00 245,179.33 433.70 Ob Fd CI Z 1.0000 .00 .00 2.27 31846V567 Asset Minor Code 1 Total Money Markets 245,179.330 245,179.33 245,179.33 .00 245,179.33 433.70 .00 .00 2.27 Cash Cash 1,826.09 1,826.09 1,826.09 Total Cash .000 1,826.09 1,826.09 .00 1,826.09 .00 .00 .00 0.00 Total Cash And 245,179.330 247,005.42 247,005.42 .00 247,005.42 433.70 Equivalents .00 .00 2.25 Mutual Funds Mutual Funds-Equity (shares Core 3,757.000 1,107,375.75 905,025.59 202,350.16 1,024,248.09 .00 S P 500 Etf 294.7500 65,390.44 83,127.66 2.02 464287200 Asset Minor Code 94 (shares S P 2,461.000 441,109.64 347,129.40 93,980.24 402,764.59 .00 500 Growth Etf 179.2400 23,027.46 38,345.05 1.29 464287309 -Asset Minor Code 94 Ishares S P 3,772.000 439,702.04 402,043.41 37,658.63 414,450.53 .00 500 Value Etf 116.5700 29,569.29 25,251.51 2.32 464287408 Asset Minor Code 94 00335501 _ 40--01-B- 2 1 CO bank. 0102 -19-02877-0177-01 PARS/CITY OF CHINO HILLS 115P Page 7 of 21 ACCOUNT 6746053100 Period from June 1,2019 to June 30,2019 :�:�h !��g�:�c:riif fig „����� ' a� i��aat�! j���''���a�'„aaaFaa�ara������!!i!�i!!i ���I��Ii �ll�!����li;i���liiil�i���1����!�ll�I��� �!!!Iiiiy!!Gi�uili!l�i! j��ij��j�����iji?�"I� i!' r!�4��l�l� '�l!lwi�9� ��?� i��!!��i:VI:���lj�i!���!�� �ti����i1 iiiM UNREALIZED GAIN(LOSS) ADJ PRIOR MARKET/ SHARES/ MARKET SINCE INCEPTION/ ADJ PRIOR MARKET ENDING ACCRUAL DESCRIPTION FACE AMOUNT PRICNIT IjOOK VALUE CURRENT PERIOD UNREALIZED GAIN/LOSS YIELD ON MARKET (shares Msci 6,366.000 418,437.18 387,789.37 30,647.81 423,900.67 .00 Eafe Etf 65.7300 12,805.59 -5,463.49 3.06 464287465 Asset Minor Code 94 (shares 5,299.000 296,055.13 253,963.76 42,091.37 279,343.56 .00 Russell Mid Cap Etf 55.8700 17,618.50 16,711.57 1.61 464287499 Asset Minor Code 94 (shares 2,286.000 275,463.00 275,999.70 -536.70 296,299.81 .00 Russell 2000 Value Etf 120.5000 17,592.34 -20,836.81 1.82 464287630 Asset Minor Code 94 Ishares 1,396.000 280,414.52 237,092.58 43,321.94 277,765.02 .00 Russell 2000 Growth Etf 200.8700 18,200.70 2,649.50 0.64 464287648 Asset Minor Code 94 Vanguard Ftse 7,187.000 305,663.11 284,852.49 20,810.62 300,180.15 .00 Emerging Markets Etf 42.5300 13,134.29 5,482.96 2.57 922042858 Asset Minor Code 94 Vanguard Real 1,981.000 173,139.40 163,761.76 9,377.64 165,345.44 1,639.08 Estate Etf 87.4000 1,432.66 7,793.96 4.05 922908553 Asset Minor Code 94 Total Mutual Funds-Equity 34,505.000 3,737,359.77 3,257,658.06 479,701.71 3,584,297.86 1,639.08 198,771.27 153,061.91 2.07 Mutual Funds-Fixed Income • (shares Core 23,269.000 2,591,003.15 2,501,473.72 89,529.43 2,478,514.95 .00 U.S.Aggregate Bond Etf 111.3500 22,233.69 112,488.20 2.71 464287226 Asset Minor Code 95 Vanguard 64,231.823 687,922.82 675,342.88 12,579.94 670,501.04 .00 Short Term Invt Grade#539 10.7100 1,535.08 17,421.78 2.92 922031836 Asset Minor Code 99 Total Mutual Funds-Fixed 87,500.823 3,278,925.97 3,176,816.60 102,109.37 3,149,015.99 .00 Income 23,768.77 129,909.98 2.75 00335501 40- - 2 1 =bank.0102 -19-02877-0177-01 kitt"'''' PARS/CITY OF CHINO HILLS 115P Page 8 of 21 ACCOUNT 6746053100 Period from June 1,2019 to June 30,2019 UNREALIZED GAIN(LOSS) ADJ PRIOR MARKET/ SHARES/ MARKET SINCE INCEPTION/ ADJ PRIOR MARKET ENDING ACCRUAL DESCRIPTION FACE AMOUNT PRICE(UNIT gIOOK VALUE CURRENT PERIOD UNREALIZED GAIN/LOSS YIELD ON MARKET Total Mutual Funds 122,005.823 7,016,285.74 6,434,474.66 581,811.08 6,733,313.85 1,639.08 222,540.04 282,971.89 2.39 • Total Assets 367,185.153 7,263,291.16 6,681,480.08 581,811.08 6,980,319.27 2,072.78 222,540.04 282.971.89 2.38 Accrued Income .000 2,072.78 2.072.78 Grand Total 367,185.153 7,265,363.94 6,683,552.86 ; '3 ii s ss i! 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. Yield on Market and Accrued Income are estimates provided for informational purposes only and should not be relied on for making investment,trading,or tax decisions.The estimates may not represent the actual value earned by your investments and they provide no guarantee of what your investments may earn in the future. 00335501Mbank. 40--01-B-62-185-01 0102 -19-02877-01 Page 9 of 21 PARS/CITY OF CHINO HILLS 115P Period from June 1,2019 to June 30,2019 21 ACCOUNT 6746053100 iii'i4��iti���i�i'i'i'i���!�,ii�+',i',+i'i'i'�i'i'i'i!i'i!i:ii�i�i'i�i:''i'�'�;�'�!i:�'i!i;i':!�'�'i' iiiiir�i�ai:!�!,' : �, i" ,� !�!�:,, " , I �i{isLi!i!i;!I�jl!i!i!j!i!,isisi;i?i;j!isisisisi!iti.',isi!j!j!;!,j!i!i!isi!Ilill:isisisitisisililitll.';i;i!I!i'!II;!'I�!i:j' !!i!!I!i!I!,27,ji2iii:i!iiili:i!i:ililiii!i!iliii';i�!ili!iiili!i!I!.',i'i i!i!:,!i:!!:!!i!i;i:i:,i!i!i!I!i';illi:ii�r�i ,yr �i;ji�����!ii:i:!i:!i:i:l5'.i'.I'.i'.2�!i';2?: ',�4'ry:r,r,,,,: : :,4',.,',.,y',,,,: .,: : '!i!i!i!i!i!i!i!i. ! . .. : . ... ..... +,+ : SHARES/ EX PAY ANN BEGINNING INCOME RNEp R INCOME E AOCR ENDING FACE AMOUNT DESCRIPTION RATE DATE RATE ACCRUAL. f,P► Cash And Equivalents 245,179.330 First Am Govt Ob Fd Cl Z 0.02 466.70 433.70 466.70 433.70 31846V567 07/01/19 Total Cash And Equivalents 466.70 433.70 466.70 433.70 Mutual Funds-Equity 3,757.000 (shares Core S P 500 Etf 5.95 .00 6,678.99 6,678.99 .00 464287200 06/17/19 06/21/19 2,461.000 (shares S P 500 Growth Etf 2.31 .00 1,843.98 1,843.98 .00 464287309 06/17/19 06/21/19 3,772.000 (shares S P 500 Value Etf 2.71 .00 2,438.59 2,438.59 .00 464287408 06/17/19 06/21/19 6,366.000 (shares Msci Eafe Etf 2.01 .00 8,760.40 8,760.40 .00 464287465 06/17/19 06/21/19 5,299.000 (shares Russell Mid Cap Etf 0.90 .00 1,024.15 1,024.15 .00464287499 06/17/19 06/21/19 2,286.000 (shares Russell 2000 Value Etf 2.20 .00 1,335.49 1,335.49 .00 464287630 06/17/19 06/21/19 1,396.000 (shares Russell 2000 Growth Etf 1.29 .00 453.65 453.65 .00 464287648 06/17/19 06/21/19 7,187.000 Vanguard Ftse Emerging Markets Etf 1.09 .00 2,006.61 2,006.61 .00 922042858 06/17/19 06/20/19 3.54 .00 1,639.08 .00 1,639.08 1,981.000 Vanguard Real Estate Etf 922908553 06/27/19 07/02/19 Total Mutual Funds-Equity .00 26,180.94 24,541.86 1,639.08 Mutual Funds-Fixed Income 00335501 40-0102 -B-02 77-011 [bank®0102 -19-02877-01 ril'1' PARS/CITY OF CHINO HILLS 115P Page 10 of 21 ACCOUNT 6746053100 Period from June 1,2019 to June 30,2019 I;i i;i;i;' ii ;iiii ; ; l ; i;i;i;i ; i;i;i; li;;ii i ';;;;;i i mul i;i ;i; ; ;; SHARES/ EX PAY ANN BEGINNING INCOME INCOME ENDING FACE AMOUNT DESCRIPTION RATE DATE RATE ACCRUAL. CABNEp FtEcEivEp ACRRUAL 23,269.000 (shares Core U.S.Aggregate Bond Etf 3.02 .00 5,750.02 5,750.02 .00 464287226 06/03/19 06/07/19 64,231.823 Vanguard Short Term Invt Grade#539 0.31 • .01 1,826.08 1,826.09 .00 922031836 06/28/19 07/01/19 Total Mutual Funds-Fixed Income .01 7,576.10 7,576.11 .00 Grand Total 466.71 34,190.74 32,584.67 2,072.78 00335501 40--01-B-62-185-01 IV bank. 0102 -19-02877-01 PARS/CITY OF CHINO HILLS 115P Page 11 of 21 ACCOUNT 6746053100 Period from June 1,2019 to June 30,2019 ��a����r�jra��•����� �j �i� � s�tis�ii�i;i;;;; s;i�;iis��!isi�iii � �i; ; � s ;i;; �2�e��� � a�cer �r ,�h�sj DATE DESCRIPTION QA§H Interest First Am Govt Ob Fd CI Z 31846V567 06/03/2019 Interest From 5/1/19 To 5/31/19 466.70 Total interest 466.70 Dividends (shares Core S P 500 Etf 464287200. 06/21/2019 1.777745 USD/Share On 3,757 Shares Due 6/21/19 6,678.99 (shares Core U.S.Aggregate Bond Etf 464287226 06/07/2019 0.260135 USD/Share On 22,104 Shares Due 6/7/19 5,750.02 (shares Msci Eafe Etf 464287465 06/21/2019 1.376123 USD/Share On 6,366 Shares Due 6/21/19 8,760.40 (shares Russell Mid Cap Etf 464287499 06/21/2019 0.193273 USD/Share On 5,299 Shares Due 6/21/19 1,024.15 (shares Russell 2000 Growth Etf 464287648 06/21/2019 0.324963 USD/Share On 1,396 Shares Due 6/21/19 453.65 (shares Russell 2000 Value Etf 464287630 06/21/2019 0.584204 USD/Share On 2,286 Shares Due 6/21/19 1,335.49 (shares S P 500 Growth Etf 464287309 00335501 40--01-B-62-185-01 ®bank® bi 0102 -19-02877-01 PARS/CITY OF CHINO HILLS 115P Page 12 of 21 ACCOUNT 6746053100 Period from June 1,2019 to June 30,2019 M:R ,,::Y ',ii' : ' i°'` iii'i ,ii ,,1' ' iri 'i` 'iiir ' ' ;; 's'";s' i311ir1` i;'iii''i 'ia;'; gii `si , ';i,,i''tiliiri;ri' icisii` ii'iiinili'ii'iy ;'! !!!s! DATE DESCRIPTIQN Ca§H 06/21/2019 0.749279 USD/Share On 2,461 Shares Due 6/21/19 1,843.98 (shares S P 500 Value Etf 464287408 06/21/2019 0.646498 USD/Share On 3,772 Shares Due 6/21/19 2,438.59 Vanguard Ftse Emerging Markets Etf 922042858 06/20/2019 0.2792 USD/Share On 7,187 Shares Due 6/20/19 2,006.61 Vanguard Short Term Invt Grade#539 922031836 06/30/2019 Dividend From 6/1/19 To 6/30/19 1,826.09 Total Dividends 32,117.97 Other Earnings Interest-Bank Compensation 06/26/2019 Income Payments .15 Interest Earned On Income Payments Total Other Earnings .15 00335501 40--01-B-62-185-01 arlbanlic 0102 -19-02877-01 PARS/CITY OF CHINO HILLS 115P Page 13 of 21 ACCOUNT 6746053100 Period from June 1,2019 to June 30,2019 ',PL DATE DESCRIPTION CA$H Trust Fees Trust Fees 06/26/2019 Collected -1,825.82 Charged For Period 05/01/2019 Thru 05/31/2019 Total Trust Fees -1,825.82 Total Trust Fees 1,825.82 Total Plan Expenses -1,825.82 00335501 -01-B- 2 1 01 C bank. 0102 -19-02877-0177-01 PARS/CITY OF CHINO HILLS 115P Page 14 of 21 ACCOUNT 6746053100 Period from June 1,2019 to June 30,2019 DATE DESCRIPTION CH Transfers Out Transfer To Another Account 06/27/2019 Paid To #6746050100 -1,459.51 Per Dir Dtd 6/26/19 Total Transfer To Another Account -1,459.51 Total Transfers Out -1.459.51 Total Other Activity -1,459.51 00335501-01-B- bank® 40--01-1 -0 -185-01 0102 -19-02877-01 Page 15 of 21 PARS/CITY OF CHINO HILLS 115P Period from June 1,2019 to June 30,of 21 ACCOUNT 6746053100 .._................_......._............._,.,.,.,.:.,:.:.:.,.,.�.,.:,.,.:.,.�.,.,.,.�ar;_�•: caararssas:nprrr,;�;;�;:,�,;�;,�tF;rt{v{v;v;' 19 v;",!r:rl; G. i s .iiiiiisiii"siiiiii!ii ;iiEiii�c;Ei . . iiiiiiii �t i1;,ii�;i;i sfi;ii;i;isi;isa;i;is:i 1 i;is?ii;i;�aiiiiii:.:.:.......... iii�i�'�i'�� ;i'„'r'i'iii,,i'',;;ii1 iiik iiiiii iii":�..i ii l Ia u :.,. SHARES/ CA $OOK VALUE DATE DESCRIPTION FACE AMOUNT COMMIS$ION $N Cash And Equivalents 06/04/2019 Purchased 466.7 466.700 .00 -466.70 466.70 Units Of First Am Govt Ob Fd CI Z Trade Date 6/4/19 31846V567 06/05/2019 Purchased 2,290.430 .00 -2,290.43 2,290.43 2,290.43 Units Of First Am Govt Ob Fd CI Z Trade Date 6/5/19 31846V567 06/07/2019 Purchased 5,750.020 .00 -5,750.02 5,750.02 5,750.02 Units Of First Am Govt Ob Fd CI Z Trade Date 6/7/19 31846V567 06/20/2019 Purchased 2,006.610 .00 -2,006.61 2,006.61 2,006.61 Units Of First Am Govt Ob Fd CI Z Trade Date 6/20/19 31846V567 06/21/2019 Purchased 22,535.250 .00 -22,535.25 22,535.25 22,535.25 Units Of First Am Govt Ob Fd CI Z Trade Date 6/21/19 31846V567 06/27/2019 Purchased 0.15 .150 .00 -.15 .15 Units Of First Am Govt Ob Fd CI Z Trade Date 6/27/19 31846V567 Total First Am Govt Ob Fd CI Z 33,049.160 .00 -33,049.16 33,049.16 Total Cash And Equivalents 33,049.160 .00 -33,049.16 33,049.16 00335501 [ibank. ' 40--01-B-62-185-01 0102 -19-02877-01 Page 16 of 21 PARS/CITY OF CHINO HILLS 115P Period from June 1,2019 to June 30,2019 ACCOUNT 6746053100 ..........._....._......._..._.............__.,.;.;_.;.,.;._.;..,._..:._..-:.:.......:...__-,.,:, r..r...:.:r.. .,r,';,r,r;,,r,r;r,r,r,'i'irr:,',:,.•r..•'.i ,',',;','irr,�;a�;ra:�;:w:r;a:;:;!;!;; !i;;�Fii ;i�s�ii"s�s�s�Fiii�:iiii�iiii.';:,,i�!::,;;;�,i;fFi;i;i;i;%iji;ai„i;i .___...._............._.._............. ......... ......... . . ................rrrrr �r rr,r,r.,r, ., .,..,,,,, ,,,. rrr.rrrr.r.r.:.:.:.:.r:. _. ,..,.. . r.r rrrr . ;.r.r.r.r.r... ::.r.:.:.:.:.r.. '.!!�?'.r!!?iii!�;i�i�:�i!i!:�i!:�i�i!!;i�i���'i�i�iii�iiiii!iiiiiiiii!i!�'ii;i�!iiii;ii!iii!i�!i!i!i!i�i';ii:i i'r!!!ii!!! !:i!,i!f!':ii!,!f i'ifii'i'i!i!�!�i�i�i�i�!i!i!?�i!i!��';�;';1!i!�;�'�i i����'!''�i.�.�'i��f•i!�'i!i!i!'i'i'i!'iii:'i'�'i.i i i i i i i i�i.:�',i i,'...f.,i'�,'i,i,is i,i.;i i.i:i.i i,i i i•�..�.. i,i.,ii,'.ii.i.i ii.ii.i,i.•..:....��'`i ii.:.r?r.r.r.r.r.r.r.r.r. r yr;r„r;r;yr;it r i .:.rrrr:•�.:rrrr,rr.,rrrr'rrrrrr:r':':�:r:•::r....r:.r.r(r'rr:ris'I't!EI!ri!'::::!:::::.:!:::.OI!uur!dr!::r!r!I!r!r!r!ru5!:.r.:.!.,...I......r...... .�..r..�:r•;r;rr:;rry:rr,rr::r:.:.;..:':':r r r r r r r,r,r,:,r,:::.r,.r rr r r r r r r r r:::•r....r.::.....rrr.r.r.,.r.:.r.:.r.:.....r.:.:.r.:....r.r..... SHARES/ DATE DESCRIPTIQN FAQE AMOUNT COMMISSION CASH ROOK VALUE Mutual Funds-Equity 06/04/2019 Purchased 38 38.000 1.33 -10,706.61 10,706.61 Shares Of (shares Core S P 500 Etf Trade Date 6/4/19 Purchased Through Ubs Securities LLC 38 Shares At 281.718 USD 464287200 Total(shares Core S P 500 Etf 38.000 1.33 -10,706.61 10,706.61 06/04/2019 Purchased 71 71.000 2.49 -3,809.79 3,809.79 Shares Of [shares Russell Mid Cap Etf Trade Date 6/4/19 - Purchased Through Ubs Securities LLC 71 Shares At 53.624 USD 464287499 • 71.000 Total Ishares Russell Mid Cap Etf 2.49 -3,809.79 3,809.79 • 82.000 2.87 -15,746.84 15,746.84 06/04/2019 Purchased 82 Shares Of Ishares Russell 2000 Growth Etf Trade Date 6/4/19 Purchased Through Ubs Securities LLC 82 Shares At 191.9996 USD 464287648 82.000 2.87 -15,746.84 15,746.84 Total(shares Russell 2000 Growth Etf 363.000 12.71 -61,988.64 61,988.64 06/04/2019 Purchased 363 Shares Of (shares S P 500 Growth Etf Trade Date 6/4/19 Purchased Through Ubs Securities LLC 363 Shares At 170.7326 USD 464287309 00335501 =bank. 40--01-B-62-185-01 0102 -19-02877-01 Page 17 of 21 PARS/CITY OF CHINO HILLS 115P Period from June 1,2019 to June 30,2019 ACCOUNT 6746053100 .,:_ t .; . ; ;;:.;;;:;;:-:;;;;;v;;v;v;v;gv;v;gv;v;v;t;v;,G;;; ;:;,;:;;,::;r;; ,,,Ri.(,,i.tp:t;;`;iiGiiiiiii�iti�i�;�G,a,!v:;i;ia; titTt; iTfl;;F ,!,!t!i,iiitm;! ititti:i?:i:Cg��;: ld:rl:'r,Is;iTi 1;?� �,i : s� ` `'r:,i'��'i`i�l` �ll �lili ;1,i�''r', ; ; ?�„��j�i�i��i��i��'r� iil ,lily ���l��;��ii`�i�i�� ii ����i�ili��i�i �'' :is:is ::. ; ei:,.,.:.:.:,.:.....:..:...:.......:.....:...:.: :..... SHARES/ C OOK VALUE DATE DESCRIPTION FACE AMOUNT COMMISSIQN ri Total Ishares S P 500 Growth Etf 363.000 12.71 -61,988.64 61,988.64 06/04/2019 Purchased 1,711 1,711.000 59.89 -69,984.18 69,984.18 Shares Of Vanguard Ftse Emerging Markets Etf Trade Date 6/4/19 Purchased Through Ubs Securities LLC 1,711 Shares At 40.8675 USD 922042858 Total Vanguard Ftse Emerging Markets Etf 1,711.000 59.89 -69,984.18 69,984.18 06/04/2019 Purchased 841 841.000 29.44 -72,652.14 72,652.14 Shares Of Vanguard Real Estate Etf Trade Date 6/4/19 Purchased Through Ubs Securities LLC 841 Shares At 86.3528 USD 922908553 Total Vanguard Real Estate Etf 841.000 29.44 -72,652.14 72,652.14 3,106.000 108.73 -234,888.20 234,888.26 Total Mutual Funds-Equity Mutual Funds-Fixed Income 06/04/2019 Purchased 1,165 1,165.000 40.78 -128,487.86 128,487.86 Shares Of Ishares Core U.S.Aggregate Bond Etf Trade Date_6/4/19 Purchased Through Ubs Securities_ LLC 1,165 Shares At 110.255 USD 464287226 Total Ishares Core U.S.Aggregate Bond Etf 1,165.000 40.78 -128,487.86 128,487.86 1,165.000 40.78 -128,487.86 128,487.86 Total Mutual Funds-Fixed Income 0033550101-B- Y - jbanI 40- -185-01 ft 0102 --19-0-02877-01 Page 18 of 21 PARS/CITY OF CHINO HILLS 115P Period from June 1,2019 to June 30,2019 ACCOUNT 6746053100 ...:............;.,:::..,.::::.,.:.:.:.,,.,,,ara,,,,,„,,,lo mil,;a,rl,„,a,i,ssas,a,;vs ;;,aa,a,,,,, ii�;i3iiii�111 i; itii lItiC!;is!sr;�.ia,;.,, ii,;,;,;a;,,;;;,;;,s;1,, a. :.:;:;il,i,:;;::i:::.;,:,,,p;!., �i�%ii� ;�,� iiiiii, ! i;,i�;�;;i";''r ii���r,itiii�i,i�;�; ;;;;;;;�i��ic �i'L�i�''i�`i���i "'{i�,i 11i`4 ii ii ,;,;,;, i "i�{;iii{���aa i ��ii '�r'',i '�� ' ?, i ;;jr; i;;i ii���;�';'� ',i; ',i';'',';'s't''ssiiii'i!, ', ,rii�i�s't�t`? r i�iiiiiii ;u: ai: a,. .,.,.,.,auau!;i; sililiassi;i;ir:;!,;;!....................... SHARES/ BOOK VALUE DATE DESCRIPTIQN FACE AMOUNT COMMISSIQN C 9BFI Total Purchases 37,320.160 149.51 -396,425.22 396-425.22 • 00335501 40--01-B- 2 1 [Mbank® 0102 -19-02877-0177-01 PARS/CITY OF CHINO HILLS 115P Page 19 of 21 ACCOUNT 6746053100 Period from June 1,2019 to June 30,2019 ' i i Ek`S NDIMA ii' ITIMMARKET/ s: ici!i i isi '?; is ii iii i i `i '' s •:;i;s ;;;;i i s s ' i ; .";;i i a i ; i si ' ; i"`' SHARES/ TRANSACTION REALIZED PRIOR PRIORMARKET DATE DESCRIPTION FACE AMOUNT COMMISSIQN PRQCEEDS BOOK VALUB GAIN/LOSS REALIZED GAIN/LOSS Cash And Equivalents 06/06/2019 Sold 23,524 -23,524.000 .00 23,524.00 -23,524.00 .00 -23,524.00 Units Of .00 First Am Govt Ob Fd CI Z Trade Date 6/6/19 31846V567 06/26/2019 Sold -1,825.820 .00 1,825.82 -1,825.82 .00 -1,825.82 1,825.82 Units Of .00 First Am Govt Ob Fd CI Z Trade Date 6/26/19 31846V567 06/27/2019 Sold -1,459.510 .00 1,459.51 -1,459.51 .00 -1,459.51 1,459.51 Units Of .00 First Am Govt Ob Fd CI Z Trade Date 6/27/19 31846V567 Total First Am Govt Ob Fd -26,809.330 .00 26,809.33 -26,809.33 .00 -26,809.33 CI Z .00 Total Cash And -26,809.330 .00 26,809.33 -26,809.33 .00 -26,809.33 Equivalents .00 Mutual Funds-Equity 06/04/2019 Sold 816 -816.000 28.56 52,550.04 -49,707.21 2,842.83 -54,336.00 Shares Of -1,785.96 (shares Msci Eafe Etf Trade Date 6/4/19 Sold Through Goldman Sachs&Co. LLC Paid 28.56 USD Brokerage Paid 1.09 USD Sec Fee 816 Shares At 64.4359 USD 464287465 Total(shares Msci Eafe -816.000 28.56 52,550.04 -49,707.21 2,842.83 -54,336.00 Etf -1,785.96 00335501 40--01-B- 2 1 ®bank® L 0102 -19-02877-0177-01 PARS/CITY OF CHINO HILLS 115P Page 20 of 21 ACCOUNT 6746053100 Period from June 1,2019 to June 30,2019 l+►A�I: !�#1i4v!�w�!�tiN ! � s ? '; ;•: ????' ' ;'!•.ssi ' ` ci?? ??? ???ijiij •as ! ;; ;ii ; ;; ; ; ? cii ; ' i; ; Gi` ;ii;; ; ri ; i;i;iiii = e PRIOR MARKET/ SHARES/ TRANSACTION REALIZED PRIOR MARKET DATE DESCRIPTION FACE AMOUNT COMMISSION PROCEEDS BOOK VALUE GAIN/LOSS REALIZED GAIN/LOSS 06/04/2019 Sold 463 -463.000 16.21 54,289.33 -55,900.20 -1,610.87 -60,011.73 Shares Of -5,722.40 'shares Russell 2000 Value Etf Trade Date 6/4/19 Sold Through Goldman Sachs&Co.LLC Paid 16.21 USD Brokerage Paid 1.12 USD Sec Fee 463 Shares At 117.293 USD 464287630 Total(shares Russell -463.000 16.21 54,289.33 -55,900.20 -1,610.87 -60,011.73 2000 Value Etf -5,722.40 06/04/2019 Sold 455 -455.000 15.93 50,718.43 -48,496.75 2,221.68 -49,993.37 Shares Of 725.06 (shares S P 500 Value Etf Trade Date 6/4/19 Sold Through Goldman Sachs&Co. LLC Paid 15.93 USD Brokerage Paid 1.05 USD Sec Fee 455 Shares At 111.5064 USD 464287408 Total(shares S P 500 -455.000 15.93 50,718.43 -48,496.75 2,221.68 -49,993.37 Value Etf 725.06 • Total Mutual Funds-Equity -1,734.000 60.70 157,557.80 -154,104.16 3,453.64 -164,341.10 -6,783.30 Mutual Funds-Fixed Income 06/05/2019 Sold -17,068.751 .00 182,294.26 -179,463.37 2,830.89 -178,176.71 17,068.751 Shares Of 4,117.55 Vanguard Short Term Invt Grade#539 Trade Date 6/5/19 17,068.751 Shares At 10.68 USD 922031836 • 00335501 EMbank. 40--01-B-62-185-01 0102 -19-02877-01 PARS/CITY OF CHINO HILLS 115P Page 21 of 21 ACCOUNT 6746053100 Period from June 1,2019 to June 30,2019 PRIOR MARKET I l'::'!!!!!!!1!1!!!!!!1!!!!!!i!ii!!1!911111!!!!'!'!!!!!!!!!!i!!!I'T'4!!!":gillt!;14!!!!!!III!!!!g!li!lill'!!! !!!!!!Yil!iii!iil!IIIIIIIiilli!iiIIIIIIIffiiiiiiiiiiiiiiiiiiii!iiii!!i:ii!i!iiiiiiiiiiii!iiiiMIlillii;iiiiiiiiiiiiiiiiiiiii!il!liii!i!i!iiHiHi!!!iiili!..!!!iiIii!igiii!nEiii!lipiliilliaiviiit10101111V il!iiiikili.r.kigibliiiidkiiiikitii.44iiij;.6:ikijil°1!1!':i!!'.""i:"i":1itillli13!ill11!1111!!i!l!llillill!i'hil;!!TIIIIIIIIijllijillIll!EglilliIlililililli!i!i!ill!i!111!lh!nli!Mil;i:ii:iii;;i;iiiiii!ii!!iii!i!iii!!iii!i!ii!!iii!i;i!!!ii!!!i!!!iiii!!iii!i!i!i!ii!!iii!!!!i;:!:;i;!;!i!;!:i;!!!i!!!!i!!!!;:!i!:!!!:!„:!:!„:!:!:! SHARES/ TRANSACTION REALIZED PRIOR MARKET DATE DESCRIPTION FACE AMOUNT COMMISSIQN PROCEEDS SOOK VALUC GAIN/LOSS REALIZED GAIN/LOSS Total Vanguard Short Term -17,068.751 .00 182,294.26 -179,463.37 2,830.89 -178,176.71 Invt Grade#539 4,117.55 Total Mutual Funds-Fixed -17,068.751 .00 182,294.26 -179,463,37 2,830.89 -178,176.71 Income 4,117.55 Total Sales And -45,612.081 60.70 366,661.39 -360,376.86 6,284.53 -369,327.14 Maturities -2,665.75 • ilegv:igiiiiii.ci!illigii.6yiggoi$111111111111111011,11111101413113IIIIiIIPE1111!!iiilial!Itil!ilillgIllEliliiiiiliiiiiglIgglellID111D.Ili11111111,11Ifilliiiiiiiiiiii111111111111111!!!1!ili!!!!!ml!!!!!!!!!!!!!!!!11111!tigitunilligililigiolliiiipougliiiii!iii!iiiiiilliii! 0:14tIES114161iin. 1e)rql.ils11311# ritymtrmriimii!!iill.11;iiiii;1;,§iiiiiiill!iilliii!i!hi!ik!iii!iii!i!iii!iiiiiiiiiiii.i!iiiiiiiiiiiiiii!iiiii!!iiiiiiiiiiiIiiii.iiiiiiiiii4ii,iiffiwiil,!hillum,1,1,!,1,!,1,1,1,1,4!„,:„,„„:„,:„,:„,„„,,,,:,:!:!.,,,:::!:,:,,,,,,,,,:!.,:::.:.:.:.:.r...:.:.:.............................. Realized gain/loss should not be used for tax purposes.