Loading...
HomeMy WebLinkAbout1997-10-07; City Council; 14370; REPORT ON CITY INVESTMENTS AS OF AUGUST 31, 19978 LP ;i 1 CIT F CARLSBAD - AGEN A BILL AB# klJm TITLE: MTG. 10/7/97 REPORT ON CITY INVESTMENTS DEPT. TRS AS OF AUGUST 31 , 1997 CITY MGR:~ 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 August 31, 1997 is as follows: I Investment Portfolio (Cash and Securities) w 5 E f3.B z E-l 4 d V H z .. E V 30 V I Current Month Prior Month Par Value 199,343,947 201,487,667 Cost of Investments 198,991,227 201 , 155,058 Amortized Cost (I) 199,508,310 201,071,008 Market Value (2) 199,059,920 201 , 193,498 I I I (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 8/31/97. I, Interest Income Current Current Income Month FYTD Month FYTD Month Prior Cash Income Fiscal 1 ,035,1 86 1,056,648 2,091,833 Year-to-Date Total Income Over The Life 31 , 199,235 32,044,363 Of The Investment If Held To Maturity 0 0 PAGE TWO OF AGENDA BILL NO. f 4: 3 3 D Investment Performance Average Life {Years) Average Yield June 1997 5.91‘ I .59 August 1997 5.91 1.59 July 1997 5.90 1.55 ~ ~ ~~ ~~~ ~__ ~ All investments have been made in accordance with the City’s Investment Policy adopted Jan 2, 1985 and last revised September 2, 1997. All investments were initially made in accordance 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 Avel Yield 2. Investment Portfolio Breakdown Of Maturities 3. Yield Comparison Graph 4. Cumulative Cash Income Graph 5. Third Quarter Transactions 6. Investment Report 7. Reconciliation of Fund Source to Investment Portfolio 8. Corporate Note and Commercial Paper Ratings 9. Percentage Weightings By Corporate Note Issuer t 0 0 Exhib i 0 3 0 k 0 p1 c3 z c3 z 2 9 5 n 2 w 2 * u 8 * u E r- Q\ Q\ 1 r( .r (3 E c 2 3 R 0 2 L, bl 4 Q J kl 4 k t! 2 $ 8 6 3 E s T T * % 4 R s g 4 0 % 0 4 bl 3 E 8 0 @ 4 e ak E * g 5" og dg I4 'i: W E3 E 2 L u g 11 EO YY 3 81 u+ 5 8 w .s L 5L c + 1s 4s EE 8 2 .L 5 5 8 wi 31 s 11 2 E s 3 .L h L v1 $1 \ 4 z $ 2 0 0 0 0 0 Q V 0 0 9 0 8 0 0 0 0 0 4 P2 00 : 0 '? VI 00 d -* t- R s2 3 3 0 3 0 N 2- m v, s', v, v, 0.. 3 o\ 2- d N ", 3 m E- a u 00 vi o! W o! 10 v, P \D t- 00, c\1 0 \D 2- vi H m m 0 0 x 00 m m 0, 3 m 3 00- h t" N m 0 P 2 2 P m 3 m 2 w 09 v, 0 cci m a 2 t; '", ?. 3 v, t- \D * * t" 0 -, a., m 00 m d * t" \D P P* *, v, m z 2 * 00 s m \d 3 N \c' 3 In N N m "* e 3 2 2- N v, 0 N 2 2 N vi 3 00 3 * t- 10 00, \D * :* :- 3 v, 8 00 IA \? W \9 10 P 0 3 t' m m 2 P" 0 2- 3 m 2 t"" 0 3 3 2 e- m 0 2 3 o\ t; t"" 0 2- 3 5 J 0 vi h! \n 2 00 3 3 3 N N \D o\ ", s N m :* N t"- 3 N N \D m M 2- N cci :* N t-, 3 @ 9 CA $1 d \3 01 In 01 2/ t" $1 00 s( P $1 00 m N 3 m N 3 u b % !2 4 s '? CCI 3 IA s 3 3 o! vi m m 00, 3 Dl :- FA 2 2- 0 m o\ FA '", 3 0 00 0, 0, 3 t- .-( 0 N FA 0 N 2 2 10 o\ FA 3 00 OI 2- OI 3 3 0 N 63 3 s E a ,e 0 Exhi 0 0 k 0 a * z 3 z E m * g E n 2 8 3 i? 3 2 b Q\ z rl H) 4. b 0 z 2 3 2 N E k 0 6 8 @ ? 5 c3 k e b 2 2 i;, & Q 3 5 e s k 0 k 0 i Q 40 ssssssss g?s\s~~? 51 s 0 s "2GN a3 0 0 0 s 2 c1 Oa*mhF,mm 000h h -F")h0N00 4 % r p El 2 '0 2 :* 3 3 r- r-" m O0- 2- t"* g* ;- 2- 2 g m m 3 mwm3 3 0 69 N 2""" 2 3 2- '", t 0- FNm m 3 N 10 rn-2 ~~\OaoCl v)mw N s '"" r-, 2 v; ") * N m3 P 69 d " H %I 2 3 8 + (? a a 0 M m a a 0; 2 m M rc) * m* :- N \O o\ 3 h a" m- 3 N a 0 01 r- \D N * m 69 m mn 00, s LC N ? -I & + z 2 a E 1 s a 0 g \=, 2 00, v) m 0 3 2 h N 00 0 0 00 0 c? N" Y 0 0 r-* 3 00 2 3 h 2 F" '", 2 0 N M c;- N r', 3 $1 03 N 3 a * F e, 2 N^ s FA s 0 m 09 L G !~8S8i%L3gg u z b%z 32 2 k g e 2 s 0 0 Exhib it z 0, m2 -1 2 5 0 u Q d w F 9% *e & 2s .. $4 X' am OS g: $2 0 Li LL ALL WJ - 3 %3 4 - - 1) -3 7 t t, -Q - L a - h - t -03 \ r - - * -0 0 -3 7 -2 - - - - - L - - (D -0) - F - - -8 U - d - v) Q) v c\ ~N~cc)Q)ao~cr,ro I 1 2 fbcdcd u5uiuiuiuj 0 0 Exhibit 4 d) E 0 0 G A u H 2 0 2 'W + 4 c6 E 9 u n m ce 0 d) c, 8 z F4 00 rn 3 h r\ rn I VI E s 0 a d) m c, W 1 I I 4 I C I .) 2 I I I I v el 0 00 (D * el 0 r r r 0 0 Exhib i c mmomwmmo OOOOO~ mhm % jll mmoNw*No omN-.mb em- 5 2 ; ; E%% 8 %%E E5 LiSslR8ZZ8 28S898 710.- u) --.-tmmr-bt- wbmm~~m N" eo E* -OrNrror -NO o bmm N '1 -. 0. $ a. '0. '0. I- vei - N"NN;N;pj GhlrrNr "C x rNr -rr 2 .g sg 0 g sss s sss g ZA ". a? N- 9 9 '9 9 a f "2 rn?? 2 2:: LD(9N?L"(9?0 L"00000 2;: h WWN 0 NhV) r '??t 0 N'40 r-4 hh a *-~-m-?mln--h--. m.rnm-0-m-m- mmm- L- ;. ;- 8 -. '9 '9 -om In h. 23 oo*o-y-r.r' t9-N-l" hl maom-mmoooowo-m mP-m om~m~~m-oommoo~w (9'7': 5 iddtiu5diOOniPidOdti NNwmoohu --mumu EXk N' m~m N-w Ic mmw m *-m.~.o.w--.b-h- rn------arm- N.'IN- A 27. U-0 0 NhO % bh-hN10WN -0WW-0 LDaN N- = 81 z-2::q-s ammzgm zuc * m* o -Nw owe x mmu hmm " N N * ssssssss ssssss sss s E* ooomomo- ~ooooe OON u~t000m-t~ qombm moo m m w E8i? k ZEG g= wLDrJwwa10LD 10Iowwwro www x g $0 6%8-%8*%%%. %%-%%e% gge Z g!= m. m- m- m- m- q w. hmm N m-7 N --m*o-mm-w.qo?*. r--..-.rn---m- w-w-w- % Z 21 momw-mmDlc mmwb-m mcum 0 00'4 N 00Y 0 LD0?000"0 0LDQ?0N? "0" o oooooooo oowomm ooo a 2 'PP 22 $22 2 $22 :%I ?cqY"YkY Yrn00?(9 L""? z em- UY m-- o? mmm N mmo .- 5 0- m m- m m- m ** 10. 7 9 OON 0 0010 h 00 0 .- W8888ZS8 ESZ8ZZ 686 -- x? 2 000 N 0-c) N - r Nrr- N - -7 - r m " c N E ssssssss ssssss sss sss g sss g 0"0NYN? ??Y0?rn y?$ "(9% 0 ""(9 2 g q 88%888:48 %8E888 8EE OLD10 Oh" 0 00 ooc Ln g " LDLDWWWh1010 10LD10wLDLD LOLDLD 0 10Lo10 0 I 00000000 .- m 00000000 ssxgss 888 rr > (00000000 000000 000 x v) z- 000 0 0010 u) d 90~9~.9~.0~0. 990.0-99 0.90- v) z 22 00000000 000000 000 8 000 0 000 000 0 000 0 0 b 00000000 000000 000 9 rNr t TF7 9 9 9 0- 9 9 9 9 L". 10. 9 9 9 9 9 0- 9 9 00 00 0 ? ~ n.1 mooooooo oooooo ooo m- - 000 0 000 0 00 a, ~~.RQ.~~.$g. 9E"95$.$ 999 c! NN z P u) wh r- h h a 0 Esssssgs ~Fas& 5s~ P- I. ; - ail >Qzxzzyz 5??2gS kgz2 P C $? 2 m z., ? 2 z ._ v 0 29 P m m 0-6 m mN JJ 5% jwa w eSm -ww w3= 5 f ss8 cz $2 gsa hh zz ?5 -= 0~3~~omm $5 Go 322 _I _I . .- hmm 4:: h xi 2%- 522 P Y s$$ssz2$ ?:go:E Nqe 200 w 55s c $p4$xT3G5s 29NO 10ro:b$ S%S sgg 2 SSG g 1 cn W;y:nnW 23wwssd2 Ep2w 52z gss 4 33m ww2 K n>-301o n gw3:n3 Taw W gsKn~':gq z~n-~n a%2 >>> = ss2 K 3sWhm"o 3$sJgg E?; $55 Y $Ss g $~~gGb:~ ZRE~,? wm mmm 2 $2: U %%y," $Mg~ zz2 $45 nnn A K g${ 2 3~z~nnlz all<Az sa: ++I- n aa rn m EESEP8EE EEEZEE EEE mmm 333 9 332 a . IC W'3W 101010 nnw I- 3 odw&ww LD n n -I I U # 2dFd5526 522226 $52 EKE ++I- 0 P zza oou d IC 3 rig II 5 a r . (L 22 m 2 c 0 25 gz $ I- $@ qPPp$qPP ammoom qee ommmm~mm mmmo-m N-O, NbTbLDrar GiiG>?ii '000 I 000-0000 000-00 0" IC~ICIC~.~~P- ~cr.lchlclc hclclc m m 261 S$8nsgs2 $zszwg 222 pl gggggggg gggggg gjg s h ... ??e$P??$ ?P?PPP mmm - zzcgz2sz gggkzz g$S 3 - 3 S U 3nw Zil" hhhhhhbb hhhhhh hhh a: n @j F!PPPPPPP PPPPPP PQP 1 5 P :m 2 U v) P ,"+@ :$38888Zz ;?88g8z(L..? I- Z2d; gggggggg ggggggA&mg = g ClL cn I- 43 3 I- n 2 -1 2 w hhh h bhh TI-.? P?? P P?? 222 2 22: sa2 $ $22 [L 666 2 888 s 3 000 0 000 ma- IC N~)(o m m mmm mmm - ee. x2e w h a &% n @ rr a g [L W L I- I-m 0 Y 25 -1 *3 2: 2 '3 7 ucn e m ? Q v P- O h m m 7 IY W I- [L U 3 br!g g rr @a n $?%2 2 z g@ e #&?j g 3F P LL 1w 912 g -I h m .- m [L W I- K U z ;K: n $,& a #g $ I- gP :$I "< E u1 0 e Exh - r v h r " mmm-mwtm~~-mm(~(~mm~t.rt.~o~m~~mm(~(~oo~m~m(~mo~~m~t.t.t.t.~ I v) ~F~s~~.~aza~.~~s~.~a~ss~.~~-~~~~~~~~.~.~~.~~~~.~-~.~.~~~~~-~.~~~-~ gij - 7 "? "? 7 " "7 "? "7""""- I- %Xff~$~X$8~XsR~X8~~~~~~~~~~~~~XX~~~~~2XXX~~X~XX~X~ mm~mmoomommmoooomt.mm~~(~mowmt.oooom~mt.mooom~mooo~mo $2 momot.-mCmmmNoPPot.mrn~~~ti*~;~~N~~~~~~;~~~~~ti~~ti~~~~ ~m~m-~m(~mtmrm~ooooom~m(~~mmmm~ooommmmmooomomooommo (~~~~~~o.~~~~~~m~m~~~o~t.~m~t.~o.qm~t.~q~~~mu~(~mt.mooumum~~~oomomooommm mmm~t.m~mt.trbm~~~m~m~mm~om~mmmmmwmomm~mot.mmomu~omo z 21 ~~N~O~O~O~N~~~O~O~~~O~~~(D~~~r~t.~O~-~N~N~N~N~~~~~~~~~ONNPNNr~rrOt.NN~~(DW~N~ 9; -mrrrr N-N-U~NOY-NN~~Y-." -"--.N-N-r-r-;N.r-r-r-;;-.--N-N"-;- z ~mt.mmommommmoooomt.mm~~(~~o(~muuomomt.~t.mooom~mooouma mm~mu~t.tmmm-oooo(~rmt.~(~(~mmmt.mom~om(~~mooomm~mo~o~ma ~~~did~~~wdi~d00~im~~w~d0diw~~~0~~0~i000~~~000~~0 (~~~t.mt.m--~~t.mt.o~t~~(~~(~uom~mmmmmommm~~~t.~o~muoo~ma o~~.~.m~~~~~m~~.~~~~w~t.~m.t.~o~t..m~t.~u.t.~-.m~t..m.-~(~.-.(~~-~~~m.~~o.o.t~o.m.m.m.~~~~~~~-.o.o~-~m~~ 81 ~~m~~~m~~t.~(~~u~~m(~m~(~mmt.t.t.mm(~oomt.(~(~~~mt.~~~wt.(~m~mm~ ~ m~wt.~~~tmt~~mw~~mt.m~mm(~-m~mmmoo(~momm-mm~~wmm~-mma m rN m Pam z -NNNNN-rrr mmmNNr-mrrOONN-(D(DNNm z SSS~SSsSSSSSSSSS~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ I- (Dm~mmmmmmmdd~ddddddddddddd~d~dd~(Dwdd(Dd(Dddmd(D~dw(D~ ; KW $g8~$8B~8$~$~~$~~~~8~gg~~g~~~~~~~~~~$$~~~~~~~~~g~ 2 il ~~~~-~~mmmmt.P~~cm--o-~~m~om~ooou~mt.m~(~~~(~~m~~~~~~ . . . . . . . . . . ~ooooo~ooooooooowooooooaoo~~~o~oao~oooooooooooooo -~~cN~~~~~n~oo~w~oo,o(DN~~~~~~~~~~~~~~~~~~~~~~~~~~ (~m~om~m~~m~mooowmoomom~-~m.o~o.m.o~-~m.~.o~~~m~m~-.-~m~(~.~.t.~m.m~m.m.o~m.o~o ~~~~~d~dmdddooo~doodo~m~o~mm~~~ommm~~~~~~~~~mo~oo f82~88~8~8~~8888a88~8~~mo?~~~~?o~o~o~oo~ooooaoooo ~.ssssss~ssess~sess~s~.~s~.~s~~~~~.~sss~~~~~~~.~s~.~~.~~ 1 I/ za rN r r PmNNrrNrr -r Nr r r " rNr" 00000000000000000000000000ut000000000000000000000 00000000000000000000000000t.t.000000000000000000000 00000000000000000000000000NN000000000000000000000 oooooooooooooooooooooooooommooooooooooooooooooooo oooooooooooooooooooooooooommoooooooo(Doot.ooooooooo ~~o~o~o.o.o.mt.o~o~o~o~~.t.~o.o~~~o~o~o~o~o.o~~.o.o~u~ooo-oooomoot.ooooooooo $8 8, q 00000000000000000000000000~~000000000000000000000 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- a- 0- 0- 0. 0- w- a- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0 ;% > rm"" NrNrPmNmrrNN""" ;;;NN;;;;;;;;;;;NN;;- co $2 Ex "2 2% C v) I/ - g 0 2 s c .- 'a e ZP IC OF t. S '4 e m mm -1~ LW I r s SZ t. ww 2s s s 0 e t.~) +e- ,.,.kaaa se mm zkss ZbT mmseee 2Z k-2 522 Sm t. (D s >w** 23aMRWt. 2;%5<< Em?1 <I$ l@!e g .gs5 P 2 :$$s c-~73*a2~::>eCJl. lrmm -I203 y <zxl O~W~3221~l~~ma =SVV $;$< 0b2,Z t:~ 0ow~~~%2mse~~~a~~%%~~eee~m~ zg;zFrn,meNm mop~,,,NNNooemm5ZZc~m~oNoNo2~~~-~o'l ,ammego oNego~~~ "ZmJ ~sSSms~S~3~~~~mt.~ms~~~~zs~ee-r-o m-~~z~a5o2g~~g*2 S=C~S=S~oSQOFS~~~QSO---nm===n~nn=~o= O==JQ~~~~Z-Q: <rG? "-lb$ &JJO JJl<<<jiW+,ZZ JJJOO ikk? Oppi ZVJJJ bJr QJN 6 ojclcl za" ,z zmsog& s~ouea<m,~~s~,,q4~~~~~zZ *~m~mmmm~mm-I00ornrnmm ajrro aozgo~p~i $53,;. MX~~4~w~P"~~~g~$w~~~SS~w~sZZm*m swiinwzc$zzSzn ~n=on~NNN~dwww~~~~~~<~~~~~z~~~~~~~~ rr.--Tzg~=W~==~omNa~ loozzmo '4~E~~z~~E~~&~~KISs~B~++~ZsS~t.N~~Swt.So~S~:S~$2Qs~~ ~O~go~~~~~mon~Ss,~~oa~~~~nn~ IzIIu-IIIIzIIIzzzIIlzzzzzluuIIxlIzzI~zIIxI~>zIzz~ uuuuu~uuuuuuuuuuuuu~uuuuu~uuuuu*uuuuuuuuuuu+u~uuu v) **Pdoomm oummmm~dd~~Zdz~~~~~~~~~%~~~~~~~~~~~~~~ SSss~ri~~ssS~ss~SSs~~SSS~SS~~sss~~SS~~S~~~s~~Ss~Ss $1 6666666666666666~6666666666~6666~6666666~666666~6 I- C Peee~PeeeeeeeeePeeee~eeeeeeeeeeee~~es~~~s~s~~~~ss ZW 222ZZ==2=~~=s~=cZ222222==~~Z===o~s==2===Zs=:-2~:= ~mmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmoooooooooooooo~~ ~mm~mmwmm~mmmmm-mu~~~~~omm--~mm~t.~~m~omm~~m-co~~o 2 51 !i 81 mNN ml9P)UUOln kt. mmz---NN~ mmm-w ~mmumm z"" r 7 r 2 w(Dw(D(Dmt.t.~Cmt.mmm~Ct.t.(Du~Pw(Dt.PP~PPmt.t.t.t.t.CCt.m(D(Dt.mmww(D mmm~~mm~w-t.u-mm-~u~o-~~-~mm~~mm-om~o-o~~m~m~~om~o gF ~Z~~~~s=Z~~23~~p22~22~~~=:Z~Z==~~s==~=2=2=:m-2:=~ - at. ~-P-COWWN-- NN m om t. mm u-mmr -- -- 5 e?eeeeecPPeeeeP?e??Peee?~P~??ePeeee~eeee?P~eeee~~ -7 r r r > z e e E aqm.rn-qqkqqqk 2. ~~~SS~SSS~~~~S~~~~S~~ B RS Z Nlnmln"+ kgz2cE8kfi8 * mmONloNNNmNNNmlnlnr-Nm-Nm 0 IC0 N lnhmmPmln g&""""- r r rrr 02- - 0 - 0 m. " N. C9 F %?~8S~v?zz> 2 ?~?~cqmqm~q?q~?qhqN~h? p. X8 2 NcqoqmkN z%fiwg$ggw$$g 8 s~~~~g~~B~~~~aa~~%~~~ ; 22 2 ;;:$-$Yj ~~~2z.~2~2zz~. g- x;~.999~.~.9~.z.9;~~x2~2x2 ;. z.5 g. ;-z.z.;z.2; gK O~~O~O~QQN t o~~~~mwrn~)rrr~oorn~~~~o e 00 0 NKMO~~~N z ommommPmmm oO ~mmo~~~~mr--lnlnlnmr--ooo ~~Zr""r.oqm-m---p a- N.c-~.--~P-PP~-----~-~.~-~N--~-Nc loON-mNNNNmm~mttOmCN~lo 8 00 0 PWm0m-P r-mmommrc 0 r m omr-mmomam~ V) o~~mmmomm-rrmloommrcrmo m X? g N~P)O~)L~N ~oommo~ammm $ ~J~$~Jg~~;~ k 9~k9kC.o~ON.oO.m~UkqP.C.9o 5 ZZ. 0 Oc9W.m.ru9,q ~mmroooomlnlnlomlnloomlnmr-lo r ot ln omorbma pg~g~~$;$~~ k ~r~mmmm~m~~m~~mm~g~~~ g cm m kmmz.-gz ?rn??99h??nr: m "hq?1-?9~?qmNNmN919~0 '? t-om~mm~~oo~ ~~~~~~~~~~~~~~~~~~~~~ 7 00 8 b-~g$w& "???r'F! I '9 m +C$g?ggzggg g gg~gg~gzg~~~g~~g~~~g~ -g ss g sssssss 3ilrm7?momyyo m ~~~pm~mm~oooooo~~""~~ 6 $5 g G:gG$:q rrmoo~ r ~ma~o~-mommlnmo-oowlomm 00 OON~OOO I- (91om(9wmmwwW ln lnlnlolnlnlnlnlnlnm~mwmmlnlnmmwm Lo loln ln lomlnlnlnaln E OOONOOOOOO p 8zg;;gfgggg 3 ~~~~~~$~~~$~~~;;a~awss m 9999999990. m ~t~~~lnmoooo~~olnooomo~ - 00 o ooooooo lncom~r-mooooo~m~~~~~oo 7 CJ; p. oooooo.o IU$999?*.O.*.b.O.N. ~O-O-~r.mqq~~-.~?O-m.C.lo~N.~ m mP o lnCwommP P olnooooo +3000tmNwmom 2 lomd~~-N-mCcmmmamlnmNPm " my m- m.m-".km-N-m- ~ogs8~ss8.~.s8.8. % ~s688.sxxsssssss8.8.8-8.s.e 2 %?% f gzJg2z=g 2 2.:- E. mYo-o.0.o.m. >EN r Nr rN m ."P."--- 24: m rNNNrr-r """ k g w K I- z w I c b z h m sssggssses s 888888888888888888888 O O0 O ooooooo c ugg-gg-ggggg-g g 000000000000000000000 dddddood~ooddddo~oddd g 99 g 9999999 0.90.0~0~~99~0~90.~9~~0.00.0.0~ x 88. s 8.888.8g8 v) nao-o.o.o-o.o-o-o~o~o- '4 ~~~~~~~~~.~.~.~~~.~~~.~.o.o~~~~~o.o.o~o~o. 0- 0-0- 0- o-~~.o-o-o.o-o-I a~oooooooooo 2 888888888888888888888 8 88 8 8888888! 3 >N----Nr--N P NNt-"""rrNmmNr"N~ 0 PN w ".-N"N, 2 a 5 00 0000000 c ~~o~ooooooooo m m d < 3 z z 8 E k3 0 3 # < m Lo 3 Lo 3 0) J 7 2 3j mzz w m3ssg mm A. r $e wI.5; J . 5g; Y 4Nz. f z $:mi &sg,sasjoo; ................m 8: 4 'D y&03$! =es$;3jgss$ mmomonmmommmmmmo~,~4~ 0 3 o.i~Z! ::FiaFiaaa~~~s~G3~~-asz~ z ;:z2pjgsaa: wwwwwwwwwwwwwuww~~ww~ fs x szzzy Jcmgsi=OoQ 3333333333333333 m33* zG3 :&igps$$g psssbsssssssssss3wss~ 5s -"":kg; -z-gzsw22- LomNNNNNNCCr-Cl.OoN ww-----~cqcq~~moo-~~~~g w: ,wlrm?$g! S;spyZ;;Y +Cmmammmlololnlnduidd am 23 NN21fos33n ~~&&~&&&~&&~&&&&~~&~~ 0s IO OTYO~CO~( 5;zgd9"""- r- ddr-: mm3333333~3~3333&&33~ $3$$$$$$$$$$$$$$33$$ 38 &&Zj-lWO "zs2Eg! T:;f;sP< 6 "ma 0 *lg 3 og:fa<<z e=j=a ggggggggggg$3gggg -0 i r """"00000"r w =os:: Or-EWL g$cq3eznt 232% w3+asnlnn, uo03r-0n[ bawm-u, ooooooooooooo~oo~~oow lnloln~lnlnlolnlnlnlololo~~lna31noo ~~;gz~~-nas k;Kb I.;:ssz maaugagaaa ~~~~~~~~~~~~~~~~~~~~~ ;g IZZZIZIZZZ ua mLommmmmmmLommLommmnummn ULLUULLUUULLLL 3333~3333333333~CC3~C w3 HO SSZSEZEi zo a zW~",a; -IIE2_rHJIHH !!1aaaaaa<aaa ~~C~CCCCC~CCCCI-CCCCCC an g 4688644884 $$$$$$$$$$$$$$$$$$8~~ CC ~~~~~~~rOOOOOrrrrOOrO 4$ 20 I- 8E86886666 ..................... Wlc gwNmmloC:a22s :=Fi=Nr~N=~~~P2~===2sq $2 - z I- >uuuuuuuuuu n~n~nnn~nnun~n~nnn~nn 00 zzzzzzz; 0000000( """.-NNN mmmmmmmmmmmmmmmmmmrr~ - w~mor?+rcom~ hr-r-~b~mc $$$$$$$S gp~?&:g; p~pppppprnprnrnrnmyrnrnrnmy~ "000000t~fft~~~N~~Of 82 ro yc85r;;r: oorrll)rO)( i 51 r " 0,""". " r I CWCr-CCCr-WCCWCr-CCfCr-CW ~!g~$ommPPN momo-~~~mnmm~--o~ln-~o mm mmmmmmmc N~W(OOPI-P sFi63Fis23; rNrrrN.c 33a:ss-: z ..I....... m- NN - mmmmmm lnln"Pln P 0 e A 7 v m~~m~~mtntn-t~rmm~)m~)rt~o~)m~od~-tr~) m -rrr- s ,sa~.s~~~s8.a~s~~~.~.~.~a~~.~~~~~~~~~~ q Eij - rrrr rr """r""rrr"r r ~ ~~~"~"N~~0~0""~00~~-99"9ys949' Fj Gy?sg 4 x ~~~~bowrt~-o~w~oofmt~o~~oo~~om~ ~=~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 2 s?%!zk2 $ z gK h ~>mh~)mb~)~)rr~bmmmom~~modtn~mm~motnh-t ~~~-m.~.m.o-o.r.h~~~d~-h.~.dh.~-do~~~m.h.o~m~~~~~m~~~~.~.b.b. 0. c9m-N.m.o- a- -t. mCmqN.~~O.~m.N.P.-.NN.r-m.~N~tn.Nd.~U)~~m.N.-t.-t.-.m. $ %.?gg.g. g 8 wwNrr-rrrNrN-~U)rrrrNNrrN rNrrrrNr Y rrhNU) m N P0rr.r c m- a~~~~~a~~s~8~ssss~~~~s~~~~~~~~~ 7 sg:%s 5 $ ~~S~~~~~sa~~8~6=~~aO~~~8~~~8~~8~ 7 g[;$cog 8 2 ror~~~~~.~~-.h.h.w.~)~h.~)~m~~-~m~m~h~o~~~~)~o.-t~tn.~.~.tn.-t. m- -NN.~o- 0- m- 0. ~m~)dd~-tn~-tnmhm~~)o-dtntntn~hdom-h--~mtnw U) W~tn~~~wrr-h~m~mmtnrm~~oo~~mmm~dmd :I - -i" o z mmNm-N--.-NNNttnNOU)rm~mNmmdm 0- N "0-t P N m rr 7 z ............................... $ $$$f$ 2 5 1~l~$%~~~~~~~~39~~~~3~~$~~~~~~~~~~ z p$$$ 2 $ W a 8888888888888888888888~88888~88 N CYdOtnO N d ~ooooO~OoooOoOdOoOo~oo~OoooO~~o lz! a~~~om~~~o~~mooorr~tomrNmmNm~~~mh 2 -molco N In u?zgzx 4 2 ~~~~~~~.~~m~.~~~~-t.~.-.~~~.~~y~~~~m~~~~~)~m~m~~)~m~~~m~o.m.~).m. -t- -.~--o.-.o- q 0- Cn=8~8~fi~586~88~6~6z8a~5g~~~~~~~~~ IC PlnOlcO I. tn w~~qo.qqmmqo.o.mq-.o.o.o~qo~~m~~~m~mqo.-.~m 4 WxE.S.s G. Z. >Hru-rrr N-N dtnrrr-~~ rr r rr-r m za rrhN(D z 5 N - lo 0000000000000000000000000000000 cb ooooooooooooooooooooooooooooooo 8 x;4;8 2 2 2; ~~$g~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ E $%8&8 g r-& K % wsx8.8.8.8.8.8~8.8.8~x8.88.8~xx~~8z.x8.8.8~88~~~~ 8 gz.gRz. 2. %. tn -g 0000000000000000000000000000000 O mPolno P4 O w v) na-~~~~.~.~.~.~.~~~.~~~~~~~.~~~~~~~~~~~~~~~~.~~.~~~~~~~~~~~~~~ m- N.P--.N.w. 2- *. pz= >~-r-rr-~r~rtm- --NN--N r~-~-~~~ m NU) La 2 W F v) W > z - 3 Q: c- p9 b z (DU) d J _I ee d mm + ,5, 9co gs 25 $9 CEO a;g $In + m Cnsg Io+ ajz 3s 03 :$ 8; C4w 022 OF E6 nz 3 <_I m Q: _I 02 J _I ss 2, ?I -7 ~2 j Q:o $2 O_I_IZ 4" 2 $ 2: zz 82dOV ?!00Z$ Log ;<z., v z $g$ $2 F$$gg gp $$ Zm8 Z$ZZ$kk 300-NOOZ~2 ;gg$~ssosw SEL%.d,y$~=gccrnw h+sw+s s:1Dor- ~,o~o~zooss~Q:~~ ,3=3gy tn'm,~Q'oNNmhtntnd3WW~s~ ~~~+,~~~~9~~z~2~g~~~~f %2PW%PZZ,,,, mZE~~~~mmmKm~~~U)m~~~ *zzqal'l'+ o+z+-lp y<q< ~~-,-oaaoa++momm Io3$'Goa-zzw ,,00:~8:!i ~~azooo,~oo3~33~~5~3nz s~&I~%~~%YY8%8gy~B88~~ I~aau~m~m00K~~a~~uz~a~ ;cs szs==mmmnooz$$~-w oN$hrnrn$ss+?2?7=Q3g <,,~~00_qoas~~~i~0tns~m 00 &&-d%N 0 0 ?! $1 r wd 22s $22 azs i6- tss A:$ %so <?E 2: $0' aoJ Fg3 am+ zam 000 TO.- am? -100 rBN QZQ N '.'N 010 ZgQQ WgWN 202: ggg2 rm?$ &E&? 2$!28 S68f marc, z+zm 2 L 3 0 + z 3 0 0 0 a !?g i$ 8 8, S+S$ rzz>_I Q0WW ammoa ZsaWk w+Eg> ZI+QE 3;gg !?:e:: Am--- woaQ:Q: 30_I_IJ 2 L 2 0 2 0 c z Q K (3 n ~~00000000ooo00000uuuo00000o0o000 ~zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz 00000 C c~c~ecc~ccceceQ~~~~QQQQQ~~QQ~~g a~===sN2?=Ac~=aQce=====zz~c~~=:~~?! mmmmmmmmmmmm~mooooooor~~~rrr~~~ -tn~-h-tntntn-tnmmtnmNNtntntn-~tntn=~m--r~ 2 61 NNU) m $! m cmmmmtntnamor ~m tcmr m r I 5 ~~cee~eeccce~ce~~ccce~~eceee~ee w,~~~~Rr~~~~~==~kmc=g~~~~a~omoN-tP 80 ~hm~)~)~~m~~)~tntnhtn~)~amh~)~)h~)hmlcm~hh .... rn.~=U).dN..mr~..-...~~~N~=~ ~~1 mm~p P z v rlcm 2- mar- m rtnn~1-t z r > - 0 0. $ s E 2 U - 7 v e e ExhiI Reconciliation of Fund Source to Investment Portfolio AS OF AUGUST 31,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 21,448,328 15,332,656 3,024,508 4,780,201 3,620,728 15,854,555 4,867,782 50,900,277 26,048,773 30,381,043 1,228,545 2,263,553 59,921,913 9,976,672 9,895,065 0 Total General Ledger Balance 199,622,686 Amortization of discounts and premiums Deposits in transit Outstanding checks Wire in/(out) not recorded Other Net adjustments per bank statement (38,439) 1,570,812 Total adjustments 1,532,372 Total Treasurer's Investment Portfolio 201 ,I 55,058 (1) Redevelopment Fund Balances are interspersed throughout all funds. ** Figures based on best estimate at the time report run on 9/15/97. e e Exhibit CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF AUGUST 31,1997 CORPORATE NOTE AND COMMERCIAL 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 GENERAL ELECTRIC CREDIT KENTUCKY UTILITIES MERRILL LYNCH NATIONAL RURAL UTILITIES NORWEST PROCTOR & GAMBLE ST PAUL CO TOYOTA TRAVELERS GROUP INC WAL-MART STORES WISCONSIN ELECTRIC AA3 AA2 AA3 AAA AA3 AAA AA2 AA3 AA3 AA3 AA2 AA3 AAA AA3 '4.42 AA2 AA- AA- AA- AAA AA- AAA AA- AA- AA AA- AA AA AAA AA- AA AA+ 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 bv both Moody'sand S&P\ DUPONT MERRILL LYNCH Al+ P1 Al+ P1 Other Debt: AA3lAA- Other Debt: AA3IAA- Investments Made Under a Previous Investment Policy (Ratings must be A or better) Prior to 2/13/96 Moody's sap FORD MOTORS CREDIT A1 A+ SOUTHERN CALIF ED AI A+ Investments with Subsequent Changes in Credit Rating * Maturity Carrying Moody's sap Date Purchased & DIGITAL EQUIP BA1 BB-t- 11/15/97 A21A- 1,003,283 DONNELLY A1 A+ 12/01/00 AA3lAA- 1,101,645 DUKE ENERGY AA3 A+ 04/01/99 AA2IAA- 2,027,929 * 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. a OF CARLSBAD INVESTMENT PORTFO a Exhibit AS OF AUGUST 31,1997 PERCENTAGE WIGHTINGS BY CORPORATE NOTE ISSUER Investments Meeting the Current Investment Policy (Percentape Less Than so/) ASSOCIATES COW NA BANCONE CAMPBELLS SOUP DETROIT SEWER DIGITAL EQUIP DONNELLY DUKE POWER DUPONT FCC NATIONAL BANK FORD MOTORS CREDIT FRANKLIN UNVL TRUSTS GENERAL ELECTRIC CREDIT KENTUCKY UTILITIES NATIONAL RURAL UTILITIES NORWEST MERRLIL LYNCH PROCTOR & GAMBLE SOUTHERN CALIF ED ST PAUL CO TOYOTA TRAVELERS GROUP INC WAL-MART STORES WISCONSIN ELECTRIC Investment Cost 8,039,266.00 997,870.00 2,062,700.00 1,014,980.00 1,053,390.00 1,145,610.00 2,048,020.00 1,945,244.44 975,690.00 1,957,160.00 998,750.00 9,108,300.00 2,024,340.00 3,019,970.00 8,729,459.00 4,364,745.50 2,256,561.60 1,000,000.00 2,042,260.00 5,530,503.57 1,105,341.85 2,491,325.00 1,000,560.00 Pertent of Portfolio 4.00% 0.50% 1.03% 0.50% 0.52% 0.57% 1.02% 0.97% 0.49% 0.97% 0.50% 4.53% 1.01% 1.50% 4.34% 2.17% 1.12% 0.50% 1.02% 2.75% 0.55% 1.24% 0.50% Investments Made Under a Previous Investment Policy (Pertentage Limited to loo/) Prior to 2/13/96 Investment Cost N/A Percent of Portfolio Total Portfolio $201,155,058.46