Loading...
R2010-164 - 2010-12-13RESOLUTION NO. R2010 -164 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS, ACCEPTING THE CITY'S INVESTMENT REPORT FOR THE QUARTER ENDING SEPTEMBER 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 September 2010. PASSED, APPROVED, AND ADOPTED this 13 day of December, A.D., 2010. f/1•y1 r�l TOM REID MAYOR ATTEST: ON G APPROVED AS TO FORM: 65 DARRIN M. COKER CITY ATTORNEY 14,, City of Pearland 71 Quarterly Investment Report , EAR....AND June 30, 2010 - September 30, 2010 ,yo' Portfolio at June 30.2010 Portfolio at September 30.2010 Ending Book Value $ 121,777,699.40 Ending Book Value $ 97,823,676.12 Ending Market Value 121,787,908.39 Ending Market Value 97,837,286.81 Accrued Interest Receivable 90,119.99 Accrued Interest Receivable 96,685.69 FYD Total Interest Earned 252,352.31 FYD Total Interest Earned 337,656.63 Unrealized Gain/(Loss) 10,208.99 Unrealized Gain/(Loss) 13,610.69 Change in Unrealized Gain/Loss 15,157.29 Change in Unrealized Gain/Loss 3,401.70 Weighted Average Maturity 41 Days Weighted Average Maturity 46 Days Change in Market Value (11,111,294.29) Change in Market Value (23,950,621.58) Yield to Maturity at Cost 0.31% Yield to Maturity at Cost 0.25% T-Bill Benchmark 0.32% T-Bill Benchmark 0.27% Agency Note Benchmark 0.25% Agency Note Benchmark 0.14% Average for Quarter City's Yield to Maturity 0.31% 1 Year T-Bill Benchmark Yield 0.27% Agency Note Benchmark Yield 0.18% 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: Claire Bogard Rick er aard Fatima Uwakwe Director of Finance Assistant Directo of Finance Senior Accountant Summary by Type September 30,2010 Description Face Amount\Shares Cost Value —Book Value Market Value YT_M P Cost Days To Maturity Cash $ 72,663,046.81 $ 72,663,046.81 $ 72,663,046.81 $ 72,663,046.81 0.19% 1 CD 4,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00 0.40% 120 FHLB 15,000,000.00 15,147,028.96 15,127,734.93 15,137,253.00 0.43% 208 FHLMC 4,000,000.00 4,053,602.32 4,023,109.44 4,024,357.00 0.34% 90 FNMA 2,000,000.00 2,017,500.00 2,009,784.94 2,012,630.00 0.52% 210 Total/Average $ 97,663,046.81 $ 97,881,178.09 $ 97,823,676.12 $ 97,837,286.81 0.25% 47 Group Portfolio Holdings Book Value by Maturity by Type 80,000,000 FHLMC FNMA FHLB 4% 2% 70,000,000 16% 60,000,000 50,000,000 CD 4% 40,000,000 30,000,000 ------ 20,000,000 -_-- 10,000,000 Cash 74% ilii- -�— 1-30 Days 31-60 Days 61-90 Days 91-120 Day421-180 Days>180 Days Interest Rates Date 1_010 3 mo 6 mo LW Zyt Z1L 5_1L Lit 1SZXt 20 yr 30 yr 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 9/30/2010 0.14 0.16 0.19 0.27 0.42 0.64 1.27 1.91 2.53 3.38 3.69 Yield Curve Comparison 4.50 350 4 a•l �r,i':.f. .s,e .V fi at t' g 1/1 ii.t ? t � d jfjk� €.� o r�rl'a)t tG IC c 4�1 F S t `i F t : E S, r 4 i.it' tt :54 < : •t t =4 y 2 1 i C.S r y1a F�"F ' `rIF.G #t lP!'ls fr t �Ki�6� t °�<e 2.50 f s : ._. u o ♦ s z t s . � c S 2.00 .4�w,0047, wxxx pIa�vur ty t n s t 1 r t'...l r iF(;.. r t{pp{¢¢ "irri�}j�+Nlof �33�}} 1.50 1 'i. ;':- .. .. .. _..:-. -.. 1,t .'t tr ii to s t;4 t .} qh!3 E i Y,Sk s; 1.00 ; OSO '1,awI jtEririvoas 4j 4:Fa{ 1.,., ,, 1 mo 3 mo 6 mo 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr 20 yr 30 yr t6/30/2010 - -9/30/2010 Portfolio vs. Benchmarks 6.00% t7. �t,° P. lirr. "uv ,is � tttit 1, f ltzt% i� s +1ww a a . x a rr ,py tM a m < x r s5.00% i C efWe [ ;A it '"r7.Hr!' .'� ` a�" .*.i ,"t ayx: K,... 3.00% 2.00% Ii 1.c O.00 O o� p1 0^ o� o� A� p� o% o% o9 p% o% oq o9 o1 p°' o°' o°' o°' o°' 64 0 & dj a o°' e 10 ,ti0 ,ti0 ti0 ,yo ,y0 .ti0 ,ti0 ,0 O�‹boa p¢`,ac Qe Oar P. ,A��c .J\p,,Q,`�e9 oc 0 Oec Nac,�e 4a,PQ<NSa)l c N PJoo`�e, O aoa<-0 ,ac<4. V- 4,,ai.1 ��PJ4=`'eQ -•-Port Total -III-1 Yr T-Bill -*-Agency Note City of Pearland Quarterly Investment Report Report Format: By CUSIP Group By: Security Type Portfolio/Report Group: Report Group: Pearland Begin Date: 6/30/2010, End Date: 9/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.64 10,385,905.91 2,048,781.77 4,685,661.96 0.00 0.00 7,749,025.72 13,873.54 Sweep Cash Fund Wells Fargo WFSWEEP 17: Municipal N/A 0.24 136,040.55 8,470.07 8,855.63 0.00 0.00 135,654.99 82.11 Sweep Cash Court Security Wells Fargo WFSWEEP 18: City Wide N/A 0.24 44,530.18 4,836.09 4,880.19 0.00 0.00 44,486.08 24.27 Sweep Cash Donation Wells Fargo WFSWEEP 19: Court N/A 0.24 225,947.63 9,699.84 39,592.44 0.00 0.00 196,055.03 114.98 Sweep Cash Technology Wells Fargo WFSWEEP 20: Debt N/A 0.22 8,900,081.18 1,231,225.49 6,540,671.93 0.00 0.00 3,590,634.74 3,199.83 Sweep Cash Services Wells Fargo WFSWEEP 23: Court N/A 0.28 2,827.56 9,421.31 3,178.14 0.00 0.00 9,070.73 4.11 Sweep Cash Juvenile Mgmt Wells Fargo WFSWEEP 25: Emergency N/A 0.00 -13,774.50 13,774.50 0.00 0.00 0.00 0.00 0.00 Sweep Cash Mgmt Buyout Wells Fargo WFSWEEP 30: Water& N/A 0.24 10,993,167.59 2,086,413.09 5,069,683.03 0.00 0.00 8,009,897.65 5,711.28 Sweep Cash Sewer Wells Fargo WFSWEEP 31: Solidwaste N/A 0.10 37,032.45 608,713.64 565.44 0.00 0.00 645,180.65 41.91 Sweep Cash Wells Fargo WFSWEEP 35: Street N/A 0.24 546,233.68 329.94 0.00 0.00 0.00 546,563.62 329.94 Sweep Cash Assessment Wells Fargo WFSWEEP 42: Utility N/A 0.24 16,491,729.83 8,665.13 3,288,722.62 0.00 0.00 13,211,672.34 8,665.13 Sweep Cash Impact Fee Wells Fargo WFSWEEP 43: Regional N/A 0.24 4,031.22 2.42 0.00 0.00 0.00 4,033.64 2.42 Sweep Cash Detention Wells Fargo WFSWEEP 44: Shadow N/A 0.25 1,454,879.98 1,168,764.88 199,785.50 0.00 0.00 2,423,859.36 1,033.01 Sweep Cash Creek Impact Wells Fargo WFSWEEP 45: Hotel/Motel N/A 0.24 1,293,777.06 58,057.87 26,319.43 0.00 0.00 1,325,515.50 806.89 Sweep Cash Occupancy Wells Fargo WFSWEEP 46: Park N/A 0.24 48,055.22 1,005.47 4,919.37 0.00 0.00 44,141.32 26.97 Sweep Cash Donations Wells Fargo WFSWEEP 47: Park&Rec N/A 0.24 993,498.21 183,538.66 10,721.72 0.00 0.00 1,166,315.15 659.66 Sweep Cash Development Page l of 5 Portfolio Maturity Annualized Amortized Amortized Investment Description CUSIP/Tlcker Name Date TRR-BV Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income-BV Wells Fargo WFSWEEP 49:Tree Trust N/A 0.23 17,243.82 8.71 11,000.00 0.00 0.00 6,252.53 8.71 Sweep Cash Fund Wells Fargo WFSWEEP 50: Capital N/A 0.25 4,370,015.96 892,611.56 1,376,000.55 0.00 0.00 3,886,626.97 2,782.20 Sweep Cash Projects Wells Fargo WFSWEEP 55: Sidewalk N/A 0.24 204,998.43 8,141.05 0.00 0.00 0.00 213,139.48 125.05 Sweep Cash Fund Wells Fargo WFSWEEP 60: Police State N/A 0.24 223,935.48 4,715.49 4,224.99 0.00 0.00 224,425.98 134.12 Sweep Cash Seizure Wells Fargo WFSWEEP 62: Federal N/A 0.24 24,602.15 14.85 0.00 0.00 0.00 24,617.00 14.85 Sweep Cash Police Fund Wells Fargo WFSWEEP 64: 1998 Cert N/A 0.24 1,119,412.29 619.39 152,189.00 0.00 0.00 967,842.68 619.39 Sweep Cash of Obligation Wells Fargo WFSWEEP67: 2003 N/A 0.24 6,596,164.11 3,827.86 370,469.79 0.00 0.00 6,229,522.18 3,827.86 Sweep Cash Revenue Bonds Wells Fargo WFSWEEP 68: 2001 Cert N/A 0.24 2,752,905.27 48,319.58 477,476.30 0.00 0.00 2,323,748.55 1,496.26 Sweep Cash of Obligation 70: 2005 Wells Fargo WFSWEEP Refunding/ N/A 0.23 12,903,619.98 6,345.98 3,259,005.17 0.00 0.00 9,650,960.79 6,345.98 Sweep Cash Mobility Wells Fargo WFSWEEP 71: 2005 N/A 0.20 19,218.63 11.62 19,230.25 0.00 0.00 0.00 4.75 Sweep Cash Refunding/Drain Wells Fargo WFSWEEP 95: Property N/A -0.66 -26,463.25 187,269.32 99,862.72 0.00 0.00 60,943.35 22.33 Sweep Cash Liability Wells Fargo WFSWEEP 97: Employee N/A -0.10 -49,812.60 84,010.52 0.00 0.00 0.00 34,197.92 5.26 Sweep Cash Benefit Trust Wells Fargo WFSWEEP 99: COP Health N/A 0.00 0.00 3,456.37 3,456.37 0.00 0.00 0.00 0.00 Sweep Cash Claims Fund Wells Fargo WFSWEEP Z101: Grant N/A 0.00 -104,227.32 108,921.07 4,693.75 0.00 0.00 0.00 0.00 Sweep Cash Fund Wells Fargo WFSWEEP Z105: 2007 N/A 0.00 187.38 22,998.46 22,998.40 0.00 0.00 187.44 0.06 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z106: 2008 N/A 0.00 -4,793.70 12,320.07 7,526.37 0.00 0.00 0.00 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z107: 2009 N/A -1.16 -14,037.16 34,770.66 20,733.50 0.00 0.00 0.00 2.23 Sweep Cash CDBG Fund Wells Fargo WFSWEEP N/A CDBG N/A 0.09 11,109.93 1,731.24 1,728.50 0.00 0.00 11,112.67 2.74 Sweep Cash Recovery Fund Wells Fargo WFSWEEP Z120: Mgmt N/A 0.24 248,312.18 132.03 50,304.00 0.00 0.00 198,140.21 132.03 Sweep Cash District 1 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 Wells Fargo WFSWEEP Z140: U of H N/A 0.01 3,038.79 47,390.26 6,789.89 0.00 0.00 43,639.16 0.15 Sweep Cash Fund Wells Fargo Z150: Sweep Cash WFSWEEP Hurricane IKE N/A 0.24 73,930.31 44.65 73,974.96 0.00 0.00 0.00 44.65 Proj Wells Fargo Z200: 2006 Sweep Cash WFSWEEP Cert of N/A 0.24 4,461,079.95 10,177.18 118,299.31 0.00 0.00 4,352,957.82 2,677.18 Obligation Wells Fargo Z201: 2007 Sweep Cash WFSWEEP Cert of N/A 0.24 2,885,625.92 1,621.78 632,378.01 0.00 0.00 2,254,869.69 1,621.78 Obligation Wells Fargo WFSWEEP Z202: 2007A N/A 0.22 7,006,668.56 2,896.07 3,442,569.52 0.00 0.00 3,566,995.11 2,896.07 Sweep Cash Gen Obligation Wells Fargo WFSWEEP Z203: 2009 N/A 0.00 510,385.85 0.00 2,231,100.17 0.00 0.00 -1,720,714.32 0.00 Sweep Cash Gen Obligation Wells Fargo Z205: 2010 Sweep Cash WFSWEEP Cert of N/A 0.20 690,684.81 170.91 690,855.72 0.00 0.00 0.00 170.91 Obligation Wells Fargo WFSWEEP Z301: W/S Pay N/A 0.24 1,224,028.87 10,391.61 2,945.40 0.00 0.00 1,231,475.08 741.38 Sweep Cash As U Go CIP Sub Total/Average 0.28 96,691,798.39 8,934,618.46 32,963,370.04 0.00 0.00 72,663,046.81 58,251.99 Cash CERTIFICATE OF DEPOSIT Pearland State 10: General Bank 1.5 CD700013249 Fund 7/24/2010 1.66 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 986.30 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 1,008.22 1/28/2011 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 1,008.22 1/28/2011 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 1,008.22 1/28/2011 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 1,008.22 1/28/2011 Sub 0.47 5,000,000.00 0.00 1,000,000.00 0.00 0.00 4,000,000.00 5,019.18 Total/Average 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 Certificate Of Deposit FHLB BOND FHLB 0.7 3133XYNV3 10: General 6/16/2011 0.71 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 1,477.78 6/16/2011-10 Fund FHLB 0.57 3133XV5G2 20: Debt 12/29/2010 0.56 1,000,049.72 0.00 0.00 0.00 -25.00 1,000,024.72 1,400.00 12/29/2010 Services FHLB 3.25 31331YC24 30: Water& 4/9/2012 0.39 0.00 1,043,810.00 0.00 0.00 -2,269.95 1,041,540.05 348.11 4/9/2012 Sewer FHLB 0.57 3133XV5G2 30: Water& 12/29/2010 0.56 1,000,049.72 0.00 0.00 0.00 -25.00 1,000,024.72 1,400.00 12/29/2010 Sewer FHLB 0.42 3133XYJY2 30: Water& 2/17/2011 0.40 1,000,110.52 0.00 0.00 0.00 -43.82 1,000,066.70 1,006.18 2/17/2011 Sewer FHLB 0.625 3133703Y2 42: Utility 1/12/2012 0.62 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 1,406.25 1/12/2012 Impact Fee FHLB 3.25 3133XPCS1 42: Utility 3/9/2012 0.36 0.00 1,042,160.00 0.00 0.00 -2,303.83 1,039,856.17 314.22 3/9/2012 Impact Fee FHLB 0.5 3133XUX73 50: Capital 10/15/2010 0.30 1,000,594.96 0.00 0.00 0.00 -509.97 1,000,084.99 740.03 10/15/2010 Projects FHLB 0.57 3133XV5G2 50: Capital 12/29/2010 0.36 1,001,036.09 0.00 0.00 0.00 -520.94 1,000,515.15 904.06 12/29/2010 Projects FHLB 0.57 3133XV5G2 68: 2001 Cert 12/29/2010 0.36 1,001,036.09 0.00 0.00 0.00 -520.94 1,000,515.15 904.06 12/29/2010 of Obligation FHLB 3.75 70: 2005 9/9/2011 3133XRY46 Refunding/ 9/9/2011 0.18 0.00 1,035,230.00 0.00 0.00 -2,864.23 1,032,365.77 156.60 Mobility FHLB 1.625 70: 2005 7/27/2011 3133XTXH4 Refunding/ 7/27/2011 0.46 1,012,450.00 0.00 0.00 0.00 -2,895.35 1,009,554.65 1,167.15 Mobility 70: 2005 FHLB 0.5 3133XUX73 Refunding/ 10/15/2010 0.30 1,000,594.96 0.00 0.00 0.00 -509.97 1,000,084.99 740.03 10/15/2010 Mobility FHLB 0.57 70: 2005 3133XV5G2 Refunding/ 12/29/2010 0.36 2,002,072.18 0.00 0.00 0.00 -1,041.88 2,001,030.30 1,808.12 12/29/201057 Mobility FHLB 0.85 70: 2005 5/4/2011 3133XVLE9 Refunding/ 5/4/2011 0.50 1,002,942.79 0.00 0.00 0.00 -871.22 1,002,071.57 1,253.78 Mobility Page 4 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.44 12,020,937.03 4,121,200.00 1,000,000.00 0.00 -14,402.10 15,127,734.93 15,026.37 FHLB Bond FHLMC BOND FHLMC 4.75 3134A4VJO 10: General 1/18/2011 0.29 1,024,550.00 0.00 0.00 0.00 -11,159.09 1,013,390.91 715.91 1/18/2011 Fund FHLMC 1.45 3128X8QT2 20: Debt 9/10/2010 0.24 1,002,362.93 0.00 1,000,000.00 0.00 -2,362.93 0.00 456.51 9/10/2010 Services FHLMC 1.5 3137EABW8 30: Water& 1/7/2011 0.40 1,005,696.81 0.00 0.00 0.00 -2,741.78 1,002,955.03 1,008.22 1/7/2011 Sewer FHLMC 2.875 3137EABV0 42: Utility 11/23/2010 0.29 1,010,275.68 0.00 0.00 0.00 -6,467.21 1,003,808.47 720.29 11/23/2010 Impact Fee FHLMC 1.45 3128X8QT2 44: Shadow 9/10/2010 0.24 1,002,362.93 0.00 1,000,000.00 0.00 -2,362.93 0.00 456.51 9/10/2010 Creek Impact FHLMC 1.5 Z200: 2006 1/7/2011 3137EA8W8 Cert of 1/7/2011 0.40 1,005,696.81 0.00 0.00 0.00 -2,741.78 1,002,955.03 1,008.22 Obligation Sub Total/Average 0.31 6,050,945.16 0.00 2,000,000.00 0.00 -27,835.72 4,023,109.44 4,365.66 FHLMC Bond FNMA BOND FNMA 1.375 31398AWQ1 10: General 4/28/2011 0.53 1,007,009.41 0.00 0.00 0.00 -2,116.94 1,004,892.47 1,320.56 4/28/2011 Fund FNMA 1.375 31398AWQ1 20: Debt 4/28/2011 0.53 1,007,009.41 0.00 0.00 0.00 -2,116.94 1,004,892.47 1,320.56 4/28/2011 Services Sub Total/Average 0.53 2,014,018.82 0.00 0.00 0.00 -4,233.88 2,009,784.94 2,641.12 FNMA Bond Total / 0.31 121 777,699.40 13,055,818.46 36,963,370.04 0.00 - 97 823'676.12 85,304.32 Average 46,471.70 Page 5 of 5 City of Pearland City of Pearland- By Security Type Report Format: By Transaction Group By: Security Type Portfolio/Report Group: Report Group: Pearland As of 9/30/2010 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 Cash Wells Fargo WFSWEEP 5/31/2006 General 5/31/2006 N/A 0.19000 7,749,025.72 7,749,025.72 7,749,025.72 7,749,025.72 1 N/A 7.93 Sweep Cash Fund 17: Wells Fargo WFSWEEP Municipal 5/31/2006 N/A 0.19000 135,654.99 135,654.99 135,654.99 135,654.99 1 N/A 0.14 Sweep Cash Court Security Wells Fargo 18: City Sweep Cash WFSWEEP Wide 5/31/2006 N/A 0.19000 44,486.08 44,486.08 44,486.08 44,486.08 1 N/A 0.05 Donation Wells Fargo WFSWEEP 19: Court 5/31/2006 N/A 0.19000 196,055.03 196,055.03 196,055.03 196,055.03 1 N/A 0.20 Sweep Cash Technology Wells Fargo WFSWEEP 20: Debt 5/31/2006 N/A 0.19000 3,590,634.74 3,590,634.74 3,590,634.74 3,590,634.74 1 N/A 3.68 Sweep Cash Services 23Wells Fargo Juvenile 9/15/2009 N/A 0.19000 9,070.73 9,070.73 9,070.73 9,070.73 1 N/A 0.01 Mgmt Wells Fargo WFSWEEP 30: Water& 5/31/2006 N/A 0.19000 8,009,897.65 8,009,897.65 8,009,897.65 8,009,897.65 1 N/A 8.20 Sweep Cash Sewer Wells Fargo WFSWEEP 31: 12/1/2006 N/A 0.19000 645,180.65 645,180.65 645,180.65 645,180.65 1 N/A 0.66 Sweep Cash Solidwaste Wells Fargo WFSWEEP 35: Street 5/31/2006 N/A 0.19000 546,563.62 546,563.62 546,563.62 546,563.62 1 N/A 0.56 Sweep Cash Assessment Wells Fargo WFSWEEP 42: Utility 5/31/2006 N/A 0.19000 13,211,672.34 13,211,672.34 13,211,672.34 13,211,672.34 1 N/A 13.53 Sweep Cash Impact Fee Wells Fargo WFSWEEP 43: Regional 5/31/2006 N/A 0.19000 4,033.64 4,033.64 4,033.64 4,033.64 1 N/A 0.00 Sweep Cash Detention Wells Fargo 44: Shadow Sweep Cash WFSWEEP Creek 5/31/2006 N/A 0.19000 2,423,859.36 2,423,859.36 2,423,859.36 2,423,859.36 1 N/A 2.48 Impact Wells Fargo 45: Cash WFSWEEP : Hotel/Motel 5/31/2006 N/A 0.19000 1,325,515.50 1,325,515.50 1,325,515.50 1,325,515.50 1 N/A 1.36 Occupancy Wells Fargo WFSWEEP 46: Park 5/31/2006 N/A 0.19000 44,141.32 44,141.32 44,141.32 44,141.32 1 N/A 0.05 Sweep Cash Donations Page 1 of 5 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 47: Park& Wells Fargo WFSWEEP Rec 5/31/2006 N/A 0.19000 1,166,315.15 1,166,315.15 1,166,315.15 1,166,315.15 1 N/A 1.19 Sweep Cash Development Wells Fargo WFSWEEP 49:Tree 5/31/2006 N/A 0.19000 6,252.53 6,252.53 6,252.53 6,252.53 1 N/A 0.01 Sweep Cash Trust Fund Wells Fargo WFSWEEP 50: Capital 5/31/2006 N/A 0.19000 3,886,626.97 3,886,626.97 3,886,626.97 3,886,626.97 1 N/A 3.98 Sweep Cash Projects Wells Fargo WFSWEEP 55: Sidewalk 5/31/2006 N/A 0.19000 213,139.48 213,139.48 213,139.48 213,139.48 1 N/A 0.22 Sweep Cash Fund 60: Police 0.23 Wells Fargo WFSWEEP State 5/31/2006 N/A 0.19000 224,425.98 224,425.98 224,425.98 224,425.98 1 N/A Sweep Cash Seizure Wells Fargo WFSWEEP 62: Federal 5/31/2006 N/A 0.19000 24,617.00 24,617.00 24,617.00 24,617.00 1 N/A 0.03 Sweep Cash Police Fund 64: 1998 0.99 Wells Fargo WFSWEEP Cert of 5/31/2006 N/A 0.19000 967,842.68 967,842.68 967,842.68 967,842.68 1 N/A Sweep Cash Obligation 67: 2003 Wells Fargo WFSWEEP Revenue 5/31/2006 N/A 0.19000 6,229,522.18 6,229,522.18 6,229,522.18 6,229,522.18 1 N/A 6.38 Sweep Cash Bonds 68: 2001 2.38 Wells Fargo WFSWEEP Cert of 5/31/2006 N/A 0.19000 2,323,748.55 2,323,748.55 2,323,748.55 2,323,748.55 1 N/A Sweep Cash Obligation 70: 2005 Wells Fargo WFSWEEP Refunding/ 5/31/2006 N/A 0.19000 9,650,960.79 9,650,960.79 9,650,960.79 9,650,960.79 1 N/A 9.88 Sweep Cash Mobility Wells Fargo WFSWEEP 95: Property 10/31/2006 N/A 0.19000 60,943.35 60,943.35 60,943.35 60,943.35 1 N/A 0.06 Sweep Cash Liability 97: 0.04 Wells Fargo WFSWEEP Employee 9/1/2007 N/A 0.19000 34,197.92 34,197.92 34,197.92 34,197.92 1 N/A Sweep Cash Benefit Trust Wells Fargo WFSWEEP Z105: 2007 5/1/2007 N/A 0.19000 187.44 187.44 187.44 187.44 1 N/A 0.00 Sweep Cash CDBG Fund Z116: CDBG Wells Fargo WFSWEEP Recovery 7/31/2009 N/A 0.19000 11,112.67 11,112.67 11,112.67 11,112.67 1 N/A 0.01 Sweep Cash Fund Wells Fargo WFSWEEP Z120: Mgmt 12/31/2007 N/A 0.19000 198,140.21 198,140.21 198,140.21 198,140.21 1 N/A 0.20 Sweep Cash District 1 Wells Fargo WFSWEEP Z140: U of H 12/1/2009 N/A 0.19000 43,639.16 43,639.16 43,639.16 43,639.16 1 N/A 0.04 Sweep Cash Fund Page 2 of 5 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 Wells Fargo Z200: 2006 Sweep Cash WFSWEEP Cert of 6/30/2006 N/A 0.19000 4,352,957.82 4,352,957.82 4,352,957.82 4,352,957.82 1 N/A 4.46 Obligation Wells Fargo Z201: 2007 Sweep Cash W FSW EEP Cert of 8/31/2006 N/A 0.19000 2,254,869.69 2,254,869.69 2,254,869.69 2,254,869.69 1 N/A 2.31 Obligation WellsZ202: 2007A Fargo Sweep Cash WFSWEEP Gen 12/31/2007 N/A 0.19000 3,566,995.11 3,566,995.11 3,566,995.11 3,566,995.11 1 N/A 3.65 Obligation Wells Fargo Z203: 2009 Sweep Cash WFSWEEP Gen 10/30/2008 N/A 0.19000 -1,720,714.32 -1,720,714.32 -1,720,714.32 -1,720,714.32 1 N/A -1.76 Obligation Wells Fargo Z301: W/S Sweep Cash WFSWEEP Pay As U Go 12/31/2007 N/A 0.19000 1,231,475.08 1,231,475.08 1,231,475.08 1,231,475.08 1 N/A 1.26 CIP Sub Total / 0.19000 72,663,046.81 72,663,046.81 72,663,046.81 72,663,046.81 1 0.00 74.40 Average Certificate Of Deposit Wells Fargo 10: General Bank 0.4 CD7579071205 Fund 1/28/2010 1/28/2011 0.40000 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 120 2,684.93 1.02 1/28/2011 Wells Fargo 20: Debt Bank 0.4 CD7579071205 Services 1/28/2010 1/28/2011 0.40000 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 120 2,684.93 1.02 1/28/2011 Wells Fargo 30: Water& Bank 0.4 CD7579071205 Sewer 1/28/2010 1/28/2011 0.40000 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 120 2,684.93 1.02 1/28/2011 Wells Fargo 42: Utility Bank 0.4 CD7579071205 Impact Fee 1/28/2010 1/28/2011 0.40000 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 120 2,684.93 1.02 1/28/2011 Sub Total / 0.40000 4,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00 120 10,739.72 4.10 Average FHLB Bond FHLB 0.57 3133XV5G2 20: Debt 9/29/2009 12/29/2010 0.56007 1,000,000.00 1,000,125.00 1,000,024.72 1,000,879.00 90 1,440.83 1.02 12/29/2010 Services FHLB 3.25 31331YC24 30: Water& 8/31/2010 4/9/2012 0.50658 1,000,000.00 1,043,810.00 1,041,540.05 1,041,852.00 557 15,437.50 1.02 4/9/2012 Sewer FHLB 0.57 3133XV5G2 30: Water& 9/29/2009 12/29/2010 0.56007 1,000,000.00 1,000,125.00 1,000,024.72 1,000,879.00 90 1,440.83 1.02 12/29/2010 Sewer Page 3 of 5 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 FHLB 0.42 3133XYJY2 30: Water& 5/20/2010 2/17/2011 0.40241 1,000,000.00 1,000,130.00 1,000,066.70 1,000,791.00 140 1,551.67 1.02 2/17/2011 Sewer FHLB 0.625 3133703Y2 42: Utility 7/9/2010 1/12/2012 0.62500 1,000,000.00 1,000,000.00 1,000,000.00 1,002,843.00 469 1,406.25 1.02 1/12/2012 Impact Fee FHLB 3.25 3133XPCS1 42: Utility 8/31/2010 3/9/2012 0.46722 1,000,000.00 1,042,160.00 1,039,856.17 1,040,306.00 526 1,895.83 1.02 3/9/2012 Impact Fee FHLB 0.5 3133XUX73 50: Capital 4/16/2010 10/15/2010 0.29486 1,000,000.00 1,001,014.26 1,000,084.99 1,000,112.00 15 5,180.56 1.02 10/15/2010 Projects FHLB 0.57 3133XV5G2 50: Capital 1/29/2010 12/29/2010 0.36108 1,000,000.00 1,001,910.11 1,000,515.15 1,000,879.00 90 1,440.83 1.02 12/29/2010 Projects FHLB 0.57 68: 2001 12/29/2010 3133XV5G2 Cert of 1/29/2010 12/29/2010 0.36108 1,000,000.00 1,001,910.11 1,000,515.15 1,000,879.00 90 1,440.83 1.02 Obligation FHLB 3.75 70: 2005 9/9/2011 3133XRY46 Refunding/ 8/31/2010 9/9/2011 0.29579 1,000,000.00 1,035,230.00 1,032,365.77 1,032,003.00 344 2,187.50 1.02 Mobility FHLB 0.85 70: 2005 5/4/2011 3133XVLE9 Refunding/ 5/20/2010 5/4/2011 0.50023 1,000,000.00 1,003,330.00 1,002,071.57 1,003,420.00 216 3,447.22 1.02 Mobility FHLB70: 2005 0.5 10/15/2010 3133XUX73 Refunding/ 4/16/2010 10/15/2010 0.29486 1,000,000.00 1,001,014.26 1,000,084.99 1,000,112.00 15 5,180.56 1.02 Mobility FHLB 0.57 70: 2005 12/29/2010 3133XV5G2 Refunding/ 1/29/2010 12/29/2010 0.36108 2,000,000.00 2,003,820.22 2,001,030.30 2,001,758.00 90 2,881.67 2.05 Mobility FHLB 1.625 70: 2005 7/27/2011 3133XTXH4 Refunding/ 6/30/2010 7/27/2011 0.46257 1,000,000.00 1,012,450.00 1,009,554.65 1,010,540.00 300 2,843.75 1.02 Mobility Sub Total / 0.42760 15,000,000.00 15,147,028.96 15,127,734.93 15,137,253.00 208 47,775.83 15.36 Average FHLMC Bond FHLMC 4.75 3134A4VJO 10: General 6/30/2010 1/18/2011 0.27956 1,000,000.00 1,024,550.00 1,013,390.91 1,013,479.00 110 9,500.00 1.02 1/18/2011 Fund FHLMC 1.5 3137EABW8 30: Water& 4/16/2010 1/7/2011 0.40039 1,000,000.00 1,007,951.16 1,002,955.03 1,003,436.00 99 3,458.33 1.02 1/7/2011 Sewer FHLMC 42: Utility 2.875 3137EABV0 Impact Fee 5/20/2010 11/23/2010 0.28441 1,000,000.00 1,013,150.00 1,003,808.47 1,004,006.00 54 10,142.36 1.02 11/23/2010 Page 4 of 5 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 FHLMC 1.5 C200: 2006 1/7/2011 3137EABW8 ert of 4/16/2010 1/7/2011 0.40039 1,000,000.00 1,007,951.16 1,002,955.03 1,003,436.00 99 3,458.33 1.02 Obligation Sub Total / 0.34119 4,000,000.00 4,053,602.32 4,023,109.44 4,024,357.00 90 26,559.02 4.10 Average FNMA Bond FNMA 1.375 31398AWQ1 10: General 4/16/2010 4/28/2011 0.52481 1,000,000.00 1,008,750.00 1,004,892.47 1,006,315.00 210 5,805.56 1.02 4/28/2011 Fund FNMA 1.375 31398AWQ1 20: Debt 4/16/2010 4/28/2011 0.52481 1,000,000.00 1,008,750.00 1,004,892.47 1,006,315.00 210 5,805.56 1.02 4/28/2011 Services Sub Total / 0.52481 2,000,000.00 2,017,500.00 2,009,784.94 2,012,630.00 210 11,611.12 2.05 Average Total / 0.24814 97,663,046.81 97,881,178.09 97,823,676.12 97,837,286.81 46 96,685.69 100 Average Page 5 of 5 City of Pearland City of Pearland-by Fund Report Format: By Transaction Group By: Portfolio Name Portfolio/Report Group: Report Group: Pearland As of 9/30/2010 Settlement Face YTM @ Maturity Days To %of Description CUSIP/Ticker Security Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio 10: General Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 7,749,025.72 7,749,025.72 7,749,025.72 0.19000 N/A 1 7.93 Cash Wells Fargo Bank 0.4 Certificate Of 1/28/2010 1,000,000.00 1,000,000.00 1,000,000.00 0.40000 1/28/2011 120 1.02 1/28/2011 CD7579071205 Deposit FHLMC 4.75 1/18/2011 3134A4VJ0 FHLMC Bond 6/30/2010 1,000,000.00 1,013,390.91 1,013,479.00 0.27956 1/18/2011 110 1.02 FNMA 1.375 4/28/2011 31398AWQ1 FNMA Bond 4/16/2010 1,000,000.00 1,004,892.47 1,006,315.00 0.52481 4/28/2011 210 1.02 Sub Total /Average 10,749,025.72 10,767,309.10 10,768,819.72 0.24902 42 11.01 17: Municipal Court Security Wells Fargo Sweep WFSWEEP Cash 5/31/2006 135,654.99 135,654.99 135,654.99 0.19000 N/A 1 0.14 Cash Sub Total /Average 135,654.99 135,654.99 135,654.99 0.19000 1 0.14 18: City Wide Donation Wells Fargo Sweep WFSWEEP Cash 5/31/2006 44,486.08 44,486.08 44,486.08 0.19000 N/A 1 0.05 Cash Sub Total /Average 44,486.08 44,486.08 44,486.08 0.19000 1 0.05 19:Court Technology Wells Fargo Sweep WFSWEEP Cash 5/31/2006 196,055.03 196,055.03 196,055.03 0.19000 N/A 1 0.20 Cash Sub Total /Average 196,055.03 196,055.03 196,055.03 0.19000 1 0.20 20: Debt Services Wells Fargo Sweep WFSWEEP Cash 5/31/2006 3,590,634.74 3,590,634.74 3,590,634.74 0.19000 N/A 1 3.68 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 120 1.02 1/28/2011 Deposit FHLB 0.57 12/29/2010 3133XV5G2 FHLB Bond 9/29/2009 1,000,000.00 1,000,024.72 1,000,879.00 0.56007 12/29/2010 90 1.02 FNMA 1.375 4/28/2011 31398AWQ1 FNMA Bond 4/16/2010 1,000,000.00 1,004,892.47 1,006,315.00 0.52481 4/28/2011 210 1.02 Page 1 of 6 Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Security Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Sub Total /Average 6,590,634.74 6,595,551.93 6,597,828.74 0.32882 64 6.75 23: Court Juvenile Mgmt Wells Fargo Sweep WFSWEEP Cash 9/15/2009 9,070.73 9,070.73 9,070.73 0.19000 N/A 1 0.01 Cash Sub Total /Average 9,070.73 9,070.73 9,070.73 0.19000 1 0.01 30: Water&Sewer Wells Fargo Sweep WFSWEEP Cash 5/31/2006 8,009,897.65 8,009,897.65 8,009,897.65 0.19000 N/A 1 8.20 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 120 1.02 1/28/2011 Deposit FHLB 3.25 4/9/2012 31331YC24 FHLB Bond 8/31/2010 1,000,000.00 1,041,540.05 1,041,852.00 0.50658 4/9/2012 557 1.02 FHLB 0.57 12/29/2010 3133XV5G2 FHLB Bond 9/29/2009 1,000,000.00 1,000,024.72 1,000,879.00 0.56007 12/29/2010 90 1.02 FHLB 0.42 2/17/2011 3133XY3Y2 FHLB Bond 5/20/2010 1,000,000.00 1,000,066.70 1,000,791.00 0.40241 2/17/2011 140 1.02 FHLMC 1.5 1/7/2011 3137EABW8 FHLMC Bond 4/16/2010 1,000,000.00 1,002,955.03 1,003,436.00 0.40039 1/7/2011 99 1.02 Sub Total /Average 13,009,897.65 13,054,484.15 13,056,855.65 0.29142 78 13.32 31:Solidwaste Wells Fargo Sweep WFSWEEP Cash 12/1/2006 645,180.65 645,180.65 645,180.65 0.19000 N/A 1 0.66 Cash Sub Total /Average 645,180.65 645,180.65 645,180.65 0.19000 1 0.66 35:Street Assessment Wells Fargo Sweep WFSWEEP Cash 5/31/2006 546,563.62 546,563.62 546,563.62 0.19000 N/A 1 0.56 Cash Sub Total /Average 546,563.62 546,563.62 546,563.62 0.19000 1 0.56 42: Utility Impact Fee Wells Fargo Sweep WFSWEEP Cash 5/31/2006 13,211,672.34 13,211,672.34 13,211,672.34 0.19000 N/A 1 13.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 120 1.02 1/28/2011 Deposit FHLB 0.625 1/12/2012 3133703Y2 FHLB Bond 7/9/2010 1,000,000.00 1,000,000.00 1,002,843.00 0.62500 1/12/2012 469 1.02 FHLB 3.25 3/9/2012 3133XPCS1 FHLB Bond 8/31/2010 1,000,000.00 1,039,856.17 1,040,306.00 0.46722 3/9/2012 526 1.02 Page 2 of 6 Settlement Face YTM @ Maturity Days To %of Description CUSIP/Ticker Security Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio FHLMC 2.875 3137EABVO rHLMC Bond 5/20/2010 1,000,000.00 1,003,808.47 1,004,006.00 0.28441 11/23/2010 54 1.02 11/23/2010 Sub Total / Average 17,211,672.34 17,255,336.98 17,258,827.34 0.24907 69 17.62 43: Regional Detention Wells Fargo Sweep WFSWEEP Cash 5/31/2006 4,033.64 4,033.64 4,033.64 0.19000 N/A 1 0.00 Cash Sub Total /Average 4,033.64 4,033.64 4,033.64 0.19000 1 0.00 44: Shadow Creek Impact Wells Fargo Sweep WFSWEEP Cash 5/31/2006 2,423,859.36 2,423,859.36 2,423,859.36 0.19000 N/A 1 2.48 Cash Sub Total /Average 2,423,859.36 2,423,859.36 2,423,859.36 0.19000 1 2.48 45: Hotel/Motel Occupancy Wells Fargo Sweep WFSWEEP Cash 5/31/2006 1,325,515.50 1,325,515.50 1,325,515.50 0.19000 N/A 1 1.36 Cash Sub Total /Average 1,325,515.50 1,325,515.50 1,325,515.50 0.19000 1 1.36 46: Park Donations Wells Fargo Sweep WFSWEEP Cash 5/31/2006 44,141.32 44,141.32 44,141.32 0.19000 N/A 1 0.05 Cash Sub Total /Average 44,141.32 44,141.32 44,141.32 0.19000 1 0.05 47: Park&Rec Development Wells Fargo Sweep WFSWEEP Cash 5/31/2006 1,166,315.15 1,166,315.15 1,166,315.15 0.19000 N/A 1 1.19 Cash Sub Total /Average 1,166,315.15 1,166,315.15 1,166,315.15 0.19000 1 1.19 49:Tree Trust Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 6,252.53 6,252.53 6,252.53 0.19000 N/A 1 0.01 Cash Sub Total/Average 6,252.53 6,252.53 6,252.53 0.19000 I 0.01 50:Capital Projects Wells Fargo Sweep WFSWEEP Cash 5/31/2006 3,886,626.97 3,886,626.97 3,886,626.97 0.19000 N/A 1 3.98 Cash Page 3 of 6 Settlement Face YTM @ Maturity Days To %of Description CUSIP/Ticker Security Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio FHLB 0.5 10/15/2010 3133XUX73 FHLB Bond 4/16/2010 1,000,000.00 1,000,084.99 1,000,112.00 0.29486 10/15/2010 15 1.02 FHLB 0.57 12/29/2010 3133XV5G2 FHLB Bond 1/29/2010 1,000,000.00 1,000,515.15 1,000,879.00 0.36108 12/29/2010 90 1.02 Sub Total /Average 5,886,626.97 5,887,227.11 5,887,617.97 0.23688 18 6.03 55: Sidewalk Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 213,139.48 213,139.48 213,139.48 0.19000 N/A 1 0.22 Cash Sub Total /Average 213,139.48 213,139.48 213,139.48 0.19000 1 0.22 60: Police State Seizure Wells Fargo Sweep WFSWEEP Cash 5/31/2006 224,425.98 224,425.98 224,425.98 0.19000 N/A 1 0.23 Cash Sub Total /Average 224,425.98 224,425.98 224,425.98 0.19000 1 0.23 62: Federal Police Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 24,617.00 24,617.00 24,617.00 0.19000 N/A 1 0.03 Cash Sub Total /Average 24,617.00 24,617.00 24,617.00 0.19000 1 0.03 64: 1998 Cert of Obligation Wells Fargo Sweep WFSWEEP Cash 5/31/2006 967,842.68 967,842.68 967,842.68 0.19000 N/A 1 0,99 Cash Sub Total /Average 967,842.68 967,842.68 967,842.68 0.19000 1 0.99 67: 2003 Revenue Bonds Wells Fargo Sweep WFSWEEP Cash 5/31/2006 6,229,522.18 6,229,522.18 6,229,522.18 0.19000 N/A 1 6.38 Cash Sub Total /Average 6,229,522.18 6,229,522.18 6,229,522.18 0.19000 1 6.38 68: 2001 Cert of Obligation Wells Fargo Sweep WFSWEEP Cash 5/31/2006 2,323,748.55 2,323,748.55 2,323,748.55 0.19000 N/A 1 2.38 Cash FHLB 0.57 12/29/2010 3133XV5G2 FHLB Bond 1/29/2010 1,000,000.00 1,000,515.15 1,000,879.00 0.36108 12/29/2010 90 1.02 Sub Total/Average 3,323,748.55 3,324,263.70 3,324,627.55 0.24147 28 3.40 70: 2005 Refunding/ Mobility Page 4 of 6 Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Security Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Wells Fargo Sweep WFSWEEP Cash 5/31/2006 9,650,960.79 9,650,960.79 9,650,960.79 0.19000 N/A 1 9.88 Cash FHLB 3.75 9/9/2011 3133XRY46 FHLB Bond 8/31/2010 1,000,000.00 1,032,365.77 1,032,003.00 0.29579 9/9/2011 344 1.02 FHLB 0.85 5/4/2011 3133XVLE9 FHLB Bond 5/20/2010 1,000,000.00 1,002,071.57 1,003,420.00 0.50023 5/4/2011 216 1.02 FHLB 0.5 10/15/2010 3133XUX73 FHLB Bond 4/16/2010 1,000,000.00 1,000,084.99 1,000,112.00 0.29486 10/15/2010 15 1.02 FHLB 0.57 12/29/2010 3133XV5G2 FHLB Bond 1/29/2010 2,000,000.00 2,001,030.30 2,001,758.00 0.36108 12/29/2010 90 2.05 FHLB 1.625 7/27/2011 3133XTXH4 FHLB Bond 6/30/2010 1,000,000.00 1,009,554.65 1,010,540.00 0.46257 7/27/2011 300 1.02 Sub Total /Average 15,650,960.79 15,696,068.07 15,698,793.79 0.26256 68 16.03 95: Property Liability Wells Fargo Sweep WFSWEEP Cash 10/31/2006 60,943.35 60,943.35 60,943.35 0.19000 N/A 1 0.06 Cash Sub Total /Average 60,943.35 60,943.35 60,943.35 0.19000 1 0.06 97: Employee Benefit Trust Wells Fargo Sweep WFSWEEP Cash 9/1/2007 34,197.92 34,197.92 34,197.92 0.19000 N/A 1 0.04 Cash Sub Total /Average 34,197.92 34,197.92 34,197.92 0.19000 1 0.04 Z105: 2007 CDBG Fund Wells Fargo Sweep WFSWEEP Cash 5/1/2007 187.44 187.44 187.44 0.19000 N/A 1 0.00 Cash Sub Total /Average 187.44 187.44 187.44 0.19000 1 0.00 Z116:CDBG Recovery Fund Wells Fargo Sweep WFSWEEP Cash 7/31/2009 11,112.67 11,112.67 11,112.67 0.19000 N/A 1 0.01 Cash Sub Total/Average 11,112.67 11,112.67 11,112.67 0.19000 1 0.01 Z120: Mgmt District 1 Wells Fargo Sweep WFSWEEP Cash 12/31/2007 198,140.21 198,140.21 198,140.21 0.19000 N/A 1 0.20 Cash Sub Total /Average 198,140.21 198,140.21 198,140.21 0.19000 1 0.20 Z140: U of H Fund Page 5 of 6 Settlement Face YTM @ Maturity Days To %of Description CUSIP/Ticker Security Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Wells Fargo Sweep WFSWEEP Cash 12/1/2009 43,639.16 43,639.16 43,639.16 0.19000 N/A 1 0.04 Cash Sub Total / Average 43,639.16 43,639.16 43,639.16 0.19000 1 0.04 Z200: 2006 Cert of Obligation Wells Fargo Sweep WFSWEEP Cash 6/30/2006 4,352,957.82 4,352,957.82 4,352,957.82 0.19000 N/A 1 4.46 Cash FHLMC 1.5 1/7/2011 3137EABW8 FHLMC Bond 4/16/2010 1,000,000.00 1,002,955.03 1,003,436.00 0.40039 1/7/2011 99 1.02 Sub Total /Average 5,352,957.82 5,355,912.85 5,356,393.82 0.22930 19 5.48 Z201: 2007 Cert of Obligation Wells Fargo Sweep WFSWEEP Cash 8/31/2006 2,254,869.69 2,254,869.69 2,254,869.69 0.19000 N/A 1 2.31 Cash Sub Total /Average 2,254,869.69 2,254,869.69 2,254,869.69 0.19000 1 2.31 Z202: 2007A Gen Obligation Wells Fargo Sweep WFSWEEP Cash 12/31/2007 3,566,995.11 3,566,995.11 3,566,995.11 0.19000 N/A 1 3.65 Cash Sub Total /Average 3,566,995.11 3,566,995.11 3,566,995.11 0.19000 1 3.65 Z203: 2009 Gen Obligation Wells Fargo Sweep WFSWEEP Cash 10/30/2008 -1,720,714.32 -1,720,714.32 -1,720,714.32 0.19000 N/A 1 -1.76 Cash Sub Total /Average -1,720,714.32 -1,720,714.32 -1,720,714.32 0.19000 1 -1.76 Z301:W/S Pay As U Go CIP Wells Fargo Sweep WFSWEEP Cash 12/31/2007 1,231,475.08 1,231,475.08 1,231,475.08 0.19000 N/A 1 1.26 Cash Sub Total /Average 1,231,475.08 1,231,475.08 1,231,475.08 0.19000 1 1.26 Total / Average 97,663,046.81 97,823,676.12 97,837,286.81 0.24814 46 100 Page 6 of 6 Pledged Collateral Reconciliation Report September 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 74,394,101.33 Wells Fargo 201-0419554 98 CO Escrow - Wells Fargo 807-1613395 Credit Card Account 5,065,831.82 Wells Fargo 818-4567843 Alvin ISD 5,130,026.62 Wells Fargo 001-3043112 PEDC Sales Tax - Wells Fargo Wells Fa .40 01/28/11 Certificate of Deposit 4,000,000.00 Total of Bank Balances $ 88,589,959.77 Pledged Collateral for City 119,085,786.40 FDIC Insurance 250,000.00 Total Collateral $ 119,335,786.40 Over(Under) Collateralized $ 30,745,826.63 Total % Collateralized 134.7% Bank Account Number Account Name 0 Wells Fargo 100-7284258 Development Authority 4,785,798.39 Total of Bank Balances $ 4,785,798.39 Pledged Collateral for DAP 8,866,429.40 FDIC Insurance 250,000.00 Total Collateral $ 9,116,429.40 Over(Under) Collateralized $ 4,330,631.01 Total % Collateralized 190.5% Total $ Over(Under) Collateralized $ 35,076,457.64 Total % Collateralized 137.6% Status Collateralized I:\Investments\Investment Reports\City of Pearland\Investment Report-City-Qtr 0910