Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2017-087 2017-05-08
RESOLUTION NO. R2017-87 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending March 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 March 2017. PASSED, APPROVED, AND ADOPTED this 8th day of May, A.D., 2017. ATTEST: APPROVED AS TO FORM: ,---try) G-ka/c-moi DARRIN M. COKER CITY ATTORNEY TOM REID MAYOR City of Pearland Quarterly Investment Report December 31, 2016 to March 31, 2017 RESOLUTION NO. R2017-87 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 1/31/2017 2/28/2017 3/31/2017 Total / Average Market Value 221,375,053.31 198,369,188.32 209,522,904.22 209,755,715.28 Book Value Unrealized Gain/Loss YTM @ Cost 221,392,203.31 198,375,518.94 209,610,246.82 209,792,656.36 -17,150.00 -6,330.62 -87,342.60 -36,941.07 0.49 0.58 0.75 0.61 Treasury 1 Year 0.83 0.82 1.01 0.89 Interest Earned Days To Maturity 76,259.03 83,735.66 113,615.31 273,610.00 160 203 192 184 7 // (It 4//, 5/►> Cynthia Pe-rson, Directoj/of Finance Date Rick Ov'rgaard .Assistant Finance Director Date Date Carrie Ditta, Accounting Supervisor Page 1 of 36 City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Begin Date: 12/31/2016, End Date: 3/31/2017 Security Type Allocation Security Type Cash Certificate Of Deposit FAMC Bond FFCB Bond FHLB Bond FHLMC Bond FNMA Bond Local Govemment Investment Pool Total / Average Book Value .12/31/2016 143,905,969.94 23,819,359.61 999,227.84 3,006,470.23 1,997,926.67 4,987,730.32 6,026,275.57 25,019,286.55 209,762,246.73 Portfolio Holdings as of 12/31/2016 • 68.6% -Cash 11.36% -Certificate O.. 0,48%-FAMC Bond • 1.43%-FFCB Bond • 0.95% -FHLB Bond 2.38%-FHLMC Bond • 2.87% -FNMA Bond • 11.93% -Local Govemm.. % of Portfolio 12/31/2016 68.60 11.36 0.48 1.43 0.95 2.38 2.87 11.93 100.00 Book Value 3/31/2017 72,642,183.22 22,824,359.61 7,003,281.91 3,005,417.97 1,998,106.52 6,988,749.20 6,025,347.17 89,122,801.22 209,610,246.82 % of Portfolio 3/31/2017 34.66 10.89 3.34 1.43 0.95 3.33 2.87 42.52 100.00 Portfolio Holdings as of 3/31/2017 Page 2 of 36 • 34.66% -Cash 10.89% -Certificate 0... * 3.34%-FAMC Bond • 1.43%-FFCB Bond * 0.95% -FHLB Bond 3.33%-FHLMC Bond • 2.87% -FNMA Bond C. 42.52% -Local Governor... City of Pearland Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date: 12/31/2016, End Date: 3/31/2017 Maturity Range Allocation Maturity Range 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 Total / Average Book Value 12/31/2016 169,173,256.49 744,000.00 750,540.63 492,818.98 4,740,658.55 11,961,413.02 9,702,162.49 4,992,211.95 7,205,184.62 209,762,246.73 % of Portfolio 12/31/2016 80.65 0.35 0.36 0.23 2.26 5.70 4.63 2.38 3.43 100.00 Book Value 3/31/2017 161,764,984.44 750,540.63 492,818.98 3,492,913.81 1,496,760.28 17,456,940.28 13,697,822.20 3,747,695.55 6,709,770.65 209,610,246.82 % of Portfolio 3/31/2017 77.17 0.36 0.24 1.67 0.71 8.33 6.53 1.79 3.20 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 - NMI 1 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 Page 3 of 36 • 12/31/2016 3/31/2017 City of Pearland Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date: 4/30/2016, End Date: 3/31/2017 Beginning BV + Month Accrued Interest 4/30/2016 103, 904, 850.37 5/31/2016 104,742,270.06 6/30/2016 100, 756,449.58 7/31/2016 139,949,607.34 8/31/2016 137,623,186.38 9/30/2016 127, 074, 266.80 10/31/2016 124,251, 905.99 11/30/2016 125,514,207.85 12/31/2016 185,281,943.15 1/31/2017 209,834,163.17 2/28/2017 221,477,158.53 3/31/2017 198,472, 951.80 Interest Earned During Period -BV 36,630.38 46,060.75 37,044.31 36,916.56 52,210.27 45,269.93 53,993.03 72,654.69 62,222.87 76,259.03 83,735.66 113,615.31 Realized Gain/Loss-BV 0.00 0.00 60.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Investment Average Capital Income -BV Base -BV TRR-BV 0.04 0.04 0.03 0.03 0.04 0.04 0.04 0.04 0.03 0.04 0.04 0.06 36,630.38 46,060.75 37,104.31 36,916.56 52,210.27 45,269.93 53,993.03 72,654.69 62,222.87 76,259.03 83,735.66 113,615.31 104,260,304.97 102,386,378.07 120,899,174.62 138,413,064.76 128,215,015.68 124,197,882.71 124,983,476.45 185,519,615.68 196,301,765.74 216,212,352.30 207,925,794.09 203,946,422.22 Annualized TRR-BV 0.42 0.54 0.37 0.32 0.49 0.44 0.52 0.47 0.38 0.42 0.48 0.67 Treasury 1 Year 0.56 0.59 0.55 0.51 0.57 0.59 0.66 0.74 0.87 0.83 0.82 1.01 Annualized TRR-BV 1.10 1.00 0.90 0.80 0.70 0.60 0.50 0.40 0.30 0.20 0.10 0.00 1 04/2016 05/2016 06/2016 1 I 1 1 07/2016 08/2016 09/2016 10/2016 11/2016 12/2016 01/2017 02/2017 03/2017 Page 4 of 36 • Portfolio Treasury 1 Year City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2017 Description CUSIP Face Amount / Shares Settlement Date YTM @ Cost Cost Value Book Value Market Price YTM @ 1114k° Market Value Accrued Interest % Portfolio Credit Rating Days To Call/Maturity Unre. Gain/Loss Credit Rating Duration To Maturity Cash Wells Fargo Cash WF9871 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 7/21/2010 118,408.08 100.00 118,408 08 118,408.08 0.09 118,408.08 0.09 0.05% 0.00 None None 12/31/2007 1,662,801.19 100.00 1,662,801.19 0.79% None 1,662,801.19 0.09 1,662,801.19 0.09 9/15/2010 2,556,261.23 100.00 2,556,261.23 2,556,261.23 0.09 2,556,261.23 0.09 Wells Fargo Sweep Cash 5/31/2006 2,875,395.14 100.00 2,875,395.14 WFSWEEP 2,875,395.14 0.09 2,875,395.14 0.09 Wells Fargo Sweep Cash 5/31/2006 741,236.87 100.00 741,236.87 WFSWEEP 741,236.87 0.09 741,236.87 0.09 Wells Fargo Sweep Cash 5/31/2006 5,994.60 100.00 5,994.60 WFSWEEP 5,994.60 0.09 5,994.60 0.09 Wells Fargo Sweep Cash 5/31/2006 446,553.90 100.00 446,553.90 WFSWEEP 446,553.90 0.09 446,553.90 0.09 Wells Fargo Sweep Cash 5/31/2006 143,532.83 100.00 143,532.83 WFSWEEP 143,532.83 0.09 143,532.83 0.09 Wells Fargo Sweep Cash 5/31/2006 532,472.00 100.00 532,472.00 WFSWEEP 532,472.00 0.09 532,472.00 0.09 Wells Fargo Sweep Cash 4/15/2012 725,951.52 100.00 725,951.52 WFSWEEP 725,951.52 0.09 725,951.52 0.09 Wells Fargo Sweep Cash 5/31/2006 6,485,953.23 100.00 6,485,953.23 WFSWEEP 6,485,953.23 0.09 6,485,953.23 0.09 0.00 None 1.22% 0.00 1.37% 0.00 0.35% 0.00 None None None None None None 0 0 0 0 0 0% None 1 0.00 None 0 0.21% None 1 0.00 None 0 0.07% None 1 0.00 None 0 0.25% None 1 0.00 None 0 0.35% None 1 0.00 None 0 3.09% None 1 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -12,386.47 100.00 -12,386.47 -C.01% Norte 1 WFSWEEP -12,386.47 0.09 -12,386.47 0.09 0.00 None 0 Page 5 of 36 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/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 Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP 14,876.22 5/31/2006 0.09 14,876.22 14,876.22 100.00 0.09 14,876.22 5/31/2006 57,069.13 100.00 57,069.13 57,069.13 0.09 57,069.13 0.09 0.00 0.01% 0.00 0.03% None None None None 10/30/2008 -930,096.66 100.00 -930,096.66 -0.44% None -930,096.66 0.09 -930,096.66 0.09 0.00 None Wells Fargo Sweep Cash 9/15/2009 21,992.22 100.00 21,992.22 0.01% None WFSWEEP 21,992.22 0.09 21,992.22 0.09 0.00 None 1 0 1 0 1 0 1 0 Wells Fargo Sweep Cash 5/31/2006 -1,136,646.46 100.00 -1,136,646.46 -0.54% None 1 WFSWEEP -1,136,646.46 0.09 -1,136,646.46 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 797,492.58 100.00 797,492.58 0.38% None 1 WFSWEEP 797,492.58 0.09 797,492.58 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 266,235.25 100.00 266,235.25 0.13% None 1 WFSWEEP 266,235.25 0.09 266,235.25 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 102,278.93 100.00 102,278.93 0.05% None 1 WFSWEEP 102,278.93 0.09 102,278.93 0.09 0.00 None 0 Wells Fargo Sweep Cash 6/30/2006 318,028.78 100.00 318,028.78 0.15% None 1 WFSWEEP 318,028.78 0.09 318,028.78 0.09 0.00 None 0 Wells Fargo Sweep Cash 10/31/2006 495,448.75 100.00 495,448.75 0.24% None 1 WFSWEEP 495,448.75 0.09 495,448.75 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 239,251.09 100.00 239,251.09 0.11% None 1 WFSWEEP 239,251.09 0.09 239,251.09 0.09 0.00 None 0 Wells Fargo Sweep Cash 9/1/2007 98,307.48 100.00 98,307.48 0.05% None 1 WFSWEEP 98,307.48 0.09 98,307.48 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -355,928.05 100.00 -355,928.05 -0.17% None 1 WFSWEEP -355,928.05 0.09 -355,928.05 0.09 0.00 None 0 Page 6 of 36 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2017 Description Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity 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 Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo TWDB Cash WF5883 Wells Fargo TWDB Cash WF5875 Wells Fargo TWD3 Cash WF4094 Wells Fargo TWDB Cash WF4102 3,335,147.78 -370.34 58,096.47 367,987.27 10,673.39 400,857.31 347,108.80 -55,396.71 14,195,645.73 11,760,593.98 10, 000,172.60 10,845,152.49 5,106, 031.07 5/31/2006 0.09 3,335,147.78 3,335,147.78 100.00 0.09 3,335,147.78 12/1/2009 -370.34 100.00 -370.34 0.09 -370.34 0.09 0.00 1.59% 0.00 0% 5/31/2006 58,096.47 100.00 58,096.47 0.03% 0.00 0.09 58,096.47 0.09 None None None None None None 5/31/2006 367,987.27 100.00 367,987.27 0.18% None 0.09 367,987.27 0.09 0.00 None 1 0 1 0 1 0 1 0 5/31/2008 10,673.39 100.00 10,673.39 0.01% None 1 0.09 10,673.39 0.09 0.00 None 0 2/1/2013 400,857.31 100.00 400,857.31 0.19% None 1 0.09 400,857.31 0.09 0.00 None 0 12/1/2006 347,108.80 100.00 347,108.80 0.17% None 1 0.09 347,108.80 0.09 0.00 None 0 11/15/2015 -55,396.71 100.00 -55,396.71 -0.03% None 1 0.09 -55,396.71 0.09 0.00 None 0 5/31/2005 14,195,645.73 100.00 14,195,645.73 6.77% None 1 0.09 14,195,645.73 0.09 0.00 None 0 3/15/2017 11,760,593.98 100.00 11,760,593.98 5.61% None 1 0.03 11,760,593.98 0.03 0.00 None 0 3/15/2017 10,000,172.60 100.00 10,000,172.60 4.77% None 1 0.03 10,000,172.60 0.03 0.00 None 0 11/1/2016 10,845,152.49 100.00 10,845,152.49 5.17% None 1 0.05 10,845,152.49 0.05 0.00 None 0 11/1/2016 5,106,031.07 100.00 5,106,031.07 2.44% None 1 0.05 5,106,031.07 0.05 0.00 None 0 Page 7 of 36 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/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 Sub Total Cash Certificate Of Deposit 1st Security Bank of Wash 1.1 1/22/2021 33625CAZ2 1st Source Bank 1.5 11/18/2019 33646CEQ3 Allegiance Bank 0.6 9/13/2017 2611523C Alma Bank 1.35 12/24/2020 020080682 American Eagle Bank IL 1.35 7/12/2021 025548CM1 Bank Leumi USA 1.3 2/26/2020 063248FH6 Bank of New England NH 1.4 6/30/2021 063847AL1 Bank of the Pacific 1.25 7/30/2018 06425BBN8 Bank United 1.2 11/21/2017 066519AF6 Bankers Bank Oklahoma 1.8 9/25/2020 06610QCV1 72,642,183.22 0.06 7/22/2018 248,000.00 1.10 4/17/2015 248, 000.00 1.50 9/13/2016 247,818.98 0.60 6/24/2016 248,000.00 1.35 7/11/2016 248,000.00 1.35 3/3/2016 246,000.00 1.30 6/30/2016 248,000.00 1.40 1/29/2015 248, 000.00 1.25 11/21/2014 248, 000.00 1.20 9/25/2015 248,000.00 1.80 Bankwest, Inc. 1.5 1/3/2020 3/4/2015 06652CFA4 248,000.00 1.50 72,642,183.22 72,642,183.22 248, 000.00 248, 000.00 0.06 97.05 1.90 72,642,183.22 240,878.79 67.27 34.66% 0.00 0.12% -7,321.21 None None 248,000.00 100.56 249,395.25 0.12% None 248,000.00 1.28 1,681.64 1,395.25 None 247,818.98 100.00 247,818.98 0.12% None 247,818.98 0.60 0.00 0.00 None 248,000.00 98.06 243,183.10 0.12% None 248,000.00 1.89 64.21 -4,816.90 None 248,000.00 97.82 242,591.62 0.12% None 248,000.00 1.88 183.45 -5,408.38 None 248,000.00 100.36 248,884.62 0.12% None 248,000.00 1.18 291.48 884.62 None 248,000.00 98.28 243,743.33 0.12% None 248.000.00 1.82 9.51 -4,256.67 None 248,000.00 99.96 247,900.55 0.12% None 248,000.00 1.28 509.59 -99.45 None 248,000.00 100.20 248,499.22 0.12% None 248,000.00 0.89 1,059.95 499.22 None 248,000.00 101.38 251,416.94 0.12% None 248,000.00 1.40 73.38 3,416.94 None 248,000.00 99.45 246,627.07 0.12% None 248,000.00 1.71 285.37 -1,372.93 None Page 8 of 36 1 0 1393 3.73 962 2.58 166 0.45 1364 3.64 1564 4.16 1062 2.86 1552 4.12 486 1.32 235 0.64 1274 3.38 1008 2.7 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/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 BARCLAYS BANK DELAWARE 1.95 5/7/2019 06740KGU5 Belmont Savings Bank 1.85 12/23/2019 080515BD0 BMO Harris Bank 1.05 6/22/2018 05581WHF5 BMW Bank 2.1 6/19/2020 05580ABX1 248,000.00 5/6/2014 1.95 12/23/2014 248,000.00 100.88 250,187.86 0.12% None 248,000.00 1.85 248,000.00 1.52 1,231.85 2,187.86 None 248,000.00 248, 000.00 100.84 1.54 250,093.86 1,907.90 0.12% 2,093.86 None None 248,000.00 248,000.00 6/23/2016 248,000.00 99.75 1.05 248,000.00 1.26 6/19/2015 248,000.00 100.58 2.10 248,000.00 1.91 767 2.05 997 2.66 247,376.03 0.12% None 448 699.16 -623.97 None 1.22 249,433.44 0.12% None 1176 1,455.39 1,433.44 None 3.11 Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 97.48 241,746.93 0.12% None 1552 099703EF3 Capital Bank Little Rock 1.35 3/22/2019 139797FL3 248,000.00 248,000.00 1.40 248,000.00 2.02 9/23/2015 248,000.00 100.66 1.35 248,000.00 1.01 9.51 -6,253.07 None 4.12 249,645.23 0.12% None 721 82.55 1,645.23 None 1.95 Capital One Bank USA 1.1 11/19/2019 11/19/2014 248,000.00 101.04 250,586.64 0.12% None 963 140420QX1 Capital One NA 2.3 9/25/2020 14042RAB7 248,000.00 1.10 248,000.00 0.70 9/23/2015 248, 000.00 101.40 986.56 2,586.64 None 2.59 251,468.28 0.12% None 1274 248,000.00 2.30 248,000.00 1.88 93.76 3,468.28 None 3.37 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 98.41 244,053.33 0.12% None 1214 144153AW3 CDARS 0.5 6/15/2017 1019146991 248,000.00 500,000.00 1.10 248,000.00 1.59 29.90 -3,946.67 None 3.26 6/16/2016 500,000.00 100.00 500,000.00 0.24% None 76 0.50 500,000.00 0.50 1,972.60 0.00 None 0.21 CDARS 0.7 12/13/2018 12/15/2016 500,000.00 100.00 500,000.00 0.24% None 1019720221 500,000.00 0.70 500,000.00 0.70 834.25 0.00 None 622 1.7 CDARS 0.9 6/14/2018 6/16/2016 500,000.00 100.00 500,000.00 0.24% None 440 1019145928 500,000.00 0.90 500,000.00 0.90 1,072.60 0.00 None 1.2 Page 9 of 36 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/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 Cedar Rapids Bank & Trust 1.5 10/30/2019 150517CJ7 Charter Bank 1.7 2/25/2020 161164BE7 Cit Bank Salt Lake 2.1 11/19/2019 17284C3Z5 Citizens State Bank Clayton 1.35 4/30/2019 176688BS7 248,000.00 248,000.00 248,000.00 248,000.00 1/30/2015 1.50 248,000.00 248,000.00 2/25/2015 248,000.00 101.19 1.03 250,950.46 305.75 99.90 247,762.66 1.70 248,000.00 1.73 11/19/2014 248,000.00 101.07 2.10 248,000.00 1.68 0.12% 2,950.46 None None 0.12% None 943 2.53 1061 69.30 -237.34 None 2.83 250,650.38 0.12% None 963 1,883.44 2,650.38 None 2.56 9/30/2015 248,000.00 100.69 249,705.74 0.12% None 760 1.35 248,000.00 1.02 9.17 1,705.74 None 2.05 Comenity Capital Bank 1.7 5/28/2018 11/26/2014 248,000.00 100.31 248,774.26 0.12% None 20033AJL1 Commerc'al Bank Ala Mich 1.5 3/29/2019 201282GV6 248,000.00 1.70 248,000.00 1.43 6/30/2015 248,000.00 99.89 248,000.00 1.50 248,000.00 1.56 57.75 774.26 None 423 1.15 247,725.46 0.12% None 728 20.38 -274.54 None 1.97 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 98.29 243,752.50 0.12% None 203507BG2 248,000.00 1.50 248,000.00 1.92 10.19 -4,247.50 None Community Bankers' Bank 1.4 6/30/2016 248,000.00 98.28 6/30/2021 20361 LBR4 248,000.00 1.40 248,000.00 1.82 Community National Bank Interest 1.25 4/4/2014 248,000.00 100.10 4/4/2018 20375WAM6 248,000.00 1.25 248,000.00 1.15 ConnectOne Bank 1.55 7/30/2018 1/30/2014 248,000.00 100.66 20786AAM7 248,000.00 1.55 248,000.00 1.05 Continental Bank 1.25 5/25/2018 11/26/2014 211163EN6 248,000.00 1.25 248,000.00 248,000.00 Discover Bank 2 2/25/2020 2/25/2015 248,000.00 254672JA7 248,000.00 2.00 248,000.00 Page 10 of 36 243,743.33 9.51 248,254.94 1,511.78 249,630.10 1552 4.12 0.12% None 1552 -4,255.67 None 4.12 0.12% None 369 254.94 None 1 0.12% None 0.00 1,630.10 None 100.05 248,126.23 1.21 1,070.14 100.75 249,856.03 1.73 462.03 486 1.32 0.12% None 420 126.23 None 1.14 0.12% None 1,856.03 None 1061 2.83 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/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 Eaglebank Bethesda 1.1512/10/2018 27002YCV6 EVB Tappa Hannock VA 1.6 9/25/2019 26927ABK7 Evergreen Bank 1.2 6/29/2018 300185CY9 Exchange Bank NEB 1.05 1/21/2020 301074CH1 Fahey Banking 1.1 6/28/2019 303117CC7 Farmers & Merchants Bank 1.45 9/25/2018-14 308862DD0 FIRST BANK HIGHLAND PARK 1.85 5/7/2019-14 3191419L0 First Bank McComb MS 1.5 2/2812019 319234AJ9 248,000.00 248,000.00 3/9/2016 1.15 248, 000.00 248,000.00 9/25/2015 248,000.00 99.98 1.16 247,949.66 171.90 100.92 250,281.35 1.60 248,000.00 1.22 6/29/2015 248,000.00 100.01 0.12% -50.34 None None 0.12% None 65.23 2,281.35 None 619 1.68 908 2.44 248,015.87 0.12% None 455 248,000.00 1.20 248,000.00 1.20 16.31 15.87 None 1.24 7/20/2016 248,000.00 98.18 243,491.11 0.12% None 1026 248,000.00 1.05 248,000.00 1.71 78.48 -4,508.89 None 2.77 3/29/2016 248,000.00 99.92 247,802.34 0.12% None 819 248,000.00 1.10 248,000.00 1.14 22.42 -197.66 None 2.22 4/25/2014 248,000.00 100.04 248,108.87 0.12% None 25 248,000.00 1.45 248,000.00 1.42 59.11 108.87 None 1.47 5/7/2014 248,000.00 100.10 248,247.26 0.12% None 37 248,000.00 1.85 248,000.00 1.80 1,810.06 247.26 None 2.06 6/30/2015 248,000.00 100.24 248,590.24 0.12% None 699 248,000.00 1.50 248,000.00 1.37 30.58 590.24 None 1.88 First Business Bank 1.7 6/30/2020 9/30/2015 248,000.00 99.69 247,229.71 0.12% None 1187 31938QP40 First Capital Bank 1.4 8/6/2019 31944FBK5 248, 000.00 248,000.00 1.70 248,000.00 1.80 4/6/2015 248,000.00 100.42 1.40 248,000.00 1.22 11.55 -770.29 None 3.17 249,049.04 0.12% None 858 237.81 1,049.04 None 2.31 First Eagle National Bank 1.45 11/21/2018 11/21/2014 248,000.00 100.35 248,876.68 0.12% None 600 32008JAM5 248,000.00 1.45 248,000.00 1.23 1,280.77 876.68 None 1.62 First Financial NW 1.35 10/30/2019 10/30/2015 248,000.00 99.19 245,990.95 0.12% None 943 32022MAF5 248,000.00 1.35 248,000.00 1.67 0.00 -2,009.05 None 2.54 Page 11 of 36 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2017 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To CaII/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity First Intl Bank & Trust 1.6 1/16/2020 32057GAE9 First Mid -III Bank & Trust 0.9 1/2/2018 32086RBK5 First National Bank 1.6 3/19/2018 CD32115CBE7 248,000.00 248,000.00 10/16/2015 1.60 248,000.00 248,000.00 6/30/2016 248,000.00 99.69 1.71 247,238.89 163.07 99.95 247,873.77 0.90 248,000.00 0.97 9/18/2013 248,000.00 1.60 0.12% -761.11 None None 0.12% None 6.12 -126.23 None 248,000.00 100.64 249,575.79 0.12% None 248,000.00 0.94 130.45 1,575.79 None 102- 2.73 277 0.75 353 0.96 First National Bank of America 1.25 7/15/2016 248,000.00 96.80 240,056.56 0.12% None 1567 7/15/2021 32110YHM0 248,000.00 1.25 248,000.00 2.03 636.99 -7,943.44 None 4.18 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 98.29 243,752.50 0.12% None 1552 36198JCC6 248,000.00 1.50 248,000.00 1.92 10.19 -4,247.50 None 4.12 Goldman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 100.75 249,856.03 0.12% None 38148JLL3 GUARANTY B&T 1.35 5/29/2018 400820BJ4 Gulf Coast Bank & Trust 1.3 7/15/2021- 17 402194EX8 JP Morgan Chase Bk NA Columbus 2.1 2/15/2021-17 48126XVW2 Lincoln 1st Bank 1.4 6/30/2021 53362LAB0 248,000.00 248,000.00 2.00 248,000.00 1.73 5/29/2014 248,000.00 100.16 1.35 248,000.00 1.21 462.03 1,856.03 None 1061 2.83 248,399.78 0.12% None 424 18.35 399.78 None 1.15 7/15/2016 248,000.00 97.84 242,552.62 0.12% None 106 248,000.00 1.30 248,000.00 1.82 141.33 -5,347.38 None 4.17 2/15/2017 245,000.00 100.68 246,666.24 0.12% None 15 245,000.00 2.10 245,000.00 1.92 225.53 1,666.24 None 3.72 6/30/2016 248,000.00 98.28 243,743.33 0.12% None 1552 248,000.00 1.40 248,000.00 1.82 285.37 -4,256.67 None 4.12 Luana Savings Bank 1.25 6/19/2018 12/19/2014 248,000.00 100.02 248,048.36 0.12% None 445 549103QQ5 248,000.00 1.25 248,000.00 1.23 866.30 46.36 None 1.21 Machias Savings Bank 1.65 2/6/2020 2/6/2015 248,000.00 101.30 251,227.97 0.12% None 1042 554479DS1 248,000.00 1.65 248,000.00 1.19 280.27 3,227.97 None 2.78 Page 12 of 36 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2017 Description CUSIP Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Face Amount / Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Mahopac Bank 1.45 7/30/2019 560160AQ6 248,000.00 1/30/2015 1.45 Manufacturers & Traders Trust 1.2 6/25/2018 564759QV3 Marlin Business Bank 1.25 12/27/2019 57116AMC9 MB Financial Bank 1.1 3/18/2019 248,000.00 248,000.00 6/242015 248,000.00 248,000.00 1.20 248,000.00 101.03 1.01 250,543.24 591.12 0.12% 2,543.24 None None 100.06 248,149.30 0.12% None 851 2.3 451 1.15 790.88 149.30 None 1.23 6/29/2016 248,000.00 98.87 245,203.80 0.12% None 1001 248,000.00 1.25 248,000.00 1.67 16.99 -2,796.20 None 2.69 3/18/2016 248,000.00 99.90 247,740.10 0.12% None 55266CQU3 248,000.00 1.10 248,000.00 1.15 97.16 -259.90 None Moody National Bank 0.5 5/30/2017 7130E National Bank Commerce Superior 1.25 7/15/2021-17 633368E67 Nebraskaland National Bank 1.2 9/25/2018 63970QFC5 Northern Bank & Trust MA 1.1 7/12/2019-17 66476QBH0 Northwest Bank Boise Idaho 1.5 1/10/2019 66736AAD1 717 1.94 11/30/2016 250,540.63 100.00 250,540.63 0.12% None 60 250,540.63 0.50 250,540.63 0.50 415.28 0.00 None 0.16 7/15/2016 248,000.00 97.84 242,652.38 0.12% None 106 248,000.00 1.25 248,000.00 1.77 135.89 -5,347.62 None 4.18 9/25/2015 248,000.00 100.52 249,291.09 0.12% None 543 248,000.00 1.2D 248,000.00 0.85 48.92 1,291.09 None 1.47 7/12/2016 248,000.00 99.06 245,657.89 0.12% None 12 248,000.00 1.10 248,000.00 1.52 582.97 -2,342.11 None 2.25 4/10/2014 248,000.00 100.76 249,878.85 0.12% None 650 248,000.00 1.50 248,000.00 1.07 214.03 1,878.85 None 1.75 OLDTOWN BANK 1.2 5/7/2018 6/6/2014 248,000.00 100.35 248,879.66 0.12% None 402 680540886 248,000.00 1.20 248,000.00 0.88 203.84 879.66 None 1.09 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 98.62 244,567.93 0.12% None 1187 69413CFD6 248,000.00 1.25 248,000.00 1.69 8.49 -3,432.07 None 3.18 Parkside Finl Bank &: Trust 1.3 7/18/2016 248,000.00 97.82 242,603.77 0.12% None 109 7/19/2021-17 70147ABX1 248,000.00 1.30 248,000.00 1.83 114.83 -5,396.23 None 4.18 Page 13 of 36 t'ErRLAND City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3131/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 Partners Bank 1.5 9/30/2019 70212YAR3 Pearland State Bank 0.15 7/24/2017 700013947A Peoples United Bank 1.9 11/19/2019 71270QKM7 Portage County Bank 1.4 6/24/2021 73565NBQ5 248,000.00 245,000.00 3/30/2015 1.50 248,000.00 248,000.00 7/24/2016 245,000.00 0.15 245,000.00 100.72 1.21 249,790.31 0.00 100.00 245,000.00 0.15 251.71 0.12% 1,790.31 None None 0.12% None 0.00 None 11/19/2014 248,000.00 101.02 250,530.84 0.12% None 248,000.00 1.90 248,000.00 1.50 1,704.07 2,530.84 None 248,000.00 6/24/2016 248,000.00 98.31 1.40 248,000.00 1.82 913 2.46 115 0.32 963 2.57 243,812.02 0.12% None 1546 66.59 -4,187.98 None 4.11 Quantum National Bank 1.2 9/18/2019-16 3/18/2016 248,000.00 99.11 245,794.29 0.12% None 79 74765JET1 Revere Bank 1.35 6/29/2018 7614C2AU0 248,000.00 1.20 248,000.00 1.57 105.99 -2,205.71 None 2.43 12/30/2014 248,000.00 100.22 248,533.94 0.12% None 248,000.00 1.35 248,000.00 1.18 18.35 533.94 None Sallie Mae Bank 2.15 11/19/2019 11/19/2014 248,000.00 101.04 250,584.41 0.12% None 795450VC6 Seiling State Bank OK 1.55 7/7/2021-17 816050AA6 248, 000.00 2.15 248,000.00 1.74 1,928.28 2,584.41 None 7/7/2016 248,000.00 98.30 243,788.46 0.12% None 248,000.00 1.55 248,000.00 1.97 252.76 .4,211.54 None 455 1.23 963 2.56 7 4.13 Signature Bank 1.35 3/28/2019 9/29/2015 248,000.00 100.64 249,575.05 0.12% None 727 B2669LFU2 Silvergate Bank 1 6/29/2018-16 828373FE5 248, 000.00 248, 000.00 1.35 248,000.00 1.03 6/29/2016 248,000.00 99.76 1.00 248,000.00 1.19 27.52 1,575.05 None 1.97 247,411.74 0.12% None 28 13.59 -588.26 None 1.24 Trust Atlantic Bank 1.45 12/6/2017 11/6/2013 248,000.00 100.50 249,237.77 0.12% None 250 89835FJC5 248,000.00 1.45 248,000.00 0.72 246.30 1,237.77 None 0.68 Unity Bank 1.65 10/30/2020 91330ABCO Vision Bank of Iowa 1.3 7/12/2021 248,000.00 10/30/2015 248,000.00 101.36 1.65 248,000.00 1.26 251,361.89 0.12% None 1309 0.00 3,361.89 None 3.48 7/11/2016 248,000.00 97.82 242,600.54 0.12% None 1564 92834CBW1 248,000.00 1.30 248,000.00 1.83 697.80 -5,399.46 None 4.17 Page 14 of 36 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/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 Washington Federal 1.5 3/31/2021-16 938828AC4 248,000.00 3/31/2016 1.50 Washington Trust Co 1.4 6/15/2018 940637G U 9 248, 000.00 Webster Bank NA 1.9 2/12/2019 248,000.00 94768NJM7 Welch State Bank 1.3 10/1/2018 949095AU7 248,000.00 Wells Fargo Bank 1.75 6/17/2021 9497485W3 248, 000.00 248,000.00 248,000.00 12/15/2014 248,000.00 99.04 1.75 245,625.15 0.00 100.24 248,592.72 1.40 248,000.00 1.20 2/12/2014 248,000.00 100.72 0.12% -2,374.85 None None 0.12% None 1,008.31 592.72 None 30 3.88 44" 1.2 249,790.56 0.12% None 683 1.90 248,000.00 1.51 606.75 1,790.56 None 1.84 9/30/2015 248,000.00 100.50 1.30 248,000.00 0.96 6/20/2016 248,000.00 98.36 1.75 248,000.00 2.16 Sub Total Certificate Of Deposit 22,824,359.61 1.37 FAMC Bond 22,824,359.61 22,824,359.61 249,242.48 0.12% None 264.99 1,242.48 None 549 1.49 243,921.89 0.12% None 1539 166.47 -4,078.11 None 4.06 22,777,890.78 11.04% 746 1.37 37,601.42 -46,468.83 2.35 FAMC 1.5 8/22/2019 2/22/2017 2,001,700.00 100.27 2,005,454.00 0.95% S&P -AA+ 3132X0PV7 2,000,000.00 1.47 2,001,625.33 1.38 3,250.00 3,827.67 Moodys-Aaa FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 100.27 1,002,727.00 0.48% S&P -AA+ 3132X0PV7 1,000,000.00 1.50 1,000,000.00 1.38 1,625.00 2,727.00 Moodys-Aaa FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 100.27 1,002,727.00 0.48% S&P -AA+ 3132X0PV7 1,000,000.00 1.50 1,000,000.00 1.38 1,625.00 2,727.00 Moodys-Aaa FAMC 1.575 2/24/2020 2/24/2017 1,001,200.00 100.08 1,000,819.00 0.48% Moodys-Aaa 3132X0PW5 1,000,000.00 1.63 1,001,158.69 1.65 1,721.53 -339.89 S&P -AA+ FAMC 1.575 2/24/2020 2/24/2017 1,001,200.00 100.08 1,000,819.00 0.48% Moodys-Aaa 3132X0PW5 1,000,000.00 1.63 1,001,158.89 1.65 1,721.53 -339.89 S&P -AA+ FAMC 1.7210/3/2018 12/16/2013 997,890.00 100.70 1,006,987.00 0.48% Moodys-Aaa 31315P5A3 1,000,000.00 1.77 999,337.80 1.25 8,504.44 7,649.20 S&P -AA+ 7,001,990.00 Sub Total FAMC Bond 7,000,000.00 1.57 7,003,281.91 Page 15 of 36 1.44 874 2.35 874 2.35 874 2.35 1060 2.84 1060 2.84 551 1.48 7,019,633.00 3.35% 881 18,447.60 16,251.09 2.37 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2017 Description Settlement Date Cost Value Market Price Market Value Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest % Portfolio Credit Rating Days To Call/Maturity Unre. Gain/Loss Credit Rating Duration To Maturity FFCB Bond FFCB 1.34 12/29/2017 3133EDE99 FFCB 1.5 1/28/2019 3133EDMF6 1/29/2014 1, 004, 000.00 100.18 1,001,776.00 1,000,000.00 1.24 1,000,760.28 1.10 3,424.44 0.48% Moodys-Aaa 1,015.72 S&P -AA+ 5/28/2014 1,000,000.00 100.37 1,003,654.00 0.48% Moodys-Aaa 1,000,000.00 1.50 1,000,000.00 1.30 2,625.00 3,654.00 S&P -AA+ 273 0.74 668 1.8 FFCB 1.95 9/17/2018 1/29/2014 1,014,770.00 101.05 1,010,470.00 0.48% Moodys-Aaa 535 3133ED2C5 1,000,000.00 1.62 1,004,657.69 1.23 758.33 5,812.31 S&P -AA+ 1.45 3,018,770.00 3,015,900.00 1.44% 492 Sub Total FFCB Bond 3,000,000.00 1.45 3,005,417.97 1.21 6,807.77 10,482.03 1.33 FHLB Bond FHLB 1 9/26/2019 9/22/2016 997,430.00 98.91 989,084.00 0.48% Moodys-Aaa 909 3130A9EP2 1,000,000.00 1.09 997,878.09 1.45 138.89 4,794.09 S&P -AA+ 2.46 FHLB 1.75 12/14/2018 12/16/2013 1,000,670.00 100.84 1,008,365.00 0.48% Moodys-Aaa 623 313376BR5 1,000,000.00 1.74 1,000,228.43 1.25 5,201.39 8,136.57 S&P -AA+ 1.68 1,998,100.00 1,997,449.00 0.96% 766 Sub Total FHLB Bond 2,000,000.00 1.41 1,998,106.52 1.35 5,340.28 -657.52 2.07 FHLMC Bond FHLMC 1 9/29/2017 1/29/2014 994,150.00 100.02 1,000,223.00 0.48% Moodys-Aaa 182 3137EADL0 1,000,000.00 1.16 999,211.14 0.96 55.56 1,011.86 S&P -AA+ 0.49 FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 96.56 965,637.00 0.47% Moodys-Aaa 1595 3137EAEC9 1,000,000.00 1.37 989,770.65 1.95 1,375.00 -24,133.65 S&P -AA+ 4.26 FHLMC 1.35 12/17/2018-15 6/19/2015 999,525.00 100.03 1,000,319.00 0.48% S&P -AA+ 626 3134G6S95 1,000,000.00 1.36 999,767.41 1.33 3,900.00 551.59 Moodys-Aaa 1.69 FHLMC 1.42 3/29/2019-17 3/29/2017 2,000,000.00 100.00 2,000,058.00 0.95% S&P -AA+ 182 3134GA6G4 2,000,000.00 1.42 2,000,000.00 1.42 157.78 58.00 Moodys-Aaa 1.97 FHLMC 212/13/2021-17 12/13/2016 1,000,000.00 98.75 987,478.00 0.48% S&P -M+ 74 3134GAZD9 1.000,000.00 2.00 1,000,000.00 2.28 6,000.00 -12,522.00 None 4.48 Page 16 of 36 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2017 Description CUSIP Face Amount 1 Shares Settlement Date Cost Value Market Price Market Value I. Portfolio Credit Rating Days To Call/Maturity YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity FHLMC 2 12/13/2021-17 3134GAZD9 Sub Total FHLMC Bond FNMA Bond FNMA 0.875 10/26/2017 3135GOPQ0 1,000, 000.00 12/13/2016 2.00 7,000,000.00 1.53 1,000,000.00 1,000,000.00 6,982,215.00 6,988,749.20 98.75 2.28 1.66 987,478.00 6,000.00 6,941,193.00 17,488.34 0.49% -12,522.00 3.34% -47,556.20 S&P -AA+ None 74 4.48 415 2.76 5/21/2014 995,150.00 99.93 999,277.00 0.48% Moodys-Aaa 209 1,000,000.00 1.02 999,194.94 1.00 3,767.36 82.06 S&P -AA+ 0.57 FNMA 0.875 12/20/2017 5/21/2014 992,573.21 99.85 998,526.00 0.48% Moodys-Aaa 264 3135G0RT2 1,000,000.00 1.09 998,507.73 1.08 2,454.86 18.27 S&P -AA+ 0.72 FNMA 0.875 5/21/2018 5/21/2014 985,050.00 99.66 996,588.00 0.48% Moodys-Aaa 416 3135G0WJ8 1,000,000.00 1.26 995,743.40 1.18 3,159.72 844.60 S&P -AA+ 1.13 FNMA 1.375 3/13/2019-16 9/22/2016 1,009,560.00 100.08 1,000,780.00 0.48% Moodys-Aaa 712 3136G1FY0 1,000,000.00 0.98 1,007,532.12 1.33 687.50 -6,752.12 S&P -AA+ 1.93 FNMA 1.625 11/27/2018 7/16/2014 1,004,411.00 100.61 1,006,118.00 0.48% Moodys-Aaa 606 3135G0YT4 1,000,000.00 1.52 1,001,673.43 1.25 5,597.22 4,444.57 S&P -AA+ 1.63 FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 100.47 1,004,665.00 0.49% Moodys-Aaa 1368 3135G0H55 1,000,000.00 1.25 1,022,695,55 1.75 4,843.75 -18,030.55 S&P -AA+ 3.61 6,012,624.21 6,005,954.00 2.89% 599 Sub Total FNMA Bond 6,000,000.00 1.19 6,025,347.17 1.27 20,510.41 -19,393.17 1.61 Local Government Investment Pool Texas Class LGIP 12/20/2016 5,511,609.42 100.00 5,511,609.42 2.63% None 1 TX -01-0615-0001 5,511,609.42 1.00 5,511,609.42 1.00 0.00 None 0 Texas Class LGIP 12/20/2016 7,015,315.62 100.00 7,015,315.62 3.35% None 1 TX -01-0615-0001 7,015,315,62 1.00 7,015,315.62 1.00 0.00 None 0 Texas Class LGIP 1/15/2017 15,029,637.11 100.00 15,029,637.11 7.17% None 1 TX -01-0615-0001 15,029,637.11 1.00 15,029,637.11 1.00 0.00 None 0 Page 17 of 36 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date: 3/31/2017 Description CUSIP Face Amount / Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To CaII/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP TX -01-0615-0001 Texas Class LGIP TX -01-0615-0001 Texas Class LGIP TX -01-0615-0001 Texas Class LGIP 7, 015, 315.62 12/20/2016 1.00 7,015,315.62 7,015, 315.62 12/20/2016 42,517.904.26 42,517,904.26 1.00 42,517,904.26 1/15/2017 1,001,975.81 1,001, 975.81 1.00 1,001,975.81 100.00 7,015,315.62 100.00 42,517,904.26 20.28% 1.00 3.35% 0.00 1.00 100.00 1.00 1/15/2017 1,001,975.81 100.00 TX -01-0615-0001 1, 001, 975.81 1.00 1,001,975.81 1.00 TexSTAR LGIP 8/26/2016 5,014,705.98 100.00 C2000-11110 5,014,706.98 0.63 5,014,706.98 0.63 TexSTAR LGIP 8/26/2016 5,014,360.59 100.00 0200C-11110 5,014,360.59 0.63 5,014,360.59 0.63 1,001,975.81 1,001,975.81 0.00 0.48% 0.00 0.48% 0.00 None None None None None None None None 0 0 0 1 0 5,014,706.98 2.39% S&P -AAA 1 0.00 None 0 5,014,360.59 2.39% S&P -AAA 1 0.00 None 0 89,122,801.22 89,122,801.22 42.52% 1 Sub Total Local Government Investment 89,122,801.22 0.96 89,122,801.22 0.96 0.00 0 Pool 209,603,043.26 209,522,904.22 100.00% 157 TOTAL PORTFOLIO 209,589,344.05 0.75 209,610,246.82 0.75 106,195.72 -87,342.60 0.51 Page 18 of 36 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3131/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 100: General Fund Allegiance Bank 0.6 9/13/2017 2611523C Alma Bank 1.35 12/24/2020 020080682 American Eagle Bank IL 1.35 7/12/2021 02554BCM1 Bank Leumi USA 1.3 2/26/2020 063248FH6 247,818.98 248,000.00 248,000.00 248,000.00 9/13/2016 0.60 247,818.98 247,818.98 100.00 247,818.98 0.12% 0.60 0.00 0.00 None None 6/24/2016 248,000.00 98.06 243,183.10 0.12% None 1.35 248,000.00 1.89 64.21 -4,816.90 None 7/11/2016 248,000.00 97.82 242,591.62 0.12% 1.35 248,000.00 1.88 183.45 -5,408.38 3/3/2016 1.30 248,000.00 248,000.00 100.36 248,884.62 0.12% 1.18 291.48 884.62 None None None None 166 0,45 1364 3.64 1564 4.16 1062 2.86 Bank of the Pacific 1.25 7/30/2018 1/29/2015 248,000.00 99.96 247,900.55 0.12% None 486 06425BBN8 248,000.00 1.25 248,000.00 1.28 509.59 -99.45 None 1.32 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 101.38 251,416.94 0.12/, None 1274 06610QCV1 248,000.00 1.80 248,000.00 1.40 73.38 3,416.94 None 3.38 Belmont Savings Bank 1.85 12/23/2019 12/23/2014 248,000.00 100.88 250,187.86 0.12% None 997 080515BD0 248,000.00 1.85 248,000.00 1.52 1,231.85 2,187.86 None 2.66 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 101.40 251,468.28 0.12% None 1274 14042RAB7 248,000.00 2.30 248,000.00 1.88 93.76 3,488.28 None 3.37 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 98.41 244,053.33 0.12% None 1214 144153AW3 248,000.00 1.10 248,000.00 1.59 29.90 -3,946.67 None 3.26 CDARS 0.7 12/13/2018 12/15/2016 500,000.00 100.00 500,000.00 0.24% None 622 1019720221 500,000.00 0.70 500.000.00 0.70 834.25 0.00 None 1.7 CDARS 0.9 6/14/2018 6/16/2016 500,000.00 100.00 500,000.00 0.24% None 440 1019145928 500,000.00 0.90 500,000.00 0.90 1,072.60 0.00 None 1.2 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 17284C3Z5 248,000.00 2.10 Prepared by Rick Overgaard 248,000.00 101.07 250,650.38 0.12% None 963 248,000.00 1.68 1,883.44 2,650.38 None 2.56 Page 19 of 36 1 of 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 Comenity Capital Bank 1.7 5/28/2018 20033AJL1 Commercial Bank Ala Mich 1.5 3/29/2019 201282GV6 248,000.00 11/26/2014 1.70 248,000.00 248,000.00 6/30/2015 248,000.00 248,000.00 1.50 248,000.00 1.56 20.38 -274.54 100.31 1.43 248,774.26 57.75 99.89 247,725.46 0.12% 774.26 0.12% None None None None 423 1.15 728 1.97 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 98.29 243,752.50 0.12% None 1552 203507BG2 248,000.00 1.50 248,000.00 1.92 10.19 -4,247.50 None 4.12 6/30/2016 248,000.00 98.28 243,743.33 0.12% None 1552 Community Bankers' Bank 1.4 6/30/2021 20361LBR4 248,000.00 1.40 248,000.00 1.82 9.51 -4,256.67 None 4.12 Community National Bank Interest 1.25 4/4/2014 248,000.00 100.10 248,254.94 0.12% Nene 369 4/4/2018 20375WAM6 248,000.00 1.25 248,000.00 1.15 1,511.78 254.94 Nene Exchange Bank NEB 1.05 1/21/2020 301074CH1 7/20/2016 248,000.00 98.18 243,491.11 0.12% Ncne 1026 248,000.00 1.05 248,000.00 1.71 78.48 -4,508.89 Ncne 2.77 Fahey Banking 1.1 6/28/2019 3/29/2016 248,000.00 99.92 247,802.34 0.12% Ncne 303117CC7 248,000.00 1.10 248,000.00 1.14 22.42 -197.66 Ncne 819 2.22 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 100.08 1,000,819.00 0.48% Moodys-Aaa 1060 3132X0PW5 1,000,000.00 1.63 1,001,158.89 1.65 1,721.53 -339.89 S&P -AA+ 2.84 Farmers & Merchants Bank 1.45 4/25/2014 248,000.00 100.04 248,108.87 0.12% None 25 9/25/2018-14 308862DD0 248,000.00 1.45 248,000.00 1.42 59.11 108.87 None 1.47 FFCB 1.34 12/29/2017 1/29/2014 1,004,000.00 3133EDE99 1,000,000.00 1.24 1.000,760.28 100.18 1,001,776.00 0.48% Moodys-Aaa 1.10 3,424.44 1,015.72 S&P -AA+ FHLMC 1.35 12/17/2018-15 6/19/2015 999,525.00 100.03 1.000,319.00 0.48% S&P -AA+ 3134G6S95 1,000,000.00 1.36 999,767.41 1.33 3,900.00 551.59 Moodys-Aaa 273 0.74 626 1.69 FHLMC 1.42 3/29/2019-17 3/29/2017 2,000,000.00 100.00 2,000,058.00 0.95% S&P -A4+ 182 3134GA6G4 2,000,000.00 1.42 2,000,000.00 1.42 157.78 58.00 Moodys-Aaa 1.97 Prepared by Rick Overgaard Page 20 of 36 2 of 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2017 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity FIRST BANK HIGHLAND PARK 1.85 5/7/2019-14 319141BLO First National Bank 1.6 3119/2018 CD32115CBE7 248,000.00 248,000.00 5/7/2014 1.85 9/18/2013 1.60 248,000.00 248,000.00 100.10 1.80 248,247.26 1,810.06 0.12% 247.26 None None 248,000.00 100.64 249,575.79 0.12% None 248,000.00 0.94 130.45 1,575.79 None FNMA 0.875 12/20/2017 5/21/2014 992,573.21 99.85 998,526.00 0.48% Moodys-Aaa 3135G0RT2 1,000,000.00 1.09 998,507.73 1.08 2,454.86 18.27 S&P -A4+ JP Morgan Chase Bk NA Columbus 2.1 2/15/2021-17 48126XVW2 Machias Savings Bank 1.65 2/6/2020 554479DS1 Mahopac Bank 1.45 7/30/2019 56016CAQ6 2/15/2017 245,000.00 100.68 37 2.06 353 0.96 264 0.72 246,666.24 0.12% None 15 245,000.00 2.10 245,000.00 1.92 225.53 1,666.24 None 3.72 2/6/2015 248,000.00 101.30 251,227.97 0.12% None 1042 248,000.00 1.65 248,000.00 1.19 280.27 3,227.97 None 2.78 1/30/2015 248,000.00 101.03 250,543.24 0.12% None 851 248,000.00 1.45 248,000.00 1.01 591.12 2,543.24 None 2.3 Moody National Bank 0.5 5/30/2017 11/30/2016 250,540.63 100.00 250,540.63 0.12% None 60 7130E 250,540.63 0.50 250,540.63 0.50 415.28 0.00 None 0.16 Pearland State Bank 0.15 7/24/2017 700013947A 7/24/2016 245,000.00 100.00 245,000.00 0.12% None 115 245,000.00 0.15 245,000.00 0.15 251.71 0.00 None 0.32 Quantum National Bank 1.2 9/18/2019-16 3/18/2016 248,000.00 99.11 245,794.29 0.12% None 79 74765JETI 248,000.00 1.20 248,000.00 1.57 105.99 -2,205.71 None 2.43 Sallie Mae Bank 2.15 11/19/2019 11/19/2014 248,000.00 101.04 250.584.41 0.12% None 963 795450VC6 248,000.00 2.15 248,000.00 1.74 1,928.28 2,584.41 None 2.56 Selling State Bank OK 1.55 7/7/2021-17 7/7/2016 248,000.00 98.30 243,788.46 0.12% None 816050AA6 248,000.00 1.55 248,000.00 1.97 252.76 -4,211.54 None Trust Atlantic Bank 1.45 12/6/2017 89835FJC5 Prepared by Rick Overgaard 7 4.13 11/6/2013 248,000.00 100.50 249,237.77 0.12% None 250 248,000.00 1.45 248,000.00 0.72 Page 21 of 36 246.30 1,237.77 None 0.68 3of17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2017 Description CUSIP Face Amount / Shares Settlement Date YTM @ Cost Cost Value Market Price Market Value % Portfolio Credit Rating Days To CaII/Maturity Book Value YTM @ Market Accrued Interest Unre. GainfLoss Credit Rating Duration To Maturity Unity Bank 1.65 10/30/2020 91330ABC0 Vision Bank of Iowa 1.3 7/12/2021 92834CBW1 248,000.00 10/30/2015 1.65 248,000.00 248.000.00 7/11/2016 248,000.00 248,000.00 1.30 248.000.00 101.36 1.26 251,361.89 0.00 97.82 242.600.54 0.12% 3,361.89 None None 0.12% None 1.83 697.80 -5,399.46 None 1309 3.48 1564 4.17 Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 99.04 245,625.15 0.12% None 30 938828AC4 248,000.00 1.50 248,000.00 1.75 0.00 -2,374.85 None 3.88 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 98.36 243,921.89 0.12% None 1539 9497485W3 248,000.00 1.75 248,000.00 2.16 166.47 -4,078.11 None 4.06 Wets Fargo Sweep Cash 5/31/2006 14,195,645.73 WFSWEEP 14.195,645.73 0.09 14.195,645.73 29,373,303.55 Sub Total 100: General Fund 29,376,005.34 0.75 29,376,199.65 200: Debt Services lst Source Bank 1.5 11/18/2019 33646CEQ3 Charter Bank 1.7 2/25/2020 161164BE7 ConnectOne Bank 1.55 7/30/2018 20786AAM7 Discover Bank 2 2/25/2020 254672JA7 First Capital Bank 1.4 8/6/2019 31944FBK5 Goldman Sachs Bank 2 2/25/2020 38148JLL3 Prepared by Rick Overgaard 100.00 14,195,645.73 6.76% None 0.09 0.00 None 0 29,361,667.73 14.07% 318 0.74 26,798.16 -14,531.92 1.1 4/17/2015 248,000.00 100.56 249,395.25 0.12% None 248,000.00 1.50 248,000.00 1.28 1,681.64 1,395.25 None 2/25/2015 248,000.00 99.90 247,762.66 0.12% None 248,000.00 1.70 248,000.00 1.73 69.30 -237.34 None 1/30/2014 248,000.00 100.66 249,630.10 0.12% None 248,000.00 1.55 248,000.00 1.05 0.00 1,630.10 None 2/25/2015 248,000.00 100.75 249,856.03 0.12% None 248,000.00 2.00 248,000.00 1.73 462.03 1,856.03 None 4/6/2015 248,000.00 100.42 249,049.04 0.12% None 248,000.00 1.40 248,000.00 1.22 237.81 1,049.04 None 2/25/2015 248,000.00 100.75 249,856.03 0.12% None 248,000.00 2.00 248,000.00 1.73 462.03 1,856.03 None Page 22 of 36 962 2.58 1061 2.83 486 1.32 1061 2.83 858 2.31 1061 2.83 4 of 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 Partners Bank 1.5 9/30/2019 70212YAR3 Texas Class LGIP TX -01-0615-0001 Webster Bank NA 1.9 2/12/2019 94768NJM7 248,000.00 15,029,637.11 248.000.00 1.90 3/30/2015 1.50 248,000.00 248,000.00 1/15/2017 15.029,637.11 1.00 15.029,637.11 100.72 1.21 249,790,31 0.00 100.00 15.029,637.11 1.00 0.12% 1,790.31 7.15% 0.00 None None 913 2.48 None None 0 2/12/2014 248,000.00 100.72 249.790.56 0.12% None 663 248.000.00 1.51 606.75 1,790.56 None 1.84 Wells Farco Sweep Cash 5/31/2006 -355,928.05 100.00 -355,928.05 -0.17% None 1 WFSWEEP -355,928.05 0.09 -355,928.05 0.09 0.00 None 0 16,657,709.06 Sub Total 200: Debt Services 16,657,709.06 1.10 16,657,709.06 1.07 305: Hotel/Motel Occupancy Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 98.28 243,743.33 0.12% None 1552 063847AL1 24.8,000.00 1.40 248,000.00 1.82 9.51 -4,256.67 None 4.12 16,668,839.04 3,519.56 7.94% 11,129.98 106 0.28 Capital Bank Little Rock 1.35 3/22/2019 9/23/2015 248.000.00 100.66 249,645.23 0.12% None 721 139797FL3 248.000.00 1.35 248,000.00 1.01 82.55 1,645.23 None 1.95 First Intl Bank & Trust 1.8 1/16/2020 10/16/2015 248.000.00 99.69 247.238.89 0.12% None '021 32057GAE9 248.000.00 1.80 248.000.00 1.71 163.07 -751.11 None 2.73 Wells Fargo Sweep Cash 5/31/2006 3,335,147.78 100.00 3.335,147.78 1.59% None WFSWEEP 3,335,147.78 0.09 3,335,147.78 0.09 0.00 None 0 4,079,147.78 4,075,775.23 1.95% 201 Sub Total 305: Hotel/Motel Occupancy 4,079,147.78 0.34 4,079,147.78 0.35 255.13 -3,372.55 0.54 310: Municipal Court Security Wells Fargo Sweep Cash 5/31/2006 14,876.22 100.00 14,878.22 0.01% None 1 WFSWEEP 14,876.22 0.09 14,876.22 0.09 0.00 None 0 14478.22 14,876.22 0.01% 1 Sub Total 310: Municipal Court Security 14,876.22 0.09 14,876.22 0.09 0.00 0 315: City Wide Donation Prepared by Rick Overgaard Page 23 of 36 5of17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2017 Description CUSIP Face Amount 1 Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Sub Total 315: City Wide Donation 320: Court Technology Wells Fargo Sweep Cash WFSWEEP 58,096.47 5/31/2006 0.09 58,096.47 58,096 47 100.00 0.09 58,096.47 58,096.47 0.09 58,096.47 0.09 58,096.47 58,096.47 0.03% 0.00 0.03% 0.00 None None 1 0 5/31/2006 -12,386.47 100.00 -12,386.47 -0.01% None 1 -12,386.47 0.09 -12,386.47 0.09 0.00 None 0 -12,386.47 -12,386.47 -0.01% 1 Sub Total 320: Court Technology -12,386.47 0.09 -12,386.47 0.09 0.00 0 330: Park Donations Wells Fargo Sweep Cash 5/31/2006 143,532.83 100.00 143,532.83 0.07% None 1 WFSWEEP 143,532.83 0.09 143,532.83 0.09 0.00 None 0 143,532.83 143,532.83 0.07% 1 Sub Total 330: Park Donations 143,532.83 0.09 143,532.83 0.09 0.00 0 331: Tree Trust Fund Wells Fargo Sweep Cash 5/31/2006 57,069.13 100.00 57,069.13 0.03% None 1 WFSWEEP 57,069.13 0.09 57,069.13 0.09 0.00 None 0 57,069.13 57,069.13 0.03% 1 Sub Total 331: Tree Trust Fund 57,069.13 0.09 57,069.13 0.09 0.00 0 335: Police State Seizure Weirs Fargo Sweep Cash 5/31/2006 239,251.09 100.00 239,251.09 0.11% None 1 WFSWEEP 239,251.09 0.09 239,251.09 0.09 0.00 None 0 239,251.09 239,251.09 0.11% 1 Sub Total 335: Police State Seizure 239,251.09 0.09 239,251.09 0.09 0.00 0 336: Federal Police Fund Wells Fargo Sweep Cash 5/31/2006 10,673.39 100.00 10,673.39 0.01% None 1 WFSWEEP 10,673.39 0.09 10,673.39 0.09 0.00 None 0 Sub Total 336: Federal Police Fund Prepared by Rick Overgaard 10,673.39 0.09 10,673.39 10,673.39 10,673.39 0.09 Page 24 of 36 0.01% 1 0.00 0 6 of 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2017 Description CUSIP Face Amount 1 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 340: Park & Rec Development Border State Bank 1.4 6/30/2021 099703EF3 Nebraskaland National Bank 1.2 9.25/2018 63970QFC5 248,000.00 6/30/2016 1.40 248,000.00 248.000.00 97.48 241,746.93 0.12% 2.02 9.51 -6.253.07 None None 9/25/2015 248,000.00 100.52 249,291.09 0.12% None 248,000.00 1.20 248,000.00 0.85 48.92 1.291.09 None Wells Fargo Sweep Cash 532.472 00 WFSWEEP Sub Total 340: Park & Rec Development 1,028,472.00 345: Sidewalk Fund Wells Fargo Sweep Cash WFSWEEP 1552 4.12 543 1.47 5/31/2008 532,472.00 100.00 532,47200 025% None 1 0.09 532,472.00 0.09 0.00 None 0 1,028,472.00 1,023,510.02 0A9% 506 0.67 1,028,472.00 0.74 58.43 -4,961.98 1.35 5/31/2006 5,994.60 100.00 5,994.60 0% None 1 5.994.60 0.09 5,994.60 0.09 0.00 None 0 5,994.60 5,994.60 0% 1 Sub Total 345: Sidewalk Fund 5,994.60 0.09 5,994.60 0.09 0.00 0 350: Grant Fund Wells Fargo Sweep Cash 5/31/2006 102.278.93 100.00 102,278.93 0.05% None 1 WFSWEEP 102,278.93 0.09 402.278 93 0.09 0.00 None 0 102,278.93 102,278.93 0.05% 1 Sub Total 350: Grant Fund 102,278.93 0.09 102,278.93 0.09 0.00 0 351: CDBG Fund Wells Fargo Sweep Cash 11/15/2015 -55.396.71 100.00 -55,396.71 -0.03% Non 1 WFSWEEP -55,396.71 0.09 -55,396.71 0.09 0.00 None 0 -55,396.71 -55,396.71 4.03% 1 Sub Total 351: CDBG Fund -55,396.71 0.09 -55,396.71 0.09 0.00 0 360: Traffic Impact Improvement Wells Fargo Sweep Cash 5/31/2006 741,236.87 100.00 741,236.87 0.35% None 1 WFSWEEP 741,236.87 0.09 741,236.87 0.09 0.00 None 0 Prepared by Rick Overgaard Page 25 of 36 70(17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/3112017 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 @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total 360: Traffic Impact Improvement 365: Court Juvenile Mgmt Wells Fargo Sweep Cash WFSWEEP 741,236.87 0.09 9/15/2009 21,992.22 0.09 741,236.87 741, 236.87 21,992.22 21,992.22 21,992.22 0.09 100.00 0.09 741,236.87 21,992.22 0.35% 0.00 0.01% None 0.00 None Sub Total 365: Court Juvenile Mgmt 21,992.22 0.09 21,992.22 0.09 370: Municipal Channel Wells Fargo Sweep Cash 4/15(2012 725,951 52 100.00 725,951.52 0.35% None 1 WFSWEEP 725,951.52 0.09 725,951.52 0.09 0.00 None 0 21,992.22 0.01% 0.00 1 0 0 1 0 725,951.52 725,951.52 0.35% 1 Sub Total 370: Municipal Channel 725,951.52 0.09 725,951.52 0.09 0.00 0 375: U of H Fund Wells Fargo Sweep Cash 12/1/2009 -370.34 100.00 -370.34 0% None 1 WFSWEEP -370.34 0.09 -370.34 0.09 0.00 None 0 -370.34 -370.34 0% 1 Sub Total 375: U of 11 Fund -370.34 0.09 -370.34 0.09 0.00 0 500: Capital Projects Texas Class LGIP 1/15/2017 1,001,975.81 100.00 1,001,975.81 0.48% None 1 TX -01-0615-0001 1,001,975.81 1.00 1,001,975.81 1.00 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,875,395.14 100.00 2,875,395.14 1.37% None 1 WFSWEEP 2,875,395.14 0.09 2,875,395.14 0.09 0.00 None 0 3,877,370.95 3,877,370.95 1.85% 1 Sub Total 500: Capital Projects 3,877,370.95 0.33 3,877,370.95 0.33 0.00 0 501: Certificates of Obligation 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 97.05 240,678.79 0.12% None 1393 33625CAZ2 248,000.00 1.10 248,000.00 1.90 67.27 -7,321.21 None 3.73 Prepared by Rick Overgaard Page 26 of 36 8 of 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2017 Description CUSIP Face Amount / Settlement Date Shares YTM @ Cost Cost Value Book Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity FAMC 1.5 8/22/2019 3132X0PV7 FHLMC 1.125 8/12/2021 3137EAEC9 FHLMC 2 12/13/2021-17 3134GAZD9 FNMA 1.875 12/28/2020 3135G0H55 Gulf Coast Bank & Trust 1.3 7/15/2021- 17 402194EX8 Luana Savings Bank 1.25 6/19/2018 549103QQ5 Marlin Business Bank 1.25 12/27/2019 57116AM C9 Texas Class LGIP TX -01-0615-0001 TexSTAR LGIP 02000-11110 Wells Fargo Sweep Cash WFSWEEP Sub Total 501: Certificates of Obligation 503: Certificates of Obligation 2006 Wells Fargo Sweep Cash WFSWEEP Prepared by Rick Overgaard 1,000,000.00 1,000,000.00 1,000,000.00 1.000,000.00 248,000.00 248,000.00 248,000.00 7,015,315.62 5,014,706.98 266,235.25 2/22/2017 1.50 1.000,000.00 1,000,000.00 9/22/2016 1.37 12/13/2016 2.00 9/22/2016 1.25 7/15/2016 1.30 12/19/2014 1.25 6/29/2016 1.25 12/20/2016 1.00 8/26/2016 0.63 5/31/2006 0.09 17,288,257.85 1.01 6/30/2006 318,028.78 0.09 988,540.00 989,770.65 1,000,000.00 1,000,000.00 1,025,880.00 1,022,695.55 248.000.00 248,000.00 248,000.00 248.000.00 248,000.00 248,000.00 7,015,315.62 7,015,315.62 5,014.706.98 5,014,706.98 266235.25 266,23525 10027 1.38 1,002,727.00 1,625.00 96.56 1.95 98.75 2.28 100.47 1.75 97.84 1.82 100.02 1.23 98.87 1.67 100.00 1.00 100.00 0.63 100.00 17,302,677.85 17,300,724.05 318,028.78 318,028.78 Page 27 of 36 0.09 100.00 0.09 965.637.00 1,375.00 987,478.00 6,000.00 1,004,665.00 4,843.75 242,652.62 141.33 248,048.36 866.30 245,203.80 16.99 7,015,315.62 5,014,706.98 266,235.25 0.48% S&P -AA+ 2,727.00 Moodys-Aaa 0.47% Moodys-Aaa -24,133.65 S&P -AA+ 0.48% -12,522.00 0.49% -18,030.55 0.12% -5,347.38 0.12% 48.36 0.12% -2,796.20 17,233,348.42 14,935.64 318,028.78 3.34% 0.00 2.39% 0.00 0.13% 0.00 8.26% -67,375.63 0.15% 0.00 S&P -AA+ None Moodys-Aaa S&P -AA+ None None None None None None None None S&P -AAA None None None None None 874 2.35 1595 4.26 74 4.48 1368 3.61 106 4.17 445 1.21 1001 2.69 0 0 0 270 1.02 1 0 9 of 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total 503: Certificates of Obligation 2006 506: General Obligation BMO Hams Bank 1.05 6/22/2018 05581 WHF5 318,028.78 0.09 318,028.78 318,028.78 0.09 318,028.78 0.15% 0.00 6/23/2016 248,000.00 99.75 247,376.03 0.12% None 248,000.00 1.05 248,000.00 1.26 699.16 -623.97 None Capital One Bank USA 1.1 11/19,2019 11/19/2014 248,000.00 101.04 250,586.64 0.12% None 1404200X1 24.8,000.00 1.10 248,000.00 0.70 986.56 2.586.64 None Citizens State Bank Clayton 1.35 4/30/2019 9/30/2015 248,000.00 100.69 249,705.74 0.12% None 176688BS7 248,000.00 1.35 248,000.00 1.02 9.17 1,705.74 None FFCB 1.5 1/28/2019 5/28/2014 1,000,000.00 100.37 1,003,654.00 0.48% Moodys-Aaa 3133EDMF6 1,000,000.00 1.50 1,000,000.00 1.30 2,625.00 3,654.00 S&P -AA+ FHLB 1 9/26/2019 9122/2018 997,430.00 98.91 989,084.00 0.47% Moodys-Aaa 3130A9EP2 1,000,000.00 1.09 997,878.09 1.45 138.89 -8,794.09 S&P -AA+ FHLMC 2 12/13/2021-17 12/1312018 1,000,000.00 98.75 987,478.00 0.48% S&P -AA+ 3134GAZD9 1,000,000.00 2.00 1,000,000.00 2.28 6,000.00 -12,522.00 None First Business Bank 1.7 8/30/2020 9/30/2015 248,000.00 99.69 247,229.71 0.12% None 31938QP40 248,000.00 1.70 248,000.00 1.80 11.55 -770.29 None First Mid -III Bank & Trust 0.9 1/2/2018 6/30/2016 248,000.00 99.95 247,873.77 0.12% None 32086RBK5 248,000.00 0.90 248,000.00 0.97 6.12 -126.23 None First National Bank of America 1.25 7/15/2016 248,000.00 96.80 240,056.56 0.12% None 7/15/2021 32110YHMO 248,000.00 1.25 248,000.00 2.03 636.99 -7,943.44 None Lincoln 1st Bank 1.4 6/30/2021 53362LAB0 6/30/2016 248,000.00 98.28 243,743.33 0.12% None 248,000.00 1.40 248,000.00 1.82 285.37 -4,256.67 None National Bank Commerce Superior 1.25 7/15/2016 248,000.00 97.84 242,652.38 0.12% None 7/15/2021-17 633368E67 248,000.00 1.25 248.000.00 1.77 135.89 -5,347.62 None Prepared by Rick Overgaard Page 28 of 36 1 0 953 2.59 760 2.05 668 1.8 909 2.46 74 4.48 1187 3.17 277 0.75 1567 4.18 1552 4.12 106 4.18 10 of 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2017 Description CUSIP Face Amount / Settlement Date Shares YTM @ Cost Cost Value Market Price Market Value % Portfolio Unre. Gain/Loss Book Value YTM @ Market Accrued Interest Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity Peoples United Bank 1.9 11/19/2019 71270QKM7 Revere Bank 1.35 6/29/2018 761402AU0 Texas Class LGIP TX -01-0615-0001 248,000.00 248,000.00 7,015,315.62 TexSTAR LGIP 02000-11110 5,014,360.59 Wells Fargo Sweep Cash WFSWEEP -930,096.66 11/19/2014 1.90 248,000.00 248,000.00 12/30/2014 248,000.00 101.02 1.50 250,530.84 1,704.07 100.22 248,533.94 1.35 248,000.00 1.18 0.12% 2,530.84 Norse Noce 0.12% None 18.35 533.94 None 12/20/2016 7,015,315.62 100.00 7,015,315.62 1.00 7,015,315.62 1.00 8/26/2016 5,014,360.59 100.00 5.014,360.59 0.63 5,014,360.59 0.63 10/30/2008 -930,096.66 100.00 -930,096.66 0.09 -930,096.66 0.09 3.34% 0.00 2.39% 0.00 None None S&P -AAA None 953 2.57 455 1.23 0 1 0 -0.44% None 1 0.00 None 0 16,577,009.55 16,548,084.49 7.92% 224 Sub Total 506: General Obligation 16,579,579.55 1.08 16,577,457.64 1.12 13,257.12 -29,373.15 0.92 510: Lower Kirby Urban Center Wells Fargo Sweep Cash 10/15/2015 531,620.34 100.00 531,620.34 0.25% None 1 WFSWEEP 531,620.34 0.09 531,620.34 0.09 0.00 None 0 531,620.34 531,620.34 0.25% 1 Sub Total 510: Lower Kirby Urban Center 531,620.34 0.09 531,620.34 0.09 0.00 0 550: W/S Impact Fee Bank United 1.2 11/21/2017 11/21/2014 248,000.00 100.20 248,499.22 0.12% None 235 066519AF6 248,000.00 1.20 248,000.00 0.89 1,059.95 499.22 None 0.64 Bankwest, Inc. 1.5 1/3/2020 3/4/2015 248,000.00 99.45 246,627.07 0.12% None 1008 06652CFA4 248,000.00 1.50 248,000.00 1.71 285.37 -1,372.93 None 2.7 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 100.58 249,433.44 0.12% None 1176 05580ABX1 248,000.00 2.10 248,000.00 1.91 1,455.39 1,433.44 None 3.11 Cedar Rapids Bank & Trust 1.5 1/30/2015 248,000.00 101.19 250,950.46 0.12% None 943 10/30/2019 150517CJ7 248,000.00 1.50 248,000.00 1.03 305.75 2,950.46 None 2.53 Prepared by Rick Overgaard Page 29 of 36 11 of 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2017 Descript,on CUSIP Face Amount l Shares Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To CaII/Maturity YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity EVB Tappa Hannock VA 1.6 W25/2019 28927ASK7 248,000.00 9/25/2015 1.60 248,000.00 248,000.00 First FInandet NW 1.3510/30/2019 32022MAF5 FNMA 0.875 5/21/2018 3136G0WJ8 FNMA 1.375 3/13/2019-16 3136G1FY0 Pacific Continental Bank 1.25 6/30/2020 69413CFD6 10/30/2015 248,000.00 248,000.00 1.35 248,000.00 100.92 1.22 250,281.35 65.23 0.12% 2,281.35 99.19 245,990.95 0.12% 1.67 0.00 ,2400.06 None None None None 5/21/2014 985,050.00 99.86 998,588.00 0.47% Moodys-Aaa 1.000,000.00 1.26 995,743.40 1.18 3,159.72 944.90 S&P -AA+ 9/22/2016 1.009,560.00 100.08 1,000,780.00 OAS% Moodys-Aaa 1,000,000.00 0.98 1,007,532.12 1.33 687.50 4,752.12 S&P -AA+ 6/30/2018 248,000.00 248,000.00 1.25 248,000.00 Texas Class LGIP TX -01-0615-0001 42,517,90428 908 2.44 943 2.54 416 1.13 712 1.93 98.82 244,567.93 0.12% None 1187 1.69 8.49 4,482.07 None 3.18 �wrr 12/20/2016 42,517,90426 100.00 42,517,904.26 20.23% None 1.00 42,517,904.26 1.00 0.00 None Washington Trust Co 1.4 6/15/2018 12/15/2014 248,000.00 940637GU9 248,000.00 1.40 248,000.00 100.24 1.20 248,592.72 0.12% None 1,008.31 592.72 None 0 441 1.2 Welch State Bank 1.3 10/1/2018 9/30/2015 248,000.00 100.50 249,242.48 0.12% None 549 949095AU7 248,000.00 1.30 248,000.00 0.96 264.99 1,242.48 None 1.49 Wells Fargo Sweep Cash 5/31/2006 -1,136,646.46 100.00 -1,136,646.46 -0.54% None 1 WFSWEEP -1,136,646.46 0.09 -1,136,646.46 0.09 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 11,760,593.98 100.00 11,760,593.98 5.6% None 1 WF5883 11.780,593.98 0.03 11,760,593.98 0.03 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 10,845,152.49 100.00 10,845,152.49 5.16% None 1 WF4094 10,845,152.49 0.05 10,845,152.49 0.05 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 10,000,172.60 100.00 10,000,172.60 4.76% None 1 WF5875 10,000,172.60 0.03 10,000.172.60 0.03 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 5,106,031.07 100.00 5,106,031.07 2.43% None 1 WF4102 5,106,031.07 0.05 5,108,031.07 0.05 0.00 None 0 Prepared by Rick Overgaard Page 30 of 36 12 of 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2017 Description CUSIP Face Amount 1 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 550: W/S Impact Fee 555: Shadow Creek Impact Evergreen Bank 1.2 6/29/2018 300185CY9 83,325,207.94 83,319,817.94 0.59 83,328,483.46 0.59 83,324,761.56 8,300.70 39.67% -3,721.90 6/29/2015 248,000.00 100.01 248,015.87 0.12% None 248,000.00 1.20 248,000.00 1.20 16.31 15.87 None 1.24 37 0.1 455 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 100.08 1,000,819.00 0.48% Moodys-Aaa 1060 3132X0PW5 1.000,000.00 1.63 1.001,158.89 1.65 1,721.53 -339.89 S&P -A4+ 2.84 GUARANTY B&:T 1.35 5/29/2018 5/29/2014 248.000.00 100.16 248,399.78 0.12% None 424 400820BJ4 248,000.00 1.35 248,000.00 1.21 18.35 399.78 None 1.15 Manufacturers &: Traders Trust 1.2 6/24/2015 248,000.00 100.06 248,149.30 0.12% None 451 6/25/2018 564759QV3 248,000.00 1.20 248,000.00 1.15 790.88 149.30 None 1.23 Wens Fargo Sweep Cash 5/31/2006 446,553.90 100.00 446,553.90 0.21% None WFSWEEP 446,553.90 0.09 446,553.90 0.09 0.00 None 1 0 2,191,753.90 2,191,937.85 1.05% 635 Sub Total 555: Shadow Creek Impact 2,190,553.90 1.19 2,191,712.79 1.17 2,547.07 225.01 1.71 560: Certificates of Obligation 1998 Wells Fargo Sweep Cash 5/31/2006 357,987.27 100.00 367,987.27 0.18% None 1 WFSWEEP 367,987.27 0,09 367.987.27 0.09 0.00 None 0 367,987.27 367,987.27 0.18% 1 Sub Total 560: Certificates of Obligation 367,987.27 0.09 367,987.27 0.09 0.00 0 1998 565: Revenue Bonds 1999 & 2003 Continental Bank 1.25 5/25/2018 11/26/2014 248,000.00 100.05 248,126.23 0.12% None 420 211163EN6 248,000.00 1.25 248,000.00 1.21 1,070.14 126.23 None 1.14 FAMC 1.5 8222019 2/22/2017 1,000,000.00 100.27 1,002,727.00 0.48% S&P -AA+ 3132X0PV7 1,000,000.00 1.50 1,000,000.00 1.38 1,625.00 2.727.00 Moodys-Aaa GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 98.29 243,752.50 0.12% None 36198JCC6 248,000.00 1.50 248,000.00 1.92 10.19 -4,247.50 None Prepared by Rick Overgaard Page 31 of 36 874 2.35 1552 4.12 13 of 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 Signature Bank 1.35 3/28/2019 82669LFU2 Silvergate Bank 1 6/29/2018-16 828373FE5 Texas Class LGIP TX -01-0615-0001 Wells Fargo Sweep Cash. WFSWEEP Sub Total 565: Revenue Bonds 1999 & 2003 570: W1S Pay As You Go 248,000.00 248,000.00 1,001,975.81 797,492.58 3,791,468.39 9/29/2015 1.35 6/29/2016 1.00 1/15/2017 1.00 248,000.00 248,000.00 248,000.00 248,000.00 1,001,975.81 1,001,975.81 100.64 1.03 249,575.05 27.52 99.76 247,411.74 1.19 13.59 100.00 1,001,975.81 1.00 0.12% 1,575.05 0.12% -588.26 0.48% 0.00 None None None None None None 5/31/2006 797,492.58 100.00 797.492.58 0.38% None 0.09 797,492.58 0.09 0.00 None 1.01 3,791,468.39 3,791,468.39 727 1.97 28 1.24 0 0 3,791, 060.91 1.82% 409 1.00 2,746.44 -407.4.8 1.17 Wells Fargo Sweep Cash 12/31/2007 1,662,801.19 100.00 1,662,801.19 0.79% None 1 WFSWEEP 1,662,801.19 0.09 1,662,801.19 0.09 0.00 None 0 1,662,801.19 1,662,801.19 0.79% 1 Sub Total 570: W,S Pay As You Go 1,662,801.19 0.09 1,662,801.19 0.09 0.00 0 575: MUD 4 Capital Programs Wells Fargo Sweep Cash 2/12013 400,857.31 100.00 400,857.31 C.19% None 1 WFSWEEP 400,857.31 0.09 400,857.31 0.09 0.00 None 0 400,857.31 400,857.31 0.19% 1 Sub Total 575: MUD 4 Capital Programs 400,857.31 0.09 400,857.31 0.09 0.00 0 600: Water & Sewer BARCLAYS BANK DELAWARE 1.95 5/6/2014 248,000.00 100.84 250,093.86 0.12% None 767 5/7/2019 06740KGU5 248,000.00 1.95 248,000.00 1.54 1,907.90 2,093.86 None 2.05 CDARS 0.5 6/15/2017 1019146991 Eaglebank Bethesda 1.15 12/10/2018 27002YCV6 Prepared by Rick Overgaard 6/16/2016 500,000.00 100.00 500,000.00 0.24% None 500,000.00 0.50 500,000.00 0.50 1,972.60 0.00 None 3/9/2016 248,000.00 99.98 247,949.66 0.12% None 248.000.00 1.15 248,000.00 1.18 171.90 40.34 None Page 32 of 36 76 0.21 619 1.68 14 of 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 FAMC 1.5 8/22/2019 3132X0PV7 FAMC 1.72 10/3/2018 31315P5A3 FFCB 1.95 9/17/2018 3133ED2C5 FHLB 1.75 12/14/2018 3133768R5 FHLMC 1 9/29/2017 3137EADLO First Bank McComb MS 1.5 2/28/2019 319234AJ9 First Eagle National Bank 1.45 11/21/2018 32008JAM5 FNMA 0.875 10/26/2017 3135GOPQ0 FNMA 1.625 11/27/2018 3135G0YT4 MB Financial Bank 1.1 3/18/2019 55266CQU3 Northem Bank & Trust MA 1.1 7/12/2019-17 66476QBH0 Northwest Bank Boise Idaho 1.5 1/10/2019 66736AAD1 Prepared by Rick Overgaard 2.000,000.00 1.000,000.00 1,000,000.00 1,000,000.00 1.000,000.00 248,000.00 248,000.00 1,000,000.00 1,000,000.00 248.000.00 248,000.00 248,000.00 2/22/2017 1.47 2,001,700.00 2,001,626.33 12/16/2013 997,890.00 100.27 1.38 100.70 2,005,454.00 3,250.00 0.95% 3,827.67 S&P -AA+ Moodys-Aaa 1,006,987.00 0.48% Moodys-Aaa 1.77 999,337.80 125 8,504.44 7,649.20 S&P -AA+ 1/29/2014 1, 014, 770.00 1.62 1,004,657.69 101.05 1.23 1,010,470.00 758.33 0.48% Moodys-Aaa 5,812.31 S&P -AA+ 12/16/2013 1,000,670.00 100.84 1,008,365.00 0.48% Moodys-Aaa 1.74 1,000,228.43 1.25 5,201.39 8,136.57 S&P -AA+ 1/29/2014 994,150.00 100.02 1,000,223.00 1.16 999,211.14 0.96 55.56 0.48% Moodys-Aaa 1,011.86 S&P -AA+ 6/30/2015 248.000.00 100.24 248,590.24 0.12% None 1.50 248,000.00 1.37 30.58 590.24 None 11/21/2014 248,000.00 100.35 248,876.68 0.12% None 1.45 248,000.00 1.23 1,280.77 876.68 None 5/21/2014 995,150.00 99.93 999,277.00 0.48% Moodys-Aaa 1.02 999,194.94 1.00 3,767.36 82.06 S&P -AA+ 7/16/2014 1,004,411.00 1.52 1,001,673.43 100.61 1.25 1,006,118.00 5,597.22 0.48% Moodys-Aaa 4,444.57 S&P -AA+ 874 2.35 551 1.48 535 1.45 623 1.68 182 0.49 699 1.88 600 1.62 209 0.57 606 1.63 3/18/2016 248,000.00 99.90 247,740.10 0.12% None 717 1.10 248,000.00 1.15 97.16 -259.90 None 1.94 7/12/2016 248,000.00 99.06 245,657.89 0.12% None 12 1.10 248,000.00 1.52 582.97 -2,342.11 None 2.25 4/10/2014 248,000.00 100.76 249,878.85 0.12% None 650 1.50 248,000.00 1.07 214.03 1,878.85 None 1.75 Page 33 of 36 15 of 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2017 Description Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity OLDTOWN BANK 1.2 5/7/2018 680540886 Parkside Finl Bank &: Trust 1.3 7/19/2021-17 70147ABX1 248,000.00 248,000.00 Portage County Bank 1.4 6/24/2021 248,000.00 Texas Class LGIP TX -01-0615-0001 5,511,609.42 73565NBQ5 Wells Fargo Sweep Cash WFSWEEP 6,485,953.23 Sub Total 600: Water & Sewer 22,977,562.65 610: Solidwaste Wells Fargo Sweep Cash F SWEE P 347,108.80 Sub Total 610: Solidwaste 700: Property Liability Ins Wells Fargo Sweep Cash WFSWEEP 6/6/2014 1.20 248,000.00 248,000.00 7/18/2016 248,000.00 1.30 6/24/2016 1.40 100.35 0.88 248,879.66 204.84 97.82 212,80$,77 0.12% 879.66 None None 0.12% None 248.000.00 1.83 114.83 -5,396.23 None 248,000.00 248,000.00 12/20/2016 5.511,609.42 1.00 5,511,609.42 98.31 243,812.02 0.12% None 1.82 66.59 -4,187.98 None 100.00 5,511,609.42 2.62% None 1.00 0.00 None 5/31/2006 6,485,953.23 100.00 6.485,953.23 3.09% None 0.09 6,485,953.23 0.09 0.00 None 0.94 22, 986, 303.65 22,983,492.41 402 1.09 109 4.18 1546 4.11 0 23,008,539.38 10.98% 262 0.84 33,777.47 25,046.97 0.77 12/1/2006 347,108.80 100.00 347,108.80 C.17% None 0.09 347,108.80 0.09 0.00 None 0 347,108.80 0.09 347,108.80 347,108.80 347,108.80 0.09 0.17% 1 0.00 0 10/31/2006 495,448.75 100.00 495,448.75 0.24% None 1 495,448.75 0.09 495,448.75 0.09 0.00 None 0 495,448.75 495,448.75 0.24% 1 Sub Total 700: Property Liability Ins 495,448.75 0.09 495,448.75 0.09 0.00 0 701: Employee Benefit Fund Wells Fargo Sweep Cash 9/1/2007 98.307.48 100.00 98.307.48 0.05% None WFSWEEP 98.307,48 0.09 98,307.48 0.09 0.00 None 0 Sub Total 701: Employee Beneft Fund 702: Health Claims Fund ?repa7ed by Rick Cve-gaard 98,307.48 0.09 98,307.48 98,307.48 98,307.4.8 0.09 Page 34 of 36 0.05% 1 0.00 0 16 of 17 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/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 Cash WF9871 Wells Fargo Sweep Cash WFSWEEP Sub Total 702: Health Claims Fund TOTAL PORTFOLIO Prepared by Rick Overgaard 118,408.08 7/21/2010 0.09 118,408.08 118.408.08 9/15/2010 2,556,261.23 2,556,261.23 0.09 2,556,261.23 2,674,669.31 2,674,669.31 0.09 2,674,669.31 210,134,663.60 210,120,964.39 0.75 210,141,867.16 Page 35 of 36 100.00 0.09 118.408.08 100.00 2,556,261.23 0.09 C.06% 0.00 1.22% 0.00 2,674,669.31 1.28% 0.09 0.00 210, 054,524.56 100.00% 0.75 106,195.72 .87,342.60 None None None None 0 0 1 0 156 0.51 17 of 17 Ban k Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Pledged Collateral Reconciliation Report March 31, 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 Credit Card Account Sweep Account False Alarm Reduction Program Alvin ISD EMS Payments Health Claims Escrow W&S Revenue Bonds, Series B Escrow W&S Revenue Bonds, Series C Choice IV with Interest -Public Funds Choice IV with Interest -Public Funds Total of Bank Balances Pledged Collateral for City FDIC Insurance Amount 50,394,421.05 281,017.38 4, 252, 062.31 312,529.20 10, 845,152.49 5,106,031.07 11,760,593.98 10,000,172.60 $ 92,951,980.08 148,870,099.25 500,000.00 $ 149,370,099.25 Over (Under) Collateralized $ 56,418,119.17 Total % Collateralized 160.7% Account Name Amount 929,600.66 $ 929,600.66 Development Authority Total of Bank Balances Pledged Collateral for DAP FDIC Insurance 772,303.47 250,000.00 $ 1,022,303.47 Over (Under) Collateralized $ 92,702.81 Page 36 of 36 Total % Collateralized 110.0% Total % Collateralized 160.2% Status Collateralized