HomeMy WebLinkAbout2007-01-09; City Council; 18853; Report on City Investments as of 11/30/20061
CITY OF CARLSBAD - AGENDA BILL
AB#
MTG.
DEPT.
18,853
1/9/07
TRS
REPORT ON CITY INVESTMENTS
AS OF NOVEMBER 30, 2006
DEPT. HEAD if/M
CITYATTY. ^ (&¥•
CITYMGR. ~2DV>
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 November 30, 2006 is summarized below.
Pooled Investment Portfolio (Cash and Securities)
Par Value
Cost of Investments
Amortized Cost (1)
Market Value (2)
Current Month
499,294,938
498,744,248
498,317,300
496,199,829
Prior Month
503,053,142
502,523,491
502,106,900
499,002,183
(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 11/30/06.
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)
Special Revenue
$33.6
Capital Projects
$ 236.5
General
$41.:
Other $5.2
Internal Service
$22.1
$23.2
Enterprise
$135.9
Total Treasurer's Investment Portfolio at Amortized Cost
November 30,2006 $498.3 Million
DEPARTMENT CONTACT: Nancy Sullivan (760) 602-2473 nsull@ci.carlsbad.ca.us
FOR CITY CLERKS USE ONLY.
COUNCIL ACTION: APPROVED
DENIED
CONTINUED
WITHDRAWN
AMENDED
D
D
D
D
D
CONTINUED TO DATE SPECIFIC
CONTINUED TO DATE UNKNOWN
RETURNED TO STAFF
OTHER - SEE MINUTES
Council received the Report.
D
D
D
D
PAGE 2 OF AB REPORT ON CITY INVESTMENTS AS OF NOVEMBER 30. 2006
Pooled Investment Interest Income
Cash Income Fiscal
Year-to-Date *
Current
Month FYTD
9,452,277
Prior
Month FYTD
7,326,403
Current Month
Income
2,125,875
*The cash income received is adjusted for any accrued interest purchased.
Pooled Investment Performance/Measurement
September 2006
October 2006
November 2006
Average Life
(Years)
2.09
1.95
1.97
Average Yield
To Maturity
4.26%
4.28%
4.32%
Modified Duration
1.909
1.784
1.802
All pooled investments have been made in accordance with the City's Investment Policy adopted
January 2, 1985 and last revised October 18, 2005. 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. Second 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
0
Ou_
cc
O <o
°- §
zuj cT
2 °°h- DC
CO UJ
UJ OQ
> 5
CARLSBAD INAS OF NOVEILL
O
O
COCO1
OQ
Q-4UJ
UJ
CD
cc
UjS!^
Q
^UJ
INCOMiJ.
COs
^2
MARKET VAL1-8O
Q
•U
^^jj
QCo
5
^
^*OQ
I
OQ
^SQCOQ
-C
|
k.d 0
UJ £
UJ< 1s ^< •£
£
3o
8 8m d
8 8
™ d
0) o> ° °
f!— •!
M a
o >•
1o
3 1
0 0oo
oo"oo•^t
^ft
MARKICurrent Montho ooo
oo"00
|
•jj
H OOT •£o £
o o8
oo"oo
oo
UJ ,-, ^e £ s °
C c
_
< B£
o
ooo"00
"*
W|« n x"
OO
0o
o
oo
o
0
o
o
o
o
CD1 —
•*
<J>
CO
•sfs
IV."
COCOCO
LO"
PV
^5
sO)
8CD
o"
CM
|vT
CDh-
5"
CO
IV.o_
P^J1
CD00
CM"
LOoo
oo
T —
8Y—
LOo_
1 —
CMO
CD
^~CD
TJ-"
00
CM
CMO)
CJ)"
oLO
CM"oo
LO"
8CM
1— T
(v.
00
O)"
0
LO
1—
LO
ro
^co"
LO
CDCDoo
oo"CO
CM"
T—
00IV.
Sco
CM"CO
CDCDoooo"
^8"
00
IV.
LO"OOco
CM00
*
CMOO
?
co"
O
sCOg
.
s
CO
CD"CO
ooCM
*
CO
oo
LOco
of
LO
8co"COCO
COCOCM
CD"CD
^_r
CO
co"COCO
COCO
CM
CD"CDrv
ooCM
'
co
o
CO
co"
LOCO
LO"
1
CM"
00
CO
co"
CO
LO"
s"frc\r
Qoo
0?00
CM
35
"*
IV.fv.
CM
CM"
co"
™c\r
Qo
co"CO
CO
00
1
co"CO
o8
co"o
CM"o
g
COrv"
COoo"
Q-
0
DC <
UL * ±o <
ao
fe
o
Q-
LU
LU
W <m
<n
\5
fl ^
•°
& I
U So
EXHIBIT 2
pd qo qd (NOO
<Nd 10
VO
qd
0JotaH±
O ^in 0g*a ®M <^>INVESTSVEMBERQ O< Zpa fa
2§C^ t/2
5^
bO
SN4U
b3
g
^fe,
ttj
1a
Q
§
13
CLASSIFlfcs
'TIESB1
E-H
1
>
--<
H
^^J
W>H
IT)
8
^H
a!•**Ec
O3
tt
OSt-
O
I«3
oo
^
1010
VD
CN
CS
oo°im"
ooO
mo
1010voo"r-ooo"•o
VO10
10(N
o(N
00o"
XT00 voCO vo g
r~ oo I06"
ON <-*
VO OO
p. ^
Iff 1O*^H OO
Tf (N
voen vovo
vooo
oo"vo10
(N rovom
qd
u
3 .3
a.U
u
I
oo
OH
I
EXHIBIT 3
fcooo
&
<
CLH
O
U
Q
r- >
^
HH \0
3 O
<! O
hJ <N
t/5 ^> w
TT «& s< m
J >xow zo 'HTJ ^O
J ON
R2
H >H
»j JO D
OH "->
EXHIBIT 4
i i
O
O
03
U
>
u
1o
oo C
<U O^, 2^i« 3
Montho
^o
0)a
do
d !—i
»
V
\
II
\
1
o oo <oCM i- i-rrCsJOOOCD CM O
c
3
(0
CO
0
U.
- CO
0
Q>
0
o
OO
Q.0)(/)
U)
(0
o
O)
T3
ISffi
ncome0)
•a 3<!> m10>
i**- co CNJCD CO ^J1
i-' LO uoO) O> 00r-- co co
"88
T- LOLO" co" LO"
•<t
CM
CM CO O>00 CO O3
LO LO COiv. <j) coCO CO CD
CO" |v" CO"
Is** T™ C^co T- h-
xp vp ^p
PV. ^S. ^N,O 03 O|v CO O00 Tf O
•* LO LO
LOCO CO
i sn
LO O 1-1- O LOT-_ q rv_
co" LO" ^•^- T- CO°, p. °°.LO" LO" •*"
LO LO CMCM CM i-
888
o d o888
8 8 8°. °. °.LO" LO" LO"
CDO
CM
CMO
O O 000 0 iv.
o LO ivO |v 03
o" co" co"LO O3 C3
•*_ •* CMco" to" CM"
O LO COO CM CM
O W C)O CO O>O LO CM
S 1^-" O)"O) CM•t •* co
•^O vP -vP£5^ 5^o o883
CO CM CO
§LO OIV. LO
d 06 iv!O i- 00
°. "N. 'Go" oT o>"§05 CO
O) O>
CO" •*" T-"
&^ ^ o^§LO OCM OO i- i-
CO CM CO
888
d d d888
888o o o
CO LO CM
11/09/200505/20/200411/27/2002888
O LO COO Tf COLO TJ- CO
S" LO" co"1- •*CO CM -i-LO" co" CM"
o o Po q co
O LO COLO •* T-t~~ •* T-
CM" LO" co"
LO T- •*
CO CM COCM" i-~ CM^
vp xp vfltf^ S^ o^S8^
CM CM CO
O O OO O O
S881*- O O
r-" o" LO"o> o enO> O OJ
CM" CM" t"
<§§!
0^2
CO CM CM
O O OO O O
d d d§o oo oo o o
888
LO CO CM
12/27/200506/29/200406/29/2004T-
T-
<ds
B°i
CM
(O00
Sooi^
^g
CM
«
s
iof
§
§ea
|
8
oo
8
CM"
co"
0
8LOCM"
3?IV.«"*
OO
8o
8
LO"
3?o
LOCM
CO
Oq
§
o"8LO"
COoo
oo
8LO_
|v"COCO
LO"
oo
8LOrv"
00CO
3?
8LO
LO
Oo
8o
8oLO"
oo
LO
8
8o
8CO
T-
oo
8o
1
1
"*
8i
I
cT
LO
oo
8oo"oqLO"
8o
8
8o
8oo
EXHIBIT 5
ECLU
O
•o
CM
a I £^^£LL LL 2
< ffi 22 _l _l
Z I ILL LL LL LBCO CQ_l _l^ T. i:
LL LL LL
0 O
2 2_l _l
1 ILL u_
UJ i-
Q.
OC
O
O < J3^- </) ?=O ? o1-1?
0 H m o
O
<J>o0
S
1
01/2006^^-
S|
S d
O c5z T-
< <LL LL
T- O)58
^§S! CCM O>O O
01/200603/2006— •» —
T— T —
CD <O
C^ ^D
^ ^CO COo o^— T—
^8CM
§
Soc
UJ
D QUARTZOuHICO_l
o
tnm
oc
1s
ococ ui
U m mm g sOouj
o oO z
< <LL LL
CO CO
CD CDCM £M
O) OCD CM
T— T—09/200420/2003^ 55i- O
L?
SO
SCM
01/2002SIo DCUJ
fflS
UJUUJQ
< < <LL LL LL
888o o oCM CM CM
p- O) O5
^- co co888CM CM CM
S IV c5CM CM CO
c\j cS cST- O O
[V.
i
CM
UJ
D QUARTZouUJ
(0_J
o SALESlM»O
^^
?o:S uj
CO CQ
^g<J O
if
03OO
g
1CM
S
^ OCUJms
UJ
OZ
<LL
rv
CO O
8?
§8^8
^ or^^ ^u
UI
10/2006D QUARTLO ZO Q
ftCOJ§
H 7
EXHIBIT 6
CC E
1S
O T- CO •* T-CO 00 S- O CMh- CM CM cn co
OOCOi-OOOOCOOOOOOOOOOOCMCOOOCOOOCnOCOOOlDOOOh-QOOOOppco^tqppcoppppppppppcocoppcqppcqpCMppppppcpppppp
§'irico'<dodddcoiridiriddddddddce>ddco'ddcddiriddcoddd<ddddddTtoooo-'roococMof^ooooinoocMOOOcoininooo-'-ino-tooocOQinQooin
in" co" CM" in" CM" co" in" co" m" in" eg" eg" co" co" in" co" co" co" to in" co" -»" co" co" in" in" co" in" co" co" in" m" eg" m" co" co in" co" co" in
co o o co in_ _. _ _ r^ o o oo CMmiDooicninoo-'-§coino<oocDomcoco'tint^ocnmr^cnincococMcnr^^-CMcOTj-
^ !"• O Ot^ oo m o
r^ <o en co i^i- •* oo en tCM T- CO TJ- CM
o
§
h- 00
8 EM
cginini-~T-<oinointcoenini-cocM^h-otvi^cnmcMincocoin<Dco<Dcoco
888888888|^|||||^g||||^|^|^||||||^8|||
CM
en o 03 oo o o cn cn o o o) o o o o o O) en o cn cn o en o en 03 O) o en en o ^ o o O) o cn o o
eg" t" in" CM" T-" co" co" in" co CM" CM" m" in" CM" co" co" CM" uf Tt" eg" -^-" co" CM" ^r" in" eg" in" eg" eg" in" CM" co" m"in CM CM t i- co
§000000000000000000000000000000000000000ppppppppppppppppppppppppppppppppppppppp
in" co" eg" in" r-~ co" m" co" in" in" CM" CM" co" co" in co" co" co" CD" in" co" •*" co" co" in in" co" in" co co" in in CM" m" co" co" ir>" co" co" in
OLLI(/]
1^ O O O*- o o or~ o o o
ininococDoioinocor^ooooooooO'-oinoooCMr^ococooinoo oocoiooooooooocnocMooini-comocooo^-in incncMinoooinooot^oNmocMm en o ^ oo o i^* Is* o in f** CD *~ in o co T~ CM co en o GO ^ r** ^ o co Is* o o in CM o in o ^ in o cvj in *~
incoincocoininco i-cocDcocDCMinincococMinincMincocococoinini-cocMco
t"-cooooinoocococoi^oii^oomi^oocOi-ocoincooinr^ooininooi-coco 1CCO §CM
8 i-eO<DtCMCMO
r^CO00
ooo
^ r»- T- r- mco co en ^ T—o en t in •>*COOOOOOOCOO5CM
IIz <
£oo
OOOOOOOOOOOOOOOinOOOOO^OOOCMOOOOOOOOOinOCOOOOpppppppppcopppppr^ppmppcqpppppppppppppoqpoqppp
§ddddddlridWdc>dOOOOOOt-OCMOOOp o_ o_ o_ in o_ o_ T-_ o_ o_ o_ o_ o_
00 O CO O h* O^ o
CO O O CO C5lrilrir~COCMcMcocD
oooooinooocooooooooinOCDOOOCMOOO'-COinOOO'-CMo_ o\ o_ p o_ T-_ o_ o_ p co_ •*_ o_ o_ o_ o_ CM_ co_
en" co" cT o" o" co" o" o" in o" h-~ co" cT o" o" o> in" o" in co" o" h-~ CM" o" co" co" _ _ _ _ _ _ . _ _ __ _ ,. _ , - ^iDt^ooooooo^reni^i-oooth»ocDcnocoi-o^'-oooooooo)OO^ioinoc3)OOOOOOOOCnOOC7)C7)CO^~OOOCM^'OCOC71O^'O>OC7>CnC7>OOOOOCnOOOOOOC7>O•t" co" in" co" m" CM" co" in" ^t" CM" *-" co" •*" co" r-" T-" in" in" CM" in" CM" T" m" CM" CM" Y-" m" in CM" m" m" ^r" in" in" in" in" T-~ in" T-" co"
88888888888888888888888888888888888888888ooooooooooooooooooooooooooooooooo
o o o o o o§00000o o o o ooooco-
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 in o o oo o o in o o o o o o o o o o o o o o o o o o o o o in o o o
T-~ co" -t" co" T-" T-~ in" co" co" in" CM" in" in" co" co" CM" in" in" CM" in" in in in 10 in" m" W in" CM" co"in-fincoincocoinincM
IE X xzzx Z2XIXXXXXXXXIXZZZLLLLLLLLU.LL.LLU.U.LLLLLLLLLLU.U.LJ.
U.U.U.LLLl.Ll.
coooooooooooo^cncncj)o o o oo o o o
co in in in~ o o oo o o
P^fMfMCMCOOCMCMCMT-i^t^t^r^-^i^iooo^r^mooooooooooo
co in ^- in ino o o o oo o o o o
3J§
CNl Si i^ ^T- i- O O
i
r^ooino oocoooocooocMopincoLqpLOcqppr^pioo* ^" OO h*> O
8 8i^ r^(p tO CO CO CO
T-' T^ CO COen '" ~CMUJ
ffi£
i~ O Of^ ^ O5 00 CO •*" •*•"
•»•" CO CO CO O)CO en en co LO
S ooooincMi-cMCMi-Tj-ocoi^co-to^cMLni^ooi-cMt^T-coinocMcoor--cocoh-to en . •<» oenLoiocoLoi^r^iDiocOTrcocoooTttocjt--oc>jincDeoiotDiDojc\it-cMcor~(N-^r^cMt^r^r^i-i^i^oioco" co c\T to" co" co" co" co" co" co" co~ co" us CD" to" co" co" •*" co" to" co" co" co" to" co" co" co c\f
CO-00
CM"
8 8m LO
LO ^ O) LO COCVJ CO O) CSI CD10 co r*- ^ to
c\T to" co" 10" co"
OOOOLOOOOOIOOO'tOCOOOOOOOCOO-^lOCOOOCJOoooocMocoLooi--oo<<rocooooooincoiois~tooooO'-o
S oootootooooooOOOIOOT-OLOCDO O LO Oo en o
s
00
to
COCO ^»-CMO)T-Ooo OOT-CMCJCO
00 0010" LO"
en i— oo CM
to co en ^"oo o o co" ~ O CMCM Is-to oi- CM OCOCOCOCOtOCM-^CM-^-LOlOtOLOlOCO^-COI^I^i-COO 1
OOOOOOOOinOOOOOOOOOOOOOOOCMOOOOOOO CM OO
o r~
65 8
O CO _ _ .. _O_ •*_ tO_ O_ CM_ O_o" <o" CM" o" T-" o" r*-~ o" o"
tolOto
o oo po o
i- p 10 T- min co o oo ooto ^" T— co ^ti-" o" CM"
in 10" m" CM" *-" in" CM" CM" co" CM" co" CM" in" •*" •*" 10" LO" CM" 10" co" CM" t" CM" CM" CM" m" co" CM" CM" CM"CM
5
g 1^ 1^ f^ r-cn en en CM i-
i-" •*" CM" •*" co"
888888888888888888888888888888
§00000000oooooooo
oo 8 88888
o o o o o o o ooo o _ _o o o o o o o
10" in" in" co" i-" LO" co" co" co" co" co" co" m" in" in" m" in" co" in co" co" in" co" co" co" m" co" co" CM" CM"
o>f-
co"CM in co -t co
ooooooooooooooooo
^^y-ivy-i-jiV^
Ql ooooooo
i£
co
IS
to
Ienco
m
OODC
O
CO
<O
O o
c i: o
CM fc-
53
HI
Q
5?
£in LO Q
Q_ n ^
< < inO O S
"SoHI '" HIOHI
H, Q]
HI _|
H <
DC
HIz zHIo
LO
m
coHI = HI
< W <DC t ITHI O HI
Z HI Z
HI DC HI
O O O
•z-z.-z.-z.~z.o o o o o
..Ot-r-T-T-7-OOOOOOOOOO
.. t=s:r=acM«P:r^CMCMCMCOCMCMCS
OOOOOO^OOO
inmLnininLntototDtototocototoooooooo~~~~~~~~o o o o o o o oooooooooooooooooooo"
CM CJ CNJ OJ CM
§§§§|§^oc.
_—|i-COOCMt~-COCMOEglcOCMOJ-^COOJCOOBcSHcDr^oocooor^i^
en egco co T— co en r^ CM coq ^; •* ^t oq inco c\i in o CD in coen T— CD co -r— T— *f•G •* CD o en
UJ
inco^-ocn
r^t— incococnr^r^^'oogco^oinr^oococj)oocoi^cocMinmr^i^
en
I--;CO
coo"
co en m inS 5f P "
8in8 8
cocooCM"co
Si
z <
O COCO 'too co en T—en co oo mCM CM co t^o" " ~"
S 8
8
o oin oi- O
o oT "ico coen
in
5? 8 inin(O-. o i- en •*in o en co r^en o en en enCM" in T-~ T-" CM"
CDooco"
§o°.^t en co o co r^co en en o o oo•* CM_ co_ o_ CM_ •*_
8
S
T- r- in o oT-" in co" CM"
8o
5
3
I
88888888
uiOC D
8 8 en co o
Sco
coO5 00 O COt o en
ocnoooooooo
co" co" co" m" co" in CM" CM" co" co"
CMOCO
CO CD CO T- CO CO QCD co co ^t CM co enr^ i- r^ in o o oom co" CM inT— CO
S3aCM
O
NON-CALIr^
i
LLJ
s?in
r--:
LUo
a!ECURITY CAPITCO
O
i^
H
5% DUE 8en
CD
z
LL
LU
CO
0
E CAPITAL FRAIO NON-CALin
S
LU
Q
6?inCM
•*
^
I
'ORLD SAVINGS£•
_i
<O
0/09 NON^~5% DUE 9CM
W
lERRILL LYNCH -5
_i_j
1 NON-CAIw
DUE 7/29/15?S BANCORP 4.5iID
_,_i
O
UE 2/1 4/1-Q
S?ITIGROUP 5.1 25O
_l
NON-CALUE 2/1 4/1 'Q
S?ITIGROUP 5.1250
_i
NON-CALUE 2/1 4/1 'Q
3?ITIGROUP 5.1250
_i_i
0
DUE 3/1/1"5?o
OME DEPOT 5.2I
_!
9
oz
§§
LU
Q1in
O
DC
ENERAL ELECTICD
im
co
^3 FARGO11
LU
§/!ENT ACCOUNT^LUCD
z§
I
CO
o
LU
£o0-oroo
CO
^—Oz
ID
1-Occ
CO5
WATER 1LL
—
^_l CORPORATIONi-
LU
LUS
OCCLs
PUBLIC 1LL_
^_l RPO RATIONo0
CDZ
O
^z
II
PUBLIC 1LL
—
^_l
Q
!5
3DC
^O
CITY OFLL
—
^_l
Im
co
I
Q
OC
O
zzzzzzzzzzoooooooooo O O O O O O O
en o i- i- T- T- i-
EXHIBIT 7
CITY OF CARLSBAD
Fund Equity in Pooled Investments
AS OF NOVEMBER 30, 2006
Cash Balance by Fund:
General 41,772,309
Special Revenue 33,583,118
Debt Service 1,655,012
Capital Projects:
General Capital Construction 44,389,265
Traffic Impact Fees 11,619,410
Public Facilities Fees 48,097,990
Park Development 3,514,077
Transnet Taxes 5,342,401
Drainage Fees 10,552,167
Special Districts 82,293,134
Infrastructure Replacement 28,335,114
Other Capital Construction 2,307,592
Total 236,451,151
Enterprise:
Carlsbad Municipal Water District 64,599,091
Sewer Fund 63,000,234
Solid Waste 6,819,350
Storm Water 830,910
Golf Course 655,822
Total 135,905,407
Internal Service 22,123,529
Agency Funds 23,225,114
Redevelopment Funds (1) 0
Misc. Special Funds 0
Total General Ledger Balance ** 494,715,640
Reconciling Adjustments (2) 3,601,660
Total Treasurer's Investment Portfolio at Amortized Cost 498,317,300
(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 12/06/06
EXHIBIT 8
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF NOVEMBER 30, 2006
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
ALLSTATE FINANCIAL AA2 AA
CITIGROUP AA1 AA-
CREDIT SUISSE AA3 AA-
GENERAL ELECTRIC AAA AAA
HOME DEPOT AA3 AA
MERRILL LYNCH AA3 AA-
SECURITY CAPITAL - GE AAA AAA
US BANCORP AA2 AA-
WORLD SAVINGS BANK AA3 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 or S&P)
NONE
Investments with Subsequent Changes in Credit Rating *
Latest Carrying Market
Moodv's S&P Maturity Date Purchased Value Value
NONE
* 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.
13
EXHIBIT 9
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF NOVEMBER 30, 2006
WEIGHTINGS FOR CORPORATE AND FEDERAL AGENCY ISSUERS
PERCENTAGE WEIGHTINGS BY CORPORATE NOTE ISSUER
Investment Cost Percent of Portfolio*
ALLSTATE FINANCIAL
CITIGROUP
CREDIT SUISSE
GENERAL ELECTRIC CAP
SECURITY CAPITAL
HOME DEPOT
MERRILL LYNCH
US BANKCORP
WORLD SAVINGS BANK FSB
PERCENTAGE WEIGHTINGS BY FEDERAL AGENCY ISSUER
1,995,651.84
8,961 ,239.70
4,270,881.12
18,451,402.35
3,380,298.92
2,974,590.00
4,884,751.43
2,952,150.09
2,999,689.80
0.40%
1.80%
0.86%
4.38%
0.60%
0.98%
0.59%
0.60%
Investment Cost Percent of Portfolio*
FEDERAL FARM CREDIT BANK
FEDERAL HOME LOAN BANK
FEDERAL HOME LOAN MORTGAGE CORP
FEDERAL NATIONAL MORTGAGE ASSOC
Total Portfolio
5,990,313.30
168,736,471.81
150,270,886.48
92,202,773.95
1.20%
33.83%
30.13%
18.49%
$498,744,248.43
No more than 5% may be invested with a single corporate issuer.
*There are no percentage limits on federal agency issuers.