Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R-2014-007 2014-01-27
RESOLUTION NO. R2014-7 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS, ACCEPTING THE CITY'S INVESTMENT REPORT FOR THE QUARTER ENDING DECEMBER 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 December 2013. PASSED, APPROVED, AND ADOPTED this 27th day of January, A.D., 2014. ATTEST: APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY TOM REID MAYOR City of Pearland Quarterly Investment Report Sept 30, 2013 - Dec 31, 2013 RESOLUTION NO. R2014-7 Exhibit "A" Portfolio at Sept 30, 2013 Ending Book Value Ending Market Value Accrued Interest Receivable FYD Total Interest Earned Unrealized Gain/(Loss) Change in Unrealized Galn/Loss Weighted Average Maturity Change in Market Value Yield to Maturity at Cost T -Bill Benchmark Agency Note Benchmark $ 81,180,409.69 81,177,454.21 34,705.29 188,482.36 (2,955.48) 25,211.86 179 Days (5,192,607.54) 0.27% 0.10% 0.09% Portfolio at Dec 31, 2013 Ending Book Value Ending Market Value Accrued Interest Receivable FYD Total Interest Earned Unrealized Galn/(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.29% 0.12% 0.14% $ 89,364,730.77 89,321,982.01 47,334.84 58,819.11 (42,748.76) (39,793.28) 230 Days 8,144,527.80 0.33% 0.13% 0.15% This quarterly report Is in compliance with the Investment policy and strategy as established by the City and the Public Funds Investment Act (Chapter 2256, Texas Government Code). Prepared by: Claire Bogard Director of Finance Rick p rgaaFatima Uwakwe Assistant Director of Finance Accounting Supervisor Summary by Type December 31, 2013 Description Face Amount \ Shares Cost Value Book Value Market Value YTM L® Cost Days To Maturity Cash $ 59,438,541.64 $ 59,438,541.64 $ 59,438,541 64 $ 59,438,541.64 0.14% 1 CD 12,903,807.96 12,903,807.96 12,903,807.96 12,876,114.47 0.56% 582 FAMC 1,000,000.00 997,890.00 997,908 33 989,706.00 1.77% 1,737 FFCB 5,500,000.00 5,533,816.03 5,502,928.55 5,504,530.50 0.28% 260 FHLB 2,000,000.00 2,016,920.00 2,007,695.89 2,000,131.00 1.02% 1,056 FHLMC 7,000,000.00 6,996,661.00 6,998,092.96 6,994,451.00 1.11% 1,010 FNMA 1,509,000.00 1,528,352.67 1,515,755.44 1,518,507.40 0.45% 416 Total/Average $ 89,351,349.60 $ 89,415,989.30 $ 89,364,730.77 $ 89,321,982.01 0.33% 230 Group Portfolio Holdings by Type FNMA 2% 14% 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- 30 Days 31- 60 Days 61- 90 Days91-120 Dayh1.1g0 Days . ig0 Days Interest Rates Date 1 mo 3 mo 5 mo 2 yr tyr LIE 10 yr 20 yr 30 yr 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 12/31/2013 0.01 0.07 0.10 0.13 0.38 0.78 1.75 2.45 3.04 3.72 3.96 450 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 Yield Curve Comparison 0.35% 0.30% 0.25% 0.20% - 0.15% - 0.10% - 0.05% 0.00% -, City's Weighted Avg .Yield ..29% 230 Day Average Maturity .wI4..;.:a.i T 1mo 3mo 6mo 1yr 2 yr 3 yr 5yr Tyr 10 yr 20 yr 30 yr -r-9/30/2013 -0-12/31/2013 Portfolio vs. Benchmarks r.. :22 Jan -13 Feb -13 Mar -13 Apr -13 May -13 Jun -13 Jul -13 Aug -13 Sep -13 Oct -13 Nov -13 Dec -13 - -Port Total -40-1 Yr T -Bill - -- Agency Note City of Pearland Quarterly Investment Report Report Format: By CUSDP Group By: Security Type Portfolio/Report Group: Report Group: Pearland Begin Date: 9/30/2013, End Date: 12/31/2013 Ending Portfolio YTM a Maturity Amortized Amortized Investment Desaiption CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Prindpal Discount Premkmr Ending BV Income -BV CASH We15 Fargo WFSWEEP 10: General 0.140 N/A 8,883,597.09 3,033,450.38 1,973,277.87 0.00 0.00 9,943,769.60 2,351.66 Sweep Cash Fund Wets Fargo ash Municipal Sweep oh WFSWEEP Court 0.140 N/A 131,364.31 44.62 5,015.04 0.00 0.00 126,393.89 44.62 Security Weis Fargo 18: City Sweep Cash WFSWEEP Wide 0.140 N/A 88,806.68 4,712.60 0.00 0.00 0.00 93,519.28 32.16 Aonadon Wets Fargo WFSWEEP 19: Court 0.140 N/A 283,435.11 9,672.74 31,365.30 0.00 0.00 261,742.55 94.00 Sweep Cash Technobgy Weis Fargo WFSWEEP 20: Debt 0.140 N/A 3,073,485.03 6,678,402.89 0.00 0.00 0.00 9,751,887.92 2,165.92 Sweep Cash Services 23: Court Wetos Fargo Sweep CashWFSWEEP Juvenile 0.140 N/A 61,821.84 1,991.19 2,254.20 0.00 0.00 61,558.83 21.77 Mgmt Wets Fargo WFSWEEP 30: Water & 0.140 N/A 8,900,303.13 3,163,093.37 618,642.80 0.00 0.00 11,444,753.70 4,054.21 Sweep Cash Sewer Wets Fargo WFSWEEP 31: 0.140 N/A 1,096,976.32 84,596.50 630,623.02 0.00 0.00 552,949.80 174.23 Sweep Cash Soldwaste Weis Fargo WFSWEEP 35: Street 0.140 N/A 637,094.36 3,124.66 235,950.00 0.00 0.00 404,269.02 169.78 Sweep Cash Assessment Wets Fargo WFSWEEP 42: UU6ty 0.140 N/A 3,376,384.56 985.54 744,992.35 0.00 0.00 2,632,377.75 985.54 Sweep Cash Impact Fee 44: Shadow Wets Fargo Sweep CashWFSWEEP Creek 0.140 N/A 1,767,207.70 236,489.76 214,547.69 0.00 0.00 1,789,149.77 665.03 Impact Weds Fargo 45: Sweep Cash WFSWEEP liotel/Motel 0,140 N/A 1,634,144.31 155,567.34 346,515.83 0.00 0.00 1,443,195.82 551.15 Occupancy Wells Fargo WFSWEEP 46: Park 0.140 N/A 116,140.62 7,049.79 10,15633 0.00 0.00 113,034.08 37.88 Sweep Cash Donations Weis Fargo 47: Park Sweep Cash WFSWEEP Rec 0.140 N/A 807,708.33 25,496.41 248,000.00 0.00 0.00 585,204.74 259.01 Development 1 of 9 Ending Portfolio YTi4 411 Maturity Amortized Amortized Investment Desaiption CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV Wets Fargo WFSWEEP 49: Tree 0.140 N/A 73,845.73 325.75 575.00 0.00 0.00 73,596.48 25.75 Sweep Cash Trust Fund Wets Fargo WFSWEEP 50: Capital 0.140 N/A 2,212,173.20 472,227.66 641,258.95 0.00 0.00 2,043,141.91 644.45 Sweep Cash Projects Wets Fargo WFSWEEP 55: Sidewak 0.140 N/A 225,800.10 78.73 0.00 0.00 0.00 225,878.83 78.73 Sweep Cash Fund Weis Fargo 60: Police Sweep Cash WFSWEEP State 0.140 N/A 196,209.15 14,030.96 14,425.00 0.00 0.00 195,815.11 70.23 Seizure Wets Fargo WFSWEEP 62: Federal 0.140 N/A 47,886.28 1,638.97 0.00 0.00 0.00 49,525.25 17.22 Sweep Cash Poice Fund Weis Fargo 64: 1998 Sweep Cash WFSWEEP Cert of 0.140 N/A 845,526.97 256.50 331,325.75 0.00 0.00 514,457.72 256.50 Obligation 67: 2003 Weis Fargo Sweep Cash WFSWEEP Revenue 0.140 N/A 3,969,896.24 83,167.25 1,803,117.19 0.00 0.00 2,249,946.30 979.61 Bonds 68: 2001 WWeis Fargo Weis Fargo WFSWEEP Cert of 0.140 N/A 196,864.01 74,929.38 100,626.61 0.00 0.00 171,166.78 46.40 Sweep Obligation Weis Fargo 70: 2005 Sweep Cash WFSWEEP Refunding / 0.140 N/A 656,562.03 211.94 144,498.44 0.00 0.00 512,275.53 211.94 Mobility Wets Fargo WFSWEEP 95: Property 0.140 N/A 104,308.59 35,645.29 523,870.64 0.00 0.00 -383,916.76 0.00 Sweep Cash UabIRy Weis Fargo 97' Sweep Cash WFSWEEP Employee 0.140 N/A 33,108.26 24,029.24 26,159.59 0.00 0.00 30,977.91 20.42 Benefit Trust 99: COP Well Fargo Cash WF9871 Health 0.140 N/A 255,413.44 1,768,605.14 1,764,570.79 0.00 0.00 259,447.79 113.06 Claims Fund Weis Fargo 99: COP Sweep Cash WFSWEEP Heath 0.140 N/A 619,848.85 163,794.74 675,718.92 0.00 0.00 107,924.67 0.00 Claims Fund Wets Fargo WFSWEEP 2101: Grant 0.140 N/A 0.00 56,655.38 86,363.04 0.00 0.00 -29,707.66 0.00 Sweep Cash Fund Well Fargo WFSWEEP Z109: 2011 0.140 N/A 0.00 0.00 161.41 0.00 0.00 -161.41 0.00 Sweep Cash CDBG Fund Weis Fargo WFSWEEP Z110: 2012 0.140 N/A 0.00 19,113.43 18,908.88 0 00 0.00 204.55 0.00 Sweep Cash CDBG Fund 2 of 9 Ending Portfolio YTM 0 Maturity Amortized Amortized Investment Desoriptbn CUSIP/Tkker Name Cost Date Beginning BV Buy Prindpal Sell Principal Discount Premium Ending BV Income -BV Web Fargo WFSWEEP Z140: U of H 0.140 N/A 18,842.78 16,982.48 0.00 0.00 0.00 35,825.26 9.96 Sweep Cash Fund Z141: U of H Web Sweep Cash WFSWEEP FaCRelel 0.140 N/A 239,779.45 83.60 0.00 0.00 0.00 239,863.05 83.60 Fund WeiFargo Wells 2145: Sweep Cash WFSWEEP Municipal 0.140 N/A 227,557.46 23,642.01 8,521.40 0.00 0.00 242,678.07 82.82 Channel Weis Fargo 2200: 2006 Wo Weisr Cash WFSWEEP Cert of 0.140 N/A 2,011,503.98 697.73 11,690.54 0.00 0.00 2,000,511.17 697.73 SweeObligation Well Fargo 2201: 2007 Sweep Cash WFSWEEP Cert of 0.140 N/A 117,856.47 22.64 53,429.62 0.00 0.00 64,449.49 22.64 Obligation Web Fargo 2202: Sweep Cash WFSWEEP 2007A Gen 0.140 N/A 2,153,229.70 743.80 32,341.97 0.00 0.00 2,121,631.53 743.80 Obligation WelFargo l Far2203: 2009 Sweep 9oh WFSWEEP Gen 0.140 N/A 7,476,741.51 289,920.95 1,104,531.19 0.00 0.00 6,662,131.27 2,359.04 Obligation Fargo 2301: W/S Weis eIs Cash WFSWEEP Pay As U Go 0.140 N/A 2,159,900.81 748.00 20,691.59 0.00 0.00 2,139,957.22 748.00 SweeC1P Web Fargo 2302: MUD Sweep Cash WFSWEEP 4 Capital 0.140 N/A 1,266,241.04 364.65 559,490.86 0.00 0.00 707,114.83 364.65 Programs Sub Total/Average 0.140 55,969,565.44 16,452,594.01 12,983,617.81 0.00 0.00 59,438,541.64 19,183.51 Cash CERTIFICATE OF DEPOSIT CDARS 0.5 1016130741 10: General 0.500 12/18/2014 0.00 500,000.00 0.00 0.00 0.00 500,000.00 82.19 12/18/2014 Fund 10: General 0.700 5/9/2016 0.00 248,000.00 0.00 0.00 0.00 248,000.00 247.32 Fund lst Unked Bank FL 0.7 33741TAU5 5/9/2016 Synovus Bank GA 0.5 11/28/2014 87164DBV1 Townebank Portsmouth VA 89214PAP4 0.4 6/1/2015 10: General 0.500 11/28/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 312.56 Fund 10: General 0.400 6/1/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 250.04 Fund 3 of 9 Ending Portfolio YTM O Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BY Buy Prindpal Sell Prindpal Discount Premium Ending BV Inaome-BV Trust Atlantic 10: General Bank 1.45 89835F3C5 Fund 1.450 12/6/2017 0.00 248,000.00 0.00 0.00 0.00 248,000.00 541.86 12/6/2017 BBCN Bank LA CD073296Al2 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 2,252.75 6/19/2014 Fund CDARS 0.5 C01014682593 10: General 12/19/2013 500,000.00 0.00 500,000.00 0.00 0.00 0.00 554.21 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.55 0.5 5/17/2016 Fund Moody National 10: General Bank 0.5 CD1730 Fund 11/30/2013 246,186.79 0.00 246,186.79 0.00 0.00 0.00 206.36 11/30/2013 Discover Bank CO25467101210: 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 Fund1.600 3/19/2018 248,000.00 0.00 0.00 0.00 0.00 248,000.00 989.29 3/19/2018 First Niagara 10: General Bank 0.25 CD33583CDH9 Fund 11/4/2013 248,000.00 0.00 248,000.00 0.00 0.00 0.00 59.46 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 MlzuhO Bank CD60688TLM9 10: General 0.250 5/8/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 0.25 5/8/2014 Fund Moody Natbnal 10: General Bank 0.5 CD7130A Fund 0.500 5/30/2014 0.00 246,807.96 0.00 0.00 0.00 246,807.96 104.81 5/30/2014 Plus International C072940UFV2 10: General 0.500 7/8/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 312.55 Bank 0.5 Fund 7/8/2016 Southwest 10: General Bank Ft Worth CD844772AA1 Fund 0.300 2/27/2025 248,000.00 0.00 0.00 0.00 0.00 248,000.00 187.52 0.3 2/27/2015 Valey 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 Ohb 20: Debt 0.35 C0493065RE8 Services 0.350 8/27/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 218.79 4 of 9 Descriptbn 8/27/2014 Mechanics Savings Bank 0.35 3/20/2015 Bay Cries Bank 0.5 12/12/2014 CDARS 0.5 6/19/2014 First Farmers Bank 0.5 5/3/2016 CUSIP/Ticker Ending Portfolio YTM IP Maturity Name Cost Date Beginning BV Buy Prtdpal Amortised Amortized Investment Sell Prindpal Discount Premium Ending BV Income -BV Fox Chase Bank 0.65 6/27/2016 Goldman Sachs Bank 0.6 2/20/2015 SAFRA NATIONAL BANK 0.6 5/5/2014 United Bankers Bank 0.75 5/6/2016 Hardin County Bank 0.25 12/30/2014 BMW Bank of NA 0.85 6/8/2015 Colege Savings Bank 0.55 6/20/2016 Private Bank & Trust 0.35 5/11/2015 Stering Sayings Bank 0.35 2/23/2015 The Independent CD58368613C3 20: Debt Services 0.350 3/20/2015 248,000.00 CD07203QBR2 30: Water & 0.500 12/12/2014 248,000.00 Sewer CD10139818568 35ewerater & 0.500 6/19/2014 500,000.00 CD320165F21 350evrera�r & 0.500 5/3/2016 245,000.00 CD35137QAN4 0.650 6/27/2016 248,000.00 CD381473AA0 0.600 2/20/2015 248,000.00 30: Water & Sewer 30: Water& Sewer C0786580150 30: Water& 0.600 5/5/2014 Sewer 909557CV0 411822863 CD05568P2Q9 CD19443PAP4 CD74267GTC1 C08595316A8 35: Street 0.750 5/6/2016 Assessment 42: Utility Impact Fee 42: Utility Impact Fee 42: Utility Impact Fee 42: Utility Impact Fee 42: Utility Impact Fee CD88632YAG1 42: Utility Impact Fee 0.250 12/30/2014 0.850 6/8/2015 0.550 6/20/2016 0.350 5/11/2015 0.350 2/23/2015 1.100 9/16/2016 248,000.00 0.00 0.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 5 of 9 0.00 0.00 0.00 0.00 248,000.00 218.78 0.00 0.00 0.00 0.00 248,000.00 312.55 0.00 0.00 0.00 0.00 500,000.00 630.14 0.00 0.00 0.00 0.00 245,000.00 308.75 0.00 0.00 0.00 0.00 248,000.00 406.31 0.00 0.00 0.00 0.00 248,000.00 375.05 0.00 248,000.00 248,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 248,000.00 375.05 0.00 0.00 0.00 248,000.00 280.28 0.00 0.00 0.00 248,000.00 1.70 0.00 0.00 0.00 248,000.00 531.34 0.00 0.00 0.00 248,000.00 340.07 0.00 0.00 0.00 248,000.00 216.40 0.00 0.00 0.00 248,000.00 218.78 0.00 0.00 0.00 248,000.00 702.55 Ending Portfolio YTM 0 Maturity Amortized Amortized Investment Desaiptlon CUSIP/Ticker Name Cost Date Beginning BV Buy Prtndpal Sell Prindpal Discount Premium Ending BV Income -BV Bank 1.1 9/16/2016 Bank of Buffalo 44: Shadow KY 0.35 060788AF3 Creek 0.350 6/22/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 26.16 6/22/2015 Impact 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 Fist 45: Commercial 31984GCW7 Hotel/Motel 0.400 6/26/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 10.87 Bank Mks 0.4 Occupancy 6/26/2015 Colonial Virginia 45: Bank 0.55 CD196121AM9 HoteVMotel 0.550 6/24/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 343.81 6/24/2016 Occupancy First Natlal Bank 45: WI0.25 CD321086FE5 HoteVMotel 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 First State Bank 47: park & - Un Cty Tenn 336472E10 Rec 0.450 12/23/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 24.46 0.45 Development 12/23/2015 US AmerlBank 64: 1998 Largo FL 0.55 917312CC2 Cert of 0.550 12/23/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 29.90 12/23/2015 Obligation First National 67: 2003 Bank ORD NEB 32116RAC8 Revenue 0.800 11/18/2016 0.00 248,000.00 0.00 0.00 0.00 248,000.00 233.73 0.8 Bonds 11/18/2016 Ashev0e 67: 2003 Savings Bank CO04407RAJ0 Revenue 0.350 3/27/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 218.77 0.35 Bonds 3/27/2015 CIT Bank 1.5 67: 2003 9/5/2017 CD17284CMN1 Revenue 1 500 9/5/2017 248,000.00 0.00 0.00 0.00 0.00 248,000.00 937.64 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 2202: 6/28/2016 CD15118R1D0 2007A Gen 0.600 6/28/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 375.06 6 of 9 Ending Portfolio YTM lit Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Prindpal SeU Principal Discount Premium Ending BV Income -BV Obligation Kansas State Z203: 2009 Bank 0.8 485382DV4 Gen 0.800 10/31/2016 0.00 248,000.00 0.00 0.00 0.00 248,000.00 331.57 10/31/2016 Obligation Cathay Bank 2203: 2009 0.75 C01491593E6 Gen 0.750 3/21/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 468.82 3/21/2016 Obligation DeWitt Bank Z301: W/5 and That 0.5 CO241888812 Pay As U Go 0.500 6/20/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 312.55 6/20/2016 CIP Farm Bureau Z302: MUD Bank 0.5 307660HH6 4 Capital 0.500 12/23/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 27.18 12/23/2015 Programs Pacific City Bank 2302: MUD 0.35 69406PB)7 4 Capital 0.350 6/26/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 11.89 6/26/2015 Programs Sub Total/Average Certificate Of Deposit FAMC BOND FAMC 1.72 10/3/2018 31315P5A3 0.557 10,175,186.79 3,722,807.96 994,186.79 0.00 0.00 12,903,807.96 16,840.25 30: Water & 1.766 10/3/2018 0.00 997,890.00 0.00 18.33 0.00 997,908.33 734.99 Sewer Sub Total/Average FAMC Bond 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 3133EAU30 3133EAYL6 3133ECAV6 3133EA3U0 313311DY6 10: General Fund 10: General Fund 20: Debt Services 42: Utillty Impact Fee 67: 2003 Revenue Bonds Sub 1.766 0.00 997,890.00 0.00 18.33 0.00 997,908.33 734.99 0.320 3/12/2015 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 808.89 0.285 7/18/2014 1,000,119.55 0.00 0.00 0.00 -37.77 1,000,081.78 720.56 0.273 12/24/2014 999,715.22 0.00 0.00 58.37 0.00 999,773.59 690.31 0.300 1/9/2015 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 758.33 0.230 2/10/2014 1,510,243.92 0.00 0.00 0.00 -7,170.74 1,503,073.18 886.56 0.277 5,510,078.69 0.00 0.00 58.37 -7,208.51 5,502,928.55 3,864.65 7 of 9 Ending Portfolio YTM ® Maturity Amortized Amortized Investment Description CUSIP/Tidcer Name Cost Date Beginning BV Buy Prtndpal Sen Principal Discount Premium Ending BV Income -BV Total/Average FFCB Bond FHLB BOND FHLB 1.15 10/30/2014 FHLB 1.75 12/14/2018 FHLB 0.32 12/26/2014-13 3133743W8 313376BR5 313381G58 30: Water& Sewer 30: Water& Sewer 67: 2003 Revenue Bonds 0.300 10/30/2014 1,009,171.49 0.00 0.00 0.00 -2,140.01 1,007,031.48 734.99 1.736 12/14/2018 0.00 1,000,670.00 0.00 0.00 -5.59 1,000,664.41 723.58 12/26/2014 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 497.77 Sub Total/Average FHLB Bond FHLMC BOND FHLMC 0.375 4/28/2014 FHLMC 2 9/24/2018-14 FHLMC 0.35 12/31/2015-14 FHLMC 1.85 12/27/2018-14 FHLMC 0.5 8/28/2015-14 FHLMC 2.25 9/26/2018-14 FHLMC 0.35 12/5/2014 3134G3567 3134G4FY9 3134G4QK7 3134G4QV3 3134G4FP8 3134G4GE2 3134G3H78 1.013 2,009,171.49 1,000,670.00 1,000,000.00 0.00 -2,145.60 2,007,695.89 1,95634 10: General Fund 10: General Fund 10: General Fund 20: Debt Servkes 30: Water & Sewer 42: Utility Impact Fee 67: 2003 Revenue Bonds 0.467 4/28/2014 999,473.77 0.00 0.00 230.22 0.00 999,703.99 1,178.14 2.000 9/24/2018 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 5,055.56 0.369 12/31/2015 0.00 999,625.00 0.00 0.00 0.00 999,625.00 0.00 1.850 12/27/2018 0.00 1,000,000.00 0.00 0.00 0.00 1,000,000.00 205.56 0.500 8/28/2015 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,263.89 2.282 9/26/2018 998,503.33 0.00 0.00 75.84 0.00 998,579.17 5,763.34 0.330 12/5/2014 1,000,235 15 0.00 0.00 0.00 -50.35 1,000,184.80 834.37 Sub Total/Average 1.114 4,998,212.25 1,999,625.00 0.00 306.06 -50.35 6,998,092.96 14,300.86 FHLMC Bond FNMA BOND FNMA 0.35 8/25/2015 FNMA 1.3 11/17/2014 3135GDUW 1 3136FPWZ6 10: General Fund 30: Water & Sewer 0.416 8/25/2015 508,363.11 0.462 11/17/2014 1,009,412.17 8 of 9 0.00 0.00 0.00 0.00 84.60 0.00 508,447.71 534.92 0.00 -2,104.44 1,007,307.73 1,181.67 Ending Portfolio YTM 8* Maturity Amortized Amortized Investment Description CUSIP/Tidrer Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV FNMA 1.05 10/22/2013 31398A4S8 30: Water & Sewer 10/22/2013 1,000,419.75 0.00 1,000,000.00 0.00 -419.75 0.00 221.92 Sub Total/Average FNMA Bond 0.447 2,518,1.95.03 0.00 1,000,000.00 84.60 -2,524.19 1,515,755.44 1,938.51 Total / Average 0.328 81,180,409.69 24,173,586.97 15,977,804.60 467.36 -11,928.65 89,364,730.77 58,819.11 9 of 9 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/2013 Portfolio Settlement Maturity YTM S Face Days To Accrued % of Description CUSIP/Tldrer Name Date Date Cost Amount/Shares Cost Vakie Book Value Market Value Maturity Interest Portfolio Cash Welk Fargo WFSWEEP 10: General 5/31/2006 N/A 0.140 9,943,769.60 9,943,769.60 9,943,769.60 9,943,769.60 1 11.13 Sweep Cash Fund Weis Fargo 17: Municipal Sweep Fargo WFSWEEP Court 5/31/2006 N/A 0.140 126,393.89 126,393.89 126,393.89 126,393.89 1 0.14 Securfry Web Fargo 18: City Sweep Cash WFSWEEP Wide 5/31/2006 N/A 0.140 93,519.28 93,519.28 93,519.28 93,519.28 1 0.10 Donation Wets Fargo WFSWEEP 19: Court 5/31/2006 N/A 0.140 261,742.55 261,742.55 261,742.55 261,742.55 1 0.29 Sweep Cash Technology Wets Fargo WFSWEEP 20:Oe5/31/2006 N/A 0.140 9,751,887.92 9,751,887.92 9,751,887.92 9,751,887.92 1 10.91 Sweep Cash Services Welk Fargo 23: Court Sweep Cash WFSWEEP Juvenile 9/15/2009 N/A 0.140 61,558.83 61,558.83 61,558.83 61,558.83 1 0.07 Mgmt We Fargo WFSWEEP 30: Water & 5/31/2006 WA 0.140 11,444,753.70 11,444,753.70 11,444,753.70 11,444,753.70 1 12.81 Sweep Cash Sewer Welk Fargo WFSWEEP 31: 12/1/2006 N/A 0.140 552,949.80 552,949.80 552,949.80 552,949.80 1 0.62 Sweep Cash So dwaste We Fargo WFSWEEP 35: Street 5/31/2006 N/A 0.140 404,269.02 404,269.02 404,269.02 404,269.02 1 0.45 Sweep Cash Assessment Welk Fargo WFSWEEP 42: Ut®ty 5/31/2006 N/A 0.140 2,632,377.75 2,632,377.75 2,632,377.75 2,632,377.75 1 2.95 Sweep Cash Impact Fee 44: Shadow We Fargo Sweep go WFSWEEP Creek 5/31/2006 N/A 0.140 1,789,149.77 1,789,149.77 1,789,149.77 1,789,149.77 1 2.00 Impact Wells Fargo 45: Sweep Cash WFSWEEP HoteVMotel 5/31/2006 N/A 0.140 1,443,195.82 1,443,195.82 1,443,195.82 1,443,195.82 1 1.62 Occupancy Wells Fargo WFSWEEP 46: Park 5/31/2006 N/A 0 140 113,034.08 113,034.08 113,034.08 113,034.08 1 0.13 Sweep Cash Donatbns Wefts Fargo 47: Park & Sweep Cash WFSWEEP Rec 5/31/2006 N/A 0.140 585,204 74 585,204.74 585,204.74 585,204.74 1 0.65 Devebpment Wets Fargo WFSWEEP 49: Tree 5/31/2006 N/A 0.140 73,596.48 73,596.48 73,596.48 73,596.48 1 0.08 Sweep Cash Trust Fund 1 of 8 Portfolio Settlement Maturity YTM ® Face Days To Accrued % of Description CUSIP/Tidter Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Welk Fargo WFSWEEP 50: Ceptai 5/31/2006 N/A 0.140 2,043,141.91 2,043,141.91 2,043,141.91 2,043,141.91 1 2.29 Sweep Cash Projects We F3 rgo WFSWEEP 55: Sidewalk 5/31/2006 N/A 0.140 225,878.83 225,878.83 225,878.83 225,878.83 1 0.25 Sweep Cash Fund 60: Poise We Fargo Sweep Cash WFSWEEP State 5/31/2006 N/A 0.140 195,815.11 195,815.11 195,815.11 195,815.11 1 0.22 Seizure Wets Fargo WFSWEEP 62: Federal 5/31/2006 N/A 0.140 49,525.25 49,525.25 49,525.25 49,525.25 1 0.06 Sweep Cash Police Fund 64: 1998 Wets Fargo Sweep Cash WFSWEEP Cert of 5/31/2006 N/A 0.140 514,457.72 514,457.72 514,457.72 514,457.72 1 0.58 Obligation Weds Fargo 67: 2003 Sweep Cash WFSWEEP Revenue 5/31/2006 N/A 0.140 2,249,946.30 2,249,946.30 2,249,946.30 2,249,946.30 1 2.52 Bonds 68: 2001 Wets Fargo Sweep Cash WFSWEEP Cert of S/ 31/2006 N/A 0.140 171,166.78 171,166.78 171,166.78 171,166.78 1 0.19 Obligation Weis Fargo 70: 2005 Sweep Cash WFSWEEP Refunding / 5/31/2006 N/A 0.140 512,275.53 512,275.53 512,275.53 512,275.53 1 0.57 Mobility Sweep Ca h WFSWEEP �b 10/31/2006 N/A 0.140 -383,916.76 -383,916.76 -383,916.76 -383,916.76 1 -0.43 97: Weds Fargoo Sweep Cash WFSWEEP Empbyee 9/1/2007 N/A 0.140 30,977.91 30,977.91 30,977.91 30,977.91 1 0.03 Benelk Trust 99: COP Welk Fargo Sweep Cash WFSWEEP Heath 9/15/2010 N/A 0.140 107,924.67 107,924.67 107,924.67 107,924.67 1 0.12 Claims Fund Weis Fargo 99: COP Cash WF9871 Heath 7/21/2010 N/A 0.140 259,447.79 259,447.79 259,447.79 259,447.79 1 0.29 Claims Fund We Fargo WFSWEEP Z101: Grant 5/31/2006 N/A 0.140 -29,707.66 -29,707.66 -29,707.66 -29,707.66 1 -0.03 Sweep Cash Fund Weds Fargo WFSWEEP Z109: 2011 12/1/2011 N/A 0.140 -161.41 -161.41 -161.41 -161.41 1 0.00 Sweep Cash CDBG Fund Weis Fargo WFSWEEP Z110: 2012 11/15/2012 N/A 0.140 204.55 204.55 204.55 204.55 1 0.00 Sweep Cash CDBG Fund Wets Fargo WFSWEEP 2140: U of H 12/1/2009 N/A 0.140 35,825.26 35,825.26 35,825.26 35,825.26 1 0.04 Sweep Cash Fund Z141: U of H Weis Sweep Cash WFSWEEP RCFaenpewal 9/30/2013 N/A 0.140 239,863.05 239,863.05 239,863.05 239,863.05 1 0.27 Fund 2 of 8 Portfolio Settlement Maturity YTM 0 Face Days To Accrued % of Description CUSIP/Tidier Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio WeiFargo s Fargo Z145: Sweep Cash WFSWEEP Munk:ipal 4/15/2012 N/A 0.140 242,678.07 242,678.07 242,678.07 242,678.07 1 0.27 Channel Welk Fargo Z200: 2006 Sweep Cash WFSWEEP Cert of 6/30/2006 N/A 0.140 2,000,511.17 2,000,511.17 2,000,511.17 2,000,511.17 1 2.24 Obllgatbn 2201: 2007 We Fargo Sweep Cash WFSWEEP Cert of 8/31/2006 WA 0.140 64,449.49 64,449.49 64,449.49 64,449.49 1 0.07 Obligation Z202: Wells Fargo Sweep Cash WFSWEEP 2007A Gen 12/31/2007 N/A 0.140 2,121,631.53 2321,631.53 2321,631.53 2,121,631.53 1 2.37 Obligation Wells Fargo Z203: 2009 Sweep Cash WFSWEEP Gen 10/30/2008 N/A 0.140 6,662,131.27 6,662,131.27 6,662,131.27 6,662,131.27 1 7.46 Obligation Z301: W/S Weis Fargo Sweep Cash WFSWEEP Pay As U Go 12/31/2007 N/A 0.140 2,139,957.22 2,139,957.22 2,139,957.22 2.139,957.22 1 2.39 CIF Weis Fargo go Z302: MUD Sweep WFSWEEP 4 Cagan! 2/1/2013 WA 0.140 707,114.83 707,114.83 707,114.83 707,114.83 1 0.79 Programs Sub Total / 0.140 59,438,541.64 59,438,541.64 59,438,541.64 59,438,541.64 1 0.00 66.52 Average Certilirate Of Deposit CDARS 0.5 1016130741 10: General 12/19/2013 12/18/2014 0.500 500,000.00 500,000.00 500,000.00 500,000.00 352 82.19 0.56 12/18/2014 Fund Vasey 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,985,86 211 313.91 0.28 7/30/2014 Fist 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 247,442.50 1539 130.45 0.28 3/19/2018 Ist United Bank 10: General FL 0.7 33741TAU5 Fund 11/8/2013 5/9/2016 0.700 248,000.00 248,000.00 248,000.00 247,127.29 860 104.64 0.28 5/9/2016 Trust Atlantic 10: General Bank 1.45 89835F105 Fund 11/6/2013 12/6/2017 1.450 248,000.00 248,000.00 248,000.00 247,315.27 1436 246.30 0.28 12/6/2017 B8CN Bank LA C0073296AT2 10: General 2/8/2013 2/7/2014 0.250 248,000.00 248,000.00 248,000.00 247,960.82 38 39.07 0.28 0.25 2/7/2014 Fund Southwest 10: General Bank Ft Worth CD844772AA1 Fund 2/27/2013 2/27/2015 0.300 248,000.00 248,000.00 248,000.00 247,797.88 423 8.15 0.28 0.3 2/27/2015 3 of 8 PortfoBo Settlement Maturfty YTM ® Face Days To Accrued % of Description CUSIP/Tidker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Plus International CD72940UFV2 10: General 7/8/2013 7/8/2016 0.500 248,000.00 248,000.00 248,000.00 246,059.15 920 78.14 0.28 Bank 0.5 Fund 7/8/2016 CDARS 0.6 10: General 6/19/2014 CD1013981872 Fund 6/21/2012 6/19/2014 0.600 500,000.00 500,000.00 500,000.00 500,000.00 170 0.00 0.56 Cardinal Bank CD14147VDM5 10: General 5/17/2013 5/17/2016 0500 248,000.00 248,000.00 248,000.00 246,544.74 868 47.56 0.28 0.5 5/17/2016 Fund Moody National 10: General Bank 0.5 CD7130A Fund 11/30/2013 5/30/2014 0.500 246,807.96 246,807.96 246,807.96 246,807.96 150 104.81 0.28 5/30/2014 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,947.42 37 42.47 0.28 0.25 2/6/2014 Discover Bank CD254671KH2 10: General 2/20/2013 2/20/2015 0.500 248,000.00 248,000.00 248,000.00 247,811.77 416 451.84 0.28 0.5 2/20/2015 Fund Synovus Bank 10: General GA 0.5 87164138V1 Fund 11/30/2012 11/28/2014 0.500 248,000.00 248,000.00 248,000.00 248,649.51 332 105.32 0.28 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 247,436.54 517 84.25 0.28 0.4 6/1/2015 Mhuho Bank CD60688T1M9 10: General 5/8/2013 5/8/2014 0.250 248,000.00 248,000.00 248,000.00 247,999.75 128 402.58 0.28 0.25 5/8/2014 Fund Key Bank Ohb 20: Debt 0.35 CD493065RE8 Services2/27/2013 8/27/2014 0.350 248,000.00 248,000.00 248,000.00 248,068.20 239 299.64 0.28 8/27/2014 Mechanics Savings Bank CD5836868C3 20: Debt 3/20/2013 3/20/2015 0.350 248,000.00 248,000.00 248,000.00 247,633.21 444 26.16 0.28 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,645.86 416 542.20 0.28 2/20/2015 SAFRA NATIONAL C0786580150 30: Water& 8/1/2012 5/5/2014 0.600 248,000.00 248,000 00 248,000.00 248,370 02 125 236.45 0.28 BANK 0.6 Sewer 5/5/2014 Bay Cities Bank 30: Water & 0.5 CD07203Q8R2 Sewer 12/12/2012 12/12/2014 0.500 248,000.00 248,000.00 248,000.00 248,644.80 346 64.55 0.28 12/12/2014 CDARS 0.5 CD10139818568 30: Water & 6/20/2013 6/19/2014 0.500 500,000.00 500,000.00 500,000.00 500,000 00 170 1,328.77 0.56 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 246,148.18 909 17.67 0.28 4 of 8 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 6/27/2016 First Farmers 30: Water & Bank 0.5 CD320165F21 Sewer 5/3/2013 5/3/2016 0.500 245,000.00 245,000.00 245,000.00 243,731.64 854 93.97 0.27 5/3/2016 United Bankers 35: Street Bank 0.75 909557CV0 Assessment 11/6/2013 5/6/2016 0.750 248,000.00 248,000.00 248,000.00 247,206.40 857 127.40 0.28 5/6/2016 Hardin County 42: Utility Bank 0.25 411822663pact Fee 12/30/2013 12/30/2014 0.250 248,000.00 248,000.00 248,000.00 247,248.81 364 1.70 0.28 Im 12/30/2014 Private Bank & 42: Ut&ty Trust 0.35 CD74267GTC1 impact Fee 5/10/2013 5/11/2015 0.350 248,000.00 248,000.00 248,000.00 247,49755 496 118.90 0.28 5/11/2015 Sterling Savings 42: Utility Bank 0.35 CD8595316A8Impact Fee 2/22/2013 2/23/2015 0350 248,000.00 248,000.00 248,000.00 247,805.82 419 311.53 0.28 2/23/2015 College Savings 42: Unity Bank 0.55 CD19443PAP4 Impact Fee 6/19/2013 6/20/2016 0.550 248,000.00 248,000.00 248,000.00 246,211.18 902 41.11 0.28 6/20/2016 The Independent CD88632YAG1 42Pa tility a 9/18/2013 9/16/2016 1.100 248,000.00 248,000.00 248,000.00 247,572.94 990 112.11 0.28 Bank 1.1 9/16/2016 BMW Bank of 42: UtBty NA 0.85 CD05568P2Q9 Impact Fee 12/7/2012 6/8/2015 0.850 248,000.00 248,000.00 248,000.00 248,815.18 524 138.61 0.28 6/8/2015 Marin 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 246,257.06 896 63.53 0.28 6/14/2016 Impact Bank of Buffalo 44: Shadow KY 0.35 060788AF3 Creek 12/20/2013 6/22/2015 0.350 248,000.00 248,000.00 248,000.00 247,049.17 538 26.16 0.28 6/22/2015 knpact First Nadal Bank 45: WI 0.25 CD321086FE5 HoteVMotel 1/31/2013 1/3I/2014 0.250 248,000.00 248,000.00 248,000.00 247,957.59 31 50.96 0.28 1/31/2014 Occupancy First 45: Commercial 31984GCW7 HoteVMotel 12/27/2013 6/26/2015 0.400 248,000.00 248,000.00 248,000.00 247,03032 542 10.87 0.28 Bank Miss 0.4 Occupancy 6/26/2015 Cobn ai Virginia 45: Bank 0.55 CD196121AM9 HoteVMotel 6/25/2013 6/24/2016 0.550 248,000.00 248,000.00 248,000.00 246,170.50 906 26,16 0.28 6/24/2016 Occupancy First State Bank 47: Park & - Un Cty Tenn 336472E70 Rec 12/23/2013 12/23/2015 0.450 248,000.00 248,000.00 248,000.00 247,029.33 722 24.46 0.28 0.45 Devebpment 12/23/2015 5 of 8 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 US AmerlBank 64: 1998 Largo FL 0.55 917312CC2 Cert of 12/23/2013 12/23/2015 0.550 248,000.00 248,000.00 248,000.00 247,078.43 722 29.90 0.28 12/23/2015 Obligation Asheville 67: 2003 Savings Bank CD04407RA)0 Revenue 2/28/2013 3/27/2015 0.350 248,000.00 248,000.00 248,000.00 247,599.98 451 7.13 0.28 0.35 Bonds 3/27/2015 Medallion Bank 67: 2003 UT 0.4 CD584038862 Revenue 5/3/2013 11/3/2015 0.400 248,000.00 248,000.00 248,000.00 247,434.81 672 157.63 0.28 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 247,817.47 1344 1,202.63 0.28 Bonds First National 67: 2003 Bank ORD NEB 32116RAC8 Revenue 11/18/2013 11/18/2016 0.800 248,000.00 248,000.00 248,000.00 247,126.79 1053 233.73 0.28 0.8 Bonds 1I/18/2016 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,649.51 337 66.59 0.28 12/3/2014 Mobility Ceti Bank 0.6 Z202: R)D 6/28/2016 CD151180 2007A Gen 6/28/2013 6/28/2016 0.600 248,000.00 248,000.00 248,000.00 246,203.74 910 12.23 0.28 Obligation Kansas State Z203: 2009 Bank 0.8 48538201/4 Gen 10/30/2013 10/31/2016 0.800 248,000.00 248,000.00 248,000.00 247,30932 1035 0.00 0.28 10/31/2016 Obligation Cathay Bank 2203: 2009 0.75 CD149159JE6 Gen 9/20/2013 3/21/2016 0.750 248,000.00 248,000.00 248,000.00 247,576.17 811 56.05 0.28 3/21/2016 Obligation DeWitt Bank 2301: W/S and Trust 0.5 CD24188813T2 Pay As U Go 6/24/2013 6/20/2016 0.500 248,000.00 248,000.00 248,000.00 246,264.99 902 37.37 0.28 6/20/2016 CIP Farm Bureau Z302: MUD Bank 0.5 307660HH6 4 Capital 12/23/2013 12/23/2015 0.500 248,000.00 248,000.00 248,000.00 247,078.18 722 27.18 0.28 12/23/2015 Programs Pacific Cty Bank Z302: MUD 0.35 69406P8)7 4 Capital 12/26/2013 6/26/2015 0.350 248,000.00 248,000.00 248,000.00 246,994.86 542 11.89 0.28 6/26/2015 Programs Sub Total / 0.557 12,903,807.96 12,903,807.96 12,903,807.96 12,876,114.47 582 7,746.92 14.44 Average FAMC Bond FAMC 1.72 31315P5A3 30: water & 12/16/2013 10/3/2018 1.766 1,000,000.00 997,890.00 997,908.33 989,706.00 1737 4,204.44 1.12 10/3/2018 Sewer 6 of 8 Portfolio Settlement Maturity YTM 0 Face Days To Accrued % of Desaiptbn CUSIP/Tither Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Sub Total / 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 3133EAU30 3133EAY16 3133ECAV6 3133EA3U0 313311DY6 10: General Fund 10: General Fund 20: Debt Services 42: Ut6ty Impact Fee 67: 2003 Revenue Bonds Sub Total/ Average FHLB Bond FHLB 1.15 10/30/2014 FHLB 1.75 12/14/2018 1.766 1,000,000.00 997,890.00 997,908.33 989,706.00 1737 4,204.44 1.12 10/31/2012 3/12/2015 0.320 1,000,000.00 1,000,000.00 1,000,000.00 1,000,014.00 436 968.89 1.12 8/1/2012 7/18/2014 0.285 1,000,000.00 1,000,293.48 1,000,081.78 1,000,816.00 199 1,358.33 1.12 1/28/2013 12/24/2014 0.273 1,000,000.00 999,560.00 999,773.59 1,000,609.00 358 48.61 1.12 11/29/2012 1/9/2015 0.300 1,000,000.00 1,000,000.00 1,000,000.00 1,000,015.00 374 1,433.33 1.12 11/29/2012 2/10/2014 0.230 1,500,000.00 1,533,962.55 1,503,073.18 1,503,076.50 41 12,484.3B 1.68 0.277 5,500,000.00 5,533,816.03 5,502,928.55 5,504,530.50 260 16,293.54 6.16 3133743W8 313376BR5 30: Water & 11/29/2012 10/30/2014 0.300 1,000,000.00 1,016,250.00 1,007,031.48 1,008,023.00 303 1,916.67 1.12 Sewer 30: Water & 12/16/2013 12/14/2018 1.736 1,000,000.00 1,000,670.00 1,000,664.41 992,108.00 1809 826.39 1.12 Sewer Sub Total / Average 1.018 2,000,000.00 2,016,920.00 2,007,695.89 2,000,131.00 1056 2,743.06 2.24 FHLMC Bond FHLMC 2 3134G4FY9 9/24/2018-14 FHLMC 0.375 3134G3557 4/28/2014 FHLMC 0.35 3134G4QK7 12/31/2015-14 FHLMC 1.85 12/27/2018-14 FHLMC 0.5 8/28/2015-14 FHLMC 2.25 9/26/2018-14 FHLMC 0.35 12/5/2014 3134G4QV3 3134G4FP8 3134G4GE2 3134G3H78 10: General Fund 10: General Fund 10: General Fund 20: Debt Services 30: Waters, Sewer 42: Utility Impact Fee 67: 2003 Revenue Bonds 9/24/2013 9/24/2018 2.000 1,000,000.00 1,000,000.00 1,000,000.00 998,228.00 1728 5,388.89 1.12 3/27/2012 4/28/2014 0.467 1,000,000.00 998,100.00 999,703.99 1,000,789.00 118 656.25 1.12 12/31/2013 12/31/2015 0.369 1,000,000.00 999,625.00 999,625.00 997,800.00 730 0.00 1.12 12/27/2013 12/27/2018 1.850 1,000,000.00 1,000,000.00 1,000,000.00 992,872.00 1822 205.56 1.12 8/28/2013 8/28/2015 0.500 1,000,000.00 1,000,000.00 1,000,000.00 1,000,510.00 605 1,708.33 1.12 9/26/2013 9/26/2018 2.282 1,000,000.00 998,500.00 998,579.17 1,002,694.00 1730 5,937.50 1.12 9/27/2012 12/5/2014 0.330 1,000,000.00 1,000,436.00 1,000,184.80 1,001,558.00 339 252.78 1.12 7 of 8 Portfolio Settlement Maturity YTM a Fane Days To Accrued % of Description CUSIP/Tkler Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Sub Total / 1.114 7,000,000.00 6,996,661.00 6,998,092.96 6,994,451.00 1010 14,149.31 7.83 Average FNMA Bond FNMA 0.35 8/25/2015 FNMA 1.3 11/17/2014 3135GOUW1 3136FPWZ6 10: General 7/25/2013 8/25/2015 0.416 509,000.00 508,302.67 508,447.71 508,768.40 602 608.68 0.57 Fund 30: Water B 6/20/2012 11/17/2014 0.462 1,000,000.00 1,020,050.00 1,007,307.73 1,009,739.00 321 1,588.89 1.12 Sewer Sub Total / Average 0.446 1,509,000.00 1,528,352.67 1,515,755.44 1,518,507.40 416 2,197.57 1.69 Total / Average 0.328 89,351,349.60 89,415,989.30 89,364,730.77 89,321,982.01 230 47,334.84 100 8 of8 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/2013 Description CUSIP/Tidcer Severity 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 CDARS 0.5 12/18/2014 Valley Bank Roanoke 0.3 7/30/2014 First Natbnal Bank 1.6 3/19/2018 1st United Bank FL 0.7 5/9/2016 Trust Atlantic Bank 1.45 12/6/2017 BBCN Bank LA 0.25 2/7/2014 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 Moody National Bank 0.5 5/30/2014 Gorham Savings Bank 0.25 2/6/2014 Discover Bank 0.5 2/20/2015 Synovus Bank GA 0.5 11/28/2014 WFSWEEP Cash 1016130741 CD91935VAN0 CD32115CBE7 33741TAU5 89835FJC5 CD073296AT2 CD844772AA1 C072940UFV2 C01013951872 CD14147VDM5 CD7130A CD383052CN5 CD254671KH2 87164DBV1 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 Certificate Of Deposit 5/31/2006 12/19/2013 1/30/2013 9/18/2013 11/8/2013 11/6/2013 2/8/2013 2/27/2013 7/8/2013 6/21/2012 5/17/2013 11/30/2013 2/6/2013 2/20/2013 11/30/2012 9,943,769.60 500,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 500,000.00 248,000.00 246,807.96 248,000.00 248,000.00 248,000.00 1 of 10 9,943,769.60 9,943,769.60 0.140 N/A 1 11.13 500,000.00 500,000.00 0.500 12/18/2014 352 0.56 248,000.00 247,985.86 0.300 7/30/2014 211 0.28 248,000.00 247,442.50 1.600 3/19/2018 1539 0.28 248,000.00 247,127.29 0.700 5/9/2016 860 0.28 248,000.00 247,315.27 1.450 12/6/2017 1436 0.28 248,000.00 247,960.82 0.250 2/7/2014 38 0.28 248,000.00 247,797.88 0.300 2/27/2015 423 0.28 248,000.00 246,059.15 0.500 7/8/2016 920 0.28 500,000.00 500,000.00 0.600 6/19/2014 170 0.56 248,000.00 246,544.74 0.500 5/17/2016 868 0.28 246,807.96 246,807.96 0.500 5/30/2014 150 0.28 248,000.00 247,947.42 0.250 2/6/2014 37 0.28 248,000.00 247,811.77 0.500 2/20/2015 416 0.28 248,000.00 248,649.51 0.500 11/28/2014 332 0.28 Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Tidcer Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Townebank Certificate Portsmouth VA 0.4 89214PAP4 Of Deposit5/31/2013 248,000.00 248,000.00 247,436.54 0.400 6/1/2015 517 0.28 6/1/2015 Mlzuho Bank 0.25 CertifiCD60688TLM9 Of 5/8/2013 248,000.00 248,000.00 247,999.75 0.250 5/8/2014 128 0.28 5/8/2014 Of Deposit FFCB 0.32 3133EAU30 FFCB Bond 10/31/2012 1,000,000.00 1,000,000.00 1,000,014.00 0.320 3/12/2015 436 1.12 3/12/2015-12 FFCB 0.3 7/18/2014 3133EAYL6 FFCB Bond 8/1/2012 1,000,000.00 1,000,081.78 1,000,816.00 0.285 7/18/2014 199 1.12 9/2%201814 2 3134G4FY9 FHLMC9/24/2013 1,000,000.00 1,000,000.00 998,228.00 2.000 9/24/2018 1728 1.12 Bond FHLMC 0.375 3134G3S87 FHLMC 3/27/2012 1,000,000.00 999,703.99 1,000,789.00 0.467 4/28/2014 118 1.12 4/28/2014 Bond FHLMC 0.35 3134G4QK7 FHLMC 12/31/2013 1,000,000.00 999,625.00 997,800.00 0.369 12/31/2015 730 1.12 12/31/2015-14 Bond FNMA 0.35 3135G0UW 1 FNMA Bond 7/25/2013 509,000.00 508,447.71 508,768.40 0.416 8/25/2015 602 0.57 8/25/2015 Sub Total / Average 19,923,577.56 19,922,436.04 19,915,071.46 0.380 288 22.29 17: Municipal Court Security Wells Fargo Sweep WFSWEEP Cash 5/31/2006 126,393.89 126,393.89 126,393.89 0.140 N/A 1 0.14 Cash Sub Total / Average 126,393.89 126,393.89 126,393.89 0.140 1 0.14 18: City Wide Donation Wells Fargo Sweep WFSWEEP Cash 5/31/2006 93,519.28 93,519.28 93,519.28 0.140 N/A 1 0.10 Cash Sub Total / Average 93,519.28 93,519.28 93,519.28 0.140 1 0.10 19: Court Technology Wells Fargo Sweep WFSWEEP Cash 5/31/2006 261,742.55 261,742.55 261,742.55 0.140 N/A 1 0.29 Cash Sub Total / Average 261,742.55 261,742.55 261,742.55 0.140 1 0.29 20: Debt Services Wells Fargo Sweep WFSWEEP Cash 5/31/2006 9,751,887.92 9,751,887.92 9,751,887.92 0.140 N/A 1 10.91 Cash 2ofI0 Description CUSIP/Ticker Security Settlement Face Type Date Amount/Shares YTM 0 Maturity Days To % of Book Value Market Value Cost Date Maturity Portfolio Key Bank Ohkr 0.35 8/27/2014 Mechanks Savings Bank 0.35 3/20/2015 FFCB 0.25 12/24/2014 FHLMC 1.85 12/27/2018-14 CD493065RE8 CD5B3686BC3 3133ECAV6 3134G4QV3 Certificate Of Deposit Certificate Of Deposit 2/27/2013 3/20/2013 FFCB Bond 1/28/2013 12/27/2013 FHLMC Bond 248,000.00 248,000.00 1,000,000.00 1,000,000.00 248,000.00 248,000.00 999,773.59 1,000,000.00 248,068.20 0.350 8/27/2014 239 0.28 247,633.21 0.350 3/20/2015 444 0.28 1,000,609.00 0.273 12/24/2014 358 1.12 992,872.00 1.850 12/27/2018 1822 1.12 Sub Total / Average 23: Court Juvenile Mgmt Wells Fargo Sweep Cash WFSWEEP Cash 9/15/2009 12,247,887.92 12,247,661.51 12,241,070.33 0.299 61,558.83 61,558.83 61,558.33 0.140 N/A 193 13.71 1 0.07 Sub Total / Average 61,558.83 30: Water & Sewer Wehs Fargo Sweep Cash Goldman Sachs Bank 0.6 2/20/2015 SAFRA NATIONAL BANK 0.6 5/5/2014 Bay Cities Bank 0.5 12/12/2014 CDARS 0.5 6/19/2014 Fox Chase Bank 0.65 6/27/2016 First Farmers Bank 0.5 5/3/2016 FAMC 1.72 10/3/2018 FHLB 1.15 10/30/2014 FHLB 1.75 12/14/2018 WFSWEEP CD38147JAA0 CD786580750 CD07203QBR2 CD10139818568 CD35137QAN4 CD320165FZ1 31315P5A3 3133743W8 3133768RS Cash Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit 5/31/2006 2/20/2013 8/1/2012 12/12/2012 6/20/2013 6/27/2013 5/3/2013 FAMC Bond 12/16/2013 FHLB Bond 11/29/2012 FHLB Bond 12/16/2013 11,444,753.70 248,000.00 248,000.00 248,000.00 500,000.00 248,000.00 245,000.00 1,000,000.00 1,000,000.00 1,000,000.00 3 of 10 61,558.83 61,558.83 0.140 11,444,753.70 11,444,753.70 0.140 N/A 248,000.00 247,645.86 0.600 2/20/2015 248,000.00 248,370.02 0.600 5/5/2014 248,000.00 248,644.80 0.500 12/12/2014 500,000.00 500,000.00 0.500 6/19/2014 248,000.00 246448.18 0.650 6/27/2016 245,000.00 243,731.64 0.500 5/3/2016 997,908.33 1,007,031.48 1,008,023.00 0.300 10/30/2014 1,000,664.41 1 0.07 1 12.81 416 0.28 125 0.28 346 0.28 170 0.56 909 0.28 854 0.27 989,706.00 1.766 10/3/2018 1737 1.12 303 1.13 992,108.00 1.736 12/14/2018 1809 1.12 Security Settlement Face YTM 0 Maturity Days To % of Description CUSIP/Tidcer Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio FHLMC 0.5 8/28/2015-14 FNMA 1.3 11/17/2014 3134G4FP8 Bor LMC 8/28/2013 1,000,000.00 1,000,000.00 1,000,510.00 0.500 8/28/2015 605 1.12 3136FPWZ6 FNMA Bond 6/20/2012 1,000,000.00 1,007,307.73 1,009,739.00 0.462 11/17/2014 321 1.13 Sub Total / Average 31: Solldwaste 18,181,753.70 18,194,665.65 18479,380.20 0.403 304 20.36 Wells Fargo Sweep Cash WFSWEEP Cash 12/1/2006 552,949.80 552,949.80 552,949.80 0.140 N/A 1 0.62 Sub Total / Average 35: Street Assessment We Fargo Sweep Cash United Bankers Bank 0.75 5/6/2016 WFSWEEP Cash 909557CV0 Certificate Of Deposit 552,949.80 552,949.80 552,949.80 0.140 1 0.62 5/31/2006 404,269.02 404,269.02 404,269.02 0.140 N/A 1 0.45 11/6/2013 248,000.00 248,000.00 247,206.40 0.750 5/6/2016 857 0.28 Sub Total / Average 652,269.02 42: Utility Impact Fee WePs Fargo Sweep Cash Hardin County Bank 0.25 12/30/2014 652,269.02 651,475.42 0.372 326 0.73 WFSWEEP Cash 5/31/2006 2,632,377.75 2,632,377.75 2,632,377.75 0.140 N/A 1 2.95 411822BG3 Certificate 12/30/2013 248,000.00 248,000.00 247,248.81 0.250 12/30/2014 364 0.28 Of Deposit Private Bank &Trust CD74267G1C1 Certificate 5/10/2013 248,000.00 248,000.00 247,497.55 0.350 5/11/2015 496 0.28 0.35 5/11/2015 Of Deposit Sterling Savings Bank C08595316A8 Certificate 2/22/2013 248,000.00 248,000.00 247,805.82 0.350 2/23/2015 419 0.28 0.35 2/23/2015 Of Deposit College Savings Bank 0.55 6/20/2016 CD19443PAP4 Certificate 6/19/2013 248,000.00 248,000.00 246,211.18 0.550 6/20/2016 902 0.28 Of Deposit The Independent Bank CD88632YAG1 Certificate 9/18/2013 248,000.00 248,000.00 247,572.94 1.100 9/16/2016 990 0.28 1.1 9/16/2016 Of Deposit BMW Bank of NA 0.85 6/8/2015 FFCB 0.3 1/9/2015-13 CD05568P2Q9 Certificate 12/7/2012 248,000.00 248,000.00 248,815.18 0.850 6/8/2015 524 0.28 Of Deposit 3133EA3U0 FFCB Bond 11/29/2012 1,000,000.00 1,000,000.00 1,000,015.00 0.300 1/9/2015 374 1.12 4of10 Description CUSIP/Tkker Security Settlement Face Type Date Amount/Shares YTM ® Maturity Days To % of Book Value Maricet Value Cost Date Maturity Portfolio FHLMC 2.25 9/26/2018-14 3134G4GE2 FHLMC Bond 9/26/2013 1,000,000.00 998,579.17 1,002,694.00 2.282 9/26/2018 1730 1.12 Sub Total / Average 44: Shadow Creek Impart Wells Fargo Sweep Cash Marfm Business Bank 0.55 6/14/2016 Bank of Buffalo KY 0.35 6/22/2015 6,120,377.75 6,118,956.92 6,120,238.2.3 0.621 494 6.85 WFSWEEP CD57116AGF9 060788AF3 Cash Certificate Of Deposit Certificate Of Deposit 5/31/2006 6/14/2013 12/20/2013 1,789,149.77 248,000.00 248,000.00 1,789,149.77 1,789,149.77 0.140 N/A 248,000.00 246,257.06 0.550 6/14/2016 248,000.00 247,049.17 0.350 6/22/2015 1 2.00 896 0.28 538 0.28 Sub Total / Average 45: Hotel/Motel Oonrpancy Wells Fargo Sweep Cash First Natial Bank WI 0.25 1/31/2014 First Commercial Bank Miss 0.4 6/26/2015 Cobnial Virginia Bank 0.55 6/24/2016 WFSWEEP CD321086FE5 31984GCW7 CD196121AM9 2,285,149.77 2,285,149.77 2,282,456.00 0.207 Cash Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit 5/31/2006 1/31/2013 12/27/2013 6/25/2013 1,443,195.82 1,443,195.82 1,443,195.82 0.140 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 248,000.00 156 2.56 N/A 247,957.59 0.250 1/31/2014 247,030.32 0.400 6/26/2015 246,170.50 0.550 6/24/2016 1 1.61 31 0.28 542 0.28 906 0.28 Sub Total / Average 46: Paris Donations Wells Fargo Sweep Cash WFSWEEP Cash 2,187,195.82 2,187,195.82 2,184,354.23 0.228 5/31/2006 113,034.08 113,034.08 113,034.08 0.140 N/A 168 2.45 1 0.13 Sub Total / Average 47: Park & Rec Development Wells Fargo Sweep Cash WFSWEEP Fust State Bank - Un Cty Tenn 0.45 336472E30 12/23/2015 Cash 113,034.08 113,034.08 113,034.08 0.140 5/31/2006 585,204.74 585,204.74 585,204.74 0.140 N/A 248,000.00 248,000.00 247,029.33 0.450 12/23/2015 833,204.74 833,204.74 832,234.07 0.232 Certificate 12/23/2013 Of Deposit Sub Total / Average 5 of 10 1. 0.13 1 0.65 722 0.28 216 0.93 Security Settlement Face YTM 0 Maturity Days To % of Description CUSIP/Tidrer Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio 49: Tree Trust Fund WeRs Fargo Sweep WFSWEEP Cash 5/31/2006 73,596.48 73,596.48 Cash 73,596.48 0.140 N/A 1 0.08 Sub Total / Average 50: Capital Projects Wells Fargo Sweep Cash 73,596.48 73,596.48 73,596.48 0.140 1 0.08 WFSWEEP Cash 5/31/2006 2,043,141.91 2,043,141.91 2,043,141.91 0.140 N/A 1 2.29 Sub Total / Average 55: Sidewalk Fund Wells Fargo Sweep Cash WFSWEEP 2,043,141.91 2,043,141.91 2,043,141.91 0.140 1 2.29 Cash 5/31/2006 225,878.83 225,878.83 225,878.83 0.140 N/A 1 0,25 Sub Total / Average 60: Police State Seizure Weis Fargo Sweep Cash WFSWEEP Cash 225,878.83 225,878.83 225,878.83 0.140 1 0.25 5/31/2006 195,815.11 195,815.11 195,815.11 0.140 N/A 1 0.22 Sub Total / Average 62: Federal Police Fund Weis Fargo Sweep Cash WFSWEEP Cash 195,815.11 195,815.11 195,815.11 0.140 5/31/2006 49,525.25 49,525.25 1 0.22 49,525.25 0.140 N/A 1 0.06 Sub Total / Average 64: 1998 Cert of Obligation Wells Fargo Sweep Cash US Amerlaank Largo FL 0.55 12/23/2015 WFSWEEP Cash 917312CC2 Certificate OF Deposit 49,525.25 49,525.25 49,525.25 0.140 5/31/2006 514,457.72 514,457.72 12/23/2013 248,000.00 1 0.06 514,457.72 0.140 N/A 1 0.58 248,000.00 247,078.43 0.550 12/23/2015 722 0.28 Sub Total / Average 67: 2003 Revenue Bonds Weis Fargo Sweep Cash WFSWEEP Cash 762,457.72 762,457.72 761,536.15 0.273 236 0.85 5/31/2006 2,249,946.30 2,249,946.30 2,249,946.30 0.140 N/A 1 2.52 6of10 Description Asheville Savings Bank 0.35 3/27/2015 Medallion Bank UT 0.4 11/3/2015 CIT Bank 1.5 9/5/2017 First National Bank ORD NEB 0.8 11/18/2016 FFCB 2.125 2/10/2014 FHLMC 0.35 12/5/2014 CUSIP/Tldcer CD04407RAJ0 C0584036862 CD17284CMN1 32116RACB 31331JDY6 3134G3H78 Security Settlement Face Type Date Amount/Shares YTM 0 Maturity Days To °Yb of Book Value Market Value Cost Date Maturity Portfolio Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit FHLMC Bond 2/28/2013 248,000.00 248,000.00 5/3/2013 248,000.00 248,000.00 9/4/2013 248,000.00 248,000.00 11/18/2013 248,000.00 248,000.00 FFCB Bond 11/29/2012 1,500,000.00 1,503,073.18 9/27/2012 1,000,000.00 1,000,184.80 247,599.98 0.350 3/27/2015 451 0.28 247,434.81 0.400 11/3/2015 672 0.28 247,817.47 1.500 9/5/2017 1344 0.28 247,126.79 0.800 11/18/2016 1,503,076.50 0.230 2/10/2014 1,001,558.00 0.330 12/5/2014 Sub Total / Average 68: 2001 Cert of Obligation Weds Fargo Sweep Cash WFSWEEP Cash 5,741,946.30 5,745,204.28 5,744,559.85 0.304 5/31/2006 171,166.78 171,166.78 1053 0.28 41 1.68 339 1.12 222 6.43 171,166.78 0.140 N/A 1 0.19 Sub Total / Average 70: 2005 Refunding / Mobility Weds Fargo Sweep Cash First State Bank - WV 0.35 12/3/2014 WFSWEEP CD33648FHR9 Cash Certificate Of Deposit 5/31/2006 12/3/2012 171,166.78 171,166.78 171,166.78 0.140 512,275.53 512,275.53 248,000.00 248,000.00 1 0.19 512,275.53 0.140 N/A 1 0.57 248,649.51 0.350 12/3/2014 337 0.28 Sub Total / Average 95: Property Liability Weds Fargo Sweep Cash WFSWEEP Cash 10/31/2006 760,275.53 -383,916.76 760,275.53 760,925.04 0.209 -383,916.76 -383,916.76 0.140 111 0.85 N/A 1 -0.43 Sub Total / Average 97: Employee Benefit Trust Weds Fargo Sweep Cash WFSWEEP Cash 9/1/2007 -383,916.76 -383,916.76 -383,916.76 0.140 30,977.91 30,977.91 1 -0.43 30,977.91 0.140 N/A 1 0.03 Sub Total / Average 30,977.91 30,977.91 7of10 30,977.91 0.140 1 0.03 Security Settlement Face YTM U Maturity Days To % of Description CUSIP/Tidcer Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio 99: COP Health Claims Fund Wens Fargo Sweep Cash WFSWEEP Cash Wells Fargo Cash WF9871 Cash 9/15/2010 107,924.67 107,924.67 107,924.67 0.140 N/A 1 0.12 7/21/2010 259,447.79 259,447.79 259,447.79 0.140 N/A 1 0.29 Sub Total / Average Z101: Grant Fund Wells Fargo Sweep Cash 367,372.46 367,372.46 367,372.46 0.140 1 0.41 WFSWEEP Cash 5/31/2006 -29,707.66 -29,707.66 -29,707.66 0.140 N/A 1 -0.03 Sub Total / Average Z109: 2011 CDBG Fund Wells Fargo Sweep Cash -29,707.66 -29,707.66 -29,707.66 0.140 1 -0.03 WFSWEEP Cash 12/1/2011 -161.41 -161.41 -161.41 0.140 N/A 1 0.00 Sub Total / Average -161.41 -161.41 -161.41 0.140 1 0.00 Z110: 2012 CDBG Fund We Fargo Sweep Cash WFSWEEP Cash 11/15/2012 204.55 204.55 204.55 0.140 N/A 1 0.00 Sub Total / Average 204.55 Z140: U of H Fund Wets Fargo Sweep Cash WFSWEEP Cash 204.55 204.55 0.140 1 0.00 12/1/2009 35,825.26 35,825.26 35,825.26 0.140 N/A 1 0.04 Sub Total / Average 35,825.26 Z141: U of H Capital Renewal Fund Wei Fargo Sweep Cash WFSWEEP Cash 35,825.26 35,825.26 0.140 1 0.04 9/30/2013 239,863.05 239,863.05 239,863.05 0.140 N/A 1 0.27 Sub Total / Average 239,863.05 Z145: Munidpal Channel We Fargo Sweep Cash WFSWEEP Cash 239,863.05 239,863.05 0.140 1 0.27 4/15/2012 242,678.07 242,678.07 242,678.07 0.140 N/A 1 0.27 8of10 Security Settlement Face YTM 0 Maturity Days To % of Desaiption CUSIP/Tidter Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Sub Total / Average 2200: 2006 Cert of Obligation Welts Fargo Sweep Cash WFSWEEP Cash 242,678.07 242,678.07 242,678.07 0.140 1 0.27 6/30/2006 2,000,511.17 2,000,511.17 2,000,511.17 0.140 N/A 1 2.24 Sub Total / Average Z201: 2007 Cert of Obligation Welk Fargo Sweep Cash WFSWEEP Cash 2,000,511.17 2,000,511.17 2,000,511.17 0.140 1 2.24 8/31/2006 64,449.49 64,449.49 64,449.49 0.140 N/A 1 0.07 Sub Total / Average Z202: 2007A Gen Obligation Welk Fargo Sweep Cash Celtic Bank 0.6 6/28/2016 64,449.49 64,449.49 64,449.49 0.140 1 0.07 WFSWEEP Cash 12/31/2007 2,121,631.53 2,121,631.53 2,121,631.53 0.140 N/A 1 2.37 CD15118FUD0 Certificate 6/28/2013 248,000.00 248,000.00 246,203.74 0.600 6/28/2016 910 0.28 Of Deposit Sub Total / Average 2,369,631.53 2,369,631.53 2,367,835.27 0.188 96 2.65 Z203: 2009 Gen Obligation We Fargo Sweep WFSWEEP Cash 10/30/2008 6,662,131.27 6,662,131.27 6,662,131.27 0.140 N/A 1 7.45 Cash Kansas State Bank 485382DV4 Certificate 10/30/2013 248,000.00 248,000.00 247,309.32 0.800 10/31/2016 1035 0.28 0.8 10/31/2016 Of Deposit Cathay Bank 0.75 CD1491593E6 Certificate 9/20/2013 248,000.00 248,000.00 247,576.17 0.750 3/21/2016 811 0.28 3/21/2016 Of Deposit Sub Total / Average 7,158,131.27 7,158,131.27 7,157,016.76 0.184 65 8.01 Z301: W/S Pay As U Go CIP We Fargo Sweep WFSWEEP Cash 12/31/2007 2,139,957.22 2,139,957.22 2,139,957.22 0.140 N/A 1 2.39 Cash DeWitt Bank and Trust CD2418888T2 Certificate 6/24/2013 248,000.00 248,000.00 246,264.99 0.500 6/20/2016 902 0.28 0.5 6/20/2016 Of Deposit Sub Total / Average 2,387,957.22 2,387,957.22 2,386,222.21 0.177 95 2.67 Z302: MUD 4 Capital Programs 9of10 Security Settlement Fa CS YTM @ Maturity Days To % of Description CUSIP/Tidcer Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Wells Fargo Sweep WFSWEEP Cash 2/1/2013 707,114.83 707,114.83 707,114.83 0.140 N/A 1 0.79 Cash Farm Bureau Bank 0.5 307660HH6 Certificate 12/23/2013 248,000.00 248,000.00 247,078.18 0.500 12/23/2015 722 0.28 12/23/2015 Of Deposit Pacific City Bank 0.35 Certificate 69406P8J7 Of Deposit 12/26/2013 248,000.00 248,000.00 246,994.86 0.350 6/26/2015 542 0.28 6/26/2015 Sub Total / Average 1,203,114.83 1,203,114.83 1,201,187.87 0.257 261 1.35 Total / Average 89,351,349.60 89,364,730.77 89,321,982.01 0.328 230 100 10 of 10 City of Pearland Purchases Portfolio/Report Group: Report Group: Peariand From 9/30/2013 To 12/31/2013 YT31 Po tlobo Settlement Maturity Face Name Desaiptlon Bullet/Callable CUSIP/Ticker Action Date Date Price Amount/Shares Cost Principal Interest/Dividends Broker/Dealer 10: General Tent Atlantic Wells Fargo Bank 1.45 89835FJC5 Buy 11/6/2013 12/6/2017 100 248,000.00 1.450 248,000.00 0.00 Fund 12/6/2017 Bank 10: General 1st tinted Bank Wells Fargo FL 0.7 33741TAU5 Buy 11/8/2013 5/9/2016 100 248,000.00 0.700 246,000.00 0.00 Fund 5/9/2016 Bank 10: General CDARS 0.5 1016130741 Buy 12/19/2013 12/18/2014 100 500,000.00 0.500 500,000.00 0.00 Independence Fund 12/18/2014 Bank 10: General Moody National Moody National Bank 0.5 CD7130A Buy 11/30/2013 5/30/2014 100 246,807.96 0.500 246,807.96 0.00 Fund 5/30/2014 Bank 10: General FHLMC 0.35 Word Fund 12/31/2015-14 Yes 3134G4QK7 Buy 12/31/2013 12/31/2015 99.9625 1,000,000.00 0.369 999,625.00 0.00 Securties 20: Debt FHLM1.85 Yes 3134G4QV3 Buy 12/27/2013 12/27/2018 100 1,000 000.00 1.850 1,000,000.00 0.00 Word 12/27/2018-14 Securities 30: Water & FAMC 1.72 CastleOak Sewer 10/3/2018 31315P5A3 Buy 12/16/2013 10/3/2018 99.789 1,000,000.00 1.766 997,890.00 3,487.78 Securitles 30: Water B FHLB 1.75 CastleOak Sewer 12/14/2018 313376BR5 Buy 12/16/2013 12/14/2018 100.067 1,000,000.00 1.736 1,000,670.00 97.22 Securties tinted Bankers 35: Street Bank 0.75 909557CV0 Buy 11/6/2013 5/6/2016 100 248 000.00 0.750 248,000.00 0.00 Wells Fargo Assessment 5/6/2016 Bank Hardin County 42: Utility Bank 0.25 411822BG3 Buy 12/30/2013 12/30/2014 100 248,000.00 0.250 248,000.00 0.00 wells Fargo Impact Fee 12/30/2014 Bank 44: Shadow Bank of Buffalo Wells Fargo Creek KY 0.35 060788AF3 Buy 12/20/2013 6/22/2015 100 248,000.00 0.350 248,000.00 0.00 Bank Impact 6/22/2015 45: First HoteVMotel Commercial 31984GCW7 Buy 12/27/2013 6/26/2015 100 248,000.00 0.400 248,000.00 0.00 wells Fargo Occupancy Miss 0.4 Bank 6/26/2015 47: Park fi First State Bank Rec Un Cty Tenn 336472©0 Buy 12/23/2013 12/23/2015 100 248,000.00 0.450 248,000.00 0.000.wells Fargo Development 12/23/2015 Bank 1 oft YTM Portfolio Settlement Maturity Face 0 Name Description Bullet/Callable CUSIP/Ticker Adson Date Date Price Amount/Shares Cost Principal Interest/Dividends Broker/Dealer 64: 1998 US AmerlBank Wells Fargo Cert of Largo FL 0.55 917312CC2 Buy 12/23/2013 12/23/2015 100 248,000.00 0.550 248,000.00 0.00 Bank Obligation 12/23/2015 67: 2003 First National Revenue Bank ORD NEB 32116RAC8 Buy 11/18/2013 11/18/2016 100 248,000.00 0.800 248,000.00 0.00 Wells Fargo 0.8 Bank Bonds 11/18/2016 2203: 2009 Kansas State Gen Bank 0.8 485382DV4 Buy 10/30/2013 10/31/2016 100 248,000.00 0.800 248,000.00 0.00 Bank Fargo Obligation 10/31/2016 2302: MUD Farm Bureau Wets Fargo 4 Capital Bank 0.5 307660HH6 Buy 12/23/2013 12/23/2015 100 248,000.00 0.500 248,000.00 0.00 Bank Programs 12/23/2015 Z302: MUD Pacific City Bank 4 Capital 0.35 69406P837 Buy 12/26/2013 6/26/2015 100 248,000.00 0.350 248,000.00 0.00 BWaells Fargo Programs 6/26/2015 2 oft Bank Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Pledged Collateral Reconciliation Report December 31, 2013 Account Number 201-0419505 201-0419513 001-3042841 179-0121790 807-1613395 818-4567843 280-7409871 Bank Account Number Wells Fargo 100-7284258 Bank Regions Account Number 6180003939 6180003948 I:11nvestmentsllmesUnent ReportslCity of PeartarxlVnvestmenl Report - City • Qtr 1213 Account Name Operating Payroll Fund Sweep Account EMS Payments Credit Gard Account Alvin ISD Health Claims Total of Bank Balances Pledged Collateral for City FDIC Insurance Total Collateral Over (Under) Collateralized Total % Collateralized Account Name Development Authority Total of Bank Balances Pledged Collateral for DAP FDIC Insurance Total Collateral Over (Under) Collateralized Total % Collateralized Total of Bank Balances Regions Trust Collateral FDIC Insurance Amount $ 65,707,889.74 4,255,688.68 259,447.79 $ 70,223,026.21 79,321,718.32 250,000.00 $ 79,571,718.32 $ 9,348,692.11 113.3% Amount 1,014,217.71 $ 1,014,217.71 1,113,813.39 250,000.00 $ 1,363,813.39 $ 349,595.88 134.5% $ 4,300.13 543,049.06 $ 547,349.19 $ 312,218.65 250,000.00 Over (Under) Collateralized' $ Total % Collateralized Total $ Over (Under) Collateralized $ Total % Collateralized Status 14,867.46 102.7% 9,698,287.79 113.1% Collateralized