Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2019-206 2019-08-26
RESOLUTION NO. R2019-206 A Resolution of the City Council of the City of Pearland, Texas, accepting • the City's Investment Report for the quarter ending June 2019. 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 2019. PASSED, APPROVED, AND ADOPTED this 26th day of August, A.D., 2019. soltreIN s __)4)7? TOM REID j\ MAYOR ATTEST: Sitt0,4-1L " 1 b MARIA RODRIGUEZ INTERIM CITY SECRETARY APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY City of Pearland "' Quarterly Investment Report A-RL-N9 March 31, 2019 to June 30, 2019 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/2019 220,824,035.18 221,050,757.67 -226,722.49 2.34 2.43 420,639.00 87 5/31/2019 209,603,383.49 209,773,596.38 -170,212.89 2.32 2.34 432,503.22 84 6/30/2019 205,778,441.79 205,886,176.92 -107,735.13 2.28 2.00 390,803.00 78 Total/Average 212,068,620.15 212,236,843.66 -168,223.50 2.31 2.26 1,243,945.22 83 lir ..A.Srn ;u, a7 ? f ' ►bcdLO 413 J lir Cynthia Pearson, Diree or of Finance Date Rhonda Daugherty,Assitlant Dirett6r of Finance Date 4ais liq Shamaira Jagr ,Treasury Analyst Date City of Pearland liii-ABWAS Distribution by Security Type - Book Value Report Group: Pearland Begin Date:3/31/2019,End Date:6/30/2019 Security Type Allocation Book Value %of Portfolio Book Value %of Portfolio Security Type 3/31/2019 3/31/2019 6/30/2019 6/30/2019 Cash 82,136,799.65 36.68 81,319,171.46 39.50 Certificate Of Deposit 15,122,000.00 6.75 13,634,000.00 6.62 Compound CD 508,192.94 0.23 15,043,407.49 7.31 FAMC Bond 7,000,984.11 3.13 7,000,618.22 3.40 FFCB Bond 1,000,000.00 0.45 1,000,000.00 0.49 FHLB Bond 3,999,585.10 1.79 1,999,796.11 0.97 FHLMC Bond 3,688,434.82 1.65 3,689,651.07 1.79 FNMA Bond 1,010,564.30 0.45 1,009,064.74 0.49 Local Government Investment Pool 109,469,663.55 48.88 81,190,467.83 39.43 Total/Average 223,936,224.47 100.00 205,886,176.92 100.00 Portfolio Holdings as of 3/31/2019 Portfolio Holdings as of 6/30/2019 • 36.68%-Cash • 39.5%-Cash 6.75%-Certificate Of... 6.62%-Certificate Of... 0.23% Compound CD 1 • 7.3 1%-Compound CD 1 • 3.13%-FAMC Bond + 3.4%-FAMC Bond ......._.,,,,dor_ , • 0.45% FFCB Bond010r 0.49% FFCB Bond 1.79% FHLB Bond i 0.97%-FHLB Bond 10 1.65%-FHLMC Bond • 1.79%-FHLMC Bond 1 • 0.4 Bond • 0.49%-FNMA Bond i 48.88%-Local Governm...' • 39.43%-Local Governm... Prepared by Shamaira Jagrup 1 of 1 Al*, City of Pearland kettR AR Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date:3/31/2019,End Date:6/30/2019 Maturity Range Allocation Book Value %of Portfolio Book Value %of Portfolio Maturity Range 3/31/2019 3/31/2019 6/30/2019 6/30/2019 0-1 Month 191,854,463.20 85.67 163,250,639.29 79.29 1-3 Months 2,748,192.94 1.23 5,743,894.33 2.79 3-6 Months 6,484,851.43 2.90 2,728,000.00 1.33 6-9 Months 2,480,000.00 1.11 9,006,309.05 4.37 9-12 Months 5,232,717.78 2.34 6,013,618.44 2.92 1-2 Years 8,231,564.30 3.68 14,966,064.74 7.27 2-3 Years 6,904,434.82 3.08 4,177,651.07 2.03 Total/Average 223,936,224.47 100.00 205,886,176.92 100.00 Portfolio Holdings 200,000 180,000 - 160,000 ,,, 140,000 - c 120,000 - o • 100,000 0 3/31/2019 I- 80,000 - le 6/30/2019 c - 60,000 - 40,000 - 20,000 00 � _._ simmemiim , MM. IMNMia 0-1 Month 1-3 Months 3-6 Months 6-9 Months 9-12 Months 1-2 Years 2-3 Years Prepared by Shamaira Jagrup 1 of 1 rF City of Pearland iiiialitabil Total Rate of Return - Book Value by Month `'` °" Report Group: Pearland Begin Date:7/31/2018,End Date:6/30/2019 Beginning BV+ Interest Earned Realized Investment Average Capital Annualized Treasury 1 Month Accrued Interest During Period-BV Gain/Loss-By Income-BV Base-BV TRR-BV TRR-BV Year 7/31/2018 201,993,950.82 315,094.20 0.00 315,094.20 199,935,031.87 0.16 1.91 2.39 8/31/2018 198,281,062.39 313,551.17 0.00 313,551.17 185,048,204.52 0.17 2.05 2.45 9/30/2018 174,660,436.69 283,238.88 0.00 283,238.88 189,836,699.79 0.15 1.81 2.56 10/31/2018 203,084,394.91 377,409.86 0.00 377,409.86 202,357,061.66 0.19 2.26 2.65 11/30/2018 203,128,606.55 349,766.33 0.00 349,766.33 202,934,419.32 0.17 2.09 2.70 12/31/2018 202,145,723.57 402,422.24 0.00 402,422.24 217,611,692.18 0.18 2.24 2.66 1/31/2019 230,840,491.15 458,546.59 0.00 458,546.59 238,851,349.56 0.19 2.33 2.58 2/28/2019 245,314,107.68 427,343.46 0.00 427,343.46 236,179,061.59 0.18 2.19 2.55 3/31/2019 227,434,896.03 427,655.70 0.00 427,655.70 226,531,402.89 0.19 2.29 2.49 4/30/2019 224,021,812.75 420,639.00 0.00 420,639.00 214,328,263.42 0.20 2.38 2.43 5/31/2019 221,152,712.96 432,503.22 0.00 432,503.22 214,548,255.11 0.20 2.45 2.34 6/30/2019 209,887,022.59 390,803.00 0.00 390,803.00 208,783,877.45 0.19 2.27 2.00 Annualized TRR-BV 3.00 - 2.50 - 2.00 w � �k ! Portfolio 1.50 ` _° Treasury 1 111 r < Year 1,00 '4r ,Aal �� i 1-', . ,:,,,i,r.0,50 - t ? to 0.00 4-, 07/2018 08/2018 09/2018 10/2018 11/2018 12/2018 01/2019 02/2019 03/2019 04/2019 05/2019 06/2019 Prepared by Shamaira Jagrup 1 of 1 ,ze City of Pearland DMOa Portfolio Holdings by Security Type `'' I0' Report Group: Pearland Date:6/30/2019 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 Cash Wells Fargo Cash 7/21/2010 622,926.04 100.00 622,926.04 0.3% None 1 WF9871 622,926.04 0.75 622,926.04 0.75 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 745,601.84 100.00 745,601.84 0.36% None 1 WFSWEEP 745,601.84 2.26 745,601.84 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,720,608.07 100.00 2,720,608.07 1.32% None 1 WFSWEEP 2,720,608.07 2.26 2,720,608.07 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 154,231.71 100.00 154,231.71 0.07% None 1 WFSWEEP 154,231.71 2.26 154,231.71 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 609,596.80 100.00 609,596.80 0.3% None 1 WFSWEEP 609,596.80 2.26 609,596.80 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 46,647.26 100.00 46,647.26 0.02% None 1 WFSWEEP 46,647.26 2.26 46,647.26 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,040,337.76 100.00 1,040,337.76 0.51% None 1 WFSWEEP 1,040,337.76 2.26 1,040,337.76 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 994,677.29 100.00 994,677.29 0.48% None 1 WFSWEEP 994,677.29 2.26 994,677.29 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 18,984.20 100.00 18,984.20 0.01% None 1 WFSWEEP 18,984.20 2.26 18,984.20 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 788,262.80 100.00 788,262.80 0.38% None 1 WFSWEEP 788,262.80 2.26 788,262.80 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 29,845.24 100.00 29,845.24 0.01% None 1 WFSWEEP 29,845.24 2.26 29,845.24 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 24,602,393.13 100.00 24,602,393.13 11.95% None 1 WFSWEEP 24,602,393.13 2.26 24,602,393.13 2.26 0.00 None 0 Prepared by Shamaira Jagrup 1 of 12 a' r`4City of Pearland a lititiedia Portfolio Holdings by Security Type `'' Report Group: Pearland Date:6/30/2019 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 Sweep Cash 5/31/2006 1,253,688.36 100.00 1,253,688.36 0.61% None 1 WFSWEEP 1,253,688.36 2.26 1,253,688.36 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 152,646.58 100.00 152,646.58 0.07% None 1 WFSWEEP 152,646.58 2.26 152,646.58 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 7,099.96 100.00 7,099.96 0% None 1 WFSWEEP 7,099.96 2.26 7,099.96 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 127,367.44 100.00 127,367.44 0.06% None 1 WFSWEEP 127,367.44 2.26 127,367.44 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,549,849.83 100.00 2,549,849.83 1.24% None 1 WFSWEEP 2,549,849.83 2.26 2,549,849.83 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 37,851.86 100.00 37,851.86 0.02% None 1 WFSWEEP 37,851.86 2.26 37,851.86 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 482,906.52 100.00 482,906.52 0.23% None 1 WFSWEEP 482,906.52 2.26 482,906.52 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 78,783.64 100.00 78,783.64 0.04% None 1 WFSWEEP 78,783.64 2.26 78,783.64 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 12,047.14 100.00 12,047.14 0.01% None 1 WFSWEEP 12,047.14 2.26 12,047.14 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 191,261.44 100.00 191,261.44 0.09% None 1 WFSWEEP 191,261.44 2.26 191,261.44 2.26 0.00 None 0 Wells Fargo Sweep Cash 6/30/2006 53,910.60 100.00 53,910.60 0.03% None 1 WFSWEEP 53,910.60 2.26 53,910.60 2.26 0.00 None 0 Wells Fargo Sweep Cash 10/31/2006 -84,579.92 100.00 -84,579.92 -0.04% None 1 WFSWEEP -84,579.92 2.26 -84,579.92 2.26 0.00 None 0 Wells Fargo Sweep Cash 12/1/2006 299,888.43 100.00 299,888.43 0.15% None 1 WFSWEEP 299,888.43 2.26 299,888.43 2.26 0.00 None 0 Prepared by Shamaira Jagrup 2 of 12 4 ot rF",<, City of Pearland Iiiinfail Portfolio Holdings by Security Type `'' ,A9' Report Group: Pearland Date:6/30/2019 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 Sweep Cash 9/1/2007 30,065.44 100.00 30,065.44 0.01% None 1 WFSWEEP 30,065.44 2.26 30,065.44 2.26 0.00 None 0 Wells Fargo Sweep Cash 12/31/2007 4,226,978.90 100.00 4,226,978.90 2.05% None 1 WFSWEEP 4,226,978.90 2.26 4,226,978.90 2.26 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 341,343.18 100.00 341,343.18 0.17% None 1 WFSWEEP 341,343.18 2.26 341,343.18 2.26 0.00 None 0 Wells Fargo Sweep Cash 9/15/2009 39,178.63 100.00 39,178.63 0.02% None 1 WFSWEEP 39,178.63 2.26 39,178.63 2.26 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,710,857.84 100.00 2,710,857.84 1.32% None 1 WFSWEEP 2,710,857.84 2.26 2,710,857.84 2.26 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 165,033.30 100.00 165,033.30 0.08% None 1 WFSWEEP 165,033.30 2.26 165,033.30 2.26 0.00 None 0 Wells Fargo Sweep Cash 2/1/2013 25,447.93 100.00 25,447.93 0.01% None 1 WFSWEEP 25,447.93 2.26 25,447.93 2.26 0.00 None 0 Wells Fargo Sweep Cash 11/15/2015 1,442.68 100.00 1,442.68 0% None 1 WFSWEEP 1,442.68 2.26 1,442.68 2.26 0.00 None 0 Wells Fargo Sweep Cash 10/15/2018 1,145,207.92 100.00 1,145,207.92 0.56% None 1 WFSWEEP 1,145,207.92 2.26 1,145,207.92 2.26 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 10,292,754.79 100.00 10,292,754.79 5% None 1 WF5875 10,292,754.79 2.26 10,292,754.79 2.26 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 82,915.72 100.00 82,915.72 0.04% None 1 WF4094 82,915.72 2.26 82,915.72 2.26 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 8,647,209.07 100.00 8,647,209.07 4.2% None 1 WF6624 8,647,209.07 2.26 8,647,209.07 2.26 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 3,969,219.98 100.00 3,969,219.98 1.93% None 1 WF4102 3,969,219.98 2.26 3,969,219.98 2.26 0.00 None 0 Prepared by Shamaira Jagrup 3 of 12 r.,4rf City of Pearland O, r fa tr19 Portfolio Holdings by Security Type t'{f. IA9' Report Group: Pearland Date:6/30/2019 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 12,104,682.06 100.00 12,104,682.06 5.88% None 1 WF5883 12,104,682.06 2.26 12,104,682.06 2.26 0.00 None 0 81,319,171.46 81,319,171.46 39.49% 1 Sub Total Cash 81,319,171.46 2.25 81,319,171.46 2.25 0.00 0 Certificate Of Deposit 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 98.32 243,837.06 0.12% None 572 33625CAZ2 248,000.00 1.10 248,000.00 2.20 59.79 -4,162.94 None 1.55 1st Source Bank 1.5 11/18/2019 4/17/2015 248,000.00 99.90 247,752.85 0.12% None 141 33646CEQ3 248,000.00 1.50 248,000.00 1.76 754.19 -247.15 None 0.38 Ally Bank Midvale Utah 1.8 6/29/2020 6/29/2017 248,000.00 99.63 247,082.18 0.12% None 365 02006L3U5 248,000.00 1.80 248,000.00 2.18 12.23 -917.82 None 0.99 Alma Bank 1.35 12/24/2020 6/24/2016 248,000.00 98.77 244,955.79 0.12% None 543 020080682 248,000.00 1.35 248,000.00 2.19 55.04 -3,044.21 None 1.47 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 98.59 244,510.44 0.12% None 743 02554BCM1 248,000.00 1.35 248,000.00 2.06 174.28 -3,489.56 None 2.01 Bank Leumi USA 1.3 2/26/2020 3/3/2016 248,000.00 99.80 247,508.53 0.12% None 241 063248FH6 248,000.00 1.30 248,000.00 1.60 1,095.28 -491.47 None 0.65 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 98.81 245,061.08 0.12% None 731 063847AL1 248,000.00 1.40 248,000.00 2.01 0.00 -2,938.92 None 1.97 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 100.08 248,207.57 0.12% None 453 06610QCV1 248,000.00 1.80 248,000.00 1.73 61.15 207.57 None 1.22 Bankwest,Inc.1.5 1/3/2020 3/4/2015 248,000.00 99.68 247,214.12 0.12% None 187 06652CFA4 248,000.00 1.50 248,000.00 2.13 275.18 -785.88 None 0.51 Bar Harbor Bank&Trust 2.65 3/29/2021-18 3/29/2018 248,000.00 100.03 248,067.11 0.12% None 29 066851 WB8 248,000.00 2.65 248,000.00 2.63 18.01 67.11 None 1.71 Prepared by Shamaira Jagrup 4 of 12 ;o` °E"•<,a City of Pearland 6.Maga Portfolio Holdings by Security Type `s` .""' Report Group: Pearland Date:6/30/2019 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 Belmont Savings Bank 1.85 10/23/2019 12/23/2014 248,000.00 99.95 247,870.34 0.12% None 115 080515BD0 248,000.00 1.85 248,000.00 2.02 87.99 -129.66 None 0.31 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 99.81 247,529.90 0.12% None 355 05580ABX1 248,000.00 2.10 248,000.00 2.30 156.95 -470.10 None 0.96 Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 98.43 244,094.93 0.12% None 731 099703EF3 248,000.00 1.40 248,000.00 2.21 0.00 -3,905.07 None 1.97 Brickell Bank Miami FL 1.65 10/28/2019 6/27/2017 248,000.00 99.83 247,567.36 0.12% None 120 10801 DAG6 248,000.00 1.65 248,000.00 2.19 22.42 -432.64 None 0.33 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 99.22 246,061.33 0.12% None 724 12325EHU9 248,000.00 1.80 248,000.00 2.20 85.61 -1,938.67 None 1.95 Capital One Bank USA 1.1 11/19/2019 11/19/2014 248,000.00 99.97 247,935.24 0.12% None 142 140420QX1 248,000.00 1.10 248,000.00 1.17 313.91 -64.76 None 0.39 • Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 100.09 248,232.39 0.12% None 453 14042RAB7 248,000.00 2.30 248,000.00 2.22 1,515.86 232.39 None 1.22 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 99.08 245,728.79 0.12% None 393 144153AW3 248,000.00 1.10 248,000.00 1.96 22.42 -2,271.21 None 1.07 Cedar Rapids Bank&Trust 1.5 10/30/2019 1/30/2015 248,000.00 99.99 247,971.95 0.12% None 122 150517CJ7 248,000.00 1.50 248,000.00 1.53 295.56 -28.05 None 0.33 Charter Bank 1.7 2/25/2020 2/25/2015 248,000.00 99.70 247,255.61 0.12% None 240 161164BE7 248,000.00 1.70 248,000.00 2.16 57.75 -744.39 None 0.65 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248,000.00 99.98 247,945.10 0.12% None 142 17284C3Z5 248,000.00 2.10 248,000.00 2.15 599.28 -54.90 None 0.39 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 98.82 245,064.12 0.12% None 731 203507BG2 248,000.00 1.50 248,000.00 2.11 0.00 -2,935.88 None 1.97 Community Bankers'Bank 1.4 6/30/2021 6/30/2016 248,000.00 98.81 245,061.08 0.12% None 731 20361LBR4 248,000.00 1.40 248,000.00 2.01 0.00 -2,938.92 None 1.97 Prepared by Shamaira Jagrup 5 of 12 ;� d r o ,,,,o. CityCity of Pearland 4, C litiatthkal Portfolio Holdings by Security Type `' ,""' Report Group: Pearland Date:6/30/2019 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 Discover Bank 2 2/25/2020 2/25/2015 248,000.00 99.89 247,738.61 0.12% None 240 254672JA7 248,000.00 2.00 248,000.00 2.16 1,698.63 -261.39 None 0.65 EVB Tappa Hannock VA 1.6 9/25/2019 9/25/2015 248,000.00 99.95 247,882.51 0.12% None 87 26927ABK7 248,000.00 1.60 248,000.00 1.79 1,054.51 -117.49 None 0.24 Exchange Bank NEB 1.05 1/21/2020 7/20/2016 248,000.00 99.39 246,497.79 0.12% None 205 301074CH1 248,000.00 1.05 248,000.00 2.14 71.34 -1,502.21 None 0.56 First Business Bank 1.7 6/30/2020 9/30/2015 248,000.00 99.53 246,824.39 0.12% None 366 31938QP40 248,000.00 1.70 248,000.00 2.18 1,062.66 -1,175.61 None 0.99 First Capital Bank 1.4 8/6/2019 4/6/2015 248,000.00 99.95 247,878.86 0.12% None 37 31944FBK5 248,000.00 1.40 248,000.00 1.89 228.30 -121.14 None 0.1 First Financial NW 1.35 10/30/2019 10/30/2015 248,000.00 99.72 247,311.07 0.12% None 122 32022MAF5 248,000.00 1.35 248,000.00 2.19 0.00 -688.93 None 0.33 First Intl Bank&Trust 1.6 1/16/2020 10/16/2015 248,000.00 99.71 247,285.11 0.12% None 200 32057GAE9 248,000.00 1.60 248,000.00 2.13 152.20 -714.89 None 0.54 First National Bank of America 1.25 7/15/2016 248,000.00 98.10 243,280.15 0.12% None 746 7/15/2021 32110YHMO 248,000.00 1.25 248,000.00 2.21 1,409.86 -4,719.85 None 2.01 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 98.82 245,064.12 0.12% None 731 36198JCC6 248,000.00 1.50 248,000.00 2.11 0.00 -2,935.88 None 1.97 Goldman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 99.89 247,738.61 0.12% None 240 38148JLL3 248,000.00 2.00 248,000.00 2.16 1,698.63 -261.39 None 0.65 Gulf Coast Bank&Trust 1.3 7/15/2021-17 7/15/2016 248,000.00 98.61 244,542.09 0.12% None 15 402194EX8 248,000.00 1.30 248,000.00 2.00 132.49 -3,457.91 None 2.01 JP Morgan Chase Bk NA Columbus 2.1 �_. 2/15/2017 245,000.00 99.85 244,637.04 0.12% None 15 2/15/2021-17 48126XVW2 245,000.00 2.10 245,000.00 2.19 211.44 -362.96 None 1.6 Prepared by Shamaira Jagrup 6 of 12 City of Pearland ffititItiasii Portfolio Holdings by Security Type ,, ,"'' Report Group: Pearland Date:6/30/2019 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 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 98.81 245,061.08 0.12% None 731 53362LAB0 248,000.00 1.40 248,000.00 2.01 275.86 -2,938.92 None 1.97 Machias Savings Bank 1.65 2/6/2020 2/6/2015 248,000.00 100.03 248,068.06 0.12% None 221 554479DS1 248,000.00 1.65 248,000.00 1.60 269.06 68.06 None 0.6 Mahopac Bank 1.45 7/30/2019 1/30/2015 248,000.00 99.98 247,955.01 0.12% None 30 560160AQ6 248,000.00 1.45 248,000.00 1.66 1,487.66 -44.99 None 0.08 Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 99.31 246,285.55 0.12% None 730 56817TAB7 248,000.00 1.80 248,000.00 2.15 12.23 -1,714.45 None 1.96 Marlin Business Bank 1.25 12/27/2019 6/29/2016 248,000.00 99.59 246,980.72 0.12% None 180 57116AMC9 248,000.00 1.25 248,000.00 2.09 8.49 -1,019.28 None 0.49 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 101.04 250,586.28 0.12% None 645 61747MS69 248,000.00 2.80 248,000.00 2.19 1,636.12 2,586.28 None 1.72 National Bank Commerce Superior 1.25 7/15/2016 248,000.00 98.61 244541.65 0.12% None 746 7/15/2021-17 633368E87 248,000.00 1.25 248,000.00 1.95 127.40 -3,458.35 None 2.02 Northern Bank&Trust MA 1.1 7/12/2019-17 7/12/2016 248,000.00 99.96 247,890.21 0.12% None 12 66476QBH0 248,000.00 1.10 248,000.00 2.44 590.44 -109.79 None 0.03 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 99.19 245,989.85 0.12% None 366 69413CFD6 248,000.00 1.25 248,000.00 2.07 0.00 -2,010.15 None 0.99 Parkside Finl Bank&Trust 1.3 7/19/2021-17 7/18/2016 248,000.00 98.60 244,520.45 0.12% None 18 70147ABX1 248,000.00 1.30 248,000.00 2.00 105.99 -3,479.55 None 2.03 Partners Bank 1.5 9/30/2019 3/30/2015 248,000.00 99.93 247,837.29 0.12% None 92 70212YAR3 248,000.00 1.50 248,000.00 1.76 0.00 -162.71 None 0.25 Pearland State Bank 0.9 7/24/2019 7/24/2018 245,000.00 100.00 245,000.00 0.12% None 24 700013947C 245,000.00 0.90 245,000.00 0.90 2,060.01 0.00 None 0.07 Prepared by Shamaira Jagrup 7 of 12 .V ^F p` 4.0e, City of Pearland lifitaida Portfolio Holdings by Security Type fJ 1. ,PQ} Report Group: Pearland Date:6/30/2019 Description Face Amount I 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 Peoples United Bank 1.9 11/19/2019 11/19/2014 248,000.00 99.97 247,926.22 0.12% None 142 71270QKM7 248,000.00 1.90 248,000.00 1.97 542.20 -73.78 None 0.39 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 98.83 245,088.03 0.12% None 725 73565NBQ5 248,000.00 1.40 248,000.00 2.00 57.07 -2,911.97 None 1.96 Quantum National Bank 1.2 9/18/2019-16 3/18/2016 248,000.00 99.78 247,462.51 0.12% None 80 74765JETI 248,000.00 1.20 248,000.00 2.20 97.84 -537.49 None 0.22 Sallie Mae Bank 2.15 11/19/2019 11/19/2014 248,000.00 99.97 247,935.02 0.12% None 142 795450VC6 248,000.00 2.15 248,000.00 2.21 613.55 -64.98 None 0.39 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 100.09 248,215.09 0.12% None 488 91330ABC0 248,000.00 1.65 248,000.00 1.58 0.00 215.09 None 1.32 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 98.60 244,522.34 0.12% None 743 92834CBW1 248,000.00 1.30 248,000.00 2.01 1,501.59 -3,477.66 None 2 Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 99.13 245,842.99 0.12% None 640 938828AC4 248,000.00 1.50 248,000.00 2.01 0.00 -2,157.01 None 1.73 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 98.84 245,128.68 0.12% None 718 9497485W3 248,000.00 1.75 248,000.00 2.35 154.58 -2,871.32 None 1.93 13,634,000.00 13,562,032.25 6.60000000000001% 354 Sub Total Certificate Of Deposit 13,634,000.00 1.57 13,634,000.00 2.02 22,923.05 -71,967.75 1.09 Compound CD East West Bank 2.54 5/4/2020 4/30/2019 5,021,618.44 100.00 5,021,618.44 2.44% None 309 CD5845 5,021,618.44 2.54 5,021,618.44 2.54 0.00 0.00 None 0.84 East West Bank 2.56 3/2/2020 4/30/2019 2,013,073.43 100.00 2,013,073.43 0.98% None 246 CD0940 2,013,073.43 2.56 2,013,073.43 2.56 0.00 0.00 None 0.67 East West Bank 2.56 3/2/2020 4/3D/2019 3,008,715.62 100.00 3,008,715.62 1.46% None 246 CD0940 3,008,715.62 2.56 3,008,715.62 2.56 0.00 0.00 None 0.67 Prepared by Shamaira Jagrup 8 of 12 hyo, A rr4+r'_ City of Pearland JB! ►iq Portfolio Holdings by Security Type ff r, 10% Report Group: Pearland Date:6/30/2019 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 Wallis Bank 2.539 8/3/2020 4/30/2019 5,000,000.00 100.00 5,000,000.00 2.43% None 400 CD26135 5,000,000.00 2.54 5,000,000.00 2.54 21,216.30 0.00 None 1.08 15,043,407.49 15,043,407.49 7.31% 318 Sub Total Compound CD 15,043,407.49 2.55 15,043,407.49 2.55 21,216.30 0.00 0.86 FAMC Bond FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 99.89 998,878.91 0.49% S&P-AA+ 53 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.27 5,333.33 -1,121.09 Moodys-Aaa 0.14 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 99.89 998,878.91 0.49% S&P-AA+ 53 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.27 5,333.33 -1,121.09 Moodys-Aaa 0.14 FAMC 1.5 8/22/2019 2/22/2017 2,001,700.00 99.89 1,997,757.82 0.97% S&P-AA+ 53 3132X0PV7 2,000,000.00 1.47 2,000,098.22 2.27 10,666.67 -2,340.40 Moodys-Aaa 0.14 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 99.56 995,604.48 0.49% Moodys-Aaa 239 3132X0PW5 1,000,000.00 1.63 1,000,260.00 2.36 5,862.50 -4,655.52 S&P-AA+ 0.65 FAMC 1.6752/24/2020 2/24/2017 1,001,200.00 99.56 995,604.48 0.49% Moodys-Aaa 239 3132X0PW5 1,000,000.00 1.63 1,000,260.00 2.36 5,862.50 -4,655.52 S&P-AA+ 0.65 FAMC 1.82 11/9/2020 11/9/2017 1,000,000.00 99.42 994,203.21 0.49% Moodys-Aaa 498 3132X0ZC8 1,000,000.00 1.82 1,000,000.00 2.26 2,578.33 -5,796.79 S&P-AA+ 1.34 7,004,100.00 6,980,927.81 3.42% 170 Sub Total FAMC Bond 7,000,000.00 1.57 7,000,618.22 2.29 35,636.66 -19,690.41 0.46 FFCB Bond FFCB 1.84 10/30/2020-18 10/30/2017 1,000,000.00 100.00 999,999.88 0.49% Moodys-Aaa 488 3133EHM26 1,000,000.00 1.84 1,000,000.00 1.84 3,066.67 -0.12 S&P-AA+ 1.32 1,000,000.00 999,999.88 0.49% 488 Sub Total FFCB Bond 1,000,000.00 1.84 1,000,000.00 1.84 3,066.67 -0.12 1.32 FHLB Bond FHLB 1 9/26/2019 9/22/2016 997,430.00 99.71 997,097.98 0.49% Moodys-Aaa 88 3130A9EP2 1,000,000.00 1.09 999,796.11 2.22 2,611.11 -2,698.13 S&P-AA+ 0.24 Prepared by Shamaira Jagrup 9 of 12 req °< City of Pearland I Portfolio Holdings by Security Type `'' ""T Report Group: Pearland Date:6/30/2019 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 FHLB 2.21/29/2021-19 1/29/2018 1,000,000.00 99.91 999,066.46 0.49% Moodys-Aaa 29 3130ADC26 1,000,000.00 2.20 1,000,000.00 2.26 9,227.78 -933.54 S&P-AA+ 1.55 1,997,430.00 1,996,164.44 0.98% 58 Sub Total FHLB Bond 2,000,000.00 1.64 1,999,796.11 2.24 11,838.89 -3,631.67 0.9 FHLMC Bond FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 98.58 985,783.99 0.48% Moodys-Aaa 774 3137EAEC9 1,000,000.00 1.37 995,038.34 1.81 4,156.25 -9,254.35 S&P-AA+ 2.09 FHLMC 2 11/20/2020-18 12/5/2017 1,000,000.00 100.01 1,000,139.92 0.49% Moodys-Aaa 51 3134GBW32 1,000,000.00 2.00 1,000,000.00 1.99 2,222.22 139.92 S&P-AA+ 1.37 FHLMC 2.2 12/8/2021-18 12/8/2017 1,000,000.00 100.05 1,000,517.94 0.49% Moodys-Aaa 70 3134GB4N9 1,000,000.00 2.20 1,000,000.00 2.18 1,344.44 517.94 S&P-AA+ 2.39 FHLMC Step 8/3/2021-18 3/9/2018 691,243.00 100.00 699,985.00 0.34% S&P-AA+ 34 3134GBA93 700,000.00 2.61 694,612.73 2.42 5,716.67 5,372.27 Moodys-Aaa 2.04 3,679,783.00 3,686,426.85 1.8% 248 Sub Total FHLMC Bond 3,700,000.00 2.00 3,689,651.07 2.07 13,439.58 -3,224.22 1.97 FNMA Bond FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 99.98 999,843.78 0.49% Moodys-Aaa 547 3135G0H55 1,000,000.00 1.25 1,009,064.74 1.89 104.17 -9,220.96 S&P-AA+ 1.48 1,025,880.00 999,843.78 0.49% 547 Sub Total FNMA Bond 1,000,000.00 1.25 1,009,064.74 1.89 104.17 -9,220.96 1.48 Local Government Investment Pool Texas Class LGIP 12/20/2016 5,929.89 100.00 5,929.89 0% None 1 TX-01-0615-0001 5,929.89 2.50 5,929.89 2.50 0.00 None 0 Texas Class LGIP 12/20/2016 15,446.34 100.00 15,446.34 0.01% None 1 TX-01-0615-0001 15,446.34 2.50 15,446.34 2.50 0.00 None 0 Texas Class LGIP 12/20/2016 10,736,014.02 100.00 10,736,014.02 5.21% None 1 TX-01-0615-0001 10,736,014.02 2.50 10,736,014.02 2.50 0.00 None 0 Prepared by Shamaira Jagrup 10 of 12 61 44® ,. City of Pearland 4.: liballiatill Portfolio Holdings by Security Type fl i0% Report Group: Pearland Date:6/30/2019 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 20,358,039.35 100.00 20,358,039.35 9.89% None 1 TX-01-0615-0001 20,358,039.35 2.50 20,358,039.35 2.50 0.00 None 0 Texas Class LGIP 1/15/2017 234,808.94 100.00 234,808.94 0.11% None 1 TX-01-0615-0001 234,808.94 2.50 234,808.94 2.50 0.00 None 0 Texas Class LGIP 1/15/2017 1,047,246.99 100.00 1,047,246.99 0.51% None 1 TX-01-0615-0001 1,047,246.99 2.50 1,047,246.99 2.50 0.00 None 0 Texas Class LGIP 1/15/2017 8,552,852.57 100.00 8,552,852.57 4.15% None 1 TX-01-0615-0001 8,552,852.57 2.50 8,552,852.57 2.50 0.00 None 0 Texas Class LGIP 5/15/2017 4,583,502.71 100.00 4,583,502.71 2.23% None 1 TX-01-0615-0001 4,583,502.71 2.50 4,583,502.71 2.50 0.00 None 0 Texas Class LGIP 5/15/2017 673,419.80 100.00 673,419.80 0.33% None 1 TX-01-0615-0001 673,419.80 2.50 673,419.80 2.50 0.00 None 0 Texas Class LGIP 5/15/2017 1,118,149.16 100.00 1,118,149.16 0.54% None 1 TX-01-0615-0001 1,118,149.16 2.50 1,118,149.16 2.50 0.00 None 0 Texas Class LGIP 9/15/2018 8,074,782.42 100.00 8,074,782.42 3.92% None 1 TX-01-0615-0005 8,074,782.42 2.50 8,074,782.42 2.50 0.00 None 0 Texas Class LGIP 9/15/2018 10,094,343.52 100.00 10,094,343.52 4.9% None 1 TX-01-0615-0004 10,094,343.52 2.50 10,094,343.52 2.50 0.00 None 0 Texas Class LGIP 9/15/2018 5,208,305.91 100.00 5,208,305.91 2.53% None 1 TX-01-0615-0004 5,208,305.91 2.50 5,208,305.91 2.50 0.00 None 0 Texas Class LGIP 9/15/2018 7,687,111.29 100.00 7,687,111.29 3.73% None 1 TX-01-0615-0006 7,687,111.29 2.50 7,687,111.29 2.50 0.00 None 0 TexSTAR LGIP 8/26/2016 1,158,928.85 100.00 1,158,928.85 0.56% S&P-AAA 1 02000-11110 1,158,928.85 2.38 1,158,928.85 2.38 0.00 None 0 TexSTAR LGIP 8/26/2016 1,641,586.07 100.00 1,641,586.07 0.8% S&P-AAA 1 02000-11110 1,641,586.07 2.38 1,641,586.07 2.38 0.00 None 0 Prepared by Shamaira Jagrup 11 of 12 Y,;a�r��.. `,:, .G City of Pearland t__-_!9 Portfolio Holdings by Security Type "' Report Group: Pearland Date:6/30/2019 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 81,190,467.83 81,190,467.83 39.42% 1 Sub Total Local Government Investment 81,190,467.83 2.50 81,190,467.83 2.50 0.00 0 Pool 205,894,239.78 205,778,441.79 100.00% 63 TOTAL PORTFOLIO 205,887,046.78 2.28 205,886,176.92 2.35 108,225.32 -107,735.13 0.21 Prepared by Shamaira Jagrup 12 of 12 ,'\ City of Pearland I Portfolio Holdings by Portfolio Name --- .1.14160,9v-° Report Group: Pearland Date:6/30/2019 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 100:General Fund Alma Bank 1.35 12/24/2020 6/24/2016 248,000.00 98.77 244,955.79 0.12% None 543 020080BB2 248,000.00 1.35 248,000.00 2.19 55.04 -3,044.21 None 1.47 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 98.59 244,510.44 0.12% None 743 02554BCM1 248,000.00 1.35 248,000.00 2.06 174.28 -3,489.56 None 2.01 Bank Leumi USA 1.3 2/26/2020 3/3/2016 248,000.00 99.80 247,508.53 0.12% None 241 063248FH6 248,000.00 1.30 248,000.00 1.60 1,095.28 -491.47 None 0.65 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 100.08 248,207.57 0.12% None 453 06610QCV1 248,000.00 1.80 248,000.00 1.73 61.15 207.57 None 1.22 Bar Harbor Bank&Trust 2.65 3/29/2021-18 3/29/2018 248,000.00 100.03 248,067.11 0.12% None 29 066851WB8 248,000.00 2.65 248,000.00 2.63 18.01 67.11 None 1.71 Belmont Savings Bank 1.85 10/23/2019 12/23/2014 248,000.00 99.95 247,870.34 0.12% None 115 080515BD0 248,000.00 1.85 248,000.00 2.02 87.99 -129.66 None 0.31 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 100.09 248,232.39 0.12% None 453 14042RAB7 248,000.00 2.30 248,000.00 2.22 1,515.86 232.39 None 1.22 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 99.08 245,728.79 0.12% None 393 144153AW3 248,000.00 1.10 248,000.00 1.96 22.42 -2,271.21 None 1.07 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248,000.00 99.98 247,945.10 0.12% None 142 17284C3Z5 248,000.00 2.10 248,000.00 2.15 599.28 -54.90 None 0.39 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 98.82 245,064.12 0.12% None 731 203507BG2 248,000.00 1.50 248,000.00 2.11 0.00 -2,935.88 None 1.97 Community Bankers'Bank 1.4 6/30/2021 6/30/2016 248,000.00 98.81 245,061.08 0.12% None 731 20361LBR4 248,000.00 1.40 248,000.00 2.01 0.00 -2,938.92 None 1.97 East West Bank 2.54 5/4/2020 4/30/2019 5,021,618.44 100.00 5,021,618.44 2.44% None 309 CD5845 5,021,618.44 2.54 5,021,618.44 2.54 0.00 0.00 None 0.84 Prepared by Shamaira Jagrup 1 of 14 City of Pearland ULA, Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2019 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 East West Bank 2.56 3/2/2020 4/30/2019 3,008,715.62 100.00 3,008,715.62 1.46% None 246 CD0940 3,008,715.62 2.56 3,008,715.62 2.56 0.00 0.00 None 0.67 Exchange Bank NEB 1.05 1/21/2020 7/20/2016 248,000.00 99.39 246,497.79 0.12% None 205 301074CH1 248,000.00 1.05 248,000.00 2.14 71.34 -1,502.21 None 0.56 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 99.56 995,604.48 0.49% Moodys-Aaa 239 3132X0PW5 1,000,000.00 1.63 1,000,260.00 2.36 5,862.50 -4,655.52 S&P-AA+ 0.65 FHLMC Step 8/3/2021-18 3/9/2018 691,243.00 100.00 699,985.00 0.34% S&P-AA+ 34 3134GBA93 700,000.00 2.61 694,612.73 2.42 5,716.67 5,372.27 Moodys-Aaa 2.04 JP Morgan Chase Bk NA Columbus 2.1 2/15/2017 245,000.00 99.85 244,637.04 0.12% None 15 2/15/2021-17 48126XVW2 245,000.00 2.10 245,000.00 2.19 211.44 -362.96 None 1.6 Machias Savings Bank 1.65 2/6/2020 2/6/2015 248,000.00 100.03 248,068.06 0.12% None 221 554479DS1 248,000.00 1.65 248,000.00 1.60 269.06 68.06 None 0.6 Mahopac Bank 1.45 7/30/2019 1/30/2015 248,000.00 99.98 247,955.01 0.12% None 30 560160AQ6 248,000.00 1.45 248,000.00 1.66 1,487.66 -44.99 None 0.08 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 101.04 250,586.28 0.12% None 645 61747MS69 248,000.00 2.80 248,000.00 2.19 1,636.12 2,586.28 None 1.72 Pearland State Bank 0.9 7/24/2019 7/24/2018 245,000.00 100.00 245,000.00 0.12% None 24 700013947C 245,000.00 0.90 245,000.00 0.90 2,060.01 0.00 None 0.07 Quantum National Bank 1.2 9/18/2019-16 3/18/2016 248,000.00 99.78 247,462.51 0.12% None 80 74765JETI 248,000.00 1.20 248,000.00 2.20 97.84 -537.49 None 0.22 Sallie Mae Bank 2.15 11/19/2019 11/19/2014 248,000.00 99.97 247,935.02 0.12% None 142 795450VC6 248,000.00 2.15 248,000.00 2.21 613.55 -64.98 None 0.39 Texas Class LGIP 5/15/2017 4,583,502.71 100.00 4,583,502.71 2.23% None 1 TX-01-0615-0001 4,583,502.71 2.50 4,583,502.71 2.50 0.00 None 0 Prepared by Shamaira Jagrup 2 of 14 rr. 'Q<, City of Pearland ilidaidal Portfolio Holdings by Portfolio Name `'' .00. Report Group: Pearland Date:6/30/2019 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 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 100.09 248,215.09 0.12% None 488 91330ABC0 248,000.00 1.65 248,000.00 1.58 0.00 215.09 None 1.32 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 98.60 244,522.34 0.12% None 743 92834CBW1 248,000.00 1.30 248,000.00 2.01 1,501.59 -3,477.66 None 2 Wallis Bank 2.539 8/3/2020 4/30/2019 5,000,000.00 100.00 5,000,000.00 2.43% None 400 CD26135 5,000,000.00 2.54 5,000,000.00 2.54 21,216.30 0.00 None 1.08 Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 99.13 245,842.99 0.12% None 640 938828AC4 248,000.00 1.50 248,000.00 2.01 0.00 -2,157.01 None 1.73 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 98.84 245,128.68 0.12% None 718 9497485W3 248,000.00 1.75 248,000.00 2.35 154.58 -2,871.32 None 1.93 Wells Fargo Sweep Cash 5/31/2006 2,720,608.07 100.00 2,720,608.07 1.32% None 1 WFSWEEP 2,720,608.07 2.26 2,720,608.07 2.26 0.00 None 0 27,724,887.84 27,705,036.39 13.47% 241 Sub Total 100:General Fund 27,732,444.84 2.30 27,727,317.57 2.39 44,527.97 -22,281.18 0.73 200:Debt Services 1st Source Bank 1.5 11/18/2019 4/17/2015 248,000.00 99.90 247,752.85 0.12% None 141 33646CEQ3 248,000.00 1.50 248,000.00 1.76 754.19 -247.15 None 0.38 Charter Bank 1.7 2/25/2020 2/25/2015 248,000.00 99.70 247,255.61 0.12% None 240 1611646E7 248,000.00 1.70 248,000.00 2.16 57.75 -744.39 None 0.65 Discover Bank 2 2/25/2020 2/25/2015 248,000.00 99.89 247,738.61 0.12% None 240 254672JA7 248,000.00 2.00 248,000.00 2.16 1,698.63 -261.39 None 0.65 First Capital Bank 1.4 8/6/2019 4/6/2015 248,000.00 99.95 247,878.86 0.12% None 37 31944FBK5 248,000.00 1.40 248,000.00 1.89 228.30 -121.14 None 0.1 Goldman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 99.89 247,738.61 0.12% None 240 38148JLL3 248,000.00 2.00 248,000.00 2.16 1,698.63 -261.39 None 0.65 Prepared by Shamaira Jagrup 3 of 14 oN r`4o 4 City of Pearland lifignitail Portfolio Holdings by Portfolio Name {, ,""' Report Group: Pearland Date:6/30/2019 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 Partners Bank 1.5 9/30/2019 3/30/2015 248,000.00 99.93 247,837.29 0.12% None 92 70212YAR3 248,000.00 1.50 248,000.00 1.76 0.00 -162.71 None 0.25 Texas Class LGIP 1/15/2017 8,552,852.57 100.00 8,552,852.57 4.15% None 1 TX-01-0615-0001 8,552,852.57 2.50 8,552,852.57 2.50 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,040,337.76 100.00 1,040,337.76 0.51% None 1 WFSWEEP 1,040,337.76 2.26 1,040,337.76 2.26 0.00 None 0 11,081,190.33 11,079,392.16 5.38% 23 Sub Total 200:Debt Services 11,081,190.33 2.37 11,081,190.33 2.41 4,437.50 -1,798.17 0.06 305: Hotel/Motel Occupancy Ally Bank Midvale Utah 1.8 6/29/2020 6/29/2017 248,000.00 99.63 247,082.18 0.12% None 365 02006L3U5 248,000.00 1.80 248,000.00 2.18 12.23 -917.82 None 0.99 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 98.81 245,061.08 0.12% None 731 063847AL1 248,000.00 1.40 248,000.00 2.01 0.00 -2,938.92 None 1.97 East West Bank 2.56 3/2/2020 4/30/2019 2,013,073.43 100.00 2,013,073.43 0.98% None 246 CD0940 2,013,073.43 2.56 2,013,073.43 2.56 0.00 0.00 None 0.67 First Intl Bank&Trust 1.6 1/16/2020 10/16/2015 248,000.00 99.71 247,285.11 0.12% None 200 32057GAE9 248,000.00 1.60 248,000.00 2.13 152.20 -714.89 None 0.54 Texas Class LGIP 5/15/2017 1,118,149.16 100.00 1,118,149.16 0.54% None 1 TX-01-0615-0001 1,118,149.16 2.50 1,118,149.16 2.50 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 994,677.29 100.00 994,677.29 0.48% None 1 WFSWEEP 994,677.29 2.26 994,677.29 2.26 0.00 None 0 4,869,899.88 4,865,328.25 2.36% 168 Sub Total 305:Hotel/Motel Occupancy 4,869,899.88 2.34 4,869,899.88 2.42 164.43 -4,571.63 0.46 310:Municipal Court Security Wells Fargo Sweep Cash 5/31/2006 37,851.86 100.00 37,851.86 0.02% None 1 WFSWEEP 37,851.86 2.26 37,851.86 2.26 0.00 None 0 Prepared by Shamaira Jagrup 4 of 14 , I'r City of Pearland giM4ktig Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2019 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 37,851.86 37,851.86 0.02% 1 Sub Total 310:Municipal Court Security 37,851.86 2.26 37,851.86 2.26 0.00 0 315:City Wide Donation Wells Fargo Sweep Cash 5/31/2006 152,646.58 100.00 152,646.58 0.07% None 1 WFSWEEP 152,646.58 2.26 152,646.58 2.26 0.00 None 0 152,646.58 152,646.58 0.07% 1 Sub Total 315:City Wide Donation 152,646.58 2.26 152,646.58 2.26 0.00 0 320:Court Technology Wells Fargo Sweep Cash 5/31/2006 18,984.20 100.00 18,984.20 0.01% None 1 WFSWEEP 18,984.20 2.26 18,984.20 2.26 0.00 None 0 18,984.20 18,984.20 0.01% 1 Sub Total 320:Court Technology 18,984.20 2.26 18,984.20 2.26 0.00 0 330: Park Donations Wells Fargo Sweep Cash 5/31/2006 78,783.64 100.00 78,783.64 0.04% None 1 WFSWEEP 78,783.64 2.26 78,783.64 2.26 0.00 None 0 78,783.64 78,783.64 0.04% 1 Sub Total 330:Park Donations 78,783.64 2.26 78,783.64 2.26 0.00 0 331:Tree Trust Fund Wells Fargo Sweep Cash 5/31/2006 482,906.52 100.00 482,906.52 0.23% None 1 WFSWEEP 482,906.52 2.26 482,906.52 2.26 0.00 None 0 482,906.52 482,906.52 0.23% 1 Sub Total 331:Tree Trust Fund 482,906.52 2.26 482,906.52 2.26 0.00 0 335:Police State Seizure Wells Fargo Sweep Cash 5/31/2006 127,367.44 100.00 127,367.44 0.06% None 1 WFSWEEP 127,367.44 2.26 127,367.44 2.26 0.00 None 0 127,367.44 127,367.44 0.06% 1 Sub Total 335:Police State Seizure 127,367.44 2.26 127,367.44 2.26 0.00 0 336:Federal Police Fund Prepared by Shamaira Jagrup 5 of 14 +°* Pr • r'rrO City of Pearland 6, { Portfolio Holdings by Portfolio Name `'r 4' Report Group: Pearland Date:6/30/2019 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 Sweep Cash 5/31/2006 154,231.71 100.00 154,231.71 0.07% None 1 WFSWEEP 154,231.71 2.26 154,231.71 2.26 0.00 None 0 154,231.71 154,231.71 0.07% 1 Sub Total 336:Federal Police Fund 154,231.71 2.26 154,231.71 2.26 0.00 0 340:Park&Rec Development Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 98.43 244,094.93 0.12% None 731 099703EF3 248,000.00 1.40 248,000.00 2.21 0.00 -3,905.07 None 1.97 Wells Fargo Sweep Cash 5/31/2006 1,253,688.36 100.00 1,253,688.36 0.61% None 1 WFSWEEP 1,253,688.36 2.26 1,253,688.36 2.26 0.00 None 0 1,501,688.36 1,497,783.29 0.73% 122 Sub Total 340:Park&Rec Development 1,501,688.36 2.12 1,501,688.36 2.25 0.00 -3,905.07 0.33 345:Sidewalk Fund Wells Fargo Sweep Cash 5/31/2006 12,047.14 100.00 12,047.14 0.01% None 1 WFSWEEP 12,047.14 2.26 12,047.14 2.26 0.00 None 0 12,047.14 12,047.14 0.01% 1 Sub Total 345:Sidewalk Fund 12,047.14 2.26 12,047.14 2.26 0.00 0 350:Grant Fund Wells Fargo Sweep Cash 5/31/2006 191,261.44 100.00 191,261.44 0.09% None 1 WFSWEEP 191,261.44 2.26 191,261.44 2.26 0.00 None 0 191,261.44 191,261.44 0.09% 1 Sub Total 350:Grant Fund 191,261.44 2.26 191,261.44 2.26 0.00 0 351:CDBG Fund Wells Fargo Sweep Cash 11/15/2015 1,442.68 100.00 1,442.68 0% None 1 WFSWEEP 1,442.68 2.26 1,442.68 2.26 0.00 None 0 1,442.68 1,442.68 0% 1 Sub Total 351:CDBG Fund 1,442.68 2.26 1,442.68 2.26 0.00 0 360:Traffic Impact Improvement Prepared by Shamaira Jagrup 6 of 14 'e '``'4a City of Pearland liMiliall Portfolio Holdings by Portfolio Name €3:. ."°" Report Group: Pearland Date:6/30/2019 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 Sweep Cash 5/31/2006 609,596.80 100.00 609,596.80 0.3% None 1 WFSWEEP 609,596.80 2.26 609,596.80 2.26 0.00 None 0 609,596.80 609,596.80 0.3% 1 Sub Total 360:Traffic Impact Improvement 609,596.80 2.26 609,596.80 2.26 0.00 0 365:Court Juvenile Mgmt Wells Fargo Sweep Cash 9/15/2009 39,178.63 100.00 39,178.63 0.02% None 1 WFSWEEP 39,178.63 2.26 39,178.63 2.26 0.00 None 0 39,178.63 39,178.63 0.02% 1 Sub Total 365:Court Juvenile Mgmt 39,178.63 2.26 39,178.63 2.26 0.00 0 370:Municipal Channel Texas Class LGIP 5/15/2017 673,419.80 100.00 673,419.80 0.33% None 1 TX-01-0615-0001 673,419.80 2.50 673,419.80 2.50 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 165,033.30 100.00 165,033.30 0.08% None 1 WFSWEEP 165,033.30 2.26 165,033.30 2.26 0.00 None 0 838,453.10 838,453.10 0.41% 1 Sub Total 370:Municipal Channel 838,453.10 2.45 838,453.10 2.45 0.00 0 380:Regional Detention Wells Fargo Sweep Cash 5/31/2006 29,845.24 100.00 29,845.24 0.01% None 1 WFSWEEP 29,845.24 2.26 29,845.24 2.26 0.00 None 0 29,845.24 29,845.24 0.01% 1 Sub Total 380:Regional Detention 29,845.24 2.26 29,845.24 2.26 0.00 0 500:Capital Projects Texas Class LGIP 1/15/2017 1,047,246.99 100.00 1,047,246.99 0.51% None 1 TX-01-0615-0001 1,047,246.99 2.50 1,047,246.99 2.50 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,549,849.83 100.00 2,549,849.83 1.24% None 1 WFSWEEP 2,549,849.83 2.26 2,549,849.83 2.26 0.00 None 0 3,597,096.82 3,597,096.82 1.75% 1 Sub Total 500:Capital Projects 3,597,096.82 2.33 3,597,096.82 2.33 0.00 0 Prepared by Shamaira Jagrup 7 of 14 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2019 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 501: Certificates of Obligation 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 98.32 243,837.06 0.12% None 572 33625CAZ2 248,000.00 1.10 248,000.00 2.20 59.79 -4,162.94 None 1.55 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 99.89 998,878.91 0.49% S&P-AA+ 53 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.27 5,333.33 -1,121.09 Moodys-Aaa 0.14 FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 98.58 985,783.99 0.48% Moodys-Aaa 774 3137EAEC9 1,000,000.00 1.37 995,038.34 1.81 4,156.25 -9,254.35 S&P-AA+ 2.09 FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 99.98 999,843.78 0.49% Moodys-Aaa 547 3135G0H55 1,000,000.00 1.25 1,009,064.74 1.89 104.17 -9,220.96 S&P-AA+ 1.48 Gulf Coast Bank&Trust 1.3 7/15/2021-17 7/15/2016 248,000.00 98.61 244,542.09 0.12% None 15 402194EX8 248,000.00 1.30 248,000.00 2.00 132.49 -3,457.91 None 2.01 Marlin Business Bank 1.25 12/27/2019 6/29/2016 248,000.00 99.59 246,980.72 0.12% None 180 57116AMC9 248,000.00 1.25 248,000.00 2.09 8.49 -1,019.28 None 0.49 Texas Class LGIP 12/20/2016 5,929.89 100.00 5,929.89 0% None 1 TX-01-0615-0001 5,929.89 2.50 5,929.89 2.50 0.00 None 0 Texas Class LGIP 9/15/2018 7,687,111.29 100.00 7,687,111.29 3.73% None 1 TX-01-0615-0006 7,687,111.29 2.50 7,687,111.29 2.50 0.00 None 0 TexSTAR LGIP 8/26/2016 1,158,928.85 100.00 1,158,928.85 0.56% S&P-AAA 1 02000-11110 1,158,928.85 2.38 1,158,928.85 2.38 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 46,647.26 100.00 46,647.26 0.02% None 1 WFSWEEP 46,647.26 2.26 46,647.26 2.26 0.00 None 0 12,657,037.29 12,618,483.84 6.13% 124 Sub Total 501:Certificates of Obligation 12,642,617.29 2.14 12,646,720.37 2.34 9,794.52 -28,236.53 0.37 503:Certificates of Obligation 2006 Wells Fargo Sweep Cash 6/30/2006 53,910.60 100.00 53,910.60 0.03% None 1 WFSWEEP 53,910.60 2.26 53,910.60 2.26 0.00 None 0 Prepared by Shamaira Jagrup 8 of 14 <.Q City of Pearland [tit Portfolio Holdings by Portfolio Name rt. ,� Report Group: Pearland Date:6/30/2019 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 53,910.60 53,910.60 0.03% 1 Sub Total 503:Certificates of Obligation 53,910.60 2.26 53,910.60 2.26 0.00 0 2006 506:General Obligation Brickell Bank Miami FL 1.65 10/28/2019 6/27/2017 248,000.00 99.83 247,567.36 0.12% None 120 10801DAG6 248,000.00 1.65 248,000.00 2.19 22.42 -432.64 None 0.33 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 99.22 246,061.33 0.12% None 724 12325EHU9 248,000.00 1.80 248,000.00 2.20 85.61 -1,938.67 None 1.95 Capital One Bank USA 1.1 11/19/2019 11/19/2014 248,000.00 99.97 247,935.24 0.12% None 142 140420QX1 248,000.00 1.10 248,000.00 1.17 313.91 -64.76 None 0.39 FHLB 1 9/26/2019 9/22/2016 997,430.00 99.71 997,097.98 0.49% Moodys-Aaa 88 3130A9EP2 1,000,000.00 1.09 999,796.11 2.22 2,611.11 -2,698.13 S&P-AA+ 0.24 First Business Bank 1.7 6/30/2020 9/30/2015 248,000.00 99.53 246,824.39 0.12% None 366 31938QP40 248,000.00 1.70 248,000.00 2.18 1,062.66 -1,175.61 None 0.99 First National Bank of America 1.25 7/15/2016 248,000.00 98.10 243,280.15 0.12% None 746 7/15/2021 32110YHMO 248,000.00 1.25 248,000.00 2.21 1,409.86 -4,719.85 None 2.01 • Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 98.81 245,061.08 0.12% None 731 53362LAB0 248,000.00 1.40 248,000.00 2.01 275.86 -2,938.92 None 1.97 National Bank Commerce Superior 1.25 7/15/2016 248,000.00 98.61 244,541.65 0.12% None 746 7/15/2021-17 633368EB7 248,000.00 1.25 248,000.00 1.95 127.40 -3,458.35 None 2.02 Peoples United Bank 1.9 11/19/2019 11/19/2014 248,000.00 99.97 247,926.22 0.12% None 142 71270QKM7 248,000.00 1.90 248,000.00 1.97 542.20 -73.78 None 0.39 Texas Class LGIP 12/20/2016 15,446.34 100.00 15,446.34 0.01% None 1 TX-01-0615-0001 15,446.34 2.50 15,446.34 2.50 0.00 None 0 Texas Class LGIP 9/15/2018 8,074,782.42 100.00 8,074,782.42 3.92% None 1 TX-01-0615-0005 8,074,782.42 2.50 8,074,782.42 2.50 0.00 None 0 Prepared by Shamaira Jagrup 9 of 14 o`d rrae ,= City of Pearland ►fit i Portfolio Holdings by Portfolio Name `'` ,""' Report Group: Pearland Date:6/30/2019 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 1,641,586.07 100.00 1,641,586.07 0.8% S&P-AAA 1 02000-11110 1,641,586.07 2.38 1,641,586.07 2.38 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 341,343.18 100.00 341,343.18 0.17% None 1 WFSWEEP 341,343.18 2.26 341,343.18 2.26 0.00 None 0 13,054,588.01 13,039,453.41 6.35% 78 Sub Total 506:General Obligation 13,057,158.01 2.22 13,056,954.12 2.38 6,451.03 -17,500.71 0.21 550:WS Impact Fee Bankwest,Inc.1.5 1/3/2020 3/4/2015 248,000.00 99.68 247,214.12 0.12% None 187 06652CFA4 248,000.00 1.50 248,000.00 2.13 275.18 -785.88 None 0.51 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 99.81 247,529.90 0.12% None 355 05580ABX1 248,000.00 2.10 248,000.00 2.30 156.95 -470.10 None 0.96 Cedar Rapids Bank&Trust 1.5 10/30/2019 1/30/2015 248,000.00 99.99 247,971.95 0.12% None 122 150517CJ7 248,000.00 1.50 248,000.00 1.53 295.56 -28.05 None 0.33 EVB Tappa Hannock VA 1.6 9/25/2019 9/25/2015 248,000.00 99.95 247,882.51 0.12% None 87 26927ABK7 248,000.00 1.60 248,000.00 1.79 1,054.51 -117.49 None 0.24 FAMC 1.82 11/9/2020 11/9/2017 1,000,000.00 99.42 994,203.21 0.49% Moodys-Aaa 498 3132XOZC8 1,000,000.00 1.82 1,000,000.00 2.26 2,578.33 -5,796.79 S&P-AA+ 1.34 FFCB 1.84 10/30/2020-18 10/30/2017 1,000,000.00 100.00 999,999.88 0.49% Moodys-Aaa 488 3133EHM26 1,000,000.00 1.84 1,000,000.00 1.84 3,066.67 -0.12 S&P-AA+ 1.32 FHLB 2.2 1/29/2021-19 1/29/2018 1,000,000.00 99.91 999,066.46 0.49% Moodys-Aaa 29 3130ADC26 1,000,000.00 2.20 1,000,000.00 2.26 9,227.78 -933.54 S&P-AA+ 1.55 FHLMC 2 11/20/2020-18 12/5/2017 1,000,000.00 100.01 1,000,139.92 0.49% Moodys-Aaa 51 3134GBW32 1,000,000.00 2.00 1,000,000.00 1.99 2,222.22 139.92 S&P-AA+ 1.37 FHLMC 2.2 12/8/2021-18 12/8/2017 1,000,000.00 100.05 1,000,517.94 0.49% Moodys-Aaa 70 3134GB4N9 1,000,000.00 2.20 1,000,000.00 2.18 1,344.44 517.94 S&P-AA+ 2.39 Prepared by Shamaira Jagrup 10 of 14 fi',r` City of Pearland Iiiigakka Portfolio Holdings by Portfolio Name 'Sr. 0,o' Report Group: Pearland Date:6/30/2019 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 First Financial NW 1.35 10/30/2019 10/30/2015 248,000.00 99.72 247,311.07 0.12% None 122 32022MAF5 248,000.00 1.35 248,000.00 2.19 0.00 -688.93 None 0.33 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 99.19 245,989.85 0.12% None 366 69413CFD6 248,000.00 1.25 248,000.00 2.07 0.00 -2,010.15 None 0.99 Texas Class LGIP 12/20/2016 20,358,039.35 100.00 20,358,039.35 9.89% None 1 TX-01-0615-0001 20,358,039.35 2.50 20,358,039.35 2.50 0.00 None 0 Texas Class LGIP 9/15/2018 5,208,305.91 100.00 5,208,305.91 2.53% None 1 TX-01-0615-0004 5,208,305.91 2.50 5,208,305.91 2.50 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 788,262.80 . 100.00 788,262.80 0.38% None 1 WFSWEEP 788,262.80 2.26 788,262.80 2.26 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 82,915.72 100.00 82,915.72 0.04% None 1 WF4094 82,915.72 2.26 82,915.72 2.26 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 8,647,209.07 100.00 8,647,209.07 4.2% None 1 WF6624 8,647,209.07 2.26 8,647,209.07 2.26 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 3,969,219.98 100.00 3,969,219.98 1.93% None 1 WF4102 3,969,219.98 2.26 3,969,219.98 2.26 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 12,104,682.06 100.00 12,104,682.06 5.88% None 1 WF5883 12,104,682.06 2.26 12,104,682.06 2.26 0.00 None 0 57,646,634.89 57,636,461.70 28.02% 26 Sub Total 550:W/S Impact Fee 57,646,634.89 2.33 57,646,634.89 2.35 20,221.64 -10,173.19 0.15 555:Shadow Creek Impact FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 99.56 995,604.48 0.49% Moodys-Aaa 239 3132X0PW5 1,000,000.00 1.63 1,000,260.00 2.36 5,862.50 -4,655.52 S&P-AA+ 0.65 Wells Fargo Sweep Cash 5/31/2006 7,099.96 100.00 7,099.96 0% None 1 WFSWEEP 7,099.96 2.26 7,099.96 2.26 0.00 None 0 1,008,299.96 1,002,704.44 0.49% 237 Sub Total 555:Shadow Creek Impact 1,007,099.96 1.64 1,007,359.96 2.36 5,862.50 -4,655.52 0.65 Prepared by Shamaira Jagrup 11 of 14 `.` 1e City of Pearland WWI Portfolio Holdings by Portfolio Name 4.11 04% Report Group: Pearland Date:6/30/2019 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 565: Revenue Bonds 1999&2003 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 99.89 998,878.91 0.49% S&P-AA+ 53 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.27 5,333.33 -1,121.09 Moodys-Aaa 0.14 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 98.82 245,064.12 0.12% None 731 36198JCC6 248,000.00 1.50 248,000.00 2.11 0.00 -2,935.88 None 1.97 Texas Class LGIP 1/15/2017 234,808.94 100.00 234,808.94 0.11% None 1 TX-01-0615-0001 234,808.94 2.50 234,808.94 2.50 0.00 None 0 Texas Class LGIP 9/15/2018 10,094,343.52 100.00 10,094,343.52 4.9% None 1 TX-01-0615-0004 10,094,343.52 2.50 10,094,343.52 2.50 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 745,601.84 100.00 745,601.84 0.36% None 1 WFSWEEP 745,601.84 2.26 745,601.84 2.26 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 10,292,754.79 100.00 10,292,754.79 5% None 1 WF5875 10,292,754.79 2.26 10,292,754.79 2.26 0.00 None 0 22,615,509.09 22,611,452.12 10.98% 11 Sub Total 565:Revenue Bonds 1999& 22,615,509.09 2.33 22,615,509.09 2.37 5,333.33 -4,056.97 0.03 2003 570:W/S Pay As You Go Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 99.31 246,285.55 0.12% None 730 56817TAB7 248,000.00 1.80 248,000.00 2.15 12.23 -1,714.45 None 1.96 Wells Fargo Sweep Cash 12/31/2007 4,226,978.90 100.00 4,226,978.90 2.05% None 1 WFSWEEP 4,226,978.90 2.26 4,226,978.90 2.26 0.00 None 0 4,474,978.90 4,473,264.45 2.17% 41 Sub Total 570:W/S Pay As You Go 4,474,978.90 2.24 4,474,978.90 2.26 12.23 -1,714.45 0.11 575:MUD 4 Capital Programs Wells Fargo Sweep Cash 2/1/2013 25,447.93 100.00 25,447.93 0.01% None 1 WFSWEEP 25,447.93 2.26 25,447.93 2.26 0.00 None 0 25,447.93 25,447.93 0.01% 1 Sub Total 575:MUD 4 Capital Programs 25,447.93 2.26 25,447.93 2.26 0.00 0 Prepared by Shamaira Jagrup 12 of 14 A Pr If City of Pearland iitatall Portfolio Holdings by Portfolio Name `'' ,A°' Report Group: Pearland Date:6/30/2019 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 600:Water&Sewer FAMC 1.5 8/22/2019 2/22/2017 2,001,700.00 99.89 1,997,757.82 0.97% S&P-AA+ 53 3132X0PV7 2,000,000.00 1.47 2,000,098.22 2.27 10,666.67 -2,340.40 Moodys-Aaa 0.14 Northern Bank&Trust MA 1.1 7/12/2019-17 7/12/2016 248,000.00 99.96 247,890.21 0.12% None 12 66476QBH0 248,000.00 1.10 248,000.00 2.44 590.44 -109.79 None 0.03 Parkside Finl Bank&Trust 1.3 7/19/2021-17 7/18/2016 248,000.00 98.60 244,520.45 0.12% None 18 70147ABX1 248,000.00 1.30 248,000.00 2.00 105.99 -3,479.55 None 2.03 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 98.83 245,088.03 0.12% None 725 73565NBQ5 248,000.00 1.40 248,000.00 2.00 57.07 -2,911.97 None 1.96 Texas Class LGIP 12/20/2016 10,736,014.02 100.00 10,736,014.02 5.21% None 1 TX-01-0615-0001 10,736,014.02 2.50 10,736,014.02 2.50 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 24,602,393.13 100.00 24,602,393.13 11.95% None 1 WFSWEEP 24,602,393.13 2.26 24,602,393.13 2.26 0.00 None 0 38,084,107.15 38,073,663.66 18.49% 9 Sub Total 600:Water&Sewer 38,082,407.15 2.27 38,082,505.37 2.33 11,420.17 -8,841.71 0.03 610:Solidwaste Wells Fargo Sweep Cash 12/1/2006 299,888.43 100.00 299,888.43 0.15% None 1 WFSWEEP 299,888.43 2.26 299,888.43 2.26 0.00 None 0 299,888.43 299,888.43 0.15% 1 Sub Total 610:Solidwaste 299,888.43 2.26 299,888.43 2.26 0.00 0 700:Property Liability Ins Wells Fargo Sweep Cash 10/31/2006 -84,579.92 100.00 -84,579.92 -0.04% None 1 WFSWEEP -84,579.92 2.26 -84,579.92 2.26 0.00 None 0 -84,579.92 -84,579.92 -0.04% 1 Sub Total 700:Property Liability Ins -84,579.92 2.26 -84,579.92 2.26 0.00 0 701:Employee Benefit Fund Wells Fargo Sweep Cash 9/1/2007 30,065.44 100.00 30,065.44 0.01% None 1 WFSWEEP 30,065.44 2.26 30,065.44 2.26 0.00 None 0 Prepared by Shamaira Jagrup 13 of 14 a r 0 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2019 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 30,065.44 30,065.44 0.01% 1 Sub Total 701:Employee Benefit Fund 30,065.44 2.26 30,065.44 2.26 0.00 0 702:Health Claims Fund Wells Fargo Cash 7/21/2010 622,926.04 100.00 622,926.04 0.3% None 1 WF9871 622,926.04 0.75 622,926.04 0.75 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,710,857.84 100.00 2,710,857.84 1.32% None 1 WFSWEEP 2,710,857.84 2.26 2,710,857.84 2.26 0.00 None 0 3,333,783.88 3,333,783.88 1.62% 1 Sub Total 702:Health Claims Fund 3,333,783.88 1.98 3,333,783.88 1.98 0.00 0 703:Motor Pool Fund Wells Fargo Sweep Cash 10/15/2018 1,145,207.92 100.00 1,145,207.92 0.56% None 1 WFSWEEP 1,145,207.92 2.26 1,145,207.92 2.26 0.00 None 0 1,145,207.92 1,145,207.92 0.56% 1 Sub Total 703:Motor Pool Fund 1,145,207.92 2.26 1,145,207.92 2.26 0.00 0 205,894,239.78 205,778,441.79 100.00% 63 TOTAL PORTFOLIO 205,887,046.78 2.28 205,886,176.92 2.35 108,225.32 -107,735.13 0.21 Prepared by Shamaira Jagrup 14 of 14 City of Pearland apwakkig Treasury Yield Curve !J! wRx Treasury 3/31/2019 6/30/2019 1 Month 2.45 2.22 3 Month 2.45 2.22 6 Month 2.51 2.17 1 Year 2.49 2.00 2 Year 2.41 1.81 3 Year 2.37 1.78 5 Year 2.37 1.83 10 Year 2.57 2.07 3.00 2.50 2.00 1,50 •3/31/2019 •6/30/2019 1.00 0.50 0,00 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year Prepared by Shamaira Jagrup 1 of 1 Pledged Collateral Reconciliation Report June 30, 2019 Bank Account Number Account Name Amount Wells Fargo 8071613395 Credit Card Account - Wells Fargo 13042841 Sweep Account 48,756.00 * Wells Fargo 7169195455 False Alarm Reduction Program 286,012.28 Wells Fargo 8184567843 Alvin ISD 13,147,369.57 Wells Fargo 1790121790 EMS Payments - Wells Fargo 2807409871 Health Claims 622,926.04 Wells Fargo 3542574094 Escrow W&S Revenue Bonds,Series 2016B - * Wells Fargo 3542574102 Escrow W&S Revenue Bonds,Series 2016C - * Wells Fargo 4827855883 Texas Permanent W&S System Revenue 2017B - Wells Fargo 4827855875 Texas Permanent W&S System Revenue 2017A - * Wells Fargo 1382256624 Escrow W&S Revenue Bonds, Series 2018A - * Total of Bank Balances $ 14,105,063.89 Pledged Collateral for City 30,222,166.36 FDIC Insurance 500,000.00 $ 30,722,166.36 Over(Under)Collateralized $ 16,617,102.47 Total%Collateralized 217.8% Bank Account Number Account Name Amount Wells Fargo 1007284258 Development Authority 951,400.91 Total of Bank Balances $ 951,400.91 Pledged Collateral for DAP 759,932.99 FDIC Insurance 250,000.00 $ 1,009,932.99 Over(Under)Collateralized $ 58,532.08 Total%Collateralized 106.2% Total%Collateralized 210.8% Status Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral.