Loading...
R2010-056 - 2010-04-26 RESOLUTION NO. R2010 -56 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS, ACCEPTING THE CITY'S INVESTMENT REPORT FOR THE QUARTER ENDING MARCH 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 March 2010. PASSED, APPROVED, AND ADOPTED this 26 day of April, A.D., 2010. TOM REID MAYOR ATTEST: .t 4 '°max Y NG C ar Y SE ETARY /1,1F 11411.00S° APPROVED AS TO FORM: DA RIN M. COKER CITY ATTORNEY e - r . �. City ®f Pearland m. ' \=� = Quarterly Investment Report 'PEARL/AN{ : December 31, 2009 - March 31 2010 Portfolio:at December 31.2009 Portfolio at March 31.2010 Ending Book Value $ 150,902,838.01 Ending Book Value $ 132,904,150.98 Ending Market Value 150,900,139.13 Ending Market Value 132,899,202.68 Accrued Interest Receivable .92,749.11 Accrued Interest Receivable 78,217.95 FYD Total Interest Earned 92,179.66 FYD Total Interest Earned 172,656.03 Unrealized Gain/(Loss) (2,698.88) - Unrealized Gain/(Loss) (4,948.30) Change in Unrealized Gain/Loss (569.44) Change in Unrealized Gain/Loss (2,249.42) Weighted Average Maturity 18 Days Weighted Average Maturity 27 Days Change in Market Value . 37,190,801.43 Change in Market Value (18,000,936.45) Yield to Maturity at Cost 0.26% Yield to Maturity at Cost 0.22% T-Bill Benchmark 0.47% T=Bill Benchmark 0.41% Agency Note Benchmark 0.15% Agency Note Benchmark 0.18%. Average for Quarter City's Yield to Maturity 0.22%. 1 Year T-Bill Benchmark Yield 0.37% Agency Note Benchmark Yield 0.16% 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: 1 / ss •—••. :61/4...jc, 6ohrAL, 8,01_,ILA— Claire Bogard Rick( ver aard Fatima Uwakwe Director of Finance Assistant Director of Finance Senior Accounta nt Summary by Type March 31,2010 Description Face Amount k Shares Cost Value Book Value Market Value VIM 0 Cost Pays To Maturity Cash $ 114,887,062.68 $ 114,887,062.68 $ 114,887,062.68 $ 114,887,062.68 0.15% 1 CD 10,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 0.94% 155 FHLB 6,000,000.00 6,007,890.44 6,006,353.84 6,000,000.00 0.43% 273 FHLMC 2.000.000.00 2,014,920.22 2,010,734.46 2.012.140.00 0.23% 163 Total/Average $ 132,887,062.68 $ 132,909,873.34 $ 132,904,150.98 $ 132,899,202.68 0.22% 27 Group Portfolio Holdings Book Value by Maturity T e 140,000,000 FHLB by Yp FHLMC 5% 1% CD 120,000,000 8% 100,000,000 80,000,000 60,000,000 40,000,000 20,000,000 Cash is* 86% 1-30 Days 31-60 Days 61-90 Days 91-120 Day421-180 Days>180 Days interest Kates Date 1 mo 3 mo 6 mo 1 yr 2yr. 3 yr 5 yr 7 yr 10 yr 20 yr 30 yr 12/31/2009 0.04 0.06 0.20 0.47 1.14 1.70 2.69 3.39 3.85 4.58 4.63 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 Yield Curve Comparison 4.50 tt a , to � .114 3 00pals4A � 4:1 2 50 „ 3 Ci b • •...te d.vi;Yield.• q y ? D:y Average Matur,ty y q- 1 �. 3 E t " ... : rr. .3 . v si cai- '�'-e-Tt.-s i--c •ni � , c a-..- r t.n c-..v=1 a - ' .x." • u..1f u6 a l Y':7 N�.] :t r:-! ra. ! i .141:;LTc x4. wn_Fu- w � "--ra� ri.1sk 0 ¢- t¢ a a gL ?f romEns to-.. 0.50 �. � 'TYt' SF �, Y &"b Y' CAt ' "� 'F . .1 --1":R�"S. �'SPY[ _.R.- LTL.1 h .S "'"7"-- 0: ' ? :'YRL2' , ¢cn av "r-q• rr si. °• trvw4'- a � t �. - -r' . ita- - a gxrr ' a:ra c e rtxailt. ,•• -- ai -3" ^- b. 0.00 G':7d9 1 mo 3 mo 6 mo 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr 20 yr 30 yr -4--12/31/2009 -f-3/31/2010 Portfolio vs. Benchmarks 6.0096 a 3 u t'tz tt~< E+e t.qqqq°,i e .fp¢ :.l r r�p.o�tli q E� rife€a �:. 3E¢rgp¢tt�'¢ g�etttE-itr tt•l!t� E�f�-t''c E�I III : 441T ht 44°!` 4::i Ili .i4=i file.?t"t't ?ta'E!,,N ?Pt. tt e¢F t v R t* t4 t�� bt i ¢+ irE q¢it itgtk: Si tt.t e i l t I1 ,i•tW tE 4� t f�r¢¢t E edtl ¢re""*"'.. ,t`tt°t:.t..iric t?:-rf`ti. P -4.i - tt . t .,,c¢� t E.¢E.?4 t@er¢tt¢ ftt¢!¢tt t?Eitk14r 4r ttlt crEF�l614,i ti E°E ' E ttt f rcw; b tt'w rF tl F ti 5.00% .. ct t a t s.¢ct r t ¢° Ent"e a¢r to rs efl •s tv a r;Pt �f.� i aft*tM1:.�F.E fE r t t ttt h ¢� st a ¢ i� F¢tr¢q¢ .'"`,. i ¢tt•E¢:ctE 4¢t10. ¢ ft¢¢yt.?,i¢iilq ii¢it Pi Eligii ttO f illii 4 It IODitl:tt "t it t E�ii`*¢E i:i¢LE°Eli,¢E° C¢i et i 4t t 4: 6 tP d E rt t E tt ¢ g 1 to t t t q».n t Ett l tt¢rt Ela¢ ¢t ft F tttet v.t 1¢ ,_ ¢ 6 1, t E¢ r ' e!¢"¢t s. ¢:r¢t ,g¢.tt._t ¢¢_t 1 9:143t c¢F Ifra�¢?l-it ii tt' "T,1 t`.Pletr l Pt'ttt s -4°l:t+,1-t t v t t tI t• rf'et t tt q ." l 9¢�¢c: i' r 3t.7tt 4.00% lte ttt '..�..........?S E t.E?i;t E{�¢tef¢tE; ¢[e FFe^ et¢?Es ttt?7Et tt"�tt�c ' tttt[Pt t'ti tetil E�4rtE[�t �E F6EA°ESE" t it�..;-r 6r,ral*rp474 P.-7 M n t.4 tt,t t t¢E t¢`¢tt.ftt¢ ¢t ,iE fir ? ¢.c16 I t fl43€q"v t t.E:E.is iI +ttE"I tt,"t SiE't.e.E"'t¢t it� Sect ii 9 i i+ t ¢ � € •E t.r t1. Rt .e q�c tc a,t e�t¢! 1,_,1,• .tier �t xt r �t E Fc•'tgr¢"itvt,il'igr4 .f t!3 P P .gi i r` tt 4,. f t.f t¢ "i eq�rxp,�l.,it"t�?t 5'v 52iiggq! Itif Ibe iii 3.00% .•..t� lrt ttl�1 f .t•:r. i 6tieis IT a ti 4 ¢E trc t h ti ¢4 P¢ t tt� ���`�htg i l!ttit rp..f y,:4ri l . ,rt ei'.it.¢,? ......r. t. i,,;t.3ltiri ,4�t.E ...ia.i¢tivlet't .,tc .ri...l i...11 . 1.00% F! '1.1 0.00% levri''. r.u + �uE..l,.tty.t• .,.,,..r<.t.•t.t! ,...,ite ? E..- l,iP.-. ePFi `:r +t Esi i + a . i t r ? E4 pi . �0 Al 0 0 A% 0 O� O§) Ag' O' 0 o§2 S§' S§' S§' 8' Cf./ SP SP e 0 Spa 0 0 0 e 0 ti., ti� 4) O boo O6 lac �¢�,§ Pc was l,t 4 PJa,y.9 Ob.�e O4- lac,�e�4 Pci�,pX 1,c lam\ P,4��yQ O&+ oyc. lac Fe tea' -4-Port Total --IF-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: 12/31/2009, End Date: 3/31/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.16 11,712,850.87 4,951,901.91 1,160,890.59 0.00 0.00 15,503,862.19 5,765.85 Sweep Cash Fund Wells Fargo WFSWEEP 17: Municipal N/A 0.15 134,837.38 7,550.02 7,043.29 0.00 0.00 135,344.11 52.63 Sweep Cash Court Security Wells Fargo WFSWEEP 18: City Wide N/A 0.16 52,070.56 13,001.83 562.38 0.00 0.00 64,510.01 22.86 Sweep Cash Donation Wells Fargo WFSWEEP 19: Court N/A 0.15 294,283.11 4,729.25 4,770.92 0.00 0.00 294,241.44 112.81 Sweep Cash Technology Wells Fargo WFSWEEP 20: Debt N/A 0.14 17,089,759.87 4,205,416.01 10,904,027.92 0.00 0.00 10,391,147.96 5,280.19 Sweep Cash Services Wells Fargo WFSWEEP 23: Court N/A 0.79 -2,913.19 7,253.52 8,241.80 0.00 0.00 -3,901.47 0.58 Sweep Cash Juvenile Mgmt Wells Fargo WFSWEEP 25: Emergency N/A 0.00 -4,024.50 0.00 88,000.00 0.00 0.00 -92,024.50 0.00 Sweep Cash Mgmt Buyout Wells Fargo WFSWEEP 30: Water& N/A 0.17 10,679,340.85 2,972,424.11 2,930,226.95 0.00 0.00 10,721,538.01 3,894.88 Sweep Cash Sewer Wells Fargo WFSWEEP 31: Solidwaste N/A 0.17 57,372.56 95,894.53 37,744.59 0.00 0.00 115,522.50 19.55 Sweep Cash Wells Fargo WFSWEEP 35: Street N/A 0.15 541,095.85 4,877.22 0.00 0.00 0.00. 545,973.07 207.22 Sweep Cash Assessment Wells Fargo WFSWEEP 42: Utility N/A 0.15 10,383,384.02 184,272.71 1,737,033.65 0.00. 0.00 8,830,623.08 3,434.3C Sweep Cash Impact Fee Wells Fargo WFSWEEP 43: Regional N/A 0.15 4,027.80 1.51 0.00 0.00 0.00 4,029.31 1.51 Sweep Cash Detention Wells Fargo WFSWEEP 44: Shadow N/A 0.14 2,449,367.18 31,519.26 981,917.82 0.00 0.00 1,498,968.62 704.0] Sweep Cash Creek Impact Wells Fargo WFSWEEP 45: Hotel/Motel N/A 0.15 1,277,727.44 58,391.47 65,503.59 0.00 0.00 1,270,615.32 497.5E Sweep Cash Occupancy Wells Fargo WFSWEEP 46: Park N/A 0.15 29,051.30 12,091.97 15,795.66 0.00 0.00 25,347.61 7.5S Sweep Cash Donations Wells Fargo WFSWEEP 47: Park&Rec: N/A 0.15 983,624.84 6,523.17 20,498.50 0.00 0.00 969,649.51 373.1; Sweep Cash Development 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 WFSWEEP 49: Tree Trust N/A 0.15 17,229.09 6.52 0.00 0.00 0.00 17,235.61 6.52 Sweep Cash Fund Wells Fargo WFSWEEP 50: Capital N/A 0.14 11,291,697.60 3,354.71 3,497,843.82 0.00 0.00 7,797,208.49 3,354.71 Sweep Cash Projects Wells Fargo WFSWEEP 55: Sidewalk N/A 0.15 202,431.37 1,977.32 0.00 0.00 0.00 204,408.69 77.32 Sweep Cash Fund Wells Fargo WFSWEEP 60: Police State N/A 0.15 260,776.23 94.62 21,665.25 0.00 0.00 239,205.60 94.62 Sweep Cash Seizure Wells Fargo WFSWEEP 62: Federal N/A 0.15 19,806.28 7.50 0.00 0.00 0.00 19,813.78 7.50 Sweep Cash Police Fund Wells Fargo WFSWEEP 64: 1998 Cert N/A 0.15 1,380,084.35 501.44 164,944.00 0.00 0.00 1,215,641.79 501.44 Sweep Cash of Obligation Wells Fargo WFSWEEP 67: 2003 N/A 0.15 3,366,999.40 333,005.69 84,756.49 0.00 0.00 3,615,248.60 1,289.98 Sweep Cash Revenue Bonds Wells Fargo WFSWEEP 68: 2001 Cert N/A 0.15 4,974,315.14 930,267.36 2,281,464.62 0.00 0.00 3,623,117.88 1,836.10 Sweep Cash of Obligation 70Wells Fargo Re 2005; Sweep Cash WFSWEEP Refunding/ N/A 0.15 27,864,670.92 9,510.44 5,151,104.32 0.00 0.00 22,723,077.04 9,510.44 Mobility Wells Fargo WFSWEEP 71: 2005 N/A 0.15 43,567.79 15.07 12,188.25 0.00 0.00 31,394.61 15.07 Sweep Cash Refunding/Drain Wells Fargo WFSWEEP 95: Property • N/A 0.17 125,408.11 218,363.31 85,501.01 0.00 0.00 258,270.41 44.64 Sweep Cash Liability Wells Fargo WFSWEEP 97: Employee N/A 0.00 -52,469.34 11,124.67 19,533.98 0.00 0.00 -60,878.65 0.0C Sweep Cash Benefit Trust Wells Fargo WFSWEEP Z101: Grant N/A -0.01 44,445.80 4.44 586,044.34 0.00 0.00 -541,594.10 4.44 Sweep Cash Fund Wells Fargo WFSWEEP Z105: 2007 N/A 0.13 187.24 0.06 0.00 0.00 0.00 187.30 0.0E Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z106: 2008 N/A 0.00 0.00 0.00 42,099.33 0.00 0.00 -42,099.33 0.0C Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z107: 2009 N/A 0.00 -11,101.25. 11,000.76 28,947.00 0.00 0.00 -29,047.49 0.0( Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z116: CDBG N/A 0.00 -4,076.83 4,076.83 3,119.29 0.00 0.00 -3,119.29 0.0( Sweep Cash Recovery Fund Wells Fargo WFSWEEP Z120: Mgmt N/A 0.15 348,662.47 126.37 50,304.00 0.00 0.00 298,484.84 126.3: Sweep Cash District 1 Wells Fargo WFSWEEP Z140: U of H N/A 0.00 -3,435.50 6,871.83 0.00 0.00 0.00 3,436.33 0.8: Sweep Cash Fund Paue2of5 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 Z150: Sweep Cash WFSWEEP Hurricane IKE N/A 0.00 -834,346.34 0.00 0.00 0.00 0.00 -834,346.34 0.00 Proj . Wells Fargo Z200: 2006 Sweep Cash WFSWEEP Cert of N/A 0.15 5,525,188.65 55,462.68 8,202.06 0.00 0.00 5,572,449.27 2,117.21 Obligation Wells Fargo Z201: 2007 Sweep Cash Obligation Cert of N/A 0.15 4,740,259.21 984,924.93 1,559,380.63 0.00 0.00 4,165,803.51 1,595.43 Obligation Wells Fargo WFSWEEP Z202: 2007A N/A 0.15 10,257,567.49 1,225,588.33 2,058,342.57 .0.00 0.00 9,424,813.25 4,053.79 Sweep Cash Gen Obligation Wells Fargo WFSWEEP Z203: 2009 N/A 0.13 11,225,153.84 2,440.12 5,990,302.20 0.00 0.00 5,237,291.76 2,440.12 Sweep Cash Gen Obligation Wells Fargo Z205: 2010 Sweep Cash WFSWEEP Cert of N/A 0.17 230,119.35 230,204.85 0.00 0.00 0.00 460,324.20 114.85 Obligation Wells Fargo WFSWEEP Z301: W/S Pay N/A 0.15 1,207,642.12 13,447.40 5,801.37 0.00 0.00 1,215,288.15 457.90 Sweep Cash As U Go CIP Sub Total/Average 0.15 137,902,639.13 16,598,225.74 39,613,802.19 0.00 0.00 114,887,062.68 48,024.05 Cash CERTIFICATE OF DEPOSIT Pearland State 10: General Bank 1.5 CD700013249 Fund 7/24/2010 1.49 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 3,698.63 7/24/2010 Wells Fargo 10: General c Bank 0.4 CD7579071205 Fund 1/28/2011 ' 0.39 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 679.4- 1/28/2011 Wells Fargo CD7579073706 10: General 5/15/2010 1.24 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 3,082.1c 1.25 5/15/2010 Fund Wells Fargo Bank 0.4 C07579071205 SQry Debt 1/28/2011 0.39 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 679.4° 1/28/2011 Wells Fargo CD7579073706 20: Debt 5/15/2010 1.24 1,000,000.00 0.00 . 0.00 0.00 0.00 1,000,000.00 3,082.1c 1.25 5/15/2010 Services Wells Fargo 30: Water& Bank 1.53 CD114240070 Sewer 1/27/2010 1.81 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 1,249.1( 1/27/2010 Wells Fargo 30: Water& Bank 0.4 CD7579071205 Sewer 1/28/2011 0.39 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 679.41 1/28/2011 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 Wells Fargo CD7579073706 30: Water& 5/15/2010 1.24 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 3,082.19 1.25 5/15/2010 Sewer Wells Fargo 42: Utility Bank 0.4 CD7579071205 Impact Fee 1/28/2011 0.39 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 679.45 1/28/2011 Wells Fargo Z201: 2007 Bank 1.53 CD114240070 Cert of 1/27/2010 1.81 2,000,000.00 0.00 _ 2,000,000.00 0.00 0.00 0.00 2,498.18 1/27/2010 Obligation Wells Fargo Z202: 2007A CD7579073706 5/15/2010 1.24 2,000,000.00 0.00 0.00 0.00 0.00 2,000,000.00.. 6,164.39 1.25 5/15/2010 Gen Obligation Sub Total/Average 1.07 9,000,000.00 4,000,000.00 3,000,000.00 0.00 0.00 10,000,000.00 25,574.67 Certificate Of Deposit FHLB BOND FHLB 1 3133XV3Z2 10: General 4/15/2011 1.02 2,000,000.00 0.00 2,000,000.00 0.00 0.00 0.00 777.78 4/15/2011-10 Fund FHLB 0.57 20: Debt 3133XV5G2 12/29/2010 0.56 1,000,099.44 0.00 0.00 0.00 -25.00 1,000,074.44 1,400.00 12/29/2010 Services FHLB 0.57 3133XV5G2 30: Water& 12/29/2010 0.56 1,000,099.44 0.00 0.00 0.00 -25.00 1,000,074.44 1,400.00 12/29/2010 Sewer FHLB 0.57 3133XV5G2 50: Capital 12/29/2010 0.36 0.00 1,001,910.11 0.00 0.00 -358.87 1,001,551.24 622.80 12/29/2010 Projects FHLB 0.57 3133XV5G2 68: 2001 Cert 12/29/2010 0.36 0.00 1,001,910.11 0.00 0.00 -358.87 1,001,551.24 622.8C 12/29/2010 of Obligation 70FHLB 0.57 Re 2005 12/29/2010 3133XV5G2 Refunding/ - 12/29/2010 0.36 0.00 2,003,820.22 0.00 0.00 -717.74 2,003,102.48 1,245.55 Mobility Sub Total/Average 0.48 4,000,198.88 4,007,640.44. 2,000,000.00 . 0.00 -1,485.48 6,006,353.84 6,068.9, FHLB Bond • FHLMC BOND FHLMC 1.45 3128X8QT2 20: Debt 9/10/2010 0.23 0.00 1,007,460.11 0.00 0.00 -2,092.88 1,005,367.23 404.34 9/10/2010 Services FHLMC 1.45 3128X8QT2 44: Shadow 9/10/2010 0.23 0.00 1,007,460.11 0.00 0.00 -2,092.88 1,005,367.23 404.34 9/10/2010 Creek Impact Sub Total/Average 0.23 0.00 2,014,920.22 0.00 0.00 -4,185.76 2,010,734.46 808.6f FHLMC Bond 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• Total / 0.22 150,902,838.01 26,620,786.40 44,613,802.19 0.00 132,904,150.98 80,476.37 Average 5,671.24 • • Pac,p 5 ni'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 3/31/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 15,503,862.19 15,503,862.19 15,503,862.19 15,503,862.19 0.15000 N/A N/A 1 N/A 11.67 Sweep Cash Fund Wells Fargo WFSWEEP 17: Municipal 135,344.11 135,344.11 135,344.11 135,344.11 0.15000 N/A N/A 1 N/A 0.10 Sweep Cash Court Security Wells Fargo WFSWEEP 18: City Wide 64,510.01 64,510.01 64,510.01 64,510.01 0.15000 N/A N/A 1 N/A 0.05 Sweep Cash Donation Wells Fargo WFSWEEP 19: Court 294,241.44 294,241.44 294,241.44 294,241.44 0.15000 N/A N/A 1 N/A 0.22 Sweep Cash Technology Wells Fargo WFSWEEP 20:.Debt 10,391,147.96 10,391,147.96 10,391,147.96 " 10,391,147.96 0.15000 N/A N/A 1 N/A 7.82 Sweep Cash Services Wells Fargo WFSWEEP 23: Court -3,901.47 -3,901.47 -3,901.47 -3,901.47 0.15000 N/A N/A 1 N/A 0.00 Sweep Cash Juvenile Mgmt Wells Fargo WFSWEEP 25: Emergency -.92,024.50 -92,024.50. -92,024.50 -92,024.50 0.15000 N/A N/A 1 N/A -0.07 Sweep Cash Mgmt Buyout Wells Fargo WFSWEEP 30: Water& 10,721,538.01 10,721,538.01 10,721,538.01 10,721;538.01 0.15000 N/A N/A 1 N/A 8.07 Sweep Cash Sewer Wells Fargo WFSWEEP 31: Solidwaste 115,522.50 115,522.50 115,522.50 115,522.50 0.15000 N/A N/A 1 N/A 0.09 Sweep Cash Wells Fargo WFSWEEP 35: Street 545,973.07 545,973.07 545,973.07 545,973.07 0.15000 N/A N/A 1 N/A 0.41 Sweep Cash Assessment Wells Fargo WFSWEEP 42: Utility 8,830,623.08 8,830,623.08 8,830,623.08 8,830,623.08 0.15000 N/A N/A 1 N/A 6.65 Sweep Cash Impact Fee Wells Fargo WFSWEEP 43: Regional 4,029.31 4,029.31 4,029.31 4,029.31 0.15000 N/A N/A 1 N/A 0.00 Sweep Cash Detention Wells Fargo WFSWEEP 44: Shadow 1,498,968.62 1,498,968.62 1,498,968.62 1,498,968.62 0.15000 N/A N/A 1 N/A 1.13 Sweep Cash Creek Impact Wells Fargo WFSWEEP 45: Hotel/Motel 1,270,615.32 1,270,615.32 1,270,615.32 1,270,615.32 0.15000 N/A N/A 1 N/A 0.96 Sweep Cash Occupancy Wells Fargo WFSWEEP 46: Park 25,347.61 25,347.61 25,347.61 25,347.61 0.15000 N/A N/A 1 N/A 0.02 Sweep Cash Donations Wells Fargo WFSWEEP 47: Park&Rec 969,649.51 969,649.51 969,649.51 969,649.51 0.15000 N/A N/A 1 N/A 0.73 Sweep Cash Development Wells Fargo WFSWEEP 49:Tree Trust 17,235.61 17,235.61 17,235.61 17,235.61 0,15000 N/A N/A 1 N/A 0.01 Sweep Cash Fund Wells Fargo WFSWEEP 50: Capital 7,797,208.49 7,797,208.49 7,797,208.49 . 7,797,208.49 0.15000 N/A N/A 1 N/A 5.87 Sweep Cash Projects Pape 1 o14 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 55:Sidewalk 204,408.69 204,408.69 204,408.69 204,408.69 0.15000 N/A N/A 1 • N/A 0.15 • • Sweep Cash Fund Wells Fargo WFSWEEP 60: Police State 239,205.60 239,205.60 239,205.60 239,205.60 0.15000 N/A N/A 1 N/A 0.18 Sweep Cash Seizure Wells Fargo WFSWEEP 62: Federal 19,813.78. 19,813.78 19,813.78 19,813.78 0.15000 N/A N/A 1 N/A 0.01 Sweep Cash Police Fund Wells Fargo WFSWEEP 64: 1998 Cert 1,215,641.79 1,215,641.79 1,215,641.79 1,215,641.79 0.15000 N/A N/A 1 N/A 0.91 Sweep Cash of Obligation Wells Fargo WFSWEEP 67: 2003 3,615,248.60 3,615,248.60 3,615,248.60 3,615,248.60 0.15000 N/A N/A 1 N/A 2.72 Sweep Cash Revenue Bonds Wells Fargo WFSWEEP 68: 2001 Cert 3,623,117.88 3,623,117.88 3,623,117.88 3,623,117.88 0.15000 N/A N/A 1 N/A 2.73 Sweep Cash of Obligation 70Wells Fargo Re 2005 Sweep Cash WFSWEEP Refunding/ 22,723,077.04 22,723,077.04 22,723,077.04 22,723,077.04 0.15000 N/A N/A 1 N/A 17.10 Mobility Wells Fargo WFSWEEP 71: 2005 31,394.61 31,394.61 31,394.61 31,394.61 0.15000 N/A N/A 1 N/A 0.02 Sweep Cash Refunding/Drain Wells Fargo WFSWEEP 95: Property 258,270.41 258,270.41 258,270.41 258,270.41 0.15000 N/A N/A 1 N/A 0.19 Sweep Cash Liability Wells Fargo• WFSWEEP 97: Employee -60,878.65 60,878.65, -60,878.65 -60,878.65 0.15000 N/A N/A 1 N/A -0.05 Sweep Cash . Benefit Trust Wells Fargo WFSWEEP Z101: Grant -541,594.10 -541,594.10 -541,594.10 -541,594.10 0.15000 N/A N/A 1 N/A -0.41 Sweep Cash Fund Wells Fargo WFSWEEP Z105: 2007 187.30 187.30 187.30 187.30 0.15000 N/A N/A 1 N/A 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z106: 2008 -42,099.33 -42,099.33 -42,099.33 -42,099.33 .0.15000 N/A N/A 1 N/A -0.03 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z107: 2009 -29,047.49 -29,047.49 -29,047.49 -29,047.49. 0.15000 N/A N/A 1 N/A -0.02 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z116: CDBG -3,119.29 -3,119.29 -3,119.29 -3,119.29 0.15000 N/A N/A 1 N/A 0.00 Sweep Cash Recovery Fund Wells Fargo WFSWEEP Z120: Mgmt 298,484.84 298,484.84 298,484.84 298,484.84 0.15000 N/A N/A 1 N/A 0.22 Sweep Cash District 1 Wells Fargo WFSWEEP Z140: U of H 3,436.33 3,436.33 3,436.33 3,436.33 0.15000 N/A N/A 1 N/A 0.00 Sweep Cash Fund • Z150: Wells Fargo WFSWEEP Hurricane IKE -834,346.34 -834,346.34 -834,346.34 -834,346.34 0.15000 N/A N/A 1 N/A -0.63 • Sweep Cash Proj Z20Wells Fargo Cert 2006 Sweep Cash WFSWEEP Cert of 5,572,449.27 5,572,449.27 5,572,449.27 5,572,449.27 0.15000 N/A N/A 1 N/A 4.19 Obligation Wells Fargo Z201: 2007 Sweep Cash WFSWEEP Cert of 4,165,803.51 4,165,803.51 . 4,165,803.51,: 4,165,803.51 0.15000 N/A N/A 1 N/A 3.13 Obligation • D.,.... 1 n P tl Portfolio Face YTM @ Settlement Maturity Days To Accrued Wo of . Description CUSIP/Ticker Name Amount/Shares Cost Value Book Value Market Value Cost Date Date Maturity Interest Portfolio Wells Fargo WFSWEEP Z202: 2007A 9,424,813.25 9,424,813.25 9,424,813.25 9,424,813.25 0.15000 N/A N/A 1 N/A 7.09 Sweep Cash Gen Obligation Wells Fargo Z203: 2009 WFSWEEP 5,237,291.76 5,237,291.76 5,237,291.76 5,237,291.76 0.15000 N/A N/A 1 N/A 3.94 Sweep Cash Gen Obligation • Z205: 2010 Wells Fargo Sweep Cash WFSWEEP Cert of 460,324.20 460,324.20 460,324.20 460,324.20 0.15000 N/A N/A 1 N/A 0.35 Obligation Wells Fargo WFSWEEP Z301: W/S Pay 1,215,288.15 1,215,288.15 1,215,288.15 1,215,288.15 0.15000 N/A N/A 1 N/A 0.91 Sweep Cash As U Go CIP Sub Total / 114,887,062.68 114,887,062.68 114,887,062.68 114,887,062.68 0.15000 1 0.00 86.45 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 115 10,273.97 0.75 1.5 Fund 7/24/2010 Wells Fargo 10: General 1.25 CD7579073706 Fund 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1.25000 N/A 5/15/2010 45 10,958.90 0.75 5/15/2010 Wells Fargo 10: General Bank 0.4 C07579071205 Fund 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 0.40000 N/A 1/28/2011 303 679.45 0.75 1/28/2011. Wells Fargo 20: Debt 1.25 CD7579073706 Services- 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1.25000 N/A 5/15/2010 45 10,958.90 0.75 5/15/2010 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 303 679.45 0.75 1/28/2011 Wells Fargo 30: Water& 1.25 CD7579073706 Sewer 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1.25000 N/A 5/15/2010 45 10,958.90 0.75 5/15/2010 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 303 679.45 0.75 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 303 679.45 0.75 1/28/2011 Wells Fargo Z202: 2007A 1.25 CD7579073706 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1.25000 N/A 5/15/2010 45 21,917.81 1.51 5/15/2010 Gen Obligation Sub Total / 10,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 0.93500 155 67,786.28 7.53 Average FHLB Bond FHLB 0.57 3133XV5G2 20: Debt 1,000,000.00 1,000,125.00 1,000,074.44 1,000,000.00 0.56007 N/A 12/29/2010 273 1,456.67 0.75 12/29/2010 Services Page 3 014 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 30: Water& 1,000,000.00 1,000,125.00 1,000,074.44 1,000,000.00 0.56007 N/A 12/29/2010 273 1,456.67 0.75 12/29/2010 Sewer FHLB 0.57 3133XV5G2 50: Capital 1,000,000.00 1,001,910.11 1,001,551.24 1,000,000.00 0.36108 N/A 12/29/2010 273 1,456.67 0.75 12/29/2010 Projects FHLB 0.57 3133XV5G2 68: 2001'Cert 1,000,000.00 1,001,910.11 1,001,551.24 1,000,000.00 0.36108 N/A 12/29/2010 273 1,456.67 0.75 12/29/2010 of Obligation 70: 2005 FHLB 0.57 • 12/29/2010 3133XV5G2 Refunding/ 2,000,000.00 2,003,820.22 2,003,102.48 2,000,000.00 0.36108 N/A 12/29/2010 273 2,913.33 1.51 Mobility Sub Total/ 6,000,000.00 6,007,890.44 6,006,353.84 6,000,000.00 0.42741 273 8,740.01 4.52 Average FHLMC Bond FHLMC 1.45 3128X8QT2 20: Debt 1,000,000.00 1,007,460.11 1,005,367.23 1,006,070.00 0.23304 N/A 9/10/2010 163 845.83 0.75 9/10/2010 Services FHLMC 1.45 3128X8QT2 44: Shadow 1,000,000.00 1,007,460.11 1,005,367.23 1,006,070.00 0.23304 N/A 9/10/2010 163 845.83 0.75 9/10/201.0 Creek Impact Sub Total/ 2,000,000.00 2,014,920.22 2,010,734.46 2,012,140.00 0.23304 163 1,691.66 1.51 Average Total / 132,887,062.68 132,909,873.34 132,904,150.98 132,899,202.68 0.22285 27 78,217.95 100 Average • Page 4 of 4 City of Pearland By Maturity Report Format: By CUSIP Group By: Portfolio/Report Group: Report Group: Pearland As of 3/31/2010 Portfolio Face YTM @ Maturity Days To Accrued %of Security Description CUSIP/Ticker Name Amount/Shares Cost Value Book Value Market Value Cost Date Maturity Interest Portfolio Type Wells Fargo WFSWEEP Z301: W/S Pay 1,215,288.15 1,215,288.15 1,215,288.15 1,215,288.15 0.15000 N/A 1 N/A 0.91 Cash Sweep Cash As U Go CIP 5 Wells Fargo 70: 200 Sweep Cash WFSWEEP Refunding/ 22,723,077.04 22,723,077.04 22,723,077.04 22,723,077.04 0.15000 N/A 1 N/A 17.10 Cash Mobility Wells Fargo WFSWEEP 64: 1998 Cert 1,215,641.79 1,215,641.79 1,215,641.79 1,215,641.79 0.15000 N/A 1 N/A 0.91 Cash Sweep Cash of Obligation Wells Fargo WFSWEEP 44: Shadow 1,498,968.62 1,498,968.62 1,498,968.62 1,498,968.62 0.15000 N/A 1 N/A 1.13 Cash Sweep Cash Creek Impact Wells Fargo 45: Hotel/Motel 1,270,615.32 1;2.70,615.32 1,270,615.32 1,270,615.32 0.15000 N/A 1 N/A 0.96 Cash Sweep Cash Occupancy Wells Fargo WFSWEEP Z120: Mgmt 298,484.84 298,484.84 298,484.84 298,484.84 0.15000 N/A 1 N/A 0.22 Cash Sweep Cash District 1 Wells Fargo WFSWEEP 19: Court 294,241.44 294,241.44 294,241.44 294,241.44 0.15000 N/A 1 N/A 0.22.Cash Sweep Cash Technology Wells Fargo Z205: 2010 Sweep Cash WFSWEEP Cert of 460,324.20 460,324.20 460,324.20 460,324.20 0.15000 N/A 1 N/A . 0.35 Cash Obligation Wells Fargo WFSWEEP 47: Park&Rec 969,649.51 969,649.51 969,649.51 969,649.51 0.15000 N/A 1 N/A. 0.73 Cash Sweep Cash Development Wells Fargo WFSWEEP 35: Street 545,973.07 545,973.07 545,973.07 545,973.07 0.15000 N/A 1 N/A 0.41 Cash Sweep Cash Assessment Wells Fargo WFSWEEP. 67: 2003 3,615,248.60 3,615,248.60 3,615,248.60 . 3,615,248.60. 0.15000 N/A 1 N/A 2.72 Cash Sweep Cash Revenue Bonds Wells Fargo WFSWEEP Z202: 2007A 9,424,813.25 9,424,813.25 9,424,813.25 9,424,813.25 0.15000 N/A 1 N/A 7.09 Cash Sweep Cash Gen Obligation Wells Fargo WFSWEEP 42: Utility 8,830,623.08 8,830,623.08 8,830,623.08 8,830,623.08 0.15000 N/A 1 N/A 6.65 Cash Sweep Cash Impact Fee Wells Fargo WFSWEEP 20: Debt 10,391,147.96 10,391,147.96 10,391,147.96 10,391,147.96 0.15000 N/A 1 N/A 7.82 Cash Sweep Cash Services Wells Fargo WFSWEEP 10: General 15,503,862.19 15,503,862.19 15,503,862.19 15,503,862.19 0.15000 •N/A 1 N/A 11.67 Cash Sweep Cash Fund . Wells Fargo WFSWEEP 30: Water& 10,721,538.01 10,721,538.01 10,721,538.01 10,721,538.01. 0.15000 N/A 1 N/A 8.07 Cash Sweep Cash Sewer Wells Fargo Z201: 2007 Sweep Cash WFSWEEP Cert of 4,165,803.51 4,165,803.51 4,165,803.51 4,165,803.51 0.15000 N/A 1 N/A 3.13 Cash Obligation .. Page 1 of4 Portfolio Face YTM @ Maturity Days To Accrued 0/0 of Security. Description CUSIP/Ticker Name Amount/Shares Cost Value Book Value Market Value Cost Date Maturity Interest Portfolio Type Wells Fargo WFSWEEP 68: 2001 Cert 3,623,117.88 3,623,117.88 3,623,117.88 3,623,117.88 0.15000 N/A 1 N/A 2.73 Cash Sweep Cash of Obligation • Wells Fargo WFSWEEP Z203: 2009 5,237,291.76 5,237,291.76 5,237,291.76 5,237,291.76 0.15000 N/A 1 N/A 3.94 Cash Sweep Cash Gen Obligation Wells Fargo WFSWEEP 50: Capital 7,797,208.49 7,797,208.49 7,797,208.49 7,797,208.49 0.15000 N/A 1 N/A 5.87 Cash Sweep Cash Projects Wells Fargo Z200: 2006 Sweep Cash WFSWEEP Cert of 5,572,449.27 5,572,449.27 5,572,449.27 5,572,449.27 0.15000 N/A 1 N/A 4.19 Cash . Obligation Wells Fargo WFSWEEP 71: 2005 31,394.61 31,394.61 31,394.61 31,394.61 0.15000 N/A 1 N/A 0.02 Cash Sweep Cash Refunding/Drain Wells Fargo WFSWEEP 46: Park 25,347.61 25,347.61 25,347.61 25,347.61 0.15000 N/A 1 N/A 0.02 Cash Sweep Cash Donations Wells Fargo WFSWEEP 62: Federal 19,813.78 19,813.78 19,813.78 19,813.78 0.15000 N/A 1 N/A 0.01 Cash Sweep Cash Police Fund Wells Fargo WFSWEEP Z107: 2009 -29,047.49 -29,047.49 -29,047.49 -29,047.49 0.15000 N/A 1 N/A -0.02 Cash Sweep Cash CDBG Fund Wells Fargo WFSWEEP 97: Employee -60,878.65 -60,878.65 -60,878.65 -60,878.65 0.15000 N/A 1 N/A -0.05 Cash Sweep Cash Benefit Trust Wells Fargo WFSWEEP Z106: 2008 -42,099.33 -42,099.33 -42,099.33 -42,099.33 0.15000 N/A 1 N/A -0.03 Cash Sweep Cash CDBG Fund . Wells Fargo WFSWEEP Z105: 2007 187.30 187.30 187.30 187.30 0.15000 N/A 1 N/A 0.00 Cash Sweep Cash CDBG Fund Wells Fargo WFSWEEP 2116: CDBG -3,119.29 -3,119.29 -3,119.29 -3,119.29 0.15000 N/A 1 N/A 0.00 Cash Sweep Cash Recovery Fund Wells Fargo WFSWEEP 23: Court -3,901.47 -3,901.47 -3,901.47 -3,901.47 0.15000 N/A 1 N/A 0.00 Cash Sweep Cash Juvenile Mgmt Wells Fargo WFSWEEP 49:Tree Trust 17,235.61 17,235.61 17,235.61 17,235:61 0.15000 N/A 1 N/A 0.01 Cash Sweep Cash Fund Wells Fargo WFSWEEP 43: Regional 4,029.31. 4,029.31 4,029.31 4,029.31 0.15000 N/A 1 . N/A 0.00 Cash Sweep Cash Detention Wells Fargo WFSWEEP Z140: U of H 3,436.33 3,436.33 3,436.33 3,436.33 0.15000 N/A 1 N/A 0.00 Cash Sweep Cash Fund Wells Fargo WFSWEEP 25: Emergency -92,024.50 -92,024.50 -92,024.50 -92,024.50 0.15000 N/A 1 •N/A -0.07 Cash Sweep Cash Mgmt Buyout Wells Fargo WFSWEEP 17: Municipal 135,344.11 135,344.11 135,344.11 135,344.11 0.15000 • N/A 1 N/A 0.10 Cash Sweep Cash Court Security Wells Fargo Z150: Sweep Cash WFSWEEP Hurricane IKE -834,346.34 • -834,346.34 -834,346.34 -834,346.34 0.15000 N/A 1 N/A -0.63 Cash Proj Wells Fargo WFSWEEP 18: City Wide 64,510.01 64,510.01 64,510.01 64,510.01 0.15000 N/A 1 N/A 0.05 Cash Sweep Cash Donation Patie2Of4 • Portfolio Face YTM @ Maturity Days To Accrued %of Security. Description CUSIP/Ticker Name Amount/Shares Cost Value Book Value Market Value . Cost Date Maturity Interest Portfolio Type Wells Fargo WFSWEEP 55: Sidewalk 204,408.69 204,408.69 204,408.69 204,408.69 0.15000 N/A 1 N/A 0.15 Cash • Sweep Cash Fund Wells Fargo WFSWEEP 31: Solidwaste 115,522.50 115,522.50 115,522.50 115,522.50 0.15000 N/A 1 N/A 0.09 Cash Sweep Cash Wells Fargo WFSWEEP 60: Police State 239,205.60 239,205.60 239,205.60 239,205.60 0.15000 N/A 1 N/A 0.18 Cash Sweep Cash Seizure Wells Fargo WFSWEEP 95:Property 258,270.41 258,270.41 258,270.41 258,270.41 0.15000 N/A 1 N/A 0.19 Cash Sweep Cash Liability Wells Fargo WFSWEEP Z101: Grant -541,594.10 -541,594.10 -541,594.10 -541,594.10 0.15000 N/A 1 N/A -0.41 Cash Sweep Cash Fund • Certificate Wells Fargo Z202: 2007A 1.25 CD7579073706 2,000,000.00 2,000,000.00 2,000,000.00 2,000,000.00 1.25000 5/15/2010 45 21,917.81 1.51 Of 5/15/2010 Gen Obligation Deposit Certificate Wells Fargo 10: General 1.25 CD7579073706 Fund 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1.25000 5/15/2010 45 10,958.90 0.75 Of 5/15/2010 Deposit Certificate Wells Fargo 20: Debt 1.25 CD7579073706 Services 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1.25000 5/15/2010 45 10,958.90 0.75 Of 5/15/2010 Deposit Certificate Wells Fargo 30: Water& 0 075 1.25 CD7579073706 Sewer 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 .1.25000 5/15/2010 45 10,958.9 . Of 5/15/2010 Deposit Pearland Certificate State Bank 10: General 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1.50000 7/24/2010 115 10,273.97 0.75 Of 1.5 CD700013249. FundDeposit 7/24/2010 FHLMC 1.45 20: Debt FHLMC 9/10/2010 3128X8QT2 Services 1,000,000.00 1,007,460.11 1,005,367.23 1,006,070.00 0.23304 9/10/2010 163 845.83 0.75 Bond FHLMC 1.45 44: Shadow FHLMC 9/10/2010 3128X8QT2 Creek Impact' 1,000,000.00 1,007,460.11 1,005,367.23 1,006,070.00 0.23304 9/10/2010 163 845.83 0.75 Bond FHLB 0.57 70: 2005 FHLB 12/29/2010 3133XV5G2 Refunding/ 2,000,000.00 2,003,820.22 2,003,102.48 2,000,000.00 0.36108 12/29/2010 273 2,913.33 1.51 Bond Mobility FHLB 0.57 50: Capital FHLB 3133XV5G2 1,000,000.00 1,001,910.11 1,001,551.24 1,000,000.00 0.36108 12/29/2010 273 1,456.67 0.75 Bond 12/29/2010 Projects FHLB 0.57 20: Debt FHLB 12/29/2010 3133XV5G2 Services 1,000,000.00 1,000,125.00 1,000,074.44 1,000,000.00 0.56007 12/29/2010 273 1,456.67 0.75 Bond FHLB 0.57 68: 2001 Cert FHLB 3133XV5G2 1,000,000.00 1,001,910.11 1,001;551.24 1,000,000.00 0.36108 12/29/2010 273 1,456.67 0.75 Bond 12/29/2010 of Obligation FHLB 0.57 30: Water& FHLB 12/29/2010 3133XV5G2 Sewer 1,000,000.00 1,000,125.00 1,000,074.44 1,000,000.00 0.56007 12/29/2010 273 1,456.67 0.75 Bond • Certificate 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 1/28/2011 303 679.45 0.75 Of 1/28/2011 Deposit . Pane 1 of 4 • Portfolio Face YTM @ Maturity Days To Accrued %of Security. Description CUSIP/Ticker Name Amount/Shares Cost Value Book Value Market Value Cost Date Maturity Interest Portfolio Type Wells Fargo 10: General Certificate Bank 0.4 CD7579071205 Fund 1,000,000.00 1,000,000.00 .1,000,000.00 1,000,000.00 0.40000 1/28/2011 303 679.45 0.75 Of • 1/28/2011 • Deposit Wells Fargo 42 Utility Certificate Bank 0.4 CD7579071205 Impact Fee 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 0,40000 1/28/2011 303 679.45 0.75 Of 1/28/2011 Deposit Wells Fargo Certificate Bank 0.4 CD7579071205 20: DebtServices 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 0.40000 1/28/2011 303 679.45 0.75 Of 1/28/2011 Deposit Total / 132,887,062.68 132,909,873.34 132,904,150.98 132,899,202.68 0.22285 27 78,217.95 100 Average • • • • • • • Page 4 of 4 Pledged Collateral Reconciliation Report March 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 107,104,691.79 Wells Fargo 201-0419554 98 CO Escrow • - Wells Fargo 807-1613395 Credit Card Account 9,353,867.37 Wells Fargo 818-4567843 Alvin !SD 6,000,661.91 Wells Fargo 001-3043112 PEDC Sales Tax - Wells Fargo Wells Fa 1.25 05/15/10 Certificate of Deposit 6,000,000.00 Wells Fargo Wells Fa 1.53 01/27/10 Certificate of Deposit 4,000,000.00 Total of Bank Balances $ 132,459,221.07 Pledged Collateral for City 157,908,677.27 FDIC Insurance 250,000.00 Total Collateral $ 158,158,677.27 Over(Under) Collateralized $ 25,699,456.20 Total_% Collateralized 119.4% Bank Account Number Account Name Amount Wells Fargo 100-7284258 Development Authority 2,669,401.41 Wells Fargo 16798300 Development Authority - Wells Fargo 16798301 Development Authority 200.03 • Wells Fargo 16798302 Development Authority 1,548,884.39 Total of Bank Balances $ 4,218,485.83 Pledged Collateral for DAP 4,294,925.60 FDIC Insurance 250,600.00 Total Collateral $ 4,544,925.60 Over(Under) Collateralized $ 326,439.77 Total % Collateralized 107.7% 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,865,499.82 FDIC Insurance 250,000.00 Total Collateral $ 3,115,499.82 Over(Under) Collateralized $ 2,115,499.82 Total % Collateralized 311.5% Total $ Over(Under) Collateralized $ 28,141,395.79 Total % Collateralized 120.4% Status Collateralized I_\Investments\Investment Report-City-Qtr 0310