The URL can be used to link to this page

R2019-118 2019-05-13 RESOLUTION NO. R2019-118 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending March 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 March 2019. PASSED, APPROVED and ADOPTED this the 13th day of May, A.D., 2019. Ont TOM REID MAYOR ATTEST: G —FIN , 'M% _". " YS.F'ETAR APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY r‘ City of Pearland EAI�LAND4 Quarterly Investment Report December 31, 2018 to March 31, 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 1/31/2019 244,823,171.36 245,185,504.35 -362,332.99 2.28 2.58 458,546.59 68 2/28/2019 227,010,499.36 227,342,596.35 -332,096.99 2.29 2.55 427,343.46 68 3/31/2019 223,686,102.52 223,936,224.47 -250,121.95 2.36 2.49 427,655.70 64 Total/Average 231,839,924.41 232,154,775.06 -314,850.64 2.31 2.54 1,313,545.75 67 itt‘y#2 li '7 i 111/1/a4,14- COW __ LI I 241 Cynthia Pearson, irector of Finance Date Rhonda Daugherty,Assis nt Directo f Finance Date Avvvw2A.AA �P HiI6Iil Shamaira Jagru ,Treasury Analyst Date • f f4 z C City of Pearland 4 O iiiii Distribution by Security Type - Book Value Report Group: Pearland Begin Date: 12/31/2018,End Date:3/31/2019 Security Type Allocation Book Value %of Portfolio Book Value %of Portfolio Security Type 12/31/2018 12/31/2018 3/31/2019 3/31/2019 Cash 106,951,361.78 46.35 82,136,799.65 36.68 Certificate Of Deposit 16,858,000.00 7.31 15,122,000.00 6.75 Compound CD 508,192.94 0.22 508,192.94 0.23 FAMC Bond 7,001,354.11 3.03 7,000,984.11 3.13 FFCB Bond 2,000,000.00 0.87 1,000,000.00 0.45 FHLB Bond 3,999,371.73 1.73 3,999,585.10 1.79 FHLMC Bond 5,687,204.90 2.46 3,688,434.82 1.65 FNMA Bond 2,012,853.23 0.87 1,010,564.30 0.45 Local Government Investment Pool 85,707,112.32 37.15 109,469,663.55 48.88 Total/Average 230,725,451.01 100.00 223,936,224.47 100.00 Portfolio Holdings as of 12/31/2018 Portfolio Holdings as of 3/31/2019 • 46.35%-Cash • 36.68%-Cash 7.31%-Certificate Of.. • 6.75%-Certificate Of... 411111.\ • 0.22%-Compound CD • 0.23%-Compound CD • 3.03% FAMC Bond • 3.13%-FAMC Bond igy • 0.87%-FFCB Bond " • 0.45% FFCB Bond 1.73%-FHLB Bond 1.79% FHLB Bond • • 1.65%-FHLMC Bond 2.46% FHLMC Bond • 0.87%-FNMA Bond 0.45% FNMA Bond 37.15% Local Governm...' 48,88%-Local Governm... • Prepared by Shamaira Jagrup 1 of 1 City of Pearland liiiiikkata Distribution by Maturity Range - Book Value '''Ir" '0A# Report Group: Pearland Begin Date:12/31/2018,End Date:3/31/2019 Maturity Range Allocation Book Value %of Portfolio Book Value %of Portfolio Maturity Range 12/31/2018 12/31/2018 3/31/2019 3/31/2019 0-1 Month 193,906,474.10 84.04 191,854,463.20 85.67 1-3 Months 4,488,772.53 1.95 2,748,192.94 1.23 3-6 Months 2,996,192.94 1.30 6,484,851.43 2.90 6-9 Months 6,484,808.06 2.81 2,480,000.00 1.11 9-12 Months 2,728,000.00 1.18 5,232,717.78 2.34 1-2 Years 11,228,998.48 4.87 8,231,564.30 3.68 2-3 Years 8,892,204.90 3.85 6,904,434.82 3.08 Total/Average 230,725,451.01 100.00 223,936,224.47 100.00 Portfolio Holdings 200,000 180,000 160,000 ,,, 140,000 v foc 120,000 v. E 100,000 • 12/31/2018 0 lL— 80,000 3/31/2019 c — 60,000 40,000 20,000 00 iw'.'r 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 �04 °` , City of Pearland 6 Total Rate of Return - Book Value by Month !Sr' ig4% Report Group: Pearland Begin Date:4/30/2018,End Date:3/31/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 4/30/2018 214,131,616.64 292,274.86 0.00 292,274.86 211,794,160.07 0.14 1.67 2.15 5/31/2018 210,322,591.04 296,309.92 0.00 296,309.92 207,414,463.44 0.14 1.73 2.27 6/30/2018 204,643,326.67 281,020.42 0.00 281,020.42 203,421,522.63 0.14 1.67 2.33 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 Annualized TRR-BV 3.00 2.50 2.00 * Portfolio 1.50 Treasury 1 Year 1.00 0.50 0.00 04/2018 05/2018 06/2018 07/2018 08/2018 09/2018 10/2018 11/2018 12/2018 01/2019 02/2019 03/2019 Prepared by Shamaira Jagrup 1 of 1 l P#q i , City of Pearland DiStita Portfolio Holdings by Security Type Fa{. me% Report Group: Pearland Date:3/31/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 414,146.99 100.00 414,146.99 0.18% None 1 WF9871 414,146.99 0.75 414,146.99 0.75 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,505,919.02 100.00 2,505,919.02 1.12% None 1 WFSWEEP 2,505,919.02 2.32 2,505,919.02 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 5,335.36 100.00 5,335.36 0% None 1 WFSWEEP 5,335.36 2.32 5,335.36 2.32 0.00 None 0 Wells Fargo Sweep Cash 10/31/2006 506,993.96 100.00 506,993.96 0.23% None 1 WFSWEEP 506,993.96 2.32 506,993.96 2.32 0.00 None 0 Wells Fargo Sweep Cash 10/15/2018 1,622,211.40 100.00 1,622,211.40 0.72% None 1 WFSWEEP 1,622,211.40 2.32 1,622,211.40 2.32 0.00 None 0 Wells Fargo Sweep Cash 2/1/2013 25,276.65 100.00 25,276.65 0.01% None 1 WFSWEEP 25,276.65 2.32 25,276.65 2.32 0.00 None 0 Wells Fargo Sweep Cash 12/1/2006 -1,232,766.26 100.00 -1,232,766.26 -0.55% None 1 WFSWEEP -1,232,766.26 2.32 -1,232,766.26 2.32 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 168,568.96 100.00 168,568.96 0.08% None 1 WFSWEEP 168,568.96 2.32 168,568.96 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 132,076.25 100.00 132,076.25 0.06% None 1 WFSWEEP 132,076.25 2.32 132,076.25 2.32 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,958,554.43 100.00 2,958,554.43 1.32% None 1 WFSWEEP 2,958,554.43 2.32 2,958,554.43 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 10,424.38 100.00 10,424.38 0% None 1 WFSWEEP 10,424.38 2.32 10,424.38 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 69,974.70 100.00 69,974.70 0.03% None 1 WFSWEEP 69,974.70 2.32 69,974.70 2.32 0.00 None 0 Prepared by Shamaira Jagrup 1 of 12 City of Pearland Portfolio Holdings by Security Type kdr. 140% Report Group: Pearland Date:3/31/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 357,775.53 100.00 357,775.53 0.16% None 1 WFSWEEP 357,775.53 2.32 357,775.53 2.32 0.00 None 0 Wells Fargo Sweep Cash 9/1/2007 58,403.65 100.00 58,403.65 0.03% None 1 WFSWEEP 58,403.65 2.32 58,403.65 2.32 0.00 None 0 Wells Fargo Sweep Cash 12/31/2007 4,254,614.43 100.00 4,254,614.43 1.9% None 1 WFSWEEP 4,254,614.43 2.32 4,254,614.43 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -375,080.46 100.00 -375,080.46 -0.17% None 1 WFSWEEP -375,080.46 2.32 -375,080.46 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 11,966.05 100.00 11,966.05 0.01% None 1 WFSWEEP 11,966.05 2.32 11,966.05 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,342,615.59 100.00 2,342,615.59 1.05% None 1 WFSWEEP 2,342,615.59 2.32 2,342,615.59 2.32 0.00 None 0 Wells Fargo Sweep Cash 9/15/2009 41,225.69 100.00 41,225.69 0.02% None 1 WFSWEEP 41,225.69 2.32 41,225.69 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 10,205,343.25 100.00 10,205,343.25 4.56% None 1 WFSWEEP 10,205,343.25 2.32 10,205,343.25 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -210,680.10 100.00 -210,680.10 -0.09% None 1 WFSWEEP -210,680.10 2.32 -210,680.10 2.32 . 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 3,204.87 100.00 3,204.87 0% None 1 WFSWEEP 3,204.87 2.32 3,204.87 2.32 0.00 None 0 • Wells Fargo Sweep Cash 5/31/2006 483,086.77 100.00 483,086.77 0.22% None 1 WFSWEEP 483,086.77 2.32 483,086.77 2.32 0.00 None 0 Wells Fargo Sweep Cash 6/30/2006 53,547.74 100.00 53,547.74 0.02% None 1 WFSWEEP 53,547.74 2.32 53,547.74 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,017,464.68 100.00 1,017,464.68 0.45% None 1 WFSWEEP 1,017,464.68 2.32 1,017,464.68 2.32 0.00 None 0 Prepared by Shamaira Jagrup 2 of 12 O. fiO4 r{p F. y City of Pearland li Portfolio Holdings by Security Type qr. "B4D Report Group: Pearland Date:3/31/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 10/30/2008 894,087.93 100.00 894,087.93 0.4% None 1 WFSWEEP 894,087.93 2.32 894,087.93 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 182,872.52 100.00 182,872.52 0.08% None 1 WFSWEEP 182,872.52 2.32 182,872.52 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 137,263.82 100.00 137,263.82 0.06% None 1 WFSWEEP 137,263.82 2.32 137,263.82 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 401,245.98 100.00 401,245.98 0.18% None 1 WFSWEEP 401,245.98 2.32 401,245.98 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 30,854.52 100.00 30,854.52 0.01% None 1 WFSWEEP 30,854.52 2.32 30,854.52 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 19,176,613.59 100.00 19,176,613.59 8.56% None 1 WFSWEEP 19,176,613.59 2.32 19,176,613.59 2.32 0.00 None 0 Wells Fargo Sweep Cash 11/15/2015 29,766.43 100.00 29,766.43 0.01% None 1 WFSWEEP 29,766.43 2.32 29,766.43 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 804,705.93 100.00 804,705.93 0.36% None 1 WFSWEEP 804,705.93 2.32 804,705.93 2.32 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 149,809.34 100.00 149,809.34 0.07% None 1 WFSWEEP 149,809.34 2.32 149,809.34 2.32 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 10,234,862.10 100.00 10,234,862.10 4.57% None 1 WF5875 10,234,862.10 2.32 10,234,862.10 2.32 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 3,946,894.69 100.00 3,946,894.69 1.76% None 1 WF4102 3,946,894.69 2.32 3,946,894.69 2.32 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 82,449.35 100.00 82,449.35 0.04% None 1 WF4094 82,449.35 2.32 82,449.35 2.32 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 12,036,597.99 100.00 12,036,597.99 5.38% None 1 WF5883 12,036,597.99 2.32 12,036,597.99 2.32 0.00 None 0 Prepared by Shamaira Jagrup 3 of 12 fli ryy r City of Pearland r'+ Portfolio Holdings by Security Type `'r 's," Report Group: Pearland Date:3/31/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 Wells Fargo TWDB Cash 5/15/2018 8,598,571.93 100.00 8,598,571.93 3.84% None 1 WF6624 8,598,571.93 2.32 8,598,571.93 2.32 0.00 None 0 82,136,799.65 82,136,799.65 36.68% 1 Sub Total Cash 82,136,799.65 2.31 82,136,799.65 2.31 0.00 0 Certificate Of Deposit 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 97.59 242,030.80 0.11% None 663 33625CAZ2 248,000.00 1.10 248,000.00 2.46 67.27 -5,969.20 None 1.79 1st Source Bank 1.5 11/18/2019 4/17/2015 248,000.00 99.67 247,172.35 0.11% None 232 33646CEQ3 248,000.00 1.50 248,000.00 2.03 1,681.64 -827.65 None 0.63 Ally Bank Midvale Utah 1.8 6/29/2020 6/29/2017 248,000.00 99.17 245,940.34 0.11% None 456 02006L3U5 248,000.00 1.80 248,000.00 2.48 1,125.17 -2,059.66 None 1.23 Alma Bank 1.35 12/24/2020 6/24/2016 248,000.00 98.11 243,324.38 0.11% None 634 020080BB2 248,000.00 1.35 248,000.00 2.46 64.21 -4,675.62 None 1.71 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 97.69 242,280.72 0.11% None 834 02554BCM1 248,000.00 1.35 248,000.00 2.39 183.45 -5,719.28 None 2.25 Bank Leumi USA 1.3 2/26/2020 3/3/2016 248,000.00 99.45 246,630.06 0.11% None 332 063248FH6 248,000.00 1.30 248,000.00 1.92 291.48 -1,369.94 None 0.91 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 97.97 242,962.51 0.11% None 822 063847AL1 248,000.00 1.40 248,000.00 2.33 9.51 -5,037.49 None 2.21 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 99.68 247,210.64 0.11% None 544 066100CV1 248,000.00 1.80 248,000.00 2.02 73.38 -789.36 None 1.46 Bankwest,Inc.1.51/3/2020 3/4/2015 248,000.00 99.28 246,215.90 0.11% None 278 06652CFA4 248,000.00 1.50 248,000.00 2.46 285.37 -1,784.10 None 0.75 Bar Harbor Bank&Trust 2.65 3/29/2021 3/29/2018 248,000.00 100.03 248,067.13 0.11% None 29 -18 066851WB8 248,000.00 2.65 248,000.00 2.64 36.01 67.13 None 1.94 Prepared by Shamaira Jagrup 4 of 12 it' City of Pearland iikinkail Portfolio Holdings by Security Type `s' 'p' Report Group: Pearland Date:3/31/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 BARCLAYS BANK DELAWARE 1.95 5/6/2014 248,000.00 99.97 247,923.65 0.11% None 37 5/7/2019 06740KGU5 248,000.00 1.95 248,000.00 2.24 1,907.90 -76.35 None 0.1 Belmont Savings Bank 1.85 10/23/2019 12/23/2014 248,000.00 99.78 247,442.06 0.11% None 206 080515BDO 248,000.00 1.85 248,000.00 2.25 1,231.85 -557.94 None 0.56 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 , 99.40 246,519.80 0.11% None 446 05580ABX1 248,000.00 2.10 248,000.00 2.60 1,455.39 -1,480.20 None 1.2 Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 97.54 241,889.16 0.11% None 822 099703EF3 248,000.00 1.40 248,000.00 2.53 9.51 -6,110.84 None 2.21 Brickell Bank Miami FL 1.65 10/28/2019 6/27/2017 248,000.00 99.56 246,900.51 0.11% None 211 10801DAG6 248,000.00 1.65 248,000.00 2.43 33.63 -1,099.49 None 0.57 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 98.43 244,117.84 0.11% None 815 12325EHU9 248,000.00 1.80 248,000.00 2.52 97.84 -3,882.16 None 2.18 Capital One Bank USA 1.1 11/19/2019 11/19/2014 248,000.00 99.79 247,468.00 0.11% None 233 140420QX1 248,000.00 1.10 248,000.00 1.44 986.56 -532.00 None 0.63 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 99.70 247,250.81 0.11% None 544 14042RAB7 248,000.00 2.30 248,000.00 2.51 93.76 -749.19 None 1.47 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 98.49 244,257.90 0.11% None 484 144153AW3 248,000.00 1.10 248,000.00 2.26 29.90 -3,742.10 None 1.31 Cedar Rapids Bank&Trust 1.5 1/30/2015 248,000.00 99.84 247,597.69 0.11% None 213 10/30/2019 150517CJ7 248,000.00 1.50 248,000.00 1.78 305.75 -402.31 None 0.58 Charter Bank 1.7 2/25/2020 2/25/2015 248,000.00 99.31 246,286.85 0.11% None 331 1611646E7 248,000.00 1.70 248,000.00 2.48 69.30 -1,713.15 None 0.89 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248,000.00 99.79 247,483.68 0.11% None 233 17284C3Z5 248,000.00 2.10 248,000.00 2.43 1,883.44 -516.32 None 0.63 Prepared by Shamaira Jagrup 5 of 12 p< e, `, City of Pearland Portfolio Holdings by Security Type `fr. '69. Report Group: Pearland Date:3/31/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 Citizens State Bank Clayton 1.35 4/30/2019 9/30/2015 248,000.00 99.97 247,926.46 0.11% None 30 176688657 248,000.00 1.35 248,000.00 1.72 9.17 -73.54 None 0.08 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 97.97 242,968.33 0.11% None 822 203507BG2 248,000.00 1.50 248,000.00 2.43 10.19 -5,031.67 None 2.21 Community Bankers'Bank 1.4 6/30/2016 248,000.00 97.97 242,962.51 0.11% None 822 6/30/2021 20361LBR4 248,000.00 1.40 248,000.00 2.33 9.51 -5,037.49 None 2.21 Discover Bank 2 2/25/2020 2/25/2015 248,000.00 99.58 246,951.08 0.11% None 331 254672JA7 248,000.00 2.00 248,000.00 2.47 462.03 -1,048.92 None 0.9 EVB Tappa Hannock VA 1.6 9/25/2019 9/25/2015 248,000.00 99.82 247,545.24 0.11% None 178 26927ABK7 248,000.00 1.60 248,000.00 1.98 65.23 -454.76 None 0.48 Exchange Bank NEB 1.05 1/21/2020 7/20/2016 248,000.00 98.87 245,194.04 0.11% None 296 301074CH1 248,000.00 1.05 248,000.00 2.47 78.48 -2,805.96 None 0.8 Fahey Banking 1.1 6/28/2019 3/29/2016 248,000.00 99.80 247,511.60 0.11% None 89 303117CC7 248,000.00 1.10 248,000.00 1.92 22.42 -488.40 None 0.24 FIRST BANK HIGHLAND PARK 1.85 5/7/2014 248,000.00 99.95 247,883.57 0.11% None 37 5/7/2019-14 319141BL0 248,000.00 1.85 248,000.00 2.29 1,810.06 -116.43 None 0.1 First Business Bank 1.7 6/30/2020 9/30/2015 248,000.00 99.05 245,637.38 0.11% None 457 31938QP40 248,000.00 1.70 248,000.00 2.48 11.55 -2,362.62 None 1.24 First Capital Bank 1.4 8/6/2019 4/6/2015 248,000.00 99.80 247,505.84 .0.11% None 128 31944FBK5 248,000.00 1.40 248,000.00 1.98 237.81 -494.16 None 0.35 First Financial NW 1.35 10/30/2019 10/30/2015 248,000.00 99.38 246,454.11 0.11% None 213 32022MAF5 248,000.00 1.35 248,000.00 2.43 0.00 -1,545.89 None 0.58 First Intl Bank&Trust 1.6 1/16/2020 10/16/2015 248,000.00 99.32 246,324.88 0.11% None 291 32057GAE9 248,000.00 1.60 248,000.00 2.46 163.07 -1,675.12 None 0.79 Prepared by Shamaira Jagrup 6 of 12 �` A{' City of Pearland 4"" O Portfolio Holdings by Security Type `ir. % Report Group: Pearland Date:3/31/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 First National Bank of America 1.25 7/15/2016 248,000.00 97.14 240,900.62 0.11% None 837 7/15/2021 32110YHMO 248,000.00 1.25 248,000.00 2.54 636.99 -7,099.38 None 2.26 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 97.97 242,968.33 0.11% None 822 36198JCC6 248,000.00 1.50 248,000.00 2.43 10.19 -5,031.67 None 2.21 Goldman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 99.58 246,951.08 0.11% None 331 38148JLL3 248,000.00 2.00 248,000.00 2.47 462.03 -1,048.92 None 0.9 Gulf Coast Bank&Trust 1.3 7/15/2021- 7/15/2016 248,000.00 97.70 242,299.21 0.11% None 15 17 402194EX8 248,000.00 1.30 248,000.00 2.33 141.33 -5,700.79 None 2.26 JP Morgan Chase Bk NA Columbus 2.1 2/15/2017 245,000.00 99.35 243,409.33 0.11% None 15 2/15/2021-17 48126XVW2 245,000.00 2.10 245,000.00 2.46 225.53 -1,590.67 None 1.84 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 97.97 242,956.07 0.11% None 822 53362LAB0 248,000.00 1.40 248,000.00 2.33 285.37 -5,043.93 None 2.21 Machias Savings Bank 1.65 2/6/2020 2/6/2015 248,000.00 99.77 247,427.86 0.11% None 312 554479DS1 248,000.00 1.65 248,000.00 1.92 280.27 -572.14 None 0.84 Mahopac Bank 1.45 7/30/2019 1/30/2015 248,000.00 99.90 247,744.74 0.11% None 121 560160AQ6 248,000.00 1.45 248,000.00 1.76 591.12 -255.26 None 0.33 Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 98.52 244,334.51 0.11% None 821 56817TAB7 248,000.00 1.80 248,000.00 2.48 24.46 -3,665.49 None 2.2 Marlin Business Bank 1.25 12/27/2019 6/29/2016 248,000.00 99.14 245,862.20 0.11% None 271 57116AMC9 248,000.00 1.25 248,000.00 2.43 16.99 -2,137.80 None 0.74 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 100.67 249,671.21 0.11% None 736 61747MS69 248,000.00 2.80 248,000.00 2.46 3,367.36 1,671.21 None 1.95 National Bank Commerce Superior 1.25 7/15/2016 248,000.00 97.70 242,298.00 0.11% None 837 7/15/2021-17 633368EB7 248,000.00 1.25 248,000.00 2.28 135.89 -5,702.00 None 2.26 Prepared by Shamaira Jagrup 7 of 12 y City of Pearland 4 O IMAM Portfolio Holdings by Security Type '.4r. .84% Report Group: Pearland Date:3/31/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 Northern Bank&Trust MA 1.1 7/12/2016 248,000.00 99.66 247,167.22 0.11% None 12 7/12/2019-17 66476QBH0 248,000.00 1.10 248,000.00 2.28 582.97 -832.78 None 0.28 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 98.63 244,591.57 0.11% None 457 69413CFD6 248,000.00 1.25 248,000.00 2.37 8.49 -3,408.43 None 1.24 Parkside Finl Bank&Trust 1.3 7/18/2016 248,000.00 97.68 242,254.24 0.11% None 18 7/19/2021-17 70147ABX1 248,000.00 1.30 248,000.00 2.34 114.83 -5,745.76 None 2.27 Partners Bank 1.5 9/30/2019 3/30/2015 248,000.00 99.77 247,435.97 0.11% None 183 70212YAR3 248,000.00 1.50 248,000.00 1.96 0.00 -564.03 None 0.5 Pearland State Bank 0.9 7/24/2019 7/24/2018 245,000.00 100.00 '245,000.00 0.11% None 115 700013947C 245,000.00 0.90 245,000.00 0.90 1,510.27 0.00 None 0.32 Peoples United Bank 1.9 11/19/2019 11/19/2014 248,000.00 99.78 247,452.26 0.11% None 233 71270QKM7 248,000.00 1.90 248,000.00 2.25 1,704.07 -547.74 None 0.63 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 97.99 243,018.72 0.11% None 816 73565NBQ5 248,000.00 1.40 248,000.00 2.33 66.59 -4,981.28 None 2.2 Quantum National Bank 1.2 9/18/2019-16 3/18/2016 248,000.00 99.47 246,695.92 0.11% None 79 • 74765JETI 248,000.00 1.20 248,000.00 2.34 105.99 -1,304.08 None 0.46 Sallie Mae Bank 2.15 11/19/2019 11/19/2014 248,000.00 99.79 247,468.01 0.11% None 233 795450VC6 248,000.00 2.15 248,000.00 2.49 1,928.28 -531.99 None 0.63 Summit Community Bank Moorefield WV 6/30/2017 248,000.00 99.80 247,505.33 0.11% None 89 1.55 6/28/2019 86604XLX2 248,000.00 1.55 248,000.00 2.38 31.59 -494.67 None 0.24 Umpqua Bank Roseburg OR 1.6 6/28/2019 6/30/2017 248,000.00 99.81 247,525.92 0.11% None 89 90421MAX1 248,000.00 1.60 248,000.00 2.38 989.28 -474.08 None 0.24 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 99.67 247,171.22 0.11% None 579 91330ABC0 248,000.00 1.65 248,000.00 1.86 0.00 -828.78 None 1.56 Prepared by Shamaira Jagrup 8 of 12 �' °r\City of Pearland e libtatial Portfolio Holdings by Security Type `s'. °* Report Group: Pearland Date:3/31/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 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 97.70 242,295.31 0.11% None 834 92834CBW1 248,000.00 1.30 248,000.00 2.34 697.80 -5,704.69 None 2.25 Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 98.51 244,314.26 0.11% None 731 938828AC4 248,000.00 1.50 248,000.00 2.26 0.00 -3,685.74 None 1.97 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 98.03 243,110.86 0.11% None 809 9497485W3 248,000.00 1.75 248,000.00 2.67 166.47 -4,889.14 None 2.17 15,122,000.00 14,981,667.79 6.71000000000001% 399 Sub Total Certificate Of Deposit 15,122,000.00 1.57 15,122,000.00 2.27 28,886.00 -140,332.21 1.22 Compound CD CDARS 1.05 6/15/2019 6/15/2017 508,192.94 100.00 508,192.94 0.23% None 76 CDARS061517 508,192.94 1.05 508,192.94 1.05 1,315.73 0.00 None 0.21 508,192.94 508,192.94 0.23% 76 Sub Total Compound CD 508,192.94 1.05 508,192.94 1.05 1,315.73 0.00 0.21 FAMC Bond FAMC 1.58/22/2019 2/22/2017 2,001,700.00 99.66 1,993,198.02 0.89% S&P-AA+ 144 3132X0PV7 2,000,000.00 1.47 2,000,266.33 2.37 3,250.00 -7,068.31 Moodys-Aaa 0.39 FAMC 1.58/22/2019 2/22/2017 1,000,000.00 99.66 996,599.01 0.45% S&P-AA+ 144 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.37 1,625.00 -3,400.99 Moodys-Aaa 0.39 FAMC 1.58/22/2019 2/22/2017 1,000,000.00 99.66 996,599.01 0.45% S&P-AA+ 144 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.37 1,625.00 -3,400.99 Moodys-Aaa 0.39 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 99.33 993,329.91 0.45% Moodys-Aaa 330 3132X0PW5 1,000,000.00 1.63 1,000,358.89 2.43 1,721.53 -7,028.98 S&P-AA+ 0.89 FAMC 1.6752/24/2020 2/24/2017 1,001,200.00 99.33 993,329.91 0.45% Moodys-Aaa 330 3132X0PW5 1,000,000.00 1.63 1,000,358.89 2.43 1,721.53 -7,028.98 S&P-AA+ 0.89 FAMC 1.82 11/9/2020 11/9/2017 1,000,000.00 99.12 991,235.27 0.45% Moodys-Aaa • 589 3132X0ZC8 1,000,000.00 1.82 1,000,000.00 2.38 7,178.89 -8,764.73 S&P-AA+ 1.58 Prepared by Shamaira Jagrup 9 of 12 4.°, A, 'e, City of Pearland 4 O Cateagril Portfolio Holdings by Security Type `s' °* Report Group: Pearland Date:3/31/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 7,004,100.00 6,964,291.13 3.14% 261 Sub Total FAMC Bond 7,000,000.00 1.57 7,000,984.11 2.39 17,121.95 -36,692.98 0.7 FFCB Bond FFCB 1.84 10/30/2020-18 10/30/2017 1,000,000.00 99.23 992,279.53 0.45% Moodys-Aaa 579 3133EHM26 1,000,000.00 1.84 1,000,000.00 2.34 7,666.67 -7,720.47 S&P-AA+ 1.56 1,000,000.00 992,279.53 0.45% 579 Sub Total FFCB Bond 1,000,000.00 1.84 1,000,000.00 2.34 7,666.67 -7,720.47 1.56 FHLB Bond FHLB 1 9/26/2019 9/22/2016 997,430.00 99.30 993,049.98 0.45% Moodys-Aaa 179 3130A9EP2 1,000,000.00 1.09 999,585.10 2.45 138.89 -6,535.12 S&P-AA+ 0.49 FHLB 1.456/28/2019-17 6/28/2017 1,000,000.00 99.77 997,658.27 0.45% Moodys-Aaa 89 3130ABHRO 1,000,000.00 1.45 1,000,000.00 2.42 3,745.83 -2,341.73 S&P-AA+ 0.24 FHLB 2.21/29/2021-19 1/29/2018 1,000,000.00 99.39 993,909.83 0.45% Moodys-Aaa 29 3130ADC26 1,000,000.00 2.20 1,000,000.00 2.54 3,788.89 -6,090.17 S&P-AA+ 1.8 FHLB 2.4 3/27/2020-18 3/27/2018 1,000,000.00 99.86 998,556.15 0.45% S&P-AA+ 88 3130ADSH6 1,000,000.00 2.40 1,000,000.00 2.55 266.67 -1,443.85 Moodys-Aaa • 0.98 3,997,430.00 3,983,174.23 1.8% 96 Sub Total FHLB Bond 4,000,000.00 1.78 3,999,585.10 2.49 7,940.28 -16,410.87 0.88 FHLMC Bond FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 97.28 972,824.58 0.44% Moodys-Aaa 865 3137EAEC9 1,000,000.00 1.37 994,458.83 2.31 1,375.00 -21,634.25 S&P-AA+ 2.34 FHLMC 2 11/20/2020-18 12/5/2017 1,000,000.00 99.36 993,555.05 0.45% Moodys-Aaa 50 3134GBW32 1,000,000.00 2.00 1,000,000.00 2.40 7,277.78 -6,444.95 S&P-AA+ 1.61 FHLMC 2.2 12/8/2021-18 12/8/2017 1,000,000.00 99.39 993,896.90 0.45% Moodys-Aaa 69 3134GB4N9 1,000,000.00 2.20 1,000,000.00 2.44 6,905.56 -6,103.10 S&P-AA+ 2.61 FHLMC Step 8/3/2021-18 3/9/2018 691,243.00 99.58 697,092.26 0.31% S&P-AA+ 33 3134GBA93 700,000.00 2.61 693,975.99 2.55 2,255.56 3,116.27 Moodys-Aaa 2.29 Prepared by Shamaira Jagrup 10 of 12 YO City of Pearland 4.7'a6ilrtg Portfolio Holdings by Security Type `ir. ,s°, Report Group: Pearland Date:3/31/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 3,679,783.00 3,657,368.79 1.65% 272 Sub Total FHLMC Bond 3,700,000.00 2.00 3,688,434.82 2.42 17,813.90 -31,066.03 2.21 FNMA Bond FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 99.27 992,664.91 0.45% Moodys-Aaa 638 3135G0H55 1,000,000.00 1.25 1,010,564.30 2.31 4,843.75 -17,899.39 S&P-AA+ 1.71 1,025,880.00 992,664.91 0.45% 638 Sub Total FNMA Bond 1,000,000.00 1.25 1,010,564.30 2.31 4,843.75 -17,899.39 1.71 Local Government Investment Pool Texas Class LGIP 9/15/2018 8,023,647.15 100.00 8,023,647.15 3.58% None 1 TX-01-0615-0005 8,023,647.15 2.61 8,023,647.15 2.61 0.00 None 0 Texas Class LGIP 9/15/2018 7,638,431.07 100.00 7,638,431.07 3.41% None 1 TX-01-0615-0006 7,638,431.07 2.61 7,638,431.07 2.61 0.00 None 0 Texas Class LGIP 5/15/2017 3,110,005.27 100.00 3,110,005.27 1.39% None 1 TX-01-0615-0001 3,110,005.27 2.61 3,110,005.27 2.61 0.00 None 0 Texas Class LGIP 12/20/2016 10,657,819.66 100.00 10,657,819.66 4.76% None 1 TX-01-0615-0001 10,657,819.66 2.61 10,657,819.66 2.61 0.00 None 0 Texas Class LGIP 1/15/2017 1,039,619.50 100.00 1,039,619.50 0.46% None 1 TX-01-0615-0001 1,039,619.50 2.61 1,039,619.50 2.61 0.00 None 0 Texas Class LGIP 1/15/2017 12,969,256.47 100.00 12,969,256.47 5.79% None 1 TX-01-0615-0001 12,969,256.47 2.61 12,969,256.47 2.61 0.00 None 0 Texas Class LGIP 1/15/2017 233,098.74 100.00 233,098.74 0.1% None 1 TX-01-0615-0001 233,098.74 2.61 233,098.74 2.61 0.00 None 0 Texas Class LGIP 5/15/2017 668,515.04 100.00 668,515.04 0.3% None 1 TX-01-0615-0001 668,515.04 2.61 668,515.04 2.61 0.00 None 0 Texas Class LGIP 12/20/2016 21,722,133.87 100.00 21,722,133.87 9.7% None 1 TX-01-0615-0001 21,722,133.87 2.61 21,722,133.87 2.61 0.00 None 0 Prepared by Shamaira Jagrup 11 of 12 0. °` Y,a City of Pearland leittlfite Portfolio Holdings by Security Type I/. iW Report Group: Pearland Date:3/31/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 3,399,238.60 100.00 3,399,238.60 1.52% None 1 TX-01-0615-0001 3,399,238.60 2.61 3,399,238.60 2.61 0.00 None 0 Texas Class LGIP 9/15/2018 5,171,888.48 100.00 5,171,888.48 2.31% None 1 TX-01-0615-0004 5,171,888.48 2.61 5,171,888.48 2.61 0.00 None 0 Texas Class LGIP 5/15/2017 15,038,284.64 100.00 15,038,284.64 6.72% None 1 TX-01-0615-0001 15,038,284.64 2.61 15,038,284.64 2.61 0.00 None 0 Texas Class LGIP 9/15/2018 16,009,931.85 100.00 16,009,931.85 7.15% None 1 TX-01-0615-0004 16,009,931.85 2.61 16,009,931.85 2.61 0.00 None 0 Texas Class LGIP 12/20/2016 5,886.70 100.00 5,886.70 0% None 1 TX-01-0615-0001 5,886.70 2.61 5,886.70 2.61 0.00 None 0 TexSTAR LGIP 8/26/2016 2,151,228.19 100.00 2,151,228.19 0.96% S&P-AAA 1 02000-11110 2,151,228.19 2.41 2,151,228.19 2.41 0.00 None 0 TexSTAR LGIP 8/26/2016 1,630,678.32 100.00 1,630,678.32 0.73% S&P-AAA 1 02000-11110 1,630,678.32 2.41 1,630,678.32 2.41 0.00 None 0 109,469,663.55 109,469,663.55 48.88% 1 Sub Total Local Government Investment 109,469,663.55 2.60 109,469,663.55 2.60 0.00 0 Pool 223,943,849.14 223,686,102.52 100.00% 48 TOTAL PORTFOLIO 223,936,656.14 2.36 223,936,224.47 2.46 85,588.28 -250,121.95 0.17 Prepared by Shamaira Jagrup 12 of 12 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/31/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 100:General Fund Alma Bank 1.35 12/24/2020 6/24/2016 248,000.00 98.11 243,324.38 0.11% No 634 020080BB2 248,000.00 1.35 248,000.00 2.46 64.21 -4,675.62 None 1.71 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 97.69 242,280.72 0.11% None 834 02554BCM1 248,000.00 1.35 248,000.00 2.39 183.45 -5,719.28 None 2.25 Bank Leumi USA 1.3 2/26/2020 3/3/2016 248,000.00 99.45 246,630.06 0.11% None 332 063248FH6 248,000.00 1.30 248,000.00 1.92 291.48 -1,369.94 None 0.91 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 99.68 247,210.64 0.11% None 544 06610QCV1 248,000.00 1.80 248,000.00 2.02 73.38 -789.36 None 1.46 Bar Harbor Bank&Trust 2.65 3/29/2021 3/29/2018 248,000.00 100.03 248,067.13 0.11% None 29 -18 066851WB8 248,000.00 2.65 248,000.00 2.64 36.01 67.13 None 1.94 Belmont Savings Bank 1.85 10/23/2019 12/23/2014 248,000.00 99.78 247,442.06 0.11% None 206 080515BD0 248,000.00 1.85 248,000.00 2.25 1,231.85 -557.94 None 0.56 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 99.70 247,250.81 0.11% None 544 14042RAB7 248,000.00 2.30 248,000.00 2.51 93.76 -749.19 None 1.47 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 98.49 244,257.90 0.11% None 484 144153AW3 248,000.00 1.10 248,000.00 2.26 29.90 -3,742.10 None 1.31 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248,000.00 99.79 247,483.68 0.11% None 233 17284C3Z5 248,000.00 2.10 248,000.00 2.43 1,883.44 -516.32 None 0.63 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 97.97 242,968.33 0.11% None 822 203507BG2 248,000.00 1.50 248,000.00 2.43 10.19 -5,031.67 None 2.21 Community Bankers'Bank 1.4 6/30/2016 248,000.00 97.97 242,962.51 0.11% None 822 6/30/2021 20361LBR4 248,000.00 1.40 248,000.00 2.33 9.51 -5,037.49 None 2.21 Exchange Bank NEB 1.05 1/21/2020 7/20/2016 248,000.00 98.87 245,194.04 0.11% None 296 301074CH1 248,000.00 1.05 248,000.00 2.47 78.48 -2,805.96 None 0.8 Prepared by Shamaira Jagrup 1 of 15 4 OF Oi 'Co a City of Pearland Portfolio Holdings by Portfolio Name r''. ,°"* Report Group: Pearland Date:3/31/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 Fahey Banking 1.1 6/28/2019 3/29/2016 248,000.00 99.80 247,511.60 0.11% None 89 303117CC7 248,000.00 1.10 248,000.00 1.92 22.42 -488.40 None 0.24 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 99.33 993,329.91 0.45% Moodys-Aaa 330 3132X0PW5 1,000,000.00 1.63 1,000,358.89 2.43 1,721.53 -7,028.98 S&P-AA+ 0.89 FHLB 1.45 6/28/2019-17 6/28/2017 1,000,000.00 99.77 997,658.27 0.45% Moodys-Aaa 89 3130ABHRO 1,000,000.00 1.45 1,000,000.00 2.42 3,745.83 -2,341.73 S&P-AA+ 0.24 FHLB 2.4 3/27/2020-18 3/27/2018 1,000,000.00 99.86 998,556.15 0.45% S&P-AA+ 88 3130ADSH6 1,000,000.00 2.40 1,000,000.00 2.55 266.67 -1,443.85 Moodys-Aaa 0.98 FHLMC Step 8/3/2021-18 3/9/2018 691,243.00 99.58 697,092.26 0.31% S&P-AA+ 33 3134GBA93 700,000.00 2.61 693,975.99 2.55 2,255.56 3,116.27 Moodys-Aaa 2.29 FIRST BANK HIGHLAND PARK 1.85 5/7/2014 248,000.00 99.95 247,883.57 0.11% None 37 5/7/2019-14 319141BL0 248,000.00 1.85 248,000.00 2.29 1,810.06 -116.43 None 0.1 JP Morgan Chase Bk NA Columbus 2.1 2/15/2017 245,000.00 99.35 243,409.33 0.11% None 15 2/15/2021-17 48126XVW2 245,000.00 2.10 245,000.00 2.46 225.53 -1,590.67 None 1.84 Machias Savings Bank 1.65 2/6/2020 2/6/2015 248,000.00 99.77 247,427.86 0.11% None 312 554479DS1 248,000.00 1.65 248,000.00 1.92 280.27 -572.14 None 0.84 Mahopac Bank 1.45 7/30/2019 1/30/2015 248,000.00 99.90 247,744.74 0.11% None 121 560160AQ6 248,000.00 1.45 248,000.00 1.76 591.12 -255.26 None 0.33 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 100.67 249,671.21 0.11% None 736 61747MS69 248,000.00 2.80 248,000.00 2.46 3,367.36 1,671.21 None 1.95 Pearland State Bank 0.9 7/24/2019 7/24/2018 245,000.00 100.00 245,000.00 0.11% None 115 700013947C 245,000.00 0.90 245,000.00 0.90 1,510.27 0.00 None 0.32 Quantum National Bank 1.2 9/18/2019-16 3/18/2016 248,000.00 99.47 246,695.92 0.11% None 79 74765JETI 248,000.00 1.20 248,000.00 2.34 105.99 -1,304.08 None 0.46 Prepared by Shamaira Jagrup 2 of 15 City of Pearland $. , O Maga Portfolio Holdings by Portfolio Name `f'. ..4. Report Group: Pearland Date:3/31/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 Sallie Mae Bank 2.15 11/19/2019 11/19/2014 248,000.00 99.79 247,468.01 0.11% None 233 795450VC6 248,000.00 2.15 248,000.00 2.49 1,928.28 -531.99 None 0.63 Texas Class LGIP 5/15/2017 15,038,284.64 100.00 15,038,284.64 6.72% None 1 TX-01-0615-0001 15,038,284.64 2.61 15,038,284.64 2.61 0.00 None 0 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 99.67 247,171.22 0.11% None 579 91330ABC0 248,000.00 1.65 248,000.00 1.86 0.00 -828.78 None 1.56 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 97.70 242,295.31 0.11% None 834 92834CBW1 248,000.00 1.30 248,000.00 2.34 697.80 -5,704.69 None 2.25 Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 98.51 244,314.26 0.11% None 731 938828AC4 248,000.00 1.50 248,000.00 2.26 0.00 -3,685.74 None 1.97 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 98.03 243,110.86 0.11% None 809 9497485W3 248,000.00 1.75 248,000.00 2.67 166.47 -4,889.14 None 2.17 Wells Fargo Sweep Cash 5/31/2006 10,205,343.25 100.00 10,205,343.25 4.56% None 1 WFSWEEP 10,205,343.25 2.32 10,205,343.25 2.32 0.00 None 0 35,130,070.89 35,075,040.63 15.69% 90 Sub Total 100:General Fund 35,137,627.89 2.29 35,131,962.77 2.44 22,680.82 -56,922.14 0.33 200:Debt Services 1st Source Bank 1.5 11/18/2019 4/17/2015 248,000.00 99.67 247,172.35 0.11% None 232 33646CEQ3 248,000.00 1.50 248,000.00 2.03 1,681.64 -827.65 None 0.63 Charter Bank 1.7 2/25/2020 2/25/2015 248,000.00 99.31 246,286.85 0.11% None 331 1611646E7 248,000.00 1.70 248,000.00 2.48 69.30 -1,713.15 None 0.89 Discover Bank 2 2/25/2020 2/25/2015 248,000.00 99.58 246,951.08 0.11% None 331 254672JA7 248,000.00 2.00 248,000.00 2.47 462.03 -1,048.92 None 0.9 First Capital Bank 1.4 8/6/2019 4/6/2015 248,000.00 99.80 247,505.84 0.11% None 128 31944FBK5 248,000.00 1.40 248,000.00 1.98 237.81 -494.16 None 0.35 Prepared by Shamaira Jagrup 3 of 15 City of Pearland Portfolio Holdings by Portfolio Name -, Report Group: Pearland Date:3/31/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 Goldman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 99.58 246,951.08 0.11% None 331 38148JLL3 248,000.00 2.00 248,000.00 2.47 462.03 -1,048.92 None 0.9 Partners Bank 1.5 9/30/2019 3/30/2015 248,000.00 99.77 247,435.97 0.11% None 183 70212YAR3 248,000.00 1.50 248,000.00 1.96 0.00 -564.03 None 0.5 Texas Class LGIP 1/15/2017 12,969,256.47 100.00 12,969,256.47 5.79% None 1 TX-01-0615-0001 12,969,256.47 2.61 12,969,256.47 2.61 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,505,919.02 100.00 2,505,919.02 1.12% None 1 WFSWEEP 2,505,919.02 2.32 2,505,919.02 2.32 0.00 None 0 16,963,175.49 16,957,478.66 7.57% 23 Sub Total 200:Debt Services 16,963,175.49 2.49 16,963,175.49 2.53 2,912.81 -5,696.83 0.06 305:Hotel/Motel Occupancy Ally Bank Midvale Utah 1.8 6/29/2020 6/29/2017 248,000.00 99.17 245,940.34 0.11% None 456 02006L3U5 248,000.00 1.80 248,000.00 2.48 1,125.17 -2,059.66 None 1.23 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 97.97 242,962.51 0.11% None 822 063847AL1 248,000.00 1.40 248,000.00 2.33 9.51 -5,037.49 None 2.21 First Intl Bank&Trust 1.6 1/16/2020 10/16/2015 248,000.00 99.32 246,324.88 0.11% None 291 32057GAE9 248,000.00 1.60 248,000.00 2.46 163.07 -1,675.12 None 0.79 Texas Class LGIP 5/15/2017 3,110,005.27 100.00 3,110,005.27 1.39% None 1 TX-01-0615-0001 3,110,005.27 2.61 3,110,005.27 2.61 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 804,705.93 100.00 804,705.93 0.36% None 1 WFSWEEP 804,705.93 2.32 804,705.93 2.32 0.00 None 0 4,658,711.20 4,649,938.93 2.08% 84 Sub Total 305:Hotel/Motel Occupancy 4,658,711.20 2.40 4,658,711.20 2.53 1,297.75 -8,772.27 0.23 310: Municipal Court Security Wells Fargo Sweep Cash 5/31/2006 30,854.52 100.00 30,854.52 0.01% None 1 WFSWEEP 30,854.52 2.32 30,854.52 2.32 0.00 None 0 Prepared by Shamaira Jagrup 4 of 15 . f4) City of Pearland ` 1 Portfolio Holdings by Portfolio Name '.---\\,71111_, -,,,, Report Group: Pearland Date:3/31/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 30,854.52 30,854.52 0.01% 1 Sub Total 310:Municipal Court Security 30,854.52 2.32 30,854.52 2.32 0.00 0 315:City Wide Donation Wells Fargo Sweep Cash 5/31/2006 137,263.82 100.00 137,263.82 0.06% None 1 WFSWEEP 137,263.82 2.32 137,263.82 2.32 0.00 None 0 137,263.82 137,263.82 0.06% 1 Sub Total 315.City Wide Donation 137,263.82 2.32 137,263.82 2.32 0.00 0 320:Court Technology Wells Fargo Sweep Cash 5/31/2006 10,424.38 100.00 10,424.38 0% None 1 WFSWEEP 10,424.38 2.32 10,424.38 2.32 0.00 None 0 10,424.38 10,424.38 0% 1 Sub Total 320:Court Technology 10,424.38 2.32 10,424.38 2.32 0.00 0 330: Park Donations Wells Fargo Sweep Cash 5/31/2006 69,974.70 100.00 69,974.70 0.03% None 1 WFSWEEP 69,974.70 2.32 69,974.70 2.32 0.00 None 0 69,974.70 69,974.70 0.03% 1 Sub Total 330:Park Donations 69,974.70 2.32 69,974.70 2.32 0.00 0 331:Tree Trust Fund Wells Fargo Sweep Cash 5/31/2006 483,086.77 100.00 483,086.77 0.22% None 1 WFSWEEP 483,086.77 2.32 483,086.77 2.32 0.00 None 483,086.77 483,086.77 0.22% 1 Sub Total 331:Tree Trust Fund 483,086.77 2.32 483,086.77 2.32 0.00 0 335: Police State Seizure Wells Fargo Sweep Cash 5/31/2006 132,076.25 100.00 132,076.25 0.06% None WFSWEEP 132,076.25 2.32 132,076.25 2.32 0.00 None 132,076.25 132,076.25 0.06% 1 Sub Total 335:Police State Seizure 132,076.25 2.32 132,076.25 2.32 0.00 0 336:Federal Police Fund Prepared by Shamaira Jagrup 5 of 1b 0`4 rg yy City of Pearland 6, iPortfolio Holdings by Portfolio Name qt. .0% Report Group: Pearland Date:3/31/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 149,809.34 100.00 149,809.34 0.07% None 1 WFSWEEP 149,809.34 2.32 149,809.34 2.32 0.00 None 0 149,809.34 149,809.34 0.07% 1 Sub Total 336:Federal Police Fund 149,809.34 2.32 149,809.34 2.32 0.00 0 340: Park&Rec Development Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 97.54 241,889.16 0.11% None 822 099703EF3 248,000.00 1.40 248,000.00 2.53 9.51 -6,110.84 None 2.21 Wells Fargo Sweep Cash 5/31/2006 1,017,464.68 100.00 1,017,464.68 0.45% None 1 WFSWEEP 1,017,464.68 2.32 1,017,464.68 2.32 0.00 None 0 1,265,464.68 1,259,353.84 0.56% 162 Sub Total 340:Park&Rec Development 1,265,464.68 2.14 1,265,464.68 2.36 9.51 -6,110.84 0.43 345:Sidewalk Fund Wells Fargo Sweep Cash 5/31/2006 11,966.05 100.00 11,966.05 0.01% None 1 WFSWEEP 11,966.05 2.32 11,966.05 2.32 0.00 None 0 11,966.05 11,966.05 0.01% 1 Sub Total 345:Sidewalk Fund 11,966.05 2.32 11,966.05 2.32 0.00 0 350:Grant Fund Wells Fargo Sweep Cash 5/31/2006 182,872.52 100.00 182,872.52 0.08% None 1 WFSWEEP 182,872.52 2.32 182,872.52 2.32 . 0.00 None 0 182,872.52 182,872.52 0.08% 1 Sub Total 350:Grant Fund 182,872.52 2.32 182,872.52 2.32 0.00 0 351:CDBG Fund Wells Fargo Sweep Cash 11/15/2015 29,766.43 100.00 29,766.43 0.01% None 1 WFSWEEP 29,766.43 2.32 29,766.43 2.32 0.00 None 0 29,766.43 29,766.43 0.01% 1 Sub Total 351:CDBG Fund 29,766.43 2.32 29,766.43 2.32 0.00 0 360:Traffic Impact Improvement Prepared by Shamaira Jagrup 6 of 15 ;O`sl. rrj4,yz City of Pearland �a a Portfolio Holdings by Portfolio Name `sr .e,% Report Group: Pearland Date:3/31/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 Summit Community Bank Moorefield WV 6/30/2017 248,000.00 99.80 247,505.33 0.11% None 89 1.55 6/28/2019 86604XLX2 248,000.00 1.55 248,000.00 2.38 31.59 -494.67 None 0.24 Wells Fargo Sweep Cash 5/31/2006 357,775.53 100.00 357,775.53 0.16% None 1 WFSWEEP 357,775.53 2.32 357,775.53 2.32 0.00 None 0 605,775.53 605,280.86 0.27% 37 Sub Total 360:Traffic Impact Improvement 605,775.53 2.00 605,775.53 2.34 31.59 -494.67 0.1 365:Court Juvenile Mgmt Wells Fargo Sweep Cash 9/15/2009 41,225.69 100.00 41,225.69 0.02% None 1 WFSWEEP 41,225.69 2.32 41,225.69 2.32 0.00 None 0 41,225.69 41,225.69 0.02% 1 Sub Total 365:Court Juvenile Mgmt 41,225.69 2.32 41,225.69 2.32 0.00 0 370:Municipal Channel Texas Class LGIP 5/15/2017 668,515.04 100.00 668,515.04 0.3% None 1 TX-01-0615-0001 668,515.04 2.61 668,515.04 2.61 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 168,568.96 100.00 168,568.96 0.08% None 1 WFSWEEP 168,568.96 2.32 168,568.96 2.32 0.00 None 0 837,084.00 837,084.00 0.38% 1 Sub Total 370:Municipal Channel 837,084.00 2.55 837,084.00 2.55 0.00 0 380:Regional Detention Wells Fargo Sweep Cash 5/31/2006 3,204.87 100.00 3,204.87 0% None 1 WFSWEEP 3,204.87 2.32 3,204.87 2.32 0.00 None 0 3,204.87 3,204.87 0% 1 Sub Total 380:Regional Detention 3,204.87 2.32 3,204.87 2.32 0.00 0 500:Capital Projects Texas Class LGIP 1/15/2017 1,039,619.50 100.00 1,039,619.50 0.46% None 1 TX-01-0615-0001 1,039,619.50 2.61 1,039,619.50 2.61 0.00 None 0 Umpqua Bank Roseburg OR 1.6 6/28/2019 6/30/2017 248,000.00 99.81 247,525.92 0.11% None 89 90421MAX1 248,000.00 1.60 248,000.00 2.38 989.28 -474.08 None 0.24 Prepared by Shamaira Jagrup 7 of 15 I O.4�yy VV City of Pearland 4 •- p einkall Portfolio Holdings by Portfolio Name `it. i eq'' Report Group: Pearland Date:3/31/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 Wets Fargo Sweep Cash 5/31/2006 2,342,615.59 100.00 2,342,615.59 1.05% None 1 WFSWEEP 2,342,615.59 2.32 2,342,615.59 2.32 0.00 None 0 3,630,235.09 3,629,761.01 1.62% 7 Sub Total 500:Capital Projects 3,630,235.09 2.35 3,630,235.09 2.41 989.28 -474.08 0.02 501:Certificates of Obligation 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 97.59 242,030.80 0.11% None 663 33625CAZ2 248,000.00 1.10 248,000.00 2.46 67.27 -5,969.20 None 1.79 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 99.66 996,599.01 0.45% S&P-AA+ 144 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.37 1,625.00 -3,400.99 Moodys-Aaa 0.39 FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 97.28 972,824.58 0.44% Moodys-Aaa 865 3137EAEC9 1,000,000.00 1.37 994,458.83 2.31 1,375.00 -21,634.25 S&P-AA+ 2.34 FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 99.27 992,664.91 0.45% Moodys-Aaa 638 3135G0H55 1,000,000.00 1.25 1,010,564.30 2.31 4,843.75 -17,899.39 S&P-AA+ 1.71 Gulf Coast Bank&Trust 1.3 7/15/2021- 7/15/2016 248,000.00 97.70 242,299.21 0.11% None 15 17 402194EX8 248,000.00 1.30 248,000.00 2.33 141.33 -5,700.79 None 2.26 Marlin Business Bank 1.25 12/27/2019 6/29/2016 248,000.00 99.14 245,862.20 0.11% None 271 57116AMC9 248,000.00 1.25 248,000.00 2.43 16.99 -2,137.80 None 0.74 Texas Class LGIP 9/15/2018 7,638,431.07 100.00 7,638,431.07 3.41% None 1 TX-01-0615-0006 7,638,431.07 2.61 7,638,431.07 2.61 0.00 None 0 Texas Class LGIP 12/20/2016 5,886.70 100.00 5,886.70 0% None 1 TX-01-0615-0001 5,886.70 2.61 5,886.70 2.61 0.00 None 0 TexSTAR LGIP 8/26/2016 2,151,228.19 100.00 2,151,228.19 0.96% S&P-AAA 1 02000-11110 2,151,228.19 2.41 2,151,228.19 2.41 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 401,245.98 100.00 401,245.98 0.18% None 1 WFSWEEP 401,245.98 2.32 401,245.98 2.32 0.00 None 0 Prepared by Shamaira Jagrup 8 of 15 O. : PF 44. City of Pearland 4 L O EiritRilida Portfolio Holdings by Portfolio Name ''F k®'' Report Group: Pearland Date:3/31/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 Peoples United Bank 1.9 11/19/2019 11/19/2014 248,000.00 99.78 247,452.26 0.11% None 233 71270QKM7 248,000.00 1.90 248,000.00 2.25 1,704.07 -547.74 None 0.63 Texas Class LGIP 9/15/2018 8,023,647.15 100.00 8,023,647.15 3.58% None 1 TX-01-0615-0005 8,023,647.15 2.61 8,023,647.15 2.61 0.00 None 0 Texas Class LGIP 12/20/2016 3,399,238.60 100.00 3,399,238.60 1.52% None 1 TX-01-0615-0001 3,399,238.60 2.61 3,399,238.60 2.61 0.00 None 0 TexSTAR LGIP 8/26/2016 1,630,678.32 100.00 1,630,678.32 0.73% S&P-AAA 1 02000-11110 1,630,678.32 2.41 1,630,678.32 2.41 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 894,087.93 100.00 894,087.93 0.4% None 1 WFSWEEP 894,087.93 2.32 894,087.93 2.32 0.00 None 0 17,177,082.00 17,146,359.12 7.67% 76 Sub Total 506:General Obligation 17,179,652.00 2.34 17,179,237.10 2.52 4,039.96 -32,877.98 0.2 550:W/S Impact Fee Bankwest,Inc.1.5 1/3/2020 3/4/2015 248,000.00 99.28 246,215.90 0.11% None 278 06652CFA4 248,000.00 1.50 248,000.00 2.46 285.37 -1,784.10 None 0.75 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 99.40 246,519.80 0.11% None 446 05580ABX1 248,000.00 2.10 248,000.00 2.60 1,455.39 -1,480.20 None 1.2 Cedar Rapids Bank&Trust 1.5 1/30/2015 248,000.00 99.84 247,597.69 0.11% None 213 10/30/2019 150517CJ7 248,000.00 1.50 248,000.00 1.78 305.75 -402.31 None 0.58 EVB Tappa Hannock VA 1.6 9/25/2019 9/25/2015 248,000.00 99.82 247,545.24 0.11% None 178 26927ABK7 248,000.00 1.60 248,000.00 1.98 65.23 -454.76 None 0.48 FAMC 1.8211/9/2020 11/9/2017 1,000,000.00 99.12 991,235.27 0.45% Moodys-Aaa 589 3132X0ZC8 1,000,000.00 1.82 1,000,000.00 2.38 7,178.89 -8,764.73 S&P-AA+ 1.58 FFCB 1.84 10/30/2020-18 10/30/2017 1,000,000.00 99.23 992,279.53 0.45% Moodys-Aaa 579 3133EHM26 1,000,000.00 1.84 1,000,000.00 2.34 7,666.67 -7,720.47 S&P-AA+ 1.56 Prepared by Shamaira Jagrup 10 of 15 lF °< City of Pearland 4 O Portfolio Holdings by Portfolio Name ,-3,. ,,", Report Group: Pearland Date:3/31/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.2 1/29/2021-19 1/29/2018 1,000,000.00 99.39 993,909.83 0.45% Moodys-Aaa 29 3130ADC26 1,000,000.00 2.20 1,000,000.00 2.54 3,788.89 -6,090.17 S&P-AA+ 1.8 FHLMC 2 11/20/2020-18 12/5/2017 1,000,000.00 99.36 993,555.05 0.45% Moodys-Aaa 50 3134GBW32 1,000,000.00 2.00 1,000,000.00 2.40 7,277.78 -6,444.95 S&P-AA+ 1.61 FHLMC 2.2 12/8/2021-18 12/8/2017 1,000,000.00 99.39 993,896.90 0.45% Moodys-Aaa 69 3134GB4N9 1,000,000.00 2.20 1,000,000.00 2.44 6,905.56 -6,103.10 S&P-AA+ 2.61 First Financial NW 1.35 10/30/2019 10/30/2015 248,000.00 99.38 246,454.11 0.11% None 213 32022MAF5 248,000.00 1.35 248,000.00 2.43 0.00 -1,545.89 None 0.58 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 98.63 244,591.57 0.11% None 457 69413CFD6 248,000.00 1.25 248,000.00 2.37 8.49 -3,408.43 None 1.24 Texas Class LGIP 9/15/2018 5,171,888.48 100.00 5,171,888.48 2.31% None 1 TX-01-0615-0004 5,171,888.48 2.61 5,171,888.48 2.61 0.00 None 0 Texas Class LGIP 12/20/2016 21,722,133.87 100.00 21,722,133.87 9.7% None 1 TX-01-0615-0001 21,722,133.87 2.61 21,722,133.87 2.61 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -375,080.46 100.00 -375,080.46 -0.17% None 1 WFSWEEP -375,080.46 2.32 -375,080.46 2.32 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 82,449.35 100.00 82,449.35 0.04% None 1 WF4094 82,449.35 2.32 82,449.35 2.32 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 3,946,894.69 100.00 3,946,894.69 1.76% None 1 WF4102 3,946,894.69 2.32 3,946,894.69 2.32 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 12,036,597.99 100.00 12,036,597.99 5.38% None 1 WF5883 12,036,597.99 2.32 12,036,597.99 2.32 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 8,598,571.93 100.00 8,598,571.93 3.84% None 1 WF6624 8,598,571.93 2.32 8,598,571.93 2.32 0.00 None 0 57,671,455.85 57,627,256.74 25.77% 31 Sub Total 550:W/S Impact Fee 57,671,455.85 2.41 57,671,455.85 2.46 34,938.02 -44,199.11 0.18 Prepared by Shamaira Jagrup 11 of 15 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/31/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 555:Shadow Creek Impact FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 99.33 993,329.91 0.45% Moodys-Aaa 330 3132X0PW5 1,000,000.00 1.63 1,000,358.89 2.43 1,721.53 -7,028.98 S&P-AA+ 0.89 Wells Fargo Sweep Cash 5/31/2006 5,335.36 100.00 5,335.36 0% None 1 WFSWEEP 5,335.36 2.32 5,335.36 2.32 0.00 None 0 1,006,535.36 998,665.27 0.45% 328 Sub Total 555:Shadow Creek Impact 1,005,335.36 1.64 1,005,694.25 2.43 1,721.53 -7,028.98 0.89 565:Revenue Bonds 1999&2003 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 99.66 996,599.01 0.45% S&P-AA+ 144 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.37 1,625.00 -3,400.99 Moodys-Aaa 0.39 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 97.97 242,968.33 0.11% None 822 36198JCC6 248,000.00 1.50 248,000.00 2.43 10.19 -5,031.67 None 2.21 Texas Class LGIP 9/15/2018 16,009,931.85 100.00 16,009,931.85 7.15% None 1 TX-01-0615-0004 16,009,931.85 2.61 16,009,931.85 2.61 0.00 None 0 Texas Class LGIP 1/15/2017 233,098.74 100.00 233,098.74 0.1% None 1 TX-01-0615-0001 233,098.74 2.61 233,098.74 2.61 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -210,680.10 100.00 -210,680.10 -0.09% None 1 WFSWEEP -210,680.10 2.32 -210,680.10 2.32 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 10,234,862.10 100.00 10,234,862.10 4.57% None 1 WF5875 10,234,862.10 2.32 10,234,862.10 2.32 0.00 None 0 27,515,212.59 27,506,779.93 12.29% 14 Sub Total 565:Revenue Bonds 1999& 27,515,212.59 2.45 27,515,212.59 2.49 1,635.19 -8,432.66 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 98.52 244,334.51 0.11% None 821 56817TAB7 248,000.00 1.80 248,000.00 2.48 24.46 -3,665.49 None 2.2 Wells Fargo Sweep Cash 12/31/2007 4,254,614.43 100.00 4,254,614.43 1.9% None 1 WFSWEEP 4,254,614.43 2.32 4,254,614.43 2.32 0.00 None 0 Prepared by Shamaira Jagrup 12 of 15 �°.� °F 4 O y,, City of Pearland K iRl � Portfolio Holdings by Portfolio Name `f' "' Report Group: Pearland Date:3/31/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 4,502,614.43 4,498,948.94 2.01% 46 Sub Total 570:WIS Pay As You Go 4,502,614.43 2.29 4,502,614.43 2.33 24.46 -3,665.49 0.12 575:MUD 4 Capital Programs Wells Fargo Sweep Cash 2/1/2013 25,276.65 100.00 25,276.65 0.01% None 1 WFSWEEP 25,276.65 2.32 25,276.65 2.32 0.00 None 0 25,276.65 25,276.65 0.01% 1 Sub Total 575:MUD 4 Capital Programs 25,276.65 2.32 25,276.65 2.32 0.00 0 600:Water&Sewer BARCLAYS BANK DELAWARE 1.95 5/6/2014 248,000.00 99.97 247,923.65 0.11% None 37 5/7/2019 06740KGU5 248,000.00 1.95 248,000.00 2.24 1,907.90 -76.35 None 0.1 CDARS 1.05 6/15/2019 6/15/2017 508,192.94 100.00 508,192.94 0.23% None 76 CDARS061517 508,192.94 1.05 508,192.94 1.05 1,315.73 0.00 None 0.21 FAMC 1.5 8/22/2019 2/22/2017 2,001,700.00 99.66 1,993,198.02 0.89% S&P-AA+ 144 3132X0PV7 2,000,000.00 1.47 2,000,266.33 2.37 3,250.00 -7,068.31 Moodys-Aaa 0.39 Northern Bank&Trust MA 1.1 7/12/2016 248,000.00 99.66 247,167.22 0.11% None 12 7/12/2019-17 66476QBH0 248,000.00 1.10 248,000.00 2.28 582.97 -832.78 None 0.28 Parkside Finl Bank&Trust 1.3 7/18/2016 248,000.00 97.68 242,254.24 0.11% None 18 7/19/2021-17 70147ABX1 248,000.00 1.30 248,000.00 2.34 114.83 -5,745.76 None 2.27 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 97.99 243,018.72 0.11% None Mv� 816 73565NBQ5 248,000.00 1.40 248,000.00 2.33 66.59 -4,981.28 None 2.2 Texas Class LGIP 12/20/2016 10,657,819.66 100.00 10,657,819.66 4.76% None 1 TX-01-0615-0001 10,657,819.66 2.61 10,657,819.66 2.61 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 19,176,613.59 100.00 19,176,613.59 8.56% None 1 WFSWEEP 19,176,613.59 2.32 19,176,613.59 2.32 0.00 None 0 33,336,326.19 33,316,188.04 14.88% 17 Sub Total 600:Water&Sewer 33,334,626.19 2.31 33,334,892.52 2.39 7,238.02 -18,704.48 0.06 Prepared by Shamaira Jagrup 13 of 15 0. rt ye City of Pearland Portfolio Holdings by Portfolio Name ti-, j. . Report Group: Pearland Date:3/31/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 610:Solidwaste Wells Fargo Sweep Cash 12/1/2006 -1,232,766.26 100.00 -1,232,766.26 -0.55% None 1 WFSWEEP -1,232,766.26 2.32 -1,232,766.26 2.32 0.00 None 0 -1,232,766.26 -1,232,766.26 -0.55% 1 Sub Total 610:Solidwaste -1,232,766.26 2.32 -1,232,766.26 2.32 0.00 0 700:Property Liability Ins Wells Fargo Sweep Cash 10/31/2006 506,993.96 100.00 506,993.96 0.23% None 1 WFSWEEP 506,993.96 2.32 506,993.96 2.32 0.00 None 0 506,993.96 506,993.96 0.23% 1 Sub Total 700:Property Liability Ins 506,993.96 2.32 506,993.96 2.32 0.00 0 701:Employee Benefit Fund Wells Fargo Sweep Cash 9/1/2007 58,403.65 100.00 58,403.65 0.03% None 1 WFSWEEP 58,403.65 2.32 58,403.65 2.32 0.00 None 0 58,403.65 58,403.65 0.03% 1 Sub Total 701:Employee Benefit Fund 58,403.65 2.32 58,403.65 2.32 0.00 0 702:Health Claims Fund Wells Fargo Cash 7/21/2010 414,146.99 100.00 414,146.99 0.18% None 1 WF9871 414,146.99 0.75 414,146.99 0.75 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,958,554.43 100.00 2,958,554.43 1.32% None 1 WFSWEEP 2,958,554.43 2.32 2,958,554.43 2.32 0.00 None 0 3,372,701.42 3,372,701.42 1.5% 1 Sub Total 702:Health Claims Fund 3,372,701.42 2.12 3,372,701.42 2.12 0.00 0 703:Motor Pool Fund Wells Fargo Sweep Cash 10/15/2018 1,622,211.40 100.00 1,622,211.40 0.72% None 1 WFSWEEP 1,622,211.40 2.32 1,622,211.40 2.32 0.00 None 0 1,622,211.40 1,622,211.40 0.72% 1 Sub Total 703:Motor Pool Fund 1,622,211.40 2.32 1,622,211.40 2.32 0.00 0 Prepared by Shamaira Jagrup 14 of 15 City of Pearland 10,,,,.„ 4 �'`� Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/31/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 223,943,849.14 223,686,102.52 100.00% 48 TOTAL PORTFOLIO 223,936,656.14 2.36 223,936,224.47 2.46 85,588.28 -250,121.95 0.17 Prepared by Shamaira Jagrup 15 of 15 City of Pearland slam Treasury Yield Curve Treasury 12/31/2018 3/31/2019 1 Month 2.37 2.45 3 Month 2.41 2.45 6 Month 2.54 2.51 1 Year 2.66 2.49 2 Year 2.68 2.41 3 Year 2.67 2.37 5 Year 2.68 2.37 10 Year 2.83 2.57 3.00 2,00 1,50 0 1.J31/2018 3/31/2019 1,00 - 0.50 0.00 1 Month 3 Month n Month 1 Year 2 Year 3 Year 5 Year 10 Year Prepared by Shamaira Jagrup 1 of 1 Pledged Collateral Reconciliation Report March 31, 2019 Bank Account Number Account Name Amount Wells Fargo 8071613395 Credit Card Account - Wells Fargo 13042841 Sweep Account 37,036.00 * Wells Fargo 7169195455 False Alarm Reduction Program 285,619.78 Wells Fargo 8184567843 Alvin ISD 10,251,892.15 Wells Fargo 1790121790 EMS Payments - Wells Fargo 2807409871 Health Claims 414,146.99 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 $ 10,988,694.92 Pledged Collateral for City 13,180,741.08 FDIC Insurance 500,000.00 $ 13,680,741.08 Over(Under)Collateralized $ 2,692,046.16 Total%Collateralized 124.5% Bank Account Number Account Name Amount Wells Fargo 1007284258 Development Authority 952,551.72 Total of Bank Balances $ 952,551.72 Pledged Collateral for DAP 763,879.34 FDIC Insurance 250,000.00 $ 1,013,879.34 Over(Under)Collateralized $ 61,327.62 Total%Collateralized 106.4% Total%Collateralized 123.1% Status Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral.