HomeMy WebLinkAbout08-25-09 CC Item 04CITY OF
LAKE ~ LSIAOIZE
DREAM EfCTREMEN
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 y~
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
ACTIVE ACCOUNTS
Bank of America - General
Bank of America - Payroll
Bank of America - Flex Benefit
Total Active Accounts
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
Su b-total I nvestments
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 8 #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 inves[ment policy as
approved by the Ciry Council on June 24, 2008. A wpy of this policy is available in the office of the Ciry Clerk. The
pooled investments shown above provide sufficient cash flow liquidity to meet the next six months estimated expenditures.
James R. Riley~G~u Xi~ kh~L~JeL('O./i Au9ust 17, 2009
Acting Director A'd mistrativ e es C// Date
Prepartd by: N. Isssey, Sntior Accounua
BANK DEPOSITS OUTSTANG. BOOK
BALANCE IN TRANSIT CHECKS BALANCE
$2,783,025.96
103,390.39 (2,249,647.91)
636,768.44
12,366.14
- (526.79)
11,839.35
13,746.70
13,746.70
2,809,138.80
103,390.39 (2,250,174.70)
662,354.49
17,050,13428
2,117,591.67
2,007,800.00
1,014,120.00
2,040,580.00
1,000,000.00
1,000,000.00
26,230,225.95
- - 17,050,134.28
- - 2,117,591.67
- - 2,007,800.00
- - 1,014,120.00
- - 2,040,580.00
- - 1,000,000.00
- - 1,000,000.00
26,230225.95
(1,974.00) -
- (1,974.00)
33,113.00
33,113.00
31,139.00
31,139.00
26,261,364.95 -
- 26,261,364.95
29,070,503.75 103,390.39 (2,250,174.70) 26,923,719.44
300.00
1,000.00
$26,925,019.44
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 FUND NAME
AMOUNT
100
General Fund
360,524.85
701
Supplemental Law Enforcement Fund
268,540.66
102
Local Law Enforcement Block Grant Fund
11,365.77
703
Office of Traffc Safety Fund
(52,860.53)
104
Treffic Offender Fund
29,65871
105
Misa 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 Taz Fund
2,327,035.59
112
Transportation Fund
(756,311.59)
115
Traffic Safety Fund
840,648.58
116
Ciry Hall-Public Works DIF Fund
928,633.04
117
Communiry Cen[er DIF Fund
142,993.34
118
Lake Side Facility Dlf Funtl
287,450.03
119
Animal Shelter DIF Fund
415,990.13
120
Camino Del Norte DIF
33,487.39
130
Lighting & Landscape Maintenance Fund
(751,073.44)
135
#i Lighting & Landscape Maintenance Fund
352,049.00
140
Geothermal Fund
18,316.48
150
C.D.B.G. Fund
(121,41226)
207
StreetC.I.P.FUnd
73,062.04
204
Signal C.I.P. fund
139,713.67
205
Traffc Impact Fee Fund
3,366,723.55
211
Storm Drain C.I.P. Fund
5,556,20626
227
ParkC.1.P.Fund
1,053,056.78
231
Library C.I.P.Fund
1,314,128.74
232
City Fire Protection Fund
759,38779
254
AD 69-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
CFD200fi-1Summedy
(1,570.00)
272
CFD 2005-2 CIP Fund
868.47
351
AD 87-2 Deb[ Service Fund
50,651.56
352
AD86-1DebtServiceFund
(11,275.53)
353
AD 89-1 Debt Service Fund
57,84225
356
AD90-1DebtServiceFund
77,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
CFD95-1(965rs.E)DebtServiceFUnd
(1,956.63)
363
CFD 863 / 1997 Series F Debt Service Fund
7,32524
364
CFD 863 III B/ 1997 Series B Debt Service Fund
(552.50)
365
CFD98-1Summerhilllmprovemen[fund
47,035.34
366
CFD20041DebtServiceFund
(34,847.90)
367
CFD 20053 Summerly / Laing
8,456.36
368
CFD 20042 Vista Lago
20,91622
369
CFD 20043 Rosetta Canyon
(23,344.23)
370
CFD 2005-x Camino Del Norte
4,198.59
371
CFD 2005-7 Serenity
(82,221.98)
372
CFD 20053 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
79,614.42
376
CFD 2005-7 La Streda
(3,371.44)
377
CFD 2006-X Tessara
42,936.72
378
CFD 2007-X TR#31957
58,914.74
379
CFD 2007-X Marina Vllage
476.70
380
CFD 2006-9 Tuscany W
(8.47)
387
CFD 2006-10 River LK
54,773.09
382
CFD 2006-9 Tneste
73,935.55
363
CFD 2007-X Canyon Hills
65,345.64
384
CFD2003-2SR52006A
141,657.54
385
CFD 20043 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 883 Series 2008
125,121.27
604
Endowment Trust Fund
16,966.35
605
Public Improvement Trust Fund
545.921.71
606
Mobile Source Air Polution Fund
187,002.51
608
Trust Deposit & Pre Paid Expense
1,084,274.27
611
DeveloperAgreementTruStFUnd
1,667,290.00
616
Fire Sta[ion Tmst Fund
16.66
620
Cos[Recovery SystemFund .
1,138,226.89
650
CFD 2003-1 Law & Fire Service Fund
1,644,367.75
651
CFD 2006-5 Park, OpnSpc
18,00825
652
CFD 2007-1 Law & Fire
4,758.60
Total Pooled Cash 8 Investments
26,925,019.44
It ~
O O
Z
E M
N ~
~
rna
O
0
N
U)
N
y
~
W
~
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
$ 28,907,833.97
PURCHASE MATURITY/ COUPON YIELD TO
DATE CALL DATE RATE MATURITY COST
(632,108.02)
$ 28,275,725.95
CC August 25, 2009 Item No. 4
Page 4 of 11
~
~
z
~
O W ~
z ~ o
r`i~ F N
W W M
I+M IH ~
~I O
O ~
F F ~
F
~
~
IN
~
C' 0 Q Q N O O N O
Q N 'Z' z vt d' Vt 1~ h
~ y VN N
O O O ~ O ~
a ~ a
N S
z z z~~ z z
W
~ F a 8 8~ S 8
U C N 'Z z .M. ya .~i O O
~ Q O O O ~ O ~
QI
F
~ ~ ~ b t+~ ~N C V ~
W
8 N b O p p p pp ~
F^ ~ v~i O O O V m N
O O O --i O O O O O M
. . . . ~ ~
O
5~ M q O Q N ~
4~ 25 0 25 ~ 0 25 N ~
~
w W bOp~° @°. bS~° S8 S8° 68° 6° H°
W ~ O O O O O O N
F~ V O dN m in v~
a
O
N
~ z
a
g
N
~T
W
N
N ~ ~W+ N N
N
O O O wU
z w~ z m ~ z z
~ v o m e~+n O0 m ro t
N
U U w
N ~
E q
~ F A F' F itl ° F F O W
~
O
E
A
~
d
a
F
W
~
a
~
w
~
y
~
N
~T
'J y
ti A
b~
~ H
U C9VJ
9
N
~ w
v ~
~
q 3
. ~
a
fi ?
v
~ d
~ A
m 9
~
~
~
F d
m
y V
A m
ti A
.C
a s
O y
d
[
~ U
~ G
N p~p
~ayl ¢
o ~
w ~
w
Q o
.1 S
E
~
N
3~ u
Cp ~
L ~
5
~ C
N
T C d
Q o ^
U ~yT'
g y o
aT ~
o ~ ~v
da
: [a G
CC August 25, 2009 Item No. 4
Page 5 of 11
t
~E
W~
U~
0
~o
~ N
I a
~
IIO
iQ
0
O k,
0
a
w
a Q
' O
x
~ ¢ o
NI
0
V
h
~
Q
~
ti
~ F
Ua Q
a
w
~ G]
U ~
s 6R
c~ o o ~c
r r
N
N
b
b
O
O
p
O
g g S
N
r
~
r
N
N .r .-i
.r
N
N
b
b
p
p
p
p
g S g
g
p
O
p
O
p
O
O
O
-
O
O
.~i
ti
O
O
O
O
~ O S
O
lz
h
N
N
N.n .Y
.y
t§~
6R
L~
el
O
O
8
8
N
O
O
O O
~
-
o
ti
i.i
v c
vi
v;
s
~
~
a~
~
~p
Q
'C
Q
Y
R
N
rqi
N
~ ry
N
ry
z
O
~
N
d
g
~
o
U
N -
+
rn v
o 0
N
o0
0
0
~
o
~
~
Q
~
Q
S
o
g
.~1.
g g
g
g
z
u
z
aS
°
°
~
6
~
o
+
.
.
v
o
N
0
V
z
y
O
~
~ $
O
$
N
¢
F
E'
E"
K
E"
w
°O
`
~
7
•
a
b
o
o
~
v
i
N ~
p
e
y
~
M
M
W O
A
s
e
~
F
z
o
~
a
a
~
H
F F
F
~
H
w
>
a
3
z
Z
o
U
X
u
¢
a
3
¢
o
~
~
>
v
a
U
z
C
C
y
G
m
vl
v
q
~
E'
❑
L
C
L
~
2
C
~
`e
N
U
>
~
a
u
a
c
c
F
m
~
€
w
~
b
z
n
z
`a
0
x
5
ti
F
F
x v
z
~
w
¢
Q
o
~
~
w
~
'Z
~
o
~
~
~
~
y
•
•
~
a
N
N
~
~
y
o
~
N
o
N1
O
g
~
t~
O
8
V
~
N
O
Np
O
f4
~
O
h
N
~
p
C
N
~
W
L
a
¢
a
~
~
z
N
F
m
v
m
e
~
~
t°
y
7
U
^
~
U
L
F
Q
~
~
d
~
E
~
y
F
°
U
yT
9
C
O
~
T
~
E
U
2
F
x
.0
~
w
z
O
c
G
~
a
^
m
~
5
~
w
Cg
Afust 25, 2009 Item No. 4
F
w Page 6 of 11
O~
~ n
W `
a~
o€C
~ F
U '
O
~ O
, N
i
'o
i~
. ~
N
O O
N
C
C
~
y
n
~
Q
[~i1
p
O
p
O
M
5
a
c
c
o
U
W
r
Q
z
N
b
N
>
0
z
N
y
b
-v
O
N
O
O
O
S
O
O
S
n
O
O
O
O
O
p
~
p~
b
b
N
O~
t~
O
O
~
~
~
N
q
M
N
N
~
~p
b
y
O
~
+1
O
N
N
N
N
y
y
c;
I
l~
N
N
O~
O~
`
a
~
ti
m
m
o0
0>
N
N
N
O p
O
~ G
N ~
r
r ~
N
T O
v~ O
O ~
O
0 0
M ^
r N
~ s
8 O
O G
O O 8 N
O Cj p p
~ o 0
o ^ -
O N
8 O O O
O .r
TyW
~
^ M
a
r ~
N .m.
M ~
~
O N
o c~
n O
o M
a b
~
8 q
~E/]
~
v~i
~
O
.~-i
.-N.
<
'aT
v~ O O
~
'
N
O
I
O
o
~
S
I
o
p
S
V 88
V
?
N
M
O
O
M
O
.
.
O
O
O
O O O
O
~
~
N
O
N
a
N
n
R
O
0
a
s
s
s
s
s
~
ses
a
Q
V
O
25
N
Q
25
Q
Q
~5 0 25
~
O
vi
V
.
vi
~t N M
~
.0.
O
F"
r~
p
6~
b~
6R
B
°
S
S
S S
N
{ai,
Q
F
o
~
N
$
$
25
~
Q
5$
~
~
ti
O
v
V
.
25
25
~
~
,
t
vt
d
N cn
~
F
NN
6R °
° bY S
B
[~i~
Q
O
~
N
O
Q
g
S~
~
z
9'
G
vi
v
vi
8
N
a
r
a
~
M
a
O
w
E
Q
¢
~
q
N
~
~
~
O
O
0
O
U
~
Q
T.
Z
w
~
p
~
.'~j
F
Q
6
Q
qp
Q
eN-1
Q
Q~ g
.Qi
~
Q
C
Z
z
z
N
z
N
Z
N
z d' ~
N
d
.9
eo
eL]o
eo
4
N
~
y
y
O
g
W
,C
'J'
QQ O
G
'J'
w
T
o
4~
W
¢
c
a
g
a
g
8
~
8 a 8
~
v
Q
z
z
o
a
~
a
o
N°~
~
~
^
~
~
~
O
y
O ~ ~
L
d
"
`
a
w
a
a
s
x
°
~
x
~wx
~
m
~
&
b~
'
U
✓
n'
q
~
N b~
M
~
Y
7r
Vl
~
r
N
i .
3
v
z
m
y
~
b
F
W
~
Z
z
z m°
W
~
o
m
w
o
a y
~
ii
~
,
p
a.
~
E
E
9
E o°'
iO
O
aW.
¢
Q
I
F
N
°
w
~
NI
°
l ~
I
~
°
°
a
,
<
v
~
w w
m
b~ H: g
~ m
v~ p
b V g
h W 8
O
~
0
F"
ra
¢
a
.d
6
U
CC August 25, 2009 Item No. 4
Page 7 of 11
~
Q
z
z
a
~
S
z
z z
z
o
°
x
o
w
~
z
z
T
o
T
o
¢
z
Q, Q
z z
¢
z
z
0
W
~
Q
u
o
z
z
¢
z
c¢
z
z
¢
z
z
~
a
¢
z
z
F
z
z
z z
z
U
o
a
F
rn
z
z
o
1
~
~
%
5"
W
v
w
w
'u
w
w
w
~ p O
w
H
W
~ U~
pW
y
O
U
U U
U
,
z
a
W
W
F
V
~
~
f5
,n
vNi
x
CO
E"
6
a
~ ai
~
"
~
z
M
M
~
o o
~
U
W
P.
m
~
V
U
a
X
¢
w
w
y
3
h
¢
u
o
U
0
z
❑
~
q
G
q
`y
h
c~
"
O
U
O
NC
i-1
N
S
F
~E
o
~
~
F
N
~
U
7
~
i.
2~
O
a
N
N
E
~
C
~
7
i..
o
T
5
^
y
$
m
U
~
m
F
m
¢
v
6
m
~
o
w
~
z
e
~
m
x
N
m
~
.a
7
x
Z
o
~
W
0
S
w
w
o
~
~
g
~
a
~
~A
~
o CC August 25, 2009 Item No. 4
a
w
w
m w
rD Page 8 of 11
~
A
n,Z,i a O
W A r,
~ v a
a a ~
F
~
U
8 8 g
F o o g
O ~ $ g
a
U
F1
o
y
0
s
~
o
O
F
O
F a
A ~
W U
F ~
A
W ~
z
0
~
~
U
F
F ~
~ A
W
W
~
~ Q
P.~
x
U ~
0 ~
~
s s°
S ~
o ~
rn (V
~ N
a a
00
00
N ~N
0 0
~
N M
th C1
~ w
cc
~
a
z
0
~
~
.Fi
F
Iti
HI
~
~
~
~
~
E
~
p U
C ~
W q
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 Biils
CURRENT
PERCENTAGE
BASED ON MARKET VALUE
AS OF July 31, 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
TOTAL
% of Portfolio Maturing within one year
% of Portfolio Maturing or Callable within one year
0.00%
0.00%
0.00%
0.00%
0.00%
3.70%
3.76%
0.00%
0.00%
0.00%
0.00%
19.80%
0.00%
0.00%
64.71 %
8.04%
UNLIMITED
UNLIMITED
UNLIMITED
UNLIMITED
UNLIMITED
UNLIMITED
UNLIMITED
40.00%
25.00%
30.00%
15.00%
30.00%
UNLIMITED
20.00%
UNLIMITED
$ 17,050,134.28
UNLIMITED
$ 2,117,591.67
100.00%
76.90%
84.53%
no less than 25%
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
°/a 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°/a
3.33%
September 2005
0.00°/a
6.23%
3.12%
0.00%
9.35%
October 2005
0.00°/a
14.23%
2.85%
0.00%
17.08%
November2005
0.00%
18.82%
2.69°/a
0.00%
21.51%
December 2005
0.00%
22.92%
2.86%
0.00%
25.78°/a
January 2006
0.00%
20.74°/a
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°/a
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%
June2006
0.00%
24.91%
1.91%
3.85%
30.67%
JUIy 2006
0.00%
25.26%
1.93%
3.90%
31.09°/a
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°/a
0.00%
.
27.15%
December 2006
0.00%
25.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%
Apri12007
0.00%
30.05%
4.73%
0.00%
34.78%
May 2007
0.00°/a
31.17%
4.80%
0.00%
35.97%
June 2007
0.00%
36.37%
4.28%
0.00%
40.65%
JUIy 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°/a
0.00%
0.00%
39.24%
October 2007
0.00%
31.02%
0.00%
0.00%
31.02%
November2007
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%
Apri12008
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°/a
5.20%
.
31.22%
September 2008
0.00°/a
13.54%
10.85%
5.40%
29.79%
October 2008
0.00%
15.60%
72.54%
6.25%
34.39%
November 2008
6.46%
12.94%
12.89%
6.44%
38.74%
December 2008
6.58%
6.65°/a
9.86%
6.57°/a
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%
Apri12009
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~
ow
Z 0
E ~
m
oa
0
N
L0
N
N
~
Ol
~
a
U
U