Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R-2012-113-2012-08-13
RESOLUTION NO. R2012-113 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS, ACCEPTING THE CITY'S INVESTMENT REPORT FOR THE QUARTER ENDING JUNE 2012. BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS: Section 1. That the City Council hereby accepts the City's Investment Report for the Quarter ending June 2012. PASSED, APPROVED, AND ADOPTED this 13th day of August, A.D., 2012. c:Qtrryt.) TOM REID MAYOR ATTEST: 4QtiPRLq�, s' Y G G C o • ."i T SE ETA ',I'klgMHNN.M.N APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY Exhibit "A" Resolution No. R2012-113 ,o� 9,9 City of Pearland . Quarterly Investment Report igLiAkairi March 31, 2012-June 30, 2012 'sr. j9ls Portfolio at March 31.201Z Portfolio at June 30.201Z Ending Book Value $ 95,233,291.70 Ending Book Value $ 89,422,699.33 Ending Market Value 95,264,039.86 Ending Market Value 89,445,581.34 Accrued Interest Receivable 89,811.06 Accrued Interest Receivable 49,758.01 FYD Total Interest Earned 93,560.55 FYD Total Interest Earned 133,110.65 Unrealized Gain/(Loss) 30,748.16 Unrealized Gain/(Loss) 22,882.01 Change in Unrealized Gain/Loss (20,224.28) Change in Unrealized Gain/Loss (7,866.15) Weighted Average Maturity 83 Days Weighted Average Maturity 101 Days Change in Market Value 64,700.51 Change in Market Value (5,818,458.52) Yield to Maturity at Cost 0.18% Yield to Maturity at Cost 0.19% T-Bill Benchmark 0.19% T-Bill Benchmark 0.21% Agency Note Benchmark 0.09% Agency Note Benchmark 0.14% Averaae for Quarter City's Yield to Maturity 0.17% 1 Year T-Bill Benchmark Yield 0.20% Agency Note Benchmark Yield 0.13% 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: Dr):r. Claire Bogard Rick gaa Fatima Uwakwe Director of Finance Assistan Director of Finance Senior Accountant Summary by Type June 30,2012 QSxxripion Face Amount\Shares COst_Value 800kValue Market Value 1I1Y1)_Cost Days To Maturity Sweep Acct $ 56,885,031.72 $ 56,885,031.72 $ 56,885,031.72 $ 56,885,031.72 0.05% 1 Bank Acct 358,698.95 358,698.95 358,698.95 358,698.95 0.04% 1 CD 4,473,000.00 4,473,000.00 4,473,000.00 4,468,783.27 0.42% 254 FFCB 2,600,000.00 2,599,850.00 2,599,908.33 2,605,291.40 0.57% 570 FHLB 8,000,000.00 8,174,597.48 8,076,259.02 8,082,565.00 0.38% 186 FHLMC 5,000,000.00 5,010,650.44 5,000,913.39 5,004,490.00 0.32% 266 FNMA 12,000,000.00 12,021,213.48 12,028,887.92 12,040,721.00 0.51% 295 Total/Average $ 89,316,730.67 $ 89,523,042.07 $ 89,422,699.33 $ 89,445,581.34 0.19% 101 Group Portfolio Holdings Book Value by Maturity by Type 70,000,030 /__ 13''- 60,000,000 FH .--.-- — FMB 6L%MC 9% 50,000,000 . 40,000,000 30,000,000 - - - _— FFCB 20,000,000 --- — 3% 10,000,000 _ CD Sweep Acct 5% Bank Acct 64% 1.30 Owls 31.60 0aY5 61..90 0aY591.120 0a%1%21.180 DaYs >180 flays Interest Rates Date 1 mQ 3 mo 6 mo Lr zit 3i Syr z.. 10 yr 20 yr 0 r 3/30/2012 0.05 0.07 0.15 0.19 0.33 0.51 1.04 1.61 2.23 3.00 3.35 6/29/2012 0.04 0.09 0.16 0.21 0.33 0.41 0.72 1.11 1.67 2.38 2.76 Yield Curve Comparison 4.00 .'r TF � - ; ^T-. C 5 t t k 4... a 4 rc • • • = r-T" "4-�`r 200 --. .. ays�' ted4gliAti l 1.50 ! i.0i Day Average Maturity 1mo 3mo 6mo lyr 2yr 3yr 5yr 7yr l0 yr 20 yr 30 yr —4-3/30/2012 i-6/29/2012 Portfolio vs. Benchmarks 0.30% l: 0.25% '. 1 _ ._._ ...... _.. ., ♦ ■ r"> F .. Jul-11 Aug-11 Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 —+—Port Total —1111--1 Yr 7-Bill —Ar—Agency Note City of Peartand Quarterly Investment Report Report Format:By CUSIP Group By:Security Type Portfolio/Report Group:Report Group:Pearland Begin Date:3/31/2012,End Date:6/30/2012 Portfolio Maturity Annualized Amortized Amortized Investment Description CUSIP/Ticker Name Date TRR-BV Beginning By Buy Principal Sell Principal Discount Premium Ending BV Income-BV CASH Wets Fargo WFSWEEP 10:General N/A 0.05 13,553,550.41 1,238.17 6,587,190.31 0.00 0.00 6,967,598.27 1,238.17 Sweep Cash Fund Wells Fargo 17:Municipal Sweep Cash WFSWEEP Court N/A 0.05 147,933.03 1,064.86 9,768.94 0.00 0.00 139,228.95 16.75 Security Wells Fargo 18:City Sweep Cash WFSWEEP Wide N/A 0.05 65,320.54 4,233.57 6,544.88 0.00 0.00 63,009.23 7.49 Donation Welt Fargo WFSWEEP 19:Court N/A 0.05 215,751.22 12,985.10 0.00 0.00 0.00 228,736.32 26.33 Sweep Cash Technology Welk Fargo WFSWEEP 20:Debt N/A 0.04 10,948,102.01 965,148.68 4,636,922.32 0.00 0.00 7,276,328.37 921.12 Sweep Cash Services Weis Fargo Juv Court Sweep Cash WFSWEEP 23:nil Co N/A 0.05 28,505.65 3,262.53 589.20 0.00 0.00 31,178.98 3.63 Mgmt We Fargo WFSWEEP 30:WaterB N/A 0.03 7,777,989.25 2,708,445.82 309,741.44 0.00 0.00 10,176,693.63 764.77 Sweep Cash Sewer Welk Fargo WFSWEEP 31: N/A 0.05 347,747.23 26,989.37 84,327.56 0.00 0.00 290,409.04 38.08 Sweep Cash Solidwaste Wells Fargo WFSWEEP 35:Street N/A 0.05 343,541.75 40.30 0.00 0.00 0.00 343,582.05 40.30 Sweep Cash Assessment Wets Fargo WFSWEEP 42:Uttty N/A 0.05 764,743.10 2,536,325.59 2,547,624.69 0.00 0.00 753,444.00 232.96 Sweep Cash Impact Fee Weis Fargo 44:Shadow W Weis Fargo WFSWEEP Creek N/A 0.06 1,028,923.82 2,719,659.41 0.00 0.00 0.00 3,748,583.23 248.51 Sweep Impact 45: Wels Fargo o Sweep Cash WFSWEEP HteVMotel N/A 0.05 1,196,377.72 156,544.16 84,136.73 0.00 0.00 1,268,785.15 153.06 Occupancy Well Fargo WFSWEEP 46:Park N/A 0.05 66,245.66 25,044.93 2,450.91 0.00 0.00 88,839.68 10.51 Sweep Cash Donations 47Welt Fargo et Park& Sweep Cash WFSWEEP Rec N/A 0.05 842,077.97 I51.01 10,360.28 0.00 0.00 831,868,70 98.35 Development 1 of7 Portfo o Maturity Annualized Amortized Amortized Investment Description CUSIP/Tiicker Name Date TRR-BV Beginning BY Buy Principal Sell Principal Discount Premium Ending BV Income-BY Wets Fargo WFSWEEP 49:Tree N/A 0.05 19,117.33 2.23 36.30 0.00 0.00 19,083.26 2.23 Sweep Cash Trust Fund Welk Fargo WFSWEEP 50:Capital N/A 0.05 2,634,404.33 297.26 157,823.36 0.00 0.00 2,476,878.23 297.26 Sweep Cash Projects Welk Fargo WFSWEEP 55:Sidewaic N/A 0.05 213,270.50 24.65 4,998.00 0.00 0.00 208,297.15 24.65 Sweep Cash Fund W 60:Police Weis Fargo Sweep Cash WFSWEEP State N/A 0.05 263,929.92 29.30 25,083.55 0.00 0.00 238,875.67 29.30 Seizure Wets Fargo WFSWEEP 62:Federal N/A 0.05 32,144.61 3.77 0.00 0.00 0.00 32,148.38 3.77 Sweep Cash Poice Fund 64Weis Fargo Cert 1998 Sweep Cash WFSWEEP of N/A 0.05 923,695.88 104.95 79,834.68 0.00 0.00 843,966.15 104.95 Obligation Weis Fargo 67:2003 Sweep Cash WFSWEEP Revenue N/A 0.05 9,116,918.03 1,020.29 848,625.88 0.00 0.00 8,269,312.44 1,020.29 Bonds 68Weis Fargo Cert 2001 Sweep Cash WFSWEEP of N/A 0.04 1,925,485.52 186.12 645,514.61 0.00 0.00 1,280,157.03 186.12 Ublgaton Weis Fargo Re: i9 Sweep Cash WFSWEEP 70 nd20in / N/A 0.05 1,800,557.75 442,874.69 344,281.43 0.00 0.00 1,899,151.01 247.63 Mobility Wens Fargo WFSWEEP 95:Property N/A -0.04 154,576.62 251,764.66 505,621.31 0.00 0.00 -99,280.03 5.81 Sweep Cash llabity Weis Fargo 97: Sweep Cash WFSWEEP Empbyee N/A 0.05 22,973.04 39,593.84 22,913.11 0.00 0.00 39,653.77 3.86 Benefit Trust Weis Fargo He:COP Cash WF9871 Health N/A 0.04 292,144.55 1,200,037.95 1,133,483.55 0.00 0.00 358,698.95 37.95 Claims Fund Wets Fargo He:COP Sweep Cash WFSWEEP Health N/A 0.00 -72,543.80 200,997.05 271,206.97 0.00 0.00 -142,753.72 0.00 Claims Fund Wells Fargo WFSWEEP 2101:Grant N/A 0.00 -111,911.30 24,028.82 12,699.39 0.00 0.00 -100,581.87 0.00 Sweep Cash Fund Welk Fargo WFSWEEP Z105:2007 N/A 0.00 187.54 0.00 0.00 0.00 0.00 187.54 0.00 Sweep Cash CDBG Fund Welk Fargo WFSWEEP Z106:2008 N/A 0.00 1.14 0.00 0.00 0.00 0.00 1.14 0.00 Sweep Cash CDBG Fund 2 of 7 Portfolio Maturity Annualized Amortized Amortized Investment Description CUSIP/Ticiter Name Date TRR-BV Beginning BV Buy Principal SeN Principal Discount Premium Ending By Income-BV Wets Fargo WFSWEEP Z107:2009 N/A 0.00 15.61 0.00 0.00 0.00 0.00 15.61 0.00 Sweep Cash CDBG Fund Were Fargo WFSWEEP Z108:2010 N/A 0.00 -32,604.95 32,605.00 0.00 0.00 0.00 0.05 0.00 Sweep Cash CDBG Fund Wells Fargo 2109:2011 WFSWEEP N/A 0.00 -5,077.60 5,077.60 7,604.22 0.00 0.00 -7,604.22 0.00 Sweep Cash CDBG Fund Wells Fargo Reov CDBG Sweep Cash WFSWEEP Recovery N/A 0.00 7.40 0.00 0.00 0.00 0.00 7.40 0.00 Fund Wets Fargo WFSWEEP Z140:U of H N/A 0.05 69,500.83 11,104.39 717.87 0.00 0.00 79,887.35 9.36 Sweep Cash Fund Wets Fargo M1 n5: Sweep Cash WFSWEEPici ZI.45: al N/A 0.09 0.00 24,883.71 14,415.46 0.00 0.00 10,468.25 1.05 Channel Z20Wells Fargo Cert 2006 Sweep Cash WFSWEEP 2rtof N/A 0.05 1,802,299.55 209.94 25,828.68 0.00 0.00 1,776,680.81 209.94 Obligation Wells Fargo Z201:2007 Sweep Cash WFSWEEP Cert of N/A 0.05 1,699,907.08 198.69 19,739.91 0.00 0.00 1,680,365.86 198.69 Obligation Wets Fargo 2002. Sweep Cash WFSWEEP 2002A Gen N/A 0.05 3,405,229.42 355.36 732,733.02 0.00 0.00 2,672,851.76 355.36 Obligation Wells Fargo Z203:2009 Sweep Cash WFSWEEP Gen N/A 0.05 2,070,054.54 221.74 279,939.43 0.00 0.00 1,790,336.85 221.74 Obligation Wets Fargo P30 A W/S Sweep Cash WFSWEEP Z31: U Go N/A 0.05 1,483,118.47 261,062.33 35,540.55 0.00 0.00 1,708,640.25 160.97 CIP Sub Total/Average 0.04 65,034,211.37 11,657,817.84 19,448,298.54 0.00 0.00 57,243,730.67 6,940.96 Cash CERTIFICATE OF DEPOSIT CDARS 0.75 CD1012781942 10:General 9/33/2012 0.75 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,869.87 9/13/2012 Fund GDARS 0.6 CD1013981872 10.General 6/19/2014 0.60 0.00 500,000.00 0.00 0.00 0.00 500,000.00 73.97 6/19/2014 Fund Moody National Bank 0.6 C060007130 10:GeneralFund 5/30/2012 0.61 245,000.00 0.00 245,000.00 0.00 0.00 0.00 246.58 5/30/2012 3of7 Portfolio Maturity Annualized Amortized Amortized Investment Description CUSIP/Tfdter Name Date TRR-BV Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income-BV Moody National Bank 0.5 CD60007130B 10:General Fund11/30/2012 0.50 0.00 245,000.00 0.00 0.00 0.00 245,000.00 104.04 11/30/2012 21ST CENTURY 0.25 CD90136SFD3 FO10:M General 2/13/2013 0.25 248,000.00 0.00 0.00 0.00 0.00 248,000.00 154.58 2/13/2013 FARMERS& MERCHANTS CD307612 HH3 er S Debt 2/15/2013 0.25 248,000.00 0.00 0.00 0.00 0.00 248,000.00 154.58 0.25 Services 2/15/2013 AMERICAN NATIONAL CD02771PKZ9 30:Water 5/3/2013 0.25 0.00 248,000.00 0.00 0.00 0.00 248,000.00 98.52 BANK 0.25 Sewer 5/3/2013 BEAL BANK 0.3 C307370TKX0 30:Water& 2/13/2013 0.30 248,000.00 0.00 0.00 0.00 0.00 248,000.00 185.49 2/13/2013 Sewer DISCOVER 35:Street BANK 0.25 CD2546703U4 Assessment 2/15/2013 0.25 248,000.00 0.00 0.00 0.00 0.00 248,000.00 154.57 2/15/2013 GOLDMAN 44:Shadow SACHS0.25 C038143A3Z9 Creek 2/15/2013 0.25 248,000.00 0.00 0.00 0.00 0.00 248,000.00 154.57 2/15/2013 Impact KEY BANK 0.25 45. 2/15/2013 CD49306SPE0 Hote/Motel 2/15/2013 0.25 248,000.00 0.00 0.00 0.00 0.00 248,000.00 154.57 Occupancy PACIFIC 47:Park& CONTINENTAL CD69413CCQO Rec 2/15/2013 0.25 248,000.00 0.00 0.00 0.00 0.00 248,000.00 154.58 0.25 Development 2/15/2013 MIZUHO CORP 67:2003 BANK 0.3 CD60688TBR9 Revenue 5/2/2013 0.30 0.00 248,000.00 0.00 0.00 0.00 248,000.00 120.26 5/2/2013 Bonds PRNATE BANK 68:2001 0.25 CD74269TBK2 Cert of 2/15/2013 0.25 248,000.00 0.00 0.00 0.00 0.00 248,000.00 154.58 2/15/2013 Obligation APPLE BANK 0.3 Z202. 2/22/2013 CD037830FX9 2007A Gen 2/22/2013 0.30 248,000.00 0.00 0.00 0.00 0.00 248,000.00 185.49 Obligation Sub Total/Average 0.41 3,477,000.00 1,241,000.00 245,000.00 0.00 0.00 4,473,000.00 3,966.25 Certificate Of Deposit FFCB BOND 4 of 7 Portfolio Maturity AnnualizedTRR-B Amortized Amortized Investment Description CUSIP/T""iGcer Name Date TRR-BV Begimbq BV Buy Principal Set Principal Discount Premium Ending BV Incomtr8 Y FFCB 0.75 31331K/Q4 F0 General 5/2/2013 0.74 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,854.16 5/2/2013 FFCB 0.4 10:General 9/20/2013 0.41 599,889.79 0.00 0.00 18.54 0.00 599,908.33 611.88 31331KZB9 9/20/2013-12 Fund 67:2003 FFCB 0.48 3133EAVI4 Revenue 12/26/2014 0.49 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 53. 33 12/26/2014-13 Bonds Sub 0.61 1,599,889.79 1,000,000.00 0.00 18.54 0.00 2,399,908.33 2,519.37 Total/Average FFCB Bond --- -. - -- FHLB BOND FHLB 3.625 3133XQU34 10:r General 5/29/2013 0.50 1,035,734.46 0.00 0.00 0.00 -7,675.66 1,028,058.80 1,286.15 5/29/2013 FHLB 2 3133XUK93 Fund:Merdf 9/14/2012 0.63 1,006,177.76 0.00 0.00 0.00 -3,373.13 1,002,804.63 1,571.32 9/14/2012 FHLB 0 20:Debt 0.00 252.78 0.00 999,548.89 252.78 10/24/FHLB 313384180 Services10/24/2012 0.14 0.00 999,296.11 FfIL63.25 30:Wa[era 0.00 41.24 4/9/232 31331YC24 Sewer 4/9/2012 0.17 1,000,680.98 0.00 1,000,000.00 0.00 -680.98 FHLB 3.625 3133XQU34 30:WaterB 5/29/2013 0.50 1,035,734.46 0.00 0.00 0.00 -7,675.66 1,028,058.80 1,286.15 5/29/2013 Sewer FHLB 1.375 3133XWKU2 30:Waterfi 6/8/2012 0.46 1,001,695.36 0.00 1,000,000.00 0.00 -1,695.36 0.00 863.67 6/8/2012 Sewer FH160.875 3133XYWB7 30:WaterB 8/22/2012 0.60 1,001,070.65 0.00 0.00 0.00 -675.80 1,000,394.85 1,487.39 8/22/2012 Sewer FHLB 0.42 313372368 42:U[LRy 4/13/2012 0.39 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 140.00 4/13/2012 Impact Fee FHLB 1.81 3133XWGP8 42:UIRY 3/26/2013 0.24 1,015,453.87 0.00 0.00 0.00 -3,874.35 1,011,579.52 600.37 3/26/2013 Impact Fee FHLB 0.2 67:2003 12/13/2012 3133761R4 Revenue 12/13/2012 0.18 1,000,125.02 0.00 0.00 0.00 -44.16 1,000,080.86 450.28 Bonds FHLB 1.625 67:2003 11/21/2012 3133XVEM9 Revenue 11/21/2012 0.16 1,009,351.17 0.00 0.00 0.00 -3,618.50 1,005,732.67 398.86 Bonds 70:2005 0.00 140.00 FHLB2 313372388 Refunding/ 4/13/2012 0.39 1,000,000.00 0.00 1,000,000.00 0.00 0.00 4//1313/2200 12 Mobility 5of7 Portfolio Maturity Annualized Amortized Amortized Investment Description CUSIP/Ticker Name Date TRR-BV Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income-BV Sub Total/Average 0.38 11,106,023.73 999,296.11 4,000,000.00 252.78 -29,313.60 8,076,259.02 8,518.21 FHLB Bond FHLMC BOND FHLMC 0 313397DU2 10:General 4/1/2013 0.17 0.00 998,394.44 0.00 306.95 0.00 998,701.39 306.95 4/1/2013 Fund FHLMC 0.375 3134G3S87 10:General 4/28/2014 0.46 998,110.12 0.00 0.00 225.17 0.00 998,335.29 1,152.25 4/28/2014 Fund FHLMC 1.125 3137EACK3 20:Debt 7/27/2012 0.12 1,003,237.02 0.00 0.00 0.00 -2,483.58 1,000,753.44 297.67 7/27/2012 Services FHLMC 0.75 3134G1P65 42:UtW2y 12/28/2012 0.43 2,004,702.45 0.00 0.00 0.00 -1,579.18 2,003,123.27 2,129.15 12/28/2012 Impact Fee Sub Total/Average 0.33 4,006,049.59 998,394.44 0.00 532.12 -4,062.76 5,000,913.39 3,886.02 FHLMC Bond FNMA BOND FNMA 0.75 10:General 3135GOAK9 2/26/2013 0.18 1,005,158.73 0.00 0.00 0.00 -1,412.70 1,003,746.03 441.46 2/26/2013 Fund FNMA 0.5 3136GOFF3 10:General 10/30/2014 0.51 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 833.33 10/30/2014-13 Fund FNMA 0.5 31398A4T6 10:General 10/30/2012 0.63 1,998,562.29 0.00 0.00 616.16 0.00 1,999,178.45 3,116.16 10/30/2012 Fund FNMA 0.375 31398A6F4 20:Debt 12/28/2012 0.65 997,902.70 0.00 0.00 699.10 0.00 998,601.80 1,626.18 12/28/2012 Services FNMA 1.3 3136FPWZ6 30:Water& 11/17/2014 0.46 0.00 1,020,050.00 0.00 0.00 -231.26 1,019,818.74 129.85 11/17/2014 Sewer FNMA 1.05 31398A4S8 30:Water® 10/22/2013 0.36 1,010,703.68 0.00 0.00 0.00 -1,698.09 1,009,005.59 897.74 10/22/2013 Sewer FNMA 0.5 31398A4T6 30:Water& 10/30/2012 0.63 999,281.14 0.00 0.00 308.09 0.00 999,589.23 1,558.09 10/30/2012 Sewer FNMA 0.375 31398A6F4 30:Water& 12/28/2012 0.65 997,902.70 0.00 0.00 699.10 0.00 998,601.80 1,626.18 12/28/2012 Sewer FNMA 0.5 31398A4T6 42:Utility 10/30/2012 0.63 999,281.14 0.00 0.00 308.09 0.00 999,589.23 1,558.09 10/30/2012 Impact Fee FNMA70:2005 0.5 10/30/2012 3136FP0C9 Refunding/ 10/30/2012 0.39 2,001,324.84 0.00 0.00 0.00 -567.79 2,000,757.05 1,932.21 Mobility 6 of 7 Amortized Amortized Investment Portfolio Maturity Annualized Description CUSIP/Tkker Name Date TRR-BV Beginning BV Buy Principal Sell Principal— Discount Premium Ending BV Income-BV Sub 0.51 10,010,117.22 2,020,050.00 0.00 2,630.54 -3,909.84 12,028,887.92 13,719.29 Total/Average FNMA Bond Total/ 0.17 95,233,291.70 17,916,558.39 23,693,298.54 3,433.98 -37,286.20 89,422,699.33 39,550.10 Average 7 of 7 City of Pearland Quarterly Investment Report at Quarterend Report Format:By Transacton Group By:Securty Type Portfolo/Report Group:Report Group:Peariand As of 6/30/2012 Portfolio Settiement Maturity YTM 0 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.05000 6,967,598.27 6,967,598.27 6,967,598.27 6,967,598.27 1 N/A 7.80 Sweep Cash Fund Wets Fargo 17:Municipal WFSWEEP Court 5/31/2006 N/A 0.05000 139,228.95 139,228.95 139,228.95 139,228.95 1 N/A 0.16 Sweep Cash Securty Wets Fargo 18:Cty Sweep Cash WFSWEEP wide 5/31/2006 N/A 0.05000 63,009.23 63,009.23 63,009.23 63,009.23 1 N/A 0.07 Donation Wets Fargo WF51yEEP 19:Court 5/31/2006 N/A 0.05000 228,736.32 228,736.32 228,736.32 228,736.32 1 N/A 0.26 Sweep Cash Technology Wells Fargo WFSWEEP 20:Debt 5/31/2006 N/A 0.05000 7,276,328.37 7,276,328.37 7,276,328.37 7,276,328.37 1 N/A 8.15 Sweep Cash Services 23Welts Fargo 3uv Court Sweep Cash WFSWEEP wenee 9/15/2009 N/A 0.05000 31,178.98 31,178.98 31,178.98 31,178.98 1 N/A 0.03 Mgmt Wets Fargo WFSWEEP 30:Water& 5/31/2006 N/A 0.05000 10,176,693.63 10,176,693.63 10,176,693.63 10,176,693.63 1 N/A 11.39 Sweep Cash Sewer Sees Fargo WFSWEEP 31: 12/1/2006 N/A 0.05000 290,409.04 290,409.04 290,409.04 290,409.04 1 N/A 0.33 Sweep Cash :dwaste Weis Fargo 35:Street WFSWEEP 5/31/2006 N/A 0.05000 343,582.05 343,582.05 343,582.05 343,582.05 1 N/A 0.38 Sweep Cash Assessment Weis Fargo WFSWEEP 42:Utarty 5/31/2006 N/A 0.05000 753,444.00 753,444.00 753,444.00 753,444.00 1 N/A 0.84 Sweep Cash Impact Fee WeIs Fargo 44:Shadow Sweep Cash WFSWEEP Creek 5/31/2006 N/A 0.05000 3,748,583.23 3,748,583.23 3,748,583.23 3,748,583.23 1 N/A 4.20 Impact 45: Sweep Cash WFSWEEP 4Hotel/Motel126878515 Motel 5/31/2006 N/A 0.05000 1,268,785.15 1,268,785.15 1,268,785.15 , , . 1 Wei Fargo N/A 1.42 Occupancy Weis Fargo WFSWEEP 46:Park 5/31/2006 N/A 0.05000 88,839.68 88,839.68 88,839.68 88,839.68 1 N/A 0.10 Sweep Cash Donations 47:Park& Wells Fargo Sweep Cash WFSWEEP 7: 5/31/2006 N/A 0.05000 831,868.70 831,868.70 831,868.70 831,868.70 1 N/A 0. 93 Development I of 6 Portfolio Settlement Maturity VIM @ Face Days To Accrued Wu of Description CUSIP/Tldcer 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.05000 19,083.26 19,083.26 19,083.26 19,083.26 1 NIA 0 C2 Sweep Cash Trust Fund wens Fargo WFSWEEP 50:Captai 5/31/2006 N/A 0.05000 2,476,878.23 2,476,878.23 2,476,878.23 2,476,878.23 1 N'A 2.77 Sweep Cash Projects Wens Fargo WFSWEEP 55:Sidewalk 5/31/2006 NIA 0.05000 208,297.15 208,297.15 208,297.15 208,297.15 1 N/A 0.23 Sweep Cash Fund S Poke Sweep Cash WFSWEEP State 5/31/2006 N/A 0.05000 236,875.67 238,875.67 238,875.67 238,875.671 Wets FargoN/A 0.27 Seizure Wens Fargo WFSWEEP 62:Federal 5/31/2006 N/A 0.05000 32,148.38 32,148.38 32,148.38 32,148.38 1 N/A 0.04 Sweep Cash Police Fund 64Wets Fargo Cert 1998 Sweep Cash WFSWEEP of 5/31/2006 N/A 0.05000 843,966.15 843,966.15 843,966.15 843,966.15 1 N/A 0.94 Obligation Welts Fargo 67:2003 W Sweep Cash WFSWEEP Revenue 5/31/2006 N/A 0.05000 8,269,312.44 8,269,312.44 8,269,312.44 8,269,312.44 1 N/A 9.26 Bonds 68Wells Fargo Cert 2001 Sweep Cash WFSWEEP of 5/31/2006 N/A 0.05000 1,280,157.03 1,280,157.03 1,280,157.03 1,280,157.03 1 N/A 1.43 Obligation Welk Fargo 70:2005 Sweep Cash WFSWEEP Refundng/ 5/31/2006 N/A 0.05000 1,899,151.01 1,899,151.01 1,899,151.01 1,899,151.01 1 N/A 2.13 Motility Wells Fargo WFSWEEP 95:Property 10/31/2006 N/A 0.05000 -99,280.03 -99,280.03 -99,280.03 -99,280.03 1 N/A -0.11 Sweep Cash Liabirty Wells Fargo 97' Sweep Cash WFSWEEP Employee 9/1/2007 N/A 0.05000 39,653.77 39,653.77 39,653.77 39,653.77 1 N/A 0.04 Benefit Trust Wells Fargo 99:COP Sweep Cash WFSWEEP Heath 9/15/2010 N/A 0.05000 -142,753.72 -142,753.72 -142,753.72 -142,753.72 1 N/A -0.16 Clams Fund Wells Fargo 99:COP WF9871 Heath 7/21/2010 N/A 0.04000 358,698.95 358,698.95 358,698.95 358,698.95 1 N/A 0.40 Cash Clams Fund Wells Fargo WFSWEEP ZI01:Grant 5/31/2006 N/A 0.05000 -100,581.87 -100,581.87 -100,581.87 -100,581.87 1 N/A -0.11 Sweep Cash Fund WellsFargo WFSWEEP 2105:2007 5/1/2007 N/A 0.05000 187,54 187.54 187.54 187.54 1 N/A 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z106:2008 3/15/2009 N/A 0.05000 7.14 1.14 1.14 1.14 1 N/A 0.00 Sweep Cash CDBG Fund Welk Fargo WFSWEEP Z107:2009 11/1/2009 N/A 0.05000 15.61 15.61 15.61 15.61 1 N/A 0.00 Sweep Cash CMG Fund 2 of 6 Portfolio Settlement Maturity YTM O 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 Z108:2010 11/1/2010 N/A 0.05000 0.05 0.05 0.05 0.05 1 N/A 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z109:2011 12/1/2011 N/A 0.05000 -7,604.22 -7,604.22 -7,604.22 -7,604.22 1 N/A -0.01 Sweep Cash CDBG Fund Welt rgo Far Z116:CDBG Sweep goh WFSWEEP Recovery 7/31/2009 N/A 0.05000 7.40 7.40 7.40 7.40 1 N/A 0.00 Fund Wells Fargo WFSWEEP 2140:U of H 12/1/2009 N/A 0.05000 79,887.35 79,887,35 79,887.35 79,887.35 1 N/A 0.09 Sweep Cash Fund Wells Fargo Z145: Sweep Cash WFSWEEP Municipal 4/15/2012 N/A 0.05000 10,468.25 10,468.25 10,468.25 10,468.25 1 N/A 0.01 Channel ellsr Fargo Z200:2006 W Sweep Cash WFSWEEP Cert of 6/30/2006 N/A 0.05000 1,776,680.81 1,776,680.81 1,776,680.81 1,776,680.81 1 N/A 1.99 Obligation Wells Fargo Z201:2007 Sweep Cash WFSWEEP Cert of 8/31/2006 N/A 0.05000 1,680,365.86 1,680,365.86 1,680,365.86 1,680,365.86 1 N/A 1.88 Obligation Wells Fargo 2007. Sweep Cash WFSWEEP 2007A Gen 12/31/2007 N/A 0.05000 2,672,851.76 2,672,851.76 2,672,851.76 2,672,851.76 1 N/A 2.99 Obligation Wellsr Fargo Z203:2009 Sweep Cash WFSWEEP Gen 10/30/2008 N/A 0.05000 1,790,336.85 1,790,336.85 1,790,336.85 1,790,336.85 1 N/A 2.00 Obligation Welt Fargo Pa0A W/S Sweep Cash WFSWEEP Pay As U Go 12/31/2007 N/A 0.05000 1,708,640.25 1,708,640.25 1,708,640.25 1,708,640.25 1 N/A 1.91 CIP Sub Total/ 0.04994 57,243,730.67 57,243,730.67 57,243,730.67 57,243,730.67 1 0.00 64.09 Average Certificate Of Deposit 21ST CENTURY 10:General 0.25 CD90136SFD3 Fund 2/13/2012 2/13/2013 0.25000 248,000.00 248,000.00 248,000.00 247,699.67 228 28.88 0.28 2/13/2013 CDARS 0.6 CD1013981872 10:General 6/21/2012 6/19/2014 0.60000 500,000.00 500,000.00 500,000.00 500,000.00 719 73.97 0.56 6/19/2014 Fund CDARS 0.75 CD1012781942 10:General 9j15/2011 9/13/2012 0.75000 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 75 5,938.36 1.12 9/13/2012 Fund Moody National 10:General Bank 0.5 CO600071308 Fund 5/30/2012 11/30/2012 0.50000 245,000.00 245,000.00 245,000.00 245,000.00 153 104.04 0.27 11/30/2012 3 of 6 Portfolio Settlement Maturity YTM gi Face Days To Accrued %of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Mature Interest Portfob FARMERS& MERCHANTS CD307812HH3 20:Debt 2/17/2012 2/15/2013 0.25000 248,000.00 248,000.00 248,000.00 247,706.86 230 227.62 0.28 0.25 Services 2/15/2013 AMERICAN NATIONAL 30:Water& 0.28 BANK 0.25 CD02771PKZ9 Sewer 5/3/2012 5/3/2013 0.25000 248,000.00 248,000.00 248,000.00 247,417.70 307 98.52 5/3/2013 REAL BANK 0.3 CD07370TKX0 30:Water& 2/15/2012 2/13/2013 0.30000 248,000.00 248,000.00 248,000.00 247,756.71 228 277.22 0.28 2/13/2013 Sewer DISCOVER 35:Street BANK 0.25 CD2546703U4 Assessment 2/15/2012 2/15/2013 0.25000 248,000.00 248,000.00 248,000.00 247,691.74 230 231.01 0.28 2/15/2013 GOLDMAN 44:Shadow SACHS 0.25 CD38143AIZ9 Creek 2/15/2012 2/15/2013 0.25000 248,000.00 248,000.00 248,000.00 247,691.74 230 231.01 0.28 2/15/2013 Impact KEY BANK 0.25 45: 2/15/2013 CD49306SPE0 HoteVMotel 2/15/2012 2/15/2013 0.25000 248,000.00 248,000.00 248,000.00 247,691.74 230 231.01 0.28 Occupancy PACIFIC 47:Park& CONTINENTAL CD69413CC00 Rec 2/15/2012 2/15/2013 0.25000 248,000.00 248,000.00 248,000.00 247,709.84 230 25.48 0.28 0.25 Development 2/15/2013 MIZUHO CORP 67:2003 BANK 0.3 CD60688TBR9 Revenue 5/2/2012 5/2/2013 0.30000 248,000.00 248,000.00 248,000.00 246,969.81 306 120.26 0.28 5/2/2013 Bonds PRNATE BANK 68:2001 0.25 CD74269TBK2 Cert of 2/15/2012 2/15/2013 0.25000 248,000.00 248,000.00 248,000.00 247,709.84 230 25.48 0.28 2/15/2013 Obligation APPLE BANK 0.3 2202: 2/22/2013 CD037830FX9 2007A Gen 2/22/2012 2/22/2013 0.30000 248,000.00 248,000.00 248,000.00 247,737.62 237 262.95 0.28 Oblgation Sub Total/ 0.42292 4,473,000.00 4,473,000.00 4,473,000.00 4,468,783.27 254 7,875.81 5.01 Average FFCB Bond _.. FFCB 0.4 31331KZB9 10:General 9/20/2011 9/20/2013 0.41258 600,000.00 599,850.00 599,908.33 600,236.40 447 666.67 0.67 9/20/2013-12 Fund FFCB 0.75 31331K3Q4 10:General Fund 5/2/2011 5/2/2013 0.75000 1,000,000.00 1,000,000.00 1,000,000.00 1,003,651.00 306 1,208.33 1.12 FFCB 0.48 67:2003 12/26/2014-13 3133EAV34 Revenue 6/26/2012 12/26/2014 0.48000 1,000,000.00 1,000,000.00 1,000,000.00 1,001,404.00 909 53.33 1.12 Bonds 4 of 6 Portfolio Settlement Maturity YTM 0 Face Days To Accrued %of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Ave Total/Average 0.56829 2,600,000.00 2,599,850.00 2,599,908.33 2,605,291.40 570 1,928.33 2.91 FHLB Bond FMB 10:General 3133XUK93 2/22/2011 9/14/2012 0.62617 1,000,000.00 1,021,300.00 1,002,804.63 1,003,697.00 76 5,888.89 1.12 9/14/2012 1Furd 0: FHLB 2 3133XQU34 10;General 5/29/29/2013013 Fund 5/31/2011 5/29/2013 0.53011 1,000,000.00 1,061,320.00 1,028,058.80 1,030,508.00 333 3,121.53 1.12 FHLB 0 313384180 20:Debt 4/26/2012 10/24/2012 0.14243 1,000,000.00 999,296.11 999,548.89 999,715.00 116 0.00 1.12 10/24/2012 Services FHLB 0.875 30:Water& 8/22/2012 3133X'YWB7 Sewer 2/22/2011 8/22/2012 0.60004 1,000,000.00 1,004,100.37 1,000,394.85 1,001,006.00 53 3,111.11 1.12 FHLB 3.625 30:Water& 5/29/2013 3133XQU34 Sewer 5/31/2011 5/29/2013 0.53011 1,000,000.00 1,061,320.00 1,028,058.80 1,030,508.00 333 3,121.53 1.12 FHLB 1.81 3/26/2013 3133XWGP8 42:F 3/27/2012 3/26/2013 0.24004 1,000,000.00 1,015,628.00 1,011,579.52 1,011,347.00 269 4,726.11 1.12 e FHLB 0.2 67:2003 12/13/2012 313376LR4 Revenue 3/27/2012 12/13/2012 0.18195 1,000,000.00 1,000,127.00 1,000,080.86 1,000,093.00 166 94.44 1.12 Bonds FHLB 1.625 67:2003 11/21/2012 3133XVEM9 Revenue 2/8/2012 11/21/2012 0.15977 1,000,000.00 1,011,506.00 1,005,732.67 1,005,691.00 144 1,760.42 1.12 Bonds Sub Total/ 0.37633 8,000,000.00 8,174,597.48 8,076,259.02 8,082,565.00 186 21,824.03 8.96 Average FHLMC Bond FHLMC 0 313397DU2 10:General 4/26/2012 4/1/2013 0.17257 1,000,000.00 998,394.44 998,701.39 998,637.00 275 0.00 1.12 4/1/2013 Fund FHLMC 0.375 3134G3SB7 10:General 3/27/2012 4/28/2014 0.46657 1,000,000.00 998,100.00 998,335.29 999,918.00 667 1,270.83 1.12 4/28/2014 Fund FHLMC 1.125 3137F.ACK3 20'Debt 2/8/2012 7/27/2012 0.11980 1,000,000.00 1,004,716.00 1,000,753.44 1,000,649.00 27 4,781.25 1.12 7/27/2012 Services FHLMC 0.75 3134G1P65 42:Imo 6/30/2011 12/28/2012 0.43281 2,000,000.00 2,009,440.00 2,003,123.27 2,005,286.00 181 83.33 2.24 12/28/2012 Impact Fee Sub Total/ 0.32491 5,000,000.00 5,010,650.44 5,000,913.39 5,004,490.00 266 6,135.41 5.60 Average FNMA Bond FNMA 0.5 3136GOFF3 10:General 5/1/2012 10/30/2014 0.50000 1,000,000.00 1,000,000.00 1,000,000.00 1,000,009.00 852 833.33 1.12 10/30/2014-13 Fund 5 of 6 Portfolio Settlement Maturely `/TM tG` Face Days To Accrued %of Deauiptb0 CUSIP/Tidier Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio FNMA 0.75 3135GOAK9 30:General 2/8/2012 2/26/2013 0.17780 1,000,000.00 1,006,000.00 1,003,746.03 1,003,180.00 241 2,583.33 1.12 2/26/2013 Fund FNMA 0.5 31398A4T6 10 General 3/30/2011 10/30/2012 0.62402 2,000,000.00 1,996,097.64 1,999,178.45 2,002,292.00 122 1,666.67 2.24 10/30/2012und FNMA 0.375 3139886F4 20:Debt 1/28/2011 12/28/2012 0.66003 1,000,000.00 994,580.00 998,601.80 1,001,154.00 181 20.83 1.12 12/28/2012 Services FNMA 1.05 31398A458 30:Water& 3/27/2012 10/22/2013 0.36058 1,000,000.00 1,010,780.00 1,009,005.59 1,008,746.00 479 1,983.33 1.12 10/22/2013 Sewer FNMA 0.375 31398A6F4 30:Water& 1/28/2011 12/28/2012 0.66003 1,000,000.00 994,580.00 998,601.130 1,001,154.00 181 20.83 1.12 12/28/2012 Sewer FNMA 0.5 30:WaterS 31398A4T6 3/30/2011 10/30/2012 0.62402 1,000,000.00 998,048.82 999,589.23 1,001,146.00 122 833.33 1.1 2 10/30/2012 Sewer FNMA 1.3 3136FPWZ6 30:Water B. 6/20/2012 11/17/2014 0.46187 1,000,000.00 1,020,050.00 1,019,818.74 1,020,258.00 870 1,552.78 1.12 11/17/2014 Sewer FNMA 0.5 31398A4T6 42:Ut8ty 3/30/2011 10/30/2012 0.62402 1,000,000.00 998,048.82 999,589.23 1,001,146.00 122 833.33 1.12 10/30/2012 Impact Fee FNMA70:2005 0.5 10/30/2012 3136FPUC9 Refundig/ 6/30/2011 10/30/2012 0.38604 2,000,000.00 2,003,028.20 2,000,757.05 2,001,636.00 122 1,666.67 2.24 Mobilty Sub Total/ 0.50737 12,000,000.00 12,021,213.48 12,028,887.92 12,040,721.00 295 11,994.43 13.44 Average Total/ 0.18979 89,316,730.67 89,523,042.07 89,422,699.33 89,445,581.34 101 49,758.01 100 Average 6 of 6 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/2012 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 Welts Fargo Sweep Cash WFSWEEP Cash 5/31/2006 6,967,598.27 6,967,598.27 6,967,598.27 0.05000 N/A 1 7.80 21ST CENTURY 0.25 CD901365FD3 Certificate Of 2/13/2012 248,000.00 248,000.00 247,699.67 0.25000 2/13/2013 228 0.28 2/13/2013 Deposit CDARS 0.6 6/19/2014 CD1013981872 Certf ate Of 6/21/2012 500,000.00 500,000.00 500,000.00 0.60000 6/19/2014 719 0.56 Deposit CDARS 0.75 9/13/2012 C01012781942 Certficate Of 9/15/2011 1,000,000.00 1,000,000.00 1,000,000.00 0.75000 9/13/2012 75 1.12 Deposit Moody National Bank CD600071308 CertFcate Of 5/30/2012 245,000.00 245,000.00 245,000.00 0.50000 11/30/2012 153 0.27 0.5 11/30/2012 Deposit FFCB 0.4 9/20/2013-12 31331KZB9 FFCB Bond 9/20/2011 600,000.00 599,908.33 600,236.40 0.41258 9/20/2013 447 0.67 FFCB 0.75 5/2/2013 31331KJQ4 FFCB Bond 5/2/2011 1,000,000.00 1,000,000.00 1,003,651.00 0.75000 5/2/2013 306 1.12 FHLB 2 9/14/2012 3133XUK93 FHLB Bond 2/22/2011 1,000,000.00 1,002,804.63 1,003,697.00 0.62617 9/14/2012 76 1.12 FHLB 3.625 5/29/2013 3133XQU34 FHLB Bond 5/31/2011 1,000,000.00 1,028,058.80 1,030,508.00 0.53011 5/29/2013 333 1.12 FHLMC 0 4/1/2013 313397DU2 FHLMC Bond 4/26/2012 1,000,000.00 998,701.39 998,637.00 0.17257 4/1/2013 275 1.12 FHLMC 0.375 3134035B7 FHLMC Bond 3/27/2012 1,000,000.00 998,335.29 999,918.00 0.46657 4/28/2014 667 1.12 4/28/2014 FNMA 0.5 3136GOFF3 FNMA Bond 5/1/2012 1,000,000.00 1,000,000.00 1,000,009.00 0.50000 10/30/2014 852 1.12 10/30/2014-13 FNMA 0.75 2/26/2013 3135GOAK9 FNMA Bond 2/8/2012 1,000,000.00 1,003,746.03 1,003,180.00 0.17780 2/26/2013 241 1.12 FNMA 0.5 10/30/2012 31398A4T6 FNMA Bond 3/30/2011 2,000,000.00 1,999,178.45 2,002,292.00 0.62402 10/30/2012 122 2.24 Sub Total/Average 18,560,598.27 18,591,331.19 18,602,426.34 0.33952 205 20.78 17:Municpal Court Security We Fargo Sweep Cash WFSWEEP Cash 5/31/2006 139,228.95 139,228.95 139,228.95 0.05000 N/A 1 0.16 Sub Total/Average 139,228.95 139,228.95 139,228.95 0.05000 1 0.16 18:City Wide Donation 1 of 7 Security Settlement Face YTM 0 Maturity Days To %of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 63,009.23 63,009.23 63,009.23 0.05000 N/A 1 0.07 Sub Total/Average 63,009.23 63,009.23 63,009.23 0.05000 1 0.07 19:Court Technology We Fargo Sweep Cash WFSWEEP Cash 5/31/2006 228,736.32 228,736.32 228,736.32 0.05000 N/A 1 0.26 Sub Total/Average 228,736.32 228,736.32 228,736.32 0.05000 1 0.26 20:Debt Services We Fargo Sweep Cash WFSWEEP Cash 5/31/2006 7,276,328.37 7,276,328.37 7,276,328.37 0.05000 N/A 1 8.15 FARMERS& Certificate Of MERCHANTS 0.25 CD307812HH3 Deposit2/17/2012 248,000.00 248,000.00 247,706.86 0.25000 2/15/2013 230 0.28 2/15/2013 FHLB 0 10/24/2012 313384L80 FHLB Bond 4/26/2012 1,000,000.00 999,548.89 999,715.00 0.14243 10/24/2012 116 1.12 FHLMC 1.125 3137EACK3 FHLMC Bond 2/8/2012 1,000,000.00 1,000,753.44 1,000,649.00 0.11980 7/27/2012 27 1.12 7/27/2012 FNMA 0.375 31398A6F4 FNMA Bond 1/28/2011 1,000,000.00 998,601.80 1,001,154.00 0.66003 12/28/2012 181 1.12 12/28/2012 Sub Total/Average 10,524,328.37 10,523,232.50 10,525,553.23 0.12809 37 11.78 23:Court Juvenile Mgmt Well Fargo Sweep Cash WFSWEEP Cash 9/15/2009 31,178.98 31,178.98 31,178.98 0.05000 N/A 1 0.03 Sub Total/Average 31,178.98 31,178.98 31,178.98 0.05000 1 0.03 30:Water&Sewer Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 10,176,693.63 10,176,693.63 10,176,693.63 0.05000 N/A 1 11.39 AMERICAN NATIONAL CD02771PKZ9 Certificate Of 5/3/2012 248,000.00 248,000.00 247,417.70 0.25000 5/3/2013 307 0.28 BANK 0.25 5/3/2013 Deposit REAL BANK 0.3 CD07370TKX0 Certificate Of 2/15/2012 248,000.00 248,000.00 247,756.71 0.30000 2/13/2013 228 0.28 2/13/2013 Deposit FHLB 0.875 8/22/2012 3133XYWB7 FHLB Bond 2/22/2011 1,000,000.00 1,000,394.85 1,001,006.00 0.60004 8/22/2012 53 1.12 FH13 3.625 5/29/2013 3133XQU34 FHLB Bond 5/31/2011 1,000,000.00 1,028,058.80 1,030,508.00 0.53011 5/29/2013 333 1.12 FNMA 1.05 10/22/2013 31398A4S8 FNMA Bond 3/27/2012 1,000,000.00 1,009,005.59 1,008,746.00 0.36058 10/22/2013 479 1.12 FNMA 0.375 31398A6F4 FNMA Bond 1/28/2011 1,000,000.00 998,601.80 1,001,154.00 0.66003 12/28/2012 181 1.12 12/28/2012 2 of 7 Security Settlement Face YTM 0 Maturity Days To %of Description CUSIP/Tidcer Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfo8o FNMA 0.5 10/30/2012 31398A4T6 FNMA Bond 3/30/2011 1,000,000.00 999,589.23 1,001,146.00 0.62402 10/30/2012 122 1.12 FNMA 1.3 11/17/2014 3136FPWZ6 FNMA Bond 6/20/2012 1,000,000.00 1,019,818.74 1,020,258.00 0.46187 11/17/2014 870 1.12 Sub Total/Average 16,672,693.63 16,728,162.64 16,734,686.04 0.23283 131 18.67 31:Solidwaste Weis Fargo Sweep Cash WFSWEEP Cash 12/1/2006 290,409.04 290,409.04 290,409.04 0.05000 N/A 1 0.33 Sub Total/Average 290,409.04 290,409.04 290,409.04 0.05000 1 0.33 35:Street Assessment Welk Fargo Sweep Cash WFSWEEP Cash 5/31/2006 343,582.05 343,582.05 343,582.05 0.05000 N/A 1 0.38 DISCOVER BANK 0.25 CD2546703U4 Certificate Of 2/15/2012 248,000.00 248,000.00 247,691.74 0.25000 2/15/2013 230 0.28 2/15/2013 Depost Sub Total/Average 591,582.05 591,582.05 591,273.79 0.13384 97 0.66 42:Utility Impact Fee Wei Fargo Sweep Cash WFSWEEP Cash 5/31/2006 753,444.00 753,444.00 753,444.00 0.05000 N/A 1 0.84 FHLB 1.81 3/26/2013 3133XWGP8 FHLB Bond 3/27/2012 1,000,000.00 1,011,579.52 1,011,347.00 0.24004 3/26/2013 269 1.12 FHLMC 0.75 3134G1P65 FHLMC Bond 6/30/2011 2,000,000.00 2,003,123.27 2,005,286.00 0.43281 12/28/2012 181 2.24 12/28/2012 FNMA 0.5 10/30/2012 31398A4T6 FNMA Bond 3/30/2011 1,000,000.00 999,589.23 1,001,146.00 0.62402 10/30/2012 122 1.12 Sub Total/Average 4,753,444.00 4,767,736.02 4,771,223.00 0.37180 159 5.32 44:Shadow Creek Impact Welk Fargo Sweep Cash WFSWEEP Cash 5/31/2006 3,748,583.23 3,748,583.23 3,748,583.23 0.05000 N/A 1 4.20 GOLDMAN SACHS 0.25 CD38143AIZ9 Certificate Of 2/15/2012 248,000.00 248,000.00 247,691.74 0.25000 2/15/2013 230 0.28 2/15/2013 Deposit Sub Total/Average 3,996,583.23 3,996,583.23 3,996,274.97 0.06241 15 4.47 45:Hotel/Motel Occupancy Wets Fargo Sweep Cash WFSWEEP Cash 5/31/2006 1,268,785.15 1,268,785.15 1,268,785.15 0.05000 N/A 1 1.42 KEY BANK 0.25 CD493065PE0 Certf'icate Of 2/15/2012 248,000.00 248,000.00 247,691.74 0.25000 2/15/2013 230 0.28 2/15/2013 Depost Sub Total/Average 1,516,785.15 1,516,785.15 1,516,476.89 0.08270 38 1.70 3 of 7 Security Settlement Face YIN• Maturity Days To %of Description CUSIP/71dcer Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio 46:Pant Donations Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 88,839.68 88,839.68 88,839.68 0.05000 N/A 1 0.10 Sub Total/Average 88,839.68 88,839.68 88,839.68 0.05000 1 0.10 47:Park&Rec Development Well Fargo Sweep Cash WFSWEEP Cash 5/31/2006 831,868.70 831,868.70 831,868.70 0.05000 N/A 1 0.93 PACB=IC CONTINENTAL CD69413CCQO Certificate Of 2/15/2012 248,000.00 248,000.00 247,709.84 0.25000 2/15/2013 230 0.28 0.25 2/15/2013 Deposit Sub Total/Average 1,079,868.70 1,079,868.70 1,079,578.54 0.09593 54 1.21 49:Tree Trust Fund -- - _ We Fargo Sweep Cash WFSWEEP Cash 5/31/2006 19,083.26 19,083.26 19,083.26 0.05000 N/A 1 0.02 Sub Total/Average 19,083.26 19,083.26 19,083.26 0.05000 1 0.02 --50:Capital Projects Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 2,476,878.23 2,476,878.23 2,476,878.23 0.05000 N/A 1 2.77 Sub Total/Average 2,476,878.23 2,476,878.23 2,476,878.23 0.05000 1 2.77 55:Sidewalk Fund We Fargo Sweep Cash WFSWEEP Cash 5/31/2006 208,297.15 208,297.15 208,297.15 0.05000 N/A 1 0.23 Sub Total/Average 208,297.15 208,297.15 208,297.15 0.05000 1 0.23 60:Police State Seizure Wets Fargo Sweep Cash WFSWEEP Cash 5/31/2006 238,875.67 238,875.67 238,875.67 0.05000 N/A 1 0.27 Sub Total/Average 238,875.67 238,875.67 238,875.67 0.05000 1 0.27 62:Federal Poke Fund Web Fargo Sweep Cash WFSWEEP Cash 5/31/2006 32,148.38 32,148.38 32,148.38 0.05000 N/A 1 0.04 Sub Total/Average 32,148.38 32,148.38 32,148.38 0.05000 1 0.04 64:1998 Cert of Obligation Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 843,966.15 843,966.15 843,966.15 0.05000 N/A 1 0.94 4 of 7 Seo r*y Settlement Face YTM ft, Maturity Days To %of Description CUSIP/Tidcer Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Sub Total/Average 843,966.15 843,966.15 843,966.15 0.05000 1 0.94 67:2003 Revenue Bonds Wets Fargo Sweep Cash WFSWEEP Cash 5/31/2006 8,269,312.44 8,269,312.44 8,269,312.44 0.05000 N/A 1 9.26 MIZUHO CORP BANK 0.3 CD60688TBR9 Certificate Of 5/2/2012 248,000.00 248,000.00 246,969.81 0.30000 5/2/2013 306 0.28 5/2/2013 Deposit FFCB 0.48 3133EAV14 FFCB Bond 6/26/2012 1,000,000.00 1,000,000.00 1,001,404.00 0.48000 12/26/2014 909 1.12 12/26/2014-13 FHLB 0.2 12/13/2012 313376LR4 FHLB Bond 3/27/2012 1,000,000.00 1,000,080.86 1,000,093.00 0.18195 12/13/2012 166 1.12 FHLB 1.625 3133XVEM9 FHLB Bond 2/8/2012 1,000,000.00 1,005,732.67 1,005,691.00 0.15977 11/21/2012 144 1.12 11/21/2012 Sub Total/Average 11,517,312.44 11,523,125.97 11,523,470.25 0.11371 113 12.89 68:2001 Cert of Obligation Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 1,280,157.03 1,280,157.03 1,280,157.03 0.05000 N/A 1 1.43 PRIVATE BANK 0.25 CD74269TBK2 Certificate Of 2/15/2012 248,000.00 248,000.00 247,709.84 0.25000 2/15/2013 230 0.28 2/1S/2013 Deposit Sub Total/Average 1,528,157.03 1,528,157.03 1,527,866.87 0.08246 38 1.71 70:2005 Refunding/Moblity Wets Fargo Sweep Cash WFSWEEP Cash 5/31/2006 1,899,151.01 1,899,151.01 1,899,151.01 0.05000 N/A 1 2.13 FNMA 0.5 10/30/2012 3136FPUC9 FNMA Bond 6/30/2011 2,000,000.00 2,000,757.05 2,001,636.00 0.38604 10/30/2012 122 2.24 Sub Total/Average 3,899,151.01 3,899,908.06 3,900,787.01 0.22237 63 4.37 95:Property Liability Weis Fargo Sweep Cash WFSWEEP Cash 10/31/2006 -99,280.03 -99,280.03 -99,280.03 0.05000 N/A 1 -0.11 Sub Total/Average -99,280.03 -99,280.03 -99,280.03 0.05000 1 -0.11 97:Employee Benefit Trust Weis Fargo Sweep Cash WFSWEEP Cash 9/1/2007 39,653.77 39,653.77 39,653.77 0.05000 N/A 1 0.04 Sub Total/Average 39,653.77 39,653.77 39,653.77 0.05000 1 0.04 99:COP Health Claims Fund 5 of 7 Security Settlement Face YTM @ Maturity Days To 0/of Description CUSIP/Tiidser Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Wells Fargo Sweep Cash WFSWEEP Cash 9/15/2010 -142,753.72 -142,753.72 -142,753.72 0.05000 N/A 1 -0.16 Wells Fargo MM WF9871 Money 7/21/2010 358,698.95 358,698.95 358,698.95 0.04000 N/A 1 0.40 Market Sub Tu I/Avoraga 215,945.23 215,945.23 213,945.23 0.03339 1 0.24 Z101:Grant Fund Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 -100,581.87 -100,581.87 -100,581.87 0.05000 N/A 1 -0.11 Sub Total/Average -100,581.87 -100,581.87 -100,581.87 0.05000 1 -0.11 Z105:2007 CDBG Fund We Fargo Sweep Cash WFSWEEP Cash 5/1/2007 187.54 187.54 187.54 0.05000 N/A 1 0.00 Sub Total/Average 187.54 187.54 187.54 0.05000 1 0.00 Z106:2008 CDBG Fund Wets Fargo Sweep Cash WFSWEEP Cash 3/15/2009 1.14 1.14 1.14 0.05000 WA 1 0.00 Sub Total/Average 1.14 1.14 1.14 0.05000 1 0.00 Z107:2009 CDBG Fund Were Fargo Sweep Cash WFSWEEP Cash 11/1/2009 15.61 15.61 15.61 0.05000 N/A 1 0.00 Sub Total/Average 15.61 15.61 15.61 0.05000 1 0.00 2108:2010 CDBG Fund Were Fargo Sweep Cash WFSWEEP Cash 11/1/2010 0.05 0.05 0.05 0.05000 N/A 1 0.00 Sub Total/Average 0.05 0.05 0.05 0.05000 1 0.00 Z109:2011 CDBG Fund We Fargo Sweep Cash WFSWEEP Cash 12/1/2011 -7,604.22 -7,604.22 -7,604.22 0.05000 N/A 1 -0.01 Sub Total/Average -7,604.22 -7,604.22 -7,604.22 0.05000 1 -0.01 Z116:CDBG Recovery Fund Wells Fargo Sweep Cash WFSWEEP Cash 7/31/2009 7.40 7.40 7.40 0.05000 N/A 1 0.00 Sub Total/Average 7.40 7.40 7.40 0.05000 1 0.00 6 of 7 Security Settlement Face YTM @ Maturity Days To %of Description CUSIP/Tiicker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Z140:U of H Fund Weis Fargo Sweep Cash WFSWEEP Cash 12/1/2009 79,887.35 79,887.35 79,887.35 0.05000 N/A 1 0.09 Sub Total/Average 79,887.35 79,887.35 79,887.35 0.05000 1 0.09 Z145:Municipal Channel Weis Fargo Sweep Cash WFSWEEP Cash 4/15/2012 10,468.25 10,468.25 10,468.25 0.05000 WA 1 0.01 Sub Total/Average 10,468.25 10,468.25 10,468.25 0A5000 1 0.01 Z200:2006 Cert of Obligation Welt Fargo Sweep Cash WFSWEEP Cash 6/30/2006 1,776,680.81 1,776,680.81 1,776,680.81 0.05000 WA 1 1.99 Sub Total/Average 1,776,680.81 1,776,680.81 1,776,680.81 0.05000 1 1.99 2201:2007 Cert of Obligation Weis Fargo Sweep Cash WFSWEEP Cash 8/31/2006 1,680,365.86 1,680,365.86 1,680,365.86 0.05000 N/A 1 1.88 Sub Total/Average 1,680,365.86 1,680,365.86 1,680,365.86 0.05000 1 1.88 Z202:2007A Gen Obligation Weis Fargo Sweep Cash WFSWEEP Cash 12/31/2007 2,672,851.76 2,672,851.76 2,672,851.76 0.05000 N/A 1 2.99 APPLE BANK 0.3 CDC37830FX9 Certificate Of 2/22/2012 248,000.00 248,000.00 247,737.62 0.30000 2/22/2013 237 0.28 2/22/2013 Deposit Sub Total/Average 2,920,851.76 2,920,851.76 2,920,589.38 0.07123 21 3.27 2203:2009 Gen Obligation Welt Fargo Sweep Cash WFSWEEP Cash 10/30/2008 1,790,336.85 1,790,336.85 1,790,336.85 0.05000 N/A 1 2.00 Sub Total/Average 1,790,336.85 1,790,336.85 1,790,336.85 0.05000 1 2.00 Z301:W/S Pay As U Go CID Weis Fargo Sweep Cash WFSWEEP Cash 12/31/2007 1,708,640.25 1,708,640.25 1,708,640.25 0.05000 N/A 1 1.91 Sub Total/Average 1,708,640.25 1,708,640.25 1,708,640.25 0.05000 1 1.91 Total/Average 89,316,730.67 89,422,699.33 89,445,581.34 0.18979 101 100 7 of 7 City of Pearland Purchases Portfoio/Report Group:Report Group:Pearland From 3/31/2012 To 6/30/2012 Portfoio Settlement Maturity Face YTM 0 Name Description Bullet/Callable CUSIP/Tidrer Action Date Date Price Amount/Shares Cost Prindpal Interest/Dkvidends Broker/DeaMr 20:Debt FHLB 0 313384L80 Buy 4/26/2012 10/24/2012 99.929611 1,000,000.00 0.14243 999,296.11 0.00 Frost Bank Services 10/24/2012 10: FHLMC 0 General 4/1/2013 313397DU2 Buy 4/26/2012 4/1/2013 99.839444 1,000,000.00 0.17257 998,394.44 0.00 Frost Bank Fund 10: FNMA 0.5 Comerica General 10/30/2014-13 Yes 3136GOFF3 Buy 5/1/2012 10/30/2014 100 1,000,000.00 0.50000 1,000,000.00 0.00 Securities Fund 67: MIZUHO CORPWls 2003 BANK 0.3 CD60688TBR9 Buy 5/2/2012 5/2/2013 100 248,000.00 0.30000 248,000.00 0.00 BankFargo Revenue 5/2/2013 Bonds AMERICAN NATIONAL Fargo Water& CO02771PKZ9 Buy 5/3/2012 5/3/2013 100 248,000.00 0.25000 248,000.00 0.00 BWan ells k Sewer BANK 0.25 5/3/2013 10: Moody National Moody Natbnal General Bank 0.5 CD600071308 Buy 5/30/2012 11/30/2012 100 245,000.00 0.50000 245,000.00 0.00 Fund 11/30/2012 Bank 30: FNMA 1.3 Water& 11/17/2014 3136FPWZ6 Buy 6/20/2012 11/17/2014 102.005 1,000,000.00 0.46187 1,020,050.00 1,191.67 First Southwest Sewer 10: CDARS 0.6 Independence General 6/19/2014 CD1013981872 Buy 6/21/2012 6/19/2014 100 500,000.00 0.60000 500,000.00 0.00 Bank Fund 67: 2003 FFCB 0.48 Yes 3133EAV14 Buy 6/26/2012 12/26/2014 100 1,000,000.00 0.48000 1,000,000.00 0.00 Comerka Revenue 12/26/2014-13 Securties Bonds 1 of I Pledged Collateral Reconciliation Report June 30, 2012 Bank Account Number Account Name Amount Wets Fargo 201-0419505 Operating $ - Wells Fargo 201-0419513 Payroll Fund - Wells Fargo 001-3042841 Sweep Account 67,509,717.92 Wells Fargo 201-0419554 98 CO Escrow - Wells Fargo 807-1613395 Credit Card Account 596,333.22 Wells Fargo 818-4567843 Alvin ISD 7,980,260.78 Wells Fargo 001-3043112 PEDC Sales Tax - Wells Fargo 280-7409871 Health Claims 358,698.95 Wells Fargo 865-9860145 BC MUD#4 26,767.97 Wells Fargo Certificate of Deposit - Total of Bank Balances $ 76,471,778.84 Pledged Collateral for City 87,633,555.68 FDIC Insurance 250,000.00 Total Collateral $ 87,883,555.68 Over(Under)Collateralized $ 11,411,776.84 Total%Collateralized 114.9% Bank Account Number Account Name Amount Wells Fargo 100-7284258 Development Authority 1,005,469.85 Total of Bank Balances $ 1,005,469.85 Pledged Collateral for DAP 9,561,774.04 FDIC Insurance 250,000.00 Total Collateral $ 9,811,774.04 Over(Under)Collateralized $ 8,806,304.19 Total%Collateralized 975.8% Total$Over(Under)Collateralized $ 20,218,081.03 Total%Collateralized 126.1% Status Collateralized I:\Investmentsllnvestment Reports\City of Pearland\Investment Report-City-Otr 0612