Loading...
HomeMy WebLinkAbout1997-08-05; City Council; 14290; REPORT ON CITY INVESTMENTS AS OF JUNE 30, 1997*. 37 ,. TG. 8/05/97 REPORT ON CITY INVESTMENTS AS OF JUNE 30,1997 Accept and file report. 1 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 June 30, 1997 is as follows: Investment Portfolio (Cash and Securities) 1 Current Month Prior Month Par Value 195,340,751 199,841,727 a 0 fL E !2 Cost of Investments 199,507,974 Amortized Cost (1) 195,051,685 199,483,871 194,024,901 198,842,797 Market Value (2) 195,037,097 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 6/30/97. Interest Income Current Current Income Month FYTD Month FYTD Month Prior Cash Income Fiscal 747,142 11,807,732 12,554,874 Year-to-Date Total Income Over The Life 28,991,765 30,302,099 Of The Investment If Held To Maturity ..* \. 0 0 PAGE TWO OF AGENDA BILL NO. Hi 390 Investment Performance I Average Life [Years) Average Yield Apr 1997 5.90c 1.55 Jun 1997 5.87c 1.53 May 1997 5.839 1.52 I All investments have been made in accordance with the City’s Investment Policy adopted Jan 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 chanc the City’s Investment Policy or a change in the credit rating subsequent to a purchase. See Ex 8 and 9 for details. Investment portfolio has the ability to meet the City’s cash flow demands for the next six months. 2, 1985 and last revised September IO, 1996. All investments were initially made in accord: EXHIBITS: 1. 2. 3. 4. 5. 6.. 7. 8. 9. 10. 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 Second Quarter Transactions Investment Report Reconciliation of Fund Source to Investment Portfolio Corporate Note Ratings Percentage Weightings By Corporate Note Issuer Investments Held Separately - Quarterly Report I \. 0 0 Exhit 0 0 5i E 2 0 n b z b > z 3 n 2 3 3 H 1 * b E; b Q\ Q\ & 0- (3 2 P 8 2 3 2 0 !A Q Q 3 8 2 8 e 9 E & 3 I3 s 2 T T el % 4 9 k s g 4 E 0 N 0 a3 h E i! E9 0 8 9 J: i i 8% 9 83 82 -2 dg + E t 8 22 sa 42 32 5s 9 aL 8 5 cg 9 .; EE 6 n @% c, E L" L 9 d $& q WL 5 .s M 05 c) c e L 5 31 1 d z 2 0 0 0 0 0 e 0 0 9 0 8 0 0 0 0 0 2 00 2 00 vi 39 0 0 \o 2 :* vi 0 00 00, 30, n 3 v, I? 0 m vi P W., 00, P 00 9 d o\ 00.. V a d 2 o\ 2 i? 8 3 0 2 z- 2 CJ W 0 0 2 m 0, vr cc) N 0 wn m., 3 o\ \o m P d 2 \o d W 0'- b e: '0 2 0 2 00 d. 0, 2 :* d N 2- 2 d \o W P 3 00- 2 oi \o 00 \o :* :- * \o 00 0 2- 2 I? \o 2 3 3 d m 3 \d vi 0 a! d 00, R 3 00 \o m '0, 3 vi \o m '", 0'- G zt m 3 o', 3 3 :- vi 00 2 ** vi* 3 00 vi V z m K d K 3 a 2 m D., 3 3 5 P \o m P., d m :- 2 m., P d h 3 P \o m r- d o\ \o P "* -Jn m N tf: 5 vi d o! m K 00 00 \o 00 " m m 0 00 '", D* 3 CJ vi 3 m v? vr m m 3 00 U* 3 '0 N 3 x CJ Ei v1 5 21 v; =I v; 01 P q m 0 ;/ I+ 3 m 4 I? m ?J m ; c 0 3 6 m 5 I? \o 00 VI 5 00 m 2 d P- 3 3 vi 3 69 3 0 d m d o\ 63 0'- 0- 3 G 00, :* !2 d 3 e3 G :* m In m fff 0, 3 d I? 2 2 0 o\ 63 3 r/l 14 0 b r2 \. 0 0 Exhib 0 0 J rz 0 e3 kr- kz sz a bm 52 &g nk $0 qz r 8 8 E ij Eq s k 0 c5 4 E Ei e z 8 Q k Q 8 E! 2 k 2 T h 4 9 T k, ; 4 4 0 k Q Ll 0 b 2 s c;l 2 g s r- ". a 0 8 8 a 8 2 P c.l a d vi- :* $ 2 '". N t' d vi a, 2 m 8 2 m d 00 2 2 m W 8 2 c\l m 2 co- 3 :* m s r- 3 3 d m :* t' c'! m N & 2 N In 3 x N $1 a 3 cc) 0 3 s 2 3 0 H P 2 3 00 2 -1 .. e3 ma00 E s z2%oaa 0 a- 2- :- E- 2 g 3 s 3 c'1 Ped m * W vi :- 2 2 a* w -1 m1 ~ooOm~uOOo1 c4 + 0 e3 mcou 0 s 0 2- 2- 3 2 ;- co 2 ch- 9 2 Ocod CY m m mm 3 vi H -I E * s i3 E F 3 a 0 I? N a d '0, 2 P co :* 2 P rn d a. 2 2- m H C 30 Q\ m P r"., "* H d m :* P m -!, m N m 0 N Q* x !I rc) a 3 a P '0, o?. 0 3 01 3 w 3 s 3 3 vi b u q8i38Nuz3g zhk2 32 2 b u 0 b m 4 8 a .s 1) 0 0 Exhib z 0 m H pr; 4 3 0 0 cll n a H * 7 ViK F4 4 +m F4 * 35 A' az 22 Ad 22 z 0 L 1 k a b e F 6 c, I 3 7 L Q a a Q) \ F 6 c, v) e rnCVrCDG300bCBV) 6 (d(dcb ujuiuiuiuj e e Exhib \, 8 0 0 F1 A c6 H rn 0 d) > ow * 4 c6 E 3 u r- 6, L Q < I- Q, rn 7 & cb Q) I CI 8 CD Q, I - a 7 .~ e d Exhik ""OOCO"O oom*o*mm "rm00rOtr0 ddrodviduivi ddrddi 000w00hOhwa V)OU)NNN** ommaoo *. s.g.g.~om-o-*- ~vmoahma omm-mh -.0".-.0.-.~.0. ".-.'.N.*.N."" o.m"4w-.o. "mmPooN~~,o OODrOOOO 8:N=z!z r c.9 Y) :: 8 s Ex Ef5 g<, ;;;$X~~Xfi~~ XX3Hzez. x2zz;z :: F? :: 9 i.3 8.8.5 m- s r 2 8 00 zNN ; $ 000 ZK rrr~rr.-*rrr ""-on NNN Nr N- N' N' 2. z. z 0' - ~~~~9o~m"yq hm-r-nqru yh-qo- rrrn~~~orro wauum-~m WWNC~C :: - ~-z~g$qszkZzz 21::wogF?z 18681f 2 W 3 $ 8:: W2:8 c r mo 70 e??G 2 0 00- 0 e 0. 2.2. o 0. m. m.qo.m.*.-. Y*.Q.-.NCPN ~.o.-.w.'P-. X? $1 %s%~p~~z~$g W89W1140 XkIXBL 9 s pz pzz m. r NrN0N" mu?" .. - so ssc83%q2Eg: 88~E2~6:: %L%?G?: ggffgggggggfi z;Pgggggz gggggg ;e g 5 g gg +s;P i J $3 ggi $1 ~wwwawwmwca mwwwwwww Y)V)hWWW 8 5 e a p I- @ 4 - I r E 61 xxxqsxgsxsx -.h.-.-.0.-.h.m.-.a.L 6688$68386% 00mw000NOOD UmNlWwNNOhh mmmm~mommmm " n- " n- $$8$$8$8$8; ggggsaFgpo, ~wowowwow~w mNU)OmOmO 000000 NqNqcqrru? T99"99 h' d a- N' a- N- m m- $ z 8. 8- g 8 mhmaoomm *ammr.o.m.m. m.m.o.voo "NN "N N'" gEgsz$$F 5qgiqq 86($$6($88 8$8$8$ 2jSSE3333 $33222 m - m- Id W : $$ E:? m. >> 23: $ 2 33 ?$? 3 2 r: aa N" X " mmm 8 $8 $88 3 3s f2$ 0 0 x 2 ; W f f P OOOOOOOOOOO 00000000 OOOOOO O0*00000000 0000000O 000000 - ~.~.o.99999999 ooogggg8ggg 0.0.0.0.0.0.0.~ g888888g OOOOOO g-g-g.Z-g.8- t g 5 5 % zz !.E.! E p1 z3zzzz3z33z "9999999 z.z.z.:-"z.z. I $. $ p !.E. 499 x .z 0 00 ""-no -5 0 r E n 4 edl $$$$$$$$$$$ sgs66$44 44euee - zs5zzzEi --m--- "$Z$S $ $1 $$$ mm m hh h 00 0 00 1 - 6 h s n 5 0 N 0 - " 0.- sa E% Wd aamm gggg 0 m N ;Lo zam $2 c$cch 2-s 8 zag,pzz $ : p:gg;a4 w 3 ****J%g:SL zzzz $;!$;$gg sEg$$ E.nz.$:"""s 4'"' +'Do9 &&&&$;;%;& 03sq2;;; :tam zxlxl~2g$I$~-3 z$;P-*333 Q?5ipSs* ssssiasi;g3 uiscG5mmn u,N'$$ FEEEg$Egg$ g;pg@$ ZZT:,, hda5d JJJJg!!Jg!Z%J E$$gFf$$ :&$gz$ 1 ;;;;z ;$Ee$ s oaoo~o3x3zo ~zz;$Z:: gaggss 1 EEEE4SE355E SSittEEir BPStii h hh 6gg t ee sce s ;: ;;; J JJ 222 0 an s+s 5 $3 $33 > >> g;; hh n nn 33 3 $3 ;ss Inn 27s F *I- OFF J JJ 5J9 E $E z,EE : ; h . - 3 3 s J 5 2 2 6 c 4 ap .. mmmmr-omr-mNN mroom-ma &686%% 8 $ gzggfgs$$$g $g.ZSs22JJ 4:aas; h hh r-bh m I$ ??? 7 4s h h a;l 4cccc'c"c24 E556We"c gs$5gg 1 " 532 I s 00 I XXXXOX8868X ooo-088B " 0 00 0 "2 hhhhhhhhhhh s %& ~""CZ"c2c2 Szaaa$$$ $$$S'" s "' 8g"ooo OhhDm0 g g 2 mmmmmmmma?? ~ZGS~~G& 6~~%66 ' * 0- 6 6; 6 r ;o :* gql %a iisiizzsaa eeeeexzx&a S$$@$$$ eegsss 5 5 $$ 959 f f K ly K hhhhhhhh hhhhhh z g 2% 2 :" 2 p$ gj2 pl w 2 #j4 tqi $:e u; XXXs~X~~~XX :-"-:-":-"amma 00000000 llglss ; 2 00 i2ll 5 s r 9% 000 w kc m- 5 gsgeeepeppe mmmmmmmm mmmmmm Lz oooXXX'hh" 4"""' """ XXXX%XXX%XX 00000000 000088 :: B k 3 hChhhhhhhCh 2% E$& K $, L? 48 2 e$: n2ea4 v) )% v) %* P a K i t >, e 0 Exhil: - 7 v h r v mmmrmwtm-~w(Dr~-r~orm~~mw(Dwot~t~mo~~~rrrrrr~~~mwmr c rccr crc P ~rrrrrrr~r-crrrrrrrrrr-r-r~r gij I VI s~$s~~~a~~~.ssss~.s~~s~s~s~~.~~.~~~.~~~~.~.~s~.~~.~~~-~~~~~~~. ~m~~~moommooormm~~(~mo(~mroo~o~mrooom~moo~moomromomw om~m~oo~~ooo~~~~rw-~~m~oo~owmmooo~~~mootmoom(~ooor~ + wmmot~~omm~~o~m~~-~~od~ooo~o~~~~~od~~ood~oo~-o~o~o ~t~~rrm~~~~~wm~w~mm~-mrw(~w~~~-woommtmm~~m~~m~o(~~m~ EZ sa~.~.~N.%.~~-~~.~~s~~.a~.7.~~.~~.s.~~~~-~~.~~.~.~~~.~-~e.~.~~.~~.s-~.~.~~ tnb Y~.9~.e~.~~X~4X~~X~~~~.~~~~~~.~~~~~~~~.~~~.~.~~~~~~~~~~~~ F 51 I1 zd rNOOOOOOrNN~O"OOO~Oooooo"ooooorooo"oooroooo"o mmlow~~~~~~w~~~~lolo~olo~aa~~~~oa~~o~~~o~~o~o~~o~~a~~ gB 3 om~~~m~~~m~~~o~mm~~w~~wmto~ror~~ooo~~mootmoom~mmomw ~m~m~o~~mooo~~~~~~m~~~~m~~~ow.-moom~~m~~~,moom.~~o~~~ o.~~t~m~~~m.~~m.w~~~~~.~~~.~-.m~~~-(~.-(~.w~~~-~o~o.rn~m~~~-.~.o~o.-~m.~~.r.-~~.~~~.m.m~m~ t N m N o r LO r r o P ddm N" m-dr-r-r m-m o o-m-m-w-a-r. m ~"N-T w r- m m m co N N m P LO NO w LO m~~ro~~t~~w~r~~~~w-~~mmoo~~ommmm~~wmt-mmo-mow~~~~ ~ m .-N LOP~LO r~~~~~rrrrmm~m~rrrrmm~~ww~~mw~m~mw~m k sa~sxs8~3~ss~~s~~~ds~a~~~8~~~~~~~~~~ss~~~~~~~~~~~ z uu $r~~~(~~~mr~r~~~m~~~t~~-oo-~rom(~mmmo-~~~~w~m-mmmm~m~m r~m~-w~~m~~tm~w~~~~mmmm~~-m~r~mmw~om~~~o~w~~rrm~ 0000000000000000000000000000000000000000000000000 0000000000000000000000000000000000000000000000000 SI ~4~~~~7~~"s~~f~~~f~~~~~~~~e6~~~~8~~~~~~~~~~~e~s8 gz ooooooooooooooooooooooooooooooooooooooo~ooooooooo ~u sssssessas~ssss~sss~s~~~~~~~~~~~~~~~~~~~~~~~~~~~~ z sEssssssEsE8ssssEEssE~~~~~~~~~~~~~~~~~~~~~~~~~~E~ i$l w,LOLOwLO,LO,m,LOwwwLOLO,LO,wLOw(Dwwmw(Dww(Dww,LO(Dw(Dw(DwLOww(Dww(D 9"99'm~qm9NN--o-N9mNom-oo~9m~m9m99~m~-ooorm~mm?m" K ~~ooooo~o~~~~~~~ooomoo~mo~~ooo~ooooooooooooooo~oooo rooooo~o~~ooooooo~omoo.-m~~~ooo~ooo~ooomooooooooooo~ gg ~a%s~a~a~ssxss~s~Nax~~~~~s~~~~~~~~~~s~~~~sss~~~~~ ~o~doodd~o~ddodo~d~o~~~~~oo~~~oodo~o~odooodo~oPo0 ~0.m.mmmmtw~~~~~o.~~o~mm~~mt~mm~~~~~8~~$.6~~~~~~~~~~~~~~~~~~~~ .si ~~pp~~~$~~~~~~~~~~~~~~~~~~om~~~~~~~~mowoooo~~~~~m >I rN rPmNrNrr " CUN r ".-N.-"N r Nr zq I- =% 2! ;q I-3 z', wo I" 3 !!I > 000000000000000000000Pt00000000000000000000000000 000000000000000000000"00000000000000000000000000 000000000000000000000NN00000000000000000000000000 000000000000000000000~,00000000000000000000000000 000000000000000000000~LO000000000,.0000000000000000 ooooooooooooooooooooo~~oooooooooo9o9ooooooooooooo LO- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- 0- a- a- 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- LO~o.o~o~o~o~LO~o~P~,.~o~o~o~o~o~o~o.,.~o~o~tPo~o.o".o~o~o.o.o~~.o~o~o.o~o~o~o.o~o.o~o~o~o~o~o~o~ rmr-r- NPmN-NN-rrrr- -rNNr-rrrrrrrNNrrrNrr--Nrr I-L $2 za - s P 9 m + a 0 2 - s . IC m 9 r 2 si8 % r Z-J ?: s 0 $ m 4 b m% r 04 6, YY IC 4a+~v,.,.~gg ~4 mm 25 Smr L (D ?$~L~$$MNNN SSLO5?& CJ aQ ,"44 (D u mss 11 isgm do~udllllls~<~:"o~ <;,z9:3 zs6&$$; E$ l N-~~-NNBQQQ~ lwmaQ %?A <ls ~$56 4 ZmFci 31ss y ~<~dll~d~~l~mu~si~~ S:< Zvdllwl: rz~samloz 8 v) z<ss ~~~~8~~8~~g~%$s"~,s~~~~~~mm3ozo~~O' 0 ~YoY:~~~ mz<<zza 0 zzg 4~23<6<-I o~o<~lddN+~ozN ~;~QUJ< 0 s~~~45~~~k~m$spss~~~~~~==~~mss=~b~~~~~sd"o~3~~~~~ ,,N,,,o,~mm~~~4mss~~~~~o--~:<<<d~~-~o mwttnwo+azn on="""~"9~~aan~~$ya~y~~~~~ ~~~~~~~~~~~~~~~uj~~s~~nn~~~~~sn~nnm 3~;-S~2sas2 o~mm*ujuu-ulo (Daw m mmm ~zz~mmammaaa~aaa--m~~aaa~a~~~~aa~aa~~aaa~a~a o~uj~~~d~m~%~m*o"ww'~ww~w bw ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ < dbZm&ssr--- ,amgggq$g~=U~~ood ?iN&wW- ~~~m~~~~,o~c~~w~~Sw~?i~~~w~W~J~~~~~~~~~~~~~~~~~~~~ +w$ww ,,mm .-gJ=~--uomq~Oa-- .+u% s~,,sN-~"Sx~rrx~~~u?-N~~~~o~~ cscsN*".+, POO"zzzmrns~~RR~mg,.g~~~:s~~~~~s~~~~~E~o u?BB&%sGsgy2;g2::g ~~~~~~~~~~UUUU~UUUUU~UUU~~~~~~~~~~~~~~~~~~~~~~~~~ El 666266626226666666266626662226666662226666~666666 5 :I i aI c 44~44~444444~4~44444~444444??~~?~???????~~~?~???? zu QQQs~==Q=ZP=Q~QQ~Q==~~~==Po~=====ss=r~s~=s=~=~==~ rmmmmmmmmmmmmmmmmmmmmmmmmmmoooooooooooo~~~~~rrrr~ NLOLON~~~~~~~LO~PNNNN~~~--~~-&N-~~LOLOP-~~OPNO(DN~O~~~~ m~w mmmo brnmzrr-~~~ om - N~P~LI) :--- .- NNID~~~N r I z I- ................................................. 8e8888668~88668xxx886~xxx8~666666~~8~~8888g868866 gp $ss~P~~==~P=QsQQQN==:~=yyb~s===QyQ=:-~:==sss~~:~~ mmmw~mw(D~-m~~~o-w~-wmmumm--m~oo~~~~m~om~o~w-mowm~ m- N " r(D r.U)(DN" NN mom wmurmmr -- -.- - r > z ., e a zf f ~mmmmmmmmmm~mmmmmmm~m~a.~ z FZE ' mm~ab~bmbvbay v QmrmqN.mmmm~-tua ~6~~~~~~ppp~~~~~~~~8~~~ (D mr.a ~nr.am~m~nwm~om~ - "- Fo - " ? N l-: Eze Ha+ 2a .. 5 ;I$ In " v? r 0 0 N 9 m ta~or~mmmmmmr~~r.~nm(~~~(~o mm":9"q"9mmm~qqm":99qN":"9 m~moa(Do~kr.r.m~~~Inmmb~ooo mmmmoN-mNNNNmmm(Dtt(DbNmm ~I~NW~~PNNNN~OD~PPPP~N~~ -N(DOO~~(D(D(D(D~~~~N~~I~P~I~- -~r~9~.-~N.990.99990.9-~-.~~~.~~N~~.~~ k.m.--~.r.~m.-~m~ss~-b----.--m-m.m-"-~m.~.r.. ~N-NNt-rr-rrrrrNOO---N- m -4 r.. m m- m N m - m 000 000 000 000 000 PPN 999 0. 9 9 0. 0. 9 0 0 0 0 0 0 9 9 9 7 N~.~O~ION~NN~OP ?9"9P"""""9"": r.(~mommr.m~r.m~~ bwmomrtmombam P9"99*.m"r..9-.19 ~~"tom~nm~mtmo bmmb~to~mr.(~mf Nm.O.--*.N.--r.-OO-Y-.-- ".-N"NmN"" - L N ig 1 LJ' r. ; I2 '9 m m r ~aoo~~ammomm---m~noa~~ao mmc9""99N-"m"q99NNrn":"mk9 m~rn~~-m~mrn~mrramrmm-~o~ ~r~m-omto~mr.m~o~m~~n~n~rn~ ~m.~m~~~r..o~r..r.~~~~.o~~~mo~~.~tm.tr..o~~~ mabomm-oooo(DInInInmInInmmm~In ~N(DN~P~w~~~(D~~(DN~~PP(D~.N " "N "rNrNmm In 9 0- m t (3 r 00- mom &Oh 0. ". ". bPIn POP bZuJ a x b B m In N N~.OO~I~N~NCU~OP mmkoPNor.ttbmm I~~O-CO~O~(DPPN cmmram-om~wwo y?~g~sv?%xx~x~ ~.a-b-m~~m~~.a~-.o---~r.. N rNNrNr Nrr vu2 -~n~mmmo(~mmom(~o~r.o~a~~o~ ~mmm~~ortto~m~momom~m~r. olnm a~m-mm~-cm-m~ frnmt~~nb~omommm~a~nwmm~~~ amr.~~(~(~(~r.(~r.wr.~r.~rrtmmbm m~o-~n-rnmnomwm -m-mmarrr------m~~rrrOr mmbmbmmommmt.- 00000000000000000000000 maoooNor.moam- 99999999999999999999999 00000000000000000000000 999 9999999999999 qi $51: ; "99"9"9~9~9m9999999"~~k 9 99c9 c9 "9kW9km"m9u.-q (9-N NO(D InIn(D mmr NNr 000 O"N"NmNrOOr 0000000000000 0000000000000 $42 z f S SSSSfffbSSSSfffffffffff f SSS g fffffffffffff au? 8 $~~~3s~8~"83~8~6~88~~~ 8 kg? r. .-r.m.-amInmmotbm oo~mooomtmmoo oaaooooooaooaaaaaaoaaaa a moo a oaoaoaoooooolo o m oo~o~o~o~nmoooooto~noomoo m OOP P ooooooo~ooooo 9 s 99~"~99"""99999"c9NY9'99 N "9": '9 9999999"W9999 ~5:- z. m.m-m.m.o.-~o~--b---m-a-m-r.--.-~k~m-nb-m-~.m- '4 m.mn! m. m.m.yb."~-m-~n.~n.o-o-m.o $ moo~mm(~mmm~nmoomam~~omo~n 2 ;IS g omooooom~oooo ~mm-m~-mror.mum~t-~~~~o~ mc(~ommaawmom~ ~mr.~namm~r~rmbbm(~mm~nm~~m sa ::[ g $08 2. s8ssa~8.ssssss8ess.asss6.s g 2.g:. ?. @ggggg3.ggggg r "Prrr" -NN-~-- P mm- m rr~~r~m~~~~~ m I- w2 ?2 ww u8 g- 00000000000000000000000 8 000 0 0000000000000 Es a:36 m ooooooooooooooooooooooo o m ooooooooooooooooooooooo o ooo o ooooooooooooo 00000000000000000000000 0000000000000 999999~.9~.99~.9999~.9~.~.999 9 90.0. 9 990.99990.0.9990. 2 r", 99999999999999999999999 9 xxx x 9999999999999 9~.9~.9999~.9999~.9999~.9~.0~0~ g- 0-90. 0. 9~~0.9999~.--9999 ~~ qls $ 00000000000000000000000 8 888 8 8888888688888 -N-NN~rrrrrr---Nmmrrr~r I" PPN z -."Nr-NONrrrr 0 I-LL g:: +a 0 s ZI 3 v) s 2 ZI z 0 0 3 v) v) 3 _I _I m $ $5 E ts 5/: v)N 2 0 w 3 n f 0 N -7 r. a z 2 U hhh bbb >>>mmmmmmmmmammmmm -0 z2p?$s$sessgggggsem e= fff3333333~~~~~~~~~4332 r www""Q"QQ""""""""~~rn~~m 333"mmmnmmPPPPPInIn,eziz~ In*In******ooooooooo ~tlitlissss~~666666688~~~~~ ~~~~~~~~~~~zz~zz~~~g~~~ l-CCl-~~~555~~~~~~~~~~~~~ n~nwwwwwwwwwwwwwww owwo ooonnnnnnnnnnnnnnnw~nnw v)v)v)v)v)NNNNNNbCCCkOO ~~~~~>>>>>>>>>>>>>~">~~ ZZZZZEEEEE~~~EEEEEE~~E~~~ m~~~v)3333333333333>>33 aaaaav)v)mv)v)v)v)mmv)v)v)v)Eav)v)~ wwwwwa~aaaaaaaaaaa33aa3 EanEnwwwwwwwwwwwww v)v)m~mv)v)mv)mv)v)v)mmv)v)v)EEmm~ 33333333333333333~CC3~~ 2 i Y 5 -61- 2:s :$Q ZZ!? XIn 334 my- uw- 00s zzo Jd+ AJZ WE0 EEa ww3 xzn r. is k x 35 e e: m Qw - Ub03 L ze2a w KO* ozho~: In hags=- wrrmzw n Z3l-QSE an0Zbo OSYO,rn $ywW--rr I.zsS2 &&G-Jwo SS3Sa9 ?$ff$ a Z~JZ :g;%ge JJ7 ypg $24' 00; %$$ 2s: y$ ll2 22W htlim $82 ++a OO* ZZE zz .. rru ool "2 SS? 99s e?% SY ss < sgoz 0 SZzfg m$ei= EqE: 3wzn szzg <-E2 <phJ z?&$ E552 'Dm 2 :$ ; _IInSU Fo*= 2u E wo zonw <ow+ El2 EEEEEErrEP~rraaEEEEEEEErrE Cl-Cl-++l-l-l-l-CCCCCl-+l-+CCl-+ naa zzzzzzzzzzzzz 000 0000000000000 C N cus bbr.mmmmmmmmmmmmmmmmm~~~ eeeeeeeeeeeeeeeeeeee"$B eee eeeeeeee?eeee 44CC9444444444""44444~4 mtn--~n-mm-m~n~r. x42 =xa:=s===xzz2 mm.-.".-.--~~a m bkb ccccr.bmmmmmmm Prm "r~r"""Ooo00rr~0o~o bbCrrmmmmmmPutPtInInNa~oP 5 212 20 " mz?= r H t-6 eeeeeeee2222eeeeeeeee22 Fee mmmmmmmmmmmmm zia3aziSsaaaaGa xN=xx2:4&===" InIn-um P 0 mmm-Pa 7 mm~2 maaCbbbbbbr.r.Cr.r.bbr.tbr.kr. Cr.+ Nakamtkr-kbma(D EP a~nomoa~rt~tmm~m~rrtmr~o P~x:=~=NNcC=~~~P2Nx=~~, ?$S E $1" r. - mmmmmm r UQ > z .. 0 0 - 7 v 1 ,~.xs~s8.~~~.s~.x~-~.a~.~.~~~~~ 2. mmrtmrmmmm-~~ommtof~~m .- .-.--.-- 2ij "7 ""r"r?r"""" 7 rto~ow~ootm~t~~~ootror r ~mmob m r -39m9?999qm-q9--9~399- m ?-??- 2 2 B~~.r~-~-~.~.~.~.~.XX~~~.X"rX92LZ9 L- :-:.E-;-:. z. ;- ~~~~X~84~s2~nRZ38WX~$8W6 E 8:wz;c m F- ~=E2~~~w6~~R~8~X~~~R~~~~ 2 ;;;;: ; 2 p" -."~~~~9~.9~.9~.~.9~.9"~""~.9-.~.~. m r NN N -torom~oobmt-4.0-hoot~m- m mbmml m m ~mbotoo-omtm~-momo~brnmr N ~ommfomrmomrm~oommm~mmm IC wmrn-rrc 10 m wr~~~~.m~~.~.m~~.-.m~m~h~o.h~w.o.q~~m~r~~~~~ N. rrnm-ow- m. o. ~~rmm~mmotmmm~h~omh~~mm E rhtm~mmrmm~oo~~mmm~~~ cn~m-~~-~~~~~m~m~romn~ooo m. z 0. -99m9~?99qm-999-9?39-- k nazz, 2 2 "-4.N 0 0 m I -- .1 r r oo~B~~R~~~~~X~~~6S8A~~~~ ~--~~owmarnw~wa~-omm~m-~w XZ8ZS a-o-w ~~0000000000000000000000 O>qqqqoqqqoqqqq==qqq~~~~ '~~z~"~r"~Krr~8~~"~~~ ~~oOoooooOoooooooooooooo sgK;=Pi O"0.- ZZ?ZZ z ~~~g~~gggg~g~~~~~g~ggg g ggggg s g ~raR~~ss~s~gs~~~zs%s~~~~ ? :ggag ; 5 BI.. . . + m~~mmm~mmmmmmmmh~m~~mh (9 mmmmm u1 a oooooooooooooooooooomo N mmo-o m m D 000000w0000.-00m00000.-0 d bromo 99999990999q09?09999~9 ? 9k9r-9 2 2 w$x%sss4.~-h~.z-~.s~s~~s~s~.z.~. z *loorno m IC ~~86~~88~Z"~~~~~~$6~~~~ 5 g8gEg 8 8 0 '4 9 '9 9 '9 m wOo.qo~mo.~oo.o~oo.m~m-tm~mo.o~-.m d 0-m.y-q m. q. >ZN~N umrrr~~ -- - --- m rtn-~m m m 24 NZ m r I- W6 12g E2 EZ z' I-3 Z-J wo $: 0000000000000000000000 0000000000000000000000 0000000000000000000000 9999999999999999999999 a~9~.~.~.999~.~.999~.9~.~.9~.9999 a~888888~8888888XXXXXXXX na~~~.~.~.~~~~m~~o~~~o~o~o~o~~o.o~o~o~o~o~o~ >N.-N.-Pln "NN"N .-N.-"" (om J ee ma SS 2 -l a 1vg a1 25% -l rT vz! 5 OZt -l -1 s$o-l-lzO c! a $pS$g $-l?jZ" -l ~s$~~~~~RR~~~~~$$mz~Z~ mgpw~~gaaR"~g~oF-~6 =:eN Na$~~~Z~~~$wWws&S-W=oQ OI-Zm'" ~zn,~~aww,n,=,a,Fs,w$~ ~~g$~~znnFmqse&a-l~So ~~w~n~omz~~n~~ w 00 .mooggg?~~~$Im<~~ss~ OoF-dssakk~ar~~o-ln~9m~n ;#g,mmzmm zm mfIZEgZZz zz0a:C:Cvyo ~zzo+~~oI-~!-Jo-loOI-~~ 00~-11 ~~~~oo~3~~~3z3~zg~a3~~ O"#dyizss+Lg ,,Y,OO,~~Z~~Z~~O!-,P~~Z ss~PBB%PP~%~Be~~IP~PFd L/ia gs:$@g e~~5oaz idza$-l$ zg5 ?ww~oo~?J~oza~30r N maa~gg~~~go~~$~~ 0 0 0 9 9 E 2 m A 2 e !! v) mmo-o qk9r-9 mmomo 0 '9 9 '4 9 moomo 0. ". I" -. t rmr~m "om0 ONOr-0 r L t 3 0 0 0 a +> $y $$ II-g3 s2gss OWE20 %?%fig zg3z0 YZZZJ <OW, zI+acL 00 wu ~nuuu -I=--- woaaa 301J-l m -? m '4 eq m m m m N 2 e !i 0 h 2 2 N h. - u z 0 I- 2 O 3 u ~zzzzzzzzzzzzzzzzzzzzzz ~~o"OOOOOOOOOvOvvOOOOOOO 00000 E ?????~"""""""""""""??" kf3 2 mmmmmmooooooor~r~~r~~~ mm=mmmmNNmmmrmmm=mm"m ar~=P=?J?J======aA==~==:~?J m bmmmmmmmo- NO brn- m 1, <I r - 8 mmm~m~mm~mmhmmhmhmhmhh a m~-u~--~mm-oo~no~~ono~~ 3 0 0 P $ ?FF?~4??4??4?~???4?4?? wwa=~?J~~4~:a?J?Jr==~Nc~~~?J 90 E z - - Ftl z p -m ~m om- m -me r - U v .J .. 0 a Exhik Reconciliation of Fund Source to lnvestmenk Portfolio As of June 30,1997 Cash Balance by Fund: General Special Revenue Debt Service Capital Projects: General Capital Construction TI F 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: 23,640,525 14,456,241 3,410,417 5,182,199 3,462,229 14,545,474 4,716,659 49,207,150 26,217,098 29,117,129 1,065,411 2,324,282 58,723,919 9,284,871 9,410,476 0 Total General Ledger Balance 196,040,159 Amortization of discounts and premiums Deposits in transit Outstanding checks Wire in/(out) not recorded Other Net adjustments per bank statement Total adjustments (24,103) 3,467,815 3,443,713 Total Treasurer's Investment Portfolio 199,483,871 (1) Redevelopment Fund Balances are interspersed throughout all funds. ** Figures based on best estimate at the time report run on 7/14/97. 0 0 Exhib CITY OF CAFUSBAD INVESTMENT PORTFOLIO AS OF JUNE 30,1997 CORPORATE NOTE AND COMMERCUL PAPER RATINGS Corporate Note Investments Meeting the Current Investment Policy: (Ratings must be AA or better by both Moody'sand S&P) Moodv's s&p ASSOC COW OF N A BANC ONE CAMPBELLS SOUP DETROIT SEWER DUKE POWER 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 "43 AAA AA2 AA3 AAA AA2 AA3 AA3 AA3 AA2 AA3 AAA AA3 AA2 AA2 AA- AA- AA- "4 AA- 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 by both Moodv'sand S&P) DUPONT MERFULL LYNCH Al+ P1 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 DIGITAL EQUIP BA 1 BB+ 11/15/97 MIA- 1,007,589 DONNELLY AI A+ 12/01/00 AA31AA- 1,110,779 * 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. 1- 0) 8 OF CARLSBAD INVESTMENT PORTFO @ Exhil AS OF JUNE 30,1997 PERCENTAGE WEIGHTING5 BY CORPOR4TE NOTE ISSUER Investments Meeting the Current Investment Policy (Percentage Less Than WO) ASSOCIATES CORP NA BANCONE CAMPBELLS SOUP DETROIT SEWER DIGITAL EQUIP DONNELLY DUKE POWER DUPONT FCC NATIONAL BANK FORD MOTORS CREDIT GENERAL ELECTRIC CREDIT KENTUCKY UTILITIES NATIONAL RURAL UTILITIES NORWEST MERRLIL LYNCH PROCTOR & GAMBLE SOUTHERN CALIF ED ST PAUL CO TOYOTA TRAVELERS GROUP INC WAL"ART 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 9,108,300.00 2,024,340.00 3,019,970.00 6,048,871.00 8,290,667.70 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 Percent of Portfolio 4.03 0.50 1.03 0.5 1 0.53 0.57 1.03 0.98 0.49 0.98 4.57 1.01 1.51 3.03 4.16 1.13 0.50 1.02 2.77 0.55 1.25 0.50 Investments Made Under a Previous Investment Policy (Percentage Limited to 10%) Prior to 2/13/96 Investment Cost Percent of Portfolio N/A Total Portfolio $199,483,871.3 ,. *. e e Exhib 0 2 a 0 v) xa c QQ gz .m .m EE .m .m .m .m .m .P EE .eP " 90 m ma rn 333% 0000 m3 c 00 nul 22 22 ulrnulul 22 tjtj G 3332 +I- CCCI- 22 e". 3% B "e+ .c.c ee iiii e .g .g .g r .g iiLLLLLL ELL YY cc mm m a," Y EEEE C 0000 00 !=!=CY- 2% - cc e- a, -"e " ulul ~ +I- z2!3 v)v) 3 f .- m E e - 0" U u) + 2 F ii s z 03 0 0 m c9 (v b m (v c9 oco 002 cao% c 0- a? -oCDm(v .. gP CQ E 3 0- ii a u u) K U E 'OQ 2E (II >e 3: gib sg$ 00 00 n e '0 c 0 rn Q a - 3 l? L E '= Q a0 3% .I 'Os lnQ3 *of e& as2 0 0 a '4 a2 9 b 8 5 r s b 2 co 0 0 m c9 5 z s z hl b In (v co- s z s z 2 m Y E m" e! tj ;; c Q Q) m c * .. E 0 P - a u In ii 0 9 x s hl 0 s 2 r- (v I I 0 z? 0 m m 0 b- 0 : 2 0 In 0) 0 0 01 o? b- x z 0 z 2 0) s5: 2 zzc b ss s G zzk .- m E e ? J y?Rz $2 - 00000 00 Y - c coacocoo am '4 a O-lnc?rn" 7- + w'oamb rr 7 2 wmmco-? "?Lo mmcrl 0- (vcrl ii H r OcobOV) bw c mmhlcoo rCO c bb'4mm om I .. 9YCq0Y c?? Q (ocqCqc?b- 00 P %%%%El 2-x - mmhl ii 0- (vhl 2 r u) 00000 00 I gggs. gg ooococo 00 O-O-O-"." 0- cvw mvc) 1010 ooocow 0-4 moor9Q) 7." r bbb bb ???e oInoa S$ rcct zzz 27 zz so00 50 s sss s 0 8 2222 22 uu CC 22 mm p! ul +I CI) c CI) a, .- $$ E ulul 0 $ ul mO 222 $ Q Q$ 8 I-I- 8 z 22 Y (3 .? .; ! 225 e ED oa,O., OW 0) 9 :%E" fis !! 385 a 2 .- B ul 0 z ul OKK m K CU e 00 c =I- c C J E Q % JII E 800 -0 ul > $3 C 0 2 C I ztijE QcokQ_ sq c 22% al (3 S LLLLLLLL ZiE c - U .- 52" C ZI a,.k - oaa LL a Q n F = E a L Q > (3 0. I E 8 U C LL a a, 5 2 ul C s U C LL 3 i a, J S S U c LL 3. c a, a m B C s V 2s S" -gc m 2 3 'E ua != "g z 72s s J LL. kc us ;~jh Ex$ Q - n 2°C LLaQ WK Q D C LL 3 a, 5 B ul S Q 2 3 .c C 0 .. c t 2 :5 .- .- C 'c n 0 C g E a -0 C 3 LL a, 5 ul K a, trsr PQQQ rn U C 3 LL a, 5 B ul cc QL r. ** . .I e >I al 2 a 0 v) xa CI @a, gz .- 0 E g - m 0 v) c CI 2 E ii I s E Q) c, g 0 8 - 5 m 0 v) a al e ii CI C 'pa, as u, ab 0Eg m >e oga *@ i3E n E Lal IC W s m a, a - z L m n E 'C 3 5 ut; 323 as2 nr iig 3 E: C E VI a2 - g ai I-" z 0. a L U v) S 0 m .- 5 C m 0 0 - z z I- C) Q) Q) F .- .- mm EE P.g -- $0 m c,+, lv mm u. e E? iiii 00 zs - l% 00 20 7 -. m 00 2: 7 m 0 i '2 ZY 0 s z s me mm !!3 .- 8; gg =z a -4 iiH Ern z= 3s 8:: 2 a. .;;$ 2% Ba, e tK cs PP *% 2 mmm k .o .o .o cncnv) UU-0 m CCC 333 LLLLLL CCC 3 m aJa,a, E $$$ C E 533 sg .g .g .g zc P 777 C - .g .g g - 0 mmm C .- err a, z TI zzr .- 0 3 LL (0 C 0 e C - m c C .- - "- LL aaa L z m mcu m .o 0 b m .o 7(? W 0cv bm E ;;; E 2 -- o? a %ma- a an! w bln ow IC OYYB1S: m Ji " *--x c- PJ E ni m E mcv mbm ow 7(? ON i; 222 ;; c?$ " o? z- u7 z- 0 *- n! Ob Zrr2?f2 bln f mbo E aw - - ln z In- zni ii ii bm n! (Y v) 0 v) ma abm ow 7* ?lo-? CRN ?a, bln wo a(D " o? bln ow cv -10 mr oww mbo r*1 2- m =!! m- " -7 2f2 ni Ni $5 s ms (42 10 e 0 a f 0 Ci m C - 2 "2 Sii sss 222 E% gz 9 sss %S zzz ?Z 0 i, m E 2 ; I-kF s gE (3$ = rzz ';i 22 2 5 % et?? 2;; 222 kk!= .- mmm g zz +I-+ 5 sz v)v)v) "IC e m <a< L 0L m - cn - i a -7 03 uz 5 C $E ;' Uk LL c tj LLsE tj kg, * e€g E E %$: E $2 LDa .s.s $! morn $! rnrn -0 C 3 00 0 C 3. U C 3 .- L 3s .- L 55 0 a, 5 ana, .F a i! dB& i! $5 111 IS 99 t t Pcw mw aw a 22; (3 (3 .: SCC 3 3-c mmr e 2.5 ==a Y-y- ma,: -r3; 223 - mii k CC;i .o .o c mcn C" s&- .E .c a 8 8j JJQ 335 zz; cooc y?: wwc NWI1 mmI1 mob 0- n! p cu- coo< *a,i corn7 ww< 9 " c 2%: moc ni I 00: 00 EE ii J-l 'c'c ma - mi3 .P .e KC mm ZZ' s= .E .c c c. 88 JJ u) a, a, 5. 0 a - s 5s 2 kZ g $$ g zI= g 66 0 55 ; 88 s CC $2 rnrn L d II