Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2018-016 2018-01-08
RESOLUTION NO. R2018-16 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending September 2017. 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 2017. PASSED, APPROVED, AND ADOPTED this 8th day of January, A.D., 2018. ATTEST: FING, T;' C TARY APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY TOM REID MAYOR City of Pearland Quarterly Investment Report June 30, 2017 to September 30, 2017 Resolution No. R2018-16 Exhibit "A" 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 Galn/Loss YTM g Cost Treasury 1 Year Interest Earned Days To Maturity 7/31/2017 192,779.068.20 192,879,604.42 -100,536.22 0.85 1.22 138,935.57 192 8/31/2017 206.844,706.51 206.903,413.61 -58.707.10 0.82 1.23 140,616.87 172 9/30/2017 211.650.420.54 211,767.763.08 -117.342.54 0.81 1.28 135.576.25 146 Total ' Average 203.758.065.08 203.850.260.37 -92,195.29 0.83 1.24 415.128.69 169 j hia ea son Dir ctor of Finan Cynt ce (1/ Date Rick Oidrgaar, Assistant Finance Director Carrie Ditta, Accounting Supervisor Date '(lam Date City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Security Type Allocation Begin Date: 6/30/2017. End Date: 9/30/2017 Security Type Book Value 6/30/2017 66.907,441.46 24,312,981.46 7,003.024.76 3,004,377.40 2.998.284.36 6.989.756.74 6,024.429.09 76.846.282.73 194,086,578.00 Cash Certificate Of Deposit FAMC Bond FFCB Bond FHLB Bond FHLMC Bond FNMA Bond Local Government Investment Pool % of Portfolio 6/30/2017 Book Value 9/30/2017 % of Portfolio 9'30/2017 Total / Average 34.47 12.53 3.61 1.55 1.54 3.60 3.10 39.59 82.608,616 88 24,062.069.94 7,002.764.72 3.003,325.14 2,998.464 19 3.990.771.18 6.023.500.69 82.078.250.34 39.01 11.36 3.31 1.42 1.42 1.88 2.84 38.76 100.00 211,767.763.08 100.00 Portfolio Holdings as of 6/30/2017 • 34.47% -Cash 12.53%-Cerofic ate 0. ! 3.6196-FAMC Bond • 1.53%-FFC8 Bond ! 1.54% -FHLB Bond - 3.6%-FHLMC Bond ! 3.1% -FNMA Bond ! 39.59% -Local Govarnm-. Prepared by Rick Overgaard Portfolio Holdings as of 9/30/2017 • 39.01% -Cash 11.36%-Cartificate O_ • 3.31% - FAMC Bond • 1.42%-FFCB Bond 1.42% -FHLB Bond 6?' 1.88%-FHLMC Bond • 2.84% -FNMA Bond • 38.76% -Local Governm.- 1of1 Maturity Range City of Pearland Distribution by Maturity Range - Book Value Report Group: Pearland Maturity Range Allocation Begin Date: 6130/2017, End Date: 9/30/2017 Book Value % of Portfolio Book Value % of Portfolio 6/30/2017 6130/2017 9/30/2017 9/30/2017 0-1 Month 1-3 Months 3-6 Months 6-9 Months 9-12 Months 1-2 Years 2-3 Years 3-4 Years 4-5 Years 143.998,724.19 247,818.98 3.745.333.02 1,496.507.80 4,472.667.40 15,971,313.14 13.945.667.32 5,482,195.99 4.726.350.16 74.19 0 13 1.93 0.77 2.30 8.23 719 2.82 2.44 165.686,765 11 2.743.791.55 496,000 00 3,729,601.77 3,232.142 60 20.213.926.29 8.201.920.00 7,463,615 76 0.00 78.24 1.30 0.23 1.76 1.53 9.55 3.87 3.52 0.00 Total / Average 194,086,578.00 100.00 211.767,763.08 100.00 Portfolio Holdings In Thousands 180,000 160,000 140,000 120,000 100,000 80,000 60,000 40,000 20,000 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 4-5 Years • 6/30/2017 I 9/30/2017 Prepa ed by Rick Overgaard 1 of 1 City of Pearland Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date: 10/31/2016. End Date. 9/30/2017 Beginning BV + Interest Earned Realized Investment Average Capital Annualized Treasury 1 Month Accrued Interest During Period -BV Gain,Loss-BV Income -BV Base -BV TRR-BV TRR-BV Year 10'31/2016 124,252,047.18 11130/2016 125, 514 , 34 9.05 12/31/2016 185, 282.084.38 1/31/2017 209,834.304.42 2/28/2017 222.552,745.48 3131/2017 198,473,194.13 4/30/2017 210,248.062.88 5./31/2017 187.893.317.51 6/30/2017 189, 225.155.37 7/31/2017 194,196.038.32 8/31/2017 193.019.075.77 9/30/2017 214,526.996.30 53,993.04 72.654 72 62.222.89 76,360.08 83.735.69 113.663.11 127,529.01 145.230.06 128,547.54 138,935.57 140,616.87 135,576.25 0.00 0.00 0.00 0.00 0.00 000 000 0.00 0.00 0.00 0.00 0.00 53.993.04 72,654.72 62,222.89 76,360.08 83.735.69 113,663.11 127.529.01 145,230.06 128.547.54 138,935.57 140,616.87 135,576.25 124,983.617.64 185,519,756.88 196,301,906.97 216.802,198 68 208,463,708.72 204.238.039.18 198,165,289.25 188.445.0'1 54 188.225.897.02 193,382,294.06 200.526,269.84 213,508,815.92 0.04 0.04 0.03 0.04 0.04 0.06 0.06 0.08 0.07 0.07 0.07 0.06 0.52 0.47 0.38 0.42 0.48 0.67 0.77 0.93 0.82 0.87 0.84 0.76 0.66 0.74 0.87 0.83 0 82 1.0' 1.04 1.12 1.20 1.22 1.23 1.28 Annualized TRR-BV 1.40 1.20 1.00 0.80 0.60 0.40 0.20 0.00 1 10/2016 11/2016 12/2016 01/2017 11111 02/2017 1 1 1 03/2017 04/2017 05/2017 06/2017 07/2017 08/2017 09/2017 Portfolio m. Treasury 1 I Year Prepared by Rick Overgaard City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/3012017 Description CUSIP Face Amount 1 Shares Settlement Date Cost Value Market Price Market Value YTM 05p, Cost Book Value YTM L Market Accrued Interest % Portfolio Credit Rating Days To Ca!IIMaturity Unre. Gain/Loss Credit Rating Duration To Maturity Cash Wells Fargo Cash WF9871 Wells Fargo Sweep Cash WFSWEEP Wens Fargo Sweep Cash WFSWEEP 367,578.33 7;21/2010 367.578.33 0.05 367,578.33 100.00 0.05 121,289.14 367,578.33 0.17% 0.00 None None 0 9/1/2007 121,289.14 100.00 121,289.14 0.06% None 0.05 121,289.14 0.05 0.00 None 0 2/1/2013 203,968.73 100.00 203,968.73 0.1% None 1 203.968.73 0.05 203,968.73 0.05 0.00 None 0 Wells Fargo Sweep Cash 5/312006 218,616.77 100.00 218,616.77 0.1% None 1 WFSWEEP 218,616.77 0.05 218,616.77 0.05 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 5/312006 109,753.14 100.00 109,753.14 0.05% None 1 109,753.14 0.05 109,753.14 0.05 0.00 None 0 12/1/2009 -370.34 100.00 -370.34 0% None 1 -370.34 0.05 -370.34 0.05 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 12/1/2006 -308,105.60 100.00 -308,105.60 -0.15% None 1 -308,105.60 0.05 -308.105.60 0.05 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 223,062.19 100.00 223,062.19 0.11% None 1 223,062.19 0.05 223,062.19 0.05 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 5/31/2006 6,283.14 100.00 6,283.14 0% None 6,283,14 0.05 6,283.14 0.05 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 11/15/2015 -164,808.43 100.00 -164,808.43 -0.08% None -164,808.43 0.05 -164,808.43 0.05 0.00 None 5,669,051.72 5/31/2006 5.669.051.72 100.00 5.669,051.72 2.68% None 0.05 5,669,051.72 0.05 0.00 None Wells Fargo Sweep Cash WFSWEEP Prepared by Rick Overgaard 6/30/2006 63.224.73 100.00 63,224.73 0.03% None 63,224.73 0.05 63,224.73 0.05 0.00 None 1 0 0 1 0 1 of 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2017 De•.clot ion I Face Amount i Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Marks Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Welk Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Welk Fargo Sweep Cash WFSWEEP Welk Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 5,259,511.80 5/31/2006 0.05 5.259,511.80 5.259.511.80 100 00 0.05 970.56 5/31/2006 0.05 970.56 100.00 970.56 0.05 282,572.73 5/31/2006 282,572.73 0.05 282,572.73 100.00 0.05 4,142,678.99 5/31/2006 4,142,678.99 0.05 4,142,678.99 100.00 0.05 5.259.511 80 970 56 2.48% 0.00 076 0.00 N:. None 0 0 282.572 73 0.13% None 0.00 None 4,142.678 99 0 196% None 0.00 None 0 5/31/2006 117,933.72 100.00 117.933 72 0.06% None 117,933.72 0.05 117,933.72 0.05 0.00 None Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Walk Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 2,348,017.39 0 9115/2010 2,348,017.39 100.00 2,348.017.39 1.11% None 0.05 2.348.017.39 0.05 0.00 None 0 36,207.02 3,102,681.02 107,227.05 5/31/2006 36,207.02 0.05 36.207.02 100.00 0.05 36.20702 0.02% None 0.00 None 0 5/31/2006 3,102,681.02 100.00 3,102,68102 1.47% None 1 0.05 3,102.681.02 0.05 0.00 None 0 5/31/2006 107.227.05 0.05 107,227.05 100.00 107,227.05 0.05% None 1 0.05 0.00 None 0 10/31/2006 636,011, 85 100.00 636,011.85 0.3% None 1 636,011.85 0.05 636,011.85 0.05 0.00 None 0 5/31/2006 74,712.01 100.00 74,712.01 0.04% None 74,712.01 0.05 74,712.01 0.05 0.00 None 0 5/31/2006 9.172,217.85 100.00 9,172.217.85 4.33% None 9.172.217.85 0.05 9,172,217.85 0.05 0.00 Nona Wells Fargo Sweep Cash WFSWEEP Prepared by Rick Overgaard 0 4/15/2012 65.367.16 100.00 65,367.18 0.03% None 65.367.16 0.05 65.367.18 0.05 0.00 None 0 2of 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount 1 Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash M SWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WrSWEEP 478.963 30 1,557,153.76 5/31/2006 0.05 478,963.09 478.963.09 12/31/2007 0.05 1,557,153.76 1,567,153.78 887,794.63 5/31/2006 0.05 887,794.83 887,794.83 Wens Fargo Sweep Cash WFSWEEP •;C -r C 478.963;09 0 23'_ 0.00 No^r 100.00 1.557,153 76 0 74 Non,, 0.05 0.00 None 100.00 887.794 83 0.42% None 0.05 0.00 Nonr• 5/31/2006 49.577.32 100.00 49.577 32 0.02% 49,577.32 0.05 49,577.32 0.05 0.00 0 None 1 None 0 Wells Fargo Sweep Cash 5/31/2006 •1.604.255.65 100.00 -1.604,255.65 0.78% WFSWEEP -1,604.255 65 0.05 .1,604,255.65 Wells Fargo Sweep Cash WFSWEEP 144,101 98 Wens Fargo Sweep Cash WFSWEEP 0.05 0.00 None 1 None 0 5/31/2006 144.101.98 100.00 144,101.98 0.07% None 0.05 144,101.98 0.05 0.00 None 1 0 5/31/2006 261,32531 100.00 261.325.51 0.12% None 1 261,325 51 0.05 261,325.51 0.05 0.00 Nate 0 Wells Fargo Sweep Cash WFSWEEP Welts Fargo Sweep Cash WFSWEEP 9/15/2009 21.25329 100.00 21253.29 0.01% None 1 21,253.29 0.05 21,253.29 0.05 0.00 None 0 11,228,520.84 10/30/2008 11,228,520.84 100.00 11,228,520.84 5.3% None 1 0.05 11,228,520.84 0.05 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP 3,158.45 Wolk Fargo TWDB Cash WF5883 11, 765.901.95 5/31/2006 0.05 3,158.45 100.00 3,158.45 0% None 1 3.158.45 0.05 0.00 None 3/15/2017 11.765301.95 100.00 11,765,901.95 5.56% None 0.09 11,765301.95 0.09 0.00 Nore 0 Wells Fargo TWDB Cash WF5875 Wells Fargo TWDB Cash WF5875 Prepared by Rick Overgaard 10,000,000.00 9/1512017 10.000,000.00 100.00 10,000,000.00 4.72% None 0.09 10,000,000.00 0.09 0.00 None 3/15/2017 4,686.03 100.00 4386.03 0% None 4386.03 0.09 4,688.03 0.09 0.00 None 1 0 0 3 of 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo TvVDB Cash WF4094 Wells Fargo T/1:DB Cash WF4102 Sub Total Cash 10,847,599.61 11/1/2016 10,847.599.61 0.05 10,847,599.61 5,107.183.20 82,608,616.88 11/1/2016 5,107.183.20 0.05 5,107.183.20 82,608,616.88 0.06 82,608,616.88 100.00 0.05 10,847,599.61 100.00 5.107,183 20 0.05 0.06 5.12% 0.00 2.41% 0.00 82.608.616.88 39.01% 0.00 None None Nore None 0 0 0 Certificate Of Deposit IDF 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248.000.00 97.34 241,405.18 0.124' None 1210 33625CAZ2 248,000.00 1.10 248,000.00 1.93 59.79 -6.594.82 None 3.25 1st Source Bank 1.5 11/18/2019 4/17/2015 248,000.00 100.36 248,895.03 0.12% None 779 33646CE03 248,000.00 1.50 248,000.00 1.33 1.691.84 895.03 None 2.09 Ailegiance Bank 0.8 9/13/2018 9/13/2017 248.069.94 100.00 248,069 94 0.12% None 348 26115230 248,069.94 0.80 248,069.94 0.80 92.43 0.00 None 0.95 Ally Bank Midvale Utah 1.8 6/292020 6/29(2017 248,000.00 99.85 247,632.96 0.12% None 020061.3U5 248,000.00 1.80 248,000.00 1.86 1,137.40 -367.04 None 1003 2.68 Alma Bank 1.35 12/24/2020 6/24/2016 248.000.00 98.20 243,541.46 0.12% None 1181 0200801382 248,000.00 1.35 248,000.00 1.92 55.04 -4,458.54 None 3.16 American Eagle Bank IL 1.35 7/1212021 7/11/2016 248,000.00 98.31 243,811.78 0.12% None 02554BCM1 248.000.00 1.35 248,000.00 1.81 174.28 4,188.22 None 1381 3.69 Bank Leumi USA 1.3 2/26/2020 3/3/2016 248,000.00 100.18 248,440.20 063248FH6 248,000.00 1.30 248,000.00 1.23 309.15 0.12% 440.20 None None 879 2.37 Bank of New England NH 1.4 6/302021 6/30/2016 248,000.00 98.70 244,764 10 063847AL1 248,000.00 1.40 248.000.00 1.76 0.00 0.12% -3,235.90 None None 1369 3.65 Bank of the Pacific 1.25 7/30/2018 1/2912015 248,000.00 99.86 247,664.95 0.12% None 06425BBN8 248,000.00 1.25 248,000.00 1.41 526.58 -335.05 None Prepared by Rick Overgaard 303 0.83 4of15 rLAIu.ANu City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Face Amount Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM L Cost Book Value YTM Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Bank United 1.2 11/2112017 066519AF6 Bankers Bank Oklahoma 1.8 9.25/2020 066100CV1 Bankwest, Inc. 1.51/3/2020 06652CFA4 248,000.00 11,21/2014 1.20 9/2512015 248,000.00 248,000.00 248,000.00 100.03 1 06 248 067 70 1.07625 0.12% 87.70 None None 52 0.14 101.01 250,502.82 248,000.00 1.80 248,000.00 1.45 61.15 3/4/2015 248,000.00 99 44 246.600 29 248,000.00 1.50 248,000.00 1.76 275.18 BARCLAYS BANK DELAWARE 1.95 5/7/2019 06740KGU5 5/6/2014 248,000.00 100.58 249.433.69 0.12% 2,502.82 None None 1091 2.91 0.12% None 825 -1.399.71 None 2.22 0.12% None 584 248,000.00 1.95 248,000.00 1.58 1.934.40 1.433.69 None 1.57 Belmont Savings Bank 1 85 10/23/2019 080515800 12,23/2014 248,000.00 100.82 249.54529 0.12% None 753 248,00000 1.85 248.000.00 1.54 1.244.42 1,545.29 None 2.02 BMO Harris Bank 1.05 6/22/2018 6/23/2016 248.000.00 99.76 247,413.73 0.12% None 265 05581WHF5 248,000.00 1.05 248,000.00 1.38 706.29 -588.27 None 0.72 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 100.34 248.852.38 0.12% None 993 05580A8X1 248.000.00 2.10 248,000.00 1.97 1.469.65 852.38 None 2.64 Border State Bank 1 4 6/30/2021 6130/2018 248.000.00 97.98 242.983.21 0.12% None 1389 099703EF3 248,000.00 1.40 248,000.00 1.96 0.00 -5,016.79 None 3.85 Bnckell Bank Miami FL 1.65 10/28/2019 6/27/2017 248,000.00 99.88 247,663 46 0.12% None 7S8 108010AG6 248,000.00 1.65 248,000.00 1.72 22.42 -338.54 None 2.04 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 99.43 248,588.63 0.12% None 12325EHU9 248,000.00 1.80 248,000.00 1.96 85.61 -1,411.37 None Capital Bank Little Rock " 35 3/22/2019 9/23/2015 248,000.00 100.42 249,052.02 0.12% None 139797F1.3 248.000.00 135 248,000.00 1.06 73.38 1,052.02 None Capital One Bank USA 1.1 11/19/2019 140420QX1 1382 3.61 538 1.46 11/19/2014 248,000.00 100.75 249,872 15 0.12% None 248,000.00 1.10 248.000.00 0.74 1,001.51 1,872.15 None 780 2.11 Prepared by Rick Overgaard 5 of 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares ¥TM Q Cost Book Value VTM ( Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Capital One NA 2.3 9125/2020 14042RAB7 248,000.00 923 2015 2.30 248,000.00 248,000.00 101.03 1.94 Carolina Premier Bank 1.1 7/27/2020 144153AW3 7/27/2016 248,000.00 250,551 67 78.14 98.48 244.228 66 0.12% 2,551.67 Ncne Ncne 0.12% None 248,000.00 1.10 248,000.00 1.65 22.42 -3,771.34 None CDARS 0.712/13/2018 1019720221 CDARS 0.9 6/14/2018 1019145928 CDARS 1.05 6/15/2019 CDARS061517 500,000.00 1091 2.9 1031 2.78 12/15/2016 500,000.00 100.00 500,000 00 0.24% None 439 0.70 500,000.00 0.70 2,589.04 0.00 None 1.2 500,000.00 6/16/2016 500,000.00 100.00 500,000 00 0.24% None 257 0.90 500,000.00 0.90 3.328.77 0.00 None 0.7 6/15/2017 500,000.00 100.00 500,000.00 0.24% None 623 500.000.00 1.05 500,000.00 1.05 1,539.04 0.00 None 5.95 Cedar Rapids Bank & Trust 1.5 1/30/2015 248,000.00 100.87 250,160.08 0.12% None 760 10/30/2019 150517CJ7 248,000.00 1.50 248.000.00 1.08 295.56 2,160.08 None 2.05 Charter Bank 1.7 2/25/2020 2/25/2015 248,000.00 99 80 247,507.47 0.12% None 1611648E7 248,000.00 1.70 248,000.00 179 57.75 -492.53 None 878 2.36 CIt Bank Salt Lake 2.1 11/19/2019 11/19/2014 248.000.00 100.78 249,924.23 0.12% None 17284C375 248,000.00 2.10 248,000.00 1.73 1,911.98 1,924.23 None 780 2.08 Citizens State Bank Clayton 1.35 4/30/2019 9/30/2015 248,000.00 100.46 249,128.90 0.12% None 176688BS7 248,000.00 1.35 248,000.00 1.06 0.00 1,128.90 None 577 1.57 Comenity Capital Bank 1.7 5/28/2018 11/26/2014 248,000.00 100.11' 248,264.37 0.12% None 20033AJL1 248,000.00 1.70 248,000.00 1.54 46.20 264.37 None 240 0.66 Commercial Bank Ala Mich 1.5 3/29/2019 6/30/2015 248,000.00 99.85 247,620.31 0.12% None 201282GV6 248,000.00 1.50 248,000.00 1.60 10.19 -379.69 None Community Bank Pasadena 1.5 6,30/2021 203507BG2 Prepared by Rick Overgaard 545 1.48 6/30/2016 248,000.00 98.70 244,770.30 0.12% None 248,000.00 1.50 248,000.00 1.86 0.00 -3,229.70 None 1369 3.65 6 of 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2017 Description CUSIP Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Face Amount Shares YTM 8> Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Community Bankers' Bank 1.4 6/30/2021 20361LBR4 248,000.00 Community National Bank Interest 1.25 4/4/2018 20375WAM6 248,000.00 6/30/2016 1.40 4/4/2014 1.25 248,000.00 248,000.00 248,000.00 248.000.00 ConnectOne Bank 1.55 7/30/2018 20786AAM7 248,000.00 98.70 1.76 100.00 1.25 244,764 10 0.12% None 0.00 -3,235.90 None 247.997 52 0.12% None 1369 3.65 186 1.520.27 -2.48 None 0.51 1/30/2014 248,000.00 100.31 248,760.12 0.12% None 303 1.55 248,000.00 1.18 0.00 760.12 None 0.83 Continental Bank 1.25 5/25//2018 11/26/2014 248,000.00 99.96 247,890.63 0.12% None 211163EN6 248,000.00 1.25 248,000.00 1.32 1,087.12 -109.37 None Discover Bank 2 2/252020 2/25/2015 248,000.00 100.51 249,255.13 0.12% None 237 0.65 878 254672JA7 248,000.00 2.00 248,000.00 1.78 489.21 1,255.13 None 2.35 Eaglebank Bethesda 1.1512/10/2018 3/9/2016 248,000.00 99.85 247,627.01 0.12% None 436 27002YCV6 248,000.00 1.15 248,000.00 1.28 164.09 -372.99 None 1.19 EVB Tappe Hannock VA 1.6 9/25/2019 26927ABK7 9/25/2015 248,000.00 100.65 249,614.48 0.12% None 725 248,000.00 1.60 248,000.00 1.27 54.36 1,614.48 None 1.96 Evergreen Bank 1.2 629/2018 300185CY9 6/29/2015 248,000.00 99.92 247,793.17 0.12% None 272 248.000 00 1.20 248,000.00 1.31 8.15 -206.83 None 0.74 Exchange Bank NEB 1.051/21/2020 7/20/2016 248,000.00 98.38 243,989.10 301074CH1 248,000.00 1.05 248.000.00 1.77 71.34 Fahey Banking 1.1628/2019 3/29/2016 248,000.00 99.86 247,650.82 303117CC7 248,000.00 1.10 248,000.00 1.18 14.95 0.12% -4,010.90 0.12% None None None 843 2.28 636 -349.18 None 1.73 Fanners &: Merchants Bank 1.45 4/25/2014 248,000.00 99.95 247.872.28 0.12% None 25 9/25/2018.14 308862000 248,000.00 1.45 248,000.00 1.50 49.26 -127.72 None 0.98 FIRST BANK HIGHLAND PARK 1.85 5/7/2019-14 5/72014 248,000.00 100.08 248,186.50 0.12% None 38 319141810 248,000.00 1.85 248.000.00 1.80 1,835.20 186.50 None 1.58 Prepared by Rick Overgaard 7 of 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2017 De,c et ion CUSIP Face Amount / Shares Settlement Date YTM CP Cost Cost Value Market Price Market Value % Portfolio Credit Rating Days To Cal/Maturity Book Value YTM C Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity First Bank McComb MS 1.5 2/28/2019 319234AJ9 First Business Bank 1.7 6/30/2020 319380P40 First Capital Bank 1.4 8/6/2019 31944FBK5 First Eagle National Bank 1.4511/21/2018 32008JAM5 248.000.00 6/30/2015 150 248.000.00 248,000.00 9/30/2015 248,000.00 -'009 1 44 248.2'4 C2 20 38 99.59 246.970 80 248,000.00 1.70 248,000.00 1.86 0.00 0.12% 214.02 0.12% -1.029.20 None None None None 516 1A 1004 2.7 4/6/2015 248,000.00 100.25 248,627.44 0.12% None 248,000.00 1.40 248,000.00 1.26 228.30 627.44 None 675 1.83 11/21/2014 248.000.00 248,000.00 1.45 248,000.00 100.11 1.36 248,261.14 0.12% None 1,300.47 261.14 None 417 1.13 First Financial NW 1.3510'30/2019 10/30/2015 248.000.00 99.25 246.133.30 0.12% None 32022MAF5 248,000.00 1.35 248,000.00 1.72 0.00 -1,866.70 None 760 2.06 First Intl Bank &: Trust 1.6 1/16/2020 10/16/2015 248,000.00 99.64 247,097 03 0.12% None 838 32057GAE9 248.000.00 1.60 248,000.00 1.76 152.20 -902.97 None 2.25 Rrst Mid -III Bank &, Trust 0.91/-2/2018 6130/2016 248.000.00 99.94 247,840.29 0.12% 32086RBK5 248,000.00 0.90 248,000.00 1.15 0.00 -159.71 None None 94 0.26 First Nefonel Bank 1.8 3/19/2018 9/18/2013 248,000.00 10026 248,641.08 0.12% None 170 CD32115C8E7 248.000.00 1.60 248.000.00 1.05 119.58 641.08 None 0.47 Flrst National Bank of Amedos 1.25 7/15/2016 248,000.00 97.40 241,558.70 0.12% None 1384 7/15/2021 32110YHMO 248.000.00 1.25 248,000.00 1.96 653.97 -6,441.30 None 3.7 GNB Bank 1.56/3012021 36198JCC6 6/30/2016 248,000.00 98.70 244.770.30 0.12% None 1369 248,000.00 1.50 248,000.00 1.86 0.00 -3.229.70 None 3.65 Goldman Sachs Bank 2 2/25/2020 2/252015 248,000.00 38148JLL3 248,000.00 2.00 248.000.00 100.51 1.78 249.255.13 489.21 GUARANTY B8amp;T 1.35 5/29/2018 5/29/2014 248,000.00 100.02 248,046.87 4008208J4 248,000.00 1.35 248,000.00 1.32 9.17 Prepared by Rick Overgaard 0.12% 1,255.13 0.12% 46.87 None None None None 878 2.35 241 0.66 80,15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount 1 Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM op Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Gulf Coast Bank & Trust 1.3 7;152021- 17 402194EX8 JP Morgan Chase Bk NA Columbus 2.1 2/15/2021-17 48126XVW2 7/15/2016 248.000.00 98.34 243.885.43 248,000 00 1.30 248,000.00 1.75 132.49 2/15/2017 245,000.00 100.35 245,000.00 2.10 245.000.00 1.99 211.44 864.60 None 0.12% None -4.114.57 None 245.864.60 0.12% None Lincoln 1st Bank 1.4 6/30/2021 53362LAB0 6/30/2016 248.000.00 98.70 244,764.10 0.12% None 248,000.00 1.40 248,000.00 1.76 275.86 -3,235.90 None Luena Savings Bank 1.25 6/19/2018 12/19/2014 248,000.00 99.93 247,823.67 0.12% None 549103005 248.000.00 1.25 248.000.00 1.35 874.79 -176.33 None Machias Savings Bank 1.65 2/612020 2/6/2015 248,000.00 100.96 250.392.70 554479DS1 248,000.00 1.65 248,000.00 1.23 269.06 0.12% 2,392.70 None None Mahopac Bank 1.45 7/30/2019 1/30/2015 248,000.00 100.73 249,812.14 0.12% None 560160A06 248,000.00 1.45 248,000.00 1.05 610.83 1,812.14 None 15 3.7 15 3.26 1369 3.65 262 0.72 859 2.3 688 1.81 Manufacturers & Traders Trust 1.2 6/24/2015 248,000.00 99.95 247,878.73 0.12% None 268 6/25/2018 5647590V3 248,000.00 1.20 248,000.00 1.27 799.04 -121.27 None 0.73 Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 99.60 247,020.15 0.12% None 1368 56817TAB7 248,000.00 1.80 248,000.00 1.91 12.23 -979.85 None 3.63 Marlin Business Bank 1.2512/27/2019 6/29/2016 248,000.00 98.96 245,432.95 0.12% None 57116AMC9 248,000.00 125 248,000.00 1.72 8.49 -2,567.05 None 818 2.21 MB Financial Bank 1.1 3/18/2019 3/18/2016 248.000.00 99.84 247,610.14 0.12% None 55266C0U3 248,000.00 1.10 248,000.00 1.21 89.69 -389.86 None 534 1.46 Moody National Bank 0.511/30/2017 5/30/2017 248.000.00 100.00 248,000.00 0.12% None 7130F 248,000.00 0.50 248,000.00 0.50 417.86 0.00 None National Bank Commerce Superior 1.25 7(15/2016 248,000.00 98.34 243,885.43 0.12% None 7/15/2021-17 633368EB7 248,000.00 1.25 248,000.00 1.70 127.40 4,114.57 None 61 0.17 15 3.7 Prepared by Rick Overgaard 9of 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount ! Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM Op Cost Book Value YTM © Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Nebraskaland National Bank 1 2 9125!2018 63970QFC5 248.000.00 Northern Bank & Trust MA 1.1 7/12/2019-17 66476013H0 Northwest Bank Boise Idaho 1 5 110.2019 66736AAD1 OLDTOWW BANK 1.2 5/7/2018 248,000.00 9/25/2015 1.20 248,000.00 248,000.00 7,12/2016 248,000.00 100.19 1.00 248.401 62 40.77 99.18 245,957.72 0.12% 481.62 None None 0.12% None 1.10 248,000.00 1.57 597.92 -2,042.28 248,000.00 4/10/2014 248.000.00 1.50 248,000.00 100.43 1.16 249,062.18 203 84 None 380 0.98 12 1.76 0.12% None 467 1,062.18 None 1.27 810/2014 248,000.00 100.13 248,323 89 0.12% None 219 680540886 248,000.00 1.20 248,000.00 0.98 195.68 323.89 None 0.6 Pacific Continental Bank 1.25 6/30/2020 69413CFD6 Parkside Finl Bank &. Trust 1.3 7/19/2021-17 70147ABX1 Partners Bank 1.5 9/30/2019 70212YAR3 Peartand State Bank 0.9 7/24/2018 70001394713 Peoples United Bank 1.9 11/19/2019 71270QKM7 Portage County Bank 1.4 6/24/2021 73565NBO5 6/30/2016 248.000.00 98.67 244,699.37 0.12% None 1004 248,000.00 1.25 248,000.00 1.75 0.00 -3,300.63 None 2.7 7/18/2016 248,000.00 98.33 243,866.83 0.12% None 18 248.000.00 1.30 248,000.00 1.75 105.99 -4,133.17 None 3.71 3130/2015 248,000.00 100.49 249.222 89 0.12% None 730 248.000.00 1.50 248,000.00 1.25 0.00 1222.89 None 1.97 7/24/2017 245,000.00 100.00 245,000.00 0.12% None 297 245,000 00 0.90 245,000.00 0.90 410.79 0.00 None 0.81 11/19/2014 248,000.00 100.74 249.825 28 248.000.00 1.90 248,000.00 1.55 1,729.88 6/24/2016 248,000.00 98.70 244.788.15 248.000.00 1.40 248,000.00 1.76 57 07 Quantum National Bank 1.2 9/18/2019.16 3/18/2016 248,000.00 99.20 246,010.79 74765JETl 248,000.00 1.20 248,000.00 162 97.84 0.12% 1,825.28 None None 780 2.09 0.12% None 1363 -3211.85 None 3.64 0.12% None 79 -1,989.21 None 1.95 Revere Bank 1.35 6/29/2018 12/30/2014 248,000.00 100.04 248,107.63 0.12% None 761402AU0 248.000.00 1.35 248,000.00 1.29 9.17 107.63 None Prepared by Rick Overgaard 272 0.74 10 of 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2017 Description Face Amount / CUSIP Shares YTM rig/ Cost Settlement Date Cost Value Book Value Market Price Market Value YTM © Market Accrued Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity Sallie Mae Bank 2.15 11/19/2019 795450VC6 Selling State Bank OK 1 55 77/2021-17 816050AA6 Signature Bank 1.35 3.'282019 826691FU2 248.000.00 248,000.00 11/19/2014 2.15 248,000.00 248,000.00 7/7/2016 248,000.00 100.75 1.79 249.87066 1,957.50 98.73 244,842.46 1.55 248,000.00 1.90 0.12% 1,870.66 None None. 0.12% None 242.22 -3,157.54 None 780 2.08 7 3.66 9/29/2015 248,000.00 100 41 249,014.07 0.12% None 544 248,000.00 1.35 248,000.00 1.07 18.35 1,014.07 None 1.48 Summit Conxnunity Bank Moorefield WV 6/3012017 248.000.00 99.83 247,567.49 0.12% None 636 1.55 6/28/2019 86604XLX2 248,000.00 1.55 248,000.00 1.65 21.06 -432.51 None 1.72 Trust Atlantic Bank 1 45 12/6/2017 11/8/2013 248.000.00 100.11 248,277.02 0.12% None 67 89835FJC5 248,000.00 1.45 248,000.00 0.84 236.45 277.02 None 0.18 Umpqua Bank Roseburg OR 1.6 6/28/2019 6/30/2017 248,000.00 99.91 247,778.54 0.12% None 636 90421MAX1 248,000.00 1.60 248,000.00 1.64 1,000.15 -221.46 None 1.72 Unity Bank 1 65 10/30/2020 10/30/2015 248.000.00 101 02 250,526.87 0.12% None 1126 91330ABC0 248,000.00 1.65 248,000.00 1.31 0.00 2,526.87 None 3.01 Vision Bank of Iowa 1.3 7/122021 7/11/2016 248,000.00 98.31 243,815.00 0.12% Nate 1381 92834CBW1 248,000.00 1.30 248,000.00 1.76 715.46 -4,185.00 None 3.69 Washington Federal 1.5 3/31.2021.16 3112016 248.000.00 99.14 245,875.63 0.12% None 31 938828AC4 248,000.00 1.50 248,000.00 1.75 0.00 -2,124.37 None 3.41 Washington Trust Co 1.4 6/15.2018 1215/2014 248,000.00 100.06 248,151.28 0.12% None 258 94063701/9 248,000.00 1.40 248,000.00 131 1,017.82 151.28 None 0.7 Webster Bank NA 1.9 2/12/2019 2/122014 248,000.00 100.43 249,074.83 0.12% None 500 94768NJM7 248,000.00 1.90 248.000.00 1.58 632.57 1,074.83 None. 1.35 Welch State Bank 1.3 10/1/2018 9/30/2015 248,000.00 100.18 248,446.15 0.12% None 366 949095AJ7 248,000.00 1.30 248,000.00 1.12 256.15 446.15 None 1 Prepared by Rick Overgaard 11 of 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount I Settlement Dote Shares YTM © Cost Cost Value Market Price Market Value Book Value YTM @ Market Accrued Interest % Portfolio Credit Rating Days To Call/Maturity Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Bank 1.75 6/17/2021 9497485W3 248,000.00 6/20/2016 1.75 248,000.00 248,000.00 Sub Total Certificate Of Deposit 24,062,069.94 24,062,069.94 1.42 24,062,069.94 98.72 211 1.46 244,837.01 154 58 24,003,567.32 43,673.53 0 T) 11.64% -58,502.92 N^o Nen,• 1356 3.6 635 2.07 FAMC Bond FAMC 1.5 8/22/2019 3132X0PV7 FAMC 1.5 8/22/2019 3132X0PV7 FAMC 1.5 8/22/2019 3132XOPV7 FAMC 1.675 2/24/2020 3132X0PW5 2'22/2017 1,000,000.00 99.74 997,381.00 0.4 T' S&P -AA+ 691 1.000,000.00 1.50 1.000,000.00 1.64 1,583.33 -2.619.00 Moodys-Aaa 1.87 2/22/2017 1,000,000.00 99.74 997.381.00 0.47% S&P -AA+ 691 1,000.000.00 1.50 1,000.000.00 1.64 1,583.33 -2,619.00 Moodys-Aaa 1.87 2122/2017 2,001,700.00 99.74 1,994,762.00 0.95% S&P -AA+ 691 2,000,000.00 1.47 2.001,288.22 1.64 3,166.67 -8.526.22 Moodys-Aaa 1.87 2/24/2017 1,001,200.00 100.09 1,000,862.00 0.47% Moodys-Aaa 877 1.000,000 00 1.63 1.000.960.00 1.64 1,675.00 -98.00 S&P -AA. 2 36 FAMC 1.675 2/24/2020 3132X0PW5 FAMC 1.72 10/3/2018 31315P5A3 2/24/2017 1.001.200.00 100.09 1,000,882.00 0.47% Moodys-Aaa 877 1,000.000.00 1.63 1,000,960.00 1.64 1,675.00 -98.00 S&P -AA+ 2 36 12/16/2013 997,890.00 100.39 1.003.884.00 0.47% Moodys-A8e 368 1,000.000.00 1.77 999,556.50 1.33 8,456.67 4,327.50 S&P -AA+ 1 Sub Total FAMC Bond 7,000,000.00 7,001,990.00 1.57 7,002,764.72 6,995,132.00 3.3% 698 1.60 18,140.00 -7,632.72 1.89 FFCB Bond FFCB 1.34 12/29/2017 3133E0E99 1/29/2014 1,004,000.00 100.07 1.000,731 00 0.47% Moodys-Aaa 90 1,000,000.00 1.24 1,000,252.48 1.04 3,387.22 478.52 S&P -A4+ 0.25 FFCB 1.5 1/28/2019 3133EDMF6 5/28/2014 1,000.000.00 100.04 1.000,406.00 0.47% Moodys-Aaa 485 1,000,000.00 1.50 1,000,000.00 1.47 2,583.33 408.00 S&P -A4+ 1.32 FFCB 1.95 9/17/2018 3133ED2C5 Prepared by Rick Overgaard 1,000.000.00 1/29/2014 1,014.770.00 100.58 1,005,756.00 0.47% Moodys-Aaa 352 1.62 1.003,072.66 1.35 704.17 2,683.34 S&P -A4+ 0.96 120115 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date. 9;30/2017 Description CUSIP Face Amount I Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM L Cost Book Value YTM Ce Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total FFCB Bond 3,000,000.00 1.45 3,018.770.00 3,003,325.14 1.29 3,006,895.00 6,674.72 1.41% 3,569.86 309 0.84 FHLB Bond FHLB 1 9/26/2019 3130A9EP2 FHLB 1.45 628/2019-17 3130ABHR0 1.000,000.00 1.000,000.00 9/22/2016 991 430.00 98.96 ,4h9,6 12 00 0.47% Moodys-Aaa 109 998.30247 1.53 111.11 -8,690.47 S8P-AA. 6/28/2017 1.000.000.00 99.64 996,357.00 0.47% Moodys-Aaa 1 45 1,000.000.00 1.66 3.705.56 -3.643 00 S&P -AA. FHLB 1.7512/142018 3133768R5 Sub Total FHLB Bond 1.000,000.00 12/16/2013 1,000.670.00 100.36 1,003,801.00 0.47% Moodys-Aaa 174 1,000.161 72 145 5,152.78 343928 SSP -AA. 3.000,000.00 1.42 2.998.100.00 2,998,464.19 1.55 726 1.97 89 1.72 440 119 2,989,570.00 1.41 % 418 8,969.45 -8,894.19 1.63 FHLMC Bond FHLMC 1.125 8'12/2021 3137EAEC9 FHLMC 1.3512/172018-15 3134G6S95 9/222016 988,540.00 97.46 974,584 00 0.47% Moodys-Aaa 1412 1,000,000.00 1.37 990,936.18 1.81 1,343 75 -16,352.18 S&P -AA. 3.79 FHLMC 1.42 3/29/2019-17 3134GA6G4 Sub Total FHLMC Bond 6/19/2015 999,525.00 99.78 997,836.00 0.47% S&P -M. 443 1.000.000.00 1.36 999,835.00 1.53 3,862.50 -1.999.00 Moodys-Aaa 1.2 3/2912017 2,000.000.00 99.75 1,994,950.00 0.94% S&P -M. 180 2,000.000.00 1.42 2.000,000.00 1.59 78.89 -5.060.00 Moodys-Aaa 1.49 3.968,065.00 3,987,370.00 1.88% 552 4,000,000.00 1.39 3,990,771.16 1.63 5,285.14 -23,401.18 1.99 FNMA Bond FNMA 0.875 10/26/201 7 3135G0P00 FNMA 0.875 12/20/2017 3135G0RT2 1.000,000.00 1.000,000.00 5/21/2014 995,150.00 99.99 999,887.00 0.47% Moodys-Aaa 26 1.02 999,897.89 1.03 3,743.06 -10.89 S&P -M• 0.07 5/2112014 992,573.21 99.95 999,524.00 0.47% Moodys-Aaa 61 1.09 999,539.07 1.09 2,430.56 -15.07 S&P -AA. 0.22 FNMA 0.875 5212018 3135GOWJ8 Prepared by Rick Overgaard 1.000,000.00 521/2014 985.050.00 99.74 997,444.00 0.47% Moodys-A88 233 1.26 997.601.77 128 3.135.42 -157.77 S&P -AA+ 0.64 13 of 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9,30/2017 Description CUSIP Face Amount/ Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM (d- Cost Book Value YTM t© Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity FNMA 1.375 3/13/2019-16 3136G1FY0 FNMA 1 625 11/27/2018 3135G0YT4 FNMA 1.875 12/28/2020 3135G0H55 Sub Total FNMA Bond 1,000,000.00 9/22/2016 0.98 1,009,560 00 1,005,611.54 7/16/2014 1,004,411.00 1,000,000.00 1.52 1,001,170.84 922/2016 1,025,880.00 1.000,000.00 125 1,019,679.58 6,000,000 00 1.19 6.012,624.21 6,023,500.69 99.77 1.54 100.13 1.51 997,70800 64931 1,001,301.00 5,552.08 0.47% Moodys-Aaa -7,903.54 SSP -AA+ 529 1,44 0.47% Moodys-Aaa 130.16 SSP -AA+ 423 1.15 100.52 1,005,155.00 0.48% Moodys-Aaa 1185 1.71 4,791.67 -14,524.58 SSP -AA+ 3.15 1.36 6,001,019.00 2.83% 416 20,302.10 -22,481.89 1.12 Local Government Investment Pool Texas Class LGIP TX -01-06150001 Texas Class LGIP TX -01-0615-0001 Texas Class LGIP TX -01.06150001 Texas Class LGIP TX -01-0615-0001 Texas Class LGIP TX -01.0615.0001 5/15/2017 5022,49441 100.00 502.494.4, 0.24% None 502,494.41 1.25 502,494 41 1.25 0.00 None 3.073.548.69 1/15/2017 3.073.548.69 100.00 3,073,548.69 1.45% None 1.25 3.073.548.69 1.25 0.00 None 37,745.748.58 12/20/2018 37.745.748.58 100.00 37,745,748.58 17.82% None 125 37,745.748.58 1.25 0.00 None 5.046,464.27 12/20/2016 5.046,464.27 100.00 5.046,46427 2.38% None 125 5,046,464.27 1.25 0.00 None 17,047,573.78 12%20/2016 17,047,573.78 100.00 17,047,573.78 8.05% None 1.25 17,047,573.78 1.25 0.00 None Texas Class LGIP TX -01-0815-0001 Tates Class LGIP TX -01-0615-0001 Texas Gass LGIP TX -01.0615-0001 1,007,849.74 1/15/2017 1,007,849.74 100.00 1,007,849.74 0.48% None 1.25 1,007,849.74 1.25 0.00 None 5/15/2017 19,585.48 100.00 19,585.48 0.01% None 19,586.48 1.25 19,585.48 125 0.00 None Prepared by Rick Overgaard 3,014,966.49 5/15/2017 3,014,966.49 100.00 3,014,988.49 1.42% None 1.25 3.014.986.49 1.25 0.00 None 0 1 0 0 0 1 0 0 0 1 0 14 of 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 9/30/2017 Description Face Amount CUSIP Shares Settlement Date Cost Value Market Price Market Value YTM (rid Cost Book Value YTM @ Market Accrued Interest % Portfolio Credit Rating Days To CalltMaturity Unre. Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP TX -01-0615.0001 Texas Class LGIP TX -01.0615-0001 TexSTAR LGIP 02000-11110 1,007,849.74 3,537,859.90 5,036,980.65 1/15/2017 1.25 1,007,649.74 1.007,849.74 12/20/2016 3.537,859.90 1.25 3,537.859.90 10000 1,25 1.007.849 7: 100.00 3,537,859.90 1.25 C 48% 0.00 1.67% 000 None None None None 0 0 8/26/2016 5,036,980.65 100.00 5.036.980.65 2.38% S&P -AAA 1 1.04 5,036,980.65 1.04 0.00 None 0 TexSTAR LGIP 02000-11110 Sub Total Local Government Investment Pool 5,037.328.61 82.078,250.34 8/26/2016 5,037.328.61 100.00 5,037,328 61 2 38% S&P -AAA 1.04 5.037,328.61 1.04 0.00 None 82.078,250.34 1.22 82,078,250.34 1.22 82,078.250.34 38.76% 0.00 0 1 0 211,768,486.37 TOTAL PORTFOLIO 211,748.937.16 0.81 211.767,763.08 211,650,420.54 100.00% 129 0.83 103,044.94 •117,342.54 0.4 Prepared by Rick Overgaard 15 of 15 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description CUSIP Settlement Date Cost Value Market Price Market Value Portfolio Credit Rating Days To Call/Maturity Face Amount 1 Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre, Gain/Loss Credit Rating Duration To Maturity 100: General Fund Aileg,ance Bank 0,8 9,132018 26115230 248,069.94 Alma Bank 1.35 12/24/2020 020080B82 248,000.00 9/13/2017 248.069.94 0.80 248,069.94 100.00 0.80 248,069.94 92,43 0.12% 0.00 6/24/2016 248.000.00 98.20 243,541.46 1.35 248,000.00 American Eagle Bank IL 1.35 7/12/2021 02554BCM1 1.92 55.04 0.12% -4,458.54 None None None None 7/11/2016 248,000.00 98.31 243,811 78 0.12% None 248,000.00 1.35 248.000.00 1.81 174.28 .4,188.22 None 348 0.95 1181 3.16 1381 3.69 Bank Leumi USA 1.3 2/262020 3/3/2016 248,000.00 100.18 248,440.20 0.12% None 063248FH6 248,000.00 1.30 248.000.00 1.23 309.15 440.20 None 879 2.37 Bank of the Pacific 1.25 7/30/2018 1292015 248,000.00 99.86 247,664.95 0.12% None 0642589N8 248.000.00 1,25 248,000.00 1.41 526.58 335.05 None 303 0.83 Bankers Bank Oklahoma 1.8 925/2020 9/25/2015 248,000.00 101.01 250,502.82 0.12% None 1091 06610QCV1 248.000 00 1.80 248,000.00 1.45 61.15 2,502.82 None 2.91 Belmont Savings Bank 1.8510/23/2019 12123/2014 248.000.00 100.62 249,545.29 0.12% None 753 0805158D0 248,000.00 1.85 248,000.00 1.54 1,244.42 1.545.29 None 2.02 Capital One NA 2.3 925/2020 9/23/2015 248,000.00 101.03 250,551.67 0.12% None 1091 14042RAB7 248,000.00 2.30 248,000.00 1.94 78.14 2,551.67 None 2.9 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 98.48 244.228.66 0.12% None 1031 144153AW3 248,000.00 1.10 248,000.00 1.65 22.42 -3,771.34 None 2.78 CDARS 0.712/13/2018 12/15/2016 500.000.00 100.00 500,000.00 0.24% None 439 1019720221 500,000.00 0.70 500,000.00 0.70 2,589.04 0.00 None 1.2 CDARS 0.9 6/14/2018 1019145928 6/16/2016 500,000.00 100.00 500.000.00 500,000.00 0.90 500,000.00 0.90 3,328.77 0.24% 0.00 None None 257 0.7 Cit Bank Salt Lake 2.1 11/19/2019 17284C3Z5 248,000.00 Prepared by Rick Overgaard 11/19/2014 248,000.00 100.78 249,924.23 0.12% None 2.10 248,000.00 1.73 1,911.98 1,924.23 None 780 2.08 1 of 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount 1 Shares Settlement Date YTM @ Cost Cost Value Book Value Market Price Market Value YTM @ Market Accrued Interest % Portfolio Credit Rating Days To Call/Maturity Unre. Gain/Loss Credit Rating Duration To Maturity Comenity Capital Bank 1.7 5/26/2018 20033AJL1 248.000.00 11/26/2014 1.70 248,000.00 248,000.00 Commercial Bank Ala Mich 1.5 3/29/2019 201282GV6 Community Bank Pasadena 1.5 6/30/2021 203507BG2 248,000.00 6/30/2015 1.50 248,000.00 248,000.00 248.000.00 6/30/2016 1.50 248,000.00 248,000.00 Community Bankers': Bank 1.4 6/30/2021 20361LBR4 248,000.00 6/30/2016 1.40 248,000.00 248,000.00 Community National Bank Interest 1.25 4/4/2018 20375WAM6 248,000.00 4/4/2014 1.25 248,000.00 248,000.00 100.11 1.54 99.85 1.60 98.70 1.86 98.70 1.76 248,264.37 46.20 0.12% 264.37 None None 247,620.31 10.19 244.770 30 0.00 244,764.10 0.00 0.12% -379.69 0.12% -3,229.70 None None None None 0.12% -3,235.90 None None 240 0.66 545 1.48 1369 3.65 1369 3.65 Exchange Bank NEB 1.051/21/2020 301074CH1 248,000.00 7/20/2016 1.05 248,000.00 248,000.00 100.00 1.25 98.38 Fahey Banking 1.1 6/28/2019 303117CC7 248,000.00 3/29/2016 1.10 248,000.00 248,000.00 1.77 247,997.52 1,520.27 0.12% -2.48 None None 186 0.51 243,989.10 71.34 99.86 247,650.82 1.18 14.95 FAMC 1.675 2/24/2020 3132X0PW5 1,000,000.00 2/24/2017 1.63 1,001,200.00 1,000,960.00 100.09 1.64 1,000,862.00 1,675.00 0.12% -4,010.90 None None 843 2.28 0.12% -349.18 None None 638 1.73 0.47% Moodys-Aaa -98.00 S&P -AA+ 877 2.36 Farmers & Merchants Bank 1.45 9/25/2018-14 308862DD0 248,000.00 4/25/2014 1.45 FFCB 1.3412/292017 3133EDE99 1,000.000.00 1/29/2014 1.24 248,000.00 248,000.00 1,004.000.00 1,000,252.48 FHLB 1.45 6/282019.17 3130ABHR0 1,000,000.00 6/28/2017 1.45 1,000,000.00 1,000,000.00 99.95 1.50 247,872.28 49.26 FHLMC 1.3512/172018.15 3134G6S95 1.000.000.00 6/19/2015 1.36 999,525.00 999.835.00 100.07 1.04 1,000,731.00 3,387.22 0.12% -127.72 None None 25 0.98 0.47% Moodys-Aaa 478.52 S&P -AA+ 99.64 1.66 996,357.00 3,705.56 0.47% Moodys-Aaa -3,643.00 S&P -AA+ 90 0.25 89 1.72 99.78 1.53 997,836.00 3,862.50 0.47% S&P -AA+ -1,999.00 Moodys-Aaa 443 1.2 Prepared by Rick Overgaard 2of 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount 1 Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call:Maturity YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity FHLMC 1 42 3129/2019-17 3134GA6G4 2,000,000.00 FIRST BANK HIGHLAND PARK 1.85 5/7/2019.14 3191410L0 First National Bank 1.6 3/19/2018 CD32115C8E7 3/29/2017 1.42 2,000.00000 2.000.000.00 9975 1.59 5/712014 248,000.00 100.08 1,994,950 00 78.89 248,186 50 0.94% -5,050.00 S&P -AA« Moodys-Aaa 0.12% None 180 1.49 38 248,000.00 1.85 248,000.00 1.80 1,835.20 186.50 None 1.58 9/18/2013 248,000.00 100.26 248,641.08 0.12% None 170 248,000.00 1.60 248,000.00 1.05 119.58 641.08 None 0.47 FNMA 0.87512/20/2017 3135GORT2 1,000.000.00 5/21/2014 992,573.21 99.95 999,524.00 0.47% Moodys-Aaa 81 1.09 999,539.07 1.09 2,430.56 -15.07 S&P -AA• 0.22 JP Morgan Chase Bk NA Columbus 2.1 2/15/2021-17 48126XVW2 2/15/2017 245.000.00 100.35 245.864 60 0.12% None 15 245,000.00 2.10 245.000.00 1.99 21144 864.60 None 3.26 Machias Savings Bank 1.65 2/6/2020 2/6/2015 248,000.00 100.96 250,392.70 0.12% 554479DS1 248.000.00 1.65 248,000.00 1.23 269.06 2.392.70 Mahopac Bank 1.45 7/30/2019 1/30/2015 248,000.00 100.73 560160A06 248,000.00 1.45 248,000.00 1.05 249,812.14 610.83 0.12% 1,812.14 None None None None 859 2.3 668 1.81 Moody National Bank 0.511/30/2017 5/30/2017 248,000.00 100.00 248,000.00 0.12% None 81 7130F 248,000.00 0.50 248,000.00 0.50 417.86 0.00 None 0.17 Pearland State Bank 0.9 7/242018 7/24/2017 245,000.00 100.00 245,000.00 0.12% None 297 7000139476 245,000.00 0.90 245,000.00 0.90 410.79 0.00 None 0.81 Quantum National Bank 1.2 9/182019.16 3/18/2016 248,000.00 99.20 246,010.79 0.12% None 79 74765JETI 248,000.00 1.20 248,000.00 1.62 97.84 -1,989.21 None 1.95 Saab Mae Bank 2.1511/192019 11/19/2014 248,000.00 100.75 249.870.66 0.12% None 780 795450VC6 248,000.00 2.15 248,000.00 1.79 1,957.50 1,870.66 None 2.08 Selling State Bank OK 1.55 7/7/2021.17 7/72016 248,000.00 98.73 244,842.46 0.12% None 7 816050AA6 248,000.00 1.55 248,000.00 1.90 242.22 -3,157.54 None 3.66 Prepared by Rick Overgaard 3of18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9.30/2017 Description Face Amount I CUSIP Shares YTM , Cost Book Value YTM @ Market Accrued Interest Unre- Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Ca!MMMaturity Texas Class LGIP TX -01.0615.0001 Trust Atlantic Bank 1.45 12/6/2017 89835FJC5 Unity Bank 1.65 10/30/2020 91330ABC0 5/15/2017 19,585.48 1 25 19,585.48 19,585.48 11/6/2013 248,000.00 100.00 1.25 100.11 19.585 48 248,277.02 248,000.00 1.45 248,000.00 0.84 236.45 248,000.00 0.01% 0.00 0.12% 277.02 None Nome None None 0 67 0.18 10/30/2015 248,000.00 101.02 250,526 87 1.65 248,000.00 1.31 0.00 0.12% None 1126 2,526.87 None 3.01 Vision Bank of Iowa 1 3 7/12/2021 7/11/2016 248,000.00 98.31 243,815.00 0.12% None 1381 92834CBW1 248,000.00 1.30 248,000.00 1.76 715.46 -4,185,00 None 3.69 Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 99.14 245,875.63 0.12% None 31 938828AC4 248,000.00 1.50 248,000.00 1,75 0.00 -2.124.37 None 3.41 Wells Fargo Bank 1.75 6/17/2021 6120)2016 248,000.00 98.72 244.837 01 0.12% None 1356 9497485W3 248,000.00 1.75 248,000.00 2.11 154.58 -3,162.99 None 3.6 Wells Fargo Sweep Cash WFSWEEP Sub Total 100: General Fund -1,604.255.65 5/31/2006 -1.604,255.65 100.00 -1,604,255.65 0.05 -1,604,255.65 0.05 14,593,399.77 1.54 -0.76% None 1 0.00 None 0 14,590,697.98 14,593,986.32 1.59 14,584,752.09 34,524.15 6.98% -29,234.23 513 1.86 200: Debt Services 1st Source Bank 1.5 11/18/2019 33646CE03 Charter Bank 1.7 2/25/2020 1611646E7 4/17/2015 248.000.00 100 36 248,895.03 0.12°': None 248,000.00 1.50 248,000.00 1.33 1,691.84 895.03 No»e 2/25/2015 248,000.00 99.80 247,507.47 0.12% None 248,000.00 1.70 248,000.00 1.79 57.75 -492.53 Nome ConnectOne Bank 1.55 7/30/2018 20786AAM7 Discover Bank 2 2/25,'2020 254672JA7 779 2.09 878 2.36 1/30'2014 248.000.00 100.31 24 8, 760 12 248,000.00 1 55 248.000.00 1.18 0.00 2/2512015 248,000.00 100.51 249,255.13 248,000.00 2.00 248,000.00 1.78 489.21 Prepared by Rick Overgaard 0.12% 780.12 None None 303 0.83 0.1296 1255.13 None None 878 2.35 4 of 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity First Capital Bank 1.4 8/6/2019 31944FBK5 Goldman Sachs Bank 2 2/25/2020 248,000.00 4/6/2015 1.40 248,000.00 248,000.00 2/25/2015 248,000.00 100.25 1.26 248.627.44 228.30 100.51 249.255.13 0.12% 627.44 None None 0.12% None 38148JLL3 248,000.00 2.00 248,000.00 1.78 489.21 1,255.13 None Partners Bank 1.5 9/30/2019 70212YAR3 Texas Class LGIP TX -01-0615.0001 675 1.83 878 2.35 3/30/2015 248,000.00 100.49 249,222.89 0.12% None 730 248,000.00 1.50 248,000.00 1.25 0.00 1,222.89 None 1.97 3,073,548.69 1/15/2017 3,073,548.69 100.00 3,073.548.69 1.45% Norte 1 1.25 3,073,548.69 1.25 0.00 None 0 Webster Bank NA 1.9 2/12/2019 2/12/2014 248,000.00 100.43 249,074.83 0.12% None 500 94768NJM7 248,000.00 1.90 248.000.00 1.58 632.57 1,074.83 None 1.35 Wells Fargo Sweep Cash WFSWEEP Sub Total 200: Debt Services 887,794.83 5/31/2006 887,794.83 0.05 887,794.83 5,945,343.52 1.22 100.00 0.05 5.945.343.52 5,945.343.52 887,794.83 0.42% None 0.00 None 0 5,951,941.58 2.83% 235 1.15 3,588.88 6,598.04 0.63 305: Hotel/Motel Occupancy Ally Bank Midvale Utah 1.8 6/29/2020 02006L3U5 248,000.00 6.2923'7 248.000.00 99.85 1.80 248,000.00 1.86 Bank of New England NH 1.4 6/30/2021 6/3W2016 248,000.00 98.70 063847AL1 248,000.00 1.40 248.000.00 1.76 Capital Bank Little Rock 1.35 3/22/2019 9/23/2015 248,000.00 100.42 139797F1_3 248,000.00 1.35 248,000.00 1.06 First Intl Bank &: Trust 1.6 1/16/2020 32057GAE9 Texas Class LGIP TX -01-0615-0001 Prepared by Rick Overgaard 247,632.96 0.12% None 1003 1,137.40 -367.04 None 2.68 244,764.10 0.12% None 0.00 -3,235.90 None 249,052.02 73.38 1369 3.65 0.12% None 1,052.02 None 538 1.46 10/16/2015 248,000.00 99.64 247,097.03 0.12% None 248,000.00 1.60 248,000.00 1.76 152.20 -902.97 None 3.014,966.49 838 2.25 5/15/2017 3,014,966.49 100.00 3,014,966.49 1.42% None 1.25 3,014,966.49 1.25 0.00 None 0 5of 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount 1 Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM © Cost Book Value YTM © Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Sub Total 305: Hotel/Motel Occupancy 282,572.73 5/31/2006 0.05 4,289,539.22 1.24 282,572.73 282,572.73 4.289,539.22 100.00 0.05 4,289,539.22 1.25 282,572.73 4,286,085.33 1,362.98 0.13% None 0.00 None 2.03% -3,453.89 0 217 0.58 310: Municipal Court Security Wells Fargo Sweep Cash WFSWEEP Sub Total 310: Municipal Court Security 36,207.02 31'2006 36,207.02 0.05 36,207.02 100.00 36,207.02 0.02% None 0.05 0.00 None 0 36,207.02 36,207.02 0.02% 1 36,207.02 0.05 36,207.02 0.05 0.00 0 315: City Wide Donation \Neils Fargo Sweep Cas': WFSWEEP Sub Total 315: City Wide Donation 5/31/2006 74,712.01 100.00 74,712.01 0.04% None 74,712.01 0.05 74,712.01 0.05 0.00 None 1 0 74,712.01 74,712.01 0.04% 1 74,712.01 0.05 74,712.01 0.05 0.00 0 320: Court Technology Welts Fargo Sweep Cash 5/31/2006 970.56 100.00 970.56 0% None 1 WFSWEEP 970.56 0.05 970.56 0.05 0.00 None 0 Sub Total 320: Court Technology 970.56 970.56 0% 1 970.56 0.05 970.56 0.05 0.00 0 330: Park Donations :dells Fargo Sweep Cash WFSWEEP Sub Total 330: Park Donations 5/3112006 117,933.72 100.00 117,933 72 0.06% None 1 117,933.72 0.05 117,933.72 0.05 0.00 None 0 117,933.72 117,933.72 0.06% 1 117,933.72 0.05 117,933.72 0.05 0.00 0 331: Tree Trust Fund Wells Fargo Sweep Cash 5/31/2006 144,101.98 100.00 144,101.98 0.07% None WFSWEEP 144,101.98 0.05 144,101.98 0.05 0.00 None Sub Total 331: Tree Trust Fund Prepared by Rick Overgaard 144,101.98 144,101.98 0.05 144,101.98 0.05 144,101.98 0.07% 0.00 0 1 0 6 of 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description Face Amount I Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To CaII/Maturity CUSIP Shares YTM @ Cost Book Value YTM © Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity 335: Police State Seizure Wens Fargo Sweep Cash 1,^JFSWEEP Sub Total 335: Police State Seizure 218.616 77 5131/2006 0.05 218.616.77 218,616.77 218,616.77 218,616.77 0.05 218,616.77 100.00 0.05 218,616.77 0.1% 0.00 0.05 218,618.77 0.1% 0.00 None None 0 0 336: Federal Police Fund Wells Fargo Sweep Cash 5/3112006 49,577.32 100.00 49,577.32 0.02et None WFSWEEP 49,577.32 0.05 49,577.32 0.05 0.00 None Sub Total 336: Federal Police Fund 49,577.32 0.05 49,577.32 49,577.32 0.05 49,577.32 0.02% 1 0 1 0.00 0 340: Park & Rec Development Border State Bank 1 4 6/30/2021 6,30:2016 248.000.00 97.98 242.983 21 0.12% None 1369 099703EF3 248,000.00 1.40 248,000.00 1.96 0.00 -5,016.79 None 3.65 Nebraskaland National Bank 1.2 925/2018 9/25/2015 248,000.00 100.19 248.481.62 0.12% None 360 63970OFC5 248.00000 1.20 248,000.00 1.00 40.77 481.62 None 0.98 Wells Fargo Sweep Cash 5/31/2006 223,062.19 100.00 223,062.19 0.11% None 1 WFSWEEP 223,062 19 0.05 223.062 19 0.05 0.00 None 0 Sub Total 340: Park & Rec Development 719,062.19 0.91 719,062.19 714,527.02 0.35% 597 719,062.19 1.04 40,77 -4,535.17 1.6 345: Sidewalk Fund ',Veils Fargo Sweep Cash WFSWEEP Sub Total 345: Sidewalk Fund 5131:2006 6,283.14 100 00 5,283.14 None 1 6.283 14 0.05 6,283 14 CI 3' ^ 03 None 0 6.283.14 0.05 6,283.14 6,283.14 0 1 6.283.14 0.05 0.00 0 350: Grant Fund Wells Fargo Sweep Cash WFSWEEP Prepared by Rick Overgaard 107.227.05 5/31/2006 107,227.05 100.00 107,227.05 0 05', None 0.05 107,227 05 0.05 0 00 None 1 0 7of18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description Face Amount/ CUSIP Shares YTM @ Cost Settlement Date Cost Value Book Value Market Price Market Value % Portfotio Credit Rating Days To Call/Maturity YTM a Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total 350: Grant Fund 107,227.05 0.05 107,227.05 107,227.05 0.05 107,227.05 0.05% 0.00 0 351: CDBG Fund !ells Fargo Sweep Cash WFSWEEP Sub Total 351: CDBG Fund 11/15/2015 '64,808.43 100.00 -164.808.43 -0.08°!: None -164.80843 0.05 •164,808.43 0.05 0.00 Nene -164.808.43 0.05 -164,808.43 -164,808.43 0.05 -164,808.43 -0.08% 0.00 0 0 360: Traffic Impact Improvement Summit Community Bank Moorefiele'AV 6/3012017 248,000.00 99.83 247,567.49 0.12% None 636 1.55 6/28/2019 86604XLX2 248,000.00 1.55 248.000.00 1.65 21.06 -432.51 None 1.72 Wells Fargo Sweep Cash WFSWEEP 5/31/2006 478,963.09 100.00 478,963.09 0.23% None 478.963.09 0.05 478.963.09 0.05 0.00 None 0 726,963.09 726,530.58 0.35% 218 Sub Total 360: Traffic Impact Improvement 726,963.09 0.56 726,963.09 0.60 21.06 -432.51 0.59 365: Court Juvenile Mgmt Wells Fargo Sweep Cash WFSWEEP 21,253.29 Sub Total 365: Court Juvenile Mgmt 9/15/2009 21,253.29 100.00 21.253.29 C 01°'- Nene 0.05 21,253.29 0.05 . 00 None 21,253.29 0.05 21,253.29 21,253.29 0.05 21,253.29 0.01% 0.00 0 1 0 370: Municipal Channel Texas Class LGIP TX -01-0615-0001 Wells Fargo Sweep Cash WFSWEEP Sub Total 370: Municipal Channel 5/15/2017 502,494.41 100.00 502,494.41 0.24% None 502.494 41 1.25 502,494.41 1.25 0.00 None 0 4/15/2012 65,367.16 100.00 65,367.16 0.03% None 65,367.16 0.05 65,367.16 0.05 0.00 None 567,861.57 1.11 567,861.57 0 567.861.57 1.11 567,861.57 0.27% 1 0.00 0 375: U of H Fund Prepared by Rick Overgaard 8of 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM a Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wel!s Fargo Sweep Cash WFSWEEP Sub Total 375: U of H Fund -370.34 12/1/2009 0.05 -370.34 -370.34 -370.34 100.00 0.05 -370.34 0.05 -370.34 0.05 -370.34 -370.34 Ooh 0.00 0% 0.00 None None 1 0 1 0 380: Regional Detention Wells Fargo Sweep Cash 5/31/2006 3.158.45 100.00 3.158.45 0% WFSWEEP 3,158.45 0.05 Sub Total 380: Regional Detention 3,158.45 0.05 3,158.45 3,158.45 3,158.45 0.05 0.05 3,158.45 0.00 0% 0.00 None None 0 0 500: Capital Projects Texas Class LGIP TX -01-0615-0001 1,007,849.74 1/15/2017 1,007,849.74 100.00 1,007,849.74 0.48% None 1.25 1,007,849.74 1.25 0.00 None Umpqua Bank Roseburg OR 1.6 6/28/2019 90421MAX1 Wells Fargo Sweep Cash WFSWEEP Sub Total 500: Captal Projects 0 6/30/2017 248,000.00 99.91 247,778.54 0.12% None 248,000.00 1.60 248,000.00 1.64 1,000.15 -221.46 None 636 1.72 5/31/2006 3,102,881.02 100.00 3,102,681.02 1.47% None 3,102,681 02 0.05 . 3,102,681.02 0.05 0.00 None 0 4,358,530.76 4,358,309.30 2.07% 4,358,530.76 0.42 4,358,530.76 0.42 1,000.15 -221.46 37 0.1 501: Certificates of Obligation 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 97.34 241.405 18 0.12% None 33625CAZ2 248,000.00 1.10 248,000.00 1.93 59.79 -6,594.82 None FAMC 1.5 822/2019 3132X0PV7 FHLMC 1.125 8/12/2021 3137EAEC9 FNMA 1.8751228/2020 3135G0H55 Prepared by Rick Overgaard 1,000,000.00 1210 3.25 2/22/2017 1,000,000.00 99.74 997,381.00 0.47% S&P -AA+ 1.50 1,000,000.00 1.64 1,583.33 -2,619.00 Moodys-Aaa 1,000,000.00 1,000.000.00 691 1.87 9/22/2016 988,540.00 97.46 974.584.00 0.47% Moodys-Aaa 1.37 990,936.18 1.81 1,343.75 -16,352.18 S&P -M+ 9/22/2016 1,025,880.00 100.52 1,005,155.00 0.48% Moodys-Aaa 1.25 1,019,679.58 1.71 4,791.67 -14,524.58 S&P -AA+ 1412 3.79 1185 3.15 9of 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount! Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM © Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Gulf Coast Bank & Trust 1.3 7.'15/2021- 17 402194EX8 Luana Savings Bank 1.25 6/19/2018 549103005 248.000.00 7/1512016 1.30 248,000.00 248,000.00 12/19/2014 248,000.00 248,000.00 1.25 248.000.00 Marlin Business Bank 1.2512/27/2019 57116AMC9 98.34 1.75 243,885.43 132.49 0.1296 -4,114.57 None None 15 3.7 99.93 247,823.67 0.12% None 262 135 874.79 -176.33 None 0.72 6/29.'2016 248,000.00 98.96 245,432.95 0.12% None 248,000.00 1.25 248.000.00 1.72 8.49 -2,567.05 None Texas Class LGIP TX -01-0615-0001 5,046,464.27 818 2.21 12/20/2016 5.046.464.27 100.00 5,046,464.27 2.38% None 1 1.25 5.046,464.27 1.25 0.00 None 0 TexSTAR LGIP 0200011110 Wells Fargo Sweep Cash WFSWEEP 5,037,328.61 8.'26.'2016 5,037,328.61 100.00 5,037,328.61 2.38% S8P-AAA 1 1.04 5,037,328.61 1.04 0.00 None 0 5,669,051.72 Sub Total 501: Certificates of Obligation 19,744,844.60 503: Certificates of Obligation 2006 Wells Fargo Sweep Cash :^1FSWEEP 63 22. 73 5/31/2006 5.669,051.72 100.00 5,669,051.72 2.68% None 1 0.05 5,669,051.72 0.05 0.00 None 0 0.87 19,759,264.60 19,755,460.36 0.95 19,708,511.83 8,794.31 9.34% 197 -46,948.53 0.57 Sub Total 503: Certificates of Obligation 63,224.73 2006 6;33'2006 63,224 73 100 00 63.224.73 0.03% None 0.05 63.224 73 0.05 0.00 None 0 63,224.73 63,224.73 0.03% 1 0.05 63,224.73 0.05 0.00 0 506: General Obligation BMO Harris Bank 1.05 6/22/2018 6/23/2016 248,000.00 99.76 247,413.73 05581 WHF5 248,000.00 1.05 248,000.00 1.38 706.29 0.12% -586.27 None None Stickel) Bank Miami FL 1.6510282019 6/27/2017 248,000.00 99.86 247,663.46 0.12% None 10801DAG6 248,000.00 1.65 248,000.00 1.72 22.42 -336.54 None Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 99.43 246,588.63 0.12% None 12325EHU9 248,000.00 1.80 248.000.00 1.96 85.61 -1,411.37 None Prepared by Rick Overgaard 265 0.72 758 2.04 .1362 3.61 10 of 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description CUSIP Settlement Date Cost Value Face Amount / Shares YTM til Cost Book Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Capital One Bank USA 1.1 11/19/2019 1404200X1 Citizens State Bank Clayton 1.35 4/30/2019 176688857 FFCB 1.51/28/2019 3133EDMF6 248.000.00 248,000.00 1.000.000.00 11/19/2014 1.10 248,000.00 248,000.00 100.75 0.74 249,872 15 1,001.51 0.12% 1,872.15 None None 780 2.11 9.,30/2015 248,000.00 100.46 249.128.90 0.12% None 1.35 248,000.00 1.06 0.00 1,128.90 None 5/28/2014 1,000,000.00 100.04 1.000,408 00 0.47% Moodys-Aaa 1.50 1.000,000.00 1.47 2,583.33 408.00 S&P -AA+ 577 1.57 485 1.32 FHLB 1 9/26/2019 9/22/2016 997,430.00 98.96 989,612.00 0.47% Moodys-Aaa 726 3'30A9EP2 1,000,000.00 1.09 998,302.47 1.53 111.11 -8,690.47 S&P -AA+ 1.97 First Business Bank 1.7 6/30/2020 9/3012015 248,000.00 99.59 246,970.80 0.12% None 1004 319380P40 248,000.00 1.70 248.000.00 1.86 0.00 -1,029.20 None 2.7 First Mid -III Bank & Trust 0.9 1/2/2018 6/30/2016 248,000.00 99.94 247,840 29 0.12% None 94 32086RBK5 248,000.00 0.90 248,000.00 1.15 0.00 -159.71 None 0.26 First National Bank of America 1.25 7/15/2016 248,000.00 97.40 241,558.70 0.12% None 1384 7/15/2021 32110YHMO 248,000.00 1.25 248,000.00 1.96 653.97 -6,441.30 None 3.7 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 98.70 244,764.10 0.12% None 1369 53362LAB0 248,000.00 1.40 248,000.00 1.76 275.86 -3,235.90 None 3.65 National Bank Commerce Superior 1.25 7/15/2016 248,000.00 98.34 243,885.43 0.12% None 15 7/15/2021-17 633368EB7 248.00000 1.25 248,000.00 1.70 127.40 1,114.57 None 3.7 Peoples United Bank 1.911119/2019 11/19/2014 248,000.00 100.74 249,825.28 0.12% None 780 71270QKM7 248.000.00 1.90 248,000.00 1.55 1,729.88 1,825.28 None 2.09 Revere Bank 1.35 6/29/2018 12/30/2014 248,000.00 100.04 248,107.63 0.12% None 761402AU0 248.000.00 1.35 248,000.00 1.29 9.17 107.63 None Texas Class LGIP 12/20/2016 17,047,573.78 100.00 17,047,573.78 8.05% None TX -01-0615.0001 17,047,573.78 1.25 17,047,573.78 1.25 0.00 None Prepared by Rick Overgaard 272 0.74 0 11 of 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description Face Amount CUSIP Shares Settlement Date YTM @ Cost Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Book Value YTM n Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity TexSTAR LGIP 02000-11110 Wells Fargo Sweep Cash WFSWEEP 5,036,980.65 11,228,520.84 Sub Total 506: General Obligation 38,289,075.27 8/26/2016 1.04 5,036,980.65 5.036,980.65 10/30/2008 11.228.520.84 0.05 11,228,520.84 38,286.505.27 0.88 38,287.377.74 100.00 1.04 5.036.980 65 100.00 11.228.520.84 0.05 0.90 38,266,714.37 7,306.55 2.38% 0.00 5.3% 0.00 -20,663.37 S&P•AAA None None None 0 0 89 0.26 550: W/S Impact Fee Bank United 1.2 11/21/2017 11/21/2014 248,000.00 100.03 248,067.70 0.12% Nene 52 066519AF6 248,000 00 1.20 248,000.00 1.00 1,076.25 67.70 None 0.14 Bankwest, Inc. 1.51/3/2020 3/4/2015 248,000.00 99.44 246,600.29 0.12% None 825 06652CFA4 248,000.00 1.50 248,000.00 1.76 275.18 -1.399.71 None 2.22 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 100.34 248,852.38 0.12% None 993 05580ABX1 248,000.00 2.10 248.000.00 1.97 1,469.65 852.38 None 2.64 Cedar Rapids Bank & Trust 1.5 1/30/2015 248,000.00 100.87 250,160.08 0.12% None 760 10/30/2019 150517CJ7 248,000.00 1.50 248,000.00 1.08 295.56 2,160.08 None 2.05 EVB Tepee Hannock VA 1.6 9/2512019 9/25/2015 248,000.00 100.65 249,614.48 0.12% None 725 26927ABK7 248,000.00 1.60 248,000.00 1.27 54.36 1,614.48 None 1,96 First Financial NW 1.3510/30/2019 10/30/2015 248.000.00 99.25 246,133.30 0.12% None 760 32022MAF5 248,000.00 1.35 248,000.00 1.72 0.00 -1,886.70 None 2.06 FNMA 0.875 5/21/2018 5/21/2014 985,050.00 99.74 997,444.00 0.47% Moodys-Aaa 233 3135GOWJ8 1,000,000.00 1.26 997.601.77 1.28 3,135.42 -157.77 S&P -AA+ 0.64 FNMA 1.375 3/13/2019-16 9/22/2016 1,009.560.00 99.77 997,708.00 0.47% Moodys-Aaa 529 3136G1FY0 1,000.000.00 0.98 1,005.611.54 1.54 649.31 -7,903.54 S&P -AA+ 1.44 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248.000.00 98.67 244,699.37 0.12% None 69413CFD6 248,000.00 1.25 248.000.00 1.75 0.00 -3,300.63 None Prepared by Rick Overgaard 1004 2.7 12 of 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9130/2017 Description CUSIP Face Amount 1 Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM a Cost Book Value YTM Lal Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP TX -01-0615-0001 37,745,748.58 Washington Trust Co 1.4 6/15/2018 940637GU9 248,000.00 12,20!2016 1.25 37,745,748.58 37,745,748.58 12/15/2014 248,000.00 1.40 248,000.00 100.00 1.25 37.745,748.58 100.06 248,151.28 17.82% 0.00 None None 0.12% None 1.31 1,017.82 151.28 None Welch State Bank 1.3 10/1/2018 949095AU7 248,000.00 9/30/2015 248,000.00 100.18 248,446.15 0.12% None 1.30 248,000.00 1.12 256.15 446.15 None 0 258 0.7 366 1 Wells Fargo Sweep Cash 5/31/2006 5,259,511.80 100.00 5.259,511.80 2.48% None 1 WFSWEEP 5.259,511.80 0.05 5,259,511.80 0.05 0.00 None 0 Wells FargoTWDBCash 11/1/2016 5,107,183.20 100.00 5,107,183.20 2.41% None 1 WF4102 5,107,183.20 0.05 5,107,183.20 0.05 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 10,847,599.61 100.00 10.847,599.61 5.12% None 1 WF4094 10,847,599.61 0.05 10,847.599.61 0.05 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 4,686.03 100.00 4.686.03 0% None 1 WF5875 4,686.03 0.09 4,686.03 0.09 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 11,765,901.95 100.00 11,765,901.95 5.56% None 1 WF5883 11,765,901.95 0.09 11,765,901.95 0.09 0.00 None 0 74,957,241.17 Sub Total 550: W/S Impact Fee 74,962,631.17 0.73 74,965,844.48 74,956,508.20 35.41% 0.74 8,229.70 -9,336.28 30 0.08 555: Shadow Creek Impact Evergreen Bank 1.2 6/29/2018 6/29/2015 248,000.00 99.92 247,793.17 0.12% None 272 300185CY9 248,000.00 1.20 248,000.00 1.31 8.15 -206.83 None 0.74 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 100.09 1.000,862.00 0.47% Moodys-Aaa 877 3132X0PW5 1,000,000.00 1.63 1,000,960.00 1.64 1,675.00 -98.00 S&P -AA+ 2.36 GUARANTY 133amp;T 1.35 5/29/2018 5/29/2014 248,000.00 100.02 248,046.87 0.12% None 400820BJ4 248,000.00 1.35 248,000.00 1.32 9.17 46.87 None 241 0.66 Prepared by Rick Overgaard 13of 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount / Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Manufacturers & Traders Tnist 1.2 6/25/2018 5647590V3 Wells Fargo Sweep Cash WFSWEEP Sub Total 555: Shadow Creek Impact 248,000 00 109,753.14 6/24/2015 248.000.00 1.20 248,000.00 109,753.14 0.05 109,753.14 5/31/2006 1,853.753.14 1.39 99.95 247,878.73 1.27 799.04 100.00 109,753 14 0.05 1,854,953.14 1,854, 713.14 1.41 1,854,333.91 2,491.36 0.12% -121.27 0.05% 0.00 None None None None 0.88% -379.23 268 0.73 0 578 1.56 560: Certificates of Obligation 1998 Wells Fargo Sweep Cash WFSWEEP Sub Total 560: Certificates of Obligation 1998 5/31/2006 261,325.51 100.00 261,325 51 0.12% None 1 261,325.51 0.05 261,325.51 0.05 0.00 None 0 261,325.51 261,325.51 0.12% 1 261,325.51 0.05 261,325.51 0.05 0.00 0 565: Revenue Bonds 1999 & 2003 Continental Bank 1.25 5/25/2018 11/26/2014 248,000.00 99.96 247,890.63 0.12% None 211163EN6 245 000.00 1.25 248.000.00 1.32 1,087.12 -109.37 None 237 0.65 FAMC 1.58/22/2019 2/22/2017 1,000,000.00 99.74 997,381.00 0.47% S&P -AA- 691 3132X0PV7 1,000,000.00 1.50 1,000,000.00 1.64 1,583.33 -2,619.00 Moodys-Aaa 1.87 GNB Bank 1,5 6130/2021 6/30/2016 248,000.00 98.70 244,770.30 0.12% None 1369 36198JCC6 248.000 00 1.50 248,000.00 1.86 0.00 3,229.70 None 3.65 Signature Bank 1,353/28/2019 9/29/2015 248,000.00 100.41 249,014.07 0.12% None 544 82669LFU2 248,000.00 1.35 248,000.00 1.07 18.35 1,014.07 None 1.48 Texas Class LGIP TX -01-0615-0001 1,007,849.74 1/15/2017 1,007,849.74 100.00 1,007,849.74 0.48% None 1 1.25 1,007,849.74 1.25 0.00 None 0 Wells Fargo Sweep Cash WFSWEEP Wells Fargo TWDB Cash WF5875 Prepared by Rick Overgaard 4,142,678.99 5/31/2008 4,142.678.99 100.00 4,142,678.99 1.96% None 0.05 4,142,678.99 0.05 0.00 None 10,000,000.00 9/15/2017 10,000,000.00 100.00 10,000,000.00 4.72% None 0.09 10,000.000.00 0.09 0.00 None 0 0 14 of 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount I Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total 565: Revenue Bonds 1999 & 2003 16,894,528.73 0.29 16,894,528.73 16.894,528.73 0.30 16,889.584.73 2,688.80 7.99% -4,944.00 73 0.2 570: WIS Pay As You Go Marine Bank Springfield IL 1.8 6/29/2021 56817TAB7 Wells Fargo Sweep Cash WFSWEEP Sub Total 570: WIS Pay As You Go 6/29/2017 248,000.00 99.60 247,020.15 0.12% None 248.000.00 1.80 248,000.00 1.91 12.23 -979.85 None 1368 363 12/31/2007 1,557,153.76 100.00 1,557,153.76 0.74% None 1 1,557.153.76 0.05 1.557,153.76 0.05 0.00 None 0 1.805.153.76 1,804,173.91 0.86% 189 1,805.153.76 0.29 1,805.153.76 0.31 12.23 -979.85 0.5 575: MUD 4 Capital Programs Wells Fargo Sweep Cash 2/1/2013 203,968.73 100.00 203,968.73 0.1% None WFSWEEP 203,968.73 0.05 203,968.73 0.05 0.00 None Sub Total 575: MUD 4 Capital Programs 203,968.73 203,968.73 0.1% 1 203,968.73 0.05 203,968.73 0.05 0.00 0 600: Water & Sewer BARCLAYS BANK OFLAWARF 1 95 5/6/2014 248,000.00 100.58 249.433.69 0.12% None 584 5/7;2019 06740KGU5 248,000.00 1.95 248,000.00 1.58 1,934.40 1.433.69 None 157 CDARS 1.05 6/15/2019 6/15/2017 500,000.00 100.00 500,000.00 0.24% None 623 CDARS061517 500,000.00 1.05 500,000.00 1.05 1,539.04 0.00 None 5.95 Eaglebank Bethesda 1.1512/1012018 3/9/2016 248.000.00 99.85 247,627.01 0.12% None 436 27002YCV6 248,000.00 1.15 248,000.00 1.28 164.09 -372.99 None 1.19 FAMC 1.58/22/2019 2/22/2017 2.001,700.00 99.74 1.994,762.00 0.95% S&P -AA+ 691 3132X0PV7 2,000,000.00 1.47 2.001,288.22 1.64 3.166.67 -6,526.22 Moodys-Aaa 1.87 FAMC 1.7210/312018 31315P5A3 1,000.000.00 FFC8 1.95 9117/2018 3133ED2C5 Prepared by Rick Overgaard 1.000,000.00 12/16/2013 997.890.00 100.39 1,003.884.00 0.47% Moodys-Aaa 368 177 999,556.50 1.33 8,456.67 4,327.50 S&P -AA+ 1 1/29/2014 1,014,770.00 100.58 1,005,756.00 0.47% Moodys-Aaa 352 1.62 1,003,072.66 1.35 704.17 2,683.34 S&P -AA* 0.96 15 of 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value / Portfolio Credit Rating Days To Call/Maturity Shares YTM (a) Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity FHLB 1.75 12/14/2018 3133768R5 1.000,000.00 12/16/2013 1.74 1,000.670.00 1,000,161.72 First Bank McComb MS 1.5 2/28/2019 6/30/2015 248,000.00 100.36 1.45 1,003.601 00 5 152.78 100.09 248.214.02 0.47% Moodys-Aaa 3,439.28 S&P -AA+ 440 1.19 0.12% None 319234AJ9 248,000.00 1.50 248,000.00 1.44 20.38 214.02 None First Eagle National Bank 1.45 11/21/2018 32008JAM5 FNMA 0.87510/26/2017 3135G0PQ0 516 1.4 11/21/2014 248,000.00 100.11 248.261.14 0.12% None 248,000.00 1.45 248,000.00 1.36 1,300.47 261.14 None 1,000,000.00 417 1.13 5/21/2014 995,150.00 99.99 999,887.00 0.47% Moodys-Aaa 1.02 999,897.89 1.03 3,743.06 -10.89 S&P -AA+ 26 0.07 FNMA 1.62511127/2018 7/16/2014 1,004.411.00 100.13 1.001.301.00 0.47% Moodys-Aaa 423 3135G0YT4 1.000,000.00 1.52 1,001,170.84 1.51 5,552.08 130.16 S&P -AA+ 1.15 - MB Financial Bank 11 3/18/2019 3/18/2016 248,000.00 99.84 247,610 14 0.12% None 534 55266CQU3 248,000.00 1.10 248,000.00 1.21 89.69 -389.86 None 1.46 Northem Bank &: Trust MA 1.1 7/12/2016 248.000.00 99.18 245.957.72 0.12% None 12 7/12/2019.17 66476QBH0 248,000.00 1.10 248.000.00 1.57 597.92 -2,042.28 None 1.76 Northwest Bank Boise Idaho 1 5 1/10/2019 4/10/2014 248,000.00 100.43 249.062.18 0.12% None 467 66736AAD1 248,000.00 1.50 248,000.00 1.16 203.84 1.062.18 None 1.27 OLDTOWN BANK 1.2 5/7/2018 6/6/2014 248,000.00 100.13 248,323.89 0.12% None 219 680540666 248,000.00 1.20 248,000.00 0.98 195.68 323.89 None 0.6 • Parkside Font Bank & Trust 1.3 7/18/2016 248.000.00 98.33 243,866.83 0.12% None 18 7/19/2021-17 70147ABX1 248.00000 1.30 248,000.00 1.75 105.99 -4,133.17 None 3.71 Portage County Bank 1.4 6/24/2021 6/24/2016 248.000.00 98.70 244,788.15 0.12% None 1363 73565NB05 248.000.00 1.40 248.000.00 1.76 57.07 -3,211.85 None 3.64 Texas Class LGIP 12/20/2016 3,537,859.90 100.00 3,537,859.90 1.67% None 1 TX -01.0615-0001 3.537,859.90 1.25 3,537,859.90 1.25 0.00 None 0 Prepared by Rick Overgaard 16 of 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description Face Amount 1 Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM a Market Accrued Interest Unre. GainlLoss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP 9,172,217.85 5,31/2006 0.05 9,172,217.85 9,172.217.85 22,704,668.75 Sub Total 600: Water 8 Sewer 22,690,077.75 0.85 22,695,225.58 100.00 0.05 0.83 9.172.217.85 22,692,413.52 32,984.00 4.33% 0.00 10.74% -2,812.06 None None 0 196 0.68 610: Solldwaste ac,.Hs Fargo Sweep Casn WFSWEEP -308,105.60 12/1/2006 -308,105.60 100.00 -308,105.60 -0.15' None 0.05 -308,105.60 0.05 0.00 None 0 -308.105.60 -308,105.60 -0.15% 1 Sub Total 610: Solldwaste 308,105.60 0.05 -308,105.60 0.05 0.00 0 700: Property Liability Ins Wells Fargo Sweep Cash 10/31/2006 636,011.85 100.00 636,011.85 0.3% None 1 WFSWEEP 636,011.85 0.05 636,011.85 0.05 0.00 None 0 636,011.85 636,011.85 0.3% 1 Sub Total 700: Property Liability Ins 636,011.85 0.05 636,011.85 0.05 0.00 0 701: Employee Benefit Fund Fargo Sweep Cash WFSWEEP 911/2007 121,289.14 100.00 121.289 14 0.06% None 121,289.14 0.05 121,289.14 0.05 0.00 None Sub Total 701: Employee Benefit Fund 1 0 121,289.14 121,289.14 0.06% 1 121.289.14 0.05 121,289.14 0.05 0.00 0 702: Health Claims Fund Wells Fargo Cash 7/21/2010 367.578.33 100.00 367.578 33 0.17% None 1 WF9871 367,578.33 0.05 367,578.33 0.05 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,348.017.39 100.00 2,348,017.39 1.11% None 1 WFSWEEP 2,348,017.39 0.05 2,348,017.39 0.05 0.00 None 0 2,715,595.72 2.715,595.72 1.28% 1 Sub Total 702: Health Claims Fund 2,715,595.72 0.05 2.715,595.72 0.05 0.00 0 Prepared by Rick Overgaard 17 of 18 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 9/30/2017 Description CUSIP Face Amount 1 Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM @ Cost Book Value YTM `a'� Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity TOTAL PORTFOLIO 211, 748,937.16 211,768,486.37 0.81 211.767.763.08 0.83 211,650,420.54 103,044.94 100.00% -117,342.54 129 0.4 Prepared by Rick Overgaard 18 of 18 PLAK1_ANJ City of Pearland Treasury Yield Curve Treasury 6/30/2017 9/30/2017 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year 0.84 1.00 1.11 1.20 1.34 1.49 1.77 2.19 0.99 1.05 1.17 1.28 1.38 1.51 1.80 2.20 2.50 2.00 - 1.50 1.00 - 0.50 0.00 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year ;• 6/30/2017 9/30/2017 Prepared by Rick Overgaard 1 of 1 Bank Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Pledged Collateral Reconciliation Report September 30, 2017 Account Number 807-1613395 001-3042841 7169195455 818-4567843 179-0121790 280-7409871 3542574094 3542574102 4827855883 4827855875 Bank Account Number Wells Fargo 100-7284258 Account Name Amount Credit Card Account - Sweep Account 44.334.491.23 False Alarm Reduction Program 282.519 73 Alvin ISD 2.302.655.92 EMS Payments - Health Claims 367,578.33 Escrow W&S Revenue Bonds. Series B 10,847,599.61 Escrow W&S Revenue Bonds, Series C 5,107,183.20 Texas Permanent Water & Sewer System F 11,765,901.95 Texas Permanent Water & Sewer System F 10,004,686 03 Total of Bank Balances Pledged Collateral for City FDIC Insurance S 85,012.616 00 100.085.331.10 500,000.00 S 100,585,331.10 Over (Under) Collateralized $ 15,572,715.10 Total % Collateralized Account Name Development Authority Total of Bank Balances Pledged Collateral for DAP FDIC Insurance 118.3% Amount 5.995,138.61 S 6,995,138.61 7,222,480.13 250,000.00 $ Over (Under) Collateralized $ Total % Collateralized Total % Collateralized Status 7,472,480.13 477,341.52 106.8% 117.4% Collateralized