HomeMy WebLinkAbout2009-07-28 City Council Item No. 4CITY OF
ISIHOU
DREAM EXTREME-
REPORT TO CITY COUNCIL
TO: HONORABLE MAYOR
AND MEMBERS OF THE CITY COUNCIL
FROM: ROBERT A. BRADY
CITY MANAGER
DATE: JULY 28, 2009
SUBJECT: INVESTMENT REPORT -JUNE 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
Senior Accountant
Reviewed By: James R. Riley(A
Acting Director of dministrative Services
Approved By: Robert A. Brady
Executive Director
CC July 28, 2009 Item No. 4
Page 1 of 11
CITY OF LAKE ELSINORE
INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS
AS OF June 30, 2009
ACTIVE ACCOUNTS
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,768,991.00
902,538.23 (1,262,754.80)
2,408,774.43
13,073.60
- (1,234.25)
11,839.35
215.10
215.10
2,782,279.70
902,538.23 (1,263 989.05)
2,420,828.88
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 National Mortgage Association
Sub-total Investments
17,682,242.30
2,117,591.67
2,007,800.00
1,014,120.00
2,040,580.00
1,000,000.00
1,000,000.00
17,682,242.30
2,117,591.67
2,007,800.00
1,014,120.00
2,040,580.00
1,000,000.00
11000,000.00
26,862,333.97
Unrealized Gain/ (Loss) at 6-30-08 per GASB 31(LAIF)
Unrealized Gain/ (Loss) at 6-30-08 per GASB 31 (Other)
Unrealized Gain/ (Loss) at 6-30-08 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 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 July 20 2009
Acting Director of Administrative Services Date
Prepared by: N. L .Y, A.... a ,
26,862,333.97
(1,974.00) - - (1,974.00)
33,113.00 - 33,113.00
31,139.00 31,139.00
26,893,472.97 - - 26,893,472.97
29,675,752.67 902,538.23 (1,263,989.05) 29,314,301.85
300.00
1,000.00
$29,315,601.85
CC July 28, 2009 Item No. 4
Page 2 of 11
CITY OF LAKE ELSINORE
POOLED CASH AND INVESTMENTS BY FUND
AS OF June 30, 2009
FUND NO FUND NAME
AMOUNT
100
General Fund
1,917,649.96
101
Supplemental Law Enforcement Fund
243,926.09
102
Local Law Enforcement Block Grant Fund
11,365.77
104
Traffic Offender Fund
22,893.46
106
Affordable Housing In Lieu Fund
1,036,824.40
107
Developer Agreement Revenue
3,095,570.89
110
State Gas Tax Fund
2,228,095.23
112
Transportation Fund
(631,818.56)
115
Traffic Safety Fund
811,250.97
116
City Hall-Public Works DIF Fund
945,771.95
117
Community Center DIF Fund
140,141.93
118
Lake Side Facility DIF Fund
282,959.68
119
Animal Shelter DIF Fund
412,548.53
120
Camino Del Norte DIF
33,314.25
130
Lighting & Landscape Maintenance Fund
(667,531.97)
135
#1 Lighting & Landscape Maintenance Fund
353,055.25
140
Geothermal Fund
18,225.07
150
C.D.B.G. Fund
(121,245.26)
201
Street C.I.P. Fund
12,996.85
204
Signal C.I.P. Fund
139,016.17
205
Traffic Impact Fee Fund
3,420,436.74
211
Storm Drain C.I.P. Fund
5,571,575.01
221
Park C.I.P. Fund
1,041,524.59
231
Library C.I.P. Fund
1,306,973.95
232
City Fire Protection Fund
752,645.29
254
AD 89-1 Railroad Canyon Rd. Improvement Fund
130,483.24
259
CFD 90-3 Construction Fund
689.24
266
CFD 2004-1 Marintiqu
930.35
267
CFD 2006-1 Summedy,
(1,570.00)
272
CFD 2005-2 CIP Fund
864.09
351
AD 87-2 Debt Service Fund
50,398.71
352
AD 86-1 Debt Service Fund
(10,680.89)
353
AD 89-1 Debt Service Fund
55,144.08
356
AD 90-1 Debt Service Fund
9,774.66
357
CFD 2003-2 Canyon Hills
(77,513.83)
358
CFD 91-2 Debt Service Fund
1,850.75
360
AD 93-1 Debt Service Fund
65,981.76
362
CFD 95-1(96 Srs.E) Debt Service Fund
(1,492.61)
363
CFD 88-3 / 1997 Series F Debt Service Fund
23,795.64
364
CFD 88-3 III B / 1997 Series B Debt Service Fund
(552.50)
365
CFD 98-1 Summerhill Improvement fund
44,017.69
366
CFD 2004-1 Debt Service Fund
(23,062.95)
367
CFD 2005-3 Summedy/Laing
8,292.19
368
CFD 2004-2 Vista Lago
23,113.13
369
CFD 2004-3 Rosetta Canyon
(9,590.14)
370
CFD 2005-z Camino Del Norte
4,177.64
371
CFD 2005-1 Serenity
(80,055.70)
372
CFD 2005-3 Alberhill Ranch
46,422.59
373
CFD 2005-5 Wasson Canyon
39,895.64
374
CFD 2005-4 Lakeview Villas
53,373.59
375
CFD 2005-1 D. Clurman
19,990.91
376
CFD 2005-7 La Strada
(2,871.44)
377
CFD 2006-X Tessam
43,259.38
378
CFD 2007-X TR#31957
59,116.37
379
CFD 2007-X Marina Village
414.63
380
CFD 2006-9 Tuscany W
489.08
381
CFD 2006-10 River LK
54,995.40
382
CFD 2006-9 Trieste
73,564.70
383
CFD 2007-X Canyon Hills
65,019.43
384
CFD 2003-2 SRS 2006A
140,053.10
385
CFD 2004-3 SRS 2006A
(105,911.81)
386
CFD 2007-4 Mekenna
(27,364.34)
387
CFD 2007-5 Red Kite
(17,839.12)
388
CFD 2007-6 Holiday
4,394.81
389
CFD 88-3 Series 2008
106,050.56
604
Endowment Trust Fund
17,230.39
605
Public Improvement Trust Fund
538,247.69
606
Mobile Source Air Polution Fund
187,992.25
608
Trust Deposit & Pre Paid Expense
1,080,790.05
610
Kangaroo Rat Trust Fund
87.50
611
Developer Agreement Trust Fund
1,663.290.00
616
Fire Station Trust Fund
16.59
620
Cost Recovery System Fund
1,099,752.98
650
CFD 2003-1 Law & Fire Service Fund
1,558,754.06
651
CFD 2006-5 Park, OpnSpc
18,467.47
652
CFD 2007-1 Law & Fire
4.758.60
Total Pooled Cash & Investments [:C:zsAE .80 09 Item No. 4
Page 3 of 11
CITY OF LAKE ELSINORE
INVESTMENT ACTIVITY SUMMARY
FOR THE MONTH ENDING June 30, 2009
Total outstanding investments as of May 31, 2009 $ 28,862,333.97
PURCHASE MATURITY/ COUPON YIELD TO
DATE CALL DATE RATE MATURITY COST
Investment Purchases:
Total Purchases
Investment Maturities:
Total Maturities
Investments Called:
FHLB 3133XRGM6 06/19/08 06/19/09 4.550% 4.550% (2,000,000.00)
Total Calls
(2,000,000.00)
Net increase (decrease) in LAIF _
Net increase (decrease) in Sweep Account 2,045,500.00
Total outstanding investments as of June 30, 2009 $ 28,907,833.97
CC July 28, 2009 Item No. 4
Page 4 of 11
z
0 ~ 01
z ~ o
N
W ~ M
W
r11
O ~ O
F
H
W ~ .N- v v m rn
N Q Q O N O O O
q N z z -hi ti N N
G
o S o$ o° E
m
m
m
s
r.7 W a` F
o
d d z z z z a Q Q
U Ca o z z 3
d
W w
o
~ F S Q Q S ~ o S g m
U Q.' N z z ° o o
~ Q o $ o 0 0 o
a ~
F ~L
~ h N m Op .r N ~ F
V] h o0 ~ O S m O. m V
[WJ=] A ~ ~ o S m O m m ~ v ~
~.y M N T N O~ ~p ~ ~ ~ ~ ~
raj ~D a ~ m W
La 3
8 yy~ b S 8O 8S yO S ~ p
~ ~ N vi O O O V ~ tMn ~ 7
1..1 u 6
A E ~ M~ 8 0~~~ H
W ~ V' O d' N M vi vi ~
rV U
,1 ~ N N
O ~
T
W W s s s a s s se s ~
fWY. F o M ~o ~ ~ g .N. ~ ro 3
LZ-~ ~ d' O V N rn v~ vj G
O
Iti ~
G
,y T
8 N C
m p°1q
_ N
N a O\ W ~ N ~ ~ ~ ti w
~~'~((y oo Vl O b O G
m m m ~ Q O
8 ~ E
T w
t5
m 5
N > c
Y
y H R
9c+d m
O F. O Q O O w G
Z w T z ~ z z „
yF m GG ~G+ O m W O m fem. Q O-
H O a 4 O 0 p p 0 ry
y C L
o > o o o
U ~ ~ U S U U .d m
~ E T m 5 0 ~ 6 c ~ ~ E
F C F m o m ~ ~ .a
ern E" Z F F OF W u~. a
A 0
CC July 28, 2009 Item No. 4
Page 5 of 11
FI
F
zoo
WPM
W
0 ~
U ~
0
o
s
s
s°
s
b.
O
~
~
h
M
m
O~
s
x
0
a
~
'
Z
O
O
b
b
p
O
O
p p
O O
p
O
O
Q
W
O
W
yN
V
h
O~
r
w
O
m
O
O
O
°
O
C
W
F
x
N
.
i
~
v
~W^
Q
~i
W
r
r
Q~
N
~
~G
O
b
~p
ti
~
~
~
V1 M V
I
O O O
O
~
H
C
O
O
O
b
SS
S
O
S
S S S
S
O
CT
O
C
N
h
p
pO
8
W
N a
S
p
8
M
O
h
O
O
O
b
b
O
C
S
O
y
S
W
O
O O O
O
l~
r
N
N
N
yj
N
C
F
N
W
F
W„
S
b@
B°
6°
S S° b~°
6E
W
F
QQ
W
~
S
S
S
55~~ O N
25 S
Om
P°~i
.
ry
a
yyy~~
F
Q
ON
C❑
O
O O O
N
y
F
Q
z
a
z
^
6
mi
O
~
N
_V
V
O
W
^
O
N .
. N
0 0
0
_
z
a~
S
p
C
OL
d
z
p
W
m
T
~
C
d
~
~
'
W
O
a
rnq
e
a\ °o
S g N
m
S
e
U
x
¢
d
¢
c~
ro
Q
z
z
}
't
4
'3
8
m M N
N
U
w
v
v
~
z
.
g
xo
~ °
o 0 0
~
?
F
d
ro
c
N
Y
N
F
Y
N
O
d
d
N
W
a0.
x
a
o
w
_
x
w
x
w
~ v
~
5
~
~
a
F
rn
F
[xi.
F
DC
F
ib
N
,c.
o
z
~
m
m
o0 0
M
U
yT
S
C
O
~
F
z
T
C
er
F F F
U
p
,
i^
W
3
U
z
2
F
x
`
c
o
~
9
U
x
°
¢
a
z
w
~
C
~
y
N
U
N
°
w
w'
y
m
°
z
a
c
c
C
w
H
U
°
E'
m
w
1
CC
> 'N
3
.a
'S
E
2
w~,g
b
~
F
e°q
v
z
z
m
F
a m z
W
y
d
d
°
~v
m
:2
0
o
w
v
a
~
S
w
'`1C
O
w
O
,OO
~
'O
y
m x C
C
~ °
:.Jul
28
2009 It
N
4
w
w
A w
F
y
,
em
o.
Page 6 of 11
y
S
S
°o
°o
°o
S
S
S
°
o S
o
0
p
n
o
0
,
0
0
0
0
0
0
O
0
c
ri
r
O
;
O
M W
O
\Z
o.
a
a;
a;
v
~
m
v~ m
v
.
.
Q
F
W
S
M
W
of
r
r
~O
O M
Q\
W
O\
M
M
W
W
r
r
r
O M
p
h
°
O
O
6
W
M
N
W
W
b
M
0
U
w
n
~
r,
06
yF
m
a
~
a\
T
r
r
N
b
N
Q
q
N
M
ze;
A
o
M
r
b
o
o
r
o.
S
o
o
g
0
o
0
0 0
o
r
Q
z
ni
o
o
o
vi o
b
?
&
~
p
O
r
p
r~'
n
n
N
d'
k
Vl
'O
a
p
~O
b
V
W
F
~V]/
Q
N
y
m
M
N
m
V
O
b
.r
O
O
~
O
O
O
T a
O
T
F.
~
M
b
S
P
S
S
S
S
O
S
S
O
}
q
b
O
S
o 8
~
H
N
v
l
t
~
~
V
O
~
~
S
O O
O
b
^
p
W
S
S
y
8
S
b
N
O
O
O
O
O
O
r
N
.r
N
N
.-i
~
A
p
N
>y
Q
a
~
~ ~ ~
a
r
M
O
S
O N
O
S
v~
N-i
S
8
~
o ~n
v
.
~n
O O O
a ~i M
p
~
~
s
s
° s
s
s°
s° s° ~
~
M
8
8
O N
8
O
Ni
8
O
O
O
z
~
~
+
O V1
V
vl
O O O
V N M
n
y N
~ ~
W Q~ ryOj
F
W
w
~
S° ~
S
p
B°
4x
w
F
Q
D
M
S O
O N
O
v,
N
8 80 O
8
z
a
O Vl
y
Vl
O
d' N M
a ~ w
O V~ O
S
>
~
N
S
M
o
y .fir .e}i
C
F
Q
Q o
s
7
o 0 0
p
c
FF4
(may
Q
z
N
x•
'
I~
.Nr
M
N
M
N ~-i .hi
O
U~
Q
~
o
n
~
o
0 0$
S
z
_o
p
S
O
e
~F
U
Q
Ga
z
z z
z
N
z
N
z a
N
.9
.9
.9
00
.9
O
.5
.9
b°
°0
.
W
b
o
~
a,
~
o
=
rn m a
g
a
x
¢
Q
Q°
8
N
g
S
9
S g
a
U
Q
z
z c
~
~
a
No
a
N e h
e
w
w
~
o
~
o 0 o
w
w
a
w
a
x
N N
w
~
N
~
x
U
z
h b
M
°O
O
~
rv ~N.
O
~ M M
m
°
N
F
w
z
z
z
z
m
~
~
~
.3
w
v
ro m
N
T
V
d
O C'
y
~
.
U
U
V.
U
4.
U
P S
m
.
.
g
E
E
S
E
o
O
d
b
F
F
F
F
o
z x
~
~
F
p
N
W
~
N~
N~
N~
W CL
F
S S° S
V W p
r W 8
O
N
V3
b
0
F
a
a
Q
U
CC July 28, 2009 Item No. 4
Page 7 of 11
z
z
N
a
p
N
o
¢
¢ ¢ ¢
U
A
a
z
z z z
o
a
w
o
¢
z
z
c
o
2
o
¢
z
¢ ¢ ¢
z z z
z
0
w
a
E.
h
U
W
q
z
z
z
z z z
a
E.
w
.a
]
E
H
z
z
a
z
z z z
a
o
a
a~
Fa
I~.I N
~4
o
W
W
a
W
F
a
~
a
~
d
~
~
~
~ ~ m
~
y
~ p 0
w
W
vz
o
a
~
a
a
W
¢
z
v
o-Fi
,
Y
W
O
,a7
F
F F F
W
F
nW
ti
a
W
¢
N
it
x
~
F
m
6
N
W W N
~ x C7
~
a
U
V
z
Q\
M
N
N
p q
m
m
o0
p p m
U
W
a
m
U
g
a
X
¢
..1
~
~
m
U
G
v
d
z
G
"
v
m
~
~
c
>
a
m
O
G
a
y
~
o
v
m
a
V
~
~
m
x
°
F
.
.
.
T
°
~
O
S
N
N
y
Fl
ry"
~
_u
L..
c
m
F
°
"
a
x
~
w
z
z
x
F
e
z
w
_
U
U
~
C
'O
~
'O
~
~
~
~
C
G
CC July 28, 2009 Item No. 4
Page 8 of 11
O
W A M
xi W
r Iti
O
O
F
U
o
g
g
~
o
o
0
vi
a
a
U
w
FI
A
a
o
N
o
s
N
`v
F
0
O
F a
A
z
0
0
V
F
w
x F
A
a
a
U
oII
F
z
0
F
g S
m ci
S S
t+i N
0
C1 N
a a
0 0
a
0 0
o, a
O S
V C
O O
H x
x x
w
N M
e~1 M
w
v
J
J
U
5
C U
(pA A
N ~
~ C
CC J14 28, 2000 Item No: 4
Page 9 of 11
CITY OF LAKE ELSINORE
SUMMARY OF POLICY LIMITATIONS
AS OF June 30, 2009
DESCRIPTION
U.S. Treasury Bills
CURRENT
PERCENTAGE
BASED ON MARKET VALUE
AS OF June 30. 2009
0.00%
MAXIMUM
PERCENTAGE
UNLIMITED
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
0.00%
0.00%
0.00%
0.00%
0.00%
3.62%
3.68%
0.00%
0.00%
0.00%
0.00%
19.14%
0.00%
0.00%
65.69%
7.87%
TOTAL 100.00%
UNLIMITED
UNLIMITED
UNLIMITED
UNLIMITED
UNLIMITED
UNLIMITED
UNLIMITED
40.00%
25.00%
30.00%
15.00%
30.00%
UNLIMITED
20.00%
UNLIMITED
$ 17,682,242.30
UNLIMITED
$ 2,117,591.67
% of Portfolio Maturing within one year 77.44% no less than 25%
% of Portfolio Maturing or Callable within one year 84.89%
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's: "Aa2"
S & P:
"AA-e"
General Electric Cap Corp
Moody's: "Aaae"
S & P:
"AAA"
Shell INTL FIN
Moody's: "Aa1e"
S & P:
"AA+e"
Berkshire Hathaway
Moody's: "Aaa"
S & P:
"AAA"
CC July28, 2009 Item No. 4
Page 10 of 11
CITY
OF LAKE ELSINORE
PERCENT OF PORTFOLIO INVESTED IN FEDERAL AGENCI
ES
JULY 2005 THROUGH JUNE 2009 (INCEPTION TO DATE)
TOTAL % OF
% OF PORTFOLIO BY AGENCY
PORTFOLIO IN
MONTH
FFCB
FHLB
FHLMC
FNMA FEDERALAGENCIES
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%
25.26%
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%
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%
AVERAGE
0.41%
19.11%
3.18%
1.86%CJui
y2$42~Oq it mNoA4
age ' 1 of I 'l