Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2018-155 2018-08-27
RESOLUTION NO. R2018-155 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending June 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 June 2018. PASSED, APPROVED, AND ADOPTED this 27th day August, A.D., 2018. --- )01/ , DC-4 TOM REID MAYOR ATTEST: DYf�ul' .ni ��: NG Lei" G, T C =�. �, , YSE " -ETARY - ...... APPROVED AS TO FORM: (214..A.--' dr-------. DARRIN M. COKER CITY ATTORNEY City of Pearland Quarterly Investment Report March 31, 2018 to June 30, 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 4/30/2018 209,537,825.33 210,173,635.61 -635,810.28 1.67 2.15 292,274.86 135 5/31/2018 203,887,048.71 204,494,130.08 -607,081.37 1.68 2.27 296,309.92 132 6/30/2018 201,234,869.24 201,858,066.60 -623,197.36 1.84 2.33 281,020.42 127 , Total/Average 204,886,581.09 205,508,610.76 -622,029.67 1.73 2.25 869,605.20 131 ---,� s/6/aork1 /2 / . e17/A3 Cynthi Pearson, Dire r of Finance Date Rhonda Daugherty, A•4stant Di s tor of Finance Date City of Pearland Distribution by Security Type - Book Value Report Group: Pearland Begin Date:3/31/2018,End Date:6/30/2018 Security Type Allocation Book Value °/of Portfolio Book Value %of Portfolio Security Type 3/31/2018 3/31/2018 6/30/2018 6/30/2018 Cash 96,349,341.54 45.02 89,547,474.80 44.36 Certificate Of Deposit 23,318,695.73 10.90 20,091,312.82 9.95 FAMC Bond 8,002,241.75 3.74 8,001,984.60 3.96 FFCB Bond 3,001,469.92 1.40 3,000,681.83 1.49 FHLB Bond 4,998,825.88 2.34 4,999,003.71 2.48 FHLMC Bond 6,683,418.48 3.12 6,684,668.33 3.31 FNMA Bond 4,020,442.94 1.88 3,018,257.67 1.50 Local Government Investment Pool 67,632,326.25 31.60 66,514,682.84 32.95 Total/Average 214,006,762.49 100.00 201,858,066.60 100.00 Portfolio Holdings as of 3/31/2018 Portfolio Holdings as of 6/30/2018 •45.02%-Cash • 44.36%-Cash i ! 10.9%-Certificate Of... 0 9.95%-Certificate Of... '* .,,,^ • 3.74%-FAMC Bond • 3.96%-FAMC Bond • 1.4%-FFCB Bond 0 1.49%-FFCB Bond • 2.34%-FHLB Bond • 2.48%-FHLB Bond 3.12%-FHLMC Bond 3.3 1%-FHLMC Bond • 1.88%-FNMA Bond • 1.5%-FNMA Bond • 31.6%-Local Governme... • 32.95%-Local Governm... Prepared by Shamaira Jagrup 1 of 1 City of Pearland DaLasig Distribution by Maturity Range - Book Value Report Group: Pearland Begin Date:3/31/2018,End Date:6/30/2018 Maturity Range Allocation Book Value %of Portfolio Book Value %of Portfolio Maturity Range 3/31/2018 3/31/2018 6/30/2018 6/30/2018 0-1 Month 164,229,667.79 76.74 156,803,157.64 77.68 1-3 Months 4,228,106.69 1.98 1,744,751.77 0.86 3-6 Months 2,486,539.86 1.16 5,493,540.05 2.72 6-9 Months 5,244,437.89 2.45 3,242,714.57 1.61 9-12 Months 5,739,669.49 2.68 5,484,000.00 2.72 1-2 Years 16,941,195.71 7.92 14,945,040.82 7.40 2-3 Years 8,237,629.92 3.85 9,972,130.36 4.94 3-4 Years 6,899,515.14 3.22 4,172,731.39 2.07 Total/Average 214,006,762.49 100.00 201,858,066.60 100.00 Portfolio Holdings 180,000 - 160,000 - 140,000 - 414 120,000 - c _ _ '�° 100,000 - o • 3/31/2018 N 80,000 - • 6/30/2018 c 60,000 - 40,000 - 20,000 - 00 - .. ____ ii . i _ MIMI : I 0-1 Month 1-3 Months 3-6 Months 6-9 Months 9-12 Months 1-2 Years 2-3 Years 3-4 Years Prepared by Shamaira Jagrup 1 of 1 , ,, ;, City of Pearland Total Rate of Return - Book Value by Month Report Group: Pearland Begin Date:7/31/2017,End Date:6/30/2018 Beginning BV+ Interest Earned Realized Investment Average Capital Annualized Treasury 1 Month Accrued Interest During Period-By Gain/Loss-BV Income-BV Base-BV TRR-BV TRR-BV Year 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 b.11 1.37 1.96 3/31/2018 210,050,683.35 337,525.82 0.00 337,525.82 211,626,642.26 0.16 1.93 2.06 4/30/2018 214,131,616.64 292,274.86 0.00 292,274.86 211,794,160.07 0.14 1.67 2.15 5/31/2018 210,322,591.04 296,309.92 0.00 296,309.92 207,414,463.44 0.14 1.73 2.27 6/30/2018 204,643,326.67 281,020.42 0.00 281,020.42 203,421,522.63 0.14 1.67 2.33 Annualized TRR-BV 2.50 - 2.00 - 1.50 - - :Portfolio 1.00 - Treasury 1 Year 0.50 - 0.00 , , , i 07/2017 08/2017 09/2017 10/2017 11/2017 12/2017 01/2018 02/2018 03/2018 04/2018 05/2018 06/2018 Prepared by Shamaira Jagrup 1 of 1 City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2018 Description Face Amount/ Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity •Cash Wells Fargo Cash 7/21/2010 393,667.82 100.00 393,667.82 0.2% None 1 WF9871 393,667.82 0.75 393,667.82 0.75 0.00 None 0 Wells Fargo Sweep Cash 12/31/2007 2,616,513.09 100.00 2,616,513.09 1.3% None 1 WFSWEEP 2,616,513.09 1.79 2,616,513.09 1.79 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 1,249,260.73 100.00 1,249,260.73 0.62% None 1 WFSWEEP 1,249,260.73 1.79 1,249,260.73 1.79 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,802,708.87 100.00 2,802,708.87 1.39% None 1 WFSWEEP 2,802,708.87 1.79 2,802,708.87 1.79 0.00 None 0 Wells Fargo Sweep Cash 10/15/2015 148,477.69 100.00 148,477.69 0.07% None 1 WFSWEEP 148,477.69 1.79 148,477.69 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 0.34 100.00 0.34 0% None 1 WFSWEEP 0.34 1.79 0.34 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 -12,097.19 100.00 -12,097.19 -0.01% None 1 WFSWEEP -12,097.19 1.79 -12,097.19 1.79 0.00 None 0 Wells Fargo Sweep Cash 12/1/2006 -1,142,160.74 100.00 -1,142,160.74 -0.57% None 1 WFSWEEP -1,142,160.74 1.79 -1,142,160.74 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 7,489,866.12 100.00 7,489,866.12 3.71% None 1 WFSWEEP 7,489,866.12 1.79 7,489,866.12 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 9,045,828.71 100.00 9,045,828.71 4.48% None 1 WFSWEEP 9,045,828.71 1.79 9,045,828.71 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 19,801,087.03 100.00 19,801,087.03 9.81% None 1 WFSWEEP 19,801,087.03 1.79 19,801,087.03 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 348,263.51 100.00 348,263.51 0.17% None 1 WFSWEEP 348,263.51 1.79 348,263.51 1.79 0.00 None 0 Prepared by Shamaira Jagrup 1 of 14 City of Pearland LEAakigAg Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 5/31/2006 726,669.08 100.00 726,669.08 0.36% None 1 WFSWEEP 726,669.08 1.79 726,669.08 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 500,021.91 100.00 500,021.91 0.25% None 1 WFSWEEP 500,021.91 1.79 500,021.91 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 845,265.38 100.00 845,265.38 0.42% None 1 WFSWEEP 845,265.38 1.79 845,265.38 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 87,751.53 100.00 87,751.53 0.04% None 1 WFSWEEP 87,751.53 1.79 87,751.53 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 6,422.72 100.00 6,422.72 0% None 1 WFSWEEP 6,422.72 1.79 6,422.72 1.79 0.00 None 0 Wells Fargo Sweep Cash 11/15/2015 16,386.08 100.00 16,386.08 0.01% None 1 WFSWEEP 16,386.08 1.79 16,386.08 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 244,543.84 100.00 244,543.84 0.12% None 1 WFSWEEP 244,543.84 1.79 244,543.84 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,585,561.29 100.00 2,585,561.29 1.28% None 1 WFSWEEP 2,585,561.29 1.79 2,585,561.29 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,297,301.37 100.00 2,297,301.37 1.14% None 1 WFSWEEP 2,297,301.37 1.79 2,297,301.37 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,143,794.88 100.00 2,143,794.88 1.06% None 1 WFSWEEP 2,143,794.88 1.79 2,143,794.88 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 423,285.75 100.00 423,285.75 0.21% None 1 WFSWEEP 423,285.75 1.79 423,285.75 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 187,735.07 100.00 187,735.07 0.09% None 1 WFSWEEP 187,735.07 1.79 187,735.07 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 29,392.77 100.00 29,392.77 0.01% None 1 WFSWEEP 29,392.77 1.79 29,392.77 1.79 0.00 None 0 Prepared by Shamaira Jagrup 2 of 14 City of Pearland €AIZL.i N„C Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 9/15/2009 27,567.13 100.00 27,567.13 0.01% None 1 WFSWEEP 27,567.13 1.79 27,567.13 1.79 0.00 None 0 Wells Fargo Sweep Cash 9/1/2007 142,864.69 100.00 142,864.69 0.07% None 1 WFSWEEP 142,864.69 1.79 142,864.69 1.79 0.00 None 0 Wells Fargo Sweep Cash 2/1/2013 24,789.07 100.00 24,789.07 0.01% None 1 WFSWEEP 24,789.07 1.79 24,789.07 1.79 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 143,989.73 100.00 143,989.73 0.07% None 1 WFSWEEP 143,989.73 1.79 143,989.73 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,282,418.08 100.00 1,282,418.08 0.64% None 1 WFSWEEP 1,282,418.08 1.79 1,282,418.08 1.79 0.00 None 0 Wells Fargo Sweep Cash 10/31/2006 485,187.82 100.00 485,187.82 0.24% None 1 WFSWEEP 485,187.82 1.79 485,187.82 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 90,145.97 100.00 90,145.97 0.04% None 1 WFSWEEP 90,145.97 1.79 90,145.97 1.79 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 83,316.38 100.00 83,316.38 0.04% None 1 WFSWEEP 83,316.38 1.79 83,316.38 1.79 0.00 None 0 Wells Fargo Sweep Cash 6/30/2006 63,762.34 100.00 63,762.34 0.03% None 1 WFSWEEP 63,762.34 1.79 63,762.34 1.79 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 8,467,939.00 100.00 8,467,939.00 4.19% None 1 WF6624 8,467,939.00 1.79 8,467,939.00 1.79 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 11,853,145.17 100.00 11,853,145.17 5.87% None 1 WF5883 11,853,145.17 1.79 11,853,145.17 1.79 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 81,192.71 100.00 81,192.71 0.04% None 1 WF4094 81,192.71 1.79 81,192.71 1.79 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 10,078,869.98 100.00 10,078,869.98 4.99% None 1 WF5875 10,078,869.98 1.79 10,078,869.98 1.79 0.00 None 0 Prepared by Shamaira Jagrup 3 of 14 :. iii:`, City of Pearland 1ii9 Portfolio Holdings by Security Type `'` ‘a"' Report Group: Pearland Date:6/30/2018 Description Face Amount/ Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo TWDB Cash 11/1/2016 3,886,739.08 100.00 3,886,739.08 1.93% None 1 WF4102 3,886,739.08 1.79 3,886,739.08 1.79 0.00 None 0 89,547,474.80 89,547,474.80 44.33% 1 Sub Total Cash 89,547,474.80 1.78 89,547,474.80 1.78 0.00 0 Certificate Of Deposit 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 95.51 236,873.23 0.12% None 937 33625CAZ2 248,000.00 1.10 248,000.00 2.92 59.79 -11,126.77 None 2.52 1st Source Bank 1.5 11/18/2019 4/17/2015 248,000.00 99.11 245,798.50 0.12% None 506 33646CEQ3 248,000.00 1.50 248,000.00 2.15 754.19 -2,201.50 None 1.37 Allegiance Bank 0.8 9/13/2018 9/13/2017 248,069.94 100.00 248,069.94 0.12% None 75 2611523D 248,069.94 0.80 248,069.94 0.80 92.43 0.00 None 0.2 Ally Bank Midvale Utah 1.8 6/29/2020 6/29/2017 248,000.00 98.04 243,132.26 0.12% None 730 02006L3U5 248,000.00 1.80 248,000.00 2.82 12.23 -4,867.74 None 1.97 Alma Bank 1.35 12/24/2020 6/24/2016 248,000.00 96.28 238,770.43 0.12% None 908 020080BB2 248,000.00 1.35 248,000.00 2.91 55.04 -9,229.57 None 2.44 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 95.63 237,161.66 0.12% None 1108 02554BCM1 248,000.00 1.35 248,000.00 2.86 174.28 -10,838.34 None 2.97 Bank Leumi USA 1.3 2/26/2020 3/3/2016 248,000.00 98.69 244,747.48 0.12% None 606 063248FH6 248,000.00 1.30 248,000.00 2.11 1,095.28 -3,252.52 None 1.64 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 95.97 238,009.32 0.12% None 1096 063847AL1 248,000.00 1.40 248,000.00 2.80 0.00 -9,990.68 None 2.94 Bank of the Pacific 1.25 7/30/2018 1/29/2015 248,000.00 99.95 247,865.58 0.12% None 30 06425BBN8 248,000.00 1.25 248,000.00 1.90 1,282.47 -134.42 None 0.08 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 98.68 244,720.94 0.12% None 818 06610QCV1 248,000.00 1.80 248,000.00 2.41 61.15 -3,279.06 None 2.19 Prepared by Shamaira Jagrup 4 of 14 "` City of Pearland I Portfolio Holdings by Security Type "' Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Bankwest,Inc.1.5 1/3/2020 3/4/2015 248,000.00 98.36 243,941.98 0.12% None 552 06652CFA4 248,000.00 1.50 248,000.00 2.61 275.18 -4,058.02 None 1.49 Bar Harbor Bank&Trust 2.65 3/29/2021-18 3/29/2018 248,000.00 99.20 246,004.10 0.12% None 29 066851WB8 248,000.00 2.65 248,000.00 2.96 18.01 -1,995.90 None 2.65 BARCLAYS BANK DELAWARE 1.95 5/6/2014 248,000.00 99.72 247,300.64 0.12% None 311 5/7/2019 06740KGU5 248,000.00 1.95 248,000.00 2.29 715.46 -699.36 None 0.85 Belmont Savings Bank 1.85 10/23/2019 12/23/2014 248,000.00 99.35 246,391.47 0.12% None 480 080515BD0 248,000.00 1.85 248,000.00 2.36 87.99 -1,608.53 None 1.3 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 98.43 244,111.61 0.12% None 720 05580ABX1 248,000.00 2.10 248,000.00 2.93 156.95 -3,888.39 None 1.94 Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 95.41 236,617.05 0.12% None 1096 099703EF3 248,000.00 1.40 248,000.00 3.00 0.00 -11,382.95 None 2.94 Brickell Bank Miami FL 1.65 10/28/2019 6/27/2017 248,000.00 98.86 245,165.11 0.12% None 485 10801 DAG6 248,000.00 1.65 248,000.00 2.53 22.42 -2,834.89 None 1.31 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 96.59 239,538.74 0.12% None 1089 12325EHU9 248,000.00 1.80 248,000.00 3.00 85.61 -8,461.26 None 2.9 Capital Bank Little Rock 1.35 3/22/2019 9/23/2015 248,000.00 99.73 247,332.14 0.12% None 265 139797FL3 248,000.00 1.35 248,000.00 1.72 73.38 -667.86 None 0.72 Capital One Bank USA 1.1 11/19/2019 11/19/2014 248,000.00 99.37 246,439.09 0.12% None 507 140420QX1 248,000.00 1.10 248,000.00 1.56 313.91 -1,560.91 None 1.38 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 98.71 244,811.46 0.12% None 818 14042RAB7 248,000.00 2.30 248,000.00 2.90 1,515.86 -3,188.54 None 2.18 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 96.96 240,452.12 0.12% None 758 144153AW3 248,000.00 1.10 248,000.00 2.61 22.42 -7,547.88 None 2.05 Prepared by Shamaira Jagrup 5 of 14 '� City of Pearland Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity CDARS 0.7 12/13/2018 12/15/2016 500,000.00 100.00 500,000.00 0.25% None 166 1019720221 500,000.00 0.70 500,000.00 0.70 1,706.85 0.00 None 0.45 CDARS 1.05 6/15/2019 6/15/2017 500,000.00 100.00 500,000.00 0.25% None 350 CDARS061517 500,000.00 1.05 500,000.00 1.05 2,603.42 0.00 None 0.95 Cedar Rapids Bank&Trust 1.5 10/30/2019 1/30/2015 248,000.00 99.49 246,734.95 0.12% None 487 150517CJ7 248,000.00 1.50 248,000.00 1.89 295.56 -1,265.05 None 1.32 Charter Bank 1.7 2/25/2020 2/25/2015 248,000.00 98.44 244,125.00 0.12% None 605 161164BE7 248,000.00 1.70 248,000.00 2.67 57.75 -3,875.00 None 1.63 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248,000.00 99.38 246,472.82 0.12% None 507 17284C3Z5 248,000.00 2.10 248,000.00 2.56 599.28 -1,527.18 None 1.37 Citizens State Bank Clayton 1.35 4/30/2019 9/30/2015 248,000.00 99.67 247,173.42 0.12% None 304 1766886S7 248,000.00 1.35 248,000.00 1.75 0.00 -826.58 None 0.83 Commercial Bank Ala Mich 1.5 3/29/2019 6/30/2015 248,000.00 99.43 246,582.43 0.12% None 272 201282GV6 248,000.00 1.50 248,000.00 2.27 10.19 -1,417.57 None 0.74 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 95.98 238,024.45 0.12% None 1096 203507BG2 248,000.00 1.50 248,000.00 2.90 0.00 -9,975.55 None 2.93 Community Bankers'Bank 1.4 6/30/2021 6/30/2016 248,000.00 95.97 238,009.32 0.12% None 1096 20361LBR4 248,000.00 1.40 248,000.00 2.80 0.00 -9,990.68 None 2.94 ConnectOne Bank 1.55 7/30/2018 1/30/2014 248,000.00 99.99 247,979.17 0.12% None 30 20786AAM7 248,000.00 1.55 248,000.00 1.65 0.00 -20.83 None 0.08 Discover Bank 2 2/25/2020 2/25/2015 248,000.00 98.93 245,334.74 0.12% None 605 254672JA7 248,000.00 2.00 248,000.00 2.67 1,698.63 -2,665.26 None 1.62 Eaglebank Bethesda 1.15 12/10/2018 3/9/2016 248,000.00 99.70 247,261.46 0.12% None 163 27002YCV6 248,000.00 1.15 248,000.00 1.82 164.09 -738.54 None 0.44 EVB Tappa Hannock VA 1.6 9/25/2019 9/25/2015 248,000.00 99.44 246,615.66 0.12% None 452 26927ABK7 248,000.00 1.60 248,000.00 2.06 1,054.51 -1,384.34 None 1.22 Prepared by Shamaira Jagrup 6 of 14 , t , City of Pearland AZKLigai Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Exchange Bank NEB 1.05 1/21/2020 7/20/2016 248,000.00 97.59 242,033.12 0.12% None 570 301074CH1 248,000.00 1.05 248,000.00 2.63 71.34 -5,966.88 None 1.55 Fahey Banking 1.1 6/28/2019 3/29/2016 248,000.00 99.20 246,009.80 0.12% None 363 303117CC7 248,000.00 1.10 248,000.00 1.92 14.95 -1,990.20 None 0.99 Farmers&Merchants Bank 1.45 9/25/2018- 4/25/2014 248,000.00 99.87 247,689.75 0.12% None 87 14 308862DD0 248,000.00 1.45 248,000.00 1.98 49.26 -310.25 None 0.24 FIRST BANK HIGHLAND PARK 1.85 5/7/2014 248,000.00 99.60 247,006.02 0.12% None 38 5/7/2019-14 319141BL0 248,000.00 1.85 248,000.00 2.33 678.77 -993.98 None 0.85 First Bank McComb MS 1.5 2/28/2019 6/30/2015 248,000.00 99.62 247,052.14 0.12% None 243 319234AJ9 248,000.00 1.50 248,000.00 2.08 20.38 -947.86 None 0.66 First Business Bank 1.7 6/30/2020 9/30/2015 248,000.00 97.84 242,641.46 0.12% None 731 31938QP40 248,000.00 1.70 248,000.00 2.82 1,062.66 -5,358.54 None 1.97 First Capital Bank 1.4 8/6/2019 4/6/2015 248,000.00 99.33 246,333.19 0.12% None 402 31944FBK5 248,000.00 1.40 248,000.00 2.02 228.30 -1,666.81 None 1.09 First Eagle National Bank 1.45 11/21/2018 11/21/2014 248,000.00 99.83 247,570.22 0.12% None 144 32008JAM5 248,000.00 1.45 248,000.00 1.89 394.08 -429.78 None 0.39 First Financial NW 1.35 10/30/2019 10/30/2015 248,000.00 98.46 244,169.39 0.12% None 487 32022MAF5 248,000.00 1.35 248,000.00 2.53 0.00 -3,830.61 None 1.32 First Intl Bank&Trust 1.6 1/16/2020 10/16/2015 248,000.00 98.46 244,172.86 0.12% None 565 32057GAE9 248,000.00 1.60 248,000.00 2.62 152.20 -3,827.14 None 1.53 First National Bank of America 1.25 7/15/2016 248,000.00 94.93 235,423.42 0.12% None 1111 7/15/2021 32110YHMO 248,000.00 1.25 248,000.00 3.01 1,409.86 -12,576.58 None 2.97 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 95.98 238,024.45 0.12% None 1096 36198JCC6 248,000.00 1.50 248,000.00 2.90 0.00 -9,975.55 None 2.93 Prepared by Shamaira Jagrup 7 of 14 ., City of Pearland iiiialiakiii Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Goldman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 98.93 245,334.74 0.12% None 605 38148JLL3 248,000.00 2.00 248,000.00 2.67 1,698.63 -2,665.26 None 1.62 Gulf Coast Bank&Trust 1.3 7/15/2021-17 7/15/2016 248,000.00 95.64 237,190.18 0.12% None 15 402194EX8 248,000.00 1.30 248,000.00 2.80 132.49 -10,809.82 None 2.98 JP Morgan Chase Bk NA Columbus 2.1 2/15/2017 245,000.00 97.90 239,861.62 0.12% None 15 2/15/2021-17 48126XVW2 245,000.00 2.10 245,000.00 2.93 211.44 -5,138.38 None 2.55 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 95.97 238,009.32 0.12% None 1096 53362LAB0 248,000.00 1.40 248,000.00 2.80 275.86 -9,990.68 None 2.93 Machias Savings Bank 1.65 2/6/2020 2/6/2015 248,000.00 99.29 246,228.78 0.12% None 586 554479DS1 248,000.00 1.65 248,000.00 2.10 269.06 -1,771.22 None 1.58 Mahopac Bank 1.45 7/30/2019 1/30/2015 248,000.00 99.63 247,073.22 0.12% None 395 560160AQ6 248,000.00 1.45 248,000.00 1.80 1,487.66 -926.78 None 1.07 Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 96.70 239,827.41 0.12% None 1095 56817TAB7 248,000.00 1.80 248,000.00 2.95 12.23 -8,172.59 None 2.92 Marlin Business Bank 1.25 12/27/2019 6/29/2016 248,000.00 98.07 243,222.78 0.12% None 545 57116AMC9 248,000.00 1.25 248,000.00 2.57 8.49 -4,777.22 None 1.48 MB Financial Bank 1.1 3/18/2019 3/18/2016 248,000.00 99.45 246,641.70 0.12% None 261 55266CQU3 248,000.00 1.10 248,000.00 1.87 89.69 -1,358.30 None 0.71 Moody National Bank 0.5 11/30/2018 5/31/2018 249,242.88 100.00 249,242.88 0.12% None 153 7130H 249,242.88 0.50 249,242.88 0.50 102.43 0.00 None 0.42 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 99.58 246,969.31 0.12% None 1010 61747MS69 248,000.00 2.80 248,000.00 2.96 1,636.12 -1,030.69 None 2.66 National Bank Commerce Superior 1.25 7/15/2016 248,000.00 95.64 237,185.96 0.12% None 15 7/15/2021-17 633368E87 248,000.00 1.25 248,000.00 2.75 127.40 -10,814.04 None 2.98 Prepared by Shamaira Jagrup 8 of 14 City of Pearland ibilpktia Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2018 Description Face Amount I Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Nebraskaland National Bank 1.2 9/25/2018 9/25/2015 248,000.00 99.93 247,837.31 0.12% None 87 63970QFC5 248,000.00 1.20 248,000.00 1.48 40.77 -162.69 None 0.24 Northern Bank&Trust MA 1.1 7/12/2019-17 7/12/2016 248,000.00 98.77 244,943.65 0.12% None 12 66476QBH0 248,000.00 1.10 248,000.00 2.31 590.44 -3,056.35 None 1.03 Northwest Bank Boise Idaho 1.5 1/10/2019 4/10/2014 248,000.00 99.87 247,686.78 0.12% None 194 66736AAD1 248,000.00 1.50 248,000.00 1.74 203.84 -313.22 None 0.53 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 97.17 240,985.07 0.12% None 731 69413CFD6 248,000.00 1.25 248,000.00 2.70 0.00 -7,014.93 None 1.98 Parkside Finl Bank&Trust 1.3 7/19/2021-17 7/18/2016 248,000.00 95.62 237,142.56 0.12% None 18 70147ABX1 248,000.00 1.30 248,000.00 2.80 105.99 -10,857.44 None 2.99 Partners Bank 1.5 9/30/2019 3/30/2015 248,000.00 99.33 246,340.14 0.12% None 457 70212YAR3 248,000.00 1.50 248,000.00 2.04 0.00 -1,659.86 None 1.24 Pearland State Bank 0.9 7/24/2018 7/24/2017 245,000.00 100.00 245,000.00 0.12% None 24 700013947B 245,000.00 0.90 245,000.00 0.90 2,060.01 0.00 None 0.07 Peoples United Bank 1.9 11/19/2019 11/19/2014 248,000.00 99.36 246,403.13 0.12% None 507 71270QKM7 248,000.00 1.90 248,000.00 2.37 542.20 -1,596.87 None 1.37 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 96.00 238,082.73 0.12% None 1090 73565NBQ5 248,000.00 1.40 248,000.00 2.80 57.07 -9,917.27 None 2.92 Quantum National Bank 1.2 9/18/2019-16 3/18/2016 248,000.00 98.56 244,426.07 0.12% None 80 74765JETI 248,000.00 1.20 248,000.00 2.41 97.84 -3,573.93 None 1.21 Sallie Mae Bank 2.15 11/19/2019 11/19/2014 248,000.00 99.37 246,439.83 0.12% None 507 795450VC6 248,000.00 2.15 248,000.00 2.62 613.55 -1,560.17 None 1.37 Signature Bank 1.35 3/28/2019 9/29/2015 248,000.00 99.71 247,283.78 0.12% None 271 82669LFU2 248,000.00 1.35 248,000.00 1.74 18.35 -716.22 None 0.74 Prepared by Shamaira Jagrup 9 of 14 City of Pearland ? gga Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Summit Community Bank Moorefield WV 6/30/2017 248,000.00 99.18 245,971.36 0.12% None 363 1.55 6/28/2019 86604XLX2 248,000.00 1.55 248,000.00 2.38 21.06 -2,028.64 None 0.99 Umpqua Bank Roseburg OR 1.6 6/28/2019 6/30/2017 248,000.00 99.23 246,097.59 0.12% None 363 90421MAX1 248,000.00 1.60 248,000.00 2.39 0.00 -1,902.41 None 0.99 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 98.58 244,475.92 0.12% None 853 91330ABC0 248,000.00 1.65 248,000.00 2.28 0.00 -3,524.08 None 2.29 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 95.65 237,212.99 0.12% None 1108 92834CBW1 248,000.00 1.30 248,000.00 2.81 1,501.59 -10,787.01 None 2.96 Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 96.65 239,701.92 0.12% None 1005 938828AC4 248,000.00 1.50 248,000.00 2.77 0.00 -8,298.08 None 2.69 Webster Bank NA 1.9 2/12/2019 2/12/2014 248,000.00 99.82 247,544.42 0.12% None 227 94768NJM7 248,000.00 1.90 248,000.00 2.20 1,781.52 -455.58 None 0.61 Welch State Bank 1.3 10/1/2018 9/30/2015 248,000.00 99.93 247,814.25 0.12% None 93 949095AU7 248,000.00 1.30 248,000.00 1.60 256.15 -185.75 None 0.25 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 96.06 238,221.11 0.12% None 1083 9497485W3 248,000.00 1.75 248,000.00 3.15 154.58 -9,778.89 None 2.89 20,091,312.82 19,772,092.60 9.73999999999999% 510 Sub Total Certificate Of Deposit 20,091,312.82 1.49 20,091,312.82 2.29 33,242.59 -319,220.22 1.58 FAMC Bond FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 98.95 989,471.00 0.5% S&P-AA+ 418 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.44 5,333.33 -10,529.00 Moodys-Aaa 1.13 FAMC 1.5 8/22/2019 2/22/2017 2,001,700.00 98.95 1,978,942.00 0.99% S&P-AA+ 418 3132X0PV7 2,000,000.00 1.47 2,000,778.22 2.44 10,666.67 -21,836.22 Moodys-Aaa 1.13 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 98.95 989,471.00 0.5% S&P-AA+ 418 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.44 5,333.33 -10,529.00 Moodys-Aaa 1.13 Prepared by Shamaira Jagrup 10 of 14 City of Pearland gt_ALUZI Portfolio Holdings by Security Type Report Group: Pearland Date:6/30/2018 Description Face Amount I Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 98.60 985,958.00 0.5% Moodys-Aaa 604 3132X0PW5 1,000,000.00 1.63 1,000,660.00 2.55 5,862.50 -14,702.00 S&P-AA+ 1.62 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 98.60 985,958.00 0.5% Moodys-Aaa 604 3132X0PW5 1,000,000.00 1.63 1,000,660.00 2.55 5,862.50 -14,702.00 S&P-AA+ 1.62 FAMC 1.72 10/3/2018 12/16/2013 997,890.00 99.95 999,499.00 0.5% Moodys-Aaa 95 31315P5A3 1,000,000.00 1.77 999,886.38 1.91 4,156.67 -387.38 S&P-AA+ 0.26 FAMC 1.82 11/9/2020 11/9/2017 1,000,000.00 98.08 980,835.00 0.5% Moodys-Aaa 863 3132X0ZC8 1,000,000.00 1.82 1,000,000.00 2.66 2,578.33 -19,165.00 S&P-AA+ 2.31 8,001,990.00 7,910,134.00 3.99% 480 Sub Total FAMC Bond 8,000,000.00 1.60 8,001,984.60 2.43 39,793.33 -91,850.60 1.29 FFCB Bond FFCB 1.5 1/28/2019 5/28/2014 1,000,000.00 99.60 995,954.00 0.5% Moodys-Aaa 212 3133EDMF6 1,000,000.00 1.50 1,000,000.00 2.21 6,333.33 -4,046.00 S&P-AA+ 0.57 FFCB 1.84 10/30/2020-18 10/30/2017 1,000,000.00 97.87 978,698.00 0.5% Moodys-Aaa 122 3133EHM26 1,000,000.00 1.84 1,000,000.00 2.79 3,066.67 -21,302.00 S&P-AA+ 2.29 FFCB 1.95 9/17/2018 1/29/2014 1,014,770.00 100.00 1,000,037.00 0.5% Moodys-Aaa 79 3133ED2C5 1,000,000.00 1.62 1,000,681.83 1.92 5,579.17 -644.83 S&P-AA+ 0.21 3,014,770.00 2,974,689.00 1.5% 138 Sub Total FFCB Bond 3,000,000.00 1.65 3,000,681.83 2.31 14,979.17 -25,992.83 1.02 FHLB Bond FHLB 1 9/26/2019 9/22/2016 997,430.00 98.27 982,686.00 0.49% Moodys-Aaa 453 3130A9EP2 1,000,000.00 1.09 998,942.60 2.43 2,611.11 -16,256.60 S&P-AA+ 1.23 FHLB 1.45 6/28/2019-17 6/28/2017 1,000,000.00 99.09 990,876.00 0.5% Moodys-Aaa 90 3130ABHRO 1,000,000.00 1.45 1,000,000.00 2.38 80.56 -9,124.00 S&P-AA+ 0.99 FHLB 1.75 12/14/2018 12/16/2013 1,000,670.00 99.80 997,962.00 0.5% Moodys-Aaa 167 313376BR5 1,000,000.00 1.74 1,000,061.11 2.20 777.78 -2,099.11 S&P-AA+ 0.46 Prepared by Shamaira Jagrup 11 of 14 ft �> City of Pearland f 6t kiAl Portfolio Holdings by Security Type `'` ,°"' Report Group: Pearland Date:6/30/2018 Description Face Amount/ Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FHLB 2.2 1/29/2021-19 1/29/2018 1,000,000.00 98.71 987,094.00 0.5% Moodys-Aaa 213 3130ADC26 1,000,000.00 2.20 1,000,000.00 2.72 9,227.78 -12,906.00 S&P-AA+ 2.5 FHLB 2.4 3/27/2020-18 3/27/2018 1,000,000.00 99.52 995,197.00 0.5% S&P-AA+ 89 3130ADSH6 1,000,000.00 2.40 1,000,000.00 2.68 6,200.00 -4,803.00 Moodys-Aaa 1.71 4,998,100.00 4,953,815.00 2.49% 202 Sub Total FHLB Bond 5,000,000.00 1.77 4,999,003.71 2.48 18,897.23 -45,188.71 1.38 FHLMC Bond FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 95.43 954,311.00 0.49% Moodys-Aaa 1139 3137EAEC9 1,000,000.00 1.37 992,694.25 2.66 4,156.25 -38,383.25 S&P-AA+ 3.06 FHLMC 1.35 12/17/2018-15 6/19/2015 999,525.00 99.65 996,497.00 0.5% S&P-AA+ 170 3134G6S95 1,000,000.00 1.36 999,936.94 2.11 487.50 -3,439.94 Moodys-Aaa 0.46 FHLMC 1.42 3/29/2019-17 3/29/2017 2,000,000.00 99.38 1,987,572.00 0.99% S&P-AA+ 91 3134GA6G4 2,000,000.00 1.42 2,000,000.00 2.26 7,178.89 -12,428.00 Moodys-Aaa 0.74 FHLMC 2 11/20/2020-18 12/5/2017 1,000,000.00 98.41 984,078.00 0.5% Moodys-Aaa 51 3134GBW32 1,000,000.00 2.00 1,000,000.00 2.69 2,222.22 -15,922.00 S&P-AA+ 2.34 FHLMC 2.2 12/8/2021-18 12/8/2017 1,000,000.00 97.97 979,658.00 0.5% Moodys-Aaa 70 3134GB4N9 1,000,000.00 2.20 1,000,000.00 2.83 1,344.44 -20,342.00 S&P-AA+ 3.33 FHLMC Step 8/3/2021-18 3/9/2018 691,243.00 98.10 686,665.00 0.34% S&P-AA+ 34 3134GBA93 700,000.00 2.61 692,037.14 2.92 5,002.08 -5,372.14 Moodys-Aaa 2.99 6,679,308.00 6,588,781.00 3.32% 243 Sub Total FHLMC Bond 6,700,000.00 1.73 6,684,668.33 2.52 20,391.38 -95,887.33 1.9 FNMA Bond FNMA 1.375 3/13/2019-16 9/22/2016 1,009,560.00 99.36 993,630.00 0.5% Moodys-Aaa 256 3136G1FY0 1,000,000.00 0.98 1,002,714.57 2.29 4,086.81 -9,084.57 S&P-AA+ 0.7 FNMA 1.625 11/27/2018 7/16/2014 1,004,411.00 99.80 998,030.00 0.5% Moodys-Aaa 150 3135G0YT4 1,000,000.00 1.52 1,000,412.74 2.11 1,489.58 -2,382.74 S&P-AA+ 0.41 Prepared by Shamaira Jagrup 12 of 14 "`'°< City of Pearland a liiakali Portfolio Holdings by Security Type `_t" 00'. Report Group: Pearland Date:6/30/2018 Description Face Amount I Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 98.15 981,540.00 0.5% Moodys-Aaa 912 3135G0H55 1,000,000.00 1.25 1,015,130.36 2.65 104.17 -33,590.36 S&P-AA+ 2.45 3,039,851.00 2,973,200.00 1.5% 441 Sub Total FNMA Bond 3,000,000.00 1.25 3,018,257.67 2.35 5,680.56 -45,057.67 1.19 Local Government Investment Pool Texas Class LGIP 12/20/2016 3,583,766.58 100.00 3,583,766.58 1.78% None 1 TX-01-0615-0001 3,583,766.58 2.16 3,583,766.58 2.16 0.00 None 0 Texas Class LGIP 5/15/2017 509,014.69 100.00 509,014.69 0.25% None 1 TX-01-0615-0001 509.014.69 2.16 509,014.69 2.16 0.00 None 0 Texas Class LGIP 5/15/2017 19,839.63 100.00 19,839.63 0.01% None 1 TX-01-0615-0001 19,839.63 2.16 19,839.63 2.16 0.00 None 0 Texas Class LGIP 12/20/2016 12,257,687.99 100.00 12,257,687.99 6.07% None 1 TX-01-0615-0001 12,257,687.99 2.16 12,257,687.99 2.16 0.00 None 0 Texas Class LGIP 5/15/2017 3,054,088.21 100.00 3,054,088.21 1.51% None 1 TX-01-0615-0001 3,054,088.21 2.16 3,054,088.21 2.16 0.00 None 0 Texas Class LGIP 1/15/2017 8,157,633.00 100.00 8,157,633.00 4.04% None 1 TX-01-0615-0001 8,157,633.00 2.16 8,157,633.00 2.16 0.00 None 0 Texas Class LGIP 12/20/2016 3,608,618.67 100.00 3,608,618.67 1.79% None 1 TX-01-0615-0001 3,608,618.67 2.16 3,608,618.67 2.16 0.00 None 0 Texas Class LGIP 1/15/2017 1,020,927.41 100.00 1,020,927.41 0.51% None 1 TX-01-0615-0001 1,020,927.41 2.16 1,020,927.41 2.16 0.00 None 0 Texas Class LGIP 12/20/2016 23,101,754.52 100.00 23,101,754.52 11.44% • None 1 TX-01-0615-0001 23,101,754.52 2.16 23,101,754.52 2.16 0.00 None 0 Texas Class LGIP 1/15/2017 1,020,927.41 100.00 1,020,927.41 0.51% None 1 TX-01-0615-0001 1,020,927.41 2.16 1,020,927.41 2.16 0.00 None 0 Prepared by Shamaira Jagrup 13 of 14 -,, City of Pearland LOM'i,abli Portfolio Holdings by Security Type ',r ,x'0. Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity TexSTAR LGIP 8/26/2016 5,090,036.54 100.00 5,090,036.54 2.52% S&P-AAA 1 02000-11110 5,090,036.54 1.83 5,090,036.54 1.83 0.00 None 0 TexSTAR LGIP 8/26/2016 5,090,388.19 100.00 5,090,388.19 2.52% S&P-AAA 1 02000-11110 5,090,388.19 1.83 5,090,388.19 1.83 0.00 None 0 66,514,682.84 66,514,682.84 32.95% 1 Sub Total Local Government Investment 66,514,682.84 2.11 66,514,682.84 2.11 0.00 0 Pool 201,867,489.46 201,234,869.24 100.00% 92 TOTAL PORTFOLIO 201,853,470.46 1.84 201,858,066.60 2.02 132,984.26 -623,197.36 0.34 Prepared by Shamaira Jagrup 14 of 14 ot o °`a4 City of Pearland 444Cityh V O fiNdalika Portfolio Holdings by Portfolio Name if` ,,q% Report Group: Pearland Date:6/30/2018 Description Face Amount/ Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 100:General Fund Allegiance Bank 0.8 9/13/2018 9/13/2017 248,069.94 100.00 248,069.94 0.12% None 75 2611523D 248,069.94 0.80 248,069.94 0.80 92.43 0.00 None 0.2 Alma Bank 1.35 12/24/2020 6/24/2016 248,000.00 96.28 238,770.43 0.12% None 908 020080682 248,000.00 1.35 248,000.00 2.91 55.04 -9,229.57 None 2.44 American Eagle Bank IL 1.35 7/12/2021 7/11/2016 248,000.00 95.63 237,161.66 0.12% None 1108 02554BCM1 248,000.00 1.35 248,000.00 2.86 174.28 -10,838.34 None 2.97 Bank Leumi USA 1.3 2/26/2020 3/3/2016 248,000.00 98.69 244,747.48 0.12% None 606 063248FH6 248,000.00 1.30 248,000.00 2.11 1,095.28 -3,252.52 None 1.64 Bank of the Pacific 1.25 7/30/2018 1/29/2015 248,000.00 99.95 247,865.58 0.12% None 30 06425BBN8 248,000.00 1.25 248,000.00 1.90 1,282.47 -134.42 None 0.08 Bankers Bank Oklahoma 1.8 9/25/2020 9/25/2015 248,000.00 98.68 244,720.94 0.12% None 818 06610QCV1 248,000.00 1.80 248,000.00 2.41 61.15 -3,279.06 None 2.19 Bar Harbor Bank&Trust 2.65 3/29/2021-18 3/29/2018 248,000.00 99.20 246,004.10 0.12% None 29 066851WB8 248,000.00 2.65 248,000.00 2.96 18.01 -1,995.90 None 2.65 Belmont Savings Bank 1.85 10/23/2019 12/23/2014 248,000.00 99.35 246,391.47 0.12% None 480 080515BD0 248,000.00 1.85 248,000.00 2.36 87.99 -1,608.53 None 1.3 Capital One NA 2.3 9/25/2020 9/23/2015 248,000.00 98.71 244,811.46 0.12% None 818 14042RAB7 248,000.00 2.30 248,000.00 2.90 1,515.86 -3,188.54 None 2.18 Carolina Premier Bank 1.1 7/27/2020 7/27/2016 248,000.00 96.96 240,452.12 0.12% None 758 144153AW3 248,000.00 1.10 248,000.00 2.61 22.42 -7,547.88 None 2.05 CDARS 0.7 12/13/2018 12/15/2016 500,000.00 100.00 500,000.00 0.25% None 166 1019720221 500,000.00 0.70 500,000.00 0.70 1,706.85 0.00 None 0.45 Cit Bank Salt Lake 2.1 11/19/2019 11/19/2014 248,000.00 99.38 246,472.82 0.12% None 507 17284C3Z5 248,000.00 2.10 248,000.00 2.56 599.28 -1,527.18 None 1.37 Prepared by Shamaira Jagrup 1 of 16 J q c °,j City of Pearland Portfolio Holdings by Portfolio Name ``' 'N9'. Report Group: Pearland Date:6/30/2018 Description Face Amount/ Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Commercial Bank Ala Mich 1.5 3/29/2019 6/30/2015 248,000.00 99.43 246,582.43 0.12% None 272 201282GV6 248,000.00 1.50 248,000.00 2.27 10.19 -1,417.57 None 0.74 Community Bank Pasadena 1.5 6/30/2021 6/30/2016 248,000.00 95.98 238,024.45 0.12% None 1096 203507BG2 248,000.00 1.50 248,000.00 2.90 0.00 -9,975.55 None 2.93 Community Bankers'Bank 1.4 6/30/2021 6/30/2016 248,000.00 95.97 238,009.32 0.12% None 1096 20361LBR4 248,000.00 1.40 248,000.00 2.80 0.00 -9,990.68 None 2.94 Exchange Bank NEB 1.05 1/21/2020 7/20/2016 248,000.00 97.59 242,033.12 0.12% None 570 301074CH1 248,000.00 1.05 248,000.00 2.63 71.34 -5,966.88 None 1.55 Fahey Banking 1.1 6/28/2019 3/29/2016 248,000.00 99.20 246,009.80 0.12% None 363 303117CC7 248,000.00 1.10 248,000.00 1.92 14.95 -1,990.20 None 0.99 FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 98.60 985,958.00 0.5% Moodys-Aaa 604 3132X0PW5 1,000,000.00 1.63 1,000,660.00 2.55 5,862.50 -14,702.00 S&P-AA+ 1.62 Farmers&Merchants Bank 1.45 9/25/2018- 4/25/2014 248,000.00 99.87 247,689.75 0.12% None 87 14 308862DD0 248,000.00 1.45 248,000.00 1.98 49.26 -310.25 None 0.24 FHLB 1.45 6/28/2019-17 6/28/2017 1,000,000.00 99.09 990,876.00 0.5% Moodys-Aaa 90 3130ABHRO 1,000,000.00 1.45 1,000,000.00 2.38 80.56 -9,124.00 S&P-AA+ 0.99 FHLB 2.4 3/27/2020-18 3/27/2018 1,000,000.00 99.52 995,197.00 0.5% S&P-AA+ 89 3130ADSH6 1,000,000.00 2.40 1,000,000.00 2.68 6,200.00 -4,803.00 Moodys-Aaa 1.71 FHLMC 1.35 12/17/2018-15 6/19/2015 999,525.00 99.65 996,497.00 0.5% S&P-AA+ 170 3134G6S95 1,000,000.00 1.36 999,936.94 2.11 487.50 -3,439.94 Moodys-Aaa 0.46 FHLMC 1.42 3/29/2019-17 3/29/2017 2,000,000.00 99.38 1,987,572.00 0.99% S&P-AA+ 91 3134GA6G4 2,000,000.00 1.42 2,000,000.00 2.26 7,178.89 -12,428.00 Moodys-Aaa 0.74 FHLMC Step 8/3/2021-18 3/9/2018 691,243.00 98.10 686,665.00 0.34% S&P-AA+ 34 3134GBA93 700,000.00 2.61 692,037.14 2.92 5,002.08 -5,372.14 Moodys-Aaa 2.99 Prepared by Shamaira Jagrup 2 of 16 4411*' A � 11*rc:' City of Pearland t __9 Portfolio Holdings by Portfolio Name '` 00' Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FIRST BANK HIGHLAND PARK 1.85 5/7/2014 248,000.00 99.60 247,006.02 0.12% None 38 5/7/2019-14 3191418L0 248,000.00 1.85 248,000.00 2.33 678.77 -993.98 None 0.85 JP Morgan Chase Bk NA Columbus 2.1 2/15/2017 245,000.00 97.90 239,861.62 0.12% None 15 2/15/2021-17 48126XVW2 245,000.00 2.10 245,000.00 2.93 211.44 -5,138.38 None 2.55 Machias Savings Bank 1.65 2/6/2020 2/6/2015 248,000.00 99.29 246,228.78 0.12% None 586 554479DS1 248,000.00 1.65 248,000.00 2.10 269.06 -1,771.22 None 1.58 Mahopac Bank 1.45 7/30/2019 1/30/2015 248,000.00 99.63 247,073.22 0.12% None 395 560160AQ6 248,000.00 1.45 248,000.00 1.80 1,487.66 -926.78 None 1.07 Moody National Bank 0.5 11/30/2018 5/31/2018 249,242.88 100.00 249,242.88 0.12% None 153 7130H 249,242.88 0.50 249,242.88 0.50 102.43 0.00 None 0.42 Morgan Stanley Bank NA 2.8 4/5/2021 4/5/2018 248,000.00 99.58 246,969.31 0.12% None 1010 61747MS69 248,000.00 2.80 248,000.00 2.96 1,636.12 -1,030.69 None 2.66 Pearland State Bank 0.9 7/24/2018 7/24/2017 245,000.00 100.00 245,000.00 0.12% None 24 7000139478 245,000.00 0.90 245,000.00 0.90 2,060.01 0.00 None 0.07 Quantum National Bank 1.2 9/18/2019-16 3/18/2016 248,000.00 98.56 244,426.07 0.12% None 80 74765JETI 248,000.00 1.20 248,000.00 2.41 97.84 -3,573.93 None 1.21 Sallie Mae Bank 2.15 11/19/2019 11/19/2014 248,000.00 99.37 246,439.83 0.12% None 507 795450VC6 248,000.00 2.15 248,000.00 2.62 613.55 -1,560.17 None 1.37 Texas Class LGIP 5/15/2017 19,839.63 100.00 19,839.63 0.01% None 1 TX-01-0615-0001 19,839.63 2.16 19,839.63 2.16 0.00 None 0 Unity Bank 1.65 10/30/2020 10/30/2015 248,000.00 98.58 244,475.92 0.12% None 853 91330ABC0 248,000.00 1.65 248,000.00 2.28 0.00 -3,524.08 None 2.29 Vision Bank of Iowa 1.3 7/12/2021 7/11/2016 248,000.00 95.65 237,212.99 0.12% None 1108 92834CBW1 248,000.00 1.30 248,000.00 2.81 1,501.59 -10,787.01 None 2.96 Prepared by Shamaira Jagrup 3 of 16 a k,,, City of Pearland ErAVR4r1I Portfolio Holdings by Portfolio Name `,, ,,"' Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Washington Federal 1.5 3/31/2021-16 3/31/2016 248,000.00 96.65 239,701.92 0.12% None 1005 938828AC4 248,000.00 1.50 248,000.00 2.77 0.00 -8,298.08 None 2.69 Wells Fargo Bank 1.75 6/17/2021 6/20/2016 248,000.00 96.06 238,221.11 0.12% None 1083 9497485W3 248,000.00 1.75 248,000.00 3.15 154.58 -9,778.89 None 2.89 Wells Fargo Sweep Cash 5/31/2006 9,045,828.71 100.00 9,045,828.71 4.48% None 1 WFSWEEP 9,045,828.71 1.79 9,045,828.71 1.79 0.00 None 0 23,692,949.16 23,524,109.88 11.67% 225 Sub Total 100:General Fund 23,700,981.16 1.67 23,693,615.24 2.12 40,481.38 -169,505.36 0.9 200: Debt Services 1st Source Bank 1.5 11/18/2019 4/17/2015 248,000.00 99.11 245,798.50 0.12% None 506 33646CEQ3 248,000.00 1.50 248,000.00 2.15 754.19 -2,201.50 None 1.37 Charter Bank 1.7 2/25/2020 2/25/2015 248,000.00 98.44 244,125.00 0.12% None 605 1611648E7 248,000.00 1.70 248,000.00 2.67 57.75 -3,875.00 None 1.63 ConnectOne Bank 1.55 7/30/2018 1/30/2014 248,000.00 99.99 247,979.17 0.12% None 30 20786AAM7 248,000.00 1.55 248,000.00 1.65 0.00 -20.83 None 0.08 Discover Bank 2 2/25/2020 2/25/2015 248,000.00 98.93 245,334.74 0.12% None 605 254672JA7 248,000.00 2.00 248,000.00 2.67 1,698.63 -2,665.26 None 1.62 First Capital Bank 1.4 8/6/2019 4/6/2015 248,000.00 99.33 246,333.19 0.12% None 402 31944FBK5 248,000.00 1.40 248,000.00 2.02 228.30 -1,666.81 None 1.09 Goldman Sachs Bank 2 2/25/2020 2/25/2015 248,000.00 98.93 245,334.74 0.12% None 605 38148JLL3 248,000.00 2.00 248,000.00 2.67 1,698.63 -2,665.26 None 1.62 Partners Bank 1.5 9/30/2019 3/30/2015 248,000.00 99.33 246,340.14 0.12% None 457 70212YAR3 248,000.00 1.50 248,000.00 2.04 0.00 -1,659.86 None 1.24 Texas Class LGIP 1/15/2017 8,157,633.00 100.00 8,157,633.00 4.04% None 1 TX-01-0615-0001 8,157,633.00 2.16 8,157,633.00 2.16 0.00 None 0 Prepared by Shamaira Jagrup 4 of 16 O� ` Pr+r s City of Pearland t� Portfolio Holdings by Portfolio Name ' Report Group: Pearland Date:6/30/2018 Description Face Amount/ Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Webster Bank NA 1.9 2/12/2019 2/12/2014 248,000.00 99.82 247,544.42 0.12% None 227 94768NJM7 248,000.00 1.90 248,000.00 2.20 1,781.52 -455.58 None 0.61 Wells Fargo Sweep Cash 5/31/2006 2,143,794.88 100.00 2,143,794.88 1.06% None 1 WFSWEEP 2,143,794.88 1.79 2,143,794.88 1.79 0.00 None 0 12,285,427.88 12,270,217.78 6.06% 70 Sub Total 200:Debt Services 12,285,427.88 2.02 12,285,427.88 2.11 6,219.02 -15,210.10 0.19 305: Hotel/Motel Occupancy Ally Bank Midvale Utah 1.8 6/29/2020 6/29/2017 248,000.00 98.04 243,132.26 0.12% None 730 02006L3U5 248,000.00 1.80 248,000.00 2.82 12.23 -4,867.74 None 1.97 Bank of New England NH 1.4 6/30/2021 6/30/2016 248,000.00 95.97 238,009.32 0.12% None 1096 063847AL1 248,000.00 1.40 248,000.00 2.80 0.00 -9,990.68 None 2.94 Capital Bank Little Rock 1.35 3/22/2019 9/23/2015 248,000.00 99.73 247,332.14 0.12% None 265 139797FL3 248,000.00 1.35 248,000.00 1.72 73.38 -667.86 None 0.72 First Intl Bank&Trust 1.6 1/16/2020 10/16/2015 248,000.00 98.46 244,172.86 0.12% None 565 32057GAE9 248,000.00 1.60 248,000.00 2.62 152.20 -3,827.14 None 1.53 Texas Class LGIP 5/15/2017 3,054,088.21 100.00 3,054,088.21 1.51% None 1 TX-01-0615-0001 3,054,088.21 2.16 3,054,088.21 2.16 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 845,265.38 100.00 845,265.38 0.42% None 1 WFSWEEP 845,265.38 1.79 845,265.38 1.79 0.00 None 0 4,891,353.59 4,872,000.17 2.41% 135 Sub Total 305:Hotel/Motel Occupancy 4,891,353.59 1.97 4,891,353.59 2.16 237.81 -19,353.42 0.36 310:Municipal Court Security Wells Fargo Sweep Cash 5/31/2006 29,392.77 100.00 29,392.77 0.01% None 1 WFSWEEP 29,392.77 1.79 29,392.77 1.79 0.00 None 0 29,392.77 29,392.77 0.01% 1 Sub Total 310:Municipal Court Security 29,392.77 1.79 29,392.77 1.79 0.00 0 315: City Wide Donation I Prepared by Shamaira Jagrup 5 of 16 ''�> City of Pearland t '__9 Portfolio Holdings by Portfolio Name `'' ,s Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 5/31/2006 90,145.97 100.00 90,145.97 0.04% None 1 WFSWEEP 90,145.97 1.79 90,145.97 1.79 0.00 None 0 90,145.97 90,145.97 0.04% 1 Sub Total 315:City Wide Donation 90,145.97 1.79 90,145.97 1.79 0.00 0 320:Court Technology Wells Fargo Sweep Cash 5/31/2006 -12,097.19 100.00 -12,097.19 -0.01% None 1 WFSWEEP -12,097.19 1.79 -12,097.19 1.79 0.00 None 0 -12,097.19 -12,097.19 -0.01% 1 Sub Total 320:Court Technology -12,097.19 1.79 -12,097.19 1.79 0.00 0 330:Park Donations Wells Fargo Sweep Cash 5/31/2006 87,751.53 100.00 87,751.53 0.04% None 1 WFSWEEP 87,751.53 1.79 87,751.53 1.79 0.00 None 0 87,751.53 87,751.53 0.04% 1 Sub Total 330:Park Donations 87,751.53 1.79 87,751.53 1.79 0.00 0 331:Tree Trust Fund Wells Fargo Sweep Cash 5/31/2006 423,285.75 100.00 423,285.75 0.21% None 1 WFSWEEP 423,285.75 1.79 423,285.75 1.79 0.00 None 0 423,285.75 423,285.75 0.21% 1 Sub Total 331:Tree Trust Fund 423,285.75 1.79 423,285.75 1.79 0.00 0 335:Police State Seizure Wells Fargo Sweep Cash 5/31/2006 244,543.84 100.00 244,543.84 0.12% None 1 WFSWEEP 244,543.84 1.79 244,543.84 1.79 0.00 None 0 244,543.84 244,543.84 0.12% 1 • Sub Total 335:Police State Seizure 244,543.84 1.79 244,543.84 1.79 0.00 0 336: Federal Police Fund Wells Fargo Sweep Cash 5/31/2006 83,316.38 100.00 83,316.38 0.04% None 1 WFSWEEP 83,316.38 1.79 83,316.38 1.79 0.00 None 0 83,316.38 83,316.38 0.04% 1 Sub Total 336:Federal Police Fund 83,316.38 1.79 83,316.38 1.79 0.00 0 Prepared by Shamaira Jagrup 6 of 16 PI, *et,. o City of Pearland 0 liikaidta Portfolio Holdings by Portfolio Name `f` .0, Report Group: Pearland Date:6/30/2018 Description Face Amount/ Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 340: Park&Rec Development Border State Bank 1.4 6/30/2021 6/30/2016 248,000.00 95.41 236,617.05 0.12% None 1096 099703EF3 248,000.00 1.40 248,000.00 3.00 0.00 -11,382.95 None 2.94 Nebraskaland National Bank 1.2 9/25/2018 9/25/2015 248,000.00 99.93 247,837.31 0.12% None 87 63970QFC5 248,000.00 1.20 248,000.00 1.48 40.77 -162.69 None 0.24 Wells Fargo Sweep Cash 5/31/2006 726,669.08 100.00 726,669.08 0.36% None 1 WFSWEEP 726,669.08 1.79 726,669.08 1.79 0.00 None 0 1,222,669.08 1,211,123.44 0.6% 241 Sub Total 340:Park&Rec Development 1,222,669.08 1.59 1,222,669.08 1.97 40.77 -11,545.64 0.65 345:Sidewalk Fund Wells Fargo Sweep Cash 5/31/2006 6,422.72 100.00 6,422.72 0% None 1 WFSWEEP 6,422.72 1.79 6,422.72 1.79 0.00 None 0 6,422.72 6,422.72 0% 1 Sub Total 345:Sidewalk Fund 6,422.72 1.79 6,422.72 1.79 0.00 0 350:Grant Fund Wells Fargo Sweep Cash 5/31/2006 187,735.07 100.00 187,735.07 0.09% None 1 WFSWEEP 187,735.07 1.79 187,735.07 1.79 0.00 None 0 187,735.07 187,735.07 0.09% 1 Sub Total 350:Grant Fund 187,735.07 1.79 187,735.07 1.79 0.00 0 351:CDBG Fund Wells Fargo Sweep Cash 11/15/2015 16,386.08 100.00 16,386.08 0.01% None 1 WFSWEEP 16,386.08 1.79 16,386.08 1.79 0.00 None 0 16,386.08 16,386.08 0.01% 1 Sub Total 351:CDBG Fund 16,386.08 1.79 16,386.08 1.79 0.00 0 360:Traffic Impact Improvement Summit Community Bank Moorefield WV 6/30/2017 248,000.00 99.18 245,971.36 0.12% None 363 1.55 6/28/2019 86604XLX2 248,000.00 1.55 248,000.00 2.38 21.06 -2,028.64 None 0.99 Prepared by Shamaira Jagrup 7 of 16 City of Pearland 16W-Akiia Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 5/31/2006 348,263.51 100.00 348,263.51 0.17% None 1 WFSWEEP 348,263.51 1.79 348,263.51 1.79 0.00 None 0 596,263.51 594,234.87 0.29% 152 Sub Total 360:Traffic Impact Improvement 596,263.51 1.69 596,263.51 2.03 21.06 -2,028.64 0.41 365: Court Juvenile Mgmt Wells Fargo Sweep Cash 9/15/2009 27,567.13 100.00 27,567.13 0.01% None 1 WFSWEEP 27,567.13 1.79 27,567.13 1.79 0.00 None 0 27,567.13 27,567.13 0.01% 1 Sub Total 365:Court Juvenile Mgmt 27,567.13 1.79 -27,567.13 1.79 0.00 0 370:Municipal Channel Texas Class LGIP 5/15/2017 509,014.69 100.00 509,014.69 0.25% None 1 TX-01-0615-0001 509,014.69 2.16 509,014.69 2.16 0.00 None 0 Wells Fargo Sweep Cash 4/15/2012 143,989.73 100.00 143,989.73 0.07% None 1 WFSWEEP 143,989.73 1.79 143,989.73 1.79 0.00 None 0 653,004.42 653,004.42 0.32% 1 Sub Total 370:Municipal Channel 653,004.42 2.08 653,004.42 2.08 0.00 0 380: Regional Detention Wells Fargo Sweep Cash 5/31/2006 0.34 100.00 0.34 0% None 1 WFSWEEP 0.34 1.79 0.34 1.79 0.00 None 0 0.34 0.34 0% 1 Sub Total 380:Regional Detention 0.34 1.79 0.34 1.79 0.00 0 500:Capital Projects Texas Class LGIP 1/15/2017 1,020,927.41 100.00 1,020,927.41 0.51% None 1 TX-01-0615-0001 1,020,927.41 2.16 1,020,927.41 2.16 0.00 None 0 Umpqua Bank Roseburg OR 1.6 6/28/2019 6/30/2017 248,000.00 99.23 246,097.59 0.12% None 363 90421MAX1 248,000.00 1.60 248,000.00 2.39 0.00 -1,902.41 None 0.99 Wells Fargo Sweep Cash 5/31/2006 2,297,301.37 100.00 2,297,301.37 1.14% None 1 WFSWEEP 2,297,301.37 1.79 2,297,301.37 1.79 0.00 None 0 Prepared by Shamaira Jagrup 8 of 16 - -;*' City of Pearland giokkkg Portfolio Holdings by Portfolio Name . Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 3,566,228.78 3,564,326.37 1.77% 26 Sub Total 500:Capital Projects 3,566,228.78 1.88 3,566,228.78 1.93 0.00 -1,902.41 0.07 501:Certificates of Obligation 1st Security Bank of Wash 1.1 1/22/2021 7/22/2016 248,000.00 95.51 236,873.23 0.12% None 937 33625CAZ2 248,000.00 1.10 248,000.00 2.92 59.79 -11,126.77 None 2.52 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 98.95 989,471.00 0.5% S&P-AA+ 418 3132XOPV7 1,000,000.00 1.50 1,000,000.00 2.44 5,333.33 -10,529.00 Moodys-Aaa 1.13 FHLMC 1.125 8/12/2021 9/22/2016 988,540.00 95.43 954,311.00 0.49% Moodys-Aaa 1139 3137EAEC9 1,000,000.00 1.37 992,694.25 2.66 4,156.25 -38,383.25 S&P-AA+ 3.06 FNMA 1.875 12/28/2020 9/22/2016 1,025,880.00 98.15 981,540.00 0.5% Moodys-Aaa 912 3135G0H55 1,000,000.00 1.25 1,015,130.36 2.65 104.17 -33,590.36 S&P-AA+ 2.45 Gulf Coast Bank&Trust 1.3 7/15/2021-17 7/15/2016 248,000.00 95.64 237,190.18 0.12% None 15 402194EX8 248,000.00 1.30 248,000.00 2.80 132.49 -10,809.82 None 2.98 Marlin Business Bank 1.25 12/27/2019 6/29/2016 248,000.00 98.07 243,222.78 0.12% None 545 57116AMC9 248,000.00 1.25 248,000.00 2.57 8.49 -4,777.22 None 1.48 Texas Class LGIP 12/20/2016 3,608,618.67 100.00 3,608,618.67 1.79% None 1 TX-01-0615-0001 3,608,618.67 2.16 3,608,618.67 2.16 0.00 None 0 TexSTAR LGIP 8/26/2016 5,090,388.19 100.00 5,090,388.19 2.52% S&P-AAA 1 02000-11110 5,090,388.19 1.83 5,090,388.19 1.83 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 1,282,418.08 100.00 1,282,418.08 0.64% None 1 WFSWEEP 1,282,418.08 1.79 1,282,418.08 1.79 0.00 None 0 13,739,844.94 13,624,033.13 6.8% 208 Sub Total 501:Certificates of Obligation 13,725,424.94 1.78 13,733,249.55 2.13 9,794.52 -109,216.42 0.61 503:Certificates of Obligation 2006 Wells Fargo Sweep Cash 6/30/2006 63,762.34 100.00 63,762.34 0.03% None 1 WFSWEEP 63,762.34 1.79 63,762.34 1.79 0.00 None 0 Prepared by Shamaira Jagrup 9 of 16 ,./100::,. City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 63,762.34 63,762.34 0.03% 1 Sub Total 503:Certificates of Obligation 63,762.34 1.79 63,762.34 1.79 0.00 0 2006 506:General Obligation Brickell Bank Miami FL 1.65 10/28/2019 6/27/2017 248,000.00 98.86 245,165.11 0.12% None 485 10801DAG6 248,000.00 1.65 248,000.00 2.53 22.42 -2,834.89 None 1.31 Business Bank of St Louis MO 1.8 6/23/2021 6/23/2017 248,000.00 96.59 239,538.74 0.12% None 1089 12325EHU9 248,000.00 1.80 248,000.00 3.00 85.61 -8,461.26 None 2.9 Capital One Bank USA 1.1 11/19/2019 11/19/2014 248,000.00 99.37 246,439.09 0.12% None 507 140420QX1 248,000.00 1.10 248,000.00 1.56 313.91 -1,560.91 None 1.38 Citizens State Bank Clayton 1.35 4/30/2019 9/30/2015 248,000.00 99.67 247,173.42 0.12% None 304 176688BS7 248,000.00 1.35 248,000.00 1.75 0.00 -826.58 None 0.83 FFCB 1.5 1/28/2019 5/28/2014 1,000,000.00 99.60 995,954.00 0.5% Moodys-Aaa 212 3133EDMF6 1,000,000.00 1.50 1,000,000.00 2.21 6,333.33 -4,046.00 S&P-AA+ 0.57 FHLB 1 9/26/2019 9/22/2016 997,430.00 98.27 982,686.00 0.49% Moodys-Aaa 453 3130A9EP2 1,000,000.00 1.09 998,942.60 2.43 2,611.11 -16,256.60 S&P-AA+ 1.23 First Business Bank 1.7 6/30/2020 9/30/2015 248,000.00 97.84 242,641.46 0.12% None 731 31938QP40 248,000.00 1.70 248,000.00 2.82 1,062.66 -5,358.54 None 1.97 - First National Bank of America 1.25 7/15/2016 248,000.00 94.93 235,423.42 0.12% None 1111 7/15/2021 32110YHMO 248,000.00 1.25 248,000.00 3.01 1,409.86 -12,576.58 None 2.97 Lincoln 1st Bank 1.4 6/30/2021 6/30/2016 248,000.00 95.97 238,009.32 0.12% None 1096 53362LAB0 248,000.00 1.40 248,000.00 2.80 275.86 -9,990.68 None 2.93 National Bank Commerce Superior 1.25 7/15/2016 248,000.00 95.64 237,185.96 0.12% None 15 7/15/2021-17 633368E67 248,000.00 1.25 248,000.00 2.75 127.40 -10,814.04 None 2.98 Peoples United Bank 1.9 11/19/2019 11/19/2014 248,000.00 99.36 246,403.13 0.12% None 507 71270QKM7 248,000.00 1.90 248,000.00 2.37 542.20 -1,596.87 None 1.37 Prepared by Shamaira Jagrup 10 of 16 City of Pearland iiiialitALSI Portfolio Holdings by Portfolio Name ',, ," Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Texas Class LGIP 12/20/2016 12,257,687.99 100.00 12,257,687.99 6.07% None 1 TX-01-0615-0001 12,257,687.99 2.16 12,257,687.99 2.16 0.00 None 0 TexSTAR LGIP 8/26/2016 5,090,036.54 100.00 5,090,036.54 2.52% S&P-AAA 1 02000-11110 5,090,036.54 1.83 5,090,036.54 1.83 0.00 None 0 Wells Fargo Sweep Cash 10/30/2008 1,249,260.73 100.00 1,249,260.73 0.62% None 1 WFSWEEP 1,249,260.73 1.79 1,249,260.73 1.79 0.00 None 0 22,826,415.26 22,753,604.91 11.28% 93 Sub Total 506:General Obligation 22,828,985.26 1.92 22,827,927.86 2.11 12,784.36 -74,322.95 0.28 510: Lower Kirby Urban Center Wells Fargo Sweep Cash 10/15/2015 148,477.69 100.00 148,477.69 0.07% None 1 WFSWEEP 148,477.69 1.79 148,477.69 1.79 0.00 None 0 148,477.69 148,477.69 0.07% 1 Sub Total 510:Lower Kirby Urban Center 148,477.69 1.79 148,477.69 1.79 0.00 0 550:W/S Impact Fee Bankwest,Inc.1.5 1/3/2020 3/4/2015 248,000.00 98.36 243,941.98 0.12% None 552 06652CFA4 248,000.00 1.50 248,000.00 2.61 275.18 -4,058.02 None 1.49 BMW Bank 2.1 6/19/2020 6/19/2015 248,000.00 98.43 244,111.61 0.12% None 720 05580ABX1 248,000.00 2.10 248,000.00 2.93 156.95 -3,888.39 None 1.94 Cedar Rapids Bank&Trust 1.5 10/30/2019 1/30/2015 248,000.00 99.49 246,734.95 0.12% None 487 150517CJ7 248,000.00 1.50 248,000.00 1.89 295.56 -1,265.05 None 1.32 EVB Tappa Hannock VA 1.6 9/25/2019 9/25/2015 248,000.00 99.44 246,615.66 0.12% None 452 26927ABK7 248,000.00 1.60 248,000.00 2.06 1,054.51 -1,384.34 None 1.22 FAMC 1.82 11/9/2020 11/9/2017 1,000,000.00 98.08 980,835.00 0.5% Moodys-Aaa 863 3132X0ZC8 1,000,000.00 1.82 1,000,000.00 2.66 2,578.33 -19,165.00 S&P-AA+ 2.31 FFCB 1.84 10/30/2020-18 10/30/2017 1,000,000.00 97.87 978,698.00 0.5% Moodys-Aaa 122 3133EHM26 1,000,000.00 1.84 1,000,000.00 2.79 3,066.67 -21,302.00 S&P-AA+ 2.29 Prepared by Shamaira Jagrup 11 of 16 City of Pearland IntEr - Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity FHLB 2.2 1/29/2021-19 1/29/2018 1,000,000.00 98.71 987,094.00 0.5% Moodys-Aaa 213 3130ADC26 1,000,000.00 2.20 1,000,000.00 2.72 9,227.78 -12,906.00 S&P-AA+ 2.5 FHLMC 2 11/20/2020-18 12/5/2017 1,000,000.00 98.41 984,078.00 0.5% Moodys-Aaa 51 3134GBW32 1,000,000.00 2.00 1,000,000.00 2.69 2,222.22 -15,922.00 S&P-AA+ 2.34 FHLMC 2.2 12/8/2021-18 12/8/2017 1,000,000.00 97.97 979,658.00 0.5% Moodys-Aaa 70 3134GB4N9 1,000,000.00 2.20 1,000,000.00 2.63 1,344.44 -20,342.00 S&P-AA+ 3.33 First Financial NW 1.35 10/30/2019 10/30/2015 248,000.00 98.46 244,169.39 0.12% None 487 32022MAF5 248,000.00 1.35 248,000.00 2.53 0.00 -3,830.61 None 1.32 FNMA 1.375 3/13/2019-16 9/22/2016 1,009,560.00 99.36 993,630.00 0.5% Moodys-Aaa 256 3136G1FY0 1,000,000.00 0.98 1,002,714.57 2.29 4,086.81 -9,084.57 S&P-AA+ 0.7 Pacific Continental Bank 1.25 6/30/2020 6/30/2016 248,000.00 97.17 240,985.07 0.12% None 731 69413CFD6 248,000.00 1.25 248,000.00 2.70 0.00 -7,014.93 None 1.98 Texas Class LGIP 12/20/2016 23,101,754.52 100.00 23,101,754.52 11.44% None 1 TX-01-0615-0001 23,101,754.52 2.16 23,101,754.52 2.16 0.00 None 0 Welch State Bank 1.3 10/1/2018 9/30/2015 248,000.00 99.93 247,814.25 0.12% None 93 949095AU7 248,000.00 1.30 248,000.00 1.60 256.15 -185.75 None 0.25 Wells Fargo Sweep Cash 5/31/2006 7,489,866.12 100.00 7,489,866.12 3.71% None 1 WFSWEEP 7,489,866.12 1.79 7,489,866.12 1.79 0.00 None 0 Wells Fargo TWDB Cash 5/15/2018 8,467,939.00 100.00 8,467,939.00 4.19% None 1 WF6624 8,467,939.00 1.79 8,467,939.00 1.79 0.00 None 0 Wells Fargo TWDB Cash 3/15/2017 11,853,145.17 100.00 11,853,145.17 5.87% None 1 WF5883 11,853,145.17 1.79 11,853,145.17 1.79 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 3,886,739.08 100.00 3,886,739.08 1.93% None 1 WF4102 3,886,739.08 1.79 3,886,739.08 1.79 0.00 None 0 Wells Fargo TWDB Cash 11/1/2016 81,192.71 100.00 81,192.71 0.04% None 1 WF4094 81,192.71 1.79 81,192.71 1.79 0.00 None 0 Prepared by Shamaira Jagrup 12 of 16 °'�� City of Pearland �o &MAKI 9 Portfolio Holdings by Portfolio Name ``' 00.' Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount I CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity 62,626,196.60 62,499,002.51 31.02% 40 Sub Total 550:W/S Impact Fee 62,616,636.60 1.92 62,619,351.17 2.02 24,564.60 -120,348.66 0.25 555:Shadow Creek Impact FAMC 1.675 2/24/2020 2/24/2017 1,001,200.00 98.60 985,958.00 0.5% Moodys-Aaa 604 3132X0PW5 1,000,000.00 1.63 1,000,660.00 2.55 5,862.50 -14,702.00 S&P-AA+ 1.62 Wells Fargo Sweep Cash 5/31/2006 500,021.91 100.00 500,021.91 0.25% None 1 WFSWEEP 500,021.91 1.79 500,021.91 1.79 0.00 None 0 1,501,221.91 1,485,979.91 0.75% 403 Sub Total 555:Shadow Creek Impact 1,500,021.91 1.68 1,500,681.91 2.29 5,862.50 -14,702.00 1.08 565: Revenue Bonds 1999&2003 FAMC 1.5 8/22/2019 2/22/2017 1,000,000.00 98.95 989,471.00 0.5% S&P-AA+ 418 3132X0PV7 1,000,000.00 1.50 1,000,000.00 2.44 5,333.33 -10,529.00 Moodys-Aaa 1.13 GNB Bank 1.5 6/30/2021 6/30/2016 248,000.00 95.98 238,024.45 0.12% None 1096 36198JCC6 248,000.00 1.50 248,000.00 2.90 0.00 -9,975.55 None 2.93 Signature Bank 1.35 3/28/2019 9/29/2015 248,000.00 99.71 247,283.78 0.12% None 271 82669LFU2 248,000.00 1.35 248,000.00 1.74 18.35 -716.22 None 0.74 Texas Class LGIP 1/15/2017 1,020,927.41 100.00 1,020,927.41 0.51% None 1 TX-01-0615-0001 1,020,927.41 2.16 1,020,927.41 2.16 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 2,585,561.29 100.00 2,585,561.29 1.28% None 1 WFSWEEP 2,585,561.29 1.79 2,585,561.29 1.79 0.00 None 0 Wells Fargo TWDB Cash 9/15/2017 10,078,869.98 100.00 10,078,869.98 4.99% None 1 WF5875 10,078,869.98 1.79 10,078,869.98 1.79 0.00 None 0 15,181,358.68 15,160,137.91 7.52% 51 Sub Total 565:Revenue Bonds 1999& 15,181,358.68 1.78 15,181,358.68 1.87 5,351.68 -21,220.77 0.13 2003 570:W/S Pay As You Go Marine Bank Springfield IL 1.8 6/29/2021 6/29/2017 248,000.00 96.70 239,827.41 0.12% None 1095 56817TAB7 248,000.00 1.80 248,000.00 2.95 12.23 -8,172.59 None 2.92 Prepared by Shamaira Jagrup 13 of 16 City of Pearland 9 Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 12/31/2007 2,616,513.09 100.00 2,616,513.09 1.3% None 1 WFSWEEP 2,616,513.09 1.79 2,616,513.09 1.79 0.00 None 0 2,864,513.09 2,856,340.50 1.42% 96 Sub Total 570:W/S Pay As You Go 2,864,513.09 1.79 2,864,513.09 1.89 12.23 -8,172.59 0.25 575:MUD 4 Capital Programs Wells Fargo Sweep Cash 2/1/2013 24,789.07 100.00 24,789.07 0.01% None 1 WFSWEEP 24,789.07 1.79 24,789.07 1.79 0.00 None 0 24,789.07 24,789.07 0.01% 1 Sub Total 575:MUD 4 Capital Programs 24,789.07 1.79 24,789.07 1.79 0.00 0 600:Water&Sewer BARCLAYS BANK DELAWARE 1.95 5/6/2014 248,000.00 99.72 247,300.64 0.12% None 311 5/7/2019 06740KGU5 248,000.00 1.95 248,000.00 2.29 715.46 -699.36 None 0.85 CDARS 1.05 6/15/2019 6/15/2017 500,000.00 100.00 500,000.00 0.25% None 350 CDARS061517 500,000.00 1.05 500,000.00 1.05 2,603.42 0.00 None 0.95 Eaglebank Bethesda 1.15 12/10/2018 3/9/2016 248,000.00 99.70 247,261.46 0.12% None 163 27002YCV6 248,000.00 1.15 248,000.00 1.82 164.09 -738.54 None 0.44 FAMC 1.5 8/22/2019 2/22/2017 2,001,700.00 98.95 1,978,942.00 0.99% S&P-AA+ 418 3132X0PV7 2,000,000.00 1.47 2,000,778.22 2.44 10,666.67 -21,836.22 Moodys-Aaa 1.13 FAMC 1.72 10/3/2018 12/16/2013 997,890.00 99.95 999,499.00 0.5% Moodys-Aaa 95 31315P5A3 1,000,000.00 1.77 999,886.38 1.91 4,156.67 -387.38 S&P-AA+ 0.26 FFCB 1.95 9/17/2018 1/29/2014 1,014,770.00 100.00 1,000,037.00 0.5% Moodys-Aaa 79 3133ED2C5 1,000,000.00 1.62 1,000,681.83 1.92 5,579.17 -644.83 S&P-AA+ 0.21 FHLB 1.75 12/14/2018 12/16/2013 1,000,670.00 99.80 997,962.00 0.5% Moodys-Aaa 167 313376BR5 1,000,000.00 1.74 1,000,061.11 2.20 777.78 -2,099.11 S&P-AA+ 0.46 First Bank McComb MS 1.5 2/28/2019 6/30/2015 248,000.00 99.62 247,052.14 0.12% None 243 319234AJ9 248,000.00 1.50 248,000.00 2.08 20.38 -947.86 None 0.66 Prepared by Shamaira Jagrup 14 of 16 City of Pearland (v6HRl Ag Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2018 Description Face Amount I Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity First Eagle National Bank 1.45 11/21/2018 11/21/2014 248,000.00 99.83 247,570.22 0.12% None 144 32008JAM5 248,000.00 1.45 248,000.00 1.89 394.08 -429.78 None 0.39 FNMA 1.625 11/27/2018 7/16/2014 1,004,411.00 99.80 998,030.00 0.5% Moodys-Aaa 150 3135G0YT4 1,000,000.00 1.52 1,000,412.74 2.11 1,489.58 -2,382.74 S&P-AA+ 0.41 MB Financial Bank 1.1 3/18/2019 3/18/2016 248,000.00 99.45 246,641.70 0.12% None 261 55266CQU3 248,000.00 1.10 248,000.00 1.87 89.69 -1,358.30 None 0.71 Northern Bank&Trust MA 1.1 7/12/2019-17 7/12/2016 248,000.00 98.77 244,943.65 0.12% None 12 66476QBH0 248,000.00 1.10 248,000.00 2.31 590.44 -3,056.35 None 1.03 Northwest Bank Boise Idaho 1.5 1/10/2019 4/10/2014 248,000.00 99.87 247,686.78 0.12% None 194 66736AAD1 248,000.00 1.50 248,000.00 1.74 203.84 -313.22 None 0.53 Parkside Finl Bank&Trust 1.3 7/19/2021-17 7/18/2016 248,000.00 95.62 237,142.56 0.12% None 18 70147ABX1 248,000.00 1.30 248,000.00 2.80 105.99 -10,857.44 None 2.99 Portage County Bank 1.4 6/24/2021 6/24/2016 248,000.00 96.00 238,082.73 0.12% None 1090 73565NBQ5 248,000.00 1.40 248,000.00 2.80 57.07 -9,917.27 None 2.92 Texas Class LGIP 12/20/2016 3,583,766.58 100.00 3,583,766.58 1.78% None 1 TX-01-0615-0001 3,583,766.58 2.16 3,583,766.58 2.16 0.00 None 0 Wells Fargo Sweep Cash 5/31/2006 19,801,087.03 100.00 19,801,087.03 9.81% None 1 WFSWEEP 19,801,087.03 1.79 19,801,087.03 1.79 0.00 None 0 32,136,294.61 32,063,005.49 15.91% 66 Sub Total 600:Water&Sewer 32,116,853.61 1.75 32,118,673.89 1.92 27,614.33 -55,668.40 0.21 610:Solldwaste Wells Fargo Sweep Cash 12/1/2006 -1,142,160.74 100.00 -1,142,160.74 -0.57% None 1 WFSWEEP -1,142,160.74 1.79 -1,142,160.74 1.79 0.00 None 0 -1,142,160.74 -1,142,160.74 -0.57% 1 Sub Total 610:Solidwaste -1,142,160.74 1.79 -1,142,160.74 1.79 0.00 0 700:Property Liability Ins Prepared by Shamaira Jagrup 15 of 16 City of Pearland Portfolio Holdings by Portfolio Name Report Group: Pearland Date:6/30/2018 Description Settlement Date Cost Value Market Price Market Value %Portfolio Credit Rating Days To Call/Maturity Face Amount/ CUSIP Shares YTM @ Cost Book Value YTM @ Market Accrued Interest Unre.Gain/Loss Credit Rating Duration To Maturity Wells Fargo Sweep Cash 10/31/2006 485,187.82 100.00 485,187.82 0.24% None 1 WFSWEEP 485,187.82 1.79 485,187.82 1.79 0.00 None 0 485,187.82 485,187.82 0.24% 1 Sub Total 700:Property Liability Ins 485,187.82 1.79 485,187.82 1.79 0.00 0 701: Employee Benefit Fund Wells Fargo Sweep Cash 9/1/2007 142,864.69 100.00 142,864.69 0.07% None 1 WFSWEEP 142,864.69 1.79 142,864.69 1.79 0.00 None 0 142,864.69 142,864.69 0.07% 1 Sub Total 701 Employee Benefit Fund 142,864.69 1.79 142,864.69 1.79 0.00 0 702:Health Claims Fund Wells Fargo Cash 7/21/2010 393,667.82 100.00 393,667.82 0.2% None 1 WF9871 393,667.82 0.75 393,667.82 0.75 0.00 None 0 Wells Fargo Sweep Cash 9/15/2010 2,802,708.87 100.00 2,802,708.87 1.39% None 1 WFSWEEP 2,802,708.87 1.79 2,802,708.87 1.79 0.00 None 0 3,196,376.69 3,196,376.69 1.59% 1 Sub Total 702:Health Claims Fund 3,196,376.69 1.66 3,196,376.69 1.66 0.00 0 201,887,489.46 201,234,869.24 100.00% 92 TOTAL PORTFOLIO 201,853,470.46 1.84 201,858,066.60 2.02 132,984.26 -623,197.36 0.34 Prepared by Shamaira Jagrup 16 of 16 , ,<<o City of Pearland Treasury Yield Curve Treasury 3/31/2018 6/30/2018 1 Month 1.64 1.81 3 Month 1.73 1.94 6 Month 1.92 2.11 1 Year 2.06 2.33 2 Year 2.28 2.53 3 Year 2.42 2.65 5 Year 2.63 2.78 10 Year 2.84 2.92 3.00 2.50 2.00 1.50 •3/31/2018 •6/30/2018 1.00 0.50 0.00 1 Month 3 Month 6 Month 1 Year 2 Year 3 Year 5 Year 10 Year Prepared by Shamaira Jagrup 1 of 1 Pledged Collateral Reconciliation Report June 30, 2018 Bank Account Number Account Name Amount Wells Fargo 8071613395 Credit Card Account - Wells Fargo 13042841 Sweep Account 134,473.00 * Wells Fargo 7169195455 False Alarm Reduction Program 284,014.87 Wells Fargo 8184567843 Alvin ISD 8,740,342.39 Wells Fargo 1790121790 EMS Payments - Wells Fargo 2807409871 Health Claims 393,667.82 Wells Fargo 3542574094 Escrow W&S Revenue Bonds, Series 2016B - * Wells Fargo 3542574102 Escrow W&S Revenue Bonds, Series 2016C - * Wells Fargo 4827855883 Texas Permanent W&S System Revenue 2017B - * Wells Fargo 4827855875 Texas Permanent W&S System Revenue 2017A - * Wells Fargo 1382256624 Escrow W&S Revenue Bonds, Series 2018A - * Total of Bank Balances $ 9,552,498.08 Pledged Collateral for City 30,206,782.22 FDIC Insurance 500,000.00 $ 30,706,782.22 Over(Under)Collateralized $ 21,154,284.14 Total%Collateralized 321.5% Bank Account Number Account Name Amount Wells Fargo 1007284258 Development Authority 967,110.07 Total of Bank Balances $ 967,110.07 Pledged Collateral for DAP 771,159.22 FDIC Insurance 250,000.00 $ 1,021,159.22 Over(Under)Collateralized $ 54,049.15 Total%Collateralized 105.6% Total%Collateralized 301.6% Status Collateralized * Accounts are sweeping to a higher yielding money market fund which does not require collateral.