Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R2011-051 - 2001-05-09
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 2011. ATTEST: A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS, ACCEPTING THE CITY'S INVESTMENT REPORT FOR THE QUARTER ENDING MARCH 2011. PASSED, APPROVED, AND ADOPTED this 9 day of May, A.D., 2011. SONIA WEBB DEPUTY CITY SECRETARY APPROVED AS TO FORM: 61_1_ DARRIN M. COKER CITY ATTORNEY RESOLUTION NO. R2011 -51 C '1 G f�.►e, TOM REID MAYOR Summary by Type March 31,2011 Description Face Amount\Shares Cost Value Book Value Market Value VTM @ Cost Days To Maturity Cash $ 81,377,229.50 $ 81,377,229.50 $ 81,377,229.50 $ 81,377,229.50 0.16% 1 MM 220,642.06 220,642.06 220,642.06 220,642.06 0.16% 1 FHLB 13,000,000.00 13,175,032.33 13,107,648.28 13,113,514.50 0.48% 314 FHLMC 2,000,000.00 2,041,268.41 2,035,003.57 2,033,924.00 0.33% 358 FNMA 11,000,000.00 11,022,379.74 11,001,746.95 10,990,917.00 0.54% 424 Total/Average $ 107,597,871.56 $ 107,836,552.04 $ 107,742,270.36 $ 107,736,227.06 0.24% 89 Group Portfolio Holdings Book Value by Maturity by Type 90,000,000 FNMA 80,000,000 FHLMC 10% 70,000,000 FHLB 2%u 12% 60,000,000 MM 50,000,000 0% 40,000,000 — 30,000,000 — — 1 20,000,000 . '4.. 10,000,000 Cash T 7 6% 1-30— 31-60- 61-90... 91 121-•• ,180... Interest Rates Date 1 mo 3___mi 6 mo IA 2.xi IA FYI Lys 10 yr 20 yr 30 vt 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 3/31/2011 0.05 0.09 0.17 0.30 0.80 1.29 2.24 2.90 3.47 4.29 4.51 Yield Curve Comparison e s-`a rmr a r Ir T5.00 i i 3,,.T rrr ri 4 t r .£a a it tc. r.f . � 4 1 i rn ... Fs....� . .Ir ,14.50 :t - 4P r. 11 rE k1 ft t tl I + 1CY l C t l tw s I m [ a r4. r r4.00 tkli';ry 1It ii ^ X2 i i i ii i 5 : t q ., i tl CF [ t +! II t e i I su y,,,+ro t � ;' [3." i� s F S 0 Wy ° v f + 1F ° f. 0 +w � ;r ° I c c s ,�. pFs t aPr i fy t- - .„ 2.50 CityF'WeightedAvg Yield.72 % f : i ss f,ri t i c et [ .wt9DayAvaagMatury ° + I+is it i i[ , F P l v 1.50 -: - 0.00 � n a l tiliAt f:�Y� � . roar. € n tr r.ir ut [it 4 s rr 3 IE txA 1t. St z v t f y r t J + -f T £, i A Ti F � s7 0.50 'w Fw kwsw C ��-- _ u sJ r t}" a sitx� :• i . 1 mo 3 mo 6 mo 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr 20 yr 30 yr -+-12/31/2010 -II-3/31/2011 Portfolio vs. Benchmarks 0.35% 0.30% 0.25% ..... 0.20% , 0.109 «.•_ �"E +.7.,- dx-r� t s �fia"1, S *�-v e"t.i4 •' a A „ x ,, -r r,'i. 0.059'0 y 9 [G h. w r y q sz r ,.. w et , -- Oct-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar 11 - -Port Total -1111-1 Yr T-Bill --*--Agency Note City of Pearland Quarterly Investment Report at Quarterend . Report Format:'ByTransaction Group By:,SecurityType . Portfolio/Report Group Report Group:Pearland • - As of 3/31'/2011 Portfolio Settlement Maturity YTM @ Face Days To Accrued %of Description CUSIP/Tidier Name "Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Cash Wells Fargo WFSWEEP 10:General 5/31/2006 N/A 0.16000 14,419,862.75 14,419,862.75 14,419,862.75 14,419,862.75 1 N/A 13.40 Sweep Cash Fund Wells Fargo 17: Municipal Sweep Cash WFSWEEP Court 5/31/2006 N/A 0.16000 135,930.64 135,930.64 135,930.64 135,930.64 1 N/A 0.13 Security Wells Fargo 18:City Sweep Cash WFSWEEP Wide 5/31/2006 N/A 0.16000 58,610.31 58,610.31 58,610.31 58,610.31 1 N/A 0.05 Donation Wells Fargo WFSWEEP 19:Court • 5/31/2006 . N/A 0.16000 204,605.20 204,605.20 204,605.20 204,605.20 1 N/A 0.19 Sweep Cash Technology Wells Fargo WFSWEEP 20: Debt 5/31/2006 N/A 0.16000 11,790,606.89 11,790,606;89 11,790,606.89 11,790,606.89 1 N/A 10.96 Sweep Cash Services Wells Fargo 23:Court Sweep Cg WFSWEEP Juvenile 9/15/2009. N/A .0.16000 17,957.11 17,957.11 17,957.11 17,957.11 1 N/A 0.02 Mgmt Wells Fargo WFSWEEP 30:Wat•er& • 5/31/2006 N/A 0.16000 6,958,354.49 6,958,354.49 6,958,354.49 6,958,354.49 1 N/A 6.47 Sweep Cash Sewer Wells Fargo WFSWEEP 31: 12/1/2006 N/A 0.16000 226,148.55 226,148.55 226;148.55 226,148.55 1 N/A 0.21 Sweep Cash Solidwaste Wells Fargo WFSWEEP 35:-Street 5/31/2006 N/A 0.16000 547,021.69 547,021.69 547,021.69 547,021.69 1 N/A 0.51 Sweep Cash Assessment Wells Fargo WFSWEEP 42:Utility 5/31/2006 N/A 0.16000 7,027,460.46 7,027,460.46 7,027,460.46 7,027,460.46 1 N/A 6.53 Sweep Cash Impact Fee Wells Fargo WFSWEEP 43:.Regional 5/31/2006 N/A 0.16000 4,036.99 4,036.99 • 4,036.99 4,036.99 1 N/A 0.00 Sweep Cash Detention Wells Fargo 44:Shadow Sweep Cash WFSWEEP Creek 5/31/2006 N/A 0.16000 1,679,798.59 1,679,798.59 1,679,798.59 1,679,798.59 1 N/A 1.56 Impact 45: Wells Fargo Sweep Cash WFSWEEP HoteVMotel 5/31/2006 N/A 0.16000 1,246,942.07 1,246,942.07 1,246,942.07 1;246,942.07 1 N/A 1.16 Occupancy • Wells Fargo • 46: Park . Sweep Cash WFSWEEP Donations 5/31/2006 ,N/A 0.16000 53,487.44 53,487.44 53,487.44 53,487.44 1 N/A 0.05 Wells Fargo 47:,•Park& Sweep Cash WFSWEEP Rec 5/31/2006 N/A 0.16000 1,141,243.35 1,141,243.35 1,141,243,35 1,141,243.35 1 N/A 1.06 Development Wells Fargo WFSWEEP 49:Tree 5/31/2006 N/A 0.16000 9,658.22 9,658.22 9,658.22 9,658.22 1 N/A. 0.01 Sweep Cash Trust Fund 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 Wells Fargo WFSWEEP 50:Capital 5/31/2006 N/A 0.16000 3,886,326.12 3,886,326.12 3,886,326.12 3,886,326.12 1 N/A 3.61 Sweep Cash Projects Wells Fargo WFSWEEP 55:Sidewalk 5/31/2006 N/A 0.16000 213,318.09 213,318.09 213,318.09 213,318.09 1 N/A 0.20 Sweep Cash Fund Wells Fargo 60:Police Sweep Cash WFSWEEP State 5/31/2006 N/A 0.16000 160,452.07 160,452.07 160,452.07 160,452.07 1 N/A 0.15 Seizure Wells Fargo WFSWEEP 62:Federal 5/31/2006 N/A 0.16000 24,637.59 24,637.59 24,637.59 24,637.59 1 N/A 0.02 Sweep Cash Police Fund Wells Fargo 64: 1998 Sweep Cash WFSWEEP Cert of 5/31/2006 N/A 0.16000- 947,140.98 947,140.98 947,140.98 947,140.98 1 N/A 0.88 Obligation Wells Fargo 67:2003 Sweep Cash WFSWEEP Revenue 5/31/2006 N/A 0.16000 7,497,950.96 7,497,950.96 7,497,950.96 7,497,950.96 1 N/A 6.97 Bonds Wells Fargo 68:2001 SweepWFSWEEP Cert of 5/31/2006 N/A 0.16000 3,577,257.15 3,577,257.15 3,577,257.15 3,577,257.15 1 N/A 3.32 Cash Obligation 69:2001 Wells Fargo WFSWEEP W&S 5/31/2006 N/A 0.16000 8,294,396.50 8,294,396.50 8,294,396.50 8,294,396.50 1 N/A 7.71 Sweep Cash Revenue Bond Wells Fargo WFSWEEP 95:Property 10/31/2006 N/A 0.16000 190,178.55 190,178.55 190,178.55 190,178.55 1 N/A 0.18 Sweep Cash Liability Wells Fargo 97' Sweep Cash WFSWEEP Employee 9/1/2007 N/A 0.16000 64,407.57 64,407.57 64,407.57 64,407.57 1 N/A 0.06 Benefit Trust . WWells Fargo 99:COP Well Fargo h WFSWEEP Health 9/15/2010 N/A 0.16000 47,070.50 47,070.50 47,070.50 47,070.50 1 N/A 0.04 SweeClaims Fund Wells Fargo WFSWEEP Z101:Grant 5/31/2006 N/A 0.16000 -46,878.40 -46,878.40 -46,878.40 -46,878.40 1 N/A -0.04 Sweep Cash Fund Wells Fargo WFSWEEP Z106:2008 3/15/2009 N/A 0.16000 -4,606.16 -4,606.16 -4,606.16 -4,606.16 1 N/A 0.00 Sweep Cash CDBG.Fund Wells Fargo WFSWEEP 2107;2009 11/1/2009 N/A 0.16000 -11,039.14 -11,039.14 -11,039.14 -11,039.14 1 N/A -0.01 Sweep Cash CDBG Fund . Wells Fargo WFSWEEP 2108:2010 11/1/2010 N/A 0.16000 -25,587.08 -25,587.08 -25,587.08 -25,587.08 1 N/A -0.02 Sweep'Cash CDBG Fund Wells Fargo Z116:CDBG Sweep CashWFSWEEP . Recovery 7/31/2009 N/A 0.16000 11,114.25 11,114.25 11,114.25 11,114.25 1 N/A 0.01 Fund Wells Fargo WFSWEEP 2120:Mgmt 12/31/2007 N/A 0.16000 947.65 947.65 947.65 947.65 1 N/A. 0.00 Sweep Cash District.1 Wells Fargo WFSWEEP Z140: U of H 12/1/2009 N/A 0.16000 20,159.87 20,159.87 20,159.87 20,159.87 1 N/A 0.02 Sweep.Cash Fund 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 Welts Fargo Z150: Sweep Cash" WFSWEEP Hurricane.IKE.10/31/2008 N/A 0,16000 11.35 11.35 11.35 11'.35 1 N/A 0.00 Proj Wells Fargo Z200:2006 Sweep Cash WFSWEEP Cert of 6/30/2006 N/A 0.16000 3,409,216.08 3,409,216.08 3,409,216.08 3,409,216.08 1 N/A 3.17 Obligation •W ells.Fargo Z201:2007 Sweep Cash WFSWEEP' Cert Of 8/31/2006 • N/A 0.16000 1,549,430.66 1,549,430.66 1,549,430.66 1,549,430.66 1 N/A 1.44 Obligation' Wells Fargo Z202' • Sweep Cash WFSWEEP 2007A'Gen 12/31/2007 N/A. '0.16000 1,007,034.71 1,007,034.71 1,007,034.71 1,007,034.71 1. N/A 0.94 Obligation Wells Fargo Z203:2009 Sweep Cash WFSWEEP Gen 10/30/2008' N/A 0.16000 '3,813,106.74 3,813,106.74 3,813,106.74 3,813,106.74 1 N/A 3.54 Obligation Wills Fargo 2301:W/S A Sweep Cash WFSWEEP Pays U Go 12/31/2007 N/A 0.16000 1,229,458.14 1,229,458.14 1,229,458.14 1,229,458.14 . 1 N/A 1.14 CIP Sub Total/ 0.16000 81,377,229.50 81,377,229.50 81,377,229.50 81,377,229.50 1 0.00 75.63 Average FHLB 2 10:General 9/14/2012 3133XUK93 Fund 2/22/2011 9/14/2012 0.62617 1,000,000.00 1,021,300.00 1,019,821.89 1,019,955.00 533 '944.44 0.93 .FHLB 3,25 30:Water& 4/9/2012 31331YC24 , Sewer 8/31/2010. 4/9/2012 .0.50658 1,000,000.00 ; 1,043,810.00 1,027,920.36 1,029,207.00' 375 15,527.78 0.93 FHLB 0.875 30:'Water& 8/22/2012 3133XYWB7_ Sewer 2/22/2011 8/22/2012 0.60004 1,000,000.00 1,004,100.37 1,003,804.23 1,004,026.00 510 947.92 0.93 FHLB 1375 3133XWKU2 30:Water& 1/18/2011 "6/8/2012 0.46004 - 1,000,000.00 1,012,651.96 1,010,804.77 1,008,668.50 435 4,315.97 0.93 6/8/2012 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,376.00 287 1,423.61 0.93 1/12/2012 Impect'Fee FHLB 0. 2 • 313372368 42:Utility 12/15/2010 4/13/2012 0.42000 1,000,000.00 1,000,000.00 1,000,000.00 .1,000,306.00' 379 1,236.67 0.93, 4/13/2020 12 Irnpact',Fee FHLB 3.25 42:Utility 3133XPCS1 8/31/2010' ' 3/9/2012. 0.46722 1,000,000.00 1,042,160.00 1,026,033.22 1,027,100.00 344 1,986.11 0.93 3/9/2012 Impact Fee FHLB 0.4 31337.1YD2 50.Capital 12/20/2010' 12/20/20.11 0.40000 1,000,000.00 1,000,000.00 1,000,000.00 1;000,091'.00 264 1,122.22 0.93 • 12/20/2011-11 Projects FHLB 0.42 Ref 2005 4/13/2012 313372368` Refunding/ 12/15/2010 4/13/2012 0.42000 1,000,000,00 1,000,000.00 1,000,000.00 1,000,306.00 379 1,236.67 0.93 Mobility. 70:2005 FHLB 3:75 FHLB 3133XRY46. Refunding/ 8/31/2010 9/9/2011 0.29579 1,000,000,00. '1,035,230.00 1,015,180.41 1,015,762.00 162 2,291.67 0.93 Mobility' • 3 of 5 • • • Portfolio 'Settlement Maturity YTM© Face - Days To Accrued 0/0of Description CUSIP/Ticker , Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio FHLB 0'.85 R Ref 005 5/4/2011 3133XVLE9 efunnding/ 5/20/2010 5/4/2011 0.50023 1,000,000.00 1,003,330.00 1,000,319.45 1,000,715.00 34 3,470.83 0.93 Mobility FHLB 1.625 Refu 005 7/27/2011 3133XTXH4 Refunding/ 6/30/2010 • 7/27/2011 0.46257 1,000,000.00 1,012,450.00 1,003,763.95 -1,004,911.00 118 2,888.89 0.93 Mobility HLB.0.4 Z203:2009 F FILB 0. 11 313371YD2 Gen• 12/20/2010 12/20/2011 0.40000 1,000,000.00 1,000,000.00 1,000,000.00 1,000,091.00 264 1,122.22 0.93 Obligation Sub Total/ 0.47566 13,000,000.00 13,175,032-33 13,107,648.28 13,113,514.50 314 38,515.00 ' 12.08 Average . • FHLMC Bond - FHLMC 2.125 3137EABY4 42:Utility 1/28/2011 3/23/2012 0.33000 1,000,000.00 1,020,634.21 1,017,501.79- 1,016,962.00 358 472.22 0.93 . 3/23/2012 Impact Fee FHLMC 2.125 Ref 2005 3/23/2012 3137EABY4 Refunding/ 1/28/2011 3/23/2012 0.33005 ' 1,000,000.00 1,020,634.20 1,017,501.78 1,016,962.00 358 472.22 0.93 Mobility Sub Total/ 0.33003 2,000,000.00 '2,041,268.41 2,035,003.57 2,033,924.00 358 944.44 1.86 ." Average - FNMA Bond • - - FNMA.1.08 31398AK50 10.General 12/10/2010 3/30/2012 0.38509 1,000,000.00 1,009,040.00 1,006,905.02 1,006,563.00 365 0.00 0.93 3/30/2012 Fund FNMA 0.5 31398A4T6 10:General 3/30/2011 10/30/2012 0.62402 2,000,000.00 1,996,097.64 1,996,097.64 1,994,428:00 579 4,166.67 1.86 10/30/2012 Fund" FNMA 1.375 31398AWQ1 'Fund 10:General 4/28/2011 4/16/2010 4/28/2011 0.52481 1,000,000.00 1,008,750.00 .1,000,635.08 1,000,971.00 28 5,843.75 0,93 " FNMA 0.375 31398A6F4 20:Debt 1/28/2011 12/28/2012 0.66003 1,000,000.00- 994,580.00 995,074.87 991,486.00 638 968.75 0,93 12/28/2012 Services FNMA',1.375 20:Debt 4/28/2011 31398AWQ1 Services 4/16/2010 4/28/2011 ,0.52481 1,000,000.00.• : 1,008,750.00 1,000,635.08 1,000,971.00 28 5,843.75 0.93 • FNMA 1.08 30:Water& 3/30/2012 31398AK50 Sewer 12/10/2010 3/30/2012 0.38509 1,000,000.00 1,009,040.00 1,006,905.02 1,006,563.00 365 0.00 0.93 FNMA 0.875 31398AB43 30:"Water& .1/18/2011 1/12/2012 0.32002 1,000,000.00 1,005,444.46 1,004,321.73 .1,004,021.00 287 1,920.14 0.93 1/12/2012 'Server FNMA 0.375 31398A6F4 Sewer 30:Water& 12/28/2012 1/28/2011; 12/28/2012 0;66003 1,000,000.00 994,580.00 995,074.87. 991,486.00 638 968.75 0.93 FNMA 0.5 30:Water& 10/30/2012 31398A4T6 Sewer 3/30/2011 10/30/2012 0.62402 1,000,000.00 996,048.82 998,048:82 997,214.00 579 2,083.33 0.93 FNMA 0.5 31398A4T6 42:.Util'dy 3/30/2011 10/30/2012 0.62402 1,000,000.00 998,048.82 998,048.82 997,214.00 579 2,083.33 0.93 10/30/2012" Impact Fee R Sub.Total/ 1).54145 11,000,000.00 11;022,379.74 11,001,746.95 10,990;917.00 424 23,878.47 10:22 •Average, • 4 of 5 Portfolio Settlement Maturity YTM @ Face Days To Accrued %of Description CUSIP/Tidcer Name Date Date Cost Amount/Shares Cost Value Book Value. Market Value Maturity Interest Portfolio Money Market 99:COP Wells Fargo MM WF9871 Health 10/1/2010 N/A 0.16000 220,642.06 220,642.06 220,642.06 220,642.06 1 N/A 0.21 Claims Fund Sub Total/ 0.16000 220,642.06 220,642.06 220,642.06 220,642.06 1 0.00 0.21 Average Total/ 0.24030 107,597,871.56 107,836,552.04 107,742,270.36 107,736,227.06 89 63,337.91 100 Average' • • 5 of 5 City of Pearland Quarterly Investment Report Beg to End • 'Report Format:By CUSIP Group By:Security Type ' Portfolio/Report Group:Report Group:Pearland Begin'Date:.12/31/2010,End Date:.3/31/2011 • • 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.19 11,627,874:49 4,747,566.87 1,955,578.61 0.00 0.00 14,419,862.75 6,734.98 Sweep Cash Fund Wells Fargo 17:Municipal Wells Cash WFSWEEP Court N/A 0.17 133,847.97 8,733.94 6,651.27 0.00 0.00 135,930.64 57.52 Sweep Security Wells Fargo 18: City SweepWFSWEEP Wide N/A 0.17 45,722.85 12,887.46 0.00 0.00 0.00 58,610.31 21.20 Cash Donation Wells Fargo WFSWEEP 19:Court N/A 0.17 194,207.12 10,398.08 0.00 0.00 0.00 204,605.20 83.85 Sweep Cash Technology Wells Fargo WFSWEEP 20:Debt N/A 0.16 16,675,299.54 3,963,886.82 8,848,579.47 '0.00 0.00 11,790,606.89 5,690.36. Sweep Cash Services Wells Fargo 23:Court Sweep Cash WFSWEEP Juvenile N/A 0.17 12,208.09 9,816.42 4,067.40 0.00 0.00 17,957.11 7.82 Mgmt . Wells Fargo WFSWEEP 30:Water& N/A 0.15 10,314,104.88 3,248.28 3,358,998.67 0.00 0.00 6,958,354.49 3,248.28 Sweep Cash Sewer Wells Fargo WFSWEEP 31: N/A 0.18 143,734.77 95,272.79 12,859.01 0.00 0.00 226,148.55 75.61 Sweep Cash Solidwaste Wells Fargo WFSWEEP 35: Street N/A 0.17 546,794.72 226.97 0.00 0.00 0.00 547,021.69 226.97 Sweep Cash Assessment Wells Fargo WFSWEEP 42:,Utility N/A 0.16 10,523,219.82 664,040.37 4,159,799.73 0.00 0.00 7,027,460.46 3,235.11 Sweep Cash Impact Fee Wells Fargo WFSWEEP 43: Regional N/A 0.16 4,035.33 1.66 0.00 0.00 0.00 4,036.99 1.66 -Sweep Cash Detention . WellsFargo 44: Shadow Sweep Cash WFSWEEP Creek N/A 0.16. 2,082,325.05 117,752.04 520,278.50 0.00 0.00 1,679,798.59 830.04 Impact Wells Fargo 45: Sweep'Cash WFSWEEP HoteUMotel N/A 0:17 1,258,561.99 48;494.35 60,114.27 0.00 0.00 1,246,942.07 530.91 Occupancy Wells Fargo WFSWEEP 46: Park • N/A 0.17. 44,439.89 9,047.55 0.00. 0.00 0.00 53,487:44 21.82 Sweep Cash Donations . Wells Fargo 47: Park& Sweep Cash WFSWEEP Rec N/A 0.17' 1,127,912.32 16,079.79 2,748.76 0.00• 0.00 1,141,243.35 469.29 Development • • • 1 of • Portfolio Maturity Annualized Amortized Amortized Investment Description CUSIP/Ticker Name Date TRR-BV Beginning BV Buy Principal Sell Principal Discount Premium Ending By Income-BV Wells Fargo WFSWEEP 49:Tree N/A 0.18 6,255.16 3,403.06 • 0.00 0.00 0.00 9,658.22 3.06 ' Sweep Cash Trust-Fund- • Wells Fargo WFSWEEP 50:CapitalN/A 0.16 4,445,865.03 1,679.53 561,218.44 0.00 0.00 3,886,326.12 1,679.53 Sweep Cash Projects Wells Fargo WFSWEEP 55:Sidewalk N/A 0.17 213,229.59 88.50 0.00 0.00 0.00 213,318.09 88.50 Sweep Cash Fund Wells Fargo 60:Police WFSWEEP State N/A 0.16 215,491.02 79.23 55,118.18 0.00 0.00 160,452.07 79.23 Sweep Cash Seizure Wells Fargo WFSWEEP 62:Federal N/A .0.17 24,627.39 10.20 0.00 0.00 0.00 24,637.59 10.20 Sweep Cash • Police Fund Wells Fargo 64: 1998 Sweep Cash WFSWEEP Cert of N/A 0.17 950,681.97 393.01 3,934.00 0.00 0.00 947,140.98 393.01 Obligation Wells Fargo 67:2003 WFSWEEP Revenue N/A 0.17 6,886,585.72 858,475.59 247,110.35 0.00 0.00 7,497,950.96 2,895.62 Sweep Cash Bonds Wells Fargo 68:2001 Sweep Cash WFSWEEP Cert of N/A 0.16 4,044,877.38 1,572.71 469,192.94 0.00 0.00 3,577,257.15 1,572.71 Obligation 69:2001 Wells Fargo WFSWEEP W&S' N/A 0.00 0.00 8,294,396.50 0.00 0.00 0.00 8,294,396.50 0.00 Sweep Cash Revenue Bond • Wells.Fa rgo 70:2005 Sweep Cash WFSWEEP Refunding/ N/A 0.19 10,118,900.34 3,601.72 10,122,502.06 0.00 0.00 0.00 3,601.72 Mobility Wells Fargo WFSWEEP 95:Property N/A 0.25 - 109,252.90 209,610.83 128,685.18 0.00 0.00 190,178.55 27.14 . Sweep Cash Liability Wells Fargo 97: Sweep Cash WFSWEEP Employee N/A 0.16 70,986.77 24,930.88 31,510.08 0.00 0.00 64,407:57 21.92 Benefit Trust Wells Fargo 99:COP Sweep Cash WFSWEEP Health N/A 0.00 -112,304.47 338,305.09 178,930.12 0.00 0.00 47,070.50 '0.00 Claims Fund Wells Fargo WFSWEEP Z101:Grant N/A -0.02 -7,350.78 8,949.16 48,476.78 0.00 0.00 -46,878.40 0.37 Sweep Cash Fund Wells Fargo WFSWEEP Z105:2007 N/A 0.11 187.50 0.04 187.54 0.00 0.00 0:00 0.04 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z106: 2008 N/A 0.00 -4,793.70 187.54 0.00 0.00 0.00 -4,606.16 0.00 Sweep Cash CDBG'Fund Wells Fargo WFSWEEP Z107:2009 N/A 0.00 -9,781.39 ' 0.00 1,257.75 0.00 0.00 • -11,039.14 0.00 Sweep Cash CDBG Fund 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 BY Income-BV Wells Fargo Z108:'2010 Sweep Cash WFSWEEP CDBG Fund N/A 0.00 -9,824.05 0.00 15,763.03 0.00 0.00 -25,567.08 0.00 Wells Fargo Z116:'CDBG Sweep Cash. WFSWEEP RecoveryN/A- 0.06 11,112.67 1.58 0.00 0.00 0.00 11,114.25 1.58 Fund Wells Fargo -Z120: Mgmt SweepCash WFSWEEP District 1 N/A. 0.13 198,223.98 54.10 197,330.43 0.00 0.00 947.65 53.96 Wells Fargo WFSWEEP Z140: U'of H N/A 0.16 25,305.75 12,595.86 17,741.74 0.00 0.00 20,159.87 6.59 •Sweep'Cash Fund Wells FargoZ150: CashWFSWEEP Hurricane IKE N/A 0.00 11.35 0.00 0.00 0.00 0.00 11.35 0.00 SweeProj Wells Fargo Z200,: 2006 Sweep WFSWEEP Cert of N/A 0.17 2,602,261.44 832,325.34 25,370.70 0.00 0.00 3,409,216.08 1,419.84 Cash Obligation Wells Fargo Z201:2007 Sweep Cash WFSWEEP_ Cert of N/A 0.16 2,201,367.18 734.72 652,671.24 0.00 0.00 1,549,430.66 734.72 Obligation Wells-Fargo Z202: Sweep Cgh WFSWEEP 2007A Gen ,N/A 0.13 3,070,277.16 582.95 2,063,825.40 0.00 0.00 1,007,034.71 582.95 Obligation Wells Fargo Z203:2009 W Wells Fargo WFSWEEP Gen N/A 0.16 5,537,352.82 1,770.36 1,726,016.44 0.00 0.00 3,813,106.74 1,770.36 Sweep Obligation Wells Fargo Z301:,W/S Sweep Cash WFSWEEP' Pay As U Go N/A 0.17 1,230,192.97 1,710.66 2;445.49, 0:00 0.00 1,229,458.14 510.66 GIP Sub- Total/Average 0.16 96,553,280.53 20,302,912.55 35,478,963.58 0.00 0.00 81,377,229.50 36,689.13 Cash CERTIFICATE OF DEPOSIT Wells Fargo 10:General Bank 0.4 CD7579071205 Fund 1/28/2011 0.42 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 314.84 1/28/2011 . Wells Fargo 20:Debt • Bank 0.4 CD7579071205 Services 1/28/2011 0.42 1,000,000.00 - 0.00 1,000,000.00 0.00 0.00 0.00 314.83. 1/28/2011 Wells.Fargo 30:Water at Bank 0.4 CD7579071205 Sewer 1/28/2011 0.42 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 314.83 1/28/2011 Wells Fargo 42:Utility Bank 0.4' CD7579071205, ImpactFee 1/28/2011 , 0.42 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 314.84 1/28/2011 3 of 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.42 4,000,000.00 0.00 . 4,000,000.00 0.00 0.00 0.00 1,259.34 .Certificate-Of Deposit • FHLB BOND FHLB 2 3133XUK93 10:General 9/14/2012 0.64 0.00 1,021,300.00 0.00 0.00 -1,478.11 1,019,821.89 688.55 9/14/2012 Fund FHLB 3:25 31331YC24 30:Water& 4/9/2012 0.51 1,034,730.21 0.00 0.00 0.00 -6,809.85 1,027,920.36 1,315.15 • 4/9/2012 Sewer FHLB 1.375 3133XWKU2 30:Water 6/8/2012 0.46 0.00 1,012,651.96 0.00 0.00 -1,847.19 1,010,804.77 941.00 6/8/2012 Sewer FHLB 0.42 30:Water.& 2/17/2011 3133XYJY2 Sewer 2/17/2011 0.40 1,000,022:40 -0.00 1,000,000.00 0.00 -22.40 0.00 514.27 • FHLB0.875 30:Water& 8/22/2012 3133XYWB7 Sewer 8/22/2012 0.62 0.00.• 1,004,100.37 0.00 0.00 -296.14 1,003,804.23 651.78 FHLB 0.625 3133703Y2 42:Utility 1/12/2012 0.63 1,000,000.00 • 0.00 0.00 0.00 0.00 1,000,000.00 1,562.50 • 1/12/2012 Impact Fee FHLB 42 313372388 42:Utility • 4/13/2012 0.42 1,000,000:00 0.00 . 0.00 0.00 0.00 1,000,000.00 1,050:00 4/13/2012 -Impact Fee FHLB 3.25 3133XPCS1 42>Utility 3/9/2012 0.47 1,032,944.70 0.00 .0.00 0.00 -6,911.48 1,026,033.22 1,213.52 • 3/9/2012- • 'Impact Fee FHLB 4 313371YD2 50:-Capital 12/20/2011 0.40 1;000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,000.00 12/20/ 12/20/.2011-11 ,Projects. HLB. .42 70:-2005 F 0 HLB .4 4/13/2012 •313372388 Refunding/ 4/13/2012 0.42. 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,050.00 Mobility FHLB 3.75 70:;2005 9/9/2011 3133XRY.46 -Refunding/ 9/9/2011 031 1,023;773.09 . 0.00 0.00 0.00 -6,592.68 1,015,180.41 782.32 Mobility • FHLB 1.625 70:2005 7/27/2.011 3133XTXH4 'Refunding/ 7/27/2011 0.47 1,006,659:30 0.00 0.00 •0.00 -2,895.35 1,003,763.95 1,167.15 Mobility FHLB-0.85 70:..2005 5/4/201.1 3133XVLE9 Refunding/ 5/4/2011 0.50 1,001,190.67 0.00 0.00 0:00 -871.22 1,000,319.45 1,253.78 Mobility' FHLB 0. •Z203:2009 FHLB0/4 11 313371YD2 Gen 12/20/2011 0.40 1,000,000.00 0.00 0.00 0:00 0.00 1,000,000.00 , 1,000.00 Obligation • • • Sub Total/Average 0.46 11,099,320.37 3,038,052.33 1,000,000.00 0:00 -29,724.42 13,107,648.28 14,190.02 FHLB,Bond FHLMC BOND - 4 of 6 Portfolio Maturity Annualized Amortized Amortized Investment Description •CUSIP./Ticker Name Date. TRR-BV Beginning By Buy Principal Sell Principal Discount Premium Ending BV Income-BV FHLMC 4.75 3134A4V30 10:General 1/18/2011 0.03 1,002,231.82 0.00 1,000,000.00 0.00 -2,231.82 0.00 11.24 1/18/2011 Fund. 1 FHLMC 0.625 3134G1L51 10: General 6/22/2012 0.27 0.00 1,000,630.00 1,000,000.00 0.00 -78.44 0.00 461.11 6/22/2012-11 Fund FHLMC 0:625 3134G1L51 20:Debt 6/22/2012 0.27 0.00 1,000,630.00 1,000,000.00 0.00 -78.44 0.00 481:11 6/22/2012-11 Services FHLMC,1.5 3137EABW8 30:Water& 1/7/2011 0.45 1,000,182.79 0.00 1,000,000.00 0.00 -182.79 0.00 67.21 1/7/2011 Sewer FHLMC 2:125 3137EABY4 42:Utility 3/23/2012 0.33 0.00 1,020,634.21 0.00 0.00 . -3,132.42 1,017,501.79 586.33 3/23/2012 Impact Fee • 70:2005 FHLMC 2:125 F FHLMC 3137EABY4 Refunding/ 3/23/2012 . 0.33 0.00 1,020,634.20 0.00 0.00 -3,132.42 1,017,501.78 586.33 Mobility FHLMC 1:5 Z200:2006 1/7/2011 3137EABW8 Cert of 1/7/2011 0.45 1,000,182.79 0.00 . 1,000,000.00 0.00 -182.79 0:00 67.21 Obligation • Sub Total/Average 0.29 3,002,597.40 4,042,528.41 5,000,000.00 0.00 • -9,019.12 2,035,003.57 2,280,54 FHLMC BOnd FNMA BOND FNMA 0.5 10:General 10/30/2012 31398A4T6 Fund 10/30/2012 0.00 0.00 1,996,097.64 0.00. 0.00 0.00 1,996,097.64 0.00 FNMA 1.08 10:General 3/30/2012 3139BAK50 Fund 3/30/2012 0.38 1,008,636.09 0.00 0.00 0.00 -1,731.07 1,006,905.02 968.93 FNMA 1.375 31398AWQ1 10: General .4/28/2011 0.53 1,002,752;02 0.00 0.00. 0.00 -2,116.94 1,000,635.08 1,320.56 4/28/201.1 Fund FNMA 0.375 31398A6F4 20:Debt 12/28/2012' 0.66 0.00 994,580:00 0.00 494.87 0.00 995,074.87 1,151.12 12/28/2012 Services FNMA 1.375 31398AWQ1 20.:•.Debt 4/28/2011 0.53 -1,002,752.02 0.00 0.00 0.00 -2,116.94 1,000,635.08 .1,320.56 4/28/2611 Services; • FNMAf2012 31398A4T6 Sewer 10/30:Water&. 10/30/2012 0/2012 0.00 0.00 998,048.82 0.00 0.00 0.00 99998,048.82 0.00 FNMA D.37S 31398A6F4 30 Water& 12/28/2012 0.66 0.00 994,580.00 0.00 494.87 0.00 995,074.87 1,151.12 12/28/2012' 'Sewer FNMA 0.875 31398AB43 30:Water& 1/12/2012 0.32'' 0.00 1,005,444.46- 0.00• .0.00 -1,122.73 1,004,321.73- 651.57 1/12/2012 Sewer FNMA1.08 30:Water 3/30/2012 .31398AK50 Sewer 3/30/2012 • 0.38 1,008,636.09 0.00. 0.00 0.00 1,731.07 1,006,905.02 968.93' 103 o/2/20.S012 31398A4T6' 42: Utility Impact Fee 1D/30 10/30/2012 0.00 0:00 998,048.82 0.00 0.00 0.00 998,048:82 0.00 5of6 . 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.48 4,022,776.22 6,986,799.74 0.00 989.74 -8,818.75 11,001,746.95 7,532.79 FNMA Bond MONEY MARKET 99:COP Wells Fargo MM WF9871 Health N/A 0.04 231,844.50 800,025.13 811,227.57 0.00 0.00 220,642.06 25.13 Claims Fund Sub Total/Average 0.04 231,844.50 800,025.13 811,227.57 0.00 0.00 220,642.06 25.13 Money Market Total•/ 0.22 118,909,819.02 35,1.70,318.16 46,290,191.15 989.74 -47,562.29 107,742,270.36 61,976.95 Average n. 6of6 •City of Pearland Purchases Portfolio/Report Group:,Report Group: Pearland - From 12/31/2010 To 3/31/2011 Portfolio Settlement Maturity Purchase Face YTM @ Name Description ,Bullet/Callable CUSIP/Ticker Action Date Date Price Amount/Shares Cost Principal Interest/Dividends Broker/Dealer 30:.Water FHLB 1.375 Wells Fargo &Sewer 6/8/2012 3133XWKU2 Buy 1/18/2011 6/8/2012 101.265196 1,000,000.00 0.46004 1,012,651.96 1,527.78 Bank 30: Water FNMA 0.875 3139BAB43 Buy 1/18/2011 1/12/2012 100.544446 1,000,000.00 0.32002 1,005,444.46 145.84 Frost Bank &Sewer 1/12/2012 FHLMC 20: Debt 0.625 Yes 3134G1L51 Buy 1/18/2011 6/22/2012 100.063 1,000,000.00 0.58061 1,000,630.00 451.39 Wells Fargo Services 6/22/2012- Bank 11 - FHLMC 10: General 0.625 Wells Fargo Fund 6/22/2012- Yes 3134G1L51 Buy 1/18/2011 6/22/2012 100.063 1,000,000.00 0.58061 1,000,630.00 451.39 Bank 11 20: Debt FNMA 0.375 Comerica Services 12/28/2012 31398A6F4 Buy . 1/28/2011 12/28/2012 99.458 1,000,000.00 0.66003 994,580.00 312.50 Securities 30: Water FNMA 0.375 31398A6F4 Buy 1/28/2011 12/28/2012 99.458 1,000,000.00 0.66003 994,580.00 312.50 Comerica &Sewer 12/28/2012 Securities 42: Utility FHLMC Impact Fee 2.125 - 3137EABY4 Buy 1/28/2011 3/23/2012 102.063421 1,000,000.00 0.33000 1,020,634.21 7,378.47 Frost Bank 3/23/2012 70: 2005 FHLMC t Refunding/ 2.125 3137EABY4 ,Buy 1/28/2011 3/23/2012 102.06342 1,000,000.00 .0.33005 1,020,634.20 7,378.47 Frost Bank Mobility 3/23/2012 10: General FHLB 2 3133XUK93 Buy 2/22/2011 9/14/2012 102.13 1,000,000.00 0.62617 1,021,300.00 8,777.78 First Southwest Fund 9/14/2012 30: Water FHLB 0.875 Wells Fargo &Sewer 8/22/2012 3133XYWB7 Buy 2/22/2011 8/22/2012 100.410037 1,000,000.00 0.60004 1,004,100.37 0.00 Bank 30: Water FNMA 0.5 Comerica &Sewer 10/30/2012 31398A4T6 Buy 3/30/2011 10/30/2012 99.804882 1,000,000.00 0.62402 998,048.82 2,083.33 Securities 42: Utility FNMA 0.5 31398A4T6 Buy 3/30/2011 10/30/2012 99.804882 1,000,000.00 0.62402 998,048.82 2,083.33 Comerica Impact Fee. 10/30/2012 Securities 10: General FNMA-0.5 Comerica Fund 10/30/2012 31398A4T6 Buy 3/30/2011 10/30/2012 99.804882 2,000,000.00 0.62402 1,996,097.64 4,166.67 Securities Page 1 of 1 Pledged Collateral Reconciliation Report March 31, 2011 Bank Account Number Account Name Amount Wells Fargo 201-0419505 Operating $ - Wells Fargo 201-0419513 Payroll Fund - Wells Fargo 001-3042841 Sweep Account 89,464,935.96 Wells Fargo 201-0419554 98 CO Escrow - Wells Fargo 807-1613395 Credit Card Account 2,164,882.41 Wells Fargo 818-4567843 Alvin ISD 5,493,177.64 Wells Fargo 001-3043112 PEDC Sales Tax - Wells Fargo 280-7409871 Health Claims 220,642.06 Wells Fargo Certificate of Deposit - Total of Bank Balances $ 97,343,638.07 Pledged Collateral for City 116,609,270.09 FDIC Insurance 250,000.00 Total Collateral $ 116,859,270.09 Over(Under)Collateralized $ 19,515,632.02 Total%Collateralized 120.0% Bank Account Number Account Name Wells Fargo 100-7284258 Development Authority 1,478,142.00 Total of Bank Balances $ 1,478,142.00 Pledged Collateral for DAP 1,905,479.51 FDIC Insurance 250,000.00 Total Collateral $ 2,155,479.51 Over(Under) Collateralized $ 677,337.51 Total% Collateralized 145.8% Total $ Over(Under)Collateralized $ 20,192,969.53 Total% Collateralized 120.4% Status Collateralized I:\Investments\Investment Reports\City of Pearland\Investment Report-City-Qtr 0311