Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2018-248 2018-12-17
RESOLUTION NO. R2018-248 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending September 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 September 2018. PASSED, APPROVED, AND ADOPTED this 17th day of December, A.D., 2018. ��• /CJ/"i 6' r--C.-e9 TOM REID MAYOR ATTEST: `o_tuuIii, G ETPAINRGY, liz)(/ TY SE( _ " APPROVED AS TO FORM: OaA.,--- a-4 DARRIN M. COKER CITY ATTORNEY 44, City of Pearland -Co Quarterly Investment Report MUM• • • June 30, 2018 to September 30, 2018 '-rt 0,9* This report is prepared for the City of Pearland in accordance with Chapter 2256 of the Public Funds Investment Act (PFIA). Section2256.023 (a) of the PFIA states that "Not less than quarterly, the investment officer shall prepare and submit to the governing body of the entity a written report of the investment transactions for all funds covered by this chapter for the preceding reporting period."This report is signed by the Investment Officer and includes the disclosures required in the PFIA. Month Market Value Book Value Unrealized Gain/Loss YTM @ Cost Treasury 1 Year Interest Earned Days To Maturity 7/31/2018 197,511,959.71 198,128,442.83 -616,483.12 1.86 2.39 315,094.20 122 8/31/2018 173,954,904.03 174,529,391.21 -574,487.18 1.89 2.45 313,551.17 131 9/30/2018 202,370,935.00 202,965,916.89 -594,981.89 2.00 2.56 283,238.88 106 Total/Average 191,279,266.25 191,874,583.64 -595,317.40 1.92 2.47 911,884.25 119 c " I 1, a t `1l2D I �C/r'i l n(G(AL,fal a " 1-7111:' �� Cynthia '-ars. , Director of finance Date Rhonda Daugherty, Ass` tant Director of Finance Date City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Begin Date:6/30/2018,End Date:9/30/2018 Security Type Allocation Book Value %of Portfolio Book Value %of Portfolio Security Type 6/30/2018 6/30/2018 9/30/2018 9/30/2018 Cash 89,547,474.80 44.36 66,954,257.79 32.99 Certificate Of Deposit 20,091,312.82 9.95 18,351,242.88 9.04 FAMC Bond 8,001,984.60 3.96 8,001,724.55 3.94 FFCB Bond 3,000,681.83 1.49 2,000,000.00 0.99 FHLB Bond 4,999,003.71 2.48 4,999,183.56 2.46 FHLMC Bond 6,684,668.33 3.31 6,685,932.24 3.29 FNMA Bond 3,018,257.67 1.50 3,015,522.91 1.49 Local Government Investment Pool 66,514,682.84 32.95 92,455,168.02 45.55 Compound CD 0.00 0.00 502,884.94 0.25 Total/Average 201,858,066.60 100.00 202,965,916.89 100.00 Portfolio Holdings as of 6/30/2018 Portfolio Holdings as of 9/30/2018 •44.36%-Cash •32.99%-Cash a♦9.95%-Certificate Of •9.04%-Certificate Of... •3.96%-FAMC Bond3.94%-FANG Bond • 1.49%-FFCB Bond t •0,99%-FFCB Bond •2.48%-FHLB Bond • 2.46%-FHLB Bond •3.3196-FHLMC Bond o') 3.29%-FHLMC Bond • 1.5%-FNMA Bond • 1.49%-FNMA Bond • 32.95%-Local Governm.« •45.55%-Local Governm... •0%-Compound CD • 0.25%-Compound CD Prepared by Shamaira Jagrup 1 of 1 City of Pearland k/9 Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date:6/30/2018,End Date:9/30/2018 Maturity Range Allocation Book Value %of Portfolio Book Value %of Portfolio Maturity Range 6/30/2018 6/30/2018 9/30/2018 9/30/2018 0-1 Month 156,803,157.64 77.68 160,657,422.14 79.15 1-3 Months 1,744,751.77 0.86 4,245,401.43 2.09 3-6 Months 5,493,540.05 2.72 5,737,748.91 2.83 6-9 Months 3,242,714.57 1.61 1,246,884.94 0.61 9-12 Months 5,484,000.00 2.72 8,476,764.20 4.18 1-2 Years 14,945,040.82 7.40 9,201,120.00 4.53 2-3 Years 9,972,130.36 4.94 12,400,575.27 6.11 3-4 Years 4,172,731.39 2.07 1,000,000.00 0.49 Total/Average 201,858,066.60 100.00 202,965,916.89 100.00 Portfolio Holdings 180,000 - 160,000 - 140,000 - 120,000 c i 2 100,000 - r. 'o •6/30/2018 H 80,000 - . 9/30/2018 60,000 - 4. 40,000 - 20,000 - 1 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 City of Pearland .f EAR1..AND Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date:10/31/2017,End Date:9/30/2018 Beginning BV+ Interest Earned Realized Investment Average Capital Annualized Treasury 1 Month Accrued Interest During Period-By Gain/Loss-By Income-By Base-BV TRR-BV TRR-BV Year 10/31/2017 211,870,808.02 153,094.72 0.00 153,094.72 206,202,969.31 0.07 0.89 1.40 11/30/2017 202,071,066.62 141,153.46 0.00 141,153.46 201,468,935.57 0.07 0.84 1.56 12/31/2017 200,850,298.18 144,503.09 0.00 144,503.09 206,300,830.05 0.07 0.84 1.70 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 Annualized TRR-BV 3.00 - 2.50 - 2.00 - ird I . . •Portfolio 1.50 - , .. . Treasury 1 1.00 Year 111 11 0.50 - 0.00 , , 1 10/2017 11/2017 12/2017 01/2018 02/2018 03/2018 04/2018 05/2018 06/2018 07/2018 08/2018 09/2018 Prepared by Shamaira Jagrup 1 of 1 • p,,,,, City of Pearland libEfitail Portfolio Holdings by Security Type '1r ,W4' Report Group: Pearland Date:9/30/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 105,248.10 100.00 105,248.10 0.05% None 1 WF9871 105,248.10 0.75 105,248.10 0.75 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 871,639.68 100.00 871,639.68 0.43% None 1 WFSWEEP 871,639.68 1.95 871,639.68 1.95 0.00 None 0 Wells Fargo Sweep Cash 11/15/2015 7,319.80 100.00 7,319.80 0% None 1 WFSWEEP 7,319.80 1.95 7,319.80 1.95 0.00 None 0 Wells Fargo Sweep Cash 12/31/2007 2,974,750.35 100.00 2,974,750.35 1.47% None 1 WFSWEEP 2,974,750.35 1.95 2,974,750.35 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 437,082.43 100.00 437,082.43 0.22% None 1 WFSWEEP 437,082.43 1.95 437,082.43 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 820,489.92 100.00 820,489.92 0.4% None 1 WFSWEEP 820,489.92 1.95 820,489.92 1.95 0.00 None 0 Wells Fargo Sweep Cash 10/31/2006 409,942.92 100.00 409,942.92 0.2% None 1 WFSWEEP 409,942.92 1.95 409,942.92 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 5,059.39 100.00 5,059.39 0% None 1 WFSWEEP 5,059.39 1.95 5,059.39 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 3,164.10 100.00 3,164.10 0% None 1 WFSWEEP 3,164.10 1.95 3,164.10 1.95 0.00 None 0 Wells Fargo Sweep Cash 9/1/2007 147,756.04 100.00 147,756.04 0.07% None 1 WFSWEEP 147,756.04 1.95 147,756.04 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -41,319.46 100.00 -41,319.46 -0.02% None 1 WFSWEEP -41,319.46 1.95 -41,319.46 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 129,469.61 100.00 129,469.61 0.06% None 1 WFSWEEP 129,469.61 1.95 129,469.61 1.95 0.00 None 0 Prepared by Shamaira Jagrup 1 of 14 City of Pearland aLis&Aig Portfolio Holdings by Security Type Report Group: Pearland Date:9/30/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 4/15/2012 217,484.30 100.00 217,484.30 0.11% None 1 WFSWEEP 217,484.30 1.95 217,484.30 1.95 0.00 None 0 Wells Fargo Sweep Cash 9/15/2009 28,991.23 100.00 28,991.23 0.01% None 1 WFSWEEP 28,991.23 1.95 28,991.23 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 351,568.66 100.00 351,568.66 0.17% None 1 WFSWEEP 351,568.66 1.95 351,568.66 1.95 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 455,104.91 100.00 455,104.91 0.22% None 1 WFSWEEP 455,104.91 1.95 455,104.91 1.95 0.00 None 0 Wells Fargo Sweep Cash 6/30/2006 64,189.38 100.00 64,189.38 0.03% None 1 WFSWEEP 64,189.38 1.95 64,189.38 1.95 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,932,253.62 100.00 2,932,253.62 1.44% None 1 WFSWEEP 2,932,253.62 1.95 2,932,253.62 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 242,113.40 100.00 242,113.40 0.12% None 1 WFSWEEP 242,113.40 1.95 . 242,113.40 1.95 0.00 None 0 Wells Fargo Sweep Cash 2/1/2013 24,955.09 100.00 24,955.09 0.01% None 1 WFSWEEP 24,955.09 1.95 24,955.09 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 95,249.68 100.00 95,249.68 0.05% None 1 WFSWEEP 95,249.68 1.95 95,249.68 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,374,180.99 100.00 2,374,180.99 1.17% None 1 WFSWEEP 2,374,180.99 1.95 2,374,180.99 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 27,033.93 100.00 27,033.93 0.01% None 1 WFSWEEP 27,033.93 1.95 27,033.93 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,610,972.44 100.00 2,610,972.44 1.29% None 1 WFSWEEP 2,610,972.44 1.95 2,610,972.44 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 77,785.01 100.00 77,785.01 0.04% None 1 WFSWEEP 77,785.01 1.95 77,785.01 1.95 0.00 None 0 Prepared by Shamaira Jagrup 2 of 14 City of Pearland a .0 Portfolio Holdings by Security Type Report Group: Pearland Date:9/30/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 12/1/2006 -1,267,451.82 100.00 -1,267,451.82 -0.62% None 1 WFSWEEP -1,267,451.82 1.95 -1,267,451.82 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,296,522.77 100.00 1,296,522.77 0.64% None 1 WFSWEEP 1,296,522.77 1.95 1,296,522.77 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 391,240.11 100.00 391,240.11 0.19% None 1 WFSWEEP 391,240.11 1.95 391,240.11 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 336,447.45 100.00 336,447.45 0.17% None 1 WFSWEEP 336,447.45 1.95 336,447.45 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 6,465.73 100.00 6,465.73 0% None 1 WFSWEEP 6,465.73 1.95 6,465.73 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,644,373.96 100.00 1,644,373.96 0.81% None 1 WFSWEEP 1,644,373.96 1.95 1,644,373.96 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 14,266,872.65 100.00 14,266,872.65 7.03% None 1 WFSWEEP 14,266,872.65 1.95 14,266,872.65 1.95 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 383,407.71 100.00 383,407.71 0.19% None 1 WFSWEEP 383,407.71 1.95 383,407.71 1.95 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 81,562.27 100.00 81,562.27 0.04% None 1 WF4094 81,562.27 1.95 81,562.27 1.95 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 3,904,430.06 100.00 3,904,430.06 1.92% None 1 WF4102 3,904,430.06 1.95 3,904,430.06 1.95 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 8,506,059.90 100.00 8,506,059.90 4.19% None 1 WF6624 8,506,059.90 1.95 8,506,059.90 1.95 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 10,124,745.23 100.00 10,124,745.23 4.99% None 1 WF5875 10,124,745.23 1.95 10,124,745.23 1.95 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 11,907,096.25 100.00 11,907,096.25 5.87% None 1 WF5883 11,907,096.25 1.95 11,907,096.25 1.95 0.00 None 0 Prepared by Shamaira Jagrup 3 of 14 40, City of Pearland i,�� Portfolio Holdings by Security Type Report Group: Pearland Date:9/30/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 66,954,257.79 66,954,257.79 32.97% 1 Sub Total Cash 66,954,257.79 1.94 66,954,257.79 1.94 0.00 0 Certificate Of Deposit 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 95.83 237,669.31 0.12% None 845 33625CAZ2 248,000.00 1.10 248,000.00 2.97 59.79 -10,330.69 None 2.28 1st Source Bank 1.5 11/18/2019 4/17/2015 248,000.00 99.25 246,133.06 0.12% None 414 33646CEQ3 248,000.00 1.50 248,000.00 2.18 1,691.84 -1,866.94 None 1.12 Ally Bank Midvale Utah 1.8 6/29/2020 6/29/2017 248,000.00 98.28 243,737.38 0.12% None 638 02006L3U5 248,000.00 1.80 248,000.00 2.82 1,137.40 -4,262.62 None 1.72 Alma Bank 1.35 12/24/2020 6/24/2016 248,000.00 96.54 239,420.94 0.12% None 816 020080BB2 248,000.00 1.35 248,000.00 2.95 55.04 -8,579.06 None 2.2 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 95.86 237,734.54 0.12% None 1016 02554BCM1 248,000.00 1.35 248,000.00 2.90 174.28 -10,265.46 None 2.73 Bank Leumi USA 1.3 2/26/2020 3/3/2016 248,000.00 98.86 245,176.77 0.12% None 514 063248FH6 248,000.00 1.30 248,000.00 2.13 309.15 -2,823.23 None 1.4 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 96.19 238,539.79 0.12% None 1004 063847AL1 248,000.00 1.40 248,000.00 2.84 0.00 •-9,460.21 None 2.7 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 98.73 244,856.10 0.12% None 726 06610QCV1 248,000.00 1.80 248,000.00 2.46 61.15 -3,143.90 None 1.95 Bankwest,Inc.1.5 1/3/2020 3/4/2015 248,000.00 98.61 244,541.89 0.12% None 460 06652CFA4 248,000.00 1.50 248,000.00 2.63 275.18 -3,458.11 None 1.25 Bar Harbor Bank&Trust 2.65 3/29/2021-18 3/29/2018 248,000.00 99.17 245,938.87 0.12% None 29 066851WB8 248,000.00 2.65 248,000.00 3.00 18.01 -2,061.13 None 2.42 BARCLAYS BANK DELAWARE 1.95 5/6/2014 248,000.00 99.84 247,614.86 0.12% None 219 5/7/2019 06740KGU5 248,000.00 1.95 248,000.00 2.21 1,934.40 -385.14 None 0.6 Prepared by Shamaira Jagrup 4 of 14 City of Pearland iiiiritleasji Portfolio Holdings by Security Type Report Group: Pearland Date:9/30/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 Belmont Savings Bank 1.85 10/23/2019 12/23/2014 248,000.00 99.45 246,625.34 0.12% None 388 080515BD0 248,000.00 1.85 248,000.00 2.38 1,244.42 -1,374.66 None 1.05 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 98.63 244,598.18 0.12% None 628 05580ABX1 248,000.00 2.10 248,000.00 2.92 1,469.65 -3,401.82 None 1.69 Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 95.67 237,256.64 0.12% None 1004 099703EF3 248,000.00 1.40 248,000.00 3.04 0.00 -10,743.36 None 2.7 Brickell Bank Miami FL 1.65 10/28/2019 6/27/2017 248,000.00 99.04 245,620.19 0.12% None 393 _ 10801DAG6 248,000.00 1.65 248,000.00 2.55 22.42 -2,379.81 None 1.07 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 96.76 239,952.40 0.12% None 997 12325EHU9 248,000.00 1.80 248,000.00 3.04 85.61 -8,047.60 None 2.66 Capital Bank Little Rock 1.35 3/22/2019 9/23/2015 248,000.00 99.86 247,644.62 0.12% None 173 139797FL3 248,000.00 1.35 248,000.00 1.65 73.38 -355.38 None 0.48 Capital One Bank USA 1.1 11/19/2019 11/19/2014 248,000.00 99.46 246,655.59 0.12% None 415 140420QX1 248,000.00 1.10 248,000.00 1.58 1,001.51 -1,344.41 None 1.13 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 98.77 244,951.58 0.12% None 726 14042RAB7 248,000.00 2.30 248,000.00 2.94 78.14 -3,048.42 None 1.95 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 97.29 241,273.74 0.12% None 666 144153AW3 248,000.00 1.10 248,000.00 2.62 22.42 -6,726.26 None 1.81 CDARS 0.7 12/13/2018 12/15/2016 500,000.00 100.00 500,000.00 0.25% None 74 1019720221 500,000.00 0.70 500,000.00 0.70 2,589.04 0.00 None 0.2 Cedar Rapids Bank&Trust 1.5 10/30/2019 1/30/2015 248,000.00 99.56 246,902.10 0.12% None 395 150517CJ7 248,000.00 1.50 248,000.00 1.91 295.56 -1,097.90 None 1.07 Charter Bank 1.7 2/25/2020 2/25/2015 248,000.00 98.65 244,655.47 0.12% None 513 161164BE7 248,000.00 1.70 248,000.00 2.68 57.75 -3,344.53 None 1.39 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248,000.00 99.47 246,683.37 0.12% None 415 17284C3Z5 248,000.00 2.10 248,000.00 2.58 1,911.98 -1,316.63 None 1.12 Prepared by Shamaira Jagrup 5 of 14 a +'r c` City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date:9/30/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 Citizens State Bank Clayton 1.35 4/30/2019 9/30/2015 248,000.00 99.81 247,524.58 0.12% None 212 176688BS7 248,000.00 1.35 248,000.00 1.68 0.00 -475.42 None 0.58 Commercial Bank Ala Mich 1.5 3/29/2019 6/30/2015 248,000.00 99.65 247,142.17 0.12% None 180 201282GV6 248,000.00 1.50 248,000.00 2.20 10.19 -857.83 None 0.5 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 96.19 238,552.94 0.12% None 1004 203507BG2 248,000.00 1.50 248,000.00 2.94 0.00 -9,447.06 None 2.69 Community Bankers'Bank 1.4 6/30/2021 6/30/2016 248,000.00 96.19 238,539.79 0.12% None 1004 20361LBR4 248,000.00 1.40 248,000.00 2.84 0.00 -9,460.21 None 2.7 Discover Bank 2 2/25/2020 2/25/2015 248,000.00 99.06 245,678.72 0.12% None 513 254672JA7 248,000.00 2.00 248,000.00 2.68 489.21 -2,321.28 None 1.39 Eaglebank Bethesda 1.15 12/10/2018 3/9/2016 248,000.00 99.88 247,694.22 0.12% None 71 27002YCV6 248,000.00 1.15 248,000.00 1.79 164.09 -305.78 None 0.19 EVB Tappa Hannock VA 1.6 9/25/2019 9/25/2015 248,000.00 99.53 246,833.41 0.12% None 360 26927ABK7 248,000.00 1.60 248,000.00 2.08 54.36 -1,166.59 None 0.98 Exchange Bank NEB 1.05 1/21/2020 7/20/2016 248,000.00 97.95 242,914.76 0.12% None 478 301074CH1 248,000.00 1.05 248,000.00 2.65 71.34 -5,085.24 None 1.3 Fahey Banking 1.1 6/28/2019 3/29/2016 248,000.00 99.45 246,627.82 0.12% None 271 303117CC7 248,000.00 1.10 248,000.00 1.85 14.95 -1,372.18 None 0.74 FIRST BANK HIGHLAND PARK 1.85 5/7/2014 248,000.00 99.76 247,405.54 0.12% None 38 5/7/2019-14 319141BL0 248,000.00 1.85 248,000.00 2.25 1,835.20 -594.46 None 0.6 First Bank McComb MS 1.5 2/28/2019 6/30/2015 248,000.00 99.78 247,462.58 0.12% None 151 319234AJ9 248,000.00 1.50 248,000.00 2.03 20.38 -537.42 None 0.41 First Business Bank 1.7 6/30/2020 9/30/2015 248,000.00 98.11 243,311.31 0.12% None 639 31938QP40 248,000.00 1.70 248,000.00 2.82 0.00 -4,688.69 None 1.73 Prepared by Shamaira Jagrup 6 of 14 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date:9/30/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 Capital Bank 1.4 8/6/2019 4/6/2015 248,000.00 99.50 246,763.47 0.12% None 310 31944FBK5 248,000.00 1.40 248,000.00 1.99 228.30 -1,236.53 None 0.84 First Eagle National Bank 1.45 11/21/2018 11/21/2014 248,000.00 99.95 247,867.82 0.12% None 52 32008JAM5 248,000.00 1.45 248,000.00 1.82 1,300.47 -132.18 None 0.14 First Financial NW 1.35 10/30/2019 10/30/2015 248,000.00 98.71 244,804.52 0.12% None 395 32022MAF5 248,000.00 1.35 248,000.00 2.56 0.00 -3,195.48 None 1.08 First Intl Bank&Trust 1.6 1/16/2020 10/16/2015 248,000.00 98.68 244,725.41 0.12% None 473 32057GAE9 248,000.00 1.60 248,000.00 2.64 152.20 -3,274.59 None 1.28 First National Bank of America 1.25 7/15/2016 248,000.00 95.20 236,103.19 0.12% None 1019 7/15/2021 32110YHMO 248,000.00 1.25 248,000.00 3.06 653.97 -11,896.81 None 2.74 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 96.19 238,552.94 0.12% None 1004 36198JCC6 248,000.00 1.50 248,000.00 2.94 0.00 -9,447.06 None 2.69 Goldman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 99.06 245,678.72 0.12% None 513 38148JLL3 248,000.00 2.00 248,000.00 2.68 489.21 -2,321.28 None 1.39 Gulf Coast Bank&Trust 1.3 7/15/2021-17 7/15/2016 248,000.00 95.87 237,754.87 0.12% None 15 402194EX8 248,000.00 1.30 248,000.00 2.84 132.49 -10,245.13 None 2.74 JP Morgan Chase Bk NA Columbus 2.1 2/15/2017 245,000.00 97.99 240,083.83 0.12% None 15 2/15/2021-17 48126XVW2 245,000.00 2.10 245,000.00 2.98 211.44 -4,916.17 None 2.32 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 96.19 238,539.79 0.12% None 1004 53362LAB0 248,000.00 1.40 248,000.00 2.84 275.86 -9,460.21 None 2.69 Machias Savings Bank 1.65 2/6/2020 2/6/2015 248,000.00 99.38 246,454.96 0.12% None 494 554479DS1 248,000.00 1.65 248,000.00 2.12 269.06 -1,545.04 None 1.33 Mahopac Bank 1.45 7/30/2019 1/30/2015 248,000.00 99.74 247,351.23 0.12% None 303 560160AQ6 248,000.00 1.45 248,000.00 1.77 610.83 -648.77 None 0.83 Prepared by Shamaira Jagrup 7 of 14 °` _ City of Pearland of a4 r v o liKa00141 Portfolio Holdings by Security Type Report Group: Pearland Date:9/30/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.86 240,213.79 0.12% None 1003 56817TAB7 248,000.00 1.80 248,000.00 2.99 12.23 -7,786.21 None 2.68 Marlin Business Bank 1.25 12/27/2019 6/29/2016 248,000.00 98.37 243,947.18 0.12% None 453 57116AMC9 248,000.00 1.25 248,000.00 2.59 8.49 -4,052.82 None 1.23 MB Financial Bank 1.1 3/18/2019 3/18/2016 248,000.00 99.67 247,188.30 0.12% None 169 55266CQU3 248,000.00 1.10 248,000.00 1.80 89.69 -811.70 None 0.47 Moody National Bank 0.5 11/30/2018 5/31/2018 249,242.88 100.00 249,242.88 0.12% None 61 7130H 249,242.88 0.50 249,242.88 0.50 416.54 0.00 None 0.17 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 99.52 246,811.83 0.12% None 918 61747MS69 248,000.00 2.80 248,000.00 3.00 3,386.39 -1,188.17 None 2.41 National Bank Commerce Superior 1.25 7/15/2016 248,000.00 95.87 237,750.90 0.12% None 15 7/15/2021-17 633368EB7 248,000.00 1.25 248,000.00 2.79 127.40 -10,249.10 None 2.74 Northern Bank&Trust MA 1.1 7/12/2019-17 7/12/2016 248,000.00 99.10 245,771.97 0.12% None 12 66476QBH0 248,000.00 1.10 248,000.00 2.26 597.92 -2,228.03 None 0.78 Northwest Bank Boise Idaho 1.5 1/10/2019 4/10/2014 248,000.00 99.94 247,853.43 0.12% None 102 66736AAD1 248,000.00 1.50 248,000.00 1.71 203.84 -146.57 None 0.28 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 97.52 241,839.68 0.12% None 639 69413CFD6 248,000.00 1.25 248,000.00 2.71 0.00 -6,160.32 None 1.73 Parkside Finl Bank&Trust 1.3 7/19/2021-17 7/18/2016 248,000.00 95.85 237,702.79 0.12% None 18 70147ABX1 248,000.00 1.30 248,000.00 2.84 105.99 -10,297.21 None 2.75 Partners Bank 1.5 9/30/2019 3/30/2015 248,000.00 99.43 246,596.57 0.12% None 365 70212YAR3 248,000.00 1.50 248,000.00 2.07 0.00 -1,403.43 None 0.99 Pearland State Bank 0.9 7/24/2019 7/24/2018 245,000.00 100.00 245,000.00 0.12% None 297 700013947C 245,000.00 0.90 245,000.00 0.90 410.79 0.00 None 0.81 Prepared by Shamaira Jagrup 8 of 14 .' "' , City of Pearland A -, Portfolio Holdings by Security Type Report Group: Pearland Date:9/30/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 Peoples United Bank 1.9 11/19/2019 11/19/2014 248,000.00 99.45 246,626.33 0.12% None 415 71270QKM7 248,000.00 1.90 248,000.00 2.40 1,729.88 -1,373.67 None 1.12 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 96.22 238,613.45 0.12% None 998 73565NBQ5 248,000.00 1.40 248,000.00 2.84 57.07 -9,386.55 None 2.68 Quantum National Bank 1.2 9/18/2019-16 3/18/2016 248,000.00 98.83 245,106.09 0.12% None 79 74765JETI 248,000.00 1.20 248,000.00 2.42 97.84 -2,893.91 None 0.96 Sallie Mae Bank 2.15 11/19/2019 11/19/2014 248,000.00 99.46 246,656.09 0.12% None 415 795450VC6 248,000.00 2.15 248,000.00 2.64 1,957.50 -1,343.91 None 1.12 Signature Bank 1.35 3/28/2019 • 9/29/2015 248,000.00 99.84 247,613.37 0.12% None 179 82669LFU2 248,000.00 1.35 248,000.00 1.67 18.35 -386.63 None 0.49 Summit Community Bank Moorefield WV 6/30/2017 248,000.00 99.43 246,598.55 0.12% None 271 1.55 6/28/2019 86604XLX2 248,000.00 1.55 248,000.00 2.32 21.06 -1,401.45 None 0.74 Umpqua Bank Roseburg OR 1.6 6/28/2019 6/30/2017 248,000.00 99.47 246,679.40 0.12% None 271 90421MAX1 248,000.00 1.60 248,000.00 2.33 1,000.15 -1,320.60 None 0.74 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 98.63 244,606.86 0.12% None 761 91330ABC0 248,000.00 1.65 248,000.00 2.32 0.00 -3,393.14 None 2.05 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 95.87 237,762.81 0.12% None 1016 92834CBW1 248,000.00 1.30 248,000.00 2.85 715.46 -10,237.19 None 2.73 Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 96.85 240,185.27 0.12% None 913 938828AC4 248,000.00 1.50 248,000.00 2.81 0.00 -7,814.73 None 2.45 Webster Bank NA 1.9 2/12/2019 2/12/2014 248,000.00 99.90 247,763.41 0.12% None 135 94768NJM7 248,000.00 1.90 248,000.00 2.16 632.57 -236.59 None 0.37 Welch State Bank 1.3 10/1/2018 9/30/2015 248,000.00 100.00 247,995.54 0.12% None 1 949095AU7 248,000.00 1.30 248,000.00 1.95 256.15 -4.46 None 0 Prepared by Shamaira Jagrup 9 of 14 City of Pearland Pearland ab..&6112 Portfolio Holdings by Security Type Report Group: Pearland Date:9/30/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 Bank 1.75 6/17/2021 6/20/2016 248,000.00 96.27 238,744.14 0.12% None 991 9497485W3 248,000.00 1.75 248,000.00 3.19 154.58 -9,255.86 None 2.65 18,351,242.88 18,063,421.95 8.89% 467 Sub Total Certificate Of Deposit 18,351,242.88 1.51 18,351,242.88 2.38 33,551.56 -287,820.93 1.46 Compound CD CDARS 1.05 6/15/2019 6/15/2017 502,884.94 100.00 502,884.94 0.25% None 258 CDARS061517 502,884.94 1.05 502,884.94 1.05 3,949.37 0.00 None 0.7 502,884.94 502,884.94 0.25% 258 Sub Total Compound CD 502,884.94 1.05 502,884.94 1.05 3,949.37 0.00 0.7 FAMC Bond FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 99.06 990,552.00 0.49% S&P-AA+ 326 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.57 1,583.33 -9.448.00 Moodys-Aaa 0.89 FAMC 1.5 8/22/2019 2/22/2017 2,001,700.00 99.06 1,981,104.00 0.99% S&P-AA+ 326 3132X0PV7 2,000,000.00 1.47 2,000,608.22 2.57 3,166.67 -19,504.22 Moodys-Aaa 0.89 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 99.06 990,552.00 0.49% S&P-AA+ 326 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.57 1,583.33 -9,448.00 Moodys-Aaa 0.89 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 98.69 986,901.00 0.49% Moodys-Aaa 512 3132X0PW5 1,000,000.00 1.63 1,000,560.00 2.63 1,675.00 -13,659.00 S&P-AA+ 1.39 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 98.69 986,901.00 0.49% Moodys-Aaa 512 3132X0PW5 1,000,000.00 1.63 1,000,560.00 2.63 1,675.00 -13,659.00 S&P-M+ 1.39 FAMC 1.72 10/3/2018 12/16/2013 997,890.00 100.00 999,985.00 0.49% Moodys-Aaa 3 31315P5A3 1,000,000.00 1.77 999,996.33 1.88 8,456.67 -11.33 S&P-AA+ 0.01 FAMC 1.82 11/9/2020 11/9/2017 1,000,000.00 98.08 980,834.00 0.49% Moodys-Aaa 771 3132XOZC8 1,000,000.00 1.82 1,000,000.00 2.76 7,128.33 -19,166.00 S&P-AA+ 2.06 8,001,990.00 7,916,829.00 3.93% 388 Sub Total FAMC Bond 8,000,000.00 1.60 8,001.724.55 2.53 25,268.33 -84,895.55 1.05 FFCB Bond Prepared by Shamaira Jagrup 10 of 14 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date:9/30/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 FFCB 1.5 1/28/2019 5/28/2014 1,000,000.00 99.71 997,105.00 0.49% Moodys-Aaa 120 3133EDMF6 1,000,000.00 1.50 1,000,000.00 2.38 2,583.33 -2,895.00 S&P-AA+ 0.33 FFCB 1.84 10/30/2020-18 10/30/2017 1,000,000.00 97.97 979,712.00 0.49% Moodys-Aaa 30 3133EHM26 1,000,000.00 1.84 1,000,000.00 2.85 7,666.67 -20.288.00 S&P-AA+ 2.04 2,000,000.00 1,976,817.00 0.98% 75 Sub Total FFCB Bond 2,000,000.00 1.67 2,000,000.00 2.62 10,250.00 -23,183.00 1.18 FHLB Bond FHLB 1 9/26/2019 9/22/2016 997,430.00 98.38 983,800.00 0.49% Moodys-Aaa 361 3130A9EP2 1,000,000.00 1.09 999,155.98 2.67 111.11 -15,355.98 S&P-AA+ 0.99 FHLB 1.45 6/28/2019-17 6/28/2017 1,000,000.00 99.18 991,804.00 0.49% Moodys-Aaa 89 3130ABHRO 1,000.000.00 1.45 1,000,000.00 2.57 3,705.56 -8,196.00 S&P-AA+ 0.74 FHLB 1.75 12/14/2018 12/16/2013 1,000,670.00 99.90 999,034.00 0.49% Moodys-Aaa 75 313376BR5 1,000,000.00 1.74 1,000,027.58 2.21 5,152.78 -993.58 S&P-AA+ 0.21 FHLB 2.21/29/2021-19 1/29/2018 1,000,000.00 98.08 980,811.00 0.49% Moodys-Aaa 121 3130ADC26 1,000,000.00 2.20 1,000,000.00 3.06 3,727.78 -19,189.00 S&P-AA+ 2.28 FHLB 2.4 3/27/2020-18 3/27/2018 1,000,000.00 99.23 992,259.00 0.49% S&P-AA+ 88 3130ADSH6 1,000,000.00 2.40 1,000,000.00 2.93 200.00 -7,741.00 Moodys-Aaa 1.47 4,998,100.00 4,947,708.00 2.45% 147 Sub Total FHLB Bond 5,000,000.00 1.77 4,999,183.56 2.69 12,897.23 -51,475.56 1.14 FHLMC Bond FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 95.17 951,650.00 0.49% Moodys-Aaa 1047 3137EAEC9 1,000,000.00 1.37 993,280.27 2.90 1,343.75 -41,630.27 S&P-AA+ 2.82 FHLMC 1.35 12/17/2018-15 6/19/2015 999,525.00 99.81 998,089.00 0.49% S&P-AA+ 78 3134G6S95 1,000,000.00 1.36 999,970.93 2.24 3,862.50 -1,881.93 Moodys-Aaa 0.21 FHLMC 1.42 3/29/2019-17 3/29/2017 2,000,000.00 99.51 1,990,216.00 0.99% S&P-AA+ 180 3134GA6G4 2,000,000.00 1.42 2,000,000.00 2.42 78.89 -9,784.00 Moodys-Aaa 0.5 Prepared by Shamaira Jagrup 11 of 14 °` 04:44110 City of Pearland Portfolio Holdings by Security Type `sr, ,0, Report Group: Pearland Date:9/30/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 FHLMC 2 11/20/2020-18 12/5/2017 1,000,000.00 98.25 982,530.00 0.49% Moodys-Aaa 51 3134GBW32 1,000,000.00 2.00 1,000,000.00 2.85 7,222.22 -17,470.00 S&P-AA+ 2.09 FHLMC 2.2 12/8/2021-18 12/8/2017 1,000,000.00 97.40 973,975.00 0.49% Moodys-Aaa 69 3134GB4N9 1,000,000.00 2.20 1,000,000.00 3.06 6,844.44 -26,025.00 S&P-AA+ 3.07 FHLMC Step 8/3/2021-18 3/9/2018 691,243.00 97.70 683,885.30 0.34% S&P-AA+ 34 3134GBA93 700,000.00 2.61 692,681.04 3.16 2,216.67 -8,795.74 Moodys-Aaa 2.76 6,679,308.00 6,580,345.30 3.29% 243 Sub Total FHLMC Bond 6,700,000.00 1.73 6,685,932.24 2.70 21,568.47 -105,586.94 1.66 FNMA Bond FNMA 1.375 3/13/2019-16 9/22/2016 1,009,560.00 99.57 995,731.00 0.49% Moodys-Aaa 164 3136G1FY0 1,000,000.00 0.98 1,001,748.91 2.33 649.31 -6,017.91 S&P-AA+ 0.45 FNMA 1.625 11/27/2018 7/16/2014 1,004,411.00 99.91 999,057.00 0.49% Moodys-Aaa 58 3135G0YT4 1,000,000.00 1.52 1,000,160.04 2.21 5,552.08 -1,103.04 S&P-AA+ 0.16 . FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 97.87 978,715.00 0.5% Moodys-Aaa 820 3135G0H55 1,000,000.00 1.25 1,013,613.96 2.86 4,791.67 -34,898.96 S&P-AA+ 2.2 3,039,851.00 2,973,503.00 1.48% 349 Sub Total FNMA Bond 3,000,000.00 1.25 3,015,522.91 2.47 10,993.06 -42,019.91 0.94 Local Government Investment Pool Texas Class LGIP 5/15/2017 19,957.06 100.00 19,957.06 0.01% None 1 TX-01-0615-0001 19,957.06 2.26 19,957.06 2.26 0.00 None 0 Texas Class LGIP 5/15/2017 3,072,166.48 100.00 3,072,166.48 1.51% None 1 TX-01-0615-0001 3,072,166.48 2.26 3,072,166.48 2.26 0.00 None 0 Texas Class LGIP 12/20/2016 3,604,980.23 100.00 3,604,980.23 1.78% None 1 TX-01-0615-0001 3,604,980.23 2.26 3,604,980.23 2.26 0.00 None 0 Texas Class LGIP 9/15/2018 7,542,977.75 100.00 7,542,977.75 3.72% None 1 TX-01-0615-0006 7,542,977.75 2.26 7,542,977.75 2.26 0.00 None 0 Prepared by Shamaira Jagrup 12 of 14 t 4 a4 City of Pearland iiiitalia Portfolio Holdings by Security Type r'' ,0% Report Group: Pearland Date:9/30/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 1/15/2017 4,899,270.29 100.00 4,899,270.29 2.41% None 1 TX-01-0615-0001 4,899,270.29 2.26 4,899,270.29 2.26 0.00 None 0 Texas Class LGIP 1/15/2017 1,026,970.66 100.00 1,026,970.66 0.51% None 1 TX-01-0615-0001 1,026,970.66 2.26 1,026,970.66 2.26 0.00 None 0 Texas Class LGIP 9/15/2018 5,107,258.24 100.00 5,107,258.24 2.52% None 1 TX-01-0615-0004 5,107,258.24 2.26 5,107,258.24 2.26 0.00 None 0 Texas Class LGIP 9/15/2018 7,923,380.08 100.00 7,923,380.08 3.9% None 1 TX-01-0615-0005 7,923,380.08 2.26 7,923,380.08 2.26 0.00 None 0 Texas Class LGIP 12/20/2016 10,318,407.05 100.00 10,318,407.05 5.08% None 1 TX-01-0615-0001 10,318,407.05 2.26 10,318,407.05 2.26 0.00 None 0 Texas Class LGIP 9/15/2018 15,809,864.51 100.00 15,809,864.51 7.79% None 1 TX-01-0615-0004 15,809,864.51 2.26 15,809,864.51 2.26 0.00 None 0 Texas Class LGIP 12/20/2016 23,232,881.31 100.00 23,232,881.31 11.45% None 1 TX-01-0615-0001 23,232,881.31 2.26 23,232,881.31 2.26 0.00 None 0 Texas Class LGIP 5/15/2017 512,027.75 100.00 512,027.75 0.25% None 1 TX-01-0615-0001 512,027.75 2.26 512,027.75 2.26 0.00 None 0 Texas Class LGIP 1/15/2017 1,026,970.66 100.00 1,026,970.66 0.51% None 1 TX-01-0615-0001 1,026,970.66 2.26 1,026,970.66 2.26 0.00 None 0 Texas Class LGIP 12/20/2016 3,629,979.42 100.00 3,629,979.42 1.79% None 1 TX-01-0615-0001 3,629,979.42 2.26 3,629,979.42 2.26 0.00 None 0 TexSTAR LGIP 8/26/2016 3,116,539.21 100.00 3,116,539.21 1.54% S&P-AAA . 1 02000-11110 3,116,539.21 2.00 3,116,539.21 2.00 0.00 None 0 TexSTAR LGIP 8/26/2016 1,611,537.32 100.00 1,611,537.32 0.79% S&P-AAA 1 02000-11110 1,611,537.32 2.00 1,611,537.32 2.00 0.00 None 0 92,455,168.02 92,455,168.02 45.56% 1 Sub Total Local Government Investment 92,455,168.02 2.25 92,455,168.02 2.25 0.00 0 Pool Prepared by Shamaira Jagrup 13 of 14 °'1 1 P rF',.,0 City of Pearland iipialitAki Portfolio Holdings by Security Type `,, ,' ' Report Group: Pearland Date:9/30/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 202,982,802.63 202,370,935.00 100.00% 76 TOTAL PORTFOLIO 202,963,553.63 2.00 202,965,916.89 2.20 118,478.02 -594,981.89 0.28 Prepared by Shamaira Jagrup 14 of 14 , City of Pearland 'o livaiRWttig Portfolio Holdings by Portfolio Name 'f, ,,,, Report Group: Pearland Date:9/30/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.54 239,420.94 0.12% None 816 020080BB2 248,000.00 1.35 248,000.00 2.95 55.04 -8,579.06 None 2.2 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 95.86 237,734.54 0.12% None 1016 02554BCM1 248,000.00 1.35 248,000.00 2.90 174.28 -10,265.46 None 2.73 Bank Leumi USA 1.3 2/26/2020 3/3/2016 248,000.00 98.86 245,176.77 0.12% None 514 063248FH6 248,000.00 1.30 248,000.00 2.13 309.15 -2,823.23 None 1.4 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 98.73 244,856.10 0.12% None 726 06610QCV1 248,000.00 1.80 248,000.00 2.46 61.15 -3,143.90 None 1.95 Bar Harbor Bank&Trust 2.65 3/29/2021-18 3/29/2018 248,000.00 99.17 245,938.87 0.12% None 29 066851WB8 248,000.00 2.65 248,000.00 3.00 18.01 -2,061.13 None 2.42 Belmont Savings Bank 1.85 10/23/2019 12/23/2014 248,000.00 99.45 246,625.34 0.12% None 388 080515BD0 248,000.00 1.85 248,000.00 2.38 1,244.42 -1,374.66 None 1.05 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 98.77 244,951.58 0.12% None 726 14042RAB7 248,000.00 2.30 248,000.00 2.94 78.14 -3,048.42 None 1.95 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 97.29 241,273.74 0.12% None 666 144153AW3 248,000.00 1.10 248,000.00 2.62 22.42 -6,726.26 None 1.81 CDARS 0.7 12/13/2018 12/15/2016 500,000.00 100.00 500,000.00 0.25% None 74 1019720221 500,000.00 0.70 500,000.00 0.70 2,589.04 0.00 None 0.2 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248,000.00 99.47 246,683.37 0.12% None• 415 17284C3Z5 248,000.00 2.10 248,000.00 2.58 1,911.98 -1,316.63 None 1.12 Commercial Bank Ala Mich 1.5 3/29/2019 6/30/2015 248,000.00 99.65 247,142.17 0.12% None 180 201282GV6 248,000.00 1.50 248,000.00 2.20 10.19 -857.83 None 0.5 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 96.19 238,552.94 0.12% None 1004 203507BG2 248,000.00 1.50 248,000.00 2.94 0.00 -9,447.06 None 2.69 Prepared by Shamaira Jagrup 1 of 16 City of Pearland ��:E Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/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 Community Bankers'Bank 1.4 6/30/2021 6/30/2016 248,000.00 96.19 238,539.79 0.12% None 1004 20361LBR4 248,000.00 1.40 248,000.00 2.84 0.00 -9,460.21 None 2.7 Exchange Bank NEB 1.05 1/21/2020 7/20/2016 248,000.00 97.95 242,914.76 0.12% None 478 301074CH1 248,000.00 1.05 248,000.00 2.65 71.34 -5,085.24 None 1.3 Fahey Banking 1.1 6/28/2019 3/29/2016 248,000.00 99.45 246,627.82 0.12% None 271 303117CC7 248,000.00 1.10 248,000.00 1.85 14.95 -1,372.18 None 0.74 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 98.69 986,901.00 0.49% Moodys-Aaa 512 3132X0PW5 1,000,000.00 1.63 1,000,560.00 2.63 1,675.00 -13,659.00 S&P-AA+ 1.39 FHLB 1.45 6/28/2019-17 6/28/2017 1,000,000.00 99.18 991,804.00 0.49% Moodys-Aaa 89 3130ABHRO 1,000,000.00 1.45 1,000,000.00 2.57 3,705.56 -8,196.00 S&P-AA+ 0.74 FHLB 2.4 3/27/2020-18 3/27/2018 1,000,000.00 99.23 992,259.00 0.49% S&P-AA+ 88 3130ADSH6 1,000,000.00 2.40 1,000,000.00 • 2.93 200.00 -7,741.00 Moodys-Aaa 1.47 FHLMC 1.35 12/17/2018-15 6/19/2015 999,525.00 99.81 998,089.00 0.49% S&P-AA+ 78 3134G6S95 1,000,000.00 1.36 999,970.93 2.24 3,862.50 -1,881.93 Moodys-Aaa 0.21 FHLMC 1.42 3/29/2019-17 3/29/2017 2,000,000.00 99.51 1,990,216.00 0.99% S&P-AA+ 180 3134GA6G4 2,000,000.00 1.42 2,000,000.00 2.42 78.89 -9,784.00 Moodys-Aaa 0.5 FHLMC Step 8/3/2021-18 3/9/2018 691,243.00 97.70 683,885.30 0.34% S&P-AA+ 34 3134GBA93 700,000.00 2.61 692,681.04 3.16 2,216.67 -8,795.74 Moodys-Aaa 2.76 FIRST BANK HIGHLAND PARK 1.85 5/7/2014 248,000.00 99.76 247,405.54 0.12% None 38 5/7/2019-14 319141BL0 248,000.00 1.85 248,000.00 2.25 1,835.20 -594.46 None 0.6 JP Morgan Chase Bk NA Columbus 2.1 2/15/2017 245,000.00 97.99 240,083.83 0.12% None 15 2/15/2021-17 48126XVW2 245,000.00 2.10 245,000.00 2.98 211.44 -4,916.17 None 2.32 Machias Savings Bank 1.65 2/6/2020 2/6/2015 248,000.00 99.38 246,454.96 0.12% None 494 554479DS1 248,000.00 1.65 248,000.00 2.12 269.06 -1,545.04 None 1.33 Prepared by Shamaira Jagrup 2 of 16 ! �F City of Pearland tdt k g Portfolio Holdings by Portfolio Name "' Report Group: Pearland Date:9/30/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 Mahopac Bank 1.45 7/30/2019 1/30/2015 248,000.00 99.74 247,351.23 0.12% None 303 560160AQ6 248,000.00 1.45 248,000.00 1.77 610.83 -648.77 None 0.83 Moody National Bank 0.5 11/30/2018 5/31/2018 249,242.88 100.00 249,242.88 0.12% None 61 7130H 249,242.88 0.50 249,242.88 0.50 416.54 0.00 None 0.17 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 99.52 246,811.83 0.12% None 918 61747MS69 248,000.00 2.80 248,000.00 3.00 3,386.39 -1,188.17 None 2.41 Pearland State Bank 0.9 7/24/2019 7/24/2018 245,000.00 100.00 245,000.00 0.12% None 297 700013947C 245,000.00 0.90 245,000.00 0.90 410.79 0.00 None 0.81 Quantum National Bank 1.2 9/18/2019-16 3/18/2016 248,000.00 98.83 245,106.09 0.12% None 79 74765JETI 248,000.00 1.20 248,000.00 . 2.42 97.84 -2,893.91 None 0.96 Sallie Mae Bank 2.15 11/19/2019 11/19/2014 248,000.00 99.46 246,656.09 0.12% None 415 795450VC6 248,000.00 2.15 248,000.00 2.64 1,957.50 -1,343.91 None 1.12 Texas Class LGIP 5/15/2017 19,957.06 100.00 19,957.06 0.01% None 1 TX-01-0615-0001 19,957.06 2.26 19,957.06 2.26 0.00 None 0 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 98.63 244,606.86 0.12% None 761 91330ABC0 248,000.00 1.65 248,000.00 2.32 0.00 -3,393.14 None 2.05 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 95.87 237,762.81 0.12% None 1016 92834CBW1 248,000.00 1.30 248,000.00 2.85 715.46 -10,237.19 None 2.73 Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 96.85 240,185.27 0.12% None 913 938828AC4 248,000.00 1.50 248,000.00 2.81 0.00 -7,814.73 None 2.45 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 96.27 238,744.14 0.12% None 991 9497485W3 248,000.00 1.75 248,000.00 3.19 154.58 -9,255.86 None 2.65 Wells Fargo Sweep Cash 5/31/2006 820,489.92 100.00 820,489.92 0.4% None 1 WFSWEEP 820,489.92 1.95 820,489.92 1.95 0.00 None 0 14,723,657.86 14,565,451.54 7.19% 325 Sub Total 100:General Fund 14,731,689.86 1.64 14,724,901.83 2.43 28,364.36 -159,450.29 1.22 Prepared by Shamaira Jagrup 3 of 16 `.;"��ff ;r'd City of Pearland alaktaill Portfolio Holdings by Portfolio Name `,r ""' Report Group: Pearland Date:9/30/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 200: Debt Services 1st Source Bank 1.5 1''18/2019 4/17/2015 248,000.00 99.25 246,133.06 0.12% None 414 33646CEQ3 248,000.00 1.50 248,000.00 2.18 1,691.84 -1,866.94 None 1.12 Charter Bank 1.7 2/25/2020 2/25/2015 248,000.00 98.65 244,655.47 0.12% None 513 1611648E7 248,000.00 1.70 248,000.00 2.68 57.75 -3,344.53 None 1.39 Discover Bank 2 2/25/2020 2/25/2015 248,000.00 99.06 245,678.72 0.12% None 513 254672JA7 248,000.00 2.00 248,000.00 2.68 489.21 -2,321.28 None 1.39 First Capital Bank 1.4 8/6/2019 4/6/2015 248,000.00 99.50 246,763.47 0.12% None 310 31944FBK5 248,000.00 1.40 248,000.00 1.99 228.30 -1,236.53 None 0.84 Goldman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 99.06 245,678.72 0.12% None 513 38148JLL3 248,000.00 2.00 248,000.00 2.68 489.21 -2,321.28 None 1.39 Partners Bank 1.5 9/30/2019 3/30/2015 248,000.00 99.43 246,596.57 0.12% None 365 70212YAR3 248,000.00 1.50 248,000.00 2.07 0.00 -1,403.43 None 0.99 Texas Class LGIP 1/15/2017 4,899,270.29 100.00 4,899,270.29 2.41% None 1 TX-01-0615-0001 4,899,270.29 2.26 4,899,270.29 2.26 0.00 None 0 Webster Bank NA 1.9 2/12/2019 2/12/2014 248,000.00 99.90 247,763.41 0.12% None 135 94768NJM7 248,000.00 1.90 248,000.00 2.16 632.57 -236.59 None 0.37 Wells Fargo Sweep Cash 5/31/2006 391,240.11 100.00 391,240.11 0.19% None 1 WFSWEEP 391,240.11 1.95 391,240.11 1.95 0.00 None 0 7,026,510.40 7,013,779.82 3.44% 98 Sub Total 200:Debt Services 7,026,510.40 2.11 7,026,510.40 2.26 3,588.88 -12,730.58 0.26 305: Hotel/Motel Occupancy Ally Bank Midvale Utah 1.8 6/29/2020 6/29/2017 248,000.00 98.28 243,737.38 0.12% None 638 02006L3U5 248,000.00 1.80 248,000.00 2.82 1,137.40 -4,262.62 None 1.72 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 96.19 238,539.79 0.12% None 1004 063847AL1 248,000.00 1.40 248,000.00 2.84 0.00 -9,460.21 None 2.7 Prepared by Shamaira Jagrup 4 of 16 p d rs19 < City of Pearland tLit a19 Portfolio Holdings by Portfolio Name `,', ,Au° Report Group: Pearland Date:9/30/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 Capital Bank Little Rock 1.35 3/22/2019 9/23/2015 248,000.00 99.86 247,644.62 0.12% None 173 139797FL3 248,000.00 1.35 248,000.00 1.65 73.38 -355.38 None 0.48 First Intl Bank&Trust 1.6 1/16/2020 10/16/2015 248,000.00 98.68 244,725.41 0.12% None 473 32057GAE9 248,000.00 1.60 248,000.00 2.64 152.20 -3,274.59 None 1.28 Texas Class LGIP 5/15/2017 3,072,166.48 100.00 3,072,166.48 1.51% None 1 TX-01-0615-0001 3,072,166.48 2.26 3,072,166.48 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 383,407.71 100.00 383,407.71 0.19% None 1 WFSWEEP 383,407.71 1.95 383,407.71 1.95 0.00 None 0 4,447,574.19 4,430,221.39 2.18% 128 Sub Total 305:Hotel/Motel Occupancy 4,447,574.19 2.07 4,447,574.19 2.28 1,362.98 -17,352.80 0.34 310: Municipal Court Security Wells Fargo Sweep Cash 5/31/2006 27,033.93 100.00 27,033.93 0.01% None 1 WFSWEEP 27,033.93 1.95 27,033.93 1.95 0.00 None 0 27,033.93 27,033.93 0.01% 1 Sub Total 310:Municipal Court Security 27,033.93 1.95 27,033.93 1.95 0.00 0 315:City Wide Donation Wells Fargo Sweep Cash 5/31/2006 95,249.68 100.00 95,249.68 0.05% None 1 WFSWEEP 95,249.68 1.95 95,249.68 1.95 0.00 None 0 95,249.68 95,249.68 0.05% 1 Sub Total 315:City Wide Donation 95,249.68 1.95 95,249.68 1.95 0.00 0 320:Court Technology Wells Fargo Sweep Cash 5/31/2006 5,059.39 100.00 5,059.39 0% None 1 WFSWEEP 5,059.39 1.95 5,059.39 1.95 0.00 None 0 5,059.39 5,059.39 0% 1 Sub Total 320:Court Technology 5,059.39 1.95 5,059.39 1.95 0.00 0 330:Park Donations Wells Fargo Sweep Cash 5/31/2006 77,785.01 100.00 77,785.01 0.04% None 1 WFSWEEP 77,785.01 1.95 77,785.01 1.95 0.00 None 0 Prepared by Shamaira Jagrup 5 of 16 4City of Pearland like Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/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 77,785.01 77,785.01 0.04% 1 Sub Total 330:Park Donations 77,785.01 1.95 77,785.01 1.95 0.00 0 331:Tree Trust Fund Wells Fargo Sweep Cash 5/31/2006 437,082.43 100.00 437,082.43 0.22% None 1 WFSWEEP 437,082.43 1.95 437,082.43 1.95 0.00 None 0 437,082.43 437,082.43 0.22% 1 Sub Total 331:Tree Trust Fund 437,082.43 1.95 437,082.43 1.95 0.00 0 335:Police State Seizure • Wells Fargo Sweep Cash 5/31/2006 242,113.40 100.00 242,113.40 0.12% None 1 WFSWEEP 242,113.40 1.95 242,113.40 1.95 0.00 None 0 242,113.40 242,113.40 0.12% 1 Sub Total 335:Police State Seizure 242,113.40 1.95 242,113.40 1.95 0.00 0 336: Federal Police Fund Wells Fargo Sweep Cash 5/31/2006 129,469.61 100.00 129,469.61 0.06% None 1 WFSWEEP 129,469.61 1.95 129,469.61 1.95 0.00 None 0 129,469.61 129,469.61 0.06% 1 Sub Total 336:Federal Police Fund 129,469.61 1.95 129,469.61 1.95 0.00 0 340:Park&Rec Development Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 95.67 237,256.64 0.12% None 1004 099703EF3 248,000.00 1.40 248,000.00 3.04 0.00 -10,743.36 None 2.7 Wells Fargo Sweep Cash 5/31/2006 871,639.68 100.00 871,639.68 0.43% None 1 WFSWEEP 871,639.68 1.95 871,639.68 1.95 0.00 None 0 1,119,639.68 1,108,896.32 0.55% 223 Sub Total 340:Park&Rec Development 1,119,639.68 1.82 1,119,639.68 2.19 0.00 -10,743.36 0.6 345:Sidewalk Fund Wells Fargo Sweep Cash 5/31/2006 6,465.73 100.00 6,465.73 0% None 1 Wi 5WE EP 6,465.73 1.95 6,465.73 1.95 0.00 None 0 6,465.73 6,465.73 0% 1 Sub Total 345:Sidewalk Fund 6,465.73 1.95 6,465.73 1.95 0.00 0 Prepared by Shamaira Jagrup 6 of 16 City of Pearland a_, Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/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 350:Grant Fund Wells Fargo Sweep Cash 5/31/2006 -41,319.46 100.00 -41,319.46 -0.02% None 1 WFSWEEP -41,319.46 1.95 -41,319.46 1.95 0.00 None 0 -41,319.46 -41,319.46 -0.02% 1 Sub Total 350:Grant Fund -41,319.46 1.95 -41,319.46 1.95 0.00 0 351: CDBG Fund Wells Fargo Sweep Cash 11/15/2015 7,319.80 100.00 7,319.80 0% None 1 WFSWEEP 7,319.80 1.95 7,319.80 1.95 0.00 None 0 7,319.80 7,319.80 0% 1 Sub Total 351:CDBG Fund 7,319.80 1.95 7,319.80 1.95 0.00 0 360:Traffic Impact Improvement Summit Community Bank Moorefield WV 6/30/2017 248,000.00 99.43 246,598.55 0.12% None 271 1.55 6/28/2019 86604XLX2 248,000.00 1.55 248,000.00 2.32 21.06 -1,401.45 None 0.74 Wells Fargo Sweep Cash 5/31/2006 351,568.66 100.00 351,568.66 0.17% None 1 WFSWEEP 351,568.66 1.95 351,568.66 1.95 0.00 None 0 599,568.66 598,167.21 0.29% 113 Sub Total 360:Traffic Impact Improvement 599,568.66 1.78 599,568.66 2.10 21.06 -1,401.45 0.31 365:Court Juvenile Mgmt Wells Fargo Sweep Cash 9/15/2009 28,991.23 100.00 28,991.23 0.01% None 1 WFSWEEP 28,991.23 1.95 28,991.23 1.95 0.00 None 0 28,991.23 28,991.23 0.01% 1 Sub Total 365:Court Juvenile Mgmt 28,991.23 1.95 28,991.23 1.95 0.00 0 370: Municipal Channel Texas Class LGIP 5/15/2017 512,027.75 100.00 512,027.75 0.25% None 1 TX-01-0615-0001 512,027.75 2.26 512,027.75 2.26 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 217,484.30 100.00 217,484.30 0.11% None 1 WFSWEEP 217,484.30 1.95 217,484.30 1.95 0.00 None 0 Prepared by Shamaira Jagrup 7 of 16 st City of Pearland IPARkaill Portfolio Holdings by Portfolio Name ''' '""' Report Group: Pearland Date:9/30/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 729,512.05 729,512.05 0.36% 1 Sub Total 370.Municipal Channel 729,512.05 2.17 729,512.05 2.17 0.00 0 380: Regional Detention Wells Fargo Sweep Cash 5/31/2006 3,164.10 100.00 3,164.10 0% None 1 WFSWEEP 3,164.10 1.95 3,164.10 1.95 0.00 None 0 3,164.10 3,164.10 0% 1 Sub Total 380:Regional Detention 3,164.10 1.95 3,164.10 1.95 0.00 0 500:Capital Projects Texas Class LGIP 1/15/2017 1,026,970.66 100.00 1,026,970.66 0.51% None 1 TX-01-0615-0001 1,026,970.66 2.26 1,026,970.66 2.26 0.00 None 0 Umpqua Bank Roseburg OR 1.6 6/28/2019 6/30/2017 248,000.00 99.47 246,679.40 0.12% None 271 90421MAX1 248,000.00 1.60 248,000.00 2.33 1,000.15 -1,320.60 None 0.74 Wells Fargo Sweep Cash 5/31/2006 2,374,180.99 100.00 2,374,180.99 1.17% None 1 WFSWEEP 2,374,180.99 1.95 2,374,180.99 1.95 0.00 None 0 3,649,151.65 3,647,831.05 1.8% 19 Sub Total 500:Capital Projects 3,649,151.65 2.01 3,649,151.65 2.06 1,000.15 -1,320.60 0.05 501:Certificates of Obligation 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 95.83 237,669.31 0.12% None 845 33625CAZ2 248,000.00 1.10 248,000.00 2.97 59.79 -10,330.69 None 2.28 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 99.06 990,552.00 0.49% S&P-AA+ 326 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.57 1,583.33 -9,448.00 Moodys-Aaa 0.89 FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 95.17 951,650.00 0.49% Moodys-Aaa 1047 3137EAEC9 1,000,000.00 1.37 993,280.27 2.90 1,343.75 -41,630.27 S&P-AA+ 2.82 FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 97.87 978,715.00 0.5% Moodys-Aaa 820 3135G0H55 1,000,000.00 1.25 1,013,613.96 2.86 4,791.67 -34,898.96 S&P-AA+ 2.2 Gulf Coast Bank&Trust 1.3 7/15/2021-17 7/15/2016 248,000.00 95.87 237,754.87 0.12% None 15 402194EX8 248,000.00 1.30 248,000.00 2.84 132.49 -10,245.13 None 2.74 Prepared by Shamaira Jagrup 8 of 16 • City of Pearland IEWLAD Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/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 Marlin Business Bank 1.25 12/27/2019 6/29/2016 248,000.00 98.37 243,947.18 0.12% None 453 57116AMC9 248,000.00 1.25 248,000.00 2.59 8.49 -4,052.82 None 1.23 Texas Class LGIP 9/15/2018 7,542,977.75 100.00 7,542,977.75 3.72% None 1 TX-01-0615-0006 7,542,977.75 2.26 7,542,977.75 2.26 0.00 None 0 Texas Class LGIP 12/20/2016 3,629,979.42 100.00 3,629,979.42 1.79% None 1 TX-01-0615-0001 3,629,979.42 2.26 3,629,979.42 2.26 0.00 None 0 TexSTAR LGIP 8/26/2016 3,116,539.21 100.00 3,116,539.21 1.54% S&P-AAA 1 02000-11110 3,116,539.21 2.00 3,116,539.21 2.00 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,296,522.77 100.00 1,296,522.77 0.64% None 1 WFSWEEP 1,296,522.77 1.95 1,296,522.77 1.95 0.00 None 0 19,344,439.15 19,226,307.51 9.53% 131 Sub Total 501:Certificates of Obligation 19,330,019.15 2.02 19,336,913.38 2.30 7,919.52 -110,605.87 0.39 503:Certificates of Obligation 2006 Wells Fargo Sweep Cash 6/30/2006 64,189.38 100.00 64,189.38 0.03% None 1 WFSWEEP 64,189.38 1.95 64,189.38 1.95 0.00 None 0 64,189.38 64,189.38 0.03% 1 Sub Total 503:Certificates of Obligation 64,189.38 1.95 64,189.38 1.95 0.00 0 2006 506: General Obligation Brickell Bank Miami FL 1.65 10/28/2019 6/27/2017 248,000.00 99.04 245,620.19 0.12% None 393 10801DAG6 248,000.00 1.65 248,000.00 2.55 22.42 -2,379.81 None 1.07 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 96.76 239,952.40 0.12% None 997 12325EHU9 248,000.00 1.80 248,000,00 3.04 85.61 -8,047.60 None 2.66 Capital One Bank USA 1.1 11/19/2019 11/19/2014 248,000.00 99.46 246,655.59 0.12% None 415 140420QX1 248,000.00 1.10 248,000.00 1.58 1,001.51 -1,344.41 None 1.13 Citizens State Bank Clayton 1.35 4/30/2019 9/30/2015 248,000.00 99.81 247,524.58 0.12% None 212 176688BS7 248,000.00 1.35 248,000.00 1.68 0.00 -475.42 None 0.58 Prepared by Shamaira Jagrup 9 of 16 '� City of Pearland libaWhal Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/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 FFCB 1.5 1/28/2019 5/28/2014 1,000,000.00 99.71 997,105.00 0.49% Moodys-Aaa 120 3133EDMF6 1,000,000.00 1.50 1,000,000.00 2.38 2,583.33 -2,895.00 S&P-AA+ 0.33 FHLB 1 9/26/2019 9/22/2016 997,430.00 98.38 983,800.00 0.49% Moodys-Aaa 361 3130A9EP2 1,000,000.00 1.09 999,155.98 2.67 111.11 -15,355.98 S&P-AA+ 0.99 First Business Bank 1.7 6/30/2020 9/30/2015 248,000.00 98.11 243,311.31 0.12% None 639 31938QP40 248,000.00 1.70 248,000.00 2.82 0.00 -4,688.69 None 1.73 First National Bank of America 1.25 7/15/2016 248,000.00 95.20 236,103.19 0.12% None 1019 7/15/2021 32110YHM0 248,000.00 1.25 248,000.00 3.06 653.97 -11,896.81 None 2.74 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 96.19 238,539.79 0.12% None 1004 53362LAB0 248,000.00 1.40 248,000.00 2.84 275.86 -9,460.21 None 2.69 National Bank Commerce Superior 1.25 7/15/2016 248,000.00 95.87 237,750.90 0.12% None 15 7/15/2021-17 633368EB7 248,000.00 1.25 248,000.00 2.79 127.40 -10,249.10 None 2.74 Peoples United Bank 1.9 11/19/2019 11/19/2014 248,000.00 99.45 246,626.33 0.12% None 415 71270QKM7 248,000.00 1.90 248,000.00 2.40 1,729.88 -1,373.67 None 1.12 Texas Class LGIP 12/20/2016 10,318,407.05 100.00 10,318,407.05 5.08% None 1 TX-01-0615-0001 10,318,407.05 2.26 10,318,407.05 2.26 0.00 None 0 Texas Class LGIP 9/15/2018 7,923,380.08 100.00 7,923,380.08 3.9% None 1 TX-01-0615-0005 7,923,380.08 2.26 7,923,380.08 2.26 0.00 None 0 TexSTAR LGIP 8/26/2016 1,611,537.32 100.00 1,611,537.32 0.79% S&P-AAA 1 02000-11110 1,611,537.32 2.00 1,611,537.32 2.00 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 455,104.91 100.00 455,104.91 0.22% None 1 WFSWEEP 455,104.91 1.95 455,104.91 1.95 0.00 None 0 24,537,859.36 24,471,418.64 12.05% 72 Sub Total 506:General Obligation 24,540,429.36 2.09 24,539,585.34 2.28 6,591.09 -68,166.70 0.22 550:W/S Impact Fee Prepared by Shamaira Jagrup 10 of 16 City of Pearland .EL Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/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 Bankwest,Inc.1.5 1/3/2020 3/4/2015 248,000.00 98.61 244,541.89 0.12% None 460 06652CFA4 248,000.00 1.50 248,000.00 2.63 275.18 -3,458.11 None 1.25 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 98.63 244,598.18 0.12% None 628 05580ABX1 248,000.00 2.10 248,000.00 2.92 1,469.65 -3,401.82 None 1.69 Cedar Rapids Bank&Trust 1.5 10/30/2019 1/30/2015 248,000.00 99.56 246,902.10 0.12% None 395 150517CJ7 248,000.00 1.50 248,000.00 1.91 295.56 -1,097.90 None 1.07 EVB Tappa Hannock VA 1.6 9/25/2019 9/25/2015 248,000.00 99.53 246,833.41 0.12% None 360 26927ABK7 248,000.00 1.60 248,000.00 2.08 54.36 -1,166.59 None 0.98 FAMC 1.82 11/9/2020 11/9/2017 1,000,000.00 98.08 980,834.00 0.49% Moodys-Aaa 771 3132X0ZC8 1,000,000.00 1.82 1,000,000.00 2.76 7,128.33 -19,166.00 S&P-AA+ 2.06 FFCB 1.84 10/30/2020-18 10/30/2017 1,000,000.00 97.97 979,712.00 0.49% Moodys-Aaa 30 3133EHM26 1,000,000.00 1.84 1,000,000.00 2.85 7,666.67 -20,288.00 S&P-AA+ 2.04 FHLB 2.2 1/29/2021-19 1/29/2018 1,000,000.00 98.08 980,811.00 0.49% Moodys-Aaa 121 3130ADC26 1,000,000.00 2.20 1,000,000.00 3.06 3,727.78 -19,189.00 S&P-AA+ 2.28 FHLMC 2 11/20/2020-18 12/5/2017 1,000,000.00 98.25 982,530.00 0.49% Moodys-Aaa 51 3134GBW32 1,000,000.00 2.00 1,000,000.00 2.85 7,222.22 -17,470.00 S&P-AA+ 2.09 FHLMC 2.2 12/8/2021-18 12/8/2017 1,000,000.00 97.40 973,975.00 0.49% Moodys-Aaa 69 3134GB4N9 1,000,000.00 2.20 1,000,000.00 3.06 6,844.44 -26,025.00 S&P-AA+ 3.07 First Financial NW 1.35 10/30/2019 10/30/2015 248,000.00 98.71 244,804.52 0.12% None 395 32022MAF5 248,000.00 1.35 248,000.00 2.56 0.00 -3,195.48 None 1.08 FNMA 1.375 3/13/2019-16 9/22/2016 1,009,560.00 99.57 995,731.00 0.49% Moodys-Aaa 164 3136G1FY0 1,000,000.00 0.98 1,001,748.91 2.33 649.31 -6,017.91 S&P-AA+ 0.45 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 97.52 241,839.68 0.12% None 639 69413CFD6 248,000.00 1.25 248,000.00 2.71 0.00 -6,160.32 None 1.73 Texas Class LGIP 9/15/2018 5,107,258.24 100.00 5,107,258.24 2.52% None 1 TX-01-0615-0004 5,107,258.24 2.26 5,107,258.24 2.26 0.00 None 0 Prepared by Shamaira Jagrup 11 of 16 Pa, °' City of Pearland la6_4a_ Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/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 23,232,881.31 100.00 23,232,881.31 11.45% None 1 TX-01-0615-0001 23,232,881.31 2.26 23,232,881.31 2.26 0.00 None 0 Welch State Bank 1.3 10/1/2018 9/30/2015 248,000.00 100.00 247,995.54 0.12% None 1 949095AU7 248,000.00 1.30 248,000.00 1.95 256.15 -4.46 None 0 Wells Fargo Sweep Cash 5/31/2006 2,610,972.44 100.00 2,610,972.44 1.29% None 1 WFSWEEP 2,610,972.44 1.95 2,610,972.44 1.95 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 81,562.27 100.00 81,562.27 0.04% None 1 WF4094 81,562.27 1.95 81,562.27 1.95 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 11,907,096.25 100.00 11,907,096.25 5.87% None 1 WF5883 11,907,096.25 1.95 11,907,096.25 1.95 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 8,506,059.90 100.00 8,506,059.90 4.19% None 1 WF6624 8,506,059.90 1.95 8,506,059.90 1.95 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 3,904,430.06 100.00 3,904,430.06 1.92% None 1 WF4102 3,904,430.06 1.95 3,904,430.06 1.95 0.00 None 0 63,095,820.47 62,961,368.79 31.06% 31 Sub Total 550:W/S Impact Fee 63,086,260.47 2.06 63,088,009.38 2.18 35,589.65 -126,640.59 0.22 555:Shadow Creek Impact FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 98.69 986,901.00 0.49% Moodys-Aaa 512 3132X0PW5 1,000,000.00 1.63 1,000,560.00 2.63 1,675.00 -13,659.00 S&P-AA+ 1.39 Wells Fargo Sweep Cash 5/31/2006 336,447.45 100.00 336,447.45 0.17% None 1 WFSWEEP 336,447.45 1.95 336,447.45 1.95 0.00 None 0 1,337,647.45 1,323,348.45 0.66% 383 Sub Total 555:Shadow Creek Impact 1,336,447.45 1.71 1,337,007.45 2.46 1,675.00 -13,659.00 1.04 565:Revenue Bonds 1999&2003 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 99.06 990,552.00 0.49% S&P-AA+ 326 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.57 1,583.33 -9,448.00 Moodys-Aaa 0.89 Prepared by Shamaira Jagrup 12 of 16 City of Pearland ..,14 !f 0 Oak/Q.9 Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/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 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 96.19 238,552.94 0.12% None 1004 36198JCC6 248,000.00 1.50 248,000.00 2.94 0.00 -9,447.06 None 2.69 Signature Bank 1.35 3/28/2019 9/29/2015 248,000.00 99.84 247,613.37 0.12% None 179 82669LFU2 248,000.00 1.35 248,000.00 1.67 18.35 -386.63 None 0.49 Texas Class LGIP 1/15/2017 1,026,970.66 100.00 1,026,970.66 0.51% None 1 TX-01-0615-0001 1,026,970.66 2.26 1,026,970.66 2.26 0.00 None 0 Texas Class LGIP 9/15/2018 15,809,864.51 100.00 15,809,864.51 7.79% None 1 TX-01-0615-0004 15,809,864.51 2.26 15,809,864.51 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,644,373.96 100.00 1,644,373.96 0.81% None 1 WFSWEEP 1,644,373.96 1.95 1,644,373.96 1.95 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 10,124,745.23 100.00 10,124,745.23 4.99% None 1 WF5875 10,124,745.23 1.95 10,124,745.23 1.95 0.00 None 0 30,101,954.36 30,082,672.67 14.83% 22 Sub Total 565:Revenue Bonds 1999& 30,101,954.36 2.10 30,101,954.36 2.15 1,601.68 -19,281.69 0.06 2003 570:WIS Pay As You Go Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 96.86 240,213.79 0.12% None 1003 56817TAB7 248,000.00 1.80 248,000.00 2.99 12.23 -7,786.21 None 2.68 Wells Fargo Sweep Cash 12/31/2007 2,974,750.35 100.00 2,974,750.35 1.47% None 1 WFSWEEP 2,974,750.35 1.95 2,974,750.35 1.95 0.00 None 0 3,222,750.35 3,214,964.14 1.59% 78 Sub Total 570:WIS Pay As You Go 3,222,750.35 1.93 3,222,750.35 2.03 12.23 -7,786.21 0.21 575:MUD 4 Capital Programs Wells Fargo Sweep Cash 2/1/2013 24,955.09 100.00 24,955.09 0.01% None 1 WFSWEEP 24,955.09 1.95 24,955.09 1.95 0.00 None 0 24,955.09 24,955.09 0.01% 1 Sub Total 575:MUD 4 Capital Programs 24,955.09 1.95 24,955.09 1.95 0.00 0 600:Water Sr Sewer Prepared by Shamaira Jagrup 13 of 16 c' P`" City of Pearland IiiPortfolio Holdings by Portfolio Name ,'' ""' Report Group: Pearland Date:9/30/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 BARCLAYS BANK DELAWARE 1.95 5/6/2014 248,000.00 99.84 247,614.86 0.12% None 219 5/7/2019 06740KGU5 248,000.00 1.95 248,000.00 2.21 1,934.40 -385.14 None 0.6 CDARS 1.05 6/15/2019 6/15/2017 502,884.94 100.00 502,884.94 0.25% None 258 CDARS061517 502,884.94 1.05 502,884.94 1.05 3,949.37 0.00 None 0.7 Eaglebank Bethesda 1.15 12/10/2018 3/9/2016 248,000.00 99.88 247,694.22 0.12% None 71 27002YCV6 248,000.00 1.15 248,000.00 1.79 164.09 -305.78 None 0.19 FAMC 1.5 8/22/2019 2/22/2017 2,001,700.00 99.06 1,981,104.00 0.99% S&P-AA+ 326 3132X0PV7 2,000,000.00 1.47 2,000,608.22 2.57 3,166.67 -19,504.22 Moodys-Aaa 0.89 FAMC 1.72 10/3/2018 12/16/2013 997,890.00 100.00 999,985.00 0.49% Moodys-Aaa 3 31315P5A3 1,000,000.00 1.77 999,996.33 1.88 8,456.67 -11.33 S&P-AA+ 0.01 FHLB 1.75 12/14/2018 12/16/2013 1,000,670.00 99.90 999,034.00 0.49% Moodys-Aaa 75 313376BR5 1,000,000.00 1.74 1,000,027.58 2.21 5,152.78 -993.58 S&P-AA+ 0.21 First Bank McComb MS 1.5 2/28/2019 6/30/2015 248,000.00 99.78 247,462.58 0.12% None 151 319234AJ9 248,000.00 1.50 248,000.00 2.03 20.38 -537.42 None 0.41 First Eagle National Bank 1.45 11/21/2018 11/21/2014 248,000.00 99.95 247,867.82 0.12% None 52 32008JAM5 248,000.00 1.45 248,000.00 1.82 1,300.47 -132.18 None 0.14 FNMA 1.625 11/27/2018 7/16/2014 1,004,411.00 99.91 999,057.00 0.49% Moodys-Aaa 58 3135G0YT4 1,000,000.00 1.52 1,000,160.04 2.21 5,552.08 -1,103.04 S&P-AA+ 0.16 MB Financial Bank 1.1 3/18/2019 3/18/2016 248,000.00 99.67 247,188.30 0.12% None 169 55266CQU3 248,000.00 1.10 248,000.00 1.80 89.69 -811.70 None 0.47 Northern Bank&Trust MA 1.1 7/12/2019-17 7/12/2016 248,000.00 99.10 245,771.97 0.12% None 12 66476QBH0 248,000.00 1.10 248,000.00 2.26 597.92 -2,228.03 None 0.78 Northwest Bank Boise Idaho 1.5 1/10/2019 4/10/2014 248,000.00 99.94 247,853.43 0.12% None 102 66736AAD1 248,000.00 1.50 248,000.00 1.71 203.84 -146.57 None 0.28 Prepared by Shamaira Jagrup 14 of 16 � r, �' , City of Pearland ilkitRlititii Portfolio Holdings by Portfolio Name `„ Report Group: Pearland Date:9/30/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 Parkside Finl Bank&Trust 1.3 7/19/2021-17 7/18/2016 248,000.00 95.85 237,702.79 0.12% None 18 70147A8X1 248,000.00 1.30 248,000.00 2.84 105.99 -10,297.21 None 2.75 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 96.22 238,613.45 0.12% None 998 73565NBQ5 248,000.00 1.40 248,000.00 2.84 57.07 -9,386.55 None 2.68 Texas Class LGIP 12/20/2016 3,604,980.23 100.00 3,604,980.23 1.78% None 1 TX-01-0615-0001 3,604,980.23 2.26 3,604,980.23 2.26 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 14,266,872.65 100.00 14,266,872.65 7.03% None 1 WFSWEEP 14,266,872.65 1.95 14,266,872.65 1.95 0.00 None 0 25,611,408.82 25,561,687.24 12.6% 54 Sub Total 600:Water&Sewer 25,606,737.82 1.85 25,607,529.99 2.06 30,751.42 -45,842.75 0.18 610:Solidwaste Wells Fargo Sweep Cash 12/1/2006 -1,267,451.82 100.00 -1,267,451.82 -0.62% None 1 WFSWEEP -1,267.451.82 1.95 -1,267,451.82 1.95 0.00 None 0 -1,267,451.82 -1,267,451.82 -0.62% 1 Sub Total 610:Solidwaste -1,267,451.82 1.95 -1,267,451.82 1.95 0.00 0 700:Property Liability Ins Wells Fargo Sweep Cash 10/31/2006 409,942.92 100.00 409,942.92 0.2% None 1 WFSWEEP 409,942.92 1.95 409,942.92 1.95 0.00 None 0 409,942.92 409,942.92 0.2% 1 Sub Total 700:Property Liability Ins 409,942.92 1.95 409,942.92 1.95 0.00 0 701:Employee Benefit Fund Wells Fargo Sweep Cash 9/1/2007 147,756.04 100.00 147,756.04 0.07% None 1 WFSWEEP 147,756.04 1.95 147,756.04 1.95 0.00 None 0 147,756.04 147,756.04 0.07% 1 Sub Total 701:Employee Benefit Fund 147,756.04 1.95 147,756.04 1.95 0.00 0 702:Health Claims Fund Wells Fargo Cash 7/21/2010 105,248.10 100.00 105,248.10 0.05% None 1 WF9871 105,248.10 0.75 105,248.10 0.75 0.00 None 0 Prepared by Shamaira Jagrup 15 of 16 r''' City of Pearland L % Portfolio Holdings by Portfolio Name Report Group: Pearland Date:9/30/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 9/15/2010 2,932,253.62 100.00 2,932,253.62 1.44% None 1 WFSWEEP 2,932,253.62 1.95 2,932,253.62 1.95 0.00 None 0 3,037,501.72 3,037,501.72 1.49% 1 Sub Total 702:Health Claims Fund 3,037,501.72 1.90 3,037,501.72 1.90 0.00 0 202,982,802.63 202,370,935.00 100.00% 76 TOTAL PORTFOLIO 202,963,553.63 2.00 202,965,916.89 2.20 118,478.02 -594,981.89 0.28 Prepared by Shamaira Jagrup 16 of 16 City of Pearland ILEALAgi Treasury Yield Curve Treasury 6/30/2018 9/30/2018 1 Month 1.81 2.04 3 Month 1.94 2.17 6 Month 2.11 2.34 1 Year 2.33 2.56 2 Year 2.53 2.77 3 Year 2.65 2.84 5 Year 2.78 2.89 10 Year 2.92 3.00 2.50 -' 2.00 1,50 •6/30/2018 6. 9/30/2018 1.00 0.50 0.00 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year Prepared by Shamaira Jagrup 1 of 1 Pledged Collateral Reconciliation Report September 30, 2018 Bank Account Number Account Name Amount Wells Fargo 8071613395 Credit Card Account - Wells Fargo 13042841 Sweep Account 58,739.00 * Wells Fargo 7169195455 False Alarm Reduction Program 284,632.34 Wells Fargo 8184567843 Alvin ISD 6,610,567.48 Wells Fargo 1790121790 EMS Payments - Wells Fargo 2807409871 Health Claims 105,248.10 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,059,186.92 Pledged Collateral for City 16,608,004.79 FDIC Insurance 250,000.00 $ 16,858,004.79 Over(Under)Collateralized $ 9,798,817.87 Total%Collateralized 238.8% Bank Account Number Account Name Amount Wells Fargo 1007284258 Development Authority 5,478,060.20 Total of Bank Balances $ 5,478,060.20 Pledged Collateral for DAP 5,601,600.93 FDIC Insurance 250,000.00 $ 5,851,600.93 Over(Under)Collateralized $ 373,540.73 Total%Collateralized 106.8% Total%Collateralized 181.1% Status Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral.