HomeMy WebLinkAbout1997-05-13; City Council; 14162; REPORT ON CITY INVESTMENTS AS OF MARCH 31, 19971
CIT 8 F CARLSBAD - AGEND ZT BILL
AB# &am:
MTG. 5/13/97 CITY ATTY: &
DEPT. TRS CITY MGR~
REPORT ON CITY INVESTMENTS
AS OF MARCH 31, 1997 -
RECOMMENDED ACTION:
Accept and file report.
ITEM EXPLANATION:
The City’s Investment Policy requires the City Treasurer to report to the City Council 01
monthly basis the status of the City’s investment portfolio. This report is presented
Council each month on the investments held.
In summary, the City’s investment portfolio as of March 31, 1997 is as follows:
- I
i
investment Portfolio (Cash and Securities)
Current Month Prior Month
Par Value 177,550,474 180,384,088
Cost of Investments 177,924,446 180,410,324
Amortized Cost (1)
176,759,055 178,725,372 Market Value (2)
177,761,595 180,291,445
(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 Wells
Fargo’s custodial report as of 3/31/97.
[c
-
-
m
Cash Income Fiscal
Year-to-Date
Total Income Over The Life
Of The Investment If
Held To Maturity
- -
- -
-
interest Income
Current
Current
Income Month FYTD Month FYTD
Month Prior
9,948,860 1,054,089 8,894,771
26,179,907 24,982,172
I I
0 0
PAGE TWO OF AGENDA BILL NO. /< /dA
Investment Performance
Average Life
[Years) Average Yield
January 1997
February 1997
5.74 1.41
5.80 1.53 March 1997
5.75 1.45
I I I
All investments have been made in accordance with the City’s Investment Policy adopted Jar
2, 1985 and last revised September 10, 1996. All investments were initially made in accord
with the City’s Investment Policy. Events subsequent to the purchase might have resulted in :
investments not being in compliance with the current policy. These events are typically a chan
the City’s Investment Policy or a change in the credit rating subsequent to a purchase. See E:
8 and 9 for details.
Investment portfolio has the ability to meet the City’s cash flow demands for the next si
months.
EXHIBITS:
1. Investment Portfolio Breakdown By Book Value, Market Value, Cash Income, and AVE
Yield
2. Investment Portfolio Breakdown Of Maturities
3. Yield Comparison Graph
4. Cumulative Cash Income Graph
5. First Quarter Transactions
6. Investment Report
7. Reconciliation of Fund Source to Investment Portfolio
8. Corporate Note Ratings
9. Percentage Weightings By Corporate Note Issuer
IO. Investments Held Separately - Quarterly Report
0 0 Exhib it
2 8 ih cq
Q 3
3 k
c 3 3 *
!i 5
A Y
2 E
L C L .3
P,
5 d iz i
c,
6
\ e z
4 2
B 8
0 8
d s G
0 8
4 2
co
m ?
4 2
0 2
b 2
m z
!a 2
30
In '?
N 2
0 2
4 41
0 ZI
x r3 ry, ? m
s m m
In ".
G 4 9 ooc, xgzzm01 x 0 s T ?, 2 2 ;- gm e 3 2
mmm- 3
k 2! z
&I s! &% 8
w ", & z- * 5 *g *m 3 5; ?Z
28 E E E
s 8
83 P,
E
0 z L
m$m, Q
m In
Qn EO
Gh
-mmoL3 mm","! d
0 mc,
fA
-T va
0
GoooPoobP f, mPm0 In m zm g
cq Q
C\I\Smm :- u 3 g .z L
"! *, d m, m* sl 2
22 g
cs 160 %L n 8
3 zn 00, dP m $* q :*
g~8s8~iL~~g z 2
3 u b m
** 00, 0, m- 0, 21 2
wE WWPdv,O v, 2- z* 2 zn 2- rn 2- brn * mL3v)m
69 2
S00OPdL3 c\1
m ? Q I' E- g- E( mA I' W33P-
3 m* m H 3 2- V)mo*mcQ v) m k c, - m- m, \s, m
2 2 6 u u
d mL3v)m 2 69
8 + a" E E
OSOONm*Pm m m 5 0-v)GW
k?z?$c$g zn r;- 3 gn :* v)
\o
2 *
Ob4 Q2 o~o"""L3mdL3 ih NmWGm v) d
d o&i?$ZEz 3
c,
3
8 m- 3 2- 2- cC
V' E&!$ c;l
4 g
2- 30
69 3
4
a
0 0 Exhibit 2
0
d 0
H
B 0 a E li2
?
2
t+ rA
E n
2 4 u 8 E a
e Q\ s
a u
n d rr)
$ s ?
N 8 8 E
2 @
8
i3
13 k
T k
T 2 5 2
b4 Q2 9 8 e s 8 E
4 @ 0
a3
c;l-.C--."%c? ssssTss?gsl F C00lflv)o' t;00
0 b
mC-4
s
4
0 CI
b
0 0 h u N m 2
8 m
Vl
3 m
:*
2- vi
\3
2 Sn m
N VI
m..
d- 0 ",
"? !4
3 m
W m
0-
a_
3 vi - ;i
v?
il 0000Do0000l mIn 2 N*
3 * mm *A ** lcIl 0
2.. 2-
:I
r/l & 2 *
(?
0
0 0 0 Do Ls 3
3 3
m m
00, 4 N s PI
L3 s r-" r' rl
0; 3
0 0 01
:I
& * d
5 E
w
0 0 0 In L3 '", - m :- N
0 0
;*
2- 2
0 0 :-
2- N
3
* 0 F * r". 3 m
Ls m
0-
\3,
3 v)
3
El m 00
SI
b $1 8 +fB$bgS&-=f kB< e JE3 4
pi
s
2 8
d- m
0 rl
*,
2 2 €4
Do s d- 3 2 N
v? Ls
r-" m 69
t- s \3 :- 2 N 0
3
e3 VI
n
m s 0 9
9
:* 3
d- v,
3 o' €4
*2 4 c3
8 0 ci b s
0 0 Exhibii
z 0 m H
I% 4 L c 0 r) n 'r
I a H *
F4
4
r/i +
7
F4
4
P4
0
7
x
8 E
U
& 0 L
r\ m m
4 2 c
I
v) m m
4 s h
h ea c a 7
.c, 8
I 3 7
k 4
to
S m 7
?
8 .c,
u)
I3
C')CVrcOQ)OobcOLC)-
?
I I 1 I I I I I I
GGG ujujujujuj
e 0 Exhib :
0
0 E
0 a H
A
u %
0 +
a?+ +I,
1 c6 E $
r)
- c, 3
8
g
0 0
Frc
t\ m
s h
2 A
W
13 11"-
~~ F cv000cD~cv FF
_"
-
b
Q)
Q YrL
a
-
-
h
Q)
m -3
1s I
-
7
CD
Q)
F'CI I :B
L
-
CD :Q)
=I 07
" - I
e 0 Exhibit 5
c
5 =I
WONNO~OO~ r-~oaa m~Nrvr.ommmmmmm
m-ru 0""- m.-.=N rNNNr N"-m -NN.-- .-rt-rrr.-rrrrr
z ma mmo boo P -----.--N-r.-Or.. N-m-m-m-m- ~~N~N~O~r~~~O~O~O~O~o~o~O~ 22 m ~OOON~~OT omm~~ ~mabmr-mammama
b "-0. m.99 sm., ". 55 rmmmcfr.mom m-mmm mm.-m.-oum.-NNmN
2 mo -om mor- m a.qc?*.r.-a-qm-?o-c? V.r-"."T m~.mo~~~o"-r.~m~.~.~.~.
N "9 z?: szz m mm~o~moom momma ~TN~~O~N~~NNN
m mo mom mom g $ZX2?$8XZ pxw??? ~zz~~z?z;~~~~ m
mo
mm mmm oar
- rr NPN rNm
ao~momooa r.~oma mwrvNr.oammmmom
x mw mwo Tom ma aam amm P NN.-.--T.-~o O~~NN rmvmm~aamaamw
0 '49 ""." "2'9". '9 r-ornm-rr.~~r-o mmcomm m.-mar.~-aooooo
2 bm olcm rima
- "0 OF? c?=?!z 10 mo mom mom g- y?xz?zxz% y??? ;z~Xz~~-?~?;Zz m ... ~moror0r.r. mwmmm mNouf.-mr.r.vorm m mo mmm I1 a-m-*-a.-.m.*.m.a. o.-.t--m. m-m-r.-o.o-~o.o-r..r-.r.-mm. 0
c .-.-.-.-N 7-N N.-mmm (INN rm mN " m" - r
Eo
sssssssss sssss sssssssssssss
o~mmmmlrmo ~mmoo mfmoa~~oaot.-m
$ sg sss sgs m ooooooooo m~oom ~ornmoaoo~o~o.- s
N
5% $"I y$?z$L;E :v=!;?z y??$?y!$=3$$$$ 2 Z8 8W:: 888 ;; 2% 22: 2;: z
ooo~oooor- ooooo oooooo~ooommo m gxgc;;:g8?~x zzggg gz;ggz?;g$$;; -
e ~.?a~.~.~-x~.$. E.$z.g-b- ~.%~-~.sfi~-$~.xSx~.
2 mr'crm~vomo baNoa aNNmmcormocorob g 8% 228 2:: 00 000 000 Fi
+ Q am rNO brr E.:. y%z. v.2. 5
a mmmmrmorw mmmom r~~~m~ornooooo 5 m %- z* 9 z- %- E- %. z. m m-m- m- 0- a 0- m m. m N m o m 0- 0-0-0-m T. 0-m 0- 0-0- 0- 0- m
rrrr N m a- " " "Pr rr 7"" " rmr rrm g
0 - c
CS - sssssssss sssss ss88g$ss&.?8$ss oomooooom 00000 aomooommmmmmm 00NOLF)ObON (DOID00 mr-NOOONWt-NNNN $ 4 y?;;sv?zs8; 8%&22 y?;zsSv?$:;66;
-0 P
ss sss sss mo mo~ mar- 00 000 omm 22 zgs 22:
YI L: 0 .- ... 000000000 00000 0000000000000 0 000000000 00000 0000000000000 0 00 000 000 c 00 000 000 c
990.999999 0.90".9 0.90.999990.0.999
90-0-0.9r.99L" 0"-990. 9999~.r..~.~.9~.99~.
9 m E i$l .-NNN- Nrm rNN" r"?rr~"r~r~-r m 2 0-J
88888888k 88888 88888C8888888 : a 88 omo ooo 0.0- x&:. XZ-8
; 0.0. 0".9 :.E.$. ; - r- NTN
r- c
0 m - 0. k m r. r-r- ; m- q gs<<<$%ss Sss$$ Sssssssssssss m mm (0 a
- 0 00 8ZZZZNNZZ SZZg! 5ZZZZZZZZZZZZ zz zzz ss $$g 99s
i=. 88 B
2 2
r- 3s
r- $ N $z$gg r;e+as
s?w!?om,o~ ,Z.ZZ *spG~$~g$~$~ r.W $E r.25 yz2-NQuz3 o.o$$mO 0 383:: "~wooww~w~w~ 93 xn ga pw
m"8wzwmgs gmi=oo q&ZZ==m==== ""88 ~3s~ggsso-e.eoo sg !Gg: 86':
r- an ss;c+?$g~ ;g$ss yph:p%E$$$$ c!# 4Ll~ we$
mm. .o :b WFf E=a z;G 2>o>E+3wg o&y$ or-d2wwamwaaaa s$>333>>d>>>> o)z zgz O>
b- DI -e?P?+ERsz wn2gg c!0m2$g??g22?? 2~ sga 5sL.r
3 $$$.p".O $orno$ w 2U.m r.J$z""i3a~$$i5a 00 $or% z=! mw-e :$$
g"jW
b $2$2gzzzp zzgpt zbqpnqq!gqqTq ww $5 wmE 3% u+u 2z2
W Q 2 2
Amwee 22 : f r- $2 r.4
r. 30
-42
tom
B ID 2 . ornjj Ez 5 :
~m>m~%~Y> ~w~ww
r 2 $ m ~Zlm <Q3NN
j 3 $3d$ gg-eu< woo 2o&>e&gseg -jjg$&;aO;;;; ? u) : W $8; - r 1
v) nnmnono r OD
Q,:~W':%G~ mwfmm a
Ln .... z wmDI$s+w~ DI w nE+E&zn;b L6Eoo go5E,,o~~ EEEE
boa . .
a aEoEa:sysy ggggz ~~E~~~EE~EEEE 5?
q aEzEzaaaz u+ub-ouuuo 25522 25F562EF5EFEE c
r. $ $0
mmmmommom O~.-NN .-.-mmoommr.mmmm ~p~eg?eg? omooo oommoommmmmmm ......... a>>zz ............. r.m.-mmmr~r-.--F r? 3 zl _=F)xQprc 0.-ONN "m".-mmOmmmm
e2 go s:."mmrmr 000000000 22282 Zigs2giasgggsss
zz 00 2E6 56E
f& 555 %e? 5: 2'": *x9
00 882
r.r.i.
zm.-
rr mm
" - gz 666666666 66666 6666666666666 E zs=,z+z~as S~AZGG SZSSS~;SZ:GGG SS $!sg g!%$ P
rrrrrrrrr aaaaa mmmmmmmmmmmmm F $$ e90 PCB g
m= .... .... L)G .... i
c
z2 ial $$$xxcQQp OOONN ggg======pppC a:
NN (ON- N(O(O 6
UZ 000000000 00000 0000000000000
z x:< ar.r.hr.r.r-l.h r-r.I.r.r. r-r.r.P-t.r.r-r-r-r.r-r.r.
IY 00 000 000 b
I
mmN mm*
.... .... .... .... mmmmmmmmm ?%epz p~~~$~~~e~~e~ 2 % &g $j; .... 2$$$$3$$$ ;ss@ 44ggg"c:28zzz $ % ........ .... +
$5 "p) c $66666666 66888 ggggggggggggg g @
;& g 3 I 3 I
.:.>:.: .... ........ ........ ....
0
Y
n 2 ;zl $g> c .:.y,.: u: ........ k E gj& k a
..... U I F i....? 2 z b
:& a: E 0 2 ;& 3 LL 2 ;* z a: 0 m LL h a a
0 0
.- 00 2
" 2
s- 55 2; % =I
El
OLD s
"
-
N
N
-
00 0 22 s. +. OLD 4 :
c
Ln r r -
E,
1s EE 5.6 ?? p a:I OLD
00
.- x
R
z- q 00 9 0- 0 0
EO ON a g
E 1 1 ;[ 0 r. 2 ..- GO
0
0
- 0 2 n tt
0
0
0 z5 00 00
00 00
NN
0
m 9
0- 9
9
c L?
v' ; La1
; a21
6 0 &
I 0
n x
4 =o r- . m m
G 0 C x
r. 0) 0)
n w + n
r
3
??
U +
r. c
2 7
68 s?
a a:? P
w ti
m z 25 Gg $6
2 z
I-
1 m
I- 3
2 zl eo
I mn
5 5 $1 2n
C -
; al E2
.... .... .... .... .... .... ....
.... .... .... .... .... .... ........ ........ ........ ........ ........ .... .... .... .... :.x.> .... .... .... .... .... ........ ;:s:: > .:<.:.:E 'I;
.....
r. s 2
5 s
J J
m
c? r W 3 0 s r. 2 5 z
9
a
a N
c? . 7 - 3 . T
N
0
2
35 E%
U
ua
6 - ? n : 2 0
I- v)
U E
a: z
5 P
-I
.... .... .:.:.:.: ........ ........ ........ .... .... .... .... :.:.:.:. .::.x :.:.:.:. ........ .... .... .... ........ ........ ........ .... .... :<= > .x.>: a: .... .... [$
:....7
2 2 LL
W U
m
I O a: a E
k
E
m r a: W
a 3 0
I- m
U
IY
L
P
5 P
2
0 0 Exhibit 6
- 7- v
- r v
Ia ~P-PLOO~~~IDNN~-NN-~~~N-NNLOLO~~~~ID~-~PNN~-NN~N~~LONN 5? 8 ~O~~-~~~-LOID~~~NO~~PP~IDIDID~P~~~LOP~~-~-~-~~-~-PLO~ID~~-~-
~mho~w~.~~~-~m~m~~~m~w~m~r-o~r-w~m~m~m~~~~~~o~~~~~~~r-~~~~~~m~m~r-~m~m~w~m~w~m~r-~~~~m~m~ P. m Eij ? "" "7 7 """"TT"""""""" 7
+ 99"~m999m999~N-9-"*mNo9999c999"N~999~99~9o9~"" 2 c9
............................................................................... ;. m z? ~z.a~-ss~.~~s~.~.~~.z-~~.~z.~~~~~.~~~g.~~~.~.~.~.~.~~.~.~.~~~.~.~.~.~~ 6.
~o0m~~0m0mc9ooom~~1~m01~mr-oo~o~r-oom~c9oo~moom~mom1~w o ID Zz b~m~~~-~~~m~r-om~m~~~m~~mmoo~ommoomowoo~moommmm~mm P cn 1~~0ma0~~0mm~~00~~~~~0~0~ooo~o-~oom~moommooc9-mo-oo cu
g I1
8
Wu rmmrrrr NVVNNrrrrrr rrNNrrrrrrrNNrrrNrrrNrrr (0 x p h
oom~~~mommooom~~~~~o~~~~o~~r-or-~oom~~oo~moomr-mom~~~~ m T
~~~~~~~m~rtm~~~~~~~~~m~~~mmmmo~~~~~o~~~oo-mooomor-mmw
c -m -N LO~~LONNNNN----~~P~N--~~NNIDIDNN~ID~~~~ID~~~ m- - m~~u)~o~t~~~~~~~~~~~mmoo~~omm~~~m~-cnmormo~~r~~ LO b
a~~~~%~X~K~X~XE~a~~~~2~~X~~X~~~~~X~~XX~~~~~~~ 2 2 il S~X~R~~~s~~S~~~~~~P~~~~~~~~~X~~~~~~~~~~~~~~~~ 2 5
z 0 7
sz ~~~$8~~6~~8~~~~~~~8~~~~~~~~~6~~~~~~~~8~~g~~~~
BLu ............................................. 2 $
P~~LO~)P~LONLO~PLON~~~~~LO~-~N~~P~IDNL~LOLO~~LO~L~N~~--~~~~ m ID 9~*99-opm9NN9-NTmN9m-99~Tc9-~9~~m~~999-c9-m*m"" '9 (9 $41 IDLOLOLoLommmLom~LOwLOLOLOLOLOIDLOIDu)IDIDmIDIDIDIDIDLOLOIDIDIDu)IDIDLoIDu)u)mIDID m m
rmtw~mm~~~~~~mwcn~mu)r~~mmm~m~~~~o~~~ooo~om~~o~ou)r-m~~
m
t~~~~mmmw~~~~mo~~mr-~m~~mm~ocnm~~ommoommomm~cnmmmooooo m m
999999990999999999999ooo9o9oo9oo9oo9o9o999o99 51 ~~~88888688668886888888~66886688868886886~~66
z31 68~66~8~888888X~~8f~~~~~8%~N~~~~%8~888~88~N~8 Lo 2: N
ID Lo 0 g; 000000000000000000000000000000000000000000000 x
IY
LOooooooooooooooomooLOc9oLOoooooooooooooooooooooo u) VI ~9999099"99999"9999-m"~99009N999c99o9999999999 0, r- fg u).qm~.q~~LO.~qqo.oq~-m.qqmqm~~qm.~~h.b~m-m.~qm-o.qo.~~-qmq~.~q
UI~ ~~.o~m~m~mm~~m~~r-~o~~o~mmu)~o~m~~mm~~mmmo.moo~m~o~qo~~o~mo~mo~~mo~ 7 c
za
~8~M8R~~fiX8~888~~8::~~:~~~8~::~~8::%88~88~8::~~~8 :: ::
rmN rPc9N" " NN r "rNrrrN r N.? r g [$ ID
kt-
K% :z sssgg8gsgss8s8888sshhssss8888ss8sssss8gss~sss 0000000000000000000"000000000000000000000000 8 m s c p z a 331 OoOOOOOOOOOOOOOoOOOLOLOooooooo~oooooooooooooooo 8 E
zz
22
OOOOOOOOOOOOOOOOOOONNOOOOOOOOOOOOOOOOOOOOOOOO W C
m000000000000000000IDID000000000000000000000000 ~.999~.9499~.~.99~.9999~."99999999999999999999~.~~~~~~~. 9 c
LO.o~o~o~o.o~o.~o.P.r-~o~o.o~o~o~r-~o~o~Poo~o~o"~o~o~o.h.o~o.o~o.o.o.o.o~o~o~o.o.o~o~o~o. r-. c WE > -Om"" NtrnNN""" "NN"r""NNr"NrrrNrrr P c:
wo e -I s 2
!i s c 2
ID
mu.
s o m
P 0
0
ID 3 v) I- e
ZP IC oe
s @ s e
0 ee mzz
e mEz2d ma<
m
r- ww 2 e,+s*!&?gg $5 dd 2
$2 2Js;d~o:2:ehdyess7 %-Io_lrn m
m
Smr-
mm
c
r-m u) i$z;$y3e$b 2x N*LOJ-I!? 44, 5 cn-l<J$ _I N e psss e 81 %$i%Z
w v) 55353 ocgq2am o~y~ssg<gzza ~~PZSS<%<~ $~~NJu 00
ID
" 2;$gm Jr.m aJ $s<LJl<<<<po;Jood ,05LZ~~~~ma ztlz sgzg.JJ-I~J: JJ:Tz2 r-sssg2i$$ %gr-ssJoo r- e
Ziijjm'' -.~-o,NNNooemm~~:~cg?2~~~8~~8255~~~~~~~ 11 -
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ O~~O?~g,,r3w3QWW U >
0m0~~~~;2g"gaZeeee<m~ z,.aNm z o'~~cnmmm~~oo~~m~~Z~B~~~~~~~~~~~~~~~~ ,mmmm~ooo~~~~~~~~~ o 5
%-2ma~T* ?WN993nVWa~~wddbw~i%~~mc9W:~... ww,w~mLOL03~~o~~5Q~~ o&.No-w'~~ s
~~~ZZ~~~6a"94ZZZn~~s~~~LOmwsss- ~~~~~~x~~~~~s~~~~~le~~~~~~~~~~~~~~~~~~~~~~~~~ P v -
(DID 2
J55-lJvn-l~~-l~~~~~~~~oo~-l-l~~~-l~~~~~-l~~~-l~~-l~~~~ F Ett~E~~~tE~t~ttttt~C~~E~~~~E~~Ett~tt~~tt~t~tt !! -
bse"o~~~~kle~$$$~s~ee==~ .zzz,gx<go "
C .-Lns\
mQQmmm .~QmmQaQQQQQa~dmmmaQ~~~~maama~mma~~a~~~
21 aa~a~aa~~~uauaaa~uaaaaaauaaauau~aaaaaaaaauaa~ @. c uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu
c eeeeeeeeeeeeeeeeeeeeeeeeeQ~QQ~~~~~~Q~QQQQ~Q~~ r. r-r-mmmmmmmmmmmmmmmmmmmmmmmoooooooooo~.".".-.-.-~~
NL~LOLON~LOL~~~~LONNNNO~ID~-~~~~-N~LOLOP-~~OPNO~NW~~-~~~ zw "22c?"=c=gg=22N2==cgg==ggg===gg~g2QQ=~=c2==NN m-NNmmmmLOIDhho---~N~mm~c9r-oNc9~mmmo--~--~N~mmmNN
e
E: $1 0.-0000000000r0000000ooooroooooo""oooooooooo
$$I OrOrrOOOOOOO~OOO-OOOoooooooooooo~rooooooo~ooo
2
a
g eee~eeeee~eeeeeeeeeeeeeeeeeeeeeeeeee~eeeeeeee
Lu 8488~88~~68~g~~6=~88~~z66~:~~~:8~~8:~~~6::~8~~ : 2
IDIDID~u)~m~mLOmmwottu)u)r-toPoIDLOr-bbr-~u)IDLOLOIDIDIDIDIDwIDIDr-r-h U e
si%~i%i%~~:~~z~Z::i%Zi%:~~~~~~i%~:~~:::::::Z~~~:~i%Z
2
0 0
- 5
I mk2!222!?$?22!?kkkk$& m, ~~.~~~~~.s~s~~~~~.s~.a~~.~.~.~~~~~~.~.~.~. ~~NTQ~CD~CDONQNNN~N -s NQ~Q~V~~CD~NO~N~~Q~~~~Q~Q-NO~VO~
Eij r
r 7" r rrrr"rrrrr"rr"
5 oumm~moau)o~bbbmb
wZmmqb-~.r~r-m.-.m.u-~.~-b-~. m- u).m~a~m~o~~~~~m~~~r-~o~~~~~o~u~r.r.b.a~o~m~o~a.~.o.a~~.b.m~o.~~
~~-.-.~.-.--O.-.-.N-O.O-O.O.O.O.N. - --~m.o.r-m.~.-.b-m-o.~---.~m.~.t~.~m.~-~.m-m.u.m.~-m.m.~-
s~~$gqg~gggg$ggg s s~s~8~e~~~~~~~~=~8ss~88~~~~~s~~ Oum~mmmON-mNNNNa 8 dS~~s~~S~&~~~$&$$~g~~g~$~~z~~a~
Es$gac7z$ggssaaaagx $ c7f~Zf43g36?2$~~s"9~~46~~a8~~~~~8
gz ~JJWNNN~N~NNU------- N- N---N-rNONrrrrrNrNmu)--~NNrNrNr~ 0
~m~~aoob~u)mmommu) m ~~~m~mm~a~~r~~ar~oou)booumuor-oou 0"N"a?a?"kU?W""""-? p: 0"w"o~~"U?s"W"9"-500"s00TWU?0-0"T
b.o.m-~.m.~m.a.r-.o-b-b.m.m-o.m. P. rnu.u)~~~m.~~rn.~.~.-~o.-~~~~~.-.~~r-.~.~~~.~.-.m.~.~.~.~~~.~.~ ~mmmmauomm~oooomm ,,,,,~~=~a~.-~wamaaw~ N ~eg~=s~~84~$~8~~=:s~gg~8~86a~~~
z
&g:g%"s26g$g$!:gg :: .s6~8gR6:S~~8xggx~8~.-8g~~~g~~~~
N !. r N -NNrNr NrrmmNmN-r-NNNUmmammmN
uu!28%k?%86L??24zazs4$ azgg:&g6E::$ggg68& ~$~68R8888$~8fx~R~88~g~~~Za8:~~ ~tmmm~mNmmI."".-" ._ 0000000000000000 866686z8g866866868~~66~88~~g8zz
~~0000000000000000
z *s****ssss***sss g s*8*~*sssssssssssssssssssssssss nu$~8$W~ags~i%$~~~ m r~wru)mmmmoP~mrmomomNmmm~mrommu o&o'&~~oomummoooaooooooooooooooo
~~m~mt-mo~a~comammao lc ~~o~~a~m~mm~~mo~~~am~m~~m~mo~m~
sggsszgl?s;!sFwsg y sxxsxsx$S~8888ssssssss~ssssssss n g"egcgcugz~g~g~~p 4 ag:sscgcgss~~s~~~8s~8s~~~s8~a~~~~
=8&$$g&!2ggg2zgzgg g 6%688~=9$~~8fs~86g8~~Z~~~~$:86~
-7
.I
;$ddddddddd&GddGdd I d GddGddddddddd~~~ddd~dd~~d~d~d~d
~~~~~u~mm~~~~~m~~mu)am~~-mauam~m
NO~O~~N-~~~O~~NO~~~~N~N-NN~NP~N
0000000000,0000.0.q 00000000000000000,00000000000000 0000000000000000000000000000000
~~~.rn.~.orn.q~q~o.-~~~~~~ m. ~~m~~r-.myqm~~o.qm.mrno.~~~~o.o~~.~~.~~.~~.~~m.
~~o~m~~mm~m~qo~o~qqqqmq 0. qm~qo.o~q~~~.o.o.o~~ma~o.o~~o~~o.o~o.-.m~mm.mo.
24 >EN-- - rrurrrrr r 0 r rrNrrrmN--rr NrNpmrrrNN-r - r m +r- wz ;I gsssss$$$$$e$$s$ gggggggggggggggg G 8 8~~8x~s~s~sss8~ssss~~~~sssssss~ sssssggg~g~gs~~888g8g88g8g8gg8~ E: q3p888888888888888 g 888gg8886~8888Xx8888~8~888888g~ w00~0.0.0~0~0.0~0~0~0~0~0~0.0~0~ 0- 0.0~0~0.0~0~0.0.0.0~0~0.0~0~0.0~0~0.0.0~0.0~0.0.0~0.0.0.0.0.0.
w = ~~o.o.o.o.o.o~o~o~o~o~o.o~o~o~o~o~ 0- o~o~m~o.o~o~o.o.m~-.o~o.o~o~o.o~o~o~o~o~mo~o.o~o.o~o.o.o.o~o.
>NNN-N-NNP-----~~ o ~rrr~rrNmNrr-rrNrNPm rrNN-N-N-r 0 E'; k8 22 2 0 t - , Lu 3 m -1 1
au) am 32 2 2-!< ",Vm ss a i V&
r- w,qoqUze!! 3 41 ?So q& $s
p- a jgzzg;2 a$$ zzga+4z e $?22g!?Z JOJ mu) J-lzVg2;;$ 2 - 6-00
>I bbb 3324yo0z<5;4
hh$$$""""m $ =;,$$2pZac, YAZB oozgggzps%oaz ;r-e?e99?????????rn ecP&bbb""r"'om bs 3ezo21asgyP~$: ;;;zzroo= oomOoO~b~~ "O
u u)a333"mmmmmmu~ ~~bgzzwLuu~m;~~~s2semm m"""mPP2ggs$s;g;a$
Wzzsss333333333- 3 ooonnnnnnnnnw ~s%s~~~~~s~$~aS~x5a%~~~~S..mw6r ng mnm ssm,+Tbm~ aw~~rn~=~~w'XS~~~
*.zdddmmmmmmmmmO %Ws$$$$$yyyyyyss ,,wnm=w",3Wwno,R,,,=~~~~~~~~~~ r-w3+~~addrn,,msW,~$,, ~E~~~Ro~~I~~E~~~~~~~~~~-~~~ u)mm+++++au)au)aamz *0"~8am~~9gs~~~~~Ess,kk~,~~a3Ra o$~$u)N~:$z5 &&&44$244&&t&Z&&; E$"W
mmmmmm*mmmmmmmmE 3333333> o+"Zr~~gg~~~~~~~~~~~~~~~~~~~~~~ aEL52uo
$$$$$$$$$$$$$$$3 ,< z"~~~~~zy~~~9~o++~~~yo mFcoJ EFEEFEEEEEEEEEEZ ~~~s~~~~~x~~~~s~ayss~~~~8~~~~8~ ooa~~ w~~oiiw6zo3
333333333333333+ ~9~~s~e~~e~s~~a%%aaa%4~~%~~~~%~
2,,,www"""Q""?.?""- ?w 0cos::wlnz
~~WW~~~WWWWWUWWW~
ossmmmss$?$$SSSS3 $dSjoS =~,,mimsw~~a3NNcm*m=w NNuFnm3 m~nz3<~~mn32Zec2
333
mmmmmmmmmmmmmmmE
~EEEEEEEEEEEaenaE t+kk+kkkk+C++++++ zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz oooUooOoooooooooooooOOOOOOOOOOO I
bbbbbcmmmmmmmmmm ~~~r-~r-~mmmmmmmmmmmmmoooooo----r
m00"""""~0~ c 9eeeeePeeeQeeeee ?~~~~~?~~3~~?~~~~?~~~~~~~~~~~~~
~aoo~~~~~ooo~~~~~- an
$~g~==9z~88868~888~~~~g~~~8g~6~
c 88888866666666Sf z 3?jGaziasaaG:GG+zG ~~~~~~~~~~~~~~~~~~~?~~~~~~~~~~~
=Fggg6g&gzggggggg6 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Ea
"ppz~$$ssssss$:
Li 41
"==BB=Q=====gN=g~BaN===g$=ee=
E
u)~u)r-u)mdr-br-~mrnauu)mu)mmmu)~amau)abu)b
BBQeQ=B=B=322Ncc
OOOOrOOOOOOOOrOOrOOroooo-oooooo
z
@
z v) E. N ""7
?ij -
T omoao m m
I- in "(D(D0 r 0 '4 "@!9"9 t t 5: 8 LO-Lnmr- 0 m
2 L ;. - '9 N. -. 9 0. gw
E./ f 8LiZSZ z % r-.m.-.a.-. N. N.
"""d a 0 2
N
I1 c
z
r- -IC000 r 0 f y-.%a?X 2 2
m mlcmmr- m o m N m m 7. 7- m- 4 N-N 10 e
". z -. %
UP (~7mot-m 01-omm
51 $3 r-mrmo v)mumu
$21 9 8ZZS8 e z
$2 "1 i Q.y.:. 5 z-
ONulrnrn OONON ;< X8XXX
z s sssss s s wLw 9 moo00 oommm 8 8 $;l z ",%$?Z %$ 2
K
IC maomo m m - kook9 "
Oh z XFiZ88 : ; r-. 0. 9 ". 0. 0. rn
m 9 ". -. 9 m. -. >E z4 L? -Fa: w 5
&$ :z f$ & Z. gggqx 3 4
2s a8 .u, a
o maomo m (D
o u(oomo u 9 kqqkq u? 2
-0-0 m u
ul " "rn
J-I
Za 6 4s
L F2 an 3 32 m ma [L (3 I- z 3
0 0
0 a ! !I-;Z 5> UZ
a :: v)
YZZZl 40LUv)
Z~knll:
00
$%%SS c335;8 Z$lES sa?::
9s::5 A[L---
UI 21 00000 +
> 5 21
I - 0
a
I- z 9
wUI E 51 0 0 E
> U 2 z - r -
0
0 e Exhibil
Reconciliation of Fund Source to Investment Portfolio
As of March 31,1997
Cash Balance by Fund:
General
Debt Service
Special Revenue
Capital Projects:
General Capital Construction
TIF
PFF
Park Development
Other Capital Construction
Carlsbad Municipal Water District
Sewer Fund
Solid Waste
Golf Course
Total
Internal Service
Redevelopment Funds (1 )
Agency Funds
Misc. Special Funds
Enterprise:
24,735,270
27,789,834
89,614
2,612,807
17,460,336
2,927,901
5,466,818
3,000,976
12,980,138
13,114,932
4,439,747
45,874,796
55,227,525
10,624,702
8,971,513
0
Total General Ledger Balance 180,089,383
Amortization of discounts and premiums
Deposits in transit
Outstanding checks
Wire in/(out) not recorded
Other
Net adjustments per bank statement
118,879
202,061
Total adjustments 320,940
Total Treasurer's Investment Portfolio 180,410,324
(1) Redevelopment Fund Balances are interspersed throughout all funds.
** Figures based on best estimate at the time report run on 4/24/97.
e 0 Exhib CITY OF CARLSBAD INVESTMENT PORTFOLIO
AS OF MARCH 31,1997
CORPORATE NOTE RATINGS
Investments Meeting the Current Investment Policy:
(Ratings must be AA or better by both Moody'sand S&P)
Moody's s&p
ASSOC COW OF N A AA3 AA-
CAMPBELLS SOUP AA3 AA-
DETROIT SEWER AAA AAA
DUKE POWER
FCC NATIONAL BANK
AA2 AA-
AA3 AA-
GENERAL ELECTRIC CREDIT AAA AAA
KENTUCKY UTILITIES AA2 AA-
NATIONAL RURAL UTILITIES AA3 AA
NORWEST AA3 AA-
PROCTOR & GAMBLE
ST PAUL CO
AA2 AA
AA3 AA
TOYOTA AAA AAA
WAL-MART STORES AA2 AA
Investments Made Under a Previous Investment Policy (Ratings must be A or better) Prior to 2/13/96
Moody's s&p
AMERICAN EXPRESS CREDIT AA3 A+
FORD MOTORS CREDIT AI A+
SOUTHERN CALIF ED A2 A+
Investments with Subsequent Changes in Credit Rating *
Maturity Carrying
Moody's s&p Date Purchased Value
DIGITAL EQUIP BA 1 BB+ 11/15/97 A2/A- 1,008,653
DONNELLY A1 A+ 12/01/00 AA3lAA- 1,113,035
UNION PACIFIC AA3 A 03/15/01 AA2IAA- 1,999,542
* The City's Investment Policy allows the City Treasurer to determine the course of action that would correct exceptions
to the policy. All 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.
q 'ITY OF CARLSBAD INVESTMENT PO d FOLIO
Ex
AS OF MARCH 31,1997
PERCENTAGE KEIGHTlNG!? BY CORPORATE NOTE lSSUER
Investments Meeting the Current Investment Policy (Percentage Less Than 5%)
Investment Cost Percent of Portfo
ASSOCIATES CORP NA 7,041,136.00
CAMPBELLS SOUP 2,062,700.00
DETROIT SEWER 1,014,980.00
DIGITAL EQUIP 1,053,390.00
DONNELLY 1,145,610.00
DUKE POWER 2,048,020.00
FCC NATIONAL BANK 975,690.00
FORD MOTORS CREDIT 1,957,160.00
KENTUCKY UTILITIES 2,024,340.00
NATIONAL RURAL UTILITIES 3,019,970.00
NORWEST 5,066,190.00
PROCTOR 62 GAMBLE 2,256,561.60
SOUTHERN CALIF ED 1,000,000.00
ST PAUL CO 2,042,260.00
TOYOTA 5,530,503.57
UNION PACIFIC 1,997,320.00
WAL-MART STORES 2,491,325.00
WISCONSIN ELECTRIC 1,000,560.00
Investments Made Under a Previous Investment Policy (Percentage Limited to 10%) Prior to 2/13/96
GENERAL ELECTRIC CREDIT
Investment Cost Percent of Portfo
9,108,300.00
Total Portfolio $18(
e e Exhibit 10
al 2
0 mm .-
-0 - 0“
8’ $5 5 E
t
E
co oar ln X3 c.
.I-
.- U
i z
m .- E P
R m 0 L -
2 k ._ e U
7 N
l” m
”!
m .-
P E
R m 0
0 L - In 2
e ii
k
m W
00 l”-
7
C 3 c
’E)
m
X c z
2 Zi
3 3
c
v)
Y 5 m
e!
c a,
tj
iz
a, m c
0 K N
(0 N
‘9
Y 5
$
m
c
tj
iz
a, m 1
6 2
.- m E -0 - m 0
0
ln
c
.I-
C
t
E c .- U
.m .m .m .m .m .m EEEEEE
333333
EPPP+oe
0- I- 4- 8- 3- I-
000000 LLCPPPLC 000000 ””IC InInInmInm
ktktkt 222222
e ,E ,E .g .E ,E iiuuuuu
ooouoo
omum-w mmCONCOw 999599
“ ‘p. m- r- 9 9: mmmmmco uwrnrno~ NN m
.m .s .E .m EEEE
3-5-33
e+++
I- I- I- 1-
0000 LCCPLCL 0000 ”” mInInm
tktk iiiikk
2222
eeam
0000 X??X
NW-0 m *- “! *- mmmo mwo- ”
.m .m .m .m .m .E .m .m EEEEEEEE 00000000
m-3mm-3-3-3-3 zrzzrxxx
0000000~
-
00000000 LCLLCLCLCLLCL
”””c InmInv)InmInIn 22222222 tkkkkkkk aaaaaa~e kkk5kkii.E
00000000 $~~=?~~X!
wl”w.-m.-l” r.-cu”m”-rurn mdmm-t~~ “rN0“N ““,-N,-
0.“ ONW 0 0 woouoo mmoo oQ)om*Woo
m N 0 9 “! 1’. os: ~%~??~: u??~~ 4p!z$?C?z m1-2 .. w rn i; 2-
::a 5N m In 5 $$-gg-z$j &gsz Eqggf:;;;
02 P “2
-wco~bw w-mo l”mcommmrc I’. i; m-mr.co-u- m-m-t-”p- o~w-m~o~m-o-m~
C=-
NN m ” rrrr-N.- - m - m 0 m
ln
U LL
-
5
B
ln .- P .- U .-
orm .c. 0 0 000000 0000 00000000
uz
04s P
z
8- G- e 9,9 999999 9999 99999999
6 2s g gkz 4 8 888888 8.882 888888f?v
L =alb mti 2 25-
2% e
n $a l” l”l”r.r.r-
- m ‘4 cn k 99999” ”999 995999m. m ooooo(o 0000 Om00mmN N m mr.00-N 01-wr NVmrrmN m NN”m “7 .?““N.- m we
vu
r.l”l” l”l”r.1-l”l” z 3% z ga esi 6d> F ZZQ ez4eC!z .E92 Q22ezzz-
r. ggggg ggg dddddd 000000 5
f mmmmm sssi-a6 gzsa mmm “““ mmmmmm d mmw-r.w~,O .zz 02
73% 2 E3 s 1-35 $$e s sgss.O.O -?-? $000 sss $000000 ssssss asg ms 2 r-: W Lnlo *mUJ ummuum zqzz@?? ZCS?? z5rnqcqqq
uu e‘ 22 c
a, m B ._ .- - m m
$$ In E a Bo
am $0 g E; p@$ 0‘
0000 of
tt 2 z c - .e+ ”E.= E;
Y (3 .s .s ;;E 5 an:; 5 ps 55%; r’
a, @V.S 8 $0.2 8 866 $s.p$
E 1 mmg .H 5ZEE EgEg mr ZZEEZZtlE
c goo ala, sf??:; 25:; 2SkkTf;s tEEEdt tEd2 ttZZEEt2
am 22
grr
%I 3 52 - zg p zg zzzz cn
S Q,
c
gEG
3 E E t =:: 00ZZ c - g- =
- ob2 3952 uua
- szo Em
uc V
ca
Uc au
cc
V :En c V $E; r U a zagu, =Fig s a, 2 E =>%iz 9 ‘E g U,BS2 <EEL$ ad B -
a m -0
U
e al
V
n z;; U 3 U
3e
a-
c 3 -
- - % % m a -
8 f f f 5 r r r E rrrrrr rrrc rrrrrrrr
I POP W 0 PPPPPP PPPP PPPPPPPP
0 d)
k* ma (Do (Dm 22 (30
.- m f -0 - : m
0
a
!-
c
t
E to .- Y
c
al P - m u a E
.- m
E -0 -
2
c,
m
0
u) c
2
e ._ LL
.- m
C L. e - m g
L
3 L 5 e .- LL
c u)
1 E
a,
c -
._ 2. -
0 a,
U
.o .o .o
(I)(I)(I)
881
$$$
PPP zz$ 333 LLUU -
.g .g .g
c .= .= u)aa -1-
~az
Sf& 223 aa4
4-
2 c
.- 2
<E
._ 6
a
\L Z-
._ c
L L
S
In - ._ 3
C
2 LL
mo k?? .; ssa .g ma x R y& 5 zcg In a r '9 ". 5 " In '4 E 3-
2- % 2- E ; 2; -In rm
@i SN X m m E
m 0 a0 2 R L?? Fge ow ?? $?s '4 m. i; In- In '9 i; m- m- tE: v) 7 (DL0 atom
r,m kln :a g 2- E f 22
N- 4 N d m -- - m u a
Y .-
- - m 0
LL
a .-
0 00 000E ESZ?
eeag
0
ccs ZjpG
22%; 12 c E
-
zm 2 a,
C c 3.k .P .e E 5 "-E zzga =&AI 8 8 22 5.5:s
mm
66S6 zzzz
mwmr NNIOrI Fjdodod
m- '3 &e '4
m m- In a- -m
-"N(n
882%
I- a
H %
m 0 (Do mom
In ma ah0
2 z 2: y.2 90! am z:v-& 2- z-
oa mtomr
mrn r '9 c? L". In '9
0- k
"Nrn m- r? r? '4 marnw mlOlnRl m m- rn " -m
t.0 -2- " N N
rm coo r,ln In.-
6 2 $6 666 m
z c zz zzz E!6
0) 2'
Sa ml 9 st $95 ga
In m
0 0
4-8
2. 2 c
0 a
u) m
c p!
6 E .-
Q,
ii e
c
m 2
3 5
u c 0
-
m
m 4
I
?5 (I) 2. l&% 5z
u)u)a mmm
$$$
L?!Pp! +e+ tkk
4z2 = aaa
e++ CnrncO
m
Kc m rn - 9
s 8
5
$ E
- E
K
m
b
._ 2
3 40
OE
LLU- 0-
"Is LC"
5z ef OLL
E 0 mz s css
c r uz -7 6 cs 8 2
.I? 8 8 .U .- s $5 p 2- i;i 0 2 2 $ zp $ zE - :: ; !$.! ti 5 OQE b- SF z $! $j .E z Ejji E ZL?; gbbEp2E al $jg
r a a
u 8
8 5 5 $5 t mmm I 0) s.Cs 22
c 3 882.g
6 6z g
23 E;
222;
35:z
88
55 m E 22 a, 0
m3 2 a, -
er
z"z",a,= La,
==d!y 8824
u) a, a, - 0" gg
g sggg
go00
E w322 g +Hma,
al 5.555 E ssss
0 SSfS
2 aaaa
P LLLLLLLL
u cncnrncn
L mmmm rrrc
L
0"