Loading...
HomeMy WebLinkAbout2009-04-28 City Council Item No. 4 CITY OF �, LAKE 5LSINO K ` DREAM EXTREME, REPORT TO CITY COUNCIL TO: HONORABLE MAYOR AND MEMBERS OF THE CITY COUNCIL FROM: ROBERT A. BRADY CITY MANAGER DATE: APRIL 28, 2009 SUBJECT: INVESTMENT REPORT — MARCH 2009 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 Accountant Reviewed By: James R. Rile Ig itt i Acting Director dministrative Services Approved By: Robert A. Brady j Executive Director Agenda Item No. 4 Page 1 of 11 CITY OF LAKE ELSINORE INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS AS OF MARCH 31, 2009 BANK DEPOSITS OUTSTANG. BOOK ACTIVE ACCOUNTS BALANCE IN TRANSIT _ CHECKS BALANCE Bank of America - General $1,493,808.70 515,272.41 (1,032,038.63) 977,042.48 Bank of America - Payroll 150,464.70 - (539.16) 149,925.54 Bank of America - Flex Benefit 8,283.83 _ (38.00) 8,245.83 Total Active Accounts 1,652,557.23 515,272.41 (1,032,615.79) 1,135,213.85 INVESTMENTS Local Agency Investment Fund 18,791,210.09 - - 18,791,210.09 Bank of New York -Trust Sweep Account 2,048,058.89 - - 2,048,058.89 Bank of New York - Medium Term Corporate Notes 2,007,800.00 - - 2,007,800.00 Federal Farm Credit Bank - - - - Shell Intl Fin B V- Medium Term Corporate Notes 2,040,580.00 2,040,580.00 Federal Home Loan Mortgage Corp. - - - - Federal Home Loan Bank 2,000,000.00 - - 2,000,000.00 Federal National Mortgage Association 1,000,000.00 - - 1,000,000.00 Sub -total Investments 27,887,648.98 - - 27,887,648.98 Unrealized Gain/ (Loss) at 6 -30 -08 per GASB 31(LAIF) (1,974.00) (1,974.00) Unrealized Gain/ (Loss) at 6 -30 -08 per GASB 31 (Other) 33,113.00 33,113.00 Unrealized Gain/ (Loss) at 6 -30 -08 per GASB 31 (Total) 31,139.00 _ 31,139.00 Total Investments 27,918,787.98 - - 27,918,787.98 29,571,345.21 515,272.41.. m (1,032,615.79) 29,054,001.83 Cashier Drawers #1 & #2 300.00 City of Lake Elsinore Petty Cash Fund 1,000.00 TOTAL POOLED CASH AND INVESTMENTS $29,055,301.83 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 June 24, 2008. 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 April 22, 2009 Acting Director of Administrative Servces Date Prepared by N. Lassey, Accountant Agenda Item No. 4 Page 2 of 11 CITY OF LAKE ELSINORE POOLED CASH AND INVESTMENTS BY FUND AS OF MARCH 31, 2009 FUND NO FUND NAME _ AMOUNT 100 General Fund 1,583,336.10 101 Supplemental Law Enforcement Fund 194,429.62 102 Local Law Enforcement Block Grant Fund 11,365.77 104 Traffic Offender Fund 82,119.00 106 Affordable Housing In Lieu Fund 1,024,843.73 107 Developer Agreement Revenue 3,085,178.78 110 State Gas Tax Fund 1,818,684.00 112 Transportation Fund 657,573.81 115 Traffic Safety Fund 699,226.12 116 City Hall - Public Works DIF Fund 921,918.60 117 Community Center DIF Fund 128,661.07 118 Lake Side Facility DIF Fund 265,781.80 119 Animal Shelter DIF Fund 402,234.92 120 Camino Del Norte DIF 33,006.92 130 Lighting & Landscape Maintenance Fund (823,971.43) 135 #1 Lighting & Landscape Maintenance Fund 256,559.32 140 Geothermal Fund 18,043.68 150 C.D.B.G. Fund (109,849.58) 201 Street C.I.P. Fund 12,876.96 204 Signal C.I.P. Fund 137,870.27 205 Traffic Impact Fee Fund 3,356,009.99 211 Storm Drain C.I.P. Fund 5,485,832.18 221 Park C.I.P. Fund 1,000,801.68 231 Library C.I.P. Fund 1,295,625.84 232 City Fire Protection Fund 731,657.86 254 AD 89 -1 Railroad Canyon Rd. Improvement Fund 129,279.48 259 CFD 90 -3 Construction Fund 682.89 266 CFD 2004 -1 Marintiqu 549.23 267 CFD 2006 -1 Sumrnerly (1,570.00) 272 CFD 2005 -2 CIP Fund 856.13 351 AD 87 -2 Debt Service Fund 49,933.77 352 AD 86 -1 Debt Service Fund (6,118.01) 353 AD 89 -1 Debt Service Fund 55,376.39 356 AD 90 -1 Debt Service Fund 15,669.43 357 CFD 2003 -2 Canyon Hills (12,219.69) 358 CFD 91 -2 Debt Service Fund 87.45 360 AD 93 -1 Debt Service Fund 113,404.85 362 CFD 95 -1(96 Srs.E) Debt Service Fund (2,085.63) 363 CFD 88 -3 / 1997 Series F Debt Service Fund 109,824.43 364 CFD 88 -3 III B / 1997 Series B Debt Service Fund (396.85) 365 CFD 98 -1 Summerhill Improvement fund 69,490.25 366 CFD 2004 -1 Debt Service Fund (1,792.04) 367 CFD 2005 -3 Summerly / Laing (5,769.72) 368 CFD 2004 -2 Vista Lago 41,183.87 369 CFD 2004-3 Rosetta Canyon 43,655.67 370 CFD 2005 -x Camino Del Norte 4,139.19 371 CFD 2005 -1 Serenity (55,079.52) 372 CFD 2005 -3 Alberhill Ranch 17,923.32 373 CFD 2005 -5 Wasson Canyon 28,665.13 374 CFD 2005 -4 Lakeview Villas 53,622.46 375 CFD 2005 -1 D. Clurman 48,164.01 376 CFD 2005 -7 La Strada (2,121.44) 377 CFD 2006 -X Tessara 43,601.56 378 CFD 2007 -X TR #31957 59,312.25 379 CFD 2007 -X Marina Village 410.82 380 CFD 2006 -9 Tuscany W 484.58 381 CFD 2006 -10 River LK 55,229.30 382 CFD 2006 -9 Trieste 73,627.29 383 CFD 2007 -X Canyon Hills 64,419.61 384 CFD 2003 -2 SRS 2006A 109,250.17 385 CFD 2004 -3 SRS 2006A (105,911.81) 386 CFD 2007 -4 Mekenna (25,206.09) 387 CFD 2007 -5 Red Kite (17,089.12) 388 CFD 2007 -6 Holiday (605.19) 389 CFD 88 -3 Series 2008 106,050.56 604 Endowment Trust Fund 16,862.88 605 Public Improvement Trust Fund 524,580.30 606 Mobile Source Air Polution Fund 270,547.48 608 Trust Deposit & Pre Paid Expense 1,295,826.22 610 Kangaroo Rat Trust Fund 5,000.00 611 Developer Agreement Trust Fund 1,634,290.00 616 Fire Station Trust Fund 16.45 620 Cost Recovery System Fund 1,102,923.19 630 Lake Maintenance Fund (2,385.00) 650 CFD 2003 -1 Law & Fire Service Fund 867,653.21 651 CFD 2006 -5 Park, OpnSpc 6,482.51 652 CFD 2007 -1 Law & Fire 4,758.60 Total Pooled Cash & Investments 29,055,301.83 Agenda Item No. 4 Page 3 of 11 CITY OF LAKE ELSINORE INVESTMENT ACTIVITY SUMMARY FOR THE MONTH ENDING MARCH 31, 2009 Total outstanding investments as of February 28, 2009 $ 28,376,260.09 PURCHASE MATURITY/ COUPON YIELD TO DATE CALL DATE RATE MATURITY COST Investment Purchases: Shell INTL FIN B V 03/23/09 03/21/14 4.000% 4.000% 2,040,580.00 Total Purchases 2,040,580.00 Investment Maturities: Total Maturities - Investments Called: FNMA M/T /N 3136F9UT8 07/08/08 03/30/09 5.000% 5.000% (1,000,000.00) Total Calls (1,000,000.00) Net increase (decrease) in LAIF (500,000.00) Net increase (decrease) in Sweep Account (1,029,191.11) Total outstanding investments as of March 31, 2009 $ 27,887,648.98 Agenda Item No. 4 Page 4 of 11 tg O N < < N 0 0 0 '1' H • A N z z N N C • cn c0 t� eo O 00 O O O O E 0 a) ON ON E, ▪ W 0 0 P E.-1 Q Q O N Q Q • d z z w z z w U A o ; 0 0 cn c 0 EL. d W o o °o g g g : .1 N < Q N N N r'-', U N z z „-" C•1 O A a A O O O O O AO CA � ti Css O 7 Z h F g CA W N W 7 01 M '0 M 7 .r' b W W p�. (� h N M b M N F g M 7 N NO M O M N h w Z ham/ 6R W a) g F O� v z o 8 0 0. o S p 8 A b z w N o o en o g o o- b .ez f" ° N o ° o 00 �n E I■I ^ En O o0 6 0 en ri ?) 0 V1 � 0 CO 0 ° N o N ° 0 8 8 8 v , a ) M N -. -. -. r 0 6. W y x e W L Z C) 0 Y 0 1...4 g F y 0 • A A P4 6\ c o ► .0 8 O °a o o p O O F O O\ h N O N E -� WO ie W O V' h h y 7e, /�1 5 O a 7 cn L /� Q A O Co) - 0 N 0 go O N C 1 W d Z 0 v o v n n n o v ^ ° Can )-I O r" y W >, O; y U 8 A bp O N -0 Q O m Q O\ W b N . v) .-1 a M O `o .• . 0 U (.1 a M�° 0 LT.,.--, 0 0o N c+ M O M Q' 0 Z c .a O 0 .., I.T. °) T . N , N y g § .E a ti L . as ti > H O 7 Q O O 4 o y Z W w 0 w v a e , g g °) to 0.� Z 00 G) 0 c0 W =I cat '• Q oa W 5 T • 0 O O. O. w 7.,:i< [ >. E., U 4 -. a 00 U U a . 2 0 cn E o L E o E E . o a g W E ." C • o is F F O W w m of Z v x z H .. .4:1='' o Q v 2 b : es a) eu a) b : a) a 0 • w w w A .5 A = Agenda Item No. 4 Page 5 of 11 0 0 8 0 0 co ° 0 0 ° 0 0 0 O O • ....... o 0 0 o 0 ri o r 0 O b '-a 0 '0 v h o 0 N h 0o Z .. _, - 00 v v N a 0 I. d w. r h C., A F .. co M N M h N '0 b N W • w N O M h M M N 0 r F N V {4[_, S O v . h O 00 ho r N 0 U NM. h 7 •-•• .. .. y6 d 0 N . .. N K an 4, W a z 0 0 e" o° .9.. " 0 0 9 w W o h o • • �� en E-, H N O C h h h O 0 0 4. w. 1 En d z cs, 0 0 0 o N O O -t 0 O O d 0 N ~ .-. r .-. (. N N se N el a\ a\ 0 00 0 0 0 0 0 0 00 0 00 0 0> 0O 0 o O 0 O O, H —O h\O N 8 0 ' ° 0 v 00 0 0 °O 0 O 8 G h N 0 M '0 o O p p '0 -t sr, 01 s 0 O UU ON t NN p 'or O 0 0 0; V 00 M M 00 0 O h 0 0 00 0 0 0 O O O 0 M 00 0 o 00 N •--1 N •--. .-. K N N h O h o0 0 N N cot O i/ C 0 O M ✓ b9 U g .:4 A -t 0 0 0 0 0 0 0 0 a 8 W U - • h v ar; vi a o At w O H a G E. 000 sss s w A o 0 0 0 0 § 0 a CG 01 a E- D\ �` N h N d W° W d .-. • 0 v v v; vi a w Z >0 ° 7 a W • d O\ . V) rn s s s s s s s - W w p p 8 H z W V [w ■ 'Cr O N 0 O z W k g z� - o� ��� 4 0 H a W � L ., x O ' 1, H 0 61.1 �" O\ M . . M . d w W O g E. d' d N N N N N 'O N N 8 U �" . an Z < .7 < z z N 00 a 0, N er N n -0 ~ ' z U d q 8 h o 0 0 '. o - c es w x d 4 4 U z CT a 0 .a H d d d 0 g N d 00 z z d' A z z z N ? z N N O ti Ci a O E o o .E a I. N 8 8 8 8 ° 8 ' O O .. W d' d ' N E N N N E N E r 12 0 0 U< z z 0 t a O N C >. ,, w w C C a. a a a E 5 a a a 0 0 M � O v a. U °' 0 0 O c7) CA d , '^ N a ch x W C 0 U' 0 F O F H U A a 0, 8 c `e n 0 N d F E. a Z ° M M c O 00 0 0 Z Z Q O. U a a Z o O. U y 0 of X o [ o d o o w E. w ,, l) z Z v W C 0 oO 40 1 g 0 '4 ❑ 0 E. ' J • ❑ u O w al 40 w v� a (n W a a. > C U . v U b4 14 N Z ea a, v E °' o f E -5 a 0 O I) 0 H x z E" E. w o. E.' 0 U �" • O, ,4 7 M " b d' -0 U` H °' 0 Agenda Item No. 4 N w N W W.4 N F Vl Page 6 of 11 o s s s e r ' 4 o o Q W ri r ce o E r a 0 a. W o0 .a Z O o 0 ° g o ° 0 8 g o Q W W O O 0o h N " g C g • O O 0 M • H x N N O H ', n O k a, h o0 • V) H °° '" - pp N g- Q O O O N N 0 0 0 O 6 Q 0 m N N .--� N ~~ N O p p p p p p p M en ON ON 0 0 0 00 0 0 O O O O O O O O ON O H o 0 0Ci 0o g 0 g 0 c o v 0 v 0 N N O 0. O o O O h m cn .O 'r U o o0 00 O p n p N 00 N O. W ON 7 O O O O 8 O O 8 00 a) Po 00 00 o 0 0 0 —— 00 t cc:; 06 N N �+ �+ N N N 'e N 0) 0 O W W F 6� 0 0 0 e 8 0 w en r7 W< O a ° ° g g o a E• N h O O N W r i g z _ O 4.1 7 V v.-; ..n Q g f� ON a O Z o H N ! Y en cn M O. 7 41 a XI M �i H Q ' '0 Q' C 0 m 0 0 0 0 y f v „ W v, ' .7r " Q Z 0 Z n Q a., N\ N H A :: W g G« c o R o c o o° as h d' W d a ° 00 w as .aX�" E $ 2 w w d /r � C F O 00 F. 00 O Q\ W 00 O ... C4 C/3 x H Q . Q ` 0 0 g o " o° g g Q v U � E" d A Z Z F N o o y v U L. 0. 00 u o Z o x o o F o ' Q ea i0 E a •" e0 Y d Y '0 E A 8 e a d & Z a w w so w a ,v— 0 E• N R >C �° Q PC N en d ci) N m d « a 0 x c a F F W O F X F 00.0 N F U A ON M m 0 Z Ch O M T 0 a 0 T E. g 0 O W a U U U o a E. O W Z x H H H U >. W °. 00 W u ' % 7 H Z E 0 o U a U W 0 Q a 0 O 1 7 7 S- 3 Q •j O 4 W W T h a) y Z C a N co ti 1 Y s 8 a a ❑ 7 i o 7 <a o d U ti 7 J ' J �"-+ F G y LYE m O � -. cg. G c0 z c c o y °- U z o .w T • a q F a u E o C7 0 .a d 9 c E+ 0 a) . Z Z o x o. E-+ E. Z W 4 o to «3 w 7 E z w 7 ` ."" E" Q Q O O 0 PO O O 40 O N z C • 2 b . Y'° b V o a 0 w al w w • 01 Po 0 H Agenda Item No. 4 Page 7 of 11 \ § ) z -6 z z u Q — » 6 j z k 0 z z o z o o z o t _ / § \ ) k 2 © z ) z 41. ^ \ \ ) z \ \ / z z � PA /� 3 3 \/ - * 4 $ 2 \ \ ] s ] \ d k k i \ « 4 I § \ 7 7 j g w ? z / / 7 k \ \ / \ ) / / / Q up w> w ® x* I / / 5 \ § \ \ / j k § § § » / 2 \ m 00 / m 1-4 VI / a m § § $ 2 ) w / \ k 0 \ 2 « m ( 3 ) ® 7 / 0 / / t m \ \ k ) { 2 / § - \ } \ ] ± ] 2 / \ § t ] ( , t k 4 ` § z x d = . / E. 2 m < 7 %# — 0 o n K t w & • ] o r ® ] °) § 3 3 § ] } / / 4) ,1) CA ± Agenda Item No. 4 Page 8 of 11 8 .. 8 8 0 c o o g O g g g 6R a W O O I-4 N N U A 0 v {r 0 0 0 A O O� V1 N U v V1 Fy o E a a • Imo/ h N W v „1 z O t W • h N 0 h ON U C.1 o s 00 co • a x • H O O N N spa • U A o `s H m w z M M F o c e l E W w w Z o F z 2 OA O Agenda Item No. 4 Page 9 of 11 CITY OF LAKE ELSINORE SUMMARY OF POLICY LIMITATIONS AS OF MARCH 31, 2009 CURRENT PERCENTAGE BASED ON MARKET VALUE MAXIMUM DESCRIPTION AS OF MARCH 31, 2009 PERCENTAGE U.S. Treasury Bills 0.00% UNLIMITED U.S. Treasury Notes 0.00% UNLIMITED Federal Agency Issues: FICB 0.00% UNLIMITED FFCB 0.00% UNLIMITED FLB 0.00% UNLIMITED FHLB 0.77% UNLIMITED FNMA 3.84% UNLIMITED FHLMC 0.00% UNLIMITED Banker's Acceptances 0.00% 40.00% Certificates of Deposit 0.00% 25.00% Negotiable Certificates of Deposits 0.00% 30.00% Commercial Paper 0.00% 15.00% Medium Term Corporate Notes 15.53% 30.00% Repurchase Agreements 0.00% UNLIMITED Reverse Repurchase Agreements 0.00% 20.00% LAIF (Local Agency Investment Fund) 72.01% UNLIMITED Current Balance $ 18,791,210.09 Bank of New York - Trust Sweep Account 7.85% UNLIMITED Current Balance $ 2,048,058.89 TOTAL 100.00% % of Portfolio Maturing within one year 78.32% no less than 25% of Portfolio Maturing or Callable within one year 89.08% 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 Moody: "Aa2" S & P: "AA -e" General Electric Cap Corp Moody: "Aaae" S & P: "AAA" Shell INTL FIN Moody: "AA le" S & P: "AA +e" Agenda Item No. 4 Page 10 of 11 CITY OF LAKE ELSINORE PERCENT OF PORTFOLIO INVESTED IN FEDERAL AGENCIES JULY 2005 THROUGH MARCH 2009 (INCEPTION TO DATE) TOTAL % OF % OF PORTFOLIO BY AGENCY PORTFOLIO IN MONTH FFCB FHLB FHLMC FNMA FEDERAL AGENCIES July 2005 0.00% 0.00% 0.00% 0.00% 0.00% August 2005 0.00% 0.00% 3.33% 0.00% 3.33% September 2005 0.00% 6.23% 3.12% 0.00% 9.35% October 2005 0.00% 14.23% 2.85% 0.00% 17.08% November 2005 0.00% 18.82% 2.69% 0.00% 21.51% December 2005 0.00% 22.92% 2.86% 0.00% 25.78% January 2006 0.00% 20.74% 2.59% 0.00% 23.33% February 2006 0.00% 21.01% 2.62% 0.00% 23.63% March 2006 0.00% 20.49% 2.55% 0.00% 23.04% April 2006 0.00% 20.59% 2.57% 0.00% 23.16% May 2006 0.00% 19.94% 2.49% 5.02% 27.45% June 2006 0.00% 24.91% 1.91% 3.85% 30.67% July 2006 0.00% 2526% 1.93% 3.90% 31.09% 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% January 2007 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% January 2008 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% T06% 14.18% March 2009 0.00% 0.77% 0.00% 3.84% 4.61% AVERAGE 0.44% 20.05% 3.14% 1.74% 25.37% Agenda Item No. 4 Page 11 of 11