Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R-2014-142 2014-11-24
RESOLUTION NO. R2014-142 A Resolution of the City Council of the City of Pearland, Texas, accepting the City's Investment Report for the quarter ending September 2014. 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 2014. PASSED, APPROVED, AND ADOPTED this 24th day of November, A.D., 2014. ATTEST: APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY TOM REID MAYOR City of Pearland Quarterly Investment Report June 30, 2014 - September 30, 2014 Resolution No. R2014-142 Exhibit "A" Portfolio at June 30, 2014 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 $ 85,261,338.95 85,319,403.10 50,232.95 240,985.21 58,064.15 64,320.70 377 Days (8,913,979.06) 0.48% 0.11% 0.14% Portfolio at September 30, 2014 Ending Book Value Ending Market Value Accrued Interest Receivable FYD Total Interest Earned Unrealized Gain/(Loss) Change in Unrealized Gain/Loss Weighted Average Maturity Change in Market Value Yield to Maturity at Cost T -Bill Benchmark Agency Note Benchmark Average for Quarter City's Yield to Maturity 1 Year T -Bill Benchmark Yield Agency Note Benchmark Yield 0.52% 0.11% 0.15% $ 84,725,083.05 84,706,693.56 84,636.52 346,211.11 (18,389.49) (76,453.64) 344 Days (612,709.54) 0.48% 0.13% 0.16% 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 4 Rick Iergaar Fatima Uwakwe Assistant Director of Finance Accounting Supervisor Summary by Type September 30, 2014 Description Face Amount \ Shares Cost Value Book Value Market Value YTM @ Cost Days To Maturity Cash $ 48,848,887.51 $ 48,848,887.51 $ 48,848,887.51 $ 48,848,887.51 0.14% 1 CD 16,376,420.54 16,376,420.54 16,376,420.54 16,372,488.01 0.75% 623 FAMC 1,000,000.00 997,890.00 998,236.98 1,002,903.00 1.77% 1,464 FFCB 4,000,000.00 4,018,330.00 4,015,898.40 4,014,917.00 1.16% 1,075 FHLB 3,000,000.00 3,016,920.00 3,001,269.67 3,002,786.00 1.05% 832 FHLMC 6,000,000.00 5,994,211.00 5,995,019.65 5,997,927.00 1.04% 884 FNMA 5,509,000.00 5,505,536.88 5,489,350.30 5,466,785.04 1.01% 973 Total/Average $ 84,734,308.05 $ 84,758,195.93 $ 84,725,083.05 $ 84,706,693.56 0.48% 344 FHLB 4% FFCB 5% FAMC 1% Group Portfolio Holdings by Type FHLMC 7% FNMA 6% 19% Cash 58% 60,000,000 50,000,000 40,000,000 30,000,000 •— 20,000,000 10,000,000 -- <1 Year Book Value by Maturity 1- 2 Year 2 - 3 Year 3-4Year 4 - 5 Year Interest Rates Date 1 mo 3 mo 6 mo 1 yr 2 yr 3 yr 5 Vr 7 yr 10 yr 20 yr 30 yr 06/30/2014 0.02 0.04 0.07 0.11 0.47 0.88 1.62 2.13 2.53 3.08 3.34 09/30/2014 0.02 0.02 0.03 0.13 0.58 1.07 1.78 2.22 2.52 2.98 3.21 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 Yield Curve Comparison CIty Weighted Avg Yield .5211- 344 Day Average Ntaturity 0.60% 0.S0% 0.40% 0.30% 0.20% 0.10% 0.00% 1 mo 3 mo 6 mo 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr 20 yr 30 yr ....4-..06/30/2014 - -09/30/2014 Portfolio vs. Benchmarks 4 Oct -13 Nov -13 Dec -13 Jan -14 Feb -14 Mar -14 Apr -14 May -14 Jun -14 Jul -14 Aug -14 Sep -14 .-0-Port Total -77-1 Yr T -Bill Agency Note City of Pearland Quarterly Investment Report Report Format: By CUSIP Group By: Security Type PortfoNo/Report Group: Report Group: Pearland Begin Date: 6/30/2014, End Date: 9/30/2014 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 Sweep Cash Wells Fargo Sweep Cash Wells Fargo Sweep Cash Weis Fargo Sweep Cash Weis 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 WFSWEEP WFSWEEP WFSWEEP WFSWEEP WFSWEEP WFSWEEP WFSWEEP W FSW EEP WFSWEEP WFSWEEP WFSWEEP WFSWEEP WFSWEEP 10: General 0.140 Fund 17: Municipal Court Security 18: City Wide Donation 19: Court Technology 20: Debt Services 0.140 0.140 0.140 0.140 23: Court Juvenile 0.140 Mgmt 30: Water& Sewer 31: Solidwaste 35: Street Assessment 42: Utility Impact Fee 44: Shadow Creek Impact 0.140 0.140 0.140 0.140 0.140 45: Hotel/Motel 0.140 Occupancy 46: Park Donations 0.140 N/A 10,305,726.92 764,657.11 671,612.77 0.00 0.00 10,398,771.26 3,815.27 N/A 120,688.26 45.01 1,161.94 0.00 0.00 119,571.33 45.01 N/A 58,870.28 911.15 10,114.85 0.00 0.00 49,666.58 18.91 N/A 47,051.42 8,976.24 7,594.83 0.00 0.00 48,432.83 19.74 N/A 7,267,806.04 314,780.49 5,943,759.40 0.00 0.00 1,638,827.13 1,270.01 N/A 56,885.92 20.88 1,793.81 0.00 0.00 55,112.99 20.88 N/A 9,403,874.63 1,103,790.38 3,707,959.67 0.00 0.00 6,799,705.34 2,677.70 N/A 446,032.93 939,796.60 514,832.49 0.00 0.00 870,997.04 240.57 N/A 426,336.92 224.19 250,345.40 0.00 0.00 176,215.71 66.22 N/A 3,959,306.04 4,391,186.48 0.00 0.00 0.00 8,350,492.52 2,618.09 N/A 1,192,099.92 171,695.89 1,911,172.64 0.00 0.00 -547,376.83 150.70 N/A 942,984.26 50,981.95 114,676.46 0.00 0.00 879,289.75 341.07 N/A 117,911.69 39.10 18,619.37 0.00 0.00 99,331.42 39.10 1 of 11 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 47: Park & Wells Fargo WFSWEEP Rec 0.140 N/A 781,067.53 68,642.07 324,215.23 0.00 0.00 525,494.37 202.51 Sweep Cash Development Wells Fargo WFSWEEP 49: Tree 0.140 N/A 69,282.43 25.94 0.00 0.00 0.00 69,308.37 25.94 Sweep Cash Trust Fund Wells Fargo WFSWEEP 50: Capital 0.140 N/A 2,064,667.46 571.41 821,896.64 0.00 0.00 1,243,342.23 571.41 Sweep Cash Projects Wells Fargo WFSWEEP 55: Sidewalk 0.140 N/A 259,445.62 95.33 16,542.00 0.00 0.00 242,998.95 95.33 Sweep Cash Fund 60: Police Wells Fargo WFSWEEP State 0.140 N/A 166,296.89 3,171.09 11,856.69 0.00 0.00 157,611.29 60.06 Sweep Cash Seizure Wells Fargo WFSWEEP 62: Federal 0.140 N/A 58,599.24 16,399.99 31,841.74 0.00 0.00 43,157.49 23.14 Sweep Cash Police Fund Wells Fargo 64: 1998 Sweep Cash WFSWEEP Cert of 0.140 N/A 455,835.63 384.29 155,954.90 0.00 0.00 300,265.02 156.33 Obligation Wells Fargo 67: 2003 Sweep Cash WFSWEEP Revenue 0.140 N/A 940,102.63 167.28 912,234.26 0.00 0.00 28,035.65 167.28 Bonds Welts Fargo 68: 2001 Sweep Cash WFSWEEP Cert of 0.140 N/A -330,587.00 66,100.00 514,209.12 0.00 0.00 -778,696.12 0.00 Obligation Wells Fargo 70: 2005 Sweep Cash WFSWEEP Refunding / 0.140 N/A 82,278.73 83.02 196,154.52 0.00 0.00 -113,792.77 9.30 Mobility Wells Fargo WFSWEEP 95: Property 0.140 N/A -10,144.77 182,909.15 37,965.71 0.00 0.00 134,798.67 40.50 Sweep Cash Liability Wells Fargo 97: Sweep Cash WFSWEEP Employee 0.140 N/A 84,039.57 44,094.33 44,636.75 0.00 0.00 83,497.15 35.00 Benefit Trust Wells Fargo 99: COP Cash WF9871 Health 0.140 N/A 223,302.01 157,355.53 0.00 0.00 0.00 380,657.54 104.23 Claims Fund Wells Fargo 99: COP Sweep Cash WFSWEEP Health 0.140 N/A -326,633.14 1,134,469.60 327,117.80 0.00 0.00 480,718.66 0.00 Claims Fund WeNs Fargo WFSWEEP Z101: Grant N/A -39,536.82 46,026.59 6,489.77 0.00 0.00 0.00 0.00 Sweep Cash Fund 2 of 11 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 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 WFSWEEP WFSWEEP WFSWEEP WFSWEEP Z109: 2011 CDBG Fund Z110: 2012 CDBG Fund Z140: U of H Fund Z141:UofH Capital Renewal Fund Z145: WFSWEEP Municipal Channel Z200: 2006 WFSWEEP Cert of Obligation Z201: 2007 WFSWEEP Cert of Obligation Z202: WFSWEEP 2007A Gen Obligation Z203: 2009 WFSWEEP Gen Obligation Z301: W/S WFSWEEP Pay As U Go CIP Z302: MUD WFSWEEP 4 Capital Programs N/A -161.41 161.41 0.00 0.00 0.00 0.00 0.00 N/A 204.55 0.00 204.55 0.00 0.00 0.00 0.00 N/A -45,710.74 45,710.74 0.00 0.00 0.00 0.00 0.00 0.140 N/A 240,037.85 89.90 0.00 0.00 0.00 240,127.75 89.90 0.140 N/A 354,772.22 96,349.62 3,483.41 0.00 0.00 447,638.43 156.31 0.140 N/A 1,887,367.38 1,086,301.33 1,152,409.00 0.00 0.00 1,821,259.71 564.31 Sub Total/Average Cash CERTIFICATE OF DEPOSIT CDARS 0.5 12/18/2014 CDARS 0.9 6/16/2016 1016130741 1016754591 10: General Fund 10: General Fund 0.140 N/A 57,478.97 13.43 28,723.74 0.00 0.00 28,768.66 13.43 0.140 N/A 933,281.41 189,981.62 516,434.10 0.00 0.00 606,828.93 205.32 0.140 N/A 2,888,842.49 11,313,938.70 2,573,404.16 0.00 0.00 11,629,377.03 1,519.70 0.140 N/A 2,061,858.47 674.97 359,296.06 0.00 0.00 1,703,237.38 674.97 0.140 N/A 645,845.54 413.20 11,042.69 0.00 0.00 635,216.05 239.94 0.140 47,847,407.97 22,201,236.01 21,199,756.47 0.00 0.00 48,848,887.51 16,278.18 0.500 12/18/2014 500,000.00 0.00 0.00 0.00 0.00 500,000.00 630.13 0.900 6/16/2016 500,000.00 0.00 0.00 0.00 0.00 500,000.00 1,134.24 3 of 11 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 Community National Bank Interest 1.25 4/4/2018 20375WAM6 10: General 1.250 4/4/2018 248,000.00 Fund Farmers & Merchants Bank 308862DD0 10: General 1.450 9/25/2018 1.45 Fund 9/25/2018-14 248,000.00 FIRST BANK HIGHLAND 319141BLO 10: General 1.850 5/7/2019 248,000.00 PARK 1.85 Fund 5/7/2019-14 1st United Bank 10: General FL0.7 33741TAU5 Fund 0.700 5/9/2016 248,000.00 5/9/2016 Moody National 10: General Bank 0.5 7130 Fund 0.500 11/30/2014 247,420.54 11/30/2014 Synovus Bank 10: General GA 0.5 87164DBV1 Fund 0.500 11/28/2014 248,000.00 11/28/2014 Townebank 10: General Portsmouth VA 89214PAP4 Fund 0.400 6/1/2015 248,000.00 0.4 6/1/2015 Trust Atlantic 10: General Bank 1.45 89835F3C5 Fund 1.450 12/6/2017 248,000.00 12/6/2017 Cardinal Bank 10: General CD14147VDM5 0.500 5/17/2016 248,000.00 0.5 5/17/2016 Fund Discover Bank 10: General CD254671KH2 0.500 2/20/2015 248,000.00 0.5 2/20/2015 Fund First National 10: General Bank 1.6 CD32115CBE7 Fund 1.600 3/19/2018 248,000.00 3/19/2018 Plus International 10: General CD72940UFV2 0.500 7/8/2016 248,000.00 Bank 0.5 Fund 7/8/2016 Southwest 10: General Bank Ft Worth CD844772AA1 Fund 0.300 2/27/2015 248,000.00 0.3 2/27/2015 4 of 11 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 248,000.00 781.37 248,000.00 906.38 0.00 0.00 0.00 0.00 248,000.00 1,156.43 0.00 0.00 0.00 0.00 248,000.00 437.56 0.00 0.00 0.00 0.00 247,420.54 311.82 0.00 0.00 0.00 0.00 248,000.00 312.54 0.00 0.00 0.00 0.00 248,000.00 250.04 0.00 0.00 0.00 0.00 248,000.00 906.38 0.00 0.00 0.00 0.00 248,000.00 312.54 0.00 0.00 0.00 0.00 248,000.00 312.55 0.00 0.00 0.00 0.00 248,000.00 1,000.16 0.00 0.00 0.00 0.00 248,000.00 312.54 0.00 0.00 0.00 0.00 248,000.00 187.53 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 Valley Bank 10: General Roanoke 0.3 CD91935VANO 7/30/2014 248,000.00 0.00 248,000.00 0.00 0.00 0.00 61.15 Fund 7/30/2014 Carolina Alliance 20: Debt Bank 1.05 14376RAK3 1.050 7/31/2017 0.00 248,000.00 0.00 0.00 0.00 248,000.00 442.32 Services 7/31/2017 ConnectOne 20: Debt Bank 1.55 20786AAM7 1.550 7/30/2018 248,000.00 0.00 0.00 0.00 0.00 248,000.00 968.91 Services 7/30/2018 Webster Bank 20: Debt NA 1.9 94768N)M7 1.900 2/12/2019 248,000.00 0.00 0.00 0.00 0.00 248,000.00 1,187.69 Services 2/12/2019 Key Bank Ohio 20: Debt 0.35 CD49306SRE8 8/27/2014 248,000.00 0.00 248,000.00 0.00 0.00 0.00 137.93 Services 8/27/2014 Mechanics Savings Bank CD583686BC3 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 BARCLAYS BANK 06740KGU5 Water& 6740KGU5 1.950 5/7/2019 248,000.00 0.00 0.00 0.00 0.00 248,000.00 1,218.94 DELAWARE Sewer 1.95 5/7/2019 CDARS 0.6 1016754575 30: Water& 0.600 6/18/2015 500,000.00 0.00 0.00 0.00 0.00 500,000.00 756.17 6/18/2015 Sewer Northwest Bank 30: Water & Boise Idaho 1.5 66736AAD1 1.500 1/10/2019 248,000.00 0.00 0.00 0.00 0.00 248,000.00 937.65 Sewer 1/10/2019 OLDTOW N 30: Water & BANK 1.2 680540886 1.200 5/7/2018 248,000.00 0.00 0.00 0.00 0.00 248,000.00 750.12 Sewer 5/7/2018 Bay Cities Bank 30: Water & 0.5 CD07203QBR2 0.500 12/12/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 312.54 Sewer 12/12/2014 First Farmers 30: Water & Bank 0.5 CD320165FZ1 0.500 5/3/2016 245,000.00 0.00 0.00 0.00 0.00 245,000.00 308.76 Sewer 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 Sewer 6/27/2016 5 of 11 s 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 Goldman Sachs Bank 0.6 CD38147JAA0 2/20/2015 Fidelity Homestead Savings Bank 31617CAD5 New Orleans 0.6 11 Town North Bank 0.4 7/24/2015 United Bankers Bank 0.75 5/6/2016 Far East National Bank Los Angeles 1 3/31/2017 Hardin County Bank 0.25 12/30/2014 89213TLD2 909557CV0 307327EK8 411822BG3 JP Morgan Chase Bank Columbus Ohio 48125TJW6 0.85 3/31/2017 - BMW Bank of NA 0.85 6/8/2015 30: Water & Sewer 31: Solidwaste 35: Street Assessment 35: Street Assessment 42: Utility Impact Fee 42: Utility Impact Fee 42: Utility Impact Fee CD05568P2Q9 42: Utility Impact Fee College Savings Bank 0.55 CD19443PAP4 6/20/2016 Private Bank & Trust 0.35 CD74267GTC1 5/11/2015 Sterling Savings Bank 0.35 CD8595316A8 2/23/2015 42: Utility Impact Fee 42: Utility Impact Fee 42: Utility Impact Fee The Independent CD88632YAG1 42: Utility Bank 1.1 Impact Fee 9/16/2016 0.600 2/20/2015 248,000.00 0.600 11/28/2016 248,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 248,000.00 375.06 248,000.00 375.06 0.400 7/24/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 182.09 0.750 5/6/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 468.82 1.000 3/31/2017 248,000.00 0.00 0.00 0.00 0.00 248,000.00 625.10 0.250 12/30/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 156.28 0.850 3/31/2017 248,000.00 0.00 0.00 0.00 0.00 248,000.00 531.33 0.850 6/8/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 531.33 0.550 6/20/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 343.80 0.350 5/11/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 218.79 0.350 2/23/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 218.79 1.100 9/16/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 687.60 6 of 11 9 Ending Portfolio YTM COMaturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Prinapal Sell Principal Discount Premium Ending BV Income -BV Bank of Buffalo 44: Shadow KY 0.35 060788AF3 Creek 0.350 6/22/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 218.79 6/22/2015 Impact GUARANTY B&T 44: Shadow 1.35 400820834 Creek 1.350 5/29/2018 248,000.00 0.00 0.00 0.00 0.00 248,000.00 843.88 5/29/2018 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 Americanwest 45: Bank 0.8 030590DS9 HoteVMotel 0.800 1/25/2017 0.00 248,000.00 0.00 0.00 0.00 248,000.00 364.19 1/25/2017 Occupancy First 45: Commercial 31984GCW7 HoteVMotel 0.400 6/26/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 250.03 Bank Miss 0.4 Occupancy 6/26/2015 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 343.81 6/24/2016 Occupancy First State Bank 47: Park & Un Cty Tenn 336472E30 Rec 0.450 12/23/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 281.29 0.45 Development 12/23/2015 Safra National 47: Park & Bank 0.45 78658QDT7 Rec 0.450 7/30/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 189.57 7/30/2015 Development San Diego Private Bank 50: Capital 79744YAB6 0.800 3/31/2017 248,000.00 0.00 0.00 0.00 0.00 248,000.00 500.07 California 0.8 Projects 3/31/2017 US AmeriBank 64: 1998 Largo FL 0.55 917312CC2 Cert of 0.550 12/23/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 343.81 12/23/2015 Obligation CALUSA 67: 2003 NATIONAL 13151TAX4 Revenue 0.500 9/22/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 312.54 BANK 0.5 Bonds 9/22/2016 First National 67: 2003 Bank ORD NEB 32116RAC8 Revenue 0.800 11/18/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 500.08 0.8 Bonds 11/18/2016 7 of 11 kO 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 Asheville 67: 2003 Savings Bank CD04407RA30 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 CD17284CMN1 Revenue 1.500 9/5/2017 248,000.00 0.00 0.00 0.00 0.00 248,000.00 937.65 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 CD15118RJD0 2007A Gen 0.600 6/28/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 375.06 Obligation Flushing Bank Z203: 2009 New York 0.95 34387AAH2 Gen 0.950 3/31/2017 248,000.00 0.00 0.00 0.00 0.00 248,000.00 593.84 3/31/2017 Obligation Kansas State Z203: 2009 Bank 0.8 485382DV4 Gen 0.800 10/31/2016 248,000.00 0.00 0.00 0.00 0.00 248,000.00 500.07 10/31/2016 Obligation Merchant & Z203: 2009 Manufacturing 588339DD0 Gen 0.350 8/7/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 218.78 Bank 0.35 Obligation 8/7/2015 Provident Bank Z203: 2009 0.35 743837BF2 Gen 0.350 8/21/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 218.78 8/21/2015 Obligation Cathay Bank Z203: 2009 0.75 CD1491593E6 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/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 312.54 6/20/2016 CIP Farm Bureau Z302: MUD Bank 0.5 307660HH6 4 Capital 0.500 12/23/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 312.54 12/23/2015 Programs Pacific City Bank Z302: MUD 0.35 69406PB37 4 Capital 0.350 6/26/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 218.78 6/26/2015 Programs 8 of 11 kt Ending Portfolio YTM 0 Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Prindpal Sell Principal Discount Premium Ending BV Income -BV Sub Tota I/Average Certificate Of Deposit FAMC BOND FAMC 1.72 10/3/2018 31315P5A3 0.752 15,880,420.54 30: Water & 1.766 10/3/2018 Sewer 998,127.02 992,000.00 496,000.00 0.00 0.00 16,376,420.54 30,709.86 0.00 0.00 109.96 0.00 998,236.98 4,409.96 Sub Total/Average FAMC Bond FFCB BOND FFCB 0.3 7/18/2014 FFCB 1.34 12/29/2017 FFCB 0.25 12/24/2014 FFCB 1.95 9/17/2018 FFCB 1.5 1/28/2019 3133EAYL6 3133EDE99 3133ECAV6 3133ED2C5 3133EDNF6 10: General Fund 10: General Fund 20: Debt Services 30: Water & Sewer Z203: 2009 Gen Obligation 1.766 998,127.02 0.00 0.00 109.96 0.00 998,236.98 4,409.96 7/18/2014 1,000,007.47 0.00 1,000,000.00 0.00 -7.47 0.00 142.53 1.235 12/29/2017 1,003,571.63 0.00 0.00 0.00 -255.32 1,003,316.31 3,094.68 0.273 12/24/2014 999,888.40 0.00 0.00 57.72 0.00 999,946.12 682.72 1.617 9/17/2018 1,013,432.91 0.00 0.00 0.00 -796.94 1,012,635.97 4,078.06 1.500 1/28/2019 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 3,750.00 Sub Total/Average 1.158 5,016,900.41 0.00 1,000,000.00 57.72 -1,059.73 4,015,898.40 11,747.99 FFCB Bond FHLB BOND FHLB 1.1 3130A1GP7 10: General 1.100 4/17/2017 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 2,750.00 4/17/2017-14 Fund FHLB 1.15 3133743W8 30: Water & 0.300 10/30/2014 1,002,822.00 0.00 0.00 0.00 -2,116.50 1,000,705.50 758.50 10/30/2014 Sewer FHLB 1.75 313376BR5 30: Water& 1.736 12/14/2018 1,000,597.71 0.00 0.00 0.00 -33.54 1,000,564.17 4,341.46 12/14/2018 Sewer Sub Total/Average 1.042 3,003,419.71 0.00 0.00 0.00 -2,150.04 3,001,269.67 7,849.96 FHLB Bond FHLMC BOND 9 of 11 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Prindpal Sell Principal Discount Premium Ending BV Income -BV 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 1 9/29/2017 FHLMC 2.1 4/24/2019-14 3134G4FY9 3134G4QK7 3134G4QV3 3134G4FP8 3137 EADLO 3134G5233 FHLMC 0.4 3134G4S33 1/15/2016-14 FHLMC 0.35 12/5/2014 10: General Fund 10: General Fund 20: Debt Services 30: Water& Sewer 30: Water & Sewer 42: Utility Impact Fee 45: Hotel/Motel Occupancy 67: 2003 3134G3H78 Revenue Bonds 9/24/2018 1,000,000.00 0.369 12/31/2015 999,718.75 1.850 12/27/2018 1,000,000.00 8/28/2015 1,000,000.00 1.163 9/29/2017 994,819.20 2.100 4/24/2019 1,000,000.00 0.400 1/15/2016 1,000,000.00 0.330 12/5/2014 1,000,085.76 0.00 1,000,000.00 0.00 0.00 0.00 4,666.67 0.00 0.00 46.87 0.00 999,765.62 921.87 0.00 0.00 0.00 0.00 1,000,000.00 4,625.00 0.00 1,000,000.00 0.00 0.00 0.00 833.33 0.00 0.00 398.87 0.00 995,218.07 2,898.87 0.00 0.00 0.00 0.00 1,000,000.00 5,250.00 0.00 0.00 0.00 0.00 1,000,000.00 1,000.00 0.00 0.00 0.00 -49.80 1,000,035.96 825.20 Sub Tota I/Average FHLMC Bond FNMA BOND FNMA 0.875 12/20/2017 FNMA 0.35 8/25/2015 FNMA 0.875 10/26/2017 FNMA 1.625 11/27/2018 FNMA 1.3 11/17/2014 FNMA 0.875 5/21/2018 3135G0RT2 3135G0UW1 3135G0PQ0 3135G0YT4 3136FPWZ6 3135G0W38 10: General Fund 10: General Fund 30: Water & Sewer 30: Water & Sewer 30: Water & Sewer 42: Utility Impact Fee 1.035 7,994,623.71 0.00 2,000,000.00 445.74 -49.80 5,995,019.65 21,020.94 1.087 12/20/2017 992,797.92 0.00 0.416 8/25/2015 508,614.14 0.00 1.019 10/26/2017 995,303.16 0.00 1.520 11/27/2018 0.00 1,004,411.00 0.462 11/17/2014 1,003,168.22 0.00 1.259 5/21/2018 985,454.90 0.00 0.00 518.55 0.00 993,316.47 2,706.05 0.00 83.68 0.00 508,697.82 538.96 0.00 353.44 0.00 995,656.60 2,540.94 0.00 0.00 -207.77 1,004,203.23 3,132.50 0.00 0.00 -2,081.31 1,001,086.91 1,168.69 0.00 934.37 0.00 986,389.27 3,121.87 Sub Tota I/Average 1.007 4,485,338.34 1,004,411.00 FNMA Bond 10 of 11 0.00 1,890.04 -2,289.08 5,489,350.30 13,209.01 13 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 MONEY MARKET Wells Fargo Bank MM WF5455 10: General Fund N/A 35,101.25 0.00 35,101.25 0.00 0.00 0.00 0.00 Sub Total/Average Money Market 35,101.25 0.00 35,101.25 0.00 0.00 0.00 0.00 Total / Average 0.477 85,261,338.95 24,197,647.01 24,730,857.72 2,503.46 -5,548.65 84,725,083.05 105,225.90 11 of 11 City of Pearland Quarterly Investment Report at Quarterend Report Format: By Transaction Group By: Security Type Portfolio/Report Group: Report Group: Pearland As of 9/30/2014 YTM Portfolio Settlement Maturity @ Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Cash Wells Fargo WFSWEEP 10: General 5/31/2006 N/A 0.140 10,398,771.26 10,398,771.26 10,398,771.26 10,398,771.26 1 12.27 Sweep Cash Fund Wells Fargo 17: Municipal Sweep Cash WFSWEEP Court 5/31/2006 N/A 0.140 119,571.33 119,571.33 119,571.33 119,571.33 1 0.14 Security Wells Fargo 18: City Sweep Cash WFSWEEP Wide 5/31/2006 N/A 0.140 49,666.58 49,666.58 49,666.58 49,666.58 1 0.06 Donation Wells Fargo WFSWEEP 19: Court 5/31/2006 N/A 0.140 48,432.83 48,432.83 48,432.83 48,432.83 1 0.06 Sweep Cash Technology Wells Fargo WFSWEEP 20: Debt 5/31/2006 N/A 0.140 1,638,827.13 1,638,827.13 1,638,827.13 1,638,827.13 1 1.93 Sweep Cash Services Wells Fargo 23: Court Sweep Cash WFSWEEP Juvenile 9/15/2009 N/A 0.140 55,112.99 55,112.99 55,112.99 55,112.99 1 0.07 Mgmt Wells Fargo WFSWEEP 30: Water& 5/31/2006 N/A 0.140 6,799,705.34 6,799,705.34 6,799,705.34 6,799,705.34 1 8.02 Sweep Cash Sewer Wells Fargo WFSWEEP 31: 12/1/2006 N/A 0.140 870,997.04 870,997.04 870,997.04 870,997.04 1 1.03 Sweep Cash Solidwaste Wells Fargo 35: Street WFSWEEP 5/31/2006 N/A 0.140 176,215.71 176,215.71 176,215.71 176,215.71. 1 0.21 Sweep Cash Assessment Wells Fargo WFSWEEP 42: Utility 5/31/2006 N/A 0.140 8,350,492.52 8,350,492.52 8,350,492.52 8,350,492.52 1 9.85 Sweep Cash Impact Fee 44: Shadow Wells Fargo WFSWEEP Creek 5/31/2006 N/A 0.140 -547,376.83 -547,376.83 -547,376.83 -547,376.83 1 -0.65 Sweep Cash Impact 45: Wells Fargo WFSWEEP Hotel/Motel 5/31/2006 N/A 0.140 879,289.75 879,289.75 879,289.75 879,289.75 1 1.04 Sweep Cash Occupancy Wells Fargo WFSWEEP 46: Park 5/31/2006 N/A 0.140 99,331.42 99,331.42 99,331.42 99,331.42 1 0.12 Sweep Cash Donations 47: Park & Wells Fargo WFSWEEP Rec 5/31/2006 N/A 0.140 525,494.37 525,494.37 525,494.37 525,494.37 1 0.62 Sweep Cash Development 1 of 9 YTM Portfolio Settlement Maturity @ 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 49: Tree 5/31/2006 N/A 0.140 69,308.37 69,308.37 69,308.37 69,308.37 1 0.08 Sweep Cash Trust Fund Wells Fargo WFSWEEP 50: Capital 5/31/2006 N/A 0.140 1,243,342.23 1,243,342.23 1,243,342.23 1,243,342.23 1 1.47 Sweep Cash Projects Wells Fargo WFSWEEP 55: Sidewalk 5/31/2006 N/A 0.140 242,998.95 242,998.95 242,998.95 242,998.95 1 0.29 Sweep Cash Fund 60: Police Wells Fargo WFSWEEP State 5/31/2006 N/A 0.140 157,611.29 157,611.29 157,611.29 157,611.29 1 0.19 Sweep Cash Seizure Wells Fargo 62: Federal WFSWEEP 5/31/2006 N/A 0.140 43,157.49 43,157.49 43,157.49 43,157.49 1 0.05 Sweep Cash Police Fund Wells Fargo C4: 1998 Sweep Cash WFSWEEP Cert of 5/31/2006 N/A 0.140 300,265.02 300,265.02 300,265.02 300,265.02 1 0.35 Obligation 67: 2003 Wells Fargo WFSWEEP Revenue 5/31/2006 N/A 0.140 28,035.65 28,035.65 28,035.65 28,035.65 1 0.03 Sweep Cash Bonds Wells Fargo C8: 2001 Sweep Cash WFSWEEP Cert of 5/31/2006 N/A 0.140 -778,696.12 -778,696.12 -778,696.12 -778,696.12 1 -0.92 Obligation 70: 2005 Wells Fargo WFSWEEP Refunding / 5/31/2006 N/A 0.140 -113,792.77 -113,792.77 -113,792.77 -113,792.77 1 -0.13 Sweep Cash Mobility Wells Fargo WFSWEEP 95: Property 10/31/2006 N/A 0.140 134,798.67 134,798.67 134,798.67 134,798.67 1 0.16 Sweep Cash Liability Wells Fargo E7. Sweep Cash WFSWEEP Employee 9/1/2007 N/A 0.140 83,497.15 83,497.15 83,497.15 83,497.15 1 0.10 Benefit Trust Wells Fargo 99: COP Sweep Cash WFSWEEP Health 9/15/2010 N/A 0.140 480,718.66 480,718.66 480,718.66 480,718.66 1 0.57 Claims Fund Wells Far -go He: COP Cash WF9871 Health 7/21/2010 N/A 0.140 380,657.54 380,657.54 380,657.54 380,657.54 1 0.45 Claims Fund Z141:UofH Wells Fargo WFSWEEP Capital 9/30/2013 N/A 0.140 240,127.75 240,127.75 240,127.75 240,127.75 1 0.28 Sweep Cash Renewal Fund Z145: Wells Fargo WFSWEEP Municipal 4/15/2012 N/A 0.140 447,638.43 447,638.43 447,638.43 447,638.43 1 0.53 Sweep Cash Channel 2 of 9 YTM Portfolio Settlement Maturity @ 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 Z200: 2006 Sweep Cash WFSWEEP Cert of 6/30/2006 N/A 0.140 1,821,259.71 1,821,259.71 1,821,259.71 1,821,259.71 1 2.15 Obligation Wells Fargo Z201: 2007 Sweep Cash WFSWEEP Cert of 8/31/2006 N/A 0.140 28,768.66 28,768.66 28,768.66 28,768.66 1 0.03 Obligation Z202: Wells Fargo WFSWEEP 2007A Gen 12/31/2007 N/A 0.140 606,828.93 606,828.93 606,828.93 606,828.93 1 0.72 Sweep Cash Obligation Wells Fargo Z203: 2009 Sweep Cash WFSWEEP Gen 10/30/2008 N/A 0.140 11,629,377.03 11,629,377.03 11,629,377.03 11,629,377.03 1 13.72 Obligation Z301: W/S Wells Fargo WFSWEEP Pay As U Go 12/31/2007 N/A 0.140 1,703,237.38 1,703,237.38 1,703,237.38 1,703,237.38 1 2.01 Sweep Cash CIP Wells Fargo WFSWEEP 4 CapZ302: Cap MUD Sweep Cash ital 2/1/2013 N/A 0.140 635,216.05 635,216.05 635,216.05 635,216.05 1 0.75 Programs Sub Total / 0.140 48,848,887.51 48,848,887.51 48,848,887.51 48,848,887.51 1 0.00 57.65 Average Certificate 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 79 1,952.05 0.59 12/18/2014 Fund First National 10: General Bank 1.6 CD32115CBE7 9/18/2013 3/19/2018 1.600 248,000.00 248,000.00 248,000.00 249,620.43 1266 119.58 0.29 Fund 3/19/2018 1st United Bank 10: General 0.29 FL 0.7 33741TAU5 11/8/2013 5/9/2016 0.700 248,000.00 248,000.00 248,000.00 248,383.41 587 99.88 Fund 5/9/2016 Trust Atlantic 10: General Bank 1.45 89835FJC5 11/6/2013 12/6/2017 1.450 248,000.00 248,000.00 248,000.00 249,360.03 1163 236.45 0.29 Fund 12/6/2017 Farmers & Merchants Bank 308862DD0 10: General 4/25/2014 9/25/2018 1.450 248,000.00 248,000.00 248,000.00 248,217.99 1456 49.26 0.29 1.45 Fund 9/25/2018-14 Moody National 10: General Bank 0.5 7130 5/30/2014 11/30/2014 0.500 247,420.54 247,420.54 247,420.54 247,420.54 61 416.89 0.29 Fund 11/30/2014 Southwest 10: General Bank Ft Worth CD844772AA1 2/27/2013 2/27/2015 0.300 248,000.00 248,000.00 248,000.00 248,189.47 150 6.12 0.29 Fund 0.3 2/27/2015 3 of 9 ii YTM Portfolio Settlement Maturity CO Face Days To Accrued % of Description CUSIP/Ticker 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 247,701.66 647 74.74 0.29 Bank 0.5 Fund 7/8/2016 Cardinal Bank CD14147VDM5 10: General 5/17/2013 5/17/2016 0.500 248,000.00 248,000.00 248,000.00 247,993.55 595 44.16 0.29 0.5 5/17/2016 Fund Discover Bank CD254671KH2 10: General 2/20/2013 2/20/2015 0.500 248,000.00 248,000.00 248,000.00 248,186.00 143 139.29 0.29 0.5 2/20/2015 Fund Synovus Bank 10: General GA 0.5 87164DBV1 11/30/2012 11/28/2014 0.500 248,000.00 248,000.00 248,000.00 248,194.18 59 417.86 0.29 Fund 11/28/2014 CDARS 0.9 1016754591 10: General 6/19/2014 6/16/2016 0.900 500,000.00 500,000.00 500,000.00 500,000.00 625 1,269.86 0.59 6/16/2016 Fund Community National Bank 20375WAM6 10: General 4/4/2014 4/4/2018 1.250 248,000.00 248,000.00 248,000.00 247,458.62 1282 1,520.27 0.29 Interest 1.25 Fund 4/4/2018 Townebank 10: General Portsmouth VA 89214PAP4 5/31/2013 6/1/2015 0.400 248,000.00 248,000.00 248,000.00 248,162.94 244 331.57 0.29 Fund 0.4 6/1/2015 FIRST BANK HIGHLAND 319141BL0 10: General 5/7/2014 5/7/2019 1.850 248,000.00 248,000.00 248,000.00 247,146.88 1680 1,835.20 0.29 PARK 1.85 Fund 5/7/2019-14 ConnectOne 20: Debt Bank 1.55 20786AAM7 1/30/2014 7/30/2018 1.550 248,000.00 248,000.00 248,000.00 248,441.44 1399 0.00 0.29 Services 7/30/2018 Carolina Alliance 20: Debt Bank 1.05 14376RAK3 7/30/2014 7/31/2017 1.050 248,000.00 248,000.00 248,000.00 246,187.37 1035 0.00 0.29 Services 7/31/2017 Webster Bank 20: Debt NA 1.9 94768N3M7 2/12/2014 2/12/2019 1.900 248,000.00 248,000.00 248,000.00 247,828.88 1596 632.57 0.29 Services 2/12/2019 Mechanics Savings Bank CD583686BC3 20: Debt 3/20/2013 3/20/2015 0.350 248,000.00 248,000.00 248,000.00 248,151.03 171 23.78 0.29 0.35 Services 3/20/2015 Goldman Sachs 30: Water & Bank 0.6 CD38147)AA0 2/20/2013 2/20/2015 0.600 248,000.00 248,000.00 248,000.00 248,128.96 143 167.15 0.29 Sewer 2/20/2015 BARCLAYS BANK06740KGU5 30: Water & 5/6/2014 5/7/2019 1.950 248,000.00 248,000.00 248,000.00 247,133.74 1680 1,947.65 0.29 DELAWARE Sewer 4 of 9 1'6 YTM Portfolio Settlement Maturity @ Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest PortfoBo 1.95 5/7/2019 O LDTO W N BANK 1.2 5/7/2018 Bay Cities Bank 0.5 12/12/2014 Fox Chase Bank 0.65 6/27/2016 CDARS 0.6 6/18/2015 First Farmers Bank 0.5 5/3/2016 Northwest Bank Boise Idaho 1.5 1/10/2019 Fidelity Homestead Savings Bank New Orleans 0.6 11 United Bankers Bank 0.75 5/6/2016 Town North Bank 0.4 7/24/2015 Hardin County Bank 0.25 12/30/2014 Private Bank & Trust 0.35 5/11/2015 Sterling Savings Bank 0.35 2/23/2015 College Savings Bank 0.55 6/20/2016 680540666 30: Water& 6/6/2014 5/7/2018 1.200 248,000.00 248,000.00 248,000.00 246,868.13 1315 195.68 0.29 Sewer CD07203QBR2 30: Water & 12/12/2012 12/12/2014 0.500 248,000.00 248,000.00 248,000.00 248,242.05 73 61.15 0.29 Sewer CD35137QAN4 30: Water & 6/27/2013 6/27/2016 0.650 248,000.00 248,000.00 248,000.00 247,758.70 636 13.25 0.29 Sewer 1016754575 30: Water& 6/19/2014 6/18/2015 0.600 500,000.00 500,000.00 500,000.00 500,000.00 261 846.58 0.59 Sewer CD320165FZ1 30: Water & 5/3/2013 5/3/2016 0.500 245,000.00 245,000.00 245,000.00 245,081.10 581 90.62 0.29 Sewer 66736AAD1 30: Water & 4/10/2014 1/10/2019 1.500 248,000.00 248,000.00 248,000.00 247,737.12 1563 203.84 0.29 Sewer 31617CAD5 31 3/28/2014 11/28/2016 0.600 248,000.00 248,000.00 248,000.00 247,635.19 790 8.15 0.29 So lidwaste 909557CV0 35: Street 11/6/2013 5/6/2016 0.750 248,000.00 248,000.00 248,000.00 248,433.50 584 122.30 0.29 Assessment 89213TLD2 35: Street 7/25/2014 7/24/2015 0.400 248,000.00 248,000.00 248,000.00 247,655.78 297 182.09 0.29 Assessment 411822BG3 42: Utility 12/30/2013 12/30/2014 0.250 248,000.00 248,000.00 248,000.00 247,964.04 91 49.26 0.29 Impact Fee CD74267GTC1 42: Utility 5/10/2013 5/11/2015 0.350 248,000.00 248,000.00 248,000.00 248,170.62 223 337.69 0.29 Impact Fee CD8595316A8 42: Utility 2/22/2013 2/23/2015 0.350 248,000.00 248,000.00 248,000.00 248,188.48 146 92.75 0.29 Impact Fee CD19443PAP4 42: Utikty 6/19/2013 6/20/2016 0.550 248,000.00 248,000.00 248,000.00 247,793.66 629 381.17 0.29 Impact Fee 5 of 9 kv` YTM Portfolio Settlement Maturity © Face Days To Accrued % of Description CUSIP/Tkker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio The Independent CD88632YAG1 42: Utitty 9/18/2013 9/16/2016 1.100 248,000.00 248,000.00 248,000.00 248,079.36 717 104.64 0.29 Bank 1.1 Impact Fee 9/16/2016 3P Morgan Chase Bank Columbus Ohio 48125T3W6 0.85 3/31/2017- 42: Utility 3/31/2014 3/31/2017 0.850 248,000.00 248,000.00 248,000.00 247,444.98 913 0.00 0.29 Impact Fee Far East National Bank 307327EK8 42: Utility 3/31/2014 3/31/2017 1.000 248,000.00 248,000.00 248,000.00 247,512.68 913 0.00 0.29 Los Angeles 1 Impact Fee 3/31/2017 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,829.81 251 664.16 0.29 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 247,822.93 623 59.79 0.29 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,979.91 265 237.81 0.29 6/22/2015 Impact GUARANTY B&T 44: Shadow 1.35 400820634 Creek 5/29/2014 5/29/2018 1.350 248,000.00 248,000.00 248,000.00 246,992.62 1337 9.17 0.29 5/29/2018 Impact Americanwest 45: Bank 0.8 030590DS9 Hotel/Motel 7/25/2014 1/25/2017 0.800 248,000.00 248,000.00 248,000.00 246,606.24 848 364.19 0.29 1/25/2017 Occupancy First 45: Commercial 31984GCW7 HoteVMotel 12/27/2013 6/26/2015 0.400 248,000.00 248,000.00 248,000.00 247,972.72 269 10.87 0.29 Bank Miss 0.4 6/26/2015 Occupancy Colonial Virginia 45: Bank 0.55 CD196121AM9 HoteVMotel 6/25/2013 6/24/2016 0.550 248,000.00 248,000.00 248,000.00 247,773.33 633 22.42 0.29 6/24/2016 Occupancy First State Bank 47: Park & Un Cty Tenn 336472E30 Rec 12/23/2013 12/23/2015 0.450 248,000.00 248,000.00 248,000.00 248,145.82 449 21.40 0.29 0.45 12/23/2015 Development Safra National 47: Park & Bank 0.45 78658QDT7 Rec 7/30/2014 7/30/2015 0.450 248,000.00 248,000.00 248,000.00 247,738.11 303 189.57 0.29 7/30/2015 Development San Diego 50: Capital Private Bank 79744YAB6 Projects 3/31/2014 3/31/2017 0.800 248,000.00 248,000.00 248,000.00 247,511.19 913 0.00 0.29 6 of 9 2-0 YTM Portfolio Settlement Maturity @ Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio California 0.8 3/31/2017 US AmeriBank 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 248,176.08 449 26.16 0.29 12/23/2015 Obligation Asheville 67: 2003 Savings Bank CD04407RAJ0 Revenue 2/28/2013 3/27/2015 0.350 248,000.00 248,000.00 248,000.00 248,120.53 178 4.76 0.29 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 248,330.34 399 407.67 0.29 11/3/2015 Bonds CIT Bank 1.5 67: 2003 9/5/2017 CD17284CMN1 Revenue 9/4/2013 9/5/2017 1.500 248,000.00 248,000.00 248,000.00 248,255.94 1071 264.99 0.29 Bonds CALUSA 67: 2003 NATIONAL 13151TAX4 Revenue 5/23/2014 9/22/2016 0.500 248,000.00 248,000.00 248,000.00 247,021.89 723 27.18 0.29 BANK 0.5 Bonds 9/22/2016 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 248,518.57 780 733.81 0.29 0.8 Bonds 11/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 247,958.34 64 64.21 0.29 12/3/2014 Mobility Celtic Bank 0.6 Z202: 6/28/2016 CD15118RJD0 2007A Gen 6/28/2013 6/28/2016 0.600 248,000.00 248,000.00 248,000.00 247,796.39 637 8.15 0.29 Obligation Kansas State Z203: 2009 Bank 0.8 485382DV4 Gen 10/30/2013 10/31/2016 0.800 248,000.00 248,000.00 248,000.00 248,634.63 762 0.00 0.29 10/31/2016 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 248,618.26 538 50.96 0.29 3/21/2016 Obligation Merchant & Z203: 2009 Manufacturing 588339DD0 Gen 2/7/2014 8/7/2015 0.350 248,000.00 248,000.00 248,000.00 247,919.15 311 54.70 0.29 Bank 0.35 Obligation 8/7/2015 Flushing Bank Z203: 2009 New York 0.95 34387AAH2 Gen 3/31/2014 3/31/2017 0.950 248,000.00 248,000.00 248,000.00 247,451.42 913 0.00 0.29 3/31/2017 Obligation 7 of 9 Zl YTM Portfolio Settlement Maturity @ Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Vakie Maturity Interest Portfolio Provident Bank Z203: 2009 0.35 743837BF2 Gen 2/21/2014 8/21/2015 0.350 248,000.00 248,000.00 248,000.00 247,874.76 325 95.12 0.29 8/21/2015 Obligation DeWitt Bank Z301: W/S and Trust 0.5 CD241888BT2 Pay As U Go 6/24/2013 6/20/2016 0.500 248,000.00 248,000.00 248,000.00 247,835.82 629 33.97 0.29 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 248,176.08 449 23.78 0.29 12/23/2015 Programs Pacific City Bank Z302: MUD 0.35 69406PB17 4 Capital 12/26/2013 6/26/2015 0.350 248,000.00 248,000.00 248,000.00 247,954.62 269 9.51 0.29 6/26/2015 Programs Sub Total / 0.752 16,376,420.54 16,376,420.54 16,376,420.54 16,372,488.01 623 17,357.85 19.33 Average FAMC Bond FAMC 1.72 31315P5A3 30: Water & 12/16/2013 10/3/2018 1.766 1,000,000.00 997,890.00 998,236.98 1,002,903.00 1464 8,456.67 1.18 10/3/2018 Sewer Sub Total / 1.766 1,000,000.00 997,890.00 998,236.98 1,002,903.00 1464 8,456.67 1.18 Average FFCB Bond FFCB 1.34 3133EDE99 10: General 1/29/2014 12/29/2017 1.235 1,000,000.00 1,004,000.00 1,003,316.31 1,007,442.00 1186 3,387.22 1.18 12/29/2017 Fund FFCB 0.25 3133ECAV6 20: Debt 1/28/2013 12/24/2014 0.273 1,000,000.00 999,560.00 999,946.12 1,000,291.00 85 666.67 1.18 12/24/2014 Services FFCB 1.95 3133ED2C5 30: Water & 1/29/2014 9/17/2018 1.617 1,000,000.00 1,014,770.00 1,012,635.97 1,011,463.00 1448 704.17 1.18 9/17/2018 Sewer FFCB 1.5 Z203: 2009 1/28/2019 3133EDNF6 Gen 5/28/2014 1/28/2019 1.500 1,000,000.00 1,000,000.00 1,000,000.00 995,721.00 1581 2,583.33 1.18 Obligation Sub Total / 1.156 4,000,000.00 4,018,330.00 4,015,898.40 4,014,917.00 1075 7,341.39 4.72 Average FHLB Bond FHLB 1.1 3130A1GP7 10: General 4/17/2014 4/17/2017 1.100 1,000,000.00 1,000,000.00 1,000,000.00 1,000,431.00 930 4,980.56 1.18 4/17/2017-14 Fund FHLB 1.15 3133743W8 30: Water& 11/29/2012 10/30/2014 0.300 1,000,000.00 1,016,250.00 1,000,705.50 1,000,829.00 30 4,791.67 1.18 10/30/2014 Sewer FHLB 1.75 313376BR5 30: Water & 12/16/2013 12/14/2018 1.736 1,000,000.00 1,000,670.00 1,000,564.17 1,001,526.00 1536 5,152.78 1.18 12/14/2018 Sewer 8 of 9 'ZZ YTM Portfolio Settlement Maturity @ Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Sub Total / Average FHLMC Bond 1.045 3,000,000.00 3,016,920.00 3,001,269.67 3,002,786.00 832 14,925.01 3.54 FHLMC 0.35 3134G4QK7 10: General 12/31/2013 12/31/2015 0.369 1,000,000.00 999,625.00 999,765.62 998,882.00 457 875.00 1.18 12/31/2015-14 Fund FHLMC 1.85 3134G4QV3 20: Debt 12/27/2013 12/27/2018 1.850 1,000,000.00 1,000,000.00 1,000,000.00 1,003,005.00 1549 4,779.17 1.18 12/27/2018-14 Services FHLMC 1 3137EADLO 30: Water& 1/29/2014 9/29/2017 1.163 1,000,000.00 994,150.00 995,218.07 995,486.00 1095 27.78 1.18 9/29/2017 Sewer FHLMC 2.1 3134G5233 42: Utility 4/24/2014 4/24/2019 2.100 1,000,000.00 1,000,000.00 1,000,000.00 1,001,218.00 1667 9,100.00 1.18 4/24/2019-14 Impact Fee FHLMC 0.4 45: 1/15/2016-14 3134G4S33 HoteVMotel 1/29/2014 1/15/2016 0.400 1,000,000.00 1,000,000.00 1,000,000.00 998,834.00 472 833.33 1.18 Occupancy 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,035.96 1,000,502.00 66 1,118.06 1.18 Bonds Sub Total / 1.035 6,000,000.00 5,994,211.00 5,995,019.65 5,997,927.00 884 16,733.34 7.08 Average FNMA Bond FNMA 0.875 3135G0RT2 10: General 5/21/2014 12/20/2017 1.087 1,000,000.00 992,573.21 993,316.47 987,489.00 1177 2,430.56 1.18 12/20/2017 Fund FNMA 0.35 3135G0UW1 10: General 7/25/2013 8/25/2015 0.416 509,000.00 508,302.67 508,697.82 509,907.04 329 158.36 0.60 8/25/2015 Fund FNMA 1.625 3135G0YT4 30: Water & 7/16/2014 11/27/2018 1.520 1,000,000.00 1,004,411.00 1,004,203.23 997,934.00 1519 5,552.08 1.18 11/27/2018 Sewer FNMA 0.875 3135G0PQ0 30: Water & 5/21/2014 10/26/2017 1.019 1,000,000.00 995,150.00 995,656.60 990,512.00 1122 3,743.06 1.18 10/26/2017 Sewer FNMA 1.3 3136FPWZ6 30: Water & 6/20/2012 11/17/2014 0.462 1,000,000.00 1,020,050.00 1,001,086.91 1,001,581.00 48 4,802.78 1.18 11/17/2014 Sewer FNMA 0.875 3135GOW]8 42: Utility 5/21/2014 5/21/2018 1.259 1,000,000.00 985,050.00 986,389.27 979,362.00 1329 3,135.42 1.18 5/21/2018 Impact Fee Sub Total / 1.009 5,509,000.00 5,505,536.88 5,489,350.30 5,466,785.04 973 19,822.26 6.50 Average Total / 0.477 84,734,308.05 84,758,195.93 84,725,083.05 84,706,693.56 344 84,636.52 100 Average 9 of 9 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/2014 Description Security Settlement Face YTM © Maturity Days To % of CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio 10: General Fund Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 10,398,771.26 10,398,771.26 10,398,771.26 0.140 N/A 1 12.27 CDARS 0.5 12/18/2014 1016130741 Certificate 12/19/2013 500,000.00 500,000.00 500,000.00 0.500 12/18/2014 79 0.59 Of Deposit First National Bank 1.6 CD32115CBE7 Certificate 9/18/2013 248,000.00 248,000.00 249,620.43 1.600 3/19/2018 1266 0.29 3/19/2018 Of Deposit 1st United Bank FL 0.7 33741TAU5 Certificate 11/8/2013 248,000.00 248,000.00 248,383.41 0.700 5/9/2016 587 0.29 5/9/2016 Of Deposit Trust Atlantic Bank 1.45 89835FJC5 Certificate 11/6/2013 248,000.00 248,000.00 249,360.03 1.450 12/6/2017 1163 0.29 12/6/2017 Of Deposit Farmers & Merchants Certificate Bank 1.45 308862DD0 Of Deposit 4/25/2014 248,000.00 248,000.00 248,217.99 1.450 9/25/2018 1456 0.29 9/25/2018-14 Moody National Bank 0.5 7130 Certificate 5/30/2014 247,420.54 247,420.54 247,420.54 0.500 11/30/2014 61 0.29 11/30/2014 Of Deposit Southwest Bank Ft CD844772AA1 Certificate 2/27/2013 248,000.00 248,000.00 248,189.47 0.300 2/27/2015 150 0.29 Worth 0.3 2/27/2015 Of Deposit Plus International Bank CD72940UFV2 Certificate 7/8/2013 248,000.00 248,000.00 247,701.66 0.500 7/8/2016 647 0.29 0.5 7/8/2016 Of Deposit Cardinal Bank 0.5 CD14147VDM5 Certificate 5/17/2013 248,000.00 248,000.00 247,993.55 0.500 5/17/2016 595 0.29 5/17/2016 Of Deposit Discover Bank 0.5 CD254671KH2 Certificate 2/20/2013 248,000.00 248,000.00 248,186.00 0.500 2/20/2015 143 0.29 2/20/2015 Of Deposit Synovus Bank GA 0.5 87164DBV1 Certificate 11/30/2012 248,000.00 248,000.00 248,194.18 0.500 11/28/2014 59 0.29 11/28/2014 Of Deposit CDARS 0.9 6/16/2016 1016754591 Certificate 6/19/2014 500,000.00 500,000.00 500,000.00 0.900 6/16/2016 625 0.59 Of Deposit Community National Certificate Bank Interest 1.25 20375WAM6 Of Deposit 4/4/2014 248,000.00 248,000.00 247,458.62 1.250 4/4/2018 1282 0.29 4/4/2018 1 of 9 Z-( Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Townebank Portsmouth 89214PAP4 Certificate 5/31/2013 248,000.00 248,000.00 248,162.94 0.400 6/1/2015 244 0.29 VA 0.4 6/1/2015 Of Deposit FIRST BANK HIGHLAND 319141BL0 Certificate 5/7/2014 248,000.00 248,000.00 247,146.88 1.850 5/7/2019 1680 0.29 PARK 1.85 5/7/2019-14 Of Deposit FFCB 1.34 12/29/2017 3133EDE99 FFCB Bond 1/29/2014 1,000,000.00 1,003,316.31 1,007,442.00 1.235 12/29/2017 1186 1.18 FHLB 1.1 4/17/2017-14 3130A1GP7 FHLB Bond 4/17/2014 1,000,000.00 1,000,000.00 1,000,431.00 1.100 4/17/2017 930 1.18 FHLMC 0.35 3134G4QK7 FHLMC 12/31/2013 1,000,000.00 999,765.62 998,882.00 0.369 12/31/2015 457 1.18 12/31/2015-14 Bond FNMA 0.875 3135G0RT2 FNMA Bond 5/21/2014 1,000,000.00 993,316.47 987,489.00 1.087 12/20/2017 1177 1.17 12/20/2017 FNMA 0.35 8/25/2015 3135G0UW1 FNMA Bond 7/25/2013 509,000.00 508,697.82 509,907.04 0.416 8/25/2015 329 0.60 Sub Total / Average 19,131,191.80 19,127,288.02 19,128,958.00 0.471 345 22.58 17: Municipal Court Security Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 119,571.33 119,571.33 119,571.33 0.140 N/A 1 0.14 Sub Total / Average 119,571.33 119,571.33 119,571.33 0.140 1 0.14 18: City Wide Donation Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 49,666.58 49,666.58 49,666.58 0.140 N/A 1 0.06 Sub Total / Average 49,666.58 49,666.58 49,666.58 0.140 1 0.06 19: Court Tedinology Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 48,432.83 48,432.83 48,432.83 0.140 N/A 1 0.06 Sub Total / Average 48,432.83 48,432.83 48,432.83 0.140 1 0.06 20: Debt Services Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 1,638,827.13 1,638,827.13 1,638,827.13 0.140 N/A 1 1.93 ConnectOne Bank 1.55 20786AAM7 Certificate 1/30/2014 248,000.00 248,000.00 248,441.44 1.550 7/30/2018 1399 0.29 7/30/2018 Of Deposit Carolina Alliance Bank 14376RAK3 Certificate 7/30/2014 248,000.00 248,000.00 246,187.37 1.050 7/31/2017 1035 0.29 1.05 7/31/2017 Of Deposit Webster Bank NA 1.9 94768N3M7 Certificate 2/12/2014 248,000.00 248,000.00 247,828.88 1.900 2/12/2019 1596 0.29 2/12/2019 Of Deposit 2 of 9 ZS Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Mechanics Savings Bank CD583686BC3 Certificate 3/20/2013 248,000.00 248,000.00 248,151.03 0.350 3/20/2015 171 0.29 0.35 3/20/2015 Of Deposit FFCB 0.25 12/24/2014 3133ECAV6 FFCB Bond 1/28/2013 1,000,000.00 999,946.12 1,000,291.00 0.273 12/24/2014 85 1.18 FHLMC 1.85 3134G4QV3 FHLMC 12/27/2013 1,000,000.00 1,000,000.00 1,003,005.00 1.850 12/27/2018 1549 1.18 12/27/2018-14 Bond Sub Total / Average 4,630,827.13 4,630,773.25 4,632,731.85 0.768 578 5.47 23: Court Juvenile Mgmt Wells Fargo Sweep Cash WFSWEEP Cash 9/15/2009 55,112.99 55,112.99 55,112.99 0.140 N/A 1 0.07 Sub Total / Average 55,112.99 55,112.99 55,112.99 0.140 1 0.07 30: Water & Sewer Wells Fargo Sweep Cash WFSWEEP Cash Goldman Sachs Bank 0.6 CD381473AA0 Certificate 2/20/2015 Of Deposit BARCLAYS BANK Certificate DELAWARE 1.95 06740KGU5 Of Deposit 5/7/2019 OLDTOWN BANK 1.2 680540886 Certificate 5/7/2018 Of Deposit Bay Cities Bank 0.5 CD07203QBR2 Certificate 12/12/2014 Of Deposit Fox Chase Bank 0.65 CD35137QAN4 Certificate 6/27/2016 Of Deposit CDARS 0.6 6/18/2015 1016754575 Certificate Of Deposit First Farmers Bank 0.5 Certificate 5/3/2016 CD320165FZ1 Of Deposit Northwest Bank Boise 66736AAD1 Certificate Idaho 1.5 1/10/2019 Of Deposit 5/31/2006 6,799,705.34 6,799,705.34 6,799,705.34 0.140 N/A 1 8.03 2/20/2013 248,000.00 248,000.00 248,128.96 0.600 2/20/2015 143 0.29 5/6/2014 248,000.00 248,000.00 247,133.74 1.950 5/7/2019 1680 0.29 6/6/2014 248,000.00 248,000.00 246,868.13 1.200 5/7/2018 1315 0.29 12/12/2012 248,000.00 248,000.00 248,242.05 0.500 12/12/2014 73 0.29 6/27/2013 248,000.00 248,000.00 247,758.70 0.650 6/27/2016 636 0.29 6/19/2014 500,000.00 500,000.00 500,000.00 0.600 6/18/2015 261 0.59 5/3/2013 245,000.00 245,000.00 245,081.10 0.500 5/3/2016 581 0.29 4/10/2014 248,000.00 248,000.00 247,737.12 1.500 1/10/2019 1563 0.29 FAMC 1.72 10/3/2018 31315P5A3 FAMC Bond 12/16/2013 1,000,000.00 998,236.98 1,002,903.00 1.766 10/3/2018 1464 1.18 FFCB 1.95 9/17/2018 3133ED2C5 FFCB Bond 1/29/2014 1,000,000.00 1,012,635.97 1,011,463.00 1.617 9/17/2018 1448 1.20 FHLB 1.15 10/30/2014 3133743W8 FHLB Bond 11/29/2012 1,000,000.00 1,000,705.50 1,000,829.00 0.300 10/30/2014 30 1.18 FHLB 1.75 12/14/2018 313376BR5 FHLB Bond 12/16/2013 1,000,000.00 1,000,564.17 1,001,526.00 1.736 12/14/2018 1536 1.18 3 of 9 Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio FHLMC 1 9/29/2017 3137EADL0 FHLMC 1/29/2014 1,000,000.00 995,218.07 995,486.00 1.163 9/29/2017 1095 1.17 Bond FNMA 1.625 3135G0YT4 FNMA Bond 7/16/2014 1,000,000.00 1,004,203.23 997,934.00 1.520 11/27/2018 1519 1.19 11/27/2018 FNMA 0.875 3135G0PQ0 FNMA Bond 5/21/2014 1,000,000.00 995,656.60 990,512.00 1.019 10/26/2017 1122 1.18 10/26/2017 FNMA 1.3 11/17/2014 3136FPWZ6 FNMA Bond 6/20/2012 1,000,000.00 1,001,086.91 1,001,581.00 0.462 11/17/2014 48 1.18 Sub Total / Average 31: Solidwaste 17,032,705.34 17,041,012.77 17,032,889.14 0.737 581 20.11 Wells Fargo Sweep Cash WFSWEEP Cash 12/1/2006 870,997.04 870,997.04 870,997.04 0.140 N/A 1 1.03 Fidelity Homestead Certificate Savings Bank New 31617CAD5 Of Deposit 3/28/2014 248,000.00 248,000.00 247,635.19 0.600 11/28/2016 790 0.29 Orleans 0.6 11 Sub Total / Average 35: Street Assessment Wells Fargo Sweep Cash WFSWEEP Cash United Bankers Bank 909557CV0 Certificate 0.75 5/6/2016 Of Deposit Town North Bank 0.4 89213TLD2 Certificate 7/24/2015 Of Deposit 1,118,997.04 1,118,997.04 1,118,632.23 0.242 176 1.32 5/31/2006 176,215.71 176,215.71 176,215.71 0.140 N/A 1 0.21 11/6/2013 248,000.00 248,000.00 248,433.50 0.750 5/6/2016 584 0.29 7/25/2014 248,000.00 248,000.00 247,655.78 0.400 7/24/2015 297 0.29 Sub Total / Average 672,215.71 42: Utility Impact Fee Welts Fargo Sweep Cash WFSWEEP Cash Hardin County Bank 0.25 411822BG3 Certificate 12/30/2014 Of Deposit Private Bank & Trust CD74267GTC1 Certificate 0.35 5/11/2015 Of Deposit Sterling Savings Bank CD8595316A8 Certificate 0.35 2/23/2015 Of Deposit College Savings Bank CD19443PAP4 Certificate 0.55 6/20/2016 Of Deposit 672,215.71 672,304.99 0.461 325 0.79 5/31/2006 8,350,492.52 8,350,492.52 8,350,492.52 0.140 N/A 1 9.86 12/30/2013 248,000.00 248,000.00 247,964.04 0.250 12/30/2014 91 0.29 5/10/2013 248,000.00 248,000.00 248,170.62 0.350 5/11/2015 223 0.29 2/22/2013 248,000.00 248,000.00 248,188.48 0.350 2/23/2015 146 0.29 6/19/2013 248,000.00 248,000.00 247,793.66 0.550 6/20/2016 629 0.29 4 of 9 Z"? Description Security Settlement Face Date Amount/Shares CUSIP/Ticker Type YTM @ Maturity Days To 0/0 of Book Value Market Value Cost Date Maturity Portfolio The Independent Bank 1.1 9/16/2016 CD88632YAG1 Certificate Of Deposit JP Morgan Chase Bank Columbus Ohio 0.85 48125TJW6 3/31/2017 - Far East National Bank Los Angeles 1 307327EK8 3/31/2017 Certificate Of Deposit Certificate Of Deposit BMW Bank of NA 0.85 CD05568P2Q9 Certificate 6/8/2015 Of Deposit FHLMC 2.1 4/24/2019-14 3134G52)3 FNMA 0.875 5/21/2018 3135GOWJ8 FHLMC Bond 9/18/2013 3/31/2014 3/31/2014 12/7/2012 4/24/2014 FNMA Bond 5/21/2014 248,000.00 248,000.00 248,079.36 1.100 9/16/2016 717 0.29 248,000.00 248,000.00 247,444.98 0.850 3/31/2017 913 0.29 248,000.00 248,000.00 247,512.68 1.000 3/31/2017 913 0.29 248,000.00 248,000.00 248,829.81 0.850 6/8/2015 251 0.29 1,000,000.00 1,000,000.00 1,001,218.00 2.100 4/24/2019 1667 1.18 1,000,000.00 986,389.27 979,362.00 1.259 5/21/2018 1329 1.16 Sub Total / Average 44: Shadow Creek Impact Wells Fargo Sweep Cash WFSWEEP Marlin Business Bank 0.55 6/14/2016 Bank of Buffalo KY 0.35 6/22/2015 GUARANTY B&T 1.35 5/29/2018 CD57116AGF9 060788AF3 400820B]4 Cash Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit 12,334,492.52 12,320,881.79 12,315,056.15 0.473 321 14.54 5/31/2006 -547,376.83 -547,376.83 -547,376.83 0.140 N/A 1 -0.65 248,000.00 246,000.00 247,822.93 0.550 6/14/2016 623 0.29 248,000.00 248,000.00 247,979.91 0.350 6/22/2015 265 0.29 6/14/2013 12/20/2013 5/29/2014 248,000.00 248,000.00 246,992.62 1.350 5/29/2018 1337 0.29 Sub Total / Average 45: Hotel/Motel Occupancy Wells Fargo Sweep Cash Americanwest Bank 0.8 1/25/2017 First Commercial Bank Miss 0.4 6/26/2015 Colonial Virginia Bank 0.55 6/24/2016 FHLMC 0.4 1/15/2016-14 WFSWEEP Cash 030590DS9 31984GCW7 CD196121AM9 3134G4S33 Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit FHLMC Bond 196,623.17 5/31/2006 879,289.75 248,000.00 248,000.00 248,000.00 1,000,000.00 7/25/2014 12/27/2013 6/25/2013 1/29/2014 5 of 9 196,623.17 195,418.63 2.448 879,289.75 879,289.75 0.140 N/A 248,000.00 246,606.24 0.800 1/25/2017 248,000.00 247,972.72 0.400 6/26/2015 248,000.00 247,773.33 0.550 6/24/2016 2804 0.23 1 1.04 848 0.29 269 0.29 633 0.29 1,000,000.00 998,834.00 0.400 1/15/2016 472 1.18 Zu 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 / Average 2,623,289.75 2,623,289.75 2,620,476.04 0.365 346 3.10 46: Park Donations Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 99,331.42 99,331.42 99,331.42 0.140 N/A 1 0.12 Sub Total / Average 99,331.42 99,331.42 99,331.42 0.140 1 0.12 47: Park & Rec Development Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 525,494.37 525,494.37 525,494.37 0.140 N/A 1 0.62 First State Bank Un Cty 336472EJ0 Certificate 12/23/2013 248,000.00 248,000.00 248,145.82 0.450 12/23/2015 449 0.29 Tenn 0.45 12/23/2015 Of Deposit Safra National Bank 0.45 78658QDT7 Certificate 7/30/2014 248,000.00 248,000.00 247,738.11 0.450 7/30/2015 303 0.29 7/30/2015 Of Deposit Sub Total / Average 1,021,494.37 1,021,494.37 1,021,378.30 0.291 183 1.21 49: Tree Trust Fund Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 69,308.37 69,308.37 69,308.37 0.140 N/A 1 0.08 Sub Total / Average 69,308.37 69,308.37 69,308.37 0.140 1 0.08 50: Capital Projects Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 1,243,342.23 1,243,342.23 1,243,342.23 0.140 N/A 1 1.47 San Diego Private Bank 79744YAB6 Certificate 3/31/2014 248,000.00 248,000.00 247,511.19 0.800 3/31/2017 913 0.29 California 0.8 3/31/2017 Of Deposit Sub Total / Average 1,491,342.23 1,491,342.23 1,490,853.42 0.250 153 1.76 55: Sidewalk Fund Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 242,998.95 242,998.95 242,998.95 0.140 N/A 1 0.29 Sub Total / Average 242,998.95 242,998.95 242,998.95 0.140 1 0.29 60: Police State Seizure Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 157,611.29 157,611.29 157,611.29 0.140 N/A 1 0.19 Sub Total / Average 157,611.29 157,611.29 157,611.29 0.140 1 0.19 62: Federal Police Fund Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 43,157.49 43,157.49 43,157.49 0.140 N/A 1 0.05 6 of 9 261 Security Settlement Face VTM @ Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Sub Total / Average 43,157.49 43,157.49 43,157.49 0.140 1 0.05 64: 1998 Cert of Obligation Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 300,265.02 300,265.02 300,265.02 0.140 N/A 1 0.35 US AmeriBank Largo FL 0.55 12/23/2015 917312CC2 Certificate Of Deposit 12/23/2013 248,000.00 248,000.00 248,176.08 0.550 12/23/2015 449 0.29 Sub Total / Average 548,265.02 548,265.02 548,441.10 0.325 204 0.65 67: 2003 Revenue Bonds Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 28,035.65 28,035.65 28,035.65 0.140 N/A 1 0.03 Asheville Savings Bank CD04407RAJO Certificate 2/28/2013 248,000.00 248,000.00 248,120.53 0.350 3/27/2015 178 0.29 0.35 3/27/2015 Of Deposit Medallion Bank UT 0.4 CD58403BB62 Certificate 5/3/2013 248,000.00 248,000.00 248,330.34 0.400 11/3/2015 399 0.29 11/3/2015 Of Deposit CIT Bank 1.5 9/5/2017 CD17284CMN1 Certificate 9/4/2013 248,000.00 248,000.00 248,255.94 1.500 9/5/2017 1071 0.29 Of Deposit CALUSA NATIONAL BANK 13151TAX4 Certificate 5/23/2014 248,000.00 248,000.00 247,021.89 0.500 9/22/2016 723 0.29 0.5 9/22/2016 Of Deposit First National Bank ORD 32116RAC8 Certificate 11/18/2013 248,000.00 248,000.00 248,518.57 0.800 11/18/2016 780 0.29 NEB 0.8 11/18/2016 Of Deposit FHLMC 0.35 12/5/2014 3134G3H78 FHLMC 9/27/2012 1,000,000.00 1,000,035.96 1,000,502.00 0.330 12/5/2014 66 1.18 Bond Sub Total / Average 2,268,035.65 2,268,071.61 2,268,784.92 0.535 374 2.68 68: 2001 Cert of Obligation Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 -778,696.12 -778,696.12 -778,696.12 0.140 N/A 1 -0.92 Sub Total / Average -778,696.12 -778,696.12 -778,696.12 0.140 1 -0.92 70: 2005 Refunding / Mobility Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 -113,792.77 -113,792.77 -113,792.77 0.140 N/A 1 -0.13 First State Bank - WV 0.35 12/3/2014 CD33648FHR9 Certificate 12/3/2012 248,000.00 248,000.00 247,958.34 0.350 12/3/2014 64 0.29 Of Deposit Sub Total / Average 134,207.23 95: Property Liability 7 of 9 134,207.23 134,165.57 0.528 117 0.16 �CI 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 Cash WFSWEEP Cash 10/31/2006 134,798.67 134,798.67 134,798.67 0.140 N/A 1 0.16 Sub Total / Average 134,798.67 134,798.67 134,798.67 0.140 1 0.16 97: Employee Benefit Trust Wells Fargo Sweep Cash WFSWEEP Cash 9/1/2007 83,497.15 83,497.15 83,497.15 0.140 N/A 1 0.10 Sub Total / Average 83,497.15 83,497.15 83,497.15 0.140 1 0.10 99: COP Health Claims Fund Wells Fargo Sweep Cash WFSWEEP Cash 9/15/2010 480,718.66 480,718.66 480,718.66 0.140 N/A 1 0.57 Wells Fargo Cash WF9871 Cash 7/21/2010 380,657.54 380,657.54 380,657.54 0.140 N/A 1 0.45 Sub Total / Average 861,376.20 861,376.20 861,376.20 0.140 1 1.02 Z141: U of H Capital Renewal Fund Wells Fargo Sweep Cash WFSWEEP Cash 9/30/2013 240,127.75 240,127.75 240,127.75 0.140 N/A 1 0.28 Sub Total / Average 240,127.75 240,127.75 240,127.75 0.140 1 0.28 Z145: Municipal Channel Wells Fargo Sweep Cash WFSWEEP Cash 4/15/2012 447,638.43 447,638.43 447,638.43 0.140 N/A 1 0.53 Sub Total / Average 447,638.43 447,638.43 447,638.43 0.140 1 0.53 2200: 2006 Cert of Obligation Wells Fargo Sweep Cash WFSWEEP Cash 6/30/2006 1,821,259.71 1,821,259.71 1,821,259.71 0.140 N/A 1 2.15 Sub Total / Average 1,821,259.71 1,821,259.71 1,821,259.71 0.140 1 2.15 Z201: 2007 Cert of Obligation Wells Fargo Sweep Cash WFSWEEP Cash 8/31/2006 28,768.66 28,768.66 28,768.66 0.140 N/A 1 0.03 Sub Total / Average 28,768.66 28,768.66 28,768.66 0.140 1 0.03 Z202: 2007A Gen Obligation Wells Fargo Sweep Cash WFSWEEP Cash 12/31/2007 606,828.93 606,828.93 606,828.93 0.140 N/A 1 0.72 Celtic Bank D.6 CD15118RJD0 Certificate 6/28/2013 248,000.00 248,000.00 247,796.39 0.600 6/28/2016 637 0.29 6/28/2016 Of Deposit 8of9 3\ 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 / Average 854,828.93 854,828.93 854,625.32 0.273 186 1.01 Z203: 2009 Gen Obligation Wells Fargo Sweep Cash WFSWEEP Cash 10/30/2008 11,629,377.03 11,629,377.03 11,629,377.03 0.140 N/A 1 13.73 Kansas State Bank 0.8 485382DV4 Certificate 10/30/2013 248,000.00 248,000.00 248,634.63 0.800 10/31/2016 762 0.29 10/31/2016 Of Deposit Cathay Bank 0.75 CD149159JE6 Certificate 9/20/2013 248,000.00 248,000.00 248,618.26 0.750 3/21/2016 538 0.29 3/21/2016 Of Deposit Merchant & Certificate Manufacturing Bank 0.35 588339DD0 Of Deposit 2/7/2014 248,000.00 248,000.00 247,919.15 0.350 8/7/2015 311 0.29 8/7/2015 Flushing Bank New York 34387AAH2 Certificate 3/31/2014 248,000.00 248,000.00 247,451.42 0.950 3/31/2017 913 0.29 0.95 3/31/2017 Of Deposit Provident Bank 0.35 743837BF2 Certificate 2/21/2014 248,000.00 248,000.00 247,874.76 0.350 8/21/2015 325 0.29 8/21/2015 Of Deposit FFCB 1.5 1/28/2019 3133EDNF6 FFCB Bond 5/28/2014 1,000,000.00 1,000,000.00 995,721.00 1.500 1/28/2019 1581 1.18 Sub Total / Average 13,869,377.03 13,869,377.03 13,865,596.25 0.283 166 16.37 Z301: W/S Pay As U Go CIP Wells Fargo Sweep Cash WFSWEEP Cash 12/31/2007 1,703,237.38 1,703,237.38 1,703,237.38 0.140 N/A 1 2.01 DeWitt Bank and Trust 0.5 6/20/2016 CD241888BT2 Certificate 6/24/2013 248,000.00 248,000.00 247,835.82 0.500 6/20/2016 629 0.29 Of Deposit Sub Total / Average 1,951,237.38 1,951,237.38 1,951,073.20 0.186 81 2.30 Z302: MUD 4 Capital Programs Wells Fargo Sweep Cash WFSWEEP Cash 2/1/2013 635,216.05 635,216.05 635,216.05 0.140 N/A 1 0.75 Farm Bureau Bank 0.5 307660HH6 Certificate 12/23/2013 248,000.00 248,000.00 248,176.08 0.500 12/23/2015 449 0.29 12/23/2015 Of Deposit Pacific City Bank 0.35 69406PB37 Certificate 12/26/2013 248,000.00 248,000.00 247,954.62 0.350 6/26/2015 269 0.29 6/26/2015 Of Deposit Sub Total / Average 1,131,216.05 1,131,216.05 1,131,346.75 0.265 158 1.34 Total / Average 84,734,308.05 84,725,083.05 84,706,693.56 0.477 344 100 9 of 9 City of Pearland Purchases Portfolio/Report Group: Report Group: Pearland From 6/30/2014 To 9/30/2014 YTM Portfolio Settlement Maturity Face Name Description Bullet/Callable CUSIP/Ticker Action Date Date Price Amount/Shares Cost Principal Interest/Dividends Broker/Dealer 30: Water & FNMA 1.625 3135G0YT4 Buy 7/16/2014 11/27/2018 100.4411 1,000,000.00 1.520 1,004,411.00 2,211.81 Gilford Sewer 11/27/2018 Securities 35: Street Town North Wells Fargo Assessment Bank 0.4 89213TLD2 Buy 7/25/2014 7/24/2015 100 248,000.00 0.400 248,000.00 0.00 Bank 7/24/2015 45: Americanwest Hotel/Motel Bank 0.8 030590DS9 Buy 7/25/2014 1/25/2017 100 248,000.00 0.800 248,000.00 0.00 Wells Fargo Occupancy 1/25/2017 Bank 47: Park & Safra National Rec Bank 0.45 78658QDT7 Buy 7/30/2014 7/30/2015 100 248,000.00 0.450 248,000.00 0.00 Wells Fargo Development 7/30/2015 Bank Carolina 20: Debt Alliance Bank 14376RAK3 Buy 7/30/2014 7/31/2017 100 248,000.00 1.050 248,000.00 0.00 Wells Fargo Services 1.05 Bank 7/31/2017 1 of 1 Bank Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Pledged Collateral Reconciliation Report September 30, 2014 Account Number 201-0419505 201-0419513 001-3042841 179-0121790 807-1613395 818-4567843 280-7409871 Account Name Operating Payroll Fund Sweep Account EMS Payments Credit Card Account Alvin ISD Health Claims Total of Bank Balances Pledged Collateral for City FDIC Insurance Total Collateral Over (Under) Collateralized Total % Collateralized Bank Account Number Account Name Wells Fargo 100-7284258 Development Authority Bank Regions Account Number 6180003939 6180003948 M:\Investments\Investment Reports\City of Pearland\Investment Report - City - Qtr 0914 Total of Bank Balances Pledged Collateral for DAP FDIC Insurance Total Collateral Over (Under) Collateralized Total % Collateralized Amount 55,723,655.70 4,307,788.83 380,657.54 $ 60,412,102.07 79,502,430.65 250,000.00 $ 79,752,430.65 $ 19,340,328.58 132.0% Amount 1,016,477.21 $ 1,016,477.21 8,380,786.25 250,000.00 $ 8,630,786.25 $ 7,614,309.04 849.1% $ 4,300.01 912,154.38 Total of Bank Balances $ 916,454.39 Regions Trust Collateral FDIC Insurance $ 684,783.48 250,000.00 Over (Under) Collateralized' $ Total % Collateralized Total $ Over (Under) Collateralized $ Total % Collateralized Status 18,329.09 102.0% 26,954,637.62 142.2% Collateralized