Loading...
R2010-110 - 2010-08-23ATTEST: APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY RESOLUTION NO. R2010 -110 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS, ACCEPTING THE CITY'S INVESTMENT REPORT FOR THE QUARTER ENDING JUNE 2010. 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 2010. PASSED, APPROVED, AND ADOPTED this 23 day of August, A.D,, 2010. TOM REID MAYOR d City of Pearland Cr's °�= e1'� Quarterly Investment Report Ap.y3N' `��`5 . March 31, 2010 -June 30, 2010. Portfolio at March 31.2010 Portfolio at June 30.2010 Ending.Book Value $ 132,904,150.98 Ending Book Value $ 121,777,699.40 Ending Market Value 132,899,202.68 Ending Market Value 121,787,908.39 Accrued Interest Receivable 78,217.95 Accrued Interest Receivable 90,119.99 FYD Total Interest Earned 172,656.03 FYD Total Interest Earned 252,352.31 Unrealized Gain/(Loss) (4,948.30) Unrealized Gain/(Loss) 10,208.99 Change in Unrealized Gain/Loss (2,249.42) Change in Unrealized Gain/Loss 15 157.29 Weighted Average Maturity 27 Days Weighted Average Maturity 41 Days Change in Market Value (18,000,936.45) Change in Market Value (11,111,294 29) Yield to Maturity at Cost 0.22% Yield to.Maturity at Cost 0.31% T-Bill Benchmark 0.41% T-Bill Benchmark 0.32% Agency Note Benchmark 0.18% Agency Note Benchmark 0.25% Average for Quarter City's Yield to Maturity 0.25% 1 Year T-Bill Benchmark Yield 0.38% Agency Note Benchmark Yield 0.20% This quarterly report is in compliance with the investment policyand strategy as established by the City and the Public.Funds Investment Act (Chapter 2256,Texas.Government Code). Prepared by: a _b h1/l14 i r[ Claire Bogard Rick r aar Iakw 9 Fatima. Director of Finance Assistan Direc r of Finance Senior Accountant Interest Rates fide 1.ms 3 mo 6 mo lxc 2,X! i.yr L Yi ?w 1QYi 70 yr 30 yr 3/31/2010 0.15 0.16 0.24 0.41 1.02 1.60 2.55 3.28 3.84 4.55 4.72 6/30/2010 0.17 0.18 0.22 0.32 0.61 1.00 1.79 2.42 2.97 3.74 3.91 • Yield Curve Comparison 5.00 { e' 4.1{I�1 t' "r r 4.50 t!r" {si Iili'{ t, i f € 3 11'''ii+t i rr , ` 1' 11�t -`i Lfil i- '• a , r f t•ilimin' �� ,-, I f !, 1 r ."• ,, , i' �i t I ,{t l it i t z,�_ I � , �: r i) .� 111 1 'l Fri /y� . ,t 1, '1} ,{ ; 1� •r a �,i� {( ,1♦ , 3 hl'1; ��jl +{ i�� �'1i I -1 r ti 1.00 { � i ; Al,.! �W SIT d, i.j t tfi�' f'1 'it Y� 1�t i��i iHfl ?t � I, 1 •� I ���>5�� Y�11.�L1 { ] 1 t A. 1.._t t'. r ..r , •1 ! , I f.. ,• '`j ! 1 4 .fzanMyS ' }'I, � 't �; i'� �� F.a. .. ... ;�t ` ' t 1 falii•to un t;ie ami l. o 3.50 a , , �, ,» 1 Rirt , i4 t: n s .`" City s Weighted Avg Yield.259E ` tligr Tim: 2.50 = 41 Day Average Mdiurity :. I{ 9 2.00 i ' {#! _ {� It {��F YE 1.50 ' '` , fi l�.ti �..... .t f in ikti4 iiia ilil fE 111 f.: letl 1.00 .I. 050 t 1 _ ...�"""r ..e lt!>. ..CtY }Siii .�l i114.iettriiii i.if{F!� ! t t tj .^i 0.00 �ac ,{lii�tife i't, ,�f{ t, ' tt'm . �E( tt.1L.,,'ril..T, i:u1,tS ti( Ei`tp;(,Nu. t.i.l.@t Imo 3mo 6mo 1yr 2yr 3yr 5yr Tyr l0yr 20yr 30yr t3/31/2010 -f-6/30/2010 Portfolio vs. Benchmarks 6.0096 r • .m as d„. .m.. . � -- i c _ � 5.00% ^. 0 , s 4,00% _ '' u I. 2.00% .. �;. •,: r swarm a ca-p„ .,w.i�t.�,..u!s a i r,m. "� r 7k• p t , 5 t i'IC - _ 0.00% . . '.'.„ ._._. .... :._ .:: . YJ f..Tr.ri ,y ,S ...,F;z, 01 O^ O^ CP OP OP QP OP OP OP CP QP OP OP OP O°t O°' cP' c�' o°' o°' Go o°' o°' RI Oer re)• ti° ,SO ,tiO .tiO ,�O ,tiO O�`moo°peg lac r<e„Ss''' QRs 4:6 ,Jc 1J\QJ9O yyQ pb ao°poi�a°Leo has• QQs�ra��JC ,, Q9cb c eQ p(`P�°'peC sae Fy..o was QQ< ., ,Jez -e-Port Total -I-1 Yr T-dill -4.-Agency Note Summary by Type June 30,2010 Descriatior! Face Amount k Shares Cost Value nook Value Market Value YTM Rif Cost pays To Maturity Cash $ 96,691,798.39 $ 96,691,798.39 $ 96,691,798.39 $ 96,691,798.39 0.27% 1 CD 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 0.62% 174 FHLB 12,000,000.00 12,025,828.96 12,020,937.03 12,028,060.00 0.43% 216 FHLMC 6,000,000.00 6,068,522.54 6,050,945.16 6,052,430.00 0.31% 146 FNMA 2,000,000.00 2,017,500.00 _ 2.014,018,82 2,015,620.00 0.52% ___ _ _ 302 Total/Average $ 121,691,798.39 $ 121,803,649.89 $ 121,777,699.40 $ 121,787,908.39 0.31% 41 Group Portfolio Holdings Book Value by Maturity by Type 120,000,000 FHLB FHLMC FNMA 5% 2% 10% 100,000,000 , CD 4% 80,000,000 60,000,000 40,000,000 20,000,000 . Cash I 79% - �.. ..�� 1-30 Days 31-60 Days 61-90 Days 91-120 Day421-180 Days>180 Days • • City of Pearland Quarterly Investment Report Report Format: By CUSIP Group By:Security Type Portfolio/Report Group:Report Group: Pearland Begin Date:3/31/2010, End Date:6/30/2010 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 CASH Wells Fargo WFSWEEP 10: General N/A 0.17 15,503,862.19 708,750.35 5,826,706.63 0.00 0.00 10,385,905.91 5,639.41 Sweep Cash Fund Wells Fargo WFSWEEP 17: Municipal N/A 0.19 135,344.11 8,574.49 7,878.05 0.00 0.00 136,040.55 66.38. Sweep Cash Court Security Wells Fargo WFSWEEP 18: City Wide N/A 0.17 64,510.01 269.04 20,248.87 0.00 0.00 44,530.18 25.79 Sweep Cash Donation Wells Fargo WFSWEEP 19: Court N/A 0.18 294,241.44 1,943.56 70,237.37 0.00 0.00 225,947.63 114.32 Sweep Cash Technology Wells Fargo WFSWEEP 20: Debt N/A 0.19 10,391,147.96 1,422,838.77 2,913,905.55 0.00 0.00 8,900,081.18 3,987.26 Sweep Cash Services Wells Fargo WFSWEEP 23: Court N/A 0.30 -3,901.47 9,510.93 2,781.90 0.00 0.00 2,827.56 1.47 Sweep.Cash Juvenile Mgmt Wells Fargo WFSWEEP 25: Emergency N/A 0.00 -92,024.50 78,250.00 0.00 0.00 0.00 -13,774.50 0.00 Sweep Cash Mgmt Buyout Wells Fargo WFSWEEP 30: Water& N/A 0.20 10,721,538.01 1,955,176.88 1,683,547.30 0.00 0.00 10,993,167.59 4,878.98 Sweep Cash Sewer Wells Fargo WFSWEEP 31: Solidwaste N/A 0.93 115;522.50 31,607.97 110,098.02 0.00 0.00 37,032.45 155.63 Sweep Cash Wells Fargo WFSWEEP 35: Street N/A 0.19 545,973.07 260.61- 0.00 0.00 0.00 546,233.68 260.61 Sweep Cash Assessment Wells Fargo WFSWEEP 42: Utility N/A 0.20 8,830,623.08 10,526,926.46 2,865,819.71 0.00 0.00 16,491,729.83 8,223.13 Sweep Cash Impact Fee Wells Fargo WFSWEEP 43: Regional N/A 0.19 4,029.31 1.91 0.00 0.00 0.00 4,031.22 1.91 Sweep Cash Detention Wells Fargo WFSWEEP 44: Shadow N/A 0.19 1,498,968.62 157,637.86 201,726.50 0.00 0.00 1,454,879.98 733.86 Sweep Cash Creek Impact Wells Fargo WFSWEEP 45: Hotel/Motel N/A 0.19 1,270,615.32 61,275.76 38,114.02 0.00 0.00 1,293,777.06 625.90 Sweep Cash Occupancy Wells Fargo WFSWEEP 46: Park N/A 0.21 25,347.61 24,031.47 1,323.86 0.00 0.00 48,055.22 21.85 Sweep Cash Donations Wells Fargo WFSWEEP 47: Park&Rec N/A 0.19 969,649.51. 89,908.78 66,060.08 0.00 0.00 993,498.21 490.24 Sweep Cash Development Wells Fargo WFSWEEP 49:Tree Trust N/A 0.19 17,235.61 8.21 0,00 0.00 0.00 17,243.82 8.21 Sweep Cash Fund Page 1 of 5 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 Wells Fargo 50: Capital WFSWEEP N/A 0.17 7,797,208.49 2,403.78 3,429,596.31 0.00 0.00 4,370,015.96 2,403.78 Sweep Cash Projects Wells Fargo WFSWEEP 55: Sidewalk N/A 0.19 204,408.69 589.74 0.00 0.00 0.00 204,998.43 97.74 Sweep Cash Fund Wells Fargo WFSWEEP Seizure 60: Police State N/A 0.19 239,205.60 109.16 15,379.28 0.00 0.00 223,935.48 109.16 Sweep Cash .. Wells Fargo WFSWEEP 62: Federal N/A 0.20 19,813.78 4,788.37 0.00 0.00 0.00 24,602.15 11.18 Sweep Cash Police Fund Wells Fargo WFSWEEP 64: 1998 Cert N/A 0.19 1,215,641.79 558.87 96,788.37 0.00 0.00 1,119,412.29 558.87 Sweep Cash of Obligation Wells Fargo WFSWEEP 67: 2003 N/A 0.20 3,615,248.60 3,500,821.10 519,905.59 0.00 0.00 6,596,164.11 3,215.49 Sweep Cash Revenue Bonds Wells Fargo WFSWEEP 68: 2001 Cert N/A 0.18 3,623,117.88 1,476.71 871,689.32 0.00 0.00 2,752,905.27 1,476.71 Sweep Cash of Obligation Wells Fargo 70: 2005 Sweep Cash WFSWEEP Refunding/ N/A 0.17 22,723,077.04 7,374.88 9,826,831.94 0.00 0.00 12,903,619.98 7,374.88 Mobility Wells Fargo WFSWEEP 71: 2005 N/A 0.17 31,394.61 12.27 12,188.25 0.00 0.00 19,218.63 12.27 Sweep Cash Refunding/Drain Wells Fargo WFSWEEP 95: Property N/A 0.46 258,270.41 184,946.83 469,680.49 0.00 0.00 -26,463.25 17.92 Sweep Cash Liability Wells Fargo WFSWEEP 97: Employee N/A 0.00 -60,878.65 16,352.74 5,286.69 0.00 0.00 -49,812.60 0.00 Sweep Cash Benefit Trust Wells Fargo WFSWEEP Z1O1:Grant N/A 0.00 -541,594.10 437,366.78 0.00 0.00 0.00 -104,227.32 0.00 Sweep Cash Fund Wells Fargo WFSWEEP Z105: 2007 N/A 0.17 187.30 0.08 0.00 0.00 0.00 187.38 0.08 Sweep Cash CDBG Fund Wells Fargo Z106: 2008 WFSWEEP N/A 0.00 -42,099.33 42,520.63, 5,215.00 0.00 0.00 -4,793.70 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z107: 2009 N/A 0.21 -29,047.49 70,640.96 55,630.63 0.00 0.00 -14,037.16 9.94 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z116: CDBG N/A 0.00 -3,119.29 .23,193.72 8,964.50 . 0.00 0.00 11,109.93 0.00 Sweep Cash Recovery Fund Wells Fargo WFSWEEP 2120: Mgmt N/A 0.18 298,484.84 131.34 50,304.00 0.00 0.00 248,312.18 131.34 Sweep Cash District 1 Wells Fargo WFSWEEP Z140: U of H N/A 0,18 3,436.33 1.54 399.08 0.00 0.00 3,038.79 1.54 Sweep Cash Fund 2150: Wells Fargo Sweep Cash WFSWEEP Hurricane IKE N/A -0.01 -834;346.34 908,276.65 0.00 0.00 0.00 73,930.31 16.34 Proj Page 2 of 5 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 Z20Wells Fargo 2006 Sweep Cash WFSWEEP Cert of N/A 0:18 5,572,449.27 2,140.36 1,113,509.68 0.00 0.00 4,461,079.95 2,140.36 Obligation Z20Wells Fargo 2007 Sweep.Cash WFSWEEP Cert of N/A 0.17 4,165,803.51 1,623.80 1,281,801.39 0.00 0.00 2,885,625.92 1,623.80 Obligation Wells Fargo WFSWEEP Z202: 2007A N/A 0.18 9,424,813.25 622,802,21 3,040,946.90 0.00 0.00 7,006,668.56 3,636.79 Sweep Cash Gen Obligation Wells Fargo WFSWEEP Z203: 2009 N/A 0.11 5,237,291.76 698.89 4,727,604.80 0.00 0.00 510,385.85 698.89 Sweep Cash Gen Obligation Wells Fargo Z205: 2010 Sweep Cash WFSWEEP Cart of N/A 0.22 460,324.20 230,360.61 0.00 0.00 0.00 690,684.81 270.61 Obligation Wells Fargo WFSWEEP Z301: W/S Pay N/A 0.19 1,215,288.15 8,740.72 0.00 0.00 0.00 1,224,028.87 581.91 Sweep Cash As U Go CIP Sub Total/Average 0.18 114,887,062.68 21,144,905.79 39,340,170.08 0.00 0.00 96,691,798.39 49,624.55 Cash CERTIFICATE OF DEPOSIT Pearland State 10: General Bank 1.5 CD700013249 Fund 7/24/2010 1.50 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 3,739.73 7/24/2010 Wells Fargo 10: General Bank 0.4 CD7579071205 Fund 1/28/2011 0.40 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 997.26 1/28/2011 Wells Fargo CD7579073706 10: General 5/15/2010 1.36 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 1,619.33 1.25 5/15/2010 Fund Wells Fargo 20: Debt Bank 0.4 CD7579071205 Services 1/28/2011 0.40 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 997.26 1/28/2011 Wells Fargo CD7579073706 20: Debt 5/15/2010 1.36 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 1,619.33 1.25 5/15/2010 Services Wells Fargo 30: Water& Bank 0.4 CD7579071205 Sewer 1/28/2011 0.40 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 997.26 1/28/2011 Wells Fargo CD7579073706 30: Water& 5/15/2010 1.36 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 1,619.33 1.25 5/15/2010 Sewer Wells Fargo 42: Utility Bank 0.4 CD7579071205 Impact Fee 1/28/2011 0.40 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 997.26 1/28/2011 Wells Fargo CD7579073706 Z202: 2007A 5/15/2010 1.36 2,000,000.00 0.00 2,000,000.00 0.00 0.00 0.00 3,238.66 1.25 5/15/2010 Gen Obligation Page 3 of 5 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.86 10,000,000.00 0.00 5,000,000.00 0.00 0.00 5,000,000.00 15,825.42 Certificate Of Deposit FHLB BOND FHLB 0.7 3133XYNV3 10: General 6/16/2011 0.67 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 369.44 6/16/2011-10 Fund FHLB 0.57 3133XV5G2 20: Debt 12/29/2010 0.55 1,000,074.44 0.00 0.00 0.00 -24.72 1,000,049.72 1,384.44 12/29/2010 Services FHLB 0.57 3133XV5G2 30: Water& 12/29/2010 0.55 1,000,074.44 0.00 0.00 0.00 -24.72 1,000,049.72 1,384.44 12/29/2010 Sewer FHLB 0.42 3133XYJY2 30: Water& 2/17/2011 0.39 0.00 1,000,130.00 0.00 0.00 -19.48 1,000,110.52 447.19 2/17/2011 Sewer FHLB 0.5 3133XUX73 50. Capital 10/15/2010 0.29 0.00 1,001,014.26 0.00 0.00 -419.30 1,000,594.96 608.48 10/15/2010 Projects FHLB 0.57 3133XV5G2 50: Capital 12/29/2010 0.36 1,001,551.24 0.00 0.00 0.00 -515.15 1,001,036.09 894.01 12/29/2010 Projects FHLB 0.57 68: 2001 Cert 12/29/2010 3133XV5G2 of Obligation 12/29/2010 '0.36 1,001,551.24 0.00 0.00 0.00 -515.15 1,001,036.09 894.01 FHLB 1.625 70: 2005 7/27/2011 3133XTXH4 Refunding/ 7/27/2011 0.00 0.00 1,012,450.00 0.00 0.00 0.00 1,012,450.00 0.00 Mobility FHLB 0.5 70: 2005 10/15/2010 3133XUX73 Refunding/ 10/15/2010 0.29 0.00 1,001,014.26 0.00 0.00 -419.30 1,000,594.96 608.48 Mobility FHLB 0.57 70: 2005 12/29/2010 3133XV5G2 Refunding/ 12/29/2010 0.36 2,003,102.48 0.00 0.00 0.00 -1,030.30 2,002,072.18 1,788.04 Mobility 70: 2005 FHLB 0.85 0 3133XVLE9 Refunding/ 5/4/2011 0.48 0.00 1,003,330.00 0.00 0.00 -387.21 1,002,942.79 557.23 5/4/ Mobility Sub Total/Average 0.41 6,006,353.84 6,017,938.52 0.00 0.00 -3,355.33 12,020,937.03 8,935.76 FHLB Bond FHLMC BOND FHLMC 4.75 3134A4V30 10: General 1/18/2011 0.00 0.00 1,024,550.00 0.00 0.00 0.00 1,024,550.00 0.00 1/18/2011. Fund FHLMC 1.45 3128X8QT2 20: Debt 9/10/2010 0.23 1,005,367.23 0.00 0.00 0.00 -3,004.30 1,002,362.93 580.43 9/10/2010 Services FHLMC 1.5 30: Water& 1/7/2011 3137EABW8 Sewer 1/7/2011 0.39 0.00 1,007,951.16 0.00 0.00 -2,254.35 1,005,696.81 828.98 Page 4or5 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 FHLMC 2.875 3137EABV0 42: Utility 11/23/2010 0.27 0.00 1,013,150.00 0.00 0.00 -2,874.32 1,010,275.68 320.12 11/23/2010 Impact.Fee FHLMC 1.45 3128X8QT2 44: Shadow 9/10/2010 0.23 1,005,367.23 0.00 0.00 0.00 -3,004.30 1,002,362.93 580.43 9/10/2010 Creek Impact Z200: 2006 1.5 FHLMC HLMC11 3137EABW8 Certof 1/7/2011 0.39 0.00 1,007,951.16 0.00 0.00 -2,254.35 1,005,696.81 828.98 Obligation .. Sub Total/Average 0.30 2,010,734.46 4,053,602.32 0.00 0.00 -13,391.62 6,050,945.16 3,138.94 FHLMC Bond FNMA BOND FNMA 1,375 31398AWQ1 10: General 4/28/2011 0.52 0.00 1,008,750.00 0.00 0.00 -1,740.59 1,007,009.41 1,085.80 4/28/2011 Fund FNMA 1.375 31398AWQ1 20: Debt 4/28/2011 0.52 0.00 1,008,750.00 0.00 0.00 -1,740.59 1,007,009.41 1,085.81 4/28/2011 Services Sub Total/Average 0.52 0.00 2,017,500.00 0.00 0.00 -3,481.18 2,014,018.82 2,171.61 FNMA Bond Total / 0.25 132,904,150.98 33'233'946.63 44'340`170.08 0.00 - 121,777,699.40 79 696.28 Average 20,228.13 ' Page 5 oP 5 City of Pearland City of Pearland-By Security Type Report Format: By CUSIP Group By: Security Type Portfolio/Report Group:Report Group:Pearland As of 6/30/2010 Portfolio Face YTM @ Settlement Maturity Days To Accrued %of Description CUSIP/Ticker Name Amount/Shares Cost Value Book Value Market Value Cost Date Date Maturity Interest Portfolio Cash Wells Fargo WFSWEEP 10:General 10,385,905.91 10,385,905.91 10,385,905.91 10,385,905.91 0.27000 N/A N/A 1 N/A 8.53 Sweep Cash Fund Wells Fargo WFSWEEP 17: Municipal 136,040.55 136,040.55 136,040.55 136,040.55 0.27000 N/A N/A 1 N/A 0.11 Sweep Cash Court Security Wells Fargo WFSWEEP 18:City Wide 44,530.18 44,530.18 44,530.18 44,530.18 0.27000 N/A N/A 1 N/A 0.04 Sweep Cash Donation Wells Fargo WFSWEEP 19:Court 225,947.63 225,947.63 225,947.63 225,947.63 0.27000 N/A N/A 1 N/A 0.19 Sweep Cash .. Technology Wells Fargo WFSWEEP 20: Debt 8,900,081.18 8,900,081.18 8,900,081.18 8,900,081.18 0.27000 N/A N/A 1 N/A 7.31 Sweep Cash Services Wells Fargo WFSWEEP 23:Court 2,827.56 2,827.56 2,827.56 2,827.56 0.27000 N/A N/A 1 N/A 0.00 Sweep Cash Juvenile Mgmt Wells Fargo WFSWEEP 25: Emergency -13,774.50 -13,774.50 -13,774.50 -13,774.50 0.27000 N/A N/A 1 N/A -0.01 Sweep Cash Mgmt Buyout Wells Fargo WFSWEEP 30:Water& 10,993,167.59 10,993,167.59 10,993,167.59 10,993,167.59 0.27000 N/A N/A 1 N/A 9.03 Sweep Cash Sewer Wells Fargo WFSWEEP 31:Solidwaste 37,032.45 37,032.45 37,032.45 37,032.45 0.27000 N/A N/A 1 N/A 0.03 Sweep Cash Wells Fargo WFSWEEP 35:Street 546,233.68 546,233.68 546,233.68 546,233.68 0.27000 N/A N/A 1 N/A 0.45 Sweep Cash Assessment Wells Fargo WFSWEEP 42: Utility 16,491,729.83 16,491,729.83 16,491,729.83 16,491,729.83 0.27000 N/A N/A 1 N/A 13.55 Sweep Cash Impact Fee Wells Fargo WFSWEEP 43: Regional 4,031.22 4,031.22 4,031.22 4,031.22 0.27000 N/A N/A 1 N/A 0.00 Sweep Cash Detention Wells Fargo WFSWEEP 44:Shadow 1,454,879.98 1,454,879.98 1,454,879.98 1,454,879.98 0.27000 N/A N/A 1 N/A 1.20 Sweep Cash Creek Impact Wells Fargo WFSWEEP 45:.,Hotel/Motel 1,293,777.06 1,293,777.06 1,293,777.06 1,293,777.06 0.27000 N/A N/A 1 N/A 1.06 Sweep Cash Occupancy Wells Fargo WFSWEEP 46: Park 48,055,22 48,055.22 48,055.22 48,055.22 0.27000 N/A N/A 1 N/A 0.04 Sweep Cash Donations Wells Fargo WFSWEEP 47: Park.&Rec 993,498.21 . 993,498.21 . 993,498.21 993,498.21 0.27000 N/A N/A 1 N/A 0.82 Sweep Cash Development Wells Fargo WFSWEEP 49:Tree Trust 17,243.82 17,243.82 17,243.82 17,243.82 0.27000 N/A N/A 1 N/A 0.01 Sweep Cash Fund Wells Fargo WFSWEEP 50: Capital 4,370,015.96 4,370,015.96 4,370,015.96 4,370,015.96 0.27000 N/A N/A 1 N/A 3.59 Sweep Cash Projects Page 1 of 4 Portfolio Face YTM @ Settlement Maturity Days To Accrued 0/0 of Description CUSIP/Ticker Name Amount/Shares Cost Value Book Value Market Value Cost Date Date Maturity Interest Portfolio . Wells Fargo WFSWEEP 55:Sidewalk 204,998.43 204,998.43 204,998.43 204,998.43 0.27000 N/A N/A 1 N/A 0.17 Sweep Cash Fund Wells Fargo WFSWEEP 60: Police State 223,935.48 223,935.48 223,935.48 223,935.48 0.27000 N/A N/A 1 N/A 0.18 Sweep Cash Seizure Wells Fargo WFSWEEP 62: Federal 24,602.15 24,602.15 24,602.15 24,602.15 0.27000 N/A N/A 1 N/A 0.02 Sweep Cash Police Fund Wells Fargo WFSWEEP 64: 1998 Cert 1,119,412.29 1,119,412.29 1,119,412.29 1,119,412.29 0.27000 N/A N/A 1 N/A 0.92 Sweep Cash of Obligation Wells Fargo WFSWEEP 67: 2003 6,596,164.11 6,596,164.11 6,596,164.11 6,596,164.11 0.27000. N/A N/A. 1 N/A 5.42 Sweep Cash Revenue Bonds . . Wells Fargo WFSWEEP 68: 2001 Cert 2,752,905.27 2,752,905.27 2,752,905.27 2,752,905.27 0.27000 N/A N/A 1 N/A 2.26 Sweep Cash of Obligation 70: 2005 Wells Fargo WFSWEEP Refunding/ 12,903,619.98 12,903,619.98 12,903,619.98 12,903,619.98 0.27000 N/A N/A 1 N/A 10.60 Sweep Cash Mobility Wells Fargo WFSWEEP 71:2005 19,218.63 19,218.63 19,218.63 19,218.63 0.27000 N/A N/A 1 N/A 0.02 Sweep Cash Refunding/Drain Wells Fargo WFSWEEP 95:Property -26,463.25 -26,463.25 -26,463.25 -26,463.25 0.27000 N/A N/A 1 N/A -0.02 Sweep Cash Liability Wells Fargo WFSWEEP 97: Employee -49,812.60 -49,812.60 -49,812.60 -49,812.60 0.27000 N/A N/A 1 N/A -0.04 Sweep Cash Benefit Trust Wells Fargo WFSWEEP Z101:Grant -104,227.32 -104,227.32 -104,227.32 -104,227.32 0.27000 N/A N/A 1 N/A -0.09 Sweep Cash Fund Wells Fargo WFSWEEP Z105:2007 187.38 ' 187.38 187.38 187.38 0.27000 N/A N/A 1 N/A 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP 2106:2008 -4,793.70 -4,793.70 -4,793.70 -4,793.70 0.27000 N/A N/A 1 N/A 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP 2107: 2009 , -14,037.16 -14,037.16 -14,037.16 -14,037.16 0.27000 N/A N/A 1 N/A -0.01 Sweep Cash CDBG Fund Wells Fargo WFSWEEP 2116:CDBG 11,109.93 11,109.93 11,109.93 11,109.93 0.27000 N/A N/A 1 N/A 0.01 Sweep Cash .Recovery Fund Wells Fargo WFSWEEP Z120: Mgmt 248,312.18 248,312.18 248,312.18 248,312.18 0.27000 N/A N/A 1 N/A 0.20 Sweep Cash District 1 Wells Fargo WFSWEEP Z140: U of H 3,038.79 3,038.79 3,038.79 3,038.79 0.27000 N/A N/A 1 N/A . 0.00 Sweep Cash Fund Z150: Wells Fargo 73,930.31 0.27000 N/A N/A 1 N/A O.D6 Sweep Cash WFSWEEP Hurricane IKE 73,930.31 73,930.31 73,930.31 Pro) Wells Fargo ZZ00:2006 Sweep Cash WFSWEEP Cert of 4,461,079.95 4,461,079.95 4,461,079.95 4,461,079.95 0.27000 N/A N/A 1 N/A 3.67 Obligation Wells Fargo 2201: 2007 Sweep Cash WFSWEEP Cert of 2,885,625.92 2,885,625.92 2,885,625.92 2,885,625,92 0.27000 N/A N/A 1 N/A 2.37 Obligation Page? of 4 Portfolio Face YTM© Settlement Maturity Days To Accrued %of Description CUSIP/Ticker Name Amount/Shares Cost Value Book Value Market Value Cost Date Date Maturity Interest Portfolio Wells Fargo WFSWEEP Z202: 2007A 7,006,668.56 7,006,668.56 7,006,668.56 7,006,668.56 0.27000 N/A N/A 1 N/A 5.76 Sweep Cash Gen Obligation Wells Fargo WFSWEEP Z203: 2009 510,385.85 510,385.85 510,385.85 510,385,85 0.27000 N/A N/A 1 N/A 0.42 Sweep Cash Gen Obligation Wells Fargo Z205: 2010 Sweep Cash WFSWEEP Cert of 690,684.8.1. 690,684.81 690,684.81 690,684.81 0.27000 N/A N/A 1 N/A 0.57 Obligation Wells Fargo WFSWEEP 2301:W/S Pay 1,224,028.87 1,224,028.87 1,224,028.87 1,224,028.87 0.27000 N/A N/A 1 N/A 1.01 Sweep Cash As U Go CIP Sub Total/ 96,691,798.39 96,691,798.39 96,691,798.39 96,691,798.39 0.27000 1 0.00 79.46 Average . Certificate Of Deposit Pearland State Bank CD700013249 10:General 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1.50000 N/A 7/24/2010 24 14,013.70 0.82 1.5 Fund 7/24/2010 Wells Fargo 10:General Bank 0.4 CD7579071205 Fund 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 0.40000 N/A 1/28/2011 212 1,676.71 0.82 1/28/2011 Wells Fargo 20: Debt Bank 0.4 CD7579071205 Services 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 0.40000 N/A 1/28/2011 212 1,676.71 0.82 1/28/2011 Wells Fargo 30:Water& Bank 0.4 CD7579071205 Sewer 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 0.40000 N/A 1/28/2011 212 1,676.71 0.82 1/28/2011 Wells Fargo 42: Utility Bank 0.4 CD7579071205 Impact Fee 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 0.40000 N/A 1/28/2011 212 1,676.71 0.82 1/28/2011 Sub Total/ 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 0.62000 174 20,720.54 4.11 Average FHLB Bond FHLB 0.7 10:General 6/16/2011- 3133XYNV3 Fund 1,000,000.00 1,000,000.00 1,000,000.00 1,000,310.00 0.70000 N/A 6/16/2011 351 369.44 0.82 10 FHLB 0.57 3133XV5G2 20:Debt 1,000,000.00 1,000,125.00 1,000,049.72 1,001,560.00 0.56007 N/A 12/29/2010 182 15.83 0.82 12/29/2010 Services FHLB 0.57 3133XV5G2 30:Water& 1,000,000.00 1,000,125.00 1,000,049.72 1,001,560.00 0.56007 N/A 12/29/2010 182 15.83 0.82 12/29/2010 Sewer FHLB 0.42 3133XY]Y2 30: Water&. 1,000,000.00 1,000,130.00 1,000,110.52 1,000,310.00 0.40241. N/A 2/17/2011 232 501,67 0.82 2/17/2011 Sewer FHLB 0.5 3133XUX73 50:Capital 1,000,000.00 1,001,014.26 1,000,594.96 1,000,940.00 0.29486 N/A 10/15/2010 107 3,930.56 0.82 10/15/2010 Projects FHLB 0.57 3133XV5G2 50:Capital 1,000,000.00 1,001,910.11 1,001,036.09 1,001,560.00 0.36108 N/A 12/29/2010 182 15.83.. 0.82 12/29/2010 Projects Page3of4 Portfolio Face YTM© Settlement Maturity Days To Accrued %of Description CUSIP/Ticker Name Amount/Shares Cost Value Book Value Market Value Cost Date Date Maturity Interest Portfolio FHLB 0.57 3133XV5G2 68: 2001 CerC. 1,000,000.00 1,001,910.11 1,001,036.09 1,001,560.00 0.36108 N/A 12/29/2010 182 15.83 0.82 12/29/2010 of Obligation FHLB 0.85 70: 2005 3133XVLE9 Refunding/ 1,000,000.00 1,003,330.00 1,002,942.79 1,003,750.00 0.50023 N/A 5/4/2011 308 1,322.22 0.82 5/4/2011 Mobility FHLB 0.5 70:2005 10/15/20103133XUX73 Refunding/ 1,000,000.00 1,001,014.26 1,000,594.96 1,000,940.00 0.29486 N/A 10/15/2010 107 3,930.56 0.82 Mobility FHLB 0.57 70: 2005 12/29/2010 3133XV5G2 Refunding/ 2,000,000.00 2,003,820.22 2,002,072.18 2,003,120.00 0.36108 N/A 12/29/2010 182 31.67 1.64 Mobility FHLB 1.625 70: 2005 7/27/2011 3133XTXH4 Refunding/ 1,000,000.00 1,012,450.00 1,012,450.00 1,012,450.00 0.46257 N/A 7/27/2011 392 6,906.25 0.82 Mobility Sub Total/ 12,000,000.00 12,025,828.96 12,020,937.03 12,028,060.00 0.43495 216 17,055.69 9.86 Average FHLMC Bond FHLMC 4.75 3134A4V10 10:General 1,000,000.00 1,024,550.00 1,024,550.00 1,024,550.00 0.27956 N/A 1/18/2011 202 21,375.00 0.82 1/18/2011 Fund FHLMC 1.45 3128X8QT2 20: Debt 1,000,000.00 1,007,460.11 1,002,362.93 1,002,340.00 0.23304 N/A 9/10/2010 72 4,430.56 0.82 9/10/2010 Services FHLMC 1.5 3137EABW8 30:Water& 1,000,000.00 1,007,951.16 1,005,696.81 1,006,150.00 0.40039 N/A 1/7/2011 191 7,208.33 0.82 1/7/2011 Sewer FHLMC 42:Utility 2.875 3137EABV0 1,000,000.00 1,013,150.00 1,010,275.68 1,010,900.00 0.28441 N/A 11/23/2010 146 2,954.86 0.82 Impact Fee 11/23/2010 FHLMC 1.45 3128X8QT2 44: Shadow 1,000,000.00 1,007,460.11 1,002,362.93 1,002,340.00 0.23304 N/A 9/10/2010 72 4,430.56 0.82 9/10/2010 Creek Impact Z200: 2006 FHLMC 1.5 3137EABW8 Cert of 1,000,000.00 1,007,951.16 1,005,696.81 1,006,150.00 0.40039 N/A 1/7/2011 191 7,208.33 0.82 1/7/2011 Obligation Sub Total/ 6,000,000.00 6,068,522.54 6,050,945.16 6,052,430.00 0.30514 146 47,607.64 4.93 Average FNMA Bond FNMA 1.375 31398AWQ1 10: General 1,000,000.00 1,008,750.00 1,007,009.41 1,007,810.00 0.52481 N/A 4/28/2011 302 2,368.06 0.82 4/28/2011 Fund FNMA 1.375 31398AWQ1 20: Debt 1,000,000.00 1,008,750.00 1,007,009.41 1,007,810.00 0.52481 N/A 4/28/2011 302 2,368.06 0.82 4/28/2011 Services Sub Total/ 2,000,000.00 2,017,500.00 2,014,018.82 2,015,620.00 0.52481 302 4,736.12 1.64 Average Total/ 121,691,798.39 121,803,649.89 121,777,699.40 121,787,908.39 0.30657 41 90,119.99 100 Average Page 4 of 4 City of Pearland City of Pearland-by Fund . Report Format: By Transaction Group By: Portfolio Name Portfolio/Report Group: Report Group: Pearland As of 6/30/2010 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 WFSWEEP Cash 5/31/2006 10,385,905.91 10,385,905.91 10,385,905.91 0.27000 N/A 1 8.53 Cash Wells Fargo Bank 0.4 CD7579071205 Certificate Of 1/28/2010 1,000,000.00 1,000,000.00 1,000,000.00 0.40000 1/28/2011 212 0.82 1/28/2011 Deposit Pearland State Bank Certificate Of 1.5 7/24/2010 CD700013249 Deposit 7/24/2009 1,000,000.00 1,000,000.00 1,000,000.00 1.50000 7/24/2010 24 0.82 FNMA 1.375 31398AWQ1 FNMA Bond 4/16/2010 1,000,000.00 1,007,009.41 1,007,810.00 0.52481 4/28/2011 302 0.82 4/28/2011 FHLMC 4.75 3134A4VJ0 FHLMC Bond 6/30/2010 1,000,000.00 1,024,550.00 1,024,550.00 0.27956 1/18/2011 202 0.82 1/18/2011 FHLB 0.7 6/16/2011 3133XYNV3 FHLB Bond 6/11/2010 1,000,000.00 1,000,000.00 1,000,310.00 0.70000 6/16/2011 351 0.82 10 Sub Total/ 15,385,905.91 15,417,465.32 15,418,575.91 0.40352 72 12.64 Average 17: Municipal Court Security Wells Fargo Sweep WFSWEEP Cash 5/31/2006 136,040.55 136,040.55 136,040.55 0.27000 N/A 1 0.11 Cash Sub Total / 136,040.55 136,040.55 136,040.55 0.27000 1 0.11 Average 18: City Wide Donation Wells Fargo Sweep WFSWEEP Cash 5/31/2006 44,530.18 44,530.18 44,530.18 0.27000 N/A 1 0.04 Cash Sub Total / 44,530.18 44,530.18 44,530.18 0.27000 1 0.04 Average 19:Court Technology Wells Fargo Sweep WFSWEEP Cash 5/31/2006 225,947.63 225,947.63 225,947.63 0.27000 N/A 1 0.19 Cash Sub Total / 225,947.63 225,947.63 225,947.63 0.27000 1 0.19 Average 20: Debt Services Page 1 01 8 Security Settlement Face YTM @ Maturity Days To %of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Wells Fargo Sweep WFSWEEP Cash 5/31/2006 8,900,081.18 8,900,081.18 8,900,081.18 0.27000 N/A 1 7.31 Cash Wells Fargo Bank 0.4 CD7579071205 Certificate Of 1/28/2010 1,000,000.00 1,000,000.00 1,000,000.00 0.40000 1/28/2011 212 0.82 1/28/2011 Deposit FNMA 1.375 31398AWQ1 FNMA Bond 4/16/2010 1,000,000.00 1,007,009.41 1,007,810.00 0.52481 4/28/2011 302 0.82 4/28/2011 FHLMC 1.45 3128X8QT2 FHLMC Bond 1/29/2010 1,000,000.00 1,002,362.93 1,002,340.00 0.23304 9/10/2010 72 0.82 9/10/2010 FHLE3 0.57 3133XV5G2 FHLB Bond 9/29/2009 1,000,000.00 1,000,049.72•. 1,001,560.00 0.56007 12/29/2010 182 0.82 12/29/2010 Sub Total / 12,900,081.18 12,909,503.24 12,911,791.18 0.31945 60 10.60 Average 23:Court Juvenile Mgmt Wells Fargo Sweep WFSWEEP Cash 9/15/2009 2,827.56 2,827.56 2,827.56 0.27000 N/A 1 0.00 Cash Sub Total / 2,827.56 2,827.56 2,827.56 0.27000 1 0.00 Average 25: Emergency Mgmt Buyout Wells Fargo Sweep WFSWEEP Cash 10/31/2008 -13,774.50 -13,774.50 -13,774.50 0.27000 N/A 1 -0.01 Cash Sub Total/ -13,774.50 -13,774.50 -13,774.50 0.27000 1 -0.01 Average 30:Water&Sewer Wells Fargo Sweep WFSWEEP Cash 5/31/2006 10,993,167.59 10,993,167.59 10,993,167.59 0.27000 N/A 1 9.03 Cash Wells Fargo Bank 0.4 CD7579071205 Certificate Of 1/28/2010 1,000,000.00 1,000,000.00 1,000,000.00 0.40000 1/28/2011 212 0.82 1/28/2011 Deposit FHLMC 1.5 1/7/2011 3137EABWB FHLMC Bond 4/16/2010 1,000,000.00 1,005,696.81 1,006,150.00 0.40039 1/7/2011 191 0.82 FHLB 0.57 3133XV5G2 FHLB Bond 9/29/2009 1,000,000.00 1,000,049.72 1,001,560.00 0.56007 12/29/2010 182 0.82 12/29/2010 FHLB 0.42 2/17/2011 3133XY3Y2 FHLB Bond 5/20/2010 1,000,000.00 1,000,110.52 1,000,310.00 0.40241 2/17/2011 232 0.82 Sub Total / 14,993,167.59 14,999,024.64 15,001,187.59 0.31555 55 12.32 Average 31: Solidwaste Wells Fargo Sweep WFSWEEP Cash 12/1/2006 37,032.45 37,032.45 37,032.45 0.27000 N/A 1 0.03 Cash Page 2 of 8 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/ 37,032.45 37,032.45 37,032.45 0.27000 1 0.03 Average 35:Street Assessment Wells Fargo Sweep WFSWEEP Cash 5/31/2006 546,233.68 546,233.68 546,233.68 0.27000 N/A 1 0.45 Cash Sub Total / 546,233.68 546,233.68 546,233.68 0.27000 1 0.45 Average 42: Utility Impact Fee Wells Fargo Sweep WFSWEEP Cash 5/31/2006 16,491,729.83 16,491,729.83 16,491,729.83 0.27000 N/A 1 13.55 Cash Wells Fargo Bank 0.4 CD7579071205 Certificate Of 1/28/2010 1,000,000.00 1,000,000.00 1,000,000.00 0.40000 1/28/2011 212 0.82 1/28/2011 Deposit FHLMC 2.875 3137EABVO FHLMC Bond 5/20/2010 1,000,000.00 1,010,275.68 1,010,900.00 0.28441 11/23/2010 146 0.82 11/23/2010 Sub Total / 18,491,729.83 18,502,005.51 18,502,629.83 0.27781 20 15.20 Average 43: Regional Detention Wells Fargo Sweep WFSWEEP Cash 5/31/2006 4,031.22 4,031.22 4,031.22 0.27000 N/A 1 0.00 Cash Sub Total / 4,031.22 4,031.22 4,031.22 0.27000 1 0.00 Average 44:Shadow Creek Impact Wells Fargo Sweep WFSWEEP Cash 5/31/2006 1,454,879.98 1,454,879.98 1,454,879.98 0.27000 N/A 1 1.20 Cash FHLMC 1.45 3128X8QT2 FHLMC Bond 1/29/2010 1,000,000.00 1,002,362.93 1,002,340.00 0.23304 9/10/2010 72 0.82 9/10/2010 Sub Total/ 2,454,879.98 2,457,242.91 2,457,219.98 0.25494 30 2.02 Average 45: Hotel/Motel Occupancy Wells Fargo Sweep WFSWEEP Cash 5/31/2006 1,293,777.06 1,293,777.06 1,293,777.06 0.27000 N/A 1 1.06 Cash Sub Total/ 1,293,777.06 1,293,777.06 1,293,777.06 0.27000 1 1.06 Average 46: Park Donations Page 3 of 8 Security Settlement Face YTM @ Maturity Days To %of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio . Wells Fargo Sweep WFSWEEP Cash 5/31/2006 48,055.22 48,055.22 48,055.22 0.27000 N/A 1 0.04 Cash Sub Total / 48,055.22 48,055.22 48,055.22 0.27000 1 0.04 Average 47: Park&Rec Development Wells Fargo Sweep WFSWEEP Cash 5/31/2006 993,498.21 993,498.21 993,498.21 0.27000 N/A 1 0.82 Cash Sub Total / 993,498.21 993,498.21 993,498.21 0.27000 1 0.82 Average 49:Tree Trust Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 17,243.82 17,243.82 17,243.82 0.27000 N/A 1 0.01 Cash Sub Total / 17,243.82 17,243.82 17,243.82 0.27000 1 0.01 Average 50:Capital Projects Wells Fargo Sweep WFSWEEP Cash 5/31/2006 4,370,015.96 4,370,015.96 4,370,015.96 0.27000 N/A 1 3.59 Cash FHLB 0.57 3133XV5G2 FHLB Bond 1/29/2010 1,000,000.00 1,001,036.09 1,001,560.00 0.36108 12/29/2010 182 0.82 12/29/2010 FHLB 0.5 10/15/2010 3133XUX73 FHLB Bond 4/16/2010 1,000,000.00 1,000,594.96 1,000,940.00 0.29486 10/15/2010 107 0.82 Sub Total/ 6,370,015.96 6,371,647.01 6,372,515.96 0.28820 46 5.23 Average 55:Sidewalk Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 204,998.43 204,998.43 204,998.43 0.27000 N/A 1 0.17 Cash Sub Total / 204,998.43 204,998.43 204,998.43 0.27000 1 0.17 Average 60: Police State Seizure Wells Fargo Sweep WFSWEEP Cash 5/31/2006 223,935.48 223,935.48 223,935.48 0.27000 N/A 1 0.18 Cash Sub Total / 223,935.48 223,935.48 223,935.48 0.27000 1 0.18 Average 62: Federal Police Fund Page 4 of 8 Security Settlement Face YTM @ Maturity Days To %of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Wells Fargo Sweep WFSWEEP Cash 5/31/2006 24,602.15 24,602.15 24,602.15 0.27000 N/A 1 0.02 Cash Sub Total / 24,602.15 24,602.15 24,602.15 0.27000 1 0.02 Average 64: 1998 Cert of Obligation Wells Fargo Sweep WFSWEEP Cash 5/31/2006 1,119,412.29 1,119,412.29 1,119,412.29 0.27000 N/A 1 0.92 Cash Sub Total / 1,119,412.29 1,119,412.29 1,119,412.29 0.27000 1 0.92 Average 67: 2003 Revenue Bonds Wells Fargo Sweep WFSWEEP Cash 5/31/2006 6,596,164.11 6,596,164.11 6,596,164.11 0.27000 N/A 1 5.42 Cash Sub Total / 6,596,164.11 6,596,164.11 6,596,164.11 0.27000 1 5.42 Average 68: 2001 Cert of Obligation Wells Fargo Sweep WFSWEEP Cash 5/31/2006 2,752,905.27 2,752,905.27 2,752,905.27 0.27000 N/A 1 2.26 Cash FHLB 0.57 3133XV5G2 FHLB Bond 1/29/2010 1,000,000.00 1,001,036.09 1,001,560.00 0.36108 12/29/2010 182 0.82 12/2 12/29/2010 Sub Total / 3,752,905.27 3,753,941.36 3,754,465.27 0.29427 49 3.08 Average 70: 2005 Refunding/ Mobility Wells Fargo Sweep WFSWEEP Cash 5/31/2006 12,903,619.98 12,903,619.98 12,903,619.98 0.27000 N/A 1 10.60 Cash FHLB 1.625 3133XTXH4 FHLB Bond 6/30/2010 1,000,000.00 1,012,450.00 1,012,450.00 0.46257 7/27/2011 392 0.82 7/27/2011 FHLB 0.85 5/4/2011 3133XVLE9 FHLB Bond 5/20/2010 1,000,000.00 1,002,942.79 1,003,750.00 0.50023 5/4/2011 308 0.82 FHLB 0.57 3133XV5G2 FHLB Bond 1/29/2010 2,000,000.00 2,002,072.1E 2,003,120.00 0.36108 12/29/2010 182 1.64 12/29/2010 FHLB 0.5 10/15/2010 3133XUX73 FHLB Bond 4/16/2010 1,000,000.00 1,000,594.96 1,000,940.00 0.29486 10/15/2010 107 0.82 Sub Total / 17,903,619.98 17,921,679.91 17,923,879.98 0.30518 66 14.71 Average 71: 2005 Refunding/Drain Wells Fargo Sweep WFSWEEP Cash 5/31/2006 19,218.63 19,218.63 19,218.63 0.27000 N/A 1 0.02 Cash Page 5 of 8 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 / 19,218.63 19,218.63 19,218.63 0.27000 1 0.02 Average 95: Property Liability Wells Fargo Sweep WFSWEEP Cash 10/31/2006 -26,463.25 -26,463.25 -26,463.25 0.27000 N/A 1 -0.02 Cash Sub Total / -26,463.25 -26,463,25 -26,463.25 0.27000 1 -0.02 Average - 97: Employee Benefit.Trust Wells Fargo Sweep WFSWEEP Cash 9/1/2007 -49,812.60 -49,812.60 -49,812.60 0.27000 N/A 1 -0.04 Cash Sub Total / -49,812.60 -49,812.60 -49,812.60 0.27000 1 -0.04 Average Z101:Grant Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 -104,227.32 -104,227.32 -104,227.32 0.27000 N/A 1 -0.09 Cash Sub Total / -104,227.32 -104,227.32 -104,227.32 0.27000 1 -0.09 Average Z105: 2007 CDBG Fund Wells Fargo Sweep WFSWEEP Cash 5/1/2007 187.38 187.38 187.38 0.27000 N/A 1 0.00 Cash Sub Total / 187.38 187.38 187.38 0.27000 1 0.00 Average Z106: 2008 CDBG Fund Wells Fargo Sweep WFSWEEP Cash 3/15/2009 -4,793.70 -4,793.70 -4,793.70 0.27000 N/A 1 0.00 Cash Sub Total / -4,793.70 -4,793.70 -4,793.70 0.27000 1 0.00 Average Z107:2009 CDBG Fund Wells Fargo Sweep WFSWEEP Cash 11/1/2009 -14,037.16 -14,037.16 -14,037.16 0.27000 N/A 1 -0.01 Cash Sub Total/ 14,037.16 -14,037.16 -14,037.16 0.27000 1 -0.01 Average Z116:CDBG Recovery Fund Page 6 of 8 SecuritySettlement Face ' YTM @ Maturity Days To %of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Wells Fargo Sweep WFSWEEP, Cash 7/31/2009 11,109.93 11,109.93 11,109.93 0.27000 N/A 1 0.01 Cash Sub Total / 11,109.93 11,109.93 11,109.93 0.27000 1 0.01 Average Z120: Mgmt District 1 Wells Fargo Sweep WFSWEEP Cash 12/31/2007 248,312.18 248,312.18 248,312.18 0.27000 N/A 1 0.20 Cash Sub Total / 248,312.18 248,312.18 248,312.18 0.27000 1 0.20 Average Z140:U of H Fund Wells Fargo Sweep WFSWEEP Cash 12/1/2009 3,038.79 3,038.79 3,038.79 0.27000 N/A 1 0.00 Cash Sub Total / 3,038.79 3,038.79 3,038.79 0.27000 1 0.00 Average Z150:Hurricane IKE Proj Wells Fargo Sweep WFSWEEP Cash 10/31/2008 73,930.31 73,930.31 73,930.31 0.27000 N/A 1 0.06 Cash Sub Total / 73,930.31 73,930.31 73,930.31 0.27000 1 0.06 Average Z200: 2006 Cert of Obligation Wells Fargo Sweep WFSWEEP Cash 6/30/2006 4,461,079.95 4,461,079.95 4,461,079.95 0.27000 N/A 1 3.67 Cash FHLMC 1.5 1/7/2011 3137EABW8 FHLMC Bond 4/16/2010 1,000,000.00 1,005,696.81 1,006,150.00 0.40039 1/7/2011 191 0.82 Sub Total / 5,461,079.95. 5,466,776.76 5 467 229.95 0.29388 Average + + 36 4.49 Z201:2007 Cert of Obligation Wells Fargo Sweep WFSWEEP Cash 8/31/2006 2,885,625.92 2,885,625.92 2,885,625.92 0.27000 N/A 1 2.37 Cash Sub Total / 2'885 625.92 2,885,625.92 2,885,625.92 0.27000 Average T 2.37 Z202:2007A Gen Obligation Wells Fargo Sweep WFSWEEP Cash 12/31/2007 7,006,668.56 7,006,668.56 7,006,668.56 0.27000 N/A 1 5.76 Cash Pane 7 of 8 I. Security Settlement Face YTM @ Maturity Days To %of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio c Sub Total / 7,006,668.56 7,006,668.56 7,006,668.56 0.27000 1 5.76 Average Z203: 2009 Gen Obligation Wells Fargo Sweep WFSWEEP Cash 10/30/2008 510,385.85 510,385.85 510,385.85 0.27000 N/A 1 0.42 Cash Sub Total/ 510,385.85 510,385.85 510,385.85 0.27000 1 0.42 Average Z205:2010 Cert of Obligation Wells Fargo Sweep WFSWEEP Cash 12/15/2009 690,684.81 690,684.81 690,684.81 0.27000 N/A 1 0.57 Cash Sub Total/ 690,684.81 690,684.81 690,684.81 0.27000 1 0.57 Average Z301:W/S Pay As U Go CIP Wells Fargo Sweep WFSWEEP Cash 12/31/2007 1,224,028.87 1,224,028.87 1,224,028.87 0.27000 N/A 1 1.01 Cash Sub Total / 1,224,028.87 1,224,028.87 1,224,028.87 0.27000 1 1.01 Average Total / Average 121,691,798.39 121,777,699.40 121,787,908.39 0.30657 41 100 Page 8 of S Pledged Collateral Reconciliation Report June 30, 2010 Bank Account Number Account Name Amount Wells Fargo 201-0419505 Operating $ - Wells Fargo 201-0419513 Payroll Fund - Wells Fargo 001-3042841 Sweep Account 104,085,233.36 Wells Fargo 201-0419554 98 CO Escrow - Wells Fargo 807-1613395 Credit Card Account 2,104,675.45 Wells Fargo 818-4567843 Alvin ISD 8,596,270.79 Wells Fargo 001-3043112 PEDC Sales Tax - Wells Fargo Wells Fa 1.50 07/24/10 Certificate of Deposit 1,000,000.00 Wells Fargo Wells Fa 1.53 01/27/10 Certificate of Deposit 4,000,000.00 Total of Bank Balances $ 119,786,179.60 Pledged Collateral for City 129,995,189.69 FDIC Insurance 250,000.00 Total Collateral $ 130,245,189.69 Over(Under)Collateralized $ 10,459,010.09 Total% Collateralized 108.7% Bank Account Number Account Name Amount Wells Fargo 100-7284258 Development Authority 2,667,955.15 Total of Bank Balances $ 2,667,955.15 Pledged Collateral for DAP 2,936,166.84 FDIC Insurance 250,000.00 Total Collateral $ 3,186,166.84 Over(Under) Collateralized $ 518,211.69 Total% Collateralized 119.4% Bank Account Number Account Name Amount Pearland State 13249 Certificate of Deposit 1,000,000.00 Pearland State 12847 Certificate of Deposit $ - Total of Bank Balances $ 1,000,000.00 Pledged Collateral 2,825,195.81 FDIC Insurance 250,000.00 Total Collateral $ 3,075,195.81 Over(Under) Collateralized $ 2,075,195.81 Total % Collateralized 307.5% Total $ Over(Under) Collateralized $ 13,052,417.59 Total % Collateralized 110.6% Status Collateralized I:\Investments\Investment Reports\City of Pearland\Investment Report-City-Qtr 0610