Loading...
08-09-2016 CC Rpt 13Meeting Date: August 9, 2016 Public Hearing: ❑ Discussion Item: ❑ CIS}' -r Milo Hills Consent Item: August 2, 2016 CITY CLERK USE ONLY Item No.: 13 TO: HONORABLE MAYOR AND CITY COUNCIL MEMBERS FROM: CITY MANAGER SUBJECT: TREASURER'S REPORT FOR JUNE 2016 RECOMMENDATION: Approve the Treasurer's Report for June 2016. BACKGROUND/ANALYSIS: The Treasurer's Report: for June 2016 may be seen in Exhibit A (attached). The amount of cash and investments for all funds amounts to $174,378,201.26. The amount of cash shown in the checking accounts may be either a positive or negative (overdrawn) amount, depending on whether or not there is an opportunity to invest the "float" amount. It is the Treasurer's intention to invest all cash not needed for the immediate cash flow needs .of the City. The cash flow for all major fund types is also reported in Exhibit A. As shown, the City's cash reserves, coupled with the month's cash receipts, are sufficient to meet the City's cash disbursement requirements for the month. Additionally, there are sufficient reserves and forecasted cash receipts to meet the City's budgeted expenditure requirements for the remainder of the fiscal year. Attached are copies of the summary reports received from the agency pools and Government Obligations and money market mutual funds in which the City invests. Due to the different styles and lengths of reports, only summary information is excerpted from the reports and attached as exhibits to the Treasurer's Report. Additionally, the agencies reports that will be attached to the City Treasurer's Report may not necessarily correspond according to dates due to the lag time in producing and mailing these reports. Included in Exhibit A is a column showing the market value of investments the City has in the various pooled investment accounts. The investment pools provide the market valuation information for the total pool and City staff then calculates and reports the City's pro rats share of the market valuation amount. 36/332 AGENDA DATE: AUGUST 9, 2016 PAGE 2 SUBJECT: TREASURER'S REPORT FOR JUNE 2016 The market value may show unrealized gains or losses for the pooled investments. This does not mean that the pool has actually gained or lost any money on these transactions; it just shows what would have occurred if the pool had redeemed any of the investments as of the date of the report. Typically, the pools may not actually earn any gains nor suffer any losses, since the pools hold the investments to their maturity dates. For interest bearing instruments (which usually comprise most, if not all, of the pools' investments), a change in the market rate of an instrument will cause the value of the instrument to change. For example, when the interest rates increase, the value of bonds, notes, and other interest -rate -sensitive investments will decrease. Conversely, when the market interest rates decrease, the value of bonds, etc., will increase. But the risk of any actual loss (or gain) occurs only if the bonds or other investments are sold before their maturity date. If the investments are held until their maturity date, the investor will receive the total principal of the investment as well as any interest earned on the investment. REVIEW BY OTHERS: ►Re"M FISCAL IMPACT: In accordance with California Government Code, the Finance Director/City Treasurer certifies that sufficient investment liquidity, as well as sufficient anticipated revenues, are available to meet the City's budgeted expenditure requirements for the six months ending December 31, 2016. The investments reported in the Treasurer's Report are in compliance with the City's Investment Policy. ENVIRONMENTAL REVIEW: This proposed action is exempt from review under the California Environmental Quality Act (California Public Resources Code §§21000, et seq.; "CEQA") and CEQA regulations (14 California Code Regulations §§15000, et. seq.) because it does not involve any commitment to a specific project which could result in a potentially significant physical impact on the environment; and constitutes an organizational or administrative activity that will not result in direct or indirect physical changes in the environment. Accordingly, this action does not constitute a "project" that requires environmental review (see specifically 14 CCR § 15378(b)(4-5)). ResperIffully submitted: Konradt Bartlam, City Manager KB:JRL:PA:EC:dk Recommended by: " ` it Judy R. Lancaster, Finance Director Attachments 37/332 EXHIBIT A CITY OF CHINO HILLS TREASURER'S REPORT JUNE 2016 I. Funds Held by City and Fiscal Agents: A. Funds Held by City: Market Investments Cost Value Citizens Business Bank- Certificate of Deposit 456,217.99 456,217.99 Los Angeles County Pooled Funds of Investments (LACPFI) 28,558,755,26 (3) (1) State of California Local Agency Investment Fund (LAIF) 1,064,120.96 1,064,782.01 US Bank/ChandlerAsset Management 131,485,501.07_ 133,410,687.49 Total Investments 161, 564,595.28 (2) Cash Citizens Business Bank - Checking 2,598,262.31 2,598,262.31 Citizens Business Bank - Payroll 10,000.00 10,000A0 Wells Fargo Bank - Credit Card 233,393.80 233,393.80 Total Cash in Bank 2,841,656.11 2,841,666,11 Petty Cash 3,200.00 3,200.00 Total Cash 2,844,856,11 2,844,856.11 Total Funds Held by City 164,409,451.39 (2) B. Funds ]field by Fiscal Agents: U.S. Bank 9,968,749.87 9,968,749,87 Total Funds Held by Fiscal Agents 9,968,749.87 9,968,749,87 Total Funds Held by City and Fiscal Agents $ 174,378,201.26 (2) 11. Estimated Composite Investment Earnings Rate: 1.35% (Estimated Investment Earnings Rate for LACPFI: 0.93%; Actual Investment Earnings Rate for LAIF : 0.55% ; Actual Purchase Yield -to -Maturity Rate for Chandler Asset Management: 1.45%) Ill. Cash Flow Transactions by Major Fund Types: Beginning Ending Cash Balance Cash Cash Cash Balance Fund 06/01/16 Receipts Disbursements 06/30/16 General Fund $ 37,692,438.10 $ 2,395,513.57 (2,551,188.81) $ 37,536,762.86 Recreation Fund 360,784.89 536,091.43 (472,283.69) 424,692.63 Comm Dev Fund 245,308.85 262,939.53 (331,282.84) 176,966.54 Water Funds 55,313,397.70 2,381,231.13 (3,481,647.65) 54,213,081.18 Sewer Funds 10,176,025.00 809,132.41 (612,381.83) 10,372,776.58 Parks & Landscape 4,648,272.94 274,640.04 (851,048.04) 4,071,864,94 Development Funds 13,473,665.22 1,868,994.88 (1,802,755.94) 13,539,904.16 Comm. Facilities Dist. 32,351,032.14 22,746.44 (57,218.98) 32,316,659.60 Assessment Districts 1,127,816.41 96,145.48 (3,617.67) 1,220,344.22 Miscellaneous Funds 20,169,005.91 2,542,779.37 (2,206,434.73) 20,505,350.55 Total $ 175,667,747.16 $ 11,190,214.28 $ (12,369,760.18) $ 174,378,201.26 38/332 EXHIBIT A CITY OF CHINO HILLS TREASURER'S REPORT JUNE 2016 Page 2 of 2 IV Funds Held by Deferred Compensation Providers - Market Value VOYA Life Insurance and Annuity Company $ 4,675,107.03 [CMA 7,955,040.50 Total Funds Held by Deferred Compensation Providers $ 12,630,147.53 Footnotes: (1) The market valuation is not available as of the date of this report. (2) Total market valuation cannot be determined since the market value for the Los Angeles County Pooled Funds of Investments (LACPFI) is not available. However, a copy of the eCAPS statement which provides the ending balance of the LACPFI is attached. (3) The Los Angeles County Pooled Funds of Investments statement is not available as of the date of this report. In accordance with the California Government Code, the Finance Director/City Treasurer certifies that the investments reported in the Treasurer's Report comply with the City's Investment Policy that sufficient liquidity, as well as sufficient anticipated revenues, are available to meet the City's budgeted expenditure requirements for the six months ending December 31, 2016. 44t,� 7ind i $ ance tor/City Treasurer 39/332 1 1 Funds Held bV city: Beginning Book Balance 06101/16 Cash Receipts Cash Disbursements Journal Entries For Month Endinq Book Balance 06/30116 Reconciling Transactions Ending Bank Balance Funds Held by City Funds Held bV Fiscal Auent: Beg[nning Book Balance &/011i6 Cash Receipts Cash Disbursements Journal Entries For Month Ending Book Balance (M6130116 Reconciling Transactions Ending Bank Balance Funds Held by F1A Summarv_of Cash Balances: Beginning Cash Balance Funds Held by City Funds Held bXFiscal Agent Total Beginning Cash Balance Endinq Cash Balance Funds Held by C,I,��y' Funds Held by 2-y-1 Agent ITotal Endinq Cash Balance City of Chino Hills Treasurer's Report Worksheet Gene[, I I and Recr tlon I t;omm uev r 3 Fund vvater Funds Sewer Parks & Funds Landscape Development Funds I Comm. Facilities District _ _Assessment Districts Miscellaneous us 'Funds Total 37,692,436.1U d60,764-89„ 245,303.85 SD,708,851,27 10,1 66,025,OD a'�4b,C12.J4 13,4J3Eiri52L 25,354,455.86 777,315.23 20,169,005.91 163,606,123.29 2,396,345.57 535,985.43 262,939.53 23�' uU9132.41 274,64u.64 1,t 68,994.88 22,746.44 96,145,48 2,542,779.37 - 11,189,940.28 (2,551,1$$-81)_ (463,409.69) (334,28-2.84) {1,503,822.65jIr 612,3r!„ i t7,tSu2,755.94} 52069.98) (3,617.67} (2,206,434.731 L0,376,012.18) itizs.UU �a,a�4; ui) j �� (8,706.00). '-16,37z, 762.86 424,486.6 175,965.54 a b5,259.75 r1,5n - i,a37,53�6 ,_ _25,325,132.34 869,843.04 20,505.350.55 164,409,345.39 IOLUd, Il I I 106,00 37,536,i"�.8b a24sy2.bs I 176,965.54I II 51,586,259.75 II 10,372,775.58 4,071,864.94 13,539,904.16 25,325.132,34 869,843.04 20,505,35D.55 164,409,451.39 0-00 0.00 u.u6 I 4,bU4,54b.43 u.uU u,uu 0.00 6,996,57626 350,501.18 0-00 11,951,623,87 0.00 LOY UAW u.uu u, G.Uu U.00 0.00 0.00 0,00 0.00 0.00 u.uU u:�i 'i,arr,rza.uu II � lf.(}i� V.UI1 _.. U.LI(J. 5,149.00 L� 0.00 0.00 t,982 874.00 L-�� J I 0.00 0.00 UU 2,6'L6,821.43 U-UU 0.00 0.00 6,991,427.26 350,501.18 0-00 9,968,749.87 I � 0.00 0.00 O.Oi) U.UU _ u.uu L,BLb,aL i,4lS U,�II} U.UU 0.00 6,991,42726 [ 350,501.18 D.00 9,968,749.87 37,692,11U .00 3liU,/84.Y-J Ow d45,308,85 9040 50,708,851. 7 4 604,546�R3 € 10,17b,U25.TJ 0 Q 4,64Ji,212.94 13,413,66 22 8-00 25354455.a�} 6�`396,�7626 Q Q0 37,692,438.10 360,784.69 E 245,3d8.85 55,313,397.70 10,176,02 0 4648,27'2.94 13,473,665.22 3A51,032.14 37,535,/6 8 ' 4Z4,syz." ir6,9 5-54 51,5sb r� iu,sf2.775.58 4,vii.uba.al ` is,ss-J,au4-1'ti" 2S.s15,i3 .t4 26 37,536,76 424,592.53 �' „....�,/ i3 10,372,7' 5� 4,071,8 64.9a 13,539,90416 32,316,55 60 777,315.23 20,169,005.91 163,606123.29 350 `501.18 1,127,816.41 0.00 20,169,005,91 11 951,62327 1 r9557,747.16 869,M.04 20,505,350.55 164 409 451-39 dm6g 350 501.18 0.00 /k9.87 1,220,344.22 20,505,350.55 174Y,20126 40/332 y cr +L GI r 4�. Yl m\,,a Balance Sheet Detail Activity By Fund Juno 1, 2016- June 30, 2016 Fiscal Year. 2016 Fiscal Period: 12 Fund Class: TT15 TTC-SCG LAPIF Fund. T1R Chino Hids Balance Balance Balance Sheet Sheet Shoat Record Category Class Account Dote Document Descrlptlon Asset 1A Pooled Cash & Investments 100 Cash 1000 Cash 0610112016 JVAAC IA051600028 10 INTEREST ALLOCATION FOR THE MONTH ENDING May 31, 2016 06103/2016 DP TT INV16000420 1 Deposit to Pooled Investment Funds Total for 1000 Cash Total for 100 Cash Total for I Pooled Cash & Investments 1J Other Receivables & Loans Receivable -Short Term 125 Interest Receivable 1450 AC -Interest Recelvable Total for 1450 AC-lntorest Receivable Total for 125 Interest Receivable Total for iJ Other Receivables & Loans Receivable -Short Term I Due From Other Funds 141 Due From Other Funds -Year End 1599 Cue From Other Funds -Year End Total for 1599 Due From Other Funds -Year End Total for 141 Due From Other Funds -Year End Total for 1 L Due From tither Funds Total for Asset Equity 3E Fund Balance 330 Fund Balance -Available 3301 Other Fund Balance Available Report ID: GL-CDBSDF1 Beginning Balance debits 27,540,536.68 0.00 0.00 18,218.58 0.00 1,000,000-00 $27,540,536.68 $1,018,218.53 $27,540,536.68 $1,018,218.58 S27,540,536.68 $1,018,218.58 Ending credits Balance 0.00 27,540,536.68 0.00 27,558,755.26 0.00 28,558,755.26 $0.00 $28,558,755.26 $0.00 $28,558,755.26 $0.00 $28,558,755.26 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 S0.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 $0.00 $0,00 $0.00 $0.00 $0,00 $27,540,536.68 $1,018,218.59 $0.00 $28,558,755,26 (27,540.53(3.68) 0-00 0.00 (27.540,536,68) Run Cato: 07/05=16 9:19 AM 41 /332 Balance Sheet Detail Activity By Fund June 1, 2016 - June 30, 2016 Fiscal Year: 2016 Fiscal Period: 12 Fund Class: TT15 T'TC-ICG LAPIF Fund: TIR Chino Hills Balance Balance Balance Sheet Sheet Sheet Record Category Class Account Date Document Equity 3E Fund Balance 330 Fund Balance -Available 3301 Other Fund Balance Available 06101=16 JVAACIA0516000289 06103/2016 DP TT INV16000420 1 Total for 3301 Dther Fund Balance Available Total for 330 Fund Balance-Avaitable Totat for 3E Fund Balance Total for Equity Total for T1 R Chino Hills Total for TT15 TTC-lCG Los Angolos County Pool Investment Fund Report I➢: GL-ODBSDFI Description INTEREST ALLOCATION FOR THE MONTH ENDING May 31, 2016 Deposit to Pooled Investment Funds 7 mnune Beginning Ending Balance Debits Credits Balance 0.00 0,00 (13.218,58) (27558,755,26) 0.00 0,00 (1,000,000.00) (28,55$.755.26) ($27,540,536,68) $0.00 (51,018,218.58) ($28,558,755.2G) ($27,540,536,63) $0.00 {$1,014,218.58) ($2$,558,755,26) ($27,540,536.68) S0.00 ($1,018,218.58) (S28,558,755.26) {$27.SA0,53G.G8) Sfl.00 (51,018,218.54) ($28,558,755.2G) $0.00 $1,018,216.58 (51,018,218,58) S0.00 $0,00 $1,018,24858 (s1,0#8,218.58) $0.00 Run Data: 07/0612016 9:1 S AM 42/332 LAIC' Regular Monthly Statement Page 1 of 1 Local Agency Investment Fund P.O. Box 942809 Sacramento, CA 94209-0001 (916) 653-3001 CITY OF CHINO HILLS FINANCE DIRECTOR. 14000 CITY CENTER DRIVE CHINO HILLS, CA 91709 Account Summary Total Deposit: Total Withdrawal: PMIA Average Monthly Yields Account Number: 98-36-151 Tran Tvme Definitions 0.00 Beginning Balance: 0.00 Ending Balance: nvmtreasurer.ca.E!ovlumia-laiV1aif.asp July 14, 2016 June 2016 Statement 1,064,120.96 1,064,120.96 43/332 https://Iaifms.treasurer.ca.gov/RegularStatement.aspx 7/14/2016 .................... ..�-. �Qe��q lily ESr,��yi. State of California w n Pooled Money Investment Account N G V Market Valuation SAFE �� 6/3012016 �'lh76l�t� Carrying Cost Plus:. beser10tion Accrued inte're'stPurch. Amortized Cost IFalr Veins Accrued Interest 1* United States Treasury: Bills $ 12,202,776,744,48 $ 12,223,991,747.38 $ 12,233,011,000.00 NA Notes $ 21,650,061,435.88 $ 21,643,492,715,88 $ 21,679,913,000.00 $ 32,803,585.50 1* (Federal Agency: SBA $ MBS-REMICs $ Debentures $ Debentures FR $ Discount Notes $ j GNMA $ 1* ISuprariational Debenture: $ 2* JCDs and YCDs FR $ 2* 1Bank Notes $ 2* CDs and YCDs $ 2* Commercial Paper $ 1* Corporate: 711,503,679.54 $ 59,658,122.97 $ 1,105,155,621.62 $ 8,126,877,847.14 $ 599,982,831.85 $ 400,000,000.00 $ 800,000,000.00 $ 16,176,007,758.81 $ 7,486,127,569.47 $ 711,488,193.35 $ 59,658,122.97 $ 1,105,073,677.18 $ 8,133,238,361.10 $ $ 705,336,310.09 $ 63,529,777.27 $ 1,106,209,500.00 $ 8,135,019,000.00 903,583.96 282,224.56 1,544,500.15 NA 599,982,831.65 $ 601,736,500.00 $ 1,126,943.50 400,000,000.00 $ 400,000,000.00 $ 611,288.61 800,000,000.00 $ 799,735,907.64 $ 752,749.99 16,175,001,869.92 $ 16,174,127,406.71 $ 16,474,277.76 7,492,070,527.88 $ 7,492,217,111.12 NA Bonds FR $ - $ - $ - $ - Bonds $ - $ $ $ 1* Repurchase Agreements $ - $ $ $ - 1* lReverse Repurchase $ - $ $ $ - Time Deposits $ 5,649,440,000.00 $ 5,549,440,000,00 $ 5,549,440,000.00 NA JAB 55 & GF Loans $ 502,313,000.00 $ 602,313,000.00 $ 502,313,000,00 NA I ITOTAL $ 75,368,904,611.76 $ 75,395 751,047.51 $ 75,442,688,612.83 $ 54,499,154.03 Fair Value Including Accrued Interest $ 76,497,087,666.86 * Governmental Accounting Standards Board (GASS) Statement #72 Repurchase Agreements, Time Deposits, AS 55 & General Fund loans, and Reverse Repurchase agreements are carried at portfolio book value (carrying cost). The value of each participating dollar equals the fair value divided by the amortized cost (1.000621222). As an example: if an agency has an account balance of $20,000,000.00, then the agency would report Its participation In the LA]F valued at $20,012,424.43 or $20,000,000.00 x 1.000621222. 44/332 ����lll�I`�l�rl��!'�IfIIE��11f11]I1LI1IlI��I�����L��l1�1�i�1111 000001161 02 SP 000638492519334 P 00- -M -A-UE-182-01 3125 0247470-00-02252-000 Page 1 of 10 ACCOUNT NUMBER; 001050981096 CITY OF CHINO HILLS This statement is for the period from June 1, 2016 to June 30, 2016 QUESTIONS? CITY OF CHINO HILLS If you have any questions regarding 14000 CITY CENTER DRIVE your account or this statement, please CHINO HILLS, CA 91709-5442 call your Relationship Manager: Christopher Lee Stewart CN-OH-W51T 6225 Lusk Boulevard San Diego, CA 92121 Phone 513-632-4194 E-mail christopher.stewart3@usbank.com - -`. - _ ai-.v ..vi•.-_. ++.7+�+" :� % of Est Annual Market Value Total Income Taxable Bonds $133,391,941.04 100.0 $1,891,005A5 Cash & Equivalents $18,746.45 0.0 $1.14 Total Market Value $133,410,687.49 100.0 $1,891,006.59 Taxable Bonds gg— Shares] Market Valuel Cost Yield Par Security Description CUSIP Price Basis At Market EstAnnual lne Taxable Bonds 700,000.000 Jpmorgan Chase CO 46625HJA9 $700,000.00 $733,341.00 3.15 $22,050.00 3.150 07/05/2016 100,000 700,000.000 John Deere Capital Corp 24422ERF8 701,610.00 721,756.00 1.85 12,950.00 Medium Term Note 100.230 1.850 09/15/2016 1,850,000.000 Federal Farm Credit Bks 31331JX32 1,857,548.00 1,924,536.50 1.69 31,450.00 1.700 10/28/2016 10DA08 1,726,000.000 F N M A M T N 3135GOGY3 1,732,797.00 1,763,506.46 1.24 21,662.50 1,250 01 /30OW 7 100.452 335,000.000 Federal Farm Credit Bks 3133ECG99 335,244,55 335,020.10 0,66 2,211,00 0.660 02/22/2017 100,073 1,750,000.000 F N M A 3135GOJA2 1,757,752,50 1,767,780.00 1.12 19,687.50 1.125 04/27/2017 100.443 45/332 -, 1, Rm E-j or,010- 3125 Page 2cf10 ACCOUNT 001050981096 CITY orCHINO HILLS This statement hfor the period from NOW MarketVxluel Cost Yield Par socu,nvoonohndnn Cns|P Pw:a Basis At Market Gn Annon(|nc Taxable Bonds 675.000.000 monvnal Flec Cap Corp 36962o5VY8 681J36.60 691'260J* 2.28 15i325.00 Medium Term Note 100.e98 2.3000412712017 2.250,000.000 FH L M CM TM 3137EAo[3 2'262,937.50 2.296.020.00 1.24 28.125.00 1.25005/12/2017 100.575 360,000.000 Pfizer Inc 717081oJ9 360,784.80 359.683.20 1.10 3.860.00 1.10005/1512017 100.218 1.100.000.000 Berkshire Hathaway Fin 004664on9 1.109,130.00 1`103.630.00 1.*8 17,600.00 1.600*5/1*/2017 100.830 2.250.000.000 Federal Home Loan Bko 313:79+W4 2.258,797.50 2.264,737.50 1.00 22,500.00 1.00o06/09/2017 100.301 1.750.000D00 USTreasury Now 912828TG5 1.748.457.50 1.724.848.30 0.50 8'750.00 0.50007/31/2017 98.969 34.536.160 John Duum Owner Trust 477873AC4 34,531.67 34'531.45 0.87 300.46 A o Sovrzo1nB o|xo 99.087 0,87008[1512017 1.350.000.000PHLN\cy0TN 3137EADL0 1.35 1.350'780.30 0.90 13.500.00 1.00009/2912017 100.478 1.770`000.000 Oracle Corp 68389XxN5 1.7/6,209.80 1,755.367.00 1.20 21.240.00 1.3001011512017 100.354 1'715'000'000 Chevron Corp1007V4A4x 1.717820.75 1'701.862.55 1.10 18'933.00 1.1O41u0�2U17 �no.1e5 1,375,000.000 Intel �" 458140\L4 1.3831S3.7S 1`378.100.50 1.34 18.582.50 1.35012/15/2017 100.593 449.567.710 Toyota Auto Rovokmb|oo 89231MAC9 449.266.50 448,408.20 0.07 3.012.10 Owner Trust 89.933 /\BGsur2014AC|Ann.U7o1zY1@2017 1'775.000.000 F N M An°h 3135G8RT2 1.781,265.73 1,770,400.00 0.87 15.531.25 0.87512/20/2017 100.353 1.755.000.000 Toyota Motor Credit Corp 8e236TnA1 1,707J83.95 1.755'583.65 144 25.447.50 Medium Term Note 100.729 1.45001/1212018 2.225.000.000 FHLK8cK8TN 3137EAoN6 2,228,804.75 2.19e.973.68 0J5 16.687.50 0J500182/2018 100171 1.700.000.000 IBM Corp 459200HZ7 1.707,310.00 1.694.929.80 1.12 19.125.00 1.12502/0612018 100.430 503.991.030 Toyota Auto Receivables 89331l7\B6 504,187.58 503.950.51 0.83 4.687.12 Owner Tr 100.039 A8GSn/16Cc|A2AU.930V2/15/2o10 2.225,000.000FHLM0 3137exoP1 2.229,094.00 2,160'0e2.73 0.87 1e.468.75 0.87503/07/2018 100.184 428�822.560 Honda Auto Receivables 43814G8C4 428.603.86 428.771.02 0.69 - 2.$71.74 Owner Trust 88.948 ABOGeru0142C|A3oJ/0v3/i9/XV10 040.000.000 VVu|Mxrt 8mmu Inc 831142oF7 048\270.13 044,406.60 1.12 7.256.25 1.12504/11/3018 100.607 56*.182.980 John Duun, Owner Trust 47787VAc6 500'085.74 e66.082.28 0.92 5.208.88 C M000ruo14AC|83 99.983 0.92004/16/2018 2.200.000.800 Fodcm| Home Loan aks 313vA4GJ5 2,217J930.00 2.207.218.20 1.12 24.750.00 1.12504/25/2018 100.815 3125 024 Page 3of10 ACCOUNT 001060981096 CITY opCHINO HILLS This statement bfor the period 0om Share" Market Value/ Cost Yield Par Security Description cVs|P Price Basis At Market Est Annual Inc Taxable Bonds 1.180,000.000 Pepvn"}no 713448oR7 1.186,313.00 1,179,528,40 1.24 14.750.00 1.2500480X2018 100.535 1.800.000.000 Apple Inc 0378v3AJe 1.804,428.Un 1.783,023.40 1.00 18.000.00 1.0000503/2018 100.246 575,000.000 FNM8Deb 3135GOvVJ8 577277.00 550.793.27 0.87 5.031.25 0.87505/21/2018 100.396 1.900.000.000 USTreasury NnK, 912828VE7 1'914.687.00 1.889.564.e6 0.99 19.000.00 1.0000031/2018 100J73 2^600.000.000 Fedora[ Home Loan 8ks 313379oT3 2.629,354.00 2.000,514.00 1.24 32.500.00 1.25006/08/2018 101.129 670.698.7e0 Honda Auto Roo:hxWev 43814HAc2 870'54453 670.569.41 0.88 5.902.15 Owner Trust 83.877 8kSSv,u0143C|A3n.80n0n/15/201e 1`035.000.000 Honda Auto Ruooiwyb|us 43814NA81 1'035,003.40 1.034.896.60 1.34 13.869.00 Owner 100.064 C M08e, 161 C|A2 1.34006/18/2018 2.175.000.000 FNMA 3135GOE33 2'194,140.00 2.171.230.15 1.11 24,468.75 1.125071202018 100.880 1`770,000.000 American Honda Finance 02865YVAC5 1.817312.10 1,787.$21�V 2.07 37.612.50 Medium Tenn Note 02.o7o 3.12510/10/2018 2'560'000'000 Tennessee Valley Authority 880591EQI 2.61309440 2^58�8B8.65 171 44.800.00 1.75O10d5/2O1O �0o.�74 1,030.000.000 Chase Issuance Trust 161571GC2 1.030,690.10 1.031,408.30 1.01 10,403.00 ARSSorXViSAO0|A8 100.067 1.01010/1512018 2,300,000.000 U oTmauu,Y Note 912828WD8 2.331,901.00 2.284,484.27 1.23 28.750.00 1.25010131/2018 ` 101.387 1.400.000.000 pmxoir}nn 74005PBU6 1,404,228.00 1.377.978.00 1.25 17.500.00 1.25011N7/2018 100302 1.022.102.220 John Duum Owner Trust 4778774o6 1,022,531.50 1.022'081.33 1.07 10.936.49 ABo8ur2O148O}A3 100.043 ' 1.07011/15/2018 140.000.000 US Bancorp 91159HUE3 142,940.00 140.296.e0 1.91 2,730.00 Medium Term Note 102.100 1.95011115/2018 1.800.000.000 USTreasury Note 912828A34 1.825,008.00 1.775,771.66 1.23 22.500.00 1.25011/30/2018 101.426 1`095.000.000 John Deere Capital Corp 34422E8F7 1.117,907.40 1.100.497.65 1.91 21,352.50 Medium Yenn Mote 102.092 1.85012/13/2018 1.000.000.000 8onom| BevCap Corp 30962G7G3 1.033,950.00 1.011.900.00 2.22 23`000.00 Medium Tann 0utu 103.395 ' 2.30001/14/2019 1.850.000.000 U8Treasury Note 912828SD3 1.978,801.50 1.827.154.97 1.23 24.375.00 125001/31/2019 101.477 1,030.000.000 Toyota Auto Receivables 89236mVAc2 1.031,854.00 1,029.044.26 1.44 14.832.00 Owner Trust 100.180 A8Sovr20iSA C|A31.44Voz/1512018 2.155.000.000 F N M A 3135GOzA4 2.214,628.85 2,164.027.03 1.82 40.406.25 1.87502/19/2019 102J67 GO--MA-UE-182-01 3125 0247470-00-02252-000 Page 4 of 10 ACCOUNT NUMBER: 001050981096 a3bank, CITY OF CHINO HILLS This statement is for the pperiod from .tune 1, 2016 to Jong 30, 2016 Shares/ Market Value/ Cost Yield Par Security Description CUSIP Price Basis At Market Est Annual Inc Taxable Bonds 1,255,000.000 Honda Auto Receivables 43813NAC0 1,256,041.65 1,254,807.36 1.04 13,052.01 Owner Trust 100.083 A B S Ser 2015 2 Cl A3 1.040 02/21/2019 2,000,000.000 U S Treasury Note 912828SH4 2,036,320,00 1,979,996.92 1.35 27,500.00 1.375 02/28/2019 101,816 1,155,000.000 Cisco Systems Inc 17275RAR3 1,186,264.30 1,159,623,65 2.07 24,543.75 2.125 03/01/2019 102.706 1,700,000.000 US Bancorp 91159HHH6 1,743,520.00 1,712,152.45 2.14 37,400.00 Medium Term Note 102.560 2.200 04/25/2019 1,825,000.000 U S Treasury Note 912828ST8 1,853,725.50 1,788,577.40 1.23 22,812.50 1.250 04/30/2019 101.574 2,150,000.000 F H L M C M T N 3137EADG1 2,209,125.00 2,147,365.90 1.70 37,625.00 1.750 05/30/2019 102.750 1,900,000.000 F N M A Deb 3135GOZE6 1,951,737.00 1,916,606.00 1.70 33,250.00 1.750 06/20/2019 102.723 2,225,000.000 F H L M C Deb 3137EADK2 2,252,300.75 2,167,581.20 1.23 27,812.50 1.250 08/01/2019 101.227 1,815,000,000 Bank Of NY Mellon 06406HCW7 1,852,007,85 1,822,288.25 2.25 41,745.00 Medium Term Note 102.039 2,300 0911112019 1,900,000.000 FNMA 3135GOZG1 1,952,611.00 1,895,725.00 1.70 33,250.00 1.750 09/12/2019 102.769 2,500,000.000 F H L M C M T N 3137EADM8 2,529,700.00 2,494,100.00 1.23 31,250,00 1.250 10/02/2019 101.188 2,000,000.000 U S Treasury Note 912828UB4 2,013,040.00 1,947,692.25 0.99 20,000.00 1.000 11/30/2019 100.652 1,825,000.000 Wells Fargo Company 94974BGF1 1,855,952.00 1,821,821.60 2.11 39,237.50 Medium Term Note 101.696 2.150 01/30/2020 2,400,000.000 U S Treasury Note 912828H52 2,435,064.00 2,375,218.98 1.23 30,000.00 1.250 01/31/2020 101,461 900,000.000 Costco Wholesale Corp 22160KAG0 918,036.00 899,055,00 1.72 15,750.00 1.750 02/15/2020 102.004 2,250,000.000 US Treasury Note 912828,184 2,292,547.50 2,252,204.80 1.35 30,937.50 1,375 03/31/2020 101,891 1,010,000.000 Jahn Deere Owner Trust 47788MAC4 1,013,706.70 1,009,841.03 1.35 13,736.00 A B S Ser 2016 A Cl A3 100,367 1.360 04115/2020 2,550,000.000 F H L M C M T N 3137EADR7 2,588,454.00 2,525,807.60 1.35 35,062.50 1.375 05/01/2020 101,608 1,730,000.000 Qualcomm Inc 747525AD5 1,778,128.60 1,713,310.25 2.19 38,925.00 2.250 06/20/2020 102.782 2,350,000.000 U S Treasury Note 912828VF4 2,393,146.00 2,323,478.58 1.35 32,312.50 1.375 05/31/2020 101.836 2,500,000.000 Federal home Loan Bks 313383HU8 2,566,525.00 2,610,425.00 1.70 43,750.00 1.750 06/12/2020 102.661 2,625,000.000 F N M A Deb 3135GOD75 2,675,426.26 2,626,417.50 1.47 39,375.00 1.500 06/22/2020 101.921 1,750,000.000 State Street Corp 857477AS2 1,815,992.50 1,778,420.00 2.46 44,625,00 2.550-08/1812020 103.771 48/332 00- -M -A-UE-182-01 3125 0247470-00-02252-000 Page 5 of 10 W ACCOUNT NUMBE001050981096 a C TY OF HILLSR: This statement is for the pperiod from June 1, 2016 to June 30, Z016 Shares/ Market Value! Cost Yield Par Security Description CUSIP Price Basis At Market Est Annual Inc Taxable Bonds 2,650,000.000 U S Treasury Note 912828E_99 2,697,938.50 2,608,499.12 1.35 36,437.60 1.375 10/31/2020 101.809 675,000.000 Microsoft Corp 594918BG8 692,226.00 674,460.00 1.95 13,500.00 2.000 11 /03/2020 102.652 2,700,000.000 F N M A 3135GOF73 2,745,792.00 2,648,970.00 1.47 40,500.00 1.500 11/30/2020 101,696 1,300,000.000 Visa Inc 92826CAB8 1,340,404.00 1,330,940.00 2.13 28,600.00 2,200 12/14/2020 103.108 2,500,000.000 U 5 Treasury Note 912828N89 2,544,250.00 2,497,666.98 1.35 34,375.00 1.375 01 /31/2021 101.770 2,235,000.000 Federal Home Loan Bks 3130A7CV5 2,261,350.65 2,225,970.60 1.36 30,731.25 1.375 02/18/2021 101.179 2,700,000.000 F N M A Deb 3135GOJ20 2,727,972.00 2,688,445.80 1.36 37,125.00 1.375 02/26/2021 101,036 1,500,000.000 U S Treasury Note 912828590 1,569,135.00 1,542,133.94 1.91 30,000.00 2,125 02/28/2021 104.609 1,795,000.000 Exxon Mobil Corporation 30231GAV4 1,850,734.75 1,816,422.45 2.15 39,884.90 2.222 03/01/2021 103.105 975,000.000 FNMA 3135GOK69 978,656.25 970,565.50 1.24 12,187.50 1.250 05/06/2021 100.375 920,000.000 State Street Corp 857477AV5 931,564.40 919,521.60 1.93 17,940.00 1.950 05/19/2021 101.257 Total Taxable Bonds $133,391,941.04 $134,466,754.62 $1,891,005A5 Cash & Equivalents 18,746,450 First American Government 31846V401 18,746.45 18,746.45 0.01 1.14 Obligation 1.000 Fund Cl ❑ Income Cash $6,223,904.77 $6,223,904.77 $0.00 Principal Cash - $6,223,904.77 - $6,223,904.77 $0.00 Total Cash & Equivalents $18,746A5 $18,746.45 $1.14 Total Investments $133,410,687.49 $131,485,501.07 $1,891,006.59 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 mbe reflected at a previous ay 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. 49/332 00- -M -A--UE--182-01 3125 0247470-00-02252-000 Page 6 of 10 ACCOUNT NUMBER: 001050981096 CITY OF Ci�Hr1�I��NnnO HILLS p C This a o to If oe 30e mld from Jun Income Princi al Cash Cash Beginning Cash Balance $6,092,677.36 - $6,092,677.36 Receipts Interest 131,227,41 0.00 Sales/Maturities 0.00 1,966,594.84 Cash Equivalent Sales 0.00 2,252,725.98 Total Cash Receipts $131,227.41 $4,219,320.82 Disbursements Trust & Investment Fees 0.00 _ 8,746.17 Purchases 0.00 - 2,242,236.50 Cash Equivalent Purchases 0.00 - 2,099,565.56 Total Cash Disbursements $0.00 - $4,350,548.23 Ending Cash Balance $6,223,904.77 - $6,223,904.77 Total $0.00 13l,227.41 1,966,594.84 2,252,725.98 $4,350,548.23 - 8,746.17 - 2,242,236.50 - 2,099,565.56 - $4,350,548.23 $0.00 50/332 hank. Rate Posted Description 06/01/46 Beginning Cash Balance 06/01/16 Interest Earned On First Amer Govt Oblig Fund Cl D Interest From 511/16 To 5131/16 06/06/16 Cash Disbursement Paid To Chandler Asset Management Investment Counsel Fee Mgmt Fee For The Pe Ending 5131/16 06/06/16 Matured 1,600,000 Par Value Of F H L B 0,400% 6/06/16 Trade Date 6/6116 1,600,000 Par Value At 100 % 06/06/16 Interest Earned On Chevron Corp 1.104% 12/06M7 0.00552 USD1$1 Pv On 1,715,000 Par Value Due 6/5116 06/06/16 Interest Earned On F H L B 0.400% 6/06116 0.002 USD/$1 Pv On 1,600,000 Par Value Due 6/6116 06/08/16 Interest Earned On F H L B Deb 1.250% 6/08/18 0.00625 USD/$1 Pv On 2,600,000 Par Value Due 618/16 06/09/16 Interest Earned On F H L B Deb 1.000% 6109/17 0,005 USDI$1 Pv On 2,250,000 Par Value Due 6/9/16 06/13/16 Interest Earned On F H L B Deb 1.750% 6/12/20 0.00875 USD/$1 Pv On 2,500,000 Par Value Due 6/12116 06/13/16 Interest Earned On John Deere Mtn 1.950% 12/13/18 0.00975 USD/$1 Pv On 1,095,000 Par Value Due 6/13116 06/15/16 Interest Earned On Chase lssuance Trust 1.010% 10/15/18 0,000942 USD/$1 Pv On 1,030,000 Par Value Due 6115116 06/15/16 Interest Earned On John Deere Owner 0.870% 8/15117 $0.000731Pv On 48,253.84 Pv Due 6115116 06/15/16 Paid Down 13,717.68 Par Value Of John Deere Owner 0.870% 8115/17 Trade Date 6116/16 06/15/16 Interest Earned On John Deere Owner 0.920% 4116/18 $0.00077/Pv On 607,992.88 Pv Due 6/15/16 06/15/16 Paid Down 41,809.89 Par Value Of John Deere Owner 0.920% 4116/18 Trade Date 6115116 00--M -A-U1-182-01 3125 0247470-00-02252-000 Page 7 of 10 ACCOUNT NUMBER. 001050981096 CITY OF CHINO HILLS This statement is for the period from June 1, 2016 to June 30, 2016 Income Principal Cash Gash Balance $6,092,677.36 - $6,092,677.36 $0.00 4.59 4.59 . - 8,642.00 - 8,637.41 1,600,000.00 1,591,362.59 9,466.80 1,600, 829.39 3,200.00 1,604, 029.39 16,250.00 1,620,279.39 11,250.00 1,631,529.39 21, 875.00 1,653,404.39 10,676.25 1,664, 080.64 866.92 1,664,947.56 34.98 1,664,982.54 13,717.68 1,678,700.22 466.13 1,679,166.35 41, 809.89 1, 720, 976.24 51 /332 Date Posted Description 06/15/16 Interest Earned On John Deere Owner 1.360% 4115/20 $0.001131Pv On 1,010,000.00 Pv Due 6/16116 06/15/16 Interest Earned On John Deere Owner 1.070% 11/15118 $0.00089/Pv On 1',102,171.06 Pv Due 6115/16 06/15/16 Paid Down 80,068.84 Par Value Of John Deere Owner 1.070% 11/15/18 Trade Date 6115116 06/15/16 Interest Earned On Honda Auto 0.880% 6/16/18 $0.00073/Pv On 732,816.64 Pv Rue 6115/16 06/15/16 Paid Down 62,117.85 Par Value Of Honda Auto 0.880% 6115/18 Trade Date 6/15/16 06/15/16 Interest Earned On Toyota Auto 0.670% 12/15/17 $0.00056/Pv On 612,938.18 Pv Due 6/15/16 06M5116 Paid Down 63,370.47 Par Value Of Toyota Auto 0.670% 12/16/17 Trade Date 6115/16 06/15/16 Interest Earned On Toyota Auto 0.930% 2/15/18 $0.000771Pv On 565,775.59 Pv Due 6/15/16 06/15/16 Paid Down 61,784.56 Par Value Of Toyota Auto 0.930% 2115118 Trade Date 6115/16 06/15/16 Interest Earned On Toyota Auto 1.440% 2115/19 $0.00093/Pv On 1,030,000.00 Pv Due 6/15116 06/15/16 Interest Earned On Intel Corp 1.350% 12/15117 0.00675 USDI$1 Pv On 1,375,000 Par Value Due 6115/16 06/20/16 Interest Earned On Honda Auto 0.693% 3/19118 $0.00064/Pv On 472,548.11 Pv Due 6/18/16 06/20/16 Paid Down 43,725.55 Par Value Of Honda Auto 0.693% 3/19/18 Trade Date 6118/16 06/20/16 Interest Earned On Honda Auto 1.340% 6/18/18 $0.000841Pv On 1,035,000.00 Pv Due 6118/16 06120/16 Interest Earned On F N M A Deb 0.875% 12/20/17 0,004375 USDI$1 Pv On 1,775,000 Par Value Rue 6120/16 00- -M -A-UE-182-01 3125 0247470-00-02252-000 Page 8 of 10 ACCOUNT NUMBER: 001050981096 CITY OF CHINO HILLS This statement is for the period from June 1, 2015 to .tune 30, 2016 Income Principal Gash Cash Balance 1,144.67 1,722,120.91 982.77 1,723,103.68 80, 068.84 1,803,172.52 537.40 1, 803, 709.92 62,117.85 1,865, 827.77 286.39 1,866,114.46 63, 370.47 1,929,484.63 433.76 1, 929, 918.39 61, 784.56 1, 991, 702.95 961.33 1,992,664.28 9,281.25 2,001,945.53 303.22 2,002,248.75 43,725.55 2,045,974.30 871.13 2,046,845.43 7,766.63 2,054,611.06 52/332 Date Pasted Description 06/20/16 Interest Earned On F N M A Deb 1.750% 6/20/19 0.00875 USDI$1 Pv On 1,900,000 Par Value Due 6120116 06/21116 Interest Earned On Honda Auto 1.040% 2/21119 $0.00087/Pv On 1,255,000.00 Pv Due 6/21/16 06/21/16 Purchased 1,300,000 Par Value Of Visa Inc 2.200% 12/14/20 Trade Date 6/16/16 Purchased Through Wells Fargo Securities, LLC Purchased On The OTC Bulletin Board 1,300,000 Par Value At 102.38 % 06121/16 Paid Accrued Interest On Purchase Of Visa Inc 2.200% 12/14/20 Income Debit 556.11- USD 06/21/16 Purchased 476,000 Par Value Of US Bancorp Mtn 2.200% 4/26119 Trade Date 6/16/16 Purchased Through Mlpfs Inc/Fixed Income Purchased On The OTC Bulletin Board 475,000 Par Value At 102.074 % 06/21/16 Paid Accrued Interest On Purchase Of US Bancorp Mtn 2.200% 4125/19 Income Debit 1,625.56- USD 06/22/16 Interest Earned On F N M A Deb 1,500% 6/22120 0.0075 USDI$1 Pv On 2,625,000 Par Value Due 6122116 06/27/16 Trust Fees Collected Charged For Period 05/01/2016 Thru 05/31/2016 06/30/16 Purchased 425,000 Par Value Of F N M A 1.250% 5/06/21 Trade Date 6/29/16 Purchased Through Citigroup Global Markets Inc. 425,000 Par Value At 100.34 % 06/30/16 Paid Accrued Interest On Purchase Of F N M A 1.250% 5/06/21 Income Debit 649.31- USD Combined Purchases For The Period 61 1/16 - 6/30/16 Of First Amer Govt Oblig Fund Cl D Combined Sales For The Period 61 1116 - 6130/16 Of First Amer Govt Oblig Fund Cl D 06130/16 . Ending Cash Balance 00- -M -A-UE-182-01 3125 0247470-00-02252-000 Page 9 of 10 ACCOUNT NUMBER: 001050981096 CITY OF CHINO BILLS This statement is for the period from June 1, 2016 to June 30, 2016 Income Principal Cash Cash Balance 16,625.00 2,071, 236.06 1,087.67 2,072,323.73 - 1,330,940.00 741,383.73 - 556.11 740,827.62 - 484,851.50 255,976.12 - 1,625.56 254,350.56 19,687.50 274,038.06 - 104A 7 273,933.89 - 426,445.00 - 152,511.11 - 649.31 - 153,160.42 - 2,099,565.66 - 2,252,725.98 2,252,725.98 0.00 $6,223,904.77 - $6,223,904.77 $0,00 53/332 i= 00- -M -A-UE-182-01 3125 0247470-00-02252-000 Page 10 of 10 ACCOUNT NUMBER: 001050981096 CITY OF CHINO HILLS This statement is for the period from June 1, 2016 to June 30, 2016 Trade Cost Estimated Date Asset Description Basis Proceeds Gain/Loss 06/06/16 F H L B 0.400% 6/06/16 Matured 1,600,000 - 1,599,648.00 1,600,000.00 352.00 06/16/16 John Deere Owner 0.870% 8/16/17 Paid Down 13,717.68 - 13,715.81 13,717.68 1.87 06/15/16 John Deere Owner 0.920% 4116/18 Paid Down 41,809.89 - 41,803.19 41,809.89 6.70 06/15/16 Jahn Deere Owner 1.070% 11/15/18 Paid Down 80,068.84 - 80,067.98 80,068.84 0.86 06/15/16 Honda Auto 0.880% 6/15/18 Paid Down 62,117.85 - 62,105.87 62,117.85 11.98 06/15/16 Toyota Auto 0.670% 12/15/17 Paid Down 63,370.47 - 63,348.12 63,370.47 22.35 06/15/16 Toyota Auto 0.930% 2/15118 Paid Down 61,784.56 - 61,779.59 61,784.56 4.97 06/18/16 Honda Auto 0.693% 3119/18 Paid Down 43,725.55 - 43,720.30 43,725.55 5.25 Total Assets Disposed - Cost Basis - $1,966,188.86 - Proceeds $1,966,594.84 - Estimated Gain/Loss $495.98 For information only, Not intended for tax purposes. World Class Service Delivered by World Class Professionals -Guaranteed! f Tl Y- 54/332 Glossary Accretion - The accumulation of the value of a discounted bond until maturity. Adjusted Prior Market Realized Gain/Loss - The difference between the proceeds and the Prior Market Value of the transaction. Adjusted Prior Market Unrealized Gain/Loss - The difference between the Market Value and the Adjusted Prior Market Value. Adjusted Prior Market Value - A figure calculated using the beginning Market Value for the fiscal year, adjusted for all asset related transactions during the period, employing an average cost methodology. Amortization - The decrease in value of a premium band until maturity. Asset - Anything owned that has commercial exchange value. Assets may consist of specific property or of claims against others, in contrast to obligations due to others (liabilities). Bond Rating - A measurement of a bond's quality based upon the issuer's financial condition. Ratings are assigned by independent rating services, such as Moody's, or S&P, and reflect their opinion of the issuer's ability to meet the scheduled interest and principal repayments for the bond. Cash - Cash activity that includes both income and principal cash categories. Change in Unrealized Gain/Loss -Also reported as Gain/Loss in Period in the Asset Detail section. This figure shows the market appreciation (depreciation) for the current period. Cost Basis (Book Value) - The original price of an asset, normally the purchase price or appraised value at the time of acquisition. Book Value method maintains an average cost for each asset. Cost Basis (Tax Basis) - The original price of an asset, normally the purchase price or appraised value at the time of acquisition. Tax Basis uses client determined methods such as Last -In -First -Out (LIFO), First -In -First -Out (FIFO), Average, Minimum Gain, and Maximum Gain. Ending Accrual - (Also reported as Accrued Income) Income earned but not yet received, or expenses incurred but not yet paid, as of the end of the reporting period. Estimated Annual Income -The amount of income a particular asset is anticipated to earn over the next year. The shares multiplied by annual income rate. Estimated Current Yield - The annual rate of return on an investment expressed as a percentage. For stocks, yield is calculated by taking the annual dividend payments divided by the stocks current share price_ For bonds, yield is calculated by the coupon rate divided by the bond's market price. Ex -Dividend date - (Also reported as Ex -Date) For stock trades, the person who owns the security on the ex -dividend date will earn the dividend, regardless of who currently owns the stock_ Income Cash - A category of cash comprised of ordinary earnings derived from investments, usually dividends and interest. Market Value - The price per unit multiplied by the number of units. Maturity Date - The dale onwhich an obligation or note matures. Payable Date - The date on which a dividend, mutual fund distribution, or interest on a bond will be made. Principal Cash - A category of cash comprised of cash, deposits, cash withdrawals and the cash flows generated from purchases or sales of investments. Realized GainfLoss Calculation - The Proceeds less the Cost Basis of a transaction. Settlement Date - The date on which a trade settles and cash or securities are credited or debited to the account Trade Date - The date a trade is legally entered into_ Unrealized Gain/Loss - The difference between the Market Value and Cost Basis at the end of the current period. Yield onlat Market -The annual rate of return on an investment expressed as a percentage. For stocks, yield is calculated by the annual dividend payments divided by the stock's current share price. For bonds, yield is calculated by the coupon rate divided by the bond's market price. The terms defined in this glossary are only for use when reviewing your account statement_ Please contact your Relalionship Manager with any questions. 55/332 003125 -A -182 U.S. Bank 1555 N. Rivercenter Dr. Suits 300 Milwaukee, WI 53212 F[F�II[f1FIIIf11Il F�Illli�FllilI�lliFlll#IrIIFF��FIFFFII'YIFIIII 000001161 02 SP 000638492519334 P CITY OF CHINO HILLS 14000 CITY CENTER DRIVE CHINO HILLS, CA 91709-5442 56/332 CHAtJDLER A$S T. MANAGEMENT City of Chin® Hills June 1, 2016 through June 30, 2016 Chandler Turn For questions about your account, please call (800) 317-4747 or Email operations@chandlerasset.com Custodian US Bank April Bernhardt (503)-464-3616 Information contained herein is confidential. We urge you to compare this statement to the one you receive from your qualified custodian. Prices are provided by IDC, an independent pricing source. 57/332 City of Chino Hills Portfolio Summary Account#1O150 As of 6/30/2016 Average Duration Average Coupon Average Purchase YTM Average Market YTM Average S&PIMoody Rating Average Final Maturity Average Life us Corporate (2TS %) Money Market Fund �i (0.0°} ASS (6.8 %) Agency (43.2 %) Beg I/alues end Values 2_52 as of 5131116 as, 6130116 + 132,364,226 133,410,635 1.45 % Accrued Interest 394,156 417,078 0.92 % li."rQtac market val"ue,: ,; 132,758,382 133,827,713 AA/Aa1 ;Incorrie;`Earne'd'":;=>' 159,962 156,683 2.71 yrs ContlWl] -8,746 2.60 i'P�r ,1 ;, 131,554,403 131,634,648 131,330,775 131,455,790 f ".:Cos# Value Y 131,362,614 131,485,501 30% i Us 25% :Treasury (22.2 %) 20% !i 10% 5% City of Chino Hills BAML 1-5 Yr US Treasury/Agency Index* *BAML 1-3 Yr US Treasury/Agency Index to 7131/12 25.5 % 24.2% 23.3 % 1.1% 14% 0-.25 .25-.5 ,5-1 1-2 2-3 3-4 4-5 5+ Maturity (Yrs) 0.81 % 0,75 % 2.31 % 0.94 % 0,79 % 2,35 % 2.53 % 1.81 % 2.38 % 1.65 % Issuer % Portfolio Government of United States 22.2 % Federal National Mortgage Assoc 17.5 % Federal Home Loan Mortgage Corp 13.2 % Federal Home Loan Bank 8,9 % Honda ABS 2.5 % State Street Bank 2.1 % John Deere ABS 2 0 % Tennessee Valley Authority 2.0 % 70.4 % AA (77.2 %; 1,34 % NIA 1.40 % 1.12% N/A 1.20% 0% AAA (5.3 %) A 7.70 %>.:.. 6.56 % Chandler Asset Management - CONFIDENTIAL Page 1 Execution Time: 713l2016 12:02:20 PM 58/332 City of Chino Hills June 30, 2016 Assets managed by Chandler Asset Management are in full compliance with State lave and with the City's investment policy. l.•h^� bl c,� r, - .i. !A .L f i.;"a ,.. I" 'r 9�•, 1, f�l." ^t 171' ..1�",' ip„sued �r, ., ,So rt I „a' iii `. -i4 i. ,✓,. :, l.lf i+'E� ! r`7, .,�_ �„ ..t ,'r r;,,.,;,,,,: ,,i� :'�. �.1� , t . j . ��, .11':.;, .i; ..u. , i�lry' `%r'•U'.,� , i , -r�• s`1•fr.,' ;,i .: a..,+. Ih3o- rg, i ; t, sr :'a,.,,,.-�i,.;; - .,�;1, ,.13 /+� .,•u I--:1i.. �>�„'; ',, J.} F`t.;zl t,., .51. tt=✓Irr, .r ..h €:+t a�•, .�;r,{,. :I'�'Jr:;al, _:4i� '�� r. ';}� •I J>� (,;,,:, ,d,d:..�¢ .I. �X-l' ,v , 3 i ,� ',i .r.;`,�„�.� C. � ,'s .� �:'.e.;�: .r .€., t.. J,x 4� t ,i;o, ! , h <:I. ,i:, P:A••l ,.t , ,y..,.. • :�t f,'•'r.�,�,@o-,•,.: , ::gtit`,C�.b,a, L:,E++.',.r���{i..r .,,1 , . r' ,'3f.,�'F 4'<v�F..,,J;l'1�J !. � [7;���� :� .�><< r , ft kae} r„s�(i� me��' � -r .Local Agency Bonds No Limitation Complies Treasury Issues Agency Issues Medium Term Notes Asset Backed Securities Money Market Mutual Funds Local Agency Investment Fund - L.A.I,F, Prohibited Securities - per State Code Prohibited Securities -per City restrictions Maximum maturity No Limitation Complies No Limitation (except for SBAs) Complies 30% maximum; A -rated or better Complies 20% maximum; AA -rated issue; A -rated Complies issuer 20% maximum; AAAf/Aaaf, minimum Complies rating Currently not used by investment adviser Complies Inverse floaters; Ranges notes, Interest- Complies only strips from mortgaged backed securities; Zero interest accrual securities Small Business Administration (SBA) debt; Complies Bankers Acceptance; Commercial Paper; Reverse Repurchase Agreements; Mortgage -Backed Securities 5 years Complies 59/332 City of Chino Hills C1,11"t 2"It I Account ##10150 Acauisition • 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 Withdrawa[s - Security Transfers - Other Dispositions - Maturites - Calls - Principal Paydowns Tota[ Dispositions Amortization/Accretion f/- Net Accretion Gainll-oss on Disoositions +1- Realized Gain/Loss Reconciliation Summary As of 6/30/2016 x, ,.ra:. .v` >x,�, �Y f,„1•. t :;lo;':.iLa i� ;R,73, $2,242,236.50 $2,100, 653.23 $0,00 . $0.00 $0.00 $0.00 $2,245, 067.48 $8,746.17 $0.00 $0.00 $0.00 $1,600,000.00 $0.00 $366,594.84 $2, 533.84 1131;a a;774.72 $4,342,889,73 $4, 220,408A9 $2,533.84 $0.00 $131,4a5;7$9;$0" BEGIN NING'BAL:ANCE,=,`..;''17t$906:87 Acauisition Contributions $0.00 Security Sale Proceeds $0.00 Accrued Interest Received $0.00, Interest Received $134,053.80, Dividend Received $4.591 Principal on Maturities $1,600,000.= Interest on Maturities Calls/Redemption (Principal) Interest from Calls/Redernption $0.00i Principal Paydown $366,594.84 Total Acquisitions $2,100,653.23' Disoosition Withdrawals $8,746.17 Security Purchase $2,242,236.50 Accrued Interest Paid $2,830.98 Total Dispositions $2,253,813.65 Bnding'Bobk VaNeie ; ' $1&,746:45 Chandler Asset Management- CONFIDENTIAL Page 3 Execution Time: 7/3/2016 12:02:20 PM 60/332 City of Chino Hills I Holdings Report 0 ilk Account #10150 As of 6/30I16 : C 477879AC4 John Deere Owner Trust 2013-8 A3 34,536.16 08/27/2013 34,531.45 99,99 34,531.57 0.03 % Aaa 1 NR 1.13 + 0.87% Due 8/15/2017 _ 0.88 % 34,534.82 0.97 % 13.35 (3,25) AAA 0.13 89231 MACS Toyota Auto Receivables Owner 2014-A 449,567.71 Various 449,409.20 99.93 449,265.15 0.34 % Aaa I AAA 1.46 0.67% Due 12/15/2017 0.71 % 449,523.56 0.90 % 133.87 (258.41) NR 0.29 89231 TAS6 Toyota Auto Receivables Owner 2015-C 503,991.03 08/18/2015 503,950.51 100.04 504,185.57 0.3B % Aaa I AAA 1.63 0.92% Due 2/15/2018 0.93 % 503,964.41 0181 % 206.08 221.16 NR 0.34 43814GAC4 Honda Auto Receivables 2014-2 A3 428,822.56 05/13/2014 428,771.02 99.95 428,605.58 0.32 % Aaa I AAA 1.72 0.77% Due 3/19/2018 0.78 % 428,807.42 0.89 % 119.24 (201.84) NR 0.43 47787VAC5 John Deere Owner Trust 2014-A A3 566,182.99 04/02/2014 566,092.29 99.98 566,084.47 0A2 % Aaa I NR 1.79 0.92% Due 4/16/2018 0.93 % 566,159.29 0.96 % 231.51 (74.82) AAA 0.42 43814HAC2 Honda Auto Receivables 2014-3 A3 670,698.79 08/1212014 670,569.41 99.98 670,543,19 0,50 % NR I AAA 1.96 0.88% Due 611512018 _.._. 0,89 % 670,652.53 0.93 % 262.32 (109.34) AAA 0.49 43814NABI Honda Auto Receivables 2016-1 A2 1,035,000.00 02/16/2016 1,034,896.60 100.06 1,035,666.54 0.77 % NR I AAA 1.97 1 01% Due 6/18/2018 1.02 % 1,034,912A6 0.92% 377,49 754,38 AAA 0.71 161571 GC2 Chase CHAIT Pool #2013-A8 1,030,000.00 09/03/2015 1,031,4D8.20 100.07 1,030,690.10 0.77 % Aaa IAAA 2.29 1.01% Due 10/15/2018 0.95 % 1,031,035.40 0.77 % 462.36 (345.30) ' AAA 0.27 477877AD6 John Deere Owner Trust 2014-6 A3 1,022,102.22 Various 1,022,091.33 100.04 1,C22,534.58 0.76 % Aaa / NR 2.38 1.07% Due 11/15/2018 1.07 % 1,022,119.37 1.00 % 486.07 415.21 AAA 0.60 89236WAC2 Toyota Auto Receivables Owner 2015-A 1,030,000,00 M2412015 1,029,844.26 100.18 1,031,852.97 0.77 % Aaa 1AAA 2.53 1.12% Due 2/15/2019 1.13 % 1,029,914.26 0.92% 512.71 1,938.71 NR 0,87 43813NAC0 Honda Auto Receivables 2015-2 A3 1,255,000.00 05/13/2015 1,254,807.36 100.08 1,256,047.93 0.94 % NR I AAA 2.65 1.04% Due 22112019 1.05 % 1,254,864.60 0.96 % 362.56 1,183.33 AAA 0.98 47788MAC4 John Deere Owner Trust2016-AA3 1,010,000.00 02/23/2016 1,009,841.03 100.37 1,013,706.70 0.76% Aaa INR 3.79 1.36% Due 4/15/2020 1.37 % 1,009,853.81 1.17 % 610,49 3,852,89 AAA 1,87 %036,212.66 9,043,714.35 6.76 % Aaa 1 AAA 2.36 Total ABS 9,035,901.46 1.03 % 9,036,341.63 0.94 % 3,778.05 7,372.72 Aaa 0.74 !:A GENCY, :,. 31331JX32 FFCB Note 1,850,000.00 08/10/2012 1,924,536.50 100.41 1,857,542.45 1.39 % Aaa IAA+ 0.33 1.7% Due 10/28/2016 0,73 % 1,855,770.88 0.45 % 5,503.75 1,771.57 AAA C.33 3135GOGY3 FNMA Note 1,725,000.00 08/08/2012 1,763,505.45 100.45 1,732,798.73 1.30 % Aaa I AA+ 0.59 1.25% Due 1/30/2017 0.74 % 1,730,016.31 0,47 % 9,044.27 2,782.42 AAA 0.58 3133ECG99 FFCB Note 335,000.00 05/10/2013 335,020.10 100,07 335,243.55 0.25 % Aaa IAA+ 0.55 0.66% Due 2/22/2017 0.66 % 335,003.43 0,55 % 792.28 240.12 AAA C.64 3135GOJA2 FNMA Note 1,750,000.00 08/15/2012 1,767,780.00 100.44 1,757,749.00 1.32 % Aaa IAA+ 0.82 1,125% Due 4/27/2017 0.90 % 1,753,11120 0.59 % 3,500.00 4,638,80 AAA 0.82 3137EADF3 FHLMC Note 2,250,000.00 07/30/2012 2,296,620.00 100.58 2,262,939,75 1.69 % Aaa IAA+ 0.87 1.25% Due 511=017 0.81 % 2,258,410.82 0.58 % 3,828.13 4,528.93 AAA 0.86 313379FW4 FHLB Note 2,250,000.00 07/27/2012 2,264,737.50 100.39 2,258,786.25 1.69 % Aaa IAA+ 0.94 1 % Due 6/9/2017 0.86 % 2,252,847.87 0.58 % 1,375.00 5,938.38 AAA 0.94 Chandler Asset Management - CONFIDENTIAL Page 4 Execution Time: 71=016 12:02'.20 PM 61 /332 City of Chino Hills Holdings Deport CIS& Account #10150 As of 6/30116 3137EADLO 3135GORT2 3137EADNB 3137EADP1 313OA4GJ5 3135GOWJ8 313379DT3 3135GOE33 880591E41 3135GOZA4 3137EADGI 3135GOZE6 3137EADK2 3135GOZG1 3137EADM8 3137EADR7 313383HUB 3135GOD75 3135GOF73 313OA7CV5 FHLMC Note 1,350,000.00 10/10/2014 1,350,780.30 100.48 1,356;458.40 1.02 % Aaa /AA+ 1.25 1% Due 9MI2017 -- 0.98 % 1,350,'328.43 0.61 % 3,450.00 6,129.97 AAA 1.24 FNMA Note 1,775,000.00 02/22/2013 1,770,456.00 100.35 1,781,271.08 1,33 % Aaa IAA+ 1.47 0.875% Due 12/20/2017 0.93 % 1,773,612.78 0.63 % 474.57 7,658.30 AAA 1.46 FHLMC Note 2,225,000A0 Various 2,198,973.68 100.17 2,228,813.65 1.67 % Aaa IAA+ 1.54 0.75% Due 1/12/2018 1.01 % 2,216,328.71 0.64 % 7,833.85 12,484.94 AAA 1.52 FHLMC Note 2,225,000.00 Various 2,166,092.75 100.18 2,229,100.68 1.67 % Aaa /AA+ 1.68 0.875% Due 3/7/2018 1,47 % 2,203,520.66 0.76 % 6,165.10 25,580.02 AAA 1.67 FHLB Note 2,200,000.00 03/20/2015 2,207,218.20 100.82 2,217,932.20 1.66 % Aaa IAA+ 1.82 1.125% Due 4/25/2018 1.02 % 2,204,238,85 0.67 % 4,537.50 13,693.35 AAA 1.80 FNMA Note 575,000.00 Various 560,793.27 100.40 577,275.85 0,43 % Aaa IAA+ 1.89 0.875% Due 5/21/2018 1.45 % 568,971.16 0.66 % 559.03 8,304.69 AAA 1.87 FHLi3 Note 2,600,000.00 Various 2,600,514.00 101.13 2,629,359.20 1.97 % Aaa IAA+ 1.94 1.25% Due 6/8/2018 1.23 % 2,601,099.91 0.66 % 2,076.39 28,259.29 AAA 1.91 FNMA Note 2,175,000.00 Various 2,171,230.15 100.88 2,194,137.83 1.65 % Aaa 1AA+ 2.05 1.125% Due, 7/20/2018 1.18 % 2,172,508.51 0.69 % 10,942.97 21,529,32 AAA 2.02 Tennessee Valley Authority Note 2,560,000.00 Various 2,584,996.65 102.07 21613,081.61 1.96 % Aaa IAA+ 2,29 1.75% Due 10/15/2018 1.49 % 2,574,550.92 0,83 % 9,457,78 38,530.69 AAA 2,24 FNMA Note 2,155,000,00 Various 2,164,027.03 102.77 2,214,626.70 1.67 % Aaa / AA+ 2.64 1.875% Due 2/19/2019 1.78 % 2,160,249.67 0.81 % 14,815.63 54,377.03 AAA 2,56 FHLMC Note 2,150,000.00 Various 23147,365.90 102.75 2,209,118.55 1.65 % Aaa I AA+ 2.92 1.75% Due 5/30/2019 1,78 % 2,148,436.54 0,79 % 3,239.93 60,682.01 AAA 2.84 FNMA Note 1,900,000.00 10/17/2014 1,916,606.00 102.72 1,951,729.40 1.46 % Aaa /AA+ 2.97 1.75% Due 6/20/2019 1.55 % 1,910,563.91 0.82 % 1,015.97 41,165.49 AAA 2.90 FHLMC Note 2,225,000,00 Various 2,167,581.20 101.23 2,252,296.30 1.69 % Aaa IAA+ 3.09 1.25% Due 8/112019 1.80 % 2,188,696.30 C.85 % 11,588.54 63,600.00 AAA 3.01 FNMA Note 1,900,000.00 10/07/2014 1,895,725.00 102.77 1,952,611.00 1.47 % Aaa I AA+ 3,20 1.75% Due 911'212019 1.80 % 1,897,226.00 0.87 % 10,067.36 55,385.00 AAA 3.10 FHLMC Note 2,500,000.00 09/30/2015 2,494,100.00 101.19 2,529,687.50 1.90 % Aaa IAA+ 3.26 1.25% Due 10/2/2019 1.31 % 2,495,209.02 0.88 % 7,725.69 34,478.48 AAA 3.18 FHLMC Note 2,550,000.00 Various 2,525,807.60 101.51 2,588,443.80 1.94 % Aaa / AA+ 3.84 1.375% Due 5/1/2020 1.59 % 2,529,990.67 0.97 % 5,843.75 58,453.13 AAA 3.72 FHLB Note 2,500,000.00 09/15/2015 2,510,425.00 102.66 2,566,517.50 1.92 % Aaa IAA+ 3.95 1.75% Due 6/12/2020 1,66 % 2,608,684.49 1.06 % 2,309.03 57,833.01 NR 3.81 FNMA Note - 2,525,000.00 09/29/2015 2,626,417.50 101.92 2,675,428.88 2,00 % Aaa I AA+ 3.98 1.5% Due 6/22/2020 1.49 % 2,626,191,78 1.01 % 984.38 49,237.10 AAA 3.86 FNMA Note 2,700,000.00 12/16/2015 2,648,970.00 101.70 2,745,800.10 2.05 % Aaa IAA+ 4.42 1.5% Due 11/30/2020 1.90 % 2,654,524.09 1.11 % 3,487.60 91,276.01 AAA 4.26 FHLB Note 2,235,000.00 02/17/2016 2,225,970.60 101.18 2,261,355.12 1.70 % Aaa IAA+ 4.64 1.375% Due 2/18/2021 1.46 % 2,226,632.85 1.11 % 11,353.49 34,722.27 AAA 4.46 Chandler Asset Management- CONFIDENTIAL Page 5 Execution Time: 7/312016 12:02:20 PM 62/332 City of Chino Hills Holdings Report Account #10150 As of 6/30/16 3135GOJ20 FNMA Nate 2,700,000,00 Various 2,688,445.80 101.04 2,727,972.00 2.05 % Aaa I AA+ 4.66 1.375% Due 2/26/2021 1.47 % 2,688,901.58 1.15 % 12,890.63 39,070.42 AAA 4.48 3135GDK69 FNMA Note 975,000.00 Various 970,565.50 100.37 978,654.30 0.73 % Aaa IAA+ 4.85 1.25% Due 5/6/2021 1.34 % 970,665.88 1.17 % 1,523.44 7,988.42 AAA 4.69 56,945,261.68 57,686,731.38 43,22 % Aaa 1 AA+ 2.60 Total Agency 56,960,000.00 1.34 % 56,856,292.22 0.81 % 156,385.96 830,439,16 Aaa 2.53 MONEI(.''MARKF-TrFI' NEY-1=1 ` I `:=;'rti. _ _ _. ... ,,, •'.n. '' K , - + , 31846V401 First Govt Obligation MMKT 18,746.45 Various .0� 18,7466.445 0.0 Aaa AAA ass -American % 18,746 45 0.0 5 Do 00,00 .00 18,746.45 18,746.45 0.01 % Aaa I AAA 0.00 Total Money Market Fund Fl 18,746.45 NIA 13,746.45 0.00 % 0.00 0.00 NR 0.00 *I .tl.�; rL l M'l =1 `r:f kvj>vV`I �US Or. giiA7e ,.ri='<'„1. ,,�• !, I, „s,.� :i. ?a,. .:I 1 i ;�I. ..�'� .._'; " I;E"' e'ki1 :h.+ !, '� :I. Ji'>`Y` �'- !J. •! q r„y, p'.r.r, J'J,°ry 14 +5i v: 'b= h!''1;11 'i,9V"• rl ':1.1. y : t. '. j.`,. Yn.. T, .,. I��l `.:, !.1= .=•I; :: . l}':'F: ''r, � ; ..d'!+, .....,.. u•:'?:r>a''.dy:^. .t, ,,h'7,. .'rf,."r.. ti..' rl''>.r��„ � 46625HJA9 JP Morgan Chase Note 700,000.00 07/30/2012 733,341.00 100.00 700,000.00 0.53 % A3 !A 0,01 3.15% Due 7/5/2016 1.89 % 700,093.07 3,15 % 10,780.00 (93.07) A+ 0.D1 24422ERF8 John Deere Capital Corp Note 700,000,00 07/27/2012 721,756.00 100.23 701,610.00 0.53 % A21A 0.21 1.85% Due 9/15/2016 1.08 % 701,097.91 0.74 % 3,813.06 512.09 NR 0.21 36962G5W0 General Electric Capital Corp Note 675,000.00 08/2012012 691,260.75 101.00 681,733.80 0.51 % Al IAA+ 0.82 2.3% Due 4/2712017 1,76 % 677,856.10 1.08 % 2,760.00 3,877.70 NR 0.81 084664B59 Berkshire Hathaway Note 1,100,000.00 08/26/2013 1,103,630.00 100.83 1,109,124.50 0.83 % Aa21AA D.87 1.6% Due 5/15/2017 1.51 % 1,100,851,91 0.65 % 2,248.89 8,272.59 A+ 0.87 717081 DJ9 Pfizer. Inc. Note 360,000.00 05/12/2014 359,683.20 100.22 360,783.36 0.27 % Al 1 AA 0.87 1.1 % Due 5/15/2017 1.13 % 359,908.08 0.85 % 506.00 875.28 A+ 0.87 68389XAN5 Oracle Corp Note 1,770,000.00 Various 1,755,367.00 100.35 1,776,267.57 1.33 % Al 1 AA- 1.29 1.2% Due 10/15/2017 1,43 % 1,764,830.49 0,92 % 4,484.00 11,437.08 A+ 1.28 166764AA8 Chevron Carp Callable Note Cont 1,715,004.00 Various 1,701,862.55 100.17 1,717,833.18 1,28 % Aa2IAA- 1.43 111511;7 1.33 % 1,709,621.68 0.98 % 1,367.43 8,211.50 NR 1.33 1.104% Due 12J512017 458140AL4 Intel Corp Note 1,375,000.00 Various 1,378,106.50 100,59 1,383,148.25 1.03 % Al IA+ 1.46 1,35% Due 12/15/2017 1.30 % 1,375,876.08 0,94 % 825.00 7,272,17 A+ 1.44 89236TCA1 Toyota Motor Credit Carp Note 1,755,000.00 Various 11,755,583.65 100.73 1,767,795.71 1.33 "/° Aa3 !AA. 1.54 1.45% Due 1/12/2018 1.43 % 1,755,393.01 0.97 % 11,946.19 12,402.70 A 1.50 459200Hz7 IBM Corp Note 1,700,000.00 Various 1,694,929.00 100.43 1,707,316.80 1.28 % Aa3 IAA- 1.61 1.1250/. Due 2/6/2018 1.23 % 17697,172.80 0.85 % 7,703,13 10,144.00 A+ 1.58 931142DF7 Wal-Mart Stores Note 645,000.00 04/04/2013 644,406.60 100.51 648,266.93 0,49 % Aa2 IAA 1.78 1.1250/6 Due 4/11/2018 1.14 % 644,789.09 0,84 % 1,612.50 3,477.84 AA 1.76 713448CR7 PepsiCo Inc Note 1,180,000.00 Various 1,179,528.40 100.53 1,1867308.28 0.89 % Al 1A 1.83 1.25% Due 4/30/2018 1.26 % 1,179,712.34 0.95 % 2,499.31 6,595.94 A 1.81 037833AJ9 Apple! Inc Note 1,800,000.00 Various 1,783,023.40 100.25 1,804,429.81 1.35 % Aal IAA+ 1.84 1 % Due 5/3/2018 1.25 % 1,791,894.13 0.86 % 2,899.99 12,535.68 NR 1.82 Chandler Asset Management - CONFIDENTIAL Page 6 Execution Time: 71312016 12:0220 PM 63/332 %I , -1 City of Chino Hills Holdings Report Account #1 E}150 Asaf613011B 02665WAC5 74005PBH6 91159HHE3 24422ESF7 36962G7G3 17275RAR3 91159HHH6 06406HCW7 American Honda Finance Note 2.125% Due 1011012018 Praxair Note 1.26% Due 11/7/201 B US Bancorp Callable Note Cant 1011512018 1.95% Due 1111512018 John Deere Capital Corp Note 1.95% Due 1211312018 General Electric Capital Corp Note 2.3% Due 1/14=19 Cisco Systems Note 2.125% Due 3/1/2019 US Bancorp Callable Note Cent 3/2512019 2.2% Due 4/25/2019 Bank of New York Callable Note Cent 8111 /2019 2.3% Due 9/1112019 1,770,000.00 1,400, 000.00 140,000.00 1,095,000.00 1,000,000.00 1,155,000.00 1,700,000.00 1,815,000.00 94974BGF1 Wells Fargo Corp Note 1,825,000.00 2.15% Due 1/30/2020 22160KAGO Costco Wholesale Corp Note 900,000.00 1.75% Due 211512020 747525AD5 Qualcomm Inc Note 1,730,000.00 2.25% Due 5120=20 857477AS2 State Street Bank Note 1,750,000.00 2.55% Due 811812020 5949183GB Microsoft Callable Note Cont. 10/03/20 675,000.00 2% Due 11/3/2020 92826CAB8 Visa Inc Note 1,300,000.00 2.2% Due 12/14/2020 3Q231GAV4 Exxon Mobil Corp Callable Note Cont 1,795,000.00 211=21 2.222% Due 3/1/2021 Various 1.84 % 01 /08/2015 1.68 % 02/12/2014 1.90 % Various 1.78 % 0911012015 1.93 % Various 2,04 % Various 1.95% Various 2.19 % Various 2.19 02/05/2015 - - 1.77 % Various 2.46 % 01121/2016 2A7 % 1012912015 2.02 % 06/16/2016 1.65 % Various 1.97 % 1,787,921.40 1,780,841.81 1,377,978.00 1,386,429.77 140,296.80 140,145.96 1,100,497.65 1,099,427.88 1,011,900.00 1,009,064.34 1,159, 623.65 1,157,469.92 1,712,152.45 1,711,174A2 1,822,288.25 1,820,812.80 1,821,821.60 1,822,553.36 899,055.00 899,314.05 1,713,310.25 1,716,758.74 1,778,420.00 1,775,741.76 674,460.00 674,531.23 1,330,940.00 1,330,751,00 1,815,422.45 1,814,919.78 102.67 0,94 % 100.30 1.12 % 102.10 1.02 % 102.09 1.08 % 103,39 0.94 % 102.71 1.09 % 102.56 1.25 % 102.04 1.63 % 1,617,315.64 1.36 % Al IA+ 2.28 8,462.82 36,473.83 NR 2.22 1,404,233.60 1.05 % A21A 2.36 2,625.00 17,803.83 NR 2.31 142,939.86 0.11 % Al IA+ 2.38 348.83 2,793.90 AA 2.24 1,117,911.78 0.84 % A21A 2,45 11067,63 18,483.00 NR 2.39 1,033,949.00 0.78 % Al IAA+ 2.54 10,669.44 24,884,66 NR 2.45 1,186,256.61 0.89 % Al IAA 2.67 8,181.24 28,786.59 NR 2.58 1,743,518.31 1.31 % Al 1 A+ 2.82 6,856.66 32,344.19 AA 2.54 1,852,009.67 1.39 % Al lA 3.20 12,755.41 31,196.87 AA- 2.98 101.70 1,855,959.30 1.40 % A21A 3.59 1.66 % 16,457.95 - 33,405.94 AA- 3.41 102.00 918,037.80 0.69 % Al /A+ 3.63 1.18 % 5,950.00 18,723.75 A+ 3.49 102.78 1,778,123.42 1.33 % Al I A+ 3.89 1.51 % 4,433,12' 61,364.68 NR 3.71 103.77 1,815,992.50 1.37% Al1A 4.14 1.60 % 16,486,46 40,250.74 AA- 3.89 102.55 692,226.68 0.52 % Aaa I AAA 4.35 1.38 % 2,175.00 17,695.45 AA+ 4.07 103.11 1,340,405.30 1.00 % Al IA+ 4.46 1.48 % 1,350.56 9,654.30 NR 4.24 103.10 1,850,727.57 1.39 % Aaa I AA+ 4.67 1.53 % 13,073.38 35,807,79 NR 4.40 857477AV5 State Street Bank Note 920,000.00 05/16/2016 919,521.60 101.26 931,563,48 0.70 % Al 1 A 4.89 1.95% Due 5/19/2021 1.96 % 919,532.87 1.68 % 2,093.00 12,030.61 AA- 4.64 36,568,087.15 37,025,73&71 27.79 % Al 1 AA- 2.56 Total US Corporate 36,445,000.00 1.73 % 36,518,566.08 1.21 % 166,432.00 507,222.63 AA- 2.45 v, : '7•' Y'h 1, r,7i•, P==;'f� r11�:?IJ =;5,� USREASURY rv. ""l.;i, I„ _r�. ys"'$I,`r;,f �?•i;--0;�7, t1 rl, Y.. Y"fi. � .ar C. 1 d; b<, �. 'i�'/„ f�{pix ', i!' �l; ,,.r rrJ ,., lfi r>, •�r l.. ::'r�'' 7.` f Yr`r r=r,`•','.' r.;,, "a. ;rrP(.}.i, .,.,f. ,]`� h rr. P,` f .1 "ti;l's /,,, 1 •;{•; s•r =•, 'I; e S,'= `d= 4„ `' f'w v4, . :, iM' r , ; ,, 'r ::h',;;o. -,..[. r, � .a , •,I;r hr;. i l •I, :i �>r'. wi` i; .; •.. r,✓>� �sl. =�7� ;.� „ ',i,.. ...-. r, .. ., �, ."t 1, .,1.. r.J^ � •:A, ,t., 1;r• .,1- "•r, .:,, ^'P. �..,- �'?I'„, ,:,i r ,. .. rl de, rv°S+ lnr i •; � "a .. rvl.-sr,.°i.u�',a .vr< „�. m9,h .�, r ,r,?r li iI t:rr4 yv YID ��'i.. ,, .?,F`:. �ql.�r i 4, ,- =.P(,�"=:,,c ,ter ..l.,�..1 I'•1+1`1." b hi 912828TG5 US Treasury Note 1,750,000.00 Various 1,724,848.30 99.97 1,749,454.00 1.31 % Aaa IAA+ 1.08 0.5% Due 7/31/2017 0.80 % 1,744,509.25 0.53 % 3,653.84 4,944,75 AAA 1.08 Chandler Asset Managemsnt - CONFIDt WTIAL Page 7 Execution Time: 7/312016 12:02:20 PM 64/332 City of China Hills Holdings Report Account#10150 Report As of 6130116 US TREASURY 912828VE7 US Treasury Note 1 %n Due 5131 /2018 912828WD8 US Treasury Note 1.25% Due 10/31/2018 912828A34 US Treasury Note 1.25% Due 11/30/2018 9128285D3 US Treasury Note 1.25% Due 113112C19 912828SH4 US Treasury Note 1.375% Due 212812019 912828STS US Treasury Note 1.25% Due 413012019 912828UB4 US Treasury Note 1% Due 11/30/2019 912828H52 US Treasury Note 1,25% Due 1/31/2020 912828584 US Treasury Nate 1.375% Due 3/31/2020 912828VF4 US Treasury Nate 1,375% Due 5/31/2020 912828L99 US Treasury Note 1,375% Due 10/31/2020 912828NBP US Treasury Note 1.375% Due 1/31/2021 9128281390 US Treasury Note 2% Due 2/28/2021 Total US Treasury TOTAL PORTFOLIO TOTAL MARKET VALUE PLUS ACCRUED 1,900,000.00 Various 1.14 % 2,300,000.00 Various 1,37 % 1,800,000.00 Various 1,54 % 1,950, 0 00,00 10/07/2014 1.53 % 2,000,000.00 Various 1.60 % 1,825,000.00 0611012C14 1.68 % 2,000,000.00 Various 1.56 % 2,400,000.00 Various 1.49 % 2, 250, 000.00 10/23/2015 1.35 % 2,350,000,00 07110/2015 1.62 % 2,650,000.00 11/23/2015 1.71 % 2,500,000.00 03/09/2016 1,40 % 1,500,000,00 04/26/2016 1.40 % 29,175,000.00 1.45 % 131,634,647.91 1.45 % 1,889,564.96 100.77 1,914,694.60 1,43 % Aaa IAA+ 1,895,107.38 0.59 % 1,609.29 19,587.22 AAA 2,284,484.27 101,39 2,331,894.10 1.75 % Aaa IAA+ 2,293,914.64 0.65 % 4,843.76 37,979.46 AAA 1,775,771.66 101.43 1,825,664.40 1.37 % Aaa I AA+ 1,787,836.48 0.65 % 1,905.73 37,82T92 AAA 1,927,154.97 101.48 1,978,793.70 1.49 % Aaa IAA+ 1,936,316.17 0,67 % 10,178.57 42,477.53 AAA 1,979,996.92 101.82 2,036,328.00 1.53 % Aaa IAA+ 1,988,247.07 0.69 % 9,191.58 48,080.93 AAA 1,786,577.40 101.57 1,853,729.15 1.39 % Aaa IAA+ 1,803,910.01 0.69 % 3,843.41 49,819,14 AAA 1,947,692.25 100.65 2,013,046.00 1.51 % Aaa 1 AA+ 1,963,377.92 0.81 % 1,693.99 49,668.08 AAA 2,375,218.98 101 A6 2,435,061.60 1.83 % Aaa I AA+ 2,380,127,42 0.84 % 12,527.47 54,934.18 AAA 2,252,204.80 101,89 2,292,538.50 1.72 % Aaa IAA+ 2,251,865.50 0.86 % 7,776.64 40,673.00 AAA 2,323,478.58 101.84 2,393,143.65 1.79 % Aaa IAA+ 2,328,741.24 0190 % 2,736.85 64,402.41 AAA 2,603,499.12 101.81 2,697,927.90 2.02 % Aaa 1 AA+ 2,613,563.01 0.95 % 6,138.93 64,364.89 AAA 2,497,566.98 101.77 2,544,237.50 1.91 % Aaa 1 AA+ 2,497,719.47 0.98 % 14,354.40 46,518,03 AAA 1,542,133.93 104.61 1,569,141.00 1.18 % Aaa IAA+ 1,540,607.86 0.99 % 10,027.17 28,533.14 AAA 28,917,193.12 29,635,654.10 22.21 % Aaa I AA+ 29,025,843.42 0.78 % 90,481.63 609,810.68 Aaa 131,435,501.06 133,410,634.99 100.00 % Aal 1 AA 131,455,789.80 0.92 % 417,077,64 1,954,845A9 Aaa 133,827,712,63 1.92 1.90 2.34 2.30 2.42 2.38 2.59 2.53 2.67 2.61 2,83 2.78 3.42 3.35 3.59 3.49 3,75 3.64 3.92 3.81 4.34 4.19 4.59 441 4.67 4.44 3.23 3.14 2.71 2.52 Chandler Asset Management - CONFIDENTIAL Page 8 Execution Time* 713/2016 12:02.20 PM 65/332 !ig, , City of Chino Hills Transaction Ledger 0 Account #10150 5/31116 Thru 6/30/16 NOW imm �'AGQUISrTigNS Purchase 06101=16 31846V401 4.59 First American Govt Obligation'MMKT 1.000 4.59 0.00 4.59 0.00 Class-D Purchase OSIOS12016 31846V401 9,466.80 First American Govt Obligation MMKT 1.000 9,466.80 0.00 9,466.80 0.00 Class-D Purchase 06/06/2016 31846V401 3,200.00 First American Govt Obligation MMKT 1.000 3,200.00 0.00 3,200A0 0A0 Class-D Purchase 06/06/2016 31846V401 1,600,000.00 First American Govt Obligation MMKT 1.000 1,600,000.00 0.00 1,600,000.00 0.00 Class-D Purchase 06/08/2016 3184SV401 16,260.00 First American Govt Obligation MMKT 1.000 16,250.00 0.00 16,250.00 0.00 Class-D Purchase 06/09/2016 31846V401 11,250.00 First American Gevt Obligation MMKT 1.000 11,250.00 0.00 11,260.00 0.00 Class-D Purchase 06/12/2016 3184GV401 21,875.00 First American Govt Obligation MMKT 1.000 21,875.00 0.00 21,875.00 0,00 Class-D Purchase 06/13/2016 31846V401 10,676.25 First American Govt Obligation MMKT 1.000 10,676.25 0.00 10,676.25 IN Class-D Purchase 06/15/2016 31846V401 9,281.25 First American Govt Obligation MMKT" 1.000 9,281.25 0.00 9,261.25 0.00 Class-D Purchase 06/15/2016 3184SV401 856.92 First American Govt Obligation MMKT 1.000 866.92 0.00 866.92 0.00 Class-f7 Purchase 06/15/2016 31846V401 62,655.25 FirstAmerican Govt Obligation MMKT 1.000 62,655.25 0.00 62,655.25 0.00 Class-D Purchase 06115/2016 31846V401 81,051.61 First American Govt Obligation MMKT 1.000 81,051.61 0.00 81,051.61 0.00 Class-D Purchase 06/15/2016 31B46V401 13,752,66 First American Govt Obligation MMKT 1,000 13,752.66 0.00 13,752.65 0.00 Class-D Purchase 06/15/2016 31846V401 42,276.02 First American Gavt Obligation MMKT 1.000 42,276.02 0,00 42,276.02 0.00 Class-D Purchase 05115/2016 31846V401 1,144.67 First American Govt Obligation MMKT 1.000 1,144.67 0.00 1,144.67 0.00 Class-D Purchase 06/15/2016 31846V401 63,656.86 First American Govt Obligation MMKT 1.000 63,656.86 0.00 63,656.86 0.0c Class-D Purchase 06/15/2016 31846V401 62,218.32 First American Govt Obligation MMKT 1.000 62,218.32 0.00 62,218.32 0.00 Class-D Purchase 06/15/2016 31846V401 961.33 First American Govt Obligation MMKT 1.000 961.33 0.00 961.33 0.00 Class-D Purchase 06/201201 S 31846V401 24,390.63 First American Govt Obligation MMKT 1.000 24,390.63 0.00 24,390.63 0,00 Class-D Purchase 06/20/2016 31846V401 44,028.77 First American Govt Obligation MMKT 1.000 44,028.77 0.00 44,028,77 0.00 Class-D Chandler Asset Management - CONFIDENTIAL Page 9 Execution Time: 702016 12:02:20 PM 66/332 t City of Chino Hills Transaction Ledger Accounff1(}150 5/31116 Thru 6/30/16 pli �. ACQ�1lSliiC?NS I r, >: Purchase 06/20/2016 3184BV401 871.13 First American Govt Obligation MMKf 1.000 871.13 0.00 871.13 0.00 Class-D Purchase 06/21/2016 31846V401 1,087.67 First American Govt Obligation MMKT 1.000 1,087.67 0.00 1,087.67 0.00 Class-D Purchase 06/21/2016 91159HHH6 475,000.00 US Bancorp Callable Note Cont 3/25/2019 102.074 1.45 % 484,851.50 1,625.56 486,477.06 0.00 2.2% Due 4/25/2019 Purchase 06/21/2016 92826CAB8 1,300,000.00 Visa Inc Note 102.380 1.65 % 1,330,940.00 556.11 1,331,49fi.11 0.00 2.2% Due 12J1412020 Purchase D612212016 31846V401 19,587.50 First American Govt Obligation MMKT 1.000 19,687.50 0.00 19,687.50 0,00 Class-D Purchase 06/30/2016 3135GOK69 425,00100 FNMA Note 100.340 1.18 % 426,445.00 649.31 427,094.31 0.00 1.25% Due 5/6/2021 Subtotal 4,300,653.23 4,342,889.73 2,830.9.8 4,345,720.71 0.00 TOTAL ACQUISITIONS 4,300,653.23 4,342,889.73 2,830.98 4,345,720.71 0,00 ;D15P'OS1710N5, i:`k i•' 4 r k „ i, ;;„ Sale 06/21/2016 31846V401 1,817,973.17 First American Gov. Obligation MMKT 1.000 1,817,973.17 0.00 1,817,973.17 0.00 Class-D Sale 06/30/2016 31846V401 427,094.31 First American Govt Obligation MMKT 1,000 427,094.31 0.00 427,094.31 0.00 Class-D Subtotal 2,245,067.48 2,245,067.48 0,00 2,245,067,48 0.00 Paydown 06/15/2016 161571GC2 0.00 Chase CHAIT Pool #2013-A8 100,000 0.00 866.92 866.92 0.00 1.01 % Due 10/15/2018 Paydown 06/15/2016 43814HAC2 62,117.85 Honda Auto Receivables 2014-3 A3 100.000 62,117.85 537.40 62,655.25 O,pO 0.88% Due 6115;2018 Paydown 06/1512016 477877AD6 80,068.84 John Deere Owner Trust 2014-B A3 100.000 80,068.84 982.77 81,051.61 0.00 1.07% Due 1Ill 5/2018 Paydown 06/15/2016 477879AC4 13,717.68 John Deere Owner Trust 2013-3 A3 100.000 13,717.68 34.98 13,7$2,66 0100 0.87% Due 811512017 Paydown 06/15/2016 47787VAC5 41,809.89 John Deere Owner Trust 2014-A A3 100.000 41,809.89 466.13 42,276.02 0.00 0.92% Due 4/16/2018 Paydown 06/15/2016 47788MAC4 0.00 John Deere Owner Trust 2016-A A3 100.000 0.00 1,144.67 1,144.67 0.00 1.36% Due 4/15/2020 Paydown 06/15/2016 89231 MACS 63,370.47 Toyota Auto Receivables Owner 2014-A 100.000 63,370.47 286.39 63,656.86 0.00 0.67% Due 12/15/2017 Chandler Asset Management - CONFIDENTIAL Page 10 Execution Time, 7/3/2016 12:02:20 PM 67/332 ' City of Chino Hills Account #1015Q Paydown 06/15/2016 89231TAB6 Paydown 06/15/2016 89236WAC2 Paydown 06/20/2016 43814GAC-4 Paydown 06/20/2016 43814NAS1 Paydown 06/21/2016 43813NACO Subtotal Maturity 06/06/2016 313OA22PO Subtotal Transaction Ledger 5/31116 Thru 6/30116 mom.. J.': • 1' 11 le: 1�.( �3 'I l.11a i.�' � (f{ I fC 1 YI' �' � 1 'I "I l;:,1'1;� �t'I. ,, "k i 11 ' I,i '.:I'. .,�,.', -t�•, h, n.lhi i 1'I.• III �I !V. I. I' �.. .r li'i �.1,' 'ill�l.l, I, t i pl! a,',bn•I!`IM1E"v" 61,784,56 Toyota Auto Receivables Owner 2015-C 100.000 61,784.56 433.76 62,218.32 OAO 0.92% Due 211512018 0.00 Toyota Auto Receivables Owner 2015-A 100.000 0.00 961.33 961.33 0.00 1.12% Due 2/15/2019 43,725.55 Honda Auto Receivables 2014-2 A3 100.000 43,725.55 303.22 44,028.77 0.00 0.77% Due 3/19/2018 0.00 Honda Auto Receivables 2016-1 A2 100.000 0.00 871.13 871.13 0.00 1.01% Due 611MO18 0.00 Honda Auto Receivables 2015-2 A3 100,000 0,00 1,087-67 1,087.67 0.00 1.04% Due 2/2112019 366,594.84 366,594.84 7,976.37 374,571.21 0.00 1,600,000.00 FHLS Note 0.4% Due 6/6/2016 1,600,000.00 100.000 11600,000.00 0.00 11600,000.00 0.00 1,600,000.00 0.00 1,600,000.00 0.00 Security 06/06/2016 31846V401 8,642.00 First American Govt Obligation MMKT 1.000 8,642.00 0.00 8,642.00 0.00 Withdrawal Class-D Security 06/27/2016 31846V401 104,17 First American Gavt Obligation MMKf 1.000 104.17 0.00 104.17 0.00 Withdrawal Class-D Subtotal 8,746.17 8,746.17 0.00 8,746.17 0.00 TOTAL DISPOSITIONS 1 4,220,408A9 - 4,220,408.49 7,976.37 4,228,384,86 0.00 '1' + '!LS 11I "3 ,1 a, , t z',yl' :ir,� , •]. r,. t 11 •II; h ', rui- r '._ LI„ f l I _ ry.,,, m, -r Interest 06105/2016 166764AAS 1,715,000.00 Chevron Corp Callable Note Cont. 1115/17 0.000 9,466.80 0.00 9,466.80 0.00 1.104% Due 12/5/2017 Interest 06/0612016 313OA22PO 1,600,000,00 FHLB Note 0.000 3,200.00 0.00 3,200.00 0100 0.4% Due 6/6/2016 lntorotat 06/08/2016 313379DT3 2,600,000.00 FHLS Note 0.000 16,260= 0.00 16,250.00 0.00 1.25% Due 6/8/2018 Interest 06/09/2016 313379FW4 2,250,000.00 FHLS Note 0.000 11,250.00 0.00 11,25C.00 0.00 1 % Due 6/9/2017 Interest 06/12/2016 313383HUB 2,500,000.00 FHLS Note 0.000 21,875.00 0.00 21,875,00 C.00 1.75% Due 6112/2020 Interest 06/1312016 24422ESF7 1,095,000.00 John Deere Capital Corp Note 0,000 10,676.25 0.00 10,676.25 0,00 1.95% Due 12/13/2018 Interest 06/15/2016 458140AL4 1,375,000.00 Intel Corp Note 0.000 9,281.25 0.00 9,281.25 0.00 1,35% Due 12/15/2017 Chandler Asset Management - CONFIDENTIAL Page 11 cxecuton Time: 7/312016 12:02:20 PM 68/332 ;. j1 City of Chino Hilts Transaction Ledger Account #10150 5131116 Thru 6/30/16 i I I r (OTHER"tRdN'SACTIONS Interest 06/20/2016 3135GORT2 1,775,000.00 FNMA Note 0.000 7,765.63 0.00 7,765,63 0.00 0.875% Due 12/2012017 Interest 06/20/2016 3135GOZE6 1,900,000.00 FNMA Note 0.000 16,625.00 0.00 16,625.00 0.00 1.75% Due 6/20/2019 Interest 06/2212016 3135GOD75 2,625,000.00 FNMA Note 0.000 19,687,50 0.00 19,687.50 0.00 1.5% Due 6/22/2020 Subtotal 19,435,000.00 126,077A3 0.00 126,077.43 0.00 Dividend 06101f2016 31846V401 171,906.87 First American Govt Obligation MMKT 0.000 4.59 0.00 4,59 0.00 Class-D Subtotal 171,906.87 4.59 0.00 4.59 0.011 TOTAL. OTHER TRANSACTIONS 19,606,906.87 126,082.02 0.00 126,082.02 0.00 Chandler Asset Management - CONPIDENTIAL Page 12 Execution Time: 713/20/6 12.02:20 PIA 69/332 City of Chino Hills Account #10150 Income Earned 5/31/16 Thru 6/30116 02665WAC5 American Honda Finance 1,781,233,22 5,328.45 0.00 Note 2.125% Due 1011012018 Various 0.00 0.00 391.41 Various 0.00 8,462.82 (391.41) 0_00 1,770,000.00 1,780,841.81 3,134.37 2,742.96 2,742.96 037633AJ9 Apple Inc 1,791,53132 1,400.00 362.41 Note 1%a Due0510312018 Various Various 0.00 0.00 0.00 2,899.99 0,00 362.41 0.00 1,800,000.00 1,791, 894.13 1,499.99 1,862.40 1,862.40 06406HCW7 Sank of New York 1,820,960.00 g 270.00 Capable Note Cont 8/1112019 Various 155.89 2.3% Due 09111/2019 Various 0.00 12,755,41 (153.56) 000 1,815,000.00 1,820,812.80 3,478.74 3,325.18 3,325.18 084664BS9 Berkshire Hathaway 1,100,932.28 782.22 0.00 Note 1.5% Due 05/15/2017 08/26/2013 0.00 0.00 80.37 08/29/2013 0.00 2,248.89 (80.37) 0.00 1,100,000.00 1,100,851.91 1,466.67 1,386.30 1,386,30 161571GC2 Chase CHAIT 1,031,072.56 462.36 0.00 Pool'92013-A8 09/03/2015 0.00 866.92 37.16 1.01 % Due 10/15/2018 09/04/2015 0.00 462.36 (37.16) 0.00 1,030, aao.00 1,031,035.40 866.92 829.76 829.76 166764AA8 Chevron Corp 1,709,312.58 9,256.43 320.44 Callable Note Cont 1115117 Various 0.00 9,466.80 11.34 1.104% Due 12/05/2017 Various 0.00 1,367.43 30MO 0.00 1,715,000.00 1,709, 621.68 1,577.80 11886.90 1,886.90 17275RAR3 Cisco Systems i,157,546.08 6,135.94 3.77 Note 2.125% Due 03101/2019 Various 0.00 0.00 79.93 Various 0.00 8,181,24 (76.16) MO 1,155,000.00 1,157,469.92 2,045.30 1,969.14 1,969.14 22160KAGO Costco Wholesale Corp 899,298.50 4,637.50 15.55 Note 1.75% Due 02/15/2020 02/05/2015 0.00 0.00 0.00 02/17/2015 0.00 5,950.00 15.55 0.00 900, 000.00 899,314-05 1,312.50 1,328.05 1,328.05 24422F-Rp8 John Door© Capital Corp 701,531.30 2,733,89 0.00 - - Note 1.85% Due 09/15/2016 07/27/2012 0.00 0.00 433.39 08/01/2012 0.00 3,813.06 (433,39) 0.00 700,000.00 701,097.91 1,079.17 645.78 645.78 24422ES1=7 John Deere Capital Corp 1,099,576.30 9,964.60 12.07 Note 1.95% Due 12/13/2018 Various 0.00 10,676.25 160.49 Various 0.00 1,067.63 (148.42) MO 1,095,000.00 1,099,427.88 1,779,38 11630.96 1,630.96 Chandler Asset Management - CONFIDENTIAL Page 13 Execution Time: 71312016 12.02:20 PM 70/332 City of Chino Hilis Income Earned ,... ,. Account # I0150 5131116 Thru 5130I16 30231 GAV4 313OA22PO 313OA4GJ5 3130A7CV5 31331JX32 313379DT3 313379FW4 313383HUB 3133ECG99 3135GOD75 3135GOE33 Exxon Mobil Corp Callable Note Cont 2/1/2021 2.222% Due 03/01/2021 FHLB Note Due 06106/2016 FHLB Note 1.125% Due 04/25/2018 FHLB Note 1.375% Due 02/18/2021 FFCB Note 1.7% Due 10128/2016 FHLB Note 1.25% Due 06108/2018 FHLB Note 1 % Due 06/09/2017 FHLB Note 1,75% Due 0611212020 FFCB Note 0.66% Due 02/22/2017 FNMA Nate 1.5% Due 06/22/2020 FNMA N ote 1.125% Due 07120/2018 Chandler Asset Management- CONN OENTIAL 1,815,270.48 9,749.64 0,00 Various 0.00 0.00 350.70 Various 0.00 13,073.38 (350,70) 0.00 1,795,000.00 1,814, 919.78 3,323.74 2,973.04 2,973.04 1,599,997.09 3,111.11 2.91 10/09/2014 0.00 3,200.00 0.00 10/10/2014 11600,000,00 0.00 2.91 0.00 0.00 0.00 88.89 91.80 91.80 2,204,430.66 2,475.00 0.00 03/20/2015 0.00 0.00 191.81 03/23/2015 0.00 4,537.50 (191.81) D.00 2,200,000.00 2,204,238.85 2,062.50 1,870.69 1,870,69 2,226,484.59 8,792,55 148.25 02/17/2016 0.00 0.00 0.00 02/18/2016 0.00 11,353.49 148.26 0.00 2,235,000.00 2,226,632.85 2,560.94 2,709.20 2,709.20 1,857,225.72 2,882.92 0.00 08/10/2012 0.00 0,00 1,454.84 08/13/2012 0.00 5,503.75 (1,454.84) 0.00 1,850,000.00 1,855,770.88 2,620.83 1,165.99 1,165.99 21601,146.58 15, 618.05 92.18 Various 0.00 16,250.00 138.85 Various 0.00 2,076.39 (46.67) 0.00 2,600,000.00 21601, 099.91 2,708.34 2,661.67 2,661.67 2,253, 096.95 10,750.00 0.00 07127=12 0.00 11,250.00 249,08 07/30/2012 0.00 1,375.00 (249.08) 0,00 2,250,000.00 2,252,847.87 1,875,00 1,625.92 1,625.92 2,508,865.16 20,538.19 0.00 09115/2015 0.00 21,875.00 180,67 09/16/2015 0.00 2,309.03 (180.67) 0.00 2,500,000.00 2,508,684.49 3,645.B4 3,465.17 3,465.17 335,003.87 608.03 0.00 05/10/2013 0.00 0.00 0.44 05/13/2013 0.00 792.28 (0.44) 0.00 335,000.00 335,003.43 184.25 183.81 183.81 2,626,216.41 17,390.63 0.00 09/29/2015 0.00 19,687.50 24.63 09/30/2015 0.00 934.38 (24.63) 0.00 2,625,000.00 2,626,191.78 3,281.25 3,256.62 3,256.62 2,172,408.72 8,903.91 99.79 Various 0.00 0,00 0.00 Various 0.00 10,942.97 99,79 O.00 2,175,000.00 2,172,508.51 2,039.06 2,138.85 2,138.85 Page 14 Execution Time: 7/312016 12:02:20 PM 71 /332 City of Chino Hills Account #10150 Income Earned 5/31/16 Thru 6/30116 3135GOF73 FNMA 2,653,678.29 112.50 845.80 N ote 12/16/2015 MO 0.00 0.00 1.5% flue 11/30/2020 12/17/2015 0.00 3,487,50 845.80 0.00 2,700,000.00 2,654,524.09 3,375,00 4,220.80 4,220.80 3135GOGY3 FNMA 1,730,722.83 7,247.40 0.00 N ote 1,25% Due 01/3012017 08/08/2012 0.00 0.00 706.52 08/09/2012 0.00 9,044.27 (706.52) 0.00 1,725,000.00 1,730,016,31 1,796.87 1,090.35 1,090.35 3135GU20 FNMA 2,688,705.B4 9,796.88 195.74 Note Various 0.00 0.00 0.00 1.375% Due 02/26/2021 Various 0.00 12,890.63 125.74 0.00 2,700,000.00 2,688,901.58 3,093,76 3,289.49 3,289.49 3135GOJA2 FNMA 1,753,421.22 1,859.38 0,30 Note 1.125% Due 04127/2017 08/15/2012 0.00 0.00 311.02 08/16/2012 0.00 31500,00 (311.02) 0.00 1,750,000,00 1,753,110.20 1,640.62 1,329.60 1,329.60 3135GQK69 FNMA 544,123.76 286.46 97.94 N ote 1.25% Due 05/06/2021 Various 426,445.00 (649,31) Q.82 Various 0.00 1,523.44 97.12 0.00 975,000.00 970, 665.88 587.67 684.79 684.79 3135GORT2 FNMA 1,7733535.23 6,945.92 77.50 Mote 0.875% Due 12/20/2017 02/22/2013 0.00 7,765.63 0.00 02/25/2013 0.00 474.57 77,50 0.00 1,775,000.00 1,773,612.78 1,294.28 1,371.78 1,371.78 313530WJ8 FNMA 568,708.65 139,76 262.51 Note 0.875% Due 05/21/2018 Various 0.00 0.00 Q.00 Various 0.00 559,03 262.51 0.00 575,000,00 568,971.16 419.27 681.78 681,78 3135G0ZA4 FNMA 2,160,413.21 11,448.44 0.00 Note 1.875% Due 02/19/2019 Various 0.00 0.00 163.54 Various MO 14,B15.63 (163.54) 0.0Q 2,155,000.00 2,160,249.67 3,367.19 3,203.65 3,203,65 3135GOZE6 FNMA 1,910,856.27 14,870A4 0.00 Note 1.75% Due 06/20/2019 10/17/2014 0.00 16, 625.00 292.36 10/20/2014 0.00 1,015.97 (292.36) 0.00 11900,000.00 1,910,563.91 2,770.83 2,478.47 2,478.47 3135GOZG1 FNMA 1,897,154.75 7,296.53 71.25 Note 1.75% Due 09/12/2019 10/07/2014 0.00 MO 0.00 10/08/2014 0.00 10,067.36 71,25 0.00 1,900,000.00 1,897,226.00 2,770.63 2,842.08 2,842.05 3137EADF3 FHLMC 2,259,211.86 1,484.38 MO Note 1.25% Due 05/12/2017 07/30/2012 0.00 0.00 801:04 07/31/2012 MO 3,528.13 (801.04) 0.00 2,250,000.00 2,258,410.82 2,343.75 1,542.71 1,542.71 Chandler Asset Management- CONFIDENTIAI- Page 15 ExecutionTime: 7/312016 12:0720 PM 72/332 City of Chino Hills Income Earned CIAN kAccount #10150 5/31/16 Thru 6130116 .c3F�/��Ie31 3137EADK2 3137EADM8 3137F_ADN6 3137EADP1 3137EADR7 FHLMC Note 1.75% Due 05130=19 FHLMC Note 1.25% Due 08/01/2019 FHLMC Note 1 % Due 09/29/2017 FHLMC Note 1.25% Due 10102/2019 FHLMC Note 0.75% Due 01/12/2018 FHLMC N ote 0.875% Due 03/07/2018 FHLMC Note 1.375% Due 05/01/2020 36962G5W0 General Electric Capital Corp Note 2.3% Due 04/27/2017 36962G7G3 General Electric Capital Corp Note 2.3% Due 01/14/2019 43813NACO Honda Auto Receivables 2015-2 A3 1.04% Due 02/2112019 43814GAC4 Honda Auto Receivables 2014-2 A3 0,77% Due 03119/2018 Chandler Assot Management - CONFIDENTIAL 2,148,392.41 104.52 98,82 Various 0.00 0.00 54.69 Various 0.00 3,239.93 44.13 O.OQ 2,150,000.00 2,148,436.54 3,135.41 3,179.54 3,179.54 2,187,729.07 9,270.84 967.23 Various 0.00 0,00 0.00 Various 0.00 11,588.54 967.23 0.00 2,225,000.00 2,188,696.30 2,317.70 3,284.93 3,284,93 1,350,350.09 2,325.00 0.00 10/10/2014 0.00 0.00 21.66 1011412014 Q.QQ 3,450.00 (21.66) 0.00 1,350,000M 1,350,328.43 1,125.00 1,103.34 1,103.34 2,495,088.04 5,121.53 120,98 09/30/2015 0.00 0.00 0.00 09/30/2015 0.00 7,725.69 120.98 0.00 2,500,000.00 2,495,209.Q2 2,604,16 2,725,14 2,725.14 2,215,864.18 6,443.23 464.53 Various 0.00 0.00 0.00 Various 0.00 7,833.85 464.53 C.00 2,225,000,00 2,216,328.71 1,390.62 1,855.15 1,855.15 2,202,471.19 4,542.71 1,049.47 Various 0.00 0.00 0.00 Various 0.00 6,165.10 1,049.47 0.00 2,225, 000, 00 2,203,520.66 1,622.39 2,671.86 2,671.86 2,529,561.90 2,921.88 428,77 Various 0.00 0.00 0.00 Various 0.00 5,843.75 428.77 0.00 2,550,000.00 2,529,990.67 2,921.87 3,350.64 3,350.64 678,141.71 1,466.25 0.00 08/20/2012 0.00 0.00 285,51 D812312012 0.00 2,760.00 (285.61) 0.00 675,000.00 677,856.10 1,293.75 1,008.14 1,008.14 1,009,357.68 8,762,78 0.00 09/10/2015 0.00 0.00 293.34 09/15/2015 0.00 10,669.44 (293.34) OAO 1,000,000.00 1,009,064.34 1,916.66 1,623.32 1,623.32 1,254,860.40 362.56 4.20 05/13/2015 0,00 1,087.67 0,00 0512a/2015 0.00 36Z56 4.20 C.00 11255,000.00 1,254,864.60 1,087.67 1,091.87 1,091.87 472,529,87 131.39 3.10 05/13/2014 0.00 303.22 0.00 05/21/2014 43,725.55 119,24 3.10 0.00 428,822.56 428, 807.42 291.07 294.17 294.17 Page 16 Execution Time: 7/312016 12:02,20 PM 73/332 City of Chino Hills Income Earned CAR Account #10150 5131/16 Thru 6130/16 43814HAC2 Honda Auto Receivables 732,762.10 286.61 8.28 2014-3 A3 08/12/2014 0.00 537.40 0.00 0.88% Due 06/15/2018 08/20/2014 62,117.85 262.32 8.28 0.00 670,698.79 670,652.53 513.11 521.39 521.39 43814NA81 Honda Auto Receivables 1,034,908,48 377.49 3.68 2016-1 A2 02116MIS 0.00 871.13 0.00 1.01 % Due 06/18/2018 02/25/2016 0.00 377.49 3,68 0.00 1,035,000.00 1,034,912,16 871.13 874.81 874.81 458140AL4 Intel Corp 1,375,925.49 8,559.39 4.63 Note 1.35% Due 12115/2017 Various 0.00 9,281.25 54.04 Various 0.00 825.00 (49.41) 0.00 1,375,000.00 1,375,876.08 1,546.86 1,497.45 1,497.45 459200HZ7 IBM Corp 1,697,027.81 6,109.38 144.99 Note 1.125% Due 0210612018 Various Various 0.00 0.00 0.00 7,703.13 0.00 144.99 0.00 1,700,000.00 1,697,172,80 1,593.75 1,738.74 1,738.74 46625HJA9 JP Morgan Chase 700,791.06 8,942.50 0.00 Note 07/30/2012 0.00 0.00 697.99 3.15% Due 0710,912016 08/02/2012 0.00 10,780.00 (697.99) 0.00 700,000.00 700,093.07 1,837.50 1,139.51 1,139.51 477877A06 Jahn Deere Owner Trust 1,102,190.65 524.14 14.82 2014-B A3 Various 0.00 982.77 17.26 1.07% Due 11/15/2018 Various 80,068.84 486.07 (2.44) 0.00 1,022,102.22 1,022,119.37 944.70 942.26 942.26 477879AC4 John Deere Owner Trust 48,251.83 18.66 0.67 2013-B A3 03/27/2013 0.00 34.98 0.00 0.87% Due 08115/2017 09104/2013 13,717.68 13.35 0.67 0.00 34, 536.16 34,534.82 29.67 30.34 30.34 47787VAC5 John Deere Owner Trust 607,964.77 248.60 4.41 2014-A A3 04/02/2014 0.00 466.13 0.00 0.92% Due 04/1612018 04/09/2014 41,809.89 231.51 4.41 0.00 566,182.99 566,159.29 449.04 453.45 453.45 47788MAC4 Jahn Deere Owner Trust 1,009,850.64 610.49 3.17 2016-A A3 02/23/2016 D.DO 1,144.67 0.00 1.36% Due 04/15/2020 03102/2016 0.00 610.49 3.17 0.00 1,010,000.00 1,009,853.81 1,144.67 1,147.84 1,147.84 59491BBG8 Microsoft 674,522.36 1,050.00 8.87 Callable Note Cent 10/03/20 1012SI2015 0.00 0.00 0.00 2% Due 11/03/2020 11/03/2015 0.00 2,175.00 8.87 0.00 675,000.00 674,531.23 1,125.00 1,133.87 1,133.87 68389XAN5 Oracle Corp 1,754,501.23 2,714.00 329.26 Note 1.2% Due 10/15/2017 Various 0.00 0.00 0.00 Various 0.00 4,484.00 329.26 0.00 1,770,000.00 1,764,830.49 1,770.00 2,099.26 2,099,26 Chandler Asset Management- CONFIDENTIAL Page 17 Execution -rime: 713120I S 12:02:2C PM 74/332 ° a ' City of Chino Hills Income Earned « � Account #10150 5131/16 Thru 5130116 713448CR7 717081DJ9 74005PBH6 747525AD5 857477AS2 857477AV5 880591 EQ1 89231 MAC9 89231TAB6 89236TCA1 89236WAC2 PepsiCo Inc Note 1.25% Due 04130/2018 Pfizer Inc. Note 1.1 %a Due 0511512017 Praxair Note 1,25% Due 1110712018 Qualcomm Inc Note 2.25% Due 05/20/2020 State Street Bank Note 2.55% Due 08/18/2020 State Street Bank Note 1.95% Due 05/19/2021 Tennessee Valley Authority Note 1.751/. Due 1011512018 Toyota Auto Receivables Owner 2014-A 0.67% Due 1211512017 Toyota Auto Receivables Owner 2015-C 0.92% Due 0211512018 Toyota Motor Credit Corp Note 1.45% Due 01/12/2018 Toyota Auto Receivables Owner 2015-A 1.12% Due 0211512019 Chandler Asset Management - CONFIDENTIAL. 1,179, 699.42 1,270.14 12.92 Various 0.00 0.00 0.00 Various 0.00 2,499.31 12.92 0.00 1,180,000.00 1,179,712.34 1,229_ 7 1,242.09 1,242.09 359,899,41 176,00 8.67 05/12/2014 0.00 0.00 0.00 05/15/2014 0.00 506.00 8.67 0.00 360,000.00 359,908.08 330.00 338.67 338.67 1,385,955,84 1,166, 67 473.93 01/08/2015 0.00 0.00 0.00 01/13/2015 0.00 2,625.00 473.93 0.00 1,400,000.00 1,386,429.77 1,458.33 1,932.26 1,932.26 1,716,478.79 1,189.38 279.95 Various 0.00 0.00 0100 Various 0.00 4,433.12 279.95 0100 1,730,000.00 1,716,758.74 3,243.74 3,523.69 3,523.69 1,776,253.53 12,767.71 0.00 01 /21/2016 0.00 Q00 511.77 01 /26/2016 0.00 16,486.46 (511.77) 0.00 1,750, 000.00 1,775,741.76 3,718.75 3,206.98 3,206.98 919,525.01 598.00 7.86 05/16/2016 0.00 0.00 0.00 05/1912016 0.00 2,093,00 7.86 0.00 920,000.00 919,532.87 11495.00 1,502.86 1,602.86 2,575, 073.08 5,724.45 0.00 Various 0.00 0.60 522.16 Various 0.00 9,457.78 (522,16) 0.00 2,560,000.00 2,574,550.92 3,733.33 3,211.17 3,211.17 512,880.26 152.75 13.77 Various 0.00 286.39 0.00 Various 63,370.47 133.87 13.77 0.00 449,567.71 449,523.56 267,51 281.28 281.28 565,744.19 231.34 4.78 08/18/2015 0.0c 433.76 0.00 08/26/2015 61,784.56 206.08 4.78 0.00 503,991.03 503,964.41 408.50 413.28 413.28 1,755,414.06 9,825.56 14.03 Various 0.00 0.00 35.08 Various 0,00 11,946.19 (21,05) 0.00 1,755,000.00 1,755,393.01 2,120.63 2,099.58 2,099.58 1,029,909.93 512.71 4.33 02/24/2015 0.00 961.33 0,00 03/04/2015 0.00 512.71 4.33 0.00 1,030,000.00 1,029, 914.26 961.33 965.66 965.66 Page 18 Execution Time. 7l312016 1222:20 PM 75/332 4,r:rr, city of chino Hills Income Earned Account #'10150 " . 5/31/16 Thru 6130/16 91159HHE3 US Bancorp 140,151.19 121.33 0.00 Callable Note Cent 10/15/2018 02/12/2014 0.00 0.00 5.23 1.95% Due 11/15/2018 02/18/2014 OXG 348.83 (5.23) 0.00 140,000.00 140, [45.96 227,50 222.27 222.27 91159HHHG US Bancorp 1,226,463.82 2,695.00 20.34 Callable Note Cant 3/25/2019 Various 484,851.50 (1,625.56) 161.54 2.2% Due 04/25/2019 Various 0.00 6,856.66 (141.2G) 0.00 1,700,000.00 1,711,174.12 2,536,10 2,394.90 2,394.90 912828A34 US Treasury 1,787,422.76 61.47 413.72 Note 1.25% Due 1113012018 Various Various 0.00 0.00 0.00 1,905.73 0.00 413.72 0.00 1,8DO,OOO.00 1,787,836,48 1,844.26 2,257.98 2,257.98 912828890 US Treasury 13541,323.20 7,581.52 0.00 Note 2% Due 02128/2021 04/26/2016 0,00 0.00 715.34 04/28/2016 0.00 10,027.17 (715.34) 0.00 1,500, 000.00 1,540,607.86 2,445.65 1,730.31 1,730.31 912828H52 US Treasury 2,379,671.98 10,054.94 455.44 Note 1.25% Due 01/31/2020 Various Various 0.00 0.00 0.00 12,527.47 0.00 455.44 0.00 2,400,000.00 2,380,127.42 2,472.53 2,927.97 2,927,97 912828,184 US Treasury 2,251,206.38 5,240,78 0.00 Note 1.375% Due 03/31/2020 10/23/2015 0.00 0.00 40.88 10/26/2015 0.00 7,776.64 (40.88) 0.00 2,250,000.00 2,251,865,50 2,535.86 2,494.98 2,494.98 912828L99 US Treasury 2,612,872.48 3,168,4E 690.53 Note 1.375% Due 10/81/2020 11/23/2015 0.00 0.00 0.00 11/24/2015 0.00 6,138.93 690.53 0.00 2,650,000.00 2,613,563.01 2,970.45 3,660.98 3,660.98 91282BN89 US Treasury 2,497,678.62 11,521.29 40.85 Note 1.375% Due 01/31/2021 03/0912016 0.00 0.00 0.00 03/1112016 0.00 14,354.40 40,85 0,00 2,500,000.00 2,497,719.47 2,833.11 2,873.96 2,873.96 912828SD3 US Treasury 1,935,881.31 8,169.64 434.86 Note 1.25% Due 01/31/2019 10/07/2014 10/0312014 0.00 0.00 0.00 10,178.57 0.00 434.86 0.00 1,950,000.00 1,936,316.17 2,008.93 2,443.79 2,443.79 912828SH4 US Treasury 1,987,884.32 6,949.73 362.75 Note 1.375% Due 02/28/2019 Various Various 0.00 0.00 0.00 9,191.58 0,00 362.75 0.00 21000,000.00 1,988,247.07 2,241.85 2,604.60 2,604.60 912828ST8 US Treasury 1,803,297,52 1,983.70 612.49 Nate 1.25% Due 04/30/2019 06/10/2014 0.00 0.00 0.00 06/11/2014 0.00 3,843.41 612.49 0.00 1,825, 000.00 1,803,910.01 1,859.71 2,472.20 2,472.20 Chandler Asset Management - CONFIDZNTIAL Page 19 Execution Time: 7/=016 12:02:20 PM 76/332 City of Chino Hills ,a Nk. �: Account #10150 912828TG5 91282BUH4 912828VF-7 912828VF4 912828WD8 92826 CAS8 931142DF7 94974BGF1 TOTAL. Fixed income US Treasury Note 0.5% Due 0713112017 US Treasury Nate 1 % Due 11180/2019 US Treasury N ote 1% Due 05/31/2018 US Treasury Note 1.375% Due 05/31/2020 US Treasury Note 1.25% Due 10/3112018 Visa Inc Note 2.2% Due 12/14/2020 Wal-Mart Stores Note 1.125% Due 04/11/2018 Wells Fargo Corp N ote 2.15% Due D1/30/2020 Income Earned 5/31116 Thru 6130116 1,744,092.23 Various 0.00 Various 0.00 1,750,000.00 1,744,509.25 1,962,496.87 Various 0.00 Various 0.00 2,000, 000,00 1,963,377.92 1,894,897.40 Various 0.00 Various 0.00 11900, 000.00 1,895,107.38 2,32B,295.25 07/10/2015 0.00 07/13/2015 0.00 2,350,000.00 2,328,741.24 2,293,700.36 Various 0100 Various 0.00 2,300,000.00 2,293,914.64 0.00 06/16/2016 1,330,940.00 06/21/2016 0.00 1,300,000.00 1,330,751.00 644,779,34 04/04/2013 0.00 04/11/2013 0.00 645,000.00 644,789.09 1, 822,497.25 01/26/2015 0.00 02/02/2015 0.00 1,825,000, 00 1,822,553.36 131,158,867.85 2,242,236.50 1,966,594.84 131, 615, 901.46 131,437, 043.35 2,932.62 0.00 3,653,84 721.15 54.64 0.00 1,693.99 1,639.35 51.91 0.00 1,609,29 1,557.38 88.29 0.00 2,736.85 2,648.56 2,500.00 0.00 4,843,76 2,343.76 0.00 (556.11) 1,350.56 794.45 1,007.81 0.00 1,612.50 604.69 13,168.16 0.00 16,457.95 3,269.79 394,155.82 131,222.82 417,077.64 154,144.64 417,02 0.00 417.02 1,138.17 881.05 0.00 881.05 2,520.40 209,98 0.00 209.98 1.767.36 445.99 0.00 445.99 3,094.55 359.06 144.78 214.28 2,558.04 0.00 189.00 (189.00) 605,45 9.75 o.aa 9.75 614.44 56.11 0.00 56.11 3,325.90 12,500.51 9,966.67 2,533.84 156, 678.48 0.00 1,138,17 0.00 2,520.40 0.00 1,767,36 0.00 3,094.55 0.00 2,558.04 0.00 605.45 0.00 614.44 0.00 3,325.90 0.00 156,678.48 Chandler Asset Management- CONFIDENTIAL Page 20 Execution Time: 713f2016 12:02:20 PM 77/332 City of Chino Hills Income Earned CA Account #10i50 5131/16 Thru 6/30/16 31846V401 First American Govt Obligation MMKT Class-D TOTAL Cash & Equivalent TOTAL PORTFOLIO Various Various 18,746.45 18,746.45 131,634,647.91 171, 906.87 0.00 2,100,653.23 4,59 2,253, 813.65 0.00 18,746,45 4.59 171,906,87 0.00 2,100,653.23 4.59 2,253,813.65 0,00 18,746.45 4.59 131,330,774.72 394,155.82 4,342,389.73 131,227.41 4,220,403.49 417,077.64 131,455,789.80 154,149.23 0.00 0.00 0.00 0.00 4.59 4,59 0.00 0,00 0.00 0.00 4.59 4..59 12,500.51 9,966.67 2,533.84 0.00 156,683.07 156,683.07 Chandler Asset Management- CONFIDENTIAL Page 21 Execution Time: 7=016 12:02:20 PM 78/332 CA] CiEy of Chino Hills Account#10150 Cash FIow Report From 06/30/2016 0710512016 Maturity 46625HJA9 700,000.00 JP Morgan Chase Note 700,000.00 11,025.00 711,025.00 3.15% Due 7/5/2016 07/12/2016 Interest 3137EADNS 2,225,000.00 FHLMC Note 0.00 8,343.75 8,343,75 0.75% Due 1/12/2018 07/12/2016 Interest 89236TCAl 1,755,000.00 Toyota Motor Credit Corp Note 0.00 12,723.75 12,723.75 1.45% Due 1/1212018 0711412016 Interest 36962G7G3 1,00C,000.00 General Electric Capital Corp Note 0.00 11,500.00 11,500.00 2.3% Due 1/14/2019 07/15/2016 Paydown 43814HAC2 67C,698.79 Honda Auto Receivables 2014-3 A3 57,436.26 491.85 57,928.11 0.88% Due 6/15/2018 07/15/2016 Paydown 477877AD6 1,022,102.22 John Deere Owner Trust 2014-6 A3 75,662.58 911.38 76,573.95 1.07% Due 11/15/201 a 07/15/2016 Paydown 47788MAC4 1,010,000.00 John Deere Owner Trust 2016-AA3 0.00 1,144.67 1,144.67 1.36% Due 4115/2020 07115/2016 Paydown 89231 MACS 449,567.71 Toyota Auto Receivables Owner 2014-A 54,089.04 251.01 64,340.05 0.67% Due 1211512017 0711512016 Paydown 89231TAB6 503,991.03 Toyota Auto Receivables Owner2015-C 34,467.13 386.39 34,853,52 0.92% Due 2/1512018 0711512016 Paydown 89236WAC2 1,030,000,00 Toyota Auto Receivables Owner2015-A 64,190.97 961.33 65,152.30 1.12% Due 2/15/2019 07/15/2016 Paydown 161571 GC2 1,030,000.00 Chase C"T Pool #2013-A8 0.00 866.92 866.92 1.01 % Due 10/15/2018 07/1512016 Paydown 477879AC4 34,536.16 John Deere Owner Trust 2013-6 A3 2,451.55 25.04 2,476.59 0.87% Due 8115=17 07/15/2016 Paydown 47787VAC5 566,182.99 John Deere Owner Trust 2014-A A3 66,055.33 434,07 66,489.40 0.92% Due 411612018 07/1812016 Paydown 43814NAB'I 1,035,00C.D0 Honda Auto Receivables 2016-1 A2 42,622.93 871.13 43,494.06 1.01 %n Due 611812018 07/18/2016 Paydown 43814GAC4 428,822.56 Honda Auto Receivables 2014-2 A3 46,368.26 275.16 46,643.42 0.77% Due 3/19/2018 07120/2016 Interest 3135GOE33 2,175,000.00 FNMA Note 0.00 12,234.38 12,234.38 1.125% Due 712012018 07/21/2016 Paydown 43813NACO 1,255,000.00 Honda Auto Receivables 2015-2 A3 53,011.90 1,087.67 54,099,57 1.04% Due 2/21/2019 07/30/2016 Interest 3135GOGY3 1,725,000,00 FNMA Note . 0.00 10,781.25 10,781.25 1.25% Due 1/30/2017 07/3012016 interest 94974BGF1 1,825,000.00 Wells Fargo Corp Note 0.00 19,618.75 19,618.75 2.15% Due 1/30/2020 07131/2016 Interest 912828H52 2,400,000.00 US Treasury Note 0.00 15,000.00 15,000,00 1.25% Due 1/3112020 Chandler Asset Management - CONFIDENTIAL. Page 22 UCecutlen Tme: 71MOI S 12:02:20 PU 79/332 0, City of Chino Hills „ Account#10150 Lf J. 07/31 /2016 Interest 07131 /2016 Interest 0713112016 Interest Jul 2016 08101/2016 Interest 08/06/2016 Interest 08/15/2016 Interest 08/15/2016 Paydown 0811512016 Paydown 08/1512016 Paydown 08/1512016 Paydown 08/15/2016 Paydown 08115/2016 Paydown 08/1512016 Paydown 0811512016 Paydown 0811512016 Paydown 08/18/2016 Interest 0811812016 Interest 08/18/2016 Paydown 08118/2016 Paydown 0811912016 Interest 912828SO3 912828TG5 91282BN89 3137EADK2 459200HZ7 22160KAGO 43814HAC2 477877AD6 477879AC4 47787VAC5 47788MAC4 89236WAC2 161571 GC2 89231 MACS 89231TAB6 313OA7CV5 857477AS2 43814GAC4 43814NAB1 3135GOZA4 Chandler Asset Management - CONFIDENTIAL Cash Mow Report From 06/30/2016 1,950,000.00 US Treasury Note 1.25% Due 1/31/2019 1,750,000.00 US Treasury Note 0.5% Due 7/3112017 2,500,000.00 US Treasury Note 1.375% Due 1/31/2021 2,225,000.00 FHLMC Nate 1.25% Due 8/1/2019 1,700,000.00 IBM Corp Note 1.125% Due 2/6/2018 900,000.00 Costco Wholesale Corp Note 1.75% Due 2/15/2020 670,698.79 Honda Auto Receivables 2014-3 A3 0.88% Due 611 S12018 1,022,102.22 John Deere Owner Trust 2014-8 A3 1.07% Due 11/15/2018 34,536.16 John Deere Owner Trust 2013-8 A3 0.87% Due 811512017 566,182.99 John Deere Owner Trust 2014-A A3 0.92% Due 411612018 1,010,000.00 John Deere Owner Trust 2016-A A3 1.36% Due 4/15/2020 1,030,000.00 Toyota Auto Receivables Owner2015-A 1,12% Due 2/15/2019 1,030,000.00 Chase CHAT Pool #2013-A8 1.01 % Due 10/15/2018 449,567.71 Toyota Auto Receivables Owner 2014-A 0.67% Due 12/15/2017 503,991.03 Toyota Auto Receivables Owner 2015-C 0.92% Due 2/15/2018 2,235,000.00 FHLB Note 1.375% Due 2/18/2021 1,750,000.00 State Street Bank Note 2.55% Due 8/18/2020 428,822.56 Honda Auto Receivables 2014-2 A3 0.77% Due 3119/2018 1,035,000.00 Honda Auto Receivables 2016-1 A2 1.01 % Due 6/1812018 2,155,000.00 FNMA Note 1.875% Due 2/19/2019 Page 23 0.00 0.00 0,00 1,206,355.95 0.00 0.00 0.00 56,576.23 73,736.26 2,453.90 63,964.68 0.00 62,864.36 0.00 61,839.09 33,496.65 0.00 0.00 44,895.70 42,6W.27 0.00 12,187.50 4,375.00 17,187.50 142,683.50 13,906.25 9,562.50 7,875.00 449.73 843.91 23.26 383.43 1,144.67 901.42 866.92 215,23 359.97 15,365.63 22,312.50 245.41 835.25 20,203.13 12,187.50 4,375, 00 17,187,50 1,349,039.45 13,906.25 9,562.50 7,875,00 57,025.96 74,580.17 2,477.16 64,348.11 1,144.67 53,765.78 866.92 62, 054.32 33,856,62 15,365.53 22,312.50 45,141,11 43,501.52 20,203.13 Execution 77me: 7/3/201612:02:20 PM 80/332 City of Chino dills Account #10150 Cash Flow Report From 06130./2016 08/21/2016 Paydown 43813NACO 1,255,000,00 Honda Auto Receivables 2015-2 A3 523133.80 1,041.72 53,175.52 1.04% Due 2/21/2019 08/22/2016 Interest 3133ECG99 335,000.00 FFCB Note 0.00 1,105.50 1,105.50 0.66% Due 2/22/2017 08/26/2016 Interest 3135GOJ20 2,700,000.00 FNMA Note 0.00 18,582.50 18,562.50 1.375% Due 2126/2021 08/31/2016 Interest 91282SB90 1,500,000,00 US Treasury Note 0.00 15,000.00 15,000.00 2% Due 2/28/2021 08/31/2016 Interest 912828SH4 2,000,000.00 US Treasury Note 0.00 13,750.00 13,750.00 1.375% Due 212812019 Aug 2016 494,626.94 144,953.93 639,580.87 09/01/2016 Interest 17275RAR3 1,155,000.DO Cisco Systems Note 0.00 12,271.88 12,271.88 2,125% Due 3/1/2019 09/0112016 Interest 30231GAV4 1,795,000.00 Exxon Mobil Corp Callable Note Cont21112021 0.00 19,720.87 19,720.87 2.222% Due 3/1/2021 0910712CI6 Interest 3137EADPI 2,225,000.00 FHLMC Note 0.00 9,734.38 9,734,38 0.875% Due 3/7/2018 09/11/2016 Interest 06406HCW7 1,815,000.00 Bank of New York Callable Note Cont 8/11/2019 0.00 20,872,50 20,872.50 2.3% Due 9/11/2019 09tl212016 Interest 3135GOZGI 1,900,000.00 FNMA Note 0.00 16,625.00 16,625.00 1.75% Due 911212019 09/15/2016 Maturity 24422ERFS 700,000.00 John Deere Capital Corp Note 700,000.00 6,475.00 706,475.00 1.85% Due 9/15/2016 09/15/2016 Paydown 477879AC4 34,536.16 John Deere Owner Trust2013-B A3 2,455.25 21.48 2,477.73 0.87% Due 8/15/2017 09/16/2016 Paydown 47787VAC5 566,182.99 John Deere Owner Trust2014-AA3 61,871.61 334.39 62,206.00 0.92% Due 411612018 09/15/2016 Paydown 161571GC2 1,030,000.00 Chase CHAIT Pool #2013-A8 0.00 866.92 866.92 1A1% Due 1011512018 09115/2016 Paydown 43814HAC2 670,698.79 Honda Auto Receivables 2014-3 A3 55,687.06 408.24 55,095.30 0.88% Due 6/15/2018 09/15/2016 Paydown 477877AD6 1,022,102.22 Sohn Deere Owner Trust 2014-B A3 71,806,73 778.16 72,584.89 1.07% Due 11M512018 09/15/2016 Paydown 47788MAC4 1,010,000.00 John Deere Owner Trust 2016-A A3 0.00 1,144.57 1,144.67 1.35% Due 4/15/2020 09/15/2016 Paydown 89231 MAC9 449,567.71 Toyota Auto Receivables Owner 2014-A 59,586.53 180.70 59,757.23 0.67% Due 12/15/2017 0911512016 Paydown 89231TA$6 503,991,03 Toyota Auto Receivables Owner2015-C 32,525.34 334.29 32,859.63 0.92% Due 2/15/2018 0911512016 Paydown 89236WAC2 1,030,000,00 Toyota Auto Receivables Owner2015-A 61,536.21 842.75 62,378.96 1.12% Due 2/15/2019 Chandler Asset Management - CONRDEN IAL Page 24 Execution Time: 7/3/2016 12:02:20 PM 81 /332 City of Chino Hills Account##10150 Cash Flow Report From 06/30/2016 09/1812016 Paydown 43814GAC4 428,822.56 Honda Auto Receivables 2014-2 A3 43,421.71 216.60 43,638.31 0.77% Due 3/19/2018 09/1812016 Paydown 43814NAB1 1,035,000.00 Honda Auto Receivables 2016-1 A2 42,709.64 799.34 43,608,96 1.01 % Due 611812018 09/21/2016 Paydown 43813NACO 1,255,000.00 Honda Auto Receivables 2015-2 A3 51,254.52 996.54 52,251.06 1.04% Due 2/21/2019 0912912016 Interest 3137FADLO 1,350,000.00 FHLMC Note 0.00 6,750.00 6,750.00 1 % Due 912912017 0913012016 Interest 912828J84 2,250,000.00 US Treasury Note 0.00 15,468.75 15,468.75 1.375% Due 3/31/2020 Sep 2016 1,182,855.60 114,842.46 1,297,698.06 10/02/2016 Interest 3137EADM8 2,500,000.00 FHLMC Note 0.00 15,625.00 15,625.00 1.25% Due 10/212019 10110/2016 Interest 02665WAC5 1,770,000.00 American Honda Finance Note 0.00 18,806.25 18,806.25 2.125% Due 10/10/2018 10/11/2016 Interest 931142DF7 645,000.00 Wal-Mart Stores Note 0.00 3,628.13 3,628.13 1.125% Due 411112018 10115/2016 Interest 68389XAN5 1,770,000.00 Oracle Corp Note 0.00 10,620.00 10,520,00 1.2% Due 10/1512017 1011512016 Interest 880591 EQ1 2,560,000.00 Tennessee Valley Authority Note 0.00 22,400.00 22,400.00 1.75% Due 10/15/2018 1011512016 Paydown 89231 MACS 449,567.71 Toyota Auto Receivables Owner 2014-A 57,331.38 147.43 57,478.81 0.67% Due 12/15/2017 10/15/2016 Paydown 89231TABG 503,991.03 Toyota Auto Receivables Owner 2015-C 31,553.19 309.35 31,862.54 0.92% Due 2/15/2018 10115/2016 Paydown 161571GC2 1,030,000A0 Chase CHAIT Pool #2013-A8 0.00 866.92 866,92 1,01% Due loll5/2018 1011512016 Paydown 43814HAC2 670,698.79 Honda Auto Receivables 2014-3 A3 54,768.01 367.40 55,135.41 0.88% Due 6/15/2018 10115/2015 Paydown 477877AD6 1,022,102.22 John Deere Owner Trust 2014-B A3 69,874.00 714.14 70,588.14 1.07% Due 11/15/2018 10/15/2016 Paydown 477879AC4 34,536.16 John Deere Owner Trust 2013-6 A3 2,468.60 19,70 2,478.30 0.87% Due 8/15/2017 10/15/2016 Paydown 47787VAC5 566,182.99 John Deere Owner Trust 2014-A A3 59,776.11 286.96 60,063.07 0.92% Due 4/16/2018 10115/2016 Paydown 47788MAC4 1,010,000.00 John Deere Owner Trust 2016-A A3 0.00 1,144.67 1,144.67 1.36% Due 4115=20 1011512016 Paydown 89236WAC2 1,030,000.00 Toyota Auto Receivables Owner 2015-A 60,206.53 785.31 60,991.84 1.12% Due 2/15/2019 10/18/2016 Paydown 43814GAC4 428,822.56 Honda Auto Receivables 2014-2 A3 41,946.27 188.74 42,135,01 0.77% Due 3/19/2018 Chandler Asset Management- CONFIDENTIAL Page 25 Execution Time: 7/312016 12:02:20 PM 82/332 .,:, City of Chino Hills Cash Flow Report i Account #10150 From 06/30/2016 e. R s• MEN 10118/2016 Paydown 43814NAB1 1,035,000.00 ,Honda Auto Receivables 2016-1 A2 42,753.07 763.39 43,516-46 1.01 % Due 6/18/2018 10/21/2016 Paydown 43313NACO 1,255,000.00 Honda Auto Receivables 2015-2 A3 50,374.08 952.12 51,326.20 1.04% Due 2/21 /2019 10/25/2016 Interest 91159HHH6 1,700,000.00 US Bancorp Callable Note Cant 3125/2019 0.00 18,700.00 18,700.00 2.2% Due 412512019 10/25/2016 Interest 3130A4GJ5 2,200,000.00 FHLS Note 0-00 12,375.00 12,375.00 1.125% Due 4/25/2018 10/27/2016 Interest 3135GOJA2 1,750,000.00 FNMA Note 0.00 9,843.75 9,643.75 1.125% Due 4/27/2017 10/27/2016 Interest 36962G5WO 675,000.00 General Electric Capital Corp Note 0.00 7,762.50 7,762.50 2.3% Due 412712017 10/2812016 Maturity 31331JX32 1,850,000.00 FFCB Note 11850,000,00 15,725.00 1,865,725.00 1.7% Due 10/28/2016 10/30/2016 Interest 713448CR7 1,180,000.00 PepsiCo Inc Note 0.00 7,375.00 7,375.00 1.25% Due 4/3012018 1013112016 Interest 912828ST8 1,825,000,00 US Treasury Note 0.00 11,406.25 11,406.25 1.25% Due 4/30/2019 10131/2016 Interest 012828WDB 2,300,000.00 US Treasury Note 0.00 14,375.00 14,375.00 1,25% Due 10/31/2018 1013112016 Interest 9128281-99 2,650,000.00 US Treasury Nate 0.00 18,218.75 18,218.75 1.375% Due 10/3112020 Oct 2016 2,321,041.24 193,406.76 2,514,448.00 11/01/2016 Interest 3137EADR7 2,550,000.00 FHLMC Note 0.00 17,531.25 17,531.25 1.375% Due 5/1/2020 11/03/2016 Interest 037833AJ9 1,800,000.00 Apple Inc Nate 0.00 9,000,00 9,000.00 1% Due 5/3/2018 11103/2016 Interest 594918BG8 675,000.00 Microsoft Callable Note Cont. 10/03120 0.00 6,750.00 6,750.00 2% Due 111312020 11/0612016 Interest 3135GOK69 975,000.00 FNMA Note 0.00 5,755.21 5,755.21 1.25% Due 5/6/2021 11/07/2016 Interest 74005PBH6 1,400,000.00 Praxair Note 0.00 8,750.00 8,750.00 1.25% Due 11/712018 1111212016 Interest 3137EADF3 2,250,000.00 FHLMC Note 0.00 14,062.50 14,062.50 1.25% Due 5/12/2017 1111512016 Interest 084664BS9 1,100,000.00 Berkshire Hathaway Note 0.00 8,800.00 8,800.00 1.6% Due 511,912017 11115/2016 Interest 717081DJ9 360,000,00 Pfizer Inc. Note 0.00 1,980.00 1,980.00 1.1% Due 511512017 11/15/2016 Interest 91159HHE3 140,000.00 US Bancorp Callable Note Cant 10/15/2018 0.00 1,365-00 1,365.00 1.95% Due 11/15/2018 Chandler Asset Management - CONFIDENTIAL Page 26 Execution Tme., 7l312C16 12:0220 PM 83/332 . City of china Hills Account#10150 Cash Flow Report €� From 0613012(}16 11/15/2016 Paydown 89231 MACS 449,567,71 Toyota Auto Receivables Owner 2014-A 55,073.60 115.42 55,189-02 0.67% Due 12/15/2017 11/15/2015 Paydown 89231TAB6 503,991.03 Toyota Auto Receivables Owner 2015-C 30,580.19 285.16 30,865.35 0.92% Due 2/15/2018 1111512016 Paydown 89236WAC2 1,030,000.00 Toyota Auto Receivables Owner 2015-A 58,875.29 729.12 59,604.41 1.12% Due 2/15/2019 11/15/2016 Paydown 43814HAC2 670,698.79 Honda Auto Receivables 2014-3 A3 53,818.31 327.24 54,145-55 0.88% Due 6/15/2018 11/15/2016 Paydown 477877AD6 1,022,102.22 Jahn Deere Owner Trust 2014-B A3 67,938.09 651.83 68,569,92 1.07% Due 11/15/2018 11/15/2016 Paydown 47788MAC4 1,0103000.00 John Deere Owner Trust 2016-A A3 0.00 1,144.67 1,144.57 1.36% Due 4/15/2020 11/15/2016 Paydown 161571GC2 1,030,000.00 Chase CHAIT Pool #62013-A8 42,506,81 866.92 43,373.73 1.01 % Due 10115)2018 11/15/2016 Paydown 477879AC4 34,536.16 John Deere Owner Trust 2013-3 A3 2,46C.95 17.92 2,478.87 0.87% Due 811512017 11/15/2016 Paydown 477B7VAC5 566,182.99 John Deere Owner Trust 2014-AA3 57,678.19 241.13 57,919.32 0.92% Due 411612018 1111812016 Paydown 43814NAB1 1,035,000.00 Honda Auto Receivables 2016-1 A2 42,796.53 727.41 43,523.94 1.01 % Due 6/1812018 1111812016 Paydown 43814GAC4 428,822.56 Honda Auto Receivables 2014-2 A3 40,469.40 161.82 40,G31.22 0.77% Due 311912018 11/19/2016 Interest 857477AV5 920,000.00 State Street Bank Note 0,00 8,970.00 8,970.00 1.95% Due 5/19/2021 11/20/2016 Interest 747525AD5 1,730,000.00 QU3100 M Inc Note 0.00 19,462.50 19,462.50 2.25% Due 5/20/2020 IV2112016 Interest 3135GOWJ8 575,000.00 FNMA Note 0.00 2,515.63 2,515.63 0.875% Due 50/2018 11/2112016 Paydown 43813NACO 1,255,000.00 Honda Auto Receivables 2015-2 A3 49,492.46 908A6 50,400.92 1.04% Due 2/21/2019 11/30/2016 Interest 91282BUB4 2,000,000,00 US Treasury Note 0.00 10,000.00 10,000.00 1 % Due 11/30/2019 11/3012016 Interest 912828VF4 2,350,000.00 US Treasury Note 0.00 16,156.25 16,156.25 1.375% Due 5/31/2020 11/50/2016 Interest 3135GOF73 2,700,000.00 FNMA Note 0.00 20,250.00 20,250.00 1.5% Due 11/30/2020 11/30/2016 Interest 3137EADG1 2,150,000.00 FHLMC Note 0,00 18,812.50 18,812.50 1.75% Due 5/30/2019 1V3012016 Interest 91282BA34 1,800,000.00 US Treasury Note 0.00 11,250.00 11,250.00 1.25% Due 11130/201 B Chandler Asset Management - CONFIDENTIAL Page 27 Execution Tme: 71312G16 12:02:20 PM 84/332 q City of Chino Hills Cash Flow Report ,3 Account #10150 From 06/30/2016 now 11/3012016 Interest 912828VC7 1,900,000.00 US Treasury Note 0.00 9,500.00 91500.0C 1 % Due 5/31 /2018 Nov 2016 501,689.82 197,087.94 698,777.76 12/05/2016 Interest 166764AA8 1,715,000.00 Chevron Corp Callable Note Cont 1115117 0.00 9,466.80 9,466.80 1.104% Due 12/5/2017 1210812016 Interest 313379DT3 2,600,000.00 FHLB Note 0.00 16,250.00 16,250-00 1.25% Due 6/8/2018 1210912016 Interest 313379FW4 2,250,000.00 FHLB Note 0.00 11,250.00 11,250.00 1% Due 6/9/2017 12/12/2016 Interest 313383HUS 2,500,000.00 FHLB Note 0.00 21,875.00 21,875.00 1.75% Due 611212020 12/1312016 Interest 24422ESF7 1,095,000,00 John Deere Capital Corp Note 0.00 10,676.25 10,676.25 1.95% Due 12113/2018 12/1412016 Interest 92826CAB8 1,300,000.00 Visa Inc Note 0.00 14,300.00 14,30C.00 2.2% Due 1211412020 12J1512016 Interest 458140AL4 1,375,000.00 Intel Corp Note 0.00 9,281.25 9,281.25 1.35% Due 12/15/2017 1211512016 Paydown 89231 MACS 449,567.71 Toyota Auto Receivables Owner 2014-A 52,813.22 84.67 52,897.89 0.67% Due 12/15/2017 1211512016 Paydown 161571 GC2 1,030,000,00 Chase CHAIT Pool #2013-A8 42,542.23 831.14 43,373.37 1.01 % Due 1Oil 5/2018 12/15/2016 Paydown 43814HAC2 670,698.79 Honda Auto Receivables 2014-3 A3 52,837,19 287.77 53,124,96 0.88% Due 6/1512018 1211512016 Paydown 477877AD6 1,022,102.22 John Deere Owner Trust2014-B A3 65,998.98 $91.25 66,590.23 1.07% Due 11115/2018 12/15/2016 Paydown 477879AC4 34,536.16 John Deere Owner Trust 2013-B A3 2,463.32 16,13 2,479A5 0.87% Due 811512017 12/15/2016 Paydown 47787VAC5 566,1 B2.99 John Deere Owner Trust 2014-A A3 55,577.84 196.91 55,774.75 0.92% Due 4/16/2018 12115/2016 Paydown 47788MAC4 1,010,000,00 John Deere Owner Trust 201&AA3 0.00 1,144.67 1,144.67 1.36% Due 411512020 1211512016 Paydown 89231TASE 503,991,03 Toyota Auto Receivables Owner 2015-C 29,606.35 261,72 29,868.07 0.920/6 Due 2/15/2018 1211612016 Paydown 89236WAC2 1,030,000.00 Toyota Auto Receivables Owner2015-A 57,542.51 674,17 58,216,68 1.12% Due 2/1512019 1211812016 Paydown 43814GAC4 428,822.56 Honda Auto Receivables 2014-2 A3 38,091.09 135.85 39,126.94 0,77% Due 3/19/2018 12/18/2016 Paydown 43814NAB1 1,035,D00.00 Honda Auto Receivables 2016-1 A2 42,840.04 691.30 43,531.43 1.01 % Due 611812018 12/20/2016 Interest 3135GOR72 1,775,000.00 FNMA Note 0.00 7,765.63 7,755.63 0.875% Due 12/20/2017 Chandler Asset Management - CONFIDENTIAL Page 28 Execu6on Time: 71312098 12:02:20 PM 85/332 City of Chino Hills r'j Account #10150 �4 •�w. .. .,. ., Cash Flow Report From 06/30/2016 12/20/2016 Interest 3135G02'E6 1,900,000.00 FNMA Note 0.00 16,625.00 16,625.00 1.75% Due 6/20/2019 12/21/2016 Paydown 43813NACO 1,255,000.00 Honda Auto Receivables 2015-2 A3 48,609.68 865.57 49,475.25 1.04% Due 2/21/2019 1212212016 Interest 3135GOD75 2,625,000.00 FNMA Nate 0.00 19,687.50 19,687,50 1.5% Due 6/22/2020 Dec 2016 439,822.45 142,958.67 632,781.12 01/12/2017 Interest 3137EADN6 2,225,000.00 FHLMC Note 0.00 8,343.75 8,343.75 0.75% Due 1/12/2018 01/12/2017 Interest 89236TCAl 1,755,000.00 Toyota Motor Credit Corp Note 0.00 12,723.75 12,723.75 1.45% Due 1/12/2018 01/1412017 Interest 36962G7G3 1,000,000.00 General Electric Capital Corp Note 0.00 11,500.00 11,500.00 2.3% Due 1/14/2019 01/15/2017 Paydown 161571GC2 1,030,000.00 Chase CHAIT Pao[ #f2013-A8 42,577.69 795.33 43,373.02 1.01% Due 10/1512018 01/15/2017 Paydown 43814HAC2 670,698.79 Honda Auto Receivables 2014-3 A3 51,823.84 249.02 52,072.86 0.88% Due 611512018 0111512017 Paydown 477877AD6 1,022,102.22 John Deere Owner Trust 2014-B A3 64,056.64 532.40 64,589.04 1.07% Due 11/15/2018 01/1612017 Paydown 47787VAC5 566,182.99 John Deere Owner Trust 2014-A A3 53,475.06 154.30 53,62e.36 0.92% Due 4/16/2018 01/15/2017 Paydown 89231 MAC9 449,567.71 Toyota Auto Receivables Owner 2014-A 50,550.22 55.19 50,605.41 0.67% Due 1211512017 0111512017 Paydown 89231TAB6 503,991.03 Toyota Auto Receivables Owner 2015-C 28,631.67 239,02 28,870.69 0.92% Due 211512018 01/1512017 Paydown 477879AC4 34,536.16 John Deere Owner Trust 2013-BA3 2,465.67 14.35 2,480.02 0.87% Due 8/15/2017 01115/2017 Paydown 47788MAC4 1,010,000.00 John Deere Owner Trust 2016-A A3 0.00 1,144.67 1,144.67 1.36% Due 4/15/2020 01/1512017 Paydown 89236WAC2 1,030,000.00 Toyota Auto Receivables Owner 2015-A 56,208.18 620.47 56,828.65 1.12% Due 2/15/2019 01/1712017 Paydown 89231MAC9 4493567.71 Toyota Auto Receivables Owner2014-A 48,284,61 1.80 48,2e6.41 0.67% Due 12/1512017 01/18/2017 Paydown 43814GAC4 428,822.56 Honda Auto Receivables 2014-2 A3 37,511.32 110.84 37,622.16 0.77% Due 3/19/2018 01118/2017 Paydown 43814NAB1 1,035,600.00 Honda Auto Receivables 2016-1 A2 42,883.59 655.33 43,538.92 1.01% Due 611812018 01/20/2017 Interest 3135GOE33 2,175,000.00 FNMA Note 0.00 12,234.38 12,234.38 1.125% Due 712012018 01/21/2017 Paydown 43813NACO 1,255,000:00 Honda Auto Receivables 2015-2 A3 47,725.72 823.44 413,549.16 1.04% Due 2/21/2019 Chandler Asset Management - CONFIDENTIAL Page 29 Execution Time: 7/312016 12:02:20 PM 86/332 City of Chino Hills Cash Flow Report CA, Account #10150 From 06/30/2016 ' Ill I h I Namomm, 01/30/2017 Interest 94974BGFI 1,825,000.00 Wells Fargo Corp Note 0.00 19,618.75 19,618,75 2.15% Due 1/30/2020 01/30/2017 Maturity 3135GOGY3 1,725,000.00 FNMA Note 1,725,000,00 10,781.25 1,735,781.25 1.25% Due 113012017 01/31/2017 interest 912828H52 2,400,000.00 US Treasury Note 0.00 15,000.00 15,000.00 1.25% Due 1/31/2020 01/31/2017 Interest 912828N89 2,500,000.00 US Treasury Note 0.00 17,187.50 17,187.50 1.375% Due 1/31/2021 01/31/2017 Interest 912828SD3 1,950,000.00 US Treasury Note 0.00 12,187.50 12,187.50 1.25% Due 1131)2019 01/31/2017 Interest 912828TG5 1,750,000.00 US Treasury Note 0.00 4,375.00 4,375.00 0.5% Due 7/3112017 Jan 2017 2,251,194.21 129,348,04 2,380,542.25 02/01/2017 Interest 3137EADK2 2,225,000.00 FHLMC Note 0.00 13,906.25 13,906.25 1.25% Due 8/1/2019 0210612017 Interest 459200HZ7 1,700,000.00 IBM Corp Note 0.00 9,562.50 9,562.50 1.125% Due 2/612018 02 I512017 Interest 22160KAGO 900,000.00 Costco Wholesale Corp Note 0.00 7,875.00 7,875.00 1.75% Due 2/15/2020 0211512017 Paydown 43814HAC2 670,698.79 Honda Auto Receivables 2014-3 A3 50,777.42 211.02 50,988.44 0.88% Due 6/15/2018 02/15/2017 Paydown 477877AD6 1,022,102.22 John Deere Owner Trust 2014-B A3 62,111.09 475,29 62,586.38 1.07% Due 11/15/2018 02/15/2017 Paydown 477879AC4 34,536.16 John Deere Owner Trust 2013-B A3 2,468.03 12.56 2,480,59 0.87% Due 811512017 0211512017 Paydown 47788MAC4 1,010,000,00 John Deere Owner Trust 201&AA3 0.00 1,144.67 1,144.67 1.36% Due 411512020 02/15/2017 Paydown 89231TAB6 503,991.03 Toyota Auto Receivables Owner 2015-C 27,656.14 217.07 27,873.21 0.92% Due 211512018 02/15/2017 Paydown 89236WAC2 1,030,000.00 Toyota Auto Receivables Owner 2015-A 54,872.31 568.00 55,440,31 1.12% Due 2/15/2019 0211512017 Paydown 161571 GC2 1,030,000.00 Chase CHAIT Pool #2013-A8 42,613.16 759,50 43,372.56 1.01 % Due 1011512018 02/1512017 Paydown 47787VAC5 566,182.99 John Deere Owner Trust 2014-A A3 51,369.85 113.30 51,483.15 0.92% Due 4/16/2018 02/18/2017 Interest 3130A7CV5 2,235,000.00 FHLB Note 0.00 15,365.63 15,365.63 1.375% Due 2/18/2021 02/18/2017 Interest 857477AS2 1,750,000,00 State Street Bank Note 0.00 22,312.50 22,312.50 2.55% Due 811812020 0211812017 Paydown 43814NABI 1,036,000,00 Honda Auto Receivables 2016-1 A2 42,927.10 619.24 43,546,43 1.01 % Due 611812018 Chandler Asset Management - CONFIDENTIAL Page 30 Execution Time: 702015 12:02:20 PM 87/332 011 City at Chino kiills Casio stow Report Account #10150 From 06I30/2016 02/18/2017 Paydown 43814GAC4 428,822.56 Honda Auto Receivables 2014-2 A3 36,030.12 86.77 36,116.89 0.77% Due 311912018 02/19/2017 Interest 3135GDZA4 2,155,000.00 FNMA Nate 0.00 20,203.13 20,203.13 1.875% Due 211912019 02/21/2017 Paydown 43813NACO 1,255,000.00 Honda Auto Receivables 2015-2 A3 46,840.59 782.08 47,622.67 1.04% Due 2/21/2019 02/22/2017 Maturity 3133ECG99 335,000.00 FFCB Note 335,000.00 1,105.50 336,105,50 0.660/. Due 2/22/2017 02/26/2017 Interest 3135GOJ20 2,700,000.00 FNMA Note 0.00 18,562.50 18,862.50 1.375% Due 2/26/2021 02128/2017 Interest 912828SH4 2,000,000.00 US Treasury Note 0.00 13,750.00 13,750,00 1.375% Due 2/28/2019 02/28/2017 Interest 912828B90 1,500,000.00 US Treasury Note 0.00 15,000.00 15,000,00 2% Due 2/28=21 Feb 2017 752,665.90 142,632.51 895,298.41 03/01/2017 Interest 17275RAR3 1,155,000.00 Cisco Systems Note 0.00 12,271.88 12,271.88 2.125% Due 3/1/2019 0310112017 Interest 30231 GAV4 1,795,000.00 Exxon Mobil Corp Callable Note Cent 2/1/2021 0.00 19,942.45 19,942.45 2.222% Due 311/2021 03/07/2017 Interest 3137EADP1 2,225,000.00 FHLMC Note 0.00 9,734.38 9,734.38 0.875% Due 3/7/2018 03/11/2017 Interest 06406HCW7 1,815,000.OD Bank of New York Callable Note Cant 8A 1/2019 0.00 20,872.50 20,872.50 2.3% Due 9/11/2019 03112/2017 Interest 3135GOZGI 1,900,000.00 FNMA Note Q.DO 16,625.00 16,625.00 1.75% Due 9/1212019 0311512017 Paydown 477879AC4 34,536.16 John Deere Owner Trust 2013-B A3 2,470.40 10.77 2,481,17 0.87% Due 811512017 0311512017 Paydown 47788MAC4 1,D10,000,00 John Deere Owner Trust 2016-AA3 0.00 1,144.67 1,144,67 1.36% Due 411512020 03/15/2017 Paydown 89236WAC2 1,030,ODO.00 Toyota Auto Receivables Owner 2015-A 53,534.88 516.79 54,051.67 1.12% Due 211512QI9 03/1512017 Paydown 161571GC2 1,030,000.00 Chase CHAIT Pool #2013-A8 42,646.68 723.63 43,372,31 1.01 % Due 10115/2018 0311512017 Paydown 43814HAC2 670,698.79 Honda Auto Receivables 2014-3 A3 49,697.13 173.78 49,870.91 0.88% Due 611512018 0311512017 Paydown 477877AD6 1,022,102.22 John Deere Owner Trust 2014-8 A3 60,162.33 419,90 60,562.23 1.07% Due 1111512018 03115/2017 Paydown 47787VAC5 566,182.99 John Deere Owner Trust 2014-A A3 49,262.2D 73.02 49,336.12 0.92% Due 411612018 03/15/2017 Paydown 89231TAB6 503,991.03 Toyota Auto Receivables Owner2015-C 26,679.78 195,85 26,875.64 0.92% Due 2/1512018 Chandler Asset Management- CONFIDENTIAL Page 31 Execution Time: 7/3/2016 12:02:20 PM 88/332 c77aft'..1 City of Chino Hills Account #10150 Cash Flow Report From 06/30/2016 03/18/2017 Paydown 43814NA81 1,035,000.00 Honda Auto Receivables 2016-1 A2 42,970,83 583.11 43,553.94 1,01 % Due 6/18/2018 03/18/2017 Paydown 43814GAC4 428,822.56 Honda Auto Receivables 2014-2 A3 34,547.47 63.65 34,611.12 0.77% Due 3/19/2018 03/21/2017 Paydown 43813NACO 1,255,000.00 Honda Auto Receivables 2015-2 A3 45,954.28 741.48 46,695.76 1.04% Due 2/21/2019 03129/2017 Interest 3137EADLO 1,350,000.00 FHI.MC Note 0.00 6,750.00 6,750.00 1 % Due 9/29/2017 03/31/2017 Interest 91282BJ84 2,250,000.00 US Treasury Nate 0100 15,468.75 15,468.75 1.375% Due 3131/2020 Mar2017 407,927.98 106,312.52 514,240.50 04/02/2017 Interest 3137EADM8 2,500,000.00 FHLMC Note 0,00 15,626.00 15,625.00 1.26% Due 10/2/2019 04/1012017 interest 02665WAC5 1,770,000.00 American Honda Finance Note 0.00 18,806.25 18,805.25 2.125% Due 10/10/2018 04/11/2017 fnterest 931142DF7 645,000.00 Wal-Mart Stores Note 0.00 3,628.13 3,628.13 1.125% Due 4/11/2018 04/15/2017 Interest 68389XAN5 1,770,000.00 Oracle Corp Note 0.00 10,620.00 10,620.00 1.2% Due 10/15/2017 04/15/2017 Interest 880591EQ1 2,560,000.00 TennesseeValley Authority Nate a.nn 22,400.00 22,400.00 1.75% Due 1011512018 04/1512017 Paydown 89231 TAB6 503,991.03 Toyota Auto Receivables Owner 2015-C 25,702.55 175.41 25,877.96 0.92% Due 2/1,912018 04/1512017 Paydown 89236WAC2 1,030,000.00 Toyota Auto Receivables Owner 2015-A 52,195.91 466.82 52,662.73 1,12% Due 211512019 0411512017 Paydown 161571GC2 1,030,000.00 Chase CHAIT Pool #2013-A8 42,684.21 687.74 43,371.95 1.01 % Due 10/15/2018 0411512017 Paydown 43814HAC2 670,698.79 Honda Auto Receivables 2014-3 A3 48,582.08 137.34 48,719A2 0.86% Due 6/15/2018 04115/2017 Paydown 477877AD6 1,022,102.22 John Deere Owner Trust 2014-B A3 58,210.34 366.26 58,576.60 1.07% Due 11/15/2018 04/15/2017 Paydown 477879AC4 34,536.16 John Deere Owner Trust 2013-B A3 2,472.76 8.98 2,481.74 0.87% Due 8/15/2017 0411512017 Paydown 47787VAC5 566,182.99 John Deere Owner Trust 2014-A A3 47,152.11 36,15 47,188.26 0.92% Due 4/1 S 2018 0411512017 Paydown 47788MAC4 1,010,000.00 John Deere Owner Trust 2016-A A3 0.00 1,144.67 1,144.67 1.36%n Due 4/1512020 04/18/2017 Paydawn 43814GAC4 428,822.56 Honda Auto Receivables 2014-2 A3 33,063.38 41.48 33,104.86 0.77% Due 311912018 0411812017 Paydown 43614NAB1 1,035,000.00 Honda Auto Receivables 2016-1 A2 43,014.52 546.94 43,561.45 1,01% Due 6/18/2018 Chandler Asset Management - CONFIDENTIAL Page 32 Execution Time- 713/2016 12.02'24 PM 89/332 City of Chino Hills .. ;E.a AGCount a' 10150 04/21/2017 Paydown 04/2512017 Interest 04/25/2017 Interest 04/2712017 Maturity 04/27/2017 Maturity 0413012017 Interest 0413012017 Interest 04/30/2017 Interest 0413012017 Interest .Apr 2017 05/01/2017 Interest 05/03/2017 Interest 0510312017 interest 0510612017 Interest 05/07/2017 Interest 05/12/2017 Maturity 05115/2017 Interest 05/15/2017 Maturity 05/15/2017 Maturity 05/15/2017 Paydown 0511512017 Paydown 43813NACO 3130A4GJ5 91159HHH6 3135GOJA2 36962G5WO 912828L99 713448CR7 912828ST8 912828WD8 3137EAD R7 037833AJ9 594918BGS 3135GOK69 74005PBH6 3137EAD F3 91159HHE3 084664BS9 717081DJ9 89236WAC2 477879AC4 Chandler Asset Management - CONFIDENTIAL Cash Flow Report From 06/30/2016 1,255,000.00 Honda Auto Receivables 2015-2 A3 1.04% Due 2/21/2019 2,200,000.00 FHLB Note 1,125% Due 4/2512018 1,700,000,00 US Bancorp Callable Note Cant 312512019 2.2% Due 412512019 1,750,000.00 FNMA Note 1.125% Due 412712017 675,000.00 General Electric Capital Corp Note 2.3% Due 4/27/2017 2,650,000.00 US Treasury Note 1.375% Due 10131/2020 1,180,000.00 PepsiCo Inc Note 1.25% Due 4/30/2018 1,825,000.00 US Treasury Note 1.25% Due 4/30/2019 2,300,000.00 US Treasury Note 1.25% Due 10/31/2018 2,550,DDO.00 FHLMC Note 1.375% Due 5/112020 1,800,000.00 Apple Inc Note 1%Due 5131201a 675,000.00 Microsoft Callable Note Cont. 10/03/20 2% Due 111312020 975,000.00 FNMA Note 1.25% Due 5/6/2021 1,400,000.00 Praxair Note 1.25% Due 1117/2018 2,250,000.00 FHLMC Note 1.25% Due 5/12/2017 140,000.00 US Bancorp Callable Note Cont 1011512018 1,95% Due 11115/2018 1,100,000.00 Berkshire Hathaway Note 1.6%o Due 5/15/2017 360,000.00. Pfizer Inc. Note 1.1 % Due 511512017 1,030,000.00 Toyota Auto Receivables Owner 2015-A 1.12% Due 211512019 34,536.15 John Deere Owner Trust 2013-B A3 0.87% Due 8/16/2017 Page 33 45,066.79 0.00 0.00 1,750,000.00 675,000.00 0.00 0.00 0.00 0.00 2,823,144.65 0.00 0.00 0.00 0.00 0.00 2,250,000.00 0.00 1,100,000.00 360,000.00 50,855.38 2,475.13 701.66 12,375,00 18,700.00 9,843,75 7,762.50 18,218.75 7,375.00 11,406.25 14,375.00 175,449.08 17,531.25 9,000.00 5,750.00 6,093.75 8,750.00 14,062.50 1,365.00 8,800.00 1,980.00 418.11 7,19 45,768.45 12,375.00 18,700.00 1,759,843,75 682,762.50 18,218.75 7,375.00 11,406.25 14,375.00 2,598,593,73 17,531.25 9,000,0O 6,750,00 6,093.75 8,750.00 2,264,D62.50 1,365.00 1,108,800.00 361,980.00 5i,273.49 2,482.32 EXOMCMn Time: 7!3l2d15 12:02:20 PM 90/332 ;x. }° �Al, city of chino Hills Cash Flow Report Account #1 Q1SQ From 06/30/2016 05/1512017 Paydown 47788MAC4 1,010,000.00 John Deere Owner Trust 2016-A A3 0.00 1,144.67 1,144.67 1.36% Due 411512020 0511512017 Paydown 161571GC2 1,030,000.00 Chase CHAIT Pool #2013-A8 42,719.79 651.81 43,371.60 1.01 % Due 1011512018 0511512017 Paydown 43814HAC2 670,698.79 Honda Auto Receivables 2014-3 A3 47,431.41 101,71 47,533.12 0.88% Due 611512018 05/15/2017 Paydown 477877ADS 1,022,102.22 John Deere Owner Trust 2014-B A3 56,255,14 314.35 56,569.49 1.07% Due 11/15/2018 05115/2017 Paydown 89231TABS 503,1391.03 Toyota Auto Receivables Owner 2015-C 24,724.49 155.70 24,860.19 0.92% Due 2115P2018 05/18/2017 Paydown 43814NAB1 1,035,000.00 Honda Auto Receivables 2016-1 A2 43,058.25 510.74 43,568.99 1.01 % Due 6/18/2018 05/18/2017 Paydown 43814GAC4 428,822.56 Honda Auto Receivables 2014-2 A3 31,577.84 20.26 31,598.10 0.77% Due 311912018 05/19/2017 Interest 857477AV5 920,000.00 State Street Bank Note 0.00 8,970.00 8,970A0 1.95% Due 5/19/2021 05/20/2017 Interest 747525AD5 1,730,000.0O Qualcomm Inc Note 0.00 19,452.50 19,462.50 2.25% Due 5/20/2020 05/21/2017 Interest 3135GOWJ8 575,000.00 FNMA Note 0.00 2,515.63 2,515.53 0.875% Due 5/21/2018 05/21/2017 Paydown 43813NACO 1,255,000.00 Honda Auto Receivables 2015-2 A3 44,178.13 662.60 44,a40.73 1.04% Due 2/21/2019 05/3012017 Interest 3137EADG1 2,150,000.00 FHLMC Nate 0.00 18,812.50 18,812.50 1.75% Due 513012019 05/30/2017 Interest 3135GOF73 2,700,000.00 FNMA Note 0.00 20,250.00 20,250.00 1.5% Due 11/30/2020 05/31/2017 Interest 912828A34 1,800,000.00 US Treasury Note 0.00 11,250.00 11,250.00 1.25% Due 11/30/2018 05/31/2017 Interest 912828U84 2,000,000.00 US Treasury Nate 0.00 10,000.00 10,000.00 1 % Due 1113012019 0513112017 Interest 912828VF4 2,350,000.00 US Treasury Note 0.00 16,156.25 16,156.25 1.375% Due 5/31/2020 06/31/2017 Interest 912828VE7 1,900,000.00 US Treasury Note 0.00 9,500.00 9,500.00 1 % Due 5/31/2018 May 2017 4,053,275.56 195,236.52 4,248,512.08 0610512017 Interest 166764AA8 1,715,000.00 Chevron Corp Callable Note Cent 1115117 0.00 9,466,80 9,466.80 1.104% Due 121512017 06/0812017 Interest 313379DT3 2,600,000.00 FHLB Note 0.00 16,250.00 16,250.00 1.25% Due 6/8/2018 06109/2017 Maturity 313379FW4 2,250,000.00 FHLB Note 2,250,000.00 11,250.00 2,261,250.00 1 % Due 6/9/2017 Chandler Asset Management- CONFIDENTIAL Page 34 Execution Time:7tM016 12:02.20 PM 91 /332 IL. I City of Chino Hills Gash FIow Report a t X Account #10150 From 06/30/2016 06/12/2017 Interest 313383HU8 2,500,000,00 FHLB Nate 0.00 21,875,00 21,875.00 1.75% Due 6/12/2020 06/13/2017 Interest 24422ESF7 1,095,000.D0 John Deere Capital Corp Note 0.00 10,676.25 10,676.25 1,95% Due 1211312018 0611412017 interest 92826CAB8 1,300,000.00 Visa Inc Note 0.00 14,300.00 14,300.00 2.2% Due 12114/2020 06/15/2017 Interest 458140AL4 1,375,000.00 Intel Corp Note 0.00 9,281.25 9,281.25 1.35% Due 12115/2017 06/15/2017 Paydown 161579 GC2 1,03D,000.00 Chase CHAIT Pool #2013-A8 42,755.39 615.85 43,371.24 1.01 % Due 10/15/2018 0611512017 Paydown 43814HAC2 670,698.79 Honda Auto Receivables 2014-3 A3 46,244.22 66.93 46,311.15 0.88% Due 6/15/2018 06/15/2017 Paydown 477877AD6 1,022,102.22 Jahn Deere Owner Trust2014-BA3 54,296.70 264.19 54,560.89 1.07% Due 11/15/2018 06/1512017 Paydown 477879AC4 34,536.16 John Deere Owner Trust2013-BA3 2,477.50 5.39 2,482.89 0.87% Due 811512017 06/15/2017 Paydown 47788MAC4 1,010,000.00 John Deere Owner Trust 2016-A A3 0.00 1,144.67 1,144.67 1.36% Due 4/15/2020 06/15/2017 Paydown 89231TABG 503,991.03 Toyota Auto Receivables Owner2015-C 23,745,58 136.75 23,882.33 0.92% Due 2715/2018 0611512017 Paydown 89236WAC2 1,030,000.00 Toyota Auto Receivables Owner 2015-A 49,513.30 370.64 49,883.94 1.12% Due 211512019 06/18/2017 Paydown 43814NAB1 1,035,000.00 Honda Auto Receivables 2016-1 A2 43,102.02 474.50 43,576.52 1.01 % Due 6/1812018 06/20/2017 Interest 3135GORT2 1,775,000.00 FNMA Note 0.00 7,765.63 7,765.63 0.875% Due 12/20/2017 0612012017 Interest 3135GOZE6 1,900,000.00 FNMA Note 0.00 16,625.00 16,625.00 1.75% Due 612012019 06/21/2017 Paydown 43813NACO 1,265,000.00 Honda Auto Receivables 2015-2 A3 43,288.29 624.31 43,912.60 1.04% Due 2/21/2019 06122/2017 Interest 3136GOD75 2,625,000.00 FNMA Note 0.00 19,687.50 19,687.50 1.5%p Due 6/22/2020 Jun 2017 2,555,423.00 140,880.66 2,696,303.66 Total 19,040,023.30 _ 1,825,792.59 20,865,815.89 Is Chandler Asset Management- CONFIDENTIAL Page 35 Execution 7me: 7,W2016 12:02:20 PM 92/332