Loading...
R2018-088 2018-05-14 RESOLUTION NO. R2018-88 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending March 2018. BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS: Section 1. That the City Council hereby accepts the Quarterly Investment Report attached hereto as Exhibit "A" for the quarter ending March 2018. PASSED, APPROVED, AND ADOPTED this 14TH day of May, A.D., 2018. Vic.v' TOM REID MAYOR ATTEST: ogai.zz,, MA E. RODRIGUEZ T Col ria DEPUTY CITY SECRETA'Y APPROVED AS TO FORM: Gr... C2 & . DARRIN M. COKER CITY ATTORNEY City of Pearland ',� Quarterly Investment Report ,' ` ' December 31, 2017 to March 31, 2018 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 1/31/2018 240,231,911.22 240,677,473.98 -445,562.76 1.35 1.80 302,556.92 129 2128/2018 209,412,714.80 209,934,012.99 -521,298.19 1.42 1.96 254,890.07 141 3/31/2018 213,449,317.64 214,006,762.49 -557,444.85 1.57 2.06 337,525.82 140 Total/Average 221,031,314.55 221,539,416.49 -508,101.93 1.44 1.94 894,972.81 136 U..4.—) ; yfirl-kie fir 421(iii_ Cynthia P-. son, airector of Finan e Date Rick 0 gaa-d, Assistant Finance Director Date ! P Page 1 of 38 City of Pearland '7,%'--,,y r$ Distribution by Security Type - Book Value Report Group: Pearland Begin Dale: 1213112017,End Dale:3/31/2018 Security Type Allocation Book Value %of Portfolio Book Value %of Portfolio Security Type 12131/2017 1213112017 3/31/2018 3/3112018 Cash 99,858.634.16 44.43 96,349,341.54 45.02 Certificate Of Deposit 23,566,695.73 10.48 23,318,695.73 10.90 FAMC Bond 8,002,501.79 3.56 8,002,241.75 3.74 FFCB Bond 3,002,266.86 1.34 3,001,469.92 1.40 FHLB Bond 2,998,646.03 1.33 4,998,825.88 2.34 FHLMC Bond 5,991,398.08 2.67 6.683.418.48 3.12 FNMA Bond 4,022,243.34 1.79 4,020,442.94 1,88 Local Government Investment Pool 77,334,300.28 34.40 67.632,326.25 31.60 Total/Average 224,776,686.27 100.00 214,006,762.49 100.00 Portfolio Holdings as of 12/31/2017 Portfolio Holdings as of 3/31/2018 44 44,43%-Cash 4) 45.02%-Cash 10.48%-Certificate 0... 10,9%-Certificate Of.,. 3,56%-FAMC Bondler A. 3.74% FANG Bond • 1,34%-FFCB Bond • 1.4%-FFCB Bond 1,33%-FHLB Bond '' 2.34%-FHLB Bond 2.67%-FHLMC Bond 3,12%-FRUv1C Bond # 1.79%-FNMA Bond $ 1.88%-FNMA Bond R! 34,4%-Local Governme.,. ' 31.6%-Local aovernme... Page 2 of 38 Prepared by Rick Overgaard 1 of 1 o City of Pearland Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date: 1213112017,End Date:3/31/2018 Maturity Range Allocation Book Value 'Y of Portfolio Book Value %of Portfolio Maturity Range 12/31/2017 1213112017 3/31/2018 3/31/2018 0-1 Month 177,440,934.44 78.04 164,229,667.79 76.74 -3 Months 248,000.00 0.11 4,228,106.69 1.98 3-6 Months 4,475,172.32 1.0f+ 2,486,539.86 1.16 6-9 Months 2,487,336.80 1,11 5,244,437.89 2.45 9-12 Months 5,244,580.18 2.33 5,739,669,49 2.68 1-2 Years 17,606,269.70 7.87 16,941,195.71 7.92 2-3 Years 10,235,864.11 4.55 8,237,629.92 3.85 3-4 Years 6,948,528.72 3.09 6,899,515.14 3.22 Total/Average 224,776,686.27 100.00 214,006,762.49 100.00 Portfolio Holdings • 180,000 - 160,000 140,000 '^ -o 120,000 c rig 100,000 0 12/31/2017 80,000 3/31/2018 60,000 40,000 - 20,000 1 ', MEE I1I 0-1 Month 1-3 Months 3-6 Months 6-9 Months 9-12 Months 1-2 Years 2-3 Years 3-4 Years Prepared by Rick Overgaard 1 ;r , Page 3 of 38 •.' City of Pearland i+4,g, Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date:4/30/2017,End Date:3/31/2018 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/2017 210,248,062.88 127,529.01 0.00 127,529.01 198,165,289.25 0.06 0.77 1.04 5/31/2017 187,893,317.51 145,230,06 0,00 145,230.06 188,445,011.54 0.08 0.93 1.12 6/30/2017 189,225,155.37 128,547.54 0.00 128,547,54 188,225,897.02 0.07 0.82 1.20 7/31/2017 194,196,038.32 138,935.57 0.00 138,935.57 193,382,294.06 0.07 0.87 1.22 8/31/2017 193,019,075,77 140,616.87 0.00 140,616.87 200,526,269.84 0.07 0.84 1,23 9/30/2017 214,526,996.30 135,576.25 0.00 135,576.25 213,508,815.92 0.06 0.76 1.28 10/31/2017 211,870,808,02 153,094.72 0,00 153,094.72 206,202,969.31 0.07 0.89 1.40 11/30/2017 202,071,066.62 141,153,46 0.00 141,153.46 201,468,935.57 0.07 0.84 1.56 12/31/2017 200,850,298.18 144,503.09 0.00 144,503.09 206,300,830.05 0.07 0.84 1.70 1/31/2018 224,894,930.21 302.556.92 0.00 302,556.92 232,787,416.50 0.13 1,57 1.80 2/28/2018 240,816,213.87 254,890.07 0.00 254,890.07 225,205,995 97 0.11 1.37 1,96 3/31/2018 210,050,683.35 337,525.82 0.00 337,525.82 211,626,642.26 0.16 1.93 2.06 Annualized TRR-BV 2,50 2.00 1,50 • Portfolio ----::, ,.d 1,00 .0 , Treasury 1 Year i 0 , , 0,50 .. ,‘ ,�g; 0.00 - -, ~- . ,, e:' 04/2017 05/2017 06/2017 07/2017 06/2017 09/2017 10/2017 11/2017 12/2017 01/2018 02/2018 03/2018 Prepared by Rick Overgaard 1 of 1 Page 4 of 38 ``'Y, City of Pearland laikliONS Portfolio Holdings by Security Type Report Group: Pearland Date:313112018 Description Settlement Date Cost Value Market Price Market Value "r%%Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Cash Welts Fargo Cash 7121/2010 371,809.39 100.00 371,609.39 0.17% None 1 WF9871 371,809.39 0.68 371.81)9 39 0.68 0.00 None 0 Wefts Fargo Sweep Cash 10/30/2008 4,382,983,17 100.00 4,362,963.17 2.04% None WFSWEEP 4,362,963.17 1.49 4,362,983.17 1.49 0.00 None Wells Fargo Sweep Cash 5131/2008 2,019,875.89 100.D0 2,019,875.89 0.94% None WFSWEEP 2,019,875.89 1.49 2.019,875.89 1.49 0.00 None u Wells Fargo Sweep Cash 5131/2006 951,404.81 100.00 951,404.81 0.44% None 1_ WFSWEEP 961,404.81 1,49 951.404.81 1.49 0.00 None ii Wells Fargo Sweep Cash 911512010 2,756,192.23 100.00 2,756,192.23 1.29% None 1. WFSWEEP 2,756,192.23 1.49 2,756,192.23 1.49 0.00 None o Wells Fargo Sweep Cash 5131/2006 2,656,991.24 100.00 2,658,991.24 1.24% None 1 WFSWEEP 2,656,991.24 1.49 2,656,991.24 1.49 0.00 None 0 _aw u Wells Fargo Swoop Cash 5/3112008 583,767.71 100.00 583,787.71 0.27% None 1 WFSWEEP 583,787,71 1.49 583,767.71 1.49 0.00 None 0 Welts Fargo Sweep Cash . 5131/2005 663,710,94 100.00 863,710.94 0.31% None 1 WFSWEEP 663,710.94 1.49 663,710.94 1.49 0.00 None 0 Wells Fargo Sweep Cash 5/3112006 14,215,381.20 100.00 14,215,381.20 6.64% None 1 WFSWEEP 14,215,381.20 1.49 14,215,381.20 1.49 0.00 Nene 0 Wells Fargo Sweep Cash 5/31/2006 383,755.05 100.00 383,755.05 0.18% Note 1 WFSWEEP 383,155.05 1.49 383,755.05 1.49 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 421,399.81 100.00 421,399,81 0.2% None 1 WFSWEEP 421,399.81 1.49 421,399.81 1.49 0.00 None 0 Wells Fargo Sweep Cash 513112006 381,504.84 100.00 381,504.84 0.18% None 1 WFSWEEP 381,604.84 1.49 381,504.84 1A9 0.00 None 0 Prepared by Rick Overgaard q c115 Page 5 of 38 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date:3/31/2018 Description Settlement Date Cost Value Market Price Market Value "rig Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM GCost Book Value YTM Q Market Accrued Interest Unre,Gain/Loss Credit Rating Duration To Maturity Welts Fargo Sweep Cash 9/15/2009 25,696.49 1110.00 25,695.49 0.01% None 1 WFSWEEP 25,696.49 1,49 25,896.49 1,49 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 222,829.61 100.00 222,829,61 0.1% None 1 WFSWEEP 222,829.61 1.49 222,829.61 1.49 0.00 None 0 Wells Fargo Sweep Cash 10/31/2006 642,454.11 100.00 642,454.11 0.3% None 1 WFSWEEP 642,454.11 1.49 642.454,11 1.49 0.00 None 0 Wells Fargo Sweep Cash 12/31/2007 1,998,312.56 100.00 1,998,31236 0.93% None 1 WFSWEEP 1,998,312,56 1.49 1,998,312.56 1.49 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 95,391.29 100.00 95,391.29 0.04% None i WFSWEEP 95,391.29 1.49 95,391.29 1.49 0.00 Note 0 Wells Fargo Sweep Cash 12/1/2006 -1,242,984.13 100.00 -1.242,984.13 -0.58% None 1 WFSWEEP -1,242,984.13 1.49 -1,242.984.13 1.49 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 235,577.94 100.00 235,577.94 0.11% None 1 WFSWEEP 235,57734 1.49 235,577,94 1.49 0.00 None 0 Wells Fargo Sweep Cash 12/1/2009 -370.34 100.00 -370.34 0% None 1 WFSWEEP -370.34 1.49 -370.34 1.49 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 75,262.22 100.00 75,282.22 0.04% None 1 WFSWEEP 15,282.22 1.49 75,282.22 1.49 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 27,018.24 100.00 27,018.24 0.01% None 1 WFSWEEP 27,018.24 1,49 27,018.24 1.49 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 129,536.81 100.00 129,536,81 0.06% None 1 WFSWEEP 129,536.81 1,49 129,536.81 1.49 0.00 None 0 Wells Fargo Sweep Cash 6/30/2006 63,478,25 100.00 83,478.25 0.03% None 1 WFSWEEP 63,478.25 1.49 63,478.25 1.49 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -227,233.82 100.01) -227,23332 -0.11% None 1 WFSWEEP -227,233.52 1.49 -227.233.82 1,49 0.00 None 0 Prepared by Rick Overgaard 2 of 15 Page 6 of 38 City of Pearland +t r ,,,, 4 Portfolio Holdings by Security Type Report Group: Pearland Date:3/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To CaltlMalurity Face Amount! CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gainli_oss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 10!1512015 451,81 100.00 451.81 0% None 1 WFSWEEP 451.81 1,49 451,81 1.49 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 12,973,040,04 100.00 12,973,040.04 6.06% None 1 WFSWEEP 12,973,040.04 1.49 12,973,040.04 1,49 0.00 None 0 Wells Fargo Sweep Cash 2/1/2013 24,678.62 100.00 24,678.62 0.01% None 1 WFSWEEP 24,678,62 1.49 24,678.62 1.49 0.00 None 0 Wells Fargo Sweep Cash 9/1/2007 160,873.16 100,00 160,873.16 0.08% None 1 WFSWEEP 160,873.16 1.49 160,873.16 1,49 0.00 None 0 Welts Fargo Sweep Cash 5/31/2006 6,308.34 100.00 6,308.34 0% None 1 WFSWEEP 8,308.34 1.49 6,308.34 1.49 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 81,235.99 100.00 81,235.99 0.04% Nate 1 WFSWEEP 81,235.99 1.49 81,235.99 1.49 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -32,430.76 100.00 -32,430.75 -0,02% None 1 WFSWEEP -32,430.75 1.49 -32,430,75 1.49 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 14,561,302.61 100,00 14,561,302:61 6.8% None 1 WFSWEEP 14,561,302.61 1.49 14,561,302.61 1,49 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 141,153.08 100.00 141,153.09 0.07% None 1 WFSWEEP 141,163.09 1.49 141,153.09 1.49 0.00 None 0 Wells Fargo Sweep Cash 11/15/2015 17,983.81 100.00 17,983.81 0.01% None 1 WFSwEEP 17,983.81 1.49 17,983.81 1.49 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 3,871,361.47 100.00 3,871,36147 1.61% None 1 WF41D2 3,871,361.47 1.49 3,871,361.47 1.49 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 10,038,993.65 100.00 10,038,993.65 4.89% None 1 WF5875 10,038,993.66 1.49 10,038,993.65 1.49 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 11,806,249.06 100.00 11,806,249.06 5.52% None 1 WF5883 11,806,249.06 1.49 11,806,249.06 1.49 0.00 None 0 Prepared by Rick Overgaard 3 of 15 Page 7 of 38 Aor City of Pearland i''ti Portfolio Holdings by Security Type Report Group: Pearland Date:3/31/2018 Description Settlement Date Cost Value Market Price Market Value f.,Portfolio Credit Rating Days To Call,'hlaturity Face Amount 1 CUSIP Shares YTM @ Cost Book Value YTM 41?Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo TWDB Cash 11/1/20111 10,8.84,395,13 100.00 10,884,395.13 5.09% None 1 WF4094 10,884,395.13 1.49 10,884,395,13 1.49 0.00 None 0 96,349,341.54 96,349,341.54 45% . Sub Total Cash 98,349,341.54 1.4ts 96,349,341.54 1.48 0.00 0 Certificate Of Deposit. 1st Security Bank of Wash t_1 1122/2021 712212016 248,000,00 95,85 237,897.34 0.12% None 1028 33625CAZ2 2;8,000.00 1,10 248,000.00 2.64 67.27 -10,302.66 None 2.77 1st Source Bank 1 511/18/2019 4/1712015 248,000.00 99.24 246,116.19 0.12% None 597 33646CE03 246,000.00 1.50 246,000.00 1.98 1,681.64 -1,883.81 None 1.61 Allegiance Bank 0.8 9/13/2018 9/13/2017 248.069.94 100.00 248.069.94 0.125E None 166 26115230 248,069.94 0.80 248.069.94 0.80 97.87 0.00 None 0.45 Ally Bank Midvale Utah 1.6 8/2912020 6129/2017 246,000.00 98.32 243,839.30 0.12% None 821 020061_3U5 248,000.00 1.80 248,000.00 2.57 1,125.17 -4,180.70 None 2.2 Alma Bank 1.3512/24/2020 8/24/2016 248,000,00 98.84 239,864.22 0.12% None 999 020080BB2 248,000.00 1.35 248,000 00 2.83 64.21 8,335.78 None 2.68 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000 DO 98.30 238,816.81 0.12% None 1199 02554130M1 248,000.00 1.35 248,000.00 2.53 183.45 -9.183.19 Norte 3.21 Bank Leumi USA 1.3 2126/2020 3/3/2016 248,000.00 98.60 245,017.80 0.12% None 887 063248FH6 248,000,00 1.30 248,000.00 1.94 291.48 -2,982,20 None 1,89 Bank of New England NH 1.4 6/30/2021 8/3002016 248,000.00 96.65 239,700.43 0.12% None; 1187 063847A1.1 248,000.00 1.40 248,000.00 2.47 9.51 -8,299.57 None 3.17 Bank of the Pacific 1,25 7/3012018 1/29/2015 248,000-00 99.85 247,632.71 0.12% None 121 06425BBN8 248,000.00 1.25 248,000.00 1.69 509.59 -367.29 None 0.33 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 99.16 245,919.28 0.12% None 909 08610QCV1 248000.00 1-80 248,000.00 2.15 73.38 -2,080.72 None 2.43 Prepared by Rick Overgaard 4 of 15 Page 8 of 38 _ City of Pearland 0-41 Portfolio Holdings by Security Type Report Group: Pearland Date:3/31/2018 Description Settlement Date Cost Value Market Price Market Value Portfolio Credit Rating Days To CalltMaturity Face Amount 1 CUSIP Shares YTM`Cost Book Value YTM(ed Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Bantrst,Inc.1.5 113/2020 314/2015 248,000.00 98.39 244,006.70 0,12% None 843 06652CFA4 248,000.00 1.50 248,000.00 2.44 285.37 -3,993.30 None 1.73 Bar Harbor Bank&amp;Trust 2.65 3/29/2021 3/29/2018 248,000.00 100.00 245,000.00 0.12% None 90 -16 066851WB8 246,000,00 2.65 248,000.00 2.85 36.01 0.00 None 2.88 - BARCLAYS BANK DELAWARE 1.95 5/6/2014 248,000:00 99.86 247,845.36 0.12% None 402 51712019 06740KGU5 248,000.00 1,95 248,000.00 2.09 1,907.90 .354,64 None 1.09 Be€mons Savings Bank 1,55 10/23/2019 12,2312014 248,000.00 99.51 246,778,85 0,12% None 571 080515500 245,000.00 1.85 248,000,00 2.17 1,231.85 •1,221.15 None 1.54 HMO Harris Rank 1.05 6/22/2018 6/2312016 248,000.00 99.56 247,657,76 0.12% None 83. 05581WHF5 248,000.00 1.05 248,000.00 1.85 699.16 •342.24 Nona 0,23 LL BMW Bank 2.1 6119/2020 6/1912015 248,000.00 98.74 244,569.74 0.12% None 811 05580ABX1 248,000.00 2.10 248,000.00 2.69 1,455.39 -3,130.26 None 2.17 Border State Bank 1.4 613012021 6/30/2016 248,000.00 96.04 238,164.16 0.12% None 1187 099703EF3 248,000.00 1.40 248,000.00 2.67 9.51 -9,815.84 None 3.17 Brickell Bank Miami FL.1.6510/28/2019 6/27,2017 248,000.00 98.92 245,321,85 0.12% None 576 108010AG6 248,000.00 1.65 248,000.00 2.35 33.63 -2,678.15 None 1.56 Business Bank of St Louis MO 1.5 612372021 , 6/2312017 248,000.00 97.30 241,315.16 0,12% None 1180 12325EHU9 248,000.00 1.80 248,000.00 2.67 97.84 •6,684.84 None 3.14 Capital Bank Little Rack 1.35 3/22/2019 9/2312015 248,000-00 99.84 247,594-27 0.12% None ..... - 356 139797FL3 248,000.00 1.35 248,000.00 1.52 82.55 •405,73 None 0.97 Capital One Bank USA 1.1 11/19/2019 11/19/2014 248,000.00 99.54 246,869.86 0,12% None 598 1404200X1 248,000.00 1,10 248,000.00 1.38 968.56 -1,130.14 None 1.62 Capital One NA 2,3 9/25/2020 9/23/2015 248,000.00 99.19 246,002.86 0.12% None 909 14042RAB7 248,000.00 2.30 248,000.00 2.64 93.76 -1,997.14 None 2.43 Prepared by Rick Overgaard 5 ot15 Page 9 of 38 City of Pearland . , Portfolio Holdings by Security Type Report Group: Pearland Date:3131/2018 Description Settlement Dale Cost Value Market Price Market Value Portfolio Credit Rating Days To CalliMaturay Face Amount i CUSIP Shares YTM @ Cost Book Value YTM(5n Market Accrued interest Uwe.GainiLoss Credit Rating Duration To Maturity Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 97.15 240,931 50 0.12% None 849 144153AW3 248,000.00 1.10 248,000.00 2.36 29.90 -7,068.50 None 2.29 CDARS 0.7 12/1312018 12/1512016 500.000.00 100.00 500,000.00 0.23% None 257 1019720221 500,000.00 0.70 500,000.00 0.70 834.25 0.00 None 0.7 CDARS 0.9 6/14/2018 6/1612016 500,000.00 100.00 500,000.00 0.23% None 76 1019145928 500,000.00 0.9D 500,000.00 0.90 1,072.60 0.00 None 0.21 CDARS 1.05 6/15/2019 6/15/2017 500,000.00 100.00 500,000.00 0.23% None 441 CDARS061517 500,000.00 1,05 500,000.00 1.05 1,294.52 0.00 None 1.2 Cedar Rapids Bank&amp:Trust 1.5 1/30/2015 248,000.00 99.67 247,191.77 0.12% None 576 10/30/2019 150517CJ7 248,000.00 1.50 248,000.00 1.71 305.75 -808.23 None 1.56 Charter Bank 1.72.1251'2020 2125/2015 248,000.00 98.51 244,304.06 0.12% None 696 1611648E7 248,000.00 1.70 248,000.00 2.50 69.30 -3,695.94 None 1.87 Cit Bank Salt Lake 2,1 11/19/2019 11/19112014 248,000.00 9958 246,909.54 0.12% None 598 172840325 248,000.00 2.10 248,000.00 2.37 1,883.44 -1,090,46 None 1.6 Citizens State Bank Clayton 1.35 4/30/2019 9/30/2015 248,000.00 99.78 247,462.58 0.12% None 395 176888857 248,000.00 1.35 248,000.00 1.55 9.17 -537.42 None 1.07 Comonity Capital Bank 1.7 5/28,2018 11/26/2014 248,000.00 100.00 247,990.08 0.12% None 58 20033AJL1 248,000.00 1.70 248,000.00 1.73 57.75 -9.92 None 0.16 Commercial Bank Ala Mich 1.5 3,29/2019 613012015 248,000.00 99.44 246,609.46 0.12% None 363 2012820V6 248,000.00 1.50 2.48,000,00 2.07 20.38 -1,390.54 None 0.99 Community Bank Pasadena 1.5 6/3012021 6/3047016 248,000.00 96.66 239,714.07 0.12% None 1187 203507802 748,000.00 1.50 248,000.00 2.57 10.19 -8,285.93 None 3.17 Community Bankers&439:Bank 1.4 6/3012016 248,000.00 98.65 239,700.43 0.12% None 1187 6/30/2021 20361LBR4 248,000.00 1.40 248,000.00 2.47 9.51 -8.299.57 None 3.17 Prepared by Rick Overgaard 60115 Page 10 of 38 4111Fr ', City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Dale:3/3112018 Description Settlement Date Cost Value Market Price Market Value f6,Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM n Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Community National Bank Interest 1.25 4/4/2014 248,000.00 100,00 247,992 31 0.12% None 4 4/4/2018 20375WAM6 248,000.00 1.25 248,000.00 1.52 1.511.78 -7.69 None 0.01 ConnectOne Bank 1.55 7/30/2016m 1/30/2014 248,000.00 100.03 248,079.86 0.12% None 121 20786AAM7 248,000.00 1.55 248,000.00 1.45 0.00 79.88 None 0.33 Continental Bank 1.25 5/25/2018 11/26/2014 248,000.00 99.96 247,897.58 0,12% None 55 211163EN6 248,000.00 1.25 248,000.00 1.52 1,070.14 -102.42 None 0.15 Discover Bank 2 2/25/2020 2/25/2015 248,000.00 99.07 245,691.62 0.12% None 896 254672JA7 248,000.00 2.00 248,000.00 2.50 462,03 -2,308 38 None 1.68 Eagiebenk Bethesda 1.15 12/10/2018 3/9/2016 248,000.00 99.87 247,181.85 0.12% None 254 27002YCV6 248,000 00 1.15 248,000 00 1.63 171.90 -818.15 Norte 0.69 EVB Tappa Hannock VA 1.6 9125/2019 9/25/2015 248,000.00 99.80 247,003.54 0,12% None 543 26927ABK7 248,000.00 1.60 248,000.00 1-88 65.23 -996.46 None 1.47 Evergreen Bank 1.2 6129/2018 6/29/2015 248,000.00 99.90 247,759.19 0.12% None 90 300185CY9 248,000.00 1.20 248,000.00 1.60 16.31 -240.81 None 0.24 Exchange Bank NEB 1.05 1/21/2020 7120/2016 248,000.00 97.51 241,822.82 0.12% None 881 301074C1-11 248,000.00 1.05 248,000,00 2.46 78.48 -6,177.18 None 1.79 Fahey Banking 1.t 6/28/2019 3/29/2016 248,000.00 90.24 246,102.80 0.12% None 454 303117CC7 248,000.00 1.10 248,000.00 1.72 22.42 -1,897.20 None 1.23 Farmers&amp:Merchants Bank 1.45 4/25/2014 248,000.00 99.84 247,604.69 0.12% None 25 9/2512018-14 308862DD0 248,000.00 1.45 248,000.00 1.78 59.11 -395.31 None 0.48 FIRST BANK HIGHLAND PARK 1.86 5/7/2014 248,000.00 99.70 247.267.90 0.12% None 37 5/7/2019.14 319141BL0 248,000.00 1.85 248,000.00 2.12 1,810.08 -732.10 None 1.09 First Bank McComb MS 1.5 2/28/2019 6/30/2015 248,000.00 99.66 247,154.82 0.12% Nono 334 319234AJ9 248,000.00 1.50 248,000.00 1.88 30.58 -845.18 None 0.9 Prepared by Rick Overgaard 7 of 15 Page 11 of 38 City of Pearland flAbOar Portfolio Holdings by Security Type Report Group: Pearland Date:3/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Cali/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity First Business Bank 1.7 6130/2020 9/30/2015 248,000.00 98.10 243,298.66 n 12"', None 822 319380P40 248,000.00 1,70 248,000,00 2.57 11.55 -4,}:41.34; None 2.21 First Capital Bank 1.4 816/71)19 41612015 248,000.00 99.43 246,579,46 0.12% None 493 31944FBK5 248,000.00 1.40 748,009.00 1.83 237.81 -1,420.54 None 1.34 First Eagle National Bank 1.45 11/2112018 11/2112014 248,000.00 99.85 247,625,27 0.12% None 235 32008JAM5 248,000.00 1.45 248,000.00 1.69 1,280.77 -374.73 None 0.64 First Financial NW 1,35 10/30J2019 1013012015 2411,000.00 98.44 244.143.35 0.12% None 578 32022MAF5 248,000.00 1.35 249,000.00 2.35 0.00 -3,856.65 None 1.57 First Intl Bank&amp;Trust 1.6 1/16/2020 10/16/2015 248,000.00 98.51 244,296.37 0.12% None 656 32057GAE9 248,000.00 1.60 248,000.00 2.45 163.07 -3,703.63 None 1.77 First National Bank of Ame.riaa 1.25 7/1512016 248,000.00 95.53 236,905.47 0,12% None 1202 7/15/2021 32110YHM0 248,000.00 1.25 248,000.00 2.68 636.99 -11,094.53 None 3.23 GNB Bank 1.5 6/30/2021 8/30/2016 248,000.00 96.66 239,714.07 0.12% None 1187 36198JGC6 248,000,00 1.50 248,000.00 2.57 10.19 -8,285.93 None 3.17 Gokfman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 99.07 245,691.62 0.12% None 696 38148J113 248,000.00 2.00 248,000.00 2.50 462.03 .2,308,38 None 1.88 GUARANTY a&amp:T 1.35 5/29/2918 5129/2014 248,000.00 99.97 247,929.57 0.12% None 59 4008208J4 249,000.00 1.35 248,000.00 1.53 18.35 -70.43 None 0.16 Gulf Coast Bank&amp;Trust 1.3 7/15/2021- 7/1512016 248,000.00 96.31 238,860.95 0.12% None 15 17 402194EX8 248,000.00 1.30 248,000.00 2.47 141.33 4,139.05 None 3.22 JP Morgan Chase Bk NA Columbus 2.1 2/15/2017 245,000.00 98.51 241,343.38 0.11% None 15 2/15/2021-17 48126XVW2 245,000.00 2.10 245,000.00 2.64 225.53 -3,656.62 None 2.79 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 96.65 239,693 24 0.12% None 1187 53362LAB0 248,000.00 1.40 248,000.00 2.47 285.37 -8,306.76 None 317 Prepared by Rick Overgaard 8 of 15 Page 12 of 38 ;,, .,, City of Pearland iiitkaila Portfolio Holdings by Security Type Report Group: Pearland Date:3/3112018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount! CUSIP Shares YTM a Cost Book Value YTM(a?Market Accrued Interest Unre.GainlLoss Credit Rating Duration To Maturity Luana Savings Bank 1.75 6/19/7018 12/19/2014 248,000.00 99.92 247,799.82 0.12% None BO 549103Q05 248,000,00 1.25 248,000.00 1.61 888.30 -200.38 None 0.22 Machias Savings Bank 1.65 7/6/2020 2/812015 248,000.00 99.48 246,707.92 0.12% None 677 554479051 245,000.00 1.85 248.000.00 1.94 280.27 -1,292.08 None 1.82 Mahopac Bank 1.45 7/30/2019 1/3012015 248.000.00 99.79 247,478.97 0.12% None 486 560160AQ6 248,000.00 1.45 248.000.00 1.61 591.12 •523.03 None 1.32 Manufacturers&amp:Traders Trust 1.2 8124)2015 248,000.00 99.92 247,707.14 0.12% None 86 6/2512018 564759QV3 248,000.00 1.20 248,000 00 1.55 790.88 -202.86 None 024 Marine Bank Springfield IL 1.8 6/29/2021 8,29/2017 248,000 00 97.44 241,658-39 0.12% None 1116 56817TA87 248,000.00 1.80 248,000.00 2.82 24.46 6,341.61 None 3.15 Marlin Business Bank 1.25 12/27/2019 6/29/2016 248,000.00 98.05 243,154.06 0.12% None 838 57116AMC9 248,000.00 1.25 248,000.00 2,40 16.99 -4,845.92 None 1.72 MB Financial Bank 1,1 3/18/2019 3/18/2016 248,000.00 90.46 246,656.34 0.12% None 352 55266CQ1J3 248,000.00 1.10 748,000.00 1.67 97,16 -1,343.66 None 0.98 Moody National Bank 0,5 5/30/2018 11/30/2017 248,625.79 100.00 248,625.79 0.12% None 60 7130G 248,825.79 0,50 248,825.79 0.50 412.11 0.00 None 0.16 National Bank Commerce Superior 1.25 7/15/2016 246,000.00 96.31 238,857,73 0.12% None 15 7/15/2021-17 633368F117 248,000.00 1.25 248,000.00 2.42 135.89 -9,142.27 None 3.22 Nebraskaland National Bank 1.2 9/2512018 9/25,2015 248,000.00 99.96 247,907.74 0.12% None 178 63970QFC5 248,000.00 1.20 248,000.00 1.28 48.92 -92.26 None 0.48 Northern Bank Ramp;Trust MA 1,1 7)12/2018 248,000.00 98.71 244,806.01 0.12% None 12 7/1212019-17 6647608H0 748.000.00 1.10 248,000.00 2.12 582.97 -3,193.99 None 1.27 Northwest Bank Boise Idaho 1.5 1/10/2019 4/1012014 248,000.00 99.97 247,915.93 0.12% None 285 66736AAD1 248,000.00 1.50 248,000.00 1.54 214.03 -84.07 None 0.77 Prepared by Rick Overgaard 9 of 15 Page 13 of 38 City of Pearland ARLAND Portfolio Holdings by Security Type Report Group: Pearland Date.3131/2018 Dr+scriptron Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days'To Call/Maturity Face Amount/ CliSIP Shares YTM ail Cost Book Value YTM 40 Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity OLDTOWN BANK 1,2 5/7/2018 816/2014 248,000.00 100.01 248,015.38 0.12% None 37 680540886 248,000.00 1.20 248,000.00 1.14 203.84 15.38 None 0.1 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 97.35 241.430.98 0.12.. None 822 69413CFD6 248,000.00 1.25 248.000.00 2.46 8 49 -6,569,02 None 222 Parkside Pint Bank&amp Trust 1.3 7/18/2018 248,000 00 96.30 238,824.74 0.12% None 18 7119/2021-17 70147ABX1 248,000.00 1.30 248,000.00 2.47 114„83 -9,175.26 None 3.23 Partners Bank 1.5 9/30/2019 3/30/2015 248,000.00 96.47 246,678.41 0.12% None 54$ 70212YAR3 248,000.00 1.50 248,000.00 1.88 0.00 -1,321.59 None 1.48 Pearland Slate Bank 0.9 7/24/2018 7/24/2017 245,000.00 100.00 245,000.00 0.11% None 115 700013947B 245,000.00 0.90 745,000.00 0.90 1,510.27 0.00 None 0.32 Peoples United Bank 1.9 11119/2019 11/1912014 248,000.00 99.53 246,828.45 0.12°! None 598 71270QKM7 248,000.00 1.90 248,000.00 2.20 1,704,07 -1,171.55 None 1.61 Portage County Bank 1,4 6124/2021 6/2412016 248,000.00 96.67 239,743.58 0.12% None 1181 73565N13Q5 248,000.00 1.40 248,000.00 2.47 66.59 4,258.42 None 3.16 Quantum National Bank 1.2 911812019-16 3/18/2018 248,000.00 98.53 244,362.58 0.12% None 79 74765J8T1 248,000.00 1.20 248,000.00 2.22 105.99 -3,637.42 None 1.45 Revere Bank 1.35 612912018 12/30/2014 248,000.00 99.95 247,865.58 0.12% None 90 761402AU0 248,000.00 1.35 248,000,00 1.57 18.35 -134.42 None 0.24 Saltie Mae Bank 2.15 11119/2019 1111912014 248,000.00 99.54 246,870.36 0.12% None 598 795450VC6 248,000.0D 2.15 248,000.00 2.44 1,928.28 -1,129.64 None 1.6 Selling Stale Bank OK 1.55 7/7/2021-17 7/717016 248,000.00 96.67 239,740.36 0.12% None 7 816050AA6 248,000.00 1.55 248,000,00 2.62 252.76 -8.259.64 None 3.18 Signature Bank 1.35 3/28/2019 9/29/2015 248,000.00 99.81 247,540.21 0.12% None 382 82669LFU2 248,000.00 1.35 248,000.00 1.54 27.52 -459.79 None 0,99 Prepared by Rick Overgaard 10 of 15 Page 14 of 38 ''� City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date:3/3112018 Description Settlement Date Cost Value Market Price Market Value °S,Portfolio Credit Rating Days To CalBMaturity face Amount! CUSIP Shares YTM CT,Cost Book Value YTM @ Market Accrued interest Unre.Gain/Loss Credit Rating Duration To Maturity Summit Community Bank Moorefield WV 6/30/2017 248,000,00 09.21 246,051.96 0.12% None 454 1.55 6/28/2019 86604XLX2 248,000.00 1.55 246,000.00 2.19 31.59 -1,948.04 None 123 Umpqua Bank Roseburg OR 1.6 6/28/2019 6/30/2017 248,000.00 99.28 246,202.00 0,12% None 454 90421MAX1 248,000.00 1.60 248,000.00 2.19 989.28 -1,798.00 None 1.23 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 99.10 745,770,73 0.12% None 944 91330ABC0 248,000.00 1.65 248,000,00 2.01 0.00 2.229.27 None 2.53 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 96.31 238,844.56 0.12% None 1199 92834C8W1 248,000.00 1.30 246,000.00 2.48 697.80 -9,155.42 None 3.22 Washington Federal 1,5 3/31/2021-16 3/31/2016 246,000.00 97.22 241,108.33 0.12% None 30 938628AC4 248,000.00 1,50 248,000.00 2.46 0.00 -6,891.67 None 2.93 Washington Trust Co 1.4 6/1512018 12/15/2014 248,000.00 99.97 247,913.70 0.12% None 76 940637(09 248,000.00 1.40 248,000.00 1.56 1,008.31 -86.30 None 0.21 Webster Bank NA 1.0 2/12/2019 2/12/2014 248,000.00 99.92 247,789,45 0.12% None 318 94768NJM7 248,000.00 1.90 248,000.00 2.00 606.75 .210.55 None 0.87 Welch State Bank 1-3 1011/2018 9/30/2015 248,000.00 99,95 247,880.96 0.12% None 184 949095AU7 248,000.00 ' 1.30 248,000 00 1,40 264.99 .119.04 None 0.5 Wells Fargo Bank 1.75 6117/2021 6/20/2016 248,000 00 96.71 239,848.98 0.12% None 1174 9497485W3 248,000.00 1.75 248,000.00 2..82 166.47 48,151.02 None 3.12 23,318,695.73 23,038,849.45 11.23% 493 Sub Total Certificate Of Deposit 23,318,695.73 1.44 23,318,695.73 199 39,158.17 -279,846.28 1.59 FAMC Bond FAMC 1.58122/2019 2122(2017 1,000,000.00 98,1,' 080,743.09 0.47% SAP-AA+ 509 3132XOPV7 1,000,000.00 1.50 1,000,000.00 2-'2:) 1,625.00 -10,257.00 Moodys-Aaa 1.38 FAMC 1.5 8/22/2019 2/22/2017 7,001,700.00 98.97 1,979,486,00 0.93% SAP-AA+ 509 3132X0PV7 2,000,000.00 1.47 2,000,946.33 2.26 3,250.00 -21,460.33 Moodys-Aaa 1.38 Prepared by Rick Overgaard 11 of 15 Page 15 of 38 City of Pearland ,,; ,. „ , Portfolio Holdings by Security Type Report Group: Pearland Date:3131/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount l CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FAMC 1.5 8122/2019 2/22/2017 1,000,000.00 98.97 989,743.00 0.47% S&P-AA4 509 3132X0PV7 1,000,000.00 1.50 1,0013,000.00 2.25 1,625.00 -10,257.00 Mond/is-Ana 1.38 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 98.68 986,814.00 0.47% Moodys-Aaa 695 3132X0PW5 1,000,000.00 1,63 1,000,758.89 2.39 1,721.53 -13,944.89 S&P-AA+ 1.87 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 98.68 986,814.00 0.47% M0odys-Aaa 695 3132X0PW5 1,000,000.00 1.83 1,000,758.89 2.39 1,721.53 -13,944.89 S&P-AA+ 1.87 FAMC 1.72 1013/2.018 12/10/2013 997,890.00 99.91 999,075.00 0.47% Moodys-Aaa 186 31315P5A3 1,000,000.00 1.77 999,777.64 1.91 8,504.44 -702.64 S&P-AA+ 0.5 FAMC 1.82 11/912020 11/912017 1,000,000.00 98.26 982,603.00 0,47% Moodys.Aaa 954 3132X0ZC8 1,000,000.00 1.82 1,000,000.00 2.51 7,178.89 -17,397.00 S&P-M+ 2.54 8,001,998.00 7,914,276.00 3.75% 571 Sub Total FAMC Bond 8,000,000.00 1.60 8,002,241,75 2.28 25,626.39 -87,963.75 1.54 FFCB Bond FFCB 1.51/28/2019 5/28/2014 1,000,000.00 99.67 996,726.00 0.47% Moo1ys-Aaa 303 3133E0MF6 1.000,009.00 1.50 1,000,000.00 1.90 2,625.00 -3,774.00 S&P-AA+ 0.82 FFCB 1.84 10/30/2020.18 10/3062017 1,000,000.00 96.27 982,722.00 0.47% Moodys-Aaa 213 3133EHM26 1,000,000 00 1 R4 1,000,000.00 2.54 7,666.67 -17,278.00 S&P-AA+ 2.51 FFCB 1.959117/2018 1/20,2014 1,014,770.00 100.02 1,000,242.00 0.47% Moodys-Aaa 170 3133ED2C5 1,000,000.00 1.62 1,001,469.92 1.90 758.33 -1,227.92 S&P-AA+ 0.46 3,014,770.00 2,979,690.00 1.41% 229 Sub Total FFCB Bond 3,000,000.00 1135 3.001,469.92 2.11 11,050.00 41,779.92 1.26 FHLB Bond FHLB 1 912812019 9/22/2016 997,430.00 98.19 981,1181.00 0.47% Moodys-Aaa 544 3130A9EP2 1,000,/00.00 1.09 998,731.80 2.25 138.89 -18,850.60 S&P-AA+ 1.48 FHLB 1.45 6/28/2019-17 6/28/2017 1,000,0/0.00 99.09 990,942.00 0.47% Moodys-Aaa 09 3130A8HRO 1,000,000.00 1.45 1,000,000.00 2.19 3,745.83 -9,058.00 S8.P-AA+ 1.23 Prepared by Rick Overgaard 12 0115 Page 16 of 38 ,, City of Pearland iii:ABlitia Portfolio Holdings by Security Type Report Group: Pearland Date:3/31/2018 Face Amount f Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To CattlMaturity Shares YTM @1 Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FHLB 1.7512114/2018 12/16/2013 1,000.670.00 99.79 997,068.00 0.47% Moodys-Aaa 258 313376085 1.000,000.00 1.74 1,000,094,28 2.06 5,201.39 -2,226.28 S&P-AA+ 0.7 FHLB 2.2 112912021.19 1/29/2018 1,000,000.00 99.34 993,438,00 0.47% Moodys-Aaa 304 3130ADC26 1,000,000.00 2.20 1,000,000.00 2.44 3,788.89 -6.562.00 S&P-AA+ 225 FHLB 2.4 31271202.0-18 3/27/2018 1,000,000.00 99.88 998,816.00 0,479E S&P-AA+ 88 3130ADSH6 1,000„000.00 2.40 1,000,000.00 2.46 266.67 -1,184.00 Moodys-Aaa 1.95 4,998,100.00 4,962,945.00 2.35% 257 Sub Total FHLB Bond 5,000,000.00 1.77 4,908,825.88 2.28 13,141.67 -35,88188 1.62 FHLMC Bond FHLMC 1.125 8/12/2021 9/22/2016 990,540 00 95 53 955.268.00 0.46% Moodys-Aaa 1230 3137EAEC9 1,000,000.00 1.37 992,114.74 2.52 1,375.00 -36,846.74 S&P-AA+ 3.3 FHLMC 1 3512117/2018-15 6/19/2015 999,525.00 99.52 995,164 00 0.47% S&P-AA+ 261 313466595 1,000,000.00 1.36 999,903.34 2.04 3,900.00 -4,739.34 Moodys-Aaa 0.71 FHLMC 1.42 3/2912019-17 3/29/2017 2,000,000.00 99.24 1,984,812.00 0.93% S&P-AA+ 182 3134GA6G4 2,000,000.00 1.42 2,000,000.00 2-20 157.78 -15,188.00 Moodys-Aaa 0.99 FHLMC 2 11/20/2020.18 12/5/2017 1,000,000.00 98.76 987,600.00 D.47% Moodys-Aaa 50 3134GBW32 1,000,000.00 2.00 1,000,000,00 2.49 7,277.78 -12,400.00 S&P-AM 2.56 FHLMC 2.2 12/812021-18 12/8/7017 1.000,000.00 98.50 984,984.00 0.47% Moodys-Aaa 69 3134G84N9 1,000,003.00 2.20 1,000,000.00 2.63 6,905.56 -15,016.00 S&P-M+ 3.54 FHLMC Step 8/3/2021.18 3/W2018 691,243.00 98.53 689,718.40 0.32% S&P-AA+ 33 3134GBA93 700,000.00 2.61 691,400.40 2.59 1,973.61 -1,682.00 Moodys-Aaa 3.24 6,679,308.00 6.597,546.40 3.12% 297 Sub Total FHLMC Bond 6,700,000.00 1.73 6,683.418.48 2.38 21,589.73 -85,872.08 2.14 FNMA Bond FNMA 0.875 5/21/2018 5/2112014 985,050.00 99.88 998,838.00 0.47% Moodys-Aaa 51 i 3135G0WJ8 1,000,000.00 1.26 999,480.90 1.71 3,159.72 -642.90 S&P-AA+ 0.14 I Prepared by Rick Overgaard 13 of 15 Page 17 of 38 , City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date:3/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Cali/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FNMA 1.375 3/13/7019-16 9!2212016 1,009,560.00 99,25 992,402.04 0.47% Moodys-Aaa 347 3136G1FY0 1,000,000.00 0.96 1,003,669.49 2,18 687.50 -11,177,49 S&P-AA4 0.95 FNMA 1.625 11/27/2018 7/16/2014 1,004,411.00 99.74 997,406.00 0.47% Moodys-Aaa 241 313500Y74 1,000,000.00 1.52 1,000,662.63 2.02 5,597,22 -3,256.63 S&P-AA+ 0.65 FNMA 1,875 12/28/2020 9/2,2/2016 1,025,880.00 98.56 985,605.00 0.48% Moodys-Aaa 1003 3135G0H55 1,000,000.00 1.25 1,016,529.92 2.42 4,843,75 -31,024.92 S&P-AA* 2.67 4,024,901.00 3,974,341.00 1.695E 413 Sub Total FNMA Bond 4,000,000.00 1.25 4,020,442,94 2.08 14,288.19 -46,101.94 1.11 Local Government Investment Pool Texas Class I.(11P 5!15'2017 3,037,293.57 100 I'D 3,037,243.57 1 42% None 1 TX-01-0615.00011 3,037,293.57 1.75 3,037,293.57 1.75 0.00 None 0 Texas Class LGIP 12/20/2016 22,983,765.26 100.00 22,983,765.26 10.74% None 1 TX-01-0615.0001 22,983,765.26 1.75 22,983,765.26 1.75 0.00 None 0 Texas Class LGIP 12/20/2016 3,564,059.22 100.00 3,564,059.22 1.67% None I TX-01-0615.0001 3,564,050.22 1.75 3,564,059.22 1.75 0.00 None 0 Texas Class LGIP 1115/2017 1,015,313.27 100.00 1,015.313.27 0.47% None 1 TX-01.0615-0001 1,015,313.27 1.75 1,015,313.27 1.75 0.00 None 0 Texas Class LGIP 1/15/2017 3.096,309.60 100.00 3,096,309.60 1.45% None 1 TX-01-0615-0001 3,096,309.60 1.75 3,096,309.60 1,75 0.00 Norse 0 Texas Class LGIP 1/15/2017 1,015,313.27 100,00 1,015,313.27 0.47% None 1 TX-01-0615-0001 1,015.313.27 1.75 1,015,313.27 1,75 0.00 None 0 Texas Class LGIP 12)20/2016 5,083,835.43 100.00 5,083,835.43 2.38% None 1 TX-01-0615.0001 5,083.835.43 1.75 5.083,835.43 1.75 0.00 None 0 Texas Class LGIP 5/15/2017 19,730.52 100.00 19,730.52 0.01% None 1 TX-01-0615.0001 19,730.52 1.75 19,730.52 1.75 0.00 None 0 Prepared by Rick Overgaard 14 of 15 Page 18 of 38 { City of Pearland iffitaitail Portfolio Holdings by Security Type Report Group: Pearland Date:3131/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount 1 CUSIP Shares VIM Q Cost Book Value YTM Q Market Accrued Interest Unre.GainlLoss Credit Rating Duration To Maturity Texas Class LGIP 5/15/2017 506,215.58 100.00 506,215.58 0.24% None 1 TX-01-0615-0001 506,215.58 1.75 506,215.58 1.75 0.00 None 0 Texas Class LGIP 12/20/2016 17,173,818.12 100.00 17,173,818.12 8.02% None 1 TX-01.0815-0001 17,173,818.12 1.75 17,173,818.12 1.75 0.00 None 0 TexSTAR LGIP 6126/2016 5,068,511.28 100.00 5,068,511.28 2.37% S&P-AAA 1 02000-11110 5,086,511.28 1,50 5,068,511.28 1.50 0.00 None 0 TexSTAR LGIP 8/26/2016 8,068,161.13 100.00 5,068.161.13 2.37% S&P-AAA 1 02000-11110 8,068,161.13 1.50 5,068,161.13 1.50 0.00 None 0 67,632,326.25 67,632,326.25 31.61% 1 Sub Total Local Government Investment 67,632,326.25 1.71 67,632,326.25 1.71 0.00 0 Pool 214,019,432.52 213,449,317.64 100.00% 102 TOTAL PORTFOLIO 214,000,363.52 1.57 214,006,762.49 1.71 124,854.15 -557,444.85 0.37 Prepared by Ricic Overpaid 15 of 15 Page 19 of 38 City of Pearland ,, ,, °,' Portfolio Holdings by Portfolio Name `sr to, Report Group: Pearland Date:3131/2018 Description Settlement Dale Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares VIM r;,fD Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 100:General Fund Allegiance Bank 0.89/13/2018 ;411312017 248,069.94 100.00 248,069.94 712% None 168 26115230 248,069.94 0.80 248,069.94 0,60 97.87 0.tin None 0.45 Alma Bank 1.35 12/24/2020 6/2412016 248,000.00 96.64 239,664.72 0.12% None 999 020050992 248,000.00 1.35 248,000.00 2.63 64.21 8,335.78 None 2.68 American Eagle Sank IL 1.35 7/12/2021 7/11/2016 248,000.00 96.30 736,816.81 0.12% None 1199 025548CM1 248,000.00 1.35 248.000 00 2 53 183.45 -9,183.19 None 321 Bank Leumi USA 1.3 2/2612020 3/3/2016 248.000,OD 98.60 245,017 EW 0.12% None 697 063248FH6 248,000.00 1.30 248,000 OD 1.94 291.45 -2,962.20 None 1.89 Bank of the Pacific 1.25 7/30/2018 1/29/2015 248,000.00 99.85 247,632.71 0.12% None 121 0642500M8 246,000.00 1.25 248,000.00 1.69 509.59 -367.29 None 0.33 Bankers Bank Oklahoma 1.8 9/25/2020 9125/2015 248,000.00 99.16 245,919.28 0,12% None 909 06810QCV1 248,000.00 1.80 248,000.00 2.15 73.38 -2,080.72 None 2.43 Bar Harbor Bank damp,Trust 2.65 3/29/20213/2912018 248,000.00 100.00 248,000.00 0.12% None 90 -18 066851WB8 248,000.00 2.85 248,000.00 2.65 36.01 0.00 None 2.68 Belmont Savings Bank 1.8510/2312019 12/23/2014 248,000.00 99.51 246,778.55 0.12% None 571 080515800 248,000.00 1.85 248,000.00 2.17 1,231.85 -1,221.15 None 1.54 Capital One NA 2.3 9/25/2020 9123/2015 248,000.00 99.19 246,002.86 0.12% None 909 14042RA87 248,000.00 2.30 248,000.00 2.64 93.76 -1,997.14 None 2.43 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 97,15 240,931.50 0,12% None 849 144153AW3 248,000.00 1.10 248,000.00 2.36 29.90 -7,068.50 None 2.29 CDARS 0.7 12/13/2018 12/15/2016 500,000.00 100,00 500,000.00 0.23% None 257 1019720221 500,000.00 0.70 500,000.00 0.70 834.25 0.00 None 0.7 CDARS 0.9 6/1412018 6/16/2016 500,000.00 100.00 500,000.00 0.23% None 75 1019145928 500,000.00 0.90 500,000.00 0.90 1,072.60 0.00 None 0.21 Prepared by Rick Overgaard 1 of 17 Page 20 of 38 City of Pearland iiiit44446Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares VIM @ Cost Book Value VIM @ Markel Accrued interest Unre,Gain/Loss Credit Rating Duration To Maturity Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248,000,00 09.56 246,909.54 0.12% None 598 17284C3Z5 248,000.00 2.10 248,000,00 2.37 1,883.44 -1,090.46 None 1.6 Contenity Capital Bank 1.7 5/28/2018 11120/2014 248,000.00 100,00 247.990,08 0,124E None 58 20033AJL1 248,000.00 1.70 246,000.00 1.73 57.75 -9.92 None 0,16 Commercial Bank Ala Mich 1.53/29/2019 6130/2015 246,000.00 99.44 246,609.46 0.12% None 363 201282GV6 240,000.00 1.50 246,000.00 2.07 20.38 -1,390.54 None 0.99 Community Bank Pasadena 1.5 6/30/2021 8/30/2016 246,000.00 96.66 239,714.07 0,12% None 1187 2035079G2 248,000.00 1.50 248,000.00 2.57 10.19 -8,285.93 None 3.17 Community Bankers&#39;Bank 1.4 6/30/2016 248,000.00 96.85 239,700.43 0.12% None 1187 6/3012021 20361LBR4 248,000.00 1.40 248,000.00 2,47 9.51 -8,299.57 None 3.17 Community National Bank Interest 1.25 414/2014 248.000.00 100.00 247,992.31 0.12% None 4 4/412018 20375WAM6 248,000.00 1.25 248,000.00 1.52 1,511.78 -7.69 None 0.01 Exchange Bank NEB 1.05 112112020 7/20/2016 248,000.00 97.51 241,822.82 0.12% None 661 301074CH1 248,000.00 1.05 248,000.00 2.46 78.48 -6.177.18 None 1.79 Fahey Banking 1.1 6/28/2019 3/29/2016 248,000.00 99.24 246,102.80 0.12% None 454 303117CC7 248,000.00 1.10 248,000.00 1.72 22.42 -1,897.20 None 1.23 FAMC 1.6752/24/2020 2/24/2017 1,001,200.00 98.68 986,814,00 0.47% Moodys.Aaa 695 3132X0PVV5 1,000,000.00 1,63 1,000,758.89 2.39 1,721.53 •13,944.89 S&P-AA+ 1.87 Farmers&amp;Merchants Bank 1.45 4/2512014 248,000.00 99.84 247,604.69 0.12% None 25 • 9/25/2018-14 308862DD0 248,000.00 1.45 248,000.00 178 59.11 •395.31 None 0.48 FHLB 1.45 6/28/2019-17 8/28/2017 1,000,000.00 99.09 990,942.00 0.47% Moodys-Aaa 89 3130A13H80 1,000,000,00 1.45 1,000,000.00 2.19 3,745.83 -9,058.00 S&P-AA+ 123 FHLB 2.4 3/2712020-18 3/27/2018 1.000,000.00 99.88 998,816.00 0.47% S&P-AA+ 88 3130ADSH6 1,000,000.00 2.40 1,000,000.00 2.46 286.67 -1,184.00 Moodys-Aaa 1.95 Prepared by Rick Overgaard 2 of 17 Page 21 of 38 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/31/2018 Description Settlement Date Cost Value Market Price Market Value Portfolio Credit Rating Days To Call/Maturity Face Amount 1 CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FHLMC 1.35 12/1712018-15 6/1912015 999,525.00 99.52 995,164.00 0-47% SAP-AA+ 261 313406895 1,000,000.00 1.36 999,903.34 2.04 3,900.00 -4,739.34 Moodys-Aaa 0.71 FHLMC 1.42 3/29!2019.17 3/29/2017 2,000,000.00 99.24 1,984,812.00 0-93% S&P-AA+ 182 3134GA6G4 2,000,000.00 1,42 2,000,000.00 2,20 157.78 -15,188.00 Moodys-Aaa 0.99 FHLMC Step 8/3/2021-18 31912018 891,243.00 98.53 689,718.40 0.32% St3P-AA+ 33 313409493 700,000.00 2.51 691,400,40 2.69 1,973.61 -1,682.00 Moodys-Ass 3.24 FIRST BANK HIGHLAND PARK 1.85 5/7/2014 248,000.00 99.70 247,287.90 0.12% None 37 5/7/2019-14 3191419Ln 248,000.00 1.85 248,000.00 2.12 1,810.06 -732.10 None 1.09 JP Morgan Chase Bk NA Columbus 2.1 2/1512017 245,000.00 98.51 241,343.38 0,11% None 15 2/15/2021-17 48126XVW2 245,000.00 2,10245,000.00 2.64 225.53 -3,656.62 None 2.79 Machias Savings Bank 1.65 2/6/2020 2/612015 248,000.00 99.48 246,707.92 0.12% None 877 554479DS1 248,000.00 1.6$ 248,000.00 1.94 280.27 -1,292.08 None 1.82 Mahopac Bank 1.45 7/30/2019 1/30/2015 248,000 00 99.79 247,476.97 0.12% None 486 560160406 248,000.00 1.45 248,000,00 1.61 591.12 -523.03 None 1,32 Moody Nailonal Bank 0,5 5/30/2018 11/3012017 248,625.79 10n.00 248,625.79 0.12% None 60 7130E 246,625.79 0.50 248,625,79 0.50 412.11 0.00 None 0.16 Pearland State Bank 0.9 7024/2018 7/24/2017 245,000.00 100.00 245,000.00 0.11% None 115 70001394713 245,000.00 0 90 245,000.00 0.90 1,510.27 0.00 None 0.32 Quantum National Bank 1.2 9/18/2019-16 3/18/2016 248,000.00 98.53 244,382.58 0.12% None 79 74765JET1 248,000.00 1.20 248,000.00 2.22 105.99 -3.637.42 None 1.45 Sallie Mae Bank 2.1511/19/2019 11/1912014 248.000.00 99.54 246.870.36 0.12% None 596 795450VC6 248,000,00 2.15 248,000.00 2.44 1,928.28 -1,129.84 None 1.6 Selling Stale Bank OK 1.55 7/7/2021-17 7/7/2016 248,000.00 96.67 239,740.36 0.12% None 7 816050446 246,000.00 1.55 248,000.00 2.82 252.76 -8,259.64 None 3.18 Prepared by Rick Overgaard 3 of 17 Page 22 of 38 1:,.."-. City of Pearland '>:: ;:;s ' Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To CalllMaturity Face Amount I CUSIP Shares VIM @ Cost Book Value VIM @ Market Accrued Interest Unre,Gain!Loss Credit Rating Duration To Maturity Texas Class t.GIP :,/1,12017 10,730,52 100.00 19,730.52 0.01% None 1 TX-01-0615-0001 19,730.52 1.75 19,730.52 1.75 0.00 None 0 Unity Bank 1,5510/30/2020 10/30/2015 248,000.00 99.10 245,770.73 0.12% None 944 91330A8C0 248,000.00 1.65 248,000.00 2.01 0.00 -2,229.27 None 2.53 Vision Bank of Iowa 1.3 7112/2021 7/11/2018 248,000.00 98.31 238,844.58 0.12% None 1199 92834C8W1 248,000.00 1.30 248,000.00 2.48 697.80 -9,155,42 None 3,22 Washington Federal 1.5 3/31/2021-16 3/3112016 248,000.00 97.22 241,108.33 0.12% None 30 938828AC4 248,000.00 1.50 248,000.00 2.46 0.00 -6,891.87 None 2.93 Wells Fargo Bank 1.756117/2021 6/20/2016 248,000.00 96.71 239,848.98 0.12% None 1174 9497485W3 248,000.00 1.75 745,000.00 2.82 166.47 -8,151.02 None 3.12 Wells Fargo Sweep Cash 5/31/2006 14,215,381.20 100.00 14,215,381.20 6.64% None I WFSWEEP 14,215,381.20 1.49 14,215,381.20 1.49 0.00 None 0 29,857,775.45 29,705,826.17 14.06% 194 Sub Total 100:General Fund 29,865,807.45 1.52 29,857,870.08 1.81 27,917.49 •152,243.91 0.83 200:Debt Services 1st Source Bank 1 11/18/2019 4/17/2015 245,000,00 99.24 246,116.19 0.12% None 597 33646CEQ3 748,000.00 1.50 245,000.00 1.08 1,681.64 -1,883.81 None 1.81 Charter Bank 1.7 2/2512020 2/25/2015 245,000,00 98.51 244,304.06 0.12% None 896 181164BE7 248,000,00 1,70 248,000.00 2,50 69,30 -3,895.94 None 1.87 ConnectOne Bank 1.557/30/2018 1/30/2014 248,000.00 100.03 248,079.86 0.12% None 121 20786AA1‘.17 248,000.00 1.55 248,000.00 1.45 0.00 79,86 None 0.33 Discover Bank 2 2/25/2020 2/25/2015 248,000.00 99.07 245,691.62 0.12% None 696 254672JA7 248,000.00 2.00 248,000.00 2.50 462.03 -2,308.38 None 1.88 First Capital Bank 1.4 8/6/2019 4/612015 248.000.00 99.43 246,579.46 0.12% None 493 31944F8K5 248,000.00 1,40 248,000.00 1,83 237.81 -1,420.54 None 1.34 Prepared by Rick Overgaard 4 of 17 Page 23 of 38 ;, :y City of Pearland iiithaitaili Portfolio Holdings by Portfolio Name Report Group: Pearland Date:313112018 Description Settlement Date Cost Value Market Price Market Value Portfolio Credit Rating Days To Cann/Maturity Face Amount 1 CUSIP Shares VIM @ Cost Book Value VIM Q Market Accrued Interest un re Garn)Loss Credit Rating Duration To Maturity Goldman Sachs Bank 2 2125/2020 7/7512015 248,000.00 99.07 245,691.82 0.12% None 696 38148JLL3 248,000,00 2.00 248,000.00 2.50 462.03 -2,308.38 None 1.88 Partners Bank 1.5 9/3012019 31301201h 248,000.00 99.47 246,678,41 0.12% None 548 70212YAR3 248,000.00 1.50 248,000.00 1.86 0.00 -1.321.59 None 1.48 . Texas Class LGIP 1/15/2017 3,096.309.60 100.00 3,096,309.60 1.45% None 1 TX•01.0615-0001 3,006,300.80 1.75 3,096.309.60 1.75 0.00 None 0 Webster Rank NA 1.9 2/12/2019 2/12/2014 248.000,00 99.92 247,789.45 0.12% None 318 94766N.IM7 248,000.00 1.90 248,000.00 2.00 606.75 -210.55 None 9.87 Wells Fargo Sweep Cash 5/31/2006 12,973,040.04 100.00 12,973,040.04 6.06% None 1 WFSWEEP 12,973,040.04 1.49 12,973,040.04 1.49 0.00 None 0 18,053,349.64 18,040,280.31 8.47% Ili Sub Total 200:Debt Services 18,053,349.64 1.56 18,053,349.64 1,60 3,519.56 -13,069.33 0.15 305:Hotel/Motel Occupancy Alfy Bank Midvale Utah 1.8 6/29/2020 6/29/2017 248,000.00 98.32 243,839.30 0.12% None 821 02006L3U5 248,000.00 1.80 248,000 00 2 57 1.125.17 -4,160.70 None 2.2 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 96.65 239,700.43 0.12% None 1187 063847AL1 248,000.00 1.40 248,000.00 2.47 9,51 -8,299.57 None 3.17 Capital Bank Little Rock 1.35 3/22/2019 9123/2015 248,000.00 99.84 247,594.27 0.12% None 356 139797FL3 248,000.00 1.35 248,000.00 1.52 82.55 -405.73 None 0.97 First Intl Bank&amp;Trust 1.6 1/16/2020 10116/2015 248,000.00 98.51 244,296.37 0.12% None 656 32057GAE9 248,000.00 1.60 248,000.00 2.45 163.07 -3,703.63 None 1.77 Texas Class LGIP 5115122017 3.037,293.57 100.00 3,037,293.57 1.42% None 1 TX•01.0615.0001 3.037,293.57 1.75 3,037.293.57 1.75 0.00 None 0 Webs Fargo Sweep Cash 5/31/2006 663.710.94 100.00 663,710,94 0.31% None 1 WFSWEEP 883,710.94 1.49 663.710.94 1.49 0.00 None 0 4,693,004.51 4,676,434.88 2.21% 160 Sub Total 305:Hotel/Motel Occupancy 4,693,004.51 1.67 4,693,004.51 1,82 1,380,30 -16,569.63 0.43 Prepared by Rick Overgaard 5 of 17 Page 24 of 38 a „ City of Pearland ' ` °,,* .,,, Portfolio Holdings by Portfolio Name . 4 Report Group: Pearland Date:313112018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount 1 CUSIP Shares YTM c@ Cost Book Value VIM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 310:Municipal Court Security Wells Fargo Sweep Cash 5/3112006 27,018.24 100 Cr .",0'r 21 0.01% None 1 WFSWEEP 27,018.24 1.49 27,018.24 1.49 0.00 None ,. 27,018,24 27,018.24 0.01% 1 Sub Total 310:Municipal Court Security 27,018.24 1.49 27,018.24 1.49 0.00 0 315:City Wide Donation Wells Fargo Sweep Cash 5131/2006 75,282.22 100.00 75,282.22 0,04% None 1 WFSWEEP 75,282.22 1.49 75,282.22 1.49 0.00 None 0 75,282.22 75,282.22 0.04% 1 Sub Total 315:City Wide Donation 75,282.22 1.49 75,282.22 1.49 0.00 0 320:Court Technology Woos Fargo Sweep Cash a 5/31/2006 -32,430.75 100.00 -32,430.75 -0.02% None 1 WFFWFFP -32,430+'1, 1.49 -32,430.75 1.49 0.00 None 0 -32,430.75 -32,430.75 •0,02% 1 Sub Total 320:Court Technology -32,430.75 1.49 -32,430.75 1.49 0.00 0 330: Park Donations Welts Fargo Sweep Cash 5/31/2006 95,391.29 100.00 95,391.29 0,04% None 1 WFSWEEP 95,391.29 1.49 95,391.29 1.49 0.00 Nate 0 95,391.29 95,391.29 0.04% 1 Sub Total 330:Park Donations 95,391.29 1.49 95,391.29 1.49 0.00 0 331;Tree Trust Fund Wells Fargo Sweep Gas') 5/31/2006 421,399.81 100.00 42',399,B1 112% N:-,9,„, , WFSWEEP 47',3e51R 1 1.49 .;9 421,399 81 1 1(1 2" e 1 Nrn .:1 421,30'0.81 421,390.81 0.27,, 1 Sub Total 331:Tree Trust Fund 421,339.81 1.49 421,399.81 1.49 0.00 0 335:Police State Seizure Wells Fargo Sweep Cash :13112001; 235,!577 9,1 11,.1111 735 0.1.% Nine 1 WFSWEEP 235 577 9,1 1 411 235,f,17 1,t, 1,411 Nnrn, Prepared by Rick Overgaard o o'17 Page 25 of 38 • ,4,„ City of Pearland ,!,\ 1, „ "' Portfolio Holdings by Portfolio Name °' Report Group: Pearland Date:3/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount 1 CUSIP Shares YTM @ Cast Book Value VIM 1 Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 235,577.94 235,577.94 0.11% 1 Sub Total 335:Police State Seizure 235,577.94 1.49 235,577.94 1.49 0.00 0 336:Federal Police Fund Wells Fargo Sweep Cash 513112006 81,235.99 100.00 81,235.90 0.04% None 1 WFSWEEP 81,235.99 1.49 81,235.99 1.49 0.00 None 0 81,235,99 81,235.99 0.04% 1 Sub Total 336:Federal Police Fund 81,235.99 1.49 81,235.99 1.49 0.00 0 340:Park&Rec Development Border Stale Bank 1,4 613012021 6e3012016 248,000,00 96.04 200,184.16 0.12% None 1187 099703EF3 246,000.00 1,40 248,000.00 2.67 9.51 -9,815.84 None 3.17 Nebraskaland National Bank 1.2 912512018 9/25/2015 248,000,00 99.96 247,907.74 0.12% None 178 63970QFC5 248,000.00 1.20 248,000.00 1.28 48,92 -92.26 None 0.48 Wells Fargo Sweep Cash 5131/2006 583,767.71 100.00 583,767.71 0.27% None 1 WFSWEEP 583,767.71 1.49 583,767,71 1.49 0.00 None 0 1,079,767.71 1.069.859.61 0.51% 314 Sub Total 340:Park&Rec Development 1,079,787,71 1.40 1,079,767.71 1.71 58.43 -9,908.10 0.84 345:Sidewalk Fund Wells Fargo Sweep Cash 6/31/2006 6,300.34 103.00 6,306.34 094 None 1 WFSWEEP 6,308,34 1.49 6,308.34 1.49 0.00 M1.1- 6,300.34 6,308.34 0% 1 Sub Total 345:Sidewalk Fund 6,308.34 1.49 6,300,34 1.49 0.00 0 350:Grant Fund Wells Fargo Sweep Cash 5131/2036 222,829.81 100.00 722 W2:,?l1 0.11:. Non,,, 1 WFSWEEP 222,829.61 1.49 222,829.61 1.49 0010 None 222,829.61 222.629 61 0.1"•t, 1 Sub Total 350:Grant Fund 222,829.61 1.49 222,829.61 1.49 0.00 0 351:CDBG Fund Prepared by Rick Overgaard 7 r:1 17 Page 26 of 38 AIV, City of Pearland iiiiikaka Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM 13 Cost Book Value YTM @ Market Accrued Interest Unre,GaIniLoss Credit Rating Duration To Maturity Wells Fargo Swoop Cash 11/15/2015 17,983.81 100.00 17,983.81 0.01% None 1 WFSWEEP 17,983.81 1.49 17,983.81 1.49 0.00 None 9 17,983.81 17.983.81 0.01% 1 Sub Total 351:CDBG Fund 17,983.81 1.49 17,983.81 1.49 0.00 0 360:Traffic impact Improvement Summit Community Bank Moorefield WV 6/30/2017 248,000.00 0[3.21 246,051 96 0.12% None 1.55 612812019 86604XLX2 248,000.00 1.55 248,000.00 2.19 31.59 -1,948.04 None 1,23 Wells Fargo Sweep Caen 5/31 201aa; 363,755.05 100.00 383.755.05 016% None 1 WFSWEEP 363,755.05 1.49 383,755.05 1.49 0.00 None 0 631,755.05 629,807.01 0.3% 179 Sub Total 360:Traffic Impact Improvement 631,755.05 1.51 631,755.05 1.76 31.59 -1,948.04 0,48 365:Court Juvenile Mgtnt Wells Fargo Sweep Cash 9/15,9009 0,500 49 12' f;!1 25,696 49 [1 0„":, None 1 WFSWEEP <,'..50r.49 1.49 :2`.505 4h 1.40 0,00 None 0 25,606.49 25969.49 0.01% 1 Sub Total 365:Court Juvenile Mgmt 25,696.49 1.49 25,696.49 1.49 0.00 0 370:Municipal Channel Texas Class LGIP 5/15/2017 506,715,58 100.00 506,215.58 0.24% None 1 TX-01-0615-0001 506,215.58 1.75 506,215.59 1.75 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 179,576 81 ' 100.00 129,536.81 0.06% None 1 WFSWEEP 129,536.81 1.49 1244,535.91 1.49 0,00 None 0 635,752.39 635,752.39 0.3% 1 Sub Total 370:Municipal Channel 635,752.39 1.70 635,752.39 1.70 0.00 0 375:U of H Fund Wells Fargo Sweep Cash 12/1/2009 -370.34 100.00 170.34 0% None 1 WFSWEEP -370.34 1.49 -370.34 1.49 0.00 None 0 -370.34 -370.34 0% 1 Sub Total 375:U of H Fund 470.34 1,49 -370.34 1.49 0.00 0 Prepared by Rick Overgaard Sof 17 Page 27 of 38 1 r; City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/3112018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount 1 CUSIP Shares VIM @ Cost Book Value VIM @ Market Accrued interest Unre.Gain/Loss Credit Rating Duration To Maturity 380:Regional Detention Wr711s Fargo Sweet:Caistl 5131/2006 141,153.09 100.00 141,153,09 0.07% None 1 WFSWEEP 141,153.09 1.49 141,153.09 1 49 0.00 None 0 141,153.09 141,153.09 0.07% 1 Sub Total 380:Regional Detention 141,153.09 1.49 141,153.09 1.49 0.90 0 500:Capital Projects Texas Class LGIP 1/1512017 1,015,313.27 100.00 1,015,313.27 ;L4 `.'. None 1 TX-01-0615-0001 1,015.313.27 1.75 1.015,313.27 1.75 o 0/ None 0 Umpqua Bank Roseburg OR 1.6 6/28/2019 6/3017017 248,000.00 99.28 246,202.00 0.12% None 454 90421MAX1 248,000.00 1.60 248,000.00 2.19 969,28 •1,798.00 None 1.23 Welts Fargo Sweep Cash 5/31/2006 2,019,875.89 100.00 2,019,875,89 0.94% None 1 WFSWEEP 2,019.875.89 1.49 2,019,875.89 1.49 0 00 None 0 3,283,189.16 3,281,391.16 1.5335 Sub Total 500:Capital Projects 3,283.189.16 1.58 3,283,189.16 1,62 989.28 •1,798.00 0.09 501:Certificates of Obligation 1st Security Bank of Wash 1.1 112212021 ,22r201ft 248.000.00 175.85 237,697.34 0.12% None 1028 33625CAZ2 248.000 00 110 248,000.00 2.64 67.27 -10,302.66 None FAMC 1.5 8/22/2019 2/22/2017 1,000.000.00 98.97 989,743.00 0.47% s1,,P-AA+ 500 3132X0PV7 1,000,000.00 1.50 1,000.000.00 2.25 1,825.00 -10,257,00 Moodys-Aaa 1.38 FHLMC 1.125 8/12/2021 9/22/2018 988,540.00 95.53 955,288.00 0,46% Mondys-Aaa 1230 3137EAEC9 1,000,000.00 1.37 992,114.74 2.52 1,375.00 -36,846,74 S&P-AA+ 3,3 FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 98.56 985,805.00 0.48% Moodys-Aaa 1003 3135G01-155 1,000,000.00 1.25 1,016,629.92 2.42 4,643.75 -31,024.92 S&P-AA+ 2.67 Gulf Coast Bank&a trgr,Trust 1.3 711512021= 7/15/2016 248,000.00 96.31 238,860.95 0.12% None 15 17 402194EX8 248,000.00 1.30 248,000.00 2.47 141.33 -9,139.05 None 3.22 Luang Savings Bank 1.25 6/19/2018 12/19/2014 248,000.00 99.92 247,799.62 0.12% None 80 549103Q125 248,000.00 1.26 248,000.00 1.81 866.30 -200.38 None 0.22 Prepared by Rick Overgaard 9 Of 17 Page 28 of 38 �`'4 City of Pearland ' j,ry, Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/31/2018 Description Face Amount f Settlement Date Cost Value Market Price Market Value 'f Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YIN rt i Cost Book Value YTM @ Market Accrued Interest Unre.GalniLoss Credit Rating Duration To Maturity Marlin Business Bank 1.2512/27;2019 6/29/2.016 248,000.00 98.05 243,154.06 0.12% None 636 57115AMC9 248,000,00 1.25 248,000.00 2.40 16.99 -4,845.92 None 1.72 Texas Class LOP 12/20/2016 5,083.835.43 100.00 5,083.835.43 2.38% None 1 1'X-01-0615-0001 5,083,835.43 1,75 5,083,835.43 1.75 0.00 None 0 TexSTAR LOOP 8/26/2016 5,068.51128 100.00 5,068,511.23 2.37% S&P-AAA 1 02000-11110 5,068,511.28 1.50 5,068.511.28 1.50 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 381,504.84 100.00 381,504.84 0.18% None 1 WFSWEEP 381,504.84 1.49 381,504.84 1.49 0.00 None 0 14,540,271.55 14,431.979.54 5.82% 220 Sub Total 501:Certificates of Obligation 14,525,851,55 1.54 14,534,598.21 1.83 8,935.64 •102,816.67 0.64 503:Certificates of Obligation 2006 Wells Fargo Swoop Cash 6/30/2006 63.478.25 100.00 63,478.25 0.03% None 1 WFSWEEP 63,478.25 1.49 63,478.25 1.49 0.00 None 0 63,478.25 03,478.25 0.03% 1 Sub Total 503:Certificates of Obligation 63,478.25 t49 63,478.25 1.49 0.00 0 2006 506:General Obligation BMO Harris Bank 1.05 6/22/2018 6123/2016 248,000.00 99.86 247,657.76 0.12% None 83 05581WHF5 248,000.00 1.05 248,000.00 1.65 699.16 442.24 None 0.23 Brickett Bank Miami FL 1,65 10/28/2019 8/27/2017 248,000,00 98.92 245,321.85 0.12% None 576 108010A136- 248,000.00 1.65 248,000,00 2.35 33.63 .2,678.15 None 1.56 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 97.30 241,315.16 0.12% None 1160 12325EH1J9 248,000.00 1.80 248,000.00 2.87 97,84 -6,884,84 None 3.14 Capital Ono Bank USA 1.1 11/10/2019 11119/2014 248,000.00 99.54 246,869.86 0.12% None 598 1404200X1 248,000.00 1.10 248,000.00 1.38 986.56 -1,130.14 None 1.82 Citizens State Bank Clayton 1.35 4/30/2010 9/3812015 248,000.00 99.78 247,462.58 0.12% None 395 176688057 248,000.00 1.35 248,000.00 1.55 9.11 -537.42 None 1.07 Prepared by Rick Overgaard 10 of 17 Page 29 of 38 City of Pearland !LY .r'''.['..c? Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To CallIMaturity Face Amount I cal_tP Shares YTM 184 Cost Book Value YTM @ Market Accrued Interest Unre.GainfLoss Credit Rating Duration To Maturity FFC8 t5 1128/2019 5/28/2014 1,000,000.00 99.67 996,726.00 0,47% Moodys-Aaa 303 3133EDMF6 1,000,000.00 1.50 1,000,000.00 1.90 2,625.00 -3,274.00 S&P-AA+ 0.82 FHLB 1 9/2612019 9/2212016 997,430.00 98.19 981,881.00 0.47% Moodys-Aaa 544 3130A9EP2 1,000,000.00 1.09 998,731.60 2.25 138.89 -18,850.80 S&P-AA+ 1,48 First Business Bank 1.7 6/30/2020 9/30/2015 248,000.00 98.10 243,298.66 0.12% None 822 319380P40 248,000.00 1.70 248,000.00 2.57 11.55 4,701.34 None 2.21 First National Bank of America 1.25 7/15/2018 1:-48,000.00 95-53 236,905-47 0.12% None 1202 7/15/2021 32110YHMO 248,000.00 1.25 248,000.00 2.68 636.99 -11,094.53 None 3.23 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 748,000.00 96.65 239,693.24 0.12% None 1187 53362tA90 248,000.00 1.40 748,000.00 2.47 285.37 -8,306.76 None 3.17 National Bank Commerce Superior 1.25 7/15/2016 248,000.00 98.31 738,857 73 0.12% None 15 7/15/2021-17 633388E87 248,000.00 1.25 248,000.00 2.42 135-89 -9,142.27 None 3.22 Peoples United Bank 1.9 11/19/2019 11/19/2014 248,000.00 99.53 246,828.45 0.12% None 598 712700KM7 248,000.00 1.90 248,000.00 2.20 1,704.07 -1,171.55 None 1.61 Revere Bank 1.35 612912018 12/30/2014 248,000.00 99.95 247,865.58 0.12% None 90 761402AU0 248,000.00 1.35 248,000.00 1.57 18.35 -134.42 None 0.24 Texas Class LGIP 12/20/2016 17,173,818.12 100.00 17,173,818.12 8.02% None 1 TX-01-0615-0001 17,173,818.12 1.75 17,173,818.12 1.75 0.00 None 0 TexSTAR LGIP 8/26/2016 5,068,161.13 100.00 5,068,161.13 2.37% S&P-',AA 1 02000.11110 5,068,161.13 1.50 5,008,161.13 1.50 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 4,362,963.17 100.00 4,362,953.17 2.04% None 1 WFSWEEP 4,362,983.17 1.49 4,362,963.17 1.49 0.00 None 0 31,330.372.42 31,265,825.76 14.69% H Sub Total 506:General Obligation 31,332,942.42 1.62 31,331,674.02 1.73 7,382.47 •66,048.26 0.24 510:Lower Kirby Urban Center Prepared by Rick Overgaard 11 of 17 Page 30 of 38 S.., n €.4, City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Bata.3�31201l Description Settlement Date Coal Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount l CUSP Shares YTM ge Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Durallon To Maturity Wells Fargo Sweep Cash 10/15/2015 451.81 100.00 451St 0% None 1 WFSWEEP 451.81 1,49 461.81 149 0.00 None 0 451.81 451.81 0% 1 Sub Total 510:Lower Kirby Urban Center 451.81 1,49 451.81 1.49 0.00 0 550:W/S Impact Fee Bankwest,Inc. 1.5 1/3/2020 3/4/2015 248,000.00 98.39 244,006.70 9.12`%?. None 643 06652CFA4 248,000.00 1,50 248,000.00 2.44 285.37 •3,993.30 None 1.73 BMW Bank 2.1 6/19/2020 6/19/2015 246,000.00 98.74 244,869.74 0.12% None 811 05580ABX1 248,000.00 2.10 248,000.00 2.69 1,455.39 -3,130.26 None 2.17 Cedar Rapids Bank&amp;Trust 1.5 1/30/2015 248,000.00 99.07 247,191.77 0.12% None 578 10/30/2019 150517CJ7 248,000.00 1.50 248,000.00 1.71 305.75 -80823 None 1-56 EVB Tappa Hannnck VA 1.6 9/25/2019 9/25/2015 246,000.00 99.60 247,003.54 0.12% None 543 26927ABK7 248,000.00 1.80 248,000.00 1.88 65.23 .998.46 None 1.47 FAMC 1.82 11/9/2020 11/9/2017 1,000,000.00 98.26 982,603.00 0.47% Moodys-Ana 954 3132X02C8 1,000,000.00 1.82 1,000,000.00 2.51 7,178.89 -17,397.00 S&P-AA+ 2,54 FFCB 1,84 10/30/2020-18 10t30/2017 1,000,008,00 9627 982,722.00 0.47% Moodys-Aaa 213 3133E148426 1,000,000.0D 1.84 1,000,000,00 2.54 7,666.67 -17,278.00 S&P-AA+ 2,51 FHLB 2.2 112912021.19 1/29/2018 1,000,000.00 99.34 993,438-00 0.47% Moodys-Aae 304 3130ADC28 1,000.000.00 2.20 1,000,000.00 244 3,788.89 -6.562.00 S&P-AA+ 2.75 FHLMC 2 11120/2020.18 12/5/2017 1,000,000.00 98.76 987,600.00 0,47% Moodys-Aaa 50 3134GBW32 1,000000.00 2,00 1,000,000.00 2-49 7,277.78 -12.400.00 S&P-AA+ 2.58 FHLMC 2.2 12/8/2021-18 12/8/2017 1,000,000.00 98.50 984.984.00 0.47% Moody5-Aae 69 313443E14 N9 1,000,000.00 2.20 1,000,000.00 2.63 8,905.56 -15,016.00 S&P-AA+ 3.54 First Financial NW 1.3510/30/2019 10/30/2015 248,000.00 98.44 244,143.38 0.12% None 578 32022MAF5 248,000.00 1,35 248,000.00 2.35 0.00 3,856.65 None 1.57 Prepared by Rick Overgaard 12 of 17 Page 31 of 38 1 City of Pearland P-Al,'1 ANL Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To CattiMaturity Face Amount I CUSIP Shares YTM 18'Cost Book Value VIM i4 Market Accrued Interest Unre.GainlLoss Credit Rating Duration To Maturity FNMA 0.8755/21/2018 5/2112014 985,050.00 99.88 995,538.00 OAT% Moodys-Aaa 51 313560W/8 1,000,000.00 1.26 999,480.90 1.71 3,159.72 -642.90 SWAM 0.14 FNMA 1.3753/13/201946 9/22/2016 1,009,560.00 99.25 992,492.00 0.47% Moodys-Aaa 347 3136G1FY0 1,000,000,00 0.98 1,003,669.49 2.18 687.50 -11,177.49 S&P-AM 0.95 Pacific Continental Bank 1.25 6/30/2020 5/30/2016 248,000.00 97.35 241.430.98 0.12% None 822 69413CFD6 246,000.00 1,25 248,000.00 2.46 8.49 -6,569.02 None 2.22 Texas Gass LGtP 12/20/2016 22,983,765.26 100.00 22,983,765.26 10.74% None 1 TX-01-0615.0001 22,983,765.26 1.75 22,983,765.26 1.75 0.00 None 0 Washington Trust Co 1.4 6/15/2018 12/15/2014 248,000.00 99.97 247,913.70 0.12% None 76 940637009 248,000.00 1.40 248,000.00 1.56 1.008.31 -86.30 None 0.21 Welch State Bank 1.310/1/2018 9/30/2015 248,000.00 99,95 247,880.06 012% None 184 949095AU7 246,000.00 1.30 248,000.00 1.40 264.99 -119.04 None 0.5 _ . Wells Fargo Sweep Cash 5/31/2006 951,404.81 100.00 951,404.81 0.44% None 1 WFSWEEP 951A04,61 1.49 951,404.81 1.49 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 10,884.395.13 100.00 10.884,395.13 5.09% None 1 WF4094 10,884,395.13 1.49 10,884,395.13 1.49 0.00 None 0 _ Wells Fargo TWDB Cash 11/112016 3,871,361.47 100.00 3,871,381.47 1.81% Nam 1 WF4102 3,871,381.47 1,49 3,871,38147 1.49 0.00 None 0 Weds Fargo TWDB Cash 3/15/2017 11,806,249.06 100.00 11,806,249.06 5.52% None 1 WF5883 11,806,249.06 1.49 11,806,249.06 1.49 0.00 None 0 59,475,785.73 89,384,293.47 27.85% 52 Sub Total 550:W/S Impact Fee 59,481,175.73 1.62 59,484,326.12 1.71 40,058.54 .100,032.65 0.3 555:Shadow Creek Impact Evergreen Bank 1.2 6/2812018 6129/2015 248,000.00 99.90 247,759.19 0.12% None 90 300185C:N9 248,000.00 1.20 248,000.00 1,60 16.31 -240.81 None 0.24 Prepared by Rick O ergeerd 13 or 17 Page 32 of 38 City of Pearland /ke -- .y Portfolio Holdings by Portfolio Name Report Group: Pearland Date:3131/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount! CUSIP Shares YTM i Cost Book Value VIM @ Market Accrued Interest Unre.Gain/Lass Credit Rating Duration To Maturity FAMC 1,6752/2412020 2124/2017 1,001,204.00 98.68 986,814.00 0.47% Moodys-Aaa 695 3132X0PW5 1,000,000.00 1.63 1,000,758.89 2.39 1,721.53 -13,944,89 SRP-AA+ 187 GUARANTY B&amp:T 1.35 5/29/2018 512912014 248,000.00 9927 247,929.57 0,12% Nczne 51+ 400820E1.14 246,000,00 1.35 248,000.00 1.53 18.35 -70.43 None 0.18 Manufacturers&amp;Traders Trust 1.2 6124120117 248,000.00 99.92 247,797.14 0.12% None 86 6!2512018 5647590V3 248,000.00 1.20 248.000.00 1.55 790.88 -202.86 None 0.24 Wells Farctn Sweep Cash 5/31/2006 -227,233.82 101.00 -227,233.82 -0.11% None 1 Wf-SWEEP -227,233.82 1.49 -227,233.82 1.49 0.00 None 0 1,517,966.18 1,503,066.08 0.72% 497 Sub Total 555:Shadow Creek Impact 1,516.766.18 1.47 1.517.525.07 2.12 2,547.07 •14,458.99 1,34 565:Revenue Bonds 1999&2003 Continental Bank 1.25 5/25/2018 1105/2014 248,000.00 no 21710;7.03 0.12% /lore 55 211153EN6 248,0000n 1.25 245,000.00 1.52 .,G72.14 ,042 None 0.15 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 98.0? 989,743.00 0.47% S&P-AA+ rc 509 3132X0PV7 1,000,000.00 1.50 1.000.000.00 2.25 1.625.00 -10,257,00 Moodys-Aaa 1.38 GNB Bank 1.5 6130/2021 6/30/2016 248.000.00 96.66 239,714.07 0.12% None 1187 36198JCC6 248,000.00 1.50 248.000.00 257 10.19 -8.285.93 None 3.17 Signature Bank 1.35 3/28/2019 9/29/2015 248,000.00 99.81 247,54021 0.12% None 362 826891FU2 248,000.00 1.35 248,000 00 1.54 27.52 -459.79 None 0.99 Texas Class LGIP 1/15/2017 1,015,313.27 100.00 1,015,313.27 0.47% None 1 7X•01-0615-0001 1,015,313.27 1.75 1,015,313/7 1.75 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,656,99114 100.00 2,656.991.24 1,24% None I WFSWEEP 2,656,991.24 1.49 2,658,99114 1.49 0.00 None 0 Wells Fargo TWDB Cash W15/2017 10,038,993.65 100.00 10,038,993.65 4.80% None 1 WF5875 10,038,993.65 1,49 10,038,993.85 1.49 0.00 None 0 Prepared by Rick Overgaard 14 of 17 Page 33 of 38 �'` ,t`. City of Pearland . , + Portfolio Holdings by Portfolio Name r,` , ". Report Group: Pearland Date:3/31/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To CallMMaturity Face Amount 1 CUSIP Shares VIM r@i Cost Book Value VIM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 15,455,298.16 15,436,193.02 7.23% 60 Sub Total 565:Revenue Bonds 1999& 15,455,298.16 1,50 15,455,298.16 1.57 2,732.85 -19,105.14 0.16 2003 570:WIS Pay As You Go Marine Bank Springfield IL 1.8 61292021 5+2.9/2017 248,000.00 97.4 241,658.39 0.12% Nono '.166 56817TA87 248,000.00 1.80 248,000.00 2.62 24.46 -6,341.61 None 3.15 Wells Fargo Sweep Cash 12/31/2007 1,998,312.56 100.00 1,998,312.56 0.93% None 1 WFSWEEP 1,998,312,56 1.49 1,998,312.56 1.49 0.00 None 0 2,246,312.56 2,239,970.05 1.05% 132 Sub Total 570:W/S Pay As You Go 2,246,312.56 1.52 2,246,312.56 1.61 24.46 -6,341.61 0.35 575:MUD 4 Capital Programs Wells Fargo Sweep Cash 21112013 24,678,62 100.00 24,678.62 0.01% None 1 WFSWEEP 24,878.82 1.49 24,678.62 1,49 0.00 None 0 24,678.62 24,1178.82 0.01% 1 Sub Total 575:MUD 4 Capital Programs 24.676.62 1.49 24,678.62 1.49 0.00 0 600:Water&Sewer BARCLAYS BANK DELAWARE 1.95 5/6/2014 248,000.00 99.86 247,645,36 0.12% Moto 402 5/712019 06740KGU5 248.000.00 1.95 248,000.00 2.08 1,907.90 -354.84 None 1.09 CDARS 1,05 6/15/2019 8/15/20017 500,000.00 100.00 500,000.00 0.23% None 441 CDARS061517 500,000.00 1.05 500,000.00 1,05 1,294.52 0.00 None 1.2 Eaglebank Bethesda 1.15 12/1012018 319/2016 248.000.00 99.87 247,181.85 0.12% None 254 27002YCV6 248,000.00 1,15 248,000.00 1.83 171.90 -818.15 None 0.69 FAMC 1.5 8/22/2019 2/22/2017 2,001.700.00 98.97 1.979,486.00 0.93% S&P-AA+ 509 3132X0PV7 2.000.000.00 1.47 2,000,946.33 2,25 3,250.00 -21,460.33 Moodys-Aaa 1.38 FAMC 1,72 1013/2018 12/16/2013 997,890.00 99.91 999,075.00 0.47% Moodys-Aaa 186 31315P5A3 1,000,000.00 1.77 999,777.64 1.91 8,504.44 -702.64 S&P-AA+ 0.5 FFCB 1.95 9/17/2018 1/29/2014 1,014,770.00 100.02 1.000.242.00 0.47% Moodys•Aaa 170 3133E02C5 1,000,000.00 1.62 1,001,469.92 1.90 758.33 .1,227.92 S&P-AA+ 0.46 Prepared by Rick Overgeard 15 of 17 Page 34 of 38 City of Pearland iiikEkkkiii Portfolio Holdings by Portfolio Name Report Group: Pearland Date:313112018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To CalliMaturity Face Amount f CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FHLB 1.75 12/14/2018 12/16/2013 1,000,670.00 09.79 997,868.00 0.47% Moodys-Aaa 258 313376BR5 1,000,000.00 1.74 1,000,094,28 2.06 5,201.39 -2,226.28 S&P-AA+ 0.7 First Bank McComb MS 1.52/28/2019 6/30/2015 248,000.00 90.66 247,154.82 0.12% None 334 319234419 240,000.00 1.50 248,0013.00 1.88 30.58 -845.18 None 0.9 First Eagle National Bank 1.45 11/21/2018 11/21/2014 248,000.00 99.85 247,625.27 0.12% None 236 32008JAM5 248,000.00 145 248,000.00 1.69 1,280.77 -374.73 Nona 0.04 FNMA 1.625 11/27/2018 7/16/2014 1.004,411,00 99.74 997,406.00 0.47% Moodys-Aaa 241 3135G0YT4 1,000.000.00 1.52 1,000,662.63 2.02 5,597.22 -3.256.63 S&P-AA+ 0.65 MB Financial Bank 1.1 3/18/2019 3/18/2016 248,000.00 90.48 246,656.34 0.12% None 352 55266CQU3 248,000.00 1.10 246,000.00 1.87 97.16 •1,343 66 None 0.98 Northern Dank&amp;Trust MA 1.1 7/12/2016 248,000.00 98.71 244,806.01 0.12% None 12 7/12/201947 66476QBH0 248,000.00 1.10 248,000.00 2.12 582.97 -3.193.99 None 1.27 Northwest Bank Boise Idaho 1.5 1/10/2019 4/10/2014 248,009.00 99.97 247,915.93 0.12% None 285 66736AA01 248,000.00 1.50 248,000.00 1.54 214.03 -84.07 None 0.77 OLDTOWN BANK 1.2 5/7/2018 6/6/2014 248,000.00 100.01 248,015.38 0.12% None 37 6805408B6 248,000.00 '1.20 248,000.00 1.14 203.84 15.38 None 0.1 Par kside Finl Bank Ramp;Trust 1.3 7/18/2016 248,000.00 96.30 238,824.74 0.12% None 18 7/1912021-17 70147ABX1 248,000.00 130 248,000.00 2.47 114,83 .9,175.26 None 3.23 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 96.67 239,743.58 0.12% None 1181 73565NBQ5 248,000.00 1.40 248,000.00 2.47 66.59 -8,256.42 None 3.16 Texas Class LGIP 12/20/2016 3,564,059.22 100.00 3,564,059.22 1.67% None 1 TX-01.0615.0001 3,564,059.22 1.75 3,564,059.22 1.75 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 14,561,302.61 100.00 14,581.302.61 6.8% None 1 WFSWEEP 14,581.202.61 1.48 14,561,302.61 1.49 0.00 None 0 Prepared by Rick Overgaard 16 of 17 Page 35 of 38 City of Pearland ginaktil Portfolio Holdings by Portfolio Name Report Group: Pearland Dzaie:3r31/21)1/3 Description Face Amount 1 Settlement Date Cost Value Market Price Market Value °k Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM(4)Cost Book Value 'VIM @ Market Accrued Interest Unre.GainfLoss Credit Rating Duration To Maturity 27,124,802.83 27.055,008,11 12.71% 106 Sub Total 600:Water&Sewer 27,105,361.83 1.53 27,108,312.63 1.68 29,276.47 -53,304.52 0.33 610:Soiidwaste Wells Fargo Sweep Cash 12/112006 -1.242,904.13 I00.00 -1,242,004.13 -0.58% None 1 WFSWEEP •1,242.984.13 1.49 -1,242,984.13 1.49 0.00 None 0 -1,242,984.13 -1,242,984.13 -0.58% 1 Sub Total 010:Solidwaste -1,242,984.13 1.49 -1,242,984.13 1.49 0.00 0 700:Property Liability Ins Wells Fargo Sweep Cash 1013112006 642,454.11 109.00 642,454.11 0.3% None 1 WFSWEEP 642,454.11 1.411 642,454.11 1.49 0.09 None 0 642,454.11 642,454.11 0.3% 1 Sub Total 700:Property Liability Ins 642,454.11 1.49 642,454,11 1.49 0.00 0 701:Employee Benefit Fund Wells Fargo Sweep Cash 911/2007 160,873.16 100.09 'rr,07 t.i n 1117.'.<. None 1 WFSWEEP 160,873.16 1.49 160,873.16 1.4! j 0/) None 0 160,873.16 160,873.16 0.0I3.'. 1 Sub Total 701:Employee Benefit Fund 160,873.16 1,49 160,873.16 1.49 0.00 0 702:Health Claims Fund Wells Fargo Cash 7/21/2010 371,809.39 100.00 371,809.39 0.17% Ni,'c 1 WF9871 371,809.39 0.68 371,809.39 0.66 0.00 None 0 Wells Fargo Sweep Cash 9115/2010 2,756,192.23 100.00 2,756.192.23 1.20% None 1 WFSWEEP 2,758,192.23 149 2,756,192.23 1.49 0.90 None 0 3,128,001.62 3,126,001.62 1.46% 1 Sub Total 702:Health Claims Fund 3,128,001.62 1.39 3,128,001.62 1.39 0.00 0 214,019,432.52 213,449,317.64 100.00% 102 TOTAL PORTFOLIO 214,000,363.52 1.57 214,006,762.49 1.71 124,854.15 -557,444.85 0.37 Prepared by Rick Overgaard 17 of 17 Page 36 of 38 v City of Pearland LW/MMLW/4MM Treasury Yield Curve Treasury 12/31/2017 3/31/2018 1 Month 1.20 1.64 3 Month 1.34 1,73 6 Month 1.50 1.92 1 Year 1.70 2.06 2 Year 1.84 2.28 3 Year 1.96 2.42 5 Year 2.18 2.63 10 Year 2.40 2.84 3.00 - 2,50 - 2.00 - _-------"-- — 1,50 - •12/31/2017 3/31/2018 1.00 - 0.50 - 0,00 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year Prepared by Rick Ovorgaard ' et 1 Page 37 of 38 Pledged Collateral Reconciliation Report March 31, 2018 Bank Account Number Account Name Amount Wells Fargo 807-1613395 Credit Card Account - Wells Fargo 001-3042841 Sweep Account 34,901.00 Wells Fargo 7169195455 False Alarm Reduction Program 283,265.12 Wells Fargo 818-4567843 Alvin ISD 5,595,728.44 Wells Fargo 179-0121790 EMS Payments - Wells Fargo 280-7409871 Health Claims 371,809.39 Wells Fargo 3542574094 Escrow W&S Revenue Bonds,Series B Wells Fargo 3542574102 Escrow W&S Revenue Bonds, Series C Wells Fargo 4827855883 Texas Permanent Water& Sewer System R - Wells Fargo 4827855875 Texas Permanent Water& Sewer System R - Total of Bank Balances $ 6,285,703.95 Pledged Collateral for City 6,970,092.21 FDIC Insurance 500,000.00 $ 7,470,092.21 Over(Under)Collateralized $ 1,184,388.26 Total%Collateralized 118.8% Bank Account Number Account Name Amount Wells Fargo 100-7284258 Development Authority 970,169.56 Total of Bank Balances $ 970,169.56 Pledged Collateral for DAP 814,556.15 FDIC Insurance 250,000.00 $ 1,064,556.15 Over(Under)Collateralized $ 94,386.59 Total %Collateralized 109.7% Total %Collateralized 117.6% Status Collateralized * Accounts are now being sweep to a higher yielding money market fund which does not require collateral. Page 38 of 38