Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2019-033 2019-02-11
RESOLUTION NO. R2019-33 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending December 2018. 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 December 2018. PASSED, APPROVED, AND ADOPTED this 11th day of February, A.D., 2019. L)-(77-) TOM REID MAYOR ATTEST: Q O • 4e cos TY SE ETARY APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY o ,,, City of Pearland 4. ', Quarterly Investment Report lielhatalli September 30, 2018 to December 31, 2018 'Sr. ,q4s 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 10/31/2018 202,382,739.68 202,989,910.32 -607,170.64 2.06 2.65 377,409.86 99 11/30/2018 201,439,786.01 202,009,757.42 -569,971.41 2.12 2.70 349,766.33 94 12/31/2018 230,265,382.29 230,725,451.01 -460,068.72 2.27 2.66 402,422.24 77 Total/Average 211,362,635.99 211,908,372.92 -545,736.92 2.16 2.67 1,129,598.43 89 ,.� CC..t.--- ",) UCO '/2.411 q I Cynthia Pearson, Dir ctor of Finance Date Rhonda Daugherty, A sistant irector of Finance Date Ii" Itlerc17 t I tall Shamaira Jagrup, Treasury Analyst Date °''1‘, City of Pearland litalititLsa Distribution by Security Type - Book Value ,0' Report Group: Pearland Begin Date:9/30/2018,End Date:12/31/2018 Security Type Allocation Book Value %of Portfolio Book Value %of Portfolio Security Type 9/30/2018 9/30/2018 12/31/2018 12/31/2018 Cash 66,954,257.79 32.99 106,951,361.78 46.35 Certificate Of Deposit 18,351,242.88 9.04 16,858,000.00 7.31 Compound CD 502,884.94 0.25 508,192.94 0.22 FAMC Bond 8,001,724.55 3.94 7,001,354.11 3.03 FFCB Bond 2,000,000.00 0.99 2,000,000.00 0.87 FHLB Bond 4,999,183.56 2.46 3,999,371.73 1.73 FHLMC Bond 6,685,932.24 3.29 5,687,204.90 2.46 FNMA Bond 3,015,522.91 1.49 2,012,853.23 0.87 Local Government Investment Pool 92,455,168.02 45.55 85,707,112.32 37.15 Total/Average 202,965,916.89 100.00 230,725,451.01 100.00 Portfolio Holdings as of 9/30/2018 Portfolio Holdings as of 12/31/2018 't • 32.99%-Cash • 46.35%-Cash '44` °/` ' X44 , 1 : 9.04%-Certificate Of.. 7.31%-Certificate Of... 4.,Y.. I • 0.25%-Compound CD ` 0.22%-Compound CD , I • 3.94%-FAMC Bond • 3.03%-FAMC Bond ', 10 0.99%-FFCB Bond !r! 0.87%-FFCB Bond ', 2.46%-FHLB Bond 1.73%-FHLB Bond 1 •3.29%-FHLMC Bond ( 1111F 1 • 2.46%-FHLMC Bond (a 1.49%-FNMA Bond I • 0.87%-FNMA Bond 45.55%-Local Governm... 1 * 37.15%-Local Governm... Prepared by Shamaira Jagrup 1 of 1 ;� City of Pearland ijaRldikL\N Distribution by Maturity Range - Book Value `„ ,„, Report Group: Pearland Begin Date:9/30/2018, End Date: 12/31/2018 Maturity Range Allocation Book Value %of Portfolio Book Value %of Portfolio Maturity Range 9/30/2018 9/30/2018 12/31/2018 12/31/2018 0-1 Month 160,657,422.14 79.15 193,906,474.10 84.04 1-3 Months 4,245,401.43 2.09 4,488,772.53 1.95 3-6 Months 5,737,748.91 2.83 2,996,192.94 1.30 6-9 Months 1,246,884.94 0.61 6,484,808.06 2.81 9-12 Months 8,476,764.20 4.18 2,728,000.00 1.18 1-2 Years 9,201,120.00 4.53 11,228,998.48 4.87 2-3 Years 12,400,575.27 6.11 8,892,204.90 3.85 3-4 Years 1,000,000.00 0.49 0.00 0.00 Total/Average 202,965,916.89 100.00 230,725,451.01 100.00 Portfolio Holdings 200,000 - 180,000 - 160,000 - ,,, 140,000 - g 120,000 - 0 100,000 - •9/30/2018 H 80,000 - t ' 12/31/2018 1 c ”' 60,000 - 40,000 - 20,000 - �_ m Ella 00 , 0-1 Month 1-3 Months 3-6 Months 6-9 Months 9-12 Months 1-2 Years 2-3 Years 3-4 Years Prepared by Shamaira Jagrup 1 of 1 s City of Pearland iihiRldalki Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date: 1/31/2018,End Date:12/31/2018 Beginning BV+ Interest Earned Realized Investment Average Capital Annualized Treasury 1 Month Accrued Interest During Period-BV Gain/Loss-BV Income-By Base-BV TRR-BV TRR-BV Year 1/31/2018 224,894,930.21 302,556.92 0.00 302,556.92 232,787,416.50 0.13 1.57 1.80 2/28/2018 240,816,213.87 254,890.07 0.00 254,890.07 225,205,995.97 0.11 1.37 1.96 3/31/2018 210,050,683.35 337,525.82 0.00 337,525.82 211,626,642.26 0.16 1.93 2.06 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 Annualized TRR-BV 3.00 2.50 - 2.00 - � Portfolio iiIiiiII1 01/2018 02/2018 03/2018 04/2018 05/2018 06/2018 07/2018 08/2018 09/2018 10/2018 11/2018 12/2018 Prepared by Shamaira Jagrup 1 of 1 "'� City of Pearland + Portfolio Holdings by Security Type 1 3r, ,"°' Report Group: Pearland Date: 12/31/2018 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 529,911.06 100.00 529,911.06 0.23% None 1 WF9871 529,911.06 0.75 529,911.06 0.75 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 22,685,462.40 100.00 22,685,462.40 9.83% None 1 WFSWEEP 22,685,462.40 2.35 22,685,462.40 2.35 0.00 None 0 Wells Fargo Sweep Cash 2/1/2013 25,098.07 100.00 25,098.07 0.01% None 1 WFSWEEP 25,098.07 2.35 25,098.07 2.35 0.00 None 0 Wells Fargo Sweep Cash 12/15/2018 -682.10 100.00 -682.10 0% None 1 WFSWEEP -682.10 2.35 -682.10 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 16,427,862.32 100.00 16,427,862.32 7.12% None 1 WFSWEEP 16,427,862.32 2.35 16,427,862.32 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 25,268.87 100.00 25,268.87 0.01% None 1 WFSWEEP 25,268.87 2.35 25,268.87 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 3,182.23 100.00 3,182.23 0% None 1 WFSWEEP 3,182.23 2.35 3,182.23 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,362,979.51 100.00 2,362,979.51 1.02% None 1 WFSWEEP 2,362,979.51 2.35 2,362,979.51 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 138,928.24 100.00 138,928.24 0.06% None 1 WFSWEEP 138,928.24 . 2.35 138,928.24 2.35 0.00 None 0 Wells Fargo Sweep Cash 10/15/2018 1,626,672.04 100.00 1,626,672.04 0.71% None 1 WFSWEEP 1,626,672.04 2.35 1,626,672.04 2.35 0.00 None 0 Wells Fargo Sweep Cash 11/15/2015 36,121.82 100.00 36,121.82 0.02% None 1 WFSWEEP 36,121.82 2.35 36,121.82 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,604,594.58 100.00 1,604,594.58 0.7% None 1 WFSWEEP 1,604,594.58 2.35 1,604,594.58 2.35 0.00 None • 0 Prepared by Shamaira Jagrup 1 of 13 4 TF, °- City of Pearland I19 Portfolio Holdings by Security Type `t, ,"°' Report Group: Pearland Date: 12/31/2018 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 6/30/2006 63,576.63 100.00 63,576.63 0.03% None 1 WFSWEEP 63,576.63 2.35 63,576.63 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 470,659.14 100.00 470,659.14 0.2% None 1 WFSWEEP 470,659.14 2.35 470,659.14 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -1,743.57 100.00 -1,743.57 0% None 1 WFSWEEP -1,743.57 2.35 -1,743.57 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 115,503.80 100.00 115,503.80 0.05% None 1 WFSWEEP 115,503.80 2.35 115,503.80 2.35 0.00 None 0 ........ . ........- Wells Fargo Sweep Cash 5/31/2006 354,585.99 100.00 354,585.99 0.15% None 1 WFSWEEP 354,585.99 2.35 354,585.99 2.35 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 226,872.33 100.00 226,872.33 0.1% None 1 WFSWEEP 226,872.33 2.35 226,872.33 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 171,202.85 100.00 171,202.85 0.07% None 1 WFSWEEP 171,202.85 2.35 171,202.85 2.35 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,635,626.31 100.00 2,635,626.31 1.14% None 1 WFSWEEP 2,635,626.31 2.35 2,635,626.31 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 35,695.23 100.00 35,695.23 0.02% None 1 WFSWEEP 35,695.23 2.35 35,695.23 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 462,161.57 100.00 462,161.57 0.2% None 1 WFSWEEP 462,161.57 2.35 462,161.57 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 104,481.68 100.00 104,481.68 0.05% None 1 WFSWEEP 104,481.68 2.35 104,481.68 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 949,331.84 100.00 949,331.84 0.41% None 1 WFSWEEP 949,331.84 2.35 949,331.84 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -1,206,372.93 100.00 -1,206,372.93 -0.52% None 1 WFSWEEP -1,206,372.93 2.35 -1,206,372.93 2.35 0.00 None 0 Prepared by Shamaira Jagrup 2 of 13 PF. ''? City of Pearland -t EatRigal Portfolio Holdings by Security Type `'` ,"°' Report Group: Pearland Date: 12/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares Y7M @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 12/31/2007 3,628,527.30 100.00 3,628,527.30 1.57% None 1 WFSWEEP 3,628,527.30 2.35 3,628,527.30 2.35 0.00 None 0 Wells Fargo Sweep Cash 10/31/2006 207,661.39 100.00 207,661.39 0.09% None 1 WFSWEEP 207,661.39 2.35 207,661.39 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 5,446.12 100.00 5,446.12 0% None 1 WFSWEEP 5,446.12 2.35 5,446.12 2.35 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 453,349.31 100.00 453,349.31 0.2% None 1 WFSWEEP 453,349.31 2.35 453,349.31 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 239,436.18 100.00 239,436.18 0.1% None 1 WFSWEEP 239,436.18 2.35 239,436.18 2.35 0.00 None 0 � Wells Fargo Sweep Cash 5/31/2006 19,100,404.67 100.00 19,100,404.67 8.28% None 1 WFSWEEP 19,100,404.67 2.35 19,100,404.67 2.35 0.00 None 0 Wells Fargo Sweep Cash 9/15/2009 31,719.95 100.00 31,719.95 0.01% None 1 WFSWEEP 31,719.95 2.35 31,719.95 2.35 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -80,853.16 100.00 -80,853.16 -0.04% None 1 WFSWEEP -80,853.16 2.35 -80,853.16 2.35 0.00 None 0 Wells Fargo Sweep Cash 12/1/2006 -1,279,607.52 100.00 -1,279,607.52 -0.55% None 1 WFSWEEP -1,279,607.52 2.35 -1,279,607.52 2.35 0.00 None 0 Wells Fargo Sweep Cash 9/1/2007 93,878.69 100.00 93,878.69 0.04% None 1 WFSWEEP 93,878.69 2.35 93,878.69 2.35 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 10,177,687.46 100.00 10,177,687.46 4.41% None 1 WF5875 10,177,687.46 2.35 10,177,687.46 2.35 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 81,988.76 100.00 81,988.76 0.04% None 1 WF4094 81,988.76 2.35 81,988.76 2.35 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 8,550,538.04 100.00 8,550,538.04 3.71% None 1 WF6624 8,550,538.04 2.35 8,550,538.04 2.35 0.00 None 0 Prepared by Shamaira Jagrup 3 of 13 °`'° City of Pearland lititikftil Portfolio Holdings by Security Type `'` 0% Report Group: Pearland Date: 12/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo TWDB Cash 11/1/2016 3,924,846.30 100.00 3,924,846.30 1.7% None 1 WF4102 3,924,846.30 2.35 3,924,846.30 2.35 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 11,969,358.38 100.00 11,969,358.38 5.19% None 1 WF5883 11,969,358.38 2.35 11,969,358.38 2.35 0.00 None 0 106,951,361.78 106,951,361.78 46.36% 1 Sub Total Cash 106,951,361.78 2.34 106,951,361.78 2.34 0.00 0 Certificate Of Deposit 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 96.07 238,259.06 0.11% None 753 33625CAZ2 248,000.00 1.10 248,000.00 3.07 67.27 -9,740.94 None 2.04 1st Source Bank 1.5 11/18/2019 4/17/2015 248,000.00 99.32 246,322.53 0.11% None 322 33646CEQ3 248,000.00 1.50 248,000.00 2.28 764.38 -1,677.47 None 0.88 Ally Bank Midvale Utah 1.8 6/29/2020 6/29/2017 248,000.00 98.41 244,055.06 0.11% None 546 02006L3U5 248,000.00 1.80 248,000.00 2.90 24.46 -3,944.94 None 1.48 Alma Bank 1.35 12/24/2020 6/24/2016 248,000.00 96.73 239,879.24 0.11% None 724 020080662 248,000.00 1.35 248,000.00 3.06 64.21 -8,120.76 None 1.95 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 96.01 238,092.90 0.11% None 924 02554BCM1 248,000.00 1.35 248,000.00 2.99 183.45 -9,907.10 None 2.49 Bank Leumi USA 1.3 2/26/2020 3/3/2016 248,000.00 98.95 245,408.15 0.11% None 422 063248FH6 248,000.00 1.30 248,000.00 2.22 1,121.78 -2,591.85 None 1.15 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 96.31 238,838.14 0.11% None 912 063847AL1 248,000.00 1.40 248,000.00 2.94 9.51 -9,161.86 None 2.45 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 98.78 244,963.74 0.11% None 634 06610QCV1 248,000.00 1.80 248,000.00 2.52 73.38 -3,036.26 None 1.71 Bankwest,Inc.1.5 1/3/2020 3/4/2015 248,000.00 98.78 244,964.23 0.11% None 368 06652CFA4 248,000.00 1.50 248,000.00 2.73 285.37 -3,035.77 None 1 Prepared by Shamaira Jagrup 4 of 13 °. City of Pearland Portfolio Holdings by Security Type `'' ,"°' Report Group: Pearland Date: 12/31/2018 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 Bar Harbor Bank&Trust 2.65 3/29/2021 3/29/2018 248,000.00 99.03 245,601.59 0.11% None 29 -18 066851WB8 248,000.00 2.65 248,000.00 3.10 36.01 -2,398.41 None 2.18 BARCLAYS BANK DELAWARE 1.95 5/6/2014 248,000.00 99.82 247,554.59 0.11% None 127 5/7/2019 06740KGU5 248,000.00 1.95 248,000.00 2.46 715.46 -445.41 None 035 Belmont Savings Bank 1.85 10/23/2019 12/23/2014 248,000.00 99.50 246,750.58 0.11% None 296 0805158D0 248,000.00 1.85 248,000.00 2.48 100.56 -1,249.42 None 0.81 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 98.71 244,800.30 0.11% None 536 05580ABX1 248,000.00 2.10 248,000.00 3.01 171.22 -3,199.70 None 1.45 Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 95.83 237,670.30 0.11% None 912 099703EF3 248,000.00 1.40 248,000.00 3.14 9.51 -10,329.70 None 2.45 Brickell Bank Miami FL 1.65 10/28/2019 6/27/2017 248,000.00 99.18 245,971.86 0.11% None 301 10801DAG6 248,000.00 1.65 248,000.00 2.65 33.63 -2,028.14 None 0.82 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 96.83 240,128.73 0.11% None 905 12325EHU9 248,000.00 1.80 248,000.00 3.13 97.84 -7,871.27 None 2.42 Capital Bank Little Rock 1.35 3/22/2019 9/23/2015 248,000.00 99.88 247,713.06 0.11% None 81 139797FL3 248,000.00 1.35 248,000.00 1.87 82.55 -286.94 None 0.23 Capital One Bank USA 1.1 11/19/2019 11/19/2014 248,000.00 99.49 246,732.47 0.11% None 323 140420QX1 248,000.00 1.10 248,000.00 1.68 313.91 -1,267.53 None 0.88 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 98.81 245,053.02 0.11% None 634 14042RAB7 248,000.00 2.30 248,000.00 3.01 1,515.86 -2,946.98 None 1.7 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 97.54 241,900.44 0.11% None 574 144153AW3 248,000.00 1.10 248,000.00 2.70 29.90 -6,099.56 None 1.56 Cedar Rapids Bank&Trust 1.5 1/30/2015 248,000.00 99.58 246,950.96 0.11% None 303 10/30/2019 150517CJ7 248,000.00 1.50 248,000.00 2.01 305.75 -1,049.04 None 0.82 Prepared by Shamaira Jagrup 5 of 13 City of Pearland ,tom€A4AND Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2018 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 Charter Bank 1.7 2/25/2020 2/25/2015 248,000.00 98.78 244,972.66 0.11% None 421 161164BE7 248,000.00 1.70 248,000.00 2.78 69.30 -3,027.34 None 1.14 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248,000.00 99.50 246,754.05 0.11% None 323 17284C3Z5 248,000.00 2.10 248,000.00 2.68 599.28 -1,245.95 None 0.88 Citizens State Bank Clayton 1.354/30/2019 9/30/2015 248,000.00 99.81 247,519.38 0.11% None 120 176688BS7 248,000.00 1.35 248,000.00 1.94 9.17 -480.62 None 0.33 Commercial Bank Ala Mich 1.5 3/29/2019 6/30/2015 248,000.00 99.77 247,430.59 0.11% None 88 201282GV6 248,000.00 1.50 248,000.00 2.44 20.38 -569.41 None 0.24 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 96.31 238,849.79 0.11% None 912 2035076G2 248,000.00 1.50 248,000.00 3.04 10.19 -9,150.21 None 2.45 Community Bankers'Bank 1.4 6/30/2016 248,000.00 96.31 238,838.14 0.11% None 912 6/30/2021 20361LBR4 248,000.00 1.40 248,000.00 2.94 9.51 -9,161.86 None 2.45 Discover Bank 2 2/25/2020 2/25/2015 248,000.00 99.12 245,818.84 0.11% None 421 254672JA7 248,000.00 2.00 248,000.00 2.78 1,739.40 -2,181.16 None 1.14 EVB Tappa Hannock VA 1.6 9/25/2019 9/25/2015 248,000.00 99.58 246,953.44 0.11% None .268 26927ABK7 248,000.00 1.60 248,000.00 2.18 1,054.51 -1,046.56 None 0.73 Exchange Bank NEB 1.05 1/21/2020 7/20/2016 248,000.00 98.23 243,619.58 0.11% None 386 ' 301074CH1 248,000.00 1.05 248,000.00 2.75 78.48 -4,380.42 None 1.05 Fahey Banking 1.1 6/28/2019 3/29/2016 248,000.00 99.51 246,793.98 0.11% None 179 303117CC7 248,000.00 1.10 248,000.00 2.10 22.42 -1,206.02 None 0.49 FIRST BANK HIGHLAND PARK 1.85 5/7/2014 248,000.00 99.77 247,429.60 0.11% None 38 5/7/2019-14 319141BL0 248,000.00 1.85 248,000.00 2.50 678.77 -570.40 None 0.35 First Bank McComb MS 1.5 2/28/2019 6/30/2015 248,000.00 99.89 247,730.92 0.11% None 59 319234AJ9 248,000.00 1.50 248,000.00 2.19 30.58 -269.08 None 0.16 Prepared by Shamaira Jagrup 6 of 13 ;.;,, ;-,4 City of Pearland Lim Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2018 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 Business Bank 1.7 6/30/2020 9/30/2015 248,000.00 98.26 243,682.57 0.11% None 547 31938QP40 248,000.00 1.70 248,000.00 2.90 1,062.66 -4,317.43 None 1.48 First Capital Bank 1.4 8/6/2019 4/6/2015 248,000.00 99.54 246,863.42 0.11% None 218 31944FBK5 248,000.00 1.40 248,000.00 2.17 237.81 -1,136.58 None 0.6 First Financial NW 1.35 10/30/2019 10/30/2015 248,000.00 98.92 245,332.26 0.11% None 303 32022MAF5 248,000.00 1.35 248,000.00 2.66 0.00 -2,667.74 None 0.83 First Intl Bank&Trust 1.6 1/16/2020 10/16/2015 248,000.00 98.83 245,090.46 0.11% None 381 32057GAE9 248,000.00 1.60 248,000.00 2.74 163.07 -2,909.54 None 1.03 First National Bank of America 1.25 7/15/2016 248,000.00 95.42 236,630.94 0.11% None 927 7/15/2021 32110YHMO 248,000.00 1.25 248,000.00 3.14 1,435.34 -11,369.06 None 2.49 GNB Bank 1.56/30/2021 6/30/2016 248,000.00 96.31 238,849.79 0.11% None 912 36198JCC6 248,000.00 1.50 248,000.00 3.04 10.19 -9,150.21 None 2.45 Goldman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 99.12 245,818.84 0.11% None 421 38148JLL3 248,000.00 2.00 248,000.00 2.78 1,739.40 -2,181.16 None 1.14 Gulf Coast Bank&Trust 1.3 7/15/2021- 7/15/2016 248,000.00 96.01 238,108.27 0.11% None 15 17 402194EX8 248,000.00 1.30 248,000.00 2.93 141.33 -9,891.73 None 2.5 JP Morgan Chase Bk NA Columbus 2.1 2/15/2017 245,000.00 97.99 240,074.76 0.11% None 15 2/15/2021-17 48126XVW2 245,000.00 2.10 245,000.00 3.08 225.53 -4,925.24 None 2.08 Lincoln 1st Bank 1.46/30/2021 6/30/2016 248,000.00 96.31 238,838.14 0.11% None 912 53362LAB0 248,000.00 1.40 248,000.00 2.93 285.37 -9,161.86 None 2.45 Machias Savings Bank 1.65 2/6/2020 2/6/2015 248,000.00 99.38 246,465.62 0.11% None 402 554479DS1 248,000.00 1.65 248,000.00 2.22 280.27 -1,534.38 None 1.09 Mahopac Bank 1.45 7/30/2019 1/30/2015 248,000.00 99.71 247,275.84 0.11% None 211 560160AQ6 248,000.00 1.45 248,000.00 1.96 1,517.22 -724.16 None 0.58 Prepared by Shamaira Jagrup 7 of 13 City of Pearland iiiiiIkke Portfolio Holdings by Security Type `tr "' Report Group: Pearland Date: 12/31/2018 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 Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 96.92 240,360.86 0.11% None 911 56817TAB7 248,000.00 1.80 248,000.00 3.09 24.46 -7,639.14 None 2.44 Marlin Business Bank 1.25 12/27/2019 6/29/2016 248,000.00 98.59 244,506.18 0.11% None 361 57116AMC9 • 248,000.00 1.25 248,000.00 2.70 16.99 -3,493.82 None 0.98 MB Financial Bank 1.1 3/18/2019 3/18/2016 248,000.00 99.81 247,518.14 0.11% None 77 55266CQU3 248,000.00 1.10 248,000.00 2.01 97.16 -481.86 None 0.21 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 99.35 246,383.54 0.11% None 826 61747MS69 248,000.00 2.80 248,000.00 3.10 1,655.15 -1,616.46 None 2.19 National Bank Commerce Superior 1.25 7/15/2016 248,000.00 96.01 238,104.80 0.11% None 15 7/15/2021-17 633368E67 248,000.00 1.25 248,000.00 2.88 135.89 -9,895.20 None 2.5 Northern Bank&Trust MA 1.1 7/12/2016 248,000.00 99.27 246,200.76 0.11% None 12 7/12/2019-17 66476QBH0 248,000.00 1.10 248,000.00 2.48 597.92 -1,799.24 None 0.53 Northwest Bank Boise Idaho 1.5 1/10/2019 4/10/2014 248,000.00 99.99 247,976.94 0.11% None 10 66736AAD1 248,000.00 1.50 248,000.00 1.85 214.03 -23.06 None 0.03 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 97.75 242,424.22 0.11% None 547 69413CFD6 248,000.00 1.25 248,000.00 2.79 8.49 -5,575.78 None 1.48 Parkside Finl Bank&Trust 1.3 7/18/2016 248,000.00 95.99 238,056.94 0.11% None 18 7/19/2021-17 70147ABX1 248,000.00 1.30 248,000.00 2.93 114.83 -9,943.06 None 2.51 Partners Bank 1.5 9/30/2019 3/30/2015 248,000.00 99.50 246,766.70 0.11% None 273 70212YAR3 248,000.00 1.50 248,000.00 2.17 0.00 -1,233.30 None 0.75 Pearland State Bank 0.9 7/24/2019 7/24/2018 245,000.00 100.00 245,000.00 0.11% None 205 700013947C 245,000.00 0.90 245,000.00 0.90 966.58 0.00 None 0.56 Peoples United Bank 1.9 11/19/2019 11/19/2014 248,000.00 99.48 246,709.90 0.11% None 323 71270QKM7 248,000.00 1.90 248,000.00 2.50 542.20 -1,290.10 None 0.88 Prepared by Shamaira Jagrup 8 of 13 "'�>, City of Pearland c liiiitakilla Portfolio Holdings by Security Type `f' 00 ' Report Group: Pearland Date: 12/31/2018 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 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 96.34 238,911.30 0.11% None 906 73565NBQ5 248,000.00 1.40 248,000.00 2.93 66.59 -9,088.70 None 2.44 Quantum National Bank 1.2 9/18/2019-16 3/18/2016 248,000.00 99.06 245,678.47 0.11% None 77 74765JETI 248,000.00 1.20 248,000.00 2.53 105.99 -2,321.53 None 0.71 Sallie Mae Bank 2.15 11/19/2019 11/19/2014 248,000.00 99.49 246,732.72 0.11% None 323 795450VC6 248,000.00 2.15 248,000.00 2.74 613.55 -1,267.28 None 0.88 Signature Bank 1.35 3/28/2019 9/29/2015 248,000.00 99.87 247,668.67 0.11% None 87 82669LFU2 248,000.00 1.35 248,000.00 1.90 27.52 -331.33 None 0.24 Summit Community Bank Moorefield WV 6/30/2017 248,000.00 99.50 246,771.16 0.11% None 179 1.55 6/28/2019 86604XLX2 248,000.00 1.55 248,000.00 2.57 31.59 -1,228.84 None 0.49 Umpqua Bank Roseburg OR 1.6 6/28/2019 6/30/2017 248,000.00 99.53 246,838.37 0.11% None 179 90421MAX1 248,000.00 1.60 248,000.00 2.56 10.87 -1,161.63 None 0.49 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 98.65 244,647.04 0.11% None 669 91330ABC0 248,000.00 1.65 248,000.00 2.41 0.00 -3,352.96 None 1.81 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 96.03 238,143.74 0.11% None 924 92834CBW1 248,000.00 1.30 248,000.00 2.94 1,528.09 -9,856.26 None 2.48 Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 96.94 240,412.69 0.11% None 821 938828AC4 248,000.00 1.50 248,000.00 2.91 0.00 -7,587.31 None 2.21 Webster Bank NA 1.9 2/12/2019 2/12/2014 248,000.00 99.96 247,889.14 0.11% None 43 94768NJM7 248,000.00 1.90 248,000.00 2.27 1,820.25 -110.86 None 0.12 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 96.39 239,036.04 0.11% None 899 9497485W3 248,000.00 1.75 248.000.00 3.28 166.47 -8.963.96 None 2.41 16,858,000.00 16,586,091.15 7.48000000000001% 422 Sub Total Certificate Of Deposit 16,858,000.00 1.56 16,858,000.00 2.61 26,170.81 -271,908.85 1.33 Compound CD Prepared by Shamaira Jagrup 9 of 13 <, City of Pearland ilitakkal Portfolio Holdings by Security Type 'r'' ,o'+' Report Group: Pearland Date: 12/31/2018 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 CDARS 1.05 6/15/2019 6/15/2017 508,192.94 100.00 508,192.94 0.22% None 166 CDARS061517 508,192.94 1.05 508,192.94 1.05 0.00 0.00 None 0.45 508,192.94 508,192.94 0.22% 166 Sub Total Compound CD 508,192.94 1.05 508,192.94 1.05 0.00 0.00 0.45 FAMC Bond FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 99.34 993,443.00 0.43% S&P-AA+ 234 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.54 5,375.00 -6,557.00 Moodys-Aaa 0.64 FAMC 1.5 8/22/2019 2/22/2017 2,001,700.00 99.34 1,986,886.00 0.87% S&P-AA+ 234 3132X0PV7 2,000,000.00 1.47 2,000,436.33 2.54 10,750.00 -13,550.33 Moodys-Aaa 0.64 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 99.34 993,443.00 0.43% S&P-AA+ 234 3132XOPV7 1,000,000.00 1.50 1,000,000.00 2.54 5,375.00 -6,557.00 Moodys-Aaa 0.64 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 98.95 989,455.00 0.43% Moodys-Aaa 420 3132X0PW5 1,000,000.00 1.63 1,000,458.89 2.61 5,909.03 -11,003.89 S&P-AA+ 1.13 FAMC 1.6752/24/2020 2/24/2017 1,001,200.00 98.95 989,455.00 0.43% Moodys-Aaa 420 3132X0PW5 1,000,000.00 1.63 1,000,458.89 2.61 5,909.03 -11,003.89 S&P-AA+ 1.13 FAMC 1.82 11/9/2020 11/9/2017 1,000,000.00 98.71 987,135.00 0.43% Moodys-Aaa 679 3132X0ZC8 1,000,000.00 1.82 1,000,000.00 2.53 2,628.89 -12,865.00 S&P-M+ 1.83 7,004,100.00 6,939,817.00 3.02% 351 Sub Total FAMC Bond 7,000,000.00 1.57 7,001,354.11 2.56 35,946.95 -61,537.11 0.95 FFCB Bond FFCB 1.5 1/28/2019 5/28/2014 1,000,000.00 99.94 999,446.00 0.43% Moodys-Aaa 28 3133EDMF6 1,000,000.00 1.50 1,000,000.00 2.23 6,375.00 -554.00 S&P-AA+ 0.08 FFCB 1.84 10/30/2020-18 10/30/2017 1,000,000.00 98.66 986,627.00 0.43% Moodys-Aaa 1 3133EHM26 1,000,000.00 1.84 1,000,000.00 2.59 3,066.67 -13,373.00 S&P-AA+ 1.81 2,000,000.00 1,986,073.00 0.86% 14 Sub Total FFCB Bond 2,000,000.00 1.67 2,000,000.00 2.41 9,441.67 -13,927.00 0.94 FHLB Bond Prepared by Shamaira Jagrup 10 of 13 City of Pearland .-A - R Portfolio Holdings by Security Type Report Group: Pearland Date: 12/31/2018 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 1 9/26/2019 9/22/2016 997,430.00 98.79 987,908.00 0.43% Moodys-Aaa 269 3130A9EP2 1,000,000.00 1.09 999,371.73 2.67 2,638.89 -11,463.73 S&P-AA+ 0.73 FHLB 1.456/28/2019-17 6/28/2017 1,000,000.00 99.44 994,400.00 0.43% Moodys-Aaa 87 3130ABHRO 1,000,000.00 1.45 1,000,000.00 2.60 120.83 -5,600.00 S&P-AA+ 0.49 FHLB 2.21/29/2021-19 1/29/2018 1,000,000.00 99.15 991,473.00 0.43% Moodys-Aaa 29 3130ADC26 1,000,000.00 2.20 1,000,000.00 2.62 9,288.89 -8,527.00 S&P-AA+ 2.02 FHLB 2.4 3/27/2020-18 3/27/2018 1,000,000.00 99.70 997,003.00 0.43% S&P-AA+ 86 3130ADSH6 1,000,000.00 2.40 1,000,000.00 2.65 6,266.67 -2,997.00 Moodys-Aaa 1.22 3,997,430.00 3,970,784.00 1.72% 118 Sub Total FHLB Bond 4,000,000.00 1.78 3,999,371.73 2.64 18,315.28 -28,587.73 1.12 FHLMC Bond FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 96.58 965,807.00 0.43% Moodys-Aaa 955 3137EAEC9 1,000,000.00 1.37 993,872.81 2.48 4,187.50 -28,065.81 S&P-AA+ 2.57 FHLMC 1.42 3/29/2019-17 3/29/2017 2,000,000.00 99.77 1,995,484.00 0.87% S&P-AA+ 88 3134GA6G4 2,000,000.00 1.42 2,000,000.00 2.34 7,257.78 -4,516.00 Moodys-Aaa 0.24 FHLMC 2 11/20/2020-18 12/5/2017 1,000,000.00 98.83 988,306.00 0.43% Moodys-Aaa 51 3134GBW32 1,000,000.00 2.00 1,000,000.00 2.64 2,277.78 -11,694.00 S&P-AA+ 1.86 FHLMC 2.2 12/8/2021-18 12/8/2017 1,000,000.00 98.81 988,089.00 0.43% Moodys-Aaa 67 3134GB4N9 1,000,000.00 2.20 1,000,000.00 2.62 1,405.56 -11,911.00 S&P-AA+ 2.86 FHLMC Step 8/3/2021-18 3/9/2018 691,243.00 99.04 693,268.10 0.3% S&P-AA+ 34 3134GBA93 700,000.00 2.61 693,332.09 2.72 5,755.56 -63.99 Moodys-Aaa 2.51 5,679,783.00 5,630,954.10 2.46% 223 Sub Total FHLMC Bond 5,700,000.00 1.79 5,687,204.90 2.51 20,884.18 -56,250.80 1.67 FNMA Bond FNMA 1.375 3/13/2019-16 9/22/2016 1,009,560.00 99.78 997,798.00 0.43% Moodys-Aaa 72 3136G1FY0 1,000,000.00 0.98 1,000,772.53 2.47 4,125.00 -2,974.53 S&P-AA+ 0.2 Prepared by Shamaira Jagrup 11 of 13 '" City of Pearland °- GiinkiQ Portfolio Holdings by Security Type Report Group: Pearland Date:12/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 98.72 987,198.00 0.44% Moodys-Aaa 728 3135G01-155 1,000,000.00 1.25 1,012,080.70 2.54 156.25 -24,882.70 S&P-AA+ 1.96 2,035,440.00 1,984,996.00 0.67% 402 Sub Total FNMA Bond 2,000,000.00 1.12 2,012,853.23 2.50 4,281.25 -27,857.23 1.08 Local Government Investment Pool Texas Class LGIP 1/15/2017 4,931,090.77 100.00 4,931,090.77 2.14% None 1 TX-01-0615-0001 4,931,090.77 2.50 4,931,090.77 2.50 0.00 None 0 Texas Class LGIP 5/15/2017 515,353.35 100.00 515,353.35 0.22% None 1 TX-01-0615-0001 515,353.35 2.50 515,353.35 2.50 0.00 None 0 Texas Class LGIP 12/20/2016 3,628,394.37 100.00 3,628,394.37 1.57% None 1 TX-01-0615-0001 3,628,394.37 2.50 3,628,394.37 2.50 0.00 None 0 Texas Class LGIP 5/15/2017 3,092,120.03 100.00 3,092,120.03 1.34% None 1 TX-01-0615-0001 3,092,120.03 2.50 3,092,120.03 2.50 0.00 None 0 Texas Class LGIP 1/15/2017 1,033,640.78 100.00 1,033,640.78 0.45% None 1 TX-01-0615-0001 1,033,640.78 2.50 1,033,640.78 2.50 0.00 None 0 Texas Class LGIP 1/15/2017 231,758.22 100.00 231,758.22 0.1% None 1 TX-01-0615-0001 231,758.22 2.50 231,758.22 2.50 0.00 None 0 Texas Class LGIP 12/20/2016 1,145,531.28 100.00 1,145,531.28 0.5% None 1 TX-01-0615-0001 1,145,531.28 2.50 1,145,531.28 2.50 0.00 None 0 Texas Class LGIP 12/20/2016 6,372,799.25 100.00 6,372,799.25 2.76% None 1 TX-01-0615-0001 6,372,799.25 2.50 6,372,799.25 2.50 0.00 None 0 Texas Class LGIP 12/20/2016 23,375,236.92 100.00 23,375,236.92 10.13% None 1 TX-01-0615-0001 23,375,236.92 2.50 23,375,236.92 2.50 0.00 None 0 Texas Class LGIP 9/15/2018 7,971,929.20 100.00 7,971,929.20 3.46% None 1 TX-01-0615-0005 7,971,929.20 2.50 7,971,929.20 2.50 0.00 None 0 Prepared by Shamaira Jagrup 12 of 13 08 I !'f 4 9 .., City of Pearland 9 Portfolio Holdings by Security Type f'f 'p4' Report Group: Pearland Date:12/31/2018 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 9/15/2018 7,589,196.06 100.00 7,589,196.06 3.29% None 1 TX-01-0615-0006 7,589,196.06 2.50 7,589,196.06 2.50 0.00 None '0 Texas Class LGIP 9/15/2018 15,906,736.80 100.00 15,906,736.80 6.89% None 1 TX-01-0615-0004 15,906,736.80 2.50 15,906,736.80 2.50 0.00 None 0 Texas Class LGIP 5/15/2017 20,086.69 100.00 20,086.69 0.01% None 1 TX-01-0615-0001 20,086.69 2.50 20,086.69 2.50 0.00 None 0 Texas Class LGIP 9/15/2018 5,138,552.10 100.00 5,138,552.10 2.23% None 1 TX-01-0615-0004 5,138,552.10 2.50 5,138,552.10 2.50 0.00 None 0 TexSTAR LGIP 8/26/2016 1,620,607.18 100.00 1,620,607.18 0.7% S&P-AAA 1 02000-11110 1,620,607.18 2.31 1,620,607.18 2.31 0.00 None 0 TexSTAR LGIP 8/26/2016 3,134,079.32 100.00 3,134,079.32 1.36% S&P-AAA 1 02000-11110 3,134,079.32 2.31 3,134,079.32 2.31 0.00 None 0 85,707,112.32 85,707,112.32 37.15% 1 Sub Total Local Government Investment 85,707,112.32 2.49 85,707,112.32 2.49 0.00 0 Pool 230,741,420.04 230,265,382.29 100.00% 54 TOTAL PORTFOLIO 230,724,667.04 2.27 230,725,451.01 2.43 115,040.14 -460,068.72 0.2 Prepared by Shamaira Jagrup 13 of 13 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2018 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 100:General Fund Alma Bank 1.35 12/24/2020 6/24/2016 248,000.00 96.73 239,879.24 0.11% None 724 020080BB2 248,000.00 1.35 248,000.00 3.06 64.21 -8,120.76 None 1.95 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 96.01 238,092.90 0.11% None 924 02554BCM1 248,000.00 1.35 248,000.00 2.99 183.45 -9,907.10 None 2.49 Bank Leumi USA 1.3 2/26/2020 3/3/2016 248,000.00 98.95 245,408.15 0.11% None 422 063248FH6 248,000.00 1.30 248,000.00 2.22 1,121.78 -2,591.85 , None 1.15 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 98.78 244,963.74 0.11% None 634 06610QCV1 248,000.00 1.80 248,000.00 2.52 73.38 -3,036.26 None 1.71 Bar Harbor Bank&Trust 2.65 3/29/2021 3/29/2018 248,000.00 99.03 245,601.59 0.11% None 29 -18 066851 WB8 248,000.00 2.65 248,000.00 3.10 36.01 -2,398.41 None 2.18 Belmont Savings Bank 1.85 10/23/2019 12/23/2014 248,000.00 99.50 246,750.58 0.11% None 296 080515BD0 248,000.00 1.85 248,000.00 2.48 100.56 -1,249.42 None 0.81 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 98.81 245,053.02 0.11% None 634 14042RAB7 248,000.00 2.30 248,000.00 3.01 1,515.86 -2,946.98 None 1.7 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 97.54 241,900.44 0.11% None 574 144153AW3 248,000.00 1.10 248,000.00 2.70 29.90 -6,099.56 None 1.56 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248,000.00 99.50 246,754.05 0.11% None 323 17284C3Z5 248,000.00 2.10 248,000.00 2.68 599.28 -1,245.95 None 0.88 Commercial Bank Ala Mich 1.5 3/29/2019 6/30/2015 248,000.00 99.77 247,430.59 0.11% None 88 201282GV6 248,000.00 1.50 248,000.00 2.44 20.38 -569.41 None 0.24 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 96.31 238,849.79 0.11% None 912 203507BG2 248,000.00 1.50 248,000.00 3.04 10.19 -9,150.21 None 2.45 Community Bankers'Bank 1.4 6/30/2016 248,000.00 96.31 238,838.14 0.11% None 912 6/30/2021 20361LBR4 248,000.00 1.40 248,000.00 2.94 9.51 -9,161.86 None 2.45 Prepared by Shamaira Jagrup 1 of 16 d rri4 >t City of Pearland iiiiitakaill Portfolio Holdings by Portfolio Name ('' ,w"' Report Group: Pearland Date: 12/31/2018 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 Exchange Bank NEB 1.05 1/21/2020 7/20/2016 248,000.00 98.23 243,619.58 0.11% None 386 301074CH1 248,000.00 1.05 248,000.00 2.75 78.48 -4,380.42 None 1.05 Fahey Banking 1.1 6/28/2019 3/29/2016 248,000.00 99.51 246,793.98 0.11% None 179 303117CC7 248,000.00 1.10 248,000.00 2.10 22.42 -1,206.02 None 0.49 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 98.95 989,455.00 0.43% Moodys-Aaa 420 3132X0PW5 1,000,000.00 1.63 1,000,458.89 2.61 5,909.03 -11,003.89 S&P-AA+ 1.13 FHLB 1.45 6/28/2019-17 6/28/2017 1,000,000.00 99.44 994,400.00 0.43% Moodys-Aaa 87 3130ABHRO 1,000,000.00 1.45 1,000,000.00 2.60 120.83 -5,600.00 S&P-AA+ 0.49 FHLB 2.4 3/27/2020-18 3/27/2018 1,000,000.00 99.70 997,003.00 0.43% S&P-AA+ 86 3130ADSH6 1,000,000.00 2.40 1,000,000.00 2.65 6,266.67 -2,997.00 Moodys-Aaa 1.22 FHLMC 1.42 3/29/2019-17 3/29/2017 2,000,000.00 99.77 1,995,484.00 0.87% S&P-AA+ 88 3134GA6G4 2,000,000.00 1.42 2,000,000.00 2.34 7,257.78 -4,516.00 Moodys-Aaa 0.24 FHLMC Step 8/3/2021-18 3/9/2018 691,243.00 99.04 693,268.10 0.3% S&P-AA+ 34 3134GBA93 700,000.00 2.61 693,332.09 2.72 5,755.56 -63.99 Moodys-Aaa 2.51 _ FIRST BANK HIGHLAND PARK 1.85 5/7/2014 248,000.00 99.77 247,429.60 0.11% None 38 5/7/2019-14 319141BL0 248,000.00 1.85 248,000.00 2.50 678.77 -570.40 None 0.35 JP Morgan Chase Bk NA Columbus 2.1 2/15/2017 245,000.00 97.99 240,074.76 0.11% None 15 2/15/2021-17 48126XVW2 245,000.00 2.10 245,000.00 3.08 225.53 -4,925.24 None 2.08 Machias Savings Bank 1.65 2/6/2020 2/6/2015 248,000.00 99.38 246,465.62 0.11% None 402 554479DS1 248,000.00 1.65 248,000.00 2.22 280.27 -1,534.38 None 1.09 Mahopac Bank 1.45 7/30/2019 1/30/2015 248,000.00 99.71 247,275.84 0.11% None 211 560160AQ6 248,000.00 1.45 248,000.00 1.96 1,517.22 -724.16 None 0.58 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 99.35 246,383.54 0.11% None 826 61747MS69 248,000.00 2.80 248,000.00 3.10 1,655.15 -1,616.46 None 2.19 Prepared by Shamaira Jagrup 2 of 16 <a , City of Pearland libialdial Portfolio Holdings by Portfolio Name `'' '""' Report Group: Pearland Date: 12/31/2018 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 Pearland State Bank 0.9 7/24/2019 7/24/2018 245,000.00 100.00 245,000.00 0.11% None 205 700013947C 245,000.00 0.90 245,000.00 0.90 966.58 0.00 None 0.56 Quantum National Bank 1.2 9/18/2019-16 3/18/2016 248,000.00 99.06 245,678.47 0.11% None 77 74765JETI 248,000.00 1.20 248,000.00 2.53 105.99 -2,321.53 None 0.71 Sallie Mae Bank 2.15 11/19/2019 11/19/2014 248,000.00 99.49 246,732.72 0.11% None 323 795450VC6 248,000.00 2.15 248,000.00 2.74 613.55 -1,267.28 None 0.88 Texas Class LGIP 5/15/2017 20,086.69 100.00 20,086.69 0.01% None 1 TX-01-0615-0001 20,086.69 2.50 20,086.69 2.50 0.00 None 0 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 98.65 244,647.04 0.11% None 669 91330ABC0 248,000.00 1.65 248,000.00 2.41 0.00 -3,352.96 None 1.81 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 96.03 238,143.74 0.11% None 924 92834CBW1 248,000.00 1.30 248,000.00 2.94 1,528.09 -9,856.26 None 2.48 Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 96.94 240,412.69 0.11% None 821 938828AC4 248,000.00 1.50 248,000.00 2.91 0.00 -7,587.31 None 2.21 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 96.39 239,036.04 0.11% None 899 9497485W3 248,000.00 1.75 248,000.00 3.28 166.47 -8,963.96 None 2.41 Wells Fargo Sweep Cash 5/31/2006 16,427,862.32 100.00 16,427,862.32 7.12% None 1 WFSWEEP 16,427,862.32 2.35 16,427,862.32 2.35 0.00 None 0 28,582,392.01 28,454,774.96 12.45% 136 Sub Total 100:General Fund 28,589,949.01 2.08 28,583,739.99 2.45 36,912.90 -128,965.03 0.51 200:Debt Services 1st Source Bank 1.5 11/18/2019 4/17/2015 248,000.00 99.32 246,322.53 0.11% None 322 33646CEQ3 248,000.00 1.50 248,000.00 2.28 764.38 -1,677.47 None 0.88 Charter Bank 1.7 2/25/2020 2/25/2015 248,000.00 98.78 244,972.66 0.11% None 421 1611646E7 248,000.00 1.70 248,000.00 2.78 69.30 -3,027.34 None 1.14 Prepared by Shamaira Jagrup 3 of 16 •, P City of Pearland sae oitli g Portfolio Holdings by Portfolio Name " Report Group: Pearland Date: 12/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Discover Bank 2 2/25/2020 2/25/2015 248,000.00 99.12 245,818.84 0.11% None 421 254672JA7 248,000.00 2.00 248,000.00 2.78 1,739.40 -2,181.16 None 1.14 First Capital Bank 1.48/6/2019 4/6/2015 248,000.00 99.54 246,863.42 0.11% None 218 31944FBK5 248,000.00 1.40 248,000.00 2.17 237.81 -1,136.58 None 0.6 Goldman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 99.12 245,818.84 0.11% None 421 38148JLL3 248,000.00 2.00 248,000.00 2.78 1,739.40 -2,181.16 None 1.14 Partners Bank 1.5 9/30/2019 3/30/2015 248,000.00 99.50 246,766.70 0.11% None 273 70212YAR3 248,000.00 1.50 248,000.00 2.17 0.00 s -1,233.30 None 0.75 Texas Class LGIP 1/15/2017 4,931,090.77 100.00 4,931,090.77 2.14% None 1 TX-01-0615-0001 4,931,090.77 2.50 4,931,090.77 2.50 0.00 None 0 Webster Bank NA 1.9 2/12/2019 2/12/2014 248,000.00 99.96 247,889.14 0.11% None 43 94768NJM7 248,000.00 1.90 248,000.00 2.27 1,820.25 -110.86 None 0.12 Wells Fargo Sweep Cash 5/31/2006 19,100,404.67 100.00 19,100,404.67 8.28% None 1 WFSWEEP 19,100,404.67 2.35 19,100,404.67 2.35 0.00 None 0 25,767,495.44 25,755,947.57 11.19% 21 Sub Total 200:Debt Services 25,767,495.44 2.34 25,767,495.44 2.39 6,370.54 -11,547.87 0.06 305: Hotel/Motel Occupancy Ally Bank Midvale Utah 1.8 6/29/2020 6/29/2017 248,000.00 98.41 244,055.06 0.11% None 546 02006L3U5 248,000.00 1.80 248,000.00 2.90 24.46 -3,944.94 None 1.48 Bank of New England NH 1.4 6/30/2021 • 6/30/2016 248,000.00 96.31 238,838.14 0.11% None 912 063847AL1 248,000.00 1.40 248,000.00 2.94 9.51 -9,161.86 None 2.45 Capital Bank Little Rock 1.35 3/22/2019 9/23/2015 248,000.00 99.88 247,713.06 0.11% , None 81 139797FL3 248,000.00 1.35 248,000.00 1.87 82.55 -286.94 None 0.23 First Intl Bank&Trust 1.6 1/16/2020 10/16/2015 248,000.00 98.83 245,090.46 0.11% None 381 32057GAE9 248,000.00 1.60 248,000.00 2.74 163.07 -2,909.54 None 1.03 Prepared by Shamaira Jagrup 4 of 16 City of Pearland ,t�E�1RLANQ Portfolio Holdings by Portfolio Name Report Group: Pearland Date:12/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP 5/15/2017 3,092,120.03 100.00 3,092,120.03 1.34% None 1 TX-01-0615-0001 3,092,120.03 2.50 3,092,120.03 2.50 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 462,161.57 100.00 462,161.57 0.2% None 1 WFSWEEP 462,161.57 2.35 462,161.57 2.35 0.00 None 0 4,546,281.60 4,529,978.32 1.98% 106 Sub Total 305:Hotel/Motel Occupancy 4,546,281.60 2.27 4,546,281.60 2.51 279.59 -16,303.28 0.28 310: Municipal Court Security Wells Fargo Sweep Cash 5/31/2006 25,268.87 100.00 25,268.87 0.01% None 1 WFSWEEP 25,268.87 2.35 25,268.87 2.35 0.00 None 0 25,268.87 25,268.87 0.01% 1 Sub Total 310:Municipal Court Security 25,268.87 2.35 25,268.87 2.35 0.00 0 315:City Wide Donation Wells Fargo Sweep Cash 5/31/2006 104,481.68 100.00 104,481.68 0.05% None 1 WFSWEEP 104,481.68 2.35 104,481.68 2.35 0.00 None 0 104,481.68 104,481.68 0.05% 1 Sub Total 315:City Wide Donation 104,481.68 2.35 104,481.68 2.35 0.00 0 320:Court Technology Wells Fargo Sweep Cash 5/31/2006 -1,743.57 100.00 -1,743.57 0% None 1 WFSWEEP -1,743.57 2.35 -1,743.57 2.35 0.00 None 0 -1,743.57 -1,743.57 0% 1 Sub Total 320:Court Technology -1,743.57 2.35 -1,743.57 2.35 0.00 0 330:Park Donations Wells Fargo Sweep Cash 5/31/2006 115,503.80 100.00 115,503.80 0.05% None 1 WFSWEEP 115,503.80 2.35 115,503.80 2.35 0.00 None 0 115,503.80 115,503.80 0.05% 1 Sub Total 330:Park Donations 115,503.80 2.35 115,503.80 2.35 0.00 0 331:Tree Trust Fund Prepared by Shamaira Jagrup 5 of 16 rr, 0 City of Pearland Lik410441 Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2018 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 470,659.14 100.00 470,659.14 0.2% None 1 WFSWEEP 470,659.14 2.35 470,659.14 2.35 0.00 None 0 470,659.14 470,659.14 0.2% 1 Sub Total 331:Tree Trust Fund 470,659.14 2.35 470,659.14 2.35 0.00 0 335:Police State Seizure _ Wells Fargo Sweep Cash 5/31/2006 239,436.18 100.00 239,436.18 0.1% None 1 WFSWEEP 239,436.18 2.35 239,436.18 2.35 0.00 None 0 239,436.18 239,436.18 0.1% 1 Sub Total 335:Police State Seizure 239,436.18 2.35 239,436.18 2.35 0.00 0 336:Federal Police Fund Wells Fargo Sweep Cash 5/31/2006 138,928.24 100.00 138,928.24 0.06% None 1 WFSWEEP 138,928.24 2.35 138,928.24 2.35 0.00 None 0 138,928.24 138,928.24 0.06% 1 Sub Total 336:Federal Police Fund 138,928.24 2.35 138,928.24 2.35 0.00 0 340: Park&Rec Development Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 95.83 237,670.30 0.11% None 912 099703EF3 248,000.00 1.40 248,000.00 3.14 9.51 -10,329.70 None 2.45 Wells Fargo Sweep Cash 5/31/2006 949,331.84 100.00 949,331.84 0.41% None 1 WFSWEEP 949,331.84 2.35 949,331.84 2.35 0.00 None 0 1,197,331.84 1,187,002.14 0.52% 190 Sub Total 340:Park&Rec Development 1,197,331.84 2.15 1,197,331.84 2.51 9.51 -10,329.70 0.51 345:Sidewalk Fund Wells Fargo Sweep Cash 5/31/2006 5,446.12 100.00 5,446.12 0% None 1 WFSWEEP 5,446.12 2.35 5,446.12 2.35 0.00 None 0 5,446.12 5,446.12 0% 1 Sub Total 345:Sidewalk Fund 5,446.12 2.35 5,446.12 2.35 0.00 0 350:Grant Fund Prepared by Shamaira Jagrup 6 of 16 e City of Pearland iiivaRidal Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2018 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 Sweep Cash 5/31/2006 -80,853.16 100.00 -80,853.16 -0.04% None 1 WFSWEEP -80,853.16 2.35 -80,853.16 2.35 0.00 None 0 -80,853.16 -80,853.16 -0.04% 1 Sub Total 350:Grant Fund -80,853.16 2.35 -80,853.16 2.35 0.00 0 351:CDBG Fund Wells Fargo Sweep Cash 11/15/2015 36,121.82 100.00 36,121.82 0.02% None 1 WFSWEEP 36,121.82 2.35 36,121.82 2.35 0.00 None 0 36,121.82 36,121.82 0.02% 1 Sub Total 351:CDBG Fund 36,121.82 2.35 36,121.82 2.35 0.00 0 360:Traffic Impact Improvement Summit Community Bank Moorefield WV 6/30/2017 248,000.00 99.50 246,771.16 0.11% None 179 1.55 6/28/2019 86604XLX2 248,000.00 1.55 248,000.00 2.57 31.59 -1,228.84 None 0.49 Wells Fargo Sweep Cash 5/31/2006 354,585.99 100.00 354,585.99 0.15% None 1 WFSWEEP 354,585.99 2.35 354,585.99 2.35 0.00 None 0 602,585.99 601,357.15 0.26% 74 Sub Total 360:Traffic Impact Improvement 602,585.99 2.02 602,585.99 2.44 31.59 -1,228.84 0.2 365:Court Juvenile Mgmt Wells Fargo Sweep Cash 9/15/2009 31,719.95 100.00 31,719.95 0.01% None 1 WFSWEEP 31,719.95 2.35 31,719.95 2.35 0.00 None 0 31,719.95 31,719.95 0.01% 1 Sub Total 365:Court Juvenile Mgmt 31,719.95 2.35 31,719.95 2.35 0.00 0 370:Municipal Channel 'l Texas Class LGIP 5/15/2017 515,353.35 100.00 515,353.35 0.22% None 1 TX-01-0615-0001 515,353.35 2.50 515,353.35 2.50 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 226,872.33 100.00 226,872.33 0.1% None 1 WFSWEEP 226,872.33 2.35 226,872.33 2.35 0.00 None 0 742,225.68 742,225.68 0.32% 1 Sub Total 370:Municipal Channel 742,225.68 2.45 742,225.68 2.45 0.00 0 Prepared by Shamaira Jagrup 7 of 16 4. City of Pearland Portfolio Holdings by Portfolio Name _- Report Group: Pearland Date: 12/31/2018 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 380: Regional Detention Wells Fargo Sweep Cash 5/31/2006 3,182.23 100.00 3,182.23 0% None 1 WFSWEEP 3,182.23 2.35 3,182.23 2.35 0.00 None 0 3,182.23 3,182.23 0% 1 Sub Total 380:Regional Detention 3,182.23 2.35 3,182.23 2.35 0.00 0 500:Capital Projects Texas Class LGIP 1/15/2017 1,033,640.78 100.00 1,033,640.78 0.45% None 1 TX-01-0615-0001 1,033,640.78 2.50 1,033,640.78 2.50 0.00 None 0 Umpqua Bank Roseburg OR 1.6 6/28/2019 6/30/2017 248,000.00 99.53 246,838.37 0.11% None 179 90421MAX1 248,000.00 1.60 248,000.00 2.56 10.87 -1,161.63 None 0.49 Wells Fargo Sweep Cash 5/31/2006 2,362,979.51 100.00 2,362,979.51 1.02% None 1 WFSWEEP 2,362,979.51 2.35 2,362,979.51 2.35 0.00 None 0 3,644,620.29 3,643,458.66 1.58% 13 Sub Total 500:Capital Projects 3,644,620.29 2.34 3,644,620.29 2.41 10.87 -1,161.63 0.03 501:Certificates of Obligation 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 96.07 238,259.06 0.11% None 753 33625CAZ2 248,000.00 1.10 248,000.00 3.07 67.27 -9,740.94 None 2.04 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 99.34 993,443.00 0.43% S&P-AA+ 234 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.54 5,375.00 -6,557.00 Moodys-Aaa 0.64 FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 96.58 965,807.00 0.43% Moodys-Aaa 955 3137EAEC9 1,000,000.00 1.37 993,872.81 2.48 4,187.50 -28,065.81 S&P-AA+ 2.57 FNMA 1.87512/28/2020 9/22/2016 1,025,880.00 98.72 987,198.00 0.44% Moodys-Aaa 728 3135G0H55 1,000,000.00 1.25 1,012,080.70 2.54 156.25 -24,882.70 S&P-AA+ 1.96 Gulf Coast Bank&Trust 1.3 7/15/2021- 7/15/2016 248,000.00 96.01 238,108.27 0.11% None 15 17 402194EX8 248,000.00 1.30 248,000.00 2.93 141.33 -9,891.73 None 2.5 ' Marlin BusinessBank 1.25 12/27/2019 6/29/2016 248,000.00 98.59 244,506.18 0.11% None 361 57116AMC9 248,000.00 1.25 248,000.00 2.70 16.99 -3,493.82 None 0.98 Prepared by Shamaira Jagrup 8 of 16 c"'�T",, City of Pearland ibialakba Portfolio Holdings by Portfolio Name '` '"°' Report Group: Pearland Date: 12/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP 12/20/2016 1,145,531.28 100.00 1,145,531.28 0.5% None 1 TX-01-0615-0001 1,145,531.28 2.50 1,145,531.28 2.50 0.00 None 0 Texas Class LGIP 9/15/2018 7,589,196.06 100.00 7,589,196.06 3.29% None 1 TX-01-0615-0006 7,589,196.06 2.50 7,589,196.06 2.50 0.00 None 0 TexSTAR LGIP 8/26/2016 3,134,079.32 100.00 3,134,079.32 1.36% S&P-AAA 1 02000-11110 3,134,079.32 2.31 3,134,079.32 2.31 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 35,695.23 100.00 35,695.23 0.02% None 1 WFSWEEP 35,695.23 2.35 35,695.23 2.35 0.00 None 0 15,662,921.89 15,571,823.40 6.8% 141 Sub Total 501:Certificates of Obligation 15,648,501.89 2.18 15,654,455.40 2.48 9,944.34 -82,632.00 0.42 503:Certificates of Obligation 2006 Wells Fargo Sweep Cash 6/30/2006 63,576.63 100.00 63,576.63 0.03% None 1 WFSWEEP 63,576.63 2.35 63,576.63 2.35 0.00 None 0 63,576.63 63,576.63 0.03% 1 Sub Total 503:Certificates of Obligation 63,576.63 2.35 63,576.63 2.35 0.00 0 2006 506:General Obligation Brickell Bank Miami FL 1.65 10/28/2019 6/27/2017 248,000.00 99.18 245,971.86 0.11% None 301 10801DAG6 248,000.00 1.65 248,000.00 2.65 33.63 -2,028.14 None 0.82 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 96.83 240,128.73 0.11% None 905 12325EHU9 248,000.00 1.80 248,000.00 3.13 97.84 -7,871.27 None 2.42 Capital One Bank USA 1.1 11/19/2019 11/19/2014 248,000.00 99.49 246,732.47 0.11% None 323 140420QX1 248,000.00 1.10 248,000.00 1.68 313.91 -1,267.53 None 0.88 Citizens State Bank Clayton 1.35 4/30/2019 9/30/2015 248,000.00 99.81 247,519.38 0.11% None 120 176688887 248,000.00 1.35 248,000.00 1.94 9.17 -480.62 None 0.33 FFCB 1.5 1/28/2019 5/28/2014 1,000,000.00 99.94 999,446.00 0.43% Moodys-Aaa 28 3133EDMF6 1,000,000.00 1.50 1,000,000.00 2.23 6,375.00 -554.00 S&P-AA+ 0.08 Prepared by Shamaira Jagrup 9 of 16 ,,;, City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2018 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 FHLB 1 9/26/2019 9/22/2016 997,430.00 98.79 987,908.00 0.43% Moodys-Aaa 269 3130A9EP2 1,000,000.00 1.09 999,371.73 2.67 2,638.89 -11,463.73 S&P-AA+ 0.73 First Business Bank 1,7 6/30/2020 9/30/2015 248,000.00 98.26 243,682.57 0.11% None 547 31938QP40 248,000.00 1.70 248,000.00 2.90 1,062.66 -4,317.43 None 1.48 First National Bank of America 1.25 7/15/2016 248,000.00 95.42 236,630.94 0.11% None 927 7/15/2021 32110YHMO 248,000.00 1.25 248,000.00 3.14 1,435.34 -11,369.06 None 2.49 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 96.31 238,838.14 0.11% None 912 53362LAB0 248,000.00 1.40 248,000.00 2.93 285.37 -9,161.86 None 2.45 National Bank Commerce Superior 1.25 7/15/2016 248,000.00 96.01 238,104.80 0.11% None 15 7/15/2021-17 633368E67 248,000.00 1.25 248,000.00 2.88 135.89 -9,895.20 None 2.5 Peoples United Bank 1.9 11/19/2019 11/19/2014 248,000.00 99.48 246,709.90 0.11% None 323 71270QKM7 248,000.00 1.90 248,000.00 2.50 542.20 -1,290.10 None 0.88 Texas Class LGIP 12/20/2016 6,372,799.25 100.00 6,372,799.25 2.76% None 1 TX-01-0615-0001 6,372,799.25 2.50 6,372,799.25 2.50 0.00 None - 0 Texas Class LGIP 9/15/2018 7,971,929.20 100.00 7,971,929.20 3.46% None 1 TX-01-0615-0005 7,971,929.20 2.50 7,971,929.20 2.50 0.00 None 0 TexSTAR LGIP 8/26/2016 1,620,607.18 100.00 1,620,607.18 0.7% S&P-AAA 1 02000-11110 1,620,607.18 2.31 1,620,607.18 2.31 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 453,349.31 100.00 453,349.31 0.2% None 1 WFSWEEP 453,349.31 2.35 453,349.31 2.35 0.00 None 0 20,648,114.94 20,590,357.73 8.97% 68 Sub Total 506:General Obligation 20,650,684.94 2.26 20,650,056.67 2.49 12,929.90 -59,698.94 0.21 511:PEDC Capital Projects Wells Fargo Sweep Cash 12/15/2018 -682.10 100.00 -682.10 0% None 1 WFSWEEP -682.10 2.35 -682.10 2.35 0.00 None 0 Prepared by Shamaira Jagrup 10 of 16 City of Pearland Fj,'��ARly Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2018 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 -682.10 -682.10 0% 1 Sub Total 511:PEDC Capital Projects -682.10 2.35 -682.10 2.35 0.00 0 550:W/S Impact Fee Bankwest,Inc.1.51/3/2020 3/4/2015 248,000.00 98.78 244,964.23 0.11% None 368 06652CFA4 248,000.00 1.50 248,000.00 - 2.73 285.37 -3,035.77 None 1 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 98.71 244,800.30 0.11% None 536 05580ABX1 248,000.00 2.10 248,000.00 3.01 171.22 -3,199.70 None 1.45 Cedar Rapids Bank&Trust 1.5 1/30/2015 248,000.00 99.58 246,950.96 0.11% None 303 10/30/2019 150517CJ7 248,000.00 1.50 248,000.00 2.01 305.75 -1,049.04 None 0.82 EVB Tappa Hannock VA 1.6 9/25/2019 9/25/2015 248,000.00 99.58 246,953.44 0.11% None 268 26927ABK7 248,000.00 1.60 248,000.00 2.18 1,054.51 -1,046.56 None 0.73 FAMC 1.82 11/9/2020 11/9/2017 1,000,000.00 98.71 987,135.00 0.43% Moodys-Aaa 679 3132X0ZC8 1,000,000.00 1.82 1,000,000.00 2.53 2,628.89 -12,865.00 S&P-AA+ 1.83 FFCB 1.84 10/30/2020-18 10/30/2017 1,000,000.00 98.66 986,627.00 0.43% Moodys-Aaa 1 3133EHM26 1,000,000.00 1.84 1,000,000.00 2.59 3,066.67 -13,373.00 S&P-AA+ 1.81 FHLB 2.2 1/29/2021-19 1/29/2018 1,000,000.00 99.15 991,473.00 0.43% Moodys-Aaa 29 3130ADC26 1,000,000.00 2.20 1,000,000.00 2.62 9,288.89 -8,527.00 S&P-AA+ 2.02 FHLMC 2 11/20/2020-18 12/5/2017 1,000,000.00 98.83 988,306.00 0.43% Moodys-Aaa 51 3134GBW32 1,000,000.00 2.00 1,000,000.00 2.64 2,277.78 -11,694.00 S&P-AA+ 1.86 FHLMC 2.2 12/8/2021-18 12/8/2017 1,000,000.00 98.81 988,089.00 0.43% Moodys-Aaa 67 3134GB4N9 1,000,000.00 2.20 1,000,000.00 2.62 1,405.56 -11,911.00 S&P-AA+ 2.86 First Financial NW 1.35 10/30/2019 10/30/2015 248,000.00 98.92 245,332.26 0.11% None 303 32022MAF5 248,000.00 1.35 248,000.00 2.66 0.00 -2,667.74 None 0.83 FNMA 1.375 3/13/2019-16 9/22/2016 1,009,560.00 99.78 997,798.00 0.43% Moodys-Aaa 72 3136G1FY0 1,000,000.00 0.98 1,000,772.53 2.47 4,125.00 -2,974.53 S&P-AA+ 0.2 Prepared by Shamaira Jagrup 11 of 16 `''S City of Pearland `� Portfolio Holdings by Portfolio Name Report Group: Pearland Date:12/31/2018 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 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 97.75 242,424.22 0.11% None 547 69413CFD6 248,000.00 1.25 248,000.00 2.79 8.49 -5,575.78 None 1.48 Texas Class LGIP 12/20/2016 23,375,236.92 100.00 23,375,236.92 10.13% None 1 TX-01-0615-0001 23,375,236.92 2.50 23,375,236.92 2.50 0.00 None 0 Texas Class LGIP 9/15/2018 5,138,552.10 100.00 5,138,552.10 2.23% None 1 TX-01-0615-0004 5,138,552.10 2.50 5,138,552.10 2.50 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -1,206,372.93 100.00 -1,206,372.93 -0.52% None 1 WFSWEEP -1,206,372.93 2.35 -1,206,372.93 2.35 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 81,988.76 100.00 81,988.76 0.04% None 1 WF4094 81,988.76 2.35 81,988.76 2.35 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 8,550,538.04 100.00 8,550,538.04 3.71% None 1 WF6624 8,550,538.04 2.35 8,550,538.04 2.35 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 11,969,358.38 100.00 11,969,358.38 5.19% None 1 WF5883 11,969,358.38 2.35 11,969,358.38 2.35 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 3,924,846.30 100.00 3,924,846.30 1.7% None 1 WF4102 3,924,846.30 2.35 3,924,846.30 2.35 0.00 None 0 59,331,707.57 59,245,000.98 25.72% 26 Sub Total 550:W/S Impact Fee 59,322,147.57 2.35 59,322,920.10 2.45 24,618.13 -77,919.12 0.2 555:Shadow Creek Impact FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 98.95 989,455.00 0.43% Moodys-Aaa 420 3132X0PW5 1,000,000.00 1.63 1,000,458.89 2.61 5,909.03 -11,003.89 S&P-AA+ 1.13 Wells Fargo Sweep Cash 5/31/2006 171,202.85 100.00 171,202.85 0.07% None 1 WFSWEEP 171,202.85 2.35 171,202.85 2.35 0.00 None 0 1,172,402.85 1,160,657.85 0.5% 359 Sub Total 555:Shadow Creek Impact 1,171,202.85 1.74 1,171,661.74 2.57 5,909.03 -11,003.89 0.96 565:Revenue Bonds 1999&2003 Prepared by Shamaira Jagrup 12 of 16 City of Pearland ;gym_, Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2018 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 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 99.34 993,443.00 0.43% S&P-AA+ 234 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.54 5,375.00 -6,557.00 Moodys-Aaa 0.64 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 96.31 238,849.79 0.11% None 912 36198JCC6 248,000.00 1.50 248,000.00 3.04 10.19 -9,150.21 None 2.45 Signature Bank 1.35 3/28/2019 9/29/2015 248,000.00 99.87 247,668.67 0.11% None 87 82669LFU2 248,000.00 1.35 248,000.00 1.90 27.52 -331.33 None 0.24 Texas Class LGIP 1/15/2017 231,758.22 100.00 231,758.22 0.1% None 1 TX-01-0615-0001 231,758.22 2.50 231,758.22 2.50 0.00 None 0 Texas Class LGIP 9/15/2018 15,906,736.80 100.00 15,906,736.80 6.89% None 1 TX-01-0615-0004 15,906,736.80 2.50 15,906,736.80 2.50 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,604,594.58 100.00 1,604,594.58 0.7% None 1 WFSWEEP 1,604,594.58 2.35 1,604,594.58 2.35 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 10,177,687.46 100.00 10,177,687.46 4.41% None 1 WF5875 10,177,687.46 2.35 10,177,687.46 2.35 0.00 None 0 29,416,777.06 29,400,738.52 12.75% 17 Sub Total 565:Revenue Bonds 1999& 29,416,777.06 2.39 29,416,777.06 2.44 5,412.71 -16,038.54 0.04 2003 570:W/S Pay As You Go Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 96.92 240,360.86 0.11% None 911 56817TAB7 248,000.00 1.80 248,000.00 3.09 24.46 -7,639.14 None 2.44 Wells Fargo Sweep Cash 12/31/2007 3,628,527.30 100.00 3,628,527.30 1.57% None 1 WFSWEEP 3,628,527.30 2.35 3,628,527.30 2.35 0.00 None 0 3,876,527.30 3,868,888.16 1.68% 59 Sub Total 570:W/S Pay As You Go 3,876,527.30 2.31 3,876,527.30 2.40 24.46 -7,639.14 0.16 575:MUD 4 Capital Programs Wells Fargo Sweep Cash 2/1/2013 25,098.07 100.00 25,098.07 0.01% None 1 WFSWEEP 25,098.07 2.35 25,098.07 2.35 0.00 None 0 Prepared by Shamaira Jagrup 13 of 16 ``' City of Pearland 9 Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2018 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 25,098.07 25,098.07 0.01% 1 Sub Total 575:MUD 4 Capital Programs 25,098.07 2.35 25,098.07 2.35 0.00 0 600:Water&Sewer BARCLAYS BANK DELAWARE 1.95 5/6/2014 248,000.00 99.82 247,554.59 0.11% None 127 5/7/2019 06740KGU5 248,000.00 1.95 248,000.00 2.46 715.46 -445.41 None 0.35 CDARS 1.05 6/15/2019 6/15/2017 508,192.94 100.00 508,192.94 0.22% None 166 CDARS061517 508,192.94 1.05 508,192.94 1.05 0.00 0.00 None 0.45 FAMC 1.58/22/2019 2/22/2017 2,001,700.00 99.34 1,986,886.00 0.87% S&P-AA+ 234 3132X0PV7 2,000,000.00 1.47 2,000,436.33 2.54 10,750.00 -13,550.33 Moodys-Aaa 0.64 First Bank McComb MS 1.5 2/28/2019 6/30/2015 248,000.00 99.89 247,730.92 0.11% None 59 319234AJ9 248,000.00 1.50 248,000.00 2.19 30.58 -269.08 None 0.16 MB Financial Bank 1.1 3/18/2019 3/18/2016 248,000.00 99.81 247,518.14 0.11% None 77 55266CQU3 248,000.00 1.10 248,000.00 2.01 97.16 -481.86 None 0.21 Northern Bank&Trust MA 1.1 7/12/2016 248,000.00 99.27 246,200.76 0.11% None 12 7/12/2019-17 66476QBH0 248,000.00 1.10 248,000.00 2.48 597.92 -1,799.24 None 0.53 Northwest Bank Boise Idaho 1.5 1/10/2019 4/10/2014 248,000.00 99.99 247,976.94 0.11% None 10 66736AAD1 248,000.00 1.50 248,000.00 1.85 214.03 -23.06 None 0.03 Parkside Finl Bank&Trust 1.3 7/18/2016 248,000.00 95.99 238,056.94 0.11% None 18 7/19/2021-17 70147ABX1 248,000.00 1.30 248,000.00 2.93 114.83 -9,943.06 None 2.51 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 96.34 238,911.30 0.11% None 906 73565NBQ5 248,000.00 1.40 248,000.00 2.93 66.59 -9,088.70 None 2.44 Texas Class LGIP 12/20/2016 3,628,394.37 100.00 3,628,394.37 1.57% None 1 TX-01-0615-0001 3,628,394.37 2.50 3,628,394.37 2.50 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 22,685,462.40 100.00 22,685,462.40 9.83% None 1 WFSWEEP 22,685,462.40 2.35 22,685,462.40 2.35 0.00 None 0 Prepared by Shamaira Jagrup 14 of 16 City of Pearland biq Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 30,559,749.71 30,522,885.30 13.26% 29 Sub Total 600:Water&Sewer 30,558,049.71 2.23 30,558,486.04 2.36 12,586.57 -35,600.74 0.1 610:Solidwaste Wets Fargo Sweep Cash 12/1/2006 -1,279,607.52 100.00 -1,279,607.52 -0.55% None 1 WFSWEEP -1,279,607.52 2.35 -1,279,607.52 2.35 0.00 None 0 -1,279,607.52 -1,279,607.52 -0.55% 1 Sub Total 610:Solidwaste -1,279,607.52 2.35 -1,279,607.52 2.35 0.00 0 700:Property Liability Ins Wells Fargo Sweep Cash 10/31/2006 207,661.39 100.00 207,661.39 0.09% None 1 WFSWEEP 207,661.39 2.35 207,661.39 2.35 0.00 None 0 207,661.39 207,661.39 0.09% 1 Sub Total 700:Property Liability Ins 207,661.39 2.35 207,661.39 2.35 0.00 0 701: Employee Benefit Fund Wells Fargo Sweep Cash 9/1/2007 93,878.69 100.00 93,878.69 0.04% None 1 WFSWEEP 93,878.69 2.35 93,878.69 2.35 0.00 None 0 93,878.69 93,878.69 0.04% 1 Sub Total 701:Employee Benefit Fund 93,878.69 2.35 93,878.69 2.35 0.00 0 702:Health Claims Fund Wells Fargo Cash 7/21/2010 529,911.06 100.00 529,911.06 0.23% None 1 WF9871 529,911.06 0.75 529,911.06 0.75 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,635,626.31 100.00 2,635,626.31 1.14% None 1 WFSWEEP 2,635,626.31 2.35 2,635,626.31 2.35 0.00 None 0 3,165,537.37 3,165,537.37 1.37% 1 Sub Total 702:Health Claims Fund 3,165,537.37 2.08 3,165,537.37 2.08 0.00 0 703:Motor Pool Fund Wells Fargo Sweep Cash 10/15/2018 1,626,672.04 100.00 1,626,672.04 0.71% None 1 WFSWEEP 1,626,672.04 2.35 1,626,672.04 2.35 0.00 None 0 1,626,672.04 1,626,672.04 0.71% 1 Sub Total 703:Motor Pool Fund 1,626,672.04 2.35 1,626,672.04 2.35 0.00 0 Prepared by Shamaira Jagrup 15 of 16 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 12/31/2018 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 230,741,420.04 230,265,382.29 100.00% 54 TOTAL PORTFOLIO 230,724,667.04 2.27 230,725,451.01 2.43 115,040.14 -460,068.72 0.2 Prepared by Shamaira Jagrup 16 of 16 City of Pearland 09 Treasury Yield Curve Treasury 9/30/2018 12/31/2018 1 Month 2.04 2.37 3 Month 2.17 2.41 6 Month 2.34 2.54 1 Year 2.56 2.66 2 Year 2.77 2.68 3 Year 2.84 2.67 5 Year 2.89 2.68 10 Year 3.00 2.83 3.00 - 2.50 - 2.00 1.50 - •9/30/2018 •12/31/2018 1.00 - 0.50 - 0.00 - I i 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year Prepared by Shamaira Jagrup 1 of 1 Pledged Collateral Reconciliation Report December 31, 2018 Bank Account Number Account Name Amount Wells Fargo 8071613395 Credit Card Account - Wells Fargo 13042841 Sweep Account 90,747.00 Wells Fargo 7169195455 False Alarm Reduction Program 285,170.91 Wells Fargo 8184567843 Alvin ISD 6,649,114.99 Wells Fargo 1790121790 EMS Payments - Wells Fargo 2807409871 Health Claims 529,911.06 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 $ 7,554,943.96 Pledged Collateral for City 36,061,632.32 FDIC Insurance 500,000.00 $ 36,561,632.32 Over(Under)Collateralized $ 29,006,688.36 Total%Collateralized 483.9% Bank Account Number Account Name Amount Wells Fargo 1007284258 Development Authority 1,009,387.93 Total of Bank Balances $ 1,009,387.93 Pledged Collateral for DAP 817,757.53 FDIC Insurance 250,000.00 $ 1,067,757.53 Over(Under)Collateralized $ 58,369.60 Total%Collateralized 105.8% Total%Collateralized 439.4% Status Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral.