Loading...
Quarterly Investment Report CITY OF DUBUQUE, IOWA MEMORANDUM August 2, 2000 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Quarterly Investment Report Finance Director Ken TeKippe is transmitting the quarterly investment report. Michael C. Van Milligen MCVM/dd Attachment cc: Barry Lindahl, Corporation Counsel Tim Moerman, Assistant City Manager Finance Department 50 West 13th Street Dubuque, Iowa 52001-4864 ~~\A~\J\ D~~~E ~<k~ July, 27, 2000 TO: Michael Van Milligen, City Manager FROM: Kenneth J. TeKippe, Finance Director ~J. U;~ SUBJECT: Quarterly Investment Report INTRODUCTION The purpose of the memorandum is to transmit the quarterly investment report as prescribed within the City of Dubuque Investment Policy Section 17.0 "Reporting". DISCUSSION This report covers the period beginning April 1, 2000, and ending June 30, 2000. The report presents a summary of the investments on hand at the end of the quarter and indicates the earnings recorded for the period and fiscal year end. Also included are reports summarizing investment advisor performance and composition of the investment portfolio by type of investment and specific account. The valuation reflects the same basis that the assets are carried on the financial records ofthe City. The City is in compliance with the Investment Policy. REOUESTED ACTION This report is for your review and filing with the Honorable Mayor and City Council. Attachment Service People Integrity Responsibility Innovation Teamwork CITY OF DUBUQUE, IOWA CASH AND INVESTMENTS SUMMARY AND SUMMARY OF INVESTMENT EARNINGS FOR THE QUARTER ENDED JUNE 30, 2000 ANDTHEACCUMULATEDYEAR~~DATE MARKET VALUE UNREALIZED CARRYING (INCLUDING GAIN OR DESCRIPTION VALUE ACCRUED INTEREST) (LOSS) MONEY FUND SAVINGS ACCOUNTS 10,544,538 10,544,538 0 MUTUAL FUNDS 0 0 0 INVESTMENT POOLS 0 0 0 CERTIFICATES OF DEPOSIT 3,141,874 3,173,079 31,205 REPURCHASE AGREEMENTS 0 0 0 US TREASURY SECURITIES 23,120,230 23,557,150 436,920 FEDERAL AGENCY SECURITIES 0 0 0 CORPORATE STOCK 6,825 119,905 113,080 INVESTMENT ADVISOR ACCOUNTS 21,736,936 21,620,736 -116,200 INVESTMENTS 58,550,403 59,015,408 465,005 CASH ACCOUNTS 2,337,456 2,337,456 0 TOTAL FUNDS AVAILABLE 60,887,859 61,352,864 465,005 CITY METRO COMBINED 52,481,988 8,405,951 60,887,859 52,801,508 8,551,356 61~52,864 319,600 145,405 465,005 CASH BASIS I OUARTER YR-T~DATE I GROSS EARNINGS: CITY 791,356 2,247,702 METRO 151,763 341,889 COMBINED 943 119 2 589 591 INVESTMENT FEES: CITY 38,697 144,585 METRO 205 650 COMBINED 38 902 145 235 NET EARNINGS: CITY 752,659 2,103,117 METRO 151,558 341,239 COMBINED 904.217 2 444.356 N~;j 8-"'''' .., ~ ~8~ ~N-N '#'# :f'. .., .,...,.... .,. "l3:"":"":<ot; . vi -oi....ic-i ol:""i.noci '" ;;I; 0\00\ OI"'O'OV'l ;Z~ ~ 8 1l 0 - "'... ~ - '" ~ '" on V'lt--_O\ ..o:.n vi .,. '" "'''' 00000 .,. 0 .., .. "'O'~ C't ("i, \"1'1 '" jsl on r--: \D~ 0 ...; ..j: V'l~ 0 ~ ,.: .... O"'O'C'lV'l .., ~ :; :; ~ ~ ... \D--\D " ~,2 0 .,. ~ClOt--\"I'}. ~ <<i <<i .. Ii '" '" ~ ~ '" '" ~ .... C!:8C!: 0 8"'''' 00 r:: ~~~ 000 .... ~ <f'. <f'. <f'. 'i'i .... 0 .\"I'll""'! .,. .,.'" .., .., ~;;t 00 j ~ aeooci 0 0'" '" M '" "'0.., rrj", - '" ... = .,. ;l; 00 ... .., '" ... ~;;;::j:;Z r..:~ ..; '" .., '" .., .., '" .:; ;; <<i <<i ~ "'O'~ ..; !:l ,.: 0 C'f'i'oOoOl""'l~ ... ... ... ... '" NOIt--O il .,. .., .., .... .., .,. - t--V'l"'O'\D :e ;i .. .. '" "'O'~ "'O'~ .., .., .., .., III 8 888 ~888 0 8 888 8888 ~~~~ 0 0 cicio 0000 0 0 ci60 0000 ocioo .,. ...."'... 8;;:8;;: '" ;;: 0 8 '" ~~;3;b <f'. :f'. <f'. :f'. '" -.., 00 '" 0 '" l'- :. :! ..o....i~ vi 0 0 vi "';0\0\...0 '" '" O~O\"l"l i:i '" .., .,. .,. 1lJ!l '" "'.... ~ '" '" .., ~V'l\D~ vi vi M vi ... ..."'''' 00. 00 '" '" 01 01 t--t-- is i: ~<<i;i <<i ... '" <<ion~"': .., 00 .., .., - '" :eJ ~ ..... .... t--~ N t--~ ;::; - - ... ... ... ... 0 ........0 0....0 .... '" .., 0 0.., f"'l0l~t-- :f'. <f'. <f'. <f'. ... t'i"":"'! 0000 00 00 "! 0 000 ClOOOt-- . vi 006 0 ..; 0 0..0 ..o:r-:c-i""; .... '" '" 00 "''''... s~ '" '" ... 00 J :il 0_'" (;l (;l .... .... t:o;;t;~~ vi vi M vi '" 00 '" 00 00 ~ ..; .c -~-.i' ,.: ;!i .... ~~~~~ '" ... ... 00 00 '" '" .., '" "l ,.: ,.: .... ,.: .... :E ;;l '" '" ... 88:<1 <f'. <f'. <f'. - ~ .,. - '" 8~8~ ~ ~~~:2; :f'. ~ ~"'!"l3: '" . 0..0:0-.0 ... '" 00 ~ .., ~ ;; .,."'''' 00;:1; .t--NO\ '" '" .. ~ ~~~ ;0 ;0 '" '" .,.., ClO V'l_ vi vi M vi :E '" .... ... .... t--\DO_ ~ '" !:iN;:! ..; :!: :2 ~.coO"; :!: :e :2ClO~~ .. ,.: ,.: .... r--: ...: > i5 ~ 00 "'....'" 8 t:08t:o 0 g 88~ ~~~~ <f'. :f'. <f'. <f'. !5 .,. '" 0 00 '" . ,.: ;3"'''' 0 ~o~ ;3 ,.: 00;3 .,. 0 '" ~ (!~~;;; ... .,. ... z ~ '" - '" ..; vi ... vi 0 ~I ...."'0 '" '" .., .., .., \"I"I~~~""":.O~ :;g 0 r--: N~..,-i on ::t '" V'l N U"l 00 :!: .,. .,. 00 00 ClO\DU"lt-- - - - ,.: ,.: .... ...: r--: '" '" ~ ~ >= >= ~ ~ Gl .:; ..... ~ ~ gj '" ~ .:; il i '" ~ il:e ~o ~ :e- ~ .....[3..... ~ d ~~ ..... ~~ ]e ~ 0 '" ;f8 '" ..... 0 ~~ ~ u '" ~el ~ 1;; .....[3[3 '" ~ B i <O:I~ U ~Q~ Jjej ~~~" ~ -=- U ~:I:U ]] ..~~ S2:e~~ ~ "'QQ "'~f!J ~Z'" t;~QU >- ~~~ ~~ "lj" -' E~~ ~<(~.. " ~ J/1 ~ ~~8~ ~ I::I::~ Vj~ Q-gj Q ececo lll-, J~~~ QQ ~ -'0.. <( '" :e UUU ~ ::>1 ~ ~ .. ::>1 Ii.; .. > i5 ~ = ... z o ::>1 <> 'i' <> ";> o ~ 1 ~I .. o '6 o .. ii o ~ 01 ~I ]~ llfj IJ N;:::~ ~::t2 '" N .. ~ C'\~ N '" - on '" .... o _ '" >0 I .......- .... "'- \O"';oci eg:;~ trr 00 N "'.... '" N....... '" '" '" '" 888 ocio ....... - ..."'.. ..00\"'; "''''''' "'........ 0\00 .......N I"'1M\O N N J .... '" <> .... <> .. ~~oci ",,,,Cl: ",,..:~' '" .... N ,..: .... ~I N "'.... '" N'" ONN .. '" '" .. <> '" t~~ <> -- r-: r-: ~ ~8; o\ori~ '" '" '" '" - .. vi' lI"I~ 0 N '" .. <> <> ,..: .... ~ !3 >....:<! i~~ ~~~ ....!3<:> ~ odS UUO ~~ffi ~g~ ~ci;i '" ... r-: "" N N ... '" ~ \IS '" ~8~ 0\000 '" N '" .... :::i ;5 ... '" ot:t~ .n '" 888 cicici 88;; cio"'; '" .... o N '" N 8Si cicioci ... '" ..; ... '" ,..: 8g&=i ciON '" '" N ~ ,..: 88; oci~ '" .. o .. <> ,..: G " ~~ ",~i ~~o:~ it _5 .. ." o rli ~~1 ~ ~-= UU::i! .... ... :8 N :::i '" ..; .., '" "! '" .; - .; '" 8 .,; .. '" "J '" ,..: '" "'. N '" <> .... :iii ,..: '" N ,..: '" .., -0 ;::: ..; .. <> ,..: ~ .-; .... ,.; ;g ,..: !3 ~ i <:> 2; ~ &l '" f .,; ~ . ... '" .,; '" "#- 8 .,; ~ . '" '" ~ ilc '" - .., .. "#- .. "" - '" .. ~ . '" '" .,; '" N ~ II ~ .S r <:i ~ 1 " I l:l ~ 5 ~ o 'Cii ~ !l 8::-' ~_O~~g; "'...'" ..o..c..o..o ",to .1!:l'; ...:J:: Q: '" ####~:8 ~~~;.a.~ ..o..o..o..o~:g 5.9 .....0.. 'C g c: Cl) 0.::-' ~C: '" III 8,f C:-- i!~~~~~~ &! ' , . ',~ ~ _ N M ................ e ~ <r.i E E--U ::)J: o !: ~#~~~ <:7'I8-r--on NM"":"';o\c::t '" ~ ~ '" '" ] .~ Gii f~ <'" cf#-'#-# NNonO "'!t;~OO .,; 1l &l j ##'#.'it. - M\OO\~ .3~~:~;::; ~~ ft ~ ~ ~ ~.s ~,-: 0 "." ~ :;"'000'" .s-r-:.~~- ~ l:!Hi;f ... "0",,_ ~:;: E liln ~<1: ::t t: ; 5 u ~ e U "'-" iiij e j SCHEDULE OF CITY FUNDS Month Ending: . ... ,;\J.l..P\lNDS COMBINli:D PDCENTAGI:S EXPENSE ADVANCES CASH BANK N.O.W. ACCOUNTS BANK MONEY FUND SAVINGS ACCTS mUST SAVINGS ACCOUNTS mUST POOLS MUTUAL FUNDS (US GOVERNMENT) CERTIFICATES OF DEPOSIT REPURCHASE AGREEMENTS US lREASURY OBLIGATIONS FEDERAL AGENCY OBLIGATIONS CORPORATE SECURlTIES -~ MANAGED FUNDS 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 2.08% 0.66% 0.00% 6.60"10 26.36% 0.00% TOTAL 35.70% Jun-3~ OTHER COMBINED FUNDS TOTAL 0.03% 0.03% 0.00% 0.00% 3.81% 3.81% 17.32% 17.32% 0.00% 0.00% 0.00% 0.00% 0.00% 2.08% 5.16% 5.82% 0.00% 0.00% 37.97% 44.57% 0.00% 26.36% 0.01% 0.01% 64.30% 100.00% 3 of 3 ~ ~l If - ~ =... 8-S ii 1l ;ll ~J to ]i .l:l ::0 J! ~ ;-! ...> .. l5 ~ .. ~ .. II 8;;; ON N '" "'N ~ r--~ -... ;,] . . l:l::o 88 ",..0: N ~ ;.. ~~ ~r-- ....'" vi vi 88 00 ......, ~- :rJ; "'''' .. . ;;; i .... '" '" 0 '" N ocir..: "'''' 88 S;;~ Q(OI ........ 00 88 (01(01 i!!E> ~o 00 00 ~~ 8"8' -:'ri .... .. 2: ... - '" ;l u .., - ",;, "'''' '" '" '" '" .... .... NN ;;;; "',., ...'" ocio.: '" '" ...'" NM "'... g~ 0.... ... ... #.#. ,.,'" ... 0 "'''! vi", 88 gg "'0 00 .... '" '" '" .. .. '" 0 .., 0 0"" ,..:..., '" '" 88 (01(01 0.... ;a~ 00 0'" 8~ (01- 0Ci; ;;;:;0 00 88 ~~ d o~ 8.8. .. .. ~~ '" '" '" '" .... .... '" '" "'" "'''' '" '" ..c..o '" '" ~~ ~'" 00 00 ",,,,-i .... .... 'tf'J!. .... .... '" '" "'''' vi", 00 00 go ~ t{~ -.::t~ 'o::t~ ~~ ~~ "'''' '3,'3, 88 (01(01 ~:! ~g ~~ "'~ ~~ 0\0\ 00 88 00 88 8"8" on.. on~ v; V; t:~ "'''' "'~ '" '" .... .... ~~ '" '" $I=:~;;~ ~g;;~~ 1'""-00_00 tr'I~ 1tS.....~ 0 0 ...... (\"'1_"""""" 8Sggg ..otf"lor-:r-: "':': '#.'#'#'#'# &:l~~~\O 01""'10\0\0'\ ...o.nMvi.,.; 88888 ?2g~og _NOO~O\ ooo~ooo r-- 'V r-- r-- f' 0\0\0'10\0'1 ~~li4i4Vt r--ooll"l\O\O o~~gg s:~s:s:s: ggg~8 (01"'(01(01(01 ""NO'I \0 \0 ~~~~~ ~~:=::=:8 8~888 ~~~~~ e:::~~~ ~:':o~~ 88ggg 0002.0 888158 ~~~8:~ v; V; V; V; V; 8S~~1.O LL.~LL.l.J,.,~ on on on on '" 0\0\0'10'10\ l:' f' r-- r--- r--- ~~~~~ 0\0\0\0<.0\ ~;;~~ ON 00 oci rt'lO\oooo ONO\O\ M r--~ vi' '" ,., 8888 OOV'l.n ::::~:!:! :;~~~ 'I'l on on on 'V'o::t('t')('f"J "';..0..0..0 ggg8 ~ggg oo<o:t 00 00 r-:oOoOoO 'o::t\O\O\O 0'>0\0\0\ Vt Vt Vt Vt ""'0\0\0 ~~gggg ~~~~ g8g~ (01(01(01(01 "''''''',., ~SSS .................. ...... & g 8"g ~~~~ ~~~~ ...... '" '" V'l -000 8888 ciosio 88158 dosio~ g~ g~ OA :SA fA V; V; V; ~G~~ ~LL.u.;LL. on on on on 0\ 0\ 0\ 0\ r--r---r--r--. NN~N ;;:;;:0\0\ 0000",,\0 ~,., ... vi", M ~~"'~ Oc-i":('f"jA ,., 88 0\..0 ~~ 88 I'f"il""i .... .... '#.'#'#.'J!. V'l f'l"ltl")tf"j ~~:=:o on...o..o..o 8888 0000 (;::bbN v-i 0\ 0 OA ~~S\;: ~Vt~N .. O\~br--- ""0')08 ~~~~ 0200 8088 "!(OI (01 (01 r--- o::t __ ~~EE ~888 O;~~~ S!~~~ ~:g:g:g 0000 0000 0000 g8S8 8'8'8'8' -"'-"'-"'t""i ~~~~ ~~ "'''"' "'~ '" '" .... .... '" '" "''' 00 -'-' ""'''"' '" '" '" '" ........ N '" 0;:;: '" '" :i ;{ ,., ... ,.; ,., '" ,.: ~ o o vi ;::; ~ .., '" ,.; 8 o '" '" <::i "J. .. o o o ,., '" <::i '" ..; '" .. '" ~ '3, 8 (01 ~ o 8 o "! ,., ~ o o o o 8 <::i 8. .. 8 8 g o ;{ .. ~ '" '" .... ~ '" ! ~ g ,., '" ::j ~ . '" .... .... vi Eo ] . ::0 i i ;.. ] fo "il ~ ~ ~ " :u " " " ::J ~ " " < iii .... 8 o ,., '" o. ~ ..; ::l '" ",::I: "'.... UZ zO <::;: z'" -en ~.... <z ....'" <::;: l:l.... "'en C\I", ~> nZ ""'- i = ~ - 8 8 M .... r-: ~ Q< ...~ M 0 0 - ~ .. . M ..... e e - 0 "'. 8Jl :f .....:- - - M <.!I ... 8 0 8 8 8 '" ~ S-c 0 '" 1 c-i ~ c-i c-i ~ -' t ~.a ..... ..... ..... ~ 8- '" '" Q~ B 1 -1 ~ B $a ... '* '* ~ ~ ~ f ] ! ! t... . M M Q< M M '" ..... .i::> .. .. jj '" '" Q< on '" ] 1l ori ori -0 -0 -0 ~ 1 a> .. b co i I .i::> .~ 1.1 ! .~ 11 Q< IE '" 8 ..... 0;; .. '" t;j Q< M 0 jj ~ <Xi r-: r-: 0 .... . ] ] ] ] on '" .... 8 ..... > ~ ~JI M ~ "'. "'. ... 1 ] 1 ] :! :I r-i '" '" ~ - .a .. '" .... .... Eo< " " 1.1= '" '" '" j ~ ~ ~ ~ ... ... ... ~ - M . '" f .f f ... ... ~ e .~ j .1l ~ - on ~ ~ 0 0 ~ ... '* '* ~ ~ ~ E~ Q ~ .;l g; 8 '" M M - j l ~ s 0 [:i M M '" c: <::: ~ (:! '" '" Q< on - ori ori -0 -0 M '" M "0 0 0 0 '" ~..Q a> '" :Ill. co ~ ..:i 1.1 0 0 '" c::i 1 U 0 ~ - - '* '* '* ..... ... .t> Q Q ~ .... .. 0 ~ 8 -0 Q ]i s .... Q< ! ..... (:! (:! '" '" ..... ... 0; - ori ori -0 .. co S M M ;oJ ~Q 0 0 0 j !l e! co .. Q< Q< 0 ~ .t>u .. ~ ~ Q on on -... i~ 0 .... Q< JlJl '" ~ ~ '" u co a; (:! (:! S <::: i - &!,! <::: ~ S M M on 0 0 0 '" ~ '" - M ~ Q< '" '" 0 ..... ..... 0-, ..... M 0 0 0 '" r-: r-: 0 ~ ~ on '" .... 0 ..... ..... ~~ M '" '" 0 "'. "'. 0 8 r-i r-i ",' 8: - - ... c.J '" .... :!: .... .. ll.> '" '" '" - i .... .; ... ... ... ... M M 8 8 /:1: ~ ... ... ... a dll ! ! dll UJI- ~ e ct:i .... Uz ~ .~ c:i < Zo ~ "'::i; is. ~/ '" '" Q< . .C '" '" 00 Q< u.U) '" ~ .ii " /1- 0 '" - M i ~ - '" M "'z - 00 0 '" ,! ~ .a - 00 0 '" < .. :::: ..... '" .... co .. .. - ..... Q< .... I-UJ .. '" N S Eo< .. .. 0 N '" S "'::i; 61 on ~ B 1;:"" on 01- . ~ 1: ~ co ""'U) Z U '" ~z NUJ E ::;!> " c.J HZ U. _