Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2019-273 2019-11-11
RESOLUTION NO. R2019-273 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending September 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 September 2019. PASSED, APPROVED, AND ADOPTED this 11th day of November, A.D., 2019. TOM REID MAYOR .3 ATTEST: • MARIA RODRI UEZ INTERIM CITY SECRETARY APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY City of Pearland Quarterly Investment Report June 30, 2019 to September 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 7/31/2019 203,030,548.47 203,114,765.51 -84,217.04 2.22 1.96 381,602.55 72 8/31/2019 217,189,317.13 217,211,817.82 -22,500.69 2.08 1.77 396,726.57 62 9/30/2019 231,737,970.28 231,766,578.25 -28,607.97 2.00 1.80 372,004.39 53 Total / Average 217,319,278.63 217,364,387.19 -45,108.57 2.10 1.84 1,150,333.51 62 tt...50)—) .144f7 66)(fht— 16(Z1 1 I Cynth Pearson, • ector of Finance Date Rhonda Daugherty, Assistan Director of Finance Date r Shamaira Jag p, reasury Analyst 1012 t 119 Date Note: This report reflects entries through Period 12, and does not include any year-end entries. Security Type City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Book Value 6/30/2019 Security Type Allocation % of Portfolio 6/30/2019 Begin Date: 6/30/2019, End Date: 9/30/2019 Book Value 9/30/2019 % of Portfolio 9/30/2019 Cash Certificate Of Deposit Compound CD FAMC Bond FFCB Bond FHLB Bond FHLMC Bond FNMA Bond Local Government Investment Pool 81,319,171.46 13,634,000.00 15,043,407.49 7,000,618.22 1,000,000.00 1,999,796.11 3,689,651.07 1,009,064.74 81,190,467.83 39.50 6.62 7.31 3.40 0.49 0.97 1.79 0.49 39.43 95,632,738.46 11,901,000.00 15,139,816.63 3,000,320.00 1,000,000.00 1,000,000.00 3,690,880.98 1,007,548.33 99,394,273.85 41.26 5.13 6.53 1.29 0.43 0.43 1.59 0.43 42.89 Total / Average 205,886,176.92 100.00 231,766,578.25 100.00 Portfolio Holdings as of 6/30/2019 • 39.5%-Cash 6.62%-Certificate Of... • 7.31%-Compound CD • 3.4%-FAMC Bond • 0.49%-FFCB Bond 0.97%-FHLB Bond • 1.79%-FHLMC Bond • 0.49%-FNMA Bond • 39.43%-Local Governm... Portfolio Holdings as of 9/30/2019 • 41.26%-Cash 5.13%-Certificate Of... • 6.53%-Compound CD • 1.29%-FAMC Bond • 0.43%-FFCB Bond 0.43%-FHLB Bond • 1.59%-FHLMC Bond • 0.43%-FNMA Bond • 42.89%-Local Governm... Prepared by Shamaira Jagrup 1 of 1 City of Pearland Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date: 6/30/2019, End Date: 9/30/2019 Maturity Range Allocation Book Value % of Portfolio Book Value % of Portfolio Maturity Range 6/30/2019 6/30/2019 9/30/2019 9/30/2019 0-1 Month 163,250,639.29 79.29 196,019,012.31 84.58 1-3 Months 5,743,894.33 2.79 1,488,000.00 0.64 3-6 Months 2,728,000.00 1.33 9,038,616.29 3.90 6-9 Months 9,006,309.05 4.37 5,301,869.79 2.29 9-12 Months 6,013,618.44 2.92 6,519,650.55 2.81 1-2 Years 14,966,064.74 7.27 12,399,429.31 5.35 2-3 Years 4,177,651.07 2.03 1,000,000.00 0.43 Total / Average 205,886,176.92 100.00 231,766,578.25 100.00 Portfolio Holdings 200,000 - 180,000 - 160,000 - ,,, 140,000 - 120,000 - c IA 0 100,000 - � 80,000 - • 6/30/2019 . 9/30/2019 c '" 60,000 - 40,000 - 20,000 - MIIIIMSlI INNII w.-I 0 0 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 City of Pearland Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date: 10/31/2018, End Date: 9/30/2019 Beginning BV + Interest Earned Realized Investment Average Capital Annualized Treasury 1 Month Accrued Interest During Period-BV Gain/Loss-BV Income-BV Base-BV TRR-BV TRR-BV Year 10/31/2018 11/30/2018 12/31/2018 1/31/2019 2/28/2019 3/31/2019 4/30/2019 5/31/2019 6/30/2019 7/31/2019 8/31/2019 9/30/2019 203,084,394.91 203,128,606.55 202,145,723.57 230,840,491.15 245,314,107.68 227,434,896.03 224,021,812.75 221,152,712.96 209,887,022.59 205,994,402.24 203,211,850.03 217,279,662.59 377,409.86 349,766.33 402,422.24 458,546.59 427, 343.46 427, 655.70 420,639.00 432,503.22 390,803.00 381,602.55 396,726.57 372,004.39 0.00 377,409.86 202,357,061.66 0.19 0.00 349,766.33 202,934,419.32 0.17 0.00 402,422.24 217,611,692.18 0.18 0.00 458,546.59 238,851,349.56 0.19 0.00 427,343.46 236,179,061.59 0.18 0.00 427,655.70 226,531,402.89 0.19 0.00 420,639.00 214,328,263.42 0.20 0.00 432,503.22 214,548,255.11 0.20 0.00 390,803.00 208,783,877.45 0.19 0.00 381,602.55 204,358,071.11 0.19 0.00 396,726.57 217,590,574.87 0.18 0.00 372,004.39 215,059,648.68 0.17 2.26 2.09 2.24 2.33 2.19 2.29 2.38 2.45 2.27 2.26 2.21 2.10 2.65 2.70 2.66 2.58 2.55 2.49 2.43 2.34 2.00 1.96 1.77 1.80 Annualized TRR-BV 3.00 - 2.50 - 2.00 1.50 1.00 0.50 - 0.00 10/2018 11/2018 12/2018 01/2019 02/2019 03/2019 04/2019 05/2019 06/2019 07/2019 08/2019 09/2019 • Portfolio Treasury 1 S Year Prepared by Shamaira Jagrup 1 of 1 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Shares Settlement Date YTM @ Cost Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Cash Wells Fargo Cash WF9871 375,533.06 7/21/2010 375,533.06 0.75 375,533.06 100.00 0.75 375,533.06 0.16% 0.00 None None 0 Wells Fargo Sweep Cash WFSWEEP 1,508,575.38 5/31/2006 1,508,575.38 100.00 1,508,575.38 0.65% None 1.81 1,508,575.38 1.81 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 123,137.83 100.00 123,137.83 0.05% None 123,137.83 1.81 123,137.83 1.81 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -334,525.04 100.00 -334,525.04 -0.14% None 1 WFSWEEP -334,525.04 1.81-334,525.04 1.81 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 WFSWEEP 963,308.26 1.81 963,308.26 100.00 963,308.26 0.42% None 963,308.26 1.81 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 1,155,900.93 100.00 1,155,900.93 0.5% None WFSWEEP 1,155,900.93 1.81 1,155,900.93 1.81 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 27,190.84 100.00 27,190.84 0.01% None 1 27,190.84 1.81 27,190.84 1.81 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 2,555,510.68 5/31/2006 2,555,510.68 100.00 2,555,510.68 1.1% None 1.81 2,555,510.68 1.81 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 17,735,924.45 100.00 17,735,924.45 7.65% None WFSWEEP 17,735,924.45 1.81 17,735,924.45 1.81 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 933,649.12 100.00 WFSWEEP 933,649.12 1.81 933,649.12 1.81 933,649.12 0.4% None 1 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 162,485.06 100.00 162,485.06 0.07% None 1 WFSWEEP 162,485.06 1.81 162,485.06 1.81 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 36,306.85 100.00 36,306.85 0.02% None 1 WFSWEEP 36,306.85 1.81 36,306.85 1.81 0.00 None 0 Prepared by Shamaira Jagrup 1 of 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2019 Description CUSIP Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Face Amount / Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 202,485.56 5/31/2006 1.81 202,485.56 202,485.56 100.00 1.81 202,485.56 0.09% 0.00 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 46,250.64 100.00 46,250.64 46,250.64 1.81 46,250.64 1.81 0.02% 0.00 None None None None 1 0 Wells Fargo Sweep Cash WFSWEEP 2,122,955.29 0 5/31/2006 2,122,955.29 100.00 2,122,955.29 0.92% None 1 1.81 2,122,955.29 1.81 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 62,781.79 100.00 62,781.79 0.03% None WFSWEEP 62,781.79 1.81 62,781.79 1.81 0.00 None 1 0 Wells Fargo Sweep Cash 5/31/2006 467,268.96 100.00 467,268.96 0.2% None WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 467,268.96 -2,022,063.12 980,315.34 1.81 467,268.96 1.81 0.00 None 0 5/31/2006 -2,022,063.12 100.00 -2,022,063.12 -0.87% None 1 1.81-2,022,063.12 1.81 0.00 None 0 5/31/2006 980,315.34 100.00 980,315.34 0.42% None 1.81 980,315.34 1.81 1 0.00 None 0 5/31/2006 155,213.32 100.00 155,213.32 0.07% None 155,213.32 1.81 155,213.32 1.81 0.00 None Wells Fargo Sweep Cash 5/31/2006 612,903.06 100.00 612,903.06 0.26% None WFSWEEP 612,903.06 1.81 612,903.06 1.81 0.00 None 1 0 1 0 Wells Fargo Sweep Cash 6/30/2006 51,952.60 100.00 51,952.60 0.02% None 1 WFSWEEP 51,952.60 1.81 51,952.60 1.81 0.00 None 0 Wells Fargo Sweep Cash 10/31/2006 439,826.70 100.00 439,826.70 0.19% None 1 WFSWEEP 439,826.70 1.81 439,826.70 1.81 0.00 None 0 Wells Fargo Sweep Cash 12/1/2006 318,723.21 100.00 318,723.21 0.14% None WFSWEEP 318,723.21 1.81 318,723.21 1.81 0.00 None Wells Fargo Sweep Cash WFSWEEP 9/1/2007 29,139.26 100.00 29,139.26 0.01% None 29,139.26 1.81 29,139.26 1.81 0.00 None 0 1 0 Prepared by Shamaira Jagrup 2 of 11 I., ro et 0 Maki r City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Shares Settlement Date Cost Value Market Price Market Value YTM @ Cost Book Value YTM @ Market Accrued Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 6,567,589.38 12/31/2007 1.81 6,567,589.38 6,567,589.38 100.00 1.81 Wells Fargo Sweep Cash WFSWEEP 3,494,302.75 10/30/2008 3,494,302.75 1.81 3,494,302.75 100.00 1.81 Wells Fargo Sweep Cash WFSWEEP 42,096.95 9/15/2009 42,096.95 100.00 1.81 42,096.95 1.81 6,567,589.38 3,494,302.75 2.83% 0.00 None None 1 0 1.51% 0.00 None None 1 0 42,096.95 0.02% None Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 3,231,131.60 214,171.23 25,447.93 0.00 None 1 0 9/15/2010 3,231,131.60 100.00 3,231,131.60 1.39% None 1.81 3,231,131.60 1.81 1 0.00 None 0 4/15/2012 214,171.23 100.00 214,171.23 0.09% None 1 1.81 214,171.23 1.81 0.00 None 0 2/1/2013 25,447.93 100.00 25,447.93 0.01% None 1 1.81 25,447.93 1.81 0.00 None 0 Wells Fargo Sweep Cash 11/15/2015 WFSWEEP 151,037.77 1.81 151,037.77 151, 037.77 100.00 1.81 151,037.77 0.07% None 0.00 None 0 Wells Fargo Sweep Cash 10/15/2018 859,963.99 100.00 859,963.99 0.37% None 1 WFSWEEP 859,963.99 1.81 859,963.99 1.81 0.00 None 0 Wells Fargo Sweep Cash 12/15/2018 -121,431.71 WFSWEEP -121,431.71 1.81-121,431.71 100.00 -121,431.71 -0.05% None 1 1.81 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 10,346,520.22 100.00 10,346,520.22 4.46% None 1 WF5875 10,346,520.22 1.81 10,346,520.22 1.81 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 83,348.84 100.00 83,348.84 0.04% None 1 WF4094 83,348.84 1.81 83,348.84 1.81 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 8,692,378.80 100.00 8,692,378.80 3.75% None 1 WF6624 8,692,378.80 1.81 8,692,378.80 1.81 0.00 None 0 Wells Fargo TWDB Cash 8/6/2019 20,613,812.12 100.00 20,613,812.12 8.89% None WF2847 20,613,812.12 1.81 20,613,812.12 1.81 0.00 None 1 0 Prepared by Shamaira Jagrup 3 of 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2019 Description CUSIP Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Face Amount / Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo TWDB Cash WF4102 Wells Fargo TWDB Cash WF5883 Sub Total Cash 1,959,751.01 10,761,867.55 11/1/2016 1.81 1,959,751.01 1,959,751.01 3/15/2017 10,761,867.55 1.81 10,761,867.55 1.81 100.00 1.81 95,632,738.46 1,959,751.01 100.00 10, 761,867.55 95,632,738.46 95,632,738.46 1.80 95,632,738.46 1.80 0.85% 0.00 4.64% 0.00 41.26% 0.00 None None None None 0 0 0 Certificate Of Deposit 1st Security Bank of Wash 1.1 1/22/2021 33625CAZ2 7/22/2016 248,000.00 99.09 245,752.19 0.11% None 248,000.00 1.10 248,000.00 1.80 59.79 -2,247.81 None 1st Source Bank 1.511/18/2019 33646CE03 Ally Bank Midvale Utah 1.8 6/29/2020 02006L3U5 Alma Bank 1.35 12/24/2020 020080BB2 4/17/2015 248,000.00 100.00 247,996.78 0.11 % None 248,000.00 1.50 248,000.00 1.51 1,691.84 -3.22 None American Eagle Bank IL 1.35 7/12/2021 02554BCM1 Bank Leumi USA 1.3 2/26/2020 063248FH6 Bank of New England NH 1.4 6/30/2021 063847AL1 Bankers Bank Oklahoma 1.8 9/25/2020 06610QCV1 Ba n kwest, Inc. 1.5 1/3/2020 06652CFA4 480 1.3 49 0.13 6/29/2017 248,000.00 100.00 247,993.74 0.11% None 248,000.00 1.80 248,000.00 1.80 1,137.40 -6.26 None 6/24/2016 248,000.00 99.45 246,639.74 0.11% None 248,000.00 1.35 248,000.00 1.80 55.04 -1,360.26 None 7/11/2016 248,000.00 99.47 246,693.38 0.11% None 248,000.00 1.35 248,000.00 1.65 174.28 -1,306.62 None 273 0.74 451 1.22 651 1.76 3/3/2016 248,000.00 100.00 248,001.13 0.11% None 248,000.00 1.30 248,000.00 1.30 309.15 1.13 None 149 0.4 6/30/2016 248,000.00 99.66 247,144.60 0.11% None 248,000.00 1.40 248,000.00 1.60 0.00 -855.40 None 639 1.73 9/25/2015 248,000.00 100.44 249,092.31 0.11% None 248,000.00 1.80 248,000.00 1.35 61.15 1,092.31 None 3/4/2015 248,000.00 99.90 247,748.86 0.11% None 248,000.00 1.50 248,000.00 1.89 275.18 -251.14 None 361 0.98 95 0.26 Prepared by Shamaira Jagrup 4 of 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To CaII/Maturity YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Bar Harbor Bank & Trust 2.65 3/29/2021-18 066851WB8 248,000.00 3/29/2018 2.65 248,000.00 248,000.00 100.06 2.61 248,141.96 18.01 0.11% 141.96 None None 29 1.47 Belmont Savings Bank 1.85 10/23/2019 080515BD0 12/23/2014 248,000.00 100.01 248,000.00 1.85 248,000.00 1.73 248,017.60 1,244.42 0.11% 17.60 None None 23 0.06 BMW Bank 2.1 6/19/2020 05580ABX1 6/19/2015 248,000.00 100.12 248,306.23 248,000.00 2.10 248,000.00 1.92 1,469.65 0.11% None 306.23 None 263 0.71 Border State Bank 1.4 6/30/2021 099703EF3 6/30/2016 248,000.00 99.31 246,292.32 0.11% None 248,000.00 1.40 248,000.00 1.80 0.00 -1,707.68 None 639 1.73 Brickell Bank Miami FL 1.65 10/28/2019 6/27/2017 248,000.00 99.98 247,951.84 0.11% None 10801 DAG6 248,000.00 1.65 248,000.00 1.90 22.42 -48.16 None 28 0.08 Business Bank of St Louis MO 1.8 6/23/2021 12325EHU9 6/23/2017 248,000.00 100.00 247,999.95 0.11% None 632 248,000.00 1.80 248,000.00 1.80 85.61 -0.05 None 1.7 Capital One Bank USA 1.1 11/19/2019 11/19/2014 248,000.00 100.02 248,056.22 0.11% None 50 140420QX1 248,000.00 1.10 248,000.00 0.93 1,001.51 56.22 None 0.14 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 100.45 14042RAB7 248,000.00 2.30 248,000.00 1.84 249,108.77 0.11% None 78.14 1,108.77 None 361 0.98 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 99.61 247,022.15 0.11% None 301 144153AW3 248,000.00 1.10 248,000.00 1.58 22.42 -977.85 None 0.82 Cedar Rapids Bank & Trust 1.5 10/30/2019 1/30/2015 248,000.00 100.02 248,049.55 0.11% None 30 150517CJ7 248,000.00 1.50 248,000.00 1.25 295.56 49.55 None 0.08 Charter Bank 1.7 2/25/2020 161164BE7 • 2/25/2015 248,000.00 99.94 247,843.01 248,000.00 1.70 248,000.00 1.86 0.11% None 148 57.75 -156.99 None 0.4 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248,000.00 100.02 172B4C3Z5 248,059.68 0.11% None 50 248,000.00 2.10 248,000.00 1.91 1,911.98 59.68 None 0.14 Community Bank Pasadena 1.5 6/30/2021 203507BG2 6/30/2016 248,000.00 99.66 247,145.38 248,000.00 1.50 248,000.00 1.70 0.00- 0.11% None 639 -854.62 None 1.73 Prepared by Shamaira Jagrup 5 of 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2019 Description CUSIP Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To CaII/Maturity Face Amount / Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Community Bankers' Bank 1.4 6/30/2021 20361LBR4 248,000.00 6/30/2016 1.40 248,000.00 248,000.00 99.66 1.60 247,144.60 0.00 0.11% -855.40 None None 639 1.73 Discover Bank 2 2/25/2020 254672JA7 2/25/2015 248,000.00 100.06 248,140.08 0.11% None 248,000.00 2.00 248,000.00 1.86 489.21 140.08 None 148 0.4 Exchange Bank NEB 1.05 1/21/2020 301074CH1 7/20/2016 248,000.00 99.75 247,368.80 0.11% None 248,000.00 1.05 248,000.00 1.88 71.34 -631.20 None 113 0.31 First Business Bank 1.7 6/30/2020 31938QP40 9/30/2015 248,000.00 99.92 247,811.99 0.11% None 274 248,000.00 1.70 248,000.00 1.80 0.00 -188.01 None 0.75 First Financial NW 1.35 10/30/2019 10/30/2015 248,000.00 99.95 247,886.51 0.11% None 30 32022MAF5 248,000.00 1.35 248,000.00 1.90 0.00 -113.49 None 0.08 First Intl Bank & Trust 1.61/16/2020 32057GAE9 248,000.00 10/16/2015 248,000.00 99.92 247,795.18 0.11% None 108 1.60 248,000.00 1.88 152.20 -204.82 None 0.29 First National Bank of America 1.25 7/15/2021 32110YHMO 248,000.00 GNB Bank 1.5 6/30/2021 36198JCC6 248,000.00 7/15/2016 1.25 6/30/2016 1.50 248,000.00 99.03 248,000.00 1.80 245,596.58 0.11% None 654 653.97 -2,403.42 None 1.77 248,000.00 248,000.00 99.66 247,145.38 1.70 0.00 0.11% None 639 -854.62 None 1.73 Goldman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 100.06 248,140.08 0.11% None 148 38148JLL3 248,000.00 2.00 248,000.00 1.86 489.21 140.08 None 0.4 Gulf Coast Bank & Trust 1.3 7/15/2021-17 402194EX8 7/15/2016 248,000.00 99.49 246,730.63 0.11% None 248,000.00 1.30 248,000.00 1.59 132.49 -1,269.37 None 15 1.77 JP Morgan Chase Bk NA Columbus 2.1 2/15/2021-17 48126XVW2 2/15/2017 245,000.00 100.02 245,052.37 0.11% None 15 245,000.00 2.10 245,000.00 2.08 211.44 52.37 None 1.36 Lincoln 1st Bank 1.4 6/30/2021 53362LAB0 6/30/2016 248,000.00 99.66 247,144.60 0.11% None 639 248,000.00 1.40 248,000.00 ' 1.60 275.86 -855.40 None 1.73 6of11 Prepared by Shamaira Jagrup 69413CFD6 City of Pearland Portfolio Holdings by Security. Type Report Group: Pearland Date: 9/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 Machias Savings Bank 1.65 2/6/2020 554479DS1 248,000.00 2/6/2015 1.65 248,000.00 248,000.00 1 00.1 1 1.33 248,277.77 269.06 0.11% 277.77 None None 129 0.35 Marine Bank Springfield IL 1.8 6/29/2021 56817TAB7 6/29/2017 248,000.00 100.09 248,213.12 0.11% None 248,000.00 1.80 248,000.00 1.75 12.23 213.12 None 638 1.72 Marlin Business Bank 1.25 12/27/2019 57116AMC9 6/29/2016 248,000.00 1.25 248,000.00 99.85 247,633.33 0.11% None 248,000.00 1.86 8.49 -366.67 None 88 0.24 Morgan Stanley Bank NA 2.8 4/5/2021 61747MS69 4/5/2018 248,000.00 2.80 248,000.00 101.49 248,000.00 1.80 251,686.97 0.11% None 3,386.39 3,686.97 None 553 1.47 National Bank Commerce Superior 1.25 7/15/2021-17 633368EB7 248,000.00 7/15/2016 248,000.00 99.49 246,730.81 0.11% None 654 1.25 248,000.00 1.54 127.40 -1,269.19 None 1.77 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 99.67 247,183.77 0.11% None 248,000.00 1.25 248,000.00 1.69 0.00 -816.23 None 274 0.75 Parkside Finl Bank & Trust 1.3 7/19/2021-17 70147ABX1 248,000.00 7/18/2016 248,000.00 99.49 246,722.83 0.11% None 18 1.30 248,000.00 1.59 105.99 -1,277.17 None 1.78 Peoples United Bank 1.9 11/19/2019 11/19/2014 248,000.00 100.02 71270QKM7 248,000.00 1.90 248,000.00 1.73 248,053.75 0.11% None 1,729.88 53.75 None 50 0.14 Portage County Bank 1.4 6/24/2021 73565NBQ5 6/24/2016 248,000.00 99.66 247,152.60 0.11% None 248,000.00 1.40 248,000.00 1.60 57.07 -847.40 None 633 1.71 Sallie Mae Bank 2.15 11/19/2019 11/19/2014 248,000.00 100.02 795450VC6 248,055.95 0.11% None 50 248,000.00 2.15 248,000.00 1.97 1,957.50 55.95 None 0.14 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 91330ABC0 248,000.00 1.65 248,000.00 100.49 249,203.63 0.11% None 1.20 0.00 1,203.63 None 396 1.07 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 '248,000.00 92834CBW1 248,000.00 1.30 248,000.00 99.47 246,691.38 0.11% None 651 1.60 715.46 -1,308.62 None 1.76 Prepared by Shamaira Jagrup 7 of 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Settlement Date Shares YTM @ Cost Cost Value Market Price Book Value YTM @ Market Market Value % Portfolio Credit Rating Days To Call/Maturity Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Washington Federal 1.5 3/31/2021-16 938828AC4 248,000.00 3/31/2016 1.50 248,000.00 248,000.00 99.84 1.61 247,604.12 0.00 0.11% -395.88 None None 548 1.48 Wells Fargo Bank 1.75 6/17/2021 9497485W3 248,000.00 6/20/2016 1.75 248,000.00 248,000.00 99.66 1.95 247,164.56 154.58 0.11% -835.44 None None 626 1.69 Sub Total Certificate Of Deposit 11,901,000.00 1.61 11,901,000.00 11,901,000.00 1.71 11,885,388.78 20,971.07 5.28% -15,611.22 314 0.98 j"Compound CD East West Bank 2.54 5/4/2020 CD5845 5,053,869.79 4/30/2019 2.54 5,053,869.79 5,053,869.79 100.00 2.54 5,053,869.79 0.00 2.18% 0.00 None None 217 0.59 East West Bank 2.56 3/2/2020 CD0940 2,021,718.52 4/30/2019 2.56 2,021,718.52 2,021,718.52 100.00 2.56 2,021,718.52 0.00 0.87% 0.00 None None 154 0.42 East West Bank 2.56 3/2/2020 CD0940 3,032,577.77 4/30/2019 2.56 3,032,577.77 3,032,577.77 100.00 2.56 3,032,577.77 0.00 1.31 0.00 None None 154 0.42 Wallis Bank 2.539 8/3/2020 CD26135 5,031,650.55 4/30/2019 2.54 5,031,650.55 5,031,650.55 100.00 2.54 5,031,650.55 21,350.60 2.17% 0.00 None None 308 0.83 Sub Total Compound CD 15,139,816.63 2.55 15,139,816.63 15,139,816.63 2.55 15,139,816.63 21,350.60 6.53% 0.00 226 0.61 FAMC Bond FAMC 1.675 2/24/2020 3132X0PW5 1,000,000.00 2/24/2017 1.63 1,001,200.00 1,000,160.00 99.87 1.99 998,743.34 1,675.00 0.43% Moodys-Aaa -1,416.66 S&P -AA+ 147 0.4 FAMC 1.675 2/24/2020 3132X0PW5 1,000,000.00 2/24/2017 1.63 1,001,200.00 1,000,160.00 99.87 1.99 998,743.34 1,675.00 0.43% Moodys-Aaa -1,416.66 S&P -AA+ 147 0.4 FAMC 1.8211/9/2020 3132X0ZC8 1,000,000.00 11/9/2017 1.82 1,000,000.00 1,000,000.00 99.95 1.87 999,505.69 7,128.33 0.43% Moodys-Aaa -494.31 S&P -AA+ 406 1.09 Sub Total FAMC Bond 3,000,000.00 1.70 3,002,400.00 3,000,320.00 1.95 2,996,992.37 10,478.33 1.29% -3,327.63 233 0.63 FFCB Bond Prepared by Shamaira Jagrup 8 of 11 'sr. 9% City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2019 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity FFCB 1.8410/30/2020-18 3133EHM26 1,000,000.00 10/30/2017 1.84 1,000,000.00 1,000,000.00 100.00 1.84 1,000,004.43 7,666.67 0.43% Moodys-Aaa 4.43 S&P -AA+ 396 1.07 Sub Total FFCB Bond 1,000,000.00 1.84 1,000,000.00 1,000,000.00 1.84 1,000,004.43 7,666.67 0.43% 4.43 396 1.07 FHLBeBorid" FHLB 2.2 1/29/2021-19 3130ADC26 1,000,000.00 1/29/2018 1,000,000.00 99.95 999,496.28 0.43% Moodys-Aaa 2:20 1,000,000.00 2.24 3,727.78 -503.72 S&P -AA+ 29 1.31 1,000,000.00 Sub Total FHLB Bond 1,000,000.00 2.20 1,000,000.00 999,496.28 0.43% 2.24 3,727.78 -503.72 29 1.31 [FHL'MC Bori FHLMC 1.125 8/12/2021 3137EAEC9 1,000,000.00 9/22/2016 988,540.00 98.97 989,657.28 0.43% Moodys-Aaa 1.37 995,624.36 1.69 1,343.75 -5,967.08 S&P -AA+ 682 1.85 FHLMC 211/20/2020-18 3134GBW32 1,000,000.00 12/5/2017 1,000,000.00 2.00 1,000,000.00 99.77 997,692.54 0.43% Moodys-Aaa 2.21 7,222.22 -2,307.46 S&P -AA+ 51 1.12 FHLMC 2.2 12/8/2021-18 3134GB4N9 1,000,000.00 12/8/2017 1,000,000.00 100.06 1,000,592.17 0.43% Moodys-Aaa 2.20 1,000,000.00 2.17 6,844.44 592.17 S&P -AA+ 69 2.14 FHLMC Step 8/3/2021-18 3134GBA93 3/9/2018 691,243.00 100.02 700,171.42 0.3% S&P -AA+ 34 700,000.00 2.61 695,256.62 2.44 2,493.75 4,914.80 Moodys-Aaa 1.81 3,679,783.00 Sub Total FHLMC Bond 3,700,000.00 2.00 3,690,880.98 3,688,113.41 1.59% 223 2.10 17,904.16 -2,767.57 1.72 FNMA Bond FNMA 1.875 12/28/2020 3135G0H55 1,000,000.00 9/22/2016 1, 025, 880.00 1.25 1,007,548.33 100.11 1,001,146.07 0.43% Moodys-Aaa 1.78 4,791.67 -6,402.26 S&P -AA+ 455 1.23 Sub Total FNMA Bond 1,000,000.00 1.25 1,025,880.00 1,007,548.33 1,001,146.07 0.43% 455 1.78 4,791.67 -6,402.26 1.23 j Local Government Investment"Pool . Texas Class LGIP TX-01-0615-0001 10,805,041.40 12/20/2016 10,805,041.40 100.00 10,805,041.40 4.66% None 2.20 10,805,041.40 2.20 0.00 None 1 0 Prepared by Shamaira Jagrup 9 of 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM @ Cost Book Value YTM @ Market Accrued Interest Unre..Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP TX-01-0615-0001 16,464,145.45 12/20/2016 16,464,145.45 2.20 16,464,145.45 100.00 2.20 16,464,145.45 7.1% 0.00 None None 0 Texas Class LGIP TX-01-0615-0001 12/20/2016 5,968.02 100.00 5,968.02 5,968.02 2.20 5,968.02 2.20 0% None 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 12/20/2016 15,545.65 100.00 15,545.65 0.01% None 1 15,545.65 2.20 15,545.65 2.20 0.00 None 0 Texas Class LGIP TX-01-0615-0001 . 1,053,980.28 1/15/2017 1,053,980.28 100.00 1,053,980.28 0.45% None 1 2.20 1,053,980.28 2.20 0.00 None 0 Texas Class LGIP TX-01-0615-0001 3,596,243.71 1/15/2017 3,596,243.71 100.00 3,596,243.71 1.55% None 2.20 3,596,243.71 2.20 0.00 None 1 0 Texas Class LGIP 1/15/2017 236,318.64 100.00 236,318.64 0.1% None TX-01-0615-0001 236,318.64 2.20 236,318.64 2.20 0.00 None 1 0 Texas Class LGIP 5/15/2017 98,434.65 100.00 98,434.65 0.04% None TX-01-0615-0001 98,434.65 2.20 98,434.65 2.20 0.00 None 1 0 Texas Class LGIP TX-01-0615-0001 1,125,338.32 5/15/2017 1,125,338.32 100.00 1,125,338.32 0.49% None 1 2.20 1,125,338.32 2.20 0.00 None 0 Texas Class LGIP TX-01-0615-0001 5/15/2017 677,749.56 100.00 677,749.56 0.29% None 677,749.56 2.20 677,749.56 2.20 0.00 None 1 0 Texas Class LGIP TX-01-0615-0007 5,743,055.97 9/19/2019 5,743,055.97 100.00 5,743,055.97 2.48% None 2.20 5,743,055.97 2.20 0.00 None 1 0 Texas Class LGIP TX-01-0615-0007 2,763,168.45 9/19/2019 2,763,168.45 100.00 2,763,168.45 1.19% None 1 2.20 2,763,168.45 2.20 0.00 None 0 Texas Class LGIP TX-01-0615-0007 5,038,718.92 9/19/2019 5,038,718.92 100.00 5,038,718.92 2.17% None 2.20 5,038,718.92 2.20 0.00 None 1 0 Texas Class LGIP TX-01-0615-0005 4,613,673.57 9/15/2018 4,613,673.57 100.00 4,613,673.57 1.99% None 1 2.20 4,613,673.57 2.20 0.00 None 0 Prepared by Shamaira Jagrup 10 of 11 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2019 Description Face Amount / CUSIP Shares Settlement Date Cost Value Market Price YTM @ Cost Book Value YTM @ Market Market Value Accrued Interest % Portfolio Credit Rating Days To Call/Maturity Unre. Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP TX-01-0615-0004 5,239,923.24 9/15/2018 2.20 5,239,923.24 5,239,923.24 100.00 2.20 5,239,923.24 1 2.26% 0.00 None None 1 0 Texas Class LGIP TX-01-0615-0004 8,149,666.05 9/15/2018 8,149,666.05 2.20 8,149,666.05 100.00 8,149,666.05 2.20 3.52% 0.00 None None 1 0 Texas Class LGIP TX-01-0615-0006 5,227,581.65 9/15/2018 5,227,581.65 100.00 5,227,581.65 2.26% None 2.20 5,227,581.65 2.20 1 0.00 None 0 TexSTAR LGIP 02000=20190 6,363,088.30 9/19/2019 6,363,088.30 100.00 6,363;088.30 2.75% None 1 2.11 6,363,086.30 2.11 0.00 None 0 TexSTAR LGIP 9/27/2019 02000-20191 486,416.54 2.11 486,416.54 100.00 486,416.54 0.21% None 486,416.54 2.11 0.00 None 1 0 TexSTAR LGIP 02000-20191 4,477,617.55 9/27/2019 4,477,017.55 100.00 4,477,017.55 1.93% None 1 2.11 4,477,017.55 2.11 0.00 None 0 TexSTAR LGIP 02000-11110 1,165,390.31 8/26/2016 1,165,390.31 100.00 -1,165,390.31 0.5% S&P -AAA 2.11 1,165,390.31 2.11 0.00 None 1 TexSTAR LGIP '02000-11110 1,650,738.49 8/26/2016 1,650,738.49 100.00 1,650,738.49 0.71% S&P -AAA 1 2.11 1,650,738.49 2.11 0.00 None 0 TexSTAR LGIP 02000-20192 14,397,069.13 9/27/2019 14,397,069.13 100.00 14,397,069.13 6.21% None 1 2.11 14,397,069.13 2.11 0.00 None 0 Sub Total Local Government Investment Pool 99,394,273.85 2.17 99,394,273.85 99,394,273.85 2.17 99,394,273.85 42.87% 1 0.00 0 TOTAL PORTFOLIO 231,767,828.94 231,775,891.94 231,737,970.28 100.00% 2.00 231,766,578.25 2.02 86,890.28 -28,607.97 42 0.14 Prepared by Shamaira Jagrup 11 of 11 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Shares Settlement Date YTM @ Cost Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity 100: GeneralFund Alma Bank 1.35 12/24/2020 020080BB2 248,000.00 6/24/2016 248,000.00 1.35 248,000.00 99.45 1.80 246,639.74 55.04 0.11% -1,360.26 None None 451 1.22 American Eagle Bank IL 1.35 7/12/2021 02554BCM1 7/11/2016 248,000.00 248,000.00 1.35 99.47 246,693.38 0.11% None 248,000.00 1.65 174.28 -1,306.62 None 651 1.76 Bank Leumi USA 1.3 2/26/2020 063248FH6 248,000.00 3/3/2016 248,000.00 100.00 248,001.13 0.11% None 1.30 248,000.00 1.30 309.15 1.13 None 149 0.4 Bankers Bank Oklahoma 1.8 9/25/2020 06610QCV1 9/25/2015 248,000.00 100.44 249,092.31 0.11% None 248,000.00 1.80 248,000.00 1.35 61.15 1,092.31 None 361 0.98 Bar Harbor Bank & Trust 2.65 3/29/2021-18 066851WB8 3/29/201 B 248,000.00 248,000.00 2.65 248,000.00 100.06 248,141.96 0.11% None 2.61 18.01 141.96 None 29 1.47 Belmont Savings Bank 1.85 10/23/2019 12/23/2014 248,000.00 100.01 248,017.60 080515BD0 248,000.00 1.85 248,000.00 1.73 1,244.42 0.11% None 17.60 None 23 0.06 Capital One NA 2.3 9/25/2020 14042RAB7 9/23/2015 248,000.00 100.45 249,108.77 0.11% None 361 248,000.00 2.30 248,000.00 1.84 78.14 1,108.77 None 0.98 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 144153AW3 248,000.00 1.10 248,000.00 99.61 1.58 247,022.15 22.42 0.11% None 301 -977.85 None 0.82 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248,000.00 100.02 . 248,059.68 0.11 % None 50 17284C3Z5 248,000.00 2.10 248,000.00 1.91 1,911.98 59.68 None 0.14 Community Bank Pasadena 1.5 6/30/2021 2035078G2 6/30/2016 248,000.00 99.66 247,145.38 0.11% None 639 248,000.00 1.50 248,000.00 1.70 0.00 -854.62 None 1.73 Community Bankers' Bank 1.4 6/30/2021 6/30/2016 248,000.00 99.66 . 247,144.60 0.11% None 639 20361LBR4 248,000.00 1.40 248,000.00 1.60 0.00 -855.40 None 1.73 East West Bank 2.54 5/4/2020 4/30/2019 5,053,869.79 100.00 5,053,869.79 2.18% None 217 CD5845 5,053,869.79 2.54 5,053,869:79 2.54 0.00 0.00 None 0.59 Prepared by Shamaira Jagrup 1 of 14 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2019 Description CUSIP Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Face Amount / 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 CD0940 3,032,577.77 4/30/2019 2.56 3,032,577.77 3,032,577.77 100.00 2.56 3,032,577.77 0.00 1.31% 0.00 None None 154 0.42 Exchange Bank NEB 1.05 1/21/2020 301074CH1 7/20/2016 248,000.00 248,000.00 1.05 248,000.00 99.75 247,368.80 1.88 71.34 0.11% None -631.20 None 113 0.31 FAMC 1.675 2/24/2020 3132X0PW5 1,000,000.00 2/24/2017 1,001,200.00 1.63 1,000,160.00 99.87 998,743.34 0.43% Moodys-Aaa 1.99 1,675.00 -1,416.66 S&P -AA+ 147 0.4 FHLMC Step 8/3/2021-18 3134GBA93 3/9/2018 691,243.00 100.02 700,171.42 0.3% S&P -AA+ 700,000.00 2.61 695,256.62 2.44 2,493.75 4,914.80 Moodys-Aaa 34 1.81 JP Morgan Chase Bk NA Columbus 2.1 2/15/2021-17 2/15/2017 245,000.00 100.02 245,052.37 0.11% None 48126XVW2 245,000.00 2.10 245,000.00 2.08 211.44 52.37 None 15 1.36 Machias Savings Bank 1.65 2/6/2020 554479DS1 2/6/2015 248,000.00 100.11 248,277.77 0.11% None 248,000.00 1.65 248,000.00 1.33 269.06 277.77 None 129 0.35 Morgan Stanley Bank NA 2.8 4/5/2021 61747MS69 4/5/2018 248,000.00 101.49 251,686.97 0.11% None 553 248,000.00 2.80 248,000.00 1.80 3,386.39 3,686.97 None 1.47 Sallie Mae Bank 2.15 11/19/2019 795450VC6 • 11/19/2014 248,000.00 100.02 248,055.95 0.11% None 50 248,000.00 2.15 248,000.00 1.97 1,957.50 55.95 None 0.14 Texas Class LGIP TX-01-0615-0001 5/15/2017 98,434.65 100.00 98,434.65 0.04% None 98,434.65 2.20 98,434.65 2.20 0.00 None 0 Unity Bank 1.6510/30/2020 91330ABC0 10/30/2015 248,000.00 100.49 249,203.63 0.11% None 248,000.00 1.65 248,000.00 1.20 0.00 1,203.63 None 396 1.07 Vision Bank of Iowa 1.3 7/12/2021 92834CBW 1 7/11/2016 248,000.00 248,000.00 1.30 248,000.00 99.47 246,691.38 0.11% None 1.60 715.46 -1,308.62 None 651 1.76 Wallis Bank 2.539 8/3/2020 4/30/201'9 '5,031,650.55 100.00 5,031,650.55 CD26135 5,031,650.55 2.54 5,031,650.55 2.54 21,350.60 2.17% None ' 308 0.00 None 0.83 Prepared by Shamaira Jagrup 2 of 14 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Washington Federal 1.5 3/31/2021-16 938828AC4 248,000.00 3/31/2016 1.50 248,000.00 248,000.00 99.84 1.61 247,604.12 0.00 0.11% -395.88 None None 548 1.48 Wells Fargo Bank 1.75 6/17/2021 9497485W3 6/20/2016 248,000.00 99.66 247,164.56 0.11% None 248,000.00 1.75 248,000.00 1.95 154.58 -835.44 None 626 1.69 Wells Fargo Sweep Cash WFSWEEP -2,022,063.12 5/31/2006 -2,022,063.12 100.00 -2,022,063.12 1.8.1-2,022,063.12 1.81 -0.87% 0.00 None None 1 0 17,843,912.64 Sub Total 100: General Fund 17,851,469.64 2.35 17,846,886.26 2.36 17,849,556.65 36,159.71 7.76% 2,670.39 277 0.86 200: Debt Services 1st Source Bank 1.5 11/18/2019 4/17/2015 248,000.00 100.00 247,996.78 0.11% None 33646CEQ3 248,000.00 1.50 248,000.00 1.51 1,691.84 -3.22 None 49 0.13 Charter Bank 1.7 2/25/2020 161164BE7 2/25/2015 248,000.00 99.94 247,843.01 0.11% None 248,000.00 1.70 248,000.00 1.86 57.75 -156.99 None 148 0.4 Discover Bank 2 2/25/2020 2/25/2015 248,000.00 100.06 248,140.08 0.11% None 148 254672JA7 248,000.00 2.00 248,000.00 - 1.86 489.21 140.08 None 0.4 Goldman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 100.06 248,140.08 0.11% None 148 38148JLL3 248,000.00 2.00 248,000.00 1.86 489.21 140.08 None 0.4 Texas Class LGIP TX-01-0615-0001 3,596,243.71 1/15/2017 3,596,243.71 100.00 3,596,243.71 1.55% None 2.20 3,596,243.71 2.20 0.00 None 1 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 963,308.26 100.00 963,308.26 0.42% 963,308.26 1.81 963,308.26 1.81 None • 0.00 None 0 Sub Total 200: Debt Services 5,551,551.97 2.06 5,551,551.97 5,551,551.97 5,551,671.92 2.41% 23 2.06 2,728.01 119.95 .0.06 05171otellMotel:Occu`pancy Ally Bank Midvale Utah 1.8 6/29/2020 02006L3U5 6/29/2017 248,000.00 248,000.00 1.80 248,000.00 100.00 247,993.74 0.11% None 273 1.80 1,137.40 -6.26 None 0.74 Prepared by Shamaira Jagrup 3 of 14 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Settlement Date Shares YTM @ Cost Cost Value Book Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM @ Market Accrued, Interest Unre. Gain/Loss Credit Rating Duration To Maturity Bank of New England NH 1.4 6/30/2021 063847AL1 248,000.00 6/30/2016 248,000.00 1.40 248,000.00 99.66 1.60 247,144.60 0.00 0.11 % -855.40 None None 639 1.73 East West Bank 2.56 3/2/2020 CD0940 2,021,718.52 4/30/2019 2,021,718.52 2.56 2,021,718.52 100.00 2.56 2,021,718.52 0.00 0.87% None 0.00 None 154 0.42 First Intl Bank & Trust 1.6 1/16/2020 32057GAE9 10/16/2015 248,000.00 99.92 247,795.18 0.11% None 108 248,000.00 1.60 248,000.00 1.88 152.20 -204.82 None 0.29 Texas Class LGIP TX-01-0615-0001 1,125,338.32 5/15/2017 1,125,338.32 100.00 1,125,338.32 0.49% None 2.20 1,125,338.32 2.20 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 , 1,155,900.93 100.00 1,155,900.93 0.5% None WFSWEEP 1,155,900.93 1.81 1,155,900.93 1.81 0.00 None 0 5,046,957.77 Sub Total 305: Hotel/Motel Occupancy 5,046,957.77 2.17 5,046,957.77 2.19 5,045,891.29 1,289.60 2.19% -1,066.48 112 0.3 310: Munlclpal'Court Security= Wells Fargo Sweep Cash WFSWEEP 36,306.85 5/31/2006 1.81 36,306.85 36,306.85 100.00 36,306.85 0.02% None 1.81 0.00 None Sub Total 310: Municipal Court Security 36,306.85 1.81 36,306.85 36,306.85 1.81 36,306.85 0.02% 0.00 0 315t City WideDotiation, r Wells Fargo Sweep Cash WFSWEEP 162,485.06 5/31/2006 1.81 162,485.06 162,485.06 100.00 1.81 162,485.06 0.07% 0.0'0 None None 0 Sub Total 315: City Wide Donation 162,485.06 1.81 162,485.06 162,485.06 162,485.06 0.07% 0.00 1 0 i 320 -.Court:Technology, Wells Fargo Sweep Cash WFSWEEP 27,190.84 5/31/2006 1.81 27,190.84 27,190.84 100.00 1.81 27,190.84 0.01% • 0.00 None None Sub Total 320: Court Technology 27,190.84 1.81 27,190.84 27,190.84 1.81 27,190.84 0.01% 0.00 0 i 33U:' Park Donations Prepared by Shamaira Jagrup 4 of 14 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 62,781.79 5/31/2006 1.81 62,781.79 62,781.79 100.00 1:81 62,781.79 0.03% 0.00 None None 0 Sub Total 330: Park Donations 62,781.79 1.81 62,781.79 62,781.79 1.81 62,781.79 0.03% 0.00 1 0 331: Tree Trust Fund Wells Fargo Sweep Cash WFSWEEP 5/31/2006 467,268.96 100.00 467,268.96 0.2% None 467,268.96 1.81 467,268.96 1.81 0.00 None 0 Sub Total 331: Tree Trust Fund 467,268.96 467,268.96 1.81 467,268.96 1.81 467,268.96 0.2% 0.00 0 1335:`Poliee:State,Seizure" • • Wells Fargo Sweep Cash 5/31/2006 123,137.83 WFSWEEP 123,137.83 1.81 123,137.83 100.00 123,137.83 0.05% None 1.81 0.00 None 1 0 Sub Total 335: Police State Seizure 123,137.83 1.81 123,137.83 123,137.83 1.81 123,137.83 0.05% 0.00 1336: Federal Polic! Fund Wells Fargo Sweep Cash WFSWEEP 155,213.32 5/31/2006 155,213.32 100.00 155,213.32 0.07% None 1.81 155,213.32 1.81 0.00 ' None 0 Sub Total 336: Federal Police Fund 155,213.32 155,213.32 1.81 155,213.32 1.81 155,213.32 0.07% 0.00 1:340`: Park & .!00beireloorrienjf Border State Bank 1.4 6/30/2021 099703EF3 248,000.00 6/30/2016 248,000.00 99.31 246,292.32 0.11% 1.40 248,000.00 1.80 0.00 -1707.68 None None 639 1.73 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 933,649.12 933,649.12 . 1.81 100.00 933,649.12 933,649.12 1.81 0.4% None 0.00 None 0 Sub Total 340: Park & Rec Development 1,181,649.12 1.72 1,181,649.12 1,181,649.12 1.81 1,179,941.44 0.00 0.51% 135 -1,707.68 0.36 345: Sidewalk Funil Prepared by Shamaira Jagrup 5 of 14 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2019 Description CUSIP Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To CaII/Maturity Face Amount / Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 46,250.64 5/31/2006 1.81 46,250.64 46,250.64 100.00 1.81 46,250.64 0.02% 0.00 None None 1 0 Sub Total 345: Sidewalk Fund 46,250.64 46,250.64 1.81 46,250.64 1.81 46,250.64 0.02% 0.00 1 0 350 Grant Fund,' Wells Fargo Sweep Cash 5/31/2006 202,485.56 100.00 202,485.56 0.09% None WFSWEEP 202,485.56 1.81 202,485.56 1.81 0.00 None 1 0 Sub Total 350: Grant Fund 202,485.56 202,485.56 1.81 202,485.56 1.81 202,485.56 0.09% 0.00 1 0 i 351 CDBG Fund' Wells Fargo Sweep Cash WFSWEEP 11/15/2015 151,037.77 100.00 151,037.77 0.07% None 151,037.77 1.81 151,037.77 1.81 0.00 None 1 0 Sub Total 351: CDBG Fund 151,037.77 1.81 151,037.77 151,037.77 1.81 151,037.77 0.07% 0.00 0 360. Traffic,lmpact•Improvemen( Wells Fargo Sweep Cash WFSWEEP 612,903.06 5/31/2006 1.81 612,903.06 612,903.06 100.00 1.81 612,903.06 0.26% 0.00 None None 0 Sub Total 360: Traffic Impact Improvement 612,903.06 1.81 612,903.06 612,903.06 1.81 612,903.06 0.26% 0.00 1 0 �365 Court, Juvenile,Mgmt:`, Wells Fargo Sweep Cash WFSWEEP 42,096.95 9/15/2009 42,096.95 1.81 42,096-.95 100.00 1.81 42,096.95 0.02% 0.00 None None 0 Sub Total 365: Court Juvenile Mgmt 42,096.95 1.81 42,096.95 42,096.95 1.81 42,096.95 0.02% 0.00 1 370 , MunlclpahChannel'''; Texas Class LGIP TX-01-0615-0001 677,749.56 5/15/2017 2.20 677,749.56 677,749.56 100.00 2.20 677,749.56 0.29% 0.00 None None 1 0 Prepared by Shamaira Jagrup 6 of 14 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 214,171.23 4/15/2012 1.81 214,171.23 214,171.23 100.00 1.81 214,171.23 0.09% 0.00 None None 0 Sub Total 370: Municipal Channel 891,920.79 2.11 891,920.79 891,920.79 2.11 891,920.79 0.38% 0.00 1 0 1500 .Capltal?to jects: Texas Class LGIP TX-01-0615-0001 1,053,980.28 1/15/2017 2.20 1,053,980.28 1,053,980.28 100.00 2.20 1,053,980.28 0.45% 0.00 None None 0 Wells Fargo Sweep Cash WFSWEEP • 2,122,955.29. 5/31/2006 2,122,955.29 1.81 2,122,955.29 100.00 2,122,955.29 1.81 0.92% 0.00 None None 0 Sub Total 500: Capital Projects 3,176,935.57 1.94 3,176,935.57 3,176,935.57 1.94 3,176,935.57 1.37% 0.00 0 501: Certificates "of Obligation 1st Security Bank of Wash 1.1 1/22/2021 33625CAZ2 248,000.00 7/22/2016 248,000.00 1.10 248,000.00 99.09 1.80 245,752.19 59.79 0.11% -2,247.81 None None 480 1.3 FHLMC 1.125 8/12/2021 3137EAEC9 1,000,000.00 9/22/2016 988,540.00 98.97 989,657.28 0.43% Moodys-Aaa 1.37 995,624.36 1.69 1,343.75 -5,967.08 S&P -AA+ 682 1.85 FNMA ;1.875 12/28/2020 3135G0H55 1,000,000.00 9/22/2016 1,025, 880.00 1.25 1,007,548.33 100.11 1,001,146.07 0.43% Moodys-Aaa 455 4,791.67 -6,402.26 S&P -AA+ 1.23 1.78 Gulf Coast Bank & Trust 1.3 7/15/2021-17 7/15/2016 248,000.00 99.49 246,730.63 0.11% None 15 402194EX8 248,000.00 1.30 248,000.00 1.59 132.49 -1,269.37 None 1.77 Marlin Business Bank 1.25 12/27/2019 6/29/2016 248,000.00 99.85 247,633.33 0.11% None 57116AMC9 248,000.00 1.25 248,000.00 1.86 8.49 -366.67 None 88 0.24 Texas Class LGIP TX-01-0615-0001 12/20/2016 5,968.02 100.00 5,968.02 0% None 1 5,968.02 2.20 5,968.02 2.20 0.00 None 0 Texas Class LGIP TX-01-0615-0007 5,038,718.92 9/19/2019 5,038,718.92 100.00 5,038,718.92 2.17% None 2.20 5,038,718.92 2.20 0.00 None Prepared by Shamaira•Jagrup 7 of 14 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To CaII/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP TX-01-0615-0006 5,227,581.65 9/15/2018 5,227,581.65 2.20 5,227,581.65 100.00 2.20 5,227,581.65 2:26% 0.00 None None 0 TexSTAR LGIP 02000-20191 4,477,017.55 9/27/2019 4,477,017.55 2.11 4,477,017.55 100.00 4,477,017.55 2.11 1.93% None 0.00 None 1 0 TexSTAR LGIP 02000-11110 1,165,390.31 8/26/2016 1,165,390.31 100.00 1,165,390.31 2.11 1,165,390.31 2.11 0.5% S&P -AAA 0.00 None 0 TexSTAR LGIP 02000-20192 14,397,069.13 9/27/2019 14,397,069.13 2.11 14,397,069.13 100.00 14,397,069.13 6.21% None 2.11 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 980,315.34 WFSWEEP 980,315.34 1.81 980,315.34 100.00 1.81 980,315.34 0.42% None 0.00 None 1 0 Sub Total 501: Certificates of Obligation 34,036,060.92 2.06 34,050,480.92 34,039,233.61 2.10 34,022,980.42 6,336.19 14.68% -16,253.19 39 0.11 1503 Certrflcates of.0bligatlon4006 Wells Fargo Sweep Cash WFSWEEP 51,952.60 6/30/2006 1.81 51,952.60 51,952.60 100.00 51,952.60 0.02% 0.00 None .None 1 0 Sub Total 503: Certificates of Obligation 2006 51,952.60 1.81 51,952.60 51,952.60 1.81 51,952.60 0.02% 0.00 0 [506,'+'General; Obligation Brickell Bank Miami FL 1.65 10/28/2019 10801DAG6 248,000.00 6/27/2017 1.65 248,000.00 248,000.00 99.98 1.90 247,951.84 22.42 0.11% =48.16 None None 28 0.08 Business Bank of St Louis MO 1.8 6/23/2021 12325EHU9 248,000.00 6/23/2017 248,000.00 1.80 248,000.00 100.00 247,999.95 0.11% None 1.80 85.61 -0.05 None 632 1.7 Capital One Bank USA 1.1 11/19/2019 140420QX1 11/19/2014 248,000.00 100.02 248,056.22 0.11% None 248,000.00 1.10 248,000.00 0.93 . 1,001.51 56.22 50 None 0.14 First Business Bank 1.7 6/30/2020 31938QP40 248,000.00 9/30/2015 248,000.00 1.70 248,000.00 99.92 247,811.99 0.11% 1.80 0:00 None 274 -188.01 None 0.75 Prepared by Shamaira Jagrup 8 of 14 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity First National Bank of America 1.25 7/15/2021 32110YHMO 248,000.00 7/15/2016 248,000.00 1.25 248,000.00 99.03 1.80 245,596.58 653.97 0.11% -2,403.42 None None 654 1.77 Lincoln 1st Bank 1.4 6/30/2021 53362LAB0 6/30/2016 248,000.00 248,000.00 1.40 248,000.00 99.66 247,144.60 0.11% None 1.60 275.86 -855.40 None 639 1.73 National Bank Commerce Superior 1.25 7/15/2021-17 633368EB7 7/15/2016 248,000.00 99.49 246,730.81 0.11% None 654 248,000.00 1.25 248,000.00 1.54 127.40 -1,269.19 None 1.77 Peoples United Bank 1.9 11/19/2019 11/19/2014 248,000.00 100.02 248,053.75 0.11% None 50 71270QKM7 248,000.00 1.90 248,000.00 1.73 1,729.88 53.75 None 0.14 Texas Class LGIP TX-01-0615-0001' 12/20/2016 15,545.65 100.00 15,545.65 0.01% None 1 15,545.65 2.20 15,545.65 2.20 0.00 None 0 Texas Class LGIP TX-01-0615-0005 4,613,673.57 9/15/2018 4,613,673.57 100.00 4,613,673.57 1.99% None 2.20 4,613,673.57 2.20 0.00 None 1 0 TexSTAR LGIP 02000-20190 6,363,088.30 9/19/2019 6,363,088.30 100.00 6,363,088.30 2.75% None 1 2.11 6,363,088.30 2.11 0.00 None 0 TexSTAR LGIP 02000-20191 486,416.54 9/27/2019 486,416.54 2.11 486,416.54 100.00 486,416.54 0.21% None 2.11 0.00 None 1 TexSTAR LGIP 02000-11110 1,650,738.49 8/26/2016 1,650,738.49 100.00 1,650,738.49 0.71% S&P -AAA 2.11 1,650,738.49 2.11 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 3,494,302.75 10/30/2008 3,494,302.75 1.81 3,494,302.75 100.00 3,494,302.75 1.51% None 1.81 0.00 None 0 Sub. Total 506: General Obligation 18,607,765.30 2.01. 18,607,765.30 18,607,765.30 2.02 18,603,111.04 3,896.65 8.06% -4,654.26 41 0.11 1511': PEDC Capital Projects. Wells Fargo Sweep Cash WFSWEEP -121,431.71 12/15/2018 1.81 -121,431.71 -121,431.71 100.00 1.81 -121,431.71 -0.05% 0.00 None None Prepared by Shamaira Jagrup 9 of 14 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total 511: PEDC Capital Projects -121,431.71 1.81 -121,431.71 -121,431.71 1.81 -121,431.71 -0.05% 0.00 1 0 1550 W/$Impact Feea Bankwest, Inc. 1.5.1/3/2020 06652CFA4 248,000.00 3/4/2015 1.50 248,000.00 248,000.00 99.90 1.89 247,748.86 275.18 0.11% -251.14 None None 95 0.26 BMW Bank 2.1 6/19/2020 05580ABX1 248,000.00 6/19/2015 248,000.00 2.10 248,000.00 100.12 248,306.23 '0.11% None 1.92 1,469.65 306.23 None 263 0.71 Cedar Rapids Bank & Trust 1.5 10/30/2019 1/30/2015 248,000.00 150517CJ7 248,000.00 1.50 248,000.00 100.02 1.25 248,049.55 0.11% None 295.56 49.55 None 30 0.08 FAMC 1.82 11/9/2020 3132X0ZC8 1,000,000.00 11/9/2017 1,000,000.00 99.95 999,505.69 0.43% Moodys-Aaa 1.82 1,000,000.00 1.87 7,128.33 -494.31 S&P -AA+ 406 1.09 FFCB 1.8410/30/2020-18 3133EHM26 1,000,000.00 10/30/2017 1,000,000.00 100.00 1,000,004.43 0.43% Moodys-Aaa 1.84 1,000,000.00 1.84 7,666.67 4.43 S&P -AA+ 396 1.07 FHLB 2.2 1/29/2021-19 3130ADC26 1,000,000.00 1/29/2018 1,000,000.00 99.95 999,496.28 0.43% Moodys-Aaa 2.20 1,000,000.00 2.24 3,727.78 -503.72 S&P -AA+ 29 1.31 FHLMC 2 11/20/2020-18 3134GBW32 1,000,000.00 12/5/2017 1,000,000.00 99.77 997,692.54 0.43% Moodys-Aaa 2.00 1,000,000.00 2.21 7,222.22 -2,307.46 S&P -AA+ 51 1.12 FHLMC 2.212/8/2021-18 3134GB4N9 1,000,000.00 12/8/2017 1,000,000.00 2.20 1,000,000.00 100.06 1,000,592.17 0.43% Moodys-Aaa 2.17 6,844.44 592.17 S&P -AA+ 69 2.14 First Financial NW 1.35 10/30/2019 32022MAF5 10/30/2015 248,000.00 99.95 247,886.51 0.11% None 30 248,000.00 1.35 248,000.00 1.90 0.00 -113.49 None 0.08 Pacific Continental Bank 1.25 6/30/2020 69413CFD6 248,000.00 6/30/2016 248,000.00 99.67 247,183.77 0.11% None 1.25 248,000.00 1.69 0.00 -816.23 None 274 0.75 Texas Class LGIP TX-01-0615-0001 16,464,145.45 12/20/2016 16,464,145.45 100.00 16,464,145.45 7.1% None 1 2.20 1'6,464,145.45 2.20 0.00 None 0 Prepared by Shamaira Jagrup 10 of 14 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2019 Description CUSIP Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Face Amount / Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP TX-01-0615-0007 2,763,168.45 9/19/2019 2.20 2,763,168.45 2,763,168.45 100.00 2.20 2,763,168.45 1.19% 0.00 None None 0 Texas Class LGIP TX-01-0615-0004 5,239,923.24 9/15/2018 5,239,923.24 2.20 5,239,923.24 100.00 5,239,923.24 2.20 2.26% None 0.00 None 1 0 Wells Fargo Sweep Cash WFSWEEP 2,555,510.68 5/31/2006 2,555,510.68 100.00 2,555,510.68 1.1% None 1.81 2,555,510.68 1.81 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 WF4094 83,348.84 1.81 83,348.84 100.00 83,348.84 1.81 83,348.84 0.04% None 1 0.00 None C Wells Fargo TWDB Cash WF6624 8,692,378.80 5/15/2018 8,692,378.80 100.00. 8,692,378.80 8.75% None 1.81 8,692,378.80 1.81 0.00 None 1 Wells Fargo TWDB Cash 8/6/2019 20,613,812.12 100.00 20,613,812.12 8.89% None WF2847 20,613,812.12 1.81 20,613,812.12 1.81 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 1, 959, 751.01 WF4102 1,959,751.01 1.81 1,959,751.01 100.00 1,959,751.01 0.85% None 1.81 0.00 None 1 0 Wells Fargo TWDB Cash WF5883 10,761,867.55 3/15/2017 10, 761, 867.55 1.81 10,761, 867.55 100.00 10,761,867.55 4.64% None 1.81 0.00 None 0 Sub Total 550: W/S Impact Fee 75,373,906.14 1.94 75,373,906.14 75,373,906.14 1.95 75,370,372.17 34,629.83 32:52% -3,533.97 16 0.1 �555: ShadoviiCreek=Impact.' FAMC 1.675 2/24/2020 3132X0PW5 Wells Fargo Sweep Cash WFSWEEP 1,000, 000.00 -334,525.04 2/24/2017 • 1.63 1,001,200.00 1,000,160.00 99.87 1.99 998,743.34 1,675.00 0.43% -1,416.66 Moodys-Aaa S&P -AA+ 147 0.4 5/31/2006 1.81 -334,525.04 -334,525.04 100.00 -334,525.04 -0.14% None 0.00 None 1 Sub Total 555: Shadow Creek Impact 665,474.96 1.55 666,674.96 665,634.96 2.08 664,218.30 1,675.00 0.29% -1,416.66 220 0.6 L565:17evenue Bondi.099 Bi 2003 Prepared by Shamaira Jagrup 11 of 14 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To CaII/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity GNB Bank 1.5 6/30/2021 36198JCC6 248,000.00 6/30/2016 1.50 248,000.00 248,000.00 99.66 1.70 247,145.38 0.00 0.11% -854.62 None None 639 1.73 Texas Class LGIP TX-01-0615-0001 1/15/2017 236,318.64 100.00 236,318.64 236,318.64 2.20 236,318.64 2.20 0.1% None 0.00 None 1 0 Texas Class LGIP TX-01-0615-0007 5,743,055.97 9/19/2019 5,743,055.97 100.00 5,743,055.97 2.48% None 1 2.20 5,743,055.97 2.20 0.00 None 0 Texas Class LGIP TX-01-0615-0004 8,149,666.05 9/15/2018 8,149,666.05 100.00 8,149,666.05 3.52% None 1 2.20 8,149,666.05 2.20 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,508,575.38 100.00 1,508,575.38 0.65% None WFSWEEP 1,508,575.38 1.81 1,508,575.38 1.81 0.00 None 1 0 Wells Fargo TWDB Cash 9/15/2017 10,346,520.22 100.00 10,346,520.22 4.46% None WF5875 10,346,520.22 1.81 10,346,520.22 1.81 0.00 None 0 Sub Total 565: Revenue Bonds 1999 & 2003 26,232,136.26 26,232,136.26 2.02 26,232,136.26 2.02 26,231,281.64 0.00 11.32% -854.62 7 0.02 570: W/S •Pay As.You Go. Marine Bank Springfield IL 1.8 6/29/2021 56817TAB7 248,000.00 6/29/2017 1.80 248,000.00 248,000.00 100.09 1.75 248,213.12 12.23 0.11% 213.12 None None 638 1.72 Wells Fargo Sweep Cash WFSWEEP 6,567,589.38 12/31/2007 6,567,589.38 1.81 6,567,589.38 100.00 6,567,589.38 1.81 2.83% None 0.00 None 0 Sub Total 570: W/S Pay As You Go 6,815,589.38 1.81 6,815,589.38 6,815,589.38 1.81 6,815,802.50 12.23 2.94% 213.12 24 0.06 575;.'MUD 4 CapitarPrOdrams' Wells Fargo Sweep Cash WFSWEEP 25,447.93 2/1/2013 1.81 25,447.93 25,447.93 100.00 1.81 25,447.93 0.01% 0.00 None None 0 Sub Total 575: MUD 4 Capital Programs 25,447.93 1.81 25,447.93 25,447.93 1.81 25,447.93 0.01% 0.00 0 1 600:%Water.&°Sewer Prepared by Shamaira Jagrup 12 of 14 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Parkside Finl Bank & Trust 1.3 7/19/2021-17 70147ABX1 248,000.00 7/18/2016 1.30 248,000.00 248,000.00 99.49 1.59 246,722.83 105.99 0.11% -1,277.17 None None 18 1.78 Portage County Bank 1.4 6/24/2021 73565NBQ5 6/24/2016 248,000.00 248,000.00 1.40 99.66 247,152.60 0.11% None 248,000.00 1.60 57.07 -847.40 None 633 1.71 Texas Class LGIP TX-01-0615-0001 10,805,041.40 12/20/2016 10, 805, 041.40 2.20 10,805,041.40 100.00 10,805,041.40 4.66% None 2.20 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 17,735,924.45 100.00 17,735,924.45 7.65% None WFSWEEP 17,735,924.45 1.81 17,735,924.45 1.81 0.00 None 0 Sub Total 600: Water & Sewer 29,036,965.85 1.95 29,036,965.85 29,036,965.85 1.95 29,034,841.28 163.06 12.53% 7 -2,124.57 0.03 610: Solidwaste. Wells Fargo Sweep Cash WFSWEEP 12/1/2006 318,723.21 100.00 318,723.21 0.14% None 318,723.21 1.81 318,723.21 1.81 0.00 None 1 0 Sub Total 610: Solidwaste 318,723.21 1.81 318,723.21 318,723.21 1.81 318,723.21 0.14% 1 0.00 0 1700: Property Liability Ins Wells Fargo Sweep Cash 10/31/2006 439,826.70 100.00 439,826.70 0.19% None WFSWEEP 439,826.70 1.81 439,826.70 1.81 0.00 None 0 Sub Total 700: Property Liability Ins 439,826.70 1.81 439,826.70 439,826.70 439,826.70 1.81 0.19% 1 0.00 0 701: Employee Benefit Fund Wells Fargo Sweep Cash 9/1/2007 29,139.26 100.00 29,139.26 0.01% None WFSWEEP 29,139.26 1.81 29,139.26 1.81 0.00 None 1 0 Sub Total 701: Employee Benefit Fund 29,139.26 1.81 29,139.26 29,139.26 1.81 29,139.26 0.01% 1 0.00 0 170: Health Claims Fund Wells Fargo Cash 7/21/2010 375,533.06 100.00 375,533.06 0.16% None 1 WF9871 375,533.06 0.75 375,533.06 0.75 0.00 None 0 Prepared by Shamaira Jagrup 13 of 14 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2019 Description CUSIP Face Amount / Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Cali/Maturity YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 3,231,131.60 9/15/2010 1.81 3,231,131.60 3,231,131.60 100.00 1.81 3,231,131.60 1.39% 0.00 None None 1 0 Sub Total 702: Health Claims Fund 3,606,664.66 3,606,664.66 1.70 3,606,664.66 1.70 3,606,664.66 1.55% 0.00 1 0 I703:',Motor;Pool Fund Wells Fargo Sweep Cash 10/15/2018 859,963.99 100.00 859,963.99 0.37% None 1 WFSWEEP 859,963.99 1.81 859,963.99 1.81 0.00 None 0 Sub Total 703: Motor Pool Fund 859,963.99 859,963.99 1.81 859,963.99 1.81 859,963.99 0.37% 1 0.00 0 231,775,891.94 TOTAL PORTFOLIO 231,767,828.94 2.00 231,766,578.25 231,737,970.28 100.00% 42 2.02 86,890.28 -28,607.97 0.14 Prepared by Shamaira Jagrup 14 of 14 City of Pearland Treasury Yield Curve Treasury 6/30/2019 9/30/2019 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year 2.22 2.22 2.17 2.00 1.81 1.78 1.83 2.07 1.99 1.94 1.90 1.80 1.65 1.59 1.57 1.70 2.50 — 2.00 - 1.50 - 1.00 - 0.50 - 0.00 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year • 6/30/2019 • 9/30/2019 Prepared by Shamaira Jagrup 1 of 1 Bank Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Pledged Collateral Reconciliation Report September 30, 2019 Account Ending 3395 2841 5455 7843 1790 9871 4094 4102 5883 5875 6624 2847 Account Name Credit Card Account Sweep Account False Alarm Reduction Program Alvin ISD EMS Payments Health Claims Escrow W&S Revenue Bonds, Series 2016B Escrow W&S Revenue Bonds, Series 2016C Texas Permanent W&S System Revenue 2017B Texas Permanent W&S System Revenue 2017A Escrow W&S Revenue Bonds, Series 2018A Escrow W&S Revenue Bonds, Series 2019A Total of Bank Balances Pledged Collateral for City FDIC Insurance Amount 204,694.00 * 286,218.68 9,459,594.19 375,533.06 $ 10,326,039.93 32,580,264.71 500,000.00 Over (Under) Collateralized $ Total % Collateralized Bank Account Ending Account Name Wells Fargo 4258 Development Authority Total of Bank Balances Pledged Collateral for DAP FDIC Insurance 33,080,264.71 22,754,224.78 320.4% Amount 7,166, 900.42 $ 7,166,900.42 7,425,196.23 250,000.00 Over (Under) Collateralized $ Total % Collateralized Total % Collateralized Status 7,675,196.23 508,295.81 107.1% 233.0% Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral.