Loading...
HomeMy WebLinkAbout1998-01-06; City Council; 14505; REPORT ON CITY INVESTMENTS AS OF NOVEMBER 30, 1997CI ty OF CARLSBAD -AGEN 9. A BILL 39 A AB# i4, 505 TITLE: MTG. 1/6/98 REPORT ON CITY INVESTMENTS AS OF NOVEMBER 30,1997 DEPT. TRS RECOMMENDED ACTION: Accept and file report. ITEM EXPLANATION: The City’s Investment Policy requires the City Treasurer to report to the City Council on 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 November 30, 1997 is as follows: i5 E2 3 2 2 g .. H &I V 2 V Investment Portfolio (Cash and Securities) Current Month Prior Month Par Value 206,450,391 21 1,573,357 Amortized Cost (1) 206,497,766 21 1,543,389 Cost of Investments 206,718,251 21 1,716,510 Market Value (2) 206,943,762 21 1,672,223 I I I (I) The cost of investments adjusted for amortized premiums and discounts. (2) The amount at which the investments could be sold. Source of market values is Union Bank of California’s custodial report as of 11/30/97. - [ . Interest Income Current Current Income Month FYTD Month FYTD Month Prior Cash Income Fiscal 644,938 4,153,452 4,798,390 Year-to-Date * * The cash income received is adjusted for any accrued interest purchased. 0 * PAGE TWO OF AGENDA BILL NO. / y ! 5 6 5 Investment Performance Average Life (Years) Average Yield September 1 997 5.929 1.57 October 1997 5.91 o/; 1.45 November 1997 5.91 O/I 1.50 I I I All investments have been made in accordance with the City’s investment Policy adopted Jan1 2, 1985 and last revised September 2, 1997. All investments were initially made in accordance 1 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 chang the City’s investment Policy or a change in the credit rating subsequent to a purchase. See Ex1 8 and 9 for details. investment portfolio has the ability to meet the City’s cash flow demands for the next six months, EXHIBITS: I. 2. 3. 4. 5. 6. 7. 8. 9. investment Portfolio Breakdown By Book Value, Market Value, Cash Income, and Aver Yield Investment Portfolio Breakdown Of Maturities Yield Comparison Graph Cumulative Cash Income Graph Fourth Quarter Transactions Investment Report Reconciliation of Fund Source to investment Portfolio Corporate Note and Commercial Paper Ratings Percentage Weightings By Corporate Note Issuer 0 0 4 u P *r( ad $2 w 3 i3 k Q w 2 z .K 4 * n a ! c F E i z1 0 .3 & 5 g 8 c fi g 2 4 5 z 0 0 0 0 8 d 00 vi 0 8 m m vi m 2 0 00 vi m 2 2 \d 2 Li r( P vi 3 2 00 c) vi 2 v; gl 4 W %I 5 0'. m 0 VI 5 Q 0 2 3 E E 4 0 d 0 p1 & z b !3 F 3 3 rn & 3 b Q\ o\ rl 0- d W c3 i! 0 z 8 3 I& 0 * E.lr G z E T $ s 8 s 3 3 R 3 l3 s E! 8 8 E @ 3 k 0 cq b4 aq 0 cq $1 G 4; 5s sa A9,o -22 $ 41 2. 2 w 31 [$ + cg EE c 8 e E r, E i2 "E 4 35 wg + ozo nz .5 6 c 2. 2. 0 0 0 0 0 u CI 0 0 0 0 0 3 00 3 2" 0 cl 2 N, Q'* m m 3 0 m m mn N o', m 3 0 8 cl Q m- 3 P P 0 cl Qn \on d s m 0 rg m '", \om 2 m 3 Pa an k 3 m Q m 3 :- Q m i5 cl \o :- 00 ", 3 2 '0, e, 3 * m 00 2 :- 2 cl 00 d cn 4 2- *, m 00 m m 4 W" P :- 00 2 00 P 3 v, 3 ", m f d- W 3 Q Q m x 2 3 m d m '0, E 2 W N * 3 2 0 m 6 3 00 3 m \o g z* 3 m cl d 0 2 2- m c.l d 0 Pn 60 :* N * 0 2- 3 m cl 2 4 a :- m \o 0 -In In 0. t" 3 cl 0 :* m "* 4 Q 0 0, I', I?, 3 C-l 0 :- m "* 3 1 K! 01 1 0 4 m m ?I 2 W $1 m W 0 \o m b 3 4 !2 0 m 3 :- m €4 13 2 ", cr, * 0 63 cl m cl Xn P Q* 3 3 cl €4 m d -! 5 9 0 cl €4 % x P '0, 3 3 cl €4 VI 4 0 E3 2 i t\l .rl w 3 & w x 0 0 0 Gl 0 ra H z E5 or- B$ jl w no 4k mra 20 &m 44 u 8 iz G N i! k 0 k 3 u 2 2 % E 3 6 2 h + 8 ;..( rq 9 g Ls h $ 3 E 2 0 9 rq 4888" z $$$$$$$$$ s s ?=!e 2 s;;F;=oo 91 8 s 000mYtvrd-mo *c\lvroo\D cn 00 G-. 2- g* Zn :* zl 2 4 H gh Gn ?n gfi ?- m m Yt ? 0 t-c mL.oooooo4 m00rOm i 3 €9 c'l r/l c$ * 0 H s m 0 0 0 m vr 4 0- 5 m P 47 4 '", In 4 &* Pa m 0 3 Yt m 3 Y 0 0 01 4 P 2 3 m m €9 $ 2 4 *I m & 2 g $ m 0 0 0 m m :- On 0 C-J 5 a \o Sfi 0 m P P m d- Q', m, m c'1 0 0 01 cn 3 2 'n 3 \3 €9 $ z c-4 "I !3 5 " z w E 0 0 0 00 vr '"* s 3 m 0 0 2 :- 0 m m P 3 2 P 4 d- 0 Z- 3 m c'1 t-4 0 :* In 4 ", 31 rc) m cn o\ :* P -* 2 €9 4 $ 3 Pi v) b ". n 2 * 4 m w q88BFhS,,, d &#2 2 0 2 F T K AI CII n w1 3 H 9 aa v- s m CY 8 C s C w F C d 5 s 5 C 2 ? c C P r: 0 0 (? t! 4 P .rl s w z 0 m H % 9 0 u d GI n F4 4 7 ~z ?m L4 qg 4z I x, I am Om uw % k L c4 0 e( H * I C3NrCDQ)Oor-CDLD GGG lf5YjujY;ui .c, 8 - 3 ’$ L 4 r- e F .c, 8 - 3 7 L 4 (D Q) T \ 8 .c, v) r- e 0 e e 4J 4 % c x w a, 0 0 G Ja E H rn 5 i 5 a, > c6 04 I 1 00 ch m F4 l+ + n c-, z 0 d) k F4 0 00 a? 0 F1 3 h r- m k 9 d) d) 0 I E B W g 4 A v s s e s + b - e s * * L 4 s -c a * * * * * % I I w cv 0 00 co w cv 0 F v= r Vl 0 0 -rl u 5 c w x ooomo~mmoco or-rn.-(~ r-mmwm N N-0-0- 0- v) N r N 7. '.0.90.9 N.w.N.W-0. 3 p mgmNPUmrU7-r mmmmu NmbNm N mm--m mm-mm mmomr-wm-WOO e omm o r r mo orno m " X?X??Z?a?%ZX ?$y?Z v??%3 fi :X XEX 2 g- : 9 % 9 '9 9 N. 5 2:: 2 $51 ;gs~~-?.$>~~~ :-$;-EL :.:-:-:.g. w ma om0 m-m m 9 r 9 0. -. N. g. E mr~ m UI mo XE8 P 2 S<N--- kmN N-N N - N "rrN NONN- 2. z- -- m. 0. N. r N-N 7 omommtmmor-o 919505""9'99 OICW-N r-wmwm mo~mmwr-r-mm~ - omomomowouo omm h N mo om0 VI 9 ONN CO 00 rr-P m " PWr-ll)r- mmwom- 3 2 25% 0 2% 8%: 3 omw~r- -m(~-w X$?Z> $Z?Z$ * ?kk p i- 09 om"! k ;I y-Y%~;L~~~o.; -.o.w.-.m. r--w.~.m.m. 0 b. '4 *. N. b. m. 2 2 $28 5 22 p?Z 2 g sss g s $ ss sss s sssss sssss r mcg ;; mc :go g m E uum~uu~-- 7- zoous gg~zu n 2 -. N. r.. 0. - rNfi r Ec wwr-mmr-mr~mm sssssssssss mooo~mooooo mom-w mmarnm N o NO moo o UI oom m m mom -ww m 0-000 oomoo 581 k'c?Nkk45"5k y?z$ y??Z? 2 ONN anL momammmmmmm XsxX$:>?gXX OmOOrr.rOO0O oomow or-ooo m 00 000 0 '"9-5". 9'999'" x 8 g. xg 2x5 2 000 0 0 - ommwmm~m~mm r-om~w omomr- mor-mm mmmbm m w mmm o 5 w ow %83 z mom-mmomwmm lornoom m(Dmm~ Q 2. g- z. 2. 2- ". *. N. N. "- wmo-w wm" dm mmr- ww om- ?:s 2 z- g ji X~u&.~Xgg.Xg.~~ -.m-o-o.m. ~.-~.mq u) 8 2- 2a mmm~o~mmm~~-m~ mmo.o.o- m--.o.m*o. N ? 9 4 0- 0- m. 0. sssssssssss sssss sssss oowmo mr-~mo g " dwmwwwmmmmm m)Lnmmw mmwwm c: - " r ."N rmNrr 9 m m. 0- Nrr r rr N % g 1 ~L2SSSSS88Z~ i 231 00000000000 s a51 z$zzOO~~~~z 00000 ommoo SS sss s mo 000 sss s omw m 000 0 a Nk'"?k0??-.'9 9kk5W. rc@?rqNr: 6s 252 g $22 5 000 8 8 E mo 0 'S gsgsgssssss S8.8.8-8.S8.8.8.8-8. 00000 00000 8- 8 S. 8. 8. Z- 8 F: Z F: 8. s 2 9 z- 2. z. E- 2.:. 90.0- 9 f E8888 88888 ooooo ooooo 0 000 0 N 9990.9 0.0.90.0. 0 a 00 000 0 8XXXX XXXXX x a 8 g. g- 8 0 00 ooo o 000 00000000000 0. 9 0. 0. 0. 0. 8. 888 8 2 - mqqqo. o.o-o.o-o- I N E N-N T r m 0. 7 N--7 r N -7-N NmNNr I -0 <SS<$$SSSk< m r-r-hh 8 r-bl. <$6$$ 666S6 zzzzz zzzzz 66 99s 6 $$A 6 zz zzz z ZCC C T-rrr - zzz z ._ 0 - - m . 7 . k - 7 r r- 0 0 z 2 bbq mr. erN $& $yS - - 2B ,$ 2 g $33 j ;$&&$zgg IC0 3:Sa :S c?; E!$- q s 86 $ ems om?! IC vmm p gz:os ZIEFS 522 g55 t sg8 0 g U) zwag3WD3w33 1:;;: IJJ+WIJJ 333z EE ax,= E Zzz g K 03Ebo3~nzno $212~ 2400~ SI ZRW K 0 +ww IJJ $22 2 ;qz~BkzZ%$g gswms gjZ8- $3 ;$e 2 E%; F $5 ?e% E 992 9 r c! Wb Ins$ w 0i:g r m W $5 5 3 0 mm m ozg 4mo o b 1 $2&g;$sg mg(0gz 2 NZm k- K g;g3ggggsgg 3nsso S&SSC ii$ m$2 E mw60tto0m~m ,ezZZ $sz$g gd $J+ 8 H mzOwm3w-ww W os$ s I ~@$~~s~~~g $0664 0aaz S52SY LL Li55 0 m.b(D w IIJ G Z$S%!ttEEttt 3kdd:t EFttf 51 uno B LL(D E 1 22552222222 52222 22225 za zza z 00 000 0 222 2 mom~mmmmmmm .-mmm- mmo~ bb br-r- r- mmm o ~r-mr-oom~mmm f Q. QQeQe4eeeee .-I ~Orr00-0"- ""0 ."o.-a 6 "r F! 6 szz F % 2.z 44eeeeeeeee eeeee $%$$$ E 44 eee $ E (Dm0 3 5 s 22 zgs s zj S$$%S $$SZg 4Q $$$ $ $ 221 g$gg$~~~~~g w?sgg. $gzsg $5 sz$ Q $ss -CQ 8 gp %:I @?$Z&$$$$$ 8ZZZZ r---- p!zs t 2k ::Q 2 2 FCC C t " P L hhhhr-r.r-r-r.hh N mmwwrrrrm r-owom -m r-r-r-lch br-r-r-r. - br- r-Or. m r z r-lcu) m L eee corn: .- ""r ""7 00 -3 k P p:a w9 ZE a a a I I X 3 Q I- cr.cccr-~r-ccc Sf$$$ 66666 $$$es!sggq ""r-"$ Gisaa: 9 Peegrrrrrr a$$$?; ur??e< gooooooooo~ ;""- IZNNNN E w E ;-I 2 z P n 25 zg 0 0 a + -4 e *rl s W x - r v - r v =ul ~a~8SfaX68~WX~~~~~~~~~~~~~~~~68~~~~W~~Xf~~8~~8a~~! b P P (D r-m P m -.N r.m.m-m m m m m m m m m m m m P m-m-m-r- 0-b m.m-m m.m-qm o.o-r.m o-N.-.~-o-(D-~ gij r r rrr rrr r rr rrr "7 """. I- a~~~~g$~a~~~xg~~~~x~g~~~~~~~~~~~~~xggga~~~~xxx~~~~ Ez ~~.~-~~-~~~-~h~-~ss~~-~~sx8.~-g-~h~~~.~~-~~~~-~~.~-~~.a.~-~~-~~.~-~8-~-~~ k? a~.gs~~a~~-x~-~~~.~8~x~-~~~~-~~.~~~~.~-X-~~~~8~~-a~-~.~~~~-~.~-~~~~~.~ zK m~~~moommmmoooom~moooo~~~mm~(~~mo~m~oooom~m~mooomo~~ = ej PLOO~~~~~LONOP~O~NO~(D~~~~LO~~(D~LO~~~~~NW(DLONLOLO~~WOO~O~~ wU mrrrr r~r~~~mrr -- N- -- rrrrrr rrr~~rrr~rrrrrrr a~8as~a99~8888~~~4888~~~~9~~~~~~~~~~~8~~~~~88~~~~! t;; a8BfB8~~5PBB~Sa~~X~~~~~6S~~~~~~~~~~6~~a~~~~S~~~~~~ !I X$~~X~.~$~S~$~~~PXa~~~~~~-~~~~~~~~~~~X~~~~~~~.~X~~~~~ NW~OLONPPNPLO~NI-~LO~LOLO ~LO~LOLO~LO(DLO~LON~~~OO(D~~~~~~~~NNLO(D~ ~ m rw LO POLO- r z NNNNrrrr mmmNNrrmrrmmrNl Sw ~W~9se~9W9~g9~9a$~~~~$W~~~W~~9~~~~~~W~~~~~%~8~~~~~ qqqqEsEqqqqqqEEEqqqqqqqEqqqqqqqqqqEqEsEEEEEEEsEEE~ >El q99r99mwo~q"N~w~w~~9~~w~~9~~N9~09r000~~9~9s~9~9~9~ L LOLDLO(DLOLOLOLOLOLO~LOLOLOLOLOLOLOLOLOLOLOLOLOLOLOLOLOLOLOLOWLO(D(DWW~WW(DWW(D~(D~WLOI 0: ~~~~o~~~~~~~~~~m~~-~~oooomoooomoo~~m~o~~omo~~oooooo~~o~ 090aaY00"~0000m,a99aa9oor~oo~w0o-99~~o9oNo~oa~o~0~ Eg ~.~~~~.~~~~m~~.~~~~~.~o~~~~~~.o~~~~~~~~~.~~~~.ooo~o~~~~~o~~-~~.~~~~~~~.~ %~B~~~~~fi68888~8fi~8~~~~~~~8~~~8g~~~~~88a~~a8g~~8a~ pal ~66~86~~888X~688888~8~88868~g~8~~~~88~~8~~~6~~~~W1 m-m am m P w m m-m ~-b-o-m-(~-a r m m - m-0-7 m 0-0 0.m a (~-0-m P P m m m "m-m m m m-m m ~.m m o. >I N r PmNNr " 7 r " Nr "7 za I- Q) &$ gg 3 i!$! wm z> rng w >k +v, a !Y% 2 > :I $1 2 v) 00000000000000000000000000000000PP000000000000000 00000000000000000000000000000~a0~b.000000000000000 00000000000000000000000000000000"000000000000000 oooooooooooooooo~o~o.o~o~o*o~o~o~o~o~o~o~o~o~o~o.LO~LO~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 o o o o o o o o o o o o m (0 o o o o o o o o LO o o o o o o oooooooooooooooooooLOooooooooooooLOLOooooo0oo(DooICooo 0- 0- 0- 0- o. LO IC o. 0- 0- P. b- 0- 0. b- 0- N 0- 0- r o. 0- N 0- 0- LO oh 0. 0- b- 0- 0. P -t 0. 0- 0- r. 0. 0- 0- 0- m- o. 0- b- 0- a 0- mrrrr rNrPmNmrr rr Nr rr rrrr-r rrrNNrrrrrrrr r OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOONNOOOOOOOOOOOOOOO h $ 8 z. m 3 I- a L IC e ZP IC $62 =bm Aieee ?x E22 52; Fwd; Ass LA-aAA? 2225 <s~~~E~~~~~~~ z8.i2 -, SygS?? &z 1%~ y oa4 a210 o-,wiSSO, 3amzgg2 wozsvooaaaAso '225 .- AJoo d$$Z o SAa zq4: o%Y@;$ase 8onCarmNm~wao~~~~g~~~~~m -%a'mmeegem,. (DNe~eeam .~~~ooqmm~aar=~ mmmme,~sg~~~g~~p sEqms~s3~wpg;srsa z~~~~~~~~S~EW~~~~~o~m~~~~~~~~8 ~f@$~$?W w**nwn+n,szo P~Y~"?~3w~~~~~~z~~~~~~~~~~~~~~~~~~~~~~~~z~~ nzzon nn ~I-I-S~~ZP~~F~$$S. sE~EE~E~E~~~~E8na~qq,~~a~qa~Ean%E~ qrrrn 22~ooon2m~2qn22~n~ ozz~n~+~~,~~s-mm~qm mmmb Os~~~m~~qq~~~~Ew~ss(Dqqrm E~~~~~mN~LO~""99~LO~~~~~~~~~~~~~~~~~~~~~~~~~~~~~LON~ -mmPujoclLO ouLO~-~- ~ssan~~s~~ss~~~~~~~~~~~~~~~~~~~~~~s~~~~~~~~~~~~~~ t~E~~~~~t~~~itttEt~tt~t~~~ttttt~~~~~~~~tt~~t~~~~~ r 'y s sz 9 s ww 23 s (D(D(D $$ dd ?? 0 b $kg I-%* OF - E (D A A" $ < <;? ZZELO-'-,Q S8m KAAAN~~~ <22"1JAA 222 0 zm~~~~oV~~o"rnrn~m,~g~~~mrnmm~oy~ mOYgo m~Zg~z,m~ ZmOOy~=WLzz 1 mzaa~AAm~+gcc80~$6~~ y ddddddddddddddddhdddddddddddddd~d~dddddddddddddd~ t ~~~~~s~~~sos~~$~e~~$~~~~~~ee~~~~~~~~~~~~~~~~~~~~~ 5 21 mmmmmmmmmmmmmmmmmmmmmmmmmmmmammmmmmmmmmoooooooooo -=99==~~=~~=~4~~99::=~~~~=~9~~~~~~=a==~===~~~ mmm-rwv) IC- mmrnrroorrr~r-r~~N mmm-2 N~~PLOLD " r- a I I- ~~~~~~~~~~~~~~~~~~~~~~~EE~~~~~~~~~~~~~~~~~~~~~~~~ E, maS~~sr~=~~~=~~r~r~~~r~==??N~rr~~=~==~=Sr~~r~r~~= 2 ~~(DN~(DW~~P~~LO~NP~PN~~O~OP~~~(D~(D~~PW~~~O~NO~ONNLO(DN r- .- (D- ~~moooroororror -NN m om b mm -trmrnrr "r """r i 31 r 0 0 ,ag~pk~&8~g~~~gcn~g~ m m(DoNmNNNmNNNmmmbrNarNm .- mmu &?"""""""" -."k"rn.~"rn.91trn.b.(~."~k" Z. r ggsgssssgas~gss~s~o~~~~ Z qsS r "r r ~ ooq"999mw?999k""Tm rn o"m~qm~m"m~~q~o~o~~q~o - LONC ootmooomb(~omom(~m~m m or~mmmmam~~~~mmmbwht(~o z gggzg~gzzl$gg$;ogz~ g ~$~~gkcncnz~zz~~~~46~R$g 2 22: sh"r6gap+$~f$g~$$$~$ >p: ? m w~oommwm+r-~moomm~~mm q 1~9-m.99~~.rr~m.??991~m1~ $. a.m.0 rPC 6elfE?z?hsze-rz"-r- $ xx79~9999999x~~~~~~r~~ ~~~%~~~~~8~8~$~R~b9~~~ 2 8 22; $25 I oo~mo~ombmmmomaa~m m ob~mmmomm~~rmmommwc~(~o oNymohoqqymqqk??Tp m "kmqN-?m?qmqNNmNqqymho s 2;: &38f%8%8$?z2%%EZ85z: c: sg68f~~~Cz~$O69~6~~7$~ 8 NOP w--o.--m*~m-~.--t~~.qb-m~m~o--b-~ N. m~~~~-o.~-~-rnyo-y*.o-m~~.~-~~~.m~q~-~-~. -- m--.u ~ammrn~r~m-rmm~oammmm m omm-ooooam~mmmmoommmbm esgggggzzgsg%gzgggg g g=~ww(~(~(~w(~ww~mmmcttabN K RO: 51 rrrrrNrNlOm -t- NrC (D r 0 z ssssssssssssssssss 2 sssssssqq~q~qqq~~qqqss s sss EwEgggggkEggg$zzgggg m agZRgs~~~P9~8%~~W%8~~~ 8 ggg ~~o~oo~~~m,~~rn,~~~~~oy ~~[dd~~rn~mnmornmm~~m~m W 2 dddddddddddd~dddddddd~ 2 22: K babmmmmmmoooooo~(~ommmc gogssasssssg,g,g.sss~ g, oto~~~~moooootomomoomoo m oor ?k999km99999NqN"m?9-99 p: 99" mmboowoNotmmrwmoom X g8Z~~"~~g8Z596~~y6Eg~ $ ESz w~qm-m.o~qqqqqqymo~q~.o.~.w. -. "0~-.9~~-.m-(~-"k~~b.~q~."r-~yrn r- p?eu I- ~mmoo.-ooom~m~~m~mm - mamm~-~rm~~m(~mmm~mm~tm (D -to. ~~~~~ggg~omo~~m~~moom - mm~ooooommmmmmmo~ooo~m ~o~mo~o~mmo~o~mo~o.m N. ~~o.~o~qo~o~mmmm~m~~~m~~~o~~m & 62-2 z=l m rNNNNrrrr m r"(l o O~~OONO~OOrOPOOOOb >I rr."rN rN Nr rN (0 rrrtrrrr- 0 kg biv wm h OrY CLw E5 EZ I2 $4 WLL Q( 2; 000000000000000000 999999999999999999 000000000000000000 Y888888888888888888 a a o- o- o- o- o- o- o- o- 0- 0- 0- 0- 0- 0- o- o- o- o- ~~000000000000000000 nu^^^.^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ 5rN""N"N"NrrrN.- r 5 3 Qgd*s mm PQ 5 mZZ I. u] messm mm kl sr. .m (Dw k<~-~qmml me "X $a d~$&;~g~~;;i~ o$Smaa:$@ x 65 .ow&NzwJay55s; * $s$~~y~~gq"g2so 0- gdgis- F~~$&&@@S $~$~~3g~~p2$;;3w ;2s?;$$$$g3$4g;$g N~~u-~-g~2~m5w22~~ rg,gC?N-N35s0s33nz O$;s$d~-.rtsm9b??7" ~~aa~~~<<u<~a~u<aa <rrrJddrrrrJrJrrrr 2ththZZtttthtEtttZ LOLO-LO qrmaaommmao IC ambw m t c) m m m 8 2 J 6 z a 3 (0 0000000000000000000000 0000000000000000000000 999sss9ss~ssssS~~ssgsg ~~~~~~~~~~~.xx~~o.g~~~~~~~~o~o.~~~~~~~~~ 0000000000000000000000 0000000000000000000000 m- N- d 7- 7- " " " " " " 7- N- m- m- N- m- " " " N- " mmmmmmmmmmmmmmmm $$$$$$$$%%%%%$$$a, e: myommmmmmmmmmmmya~m~~~ wwwwwwwwwwwwwwww~~~ww~ r -0 >.-33333SGGGGG53m4 mar 3333333333333333w W33P oooonooooooooooo~~~o~~ ssssssssssssssss 3wss3 mmmmmm~mmmmm~~~mso3~~n wwdww(~(~(~mmmmma(~w~~~am Zzaaaaaaaaaaaaaaaddaad (0(0NNNNNNbbbbbOONU3 yrryr-mmmmmoor~gggQ ~~>~>>>>>>>>>>>>>-b>>s ~~~~~~~~~~~~~~~~~>>~3> ~'tttttttt~t~~t~~99tt~ ~~ssssssss~ssssssss~~s a~annaaaanaaaaa~*ae* ~~*******~***(0~~~aa(0(0a 333333333333~33~3~~33~ 0 ? 0, 9 0 0 9 a m g z 3 * ooc ??C ooc 0- o r SS: 9 z- ; oou -I- eoc az e$- =0i yzi 0s: x?:; !jz; $wu - +Si EN( $X 2p$ $2. 005 noc =3; K>> 22s -31 b oc nc w ;lhhdhd&%%hhdhhSdh aaKaaaananuna~aaaanann ~~~~~~~~~~~~~+~I-~~~~~~ zzi oo< 0OO"r"rrrrrrNNNN gw$$@~!$~sss~gsss$s$ QeeQeQeeeeeeeQQQQQQeeQ mmmmmmmmmmmmmmmmmmm~~~ bma mmc Nz: ~"rrrrr00000rrrOr00rO y~~as2a~2c~22~s ss~~~~~~sssss~~ss~~~~s 5s: 5 til --.- ." N mmmmwwt -7. a b~ww(~ba(~mcc(~(~cccr-c QQeQeeeQQQQQBFeQeeQeeQ dbr b~~y~gee~mrnornm-r-r~~ mow~r~~~m~mm~r-ott~-~o QQC ~mc mmlcmrwm S 2:s g eeeeQcQQBQBQQQQQee bhbbCbbbCCbCCbC~ebbhbb gpm=r...~mm~5e>322S~ rrm - mr NN m :z~z~~2~=P~GP2~z~zc~~ 7 mmmmmm (0. i dl 7 2 a e A - r m~om~~~lnln-tm-m~mmm(~~'-~~o~~to~~lnot~~~ 10 r,"r,-,- s ommhmmnqo.yqmqoccqyy~o.~~~~~~w~m-~~~m~t~ ~t~mrmmrntmr~mmm~~rmmmtrnm~rnra~o~~~rnrn~ .h.w".m. %- gij - "-7 " """"""""""~ 7 % ~~~~i~ddioidddd~ddid~o~dd~o~i~~id~~~ 2 .=?-?p?-!* h ~~~s~-o~~x~~~~a~.oaw.~a~~~-~~.~~~3-~~s~~~.~-~.~. q 22.gqg %. g p I' -:NE? w z ~wc~%~~Ffx~sxsxsss~~~~~s~~s~~~8~~~~~ 6 g;$4? c N ~~~o~~(~rt~-owwocootmmtto-~'oot-ocom~m m tomice m ln ~~~lntlo~rtom~lnmowoot~mrmo--olntwm-ow~m wz~s~x~-~s~-~~~~~.RX~.s~~~g-~g.~~~~~-~~~~~~~: 3- %%.2-8:,4 5. $ UJommm ~~rm~rnoor~'mm~'c~to~'~to~~m~'omlnmmw~wm~~~~ N NON~N - u) WWNrrrrrrNrNrloWrNrrrNrN-rN rNrrrrrrNrr 0 ~~~cs%a~~~w~s~~~f~b~b~~~b~~~~~~~~~~~~ g lomlnlnm g; ~lnwtt~~lo~'--~m-~'m~t(~o*dlnolom~~t-o-m~-~twmln(~m W~lnw~~wrr-~tmNmmwln~mm~~oo~~mmm~m~tmt 2 mmNorN.~-NNNNP-lnNmwrOlnmNmNNmtm~ t NNPg z N -o-y~~~~~'~rnq~qqm.~-m.~~~o~e~oq~m~-~ln~~y~t.w. q btNmm ,I. -:" N -- m 0- W- m. " a. r N 0 z S~~$$~$G$~Z$$$$Z$$$~Z~Z$$~~~$$$$$~ZZ g $Z$$$ E ~~~x~~s~~a~~cssos~s$~~~~;~~~~~~~$~~~~~ ? $?ccc 8 O s + mmmlnlnmcmwwwwm(Dlo(DmwmwUJwln(Dwcw(D~(Dmwwwc(D w tlololnm ln 2 2 sl.. . . 88888s8s88888888888888ss~8888s~8~~~,8, N lnmomo N m ~~~do~oooo~dd~ddoo~~o~ao~ooooo~~rmoo 2 -7kqTq - wZ~.?o.~.m.~m.?~?'o.m~.ln.1~9m.~.t-.m.~.??~.~.t-.??~~.?~?~. 8 qsqt-.? $. gm oroto w 0 ~~~"8~88~8~5888~~~~0~~~~~~~~~~~~~~~~~~ g WDJ~J g 0 !k!Zri.--?"~ NrN tlnr""NrN " r " rrr r z. p za % ."mr N nCa~omtlo~otNmooomrrNtwomr~mm~m~~m~tw~~ woooo ~~~o~~ommqqqmq~q~~qq~o.o.~~~~trn~~mq~mq~qmo~ p. mr--xx li? 2 W K I- z W E 9 v) z h Q) a3 T- 5 m P z 0 0 P) 8 2 000000000000000000000000000000000000 000000000000000000000000000000000000 wss8.~s~~~~8~8.8~8~8.8~s~8.s~~~~~8~~~~~~~8~8~~~8.8. ~~$x-ss4sxssgxsxss~ssxss8sgssssxs2888ss oooooooooooooooooo~ooooooooo~ooooooo na-~~~~~~~~.~~~~~.~~~~~~~~~~~.~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >NrrrrrrNrNrtlnrN rrNrNrrN rNrrr rrrrr -I a 25 8w p 0s ili ; 8'm cosw "k WC m-l gz Eg 03 aa 4s 00 OF lY4 az w -t 1 320 _Iz a$: Yo$ g4: 5 ;e2 qzsm3 rN 2? ln$W+* m JUO Qmo=)o ";r"$g; $$Z$S $E?& $+;$$ mm .- zWO30 Io=)$= +K<ZO _I _I 4 0 i s!j 22; 22: Mg ++ $arn sse mr 22s 002 sg %%5 00 00 oow 440 w s s - 2 $ $ELi 5" $3 or? 3: :g PZ 5s %$ 0 n we 0, Om *O mw uw w 2 1 5 $$ 09 nZ fhw em2 :es e?? Wmvi $5 kW> os4 sa% m,-2 :&: 23 255 UZI _I 2 d a1 izz 1 coa 2 ,_I_I$ 2 1 ZZ? J saaq p $JOG; -I 9 N0U 0 i<Zln,_IS p ZiiX z so00 0 wzz$ pggsn;it G5 388- sxgO5$p4 Ym oaR"~$ggws:Z~g:s NOoZzOPOr gss$ei%~s~~~15s~~; mczqzw, t-lnmom~ LU~S~~~WZ~~ 4y~m~n!~3gYr~3~rnR Zpg~~~oo~~z,~03n- p&sN&Ra. ~~plna~N~~~$z~~~~ o .,-: .,d~~ib~nm'4 022?:g52%s5g22E? %nazzmazaao+maagm szz=Nar=Q wamm .~<3aworzg ln~Zl~aom3> occYwo+~+~oJo~~oa 0cnm0z0m11nAF40_Im~m %84Ys%PBssPs%&~9E 8, i? -0 ?SN$ w;;"Nz N gQeW 232 ss,m nus sxsm nz mI'I'w =+We ymz9 @; +42% 0 x 9 0- m '4 N I' IC) 1 2 2 0 3 m lomomo 'hOT9 oroto woo00 rn -. 9 I'- 0. ~momo m I'. " N. N. mlnomo -cNc e z 3 0 0 2 c a$ 33 CFZK s%;ss g:Z?.$ %$pg y@u.. S: an $5@ LLZ3KG 22::: N 7 8 -? m- (D N 0 m _I 2 L 0 3 In 0 '4 ". I'- 8 z ? r N 1 2 d 0 + Z U n nzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz ~~"0000000"00000000000000~000~00000000 00000 c eeeeeeeeeeee??e$eeee~~$$??$~$eee~~e~ zz~I'.m=a~~=~~=~===~~z=az==~=~::~aa~o m~ mmmmmmmmmmmmmmmoooooooo-~~~~~~~~~~~~ aW=~~~~=lnlnlnrlnmmlnmm~~ln-mln-lnmlnrmmr- .-.-ink rcmwmrmmlnw mz.- ~m emrrr m.- 5 :I r I 5 eeeeeeeeeeeeeeee~ee~eeeeeeee~~~emmmm ~'~'mw(~~'t(~mwcmm~'~'mw~'wclncwm~'w~'(~~'(~c~'cc~~ ~ootolnN(Dc~~=-tmI'wm-ooolomowkomo~ma~~~ t z t 5r"m mmln m(~e w -rmlntctr gwNs~~~sea=w-t =~~~:s"~~:==~N~~~r~~=~~ Li 21 sn r r 6 - g 5 a 0 0 E e LL - r - 0 e Exhi Reconciliation of Fund Source to Investment Portfolio AS OF NOVEMBER 30,1997 Cash Balance by Fund: General Special Revenue Debt Service Capital Projects: General Capital Construction Traffic Impact Fees Public Facilities Fees Park Development Other Capifal Construction Enterprise: Carlsbad Municipal Water District Solid Waste Golf Course Internal Service Redevelopment Funds (1) Agency Funds Misc. Special Funds Sewer Fund 4,838,828 3,553,981 17,696,160 5,341,019 58,051,980 Total 27,052,848 1,364,323 2,128,547 32,665,198 Total 22,207,230 15,260,415 1,886,926 89,481,968 63,210,916 10,513,936 8,142,491 0 Total General Ledger Balance ** 210,703,882 Amortization of discounts and premiums Deposits in transit Outstanding checks Wire in/(out) not recorded Other Net adjustments per bank statement (16,009) 855,516 Total adjustments 839,507 Total Treasurer's Investment Portfolio 211,543,389 (1) Redevelopment Fund Balances are interspersed throughout all funds. 0 * Exhi CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF NOVEMBER 30,1997 CORPORATE NOTE AlYD CUMMEKCIAL PAPER RATINGS Corporate Note 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 BANC ONE CAMPBELLS SOUP DETROIT SEWER FCC NATIONAL BANK FIRST USA BANK FRANKLIN UNVL TRUST GENERAL ELECTRIC CREDIT KAISER FOUND HSP KENTUCKY UTILITIES MERRILL LYNCH MORGAN GUARANTY NATIONAL RURAL UTILITIES NORWEST PROCTOR & GAMBLE ST PAUL CO TOYOTA TRAVELERS GROUP INC AA3 AA3 AA3 AAA AA2 AAA AA3 AA2 AA3 AAl AA3 AA3 AA2 AA3 AAA AA3 AA3 AA- AA- AA- AAA AA AAA AAA AA AA AA- AAA AA AA- AA AA AAA AA- A-l+ Commercial Paper Investments Meeting the Current Investment Policy: (Ratings must be Alp1 or better by both Moody'sand S&P) (Ratings of other debt must be AA or better by both Moody'sand S&P1 DUPONT Al+ P1 Other Debt: AA3/AA- Investments Made Under a Previous Investment Policy (Ratings must be A or better) Prior to 2/13/96 Moody's s&p FORD MOTORS CREDIT SOUTHERN CALIF ED AI A+ A1 A" Investments with Subsequent Changes in Credit Rating * Maturity Carrying Moody's s&p Date Purchased - Value DONNELLY A1 A+ 12/01/00 AA3lAA- 1,092,745 DUKE ENERGY AA3 Ai- 04/01/99 AA2IAA- 2,023,268 * 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 c, JRTFOLIO Exhi AS OF NOVEMBER 30,1997 PERCENTAGE WIGHTLNGS BY CORPORATE NOTE ISSUER ASSOCIATES COP NA BANCONE DETROIT SEWER DONNELLY DUKE POWER FCC NATIONAL BANK FIRST USA VISA FORD MOTORS CREDIT m UNVL TRUSTS GENERAL ELECTRIC CREDIT KAISER FOUD HSP KE-NTUCKYUTILITIES MERRLJL LYNCH (CP and MTN) MORGAN GUARANTY NATIONAL RURAL UTILITIES NORWEST PROCTOR & GAMBLE SOUTHERN CALIF ED ST PAUL CO TOYOTA TRAVELERS GROUP INC Investment Cost Percent of Portfoli 9,054,506.00 1,999,830.00 1,014,980.00 1,145,610.00 2,048,020.00 975,690.00 1,002,620.00 1,957,160.00 998,750.00 9,108,300.00 954,187.50 2,024,340.00 495,385.50 I.! t 1,995,580.00 3,019,970.00 8,729,459.00 2,256,561.60 1,000,000.00 2,042,260.00 5,530,503.57 1,105,341.85 Total Portfolio * ??a more th& 5% may be invested with a single issue. , . .. $21 1,5