Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R-2016-091 2016-06-13
RESOLUTION NO. R2016-91 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending March 2016. 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 2016. PASSED, APPROVED, AND ADOPTED this 13th day of June, A.D., 2016. ATTEST: APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY TOM REID MAYOR ```` o It, 1,4,,'' s •:�; City of Pearland Quarterly Investment Report December 31, 2015 to March 31, 2016 Resolution No. R2016-91 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 Gain/Loss YTM @ Cost Treasury 1 Year Interest Earned Days To Maturity 111/2016 2/29/2016 311/2016 115 819.831.42 107 901.897.72 104 099.37820 115,664.426 48 107.678.683.54 103.820.207 26 155,404.94 223.214.18 279,170.94 0 44 0.45 0 47 0.54 0.53 0.66 43.879.84 43,579.65 41,562.74 248 245 261 Total / Average 109,273.702.45 109,054,439.09 219,263.35 0.45 0.58 129,022.23 251 Rick OVerlgaa . Assistant Finance Director Date S7/ Carrie Ditta Accounting Supervisor 51IO(IIa Date 5 Securit T pe Allocation Security Type Book Value 12/31/2015 of Portfolio 12/31/2015 Book Value 3/31/2016 % of Portfolio 3/31/2016 Cash Certificate Of Deposit FAMC Bond FFCB Bond FHLB Bond FHLMC Bond FNMA Bond 68.394,131.88 21 090.106.88 998 788.00 3.785 679.28 4,000,356.05 1 996 814.32 3.987.351.16 65.60 20.23 0.96 3.63 3.84 1.92 382 70 735,130 62 21 090 106.88 998,897.96 3.009.627.02 2,000 292.80 1997 247.16 3,988.904.82 68.13 20.31 096 2.90 1.93 1 92 384 Total / Average 104,253,227.57 Portfolio Holdings as of 12/31/2015 City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Begin Date 12/31/2015. End Date. 3/31/2016 • 65.6% -Cash 20.23% -Certificate 0... • 0.96%-FAMC Bond f• 3.63%-FFCB Bnnd • 3.84% -FHLB Bond 1.92%-FHLMC Bond • 3.82% -FNMA Bond 100.00 103.820,207.26 100.00 Portfolio Holdings as of 3/31/2016 • 68.13% -Cash tr 20.31% -Certificate C. • 0.96%-FAMC Bond • 2.9%-FFCB Bond • 1.93% -FHLB Bond 1.92%-FHLMC Bond • 3,84% -FNMA Bond 6 Prepared by Rick Overgaard 10/' City of Pearland Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date 12/31/2015. End Date 3/31/2016 Maturit Ran • e Allocation Matunty Range Book Value 12/31/2015 % of Portfolio 12/31/2015 Book Value 3131/2016 % of Portfolio 3/31/2016 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 68.394,131 88 2,240.039.72 3,481,287.90 988,818.98 1,244,000 00 6.728,516.63 10,217 432.46 6.456.000 00 4503 000.00 65.60 215 3 34 0 95 119 645 9.80 6.19 4.32 70.735 130.62 3.481 287 90 988,818.98 1 244,000 00 992 000.00 5.737.542.16 13,201.427.60 5.952.000.00 1 488.000.00 68.13 3 35 0 95 1 20 096 5.53 12.72 5.73 1 43 Total / Average 104,253,227.57 100.00 103,820,207.26 100.00 Portfolio Holdings In Thousands 80,000 70,000 60,000 50,000 40,000 30,000 20,000 10,000 00 0-1 M MEM 1-3 M 3-6 M 6-9 M 9-12 M 3-4 Y 4-5 Y 12/31/2015 111 3/31/2016 Prepared by Rick Overgaard 7 1 oft City of Pearland Total Rate of Return - Book Value by Month Report Group: Pearland Begun Date 4/30/2015 End Date 3/31/2016 Beginning BV + Interest Earned Realized Investment Average Capital Annualized Treasury 1 Month Accrued Interest During Period -BV Gain/Loss-BV Income -BV Base -BV TRR-BV TRR-BV Year 4/30/2015 111.229 526.74 5/31/2015 105.463.282.04 6/30/2015 101.276.825.50 7/31/2015 97.582.481.03 8/31/2015 95.988.723.31 9/30/2015 84.060.319.98 10/31/2015 94.017 315.52 11/30/2015 94.017.517.21 12/31/2015 95 463.993.42 1/31/2016 104 326 907.41 2/29/2016 115.744,672.18 3/31/2016 107.760.192.94 37.849.99 40 431.37 38 246.93 42 564.89 42,536.05 39.509.73 43.479.22 43.328.10 48,077.82 43 879.84 43.579.65 41.562.74 0 00 0.00 000 0.00 0.00 0.00 0.00 0.00 0.00 000 0.00 000 37.849.99 40,431 37 38,246.93 42,564.89 42.536.05 39,509.73 43,479.22 43.328.10 48,077.82 43.879.84 43579.65 41.562.74 108,073,382.11 0 04 103.056.388.55 0.04 98.226,574.91 0 04 96,753.317 85 0 04 89.543.279.41 0 05 83.758.164.74 0.05 93,653 134.95 0 05 95.030.981.22 0.05 100,406.813.53 0.05 110,715.608 40 0 04 111,982.656.93 0.04 105.449,678.87 0.04 0.42 0.47 0.47 0.53 0.57 0.57 0.56 0.55 0.58 0.48 0.47 0.47 0.23 0.24 0 28 0.30 0.38 0.37 0.26 0.48 0.65 054 0.53 0.66 Annualized TRR-BV 0.70 0.60 0.50 0.40 0.30 0.20 0.10 0.00 04/2015 05/2015 06/2015 07/2015 08/2015 09/2015 10/2015 11/2015 12/2015 01/2016 02/2016 03/2016 • Portfolio Treasury 1 Year Prepared by Rick Overgaard 8 1of1 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date 3/31/2016 Description Face Amount i CUSIP Shares Settlement Date Cost Value Market Price Market Value YTM Cost Book Value YTM Market Accrued Interest Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Ca!UMaturity Duration To Maturity Cash Wells Fargo Cash WF987 1 Wells Fargo Sweep Cash WF SWEEP Wells Fargo Sweep Casn WFSWEEP 7/21;2010 390 778.39 100.00 330 779 3 390 778.39 0.09 390.778.39 0.09 4/15/2012 822 302.01 100.00 . 822.302 01 0 09 822.302.01 0 09 5/31/2006 17,500.60 100.00 17 500 60 17 500 60 0.09 17,500.60 0.09 None None 379"0 None 0.00 None 0.02° 0.00 None None Wells Fargo Sweep Cash 5/31/2006 171,498.03 100.00 171,498.03 0.17% None WFSWEEP 171 498.03 0.09 171 498.03 0.09 0.00 None Wells Fargo Sweep Cash 9/30/2013 270 024.65 100 00 270 024.65 WFSWEEP 270 024 65 0.09 270.024,65 0 09 Wells Fargo Sweep Cash 9/15/2010 1.281 254 72 100.00 1.281 254.72 WFSWEEP 1 281 254 72 0.09 1 281.254.72 0 09 Wells Fargo Sweep Cash 531/2006 217 959 85 100 00 217 959.85 WFSWEEP 217 959.85 0.09 217.959.85 0 09 Wells Fargo Sweep Cash 5/31/2006 74.706.29 100.00 74,706.29 WFSWFEP 74 706.29 0.09 74 706 29 0.09 Wells Fargo Sweep Cash 5/31/2006 2.164 236.71 100.00 2 164 236.71 WFSWEEP 2 164,236.71 0.09 2 164 236.71 0.09 Wells Fargo Sweep Cash 10/30/2008 3.976 557.33 100.00 3.976 557 33 WFSWEEP 3.976 557.33 0.09 3.976.557 33 0.09 Wells Fargo Sweep Cash 10/31/2006 284 107.09 100 00 284.107 09 WFSWEEP 284.107.09 0.09 284 107.09 0 09 Wells Fargo Sweep Cash 2/1/2013 665,910 67 100.00 665.910 67 WFSWEEP 685.910.67 0.09 665.910-67 0.09 Prepared by Rick Overgaard 0.26°.i, 0.00 None None 1.23% None 0.00 None 0 21% None 0.00 None 0 07% None 0 00 None 2 08% None 0 00 None 3.83% None 0.00 None 0 27% None 0 00 None 0 n 0 0 0 0 0 0 0 0.64% None 1 0 00 None 0 9 1 of 12 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date 3/3112016 Description Settlement Date Cost Value Market Price Market Value Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To CaIIIMaturity Duration To Maturity Wells Fargo Sweep Casn /NFSWEEP Wells Fargo Sweep Cash WF SWEEP Wells Fargo Sweep Cash WFSWEEP 5/31)2006 2,717,608.08 100.00 2.717.606.08 0.09 2.717 606.08 0 09 367 573 19 562 805.04 5/3112006 2.717 606 08 2.62% None None 0.00 367.573 19 100.00 367 573 19 0.3504 None 0 09 367 573 19 0.09 0.00 None 0 6/30/2006 562 805.04 100.00 582.805.04 0.54% None 0.09 562 805.04 0.09 0 00 None 0 Wells Fargo Sweep Cash 5/31/2006 14.875 994 95 100.00 14 875 994.95 14 33°4 None WFSWEEP 14 875,994.95 0 09 14.875 994 95 0.09 0.00 None 0 Wells Fargo Sweep Cash 12/31/2007 1.436,159.69 100.00 1 436 159.69 1.38°_ None WFSWEEP 1 436 159.69 0.09 1,436.159.69 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 989.131.37 100.00 989.131,37 0 95% None 1 WFSWEEP 989 131.37 0.09 989,131.37 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 51,076.93 100.00 51 076.93 0.05 None WFSWEEP 51 076.93 0.09 51,076.93 0 09 0.00 None 0 Wells Fargo Sweep Cash 9/15/2009 34 953.53 100.00 34,953.53 0 03% None WFSWEEP 34 953.53 0.09 34 953.53 0.09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 118 086.69 100.00 118.086.69 0 11% None 1 WFSWEEP 118 086 69 0.09 118.086.69 0.09 0 00 None 0 Wells Fargo Sweep Cash 5/31/2006 10.978.246 33 100 00 10,978,246.33 10.5704 None WFSWEEP 10.978,246.33 0.09 10.978 246.33 0 09 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 485.018,73 100 00 465,018.73 0 45% None 1 WFSWEEP 465 018.73 0.09 465 018.73 0 09 0.00 None 0 Wells Fargo Sweep Casn 5/31/2006 46.90 100 00 48.90 0% None 1 WFSWEEP 46.90 0.09 46.90 0.09 0.00 None 0 Wells Fargo Sweep Cash 12/1/2009 50 501.62 100,00 50.501.62 0.05% None 1 WFSWEEP 50.501 62 0 09 50 501 62 0.09 0,00 None 0 Prepared by Rick Overgaard 10 2of12 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date 3/31/2016 Description CUSIP Face Amount 1 Shares YTM @ Cost Book Value YTM Cm Market Accrued Interest Settlement Date Cost Value Market Price Market Value Portfolio Credit Rating Days To Call/Maturity Unre. Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Casn WFSWEEP Wells Fargo Sweep Cash W1 SWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WF SWEEP Welts Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Cash WFSWEEP Wells Fargo Sweep Casn WFSWEEP Wells Fargo Sweep Cash WFSWEEP Welts Fargo Sweep Cash WFSWEEP Prepared by Rick Overgaard 225 200 02 2.581 055.64 2 787 131.29 288 818.77 101.267.47 87 522 74 5.299.65 7 184.24 -198472.94 21.793.314.92 65 076.49 948.27 6 74667 5/31/2006 0.09 511/2006 0.09 5/31/2006 0.09 225 200 02 225.200.02 2.581 055.64 2.581.055.64 2,787,131.29 2.787.131.29 100.00 0.09 225.200 02 100 00 2 581 055.64 0 09 100.00 2.787 131 29 0.09 5/31/2006 288.818.77 100.00 288 818 7' 0 09 288 818.77 0.09 12/1,2006 101,267.47 100 00 101.267 47 0.09 101 267.47 0.09 9/1/2007 87.522.74 100.00 87,522.74 0.09 87 522.74 0 09 5'3112006 5 299.65 100.00 5.299.65 0.09 5.299 65 0.09 5/31/2006 7 184.24 100.00 7 184 24 0.09 7 184.24 0 09 12/31/2007 0.22% 0.00 None None 2.49% 0.00 None None 2.68% None 0 00 None 0.28% None 0.00 None 01% None 0.00 None 0.08% 0.00 None None 0.01% None 1 0 0 0 0 r 0.00 None 0 0.01% None 1 0.00 None 0 -198 472.94 100.00 -198.472.94 -0.19% None 0.09 -198472.94 0.09 0.00 None 0 5/31/2006 21,793.314.92 100 00 21,793,314.92 20.99% None 1 0.09 21 793.314,92 0.09 0.00 None 0 5/31/2006 65,076 49 100.00 65.078.49 0 09 65 076.49 0.09 11/15/2015 948.27 100.00 948.27 0 09 948.27 0.09 5'31'2006 6.746.67 100.00 0.09 6.746.67 0.09 0,06% None 1 0.00 None 0 0% None 1 0.00 None 0 6.746 67 0.01% Non. 0.00 None 11 3of12 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Description Settlement Date Cost Valise Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Face Amount / CUSIP Shares YTM Cost Book Value YTM Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity Sub Total Cas! 70.735.130.62 0.09 70.7 35.130.62 70,735,130.62 0.09 70.735,130.62 68.12`1° 0.00 0 Certificate Of Deposit 1st Source ©a • - 33646CE03 1st United Bank FL 0.7 5/9/2016 33741TAU5 Allegiance Bank 0 5 9/13/2016 26115238 Amencanwest Bank 0.8 1/25/2017 030590DS9 20 5 248.000 00 250 717 34 0.24% None 248 000 00 1.50 248.000 00 1.19 1.691.84 2.717.34 None 3.53 11/8/2013 248 000 00 100.03 248 068 96 0.24% None 39 248 000.00 0.70 248 000.00 0.45 104 64 66.96 None 0 11 9/14/2015 247 818 98 100.00 247 818,98 0.24'6 None 166 247 818.98 0.50 247 818.98 0 50 0.00 0.00 None 0 45 7/25/2014 248 000.00 100 16 248 402 75 0.24% None 300 248 000 00 0.80 248 000 00 0 80 358 75 402.75 None 0.82 Bank Leumi USA 1.3 2/26/2020 3/3/2016 248 000 00 99 15 245 892 00 0.24% None 1427 063248FH6 248 000 00 1.30 248 000.00 1 53 247.32 -2.108.00 None 3 82 Bank of the PaOIc 125 7/30,2018 1/29/2015 248 000 00 101 13 250.809 10 0.24% None 851 06425118148 248 000 00 1.25 248 000 00 0 76 518 08 2.809 10 None 2.3 Bank United 1.2 11/2112017 11/21/2014 248 000 00 100.27 248 666 13 0.24% None 600 066519AF6 248 000 00 1.20 248 000 00 1 03 1,068.10 666.13 None 1 82 Bankers Ranh Oklahoma 1.8 9/25/2020 9/25/2015 248 000.00 101.96 252 867.25 0.24% None 1639 066100CV1 218,000.00 1.80 248 000 00 1.35 73 38 4.867.25 None 4 31 Bankwest Inc 1 5 1/32020 3/4/2015 248 000 00 101 55 251 842 26 024% None 1373 06652CFA4 248.000.00 1.50 248 000.00 1 08 285 37 3.84226 None 3 65 BARCLAYS BANK DELAWARE 1 95 5/6/2014 248 000.00 101 69 252 183.76 0.24°4 None 1132 5/72019 06740KGU5 248.000.00 1.95 248 000 00 1 39 1.921 15 4 183.76 None 3 Belmont Savings Bank 1,85 12/23/2019 12/23/2014 248,00000 101 56 251.884.58 0.24°4 None 1362 080515800 248.000.00 1.85 248.000 00 1 42 1.244 42 3.864.58 None 3 8 Prepared by Rick Overgaard 4 of 12 12 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date 3/31/2016 Des criptwr CUSIP Face Amount i Shares Settlement Date YTM @ Cost Cost Value Market Price Market Value Book Value YTM @ Market Accrued Interest % Portfolio Credit Rating Days To CatlrMatunty Unre. Gain/Loss Credit Rating Duration To Maturity BMW Bank 2.1 8/19/2020 05580ABX1 CALUSA NATIONAL BANK 0 5 9/22/2016 13151TAX4 Capital Bank Little Rock 1.3 5 3/2212019 139797FL3 Capital One Bank USA 1 1404200X1 11/19/2019 248.000.00 248 000.00 6/19/2015 2.10 248 000.00 248 000 00 5/23/2014 248 000 00 0.50 248 000.00 9/23/2015 100.95 1 86 250.355 75 1 46965 99,97 247 925 35 0 56 30 58 248.000.00 101.45 0.24% 2,355 75 None None 0.24% None -74.65 None 251 604 68 0 24% 1541 4.04 175 0 48 None 1086 248.000.00 1.35 248,000.00 0.86 82.55 3.604.68 None 2.92 11/19/2014 248.000 00 101.75 252.336.53 0 24% None 1328 248 000 00 1.10 248.000.00 0.61 994.04 4 336 53 None 356 Capital One NA 2 3 9/25/2020 9/2312015 248 000 00 101 98 252 910 15 0.24°'. None 1639 14042RAB7 Cardinal Bank 0.5 5/17/2016 CD14147VDM5 248 000.00 248 000,00 2 30 248 000.00 1.84 5/17/2013 248 000.00 100.01 0.50 248,000 00 0.43 93,76 4.910.15 None 4.29 248.021 08 0.24% None 47 56 21.08 None CDARS 0 5 12/15/2016 12.'17/2015 500,000.00 100 00 500 000 00 048% /018550896 CDARS 0 5 6/16/2016 1017961604 500 000 00 500 000.00 0.50 500 000 00 6/18/2015 0.50 719 18 500 000.00 100.00 0.50 500.000.00 0.50 47 013 None 259 0 00 None 0.71 500 000.00 0.48.6 None 1.965.75 0 00 None 77 021 CDARS 0.9 6/16/2016 6/19/2014 500 000 00 100 00 500 000.00 0 48°%o None 77 1016754591 500 000 00 0.90 500.000 00 0.90 8,026.03 0 00 None 0.21 Cedar Rapids Bank & Trust 1.5 10/30/2019 1(30/2015 248 000 00 101 98 252.920 07 0.24°k None 1308 150517CJ7 248 000.00 1.50 248,000.00 0.94 305 75 4,92007 None 3 49 Celtic Bank 0 6 6/28/2016 8/28/2013 248 000 00 100.02 248.059.02 0.24% None 89 CD15118RJDO 248 000.00 0.60 248 000 00 0.50 12.23 59 02 None 224 Charter Bank 1 7 2/25;2020 2/25/2015 248 000.00 100.07 248 180 05 0.24% None 1425 1611648E7 248 000.00 1 70 248.000.00 1.68 69.30 180 05 None 378 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248 000.00 101.08 250 674 93 0 24% None 1328 1 7 284C3Z5 Prepared by Rick Overgaard 248.000.00 2.10 248.000 00 1 79 1.897.71 2,674.93 None 3.49 5 of 12 13 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date. 3/31/2016 Description Settlement Date Cost Value Market Price Market Value Face Amount I CUSIP Shares YTM @ Cost Book Value YTM LID Market Accrued Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity Citizens State Bank Clayton 1 35 4/30,2019 176688BS7 College Savings Bank 0 55 6/20.2016 CD19443PAP4 Colonial Virginia Bank 0 55 8/24/2018 CD196121AM9 9'30/2015 248 000.00 1.35 6/19/2013 248 000 00 248 000 00 248 000 00 101.47 0 87 251 648.33 18 35 100 01 248 034.22 248 000 00 0.55 248 000 00 0 49 381 17 6/25/2013 248, 000.00 100.01 248,032.98 248 000.00 0.55 248 000.00 0.49 28.18 0.24% 3,648.33 None None 0.24% None 34.21 None 0.24% 32.98 None None ',125 3.02 81 0.22 85 0.23 Comendy Capital Bank 1 7 5/28/2018 11/26/2014 248 000.00 100 63 249.588.37 0.24% None 788 20033AJ11 248 000 00 1-70 248 000.00 1 40 57.75 1 566.37 None 2 12 Commercial Bank Ala Met+ 1 5 3/29/2019 6/30/2015 248 000 00 100 56 249 391 03 0-24% None 1093 201282GV6 248 000 00 1.50 248 000.00 1 31 20 38 1 391.03 None 2 93 Community National Bank Interest 1 25 4/4/2014 248 000 00 100 19 248 479.14 0.24% None 734 4/4/2018 20375WAM6 248 000 00 1 25 248.000.00 1 15 1 520 27 479,14 None 1 98 ConnectOne Bank 1.55 7/30/2018 1/30/2014 248.000.00 101 29 251 204 90 0.24% None 851 20786AAM7 248 000 00 1.55 248 000.00 0 99 0 00 3 204.90 None 2.29 Continental Bank 1.2 5 5/25/2018 2 t 1163EN6 248 000 00 De1Mtt Bank and Trust 0.5 6/20/2016 CD241888BT2 248 000 00 11/26/2014 748 000 00 100 48 1 25 248 000 00 1 02 6/24/2013 248.000.00 100.00 050 248 000 00 048 249,200 57 0.24% None 785 1078-63 1.200.57 None 212 248.008.68 0.24% None 81 37 37 8 68 None 0 22 Discover Bank 2 2/25/2020 2/25/2015 248-000 00 101 38 251 430 83 0,24% None 254672JA7 248 000 00 2 00 248 000.00 1 63 475.82 3,430.83 None Eaglebank Bethesda 1 15 12.'10/2018 3/9.'2016 248 000.00 100.30 248,732.59 0.24% None 27002YCV6 248 000 00 1.15 248 000 00 1.04 171 90 732.59 None EVB Tappa Nannock VA 1 6 9/25/2019 76977ABK7 Prepared by Rick Overgaard 9/25/2015 248 000.00 101 65 252 082.08 0.24°. None 248 000 00 1.60 248.000.00 1 12 65 23 4.082.08 None 1426 377 984 2 65 1273 34 6 of 12 14 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date IJesr r�l:riun c:uSu' Face Amount / Shares Settlement Date Cost Value Market Price Market Value YTM @ Cost Book Value YTM @ Market Accrued Interest % Portfolio Credit Rating Days To Call/Maturity Unre. Gain/Loss Credit Rating Duration To Maturity Evergreen Bank 1.2 6/29/2018 300185CY9 Fahey Banking 1.1 6/28/2019 Z48 300 0;. 6/29/2015 1 20 248.000-00 248.000.00 3/29/2016 248 000.00 100.11 1.15 248.278 SO 16.31 100.31 248 768 55 0.24% 278.50 None None 0.24% None 303117CC7 248 000 00 1 10 248 000.00 1 00 14 95 768.55 None Far East National Bank Los Angeles 1 3/31/2014 248 000.00 100.25 248.608.84 0,24% None 3/31/2017 307327EK8 248 000 00 1.00 248 000 00 0.75 0 00 608.84 None Farmers & Merchants Bank 1 45 925/2018• 4/25/2014 248 000 00 100.05 248 135 66 0.24% None 14 308882000 248 000 00 1.45 248 000 00 1 43 59 1 1 135.66 None Fidelity Homestead Savings Bank New 328/2014 248 000 00 99 98 247 954 37 0.24°6 None Orleans 0 6 11 31617CAD5 248.000 00 0 60 248 000.00 0 63 12.23 -45.63 None FIRST BANK HIGHLAND PARK 1 85 5/7/2014 248 000 00 100 12 248 307 77 0.24% None 5/7/2019-14 319141BL0 248 000 00 1.85 248 000 00 1 81 1 822 63 307.77 None First Bank McComb MS 1 5 2/282019 6/30/2015 248 000 00 100 79 249 951.02 0.24•n None 3 t 9234AJ9 248 000 00 1.50 248 000 00 1 23 30 58 1 951.02 None First Business Bank 1.7 6/30/2020 9/30/2015 248 000.00 101.81 252.491.53 0.24 None 319380P40 248,000.00 1.70 248 000 00 1.26 11 55 4,491.53 None F irst Capital Bank 1 4 8/6'2019 4/6/2015 248.000 00 101.00 250 480 74 0.24% Nona 31944FBK5 248,000.00 1.40 248 000 00 1 10 237 81 2.480.74 None First Eagle National Bank 1 45 11/21/2018 11/21/2014 248 000 00 100 87 250 158 59 0.24�� None 32008JAM5 248,000.00 1.45 248.000.00 1.11 1 290 62 2,158.59 None First Financial NW 1 35 10/30/2019 10/30/2015 248.000.00 101 64 252.055 30 0.24% None 32022MAF5 248.000.00 1.35 248 000 00 0 89 0 00 4,055.30 None First Intl Bank & Trust 1 6 1/16/2020 10/16:2015 248 000 00 101 60 251 956.10 0.24% None 32057GAE9 248.000 00 1 60 248 000.00 1 17 163 07 3,956.10 None Prepared by Rick Overgaard 820 2 22 1184 3 19 365 1 25 2 44 242 0 86 37 301 2 85 1552 4.12 1223 3.27 965 259 1308 3,5 1386 3 68 7 of 12 15 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date 3/31/2016 Description Face Amount 1 CUSIP Shares Settlement Date YTM -a" Cost Cost Value Market Price Market Value Book Value YTM Market Accrued Interest V. Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Matunty First National Bank 1 6 3(1912018 CD3211SCBE7 First National Bank ORD NEB 0 8 11/18/2016 32116RAC8 Flushing Bank New York 0.95 3/31/2017 34387AAH2 Fox Chase Bank 0 65 6/27/2016 CD351370AN4 Goldman Sachs Bank 2 2252020 36148JLL3 GUARANTY BMT 1 35 5/29/2018 400820E114 JP Morgan Bank 1 2'6(2019 48125TU86 Kansas State Bank 0.8 10/31/2016 485382DV4 248 000 00 9/18/2013 1 60 11,18/2013 248 000 00 248 000 00 248 000 00 248 000.00 0 80 248 000 00 3/31/2014 248 000.00 248 000 00 0 95 248 000 00 101.24 0.96 100 11 0 62 251 07421 130 45 248.276 52 728 37 0.24% 3 074.21 024% 276 52 None None None 718 1 94 232 None 0 63 100.20 248.488.56 0,24°i None 0.75 0.00 488.56 None 365 6(27(2013 248 000 00 100,04 248.087 30 1 24% None 88 248 000 00 0 65 248 000.00 0.50 17 87 87 30 None 0 24 2.762015 748 000 GO 101.23 251 055.86 0 74°- None 1426 248 000 00 2 00 248 000 00 1.67 475 62 3.055 85 None 3 77 5/29/2014 248 000.00 100.38 248.853.38 0.24!4 None 789 248 000 00 1.35 248 000 00 1.18 27.52 883 38 None 2.13 2/6/2015 248 000 00 10016 248 401 51 0 24% None 1042 248 000 00 1.00 248 000 00 0.94 368 90 401.51 None 2.81 ' 0/30/2013 248.000 00 100.11 248,279 99 0.24% None 214 248 000 00 0.80 248 000.00 0.61 0.00 279.99 None 0 58 Luana Savings Bank 1 25 6/19/2018 12/19/2014 248 000.00 100 56 249 383.10 0 24% None 549103005 248.000.00 1 25 248 000 00 1 00 874.79 1,383.10 None Machias Savings Bank 1 65 26 2020 2/6/2015 248 000 00 102.01 252 974 14 0.24% None 554479DS1 248.000,00 1.65 248 000 00 1 12 280.27 4,974.14 None Mahopac Bank 1 45 7/30/2019 1/30/2015 248 000 00 101.86 252.621 48 0.24% None 560150A06 248.000.00 1 45 248 000 00 0 88 600 98 4,621.48 None Manufacturers & Traders Trust 1 2 6/252018 6/242015 246 000.00 100 20 248 504 93 0.24% None 5647590V3 248,000.00 1 20 248.000.00 1 11 799 04 504.93 None Prepared by Rick Overgaard 16 810 2 19 1407 3 73 1216 3 26 816 221 8 of 12 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Uwe S1 Description Settlement Date Cost Value Market Price Face Amount I CUSIP Shares YTM @ Cost Book Value YTM Market Market Value Accrued Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call Matunty Duration To Maturity Martin Business Bank 0 55 6/14/2016 CD571 16AGF9 MB Financial Bank 1 1 3'18/2019 55266CO U 3 Moody National Bank 0.5 5/30/2016 248 000 00 6.14/2013 0.55 248 00000 248 000.00 100 01 0 48 248 036 46 63 53 0240. 36 46 None None 3/18/2016 248 000.00 100 29 248 730.61 0 24'/. None 248.000 00 1.10 248 000.00 1.00 97.16 730 61 None 11/30/2015 249,287.90 100 00 249.287.90 0.24% None 75 0.2 1082 2.92 60 7130C 249 287 90 0 50 249.287.90 0.50 416.62 0 00 None 0.16 Nebraskaland National Bank 1 2 9125/2018 63970QFC5 248 000 00 9/25!2015 120 248 000.00 101 11 250.749.08 0.24% None 908 248 000.00 0 75 48.92 2 749 08 None 2.45 Northwest Bank Boise Idaho 1.5 1/10/2019 4/10/2014 248.000 00 101,54 251.830.36 0 24% None 1015 66736AAD1 248 000 00 1,50 22248 000 00 0.94 214 03 3.630 36 None 2 72 OLDTOWN BANK 1 2 5/7/2018 6/6/2014 248.000.00 100 70 249 744 93 0,24°. None 767 8805406B6 248 000 00 1 70 248 000.00 0.86 203 8.4 1 744 93 None 2 08 Partners Bank 1 5 930/2019 3/30/2015 248 000.00 101 37 251 392.89 0.24°- None 1278 70212YAR3 248 000 00 150 248 000.00 1.10 0 00 3.392 89 None 3 41 Pearland State Bank 0 15 7/24/2016 7/25/2015 245 000.00 100,00 245 000.00 0 24% None 115 700013947 245 000 00 0 15 245,000.00 0.15 251.71 0.00 None 0 32 Peoples United Bank 1.9 11/19/2019 11/1912014 248 000.00 101.72 252 266.34 0.24°.. None 1328 7 1270QKM7 248 000 00 1 90 248 000 00 1.41 1 716 98 4 266 34 None 3.51 Plus International Bank 0.5 7/8/2016 7/8/2013 248,000 00 100.00 247,995.04 0.24% None 99 C072940UFV2 248 000 00 0 50 248 000.00 0.51 78.14 .4 96 None 0.27 Quantum Nation. Bank 1.2 9/18+2019-16 3/18/2016 248.000.00 100.33 248.818.85 0 24'; None 171 74765JETI 248 000 00 1 20 248.000 00 1.10 105.99 818 65 None 4.59 - Revere Bonk 1.35 8/29/2018 12/30/2014 248 000.00 100.49 249.207.02 0 24'; None 820 781402AU0 248 000 00 1 35 248 000.00 1.13 27 52 1 207 02 None 2.21 Salle Mae Bank 2.15 11/19/2019 11/191014 248 000.00 101.75 252 332.06 0.24% None 1329 795450VC6 248 000 00 2.15 248 000.00 1 65 1,942.89 4,332.06 None 3.49 Prepared by Rick Overgaard 9of12 17 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date 3/31/2016 Description Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity' Amount / CUSIP Shares YTM Cost Book Value YTM @ Market Accrued Interest Unre. Galn/LOSS Credit Rating Duration To Maturity San Diego Private Bank California 0 8 3'31/2017 79744YAB6 Signature Bank 1 35 3/28/2019 82669LFU2 Trust Atlantic Bank 1 45 12/6'2017 89835FJC5 United Bankers Bank 0 75 5/6/2016 909557CV0 Unity Bank 1.65 10/30(2020 9133OABCO Washington Federal 1.5 3/31/2021.16 938828AC4 Washington Trust Co 1.4 6115/2018 940637GU9 Webster Bank NA 1.9 2112/2019 94768NJM7 Welch State Bank 1 3 10/1/2018 949095AU7 Sub Total Certificate Of Deposit 248 000.00 248 000 00 248 000 OC 248 OCO 00 248.000 00 248 000 00 248 000 00 248 000 00 248 000 00 21.090,106.88 3/31/2014 080 9/29/2015 1.35 248.000 00 248.000.00 248,000.00 248.000 00 100.05 0.75 101 42 087 248 122.26 0.00 251,512.67 27.52 0.24% 122.28 0.24% None 3.512.67 None None None 11/6/2013 248 000.00 100.99 250 444.54 0 24°i: None 1 45 248 000 00 0 88 246 30 2 444 54 None 11/6/2013 248 000 00 100.03 248.072.66 0.24', None 0 75 248 000.00 0 45 127.40 72.68 None 10/30/2015 248 000 00 101,92 252,773.75 0.24% None 1 65 248 000 00 1.22 0.00 4.773.75 None 3/31/2016 248.000 00 100 29 248.717.96 0.24% None 1.50 248 000 00 1 44 0.00 717.96 None 12/15/2014 248 000.00 100.52 249.277.70 0.24% None 1.40 248 000.00 1 16 1.017.82 1277.70 None 2/12/2014 248.000.00 10150 251,728,88 0.24% None 1.90 2248.000.00 136 619.86 3.728.68 None 9/30/2015 248 000.00 101.08 250,880.83 0.24% None 1 30 248.000 00 21.090.106.88 1.23 21.090,106.88 0 86 264.99 2,680.63 None 365 1 1092 2.93 615 166 36 0.1 1674 4.42 183 4.82 806 2 17 1048 28 914 2 46 21,237,830.58 20.4% 769 0.98 42,511.46 147,723.70 2.22 FAMC Bond -AMC - C'3 :. 313 5P 1.00000000 Sub Total FAMC Bond 1,000,000.00 12/16/2013 997 890.00 101 63 1 77 998 897 96 997.890.00 106 1.77 998,897.96 1.06 1 016 295.00 8 504 4 0 965_ Moodys-Aaa 916 17 397 04 S&P -AAS 2 44 1.016.295.00 0.96% 916 8.504.44 17,397.04 2.44 FFCB Bond Prepared by Rick Overgaard 10 of 12 18 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date 3/31/2016 Description Settlement Date Cost Value Face Amount / CUSIP Shares YTM @ Cost Book Value Market Price YTM @ Market Market Value Accrued Interest Portfolio Credit Rating Days To Call/Maturity Unre, Gain/Loss Credit Rating Duration To Maturity FFCB 1 34 12/29/2017 3133E0E99 FFCB 1 5 1/28/2019 3133EDNFB FFCB 1.95 9/17/2018 3133ED2C5 Sub Total FFCB Bond 1 000 000 00 1,000 000 00 1 000 000 00 3.000.000.00 1/29/2014 1 24 5/28/2014 1.004 000 00 1.001 781 56 1.000.000.00 100.90 0.82 101.59 150 1,000,00000 0.93 1 009 016 00 3 424 44 0.96% 723444 Moodys-Aaa S&P -AA. 1 015 908.00 0.96 % Moodys-Aaa 2 625 00 15 908 00 561, -AA+ 1/29/2014 1.014,770 00 102.57 1.025 656.00 0 97% Moodys-Aaa 1 62 1 007.845 46 0.89 758 33 17 810.54 S&P -AA. 3,018.770.00 1.45 3,009,627.02 0.88 3,050.580.00 2.89% 6,807.77 40.952.98 638 1 72 1033 2.77 900 2.41 857 2.3 FHLB Bond FHLB 1.05 12.2912017.16 6:29+2015 3130A5MJ5 FHLB 1.75 12/14/2018 313378BR5 Sub Total FHLB Bond 1 000 000 00 1 000 000 00 2.000.000,00 1 05 999 900 06 100.14 1 001 431 00 0.96% S&P -AAS 90 999 930.22 0.97 2,683.33 1 500 78 Moodys-Aaa 73 12/16/2013 1000,670.00 102.33 1.023,269.00 0.96% Moodys-Aaa 998 1 74 1 000 362 58 0.88 5.201 39 22 906 42 S&P -AA. 2.64 2,000,570.00 2.024.700.00 1.92% 539 1.40 2,000,292.80 0.92 7.884.72 24,407.20 2.19 FHLMC Bora! FHLMC 1 9/29/201- 3137EA0L0 FHLMC 1 35 12/17/2018-15 3134G6S95 Sub Total FHLMC Bond 1/29/20' 4 994 150 00 100 36 1 003 635 00 0 96% Moodys-Aaa 547 1 000 000.00 1 16 997 615 68 0 76 55 55 6.019.32 S&P -AA. 1.49 6/19/2015 999.525 00 100 67 1 006 686.00 0.96% S&P -AA. 991 1 000.000 00 1.36 999 631 48 1 10 3 900.00 7.054.52 Moodys-Aaa 2.66 1,993,675.00 2.010,321.00 1.92% 769 2,000.000.00 1.26 1,997,247.16 0.93 3,955.56 13,073.84 2.08 FNMA Bond FNMA 0 875 10'26/2017 521/2014 3135G0P00 1.000.000.00 1.02 FNMA 0 875 12/20/2017 5/21/2014 3135G0 RT2 1,000.000 00 1.09 Prepared by Rick Overgaard 995 150.00 997 781.17 992.573.21 996.433.53 100.19 075 100.18 0 78 1,001,884.00 3,767.36 1,001.583.00 2 454.86 0 96% Moodys-Aaa 4,102 83 S&P -AA* 0 96% Moodys-Aaa 5149.47 S&P -AA. 574 1 56 529 1 71 11 of 12 19 -feer City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date 3/31/2016 Description CUSIP Face Amount , Shares Settlement Date Cost Value Market Pnce Market Value YTM Cost Book Value YTM a Market Accnied Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity FNMA 0.875 5/21/2018 3135GOWJ8 FNMA 1 625 11!2712018 3135G0YT4 Sub Total FNMA Bond 1 000,000 00 1 000 000 00 4.000,000.00 5'21+2014 1.26 985 050 00 992 005 90 7'1612014 1 004 411 00 10012 o8 101 98 1.52 1 002.684 22 0 8' 1.22 3.977,184.21 3,988,904.82 0.81 1 001.229 00 3 159 72 1 019 825 00 5 597.22 4, 024, 521.00 14,979.16 0.96" Moodys-Aaa S&P -AA. 9,223.10 0.97% Moodys-Aaa 17.140.79 S&P -AA. 3.85% 35,616.18 781 2 12 971 2.6 739 2 TOTAL PORTFOLIO 103.825,237.50 0.47 103.813,326.71 103.820.207.26 0.36 104,099.378.20 84,643.11 100.00 279,170.94 244 0.7 Prepared by Rick Overgaard 12 of 12 20 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date 3/31/2016 Description CUSIP Face Amount ! Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Shares YTM ie Cost Book Value YTM Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity 100: General Fund 1st United Bank FL 0 7 5/92016 33741TAU5 Allegiance Bank 0 5 9/13/2016 26115238 Bank Leumi USA 1 3 2(26/2020 063248FH6 11/8/2013 248 000.00 100 03 248 066 56 0.24 None 248,000.00 0 70 248.000.00 0 45 104 64 66.96 Nolte 247,818.98 248.000,00 35 0.11 9/14/2015 247 818.98 100.00 247 818 98 0.24% None 0 50 247 818 98 0.50 0 00 0.00 None 3/3/2016 248.000.00 99.15 245 892.00 0.24°< None 1 30 248 000.00 1 53 247 32 -2 108 00 None Bank of the Pacdic 1.25 7/30/2016 1!29/2015 248 000.00 101 13 250 809 100 24°4 None 06425BBN8 248.000.00 1.25 248.000.00 0 76 518 08 2.809.10 None Bankers Bank Owlahome 1 8 9/25!2020 9/25/2015 248 000 00 101.96 252 867.25 0.24 None 066100CV1 248,000.00 1.80 248.000 00 1 35 73 38 4.86725 None Belmont Savings Bank 1 65 12/23/2019 12123/2011 248 000 00 101 56 251 864.58 0.24% None 080515800 248 000 00 1 85 248 000 00 1 42 1.244.42 3,884.58 None Capital One NA 2 3 9/25/2020 14042RAB7 Cardinal Bank 0 5 5/17/2016 CD 14147VDM5 9/23/2015 248 000 00 101 98 252 910.15 024% None 248 000 00 2.30 248 000 00 1 84 93.78 4,910.15 None 5/17/2013 248 000 00 100 01 248 021 08 0 24% None 248 000 00 0 50 248 000 00 0 43 47 56 21 08 None CDARS 0 5 12/15/2016 12/17/2015 500.000.00 100.00 500.000.00 048'1 None 1018550896 500 000 00 0 50 500 000.00 0.50 719.18 0.00 None CDARS 0 9 6/16/2018 6/19/2014 500 000.00 100.00 500 000 00 0.48% None 1016754591 500.000.00 0 90 500 000 00 0.90 8 026.03 0 00 None Cd Bank Satt Lake 2 1 11(19/2019 17284C3Z5 Comenrly Capital Bank 1 7 5/28/2018 20033AJL1 Prepared by Rick Overgaard 11/19/2014 248,000.00 101,08 250674.93 0.24°, None 248 000.00 2.10 248 000 00 1 79 1,897.71 2 674 93 None 186 0 45 1427 382 851 23 1639 4.31 1362 36 1639 4 29 47 013 259 071 n 021 1328 3.49 11/26/2014 248 000 00 100.63 249.568.37 0 241< None 788 248 000.00 1 70 248 000 00 1 40 57.75 1.566.37 None 2.12 21 1 of 15 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date: 3/31/2016 Description CUSIP Face Amount 1 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 Commercial Bank Ala Mich 1.5 3/29/2019 201282GV6 Community National Bank Interest 1.25 4/4/2018 20375WAM6 Fahey Banking 1 1 6/28/2019 303117CC7 Farmers & Merchants Bank 1.45 9/25/2018- 14 308862DD0 6/30/2015 248 000 00 248,000.00 1 50 248 000.00 4/4/2014 248 000.00 100.56 1.31 100.19 249 391 03 2038 248 479 14 0.24% 1,391.03 0.24% 248 00000 1 25 248 000 00 1.15 1 520 27 479.14 3/29/2016 248 000-00 None None None None 100.31 248.768.55 0,24?i None 248.000.00 1 10 248 000 00 1.00 14 95 768.55 None 4/25/2014 248 000.00 100 05 248 135 66 0.24% 1093 2.93 734 1 98 1184 319 None 25 248.000.00 1.45 248.000.00 1.43 59.11 135.66 None 2.44 FFCB 1 34 12/29/2017 1/29/2014 1 004,000.00 100.90 1 009.016.00 0.96% Moodys-Aaa 638 3133EDE99 1 000.000.00 1.24 1 001 781 56 0 82 3 424.44 7,234.44 S8P-AA. 1 72 FHLMC 1 35 12/17/2018-15 6/19/2015 999.525.00 100 67 1 006,686.00 0.96% S&P -AA* 991 3134G6S95 1 000 000.00 1 36 999.631 48 1 10 3 900.00 7 054.52 Moodys-Aaa 2.86 - FIRST BANK HIGHLAND PARK 1 85 5/7/2014 248.000.00 100.12 248.307 77 0.24% None 37 5'7/2019-14 319141BL0 248.000.00 1.85 248.000 00 1.81 1,822.63 307.77 None 3.01 First National Bank 1.6 3/19/2018 9/18/2013 248.000.00 101 24 251.074.21 0.24°- None 718 CD32115C13E7 248 000 00 1 60 248.000.00 0 95 130 45 3.074.21 None 1 94 FNMA 0 875 12/20/2017 5/21/2014 992.573.21 100.16 1 001 583.00 0.96% Moodys-Aaa 629 3135G0RT2 1 000 000.00 1.09 996.433.53 0 78 2 454.86 5,149.47 S&P -AA. 1 71 JP Morgan Bank 1 2/6/2019 2/6/2015 248 000.00 100.16 248 401 51 0.24% None 1042 48125TU86 248 000.00 1.00 248.000 00 0 94 366.90 401.51 • None 2 81 Machias Savings Bank 1.65 2/6/2020 2/6/2015 248 000-00 102.01 252.974,14 0.24°i None 1407 554479051 248 00000 1 65 248 000.00 1.12 280.27 4.974 14 None 3 73 Mahopac Bank 1.45 7/30/2019 1130/2015 248,000.00 101.86 252.621.48 0.24% None 1216 560160A06 248.000.00 1 45 248 000 00 0 88 600.98 4.621 48 None 3.26 Prepared by Rick Overgaard 2 of 15 22 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date 3/3112016 Description CUSIP Face Amount 1 Settlement Date Shares YTM @ Cost Cost Value Book Value Market Price YTM @ Market Market Value Accrued Interest '6 Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity Moody National Bank 0.5 5/30/2016 7130C Pearland State Bank 0 15 7/24/2016 700013947 Plus International Bank 0 5 7/8/2016 CD72940UFV2 249 287.90 11/30/2015 0.50 249, 287 90 249.287.90 7/25/2015 245.000.00 245.000 00 0.15 245.000.00 0.15 100.00 0 50 249 287.90 416.62 100.00 245 000 00 7/8/2013 248,000.00 0,50 248.000.00 100 00 248,000.00 0.51 0.24°4 000 None None 0.24°' None 25171 0.00 None 247.995 04 0.24% 60 016 115 0.32 None 99 7814 -4.96 None 0.27 Quantum National Bank 1.2 9118/2019-16 3/18/2016 248 000.00 100.33 248,818 650.24°4 None 74765JETI 248.000,00 1 20 248.000.00 1.10 105 99 818.65 None Sallie Mae Bank 2 15 11/19%2019 11/19/2014 248 000 00 101.75 252 332 06 0.2414 None 795450VC6 248 000 00 2.15 248 000 00 1.65 1 942 89 4,332.06 None Trust Atlantk Bank 1 45 12!612017 t 1)6/2013 248 000 00 100.99 250,444 54 0.24'4 None 89835FJC5 248 000 00 1 45 248 000,00 0.86 246.30 2.444 54 None Unity Bank 1 65 10/30/2020 10/30/2015 91330ABC0 248.000.00 1.65 Washington Federal 1 5 3/31/2021-16 3/31/2016 938828AC4 248 000 00 1.50 248 C0O 00 101 92 24600000 1 22 248 000.00 100.29 248 000.00 1 44 252 773 75 0.24% None 0 00 4,773.75 None 248.71796 0.24% None 0.00 717.96 None Wells Fargo Sweep Cash 5/31/2006 21.793.314.92 100 00 21,793.314.92 20.99% None WFSWEEP 21.793,314.92 0.09 21 793,314.92 0.09 0.00 None Sub Total 100: General Fund 32.487,421.80 32.483.520.01 32.552.614.71 0.47 32,485,268.37 0.39 30,666.72 171 4 59 1328 349 615 1 66 1674 4.42 183 4.82 1 r, 31.31'/ 236 67,346.34 0.73 200: Debt Services 1st Source Bank • ' ' ' 18/2019 4/17/2015 33646CE03 248 000 00 1 50 Charter Bank 1 7 225/2020 '611648E7 248 000,00 Prepared by Pick Overgaard 2/25/2015 1.70 248 000 00 101.10 250.717.34 0.24°4 None 1327 248 000.00 1.19 1 691.84 2.717.34 None 3.53 248 000.00 100 07 248, 180.05 0.24% None 1428 248 000.00 1.68 69 30 180.05 None 3.78 3 of 15 23 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date 3/31/2016 Description CUSIP Face Amount r Shares Settlement Date Cost Value Market Price Market Value YTM @ Cost Book Value YTM Markel Accrued Interest °h Portfolio Credit Rating Days To Call/Maturity Unre. GaunhLoss Credit Rating Duration To Maturity 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 Partners Bank 1 5 9.30/2019 70212YAR3 Webster Bank NA 1.9 2/12/2019 94768NJM7 Wells Fargo Sweep Cash WFSWEEP Sub Total 200 Debt Services 248.000 00 248 000 00 248 000.00 248 000.00 248 000.00 248,000 00 14 875 994 95 16.859,994.95 1/30/2014 1 55 248 000 00 248.000 00 2/25/2015 248.000 00 2 00 248 000 00 4/6/2015 101.29 0 99 251 204.90 0.00 10138 251430.83 0.24°/ 3,204.90 None None 024% None 1 63 475.62 3 430.83 None 248 000 00 101 00 140 248,000 00 1 10 2/25/2015 248.000.00 101.23 851 2 29 1426 377 250.480 74 0.24% None 1223 237.81 2 480.74 None 3.27 251 055.86 0.24% None 1426 2.00 248 000.00 1 67 475 62 3.055.86 None 3 77 3/30/2015 248 000 00 101 37 251.392.89 0 24%, None ' 278 1 50 248 000.00 1 10 0 00 3 392.89 None 3 41 2/12/2014 248 000 00 101 50 251 728 88 0.24% None 1048 1 90 248.000 00 1 36 519 66 3.728.68 None 2.8 5;3112006 14 875 994 95 10000 0 09 14 875 994 95 0 09 0.28 16.859.994.95 16.859.994.95 14 875 994 95 '4.33% '6.682,1R6 24 0.24 3,569.85 0 00 None None 16.25% 148 22,191.29 0.39 305: Hotel/Motel Occupancy Americanwest Bank 0.8 1/25/2017 030590DS9 Capital Bank little Rock 1 35 3/22/2019 139797F13 '.25/2014 248 000.00 0 80 9/23/2015 248.000.00 1 35 Colonial Virginia Bank 0.55 6/24/2016 6/25/2013 CD196121AM9 248.000.00 0.55 First Intl Bank 6 Trust 1 6 1/16/2020 10/16/2015 32057GAE9 248.000.00 1 60 Prepared by Rick Overgaard 248.000 00 100 18 248 402.75 0 24'• None 248 000.00 0 60 358 75 402 75 None 248 000.00 101.45 251 604 68 0 24% None 248 000.00 0.86 82 55 3.604 68 None 248 000 00 100 01 248 032 98 0.24% None 248.000,00 0.49 26.16 32.98 None 248 000.00 101 60 251 956 10 0.24% None 248 000.00 1 17 163 07 3 956 10 None 300 0 82 1086 2.92 85 023 1386 3 68 4 ot 15 24 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date 3/31/2016 Description CUSIP Face Amount I Settlement Date Shares YTM Ci Cost Cost Value Market Price Market Value 1 Portfolio Credit Rating Days To Call/Maturity Book Value YTM Market Accrued Interest Unre. Gain/Loss Credit Rating Duration To Maturity ,VeIIs Fargo Sweep Cash WFSWEEP Sub Total 305 Hotel/Motel Occupancy '1; •o005 3.709.606.08 0.35 2. '760608 760608 3.709.606.08 3.709.606.08 100 0:: 3.717.60 2.59 2.82%< 0.00 None None 3.51% 0.27 630.53 7,996.51 192 0.51 310: Municipal Court Security Wells Fargo Sweep Cash WFSWEEP Sub Total 310 Municipal Court Security ` 31 7006 51 076 92 100 00 51 075 93 09 51 076 93 0 09 51,076.93 0.09 51,076.93 51,076.93 0.09 51,076.93 0.00 c 315: City Wide Donation Wells Fargo Sweep Cash 5/31/2006 65 076 49 100 0"1 WFSWEEP Sub Total 315' City Wide Donation 65 076 49 009 65.076.49 0.09 65 076.49 0 09 65.076.49 65.076.49 0.09 65 076.49 0 06% 0.00 65,076.49 0.06% 0.00 None None 0 0 320: Court Technology :"lens Fago Sweeo Cas,' WFSWEEP Sub Total 320 Court Technology 7.184.24 0.09 7 184.24 7.184.24 0.09 '84 Zei 001`4 None 0 00 None 7,184.24 0.01•/. 0.00 0 330: Park Donations Wells Fargo Sweep Cash WFSWEEP Sub Total 330: Park Donations 5'31,2006 119 086 69 100 00 009 118 086 69 004 118.086.69 0.09 118.086.69 118.086.69 0.09 118 086 69 011°. None 0 00 None 0 118.086.69 0.11'!. 0.00 0 331: Tree Trust Fund Wells F a'go Sweep Cash WFSWEEP Sub Total 331: Tree Trust Fund Prepared by Rick Overgaard 5'312006 6 746.67 100 03 6 746 67 0.09 6.746.67 0 09 6,746.67 0.09 6,746.67 6,746.67 0.09 6 746 6" 0 C 0 00 6,746.67 0.01% 0.00 Ncne None 0 0 or 15 25 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date 3/31/2016 Description Face Amount CUStP Shares Settlement Date YTM Cost Cost Value Book Value Market Price YTM C Market Market Value Accnied Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity 335: Police State Seizure Wells Fargo Sweep Casr, WFSWEEP Sub Total 335: Police State Se.rure 225.200 02 225.200.02 5%31,2006 225 200 02 0 09 225200 02 225.200.02 100 00 0 09 0.09 225.200.02 0.09 225 200 02 0 0.00 225,200.02 0.227. 0.00 No60 None 0 336: Federal Police Fund Wells Fargo Sweep Casn WFSWEEP Sub Total 336: Federal Police Fund 74,706.29 0.09 74.706.29 74,706.29 0.09 None 0 00 Nene 74.706.29 0.07% 0.00 0 340: Park & Rae Development Nebraskaland National Bank 1 2 9 25 2018 639700FC5 Wells Fargo Sweep Cash WFSWEEP Sub Total 340 Park & Rec Development 9/25/2015 248 000 00 101.11 250 749 08 0 24% None 908 248 000 00 1 20 248,000.00 0.75 48.92 2.749.08 None 2 45 5/31/2006 989.131.37 100 00 989 131 37 0 95% None 989,131.37 0.09 989.131.37 0 09 0 00 None 0 1,237.131.37 1,239.880.45 1.19% 183 1,237,131.37 0.31 1,237,131.37 0.22 48.92 2,749.08 0.49 345: Sidewalk Fund Wells Fargo Sweep Cash 5 31 2006 17 500 60 100 00 WFSWEEP 17 500 60 00 17 500 60 7 09 Sub Total 345: Sidewalk Fund 17.500.60 0.09 17 500 60 002°b 17.500.60 17,500.60 17.500.60 0.09 000 None None 1 0 0.02% 1 0.00 0 350: Grant Fund Wells Fargo Swee. 5 31,2006 5 299 65 WFSWEEP 5 ?4'• >: 0 09 5 299.65 0 09 Sub Total 350' Grant Fund 5,299.65 0.09 5 299 65 001°s 5.299.65 5,299.65 5,299.65 0.09 0 00 None None 1 0 0.01% 1 0.00 0 351: CDBG Fund Prepared by Rick Overgaard 6 of 15 26 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland CuSIF Face Arnount Shares Settlement Date Cost Value Market Price Market Value YTM @ Cost Book Value YTM a Market Accrued Interest % Portfolio Unre. Gain/LOss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Sub Total 351: CDBG Fund 948.27 11/152015 0.09 948.27 0.09 54? 948 . 948.27 100 0, 009 948.27 0.09 948.27 05.. 0.00 r,• 0 360: Traffic Impact Improvement United Bankers Bank 0 75 5/612016 909557CV0 Wells Fargo Sweep Cash WF SWE EP Sub Total 360 Traffic Impact Improvement 11/6/2013 248 000 00 0 75 5r31/2006 465 018 '3 0.09 713,018.73 0.32 248 000.00 100.03 248 072.66 0 24 Non, 248.000.00 0.45 127.40 72.66 None 465.018 73 100.00 465.018.73 0.45% None 465 018 73 0 09 000 None 713.018.73 713.018.73 0.22 713,091.39 0.69% 127.40 72.66 13 0.03 365: Court Juvenile Mgmt Wells Fargo Sweep Cash 9'15'2009 34 553 53 WFSWEEP 34 953 53 0.09 34 953 53 Sub Total 365 Court Juvenile Mgmt 34.953.53 0.09 15r, C :14 353 53 34,953.53 34.953.53 34,953.53 0 09 n,.: 0.03 0-00 Non, 0 370: Municipal Channel Wells Fargo Sweep Cash WFSWEEP Sub Total 370, Municipal Channel 4/15/2012 822.302.01 100 00 822 302 01 0 79' 822 302.01 0.09 822.302.01 0 09 0 00 822,302.01 0.09 822,302.01 822,302.01 822.302.01 0.09 0.79% 0.00 None None 0 0 375: U of H Fund Wets Fargo SweeF Casn 12'1'2009 50 501.62 100,00 50 501 52 0 05`s None WFSWEEP 50 501 62 0 09 50 501 62 0.09 0 00 None Sub Total 375 U of 11 Fund 50,501.62 0.09 50.501.62 50.801.82 50.501.62 0.09 0.05 0.00 0 376: U of H Capital Renewal Fund Prepared by Rick Overgaard 27 of 15 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date 3/31/2016 Description Face Amount / CUSIP Shares Settlement Date YTM @ Cost Cost Value Book Value Market Price YTM @ Market Market Value Accrued Interest % Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity Wells Fargo Sweep Cash WFSWEEP Sub Total 376 U of H Capital Renewal Fund 270.024.65 9i30/2013 0.09 270.024.65 0.09 270.024.65 270,024.65 270,024.65 •03 ,0n 270,024.65 0.09 270 024.65 270.024.65 026' 000 0.26% 0.00 None None 0 0 380: Regional Detention Wells Fargo Sweep Cash WFSWEEP Sub Total 380- Regional Detention 5.31 2006 1 49e 33 0 09 171,498.03 0.09 100 00 171 49803 • , 496 0 0 09 171,498.03 171,498.03 0.09 01'';, None 3 00 Noce 171.498.03 0.17 % 0.00 0 500: Capital Projects San Diego Private Bank Cakfornia 0 8 3/31/2017 79744YA86 Wells Fargo Sweep Cash WF SWEEP Sub Total 500 Capital Projects 3/31/2014 248,000.00 10005 248,122.26 0.24% None 248 000 00 0.80 248.000.00 0,75 0.00 122.26 None 5/31/2006 217,959.85 100.00 217.959.85 0 21% None 217 959 85 0.09 217.959.85 0.09 0 00 None 465,959 85 0.47 465,959.85 465.959.85 0.44 466.082.11 0.45% 0.00 122.26 0 195 0.53 501: Certificates of Obligation Luana Savings Bank 125 8/19/2018 549103005 Wells Fargo Sweep Casn WFSWEEP Sub Total 501: Certificates of Obligation 248,000 00 2 164 238 71 2.412,236.71 12/19/2014 248.000 00 100 56 249 383.10 0.24% None 1.25 248 000.00 1 00 874.79 1,383.10 None 5/31/2006 2 164 236 71 100 00 2 164 236 71 2.08% None 0 09 2 164 236.71 0 09 0 00 None 2.412,236.71 0.21 2.412.236.71 0.18 2.413.619.81 874.79 2.32% 1.383.10 810 2 19 0 84 0.23 502: General Obligation 2001 Wells Fargo Sweep Cash WFSWEEP Sub Total 502: General Obligation 2001 Prepared by Rick Overgaard 5/31:2006 46 90 46 90 0.09 46.90 0.09 40 90 100.00 46.90 0% None 1 0 09 0 00 None 0 46.90 46.90 0% 1 46.90 0.09 0.00 0 28 8 of 15 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date. 3/31/2016 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 Matunty 503: Certificates of Obligation 2006 2'rensfagoSweep Casa WF SWEEP Sub Total 503 Certificates of Obligation 2006 562 805 04 6.30 2006 552 805 04 0 09 562 805 04 562.805.04 0.09 562.805.04 562.805.04 0.09 562.805-04 0.54% 0.00 0 505: General Obligation 2008 C.Itic Ba1nk ? 6 6.28 2015 5:282013 CD15118RJDO 240,000.00 060 Webs Fargo Sweep Cash 12/31/2007 WFSWEEP -198.472.94 009 Sub Total 505 General Obligation 2008 49.527.06 2.64 248 000.00 248 000 00 -198 472.94 -198 472.94 49,527.06 100 02 248.059 02 0.24 %° None 89 0 50 12 23 59.02 NCtle 0 24 100 00 _198 472 94 -0.19% None 0 09 0.00 None 0 49.527.06 2.15 49,586.08 0.05% 442 12.23 59.02 1.2 606: General Obligation Capital One Bank USA ' ' ' ' '1,19/2014 248 000 0: 252 336 t. 0 24' None 1328 1404200%1 248 000 00 1 10 248 000 00 0.81 994 04 4 336.53 None 356 Citizens State Bank Clayton 1 35 4/30'2019 9/3012015 248 000.00 101 47 251 648 33 0.24°. None 1125 176688857 248 000 00 1 35 248 000 00 0 87 18 35 3,648.33 None 3.02 FFCB 1 5 1/28/2019 5/28/2014 1.000 000.00 101 59 1.015 908 00 0.96°•, Moodys•Aaa 1033 3133EDNF6 1 000 000 00 1.50 1 000 000 00 0 93 2,625 00 15.908.00 SBP -AA• 2 77 Fust Business Bank 1 7 6730/2020 9/30/2015 248.000 00 101.81 252 491 53 0.24°.6 None 1552 319380P40 248 000 00 1 70 248 000-00 1.26 11 55 4.491 53 None 4 12 Flushing Bank New York 0.95 3/31/2017 3/31/2014 248 000 00 100.20 248 488 56 0 24°< None 365 34387AAH2 248 000 00 0 95 248 000.00 0.75 000 488.56 None Kansas State Bank 0 8 10(31/2016 10/30/2013 248 000 00 100 11 248.279.99 0.24' None 214 485382DV4 248.000.00 0.80 248 000.00 0 61 000 279 99 None 0 58 Peoples United Bank 1 9 11,19/2019 11/19/2014 248 000 00 101 72 252.266 34 0 24°., None 1328 7i2700KM7 248,000.00 1 90 248 000 00 1 41 1 716 98 4 266.34 None 3.51 Prepared by Rick Overgaard 9of15 29 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date 3/31/2016 Dosr_-r,pt“nn Settlement Date Cost Value Market Price Market Value % Portfolio Credit Rating Days To Call/Maturity Face Amount CUSIP Shares YTM @ Cost Book Value YTM LID Market Accrued Interest Unre. GahULoss Credit Rating Duration To Maturity Revere Bank 1.35 6/29/2018 761402AU0 Wells Fargo Sweep Casn WFSWEFP Sub Total 506' General Obligation 248,000.00 3 975 557,33 6.712,557.33 12/30/2014 1.35 248,000.00 248.000.00 10/30/2008 3 976 557 33 10049 1.13 249.207.02 27.52 0 24% 1.207.02 None None 100.00 3 976.557 33 3.83% None 009 3971;1-,c- 33 0.08 0.00 None 6,712,557.33 6,747.183.63 L47% 0.61 6,712,557.33 0.4.4 5,393.44 34.626.30 820 2 21 0 403 1.08 550: WS Impact Fee Bank United 1 2 11/21/2017 066519AF6 Bankwest Inc 1 5 1/3/2020 06652CFA4 11,21/2014 248 000 00 100 27 248 666 13 3 24': None 248.000.00 1.20 248.000.00 103 1068.10 66613 None 3/4/2015 248.000.00 101.55 251.842.26 0.24% None 248 000.00 1.50 248 000 00 1.03 285 37 3.842.26 None 600 1 62 1373 3 65 BMW Bank 2.1 6/19/2020 6/19/2015 248 000.00 100.95 250.355.75 0.24°i None 1541 05580ABX1 248 000 00 2 10 248 000.00 1.85 1 469 65 2.355.75 None 404 Cedar Rapids Bank & Trust 1.5 10/30/2019 1/30/2015 248 000 00 101.99 252.920 07 0 24% None 1308 150517CJ7 248.000 00 1.50 248,000.00 0.94 305.75 4,920.07 None 3.49 College Savings Bank 0.55 6;20;2016 6/19/2013 CD19443PAP4 248 000 00 0 55 EVB Tappa Hannock VA 1.6 9/25/2019 26927ABK7 Far East National Bank Los Angeles 1 3/31/2017 307327EK8 FHLB 1 05 12129/2017-16 3130A5MJ5 First Financial NW 1 35 10/30/2019 32022MAF5 Prepared by Rick Overgaard 248.000 00 100.01 248 034.22 0,24% None 81 248.000 00 0.49 381 17 34.22 None 0.22 9/25/2015 248,000 00 101.65 252,082 08 0 24% None 248.000.00 1,60 248.00000 1 12 65.23 4 082.08 None 3/31/2014 248.000 00 100.25 248.608.84 0,240% None 248 000.00 1.00 248.000 00 0 75 0.00 608.84 None 6/29/2015 999 900.00 100.14 1 001.431 00 0.96% S&P•AA• 1 000 000.00 1.05 999 930 22 0.97 2.683.33 1.500,78 Moodys-Aaa 10/30/2015 248,000.00 101.84 252,055.30 0.24% None 248,000.00 1,35 248 000 00 0.89 0.00 4,055.30 None 1273 3.4 385 90 1.73 1308 3.5 10 of 15 30 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Dat 1,i,(11p111,11 Face Amount I Shares Settlement Date Cost Value Market Price Market Value YTM Cost Book Value YTM a Market Accrued Interest '. Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity FNMA 0 875 5121/2018 3'35G0WJ8 Washington Trust Co 1 4 6/15/2018 940637GU9 Welch State Bank 1.3 10/1/2018 949095AU7 Wells Fargo Sweep Cash WF SWEEP Sub Total 550' WrS Impact Fer 1 000 000 00 248 000 00 248 000.00 2 787 131 29 7.267,131.29 212014 1 26 965 050.00 992 005 90 12:15,2014 248 000 00 100.12 0.81 1.001 229 00 3 159.72 100 52 249.277.70 1 40 248 000.00 1.16 9/30/2015 248.000.00 101 08 1 30 248.000 00 0 86 5/31/2006 2 787 131 29 0.09 2 767 131.29 7.252,081.29 0.96% 9.223.10 Moodys-Aaa S&P -AA. 0.24% None 1 017 82 1.277.70 None 250.680 63 0.24% 781 2 12 806 2.17 None 914 264 99 2.680 63 None 2 48 100 00 2.787 131 29 2 68°' 0 09 0.81 7.259,067.41 0.63 None 1 0.00 None 0 7,294,314.27 7% 446 10,701.13 35,246.86 1.4 555' Shadow Creek Impact Lvergreen Bank 1 2 6/25020ib 6/29.2015 248 000 00 100 11 248 278 50 0.24% None 1320 300185CY9 248 000 00 1.20 248.000.00 1 15 16 31 278.50 None 2 22 GUARANTY BAT 1 35 50292018 5/2912014 248.000,00 100 36 248 883 38 0.24% None '89 400820BJ4 248 000 00 1 35 248.000,00 1 18 27 52 883.38 None 2 13 Manufacturers & Traders Trust 1 2 6/25/2018 6/24/2015 248.000.00 100 20 248 504 93 0.24% None 816 5647590V3 248,000 00 1 20 248 000.00 1.11 799 04 504.93 None 2 21 Marlin Business Bank 0 55 6/14/2016 6/14/2013 248 000.00 100 01 248 036.48 0 24% None 75 CD57116AGF9 248.000 00 0 55 248 000 00 0 48 63 53 36 46 None 0 2 Wells Fargo Sweep Cash 5/31/2006 288 818.77 100 00 288 818 77 0 28% None WFSWEEP 288 818 77 0 09 288 818.77 0 09 0.00 None 0 1,280.818.77 1,262,522.04 1.24% 484 Sub Total 555: Shadow Creek Impact 1.280.818.77 0.85 1,280.818.77 0.78 906.40 1,703.27 1.31 560: Certificates of Obligation 1998 Wells F arq, Sweep Casn 5/3107006 /1/" 573 19 '2(/ 00 31,7 573 'n n_ 35', None WFSWEEP 367 573 19 0 09 '..7,' 5" " 2" 1)1717' N�"" Prepared by Rick Overgaard 31 0 11 of 15 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date. 3/31/2016 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. Gam/Loss Credit Rating Duration To Maturity Sub Total 560 Certificates of Obligation 1998 367.573.19 0.09 367.573.19 367,573.19 009 367.573.19 0.35°5 0.00 0 565: Revenue Bonds 1999 & 2003 CALUSA NATIONAL BANK 3 5 9i22;2016 13151TAX4 Continental Bank 1.25 5125/2018 211163EN6 First National Bank ORD NEB 0 8 11/18/2016 32119RAC8 Signature Bank 1 35 3/2812019 82669LFU2 Wells Fargo Sweep Cash WFSWEEP Sub Total 565, Revenue Bonds 1999 6 2003 5232014 248.000 00 99.97 247 925 35 0,24/, None 248 000 00 0 50 248.000.00 0.56 30.58 -74.85 None 0.48 11/28/2014 248 000 00 100 48 249.200.57 0.24% None 785 248 000 00 1.25 248 000.00 1 02 1 078 63 1,200.57 None 2 12 175 11/18/2013 248 000.00 100 11 248.276 52 0.24% None 232 248 000 00 0.80 248 000 00 0 62 728 37 276.52 Nene 0 63 9/29/2015 248 000 00 101.42 251 512 67 0.244 None 1092 248 000 00 1.35 248.000.00 0.87 27.52 3.512.87 None 2.93 5/31/2006 2.581 055.64 100.00 2.581.055 64 2 49' , None 1 2 581 055 54 0.09 7 581 055 64 0 09 0.00 None 0 3.573.055.64 3.577,970.75 3.45% 159 3.573.055.64 0.34 3.573.055.64 0.28 1.865.10 4.915.11 0A3 570:W/SPay AsYou Go DeWdt Bank and Trust 0 5 6+202016 6/2412013 248 000 00 100 00 248.008 68 0 24''• None 81 CD241888BT2 248 000 00 0.50 248 000 00 0 48 37.37 8 68 None 0 22 Wells Fargo Sweep Cash 12/31'2007 1 436 159.69 100 00 1 436.159.69 1.38% None 1 WFSWEEP 1 438 159 69 0 09 1 436 15969 0 09 0 00 None 0 1.684.159.69 1,684,168.37 1.625E 13 Sub Total 570 WS Pay As You Go 1.684.159.69 0.15 1.684,159.69 0 15 37.37 8.68 0.03 575: MUD 4 Capital Programs Wells Fargo Sweep Cash WFSWEEP Sub Total 575: MUD 4 Capital Programs Prepared by Rick Overgaard 66591067 2/112013 ,cS atC 064'., None 1 0.09 'a105' 665,910.67 0.09 , 665,910.67 665.910.67 665,910.67 0.09 0 00 None 0 0.64'/. 1 0.00 0 12 0115 32 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date 3/31/2016 Description Face Amount 1 CUSIP Shares Settlement Date YTM @ Cost Cost Value Market Pnce Market Value / Portfolio Book Value YTM @ Market Accrued Interest Unre. Gain/Loss Credit Rating Credit Rating Days To CaII/Maturity Duration To Matunty 600: Water & Sewer BARCLAYS BANK DELAWARE 1 95 5/7/2019 06740KGU5 CDARS 0 5 6/16/2016 1017961604 Eaglebank Bethesda 1 15 12/10/2018 27002YCV6 248.000 00 56.2014 1 95 6/18/2015 500 000-00 100.00 500 000 00 0.48% 500.000-00 0.50 500,000,00 0.50 1.965 75 0.00 248 000 00 248 000 00 101 69 252 183 76 0 244. 1 39 1 921 15 4,183.76 248 000 00 3/9/2016 248,000 00 100.30 1.15 248 000.00 104 FAMC 1 72 10/3/2018 12/18/2013 31315P5A3 1 000 000 00 1 77 FFCB 1.95 9(1712018 3133ED2C5 1.000 000 00 997 890 00 101 63 998 897 96 106 248 732 59 0.2a% 171,90 732 59 None Nene None None None None 3 77 021 984 265 1 016 295 00 0.96" Moodys-Aaa 916 8 504 44 17 397 04 S&P -AA• 2 44 1/2912014 1 014 770 00 102.57 1 025.656 00 0.97% Moodys-Aaa 900 1 82 1 007.845.46 0.89 758 33 17.810.54 S&P -AA. 2.41 FHLB 1.75 12/14/2018 12/16/2013 1.000 870 00 102.33 1 023.269 00 0.96% Moodys-Aaa 988 313376BR5 1 000 000 00 1 74 1 000 362 58 0 88 5 201 39 22 906.42 S&P -AA. 2,64 FHLMC 1 9/29/2017 3137EADLO 1 000 000.00 1/29;2014 994 150.00 100 36 1,003.635.00 0.96% Moo2ys-Aaa 547 1 16 997 615.68 0.76 55.58 6.019.32 S&P -AA. 1 49 First Bank McComb MS 1.5 2/28/2019 6/30/2015 319234AJ9 248 000 00 1.50 248 000.00 100 79 249 951 02 0.24°, None 1064 248 000 00 1.23 30 58 1.951.02 None 2 85 First Eagle National Bank 1 45 11/21/2018 11/21/2014 248 000.00 100 87 250 158 59 0.24% None 985 32008JAM5 248 000 00 1.45 248 000.00 1.11 1 290.62 2,158.59 None 2 59 FNMA 0.875 10/26/2017 5/21/2014 995 150 00 100 19 1 001 884 00 096°a Moodys-Aaa 574 3135G0P00 1 000 000 00 1 02 997.781 17 0 75 3 767 36 4,102.83 S&P -AA. 1.56 FNMA 1.825 11/27/2018 7/16/2014 1 004 411.00 101 98 1 019 825 00 0.974, Moodys-Aaa 971 3135G0YT4 1 000 000 00 1 52 1 002,884.22 0 87 5.597.22 17 140.78 S&P -AA+ 2.6 Fox Chase Bank 0 65 6/27/2016 8/27/2013 248,000.00 100.04 248 087 30 0.24% None 88 CD351370AN4 248.000.00 Prepared by Ritk Overgaard 0.65 248 000,00 0 50 17.67 87,30 None 0.24 13 of 15 33 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date 3'31/2016 Description Settlement Date Cost Value Market Price Market Value Face Amount / CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Portfolio Unre. Gain/Loss Credit Rating Credit Rating Days To Call/Maturity Duration To Maturity MB Financial Bank 1 1 3/18/2019 55266C0U3 Northwest Bank Boise Idaho 1.5 1/10/2019 66736AAD1 OLDTOWN BANK 1.2 5/7/2018 680540886 Wells Fargo Sweep Cash WFSWEEP Sub Total 600: Water & Sewer 248.000 OC 248 000 00 248 000 00 10 978 246 33 19,462246.33 3/18/2016 110 248 000.00 248 000 00 4/10/2014 248.000.00 100.29 1.00 248,730.61 97.18 10154 251,830.36 1 50 248.000 00 0.94 6/6/2014 248 000.00 100 70 1 20 248.000.00 0 86 0.24% 730.61 None None 0.24% None 214 03 3 830.38 None 249 744.93 0.24% None 203.84 1.744.93 None 1082 2 92 1015 2 72 767 2.08 5/31/2006 10,978 246 33 100 00 10.978.248.33 10.57% None 0 09 .10 978 246 33 0 09 0.00 None 0 0.65 19,469.287.33 19.467,433.40 19,568.229.49 18.75% 345 0.43 29,797.00 100,796.09 0.92 610: Sofldwaste Fidelity Homestead Savings Bank New Orleans 0.6 11 31617CA05 Wells Fargo Sweep Cash WFSWEEP 3/28/2014 248.000.00 99.98 247.954 37 0.24% None 248 000 00 0.60 248.000.00 0.63 12.23 -45.63 None 12/1'2006 101.267.47 100 00 101 267.47 0.1% None 101 267 47 0 09 101.267 47 0.09 0.00 None Sub Total 610: Solidwaste 349.267.47 349.267.47 349.221.84 0.34% 0.45 349,267.47 0.47 12.23 242 0 66 0 172 -45.63 0.47 700: Property Liability Ins Welts argo Sweep Cash WFSWEEP Sub Total 700: Property Liability Ins 10/3112006 284 107.09 100.00 284 107 0C• 0 284.107.09 0.09 284 107.09 0 09 0 00 284.107.09 0.09 284,107.09 284,107.09 284,107.09 0.09 None Nene 0 0.27% 1 0.00 0 701: Employee Benefit Fund Wells Fargo Sweep Cash 9/11200' 87 522 74 100 00 87 522 74 0 08',. None WFSWEEP 87.522 74 009 87.522.74 0.09 0.00 None Sub Total 701: Employee Benefit Fund 87.522.74 0.09 87,522.74 87,522.74 87.522.74 0.09 0.08 0.00 0 1 0 702' Health Claims Fund Prepared by Rick Overgaard 14 of 15 34 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date 3/31/2016 Description CUSIP Face Amount r 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. GainlLoss Credit Rating Duration To Maturity Welk Fargo Cash WF9871 Wells Fargo Sweep Cash WFSWEEP Sub Total 702 Health Claims Fund 390 778 39 281 254 72 1.672,033.11 7; 2112010 009 390 778.39 390 778.39 9/15/2010 1 281 254 72 100.00 0.09 100 00 009 1.28125472 009 0.09 1,672,033.11 1.672,033.11 0.09 390 778.39 ' 281 254 72 1,672,033.11 0.38' 0.00 1 23% 0.00 1.61% 0.00 None None None None 0 TOTAL PORTFOLIO 103,825,237.50 103,813,326.71 0.47 103.820,207.26 104,099.378.20 100.00% 0.36 84,643.11 279.170.94 244 0.7 Prepared by Rick Overgaard 15 of 15 35 Bank Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Pledged Collateral Reconciliation Report March 31, 2016 Account Number 807-1613395 001-3042841 7169195455 818-4567843 179-0121790 280-7409871 Bank Account Number Wells Fargo 100-7284258 Account Name Credit Card Account Sweep Account False Alarm Reduction Program Alvin ISD EMS Payments Health Claims Total of Bank Balances Pledged Collateral for City FDIC Insurance Amount 87,067,220.50 247,389.05 7,852,576.10 390,778.39 $ 95,557,964.04 107,593,515.43 250,000.00 $ 107,843,515.43 Over (Under) Collateralized $ 12,285,551.39 Total % Collateralized Account Name Development Authority Total of Bank Balances Pledged Collateral for DAP FDIC Insurance 112.9% Amount 981,791.08 S 981,791.08 835,962.96 250,000.00 $ 1,085,962.96 Over (Under) Collateralized $ 104,171.88 Total % Collateralized 110.6% Total % Collateralized 112.8% Status Collateralized 36