Loading...
HomeMy WebLinkAboutR2013-127 2013-08-26RESOLUTION NO. R2013-127 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS, ACCEPTING THE CITY'S INVESTMENT REPORT FOR THE QUARTER ENDING JUNE 2013. 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 2013. PASSED, APPROVED, AND ADOPTED this 26th day of August, A.D., 2013. TOM REID MAYOR ATTEST: APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY Resolution No. R2013-127 Exhibit "A" City of Pearland Quarterly Investment Report Mar31, 2013 -Jun 30, 2013 portfolio at Mir 31 2013 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 $ 96,039,159.55 96,046,695.73 63,164.36 102,165.40 7,536.18 (8,864.71) 106 Days (4,438,539.85) 0.20% 0.14% 0.16% Portfolio at Jun 30, 2013 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.20% 0.13% 0.12% $ 86,244,583.15 86,216,415,81 27,726.47 144,544.13 (28,167.34) (35,703.52) 118 Days (9,830,279.92) 0.20% 0.15% 0.12% 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: O OLk Claire Bogard Director of Finance Rick /.e •aard Assistant Directo of Finance Fatima`Uwakwe Accounting Supervisor Summary by Type June 30, 2013 Description Face Amount \ Shares Cost Value Book Value MarketValue YTM @ Cost Days To Maturity Cash $ 65,271,796.68 $ 65,271,796.68 $ 65,271,796.68 $ 65,271,796.68 0.14% 1 CD 9,431,186.79 9,431,186.79 9,431,186.79 9,400,873.63 0.45% 553 FFCB 5,500,000.00 5,533,816.03 5,517,150.27 5,513,992.50 0.28% 444 FHLB 2,000,000.00 2,016,250.00 2,011,287.99 2,011,651.00 0.31% 516 FHLMC 2,000,000.00 1,998,536.00 1,999,531.02 2,001,990.00 0.40% 412 FNMA 2,000,000.00 2,030,830.00 2,013,630.40 2,016,112.00 0.41% 310 Total/Average $ 86,202,983.47 $ 86,282,415.50 $ 86,244,583.15 $ 86,216,415.81 0.20% 118 FFCB 7% CD 11% Group Portfolio Holdings by Type FHLB 2% FHLMC FNMA 2%_ 2% Cash 76% 70,000,000 60,000,000 50,000,000 +- 40,000,000 -- 30,000,000 .r 20,000,000 +— 10,000,000 Book Value by Maturity 1- 30 Days 31.60 Days 61.90 DaYs91. 120 Dayls21. 180 Days > 180 DaYs Z Interest Rates Date 1 mo :Limo 6 mo 1 yr 2 yr 3_yr 5 yr 7 yr 10 yr ALA 30 yr 3/28/2013 0.04 0.07 0.11 0.14 0.25 0.36 0.77 1.24 1.87 2.71 3.10 6/30/2013 0.02 0.04 0.10 0.1 0.36 0.66 1.41 1.96 2.52 3.22 3.52 Yield Curve Comparison 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 r 0.00 r -- 1 mo 0.35% 0.30% 0.25% 0.20% 0.15% - 0.10% 0.05% 0.00% C 'y's Weighted Avg Yield .20% 118 Day Average Maturity 3ro 6mo 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr 20 yr 30 yr -4-- 3/28/2013 -4F- 6/30/2013 Portfolio vs. Benchmarks Jul -12 Auk -12 Sep -12 Oct -12 Nov -12 Dec -12 Jan -13 Feb -13 Mar -13 Apr -13 May -13 Jun -13 —4—Port Total --*-1 Yr T -Bill -`4,- Agency Note 3 City of Pearland Quarterly Investment Report Report Format: By CUSIP Group By: Security Type Portfolio/Report Group: Report Group: Pearland Begin Date: 3/31/2013, End Date: 6/30/2013 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -By CASH Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash WFSWEEP 10: General 0.140 N/A 15,442,384.83 578,648.50 2,653,932.37 0.00 0.00 13,367,100.96 5,154.79 Fund 17: Municipal WFSWEEP Court 0.140 N/A 141,839.79 1,272.11 11,183.43 0.00 0.00 131,928.47 49.81 Security 18: City WFSWEEP Wide 0.140 N/A 79,638.64 10,305.24 1,101.00 0.00 0.00 88,842.88 30.98 Donation WFSWEEP 19: Court 0.140 N/A 262,672.17 12,976.06 0.00 0.00 0.00 275,648.23 97.13 Technology WFSWEEP 20: Debt 0.140 N/A 13,387,679.21 759,771.28 3,867,917.35 0.00 0.00 10,279,533.14 4,059.94 Services 23: Court WFSWEEP Juvenile 0.140 N/A 47,986.90 7,906.21 0.00 0.00 0.00 55,893.11 19.26 Mgmt WFSWEEP 30: Water & 0.140 N/A 9,285,996.71 3,475,696.27 0.00 0.00 0.00 12,761,692.98 2,708.64 Sewer WFSWEEP 31: 0.140 N/A 369,171.16 95,109.94 74,881.82 0.00 0.00 389,399.28 154.40 Solidwaste WFSWEEP 35: Street 0.140 N/A 531,550.36 231,483.15 0.00 0.00 0.00 763,033.51 218.56 Assessment WFSWEEP 42: Utility 0.140 N/A 5,838,900.26 309,793.58 257,305.42 0.00 0.00 5,891,388.42 2,167.40 Impact Fee WFSWEEP 43: Regional 0.140 N/A 10,436.30 3.74 0.00 0.00 0.00 10,440.04 3.74 Detention 44: Shadow WFSWEEP Creek 0.140 N/A 1,576,115.48 186,966.62 306,449.25 0.00 0.00 1,456,632.85 587.62 Impact 45: WFSWEEP Hotel/Motel 0.140 N/A 1,583,428.27 192,863.63 257,246.77 0.00 0.00 1,519,045.13 588.91 Occupancy WFSWEEP 46: Park 0.140 N/A 109,385.17 8,215.31 2,387.79 0.00 0.00 115,212.69 40.12 Donations 1 of8 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 Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash 47: Park & WFSWEEP Rec 0.140 N/A 675,251.22 73,117.62 13,392.15 0.00 0.00 734,976.69 249.69 Development WFSWEEP 49: Tree 0.140 N/A 16,364.23 59,892.96 490.00 0.00 0.00 75,767.19 12.96 Trust Fund WFSWEEP 50: Capital 0.140 N/A 568,830.75 264,875.54 1,007,533.48 0.00 0.00 -173,827.19 36.95 Projects WFSWEEP 55: Sidewalk 0.140 N/A 208,784,96 16,929.40 0.00 0.00 0.00 225,714.36 76.90 Fund 60: Police WFSWEEP State 0.140 N/A 212,396.86 73.54 11,191.96 0.00 0.00 201,278.44 73.54 Seizure WFSWEEP 62: Federal 0.140 N/A 32,184.02 15,684.09 0.00 0.00 0.00 47,868.11 17.10 Police Fund 64: 1998 WFSWEEP Cert of 0.140 N/A 844,902.87 303.03 0.00 0.00 0.00 845,205.90 303.03 Obligation 67: 2003 WFSWEEP Revenue 0.140 N/A 6,646,213.55 392,475.04 839,306.67 0.00 0.00 6,199,381.92 2,167.30 Bonds 68: 2001 WFSWEEP Cert of 0.140 N/A 541,746.57 45,932.09 185,818.77 0.00 0.00 401,859.89 186.49 Obligation 70: 2005 WFSWEEP Refunding / 0.140 N/A 1,454,116.38 392.32 592,128.58 0.00 0.00 862,380.12 392.32 Mobility WFSWEEP 95: Property 0.140 N/A 92,940.31 15,396.27 360,573.65 0.00 0.00 -252,237.07 24.33 liability 97: WFSWEEP Employee 0.140 N/A 7,554.13 25,453.50 16,094.81 0.00 0.00 16,912.82 8.17 Benefit Trust 99: COP WF9871 Health 0.140 N/A 478,377.75 5,559.77 157,984.15 0.00 0.00 325,953.37 123.62 Claims Fund 99: COP WFSWEEP Health 0.140 N/A 368,285.45 312,309.31 180,492.03 0.00 0.00 500,102.73 0.00 Claims Fund WFSWEEP 2101: Grant 0.140 N/A 8,983.55 0.14 28,288.35 0.00 0.00 -19,304.66 0.14 Fund WFSWEEP Z105: 2007 0.140 N/A 187.69 0.06 0.00 0.00 0.00 187.75 0.06 CDBG Fund 2 of 8 S 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 Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash WFSWEEP WFSWEEP WFSWEEP WFSWEEP WFSWEEP WFSWEEP WFSWEEP WFSWEEP WFSWEEP WFSWEEP WFSWEEP WFSWEEP WFSWEEP WFSWEEP Sub Total/Average Cash CERTIFICATE OF DEPOSIT 2106: 2008 CDBG Fund Z107: 2009 CDBG Fund Z108: 2010 CDBG Fund Z109: 2011 CDBG Fund Z110: 2012 CDBG Fund 0.140 0.140 0.140 0.140 0.140 Z116: CDBG Recovery 0.140 Fund Z140: U of H 0.140 Fund Z145: Municipal 0.140 Channel Z200: 2006 Cert of Obligation Z201: 2007 Cert of Obligation Z202: 2007A Gen Obligation Z203: 2009 Gen Obligation Z301: W/S Pay As U Go CIP Z302: MUD 4 Capital Programs 0.140 N/A 1.14 0.00 0.00 0.00 0.00 1.14 0.00 N/A 15.61 0.00 0.00 0.00 0.00 15.61 0.00 N/A 0.05 0.00 0.00 0.00 0.00 0.05 0.00 N/A -184.24 0.00 9,141.30 0.00 0.00 -9,325.54 0.00 N/A -4,481.82 11,377.22 0.00 0.00 0.00 6,895.40 0.00 N/A 7,40 0.00 0.00 0.00 0.00 7.40 0.00 N/A 22,232.56 4,156.35 47,288.38 0.00 0.00 -20,899.47 3.03 N/A 157,478.72 52.89 15,693.25 0.00 0.00 141,838.36 52.89 N/A 1,574,582.54 544.54 58,834.47 0.00 0.00 1,516,292.61 544.54 0.140 N/A 1,227,677.34 222.24 862,353.15 0.00 0.00 365,546.43 222.24 0.140 N/A 3,169,811.00 1,004.92 667,235.77 0.00 0.00 2,503,580.15 1,004.92 0.140 N/A 1,216,336.90 159,351.29 1,034,983.29 0.00 0.00 340,704.90 267.59 0.140 N/A 1,966,884.54 9,758.42 4,202.49 0.00 0.00 1,972,440.47 705.51 0.140 N/A 1,614,590.06 352.15 258,255.10 0.00 0.00 1,356,687.11 352.15 0.140 71,769,257.34 7,286,226.34 13,783,687.00 0.00 0.00 65,271,796.68 22,706.77 3ot£ 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 First Commercial 31984GCN7 10: General 0.300 8/30/2013 248,000.00 0.00 0.00 0,00 0.00 248,000.00 248.68 Bank 0.3 Fund 8/30/2013 Synovus Bank 10: General GA 0.5 87164D8V1 0.500 11/28/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 309.15 Fund 11/28/2014 Townebank 10: General Portsmouth VA 89214PAP4 0.400 6/1/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 81.53 Fund 0.4 6/1/2015 BBCN Bank LA CD073296AT2 10: General 0.250 2/7/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 154.58 0.25 2/7/2014 Fund CDARS 0.6 CD1013981872 10: General 0.600 6/19/2014 500,000.00 0.00 0.00 0.00 0.00 500,000.00 -739.73 6/19/2014 Fund CDARS 0.5 CD1014682593 10: General 0.500 12/19/2013 500,000.00 0.00 0.00 0.00 0.00 500,000.00 623.29 12/19/2013 Fund Cardinal Bank CD14147VDM5 10: General 0.500 5/17/2016 0.00 248,000.00 0.00 0.00 0.00 248,000.00 149.47 0.5 5/17/2016 Fund Moody National 10: General Bank 0.5 CD1730 0.500 11/30/2013 0.00 246,186.79 0.00 0.00 0.00 246,186.79 104.55 Fund 11/30/2013 Discover Bank CD254671KH2 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 Niagara 10: General Bank 0.25 CD33583CDH9 0.250 11/4/2013 0.00 248,000.00 0.00 0.00 0.00 248,000.00 98.52 Fund 11/4/2013 Gorham 10: General Savings Bank CD383052CN5 0.250 2/6/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 154.58 Fund 0.25 2/6/2014 Mizuho Bank CD60688TLM9 10: General 0.250 5/8/2014 0.00 248,000.00 0.00 0.00 0.00 248,000.00 90.03 0.25 5/8/2014 Fund Moody National 10: General Bank 0.5 CD7130 5/30/2013 245,577.26 0.00 245,577.26 0.00 0.00 0.00 202.48 Fund 5/30/2013 Southwest 10: General Bank Ft Worth CD844772AA1 0.300 2/27/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 185.50 Fund 0.3 2/27/2015 Valley Bank 10: General Roanoke 0.3 CD91935VANO 0.300 7/30/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 185.49 Fund 7/30/2014 -7 4 of 8 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 Key Bank Ohio 20: Debt 0.35 CD49306SRE8 0.350 8/27/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 216.40 Services 8/27/2014 Mechanics Savings Bank CD583686BC3 20: Debt 0.350 3/20/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 216.40 0.35 Services 3/20/2015 AMERICAN NATIONAL CD02771PKZ9 30: water & 5/3/2013 248,000.00 0.00 248,000.00 0.00 0.00 0.00 56.05 BANK 0.25 Sewer 5/3/2013 Bay Cities Bank 30: Water & 0.5 CDO7203QBR2 0.500 12/12/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 309.14 Sewer 12/12/2014 CDARS 0.5 CD1013981856 30: Water & 6/20/2013 500,000.00 0.00 500,000.00 0.00 0.00 0.00 561.06 6/20/2013 Sewer CDARS 0.5 CD1013981856B 30: Water & 0.500 6/19/2014 0.00 500,000.00 0.00 0.00 0.00 500,000.00 68.49 6/19/2014 Sewer First Farmers 30: Water & Bank 0.5 CD320165FZ1 0.500 5/3/2016 0.00 245,000.00 0.00 0.00 0.00 245,000.00 194.66 Sewer 5/3/2016 Fox Chase Bank 30: Water & 0.65 CD35137QAN4 0.650 6/27/2016 0.00 248,000.00 0.00 0.00 0.00 248,000.00 13.25 Sewer 6/27/2016 Goldman Sachs 30: Water & Bank 0.6 CD38147JAA0 0.600 2/20/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 370.98 Sewer 2/20/2015 SAFRA NATIONAL CO786580350 30: Water & 0.600 5/5/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 370.98 BANK 0.6 Sewer 5/5/2014 BMW Bank of 42: Utility NA 0.85 CD05568P2Q9 0.850 6/8/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 525.55 Impact Fee 6/8/2015 College Savings 42: Utility Bank 0.55 CD19443PAP4 0.550 6/20/2016 0.00 248,000.00 0.00 0.00 0.00 248,000.00 41.11 Impact Fee 6/20/2016 Private Bank & 42: Utility Trust 0.35 CD74267GTC1 0.350 5/11/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 121.28 Impact Fee 5/11/2015 Sterling Savings 42: Utility Bank 0.35 CD8595316A8 0.350 2/23/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 216.40 Impact Fee 2/23/2015 5 of 8 8 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -By Marlin Business 44: Shadow Bank 0.55 CD57116AGF9 Creek 0.550 6/14/2016 0.00 248,000.00 0.00 0.00 0,00 248,000.00 59.79 6/14/2016 Impact 44: Shadow Sovereign Bank 0.2 7/30/2013 CD84603M3N4 Creek 0.200 7/30/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 123.66 Impact Colonial Virginia 45: Bank 0.55 CD196121AM9 Hotel/Motel 0.550 6/24/2016 0.00 248,000.00 0.00 0.00 0.00 248,000.00 18.68 6/24/2016 Occupancy First Natial Bank 45: WI 0.25 CD321086FE5 HotevMotel 0.250 1/31/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 154.58 1/31/2014 Occupancy Asheville 67: 2003 Savings Bank CD04407RA)0 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 Medallion Bank 67: 2003 UT 0.4 CD584038B62 Revenue 0.400 11/3/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 157.63 11/3/2015 Bonds MIZUHO CORP 67: 2003 BANK 0.3 CD60688TBR9 Revenue 5/2/2013 248,000.00 0.00 248,000.00 0.00 0.00 0.00 65.23 5/2/2013 Bonds First State Bank 70: 2005 - WV 0.35 CD33648FHR9 Refunding / 0.350 12/3/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 216.40 12/3/2014 Mobility Celtic Bank 0.6 Z202: 6J28/2016 CD15118RJD0 2007A Gen 0.600 6/28/2016 0.00 248,000.00 0.00 0.00 0.00 248,000.00 8.15 Obligation DeWitt Bank Z301: W/S and Trust 0.5 CO241888812 Pay As U Go 0.500 6/20/2016 0.00 248,000.00 0.00 0.00 0.00 248,000.00 20.38 6/20/2016 CIP Sub Total/Average 0.445 6,705,577.26 3,967,186.79 1,241,577.26 0.00 0.00 9,431,186.79 6,479.93 Certificate Of Deposit FFCB BOND FFCB 0.75 5/2/2013 FFCB 0.32 3/12/2015-12 31331KJQ4 3133EAU30 10: General Fund 10: General Fund 5/2/2013 1,000,000.00 0.320 3/12/2015 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 645.83 1,000,000.00 791.11 6 of 8 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 FFCB 0.3 7/18/2014 FFCB 0.25 12/24/2014 FFCB 0.3 1/9/2015-13 FFCB 2.125 2/10/2014 3133EAYL6 3133ECAV6 3133EA3U0 31331JDY6 FFCB 0.48 3133EAVJ4 12/26/2014-13 Sub Total/Average FFCB Bond FHLB BOND FHLB 3.625 5/29/2013 FHLB 1.15 10/30/2014 FHLB 3.625 5/29/2013 3133XQU34 3133743W8 3133XQU34 FHLB 0.32 313381G58 12/26/2014-13 10: General Fund 20: Debt Services 42: Utility Impact Fee 67: 2003 Revenue Bonds 67: 2003 Revenue Bonds 0.285 7/18/2014 1,000,193.85 0.273 12/24/2014 999,600.41 0.300 1/9/2015 1,000,000.00 0.230 2/10/2014 1,524,349.02 12/26/2014 1,000,000.00 0.00 0.00 0.00 -36.94 1,000,156.91 704.73 0.00 0.00 57.08 0.00 999,657.49 675.14 0.00 0.00 0.00 0.00 1,000,000.00 741.67 0.00 0.00 0.00 -7,013.15 1,517,335.87 867.05 0.00 1,000,000.00 0.00 10: General Fund 30: Water & Sewer 30: Water & Sewer 67: 2003 Revenue Bonds 0.277 7,524,143.28 5/29/2013 1,005,0 31.8 2 0.300 10/30/2014 1,013,380.97 5/29/2013 1,005,031.82 0.320 12/26/2014 1,000,000.00 0.00 0.00 1,133.33 0.00 2,000,000.00 57.08 -7,050.09 5,517,150.27 5,558.86 0.00 1,000,000.00 0.00 -5,031.82 0.00 808.46 0.00 0.00 0.00 -2,092.98 1,011,287.99 782.02 0.00 1,000,000.00 0.00 -5,031.82 0.00 808.46 0.00 0.00 0.00 0.00 1,000,000.00 791.12 Sub Total/Average FHLB Bond FHLMC BOND FHLMC 0 4/1/2013 FHLMC 0.375 4/28/2014 FHLMC 0.35 12/5/2014 313397DU2 3134G3SB7 3134G3H78 Sub Total/Average 10: General Fund 10: General Fund 67: 2003 Revenue Bonds 0.310 4,023,444.61 4/1/2013 999,995.28 0.467 4/28/2014 999,020.91 0.330 12/5/2014 1,000,334.19 0.00 2,000,000.00 0.00 -12,156.62 2,011,287.99 3,190.06 0.00 1,000,000.00 4.72 0.00 0.00 4.72 0.00 0.00 225.16 0.00 999,246.07 1,152.24 0.00 0.00 0.00 -49.24 1,000,284.95 816.04 0.398 2,999,350.38 0.00 1,000,000.00 229.88 -49.24 1,999,531.02 1,973.00 7 of 8 lt) Ending Portfolio YTM CD Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV FHLMC Bond FNMA BOND FNMA 0.5 10/30/2014-13 FNMA 1.3 11/17/2014 FNMA 1.05 10/22/2013 3136GOFF3 3136FPWZ6 31398A4S8 10: General Fund 30: Water& Sewer 30: Water& Sewer 10/30/2014 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 416.67 0.462 11/17/2014 1,013,551.67 0.00 0.00 0.00 -2,058.19 1,011,493.48 1,155.70 0.361 10/22/2013 1,003,835.01 0.00 0.00 0.00 -1,698.09 1,002,136.92 897.74 Sub Total/Average FNMA Bond 0.411 3,017,386.68 0.00 1,000,000.00 0.00 -3,756.28 2,013,630.40 2,470.11 Total / Average 0.198 96,039,159.55 11,253,413.13 21,025,264.26 286.96 -23,012.23 86,244,583.15 42,378.73 8 of 8 City of Pearland Quarterly Investment Report at Quarterend Report Format: By Transaction Group By: Security Type Portfolio/Report Group: Report Group: Pearland As of 6/30/2013 Portfolio Settlement Maturity YTM @ Face Days To Accrued 0/0 of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash WFSWEEP 10: General 5/31/2006 N/A 0.140 13,367,100.96 13,367,100.96 13,367,100.96 13,367,100.96 1 15.51 Fund 17: Municipal WFSWEEP Court 5/31/2006 N/A 0.140 131,928.47 131,928.47 131,928.47 131,928.47 1 0.15 Security 18: City WFSWEEP Wide 5/31/2006 N/A 0.140 88,842.88 88,842.88 88,842.88 88,842.88 1 0.10 Donation WFSWEEP 19: Court 5/31/2006 N/A 0.140 275,648.23 275,648.23 275,648.23 275,648.23 1 0.32 Technology WFSWEEP 20: Debt 5/31/2006 N/A 0.140 10,279,533.14 10,279,533.14 10,279,533.14 10,279,533.14 1 11.92 Services 23: Court WFSWEEP Juvenile 9/15/2009 N/A 0.140 55,893.11 55,893.11 55,893.11 55,893.11 1 0.06 Mgmt WFSWEEP 30: Water & 5/31/2006 N/A 0.140 12,761,692.98 12,761,692.98 12,761,692.98 12,761,692.98 1 14.80 Sewer WFSWEEP 31: 12/1/2006 N/A 0.140 389,399.28 389,399.28 389,399.28 389,399.28 1 0.45 Solidwaste WFSWEEP 35: Street 5/31/2006 N/A 0.140 763,033.51 763,033.51 763,033.51 763,033.51 1 0.89 Assessment WFSWEEP 42: Utility 5/31/2006 N/A 0.140 5,891,388.42 5,891,388.42 5,891,388.42 5,891,388.42 1 6.83 Impact Fee WFSWEEP 43: Regional 5/31/2006 N/A 0.140 10,440.04 10,440.04 10,440.04 10,440.04 1 0.01 Detention 44: Shadow WFSWEEP Creek 5/31/2006 N/A 0.140 1,456,632.85 1,456,632.85 1,456,632.85 1,456,632.85 1 1.69 Impact 45: WFSWEEP Hotel/Motel 5/31/2006 N/A 0.140 1,519,045.13 1,519,045.13 1,519,045.13 1,519,045.13 1 1.76 Occupancy WFSWEEP 46: Park 5/31/2006 N/A 0.140 115,212.69 115,212.69 115,212.69 115,212.69 1 0.13 Donations 47: Park & WFSWEEP Rec 5/31/2006 N/A 0.140 734,976.69 734,976.69 734,976.69 734,976.69 1 0.85 1 of 7 Portfolio Settlement Maturity YTM © Face Days To Accrued 0/0 of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Cash Welts Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Development WFSWEEP 49: Tree 5/31/2006 Trust Fund WFSWEEP 50: Capital 5/31/2006 Projects WFSWEEP 55: Sidewalk 5/31/2006 Fund 60: Police WFSWEEP State 5/31/2006 Seizure WFSWEEP 62: Federal 5/31/2006 Police Fund 64: 1998 WFSWEEP Cert of 5/31/2006 Obligation 67: 2003 WFSWEEP Revenue 5/31/2006 Bonds 68: 2001 WFSWEEP Cert of 5/31/2006 Obligation 70: 2005 WFSWEEP Refunding / 5/31/2006 Mobility WFSWEEP 95: Property 10/31/2006 Liability 97: WFSWEEP Employee 9/1/2007 Benefit Trust 99: COP WFSWEEP Heath 9/15/2010 Claims Fund 99: COP WF9871 Health 7/21/2010 Claims Fund WFSWEEP 2101: Grant 5/31/2006 Fund WFSWEEP Z105: 2007 5/1/2007 CDBG Fund WFSWEEP Z106: 2008 3/15/2009 CDBG Fund N/A 0.140 75,767.19 75,767.19 75,767.19 75,767.19 1 N/A 0.140 -173,827.19 -173,827.19 -173,827.19 -173,827.19 1 N/A 0.140 225,714.36 225,714.36 225,714.36 225,714.36 1 N/A 0.140 201,278.44 201,278.44 201,278.44 201,278.44 1 N/A 0.140 47,868.11 47,868.11 47,868.11 47,868.11 1 N/A 0.140 845,205.90 845,205.90 845,205.90 845,205.90 1 N/A 0.140 6,199,381.92 6,199,381.92 6,199,381.92 6,199,381.92 1 N/A 0.140 401,859.89 401,859.89 401,859.89 401,859.89 1 N/A 0.140 862,380.12 862,380.12 862,380.12 862,380.12 1 N/A 0.140 -252,237.07 -252,237.07 -252,237.07 -252,237.07 1 N/A 0.140 16,912.82 16,912.82 16,912.82 16,912.82 1 N/A 0.140 500,102.73 500,102.73 500,102.73 500,102.73 1 N/A 0.140 325,953.37 325,953.37 325,953.37 325,953.37 1 N/A 0.140 -19,304.66 -19,304.66 -19,304.66 -19,304.66 1 N/A 0.140 187.75 187.75 187.75 187.75 1 N/A 0.140 1.14 1.14 1.14 1.14 1 0.09 -0.20 0.26 0.23 0.06 0.98 7.19 0.47 1.00 -0.29 0.02 0.58 0.38 -0.02 0.00 0.00 2 of 7 Portfolio Settlement Maturity YTM @ Face Days To Accrued 0/0 of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Wells Fargo WFSWEEP Z107: 2009 11/1/2009 N/A 0.140 15.61 15.61 15.61 15.61 1 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP 2108:2010 11/1/2010 N/A 0.140 0.05 0.05 0.05 0.05 1 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z109: 2011 12/1/2011 N/A 0.140 -9,325.54 -9,325.54 -9,325.54 -9,325.54 1 -0.01 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z110: 2012 11/15/2012 N/A 0.140 6,895.40 6,895.40 6,895.40 6,895.40 1 0.01 Sweep Cash CDBG Fund Z116: CDBG Wells Fargo Sweep Cash WFSWEEP Recovery 7/31/2009 N/A 0.140 7.40 7.40 7.40 7.40 1 0.00 Fund Wells Fargo Z140: U of H WFSWEEP 12/1/2009 N/A 0.140 -20,899.47 -20,899.47 -20,899.47 -20,899.47 1 -0.02 Sweep Cash Fund Wells Fargo Z145: Sweep Cash WFSWEEP Municipal 4/15/2012 N/A 0.140 141,838.36 141,838.36 141,838.36 141,838.36 1 0.16 Channel Wells Fargo Z200: 2006 Sweep Cash WFSWEEP Cert of 6/30/2006 N/A 0.140 1,516,292.61 1,516,292.61 1,516,292.61 1,516,292.61 1 1.76 Obligation Wells Fargo Z201: 2007 Sweep Cash WFSWEEP Cert of 8/31/2006 N/A 0.140 365,546.43 365,546.43 365,546.43 365,546.43 1 0.42 Obligation Wells Fargo Z202: Sweep Cash WFSWEEP 2007A Gen 12/31/2007 N/A O.la0 2,503,580.15 2,503,580.15 2,503,580.15 2,503,580.15 1 2.90 Obligation Z203: 2009 WeltsFargo WFSWEEP Gen 10/30/2008 N/A 0.140 340,704.90 340,704.90 340,704.90 340,704.90 1 0.40 Sweep Cash Obligation Z301: W/S Wells Fargo WFSWEEP Pay As U Go 12/31/2007 N/A 0.140 1,972,440.47 1,972,440.47 1,972,440.47 1,972,440.47 Sweep Cash 2.29 1 CIP Z302; MUD Welk Fargo WFSWEEP 4 Capital Sweep Cash 2/1/2013 N/A 0.140 1,356,687.11 1,356,687.11 1,356,687.11 1,356,687.11 1 1.57 Programs Sub Total / 0.140 65,271,796.68 65,271,796.68 65,271,796.68 65,271,796.68 1 0.00 75.72 Average Certificate Of Deposit Valley Bank 10: General Roanoke 0.3 CD91935VANO 1/30/2013 7/30/2014 0.300 248,000.00 248,000.00 248,000.00 247,529.30 395 307.79 0.29 Fund 7/30/2014 BBCN Bank LA CD073296AT2 10: General 2/8/2013 2/7/2014 0.250 248,000.00 248,000.00 248,000.00 247,650.07 222 37.37 0.29 0.25 2/7/2014 Fund 3 of 7 Portfolio Settlement Maturity YTM @ Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio CDARS 0.5 CD1014682593 10: General 12/20/2012 12/19/2013 0.500 500,000.00 500,000.00 500,000.00 500,000.00 172 1,315.07 0.58 12/19/2013 Fund First Niagara 10: General Bank 0.25 CD33583COH9 5/3/2013 11/4/2013 0.250 248,000.00 248,000.00 248,000.00 247,785.48 127 98.52 0.29 Fund 11/4/2013 Southwest 10: General Bank Ft Worth CD844772AA1 2/27/2013 2/27/2015 0.300 248,000.00 248,000.00 248,000.00 247,293.45 607 6.12 0.29 Fund 0.3 2/27/2015 CDARS 0.6 C01013981872 10: General 6/21/2012 6/19/2014 0.600 500,000.00 500,000.00 500,000.00 500,000.00 354 0.00 0.58 6/19/2014 Fund Cardinal Bank CD14147VDM5 10: General 5/17/2013 5/17/2016 0.500 248,000.00 248,000.00 248,000.00 245,508.59 1052 44.16 0.29 0.5 5/17/2016 Fund Gorham 10: General Savings Bank CD383052CN5 2/6/2013 2/6/2014 0.250 248,000.00 248,000.00 248,000.00 247,551.12 221 40.77 0.29 Fund 0.25 2/6/2014 Moody National 10: General Bank 0.5 CD1730 5/30/2013 11/30/2013 0.500 246,186.79 246,186.79 246,186.79 246,186.79 153 104.55 0.29 Fund 11/30/2013 Discover Bank CD254671KH2 10: General 2/20/2013 2/20/2015 0.500 248,000.00 248,000.00 248,000.00 247,318.25 600 441.64 0.29 0.5 2/20/2015 Fund Synovus Bank 10: General GA 0.5 87164DBV1 11/30/2012 11/28/2014 0.500 248,000.00 248,000.00 248,000.00 248,613.30 516 105.32 0.29 Fund 11/28/2014 Townebank 10: General Portsmouth VA 89214PAP4 5/31/2013 6/1/2015 0.400 248,000.00 248,000.00 248,000.00 246,752.56 701 81.53 0.29 Fund 0.4 6/1/2015 First Commercial 31984GCN7 10: General 8/30/2012 8/30/2013 0.300 248,000.00 248,000.00 248,000.00 247,921.14 61 0.00 0.29 Bank 0.3 Fund 8/30/2013 Mizuho Bank CD60688TLM9 10: General 5/8/2013 5/8/2014 0.250 248,000.00 248,000.00 248,000.00 247,827.14 312 90.03 0.29 0.25 5/8/2014 Fund Key Bank Ohio 20: Debt 0.35 CD49306SRE8 2/27/2013 8/27/2014 0.350 248,000.00 248,000.00 248,000.00 247,651.06 423 292.50 0.29 Services 8/27/2014 Mechanics Savings Bank CD5836868C3 20: Debt 3/20/2013 3/20/2015 0.350 248,000.00 248,000.00 248,000.00 247,049.17 628 23.78 0.29 0.35 Services 3/20/2015 Goldman Sachs 30: Water & Bank 0.6 CD38147JAA0 2/20/2013 2/20/2015 0.600 248,000.00 248,000.00 248,000.00 247,078.68 600 529.97 0.29 Sewer 2/20/2015 SAFRA 30: Water & NATIONAL CD786580J50 Sewer 8/1/2012 5/5/2014 0.600 248,000.00 248,000.00 248,000.00 248,669.85 309 236.45 0.29 4 of 7 Portfolio Settlement Maturity YTM @ Face Days To Accrued 0/0 of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio BANK 0.6 5/5/2014 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,601.40 530 61.15 0.29 Sewer 12/12/2014 CDARS 0.5 CD1013981856B 30: water & 6/20/2013 6/19/2014 0.500 500,000.00 500,000.00 500,000.00 500,000.00 354 68.49 0.58 6/19/2014 Sewer Fox Chase Bank 30: Water & 0.65 CD35137QAN4 6/27/2013 6/27/2016 0.650 248,000.00 248,000.00 248,000.00 245,022.02 1093 13.25 0.29 Sewer 6/27/2016 First Farmers 30: Water & Bank 0.5 CD320165FZ1 5/3/2013 5/3/2016 0.500 245,000.00 245,000.00 245,000.00 242,742.57 1038 90.62 0.28 Sewer 5/3/2016 Private Bank & 42: Utility Trust 0.35 CD74267GTC1 Impact Fee 5/10/2013 5/11/2015 0.350 248,000.00 248,000.00 248,000.00 246,839.86 680 121.28 0.29 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 247,307.34 603 304.39 0.29 2/23/2015 College Savings 42: Utility Bank 0.55 CD19443PAP4 Impact Fee 6/19/2013 6/20/2016 0.550 248,000.00 2.48,000.00 248,000.00 245,094.93 1086 41.11 0.29 6/20/2016 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,623.22 708 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 245,154.70 1080 59.79 0.29 6/14/2016 Impact Sovereign Bank 44: Shadow 0.2 7/30/2013 CD84603M3N4 Creek 1/30/2013 7/30/2013 0.200 248,000.00 248,000.00 248,000.00 247,944.94 30 205.19 0.29 Impact First Natial Bank 45: WI0.25 CD321086FE5 Hotel/Motel 1/31/2013 1/31/2014 0.250 248,000.00 248,000.00 248,000.00 247,566.74 215 49.26 0.29 1/31/2014 Occupancy Colonial Virginia 45: Bank 0.55 CD196121AM9 Hotel/Motel 6/25/2013 6/24/2016 0.550 248,000.00 248,000.00 248,000.00 245,047.81 1090 18.68 0.29 6/24/2016 Occupancy Asheville 67: 2003 Savings Bank CD04407RAJ0 Revenue 2/28/2013 3/27/2015 0.350 248,000.00 248,000.00 248,000.00 247,008.50 635 4.76 0.29 0.35 Bonds 3/27/2015 Medallion Bank 67: 2003 UT 0.4 CD58403BB62 Revenue 5/3/2013 11/3/2015 0.400 248,000.00 248,000.00 248,000.00 246,680.64 856 157.63 0.29 11/3/2015 Bonds 5 of 7 1b Portfolio Settlement Maturity YTM @ Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio 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 248,609.83 521 64.21 0.29 12/3/2014 Mobility Celtic Bank 0.6 Z202: 6/28/2016 CD15118RJD0 2007A Gen 6/28/2013 6/28/2016 0.600 248,000.00 248,000.00 248,000.00 245,081.54 1094 8.15 0.29 Obligation DeWitt Bank Z301: W/5 and Trust 0.5 CD241888BT2 Pay As U Go 6/24/2013 6/20/2016 0.500 248,000.00 248,000.00 248,000.00 245,161.64 1086 20.38 0.29 6/20/2016 CIP Sub Total / Average FFCB Bond FFCB 0.32 3/12/2015-12 FFCB 0.3 7/18/2014 FFCB 0.25 12/24/2014 FFCB 0.3 1/9/2015 13 FFCB 2.125 2/10/2014 3133EAU30 3133EAYL6 3133ECAV6 3133EA3U0 31331JDY6 10: General Fund 10: General Fund 20: Debt Services 42: Utility Impact Fee 67: 2003 Revenue Bonds Sub Total / Average FHLB Bond FHLB 1.15 10/30/2014 3133743W8 FHLB 0.32 313381G58 12/26/2014-13 Sub Total / Average FHLMC Bond FHLMC 0.375 4/28/2014 FHLMC 0.35 12/5/2014 0.445 9,431,186.79 9,431,186.79 9,431,186.79 9,400,873.63 553 5,176.74 10.94 10/31/2012 3/12/2015 0.320 1,000,000.00 1,000,000.00 1,000,000.00 998,730.00 620 960.00 1.16 8/1/2012 7/18/2014 0.285 1,000,000.00 1,000,293.48 1,000,156.91 1,000,585.00 383 1,350.00 1.16 1/28/2013 12/24/2014 0.273 1,000,000.00 999,560.00 999,657.49 998,418.00 542 41.67 1.16 11/29/2012 1/9/2015 0.300 1,000,000.00 1,000,000.00 1,000,000.00 999,218.00 558 1,425.00 1.16 11/29/2012 2/10/2014 0.230 1,500,000.00 1,533,962.55 1,517,335.87 1,517,041.50 225 12,395.83 1.74 0.277 5,500,000.00 5,533,816.03 5,517,150.27 5,513,992.50 444 16,172.50 6.38 30: Water & 11/29/2012 10/3D/2014 0.300 1,000,000.00 1,016,250.00 1,011,287.99 1,011,489.00 487 1,916.67 1.16 Sewer 67: 2003 Revenue 12/26/2012 12/26/2014 0.320 1,000,000.00 1,000,000.00 1,000,000.00 1,000,162.00 544 35.56 1.16 Bonds 0.310 2,000,000.00 2,016,250.00 2,011,287.99 2,011,651.00 516 1,952.23 2.32 3134G3SB7 10: General Fund 67: 2003 3134G3H78 Revenue Bonds 3/27/2012 4/28/2014 0.467 1,000,000.00 998,100.00 999,246.07 1,001,278.00 302 645.83 1.16 9/27/2012 12/5/2014 0.330 1,000,000.00 1,000,436.00 1,000,284.95 1,000,712.00 523 243.06 1.16 6 of 7 1� Portfolio Settlement Maturity YTM @ Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Sub Total / Average FNMA Bond FNMA 1.05 10/22/2013 FNMA 1.3 11/17/2014 0.398 2,000,000.00 1,998,536.00 1,999,531.02 2,001,990.00 412 888.89 2.32 31398A4S8 30: Water ti 3/27/2012 10/22/2013 0.361 1,000,000.00 Sewer 1,010,780.00 1,002,136.92 1,002,587.00 114 1,983.33 1.16 3136FPWZ6 30: Water & 6/20/2012 11/17/2014 0.462 1,000,000.00 1,020,050.00 1,011,493.48 1,013,525.00 505 1,552.78 1.16 Sewer Sub Total / Average 0.411 2,000,000.00 2,030,830.00 2,013,630.40 2,016,112.00 310 3,536.11 2.32 Total / Average 0.198 86,202,983.47 86,282,415.50 86,244,583.15 86,216,415.81 118 27,726.47 100 7 017 1$ 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/2013 Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio 10: General Fund Wells Fargo Sweep Cash Valley Bank Roanoke 0.3 7/30/2014 BBCN Bank LA 0.25 2/7/2014 CDARS 0.5 12/19/2013 First Niagara Bank 0.25 11/4/2013 Southwest Bank Ft Worth 0.3 2/27/2015 CDARS 0.6 6/19/2014 Cardinal Bank 0.5 5/17/2016 Gorham Savings Bank 0.25 2/6/2014 Moody National Bank 0.5 11/30/2013 Discover Bank 0.5 2/20/2015 Synovus Bank GA 0.5 11/28/2014 Townebank Portsmouth VA 0.4 6/1/2015 First Commercial Bank 0.3 8/30/2013 319 WFSWEEP Cash CD91935VANO CD073296AT2 CD1014682593 CD33583CDH9 CD844772AA1 CD1013981872 CD14147VDM5 CD383052CN5 CD1730 CD254671KH2 87164DBV1 89214PAP4 84GCN7 Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit 5/31/2006 1/30/2013 2/8/2013 12/20/2012 5/3/2013 2/27/2013 6/21/2012 5/17/2013 2/6/2013 5/30/2013 2/20/2013 11/30/2012 5/31/2013 8/30/2012 13,367,100.96 248,000.00 248,000.00 500,000.00 248,000.00 248,000.00 500,000.00 248,000.00 248,000.00 246,186.79 248,000.00 248,000.00 248,000.00 248,000.00 13,367,100.96 13,367,100.96 0.140 248,000.00 248,000.00 500,000.00 248,000.00 248,000.00 500,000.00 248,000.00 248,000.00 246,186.79 248,000.00 248,000.00 248,000.00 248,000.00 N/A 1 15.51 247,529.30 0.300 7/30/2014 395 0.29 247,650.07 0.250 2/7/2014 222 0.29 500,000.00 0.500 12/19/2013 172 0.58 247,785.48 0.250 11/4/2013 127 0.29 247,293.45 0.300 2/27/2015 607 0.29 500,000.00 0.600 6/19/2014 354 0.58 245,508.59 0.500 5/17/2016 1052 0.29 247,551.12 0.250 2/6/2014 221 0.29 246,186.79 0.500 11/30/2013 153 0.29 247,318.25 0.500 2/20/2015 600 0.29 248,613.30 0.500 11/28/2014 516 0.29 246,752.56 0.400 6/1/2015 701 0.29 247,921.14 0.300 8/30/2013 61 0.29 1 of 9 rq Description CUSIP/Ticker Security Settlement Face Type Date Amount/Shares Book Value Market Value YTM @ Cost Maturity Days To 0/0 of Date Maturity Portfolio Meuho Bank 0.25 5/8/2014 FFCB 0.32 3/12/2015-12 FFCB 0.3 7/18/2014 FHLMC 0.375 4/28/2014 CD60688TLM9 3133EAU30 3133EAYL6 3134G3SB7 Certificate Of Deposit 5/8/2013 248,000.00 248,000.00 247,827.14 0.250 5/8/2014 FFCB Bond 10/31/2012 1,000,000.00 1,000,000.00 998,730.00 FFCB Bond 8/1/2012 1,000,000.00 1,000,156.91 1,000,585.00 FHLMC Bond 3/27/2012 1,000,000.00 999,246.07 1,001,278.00 Sub Total / Average 17: Municipal Court Security Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 0.320 3/12/2015 0.285 7/18/2014 0.467 4/28/2014 20,341,287.75 20,340,690.73 20,335,631.15 0.224 Sub Total / Average 18: City Wide Donation Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 Sub Total / Average 19: Court Technology Wells Fargo Sweep Cash WFSWEEP Sub Total / Average 20: Debt Services Wells Fargo Sweep Cash Key Bank Ohio 0.35 8/27/2014 Mechanics Savings Bank 0.35 3/20/2015 FFCB 0.25 12/24/2014 WFSWEEP CD49306SRE8 CD583686BC3 3133ECAV6 Sub Total / Average 23: Court Juvenile Mgmt Cash 5/31/2006 131,928.47 131,928.47 131,928.47 131,928.47 131,928.47 0.140 N/A 88,842.88 88,842.88 88,842.88 88,842.88 275,648.23 275,648.23 Cash 5/31/2006 2/27/2013 3/20/2013 FFCB Bond 1/28/2013 Certificate Of Deposit Certificate Of Deposit 131,928.47 0.140 88,842.88 0.140 N/A 88,842.88 0.140 275,648.23 0.140 275,648.23 275,648.23 10,279,533.14 248,000.00 248,000.00 1,000,000.00 10,279,533.14 248,000.00 248,000.00 999,657.49 275,648.23 0.140 N/A 10,279,533.14 0.140 N/A 247,651.06 0.350 8/27/2014 247,049.17 0.350 3/20/2015 998,418.00 0.273 12/24/2014 11,775,533.14 11,775,190.63 11,772,651.37 0.160 312 0.29 620 1.16 383 1.16 302 1.16 138 23.60 1 0.15 1 0.15 1 0.10 1 0.10 0.32 1 0.32 1 11.92 423 0.29 628 0.29 542 1.16 69 13.66 2 of9 20 Description CUSIP/Ticker Security Settlement Face Type Date Amount/Shares Book Value YTM @ Maturity Days To 0/0 of Market Value Cost Date Maturity Portfolio Wells Fargo Sweep Cash WFSWEEP Sub Total / Average 30: Water & Sewer Wells Fargo Sweep Cash Goldman Sachs Bank 0.6 2/20/2015 SAFRA NATIONAL BANK 0.6 5/5/2014 Bay Cities Bank 0.5 12/12/2014 CDARS 0.5 6/19/2014 Fox Chase Bank 0.65 6/27/2016 First Farmers Bank 0.5 5/3/2016 FHLB 1.15 10/30/2014 FNMA 1.05 10/22/2013 WFSWEEP CD38147JAA0 CD786580350 CD07203QBR2 CD1013981856B CD35137QAN4 CD320165FZ1 3133743W8 31398A4S8 FNMA 1.3 11/17/2014 3136FPWZ6 Cash 9/15/2009 55,893.11 55,893.11 55,893.11 0.140 N/A Cash 5/31/2006 2/20/2013 8/1/2012 12/12/2012 6/20/2013 6/27/2013 5/3/2013 FHLB Bond 11/29/2012 FNMA Bond 3/27/2012 Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit 55,893.11 12,761,692.98 248,000.00 248,000.00 248,000.00 500,000.00 248,000.00 245,000.00 1,000,000.00 1,000,000.00 FNMA Bond 6/20/2012 1,000,000.00 55,893.11 12,761,692.98 248,000.00 248,000.00 248,000.00 500,000.00 248,000.00 245,000.00 1,011,287.99 1,002,136.92 1,011,493.48 55,893.11 0.140 12,761,692.98 0.140 N/A 247,078.68 0.600 2/20/2015 248,669.85 0.600 5/5/2014 248,601.40 0.500 12/12/2014 500,000.00 0.500 6/19/2014 245,022.02 0.650 6/27/2016 242,742.57 0.500 5/3/2016 1,011,489.00 0.300 10/30/2014 1,002,587.00 0.361 10/22/2013 1,013,525.00 0.462 11/17/2014 1 0.06 1 0.06 14.80 600 0.29 309 0.29 530 0.29 354 0.58 1093 0.29 1038 487 114 505 Sub Total / Average 31: Solidwaste Wells Fargo Sweep Cash WFSWEEP Cash Sub Total / Average 35: Street Assessment Wells Fargo Sweep Cash WFSWEEP Cash 12/1/2006 5/31/2006 17,498,692.98 17,523,611.37 17,521,408.50 0.221 389,399.28 389,399.28 389,399.28 763,033.51 389,399.28 763,033.51 389,399.28 0.140 N/A 0.28 1.16 1.16 1.16 124 20.30 1 389,399.28 0.140 763,033.51 0.140 N/A 0.45 1 0.45 1 Sub Total / Average 763,033.51 763,033.51 763,033.51 0.140 0.89 1 0.89 of 9 Zl Description Security Settlement Face CUSIP/Ticker Type Date Amount/Shares YTM @ Maturity Days To 0/0 of Book Value Market Value Cost Date Maturity Portfolio 42: Utility Impact Fee Wells Fargo Sweep Cash Private Bank & Trust 0.35 5/11/2015 Sterling Savings Bank 0.35 2/23/2015 College Savings Bank 0.55 6/20/2016 BMW Bank of NA 0.85 6/8/2015 FFCB 0.3 1/9/2015-13 WFSWEEP CD74267GTC1 CD8595316A8 CD19443PAP4 CD05568P2Q9 3133EA3U0 Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Cash 5/31/2006 5/10/2013 2/22/2013 6/19/2013 12/7/2012 FFCB Bond 11/29/2012 5,891,388.42 248,000.00 248,000.00 248,000.00 248,000.00 1,000,000.00 5,891,388.42 248,000.00 248,000.00 248,000.00 248,000.00 1,000,000.00 5,891,388.42 0.140 N/A 1 6.83 246,839,86 0.350 5/11/2015 680 0.29 247,307.34 0.350 2/23/2015 603 0.29 245,094.93 0.550 6/20/2016 1086 0.29 248,623.22 0.850 6/8/2015 708 0.29 999,218.00 0.300 1/9/2015 558 1.16 Sub Total / Average 43: Regional Detention Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 7,883,388.42 7,883,388.42 7,878,471.77 0.209 10,440.04 10,440.04 10,440.04 0.140 Sub Total / Average 44: Shadow Creek Impact Wells Fargo Sweep Cash Marlin Business Bank 0.55 6/14/2016 Sovereign Bank 0.2 7/30/2013 WFSWEEP CD57116AGF9 CD84603M3N4 Cash Certificate Of Deposit Certificate Of Deposit 5/31/2006 6/14/2013 1/30/2013 10,440.04 10,440.04 10,440.04 0.140 N/A 1,456,632.85 1,456,632.85 1,456,632.85 0.140 N/A 248,000.00 248,000.00 245,154.70 0.550 6/14/2016 248,000.00 248,000.00 247,944.94 0.200 7/30/2013 Sub Total / Average 45: Hotel/Motel Occupancy Wells Fargo Sweep Cash First Natal Bank WI 0.25 1/31/2014 Colonial Virginia Bank 0.55 6/24/2016 WFSWEEP CD321086FE5 CD196121AM9 Cash Certificate Of Deposit Certificate Of Deposit 5/31/2006 1/31/2013 6/25/2013 1,952,632.85 1,952,632.85 1,949,732.49 0.200 1,519,045.13 1,519,045.13 1,519,045.13 0.140 N/A 248,000.00 248,000.00 247,566.74 0.250 1/31/2014 248,000.00 248,000.00 245,047.81 168 9.15 1 1 1080 0.01 0.01 1.69 0.29 30 0.29 142 2.27 1 1.76 215 0.29 0.550 6/24/2016 1090 0.29 4 of9 ZZ 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 2,015,045.13 2,015,045.13 2,011,659.68 0.204 46: Park Donations Wells Fargo Sweep Cash WFSWEEP Cash 161 2.34 5/31/2006 115,212.69 115,212.69 115,212.69 0.140 N/A 1 0.13 Sub Total / Average 115,212.69 47: Park & Rec Development Wells Fargo Sweep Cash WFSWEEP Cash 115,212.69 115,212.69 0.140 1 0.13 5/31/2006 734,976.69 734,976.69 734,976.69 0.140 N/A 1 0.85 Sub Total / Average 734,976.69 49: Tree Trust Fund Wells Fargo Sweep Cash WFSWEEP Cash Sub Total / Average 50: Capital Projects Wells Fargo Sweep Cash WFSWEEP Cash 734,976.69 734,976.69 0.140 5/31/2006 75,767.19 75,767.19 75,767.19 0.140 N/A 1 0.85 1 0.09 75,767.19 75,767.19 75,767.19 0.140 5/31/2006 -173,827.19 -173,827.19 -173,827.19 0.140 N/A 1 0.09 1 -0.20 Sub Total / Average 55: Sidewalk Fund Wells Fargo Sweep Cash WFSWEEP Cash -173,827.19 -173,827.19 -173,827.19 0.140 5/31/2006 225,714.36 225,714.36 225,714.36 0.140 N/A Sub Total / Average 60: Police State Seizure Wells Fargo Sweep Cash WFSWEEP Cash 225,714.36 225,714.36 225,714.36 0.140 1 -0.20 1 0.26 1 0.26 5/31/2006 201,278.44 201,278.44 201,278.44 0.140 N/A 1 0.23 Sub Total / Average 201,278.44 62: Federal Police Fund Wells Fargo Sweep Cash WFSWEEP 201,278.44 201,278.44 0.140 1 0.23 Cash 5/31/2006 47,868.11 47,868.11 47,868.11 0.140 N/A 1 0.06 5 of 9 2'S Description CUSIP/Ticker Security Settlement Face Type Date Amount/Shares Book Value YTM Market Value Cost Maturity Days To 0/0 of Date Maturity Portfolio Sub Total / Average 64: 1998 Cert of Obligation Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 47,868.11 845,205.90 47,868.11 845,205.90 47,868.11 0.140 845,205.90 0.140 N/A Sub Total / Average 67: 2003 Revenue Bonds Wells Fargo Sweep Cash Asheville Savings Bank 0.35 3/27/2015 Meda@ion Bank UT 0.4 11/3/2015 FFCB 2.125 2/10/2014 FHLB 0.32 12/26/2014-13 FHLMC 0.35 12/5/2014 WFSWEEP Cash CD04407RAJ0 CD58403BB62 31331JDY6 FFCB Bond 313381G58 FHLB Bond 3134G3H78 FHLMC Bond Certificate Of Deposit Certificate Of Deposit 5/31/2006 2/28/2013 5/3/2013 11/29/2012 12/26/2012 9/27/2012 845,205.90 6,199,381.92 248,000.00 248,000.00 1,500,000.00 1,000,000.00 1,000,000.00 845,205.90 845,205.90 0.140 6,199,381.92 248,000.00 248,000.00 1,517,335.87 1,000,000.00 1,000,284.95 6,199,381.92 0.140 N/A 247,008.50 0.350 3/27/2015 246,680.64 0.400 11/3/2015 1,517,041.50 0.230 2/10/2014 1,000,162.00 0.320 12/26/2014 1,000,712.00 0.330 12/5/2014 Sub Total / Average 68: 2001 Cert of Obligation Wells Fargo Sweep Cash WFSWEEP Sub Total / Average 70: 2005 Refunding / Mobility Wells Fargo Sweep Cash Fast State Bank - WV 0.35 12/3/2014 Sub Total / Average 95: Property Liability WFSWEEP CD33648FHR9 Cash 10,195,381.92 10,213,002.74 10,210,986.56 0.201 5/31/2006 401,859.89 401,859.89 401,859.89 0.140 N/A Cash Certificate Of Deposit 401,859.89 401,859.89 401,859.89 0.140 5/31/2006 862,380.12 862,380.12 862,380.12 0.140 N/A 12/3/2012 248,000.00 248,000.00 248,609.83 0.350 12/3/2014 1 0.06 1,110,380.12 1,110,380.12 1,110,989.95 0.187 1 0.98 1 0.98 1 7.19 635 0.29 856 0.29 225 1.74 544 1.16 523 1.16 175 11.83 1 0.47 1 0.47 1 1.00 521 0.29 117 1.29 6 of 9 2)-1 Description Security Settlement Face YTM @ Maturity Days To 0/0 of CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Wells Fargo Sweep WFSWEEP Cash 10/31/2006 -252,237.07 -252,237.07 -252,237.07 0.140 N/A 1 -0.29 Cash Sub Total / Average -252,237.07 -252,237.07 -252,237.07 0.140 1 -0.29 97: Employee Benefit Trust Wells Fargo Sweep WFSWEEP Cash 9/1/2007 16,912.82 16,912.82 16,912.82 0.140 N/A 1 0.02 Cash Sub Total / Average 16,912.82 16,912.82 16,912.82 0.140 1 0.02 99: COP Health Claims Fund Wells Fargo Sweep WFSWEEP Cash 9/15/2010 500,102.73 500,102.73 500,102.73 0.140 N/A 1 0.58 Cash Wells Fargo Cash WF9871 Cash 7/21/2010 325,953.37 325,953.37 325,953.37 0.140 N/A 1 0.38 Sub Total / Average 826,056.10 826,056.10 826,056.10 0.140 1 0.96 2101: Grant Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 -19,304.66 -19,304.66 -19,304.66 0.140 N/A 1 -0.02 Cash Sub Total / Average -19,304.66 -19,304.66 -19,304.66 0.140 1 -0.02 2105: 2007 CDBG Fund Wells Fargo Sweep WFSWEEP Cash 5/1/2007 187.75 187.75 187.75 0.140 N/A 1 0.00 Cash Sub Total / Average Z106: 2008 CDBG Fund Wells Fargo Sweep Cash WFSWEEP Cash 3/15/2009 Sub Total / Average Z107: 2009 CDBG Fund Wells Fargo Sweep Cash Sub Total / Average WFSWEEP Cash 11/1/2009 187.75 187.75 187.75 0.140 1 0.00 1.14 1.14 1.14 0.140 N/A 1 0.00 1.14 1.14 1.14 0.140 15.61 15.61 1 0.00 15.61 0.140 N/A 1 0.00 15.61 15.61 15.61 0.140 1 0.00 7oi9 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 2108: 2010 CDBG Fund Wells Fargo Sweep WFSWEEP Cash 11/1/2010 0.05 0.05 0.05 0.140 N/A 1 0.00 Cash Sub Total / Average 0.05 0.05 0.05 0.140 1 0.00 Z109: 2011 CDBG Fund Wells Fargo Sweep WFSWEEP Cash 12/1/2011 -9,325.54 -9,325.54 -9,325.54 0.140 N/A 1 -0.01 Cash Sub Total / Average -9,325.54 Z110: 2012 CDBG Fund Wells Fargo Sweep Cash -9,325.54 -9,325.54 0.140 1 -0.01 WFSWEEP Cash 11/15/2012 6,895.40 6,895.40 6,895.40 0.140 N/A 1 0.01 Sub Total / Average 6,895.40 Z116: CDBG Recovery Fund Wells Fargo Sweep Cash WFSWEEP Cash 7/31/2009 7.40 6,895.40 6,895.40 0.140 1 0.01 7.40 7.40 0.140 N/A 1 0.00 Sub Total / Average 7.40 Z140: U of H Fund Wells Fargo Sweep Cash WFSWEEP Cash 7.40 7.40 0.140 1 0.00 12/1/2009 -20,899.47 -20,899.47 -20,899.47 0.140 N/A 1 -0.02 Sub Total / Average -20,899.47 -20,899.47 -20,899.47 0.140 1 -0.02 Z145: Munidpal Channel Wells Fargo Sweep WFSWEEP Cash 4/15/2012 141,838.36 141,838.36 141,838.36 0.140 N/A 1 0.16 Cash Sub Total / Average 141,838.36 Z200: 2006 Cert of Obligation Wells Fargo Sweep Cash WFSWEEP Cash 141,838.36 141,83836 0.140 1 0.16 6/30/2006 1,516,292.61 1,516,292.61 1,516,292.61 0.140 N/A 1 1.76 Sub Total / Average 1,516,292.61 1,516,292.61 1,516,292.61 0.140 1 1.76 8of9 z, 6 Security Settlement Face Description CUSIP/Ticker Type Date Amount/Shares Book Value YTM @ Maturity Days To 0/0 of Market Value Cost Date Maturity Portfolio Z201: 2007 Cert of Obligation Wells Fargo Sweep Cash WFSWEEP Cash 8/31/2006 365,546.43 365,546.43 365,546.43 0.140 N/A Sub Total / Average Z202: 2007A Gen Obligation Wells Fargo Sweep Cash Celtic Bank 0.6 6/28/2016 WFSWEEP CD15118RJD0 Cash Certificate Of Deposit Sub Total / Average Z203: 2009 Gen Obligation Wells Fargo Sweep Cash WFSWEEP Cash 365,546.43 365,546.43 365,546.43 0.140 12/31/2007 2,503,580.15 2,503,580.15 2,503,580.15 0.140 6/28/2013 248,000.00 248,000.00 10/30/2008 N/A 245,081.54 0.600 6/28/2016 2,751,580.15 2,751,580.15 2,748,661.69 0.181 340,704.90 340,704.90 340,704.90 0.140 N/A 1 0.42 1 0.42 1 2.90 1094 0.29 100 3.19 1 0.40 Sub Total / Average Z301: W/S Pay As U Go CIP Wells Fargo Sweep Cash DeWitt Bank and Trust 0.5 6/20/2016 Sub Total / Average WFSWEEP CD241888BT2 Z302: MUD 4 Capital Programs Wells Fargo Sweep Cash WFSWEEP Cash 340,704.90 340,704.90 340,704.90 0.140 12/31/2007 1,972,440.47 1,972,440.47 1,972,440.47 0.140 Certificate Of 6/24/2013 Deposit Cash 248,000.00 248,000.00 N/A 245,161.64 0.500 6/20/2016 2,220,440.47 2,220,440.47 2,217,602.11 0.180 2/1/2013 1,356,687.11 1,356,687.11 1,356,687.11 0.140 N/A 1 0.40 1 2.29 1086 0.29 122 2.58 1 1.57 Sub Total / Average 1,356,687.11 1,356,687.11 1,356,687.11 0.140 1 1.57 Total / Average 86,202,983.47 86,244,583.15 86,216,415.81 0.198 118 100 9 of 9 Z7 City of Pearland Purchases Portfolio/Report Group: Report Group: Pearland From 3/31/2013 To 6/30/2013 VTM Portfolio Settlement Maturity Face Name Description Bullet/Callable CUSIP/Ticker Action Date Date Price Amount/Shares Cost Principal Interest/Dividends Broker/Dealer 10: Cardinal General Bank 0.5 Fund 5/17/2016 10: General Fund Moody National Bank 0.5 11/30/2013 10: First Niagara General Bank 0.25 Fund 11/4/2013 10: Mizuho General Bank 0.25 Fund 5/8/2014 10: General Fund Townebank Portsmouth VA 0.4 6/1/2015 First 30: Water Farmers & Sewer Bank 0.5 5/3/2016 30: Water Fox Chase & Sewer Bank 0.65 6/27/2016 30: Water CDARS 0.5 & Sewer 6/19/2014 42: Utility Impact Fee Private Bank & Trust 0.35 5/11/2015 College 42: Utility Savings Impact Fee Bank 0.55 6/20/2016 44: Marlin Shadow Business Creek Bank 0.55 Impact 6/14/2016 CD14147VDM5 Buy 5/17/2013 5/17/2016 100 248,000.00 0.500 248,000.00 CD1730 Buy 5/30/2013 11/30/2013 100 246,186.79 0.500 246,186.79 CD33583CDH9 Buy 5/3/2013 11/4/2013 100 248,000.00 0.250 248,000.00 CD60688TLM9 Buy 5/8/2013 5/8/2014 100 248,000.00 0.250 248,000.00 89214PAP4 Buy 5/31/2013 6/1/2015 100 248,000.00 0.400 248,000.00 CD320165FZ1 Buy 5/3/2013 5/3/2016 100 245,000.00 0.500 245,000.00 CD35137QAN4 Buy 6/27/2013 6/27/2.016 100 248,000.00 0.650 248,000.00 CD1013981856B Buy 6/20/2013 6/19/2014 100 500,000.00 0.500 500,000.00 CD74267GTC1 Buy 5/10/2013 5/11/2015 100 248,000.00 0.350 248,000.00 CD19443PAP4 Buy 6/19/2013 6/20/2016 100 248,000.00 0.550 248,000.00 CD57116AGF9 Buy 6/14/2013 6/14/2016 100 248,000.00 0.550 248,000.00 0.00 Wells Fargo Bank 0.00 Moody National Bank 0.00 Wells Fargo Bank 0.00 Wells Fargo Bank 0.00 Wells Fargo Bank 0.00 Wells Fargo Bank 0.00 Vining Sparks 0.00 Independence Bank 0.00 Wells Fargo Bank 0.00 Wells Fargo Bank 0.00 Wells Fargo Bank 1 oft YTM Portfolio Settlement Maturity Face @ Name Description Bullet/Callable CUSIP/Ticker Action Date Date Price Amount/Shares Cost Principal Interest/Dividends Broker/Dealer 45: HotevMotel Occupancy Cobnial Virginia Bank 0.55 6/24/2016 67: 2003 Medallion Revenue Bank UT 0.4 Bonds 11/3/2015 Z202: Celtic Bank 2007A Gen 0.6 Obligation 6/28/2016 Z301: W/S Pay As U Go CIP DeWitt Bank and Trust 0.5 6/20/2016 CD196121AM9 Buy 6/25/2013 6/24/2016 100 248,000.00 0.550 248,000.00 CD58403BB62 Buy 5/3/2013 11/3/2015 100 248,000.00 0.400 248,000.00 CD15118RJDO Buy 6/28/2013 6/28/2016 100 248,000.00 0.600 248,000.00 0.00 Vining Sparks 0.00 Wells Fargo Bank 0.00 Vining Sparks CD241888BT2 Buy 6/24/2013 6/20/2016 100 248,000.00 0.500 248,000.00 0.00 Vining Sparks 2 of 2 7 -et Pledged Collateral Reconciliation Report June 30, 2013 Bank Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Account Number 201-0419505 201-0419513 001-3042841 1-9-0121790 807-1613395 8 8-4567843 001-3043112 200-7409871 805-9860145 Bank A :count Number Wells Fargo 1n0-7284258 Account Name Operating Payroll Fund Sweep Account EMS Payments Credit Card Account Alvin ISD PEDC Sales Tax Health Claims BC MUD #4 Total of Bank Balances Pledged Collateral for City FDIC Insurance Total Collateral Amount 79,255,962.44 8, 258, 369.88 325,953.37 1.43 $ 87,840,287.12 112,190,155.72 250,000.00 $ 112,440,155.72 Over (Under) Collateralized $ 24,599,868.60 Total % Collateralized Account Name Development Authority Total of Bank Balances Pledged Collateral for DAP FDIC Insurance Total Collateral Over (Under) Collateralized Total % Collateralized Total $ Over (Under) Collateralized Total % Collateralized Status 128.0% Amount 1,005,469.85 $ 1,005,469.85 11,656,496.28 250,000.00 $ 11,906,496.28 $ 10,901,026.43 1184.2% $ 35,500,895.03 140.0% Collateralized I:\tnvestments\Investment Reports\City of Peartand\In sstment Report - City - Qtr 0613 3�