Loading...
R-2012-173-2012-12-10RESOLUTION NO. R2012-173 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS, ACCEPTING THE CITY'S INVESTMENT REPORT FOR THE QUARTER ENDING SEPTEMBER 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 September 2012. PASSED, APPROVED, AND ADOPTED this 10th day of December A.D., 2012. ATTEST: APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY TOM REID MAYOR City of Pearland Quarterly investment Report June 30, 2012 - Sept 30, 2012 Period 13 Resolution No.R2012-173 Exhibit "A" Portfolio at Jure 30, 2012 Portfolio at Sept 30. 201Z Ending Book Value Ending Market Value Accrued Interest Receivable FYD Total Interest Earned Unrealized Gain/(Loss) Change in Unrealized Gain/Loss Weighted Average Maturity Change in Market Value Yield to Maturity at Cost T -Bill Benchmark Agency Note Benchmark $ 89,422,699.33 89,445,581.34 49,758.01 133,110.65 22,882.01 (7,866.15) 101 Days (5,818,458.52) 0.19% 0.21% 0.14% Ending Book Value Ending Market Value Accrued Interest Receivable FYD Total Interest Earned Unrealized Gain/(loss) Change in Unrealized Gain/Loss Weighted Average Maturity Change in Market Value Yield to Maturity at Cost T -Bill Benchmark Agency Note Benchmark Average for Quarter City's Yield to Maturity 1 Year T -Bill Benchmark Yield Agency Note Benchmark Yield 0.26% 0.16% 0.15% $ 83,626,352.37 83,648,364.14 76,454.21 367,293.74 22,011.77 (870.24) 106 Days (5,797,217.20) 0.27% 0.17% 0.15% This quarterly report is in compliance with the investment policy and strategy as established by the City and the Public Funds Investment Act (Chapter 2256, Texas Government Code). Prepared by: _i�r_cls Claire Bogard Director of Finance J► J Rick O asak Fatima wakwe Assistant Director of Finance Accounting Supervisor FHLB 7% FHLMC 6%_ FFCB 6% Summary by Type Sept 30, 2012 Description FaceAmouns_LShatet CosiValue Book Value MarkelMalue YTM_PSost Pays To Maturity Cash $ 51,081,222.52 $ 51,081,222.52 $ 51,081,222.52 $ 51,081,222.52 0.17% 1 CD 4,469,000.00 4,469,000.00 4,469,000,00 4,466,970.62 0.36% 247 FFCB 5,000,000.00 5,000,293.48 5,000,268.99 5,004,430.00 0.42% 549 F1-11.8 6,000,000.00 6,149,197.11 6,050,444.32 6,055,222.00 0.30% 135 FNLMC 5,000,000.00 5,006,370.44 4,999,677.24 5,005,182,00 0.37% 346 FNMA 12,000,000.00 12,021,213.48 12,025,739.30 12,035,337.00 0.51% 203 Total/Average 5 83,550,222.52 $ 83,727,297.03 $ 83,626,352.37 $ 83,648,364.14 0.27% 106 CO 5% Group Portfolio Holdings by Type FNMA 15%. Cash 61% 60,000,000 50,000,000 40,000,000 30,000,000 20,000,000 10,000,000 Book Value by Maturity 1.30 0'Y' 31.60 DaYs 61.90 DaYs95 _ 120 Day 21-180 oars ,180 Days Z Interest Rates Qais ins LoBQ Los isl in in in Zaa 10 yr 20 tr 1432 6/29/2012 0.04 0.09 0.16 0.21 0.33 0.41 0.72 1.11 1.67 2.38 2.76 9/28/2012 0.06 0.10 0.14 0.17 0.23 0.31 0.62 1.04 1.65 2.42 2.82 3.00 2.50 2.00 1.50 1.00 0.50 Yield Curve Comparison 0.00..... �.. r» 0.35% 0.30% 0.25% 0.20% 0.15% - 0.10% 0.05% 0.00% 3 r u n..: 1 y 2yr 3yr 5yr Ta,- -4.-6/29/2012 r - -6/29/2012 -1-9/28/2012 Portfolio vs. Benchmarks Dec -11 lan-12 Feb -12 Mar -12 Apr -12 May -12 Jun -12 .1..11 12 Aug -12 Sep 1_ —+—Port Total —t-1 Yr T -Bill -*—Agency Note City of Peartand Quarterly Investment Report Report Format: By CUSH, Group By: Securty Type Portfolio/Report Group: Report Group: Pearland Begin Date: 6/30/2012, End Date: 9/30/2012 Ending Portfolio VTM D Maturity Amortized Amortized Investment Description CUSIP/Tidcer Name Cost Date Beginning RV Buy Principal Sall Principal Discount Premium Ending BV Income -BV CASH Weis Fargo Sweep Cash Weis Fargo Sweep Cash Welk Fargo Sweep Cash Weis Fargo Sweep Cash Weis Fargo Sweep Cash Weis Fargo Sweep Cash Welk Fargo Sweep Cash Weis Fargo Sweep Cash Weis Fargo Sweep Cash Wei Fargo Sweep Cash Weis Fargo Sweep Cash Weis Fargo Sweep Cash We Fargo Sweep Cash Weis Fargo Sweep Cash 1o`7 WFSWEEP 10: General 0.17000 N/A 6,967,598.27 1,336,627.96 2,762,361.51 0.00 0.00 5,541,864.72 2,035.47 Fund 17: Municipal WFSWEEP Court 0.17000 N/A 139,228.95 3,440.12 0.00 0.00 0.00 142,669.07 57.35 Security 18: City WFSWEEP Wide 0.17000 N/A 63,009.23 11,566.49 3,211.26 0.00 0.00 71,364.46 26.20 Donation WFSWEEP 19: Court 0.17000 N/A 228,736.32 14,871.30 0.00 0.00 0.00 243,607.62 96.63 Technology WFSWEEP 20: Debt 0.17000 N/A 7,276,328.37 1,854,224.31 6,496,153.30 0.00 0.00 2,634,399.38 1,141.38 Services 23: Court WFSWEEP Juvenile 0.17000 N/A 31,178.98 5,207.38 0.00 0.00 0.00 36,386.36 14.31 Mgmt WFSWEEP 30: Water& 0.17000 N/A 10,176,693.63 1,442,509.01 5,664,495.35 0.00 0.00 5,954,707.29 2,249.15 Sewer WFSWEEP 31' 0.17000 N/A 290,409.04 678,113.71 26,657.75 0.00 0.00 941,865.00 128.42 Soldwaste WFSWEEP 35: Street 0.17000 N/A 343,582.05 138.67 0.00 0.00 0.00 343,720.72 138.67 Assessment WFSWEEP 42: Utiy 0.17000 N/A 753,444.00 2,085,603.74 141,632.74 0.00 0.00 2,697,415.00 539.72 Impact Fee WFSWEEP 43: Regional 0.17000 N/A 0.00 24,756.46 24,750.00 0.00 0.00 6.46 6.46 Detention 44: Shadow WFSWEEP Creek 0.17000 N/A 3,748,583.23 189,117.05 2,637,133.50 0.00 0.00 1,300,566.78 1,209.88 Impact 45: WFSWEEP Hotel/Motel 0.17000 N/A 1,268,785.15 136,504.17 9,975.46 0.00 0.00 1,395,313.86 564.09 Occupancy WFSWEEP 46: Park 0.17000 N/A 88,839.68 2,724.91 8,614.84 0.00 0.00 82,949.75 33.65 Donations Ending Portfolio YTM 0 Maturity Amortised Amortized Investment Desarytion CUSIP/Tidcer Name Cost Data Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -SV Wells Fargo Fa47: Park & Sweep CashoWFSWEEP Rec 0.17000 Development Well Fargo WFSWEEP 49: Tree 0.17000 Sweep Cash Trust Fund Sweep WFSWEEP Cash Prof ) 0.17000 Wets Fargo WFSWEEP 55: Sidewalk 0.17000 Sweep Cash Fund Wells Fargoo 60: Poke Sweep Cash WFSWEEP State 0.17000 Secure Well Fargo WFSWEEP 62: Federal 0.17000 Sweep Cash Poke Fund WebFargoo 64: 1998 Sweep Cash WFSWEEP Cert of 0.17000 Obligation 67: 2003 Weis Fargo Wr WeisSweep Cash WFSWEEP Revenue 0.17000 Bonds Wets Fargo 68: 2001 Sweep Cash WFSWEEP Cert of 0.17000 Ob&jatlon Well Fargo 70: 2005 Sweep Fargo WFSWEEP Refunding / 0.17000 Mobty Wells Sweep Crash 95: Property WFSWEEPUaity b 0.17000 Wets Fargo 97: Sweep Cash WFSWEEP Employee 0.17000 Benefit Trust Weis Fargo 99: COP Cash WF9871 Claims Health 0.16000 ins Fund Fargo 99: COP Weis Far Sweep Cash WFSWEEP Health 0.17000 Claims Fund Wets FargoWFSWEEP 2101: Grant 0.17000 Sweep Cash Fund 2of7 N/A 831,868.70 81,302.47 220,259.89 0.00 0.00 692,911.28 274.30 N/A 19,083.26 307.65 1,159.00 0.00 0.00 18,231.91 7.65 N/A 2,476,878.23 93,708.66 694,309.63 0.00 0.00 1,876,277.26 773.81 N/A 208,297.15 83.64 3,018.00 0.00 0.00 205,362.79 83.64 N/A 238,875.67 52,207.83 8,041.25 0.00 0.00 283,042.25 100.27 N/A 32,148.38 12.95 0.00 0.00 0.00 32,161.33 12.95 N/A 843,966.15 340.64 0.00 0.00 0.00 844,306.79 340.64 N/A 8,269,312.44 4,240,262.40 405,357.78 0.00 0.00 12,104,217.06 3,787.19 N/A 1,280,157.03503.41 458,607.22 0.00 0.00 822,053.22 450.75 N/A 1,899,151.01 836.89 1,046,531.00 0.00 0.00 853,456.90 589.02 N/A -99,280.03 250,727.60 23,008.92 0.00 0.00 128,438.65 18.25 N/A 39,653.77 65,054.36 68,330.24 0.00 0.00 36,377.89 14.96 N/A 358,698.95 800,112.58 962,099.01 0.00 0.00 196,712.52 112.58 N/A -142,753.72 646,395.70 78,796.40 0.00 0.00 424,845.58 0.00 N/A -100,581.87 185,996.93 228,758.79 0.00 0.00 -143,343.73 0.00 Ending Portfolio YTM @ Matwity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Primal SeN Principal Discount Premium Ending BY Income -BV Weis Fargo WFSWEEP 2105: 2007 0.17000 N/A 187.54 0.06 0.00 0.00 0.00 187.60 0.06 Sweep Cash CDBG Fund We Fargo WFSWEEP 2106: 2008 0.17000 N/A 1.14 0.00 0.00 0.00 0,00 1.14 0.00 Sweep Cash CDBG Fund Wei Fargo WFSWEEP 2107: 2009 0.17000 N/A 15.61 0.00 0.00 0.00 0.00 15.61 0.00 Sweep Cash CDBG Fund We Fargo WFSWEEP Z108: 2010. 0.17000 N/A 0.05 0.00 0.00 0.00 0.00 0.05 0.00 Sweep Cash CDBG Fund Wefts Fargo WFSWEEP Z109: 2011 0.17000 N/A -7,604.22 7,604.22 16,697.97 0.00 0.00 -16,697.97 0.00 Sweep Cash CDBG Fund Wets Fargo Z116: CDBG Sweep Cash WFSWEEP Recovery 0.17000 N/A 7.40 7,195.95 7,195.95 0.00 0.00 7.40 0.00 Fund Wets Fargo WFSWEEP Z140: U of H 0.17000 N/A 79,887.35 19,493.34 13,680.88 0.00 0.00 85,699.81 33.94 Sweep Cash Fund Wets Fargo Z145: Sweep Cash WFSWEEP Municipal 0.17000 N/A 10,468.25 55,130.37 1.2,530.56 0.00 0.00 53,068.06 19.33 Channel W 2200: 2006 Wets Fargo Sweep Cash WFSWEEP Cert of 0.17000 N/A 1,776,680.81 4,970.08 156,222.60 0.00 0.00 1,625,428.29 686.12 Obligation Wets Fargo Z201: 2007 Sweep Cash WFSWEEP Cert of 0.17000 N/A 1,680,365.86 34,724.09 70,871.22 0.00 0.00 1,644,218.73 665.26 Obligation Weis Fargo Z202: Sweep Cash WFSWEEP 2007A Gen 0.17000 N/A 2,672,851.76 988,553.47 75,279.53 0.00 0.00 3,586,125.70 1,389.13 Obligation Wells Fargo Z203: 2009 Sweep Cash WFSWEEP Gen 0.17000 N/A 1,790,336.85 611,490.66 22,924.79 0.00 0.00 2,378,902.72 866.10 Oblgation Wets Fargo Z301: W/S Sweep Cash WFSWEEP Pay As U Go 0.17000 N/A 1,708,640.25 261,389.92 7,652.96 0.00 0.00 1,962,377.21 723.62 C1P Sub Total/Average 0.16996 57,243,730.67 16,193,811.15 22,356,319.30 0.00 0.00 51,081,222.52 19,190.95 Cash CERTIFICATE OF DEPOSIT First Commercial 31.984GCN7 Bank 0.3 3 of 7 10: General 0.30000 8/30/2013 Fund 0.00 248,000.00 0.00 0.00 0.00 248,000.00 0.00 Ending Portfolio YTM D Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Seli Principal Discount Premium Ending BV Income -BV 8/30/2013 CDARS 0.75 10: General 9/13/2012 CD1012781942 Fund 9/13/2012 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 1,541.09 CDARS 0.6 CD1013981872 10: General 0.60000 6/19/2014 500,000.00 0.00 0.00 0.00 0.00 500,000.00 756.17 6/19/2014 Fund Moody National Bank 0.5 CD60007130B 10: Generalfund 0.50000 11/30/2012 245,000.00 0.00 0.00 0.00 0.00 245,000.00 308.77 11/30/2012 21ST CENTURY 0.25 CD90136SFD3 10: General0.25000 2/13/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 Fund 2/13/2013 FARMERS & MERCHANTS CD307812HH3 20: Debt 0.25000 2/15/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.27 0.25 Services 2/15/2013 AMERICAN NATIONAL CD02771PK29 30: Water & 0.25000 5/3/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.27 BANK 0.25 Sewer 5/3/2013 REAL BANK 03 CD07370TKX0 30: Water & 0.30000 2/13/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 187.53 2/13/2013 Sewer CDARS 0.5 001013981856 30: Water & 0.50000 6/20/2013 0.00 500,000.00 0.00 0.00 0.00 500,000.00 410.96 6/20/2013 Sewer SAFRA NATIONAL 00786580350 30: Water& 0.60000 5/5/2014 0.00 248,000.00 0.00 0.00 0.00 248,000.00 244.61 BANK 0.6 Sewer 5/5/2014 DISCOVER 35: Street BANK 0.25 CD2546703U4 Assessment 0.25000 2/15/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 2/15/2013 GOLDMAN 44: Shadow SACHS 0.25 CD38143A3Z9 Creek 0.25000 2/15/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 2/15/2013 Impact KEY BANK 0.25 45: 2/15/2013 CD49306SPE0 HoteVMotel 0.25000 2/15/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 Occupancy PACIFIC 47: Park & CONTINENTAL C069413CCQ0 Rec 0.25000 2/15/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 0.25 2/15/2013 Development 4of7 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Tidcer Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV MIZUHO CORP 67: 2003 BANK 0.3 CD60688TBR9 Revenue 0.30000 5/2/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 187.53 5/2/2013 Bonds PRIVATE BANK 68: 2001 0.25 C074269T3K2 Cert of 0.25000 2/15/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 2/15/2013 Obligation APPLE BANK 0.3 Z202: 2/22/2013 CD037830FX9 2007A Gen 0.30000 2/22/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 187.53 Obfgation Sub Total/Average 0.36136 4,473,000.00 996,000.00 1,000,000.00 0.00 0.00 4,469,000.00 5,074.41 Certificate Of Deposit FFCB BOND FFCB 0.75 5/2/2013 FFCB 0.4 9/20/2013-12 FFCB 0.3 7/18/2014 FFCB 0.25 1/30/2014-12 FFCB 0.34 4/23/2014-12 FFCB 0.48 12/26/2014-13 Sub Total/Average FFCB Bond FHLB BOND FHLB 3.625 5/29/2013 FHLB 2 9/14/2012 FHLB 0 10/24/2012 5of7 31331KIQ4 31331K289 3133EAYL6 3133 EAA73 3133EAM34 3133EAV34 10: General Fund 10: General Fund 10: General Fund 30: Water& Sewer 42: Utility Impact Fee 67: 2003 Revenue Bonds 3133XQU34 3133XUK93 313384180 10: General Fund 10: General Fund 20: Debt Services 0.75000 5/2/2013 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,875.00 9/20/2013 599,908.33 0.00 600,000.00 16.67 0.00 0.00 625.00 0.28461 7/18/2014 0.00 1,000,293.48 0.00 0.00 -24.49 1,000,268.99 467.18 0.25000 1/30/2014 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 409.73 0.34000 4/23/2014 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 28.34 0.48000 12/26/2014 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,200.00 0.42091 2,599,908.33 3,000,293.48 600,000.00 16.67 -24.49 5,000,268.99 4,605.25 0.53011 5/29/2013 1,028,058.80 0.00 0.00 0.00 -7,675.66 1,020,383.14 1,386.84 9/14/2012 1,002,804.63 0.00 1,000,000.00 0.00 -2,804.63 0.00 1,306.48 0.14243 10/24/2012 999,548.89 0.00 0.00 357.78 0.00 999,906.67 357.78 Ending Portfo8o YTM ® Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BY Buy Principal Sell Principal Discount Premium Ending BV Income -BV FHLB 3.625 3133XQU34 30: Water 8c 0.53011 5/29/2013 1,028,058.80 0.00 0.00 0.00 -7,675.66 1,020,383.14 1,386.84 5/29/2013 Sewer FHLB 0.875 3133XYW87 30: Water & 8/22/2012 1,000,394.85 0.00 1,000,000.00 0.00 -394.85 0.00 869.04 8/22/2012 Sewer FHLB 1.81 3133XWGP8 42' Utility 0.24004 3/26/2013 1,011,579.52 0.00 0.00 0.00 -3,917.88 1,007,661.64 607.12 3/26/2013 Impact Fee FHLB 0.2 67: 2003 12/13/2012 313376LR4 Revenue 0.18195 12/13/2012 1,000,080.86 0.00 0.00 0.00 -44.65 1,000,036.21 455.35 Bonds FHLB 1.625 67: 2003 11/21/2012 3133XVEM9 Revenue 0.15977 11/21/2012 1,005,732.67 0.00 0.00 0.00 -3,659.15 1,002,073.52 403.35 Bonds Sub Total/Average 0.30165 8,076,259.02 0.00 2,000,000.00 357.78 -26,172.48 6,050,444.32 6,772.80 FHLB Bond FHLMC BOND FHLMC 0 313397DU2 10: General 0.17257 4/1/2013 998,701.39 0.00 0.00 434.44 0.00 999,135.83 434.44 4/1/2013 Fund FHLMC 0.375 3134G3SB7 10: General 0.46657 4/28/2014 998,335.29 0.00 0.00 227.69 0.00 998,562.98 1,165.19 4/28/2014 Fund FHLMC 1.125 3137EACK3 20: Debt 7/27/2012 1,000,753.44 0.00 1,000,000.00 0.00 -753.44 0.00 90.31 7/27/2012 Services FHLMC 0.75 3134G1P65 42' Ut 1, 0.43281 12/28/2012 2,003,12327 0.00 0.00 0.00 -1,579.18 2,001,544.09 2,170.82 12/28/2012 Impact Fee FHIMC 0.35 67: 2003 12/5/2014 3134G3H78 Revenue 0.33000 12/5/2014 0.00 1,000,436.00 0.00 0.00 -1.66 1,000,434.34 27.50 Bonds Sub Total/Average 0.36710 5,000,913.39 1,000,436.00 1,000,000.00 662.13 -2,334.28 4,999,677.24 3,888.26 FHLMC Bond FNMA BOND FNMA 0.75 3135GOAK9 10: General 0.17780 2/26/2013 1,003,746.03 0.00 0.00 0.00 -1,428.57 1,002,317.46 446.43 2/26/2013 Fund FNMA 0.5 3136GOFF3 10. General 0.50000 10/30/2014 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,250.00 10/30/2014-13 Fund FNMA 0.5 31398A4T6 10-���! 0.62402 10/30/2012 1,999,178.45 0.00 0.00 616.16 0.00 1,999,794.61 3,116.16 10/30/2012 Fund 9 6 of 7 Ending Portfolio YTM Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Prindpal San Principal Discount Premium Ending BV Inoome-BV FNMA 0.375 31398A6F4 20' Debt 12/28/2012 998,601.80 0.00 0.00 706.95 0.00 999,308.75 1,644.45 12/28/2012 Services FNMA 1.3 3136FPWZ6 30: Water & 0.46187 11/17/2014 1,019,818.74 0.00 0.00 0.00 -2,081.32 1,017,737.43 1,168.69 11/17/2014 Sewer FNMA 1.05 31398A458 30: Water& 0.36058 10/22/2013 1,009,005.59 0.00 0.00 0.00 -1,717.17 1,007,288.42 907.83 10/22/2013 Sewer FNMA 0.5 31398A4T6 30: Water Sc 0.62402 10/30/2012 999,589.23 0.00 0.00 308.08 0.00 999,897.31 1,558.08 10/30/2012 Sewer FNMA 0.375 31398A6F4 30: Water& 0.66003 12/28/2012 998,601.80 0.00 0.00 706.95 0.00 999,308.75 1,644.45 12/28/2012 Sewer FNMA 0.5 31398A4T6 42. Utility 0.62402 10/30/2012 999,589.23 0.00 0.00 308.08 0.00 999,897.31 1,558.08 10/30/2012 Impact Fee FNMA 0.5 70: 2005 2012 3136FPUC9 Refunding / 0.38604 10/30/2012 2,000,757.05 0.00 0.00 0.00 -567.79 2,000,189.26 1,932.21 10/30/Mobity Sub Total/Average 0.50676 12,028,887.92 0.00 0.00 2,646.22 -5,794.84 12,025,739.30 15,226.38 FNMA Bond Total / Average 7 of 7 0.26498 89,422,699.33 21,190,540.63 26,956,319.30 3,682.80 -34,326.09 83,626,352.37 54,75&05 10 City of Pearland Quarterly Investment Report at Quarterend Report Format: By Transaction Group By: Security Type Portfolio/Report Group: Report Group: Peariand As of 9/30/2012 Portfolio Settlement Maturity VTM Face Days To Accrued % of Desolation CUSIP/Ticker 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.170 5,541,864.72 5,541,864.72 5,541,864.72 5,541,864.72 1 6.63 Sweep Cash Fund Weis Fargo 17: Municipal Sweep Cash WFSWEEP Court 5/31/2006 N/A 0.170 142,669.07 142,669.07 142,669.07 142,669.07 1 0.17 Security Weis Fargo 18: Cly Sweep Cash WFSWEEP Wide 5/31/2006 N/A 0.170 71,364.46 71,364.46 71,364.46 71,364.46 0.09 Donation Web eepFa as°h WFSWEEP T urt 5/31/2006 N/A 0.170 243,607.62 243,607.62 243,607.62 243,607.62 1 0.29 S echnology Wets FargoWFSWEEP 20' Debt5/31/2006 N/A 0.170 2,634,399.38 2,634,399.38 2,634,399.38 2,634,399.38 1 3.15 Sweep Cash Services Wes Fano 23: Court Sweep Cash WFSWEEP Juvenile 9/15/2009 N/A 0.170 36,386.36 36,386.36 36,386.36 36,386.36 1 0.04 Mgmt Weis Fargo WFSWEEP 30: Water& 5/31/2006 N/A 0.170 5,954,707.29 5,954,707.29 5,954,707.29 5,954,707.29 1 7.13 Sweep Cash Sewer Wells Fargo WFSWEEP 31: 12/1/2006 N/A 0.170 941,865.00 941,865.00 941,865.00 941,865.00 1 1.13 Sweep Cash Soedwaste We Fargo WFSWEEP 35: Street 5/31/2006 N/A 0.170 343,720.72 343,720.72 343,720.72 343,720.72 0.41 Sweep Cash Assessment vele Fargo WFSWEEP 42: UtiRy 5/31/2006 N/A 0.170 2,697,415.00 2,697,415.00 2,697,415.00 2,697,415.00 3.23 Sweep Cash Impact Fee Weis Fargo WFSWEEP 43: Regional 5/31/2006 N/A 0.170 6.46 6.46 6.46 6.46 1 0.00 Sweep Cash Detention Was Fargo C4: Shadow Sweep Cash WFSWEEP Creek 5/31/2006 N/A 0.170 1,300,566.78 1,300,566.78 1,300,566.78 1,300,566.78 1.56 Impact Weis Fargo 45: WFSWEEP motel/Motel 5/31/2006 N/A 0.170 1,395,313.86 1,395,313.86 1,395,313.86 1,395,313.86 1.67 Sweep Cash Occupancy Welt Fargo WFSWEEP 46: Park 5/31/2006 N/A 0.170 82,949.75 82,949.75 82,949.75 82,949.75 0.10 Sweep Cash Donations t 1 of6 Portfolio Settlement Maturity \TM ® Face Days To Accrued Vs of Description CUSIP/TIcker Name Date Date Cost Amount/Shares Cort Value Book Value Market Value Maturity Interest Portfolio Wels Fargo 47: Park & Sweep Cash WFSWEEP Rec 5/31/2006 N/A 0.170 692,911.28 692,911.28 692,911.28 692,911.28 0.83 Development Wels Fargo WFSWEEP 49: Tree 5/31/2006 N/A 0.170 18,231.91 18,231.91 18,231.91 18,231.91 0.02 Sweep Cash Trust Fund We Fargo WFSWEEP 50: Capital 5/31/2006 N/A 0.170 1,876,277.26 1,876,277.26 1,876,277.26 1,876,277.26 2.25 Sweep Cash Projects were Fargo WFSWEEP 55: Sidewalk 5/31/2006 N/A 0.170 205,362.79 205,362.79 205,362.79 205,362.79 0.25 Sweep Cash Fund W 60: Police Wes Fargo WFSWEEP State 5/31/2006 N/A 0.170 283,042.25 283,042.25 283,042.25 283,042.25 0.34 Sweep Cash Setzure Welk Fargo WFSWEEP 62: Federal 5/31/2006 N/A 0.170 32,161.33 32,161.33 32,161.33 32,161.33 1 0.04 Sweep Cash Police Fund Wells Fargo 64: 1998 Sweep Cash WFSWEEP Cert of 5/31/2006 N/A 0.170 844,306.79 844,306.79 844,306.79 844,306.79 1 1.01 Obligation Welk Fargo 67: 2003 Sweep Cash WFSWEEP Revenue 5/31/2006 N/A 0.170 12,104,217.06 12,104,217.06 12,104,217.06 12,104,217.06 14.49 Bonds Welk Fargo 68: 2001 Sweep Cash WFSWEEP Cert of 5/31/2006 N/A 0.170 822,053.22 822,053.22 822,053.22 822,053.22 1 0.98 Obligation 70Welk Fargo Ref 2065 Sweep Cash WFSWEEP Refunding / 5/31/2006 N/A 0.170 853,456.90 853,456.90 853,456.90 853,456.90 1.02 Mobility Wets Fargo WFSWEEP 95: Property 10/31/2006 N/A 0.170 128,438.65 128,438.65 128,438.65 128,438.65 1 0.15 Sweep Cash Uabltty Wens Fargo 97: Sweep Cash WFSWEEP Employee 9/1/2007 N/A 0.170 36,377.89 36,377.89 36,377.89 36,377.89 1 0.04 Benefit Trust Welk Fargo 99: COP WFSWEEP Heath 9/15/2010 N/A 0.170 424,845.58 424,845.58 424,845.58 424,845.58 1 0.51 Sweep Cash Claims Fund Wells Fargo 99: COP Cash WF9871 Health 7/21/2010 N/A 0.160 196,712.52 196,712.52 196,712.52 196,712.52 1 0.24 Claims Fund Welk Fargo WFSWEEP 2101: Grant 5/31/2006 N/A 0.170 -143,343.73 -143,343.73 -143,343.73 -143,343.73 1 -0.17 Sweep Cash Fund We Fargo WFSWEEP Z105: 2007 5/1/2007 N/A 0.170 187.60 187.60 187.60 187.60 1 0.00 Sweep Cash CDBG Fund 2 of 6 1 Z Portfolio Settlement Maturity YTM 0 Face Days To Accrued % of Description CUSIP/Tidcer Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Welk Fargo WFSWEEP Z106: 2008 3/15/2009 N/A 0.170 1.14 1.14 1.14 1.14 1 0.00 Sweep Cash CDBG Fund Wells Fargo 2107: 2009 WFSWt:EP 11/1/2009 N/A 0.170 15.61 15.61 15.61 15.61 0.00 Sweep Cash CDBG Fund Wells Fargo 2108: 2010 WFSWEEP 11/1/2010 N/A 0.170 0.05 0.05 0.05 0.05 0.00 Sweep Cash CDBG Fund Welts Fargo WFSWEEP Z109: 2011 12/1/2011 N/A 0.170 -16,697.97 -16,697.97 -16,697.97 -16,697.97 -0.02 Sweep Cash CDBG Fund ets Fargo Z116: CDBG W Wets Fa Cash WFSWEEP Recovery 7/31/2009 N/A 0.170 7.40 7.40 7.40 7.40 0.00 Sweep Fund We Fargo WFSWEEP Z140: U of H 12/1/2009 N/A 0.170 85,699.81 85,699.81 85,699.81 85,699.81 1 0.10 Sweep Cash Fund Welts Fargo 2145: Sweep Cash WFSWEEP Municipal 4/15/2012 N/A O.I70 53,068.06 53,068.06 53,068.06 53,068.06 1 0.06 Channel Wells Fargo Z200: 2006 Sweep WFSWEEP Cert of 6/30/2006 N/A 0.170 1,625,428.29 1,625,428.29 1,625,428.29 1,625,428.29 1.95 Cash Magellan n Wells Fargo Z201: 2007 W W018 r Cash WFSWEEP Cert of 8/31/2006 N/A 0.170 1,644,218.73 1,644,218.73 1,644,218.73 1,644,218.73 1.97 SweepObligation Wells Fargo 2007: Sweep Cash WFSWEEP 2007A Gen 12)31(2007 N/A 0.170 3,586,125.70 3,586,125.70 3,586,125.70 3,586,125.70 4.29 Obligation Wei Fargo Z203: 2009 Sweep Cash WFSWEEP Gen 10/30/2008 N/A 0.170 2,378,902.72 2,378,902.72 2,378,902.72 2,378,902.72 1 2.85 Oblgation Wellss Fargo 2301: W/S Sweep Cash WFSWEEP Pay As U Go 12/31/2007 N/A 0.170 1,962,377.21 1,962,377.21 1,962,377.21 1,962,377.21 1 2.35 CIP Sub Total / Average Certificate Of Degas 21ST CENTURY 0.25 2/13/2013 CD901365FD3 10: General fund 0.170 51,081,222.52 51,081,222.52 51,081,222.52 51,081,222.52 1 0.00 61.14 2/13/2012 2/13/2013 0.250 248,000.00 248,000.00 248,000.00 247,865.34 136 28.88 0.30 CDARS 0.6 CD1013981872 30: General 6/21/2012 6/19/2014 0.600 500,000.00 500,000.00 500,000.00 500,000.00 627 830.14 0.60 6/19/2014 FtmC 3 of6 Fortioro Settlement Maturity YTM Face Days To Accrued Wo of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio First Commercial 31984GCN7 10: General 8/30/2012 8/30/2013 0300 248,000.00 248,000.00 248,000.00 247,390.42 334 0.00 0.30 Bank 0.3 Fund 8/30/2013 Moody National 10: General Bank 0.5 C06000713013 Fund 5/30/2012 11/30/2012 0.500 245,000.00 245,000.00 245,000.00 245,000.00 61 412.81 0.29 11/30/2012 FARMERS & MERCHANTS CD307B12HH3 20: Debt 2/17/2012 2/15/2013 0.250 248,000.00 248,000.00 248,000.00 247,869.30 138 383.89 0.30 0.25 Services 2/15/2013 CDARS 0.5 C01013981856 30: Water & 8/1/2012 6/20/2013 0.500 500,000.00 500,000.00 500,000.00 500,000.00 263 691.78 0.60 6/20/2013 Sewer SAFRA NATIONAL CD786580150 30: Water & 8/1/2012 5/5/2014 0.600 248,000.00 248,000.00 248,000.00 248,355.88 582 611.51 0.30 BANK 0.6 Sewer 5/5/2014 AMERICAN NATIONAL C002771PKZ9 30: Water& 5/3/2012 5/3/2013 0.250 248,000.00 248,000.00 248,000.00 247,708.35 215 254.79 0.30 BANK 0.25 Sewer 5/3/2013 / BANK 0.3 CD07370TKX0 30: water& 2/15/2012 2/13/2013 0.300 248,000.00 248,000.00 248,000.00 247,899.31 136 464.75 0.30 213 2/13/2013 Sewer DISCOVER 35: Street BANK 0.25 CD2546703U4 Assessment 2/15/2012 2/15/2013 0.250 248,000.00 248,000.00 248,000.00 247,860.13 138 387.29 0.30 2/15/2013 GOLDMAN 44: Shadow SACHS 0.25 C0381434129 Creek 2/15/2012 2/15/2013 0.250 248,000.00 248,000.00 248,000.00 247,860.13 138 387.29 0.30 2/15/2013 Impact KEY BANK 0.25 45: 2/15/2013 CD493065PE0 HoteVMotel 2/15/2012 2/15/2013 0.250 248,000.00 248,000.00 248,000.00 247,860.13 138 387.29 0.30 Occupancy PACIFIC 47: Park & CONTINENTAL C069413CCQ0 Rec 2/15/2012 2/15/2013 0.250 248,000.00 248,000.00 248,000.00 247,871.04 138 25.48 0.30 0.25 Development 2/15/2013 MIZUHO CORP 67: 2003 BANK 0.3 CD60688TBR9 Revenue 5/2/2012 5/2/2013 0.300 248,000.00 248,000.00 248,000.00 247,672.64 214 307.79 0.30 5/2/2013 Bonds PRIVATE BANK 68: 2001 0.25 CD74269TBK2 Cert of 2/15/2012 2/15/2013 0.250 248,000.00 248,000.00 248,000.00 247,871.04 138 25.48 0.30 2/15/2013 Obligation APPLE BANK 0.3 2202: 2/22/2013 CD037830FX9 20074 Gen 2/22/2012 2/22/2013 0.300 248,000.00 248,000.00 248,000.00 247,886.91 145 450.48 0.30 4of6 Portfolio Settlement Maturity ¥TM ® Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Obligation Sub Total / 0.361 4,469,000.00 4,469,000.00 4,469,000.00 4,466,970.62 247 5,649.65 5.35 Average FFCB Bond FFCB 0.3 3133EAYL6 10: General 8/1/2012 7/18/2014 0.285 1,000,000.00 1,000,293.48 1,000,268.99 1,000,105.00 656 600.00 1.20 7/18/2014 Fund FFCB 0.75 3133110Q4 10: General 5/2/2011 5/2/2013 0.750 1,000,000.00 1,000,000.00 1,000,000.00 1,003,102.00 214 3,083.33 1.20 5/2/2013 Fund FFCB 0.25 3133EAA73 30: water & 8/1/2012 1/30/2014 0.250 1,000,000.00 1,000,000.00 1,000,000.00 999,017.00 487 416.67 1.20 1/30/2014-12 Sewer FFCB 0.34 3133EAMJ4 42. Utley 9/27/2012 4/23/2014 0.340 1,000,000.00 1,000,000.00 1,000,000.00 1,000,009.00 570 1,482.78 1.20 4/23/2014-12 Impact Fee FFCB 0.48 67: 2003 Revenue 12/26/2014-13 3133EAV14 6/26/2012 12/26/2014 0.480 1,000,000.00 1,000,000.00 1,000,000.00 1,002,197.00 817 1,253.33 1.20 Bonds Sub Total / 0.421 5,000,000.00 5,000,293.48 5,000,268.99 5,004,430.00 549 6,836.11 5.98 Average FHLB Bond FHLB 3.625 5/29/2013 FHLB 0 10/24/2012 FHLB 3.625 5/29/2013 FHLB 1.81 3/26/2013 FHLB 0.2 12/13/2012 FHLB 1.625 11/21/2012 3133XQU34 313384180 3133XQU34 3133XWGP8 313376LR4 10: General Fund 20: Debt Services 30: Water & Sewer 42: Unity Impact Fee 67: 2003 Revenue Bonds 67: 2003 3133XVEM9 Revenue Bonds Sub Total / Average FHLMC Bond FHLMC 0 4/1/2013 5 of 6 5/31/2011 5/29/2013 0.530 1,000,000.00 1,061,320.00 1,020,383.14 1,022,615.00 241 12,184.03 1.20 4/26/2012 10/24/2012 0.142 1,000,000.00 999,296.11 999,906.67 999,987.00 24 0.00 1.20 5/31/2011 5/29/2013 0.530 1,000,000.00 1,061,320.00 1,020,383.14 1,022,615.00 241 12,184.03 1.20 3/27/2012 3/26/2013 0.240 1,000,000.00 1,015,628.00 1,007,661.64 1,007,960.00 177 201.11 1.20 3/27/2012 12/13/2012 0.182 1,000,000.00 1,000,127.00 1,000,036.21 1,000,040.00 74 594.44 1.20 2/8/2012 11/21/2012 0.160 1,000,000.00 1,011,506.00 1,002,073.52 1,002,005.00 52 5,822.92 1.20 0.297 6,000,000.00 6,149,197.11 6,050,444.32 6,055,222.00 135 30,986.53 7.18 31339701.12 F0 General 4/26/2012 4/1/2013 0.173 1,000,000.00 998,394.44 999,135.83 999,444.00 183 0.00 1.20 Portfolio Settlement Maturity vim L3 Face Days To Accrued % of Description CUSIP/Tldker Name Data Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio FHLMC 0.375 3134G3SB7 FurW antral 3/27/2012 4/28/2014 0.467 1,000,000.00 998,100.00 998,562.98 1,001,888.00 575 2,208.33 1.20 4/28/2014 FHLMC 0.75 3134G1P65 42: UnleY 6/30/2011 12/28/2012 0.433 2,000,000.00 2,009,440.00 2,001,544.09 2,002,850.00 89 3,833.33 2.39 12/28/2012 Impact Fee 67: 2003 FHLMC 0.35 3134G3H78 Revenue 9/27/2012 12/5/2014 0.330 1,000,000.00 1,000,436.00 1,000,434.34 1,001,000.00 796 320.83 1.20 12/5/2014 Bonds Sub Total / Average FNMA Bond FNMA 0.5 10/30/2014-13 FNMA 0.75 2/26/2013 FNMA 0.5 10/30/2012 FNMA 0.375 12/28/2012 FNMA 1.05 10/22/2013 FNMA 0.375 12/28/2012 FNMA 0.5 10/30/2012 FNMA 1.3 11/17/2014 FNMA 0.5 10/30/2012 FNMA 0.5 10/30/2012 3136GOFF3 3135GOAK9 31398A4T6 31398A6F4 31398A458 31398A6F4 31398A4T6 3136FPWZ6 31398A4T6 3136FPUC9 10: General Fund 10: General Fund 10: General Fund 20: Debt Services 30: Water & Sewer 30: Water& Sewer 30: Water & Sewer 30: Water & Sewer 42: Utility Impact Fee 70: 2005 Refunding / Mo bitty 0.367 5,000,000.00 5,006,370.44 4,999,677.24 5,005,182.00 346 6,362.49 5.98 5/1/2012 10/30/2014 0.500 1,000,000.00 1,000,000,00 1,000,000.00 1,001,257.00 760 2,083.33 1.20 2/8/2012 2/26/2013 0,178 1,000,000.00 1,006,000.00 1,002,317.46 1,002,374.00 149 708.33 1.20 3/30/2011 10/30/2012 0.624 2,000,000.00 1,996,097.64 1,999,794.61 2,000,548.00 30 4,166.67 2.39 1/28/2011 12/28/2012 0.660 1,000,000.00 994,580.00 999,308.75 1,000,688.00 89 958.33 1.20 3/27/2012 10/22/2013 0.361 1,000,000.00 1,010,780.00 1,007,288.42 1,008,062.00 387 4,608.33 1.20 1/28/2011 12/28/2012 0.660 1,000,000.00 994,580.00 999,308.75 1,000,688.00 89 958.33 1.20 3/30/2011 10/30/2012 0.624 1,000,000.00 998,048.82 999,897.31 1,000,274.00 30 2,083.33 1.20 6/20/2012 11/17/2014 0.462 1,000,000.00 1,020,050.00 1,017,737.43 1,020,786.00 778 4,802.78 1.20 3/30/2011 10/30/2012 0.624 1,000,000.00 998,048.82 999,897.31 1,000,274.00 30 2,083.33 1.20 6/30/2011 10/30/2012 0.386 2,000,000.00 2,003,028.20 2,000,189.26 2,000,386.00 30 4,166.67 2.39 Sub Total / Average 0.507 12,000,000.00 12,021,213.48 12,025,739.30 12,035,337.00 203 26,619.43 14.36 Total / Average 6 of 6 0.265 83,550,222.52 83,727,297.03 83,626,352.37 83,648,364.14 106 76,454.21 100 lit I of City of Pearland City of Pearland - by Fund Report Format: By Transaction Group By: Portfolio Name PortfoUo/Report Group: Report Group: Pearland As of 9/30/2012 Security Settlement Face YTM 0 Maturity Days To % of Description CUSIP/Tidcer Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfoio 10: General Fund we Fargo Sweep Cash WFSWEEP Cash 5/31/2006 5,541,864.72 5,541,864.72 5,541,864.72 0.170 N/A 1 6.63 21ST CENTURY 0.25 CD90136SFD3 Certificate Of 2/13/2012 248,000.00 248,000.00 247,865.34 0.250 2/13/2013 136 0.30 2/13/2013 Depost CDARS 0.6 6/19/2014 CD1013981872 Certificate Of 6/21/2012 500,000.00 500,000.00 500,000.00 0.600 6/19/2014 627 0.60 Depost Fist Commercial Bank 31984GCN7 Certificate Of 8/30/2012 248,000.00 248,000.00 247,390.42 0.300 8/30/2013 334 0.30 0.3 8/30/2013 Depost Moody National Bank 0.5 CO6000713013 Certificate Of 5/30/2012 245,000.00 245,000.00 245,000.00 0.500 11/30/2012 61 0.29 11/30/2012 Depost FFCB 0.3 7/18/2014 3133EAYL6 FFCB Bond 8/1/2012 1,000,000.00 1,000,268.99 1,000,105.00 0.285 7/18/2014 656 1.20 FFCB 0.75 5/2/2013 31331K1Q4 FFCB Bond 5/2/2011 1,000,000.00 1,000,000.00 1,003,102.00 0.750 5/2/2013 214 1.20 FHLB 3.625 5/29/2013 3133XQU34 FHLB Bond 5/31/2011 1,000,000.00 1,020,383.14 1,022,615.00 0.530 5/29/2013 241 1.20 FHLMC 0 4/1/2013 313397DU2 FHLMC Bond 4/26/2012 1,000,000.00 999,135.83 999,444.00 0.173 4/1/2013 183 1.20 FHLMC 0.375 3134G3SB7 FHLMC Bond 3/27/2012 1,000,000.00 998,562.98 1,001,888.00 0.467 4/28/2014 575 1.20 4/28/2014 FNMA 0.5 3136GOFF3 FNMA Bond 5/1/2012 1,000,000.00 1,000,000.00 1,001,257.00 0.500 10/30/2014 760 1.20 10/30/2014-13 FNMA 0.75 2/26/2013 3135GOAK9 FNMA Bond 2/8/2012 1,000,000.00 1,002,317.46 1,002,374.00 0.178 2/26/2013 149 1.20 FNMA 0.5 10/30/2012 3139844T6 FNMA Bond 3/30/2011 2,000,000.00 1,999,794.61 2,000,548.00 0.624 10/30/2012 30 2.39 Sub Total / Average 15,782,864.72 15,803,327.73 15,813,453.48 0.357 208 18.89 17: Municipal Court Security We Fargo Sweep Cash WFSWEEP Cash 5/31/2006 142,669.07 142,669.07 142,669.07 0.170 NJA 1 0.17 Sub Total / Average 142,669.07 142,669.07 142,669.07 0.170 1 0.17 18: City Wide Donation Wens Fargo Sweep Cash WFSWEEP Cash 5/31/2006 71,364.46 71,364.46 71,364.46 0.170 N/A 1 0.09 11 2 of 8 Security Settlement Face YTM 0 Maturity Days To % of Description CUSIP/TIdrer Type Date Amount/Shares Book Vakie Market Vakie Cost Date Maturity Portfolio Sub Total / Average 71,364.46 71,364.46 71,364.46 0.170 1 0.09 19: Court Tednology Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 243,607.62 243,607.62 243,607.62 0.170 N/A 1 0.29 Sub Total / Average 243,607.62 243,607.62 243,607.62 0.170 1 0.29 20: Debt Services Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 2,634,399.38 2,634,399.38 2,634,399.38 0.170 N/A 1 3.15 FARMERS & MERCHANTS CD307812HH3 Certificate Of 2/17/2012 248,000.00 248,000.00 247,869.30 0.250 2/15/2013 138 0.30 0.25 2/15/2013 Depost FHLB 0 10/24/2012 313384L80 FHLB Bond 4/26/2012 1,000,000.00 999,906.67 999,987.00 0.142 10/24/2012 24 1.20 FNMA 0.375 31398A6F4 FNMA Bond 1/28/2011 1,000,000.00 999,308.75 1,000,688.00 0.660 12/28/2012 89 1.20 12/28/2012 Sub Total / Average 4,882,399.38 4,881,614.80 4,882,943.68 0.269 31 5.84 23: Court Juvenile Mgmt We Fargo Sweep Cash WFSWEEP Cash 9/15/2009 36,386.36 36,386.36 36,386.36 0.170 N/A 1 0.04 Sub Total / Average 36,386.36 36,386.36 36,386.36 0.170 1 0.04 30: Water & Sewer We Fargo Sweep Cash WFSWEEP Cash 5/31/2006 5,954,707.29 5,954,707.29 5,954,707.29 0.170 N/A 1 7.13 CDARS 0.5 6/20/2013 CD1013981856 Certificate Of 8/1/2012 500,000.00 500,000.00 500,000.00 0.500 6/20/2013 263 0.60 Deposit SAFRA NATIONAL BANK C07865803513 8/1/2012 Of 8/1/2012 248,000.00 248,000.00 248,355.88 0.600 5/5/2014 582 0.30 0.6 5/5/2014 Deposit AMERICAN NATIONAL CD02771PKZ9 Certificate Of 5/3/2012 248,000.00 248,000.00 247,708.35 0.250 5/3/2013 215 0.30 BANK 0.25 5/3/2013 Depost BEAL BANK 0.3 CD07370TKX0 Certificate Of 2/15/2012 248,000.00 248,000.00 247,899.31 0.300 2/13/2013 136 0.30 2/13/2013 Depost FFCB 0.25 3133EAA73 FFCB Bond 8/1/2012 1,000,000.00 1,000,000.00 999,017.00 0.250 1/30/2014 487 1.20 1/30/2014-12 FHLB 3.625 5/29/2013 3133XQU34 FHLB Bond 5/31/2011 1,000,000.00 1,020,383.14 1,022,615.00 0.530 5/29/2013 241 1.20 FNMA 1.05 10/22/2013 31398A4S8 FNMA Bond 3/27/2012 1,000,000.00 1,007,288.42 1,008,062.00 0.361 10/22/2013 387 1.20 Seamy Settlement Face YTM 18 Maturity Days To % 01 Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfo8o FNMA 0.375 31398A6F4 FNMA Bond 1/28/2011 1,000,000.00 999,308.75 1,000,688.00 0.660 12/28/2012 89 1.20 12/28/2012 FNMA 0.5 10/30/2012 31398A4T6 FNMA Bond 3/30/2011 1,000,000.00 999,897.31 1,000,274.00 0.624 10/30/2012 30 1.20 FNMA 1.3 11/17/2014 3136FPWZ6 FNMA Bond 6/20/2012 1,000,000.00 1,017,737.43 1,020,786.00 0.462 11/17/2014 778 1.20 Sub Total /Average 13,198,707.29 13,243,322.34 13,250,112.83 0.336 180 15.80 31: Solldwaste Weis Fargo Sweep Cash WFSWEEP Cash 12/1/2006 941,865.00 941,865.00 941,865.00 0.170 N/A 1 1.13 Sub Total / Average 941,865.00 941,865.00 941,865.00 0.170 1 1.13 35: Street Assessment Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 343,720.72 343,720.72 343,720.72 0.170 N/A 1 0.41 DISCOVER BANK 0.25 CD2546703U4 Certificate Of 2/15/2012 248,000.00 248,000.00 247,860.13 0.250 2/15/2013 138 0.30 2/15/2013 Deposit Sub Total / Average 591,720.72 591,720.72 591,580.85 0.204 58 0.71 42: UtiNty Impact Fee Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 2,697,415.00 2,697,415.00 2,697,415.00 0.170 N/A 1 3.23 FFCB 0.34 3133EAM34 FFCB Bond 9/27/2012 1,000,000.00 1,000,000.00 1,000,009.00 0.340 4/23/2014 570 1.20 4/23/2014-12 FHLB 1.81 3/26/2013 3133XWGP8 FHLB Bond 3/27/2012 1,000,000.00 1,007,661.64 1,007,960.00 0.240 3/26/2013 177 1.20 FHLMC 0.75 3134G1P65 FHLMC Bond 6/30/2011 2,000,000.00 2,001,544.09 2,002,850.00 0.433 12/28/2012 89 2.39 12/28/2012 FNMA 0.510/30/2012 31398A4T6 FNMA Bond 3/30/2011 1,000,000.00 999,897.31 1,000,274.00 0.624 10/30/2012 30 1.20 Sub Total / Average 7,697,415.00 7,706,518.04 7,708,508.00 0.328 124 9.21 43: Regional Detention Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 6.46 6.46 6.46 0.170 N/A 1 0.00 Sub Total / Average 6.46 6.46 6.46 0.170 1 0.00 44: Shadow Creek Impact Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 1,300,566.78 1,300,566.78 1,300,566.78 0.170 N/A 1 1.56 3of8 lq 4of3 Security Settlement Face YTM 0 Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio GOLDMAN SACHS 0.25 Certificate Of 2/15/2013 CD38143A3Z9 DeposR 2/15/2012 248,000.00 248,000.00 247,8.60.13 0.250 2/15/2013 138 0.30 Sub Total / Average 1,548,566.78 1,548,566.78 1,548,426.91 0.183 23 1.85 45: Hotel/Motel Occupancy Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 1,395,313.86 1,395,313.86 1,395,313.86 0.170 N/A 1 1.67 KEY BANK 0.25 CD49306SPE0 Certificate Of 2/15/2012 248,000.00 248,000.00 247,860.13 0.250 2/15/2013 138 0.30 2/15/2013 Deposit Sub Total / Average 1,643,313.86 1,643,313.86 1,643,173.99 0.182 22 1.97 46: Park Donations Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 82,949.75 82,949.75 82,949.75 0.170 N/A 1 0.10 Sub Total / Average 82,949.75 82,949.75 82,949.75 0.170 1 0.10 47: Park & Rec Development Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 692,911.28 692,911.28 692,911.28 0.170 N/A 1 0.83 PACIFIC CONTINENTAL C069413CCQ0 Certificate Of 2/15/2012 248,000.00 248,000.00 247,871.04 0.250 2/15/2013 138 0.30 0.25 2/15/2013 Deposit Sub Total / Average 940,911.28 940,911.28 940,782.32 0.191 37 1.13 49: Tree Trust Fund Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 18,231.91 18,231.91 18,231.91 0.170 N/A 1 0.02 Sub Total / Average 18,231.91 18,231.91 18,231.91 0.170 1 0.02 50: Capital Projects Weis Fargo Sweep Cash WFSWEEPCash 5/31/2006 1,876,277.26 1,876,277.26 1,876,277.26 0.170 N/A 1 2.25 Sub Total / Average 1,876,277.26 1,876,277.26 1,876,277.26 0.170 1 2.25 55: Sidewalk Fund Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 205,362.79 205,362.79 205,362.79 0.170 N/A 1 0.25 Sub Total / Average 205,362.79 205,362.79 205,362.79 0.170 1 0.25 60: Polce State Seizure 2,D Security Settlement Face YTM 0 Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Welk Fargo Sweep Cash WFSWEEP Cash 5/31/2006 283,042.25 283,042.25 283,042.25 0.170 N/A 1 0.34 Sub Total / Average 283,042.25 283,042.25 283,042.25 0.170 1 0.34 62: Federal Police Fund Welts Fargo Sweep Cash WFSWEEP Cash 5/31/2006 32,161.33 32,161.33 32,161.33 0.170 N/A 1 0.04 Sub Total / Average 32,161.33 32,161.33 32,161.33 0.170 1 0.04 64: 1998 Cert of Obligation Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 844,306.79 844,306.79 844,306.79 0.170 N/A 1 1.01 Sub Total / Average 844,306.79 844,306.79 844,306.79 0.170 1 1.01 67: 2003 Revenue Bonds Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 12,104,217.06 12,104,217.06 12,104,217.06 0.170 N/A 1 14.49 MIZUHO CORP BANK 0.3 C060688TBR9 Certificate Of 5/2/2012 248,000.00 248,000.00 247,672.64 0.300 5/2/2013 214 0.30 5/2/2013 Deposit FFCB 0.48 3133EAV34 FFCB Bond 6/26/2012 1,000,000.00 1,000,000.00 1,002,197.00 0.480 12/26/2014 817 1.20 12/26/2014-13 FH1_80.212/13/2012 313376LR4 FHLB Bond 3/27/2012 1,000,000.00 1,000,036.21 1,000,040.00 0.182 12/13/2012 74 1.20 FHLB 1.625 11/21/2012 3133XVEM9 FHLB Bond 2/8/2012 1,000,000.00 1,002,073.52 1,002,005.00 0.160 11/21/2012 52 1.20 FHLMC 0.35 12/5/2014 3134G3H78 FHLMC Bond 9/27/2012 1,000,000.00 1,000,434.34 1,001,000.00 0.330 12/5/2014 796 1.20 Sub Total / Average 16,352,217.06 16,354,761.13 16,357,131.70 0.201 110 19.57 68: 2001 Cert of Obligation Web Fargo Sweep Cash WFSWEEP Cash 5/31/2006 822,053.22 822,053.22 822,053.22 0.170 N/A 1 0.98 PRIVATE BANK 0.25 CD74269TBK2 osit Of 2/15/2012 248,000.00 248,000.00 247,871.04 0.250 2/15/2013 138 0.30 D 2/15/2013 Deposit Sub Total / Average 1,070,053.22 1,070,053.22 1,069,924.26 0.189 33 1.28 70: 2005 Refucding / Mobaity Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 853,456.90 853,456.90 853,456.90 0.170 N/A 1 1.02 FNMA 0.5 10/30/2012 3I36FPUC9 FNMA Bond 6/30/2011 2,000,000.00 2,000,189.26 2,000,386.00 0.386 10/30/2012 30 2.39 Sub Total / Average 2,853,456.90 2,853,646.16 2,853,842.90 0.321 21 3.42 5 of 8 Security Settlement Face YTM Malty Days To % of Desciption CUSIP/Tldter Type Date Amount/Shares Book Value Market Value Cost Data Maturity Portfolio 95: Property Liability Wets Fargo Sweep Cash WFSWEEP Cash 10/31/2006 128,438.65 128,438.65 129,438.65 0.170 N/A 1 0.15 Sub Total / Average 128,438.65 128,438.65 128,438.65 0.170 1 0.15 97: Employee Benefit Trust Web Fargo Sweep Cash WFSWEEP Cash 9/1/2007 36,377.89 36,377.89 36,377.89 0.170 N/A 1 0.04 Sub Total / Average 36,377.89 36,377.89 36,377.89 0.170 1 0.04 99: COP Health Calms Fund We Fargo Sweep Cash WFSWEEP Cash 9/15/2010 424,845.58 424,845.58 424,845.58 0.170 N/A 1 0.51 Welts Fargo Cash WF9871 Cash 7/21/2010 196,712.52 196,712.52 196,712.52 0.160 N/A 1 0.24 Sub Total / Average 621,558.10 621,558.10 621,558.10 0.167 1 0.74 2101: Grant Fund We Fargo Sweep Cash WFSWEEP Cash 5/31/2006 -143,343.73 -143,343.73 -143,343.73 0.170 N/A 1 -0.17 Sub Total / Average -143,343.73 -143,343.73 -143,343.73 0.170 1 -0.17 Z105: 2007 CDBG Fund Weis Fargo Sweep Cash WFSWEEP Cash 5/1/2007 Sub Total / Average 187.60 187.60 187.60 0.170 N/A 1 0.00 187.60 187.60 187.60 0.170 1 0.00 Z106: 2008 CDBG Fund Weis Farre Sweep Cash WFSWEEP Cash 3/15/2009 1.14 1.14 1.14 0.170 N/A 1 0.00 1.14 1.14 1.14 0.170 1 0.00 Sub Total / Average Z107: 2009 CDBG Fund Web Fargo Sweep Cash WFSWEEP Cash 11/1/2009 15.61 15.61 15.61 0.170 N/A 1 0.00 15.61 15.61 15.61 0.170 1 0.00 Sub Total / Average Z108: 2010 CDBG Fund Wek1s Fargo Sweep Cash WFSWEEP Cash 11/1/2010 0.05 0.05 0.05 0.170 N/A 1 0.00 0.05 0.05 0.05 0.170 1 0.00 Sub Total / Average 6 of 8 7 of 8 Security Settlement Face WTM 0 Maturfy Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Z109: 2011 CDBG Fund Weis Fargo Sweep Cash WFSWEEP Cash 12/1/2011 -16,697.97 -16,697.97 -16,697.97 0.170 N/A 1 -0.02 Sub Total / Average -16,697.97 -16,697.97 -16,697.97 0.170 1 -0.02 Z116: CDBG Recovery Fund We Fargo Sweep Cash WFSWEEP Cash 7/31/2009 7.40 7.40 7.40 0.170 N/A 1 0.00 Sub Total / Average 7.40 7.40 7.40 0.170 1 0.00 2140: U of H Fund We Fargo Sweep Cash WFSWEEP Cash 12/1/2009 85,699.81 85,699.81 85,699.81 0.170 N/A 1 0.10 Sub Total / Average 85,699.81 85,699.81 85,699.81 0.170 1 0.10 Z145: Munklpal Channel Weis Fargo Sweep Cash WFSWEEP Cash 4/15/2012 53,068.06 53,068.06 53,068.06 0.170 N/A 1 0.06 Sub Total / Average 53,068.06 53,068.06 53,068.06 0.170 1 0.06 Z200: 2006 Cert of Obligation Welk Fargo Sweep Cash WFSWEEP Cash 6/30/2006 1,625,428.29 1,625,428.29 1,625,428.29 0.170 N/A 1 1.95 Sub Total / Average 1,625,428.29 1,625,428.29 1,625,428.29 0.170 1 1.95 Z201: 2007 Cert of Obligation Weis Fargo Sweep Cash WFSWEEP Cash 8/31/2006 1,644,218.73 1,644,218.73 1,644,218.73 0.170 N/A 1 1.97 Sub Total / Average 1,644,218.73 1,644,218.73 1,644,218.73 0.170 1 1.97 2202: 2007A Gen Obligation Welk Fargo Sweep Cash WFSWEEP Cash 12/31/2007 3,586,125.70 3,586,125.70 3,586,125.70 0.170 N/A 1 4.29 APPLE BANK 0.3 CD037830FX9 Certificate Of 2/22/2012 248,000.00 248,000.00 247,886.91 0.300 2/22/2013 145 0.30 2/22/2013 Depose Sub Total / Average 3,834,125.70 3,834,125.70 3,834,012.61 0.178 10 4.59 Z203: 2009 Gen Obligation Welk Fargo Sweep Cash WFSWEEP Cash 10/30/2008 2,378,902.72 2,378,902.72 2,378,902.72 0.170 N/A. 1 2.85 zs Security Settlement Face VTM © Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Sub Total / Average 2,378,902.72 2,378,902.72 2,378,902.72 0.170 1 2.85 Z301: W/S Pay As U Go CIP Wells Fargo Sweep Cash WFSWEEP Cash 12/31/2007 1,962,377.21 1,962,377.21 1,962,377.21 0.170 N/A 1 2.35 Sub Total / Average 1,962,377.21 1,962,377.21 1,962,377.21 0.170 1 2.35 Total / Average 8 of 8 83,550,222.52 83,626,352.37 83,648,364.14 0.265 106 100 2.4 City of Peadand Purchases Portfolio/Report Group: Report Group: Peariand From 6/30/2012 To 9/30/2012 TIM Portfolio Settlement Maturity Face Name Description Bullet/Callable CUSIP/Tdcer Action Date Date Price Amount/Shares Cost Prindpal Interest/Divklends Broker/Dealer 30: FFCB 0.25 Wets Fargo Water& 1/30/2014-12 Yes 3133EAA73 Buy 8/1/2012 1/30/2014 100 1,000,000.00 0.250 1,000,000.00 6.94 Bank Sewer 10: FFCB 0.3 Web Fargo General 7/18/2014 3133EAY1.6 Buy 8/1/2012 7/18/2014 100.029348 1,000,000.00 0.285 1,000,293.48 108.33Bank Fund 30: SAFRA Water& NATIONAL CD786580350 Buy 8/1/2012 5/5/2014 100 248,000.00 0.600 248,000.00 366.90 Bank Sewer Fargo Sewer BANK 0.6 5/5/2014 30: CDARS 0.5 Independence Water& 6/20/2013 CD1013981856 Buy 8/1/2012 6/20/2013 100 500,000.00 0.500 500,000.00 280.82 Bank Sewer 10: First General Commercial 0.3 ei 31984GCN7 Buy 8/30/2012 8/30/2013 100 248,000.00 0.300 248,000.00 0.00 Baerk Fargo Fund Bank 0.3 8/30/2013 42: FFCB 0.34 Duncan Yes 3133EAM34 Buy 9/27/2012 4/23/2014 100 1,000,000.00 0.340 1,000,000.00 1,454.44 W3liams Impact 4/23/2014-12 Fee 67: 2003 FHLMC 0.35 Revenue 12/5/2014 Bonds 1 of 1 3134G3H78 Buy 9/27/2012 12/5/2014 100.0436 1,000,000.00 0.330 1,000,436.00 Duncan 291.67 W dliems 2S Bank Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Pledged Collateral Reconciliation Report September 30, 2012 Account Number 201-0419505 201-0419513 001-3042841 201-0419554 807-1613395 818-4567843 001-3043112 280-7409871 865-9860145 Bank Account Number Wells Fargo 1010-7284258 I:\Investments\Investment Reports1City of Peartand\Investment Report - City - Otr 0912 Account Name Operating Payroll Fund Sweep Account 98 CO Escrow Credit Card Account Alvin ISD PEDC Sales Tax Health Claims BC MUD #4 Certificate of Deposit Total of Bank Balances Pledged Collateral for City FDIC Insurance Total Collateral Amount $ 57,594,144.23 620,889.88 4,222,256.28 201,496.15 1.44 $ 62,638,787.98 92,979,805.97 250,000.00 $ 93,229,805.97 Over (Under) Collateralized $ 30,591,017.99 Total % Collateralized 148.8% Account Name Development Authority Total of Bank Balances Pledged Collateral for DAP FDIC Insurance Total Collateral Over (Under) Collateralized Total % Collateralized Total $ Over (Under) Collateralized Total % Collateralized Status Amount 656,251.90 $ 656,251.90 8,145,221.83 250.000.00 $ 8,395,221.83 $ 7,738,969.93 1279.3% $ 38,329,987.92 160.6% Collateralized z-6 RESOLUTION NO. R2012-173 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS, ACCEPTING THE CITY'S INVESTMENT REPORT FOR THE QUARTER ENDING SEPTEMBER 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 September 2012. PASSED, APPROVED, AND ADOPTED this 10th day of December A.D., 2012. 2y £4 TOM REID MAYOR ATTEST: / •..Q�A42L,gN�,,. `•O. Y�'NG �� ' �N / R y- ~' /\ _ = • SEETAR «,tn4.'..''••. APPROVED AS TO FORM: • DARRIN M. COKER CITY ATTORNEY Resolution No.R2012-173 Exhibit "A" City of Pearland Quarterly Investment Report ['EARL.AND June 30, 2012-Sept 30, 2012 Period 13 Portfolio at June 30.2012, Portfolio at Scot 30.2032 Ending Book Value $ 89,422,699.33 Ending Book Value $ 83,626,352.37 Ending Market Value 89,445,581.34 Ending Market Value 83,648,364.14 Accrued Interest Receivable 49,758.01 Accrued Interest Receivable 76,454.21 FYD Total Interest Earned 133,110.65 FYD Total Interest Earned 367,293.74 Unrealized Gain/(Loss) 22,882.01 Unrealized Gain/(Loss) 22,011.77 Change in Unrealized Gain/Loss (7,866.15) Change in Unrealized Gain/Loss (870.24) Weighted Average Maturity 101 Days Weighted Average Maturity 106 Days Change in Market Value (5,818,458.52) Change in Market Value (5,797,217.20) Yield to Maturity at Cost 0.19% Yield to Maturity at Cost 0.27% T-Bill Benchmark 0.21% T-Bill Benchmark 0.17% Agency Note Benchmark 0.14% Agency Note Benchmark 0.15% Average for Quarter City's Yield to Maturity 0.26% 1 Year T-Bill Benchmark Yield 0.16% Agency Note Benchmark Yield 0.15% This quarterly report is in compliance with the investment policy and strategy as established by the City and the Public Funds Investment Act (Chapter 2256,Texas Government Code). Prepared by: n Claire Bogard Rick as Fatima wakwe Director of Finance Assistant Director of Finance Accounting Supervisor Summary by Type Sept 30,2012 Descrlotion Face Amount k Shams Cost Valua Book Value Market Value YIM @ Cost Days To_Matwrity Cash $ 51,081,22252 $ 51,081,222.52 $ 51,081,222.52 $ 51,081,222.52 0.17% 1 CD 4,469,000.00 4,469,000.00 4,469,000.00 4,466,970.62 0.36% 247 FFCB 5,000,000.00 5,000,293.48 5,000,268.99 5,004,430.00 0.42% 549 FHLB 6,000,000.00 6,149,197.11 6,050,444.32 6,055,222.00 0.30% 135 FHLMC 5,000,000.00 5,006,370.44 4,999,677.24 5,005,182.00 0.37% 346 FNMA 12,000,000.00 12,021,213.48 12,025,739.30 12,035,337.00 0.51% 203 Total/Average $ 83,550,222.52 $ 83,727,297.03 $ 83,626,352.37 $ 83,648,364.14 0.27% 106 Group Portfolio Holdings Book Value by Maturity by Type 60,000,000 FNMA } FHtMC 15% 6% 50,000,000 40,000,000 NO 7% 30,000,000 20,000.000 - - - 10,000,000 FFCB Cash _lir6% a) 61% 5% - — 1.30 DaYs 31.60 DaYs 61.90 DaYs91-120 DaV{21-180 DaYs ,160 Days Z Interest Rates Qats Imp 3 mo trim lx1 2 yr la Sya Lu 10_.yr ZO yr NYC 6/29/2012 0.04 0.09 0.16 0.21 0.33 0.41 0.72 1.11 1.67 2.38 2.76 9/28/2012 0.06 0.10 0.14 0.17 0.23 0,31 0.62 1.04 1.65 2.42 2.82 Yield Curve Comparison 3.00 t----..._-__.__ 2.00 1.50 C'y's Weighted Avg Yield.26% 1'3 Day Average Maturity 1 rro 3 ,0 6ma lyr 2 yr Syr 5 yr Tyr 10 yr 20 yr 30 yr t6/29/2012 —III—9/28/2012 Portfolio vs. Benchmarks 0.35% 0.15% — 0.00% .._,..._.T._._..._""-'- Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul 12 Aug-12 Sep 12 import Total — —1 Yr T-001 -*—Agency Note 3 City of Pearland Quarterly Investment Report Report Format:By CUSIP Group By:Securty Type Portfolio/Report Group:Report Group:Pearland Begin Date:6/30/2012,End Date:9/30/2012 Ending Portfolio YTM 0 Maturity Amortized Amortised Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Prirdpal Sell Principal Discount Premium Ending BV Inane-BV CASH Wets Fargo WFSWEEP 10:General 0.17000 N/A 6,967,598.27 1,336,627.96 2,762,361.51 0.00 0.00 5,541,864.72 2,035.47 Sweep Cash Fund Fargo 17:Municipal Wels Welt Fa Cash WFSWEEP Court 0.17000 N/A 139,228.95 3,440.12 0.00 0.00 0.00 142,669.07 57.35 Sweep Security Wells s Fargo 18:Cty Sweep Cash WFSWEEP Wide 0.17000 N/A 63,009.23 11,566.49 3,211.26 0.00 0.00 71,364.46 26.20 Donation Wets Fargo WFSWEEP 19:Court 0.17000 N/A 228,736.32 14,871.30 0.00 0.00 0.00 243,607.62 96.63 Sweep Cash Technology Web Fargo WFSWEEP 20:Debt 0.17000 N/A 7,276,328.37 1,854,224.31 6,496,153.30 0.00 0.00 2,634,399.38 1,141.38 Sweep Cash Services Wells Fargo 23:Court Sweep Cash WFSWEEP Juvenile 0.17000 N/A 31,178.98 5,207.38 0.00 0.00 0.00 36,386.36 14.31 Mgmt Wets Fargo WFSWEEP 30:Water B; 0.17000 N/A 10,176,693.63 1,442,509.01 5,664,495.35 0.00 0.00 5,954,707.29 2,249.15 Sweep Cash Sewer Wets Fargo wFSWEEp 31: 0.17000 N/A 290,409.04 678,113.71 26,657.75 0.00 0.00 941,865.00 128.42 Sweep Cash Sotdwaste Wets Fargo WFSWEEP 35:Street 0.17000 N/A 343,582.05 138.67 0.00 0.00 0.00 343,720.72 138.67 Sweep Cash Assessment Wea5Sweep WFSWEEP 42�F 0.17000 N/A 753,444.00 2,085,603.74 141,632.74 0.00 0.00 2,697,415.00 539.72 Wets Fargo WFSWEEP 43:Regional 0.17000 N/A 0.00 24,756.46 24,750.00 0.00 0.00 6.46 6.46 Sweep Cash Detertlon WWeis Fargo44:Shadow Weis h WFSWEEP Creek 0.17000 N/A 3,748,583.23 189,117.05 2,637,133.50 0.00 0.00 1,300,566.78 1,209.88 SweeImpact 45: Wets Fargo WFSWEEP o Sweep Cash HteyMotel 0.17000 N/A 1,268,785.15 136,504.17 9,975.46 0.00 0.00 1,395,313.86 564.09 Occupancy Wets Fargo WFSWEEP 46:Park 0.17000 N/A 88,839.68 2,724.91 8,614.84 0.00 0.00 82,949.75 33.65 Sweep Cash Donations 1of7 k Ending Portfolio VT/40 Maturity Amortized Amortized Investment Hums Defoiptioe CUSIP/Tidker Name Cost Date Beginning BY Buy prFtipel Sell Principal Discount Premium Ending BV Inoome-SV Wells Fargo 47:Park a Sweep Cash WFSWEEP Rec 0.17000 N/A 831,868.70 61,302.47 220,259.89 0.00 0.00 692,911.28 274.30 Development Web Fargo WFSWEEP 49:Tree 0.17000 N/A 19,083.26 307.65 1,159.00 0.00 0.00 18,231.91 7.65 Sweep Cash Trust Fund Web Fargo Projects 50:Captal 0.17000 N/A 2,476,878.23 93,708.66 694,309.63 0.00 0.00 1,876,277.26 773.81 Sweep Web Fargo WFSWEEP 55:Sidewalk 0.17000 WA 208,297.15 83.64 3,018.00 0.00 0.00 205,362.79 83.64 Sweep Cash Fund 60Web Fargo Sta Poke Sweep Cash Seizure State 0.17000 N/A 238,875.67 52,207.83 8,041.25 0.00 0.00 283,042.25 100.27 Seizure Web Fargo WFSWEEP 62:Federal 0.17000 N/A 32,148.38 12.95 0.00 0.00 0.00 32,161.33 12.95 Sweep Cash Poke Fund 64Weis Fargo er 1998 Sweep CashWFSW EEP Cert of 0.17000 N/A 843,966.15 340.64 0.00 0.00 0.00 844,306.79 340.64 obligation Web Fargo 67:2003 Sweep Cash WFSWEEP Revenue 0.17000 N/A 8,269,312.44 4,240,262.40 405,357.78 0.00 0.00 12,104,217.06 3,787.19 Bonds Weis Fargo 68:2001 Sweep Cash WFSWEEP CeR of 0.17000 N/A 1,280,157.03 503.41 458,607.22 0.00 0.00 822,053.22 450.75 Obligation 70Web Ref ef 2005 Sweep Cash WFSWEEP 0:200tridbg/ 0.17000 N/A 1,899,151.01 836.89 1,046,531.00 0.00 0.00 853,456.90 589.02 Mobity web Fargo Cash WFSWEEP apt y Pe' 0.17000 N/A -99,280.03 250,727.60 23,008.92 0.00 0.00 128,438.65 18.25 eep Web Fargo 97: Sweep Cash WFSWEEP Employee 0.17000 N/A 39,653.77 65,054.36 68,330.24 0.00 0.00 36,377.89 14.96 Benefit Trust Web Fargo 99:COP Cash WF9871 Health 0.16000 N/A 358,698.95 800,112.58 962,099.01 0.00 0.00 196,712.52 112.58 Claims Fund Weis Fargo 99:COP W Sweep Cash WFSWEED ath 0.17000 N/A -142,753.72 646,395.70 78,796.40 0.00 0.00 424,845.58 0.00 Claims Fund Web Fargo WFSWEEP Z11r0C1:Grant 0.17000 N/A -100,581.87 185,996.93 228,758.79 0.00 O.OD -143,343.73 0.00 Sweep Cash 2of7 Ending Portfolio YTM 0 Maturty Amortized Amortized Investment Desaiption CUSIP/Tldcer Name Coat Date Beginning BY Buy Prindpal Sal Principal Discount Premium Ending BY Income•BY We Fargo WFSWEEP Z105:2007 0.17000 N/A 187.54 0.06 0.00 0.00 0.00 187.60 0.06 Sweep Cash CDBG Fund Well Fargo WFSWEEP Z106:2008 0.17000 N/A 1.14 0.00 0.00 0.00 0.00 1.14 0.00 Sweep Cash CDBG Fund We Fargo WFSWEEP Z107:2009 0.17000 N/A 15.61 0.00 0.00 0.00 0.00 15.61 0.00 Sweep Cash CDBG Fund Wets Fargo WFSWEEP 2108:2010 0.17000 N/A 0.05 0.00 0.00 0.00 0.00 0.05 0.00 Sweep Cash CDBG Fund Weis Fargo WFSWEEP Z109:2011 0.17000 N/A -7,604.22 7,604.22 16,697.97 0.00 0.00 -16,697.97 0.00 Sweep Cash CDBG Fund Web Fargoo Z116:CDBG W Web Faeep Cash WFSWEEP Recovery 0.17000 N/A 7.40 7,195.95 7,195.95 0.00 0.00 7.40 0.00 SFund Wets Fargo WFSWEEP Z140:U of M 0.17000 N/A 79,887.35 19,493.34 13,680.88 0.00 0.00 85,699.81 33.94 Sweep Cash Fund Weis Fargo Z145: Sweep Cash WFSWEEP Municipal 0.17000 N/A 10,468.25 55,130.37 12,530.56 0.00 0.00 53,068.06 19.33 Channel Weis Fargo Z200:2006 Sweep Cash WFSWEEP Certof 0.17000 N/A 1,776,680.81 4,970.08 156,222.60 0.00 0.00 1,625,428.29 686.12 Obligation We Fargo Z201:2007 Sweep Cash WFSWEEP Cart of 0.17000 N/A 1,680,365.86 34,724.09 70,871.22 0.00 0.00 1,644,218.73 665.26 Obligaton Weis Fargo 2002: Sweep Cash WFSWEEP 2007A Gen 0.17000 N/A 2,672,851.76 988,553.47 75,279.53 0.00 0.00 3,586,125.70 1,389.13 Obigabon Web Fargo Z203:2009 W Web Fa Cash WFSWEEP Gen 0.17000 N/A 1,790,336.85 611,490.66 22,924.79 0.00 0.00 2,378,902.72 866.10 Sweep obligation Well Fargoo Z301:W/S Sweep Cash WFSWEEP Pay As U Go 0.17000 N/A 1,708,640.25 261,389.92 7,652.96 0.00 0.00 1,962,377.21 723.62 CID Sub Total/Average 0.16996 57,243,730.67 16,193,811.15 22,356,319.30 0.00 0.00 51,081,222.52 19,190.95 Cash CERTIFICATE OF DEPOSIT First 10:General Commercial 31984GCN7 Fund 0.30000 8/30/2013 0.00 248,000.00 0.00 0.00 0.00 248,000.00 0.00 Bank 0.3 3of7 19 Ending Portfolio YTM 0 Maturity Amortized Amortized Investment Description CUSIP/Tidnr Mame Cost Date Beginning BV Buy Prbndpel Sell Principal Discount Premium Ending BV Income-BY 8/30/2013 CDARS 0.75 CD1012781942 10:General 9/13/2012 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 1,541.09 9/13/2012 Fund CDARS 0.6 10:General 756.17 6/19/2014 CO1013981872 Fund 0.60000 6/19/2014 500,000.00 0.00 0.00 0.00 0.00 500,000.00 Moody National Bank 0.5 CD600071306 10:Generalfund 0.50000 11/30/2012 245,000.00 0.00 0.00 0.00 0.00 245,000.00 308.77 11/30/2012 215T CENTURY 0.25 CD901365FD3 10:General Fund0.25000 2/13/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 2/13/2013 FARMERS& MERCHANTSre C0307812HH3 Sest 0.25000 2/15/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.27 2/15/2013 AMERICAN NATIONALCD02771PK29wW�ater& 0.25000 5/3/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.27 BAN 0.25 5/3/2013 REAL BANK 0.3 CD07370TKX0 30:Water& 0.30000 2/13/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 187.53 2/13/2013 Sewer CDARS 0.5 CD1013981856 30:Water& 0.50000 6/20/2013 0.00 500,000.00 0.00 0.00 0.00 500,000.00 410.96 6/20/2013 Sewer SAFRA N'r'TI3 C0786580350 30:Water& 0.60000 5/5/2014 0.00 248,000.00 0.00 0.00 0.00 248,000.00 244.61 BANK 0.6 Sewer 5/5/2014 DISCOVER 35:Street BANK 0.25 CD2546703U4 Assessment 0.25000 2/15/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 2/15/2013 GOLDMAN 44:Shadow SACHS 0.25 C038143A329 Creek 0.25000 2/15/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 2/15/2013 Impact KEY BANK 0.25 45: 2/15/2013 CD49306SPE0 HoteVMotel 0.25000 2/15/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 Occupancy PACIFIC 47:Park& CONTINENTAL CD69413CCQO Rec 0.25000 2/15/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 2/15/2013 0.25Development 1 4 of 7 Ending Poitforo YTM 0 Maturity Amortked Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Seg Prindpal Discount Premium Ending By Inoome-BV M12UN0 CORP 67:2003 BANK 0.3 CD60688TBR9 Revenue 0.30000 5/2/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 187.53 5/2/2013 Bonds PRIVATE BANK 68:2001 0.25 CD74269TBK2 Certof 0.25000 2/15/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 2/15/2013 Obleatbn APPLE BANK 0.3 Z202: 2/22/2013C0037830FX9 2007A Gen 0.30000 2/22/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 187.53 Obagatbn Sub Total/Average 0.36136 4,473,000.00 996,000.00 1,000,000.00 0.00 0.00 4,469,000.00 5,074.41 Certificate Of Deposit FFCB BOND FFCB 0 10:General 5/2/2013 3133110Q4 Fund 0.75000 5/2/2013 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,875.00 FFCB 0.4 31331KZB9 10:General 9/20/2013 599,908.33 0.00 600,000.00 16.67 0.00 0.00 625.00 9/20/2013-12 Fund FFCB 0.3 3133EAYLb 10:General 0.28461 7/18/2014 0.00 1,000,293.48 0.00 0.00 -24.49 1,000,268.99 467.18 7/18/2014 Fund FFCB 0.25 3133EAA73 30:WaterB 0.25000 1/30/2014 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 409.73 1/30/2014-12 Sewer FFCB 0.34 3133EAMJ4 42'�*v 0.34000 4/23/2014 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 28.34 4/23/2014-12 Impact Fee FFCB 0.48 67:2003 12/26/2014-13 3133EAVJ4 Revenue 0.48000 12/26/2014 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,200.00 Bonds Sub Total/Average 0.42091 2,599,908.33 3,000,293.48 600,000.00 16.67 -24.49 5,000,268.99 4,605.25 FFCB Bond FMB BOND FHLB3.625 10:General 5/29/2013 3133XQU34 Fund 0.53011 5/29/2013 1,028,058.80 0.00 0.00 0.00 -7,675.66 1,020,383.14 1,386.114 9/4/2012 3133XUK93 FGer�eral 9/14/2012 1,002,804.63 0.00 1,000,000.00 0.00 -2,804.63 0.00 1,306.48 nd FMLB 0 313384L80 20'Debt 0.14243 10/24/2012 999,548.89 0.00 0.00 357.78 0.00 999,906.67 357.78 10/24/2012 Services V 5 of 7 Ending Amortized Amortized Investment Portfolio YTM 0 Maturity Description CUSIP/Ticker lame Cost Data Beginning BV Buy Prindpal Sell Prindpal Discount Premium Ending BY Income-BV FMB 3.625 3133XQU34 30:Water& 0.53011 5/29/2013 1,028,058.80 0.00 0.00 0.00 -7,675.66 1,020,383.14 1,386.84 5/29/2013 Sewer FHLB 0.875 3133XYWB7 30:Water& 8/22/2012 1,000,394.85 0.00 1,000,000.00 0.00 -394.85 0.00 869.04 8/22/2012 Sewer FHLB 1.81 3133XWGP8 4Z'Utility 0.24004 3/26/2013 1,011579.52 0.00 0.00 0.00 -3,917.88 1,007,661.64 607.12 3/26/2013 Impact Fee B 0.2 67:2003 FHI 12/13/2012 313376LR4 Revenue 0.18195 12/13/2012 1,000,080.86 0.00 0.00 0.00 -44.65 1,000,036.21 455.35 Bonds FHLB 1.625 67:2003 11/21/2012 3133XVEM9 Revenue 0.15977 11/21/2012 1,005,732.67 0.00 0.00 0.00 -3,659.15 1,002,073.52 403.35 Bonds Sub Total/Avernus 0.30165 8,076,259.02 0.00 2,000,000.00 357.78 -26,172.48 6,050,444.32 6,772.80 FMB Bond FMLMC BOND. FHIMC 0 313397Cd12 10: :eneral 0.17257 4/1/2013 998,701.39 0.00 0.00 434.44 0.00 999,135.83 434.44 4/1/2013 FHLMC 0.375 3134G3587 1:General 0.46657 4/28/2014 998,335.29 0.00 0.00 227.69 0.00 998,562.98 1,165.19 4/28/2014 FHLMC 1.125 3137EACK3 20:Debt 7/27/2012 1,000,753.44 0.00 1,000,000.00 0.00 -753.44 0.00 90.31 7/27/2012 Services FHLMC 0.75 3134G1P65 42'Utility 0.43281 12/28/2012 2,003,123.27 0.00 0.00 0.00 -1,579.18 2,001,544.09 2,170.82 12/28/2012 Impact Fee FM.MC 0.35 67:2003 12/5/2014 3134G3H78 Revenue 0.33000 12/5/2014 0.00 1,000,436.00 0.00 0.00 -1.66 1,000,434.34 27.50 Bonds Sub Total/Average 036710 5,000,913.39 1,000,436.00 1,0O0,00O.00 662.13 -2,334.28 4,999,677.24 3,888.26 FFB.MC Bond FNMA BOND FNMA 0.75 3135GOAK9 1 General 0.17780 2/26/2013 1,003,746.03 0.00 0.00 0.00 -1,428.57 1,002,317.46 446.43 2/26/2013 FNMA 0.5 3136GOFF3 10:General 0.50000 10/30/2014 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,250.00 10/30/2014-13 Fund FNMA 0.5 31398A4 10:General T6 0.62402 10/30/2012 1,999,178.45 0.00 0.00 616.16 0.00 1,999,794.61 3,116.16 10/30/2012 Fund 1 6 oC 7 Ending Portfolio VTM O Maturity Amortised Amortised Investment Description CUSIP/Tldter Name Cost Date Beginning BY Buy Priidpal Sell Principal Discount Premium Ending SV Income-BV FNMA 0.375 20:Debt 12128/2012 31398A6F4 Services0.66003 12/28/2012 998,601.80 0.00 0.00 706.95 0.00 999,308.75 1,644.45 FNMA 1.3 30:Water& 11/17/2014 3136FPWZ6 Sewer 0.46187 11/17/2014 1,019,818.74 0.00 0.00 0.00 -2,081.31 1,017,737.43 1,168.69 FNMA 1.05 31398A458 30:Water& 0.36058 10/22/2013 1,009,005.59 0.00 0.00 0.00 -1,717.17 1,007,288.42 907.83 10/22/2013 Sewer FNMA 0.5 30:Water& 10/30/2012 31398A4T6 Sewer 0.62402 10/30/2012 999,589.23 0.00 0.00 308.08 0.00 999,897.31 1,558.08 FNMA 0.375 31398A6F4 30:Water& 0.66003 12/28/2012 998,601.80 0.00 0.00 706.95 0.00 999,308.75 1,644.45 12/28/2012 Sewer 10/30/2012 31398A416 42 Feepact 0.62402 10/30/2012 999,589.23 0.00 0.00 308.08 0.00 999,897.31 1,558.08 FNMA 0.5 70:2005 10/30/2012 3136FPUC9 Refunding/ 0.38604 10/30/2012 2,000,757.05 0.00 0.00 0.00 -567.79 2,000,189.26 1,932.21 Mobity Sub Total/Average 0.50676 12,028,887.92 0.00 0.00 2,646.22 -5,794.84 12,025,739.30 15,226.38 FNMA Bond Total/ 0.26498 89,422,699.33 21,190,540.63 26,956,319.30 3,682.80 -34,326.09 83,626,35237 54,758.05 Average �0 7 of 7 City of Pearland Quarterly Investment Report at Quarterend Report Format:By Transaction Group By:Security Type Portfob/Report Group:Report Group:Pea riand As of 9/30/2012 Portfolio Settlement Maturity YTM O Face Days To Accrued %of Description CUSIP/Tidcer Name Date Data Cost Amount/Shares Cost Valor Book Value Market Value Maturity Interest Portfolio Cash Weis Fargo 10:G WFSWEEP Fund e °i 5/31/2006 N/A 0.170 5,541,864.72 5,541,864.72 5,541,864.72 5,541,864.72 1 Sweep Cash6.63 17:Mur#pal Weis Fargo W8 FWp gh WFSWEEP Court 5/31/2006 N/A 0.170 142,669.07 142,669.07 142,669.07 142,669.07 1 0.17 SwSecurity Weis Fargo 18:City Sweep Cash WFSWEEP Wick 5/31/2006 N/A 0.170 71,364.46 71,364.46 71,364.46 71,364.46 1 0.09 Donation Wells Fargo WFSWEEP 19:Court O 9y 5/31/2006 N/A 0.170 243,607.62 243,607.62 243,607.62 243,607.62 1 0.29 Sweep Cash Wets Fargo WFSWEEP 20:Debt5/31/2006 N/A 0.170 2,634,399.38 2,634,399.38 2,634,399.38 2,634,399.38 1 3.15 Sweep Cash Services Weis Fargo 23:Court Sweep Cash WFSWEEP Juvenile9/15/2009 N/A 0.170 36,386.36 36,386.36 36,386.36 36,386.36 1 0.04 Mgmt We Fargo WFSWEEP 30:Water& 5/31/2006 N/A 0.170 5,954,707.29 5,954,707.29 5,954,707.29 5,954,707.29 1 7.13 Sweep Cash Sewer We Fargo WFSWEEP 31: 12/1/2006 N/A 0.170 941,865.00 941,865.00 941,865.00 941,865.00 1 1.13 Sweep Cash Sordwaste We Fargo WFSWEEP 35:Street 5/31/2006 N/A 0.170 343,720.72 343,720.72 343,720.72 343,720.72 1 0.41 Sweep Cash Assessment WeIs Cash WFSWEEP 42CIt FY 5/31/2006 N/A 0.170 2,697,415.00 2,697,415.00 2,697,415.00 2,697,415.00 1 3.23 SwWei:Fargo WFSWEEP 43:Regbnal 5/31/2006 N/A 0.170 6.46 6.46 6.46 6.46 1 0.00 Sweep Cash Detention Weis Fargo 44:Shadow W Far go Cash WFSWEEP Creek 5/31/2006 N/A 0.170 1,300,566.78 1,300,566.78 1,300,566.78 1,300,566.78 1 1.56 SwImpact 45: Weis Fargo Ho Sweep Cash WFSWEEP HoteVMotel 5/31/2006 N/A 0.170 1,395,313.86 1,395,313.86 1,395,313.86 1,395,313.86 1 1.67 Occupancy Well Fargo WFSWEEP 46:Park 5/31/2006 N/A 0.170 82,949.75 82,949.75 82,949.75 82,949.75 1 0.10 Sweep Cash Donations 1l I of6 Portfolio Settlement Maturity YTS O Face Days To Accrued We of Deserptlon CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio ell Fargo 47:Park 8 W We Cash WFSWEEP Rec 5/31/2006 N/A 0.170 692,911.28 692,911.28 692,911.28 692,911.28 1 0.83 SwDevelopment We Fargo WFSWEEP 49:Tree 5/31/2006 N/A 0.170 18,231.91 18,231.91 18,231.91 18,231.91 1 0.02 Sweep Cash Trust Fund We Fargo WFSWEEP 50:Captal 5/31/2006 N/A 0.170 1,876,277.26 1,876,277.26 1,876,277.26 1,876,277.26 1 2.25 Sweep Cash Projects We Fargo WFSWEEP 55:Sidewak 5/31/2006 N/A 0.170 205,362.79 205,362.79 205,362.79 205,362.79 1 0.25 Sweep Cash Fund Web Fargo 60:Poke Sweep Cash WFSWEEP State 5/31/2006 N/A 0.170 283,042.25 283,042.25 283,042.25 283,042.25 1 0.34 Seizure We Fargo WFSWEEP 62:Federal 5/31/2006 N/A 0.170 32,161.33 32,161.33 32,161.33 32,161.33 1 0.04 Sweep Cash Poke Fund eis Fargo 64:1998 W We Cash WFSWEEP Cert of 5/31/2006 N/A 0.170 844,306.79 844,306.79 844,306.79 844,306.79 1 1.01 SwObligation We Fargo 67:2003 Sweep Cash WFSWEEP Revenue 5/31/2006 N/A 0.170 12,104,217.06 12,104,217.06 12,104,217.06 12,104,217.06 1 14.49 Bonds Wets Fargo 68:2001 Sweep Cash WFSWEEP Cert of 5/31/2006 N/A 0.170 822,053.22 822,053.22 822,053.22 822,053.22 1 0.98 Obligation Wen Fargos 70:2005 Sweep Cash WFSWEEP Refunding/ 5/31/2006 N/A 0.170 853,456.90 853,456.90 853,456.90 853,456.90 1 1.02 Mobility Walla SweepC sh WFSWEEP 95:Property 10/31/2006 N/A 0.170 128,438.65 128,438.65 128,438.65 128,438.65 1 0.15 Liability Wells Fargo 97: Sweep Cash WFSWEEP Employee 9/1/2007 N/A 0.170 36,377.89 36,377.89 36,377.89 36,377.89 1 0.04 Beneft Trust Wets Fargo 99:COP WFSWEEP Health 9/15/2010 N/A 0.170 424,845.58 424,845.58 424,845.58 424,845.58 1 0.51 Claims Fund Fargo Wets 99:COP Cash WF9871 Health 7/21/2010 N/A 0.160 196,712.52 196,712.52 196,712.52 196,712.52 1 0.24 Clakns Fund Wells Fargo WFSWEEP 2101:Grant 5/31/2006 N/A 0.170 -143,343.73 -143,343.73 -143,343.73 -143,343.73 1 -0.17 Sweep Cash Fund Were Fargo WFSWEEP 2105:2007 5/1/2007 N/A 0.170 187.60 187.60 187.60 187.60 1 0.00 Sweep Cash CDBG Fund 2 of 6 1Z Portfolio Settlement Maturity YTM 0 Face Days TO Acwed %of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Valve Book Value Market Value Maturity Interest Portfolio We Fargo WFSWEEP 2106:2008 3/15/2009 N/A 0.170 1.14 1.14 1.14 1.14 1 0.00 Sweep Cash CDBG Fund Wens Fargo WFSWEEP Z107:2009 11/1/2009 N/A 0.170 15.61 15.61 15.61 15.61 1 0.00 Sweep Cash CDBG Fund We Fargo WFSWEEP Z108:2010 11/1/2010 N/A 0.170 0.05 0.05 0.05 0.05 1 0.00 Sweep Cash CDBG Fund Wets Fargo WFSWup Z109:2011 12/1/2011 N/A 0.170 -16,697.97 -16,697.97 -16,697.97 -16,697.97 1 -0.02 Sweep Cash CDBG Fund W 2116:CMG Web Fargo Sweep Cash WFSWEEP Recovery 7/31/2009 N/A 0.170 7.40 7.40 7.40 7.40 1 0.00 Fund Wets Fargo WFSWEEP 2140:U of H 12/1/2009 N/A 0.170 85,699.81 85,699.81 85,699.81 85,699.81 1 0.10 Sweep Cash Fund Z14Wets Fargo WFSWEEP Municipal Sweep Cash Muun I 4/15/2012 N/A 0.170 53,068.06 53,068.06 53,068.06 53,068.06 1 0.06 Channel Z200:2006 Wets Fargo Sweep Cash WFSWEEP Cert of 6/30/2006 N/A 0.170 1,625,428.29 1,625,428.29 1,625,428.29 1,625,428.29 1 1.95 Obligation Web Fargo Z201:2007 Sweep CashWFSWEEP Cart of 8/31/2006 N/A 0.170 1,644,218.73 1,644,218.73 1,644,218.73 1,644,218.73 1 1.97 Obligation Wells Fargo Z202: Sweep Cash WFSWEEP 2007A Gen 12/31/2007 N/A 0.170 3,586,125.70 3,586,125.70 3,586,125.70 3,586,125.70 1 4.29 Obligation Web Z203:2009 Sweep Fargoh WFSWEEP Gen 10/30/2008 N/A 0.170 2,378,902.72 2,378,902.72 2,378,902.72 2,378,902.72 1 2.85 Obligation Wets Fargo Z301:W/S Sweep Cash WFSWEEP Pay As U Go 12/31/2007 N/A 0.170 1,962,377.21 1,962,377.21 1,962,377.21 1,962,377.21 1 2.35 CID Sub Total/ 0.170 S1,081,222.52 51,081,222.52 51,081,222.52 51,081,222.52 1 0.00 61.14 Average Certificate Of Deposit 21ST CENTURY 10:General 0.25 CD901365FD3 Fund 2/13/2012 2/13/2013 0.250 248,000.00 248,000.00 248,000.00 247,865.34 136 28.88 0.30 2/13/2013 CDARS 0.6 CD1013981872 10:General 6/19/2014 Fund 6/21/2012 6/19/2014 0.600 500,000.00 500,000.00 500,000.00 500,000.00 627 830.14 0.60 3 of VS Portfolio Settlement Maturity YTM O Face Days To Accrued %of Desalptlon CUSIP/Tldrer Name Date Date Cost Amount/Shares Cost Veins look Value Market Value Maturity Interest Portfolio Feat Commercial 31984GCN7 10:General 8/30/2012 8/30/2013 0.300 248,000.00 248,000.00 248,000.00 247,390.4I 334 0.00 0.30 Bank 0.3 Fund 8/30/2013 Moody National 10:General Bank 0.5 CD60007130B Fund 5/30/2012 11/30/2012 0.500 245,000.00 245,000.00 245,000.00 245,000.00 61 412.81 0.29 11/30/2012 FARMERS& 0.25 CD307812HH3 250ervt Debt 2/17/2012 2/15/2013 0.250 248,000.00 248,000.00 248,000.00 247,869.30 138 383.89 0.30 2/15/2013 CDARS 0.5 C01013981856 30:Water& 8/1/2012 6/20/2013 0.500 500,000.00 500,000.00 500,000.00 500,000.00 263 691.78 0.60 6/20/2013 Sewer SAFRA NATIONAL 30:Water& BANK 0.6 CD786580750 Sewer 8/1/2012 5/5/2014 0.600 248,000.00 248,000.00 248,000.00 248,355.88 582 611.51 0.30 5/5/2014 AMERICAN NATIONAL 30:Water& BANK 0.25 CD0277IPKZ9 Sewer 5/3/2012 5/3/2013 0.250 248,000.00 248,000.00 248,000.00 247,708.35 215 254.79 0.30 5/3/2013 BEAL BANK 0.3 CD07370TKX0 30:Water a: 2/15/2012 2/13/2013 0.300 248,000.00 248,000.00 248,000.00 247,899.31 136 464.75 0.30 2/13/2013 Sewer DISCOVER 35:Street BANK 0.25 CO2546703U4 Assessment 2/15/2012 2/15/2013 0.250 248,000.00 248,000.00 248,000.00 247,860.13 138 387.29 0.30 2/15/2013 GOLDMAN 44:Shadow SACHS 0.25 C038143A)29 Creek 2/15/2012 2/15/2013 0.250 248,000.00 248,000.00 248,000.00 247,860.13 138 387.29 0.30 2/15/2013 Impact KEY BANK 0.25 45: 2/15/2013 C0493065PE0 Hotel/Motel 2/15/2012 2/15/2013 0.250 248,000.00 248,000.00 248,000.00 247,860.13 138 387.29 0.30 Occupancy PACIFIC 47:Park& CONTINENTAL CD69413CCQO Rec 2/15/2012 2/15/2013 0.250 248,000.00 248,000.00 248,000.00 247,871.04 138 25.48 0.30 0.25 Development 2/15/2013 MIZOHO CORP 67:2003 BANK 0.3 CD60688TBR9 Revenue 5/2/2012 5/2/2013 0.300 248,000.00 248,000.00 248,000.00 247,672.64 214 307.79 0.30 5/2/2013 Bonds PRNATE BANK 68:2001 0.25 C074269TBK2 Cert of 2/15/2012 2/15/2013 0.250 248,000.00 248,000.00 248,000.00 247,871.04 138 25.48 0.30 2/15/2013 mown APPLE BANK 0.3 Z202: 2/22l2013 CD037830FX9 2007A Gen 2/22/2012 2/22/2013 0.300 248,000.00 248,000.00 248,000.00 247,886.91 145 450.48 0.30 4of6 lti Portfolio Settlement Maturity YTM• Flee Days To Accrued %of Deseriptlen CUSIP/TIcker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Obligation Sub Total/ 0.361 4,469,000.00 4,469,000.00 4,469,000.00 4,466,970.62 247 5,649.65 5.35 Average FFCB Bond _.-- --- FFCB 0.3 3133EAYL6 10:General 8/1/2012 7/18/2014 0.285 1,000,000.00 1,000,293.48 1,000,268.99 1,000,105.00 656 600.00 1.20 7/18/2014 Fund FFCB 0.75 31331KJQ4 10:General 5/2/2011 5/2/2013 0.750 1,000,000.00 1,000,000.00 1,000,000.00 1,003,102.00 214 3,083.33 1.20 5/2/2013 Fund FFCB 0.25 30:Water& 1/30/2014-12 3133EAA73er 8/1/2012 1/30/2014 0.250 1,000,000.00 1,000,000.00 1,000,000.00 999,017.00 487 416.67 1.20 Sew FFCB 0.34 3133EAMJ4 42:��` 9/27/2012 4/23/2014 0.340 1,000,000.00 1,000,000.00 1,000,000.00 1,000,009.00 570 1,482.78 1.20 4/23/2014-12 Impact Fee FFCB 0.48 67:2003 12/26/2014-13 3133EAV34 Revenue 6/26/2012 12/26/2014 0.480 1,000,000.00 1,000,000.00 1,000,000.00 1,002,197.00 817 1,253.33 1.20 Bonds Sub Total/ 0.421 5,000,000.00 5,000,293.48 5,000,268.99 5,004,430.00 549 6,836.11 5.98 Average FHLB Bond FHLB 3.625 3133XQU34 10:General 5/31/2011 5/29/2013 0.530 1,000,000.00 1,061,320.00 1,020,383.14 1,022,615.00 241 12,184.03 1.20 5/29/2013 Fund 10/24)2012 313384L80 Servke4t 4/26/2012 10/24/2012 0.142 1,000,000.00 999,296.11 999,906.67 999,987.00 24 0.00 1.20 FHLB 3.625 30:Water& 5/29/2013 3133XQU34 Sewer 5/31/2011 5/29/2013 0.530 1,000,000.00 1,061,320.00 1,020,383.14 1,022,615.00 241 12,184.03 1.20 FHLB 1.81 3133XWGP8 42:UtlRy 3/27/2012 3/26/2013 0.240 1,000,000.00 1,015,628.00 1,007,661.64 1,007,960.00 177 201.11 1.20 3/26/2013 Impact Fee FHLB 0.2 67:2003 12/13/2012 313376LR4 Revenue 3/27/2012 12/13/2012 0.182 1,000,000.00 1,000,127.00 1,000,036.21 1,000,040.00 74 594.44 1.20 Bonds FHLB 1.625 67:2003 3133XVEM9 Revenue 2/8/2012 11/21/2012 0.160 1,000,000.00 1,011,506.00 1,002,073.52 1,002,005.00 52 5,822.92 1.20 11/21/2012625 Bonds Sub Total/ 0.297 6,000,000.00 6,149,197.11 6,050,444.32 6,055,222.00 135 30,986.53 7.18 Average FHLMC Bond FHLMC 0 313397DU2 10:General 4/26/2012 4/1/2013 0.173 1,000,000.00 998,394.44 999,135.83 999,444.00 183 0.00 1.20 4/1/2013 Fund 5of6 iS Portfolio Settlement Maturity VTM g Face Days To Accrued %of Description CUSIP/Tldcer Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio FHLMC 0.375 3134G3S87 10:General 3/27/2012 4/28/2014 0.467 1,000,000.00 998,100.00 998,562.98 1,001,888.00 575 2,208.33 1.20 4/28/2014 Fund FHLMC 0.75 3134G1P65 42:UNRY 6/30/2011 12/28/2012 0.433 2,000,000.00 2,009,440.00 2,001,544.09 2,002,850.00 89 3,833.33 2.39 12/28/2012 impact Fee FHLMC 0.35 67:2003 12/5/2014 3134G3H78 Revenue 9/27/2012 12/5/2014 0.330 1,000,000.00 1,000,436.00 1,000,434.34 1,001,000.00 796 320.83 1.20 Bonds Sub Total/ 0.367 5,000,000.00 5,006,370.44 4,999,677.24 5,005,182.00 346 6,362.49 5.93 Average _ FNMA Bond FNMA 0.5 3136GOFF3 10:General 5/1/2012 10/30/2014 0.500 1,000,000.00 1,000,000.00 1,000,000.00 1,001,257.00 760 2,083.33 1.20 10/30/2014-13 Fund FNMA 0.75 3135GOAK9 10:General 2/8/2012 2/26/2013 0.178 1,000,000.00 1,006,000.00 1,002,317.46 1,002,374.00 149 708.33 1.20 2/26/2013 Fund FNMA 0.5 31398A4T6 Fund ei 3/30/2011 10/30/2012 0.624 2,000,000.00 1,996,097.64 1,999,794.61 2,000,548.00 30 4,166.67 2.39 10/30/2012 FNMA 0.375 20:Debt 31398A6F4 1/28/2011 12/28/2012 0.660 1,000,000.00 994,580.00 999,308.75 1,000,688.00 89 958.33 1.20 12/28/2012 Services FNMA 1.05 31398A458 30:Water 8 3/27/2012 10/22/2013 0.361 1,000,000.00 1,010,780.00 1,007,288.42 1,008,062.00 387 4,608.33 1.20 10/22/2013 Sewer FNMA 0.375 31398A6F4 30:Water& 1/28/2011 12/28/2012 0.660 1,000,000.00 994,580.00 999,308.75 1,000,688.00 89 958.33 1.20 12/28/2012 Sewer FNMA O.5 30:Water A 31398A4T6 3/30/2011 10/30/2012 0.624 1,000,000.00 998,048.82 999,897.31 1,000,274.00 30 2,083.33 1.20 10/30/2012 Sewer FNMA 1.3 30:water& 6/20/2012 11/17/2014 0.462 1,000,000.00 1,020,050.00 1,017,737.43 1,020,786.00 778 4,802.78 1.20 11/17/2014 3136FPWZ6 Sewer FNMA 0.5 31398A4T6 42:Utility 3/30/2011 10/30/2012 0.624 1,000,000.00 998,048.82 999,897.31 1,000,274.00 30 2,083.33 1.20 10/30/2012 Impact Fee 70:2005 FNMA 0.5 3136FPUC9 Refurdtg/ 6/30/2011 10/30/2012 0.386 2,000,000.00 2,003,028.20 2,000,189.26 2,000,386.00 30 4,166.67 2.39 10/30/2012 M0blky Sub Total/ 0.507 12,000,000.00 12,021,213.48 12,025,739.30 12,035,337.00 203 26,619.43 14.36 Average - — -- — Total/ 0.265 83,550,222.52 83,727,297.03 83,626,35237 83,648,364.14 106 76,454.21 100 Average 6 6of6 City of Pearland City of Pearland-by Fund Report Format:By Transaction Group By:Portfoio Name Portfolo/Report Group:Report Group:Pearland As of 9/30/2012 Security Settlement Foos YTM @ Maturity Days To %of Description CUSIP/Tidcer Type Date Amount/Shares Book Value Market value Cost Date Maturity Portfolio 10:General Fund Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 5,541,864.72 5,541,864.72 5,541,864.72 0.170 N/A 1 6.63 21ST CENTURY 0.25 Certificate Of 2/13/2013 CD90136SFD3 Depost 2/13/2012 248,000.00 248,000.00 247,865.34 0.250 2/13/2013 136 0.30 CDARS 0.6 6/19/2014 CD1013981872 Certificate Of 6/21/2012 500,000.00 500,000.00 500,000.00 0.600 6/19/2014 627 0.60 Depost First Commercial Bank 31984GCN7 Certificate Of 8/30/2012 248,000.00 248,000.00 247,390.42 0.300 8/30/2013 334 0.30 0.3 8/30/2013 Depost Moody National Bank 0.5 CD600071306 Certificate Of 5/30/2012 245,000.00 245,000.00 245,000.00 0.500 11/30/2012 61 0.29 11/30/2012 Depost FFCB 0.3 7/18/2014 3133EAYL6 FFCB Bond 8/1/2012 1,000,000.00 1,000,268.99 1,000,105.00 0.285 7/18/2014 656 1.20 FFCB 0.75 5/2/2013 31331KJQ4 FFCB Bond 5/2/2011 1,000,000.00 1,000,000.00 1,003,102.00 0.750 5/2/2013 214 1.20 FHLB 3.625 5/29/2013 3133XQU34 FHLB Bond 5/31/2011 1,000,000.00 1,020,383.14 1,022,615.00 0.530 5/29/2013 241 1.20 FHLMC 0 4/1/2013 313397DU2 FHLMC Bond 4/26/2012 1,000,000.00 999,135.83 999,444.00 0.173 4/1/2013 183 1.20 FHLMC 0.375 3134G3SB7 FHLMC Bond 3/27/2012 1,000,000.00 998,562.98 1,001,888.00 0.467 4/28/2014 575 1.20 4/28/2014 FNMA 0.5 3136GOFF3 FNMA Bond 5/1/2012 1,000,000.00 1,000,000.00 1,001,257.00 0.500 10/30/2014 760 1.20 10/30/2014-13 FNMA 0.75 2/26/2013 3135GOAK9 FNMA Bond 2/8/2012 1,000,000.00 1,002,317.46 1,002,374.00 0.178 2/26/2013 149 1.20 FNMA 0.5 10/30/2012 31398A4T6 FNMA Bond 3/30/2011 2,000,000.00 1,999,794.61 2,000,548.00 0.624 10/30/2012 30 2.39 Sub Total/Average 15,782,864.72 13,803,327.73 15,813,453.48 0.357 208 18.89 17:Munklpal Court Security Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 142,669.07 142,669.07 142,669.07 0.170 N/A 1 0.17 Sub Total/Average 142,669.07 142,669.07 142,669.07 0.170 1 0.17 18:City Wide Donation Wels Fargo Sweep Cash WFSWEEP Cash 5/31/2006 71,364.46 71,364.46 71,364.46 0.170 N/A 1 0.09 I of 8 11 Security Settlement Face YTM 0 Maturity Days To %of Desaiplen CUSIP/Tkker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Sub Total/Average 71,364.46 71,364.46 71,364.46 0.170 1 0.09 19:Court Technology Web Fargo Sweep Cash WFSWEEP Cash 5/31/2006 243,607.62 243,607.62 243,607.62 0.170 N/A 1 0.29 Sub Total/Average 243,607.62 243,607.62 243,607.62 0.170 1 0.29 20:Debt Services Web Fargo Sweep Cash WFSWEEP Cash 5/31/2006 2,634,399.38 2,634,399.38 2,634,399.38 0.170 N/A 1 3.15 FARMERS&MERCHANTS CD307812HH3 Certificate Of 2/17/2012 248,000.00 248,000.00 247,869.30 0.250 2/15/2013 138 0.30 0.25 2/15/2013 Depost FHLB 0 10/24/2012 313384L80 FHLB Bond 4/26/2012 1,000,000.00 999,906.67 999,987.00 0.142 10/24/2012 24 1.20 FNMA 0.375 31398A6F4 FNMA Bond 1/28/2011 1,000,000.00 999,308.75 1,000,688.00 0.660 12/28/2012 89 1.20 12/28/2012 Sub Total/Average 4,882,399.38 4,881,614.80 4,882,943.68 0.269 31 5.84 23:Court Juvenile Mgmt Welk Fargo Sweep Cash WFSWEEP Cash 9/15/2009 36,386.36 36,386.36 36,386.36 0.170 N/A 1 0.04 Sub Total/Average 36,386.36 36,386.36 36,386.36 0.170 1 0.04 30:Water&Sewer Web Fargo Sweep Cash WFSWEEP Cash 5/31/2006 5,954,707.29 5,954,707.29 5,954,707.29 0.170 N/A 1 7.13 CDARS 0.5 6/20/2013 CD1013981856 Certificate Of 8/1/2012 500,000.00 500,000.00 500,000.00 0.500 6/20/2013 263 0.60 Depost SAFRA NATIONAL BANK CO786580350 Certificate Of 8/1/2012 248,000.00 248,000.00 248,355.88 0.600 5/5/2014 582 0.30 0.6 5/5/2014 Depost AMERICAN NATIONAL CD02771PKZ9 Certificate Of 5/3/2012 248,000.00 248,000.00 247,708.35 0.250 5/3/2013 215 0.30 BANK 0.25 5/3/2013 Depost REAL BANK 0.3 CD07370TKX0 Certificate Of 2/15/2012 248,000.00 248,000.00 247,899.31 0.300 2/13/2013 136 0.30 2/13/2013 Depost FFCB 0.25 3133EAA73 FFCB Bond 8/1/2012 1,000,000.00 1,000,000.00 999,017.00 0.250 1/30/2014 487 1.20 1/30/2014-12 FHLB 3.625 5/29/2013 3133XQU34 FHLB Bond 5/31/2011 1,000,000.00 1,020,383.14 1,022,615.00 0.530 5/29/2013 241 1.20 FNMA 1.05 10/22/2013 31398A458 FNMA Bond 3/27/2012 1,000,000.00 1,007,288.42 1,008,062.00 0.361 10/22/2013 387 1.20 113 2of8 Seaerty Settlement Face TTM 0 Maturity Days To %of Description CUSIP/Ticker Type Data Amount/Shares Book Value Market Value Cost Date Maturity Portfolio FNMA 0.375 31398A6F4 FNMA Bond 1/28/2011 1,000,000.00 999,308.75 1,000,688.00 0.660 12/28/2012 89 1.20 12/28/2012 FNMA 0.5 10/30/2012 31398A4T6 FNMA Bond 3/30/2011 1,000,000.00 999,897.31 1,000,274.00 0.624 10/30/2012 30 1.20 FNMA 1.3 11/17/2014 3136FPWZ6 FNMA Bond 6/20/2012 1,000,000.00 1,017,737.43 1,020,786.00 0.462 11/17/2014 778 1.20 Sub Total/Average 13,198,707.29 13,243,322.34 13,230,112.83 0.336 180 15.80 31:So8dwaste Wells Fargo Sweep Cash WFSWEEP Cash 12/1/2006 941,865.00 941,865.00 941,865.00 0.170 N/A 1 1.13 Sub Total/Average 941,863.00 941,865.00 941,865.00 0.170 1 1.13 35:Street Assessment Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 343,720.72 343,720.72 343,720.72 0.170 N/A 1 0.41 DISCOVER BANK 0.25 CD2546703U4 Certificate Of 2/15/2012 248,000.00 248,000.00 247,860.13 0.250 2/15/2013 138 0.30 2/15/2013 Deposit Sub Total/Average 391,720.72 591,720.72 591,580.85 0.204 58 0.71 42:Utl ty Impact Fee Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 2,697,415.00 2,697,415.00 2,697,415.00 0.170 N/A 1 3.23 FFCB 0.34 3133EAMJ4 FFCB Bond 9/27/2012 1,000,000.00 1,000,000.00 1,000,009.00 0.340 4/23/2014 570 1.20 4/23/2014-12 FHLB 1.81 3/26/2013 3133XWGP8 FHLB Bond 3/27/2012 1,000,000.00 1,007,661.64 1,007,960.00 0.240 3/26/2013 177 1.20 FHLMC 0.75 3134G1P65 FHLMC Bond 6/30/2011 2,000,000.00 2,001,544.09 2,002,850.00 0.433 12/28/2012 89 2.39 12/28/2012 FNMA 0.5 10/30/2012 31398A4T6 FNMA Bond 3/30/2011 1,000,000.00 999,897.31 1,000,274.00 0.624 10/30/2012 30 1.20 Sub Total/Average 7,697,415.00 7,706,518.04 7,708,508.00 0.328 124 9.21 43:Regional Detention We Fargo Sweep Cash WFSWEEP Cash 5/31/2006 6.46 6.46 6.46 0.170 N/A 1 0.00 Sub Total/Average 6.46 6.46 6.46 0.170 1 0.00 44:Shadow Creek Impact We Fargo Sweep Cash WFSWEEP Cash 5/31/2006 1,300,566.78 1,300,566.78 1,300,566.78 0.170 N/A 1 1.56 3 of 8 '_` Security Settlement Fad YTM 0 Maturity Days To %of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio GOLDMAN SACHS 0.25 CD38143AIZ9 Certificate Of 2/15/2012 248,000.00 248,000.00 247,860.13 0.250 2/15/2013 138 0.30 2/15/2013 DeposR Sub Total/Average 1,548,566.78 1,548,566.78 1,548,426.91 0.183 23 1.85 45:Hotel/Motel Occupancy Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 1,395,313.86 1,395,313.86 1,395,313.86 0.170 N/A 1 1.67 KEY BANK 0.25 CD493065PEO Certificate Of 2/15/2012 248,000.00 248,000.00 247,860.13 0.250 2/15/2013 138 0.30 2/15/2013 DeposIt Sub Total/Average 1,643,313.86 1,643,313.86 1,643,173.99 0.182 22 1.97 46:Park Donations Web Fargo Sweep Cash WFSWEEP Cash 5/31/2006 82,949.75 82,949.75 82,949.75 0.170 N/A 1 0.30 Sub Total/Average 82,949.75 82,949.75 82,949.75 0.170 1 0.10 47:Park&Rec Development --_ - Wets Fargo Sweep Cash WFSWEEP Cash 5/31/2006 692,911.28 692,911.28 692,911.28 0.170 N/A 1 0.83 PACIFIC CONTINENTAL CD69413CCQO Certificate Of D 0.25 2/15/2013 Deposit 2/15/2012 248,000.00 248,000.00 247,871.04 0.250 2/15/2013 138 0.30 Sub Total/Average 940,911.28 940,911.28 940,782.32 0.191 37 1.13 49:Tree Trust Fund Wets Fargo Sweep Cash WFSWEEP Cash 5/31/2006 18,231.91 18,231.91 18,231.91 0.170 N/A 1 0.02 Sub Total/Average 18,231.91 18,231.91 18,231.91 0.170 1 0.02 50:Capital Projects Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 1,876,277.26 1,876,277.26 1,876,277.26 0.170 N/A 1 2.25 Sub Total/Average 1,876,277.26 1,876,277.26 1,876,277.26 0.170 1 2.25 SS:Sidewalk Fund Wets Fargo Sweep Cash WFSWEEP Cash 5/31/2006 205,362.79 205,362.79 205,362.79 0.170 N/A 1 0.25 Sub Total/Average 205,362.79 205,362.79 205,362.79 0.170 1 0.25 60:Police State Seizure 4 of 8 Za Security Settlement Face YTM p Maturity Days To %of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 283,042.25 283,042.25 283,042.25 0.170 N/A 1 0.34 Sub Total/Average 283,042.25 283,042.25 283,042.25 0.170 1 0.34 - 62:Federal Police Fund Web Fargo Sweep Cash WFSWEEP Cash 5/31/2006 32,161.33 32,161.33 32,161.33 0.170 N/A 1 0.04 Sub Total/Average 32,161.33 32,161.33 32,161.33 0.170 1 0.04 64:1998 Cert of Obligation Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 844,306.79 844,306.79 844,306.79 0.170 N/A 1 1.01 Sub Total/Average 844,306.79 844,306.79 844,306.79 0.170 1 1.01 67:2003 Revenue Bonds Wets Fargo Sweep Cash WFSWEEP Cash 5/31/2006 12,104,217.06 12,104,217.06 12,104,217.06 0.170 N/A 1 14.49 MIZUHO CORP BANK 0.3 CO60688T8R9 Certificate Of 5/2/2012 248,000.00 248,000.00 247,672.64 0.300 5/2/2013 214 0.30 5/2/2013 Deposit FFCB 0.48 3133EAVJ4 FFCB Bond 6/26/2012 1,000,000.00 1,000,000.00 1,002,197.00 0.480 12/26/2014 817 1.20 12/26/2014-13 FHLB 0.2 12/13/2012 313376LR4 FHLB Bond 3/27/2012 1,000,000.00 1,000,036.21 1,000,040.00 0.182 12/13/2012 74 1.20 FHLB 1.625 11/21/2012 3133XVEM9 FHLB Bond 2/8/2012 1,000,000.00 1,002,073.52 1,002,005.00 0.160 11/21/2012 52 1.20 FHLMC 0.35 12/5/2014 3134G3H78 FHLMC Bond 9/27/2012 1,000,000.00 1,000,434.34 1,001,000.00 0.330 12/5/2014 796 1.20 Sub Total/Average 16,352,217.06 16,354,761.13 16,357,131.70 0.201 110 19.57 68:2001 Cert of Obigation Weis Fargo Sweep Cash WFSWEEP Cash 5/31/2006 822,053.22 822,053.22 822,053.22 0.170 N/A 1 0.98 PRIVATE BANK 0.25 CD74269TBK2 Certificate Of 2/15/2012 248,000.00 248,000.00 247,871.04 0.250 2/15/2013 138 0.30 2/15/2013 Depos't Sub Total/Average 1,070,053.22 1,070,053.22 1,069,924.26 0.189 33 1.28 70:2005 Refunding/Mobility Web Fargo Sweep Cash WFSWEEP Cash 5/31/2006 853,456.90 853,456.90 853,456.90 0.170 N/A 1 1.02 FNMA 0.5 10/30/2012 3136FPUC9 FNMA Bond 6/30/2011 2,000,000.00 2,000,189.26 2,000,386.00 0.386 10/30/2012 30 2.39 Sub Total/Average 2,853,456.90 2,853,646.16 2,853,842.90 0.321 21 3.42 5of8 24 Security Settlement Face YTM g Maturity Days To %of Dascription CUSIP/Tldter Type Date Amount/Shares leek Value Market Value Cost Date Maturity Portfolio 95:Property Liability Wells Fargo Sweep Cash WFSWEEP Cash 10/31/2006 128,438.65 128,438.65 128,438.65 0.170 N/A 1 0.15 Sub Total/Average 128,438.65 126,436.1{5 126,438.65 0.170 1 0.15 97:Employee Benefit Trust Welt Fargo Sweep Cash WFSWEEP Cash 9/1/2007 36,377.89 36,377.89 36,377.89 0.170 N/A 1 0.04 Sub Total/Average 36,377.89 36,377.89 36,377.89 0.170 1 0.04 99:COI Nsakfi Claims Fund Weis Fargo Sweep Cash WFSWEEP Cash 9/15/2010 424,845.58 424,845.58 424,845.58 0.170 N/A 1 0.51 Welk Fargo Cash WF9871 Cash 7/21/2010 196,712.52 196,712.52 196,712.52 0.160 N/A 1 0.24 Sub Total/Average 821,558.10 621,556.10 621,558.10 0.167 1 0.74 _ Z101:Grant Fund 'Wets Fargo Sweep Cash WFSWEEP Cash 5/31/2006 -143,343.73 -143,343.73 -143,343.73 0.170 N/A 1 -0.17 Sub Total/Average -143,343.73 -143,343.73 -143,343.73 0.170 1 -0.17 2105:2007 CDBG Fund Weis Fargo Sweep Cash WFSWEEP Cash 5/1/2007 187.60 187.60 187.60 0.170 N/A 1 0.00 Sub Total/Average 187.60 187.60 187.60 0.170 1 0.00 Z106:2008 CDBG Fund Weis Fargo Sweep Cash WFSWEEP Cash 3/15/2009 1.14 1.14 1.14 0.170 N/A 1 0.00 Sub Total/Average 1.14 1.14 1.14 0.170 1 0.00 Z107:2009 CDBG Fund Wets Fargo Sweep Cash WFSWEEP Cash 11/1/2009 15.61 15.61 15.61 0.170 N/A 1 0.00 Sub Total/Average 15.61 15.61 15.61 0.170 1 0.00 21011:2010 CDBG Fund Weis Fargo Sweep Cash WFSWEEP Cash 11/1/2010 0.05 0.05 0.05 0.170 N/A 1 0.00 Sub Total/Average 0.05 0.05 0.05 0.170 1 0.00 Z,2_, 6 of 8 Security Settlement Face YTM O Maturity Days To 94 of Description CUSIP/Tkker Type Date Amount/Shams Book Value Market Value Cost Date Maturity Portfolio Z109:2011 CMG Fund Wek Fargo Sweep Cash WFSWEEP Cash 12/1/2011 -16,697.97 -16,697.97 -16,697.97 0.170 N/A 1 -0.02 Sub Total/Average -16,697.97 -16,697.97 -16,697.97 0.170 1 -0.02 Z116:CMG Recovery Fund Wek Fargo Sweep Cash WFSWEEP Cash 7/31/2009 7.40 7.40 7.40 0.170 N/A 1 0.00 Sub Total/Average 7.40 7.40 7.40 0.170 1 0.00 Z140:U of N Fund Wets Fargo Sweep Cash WFSWEEP Cash 12/1/2009 85,699.81 85,699.81 85,699.81 0.170 N/A 1 0.10 Sub Total/Average 85,699.81 85,699.81 85,699.81 0.170 1 0.10 Z145:Municipal Channel Wek Fargo Sweep Cash WFSWEEP Cash 4/15/2012 53,068.06 53,068.06 53,068.06 0.170 N/A 1 0.06 Sub Total/Average 53,068.06 53,068.06 53,068.06 0.170 1 0.06 Z200:2006 Cert of Obligation Wee Fargo Sweep Cash WFSWEEP Cash 6/30/2006 1,625,428.29 1,625,428.29 1,625,428.29 0.170 N/A 1 1.95 Sub Total/Average 1,625,428.29 1,625,428.29 1,625,428.29 0.170 1 1.95 Z201:2007 Cart of Obligation Wee Fargo Sweep Cash WFSWEEP Cash 8/31/2006 1,644,218.73 1,644,218.73 1,644,218.73 0.170 N/A 1 1.97 Sub Total/Average 1,644,218.73 1,644,218.73 1,644,218.73 0.170 1 1.97 Z202:2007A Gen Obligation Wells Fargo Sweep Cash WFSWEEP Cash 12/31/2007 3,586,125.70 3,586,125.70 3,586,125.70 0.170 N/A 1 4.29 APPLE BANK 0.3 Certllcate Of 0.30 2/22/2013 CD037830FX9 Depos[ 2/22/2012 248,000.00 248,000.00 247,886.91 0.300 2/22/2013 145 Sub Total/Average 3,834,125.70 3,834,125.70 3,834,012.61 0.178 10 4.59 Z203:2009 Gen Obligation Wee Fargo Sweep Cash WFSWEEP Cash 10/30/2008 2,378,902.72 2,378,902.72 2,378,902.72 0.170 N/A 1 2.85 7 of 8 ZS Security Settlement Face YTM O Maturity Days To Mr or Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cast Date Maturity Portlab Sub Total/Average 2,378,902.72 2,378,902.72 2,378,902.72 0.170 1 2.85 Z301:W/S Pay As U Go OP We Fargo Sweep Cash WFSWEEP Cash 12/31/2007 1,962,377.21 1,962,377.21 1,962,377.21 0.170 N/A 1 2.35 Sub Total/Average 1,962,377.21 1,962,377.21 1,962,377.21 0.170 1 2.35 'Total/Average 83,550,222.52 83,626,352.37 83,648,364.14 0.265 106 100 8of8 2.1{ City of Pearland Purchases Portfob/Report Group:Report Group:Pearland From 6/30/2012 To 9/30/2012 YTM Portfolio Settlement Maturity Foos 0 Name Description Bullet/Callable CUSIP/Tldcer Action Date Date Price Amount/Shares Cost Principal Irterest/Dividends Broker/Dealer 30: FFCB 0.25 Weis Fargo Water& 1/30/2014-12 Yes 3133EAA73 Buy 8/1/2012 1/30/2014 100 1,000,000.00 0.250 1,000,000.00 6.94Bank Sewer 10: FFCB 0.3 Web Fargo General 7/18/2014 3133EAYL6 Buy 8/1/2012 7/18/2014 100.029348 1,000,000.00 0.285 1,000,293.48 108.33Bank Fund 30: SAFRA NAL Water& NATIO C0786580350 Buy 8/1/2012 5/5/2014 100 248,000.00 0.600 248,000.00 366.90 BWark Fargo Sewer BANK 0.6 5/5/2014 30: CDARS 0.5 Independence Water& 6/20/2013 CD1013981856 Buy 8/1/2012 6/20/2013 100 500,000.00 0.500 500,000.00 280.82Bank Sewer 10: First General Commercial 319840CN7 Buy 8/30/2012 8/30/2013 100 248,000.00 0.300 248,000.00 0.00 WellsBa Fargo Fund Bankank0.3 .0.3 8/30/2013 42: Utity FFCB 0.34 Yes an 3133EAM34 Buy 9/27/2012 4/23/2014 100 1,000,000.00 0.340 1,000,000.00 Impact 4/23/2014-12 1,454.44 Wirt Fee 67: 2003 FHLMC 035 Duncan 3134G3H78 Buy 9/27/2012 12/5/2014 100.0436 1,000,000.00 0.330 1,000,436.00 291.67 W Revenue 12/5/2014 Bonds 1 of I 2S Pledged Collateral Reconciliation Report September 30, 2012 Bank Account Number Account Name Amount Wells Fargo 201-0419505 Operating $ - Wells Fargo 201-0419513 Payroll Fund - Wells Fargo 0 01-304284 1 Sweep Account 57,594,144.23 Wells Fargo 201-0419554 98 CO Escrow - Wells Fargo 807-1613395 Credit Card Account 620,889.88 Wells Fargo 818-4567843 Alvin ISD 4,222,256.28 Wells Fargo 001-3043112 PEDC Sales Tax - Wells Fargo 280-7409871 Health Claims 201,496.15 Wells Fargo 865-9860145 BC MUD#4 1.44 Wells Fargo Certificate of Deposit - Total of Bank Balances $ 62,638,787.98 Pledged Collateral for City 92,979,805.97 FDIC Insurance 250,000.00 Total Collateral $ 93,229,805.97 Over(Under)Collateralized $ 30,591,017.99 Total%Collateralized 148.8% Bank Account Number Account Name Amount Wells Fargo 100-7284258 Development Authority 656,251.90 Total of Bank Balances $ 656,251.90 Pledged Collateral for DAP 8,145,221.83 FDIC Insurance 250,000.00 Total Collateral $ 8,395,221.83 Over(Under)Collateralized $ 7,738,969.93 Total%Collateralized 1279.3% Total$Over(Under)Collateralized $ 38,329,987.92 Total%Collateralized 160.6% Status Collateralized ^7 I:UnvestmentsVnvestment Reports\City of Peartand\In estment Report-City-CV 0912 `6