Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
R-2013-076-2013-06-10
RESOLUTION NO. R2013-76 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS, ACCEPTING THE CITY'S INVESTMENT REPORT FOR THE QUARTER ENDING MARCH 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 March 2013. PASSED, APPROVED, AND ADOPTED this 10th day of June, A.D., 2013. ATTEST: Y TI N G G/ R elf/ SE' RETAR APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY cz==:>)pyyl,n.E.ci TOM REID MAYOR City of Pearland Quarterly Investment Report Dec 31, 2012 - Mar 31, 2013 Portfolio at Dec 31, 2012 Ending Book Value Ending Market Value Accrued Interest Receivable FYD Total Interest Earned Unrealized Gain/(Loss) Change in Unrealized Gain/Loss Weighted Average Maturity Change in Market Value Yield to Maturity at Cost T -Bill Benchmark Agency Note Benchmark $ 100,464,473.77 100,485,235.58 46,170.04 49,924.31 16,400.89 (5,610.88) 107 Days 16,836,871.44 0.20% 0.16% 0.11% Portfolio at Mar 31. 2013 Ending Book Value Ending Market Value Accrued Interest Receivable FYD Total Interest Earned Unrealized Gain/(Loss) Change in Unrealized Gain/Loss Weighted Average Maturity Change in Market Value Yield to Maturity at Cost T -Bill Benchmark Agency Note Benchmark Average for Quarter City's Yield to Maturity 1 Year T -Bill Benchmark Yield Agency Note Benchmark Yield 0.21% 0.15% 0.14% RESOLUTION NO. R2013-76 Exhibit "A" $ 96,039,159.55 96,046,695.73 63,164.36 102,165.40 7,536.18 (8,864.71) 106 Days (4,438,539.85) 0.20% 0.14% 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 Assistant Director of Finance Fatima Uwakwe Accounting Supervisor Summary by Type March 31, 2013 Description Face Amount UShares Cost Value Book Value Market Value YTM @Cost Days To Maturity Cash $ 71,769,257.34 $ 71,769,257.34 $ 71,769,257.34 $ 71,769,257.34 0.14% 1 CD 6,705,577.26 6,705,577.26 6,705,577.26 6,700,602.39 0.42% 413 FFCB 7,500,000.00 7,533,816.03 7,524,143.28 7,526,453.00 0.37% 481 FHLB 4,000,00,1.00 4,138,890.00 4,023,444.61 4,025,890.00 0.42% 333 FHLMC 3,000,000.00 2,996,930.44 2,999,350.38 3,002,934.00 0.32% 336 FNMA 3,000,000.00 3,030,830.00 3,017,386.68 3,021,559.00 0.44% 460 Total/Average $ 95,974,834.60 $ 96,175,301.07 $ 96,039,159.55 $ 96,046,695.73 0.20% 106 FFCB 8% Group Portfolio Holdings by Type FHLMC FHLB 3% 4% FNMA 3% Cash 75% 80,000,000 70,000,000 ....___. 60,000,000 50,000,000 40,000,000 - 30,000,000 - 20,000,000 -- 10,000,000 Book Value by Maturity r- 1- 30 DaYs 31.60 DaYs 61.90 Days91-120 Day1.180 Days > 180 Days Interest Rates Date 1 mo 4 mo 6 mo 1 yr, 2 yr 3 yr jyr 7 yr 10 yr 20 yr 30 yr 12/31/2012 0.02 0.05 0.11 0.16 0.25 0.36 0.72 1.18 1.78 2.54 2.95 3/28/2013 0.04 0.07 0.11 0.14 0.25 0.36 0.77 1.24 1.87 2.71 3.10 3.50 - 3.00 2.50 2.00 1.50 1.00 0.50 0.00 0.35% 0.30% 0.25% 0.20% 0.15% 0.10% 0.05% 0.00% Yield Curve Comparison 1 mo 3 mo 6 mo 1 yr 2 yr 3 yr 5 yr 7 yr 10 yr 20 yr 30 yr --4-12/31/2012 —0-3/28/2013 Portfolio vs. Benchmarks Apr -12 May -12 Jun -12 Jul -12 Aug -12 Sep -12 Oct -12 Nov -12 Dec -12 Jan -13 Feb -13 Mar -13 —4—Port Total –#-1 Yr T -Bill + Agency Note City of Pearland Quarterly Investment Report Report Format: By CUSIP Group By: Security Type Portfolio/Report Group: Report Group: Pearland Begin Date: 12/31/2012, End Date: 3/31/2013 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV CASH Wens Fargo w11790 10: General N/A 71,435.67 0.00 71,435.67 0.00 0.00 0.00 0.00 Cash Fund Wets Fargo WFSWEEP 10: General 0.140 N/A 11,325,075.58 6,113,678.57 1,996,369.32 0.00 0.00 15,442,384.83 5,749.72 Sweep Cash Fund Weis 17: Municpal Wets Fargo Fa gh WFSWEEP Court 0.140 N/A 140,525.16 1,549.02 234.39 0.00 0.00 141,839.79 51.96 SweepSecurity • Wells Fargo 18: City Sweep Cash WFSWEEP Wide 0.140 N/A 72,797.32 6,841.32 0.00 0.00 0.00 79,638.64 28.62 Donation Wells Fargo WFSWEEP 19: Court 0.140 N/A 245,608.83 17,063.34 0.00 0.00 0.00 262,672.17 94.46 Sweep Cash Technology Weds Fargo Debt WFSWEEP 20: 0.140 N/A 18,304,211.78 5,666,175.07 10,582,707.64 0.00 0.00 13,387,679.21 6,539.06 Sweep Cash Services Wells Fargo 23: Court Sweep Cash WFSWEEP Juvenile 0.140 N/A 36,477.07 11,509.83 0.00 0.00 0.00 47,986.90 16.24 Mgmt Welts Fargo WFSWEEP 30: Water & 0.140 N/A 10,037,523.93 3,107,271.42 3,858,798.64 0.00 0.00 9,285,996.71 3,342.08 Sweep Cash Sewer Weds Fargo WFSWEEP 31: 0.140 N/A 443,519.53 5,112.70 79,461.07 0.00 0.00 369,171.16 144.88 Sweep Cash Solidwaste Wells Fargo WFSWEEP 35: Street 0.140 N/A 288,467.00 253,647.86 10,564.50 0.00 0.00 531,550.36 168.16 Sweep Cash Assessment Wells Fargo WFSWEEP 42: Utility 0.140 N/A 4,301,597.91 1,633,942.49 96,640.14 0.00 0.00 5,838,900.26 1,865.06 Sweep Cash Impact Fee Wells Fargo WFSWEEP 43: Regional 0.140 N/A 10,432.48 3.82 0.00 0.00 0.00 10,436.30 3.82 Sweep Cash Detention Welts Fargo 44: Shadow Sweep Cash WFSWEEP Creek 0.140 N/A 1,498,151.56 342,366.47 264,402.55 0.00 0.00 1,576,115.48 564.77 Impact Wells Fargo 45: Sweep Cash WFSWEEP Hotel/Motel 0.140 N/A 1,438,024.03 291,093.15 145,688.91 0.00 0.00 1,583,428.27 547.69 Occupancy I48 Ending Portfolio ¥TM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal . Discount Premium Ending BV Income -BV wells Fargo WFSWEEP 46: Park 0.140 N/A 90,754.94 39,504.88 20,874.65 0.00 0.00 109,385.17 34.81 Sweep Cash Donations Wens Fargo 47: Park & Sweep Cash WFSWEEP Rec 0.140 N/A 601,587.69 75,113.53 1,450.00 0.00 0.00 675,251.22 239.74 Development Wells Fargo WFSWEEP 49: Tree 0.140 N/A 18,488.15 6.03 2,129.95 0.00 0.00 16,364.23 6.03 Sweep Cash Trust Fund Wets Fargo WFSWEEP 50: Capital 0.140 N/A 2,099,412.90 392.80 1,530,974.95 0.00 0.00 568,830.75 392.80 Sweep Cash Projects Wells Fargo WFSWEEP 55: Sidewalk 0.140 N/A 205,432.23 3,352.73 0.00 0.00 0.00 208,784.96 76.73 Sweep Cash Fund Wells Fargo 60: Police Sweep Cash WFSWEEP State 0.140 N/A 237,829.62 6,386.24 31,819.00 0.00 0.00 212,396.86 82.05 Seizure Wets Fargo 62: Federal WFSWEEP 0.140 N/A 32,172.20 11.82 0.00 0.00 0.00 32,184.02 11.82 Sweep Cash Police Fund Wells Fargo 64: 1998 Sweep Cash WFSWEEP Cert of 0.140 N/A 844,592.33 310.54 0.00 0.00 0.00 844,902.87 310.54 Obligation Wens Fargo 67: 2003 Sweep Cash WFSWEEP Revenue 0.140 N/A 8,411,525.71 2,643.73 1,767,955.89 0.00 0.00 6,646,213.55 2,643.73 Bonds Wells Fargo 68: 2001 Sweep Cash WFSWEEP Cert of 0.140 N/A 530,465.60 244,582.12 233,301.15 0.00 0.00 541,746.57 225.06 Obligation Wells Fargo 70: 2005 Sweep Cash WFSWEEP Refunding/ 0.140 N/A 1,846,635.51 584.67 393,103.80 0.00 0.00 1,454,116.38 584.67 Mobility Wells Fargo WFSWEEP 95: Property 0.140 N/A -184,859.46 280,477.25 2,677.48 0.00 0.00 92,940.31 11.20 Sweep Cash liability Wells Fargo 97: y Sweep Cash WFSWEEP Employee 0.140 N/A 25,219.44 15,079.15 32,744.46 0.00 0.00 7,554.13 9.00 Benefit Trust Wells Fargo 99: COP Cash WF9871 Health 0.140 N/A 215,436.87 590,705.16 327,764.28 0.00 0.00 478,377.75 131.98 Claims Fund Wels Fargo 99: COP Sweep Cash WFSWEEP Health 0.140 N/A 449,843.45 158,243.06 239,801.06 0.00 0.00 368,285.45 0.00 Claims Fund Wets Fargo WFSWEEP 2101: Grant 0.140 N/A -12,038.69 39,963.66 18,941.42 0.00 0.00 8,983.55 3.20 Sweep Cash Fund 2 of 8 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV Wens Fargo WFSWEEP Z105: 2007 0.140 N/A 187.63 0.06 0.00 0.00 0.00 187.69 0.06 Sweep Cash CDBG Fund Wefts Fargo WFSWEEP Z106: 2008 0.140 N/A 1.14 0.00 0.00 0.00 0.00 1.14 0.00 Sweep Cash CDBG Fund Wetls Fargo WFSWEEP Z107: 2009 0.140 N/A 15.61 0.00 0.00 0.00 0.00 15.61 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z108: 2010 0.140 N/A 0.05 0.00 0.00 0.00 0.00 0.05 0.00 Sweep Cash CDBG Fund Welts Fargo WFSWEEP Z109: 2011 0.140 N/A -184.24 0.00 0.00 0.00 0.00 -184.24 0.00 Sweep Cash CDBG Fund Weill Fargo WFSWEEP 2110: 2012 0.140 N/A -4,360.92 15,334.84 15,455.74 0.00 0.00 -4,481.82 0.00 Sweep Cash CDBG Fund Wells Fargo Z116: CDBG Sweep Cash WFSWEEP Recovery 0.140 N/A 7.40 0.00 0.00 0.00 0.00 7.40 0.00 Fund Welk Fargo WFSWEEP Z140: U of H 0.140 N/A 16,285.94 6,502.31 555.69 0.00 0.00 22,232.56 7.15 Sweep Cash Fund Welk Fargo Z145: Sweep Cash WFSWEEP Municipal 0.140 N/A 76,871.16 82,939.74 2,332.18 0.00 0.00 157,478.72 52.60 Channel Welk Fargo Z200: 2006 Sweep Cash WFSWEEP Cert of 0.140 N/A 1,600,688.42 579.83 26,685.71 0.00 0.00 1,574,582.54 579.83 Obligation Wens Fargo Z201: 2007 Sweep Cash WFSWEEP Cert of 0.140 N/A 1,580,652.48 504.54 353,479.68 0.00 0.00 1,227,677.34 504.54 Obligation Welk Fargo Z202: Sweep Cash WFSWEEP 2007AGen 0.140 N/A 3,071,873.13 240,193.83 142,255.96 0.00 0.00 3,169,811.00 1,166.01 Obligation Wells Fargo 2203: 2009 Sweep Cash WFSWEEP Gen 0.140 N/A 2,041,849.46 595.18 826,107.74 0.00 0.00 1,216,336.90 595.18 Obligation Welts Fargo WFSWEEP Pa Z30 1: W/S Sweep Cash As U Go 0.140 N/A 1,895,572.41 198,930.88 127,618.75 0.00 0.00 1,966,884.54 682.71 CIP Wens Fargo Z302: MUD Sweep Cash WFSWEEP 4 Capital 0.140 N/A 0.00 1,886,062.69 271,472.63 0.00 0.00 1,614,590,06 0.00 Programs Sub Total/Average 0.140 73,905,806.01 21,339,256.33 23,475,805.00 0.00 0.00 71,769,257.34 27,467.96 _3 (A'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 Cash CERTIFICATE OF DEPOSIT First Commercial 31984GCN7 10: General 0.300 8/30/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 122.30 Bank 0.3 Fund 8/30/2013 Synovus Bank 10: General GA 0.5 87164DBV1 Fund 0.500 11/28/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 305.75 11/28/2014 BBCN Bank LA CD073296AT2 10: General 0.250 2/7/2014 0.00 248,000.00 0.00 0.00 0.00 248,000.00 86.63 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 739.73 6/19/2014 Fund CDARS 0.5 CD1014682593 10: General 0.500 12/19/2013 500,000.00 0.00 0.00 0.00 0.00 500,000.00 616.44 12/19/2013 Fund Discover Bank CD254671KH2 10: General 0.500 2/20/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 132.49 0.5 2/20/2015 Fund Gorham 10: General Savers Bank CD383052CN5 Fund 0.250 2/6/2014 0.00 248,000.00 0.00 0.00 0.00 248,000.00 90.03 0.25 2/6/2014 Moody National 10: General Bank 0.5 CD7130 Fund 0.500 5/30/2013 245,577.26 0.00 0.00 0.00 0.00 245,577.26 302.76 5/30/2013 Southwest 10: General Bank Ft Worth CD844772AA1 Fund 0.300 2/27/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 65.22 0.3 2/27/2015 21ST CENTURY 10: General 0.25 CD90136SFD3 Fund 2/13/2013 248,000.00 0.00 248,000.00 0.00 0.00 0.00 74.74 2/13/2013 Valley Bank 10: General Roanoke 0.3 CD91935VANO Fund 0.300 7/30/2014 0.00 248,000.00 0.00 0.00 0.00 248,000.00 122.30 7/30/2014 FARMERS & MERCHANTS CD307812HH3 20: Debt 2/15/2013 248,000.00 0.00 248,000.00 0.00 0.00 0.00 78.14 0.25 Services 2/15/2013 Key Bank Ohio 20: Debt 0.35 CD49306SRE8 Services 0.350 8/27/2014 0.00 248,000.00 0.00 0.00 0.00 248,000.00 76.10 8/27/2014 4of8 Ending Portfolio YTM C4 Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV Mechanics Savings Bank CD583686BB5 20: Debt 2/28/2014 0.00 248,000.00 248,000.00 0.00 0.00 0.00 33.97 0.25 Services 2/28/2014 Mechanics Savings Bank CD583686BC3 20: Debt 0.350 3/20/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 26.16 0.35 Services 3/20/2015 AMERICAN NATIONAL CD02771PKZ9 30: water8 0.250 5/3/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 152.88 BANK 0.25 Sewer 5/3/2013 Bay Cities Bank 30: Water & 0.5 CD07203QBR2 Sewer 0.500 12/12/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 305.76 12/12/2014 REAL BANK 0.3 CD07370TKX0 30: Water & 2/13/2013 248,000.00 0.00 248,000.00 0.00 0.00 0.00 89.69 2/13/2013 Sewer CDARS0.5 CD1013981856 30: Water>i 0.500 6/20/2013 500,000.00 0.00 0.00 0.00 0.00 500,000.00 616.44 6/20/2013 Sewer Goldman Sachs 30: Water 8 Bank 0,6 C0381473AA0 Sewer 0.600 2/20/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 158.99 2/20/2015 SAFRA NATIONAL C0786580350 30: Water A 0.600 5/5/2014 248,000.00 0.00 0.00 0.00 0.00 248,000.00 366.90 BANK 0.6 Sewer 5/5/2014 DISCOVER 35: Street BANK 0.25 CD2546703U4 Assessment 2/15/2013 248,000.00 0.00 248,000.00 0.00 0.00 0.00 78.14 2/15/2013 BMW Bank of 42: Utility NA 0.85 CD05568P2Q9 Impact Fee 0.850 6/8/2015 248,000.00 0.00 0.00 0.00 0.00 248,000.00 519.78 6/8/2015 Sterfeig Savings 42: Utility Bank 0.35 CD8595316A8 Impact Fee 0.350 2/23/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 87.99 2/23/2015 GOLDMAN 44: Shadow SACHS 0.25 CD3B143AJZ9 Creek 2/15/2013 248,000.00 0.00 248,000.00 0.00 0.00 0.00 78.14 2/15/2013 Impact Sovereign Bank 44: Shadow 0.2 7/30/2013 CD84603M3N4 Creek 0.200 7/30/2013 0.00 248,000.00 0.00 0.00 0.00 248,000 A0 81.53 Impact 5 of 8 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV First Natial Bank 45: WI0.25 CD321086FE5 HotevMotel 0.250 1/31/2014 0.00 248,000.00 0.00 0.00 0.00 248,000.00 100.90 1/31/2014 Occupancy KEY BANK 0.25 45: 2/15/2013 CD49306SPEO Hotel/Motel 2/15/2013 248,000.00 0.00 248,000.00 0.00 0.00 0.00 78.14 Occupancy PACIFIC 47: Park & CONTINENTAL CD69413CCQO Rec 2/15/2013 248,000.00 0.00 248,000.00 0.00 0.00 0.00 78.14 0.25 Development 2/15/2013 Ashevile 67: 2003 Savings Bank CD04407RAI0 Revenue 0.350 3/27/2015 0.00 248,000.00 0.00 0.00 0.00 248,000.00 73.72 0.35 Bonds 3/27/2015 MIZUHO CORP 67: 2003 MNK 0.3 CD60688TBR9 Revenue 0.300 5/2/2013 248,000.00 0.00 0.00 0.00 0.00 248,000.00 183.45 5/2/2013 Bonds PRIVATE BANK 68: 2001 0.25 CD74269TBK2 Cert of 2/15/2013 248,000.00 0.00 248,000.00 0.00 0.00 0.00 78.14 2/15/2013 Obligation 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 214.03 12/3/2014 Mobility APPLE BANK 0.3 Z202: 2/22J2013 CD037830FX9 2007A Gen 2/22/2013 248,000.00 0.00 248,000.00 0.00 0.00 0.00 108.02 Obfgation Sub Total/Average Certificate Of Deposit FFCB BOND FFCB 0.75 5/2/2013 FFCB 0.32 3/12/2015-12 FFCB 0.3 7/18/2014 FFCB 0.25 12/24/2014 FFCB 0.25 1/30/2014-12 6 of 8 31331K)Q4 3133EAU30 3133EAYL6 3133ECAV6 3133EAA73 10: General Fund 10: General Fund 10: General Fund 20: Debt Services 30: water & Sewer 0.422 5,961,577.26 3,224,000.00 2,480,000.00 0.00 0.00 6,705,577.26 6,323.54 0.750 5/2/2013 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,875.00 0.320 3/12/2015 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 800.00 0.285 7/18/2014 1,000,231.21 0.00 0.00 0.00 -37.36 1,000,193.85 712.64 0.273 12/24/2014 0.00 999,560.00 0.00 40.41 0.00 999,600.41 477.91 1/30/2014 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 298.61 Ending Portfolio YTM @ Maturity Amortized Amortized Investment Description CUSIP/Ticker Name Cost Date Beginning BV Buy Principal Sell Principal Discount Premium Ending BV Income -BV FFCB 0.3 3133EA3U0 42: Utility 0.300 1/9/2015 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 750.00 1/9/2015-13 Impact Fee FFCB 0.34 3133EAM14 42: Utikty 4/23/2014 1,000,000.00 0.00 1,000,000.00 0.00 0.00 0.00 538.34 4/23/2014-12 Impact Fee FFCB 2.125 67: 2003 2/10/2014 313311DY6 Revenue 0.230 2/10/2014 1,531,440.97 0.00 0.00 0.00 -7,091.95 1,524,349.02 876.80 Bonds FFCB 0.48 67: 2003 12/26/2014-13 3133EAV14 Revenue 0.480 12/26/2014 1,000,000.00 Bonds 0.00 0.00 0.00 0.00 1,000,000.00 1,200.00 Sub Total/Average FFCB Bond FHLB BOND FHLB 3.625 5/29/2013 FHLB 1.15 10/30/2014 FHLB 3.625 5/29/2013 FHLB 1.81 3/26/2013 3133XQU34 3133743W8 3133XQU34 3133XWGP8 FHLB 0.32 313381G58 12/26/2014-13 10: General Fund 30: Water & Sewer 30: Water & Sewer 42: Utility Impact Fee 67: 2003 Revenue Bonds 0.366 8,531,672.18 999,560.00 2,000,000.00 40.41 -7,129.31 7,524,143.28 7,529.30 0.530 5/29/2013 1,012,707.48 0.00 0.00 0.00 -7,675.66 1,005,031.82 1,386.84 0.300 10/30/2014 1,015,497.47 0.00 0.00 0.00 -2,116.50 1,013,380.97 758.50 0.530 5/29/2013 1,012,707.48 0.00 0.00 0.00 -7,675.66 1,005,031.82 1,386.84 3/26/2013 1,003,700.22 0.00 1,000,000.00 0.00 -3,700.22 0.00 573.39 0.320 12/26/2014 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 800.00 Sub Total/Average 0.423 5,044,612.65 0.00 1,000,000.00 0.00 -21,168.04 4,023,444.61 4,905.57 FHLB Bond FHLMC BOND FHLMC 0 4/1/2013 FHLMC 0.375 4/28/2014 FHLMC 0.35 12/5/2014 313397DU2 10: General Fund 3134G3S87 10: General Fund 67: 2003 3134G3H78 Revenue Bonds Sub Total/Average 7 orb 0.173 4/1/2013 999,570.28 0.467 4/28/2014 998,793.21 0.330 12/5/2014 1,000,383.99 0.00 0.00 0.00 0.323 2,998,747.48 0.00 0.00 425.00 0.00 999,995.28 425.00 0.00 227.70 0.00 999,020.91 1,165.20 0.00 0.00 -49.80 1,000,334.19 825.20 0.00 652.70 -49.80 2,999,350.38 2,415.40 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 FHLMC Bond FNMA BOND FNMA 0.75 10: General 2/26/2013 Fund FNMA 0.5 10: General 10/30/2014-13 Fund FNMA 1.3 30: Water & 11/17/2014 Sewer FNMA 1.05 10/22/2013 3135GOAK9 3136GOFF3 3136FPWZ6 31398A4S8 30: Water & Sewer 2/26/2013 1,000,873.02 0.00 1,000,000.00 0.00 -873.02 0.00 272.81 0.500 10/30/2014 1,000,000.00 0.00 0.00 0.00 0.00 1,000,000.00 1,250.00 0.462 11/17/2014 1,015,632.99 0.00 0.00 0.00 -2,081.32 1,013,551.67 1,168.68 0.361 10/22/2013 1,005,552.18 0.00 0.00 0.00 -1,717.17 1,003,835.01 907.83 Sub Total/Average 0.441 4,022,058.19 0.00 1,000,000.00 0.00 -4,671.51 3,017,386.68 3,599.32 FNMA Bond Total / Average 8 oi'S 0.205 100,464,473.77 25,562,816.33 29,955,805.00 693.11 -33,018.66 96,039,159.55 52,241.09 Cly of Pearland Quarterly Investment Report at Quarterend Report Format: By Transaction Group By: Security Type Portfolio/Report Group: Report Group: Pearland As of 3/31/2013 Portfolio Settlement Maturity YTM @ Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Cash Welts Fargo WFSWEEP 10: General 5/31/2006 Sweep Cash Fund Wells Fargo 17: Municipal Sweep Cash WFSWEEP Court 5/31/2006 Security Wells Fargo 18: City Sweep Cash WFSWEEP Wide 5/31/2006 Donation Wells Fargo WFSWEEP 19: Court 5/31/2006 Sweep Cash Technology Wells Fargo WFSWEEP 20: Debt 5/31/2006 Sweep Cash Services WellsFargo 23: Court Sweep Cash WFSWEEP Juvenile 9/15/2009 Mgmt Wetls Fargo WFSWEEP 30: Water & 5/31/2006 Sweep Cash Sewer Wens Fargo WFSWEEP 31: 12/1/2006 Sweep Cash Sofidwaste Wells Fargo WFSWEEP 35: Street 5/31/2006 Sweep Cash Assessment Wells Fargo WFSWEEP 42: Utility 5/31/2006 Sweep Cash Impact Fee Wells Fargo WFSWEEP 43: Regional 5/31/2006 Sweep Cash Detention Wells Fargo 44: Shadow Sweep Cash WFSWEEP Creek 5/31/2006 Impact Wells Fargo 45: Sweep Cash WFSWEEP HoteVMotel 5/31/2006 Occupancy Wells Fargo WFSWEEP 46: Park 5/31/2006 Sweep Cash Donations Wells Fargo 47: Park & Sweep Cash WFSWEEP Rec 5/31/2006 1 of 6 N/A 0.140 15,442,384.83 15,442,384.83 15,442,384.83 15,442,384.83 1 16.09 N/A 0.140 141,839.79 141,839.79 141,839.79 141,839.79 1 0.15 N/A 0.140 79,638.64 79,638.64 79,638.64 79,638.64 1 0.08 N/A 0.140 262,672.17 262,672.17 262,672.17 262,672.17 1 0.27 N/A 0.140 13,387,679.21 13,387,679.21 13,387,679.21 13,387,679.21 1 13.95 N/A 0.140 47,986.90 47,986.90 47,986.90 47,986.90 1 0.05 N/A 0.140 9,285,996.71 9,285,996.71 9,285,996.71 9,285,996.71 1 9.68 N/A 0.140 369,171.16 369,171.16 369,171.16 369,171.16 1 0.38 N/A 0.140 531,550.36 531,550.36 531,550.36 531,550.36 1 0.55 N/A 0.140 5,838,900.26 5,838,900.26 5,838,900.26 5,838,900.26 1 6.08 N/A 0.140 10,436.30 10,436.30 10,436.30 10,436.30 1 0.01 N/A 0.140 1,576,115.48 1,576,115.48 1,576,115.48 1,576,115.48 1 1.64 N/A 0,140 1,583,428.27 1,583,428.27 1,583,428.27 1,583,428.27 1 1.65 N/A 0.140 109,385.17 109,385.17 109,385.17 109,385.17 1 0.11 N/A 0.140 675,251.22 675,251.22 675,251.22 675,251.22 1 0.70 Portfolio Settlement Maturity YTM t/i Face Days To Accrued % of Description CUSIP/Tkker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Devebpment Weis Fargo49: Tree WFSWEEP 5/31/2006 N/A 0.140 16,364.23 16,364.23 16,364.23 16,364.23 0.72 Sweep Cash Trust Fund Weis Fargo WFSWEEP 50: Capatal 5/31/2006 N/A 0.140 568,830.75 568,830.75 568,830.75 568,830.75 1 0.59 Sweep Cash Projects Welk Fargo WFSWEEP 55: Sdewak 5/31/2006 N/A 0.140 208,784.96 208,784.96 208,784.96 208,784.96 1 0.22 Sweep Cash Fund Welk Fargo 60: Poke Sweep Cash WFSWEEP State 5/31/2006 N/A 0.140 212,396.86 212,396.86 212,396.86 212,396.86 1 0.22 Seizure wells Fargo WFSWEEP 62: Federal 5/31/2006 N/A 0.140 32,184.02 32,184.02 32,184.02 32,184.02 1 0.03 Sweep Cash Police Fund Welk Fargo 64: 1998 Sweep Cash WFSWEEP Cert of 5/31/2006 N/A 0.140 844,902.87 844,902.87 844,902.87 844,902.87 1 0.88 Obligation Welk Fargo 67: 2003 Sweep Cash WFSWEEP Revenue 5/31/2006 N/A 0.140 6,646,213.55 6,646,213.55 6,646,213.55 6,646,213.55 1 6.92 Bonds Wells Fargo 68: 2001 Sweep Cash WFSWEEP Cert of 5/31/2006 N/A 0.140 541,746.57 541,746.57 541,746.57 541,746.57 1 0.56 Obligation Welk Fargo 70: 2005 Sweep Cash WFSWEEP Refunding / 5/31/2006 N/A 0.140 1,454,116.38 1,454,116.38 1,454,116.38 1,454,116.38 1 1.52 Mobdty Welk Fargo WFSWEEP 95: Property 10/31/2006 N/A 0.140 92,940.31 92,940.31 92,940.31 92,940.31 1 0.10 Sweep Cash Liability Welts Fargo 97: Sweep Cash WFSWEEP Empbyee 9/1/2007 N/A 0.140 7,554.13 7,554.13 7,554.13 7,554.13 1 0.01 Benefit Trust Welk Fargo 99: COP Sweep Cash WFSWEEP Heath 9/15/2010 N/A 0.140 368,285.45 368,285.45 368,285.45 368,285.45 1 0.38 Claims Fund Wells Fargo 99: COP Cash WF9871 Heath 7/21/2010 N/A 0.140 478,377.75 478,377.75 478,377.75 478,377.75 1 0.50 Claims Fund Welk Fargo WFSWEEP 2101: Grant 5/31/2006 N/A 0.140 8,983.55 8,983.55 8,983.55 8,983.55 1 0.01 Sweep Cash Fund Welk Fargo WFSWEEP 2105: 2007 5/1/2007 N/A 0.140 187.69 187.69 187.69 187.69 1 0.00 Sweep Cash CDBG Fund Welk Fargo WFSWEEP Z106: 2008 3/15/2009 N/A 0.140 1.14 1.14 1.14 1.14 1 0.00 Sweep Cash CDBG Fund 2 of 6 Portfolio Settlement Maturity YTM @ Face Days To Accrued Woof Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost ValueBook Value Market Value Maturity Interest Portfolio Wells Fargo WFSWEEP Z107: 2009 11/1/2009 N/A 0.140 15.61 15.61 15.61 15.61 1 0.00 Sweep Cash CDBG Fund Welts Fargo WFSWEEP 2108: 2010 11/1/2010 N/A 0.140 0.05 0.05 0.05 0.05 1 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z109: 2011 12/1/2011 N/A 0.140 -184.24 -184.24 -184.24 -184.24 1 0.00 Sweep Cash CDBG Fund Wells Fargo WFSWEEP Z110: 2012 11/15/2012 N/A 0.140 -4,481.82 -4,481.82 -4,481.82 -4,481.82 1 0.00 Sweep Cash CDBG Fund Welk Fargo Z116: CDBG Sweep Cash WFSWEEP Recovery 7/31/2009 N/A 0.140 7.40 7.40 7.40 7.40 1 0.00 Fund Wells Fargo Z140: U of H Sweep Cash WFSWEEP Fund 12/1/2009 N/A 0.140 22,232.56 2 2,232.56 22,232.56 22,232.56 1 0.02 Wells Fargo Z145: Sweep Cash WFSWEEP Municipal 4/15/2012 N/A 0.140 157,478.72 157,478.72 157,478.72 157,478.72 1 0.16 Channel Welts Fargo Z200: 2006 Sweep Cash WFSWEEP Cert of 6/30/2006 N/A 0.140 1,574,582.54 1,574,582.54 1,574,582.54 1,574,582.54 1 1.64 Obligation Wells Fargo Z201: 2007 Sweep Cash WFSWEEP Cert of 8/31/2006 N/A 0.140 1,227,677.34 1,227,677.34 1,227,677.34 1,227,677.34 1 1.28 Obligation Wells Fargo Z202: Sweep Cash WFSWEEP 2007AGen 12/31/2007 N/A 0.140 3,169,811.00 3,169,811.00 3,169,811.00 3,169,811.00 1 3.30 Obligation Wells Fargo Z203: 2009 Sweep Cash WFSWEEP Gen 10/30/2008 N/A 0.140 1,216,336.90 1,216,336.90 1,216,336.90 1,216,336.90 1 1.27 Obligation Wells Fargo Z301: W/S Sweep Cash WFSWEEP Pay As U Go 12/31/2007 N/A 0.140 1,966,884.54 1,966,884.54 1,966,884.54 1,966,884.54 1 2.05 CIP Wells Fargo Z302: MUD Sweep Cash WFSWEEP 4 Capital 2/1/2013 N/A 0.140 1,614,590.06 1,614,590.06 1,614,590.06 1,614,590.06 1 1.68 Programs Sub Total / 0.140 71,769,257.34 71,769,257.34 71,769,257.34 71,769,257.34 1 0.00 74.78 Average Certificate Of Deposit Moody National 10: General Bank 0.5 CD7130 Fund 11/30/2012 5/30/2013 0.500 245,577.26 245,577.26 245,577.26 245,577.26 60 407.05 0.26 5/30/2013 Valley Bank 10: General Roanoke 0.3 CD91935VANO Fund 1/30/2013 7/30/2014 0.300 248,000.00 248,000.00 248,000.00 247,470.52 486 122.30 0.26 3 Of 6 Portfolio Settlement Maturity YTM @ Face Days To Accrued % of Description CUSIP/Tk3cer Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio 7/30/2014 BBCN Bank LA C0073296AT2 10: General 2/8/2013 2/7/2014 0.250 248,000.00 248,000.00 248,000.00 247,526.82 313 39.07 0.26 0.25 2/7/2014 Fund CDARS 0.5 C01014682593 10: General 12/20/2012 12/19/2013 0.500 500,000.00 500,000.00 500,000.00 500,000.00 263 691.78 0.52 12/19/2013 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,183.83 698 8.15 0.26 0.3 2/27/2015 CDARS 0.6 CD1013981872 10: General 6/21/2012 6/19/2014 0.600 500,000.00 500,000.00 500,000.00 500,000.00 445 739.73 0.52 6/19/2014 Fund Gorham 10: General Savings Bank CD383052CN5 Fund 2/6/2013 2/6/2014 0.250 248,000.00 248,000.00 248,000.00 247,385.95 312 42.47 0.26 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,211.86 691 132.49 0.26 0.5 2/20/2015 Fund Synovus Bank 10: General GA 0.5 87164DBV1 Fund 11/30/2012 11/28/2014 0.500 248,000.00 248,000.00 248,000.00 248,720.69 607 411.07 0.26 11/28/2014 Fast Commercial 31984GCN7 10: General 8/30/2012 8/30/2013 0.300 248,000.00 248,000.00 248,000.00 247,875.26 152 0.00 0.26 Bank 0.3 Fund 8/30/2013 Key Bank Ohio 20: Debt 0.35 CD49306SRE8 Services 2/27/2013 8/27/2014 0.350 248,000.00 248,000.00 248,000.00 247,602.95 514 76.10 0.26 8/27/2014 Mechanics Savings Bank CD583686BC3 20: Debt3/20/2013 3/20/2015 0.350 248,000.00 248,000.00 248,000.00 246,907.81 719 26.16 0.26 0.35 Services 3/20/2015 CDARS 0.5 30: Water & 6/20/2013 CD1013981856 Sewer 8/1/2012 6/20/2013 0.500 500,000.00 500,000.00 500,000.00 500,000.00 81 1,938.36 0.52 Goldman Sachs 30: Water& Bank 0.6 CD381471AA0 Sewer 2/20/2013 2/20/2015 0.600 248,000.00 248,000.00 248,000.00 246,935.83 691 158.99 0.26 2/20/2015 SAFRA NATIONAL CD786580)50 30: Water & 8/1/2012 5/5/2014 0.600 248,000.00 248,000.00 248,000.00 248,887.59 400 603.35 0.26 BANK 0.6 Sewer 5/5/2014 Bay Cities Bank 30: Water & 0.5 CD07203QBR2 Sewer 12/12/2012 12/12/2014 0.500 248,000.00 248,000.00 248,000.00 248,705.06 621 64.55 0.26 12/12/2014 AMERICAN NATIONAL CD02771PKZ4 30: Water & 5/3/2012 5/3/2013 0.250 248,000.00 248,000.00 248,000.00 247,968.26 33 563.95 0.26 BANK 0.25 Sewer 4 of Portfolio Settlement Maturity YTM 4 Face Days To Accrued % of Description CUSIP/Ticker Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio 5/3/2013 Sterling Savrngs 42: Ut6ty Bank 0.35 CD8595316A8 Impact Fee 2/22/2013 2/23/2015 0350 248,000.00 248,000.00 248,000.00 247,199.46 694 87.99 0.26 2/23/2015 BMW Bank of 42: Ut6ty NA 0.85 C0055681320 Impact Fee 12/7/2012 6/8/2015 0.850 248,000.00 248,000.00 248,000.00 248,596.19 799 658.39 0.26 6/8/2015 Sovereign Bank 44: Shadow 0.2 7/30/2013 CD84603M3N4 Creek 1/30/2013 7/30/2013 0.200 248,000.00 248,000.00 248,000.00 247,837.31 121 81.53 0.26 Impact First Natial Bank 45: WI0.25 CD321086FE5 Hotei/Motel 1/31/2013 1/31/2014 0.250 248,000.00 248,000.00 248,000.00 247,413.73 306 50.96 0.26 1/31/2014 Occupancy Asheville 67: 2003 Savings Bank CD04407RAI0 Revenue 2/28/2013 3/27/2015 0.350 248,000.00 248,000.00 248,000.00 246,855.73 726 7.13 0.26 0.35 3/27/2015 Bonds MIZUHO CORP 67: 2003 BANK 0.3 CD60688TBR9 Revenue 5/2/2012 5/2/2013 0.300 248,000.00 248,000.00 248,000.00 248,024.06 32 678.77 0.26 5/2/2013 Bonds Frst 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,716.22 612 66.59 0.26 12/3/2014 Mobility Sub Total / 0.422 6,705,577.26 6,705,577.26 6,705,577.26 6,700,602.39 413 7,656.93 6.99 Average FFCB Bond FFCB 0.32 3133EAU30 10: General 10/31/2012 3/12/2015 0.320 1,000,000.00 1,000,000.00 1,000,000.00 1,000,017.00 711 168.89 1.04 3/12/2015-12 Fund FFCB 0.3 3133EAYL6 10: General 8/1/2012 7/18/2014 0.285 1,000,000.00 1,000,293.48 1,000,193.85 1,000,953.00 474 608.33 1.04 7/18/2014 Fund FFCB 0.75 31331KJQ4 10: General 5/2/2011 5/2/2013 0.750 1,000,000.00 1,000,000.00 1,000,000.00 1,000,559.00 32 3,104.17 1.04 5/2/2013 Fund FFCB 0.25 Debt 3133ECAV6 20: 1/28/2013 12/24/2014 0.273 1,000,000.00 999,560.00 999,600.41 999,415.00 633 673.61 1.04 12/24/2014 Services FFCB 0.3 3133EA3U0 42: 11/29/2012 1/9/2015 0.300 1,000,000.00 1,000,000.00 1,000,000.00 1,000,015.00 649 683.33 1.04 1/9/2015-13 Impact Fee FFCB 0.48 67: 2003 12/26/2014-13 3133EAVJ4 Revenue 6/26/2012 12/26/2014 0.480 1,000,000.00 1,000,000.00 1,000,000.00 1,000,978.00 635 1,266.67 1.04 Bonds FFCB 2.125 67: 2003 2/10/2014 313311DY6 Revenue 11/29/2012 2/10/2014 0.230 1,500,000.00 1,533,962.55 1,524,349.02 1,524,516.00 316 4,515.63 1.56 Bonds 5 of 6 Portfolio Settlement Maturity YTM a Face Days To Accrued % of Description CUSIP/Tidier Name Date Date Cost Amount/Shares Cost Value Book Value Market Value Maturity Interest Portfolio Sub Total / 0.367 7,500,000.00 7,533,816.03 7,524,143.28 7,526,453.00 481 11,020.63 7.81 Average FHLB Bond FHLB 3.625 5/29/2013 FHLB 1.15 10/30/2014 FHLB 3.625 5/29/2013 3I33XQU34 3133743W8 3I33XQU34 FHLB 0.32 313381658 12/26/2014-13 10: General Fund 30: Water& Sewer 30: Water & Sewer 67: 2003 Revenue Bonds Sub Total / Average FHLMC Bond FHLMC 0 4/1/2013 FHLMC 0.375 4/28/2014 FHLMC 0.35 12/5/2014 Sub Total / Average FNMA Bond 313397DU2 10: General Fund 3134G3587 10: General Fund 67: 2003 3134G3H78 Revenue Bonds FNMA 0.5 3136GOFF3 10/30/2014-13 FNMA 1.05 10/22/2013 FNMA 1.3 11/17/2014 31398A4S8 3136FPWZ6 Sub Total / Average 10: General Fund 30: Water & Sewer 30: Water & Sewer 5/31/2011 5/29/2013 0.530 1,000,000.00 1,061,320.00 1,005,031.82 1,005,821.00 59 12,284.72 1.04 11/29/2012 10/30/2014 0.300 1,000,000.00 1,016,250.00 1,013,380.97 1,013,875.00 578 4,791.67 1.04 5/31/2011 5/29/2013 0.530 1,000,000.00 1,061,320.00 1,005,031.82 1,005,821.00 59 12,284.72 1.04 12/26/2012 12/26/2014 0.320 1,000,000.00 1,000,000.00 1,000,000.00 1,000,373.00 635 844.44 1.04 0.420 4,000,000.00 4,138,890.00 4,023,444.61 4,025,890.00 333 30,205.55 4.17 4/26/2012 4/1/2013 0.173 1,000,000.00 998,394.44 999,995.28 1,000,000.00 1 0.00 1.04 3/27/2012 4/28/2014 0.467 1,000,000.00 998,100.00 999,020.91 1,001,869.00 393 1,593.75 1.04 9/27/2012 12/5/2014 0.330 1,000,000.00 1,000,436.00 1,000,334.19 1,001,065.00 614 1,127.78 1.04 0.323 3,000,000.00 2,996,930.44 2,999,350.38 3,002,934.00 336 2,721.53 3.13 5/1/2012 10/30/2014 0.500 1,000,000.00 1,000,000.00 1,000,000.00 1,000,260.00 578 2,083.33 1.04 3/27/2012 10/22/2013 0.361 1,000,000.00 1,010,780.00 1,003,835.01 1,004,637.00 205 4,637.50 1.04 6/20/2012 11/17/2014 0.462 1,000,000.00 1,020,050.00 1,013,551.67 1,016,662.00 596 4,838.89 1.04 0.441 3,000,000.00 3,030,830.00 3,017,386.68 3,021,559.00 460 11,559.72 3.13 Total / Average 6 of 6 0,204 95,974,834.60 96,175,301.07 96,039,159.55 96,046,695.73 106 63,164.36 100 City of Pearland City of Pearland - by Fund Report Format: By Transaction Group By: Portfolio Name Portfolio/Report Group: Report Group: Pearland As of 3/31/2013 Security Settlement Face Date Amount/Shares Description CUSIP/Ticker Type 10: General Fund Wells Fargo Sweep Cash FHLMC 0 4/1/2013 FFCB 0.75 5/2/2013 FHLB 3.625 5/29/2013 Moody National Bank 0.5 5/30/2013 First Commercial Bank 0.3 8/30/2013 CDARS 0.5 12/19/2013 Gorham Savings Bank 0.25 2/6/2014 BBCN Bank LA 0.25 2/7/2014 FHLMC 0.375 4/28/2014 CDARS 0.6 6/19/2014 FFCB 0.3 7/18/2014 Valley Bank Roanoke 0.3 7/30/2014 FNMA 0.5 10/30/2014-13 Synovus Bank GA 0.5 11/28/2014 Discover Bank 0.5 2/20/2015 1 of YTM @ Maturity Days To % of Book Value Market Value Cost Date Maturity Portfolio WFSWEEP Cash 5/31/2006 15,442,384.83 15,442,384.83 15,442,384.83 0.140 313397DU2 31331K1Q4 3133XQU34 CD7130 31984GCN7 CD1014682593 CD383052CN5 CD073296AT2 3134G3SB7 N/A FHLMC Bond 4/26/2012 1,000,000.00 999,995.28 1,000,000.00 0.173 4/1/2013 FFCB Bond 5/2/2011 1,000,000.00 1,000,000.00 1,000,559.00 0.750 5/2/2013 FHLB Bond 5/31/2011 1,000,000.00 1,005,031.82 1,005,821.00 0.530 5/29/2013 11/30/2012 245,577.26 245,577.26 245,577.26 0.500 5/30/2013 Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit Certificate Of Deposit 8/30/2012 248,000.00 248,000.00 247,875.26 0.300 8/30/2013 12/20/2012 500,000.00 500,000.00 500,000.00 0.500 12/19/2013 2/6/2013 248,000.00 248,000.00 247,385.95 0.250 2/6/2014 2/8/2013 248,000.00 248,000.00 247,526.82 0.250 2/7/2014 FHLMC Bond 3/27/2012 1,000,000.00 999,020.91 1,001,869.00 0.467 4/28/2014 6/21/2012 500,000.00 500,000.00 500,000.00 0.600 6/19/2014 FFCB Bond 8/1/2012 1,000,000.00 1,000,193.85 1,000,953.00 0.285 7/18/2014 1/30/2013 248,000.00 248,000.00 247,470.52 0.300 7/30/2014 FNMA Bond 5/1/2012 1,000,000.00 1,000,000.00 1,000,260.00 0.500 10/30/2014 11/30/2012 248,000.00 248,000.00 248,720.69 0.500 11/28/2014 CD1013981872 Certificate Of Deposit 3133EAYL6 CD91935VANO Certificate Of Deposit 3136GOFF3 87164DBV1 CD254671KH2 Certificate Of Deposit Certificate Of Deposit 2/20/2013 248,000.00 248,000.00 1 16.09 1 1.04 32 1.04 59 1.04 60 0.26 152 0.26 263 0.52 312 0.26 313 0.26 393 1.04 445 474 0.52 1.04 486 0.26 578 1.04 607 0.26 247,211.86 0.500 2/20/2015 691 0.26 Security Settlement Face YTM @ Maturity Days To 0/0 of Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio 2/27/2013 248,000.00 248,000.00 247,183.83 0.300 2/27/2015 698 0.26 Description CUSIP/Ticker Type Southwest Bank Ft Worth 0.3 2/27/2015 FFCB 0.32 3/12/2015-12 CD844772AA1 3133EAU30 Certificate Of Deposit FFCB Bond 10/31/2012 1,000,000.00 1,000,000.00 1,000,017.00 0.320 3/12/2015 711 1.04 Sub Total / Average 17: Municipal Court Security Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 25,423,962.09 25,428,203.95 25,430,816.02 0.254 141,839.79 141,839.79 141,839.79 0.140 N/A 135 26.49 1 0.15 Sub Total J Average 18: City Wide Donation Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 141,839.79 141,839.79 141,839.79 0.140 79,638.64 79,638.64 79,638.64 0.140 N/A 1 0.15 Sub Total / Average 19: Court Technology Wells Fargo Sweep Cash WFSWEEP Cash 5/31/2006 79,638.64 79,638.64 79,638.64 0.140 262,672.17 262,672.17 262,672.17 0.140 Sub Total / Average 20: Debt Services Wells Fargo Sweep Cash Key Bank Ohio 0.35 8/27/2014 WFSWEEP Cash CD49306SRE8 FFCB 0,25 12/24/2014 3133ECAV6 Mechanics Savings CD583686BC3 Bank 0.35 3/20/2015 Certificate Of Depost FFCB Bond Certificate Of Deposit 262,672.17 262,672.17 262,672.17 0.140 5/31/2006 13,387,679.21 13,387,679.21 13,387,679.21 0.140 2/27/2013 1/28/2013 3/20/2013 248,000.00 1,000,000.00 248,000.00 248,000.00 999,600.41 248,000.00 247,602.95 999,415.00 246,907.81 Sub Total / Average 23: Court Juvenile Mgmt Wells Fargo Sweep Cash Sub Total J Average 2 of9 WFSWEEP Cash 9/15/2009 N/A N/A 0.350 8/27/2014 0.273 12/24/2014 0.350 3/20/2015 14,883,679.21 14,883,279.62 14,881,604.97 0.156 47,986.90 47,986.90 47,986.90 47,986.90 47,986.90 0.140 47,986.90 0.08 1 0.08 0.27 N/A 1 0.27 1 13.95 514 0.26 633 1.04 719 0.26 64 15.51 1 0.05 0.140 1 0.05 Security Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio 30: Water & Sewer Wels Fargo Sweep WFSWEEP Cash 5/31/2006 9,285,996.71 9,285,996.71 9,285,996.71 0.140 N/A 1 9.68 Cash AMERICAN NATIONAL CD02771PKZ9 Certificate Of 5/3/2012 248,000.00 248,000.00 247,968.26 0.250 5/3/2013 33 0.26 BANK 0.25 5/3/2013 Deposit FHLB 3.625 5/29/2013 3133XQU34 FHLB Bond 5/31/2011 1,000,000.00 1,005,031.82 1,005,821.00 0.530 5/29/2013 59 1.04 CDARS 0.5 6/20/2013 CD1013981856 Ce�fi to Of 8/1/2012 500,000.00 500,000.00 500,000.00 0.500 6/20/2013 81 0.52 it FNMA 1.05 31398A4S8 FNMA Bond 3/27/2012 1,000,000.00 1,003,835.01 1,004,637.00 0.361 10/22/2013 205 1.04 10/22/2013 SAFRA NATIONAL BANK CD786580150 Certificate Of 8/1/2012 248,000.00 248,000.00 248,887.59 0.600 5/5/2014 400 0.26 0.6 5/5/2014 Deposit FHLB 1.15 10/30/2014 3133743W8 FHLB Bond 11/29/2012 1,000,000.00 1,013,380.97 1,013,875.00 0.300 10/30/2014 578 1.04 FNMA 1.3 11/17/2014 3136FPWZ6 FNMA Bond 6/20/2012 1,000,000.00 1,013,551.67 1,016,662.00 0.462 11/17/2014 596 1.04 Bay Cities Bank 0.5 CD07203QBR2 Certificate Of 12/12/2012 248,000.00 248,000.00 248,705.06 0.500 12/12/2014 621 0.26 12/12/2014 Deposit Goldman Sachs Bank CD381471AA0 Certificate Of 2/20/2013 248,000.00 248,000.00 246,935.83 0.600 2/20/2015 691 0.26 0.6 2/20/2015 Deposit Sub Total / Average 14,777,996.71 14,813,796.18 14,819,488.45 0.249 130 15.40 31: Soldwaste Wells Fargo Sweep • Cash WFSWEEP Cash 12/1/2006 369,171.16 369,171.16 369,171.16 0.140 N/A 1 0.38 Sub Total / Average 369,171.16 369,171.16 369,171.16 0.140 1 0.38 35: Street Assessment Wehs Fargo Sweep WFSWEEP Cash 5/31/2006 531,550.36 531,550.36 531,550.36 0.140 N/A 1 0.55 Cash Sub Total / Average 42: Utilty Impact Fee Wells Fargo Sweep Cash 531,550.36 531,550.36 531,550.36 0.140 1 0.55 WFSWEEP Cash 5/31/2006 5,838,900.26 5,838,900.26 5,838,900.26 0.140 N/A 1 6.08 FFCB 0.3 1/9/2015-13 3133EA3U0 FFCB Bond 11/29/2012 1,000,000.00 1,000,000.00 1,000,015.00 0.300 1/9/2015 649 1.04 3 of 9 Sean-ity Settlement Face YTM @ Maturity Days To % of Description CUSIP/Ticker Type Date Amount/Shares Book Value Market Value Cost Date Maturity Portfolio Sterling Savings Bank CD8595316A8 Certificate Of 2/22/2013 2.48,000.00 248,000.00 247,199.46 0.350 2/23/2015 694 0.26 0.35 2/23/2015 Depost BMW Bank of NA 0.85 CD05568P2Q9 Certificate Of 12/7/2012 248,000.00 248,000.00 248,596.19 0.850 6/8/2015 799 0.26 6/8/2015 Deposit Sub Total / Average 7,334,900.26 7,334,900.26 7,334,710.91 0.193 140 7.64 43: Regional Detention Welts Fargo Sweep WFSWEEP Cash 5/31/2006 10,436.30 10,436.30 10,436.30 0.140 N/A 1 0.01 Cash Sub Total / Average 10,436.30 10,436.30 10,436.30 0.140 1 0.01 44: Shadow Creek Impact Wells Fargo Sweep WFSWEEP Cash 5/31/2006 1,576,115.48 1,576,115.48 1,576,115.48 0.140 N/A 1 1.64 Cash Sovereign Bank 0.2 CD84603M3N4 Certificate Of 1/30/2013 248,000.00 248,000.00 247,837.31 0.200 7/30/2013 121 0.26 7/30/2013 Deposit Sub Total / Average 1,824,115.48 1,824,115.48 1,823,952.79 0.148 17 1.90 45: Hotel/Motel Occupancy We Fargo Sweep WFSWEEP Cash 5/31/2006 1,583,428.27 1,583,428.27 1,583,428.27 0.140 N/A 1 1.65 Cash First Natial Bank WI CD321086FE5 Certificate Of 1/31/2013 248,000.00 248,000.00 247,413.73 0.250 1/31/2014 306 0.26 0.25 1/31/2014 Deposit Sub Total / Average 1,831,428.27 1,831,428.27 1,830,842.00 0.155 42 1.91 46: Park Donations Wets Fargo Sweep WFSWEEP Cash 5/31/2006 109,385.17 109,385.17 109,385.17 0.140 N/A 1 0.11 Cash Sub Total / Average 109,385.17 109,385.17 109,385.17 0.140 1 0.11 47: Park & Rec Development Wets Fargo Sweep WFSWEEP Cash 5/31/2006 675,251.22 675,251.22 675,251.22 0.140 N/A 1 0.70 Cash Sub Total / Average 675,251.22 675,251.22 675,251.22 0.140 1 0.70 49: Tree Trust Fund 4 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 Weis Fargo Sweep WFSWEEP Cash 5/31/2006 16,364.23 16,364.23 16,364.23 0.140 N/A 1 0.02 Cash Sub Total / Average 16,364.23 16,364.23 16,364.23 0.140 1 0.02 50: Capital Projects Wells Fargo Sweep WFSWEEP Cash 5/31/2006 568,830.75 568,830.75 568,830.75 0.140 N/A 1 0.59 Cash Sub Total / Average 568,830.75 568,830.75 568,830.75 0.140 1 0.59 55: Sidewalk Fund Weis Fargo Sweep WFSWEEP Cash 5/31/2006 208,784.96 208,784.96 208,784.96 0.140 N/A 1 0.22 Cash Sub Total / Average 208,784.96 208,784.96 208,784.96 0.140 1 0.22 60: Police State Seizure Wei Fargo Sweep WFSWEEP Cash 5/31/2006 212,396.86 212,396.86 212,396.86 0.140 N/A 1 0.22 Cash Sub Total / Average 212,396.86 212,396.86 212,396.86 0.140 1 0.22 62: Federal Police Fund Weis Fargo Sweep WFSWEEP Cash 5/31/2006 32,184.02 32,184.02 32,184.02 0.140 N/A 1 0.03 Cash Sub Total / Average 32,184.02 32,184.02 32,184.02 0.140 1 0.03 64: 1998 Cert of Obligation Wets Fargo Sweep WFSWEEP Cash 5/31/2006 844,902.87 844,902.87 844,902.87 0.140 N/A 1 0.88 Cash Sub Total / Average 844,902.87 844,902.87 844,902.87 0.140 1 0.88 67: 2003 Revenue Bonds Weis Fargo Sweep WFSWEEP Cash 5/31/2006 6,646,213.55 6,646,213.55 6,646,213.55 0.140 N/A 1 6.92 Cash MIZUHO CORP BANK CD60688TBR9 Certificate Of 5/2/2012 248,000.00 248,000.00 248,024.06 0.300 5/2/2013 32 0.26 0.3 5/2/2013 Deposit FFCB 2.125 2/10/2014 31331)DY6 FFCB Bond 11/29/2012 1,500,000.00 1,524,349.02 1,524,516.00 0.230 2/10/2014 316 1.56 5 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 0.35 3134G3H78 FHLMC Bond 9/27/2012 1,000,000.00 1,000,334.19 1,001,065.00 0.330 12/5/2014 614 1.04 12/5/2014 FHLB 0.32 313381G58 FHLB Bond 12/26/2012 1,000,000.00 1,000,000.00 1,000,373.00 0.320 12/26/2014 635 1.04 12/26/2014-13 FFCB 0.48 3133EAV34 FFCB Bond 6/26/2012 1,000,000.00 1,000,000.00 1,000,978.00 0.480 12/26/2014 635 1.04 12/26/2014-13 Asheville Savings Bank CD04407RA30 Certificate Of 2/28/2013 248,000.00 248,000.00 246,855.73 0.350 3/27/2015 726 0.26 0.35 3/27/2015 Depost Sub Total / Average 68: 2001 Cert of Obligation Wells Fargo Sweep Cash WFSWEEP Cash 11,642,213.55 11,666,896.76 11,668,025.34 0.220 219 12.13 5/31/2006 541,746.57 541,746.57 541,746.57 0.140 N/A 1 0.56 Sub Total / Average 541,746.57 70: 2005 Refunding / Mobility 541,746.57 541,746.57 0.140 1 0.56 Well Fargo Sweep WFSWEEP Cash 5/31/2006 1,454,116.38 1,454,116.38 1,454,116.38 0.140 N/A 1 1.52 Cash Furst State Bank WV CD33648FHR9 Certificate Of 12/3/2012 248,000.00 248,000.00 248,716.22 0.350 12/3/2014 612 0.26 0.35 12/3/2014 Depost Sub Total/ Average 1,702,116.38 1,702,116.38 1,702,832.60 0.171 90 1.77 95: Property Liability Weis Fargo Sweep WFSWEEP Cash 10/31/2006 92,940.31 92,940.31 92,940.31 0.140 N/A 1 0.10 Cash Sub Total / Average 92,940.31 97: Employee Benefit Trust Wells Fargo Sweep Cash 92,940.31 92,940.31 0.140 1 0.10 WFSWEEP Cash 9/1/2007 7,554.13 7,554.13 7,554.13 0.140 N/A 1 0.01 Sub Total / Average 99: COP Health Claims Fund 7,554.13 7,554.13 7,554.13 0.140 1 0.01 Welts Fargo Sweep WFSWEEP Cash 9/15/2010 368,285.45 368,285.45 368,285.45 0.140 N/A 1 0.38 Cash Wells Fargo Cash WF9871 Cash 7/21/2010 478,377.75 478,377.75 478,377.75 0.140 N/A 1 0.50 6 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 Sub Total / Average 846,663.20 846,663.20 846,663.20 0.140 1 0.88 Z101: Grant Fund Welts Fargo Sweep WFSWEEP Cash 5/31/2006 8,983.55 8,983.55 8,983.55 0.140 N/A 1 0.01 Cash Sub Total / Average 8,983.55 8,983.55 8,983.55 0.140 1 0.01 Z105: 2007 CDBG Fund Wets Fargo Sweep WFSWEEP Cash 5/1/2007 187.69 187.69 187.69 0.140 N/A 1 0.00 Cash Sub Total / Average 187.69 2106: 2008 CDBG Fund Wets Fargo Sweep Cash WFSWEEP Cash 3/15/2009 187.69 187.69 0.140 1.14 1.14 1 0.00 1.14 0.140 N/A 1 0.00 Sub Total / Average 1.14 Z107: 2009 CDBG Fund Wells Fargo Sweep Cash Sub Total / Average WFSWEEP Cash 1.14 1.14 0.140 1 0.00 11/1/2009 15.61 15.61 15.61 0.140 N/A 1 0.00 Z108: 2010 CDBG Fund Wei Fargo Sweep Cash 15.61 15.61 15.61 0.140 1 0.00 WFSWEEP Cash 11/1/2010 0.05 0.05 0.05 0.140 N/A 1 0.00 Sub Total / Average 0.05 Z109: 2011 CDBG Fund Wens Fargo Sweep Cash 0.05 0.05 0.140 1 0.00 WFSWEEP Cash 12/1/2011 -184.24 -184.24 -184.24 0.140 N/A 1 0.00 Sub Total / Average -184.24 2110: 2012 CDBG Fund Wens Fargo Sweep Cash 7of9 -184.24 -184.24 0.140 1 0.00 WFSWEEP Cash 11/15/2012 -4,481.82 -4,481.82 -4,481.82 0.140 N/A 1 0.00 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 -4,481.82 7116: CDBG Recovery Fund Wens Fargo Sweep Cash Sub Total / Average 7140: U of 11 Fund Wets Fargo Sweep Cash -4,481.82 -4,481.82 0.140 1 0.00 WFSWEEP Cash 7/31/2009 7.40 7.40 7.40 0.140 N/A 1 0.00 7.40 7.40 7.40 0.140 1 0.00 WFSWEEP Cash 12/1/2009 22,232.56 22,232.56 22,232.56 0.140 N/A 1 0.02 Sub Total / Average 22,232.56 22,232.56 22,232.56 0.140 1 0.02 Z145: Municipal Channel Wells Fargo Sweep WFSWEEP Cash 4/15/2012 157,478.72 157,478.72 157,478.72 0.140 N/A 1 0.16 Cash Sub Total / Average 157,478.72 7200: 2006 Cert of Obligation Wells Fargo Sweep Cash 157,478.72 157,478.72 0.140 1 0.16 WFSWEEP Cash 6/30/2006 1,574,582.54 1,574,582.54 1,574,582.54 0.140 N/A 1 1.64 Sub Total / Average 1,574,582.54 1,574,582.54 1,574,582.54 0.140 Z201: 2007 Cert of Obligation Welk Fargo Sweep Cash 1 1.64 WFSWEEP Cash 8/31/2006 1,227,677.34 1,227,677.34 1,227,677.34 0.140 N/A 1 1.28 Sub Total / Average 1,227,677.34 1,227,677.34 1,227,677.34 0.140 Z202: 2007A Gen Obligation Wens Fargo Sweep Cash 1 1.28 WFSWEEP Cash 12/31/2007 3,169,811.00 3,169,811.00 3,169,811.00 0.140 N/A 1 3.30 Sub Total / Average 3,169,811.00 3,169,811.00 3,169,811.00 0.140 7203: 2009 Gen Obligation Wells Fargo Sweep Cash Aof9 WFSWEEP Cash 1 3.30 10/30/2008 1,216,336.90 1,216,336.90 1,216,336.90 0.140 N/A 1 1.27 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 1,216,336.90 1,216,336.90 1,216,336.90 0.140 1 1.27 Z301: W/S Pay As U Go CIP Wells Fargo Sweep Cash Sub Total / Average WFSWEEP Cash 12/31/2007 1,966,884.54 1,966,884.54 1,966,884.54 0.140 Z302: MUD 4 Capital Programs Wells Fargo Sweep Cash Sub Total / Average WFSWEEP Cash N/A 1,966,884.54 1,966,88434 1,966,884.54 0.140 1 2.05 1 2.05 2/1/2013 1,614,590.06 1,614,590.06 1,614,590.06 0.140 N/A 1 1.68 1,614,590.06 1,614,590.06 1,614,590.06 0.140 1 1.68 Total / Average 95,974,834.60 96,039,159.55 96,046,695.73 0.204 106 100 9 of 9 City of Pearland Purchases Portfolio/Report Group: Report Group: Pearland From 12/31/2012 To 3/31/2013 YTM Portfolio Settlement Maturity Face Name Description Bullet/Callable CUSIP/Ticker Action Date Date Price Amount/Shares Cost Principal Interest Dividends Broker/Dealer 20: Debt FFCB 0.25 Services 12/24/2014 10: Valley Bank General Roanoke Fund 0.3 7/30/2014 44: Shadow Creek Impact Sovereign Bank 0.2 7/30/2013 45: First Natial HoteVMotel Bank WI 0.25 Occupancy 1/31 1/31/2014 10: General Fund Gorham Savings Bank 0.25 2/6/2014 10: BBCN Bank General LA 0.25 Fund 2/7/2014 30: Water & Sewer Goldman Sachs Bank 0.6 2/20/2015 10: Discover General Bank 0.5 Fund 2/20/2015 Sterling 42: Utility Savings Impact Fee Bank 0.35 2/23/2015 10 -Southwest General Bank Ft Fund Worth 0.3 2/27/2015 1 oft 3133ECAV6 Buy 1/28/2013 12/24/2014 99.956 1,000,000.00 0.273 999,560.00 236.11 CD91935VANO Buy 1/30/2013 7/30/2014 100 248,000.00 0.300 248,000.00 CD84603M3N4 Buy 1/30/2013 7/30/2013 100 248,000.00 0.200 248,000.00 CD321086FE5 Buy 1/31/2013 1/31/2014 100 248,000.00 0.250 248,000.00 CD383052CN5 Buy 2/6/2013 2/6/2014 100 248,000.00 0.250 248,000.00 CD073296AT2 Buy 2/8/2013 2/7/2014 100 248,000.00 0.250 248,000.00 CD38147JAA0 Buy 2/20/2013 2/20/2015 100 248,000.00 0.600 248,000.00 CD254671KH2 Buy 2/20/2013 2/20/2015 100 248,000.00 0.500 248,000.00 CD8595316A8 Buy 2/22/2013 2/23/2015 100 248,000.00 0.350 248,000.00 CD844772AA1 Buy 2/27/2013 2/27/2015 100 248,000.00 0.300 248,000.00 SAMCO Capital Markets 0.00 Wells Fargo Bank 0.00 Wells Fargo Bank 0.00 Welts Fargo Bank 0.00 Wells Fargo Bank 0,00 Wells Fargo Bank 0.00 Wells Fargo Bank 0.00 Wells Fargo Bank 0.00 Wells Fargo Bank 0.00 None YTM Portfolio Settlement Maturity Face @ Name Description Bullet/Callable CUSIP/Ticker Action Date Date Price Amount/Shares Cost Principal Interest/Dividends Broker/Dealer Key Bank Weld Fargo SeryDebt Ohio 035 CD493065RE8 Buy 2/27/2013 8/27/2014 100 248s,000.00 0.350 248,000.00 0.00 Bank 8/27/2014 Mechanics 20: Debt Savings CD583686BB5 Buy 2/28/2013 2/28/2014 100 248,000.00 0.250 248,000.00 0.00 Wanly Fargo Services Bank 0.25 Bank 2/28/2014 67:2003 Asheville Revenue Savings CD04407RA)0 Buy 2/28/2013 3/27/2015 100 248,000.00 0.350 248,000.00 0.00 welts Fargo Bonds Bank 0.35 Bank 3/27/2015 Mechanics 20: Debt Savings CD583686BC3 Buy 3/20/2013 3/20/2015 100 248,000.00 0.350 248,000.00 0.00 Wells Fargo Services Bank 0.35 Bank 3/20/2015 2 of 2 Bank Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Pledged Collateral Reconciliation Report March 31, 2013 Account Number 201-0419505 201-041 951 3 01-3042841 1-9-0121790 807-1613395 8' 8-4567843 001-3043112 2r0-7409871 865-9860145 Bank Account Number Wells Fargo 100-7284258 I:\Investments\Investment Reports\City of Pearland\in, estment Report - City - Qtr 0313 Account Name Operating Payroll Fund Sweep Account EMS Payments Credit Card Account Alvin ISD PEDC Sales Tax Health Claims BC MUD #4 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 $ Over (Under) Collateralized Total % Collateralized Status Amount 83,432,146.88 446,045.16 319,150.17 4,517,072.17 478,377.15 1.43 $ 89,192,792.96 109, 786,188.62 250,000.00 $ 110,036,188.62 $ 20,843,395.66 123.4% Amount 1, 008, 554.08 $ 1,008,554.08 6,538,051.42 250,000.00 $ 6,788,051.42 $ 5,779,497.34 673.0% $ 26,622,893.00 129.5% Collateralized