HomeMy WebLinkAbout2007-09-11; City Council; 19145; Report on city investments as of 7/31/071
CITY OF CARLSBAD - AGENDA BILL
AB#
MTG.
DEPT.
19.145
09/11/07
TRS
REPORT ON CITY INVESTMENTS
AS OF JULY 31, 2007
DEPT. HEAD >%^
CITYATTY. "£&-
CITY MGR. ""ISP
RECOMMENDED ACTION:
Accept and file report.
ITEM EXPLANATION:
The City's Investment Policy requires the City Treasurer to report to the City Council on a monthly
basis the status of the City's pooled investment portfolio. A quarterly report is also required for
the investments of bond proceeds held separately. The City's pooled investment portfolio as of
the month ended July 31, 2007 is summarized below.
Pooled Investment Portfolio (Cash and Securities)
Par Value
Cost of Investments
Amortized Cost (1)
Market Value (2)
Current Month
554,038,819
553,280,969
553,847,157
551 ,882,000
Prior Month
557,470,022
556,524,708
557,099,175
553,618,075
(1) The cost of investments adjusted for amortized premiums and discounts.
(2) The amount at which the investments could be sold. Source of market values is Union Bank
of California's custodial report as of 7/31/07.
The equity portion of the various funds in the total portfolio is summarized in the graph below.
Fund balances are restricted for various purposes. See Exhibit 7 for a more detailed breakdown.
FUND EQUITY IN POOLED INVESTMENTS
(Dollar Amounts in Millions)
vCapital Projects
$256.6
General
$60.6,
Other $.1
Internal Service
Agency $34 6
Enterprise
$143.0
Total Treasurer's Investment Portfolio at Amortized Cost
July 31,2007 $553.8 Million
FOR CITY CLERKS USE QNL Y.
COUNCIL ACTION: APPROVED JSC
DENIED D
CONTINUED D
WITHDRAWN D
AMENDED D
CONTINUED TO DATE SPECIFIC
CONTINUED TO DATE UNKNOWN
RETURNED TO STAFF
OTHER -SEE MINUTES
D
D
D
D
DEPARTMENT CONTACT: Nancy Sullivan (760) 602-2473 nsull@ci.carlsbad.ca.us
PAGE 2 OF AB REPORT ON CITY INVESTMENTS AS OF JULY 31. 2007
Pooled Investment Interest Income
Cash Income Fiscal
Year-to-Date *
Current
Month FYTD
2,819,087
Prior
Month FYTD
0
Current Month
Income
2,819,087
*The cash income received is adjusted for any accrued interest purchased.
Pooled Investment Performance/Measurement
May 2007
June 2007
July 2007
Average Life
(Years)
1.93
1.87
1.86
Average Yield
To Maturity
4.44%
4.47%
4.50%
Modified Duration
1.751
1.686
1.681
All pooled investments have been made in accordance with the City's Investment Policy adopted
January 2, 1985 and last revised February 13, 2007. All investments were initially made in
accordance with the City's Investment Policy. Events subsequent to the purchase might have
resulted in some investments not being in compliance with the current policy. These events are
typically a change in the City's Investment Policy, a change in the credit rating subsequent to a
purchase, or a temporary reduction in total portfolio assets. See Exhibit 8 for details.
The pooled investment portfolio has the ability to meet the City's cash flow demands for the next
six (6) months.
EXHIBITS FOR POOLED INVESTMENTS:
1. Investment Portfolio Breakdown By Amortized Cost, Market Value, Cash Income, and Average Yield
2. Investment Portfolio Breakdown Of Maturities
3. Yield Comparison Graph
4. Cumulative Cash Income Graph
5. First Quarter Transactions
6. Detailed Investment Report
7. Fund Equity in Pooled Investments
8. Corporate Note and Commercial Paper Ratings
9. Percentage Weightings By Corporate Note Issuer
EXHIBIT 1
o
oLJ.
HOCo
tL
1- h-Z oii111 O
^> ^^l_ ^
U) »
> J
Z Do r9
F CARLSBAAS OFO
^^
O
0)
0)
3
(J
OQ
Q
..J
Mi
£
uiC3
<*i^^f^i^
^8|
(0
^T0
Hi
^-j5
T, MARKETo
^J\J
Q*u
K
CCo
^5
^
OQ
^>
^O
§
1o
o
LU
ERAGE><
b._o
a
2. 8 8 8 8^ d d d •sr
£
0S
^0)&•^3
O
Si o o o oo. o o o co^ d d d -<t
0) o
O Qo— £
o) 5IR 013£
TJ- o O O h-S- oO5 CO
T-" O"mCM
CM"
£
o
LU
^_l
>
UJ
^§
2
k.
B2»_a
CM O O O OO) Oo m•si-" CD"
m CM_
Si^~
(M O O O ^J-
«.Current Mot££Jo
^1-§o
QLJ
JZ
0
^f^
_o™0.
CD mo ^~
O 00m coCM"lO
C\l ^D C3 ^D i~
O h-•^r" CD"
g ~_
PN»
!§
CM O O O CO.c
1
^0c
£
3
o_ co_
o com o
^-m
"*
00CO
"*
00CD
OOmivTCD
COmm_
CDO5
m
oo
CM
m
5
^*^~
CD
O
in"in
in
o>oo"s
m"m
CM
in
mCMin
oo
CM_
00
§
sO)
m"co
en•sj-
CM_
CDO)o
CM"•sf
oooCM"00CD
m"co
O)
CM
CD"CDo_
CM^*
O 0000 CM
•sf -sf
CM CO00 i-•sr -sr
CO CM
^J-
^~
o oo
m"s
^
O CM
o"
oo
1 T^-
LO"
m_
^
CMCO1 00
o"
^__
oo
CM
"*
CO
o
CO
in_
00
CDs
CMin00
CO
U5
co"
oo
CDsaoo
^5
-^0
s
00
0CD"
oo_
S
oo
CD
co"mm</>
0
g
CM"00oq_
inm
in
i —
CD"0)o_
^mmw
^mi —
S"co"mm
,
3ft
'aU
1
JH
^
1
<J-
yS
J
6
^
?>TR - US Treasui*j
wa«rQU-i
&n\j
•tt'S
^U
|
O
|§|
Hi
M ^ ^
ed 'd ^'S E ^
5 ^ §|g O ffl
U ^ £«
"8 pa ft
M O w^ bJl ' — j
m ^ K-^
PH ^o •— '
"S O "^^ St P
t ' §
2 pj ^
U oo ffl
g, ^
g 5
FA - Federal AgCN - Corporate :ws
^-H
I |
1 3"~~^ 22 o"§ I*fc U
1 1
g U
LUs Q_o DC Z ^o <CODO
a.LULU
CO
oo
<m
EXHIBIT 2
--i Ooo i—i
O3oe£oa.
£sW o
5
P l-H
82
> Jz &HH ^
- '-<< 0PQ ce
3^c*<!U
tuo
>•
^HU
1
^^£f
<2>
L^|
KO
te]^
1i
§55-^
u
X
COg
S
E-H
S
^fe,O
0S
^s
§
BQ
^
oH
0)ONO
3
59
i 5 YEAIOH
O
o
5
S
8
CO
M
^O
t-
co
y
O
*WITHIN01ON
O
Sin
01O!OO
ON"en
en"
ON
01eno"
•*^-
ON O3.\oON
CD
Ol VOen ^t00 \O
O" of
en^ oo
i— H
ONvo
o"oo°i
H
en
^Hoo_
00
o"01en
o<r>oo
ON
en"01
en
8oo"
o
ONvq_ON"ONON
enOl
"ooen
o
o
Ol VOm Tj"00 \O
O" of
en oo
ON
**\oo"
en
ON<N
oovo
<N
°,CNr--
ON
0
Ol
ON
8 b u
>-Q
tJU oa
CO-1
8
H
8
6R "3
EXHIBIT 3
£oco
<*<
OH
Ou
QJw
>H
PHHH
<J r-. o
00 O> <N
fc >^
<D1 ^
hJ ^
X I
T 1
•J SH
2|S3
OOH
LOO mo in OLO OLO o mo too 10 om o mo mo 10i^Lnc4ONincNjpNiocNipNLQCNiois.LncsjpNLqcsj
<d <o in to 10" io" *t ^- ^ ^ co co co co csi oi oi csi T^ r^ T^
EXHIBIT 4
1 1oo
ctf
U
U
1oo
. 1 ^^^0 C2(U OV- 1 •— i<u ^
^•H ^H
>>
3co
«,r.<o.o^coc,^o
^
) o
1 fl}£
r-^• ^7
* i>-°T— ig,
•rl c/3^j XH
1 ^G •<— i5S
^1^V\
\
V
\
N
\
\
L\\y
\
\
\1
CM
OC
\
V\
1
V\»V
rt V«T 1L 'L_J v
c
s
^^m
^^Q.
<
(0
^
- <J)
U.
c
- CO
o- CD
Q
- O
Z
_ o
O
Q.
- 0)
<c1
3
t)
<
1
I0)
O)•o
D!
CQ
t
t
0)
ooc
+••0)
£0)
^^H
1 —
O)
- D^j
"5
CD^TC\JOOO(£)^TCNOOOU3^TCMO
CMCMCslCMi-i-i-i-T-
EXHIBIT 5
+^0)DC
£-
Ti®O
§oCM
ri
8CM
DCUJ
DC<
O
w
O P
g ^DC f^UJ oa
ocO
-° O
— Pa OO <
M- </>
0
•= «|3 «n O
0)E £1id
O
O •* CM •*q cp CM T-;
d c\i c\i LO
coco
. . 00CM CO LOCM CO i- . . . .LO_ h-_ CO_ O_ O_ CM_oo" T-" LO" T-" LO" CM" Kin CD LO LO co o enCM CM CO i- CM i- t-
CM" T-" CM" -r-" CM" T-" CM" T-
coCM
oo •* CMCO CM
O CM CMCM en coLO CO CO S
CM en i-c» en CM
LO LO COCM co i*~
OOCOTTOCOOOCOooiocMLOoooojinCM LO i- CM CM
OiniOOLOOOOcMincoocoLoinin
o o o o oO O O O 00 CO
OOOOOOOCM-«tO^OO^CMLOI^-LOoococor^ooo^cM
o" 10" o" o" i-" ^-" CD" LO"I^OCOOOOOOOI— OT-OC5OOO
CMOOOJCOOOLOLOOOiq n| i^. i- ^. t- CM co
88888888
ddddddddooooooooo o o_ q q o_ o_ o_
o" o" d d o" o" o" dr^oooooooIs"1" ^D ^D C5 ^D ^D ^D CDT-" T-" CM" -r-" CM" r-" CM" T-"
o
o
m co
LL LL
S co co CD CQ
ZL^lL'iL1
LL LL LL LL LL
LL LL LL LL LL LL LL
CMCMCMOOCncnCM
ooooooooCMCMJMCMJMCMCMJM
cpqcMqqcMT-q
r^ LO i^~o o o CO
CD CD CD CD CD CD CD CDooooooooCMCMCMCMC\1CMCM£M
OLOLOLOLOLOLOinCOJMCMCMCMCMJMJM
[S.|S.|S.[S.|V.|S.|S.|S.
OOOOOOOO
88888888CMCMCMCMCMCMCMJM
O"*'*'*'*'')--*'*CMCMCMCMCMCMCMCMr^is,[^^.|^|^|^|^oooooooo
CO3O
<
CO
COCDeo_
CM"
$
co"
CO
CO00CM_
oo"
CO
^p0^
LO
"^
LO
8
d00CO$oco"
5?o
LO
in
oo
8o
8o
co"
<:
<o2
l_l_
"-
T-
O
LO
o
8
SJ
§o
^0O
^CO1^o
o00
CD[^0
CO"§
K
CO
CM^J
CO
CM.
en"CO00
CM"
vOd^enen
*~
LO
r^
LO
LO•<r00
co"COo>
•*"
oo
8o
£r-
•*"
§oCM
ri
8CM
DCUJ
tt
OfcDC
LI_j
<
&
in
1oo_,_r
CM
CM"
12
T—
8^ —
CO
0
LOr-
LO
Oo
doq
dCDo
CM"
5?in
in
8
g
o
8O
CM"
^
^^—
CO1I
<LL
^
oCMen
o
80
S1
wUJ
EIi
oooo
LO
co"•<*CO
co"
8
oS
CO
CO
0
f^
CO
CO
o0
doo_
o"0o_
co"
6?oCO
CO
8
doo
8o
co"
^8CM
oCO
0
<
~^>z
<LL
^
o§CO
o
ooCM
oCO
o
^-
oD
8
ooo
o"
10"
oo
o8
o
^"
0
^2Tt
CO
oo
do
o"0o10"
3?o
CO
8
8o
8oLO"
CO8
wo1
CO1I
<LL
^
oSi
LOo0S0
§o0
o om o
oo" m"00 0CM_ •*
co" co"
o oo **
^D r^LO i-
00 CO00 i-CM •*
0 0
LO i-CM i-
00 CO
o oO CO
d CMO CO^3 00
o" oo"O 00
O- °lco" CM"
s9 ^po^ d^
LO OCM O
CO CO
88g g
o o
88o o
co" co"
co m88
CM C*55 C
o
CO ^\ II I
< <U. LL
r**" r**
0 0
c^O T-
00 00CD CD
00 •*o oo o
c^!i
oo
ooiq
[s^f
CDCO
co"
oin
CM
^>
^CO
0
fs»in
CO
oiq
[sj
CO
co"en
CM"
5?oo
CM
8
8o
8o
co"
^.
8CM
h-CM
COO
m\i:
<LL
^
0CM
^§
OOg
SJ?3o
CMCO
0CMO
co"LOLO
co"
CO
CM00CM
00en
LO
0d--
o^>
om
^CO
r--"inenLO"
d?Y—
*^CO
8
g
o
8o
co"
108
^oS5o
<
^^z
<LL
^
0CM
OS300o
§0CM
iO
enin
CM
en
co"
LO
en
o
LO00
0)
vPo--a>CO^>
o00
^_I
0)o
Sin
0?05CO
"*
«
5>o
Z
LO
^
^^—
COCO
o
LL
<n
>
Q
O
^
0
c^io
o0
c^§o
CO
^>en
T —
CO"
CMLO"
00
[^inen^
CO00
0
oCM^>
00CO
CDCO
00co_
^
0?inO)
CO
8
doo
LO"CMen
co"
^
^^—
o•c
1
16kl0c.
zo
|V.
0CM
O)
O
CMO0
§
1
CM00
COoen^"
00CMco"CO
O
COCMin
CD"
COco"
0
d"*-CDinr^
CO
00
in
«oo"00
of
CM
oCO
T-
o_
co"
LOen"CM
ii
CM
DCUJ
^
O&DC
LL_j
1
3
(0
o
TJc
CO
u
CO OCO Oco dCO Oco in
o" r-"o ooCO 00LO" in"
CO 0co q
co dCO O00 LOm" r-TLO 00CD 00
xp ^0o~- d^00 O
•* LO
•* CO
o oo o
d d
oo
LO" o"Tt 0G) O
•<t~ LO"
0s 0s"in mN. CM
COCO
8COco"00•*
T-
%
COCOcoco"•t
LO
6?00en
CO
oo
d8
LO"•<±enen"
CM CM
Q. 0-LJJ LLJ
CO CO
88
88o o
88o o
LO" LO"
8 ^5^5JM CM
o o
GQ m_1 _lI I
LL LL
LL LL
00 00^D ^Do oCM (M
O OCO CO
O O
7
C\l
o>3 r*.•= o£ ^~ S3
§a§CMocUJ
ots
Q.
CC
2
O
.—
n
1
!<•(00.
iOH
,
woo
2 H
So
(A
i
0g
CO0)£:
CO.cCOoq
^o0
<B (/)
•S c
<5 o0 E
S3 Ec o
CO U
§ </« cog sE <oi- o£
3
0LU
r*.ooC\J
os
_l
oc
Q.
c.2co
oQ.
OO
COc.0
too'cDEEoO
CO!c_Q.
CD
5B>>0
Q.3
^
1
CD£
£'3
tz.0
t3CDccoo
c
s?b
CD
s
T3
1i3~
.w
T3
CD
1
G'5
CD.aCOO
CDC
CO5
CD
—r—
"o
iCO
^COcCD
S
LU fiiliated Debtors.<
c
•el_CDO >;•5 .-^c O
Si0 *=
'2 z
E- |o E
0 «CO Q_
IECO 0)O i-'c -a3 CE *E w
o 2O <5
ainst Adelphiaell the City's sf0) <0
<o gE w•= toCO CDo c
-i-i C13 <"S i-
o tn
1 1LJ_
° co-
2 CD-CD -^2 2
-c Ss S^^S coCO §a-£
CD COS£-g 0
CT3 (V)
^ 1
5-5
1 |"^ O-C .,-,CO ^CO ii
mo 2c "°
O CO'•§ 5-D 1l'£ «.!2 3
T3 CO— COco 0
0 HO 1'•+-* >^
So«0
< 1-
EXHIBIT 6
r— T— Is* Is*. CD ^ 05 r*» T— oo io CD CM r** Q) ^~ ^" CM t~~ co co r** to Is*- co CD r*^ CM T~~ co r^ r** r*^ co CM o 05 T*~ coi— i— f- r** O} 10 I***- i1** oo 01 0) r*** ^~ o CD T~ o Is*1" co 0) P"* r** cw r^- co 0) CM r** Is- 01 CM CM CM ^ o T~ o T~~ co— *n O^OTCMCMOOOCMOCNI^OOJOTCnCOOJOCOThOCMCMOCMlOOCOCnOlOOOOOCOCDCDCDCDlO'^'«| .-.- ^-^-^^ .-." _" T,T.-^T.-^-^-T.-^- ."." ^^T.-T--.-
H™ o o o o co co o o co o o oo o CM o o o o o o CD o o o 10 o o CM co o o o o o o oo co co p^>
§o o o o oo o o co o o oo o 10 o o co o o o co o o o GO o o p*1" co o o o o o 10 ^~ co oo co
r^OLOOCMLOLOOOl— CMOOI^CMLOCMlOOOi— lOh^OCOOlOlOCOOlOf^OlOOO'^'COOO)
~ "^ o" co" to" h-~ co" CD" h*." 10" i^~ CD" CD" co" CM" ^t" h-" 0>" m" m" o" 10" co" co" co" co" co" co" CM" 10" CD" o" r*-" oo" o" i^-" CM" co" co" 10" CM"
10" co" co" co" CD" 10" co" ^t" co" co" 10" 10" co" 10" co" co" 10" 10" CM" 10" co" co" 10" co" co" co" 10" -^t" ^" 10" co" 10" co" co" co" 10" co" c\T 10"
§§§|Sj^|8RJ||||||||||^||^||gg|||||||||g
^ o_ r^ ^ CD CM_ CM_ io_ io_ to co_ cxi. o> r^-_ ^r_ CM_ co_ ^ io_ o_ o_ o_ T-_ N_ io_ oo_ o_ io_ io_ co_ o_ io_ N_ oo_ io_ o_ o_ co_ co_ ^_
~ o co CD ^" co CD o o^ r** oo CD CM 10 io r**« T— co to o 10 ^" co oo CM CM co CM CD io o h* co co t1*^ co o co O) oi
vP sP sp •vP sP sP sP sp N^ vP ^O Np ^O -vO ^O sO sP -vO ^P ^P xP sP vP sP vO xp sP Np -»p ^O vP -sP xP xP vP vP ^O -vfl sP^ __„. _. _ ^ __._„. .-~^ «_„.«.»_„„__. _____^^._^ _.__.-
cc
ppSSSppppinp-'tpr^ppppppininpppqqqpppppppSppp
Q ^ O O CM r^ h^ O O O O ^" O CM O 00 O IO O O O O CM CM O O T" O O O O O O O IO O O f1** O O O
2 < 10" co" CM" CM" to" 10" CM" co" co" CM" LO" •*" c\T TJ-" co" CM" -t" 10" CM" 10" CM" CM" 10" CM" co" co" 10" -^r" co" to" co" 10" CM" co" CM" -t" co" r-" ^t"
tf feO £>Q_,S OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOwfN ppppppppppppppppppppppppppppppppppppppp
f™1 ^T1 O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O OOc !3 ill OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO^^ r^) ff M o o o O O O O Q O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O
^d rf J O O O O O O O O O O O O O O O O O O O O O O O O CO O O O O O O O O O O O O O Or2 ft^ OOOOIOOOOOOOOOOOOOOOOOOOOCDOOOOOOOOOOOOOO^r O O O O O O O O O O O O O O O O O O ^" O O O O O r** O O O O O O O O O O O O O O
10" co" co" co" co" to" co" ^t" co" co" io~ ui co" 10" co" co" 10" 10" CM" 10" co" co" 10" co" co" co" 10" 10" TJ-" 10" co" 10" co" co" co" 10" oo" CM" 10"
U-U-U.Li.LLlJLLL
g cocococococococococooooooooooooooooooooc
ooooooooooooo
oooooooooooooooooooooooooooooooooooooooooooooooo
o ••
inmincococo^-cDcocor^r^§000000000oooooooooogcMCMCMCMCMcgcMCMeg
""""|^c^^^^— c\i c\I c\I ^ 55
O 1- T- T- O O
m lil
> DC
or^cninoocooo
OO")COh*OOCDOin
r^-ococji-ocMh-.cor^
com T-co-^T-cO'-'-cocococDCMinincococMinincMincococococMincM'-tcOi-incMcoinT-
§r^oiinoocooinoocoi^ocMcoocoooooooooooocnoo>cM-i-ocM,-,-,-pp<DpcMppoqcppa>inpcO'*pppppppppCMino>o>T-:pcM ocMpT-:ooirir^oouJocDooiritdoor^ococoocooQino^coo•*_ co_ co_ co_ co_ o_ o_ o_ ft r-._ in T-_ in o_" " " " " " " ~ " " " "
irioCTCjirioOO'-ocMoa>_ in co_ T-_ co_ in" ~ " ~o_ in in o_in" c\f CM" in"r^-^-inr^-OOOOO
iriirii^iri-^irir^uiocooocM'-r^inr^r^cnoo•*_ t_ o_ oo_ h-_ co_ co_ in o_ i~-_o~ cT T-" in" t^~ CD" co" in" in" (**•"ojococoor^cocor^oCMin-f— ^-incOi— COCMCOOTCJ
inoooo_ co_CM" ^t~_ _ _ _ _ _ _ _ _ _co" T-" of CD" c\T in" o>" o" co" iri~ CM" r**-"incDCWcDCMr^r^coincocoooCNJ^" T-CMCD TfCMCMOCO
_ _ _ _cf ^ f*-" T-~ rC in" r^-~cncococD^ti— coCOOO)^tm^tC7)
s?
§£
DC
CO
^pspvPvPvPsPsp.vPvPC^O^O^O^O^O^rf^O^O^_C\IO>OCOinOOCMC0ojr^cor^cMor^pojtoooOJ^-^lO^NppplOi-;
^lO^tTtlOTflOTfTfrTtTf
spvP^^P-vP -vPvOvP(T-o^er-o^o^ o^o^a*-O) T~ O O O T~ O O(D CD O O CO CM h-p o) ^~ ^" i"~ co r^»
^" CO "^ ^" CO CO CO
vPvPxP^vPxPspvPspNp-vPvP^Po^o^o^o^o^o^o^o^o^o^o^o^o^OOOOTj-^t^CXJOtOOOOPCJ-- -- - T— CDCDPP^tlOlOPf^-pT^evjwr^roppcocNj^r^tTtTt-^Ttioioioiri
S?
P r^O) 00
CO CO CO CO •<fr "^ ^f Tt ^ Tf
g oooooooinooooo-fooocMooooooooocoo^oooominoocopppppppr^ppinppcDpppppppppppppcopcocqpppcqinppcq
Q.ooooooooain'oNooooooiriiriooooocioooiocNicooocoin'coooT-'iijtcoocoincMOinO'-CMOcooocooot^cocMOOOoooooooi^inoocni-tcMOCM[;;Zcoco^oooocoocM<DOO)T-OT-inocMoocDoooooinoocoocnco-<tini--r-cocopo<n
II
h» IOr*» cj)O) O)CM" TT"
ocoocninomcoor^cMoOOO'*r^ococnocDi-O'
cocooooooor^oocMo 1- co oo o§OCMCOOOO)C7)OOOOOOO)C7)C7)in" in" CM" m" CM" T-" co" CM"in" T-" co" in" T-~in in CM in in **
UJoc< -ia <
||888888888888888888888§8888888888888888
o o p o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o oo o o o o o o o o o o o o o o o o o o o o o o o o o o o o o oo co o o o o m o o o o o o o o o o o o o o o o o o o o o o o or^ i~ o o o o CM m o o o o in o o o o o o o o o o o o o o o o o o" " " ~ " " " " " " " " " " " " " " " " " " " " " " " " "in" co" co" in" CM" in" in" co" co" CM" in" in" CM" in in" m" m" m" CM" m" CM" T-"co" T-" in" CM" co" m" *-"
_ _oooooooooooooooooooooooooooo"CMCMCMCM
ooooooo
CMCMCMCMCMCMCM
OOOOOO-^r-T-
•*i<t'*^t'}ii<t-*-<ap^t~ooooooo ~o o o o o o o
*5S
r^ K r^ N N i^ i>>N N 10 mo o o o~ o o o
ooooooooooo
8 S S R00 CO 00 CO
COaOT-r^CMCOCOCDCDCDCOCOCDCOCOOO-<ti-COCDCM'<tCOCO — __. _-T-cocor^coi-cMi— CMCMincMCMcncDinTtcMi^cMi— oincMcoi-Ti-co_or-'"toi--cocooooooor--cooor--ix-r--r--i'-inooooooinooincDcDcoco
0 8
tno^o oooocoooocooocM cOT—coT^
m ~S Z
ui => EC
8 | S T— cococomcoincoi^co & z 8cn i- in
^^^ ^____hK_
co" CM" co" co" CD" CD" co" c\T co" co" co" c\T co" co" T-" co" CD" CD" co" co" CD" co" CD" t" co" CD" co" co" co" CD" co" co" co" co" CM" CM" co" CM" co" co"
ooooooomooo'tmo^o^ocooooooocooi-incooocMOOoocOT-oopppppppcMpcoin''»Np-i-p'tpcqpppppincqinr--:cqoqpp-r-;pph-:cOi-:pp
''om cdocdoino-i-o co'cooooino-i-oocooocD-tocooini-oocoooin^-cocnooinr^ocn-'ti-'fo_ o_ o_ T-_ o_ •*_ h-_ co •*_ •* •* o_ •*_ in co_ in r-_ T-_ o_ cn T- co_ •*_ in r-_ co_ in o_ cn_ co_ o_ cn i-_ cn T-_" " " " " " " " " " " " " ~ " " " " " ~ " " " " " " " "
cd^-oo_ _ _ _ _ _co" in" cT cn" cn" co" -r- ^ CM" o"cNjcoococooooocDinh*COCMCOCOCMCDCD-t—
_ _
co~ co"inco
_ _ _
-r- r-" in" cn" co"
odco'fr---_ _ _ _T-" co" in" CD" co"
cM'<i-tocnT-cMoo-coooi-inocooo
§oooooooor^ooooooooooooooooocnmoooooooooooppppppppooinppppppppppppppppCMoqppppppppppp
inooocncMino ooi-o co oo in
fto> sz <
--O)OOOOOl
OO>OOOOCT)LO" T-" co" m" ir>" ir>" c\T
ioococMT— i— oOlOCOO500O)Ot0OO5O5O)COOT-" in c\T CNJ" T-" CM" co"
^ooioooooooi'~'^"'~cor^ino<DCDOOO)ii— OOCMCOCOOIs-'^'OOCDOC\JO)LOf^lOCOi— O^-OJOOO^"!— COr-O>OO>CnoOO)OCOO)O)OJO)CT>OOOlCOOOOlt— OOOCM" in ^" ^r" in" m" c\T in" co" CM" ^t" CM" CM" CM" in" co" CM" CM" m" CM" T-" co" CM" co" co"
oooooooooooooooooooooooooooooooooooooooopppppppppppppppppppppppppppppppppppppppp
8 OOOOOOOOOC9OOOOOOOOOOOOOO_ OOOOOQQpCDCDQOOOOOOOOOQOOOo o oo o oo o o
o o o oo o o o _ _o o o o o o
o o oo o o _ _o o o o o o o o o o o o
o o o§o oo ooooooooooooooooooooooooooooo
P. °. °. °. °- O_ O_ h- O O_ O_ O_ O_ O_m" CM" co" in" in" in" co" T-" m" co" co" CM" co" co"co" in in" m" in" in" co" in" co" co" m" co" co" co" in" co" co" CM" in" CM" CM" co" eg" co" co"
LLU-LLLLLLLLLLLLLLLLU-LLLLLLLLLLLLLLLLLLLLLLLLLLLL
cncncnoooooooooooooooooo
E I"=> <5°
oooooooo
CM CM CM CM CM CM ""
O O O O O O
CM CM CM CM CM CM
CO CM h*- h* F^ 1^
CM ^ CM CM CM CM
OOOOOOOOOOOOO
. ___
. _. _ jj P: 35 ;= ^ c3CMCMCMP^OO--,. -. Si co •* in in co i-OOOOOOOOi-
m co ino en co r- cj co •* o o f-CM o oo to oo oo coco oo r-~ r*- f- r~- co
IDh-h-.OOh-OCM'^-TfOr^<ocpppcpiooj<0cop
''88?COencDOOCDt^CMCMCMOO-COCDOOCDCOi-COCOCMo ^ T~ o o co en co Is* Is* mCM" oo" |C o" o" co" co" in T-" T-" oo"ooincooinTtr^ineocoin_ CD_ r--_ in in r- CM •* co_ CM_ CM_ CM_> CC\ co" co" CM" CM" co" T-" CM" CM" r-" T-" CM"
Z
c\ioc\ir--
inCM"
coc\ioCMcoo co oo T- co i-
coino»-CMor^cooo cooco<ocoocoo
CMCMin
S
Tt Tf
m" m"
Tt
g
CM m co o co oo in_. _ co o oo 1- inco CM oo in i- en in
CMm
m
co co co in o
min CM co CMin co" CM" in in co co
cor-~
coen en co en Tt in o
CM Tt ^- r^ co co_ co
co" CM" CM" co" co" co" Tt" CM
co <o
«5m
S
mi^i^ooi-~ocMTtT-Ni-;<pppi-;IOCNCpC\l
f'cricooocrir^cMCMcoh-<oooi^incocnr~in in o o_ o> o_ co_ co_ Tt_
i <D en Tt" co" co"
oo CO COco co
CO CD
en en inen g 3>-r--i-cocooocncMcococn3)cnpincpTtpcn<ocopp
r^ooo-Ococno^'Cncooiv^cococor^inh-T-cMcOTtcni-or^T-ooinO'-<oen r^ in r^ CD oo r^ *~ co ^~ co eo co o1) en oo
co
0
o oin inco coen" en"
CO 8in CM
in in
co co 8inco
i- in to co co co coco Tt CM i^ o in oooo co CM in r^- co •*
5%£2cc
CM-^ppppCMCMCMiniriiriiriiriiriiriiriiriiriiri
in coco CMCM p
Tt O
isco
o o
CO CO
sp vpo^ 0s- _O O O O O in o o o o o§cooocMCMCMOoininr^ _poo)r^i-;CMin'<t'tppiniriiriiriTtTtiriiriiriiriiriiriirim
S Si
oinooomoooTto 5>Q . o h*!Ti c en ooEUJ O
coen" CM" co"§co oen o
i inCM
o in in o? 8 8 fc
ooSen"S
o oco coco co
CM
00
en eno o
oooocMcocncooooo-^ooooococopooTtpT^pT^eopcocopp-a:
cMcoo.cor5i-coo^TtinT-cocMocD
Sf
en oo co
CM" T-" in
--mooocor^OTtininoocnooo-O-O-oooooT-CM" co" in T-" T-" CM" co" co" W ^-" CD"
coCMco
88888888888 8 88 §8888888888888888ooooooooooooooooo o o o o o oo o o o o o oo o o o o o o en eno o o o o o
ooooooooooo en min§0000000001^ in oooooooooooooi^ m oo
co" co" CM" CM" co" r-" CM" CM" i-~ i-" i-" T-" CM" CM"
Tt Tt mo o CMin in en
o o o <o~ ~ in in
°°. °lco co CM in in co co in CM CM co co co Tt »-" m"8 8
£ £
m
co
O
CD
CO
<!
o
m
co
o
O
LU
USE FIN 6.95% DUIO
rr
GE CAPITAL FlO
Oz
in
NK 4.1 25% DUES/S
CO
CD
WORLD SAVINON-CALL-7
625% DUE 8/3/09 1Tt
<Oen
BANK OF AMEI_j
*r
JE 8/1 0/09 NON-C/Q
5?R
WAL-MART 6.8_i
O
Zn
5% DUE 9/1 0/09 N(CM
•<t
MERRILL LYNC_j
1 1
DUE 7/29/1 ONON-(5?oin
Tt
US BANCORPE8/15/10NON-CAIQ
5?in
WAL-MART 4.7UE 2/1 4/11 NON-CQ
5?inCM
CITIGROUP 5.1_i
UE 2/1 4/11 NON-CD
S?inCM
CITIGROUP 5.1UE 2/1 4/11 NON-CQ
S?inCM
CITIGROUP 5.1_i
DUE 3/1/11 NON-C8?
8iri
HOME DEPOTO
0
5.50% DUE 4/28/11O
LT
0
GENERAL ELEO
0
5.50% DUE 4/28/1 'O
LT
c3
GENERAL ELEt_i
O
o
i
LUD
Q
S?TOYOTA 5.450_i
5
LU
Q
S?
g
iri
O
DC
13
GENERAL ELEiO
oz
5.875% DUE 2/1 51'O
DC
13
GENERAL ELELLLLLLLLLLLLLLLLLLLLLL zzzzzzzzzzzzzzzzoooooooooooooooo
Is
co
CMCMCMCMCMCMCMCM
O O O O O
00OO
S!
inoi
ooooooooooooooooCMCMCVICMCMCVJCMCMCMCMCMCMCMCMCMCM'T— cooocoinmCMT-OT-T-CMT-T-T— t— OCMCM^— i— i—cS?3-ooSc.-F;coe\Ic\Ic\l5.^^5.?:c\IOOOOOOOOOOOOOOi-O
CM r^. i^ r>- r-
8888CM CM CM CM
C3OOOC2OOOOOO
UJ
L
UJ
DC
D
tiCC
8
CM•>tr^CM"
8
COo8?o"
CO
T-"
CM•*
§cnsco"
COCO5co"§co"
CMincoCOCM"coin"
CO
TfTcoCD"
5co"
O)CMo
co"
CM
•«t"
S
coCM
S"
CO
C\T"*co
2 8
3 ' S co •* coin ^ coco co co coS
O)"CO
1-
UJ
UJ
inCM CM .-r-_ r-t CO
*t •*' •*' iri in in in in? S
o
CO CM•t COco coCM" o"in T-co co
CM co .o o inm i- 2S o r^co co oo oo> -^ o o• ~ - o
!5Fr-._co" co" in co"
op m opCM"1- Tfo r^ h-t oo o
S
05
8 5:
CO CM•^- COco_ ooCM" o"in T-oo co
CM co o o inlO i-; O> p .Nco co oo o coO) Tt O O CMco in co o i^
•* o f- r>-i^ •* co oco" CD" in co"£ 3
oo
00
•tinin
DCCD
UJ1Q-l o o o o o o o
EXHIBIT 7
CITY OF CARLSBAD
Fund Equity in Pooled Investments
AS OF JULY 31, 2007
Cash Balance by Fund:
General 60,628,580
Special Revenue 37,845,864
Debt Service 2,005,558
Capital Projects:
General Capital Construction 46,456,976
Traffic Impact Fees 11,781,381
Public Facilities Fees 51,514,959
Park Development 3,265,162
Transnet Taxes 7,942,079
Drainage Fees 10,408,467
Special Districts 88,196,338
Infrastructure Replacement 36,794,416
Other Capital Construction 3,216,971
Total 259,576,749
Enterprise:
Carlsbad Municipal Water District 68,533,742
Sewer Fund 61,352,014
Solid Waste 6,638,282
Storm Water 929,968
Golf Course 5,528,151
Total 142,982,157
Internal Service 21,961,836
Agency Funds 34,634,681
Redevelopment Funds (1) 0
Misc. Special Funds 0
Total General Ledger Balance ** 559,635,425
Reconciling Adjustments (2) (5,788,269)
Total Treasurer's Investment Portfolio at Amortized Cost 553,847,157
(1) Redevelopment Fund Balances are interspersed throughout all funds.
(2) The Reconciling Adjustments consist of differences between the General Ledger which is prepared
on an accrual basis and the Treasurer's report which is prepared on the cash basis. Accrued Interest,
amortized premium or discounts and outstanding checks and deposits in transit are not included in the
Treasurer's summary. Differences between the time journal entries are posted and the time this
report is produced may also be a component of the adjustment.
** Figures based on best estimate at the time report run on 8/8/07
EXHIBIT 8
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF JULY 31, 2007
CORPORATE NOTE AND COMMERCIAL PAPER RATINGS
Corporate Note Investments Meeting the Current Investment Policy:
(Ratings must be AA or better by both Moody's and S&P)
Moodv's S&P
CITIGROUP AA1 AA
GENERAL ELECTRIC AAA AAA
BANK OF AMERICA AAA AA+
MERRILL LYNCH AA3 AA-
TOYOTA AAA AAA
US BANCORP AA2 AA
WAL-MART AA2 AA
WORLD SAVINGS BANK AA1 AA
Commercial Paper Investments Meeting the Current Investment Policy:
(Ratings must be A1/P1 or better by both Moody's and S&P)
(Ratings of other debt must be AA or better by Moody's and S&P)
NONE
Investments with Subsequent Changes in Credit Rating *
Latest Carrying Market
Moodv's S&P Maturity Date Purchased Value Value
HOME DEPOT AA3 A+ 03/01/2011 06/12/2006 2,981,291 2,953,020
* The City's Investment Policy allows the City Treasurer to determine the course of action that would correct exceptions
to the policy. All of these investments are paying interest at the required times. The principal of all investments are
considered secure. It is the intent of the City Treasurer to hold these assets in the portfolio until maturity unless events
indicate they should be sold.
EXHIBIT 9
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF JULY 31,2007
WEIGHTINGS FOR CORPORATE AND FEDERAL AGENCY ISSUERS
PERCENTAGE WEIGHTINGS BY CORPORATE NOTE ISSUER
Investment Cost Percent of Portfolio*
BANK OF AMERICA
CITIGROUP
GENERAL ELECTRIC CAP
HOME DEPOT
MERRILL LYNCH
TOYOTA
US BANKCORP
WAL-MART
WORLD SAVINGS BANK FSB
1,983,918.00
8,961,239.70
18,476,716.50
2,974,590.00
4,884,751.43
4,054,280.00
2,952,150.09
8,189,992.98
2,999,689.80
0.36%
1.62%
3.34%
0.54%
0.88%
0.73%
0.53%
1.48%
0.54%
PERCENTAGE WEIGHTINGS BY FEDERAL AGENCY ISSUER
FEDERAL FARM CREDIT BANK
FEDERAL HOME LOAN BANK
FEDERAL HOME LOAN MORTGAGE CORP
FEDERAL NATIONAL MORTGAGE ASSOC
HOUSING URBAN DEVELOPMENT (HUD)
TVA
Total Portfolio
Investment Cost Percent of Portfolio**
13,943,959.60
172,787,948.01
157,390,211.65
105,796,524.89
990,198.00
2,130,980.00
* No more than 5% may be invested with a single corporate issuer.
"There are no percentage limits on federal agency issuers.
2.52%
31.23%
28.45%
19.12%
0.18%
0.39%
$553,280,969.26