Loading...
R-2012-058-2012-05-14 RESOLUTION NO. R2012-58 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS, ACCEPTING THE CITY'S INVESTMENT REPORT FOR THE QUARTER ENDING MARCH 2012. 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 2012. PASSED, APPROVED, AND ADOPTED this 14th day of May, A.D., 2012. TOM REID MAYOR ATTEST: Y G L Cl : ' x : SE ETARY APPROVED AS TO FORM: • . 1s1 DARRIN M. COKER CITY ATTORNEY ¢ City of Pearland A �-` Quarterly Investment Report ifiellitittkal z December 31, 2011 - March 31, 2012 Portfolio at December 31,2011 Portfolio at March 31.2012 Ending Book Value 5 95,148,547.04 Ending Book Value $ 95,233,471.83 Ending Market Value 95,199,519.48 Ending Market Value 95,264,219.99 Accrued Interest Receivable 71,045.06 Accrued Interest Receivable 89,811.06 FYD Total Interest Earned 48,081.62 FYD Total Interest Earned 93,560.55 Unrealized Gain/(Loss) 50,972.43 Unrealized Gain/(Loss) 30,748 16 Change in Unrealized Gain/Loss 591.04 Change in Unrealized Gain/Loss (20,224.28) Weighted Average Maturity 80 Days Weighted Average Maturity 83 Days Change in Market Value 9,405,965.30 Change in Market Value 64,700.51 Yield to Maturity at Cost 0.19% Yield to Maturity at Cost 0.18% T-Bill Benchmark 0.12% T-Bill Benchmark 0 19% Agency Note Benchmark 0.04% Agency Note Benchmark 0.09% Average for Quarter City's Yield to Maturity 0.18% 1 Year T-Bill Benchmark Yield 0.17% Agency Note Benchmark Yield 0 10% This quarterly report is in compliance with the investment policy and strategy as established by the City and the Public Funds Investment Act (Chapter 2256,Texas Government Code). Prepared by: Claire Bogard Rick ga rd Fatima Uwakwe Director of Finance Assistant Dir for of Finance Senior Accountant Summary by Type March 31,2012 Description Face Amount 1Shares Cost Value Book Value Market Value YTM @ Cost Days To Maturity Cash $ 64,742,246.95 S 64,742,246.95 5 64,/42,246.95 5 61,742,246.95 0.05% 1 MM 292,144.55 292,144 55 292,14455 292,144,55 0.04% 1 CD 3,477,000.00 3,477,000.00 3,477,000 00 3,471,570.29 0.43% 164 FFCB 1,600,000.00 1,599,850.00 1,599,889.79 1,605,001.20 0.62% 450 FHLB 11,000,000.00 11,231,763.33 11,106,023.73 11,116,063.00 0.42% 192 FHLMC 4,000,000.00 4,012,256.00 4,006,049.59 4,009,721.00 0.36% 355 FNMA 10,000,000.00 10,001,163.48 10,010,117.22 10,027,473.00 0.51% 272 Total/Average $ 95,111,391.50 $ 95,356,424.31 $ 95,233,471.83 $ 95,264,219.99 0.18% 83 Group Portfolio Holdings Book Value by Maturity Y Type e 70,000.W0 _. ... __._. FNMA FHI.MC / 10'd 61,000,000 �0 FHLB 4 12g,, ;.Y FFCB../ 23.900,000 23, CD 13.00';WO 4% F4M � 0% Cash SMI 1.30Da4'31-60 Days 61-000a291-ill Day?,1.190Da4s „180 De45 Interest Rates Date 1_me 3_m.o 6 mo 1 yr ?yr 3_yr Syr Tyr 12yr 7_ yr 30•Lr 12/30/2011 0.01 0.72 r(Jr 0,12 0.25 0.36 0.53 1.35 1.89 2.57 2.89 3/30/2012 0.55 .15 0.1, C.31 0.51 1.0,1 1.61 2.23 3.00 3.35 Yield Curve Comparison 4.00 ,_ _.... .__... 350 2 00 ; _- City'sWeighted Avg Veld.I8% 150 83 Day Average Maturity 1.00 Imo 3mo S rno 1 yr 2 yr Syr Syr 7 yr 10 yr 20 yr 30 yr -4--12/3012011 -If-3/30/2012 Portfolio vs. Benchmarks 0.30% - 0.00% Apr-11 May-I1 Jun-I1 Jul-il Aug-11 Sep-il Oct-11 Nov-11 Dec-11 lan-12 Feb-12 Mar-12 -^-^Port Total -61-1 yr 1-BAI 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/2011,End Date:3/31/2012 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:Genera! N/A C.OS 7,945,779.27 5,607,771.14 0.00 0.00 0.00 13,553,550.41 1,613.40 Sweep Cash Fund Wells Fargc 17:Manlc,20' Sweep Cash WFSWEEP Court N/A C.05 142,852.21 5,080.82 0.00 0.00 0.00 147,933.03 17.85 Securty Wells Fargo 18:City Sweep Cash WFSWEEP Wide N/A C.05 66,183.64 4,620.31 5,483.41 0.00 0.00 65,320.54 8.26 Dcnat or Wells Fargo WFSWEEP 19:Court N/A 0.05 208,771 45 10,003.28 3,023.51 0.00 0.00 215,751.22 25.69 Sweep Cash Technology Wells Fargo WFSWEEP 20.Debt N/A 0.05 14,635,629.25 8,763,641.53 12,451,168.77 0.00 0.00 10,948,102.01 1,712.81 Sweep Cash Services Wells Fargo 23:Court WFSWEEP Cash FSWEEP Juvenile N/A C.05 22,786.61 5,719.04 0.00 0.00 0.00 28,505.65 3.21. Mgm_ Wells Fargo \VeSV+'EEo 30:Water A N/A C.04 9,463,189.713 1,774,483.96 3,459,504.28 0.00 0.00 7,778,169.38 1,017.25 Sweep Cash Sewer Wells Fargo WFSWEEP 31. N/A C.05 245,739.53 102,007.70 0.00 0.00 0.00 347,747.23 37.20 Sweep Cash Solidwaslo Wells Fargo 35:Street Sweep Cash WFSWEEP AssessmentN/A 0.04 591,490.87 50.88 248,000.00 0.00 0.00 343,541.75 50.88 Wells Fargo 42:Utility 'W Sweep Cash FSWEEP Imps-t Fee NIA -0-09 1,250,001.73 2,025,890.03 11,145.20 0.00 0.00 764,743.10 30.28 Wells Fargo 44:Shadow Sweep Cash WFSWEEP Creek N/A G.OS 890,773.04 227,064.28 88,913.50 0.00 0.00 1,028,9233.82 130.16 Impact NJels Fargo Sweep Cash WFSWEEP Ho tel/Motel N/A 0.05 1,393,603.95 118,453.95 315,590.18 0.00 0.00 1,196,377.72 158.59 Occupancy Weis Fargo WFSWEEP 46:Park 0.05 55,313.53 22,736.55 22,804,42 0.00 0.00 66,245.65 6.70 Sweep Cash Donations- Well47:Park& Fargo Sweep Cash WFSWEEP Rec N/A 0.05 1,087,895.47 6,932.50 252,750.00 0.00 0.00 842,077.97 133.24 Deve-c pment l 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-By Weis Fargo U/uSWEEP 49.Tree N/A C-0C 16,066 75 248,000.53 244,950.00 0.00 0.00 19,117.33 0.58 Sweep Cash Trust Fund Wells Fargo 50:Capita' Sweep Cash WFSvEEP Projects N/A 0.05 2,865,572.35 325.97 231,594.99 0.00 0-00 2,634,404.33 325.97 Wells Fargo 55:5,ae',valk Sweep Cash `•ti FSv/EEP F,Irld N/A O.05 216,262.24 26 2.6 3,018.00 0 00 0.00 213,270.50 26.26 Wells Fargo60:Pohen Sweep Cash WFSW EEP State N/A 0.05 201,880.89 62,0,19.03 C.00 0.00 0.00 263,929.92 30.66 Seizure Wells Fargo i y PS'W SEP 62:FederalN/A 0.05 32,140.7C 3.91 0.00 0.00 0.00 32,144.61 3.91 Sweep Cash Police Fund yells Fargo 64:1998 Sweep Cash WFS'W EEP Cott of NIA 0.05 923,583.1E 112.70 0.00 0.00 0.00 923,695.88 112.70 Obigabon Wells Fargo 67:2003 `JJ Sweep Cast FSWEEP Revenue N/A 0.05 9,926,13,1.99 483,778.19 1,292,995.15 0.00 0.00 9,115,918.03 1,115.17 Bonds Wells F3ryc 68:2001 Sweep Cash WF S'WEEP Celt of N/A 0.05 1,950,390.22 657,723.10 692,627.80 0 00 0.00 1,925,485.52 264.41 Obligation Wells Fargo70:2005 Sweep Cash WFSWEEP Refunding/ N/A 0.05 2,072,664.6C 719,599.25 991,705.10 0.00 0.00 1,800,557.75 180.20 Mobility Wets Fargc 1y FSW EEP 95'Property N/A -0.06 -81,972.78 245,907.05 9,357.65 0.00 0.00 154,576.62 6.12 Sweep Cash Liability Welts Fargo 97 Sweep Cash WFSWEEP Employee N/A 0.03 66,119.51 17,300.39 60,446.86 0.00 0.00 22,973.04 1.49 Bene t Trust Fargc 99:COP Wets eepCash WFS'WEEP Heath N;A 0.00 -41,309-35 233,631.02 264,855.47 0.00 0.00 72,543.80 0-00 SClaims Fund Wells Fargo WPSWEEP 2101 Grant N/A 0.00 -41,637.51 59,585.67 129,859.46 0.00 0-00 -111,911.30 0.03 Sweep Cash Fund ty e;ls FW'90 WFSI^JEEP Z105'2007 N/A 0.00 18754 0.00 0.00 0.00 0.00 137.54 0.00 Sweep Cash CDBG Fund we's Fargo W FS'W EEP Z106 2003 Nip, 0 00 1.14 0.00 0.00 0.00 0.00 1.14 0.00 Sweep Cash CDBG Fond We'ils Fargo Z107:2009 Sweep Cash `•�FSW EEP CUeG Fund N/A 0.00 15.61 0.00 0.00 0.00 0.00 15.G1 0.00 Weis Fargo 1•.;:SWEEP Z108:2010 N/A 0 00 835.66 0.00 33,441.61 0.00 0.00 -32,604.95 0.00 Sweep Cash CDBG Fond 2 or 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 CDBG Fund Z1.09r 201'_ Sweep Cash N/A 0.00 -24.80 0.00 5,052.80 0.00 0.00 -5,077.60 0.00 Wells Fargo Z116:CDBG Sweep CashWFSWEEP Recovery N/A 0.00 7.40 0.00 0.00 0.00 0.00 7.40 0.00 Fund Wells Fargo WFSWEEP Z140:U of H NIA 0.05 61,340.74 33,172,88 25,012.79 0.00 0.00 69,500.83 7.47 Sweep Cash Fund WelS Fargo Z200:2006 Sweep Cash WFSWEEP Cert of N/A 0.05 1,924,861.26 225.21 122,786.92 0.00 0.00 1,802,299.55 225.21 Oblig-'ion Wells Fargo Z201:2007 Sweep Cash WFSWEEP Cert of N/A 0.05 1,701,464.58 207.50 1,765.00 0.00 0.00 1,699,907.08 207.50 OohgaUon Wells Fargo Z202. Sweep Cash WFSWEEP 2007A Gen N/A 0.05 3,710,484.28 426.82 305,681.68 0.00 0.00 3,405,229.42 426.82 Obfiga_ion Wells Fargo Z203:2009 Sweep Casn WFSWEEP Gen N/A 0.05 2,436,334.80 259.65 366,539.91 0.00 0.00 2,070,054.54 259.65 Obligation Wells Fargo Z301:w/S Sweep Cash WFSWEEP Pay As U G9 N/A 0.05 1,391,801.46 216,120.55 124,803.54 0.00 0.00 1,483,118.47 167.08 CIP Sub Total/Average 0.05 64,844,313.25 21,662,922.70 21,764,989.00 0.00 0.00 64,742,246.95 8,327.75 Cash CERTIFICATE OF DEPOSIT C DARS 0.75 CD1.012781942 10:Genera: 9/13j2012 0.75 1.00O,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,869.86 9/13/2012 Ftnd Moody National 10:G-enea: Bank 0.6 CO60007130 FVnd 5/30/2012 0.60 245,000.00 0.00 0.00 0.00 0.00 245,000.00 366.50 5/30/2012 21ST CENTURY 10:Genera'. 0.25 CD901365F03 Ford 2/13!2013 0.25 0.00 248,000.00 0.00 0.00 0.00 248,000.00 79.84 2/13/2013 FARMERS& MERCHANTS 20:P_o[ 0.25 CU307812HH3 Services 2/15/2013 0.25 C.00 248,000.00 0.00 C.00 0.00 248,000.00 73.04 2/15/2013 BEAT BANK 0.3 CD07370TKX0 30:Water& 2/13/2013 0.30 0 00 248,000.00 0.00 0.00 0.00 248,000.00 91.73 2/13/2013 Sewer of Portfolio Maturity Annualized Amortized Amortized Investment Description CUSIP/Ticker Name Date TRR-BV Beginning By Buy Principal Sell Principal Discount Premium Ending BV Income-By DISCOVER 35:Street BANK.0.26 CO25467035'4 Assessmect 2/15/2C13 0.25 0.00 248,OCC.00 0.00 0.00 0.00 248,000.00 76.44 2/15/2013 GOLDMAN 44:ShaCon SACHS 0.25 CD38143AJZ9 Creek 2/15/2013 0.25 0.00 248,000_00 0.00 0.00 0.00 248,000.00 76.44 2/15/2013 Impact KEY BANK 0.25 45 2/15/2013 CD493065Pc0 Hotel/5to1u 2/15/2013 0.25 0.00 248,000.00 0.00 0.00 0.00 248,000.00 76.44 Occupancy PACIFIC 47 Park G CONTINENTAL : 0.25 CD69413CCQ3 Rec 2115/20.3 0.25 C.00 248,000.00 0,00 0.00 0.00 248,000.00 76.44 2/15/2013 Development COARS 0.5 67:2003 3/15/2012 CD1012781926 Revenue 3/15/2012 0.5C 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 1,030.57 Bonds PRIVATE BANK 68:2001 0.25 C074269T5K2 Cert.of 2/15/2013 0.25 0.00 248,000.00 0.00 0.00 0.00 248,000.00 76.44 2/15/2013 Obligation APPLE BANK 2202: 0.3 2/22/2013 00037030r59 2007A Gen 2/22/2013 0.30 0.00 248,000.00 0.00 0.00 0.00 248,000.00 77.46 Obligation Sub Total/Average Certificate Of 0.50 2,245,000.00 2,232,000.00 1,000,000.00 0.00 0.00 3,477,000.00 3,971.20 Deposit FFCB BOND FFCB 0.75 10:Gene-al 31331KJ4 0 5/2 5/2/20 13 Fund /'-C13 0.75 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,875.00 F=CB04 31331KZ89 Fund /`FO:Gene,a', 9/20/2013 0.41 599,871.04 0.00 0.00 18.75 0.00 599,889.79 618.75 9/20/2013-12 Sub Total/Average 0.63 1,599,871.04 0.00 0.00 18.75 0.00 1,599,889.79 2,493.75 FFCB Bond FHLB BOND FHLB 3.625 3133XQ334 10:Genoa: 5/29/2013 0.53 1,043,410.13 0.00 0.00 0.00 -7,675.67 1,035,734.46 1,386.83 5/29/201�3 Fund FHLB 2 10:Genera: 9/14/2012 31336UK93 Fund 9/14/2012 0.63 1,009,588.79 0.00 0.00 0.00 -3,411.03 1,006,177.76 1,588.97 4 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-By FHLB 4/9/2012 25 31331YC24 30:Vlater& 4/9/20:2 Sever 0.52 :,007,490.83 0.00 0.00 C.OD -6.809.88 1;OOC,680.98 15.15 4/9)20 FHLB 3.625 30:Water 9 5/29/2013 3133XQU34 S 5/29/2013 Sewer 0.53 1,043,410.13 0.00 0.00 0.00 -7,675.67 1,035,734.46 1,386.83 FHLB 1.375 3133X'wKU2 30:WaterB 6l8J2012 Sewer6/8/2012 0.45 1,003,972.72 0.00 0.00 0.00 -2,277.36 1,O01,69536 1,160.14 FHLB 0.875 3133XYV/67 30:Water 3 8/22/2012 Sewer 8,22/201_7 0.60 1,001,754.05 0.00 0.00 0.00 -683.40 1,001,070.65 1,504.10 FHLB0.625 1/12 3133703Y2 42:Utdty 1/12/2012 0.42 1/12/2C]2 Impact Fee 1,060,O00.0G 0.00 1,000,000.00 0.00 0.00 0.00 138.89 FHLB/132 2012 2 313372368 Impact;Utility 4/13 pact Fee 4/13;2012 0.42 1,O0O,000.O0 0.00 0.00 0.00 0.00 I,000,000.00 1,050.00 FHLB 3.25 3133XPC51 42.Utility 3/9/201? 0.44 1,005,298.80 0.00 1,000,000.00 0.00 -5,298.80 0.00 840.09 3/9/2012 Impact Fee FHLB 1.81 3133XWGP8 42'UtlGty 3726/2013 0.24 3!26/2013 [m pact Fee C.CC 1,G15,528.00 0.00 0.00 -174.13 1,015,453.87 26.98 FHLB 0.2 67:2003 12/13/2012 313376LR4 Revenue 12/13/2012 0.18 C.00 1,000,127.00 0.00 0.00 -1.98 1,000,125.02 20.24 Bonds FHLB 1.625 67:2003 11/21/2012 3133XVEM9 Revenue 11/21/2012 0.16 0.00 1,011,506.00 0.00 0.00 -2,154.83 1,009,351.17 237.54 Bonds FHLB 0.42 70:2005 4/13/2012 3133723E38 Re1uncing/ 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 Sub Total/Average 0.49 10,114,925.45 3,027,261.00 2,000,000.00 0.00 -36,162.72 11,106,023.73 11,705.76 FHLB Bond FHLMC BOND FHLMC 0.4 313463587 Fund 10:Genera'. 4/00 2014 0.47 0.00 996,100.00 0.00 10.12 0.00 998,110.12 51.79 4;28/20: FHLMC 1.125 3137EACK3 20:Debt 7/27/2012 0.12 0.00 1,004,716.00 0.0C 0.00 -1,47898 1,003,237.02 177.27 7/27/2012 Services FHLMC 0.75 3134611365 42!Utility 12/28/2012 0.43 2,006,281.64 C.00 0.00 0.00 -1,579.19 2,004,702.45 2,170.81 12/28/2012 Impact Fee FHLMC 2.125 3137E0B54 42:Ut:3c 3,/23/2012 0.33 1,004,077.12 0.00 1,000,000.00 0.00 -4,077.12 0.00 753.16 3/23/2012 Impact Fee FHLMCFHLMC 2.125 70:2005 012 3137EA654 Re runding/ 3/23/2012 0.33 1,004,077 12 0.00 1,000,000.00 0.00 -4,077.12 0.00 763.16 jof7 Portfolio Maturity Annualized Amortized Amortized Investment Description CUSIP/Ticker Name Date TRR-BV Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income-By M00i'ty Sub Total/Average 0.35 4,014,435.88 2,002,816.00 2,000,000.00 10.12 -11,212.41 4,006,049.59 3,926.19 FHLMC Bond FNMA BOND FNMA 0.75 3135GOAK9 10:Genera. 2 26 013 G 2/26/2013 Fund / /` ,18 0.00 1,006,000.DO 0.00 0.00 -841.27 1,005,158.73 262_90 FNMA2/ 01 3135GOC66 Fund 10:Genera' 9/12/2013 0.60 1,000,000.00 0.00 1,000,000.00 0.00 0.00 C.00 1,183.33 9i12/23-12 FNMA 0.5 31398A4T6 10:Genera: 10/30/2012 0.63 1,997,946.13 0.00 0.00 616,15 0.00 1,998,552.29 3,116.16 10/30/2012 Fund FNMA 1.08 31398AK50 10:Genera! 3/3C/2012 0.40 1,001,711.83 0.00 1,030,000.00 0.00 -1,711,83 0.00 988.17 3/30/2012 Fund FNMA 0.375 20:Debt 12/28/2012 31398A6F4 Services 12/28/2012 0.66 997,195.74 0.00 0.00 706.96 0.00 997,902.70 1,644.45 FNMA 10/22/2013 Sewer 1.05 31398A4S3 30:Water& 1G/2 10/22/2013 0.36 0.00 1,010,780.00 0.00 0.00 -76.32 1,010,703.68 40.35 FNMA05 31398A4T6 30:Water& 10/3C/2012 0.63 998,973.06 0,00 0.00 308.08 000 999,281.14 1,558.08 1C/30/2012 Sewer FNMA 0,375 30:Water& 12;2BR 012 31398A5F4 Sewer 12/28/2012 0.66 997,195.74 0.00 0.00 706.96 0.00 997,902.70 1,644.46 FNMA 0.875 31398A643 30:Water Pi. 1/12/2012 0.30 1,000,169.18 0.00 1,000,000.00 0.00 -169.18 0.00 98.18 1/12/2012 Sewer FNMA 1.08 3 30:Water& 1398AK50 / 3 30/2012 0.40 1,001,711.83 0.00 1,000,000.CO 0.00 -1,711.83 0.00 988.17 3/30/2012 Sewer FNMA 0.8 31398A4T6 Impact Fee 42.Utility10/30/2012 0.63 998,973.06 0.00 0.00 308.08 0.00 999,281.14 1,558.08 10/30/2012 FNMA C.5 70:2C05 10/30(2012 3136FPUC9 Refun3ing/ 10/30/2012 0.39 2,001,892.62 0.00 0.00 0.00 -567.78 2,001,324.8-3 1,932.22 Mobility Sub Total/Average 0.52 11,995,769.19 2,016,780.00 4,000,000.00 2,646.24 -5,078.21 10,010,117.22 15,014.56 FNMA Bond MONEY MARKET 99:COP Wells Fargo MM WF9871 Health N/A 0.04 334,232.23 1,100,039.72 1,142,127.40 0.0C 0.00 292,144.55 39.72 Claims Fund 6ot7 Description oam��° Portfolio Maturity Annualized ^°"^�" ^�"^�" m.���"m �~~_ ~,~ ~�_� �"°. u��"*"o m�r^�*"/ m*"�"*". u*co"* Premium 'nd~vo, mco°"*" s"* -------' ---'----- -----' --� �--�'_--__' °=vw°=Money �� v�^ `��o�o �`o�o,,,z �.`.,'�o^m n�v o�o zvz'�^^s, ,v,z `"t°// A""=y° 0.1895'148'547.0* 32'0*1'819.4231.907.116.*02'6/5.11 '52.453�3495'233'471.8345'*78y3 City of Pearland Quarterly Investment Report at Quarterend Report Format By Transaction Group By:Securt'y Type Portfolio/Report Group:Report Group:Pearland As of 3/31/2012 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 Wets Fargo WFSWEEP 1C:General Sweep Cash Fund 5131/2C06 N/A 0.05000 13,653,550.41 3,553,550.41 13,653,550.41 13,553,550.41 1 N/A 14.25 Wets Fargo 17:Munk,7pai V/ Sweep Cash FSV EEP Court5!31(2006 N/A 0.05000 147,933.03 147,933.03 147,933.03 147,933.03 1 N/A 0.16 Security Wells Fargo 18.City Sweep Cash WFSWEEP wde 5/31/2006 N/A 0.05000 65,320.54 65,320.54 65,320.54 65,320.54 1 N/A 0.07 Donation SneFargo WFSWEEP 19:Court 5/31/2006 N/A 0.05000 215,751.22 215,751.22 215,751.22 215,751.22 1 N/A 0.23 Sweep Cash Technology Wells Fargo WFSWEEP 20:Debt 5/31/2006 N/A 0.05000 10,9,18,102.01 10,948,102.01 10,948,102.01 10,948,102.01 1 N/A 11.51 Sweep Cash Services 23:Court Wells Fargo Sweep Cash FSVd hop Juvenile 9/15/2009 N/A 0.05000 28,505.65 23,505.65 28,505.65 28,505.65 1 7f N/A 0,03 Mgmt Wells Fargo 1vFSWEEP 30:Water& 5/31/2006 N/A 0.05000 7,778,169.38 7,778,169.38 7,778,169.38 7,778,169.38 1 N/A 8.16 Sweep Cash Sewer Wets Fargo WFSyd EEP 317 12/1/2006 N/A 6.05000 347,747.23 347,747.23 347,747.23 347,747.23 1 N/A 0.37 Sweep Cash Soldwaste Wells Fargo WFSWEEP 35:Street 5/31/2006 N/A 0.05000 343,541.75 343,541.75 343,541.75 343,541.75 1 N/A 0.36 Sweep Cash rssessmert Wells Fargo 42:Marry006 NGM/A 0.05000 764,743.10 764,743.10 764,743.10 764,743.10 1 N/A G Sweep Cash WFSWEEP impact Fee 5;31!2 Weis Fargo 44.Shadow Sweep Cash WFSWEEP Creek 5/31/2006 N/A 0.05000 1,028,923.82 1,028,923.82 1,028,923.82 1,028,923.82 1 N/A 1.08 I.mpact 45: 'wells Fargo Sweep Cash WFSWEEP Hotel/Motel 5/31/2006 N/A 0.05000 1,196,377.72 1,196,377.72 1,196,377.72 1,196,377.72 1 N/A 1.25 Occupancy Wells Fargo WFSWEEP 46.Pat 5/31/2005 N/A 0.05000 66,245.66 66,245.66 66,245.66 66,245.66 1 N/A 0.07 Sweep Cash Donations Wells Fargo 47:Park& Sweep Cash WFSWEEP Roc 5/31!2006 N/A 0.05000 842,077.97 842,077.97 842,077.97 842,077.97 1 N/A 0.89 Ceve'loprnent 0t 0 Portfolio Settlement Maturity YTM 4 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 49:Tree Sweep Cash -- EEP Trust Fund 5/31/2006 PTA 0.05000 19,117.33 19,117.33 19,117.33 19,117.33 1 WA 0.02 Wells Fargo WFSWEEP 50:Capital 5/31/2006. N/A 0.05000 2,634,404.33 2,634 404.33 2,634,404.33 2.634,404.33 1 N/A 2 77 Sweep Cash Projects Wells Fargo WFSWEEP 55:SCewal'. 5/31/2006 N/A 0.05006 213,270.50 213,270.50 213,270.50 213,270.50 1 N/A 0.22 Sweep Cash fond Weill Fargo 60:Police sweep Cash WFSWEEP State 5/31/2006 !WA 0.05000 263,92.9.92 263,929.92 263,929.92 253,929.92 1 N/A 0 28 Seizure Wells-Fargo WFSWEEP 62:'Federal 5/31/2006 N/A 0,05000 32,144.61 32,144.61 32,144.61 32,144.61 1 N/A 0.03 Sweep Cash Police Fund 64: 1998 Welk Fargo Sweep Cash WFSWEEP Cat cf 5/31/2006 N/A 0.05000 923,695.38 923,695.88 923,695.88 923,695.88 1 N/A 0.97 Golgatcn 67:2063 Wells Fargo Sweep Cash WFSWEEP Revenue_ 5/31/2005 N/A 0.05CCC 9,116,919-03 9,116,918.03 9,116,918.03 9,116,918.03 1 N/A 9.59 Bonds 68:2001 WetWetFargo Sweep Cash WFSWEEP Led of 5/31/2006 N/A 0.05000 1,925,485.52 1,925,485.52 1,925,485.52 1,925,495.52 1 N/A 2.02 Obliga non 70:2005 Wells Fargo Sweep Cash WFSWEEP Refunding/ 5/31/2006 N/A 0.00336 1,800,557.75 1,800,557.75 1,800,557.75 1,800,557.75 1 N/A 1.89 Ma allay Wells Fargo WFSWEEP 95:Property 10/31/2006 N/A 0.05000 154,576.62 154,576.62 154,576.62 154,576.62 1 N/A 0.16 Sweep Cash Liability Wets Fa'gc 97. Sweep Cash WFSWEEP Employee 9/1/2007 N/A 0.05000 22,973.04 22,973.04 22,973.04 22,973.04 1 N/A 0.02 Benefit Trust 99:COP Wefts Fargo Sheep Cash WFSWEEP Health 9/15/2010 N/A 0.05000 -72,543.30 -72,543.'30 -72,543.80 -72,543.8D 1 N/A -0.08 Claims Fund Wells Fargo W VJFS EEP Z101:Grant 5/31/2006 N/A 0.05000 -111,911.30 -111,911.30 -111,91.1.30 -111,911.30 1 N/A -0.12 Sweep Cash Fund VJeis Fargo V.�FS'NEEP Z105:2007 5/1/2007 N/A 0.05000 187.54 187.54 167.54 187.54 1 N/A 0.00 Sweep Cash CDBG Fund Wells Fargo 2106:2008 Sweep Cash WFSWEEP CDBGFund 3/15/2009 N/A 0.05000 1.14 1.14 1.14 1.14 1 NIA 0.00 WOW Fargo WFSWEEP 2107:2009 11/1/2009 N/A 0.05000 1.5.61 15.61 15.61. 15.61 1 N/A 0..00 Sweep Case. CDBG Fund Wells Fargo Z108:2010 Sweep CashY.'-Sl'JEE? rpEG F-.rnd Slj 1J2C 10 N/A 0.O5000 -32,604.96 -32,604.95 -32,604.95 -32,604.95 1 N/A -0.03 'sf6 Portfolio Settlement Maturity YTM @ Face Days To Accrued Ole of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Wells Fargo VJFSWEEP 2109:2011 12/1/2011 N/A 0.05000 -5,077.60 5,077.60 -5,077.60 -5,077.60 1 N/A -0.01 Sweep Cash CDBG FunC Wen.'Fargo Z116:CDBG Sweep.11 VIFSVJEEP Recovery 7/31/20'79 N/A 0.050G0 7.40 7.40 7.40 7.40 1 Fi/A 0.00 Fund Wells Fargo WFSWEEP 2140-U of H 12/1/2009 N/A 0.05000 69,500.83 69,500.83 69,500.83 69,500.83 1 N/A 0.07 Sweep CaSh Fend V!e!Is Fargo Z200'2006 Sweep Cash WFSWEEP Cart of 6/_0,'2006 P1'A C.US.,OC 1,602,299.55 1,802,299.55 1,802,299.55 1,802,299.55 1 N/A 1.89 Obligation Z201:2007 Wells Far F Sweep Cash WFSV/EEP Cent of 8/31/2006 N/A 0.05000 1,699,907.08 1,699,907.08 1,69_ao 07.08 1,699,907.08 1 N/A 1.79 Oblg3ton Wells Fa o 2002.VI . Sweet Cash FSvI EEP 2007A Gen 12/31/2007 N/A 0.050G0 3,a G5,229.4Z 3,405,229.42 3,405,229.42 3,405,229.42 1 N/A 3.58 Obligation Wells Far Z203:2009 VJ Sweep Cash FSb^JEEP Gen 10730/2008 11/A 0.05000 2,070,054.54 2,070,054.54 2,070,054.54 2,070,054.54 1 N/A 2.18 Obligation Wells Fargo Z301:VJ/S Sweep CashWPSVJEEP Pay A,U Go 12/31/2007 NIA 0.O5000 1,483,116.47 1,483,118.47 7,463,113A7 1,48 ,118.a7 1 N/A S SC CIP Sub Total/ 0.05000 64,742,246.95 64,742,246.95 64,742,246.95 64,742,246.95 1 0.00 68.07 Average Certificate Of Deposit 21ST 10:Genera: CENTURY 0.25 CD901365FD3 Furd 2/13/2012 2/13/20130.25600 248,000.00 248,000.00 243,000.00 247,383.47 319 30.58 0.26 2/13/2013 Moody National Bank C 10:General D60007130 12/1/2011 5/30/2012 0.60000 245,000.00 245,000.00 245,000.00 245,000.00 60 487.32 0.26 0.6 Fund 5/30/2012 C DARS G.75 CD1012781942 lO:General 9/15/2011 9/13/2012 0.75000 1,000,000.00 1,000,000.00 1,000;000.00 1,000,000.00 166 4,068.49 1 05 9;13/2012 Furd FARMERS& MERCHANTS 20:Debt C0307812Hh3 2i17!2012 2/15/2013 C.25000 248,000.00 248,O0O.00 248,000-00 247,392.65 321 73.04 0.2 6 0.25 Services 2/15/2013 BEAL BANK 30:Water& 0.26 0.3 000 73 70 1 600 Sewer 2/15/2012 2313/2013 0.30000 243,000.00 248,000.00 243,000.00 247,465.81 319 91.73 2/13/2013 3of6 Portfolio Settlement Maturity VTM rd Face Days To Accrued P/o of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio DISCOVER 35:Street BANK 0.25 02)2 54 6 7 0 3134 AtiSessm=r. 2/15/2012 2/15/2013 0.25000 248,000.00 248,000.00 248,000.00 247,371.07 321 76.44 0.26 2/15/2013 GOLDMAN 44:Shade, SACHS 0.25 CO38143A1Z9 Creek 2,15/2012 2/15/2013 0.25000 248,000.00 248,000.00 248,000.00 247,371.07 321 76.44 0.26 2/15/2013 Impact KEY BANK 45: 0,25 CD493065PE0 Hote Metei 2/15/2012 2/15/2013 0.25000 248,000,00 248,000.00 248,000.00 247,371.07 321 76.44 0.26 2/15/2013 Occupancy PACIFIC 47:Park 6 CONTINENTAL CD69413CCQ•0 Rec 2/15/2012 2/15/2013 0.25000 248,000.00 248,000.00 248,000.00 2-47,395.13 321 27.18 0.26 0.25 Development 2/15/2013 PRIVATE BANK 68:2001 0.25 CO74269TBK2 Cert of 2/15/2012 2/15/2013 0,25000 248,000.00 248,000.00 248,000.00 247,395.13 321 27.18 0.26 2/15/2013 OtIgatien APPLE BANK 22021 0.3 CD037830FX9 20074 Gen 2/22/2012 2/22/2013 0.30000 248,000.00 248,000.00 248,000.00 247,424.89 323 77.46 0.26 2/22/2013 ObIgahon Sub Total/ 0.42560 3,477,000.00 3,477,000.00 3,477,000.00 3,471,570.29 258 5,112.30 3.66 Average FFCB Bond FFCB 0.4 10:Gzneral 31331KZ89 Fw:d 9,/20/20t! 91 2C(2U13 0.41258 600,O00.00 599,350.00 599,889.79 599,926.20 538 73.33 0.63 9;20/2013-12 FFCB 0.75 31331K]Q4 lO:Goner_=! 5/2/2011 5/2/2013 0.75000 1,000,000.00 1,000,000.00 1,000,000.0E 1,005,075.00 397 3,104.17 1.05 5/2/2013 Fund Sub Total/ 0.62347 1,600,000.00 1,599,850.00 1,599,889.79 1,605,001.20 450 3,177.50 1.68 Average FHLB Bond FHLB 2 3133XUK93 10:Gene-al2/22/2011 9/14/2012 0.62617 1.000,000.00 1,021,300.00 1,006,177.76 1,008,295.00 167 944.44 1.05 9/14/2012 Fund, FHLB 3.625 31330Q5 34 S8,Gener4, 5/31/2011 5/29/2013 0.53011 1.000,000.00 1,061320,00 1,035,734.46 1,038,740.0E 424 12,284.72 1.05 5729/2013 Furd FHLB 3.25 31331YC24 30::'la5e'& 8i 31/2010 4/9/2012 0.50658 1,060,000.00 1,043,810.0E 1,000,680.98 1,000,602.00 9 15,527.78 1.05 4/9/2012 Sewer FHLB 0.875 30.Water&3133 XYW37 2/22/2011 8/22/2012 0.60004 1,000,000.00 1,004,100.37 1,001,070.65 1,002,817.00 144 947.92 1. 05 Si 22/2G12 Sever FHLB 1.375 3133XVIKU2 30.Water& 1/18/2011 6/8/2012 0.4600 4 1,000,000.09 1,012,651.96 1,001,695,36 1,002,244.00 69 4,315.97 1.05 6/8/2012 Sewer 4uth Portfolio Settlement Maturity YTM @ Face Days To Accrued %of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio FHLB 3.625 3133XQ'J34 30 Water 8 5/31/2011 5/29/2013 0.53011 1,000,000.00 1,061,320.00 1,035,734.46 1,038,740.00 424 12,234.72 1.05 5/29/2013 Sewer FHLB0,42 313377366 42'unlity 12/1�`/2010 4/13/2012. 0.42000 1,000,000.00 1,000,000.00 1,000,000.0C 1.000,082.00 13 1,236.67 1.05 4/13/2012 lmpac[Fee FHL6181 3133X'N088 42'1.iuky 3/27/2012 3/26/2013 0.24004 1,000,000.00 1,015,628.00 1,015,453.87 1,015,425.00 360 251.39 1.05 3/26/2013 Impact Fee FHLB 0.2 67.2033 313376LR4 Revenue 3/27/2012 12/13/2012 0.18195 1,000,000.00 1,000,127.00 1,000,125.02 999,967.00 257 600.00 1.05 12/13!20 12 eon••^.s FHLB 1.625 67:2003 11/21;2012 31330VE819 Revenue 2/8/2012 11/21/2012 0.15977 1,000,000.00 1,011,506.00 1,009,351.17 1,009,069.00 235 5,868.06 1.05 Bones FHLB 0.42 70:2005 313372358 Refuneirg/ 12/15/2010 4/13/2012 0.42000 1,000,000.03 1,000,000.00 1,000,000.00 1,000,082.00 13 1,236.67 1.05 4/13/2012 Mobility Sub Total/ 0.42498 11,000,000.00 11,231,763.33 11,106,023.73 11,116,063.00 192 55,498.34 11.57 Average FHLMC Bond FHLMC 0.375 3134G3S87 10:Generl 3/27/2012 4/28/2014 0.46657 1,000,000.00 998,100.0C 998,110.12 998,763.00 753 343.75 1.05 4/2612014 Fund FHLMC 1.125 3137EACK3 `0 Debt 2/8/2012 /27/2012 0.11960 1,000,000.00 1,001,716.00 1,003,237.02 1,002,934.00 118 2,000.00 1.05 7/27/2012 Services FHLMC 0.75 42:Lk 1?Y 3134(31865 6/30/2011 12/28/2012 0.43281 2,000,000.00 2,009,440.00 2,004,702.45 2,007,974.00 272 3,875.00 2.1 0 12/28/2012 Impact Fee 2.2 Sub Total/ 0.36300 4,000,000.00 4,012,256.00 4,006,049.59 4,009,721.00 355 6,218.75 4.21 Average FNMA Bond FNMA 0.75 10:General 313580A59 2/8/2012 212612013 0.17780 1,000,000.00 1,006,000.CD 1,005,158.73 1,004,678.00 332 729.17 1.0 5 2/26/2913 Fcrd FNMA C.5 31398A4'c 10:0ener4' 3,'30!2011 10 30;2012 0.62102 2.000,000.00 1,996,097.64 1,993,562.29 2,003,574.00 213 4,166.67 2.10 10,/30/2012 Fund FNMA C.375 31398A584 20.Ctbt 1/28/2011 12/2€/2012 0.66003 1,000,000.0,0 994,580.00 997,902.70 1,001,737.00 272 968.75 1.05 12128/2012 Services FNMA 1.C5 31398A45.9 30:,Vter& 3/27/2012 0!22;2013 0.35056 1,000,000.00 1,01C,780.00 1,010,703.68 1,009,755.00 570 4,637.50 1 35 1C/22)2013 Sz'+�er FNi-1A0.375 31398A5F4 30,'.eater& 1/28!2011 13/28/2012 0.56003 1,000,000.00 994,580.U0 997,9C 2.70 1,001,737.00 272 968.75 1.05 12 89/20_, Sevrcr FNMA 0.5 31398A T6 ' 'ate;-& 3/30/2011 10j 30;207.2 0.62402 1,000,000.00 99fi,043.82 999,281.14 1,001,787.00 213 2,083.33 1.05 10;30/2012 Ses3�we'Vtir 5ofb Portfolio Settlement Maturity YTM 0 Face Days To Accrued %of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio 10/3 0,5 42:UUiffy 10/30/2012 31398A4T5 impact Fee 3/30/2011 1C/3CJ_C 12 0.6_7 402 1,000,000.00 998,048.82 999,2A i.14 1,001,737.00 213 2,C83.33 1A5 F 70,2005 FNMA 0.5 10/30/2012 3136FPIJC9 Refur00q/ 6/30/2011 10/30/2012 038604 2,000,000.00 2,003,028.20 2,001,324.84 2,002,418.00 213 4,166.67 2.10 Mob ty Sub T0tal/ 0.51266 10,000,000.00 10,001,163.48 10,010,117.22 10,027,473.00 272 19,804.17 10.51 Average Money Market Wet Fa-go 99:COP V1 HeaRh 7/21/2010 N/A. 0.04000 292,144.55 292,144.55 92,144.55 292,144.55 1 N;A 0.31 toe w,9871 Cla rs Fund Sub Total/ 0.04000 292,144.55 292,144.55 292,144.55 292,144.55 1 0.00 0.31 Average Total/ 0.17852 95,111,391.50 95,356,424.31 95,233,471.83 95,264,219.99 83 89,811.06 100 Average 6of6 City of Pearland Credit Ratings Report Format:By Transaction Group By:Security Type Portfolio/Report Group:Report Group:Pearland As of 3/31/2012 Portfolio Security Credit Credit Face Settlement Maturity YTM 0 Days To Name Description CUSIP/Ticker Structure Issuer Rating 1 Rating 2 Amount/Shares Date Date Cost Maturity Certificate Of Deposit Fund 21 215T CENTURY CD90136SFD3 Fixed 21ST CENTURY None None 248,000.00 2/13/2012 2/13/2013 0.25000 319 Fund 0.25 2/13/2013 10:General Moody National Moody National Fund Bank C.6 CD60007130 Fixed Bank None None 245,000.00 12/1/2011 5/30/2012 0.60000 60 5/30/2012 10:General CDARS 0.75 CD101278I942 Feed CDARS None None 1,000,000.00 9/15/2011 9/13/2012 0.75000 166 Fund 9/13/2012 20:Debt FARMERS& FARMERS& Services MERCHANTSC.25 CD307812HH3 Fixed MERCHANTS None None 248,000.00 2/17/2012 2/15/2013 0.25000 321 2/15/2013 30:Water& BEAL BANK 0.3 CD07370TK:{0 Fixed BEAL BANK None None 248,000.00 2/15/2012 2/13/2013 0.30000 319 Sewer 2/13/2013 AssStreit DISCOVER BANK CD2546703U4 Feed DISCOVER None None 243,000.00 2/15/2012 2/15/2013 0.25000 321 Assessment 0.25 2/15/2013 BANK Creek GOLDMAN SACHS CO3S143AJZ9 Fixed GOLDMAN None None 248,000.00 2/15/2012 2/15/2013 0.25000 321 Creek Impact 0.25 2/15/2013 SACHS 45:HoteVMotel KEY BANK 0.25 CD493065PE0 Fixed KEY BANK None None 248,000.00 2/15,2012 2/15/2013 0.25000 321 Occupancy 2/15/2013 PACIFIC PACIFIC 47:Park&Rec CONTINENTAL 0.25 CD69413CCQ0 Fixed None None 248,000.00 2/15/2012 2/15/2013 0.25000 32.1 Development 2�15/2013 CONTINENTAL 68:2001 Cert PRIVATE BANK CD74269TBK2 Fixed PRIVATE BANK None None 248,000.00 2/15/2012 2/15/2013 0.25000 321 of Obligation 0.25 2/15/2013 Z202.2007A APPLE BANK 0.3 C D037830FX9 Fixed APPLE BANK None None 248,000.00 2/22/2012 2/22/2013 0.3,2000 328 Gen Obligation 2/22/2013 Sub Total/ 3,477,000.00 0.42560 258 Average FFCB Bond 10,General FFCB 0.4 31331K769 Fixed FFCB Moodys-Aaa S&P-AA* 600,000.00 9/20/2311 9/20/2013 0.41258 538 Fund 9/2672013-12 Iof3 Portfolio Security Credit Credit Face Settlement Maturity YTM @ Days To Name Description CUSIP/Ticker Structure Issuer Rating 1 Rating 2 Amount/Shares Date Date Cost Maturity IC:General FFC80.75 31331 K1g4 Feed FFCB t400dys-Aaa SSP-AA+ 1,000,000.00 5/0/2011 5/2/2013 0.75000 397 Fund 5!2_,�2013 Sub Total/ 1,600,000.00 0.62347 450 Average FHLB Bond 10:General FHLB 2 9/14/2012 3133XU:K93 Fixed FHLB Moodys-Aaa S&P-AA+ 1,000,000.00 2/22/2011 9/14/2012 0.62617 167 Fund 10:General FHLB 3.625 3133XQU34 Feed FHLB Moodys-Aaa S&P-AA+ 1,000,000.00 5/31/2011 5/29/2013 0.53011 424 Fund 5/29/2013 30:Water& FHLB 3.25 31331YC24 Feed FHLB Moodys-Aaa S&P-AA+ 1,O00,000.00 8/31/2010 4/9/2012 0.50658 9 Sewer 4/9/2012 30:Water& FHLB 0.875 3133XYWB7 Feed FHLB Moodys-Aaa S&P-AA+ 1,000,000.00 2/22/2011 8/22/2012 0.60004 144 Sewer 8/22/2012 30:Water& FHLB 1.375 3133XWKU2 Fixed FHLB Moodys-Aaa S&P-AA+ 1,O00,000.00 1/18/2011 6/8/2012 0.46004 69 Sever 6/8/2012 30:Water& FHLB 3.625 3133XQU34 Feed FHLB Moodys-Aaa S&P-AA+ 1,000,000.00 5/31/2011 5/29/2013 0.53011 424 Sewer 5/29/2013 42:Utility FHLB 0.42 3133723B8 Feed FHLE Moodys-Aaa S&P-AA+ 1,000,000.00 12/15/2010 4/13/2012 0.42000 13 Impact Fee 4/13/2012 42:Utility FHLB 1.81 3133XWGPS Fixed FHLB Moodys-Aaa S&P-AA+ 1,000,000.00 3/27/2012 3/26/2013 0.24004 360 Impact Fee 3/26/2013 67:2003 FHLB 0.2 313376LR4 Feed FHLB Moodys-Aaa S&P-AA+ 1,C00,000.00 3,127/2012 12/13/2012 0.18195 257 Revenue Bonds 12/13/2012 67:2003 FHLB 1.625 3133XVEM9 Fixed FHLB Moodys-Aaa S&P-AA+ 1,0000,000.00 2/8/2012 11/21/2012 0.15977 235 Revenue Bonds 11/21/2012 70:2005 FHLB 0.42 Refunding/ 3133723E3 Feed FHLB Moodys-Aaa S&P-AA+ 1,000,000.G0 12/1572010 4/13/2012 0.42000 13 qJ 13J2012 Mobility Sub Total/ 11,000,000.00 0.42498 192 Average FHLMC Bond 10:General FHLMC 0.375 3134G3SB7 Feed FHLMC Moodys-Aaa S&P-AA+ 1,000,000.00 3/27/2012 4/26/2014 0.46657 758 Fund 4/26/2014 20:Debt FHLMC 1.125 3137EACK3 Feed FHLMC Moodys-Aaa S&P-AA+ 1,000,000.00 2/8/2012 7/27/2012 0.11980 118 Services 7/27/2012 Portfolio Security Credit Credit Face Settlement Maturity 'TM 18 Days To Name Description CUSIP/Ticker Structure Issuer Rating 1 Rating 2 Amount/Shares Date Date Cost Maturity 42:(3011ty FHLMC 0.75 3134G1P65 Fxed FHLMC Moodys-Aaa S&P-AA+ 2,000,000 0i0 6/30/2011 12/28/2012 0.43281 272 Impact Fee 12/28/2012 Sub Total/ 4,000,000.00 0.36300 355 Average FNMA Bond General FNMA 0.75 3135G0AK9 Fixed FNMA Moodys-Aaa S&P-AA+ 1,000,000,00 2/8/2012 2/26/2013 0.17780 332 Fund 2/26/2013 10:Genecal FNMA 0.5 31393A4T6 Fixed FNMA Moodys-Aaa S&P-AA+ 2,000,000.00 3/30/2011 10/30/2012 0.62402 213 Fund 10/30/2012 20.Debt FNMA 0.375 31398A6F4 Fixed FNMA Moodys-Aaa S&P-AA+ 1,000,000.00 1/28/2011 12/28/2012 0.66003 272 Services 12/28/2012 30:Water& FNMA 1.05 31398A4S8 Fixed FNMA Moodys-Aaa S&P-AA+ 1,000,000.00 3/27/2012 10/22/2013 0.36058 570 Sewer 10/22/2013 30:Water& FNMA 0.375 31398A6F4 Fixed FNMA Moodys-Aaa S&P-AA-4- 1,000,000,00 1/28/2011 12/28/2012 0.66003 272 Sewer 12/28/2012 30:Water& FNMA 0.5 31398A4T6 Fixed FNMA Moodys-Aaa S&P-AA+ 1,000,000.00 3/30/2011 10/30/2012 0.62402 213 Sewer 10/30/2012 -- c:UtilityFNMA 0.5 31398A416 Fixed FNMA Moodys-Aaa S&P-AA+ 1,000,000.00 3/30/2011 10/30/2012 0.62402 213 Impact Fee 10/30/2012 70:2005 FNMA 0.5 Refunding/ 10/30/20 12 3136FPUC9 Fixed FNMA Moodys-Aaa S&P-AA+ 2,000,000.00 6/30/2011 10/30/2012 0.38604 213 Mobility Sub Total/ 10,000,000.00 0.51266 272 Average Total/ 30,077,000.00 0.45652 262 Average 3 of 3 City of Pearland Purchases Portfolio/Report Group:Report Group:Pearland From 1/1/2012 To 3/31/2012 Portfolio Settlement Maturity Face YTM p Name Description Bullet/Callable CUSIP/Ticker Action Date Date Price Amount/Shares Cost Principal Interest/Dividends Broker/Dealer 10:General FNMA0.75 3135GOAKi Buy 2/8/2012 2/26/201.3 100.6 1,000,000.03 0.1778E 1,006,000.00 3,375.00 First Southwest Fund 2/26,2013 67:2003 FHL81.625 22Q � t ? c� 475.E9 First Southwest Revenue 11(21/2012 3133XVEM9 Buy /2212 11/21/2012 101.1505 1,000,000.00 0. 5,77 1,011,5_6.00 3, Bonds 20:Debt FHLMC 1.125 3137EACK3 Buy 2/8/2012 7/27/2012 100.4716 1,000,000.00 0.11980 1,004,716.0C 343.75 First Southwest Services 7/27,2012 21ST 10:General CENTURY CD901365FD3 Buy 2/13/2012 2/13;2013 100 248,000.0E 0.20200 24 S,00C.00 0,0E Vining Sparks Fund 0.25 2/13/2013 BEAL BANK 30:Water& 0.3 CD07370TKX0 Buy 2/15/2012 2/13/2013 100 248,000.00 0.30000 248,00E 00 0.00 Vining Sparks Sewer 2/13/2013 45: KEY BANK HotelvMstei 0.25 CD493065PEO Buy 2/15/2012 2/15/2013 100 240,000.00 0.20000 248,000.00 0.00 Vining Sparks Occupancy 2/15,/2013 DISCOVER 35:street BANK 0.25 CO2546703114 Buy 2/15/201.2 2/15/2913 100 248,000.00 025000 248,000.00 0.00 Vining Sparks Assessment 2/15/2013 SiPACIFIC 47:Park Rec CONTINENTAL CD69413CCQ0 Buy 2/15/2012 2/15/2013 100 248,000.00 0.25000 248,000.00 0.00 Vining Sparks Development 0.25 2/15/2013 68:2001 PRIVATE Cert of BANK 0.25 CD74269TBK2 Buy 2/15/2012 2/15/2013 100 248,000.00 025000 248,000.00 0.00 Vining Sparks Obligation 2/15/2013 44:Shadow GOLDMAN 243,000.00 0.0E Vining Sparks Creek SACHS 0.25 CD38143A)29 Buy 2/15/2012 2/15/2013 100 248,000.0E 0.25000 impact 2/15/2013 FARMERS& 20:Debt MERCHANTS C0307812HH3 Buy 2/17/2012 2/15r2013 100 248,000.00 0.2.5000 248,000.00 0.00 Vining Sparks Services 0.25 2/15/2013 2202 APPLE BANK. > 248,000.0E 0.3000E 24II,000.00 E.00 Vining Sparks 2007A Gen 0.3 CD03753C°X9 Buy 2/22/2012 2,2_i 013 10C Obi atlon 2/22/2013 1 of Portfolio Settlement Maturity Face YTM @ Name Description Bullet/Callable CUSIP/Ticker Action Date Date Price Amount/Shares Cost Principal Interest/Dividends Broker/Dealer Duncan 30:Water& FNMA 1.C5 31398A458 Buy 3/27/2012 10/22/2013 101.078 1,000,000.00 0.36058 1,0'_0,780.00 4,520.83 vvIcros Sewer 10/22/2013 10:General FHLMC 0.375 3134G3537 Buy 3/27/2012 4/28/2014 99.81 1,000,000.00 0.46657 998,100.00 302.04 First Southwest Fund 4/28/2014 67:2003 Duncan Revenue 1HLB2/13/2012 313376LR4 Buy 3/27/2012 12/13/2012 100.0127 1,000,000.00 0.18195 1,000,127.00 577'78 Williams Bonds 42:Unity FHLB1.81 Duncan hmpact Fee 3/26/2013 31 33X1N(28 Buy 2/27/201 2 3/26/2013 101.5628 1,000,000.00 0.24004 1,015,628.00 50.28 Williams 2 of 2 .00111•IMMINIIMMINIMA+r Pledged Collateral Reconciliation Report March 31, 2012 Name Amount Bank Account Number Account $ - Wells Fargo 201-0419505 Operating Wells Fargo 201-0419513 Payroll Fund SweepAccount 73,327,278.43 Wells Fargo 001-3G42841 _ Wells Fargo 201-0419554 98 CO Escrow t 471,260.08 Credit Card Account Wells Fargo 807-1613395 5,337,772.26 Wells Fargo 818-4567843 Alvin ISD Wells Fargo 001-3043112 PEDC Sales Tax Health Claims 292,144.55 Wells Fargo 280-7409871 _ Wells Fargo Certificate of Deposit Total of Bank Balances S 79..428,455.32 Pledged Collateral for City 108,544,009.25 FDIC Insurance 250,000.00 Total Collateral S 108,794,009.25 Over(Under)Collateralized $ 29,365,553.93 Total%Collateralized 137.0% Amount Name Bank Account Number Account 2,676,180.25 Wells Fargo 100-7284258 Development Authority Total of Bank Balances $ 2,676,180.25 Pledged Collateral for DAP 10,671,089.06 FDIC Insurance 250.000.00 Total Collateral $ 10,921,089.06 Over(Under)Collateralized $ 8,244,908.81 Total%Collateralized 408.1% Total$Over(Under)Collateralized $ 37,610,462.74 Total%Collateralized 145.8% Status Collateralized I',Irvestments\Investment RepertsiCity cf Pea'land\Investment Repert-City-Otr 0312