HomeMy WebLinkAbout2009-08-25 CC Item No. 4CITY OF
LADE LSIIYOIZE
DREAM EXTREME,.
REPORT TO CITY COUNCIL
TO: HONORABLE MAYOR
AND MEMBERS OF THE CITY COUNCIL
FROM: ROBERT A. BRADY
CITY MANAGER
DATE: AUGUST 25, 2009
SUBJECT: INVESTMENT REPORT -JULY 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:
Approved By:
Nancy L. Lassey
Senior Accountant
Robert A. Brady
Executive Director
CC August 25, 2009 Item No. 4
Page 1 of 11
CITY OF LAKE ELSINORE
INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS
AS OF July 31, 2009
BANK
DEPOSITS OUTSTANG.
BOOK
ACTIVE ACCOUNTS
BALANCE
IN TRANSIT CHECKS
BALANCE
Bank of America - General
$2,783,025.96
103,390.39 (2,249,647.91)
636,768.44
Bank of America - Payroll
12,366.14
- (526.79)
11,839.35
Bank of America - Flex Benefit
13,746.70
13,746.70
Total Active Accounts
2,809,138.80
103,390.39 _ (2,250,174.70)
662,354.49
INVESTMENTS
Local Agency Investment Fund
17,050,134.28
- -
17,050,134.28
Bank of New York-Trust Sweep Account
2,117,591.67
- -
2,117,591.67
Bank of New York-Medium Term Corporate Notes
2,007,800.00
- -
2,007,800.00
Berkshire Hathaway Fin Corp.
1,014,120.00
- -
1,014,120.00
Shell Intl Fin B V-Medium Term Corporate Notes
2,040,580.00
- -
2,040,580.00
Federal Home Loan Mortgage Corp.
1,000,000.00
- -
1,000,000.00
Federal National Mortgage Association
1,000,000.00
1,000,000.00
Sub-total Investments
26,230,225.95
- -
26,230,225.95
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 GASS 31 (Total)
31,139.00
31,139.00
Total Investments 26,261,364.95 - - 26,261,364.95
29,070,503.75 103,390.39 (2,250,174.70) 26,923,719.44
Cashier Drawers #1 & #2 300.00
City of Lake Elsinore Petty Cash Fund 1,000.00
TOTAL POOLED CASH AND INVESTMENTS $26,925,019.44
1 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 rash flow liquidity to meet the next six months estimated expenditures.
Jams R. Riley xr~ JeG~D/i August 17, 2009
Acting Director Ad mistrativ a es 61 Date
Pmpemd by: N. La , S mr Acmmwnt
CC August 25, 2009 Item No. 4
Page 2 of 11
CITY OF LAKE ELSINORE
POOLED CASH AND INVESTMENTS BY FUND
AS OF July 31, 2009
FUND NO FUNDNAME
AMOUNT
100
General Fund
360,524.85
101
Supplemental Law Enforcement Fund
268,540.66
102
Local Law Enforcement Block Grant Fund
11,365.77
103
Office of Traffic Safety Fund
(52,860.53)
104
Traffic Offender Fund
29,658.71
105
Misc. General Project Fund
(810,000.00)
106
Affordable Housing In Lieu Fund
1,042,015.90
107
Developer Agreement Revenue
3,103,761.66
110
State Gas Tax Fund
2,321,035.59
112
Transportation Fund
(756,311.59)
115
Traffic Safety Fund
840,648.58
116
City Hall-Public Works DIF Fund
928,633.04
117
Community Center DIF Fund
142,993.34
118
Lake Side Facility DIF Fund
287,450.03
119
Animal Shelter DIF Fund
415,990.13
120
Camino Del Norte DIF
33,481.39
130
Lighting & Landscape Maintenance Fund
(751,073.44)
135
#1 Lighting & Landscape Maintenance Fund
352,049.00
140
Geothermal Fund
18,316.48
150
C.D.B.G. Fund
(121,412.26)
201
Street C.I.P. Fund
13,062.04
204
Signal C.I.P. Fund
139,713.67
205
Traffic Impact Fee Fund
3,386,723.55
211
Storm Drain C.I.P. Fund
5,556,206.26
221
Park C.I.P. Fund
1,053,056.78
231
Library C.I.P. Fund
1,314,128.74
232
City Fire Protection Fund
759,381.79
254
AD 89-1 Railroad Canyon Rd. Improvement Fund
131,137.90
259
CFD 90-3 Construction Fund
692.69
266
CFD 2004-1 Marintiqu
934.92
267
CFD 2006-1 Summedy
(1,570.00)
272
CFD 2005-2 CIP Fund
868.41
351
AD 87-2 Debt Service Fund
50,651.56
352
AD 86-1 Debt Service Fund
(11,275.53)
353
AD 89-1 Debt Service Fund
57,842.25
356
AD 90-1 Debt Service Fund
11,256.37
357
CFD 2003-2 Canyon Hills
(97,529.63)
358
CFD 91-2 Debt Service Fund
1,992.94
360
AD 93-1 Debt Service Fund
61,733.98
362
CFD 95-1(96 Srs.E) Debt Service Fund
(1,956.63)
363
CFD 88-3 / 1997 Series F Debt Service Fund
7,325.24
364
CFD 88-3 III B / 1997 Series B Debt Service Fund
(552.50)
365
CFD 98-1 Summerhill Improvement fund
47,035.34
366
CFD 2004-1 Debt Service Fund
(34,847.90)
367
CFD 2005-3 Summarily /Laing
8,456.36
368
CFD 2004-2 Vista Lago
20,916.22
369
CFD 2004-3 Rosetta Canyon
(23,344.23)
370
CFD 2005-x Camino Del Norte
4,198.59
371
CFD 2005-1 Serenity
(82,221.98)
372
CFD 2005-3 Alberhill Ranch
47,925.04
373
CFD 2005-5 Wasson Canyon
46,716.63
374
CFD 2005-4 Lakeview Villas
53,143.14
375
CFD 2005-1 D. Clurman
19,614.42
376
CFD 2005-7 La Stmda
(3,371.44)
377
CFD 2006-X Tessam
42,938.72
378
CFD 2007-X TR#31957
58,914.74
379
CFD 2007-X Marina Village
416.70
380
CFD 2006-9 Tuscany W
(8.47)
381
CFD 2006-10 River LK
54,773.09
382
CFD 2006-9 Trieste
73,935.55
383
CFD 2007-X Canyon Hills
65,345.64
384
CFD 2003-2 SRS 2006A
141,657.54
385
CFD 2004-3 SRS 2006A
(105,911.81)
386
CFD 2007-4 Mekenna
(27,898.51)
387
CFD 2007-5 Red Kite
(18,339.12)
388
CFD 2007-6 Holiday
4,394.81
389
CFD 88-3 Series 2008
125,121.27
604
Endowment Trust Fund
16,966.35
605
Public Improvement Trust Fund
545.921.71
606
Mobile Source Air Pollution Fund
187,002.51
608
Trust Deposit & Pre Paid Expense
1,084,274.27
611
Developer Agreement Trust Fund
1,667,290.00
616
Fire Station Trust Fund
16.66
620
Cost Recovery System Fund
1,138,226.89
650
CFD 2003-1 Law & Fire Service Fund
1,644,361.75
651
CFD 2006-5 Paris, OpnSpc
18,008.25
652
CFD 2007-1 Law & Fire
4,758.60
Total Pooled Cash & Investments
26,925,019.44
It r
O
Z O
E co
0) q)
of
t0
rn 0-
0
O
N
N
N
J
O
Q
U
U
CITY OF LAKE ELSINORE
INVESTMENT ACTIVITY SUMMARY
FOR THE MONTH ENDING July 31, 2009
Total outstanding investments as of June 30, 2009
Investment Purchases:
Total Purchases
Investment Maturities:
Total Maturities
Investments Called:
Total Calls
Net increase (decrease) in LAIF
Net increase (decrease) in Sweep Account
Total outstanding investments as of July 31, 2009
PURCHASE MATURITY/ COUPON YIELD TO
DATE CALL DATE RATE MATURITY
$ 28,907,833.97
COST
(632,108.02)
$ 28,275,725.95
CC August 25, 2009 Item No. 4
Page 4 of 11
r~
V
z
W
p W a
z ~ o
V] F N
W W e+~
a
O O
F z ~
U
F
IH
O Q Q ON N N N N
O O O O O ~
U Q z z z z z z
g o
w
W 8 8 8 q 8 8~ 8
E N ¢ z N N N N N
U d' N Z z
iii
F
h~ ~ rn g g a g S o c`.'n
G o 0 0 ~ o S rn o'^o e
W M l7 M N d' V N
S N b S SOS SS S pSp q
~ ~ .Mi h N OO 8O pV m N
O O O ti O O O O S N
O w S° v 6° 6R ° 6R v S
m N ~
w S Z~R
god C8
d' O V N M vI V1
O
O
~ a
U N Q co y .Ni b b O
co V) O M M O M
D\
S
N
T
ti
y
a n m
o a o Q o o `U'
Z w z z z w
m
4 d o ~ eiOU ti mgg
U - o a V U w
W
o
W a 5 v m E" m
d G F
F z F F OF W
'a u m ~ m c ~ c v
N
C
5
N
N
N
.C
F
W
3
d
u.
m
v
a
~ F
b
N
~ W
d
E
.s
h v
N A
ro a
m
E
F
y U
a m
^ a
r~
V
o' ;C
m 3
G
O N
~ U
N G
2 p~q
a~+ d
o
y
d
~n w
O
d
N
W
pC v
b ~
5
c
w
T
N w
Q o
m ~
v q
T
° o
5 5
d
o ,o ro
.d, o a
a G
CC August 25, 2009 Item No. 4
Page 5 of 11
F
Wa
~zo
rl
H
w
U ~y
Q7~
6
y
0
w o
44 1
w
O
a
w
a ca
o w
x
~ a z
Q
v)
O
U
h
W Ew
W
z
a H
F Q
w
w
H
~ A
M
W
C1
U z
s s s°
~ ~ O b
r n
~ M (v1
H
^
~
r
~
r
~
~
~
b
~
~
N
b
~
N
O
G
T
O
O
h
M
Q
O
G
pO~
O~
O
O
O
O`
O
O
`OO
~
N
O
O
O
O
C
O
N
S
o
N
N
b
b
p
O
p
O
p
O
p
O
p
O
O
p
O
O
ti
ti
v~
vii
O
O
O
8
O
m
p
N
p
~O
O
O
~
8
O
8
O
8
O
8
O
D
O
S
S
r
h
N
N
Cj
,.y
.r
6~
S
b~°
S°
6s
A
°
b~
b~°
o
Q
Q
S
S
5
$
Q
Q
5
$
N
25
S ri
.
.
N
^
O
N
rry
,
'Q y. Vj
yj
Q
'O
Q
~
~
m
N
O N O
S
z
z
a
O
N
~
N
k'
m
m
v
U
-
+ N
m v w
o
C
C
O
R
O
~
O O O
T
i
y
~
~
g
s
gag
s
Q
z
Q
z
~
_
a
o
F
o
0
d
v
m
_
i
en
e
y
F
F
F
Q
p W
N
N
a
F
~
~
~
F
N b
~
m
m
W O O
m
H
z
pw,
W
U
n
[w~77
>
U
U U
U
v"
,
3
W
v
Q
U
a
N
3
Q
U
u
0
w
c
w
cc
c
rn
m
,y
~n
0
U
m
o
❑
L
N
G
N
2
°
L
_
N
"
T
u
N
F.
N
F
H
c
¢
❑
a
H
z
m
z
0
x
9
h
H
,a
x v
z
'w
h
ti
U
U
~
O
TJ
yo
G
w
C
"
O
N
m
b
,ce
~
~
~ o
`
N
S
a°
w
w
U
w
~
x
w
~
~
h
w w"
c7
s
m
Q
N
r
y
O
b
N
~
M
O
Qj
~
M
O
8
h
N
o~
G
O
N
a
N
N
V
q
G
10
a
a
z
d
8
5
ti
'
o
U
U
F
b
a
m
~
m
o
F
•
°
U
T
C
O
T
a
0
F
x
`o
v
z
0
d
7
9
au
5
~
w
CS AL§gust 25, 2009 Item No. 4
Page 6 of 11
Q
O
O ~ o
N
W ~ M
Fa Clrs:
~y LL
C ~ O
FBI 1~4
V y~
Fgz7
C
O
~
"
S
S
N
Q
q
a
O
O
r
z
r
w
W
y
8
8
S
x
a
W
o
0
0
~
z
Q
r-i
w
a
z
'
Q
x
M
h
v
O
r
F
rr
N
!
/y
N
b
p
S
N
8
S
S
S
S 8
8
8
~
O
C
C
O
O O
O
O
m
M
W Vl
O~
^
b
,O
-
.
.
-
^ N
T
Q\
r
O
O
~
~
~
O N
N
m
N
N
p
p
y
S
M
~
~
?
i
r
06
N
N
m
M
C
M
r
N
N
Q
A
~
W
N
M
m
m
o6
Op`
r
N
N
N
M
° 8
r O
N m
r
r ~
r m
o ~
N
~ S
v, O
O p
O p
O C
r ~
a o
o r
0
8 S '
G C
$ 8 8 S
~ O O
b ~ r O
-M
r
o ~ iT
~ N p
S S S S
O O
S
O
N
h
W
a
b
n
V
7
a
0
9
T
~F/l
h m
o
-N+
.N.
V
'C
vii 0
0
vii
N
Oa
OU
p
g
l o
0
o
g
S
S
Q
,
°
o
S
N
M
y
N
ry
N 'y
y
b
N
r
2
~
O
N
ra
W
U
O
SS
O O
S
O
N
p
S
~
~jl,
o
.
i
g
p
~
~n
v
vi
a ~i
M
b~
b
~
UR
S°
e°
e°
6R
4
Q
F
o
5
~
5
25 ~
~
~
5
~
g 25
0
¢
C
.
.1
~n
y
vi
v tai
m
3
F
~
z
F
M
~ N
o
h
o~
~
F
W
<
O
8
O N
p
S
S
8
v
v
a
.-n
O ~n
V
vi
O
a fJ
O
M
N
0
_
D\
o
0
S
N_
°
~
m
o
s
V a
o 0
V
0
e
~
s°
[p~~
F
Q
6
m
ro
U
.7
F
6
q
z
z n
N
~
in
m
N
(~I
y
N ti
Vl
~
C
_
_
G
c
E
z
z z
pp
0
Q
Q
z
z
C
z a
O
T
U
q
9
E
9
o
N
o
.
.
$
.9
m
m
.E
eo
~j
T
w
~
~
8
~
8
~
8 8
8
A
~
x
F
¢
a
E
E
9
N N
N
9
0
q
S
a
a
>
"N"
w
y
O
O~
O
~
O O
y
O
~
,
m
a
a
i
a
a
w
e
a
v°i .n
a
~
ka. ~
~
o
V
rn
W
~
w
vNi N
a N
x
¢
N x
F
o0
2
z
m
o
m
x
3
z
a
x
m
y
°
F
z
w
0
i z
0
z
2O
o Q
z
V
"
~
m
~
m
0
^
F
0
0
0
~
>
p
~ U
v
v
v
s
T
~
W
O
c
m
F m
a F
m
F
F
n
E
w
z
x
°
o
u
.a v
ti
~o
M
i7
ti
~ m
y
~
F
NI
s
W
p
I
,
y
NI
I
N
4
N
W
W
F
h
S S
vm 8QS$
b W vO
O
Vi
a
F
0
w
a
U
CC August 25, 2009 Item No. 4
Page 7 of 11
Q
z
z
8
z
z z
z
o
a
w
r
0
?
z
z
T
o
T
o
z
z z
z
z
0
w
~
U
Q
o
z
z
°
z
z
¢ a
z z
z
z
w
a
;
F
z
z
z
z
z
z
W
U
o
a
01
zo
o
m K
v
W e„
F
°
x
'S
S
'v.
d „
p 0
w
z
W
V]
d
,_7
a
U
~F+ F
N
W
O
w
w
~7
U
U U
UU
~
U v
F
z
w
w
y
R
W
F
0.w1
w
~
F
Q
P~ coq
N
U
~
U
~
C
a
a
a
w
e
k
ono
N
`i5 e
°
N
a
.1
z
.
n
.n
oNO
o o
~
rr
U
W
a
U
V
a
X
3
¢
0
ur
u
o
U
m
~
o
ie
~
v
o 0
E
a
i
F
c
aci
o
_
m U
d
u
a
ro
0
S
r
N
j
~
U
° u
i
~
C
T
G
5
~
c
F
d
'a
E
2
E
u,
3
v
F
b
z
z"
x
F
a
H
x
d
z ww
U
U
p
a°
S
w
0.1
W
~
0.
F.
y
F~1
P7 C7
CC August 25, 2009 Item No. 4
Page 8 of 11
A
a A
rar a ti
I~'1 O
O
F
v
8
S
g
~
8
0
O
d,
~1
~4
U
~
A
N
.fir
O
N
~_r
d
O
FI
O
F a
A
W U
7.
O F
F .y
A
W ~
z
0
O
U
F
F
A
Cq F
A
a
a w
U .7
z
O
pW~ F
E
61
E*
O O
M N
E
M N
M N
~ d
0 0
N N
0 0
a a`
N N
.V 1- Q
O O
~C
M M
z
w
w
v
v
U
N
G
N '-C,-
[A A
C CO
m C
O
O
CC August 25, 2009 Item No. 4
Page 9 of 11
CITY OF LAKE ELSINORE
SUMMARY OF POLICY LIMITATIONS
AS OF July 31, 2009
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
% of Portfolio Maturing within one year
% of Portfolio Maturing or Callable within one year
CURRENT
PERCENTAGE
BASED ON MARKET VALUE
MAXIMUM
AS OF July 31, 2009
PERCENTAGE
0.00%
UNLIMITED
0.00%
UNLIMITED
0.00%
UNLIMITED
0.00%
UNLIMITED
0.00%
UNLIMITED
0.00%
UNLIMITED
3.70%
UNLIMITED
3.76%
UNLIMITED
0.00%
40.00%
0.00%
25.00%
0.00%
30.00%
0.00%
15.00%
19.80%
30.00%
0.00%
UNLIMITED
0.00%
20.00%
64.71%
UNLIMITED
$ 17,050,134.28
8.04%
UNLIMITED
$ 2,117,591.67
100.00%
76.90% no less than 25%
84.53%
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 August 25, 2009 Item No. 4
Page 10 of 11
CITY
OF LAKE ELSINORE
PERCENT OF PORTFOLIO INVESTED IN FEDERAL AGENCI
ES
JULY 2005 THROUGH JULY 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%
Apri12006
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%
July 2009
0.00%
0.00%
3.76%
3.70%
7.46%
AVERAGE
0.40%
18.72%
3.19%
1.90%
24.21%
v~
0o
z
E
~
- o~
m
od
0
N
N
N
rn
U
U