Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R-2013-029-2013-02-11
RESOLUTION NO. R2013-29 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS, ACCEPTING THE CITY'S INVESTMENT REPORT FOR THE QUARTER ENDING DECEMBER 2012. BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS: Section 1. That the City Council hereby accepts the Quarterly Investment Report attached hereto as Exhibit "A" for the quarter ending December 2012. PASSED, APPROVED, AND ADOPTED this 11th day of February, A.D., 2013. ATTEST: APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY REID MAYOR ?t: \!fir ;7G; '�hi�f.!(ttaitif )711 T�IDf Resolution No. R2013-29 Exhibit "A" City of Pearland Quarterly Investment Report Sept 30, 2012 - Dec 31, 2012 Portfolio at Sept 30, 2012 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 $ 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% Portfolio at Dec 31. 2012 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.22% 0.17% 0.13% $ 100,468,834.69 100,485,235.58 46,170.04 49,924.31 16,400.89 (5,610.88) 107 Days 16,836,871.44 0.20% 0.16% 0.11% This quarterly report is in complian:e with the investment policy and strategy as established by the City and the Public Funds Investment Act (Chapter 2256, Texas Government Code). Prepared by: Ly,a,Ld Claire Bogard Director of Finance Rick O'er, aar Assistant Direc Fati a Uwakwe r of Finance Accounting Supervisor FFCB 8% Des.&jp Ion Cash CD FFCB FHLB FHLMC FNMA Total/Average Face Amount \hares 73,910,16(,.93 $ 5,961,577.26 8,500,000.00 5,000,000.00 3,000,000.00 4,000,000.00 100,371,744.19 $ Group Portfolio Holdings by Type FHLMC FHLB 3% 5% FNMA 4% Summary by Type December 31, 2012 Cost_yalue 73,910,166.93 $ 5,961,577.26 8,534,256.03 5,154,518.00 2,996,930.44 4,036,830.00 100,594,278.66 $ Cash 74% Book Value 73,910,166.93 5,961,577.26 8,531,672.18 5,044,612.65 2,998,747.48 4,022,058.19 100,468,834.69 Market Value YTM @ Cust Day; To. Maturity $ 73,910,166.93 0.14% 5,960,751.65 0.40% 8,535,614.00 0.36% 5,048,602.00 0.38% 3,002,738.00 0.32% 4,027,363.00 0.38% $ 100,485,235.58 0.20% 80,000,000 70,000,000 60,000,000 50,000,000 40,000,000 30,000,000 - 20,000,000 10,000,000 Book Value by Maturity 1 255 522 355 426 426 107 1- 30 DaYs 31- 60 DaYS 61- 90 Days91.120 DaY121- 180 Days > 180 DaYS Interest Rates Dae 1 mo 3 mo 6_02 1 yr 2 yr 3 al( 7 yr 10 yr 20 yr 30 yr 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 12/31/2012 0.02 0.05 0.11 0.16 0.25 0.36 0.72 1.18 1.78 2.54 2.95 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 1mo 3no 6mo Yield Curve Comparison C :y's Weighted Avg Yield .22% 1 7Day Average Maturity 0.35% 0.30% 0.25% 0.20% 0.15% 0.10% 0.05% 0.00% 1 yr 2 yr 3 yr 5 yr 7 yr --.-9/28/2012 —f-12/31/2012 Portfolio vs. Benchmarks 10 yr 20 yr 30 yr Jan -12 Fe -12 Mar -12 Apr -12 May -12 Jun -12 Jul -12 Aug -12 Sep -12 Oct -12 Nov -12 Dec -12 —+—Port Total --E-1 Yr T -Bill --*—Agency Note 1 of 7 City of Pearland Quarterly Investment Report Report Format: By CUSIP Group By: Security Type Portfolio/Report Group: Report Group: Pearland Begin Date: 9/30/2012, End Date: 12/31/2012 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Tkker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV CASH Weiss Fargo WF1790 10: General 0.04000 N/A 0.00 71,435.67 0.00 0.00 0.00 71,435.67 0.60 Cash Fund Wells Fargo WFSWEEP 10: General 0.14000 N/A 5,136,624.62 6,636,930.37 448,479.41 0.00 0.00 11,325,075.58 2,283.46 Sweep Cash Fund Wells Fargo 17: Municipal Sweep Cash WFSWEEP Court 0.14000 N/A 142,669.07 402.19 2,546.10 0.00 0.00 140,525.16 47.80 Security Wells Fargo 18: City Sweep Cash WFSWEEP Wide 0.14000 N/A 71,364.46 6,813.65 5,380.79 0.00 0.00 72,797.32 24.62 Donation Wells Fargo WFSWEEP 19: Court 0.14000 N/A 243,607.62 8,246.83 6,245.62 0.00 0.00 245,608.83 81.61 Sweep Cash Technology Wells Fargo WFSWEEP 20: Debt 0.14000 N/A 2,634,399.38 15,669,812.40 0.00 0.00 0.00 18,304,211.78 2,964.92 Sweep Cash Services Wells Fargo 23: Court Sweep Cash WFSWEEP Juvenile 0.14000 N/A 36,386.36 2,514.42 2,423.71 0.00 0.00 36,477.07 12.43 Mgmt Wells Fargo WFSWEEP 30: Water& 0.14000 N/A 5,791,208.43 4,344,593.29 98,277.79 0.00 0.00 10,037,523.93 2,626.59 Sweep Cash Sewer Wells Fargo WFSWEEP 31: 0.14000 N/A 941,865.00 99,547.41 597,892.88 0.00 0.00 443,519.53 135.82 Sweep Cash Solidwaste Wells Fargo WFSWEEP 35: Street 0.14000 N/A 343,720.72 110.78 55,364.50 0.00 0.00 288,467.00 110.78 Sweep Cash Assessment Wells Fargo WFSWEEP 42: Utitty 0.14000 N/A 2,697,344.34 2,563,660.49 959,406.92 0.00 0.00 4,301,597.91 1,194.54 Sweep Cash Impact Fee Wells Fargo WFSWEEP 43: Regional 0.14000 N/A 6.46 10,426.02 0.00 0.00 0.00 10,432.48 1.02 Sweep Cash Detention 44: Shadow Wells Fargo Sweep Cash WFSWEEP Creek 0.14000 N/A 1,300,566.78 296,097.03 98,512.25 0.00 0.00 1,498,151.56 517.39 Impact Wells Fago 45: r Sweep Cash WFSWEEP Hotel/Motel 0.14000 N/A 1,395,313.86 99,309.37 56,599.20 0.00 0.00 1,438,024.03 491.55 Occupancy Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Prindpai Discount Premium Ending BV Income -BV Wells Fargo WFSWEEP 46: Park 0.14000 N/A 81,849.75 15,610.57 6,705.38 0.00 0.00 90,754.94 26.95 Sweep Cash Donations Wells Fargo 47: Park & Sweep Cash WFSWEEP Rec 0.14000 N/A 692,911.28 205.09 91,528.68 0.00 0.00 601,587.69 205.09 Development Wells Fargo WFSWEEP 49: Tree 0.14000 N/A 18,231.91 256.24 0.00 0.00 0.00 18,488.15 6.24 Sweep Cash Trust Fund Wells Fargo WFSWEEP 50: CapRal 0.14000 N/A 1,876,277.26 726,646.73 503,511.09 0.00 0.00 2,099,412.90 805.19 Sweep Cash Projects Welts Fargo WFSWEEP 55: Sidewalk 0.14000 N/A 205,362.79 69.44 0.00 0.00 0.00 205,432.23 69.44 Sweep Cash Fund 60: Police Wells Fargo Sweep CashWFSWEEP State 0.14000 N/A 283,042.25 1,602.51 46,815.14 0.00 0.00 237,829.62 82.35 Seizure Wells Fargo WFSWEEP 62: Federal 0.14000 N/A 32,161.33 14.12 3.25 0.00 0.00 32,172.20 10.87 Sweep Cash Police Fund Wells Fargo 64: 1998 Sweep Cash WFSWEEP Cert of 0.14000 N/A 844,306.79 2,285.54 2,000.00 0.00 0.00 844,592.33 285.54 Obligation Wells Fargo 67: 2003 Sweep Cash WFSWEEP Revenue 0.14000 N/A 12,104,217.06 3,352.56 3,696,043.91 0.00 0.00 8,411,525.71 3,352.56 Bonds Wells Fargo 68: 2001 Sweep Cash WFSWEEP Cert of 0.14000 N/A 822,053.22 288.22 291,875.84 0.00 0.00 530,465.60 237.26 Obligation Wells Fargo 70: 2005 Sweep Cash WFSWEEP Refunding / 0.14000 N/A 662,513.79 1,986,912.56 802,790.84 0.00 0.00 1,846,635.51 795.99 Mobility Wells Fargo WFSWEEP 95: Property 0.14000 N/A 128,438.65 305,694.29 618,992.40 0.00 0.00 -184,859.46 0.00 Sweep Cash Liability Wells Fargo 97: Sweep Cash WFSWEEP Employee 0.14000 N/A 32,837.80 34,115.15 41,733.51 0.00 0.00 25,219.44 19.08 Benefit Trust 99: COP Wells Fargo Cash WF9871 Heath 0.14000 N/A 196,712.52 1,300,473.00 1,281,748.65 0.00 0.00 215,436.87 112.36 Claims Fund Welts Fargo 99: COP Sweep Cash WFSWEEP Health 0.14000 N/A 424,845.58 456,871.05 431,873.18 0.00 0.00 449,843.45 0.00 Claims rund Wells Fargo WFSWEEP Z101: Grant 0.14000 N/A 0.00 129,817.79 141,856.48 0.00 0.00 -12,038.69 0.00 Sweep Cash Fund 2 of 7 3 of7 Ending Portfolio ¥TM @ Maturity Amortized Amortized Investment Description CUSIP/Tiicker Name Cost Date Beginning BV Buy Principal Sep Prindpal Discount Premium Ending BV Income -BV Wells Fargo WFSWEEP Z105: 2007 0.14000 N/A 187.60 0.03 0.00 0.00 0.00 187.63 0.03 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z106: 2008 0.14000 N/A 1.14 0.00 0.00 0.00 0.00 1.14 0.00 Sweep Cash CDBG Fund Weiss Fargo WFSWEEP Z107: 2009 0.14000 N/A 15.61 0.00 0.00 0.00 0.00 15.61 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z108: 2010 0.14000 N/A 0.05 0.00 0.00 0.00 0.00 0.05 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z109: 2011 0.14000 N/A 0.00 15,705.75 15,889.99 0.00 0.00 -184.24 0.00 Sweep Cash CDBG Fund Wells Fargo Z116: WFSWEEP Recovery BG Sweep Cash 0.14000 N/A 7.40 0.00 0.00 0.00 0.00 7.40 0.00 Fund Wells Fargo WFSWEEP Z140: U of 11 0.14000 N/A 78,620.19 18.25 62,352.50 0.00 0.00 16,285.94 18.25 Sweep Cash Fund Wells Fargo Z145: Sweep Cash WFSWEEP Municip al 0.14000 N/A 53,068.06 30,262.67 6,459.57 0.00 0.00 76,871.16 22.57 Channel Wells Fargo Z200: 2006 Sweep Cash WFSWEEP Cert of 0.14000 N/A 1,625,428.29 545.58 25,285.45 0.00 0.00 1,600,688.42 545.58 Obligation Wells Fargo Z201: 2007 Sweep Cash WFSWEEP Cert of 0.14000 N/A 1,644,218.73 539.77 64,106.02 0.00 0.00 1,580,652.48 539.77 Obligation Wells Fargo Z202: Sweep Cash WFSWEEP 2007A Gen 0.14000 N/A 3,777,068.81 1,083.39 706,279.07 0.00 0.00 3,071,873.13 1,083.39 Obligation Wells Fargo Z203: 2009 Sweep Cash WFSWEEP Gen 0.14000 N/A 2,378,902.72 69,199.70 406,252.96 0.00 0.00 2,041,849.46 708.39 Obligation Wells Fargo Z301: W/S Sweep Cash WFSWEEP Pay As U Go 0.14000 N/A 1,962,377.21 653.38 67,458.18 0.00 0.00 1,895,572.41 653.38 CIP Sub Total/Average 0.13990 50,660,734.89 34,892,123.30 11,642,691.26 0.00 0.00 73,910,166.93 20,073.41 Cash CERTIFICATE OF DEPOSIT f Irsl Commercial Bank 0.3 31984GCN7 10: General Fund 0.30000 8/30/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 250.72 Ending Portfolio YTM (' Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Prinapal Discount Premium Ending BV Income -BV 8/30/2013 Synovus Bank 10: General GA 0.5 87164DBV1 Fund 0.50000 5/30/2013 0.00 248,000.00 0.00 0.00 0.00 248,000.00 105.32 5/30/2013 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 766.87 6/19/2014 Fund CDARS 0.5 CD1014682593 10: General 0.50000 12/19/2013 0.00 500,000.00 0.00 0.00 0.00 500,000.00 75.34 12/19/2013 Fund Moody National 10: General Bank 0.5 CD60007130B Fund 11/30/2012 245,000.00 0.00 245,000.00 0.00 0.00 0.00 164.45 11/30/2012 Moody National 10: General Bank 0.5 CD7130 Fund 0.50000 5/30/2013 0.00 245,577.26 0.00 0.00 0.00 245,577.26 104.29 5/30/2013 21ST CENTURY 10: General 0.25 CD90136SFD3 Fund 0.25000 2/13/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 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 CD02771PKZ9 30: Water & 0.25000 5/3/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 BANK 0.25 Sewer 5/3/2013 Bay Cities Bank 30: Water & 0.5 CD07203QBR2 Sewer 0.50000 12/12/2014 0.00 248,000.00 0.00 0.00 0.00 248,000.00 64.55 12/12/2014 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.52 2/13/2013 Sewer CDARS0.5 CD1013981856 30: Water& 0.50000 6/20/2013 500,000.00 0.00 0.00 0.00 0.00 500,000.00 630.14 6/20/2013 Sewer SAFRA NATIONAL CD786580350 30: Water & 0.60000 5/5/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 375.06 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.27 2/15/2013 BMW Bank of 42: Utility NA 0.85 CD05568P2Q9 Impact Fee 0.85000 6/8/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 138.61 6/8/2015 4 of 7 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Tiicker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV GOLDMAN 44: Shadow SACHS 0.25 CD38143AJZ9 Creek 0.25000 2/15/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.27 2/15/2013 Impact 45: KEY BANK 0.25 2/15/2013 CD49306SPEO Hotel/Motel 0.25000 2/15/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.27 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 Development 2/15/2013 MIZUHO CORP 67: 2003 BANK 0.3 CD60688T8R9 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 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 First State Bank 70: 2005 - WV 0.35 CD33648FHR9 Refunding/ 0.35000 12/3/2014 0.00 248,000.00 0.00 0.00 0.00 248,000.00 66.59 12/3/2014 Mobility 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 Obligation Sub Total/Average Certificate Of Deposit FFCB BOND FFCB 0.75 5/2/2013 FFCB 0.32 3/12/2015-12 FFCB 0.3 7/18/2014 FFCB 0.25 1/30/2014-12 FFCB 0.3 1/9/2015-13 FFCB 0.34 4/23/2014-12 5 of 7 31331KJQ4 3133EAU30 3133EAYL6 3133EAA73 3133EA3U0 3133EAMJ4 10: General Fund 10: General Fund 10: General Fund 30: Water & Sewer 42: Utility Impact Fee 42: Utility Impact Fee 0.40439 4,469,000.00 1,737,577.26 245,000.00 0.00 0.00 5,961,577.26 4,554.72 0.75000 5/2/2013 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,895.84 0.32000 3/12/2015 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 533.33 0.28461 7/18/2014 1,000,268.99 0.00 0.00 0.00 -37.78 1,000,231.21 720.55 0.25000 1/30/2014 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 625.00 0.30000 1/9/2015 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 266.66 0.34000 4/23/2011 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 859.44 Ending Portfolio YTM c Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Seo Prindpal Discount Premium Ending BV Income -BV FFCB 2.125 67: 2003 2/10/2014 31331JDY6 Revenue 0.23004 2/10/2014 0.00 1,533,962.55 0.00 0.00 -2,521.58 1,531,440.97 311.76 Bonds 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,213.34 Bonds Sub Total/Average FFCB Bond FHLB BOND FHLB 3.625 5/29/2013 FHLB 0 10/24/2012 FHLB 1.15 10/30/2014 FHLB 3.625 5/29/2013 FHLB 1.81 3/26/2013 FHLB 0.2 12/13/2012 3133XQU34 313384180 3133743W8 3133XQU34 3133XWGP8 313376LR4 FHLB 0.32 313381G58 12/26/2014-13 FHLB 1.625 11/21/2012 10: General Fund 20: Debt Services 30: Water & Sewer 30: Water & Sewer 42: Utility Impact Fee 67: 2003 Revenue Bonds 67: 2003 Revenue Bonds 67: 2003 3133XVEM9 Revenue Bonds 0.36061 5,000,268.99 3,533,962.55 0.00 0.00 -2,559.36 8,531,672.18 6,425.92 0.53011 5/29/2013 1,020,383.14 0.00 0.00 0.00 -7,675.66 1,012,707.48 1,487.53 10/24/2012 999,906.67 0.00 1,000,000.00 93.33 0.00 0.00 93.33 0.30034 10/30/2014 0.00 1,016,250.00 0.00 0.00 -752.53 1,015,497.47 237.75 0.53011 5/29/2013 1,020,383.14 0.00 0.00 0.00 -7,675.66 1,012,707.48 1,487.53 0.24004 3/26/2013 1,007,661.64 0.00 0.00 0.00 -3,961.42 1,003,700.22 613.86 12/13/2012 1,000,036.21 0.00 1,000,000.00 0.00 -36.21 0.00 369.35 0.32000 12/26/2014 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 44.44 11/21/2012 1,002,073.52 0.00 1,000,000.00 0.00 -2,073.52 0.00 228.56 Sub Total/Average FHLB Bond FHLMC BOND FHLMC 0 4/1/2013 FHLMC 0.375 4/28/2014 6 of 7 313397DU2 3134G3SB7 10: General Fund 10: General Fund 0.38689 6,050,444.32 2,016,250.00 3,000,000.00 93.33 -22,175.00 5,044,612.65 4,562.35 0.17257 4/1/2013 999,135.83 0.46657 4/28/2014 998,562.98 0.00 0.00 434.45 0.00 0.00 0.00 230.23 999,570.28 434.45 0.00 998,793.21 1,178.15 Ending Portfolio YTM 0 Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Seo Prindpal Discount Premium Ending BV Income -BV FHLMC 0.75 12/28/2012 FHLMC 0.35 12/5/2014 3134G1P65 42: Utility Impact Fee 12/28/2012 2,001,544.09 67: 2003 3134G3H78 Revenue 0.33000 12/5/2014 1,000,434.34 Bonds 0.00 2,000,000.00 0.00 -1,544.09 0.00 2,122.58 0.00 0.00 0.00 -50.35 1,000,383.99 834.38 Sub Total/Average 0.32304 4,999,677.24 •0.00 2,000,000.00 664.68 -1,594.44 2,998,747.48 4,569.56 FHLMC Bond FNMA BOND FNMA 0.75 2/26/2013 FNMA 0.5 10/30/2014-13 FNMA 0.5 10/30/2012 FNMA 0.375 12/28/2012 FNMA 1.3 11/17/2014 FNMA 1.05 10/22/2013 FNMA 0.5 10/30/2012 FNMA 0.375 12/28/2012 FNMA 0.5 10/30/2012 FNMA 0.5 10/30/2012 3135GOAK9 3136GOFF3 31398A4T6 31398A6F4 3136FPWZ6 31398A4S8 31398A4T6 31398A6F4 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 / Mobility 0.17780 2/26/2013 1,002,317.46 0.00 0.00 0.00 -1,444.44 1,000,873.02 451.40 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/2012 1,999,794.61 0.00 2,000,000.00 205.39 0.00 0.00 1,038.72 12/28/2012 999,308.75 0.00 1,000,000.00 691.25 0.00 0.00 1,607.92 0.46187 11/17/2014 1,017,737.43 0.00 0.00 0.00 -2,104.44 1,015,632.99 1,181.67 0.36058 10/22/2013 1,007,288.42 0.00 0.00 0.00 -1,736.24 1,005,552.18 917.93 10/30/2012 999,897.31 0.00 1,000,000.00 102.69 0.00 0.00 519.36 12/28/2012 999,308.75 0.00 1,000,000.00 691.25 0.00 0.00 1,607.92 10/30/2012 999,897.31 0.00 1,000,000.00 102.69 0.00 0.00 519.36 10/30/2012 2,000,189.26 0.00 2,000,000.00 0.00 -189.26 0.00 644.07 Sub Total/Average 0.37516 12,025,739.30 0.00 8,000,000.00 1,793.27 -5,474.38 4,022,058.19 9,738.35 FNMA Bond Total / Average 7 of 7 0.20186 83,205,864.74 42,179,913.11 24,887,691.26 2,551.28 -31,803.18 100,468,834.69 49,924.31 City of Pearland Quarterly Investment Report at Quarterend Report Format: By Transaction Group By: Security Type Portfolio/Report Group: Report Group: Pearland As of 12/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 Wells Fargo WFSWEEP 10: General 5/31/2006 N/A 0.140 11,325,075.58 11,325,075.58 11,325,075.58 11,325,075.58 1 11.28 Sweep Cash Fund Wells Fargo WF1790 10: General 12/15/2012 N/A 0.040 71,435.67 71,435.67 71,435.67 71,435.67 1 0.07 Cash Fund Wells Fargo 17: Municipal Sweep Cash WFSWEEP Court 5/31/2006 N/A 0.140 140,525.16 140,525.16 140,525.16 140,525.16 1 0.14 Security Wells Fargo 18: City Sweep Cash WFSWEEP Wide 5/31/2006 N/A 0.140 72,797.32 72,797.32 72,797.32 72,797.32 1 0.07 Donation Welk Fargo WFSWEEP 19: Court 5/31/2006 N/A 0.140 245,608.83 245,608.83 245,608.83 245,608.83 1 0.24 Sweep Cash Technology Wells Fargo WFSWEEP 20: Debt 5/31/2006 N/A 0.140 18,304,211.78 18,304,211.78 18,304,211.78 18,304,211.78 1 18.24 Sweep Cash Services Wells Fargo 23: Court Sweep Cash WFSWEEP Juvenile 9/15/2009 N/A 0.140 36,477.07 36,477.07 36,477.07 36,477.07 1 0.04 Mgmt Wells Fargo WFSWEEP 30: Water & 5/31/2006 N/A 0.140 10,037,523.93 10,037,523.93 10,037,523.93 10,037,523.93 1 10.00 Sweep Cash Sewer Wells Fargo WFSWEEP 31: 12/1/2006 N/A 0.140 443,519.53 443,519.53 443,519.53 443,519.53 1 0.44 Sweep Cash Solidwaste Wells Fargo WFSWEEP 35: Street 5/31/2006 N/A 0.140 288,467.00 288,467.00 288,467.00 288,467.00 1 0.29 Sweep Cash Assessment Wells Fargo WFSWEEP 42: Utility 5/31/2006 N/A 0.140 4,301,597.91 4,301,597.91 4,301,597.91 4,301,597.91 1 4.29 Sweep Cash Impact Fee Wells Fargo WFSWEEP 43: Regional 5/31/2006 N/A 0.140 10,432.48 10,432.48 10,432.48 10,432.48 1 0.01 Sweep Cash Detention 44: Shadow Wells Fargo Sweep CashWFSWEEP Creek 5/31/2006 N/A 0.140 1,498,151.56 1,498,151.56 1,498,151.56 1,498,151.56 1 1.49 Impact Wells Fargo 45: Sweep Cash WFSWEEP HotelMotel 5/31/2006 N/A 0.140 1,438,024.03 1,438,024.03 1,438,024.03 1,438,024.03 1 1.43 Occupancy Wells Fargo WFSWEEP 46: Park 5/31/2006 N/A 0.140 90,754.94 90,754.94 90,754.94 90,754.94 1 0.09 Sweep Cash Donations 1 of 6 2 of 6 Portfolio Settlement Maturity YTM @ Face Days To Accrued % of Description CUSXP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio 47: Park & Wells Fargo Sweep Cash WFSWEEP Rec 5/31/2006 N/A 0.140 601,587.69 601,587.69 601,587.69 601,587.69 1 0.60 Development Wells Fargo WFSWEEP 49: Tree 5/31/2006 N/A 0.140 18,488.15 18,488.15 18,488.15 18,488.15 1 0.02 Sweep Cash Trust Fund Wells Fargo WFSWEEP 50: Capital 5/31/2006 N/A 0.140 2,099,412.90 2,099,412.90 2,099,412.90 2,099,412.90 1 2.09 Sweep Cash Projects Welk Fargo WFSWEEP 55: Sidewalk 5/31/2006 N/A 0.140 205,432.23 205,432.23 205,432.23 205,432.23 1 0.20 Sweep Cash Fund 60: Police Welk Fargo Sweep Cash WFSWEEP State 5/31/2006 N/A 0.140 237,829.62 237,829.62 237,829.62 237,829.62 1 0.24 Seizure Welk Fargo WFSWEEP 62: Federal 5/31/2006 N/A 0.140 32,172.20 32,172.20 32,172.20 32,172.20 1 0.03 Sweep Cash Police Fund Welk Fargo 64: 1998 Sweep Cash WFSWEEP Cert of 5/31/2006 N/A 0.140 844,592.33 844,592.33 844,592.33 844,592.33 1 0.84 Obligation Welk Fargo 67: 2003 Sweep Cash WFSWEEP Revenue 5/31/2006 N/A 0.140 8,411,525.71 8,411,525.71 8,411,525.71 8,411,525.71 1 8.38 Bonds Welk Fargo 68: 2001 Sweep Cash WFSWEEP Cert of 5/31/2006 N/A 0.140 530,465.60 530,465.60 530,465.60 530,465.60 1 0.53 Obligation Welk Fargo 70: 2005 Sweep Cash WFSWEEP Refunding / 5/31/2006 N/A 0.140 1,846,635.51 1,846,635.51 1,846,635.51 1,846,635.51 1 1.84 Mobilty Welk Fargo WFSWEEP 95: Property 10/31/2006 N/A 0.140 -184,859.46 -184,859.46 -184,859.46 -184,859.46 1 -0.18 Sweep Cash Uabity 97: Welk Fargo Sweep CashWFSWEEP Employee 9/1/2007 N/A 0.140 25,219.44 25,219.44 25,219.44 25,219.44 1 0.03 Benefd Trust 99: COP Welk Fargo Sweep Cash WFSWEEP Health 9/15/2010 N/A 0.140 449,843.45 449,843.45 449,843.45 449,843.45 1 0.45 Claims Fund Welk Fargo 99: COP Cash WF9871 Health 7/21/2010 N/A 0.140 215,436.87 215,436.87 215,436.87 215,436.87 1 0.21 Claims Fund Welk Fargo WFSWEEP 2101: Grant 5/31/2006 N/A 0.140 -12,038.69 -12,038.69 -12,038.69 -12,038.69 1 -0.01 Sweep Cash Fund Welk Fargo WFSWEEP Z105: 2007 5/1/2007 N/A 0.140 187.63 187.63 187.63 187.63 1 0.00 Sweep Cash CDBG Fund Welk Fargo WFSWEEP Z106: 2008 3/15/2009 N/A 0.140 1.14 1.14 1.14 1.14 1 0.00 Sweep Cash CDBG Fund Portfolio Settlement Maturity YTM @ Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Wells Fargo WFSWEEP Z107: 2009 11/1/2009 N/A 0.140 15.61 15.61 15.61 15.61 1 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP 2108: 2010 11/1/2010 N/A 0.140 0.05 0.05 0.05 0.05 1 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z109: 2011 12/1/2011 N/A 0.140 -184.24 -184.24 -184.24 -184.24 1 0.00 Sweep Cash CDBG Fund Wells Fargo Z116: CDBG Sweep Cash WFSWEEP Recovery 7/31/2009 N/A 0.140 7.40 7.40 7.40 7.40 1 0.00 Fund Wells Fargo WFSWEEP Z140: U of H 12/1/2009 N/A 0.140 16,285.94 16,285.94 16,285.94 16,285.94 1 0.02 Sweep Cash Fund Z145: Wells Fargo Sweep CashWFSWEEP Municipal 4/15/2012 N/A 0.140 76,871.16 76,871.16 76,871.16 76,871.16 1 0.08 Channel Wells Fargo 2200: 2006 Sweep Cash WFSWEEP Cert of 6/30/2006 N/A 0.140 1,600,688.42 1,600,688.42 1,600,688.42 1,600,688.42 1 1.59 Obligation Wells Fargo Z201: 2007 Sweep Cash WFSWEEP Cert of 8/31/2006 N/A 0.140 1,580,652.48 1,580,652.48 1,580,652.48 1,580,652.48 1 1.57 Obligation Wells Fargo Z202: Sweep Cash WFSWEEP 2007A Gen 12/31/2007 N/A 0.140 3,071,873.13 3,071,873.13 3,071,873.13 3,071,873.13 1 3.06 Obligation Wells Fargo Z203: 2009 Sweep Cash WFSWEEP Gen 10/30/2008 N/A 0.140 2,041,849.46 2,041,849.46 2,041,849.46 2,041,849,46 1 2.03 Obligation Wells Fargo Z301: W/S Sweep Cash WFSWEEP Pay As U Go 12/31/2007 N/A 0.140 1,895,572.41 1,895,572.41 1,895,572.41 1,895,572.41 1 1.89 CIP Sub Total / Average Certificate Of Deposit Moody National Bank 0,5 CD7130 5/30/2013 21ST CENTURY 0.25 2/13/2013 CDARS 0.5 12/19/2013 CDARS 0.6 6/1.9/2014 3 of 6 CD90136SFD3 0.140 73,910,166.93 73,910,166.93 73,910,166.93 73,910,166.93 1 0.00 73.64 10: General 11/30/2012 5/30/2013 0.500 245,577.26 245,577.26 245,577.26 245,577.26 150 104,29 0.24 Fund 10: General Fund CD1014682593 10: General Fund CD1013981872 10: General Fund 2/13/2012 2/13/2013 0.250 248,000.00 248,000.00 248,000.00 247,962.55 44 30.58 0.25 12/20/2012 12/19/2013 0.500 500,000.00 500,000.00 500,000.00 500,000,00 353 75.34 0.50 6/21/2012 6/19/2014 0.600 500,000.00 500,000.00 500,000.00 500,000.00 535 0.00 0.50 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 Synovus Bank 10: General GA 0.5 87164D8V1 Fund 11/30/2012 5/30/2013 0.500 248,000.00 248,000.00 248,000.00 247,984.38 150 105.32 0.25 5/30/2013 First Commercial 31984GCN7 10: General 8/30/2012 8/30/2013 0.300 248,000.00 248,000.00 248,000.00 247,725.46 242 0.00 0.25 Bank 0.3 Fund 8/30/2013 FARMERS & MERCHANTS 2000307812HH3 Debt 2/17/2012 2/15/2013 0.250 248,000.00 248,000.00 248,000.00 247,962.80 46 540.16 0.25 0.25 Services 2/15/2013 CDARS 0.5 CD1013981856 30: Water & 8/1/2012 6/20/2013 0.500 500,000.00 500,000.00 500,000.00 500,000.00 171 1,321.92 0.50 6/20/2013 Sewer SAFRA NATIONAL C0785580350 30: Water & 8/1/2012 5/5/2014 0.600 248,000.00 248,000.00 248,000.00 248,735.07 490 236.45 0.25 BANK 0.6 Sewer 5/5/2014 Bay Cities Bank 30: Water & 0.5 CD07203QBR2 Sewer 12/12/2012 12/12/2014 0.500 248,000.00 248,000.00 248,000.00 247,910.72 711 64.55 0.25 12/12/2014 AMERICAN NATIONAL CD02771PKZ9 30: Water & 5/3/2012 5/3/2013 0.250 248,000.00 248,000.00 248,000.00 247,877.74 123 411.07 0.25 BANK 0.25 Sewer 5/3/2013 BEAL BANK 0.3 CD07370TKX0 30: Water & 2/15/2012 2/13/2013 0.300 248,000.00 248,000.00 248,000.00 247,972.47 44 652.27 0.25 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,959.82 46 543.56 0.25 2/15/2013 BMW Bank of 42: Utility NA 0.85 CD05568P2Q9 Impact Fee 12/7/2012 6/8/2015 0.850 248,000.00 248,000.00 248,000.00 247,346.27 889 138.61 0.25 6/8/2015 GOLDMAN 44: Shadow SACHS 0.25 CO38143A029 Creek 2/15/2012 2/15/2013 0.250 248,000.00 248,000.00 248,000.00 247,959.82 46 543.56 0.25 2/15/2013 Impact KEY BANK 0.25 45: 2/15/2013 C049306SPE0 HoteVMotel 2/15/2012 2/15/2013 0.250 248,000.00 248,000.00 248,000.00 247,959.82 46 543.56 0.25 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,963.54 46 27.18 0.25 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 148,000.00 247,965.78 122 495.32 0.25 5/2/2013 Bonds 4 of 6 Portfolio Settlement Maturity YTM @ Face Days To Accrued a/o of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio PRIVATE 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,963.54 46 27.18 0.25 2/15/2013 Obligation First State Bank 70: 2005 - WV 0.35 CD33648FHR9 Refunding / 12/3/2012 12/3/2014 0.350 248,000.00 248,000.00 248,000.00 247,958.34 702 66.59 0.25 12/3/2014 Mobility Z202: APPLE BANK 0.3 2/22/2013 CD037830FX9 2007A Gen 2/22/2012 2/22/2013 0.300 248,000.00 248,000.00 248,000.00 247,966.27 53 638.01 0.25 Obligation Sub Total / 0.404 5,961,577.26 5,961,577.26 5,961,577.26 5,960,751.65 255 6,565.52 5.94 Average FFCB Bond FFCB 0.32 3133EAU30 10: General 10/31/2012 3/12/2015 0.320 1,000,000.00 1,000,000.00 1,000,000.00 999,968.00 801 968.89 1.00 3/12/2015-12 Fund FFCB 0.3 3133EAYL6 10: General 8/1/2012 7/18/2014 0.285 1,000,000.00 1,000,293.48 1,000,231.21 1,000,702.00 564 1,358.33 1.00 7/18/2014 Fund FFCB 0.75 3133110Q410: General 5/2/2011 5/2/2013 0.750 1,000,000.00 1,000,000.00 1,000,000.00 1,002,065.00 122 1,229.17 1.00 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,844.00 395 1,041.67 1.00 1/30/2014-12 Sewer FFCB 0.3 3133EA3U0 42: Utility 11/29/2012 1/9/2015 0.300 1,000,000.00 1,000,000.00 1,000,000.00 1,000,045.00 739 683.33 1.00 1/9/2015-13 Impact Fee FFCB 0.34 3133EAM14 42: Utility 9/27/2012 4/23/2014 0.340 1,000,000.00 1,000,000.00 1,000,000.00 1,000,020.00 478 642.22 1.00 4/23/2014-12 Impact Fee 67: 2003 FFCB 0.48 12/26/2014-13 3133EAV14 Revenue 6/26/2012 12/26/2014 0.480 1,000,000.00 1,000,000.00 1,000,000.00 1,001,866.00 725 66.67 1.00 Bonds FFCB 2.125 67: 2003 2/10/2014 313313DY6 Revenue 11/29/2012 2/10/2014 0.230 1,500,000.00 1,533,962.55 1,531,440.97 1,531,104.00 406 12,484.38 1.49 Bonds Sub Total / 0.361 8,500,000.00 8,534,256.03 8,531,672.18 8,535,614.00 522 18,474.66 8.47 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,012,707.48 1,014,303.00 149 3,222.22 1.00 5/29/2013 Fund FHLB 1.15 3133743W8 30: Water& 11/29/2012 10/30/2014 0.300 1,000,000.00 1,016,250.00 1,015,497.47 1,015,675.00 668 1,916.67 1.00 10/30/2014 Sewer 5/29 3.625 3133XQU34 30: Water & 5/31/2011 5/29/2013 0.530 1,000,000.00 1,061,320.00 1,012,707.48 1,014,303.00 149 3,277.72 1.00 5/29/2013 Sewer 5 of 6 6 of 6 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 1.81 3133XWGP8 42: Utility 3/27/2012 3/26/2013 0.240 1,000,000.00 1,015,628.00 1,003,700.22 1,003,941.00 85 4,776.39 1.00 3/26/2013 Impact Fee FHLB 0.32 67: 2003 12/26/2014-13 313381G58 Revenue 12/26/2012 12/26/2014 0.320 1,000,000.00 1,000,000.00 1,000,000.00 1,000,380.00 725 44.44 1.00 Bonds Sub Total / 0.384 5,000,000.00 5,154,518.00 5,044,612.65 5,048,602.00 355 13,181.94 4.98 Average FHLMC Bond FHLMC 0 4/1/2013 FHLMC 0.375 4/28/2014 FHLMC 0.35 12/5/2014 313397DU2 3134G3SB7 3134G3H78 10: General Fund 10: General Fund 67: 2003 Revenue Bonds Sub Total / Average FNMA Bond FNMA 0.5 10/30/2014-13 FNMA 0.75 2/26/2013 FNMA 1.05 10/22/2013 FNMA 1.3 11/17/2014 3136GOFF3 3135GOAK9 31398A458 3136FPW26 10: General Fund 10: General Fund 30: Water & Sewer 30: Water& Sewer Sub Total / Average 4/26/2012 4/1/2013 0.173 1,000,000.00 998,394.44 999,570.28 999,827.00 91 0.00 1.00 3/27/2012 4/28/2014 0.467 1,000,000.00 998,100.00 998,793.21 1,001,977.00 483 656.25 1.00 9/27/2012 12/5/2014 0.330 1,000,000.00 1,000,436.00 1,000,383.99 1,000,934.00 704 252.78 1.00 0.323 3,000,000.00 2,996,930.44 2,998,747.48 3,002,738.00 426 909.03 2.99 5/1/2012 10/30/2014 0.500 1,000,000.00 1,000,000.00 1,000,000.00 1,001,073.00 668 833.33 1.00 2/8/2012 2/26/2013 0.178 1,000,000.00 1,006,000.00 1,000,873.02 1,000,944.00 57 2,604.17 1.00 3/27/2012 10/22/2013 0.361 1,000,000.00 1,010,780.00 1,005,552.18 1,006,433.00 295 2,012.50 1.00 6/20/2012 11/17/2014 0.462 1,000,000.00 1,020,050.00 1,015,632.99 1,018,913.00 686 1,588.89 1.00 0.375 4,000,000.00 4,036,830.00 4,022,058.19 4,027,363.00 426 7,038.89 3.99 Total / Average 0.201 100,371,744.19 100,594,278.66 100,468,834.69 100,485,235.58 107 46,170.04 100 City of Pearland City of Pearland - by Fund Report Format: By Transaction Group By: Portfolio Name Portfolio/Report Group: Report Group: Pearland As of 12/31/2012 Description CUSIP/Ticker Security Settlement Face Type Date Amount/Shares YTM @ Maturity Days To % of Book Value Market Value Cost Date Maturity Portfolio 10: General Fund Wells Fargo Sweep Cash Wells Fargo Cash Moody National Bank 0.5 5/30/2013 21ST CENTURY 0.25 2/13/2013 CDARS 0.5 12/19/2013 CDARS 0.6 6/19/2014 Synovus Bank GA 0.5 5/30/2013 First Commercial Bank 0.3 8/30/2013 FFCB 0.32 3/12/2015-12 FFCB 0.3 7/18/2014 FFCB 0.75 5/2/2013 FHLB 3.625 5/29/2013 FHLMC 0 4/1/2013 FHLMC 0.375 4/28/2014 FNMA 0.5 10/30/2014-13 FNMA 0.75 2/26/2013 WFSWEEP Cash WF1790 CD7130 CD90136SFD3 CD1014682593 CD1013981872 87164DBV1 31984GCN7 3133EAU30 FFCB Bond Cash Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit 3133EAYL6 31331KJQ4 3133XQU34 313397DU2 FFCB Bond FFCB Bond FHLB Bond FHLMC Bond 5/31/2006 12/15/2012 11/30/2012 2/13/2012 12/20/2012 6/21/2012 11/30/2012 8/30/2012 10/31/2012 8/1/2012 5/2/2011 5/31/2011 4/26/2012 3134G3S67 FHLMC Bond 3/27/2012 3136GOFF3 FNMA Bond 5/1/2012 3135GOAK9 FNMA Bond 2/8/2012 11,325,075.58 71,435.67 245,577.26 248,000.00 500,000.00 500,000.00 248,000.00 248,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 11,325,075.58 11,325,075.58 0.140 N/A 71,435.67 71,435.67 0.040 N/A 245,577.26 245,577.26 0.500 5/30/2013 248,000.00 500,000.00 500,000.00 248,000.00 248,000.00 1,000,000.00 1,000,231.21 1,000,000.00 1,012,707.48 999,570.28 247,962.55 0.250 2/13/2013 500,000.00 0.500 12/19/2013 500,000.00 0.600 6/19/2014 247,984.38 0.500 5/30/2013 247,725.46 0.300 8/30/2013 999,968.00 0.320 3/12/2015 1,000,702.00 1,002,065.00 1,014,303.00 999,827.00 0.285 0.750 0.530 0.173 7/18/2014 5/2/2013 5/29/2013 4/1/2013 998,793.21 1,001,977.00 0.467 4/28/2014 1,000,000.00 1,001,073.00 0.500 10/30/2014 1,000,873.02 1,000,944.00 0.178 2/26/2013 1 11.28 1 0.07 150 0.24 44 0.25 353 0.50 535 0.50 150 0.25 242 0.25 801 1.00 564 122 149 91 1.00 1.00 1.00 1.00 483 1.00 668 1.00 57 1.00 Sub Total / Average 21,386,088.51 1of9 21,398,263.71 21,406,619.90 0.268 165 21.31 Security Settlement Face YTM 0 Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio 17: Municipal Court Security Wells Fargo Sweep WFSWEEP Cash 5/31/2006 140,525.16 140,525.16 140,525.16 0.140 N/A 1 0.14 Cash Sub Total / Average 140,525.16 140,525.16 140,525.16 0.140 1 0.14 18: City Wide Donation Weill Fargo Sweep WFSWEEP Cash 5/31/2006 72,797.32 72,797.32 72,797.32 0.140 N/A 1 0.07 Cash Sub Total / Average 72,797.32 72,797.32 72,797.32 0.140 1 0.07 19: Court Tedmology Wells Fargo Sweep WFSWEEP Cash 5/31/2006 245,608.83 245,608.83 245,608.83 0.140 N/A 1 0.24 Cash Sub Total / Average 245,608.83 245,608.83 245,608.83 0.140 1 0.24 20: Debt Services Wells Fargo Sweep WFSWEEP Cash 5/31/2006 18,304,211.78 18,304,211.78 18,304,211.78 0.140 N/A 1 18.24 Cash FARMERS & Certificate Of MERCHANTS 0.25 CD307812HH3 Deposit 2/17/2012 248,000.00 248,000.00 247,962.80 0.250 2/15/2013 46 0.25 2/15/2013 Sub Total / Average 18,552,211.78 18,552,211.78 18,552,174.58 0.141 2 18.48 23: Court Juvenile Mgmt Wells Fargo Sweep WFSWEEP Cash 9/15/2009 36,477.07 36,477.07 36,477.07 0.140 N/A 1 0.04 Cash Sub Total / Average 36,477.07 36,477.07 36,477.07 0.140 1 0.04 30: Water & Sewer Wells Fargo Sweep WFSWEEP Cash 5/31/2006 10,037,523.93 10,037,523.93 10,037,523.93 0.140 N/A 1 10.00 Cash 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 171 0.50 Deposit SAFRA NATIONAL BANK CD786580350 Certificate Of 8/1/2.012 248,000.00 248,000.00 248,735.07 0.600 5/5/2014 490 0.25 0.6 5/5/2014 Deposit 2 of 9 Security Settlement Face YTM @Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturlty Portfolio Bay Cities Bank 0.5 CD072d3QBR2 Certificate Of 12/12/2012 248,000.00 248,000.00 247,910.72 0.500 12/12/2014 711 0.25 12/12/2014 Deposit AMERICAN NATIONAL CD02771PKZ9 Certificate Of 5/3/2012 248,000.00 248,000.00 247,877.74 0.250 5/3/2013 123 0.25 BANK 0.25 5/3/2013 Deposit REAL BANK 0.3 CD07370TKX0 Certificate Of 2/15/2012 248,000.00 248,000.00 247,972.47 0.300 2/13/2013 44 0.25 2/13/2013 Deposit FFCB 0.25 1/30/2014-12 3133EAA73 FFCB Bond 8/1/2012 1,000,000.00 1,000,000.00 999,844.00 0.250 1/30/2014 395 1.00 FHLB 1.15 10/30/2014 3133743W8 FHLB Bond 11/29/2012 1,000,000.00 1,015,497.47 1,015,675.00 0.300 10/30/2014 668 1.00 FHLB 3.625 5/29/2013 3133XQU34 FHLB Bond 5/31/2011 1,000,000.00 1,012,707.48 1,014,303.00 0.530 5/29/2013 149 1.00 FNMA 1.05 10/22/2013 31398A4S8 FNMA Bond 3/27/2012 1,000,000.00 1,005,552.18 1,006,433.00 0.361 10/22/2013 295 1.00 FNMA 1.3 11/17/2014 3136FPWZ6 FNMA Bond 6/20/2012 1,000,000.00 1,015,632.99 1,018,913.00 0.462 11/17/2014 686 1.00 Sub Total / Average 16,529,523.93 16,578,914.05 16,585,187.93 0.240 159 16.47 31: Soildwaste Wells Fargo Sweep WFSWEEP Cash 12/1/2006 443,519.53 443,519.53 443,519.53 0.140 N/A 1 0.44 Cash Sub Total / Average 443,519.53 443,519.53 443,519.53 0.140 1 0.44 35: Street Assessment Wells Fargo Sweep WFSWEEP Cash 5/31/2006 288,467.00 288,467.00 288,467.00 0.140 N/A 1 0.29 Cash DISCOVER BANK 0.25 CD2546703U4 Certificate Of 2/15/2012 248,000.00 248,000.00 247,959.82 0.250 2/15/2013 46 0.25 2/15/2013 Deposit Sub Total / Average 536,467.00 536,467.00 536,426.82 0.191 22 0.53 42: Utility Impact Fee Welts Fargo Sweep WFSWEEPCash 5/31/2006 4,301,597.91 4,301,597.91 4,301,597.91 0.140 N/A 1 4.29 Cash BMW Bank of NA 0.85 CD05568P2Q9 Certificate Of 12/7/2012 248,000.00 248,000.00 247,346.27 0.850 6/8/2015 889 0.25 6/8/2015 Deposit FFCB 0.3 1/9/2015-13 3133EA3U0 FFCB Bond 11/29/2012 1,000,000.00 1,000,000.00 1,000,045.00 0.300 1/9/2015 739 1.00 FFCB 0.34 3133EAM34 FFCB Bond 9/27/2012 1,000,000.00 1,000,000.00 1,000,020.00 0.340 4/23/2014 478 1.00 4/23/2014-12 3 of 9 Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio FHLB 1.81 3/26/2013 3133XWGP8 FHLB Bond 3/27/2012 1,000,000.00 1,003,700.22 1,003,941.00 0.240 3/26/2013 85 1.00 Sub Total / Average 7,549,597.91 7,553,298.13 7,552,950.18 0.224 202 7.52 43: Regional Detention Welk Fargo Sweep WFSWEEP Cash 5/31/2006 10,432.48 10,432.48 10,432.48 0.140 N/A 1 0.01 Cash Sub Total / Average 10,432.48 10,432.48 10,432.48 0.140 1 0.01 44: Shadow Creek Impad Wells Fargo Sweep WFSWEEP Cash 5/31/2006 1,498,151.56 1,498,151.56 1,498,151.56 0.140 N/A 1 1.49 Cash GOLDMAN SACHS 0.25 CD38143AJ29 Certificate Of 2/15/2012 248,000.00 248,000.00 247,959.82 0.250 2/15/2013 46 0.25 2/15/2013 Deposit Sub Total / Average 1,746,151.56 1,746,151.56 1,746,111.38 0.156 7 1.74 45: Hotel/Motel Occupancy Wells Fargo Sweep WFSWEEP Cash 5/31/2006 1,438,024.03 1,438,024.03 1,438,024.03 0.140 N/A 1 1.43 Cash KEY BANK 0.25 CD49306SPE0 Certificate Of 2/15/2012 248,000.00 248,000.00 247,959.82 0.250 2/15/2013 46 0.25 2/15/2013 Deposit Sub Total / Average 1,686,024.03 1,686,024.03 1,685,983.85 0.156 8 1.68 46: Park Donations Wells Fargo Sweep WFSWEEP Cash 5/31/2006 90,754.94 90,754.94 90,754.94 0.140 N/A 1 0.09 Cash Sub Total / Average 90,754.94 90,754.94 90,754.94 0.140 1 0.09 47: Park & Rec Development Wells Fargo SweepWFSWEEP Cash 5/31/2006 601,587.69 601,587.69 601,587.69 0.140 N/A 1 0.60 Cash PACIFIC CONTINENTAL CD69413CCQO Certificate Of 2/15/2012 248,000.00 248,000.00 247,963.54 0.250 2/15/2013 46 0.25 0.25 2/15/2013 Deposit Sub Total / Average 849,587.69 849,587.69 849,551.23 0.172 14 0.85 49: Tree Trust Fund 4 of 9 Security Settlement Face YTM 0 Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Wells Fargo Sweep WFSWEEP Cash 5/31/2006 18,488.15 18,488.15 18,488.15 0.140 N/A 1 0.02 Cash Sub Total / Average 18,488.15 50: Capital Projects Wells Fargo Sweep Cash WFSWEEP Cash 18,488.15 18,488.15 0.140 1 0.02 5/31/2006 2,099,412.90 2,099,412.90 2,099,412.90 0.140 N/A 1 2.09 Sub Total / Average 2,099,412.90 2,099,412.90 2,099,412.90 0.140 55: Sidewalk Fund Wells Fargo Sweep Cash 1 2.09 WFSWEEP Cash 5/31/2006 205,432.23 205,432.23 205,432.23 0.140 N/A 1 0.20 Sub Total / Average 205,432.23 60: Police State Seizure Wells Fargo Sweep Cash 205,432.23 205,432.23 0.140 1 0.20 WFSWEEP Cash 5/31/2006 237,829.62 237,829.62 237,829.62 0.140 N/A 1 0.24 Sub Total / Average 237,829.62 62: Federal Police Fund Wells Fargo Sweep Cash 237,829.62 237,829.62 0.140 1 0.24 WFSWEEP Cash 5/31/2006 32,172.20 32,172.20 32,172.20 0.140 N/A 1 0.03 Sub Total / Average 32,172.20 64: 1998 Cert of Obligation Wells Fargo Sweep Cash WFSWEEP Cash 32,172.20 32,172.20 0.140 1 0.03 5/31/2006 844,592.33 844,592.33 844,592.33 0.140 N/A 1 0.84 Sub Total / Average 844,592.33 67: 2003 Revenue Bonds Wells Fargo Sweep Cash MIZUHO CORP BANK 0.3 5/2/2013 FFCB 0.48 12/26/2014-13 5 of 9 844,592.33 844,592.33 0.140 1 0.84 WFSWEEP Cash 5/31/2006 8,411,525.71 8,411,525.71 8,411,525.71 0.140 N/A 1 8.38 CD60688TBR9 Certificate Of 5/2/2012 248,000.00 248,000.00 247,965.78 0.300 5/2/2013 122 0.25 Deposit 3133EAVJ4 FFCB Bond 6/26/2012 1,000,000.00 1,000,000.00 1,001,866.00 0.480 12/26/2014 725 1.00 Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio FFCB 2.125 2/10/2014 31331JDY6 FFCB Bond 11/29/2012 1,500,000.00 1,531,440.97 1,531,104.00 0.230 2/10/2014 406 1.49 FHLB 0.32 313381G58 FHLB Bond 12/26/2012 1,000,000.00 1,000,000.00 1,000,380.00 0.320 12/26/2014 725 1.00 12/26/2014-13 FHLMC 0.35 3134G3H78 FHLMC Bond 9/27/2012 1,000,000.00 1,000,383.99 1,000,934.00 0.330 12/5/2014 704 1.00 12/5/2014 Sub Total / Average 68: 2001 Cert of Obligation Wells Fargo Sweep Cash WFSWEEP Cash 13,159,525.71 13,191,350.67 13,193,775.49 0.207 213 13.11 5/31/2006 530,465.60 530,465.60 530,465.60 0.140 N/A 1 0.53 PRNATE BANK 0.25 CD74269TBK2 Certificate Of 2/15/2012 248,000.00 248,000.00 247,963.54 0.250 2/15/2013 46 0.25 2/15/2013 Deposit Sub Total / Average 778,465.60 70: 2005 Refunding / Mobility Wells Fargo Sweep Cash First State Bank - WV 0.35 12/3/2014 WFSWEEP Cash CD33648FHR9 Certificate Of Depost 778,465.60 778,429.14 0.175 15 0.78 5/31/2006 1,846,635.51 1,846,635.51 1,846,635.51 0.140 N/A 1 1.84 12/3/2012 248,000.00 248,000.00 247,958.34 0.350 12/3/2014 702 0.25 Sub Total / Average 2,094,635.51 95: Property Liability Wells Fargo Sweep Cash WFSWEEP Cash 2,094,635.51 2,094,593.85 0.165 84 2.09 10/31/2006 -184,859.46 -184,859.46 -184,859.46 0.140 N/A 1 -0.18 Sub Total / Average -184,859.46 -184,859.46 -184,859.46 0.140 1 -0.18 97: Employee Benefit Trust Wells Fargo Sweep WFSWEEP Cash 9/1/2007 25,219.44 25,219.44 25,219.44 0.140 N/A 1 0.03 Cash Sub Total / Average 25,219.44 25,219.44 25,219.44 0.140 1 0.03 99: COP Health Claims Fund Wells Fargo Sweep WFSWEEP Cash 9/15/2010 449,843.45 449,843.45 449,843.45 0.140 N/A 1 0.45 Cash Wells Fargo Cash WF9871 Cash 7/21/2010 215,436.87 215,436.87 215,436.87 0.140 N/A 1 0.21 6 of 9 Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Tidcer Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Sub Total / Average 665,280.32 Z101: Grant Fund 665,280.32 665,280.32 0.140 1 0.66 Wells Fargo Sweep WFSWEEP Cash 5/31/2006 -12,038.69 -12,038.69 -12,038.69 0.140 N/A 1 -0.01 Cash Sub Total / Average Z105: 2007 CDBG Fund Wells Fargo Sweep Cash WFSWEEP Cash 5/1/2007 -12,038.69 -12,038.69 187.63 187.63 -12,038.69 0.140 1 -0.01 187.63 0.140 N/A 1 0.00 Sub Total / Average 187.63 Z106: 2008 CDBG Fund Wells Fargo Sweep Cash WFSWEEP Cash 3/15/2009 187.63 187.63 0.140 1.14 1.14 1 0.00 1.14 0.140 N/A 1 0.00 Sub Total / Average 1.14 Z107: 2009 CDBG Fund Wells Fargo Sweep Cash WFSWEEP Cash 11/1/2009 1.14 1.14 0.140 15.61 15.61 1 0.00 15.61 0.140 N/A 1 0.00 Sub Total / Average 15.61 Z108: 2010 CDBG Fund Wells Fargo Sweep Cash WFSWEEP Cash 11/1/2010 15.61 15.61 0.140 0.05 0.05 1 0.00 0.05 0.140 N/A 1 0.00 Sub Total / Average 0.05 Z109: 2011 CDBG Fund Wells Fargo Sweep Cash 0.05 0.05 0.140 1 0.00 WFSWEEP Cash 12/1/2011 -184.24 -184.24 -184.24 0.140 N/A 1 0.00 Sub Total / Average -184.24 Z116: CDBG Recovery Fund Wells Fargo Sweep Cash 7 of 9 WFSWEEP Cash 7/31/2009 -184.24 -184.24 0.140 7.40 7.40 1 0.00 7.40 0.140 N/A 1 0.00 Security Settlement Face VTM 0 Maturity Days To % of Description CUSIP/Tkicer Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Sub Total / Average 7.40 Z140: U of H Fund 7.40 7.40 0.140 1 0.00 Wells Fargo Sweep WFSWEEP Cash 12/1/2009 16,285.94 16,285.94 16,285.94 0.140 N/A 1 0.02 Cash Sub Total / Average 16,285.94 16,285.94 16,285.94 0.140 1 0.02 Z145: Municipal Channel Wells Fargo Sweep WFSWEEP Cash 4/15/2012 76,871.16 76,871.16 76,871.16 0.140 N/A 1 0.08 Cash Sub Total / Average 76,871.16 76,871.16 76,871.16 0.140 1 0.08 Z200: 2006 Cert of Obligation Wells Fargo Sweep WFSWEEP Cash 6/30/2006 1,600,688.42 1,600,688.42 1,600,688.42 0.140 N/A 1 1.59 Cash Sub Total / Average 1,600,688.42 1,600,688.42 1,600,688.42 0.140 1 1.59 Z201: 2007 Cert of Obligation Weis Fargo Sweep WFSWEEP Cash 8/31/2006 1,580,652.48 1,580,652.48 1,580,652.48 0.140 N/A 1 1.57 Cash Sub Total / Average 1,580,652.48 1,580,652.48 1,580,652.48 0.140 1 1.57 Z202: 2007A Gen Obligation Wells Fargo Sweep WFSWEEP Cash 12/31/2007 3,071,873.13 3,071,873.13 3,071,873.13 0.140 N/A 1 3.06 Cash APPLE BANK 0.3 CD037830FX9 Certificate Of 2/22/2012 248,000.00 248,000.00 247,966.27 0.300 2/22/2013 53 0.25 2/22/2013 Deposit Sub Total / Average 3,319,873.13 3,319,873.13 3,319,839.40 0.152 5 3.31 Z203: 2009 Gen Obligation Wells Fargo Sweep WFSWEEP Cash 10/30/2008 2,041,849.46 2,041,849.46 2,041,849.46 0.140 N/A 1 2.03 Cash Sub Total / Average 2,041,849.46 2,041,849.46 2,041,849.46 0.140 1 2.03 Z301: W/S Pay As U Go CIP 8 of 9 Security Settlement Face YTM 0 Maturity Days To % of Description CUSIP/Tidcer Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Wells Fargo Sweep Cash Sub Total / Average Total / Average 9 of9 WFSWEEP Cash 12/31/2007 1,895,572.41 1,895,572.41 1,895,572.41 0.140 N/A 1 1.89 1,895,572.41 1,895,572.41 1,895,572.41 0.140 1 1.89 100,371,744.19 100,468,834.69 100,485,235.58 0.201 107 100 1 of1 City of Pearland Purchases Portfolio/Report Group: Report Group: Pearland From 9/30/2012 To 12/31/2012 Portfolio Settlement Maturity Name Description Bullet/Callable CUSIP/Ticker Action Date Date YTM Face Price Amount/Shares Cost Principal Interest/Dividends Broker/Dealer 10: General Fund 30: Water & Sewer 42: Utility Impact Fee 67: 2003 Revenue Bonds 10: General Fund 10: General Fund 70: 2005 Refunding / Mobility 42: Utility Impact Fee 30: Water & Sewer 10: General Fund 67: 2003 Revenue Bonds FFCB 0.32 Yes 3/12/2015-12 FHLB 1.15 10/30/2014 FFCB 0.3 Yes 1/9/2015-13 FFCB 2.125 2/10/2014 Moody National Bank 0.5 5/30/2013 Synovus Bank GA 0.5 5/30/2013 First State Bank - WV 0.35 12/3/2014 BMW Bank of NA 0.85 6/8/2015 Bay Cities Bank 0.5 12/12/2014 CDARS 0.5 12/19/2013 FHLB 0.32 12/26/2014-13 Yes 3133EAU30 Buy 10/31/2012 3/12/2015 3133743W8 Buy 11/29/2012 10/30/2014 101.625 3133EA3U0 Buy 11/29/2012 1/9/2015 100 1,000,000.00 0.320 1,000,000.00 1,000,000.00 0.300 1,016,250.00 100 1,000,000.00 0.300 1,000,000.00 1,500,000.00 0.230 1,533,962.55 100 245,577.26 0.500 245,577.26 100 248,000.00 0.500 248,000.00 100 248,000.00 0.350 248,000.00 100 248,000.00 0.850 248,000.00 100 248,000.00 0.500 248,000.00 100 500,000.00 0.500 500,000.00 100 1,000,000.00 0.320 1,000,000.00 31331JDY6 Buy 11/29/2012 2/10/2014 102.26417 CD7130 Buy 11/30/2012 5/30/2013 87164DBV1 Buy 11/30/2012 5/30/2013 CD33648FHR9 Buy 12/3/2012 12/3/2014 CD05568P2Q9 Buy 12/7/2012 6/8/2015 CD07203QBR2 Buy 12/12/2012 12/12/2014 CD1014682593 Buy 12/20/2012 12/19/2013 313381G58 Buy 12/26/2012 12/26/2014 435.56 Wells Fargo Bank 926.39 First Southwest 416.67 Wells ek Fargo 9,651.04 Vining Sparks 0.00 Barky National 0.00 Vining Sparks 0.00 Vining Sparks 0.00 Vining Sparks 0.00 Vining Sparks 0.00 Independence Bank 0.00 First Southwest 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 December 31, 2012 Account Number 201-0419505 201-0419513 001-3042841 179-0121790 807-1613395 818-4567843 001-3043112 280-7409871 865-9860145 Bank Account Number Wells Fargo 100-7284258 Account Name Operating Payroll Fund Sweep Account EMS Payments 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 Over (Under) Collateralized Total % Collateralized Amount 83,767,355.25 71,435.67 1,030,312.27 4,223,852.94 215,436.87 1.43 $ 89,308,394.43 98,782,875.92 250,000.00 $ 99,032,875.92 $ 9,724,481.49 110.9% Account Name Amount Development Authority 1,016,140.48 Total of Bank Balances $ 1,016,140.48 Pledged Collateral for DAP 7,317,675.38 FDIC Insurance 250,000.00 Total Collateral $ 7,567,675.38 Over (Under) Collateralized $ 6,551,534.90 Total % Collateralized 744.7% Total $ Over (Under) Collateralized $ 16,276,016.39 Total % Collateralized 118.0% Status Collateralized