HomeMy WebLinkAbout2007-08-14; City Council; 19130; Report on City investments as of June 30, 20071
CITY OF CARLSBAD - AGENDA BILL
AB# 19,130
MTG. 8/14/07
DEPT. TRS
REPORT ON CITY INVESTMENTS
AS OF JUNE 30, 2007
DEPT. HEAD <[fWf
CITY ATTY. d&
CITY MGR. "l^P
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 June 30, 2007 is summarized below.
Pooled Investment Portfolio (Cash and Securities)
Par Value
Cost of Investments
Amortized Cost (1)
Market Value (2)
Current Month
557,470,022
556,524,708
557,099,175
553,618,075
Prior Month
560,344,312
559,891,781
559,947,406
556,493,330
(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 6/30/07.
FUND EQUITY IN POOLED INVESTMENTS
(Dollar Amounts in Millions)
General Special Revenue
37.9
other $1.7 ^Capital Projects
$ 246.7
Internal Service$
Agency $26.3
Enterprise
$146.2
Total Treasurer's Investment Portfolio at Amortized Cost
June 30,2007 $557.1 Million
FOR CITY CLERKS USE ONLY.
COUNCIL ACTION:APPROVED
DENIED
CONTINUED D
WITHDRAWN D
AMENDED D
CONTINUED TO DATE SPECIFIC D
CONTINUED TO DATE UNKNOWN D
RETURNED TO STAFF D
OTHER - SEE MINUTES D
DEPARTMENT CONTACT: Nancy Sullivan (760) 602-2473 nsull@ci.carlsbad.ca.us
PAGE 2 of AB REPORT ON CITY INVESTMENTS AS OF JUNE 30. 2007
Pooled Investment Interest Income
Cash Income Fiscal
Year-to-Date *
Current
Month FYTD
21,757,520
Prior
Month FYTD
20,555,194
Current Month
Income
1 ,202,326
The cash income received is adjusted for any accrued interest purchased.
Pooled Investment Performance/Measurement
April 2007
May 2007
June 2007
Average Life
(Years)
1.94
1.93
1.87
Average Yield
To Maturity
4.50%
4.44%
4.47%
Modified Duration
1.761
1.751
1.686
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.
In summary, the City's investments of bond proceeds held separately as of the quarter ended
June 2007 is as follows:
Investment Portfolio for Bond Proceeds
Par Value
Cost
Current Quarter
24,968,347
24,968,347
Prior Quarter
24,907,078
24,907,078
All investments of bond proceeds have been made in accordance with the City's Investment Policy
and the trust indenture for each issue.
02-
PAGE 3 of AB REPORT ON CITY INVESTMENTS AS OF JUNE 30. 2007
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. Fourth 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 FOR INVESTMENTS OF BOND PROCEEDS HELD SEPARATELY:
10. Detailed Investment Report - Quarterly Report
EXHIBIT FOR SUMMARY OF OUTSTANDING HOUSING LOANS:
11. Detail Of Outstanding Housing Loans - Quarterly Report
EXHIBIT 1
g
0u_
oc0
Q.
K- h-z ou °
I- o"
UJ uj> zZ D
2 0
OC
0u.o
1-
o
«00)
30
OQ
-J
UlS:
UJ
CD
^^
1
^
^^
IiS
ufs«j
S
cc
§
1o
3
P
OCo§
^OQ
>ioQ
*S
1o
a
UJ
Ul
OC
><
_o
ot
^ p p p co
O O O ^"
£
0s
•e
0)
3
U
S o o o in^ 0 0 0 CO"** o d o *f
0) o>
0 Q
2 0
« s6' 2
UJ
D
>
UJ
*OC<
^o
_o
a
m o o o •sf^r coi- co
CM" T-"CM COCD_
!^"
CM O O O ^"O) OO O
•*" m"0 0in i-
1o
E
0)k
O
1o
h- 0
0
Q
UJ
N
CCo
<
'za.
CM O O O OO) Oo in<sf CD"
O T-m CM•*"
CM O O O OCD CO
O_ T-_
O 00in o
o"s?
£
|
S
0)k
o
CM O O O i-
o r--•*" CD"O CMin i-
N."m
-*
(AW(C
O
Q 2 a. a: <
O LL O f- LL
CD00
"*
s
co
S
CM"
o
a>"8
8
COinmco"O)
m
SCD
8
t—
CD
0
so
in"
Zo
COCM
in
CM
in
1
CO
•^
inom_
CD"co
ooo
CM"00O)
m"CO
momr*-'
CD
CD
CO
8
SCD
8
LL
CD
"*
§
CMCOCD
CD"
o
o
i
USTODYO
0000
co
coCM
CMCD_
^1
CD
a
co
m"
S.
8
a
00
in"
K
CL
LU
LU
CO
00
00
CO
00CM
0
co
CM
CD"8
CO
oo
CD-3-
CD"8
CO
inco"
oo
1~
^
0CMm_
m
CM
COco
1
CD"min
m
0
oo"
CD
8
CD
a>"
mw
m
CD"CD0
Kmin
i 3
2 0
< l~CD
|
"S ^
D rt i
.111i .SP u
^ 'S § -^"§ <s ^
S cd ^j O
q^ ^** Q j_j
| 'S « pg
>> P Wj riO J3 (H <RS « t2 £
bJJ C3 r/i
"l a H ^
J ^ ' §
^ S S ^< S ^ aJ O oo cq
rl!| < |
^ § &
gSd
•^ 1o ^
!u.?.8«fig ° |
^ i I"
1 i i
U E U
EXHIBIT 2
(N OOO >—I vo'
3
I
^
I
3
•~j
3
Os"O
t-~
enof
i — i
vo"
ON(N
t--"
•^J-
vo"
§C^)
(NOO
ON
vo"en
00^H
Tf
vo"
^^VOKr-"
eni — i
"1en"t-~00
1
•^TCNin
vo"
v>
en00^
oo"
q
ci
Q fa^ 0
PQ 032«<&
U
faO
>HhHU
^oq
CO
1g
PH
^^k,O>
5
Si^ffi£
o
J
OOoCOOOO
OON
ON
(N
ONOO
en>o
~- o
° 0
s
t--"vo
BQ
<NON
Os
COONOr-"vo
VOenCN Ocs"OOON_10"en
IN10
VO10
0CN
"5
U
§
S
aOa
1 CY
EXHIBIT 3
i^ 10 CNJ p r^ LO cvi p N in c>i p i^ in csj p i^ in csj p r^ u>
<d <D to to 1010 in" in" ^ ^r ^r ^ co co co co csi oi CM" oi r^ T^ r^
oo
U
O
oo
S2CO
GO
EXHIBIT 4
r>
'S 8
U
CM O 00 (DCM CM r- i-CM O 00 (O CM O
O
<
0)
U)•o
3
CO
0)
OO
0)
I
|cic
OQ
Oo
co cq in
o in co coin TO co_ •<*_in" in" co oco co •* T-co i- CM CM
co" CM" T-" CM"
CM co r«. oco co T- m
CO CO O3 CO
oo co co inco o co coT- CO •* CM
CO i- CM CM
0s 0s V* W**S888o o o om m m m
oooo o o oq in qco ^3 r*** oo
co in co 55
00 CO CD CO•^ CO CO COO O) CO O)
00" T-" T-"
O '» Oin cq qin ^ in
cMinoocoooo^-cocMivmincoococoo
CMOOrvlvcOOOO'^J'OOincoooooi-incocMi-
O5O>COO)O)T— T— OO>
-§co
•r- in m CM
o i- co,- |v CO OCM oo rv coco" •* in" CM"
CM in oCM rv in coco o co o> coo co Tt o
S CO fv |v•>- oo inrv t- co o
co o co o ooCO CO O CM T-O OO O) |v O)
T- co in CM co m
8o>
m m in 3? .o o o ocMt'i-rvcMfvcooT-coooi-oom•t m
88oo den m*- 00
in in in m m m
o o o oo o o o CM ooo o
§^3 ^5 ^3 C*5 ^3tO C^ 00 ^3 ^3oo oo oo cvj co o
O 00 O h- 00 O 1^'O> CO CO 00 05 O> tOO> O) O O) O> O> OTT* 10 T-^ c\r ^-"
E5ST~. ^in T-"
•Sp Sp sfl sP NPo1^ 0s- 0s" o*1 0s"
CO 00 LO 00 ^3^" CO ^^ 00 ^3^- ^t 10 ^ in
o cpo>
Tt tO CO LO
EXHIBIT 5
CO O O COco o o co
co in o coco CM o mCO CO O CO
CM o o mco o m CMCM CO CO ^"co in m m
co q q CM
S in d c\iCM O |v
O_ T-_ O_ t_
co o> m in
T-"
CM rv O O
T T °. T^" CO ^" ^"
O O O CMq q q T-;
in o o ooCM_ in q co_o>~ •*" o" dO> O3 O |vO) O) O CM
CM -<t" in •*"
vP vP ^P vp0s* ff^ ^ 0s
o co o en
•* co •* m
88
in o
E58
m o00 CO
CM CM
88
rv' drv oco in
co" o"iv. co
O^ O^>
CO CO
cq q
•* •*
o oin qrv oCD O•* in
88O OJ
CM" T-"
gg
CO •*
O CO |vo co coo co T-
Cn CO |v
CM CD CO
CO CO CO
OO CO CO
88£
d oo CM'o •* o>iv_ co in
CO O |vCM 00 Oco in co
sP sp xQ
0s* 0s* 0s*
III
CO ^ ^"
O CO CMO O 0)
§iri od00 CDO •* CM
8 Si 8O T— CO
CO CO CO
o? 5? 5?•<* o m
co in h-
COCD
T—1—
$IV$
§
CDCDCO%O)
co"
>93s-s00
CO
rvin
CM
5
18rv
dCO
- §n .=a «
8
8o
8o
CO
8
8o
8o
CM
OO
8o
8o
1—
8
8o
8o
CM
8
8o
I
T-
ooo8
§
m
ooo8
oooin
ooo8
ooo
CM
Oo
8
ooo
1—
oo
o8
ooo
CO
oo
o8
ooo•*
o oo o
0 0
o oo inO 00m •>-
cz z <y z
CO
8
o o o oo o o o
§000
888o o o o8888oo in m ••*
m m coo o om o iv 5
5 Si Si z
i- O O
o oo oo o
88
o o58
CM CM
08/17/0505/23/06o o oo o oo o o
888o o o888
CO CO CO
|n
ooo
8
0
o
oCO
oa:iLU
2LU
LU
O ERICALL
00°
ilzT. X.LL m
2 CQ CQ m S-j -i O -i ZzX T. LL T. ZLL LL LL LL LL
0
O
DC
OLU
LU
<CCLU
LUCO
coco
COt
3 3 3 8
LL LL LL O
o ,
Lt <
LU O
^
m < m u g
T. Z T. LU LULL LL LL CO CO
Z < < ZO LL LL O
i- 00 CM C3)
O O 5 O
CM T- CM CD
^" O) CO COo o o o
§000o o o
CM CM CM CM
CO O O •*j;- CM CM CM
O O O O
8888
ssl^g^Sj^Sj
30.^^^^:01 < o o o o
0)
E ffl
^ ^ ^ ^ ^ ^ Z Z Z
LLLLLLLLLLLLOOO
§§
CM
C\I
CM CO 00 T— CD T—Y— O O T- O T—O O O O O O
S3 3>o o
^^o oo o
rv iv rv rv rvo o o o oo o o o oJM CM CM CM~ cnCM CM CM CM CM
in T- T- T- T-^v;i;SiSiSiSiSiSiininininininminm
88Si Si
o o o o o o
h*- fV- |V r** |V |V |Vo o o o o o oo o o o o o o
CM CM CM CM CM CM CM
^if CO CO CO 00 CO CO UJ
55o 55O O O O O O -3
£%
CM
DCLLI
CC
<
O
CC
£
tfl
LU
< < < Z
LL LL LL O
iv iv iv iv
8888
nil
=< a.S <
LL LL
< Z ZLU O O
o o o
CM CM CMm in in
CM CM
LU
D
ou.
I
City of Carlsbadc
E |
S|
-
w
^3*=
£ o>2 <ofl> «•cc
fa
0 0jd
i3ou
°" >
0 §
•^§
i
CM £
CC '=
uf u
5 «
3
0
£
P
Q r-
O | >
DC £2 '= SQJ co = re
Q. ° » °
CC
TRANSACTIONS FO04/01/07 TOTrans InvestmentDate Date8d
%
CO
00co"
oo
d
LOCM_
i
3?
LO
00
IO
8
do0
0
8
co"
S?OP
LO
oqd0oo"oo
co"
o
LO
§o
CD— I
U.
^u_
o
T —o
io
CALLS and /or SALESAPRIL NoneMAY05/05/20050
d8
to"o
co"
oo
d
CM.,_"
0000
8
^in
8
d8o"8co"
8dIOCMco"00CMr--"
8
8
LOCM"
^
1CO
IO
8
8o
8o
<£>"
0)3
£
$•£CO
o
LO
ood8
8
co"6,000,000.00Par Value isoSo
1
00
u.
,.£
LL
^
00 O8 «?CM <0
1 8
*~ UJ
05/18/2006JUNE NoneTOTAL FOURTH QUARTSTOCKSIOCM
6 CO
c5 •*
§v<
«oU
2 -<B T
£ OW
i
od«»
COCD
CO
CO
oq
^_
8
0 CO
•Q cto oO p
5 Ec o50
§ ^
<B COE co
P 0
tz>OLU
APRIL 04/01/2007c.o
i2g.
5
COc.0
'c
i
Q
CO!cCL
CD
^O
<5"i with the bankrup't5CDc
I
c£O
CD
1.•9
«
^CD
CD
5
0
t
JJ
'co
^^CDC
CO
of Time WEleven shares!2
2S
QLJ
i
^c
CDO
TTC(1
C.0
'cfl1oO
CO
nication3EE8
against Adelphia <CO
._COu
allowed*Jr
!2CDT3
i
^53cQa
w
CD
1
CD
—
5f—
B
istributionAn additional db
CD
£
'E
1
CD
TJCCO
COqj
1
§
b
0)g
1
cu"o>
C/)
c
First Ten_
S2
^|
'cCD
E
1>_c
_co
.•£"O
CD
^CD
SU
"8
1
urer has dThe City Treas
EXHIBIT 6
cn r-. T- T- i-.o r*- T- i- Is-CM CM cn cn CM
r~ CM i- CDCM r^ i^- cnoo en en ~_.OOOOOGOCDOO
fc
S88888^S88888§8S888888cq888888^S888888S8§??
v™ O O O O O O 00 O O CO O O 00 O IO O O CO O O O CD O O O 00 O O Is* CO O O O O O O CO IO ^" COO O O U") O O CM O O O CO IO lO 00 O !•" IO O ^" O O O CO O IO O O) O O O) CO O O tO O O O CO r*» IO CO
(DcDi^-ioi^-cocDcocMi-i--cnininoincooocooocococMincnoi>-coof-i*-ocMcocomr-^cocococnoi^-cOi-cOi-cor^-Of^-Nootot^-cocnY-T— cnooo^-cooocoocMCMco10 ^ co ^ co i- in in CM in co co ^ co r^ co co_ co co_ co_ OT_ co_ oo_ o>_ co_ !•*_ ^_ oo_ ^_ ^_ oo_ co_ CM_ m co_
" ~ " " " " " " " " " " " " " " " " " " " " "co~ irT co" co co" CD" in co
_ _ _ _ _ _ _co co in in co" in co" co in in" c\T m" co" co" in co" co" co" in" -M-"_ _ _ _ _ _ _ _ _in" co" in" co" co" m" m" co" in oo"
8 <M.
co in o CD oco ^ in Is- ooo co CM cn Is-
r--en o o in o o co mCDo^
1- CO O 00 CD t CD o cn r^ oo CM in in r^- T—
in CM in co co
Om^COOOCMCMCOCM
COCDCOCOCOCOCMCOOO
=
tcc
-S
^PvOv^sPvPsPvPvP^Ptf^O^tf^O^O^O^O^O^O^
ooooooooooocoomomoooooooooooooooooooooooooooino-toi^ooooooinmooooooooooooooocnoppppcpif5inpp
o o o o oo co coO O O O 00 •« Is-
IO OCM in CM CM
O CO §inCM
cor^or^cpocooocooinocnoioi-ocor^o o>o o>co" CM"
oo o o o
en o •* o
o cn co o o oo CD r^ o o oo oo oo o o o
CD CM OC~ CM Ocn o> o
§0000000000000000000000000000000000000000pppppppppppppppppppppppppppppppppppppppp
CM" co" in" co" co" co" CD" in" co" T" co" co" in" in" co" 10" co" co" m" in" oj" in" co" co" m" co" co" co" in" in" •»" in" co" in" co" co" in" m" co" in" oo"
3I Z I X I X
La-Ll.LLIJ-LLU.LLLL
§§00000 ° ^
_ _ CO - _
T-T-CMOT-T^<NOininincococ^cDr^
X X
_ .. Si c9 F: f^ 55
-_ ^ c\I Si c\l Si ?5 _i-OOOOOOi-
CM O O •— CM CMa^fli^iir^T^S^o o o o o o o sss
^
i- CO t~- CM T-T- co co in ooin •«!• co <o T-
T— CM o T— i~ r^* o r*1- T— oi r** o CM CD CD 10 oo CD CD CD co co CD CD CD T~~ o^ t~COCOCON-COCMCOCMT-OOJ^-OCM OOCnCMCMCMCMCMCMCMCMCMlOi-CM 00 i- T-
5 8 $ $
o>cor--oocoommococoomin
O>Oh*'»~OO)O1i~COlOOCOOO^"
0 ° § § §moo§ § Q
co Is- i-co oo i-co co t ff
^^^^^^ _ _ _ _ _ _ _cj in" co" in" i-~ co" •* T-" co" T-" T-" CD" CD" co" CD" CM" m" m" co" co" CM" m" in" <N" m~ co" CD" co" CD" CM" in" •*" co" i-" in" c\f co" m" T-" CD" c\T
S3
01
i^O)inoocooinoocor^oc\iioocoooooooooooocnO'-T-^T-ppcpptNjppoqcqpO5inpcO'*pppppppppcNini-;oc\icMoor^oc\ioo
00 CO O CJ) COco i-CO T-en" o" co" m" CM" Is-" CD" o" o" •*" Is-" W Is-" m" Is-"r^ooincocooocooOTcOco o> ^ T- co
§o o o o h— ^ ^ m ^ m ^ CD
in m_ o_ o_ oo_ co_ o_ oo_ !•-_ co_ co_ inm" CM" CM" m" o" CM" rr" *-" m" r-" co" co" in" mi^T-mh-mi-i-coooor^co"'oooooocMinmc- — --
O> O CD •>— C7) CDco co m CD ro coi- CO CM -t i-oooo f-COCDCM
_ _ _
h-" CM" oo"OCOCMCMP^'
gg
tgDC
t-i
Eft O> 5z <
S ooooooooomooooo^ooocMooooooooooooooominoooooopppppppppr^ppinppcppppppppppppppcoppppoqmppoqppo o o o o o o o o'o'co'irio'p-o'o'o'o'o'o'in'in'o'o'o'o'o'o'o'o'cjJoooco'in'co'o'o'T— ools-incOOCOinCMOmOi-CMOCOOOCOOOIs-COCMOOOOOOOOOOOOCJ)i-'<l-CMOCMOOm_ oo_ co_ co_ •*_ o_ co_ o_ oo_ o_ CM_ co_ o_ o>_ T-_ o_ ^-_ in o_ CM_ co_ co_ o_ p_ o_ o_ o_ in o_ o_ oo_ o_ •*_ in i-_ r-_ CD_ oo_ o_ o_ o_ o_
o)Cj)O)O)coT— cjJOcnocM^oooo^o^cjjocncncnooooo^ooooo^^o^oooocj)
i-" •*" CM" t" T-" CM" •*" co" T-" T-" m" m" CM" m" CM" •*" in" CM" CM" T-" in" m" CM" m" m" •*" in" in" CM" m" co" CM" m" *-" co" m" W m" i-~
§00000000000000000000000000000000000000000ppppppppppppppppppppppppppppppppppppppppp
§OOOOPPOOO'O'OO'O'O'O'OOO'OO'O'O'OOOOOOOooooooooooooooooooooooooooooo§000000o o o o o oo o o o o o o o o o o o o
§0co 0m 0o_ CM_ in
CO" T-" T-"m" CM" co" in" T-"cMincom i-coti-incocoincMinincococMinincMioinininmcMintcoT-
§
< < < <
O en en m o,o o
oooooooooooooooooo-. -. -. -. -. -. -. -.
m in Is- in r>- •*
Si ^
S m in ^ in ^ ^ ^ ^ ^ ^ ^oooooooooooooooooooooo ~
i- CM CM CM CMin c\l c\i N r~-O i- i- O O in" co" in" .ooooo ?5 55 - - - -
1- O O 1- 1- T- 1-
II
_ _ _CMCO1*tT-COT-CMOOCOCOCDCOCOCOCOCOCOC01'*T-COCOCM., ,, CMCMCNI^CMI^COCOCOCOf-CMT-CMCMinCMCMCncOin^CMI^CMi-oococooooocoooini<tis-^'fs-oooocococois-cocois-ls-is-is-is-inooco
COCOCOCOCOCMCMoo
ocncninincoini^i^cMi--tCOCDOCnoOCMCMOcocococoNf-Noocooo
S^Ntbi-oococdcooocoNinT-oinencocoooco'
o^ocd inirir^^
T-cooooooinc\icMCMi-^-ocoi^co'<J'OM-cMinis-oOT-<Mis-T-cocoincDa}t-CMcocMcois-oocoocDOOCMcoois-cois-coCTitocninincoinis-rs-coincoi*cooocO'*cocO'-ininis-cocoincooint
> DEI co" co" co" CD" co" CM" co" co" co" co" co" co" co" co" co" CD" CD" co" CD" •*" co" co" co" co" co" co" co" co" co" CD" CM" CM" co" CM" co" co" co" co" CM" CM" co" T-"
g in ooocooT-incooocMOOcoco-i-ooini^-i^ooppincoini^cDooppT^ppt^cOT^ppr^T^cpcDCj
oocbocdoodoin^ococDOiriT~ o co o co *^ o co o m T™''ioom m o o o m oc\ir^ooO'~o^'r^i-~ co" o" o" co" in" o" of en"
rs-coc\icbcbco oo m ^ ooT— co^'inis-
" " " " "
inois-cOT^cdcdcocricoooO)^ o o? ^ *~ ^ ^ o ^ co o o ^coooir-cj>T-^'^iininoocj)" " " " " " " " " " " " "m" en" co" Is-" Is-" in T-" co" m" co" co" CM" o" Is-" CM" co" co" o" o" co"i'i'
oinis-ooo)CDCocnocj>ococoooinocococoi^poin»-cDis-coi-cDincooocoinoois-
oooo888coSoooo888ooooooocMooo8oooooooooomoooin
u
E
o o Is- en o oin o co en in oIs- o •* CD CM ot g o" CD" CM" sf
§000ooT-oooooocom O OO O CM Is- O Is-T" o 10 r^* O) oooo oj co r- co i-
oooocncnococncnocooh^oooocncoocncnooocnocn
co" m" in" in" CM" T-" m" CM" CM" CM" co" CM" in" t"
enen
i-coi^inococooooT-oocMoocncMcooocnis-incoT~ois-c7)OOOT~T~cOT— ocoopocncncncnoocncooocnfOooocnooocnCM" CM" CM" in" co" CM" CM" m" CM" *-" co" CM" co" co" co" CM" CM" CM" co"in in CM in co CM
ooooggggoooogooogoooogoooooooooooooooooooo
LU
"" " " " " " " " " " " " " ~co" m" m" in" co" *-" m" co" co" co" co" co" in" m" in" in" in" co" m" co" co" in" co" co" co" m" co" co" CM" in" CM" CM" co" CM" co" co" co" co" CM" CM" co" T-~
UJIQ-l LLLLLLLLLLLLLLLLLLLLLLLLLLLLLL LL LL LL LL LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL
CM CM CM CM
-a-ininininininincoincDinooooooooooooooooooooooooUJ i^ s<i 1^ yi s<;!S uj oo CM Is- r-- r^S £ £M - CM JM £M
tn < ™ ^ ^. T= ^UJ Q
>
T- O O O O
co coCO COo o
CO^-i— CO OO T— CO T-
8 fcto
3in
S
CM
in
3 S
O T-~
O^•
lOCM COOOlO00 T— IOi'—OJin
co ?rin T^
E co
in h^ o ^ ^t"co T- ^ ^ inCM en oo CM t-
cDinor-cocDcocncncocn^'inocOT—
CMCOCMr^inCO^CM^^NCOCOOOCOCOm" co" CM" in in co" co" co" CM" CM" co" co" co" •*" CM" r-~"
co
E3 Cn O £ CM O^ CO N ^ ^co" CD" in in •*"ins
S
CO
in in
co £
o>sCMO
CD CD coinocncni-i-cocooocncMcococn coi^cnm^cncnoincD^ocncDcooo co.O Oin inoo coen en COCO
CD coCM r-CM in
8enco"coo
co i^ r-; p p E •*
in h* o ^ coCO T- Tj- TJ- CMCM_ en CO CM_ CM_T-" CM" CD"
CM coO 00•>- 00
T-
od
coooCM
8
co
3oCM"in
sP vP5^ 0s"in ooco CMCM p
^ O
co co
co co
co co
inco en enco CD
or^ooooomooooooooOCMOCOOQCMCMCMOOinint^OI^cMi-oooenr^i-cMin^-^-ooincn fe
sSsSsSsSsSsSsSssloiooooooh*-h-h-o^^^^mCM CM 00 CM CM CM CM O
^•^"frinininm'io
O O00 00
8 8
O O CM CO O)
O> 00 CO T- O§1- o in mO) CO h* T~§
Oinoo S enco
lOOOO)(DO) O O O5 O)ci co" to" r-" T-~s
o o o o o>O O O O CD
$2 £ 888in •* o o o
Is*." oo" CD in m" •<*"
8 8o
1•t"inTJ-
8 8o o
§00 oooooooooooooooo o ocn oooocn0000 OOOOOOOOOOOOOOOO O OCD O O O O CD
CD
O 888 888o o o
o o o o o*- *- O O O O COin •* o o o o -
cococMinincocoincMCMcococOTfi-in
co in
oo in
en
oo" co" m~ in" ^t"
CMCMo
o"
G5~in
LLJ
Q
mo
ICO
m
CO
8
(A
FederalO
m
co
37ELLS FARGO BANK 92189O
1
LU
D
s?inen
CD
Z
LL
LU
COIo
nr
GE CAPITAL FlOz
in
S
LU
Q
1
•*
*
CO
CD
WORLD SAVINd
O
Zo
en
LU
Q
S?
%CO
•*
<Ooc
BANK OF AMEIcl
0
JE 8/1 0/091Q
S?15
WAL-MART 6.8|
O
O
en
5% DUE 9/1CM
Tf
MERRILL LYNC_i
<O
O
3UE 7/29/1 CS?
S
Tt
US BANCORP_i
cl
zo
E 8/1 5/1 ONDQ
5?in
WAL-MART 4.7_i
NON-CALUE 2/1 4/11Q
5?mCM
CITIGROUP 5.1_i
NON-CALUE 2/1 4/11Q
5?inCM
CITIGROUP 5.1NON-CALUE 2/1 4/11Q
S?inCM
CITIGROUP 5.1_,
$
0
DUE 3/1/11gCMin
HOME DEPOT1
OZ
T—i
5!
LU
Q
ginin
O
OC&GENERAL ELEO
OZ
I51
LU
Q
ginin
O
CL
c3
GENERAL ELE^
O
ZO
§
S
LU
Q
S?TOYOTA 5.450i_i
11
11/15/11 <LU
Q
inin
O
OC
S3
GENERAL ELE— 1
O
O
E 2/1 5/1215.875% DUIO
OC
O
GENERAL ELEzzzzzzzzzzzzzzzzoooooooooooooooo
N.COO5O5CJ>OOi~i~i~T-i— T— i— i— CM
m
co
¥
"Z.
m
LLS FARGOLU
§ENT ACCOUNTIII
MANAGIXg
RPORATE COO
%tr
oz13
cl
DCI—
CO
Q
1 F WATER 1<_i CORPORATION1-
LU
OOCQ.1 F PUBLIC 1<_i 1PORATIONU_
Ooo
o
^z
1 1
1 F PUBLIC 1<_i
1CO_iOC<o
1 F CITY OF<_i
QQ
CO
o o o o o o o
i
Q
cc
CD
EXHIBIT 7
CITY OF CARLSBAD
Fund Equity in Pooled Investments
AS OF JUNE 30, 2007
Cash Balance by Fund:
General 75,867,066
Special Revenue 37,944,378
Debt Service 2,381,749
Capital Projects:
General Capital Construction 46,106,693
Traffic Impact Fees 11,638,699
Public Facilities Fees 50,897,337
Park Development 3,180,506
Transnet Taxes 7,848,409
Drainage Fees 10,337,227
Special Districts 84,652,911
Infrastructure Replacement 28,667,735
Other Capital Construction 3,326,180
Total 246,655,698
Enterprise:
Carlsbad Municipal Water District 71,321,124
Sewer Fund 61,209,010
Solid Waste 6,640,807
Storm Water 960,635
Golf Course 6,047,938
Total 146,179,515
Internal Service 22,441,194
Agency Funds 26,300,748
Redevelopment Funds (1) 0
Misc. Special Funds 0
Total General Ledger Balance ** 557,770,348
Reconciling Adjustments (2) (671,173)
Total Treasurer's Investment Portfolio at Amortized Cost 557,099,175
(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 7/9/07
EXHIBIT 8
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF JUNE 30, 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,980,855 2,948,580
* 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 JUNE 30, 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
PERCENTAGE WEIGHTINGS BY FEDERAL
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
AGENCY ISSUER
0.36%
1.61%
3.32%
0.53%
0.88%
0.73%
0.53%
1.47%
0.54%
Investment Cost Percent of Portfolio*4
FEDERAL FARM CREDIT BANK
FEDERAL HOME LOAN BANK
FEDERAL HOME LOAN MORTGAGE CORP
FEDERAL NATIONAL MORTGAGE ASSOC
HOUSING URBAN DEVELOPMENT (HUD)
10,960,380.80
179,005,681.24
157,390,211.65
107,795,884.89
990,198.00
1 .97%
32.16%
28.28%
19.37%
0.18%
Total Portfolio
No more than 5% may be invested with a single corporate issuer.
There are no percentage limits on federal agency issuers.
$556,524,707.63
EXHIBIT 10
+*
^Oa0)DC
4-1c•o a>(o c r^.
•9 ~ S(/)(/) O•C 0) Csl
(0 > _ro =8
>1 8
** o "^aO o ^O
a!
VBO
O
OQ Source„
oo
0)
15>
(0a.
^« C])is
.
c
~~ fl)•D «2g) (u
CO
w
InvestmenFund Typew
i—BNY Western '^0)O)<
8<A
E
enen
O)
15
c
QC
O
aaM0i
0
0
o
mos"mCO
»
8in
03"mCO
w
00CO
1o
S?
CDin
cCUECUCD
0)
OQ.
CUDC
c 'COCD
03
Q.CUDC
^-c.3O
Reserve AceM3
1—BNY Western 'LAIFc ^J1
O) as"< 00_ 00
(0u10
E
«
CM
^-03"
00
00
</^
z
s?COCMin
^f*^
o
Ilege/CannLAIFoo.
9
8
^A
sessment Di:Projecl Fund(A
LL
in00
in0CM
V)
m00
in"oCM
CV3-
*
s?
CM
LO
LL
T3
LL
RedemplionCO
8 £•> co
CO ™
(rt
US BankAIM Instil. FundJP Morgan/Chai-• ; f1^ oC CO OS CD_ ing» co" CM"< CO CO_ CM CM
8 -(AE
»»
fs» ^D
CO Oco m
co" CM"CO COCM CM
i-
<& <&
,_
T—
O
JO
Z ^CO
•^CD
ECDS1 2^ O)
"" •-St %D) CD
» >, E— L. -4^o ^ w
o co $^* CO >
«a 2> —•0 1- cq
(0 |— — '
<, < H
5
en
" §3
"5 <
5 -o„ C T3
-AssessmentImprvmnl FuiReserve FuncuQC
*-
E
BNY Westerni;
0)
^8(0
E
^^.^
ucCOQC
•o
JA
(0O,
o
inen
jo™%sessment Di:(A
\s
O
>"
CU
•s
cCOm
0m
CD
0CD05
«*
•tCO
o"COO5
<V>
1
JO
CO00
in
0COCO
^^
cCD
ECDCD
O)
^f
OQ.CD
DC
c(0CD
03
DQ.CDDC
"O
Reserve Funlo3k.1—BNY Western£0)o>
"*8w
11
«^**
5
mcho Carri%u
en
£sessment Di!(A
y
6>"
1
"o
COCD
0CDCO
O
r^
Js^~mCO
T-"
^
O
^
m
•r-
<f*
00CM
CMO
03O
5?s
CO
0CDCO
• — •
cQ
ECUCO
O)
^foQ.CU
DC
cCOCD
Z
Q.CUDC
T3
Reserve Funt5
3
t
BNY Western^cu
O)
5m
(A
E
"c?insettia Laio
Io
jG
S
sessment Di!(A
coCDCJ
'^CU
CO
•oc
LL
to_c
00O)O)
o"COCO
oo"
w
0005O3
o"COCO
co"
<-/>
1
z
1
T3C
LL
Improvementt»3
1—BNY Western£
0)
^8(A
E
Q.
iZLU
0o
CD0h-
co"m03
»
COo
co"inO)
ifi
^.
1 —
1O
S?COCOin
cCUEcucu
D3
i -
Ccu
05
C
O
T3
Reserve FuncoCDO
7S E3 CD
IIin .0) ±±
flM
il COc ^fai oo
01 Tf< o_ CM
8 ^(A
E
»
CO•<tOOsCM_
^
C/>
I
I
£5
CO
CO
H' ^
H;
CO
* <ts
w
0
(00)it:
'o
CB
mmunities F;Project Fundo0
1
BNY Western TCM00
o"CM00
<»
CMCO_
o"CM00
cy>
,_
CM
C3
O3O
S?U5
t .
CD-J£
CO
^CU
o
^^
o•t-*
(0I>
CD
Reserve FunM3
t
BNY Western^0)D)
"*8U)E
10T3
Q
03
0)M
FA Golf CouiQ.0
t3 1/5E S
BNY Western TBNY Weslern T00 O3CO Or**" r*"
CD" CM"
00 CM_
T—
»«*
00 03CO O
co" CM"
00 CM
••-
ifi ffi
II
-^ -^5
&5 ?n
O3 O3
t . l .
CD CD
~w "wCO CO
>•* >^CU CDc co o
^^ ^^
o o
I 1CO COI I
z zm co
T3c
LL
1oCD
0)Capitalized IrReserve Funeo(OO>
f-TfCO
8O)
/7
EXHIBIT 11
3 € %.» » .»
o nj co re a).IS. .IS, S
£jg
e
t> e s c
I I I I
co m m in
8 o o S
III!
jfl o 52 o (2
jS o J5 o 53S^'q Si's S.'
S -5 o -° o •T3 CO "O CO '
« S2 s
S3 ss
„ c= c= £2 c. 2.42 flJQ. COQ. top. top.
t "to= "(0= "ro^ 76 pQ.W Q.W Q.W O.W
it CO O? =(0 g-
•1 II II II 1 I 1 II II 11 1.3 Q-= 0.3 0.30. O.O.a.SQ.SQ-SQ-
s"
55" a"
S S"
in ,_ ^
8 Si
3 « «l
CM *-
"EraO
Xmo
8" 8
55
.5
CM i-
cotL
0 tfl-.*
'u cInD. S
Soo
.1 S,i.~COJfl p
CO oQ) >£
^8 TJ
(0 "£Q. §
< «•(0 ^ ,w c11I r
i;<2?
=>
1°(0S.
'Si
%
(J
co re co reIS, IS,i§ is
fe g. «
I
I
;?§?!
! rt rt OT i