Loading...
HomeMy WebLinkAboutR2008-101 2008-07-28RESOLUTION NO. R2008-101 A RESOLUTION OF THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS, ACCEPTING THE CITY'S INVESTMENT REPORT FOR THE QUARTER ENDING JUNE 2008. BE IT RESOLVED BY THE CITY COUNCIL OF THE CITY OF PEARLAND, TEXAS: Section 1. That the City Council hereby accepts the City's Investment Report for the Quarter ending JUNE 2008. PASSED, APPROVED, AND ADOPTED this 28`h day of July, A.D., 2008. )7ca TOM REID MAYOR ATTEST: APPROVED AS TO FORM: DARRIN M. COKER CITY ATTORNEY Resolution No. R2008-101 City of Pearland Quarterly Investment Report March 31, 2008 - June 30, 2008 Portfolio as of March 31, 2008 Beginning Book Value Beginning Market Value Unrealized Gain/(Loss) Weighted Average Maturity $ 218,563,105.15 218,696,139.10 133,033.95 12 Days Average Yield to Maturity Average Yield of 23 Day Disc Agency Note Average Yield of 1 Year T -Bill 2.41% 2.30% 2.07% Portfolio as of June 30, 2008 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 $ 191,803,217.69 191,832,265.09 8,541.85 5,200,956,49 29,047.40 (103,986.55) 23 Days (26,863,874.01) 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: \\00,L Claire Manthei Director of Finance Rick 0 rd Assistant irect r of Finance Summary by Type Date: 6/30/2008 Description Face Amount \ Shares Cost Value Book Value Market Value Cash $ 166,689,122.22 $ 166,689,122.22 $ 166,689,122.22 $ 166,689,122.22 FNMA 3,000,000.00 2,975,803.33 2,977,771.97 2,977,500.00 FHLB 2,000,000.00 1,993,240.00 1,993,424.80 1,994,380.00 FHLMC 16,500,000.00 16,168,889.58 16,284,835.83 16,313,200.00 CD 3,858,062.87 3,858,062.87 3,858,062.87 3,858,062.87 Total/Average $ 192,047,185,09 $ 191,685418.00 $ 191,803,217.69 $ 191,832,265.09 FHLB 1% FNMA 2% Group Portfolio Holdings co by Type 2% FHLMC 8% Cash 87% 5180,000,000.00 $160,000,000.00 $140,000,000.00 $110,000,000.00 5100,000,000.00 580,000,000.00 560,000,000.00 540,000,000.00 520,000,000.00 50.00 Book Value by Maturity 1-30Dys 31-600ays 61-90 Days 91- 120 Days 121. 180 Days >180 Days Interest Rates Date 1 mo Imo 6 mo lyr Lw Lir Lir flx 20 yr Bar_ 3/31/2008 1.22 1.38 1.51 1.55 1.62 1.79 2.46 2.88 3.45 4.30 4.30 6/30/2008 1.60 1.90 2.17 2.36 2.63 2.91 3.34 3.61 3.99 4.59 4.53 Yield Curve Comparison 5.00 4.50 - 4.00 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 6.00 5.00 4.00 3.00 2.00 1.00 City's Portfolio YTM 2.41% 23 Day WAM.. lmo 3mo 6mo 1yr 2yr 3yr 5yr Tyr 10 yr 20 yr 30 yr 13/31/2008 t 6/30/2008 Portfolio vs. Benchmarks JOSS° 1Jfj° ,�P #� hSI° a'S 03 c �c0 v0 �c0 Qc0 Sao J�01J$ ,�0 QA 00 �0 10 ,oP6 q0, �0 �aP9' , FP 1 Y, cf o to c 1 11 1 p �}' o" 2 O°' 1 Q 1` P 1P 1 -4-Port Total -4- 1 Year T -bill -»- Disc Agency Note Group Portfolio Holdings City of Pearland Pearland Date: 06/30/2008 City of Pearland: By Fund Grouped By: Portfolio Name Averaged By: Face Amount \ Shares Description Cusip Type Settlement Date Face Amount \ Shares Book Value Market Value VIM @ Cast Maturity Date Days To Maturity Portfolio Percent 10:General Fund FHLMC 012/08/08 313396553 FHLMC 2,000,000.00 51,965.008.38 51.977,600.00 4.0481 12/8/2008 161 1.04 FHLMC 012/31/08 313396V42 FHLMC 3,000.000.00 52.960,356.71 52.961,600.00 2.6637 12/31/2006 184 1.56 Capital 2.3403/02/09 C01099394 CD 1,665,132.34 51665,132.34 51,665,132.34 2.34 3/2/2009 245 0.87 Capital 2.6910/27/08 001099397 CD 367,809.20 5367,809.20 5367,809.20 2.69 10/27/2008 119 0.19 Wells Fa Var. Cash WF5WEEP Cash 9,843,493.77 59,843,493.77 59.843.49377 2.34 7/1/200B 1 5.13 Total ID: General Fund 16,876,435.31 $16,801,800.40 $16,815,635.31 2.6076 79 8.79 17: Munldpal Court Security Wells Fa Var. Cash WFSWEEP Cash 132,302.16 5132,302.16 5132,302.16 2.34 7/1/2008 0.07 Total 17: Municipal Court Security 132,302.16 5132,302.16 5132.302.16 2.34 ] 0.07 18: City Wide Donation Wells Fa Var. Cash WFSWEEP Cash 51.93875 551,938.75 551,938.75 2.34 7/1/2005 1 0.03 Total IR: City Wide Donation 51,938.75 $51,938.75 551,938.75 2.34 1 0.03 19: Court Technology Wells Fa Var. Cash WFSWEEP Cash 285,726.28 5285.726.28 5285,726.28 2.34 7/1/2008 1 0.15 Total 19: Court Technology 285,726.28 5285,726.28 5285,726.28 2.34 1 0.15 20: Debt Services FHLMC 008/18/08 313396[50 FIILMC 2000000.00 51,989,289.19 51,994,000.00 4.0217 8/18/2008 49 304 Wells Fa Var. Cash WFSWEEP Cash 11.102,333.04 511,102,333.04 511,102,33304 2.34 7/1/2008 1 5.78 Total20: Debt Services 13,102,333.04 513,091,622.23 $13,096,333.04 2.5967 8 6.82 30: Water & Sewer FIILMC 012/08/08 313396553 FHLMC 1.000,000.00 5982,504.19 5588,800.00 4.0481 12/8/2008 161 0.52 Capital 2.3403/03/09 CD1099395 CD 46,426.54 546,426.54 546.426.54 2.34 3/3/2009 246 0.02 Wells Fa Var. Cash WF5WEEP Cash 5,191.002.34 55,191,002.34 55.191,002.34 2.34 7/1/2008 1 2.7 Total 30: Water & Sewer 6,237,428.88 56,219,933.07 $6,226,22&88 26139 28 3.25 31:Solidwoste Wells Fa Var. Cash WFSWEEP Cash -398,395.51 15398395.91 15398.395.511 2.34 7/1/2008 1 -0.21 Total 31: 5olidwoste 398,395.51 (5398,395.51) (5399,395.51) 2.34 1 -0.21 35: Street Assessment Capital 2.7208/08/08 C01242224673 CD 57,049.67 557049.67 557,049.67 2.72 8/8/2008 39 0.03 Wells Fe Var. Cash WFSWEEP Cash 688,596.33 5688,596.33 5688,596.33 2.34 7/1/2008 1 0.36 Total 35:Street Assessment 745,646.00 5745,646.00 5745,646.00 2.3691 4 0.39 42: Utility impact Fee Wells Fa Var. Cash WF5WEEP Cash 2,625,117.63 52,625,117.63 52,625,117.63 2.34 7/1/2008 1 1.37 Total 42: Utility Impact Fee 2,625,117.63 52,625,117.63 52,625,117,63 2.34 1 1.37 43: Regional Detention Wells Fa Var, Cash WF5WEEP Cash 115,833.54 5115,833.54 5115,833.54 2.34 7/1/2008 1 0.06 Total 43:Regional Detention 115,833.54 5115,833.54 5115,833.54 2.34 1 0.06 44: Shadow Creek Import FNMA 010/20/08 313588145 FNMA 3,000,000.00 52,977,771.97 52,977.50000 2.4393 10/20/2008 112 1.56 Wells Fa Var. Cash WF5WEEP Cash 5,262,193.76 55,262,193.76 55,262,19376 2.34 7/1/2008 1 2.74 Total 44: Shadow Creek Impact 8,262,133.76 $8,239,965.73 $8,239,693.76 2.3761 41 4.3 45: Hotel/Motel Occupancy Wells Fa Var. Cash WFSWEEP Cash 1,090,560.76 51,090,560.76 51.090,560.76 2.34 7/1/2008 1 0,57 Total 45: Hotel/Motel Occupancy 1,090,560.76 51,090,560.76 51,090,560.76 2.34 1 0.57 46: Pork Donations Wells Fa Var. Cash WFSWEEP Cash 16,930.39 516,930.39 516,930.39 2.34 7/1/2006 1 0.01 Total 46: Park Donations 16,930.39 516,930.39 516,930.39 2.34 1 0.01 47: Park & Re: Development Wells Fa Var. Cash WFSWEEP Cash 1,242,600.09 51,242,600.09 51.242,600.09 2.34 7/1/2008 1 0.65 Toted47: Pork & Rec Development 1,242,600.09 51,242,60009 51,242,600.09 2.34 1 0.65 49: Tree Trust Fund Wells Fa Var. Cash WFSWEEP Cash 196,471.20 5196,471,20 5196,471.20 2.34 7/1/2008 1 0.1 Total 49: Tree Trust Fund 196,471.20 5196,471.20 5196,471.20 2.34 1 0.1 Group Portfolio Holdings City of Pearland Peariand Date: 06/30/2008 City of Pearland: Type of Investment Grouped By: Type Averaged By: Face Amount \ Shares Description Cusip Portfolio Name Fate Amount\Shares Cost Value Book Value Market value Y' Cast Maturity Date Days To Maturity Accrued Interest Portfolio Percent Cash Welh Fa Vat. Cash WFSWEEP 10: General Fund $ 9343.493.77 S 9943493.77 5 9.643.493.77 5 9,43,493.77 2.34 7/1/2008 I 50.00 5.13 Wells Fa Vat. Cash WFSWEEP 17: MunkbalCourt Security 132,302.16 132,302.16 13230216 132,302.16 2.34 7/1/2005 1 $000 0.07 Wefts Fa Var. Cash WFSWEEP 18: City Wide Donation 51.930.75 51.938.75 53.938.75 53,931.75 2.34 7/1/2008 I 50.00 0.03 Wells Fa Vat. Cash WFSWEEP 19: Court Technology 285,726.28 215.72618 2&5,726.29 215,71.28 234 7/1/2008 1 $0.00 0.11 Walls Ft Vat. Cash WFSWEEP 20: Debt Senoras 11,102,333.04 14102333.4 11,102,333.4 11.102333.04 2.34 711/2005 1 50.00 5.76 Wells Fa Var. Cash WFSWEEP 30: Water & Sewer 5,9100234 5.19100334 5,191002.34 5,191,002.34 2.34 7/1/2008 1 50.00 2.70 Wells Fa Var. Cash WFSWEEP 31: Solldwaste 098995911 091,395311 (34.395.511 1398395311 2.34 7/1/204 1 50.00 .0.21 wails Fa Var. Cash WFSWEEP 35: Strut Assessment 613,596.33 61859633 68839633 6459633 2.34 7/1/104 1 50.00 0.35 Wells Fa Var. Cash WFSWEEP 42: Utility Impact Fee 2.625.117.63 2,625,117.63 2515,117.63 1.6+3,117.63 094 7/1/2008 0 50.00 137 Wells Fe Vr.Cash WFSWEEP 43: Regional Detention 115,83354 115,83354 115,833.54 1/593334 2.34 7/1/2008 1 50.00 0.06 Wells Fe Vet. Cash WFSWEEP 44: Shadow Creek Impact 5,12.193.76 5,262,193.75 5,262,193.76 5,292,193.76 2.34 1/7/204 1 50.00 2.74 Wells Fa Var. Cash WFSWEEP 45: Hotel/Motel Occupancy 1,090,560.78 1,090560,76 1090560.76 1,090,560.76 2.34 7/1/204 1 50.00 0.57 Wells Fa Var. Cash WFSWEEP 46. Park Donations 16930.39 16330.39 16,930.39 16930.35 2.34 7/1/2008 1 50.00 001 Wells Fa Var. Cash WFSWEEP 47: Park & Rec Development 1.242900.09 1.2426004 1.242.600.09 4242.600.09 234 7/1/204 1 5000 065 Wells Fa Var. Cash WFSWEEP 49: Tree Trust Fund 196,471.20 196,471_20 196,471.20 196,471.20 234 7/1/2008 1 50.00 0,10 Walls Pa Var. Cash WFSWEEP 50 Capital Peelens 4,775,999.25 4,775,599.25 4,775,999.25 4.775.999.1 2.34 7/1/204 1 50.4 2.49 Welts Fa Var. Cash WFSWEEP 55: Sidewalk Fund 177,365.51 177,35538 177365.51 177,365.58 2.34 7/1/204 1 $0.00 0.09 wells Fe Var. Cash WFSWEEP 60: Poke State Seizure 91.744.91 91.744.99 91.744.99 91,744.99 2.14 7/1/2008 1 50.00 005 Wells Fa Var. Cash WFSWEEP 61: Federal Pollee Fund 29,437.97 29.437.97 1037.97 1.437.97 2.34 7/1/204 1 50.00 1,02 Wets Fa Var. Cash WFSWEEP 64: 194 Certificate/0 (201.537.951 120153]951 1201537951 001537.951 234 7(1/204 1 50.00 .0.10 Wells Fa Var. Cash WFSWEEP 67: 243 Revenue Bonds 9.904.307,09 9.94,307.09 15,943074 13,904307.09 2.34 7/3/1008 I 50.00 8.28 Wells Fe Var. Cash WFSWEEP 68: 2001 Certificate/0 15,192.43.4 15,192,083.63 15,192.43.83 15.192.01313 234 7/1/2008 1 50.00 7.91 webs Fe Var. Cask WFSWEEP 702005 Refunding/Mobley 37.677308.4 37,677300.4 37,677,301.4 37,67734.04 234 7/1/2009 1 50.00 19.62 Wells Fa Var. Cash WFSWEEP 71: 2005 Relundbg/Drain 522,9556 522,9536 522,155.56 522.155.56 2.34 7/1/2008 1 50.00 0.27 Walls Fa Var. Cash WFSWEEP 95: Property UabWly (101.462.761 001,462.76) (101.462.76) 001062.161 2.34 7/1/2009 1 50.00 .0.05 Wells Fa Vet. Cads WFSWEEP 97: Employee Benefit Trost 04,162.301 (74.162.301 7426235L (74,162.30) 234 7/1/2009 1 50.00 0.04 Wells Fe Var. Cash WFSWEEP 2101:Grant Fund 51,647.04 51,47.4 51.64704 51.47.4 734 7/1/2005 1 50.00 0.03 Wells Pa Vat. Gait WFSWEEP 2105:Community Developmem (39.293.351 139,213.36) (39363.361 (39,213361 2.34 7/1/204 1 50.00 .0.02 Walls Pa Var. Cash WFSWEEP 210: 2006 Cemlote/0 6,941,174.00 6,41,174.00 6.841,174.00 6.41,174.00 134 7/1/204 1 SO.Oa 336 Walls Fa Var. Cash WFSWEEP Z201: 2007 CertIwte/0 20,686151.96 1,64.151.96 20,688,91.96 20.669,9196 2.34 7/1/2008 1 Sams 10.77 Walls Fa Var. Cash WFSWEEP 2202: GO Series 20074 27.051,456.85 27.051.456.85 27.051,456.85 27,051.45615 234 7/1/204 1 50.00 14.09 Wells Fa Var. Cash WFSWEEP 2301: W/5 Pay As U GO OP 656.031.91 ' 656.031.91 556,031.91 656,031.91 234 7/1/2008 1 50.00 0.34 Total Cash 166,689,12222 166,669]2222 166,689,122.22 166,689,122.22 231 1 $0.00 8640 Co Capital 2.3403/01/4 001099394 10 General Fund 1,655,132.34 1,45,13234 1.665,132.34 1.665,13234 234 3/2/1009 745 5164.77 0.87 Capital 2.6900/27/4 CD1099397 10: General Fund 367.49.20 367,809.10 36;84.20 35709.20 2.59 10/27/2009 119 5432 0.19 Capital 2.3403/03/09 C01099395 30 Water& Sewer 46,42634 46,426,54 4641654 4602654 234 3/3/2009 246 571.43 0.02 Capital 1.7208/08/08 C01241224673 35: Street Assessment 57,049.67 57.49.67 57,49.67 57,049.67 172 1/8/141 39 5607.95 0.03 PearbM20007/16/fit 001195 64: 194 Certificate/0 1.711.645.12 1,721,645.12 1,721,645.12 1.7221.645.12 2 7/16/2009 16 51,320.71 0.90 Total CO 3,85&06187 3,158,062.87 3,858,063.87 3,858,062.117 2.2273 128 54,750.18 2.01 PH18 FMB 2.62506/64/09'4 353336163 2201: 2007 Certificate/0 2.000,00000 1,993,140.00 1,993.42490 1.994.380.00 2.9856 6/4/2009 339 53,791.67 104 TotalFHte 2,000,000.00 1,993,240.00 1.993.424.60 1994,360.00 2.9856 339 $3,791.67 1.4 FHLMC FHLMC 012/05/08 313396553 10:General Fwd 2,000,000.00 1,922,055.84 1,46008.38 1.977600.00 4.0411 12/8/248 161 50.00 1.04 FHIMC 913/31103 333396V42 10 General Find 3,000,000.00 2,958,201.4 4960,356.71 2,961,600.00 2.6637 12/31/2008 14 50.00 156 FHLMC 04/38/4 39396050 20 Debt Services 2.04,000.00 0,046,035.00 1,989,269.19 1,994,000.00 4.0217 9/18/2008 49 50.00 1.4 FM/4C 012/08/01 313396553 30: Water & Sewer 1,000,000.00 961,027.92 982.504,19 988,84.00 4.481 12/8/2008 161 50.00 0.52 FHLMC012/31/4 333396V42 67: 2003 Revenue Bonds 2500,000.00 7465,157.57 2.466.96393 2.468.000.00 2.6637 12/31/2009 184 50.00 1.30 FHLMC 0 12/31/08 313396042 70: 2005 Refunding /Mobility 6,000,000.00 5,916,402.17 5,920,713.43 5,923,700.00 1.6637 12/31/2008 14 50.00 3.02 rota, FNLMC 16,500,000.00 $16,161,49.51 $16,214454 $16313,200.00 3.08 163 taw 839 MMA FNMA 010/20/05 3/3588145 44: Shadow Creak Impact 3.000,00000 2975,003.33 2,977,77197 2,977,500.00 1.4393 10/20/2006 112 $0.00 1.56 Total FNMA 3,000,000.00 2,975,403.33 297777197 2377.500.00 2.4391 112 50.00 156 Total/Average $ 192,047,185.09 $ 191,1531890 $ 19194317.65 $ 191932,265.09 2.4096 23 58,54115 100.09 Solldwaste- negative casl of 998,395 because customer billing Is done In arrears to Waste Management payment. 1999 Certificate of Obligation. negative cash of 5201,538 offset by CD at Pearland State Bank. CD will be closed upon close-out of TWDB project. Property Liability- negative cash of 5101,462 because transfer to fund is only done quarterly. Community Development Block Grant - negative cash al $39,283 to be reimbursed with CDBG Funds. Group Portfolio Holdings City of Pearland Pearland Date: 06/30/2008 By Maturity Averaged By: Face Amount \ Shares Description Cudp Portfolio Name Face Amount \ Shares Cost Value Book Value Market Value VIM el Cost Maturity Date Days To Maturity Accrued Interest Portfolio Percent Wells Fe Var. Cash WFSWEEP 2105: Community Development -39,283.36 1539,783361 1539.283.361 1539,283.36) 2.34 7/1/2008 1 50.00 -0.02 Wells Fe Var. Cash WFSWEEP 2202: GO Series 2007A 27,051,456.85 527,051,456.85 527,051,456.85 527,051,456.85 2.34 7/3/2008 1 50.00 34.09 Wells Fe Var. Cash WFSWEEP 2301: W/5 Pay As U Go OP 656.031.91 565683151 5556.03191 $656,031.91 234 7/1/2008 1 50.00 034 Wells Fe Var. Cash WFSWEEP 97: Employee Benefit Trust -74,162.30 (574,162.301 (574,161.30} [574,162.30! 234 7/1/2008 1 50.00 -0.04 Wells Fe Var. Cash WFSWEEP 17: Municipal Court Secunty 132.302.16 5132,502.18 3132,302.15 5132302.16 2.34 7/1/2008 1 50.00 087 Wells Fe Var. Cash WFSWEEP 18: 0ty Wide Donation 51.938.75 551.938.75 551,93875 551938.75 2.34 7/1/2008 1 $0,00 0.03 Wells Fe Var. Cash WFSWEEP 19: Court Technology 285.726,21 5285,726.28 5285.726.28 5285,726.21 234 7/1/2008 1 50.00 0.15 Wells Fe Var. Cash WFSWEEP 42: Utility Impact Fee 2,615,117.63 52.625.117.63 51,625,117.63 52.625.117.63 234 7/1/2008 1 50.00 137 Wells Fe Var. Cash WFSWEEP 13: Regional Detention 115.83334 5115,83334 5115,83334 511583334 2.34 7/1/2008 1 50.00 0.06 Wells Fe Var. Cash WFSWEEP 44: Shadow Creek Impact 5.262.193.76 55,262,193.76 55,262,193.76 55.262.193.76 134 7/1/2008 1 50.00 2.74 wells Fe Var. Cash WFSWEEP 45: Hotel/Motel Occupancy 1,090,560.76 51,090,560.76 51,090,560.76 51.090,560.76 234 7/1/2008 1 50.00 037 Wells Fe Var. Cash WFSWEEP 46: Park Donations 16,990.39 $16,93039 516,930.39 516930.39 2.34 7/1/1008 1 50.00 0.01 Wells Fa Var. Cash WFSWEEP 47: Park &Rec Development 1,242,600.09 51.242,60089 51.242,600.09 51.242,60009 234 7/1/2008 1 $0.00 0.65 Wells Fa Val. Cash WFSWEEP 49: Tree Trust Fund 196.471.20 5196,47130 5196,471.20 5196,471.20 2.34 7/1/2008 1 50.00 0.1 Wells Fa Vat. Cash WFSWEEP 50: Capital Projects 4,775,999.25 54.775999.25 54,775,999.25 54,775999.25 2.34 7/1/2008 1 5000 2.49 Wells Fa Var. Cash WFSWEEP 55: Sidewalk Fund 177,36555 5177.36558 5177.365.58 5177,365.58 2.34 7/1/2008 1 50.00 0.09 Wells Fa Var. Cash WFSWEEP 60: Police State Seizure 91,744.98 59174498 591,714.98 591,744.98 234 7/1/2008 1 50.00 0.05 Wells Fe Var. Cash WFSWEEP 62: federal Pollee Fund 29,437.97 52943797 529,437.97 529,437.97 2.34 7/1/1008 1 50.00 0.02 Wells Fe Var. Cash Wf5WEEP 2101: Grant Fund 51,647.04 551,617.04 551,647.04 551.647.04 2.34 7/1/2008 1 50.00 0.03 Wells Fe Var. Cash WFSWEEP 2200:2006 Cartfcete/0 5.841.174.00 56,841,174.00 $6,941,174.00 56,841,171.00 2.34 7/1/2008 1 50.00 356 Wells Fe Var. Cash WFSWEEP 31: Solidwaste -398.395.51 15398,395.511 15391.395.511 (5398395511 234 7/1/2008 1 50.00 -0.21 Wells Fe Var. Cash WFSWEEP 7G 2005 Refunding / Mobility 37,677,30884 537,67730884 537,577.308.04 537.677308,04 234 7/1/2008 1 50.00 19.62 Wells Fe Var. Cash WFSWEEP 71: 2005 RefuMing/Oraln 522.15556 5522.15556 5522.15536 5522.155.56 234 7/1/2008 1 $0.00 0.27 wells Fa Var. Cash WFSWEEP 2101: 2007 Certilcate/0 10.688,15196 520,688,151.96 520,688,151.96 520,688,151.96 2.34 7/1/2008 1 50.00 10.77 Wells Fe Var. Cash WFSWEEP 68: 2001 Cenlfcale/0 15.192,08383 515.192,13.63 515.192,08383 515,192,083.83 234 7/1/2008 1 50.00 7.91 Wells Fe Var. Cash WFSWEEP 95: Progeny Liability -101,462.76 15101462.761 15101,462.761 1$101,462,761 2.34 7/1/2008 1 50.00 Wells Fe Var. Cash WFSWEEP 10:General Fund 9843.493.77 $9843.493.77 59343,493.77 59,843,493,77 234 7/1/2008 1 5080 -0p5 5.13 Wells Fe Var. Cash WFSWEEP 20:Debt Services 11.102.333.04 511,102,333.04 511.102333.04 511.102333.04 2.34 7/1/2008 1 5080 5,78 Wells Fa Var. Cash WFSWEEP 30: Water & Sewer 5,191,002.34 55391.002.34 55.191.0234 55.19180234 2.34 7/1/2008 1 50.00 2.7 Wells Fa Var. Cash WFSWEEP 35: Street Assessment 68&596.33 5668,596.33 $688596.33 5688,596.33 2.34 7/2/2008 3 50.00 036 Wells Fa Var. Cash WFSWEEP 64: 1998 Cenifcate/0 -201.537.95 15201.537.95] 15201,537.951 (5201,537.951 234 7/1/2008 1 5080 Wells Fe Var, Cash WFSWEEP 67: 2003 Revenue Bonds 15901,307.09 515904,30789 515,904307.09 515.90430789 2.34 7/1/2008 1 5000 -0.1 8.28 Pearland 2.0007/16/08 0012898 64: 1998Cemkkate/0 1,721,645.12 53,721,645.12 51,221,645.12 51.721.645.12 2 7/16/2008 16 51,320.71 0.9 Capital 27208/09/08 001242224673 35: Sired Assessment 57,049.67 $57,019.67 557,049.67 557,049.67 2.72 8/8/2008 39 560795 0.03 FHIMC 008/18/08 31339600 20: Debt Services 2,000,000.00 51,946,03530 51,989,289.19 51.994.00080 4.0217 8/18/2008 49 $0.00 1.04 FveMA 010/20/08 313588L45 44:Shadow Creek Impact 3,000,000.00 52.97580333 52,977,771.97 52,977.500.00 24393 10/20/2001 112 5080 Capital 2.6910/27/08 CD1099397 10: General Fund 357,809.20 5367.809.20 5367,809.20 5367,809.20 2.69 10/27/2008 119 58132 156 0.19 FHLMC 0 12/08/08 313396553 10. General Fund 2,000,000.00 51,922,055.84 51,965,008.38 51,977,60080 4.0181 12/8/2008 161 50.00 FHLMC 012/08/08 313396553 30: Water & Sewer 1,000,000.00 5961,027.92 5982.504.19 $988800.00 4.0481 12/8/2008 161 50.00 1.04 0.52 FHLMC 0 12/31/08 313396042 70: 2005 Refunding /Mobility 6,000,000.00 55,916402.17 55.920,71343 55,923,200.00 2.6637 12/31/2008 184 5080 FHtMC012/31/06 313395V42 10: General Fund 3,000,000.00 52.958.201.08 52.960356.71 52951,600.00 2.6637 12/31/2008 184 50812 3.11 FHLMC012/31/0B 313396042 67: 2003 Revenue Bonds 2.500.000.0D 52.465,16737 52,466,963.93 52,468,000.00 2.6637 12/31/2008 184 50.00 156 13 Capital 2.3403/02/09 C01099394 10:General Fund 1,665,132.34 51,665.13234 51,665,13234 51,665.13234 2.30 3/2/2009 245 52,668.77 0,87 Capital 2.3403/03/09 01099395 30: Water & Sewer 46,426.54 546,42854 54642654 546,42634 2.34 3/3/2009 246 571.43 0.02 NM 2.62506/04/09-08 3133)0E63 2201:2007 Cenlfcate/0 2.000.000.00 $1.993,240.00 51,993,424.80 51,994,380.00 2.9656 6/4/2009 339 53,791.67 104 Total/Average 152847,115.09 5191,685.11130 5191,803,217.69 5191832,265.09 2.4096 13 $8,54185 100 Solldwaste -negative cash of 5398,395 because customer billing is done In arrears to Waste Management payment. 1998 Certificate of Obligation - negative cash of 5201,538 offset by CD at Pearland State Bank. CD wig be closed upon close-out of TWOS project Property Liability - negative cash of 5101,462 because transfer to fund Is only done quarterly. Community Development Block Grant - negative cash of 539,283 to be reimbursed with CDBG funds. Group Date To Date By Book City of Pearland Pearland From: 03/31/2008 To: 06/30/2008 Investment Report Grouped By: Type Description Coup Patloto Name Type Maturity Date Begin Book Val 8001 Selk Amortized Discount Amordled Premium End Book Val Investment Income Cosh Wells fa Var. Cash !Wf5WEEP 10: General Fund Cash 514545,68101 5417,046.67 55,119,23397 50.00 50.00 59,843.193.1] $71,860.11 Wells Pa Var, Cask WFSWEEP 17: Muekipal Court Security Cash 5130,893.63 50.38906 56,95053 5000 50.00 5132302.16 5799.03 wells Fa Var. Cask WFSWEEP 18: Clay Wide Donation Cash 564.150.63 5333.64 512.545322 50.00 50.00 551.938.75 5333.63 Wells Fa Vat Cash WFSWEEP 19: Caws Technology Cad, 5279,034.89 511,10030 54,41491 50.00 50.00 5285.726.25 51,67505 Wells Fa Var. Cash Wf5WEEP 20: Debt Services Cash 512,764,297.34 51,075318.16 52.731,28246 50.00 $0.00 511.102333.04 $67,917.19 Wells Fa Var. Casts WPSWEEP 30: Water & Sewer Cash 53,010,53413 51..180.467.91 50.00 50.00 50.00 55,191,00234 525,434.54 Wells Fa Var. Cash WPSWEEP 31: SuldwaH4 Cash 569.16357 579,849.91 5491409315 50.00 50.00 (5398,395311 $16738 Wells fa Var.Cash WPSWEEP 35: Street Assessment Cash 5681.53991 54,05645 5000 5000 50.00 $618,59633 51.05650 Wells fa Var, Cash WFSWEEP 42 Utility Impact fee Cash 5030.73797 57,565.83144 55,77145838 50.00 50,00 $2625117,63 5537202 Wells fa Var. Cash WPSWEEP 13 Reebnal Detention Cash 5115,151.19 568735 50.00 50.00 50,00 5115,83334 568239 Welts fa Var. Cash WPSWEEP 44: Shadow Creel Impact Cash 57)07,677.51 533,047.66 51,979531.11 50.00 50.00 55.282.193.76 533,047.67 Wets Fa Var. Cash Wf5WEEP 45: Hotel/Motel 0 apancy Cash 51,031,931.62 589,174.71 513,64551 50.00 50,00 51.090510.76 56,46836 Webfa Var.Cash WFSWEEP 46:Park Donations Cash 544,43492 51908.21 579,402]1 $000 50.00 516,93039 5105.47 Web Fa Var. Cash WFSWEEP 47:Park & Rec Development Cash 51568,383.26 594.57131 5420.31018 5000 50.00 51.:41,60009 58,228.61 Wells fa Var.Cash WFSWEEP 49: tree Trust fund Cash 519531382 51,15731 50.00 50.00 5010 5194471.70 51,157.30 Wells Fa Var.Cash WPSWEEP 50: Capital Projects Cask 4,283.455.44 5901518.94 5408.97533 50.00 5000 54.775,99915 524,911.35 Wells fa Var.Cash WFSWEEP 55. Sidewalk Fund Cask 5155,82831 52153701 5000 50.00 50.00 5177,36538 51,00163 Wells fa Var.Cash WPSWEEP 60: 'sloe Stale SeWee Cash 5130.719.17 $615.08 $39,0893, 50.00 50.00 591,74498 5615.07 Wells fa Var. Cash WFSWEEP 62: Federal Police fund Cash 529,26158 517339 50.00 50.00 50.00 529,437.97 517331 Wets Fa Var. Cash WFSWEEP 84: 1991Certifkale/D Cash I5153.334.24k 50.00 $49,203.71 $000 5000 (5101,537.95( 500C Wells Fa Var. Cash Wf5WEEP 67: 2003 Revenue Bondi Cash 532010.936.99 $154250.11 516,262,880.71 50.00 5000 $15,904,307.09 5156,250.81 Wells Fa Var.Cash WFSWEEP 68: 2001 Cenllkate/0 Cash 516.287,19550 595.277.78 51,73538945 50.00 50.00 515,192,083.83 595,271.99 Wells Fa War. Cad, WFSWEEP 70: 1005 Refunding / Mab811y Cash 54042192140 5118,468.20 5197398136 $0.00 50,00 $37,677,308.01 5228.468.23 Wells Fa Var. Cash WE SWEEP 71: 2005 Reh,edina/Drain Cash 5550,68831 53499.25 531.73100 50.00 50.00 5522,155.56 53,199.23 Wells Fa Var. Cash WFSWEEP 95: Properly Liability Cash 5236,695,63 574491 5338.90330 50.00 50.00 ($101,462.76) 574491 Web fa Var. Cash WFSWEEP 91: Empbyee Denelil Trust Cash 515139985 512,17932 5237.741/2 50.03 50.00 074.182.301 50.00 Wells Fe Var. Cash WFSWEEP 1101:Grant fund Cad, $81,95111 571934 531,031.62 50.00 5000 551,64104 530391 Wells fa Var. Cash WFSWEEP 1105: Community Development Cad, 1531,283351 5000 58,000,01 50.00 50.00 1539.213 351 $0.00 Wells Fa Var.Cash WFSWEEP 2200: 2006Cen8nre/0 Cash 5485155962 54041499 553,800.61 50.00 50.00 $6,841,174.182 540,414.99 Well fa Var. Cad, WFSWEEP 1201: 8107 Certlllote/D Cash 520,225,175.03 59/531557 5452.93664 50.00 50.00 530688.15196 5119,535.66 Wells Fa Var.Cash WFSWEEP 2101:00 Miles 20070 Cash 526.250.89933 51.3104]32 551835005 5000 50.00 571051,45685 5155377.69 Well Fa Var. Cash WFSWEEP 230E W/S Pay As U Go OP Cash $443,71936 5222.45235 59,61000 50L0 50.00 5656,03131 53,0344E Pal Cosh $190,620,323.74 S1s419,629,7s $39,142,073.17 $0.00 50.00 5166,619,12222 51,054151.77 CO Capital 4.2J06/27/06 801099364 Ill: General fund CD 6/27/20108 5360523.03 5000 5360523.03 50.00 50.00 50.00 53,44230 capital 4.2000/05/08 801099303 10: General Fund CD 6/5/2000 51,630,813.78 5090 51,630,803.78 4210 50.00 50.00 512/5194 capital 23a 03/01/09 0010993994 10 General fund CO 3/2/2009 50,00 51,665,13134 50.00 50.00 50.00 51,665,13234 $2,668.]7 Capital 2.6810/27/08 CD1099397 1OGeneral Fud CD 10/27/2008 50.00 5361,809,20 50.07 50.00 5000 5367,00020 $6131 Cai*n142006/06/08 CD1099386 30: Water Sower CD 6/6/2001 545471,64 50.00 45,47184 50.00 5090 50.00 5363.64 Capital 2.34 03/03/09 C01099395 30: Water & Sewer CO 3/3/2009 50.00 54642634 50.00 50.00 50.00 546,476.54 571.43 Canna' 1.7203/05/08 C01242214673 35: Street Assessment CO 8/8/2008 557,049.67 50.00 50.00 5090 50.00 557,049.67 536688 Pearland 2.0001/15/08 C012114 64: 1991 Certificate/0 CD 4/13/2008 51,712,995.24 50.00 51,712,995.24 50.00 50.00 $000 51,407.91 Per land 2.0005/15/08 CD12847 61: 1998 Certificate/0 CD 5/15/2008 5000 $1,715,811.12 51,715911.12 50.00 50.00 50.00 $2.82051 rewind 7.0006/16/08 017873 61: 1999 Cenllicale/0 CD 6/16/1008 50.00 51,714631.63 51,718,631.63 50.00 50.00 50.00 53,01349 Pearland 2.0007/16/08 CD12890 64: 1998 Certificate/0 CD 7/16/2008 5000 51,721,845.12 50.00 50.00 50,00 51,721.15.12 $1320.71 Total CD $3,10491136 57,235,4SSJS $7,184,316.44 sane $000 53,85,062.17 $36436] RNA FMB 7.62506/04/09.08 313356563 2201: 2001 Cerltlole/0 FIILO 6/4/2009 50.00 51,993,240.00 50.00 5184,80 50.00 51.993,43490 51,643.14 rot films 5600 $1,993,740.01 $0.00 Slut $0.00 56993,424.5 $3,643.14 FNIMC FHUACO 12/08/08 313396553 II: General RIM RILMC 12/8/2008 51.945,76611 $000 50.00 519}1157 50.00 51,965.00838 519.71157 FIILMC 012/31/08 313396V41 10: General Fwd fHIMC 12/31/2009 50.00 52,958,20108 50.00 52,15563 5000 52.960356.71 52.15563 FHLMC 008/18/08 31339050 70: Debt Services MLMC 8/10/2009 51,969,699,05 $0.00 50.00 $19390.14 50.00 51,989,219.19 519,590.14 FHLMC 012/09/06 313396553 30: Water & Sewer FIILMC 11/1/2008 5972.883,41 5040 50.00 59,620.78 50.00 598150419 59,620.]8 FHLMCO 06/09/08 313396%%6 42: Udiy lmpan fee 941LMC 6/9/2006 51,983,919,13 50.00 $2,000,0000 516,05097 5000 50.00 51405087 MLMC 006/09/08 313396106 44: Shadow Creek Impact MLMC 6/9/2408 52975.923.70 $000 53.000.000.00 524970.30 50.00 50.00 524,07630 FIILMC 006/09/08 313396%16 61: 2003 Revenue Bonds FHLMC 6/9/2008 54,959.97214 5000 55,004,00000 540,127.16 5090 50.00 540,127.16 RILMC 0 13/31/08 333398V42 61: 2003 Revenue BOMB FNLMC 12/31/2009 50.00 52465.16757 50.00 51,796.36 50.00 51.466.36393 51,79636 {UUWMCa06/09/01 31339610(6 753005 Refunding/ Mobility FIILMC 6/9/2408 55951,4741 500 55.000000,00 548,15339 50.00 500 548,15139 FNUAC017/31/01 313390V42 702005 Refunding/Mobility MLMC 12/31/1009 50.00 55,916401.17 50.00 4311,26 50.00 $5,970,713.43 $4,311.26 MLMC006/09/01 313396816 1701: 2007 Cenlllrate/0 FHLMC 6/9/2001 53,98,923.70 50.00 53,000.00000 514,076.30 8090 50.00 524,076.30 Total RAMC $23,135,86605 5163397862 $19,000,000.00 $209)98.95 ADO 514284,/3513 $209,19&96 FNMA FNMA 000/20/68 313588145 94: Shadow Creek impact FNMA 10/20/2008 5000 57,975.80333 50.00 51,968.64 $0.00 52377,77197 51,960.04 Total FNMA 50.00 $211553,10515 $2,9)5,80133 538,933,09915 50,00 565,915,339.11 $;96164 $211,352.40 50.00 So DO 5),977,771.91 $191,903,211.69 S1,96d53 51197,704.44 5olldwaste - negative cash of 5398.395 because customer billing is done in arrears to Waste Management payment. 1998 Certificate of Obligationnegative cash of 5201,536 offset by CD at Pearland Slate Bank. CD will be closed upon close-out of TW0B project. Property Stability -negative cash of $101,462 because transfer to fund is only done quarterly. Community Development Block Grant . negative cash of $39,283 to be reimbursed with CMG funds. Group Portfolio Holdings City of Pearland Pearland Date: 06/30/2008 City of Pearland: By Fund Grouped By: Portfolio Name Averaged By: Face Amount \ Shares Description Cuslp Type Settlement Date Face Amount \ Shares Book Value Market Value VIM @ Cost Maturity Date Days To Maturity Portfolio Percent 10: General Fund FHLMC 012/08/08 313396553 FHLMC 2,000,000.00 51,965,00838 51,977,600.00 4.0481 11/8/2008 161 1.04 FHLMC 012/31/08 313396V42 FHLMC 3,000,000.00 52,960,356.71 52,961,600.00 2.6637 12/31/2008 184 1.56 Capital 2.3403/02/09 001099394 CO 1.665.132.34 51,665,132.34 51,665,132.34 2.34 3/2/2009 245 0.87 Capital 2.6910/27/08 CD1099397 CD 367,009.20 5367,809.20 5367,809.20 2.69 10/27/2008 119 0.15 Wells Fa Var. Cash WFSWEEP Cash 9,843,493.77 59,843,493.77 59,843,493.27 2.34 7/1/2008 1 5.13 Total 10: General Fund 16,876,435.31 $16,801,800.40 $16,815,635.31 2.6076 79 8.79 17: Municipal Court Security Wells Fa Var. Cash WFSWEEP Cash 132,302.16 5132,302.16 5132,302.16 2.34 7/1/2008 1 0.07 Total 17: Municipal Court Security 132302.16 $132,302.16 5132,302.16 2.34 1 0.07 18: City Wide Donation Wells Fa Var. Cash WFSWEEP Cash 51.938.75 551,938.75 551,938.75 2.34 7/1/2008 1 0.03 Total 18: City Wide Donation 51,938.75 $51,938.75 551,93875 2.34 1 0.03 .19: Court Technology Wells Fa Var. Cash WFSWEEP Cash 785,726.28 5285,726.28 5285,726.18 2.34 7/1/2008 1 0.15 Total 19:Court Technology 285,726.28 $285,726.28 5285,726.28 2.34 1 0.15 20: Debt Services FHLMC 008/18/06 313396C50 FIILMC 2,000,000.00 51,989,289.19 51,994,00000 4.0217 8/18/2008 49 1.04 Wells Fa Var. Cash WFSWEEP Cash 11,102,333.04 511,102,333.04 511,102,333.04 2.34 7/1/2008 1 5.78 Total 20: Debt Services 13,101,333.04 513,091,622.23 $13,096,333.04 2.5967 8 6.82 30: Water & Sewer f IONIC 012/08/08 313396553 FHLMC 100000000 5982,504.19 5988,800.00 4.0481 12/8/2008 161 0.52 Capital 2.3403/03/09 C01099395 CD 46,426.54 546,426.54 545,426.54 2.34 3/3/2009 245 0.02 Wells Fa Var. Cash WFSWEEP Cash 5,191,002.34 55,191,002.34 55,191,002.34 2.34 7/1/2006 27 Total 30' Water & Sewer 6,237,428.22 $6,219,933.07 56,216,228.88 2.6139 28 3.25 31:Salidwaste Wells Fa Var. Cash WFSWEEP Casts -398,395.51 15398,395.51) l$398,395.511 2.34 7/1/2008 1 -0.21 Total 31: Solid waste -398,395.51 ($398,395.511 ($398,395.511 2.34 1 -0.21 35:Street Assessment Capital 2.7208/08/08 C01742124673 CD 57649.67 557,049.67 557,019.67 2.72 8/8/2008 39 0.03 Wells Fa Var. Cash WFSWEEP Cash 688,596.33 5688,596.33 5688,596.33 231 7/1/2008 1 0.35 Total 35: Street Assessment 745,646.00 $745,646.00 $745,646.00 2.3691 4 0.39 41: Utility Impact Fee wells Fa Var. Casts WFSWEEP Cash 2,625,117.63 52,625,117.63 52,625,117.63 2.34 7/1/2008 1.37 Total 42:Utility Impact Fee 2,625,117.63 $2,625,117.63 $2,625,117.63 2.34 1 1.37 43: Regional Detention Wells Fa Var. Cash WFSWEEP Cash 115,833.54 5115,833.54 5115,833.54 2.34 7/1/2008 1 0.06 Total 43: Regional Detention 115,833.54 $115,833.54 $115,833.54 2.34 1 0.06 44: Shadow Creek Impact FNMA 010/20/08 313588145 FNMA 3,000,000.00 52,977,771.97 52,977,500.00 2.4393 10/20/2008 112 1.56 Wells Fa Var. Cash WFSWEEP Cash 5,262,193.76 55,262,193.76 55,262,193.76 2.34 7/1/2008 1 2.74 Total 44: Shadow Creek Impact 8,262,193.76 $8,239,065.73 58,239,693.76 2.3761 41 4.3 45: Hotel/Motel Occupancy Wells Fa Var. Cash WFSWEEP Cash 1,090,560.76 51,090,560.76 51,090,560.76 2.34 7/2/2008 1 0.57 Total 45: Hotel/Motel Occupancy 1,090,560.76 $1,090,560.76 $1,090,560.76 2.34 1 0.57 46: Park Donations Wells Fa Var. Cash WFSWEEP Cash 16,930.39 $16,930.39 516,930.39 2.34 7/1/2008 1 0.01 Total 46: Pork Donations 16,930.39 516,930.39 $16,930.39 2.34 1 0.01 47: Park & Rec Development Wells Fa Var. Cash WFSWEEP Cash 1,242,600.09 51,242,600.09 51,242,600.09 2.34 7/1/7008 1 0.65 Total 47: Park & Rea Development 1,242,600.09 $1,242,600.09 51,742,600.09 2.34 1 0.65 49: Tree Trust Fund Wells Fa Var. Cash WFSWEEP Cash 196,471.20 5196,471.20 $196,471.20 2.34 7/1/2008 1 0.1 Total 49: Tree Trust Fund 196,471,20 $196,471.20 $196,471.20 2.34 1 0.1 50: Capitol Projects Wells Fa Var. Cash WFSWEEP Cash 4,775,999.25 54,775.999.25 54,775,999.25 2.34 7/1/2008 1 2.49 Total SO: Capital Projects 4,775,999.15 54,775,999.25 $1,775,999.25 2.34 1 2.49 55: Sidewalk Fund Wells Fa Var, Cash WFSWEEP Cash 177,365.58 5177.365.58 5172,365.58 2.34 7/1/2008 1 0.09 Total 55:Sidewalk Fund 171365.58 $177,365.58 $177,365.58 2.34 1 0.09 60: Police State Seizure Wells Fa Var. Cash WFSWEEP Cash 91,744.98 591,744.98 591.744.98 2.34 7/1/2008 1 0.05 Total 60: Police State Sebum 91,744.98 591,744.98 $91,744.98 2.34 1 0.05 62: Federal Pollee Fund wells Fa Var. Cash WFSWEEP Cash 29,437.97 529,437.97 529,437.97 2.34 7/1/2008 1 0.01 Total 62: Federal Police Fund 29.437.97 529,437.97 $79,437.97 234 1 0.02 64:1998 Certificate/0 Pearland 2.0001/16/08 CD12898 CO 1.721,645.12 51.721,645.12 51,721,645.12 2 7/16/2008 16 0.9 Wells Fa Var. Cash WFSWEEP Cash -201,53735 (5201.537.951 1$201.537.951 2.34 7/1/2008 1 -0.1 Total 64: 1998 Certificate/0 1.520,107.17 51,520,107.17 51520,107.17 19549 18 0.79 67:2003 Revenue Bonds FHLMC 0 12/31/08 313396V42 FHLMC 1,500.000.00 52,466,963.93 52,468,000.00 2.6637 12/31/2008 184 1.3 Wells Fa Var. Cash WFSWEEP Cash 15.904,307.09 515,904,307.09 515,904,307.09 2.34 7/1/2006 1 8.28 Total 67: 2003 Revenue Bonds 18,404,307.09 518,371,27102 518,371507.09 2384 26 9.58 68:2001 Certificate/0 Wells Fa Var. Cash WFSWEEP Cash 15,192,083.83 515,192.0B3.83 515,192,083.83 1.34 7/1/2008 1 7.91 Total 68:2001 Certlfrcote/0 15,192,083.83 $15,192,083.83 $15,192,083.83 2.34 1 7.91 70:2005 Refunding/Mobility FHLMC 012/31/08 313396V42 FHLMC 6,000,000.00 55.920,713.43 55,923,200.00 1.6637 12/31/2008 184 3.12 Wells Fa Var. Cash WFSWEEP Cash 37,677,308.04 537,677,308.04 537,677,308.04 2.34 7/1/2008 1 19.62 Total 70:2005 Refunding/Mobility 43,677,308.04 543598,021.47 $43,60050804 2.3845 26 22.74 71:2005 Refunding/Drain Wells Fa Var. Cash WFSWEEP Cash 522,155.56 $522,155.56 5522,155.55 2.34 7/1/2008 1 0.27 Total 71:2005 Refunding/Drain 522,155.56 5522,155.56 $01,IS.56 2.34 1 0.27 95: Property Liability Wells Fa Var. Cash WFSWEEP Cash -101,462.76 (5101.462.76) (5101,462.761 2.34 7/1/2008 1 8.05 Total 95: Property Liability -101,462.76 (5101.462.76) ($101,462.76) 2,34 1 -0.05 97: Employee Benefit Trust Wells Fa Var. Cash WFSWEEP Cash -74,162.30 (574,162.301 (574,162.30) 2.34 7/1/2008 1 -0.04 Toto197: Employee Benefit Trust -74,16130 ($74,16230) ($71,162.30) 231 1 -0.04 1101: Grant Fund Wells Fa Var. Cash WFSWEEP Cash 51,647.04 551,647.04 551,647.04 2.34 7/1/2008 1 0.03 Total 2101: Grant Fund 51,647,04 $$1647.04 551647.04 2.34 1 0.03 2105: Community Development Wells Fa Var. Cash WFSWEEP Cash -39,283.36 (539,283.361 ($39,283.36 2.34 7/1/21108 1 -0.02 Total 2105: Community Development -39,283.36 (539,28136) (539,283.36) 2.34 1 -0.02 2200: 2006 Certfimte/O Wells Fa Var. Cash WFSWEEP Cash 6,841.174.00 $6,841,174.00 56,841,174.00 2.34 7/1/2008 1 3.56 Total 7200: 2006 Certfimte/O 6,841,174.00 56,841,174.00 $8841,174.00 2.34 1 3.56 2201: 2007 Certificate/0 FHLB 2.62506/04/09.08 3133213663 FHLB 2,000,000.00 51,993,424.80 51,994,380.00 2.9856 6/4/2009 339 1.04 Wells Fa Var. Cash WFSWEEP Cash 20,688,151.96 520,688,151.96 520,688,151.96 2.34 7/1/2008 1 10.77 Total 2201:2007 Certificate/0 22,688,151.96 $22,68157876 $22,682,53196 2.3969 31 11.81 2202: GO Series 20074 Wells Fa Var. Cash WFSWEEP Cash 27,051,456.85 527,051,456.85 527,051,456.85 2.34 7/1/2008 1 14.09 Total 2202: GO Series 20074 27,051,45885 $27,051,456.85 $27,051,456.05 2.34 1 14.09 2301: W/S Pay As El Go OP Wells Fa Var. Cash WFSWEEP Cash 656,031.91 5656,031.91 5656,031.91 2.34 7/1/2008 1 0.34 Total 2301: W/S Pay As U Go OP 656,03191 $656,031.91 $556,031.91 234 1 0,34 Total/Average 192,047,185.09 $191,803,217.69 $191,832,265.09 2.4096 23 100 Solldwaste - negative cash of $398,395 because customer billing is done in arrears to Waste Management payment. 1998 Certificate of Obligation - negative cash of $201,538 offset by CD at Peadand State Bank. CD will be closed upon close-out of TWDB project. Property Liability • negative cash or $101,462 because transfer to fund is only done quarterly. Community Development Block Grant- negative cash of $39,283 to be reimbursed with CDB0 funds. Pledged Collateral Reconciliation Report June 30, 2008 Bank Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Wells Fargo Account Number 201-0419505 201-0419513 201-0419539 001-3042841 201-0419554 818-4567843 001-3043112 Bank Account Number Wells Fargo 100-7284258 Bank Account Number Pearland State 12847 Bank Capital One Capital One Capital One Capital One Account Number CD1099394 CD1099397 CD 1099395 C01242224673 Account Name Operating Payroll Fund Credit Card Account Sweep Account 98 CO Escrow Alvin ISD PEDC Sales Tax Total of Bank Balances Pledged Collateral for City FDIC Insurance Amount 171, 393, 346.49 5,664,496.13 5,627,020.73 $ 182,684,863.35 231,038,991.19 100,000.00 $ 231,138,991.19 Over (Under) Collateralized $ 48,454,127.84 Account Name Development Authority Total of Bank Balances Pledged Collateral for DAP FDIC Insurance Amount $ 84,707.26 $ 84,707.26 2,160,147.17 100, 000.00 $ 2,260,147.17 Over (Under) Collateralized $ 2,175,439.91 Account Name Certificate of Deposit Total of Bank Balances Pledged Collateral FDIC Insurance Amount $ 1,721,645.12 $ 1,721,645.12 1,915, 380.64 100, 000.00 $ 2,015,380.64 Over (Under) Collateralized $ 293,735.52 Account Name Certificate of Deposit Certificate of Deposit Certificate of Deposit Certificate of Deposit Total of Bank Balances Pledged Collateral FDIC Insurance Over (Under) Collateralized Total Over (Under) Collateralized I:\Investments\Investment Report - City - ptr 0608 Amount $ 1,665,132.34 367,809.20 46,426.54 57,049.67 $ 2,136,417.75 2,712,403.51 100, 000.00 $ 2,812,403.51 $ 675,985.76 $ 51,599,289.03