Loading...
HomeMy WebLinkAbout1997-03-25; City Council; 14097; REPORT ON CITY INVESTMENTS AS OF FEBRUARY 28, 1997I sb 9 3 -j CIT F CARLSBAD - AGEND BILL AB# jwL MTG. 3125197 TITLE: REPORT ON CITY INVESTMENTS DEpT-9@ CITY APT :& AS OF FEBRUARY 28,1997 DEPT. TRS CITY MGR: s CI u > 0 E a a, < ~ ~ ~~ RECOMMENDED ACTION: Accept and file report. ITEM EXPLANATION: The City’s Investment Policy requires the City Treasurer to report to the City Council o 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 February 28, 1997 is as follows: Investment Portfolio (Cash and Securities) Current Month Prior Month Par Value 176,297,14a 176,759,055 Market Value (2) 177,075,807 177,761,595 Book Value of Investments (I) 176,066,286 177,924,446 Cost of Investments 176,926,421 177,550,474 I I I (1) Book value is cost adjusted for amortized premiums and discounts. (2) Source of market values is Wells Fargo’s custodial report as of 2/28/97. Interest Income Current Current Income Month FYTD Month FYTD Month Prior Cash Income Fiscal 2,190,076 6,704,694 8,894,771 Year-to-Date Total Income Over The Life 24,916,180 24,982,172 Of The Investment If Held To Maturity I I 0 0 PAGE TWO OF AGENDA BILL NO. I q; 0 97 Investment Performance Average Life /Years) Average Yield December 1996 5.75‘ 1.45 February 1997 5.74‘ 1.41 January 1997 5.75‘ I .40 I I All investments have been made in accordance with the City’s Investment Policy adopted Jan 2, 1985 and last revised September IO, 1996. All investments were initially made in accord; with the City’s Investment Policy. Events subsequent to the purchase might have resulted in s 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 0 0 Exhibit 1 0 cl El z h 0 a E-r rd c3 P E 2 % 2 5 F Q\ z 00" c1 E 2 E 8 2 c n I& 0 =: G 2 8 E! s s E @ g 8 6 3 % s h Q4 4 a P P % % 4 k 2 s E 3 0 & 0 Q4 h E 0 Q 4 Q4 5 Jx l L n s .2 dE 3s dg 55 8 4s 2 ii2 8Q A$ 52 5s 6, fo WE 4 "k .I +k i5 si * 5 3 23 L 9 l 5 .; 23 3 & 81 6, Og WE B 5 Y L I1 s . c z 3 z 0 0 0 0 0 n u 0 0 9 3 8 ?. - 0 0 0 0 4 m 0 8 0 -. 0 c 0 0 0 0 0 6 00 : d vi r- d I.- :- 2- m 00 m P I.-* t; I.-- N 0 N 3 3 03 N I.- I.- :- 2 I.-" N 0 0 3 2 00 c-4 E 00 x d : 0 d 0 0 ", 2- 00 vi I.- 00.. t; vi* W I.- I.- 3 3 00 \D W 2 vi* 00 :* W N 3 :- 2- o\ \o 2 W 2 I.- 2 0 0 x m 0'- 3 W 2 vi- N* vi W d 00 N 00, d I' "! s W 2 m- N 3 d m vi :- 2 \3 M u z 00 x 00 x m vi W 0 I.-, N 3 N m 3 3 \D m * 0 I.- d 00 m ", 00, N m :- 3 \D m d 0 P d m- oc, 00 m b s vi 2 vi : d- 0 :- vi co o\ 3 m Q', 3 I.- 00 2 vi Q1. 3 00 m 3 m Q', 3 I.- 00 2 vi ? 3 B 3 tn -1 2 d- :I 01 51 co ?I s ?\ co 9 0 I.- m I.- M u t-. 2 E 3 s 0 d 2 s ". M 3 vi 3 I.- 2 2- o\ 69 0 5 I.-- 2 o\ 2 69 m vi 2 3 vi 69 t; I.- 0 E- 3 I.- 2 69 vi o\ W* 3 W E- $; 69 rn Gl 2 z 0 e Exhibit 0 w k;l i5 k 0 c3 k 6 3 d E% EE 5$E 0 2 8 e c E gg @ 2: Ei Hz wc nh 3 u a e 2 0 2 g k 2 T 8 & E9 s E 4 8 k( b 0 Q S?gggggggS? 990.9c?\409". S? 2 2 obommC-3336 "I 0 3 3ccINN E XJ 3 s 3 3 * 0 H vi m 2 2 g * 0 w & 4 E rl E X E 0 0 0 0 0 0 0 C 0 0 - - e \o m :* d 0- 0 N 0 m e *, on m 0 H 2 5? ? z- N * 2 N- m z \D o\ * Zn 2 \o 3 P m 2 :- 0 m !? :- IA x 3 \o m % 3 m 3 m W d 3 x d i 0 m 2 m 3 e 00- s so % P 3 * 0 2 2- d m 0 0 g !G M 2- m P 00 2 In o?. 3 0 0 00 b 2 In % 3 !{ 0 10 01 01 !?I 0 In \o d 2 N I.- 69 Q', 2 lr, OI :* 3 3 m- 69 m 0 z a" m! W 3 m 69 3 F 3 e *- 3 69 o\ 9 2 ". s 2 N s 1 m 3 6 S s z E&% m3 u m b 8 b 2pSf3ELb~ 2 c;l 0 * e e ExhiE z 0 4 0 r) d P4 m 2 3 n F F4 cl ? $m t\ m F4 I 78 4h X' w: 22 E- 85 & 0 h mCVr(DQ,00r+(Dm- a cdcdcd Ujuiuiuiui e 0 Exhi d) E 0 0 F1 A H s 0 a > 6 a1 w 1 E' 3 u m + 3 8 0 0 L r\ m 0 G $ c, 4 I " - - - r i - - L 7 - 0 S 3 7 >r ii k a 2 L 9 aa LL S a T 0 p" 8 6 Z * Q aa cn 0 z D =I 7 e 0 Exhib c mo~~omoom I~NOU)~ m-NNr.0~ o mo mom mom X?X?,=?$ZFZ v?@?ZX f%%XZZZ g- - 2 P -"""~C?~"~.r" N."".".". "N.N.O"-.'C.O- >- g (D k-2 ma Z-2-Z. 2-2:- 5; rooo~mrou yy&$.ez.%;. %y?z.z. O~~NN WJ-~.W~.S ~mmr-mlra &X 2s: :x9 000 s :I LDLDPONWOO~ mommco vgNm)mor w 100 rom mot- Z$ vr N mcoz boo - ". "N- c in- N' x- - rNNNr Nrm rNNrr rrPrrr-r " N. rr ZdN rN)m x- - mo~womoom h~omm mu~~mo(D 0 0 n 00 mo mom mom - yXz?$xz$ y??ZZ $;w?zz r &Z y?: 222 ? wmororobr- mummm mno-o-m 3 hm ohm -ma m m-m.--m"-m""-m. o""".m- (9usrzo-m-qr?o- I4-J lcommutrcmlco mmwmm a.-mam~.- N- '9m- """ h-rqrn rJ mm wma awm 0- c x 2 z- el NNrrrWrDDO OmmNN rmUL9hNW -t -- 5 - c "rrN rrN NrlOmm mNN x-m N Ri: m-o 7- -Om rn" tn T- 7 - r Eo sssssssss sssss sssssss g ss sss ggs $i K sg- ooooooooo m-oom .-ommooo o~mmrnl~hmo ummoo mumomm~ LD 70 000 &szgzz$z$ 8z&-?z zz$sv?;g 2 2 z om mmN m-o 1 2 0 s ZI 2; -??% ;-?2 hCB 000-ooooh ooooo OOOOQON m 8xzzzzzz$ y?Zx 88%?=!2% g 22 y?z sa!: 00 000 000 000 * g-z-i%.E.s-z-z.z-L5- k-$Z-E-E. %.Z.2-3-2.?-Z- 5 mm -No Lm[: 1 ; E- :! umm~)orno~u mmmom ~~mmmhm L- gz kc$& mhN O- O. a- N. m- b- Q.Q- EO mmmmrmo~u mmmom ro-~r-uo 6 rnm-m.m-o-mo-com- mN.m-0-m o.o-o-o-m-.o- m 0-0. m.0-m- z-z.c& 2 =I, ON -"r N m N" "U.- " rx- rmr s g 0 t + sssssssss sssss s**s*ss oomooooom 00000 mOmoOOm OONOWOhON (OOmOO UP-NOOON gg sss ggg y?F!z;$wz; ~~;~~ X!Z?%zZ 2: 2:: ;X-? 11 000 QO COON WNl. L bo g 2 r. Y) 0 000000000 00000 0000000 0 000000000 00000 0000000 0 ._ c 00 000 000 g-2-g-z-g.g-g-z-E- 2-g-z-z-g- g-z-g.g-gz-g. E- z-z- z-z.g- g-8:. 2- z. 00 000 ;:; l 00 ooa 00000000~ OQOOO OOOOOhO r ; 2 c7iil Lg zKzRz"zzX z2zO.z zzszs$z 2 00 OQO 000 00 " N-N NCY 0-0- 0".9 90-0- 9 9 v> m 6 d $2 k n a! YI : @I 0 8ZZZZNNZZ gzzss g -zzzzzz zz zzs zzz h %<<<&%<< %<<%% 2<<<<<< 96 <<% 66s 2 0 8 hr. m mm m m h - 88 N G 2 ~ 2- 08 5 $;Qmrn r. hoz2c z-rmm h J% $2 2 m <&ig osn?? " y i 2 ogaz gag85 Jzqsidg !2 5 gi: 8m:Qzgav: s-zmaa- hw r &@ :'= 2 m -I ha mO am -I x 3 J &yXff 22 5 h % ,4W?OW5W -x-~~aZx S:~OO *5&!s "";;j:d2s ?x z 5% J EsnQamo n <SFgg H~~~~~~ 50 g3 wzy J 5 mn.gre0s ?$ $g; ggg 2 Xs,,n%==, sgJaa z+2asz I-0 wF& : Wc9 7 ,>o>gl-3yo 8cdww 2z 2~8 gn> 3" W c ii nK+Qzo& (603== &Www $og222g W *K 2 LL s&&FE-?z qgag$mkb &:e: coam? cuw2gg2 ZA y$ $24 E 9 s?!? =%&a In i- 3om"$ zsgzz Z4Zoo4 8; Y)p 2 l- $$?Errsyg ZOFZZ 4hEP33E ww $2; E:$ . SEan .'C 9 W ? m . 4 u) mwsLSyggs obi00 qy,_loo sg 602 sen m Bx%xwnsQz QWF$$ mn.-nxO~mT m-~xNN w Nx~$% 6 7 umrrBstiwmLY 3 ? m l- ml. N 0 I1 9 S d2e2eEhhe tEStZ hk2SEh2 ow ul-u au3 h 4 <KzKzaaaz u~ol-~uuuo i555i5i5 S5E5SSE 55 SES $SF c h mmmmommom O~.-NN rrmmoom 3 eo mmmmommom omooo oommoom IC hh $5 G&g 222 = 2pl gg$gs4~~~~ 9523gj ;;;;;;; Icm"Qm7 m 2 Q 0.- :!2g 5:s ..m mn a:::s;;j:s: 000000000 88288 8528222 00 888 P fjz ICP"P.P-ICICICP-~ ~IC~CICIC ICIC.'C~ICIC~ m n g2g?g??g$s$ $!$S!$$ 22e9922 z 32 g3g g?g2 z sz: r.m= 88888 mmmmmmm Sg SSR $5S fj Sfjt 0000000 ; rnE Q .. " mm PO B 7 c c NN WN(D NW~ m cc g e jil eeJ===gQQ OOONN egpqqqq $ u. z mm(DOONu .."?""" 000000000 00 000 000 I- P Okk eg 25 3s % !?~?~~?~!?~ eppep eeeeqqe 0 B ..... 3s .... bg ........ ...... .. .... X mht.hhhhhh hhhlclc l.hr.hhhb :..::.a c sh u SSU P :$?a 2 3: $$$ $?$$$S$!$ 2;pJs sxsssgs n .~~ .+:.x. :.:.:.:.: $3 g .:.:.:.: 2 $j$; E + %s .. . . a 5 g> 2 g =;c $+ z m 5 ij:s K 8 i & :.~ .-hmmmmm)~m hmuoo mmmmmom $ a: ..... 2 6 ", 3 -00000000 z 0000000 & :.:.:.:. us 4 e .* . ........ - . ....... > .... $j.' -3 ?% s I :.:.:.:.: .... u :....-J I 2 e 1- i: a P 2 E $1: K I 2 I O :a a ttl 6 I 2 0 0 Exhib - v 7 - 7 v B M ~~~~~~xKa~-o~as~-~~~~-~~-~-~~-~-~~-~-~-~~-~-~-~-~~-~-~-~-~-~- ~~m~mm-mwm-~~ww-~~~~muumwwowum~~u~~~~~~~~u~~mw gij - rrrr rrr r r~"r"rrrrrrr-r"rrr I- z wz E $1 sK c 11 I- z o~~om~-~~mommooom~~wm~wm~oool-l-om~mooumoom~-mo 9oorn~qqoqrnooo~N~w~~~qNooowwo~N~ooqrnoornwoo ~w~~mm~~~mm~~~o~~rw~~~~~oooow~om~moommoom~mo ~~~m~~~-~wmm~-~m~mw~m~~mmooo~momomoommoommmm "w"~""9~~~~m~~UJ~l-~~~~"~~~~~~"~~~UJ~l-~~~~~~~~~~~~~~~~~UJ~~~~~~~~~UJ~F-~~~~~~~~~ w~~mu~~~-l-~~~u~~w~~mm~-m~ww~~w~~omm~mm~~rn~~rn~w~ ~m~~m~w~-~~m~~~w~~~~~~~~~~~rmmmmwuoommou~omo~~-omm r- UJ- -. N- 0- 0- 0- N- l- m- m- w- UJ- N- r.- N- N- m- r- 7- v) UJ N- N- u- u- N- o- m- N- m- w- w- m- N- m- w- N- m- m- w- Nrmmrrrr NttNN-rr-rr rrNNr-r-rNN-r-Nr-rN 000~~~~O~m000~~~~r0~~~o~o~~o~~moo~~oo~~~o mw~~~~m~-~m~owtwto~~~mmmom~~o~~oo-mooomo?- ~~~"~N~~~~~Nm~~~~UJ~F-~~~F-"~~~F-~UJ"~w~~~w~~~UJ~~~~~~~~~~~~~*~~~~"~~~UJ~F-~~~~~F-~~~ mum~m~o~~-ouu~wm~l-l-~~moo~mwl--wl-mmmm~mmu~o ~m~~~w~-~~~~~~~w~~~~~~wr~~~mmoow~om~wmu~mmo~mouu ~X~XG~%~X~R~8~X~P~~~~~~~8~~8~~X~8%X88~~~~ r rm FN UJ~~UJNNNNN--~~OO~PN-~NNWWNN~WN~~~ z ~~~~~~~s~~~sss~~~~~~~s~~ss~~~ssss~~~~~~~~ ooooooomooo~~o~oooooo~mowoo~~ooooooooo~oooo ~~~~UJ~~~UJNUJ-~UJN~~~~~UJ~~N~~~~UJUJUJ~~UJ~UJN~~-~ 9o"~w~rm~oqNNorNqqNoqrooq"mmww~qrooor~r~~ !i 7 $2 mwmmmmwmmm~mmwmm~mmwmwww~wwwwmmwwwwwwmwww !Y omooooooooooooooomoommo~~ooooooooooooooooo ig =~8S~~X~%A888X8~~~8~~~~~8~~~~~~s8X888~8~~ 9?-.~.o~.o~.o9~4ooo~.~om~.o~~~~ooo~.ooo9~.oooooooo 321 moo~mm~mmmooomommmom~ummo-mr~~-mooooomomu ~ro~l-~wmmmooomowm~~o~mm~~~~ol-m~mwl-mowooooom~ m-m-o-m.m m m m w m-u-r-o-m-o-m m w-o-m u u m m "0-0, m m o~o~m~o~o~o~o~o~m 0-m om ~~~~~~RN~~~~~~UJ~~~~~~~~~~~~UJ~-~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >z rrmN za -ummrr -7 NN r"N-rrN - N I- oa kg xxx88888x88888xgggx8~~8888888888888888888 w3 8~~x~~~-~-8~-~-~-~-~-~-~-~-~-~-~-~-~-~*~-~~~~~-~-~-~-~-~~~-~-~-~~~-~-~-~-~-~-~- 00000000000000000000uu0000000000000000000 w 00000000000000000000NN0000000000000000000 0- UJ. 0- 0- 0- 0- 0- 0- l- 0- t- l-- 0- 0- 0- 0- 0- r- 0- 0- u u 0- 0- -- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- g 5 iil ooooooooooooooooooooUJUJooooooooooooooooooo 2s > Nrmmrrrr NlC9NNr-rr-r .?rNNrr-rrNNrrrNr"N +PI ww ZL I-co WLL Y)N zm 2: a > p !i :I $ 0 0 F m vi 0 L c &I 8 In a s P '9 m % mm !YY ," g IC . m gg F- $5 bWWW F- :g:sxeglT)gl $9 22 2 8 8 k i btj; qi3>wlriGMFjzb s3mdd ?-VAN 0 (D m JN~~J-~... ,,5zmL-rrr~F-~~3aa 9mSS YS?~ &, $E ii2zBg oa ~s~a2Aag+gd~~~~zz j~lJ~,w,~ bssme~ mbms ZOS~SC O~C)~O~O I I ,OmZaa I I ;3am OUOQ~WA~~~ a5zr)ygaa:j oaa~~~ zwsN~a mu-&a~ ~~ss~~mz~4e~d~ssss~~~~ss~~~~~$o~-O=~~ Oa8-r-riAOg; zj$O m~~m~~~~"~~0~~~~9O~mm&&~:mg~~~~80 CbNm m3=5.?.?mUJ~~a~~~===zjs~~~==o~mUJ o~~o~~ooZ aaaP 25 wNrN~&W-~W~W~Wqq~WaN~~mm-W~~=o-O~g~~~~~gW --WO~<N ~~~~5~~~~~4~~~~~N3UJW~W=== wwW3w o$!$o~~-gsg-~m3 q~03++q~z,Fq~orrro ===ooo~~~~~~g=rF=Nzjg80 ~zh~~~~~~~~~X~~~~X~K~~~~qo~oUJ~~b~~~~~w~w~ lnrol"UJklkl+jdO UJh"UJUJmF-wOOw"=~wwww~wOl- 9 5 SBm aA,O~WiAA~Nm~ 700 Im-O2,ZU:3 ~~sozz~n~~a~~~~~~~~~~~~~~~~s=sUJgq~~~b~~~~ os.?N" 0 mmaarnmm .~ammaaaaaaaa~~~~mmama~~maamaammaa~a 2~IIAAOqA~AAzszzzzzsOOAJ~JzAA,~~,I~J,~~,~ IIZZII~-IZIIZ~ZZZZZ-~~U~~~~~I~I~~~~~I~~~I~ UUUUU~U~UUU~U~UU~~~~U~~U~U~U~U~UUUUUUUU~U !I uuUUUUUU~~UUUuUUUU~UuUUuuuuuUuuuuUuuuuuuu aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa c ~~-l-mmmmmmmmmmmmmmmmmmmmmmmoooooooo~~~~~~~ PQPQQQBBPBPBPPPPPPPBPPPPPPFF~~~~~~~~~~~~~ m~~~~~m~~mmm~~~~~omw~~mm~~~~u~mF-ou~ow~mml- =egBg~F=g=FF=gccc==g~~==~~F=F~=F~~~=F=gg= mmr~~mmmm~~w~-~-o--r~~~mmmmol-~~~mmo-r~rr~~~rnm 00r0000000000-0000000000-00000----0000000 wwwwwwwmF-mUJomw~Puwwl-uuuuUJwF-bUJwwUJUJwwwwwwww mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm !i ~~d~~~~~~~~~~d~B~~B~~~~~~~~~~~~~d~~dB~~d~ ~ON00OOO~~OO~NNNO~~OO~~~OOONNrOONO~~OOO~O q ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ gn z e 0 h 7 v I w2-2- S- mmmmmm~mmmmm- m ~-~x~-xs~-~g~s~~-%~-~-~-~-~-~-~-~-~-~-~ hh N gg~zgr-gzgggg g w~~mmummwmm~~mmm~m~mwtw~~ En E+ r 7 r r rr """""". ww m mwrom-uw~o~w m w~r.~~mm~m~~u~w.-u~~w~ooum~ Bzmm c g%%g$gggggY& $ ~~~~~~~~~~~~~~~~~~~~~~~~: oow~~m~~m~mtw~r~oomwooum~ 55155 m roumoommNwmt m d~ddddm-~~;ddd;i~m-~N~~ddN-~ 0- --m-~-m-rn-m-h-m---~-h-~~ N. twwm~w~m~~~~rt~~~w~mow~o~ sE r. N 6% $ F!??6$Gz%gekF a ~s~~s~~a~~G~~a~~ss~sss~~~ cdmu; g g~~~g~~~-ggc.q r& ~~~~=6~~8~X86~"=~~g8~~~~~ w mmr a. mq~.~.q~.qq~.q~.q (9 ~-m~.q~-N9~.~.r~.~.r9-~.~.~.~*~.~.~.~.~" + yJ 9 NqkqkkrnqTq?? f/)cm-C9- %- N-N-"V---r-F---O---yN- W m"m-N"-"N-"-"r---N-N-m-yt-N-Nm-N-N-m-m-. wWrv UJ OmNNNN-N-NNr t rNrrNrrNmNr-r-NrNmW-rrNN. OO~~NN-NWOO~ h ~rm~r.~t~tmmtwwrr~mmom~~m 1-00 m mmoo~mm~mb~m w mm~~om~~uo~umww~ooo-omum~ ~mm w wwommu~-tmrm m NN~~OP~O~P~~~~O~~O~-~O~~~ p%% -- rrrcrrr- rCN W- m- N-NNrNrrrNmONmN-qNNNtm, z $1 r 7- z sg s 999999999999 s ~99999999999999999~99999. - %&&&L&b&Zn&&& 0 ob~b~b&&~%b&~b&&&bbb&bbb~ sp$$ w ow~oNamN+mmo P mh~--wmmmm~murmomomN~mmN, 2 ;zzzz?s?zz?z ; '"9?wwk9k9'999NN?w9P~rnw9~ L SlW w hmwmmmwmmmmmm~mwwwmwmwmml E 00 W O~WOOOOONOVO h OOOOOOOOhOOOOOOOOOOOOOOO nI-g8 2 NOll?ONhOOONmN W 00~00000~~000000000d0000 m,~m.o,lq~~o,w~~m. 7 00000000mw00000000000000 o "rmmrmhmm-m- m r.~hm~mmuwwmtor.o~~oo~-~uo Ezb-0- r- a-m~r.-h-m-w~m-m-m-m-o-m- w- b~m~mmh~~mmmmmomo~oom~~mm~ ~1~~ g gzgzGggg&%gg 3 mh;dN~;m-ddd~ddd;do-m-;;o-dd Zoag- b- o-o-o-o-m-m-mm-mm-m-o- 0- o-m-9mo-o-o-rn-m-N-o-o-o-mo-o-o-o---99o-o-o- N~~~w~-~~~~~o~ooPooN~-NN >E r N mmNNrr r rrr FJ --- NrrrmCI1r-r N"NULn"rrNN 54 W N r- 0, +0, Kr O> ntx zm 22 5: Ftx $zi a WLL 2: 00 00 99 woo ct3xx u n AIo u 0- 0 0- 2" mm ee mm X$ 322 f ! zoo $$ 2: 00 ww 33 00 sg lqu? ww a2 51 uu m 2 P 0- 0- z 0 W A 0 s 2 53 m 000000000000 000000000000 000000000000 000000000000 000000000000 V7VJNNNN-N-NN- 000000000000 999999999999 999999999999 r.hb h eb,,eePPCeem PssGCCwwwPP~ zwwu==sss==c w+ssuwooawwC q;;;$qmmmmms WwwwmmrrEFEx &&&&L&pgpgpz mmmmmmmmmmm> $$$$$$$$$$$E5 nnnnKKaEuEam ++I-++++++++a 3333535333333fi h,SSSam rmmmoOhhb-r "m"ww333--- .?22g::GGG::% ~ooooQo&mmmm%~L3 333333 mmmmmmmmmmm2 0 0 0 0 0 m N 9 9 0- 3 0 s 2 3 m 000000000000000000000000 000000000000000000000000 000000000000000000000000 000000000000000000000000 000000000000000000000000 0- 0- 0- 0- 0- 0- 0- 0- r.- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- oooooooowmooooooooo~oooo 99~~99999~"999999999~9999 rN-rN-rNmNrrrrN-WDW "NN -I ww am JJ< aacr w3 as -I -I $8 a1 IC wfivvz LdS3 zzo""zo e r gggg zJ40$ g<go 8 ;i 2 pzzg ubT, $+..E5 s ,,o3ee: g;gg2 ggsggxg w>a*3!?F- 80=Ro"I-ss~~~&~~~%~~ESSSw --mm ONP~~ONN mgams:Em* mwmmrwcc~~n~om~Oaaa~~~~ ~~~~8~~~~~~~~~~~nssnkk~a m ~00o.dwo O&&Ad rr qg Eh se20zzaozormc aawzz$8 k~,zz?mww nwmow~~z~~~~ss~%~~~s-N~~~ #"e9%++0ggaa <? wcO$>>~~gz~~m WW53OO-N ~k3wnsn~~mmg,~~~swwz~~~~ Emon3hoEn~nmiooO~~~u99~~ n~~~~+ooOo~~to00woo~~~~~ f33~o~~~~~~~8~~~~88~gg~~ ~5~~~~~~~~E~~~~~~ss~~~~~ - mmwww [L I-I-I-O~~~GGQ~~ wQ2-l IY>>O+~~E~~YOO~K~~~ zqaf3 !Is s FFFFFFFFFFEE zzzzzzzzzzzzzzzzzzzzzzzz oooooooooovooooooooooooo I- r g? !=uJ%% 2 hr-r.r.khhh~mmm ~~r.~~~~mmmmmmmmmmmmooooo eeeqeeeeeeee ee~ee4qqqeeeeee~4~e~~~~~ rOmmO0rr"rr rrmmrm-m~rr~mmmmrmmm~~mm CCerPCCCCPCC sBBs::a::Ai2~~aas$aas~aS~ f zla a mUUll.OWWhhh-rN OOrrOrOrrrONrrOrONNrrrrr 00000000000- 0000---000000~0000000000 I- $5 %l-N-N 2 wwwwwwmwwhh~ mmmammmmmmmm ssFias+Saszisa mmmmmmmmmmmmmmmmmmmmmmmm Or000000rOr~ ~~mwmw~mmmtm~~~~tr~r.mm~o 3asGSSi2i22::: 000000000000 sSBs:aS=:AAaa~asS3ass:aa OOOOrOOOOOOrOOorOOrOooor NWWNWOPhhhWWmUWmWmmmWr.Wm ........................ NON-"?NONOrN~NOrOOONOOON ; & f: * e omv01c m I M E- 8- z- 2- g 6 7rY-r &"" 7 OI-00.7 5 Loo)ONQ) w = m. N. 0. m. v. v) + 2- c- %- s q 9-79?? f!kgrrza., y WWNrNrr 0 9 FLo w I-- 00 El5 z boor mor403 Yqm? mmmm 0- f N. -7- o031-m NmmN mrnmm 0 0 P- rc " (0 c r W m m N. IC N! 0 0 E 7 NWWON OLoOWW "rno!?m? rommo) 9 v? 9 '4 '4 U-J o! m 7. s !22g22 r$Nb L~~WI-N mmqrcu! F~ONW I- 8 8 2 8 N- N- u) 0 9 b. m x 7 .? * m o! 0 rn 0 W 4) " '4 z 8 a! 2 N - m N e N- m 0, Tr N = 00000 w WlcWWW (D ggggg g ggggg g g $;I""%": 6 48EEE c: z Orc??U? ? rc L In~LoLoLo Lo Lo 00000 99999 nFSg:aZ!2 w 2 o) (4 m- I-. 9 wosk;g%g > I v- v- " zq $3NLoW-r 6 kc 22 5% O> o-oz ww EL kc0 v)N WL 2: a 00000 8282% p! 3 8 8 8 s- g 2 a z- z- 2. z- z- wooooo >"N" -I J d q- 03 zo 27 JS+ gay,: >zwsq qsna +OIrnZ 3rg;zS PZOSO i&gge Nm.tUI- WWJZ' IYFI-w nzxo3 sa:,mQ a. a 3 a -. mZEE(0 COJOC WI-~VV) w0i=mz ooamo zuzaz lnnszg Wt?$$ I- -7 W In N 00 - m 0 Lo 0 8 0 5 9 N. 0 In g z 3 (0 W azzzzz &00"0 > 55555 cwmm-Lor f+s$ze 5°oooo- 5 eeeee Lu ZEZZS WWI-mu) E:iiji=AS= 3soooo- 2 I-I-om0 rnP9F-9 mI-om0 mmooo m ". 9 m- 9 0 a- m- " 9 OlmoI-0 OInOUO ro)NI- yr t-bomo mmooo eq N. 0- m- 0- mcooI-o ZZW38 0 9 2- z- 2- 0LDovo " c Z 3 s 2 !zg w% ZZ ZI-52 2 40 YIZZ:, QOWV) s2;ss uwip LLU3K0 y2LLIL.u. z~+nK 00 WLL a4au- Kh-02 g55j I- 0 m 9 9 m z G t- 8 m 2 z L 0 z 0 3 (0 I- o) ui 9 o? v s I- I- r m 2 x P- LD I- In e -I 2 2 0 z 0 s 00000 - 0 n > 3 c s E s LL h 7 v a 0 Exh il Reconciliation of Fund Source to Investment Portfolio As of February 28,1997 Cash Balance by Fund: General Special Revenue Debt Service Capital Projects: General Capital Construction TIF PFF Park Development Other Capital Construction Carlsbad Municipal Water District Sewer Fund Enterprise: Solid Waste Golf Course Total Internal Service Redevelopment Funds (1) Agency Funds Misc. Special Funds 19,317,982 12,591,994 2,875,257 5,362,173 2,914,868 12,740,730 4,350,663 44,717,170 25,223,288 26,781,303 22,476 840,461 52,867,528 9,966,328 7,784,141 0 Total General Ledger Balance 175,488,834 Amortization of discounts and premiums Deposits in transit Outstanding checks Wire in/(out) not recorded Other Net adjustments per bank statement 162,851 2,272,761 Total adjustments 2,435,612 Total Treasurer's Investment Portfolio 177,924,446 (1) Redevelopment Fund Balances are interspersed throughout all funds. ** Figures based on best estimate at the time report run on 3/13/97. 0 0 Exh - CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF FEBRUARY 28,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 AA2 AA- FCC NATIONAL BANK AA3 AA- GENERAL ELECTRIC CREDIT AAA AAA KENTUCKY UTILITIES AA2 AA- NATIONAL RURAL UTILITIES AA3 AA NORWEST AA3 AA- PROCTOR & GAMBLE AA2 AA ST PAUL CO 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 A1 A+ SOUTHERN CALIF ED A2 A+ Investments with Subsequent Changes in Credit Rating * Maturity Carrying Moody's s&p Date Purchased X DIGITAL EQUIP BA 1 BB+ 11/15/97 A2/A- 1,009,7 1 1 DONNELLY A1 A+ 12/01/00 AA3/AA- 1,115,280 UNION PACIFIC AA3 A 03/15/01 AA2/AA- 1,999,315 * 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 the opportunity arises to sell them at a gain. @TY OF CARLSBAD INVESTMENT POR @ OLIO Exhil AS OF FEBRUARY 28,1997 PERCENTAGE WEIGHTINGS BY CORPORATE NOTE ISSUER Investments Meeting the Current Investment Policy (Percentage Less Than 5%) AMERICAN EXPRESS CREDIT ASSOCIATES COD NA CAMPBELLS SOUP DETROIT SEWER DIGITAL EQUIP DONNELLY DUKE POWER FCC NATIONAL BANK FORD MOTORS CREDIT KENTUCKY UTILITIES NATIONAL RURAL UTILITIES NORWEST PROCTOR & GAMBLE SOUTHERN CALIF ED ST PAUL CO TOYOTA UNION PACIFIC WAL-MART STORES Investment Cost Percent of Portfolio 1,023,770.00 7,041,136.00 2,062,700.00 1,014,980.00 1,053,390.00 1,145,610.00 2,048,020.00 975,690.00 1,957,160.00 2,024,340.00 1,996,920.00 5,066,190.00 2,256,561.60 1,000,000.00 1,037,340.00 5,530,503.57 1,997,320.00 2,491,325.00 Investments Made Under a Previous Investment Policy Percentage Limited to 10%1 Prior to 2/13/96 GENERAL ELECTRIC CREDIT Investment Cost Percent of Portfolio 9,108,300.00 Total Portfolio $177,92,