Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R-2014-105 2014-08-25
RESOLUTION NO. R2014-105 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending June 2014. 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 2014. PASSED, APPROVED, AND ADOPTED this 25th day of August, A.D., 2014. ATTEST: 6?;NGL FiNG, T Y SE ETARY APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY TOM REID MAYOR City of Pearland Quarterly Investment Report March 31, 2013 - June 30, 2014 Resolution No. R2014-105 Exhibit "A" Portfolio at March 31, 2014 Ending Book Value Ending Market Value Accrued Interest Receivable FYD Total Interest Earned Unrealized Gain/(loss) Change in Unrealized Gain/Loss Weighted Average Maturity Change in Market Value Yield to Maturity at Cost T -Bill Benchmark Agency Note Benchmark $ 94,239,638.71 94,233,382.16 51,383.56 144,271.57 (6,256.55) 36,492.21 264 Days 4,911,400.15 0.37% 0.13% 0.11% Portfolio at June 30, 2014 Ending Book Value Ending Market Value Accrued Interest Receivable FYD Total Interest Earned Unrealized Gain/(loss) Change in Unrealized Gain/Loss Weighted Average Maturity Change in Market Value Yield to Maturity at Cost T -Bill Benchmark Agency Note Benchmark Average for Quarter City's Yield to Maturity 1 Year T -Bill Benchmark Yield Agency Note Benchmark Yield 0.44% 0.11% 0.13% $ 85,261,338.95 85,319,403.10 50,232.95 240,985.21 58,064.15 64,320.70 377 Days (8,913,979.06) 0.48% 0.11% 0.14% This quarterly report is In compliance with the Investment policy and strategy as established by the City and the Public Funds Investment Act (Chapter 2256, Texas Government Code). Prepared by: N.Q.L.:o L)Gii.i.12,L__ Claire Bogard Director of Finance Rick 0suaar Fatima Uwakwe Assistant Directbr of Finance Accounting Supervisor Summary by Type June 30, 2014 Description Face Amount \ Shares Cost Value Book Value Market Value YTM @ Cost Days To Maturity Cash $ 47,847,407.97 $ 47,847,407.97 $ 47,847,407.97 $ 47,847,407.97 0.14% 1 CD 15,880,420 54 15,880,420.54 15,880,420.54 15,884,698.86 0.74% 694 MM 35,101.25 35,101.25 35,101.25 35,101.25 0.04% 1 FAMC 1,000,000.00 997,890.00 998,127.02 1,004,940.00 1.17% 1,556 FFCB 5,000,000.00 5,018,623.48 5,016,900.41 5,038,648.00 0.98% 937 FHLB 3,000,000.00 3,016,920.00 3,003,419.71 3,014,652.00 1.05% 924 FHLMC 8,000,000.00 7,994,211.00 7,994,623.71 8,011,285.00 1.09% 979 FNMA 4,509,000.00 4,501,125.88 4,485,338.34 4,482,670.02 0.90% 944 Total/Average $ 85,271,929.76 $ 85,291,700.12 $ 85,261,338.95 $ 85,319,403.10 0.48% 377 Group Portfolio Holdings by Type FHLB 4% FFCB 6% FAMC 1% MM 0% FHLMC FNMA 5% 19% Cash 56% 60,000,000 50,000,000 40,000,000 30,000,000 20,000,000 • 10,000,000 Book Value by Maturity <3year 1, year 2,3veal 3.4 Br 4 - S 'CDT Interest Rates Date Imo 3 mo 6 mo IO yr 20 yr 30 yr 03/31/2014 0.03 0.05 0.07 0.13 0.44 0.90 1.73 2.30 2.73 3.31 3.56 06/30/2014 0.02 0.04 0.07 0.11 0.47 0.88 1.62 2.13 2.53 3.08 3.34 4.00 i 3.50 3.00 Yield Curve Comparison 2.00 1.50 1.00 0.50 - 0.00+- 0.60% 0.50% 0.40% 0.30% 0.20% 0.10% 1 mo 3 mo 6 mo 1 yr 2yr Syr 5yr Tyr —+-03/31/2014 --06/30/2014 Portfolio vs. Benchmarks 10 yr 20yr 30 yr 0.00% Jul -13 Aug -13 Sep -13 Oct -13 Nov -13 Dec -13 Jan -14 Feb -14 Mar -14 Apr -14 May -14 Jun -14 --4—Port Total '--1 Yr T -Bi l Agency Note City of Pearland Quarterly Investment Report Report Format: By CUSIP Group By: Security Type Portfolio/Report Group: Report Group: Pearland Begin Date: 3/31/2014, End Date: 6/30/2014 Ending Portfolio YTM 0 Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV CASH Wells Fargo WFSWEEP 10: General 0.140 N/A 16,656,356.85 5,020.99 6,355,650.92 0.00 0.00 10,305,726.92 5,020.99 Sweep Cash Fund Wens Fargo 17: Municipal Sweep Cash WFSWEEP Court 0.140 N/A 124,014.47 44.48 3,370.69 0.00 0.00 120,688.26 44.48 Security Wens Fargo 18: City Sweep Cash WFSWEEP Wide 0.140 N/A 69,365.50 23.06 10,518.28 0.00 0.00 58,870.28 23.06 Donation Wets Fargo WFSWEEP 19: Court 0.140 N/A 170,948.26 4,256.37 128,153.21 0.00 0.00 47,051.42 26.72 Sweep Cash Technoiogy Welk Fargo WFSWEEP 20: Debt0.140 N/A 10,517,075.87 980,294.20 4,229,564.03 0.00 0.00 7,267,806.04 3,032.93 Sweep Cash Services Wens Fargo 23: Court Sweep Cash WFSWEEP Juvenlie 0.140 N/A 59,287.89 368.39 2,770.36 0.00 0.00 56,885.92 21.13 Mgmt Wells Fargo WFSWEEP 30: Water& 0.140 N/A 8,423,937.90 1,567,713.41 587,776.68 0.00 0.00 9,403,874.63 3,321.47 Sweep Cash Sewer Wells Fargo WFSWEEP 31: 0.140 N/A 426,583.56 88,001.65 68,552.28 0.00 0.00 446,032.93 225.11 Sweep Cash Solldwaste Wells Fargo WFSWEEP 35: Street 0.140 N/A 428,368.13 467.07 2,498.28 0.00 0.00 426,336.92 99.25 Sweep Cash Assessment Wells Fargo WFSWEEP 42: Utility 0.140 N/A 4,842,683.19 416,946.71 1,300,323.86 0.00 0.00 3,959,306.04 1,406.89 Sweep Cash Impact Fee Wells Fargo 44: Shadow Sweep Cash WFSWEEP Creek 0.140 N/A 1,941,313.76 68,633.04 817,646.88 0.00 0.00 1,192,099.92 610.19 Impact Wells Fargo 45: Sweep Cash WFSWEEP HoteVMotel 0.140 N/A 779,286.71 205,454.42 41,756.67 0.00 0.00 942,984.26 340.19 Occupancy Wens Fargo WFSWEEP 46: Park 0.140 N/A 90,986.65 26,925 04 0.00 0.00 0.00 117,911.69 40.49 Sweep Cash Donations Wells Fargo 47: Park & Sweep Cash WFSWEEP ReC 0.140 N/A 779,501.32 1,566.21 0.00 0.00 0.00 781,067.53 284.92 1 of 11 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV Devebpment Wells Fargo WFSWEEP 49: Tree 0.140 N/A 69,935.33 25.39 678.29 0.00 0.00 69,282.43 25.39 Sweep Cash Trust Fund Wells Fargo 50: Capital 0.140 N/A 1,733,536.55 375,846.91 44,716.00 0.00 0.00 2,064,667.46 733.60 Sweep Cash ProJect5 Wells Fargo 55: Sidewalk WFSWEEP 0.140 N/A 225,960.93 33,484.69 0.00 0.00 0.00 259,445.62 94.69 Sweep Cash Fund 60: Potce Weis Fargo Sweep Cash WFSWEEP State 0.140 N/A 211,642.77 70.83 45,416.71 0.00 0.00 166,296.89 70.83 Seizure Welts Fargo WFSWEEP 62: Federal 0.140 N/A 51,518.11 7,081.13 0.00 0.00 0.00 58,599.24 28.40 Sweep Cash Police Fund Wells Fargo 64: 1998 Sweep Cash WFSWEEP Cert of 0.140 N/A 455,325.48 510 15 0.00 0.00 0.00 455,835.63 166.34 Obligation Wells Fargo 67: 2003 Sweep Cash WFSWEEP Revenue 0.140 N/A 2,060,166.01 443.54 1,120,506.92 0.00 0.00 940,102.63 443.54 Bonds Welk Fargo 68: 2001 Sweep Cash WFSWEEP Cert of 0.140 N/A -268,469.81 556,342.31 618,459.50 0.00 0.00 -330,587.00 0.00 Obligation Wells Fargo 70: 2005 Sweep Cash WFSWEEP Refunding / 0.140 N/A 213,919.36 61.59 131,702.22 0.00 0.00 82,278.73 61.59 Mobility Welk Fargo 95: Property WFSWEEP 0.140 N/A 261,171.69 59,240.26 330,556.72 0.00 0.00 -10,144.77 72.79 Sweep Cash tiabliity Welk Fargo 97' Sweep Cash WFSWEEP Employee 0.140 N/A 87,930.62 29,019.54 32,910.59 0.00 0.00 84,039.57 36.21 Benefd Trust 99: COP Caslh Fargo WF9871 Health 0.140 N/A 334,761.63 32,996 07 144,455.69 0.00 0.00 223,302.01 92.08 Claims Fund Wells Fargo 99: COP Sweep Cash WFSWEEP Health 0.140 N/A -224,241.26 724,698.88 827,090.76 0.00 0.00 -326,633.14 0.00 Claims Fund Welk Fargo WFSWEEP 2101: Grant 0.140 N/A 30,411.45 11,120.53 81,068.80 0.00 0.00 -39,536.82 7.53 Sweep Cash Fund Welk Fargo WFSWEEP Z109: 2011 0.140 N/A -161.41 322.82 322.82 0.00 0.00 -161.41 0.00 Sweep Cash CDBG Fund 2 of 11 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Tkker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV Wells Fargo WFSWEEP 2110: 2012 0.140 N/A 20,646.37 0.00 20,441.82 0.00 0.00 204.55 0.00 Sweep Cash COBG Fund Welts Fargo WFSWEEP 2140: U of H 0.140 N/A 22,150.74 10,105.41 77,966.89 0.00 0.00 -45,710.74 3.69 Sweep Cash Fund Z141: U of H Wells Fargo WFSWEEP Capital 0.140 N/A 239,950.23 87.62 0.00 0.00 0.00 240,037.85 87.62 Sweep Cash Renewal Fund Wells Fargo 2145: Sweep Cash WFSWEEP Municipal 0.140 N/A 317,901.99 40,574.91 3,704.68 0.00 0.00 354,772.22 125.57 Channel Wells Fargo Z200: 2006 Sweep Cash WFSWEEP Cert of 0.140 N/A 1,961,064.64 251,098.87 324,796.13 0.00 0.00 1,887,367.38 446.74 Obligation Wells Fargo Z201: 2007 Sweep Cash WFSWEEP Cert of 0.140 N/A 56,263.11 1,215.86 0.00 0.00 0.00 57,478.97 20.96 Obligation Wells Fargo 2202: Sweep Cash WFSWEEP 2007A Gen 0.140 N/A 1,333,571.53 435.31 400,725.43 0.00 0.00 933,281.41 435.31 Obligation Wells Fargo Z203: 2009 Sweep Cash WFSWEEP Gen 0.140 N/A 5,052,251.62 1,304.75 2,164,713.88 0.00 0.00 2,888,842.49 1,304.75 Obligation Wells Fargo Z301: W/S Sweep Cash WFSWEEP Pay As U Go 0.140 N/A 2,091,265.30 755.09 30,161.92 0.00 0.00 2,061,858.47 755.09 CIP Wells Fargo Z302: MUD Sweep Cash WFSWEEP 4 Capital 0.140 N/A 670,241.58 240.64 24,636.68 0.00 0.00 645,845.54 240.64 Programs Sub Total/Average 0.140 62,318,424.62 5,502,798.14 19,973,814.79 0.00 0.00 47,847,407.97 19,743.18 Cash CERTIFICATE OF DEPOSIT CDARS 0.5 12/18/2014 CDARS 0.9 6/16/2016 Community National Bank Interest 1.25 4/4/2018 1016130741 1016754591 20375WAM6 10: General Fund 10: General Fund 10: General Fund 0.500 12/18/2014 500,000.00 0.00 0.00 0.00 0.00 500,000.00 623.29 0.900 6/16/2016 0.00 500,000.00 0.00 0.00 0.00 500,000.00 135.62 1.250 4/4/2018 0.00 248,000.00 0.00 0.00 0.00 248,000.00 738.90 3 of 11 Ending Portfolio YTM et Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV Farmers & Merchants Bank 1.45 9/25/2018-14 308862000 10: General 1.450 9/25/2018 Fund 0.00 248,000.00 0.00 0.00 0.00 248,000.00 650.23 FIRST BANK HIGHLAND 319141BL0 10: General 1.850 5/7/2019 0.00 248,000.00 0 00 0.00 0.00 248,000.00 678.77 PARK 1.85 Fund 5/7/2019-14 1st United Bank 10: General FL0.7 33741TAU5 0.700 5/9/2016 248,000.00 0 00 0.'.0 0 00 0.00 248,000.00 432.80 5/9/2016 Fund Moody National 10: General Bank 0.5 7130 Fund 0.500 11/30/2014 0.00 247,420.54 0.00 0 00 0 00 247,420.54 105.07 11/30/2014 Synovus Bank 10: General GA 0.5 87164DBV1 Fund 0.500 11/28/2014 248,000.00 0.00 0.00 0.00 0 00 248,000.00 309.15 11/28/2014 Townebank 10: General Portsmouth VA 89214PAP4 Fund 0.400 6/1/2015 248,000.00 0.00 0.00 0,00 0.00 248,000.00 247.32 0.4 6/1/2015 Trust Atlantic 10: General Bank 1.45 89835F105 Fund 1.450 12/6/2017 248,000.00 0.00 000 0.00 0.00 248,000 00 896.53 12/6/2017 CDARS 0.6 CD1013981872 10: General 6/19/2014 500,000.00 0.00 500,000.00 0.00 0.00 0.00 651.20 6/19/2014 Fund Cardinal Bank CD14147VDM5 10: General 0.500 5/17/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 309.14 0.5 5/17/2016 Fund Discover Bank CO254671KH2 10: General 0.500 2/20/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 309.15 0.5 2/20/2015 Fund First National 10: General Bank 1.6 CD3211SCBE7 Fund 1.600 3/19/2018 248,000.00 0.00 0.0(i 0.o0 0.00 248,000.00 989.29 3/19/2018 Mtzuho Bank CD60688TLM9 10: General 5/8/2014 248,000.00 0.00 248,000.00 0.00 0.00 0.00 on 55 0.25 5/8/2014 Fund Moody National 10: General Bank 0.5 CD7130A Fund 5/30/2014 246,807.96 0.00 246,807.96 0.00 0 00 0.00 203.49 5/30/2014 Plus international CD72940UFV2 10: General 0.500 7/8/2016 248,000.00 Bank 0.5 Fund 7/8/2016 4of11 0.00 0 00 0 00 0 00 248,000.00 309.14 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV Southwest Bank Ft Worth 0.3 2/27/2015 Valley Bank Roanoke 0.3 7/30/2014 ConnectOne Bank 1.55 7/30/2018 Webster Bank NA 1.9 2/12/2019 Key Bank Ohio 0.35 8/27/2014 CD844772AA1 10: General 0.300 2/27/2015 248,000.00 Fund CD91935VANO 10: General 0.300 7/30/2014 248,000.00 Fund 20786AAM7 20: Debt 1.550 7/30/2018 248,000.00 Services 94768N3M7 20: Debt 1.900 2/12/2019 248,000.00 Services CD49306SRE8 20: Debt 0.350 8/27/2014 248,000.00 Services Mechanics Savings Bank CD583686BC3 20: Debt 0.350 3/20/2015 248,000.00 0.35 Services 3/20/2015 BARCLAYS BANK 06740KGU5 30: Water& 1.950 5/7/2019 DELAWARE Sewer 1.95 5/7/2019 CDARS 0.6 1016754575 30: Water & 0.600 6/18/2015 6/18/2015 Sewer Northwest Bank 30: Water & Boise Idaho 1.5 66736AAD1 Sewer 1.500 1/10/2019 1/10/2019 OLDTOWN 30: Water& BANK 1.2 680540886 Sewer 1.200 5/7/2018 5/7/2018 Bay Cities Bank 30: Water & 0.5 CD07203QBR2 Sewer 0.500 12/12/2014 12/12/2014 CDARS 0.5 CD1013981856B 30: Water & 6/19/2014 6/19/2014 Sewer First Farmers Bank 0.5 5/3/2016 Fox Chase Bank 0.65 6/27/2016 CD320165FZ1 CD35137QAN4 30: water & 0.500 5/3/2016 Sewer 30: Water B 0.650 6/27/2016 Sewer 0.00 0.00 0.00 0.00 248,000.00 185.50 0.00 0.00 0.00 0.00 248,000.00 185.49 0.00 0.00 0.00 0.00 248,000.00 968.91 0.00 0.00 0.00 0.00 248,000.00 1,174.77 0.00 0.00 0.00 0.00 248,000.00 216.40 0.00 0.00 0.00 0.00 248,000.00 216.40 0.00 248,000.00 0.00 0.00 0.00 248,000.00 728.71 0.00 500,000.00 0.00 0.00 0.00 500,000.00 90.41 0.00 248,000.00 0.00 0.00 0.00 248,000.00 825.54 0.00 248,000 00 0.00 0.00 0.00 248,000.00 195.68 248,000.00 0.00 0.00 0.00 0.00 248,000.00 309.14 500,000.00 0.00 500,000 00 0.00 0.00 0.00 554.21 245,000.00 0.00 0.00 0.00 0.00 245,000.00 305.41 248,000 00 0.00 0.00 0.00 0.00 248,000.00 401.89 5 of 11 Ending Portfolio YTM Op Maturity Amortized Amortized Investment Description CUSIP/Tlcker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV Goldman Sachs 30: Water & Bank 0.6 CD381473AA0 Sewer 0.600 2/20/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 370.98 2/20/2015 SAFRA NATIONAL CD786580J50 30: Water & 5/5/2014 248,000.00 0.00 248,000.00 0.0!) 0.00 0.170 142.68 BANK 0.6 Sewer 5/5/2014 Fidelity Homestead 31: Savings Bank 31617CA05 Solidwaste 0.600 11/28/2016 248,000.00 000 0.00 0.00 0.00 248,000.00 370.98 New Orleans 0.6 11 United Bankers 35: Street Bank 0.75 909557CV0 Assessment 0.750 5/6/2016 248,000.00 0.00 (.00 0.00 0.00 248,000.00 463.72 5/6/2016 Far East National Bank 307327EK8 42: Utility 1.000 3/31/2017 240,000.00 0.00 0 00 0.00 0.00 248,000.00 618.31 Los Angeles 1 Impact Fee 3/31/2017 Hardin County 42: Utility Bank 0.25 411822BG3 Impact Fee 0.250 12/30/2014 248,000.00 0 00 0.00 0.00 0.00 248,000.00 154.58 12/30/2014 JP Morgan Chase Bank 42: Utility Columbus Ohio 48125T)W6 Impact Fee 0.850 3/31/2017 248,000.00 0 00 0 00 0.00 0 00 248,000.00 525.56 0.85 3/31/2017 - BMW Bank of 42: Utility NA 0.85 CD05568P2Q9 Impact Fee 0.850 6/8/2015 248,000.00 0 00 0 00 0.00 0.00 248,000.00 525.55 6/8/2015 College Savings 42: Utility Bank 0.55 CD19443PAP4 Impact Fee 0.550 6/20/2016 248,000.00 0 00 0 00 0 Oo 0 00 248,000.00 340.06 6/20/2016 Private Bank & 42: Utility Trust 0.35 CD74267GTC1 impact Fee 0.350 5/11/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 216.40 5/11/2015 Sterling Savings 42: Utility Bank 0.35 CD8595316A8 Impact Fee 0.350 2/23/2015 248,000.00 0.00 0 00 0.00 0.00 248,000.00 216.40 2/23/2015 The Independent CD88632YAG1 42: Utility 1.100 9/16/2016 248,000.00 0 00 0.00 0.00 0.00 248,000.00 680.13 Bank 1.1 Impact Fee 9/16/2016 6of11 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Tkker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV Bank of Buffalo 44: Shadow KY 0.35 060788AF3 Creek 0.350 6/22/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 211.64 6/22/2015 Impact GUARANTY B&T 44: Shadow 1.35 400820834 Creek 1.350 5/29/2018 0.00 248,000.00 0.00 0.00 0.00 248,000.00 293.52 5/29/2018 Impact Marlin Business 44: Shadow Bank 0.55 CD57116AGF9 Creek 0.550 6/14/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 340.07 6/14/2016 Impact First 45: Commercial 31984GCW7 HoteVMotel 0.400 6/26/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 247,31 Bank Miss 0.4 Occupancy 6/26/2015 Colonial Virginia 45: Bank 0.55 CD196121AM9 HoteVMotel 0.550 6/24/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 340.07 6/24/2016 Occupancy First State Bank 47: park & Un Cty Tenn 3364728)0 Rec 0.450 12/23/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 278.23 0.45 Development 12/23/2015 San Diego Private Bank 50: Capital 79744YAB6 0.800 3/31/2017 248,000.00 0.00 0.00 0.00 0.00 248,000.00 500.07 California 0.8 Projects 3/31/2017 US AmerlBank 64: 1998 Largo FL 0.55 917312CC2 Cert of 0.550 12/23/2015 248,000.00 0.00 0 00 0.00 0.00 248,000.00 340.07 12/23/2015 Obligation CALUSA 67: 2003 NATIONAL 13151TAX4 Revenue 0.500 9/22/2016 0.00 248,000 00 0.00 0.00 0.00 248,000.00 129.09 BANK 0.5 Bonds 9/22/2016 First National 67: 2003 Bank ORD NEB 32116RAC8 Revenue 0.800 11/18/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 494.64 0.8 Bonds 11/18/2016 Asheville 67: 2003 Savings Bank C00440711A70 Revenue 0.350 3/27/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 216.41 0.35 Bonds 3/27/2015 CIT Bank 1.5 67: 2003 9/5/2017 C017284CMN1 Revenue 1.500 9/5/2017 248,000.00 0.00 0.00 0.00 0.00 248,000.00 927.45 Bonds 1 �7 7of 11 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV Medallion Bank 67: 2003 UT 0.4 C05840313862 Revenue 0.400 11/3/2015 248,000.00 11/3/2015 Bonds First State Bank 70: 2005 - WV 0.35 CD33648FHR9 Refunding / 0.350 12/3/2014 248,000.00 12/3/2014 Mobility Celtic Bank 0.6 2202: 6/28/2016 CD15118RJDO 2007A Gen 0.600 6/28/2016 248,000.00 Obligation Flushing Bank Z203: 2009 New York 0.95 34387AAH2 Gen 0.950 3/31/2017 248,000.00 3/31/2017 Obligation Kansas State 2203: 2009 Bank 0.8 485382DV4 Gen 0.800 10/31/2016 248,000.00 10/31/2016 Obligation Merchant & 2203: 2009 Manufacturing 588339DD0 Gen 0.350 8/7/2015 248,000.00 Bank 0.35 Obligation 8/7/2015 Provident Bank 2203: 2009 0.35 743837BF2 Gen 0.350 8/21/2015 248,000.00 8/21/2015 Obligation Cathay Bank 2203: 2009 0.75 CD1491591E6 Gen 0.750 3/21/2016 248,000.00 3/21/2016 Obligatbn DeWitt Bank Z301: W/S and Trust 0.5 CD241888BT2 Pay As U Go 0.500 6/20/2016 248,000.00 6/20/2016 CIP Farrn Bureau Z302: MUD Bank 0.5 307660HH6 4 Capital 0.500 :2/23/2015 248,000.00 12/23/2015 Programs Pacific City Bank 2302: MUD 0.35 69405P8)7 4 Capital 0.350 6/26/2015 248,000.00 6/26/2015 Programs Sub Total/Average Certificate Of Deposit FAMC BOND FAMC 1.72 10/3/2018 31315P5A3 0.00 0.00 0.00 0.00 248,000.0D 247.31 0.00 0.00 0.00 0.00 248,000.00 216.40 0.00 0.00 0.00 0.00 248,000.00 370.98 0.00 0.00 0.00 0.00 248,000.00 490.56 0.00 0.00 0.00 0.00 248,000.00 500.07 0.00 0.00 0.00 0.00 248,000.00 216.41 0.00 0.00 0.00 0.00 248,000.00 216.40 0.00 0.00 0.00 0.00 248,000.00 463.73 0.00 0.00 0.00 0.00 248,000.00 309.14 0 00 0.00 0.00 0.00 248,000.00 309.14 0.00 0.00 0.00 0.00 248,000.00 216 40 0.743 14,391,807.96 3,231,420.54 1,742,807.96 30: Water& 1.766 10/3/2018 Sewer 998,018.29 8 of 11 0.00 0.00 15,880,420.54 26,512.56 0.00 0.00 108.73 0.00 998,127.02 4,360.96 Ending Portfolio YTM Cl) Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV Sub Total/Average 1.766 998,018.29 0.00 0.00 108.73 0.00 998,127.02 4,360.96 FAMC Bond FFCB BOND FFCB 0.3 7/18/2014 FFCB 1.34 12/29/2017 FFCB 0.25 12/24/2014 FFCB 1.95 9/17/2018 FFCB 1.5 1/28/2019 3133EAYL6 3133EDE99 3133ECAV6 3133ED2C5 3133EDNF6 10: General Fund 10: General Fund 20: Debt Services 30: Water& Sewer Z203: 2009 Gen Obligation 0.265 7/18/2014 1,000,044.42 0.00 0.00 0.00 -36.95 1,000,007.47 704.72 1.235 12/29/2017 1,003,824.11 0.00 0.00 0.00 -252.48 1,003,571.63 3,060.29 0.273 12/24/2014 999,831.31 0.00 0.00 57.09 0.00 999,888.40 675.15 1.617 9/17/2018 1,014,221.00 0.00 0.00 0.00 -788.09 1,013,432.91 4,032.75 1.500 1/28/2019 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 1,333.33 Sub Total/Average 0.984 4,017,920.84 1,000,000.00 0.00 57.09 -1,077.52 5,016,900.41 9,806.24 FFCB Bond FHLB BOND FHLB 2 2/27/2019-14 FHLB 1.1 4/17/2017-14 FHLB 1.15 10/30/2014 FHLB 1.75 12/14/2018 3130AOUNB 3130A1GP7 3133743W6 313376885 10: General Fund 10: General Fund 30: Water& Sewer 30: Water& Sewer 2/27/2019 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 3,111.11 1.100 4/17/2017 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 2,230.56 0.300 10/30/2014 1,004,914.98 0.00 0.00 0.00 -2,092.98 1,002,822.00 782.02 1.736 12/14/2018 1,000,630.87 0.00 0.00 0.00 -33.16 1,000,597.71 4,293.23 Sub Total/Average FHLB Bond FHLMC BOND FHLMC 0.375 4/28/2014 FHLMC 2 9/24/2016-14 313463567 3134G4FY9 FHLMC 0.35 3134G4Q1C7 12/31 12/31/2015-14 10: General Fund 10: General Fund 10: General Fund 1.042 3,005,545.85 1,000,000.00 1,000,000.00 0.00 -2,126.14 3,003,419.71 10,416.92 4/28/2014 999,931.69 0.00 1,000,000.00 68.31 0.00 0.00 349.56 2.000 9/24/2018 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 4,944.44 0.369 12/31/2015 999,671.88 0.00 0.00 46.87 0 00 999,718.75 921.87 9ofll \Z Ending Portfolio YTM c Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV FHLMC 1.85 3134G4QV3 20: Debt 1.850 12/27/2018 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 4,573.61 12/27/2018-14 Services FHLMC 0.5 3134G4FP8 30: Water & 0.500 8/28/2015 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,250.00 8/28/2015-14 Sewer FHLMC 1 3137EADL0 30: Water& 1.163 9/29/2017 994,424.77 0.00 0.00 394.43 0.00 994,819.20 2,866.65 9/29/2017 Sewer FHLMC 2.1 3134G52]3 42: Utility 4/24/2019 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 3,850.00 4/24/2019-14 Impact Fee FHLMC 0.4 45: 1/15/2016-14 3134G4533 HoteVMotel 0.400 1/15/2016 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 988.89 Occupancy FHLMC 0.35 12/5/2014 67: 2003 3134G3H78 Revenue 0.330 12/5/2014 1,000,135.01 Bonds 0.00 0.00 0.00 -49.25 1,000,085.76 816.03 Sub Total/Average 1.089 7,994,163.35 1,000,000.00 1,000,000.00 509.61 -49.25 7,994,623.71 20,561.05 FHLMC Bond FNMA BOND FNMA 0.875 12/20/2017 FNMA 0.35 8/25/2015 FNMA 0.875 10/26/2017 FNMA 1.3 12/17/2014 FNMA 0.875 5/21/2018 3135G0RT2 3135GOUW1 3135G0PQ0 3136FPWZ6 3135G0W.18 10: General Fund 10: General Fund 30: Water& Sewer 30: Water& Sewer 42: Utility Impact Fee Sub Total/Average FNMA Bond MONEY MARKET 1.087 12/20/2017 0.00 992,573.21 0.00 224.71 0.00 992,797.92 1,172.63 0.416 8/25/2015 508,531.39 0.00 0.00 82.75 0.00 508,614.14 528.12 1.019 10/26/2017 0.00 995,150.00 0.00 153.16 0.00 995,303.16 1,101.08 0.462 11/17/2014 1,005,226.41 0.00 0.00 0.00 -2,058.19 1,003,168.22 1,155.70 1.259 5/21/2018 0.00 985,050.00 0.00 404.90 0.00 985,454.90 1,352.82 0.892 1,513,757.80 2,972,773.21 0.00 865.52 -2,058.19 4,485,338.34 5,310.35 Wells Fargo WF5455 10: General 0.040 N/A 0.00 35,101.25 0.00 0.00 0.00 35,101.25 2.38 Bank MM Fund Sub Total/Average Money Market 0.040 0.00 35,101.25 10 of 11 0.00 0.00 0.00 35,101.25 2.38 t3 Ending Portfolio YTM 0 Maturity Amortized Amortized Investment Description CUSIP/Tkker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Inmme-BV Total / Average a 0.481 94,239,638.71 14,742,093.14 23,716,622.75 1,540.95 -5,311.10 85,261,338.95 96,713.64 11 of 11 { 4 City of Pearland City of Pearland - by Fund Report Format: By Transaction Group By: Portfolio Name Portfolio/Report Group: Report Group: Pearland As of 6/30/2014 Security Settlement Face YTM 0 Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio 10: General Fund Welts Fargo Sweep Cash WFSWEEP Cash 5/31/2006 10,305,726.92 10,305,726.92 10,305,726.92 0.140 N/A 1 12.09 CDARS 0.5 12/18/2014 1016130741 Certificate 12/19/2013 500,000.00 500,000.00 500,000.00 0.500 12/18/2014 171 0.59 Of Deposit Valey Bank Roanoke 0.3 CD9193SVANO Certificate 1/30/2013 248,000.00 248,000.00 248,016.37 0.300 7/30/2014 30 0.29 7/30/2014 Of Deposit Fest National Bank 1.6 CD32115CBE7 Certificate 9/18/2013 248,000.00 248,000.00 249,727.57 1.600 3/19/2018 1358 0.29 3/19/2018 Of Deposit 1st United Bank FL 0.7 33741TAU5 Certificate 11/8/2013 248,000.00 248,000.00 248,767.56 0.700 5/9/2016 679 0.29 5/9/2016 Of Deposit Trust Atlantic Bank 1.45 89835FJC5 Certificate 11/6/2013 248,000.00 248,000.00 249,512.06 1.450 12/6/2017 1255 0.29 12/6/2017 Of Deposit Farmers & Merchants Certificate Bank 1.45 308862DD0 Of Deposit 4/25/2014 248,000.00 248,000.00 248,608.59 1.450 9/25/2018 1548 0.29 9/25/2018-14 Moody National Bank 0.5 Certificate 7130 5/30/2014 247,420.54 247,420.54 247,420.54 0.500 11/30/2014 153 0.29 11/30/2014 Of Deposit Southwest Bank Ft CD844772AA1 Certificate 2/27/2013 248,000.00 248,000.00 248,226.92 0.300 2/27/2015 242 0.29 Worth 0.3 2/27/2015 Of Deposit Plus International Bank CD72940UFV2 Certificate 7/8/2013 248,000.00 248,000.00 248,133.92 0.500 7/8/2016 739 0.29 0.5 7/8/2016 Of Deposit Cardinal Bank 0.5 CD14147VDM5 Certificate 5/17/2013 248,000.00 248,000.00 248,341.25 0.500 5/17/2016 687 0.29 5/17/2016 Of Deposit Discover Bank 0.5 CD254671KH2 Certificate 2/20/2013 248,000.00 248,000.00 248,227.42 0.500 2/20/2015 235 0.29 2/20/2015 Of Deposit Synovus Bank GA 0.5 87164DBV1 Certificate 11/30/2012 248,000.00 248,000.00 248,493.52 0.500 11/28/2014 151 0.29 11/28/2014 Of Deposit CDARS 0.9 6/16/2016 1016754591 Certificate 6/19/2014 500,000.00 500,000.00 500,000.00 0.900 6/16/2016 717 0.59 Of Deposit Community National 20375WAM5 Deposit Of Certificate eposi 4/4/2014 248,000.00 248,000.00 247,412.49 1.250 4/4/2018 1374 0.29 Bank Interest 1.25 1 of 10 5- Security Settlement Face YTM @ Maturity Days To 0/0 of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio 4/4/2018 Townebank Portsmouth 89214PAP4 Certificate 5/31/2013 248,000.00 248,000.00 247,997.27 0.400 6/1/2015 336 0.29 VA 0.4 6/1/2015 Of Deposit FIRST BANK HIGHLAND 319141BL0 Certificate 5/7/2014 248,000.00 248,000.00 246,949.97 1.850 5/7/2019 1772 0.29 PARK 1.85 5/7/2019-14 0f Deposit FFCB 1.34 12/29/2017 3133EDE99 FFCB Bond 1/29/2014 1,000,000.00 1,003,571.63 1,011,343.00 1.235 12/29/2017 1278 1.18 FFCB 0.3 7/18/2014 3133EAYL6 FFCB Bond 8/1/2012 1,000,000.00 1,000,007.47 1,000,084.00 0.285 7/18/2014 18 1.17 FHLB 1.1 4/17/2017-14 3130A1GP7 FHLB Bond 4/17/2014 1,000,000.00 1,000,000.00 1,002,462.00 1.100 4/17/2017 1022 1.17 FHLMC 2 9/24/2018-14 3134G4FY9 FHLMC 9/24/2013 1,000,000.00 1,000,000.00 1,004,091.00 2.000 9/24/2018 1547 1.17 Bond FHLMC 0.35 3134G4QK7 FHLMC 12/31/2013 1,000,000.00 999,718.75 1,000,032.00 0.369 12/31/2015 549 1.17 12/31/2015-14 Bond FNMA 0.875 3135G0RT2 FNMA Bond 5/21/2014 1,000,000.00 992,797.92 992,481.00 1.087 12/20/2017 1269 1.16 12/20/2017 FNMA 0.35 8/25/2015 3135G0UW1 FNMA Bond 7/25/2013 509,000.00 508,614.14 509,821.02 0.416 8/25/2015 421 0.60 Wens Fargo Bank MM WF5455 Macket 6/15/2014 35,101.25 35,101.25 35,101.25 0.040 N/A 1 0.04 Sub Total / Average 21,321,248.71 21,316,958.62 21,336,977.64 0.533 421 25.00 17: Municipal Court Security Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 120,688.26 120,688.26 120,688.26 0.140 N/A 1 0.14 Sub Total / Average 120,688.26 120,688.26 120,688.26 0.140 1 0.14 18: City Wide Donation Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 58,870.28 58,870.28 58,870.28 0.140 N/A 1 0.07 Sub Total / Average 58,870.28 58,870.28 58,870.28 0.140 1 0.07 19: Court Tedrnology Welts Fargo Sweep Cash WFSWEEP Cash 5/31/2006 47,051.42 47,051.42 47,051.42 0.140 N/A 1 0.06 Sub Total / Average 47,051.42 47,051.42 47,051.42 0.140 1 0.06 20: Debt Services Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 7,267,806.04 7,267,806,04 7,267,806.04 0.140 N/A 1 8.52 2 of 10 16 Security Settlement Face YTM Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio ConnectOne Bank 1.55 20786AAM7 Certificate 1/30/2014 248,000.00 248,000.00 248,421.60 1.550 7/30/2018 1491 0.29 7/30/2018 Of Deposit Key Bank Ohio 0.35 CD49306SRE8 Certificate 2/27/2013 248,000.00 248,000.00 248,059.77 0.350 8/27/2014 58 0.29 8/27/2014 Of Deposit Webster Bank NA 1.9 94768NJM7 Certificate 2/12/2014 248,000.00 248,000.00 247,675.12 1.900 2/12/2019 1688 0.29 2/12/2019 Of Deposit Mechanics Savings Bank C0583686BC3 Certificate 3/20/2013 248,000.00 248,000.00 248,143.34 0.350 3/20/2015 263 0.29 0.35 3/20/2015 Of Deposit FFCB 0.25 12/24/2014 3133ECAV6 FFCB Bond 1/28/2013 1,000,000.00 999,888.40 1,000,618.00 0.273 12/24/2014 177 1.17 FHLMC 1.85 3134G4QV3 FHLMC 12/27/2013 1,000,000.00 1,000,000.00 1,003,055.00 1.850 12/27/2018 1641 1.17 12/27/2018-14 Bond Sub Total / Average 10,259,806.04 10,259,694.44 10,263,778.87 0.406 263 12.03 23: Court Juvenile Mgmt Weis Fargo Sweep Cash WFSWEEP Cash 9/15/2009 56,885.92 56,885.92 56,885.92 0.140 N/A 1 0.07 Sub Total / Average 56,885.92 56,885.92 56,885.92 0.140 1 0.07 30: Water & Sewer Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 9,403,874.63 9,403,874.63 9,403,874.63 0.140 N/A 1 11.03 Goldman Sachs Bank 0.6 CD38147JAAO Certificate 2/20/2013 248,000.00 248,000.00 248433.42 0.600 2/20/2015 235 0.29 2/20/2015 Of Deposit BARCLAYS BANK Certificate DELAWARE 1.95 06740KGU5 Of Deposit 5/6/2014 248,000.00 248,000.00 246,936.08 1.950 5/7/2019 1772 0.29 5/7/2019 OLDTOWN BANK 1.2 680540886 Certificate 6/6/2014 248,000.00 248,000.00 246,784.30 1.200 5/7/2018 1407 0.29 5/7/2018 Of Deposit Bay Cities Bank 0.5 C007203Q8R2 Certificate 12/12/2012 248,000.00 248,000.00 248,522.54 0.500 12/12/2014 165 0.29 12/12/2014 Of Deposit Fox Chase Bank 0.65 CD35137QAN4 Certificate 6/27/2013 248,000.00 248,000.00 248,202.12 0.650 6/27/2016 728 0.29 6/27/2016 Of Deposit CDARS 0.6 6/18/2015 1016754575 Certificate 6/19/2014 500,000.00 500,000.00 500,000.00 0.600 6/18/2015 353 0.59 Of Deposit First Farmers Bank 0.5 C0320165FZ1 Certificate 5/3/2013 245,000.00 245,000.00 245,095.80 0.500 5/3/2016 673 0.29 5/3/2016 Of Deposit Northwest Bank Boise 66736AA01 Certificate 4/10/2014 248,000.00 248,000.00 247,577.90 1.500 1/10/2019 1655 0.29 Idaho 1 5 1/10/2019 Of Deposit 3 of 10 Security Settlement Face Description CUSIP/Ticker Type Date Amount/Shares Book Value YTM Market Value Cost Maturity Days To % of Date Maturity Portfolio FAMC 1.72 10/3/2018 31315P5A3 FAMC Bond 12/16/2013 1,000,000.00 998,127.02 1,004,940.00 1.766 10/3/2018 1556 1.17 FFCB 1.95 9/17/2018 3133ED2C5 FFCB Bond 1/29/2014 1,000,000.00 1,013,432.91 1,028,243.00 1.617 9/17/2018 1540 1.19 FHLB 1.15 10/30/2014 3133743W8 FHLB Bond 11/29/2012 1,000,000.00 1,002,822.00 1,003,513.00 0.300 10/30/2014 122 1.18 FHLB 1.75 12/14/2018 313376BR5 FHLB Bond 12/16/2013 1,000,000.00 1,000,597.71 1,008,677.00 1.736 12/14/2018 1628 1.17 FHLMC 0.5 3134G4FPB FHLMC 8/28/2013 1,000,000.00 1,000,000.00 1,000,560.00 0.500 8/28/2015 424 1.17 8/28/ 8/28/2015-14 Bond FHLMC 1 9/29/2017 3137EAD10 FHLMC1/29/2014 1,000,000.00 994,819.20 997,938.00 1.163 9/29/2017 1187 1.17 FNMA 0.875 3135G0PQ0 FNMA Bond 5/21/2014 1,000,000.00 995,303.16 992,662.00 1.019 10/26/2017 1214 1.17 10/26/2017 FNMA 1.3 11/17/2014 3136FPWZ6 FNMA Bond 6/20/2012 1,000,000.00 1,003,168.22 1,004,490.00 0.462 11/17/2014 140 1.18 Sub Total / Average 31: Solidwaste 19,636,874.63 19,645,144.85 19,676,149.79 0.606 491 23.04 Wells Fargo Sweep Cash WFSWEEP Cash 12/1/2006 446,032.93 446,032.93 446,032.93 0.140 N/A 1 0.52 Fidelity Homestead Certificate Savings Bank New 31617CA05 Of Deposit 3/28/2014 248,000.00 248,000.00 247,690.99 0.600 11/28/2016 882 0.29 Orleans 0.6 11 Sub Total / Average 694,032.93 694,032.93 693,723.92 0.304 316 0.81 35: Street Assessment Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 426,336.92 426,336.92 426,336.92 0.140 N/A 1 0.50 United Bankers Bank 9Certificate 09557CV0 11/6/2013 248,000.00 248,000.00 248,816.91 0.750 5/6/2016 676 0.29 0.75 5/6/2016 Of Deposit Sub Total / Average 674,336.92 674,336.92 675,153.83 0.364 249 0.79 42: Utility Impad Fee Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 3,959,306.04 3,959,306.04 3,959,306.04 0.140 N/A 1 4.64 Hardin County Bank 0.25 411822BG3 Certificate 12/30/2013 248,000.00 248,000.00 247,865.83 0.250 12/30/2014 183 0.29 12/30/2014 Of Deposit Private Bank & Trust CD74267GTC1 Certificate 5/10/2013 248,000.00 248,000.00 248,055.30 0.350 5/11/2015 315 0.29 0.35 5/11/2015 OfDeposk Sterling Savings Bank CD8595316A8 Certificate 2/22/2013 248,000.00 248,000.00 248,227.42 0.350 2/23/2015 238 0.29 0.35 2/23/2015 Of Deposit 4of 10 lg Description CUSIP/Ticker Security Settlement Face Type Date YTM @ Maturity Days To % of Amount/Shares Book Value Market Value Cost Date Maturity Portfolio College Savings Bank 0.55 6/20/2016 The Independent Bank 1.1 9/16/2016 JP Morgan Chase Bank Columbus Ohio 0.85 3/31/2017 - Far East National Bank Los Angeles 1 3/31/2017 BMW Bank of NA 0.85 6/8/2015 FHLMC 2.1 4/24/2019-14 FNMA 0.875 5/21/2018 CD19443PAP4 CD88632YAG1 48125TJW6 307327EK8 CD05568P2Q9 3134G5233 3135GOWJ8 Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit FHLMC Bond 6/19/2013 9/18/2013 3/31/2014 3/31/2014 12/7/2012 4/24/2014 FNMA Bond 5/21/2014 248,000.00 248,000.00 248,218.98 0.550 6/20/2016 248,000.00 248,000.00 248,347.70 1.100 9/16/2016 248,000.00 248,000.00 247,454.65 0.850 3/31/2017 248,000.00 248,000.00 721 0.29 809 0.29 1005 0.29 247,528.30 1.000 3/31/2017 1005 0.29 248,000.00 248,000.00 248,903.71 0.850 6/8/2015 1,000,000.00 1,000,000.00 1,000,000.00 985,454.90 343 0.29 1,004,505.00 2.100 4/24/2019 1759 1.17 983,216.00 1.259 5/21/2018 1421 1.16 Sub Total / Average 44: Shadow Creek Impact Wells Fargo Sweep Cash Marlin Business Bank 0.55 6/14/2016 Bank of Buffalo KY 0.35 6/22/2015 GUARANTY B&T 1.35 5/29/2018 WFSWEEP Cash CD57116AGF9 060788AF3 400820634 Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit 7,943,306.04 7,928,760.94 7,931,628.93 0.657 5/31/2006 1,192,099.92 1,192,099.92 1,192,099.92 0.140 6/14/2013 12/20/2013 5/29/2014 N/A 248,000.00 248,000.00 248,232.87 0.550 6/14/2016 248,000.00 248,000.00 247,731.42 0.350 6/22/2015 248,000.00 248,000.00 543 9.30 1 1.40 715 0.29 357 0.29 246,918.72 1.350 5/29/2018 1429 0.29 Sub Total / Average 45: Hotel/Motel Occupancy Wens Fargo Sweep Cash WFSWEEP First Commercial Bank Miss 0.4 6/26/2015 Colonial Virginia Bank 0.55 6/24/2016 FHLMC 0.4 1/15/2016-14 31984GCW7 CD196121AM9 3134G4S33 Cash Certificate Of Deposit Certificate Of Deposit FHLMC Bond 5/31/2006 12/27/2013 6/25/2013 1/29/2014 1,936,099.92 1,936,099.92 1,934,982.93 0.374 942,984.26 248,000.00 248,000.00 1,000,000.00 5of10 942,984.26 942,984.26 0.140 248,000.00 248,000.00 1,000,000.00 N/A 247,719.02 0.400 6/26/2015 248,209.56 0.550 6/24/2016 1,000,072.00 0.400 1/15/2016 321 2.27 361 0.29 725 0.29 564 1.17 1�i Security Settlement Face YTM @I Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Sub Total / Average 2,438,984.26 2,438,984.26 2,438,984.84 0.315 342 2.86 46: Park Donations Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 117,911.69 117,911.69 117,911.69 0.140 N/A 1 0.14 Sub Total / Average 117,911.69 117,911.69 117,911.69 0.140 1 0.14 47: Park & Rec Development Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 781,067.53 781,067.53 781,067.53 0.140 N/A 1 0.92 First State Bank - Un Cty 336472E10 Tenn 0.45 12/23/2015 Certificate Of Deposit 12/23/2013 248,000.00 248,000.00 248,159.22 0.450 12/23/2015 541 0.29 Sub Total / Average 1,029,067.53 1,029,067.53 1,029,226.75 0.215 131 1.21 49: Tree Trust Fund Welts Fargo Sweep Cash WFSWEEP Cash 5/31/2006 69,282.43 69,282.43 69,282.43 0.140 N/A 1 0.08 Sub Total / Average 69,282.43 69,282.43 69,282.43 0.140 1 0.08 50: Capital Projects Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 2,064,667.46 2,064,667.46 2,064,667.46 0.140 N/A 1 2.42 San Diego Private Bank 79744YAB6 Cafiffomia 0.8 3/31/2017 Certificate Of Deposit 3/31/2014 248,000.00 248,000.00 247,526.82 0.800 3/31/2017 1005 0.29 Sub Total / Average 2,312,667.46 2,312,667.46 2,312,194.28 0.211 109 2.71 55: Sidewalk Fund Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 259,445.62 259,445.62 259,445.62 0.140 N/A 1 0.30 Sub Total / Average 259,445.62 259,445.62 259,445.62 0.140 1 0.30 60: Police State Seizure Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 166,296.89 166,296.89 166,296.89 0.140 N/A 1 0.20 Sub Total / Average 166,296.89 166,296.89 166,296.89 0.140 1 0.20 62: Federal Police Fund Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 58,599.24 58,599.24 58,599.24 0.140 N/A 1 0.07 Sub Total / Average 58,599.24 6 of 10 58,599.24 58,599.24 0.140 1 0.07 Zp Security Settlement Face Description CUSIP/Ticker Type Date Amount/Shares YTM @ Maturity Days To % of Book Value Market Value Cost Date Maturity Portfolio 64: 1998 Cert of Obligation We[Is Fargo Sweep Cash WFSWEEP Cash US AmeriBank Largo FL 917312CC2 Certificate 0.55 12/23/2015 Of Deposit 5/31/2006 12/23/2013 455,835.63 248,000.00 455,835.63 455,835.63 0.140 N/A 248,000.00 248,195.42 0.550 12/23/2015 Sub Total / Average 67: 2003 Revenue Bonds Wells Fargo Sweep Cash Asheville Savings Bank 0.35 3/27/2015 Medallion Bank UT 0.4 11/3/2015 CIT Bank 1.5 9/5/2017 CALUSA NATIONAL BANK 13151TAX4 WFSWEEP Cash CD04407RA10 C0584038862 CD17284CMN1 0.5 9/22/2016 First National Bank ORD NEB 0.8 11/18/2016 32116RAC8 FHLMC 0.35 12/5/2014 3134G3H78 Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit FHLMC Bond 5/31/2006 2/28/2013 5/3/2013 9/4/2013 5/23/2014 11/18/2013 9/27/2012 703,835.63 940,102.63 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 1,000,000.00 703,835.63 704,031.05 0.284 940,102.63 940,102.63 0.140 N/A 1 0.53 541 0.29 191 0.83 248,000.00 248,114.33 0.350 3/27/2015 270 0.29 248,000.00 248,301.32 0.400 11/3/2015 491 0.29 248,000.00 248,252.46 1.500 9/5/2017 1163 0.29 248,000.00 247,237.65 0.500 9/22/2016 815 0.29 248,000.00 248,718.46 0.800 11/18/2016 872 0.29 1,000,085.76 1,001,032.00 0.330 12/5/2014 158 1.17 Sub Total / Average 68: 2001 Cert of Obligation Wells Fargo Sweep Cash WFSWEEP Cash 3,180,102.63 3,180,188.39 3,181,758.85 0.422 5/31/2006 -330,587.00 -330,587.00 -330,587.00 0.140 Sub Total / Average 70: 2005 Refunding / Mobility Welts Fargo Sweep Cash WFSWEEP Cash First State Bank - WV CD33648FHR9 Certificate 0.35 12/3/2014 Of Deposit 5/31/2006 12/3/2012 -330,587.00 -330,587.00 -330,587.00 0.140 82,278.73 82,278.73 82,278.73 0.140 N/A N/A 248,000.00 248,000.00 247,871.78 0.350 12/3/2014 Sub Total / Average 95: Property Liability Wells Fargo Sweep Cash WFSWEEP Cash 330,278.73 330,278.73 330,150.51 0.298 10/31/2006 -10,144.77 -10,144.77 -10,144.77 0.140 7 of 10 N/A 332 3.73 1 -0.39 1 -0.39 1 0.10 156 0.29 117 0.39 1 -0.01 Zl Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Sub Total / Average -10,144.77 -10,144.77 -10,144.77 0.140 1 -0.01 97: Employee Benefit Trust Wells Fargo Sweep Cash WFSWEEP Cash 9/1/2007 84,039.57 84,039.57 84,039.57 0.140 N/A 1 0.10 Sub Total / Average 84,039.57 84,039.57 84,039.57 0.140 1 0.10 99: COP Health Claims Fund Web Fargo Sweep Cash WFSWEEP Cash 9/15/2010 -326,633.14 -326,633.14 -326,633.14 0.140 N/A 1 -0.38 Wells Fargo Cash WF9871 Cash 7/21/2010 223,302.01 223,302.01 223,302.01 0.140 N/A 1 0.26 Sub Total / Average -103,331.13 -103,331.13 -103,331.13 0.140 1 -0.12 2101: Grant Fund Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 -39,536.82 -39,536.82 -39,536.82 0.140 N/A Sub Total / Average -39,536.82 -39,536.82 -39,536.82 0.140 1 -0.05 1 -0.05 Z109: 2011 CMG Fund Wells Fargo Sweep Cash WFSWEEP Cash 12/1/2011 -161.41 -161.41 -161.41 0.140 N/A 1 0.00 Sub Total / Average -161.41 -161.41 -161.41 0.140 1 0.00 2110: 2012 CDBG Fund Wells Fargo Sweep Cash WFSWEEP Cash 11/15/2012 204.55 204.55 204.55 0.140 N/A 1 0.00 Sub Total / Average 204.55 204.55 204.55 0.140 1 0.00 Z140: U of H Fund Wells Fargo Sweep Cash WFSWEEP Cash 12/1/2009 -45,710.74 -45,710.74 -45,710.74 0.140 N/A Sub Total / Average -45,710.74 -45,710.74 -45,710.74 0.140 1 -0.05 1 -0.05 Z141: U of H Capital Renewal Fund Wells Fargo Sweep Cash WFSWEEP Cash 9/30/2013 240,037.85 240,037.85 240,037.85 0.140 N/A 1 0.28 Sub Total / Average 240,037.85 240,037.85 240,037.85 0.140 1 0.28 Z145: Municipal Channel Wells Fargo Sweep Cash WFSWEEP Cash 4/15/2012 354,772.22 354,772.22 354,772.22 0.140 N/A 1 0.42 8of10 Security Settlement Face YTM © Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Sub Total / Average 2200: 2006 Cert of Obligation Wells Fargo Sweep Cash WFSWEEP Cash 354,772.22 354,772.22 354,772.22 0.140 6/30/2006 1,887,367.38 1,887,367.38 1,887,367.38 0.140 N/A Sub Total / Average Z201: 2007 Cert of Obligation Welles Fargo Sweep Cash WFSWEEP Cash 8/31/2006 1,887,367.38 1,887,367.38 1,887,367.38 0.140 57,478.97 57,478.97 57,478.97 0.140 Sub Total / Average Z202: 2007A Gen Obligation Welts Fargo Sweep Cash WFSWEEP Cash Cehic Bank 0.6 6/28/2016 CD15118RJD0 Certificate Of Deposit 12/31/2007 6/28/2013 57,478.97 933,281.41 248,000.00 57,478.97 57,478.97 0.140 933,281.41 933,281.41 0.140 N/A N/A 248,000.00 248,248.99 0.600 6/28/2016 Sub Total / Average Z203: 2009 Gen Obligation Welts Fargo Sweep Cash Kansas State Bank 0.8 10/31/2016 Cathay Bank 0.75 3/21/2016 Merchant & Manufacturing Bank 0.35 8/7/2015 Flushing Bank New York 0.95 3/31/2017 Provident Bank 0.35 8/21/2015 WFSWEEP 485382OV4 CD1491593E6 588339D00 34387AAU2 743837BF2 Cash Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certfficate Of Deposit 1,181,281.41 1,181,281.41 1,181,530.40 0.237 10/30/2008 2,888,842.49 2,888,842.49 2,888,842.49 0.140 10/30/2013 248,000.00 9/20/2013 248,000.00 2/7/2014 248,000.00 3/31/2014 248,000.00 2/21/2014 248,000.00 N/A 1 0.42 1 2.21 1 2.21 1 0.07 1 0.07 1 1.09 729 0.29 154 1.39 1 3.39 248,000.00 248,919.83 0.800 10/31/2016 854 0.29 248,000.00 248,910.66 0.750 3/21/2016 630 0.29 248,000.00 247,673.38 0.350 8/7/2015 403 0.29 248,000.00 247,461.10 0.950 3/31/2017 1005 0.29 248,000.00 247,640.40 0.350 8/21/2015 417 0.29 FFCB 1.5 1/28/2019 3133EDNF6 FFCB Bond 5/28/2014 1,000,000.00 1,000,000.00 998,360.00 1.500 1/28/2019 1673 1.17 Sub Total / Average 5,128,842.49 5,128,842.49 5,127,807.86 0.526 487 6.02 Z301.: W/S Pay As U Go CIP Wells Fargo Sweep Cash WFSWEEP Cash 12/31/2007 2,061,858.47 2,061,858.47 2,061,858.47 0.140 N/A 1 2.42 9ofI0 7,3 Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Tidier Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio DeWitt Bank and Trust Certificate 0.5 6/20/2016 CD241888BT2 Of Deposit 6/24/2013 248,000.00 248,000.00 248,267.59 0.500 6/20/2016 721 0.29 Sub Total / Average 2302: MUD 4 Capital Programs Welts Fargo Sweep Cash WFSWEEP Cash Farm Bureau Bank 0.5 307660HH6 Certificate 12/23/2015 Of Deposit Pacific City Bank 0.35 69406P1117Certificate 6/26/2015 Of Deposit 2,309,858.47 2,309,858.47 2,310,126.06 0.179 78 2.71 2/1/2013 645,845.54 645,845.54 645,845.54 0.140 N/A 1 0.76 12/23/2013 248,000.00 248,000.00 248,195.42 0.500 12/23/2015 541 0.29 12/26/2013 248,000.00 248,000.00 247,695.21 0.350 6/26/2015 361 0.29 Sub Total / Average 1,141,845.54 1,141,845.54 1,141,736.17 0.264 196 1.34 Total / Average 85,271,929.76 85,261,338.95 85,319,403.10 0.481 377 100 10 of 10 City of Pearland Quarterly Investment Report at Quarterend Report Format: By Transaction Group By: Security Type Partfolio/Report Group: Report Group: Pearland As of 6/30/2014 YTM Portfolio Settlement Maturity @ Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Cash Wells Fargo WFSWEEP 10: General 5/31/2006 N/A 0.140 10,305,726.92 10,305,726.92 10,305,726.92 10,305,726.92 1 12 09 Sweep Cash Fund Wells Fargo 17: Municipal Sweep Cash WFSWEEP Court 5/31/2006 N/A 0.140 120,688.26 120,688.26 120,688.26 120,688.26 1 0.14 Security Welk Fargo 18: City Sweep Cash WFSWEEP Wide 5/31/2006 N/A 0.140 58,870.28 58,870.28 58,870.28 58,870.28 1 0.07 Donation Wells Fargo WFSWEEP 19: Court 5/31/2006 N/A 0.140 47,051.42 47,051.42 47,051.42 47,051.42 1 0.06 Sweep Cash Technology Welk Fargo WFSWEEP 20: Debt 5/31/2006 N/A 0.140 7,267,806.04 7,267,806.04 7,267,806.04 7,267,806.04 1 8.52 Sweep Cash Services Welts Fargo 23: Court WFSWEEP Juvenile 9/15/2009 N/A 0.140 56,885.92 56,885.92 56,885.92 56,885.92 1 0 07 Sweep Cash Mgmt Welk Fargo WFSWEEP 30: Water & 5/31/2006 N/A 0.140 9,403,874.63 9,403,874.63 9,403,874.63 9,403,874.63 1 11.03 Sweep Cash Sewer Wells Fargo WFSWEEP 31: 12/1/2006 N/A 0.140 446,032.93 446,032.93 446,032.93 446,032.93 1 0.52 Sweep Cash Sotdwaste Welk Fargo 35: Street WFSWEEP 5/31/2006 N/A 0.140 426,336.92 426,336.92 426,336.92 426,336.92 1 0.50 Sweep Cash Assessment Welk Fargo WFSWEEP 42: Utility 5/31/2006 N/A 0.140 3,959,306.04 3,959,306.04 3,959,306.04 3,959,306.04 1 4.64 Sweep Cash Impact Fee Welk Fargo 44: Shadow Sweep Cash WFSWEEP Creek 5/31/2006 N/A 0.140 1,192,099.92 1,192,099.92 1,192,099.92 1,192,099.92 1 1.40 Impact Welts Fargo 45: Sweep Cash WFSWEEP HoteVMotel 5/31/2006 N/A 0.140 942,984.26 942,984.26 942,984.26 942,984.26 1 1.1 1 Occupancy Welts Fargo WFSWEEP 46: Park 5/31/2006 N/A 0.140 117,911.69 117,911.69 117,911.69 117,911.69 1 0.14 Sweep Cash Donations Welk Fargo 47: Park & Sweep Cash WFSWEEP Rec 5/31/2006 N/A 0.140 781,067.53 781,067.53 781,067.53 781,067.53 1 0.92 Development 1of10 YTM Portfolio Settlement Maturity 0 Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Wells Fargo WFSWEEP 49: Tree 5/31/2006 N/A 0.140 69,262.43 69,282.43 69,282.43 69,282.43 1 0.08 Sweep Cash Trust Fund Welts Fargo WFSWEEP 50: Capital 5/31/2006 N/A 0.140 2,064,667.46 2,064,667.46 2,064,667.46 2,064,667.46 1 2.42 Sweep Cash Projects Wells Fargo WFSWEEP 55: Sidewalk 5/31/2006 N/A 0.140 259,445.62 259,445.62 259,445.62 259,445.62 1 0.30 Sweep Cash Fund Welts 60: Police elts Fargo Sweep Cash WFSWEEP State 5/31/2006 N/A 0.140 166,296,89 166,296.89 166,296.89 166,296.89 1 0.20 Seizure Wells Fargo WFSWEEP 62: Federal 5/31/2006 N/A 0.140 58,599.24 58,599.24 58,599.24 58,599.24 1 0.07 Sweep Cash Police Fund Wens Fargo 64: 1998 Sweep Cash WFSWEEP Cert of 5/31/2006 N/A 0.140 455,835.63 455,835.63 455,835.63 455,835.63 1 0.53 Obfgation Wells Fargo 67: 2003 Sweep Cash WFSWEEP Revenue 5/31/2006 N/A 0.140 940,102.63 940,102 63 940,102.63 940,102.63 1 1.10 Bonds WeI►s Fargo 68: 2001 Sweep Cash WFSWEEP Cert of 5/31/2006 N/A 0.140 -330,587.00 -330,587.00 -330,587.00 -330,587.00 1 -0.39 Obligation Wells Fargo 70: 2005 Sweep Cash WFSWEEP Refunding/ 5/31/2006 N/A 0.140 82,278.73 82,278.73 82,278.73 82,278.73 1 0.10 Mobility Weill Fargo WFSWEEP 95: Property 10/31/2006 N/A 0.140 -10,144.77 -10,144.77 -10,144.77 -10,144.77 1 -0 01 Sweep Cash Uabllty Wells Fargo 97: Sweep Cash WFSWEEP Employee 9/1/2007 N/A 0.140 84,039.57 84,039.57 84,039.57 84,039.57 1 0.10 Benefl Trust Welk Fargo 99: COP Sweep Cash WFSWEEP Health 9/15/2010 N/A 0.140 -326,633.14 -326,633.14 -326,633.14 -326,633.14 1 0.38 Claims Fund Welk Fargo 99: COP Cash WF9871 Health 7/21/2010 N/A 0.140 223,302.01 223,302.01 223,302.01 223,302.01 1 0.26 Claims Fund Wells Fargo WFSWEEP 2101: Grant 5/31/2006 N/A 0.140 -39,536.82 -39,536.82 -39,536.82 -39,536.82 1 -0.05 Sweep Cash Fund Welts Fargo WFSWEEP Z109: 2011 12/1/2011 N/A 0.140 -161.41 -161.41 -161.41 -161.41 1 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP 2110: 2012 11/15/2012 N/A 0.140 204.55 204,55 204.55 204.55 1 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z140: U of H 12/1/2009 N/A 0.140 -45,710.74 -45,710 74 -45,710.74 -45,710.74 1 -0.05 Sweep Cash Fund Zb 2 of 10 YTM Portfolio Settlement Maturity @ Face Days To Accrued 46 of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Z141:U0fH Wells Fargo WFSWEEP Capital 9/30/2013 N/A 0.140 240,037.85 240,037.85 240,037.85 240,037.85 1 0.28 Sweep Cash Renewal Fund Z145: Wells Fargo WFSWEEP Municipal 4/15/2012 N/A 0.140 354,772.22 354,772.22 354,772.22 354,772.22 1 0.42 Sweep Cash Channel WetsZ200: 2006 Fargo Sweep Cash WFSWEEP Cert of 6/30/2006 N/A 0.140 1,887,367.38 1,887,367.38 1,887,367.38 1,887,367.38 1 2.21 Obtgation Z201: 2007 Wets Fargo WFSWEEP Cent of 8/31/2006 N/A 0.140 57,478.97 57,478.97 57,478.97 57,478.97 1 0.07 Sweep Cash Obligation Z202: Wells Fargo WFSWEEP 2007A Gen 12/31/2007 N/A 0.140 933,281.41 933,281.41 933,281.41 933,281.41 1 1.09 Sweep Cash Obligation Weill Fargo Z203: 2009 Sweep Cash WFSWEEP Gen 10/30/2008 N/A 0.140 2,888,842.49 2,886,842.49 2,888,842.49 2,888,842.49 1 3.39 Obligation Welts Fargo Z301: W/S Sweep Cash WFSWEEP Pay As U Go 12/31/2007 N/A 0.140 2,061,858.47 2,061,858.47 2,061,858.47 2,061,858.47 1 2,47 C1P Wells Fargo 2302: MUD Sweep Cash WFSWEEP 4 Capital 2/1/2013 N/A 0.140 645,845.54 645,845.54 645,845.54 645,845.54 1 0.76 Programs Sub Total / 0.140 47,847,407.97 47,847,407.97 47,847,407.97 47,847,407.97 1 0.00 56.11 Average Certificate Of Deposit CDARS 0.5 1016130741 10: General 12/19/2013 12/18/2014 0.500 500,000.00 500,000.00 500,000.00 500,000.00 171 1,321.92 0.59 12/18/2014 Fund Valley Bank 10: General Roanoke 0.3 CD91935VANO Fund 1/30/2013 7/30/2014 0.300 248,000.00 248,000.00 248,000.00 248,016.37 30 307.79 0.29 7/30/2014 First National 10: General Bank 1.6 CD32115CBE7 Fund 9/18/2013 3/19/2018 1.600 248,000.00 248,000.00 248,000.00 249,727.57 1358 119.58 0.29 3/19/2018 1st United Bank 10: General FL 0.7 33741TAU5 Fund 11/8/2013 5/9/2016 0.700 248,000.00 248,000.00 248,000.00 248,767.56 679 99.88 0.29 5/9/2016 Trust Atlantic 10: General Bank 1.45 89835F3C5 Fund 11/6/2013 12/6/2017 1.450 248,000.00 248,000.00 248,000.00 249,512.06 1255 236.45 0.29 12/6/2017 3 of 10 7:1 YTM Portfolio Settlement Maturity @ Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Fanners & Merchants Bank 308862000 10: General 4/25/2014 9/25/2018 1.450 248,000.00 248,000.00 248,000.0D 248,608.59 1548 49.26 0.29 1.45 Fund 9/25/2018-14 Moody National 10: General Bank 0.5 7130 Fund 5/30/2014 11/30/2014 0.500 247,420.54 247,420.54 247,420.54 247,420.54 153 105.07 0.29 11/30/2014 Southwest 10: General Bank Ft Worth CD844772AA1 6 Fund 2/27/2013 2/27/2015 0.300 248,000.00 248,000.00 248,000.00 248,2292 242 6.12 0.29 0.3 2/27/2015 Plus International 10: General Bank 0.5 CD72940UFV2 Fund 7/8/2013 7/8/2016 0.500 248,000.00 248,000.00 248,000.00 248,133.92 739 74.74 0.29 7/8/2016 Cardinal Bank CD14147VDM5 10: General 5/17/2013 5/17/2016 0.500 248,000.00 248,000.00 248,000 00 248,341.25 687 44.16 0.29 0.5 5/17/2016 Fund Discover Bank CD254671KH2 10: General 2/20/2013 2/20/2015 0.500 248,000.00 248,000.00 248,000.00 248,227.42 235 441.64 0.29 0.5 2/20/2015 Fund Synovus Bank 10: General GA 0.5 87164DBV1 Fund 11/30/2012 11/28/2014 0.500 248,000.00 248,000.00 248,000.00 248,493.52 151 105.32 0.29 11/28/2014 CDARS 0.9 1016754591 10: General 6/19/2014 6/16/2016 0.900 500,000.00 500,000.00 500,000.00 500,000.00 717 135.62 0.59 6/16/2016 Fund Community National Bank 20375WAM6 10: General 4/4/2014 4/4/2018 1.250 248,000.00 248,000.00 248,000.00 247,412.49 1374 738.90 0.29 Interest 1.25 Fund 4/4/2018 Townebank 10: General Portsmouth VA 89214PAP4 Fund 5/31/2013 6/1/2015 0.400 248,000.00 248,000.00 248,000.00 247,997.27 336 81.53 0.29 0.4 6/1/2015 FIRST BANK HIGHLAND 3191418L0 10: General 5/7/2014 5/7/2019 1.850 248,000.00 248,000.00 248,000.00 246,949,97 1772 678.77 0.29 PARK 1.85 Fund 5/7/2019-14 ConnectOne 20: Debt Bank 1.55 20786AAM7 Services1/30/2014 7/30/2018 1.550 2413,000.00 248,000.00 248,000.00 248,421.60 1491 0.00 0.29 7/30/2018 Key Bank Ohio 20: Debt 0.35 CD493065REI3 Services 2/27/2013 8/27/2014 0.350 248,000.00 248,000.00 248,000.00 248,059.77 56 292.50 0.29 8/27/2014 Webster Bank 20: Debt NA 1.9 9476861JM7 Servkes 2/12/2014 2/12/2019 1 900 248,000.00 248,000.00 248,000.00 247,675.12 1688 1,781.52 0.29 2/12/2019 4 of 10 28 YTM Portfolio Settlement Maturity tip Face Days To Accrued 9'a of Description CUSIP/Tkker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Mechanics Savings Bank CD583686BC3 20. Debt 3/20/2013 3/20/2015 0.350 248,000.00 248,000.00 248,000.00 248,143.34 263 23.78 0.29 0.35 Services 3/20/2015 Goldman Sachs 30: Water & Bank 0.6 CD38147JAA0 0 2/20/2013 2/20/2015 0.600 248,000.00 248,000.00 248,000.00 248,133.42 235 529.97 0 2 Sewer 2/20/2015 BARCLAYS BANK 06740KGU5 30: Water& 5/6/2014 5/7/2019 1.950 248,000.00 248,000.00 248,000.00 246,936.08 1772 728 71 0 25 DELAWARE Sewer 1.95 5/7/2019 OLDTOWN 30: Water& BANK 1.2 680540866 6/6/2014 5/7/2018 1.200 248,000.00 248,000.00 248,000.00 246,784.30 1407 195.68 029 Sewer 5/7/2018 Bay Cities Bank 30: Water & 0.5 CD07203QBR2 12/12/2012 12/12/2014 0.500 248,000.00 248,000.00 248,000.00 248,522.54 165 61-11 0.29 Sewer 12/12/2014 Fox Chase Bank 30: Water & 0.65 CD35137QAN4 6/27/2013 6/27/2016 0.650 248,000.00 248,000.00 246 3 ,000.00 248,202.12 728 125 0.29 Sewer 6/27/2016 CDAAS 0.6 1016754575 30: Water & 6/19/2014 6/18/2015 0.600 500,000.00 500,000.00 500,000.00 500,000.00 353 90.41 0.S9 6/18/2015 Sewer First Farmers 30: Water & Bank 0.5 C0320165FZ1 5/3/2013 5/3/2016 0.500 245,000.00 245,000.00 245,000.00 245,095.80 673 90.62 0 29 5/3/2016 Sewer Northwest Bank 30: Water & Boise Idaho 1.5 66736AAD1 4/10/2014 1/10/2019 1.500 248,000.00 248,000.00 248,000.00 247,577.90 1655 203.84 0.20 Sewer 1/10/2019 Fidelity Homestead 31: Savings Bank 31617CA05 Solxhvaste 3/28/2014 11/28/2016 0.600 248,000.00 248,000.00 248,000.00 247,690.99 882 e. I S -' 11 22` New Orleans 0.6 11 United Bankers 35: Street Bank 0.75 909557CV0 11/6/2013 5/6/2016 0.750 248,000.00 248,000.00 248,000.00 248,616 91 676 122 30 0 29 Assessment 5/6/2016 Hardin County 42: Utility=n Impact Fee Bank 0.25 4118228G3 12/30/2013 12/30/2014 0.250 248,000.00 248,000.00 248,000.00 247,865.83 183 44.21 12/30/2014 Private Bank & 42: Utility Trust 0.35 CD74267GTC1 5/10/2013 5/11/2015 0.350 248,000.00 248,000.00 248,000.00 248,055.30 315 118.90 0 <9 Impact Fee 5/11/2015 Sterling Savings 42: Utility Bank 0.35 CD8595316A8 impact Fee 2/22/2013 2/23/2015 0.350 248,000.00 248,000.00 248,000.00 248,227.42 238 304 39 0.29 5 of 10 za YTM Portfolio Settlement Maturity @ Face Days To Accrued % of Description CUSIP/Tkker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfofo 2/23/2015 College Savings ty Bank 0.55 CD19443PAP4 42: Ut6Fee 6/19/2013 6/20/2016 0.550 248,000.00 248,000.00 248,000.00 248,218.98 721 37.37 0.29 impac6/20/2016 The Independent CD88632YAG1 42 Utility 9/18/2013 9/16/2016 1.100 248,000.00 248,000 00 248,000.00 248,347.70 809 104.64 0.29 Bank 1.1 Impact Fee 9/16/2016 JP Morgan Chase Bank 42: Utility Columbus Ohio 48125T3W6 Impact Fee 3/31/2014 3/31/2017 0.850 248,000.00 248,000.00 248,000.00 247,454.65 1005 525.56 0.29 0.85 3/31/2017 - Far East Natb nal Bank 307327EK8 42: Utility 3/31/2014 3/31/2017 1.000 248,000.00 248,000.00 248,000.00 247,528.30 1005 0.00 0.29 Los Angeles 1 Impact Fee 3/31/2017 BMW Bank of 42: Utility NA 0.85 CD05568P2Q9 Impact Fee 12/7/2012 6/8/2015 0.850 248,000.00 248,000.00 248,000.00 248,903.71 343 132.83 0.29 6/8/2015 Marlin Business 44: Shadow Bank 0.55 CD57116AGF9 Creek 6/14/2013 6/14/2016 0.550 248,000.00 248,000.00 248,000.00 248,232.87 715 59.79 0.29 6/14/2016 Impact Bank of euffab 44: Shadow KY 0.35 060788AF3 Creek 12/20/2013 6/22/2015 0.350 248,000.00 248,000.00 248,000.00 247,731.42 357 19.02 0.29 6/22/2015 Impact GUARANTY 8&T 44: Shadow 1.35 400820814 Creek 5/29/2014 5/29/2018 1.350 248,000.00 248,000.00 248,000.00 246,918.72 1429 9.17 0.29 5/29/2018 Impact First 45: Commercial 31984GCW7 HoteVMotel 12/27/2013 6/26/2015 0.400 248,000.00 248,000.00 248,000.00 247,719.02 361 10.87 0.29 Bank Miss 0.4 Occupancy 6/26/2015 Colonial Virginia 45: Bank 0.55 CD196121AM9 HoteVMotel 6/25/2013 6/24/2016 0.550 248,000.00 248,000.00 248,000.00 248,209.56 725 22.42 0.29 6/24/2016 Occupancy First State Bank 47: Park & Un Cty Tenn 336472E10 Rec 12/23/2013 12/23/2015 0.450 248,000.00 248,000.00 248,000.00 248,159.22 541 21.40 0.29 0.45 Development 12/23/2015 San Diego Private Bank 79744YAB6 50: Capital 3/31/2014 3/31/2017 0.800 248,000.00 248,000.00 248,000.00 247,526.82 1005 0.00 0.29 California 0.8 Projects 3/31/2017 6 of 10 30 YTM Portfolio Settlement Maturity @ Face Days To Accrued olo of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio US Amerlbank 64: 1998 Largo FL 0.55 917312CC2 Cert of 12/23/2013 12/23/2015 0.550 248,000.00 248,000.00 24B4O00.00 248,195.42 541 26.16 0.29 12/23/2015 Obligation Asheville 67: 2003 Savings Bank CD04407RA10 Revenue 2/28/2013 3/27/2015 0.350 248,000.00 248,000.00 248,000.00 248,114.33 270 4.76 0.29 0.35 Bonds 3/27/2015 Medallion Bank 67: 2003 UT 0.4 C05840381362 Revenue 5/3/2013 11/3/2015 0.400 248,000.00 248,000.00 248,000.00 248,301.32 491 157.63 0.29 11/3/2015 Bonds CIT Bank 1.5 67: 2003 9/5/2017 CD17284CMN1 Revenue 9/4/2013 9/5/2017 1.500 248,000.00 248,000.00 248,000.00 246,252.46 1163 1,202.63 0.29 Bonds CALUSA 67: 2003 NATIONAL 13151TAX4 Revenue 5/23/2014 9/22/2016 0.500 248,000.00 248,000.00 248,000.00 247,237.65 815 27.18 0.29 BANK 0.5 Bonds 9/22/2016 First National 67: 2003 Bank ORD NEB 32116RAC8 Revenue 11/18/2013 11/18/2016 0.800 248,000.00 248,000.00 248,000.00 248,718.46 872 233.73 0.29 0.8 Bonds 11/18/2016 First State Bank 70: 2005 - WV 0.35 CD33648FHR9 Refunding / 12/3/2012 12/3/2014 0.350 248,000.00 248,000.00 248,000.00 247,871.78 156 64.21 0.29 12/3/2014 Mobility Celtic Bank 0.6 Z202: 6/28/2016 CD15118RJDO 2007A Gen 6/28/2013 6/28/2016 0.600 248,000.00 248,000.00 248,000.00 248,248.99 729 8.15 0.29 Obligation Kansas State 2203: 2009 Bank 0.8 485382DV4 Gen 10/30/2013 10/31/2016 0.800 248,000.00 248,000.00 248,000.00 248,919.83 854 0.00 0.29 10/31/2016 Obligation Cathay Bank Z203: 2009 0.75 C01491593E6 Gen 9/20/2013 3/21/2016 0.750 248,000.00 248,000.00 248,000.00 248,910.66 630 50.96 0.29 3/21/2016 Obligation Merchant & Z203: 2009 Manufacturing 588339DD0 Gen 2/7/2014 8/7/2015 0.350 248,000.00 248,000.00 248,000.00 247,673.38 403 54.70 0.29 Bank 0.35 Obtgation 8/7/2015 Flushing Bank Z203: 2009 New York 0.95 34387AAH2 Gen 3/31/2014 3/31/2017 0.950 248,000.00 248,000 00 248,000.00 247,461.10 1005 0.00 0.29 3/31/2017 Obligation Provident Bank Z203: 2009 0.35 743837BF2 Gen 2/21/2014 8/21/2015 0.350 248,000 00 248,000.00 248,000.00 247,640.40 417 306.77 0.29 8/21/2015 Obligation 7of 10 YTM Portfolio Settlement Maturity ® Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio DeWitt Bank 2301: W/S and Trust 0.5 CD241868BT2 Pay As U Go 6/24/2013 6/20/2016 0.500 248,000.00 248,000.00 248,000.00 248,267.59 721 33.97 0.29 6/20/2016 CIP Farm Bureau Z302: MUD Bank 0.5 30766011H6 4 Capital 12/23/2013 12/23/2015 0.500 248,000.00 248,000.00 248,000.00 248,195.42 541 23.78 0.29 12/23/2015 Programs Pacific City Bank Z302: MUD 0.35 69406PB)7 4 Capital 12/26/2013 6/26/2015 0.350 248,000.00 248,000.00 248,000.00 247,695.21 361 9.51 0.29 6/26/2015 Programs Sub Total / 0.743 15,880,420.54 15,880,420.54 15,880,420.54 15,884,698.86 694 12,308.39 18.62 Average FAMC Bond FAMC 1.72 31315P5A3 30: Water & 12/16/2013 10/3/2018 1.766 1,000,000.00 997,890.00 998,127.02 1,004,940.00 1556 4,156.67 1.17 10/3/2018 Sewer Sub Total / 1.766 1,000,000.00 997,890.00 998,127.02 1,004,940.00 1556 4,156.67 1.17 Average FFCB Bond FFCB 1.34 3133EDE99 10: General 1/29/2014 12/29/2017 1.235 1,000,000.00 1,004,000.00 1,003,571.63 1,011,343.00 1278 37.22 1.17 12/29/2017 Fund FFCB 0.3 3133EAYL6 10: General 8/1/2012 7/18/2014 0.285 1,000,000.00 1,000,293.48 1,000,007.47 1,000,084.00 18 1,350.00 1.17 7/18/2014 Fund FFCB 0.25 3133ECAV6 20: Debt 1/28/2013 12/24/2014 0.273 1,000,000.00 999,560.00 999,868.40 1,000,618.00 177 41.67 1.17 12/24/2014 Services FFCB 1.95 3133ED2C5 30: Water& 1/29/2014 9/17/2018 1.617 1,000,000.00 1,014,770.00 1,013,432.91 1,028,243.00 1540 5,579.17 1.17 9/17/2018 Sewer FFCB 1.5 Z2D3: 2009 1/28/2019 3133EDNF6 Gen 5/26/2014 1/28/2019 1.500 1,000,000.00 1,000,000.00 1,000,000.00 998,360.00 1673 1,333.33 1.17 Obligation Sub Total / 0.982 5,000,000.00 5,018,623.48 5,016,900.41 5,038,648.00 937 8,341.39 5.86 Average FHLB Bond FHLB 1.1 3130A1GP7 10: General 4/17/2014 4/17/2017 1.100 1,000,000.00 1,000,000.00 1,000,000.00 1,002,462.00 1022 2,230.56 1.17 4/17/2017-14 Fund FHLB 1.15 3133743W8 30: Water& 11/29/2012 10/30/2014 0.300 1,000,000.00 1,016,250.00 1,002,822.00 1,003,513.0D 122 1,916.67 1.17 10/30/2014 Sewer FHLB 1.75 313376885 30: Water & 12/16/2013 12/14/2018 1.736 1,000,000.00 1,000,670.00 1,000,597.71 1,008,677.00 1628 777.78 1.17 12/14/2018 Sewer 8 of 10 31 yTM Portfolio Settlement Maturity @ Face Days To Accrued °fa of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Sub Total / Average FHLMC Bond 1.045 3,000,000.00 3,016,920.00 3,003,419.71 3,014,652.00 924 4,925.01 3.52 FHLMC 2 3134G4FY9 10: General 9/24/2013 9/24/2018 2.000 1,000,000.00 1,000,000.00 1,000,000.00 1,004,091.00 1547 5,333.33 1.17 9/24/2018-14 Fund FHLMC 0.35 3134G4QK7 10: General 12/31/2013 12/31/2015 0.369 1,000,000.00 999,625.00 999,718.75 1,000,032.00 549 0.00 1.17 12/31/2015-14 Fund FHLMC 1.85 313464QV3 20: Debt 12/27/2013 12/27/2018 1.850 1,000,000.00 1,000,000.00 1,000,000.00 1,003,055.00 1641 154.17 1.17 12/27/2018-14 Services FHLMC 0.5 3134G4FP8 30: Water & 8/28/2013 8/28/2015 0.500 1,000,000.00 1,000,000.00 1,000,000.00 1,000,560.00 424 1,666.67 1.17 8/28/2015-14 Sewer FHLMC 1 30: Water & 3137EADLO 1/29/2014 9/29/2017 1.163 1,000,000.00 994,150.00 994,819.20 997,938.00 1187 2,527.78 1.17 9/29/2017 Sewer FHLMC 2.1 3134G511342: Utility 134G53 4/24/2014 4/24/2019 2.100 1,000,000.00 1,000,000.00 1,000,000.00 1,004,505.00 1759 3,850.00 1.17 4/24/2019-14 Impact Fee FHLMC 0.4 45: 1/15/2016-14 3134G4533 HoteVMotei 1/29/2014 1/15/2016 0.400 1,000,000.00 1,000,000.00 1,000,000.00 1,000,072.00 564 1,833.33 1.17 Occupancy FHLMC 0.35 67: 2003 12/5/2014 3134G3H78 Revenue 9/27/2012 12/5/2014 0.330 1,000,000.00 1,000,436.00 1,000,085.76 1,001,032.00 158 243.06 1.17 Bonds Sub Total / 1.089 8,000,000.00 7,994,211.00 7,994,623.71 8,011,285.00 979 15,608.34 9.38 Average FNMA Bond FNMA 0.875 3135G0RT2 10: General 5/21/2014 12/20/2017 1.087 1,000,000.00 992,573.21 992,797.92 992,481.00 1269 243.06 1.17 12/20/2017 Fund FNMA 0.35 313SGOUW1 10: General 7/25/2013 8/25/2015 0.416 509,000.00 508,302.67 508,614.14 509,821.02 421 593.83 0.60 8/25/2015 Fund FNMA 0.875 3135GOPQ0 30: Water & 5/21/2014 10/26/2017 1.019 1,000,000.00 995,150.00 995,303.16 992,662.00 1214 1,555.56 1.17 10/26/2017 Sewer FNMA 1.3 3136FPWZ6 30: water & 6/20/2012 11/17/2014 0.462 1,000,000.00 1,020,050.00 1,003,168.22 1,004,490.00 140 1,552.78 1.17 11/17/2014 Sewer FNMA 0.875 3135GOW]8 42: U11Gty 5/21/2014 5/21/2018 1.259 1,000,000.00 985,050.00 985,454.90 983,216.00 1421 947.92 1.17 5/21/2016 Impact Fee Sub Total / 0.896 4,509,000.00 4,501,125.88 4,485,338.34 4,482,670.02 944 4,893.15 5.29 Average Money Market 9 of 10 33 YTM Portfolio Settlement Maturity 0 Face Days To Accrued %of Descripton CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolo Welts Fargo Bank MM WF5455 Sub Total / Average 10: Genera! 6/15/2019 N/A 0.040 35,101.25 35,101.25 35,101.25 35,101.25 1 0.04 Fund 0.040 35,101.25 35,101.25 35,101.25 35,101.25 1 0.00 0.04 Total / Average 0.482 85,271,929.76 85,291,700.12 85,261,338.95 85,319,403.10 377 50,232.95 100 10 of 10 3`� City of Pearland Purchases Portfolio/Report Group: Report Group: Pearland From 3/31/2014 To 6/30/2014 YTM Portfolio Settlement Maturity Face Name Description Bullet/Callable CUSIP/Tkker Action Date Date Price Amount/Shares Cost Prindpal Interest/Dividends Broker/Dealer JP Morgan 42: Utility Chase Bank Wells Fargo Impact Columbus Yes 48125T3W6 Buy 3/31/2014 3/31/2017 100 248,000.00 0.850 248,000.00 0.00 Bank Fee Ohio 0.85 3/31/2017- 50: San Diego Private Bank79744YAB6 Buy 3/31/2014 3/31/2017 100 248,000.00 0.800 248,000.00 0.00 Welts Fargo Capital California 0.8 Bank Projects 3/31/2017 Z203: Flushing Bank 2009 New YorkWelk Fargo Gen 0.95 34387AAH2 Buy 3/31/2014 3/31/2017 100 248,000.00 0.950 248,000.00 0.00 Bank Obligatbn 3/31/2017 42: Utility Far East National Bank Fargo Impact 307327EK8 Buy 3/31/2014 3/31/2017 100 248,000.00 1.000 248,000.00 0.00 Los Angeles 1 Bank Fee 3/31/2017 10: Community National BankWells Fargo General interest 1.25 20375WAM6 Buy 4/4/2014 4/4/2018 100 248,000.00 1.250 248,000.00 0.00 Bank Fund 4/4/2018 Northwest 30: Bank BoiseWells Fargo Water& Idaho 1.5 66736AAD1 Buy 4/10/2014 1/10/2019 100 248,000.00 1.500 248,000.00 0.00 Bank Sewer 1/10/2019 10: FHLB 1.1Wells Fargo General 4/17/2017-14 Yes 3130A1GP7 Buy 4/17/2014 4/17/2017 100 1,000,000.00 1.100 1,000,000.00 0.00 Bank Fund 42: Utility FHLMC 2.1Duncan Impact 4/24/2019-14 Yes 3134G5233 Buy 4/24/2014 4/24/2019 100 1,000,000.00 2.100 1,000,000.00 0.00 W119ams Fee 10: Farmers & Merchants Fargo General Bank 1.45 Yes 308862000 Buy 4/25/2014 9/25/2018 100 248,000.00 1.450 248,000.00 0.00 Bank Fund 9/25/2018-14 BARCLAYS 30: BANK Wells Fargo Water & DELAWARE 06740KGU5 Buy 5/6/2014 5/7/2019 100 248,000.00 1.950 248,000.00 0.00 Bank Sewer 195 5/7/2019 1 of 2 -3C YTM Portfolio Settlement Maturity Face CLQ Name Description Bullet/Callable CUSIP/Ticker Action Dater Date Price Amount/Shares Cost Principal Interest/Dividends Broker/Dealer FIRST BANK 10: HIGHLANDWells Fargo General PARK 1.85 Yes 3191418L0 Buy 5/7/2014 5/7/2019 100 248,000.00 1 850 248,000.00 0.00 Bank Fund 5/7/2019-14 42: Utility FNMA 0.875CastleOak Impact 5/21/2018 3135G0W38 Buy 5/21/2014 5/21/2018 98.505 1,000,000.00 1.259 985,050.00 0.00 Securities Fee 30: FNMA 0.875CastleOak Water& 10/26/2017 3135G0PQ0 Buy 5/21/2014 10/26/2017 99.515 1,000,000.00 1.019 995,150.00 607.64 Castle0es Sewer 10: FNMA 0.875 General 12/20/2017 3135G0RT2 Buy 5/21/2014 12/20/2017 99.257321 1,000,000.00 1.087 992,573.21 3,670.14 First Southwest Fund 67: 2003 CALUSA Revenue NATIONAL 13151TAX4 Buy 5/23/2014 9/22/2016 100 248,000.00 0.500 248,000.00 3.40 First Southwest Bonds BANK 0.5 9/22/2016 Z203: 2009 FFCB 1.5Duncan 3133EDNF6 Buy 5/28/2014 1/28/2019 100 1,000,000.00 1.500 1,000,000.00 0.00 Gen 1/28/2019 Williams Obligation 44: GUARANTY ShadowDuncan B&T 1.35 400820614 Buy 5/29/2014 5/29/2018 100 248,000.00 1.350 248,000.00 0.00 Creek 5/29/2018 Williams Impact 10 Moody General National Bank 7130 Buy 5/30/2014 11/30/2014 100 247,420.54 0.500 247,420.54 0.00 Moody National Bank Fund 11/30/2014 30: OLDTOWN Water & BANK 1.2 680540886 Buy 6/6/2014 5/7/2018 100 248,000.00 1.200 248,000.00 0.00 First Southwest Sewer 5/7/2018 30: CDARS 0.6Independence Water& 6/18/2015 1016754575 Buy 6/19/2014 6/18/2015 100 500,000.00 0.600 500,000.00 0.00 Bank Sewer 10: CDARS 0.9Independence General 6/16/2016 1016754591 Buy 6/19/2014 6/16/2016 100 500,000.00 0.900 500,000.00 0.00 Bank Fund of 3G Bank Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Pledged Collateral Reconciliation Report June 30, 2014 Account Number 201-0419505 201-0419513 001-3042841 179-0121790 807-1613395 818-4567843 280-7409871 Account Name Operating Payroll Fund Sweep Account EMS Payments Credit Card Account Alvin ISO Health Claims Amount $ 57,084,034.90 8,316.995.89 223,302.01 Total of Bank Balances $ 65,624,332.80 Pledged Collateral for City FDIC Insurance Total Collateral 90,009,763.65 250,000.00 $ Over (Under) Collateralized $ Total % Collateralized Bank Account Number Account Name Wells Fargo 100-7284258 Development Authority Bank Regions Account Number 6180003939 6180003948 M UnvestmenLMInvestmenl ReportstCiy or PeartandUnvestment Report City atr 0614 Total of Bank Balances Pledged Collateral for DAP FDIC Insurance Total Collateral $ Over (Under) Collateralized $ Total % Collateralized 90,259,763.65 24,636,430.85 137.5% Amount 922,013.13 $ 922,013.13 1,050,329.18 250,000.00 1,300,329.18 378,316.05 141.0% $ 0.29 327.48 Total of Bank Balances $ Regions Trust Collateral $ FDIC Insurance Over (Under) Collateralized' $ Total % Collateralized Total $ Over (Under) Collateralized $ Total % Collateralized Status 327.77 250,000.00 249,672.23 76273.0% 25,013,746.90 138.0% Collateralized 3-?