Loading...
R2011-020 - 2011-02-14BE 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 December 2010. ATTEST: A RESOLUTION OF THE CITY .COUNCIL OF THE CITY OF PEARLAND, TEXAS, ACCEPTING THE CITY'S INVESTMENT REPORT FOR THE QUARTER ENDING DECEMBER 2010. PASSED, APPROVED, and ADOPTED this 14 day of February, A.D., 2011. APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY RESOLUTION NO. R2011 -20 TOM REID MAYOR • o� , , :- City of Pearland y� =wa . ...fit Quarterly Investment Report , t i n n 'a September 30, 2010 - December. 31, 2010. �sr I$I ^ Portfolio at September 30,2010 Portfolio at December 31,2010 Ending Book Value $ 97,823,676.12 Ending Book Value $ 118,909,819.02 Ending Market Value 97,837,286.81 Ending Market Value 118,909,003.03 Accrued Interest Receivable 96,685.69 Accrued Interest Receivable 105,587.04 FYD Total Interest Earned 337,656.63 FYD Total Interest.Earned 65,111.65 Unrealized Gain/(Loss) 13,610.69 Unrealized Gain/(Loss) (815.99) Change in Unrealized Gain/Loss 3,401.70 Change in Unrealized Gain/Loss (14,426.68) Weighted Average Maturity 46 Days Weighted Average Maturity 42 Days Change in Market Value (23,950,621.58) Change in Market Value 21,071,716.22 Yield to Maturity at Cost 0.25% Yield to Maturity at Cost 0.22% T-Bill Benchmark 0.27% T-Bill Benchmark 0.29% Agency Note Benchmark 0.14% Agency Note Benchmark 0.12% Average for Quarter 1 City's Yield to Maturity 0.24% 1 YearT=Bill Benchmark Yield 0.28% Agency Note Benchmark Yield 0.15% 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 Ri kverg and Fatima Uwakwe Director of Finance Assistant Di ctor of Finance Senior Accountant Summary by Type December 31,2010 Description Face Amount lShares Cost_Value Book Value Market Value YTM @Cost DaYs_lo_Maturity Cash $ 96,553,280.53 $ 96,553,280.53 $ 96,553,280.53 $ 96,553,280.53 0.17% 1 MM 231,844.50 231,844.50 231,844.50 231,844.50 0.17% 1 CD 4,000,000.00 4,000,000.00 4,000,000.00 4,000,000.00 0.40% 28 FHLB 11,000,000.00 11,137,110.00 11,099,320.37 11,100,354.00 0.45% 323 FHLMC 3,000,000.00 3,040,452.32 3,002,597.40 3,001,996.00 0.36% 11 FNMA 4,000,000.00 4,035,580.00 4,022,776.22 4,021,528.00 0.45% 286 Total/Average $ 118,785,125.03 $ 118,998,267.35 $ 118,909,819.02 $ 118,909,003.03 0.22% 42 Group Portfolio Holdings Book Value by Maturity by Type 120,000,000 -- - FHLMC FNMA 100,000,000 CD FHLB 3% 4% 3% 9% MM 80,000,000 — 0% 60,000,000 40,000,000 20,000,000 - Cash - — 81 1-30— 31-60— 61-90... 91-- 121-- >180... Interest Rates Date Div ling mo 1 yr 2 yr 3,C[ 5_Yr Lu 10 yr 2Q311 3QYr 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 12/31/2010 0.07 0.12 0.19 0.29 0.61 1.02 2.01 2.71 3.30 4.13 4.34 Yield Curve Comparison s.00 f �__T,,.. . 2.50 • Crty's Weighted Avg Yield.24% 2.00 ?. _ _ ._-42 Day Average Maturity 1.50 1.00 - 0.50 0.00 I 1 mo 3 mo 6 mo 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr 20 yr 30 yr t9/30/2010 -f-12/31/2010 Portfolio vs. Benchmarks 6.00% - -________._..--_- ---_____.__r_ . 1.009 : 2,L,,, 00 °^ APAPAAweCPAw °PCP °w °w °wCP0 °Aeee °m000 & & ,N9ti° ,tio 'ti° 10 ,1odododo or, o cf., It ki 40 v9 4"i low s, p�a°heQ 0 , ,e, �c0 kg,4,ab PQ<`.7, �Jc , P�q'gz, pc,..o,e. sab Qe 4'°<PQ<`S`aA °c N p* q,, -♦-•Port Total -1--1YrT-Bill --Or-Agency Note City of,Pearland Quarterly,Investment,Report Report Format:By'CUSIP Group By: Security Type Portfolio/Report.Group:Report Group:Pearland Begin Date:.9/30/2010,End Date:"12/31/2010 Portfolio. r Maturity Annualized Amortized Amortized 'Investment Description 'CUSIP/Ticker Name Date. TRR-BV T Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income-BV CASH Wells'Fargo :WFSWEEP 10: General N/A 0.31 7,749,025.72 5,395,995;22 1,517;146.45 0.00 0.00' 11;627,874.49 5,749.38 Sweep Cash Fund 17:. Wells Fargo WFSWEEP Municipal N/A 0.17 135,654.99 7,322.72 9,129.74 0.00` 0.00 133;847:97 58',67 Sweep Cash 'Court Security 18: City Wells Fargo WFSWEEP Wide N/A 0.17 44,486.08 1,236.77 '0.00 0.00 0,00 45;722.85 18.99 Sweep Cash Donation Wells.Fargo WFSWEEP 19:'Court N/A 0:17 196,055:03 4,388.09 6,236.00 0.00 .0:00 194,207.12 .80.93' Sweep•Cash. Technology Welis.Fargo WFSWEEP 20: Debt N/A 0.21 3,590,634.74. 13,084,664.80 0.00 0.00 0.00. 16,675;299.54 3,327.47 Sweep Cash :Services 23: Court Wells Fargo WFSWEEP Juvenile- •N/A 0.18 9,070.73 9;831.76 6,694:40 0.00_ 0.00 12,208.09 6.46 Sweep Cash Mgmt Wells Fargo WFSWEEP 30: Water& 'N/A, 0.17 8,009,897.65 2,304,207.21 0.00 0.00 0.00 10,314,104.88 4,093.73 Sweep Cash. Sewer Wells'Fargo WFSWEEP 31" ;N/A 0.11 645,180.65 .27,597.13 529,043.01 0.00 0.00 143,734.77 .58.22 Sweep Cash• SolidWaste Wells Fargo. WFSWEEP 35: Street N/A 047 546,563.62 231.10 0.00 0.00 0.00 546,794:72 231.10 Sweep Cash Assessment Wells Fargo WFSWEEP 42: Utility N/A. 00.16 13,211;672.34 325;251.34 3,013,703:B6 0.00' '0.00 10,523,219.82 4,873.86 Sweep Cash Impact Fee . Wells Fargo WFSWEEP 43:.Regional N/A- 047 4,033-.64 1.69 :0.00 0.00' 0.00 4,035.33 1: 9. Sweep Cash Detention 44: Shadow Wells Fargo WFSWEEP Creek. N/A 0.17 2,423,859.36 179,223.19 520,757.50 0.00 0.00 2;082,325.05 1,016.19 'Sweep Cash ' Impact 45: Wells Fargo WFSWEEP Hotel/Motel N/A 0.17: 1,325515.50 20;995.81 87;949.32 0.00 0.00 1,256;561.99: '55541 Sweep Cash 'Occupancy Wells Fargo WFSWEEP46: Park 'N/A 0.17 44;141.32 4,753.43 4,454:86 0.00 0.00 44,439.89 19.42 Sweep Cash Donations Page 1'of 6 Amortized Description CUSIP/Ticker Name Date AnnualizedTRR-BV Beginning BV' Buy Principal Sell Principal 'Amortized Premium Ending BV Income-By Portfolio Maturity P �P �PIncome-By 47: Park•& Wells Fargo WFSWEEP Rec N/A 0.17 1,166,315.15 487.79 38,890.62 0.00 0.00 1,127,912.32. 487.79 Sweep Cash Development Wells Fargo WFSWEEP 49:Tree N/A _ 0.17' 6,252.53 2.63: 0,00 0.00: 0.00 6,255.16 2:63 Sweep Cash Trust Fund Wells Fargo WFSWEEP 50: Capital N/A 0.17 3,886,626.97 944,552.84 385,314.78' 0'.00` 0.0.0 4,445,865.03' 1,979.36 Sweep Cash Projects Wells Fargo WFSWEEP 55:Sidewalk. N/A. 0.17 213,139.48 90,11 0.00 0.00 0.00, 213,229.59 90.11 Sweep`Cash Fund, Wells Fargo St::Police Sweep Cash, WFSWEEP State N/A 017 224,425.98. 3,253.72 12,188:6B 0.00' 0:00 215,491:02 92.66 Seizure Wells Fargo WFSWEEP 62: Federal N/A 0.17 24,617.00 10.39 0.00 0.00 0.00 24,627.39 10.39 Sweep`Cash, Police`Fund 64: 1998 Wells Fargo WFSWEEP Cert of N/A 0.17 967,842.68, 402.04 17;562.75. 0.00 0.00` 950,681.97 402.04 Sweep Cash Obligation 67:2003 Wells Fargo WFSWEEP Revenue N/A 0.11 6,229,522.18 866,506,05 209,442.51 0.00 0.00 6,886,585.72 1,726.67 Sweep Cash Bonds 68:2001. Wells Fargo WFSWEEP Cert:of N/A . D.1B, 2,323,748.55; 1,730,446.47 9,317.64. •0.00 0.00 4,044,877.38 1,449.87 Sweep Cash Obligation 70:2005 Wells,Fargo. WFSWEEP Refunding/ N/A . 0.17 9,650,960.79 906,631.26 438,691.71. '0,00 0.00' 10,118,900.34 4,260.13 Sweep Cash Mobility Wells'Fargo WFSWEEP 95':'Property N/A 5.13 60,943.35 158,578.03 110,268.48 0:00 0.00 109,252:90 13.30 Sweep,Cash Liability 97.:. Wells.Fargo WFSWEEP Employee N/A -0,34 34,.197.92- 243,897.05 207,108.20 0.00 0.00 70,986.77 15.74 Sweep Cash Benefit Trust 99:.COP Wells!Fargo WFSWEEP Health. N/A 0.00 0.00 548,542.42 660,846.89 0.00, 0.00 -112,304.47 0:00 Sweep Cash Claims Fund. WeIlsEargo WFSWEEP Z101: Grant 'N/A '0.00 0.00. 17,582.17 24,932.95 0.00 0.00 -7,350.78 0.00 Sweep Cash . Fund Wells Fargo WFS 2007 WFSWEEP N/A 0.13' 187.'44 0.06 0.00 0.00 0.00 187.50 0.06 Sweep'Cash, CDBG Fund' Wells Fargo.• WFSWEEP ZSO6r.2008 N/A 0.00, 0,00 14,283':21 19,076.91 .0.00 0.00 -4,793.70 0.00 Sweep Cash CDBG fund Wells Fargo WFSWEEP Z107: 2009 N/A 0.00, 0.00 5,076.79 14,858,1E 0,00 0..00 -9,781.39 0.00 Sweep.Cash CDBG.!Fund Page.'2'of 6 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 Z108; 2010 N/A 0.00 0.00 .1.00, 9,,825.05. 0:0D 0.00 -9,824.05. 0.00 Sweep Cash CDBG Fund Z116: CDBG Wells Fargo WFSWEEP Recovery N/A 0.00 11,112.67 0.00 0.00 0.00 0.00 11,112.67 0.00 Sweep Cash Fund' Wells:Fargo WFSWEEP 2120: Mgnit N/A 0,17 198,140.21 63.77 0.00 0.00 0.00 198,223.98 '83.77 Sweep Cash District 1, Wells Fargo WFSWEEP Z140: U of H N/A '0:16 43,639.16 31,815.77 50,149.18 0.00 0,00 ,25,305.75 8:86 Sweep Cash Fund Wells Fargo Z150[ Sweep Cash WFSWEEP Hurricane N/A 0.18 0.00 73,986.31. 73,974.96 0,00 0.00 11.35 11.35 IKE Proj Wells Fargo Z200: 2006 Sweep Cash WFSWEEP Cert of N/A 0'.15 4,352,957.82 158,619.54 1,909,315.92' 0.00 0.00 -2,602,261.44 1,052.54 Obligation' Wells Fargo 2201: 2007 Sweep Cash WFSWEEP Cert of N/A 0.17 2,254,869.69 935.73 54,438.24 0.00 0:00 2,201,367.18 935.73 Obligation WellsZ202:,2007A Fargo Sweep Cash WFSWEEP Gen N/A 0.17 3,566,995.11. 770,239.30 1,266,957.25 0.00 0.00 3,070,277.16 1,596.83 Obligation Wells Fargo z203:2009 Sweep Cash WFSWEEP' Gen N/A 0.20 -1,720,714.32 10,137,372.18 2,879,305.04 0.00 0.00 5,537,352.82 3,070.02 Obligation 0S Wells.Fargo WFSWEEP Pay As U G U G Sweep_Cash Go N/A 0.17 1,231,475.08 519.95 1,802.06 0.00 0.00 1,230,192.97 519.95 C1P Sub Total/Average 0.18 72,663,046.81. 37,979,616.86 14,089,383.14 --0.00 0.00 96,553,280.53 37,901.02 Cash• CERTIFICATE OF DEPOSIT 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 1/26/2011 0.40 1,000,000.00 0.00 0.00 '0.00 0.00 1',000,000.o0 1,008.22 1/28/2011 Services Wells Fargo 30e: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 Page 3 of 6 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.40 4,000;000.00 0.00 '0.00 •0.00 0:00' 4,000,000.00 4,032.88 Certificate Of Deposit FHLB BOND FHLB-0.57 3133XV5G2 20: Debt 12/29/2010 0.57 1,000,024.72' 0'.00 1;0'00,000.00 0.00 -24.72 0.00 1,384.45 12/29/2010 Services FHLB 3.25 31331YC24 30: Water& .4/9/2012 0.55 1,041,540.05 0.00 0:00 0.00 •-6,809.84' 1,034,730:21 1,405.44 4/9/2012 Sewer •FHLB 0.57 3133XV5G2 30:Water& 12/29/2010 0.57 1,000,024.72 0:00 1,000',000.00 0:00 -24.72 0:00' 1,384.45 12/29/2010 Sewer FHLB 0.42 3133XYJY2 30: Water&• 2/17/2'011 0.41 1,000;066.70 0.00 0.00 •0.00 -44.30 1,000,022.40 1,017.36 2/17/2011 Sewer FHLB.0.625 3133703Y2 42i Utility 1/12/2012 0.63 1,000,000.00 0.00 0.00. 0.00 .0.00, 1,000,000.00 1,579.86 1/12/2012 Impact Fee FHLB 0.42 3133723B8 42: Utility 4/13/2012 0:40 0.00 1,000,000.00. 0:00 0.00 0,00 1,000,000.00 186.67 4/13/2012 'Impact Fee FHLB 3.25 3133XPCS1, 42:-Utility 3/9/2012 0.50 1,039,856.17 0.00 0:00 0.00 -6,911.47 1,032,944.70 1,303.81 3/9/2012 Impact Fee FHLB 0.4 •50: Capital; 12/20%2011 0.38 0.00 1,000;000.00 0.00 0.00 im01;000;000.00 122.22 12/20/2011-11 3133Z1YD2 projects- FHLB 0.5 50. Capital 10/15/.2010 0.33 1,000,084.99 0.00 1,000,000,00 0.00 --84.99 0.00 123.34 1.0/15/2010 .3133XUX73' ,projects FHLB 0.57 • 3133XV5G2 50: Capital 12/29/2010 -0:37 1,000,515.15 0.00' 1,000,000.00 0.00 -515.15 0.00 894.02 12/29/2010 Projects 68: 2001 FHLB 0.57 3133XV5G2 Certof . 12/29/2010' 0.37 1,000,515.15 0.00 1',000;000:00 0.00' -515.15 0.00 894,02 12/29/2010' Obligation 70: 2005 FHLB 0.42 313372388 Refunding/ 4/13/2012 0.40 0.00 1,000,000.00 '0.00 0.00 0.00 1,000,000.00 186.67 4/13/2012 Mobility 70: 2005 FHLB 3`:75 3133XRY46 'Refunding/ 9/9/2011 0:34 1,032,365.77' 0.00 0:00' 0.00- -8,592:68 • 1,023,773.09 886.49 9/9/2011 Mobility 70: 2005 'FHLB 1:625 3133XTXH4 Refunding,/ 7/27/2011 0.48 1,009,554:65 '0.00 0.00 0.00 ,2,895:35 1,006,659,30 1,212.29 7/27/2011 Mobility 70: 2005 FHLB 0.5 3133XUX-73• Refunding/ 10/15/2010 0.33 1,000,084.99 0.00 1,000;000:00. 0.00 -84.99. 0.00 123. ' 10/15/2010 Mobility Page 4 of 6 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 70FHLB 0.57 Re 2005 12/.29/2010 3133XV5G2 Re 2005 12/29/2010_ 0.37 2;001,030.30 0.00 2,000,000.00 0.00 -1;030.30 0.00 1;788:03 Mobility •FHLB 0.85 Refunding70 din5/4/2011 3133XVLE9 Reg/ 5/4/2011 0.51 1,002,071.57 0.00 0:00 '0:00 -880:90 1,001,190.67 1,267.71 Mobility FHLB Z203: 2009 FHLB 0.4011-11 313371YD2 Gen 12/20/2011 0.38 0.00 1,000,000:00 0.00. 0:00 0.00 1,000,000.00 122.22 Obligation Sub Total/Average 0.46 15,127,734.93 4,000,000.00 8,000,000.00 0.00 -28,414.56 11,099,320.37 15,882.39. FHLB Bond. - FHLMC BOND FHLMC 4.75 10:General 3134A4V]0 1/18/2011 0,34 1,013,390.91 0.00 0.00 0.00 -11,159:09 1,002,231.82 847:85 1/18%2011 Fund FHLMC 1.5 3137EABW8 30: Water'&. 1/7/2011 0.41 1;002,955.03 0.00 0.00 0.00 -2,772.24 1,000,182:79 1,019.43 1/7/2011 Sewer FHLMC_2.875 3137EABVO 42: Utility 11/23/2•010 0.30 1,003,808.47 0.00 1,000,000.00 0.00 -3,808,47 0".00 424.17 11/23/2010 "Impact Fee F Z200: 2006 FHLMC 1.5 1/7/2011 3137EABW8 Certof 1/7/2011 0.41 1,002,955.03 0:00 0.00 .0.00 -2,772.24 % 1;000482.79 1,019.43 Obligation Sub Total/Average, 0.37, .4;023,109.44 0.00 1,000,000.00 0.00 "-20,512:04. 3,002,597.40 3,310.88 FHLMC Bond FNMA BOND FNMA 1.08- 3139BAK50 10: General 3/30/2012 1.07 0.00 1,009,046.00 0.00 D.00 -403.91 1;008,636.09 646.09 3/30/2012 Fund FNMA 1.375 10: General 4/28/2011 D:54 1,004,892.47 0:00 0.00 0.00 2,140:45 1,002,752.02 1,335.24 ' 4/28/2011 31398AWQ1" Fund FNMA 1.375 20: Debt 31398AWQ1 4/28/2011 '0.54 1,004,492.47 0:00 0:00 ,0.00 -2,140.45 1,002,752.02 '1,335.24 4/28/2011 Services •FNMA 1.08 30: Water& 31398AK50 3/30/2012 1.07 0.00 1,009;040.00 0:00 0.00 403:91 1,008,636.09 646.09 Sewer Sub' Total/Average. 0.64 2,009,784.94. 2,018;080.00 . 0.00 .0.00 5,088.72. 4;022,776.22 3,962.66 "FNMA Bond MONEY MARKET Page 5'of 6 • .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 99: COP Wells Fargo MM WF9871 Health N/A 0.05 0.00 978,941.82' 747,097.32 0.00 '0.00 231,844.50 21.82 Claims Fund • Sub Total/Average, 0.05 0.00 978,041.82 747,097.32. 0.00 0.00 231,844.50 21.82' Money Market Total / 0.24 97,823,676.1.2 44,976,638.68 23,83.6,480.46. 0.00 54,015.32 118,909;819.02 65,111:65 Average Page 6of6 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 12/31/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 N/A 5/31/2006 N/A 0.17000 11,627,874.49 11,627,874.49 11,627;874.49 11,627,874.49 1 N/A. 9:79 Sweep Cash Fund 17: Wells Fargo WFSWEEP Municipal 5/31/2006 N/A 0.17000 133,847.97 133,847.97 133,847.97 133,847.97 1 ,N/A 0.11 Sweep Cash Court Security Wells Fargo Wi City W Wells Cash WFSWEEP Wide 5/31/2006 N/A 0.17000 45,722.85- 45,722.85 45,722.85 45,722.65 1 N/A 0.04 Donation Wells Fargo WFSWEEP 19:Court 5/31/2006 N/A 0.17000 194,20732 194,207.12 194,207.12 194,207.12 1 N/A 0.16 Sweep Cash Technology Wells Fargo WFSWEEP 20: Debt 5/31/2006 N/A 0.17000 16,675,299.54 16,675,299.54 16,675,299.54 16,675,299.54_ 1 N/A 14.04 Sweep Cash Services 23: Court Wells Fargo WFSWEEP Juvenile 9/1.5/2009 N/A 0.17000 12,208.09 12,208.09 .12,208:09 12,208.09. 1 N/A 0.01 Sweep Cash Mgmt Wells Fargo WFSWEEP 30:Water& 5/31/2006 N/A 0.17000 10,314,104.88 10,314,104.88 10,314,104.88 10,314,104.88 '1 N/A 8.68 •Sweep Cash Sewer Wells Fargo WFSWEEP' 31' 12/1/2006 N/A 0.17000 143,734.77 143,734.77 143,734.77 143,734.77 1 N/A 0.12 Sweep Cash Solidwaste Wells Fargo WFSWEEP 35: Street 5/31/2006 N/A 0.17000 546,794 72 546,794.72 546,794.72 546,794.72 1 N/A 0:46 Sweep Cash: Assessment Wells Fargo WFSWEEP 42: Utility 5/31/2006 N/A 0.17000 10,523,219.82 10,523,219.82 10,523,219.82 10,523,219.82 1 N/A 8.86 Sweep Cash Impact Fee Wells Fargo WFSWEEP 43; Regional 5/,31/200fi N/A 0.17000 4,035.33 4,035.33 4,035.33 4,035.33 1 N/A 0.00 Sweep Cash. Detention Wells Fargo 44:'Shadow Sweep Cash WFSWEEP Creek 5/31/2006 N/A 0.17000 2,082,325.05 Z;082;325.05 2;082;325.05 2,082,325.05 2,082,325,05 1 N/A 1:75 Impact Wells Fargo 4 06 Sweep Cash WFSWEEP Hoo: tel/Motel 5/31/2006 N/A. '0.17000 1,258,561.99 1;258;561:99 1,258,561.99 1;258;561:99 1 N/A 1. Occupancy Wells Fargo WFSWEEP 46; Park 5/31/2006 'N/A 0.17000 44,439.89 44,439.89 44,439.89 44,439.89 1 N/A 0.04' 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 47Wells Fargo, Re Park& Wells WFSWEEP' Rec 5/31y2006 N/A 0.17000 1,127,912.32 1;127,912:32 1,127;912.32 1,127,912.32 1 N/A 0.95 Sweep Development Wells Fargo WFSWEEP 49:Tree 5/31/2006 N/A 0:17000 6;255.16 6,255.16 6,255.16 6,255.16 1 N/A 0.01 Sweep Cash Trust Fund Wells Fargo WFSWEEP 50:'Capital 5/31/2006 N/A 0.17000 4,445,865.03 4,445,865.03 4,445,865.03; 4,445,865.03 1 N/A 3:74 Sweep Cash. Projects, Wells Fargo WFSWEEP' 55:Sidewalk 5/31/2006 N/A .0.17000 213,229.59 ,213,229.59 213,229.59 213,229.59 1 N/A 0.18 Sweep Cash Fund 60Wells.Fargo State llce Sweep Cash WFSWEEP State 5/31/2006 N/A '0.17000 215,491.02 215,491.02 215,491:02 215,491.02 1 N/A 0:18 Seizure Wells Fargo WFSWEEP 62:.Federal. 5/31/2006 N/A 0.17000 24,627.39 24,627.39 24,627.39 24,627.39 1 N/A 0.02 Sweep Cash Police Fund Wells Fargo 64: 1998 Sweep Cash WFSWEEP 'Cert of 5/31/2006 N/A 0.17000 950,681.97 950,681:97' 950,681.97 950,681.97 1 N/A 0.80 Obligation67 ' Wells Fargo Rev 2003 Sweep Cash- WFSWEEP Revenue 5/31/2006 N/A 0.17000 6,886,585.72 6,886,585.72 6,886;585.72 6,886,585.72 1 N/A" 5.80 Bonds Wells Fargo C8: 2001 Sweep Cash WFSWEEPCart of 5/31/2006 N/A .0.17000 4,044,877.38 4,044,877.38 4,044,877.38 4,044,877.38 1 N/A. 3.41 Obligation. Wells Fargo 7Re:2005 Sweep Cash WFSWEEP �Refunding7 5/31/2006' N/A 0.17000 10,118,900.34 10,118;900.34 10,118;900:34 10,118,900.34 1 N/A 8;52 Mobility Wells Fargo WFSWEEP 95; Property 10/31/2006 N/A 0:17000 109,252.90 109;252.90 109,252.90 109,252.90 1 N/A 0.09 Sweep Cash Liability Wells Fargo- E7, Sweep Cash WFSWEEP Employee 9/1/2007 N/A 0.17000 70;986.77 70,986.77 70,986,77 70,986.77 1 N/A .0:06 Benefit Trust Wells Fargo WFSWEEP Health 9/15/2010 'N/A 0.17000 -112,304.47, -112,304.47 -112,304:47 -112,304.47 1 N/A -0.09 Claims'Fund Wells Fargo• WFSWEEP Z101:'Grant 5/31/2006 N/A 0.17000 -7,350.78 -7,350.78 -7,350.78 -7,350.78 1, N/A -0.01 Sweep Cash Fund Wells Fargo, WFSWEEP Z105:'2007 5/1/2007 N/A. 017000 187:50 187:50 187:50 187.50 1 N/A 0.00 Sweep Cash CDBG Fund Wells Fargo' WFSWEEP Z106:,2008 3/15/2009' N/A 0.17000 -4,793.70' -4,793.70 -4,793.70 -4,793.70 1 N/A 0.00' Sweep Cash CDBG Fund WellepCa Fargo WFSWEEP 2107' 2009 11/1/2009 N/A 0.17000 -9,781.39 -9,781.39 -9,781.39 -9,781.39 1 N/A -0.01 Sweep sh CDBG Fund Page 2 of 5 Portfolio Settlement Maturity YTM @, Face Days To Accrued °/n of Description CUSIP/Ticker Name Date Date Cost Amount/Shares :Cost Value. Book Value Market Value Maturity Interest Portfolio Wells Fargo WFSWEEP 2108:2010 11/1/2010 N/A 0.17000 -9,824.05 -9,824.05 -9,824.05 -9,824.05 1 N/A -0.01. Sweep Cash CDBG Fund Wells Fargo Z116:'CDBG, Sweep Cash WFSWEEP Recovery 7/31/2009 N/A 0.17000 11,112.67 :11,112.67 11,112.67 11,112.67' 1 N/A 0.01 Fund Wells Fargo WFSWEEP Z120: Mgmt. 12/31/2007 N/A. .0.17000 198,223.98 198,223.98 198,223.98 198,223.98 1 N/A 0.17 Sweep Cash District 1 Wells Fargo WFSWEEP Z140: U of H 12/1/2009. N/A 0.17000 25,305.75 25,305.75 25,305.75 25,305.75 .1 N/A 0.02. Sweep Cash Fund Wells Fargo H150c Sweep Cash WFSWEEP Hurricane 10/31/2008 N/A 0.17000 11.35 11i35 11.35 11.35 1 N/A 0.00 IKE Proj Wells Fargo Z200: 2006 Sweep Cash WFSWEEP Cert-of 6/30/2006 N/A 0.17000 2,602,261.44 2,602,261.44 2,602,261.44. 2,602,261.44 1 N/A 2.19' Obligation Wells Fargo 2201•: 2007 Sweep Cash. WFSWEEP Cert of 8/31/2006 N/A. 0.17000 2,201,367.18 2,201,367.18 2,201,367.18 2,201,367.18 1 N/A 1.85 Obligation Wells Fargo Z202; 2007A Sweep Cash WFSWEEP Gen 12/31/2007 N/A 0.17000 3,070,277.16 3,070,277.16 3,070,277.16 3,070,277.16 1 N/A 2.58' Obligation Wells.Fargo 2203:'2009 Sweep Cash WFSWEEP 'Gen 10/30/2008 N/A 0.17000 5,537,352.82 5,537,352.82 5,537,352.82 5,537,352.82 1 N/A 4.66 Obligation. Wells.Fargo. Z301:'W/S Sweep Cash WFSWEEP Pay As U Go 12/31/2007 N/A 0.17000 1,230,192.97 1,230,192.97 1,230,192.97 1,230,192,97 1 N/A 1.04 CIP Sub Total/ 0.17000 96,553,280.53. 96,553,280.53 96,553,280.53 96,553,280.53 1 .0.00 81.28 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 28 3,693.15 0.84 1/28/2011 Wells Fargo' 20: Debt Bank 0.4 CD7579071205 1/28/2010 1/28/2011 0.40000 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 28 3,693.15 .0.84 1/28/2011 Services Wells Fargo Bank 0:4 CD7579071 30: Water&205 1/28/2010' 1/28/2011 0.40000 1,000,000.00 1,000,000.00 1,000,000,00 1,000,000:00 28 3,693.15 0,84 1/28/2011 Sewer Wells Fargo Bank 0.4 -CD75 42: Utility 1/28/2010 1'/28/2010 1/28/2011 0.40000 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 28 3,693.15 0.84 1/28/2011 Impact Fee Page 3'of 5 Portfolio Settlement Maturity YTM @ Face Days•To Accrued, %of Description. CUSIP/Ticker Name Date •Date , Cost Amount/Shares Cost Value Bobk Value Market Value Maturity Interest Portfolio Sub Total/ 0.40000 4,000,000.00 4,000,000.00 4,000;000.00 4,000,000.00 28 14,772.60 3.37 Average ••FHLB Bond FHLB 3.25 31331YC24 30:Water 8f. 8/31/2010 4/9/2012 .0.50658 1,000;000:00 1,043,810:00 1,034,736.21 1,034,973:00 465 7,402.78' 0.84 4/9/2012 Sewer FHLB 0.42 30: Water& 2/17/2011 3133XY3Y2 Sewer 5/20/2010' 2/17/2011 0.40241 1,000,000.00 1,000,130.00 1;000,022.40 1,000,286:00 48 2,613:33 0.84 FHLB 0.625 3133703Y2 4Z: Utility 7/9/2010 1/12/2012 0.62500 1,000,000,00 1,000,000.00 1,000,000.00 1,002,216'.00 377 2,986.11 0.84' 1/12/2012 .Impact Fee FHLB 0:42 3133723B8 42:'UUlity 12/15/2010 4/13/2012 0.42000 1,000,000.00 1,000,000.00 1,000,000.00 999,389.00 469 186.67 0.84 4/13/2012 Impact Fee' •FHLB 3.25, 3133XPCS1 42. Utility 0: 8/31/2010 3/9/2012 146722 1,000,000.00 1,042,160.00 1,032,944.70 1,032;985.00 434 10,111.11 0.84 3/9/201.2 'Impact Fee FHLB 0.4 50 Capital '12/20/2011 313371YD2 projects 12/20/2010 12/20/2011, .0.40000 '1,000,000.00 1,000,000.00 1,000,000.00 999,200.00 354 122:22 0.84 -11 FHLB 0.42 70:2005 4/13/2012 313372388 Refunding/ 12/15/2010 4/13/2012 0.42000 1,000,000.00 1,000,000.00 1,000,000.00 999,389.00 469 186.67 0:84 Mobility FHLB 3.75 70: 2005 9/9/2D7 3133XRY46' Refunding/ 8/31/2010 9/9/2011 0.29579 1,000,000.00 1,035,230.00 1,023;773.09 1,023,068.00• 252 11,666.67 0.84. Mobility FHLB 0.85 70: 2005 5/4/2D 8 3133XVLE9 Refunding/ 5/20/2010 5/4/2011 0.50023 1,000,000 00 1,003,330.00 1,001,190.67 1,002,331.00 124 1,345.83 0.84 Mobility FHLB 1:625. . 70: 2005 FHLB/2011 3133XTXH4 Refunding./ 6/30/2010 7/27/2011 0.46257 1,000,000.00 1,012,450.00 1,006,659:30 1,007,317.00" 208 6,951.39 0:84 Mobility FHLB 0.4 Z263: 2009 12/20/2011 313371YD2 Gen ' 12/20/2010 '12/20/2011 •0.40000 1,000,000.00' 1,000,000.00 1,000,000.00 999,200.00 354 12222 0.84 •-11 Obligation Sub Total/ 0.44544" 11,000,000.00 11,137,110.00 11,099,320.37 11,100;354.00 323 43;695.00 9.26 Average FHLMC•Bond FHLMC 4.75 10: General 1/18/2011 3134A4V30 Fund 6/30/2010 1/18/2011 0.27956 .i,000,000:00 1,024;550.00 1,002,231.82. 1,001,776.00 18. 21,506.94 0.'84' FFiLMC.1.5 30:Water& 1/7/2011. 3137EABW8 Sewer 4/16/2010 1/7/2011 0.40039 1,000;000f06 1,007,951.16 110.00;182.79 1000,110.00 7 7,250.00 0.84. 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 Z200: 2006 FHLMC1., 3137EABW8' Cert.of 4/16/2010 1/7/2011 0.40039 1,000,000.00 1,007,951.16 1,000,182.79 1,000,110.00 7 7.,250.00 0.84 • • Obligation Sub Total/ '0.36011 3,000,000.00 :3,040,452.32 3,002,597.40 3,001,996.00 11 36,006.94 2.53 Average FNMA Bond. FNMA 1.08 10:.General 3/30/2012 31398AK50 Fund 12/10/2010 3/30/2012 0.38504 1,000,000.00 1,009,040.00 1,008,636:09 1,006,920.00 455 3,150.00 0.84 FNMA 1.375 31398AWQ1 10:.General 4/16/2010 4/28/2011 0.52481 1,000,000.00, 1,008,750:00 1,002,752.02 1,003,844.00. 118 2,406.25 0.84 4/28/2011 Fund FNMA 1.11 31398AWQ1 20: Debt 4/16/2010 4/28/2011 0.52481 1,000,000.00 1;008,750.00 1,002,752:02 1,003,844.00 118 2,406.25 0.84. 4/28/2011 Service's FNMA 1.08 31398AK50 30:Water& 12/10/2010 3/30/2012 0.38504 1,000,000.00 1,009,040.00 1,008,636.09 1,006,920:00 .455 3,150.00 0.84 3/30/2012 Sewer Sub Total/ 0.45493 4,000,000.00 4,035,580.00 4,022,776.22 4,021,528.00 286 11,112.50 3:37 Average Money Market Wellso Fargo' 99:.COP M WF9871 Health' 10/1/2010 N/A 0.17000 231,844.50 231,844.50 231,844.50. 231,844.50 1 N/A 0.20 MClaims Fund Sub Total/ 0.17000 231,844.50 231,844.50 231,844.50 -231,844.50 1 0.00 0.20 Average Total / 0.21765 118,785,125.03 118;998,267.35 118;909,819.02 118,909;003.03 42 105,587.04 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 12/31/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 11,627,874.49 11,627,874.49 11,627,874.49 0.17000 N/A 1 9.79 'Cash' Wells Fargo Bank 0.4 Certificate Of 1/28/2011 CD7579071205 Deposit 1/28/2010 1,000,000.00 1,000,000.00 L000,000.00 0.40000 1/28/2011 28 0.84 FHLMC.4.75 3134A4V30 FHLMC Bond 6/30/2010 1,000,000.00 1,002,231.82 1,001,776.00 0.27956 1/18/2011 18 0.84 1/18/2011 FNMA 1.08.3/30/2012 31398AK50 FNMA Bond 12/10/2010 1,000,000.00 1,008,636.09 1,006,920.00. 0.38504 3/30/2012' 455 0.84 FNMA 1;375 31398AWQ1 FNMA Bond 4/16/2010 1,000,000.00 1,002,752.02 1,003,844.00 0:52481 4/28/2011 118 0.84 4/28/2011 . Sub Total/Average 15,627,874.49 15,641,494.42 15,640,414.49 0.22819 40 13.16 17: Municipal Court Security Wells.Fargo Sweep WFSWEEP Cash 5/31/2006 133,847.97 ,133,647.97 133,847.97 0.17000 N/A 1 • 0.11 Cash Sub Total/Average 133,847.97 133,847.97 133,847.97 0.17000 1 0.11 18:•City Wide Donation Wells Fargo Sweep: WFSWEEP •Ca§h 5/31/2006 45,722.85 45;722.85 45,722.85 0.17000 N/A 1 0.04 Cash. Sub Total.'/Average 45,722.85 - 45,722:85 45,722.85 0117000 1 0.04 .19:Court Technology Wells Fargo Sweep WFSWEEP Cash 5/31/2006 194,207.12 194,207.12 194,207.12 0.17000 IV/A 1 0.16 Cash. Sub Total/Average 194,207.12 194,207.12 194,207.12 0.17000 1 0.16 20: Debt Services Wels•Fargo Sweep WFSWEEP Cash 5/31/2006 16,675,299.54 16,675,299.54, 16,675,299.54 0.17000 N/A 1 14.04 Cash Wells Fargo.Bank 0.4 Certificate Of 1/28/2011 CD7579071205 Deposit 1/28/2010 1,000,000.00 1,000;000.00 1,000,000.00 0.40000. 1/28/2011 28 0.84 Page 1 of 7 Settlement 'Face YTM,@ Maturity Days To %of Description CUSIP/Ticker Security Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio FNMA 1.375, 31398AWQ1 FNMA•Bond .4/16/2010, 1,000;000.00 1;002;752.02 1,003,844.00' 0:52481 4/28/2011 118 0.84 4/28/2011- Sub Total'/Average' 18,675,299.54. 18,678,051.56 18,67.9,143.54 0.20131 9 15'.72 23:Court Juvenile Mgmt Wells Fargo Sweep WFSWEEP Cash 9/15/2009 12,208.09 12,208.09 12,208.09 0.17000 N/A. 1 0.01 Cash Sub Total./Average 12,208.09 12,208.09 12,208.09 0.17000 1 0.01 30:Water&Sewer Wells Fargo Sweep WFSWEEP Cash 5/31/2006 10,314,104.88 10,314,104.88 10,314,104.88 0.17000 N/A 1 8.68, Cash Wells Fargo Bank 0.4 Certificate Of 1/28/2011 CD7579071205 Deposit 1/28/2010 1,000,000.00 1,000,000.00 1,000,000.00 0:40000 1/28/2011 28 0.84 FHLB 3.25 4/9/2012 31331YC24 FHLB Bond 8/31/2010 1,000;000:00 1,034,730.21 1,034,973.00- 0.50658 4/9/2012 465 0.84. FHLB 0.42 2/17/2011 3133XY3Y2 FHLB Bond' .5/20/2010 1,000,000.00 1,000,022.40 1,000,286.00 0.40241 2/17/2011 48 0.84 FHLMC,1,5 1/7/2011 3137EABW8 FHLMC Bond 4/16/2010 1,000,000.00 1,000,182.79 1,000,110.00 0.40039 1/7/2011 7 0.84 FNMA1:08 3/30/2012 31398AK50 FNMA,Bond 1-2/10/2010 1,000,000.00 1,008,636.09 1,006,920:00 0.38504 3/30/2012 455 0.84 'Sub Total/'Average 15,314,104.88 15,357,676.37 15,356,393.88 0.25126 66 12.89 31:'Solidwaste Wells Fargo Sweep WFSWEEP 'Cash 12/1/2006 143,734.77 143,734.77 143,734.77 0.17000 N/A. 1 0.12 Cash Sub Total]Average 143,734.77 143,734.77 143,734.77 0.17000 1 0:12 35:Street Assessment Wells Fargo Sweep WFSWEEP•, Cash 5/31/2006 .546,794.72 546,794.72 546,794.72 0.17000 N/A 1 0.46 Cash Sub Total/'Average 546,794.72' 546,79.4.72 546;794.72 0.17000' 1 0.46 42:UtilityImpact Fee Wells Fargo Sweep WFSWEEP Cash 5/31/2006 10,523,219.82 10,523,219.82 10,523,219.82' .0.17000 N/A 1 8.86 -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 28 ,084 1/28/2011 Deposit Page 2 of 7 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.625. 31'33703Y2 FHLB Bond 7/9/2010 1,000,000.00 1,000,000.00 .1,002,Z16.00 0.6250D. 1/12/2012 377 0.84 1/12/2012 FHLB 0.42 4/13/2012 313372388 FHLB Bond 12/15/2010 1,000,000.00 1,000,000.00 999,389.00 0.42000 4/13/2012 469 0.84 FHLB 3.25.3/9/2012 3133XPCS1 FHLB Bond 8/31/2010 1,000,000.00 1,032,944.70 1,032,985.00 0.46722 3/9/2012 434 0.84 Sub'Total`/Average 14,523,219.82 14,556,164.52' 14,557,809.82 0.25484 91 12.23 43:Regional Detention Wells Fargo Sweep WFSWEEP Cash 5/31/2006 4,035.33 4,035.33 4,035.33 0.17000. N/A 1 0.00 Cash Sub Total/Average 4,035.33 4,035.33 4,035.33 0.17000 1 0.00 44:Shadow Creek'Impact Wells Fargo Sweep WFSWEEP Cash 5/31/2006 2,082,325.05 2,082,325.05 2,082,325.05 0.17000 N/A 1 1.75 Cash Sub Total /Average 2,082,325.05 2,082,325.05 2,082,325.05 0.17000 1 1.75 45: Hotel/Motel Occupancy Wells Fargo Sweep WFSWEEP Cash 5/31/2006 1,258,561.99 1,258,561.99 1,258,561.99 0.17000 N/A 1 1.06 Cash Sub Total /Average 1,258,561.99 1;258,561.99 1,258,561.99 0.17000 1' 1:06 46:Park Donations Wells Fargo Sweep WFSWEEP Cash '5/31/2006 44,439.89 44,439.89 44,439.89 0.17000 N/A 1 0.04 Cash Sub Total/Average 44,439.89 44,439.89 44,439.89 0.17000 1 0.04 47:Park&Rec Development Wells Fargo Sweep WFSWEEP Cash `5/31/2006 1,127,912:32 1,127;912.32 .1,127,912.32 0.17000 N/A 1 0.95 Cash • Sub'Total./Average 1,127,912.32 1,127,912:32 1,127;912.32 0.17000 1. 0.95 49:TreeTrust Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 6,255.16 6,255.16 6,255.16 0.17000' ' N/A 1 0.01 Cash 'Sub Total /Average 6,255.16 6,255.16 6,255.16 0.17000 1 0.01 50:'Capital Projects Page 3 of 7 Settlement Face YTM @ Maturity 'Days To %of Description CUSIP/Ticker Security Type Date Amount/Shares Book Value Market Value Cost Date Maturity •Portfolio INeIIs:Fargo•Sweep WFSWEEP Cash 5/31/2006 4,445,865.03 4,445,865.03 4,445,865:03 0.17000 N/A• 1 3.74 Cash FHLB 0.4 12/20/2011 313371YD2' FHLB-Bond 12/20/2010 1,000,000.00 1,000,000.00 999,200.00 0.40000 12/20/2011 354 0.84 -11 'Sub Total•./Average 5,445,865.03 5,445,865.03. 5,445,065.03 0.21223 66 4.58 55:Sidewalk Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 213,229.59 213,229.59 213,229.59 0.17000 N/A 1 0.18 Cash Sub Total/Average 213;229.59 213,229.59 213;229.59 0:17000 1 0.18 60: Police State Seizure Wells-Fargo Sweep WFSWEEP Cash 5/31/2006 215,491.02 215,491.02 215,491.02 0.17000 N/A 1 0.18 Cash Sub Total/Average 215,491.02 215,491.02 215,491.02 0.170.00 1 0.18 62:.Federal Police Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 24',627.39 24,627.39 24,627.39 0.17000 N/A 1 0.02 Cash Sub Total /Average 24,627.39 24,627.39 24,627.39 0,17000 1 0.02 64: 1998 Cert of Obligation• Wells Fargo Sweep WFSWEEP Cash 5/31/2006 950,681.97 950,681.97 950,681.97 0.17000 N/A 1 0.80 Cash Sub Total/Average 950,681.97 ,950,681.97 950,681.97 0.17000 ' 1 0.80 67: 2003 Revenue Bonds Wells Fargo Sweep WFSWEEP Cash 5/31/2006 6,886,585.72 6,886,585.72 6,886,585.72 0.17000 N/A 1 5.80 Cash Sub Total/Average. 6,886,585.72 6,886,585.72 6;886,585.72 0.17000 1 5.80 68:2001'Cert of Obligation Well's Fargo Sweep: WFSWEEP Cash 5/31/2006 4,044,877.38' 4;044,877.38 4,044,877.38 .0.17000. N/A 1 3.41 .Cash • Sub Total,/Average 4,044,877.38 4,044,877.38 4,044,877.38 0.17000 1 3.41 70: 2005 Refunding/.Mobility Page 4 of 7 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 10,118,900.34 10,118,900.34 10,118,900.34 0.17000 N/A 1 8.52 Cash FHLB 0.42 4/13/2012 313372368. :FHLB Bond 12/15/2010 1,000,000.00• 1,000,000.00 999,389.00 0'.42000 .4/13/2012' 469 0.84 FHLB 3.75 9/9/2011 .3133XRY46 FHLB Bond :8/31/2010 1,000,000.00 1,023,773.09 1,023,068.00 0.29579 9/9/2011 252 0.84 FHLB 0.85 5/4/2011 3133XVLE9 FHLB Bond 5/20/2010 1,000,000.00 1,001,190.67 1,002,331.00 0.50023 5/4/2011 124 0.84 FHLB 1,625 3133XTXH4 FHLB Bond 6/30/2010 1,000,000.00 1,006,659.30 1,007,317.00 0.46257 7/27/2011 208 ,0.84 7/27/201.1 Sub Total/Average 14,118,900.34 14,150,523.40 14,151,005.34 0:24073 75 11.89 95: Property Liability Wells Fargo Sweep WFSWEEP' Cash 10/31/2006 109,252.90 109,252.90 109,252.90 0.17000 N/A 1 0.09 Cash Sub Total/'Average 109,252:90 109,252.90 109,252.90 0.17000 1 .0.09 97: Employee Benefit Trust Wells Fargo Sweep WFSWEEP Cash 9/1/2007 70,986.77 70,986.77 70,986.77 0.17000 N/A 1 0.06 Cash Sub Total /Average 70,986.77 70,986.77 70,986.77 0.17000 1 0.06 99: COP Health Claims Fund Wells Fargo Sweep WFSWEEP Cash 9/15/2010 -112,304.47 -112,304.47 -112,304.47 0.17000 N/A 1 -0.09 Cash Wells Fargo MM WF9871 Money Market 10/1/2010 231,844.50 231,844.50 231,844.50 0.17000 N/A 1 0.20 Sub Total,/Average 119,540.03 119;540.03 119,540.03 0.17000 1 0.10 Z101:Grant Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 -7,350.78 -7,350.78 -7,350.78 0.17000 N/A 1 -0.01 Cash Sub Total/Average -7,350.78 -7,350.78 -7,350.78 0.17000 1 -0.01 Z105: 2007 CDBG Fund Wells Fargo Sweep WFSWEEP Cash 5/1/2007 187.50 187:50 187.50 0.17000 N/A 1 0.00 Cash Sub.Total/Average 187.50 187.50 " 187.50 0.17000 1 0.00 Z106: 2008 CDBG Fund Page 5 of 7 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 3/1'5/2009 -4,793.70 -4,793.70 -4,793.70 0.17000 N/A 1 0.00 Cash Sub Total,/Average -4,793.70 -4,793.70 -4,793.70' 0.17000 1 0.00 Z107:2009 CDBG Fund Wells Fargo Sweep WFSWEEP Cash 11/1/2009 -9,781.39 -9,781.39 -9,781.39 0.17000 N/A 1 -0.01 Cash Sub Total/Average -9,781.39 -9,781.39 -9,781.39 0.17000 1 -0.01 Z108:2010 CDBG Fund Wells Fargo Sweep WFSWEEP Cash 11/1/2010 -9,824.05 -9,824.05. -9,824.05 0.17000 N/A 1 -0.01 Cash Sub Total/•Average -9,824.05 -9,824.05 -9,824.05 0.17000 1 -0:01 Z116:CDBG Recovery Fund Wells Fargo Sweep WFSWEEP Cash 7/31/2009. 11,112.67 11,112.67 11,112:67 0.17000 N/A 1 0.01 Cash Sub Total /Average 11,112.67 11,112.67 11,112.67 0.17000 1 0.01 Z120:Mgmt.District 1 Wells Fargo Sweep WFSWEEP Cash` 12/31/2007 198,223.98 198,223.98 198,223.98 0.17000 N/A 1 0.17 Cash: Sub Total /Average 198;223.98 198,223.98 198,223.98 0:17000 1 0:17 Z140:U of H Fund Wells Fargo Sweep WFSWEEP Cash 12/1/2009• 25,305.75 25,305.75 25,305.75 0.17000 N/A 1 0.02 Cash Sub Total/Average. 25,305.75 25,305.75 .25,305.75 0.17000 1 0.02 Z150:Hurricane IKE Proj Wells Fargo Sweep WFSWEEP Cash 10/31/2008 11.35 11.35 11.35 0.17000 N/A 1 ,0.00 Cash 'Sub Total %Average 11.35 11.35 11.35 0.17000 1 0.00 Z200:2006 Cert of Obligation Wells Fargo Sweep ,WFSWEEP Cash 6/30/2006 2,602,261.44 2,602,261.44 2,602,261.44 0.17000 . N/A 1 2:19 Cash Page 6 of 7 Settlement Face YTM @ M'aturity Days,To %:of Description CUSIP/Ticker ,Security Type Date Amount/Shares Book Value Market Value Cost Date " Maturity Portfolio FHLMC 1.5 1/7/2011 3137EABW8 FHLMC Bond 4/16/2010 1,000,000.00 1,000,182.79 1,000,110.00- 0.40039 1/7/2011 7 0.84 Sub Total/Average 3,602,261.44 3,602,444.23 3,602,371.44 0.23396 3 3.03 Z201,2007 Cert,of Obligation Wells Fargo Sweep. WFSWEEP Cash 8/31/2006 2,201,367.18 2;201,367.18. 2,201,367.18 0.17000 N/A 1 1.85 'Cash Sub Total/Average 2,201,367.18 2,201,367.18 2,201,367.18 0.17000 1 1.85 .Z202: 2007A Gen Obligation Wells Fargo Sweep WFSWEEP Cash 12/31/2007 3,070;277:16 3,070,277.16 .3,070,277.16 0.17000 N/A 1 2.58 Cash Sub Total/Average 3,079,277.16 3,070,277:16 3,070,277.16 0.17000 1 2.58 Z203:2009 Gen Obligation Wells Fargo Sweep WFSWEEP Cash, 10/30/2008 5,537,352.82 5,537;352.82 5,537,352.82 0.17000 N/A 1 4.66 Cash FHLB 0.4 12/20/2011' 313371YD2 FHLB Bond 12/20/2010 1,000,000.00 1,000,000.00 999,200.00 0.40000 12/20/2011 354 0.84 -11 Sub Total /Average 6,537,352.82 6,537,352.82 6;536,552.82 0.20518 55 5.50 Z301:W/S Pay As U Go CIP Wells Fargo-Sweep WFSWEEP Cash 12/31/2007 1,230,192.97 1,230,192.97 1,230,192.97 0.17000 N/A 1 1.04 Cash Sub Total/Average 1,230,192.9.7 1,230,192.97 1,230,192.97 0.17000 1 1.04 Total/ Average 118,785,125.03 118,909,819.02 118,909,003:03 0.21765 42 . 100 Page 7 of 7 City of,Pearland, Purchases Portfolio/Report Group:Report Groupr Pearland From 9/30/2010 To 12/31/2010 Settlement •Maturity Purchase Face YTM© Portfolio Name Description CUSIP/Ticker Action Date Date Price Amount/Shares Cost Principal Interest/Dividends Broker/Dealer 10:,General Fund FNMA.1.08 31398AK50 Buy 12/10/2010; 3/30/2012 100'.904 1,000,000.00 0.38504' 1,009,040.00 2,100.00 Duncan Williams 3/30/2012 30:'Water& FNMA i.08• 31398AK50 Buy 12/10/2010 3/30/2012 100.904 1;000,000.00 0.38504' 1;009,040.00 2,100.00 Duncan Williams Sewer 3/30/2012 42: Utility Impact FHLB 0:42 3133723B8. Buy 12/1'5/2010' 4/13/2012 100 1;000,000.00 0.42000 1,000,000.00 0.00 Coastal Fee 4/13/2012 Securities 50: Capital FHLB 0.4 313371YD2 Buy . 12/20/2010 12/20/2011 100 1,000,000.00 0.40000 1,000,000.00 0.00 Duncan Williams Projects 12/20/2011-11 70: 2005 FHLB 0.42 Coastal Refunding./ 4/13/2012 Securities Buy 12/15/2010 4/13/2012 100. 1,000;000.00' 0.42000 1,000,000.00 0.00 Securities Mobility Z203:'2009 Gen FHLB 0:4 313371YD2 Buy 12/20/2010 12/20/2011 100 1,000,000.00 0.40000 1,000,000.00 0.00 Duncan.Williams Obligation, 12/20/2011-11 Page 1 of-1 Pledged Collateral Reconciliation Report December 31, 2010 Bank Account Number Account Name Amount: Wells Fargo .201-0419505 Operating $Wells,Fargo 201-0419513 Payroll Fund Wells Fargo 001-3042841 'Sweep Account 103,938,712.56 Wells Fargo. 201-0419554 98 CO Escrow - Wells Fargo -807-1613395 Credit Card Account 1,053,072.09. Wells Fargo 818=4567843 Alvin ISD 5,259,089.88. Wells Fargo 001-30431 1 2 PEDC Sales Tax Wells Fargo 280-7409871 Health Claims 231,844.50 Wells Fargo Wells Fa .40.01128/11 Certificate of Deposit 4,000,000.00 Total of Bank Balances $ 114,482,719.03 Pledged Collateral for City 122,693,978.03 FDIC Insurance 250,000.00 Total Collateral $ 122,943,978.03 Over(Under) Collateralized $ 8,461,259.00 Total % Collateralized 107.4% Bank Account Number Account Name 0 Wells Fargo 100-7284258 Development Authority 1,483,510:40. Total of Bank Balances $ 1,483,510.40 Pledged Collateral for DAP 2,057,670.14 FDIC Insurance 250,000.00 Total Collateral $ 2,307,670.14 Over(Under)Collateralized $ 824,159.74 Total.%Collateralized 155.6% Total$-Over(Under) Collateralized $ 9,285,418.74 Total %Collateralized 108.0% Status .Collateralized I:\Investments\Investment Reports\City of Pearland\Investment Report-City-Qtr 1210