Loading...
HomeMy WebLinkAbout2010-08-24 Item No. 4crrY of J KEAM EXTREME. REPORT TO CITY COUNCIL TO: HONORABLE MAYOR AND MEMBERS OF THE CITY COUNCIL FROM: ROBERT A. BRADY CITY MANAGER DATE: AUGUST 24, 2010 SUBJECT: INVESTMENT REPORT - JULY 2010 Discussion The Investment Report is a listing of all funds invested for the City as of the date shown on the report. Recommendation Receive and file. Prepared By: Nancy L. Lassey Senior Accountant( Prepared By: James R. Riley Director of Admi stra ve Services Approved By: Robert A. Bradyk City Manager AGENDA ITEM NO.4 Page 1 of 13 Page 2 of 13 CITY OF LAKE ELSINORE INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS AS OF JULY 31, 2010 Bank of America - General Bank of America - Payroll Bank of America - Flex Benefit Total Active Accounts BANK DEPOSITS OUTSTANG. BOOK BALANCE IN TRANSIT CHECKS BALANCE $2,047,622.75 2,440.70 (1,448,653.11) 601,410.34 26,171.13 - (9,626.54) 16,544-.59 19,820.34 19,820.34 2,093,614.22 2,440.70 (1,458,279.65) 637,775.27 INVESTMENTS Local Agency Investment Fund Bank of New York-Trust Sweep Account Bank of New York-Medium Term Corporate Notes Berkshire Hathaway Fin Corp. Shell Intl Fin B V-Medium Term Corporate Notes Federal Home Loan Mortgage Corp. Federal Home Loan Mortgage Corp. Medium Term Note Federal Home Loan Bank Federal Home Loan Bank - Step Federal National Mortgage Association - Step Sub-total Investments 15,030,534.51 2,321,197.25 1,005,440.00 1,014,120.00 2,040,580.00 999,750.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 15,030,534.51 2,321,197.25 1,005,440.00 1,014,120.00 2,040,580.00 999,750.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 Unrealized Gain/ (Loss) at 6-30-09 per GASB 31(LAI F) Unrealized Gain/ (Loss) at 6-30-09 per GASB 31 (Other) Unrealized Gain/ (Loss) at 6-30-09 per GASB 31 (Total) Total Investments Cashier Drawers #1 & #2 City of Lake Elsinore Petty Cash Fund TOTAL POOLED CASH AND INVESTMENTS I certify that this report accurately reflects all pooled investments and it is in conformity with the investment policy as approved by the City Council on September 22, 2009. A copy of this policy is available in the office of the City Clerk. The pooled investments shown above provide sufficient cash flow liquidity to meet the next six months estimated expenditures. James R. Riley August 19, 2010 Acting Director of Administrative Servces Date Pre ar by: N. L y, Smior Att uuum 26,411,621.76 23,071.00 54,468.00 26,411,621.76 23,071.00 54,468.00 77,539.00 77,539.00 26,489,160.76 - - 26,489,160.76 28,582,774.98 2,440.70 (1,458,279.65) 27,126,936.03 300.00 1,000.00 27,128,236.03 Page 3 of 13 CITY OF LAKE ELSINORE POOLED CASH AND INVESTMENTS BY FUND AS OF JULY 31, 2010 FUND NO FUND NAME AMOUNT 100 General Fund 3,952,395.34 101 Supplemental Law Enforcement Fund 82,068.68- 102 Local Law Enforcement Block Grant Fund (24,889.93) 103 Office of Traffic Safety Fund (26,898.11) 104 Traffic Offender Fund 100,003.22- 106 Affordable Housing In Lieu Fund 1,067,697.87 107 Developer Agreement Revenue 381,126.81 108 Misc. Grant Fund 711,627.04 110 State Gas Tax Fund 2,464,876.93 111 TUMF C.I.P. Fund 1,217,855.01 112 Transportation Fund 1,464,437.29 115 Traffic Safety Fund 73,685.01 116 City Hall-Public Works OF Fund 989,166.55 117 Community Center DIF Fund 64,720.06 118 Lake Side Facility DIF Fund 164,339.97 119 Animal Shelter OF Fund 443,003.40 120 Camino Del Norte DIF 33,993.25 130 Lighting & Landscape Maintenance Fund (261,708.24) 135 #1 Lighting & Landscape Maintenance Fund 364,121.78 140 Geothermal Fund 18,639.53 150 C.D.B.G. Fund 2,941.16 155 GSA152 - N.P.D.E.S. (26,494.55) 201 Street C.I.P. Fund 13,261.69 204 Signal C.I.P. Fund 145,076.65 205 Traffic Impact Fee Fund 1,700,482.91 211 Storm Drain C.I.P. Fund 3,901,887.77 221 Park C.I.P. Fund 180,980.11 231 Library C.I.P. Fund 1,353,282.42 232 City Fire Protection Fund 157,367.97 254 AD 89-1 Railroad Canyon Rd. Improvement Fund 133,143.64 259 CFO 90-3 Construction Fund 20.18 266 CFO 2004-1 Marintiqu 1,010.44 272 CFD 2005-2 CIP Fund 881.63 351 AD 87-2 Debt Service Fund 51,057.12 352 AD 86-1 Debt Service Fund 11,882.59 353 AD 89-1 Debt Service Fund 67,837.31 356 AD 90-1 Debt Service Fund 5,888.60 357 CFO 2003-2 Canyon Hills 134,678.90 358 CFD 91-2 Debt Service Fund 2,105.23 360 AD 93-1 Debt Service Fund 140,961.14 362 CFD 95-1(96 Srs.E) Debt Service Fund (909.66) 363 CFO 883 / 1997 Series F Debt Service Fund 9,485.36 365 CFO 98-1 Summerhill Improvement fund 93,220.47 366 CFO 2004-1 Debt Service Fund 19,200.21 367 CFO 2005-3 Summarily /Laing 23,253.43 368 CFO 2004-2 Vista Lago 91,439.46 369 CFO 2004-3 Rosetta Canyon 144,970.84 370 CFO 2005-x Camino Del Norte 4,273.99 371 CFD 2005-1 Serenity 39,153.41 372 CFD 2005-3 Alberhill Ranch 170,800.51 373 CFO 2005-5 Wasson Canyon 76,517.20 374 CFD 2005-4 Lakeview Villas 48,178.70 375 CFD 2005-1 D. Clurman 10,007.57 376 CFD 2006,3 La Strada (6,250.00) 377 CFD 2006-X Tessara 33,701.40 378 CFO 2007-X TR#31957 49,882.16 379 CFO 2007-X Marina Village 423.00 380 CFD 2006-9 Tuscany W 498.73 381 CFD 2006-10 River LK 45,676.64 382 CFD 2006-9 Trieste 64,624.70 383 CFD 2007-X Canyon Hills 66,344.67 384 CFD 2003-2 SRS 2006A 521,316.50 386 CFD 2007-4 Mekenna 20,120.99 387 CFD 2007-5 Red Kite (6,515.50) 388 CFD 2007-6 Holiday 8,794.36 389 CFD 88-3 Series 2008 106,543.43 604 Endowment Trust Fund 15,338.42 605 Public Improvement Trust Fund 579,922.66 606 Mobile Source Air Polution Fund 114,101.20 608 Trust Deposit & Pre Paid Expense 1,078,511.04 610 Kangaroo Rat Trust Fund 195.00 611 Developer Agreement Trust Fund 550,810.00 616 Fire Station Trust Fund 16.86 620 Cost Recovery System Fund 1,196,912.21 630 Lake Maintenance Fund (84.81) 631 Lake Destrat Equipment Replacement Fund 111,202.60 650 CFD 2003-1 Law & Fire Service Fund 550,802.89 651 CFO 20065 Park, OpnSpc 32,482.42 652 CFO 2007-1 Law & Fire 4.758.60 Total Pooled Cash & Investments 27,128 236 03 Page 4 of 13 CITY OF LAKE ELSINORE INVESTMENT ACTIVITY SUMMARY FOR THE MONTH ENDING JULY 31, 2010 Total outstanding investments as of June 30, 2010 $ 28,885,904.75 CUSIP PURCHASE MATURITY/ COUPON YIELD TO INVESTMENT NUMBER DATE CALL DATE RATE MATURITY COST Investment Purchases: Total Purchases - Investment Maturities: Total Maturities - Investments Called: FHLMC 3128X8TK8 04/15/09 07/15/10 3.000% 2.990% (1,000,000.00) FHLB-Multi-Step Coupon Bond 3133XYAL9 04/27110 07/27/10 0.990% 0.990% (1,000,000.00) Total Calls (2,000,000.00) Net increase-(decrease) in LAW (2,464,285.65) Net increase (decrease) in Sweep Account 2,010,002.66 Total outstanding investments as of July 31, 2010 $ 26,411,621.76 Page 5 of 13 Page 6 of 13 o C7 mm °o w w ~a a P o y m 6 R Y p N m VO P C O~ y o- 0 6 O d L7 a G w O a F m w a H a n m c~ O 6 rn F m ro H m m C R R 'l N C n r ~i rt R d A 5 .w. a A y a O O K 2 n Y4 G O O C0 O W O m m rt m ~ rt ~ rt p N N rt rt 6 rt 6 rt O O• C > G O o 0 0 0 '3 m O w y O m 9 t- t- t- a B K a r ° F 3 r r r r 0 0 ~ o o 0 0 o T7 0 ,7 " ~2 O O ~ O m m w w w o rn w m w m m ° n 0 0 o y o c o b b m y m 6 A .On w w w w o r o y m O\ W N W A W W O O\ ~ b rr tNA rk~`'~O rTi ~iri OA N F N [w w b A x' P O 'p w w w to A O O A ~ O O O N W O O Y O O O O O Vi O O O O W W W to r A O O A ~ O O O N ~ O O Y O O O O O U O O O O as e e ~R 3R a 3R 3R p o N U N H NN ' O O O b O O O N W A ' O O O b n O A t- O O ' pO O O O O O O J A O O S O O O O O U r O J A J J N O N po b A A N Y in CIJ °a a ~ w e w pu w 0o po uwi w b OY ~ N ~ S b O O O b N A N A W Z `Z W N N N N N N N a a N O O O Q O O O O O O O b Oo b b b e N° z A z z z z 0 0 0 o a o a a a a 0 0 0 0 tOn U U r Oq A A_ W b N r VOi J A H Z Z N N N N N N N a a N O O O O O O O O to 4i to A W A N A C z H C ro F1 z ~M H cn 5qy Cr1 ~ O W A ~ O N H H 0 v a H W z H d o ~ H H ro c H x t~J a r ~ r 4 I~ H 7~J Iti H ~C Page 7 of 13 n ~-7 ~C 0 y~ lM'J MI z O o m o ' o m ry °o °n F _ op p p ryp N p z p m H r ? z r rn g ~ x m x 4 z z m m H a m x m i n n F y p pn C S z ~ W m ° ~ o rz 2 w C o f CJ m e m S' m ~ o C p o O rt ~ ~ ~ C W F o '3 ^ R V1 (A ~ (A ~ .pn .pn 'y z < n < n R (A 'I] h1 o o < y F e e b ~ a ~ n n n g p z --I ql -3 yyy r a ro' z F tz ~ x x m 0 o ro y x z z z nn ~m a b ° o r z y o O ao N Y w ~ [ N, o rn „ H NO c o w w a e r C ~ ° P K °y x H m Y . . . N .a a a e w > ° a ~ ~ m ixf m W ^+1 K7 r a z A a ~ m e n 7 O N N W W O r N A O m r w A y p C v N H N N N ~ N ~ N N N r j e ( ] a ~ r N o r o o O = o ~ > a ? > a ~ "3 N k y C [ i7 H to OR 3 04 r o ~iy a ° R a r z ° w 11 J U r n N t n m y A z p z a C W o00 o 0 00 " o a p a y .eer A o e ~ y N w N t A U U A w O hw i t O ~ O J ~ U A A W W r W r O O y 1~ C 7 1 ti O O a~ O O O O O O r 09 ~ 39 38 ~ 39 0 0 39 0 ~ y y H A A ~ ~ N t- r N ~ ~ t- r N N V~ U~ ~'C 8 8 p 8 p . O U A O b O b O p O O O O r r O O T N A A U A N A J U O J O U O O O O O O O O U W U W 0 O V O O O O O O O O O O S S m J m J A A i y Q O O O O S S O O O O O O N N U U t I~ { j~ q N y O "O O O O O "O O W O 0 ° O W VA ~ S J N V! O N N a S y i - T U 'J ~ O ° y t J IJ A ~p O\ N q S T y~ in in x y p O O O 0 O O H O vNi ~ N u p A O S S S S O O S O S ~ j U U h] O ° H U r U C x ro O y o T J J w oo P ro 0 O U W N J O A Page 8 of 13 a r r O a y T b b b U A U O Q J W O O 39 0 H h ] 'a1 'xf N 'il TI ~ N ~ N ~ N 'x1 r N N ~ ~ C C C ~ x x x x z~ ~ ~ a~ o o 0 0 B B B o R a o " H ~ •Y9 3 B g w z r r r 0 0 0 y 0 F. S o 0 o p o t~1 8 z7 `D y w w pp w w m o rv ~ p p e e as X' w Ww A m F'o ~ p . ti7 0 ; z z z z 0 0 0 H p x rv ,W. ~ Y w r ° ° y z w Pw r a ick ~ ~ y ` O 0o w W O b A ~ A ro N q A m N O O ( p ~ pp w b . - ? m b n ? A r/ ~ ^ b N Y ^ A A W N ^ W ^ 'Y z a 5 N N N O O O 5 y N N N O O O 5 pt N O 5 N O p . a w 7 O O O ry b ~°D b ^ ~ ~ ^ b ~ [Il O b N r O t\ A O `L. O .7. O `Ii Z a a W a N a a a H r N O O O 'Q O O ` y O O O O r ° U Y' t n _ r A W W A a ~p N A r J U j Z Z C O ° W o 0 o Y' a s e o a ~ o ~ o ttri H U U U A A A w N K z W W W A lA A O O H QQ ~ ~ e4 04 0 39 0 39 0 ~ 33 39 ~ v, H r W W w r A U A O O 8 8 H O O O O O O vNi o O~ C CJ d9 0 0 39 0 0 0 es 0 39 3 H 3 O r w w W O O w r A O W O U N A O O O O W 9 O O O O O O U O O as as o see ~ e ,a ~ an r r H 0 N _N J T P T N T fA 0 b a O N W O y E Y k i Y+ Y N Y °r O p A i~ a i~ 'z Ip w A N J N to O C G O O b O O O O O O W w 0 O O O O O O O O A O b O A b O O O U O U A > r Y W O ~ ~ O 0 0 0 w J O U A A J in H O O O O W U O W A A N N w ~p W H O O O O O O O O O O O O _ J A O O O O O O O O O O O O J N U O O O O O O O O O O O O A U~ - - - - N - - U w • • • A • • • r W N ° J t N N z y t n O O a, U O w r O N O O O N O O J O U t i~ N 0 O r A [ff y O o O U p O O p O O O O O p q ~ d a Oo A 0\ O\ J J .N- m .N-. .N-. r y C] N b U~ U U W b- b J J I}1 n N J W~ W 0\ N W N N J J A A W T O Of U W W W J J O O O M ~ b W a A a 0~ ~ ~ J J ° ° ° L) d o o o H A A A b b z T U W J O\ O W O Q O\ W A U W J J O O r o O b N U J T N W W b b r t O O U N O N O O O O O O O O r1 O 0 0 0 0 o S o S $ 8 S S $ o o im age 9 of 13 m m y ~ ~ q m q~ m q ~a m m r r m ~ cL 0 8. S. 2. o ~ o. b°. v rv m o 0 Z ~ c ~ o m o w S z L O G1 trJ C O a' O-n a s H y x y x °1 z S. tl° 1-3 E w r te m ~ II n 2 S 2 2 O y o 0 O 4' 1C. o f r . z A t o O m m 5' D t o m ~ o ~ m o y ~ p w O x- ~ o C a ~ 0 ~ o x ~ y y z C b7 m p ~~i p .P. 2 0 p to (A [n ~ UJ w n ~ .O. C z r C7 Y n m y .q h7 O < O < < f y C C ~ R R N y N a p 6 6 a n n s a a 0 b t~7 A ~ O p po w w ^ y W z U T N A n yw] W x '11 ~ r C to F .I W A N ~p R x U fA w x x z a Arne , , ~w p H z n n r r r r m p ti ro n H nn til z z z ro r yv, z oil H ~ r y y a a r t4 til n m n yf c ^n o c c H A ~ t4 n rt rt rv n K ~ ' I y ~ a a a a o. . ,e a e ` ~ p b m m N 7 ~ . w+ O ~ p p A ~ n y a C zzz H z z ar a a a g a a [ u, 3 a>> a a z ° a o m y o z 0 > > > e e ? > a r ~ K x W r r A z z z N'° e A z z a s aaa o0 0 o a a r ~ 0 C 0 0 0 0 Page 10 of 13 H O a r 11= n o o P y y G G (p P P ~p y 0 0 ~ ~ 5 A ~ 5 5 B B ~ ~ o y 2 2 2 n 'n' n m m z r r r r ~ w ~ ar ~ a W_ W W W W W W N W A GO T cc w ~ x O o 0 0 U U U A b N ~ ~ A O O O O O 0 0 0 b b O O O Y A b N r ~ A O O O O O U U U A A w w w b O O O b O O O O O 0 39 0 0 0 w w w b O O O b W O O O W e o o ;e ;s w w w m °o °o °o obo 0 0 0 0 0 e9 e o e d9 0 0 0 W OJ A c b N U A N N N N N 0 0 0 0 0 a s s s O O O b O O O O b O O O O ~1 O °o °o S o 00 0 0 0 0 0 0 0 0 0 0 H z H C%i z ~ C ro ~ y ~ rri ~ ►C J [21 y [ ~ r Nrcn O n ~y o ~y 0 z 5NH 1~..I 1~ v y O ~C A rr r H 0 C n a a ~ r 3 Page 11 of 13 CITY OF LAKE ELSINORE SUMMARY OF POLICY LIMITATIONS AS OF JULY 31, 2010 DESCRIPTION U.S. Treasury Bills U.S. Treasury Notes Federal Agency Issues: FICB FFCB FLB FHLB FNMA FHLMC Banker's Acceptances Certificates of Deposit Negotiable Certificates of Deposits Commercial Paper Medium Term Corporate Notes Repurchase Agreements Reverse Repurchase Agreements LAIF (Local Agency Investment Fund) Current Balance Bank of New York - Trust Sweep Account Current Balance TOTAL CURRENT PERCENTAGE BASED ON MARKET VALUE AS OF JULY 31, 2010 0.00% 0.00% 0.00% 0.00% 0.00% 7.52% 3.77% 7.53% 0.00% 0.00% 0.00% 0.00% 16.15% 0.00% 0.00% 56.34% 8.70% 100.00% MAXIMUM PERCENTAGE UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED UNLIMITED 40.00% 25.00% 30.00% 15.00% 30.00% UNLIMITED 20.00% UNLIMITED $ 15,030,534.51 UNLIMITED $ 2,321,197.25 % of Portfolio Maturing within one year 65.70% no less than 25% % of Portfolio Maturing or Callable within one year 84.63% Note: Local agencies are only eligible to purchase medium term corporate notes that have a rating of "A" or better by both Moody's Investors Service, Inc., and Standard and Poor's Corporation (S & P). If a security falls below "A" by both rating agencies, then the Director of Administrative Services will evaluate the need to sell the security prior to maturity. The medium term corporate notes purchased by the City have the following ratings: Bank of New York Mellon Moodys: "Aa2" S & P: "AA-" Shell INTL FIN Moody's: "Aa1" S & P: "AA" Berkshire Hathaway Moody's: "Aa2" S & P: "AA+" Federal Nat'l Mortgage Association Moody's: "Aaa" S & P: "AAA" Federal Home Loan Mortage Corp. Moody's: "Aaa" S & P: "AAA" Federal Home Loan Bank Moody's: "Aaa" S & P: "AAA" Page 12 of 13 CITY OF LAKE ELSINORE PERCENT OF PORTFOLIO INVESTED IN FEDERAL AGENCIES AUGUST 2006 THROUGH JULY 2010 TOTAL % OF % OF PORTFOLIO BY AGENCY PORTFOLIO IN MONTH FFCB FHLB FHLMC FNMA FEDERAL AGENCIES August 2006 0.00% 28.57% 2.19% 4.41% 35.17% September 2006 0.00% 26.17% 2.37% 4.77% 33.31% October 2006 0.00% 26.26% 2.38% 4.79% 33.43% November 2006 0.00% 24.69% 2.46% 0.00% 27.15% December 2006 0.00% 28.04% 2.54% 0.00% 30.58%0 January2007 0.00% 27.59% 2.12% 0.00% 29.71% February 2007 0.00% 26.60% 2.21% 0.00% 28.81% March 2007 0.00% 32.82% 4.68% 0.00% 37.50% April 2007 0.00% 30.05% 4.73% 0.00% 34.78% May 2007 0.00% 31.17% 4.80% 0.00% 35.97% June 2007 0.00% 36.37% 4.28% 0.00% 40.65% July 2007 0.00% 36.07% 4.25% 0.00% 40.32% August 2007 0.00% 41.34% 2.43% 0.00% 43.77% September 2007 0.00% 39.24% 0.00% 0.00% 39.24% October 2007 0.00% 31.02% 0.00% 0.00% 31.02% November 2007 0.00% 29.61% 0.00% 0.00% 29.61% December 2007 0.00% 28.06% 0.00% 0.00% 28.06% January2008 0.00% 16.79% 0.00% 0.00% 16.79% February 2008 0.00% 11.72% 0.00% 0.00% 11.72% March 2008 0.00% 11.72% 0.00% 0.00% 11.72% April 2008 0.00% 9.66% 0.00% 0.00% 9.66% May 2008 0.00% 9.20% 0.00% 0.00% 9.20% June 2008 0.00% 12.36% 2.06% 0.00% 14.42% July 2008 0.00% 13.06% 6.55% 4.36% 23.97% August 2008 0.00% 15.60% 10.42% 5.20% 31.22% September 2008 0.00% 13.54% 10.85% 5.40% 29.79% October 2008 0.00% 15.60% 12.54% 6.25% 34.39% November 2008 6.46% 12.94% 12.89% 6.44% 38.74% December 2008 6.58% 6.65% 9.86% 6.57% 29.66% January 2009 6.59% 6.67% 3.30% 6.62% 23.18% February 2009 0.00% 7.11% 0.00% 7.06% 14.18% March 2009 0.00% 0.77% 0.00% 3.84% 4.61% April 2009 0.00% 7.48% 3.72% 3.74% 14.94% May 2009 0.00% 7.45% 3.70% 3.63% 14.78% June 2009 0.00% 0.00% 3.68% 3.62% 7.30% July 2009 0.00% 0.00% 3.76% 3.70% 7.46% August 2009 0.00% 0.00% 7.33% 10.97% 18.30% September 2009 0.00% 0.00% 8.88% 13.28% 22.16% October 2009 0.00% 0.00% 10.34% 15.47% 25.81% November 2009 0.00% 0.00% 10.61% 10.58% 21.19% December 2009 0.00% 0.00% 10.56% 10.57% 21.13% January 2010 0.00% 0.00% 10.58% 10.55% 21.13% February 2010 0.00% 0.00% 8.76% 4.43% 13.19% March 2010 0.00% 0.00% 8.72% 4.34% 13.06% April 2010 0.00% 4.52% 9.11% 4.54% 18.17% May 2010 0.00% 14.10% 14.15% 4.72% 32.97% June 2010 0.00% 10.33% 10.35% 3.46% 24.14% July 2010 0.00% 7.52% 7.53% 3.77% 18.82% Page 13 of 13 AVERAGE 0.41% 15.38% 5.04% 3.69% 24.52%