HomeMy WebLinkAbout2010-06-29; City Council; 20292; REPORT ON CITY INVESTEMENTS AS OF MAY 31, 2010CITY OF CARLSBAD - AGENDA BILL
8
AB#
MTG.
DEPT.
20,292
6/29/10
TRS
REPORT ON CITY INVESTMENTS
AS OF MAY 31, 2010
DEPT. HEAD tffflW
CITYATTY. " <£&*
CITY MGR. (fr-~
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 May 31, 2010 is summarized below.
Pooled Investment Portfolio (Cash and Securities)
Par Value
Cost of Investments
Amortized Cost (1)
Market Value (2)
Current Month
569,860,753
578,123,043
574,856,279
583,139,405
Prior Month
558,154,804
566,797,009
563,316,215
571,452,984
(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 5/31/10.
The equity portion of the various funds in the total portfolio is summarized in the graph on the next
page. Fund balances are restricted for various purposes. See Exhibit 8 for a more detailed
breakdown.
The portfolio increase of $12 million from April to May is due to the receipt of motor vehicle and
sales tax in lieu payments as well as property taxes during the month.
FOR CITY CLERKS USE ONLY.
COUNCIL ACTION: APPROVED )&
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 Nancv.Sullivan@carlsbadca.gov
PAGE 2 OF AB REPORT ON CITY INVESTMENTS AS OF MAY 31. 2010
FUND EQUITY IN POOLED INVESTMENTS
(Dollar Amounts in Millions)
General Special Revenue
$77 „, $49
Internal Service Capital Projects
$280
Total Treasurer's Investment Portfolio at Amortized Cost
May 31,2010 $574.9 million
Pooled Investment Interest Income
Cash Income Fiscal
Year-to-Date *
Current
Month FYTD
16,907,078
Prior
Month FYTD
15,671,694
Current Month
Income
1,235,384
*The cash income received is adjusted for any accrued interest purchased.
Pooled Investment Performance/Measurement
March 20 10
April 2010
May 2010
Average Life
(Years)
1.64
1.53
1.46
Average Yield
To Maturity
2.42%
2.35%
2.26%
Modified Duration
1.557
1.460
1.397
All pooled investments have been made in accordance with the City's Investment Policy adopted
January 2, 1985 and last revised March 23, 2010. 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 9 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. Market Yield Curve
5. Cumulative Cash Income Graph
6. Fourth Quarter Transactions
7. Detailed Investment Report
8. Fund Equity in Pooled Investments
9. Corporate Note and Commercial Paper Ratings
10. Percentage Weightings By Corporate Note Issuer
EXHIBIT 1
g
^ioLJ_|—
Eo0.
&|
^^ vN
1- T-"CO co
> £
1 S
Q u_:ARLSBAAS 01^^
u_O
£
o
COCO
3o
^MCQ
Q
^^^UJ
CD
1i^uj*1
oyj^
^CO^ro
n
:*}^•^
§MARKET• *K
COOO
Q
^U•vi^2i—o:o
^f^>>.
CQ
2:
^o
H
£ m co"£ o in
O CD CM
S
Q o
UJ £
UJO .e o oo^£ ** o in2 % ° ™m 5
1IM3O
8i a °8 oy •"•
= 0
v> "
o>-
0 0
_ O CD£ o co
C CO" TJ-"O CO CD5 in
UJ •_ ^f
^3 .2
*f Q-5
UJ
1 £ ° °< ^ 'tSo r--
S CO« <D_
I "
O
^ o r-*j O CMc o co0 co" ^r"
S CO C7>
^ CO
w .2 T~
O CL *~0
Q
LUN 0 COp! .E CO1- £ Tf
tt 0 0>"
s S 5
* 1 "t
o
o0
o
o0o
0
0
o
0
o
T-T-T-coinoo c^
O CN ^4* O O O O ^CM
•£
Oo
si o r\ Ccocot^comoo 5* s S
CM B /^ rt
S 0 "WJ ^5 o -~ ^
S rt C T36 * u cM r; > 3Si 1 o ££ U -g 13c >-
(J CM r r*f^ ^^ ^, ^^ ^» fQ i~i CO r*j U ^^ D
CMO^COOCO h- ^SlSOoocoooini-r^. o ep ^ c ,
P^. CD CD O5 T~ h^- D fj -4-1
O5[~~O)CO O "Ta^^SOTT-OCO en S£O5o" in" CD" 9 ' ' H^~ ^ , •& °- <
fc 2 u ^
< 3 ^ §J U c^ DQ
oco^rcMOcoo) ^10 ^~ co oo C3 co r*""* ooO5 UO O5 ^J" ^^" 00 O5 O5
CD" CM" o>" m" CD" CM" CM"r- T- CM CM r»- co inTJ CD co CD CM m 'S-
CD" T-" CD" CM" CM" v-~o o> o in r>-T- CM T- m(ft
wi
OCOOOOCOOCD in "oocof--cor^ooo o ?-.Szc*) <^ f^ OQ OQ T~ OO ^f ^ Sn ^~"
N- CD O5 ^"" T— ^-" co" O) Jg <J -H
Is-" CD" r~~" CM" m" CM" co" *~ ^ Q-s s g s^a
oi <f ZH U, U
OCOCMOOOCOI^- T-CN O> O ^ ^ CO O> CMCD" CD" o" m" co" CM" CD"•^j- o> T- CM r~- co T-co T- o) co CM m co
CD" Is-" CM" CM" CM" co"o oo o m CD m
</> 'OT O0 Zg. „
oocoooooooco o> oSfeojooocoi^ooo Is- (So,^ — T — Is- CO CO T~ 00 CM ^? § &
o" m" co" ^r" v-~ ^ co" CD" D .22 0-
O^CMCM i^-mcM m -aQ"CMOCDCMOT-IV. co S—S
Is-" CM" co" CM" m" c\f ^ egoOOOON- Is- '-^ 4> Q,CM T- in h T3 fe^rn J*s 0} O
Q Z cuu u, u
OQ (0(0JSO
QO Q.O § 3
QO
w
=3O
Q_
LU
LU
O
00
J
H0H
^
1
0 < — lO^OCNOOCNOOO
~* ^ "" ' "~*
0^O
Oo
EXHIBIT 2
0
Jo&-HOSO
CM
ESTMENT¥31,2010> <fc 5MM *
Q fe3 oCO c/>
j ^K<5u
fcO
>HM
U
&
g
^[^
^^^"i5
§3
Q
^i
SSIFICATI^Q
Kj^
S
[^{5
5
^3
^S
^fe
>
u<H
0H
t»ai<a>•
V)&
^H
ai
^a>
o
H(ft
X
zo
(^
CN
O O
00
0000oo
CNCN
CN"f-
oor--oo
oo
Tf
CN"
S
oor~-
o?O
OO
SOCN
OO —ON CNON —•
ooCNCN
SOrt-£ON
Of-
SO
ON
CNv~iON
r-"
ON —O OSO ON g
oo
SOCN
s;2
^ CNO -*t
CN
CN
O
m
CN"CN
ON"
OOCN
•*"
CN
oo"
CN OOo ooso^ oo^
P-" •^r~- CNO CN
>/">" CN
oo o sor- o oo
r-4 ^jf f^t^ >/S CN
O — f->n" CN"
m
00
oo"
ONCN"ON
oO
ooo
oON
SO•§
-O
60
|l
% Co '—<t-i "Oo g
>C
t! O
S o
S •£
o u
o oo E
ON O« 5
o o
wd QU U oi U
CUSTODYEPACCTBATOTALS% TOTALSSo
o POLICY
EXHIBIT 3
inoiAou>oinoinoinou>oinoiooinoioomoinoi^ iq cvi o i^ in c>i p t^ iq N o i^ in CNI p t^ 10 CNJ o r>; IA c>j p K. in
<d <o <d cd 10 id 10 id ^t Tf ^t ^t co co co PO csi csi c4 oi ^ ^ ^ r^ o o
EXHIBIT 4
wg!Du
O
CO
O
O>
H oo
W §
0)
ta
I
10
CM
CO
co 01
CN
m
en in o
rn <N <N
(N
^sO
•
(N
ex)
00 O) O
O O T-
O O O
CO CO CO
CD (B i?5
EXHIBIT 5
C
3
a<
L.as
a>
LJL
O
O
O
O
Q.
0)
O)
CM
^^
3
CD
O
Eooc
£
+BJ:
D
7
EXHIBIT 6
fl) C
> °£c
8
1
E «,3 *;*J Wfl> iy
tt
3 lift
OQ
o
0
fe §
>
? =%S <33
4TH QUARTER 2009-fype SecurityCM O |v- OOOOOOfv.^ o CD o iv« fv. m CD
T- O CO O CM CM Iv. T-§O CD O O O CO COo CD ^r co co CD iv.
coom co iv- iv. o •*co^oo CD co co ^ coT- CM O CM CM T- O
CM CM CO CM CM ID CM
CM O ^ o CO 00 O |v-^r o CD OIV-IV-CMCO
T- d CD d CM CM in T-§CM O CO O T- COo TT co co m o
O 0 CO •* O •* T-TJ- |v. CD CD CO O CDT- CM T- CM T-
§°oo o in CM in coo in TJ- o co T- iv.inoco v- o *™ o ^~
OCMCM T- CM CO T- T-
S o o o o o o oO O O 0 O CO O
OOO OOOCMO
OOCO O CO O TJ- |v.
coom OCMIV-CDCOCOOT- Olv-OCOCOO O O O O O CO
CM CM CO CM CM in T-
Q_
vP^PlTl ^OsP-vP^PsPovovLU 5v 5v 3- ov 5vool— oomminooco •* m CM iv- iv.in o 0 T— o} T— co co
d CM £•; T- CM CM T- T-CM
888 88888
OOO OOOOO§00 ooooo00 OOOOO
"00 §0000
o o ooooo
CM" CM" co" CM" CM" in" CM"
T- T- O
OOO
' ^ oo IV-^CD^^*- CM T- ^ CM ^-CD WELLS FARGO COFA FHLBFA FHLB 10/FA FFCB 05/CN MICROSOFTFA FNMA 08/FA FHLBFA FFCBCM00
8
00CMCM
CMin
0
o>CDo_
COco
oCO
CM
S
00in
T-
CO
oo
o
COCOo
oo"
co o o co f- CM ^•ooincooomT-oooocoorr ^-iv.|v.oocMco^ro in o oo co T- TJ-IV-OOOOOCDCOOCM iv. O |v- CO O CMOT-T-OCOOIv.
OCDOCMCMO OCMCMCOOCM-^fCOcoinococMco IOCOCOCOOIV.IV.CMCD CO O O OO CO CO O CD fv o CM CO COOCDOT-O CMT-TJ-T-OT-OO
CMT-CMCOin CMT-COCNCOCOCOT-
COOCOCOCDCM ^-OO|v-Oin|v.CDCOooooocoiv-^- ^-|v.o>ooiv.incoin
OOCO^-^T- ^-Iv-CMOOCOinT-CMCM "^ co T— in OOOCMT— ^-inT—co
CMIV.T-T-IV. COOin^-OOT-O50O
COIV.OOOCM COO5OOT— CO|v-^-oo> T— r— ooincooo T— T— co
T- CM T- T-
xO ^p sp NO sp xP vP NP vP vO sp ^O ^O sp
cboh-cMino inoooiv-cMOioiv-mcooocMO coojinocMincMOiv-oo^cocoin T-iv.coiv.T-^-ino
CMCMOOOO inCMCMCOOOO^T
B Oi-como oooocomcocncMOT-OCMO OOlv-CMCMCD-r-COoinco^T-o ooincjicoocMiv-OCOOCDCOO CMCMCOCOin^l-COtv.oocoooi-mo rv.i-cD'*t-T-^-rv.
^ |v. T— CO O> CO T-OCOCDCO^'O)|v-OOCOCDCDCDCO OOin|v.a>C35T-CDC3)OJinCDCDO COOCMCOCOT— OCO
T— T— T— COin T— T— CO T- CM CO CO
inoboino oowwoow^-IV.CMOOCMO OOCMCMCMOOCMCOcoooot-m iv-cocDcooincoco
cM^to^rcMO •^•miv-coofcMco
oooooo oooooooooooooo oooooooodddddd ddddddddB ooooo oooooooooooooo ooooooooo" o" o" o" o" co" o" o" o" o" o" o" o" o"Booooco oooooooo_ in o_ o_ o_ o_ o_ o_ o_ o_ o_ o_ o
CM" T-~ CM" co" in CM" •<-" co" CM" co" co" co" T-"
««« ««««zzzzzz zzzzzzzz
oo
>- >- > o >->->-0:0:0:0 0:0:0:13 D =) o: iz=> =>CO CO CO < CO CO CO
oLULULU(/3 LULULUp
LLlCOCOColi! LLLLlZCOCOCOQ
LLLLl3D3> LLLLLLLLI3I3DI—
<<Q:O:Q:Q <<<<Q:Q:Q:Z
LL LL |— |— |— O LLLLLLLLH 1— 1— O
5
5
§CM
COCO
COo
COCOoo
co
0_
0?COooin
inCO
%00
CO
CMCO
8
0ooo
COCOin
CO
ooa>o ooocooooooo ooocoo
§dooih dddco'dOCOCM OOOCOOOOO>T- OOOCOO
§•<- ^r" oo" a>" o" o" in" *it-|v-T- CMCMT-OJinmooT- oco-i-cMi-
CMCMCMCO 1-CMCMCMCM
8 OO5O OOOCOOO OO O OOOCOO
ddcoiri dddiv^d8^D CO C^ ^3 ^D ^5 CO ^3^5 f^* ^^ £~$ c*^ if) O) f"i
o" T- o" oo" a>" o" CM" •*" -f"ST-mi- cMCMT-oomT- CO T- CM T—
B°O?-O OOKOOiniv-in ino^-ooomcoiv. ^- o o o CM
inOT-T- T-TTCMCOCM
§000 oooooOOO OOOOO
S OOO OOOCDOOOO OOOCOOOOCMO oomooo
88cti8 88S528oooo oocooo
CMCMCMCO T-CMT-CMCM
0.
0UI00 ooooo
§°cooo oooSio.Omin moocMOOcSoiv. 'tOOi-CM
in^CM^— T— ^ CM CO CM
d
8888 88888
8888 88888oooo ooooo
§000 §0000
oooo ooooo
CM" CM" CM" co" •<-" CM" CM" CM" CM"
oooo ooooo
oooo ooooo
CMCMCMC^ C^C^C^C^C^CM CO T— PV CM m hv 00 O5CMr-OCM T-r-T-T-r-
S ^r-^r^r mminminOOO OOOOO
. O . O O ^CD m < 2 < m S 2 <_i_jZ_i 2_i_j_i5
IISI ZXXXZLLLLLLLL LL LL LL LL LL
LL LL U- LL LL LL LL LL LL
Si
0)OO
CMX—CD
CMCM
OCO
OOOin
o00O)
CO
oo
CDO)in
o
00
8
8o
8o
oo"
§!
UJa.tt
ge
re z•Q OJ2 p o
re O 5O < S
ozS
£2O I-
oooooo oooooooo CM O T- i-
ooooooCM CM CM CM CM CM
iv. oo oo m o CMCD CM CD j- CO O
S3SS
00 OO O) O) CO OCD C3 ^D ^3 G3 ^~ooooooCM CM CM JM CM CM
CM 00 O in CM CMCM CM CO CD CM CD
•* i- ^J- CD |v- CO
OOOOOO
tnUJ
IE< a.S <
ooooooooCMCMCMCMCMCMCMCM OOOO
i- CO CM ^t CM 0
O O O O O ~~
inininmininininoOOOOOOOOfM
&§§&888§SooooooootCNCMCMCMCMCMCM£MK
^^i5§55-:3
2
fMCMfM G)£i!£y£y£^cM
CO T— |v. CM^|v-COO5-J.
CM T- O CM
o ~ -
O
_ ^-t *^s ^—^ s_^« £M CM CM CM
•*{ CM CO CO iv.J CM T- O CMS5°°cli
cco
3£o <
i; iz ^ iz 5; oin m in i- T- oo o o T- T- CM
CO OO G) O O> mBBBoSfcCM CM CM CM CM^
CM TT |v- "«• CD 5T^ T- T- CM T— 3
in 25 co CM in Oo o o o o -r
OLL
EXHIBIT 7
LU
CO CO CD O CMCO CO IO O O)coi 10 10 o CMoo •* 10 in r-OO T- IO CM IO
CO CM CM CO CD IO IOCO CD CM O CO O CM COlOCMlO^-T-5 O T- O r^ T~ co co co T-
CM CD IO CD •* T-
IO CO C7> CM CO T-si co r«- CM T-
IO IOT- CM 1-T- CM" T- co" !-" co" CM"T-.-.-.-COCOV-.-COCM.-COCOCMCNCNICMCN.CNI CO CM CM CM CO CO CM t- T- CM CM CO
5 CM CO T- CO O) IO f-h- T- co co r^ T-h- T— co co co T—
^ CO f T- CM T-CMlOOJCMlOlOlOlOOCM COT-IOM-CDOIOCMCOCMCOCM O O l»- COCO CO O T-
IO CO00 f-T- CO T-IO CD CD O T- CO •fl- OCM CM CM IO r-T- CM CMlOOOO ^l-lO T-T-COOO
CD T- CM
S O CO G3 O CMT- t t O CO
CD T- •*
cc. ujit£.
OOIOOT-IOOIOIOT-IOOOOIOIOOOOOCO" ------- . -- — - -- .._-_ - _-
-r IS(o|in 2
OOOCDOOOOOOIOOOOpppiqppppppcMcqpp
lOCModpoo'oo'pcocqg'pSO) CD CO CO T-r~ 00 CM co 10
cocooo~
jppppppppppOOOTf'l^OOlOCMOOlOOOOOOOIOOCOCOOOOOOI--T-CMIS-COOOOT-IOCMO
O> O T- O O CO •*S 5 8 8 8 S P
T- co" CM" T- •»- T- co" CM ^~
OOOOJOOOOOOr-OOT-
co" co" CM" T-~ CM" CM" CM CM" W co" CM" CM" CM
000000000000000000000000000000000000000000000
ooooooooooooooooooooooooooooo o o o oooooooooooooooooooooooooooooooooooooooooo o o o o_ o_ o o o_ o_ o o_ o_ p o_ o_ o o_ o_ o o o o_ o o o_ o p o_ o_ o_ o_ o o o o 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 O5 O O O r^- O8OOOOOOOOOIOOOOOOOOOOOOOOOOOOOOOOOOCMOOOCOOoooooooooioooooooooooooooooooooooocoooor-oi-" T-" T-" .-" co" co" W T-~ T-" co" CM" W co" co" CM" CM" CM" CM CM" CM" T-" co" CM" CM" CM" co" co" *-" CM" T-" W CM" CM" co" CM" T-~ T-" T-" CM"
_J _J
< ^
gj
IO IOCM CM
T- ^-
CO CO
X X
U- LL
_J
O
o
5?o0
CO
m
XLL
O
O
j?5.CM
IO
CO
X
LL i NON-CALL5*O
CO
O
J
X
LL
_l1
o
Z
0s
IO
•o-
CO_lXLL > NON-CALL5<IOCM
^7u>
^
^ZLL
_l
s? „
CM ^~
CO ^~
m mO -1LL XLL LL NON-CALL5?Or*-
*J
^2zLL
|
O
s?oo
IO
m_iXLL ION-CALLz
eSr~.
•*m_j
X
LL CALL 8/1 2/0s?oo>
COm
XLL
<!o
o
ssIOCM
IO
O_>_iXLL NON-CALLcSIO
CM
IO
m_iXLL
_l
|
O
s?oo
CO
CO
XLL NON-CALLS?IO1^-co
CO
CO
XLL
, _l — 1 — 1 — 1 H _l ,_l_l i-i_,H_i_i_i_j5!_iH_i_i_i_iH— i— li^)<<<<?;<3!<<— I— 1^ssi.lsassislssiligisiiiiiiiliiiii
Z ^NPssPNPsPxPc^xPsPxPxP
xp^pO^O'-o*dvO'*/-1Ox<5"'OSOSo.^Os?.oS^esiOlOIOOOKIOlOlOlOSsS~SjS^ioio.~-cMi^iouiufr~r-.cM.-ioio;s^•CMCMCOT-COOO^OOCOT-CMCMCM"-!
r-lOT-T):T-Trr-T-OCMT-T-IOlOIOCO
CO CO 00 QQ 00 00 CO CO ^ CO CO CO CO CO CO ^s_iO-l-l-i-i-l-J-l-l-l-l-J-l-lSXU.XXXXXXXXXXXXXZ
LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL
O
O
0
IO<£
O
^
^LL
o
o
0
IO
<^O5
^LL
o
5?
10
<O
^»
^LL
o
EoCMCD
CO
00oLL
LL
_l
|
O
oS
S
IO<O5
^LL > NON-CALL3*IOCM
IO
O
_jX
LL
_J
|
O
3?IOCMCD
T-
00
Xu_NON-CALLs?IOr>*CO
T-
co
XLL NON-CALL3?IOr^
IO
CO_jXLL NON-CALLs?IOr^
IO
m_iXLL NON-CALLNON-CALLS S?r-- oCO O
CO 10
m CQO -JLL XLL LL
LLLLLLU.LL
oo oooo
T-CDCDCMOOOCn cococococoM-cococMinr^cocDinoOT-ooi-CMoocoooT-Tfin^i^cncOTtcoCMincMcor^cDcncooi^cncncocMoocncncnoo^-CMcnocMOin^tcn
OCnOCOOr*~CO^tinh-OOOOCMCO<^^t1CMOCOCM'*tlx-CnOOOOh-COOOCOOCMOO'<-OOOOI^COOOOr- ocoocMOcoi^^ff^toooinocMcococoi*frincocMa>coT-oooococooooocMOO'*-ooocooooZ _ o oo in cop oo i^ o
WLU
CO T- CO CO CO •*TtCMCOCMCOT-T-cOincOCMx-CM COCOi-'-CMCM'-CMT-T-T-COCMCMT-CMCMCMi-T-CO
Oft.
§ooooooooooooooooocot-O'«-ooocnooooooooococnT-ooooooocnooOOT-OOOOOOOOOOO^OtT-COCMCMOCOOOOOOOOOOI^COCOOOOOOOOT-OO
z <
CM O O -*tin CM o mCO IO CO 00
o o o o t o oT- O O O T- CO Ooo o o o oo r-- oo
COI^T— T— t—OCDCMOOT-OOOOT-C7)OO>OT-COOOOO 'irO O5OOCMOO>Olh-T-OOOOj
COCOCO^-T-CMCOCM T-T-COr-CMT-CMCMCM
CO O O O CO CM 00r^ o o o co CM mO O O O CM O O-" co"
H oooooooooooooooooooooooooooooooooooooooooooooopppppppppppppppppppppppppppppppppppppppppppppp
oooooo- ooooooooooooooooooooooooooooooooooooooooo _ooooooooooooooooooo ooooooooooooooooooooooooooooooooooooooooooooooo 8
COCMCMi-CMCMCM^T-CO
3zo
s?oo
in
CO
LL FHLB 5.00% NON-CALL^
O
1
in
O
_i
LL FFCB 1.128% NON-CALLFHLB 4.875% NON-CALLFFCB .950% CALL 4/26/10_j_i
O
Oz
tf>CM
•*
CQ
LL
o
o < z
^90O Z ZZ. O &Z inCMo 3? -~ in CM
in v oCD m 5_i _i _iIIILL LL LL
LLLLLLLL LLLLLLLL LLLLLLLLU-LLU.U-
ooooooooooooooooooooooooooooooooooooooo o o o o o o o
I— OOCOOOOOOCMOOOOCDlOCOOOOCOCO^-OCDOOh-CDOOOOOOCDOh-CMT-O'^'OCOOT-COOOO
UJ
^bCOIII>fc
8 '-o-'j-ocoO'-ooinooco-
W co" co" W CM" T-" CM" T-" co" T-" T-" co" i-" CM"T-CMv-CMCMCMCMCMCMt-T-CM CN CO T- CM CM CM CN CO CO T— IT- CO
CM CO O CO CMocj)CDooooo^-oocnr^cDincooocoo^tocDinor~cDoooT-oocooi^cMT-ooocogooooincoocNCDT-ocMoincOT-^-OOCOOt^-t^OT-CMOOOCMOCOCDOCOooOT-coh*oococj>oc7)cooor^.coh-CMi^cDinoocoor^-r^OT-cMooocMOcocDOcocor^co•<i-ininco«*-<i-'c-cocMOOT-ocoocMooT-or~-cocoincoi^ini^cor-oinoT-^fcoocD-'tinCM o> in o i- inCO CD •*!• 00 O)S T- T- O T- Tj-O5 CM O CO COincDoincoincococo
T- •* CO CD T- T- T- CM CM T- 1-
CMCOCMCMCMCMCMCOCMCM CMCOCOCMCMCMCMCMCMCOCMCM«-CMCMCM^-CMCMCOCMCMCMCOCM
OT-OOOOCMOOOinoOOCOOOI^COOOinOOOOOOOOOOOOOOOCDOCOO)inCMOOOT-oooooocoooocMooooooincoooo'j-ooooooooooooooocooO'a-ininooo^-
88£§8 COOOOT—OOOOOCOcomOTtin
o o o o. . CM O O ~CM ^- CD CN
T- CD O> CO O^ co m CM ooo> in i*- •* t oo
So
z
CO CMo coo o
TfCOTj-COOOOCMCDCOOCOCOO-r-COCOOO)C7)OOC7>COOOCOooooOOC7>OT-o>
co Is- co in T-O 00 IO COO5 O> O OT-" »-" CM" CM" t-"S!8 o o o o oo o o o o in CN CD o coT- CM_ O P CN
CM" co" T- CM" CM" CM" CN"
8 -«* CM T- T- coO O O O CM
T-" CO" CO" *-"
§5
CO CO T- CM CM T- T- i-
H 8888888888888888888888888888888888888888888888o o o o oo o o o oo o o o o
ooooooooooooooooooo8OOOOOOOOOOOOOOOO~ ~oooooooooooooooo 88 o o o oo o o oo o o ooooor-ooooooOOOOOOOOOOOo o o o oo o o o o o o
T— COCOT— CMT— t— T— COT— T— COT-
oooooooooooooooooooooooooomomoooo_ooooooT-" T-" CM" r-~ CM" CM" CM" CM" CM" CM" T-"
o o o o o oo o o o o oo o o o o oCM" T-" T-" T-" CM" co"
o o o o oo o o o oo o o o o
CM CM CM CM
o o o o oo o o o oO O O O T-
T-~ CO" CO" T-" V-"
°^^"9
9^§i^iJgg"
o
ssin _
§~ >-!«»! fc r-CM co in °°
•^ O O •*' 3
03 S 2 GO <O -I -I O 2 _ ...U. X X LL Z Z XLL LL LL LL LL LL LL
LLLLLLLLLLLLU-LL U.LLLLLLLLLL
CO O O5 tO O O 'O O O o —CN CM CN CM CM•» o in o inr; CM CM j; CM
T- O •<- CO T-
O T- -^ O T-
OC7)ODCnO>OC7)OO•<— OOOO-i-OO_00000000CN CN Csl CN *'*'-' ^' ^'
§ ° § 2
S CO O ^ 00 ., _.•r- O T- T- O T- O
CN CM CM CM CN CM CNco ^ in co co i^ T—rfMCMCMOCMCM^
CNinCMCMCOCOi-CM~ ~ O O O
O O O5 O O
oooooooocbCNCMCMcDO)O>c5cDCNc3r^
II
coincoinocococor-COTl-^-CMinCMI-CMCOcDCDcooococor^-coco
toCD ?OO 00o r«-$ 5 8 COCDOOCM-'-t^OOOCOCMTO S CM Is- CD Is- CDCM co CD CD incOM-^s-M-
8 8
(0
r~ co r^ o co o ocp co cp p co p p
o>" i-~ CD" CD" in" in" in o" o"
CM" CM" CM" co" CM" CM" CM" *-"
5o
Sco"f-CO
OOOOOOOO CO OCMCOCMCDOOOTTOO CDT- CMinCOCMin-^
oooooooooooooooooooooooo
*-" CM" *-" rg" CM" CM" CM CM"
cor~CO
nCMeo
o CM in m r>- oO CD ^ CD ^ Oo o o p o oCD" co" CM" co" CM
o o h- co h- op p oq co cp pd d m co CD d
co o o inco p p •*__.. ..__p)o'd dSOCDCOCMOCOOO *-COCMOOOOOOO l~-
i-." T-" CM" CD" o" in" oo" o" o" en"cococMi^r^T-oinco CDCMCMCMM-CMCOCOr-CO O
o •q- o o o oo •<»• o o o o r^-cDinocDocor^cocoincococot^ocoh-ocnincoCO'fCMCOI-^OCOT-'-'^OCOCnOCMCSICMOOM-CDT-
OOCOOOOOCDCOCOOOCNCMCOCMt-(OCMm
O CO CO T- CD r- CDT- 00 f- 00 O 1- r-
T- T- T- CM 1- O)
CO00en
COCOOOCOOCDI^co in CD co in T- M-_
in" i* N." in" m" co" en" o"
inCOCOCMrMr-OCMCNo oo en co •* o T- T- -<t
" " " " " " " "oo" oo" oo" in" o" T-" •* co" co" o" oo"CM CMCMCMCOCOCOCO
OOOCOOOCNJOOcDi^tcoinincnoo•<tin-*T-cn-<-T-pTt
CNCMCMCOCMCO'co'cOCO
COCOCD
OOOOOOOCD
CMcoh^ooppcoin
CM csicsicsicocoi-^CM
S? gS gS gS s?
oo'o'o'oo'o'o'o'ooocicicido'ciocioo
8 CO ;ii
oooooooooppoppppppp
ci ci~ oo
o in o h- o o"coCM
CM" CM CM CO CM CM CM T^
S O T- O O O Oo o o o o o
CDCD
CD
co"oCO"
O O O O CDp p p p in
d d coCM CO 00
CO CD CD CD OO CO" CM" CO"
CDCOCDOOCOh-COO
K cooincoinor-comCOOCMT-f^OCDOOCM
T- 00 CO O T- O T-co r^ •* p p CM co
8 Oi^cocDOininino^-in^tpCpr^CppCNICMI^pCOr*-1^;diricbo6oSc>T-:cbo6iridcoc6
T- cMcor~.incoinooinoinr-cnooT--1-incDi--cocoincocM^fCMr~-or-cncOT--1-
ooco10enCM
in CD o i^- CMCD r- • •CD Oin" co" CM" co" CM" co"
CMCMCOT-COCnOTfCMi-O"."IS . '.".co" in" CM" co" in" co" CM" co" co" co"
H U,
UJU.
< -OL <
ooooooooo oppppppppp pddddddddd dooooooooo oooooooooo oo" o" o" o" o" o" o" o" o" inooooooooo mooooooooo oCM" CM" CM" co" CM" CM" CM" T-~ ^-" oo"
ooooooop p p p p p po o o ci ci d doooooooooooooo
o oo o o oo o
§
88888888o o o o8888
§000popd d d d§000ooo
o o opopo o oo o o000
o op po oo oo oooooooooooooooooooooo
CM CM CM CM CM CDCOCMCOCM^CMincO
O O O O8888in CM" •* in"
o o o oo o o ooooo
co" CM" co" co"
o o oo o oo o oco" •*" co"
o oo oo o
t" co"
m
CO
&&
_i <
< ^M
a.
w
o
o:o
53
3°S?Ss? c^ CM o^ P,-, CO T- p '
CM CM CM CO
m m o
Z I Z Z Z ILL LL LL LL LL LL
0000
Z 2 Z Z
O O O OZ ^z
3? s?
§ §
d d d d
0.0.0.9.K. cc. a: a:i- i- i- Hw w w co
OOOOOOOooooooo
LL LL LL LL LL LL LL
"99z z zooo
popodd
E0)
§ g # S?in in o or- t-- m inoq oq r^ iv.
CM CM CM CM
£~ =) -D -D -3 -D
" CO CO CO CO
UJ uJ LU UU
o o
£ £ £ & £ ir £cc o:
11a: a:
COCOCOCOC/JCOCOCOCOCOCOC/JCOCOCOCOCOCOWCOCOW
<<<<<<<<<Z Z Z Z Z Z Z
h-l-l-l-l-l-l-l-Hl-l-l-l-l-l-l-H-Hl-l-l-l-
ooocnocnoooT--i-r-O^-O^-T-T-ooooooooo oooooooCM CM CM CM CM CM CMCM T- oo in CM CN cnT— T- T— CM O O O
CO CM CM CM CO CO COOOOOOOO
§CDOooCMCM ooCNCM
C7>CDOOooCMCM
CDenOOooCMCSI
O>O>OOooCMCM
en o CD CD o CD eno T- o o T- o o
CM CM CM CM CM C^J CM
T- O
CM O O O CMO T- T- T- T-
gg
oo m TJ- oo co inin in CD m m h-8in
ffi
Z
•* a> i^obcriScbooboCMO>incor~CMincMocMCMC7>i-i- mooCM" in" oo" t--" oo" o" CM" oo"r^-T-oO'tcMinmr-.oppP_T-T-T-in
TJ-" W m" co" co" W W oo"
o o oq p po o inin o r^f- o co
q m »-
om oSo o r~-o co •*
88 OOCOOr-CMCMCDCOr-CMOJCOOOOCOCMOCOOCOCOqqcoqr-cMCjjqcocpcpTrcoqinincocMPcopcoco
S'^cMiriomoiricopT^cMi^odcoco'iriiriodiricM^cocMincoocoodT-ocMocooi^.coincDcMO>i-coo>(Oinoi^cocococMr^coocomcO'-'M-cocMooincO'-ajcDr^cooicocNCMini^cocDtcocMcocoincoT-
ocoo>rocoo>Ti-inooOT-or^coinoi^*-incnoina>ooooi^cMCMinr-cor^cnr-inocDCMi-^CMt^cDCMOcoincMr^cocnmcnT-cor^co-itoooCMT-CMTj-^ri^-OOCDCMOOT-T-COr-COi-'t-inCOI^'tCMCDT-CMT-CMCMCMCD^ T^ CM co CM co CM" T-~ co" CM" CM" co" co" co" CM" •*" T-" T-" CM" T-" CM" CM" CM" CM" h-" co" CM" co" W •*-" CM" Y-~ T-~ »-~ CM" co"
co co coo co ooco CM
r- r- CD CO
CO
HI
O(OCOCOcocqT-cp
_
^•" CD" co" •*-" CM" oo" ^-" co"co in co o r- CM r-
i-OC7>OOCOr^CDr^^CDv-CDCDOOCOCJ>COI-~OCMO>O-*l-CDOOCOCJ>Tr
mooh-coo">cocoinoI^T-CMincOOON-^^
T-^-CDT-M-CMv-CM
So
2§
iiH fa
OOOT-OT-OCMh-co co M- CD o oo in CMmcpcpcpcq^^-in
OOOOOCMCMO
8 v- o o o in CDCO O in O CN CMco in in o CM oo T-*t CM Tj- |-~ T- CM 00
r*-." in" T-" co" in" •<- o"CO O CO *~ CM CO COo o o o o o o^•" i—" in co" oo" T-" r-"
oooooo o opppppp p poooooooo| O O O O O O O O| oooooo o o
oooooooooot^or-opoocoppoointoin
OOPCDOOOOOOOOOCD-r-CMOOOCD-^ri^CMCMCJ)CO'<tOCMOOin ooincoOTtoooo
OO>OO>OOCDO>OO)CJ)CJ)OOOO_O_OOOOOOO^'T-OO'r-inOOT-" CM" CM" CM" co" T-" in" T-" T-" CM" co" co" CM" ^r" T-" T-" CM W T-" CM" CM" CM" CD" co" CM" co" T-~ T-" CM"o o T- o
T-" T-" CM" co"
o o o oo o o oo o o o
o o o oq q q q
o o o oo o o op p p p
ooooooooooooooooooooooooooooqqqqqqqqqqqqqqqqqpqqqqqqqqqqoooo'oo'o'oo'o'ooo'o'oooooocaoooooooooooooooooooooOPPPPPPOOOOOOOOOOPPOOo o o oo o o oo o o o
o o o oo o o oo o o o
oooooooo 88 aoooocoooomooooooooooooooomootninooor-pooooppooooppoocooocMOippoinooo
CM CO CM CO CM inCMCMCOCOCOCMTTr-T-CM CM CM CM in CO CM CO
CD
CO
CM O O O O CM CMT- q q q q *- ^
T^ T^ ^ T^ T^ CO CO
D D 13 ID 3 ID 3
00 00 00 00 00 CO CO
UJ UJ UJ LU UJ UJ UJcc cc a: OL a: a: cet- i- i- H i- i- i-
00 00 00 CO 00 00 COD D D D 13 D 3
ZZZZZZZZZZZZZZZZZZZZ2ZZZZZZZZZZZZZZZoooooooooooooooooooooooooooooooooooo
O O) P P
CM CM CM CM CM
Tt CO TT O CM- -
S CO CD 1^ O>
O O O OOOOOOOOOPPOO
ooooooo o o o o
t^ 00 O COO O T- O
CMfMy^ygjg^MCMCMCMCMr^-OT-mcMinT-coqT-ooo^
— -.--, ..cSincMr^OT-T-OOOOOOOOO
T-inCNOOCNO>'*CDCO'<tCDtCMCOT— T-cncNT— cncocncNoincoT- Is-1 - - - - - - - '- - "5 CO •*CJ1CO
. _ . _ T^ O 1^ ^ OD IO IN*— T— ^oi^Ocoinoco oo in in co «3 *-_ Is- oo
CN in 5 CM CN in x- in CM CM co o T-_ CN
T-~ CN" CM" T-" T-" CN" »-" CN T-~ T-" CN" CD" *- CN"
cMinococM
Is- ooi-cncncNCNor-cnIs- encp^cNcp^inf^coCN ^riocoiricocNcdcriT-CO COOCNOOCOCNCDCncOco cMT-cDcoiocoTrcocn
CO
CNIs-
co en co inco co T- h-
h- CD OO v-
m" o~ •<*•" CN" ^J-" o"CN T- i- CN 00
£ SO O inooaCO
Oco CD^j-§ Z ? 5
CN CD oo in CMSoo oo co oo•<- -3- 10 en
i- o in •*in o in CDCN 00 T- r-
5in"Is-CO
8 SIs- in co Is- inh-. ^- cp h^ in
CN i--^ co en 06CN co o en Is-CO CN CN CO v
ooooooooooooommcoo'tinoinoooincNcoor-.ooincNOcncnT-inoooTf-^o $oooooooocn CMooomoococooocN coT-T-ppininininin CN
oooo'o'oooo CN
OOOOr-00>»T-i-CDOOCDOOO
^ fto5 **
h-cocotincooot--8 0CN CD
O>
OT-cnmmr-i^oph-.^;CNOocpcqp
pi ai co oo oco en CN Is- •*CN O CD CO CN
rs-co•*-CO incNcocnis-co-CD CO CNt O l-j.ininco
S
CO
CN
Is- T-
3 Z
CN OCO OCN O
S T- ^- oo en coIs- CO CO CO •*-~3 O Is- CO CO
S
co"CN
co"Is-m
U.<
UJ
oooooooooooooopppppppppppppp
o'oodoo'o'o'o'o'p'
o T- en in in r~- h-p t^ 't CN co co oqco en co co o ^ csiCD en CN Is- ^t co coCM O CO 00 CM CO CN
T- CN CM" *- T-o _
CN r^- ^ CM CO
CO
CMin
encom
O
IQ.IZZZZZZZZZZZZZZHoooooooooooooo
m
w
oo3 P
Z
ILS FARGO BAUJ
§MANAGEMENT ,T
RPORATE CASIOO
1 —RARY ACCOUNCD_l
CO
OL
0zID
O
fC\-1 F WATER DIS<£
_l OVEMENT CORIcc
1 F PUBLIC IMP^_i NCING CORPOR<
[L
O
m
CLu_
<^_i LSBADcc6
LLo
o
LL
^_J
oooooooo
CD
*%<fl 7k
h- h- h- OO 00 008§SS§8
CM CM CM CM CN CN
m « CN CO CN g
o T- ^ o o o
co oo en en en oo o o o o •—o o o o o oCM CM CM CN CM CM
P £J T; ------
EXHIBIT 8
CITY OF CARLSBAD
Fund Equity in Pooled Investments
AS OF MAY 31, 2010
Cash Balance by Fund:
General 77,492,233
Special Revenue 49,778,124
Debt Service 0
Capital Projects:
General Capital Construction 68,283,036
Traffic Impact Fees 16,404,553
Public Facilities Fees 44,538,687
Park Development 2,385,438
Transnet Taxes 6,215,537
Drainage Fees 7,177,881
Special Districts 74,679,193
Infrastructure Replacement 53,966,164
Redevelopment 2,515,238
Other Capital Construction 4,369,460
Total 280,535,188
Enterprise:
Carlsbad Municipal Water District 65,892,306
Sewer Fund 48,767,725
Solid Waste 6,990,303
Storm Water 2,332,841
Golf Course 220,160
Total 124,203,335
Internal Service 28,566,459
Agency Funds 16,930,937
Misc. Special Funds 0
Total General Ledger Balance ** 577,506,278
Reconciling Adjustments (1) (2,649,999)
Total Treasurer's Investment Portfolio at Amortized Cost 574,856,279
(1) 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 6/07/10
IS
EXHIBIT 9
CITY OF CARLSBAD INVESTMENT PORTFOLIO
As of May 31, 2010
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
AAA
AA2
AA1
AA2
AAA
AA3
AAA
AAA
AA3
AAA
AAA
AA2
AA1
AA2
AAA
AA-
AA
AA+
AAA
AA-
AAA
AAA
AA-
AA-
AAA
AA-
AA
AA
BARCLAYS BANK
BERKSHIRE HATHAWAY
CHEVRON
GENERAL ELECTRIC
JOHNSON & JOHNSON
MET LIFE GLOBAL
MICROSOFT
NEW YORK LIFE
PROCTER & GAMBLE
ROYAL BANK OF CANADA
SUNTRUST BANK
3M
TOYOTA
WAL-MART
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 *
Moodv's S&P
ALL STATE LIFE
CITIGROUP
GENWORTH GLOBAL
GOLDMAN SACHS
HOME DEPOT
PRINCIPAL LIFE
PROTECTIVE LIFE
US BANCORP
WELLS FARGO
A1
A3
A2
A1
BAA1
AA3
A2
AA3
A1
AA-
A
A
A
BBB-
A+
AA-
A+
AA-
Carrying Market
Purchased Value Value
05/30/2008 2,013,962 2,181,360
06/20/2006 11,029,629 11,213,740
05/07/2008 2,006,387 2,057,440
1,000,446
2,996,084
03/19/2008
BBB+ 06/12/2006
04/30/2008
07/17/2008
02/03/2006
04/30/2008 1,000,000
07/17/2008 3,000,000
2,998,283
01/30/2008 4,038,999
1,001,290
3,085,050
1,022,320
3,138,330
3,014,970
4,128,240
* 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.
CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF MAY 31, 2010
WEIGHTINGS FOR CORPORATE AND FEDERAL AGENCY ISSUERS
EXHIBIT 10
PERCENTAGE WEIGHTINGS BY CORPORATE NOTE ISSUER
ALL STATE LIFE
BARCLAYS BANK
BERKSHIRE HATHAWAY
CHEVRON
CITIGROUP
GENERAL ELECTRIC CAP
GENWORTH GLOBAL
GOLDMAN SACHS
HOME DEPOT
JOHNSON & JOHNSON
MET LIFE GLOBAL FUND
MICROSOFT
NEW YORK LIFE
PRINCIPAL LIFE
PROCTER & GAMBLE
PROTECTIVE LIFE
ROYAL BANK OF CANADA
SUNTRUST BANK
3M
TOYOTA
US BANKCORP
WAL-MART
WELLS FARGO
PERCENTAGE WEIGHTINGS BY FEDERAL AGENCY ISSUER
FAMCA
FICO
FEDERAL FARM CREDIT BANK
FEDERAL HOME LOAN BANK
FEDERAL HOME LOAN MORTGAGE CORP
FEDERAL NATIONAL MORTGAGE ASSOC
TVA
U.S.TREASURY
Total Portfolio
* No more than 5% may be invested with a single corporate issuer.
"There are no percentage limits on federal agency issuers.
Investment Cost
2,023,559.81
1,590,861.34
4,085,739.63
3,103,177.11
11,022,079.70
27,634,444.89
2,016,628.76
1,025,648.53
2,974,590.00
1,017,457.28
4,043,114.52
2,072,820.00
1,994,269.66
1,000,000.00
5,246,650.00
3,000,000.00
1,066,260.00
2,066,260.00
2,121,417.76
8,559,850.00
2,952,150.09
10,099,588.99
4,139,348.92
ENCY ISSUER
Investment Cost
7,884,746.01
11,083,183.55
56,371,790.13
131,214,585.03
41,681,077.43
41,621,252.91
5,530,478.48
97,705,259.26
Percent of Portfolii
0.35%
0.28%
0.71%
0.54%
1.91%
4.78%
0.35%
0.18%
0.51%
0.18%
0.70%
0.36%
0.34%
0.17%
0.91%
0.52%
0.18%
0.36%
0.37%
1.48%
0.51%
1.75%
0.72%
Percent of Portfolio**
1.36%
1 .92%
9.75%
22.70%
7.21%
7.20%
0.96%
16.90%
$578,123,042.64