HomeMy WebLinkAbout07-27-2010 City Council Item No. 4CITY OF
LSINOIZE
DREAM EXTREMEti
REPORT TO CITY COUNCIL
TO: HONORABLE MAYOR
AND MEMBERS OF THE CITY COUNCIL
FROM: ROBERT A. BRADY
CITY MANAGER
DATE: JULY 27, 2010
SUBJECT: INVESTMENT REPORT-JUNE 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 ~y/~
Senior Accountani~
Prepared By: James R. Riley
Director of Admi ' trative Services
Approved By: Robert A. Brady
City Manager
AGENDA ITEM NO. 4
Page 1 of 12
Page 2 of 12
CITY OF LAKE ELSINORE
INVESTMENT REPORT OF POOLED CASH AND INVESTMENTS
AS OF JUNE 30, 2010
BANK
DEPOSITS OUTSTANG.
BOOK
ACTIVE ACCOUNTS
BALANCE
IN TRANSIT CHECKS
BALANCE
Bank of America - General
$698,820.95
217,314.37 (341,366.29)
574,769.03
Bank of America - Payroll
19,009.83
- (2,465.24)
16,544.59
Bank of America - Flex Benefit
2,943.86
2,943.86
Total Active Accounts
720,774.64
217,314.37 (343,831.53)
594,257.48
INVESTMENTS
Loral Agency Investment Fund
17,514,820.16
- -
17,514,820.16
Bank of New York-Trust Sweep Account
311,194.59
- -
311,194.59
Bank of New York-Medium Term Corporate Notes
1,005,440.00
- -
1,005,440.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 Home Loan Mortgage Corp.
999,750.00
- -
999,750.00
Federal Home Loan Mortgage Corp. Medium Term Note
1,000,000.00
- -
1,000,000.00
Federal Home Loan Bank
1,000,000.00
- -
1,000,000.00
Federal Home Loan Bank - Step
1,000,000.00
- -
1,000,000.00
Federal Home Loan Bank- Step
1,000,000.00
- -
1,000,000.00
Federal National Mortgage Association - Step
1,000,000.00
1,000,000.00
Sub-total Investments
28,885,904.75
- -
28,885,904.75
Unrealized Gain/ (Loss) at 6-30-09 per GASB 31(LAIF)
23,071.00
- -
23,071.00
Unrealized Gain/ (Loss) at 6-30-09 per GASB 31 (Other)
54,468.00
54,468.00
Unrealized Gain/ (Loss) at 6-30-09 per GASB 31 (Total)
77,539.00
77,539.00
Total Investments
28,963,443.75
- -
28,963,443.75
29,684,218.39
217,314.37 (343,831.53)
29,557,701.23
Cashier Drawers #1 & #2
300.00
City of Lake Elsinore Petty Cash Fund
1,000.00
TOTAL POOLED CASH AND INVESTMENTS 29,559,001.23
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 July 21, 2010
Acting Director of Administrative Servces Date
]h pared by: N. ISamy, Senior Amun nt
Page 3 of 12
CITY OF LAKE ELSINORE
POOLED CASH AND INVESTMENTS BY FUND
AS OF JUNE 30, 2010
FUND NO FUND NAME
AMOUNT
100
General Fund
3,654,377.72
101
Supplemental Law Enforcement Fund
164,875.89
102
Local Law Enforcement Block Grant Fund
(18,318.53)
103
Office of Traffic Safety Fund
(24,300.95)
104
Traffic Offender Fund
95,826.82
106
Affordable Housing In Lieu Fund
1,078,840.15
107
Developer Agreement Revenue
390,001.67
108
Misc. Grant Fund
671,537.48
110
State Gas Tax Fund
2,361,090.97
111
TUMF C.I.P. Fund
1,135,789.95
112
Transportation Fund
1,937,456.72
115
Traffic Safety Fund
96,083.60
116
City Hall-Public Works OF Fund
999,412.67
117
Community Center DIF Fund
65,343.78
118
Lake Side Facility DIF Fund
165,981.12
119
Animal Shelter OF Fund
447,593.54
120
Camino Del Norte DIF
34,347.99
130
Lighting & Landscape Maintenance Fund
(163,631.84)
135
#1 Lighting & Landscape Maintenance Fund
370,515.23
140
Geothermal Fund
18,834.05
150
C.D.B.G. Fund
3,775.64
155
CSA152-N.P.D.E.S.
(18,714.48)
201
Street C.I.P. Fund
13,400.09
204
Signal C.I.P. Fund
146,590.65
205
Traffic Impact Fee Fund
1,768,964.23
211
Storm Drain C.I.P. Fund
3,954,170.63
221
Park C.I.P. Fund
169,724.53
231
Library C.I.P. Fund
1,366,359.47
232
City Fire Protection Fund
825,826.72
254
AD 89-1 Railroad Canyon Rd. Improvement Fund
134,533.10
259
CFD 90-3 Construction Fund
20.39
266
CFD 2004-1 Marinfiqu
1,020.99
272
CFO 2005-2 CIP Fund
890.84
351
AD 87-2 Debt Service Fund
51,589.95
352
AD 86-1 Debt Service Fund
8,759.04
353
AD 89-1 Debt Service Fund
67,197.73
356
AD 90-1 Debt Service Fund
252.29
357
CFD 2003-2 Canyon Hills
136,084.45
358
CFD 91-2 Debt Service Fund
2,127.20
360
AD 93-1 Debt Service Fund
133,322.99
362
CFD 95-1(96 Srs.E) Debt Service Fund
(7,572.34)
363
CFD 88-3 / 1997 Series F Debt Service Fund
9,584.35
365
CFD 98-1 Summerhill Improvement fund
94,192.01
366
CFD 2004-1 Debt Service Fund
19,400.59
367
CFD 2005-3 Summeriy/Laing
24,098.36
368
CFD 2004-2 Vista Lago
95,154.94
369
CFD 2004-3 Rosetta Canyon
146,483.74
370
CFO 2005-x Camino Del Norte
4,318.59
371
CFD 2005-1 Serenity
39,562.04
372
CFD 2005-3 Alberhill Ranch
172,354.62
373
CFD 2005-5 Wasson Canyon
77,195.68
374
CFD 2005-4 Lakeview Villas
49,196.36
375
CFD 2005-1 D. Clurman
10,626.89
376
CFD 2005-7 La Stmda
(5,750.00)
377
CFD 2006-X Tessara
34,567.98
378
CFD 2007-X TR#31957
50,917.61
379
CFO 2007-X Marina Village
427.42
380
CFD 2006-9 Tuscany W
503.94
381
CFD 2006-10 River LK
46,668.20
382
CFD 2006-9 Trieste
65,813.99
383
CFD 2007-X Canyon Hills
67,037.03
384
CFD 2003-2 SRS 2006A
525,817.29
386
CFD 2007-4 Mekenna
20,620.99
387
CFD 2007-5 Red Kite
(6,015.50)
388
CFD 2007-6 Holiday
8,794.36
389
CFD 88-3 Series 2008
106,543.43
604
Endowment Trust Fund
15,499.76
605
Public Improvement Trust Fund
585,874.08
606
Mobile Source Air Polution Fund
117,352.47
608
Trust Deposit & Pre Paid Expense
1,075,831.04
610
Kangaroo Rat Trust Fund
4,198.50
611
Developer Agreement Trust Fund
1,859,810.00
616
Fire Station Trust Fund
17.05
620
Cost Recovery System Fund
1,210,098.24
631
Lake Desist Equipment Replacement Fund
113,599.82
650
CFD 2003-1 Law & Fire Service Fund
640,640.23
651
CFD 2006-5 Park, OpnSpc
33,224.39
652
CFD 2007-1 Law & Fire
4,758.60
Total Pooled Cash & Investments
29,559,001.23
Page 4 of 12
CITY OF LAKE ELSINORE
INVESTMENT ACTIVITY SUMMARY
FOR THE MONTH ENDING JUNE 30, 2010
Total outstanding investments as of May 31, 2010
CUSIP PURCHASE MATURITY/ COUPON YIELD TO
INVESTMENT NUMBER DATE CALL DATE RATE MATURITY
Investment Purchases:
Total Purchases
Investment Maturities:
$ 21,085,891.40
COST
Total Maturities -
Investments Called:
Total Calls -
Net increase (decrease) in LAIF 7,800,000.00
Net increase (decrease) in Sweep Account 13.35
Total outstanding investments as of June 30, 2010 $ 28,885,904.75
Page 5 of 12
W
H
W
x
ra
1O~
F
O
N
M
z
j~
r
O
E-
. W v N a v m ~n a vi vi .n
N Q' Q' N N N N N N N N N
~y t+f V < V W < h V~1 V~1
O O O O O O O O O
a W O o 0 0 o O
F Q Q Q Q N N Q O N O O N
u z z z z z N o
U Q g o o o o
W
a. rn rn a o0 o a o 0 0
6~ W g °o °o °o °o o °0 0 0 0
M r~ N Q Q' N N N N N N ~ N N_
A O O O O O O O O O
QI
F ~o M o ~o o v o o v a o
W Q p p~ ry o h o o v o o Ili A M R
H M O O ~p vj O N h N M M V
.M. vmi m m e v rn a S O
fYi W p °a
E ti r °M M P N C N a V d' M
H W
°O °o °o
0 o v o 0 0 0 0 0 0 0 ~
E,y oo N O~ N O O C O h O O p
~ h o0 O O < O h O O S
o v~ m o 0 0 0 o a o 0 0 ~
° s e e s w s~ft e s° e el s
° oo ° o 0 o v~ ° ° ° ° °
a U ~ VNl °O C a C N T G C 8 P
W F ss ~ s se s se s s~ es s ce
R' m o 0 0 0 ~n o 0 0 0 0
W 6~ o vNi °o °o a °o .N. a o o °b, a
F ai v o C v M vi o m M m
z
x~ u a w w x
x >1
U y~J N a a ~ ~ N `°VU M N M m m
ao ti o m m o M m cn M m
z
a y
z w z d
u z u u
W "s € o o o w m
U C U `06 ro ro m
fi T v fi o E E E E E E 9 F
u
F F z x F x x x x x
fy Q R R N .Ej t~ N N
'y (~Nj( Y :p d L N W .pd d L
n.l ~ v d N U V W N d u
w~ w w~ w w w w w
O
N
v
v
A
F
W
3
y
ti
c
0
w
v
m
L
G
h R
b L
F
v
m 4
c
L
U -a
A '3
E
.9
v
y v
N A
F v
U
N N
a ~
T q
u F
a
o v
b
a
d
m
o
v
y
w w
0
v c
C n
o v
w
pq v
D ~
5
S
v
w
o
w A
pu c
a C q
o ~ ro
q G
N > v
O Q C
Page 6 of 12
o
s
s
s
.a
w
°
y
r
o
e
<
m
m
M
°
w
b
O
s a
0
a
a
a A
^
h
h
h
h
°
h °
°o
Z
w W
o
N
N
>
°
N
N
~
S
Q`
~p
'
.
i O .
i
x
~
°
vi
^
m vi m
W H F
ti
~
"
~
o
g s
/Y
~
~
h
~
O
O
O O O
O
F
y
G
m
G
m
v
v
~
C
°
C
°
c c c
° °
o
U
o
o
o
o 0
0
W
~
°
=
o°
o°
S d S
°
S
P.
~
~
M
m
o
0
0 0 o
m
F
W
w W
s
s
s
s s s
F
W
r
o
a o
a
a
a
~O
a Qa O
W F
Q
•p
Q
W
N
m
N N N
W
m
W
~
q
z
O
z
-
N= P
~
R
°
W Z
c
o
o 0 0
v
0.l
W
C
v
~
y
m
rn
,
oa o
S
0' Qi
~ F
¢
w
¢
d
N
G
N N N
y
a s
z
z
F
W
~
_
UU'
a
m
d
o
z
boo
O
m
d
a~i
m
W
W
w
d
.a
O
~
.q7 °1 x
E
a
F
a
F
w
F
DC m k
F
P
~
(]j
rn
m
m
~
z
z
M
M M t~~1
F
° W
o
w
a a a
w
a
3
w
w w w
F >
h
z
c
U
U
a
a
X
d
y
D
~
~
~
Q
U
U
w
w
3
'
'
y
G
O
G
D
a>
D
a>
F
Y
O
H
CC
❑
tJ
H
S
'O
N
~
,
>
N
~
r
i
T T
F
~
F
~
~
E
2 2
'
x
h h
~
~
z
z
a
y
6
¢
a
o
N N
z
A
A
N
v
o
N
0
;
'd
~
'S
o 0
s
can e
O ti
~n
o
oy
S O N
N
S S O
O
6
16
b
p
W C5
O
m
j
< v
o
N ~c
`T
~
O~
M m ~n
M
~
V
_
S N
,y
^ N
b
ti
O O O
~
.y O ~
~
~
O
M
O O S
O
O O O
O
r
O
O O O
O
O O O
O
V
~
o rn
a
°
°
m
o a C o
a
v o
o 0 0
C
0
m
0o
a'
^
N
N
d
U
N
E
sues
sss
O S S
O O N
„
a
O O O
O O ^
H
M M M
V' [Y Vl
d
N N N
N N N
y
v
~
o
B
~
F
o
N
C
z
d
o~ o
m
o 0 0
~
a
p
8 8
U
N N N
a
p
N N N
~o~
a
~s
d
b
v
a
°
~
e a
F
i
o 0
,
m
0 0 o
E
F
v
b
E
~
d
v
ro a M
w"
~o v
a
~
y
W
{I
~ u
qq
~
T
r
+
CC
Q
o
X~~
F
r e o
F
.Ni .Ni ti
y
N m b
V
M M M
O O O
T
y
9
d
O
G
x x x
~ ~ ~
www
H
0
N
v
a
a
w
O
U
U
O
>
O
U
v
z
c
v
ro
C
L
R
O
7a
E
o
€
o
W 3 p
2
w ~
°
~
°
g
v
x v
x
ti Ati
F
H ~,z
~
w
i
a~ ro
~
o
s
z
o
s
y
.
.
v
U
y
00 O 00
y
C
}9
E
"
w
o
w
P
age
F? of f2
m `
nzr ~
W ~
a~
O E
F'
U~
^
S S
S
S
S
S
S
S° S S
~
O O
O
N
~
V
~
~
b
O
O
v
l
V
4 ti
V
q F
h o
h
a
v
~
r
N o M b
M O
M
~
V
h
1~
N O M b
~
O
n
V
V
N
N
M
b
N r
a Ri
.
i
v
1
t
+l
U w
r
r
~
d'
b
b
N W M b
Z
"'i
Vl
W
W
1~
r
N D\ b V
Q
i
w
a Q
S
S
°
S
°
°
°
Z
n
o
o
o
o
w W
>
a
N
•y
b
b
a
O
m b
O
~.y O x
~
~
~
~
h
h
v
i
V
M VI O N
Q Z
r M
°
o
h'"
o
0
4
o
.
.
0
cQ
S•..
.ri
N
N
b
O
h
h
O
O
O
O
O O O
O a
V
O
O
O
O
0 0 0 0
v1
W r
i
O
.Ni
.Ni
O
V
vl O O r
O
C
b
V
<
h
h
O O O P
U
v
+
m
O
o
o
rn
o
°
i ~
+
_
O
C
O
o
S N N r
O 19
N N O b N M
q M n b M h h
N N h O h
01 M
~ N
O b M O D, b
N O b M O P r
a h b W O N M
O V O M O q
M N V d m ~ pj
h O
(A
O 0 0 h o 0
~n o N h l!
M ti O b N ~ ~
N M h ~O M ~ ~
ti O O O O O ti
0 0 0 0 °
O O O O O O y~
O O O O O O r
~ O O S O O p
M SO SO 8O O O p~
O O O O O O Oq
O
a
+
Q Q
M O
O
vl
O O O O
O O O O
N O
h o
O
0
.N-i
O W O O
o a o o
D\ O O W
a o o a
~y V
C
+
i
ti
O
94
Q
0o O
O
h
O O O O
pp 0 0 0
I
a F
N O
.n o
O
0
N
O W O O
o a o o
O~ O O W
0. o o a
O
H Q
C
i
V
h
m m
o
C
V
m M +
N
+
H
en
W W
6° S°
6°
8°
B° B° S B°
6° B° 6° S
W O
N
O
V1
O O O O
O O O O
z
W 4
V
i S
O
O T O O
H O O P
E.
O O
V
Vl
M M
O M M
i
;w
, Q
~
H
N
M
V V V V
Vt h h Vl
? Q
!
!yy
W
'
Q
S
O
N
O
N
W
O O O O
N N N N
y
O O O O
N N N N
N
O
i
W (
Q
Q
Z Z
^
~
N
Q
v+
b
M
\
fry
N O
r
~
.
i
N .
M
~
O
O
~
~
~
O
O O O
O O O O
7
i
_
o 0
0 0 0 0
W
o 0 0
0 0 0 0
a F
Q Q
H
Q
H
Q
ti
Q N N N
ti
N N N N
ti
Q
'Z Z
N
Z
N
Z
N
Zv
h
N
N~~ P
N
~
Q
v
i .
i O
e
e
9
v -
c
oo co
o
~
9
9
.9
.9
.9
W
«
o
«
o
~
o 0 0 0~
~
o 0 0 0
~
y
o
o
a
o 0 0
0 0 0 o
m
x F
Q' Q'
E1
N
'
N
E'.
N N N N
E.
N N N N
U Q
Z Z
G
^
~
G
O
G
N ti
h. O
C
N.
\
C
Q
.
.
N.
,J
y
O
y
O
y
O O O
y
O O O O
y
°i
"
"
"
a
a
a
a
a
x
m
w
N
ro
m
[u•
~
aa
a
w
h
~
x
¢
N X„
a r x
~
N M
M
M
U
S
~
R
N N
~ M
Z
N
O
O
M M M M
M M M M
v
Y
C
v n
0
0
0
y a
0 6
0
a
Y1
F.
Z
w T
Z
Z
0
Z 0 U U
0
W
~
A YC Qp 'N
F
F
0
w`° 0.1 m
v
~
o
>
W
0
0
0 •Ce
m
n .oa
`0tl~
.S
>
pp
p
o
ES
EEEE
°
F
v
.
c
w
C
m
ro o 0
v
0 0 0 0
O
m$
F
F
H z x x
x x x x
a
Q
y
p
p
A 9
9 a
a
o
C
'gy
b
.Ni
y
.Mi
y
~ u b e
b v e v
F
N
p
Q W
N
N
N
W W W
N
4 W
W
~
~
~
L
W
r ? O
h
b a0
Q
b
v F F
m 6 6
23 ~ ~
O O
o O O
w W W
$ a a
a a j
g O O F.
W W O
F F
A w W Q
> U v .aa
a a u
8
h
w
a
v
a°
O
Wage 8 of 12
O O O
O O O
N
a (r
Q
Q'
N
N N
_
N N N
d' d d'
Q Q
z
Z
~ ~
N
N
z iZ z
U A
N .
z
.
i
i O
v
0
n m
0 0=
r ao
o n o
z
z
z
Q
z z z
o
o o
0 0 o
° z
o
0
w
N U
r O
z
z
°
h h h
r h
z z z
z
F
a
v,
~
T v .T.
3 3
Z
~
pQ
I
-1
.
1
F
z
z
C
'
~d'
~m
t =
z z z
..I
N
o
J
^J
aQa
(y 81
0
u
ozo
aFM
as
~u
x4
x
~
4
W z
W
c4 H
¢
¢
ti
w
w
w '
w
'
w
w w
'
D
5
w
w w C
z
D o m
w w
d
> v
°
a
w
u u u
w F
o
w
z
a
a
u u u
O F
H
O
h
w
w w w
x x x
z
w w w
a
w
F
U
M W
N
T
rn M '°y'yo''
Q~ Q
ao a m
F
~
{a{yy ~D v
p
~
5~
.w.
d
rn
.
i
w
k k k
Y.
k X C7
p77
t p
6
m e b
a
m
m m v
n n o
U
U
T
.
a
~o
m
M
a
.
.
M
M M m
m m M
o0 0 0
H
U
W
a
m
C
a
a
a
.a
a
a
~F'
ro
d
y
y
N
U
N
ti
N
U
v
k'
w
v,
d
v
u
z
c
c
v
c
m
y
~
~
ti
o
m
vp
D
SO
CC
p~
❑C
p
CC
~
o
°i
G
~
a
qN
y
Np
ti
V
R .4G
O
S
i.
i
N
r1'
y
P
j
^
T
T>
T>
T
z
A ''y
r
F"
u
v
4
g
9
.
E
2
2 'c"
E
g
w c
' 3
N
c
v
c
v
F
q
v
z
~
z
v
ro
o
x
5
ul
5
y a
0
x
44
y A
fl
ti
v
,.1 x v
E, v z
.
y
Q
d
n
O
N
N
N
N
N
R
z A O
ti
a~
N
W
~C
9
p
L
y~
y~ p
L
g
:y
„^a 12 ~E
°
°
w
w
w
w
w
£ 5
i
h w" w Page 9 of 12
°o
°o
g
°0
00
00
°o
0
F
0
O
o
°o
S
°o
a
o
°o
g
o
o
°o
g
°o
"on'
a
va
~a1
U
~Gy
A
0
N
n
N
v
0
N
O
0
N
N
t~
0
N
m
0
N
m
o
N
=
a
d
F
0
0
0
0
0
O
A
a
o
O
O\
S
O
tl°,
P
S
O
o
O
O\
W
U
M
M
O
M
M
" i
H
O
F
F
.r
sE
s
ae
ae
s
~
s
A
a
W
]
°0
o
M
0°0
a
0°
o
M
°a
a
C
o0
o
M
00
o
M
000
a
ti
~
z
J,
p
a
p
ue
o
o
s
a`
qe
o
q
sc
sR
S
o
4e
o
q
a
a`
►
'
]
p
M
M
G
M
M
~
y
Z
vl
~
~
O
`Y
F
~
U
E
N_
N
N
N
N
N
N
W
A
M
~
A
M
<
0
.~i
<
0
O
-
N
<
o
c
0
N
c
0
T
c
0
x
~
U
~
z
~
~
~
~
~
0
0
0
0
y
y~yy
yp
~
N
N
N
N
N
N
N_
Q
~
O
~
A
o
o
=
o
0
0
0
Cy
U
w
.'i.
~
N
~
M
~
N
a
entry
~
M
M
M
M
M
r
F
M
M
M
M
M
M
M
F
W
W
p
~
W
F
~
a
w
w
a
w
a
w
a
w
w
a
w
F
z
U
~
a
a
d
V
d
V
V
y
C
5
~
tl
~
Q
R
fL
~
eV
td
Gl
O
~
C
C
N
'A
tl
O
(n
C
~
m
O
O
C
O
5
rt
A
C
O
0
Page 10 of 12
CITY OF LAKE ELSINORE
SUMMARY OF POLICY LIMITATIONS
AS OF JUNE 30, 2010
DESCRIPTION
U.S. Treasury Bills
CURRENT
PERCENTAGE
BASED ON MARKET VALUE
AS OF JUNE 30, 2010
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
LAW (Local Agency Investment Fund)
Current Balance
Bank of New York - Trust Sweep Account
Current Balance
0.00%
0.00%
0.00%
0.00%
10.33%
3.46%
10.35%
0.00%
0.00%
0.00%
0.00%
14.66%
0.00%
0.00%
60.14%
1.07%
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,514,820.16
UNLIMITED
$ 311,194.59
of Portfolio Maturing within one year 61.71% no less than 25%
of Portfolio Maturing or Callable within one year 85.94%
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-"
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 11 of 12
CITY
OF LAKE ELSINORE
PERCENT OF PORTFOLIO INVESTED IN FEDERAL AGENCIES
AUGU
ST 2006 THROUGH JUNE
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%
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%
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%
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%
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%
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%
AVERAGE
0.42%
15.55%
4.98%
3.69%
A Wl12 of 12