Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2017-166 2017-09-17
RESOLUTION NO. R2017-166 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending June 2017. BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS: Section 1. That the City Council hereby accepts the Quarterly Investment Report attached hereto as Exhibit "A" for the quarter ending June 2017. PASSED, APPROVED, AND ADOPTED this 31st day of August, A.D., 2017. :------- (;>10 '.' l 6--?.'1) TOM REID MAYOR ATTEST: �� R �. Y NiG ��RFIN R1A' , .."- =�. )� Y S" RETARY /\ APPROVED AS TO FORM: 04y,,:__ CIC--- DARRIN M. COKER CITY ATTORNEY Resolution No.R2017-166 Exhibit"A" City of Pearland Quarterly Investment ReportAi° March 31, 2017 to June 30, 2017 This report is prepared for the City of Pearland in accordance with Chapter 2256 of the Public Funds Investment Act (PFIA). Section2256.023 (a) of the PFIA states that "Not less than quarterly, the investment officer shall prepare and submit to the governing body of the entity a written report of the investment transactions for all funds covered by this chapter for the preceding reporting period." This report is signed by the Investment Officer and includes the disclosures required in the PFIA. Month Market Value Book Value Unrealized Gain/Loss YTM @ Cost Treasury 1 Year Interest Earned Days To Maturity 4/30/2017 187,700,925.94 187,764,723.06 -63,797.12 0.87 1.04 127,529.01 206 5/31/2017 189,019,161.75 189,085,342.45 -66,180.70 0.84 1.12 145,230.06 197 6130/2017 193,973,976.04 194,086,578.00 -112,601.96 0.83 1.20 128,547.54 199 Total/Average 190,231,354.58 190,312,214.50 -80,859.93 0.84 1.12 401,306.61 201 q _,/„...„_,/,.., .41 7 1Z--7 1 n Cynthia "earson, Direct•r of Financ Date Ric • erga_rd, Assistant Finance Director Date NrILLIC-IL- __V_sai_12 Carrie Ditta, Accounting Supervisor Date Page 1 of 39 ilk City of Pearland A Distribution by Security Type - Book Value Report Group: Pearland Begin Date:3/31/2017,End Date:6/30/2017 Security Type Allocation Book Value %of Portfolio Book Value %of Portfolio Security Type 3/31/2017 3/31/2017 6/30/2017 6/30/2017 Cash 73,173,803.56 34.82 66,907,441.46 34.47 Certificate Of Deposit 22,824,359.61 10.86 24,312,981.46 12.53 FAMC Bond 7,003,281.91 3.33 7,003,024.76 3.61 FFCB Bond 3,005,417.97 1.43 3,004,377.40 1.55 FHLB Bond 1,998,106.52 0.95 2,998,284.36 1.54 FHLMC Bond 6,988,749.20 3.33 6,989,756.74 3.60 FNMA Bond 6,025,347.17 2.87 6,024,429.09 3.10 Local Government Investment Pool 89,122,801.22 42.41 76,846,282.73 39.59 Total/Average 210,141,867.16 100.00 194,086,578.00 100.00 Portfolio Holdings as of 3/31/2017 Portfolio Holdings as of 6/30/2017 4 34.82%-Cash • 34,47%-Cash *.,. 10.86%-Certificate 0... 12.53%-Certificate 0,.. ! 3.33%-FAMC Bond 1 3.61%-FAMC Bond 1 1,43%-FFCB Bond . . 5 1.55%-FFCB Bond ... 'r 1 0.95%-FHLB Bond • 1.54%-FHLB Bond t 3,33%-FHLMC Bond 5 3.6%-FHLMC Bond 0 2.87%-FNMA Bond 0 3,1%-FNMA Bond ' 1 42.41%-Local Governm... '" I I)/39.59%-Local Governm... Page 2 of 39 Prepared by Rick Overgaard 1 of 1 City of Pearland libliballi Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date:3/31/2017,End Date:6/30/2017 Maturity Range Allocation Book Value %of Portfolio Book Value %of Portfolio Maturity Range 3/3112017 3/31/2017 6/30/2017 6/30/2017 0-1 Month 162,296,604.78 77.23 143,998,724.19 74.19 1-3 Months 750,540.63 0.36 247,818.98 0.13 3-6 Months 492,818.98 0.23 3,745,333.02 1.93 6-9 Months 3,492,913.81 1.66 1,496,507.80 0.77 9-12 Months 1,496,760.28 0.71 4,472,667.40 2.30 1-2 Years 17,456,940.28 8.31 15,971,313.14 8.23 2-3 Years 13,697,822.20 6.52 13,945,667.32 7.19 3-4 Years 3,747,695.55 1.78 5,482,195.99 2.82 4-5 Years 6,709,770.65 3.19 4,726,350.16 2.44 Total/Average 210,141,867.16 100.00 194,086,578.00 100.00 Portfolio Holdings 180,000 - 160,000 - 140,000 - 120,000 - c 100,000 • 3/31/2017 H 80,000 - 6/30/2017 60,000 - j 40,000 - I 20,000 - 00 — �! ---L MO ■o , I , 1 , , 0-1 Month 1-3 Months 3-6 Months 6-9 Months 9-12 Months 1-2 Years 2-3 Years 3-4 Years 4-5 Years Prepared by Rick Overgaard 1 of 1 Page 3 of 39 -'' ';; City of Pearland iiiiiaitigil Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date:7/31/2016,End Date:6/30/2017 Beginning BV+ Interest Earned Realized Investment Average Capital Annualized Treasury 1 Month Accrued Interest During Period-BV Gain/Loss-BV Income-By Base-BV TRR-BV TRR-BV Year 7/31/2016 139,949,748.50 36,916.57 0.00 36,916.57 138,413,205.92 0.03 0.32 0.51 8/31/2016 137,623,327.55 ,52,210.28 0.00 52,210.28 128,215,156.85 0.04 0.49 0.57 9/30/2016 127,074,407.98 45,269.94 0.00 45,269.94 124,198,023.89 0.04 0.44 0.59 10/31/2016 124,252,047.18 53,993.04 0.00 53,993.04 124,983,617.64 0.04 0.52 0.66 11/30/2016 125,514,349.05 72,654.72 0.00 72,654.72 185,519,756.88 0.04 0.47 0.74 12/31/2016 185,282,084.38 62,222.89 0.00 62,222.89 196,301,906.97 0.03 0.38 0.87 1/31/2017 209,834,304.42 76,360.08 0.00 76,360.08 216,802,198.68 0.04 0.42 0.83 2/28/2017 222,552,745.48 83,735.69 0.00 83,735.69 208,463.708.72 0.04 0.48 0.82 3/31/2017 198,473,194.13 113,663.11 0.00 113,663.11 204,238,039.18 0.06 0.67 1.01 4/30/2017 210,248,062.88 127,529.01 0.00 127,529.01 198,165,289.25 0.06 0.77 1.04 5/31/2017 187.893,317.51 145,230.06 0.00 145,230.06 188,445,011.54 0.08 0.93 1.12 6/30/2017 189,225,155.37 128,547.54 0.00 128,547.54 188,225,897.02 0.07 0.82 1.20 Annualized TRR-BV 1.20 is 1.00 - 0,80 - - j ��Portfolio ill illilltiliiii! 0,60 :I Treasury 1 0,40 Year • L, L . JJ11 07/2016 08/2016 09/2016 10/2016 11/2016 12/2016 01/2017 02/2017 03/2017 04/2017 05/2017 06/2017 Prepared by Rick Overgaard 1 of 1 Page 4 of 39 ti T a c-- O o .-- O '- co .- O O O '- O o .-- O .- O '- 0 CD - O N 3 7 O iv ,-- r-o2 i0 — O m o- bi m U iv o 0 O i- 7,-, 0 O O C O) a U U U U U U U a) U U U0 U0 0 U a) 0) U CD U U a) C CC CC CC C C CC CC CC CC CC cc C C O O O O O O O O O O O O O O O O O O O O O O O O m is Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z Z CC d' Til '0 U U Q O N 00 0 0O o 00 o co o 00 e p o OO --.9, OO o 00 0 �o{ O O ' 3 O ,- o O) O N.W O N O o O .- O .-• O O) O 6 O O O O C• C O C) O O O O o O O Cf O a A 0 Z. 7 Co n (0 0 a "' co 7 ccoo N co O n U0 CO c') O• U Ute') co .n-- U) 4 m co 'C O) n c7 N VQ 'C co O n co O O CO cD U) c0 O 'Q 6 N G I. aUO CU ' CO ' O W N C) D ^W _lc 10 M A V ro CO On LZ R UN ') N I ') CD >+ • C) 11— a T :�"' y� CD 0) CD 0) O CO 0 0) 0 C) O 0) 0 0) O o) O C) p 0) O CO O 0) L -CS ; O O O O O O O O go O O O O O O O O O O O O O O O o o O o 0 0 o O co O o C1 O o Cf O o CD 0 00 O 00 0 • C d o 0 0 0 0 0 o O o o 0 -0 U ca m C � s ® i R3 to CDg 1 co • .Q Q. o CD Q w CL 0 = v y.. G) 0 % S m I a a g g coo O O a) j o LO co 0 0 n n CO CO o 0 p) t0 CO N N n n 0 0 0 0 n N- )O U) 0) CO c') O cp O L ca "4 D O U) 6 UN 6 U) I 'i M a 0 O O V "t OO � n 7 7 N N Q, > > OifOUWO OCON- N D co . Q 0n car" CU83 QO O 7 0 '0 N N N O) O) 0 C O O N N 7 o) U 7 ' O W W W N N 7 ' D D Y NhN 01 CT) m0) til M LID N cD On n OO v o N N M N- 6 .Q • cc) N 0) cc") CD CD U = Cr CD O W 4.-. = V O O)O C') a) co C) n a) co a) 1 co a) co a) CO C) CD O) co a) co O) co D) O O O o O 0 co O 0 o O co co O co co O O O 0 t O 8 N N N N O O O O N N N N N N O I O N O O O N O O o 6O a; N a Clf7 N I M M c'9 c) co ch C7 LL U t` O` (a to i N On Cn Ul i0 In U i a C CU O ca. I co co N- o O n ) co co N 0 2 3 :D 2Sri 4) co CD (0 sr D n C- N(D O 6 4 m c0 CD O v C) N O 0 p N Oncv c,i QS C) co 6 D cD n n tD U) C C) A C') N C') cD g LL 'D co so _ ,= L = •L L P UN 0 0 N 0 0 U) N 0 N a) U U CU U U U J U U (� 0 a a a a a a a a a a a L a) co U a) U U U co a) U U o o a) a) CC a) a) 0 co a) o co _c m 3 3 3 3 3 3 3 3 3 3 3 iE U CO CO (n (n CO (1) (n (.0 (4) CO CO >, C O O a O a O d O d O 0. O D_ O 0. O d o a O d O d .n C o) C) W L w COw 2) w CD w ro W w w w W Q w a� co co W CO W N W ca yW ra W L N LLO N 0 N N } y N 0 vo N y 0 cio no fCCC CC LOL O CC ISL O Iii CC CL O li O LL N LL O LL CC Iii CC LCL 7) CL ` 0 U O 5 5 5 5 5 5 5 5 5 5 'S 5 > 5 5 5 5 5 5 5 5 a . City of Pearland 4.9 Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM to Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 5/31/2006 74,088.29 100.00 74,088.29 0.04% None WFSWEEP 74,088.29 0.09 74,088.29 0.09 0.00 None 0 - Wells Fargo Sweep Cash 5/31/2006 112,930.66 100.00 112,930.66 0.06% None 1 WFSWEEP 112,930.66 0.09 112,930.66 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 80,822.31 100.00 80,822.31 0.04% None 1 WFSWEEP 80,822.31 0.09 80,822.31 0.09 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 84,885.43 100.00 84,685.43 0.04% None 1 WFSWEEP 84,685.43 0.09 84,885.43 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 7,982,740.56 100.00 7,962,740.56 4.1% None 1 WFSWEEP 7.962,740.56 0.09 7,962,740.58 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 66,272.42 100.00 66,272.42 0.03% None 1 WFSWEEP 66,272.42 0.09 66,272.42 0.09 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,665,060.79 100.00 2,665,060.79 1.37% None 1 WFSWEEP 2,665,060.79 0.09 2.665,060.79 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 445,127.23 100.00 445,127.23 0.23% None WFSWEEP 445,127.23 0.09 445,127.23 0.09 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 2,512,234.62 100.00 2,512,234.62 1.29% None , WFSWEEP 2,512,234.82 0.09 2,512,234.62 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 3,591,325.00 100.00 3,591,325.00 1.85% None 1 WFSWEEP 3,591,325.00 0.09 3,591,325.00 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 274,756.24 100.00 274,756.24 0.14% None 1 WFSWEEP 274,756.24 0.09 274,756.24 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 233,466.56 100.00 233,468.56 0.12% None 1 WFSWEEP 233,466.56 0.09 233,466.56 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 600,925.68 100.00 600,925.68 0.31% None 1 WFSWEEP 600,925.68 0.09 600,925.68 0.09 0.00 None 0 Prepared by Rick Overgaard 2 of 15 Page 6 of 39 City of Pearland 't 4-889 Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM CaD,Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 5/31/2006 -5,937.56 100.00 -5,937.56 0% None 1 WFSWEEP -5,937.56 0.09 -5,937.56 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 10,742.28 100.00 10,742.28 0.01% None 1 WFSWEEP 10,742.28 0.09 10,742.28 0.09 0.00 None 0 Wells Fargo Sweep Cash 11/1512015 -86,589.20 100.00 -86,589.20 -0.04% None 1 WFSWEEP -86,589.20 0.09 -86,589.20 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,959,802.42 100.00 2.959,802.42 1.52% None 1 WFSWEEP 2,959,802.42 0.09 2.959,802.42 0.09 0.00 None 0 Wells Fargo Sweep Cash 9/15/2009 23,734.36 100.00 23,734.36 0.01% None 1 WFSWEEP 23,734.36 0.09 23,734.36 0.09 0.00 None 0 Wells Fargo Sweep Cash 9/1/2007 81,163.41 100.00 81,163.41 0.04% None 1 WFSWEEP 81,163.41 0.09 81,163.41 0.09 0.00 None 0 Wells Fargo Sweep Cash 12/1/2009 -370.34 100.00 -370.34 0% None 1 WFSWEEP -370.34 0.09 -370.34 0.09 0.00 None 0 Wells Fargo Sweep Cash 6/30/2006 182,039.45 100.00 182,039.45 0.09% None 1 WFSWEEP 182,039.45 0.09 182,039.45 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,805,366.09 100.00 1,805,366.09 0.93% None 1 WFSWEEP 1,805,366.09 0.09 1,805,366.09 0.09 0.00 None 0 Wells Fargo Sweep Cash 12/1/2006 -616,400.79 100.00 -616,400.79 -0.32% None 1 WFSWEEP -616,400.79 0.09 -616,400.79 0.09 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 10,002,416.73 100.00 10,002,416.73 5.15% None 1 WF5875 10,002,416.73 0.09 10,002,416.73 0.09 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 10,846,369.30 100.00 10,846,369.30 5.59% None 1 WF4094 10,846,369.30 0.05 10,846,369.30 0.05 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 5,106,603.95 100.00 5,106,603.95 2.63% None 1 WF4102 5,106,603.95 0.05 5,106,603.95 0.05 0.00 None 0 Prepared by Rick Overgaard 3 of 15 Page 7 of 39 • % ' City of Pearland t9 Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value Portfolio Credit Rating Days To Call/Maturity Face Amount! CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo TWDB Cash 3/15/2017 11,763,233.16 100.00 11,763,233.16 6.06% None 1 WF5883 11,763,233.16 0.09 11,763,233.16 0.09 0.00 None 0 66,907,441.46 66,907,441.46 34.44% 1 Sub Total C S I 66,907,441.46 0.08 66,907,441.46 0.08 0.00 0 Certificate Of Deposit 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 97.28 241,265.06 0.13% None 1302 33625CAZ2 248,000.00 1.10 248,000.00 1.89 59.79 -6,734.94 None 3.49 1st Source Bank 1.5 11/18/2019 4/17/2015 248,000.00 100.51 249,252.65 0.13% None 871 33646CEQ3 248,000.00 1.50 248,000.00 1.28 754.19 1,252.65 None 2.35 Allegiance Bank 0.6 9/13/2017 9/13/2016 247,818.98 100.00 247,818.98 0.13% None 75 2611523C 247,818.98 0.60 247,818.98 0.60 0.00 0.00 None 0.2 Ally Bank Midvale Utah 1.8 6/29/2020 6/29/2017 248,000.00 100.02 248,046.62 0.13% None 1095 02006L3U5 248,000.00 1.80 248,000.00 1.79 12.23 46.62 None 2.93 Alma Bank 1.3512/24/2020 6/24/2016 248,000.00 98.23 243,606.93 0.13% None 1273 020080BB2 248,000.00 1.35 248,000.00 1.88 55.04 4,393.07 None 3.4 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 98.18 243,441.76 0.13% None 1473 02554BCM1 248,000.00 1.35 248,000.00 1.82 174.28 . 4,558.24 None 3.92 Bank Leumi USA 1.3 2(26(2020 3/3/2016 248,000.00 100.33 248,817.41 0.13% None 971 063248FH6 248,000.00 1.30 248,000.00 1.17 1,095.28 817.41 None 2.61 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 98.60 244,525.52 0.13% None 1461 063847AL1 248,000.00 1.40 248,000.00 1.76 0.00 -3,474.48 None 3.89 Bank of the Pacific 1.25 7/30/2018 1/29/2015 248,000.00 99.87 247,675.37 0.13% None 395 06425BBN8 248,000.00 1.25 248,000.00 1.37 1,282.47 -324.63 None 1.07 Bank United 1.2 11/21/2017 11/21/2014 248,000.00 100.03 248,063.49 0.13% None 144 066519AF6 248,000.00 1.20 248,000.00 1.13 326.14 63.49 None 0.39 Prepared by Rick Overgaard 4 of 15 Page 8 of 39 - " ' , City of Pearland iks ly Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 101.32 251,261.70 0.13% None 1183 06610QCV1 248,000.00 1.80 248,000.00 1.38 61.15 3,261.70 None 3.15 Bankwest,Inc.1.5 1/3/2020 3/4/2015 248,000.00 99.49 246,737.93 0.13% None 917 06652CFA4 248.000.00 1.50 248,000.00 1.71 275.18 -1,262.07 None 2.46 BARCLAYS BANK DELAWARE 1.95 5/6/2014 248,000.00 100.75 249,871.66 0.13% None 676 5/7/2019 06740KGU5 248,000.00 1.95 248,000.00 1.54 715.46 1,871.66 None 1.82 Belmont Savings Bank 1.8510/23/2019 12/23/2014 248,000.00 100.79 249,967.88 0.13% None 845 080515600 248,000.00 1.85 248.000.00 1.50 87.99 1,967.88 None 2.28 BMO Hams Bank 1.05 6/22/2018 6/23/2016 248,000.00 99.70 247,245.34 0.13% None 357 05581 WHF5 248,000.00 1.05 248,000.00 1.36 49.94 -754.66 None 0.98 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 100.55 249,366.48 0.13% None 1085 05580ABX1 248,000.00 2.10 248,000.00 1.91 156.95 1,366.48 None 2.89 Border State Bank 1.4 6/30/2021 6130/2016 248,000.00 97.84 242,632.78 0.13% None 1461 099703EF3 248,000.00 1.40 248,000.00 1.96 0.00 -5,367.22 None 3.89 Brickell Bank Miami FL 1.65 10/28/2019 6/27/2017 248,000.00 99.94 247,861.37 0.13% None 850 10801DAG6 248,000.00 1.65 248,000.00 1.68 33.63 -138.63 None 2.28 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 99.39 246,483.98 0.13% None 1454 12325EHU9 248.000.00 1.80 248,000.00 1.96 85.61 -1,516.02 None 3.84 Capital Bank Little Rock 1.35 3/22/2019 9/23/2015 248,000.00 100.59 249,468.16 0.13% None 630 139797FL3 248,000.00 1.35 248,000.00 1.00 73.38 1,468.16 None 1.71 Capital One Bank USA 1.1 11/19/2019 11/19/2014 248,000.00 100.94 250,343.35 0.13% None 872 1404200X1 248,000.00 1.10 248,000.00 0.70 313.91 2,343.35 None 2.36 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 101.33 251,304.60 0.13% None 1183 14042RAB7 248,000.00 2.30 248,000.00 1.87 1,515.86 3,304.60 None 3.12 Prepared by Rick Overgaard 5 of 15 Page 9 of 39 City of Pearland iiklthiNA Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 98.54 244,381.68 0.13% None 1123 144153AW3 248,000.00 1.10 248,000.00 1.59 22.42 -3,618.32 None 3.02 CDARS 0.7 12/13/2018 12/15/2016 500,000.00 100.00 500,000.00 028% None 531 1019720221 500,000.00 0.70 500,000.00 0.70 .1,708,85 0.00 None 1.45 CDARS 0.9 6/14/2018 6/16/2016 500,000.00 100.00 500,000.00 0.26% None 349 1019145928 500,000.00 0.90 500,000.00 0.90 2,194.52 0.00 None 0.95 CDARS 1.05 6/15/2019 6/15/2017 500,000.00 100.00 500,000.00 0.26% None 715 CDARS081517 500,000.00 1.05 500,000.00 1.05 215.75 0.00 None 3.96 - Cedar Rapids Bank Sam ;Trust 1.5 P 1/30/2015 248,000.00 101.07 250,654.59 0.13% None 852 10/30/2019 150517CJ7 248,000.00 1.50 248,000.00 1.04 295.56 2,654.59 None 2.29 Charter Bank 1.7 7125/2020 225/2015 248,000.00 99.91 247,788.21 0.13% None 970 1611648E7 248,000.00 1.70 248,000.00 1.73 57.75 -211.79 None 2.6 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248,000.00 100.97 250,401.63 0.13% None 872 17284C3Z5 248,000.00 2.10 248,000.00 1.68 59928 2,401.63 None 2.33 Citizens State Bank Clayton 1.35 4/30/2019 9/30/2015 248,000.00 100.61 249,523.96 0.13% None 669 1766886S7 248,000.00 1.35 248,000.00 1.01 0.00 1,523.96 None 1.81 Comenity Capital Bank 1.7 5/28/2018 11/26/2014 248,000.00 100.16 248,389.86 0.13% None 332 20033AJL1 248,000.00 1.70 248,000.00 1.53 46.20 389.86 None 0.9 Commercial Bank Ala Mich 1.5 3/29/2019 6/30/2015 248,000.00 99.92 247,794.66 0.13% None 637 201282GV6 248,000.00 1.50 248,000.00 1.55 10.19 -205.34 None 1.73 Community Bank Pasadena 1.5 6/3012021 6/3012016 248,000.00 98.60 244,532.46 0.13% None 1461 203507BG2 248,000.00 1.50 248,000.00 1.86 0.00 -3,467.54 None 3.88 Community Bankers':Bank 1.4 6/30/2016 248,000.00 98.60 244,525.52 0.13% None 1461 6/30/2021 20361L8R4 248,000.00 1.40 248,000.00 1.76 0.00 -3,474.48 None 3.89 Prepared by Rick Overgaard 6 of 15 Page 10 of 39 - "l' , City of Pearland iviwaLaigiPortfolio Holdings by Security Type Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Community National Bank Interest 1.25 4/4/2014 248,000.00 100.01 248,017.36 0.13% None 278 4/4/2018 20375WAM6 248,000.00 1.25 248,000.00 1.24 738.90 17.36 None 0.76 ConnectOne Bank 1.55 7/30/2018 1/30/2014 248,000.00 100.44 249,091.94 0.13% None 395 20786AAM7 248,000.00 1.55 248,000.00 1.14 0.00 1,091.94 None 1.08 Continental Bank 1.25 5/25/2018 11/26/2014 248,000.00 99.95 247,876.74 0.13% None 329 211163EN6 248,000.00 1.25 248,000.00 1.31 305.75 -123.26 None 0.9 Discover Bank 2 2/25/2020 2/25/2015 248,000.00 100.69 249,708.72 0.13% None 970 254672JA7 248,000.00 2.00 248,000.00 1.73 1,698.63 1,708.72 None 2.58 Eaglebank Bethesda 1.15 12/10/2018 3/9/2016 248,000.00 99.93 247,826.90 0.13% None 528 27002YCV6 248,000.00 1.15 248,000.00 1.20 164.09 -173.10 None 1.43 EVB Tappa Hannock VA 1.6 9/25/2019 9/25/2015 248,000.00 100.82 250,029.63 0.13% None 817 26927ABK7 248,000.00 1.60 248.000.00 1.23 1,054.51 2,029.63 None 2.2 Evergreen Bank 1.2 6/29/2018 6/29/2015 248,000.00 99.90 247,757.46 0.13% None 364 300185CY9 248,000.00 1.20 248,000.00 1.30 8.15 -242.54 None 0.99 Exchange Bank NEB 1.05 1/21/2020 7/20/2016 248,000.00 98.33 243,868.82 0.13% None 935 301074CH1 248,000.00 1.05 248,000.00 1.72 71.34 -4,131.18 None 2.52 Fahey Banking 1.1 6/28/2019 3/29/2016 248,000.00 99.91 247,782.01 0.13% None 728 303117CC7 248,000.00 1.10 248,000.00 1.15 14.95 -217.99 None 1.97 Farmers&Merchants Bank 1.45 4/25/2014 248,000.00 100.03 248,081.34 0.13% None 117 9/25/2018-14 308862DD0 248,000.00 1.45 248,000.00 1.42 49.26 81.34 None 1.23 FIRST BANK HIGHLAND PARK 1.85 5/7/2014 248,000.00 100.09 248,230.64 0.13% None 38 5/7/2019-14 319141BL0 248,000.00 1.85 248,000.00 1.80 678.77 230.64 Nono 1.83 First Bank McComb MS 1.5 2/28/2019 6/30/2015 248,000.00 100.20 248,502.94 0.13% None 608 319234AJ9 248,000.00 1.50 248,000.00 1.38 20.38 502.94 None 1.64 Prepared by Rick Overgaard 7 of 15 Page 11 of 39 -,' , City of Pearland iak9 Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM(al Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity First Business Bank 1.7 6/30/2020 9/30/2015 248,000.00 99.73 247,319.98 0.13% None 1096 31938QP40 248,000.00 1.70 248,000.00 1.79 1,062.68 -680.02 None 2.92 First Capital Bank 1.4 8/6/2019 4/6/2015 248,000.00 100.36 248,904.21 0.13% None 767 31944F0K5 248,000.00 1.40 248,000.00 1.22 228.30 904.21 None 2.07 First Eagle National Bank 1.45 11/21/2018 11/21/2014 248,000.00 100.24 248,599.42 0.13% None 509 32008JAM5 248,000.00 1,45 248,000.00 1.27 394.08 599.42 None 1.38 First Financial NW 1.3510/30/2019 10/30/2015 248,000.00 99.25 246,151.90 0.13% None 852 32022MAF5 248,000.00 1.35 248,000.00 1.68 0.00 -1,848.10 None 2.3 First Intl Bank&Trust 1.6 1/16/2020 10/18/2015 248,000.00 99.72 247,299.40 0.13% None 930 32057GAE9 248,000.00 1.60 248,000.00 1.71 152.20 -700.80 None 2.49 First Mid-III Bank&Trust 0.9 1/2/2018 6/30/2016 248,000.00 99.85 247,617.83 0.13% None 186 32086RBK5 248,000.00 0.90 248,000.00 1.20 0.00 -382.17 None 0.51 First National Bank 1.6 3/19/2018 9/18/2013 248,000.00 100.40 248,984.81 0.13% None 262 C032115CBE7 248,000.00 1.60 248,000.00 1.05 119.58 984.81 None 0.72 First National Bank of America 1.25 7/15/2016 248,000.00 97.19 241,043.10 0.13% None 1476 7/15/2021 32110YHMO 248,000.00 1.25 248,000.00 1.98 1,409.86 -6,956.90 None 3.93 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 98.60 244,532.46 0.13% None 1461 36198JCC6 248,000.00 1.50 248,000.00 1.86 0.00 -3,467.54 None 3.88 Goldman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 100.69 249,708.72 0.13% None 970 38148J1.13 248,000.00 2.00 248,000.00 1.73 1,698.63 1,708.72 None 2.58 GUARANTY 88amp;T 1.35 5/29/2018 5/29/2014 248,000.00 100.04 248,091.02 0.13% None 333 4008208J4 248,000.00 1.35 248,000.00 1.31 9.17 91.02 None 0.91 Gulf Coast Bank&:Trust 1.3 7/15/2021- 7/15/2016 248,000.00 98.19 243,502.02 0.13% None 15 17 402194EX8 248,000.00 1.30 248,000.00 1.77 132.49 -4,497.98 None 3.94 Prepared by Rick Overgaard 8 of 15 Page 12 of 39 City of Pearland 44,1aLQ Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity JP Morgan Chase Bk NA Columbus 2.1 2/15/2017 245,000.00 100.58 246,424.68 0.13% None 15 2115/2021-17 48126XVW2 245,000.00 2.10 245,000.00 1.93 211.44 1,424.68 None 3.49 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 98.60 244,525.52 0.13% None 1461 53362LAB0 248,000.00 1.40 248,000.00 1.76 275.86 -3,474.48 None 3.89 Luana Savings Bank 1.25 6/19/2018 12/19/2014 248,000.00 99.92 247,792.92 0.13% None 354 549103QQ5 248,000.00 1.25 248,000.00 1.34 93.42 -207.08 None 0.97 Machias Savings Bank 1.65 2/612020 2/6/2015 248,000.00 101.19 250,958.89 0.13% None 951 554479DS1 248,000.00 1.65 248,000.00 1.18 269.06 2,958.89 None 2.54 Mahopac Bank 1.45 7/30/2019 1/30/2015 248,000.00 100.90 250,240.18 0.13% None 760 560160AQ6 248,000.00 1.45 248,000.00 1.01 1,487.66 2,240.18 None 2.05 Manufacturers&:Traders Trust 1.2 6/24/2015 248,000.00 99.95 247,868.56 0.13% None 360 6;25/2018 564759QV3 248,000.00 1.20 248,000.00 1.25 48.92 -131.44 None 0.98 Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 99.57 246,927.90 0.13% None 1460 56817TAB7 248,000.00 1.80 248,000.00 1.91 12.23 -1,072.10 None 3.86 Martin Business Bank 1.25 12/27/2019 6/29/2016 248,000.00 98.97 245,436.92 0.13% None 910 57116AMC9 248,000.00 1.25 248,000.00 1.67 8.49 -2,563.08 None 2.45 MB Financial Bank 1.1 3/18/2019 3/18/2016 248,000.00 99.91 247,788.46 0.13% None 626 55266CQU3 248,000.00 1.10 248,000.00 1.15 89.69 -211.54 None 1.7 Moody National Bank 0.5 11/30/2017 5/30/2017 251,162.48 100.00 251,162.48 0.13% None 153 7130F 251,162.48 0.50 251,162.48 0.50 106.66 0.00 None 0.42 National Bank Commerce Superior 1.25 7/15/2016 248,000.00 98.19 243,502.02 0.13% None 15 7/15/2021-17 633368EB7 248,000.00 1.25 248,000.00 1.72 127.40 -4,497.98 None 3.94 Nebraskaland National Bank 1.2 9/25/2018 9/25/2015 248,000.00 100.35 248,873.21 0.13% None 452 63970QFC5 248,000.00 1.20 248,000.00 0.91 40.77 873.21 None 1.23 Prepared by Rick Overgaard 9 of 15 Page 13 of 39 -* City of Pearland ladillik49 Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Markel Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Northern Bank&Trust MA 1.1 7/1212016 248,000.00 99.14 245,861.25 0.13% None 12 7112/2019-17 66476QBH0 248,000.00 1.10 248,000.00 1.53 590.44 -2,138.75 None 2.01 Northwest Bank Boise Idaho 1.5 1/10/2019 4/10/2014 248,000.00 100.62 249,534.62 0.13% None 559 66736M01 248,000.00 1.50 248,000.00 1.09 203.84 1,534.62 None 1.51 OLDTOWN BANK 1.2 5/7/2018 6/6/2014 248,000.00 100.19 248,480.38 0.13% None 311 6805408B6 248,000.00 1.20 248,000.00 0.97 195.68 480.38 None 0.85 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 98.73 244,853.38 0.13% None 1096 69413CFD6 248,000.00 1.25 248,000.00 1.68 0.00 -3,146.82 None 2.95 Parkside Finl Bank&Trust 1.3 7/18/2016 248,000.00 98.17 243,457.88 0.13% None 18 7/19/2021-17 70147ABX1 248,000.00 1.30 248,000.00 1.77 105.99 -4,542.12 None 3.95 Partners Bank 1.5 9/30/2019 3/30/2015 248,000.00 100.64 249,592.66 0.13°%0 None 822 70212YAR3 248,000.00 1.50 248,000.00 1.21 0.00 1,592.66 None 2.21 Pearland State Bank 0.15 7/24/2017 7/24/2016 245,000.00 100.00 245,000.00 0.13% None 24 700013947A 245,000.00 0.15 245,000.00 0.15 343.34 0.00 None 0.07 Peoples United Bank 1.911/19/2019 11/19/2014 248,000.00 100.92 250,292.02 0.13% None 872 71270QKM7 248,000.00 1.90 248,000.00 1.50 542.20 2,292.02 None 2.34 Portage County Bank 1.4 6/24/2021 6124/2016 248,000.00 98.62 244,565.70 0.13% None 1455 73565NBQ5 248,000.00 1,40 248,000.00 1,76 57.07 -3,434.30 None 3.87 Quantum National Bank 1.2 9/18/2019-16 3/18/2016 248,000.00 99.18 245,974.34 0.13% None 80 74765.J ETI 248,000.00 1.20 248,000.00 1.58 97.84 -2,025.66 None 2.19 Revere Bank 1.35 8/29/2018 12/3012014 248,000.00 100.07 248,175.58 0.13% None 364 781402AU0 248,000.00 1.35 248,000.00 1.28 9.17 175.58 None 0.99 Sallie Mae Bank 2.15 11/19/2019 11/19/2014 248,000.00 100.94 250,341.62 0.13% None 872 795450VC6 248,000.00 2.15 248,000.00 1.74 613.55 2,341.82 None 2.33 Prepared by Rick Overgaard 10 of 15 Page 14 of 39 City of Pearland rr~c►tc Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM Cost Book Value YTM L Market Accrued Interest Unre.GainlLoss Credit Rating Duration To Maturity Seiling State Bank OK 1.55 7/7/2021-17 7/7/2016 248,000.00 98.62 244,569.17 0.13% None 7 816050AA6 248,000.00 1.55 248,000.00 1.91 242.22 -3,430.83 None 3.89 Signature Bank 1.35 3/28/2019 9/29/2015 248,000.00 100.57 249,419.06 0.13% None 636 82669LFU2 248,000.00 1.35 248,000.00 1.02 18.35 1,419.06 None 1.72 Silvergate Bank 1 6/29/2018-16 6/29/2016 248,000.00 99.70 247,267.90 0.13% None 28 828373FE5 248.000.00 1.00 248,000.00 1.30 6.79 -732.10 None 0.99 Summit Community Bank Moorefield WV 6/30/2017 248,000.00 99.87 247,685.54 0.13% None 728 1.55 6/28/2019 86604XLX2 248,000.00 1.55 248,000.00 1.62 0.00 -314.46 None 1.97 Trust Atlantic Bank 1.45 12/6/2017 11/6/2013 248,000.00 100.21 248,525.76 0.13% None 159 89835FJC5 248,000.00 1.45 248,000.00 0.96 236.45 525.76 None 0.43 Umpqua Bank Roseburg OR 1.6 6/28/2019 6/30/2017 248,000.00 99.97 247,928.82 0.13% None 728 90421MAX1 248,000.00 1.60 248,000.00 1.61 0.00 -71.18 None 1.97 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 101.31 251,236.90 0.13% None 1218 91330ABC0 248,000.00 1.65 248,000.00 1.25 0.00 3,236.90 None 3.25 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 98.17 243,452.92 0.13% None 1473 92834CBW1 248,000.00 1.30 248,000.00 1.77 1,501.59 -4,547.08 None 3.92 Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 99.17 245,931.68 0.13% None 31 938828AC4 248,000.00 1.50 248,000.00 1.73 0.00 -2,068.32 None 3.65 Washington Trust Co 1.4 6/15/2018 12/15/2014 248,000.00 100.09 248,234.36 0.13% None 350 940637GU9 248,000.00 1.40 248,000.00 1.30 142.68 234.36 None 0.96 Webster Bank NA 1.9 2/12/2019 2/12/2014 248,000.00 100.61 249,518.50 0.13% None 592 94768NJM7 248,000.00 1.90 248,000.00 1.52 1,781.52 1,518.50 None 1.59 Welch State Bank 1.3 10/1/2018 9/30/2015 248,000.00 100.34 248,839.98 0.13% None 458 949095AU7 248,000.00 1.30 248,000.00 1.03 256.15 839.98 None 1.24 Prepared by Rick Overgaard 11 of 15 Page 15 of 39 • City of Pearland ll9 Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 98.64 244,636.13 0.13% None 1448 9497485W3 248,000.00 1.75 248.000.00 2.11 154.58 -3,363.87 None 3.63 24,312,981.6 24,266,458.85 12.74% 704 Sub Total Certificate Of Deposit 24,312,981.46 1.40 24,312,981.46 1.42 32,159.75 -46,522.61 2.24 FAMC Bond FAMC 1.58/2212019 2/22/2017 1,000,000.00 99.85 998,541.00 0.52% S&P-M+ 783 3132X0PV7 1,000,000.00 1.50 1,000,000.00 1.57 5,333.33 -1,459.00 Moodys-Aaa 2.11 FAMC 1.58/22/2019 2/22/2017 2,001,700.00 99.85 1,997,082.00 1.03% S&P-AA+ 783 3132X0PV7 2,000,000.00 1.47 2,001,458.22 1.57 10,668.67 -4,376.22 Moodys-Aaa 2.11 FAMC 1.5 8/22/2019 2/2212017 1,000,000.00 99.85 998,541,00 0.52% S&P-AA+ 783 3132X0PV7 1,000,000.00 1.50 1,000,000.00 1.57 5,333.33 -1,459.00 Moodys-Aaa 2.11 FAMC 1.8752/242020 2124/2017 1,001,200.00 100.05 1,000,501.00 0.52% Moody5-Aaa 969 3132X0PW5 1,000,000.00 1.63 1,001,060.00 1.66 5,862.50 -559.00 S&P-M+ 2.59 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 100.05 1,000,501.00 0.52% Moodys-Aaa 969 3132X0PW5 1,000,000.00 1.63 1,001,060.00 1.66 5,862.50 -559.00 S&P-AA+ 2.59 FAMC 1.72 10/3/2018 12/1W2013 997,890.00 100.37 1,003,663.00 0.51% Moodys-Aaa 460 31315P5A3 1,000,000.00 1.77 999,446.54 1.43 4,156.67 4,216.46 S&P-AA+ 1.25 7,001,990.00 6,998,829.00 3.62% 790 Sub Total FAMC Bond 7,000,000.00 1.57 7,003,024.76 1.57 37,215.00 .4,195.76 2.12 FFCB Bond FFCB 1.3412/292017 1/29/2014 1,004,000.00 100.11 1,001,058.00 0.52% Moodys-Aaa 182 3133EDE99 1,000,000.00 1.24 1,000,507.80 1.13 37.22 550.20 S&P-AA+ 0.5 FFCB 1.5 1/28/2019 5/28/2014 1,000,000.00 100.16 1,001,613.00 0.52% Moodys-Aaa 577 3133EDMF6 1,000,000.00 1.50 1,000,000.00 1.40 6,333.33 1,813.00 S&P-M+ 1.56 - FFCB 1.95 9/17/2018 1/29/2014 1,014,770.00 100.59 1,005,944.00 0.52% MoodY s-Aaa 444 3133ED2C5 1,000.000.00 1.62 1,003,889.80 1.45 5,579.17 2,07440 S&P-AA+ 1.2 Prepared by Rick Overgaard 12 of 15 Page 16 of 39 City of Pearland & 9 Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM L Cost Book Value YTM(MMarket Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 3,018,770.00 3,008,615.00 1.56% 401 Sub Total FFCB Bond 3,000,000.00 1.45 3,004,377.40 1.33 11,949.72 4,237.60 1.09 FHLB Bond FHLB 1 9/2612019 9/22/2016 997,430.00 98.98 989,842.00 0.51% Moodys-Aaa 818 3130A9EP2 1,000,000.00 1.09 998,089.10 1.46 2,611.11 -8,247.10 S&P-AA+ 2.21 FHLB 1.456/28/2019-17 6/28/2017 1,000,000.00 99.88 998,848.00 0.52% Moodys-Aaa 90 3130ABHR0 1,000,000.00 1.45 1,000,000.00 1.51 80.56 -1,152.00 S&P-AA+ 1.97 FHLB 1.75 12/14/2018 12/16/2013 1,000,670.00 100.54 1,005,388.00 0.52% Moodys-Aaa 532 3133768R5 1,000,000.00 1.74 1,000,195.26 1.38 777.78 5,192.74 S&P-AA+ 1.44 2,998,100.00 2,994,078.00 1.55% 480 Sub Total FHLB Bond 3,000,000.00 1.42 2,998,284.36 1.45 3,469.45 -4,206.36 1.87 FHLMC Bond FHLMC 1 9/29/2017 1/29/2014 994,150.00 99.98 999,765.00 0.52% Moodys-Aaa 91 3137EADL0 1,000,000.00 1.16 999,605.57 1.09 2,527.78 159.43 S&P-AA+ 0.25 FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 97.27 972,686.00 0.51% Moodys-Aaa 1504 3137EAEC9 1,000,000.00 1.37 990,350.16 1.82 4,156.25 -17,664.16 S&P-AA+ 4.02 FHLMC 1.35 12/17/2018-15 6/19/2015 999,525.00 99.90 998,975.00 0.52% S&P-AA+ 535 3134G6S95 1,000,000.00 1.36 999,801.01 1.42 487.50 -826.01 Moodys-Aaa 1.45 FHLMC 1.42 3/29/2019-17 3/29/2017 2,000,000.00 99.83 1,996,568.00 1.03% S&P-AA+ 91 3134GA6G4 2,000,000.00 1.42 2,000,000.00 1.52 7,178.89 -3,432.00 Moodys-Aaa 1.73 FHLMC 2 12113/2021-17 12/13/2016 1,000,000.00 99.07 990,660.00 0.52% S&P-AA+ 75 3134GAZD9 1,000,000.00 2.00 1,000,000.00 2.22 944.44 -9,340.00 None 4.28 FHLMC 2 12/13/2021-17 12/13/2016 1,000,000.00 99.07 990,660.00 0.52% S&P-AA+ 75 3134GAZD9 1,000,000.00 2.00 1,000,000.00 2.22 944.44 -9,340.00 None 4.28 6,982,215.00 6,949,314.00 3.62% 350 Sub Total FHLMC Bond 7,000,000.00 1.53 6,989,756.74 1.69 16,239.30 -40,442.74 2.53 FNMA Bond Prepared by Rick Overgaard 13 of 15 Page 17 of 39 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2017 Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSir' Shares YTM ii?Cost Book Value VIM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FNMA 0.8751026/2017 5/21/2014 995,150.00 99.93 999,294.00 0.51% Moodys-Aaa 118 3135GOPQ0 1.000.000.00 1.02 999,544.45 1.09 1.555.56 -250.45 SSP-AA+ 0.32 FNMA 0.87512/20/2017 5/21/2014 992,573.21 99.87 998,650.00 0.51% Moodys-Aaa 173 3135GORT2 1,000,000.00 1.09 999,020.52 1.16 243.06 -370.52 S&P-AA+ 0.47 FNMA 0.875 5/21/2018 5/21/2014 985,050.00 99.66 996,581.00 0.51% Moodys-Aaa 325 3135G0W38 1,000,000.00 1.26 996,667.40 1.26 947.92 -86.40 S&P-AA+ 0.89 - FNMA 1.375 3/13/2019.16 9/22/2016 1,009,560.00 99.93 999,323.00 0.52% Moodys-Aaa 621 3136G1FY0 1,000,000.00 0.98 1,006,577.19 1.42 4,086.81 -7,254.19 S&P-AA+ 1.68 FNMA 1.62511/27/2018 7/16/2014 1,004,411.00 100.34 1,003,418.00 0.52% Moodys-Aaa 515 3135G0YT4 1,000,000.00 1.52 1,001,423.54 1.38 1,489.58 1,994.46 S&P-M+ 1.4 FNMA 1.87512/282020 9/22/2016 1,025,880.00 100.57 1,005,691.00 0.53% Moodys-Aaa -�� 1277 3135G0H55 1,000,000.00 1.25 1,021,195.99 1.71 104.17 -15,504.99 S8P-AA. 3.4 6,012,624.21 6,002,957.00 3.1% 508 Sub Total FNMA Bond 6,000,000.00 1.19 6,024,429.09 1.34 8,427.10 -21,472.09 1.37 Local Government Investment Pool Texas Class LGIP 12/20/2016 5,031,130.53 100.00 5,031,130.53 2.59% None 1 TX-01-0615-0001 5,031,130.53 1.13 5,031,130.53 1.13 0.00 None 0 Texas Class LGIP 1/15/2017 7,056,329.53 100.00 7,056,329.53 3.64% None 1 TX-01-0615-0001 7,056,329.53 1.13 7,056,329.53 1.13 0.00 None 0 Texas Gass LGIP 5/15/2017 500,967.58 100.00 500,967.58 0.26% None 1 TX-01-0615-0001 500,967.58 1.13 500,967.58 1.13 0.00 None 0 Texas Class LGIP 1/15/2017 1,004,787.38 100.00 1,004,787.38 0.52% None 1 TX-01-0615.0001 1,004,787.38 1.13 1,004,787.38 1.13 0.00 None 0 Texas Class LGIP 1/15/2017 1,004,787.38 100.00 1,004,787.38 0.52% None 1 TX-01-0615-0001 1,004,787.38 1.13 1,004,787.38 1.13 0.00 None 0 Prepared by Rick Overgaard 14 of 15 Page 18 of 39 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP 12/20/2016 4,525,140.03 100.00 4,525,140.03 2.33% None 1 TX-01-0615-0001 4,525,140.03 1.13 4,525,140.03 1.13 0.00 None 0 Texas Class LGIP 12/2012016 2,025,325.05 100.00 2,025,325.05 1.04% None 1 TX-01-0615-0001 2,025,325.05 1.13 2,025,325.05 1.13 0.00 None 0 Texas Class LGIP 12/20/2016 37,633,836.44 100.00 37,633,836.44 19.39% None 1 TX-01-0615-0001 37,633,836.44 1.13 37,633,836.44 1.13 0.00 None 0 Texas Class LGIP 5/15/2017 3,005,805.48 100.00 3,005,805.48 1.55% None 1 TX-01-0615-0001 3,005,805.48 1.13 3,005,805.48 1.13 0.00 None 0 Texas Class LGIP 5/15/2017 5,009,675.79 100.00 5,009,675.79 2.58% None 1 TX-01-0615-0001 5,009,675.79 1.13 5,009,675.79 1.13 0.00 None C TexSTAR LGIP 8/26/2016 5,024,075.24 100.00 5,024,075.24 2.59% S&P-AAA 1 02000-11110 5,024,075.24 0.86 5,024,075.24 0.86 0.00 None 0 TexSTAR LGIP 8/26/2016 5,024,422.30 100.00 5,024,422.30 2.59% S&P-AAA 1 02000-11110 5,024,422.30 0.86 5,024,422.30 0.86 0.00 None 0 76,846,282.73 76,846,282.73 39.6% 1 Sub Total Local Government Investment 76,846,282.73 1.10 76,846,282.73 1.10 0.00 0 Pool 194,080,404.86 193,973,976.04 100.00% 159 TOTAL PORTFOLIO 194,066,705.65 0.83 194,086,578.00 0.84 109,460.32 -112,601.96 0.54 Prepared by Rick Overgaard 15 of 15 Page 19 of 39 • . City of Pearland aktLf Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value VIM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 100:General Fund Allegiance Bank 0.6 9/13/2017 9/13/2016 247,818.98 100.00 247,818.98 0.13% None 75 2611523C 247,818.98 0.60 247,818.98 0.60 0.00 0.00 None 0.2 Alma Bank 1.35 12/24/2020 6/24/2016 248,000.00 98.2.3 243,606.93 0.13% None 1273 020080B82 248,000.00 1.35 248,000.00 1.88 55.04 .4,393.07 None 3.4 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 98.16 243,441.76 0.13% None 1473 02554BCM1 248,000.00 1.35 248,000.00 1.82 174.28 -4,55824 None 3.92 Bank Leumi USA 1.3 2/26/2020 3/3/2016 248,000.00 100.33 248,817.41 0.13% None 971 063248FH6 248,000.00 1.30 248,000.00 1.17 1,095.28 817.41 None 2.61 Bank of the Pacific 1.25 7/30/2018 1/29/2015 248,000.00 99.87 247,675.37 0.13% None 395 06425BBN8 248,000.00 1.25 248,000.00 1.37 1,282.47 -324.83 None 1.07 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248.000.00 101.32 251,261.70 0.13% None 1183 06610QCV1 248,000.00 1.80 248,000.00 1.38 61.15 3,261.70 None 3.15 Belmont Savings Bank 1.8510/23/2019 12/23/2014 248,000.00 100.79 249,967.88 0.13% None 845 080515800 248,000.00 1.85 248,000.00 1.50 87.99 1,967.88 None 2.28 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 101.33 251,304.60 0.13% None 1183 14042RAB7 248,000.00 2.30 248,000.00 1.87 1,515.86 3,304.60 None 3.12 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 98.54 244,381.68 0.13% None 1123 144153AW3 248,000.00 1.10 248,000.00 1.59 22.42 -3,618.32 None 3.02 CDARS 0.7 12/13/2018 12/15/2016 500,000.00 100.00 500,000.00 026% None 531 1019720221 500,000.00 0.70 500,000.00 0.70 1,706.85 0.00 Nono 1.45 COMM 0.9 6/14/2018 6/16/2016 500,000.00 100.00 500,000.00 0.26% None 349 1019145928 500,000.00 0.90 500,000.00 0.90 2,194.52 0.00 None 0.95 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248,000.00 100.97 250,401.63 0.13% None 872 17284C3Z5 248,000.00 2.10 248,000.00 1.68 599.28 2,401.63 None 2.33 Prepared by Rick Overgaard 1 of 18 Page 20 of 39 .4 '; , City of Pearland j,,' XLi NA Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount! CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Comenity Capital Bank 1.7 5/28/2018 11/26/2014 248,000.00 100.16 248,389.86 0.13% None 332 20033AJL1 248,000.00 1.70 248,000.00 1.53 46.20 389.86 None 0.9 Commercial Bank Ala Mich 1.5 3/29/2019 6/30/2015 248,000.00 99.92 247,794.66 0.13% None 637 201282GV6 248,000.00 1.50 248,000.00 1.55 10.19 -205.34 None 1.73 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 98.60 244,532.46 0.13% None 1461 203507BG2 248,000.00 1.50 248,000.00 1.86 0.00 -3,467.54 None 3.88 Community Bankers'Bank 1.4 6/30/2016 248,000.00 98.60 244,525.52 0.13% None 1461 6/30/2021 20361LBR4 248,000.00 1.40 248,000.00 1.76 0.00 -3474.48 None 3.89 Community National Bank Interest 1.25 4/4/2014 248,000.00 100.01 248,017.36 0.13% None 278 4/4/2018 20375WAM6 248,000.00 1.25 248,000.00 1.24 738.90 17.36 None 0.76 Exchange Bank NEB 1.05 1/21/2020 7/20/2016 248,000.00 98.33 243,868.82 0.13% None 935 301074CH1 248,000.00 1.05 248,000.00 1.72 71.34 -4,131.18 None 2.52 Fahey Banking 1.1 6/28/2019 3/29/2016 248,000.00 99.91 247,782.01 0.13% None 728 303117CC7 248,000.00 1.10 248,000.00 1.15 14.95 -217.99 None 1.97 FAMC 1.6752/24/2020 2/24/2017 1.001,200.00 100.05 1,000,501.00 0.52% Moodys-Aaa 969 3132X0PW5 1,000,000.00 1.63 1,001,060.00 1.66 5,862.50 -559.00 S&P-AA+ 2.59 Farmers&Merchants Bank 1.45 4/25/2014 248,000.00 100.03 248,081.34 0.13% None 117 9/25/2018-14 308862DD0 248,000.00 1.45 248,000.00 1.42 49.26 81.34 None 1.23 FFCB 1.34 12129;2017 1/29/2014 1,004,000.00 100.11 1,001,058.00 0.52% M000ys-Aaa 182 3133EDE99 1,000,000.00 1.24 1,000,507.80 1.13 37.22 550.20 S&P-AA+ 0.5 --_____-------- -------- FHLB 1.45 6/28/2019-17 6/28/2017 1,000,000.00 99.88 998,848.00 0.52% Moodys-Aaa 90 3130ABHRO 1,000,000.00 1.45 1,000,000.00 1.51 80.56 -1,152.00 S&P-M+ 1.97 FHLMC 1.35 12117/2018-15 6/19/2015 999,525.00 99.90 998,975.00 0.52% S&P-AA+ 535 3134G6S95 1,000,000.00 1.36 999,801.01 1.42 487.50 -826.01 Moodys-Aaa 1.45 Prepared by Rick Overgaard 2 of 18 Page 21 of 39 City of Pearland 1 ZINg Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount CUSIP Shares YTM @ Cost Book Value YTM iu�Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity First Capital Bank 1.4 8/6/2019 4/6/2015 248,000.00 100.36 248,904.21 0.13% None 767 31944FBK5 248.000.00 1.40 248,000.00 1.22 228.30 90421 None 2.07 Goldman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 100.69 249,708.72 0.13% None 970 38148113 248,000.00 2.00 248,000.00 1.73 1,698.63 1,708.72 None 2.58 Partners Bank 1.5 9/30/2019 3/30/2015 248,000.00 100.64 249,592.66 0.13% None 822 70212YAR3 248,000.00 1.50 248,000.00 1.21 0.00 1,592.66 None 2.21 Texas Class LGIP 1/15/2017 7,056,329.53 100.00 7.056.329.53 3.64% None 1 TX-01-0615-0001 7,056,329.53 1.13 7,056,329.53 1.13 0.00 None 0 Webster Bank NA 1.9 2/12/2019 2/12/2014 248,000.00 100.61 249,518.50 0.13% None 592 94768NJM7 248,000.00 1.90 248,000.00 1.52 1,781.52 1,518.50 None 1.59 Wells Fargo Sweep Cash 5/31/2006 1,805,366.09 100.00 1,805.366.09 0.93% None 1 WFSWEEP 1,805,386.09 0.09 1,805,366.09 0.09 0.00 None 0 • 10,845,695.62 10,855,261.23 5.61% 146 Sub Total 200:Debt Services 10,845,695.62 1.06 10,845,695.62 1.01 6,219.02 9,585.61 0.39 305:HoteUMotel Occupancy Ally Bank Midvale Utah 1.8 6/29/2020 6/29/2017 248,000.00 100.02 248,046.62 0.13% None 1095 02006L3U5 248,000.00 1.80 248,000.00 1.79 12.23 46.62 None 2.93 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 98.60 244,525.52 0.13% None 1461 063847AL1 248,000.00 1.40 248,000.00 1.76 0.00 -3,474.48 None 3.89 Capital Bank Little Rode 1.35 3/22/2019 9!23/2015 248.000.00 100.59 249,468.16 0.13% None 630 139797FL3 248,000.00 1.35 248,000.00 1.00 73.38 1,468.16 None 1.71 First Intl Bank&:Trust 1,81/18/2020 10/16/2015 248,000.00 99.72 247,299.40 0.13% None 930 32057GAE9 248,000.00 1.60 248,000.00 1.71 152.20 -700.60 None 2.49 v Texas Class LGIP 5/15/2017 3,005,805.48 100.00 3,005,805.48 1.55% None1 TX-01-0615-0001 3,005,805.48 1.13 3,005.805.48 1.13 0.00 None 0 Prepared by Rick Overgaard 5 of 18 Page 24 of 39 4110.1,1: City of Pearland Lill.A4Zial Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM Q Cost Book Value YTM 42 Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 5(31/2006 268,644.00 100.00 268,644.00 0.14% None 1 WFSWEEP 268,644.00 0.09 268,644.00 0.09 0.00 None 0 4,266,449.48 4,263,789.18 2.21% 240 Sub Total 305:Hotel/Motel Occupancy 4,266,449.48 1.16 4,266,449.48 1.17 237.81 -2,660.30 0.64 310:Municipal Court Security Wells Fargo Sweep Cash 5/31/2006 36,878.76 100.00 36,878.76 0.02% None 1 WFSWEEP 36,878.76 0.09 36,878.76 0.09 0.00 None 0 36,878.76 36,878.76 0.02% 1 Sub Total 310:Municipal Court Security 36,878.76 0.09 36,878.76 0.09 0.00 0 315:City Wide Donation Wells Fargo Sweep Cash 5/31/2006 73,573.86 100.00 73,573.86 0 04% None 1 WFSWEEP 73,573.86 0.09 73,573.86 0.09 0.00 None 0 73,573.86 73,573.86 0.04% 1 Sub Total 315:City Wide Donation 73,573.86 0.09 73,573.86 0.09 0.00 0 320:Court Technology Wells Fargo Sweep Cash 5/3112006 -5,937.56 100.00 -5,937.56 0% None 1 WFSWEEP -5,937.56 0.09 -5,937.56 0.09 0.00 None 0 -5,937.56 -5,937.56 0% 1 Sub Total 320:Court Technology -5,937.56 0.09 -5,937.56 0.09 0.00 0 330:Park Donations Wells Fargo Sweep Cash 5/31/2006 112,930.66 100.00 112,930.66 0.06% None 1 WFSWEEP 112,930.66 0.09 112,930.66 0.05 0.00 None 0 112,930.66 112,930.66 0.06% 1 Sub Total 330:Park Donations 112,930.66 0.09 112,930.66 0.09 0.00 0 331:Tree Trust Fund Wells Fargo Sweep Cash 5/31/2006 74,088.29 100.00 74.088.29 0.04% None 1 WFSWEEP 74,088.29 0.09 74,088.29 0.09 0.00 None 0 74,088.29 74,088.29 0.04% 1 Sub Total 331:Tree Trust Fund 74,088.29 0.09 74,088.29 0.09 0.00 0 Prepared by Rick Overgaard 6 of 18 Page 25 of 39 • City of Pearland getwk& Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 335:Police State Seizure Wells Fargo Sweep Cash 5/31/2006 233,466.56 100.00 233,466.56 0.12% None 1 WFSWEEP 233,466.56 0.09 233,466.56 0.09 0.00 None 0 233,466.56 233,466.56 0.12% 1 Sub Total 335:Police State Seizure 233,466.56 0.09 233,466.56 0.09 0.00 0 336: Federal Police Fund Wells Fargo Sweep Cash 5/31/2006 10,742.28 100.00 10,742.28 0.01% None 1 WFSWEEP 10,742.28 0.09 10,742.28 0.09 0.00 None 0 10,742.28 10,742.28 0.01% 1 Sub Total 336:Federal Police Fund 10,742.28 0.09 10,742.28 0.09 0.00 0 340:Park&Rec Development Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 97.84 242,632.78 0.13% None 1461 099703EF3 248,000.00 1.40 248,000.00 1.96 0.00 -5,367.22 None 3.89 Nebraskafand National Bank 12 9/2512018 9/25/2015 248,000.00 100.35 248,873.21 0.13% None 452 63970QFC5 248,000.00 1.20 248,000.00 0.91 40.77 873.21 None 1.23 Wells Fargo Sweep Cash 5/31/2006 445,127.23 100.00 445,127.23 0.23% None 1 WFSWEEP 445,127.23 0.09 445,127.23 0.09 0.00 None 0 941,127.23 936,633.22 0.49% 505 Sub Tota:340:Park&Roc Development 941,127.23 0.73 941,127.23 0.80 40.77 -4,494.01 1.35 345:Sidewalk Fund Wells Fargo Sweep Cash 5/31/2006 6,28230 100.00 6,282.30 0% None 1 WFSWEEP 6,282.30 0.09 6,282.30 0.09 0.00 None 0 6,282.30 6,282.30 0% 1 Sub Total 345:Sidewalk Fund 6,282.30 0.09 6,282.30 0.09 0.00 0 350:Grant Fund Wells Fargo Sweep Cash 5/31/2006 80,822.31 100.00 80,822.31 0.04% None 1 WFSWEEP 80,822.31 0.09 80,822.31 0.09 0.00 None 0 Prepared by Rick Overgaard 7 of 18 Page 26 of 39 City of Pearland I{i.E9 Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value 'i Portfolio Credit Rating Days To Call/Maturity Face Amount CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 80,822.31 80,822.31 0.04% 1 Sub Total 350:Grant Fund 80,822.31 0.09 80,822.31 0.09 0.00 0 351:CDBG Fund Welts Fargo Sweep Cash 11/15/2015 -86,589.20 100.00 -86,589.20 -0.04% None 1 WFSWEEP -86,589.20 0.09 -86,589.20 0.09 0.00 None 0 -86,589.20 -86,589.20 -0.04% 1 Sub Total 351:CDBG Fund -86,589.20 0.09 -86,589.20 0.09 0.00 0 360:Traffic Impact Improvement Summit Community Bank Moorefield WV 6/30/2017 248,000.00 99.87 247,685.54 0.13% None 728 1.55 6/28/2019 86604XLX2 248,000.00 1.55 248,000.00 1.62 0.00 -314.46 None 1.97 Wells Fargo Sweep Cash 5/31/2006 493,443.20 100.00 493,443.20 0.25% None 1 WFSWEEP 493,443.20 0.09 493,443.20 0.09 0.00 None 0 741,443.20 741,128.74 0.38% 244 Sub Total 360:Traffic Impact 741,443.20 0.58 741,443.20 0.60 0.00 -314.46 0.66 Improvement 365:Court Juvenile Mgmt Wells Fargo Sweep Cash 9/15/2009 23,734.36 100.00 23,734.36 0.01% None 1 WFSWEEP 23,734.36 0.09 23,734.36 0.09 0.00 None 0 23,734.36 23,734.36 0.01% 1 Sub Total 365:Court Juvenile Mgmt 23,734.36 0.09 23,734.36 0.09 0.00 0 370:Municipal Channel Texas Class LGIP 5/15/2017 500,967.58 100.00 500,967.58 0.26% None 1 TX-01-0615-0001 500,967.58 1.13 500,967.58 1.13 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 84,685.43 100.00 84,685.43 0.04% None 1 WFSWEEP 84,685.43 0.09 84,685.43 0.09 0.00 None 0 585,653.01 585,653.01 0.3% 1 Sub Total 370:Municipal Channel 585,653.01 0.98 585,653.01 0.98 0.00 0 375:U of H Fund Prepared by Rick Overgaard Sof 18 Page 27 of 39 City of Pearland akliekkill Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %S Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM to Cost Book Value YTM(&Market Accrued Interest Unrn Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 12/1/2009 -370.34 100.00 -370.34 0% Nono 1 WFSWEEP -370.34 0.09 -370.34 0.09 0.00 None 0 470.34 470.34 0% 1 Sub Total 375:U of H Fund -370.34 0.09 470.34 0.09 0.00 0 500:Capital Projects Texas Class LGIP 1/15/2017 1,004,787.38 100.00 1,004,787.38 0.52% None 1 TX-01-0615-0001 1,004,787.38 1.13 1,004,787.38 1.13 0.00 None 0 Umpqua Bank Roseburg OR 1.6 6/28/2019 8/30/2017 248,000.00 99.97 247,928.82 0.13% None 728 90421MAX1 248,000.00 1.60 248,000.00 1.61 0.00 -71.18 None 1.97 Wells Fargo Sweep Cash 5/31/2006 2.959,802.42 100.00 2,959.802.42 1.52% None 1 WFSWEEP 2,959,802.42 0.09 2,959,802.42 0.09 0.00 None 0 4,212,589.80 4,212,518.62 2.17% 44 Sub Total 500:Capital Projects 4,212,589.80 0.43 4,212,589.80 0.43 0.00 -71.18 0.12 501:Certificates of Obligation 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 97.28 241,265.06 0.13% None 1302 33625CAZ2 248,000.00 1.10 248,000.00 1.89 59.79 -6,734.94 None 3.49 FAMC 1.58/22/2019 2/22/2017 1,000,000.00 99.85 998,541.00 0.52% S&P-AA+ 783 3132X0PV7 1,000,000.00 1.50 1,000,000.00 1.57 5,333.33 -1,459.00 Moodys-Aaa 2.11 FHLMC 1.125 8/12/2021 9/2212016 988,540.00 97.27 972,686.00 0.51% Moodys-Aaa 1504 3137EAEC9 1,000,000.00 1.37 990,350.16 1.82 4,156.25 -17,664.16 S&P-AA+ 4.02 FHLMC 2 12/13/2021-17 12/13/2018 1,000,000.00 99.07 990,660.00 0.52% S&P-AA+ 75 3134GAZD9 1,000,000.00 2.00 1.000,000.00 2.22 944.44 -9,340.00 None 4.28 FNMA 1.87512/28/2020 9/22/2016 1,025,880.00 100.57 1,005,691.00 0.53% Moodys-Aaa 1277 3135G0H55 1,000,000.00 125 1,021,195.99 1.71 104.17 -15,504.99 S&P-AA+ 3.4 Gulf Coast Bank&Trust 1.3 7/15/2021- 7/15/2016 248,000.00 98.19 243,502.02 0.13% None 15 17 402194EX8 248,000.00 1.30 248,000.00 1.77 132.49 -4,497.98 None 3.94 Prepared by Rick Overgaard 9 of 18 Page 28 of 39 11111," City of Pearland aktilakig Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value ' Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM l9?Cost Book Value YTM/ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Luana Savings Bank 1.25 6/19/2018 12/19/2014 248,000.00 99.92 247,792.92 0.13% None 354 549103Q05 248,000.00 125 248,000.00 1.34 93.42 -207.08 None 0.97 Marlin Business Bank 1.25 12/27/2019 6/29/2016 248,000.00 98.97 245,436.92 0.13% None 910 57116AMC9 248,000.00 1.25 248,000.00 1.67 8.49 -2,563.08 None 2.45 Texas Class LGIP 12/20/2016 5.031,130.53 100.00 5,031,130.53 2.59% None 1 TX-01-0615-0001 5,031,130.53 1.13 5,031,130.53 1.13 0.00 Nono 0 TexSTAR LGIP 8/26/2016 5.024,422.30 100.00 5,024,422.30 2.59% S&P-MA 1 02000-11110 5,024,422.30 0.86 5,024,422.30 0.86 0.00 None 0 Wells Fargo Sweep Cash 5/31/2008 66,272.42 100.00 66,272.42 0.03% None 1 WFSWEEP 66,272.42 0.09 66,272.42 0.09 0.00 None 0 15,128,245.25 15,067,400.17 7.81% 284 Sub Total 501:Certificates of Obligation 15,113,825.25 1.15 15,125,371.40 1.26 10,832.38 -57,971.23 1.09 503:Certificates of Obligation 2006 Wells Fargo Sweep Cash 6/30/2006 182,039.45 100.00 182,039.45 0.09% None 1 WFSWEEP 182,039.45 0.09 182,039.45 0.09 0.00 None 0 182,039.45 182,039.45 0.09% 1 Sub Total 503:Certificates of Obligation 182,039.45 0.09 182,039.45 0.09 0.00 0 2006 506: General Obligation BMO Harris Bank 1.05 6/22/2018 6/23/2016 248,000.00 99.70 247,245.34 0.13% None 357 05581WHF5 248,000.00 1.05 248,000.00 1.36 49.94 -754.66 None 0.98 Brickell Bank Miami FL 1.65 10/28/2019 6/27/2017 248,000.00 99.94 247,861.37 0.13% None 850 10801 DAG6 248,000.00 1.65 248,000.00 1.68 33.63 -138.63 None 2.28 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 99.39 246,483.98 0.13% None 1454 12325EHU9 248,000.00 1.80 248,000.00 1.96 85.61 -1,516.02 None 3.84 Capital One Bank USA 1.1 11/19/2019 11/19/2014 248,000.00 100.94 250,343.35 0.13% None 872 140420QX1 248,000.00 1.10 248,000.00 0.70 313.91 2,343.35 None 2.36 Prepared by Rick Overgaard 10 of 18 Page 29 of 39 ?k ' City of Pearland ► aQ Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To CallMMaturity Face Amount/ CUSIP Shares YTM(/8 Cost Book Value YTM t•Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Citizens State Bank Clayton 1.35 4/30/2019 9/30/2015 248,000.00 100.61 249,523.96 0.13% None 669 176688BS7 248,000.00 1.35 248,000.00 1.01 0.00 1,523.96 None 1.81 FFCB 1.5128/2019 5/28/2014 1,000,000.00 100.16 1,001,613.00 0.52% Moodys-Aaa• 577 3133EDMF6 1,000,000.00 1.50 1,000,000.00 1.40 6,333.33 1,613.00 S&P-AA+ 1.56 FHLB 1 9/26/2019 9/22/2016 997,430.00 98.98 989,842.00 0.51% Moodys-Aaa 818 3130A9EP2 1,000,000.00 1.09 998,089.10 1.46 2,611.11 -8,247.10 S&P-AA+ 2.21 FHLMC 2 12/13/2021-17 12/13/2016 1,000,000.00 99.07 990,660.00 0.52% S&P-AA+ 75 3134GAZD9 1,000,000.00 2.00 1,000,000.00 2.22 944.44 -9,340.00 None 4.28 First Business Bank 1.7 6/302020 9/30/2015 248.000.00 99.73 247,319.98 0.13% None 1096 31938QP40 248,000.00 1.70 248,000.00 1.79 1,062.66 -680.02 None 2.92 First Mid-III Bank&Trust 0.9 1/2/2018 - 8/3012016 248,000.00 99.85 247,617.83 0.13% None 186- 32086R6K5 248,000.00 0.90 248,000.00 1.20 0.00 -382.17 None 0.51 First National Bank of Amenca 1.25 7/1512016 248,000.00 97.19 241,043.10 0.13% None 1476 7/15/2021 32110YHM0 248,000.00 1.25 248,000.00 1.98 1,409.86 -6,956.90 None 3.93 Lincoln 1st Bank 1.4 6/30/2021 613012016 248,000.00 98.60 244,525.52 0.13% None 1461 533621A00 248,000.00 1.40 248,000.00 1.76 275.86 -3,474.48 None 3.89 National Bank Commerce Superior 1.25 7/15/2016 248,000.00 98.19 243,502.02 0.13% None 15 7/152021-17 633388E87 248,000.00 1.25 248,000.00 1.72 127.40 -4,497.98 None 3.94 Peoples United Bank 1.911/19/2019 11/19/2014 248,000.00 100.92 250,292.02 0.13% None 872 71270QKM7 248,000.00 1.90 248,000.00 1.50 542.20 2,292.02 None 2.34 Revere Bank 1.35 6292018 12/30/2014 248,000.00 100.07 248,175.58 0.13% None 364 761402AU0 248,000.00 1.35 248,000.00 1.28 9.17 175.58 None 0.99 Texas Class LGIP 12/20/2016 2,025,325.05 100.00 2,025,325.05 1.04% None 1 TX-01-0615-0001 2,025,325.05 1.13 2,025,325.05 1.13 0.00 None 0 Prepared by Rick Overgeard 11 of 18 Page 30 of 39 City of Pearland LILLUIALU Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount! CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity TexSTAR LGIP 8/26/2016 5.024,075.24 100.00 5,024,075.24 2.59% S&P-AAA 1 02000-11110 5,024,075.24 0.86 5,024,075.24 0.86 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 2,512,234.62 100.00 2,512,234.62 1.29% None 1 WFSWEEP 2,512,234.62 0.09 2,512,234.62 0.09 0.00 None 0 15,535,064.91 15,507,683.96 8.03% 250 Sub Total 506:General Obligation 15,537.634.91 1.00 15,535,724.01 1.05 13,799.12 -28,040.05 0.99 510:Lower Kirby Urban Center Wells Fargo Sweep Cash 10/15/2015 1,770,175.04 100.00 1,770,175.04 0.91% None 1 WFSWEEP 1,770,175.04 0.09 1,770,175.04 0.09 0.00 None 0 1,770,175.04 1,770,175.04 0.91% 1 Sub Total 510:Lower Kirby Urban Center 1,770,175.04 0.09 1,770,175.04 0.09 0.00 0 550:W/S Impact Fee Bank United 1.2 11/21/2017 11/21/2014 248,000.00 100.03 248,063.49 0.13% None 144 066519AF6 248,000.00 1.20 248,000.00 1.13 326.14 63.49 None 0.39 Bankwest,Inc.1.5 1/3/2020 3/4/2015 248,000.00 99.49 246,737.93 0.13% None 917 06652CFA4 248,000.00 1.50 248,000.00 1.71 275.18 -1,262.07 None 2.46 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 100.55 249.366.48 0.13% None 1085 05580ABX1 248,000.00 2.10 248,000.00 1.91 156.95 1,366.48 None 2.89 Cedar Rapids Bank&Trust 1.5 1/30/2015 248,000.00 101.07 250,654.59 0.13% None 852 10/30/2019 150517CJ7 248,000.00 1.50 248,000.00 1.04 295.56 2,654.59 None 2.29 EVB Tappa Hannock VA 1.6 9/25/2019 9/25/2015 248,000.00 100.82 250,029.63 0.13% None 817 26927ABK7 248,000.00 1.60 248,000.00 1.23 1,054.51 2,029.63 None 2.2 First Financial NW 1.3510/30/2019 10/30/2015 248,000.00 99.25 246,151.90 0.13% None 852 32022MAF5 248,000.00 1.35 248,000.00 1.68 0.00 -1,848.10 None 2.3 FNMA 0.8755/21/2018 5/21/2014 985,050.00 99.66 996,581.00 0.51% Moodys-Aaa 325 313500WJ8 1,000,000.00 1.26 996,667.40 1.26 947.92 -86.40 S&P-A4+ 0.89 Prepared by Rick Overgaard 12 of 18 Page 31 of 39 City of Pearland LiWkAkl51 Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FNMA 1.375 3/13/2019-16 9/22/2016 1,009,560.00 99.93 999,323.00 0.52% Moodys-Aaa 621 3136G1FY0 1,000,000.00 0.98 1,006,577.19 142 4.86.81 -7,254.19 S&P-AA+ 1.68 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 98.73 244,853.38 0.13% None 1096 69413CFD6 248,000.00 1.25 248,000.00 1.68 0.00 -3,148.82 None 2.95 Texas Class LGIP 12/20/2016 37,633,836.44 100.00 37,633,836.44 19.39% None 1 TX-01-0615-0001 37,633,836.44 1.13 37,633,836.44 1.13 0.00 None 0 y Washington Trust Co 1.4 6/15/2018 12/15/2014 248,000.00 100.09 248,234.36 0.13% None 350 940637GU9 248,000.00 1.40 248,000.00 1.30 142.68 234.36 None 0.96 Welch State Bank 1.3 10/1/2018 9/30/2015 248,000.00 100.34 248,839.98 0.13% None 458 949095AU7 248,000.00 1.30 248,000.00 1.03 256.15 839.98 None 1.24 Wells Fargo Sweep Cash 5/31/2006 672.407.57 100.00 672,407.57 0.35% None 1 WFSWEEP 672,407.57 0.09 872,407.57 0.09 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 10,846,369.30 100.00 10,846,369.30 5.59% None 1 WF4094 10,846,369.30 0.05 10,846,369.30 0.05 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 10,002,416.73 100.00 10,002,416.73 5.15% None 1 WF5875 10,002,418.73 0.09 10,002,416.73 0.09 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 5,106,603.95 100.00 5,106,603.95 2.63% None 1 WF4102 5,106,603.95 0.05 5,106,603.95 0.05 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 11,763,233.16 100.00 11,763,233.16 6.06% None 1 WF5883 11,763,233.16 0.09 11,763,233.16 0.09 0.00 None 0 80,251,477.15 80,253,702.89 41.37% 33 Sub Total 550:W/S Impact Fee 80,256,867.15 0.63 80,260,111.74 0.84 7,541.90 4,408.85 0.09 555:Shadow Creek Impact - E'.uryreen Bare 1.2 6.29./2016 6/29/2015 248,000.00 99.90 247,757.46 0.13% None 364 300185CY9 248,000.00 1.20 248,000.00 1.30 8.15 -242.54 None 0.99 Prepared by Rick Overgaard 13 of 18 Page 32 of 39 A City of Pearland tatUatIci Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value '% Portfolio Credit Rating Days To CaWMaturity Face Amount I CUSIP Shares YTNI @ Cost Book Value YTM @ Market Accrued Interest Unre.Gam/Loss Credit Rating Duration To Maturity FAMC 1.6752/24/2020 2124/2017 1,001,200.00 100.05 1,000,501.00 0.52% Moodys-Aaa 969 3132X0PW5 1,000,000.00 1.63 1,001,060.00 1.66 5.862.50 -559.00 S&P-AA+ 2.59 GUARANTY B&T 1.35 5/29/2018 5/29/2014 248,000.00 100.04 248,091.02 0.13% None 333 400820BJ4 248,000.00 1.35 248,000.00 1.31 9.17 91.02 None 0.91 Manufacturers&Traders Trust 1.2 6/24/2015 248,000.00 99.95 247,868.56 0.13% None 360 6/25/2018 564759QV3 248,000.00 1.20 248.000.00 1.25 48.92 -131.44 None 0.98 Wells Fargo Sweep Cash 5/31/2006 274,756.24 100.00 274,756.24 0.14% None 1 WFSWEEP 274,756.24 0.09 274,756.24 0.09 0.00 None 0 2,019,956.24 2,018,974.28 1.05% 610 Sub Total 555:Shadow Creek Impact 2,018,756.24 1.28 2,019,816.24 1.31 5,928.74 -841.96 1.64 560:Certificates of Obligation 1998 Wets Fargo Sweep Cash 5/31/2006 368,089.71 100.00 368,089.71 0.19°! None 1 WFSWEEP 368,0897' 0.09 368,089.71 0.09 0.00 None 0 368,089.71 368,089.71 0.19% 1 Sub Total 560:Certificates of Obligation 368,089.71 0.09 368,089.71 0.09 0.00 0 1998 565:Revenue Bonds 1999 8 2003 Continental Bank 1.25 5/25/2018 11/26/2014 248,000.00 99.95 247,876.74 0.13% None 329 211163EN6 248,000.00 1.25 248,000.00 1.31 305.75 -123.26 None 0.9 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 99.85 998,541.00 0.52% S&P-AA+ 783 3132XOPV7 1,000,000.00 1.50 1,000,000.00 1.57 5,333.33 -1,459.00 Moodys-Aaa 2.11 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 98.60 244,532.46 0.13% None 1461 36198JCC6 248,000.00 1.50 248.000.00 1.86 0.00 -3,467.54 None 3.88 Signature Bank 1.35 3/28/2019 9/29/2015 248,000.00 100.57 249,419.06 0.13% None 636 82669LFU2 248,000.00 1.35 248,000.00 1.02 18.35 1,419.06 None 1.72 Silvergate Bank 1 6/29/2018-16 6/29/2016 248,000.00 99.70 247,267.90 0.13% None 28 828373FE5 248,000,00 1.00 248,000.00 1.30 6.79 -732.10 None 0.99 Prepared by Rick Overgaard 14 of 18 Page 33 of 39 111P. City of Pearland r > . Nt1 Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP 1/15/2017 1,004,787.38 100.00 1,004,787.38 0.52% None 1 TX-01-0615-0001 1,004,787.38 1.13 1,004,787.38 1.13 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 600,925.68 100.00 600,925.68 0.31% None 1 WFSWEEP 600.925.68 0.09 600,925.68 0.09 0.00 None 0 3,597,713.06 3,593,350.22 1.87% 387 Sub Total 565:Revenue Bonds 1999& 3,597,713.06 1.10 3,597,713.06 1.14 5,664.22 .4,362.84 1.1 2003 570:W/S Pay As You Go Marine Bank Springfield IL 1.8 6/2912021 6/29/2017 248.000.00 99.57 246,927.90 0.13% None 1460 56817TA87 248,000.00 1.80 248,000.00 1.91 12.23 -1,072.10 None 3.86 Wells Fargo Sweep Cash 12/31/2007 1.542.815.69 100.00 1,542,615.69 0.79% None 1 WFSWEEP 1,542,615.69 0.09 1,542,615.69 0.09 0.00 None 0 1,790,615.69 1,789,543.59 0.92% 203 Sub Total 570:W/S Pay As You Go 1,790,615.69 0.33 1,790,615.69 0.34 12.23 -1,072.10 0.53 575:MUD 4 Capital Programs Wells Fargo Sweep Cash 2/1/2013 326,085.40 100.00 326,085.40 0.17% None 1 WFSWEEP 326,085.40 0.09 326,085.40 0.09 0.00 None 0 326,085.40 326,085.40 0.17% 1 Sub Total 575:MUD 4 Capital Programs 326,085.40 0.09 326,085.40 0.09 0.00 0 600:Water&Sewer BARCLAYS BANK DELAWARE 1.95 5/6/2014 248,000.00 100.75 249,871.66 0.13% None 676 5;7/2019 06740KGU5 248,000.00 1.95 248,000.00 1.54 715.46 1,871.66 None 1.82 MARS 1.05 6/15/2019 6/15/2017 500,000.00 100.00 500,000.00 0.26% None 715 CDARS061517 500,000.00 1.05 500,000.00 1.05 215.75 0.00 None 3.96 Eaglebank Bethesda 1.15 12/10/2018 3/9/2016 248,000.00 99.93 247,826.90 0.13% None 528 27002YCV6 248,000.00 1.15 248,000.00 1.20 164.09 -173.10 None 1.43 FAMC 1.58/22/2019 2/22/2017 2,001,700.00 99.85 1,997,082.00 1.03% S&P-AA+ 783 3132X0PV7 2,000,000.00 1.47 2,001,458.22 1.57 10,666.67 -4,376.22 Moodys-Aaa 2.11 Prepared by Rick Overgaard 15 of 18 Page 34 of 39 ; .: . City of Pearland iklat.WA Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Face Amount/ Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM©Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FAMC 1.7210/3/2018 1211612013 997,890.00 100.37 1,003,663.00 0.51% Moodys-Aaa 460 31315P5A3 1,000.000.00 1.77 999,446.54 1.43 4,156.67 4,216.46 S&P-AA+ 1.25 FFCB 1.95 9/17/2018 1/29/2014 1,014,770.00 100.59 1,005,944.00 0.52% Moodys-Aaa 444 3133ED2C5 1,000,000.00 1.62 1,003,869.60 1.45 5,579.17 2,074.40 S&P-AA+ 1.2 FHLB 1.75 12/14/2018 12/16/2013 1,000,670.00 100.54 1,005,388.00 0.52% Moodys-Aaa 532 313376BR5 1,000,000.00 1.74 1,000,195.26 1.38 777.78 5,192.74 S&P-AA+ 1.44 FHLMC 1 9/29/2017 1/29/2014 994,150.00 99.98 999,765.00 0.52% Moodys-Aaa 91 3137EADLO 1,000,000.00 1.16 999,605.57 1.09 2,527.78 159.43 S&P-AA+ 0.25 First Bank McComb MS 1.5 2/28/2019 6/30/2015 248,000.00 100.20 248,502.94 0.13% None 608 319234AJ9 248,000.00 1.50 248,000.00 1.38 20.38 502.94 None 1.64 First Eagie National Bank 1.4511/21/2018 11/21/2014 248,000.00 100.24 248,599.42 0.13% None 509 32008JAM5 248,000.00 1.45 248,000.00 1.27 394.08 599.42 None 1.38 FNMA 0.87510/26/2017 5/21/2014 995,150.00 99.93 999,294.00 0.51% Moodys-Aaa 118 3135GOPQ0 1,000,000.00 1.02 999,544.45 1.09 1,555.56 -250.45 S&P-AA+ 0.32 FNMA 1.625 11/27/2018 7/16/2014 1,004,411.00 100.34 1,003,418.00 0.52% Moodys-Aaa 515 3135G0YT4 1,000,000.00 1.52 1,001,423.54 1.38 1,489.58 1,994.46 S&P-M+ 1.4 MB Financial Bank 1.1 3/18/2019 3/18/2016 248,000.00 99.91 247,788.46 0.13% None 626 55266CQU3 248,000.00 1.10 248,000.00 1.15 89.69 -211.54 None 1.7 Northern Bank&:Trust MA 1.1 7/12/2016 248,000.00 99.14 245,861.25 0.13% None 12 7/12/2019-17 66476QBH0 248,000.00 1.10 248,000.00 1.53 590.44 -2,138.75 None 2.01 Northwest Bank Boise Idaho 1.5 1/10/2019 4/10/2014 248,000.00 100.62 249,534.62 0.13% None 559 66736AAD1 248,000.00 1.50 248,000.00 1.09 203.84 1,534.62 None 1.51 OLDTOWN BANK 1.2 5/7/2018 6/6/2014 248,000.00 100.19 248,480.38 0.13% None 311 680540BB6 248,000 00 1.20 248,000.00 0.97 195.68 480.38 None 0.85 Prepared by Rick Overgaard 16 of 18 Page 35 01 39 City of Pearland Ake Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount 1 CUSIP Shares YTM @ Cost Book Value YTM @ Markel Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Parkside Flnl Bank&Trust 1.3 7/18/2016 248,000.00 98.17 243,457.88 0.13% None 18 7/1912021-17 70147ABX1 248,000.00 1.30 248,000.00 1.77 105.99 -4,542.12 None 3.95 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 98.62 244,565.70 0.13% None 1455 73565NBC15 248,000.00 1.40 248,000.00 1.76 57.07 -3,434.30 None 3.87 Texas Class LGIP 12/20/2018 4,525.140.03 100.00 4,525,140.03 2.33% None 1 TX-01-0615-0001 4,525,140.03 1.13 4,525,140.03 1.13 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 7,962,740.56 100.00 7,962,740.56 4.1% None 1 WFSWEEP 7,962,740.56 0.09 7.962,740.56 0.09 0.00 None 0 23,476,621.59 23,476,923.80 12.12% 231 Sub Total 600:Water&Sewer 23,467,880.59 0.92 23,473,423.77 0.88 29,505.68 3,500.03 0.73 610:Solidwaste Wells Fargo Sweep Cash 12/1/2006 -616,400.79 100.00 -816,400.79 -0.32% None 1 WFSWEEP -616,400.79 0.09 -616,400.79 0.09 0.00 None 0 -616,400.79 416,400.79 43.32% 1 Sub Total 610:Solidwaste -616,400.79 0.09 -616,400.79 0.09 0.00 0 700:Property Liability Ins Wells Fargo Sweep Cash 10/31/2006 353,580.06 100.00 353,580.06 0.18% None 1 WFSWEEP 353,580.06 0.09 353,580.06 0.09 0.00 None 0 353,580.06 353,580.06 0.18% 1 Sub Total 700:Property Liability Ins 353,580.06 0.09 353,580.06 0.09 0.00 0 701:Employee Benefit Fund Wells Fargo Swoop Cast, 9/1/2007 81,163.41 100.00 81,163.41 0.04% None 1 WFSWEEP 81,163.41 0.09 81,163.41 0.09 0.00 None 0 81463..41 81,163.41 0.04% 1 Sub Total 701:Employee Benefit Fund 81,163.41 0.09 81,163.41 0.09 0.00 0 702:Health Claims Fund Wells Fargo Cash 7/21/2010 219,056.82 100.00 219,056.82 0.11% None 1 WF9871 219,056.82 0.09 219,056.82 0.09 0.00 None 0 Prepared by Rick Overgaard 17 of 16 Page 36 of 39 City of Pearland kLA44,i4g Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2017 Description Settlement Date Cost Value Market Price Market Value T.Portfolio Credit Rating Days To CalllMaturity Face Amount 1 CUSIP Shares YTM c�Cost Book Value YTM L Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 9/15/2010 2,665,060.79 100.00 2,665,060.79 1.37% None 1 WFSWEEP 2,665.060.79 0.09 2,665,060.79 0.09 0.00 None 0 2,884,117.61 2,884,117.61 1.48% 1 Sub Total 702:Health Claims Fund 2,884,117.61 0.09 2,884,117.61 0.09 0.00 0 194,080,404.86 193,973,976.04 100.00% 159 TOTAL PORTFOLIO 194,066,705.65 0.83 194,086,578.00 0.84 109,460.32 -112,601.96 0.54 Prepared by Rick Overgaard 18 of 18 Page 37 of 39 City of Pearland laialikkg Treasury Yield Curve Treasury 4/1/2017 5/1/2017 6/1/2017 1 Month 0.70 0.86 0.84 3 Month 0.81 0.98 1.03 6 Month 0.98 1.08 1.14 1 Year 1.06 1.17 1.24 2 Year 1.25 1.28 1.38 3 Year 1.44 1.44 1.55 5 Year 1.81 1.75 1.89 10 Year 2.30 2.21 2.31 2,50 2.00 - 1.50 - . - •4/1/2017 1 ,. 5/1/2017 1.00 6/1/2017 0.50 - 0.00 , i I i I I r i 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year Prepared by Rick Overgaard 1 of Page 38 of 39 Pledged Collateral Reconciliation Report June 30, 2017 Bank Account Number Account Name Amount Wells Fargo 807-1613395 Credit Card Account - Wells Fargo 001-3042841 Sweep Account 31,543,763.84 Wells Fargo 7169195455 False Alarm Reduction Program 282,025.68 Wells Fargo 818-4567843 Alvin ISD 7,178,370.31 Wells Fargo 179-0121790 EMS Payments - Wells Fargo 280-7409871 Health Claims 219,056.82 Wells Fargo 3542574094 Escrow W&S Revenue Bonds, Series B 10,846,369.30 Wells Fargo 3542574102 Escrow W&S Revenue Bonds, Series C 5,106,603.95 Wells Fargo 4827855883 Choice IV with Interest-Public Funds 11,763,233.16 Wells Fargo 4827855875 Choice IV with Interest-Public Funds 10,002,416.73 Total of Bank Balances $ 76,941,839.79 Pledged Collateral for City 102,686,430.62 FDIC Insurance 500,000.00 $ 103,186,430.62 Over(Under) Collateralized $ 26,244,590.83 Total %Collateralized 134.1% Bank Account Number Account Name Amount Wells Fargo 100-7284258 Development Authority 926,809.26 Total of Bank Balances $ 926,809.26 Pledged Collateral for DAP 766,939.24 FDIC Insurance 250,000.00 $ 1,016,939.24 Over(Under) Collateralized $ 90,129.98 Total % Collateralized 109.7% Total % Collateralized 133.8% Page 39 of 39 Status Collateralized