Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R-2013-203 2013-12-09
RESOLUTION NO. R2013-203 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS, ACCEPTING THE CITY'S INVESTMENT REPORT FOR THE QUARTER ENDING SEPTEMBER 2013. 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 September 2013. PASSED, APPROVED, AND ADOPTED this 9th day of December, A.D., 2013. ATTEST: . «/ • dNG Ley` SESI" TARY G.Tj APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY TOM REID MAYOR RESOLUTION NO. 2013-203 Exhibit "A" Portfolio at Jun 30. 2013 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 City of Pearland Quarterly Investment Report Jun 30, 2013 - Sept 30, 2013 Period 13 $ 86,244,583.15 86,216,415.81 27,726.47 144,544.13 (28,167.34) (35,703.52) 118 Days (9,830,279.92) 0.20% 0.15% 0.12% Portfolio at Seat 30. 2013 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 Averaee for Quarter City's Yield to Maturity 1 Year T -Bill Benchmark Yield Agency Note Benchmark Yield 0.23% 0,12% 0.10% $ 81,026,763.75 81,023,808.27 34,705.29 188,482.36 (2,955.48) 25,211.86 179 Days (5,192,607.54) 0.27% 0.10% 0.09% 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: 0n : !�Y ct�IL Claire Bogard Director of Finance a Rick vekgaarcl Faima Uv' akwe Assistant Director of Finance Accounting Supervisor Summary by Type Sept 30, 2013 Description Face Amount \ Share5 Cost Value Book Value Market Value YTM @ Cost Days To Maturity Cash $ 55,815,919.50 $ 55,815,919.50 $ 55,815,919.50 $ 55,815,919.50 0.14% 1 CD 10,175,186.79 10,175,186.79 10,175,186.79 10,144,535.47 0.53% 577 FFCB 5,500,000.00 5,533,816.03 5,510,078.69 5,512,433.00 0.28% 352 FHLB 2,000,000.00 2,016,250.00 2,009,171.49 2,010,508.00 0.31% 424 FHLMC 5,000,000.00 4,997,036.00 4,998,212.25 5,018,755.00 1.12% 996 FNMA 2,509,000.00 2,539,132.67 2,518,195.03 2,521,657.30 0.41% 314 Total/Average $ 81,000,106.29 $ 81,077,340.99 $ 81,026,763.75 $ 81,023,808.27 0.27% 179 Group Portfolio Holdings by Type FNMA 3gp FHLMC FHLB 6% FFCB 2% % CD 13% Cash 69% 60,000,000 50,000,000 40,000,000 '+ 30,000,000 20,000,000 10,000,000 Book Value by Maturity 1 - 10 Days 31- 60 Days61- 90 Days91 120 Days_ 12 Days >180 Days Interest Rates Date Imo 3 mo 6 mo 1 yr Lyr 3_yt Sir LyE My! am 30 yr 6/30/2013 0.02 0.04 0.10 0.15 0.36 0.66 1.41 1.96 2.52 3.22 3.52 9/30/2013 0.03 0.02 0.04 0.10 0.33 0.63 1.39 2.02 2.64 3.41 3.69 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 0.30% Yield Curve Comparison City's Weighted Avg Yield .27% 179 Day Average Maturity Imo 3 mo 6 mo 1 yr 2 yr 3 yr Syr 7 yr -4-6/30/2013 -111-.9/30/2013 Portfolio vs. Benchmarks SO yr 20 yr 30 yr 0.05% t t 0.00% I- r Oct -12 Nov -12 Dec -12 Jan -13 Feb -13 Mar -13 Apr -13 May -13 Jun -13 Jul -13 Aug -13 Sep -13 -11.-Port Total -4F- 1 Yr T -Bill -it Agency Note City of Pearland Quarterly Investment Report Report Format: By CUSIP Group By: Security Type Portfolio/Report Group: Report Group: Pearland Begin Date: 6/30/2013, End Date: 9/30/2013 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV CASH Wells Fargo WFSWEEP 10: General 0.140 N/A 13,367,100.96 403,334.12 4,719,886.39 0.00 0.00 9,050,548.69 3,630.74 Sweep Cash Fund Wells Fargo 17: Municipal Sweep Cash WFSWEEP Court 0.140 N/A 131,928.47 172.66 661.03 0.00 0.00 131,440.10 50.00 Security Wells Fargo 18: City Sweep Cash WFSWEEP Wide 0.140 N/A 88,842.88 533.02 569.22 0.00 0.00 88,806.68 33.82 Donation Wells Fargo WFSWEEP 19: Court 0.140 N/A 275,648.23 8,309.77 522.89 0.00 0.00 283,435.11 106.90 Sweep Cash Technology Wells Fargo WFSWEEP 20: Debt 0.140 N/A 10,279,533.14 651,498.03 7,857,561.44 0.00 0.00 3,073,469.73 1,693.82 Sweep Cash Services Wells Fargo 23: Court Sweep Cash WFSWEEP Juvenile 0.140 N/A 55,893.11 5,952.65 0.00 0.00 0.00 61,845.76 22.75 Mgmt Wells Fargo 30: Water& WFSWEEP 0.140 N/A 12,761,692.98 2,031,411.94 6,032,002.72 0.00 0.00 8,761,102.20 3,879.23 Sweep Cash Sewer Wells Fargo WFSWEEP 31: 0.140 N/A 389,399.28 787,105.89 78,072.97 0.00 0.00 1,098,432.20 176.52 Sweep Cash Solidwaste Wells Fargo WFSWEEP 35: Street 0.140 N/A 763,033.51 274.35 126,213.50 0.00 0.00 637,094.36 274.35 Sweep Cash Assessment Wells Fargo WFSWEEP 42: Utility 0.140 N/A 5,891,388.42 11,754.63 2,526,758.49 0.00 0.00 3,376,384.56 1,875.85 Sweep Cash Impact Fee Wells Fargo 43: Regional WFSWEEP 0.140 N/A 10,440.04 2.68 10,443.00 0.00 0.00 -0.28 2.68 Sweep Cash Detention Wells Fargo 44: Shadow Sweep Cash WFSWEEP Creek 0.140 N/A 1,456,632.85 445,575.21 135,000.36 0.00 0.00 1,767,207.70 693.29 Impact Wells Fargo 45: Sweep Cash WFSWEEP Hotel/Motel 0.140 N/A 1,519,045.13 207,428.55 92,311.51 0.00 0.00 1,634,162.17 636.73 Occupancy Wells Fargo WFSWEEP 46: Park 0.140 N/A 115,212.69 5,134.25 4,206.32 0.00 0.00 116,140.62 44.98 Sweep Cash Donations 1 of 8 Description Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Ending Portfolio YTM @ Maturity Amortized Amortized Investment CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV 47: Park & WFSWEEP Rec 0.140 N/A 734,976.69 121,566.24 48,834.60 0.00 0.00 807,708.33 317.67 Development WFSWEEP 49: Tree 0.140 N/A 75,767.19 28.54 1,950.00 0.00 0.00 73,845.73 28.54 Trust Fund WFSWEEP 50: Capital 0.140 N/A -173,827.19 2,704,160.70 318,160.31 0.00 0.00 2,212,173.20 590.32 Projects WFSWEEP 55: Sidewalk 0.140 N/A 225,714.36 85.74 0.00 0.00 0.00 225,800.10 85.74 Fund 60: Police WFSWEEP State 0.140 N/A 201,278.44 7,780.21 12,849.50 0.00 0.00 196,209.15 76.21 Seizure WFSWEEP 62: Federal 0.140 N/A 47,868.11 18.17 0.00 0.00 0.00 47,886.28 18.17 Police Fund 64: 1998 WFSWEEP Cert of 0.140 N/A 845,205.90 321.07 0.00 0.00 0.00 845,526.97 321.07 Obligation 67: 2003 WFSWEFP Revenue 0.140 N/A 6,199,381.92 1,814.51 2,231,300.19 0.00 0.00 3,969,896.24 1,819.27 Bonds 68: 2001 WFSWEEP Cert of 0.140 N/A 401,859.89 107.87 269,517.12 0.00 0.00 132,450.64 107.87 Obligation 70: 2005 WFSWEEP Refunding/ 0.140 N/A 862,380.12 266.67 206,084.76 0.00 0.00 656,562.03 266.66 Mobility WFSWEEP 95: Property 0.140 N/A -252,237.07 374,078.51 3,769.75 0.00 0.00 118,071.69 14.46 Liability 97: WFSWEEP Employee 0.140 N/A 16,912.82 15,542.43 14,942.14 0.00 0.00 17,513.11 9.83 Benefit Trust 99: COP WF9871 Health 0.140 N/A 325,953.37 1,217,498.51 1,288,038.44 0.00 0.00 255,413.44 113.81 Claims Fund 99: COP WFSWEEP Health 0.140 N/A 500,102.73 319,510.66 231,109.61 0.00 0.00 588,503.78 0.00 Claims Fund WFSWEEP 2101: Grant 0.140 N/A -19,304.66 25,798.01 9,377.70 0.00 0.00 -2,884.35 0.79 Fund WFSWEEP Z105: 2007 N/A 187.75 0.00 187.75 0.00 0.00 0.00 0.00 CDBG Fund 2 of 8 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV Wells Fargo WFSWEEP Z106: 2008 N/A 1.14 0.00 1.14 0.00 0.00 0.00 0.00 Sweep Cash CDBG Fund Wells Fargo Z107: 2009 WFSWEEP N/A 15.61 0.00 15.61 0.00 0.00 0.00 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z108: 2010 N/A 0.05 0.00 0.05 0.00 0.00 0.00 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z109: 2011 0.140 N/A -9,325.54 73,577.50 0.00 0.00 0.00 64,251.96 22.83 Sweep Cash CDBG Fund Wells Fargo WFSWEEP 2110: 2012 0.140 N/A 6,895.40 21,295.46 26,643.46 0.00 0.00 1,547.40 0.00 Sweep Cash CDBG Fund Z116: CDBG Wells Fargo Sweep CashWFSWEEP Recovery 0.140 N/A 7.40 0.00 0.00 0.00 0.00 7.40 0.00 Fund Wells Fargo Z140: U of H WFSWEEP 0.140 N/A -20,899.47 58,505.21 11,098.34 0.00 0.00 26,507.40 3.25 Sweep Cash Fund Z141: U of H Wells Fargo WFSWEEP Capital 0.140 N/A 0.00 239,779.45 0.00 0.00 0.00 239,779.45 29.45 Sweep Cash Renewal Fund Wells Fargo Z145: Sweep Cash WFSWEEP Municipal 0.140 N/A 141,838.36 85,784.52 65.42 0.00 0.00 227,557.46 76.13 Channel Z200: 2006 Wells Fargo Sweep Cash WFSWEEP Cert of 0.140 N/A 1,516,292.61 499,707.69 4,496.32 0.00 0.00 2,011,503.98 694.70 Obligation Wells Fargo Z201: 2007 Sweep Cash WFSWEEP Cert of 0.140 N/A 365,546.43 28,830.99 276,520.95 0.00 0.00 117,856.47 44.95 Obligation Z202: Wells Fargo Sweep CashWFSWEEP 2007A Gen 0.140 N/A 2,503,580.15 895.84 351,246.29 0.00 0.00 2,153,229.70 893.12 Obligation Wells Fargo 7203: 2009 Sweep Cash WFSWEEP Gen 0.140 N/A 340,704.90 8,482,043.20 1,502,315.06 0.00 0.00 7,320,433.04 1,926.52 Obligation Z301: W/S Wells Fargo Sweep CashWFSWEEP Pay As U Go 0.140 N/A 1,972,440.47 246,383.51 58,923.17 0.00 0.00 2,159,900.81 758.70 CIP Wells Fargo Z302: MUD Sweep Cash WFSWEEP 4 Capital 0.140 N/A 1,356,687.11 499.65 88,588.27 0.00 0.00 1,268,598.49 499.65 Programs Sub 0.140 65,271,796.68 19,084,368.61 28,540,245.79 0.00 0.00 55,815,919.50 21,841.37 Total/Average 3of$ Ending Portfolio YTM Cil Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV Cash CERTIFICATE OF DEPOSIT First Commercial 31984GCN7 10: General 8/30/2013 248,000.00 0.00 248,000.00 0.00 0.00 0.00 124.34 Bank 0.3 Fund 8/30/2013 Synovus Bank 10: General GA 0.5 87164DBV1 Fund 0.500 11/28/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 312.54 11/28/2014 Townebank 10: General Portsmouth VA 89214PAP4 Fund 0.400 6/1/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 250.04 0.4 6/1/2015 BBCN Bank LA C0073296AT2 10: General 0.250 2/7/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 0.25 2/7/2014 Fund CDARS 0.6 CD1013981872 10: General 0.600 6/19/2014 500,000.00 0.00 0.00 0.00 0.00 500,000.00 756.16 6/19/2014 Fund CDARS 0.5 C01014682593 10: General 0.500 12/19/2013 500,000.00 0.00 0.00 0.00 0.00 500,000.00 630.14 12/19/2013 Fund Cardinal Bank CD14147VDM5 10: General 0.500 5/17/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 312.54 0.5 5/17/2016 Fund Moody National 10: General Bank 0.5 CD1730 Fund 0.500 11/30/2013 246,186.79 0.00 0.00 0.00 0.00 246,186.79 310.26 11/30/2013 Discover Bank CD254671KH2 10: General 0.500 2/20/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 312.55 0.5 2/20/2015 Fund First National 10: General Bank 1.6 CD32115CBE7 Fund 1.600 3/19/2018 0.00 248,000.00 0.00 0.00 0.00 248,000.00 130.45 3/19/2018 First Niagara 10: Genera) Bank 0.25 CD33583CDH9 Fund 0.250 11/4/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.27 11/4/2013 Gorham 10: General Savings Bank CD383052CN5 Fund 0.250 2/6/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 0.25 2/6/2014 Mizuho Bank CD60688TLM9 10: General 0.250 5/8/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.27 0.25 5/8/2014 Fund Plus International CD72940UFV2 10: General 0.500 7/8/2016 0.00 248,000.00 0.00 0.00 0.00 248,000.00 285.36 Bank 0.5 Fund 7/8/2016 4 of 8 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV Southwest 10: General Bank Ft Worth CD844772AA1 5 Fund 0.300 2/27/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 7873 0.3 2/27/2015 Valley Bank 10: General Roanoke 0.3 CD91935VANO Fund 0.300 7/30/2014 248,000.00 0.00 0.00 0.00 0.00 248,000,00 187.53 7/30/2014 Key Bank Ohio 20: Debt 0.35 CD49306SRE8 Services 0.350 8/27/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 218.78 8/27/2014 Mechanics Savings Bank C0583686BC3 20: Debt 0.350 3/20/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 218.78 0.35 Services 3/20/2015 Bay Cities Bank 30: Water & 0.5 CD07203QBR2 Sewer 0.500 12/12/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 312.54 12/12/2014 CDARS 0.5 CD1013981856B 30: Water & 0.500 6/19/2014 500,000.00 0.00 0.00 0.00 0.00 500,000.00 630.14 6/19/2014 Sewer First Farmers 30: Water & Bank 0.5 CD320165FZ1 Sewer 0.500 5/3/2016 245,000.00 0.00 0.00 0.00 0.00 245,000.00 308.76 5/3/2016 Fox Chase Bank 30: Water & 0.65 CD35137QAN4 0.650 6/27/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 406.31 6/27/2016 Sewer Goldman Sachs 30: Water & Bank 0.6 CD38147JAA0 Sewer 0.600 2/20/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 375.06 2/20/2015 SAFRA NATIONAL CD786580350 30: Water & 0.600 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 BMW Bank of 42: Utility NA 0.85 CD05568P2Q9 Impact Fee 0.850 6/8/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 531.33 6/8/2015 College Savings 42: Utility Bank 0.55 CD19443PAP4 Impact Fee 0.550 6/20/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 343.80 6/20/2016 Private Bank & 42: Utility Trust 0.35 CD74267GTC1 Impact Fee 0.350 5/11/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 218.79 5/11/2015 Sterling Savings 42: Utility Bank 0.35 CD8595316A8 Impact Fee 0.350 2/23/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 218.79 2/23/2015 5 of 8 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV The Independent CD88632YAG1 42: Utility 1.100 9/16/2016 0.00 248,000.00 0.00 0.00 0.00 248,000.00 89.69 Bank 1.1 Impact Fee 9/16/2016 Marlin Business 44: Shadow Bank 0.55 CD57116AGF9 Creek 0.550 6/14/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 343.81 6/14/2016 Impact Sovereign Bank 44: Shadow 0.2 7/30/2013 CD84603M3N4 Creek 7/30/2013 248,000.00 0.00 248,000.00 0.00 0.00 0.00 40.77 Impact Colonial Virginia 45: Bank 0.55 CD196121AM9 Hotel/Motel 0.550 6/24/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 347.55 6/24/2016 Occupancy First Natial Bank 45: WI 0.25 CD321086FE5 Hotel/Motel 0.250 1/31/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 1/31/2014 Occupancy Asheville 67: 2003 Savings Bank CD04407RAJO Revenue 0.350 3/27/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 218.78 0.35 Bonds 3/27/2015 CIT Bank 1.5 67: 2003 9/5/2017 C017284CMN1 Revenue 1.500 9/5/2017 0.00 248,000.00 0.00 0.00 0.00 248,000.00 264.99 Bonds Medallion Bank 67: 2003 UT 0.4 CD58403BB62 Revenue 0.400 11/3/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 250.04 11/3/2015 Bonds First State Bank 70: 2005 - WV 0.35 CD33648FHR9 Refunding / 0.350 12/3/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 218.78 12/3/2014 Mobility Celtic Bank 0.6 Z202: 6/28/2016 CD15118RJDO 2007A Gen 0.600 6/28/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 375.06 Obligation Cathay Bank Z203: 2009 0.75 CD149159JE6 Gen 0.750 3/21/2016 0.00 248,000.00 0.00 0.00 0.00 248,000.00 50.96 3/21/2016 Obligation DeWitt Bank 2301: W/S and Trust 0.5 CD241888BT2 Pay As U Go 0.500 6/20/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 326.13 6/20/2016 CIP Sub Total/Average 0.533 9,431,186.79 1,240,000.00 496,000.00 0.00 0.00 10,175,186.79 11,265.52 Certificate Of Deposit FFCB BOND 6 of 8 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV FFCB 0.32 3133EAU30 10: General 0.320 3/12/2015 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 800.00 3/12/2015-12 Fund FFCB 0.3 3133EAYL6 10: General 0.285 7/18/2014 1,000,156.91 0.00 0.00 0.00 -37.36 1,000,119.55 712.64 7/18/2014 Fund FFCB 0.25 3133ECAV6 20: Debt 0.273 12/24/2014 999,657.49 0.00 0.00 57.73 0.00 999,715.22 682.73 12/24/2014 Services FFCB 0.3 3133EA3U0 42: Utility 0.300 1/9/2015 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 750.00 1/9/2015-13 Impact Fee FFCB 2.125 67: 2003 2/10/2014 313313DY6 Revenue 0.230 2/10/2014 1,517,335.87 0.00 0.00 0.00 -7,091.95 1,510,243.92 876.80 Bonds Sub Total/Average 0.277 5,517,150.27 0.00 0.00 57.73 -7,129.31 5,510,078.69 3,822.17 FFCB Bond FHLB BOND FHLB 1.15 3133743W8 30: Water& 0.300 10/30/2014 1,011,287.99 0.00 0.00 0.00 -2,116.50 1,009,171.49 758.50 10/30/2014 Sewer FHLB 0.32 67: 2003 12/26/2014-13 313381G58 Revenue 0.320 12/26/2014 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 800.00 Bonds Sub Total/Average 0.310 2,011,287.99 0.00 0.00 0.00 -2,116.50 2,009,171.49 1,558.50 FHLB Bond FHLMC BOND FHLMC 0.375 3134G3SB7 10: General 0.467 4/28/2014 999,246.07 0.00 0.00 227.70 0.00 999,473.77 1,165.20 4/28/2014 Fund FHLMC 2 3134G4FY9 10: General 2.000 9/24/2018 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 333.33 9/24/2018-14 Fund FHLMC 0.5 3134G4FP8 30: Water & 0.500 8/28/2015 0.00 1,000,000,00 0.00 0.00 0.00 1,000,000.00 444.44 8/28/2015-14 Sewer FHLMC 2.25 3134G4GE2 42: Utility 2.282 9/26/2018 0.00 998,500.00 0.00 3.33 0.00 998,503.33 253.33 9/26/2018-14 Impact Fee 67: 2003 FHLMC 0.35 12/5/2014 3134G3H78 Revenue 0.330 12/5/2014 1,000,284.95 0.00 0.00 0.00 -49.80 1,000,235.15 825.20 Bonds Sub Total/Average 1.116 1,999,531.02 2,998,500.00 0.00 231.03 -49.80 4,998,212.25 3,021.50 FHLMC Bond 7 of 8 Ending Portfolio YTM © Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV FNMA BOND FNMA 0.35 8/25/2015 FNMA 1.3 11/17/2014 FNMA 1.05 10/22/2013 Sub Total/Average FNMA Bond Total / Average 313S000W1 3136FPWZ6 31398A458 10: General Fund 30: Water & Sewer 30: Water & Sewer 0.416 8/25/2015 0.00 508,302.67 0.00 60.44 0.00 508,363.11 382.10 0.462 11/17/2014 1,011,493.48 0.00 0.00 0.00 -2,081.31 1,009,412.17 1,168.69 0.361 10/22/2013 1,002,136.92 0.00 0.00 0.00 -1,717.17 1,000,419.75 907.83 0.412 2,013,630.40 508,302.67 0.00 60.44 -3,798.48 2,518,195.03 2,458.62 0.272 86,244,583.15 23,831,171.28 29,036,245.79 349.20 -13,094.09 81,026,763.75 43,967.68 8 of 8 City of Pearland Quarterly Investment Report at Quarterend Report Format: By Transaction Group By: Securlty Type Portfolio/Report Group: Report Group: Pearland As of9/30/2013 Portfolio Settlement Maturity YTM as Face Days To Accrued 0/0 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 9,050,548.69 9,050,548.69 9,050,548.69 9,050,548.69 1 11.17 Sweep Cash Fund Wells Fargo 17: Municipal Sweep Cash WFSWEEP Court 5/31/2006 N/A 0.140 131,440.10 131,440.10 131,440.10 131,440.10 1 0.16 Security Wells Fargo 18: City Sweep Cash WFSWEEP Wide 5/31/2006 N/A 0.140 88,806.68 88,806.68 88,806.68 88,806.68 1 0.11 Donation Wells Fargo WFSWEEP 19: Court 5/31/2006 N/A 0.140 283,435.11 283,435.11 283,435.11 283,435.11 1 0.35 Sweep Cash Technology Wells Fargo WFSWEEP 20: Debt 5/31/2006 N/A 0.140 3,073,469.73 3,073,469.73 3,073,469.73 3,073,469.73 1 3.79 Sweep Cash Services Wells Fargo 23: Court Sweep CashWFSWEEP Juvenile 9/15/2009 N/A 0.140 61,845.76 61,845.76 61,845.76 61,845.76 1 0.08 Mgmt Wells Fargo WFSWEEP 30: Water & 5/31/2006 N/A 0.140 8,761,102.20 8,761,102.20 8,761,102.20 8,761,102.20 1 10.82 Sweep Cash Sewer Wells Fargo WFSWEEP 31: 12/1/2006 N/A 0.140 1,098,432.20 1,098,432.20 1,098,432.20 1,098,432.20 1 1.36 Sweep Cash Solidwaste Weis Fargo WFSWEEP 35: Street 5/31/2006 N/A 0.140 637,094.36 637,094.36 637,094.36 637,094.36 1 0.79 Sweep Cash Assessment Wells Fargo WFSWEEP 42: Utility 5/31/2006 N/A 0.140 3,376,384.56 3,376,384.56 3,376,384.56 3,376,384.56 1 4.17 Sweep Cash Impact Fee Wells Fargo WFSWEEP 43: Regional 5/31/2006 N/A 0.140 -0.28 -0.28 -0.28 -0.28 1 0.00 Sweep Cash Detention Wells Fargo 44: Shadow WFSWEEP Creek 5/31/2006 N/A 0.140 1,767,207.70 1,767,207.70 1,767,207.70 1,767,207.70 1 2.18 Sweep Cg Impact 45: Wells Fargo Sweep Cash WFSWEEP Hotel/Motel 5/31/2006 N/A 0.140 1,634,162.17 1,634,162.17 1,634,162.17 1,634,162.17 1 2.02 Occupancy Wells Fargo WFSWEEP 46: Park 5/31/2006 N/A 0.140 116,140.62 116,140.62 116,140.62 116,140.62 1 0.14 Sweep Cash Donations 47: Park & Wells Fargo Sweep CashWFSWEEP Rec 5/31/2006 N/A 0.140 807,708.33 807,708.33 807,708.33 807,708.33 1 1.00 Development 1 of 7 Portfolio Settlement Maturity YTM @ Face Days To Accrued 010 of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Wells Fargo WFSWEEP 49: Tree 5/31/2006 N/A 0.140 73,845.73 73,845.73 73,845.73 73,845.73 0.09 Sweep Cash Trust Fund Wells Fargo WFSWEEP 50. Capital 5/31/2006 N/A 0.140 2,212,173.20 2,212,173.20 2,212,173.20 2,212,173.20 1 2.73 Sweep Cash Projects Wells Fargo WFSWEEP 55: Sidewalk 5/31/2006 N/A 0.140 225,800.10 225,800.10 225,800.10 225,800.10 1 0.28 Sweep Cash Fund 60: Police WenFargo s Sweep Cash WFSWEEP State 5/31/2006 N/A 0.140 196,209.15 196,209.15 196,209.15 196,209.15 1 0.24 Sehure Wells Fargo WFSWEEP 62: Federal 5/31/2006 N/A 0.140 47,886.28 47,886.28 47,886.28 47,886.28 1 0.06 Sweep Cash Police Fund Wells Fargo 64: 1998 Sweep CashWFSWEEP Cert of 5/31/2006 N/A 0.140 845,526.97 845,526.97 845,526.97 845,526.97 1 1.04 Obligation 67: 2003 Wells Fargo Sweep CWFSWEEP Revenue 5/31/2006 N/A 0.140 3,969,896.24 3,969,896.24 3,969,896.24 3,969,896.24 1 4.90 Bonds 68: 2001 Wells Fargo Sweep Cash WFSWEEP Cert of 5/31/2006 N/A 0.140 132,450.64 132,450.64 132,450.64 132,450.64 1 0.16 Obligation 70: 2005 Welk o Farg Sweep CashWFSWEEP Refunding / 5/31/2006 N/A 0.140 656,562.03 656,562.03 656,562.03 656,562.03 1 0.81 Mobility Wells Fargo WFSWEEP 95: Property 10/31/2006 N/A 0.140 118,071.69 118,071.69 118,071.69 118,071.69 1 0.15 Sweep Cash Liability 97: Welk Fargo Sweep Cash WFSWEEP Employee 9/1/2007 N/A 0.140 17,513.11 17,513.11 17,513.11 17,513.11 1 0.02 Benefit Trust Welk Fargo 99: COP Sweep CashWFSWEEP Health 9/15/2010 N/A 0.140 588,503.78 588,503.78 588,503.78 588,503.78 1 0.73 Claims Fund Welk Fargo 99: COP Cash WF9871 Health 7/21/2010 N/A 0.140 255,413.44 255,413.44 255,413.44 255,413.44 1 0.32 Claims Fund Welk Fargo WFSWEEP Z101: Grant 5/31/2006 N/A 0.140 -2,884.35 -2,884.35 -2,884.35 -2,884.35 1 0.00 Sweep Cash Fund Welk Fargo WFSWEEP Z109: 2011 12/1/2011 N/A 0.140 64,251.96 64,251.96 64,251.96 64,251.96 1 0.08 Sweep Cash CDBG Fund Welk Fargo WFSWEEP Z110: 2012 11/15/2012 N/A 0.140 1,547.40 1,547.40 1,547.40 1,547.40 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 2of7 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 Wells Fargo WFSWEEP Z140: U of H 12/1/2009 N/A 0.140 26,507.40 26,507.40 26,507.40 26,507.40 0.03 Sweep Cash Fund Z141: U of H Wells Fargo WFSWEEP Capital 9/30/2013 N/A 0.140 239,779.45 239,779.45 239,779.45 239,779.45 1 0.30 Sweep Cash Renewal Fund Wells Fargo Z145: Sweep Cash WFSWEEP Municipal 4/15/2012 N/A 0.140 227,557.46 227,557.46 227,557.46 227,557.46 1 O.iB Channel Z200: 2006 Wells Fargo Sweep Cash WFSWEEP Cert of 6/30/2006 N/A 0.140 2,011,503.98 2,011,503.98 2,011,503.98 2,011,503.98 1 2_.-13 Obligation Wells Fargo Z201: 2007 Sweep CashWFSWEEP Cert of 8/31/2006 N/A 0.140 117,856.47 117,856.47 117,856.47 117,856.47 1 0.15 Obligation Z202: Wells Fargo Sweep CashWFSWEEP 2007A Gen 12/31/2007 N/A 0.140 2,153,229.70 2,153,229.70 2,153,229.70 2,153,229.70 1 2.66 Obligation Z203: 2009 Wells Fargo Sweep CashWFSWEEP Gen 10/30/2008 N/A 0.140 7,320,433.04 7,320,433.04 7,320,433.04 7,320,433.04 1 9.04 Obligation Wells Fargo Z301: W/S Sweep Cash WFSWEEP Pay As U Go 12/31/2007 N/A 0.140 2,159,900.81 2,159,900.81 2,159,900.81 2,159,900.81 1 2.67 C1P Wells Fargo Z302: MUD Sweep Cash WFSWEEP 4 Capital 2/1/2013 N/A 0.140 1,268,598.49 1,268,598.49 1,268,598.49 1,268,598.49 1 1.57 Programs Sub Total / 0.140 55,815,919.50 55,815,919.50 55,815,919.50 55,815,919.50 1 0.00 68.91 Average Certificate Of Deposit Valley Bank 10: General Roanoke 0.3 CD91935VANO Fund 1/30/2013 7/30/2014 0.300 248,000.00 248,000.00 248,000.00 247,818.71 303 126.38 0.31 7/30/2014 First National 10: General Bank 1.6 CD32115CBE7 Fund 9/18/2013 3/19/2018 1.600 248,000.00 248,000.00 248,000.00 246,339.39 1631 130.45 0.31 3/19/2018 BBCN Bank LA CD073296AT2 10: General 2/8/2013 2/7/2014 0.250 248,000.00 248,000.00 248,000.00 247,841.03 130 37.37 0.31 0.25 2/7/2014 Fund CDARS 0.5 CD1014682593 10: General 12/20/2012 12/19/2013 0.500 500,000.00 500,000.00 500,000.00 500,000.00 80 1,945.21 0.62 12/19/2013 Fund First Niagara 10: General Bank 0.25 CD33583CDH9 Fund 5/3/2013 11/4/2013 0.250 248,000.00 248,000.00 248,000.00 247,945.44 35 254.79 0.31 11/4/2013 3 of 7 Portfolio Settlement Maturity YTM (cl) Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Southwest 10: General Bank Ft Worth CD844772AA1 Fund 2/27/2013 2/27/2015 0.300 218,000 00 248,000.00 248,000.00 247,577.90 515 6.12 0.31 0.3 2/27/2015 Plus Intematfonal CD72940UFV2 10: General 7/8/2013 7/8/2016 0.500 248,000.00 248,000.00 248,000.00 245,352.35 1012 74.74 0.31 Bank 0.5 Fund 7/8/2016 CDARS 0.6 CD1013981872 10: General 6/21/2012 6/19/2014 0.600 500,000.00 500,000.00 500,000.00 500,000.00 262 756.16 0.62 6/19/2014 Fund Cardinal Bank C014147VDM5 10: General 5/17/2013 5/17/2016 0.500 248,000.00 248,000.00 248,000.00 245,823.80 960 44.16 0.31 0.5 5/17/2016 Fund Gorham 10: General Savings Bank CD383052CN5 Fund 2/6/2013 2/6/2014 0.250 248,000.00 248,000.00 248,000.00 247,784.49 129 40.77 0.31 0.25 2/6/2014 Moody National 10: General Bank 0.5 CD1730 Fund 5/30/2013 11/30/2013 0.500 246,186.79 246,186.79 246,186.79 246,186.79 61 414.81 0.30 11/30/2013 Discover Bank CD254671KH2 10: General 2/20/2013 2/20/2015 0.500 248,000.00 248,000.00 248,000.00 247,596.75 508 139.29 0.31 0.5 2/20/2015 Fund Synovus Bank 10: General GA 0.5 87164DBV1 Fund 11/30/2012 11/28/2014 0.500 248,000.00 248,000.00 248,000.00 248,651.00 424 417.86 0.31 11/28/2014 Townebank 10: General Portsmouth VA 89214PAP4 Fund 5/31/2013 6/1/2015 0.400 248,000.00 248,000.00 248,000.00 246,989.40 609 331.57 0.31 0.4 6/1/2015 Mizuho Bank CD60688TLM9 10: General 5/8/2013 5/8/2014 0.250 248,000.00 2.48,000.00 248,000.00 247,954.12 220 246.30 0.31 0.25 5/8/2014 Fund Key Bank Ohio 20: Debt 0.35 CD493065RE8 Services 2/27/2013 8/27/2014 0.350 248,000.00 248,000.00 248,000.00 247,877.24 331 80.85 0.31 8/27/2014 Mechanics Savings Bank CD583686BC3 20: Debt 3/20/2013 3/20/2015 0.350 248,000.00 248,000.00 248,000.00 247,373.06 536 23.78 0.31 0.35 Services 3/20/2015 Goldman Sachs 30: Water & Bank 0.6 CD38147JAA0 Sewer 2/20/2013 2/20/2015 0.600 248,000.00 248,000.00 248,000.00 247,392.90 508 167.15 0.31 2/20/2015 SAFRA NATIONAL C0786580350 30: Water & 8/1/2012 5/5/2014 0.600 248,000.00 248,000.00 248,000.00 248,595.94 217 611.51 0.31 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 248,649.26 438 61.15 0.31 12/12/2014 4 of 7 Portfolio Settlement Maturity YTM C Face Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Days To Accrued % of Book Value Market Value Maturity Interest Portfolio CDARS 0.5 CD1013981856B 30: Water & 6/20/2013 6/19/2014 0.500 500,000.00 500,000.00 500,000.00 500,000.00 262 693.63 0.62 6/19/2014 Sewer Fox Chase Bank 30: Water & 0.65 CD35137QAN4 Sewer 6/27/2013 6/27/2016 0.650 248,000.00 248,000.00 248,000.00 245,447.58 1001 13.25 0.31 6/27/2016 First Farmers 30: Water & Bank 0.5 CD320165FZ1 Sewer 5/3/2013 5/3/2016 0.500 245,000.00 245,000.00 245,000.00 243,014.03 946 90.62 0.30 5/3/2016 Private Bank & 42: Utility Trust 0.35 CD74267GTC1 Impact Fee 5/10/2013 5/11/2015 0.350 248,000.00 248,000.00 248,000.00 247,112.90 588 340.07 0.31 5/11/2015 Sterling Savings 42: Utility Bank 0.35 CD8595316A8 Impact Fee 2/22/2013 2/23/2015 0.350 248,000.00 248,000.00 248,000.00 247,588.32 511 92.75 0.31 2/23/2015 College Savings 42: Utility Bank 0.55 CD19443PAP4 Impact Fee 6/19/2013 6/20/2016 0.550 248,000.00 248,000.00 248,000.00 245,503.63 994 384.91 0.31 6/20/2016 The Independent CD88632YAG1 42: Utility 9/18/2013 9/16/2016 1.100 248,000.00 248,000.00 248,000.00 247,001.06 1082 89.69 0.31 Bank 1.1 Impact Fee 9/16/2016 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 248,600.90 616 664.16 0.31 6/8/2015 Marlin Business 44: Shadow Bank 0.55 CD57116AGF9 Creek 6/14/2013 6/14/2016 0.550 248,000.00 248,000.00 248,000.00 245,547.03 988 59.79 0.31 6/14/2016 Impact First Naha! Bank 45: WI 0.25 CD321086FE5 Hotel/Motel 1/31/2013 1/31/2014 0.250 248,000.00 248,000.00 248,000.00 247,795.90 123 49.26 0.31 1/31/2014 Occupancy Cobnial Virginia 45: Bank 0.55 CD196121AM9 Hotel/Motel 6/25/2013 6/24/2016 0.550 248,000.00 248,000.00 248,000.00 245,466.43 998 22.42 0.31 6/24/2016 Occupancy Asheville 67: 2003 Savings Bank CD04407RAJO Revenue 2/28/2013 3/27/2015 0.350 248,000.00 248,000.00 248,000.00 247,335.61 543 4.76 0.31 0.35 Bonds 3/27/2015 Medallion Bank 67: 2003 UT 0.4 CD58403BB62 Revenue 5/3/2013 11/3/2015 0.400 248,000.00 248,000.00 248,000.00 246,837.13 764 407.67 0.31 11/3/2015 Bonds 67: 2003 CIT Bank 1.5 9/5/2017 C017284CMN1 Revenue 9/4/2013 9/5/2017 1.500 248,000.00 248,000.00 248,000.00 246,895.16 1436 264.99 0.31 Bonds 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 248,651.74 429 64.21 0.31 12/3/2014 Mobility 5 of 7 Portfolio Settlement Maturity YTM a Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Z202: Celtic Bank 0.6 6/28/2016 CD15118RJDO 2007A Gen 6/28/2013 6/28/2016 0.600 248,000.00 248,000.00 248,000.00 245,505.86 1002 8.15 0.31 Obligation Cathay Bank Z203: 2009 0.75 CD149159JE6 Gen 9/20/2013 3/21/2016 0.750 248,000.00 248,000.00 248,000.00 246,918,72 903 50.96 0.31 3/21/2016 Obligation DeWitt Bank Z301: W/S and Trust 0.5 CD2418888T2 Pay As U Go 6/24/2013 6/20/2016 0.500 248,000.00 248,000.00 248,000.00 245,563.90 994 33.97 0.31 6/20/2016 CIP Sub Total / 0.533 10,175,186.79 10,175,186.79 10,175,186.79 10,144,535.47 577 9,250.68 12.56 Average FFCB Bond FFCB 0.32 3/12/2015-12 FFCB 0.3 7/18/2014 FFCB 0.25 12/24/2014 FFCB 0.3 1/9/2015-13 FFCB 2.125 2/10/2014 Sub Total / Average FHLB Bond FHLB 1.15 10/30/2014 3133EAU30 3133EAYL6 3133ECAV6 3133EA3U0 31331JDY6 3133743W8 FHLB 0.32 313381G58 12/26/2014-13 Sub Total / Average FHLMC Bond FHLMC 2 9/24/2018-14 FHLMC 0.375 4/28/2014 FHLMC 0.5 8/28/2015-14 3134G4FY9 3134G3SB7 3134G4FP8 10: General Fund 10: General Fund 20: Debt Services 42: Utility Impact Fee 67: 2003 Revenue Bonds 10/31/2012 3/12/2015 0.320 1,000,000.00 1,000,000.00 1,000,000.00 1,000,028.00 528 160.00 1.23 8/1/2012 7/18/2014 0.285 1,000,000.00 1,000,293.48 1,000,119.55 1,001,309.00 291 600.00 1.23 1/28/2013 12/24/2014 0.273 1,000,000.00 999,560.00 999,715.22 1,000,355.00 450 666.67 1.23 11/29/2012 1/9/2015 0.300 1,000,000.00 1,000,000.00 1,000,000.00 1,000,025.00 466 675.00 1.23 11/29/2012 2/10/2014 0.230 1,500,000.00 1,533,962.55 1,510,243.92 1,510,716.00 133 4,427.08 1.85 0.277 5,500,000.00 5,533,816.03 5,510,078.69 5,512,433.00 352 6,528.75 6.79 30: Water & 11/29/2012 10/30/2014 0.300 1,000,000.00 1,016,250.00 1,009,171.49 1,010,345.00 395 4,791.67 1.23 Sewer 67: 2003 Revenue 12/26/2012 12/26/2014 0.320 1,000,000.00 1,000,000.00 1,000,000.00 1,000,163.00 452 835.56 1.23 Bonds 10: General Fund 10: General Fund 30: Water & Sewer 0.310 2,000,000.00 2,016,250.00 2,009,171.49 2,010,508.00 424 5,627.23 2.47 9/24/2013 9/24/2018 2.000 1,000,000.00 1,000,000.00 1,000,000.00 1,008,584.00 1820 333.33 1.23 3/27/2012 4/28/2014 0.467 1,000,000.00 998,100.00 999,473.77 1,001,534.00 210 1,583.33 1.23 8/28/2013 8/28/2015 0.500 1,000,000.00 1,000,000.00 1,000,000.00 1,000,192.00 697 444.44 1.23 6 of7 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 FHLMC 2.25 3134G4GE2 42: Utility 9/26/2013 9/26/2018 2.282 1,000,000.00 998,500.00 998,503.33 1,006,879.00 1822 250.00 1.23 9/26/2018-14 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,235.15 1,001,566.00 431 1,118.06 1.23 Bonds Sub Total / 1.116 5,000,000.00 4,997,036.00 4,998,212.25 5,018,755.00 996 3,729.16 6.17 Average FNMA Bond FNMA 0.35 3135G0UW 1 10: General 7/25/2013 8/25/2015 0.416 509,000.00 508,302.67 508,363.11 508,649.30 694 158.36 0.63 8/25/2015 Fund FNMA 1.05 31398A4S8 30: Water & 3/27/2012 10/22/2013 0.361 1,000,000.00 1,010,780.00 1,000,419.75 1,000,525.00 22 4,608.33 1.23 10/22/2013 Sewer FNMA 1.3 3136FPWZ6 Water& 136FPWZ6 6/20/2012 11/17/2014 0.462 1,000,000.00 1,020,050.00 1,009,412.17 1,012,483.00 413 4,802.78 1.23 11/17/2014 Sewer Sub Total / 0.412 2,509,000.00 2,539,132.67 2,518,195.03 2,521,657.30 314 9,569.47 3.10 Average Total / 0.272 81,000,106.29 81,077,340.99 81,026,763.75 81,023,808.27 179 34,705.29 100 Average 7o17 City of Pearland City of Pearland - by Fund Report Format: By Transaction Group By: Portfolio Name Portfolio/Report Group: Report Group: Pearland As of 9/30/2013 Description 10: General Fund Wells Fargo Sweep Cash Valley Bank Roanoke 0.3 7/30/2014 First National Bank 1.6 3/19/2018 BBCN Bank LA 0.25 2/7/2014 CDARS 0.5 12/19/2013 First Niagara Bank 0.25 11/4/2013 Southwest Bank Ft Worth 0.3 2/27/2015 Plus International Bank 0.5 7/8/2016 CDARS 0.6 6/19/2014 Cardinal Bank 0.5 5/17/2016 Gorham Savings Bank 0.25 2/6/2014 Moody National Bank 0.5 11/30/2013 Discover Bank 0.5 2/20/2015 Synovus Bank GA 0.5 11/28/2014 CUSIP/Ticker WFSWEEP CD91935VANO CD32115CBE7 CD073296AT2 C01014682593 CD33583CDH9 CD844772AA1 CD72940UFV2 CD1013981872 CD14147VDM5 CD383052CN5 CD1730 CD254671KH2 87164DBV1 Security Settlement Face Type Date Amount/Shares Cash Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit YTM Maturity Days To % of Book Value Market Value Cost Date Maturity Portfolio 5/31/2006 9,050,548.69 9,050,548.69 9,050,548.69 0.140 1/30/2013 248,000.00 248,000.00 247,818.71 0.300 7/30/2014 9/18/2013 248,000.00 248,000.00 2/8/2013 248,000.00 248,000.00 247,841.03 0.250 2/7/2014 12/20/2012 500,000.00 500,000.00 500,000.00 0.500 12/19/2013 5/3/2013 248,000.00 248,000.00 2/27/2013 248,000.00 248,000.00 7/8/2013 248,000.00 248,000.00 6/21/2012 500,000.00 500,000.00 500,000.00 0.600 6/19/2014 5/17/2013 248,000.00 248,000.00 245,823.80 0.500 5/17/2016 2/6/2013 248,000.00 248,000.00 247,784.49 0.250 2/6/2014 5/30/2013 246,186.79 246,186.79 246,186.79 0.500 11/30/2013 2/20/2013 248,000.00 248,000.00 247,596.75 0.500 2/20/2015 N/A 303 0.31 246,339.39 1.600 3/19/2018 1631 0.31 130 0.31 80 0.62 247,945.44 0.250 11/4/2013 35 0.31 247,577.90 0.300 2/27/2015 515 0.31 245,352.35 0.500 7/8/2016 1012 0.31 11/30/2012 248,000.00 248,000.00 1of10 262 0.62 960 0.31 129 0.31 61 0.30 508 0.31 248,651.00 0.500 11/28/2014 424 0.31 Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Townebank Certificate Portsmouth VA 0.4 89214PAP4 Of Deposit 5/31/2013 248,000.00 248,000.00 246,989.40 0.400 6/1/2015 609 0.31 6/1/2015 Mizuho Bank 0.25 CD60688TLM9 Certificate 5/8/2013 248,000.00 248,000.00 247,954.12 0.250 5/8/2014 220 0.31 5/8/2014 Of Deposit FFCB 0.32 3133EAU30 FFCB Bond 10/31/2012 1,000,000.00 1,000,000.00 1,000,028.00 0.320 3/12/2015 528 1.23 3/12/2015-12 FFCB 0.3 7/18/2014 3133EAYL6 FFCB Bond 8/1/2012 1,000,000.00 1,000,119.55 1,001,309.00 0.285 7/18/2014 291 1.23 FHLMC 2 3134G4FY9 FHLMC 9/24/2013 1,000,000.00 1,000,000.00 1,008,584.00 2.000 9/24/2018 1820 1.23 9/24/2018-14 Bond FHLMC 0.375 3134G35B7 FHLMC 3/27/2012 1,000,000.00 999,473.77 1,001,534.00 0.467 4/28/2014 210 1.23 4/28/2014 Bond FNMA 0.35 3135G0UW1 FNMA Bond 7/25/2013 509,000.00 508,363.11 508,649.30 0.416 8/25/2015 694 0.63 8/25/2015 Sub Total / 17,781,735.48 17,780,691.91 17,784,514.16 0.372 281 21.95 Average 17: Municipal Court Security Wells Fargo Sweep WFSWFEP Cash 5/31/2006 131,440.10 131,440.10 131,440.10 0.140 N/A 1 0.16 Cash Sub Total / 131,440.10 131,440.10 131,440.10 0.140 1 0.16 Average 18: City Wide Donation Wells Fargo Sweep WFSWEEP Cash 5/31/2006 88,806.68 88,806.68 88,806.68 0.140 N/A 1 0.11 Cash Sub Total / 88,806.68 88,806.68 88,806.68 0.140 1 0.11 Average 19: Court Technology Wells Fargo Sweep WFSWEEP Cash 5/31/2006 283,435.11 283,435.11 283,435.11 0.140 N/A 1 0.35 Cash Sub Total / 283,435.11 283,435.11 283,435.11 0.140 1 0.35 Average 20: Debt Services 2 of 10 Security Settlement Face YTM @ 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 3,073,469.73 3,073,469.73 3,073,469.73 0.140 N/A 1 3.79 Cash Key Bank Ohio 0.35 CD49306SRE8 Certificate 2/27/2013 248,000.00 248,000.00 247,877.24 0.350 8/27/2014 331 0.31 8/27/2014 Of Deposit Mechanics Savings Certificate Bank 0.35 CD583686BC3 Of Deposit 3/20/2013 248,000.00 248,000.00 247,373.06 0.350 3/20/2015 536 0.31 3/20/2015 FFCB 0.25 3133ECAV6 FFCB Bond 1/28/2013 1,000,000.00 999,715.22 1,000,355.00 0.273 12/24/2014 450 1.23 12/24/2014 Sub Total / 4,569,469.73 4,569,184.95 4,569,075.03 0.192 146 5.64 Average 23: Court Juvenile Mgmt Wells Fargo Sweep WFSWEEP Cash 9/15/2009 61,845.76 61,845.76 61,845.76 0.140 N/A 1 0.08 Cash Sub Total / 61,845.76 61,845.76 61,845.76 0.140 1 0.08 Average 30: Water & Sewer Wells Fargo Sweep WFSWEEP Cash 5/31/2006 8,761,102.20 8,761,102.20 8,761,102.20 0.140 N/A 1 10.82 Cash Goldman Sachs Bank CD38147JAA0 Certificate 2/20/2013 248,000.00 248,000.00 247,392.90 0.600 2/20/2015 508 0.31 0.6 2/20/2015 Of Deposit SAFRA NATIONAL CD786580J50 Certificate 8/1/2012 248,000.00 248,000.00 248,595.94 0.600 5/5/2014 217 0.31 BANK 0.6 5/5/2014 Of Deposit Bay Cities Bank 0.5 CD07203QBR2 Certificate 12/12/2012 248,000.00 248,000.00 248,649.26 0.500 12/12/2014 438 0.31 12/12/2014 Of Deposit CDARS 0.5 CD1013981856B Certificate 6/20/2013 500,000.00 500,000.00 500,000.00 0.500 6/19/2014 262 0.62 6/19/2014 Of Deposit Fox Chase Bank 0.65 CD35137QAN4 Certificate 6/27/2013 248,000.00 248,000.00 245,447.58 0.650 6/27/2016 1001 0.31 6/27/2016 Of Deposit First Farmers Bank CD320165FZ1 Certificate 5/3/2013 245,000.00 245,000.00 243,014.03 0.500 5/3/2016 946 0.30 0.5 5/3/2016 Of Deposit FHLB 1.15 3133743W8 FHLB Bond 11/29/2012 1,000,000.00 1,009,171.49 1,010,345.00 0.300 10/30/2014 395 1.23 10/30/2014 FHLMC 0.5 3134G4FP8 FHLMC 8/28/2013 1,000,000.00 1,000,000.00 1,000,192.00 0.500 8/28/2015 697 1.23 8/28/2015-14 Bond 3 of 10 Description CUSIP/Ticker 31398A4S8 3136FPWZ6 FNMA 1.05 10/22/2013 FNMA 1.3 11/17/2014 Sub Total / Average 31: Solidwaste Wells Fargo Sweep Cash Sub Total / Average WFSWEEP 35: Street Assessment Wells Fargo Sweep Cash Sub Total / Average WFSWEEP 42: Utility Impact Fee Wells Fargo Sweep Cash Private Bank & Trust 0.35 5/11/2015 Sterling Savings Bank 0.35 2/23/2015 College Savings Bank 0.55 6/20/2016 The Independent Bank 1.1 9/16/2016 BMW Bank of NA 0.85 6/8/2015 FFCB 0.3 1/9/2015-13 FHLMC 2.25 9/26/2018-14 WFSWEEP CD74267GTC1 CD8595316A8 CD19443PAP4 CD88632YAG1 CD05568P2Q9 3133EA3U0 3134G4GE2 Security Settlement Face Type Date Amount/Shares Book Value YTM @ Maturity Days To % of Market Value Cost Date Maturity Portfolio FNMA Bond 3/27/2012 1,000,000.00 1,000,419.75 1,000,525.00 0.361 10/22/2013 FNMA Bond 6/20/2012 1,000,000.00 1,009,412.17 1,012,483.00 0.462 11/17/2014 14,498,102.20 14,517,105.61 14,517,746.91 0.262 Cash 12/1/2006 1,098,432.20 1,098,432.20 1,098,432.20 0.140 N/A 1,098,432.20 1,098,432.20 1,098,432.20 0.140 Cash 5/31/2006 637,094.36 637,094.36 637,094.36 0.140 N/A 637,094.36 637,094.36 637,094.36 0.140 Cash 5/31/2006 5/10/2013 2/22/2013 6/19/2013 9/18/2013 12/7/2012 FFCB Bond 11/29/2012 9/26/2013 Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit FHLMC Bond 3,376,384.56 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 1,000,000.00 1,000,000.00 4of10 3,376,384.56 3,376,384.56 0.140 N/A 248,000.00 247,112.90 0.350 5/11/2015 248,000.00 247,588.32 0.350 2/23/2015 248,000.00 245,503.63 0.550 6/20/2016 248,000.00 247,001.06 1.100 9/16/2016 248,000.00 248,600.90 0.850 6/8/2015 1,000,000.00 1,000,025.00 0.300 1/9/2015 998,503.33 1,006,879.00 2.282 9/26/2018 22 1.23 413 1.23 168 17.90 1 1.36 1 1.36 1 0.79 1 0.79 1 4.17 588 0.31 511 0.31 994 0.31 1082 0.31 616 0.31 466 1.23 1822 1.23 Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Sub Total / 6,616,38436 6,614,887.89 6,619,095.37 0.582 488 8.17 Average 43: Regional Detention Wells Fargo Sweep WFSWEEP Cash 5/31/2006 -0.28 -0.28 -0.28 0.140 N/A 1 0.00 Cash Sub Total / -0.28 -0.28 -0.28 0.140 1 0.00 Average 44: Shadow Creek Impact Wells Fargo Sweep WFSWEEP Cash 5/31/2006 1,767,207.70 1,767,207.70 1,767,207.7'0 0.140 N/A 1 2.18 Cash Marlin Business Bank CD57116AGF9 Certificate 6/14/2013 248,000.00 248,000.00 245,547.03 0.550 6/14/2016 988 0.31 0.55 6/14/2016 Of Deposit Sub Total / 2,015,207.70 2,015,207.70 2,012,754.73 0.190 122 2.49 Average 45: Hotel/Motel Occupancy Wells Fargo Sweep WFSWEEP Cash 5/31/2006 1,634,162.17 1,634,162.17 1,634,162.17 0.140 N/A 1 2.02 Cash First Natial Bank WI CD321086FE5 Certificate 1/31/2013 248,000.00 248,000.00 247,795.90 0.250 1/31/2014 123 0.31 0.25 1/31/2014 Of Deposit Colonial Virginia Bank CD196121AM9 Certificate 6/25/2013 248,000.00 248,000.00 245,466.43 0.550 6/24/2016 998 0.31 0.55 6/24/2016 Of Deposit Sub Total / 2,130,162.17 2,130,162.17 2,127,424.50 0.201 131 2.63 Average 46: Park Donations Wells Fargo Sweep WFSWEEP Cash 5/31/2006 116,140.62 116,140.62 116,140.62 0.140 N/A 1 0.14 Cash Sub Total / 116,140.62 116,140.62 116,140.62 0.140 1 0.14 Average 47: Park & Rec Development Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 807,708.33 807,708.33 807,708.33 0.140 N/A 1 1.00 5ofl0 Security Settlement Face YTM @ Maturity Days To 0/0 of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Sub Total / 807,708.33 807,708.33 807,708.33 0.140 1 1.00 Average 49: Tree Trust Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 73,845.73 73,845.73 73,845.73 0.140 N/A 1 0.09 Cash Sub Total / 73,845.73 73,845.73 73,845.73 0.140 1 0.09 Average 50: Capital Projects Wells Fargo Sweep WFSWEEP Cash 5/31/2006 2,212,173.20 2,212,173.2.0 2,212,173.20 0.140 N/A 1 2.73 Cash Sub Total / 2,212,173.20 2,212,173.20 2,212,173.20 0.140 1 2.73 Average 55: Sidewalk Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 225,800.10 225,800.10 225,800.10 0.140 N/A 1 0.28 Cash Sub Total / 225,800.10 225,800.10 225,800.10 0.140 1 0.28 Average 60: Police State Seizure Wells Fargo Sweep WFSWEEP Cash 5/31/2006 196,209.15 196,209.15 196,209.15 0.140 N/A 1 0.24 Cash Sub Total / 196,209.15 196,209.15 196,209.15 0.140 1 0.24 Average 62: Federal Police Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 47,886.28 47,886.28 47,886.28 0.140 N/A 1 0.06 Cash Sub Total / 47,886.28 47,886.28 47,886.28 0.140 1 0.06 Average 64: 1998 Cert of Obligation Wells Fargo Sweep WFSWEEP Cash 5/31/2006 845,526.97 845,526.97 845,526.97 0.140 N/A 1 1.04 Cash Sub Total / 845,526.97 845,526.97 845,526.97 0.140 1 1.04 6 of 10 Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Average 67: 2003 Revenue Bonds Wells Fargo Sweep WFSWEEP Cash 5/31/2006 3,969,896.24 3,969,896.24 3,969,896.24 0.140 N/A 1 4.90 Cash Asheville Savings Certificate Bank 0.35 CD04407RA10 Of Deposit 2/28/2013 248,000.00 248,000.00 247,335.61 0.350 3/27/2015 543 0.31 3/27/2015 Medallion Bank UT CD584038862 Certificate 5/3/2013 248,000.00 248,000.00 246,837.13 0.400 11/3/2015 764 0.31 0.4 11/3/2015 Of Deposit CIT Bank 1.5 CD17284CMN1 Certificate 9/4/2013 248,000.00 248,000.00 246,895.16 1.500 9/5/2017 1436 0.31 9/5/2017 Of Deposit FFCB 2.125 31331JDY6 FFCB Bond 11/29/2012 1,500,000.00 1,510,243.92 1,510,716.00 0.230 2/10/2014 133 1.85 2/10/2014 FHLB 0.32 313381G58 FHLB Bond 12/26/2012 1,000,000.00 1,000,000.00 1,000,163.00 0.320 12/26/2014 452 1.23 12/26/2014-13 FHLMC 0.35 3134G3H78 FHLMC 9/27/2012 1,000,000.00 1,000,235.15 1,001,566.00 0.330 12/5/2014 431 1.23 12/5/2014 Bond Sub Total / 8,213,896.24 8,224,375.31 8,223,409.14 0.257 215 10.14 Average 68: 2001 Cert of Obligation Wells Fargo Sweep WFSWEEP Cash 5/31/2006 132,450.64 132,450.64 132,450.64 0.140 N/A 1 0.16 Cash Sub Total / 132,450.64 132,450.64 132,450.64 0.140 1 0.16 Average 70: 2005 Refunding / Mobility Wells Fargo Sweep WFSWEEP Cash 5/31/2006 656,562.03 656,562.03 656,562.03 0.140 N/A 1 0.81 Cash First State Bank WV CD33648FHR9 Certificate 12/3/2012 248,000.00 248,000.00 248,651.74 0.350 12/3/2014 429 0.31 0.35 12/3/2014 Of Deposit Sub Total / 904,562.03 904,562.03 905,213.77 0.198 118 1.12 Average 95: Property Liability 7of10 Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Wells Fargo Sweep WFSWFEP Cash 10/31/2006 118,071.69 118,071.69 118,071.69 0.140 N/A 1 0.15 Cash Sub Total / 118,071.69 118,071.69 118,071.69 0.140 1 0.15 Average 97: Employee Benefit Trust Wells Fargo Sweep WFSWEEP Cash 9/1/2007 17,513.11 17,513.11 17,513.11 0.140 N/A 1 0.02 Cash Sub Total / 17,513.11 17,513.11 17,513.11 0.140 1 0.02 Average 99: COP Health Claims Fund Wells Fargo Sweep WFSWEEP Cash 9/15/2010 588,503.78 588,503.78 588,503.78 0.140 N/A 1 0.73 Cash Wells Fargo Cash WF9871 Cash 7/21/2010 255,413.44 255,413.44 255,413.44 0.140 N/A 1 0.37 Sub Total / 843,917.22 843,917.22 843,917.22 0.140 1 1.04 Average Z101: Grant Fund Wells Fargo Sweep WFSWEEP Cash 5/31/2006 -2,884.35 -2,884.35 -2,884.35 0.140 N/A 1 0.00 Cash Sub Total / -2,884.35 -2,884.35 -2,884.35 0.140 1 0.00 Average Z109: 2011 CDBG Fund Wells Fargo Sweep WFSWEEP Cash 12/1/2011 64,251.96 64,251.96 64,251.96 0.140 N/A 1 0.08 Cash Sub Total / 64,251.96 64,251.96 64,251.96 0.140 1 0.08 Average Z110: 2012 CDBG Fund Wells Fargo Sweep WFSWEEP Cash 11/15/2012 1,547.40 1,547.40 1,547.40 0.140 N/A 1 0.00 Cash Sub Total / 1,547.40 1,547.40 1,547.40 0.140 1 0.00 Average 2116: CDBG Recovery Fund 8of10 Security Settlement Face YTM @ Maturity Days To "/o of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Wells Fargo Sweep WFSWEEP Cash 7/31/2009 7.40 7.40 7.40 0.140 N/A 1 0.00 Cash Sub Total / 7.40 7.40 7.40 0.140 1 0.00 Average Z140: U of H Fund Wells Fargo Sweep WFSWEEP Cash 12/1/2009 26,507.40 26,507.40 26,507.40 0.140 N/A 1 0.03 Cash Sub Total / 26,507.40 26,507.40 26,507.40 0.140 1 0.03 Average Z141: U of H Capital Renewal Fund Wells Fargo Sweep WFSWEEP Cash 9/30/2013 239,779.45 239,779.45 239,779.45 0.140 N/A 1 0.30 Cash Sub Total / 239,779.45 239,779.45 239,779.45 0.140 1 0.30 Average Z145: Municipal Channel Wells Fargo Sweep WFSWEEP Cash 4/15/2012 227,557.46 227,557.46 227,557.46 0.140 N/A 1 0.28 Cash Sub Total / 227,557.46 227,557.46 227,557.46 0.140 1 0.28 Average Z200: 2006 Cert of Obligation Wells Fargo Sweep WFSWEEP Cash 6/30/2006 2,011,503.98 2,011,503.98 2,011,503.98 0.140 N/A 1 2.48 Cash Sub Total / 2,011,503.98 2,011,503.98 2,011,503.98 0.140 1 2.48 Average Z201: 2007 Cert of Obligation Wells Fargo Sweep WFSWEEP Cash 8/31/2006 117,856.47 117,856.47 117,856.47 0.140 N/A 1 0.15 Cash Sub Total / 117,856.47 117,856.47 117,856.47 0.140 1 0.15 Average Z202: 2007A Gen Obligation Wells Fargo Sweep WFSWEEP Cash 12/31/2007 2,153,229.70 2,153,229.70 2,153,229.70 0.140 N/A 1 2.66 Cash 9 of 10 Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Celtic Bank 0.6 CD15118R3D0 Certificate 6/28/2013 248,000.00 248,000.00 245,505.86 0.600 6/28/2016 1002 0.31 6/28/2016 Of Deposit Sub Total / 2,401,229.70 2,401,229.70 2,398,735.56 0.188 104 2.96 Average Z203: 2009 Gen Obligation Wells Fargo Sweep WFSWEEP Cash 10/30/2008 7,320,433.04 7,320,433.04 7,320,433.04 0.140 N/A 1 9.04 Cash Cathay Bank 0.75 CD1491593E6 Certificate 9/20/2013 248,000.00 248,000.00 246,918.72 0.750 3/21/2016 903 0.31 3/21/2016 Of Deposit Sub Total / 7,568,433.04 7,568,433.04 7,567,351.76 0.160 31 9.34 Average Z301: W/S Pay As U Go CIP Wells Fargo Sweep WFSWEEP Cash 12/31/2007 2,159,900.81 2,159,900.81 2,159,900.81 0.140 N/A 1 2.67 Cash DeWitt Bank and CD241888BT2 Certificate 6/24/2013 248,000.00 248,000.00 245,563.90 0.500 6/20/2016 994 0.31 Trust 0.5 6/20/2016 Of Deposit Sub Total / 2,407,900.81 2,407,900.81 2,405,464.71 0.177 103 2.97 Average Z302: MUD 4 Capital Programs Wells Fargo Sweep WFSWEEP Cash 2/1/2013 1,268,598.49 1,268,598.49 1,268,598.49 0.140 N/A 1 1.57 Cash Sub Total / 1,268,598.49 1,268,598.49 1,268,598.49 0.140 1 1.57 Average Total / Average 81,000,106.29 81,026,763.75 81,023,808.27 0.272 179 100 10 of 10 City of Pearland Purchases Portfolio/Report Group: Report Group: Pearland From 6/30/2013 To 9/30/2013 YTM Portfolio Settlement Maturity Face @ Name Description Bullet/Callable CUSIP/Ticker Action Date Date Price Amount/Shares Cost Principal Interest/Dividends Broker/Dealer 10: Plus General International Fund Bank 0.5 7/8/2016 10: FHLMC 2 Fundral Yes 9/24/2018-14 10: First National General Bank 1.6 Fund 3/19/2018 10: FNMA 0.35 General 8/25/2015 Fund 30: FHLMC 0.5 Sewer Water & 8/28/2015-14 Yes 42: Utility FHLMC 2.25 Fee Impact 9/26/2018-14 Yes 42: Utility The Impact Bank 1.1 Fee 9/16/2016 67: 2003 CIT Bank 1.5 Revenue 9/5/2017 Bonds 2203: Cathay Bank 2009 0.75 Gen 3/21/2016 Obligation CD72940UFV2 Buy 7/8/2013 7/8/2016 100 248,000.00 0.500 248,000.00 0.00 Vining Sparks 3134G4FY9 Buy 9/24/2013 9/24/2018 100 1,000,000.00 2.000 1,000,000.00 0.00 Duncan Williams CD32115CBE7 Buy 9/18/2013 3/19/2018 100 248,000.00 1.600 248,000.00 0.00 Wells Fargo Bank 3135G0UW1 Buy 7/25/2013 8/25/2015 99.863 509,000.00 0.416 508,302.67 801.68 SAMCO Capital Markets 3134G4FP8 Buy 8/28/2013 8/28/2015 100 1,000,000.00 0.500 1,000,000.00 0.00 Duncan Williams 3134G4GE2 Buy 9/26/2013 9/26/2018 99.85 1,000,000.00 2.282 998,500.00 0.00 Duncan Williams CD88632YAG1 Buy 9/18/2013 9/16/2016 100 248,000.00 1.100 248,000.00 0.00 Wens Fargo Bank CD17284CMN1 Buy 9/4/2013 9/5/2017 100 248,000.00 1.500 248,000.00 0.00 Welts Fargo Bank CD149159JE6 Buy 9/20/2013 3/21/2016 100 248,000,00 0.750 248,000.00 0.00 Wells Fargo Bank 1 of 1 Pledged Collateral Reconciliation Report September 30, 2013 Bank Account Number Account Name Amount Wells Fargo 201-0419505 Operating $ - Wells Fargo 201-0419513 Payroll Fund - Wells Fargo 001-3042841 Sweep Account 61,182,515.91 Wells Fargo 179-0121790 EMS Payments - Wells Fargo 807-1613395 Credit Card Account - Wells Fargo 818-4567843 Alvin ISD 4,123,601 78 Wells Fargo 280-7409871 Health Claims 255,413.44 Total of Bank Balances $ 65,561,531.13 Pledged Collateral for City 258,150,395.64 FDIC Insurance 250,000.00 Total Collateral $ 258,400,395 64 Over (Under) Collateralized $ 192,838,864.51 Total % Collateralized 394.1% Bank Account Number Account Name Amount Wells Fargo 100-7284258 Development Authority 7,652,641.98 Total of Bank Balances $ 7,652,641.98 Pledged Collateral for DAP 11,883,246.18 FDIC Insurance 250,000.00 Total Collateral $ 12,133,246.18 Over (Under) Collateralized $ 4,480,604.20 Total % Collateralized 158.5% Bank Account Number Regions 6180003939 $ 4,300.01 6180003948 46,761.20 Total of Bank Balances $ 51,061.21 FDIC Insurance 250,000.00 Over (Under) Collateralized' $ 198,938.79 Total % Collateralized 489.6% Total $ Over (Under) Collateralized $ 197,319,468.71 Total % Collateralized 369.6% Status Collateralized 1'\Investments\Investment Reports\City of Pearland\Investment Report - City - Qtr 0913