The URL can be used to link to this page

Quarterly Investment Report . - ... CITY OF DUBUQUE, IOWA MEMORANDUM October 28, 1999 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: Quarterly Investment Report Finance Director Duane Pitcher is transmitting the quarterly investment report as prescribed within the City of Dubuque Investment Policy for the period July 1, 1999 through September 30, 1999. MCVM/j Attachment cc: Barry Lindahl, Corporation Counsel Tim Moerman, Assistant City Manager . CITY OF DUBUQUE, IOWA MEMORANDUM October 15, 1999 TO: Michael Van Milligen, City Manager ~~ FROM: Duane Pitcher, Finance Director 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 July 1, 1999, and ending September 30, 1999. The report presents a summary ofthe 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. REQUESTED ACTION This report is for your review and filing with the Honorable Mayor and City Council. Attachments CITY OF DUBUQUE. IOWA CASH AND INVESTMENTS SUMMARY AND SUMMARY OF INVESTMENT EARNINGS FOR THE QUARTER ENDED SEPTEMBER 30. 1999 AND THE ACCUMULATED YEAR- TO-DATE DESCRIYI10N MONEY FUND SAVINGS ACCOUNTS MUTUAL FUNDS INVESTMENT POOLS CER~CATESOFDEPOSIT REPURCHASE AGREEMENTS USTREASURYSECUlUTffiS FEDERAL AGENCY SECURITffiS CORPORATE STOCK INVESTMENTAD~ORACCOUNTS INVESTMENTS MARKET VALUE CARRYING (INCLUDING VALUE <\CCRUED INTEREST 2,713,540 2,713,540 o 0 o 0 2,062,969 2,065,423 o 0 19,145,240 19,454,559 o 0 6,823 136,699 20,871,628 20,886,036 44,800,200 4S,2S6,257 CASH ACCOUNTS 1,560,496 1,560.496 TOTAL FUNDS A V AlLABLE 46,360,696 46,816,753 CITY METRO COMBINED 39,330,562 7,030,134 46,360,696 39,786,619 7,030,134 46,816.753 CASH BASIS GROSS EARNINGS: CITY METRO COMBINED QUARTER YR- TO-DATE 45S,936 90,130 546,066 455,936 90,130 546,066 INVESTMENT FEES: CITY METRO COMBINED 33,571 102 33.673 33,571 102 33,673 NET EARNINGS: CITY METRO COMBINED 422,365 90,028 512,393 422,365 90,028 512,393 Qinvsum1 UNREALIZED GAIN OR (LOSS) o o o 2,455 o 309,319 o 129,876 14,408 4S6,o57 o 4S6,OS7 4S6,OS7 o 4S6,057 ......... -. ... ............ .. , 00 5 or. "'T 25 <r. "'1" 0'1 .....,.., 'r. ,..., = ,..., \0 "'T 0 .0 .0 ,..., 00 N or, -.0 "'1' - 'r. Q\ "1" ("I or. I'- O' c' ~, - ~ :::;) iii -.0 ,..., \0 N 6 '.:i ('I N M 00 0 <r. 00 ~ "'1' ::: ('I 00 N ('j I'- 0'1 or. -.0 "'T - r-l 0 <"'. ,..., 00 "'T Q\ ...... I'- 00 I/') ]1 ~ N - 00 N 0 ~ O. N I4:l 0'1. 0 \0 I/') I/') "'T V"\ ,..., 15 - N I/') r-:- - N ..,; ..,. M ..,; = "1" r-:- 0\ r-:- 6- ~ 0'1 0 - 0'1 00 ~ N I4:l 00 M "'T 0'1 :; 0 M N """, N - ~ "1". \0 V"\ M . ..c r-:- :./J I'- r-- r-- "1" - ~ -T" "'T ~ r-- I'- 0 I'- 0 a "'T "'T :0 ,..., g M I'- a 0 I'- I'- .00 ~ '$. ~! ~ 0 0 a \0 \0 or. I/') ~ -.0 ~ ~ 0 0' 00 ~ ~ :::5 "T 00 ~ ,..., 0 0 c 00 00 ~ or. 0 00 0Cl I'- M I/') 00 M N ~! "1" I'- I'- 0 0 -.0 "1" \0 0 \0 I'- ~ 00 00 r-~ ("~ ,..., -.0 ~ 0 r;., I/') I'- I/') "1" "1" \0 :...., 0 "1" "'T r-I N ,..., ('I "'T 0\ ...... 00 ..a .::i N 0'1 0'1 0'1 N 00 - 0'1 N "1", -.0, - ~ \0 M M I/') Ci . ..a ..a :E \0 -.0 I/') N ('I N N N 0 0 0 0 a c a 0 25 0 0 0 0 0 0 0 ~ '$. '$. .~ '@ ~ 0 0 0 0 ~ 0 0 0 ...... 0 0 0 0 0 0 0 :::5 0 0 :::5 a :::5 0 0 - :::5 0 0 0 0 0 25 0 0 ~ ~ 0 0 c' 0 0 0 on ul ::l UI ~ <I .-. N I/') I'- 0 I/') 0 I/') ,..., N 0 0 M M \0 I'- "'T ,00 ~ '$. "': 0'1 00 ~ 0 I/') 0 I/') 00 I/') 0 0 00 0Cl N ~ \0 00' 00 r-: r-: r-: r-- "'T ~ ~I 0'1 M "'T a I/') 0 V"\ r-- 0Cl 0 r-- I/') I/') I'- ,..., ~ <U ~I 0 0Cl "1" "1" N N ('j N N 0 M c.o N. M - ~ 00 0Cl -.0, "'T ~ \0. I/') 0'1 q or. V"\ V"\ 00 r-:- on" g 00 r-:- ::; - N - - UI I'- 0 -0 r-- I'- r-- ,..., M I'- :E <I 1'-. 00 00 00, N N 00 0 N 0 a 0 N N N N I'- M 00 I/') a c a 0 N V"\ 0 a N N M 0 0'1 ~ '$. '$. '$. ... ..:! ~ ~ N ~ 0 "1" a ~ V"\ ~ 0 I/') V"\ - M ~ 00 0 0 :::5 0 0\ "1" 0'1 I'- 00 ~ c: I'- a a 0 00 00 00 "1" M r-- "1" OC! M \0 N "1" \0 M I4:l \0 I'- "1" M or; 0 -< <':l 0 N N \0 \0 \0 \0 \0 \0. C'!. N \0, V"\ V"\ ::!: U 0 r-:- r-:- ..a ..a ..a 0 .... \0 M M II) N M M V"\ M I/') V"\ 0 0 I/') ~ ~ 0 a 0 0, - 0 ;;:;. r-:- r-: r-:- I'- r-:- 00 ~ E- .- CD Z 0'1 M \0 a N 0 N V"\ "1" a 0 I/') V"\ "1" I/') \0 ~ '$. '$. '$. fl "': M OC! I/') a '<1: ~ '<1: '<1: 0 ~ ~ '<1: M "1" I/') 00 ~ c 0 N :::5 loCi ..,. \0 I'- \0 il M N 00 a 00 V"\ 0 I/') V"\ "1" r-: 0Cl ~ ~ '<1: Cl. ::!: "1" 00 "'T "1" a a r-- ,..., I'- I'- I'- "1" "1" E- ,..., 00 M \0 \0 a I'- 0 0 I/') M 00 V"\ V"\ "1" VI 00 00 M N 0 0 0 0 N ~ 00 rr'I rr'I N M N N 00 00 N 00 0'1 0'1 0'1 0'1 ~ ..a ..a ..a ..a ..a - ... M 0 \0 0 M 0 M \0 ,..., 0 0 \0 \0 0'1 N 0'1 .00 ,0 '$. '$. ....J V"\ 00 ~ 0 I'- ~ I'- OC! '""! ~ 0 00 00 ~ M M 0' 0' ::c: N \0 \0 00 M N 0 \0 a \0 ,..., 'r. ::: a M M "'T loCi r-- a M a ... 001 N "'T \0 C a 00 or. 00 00 I/') N or. z 81 00 0'1 \0, \0 \0 00. a 00 ~ \0, "':. or. V"\ V"\ or. V"\ C N ..a N "1" N' "1". "1" "1" or. or. \0 rr'I M 0'1 M 0'1 0'1 or. or. 0'1 ::!: 00 00 00 00, 00 ..a ..a ..a \0 ..a ..... CI) CI) ..... CI) ~ ;z: .- ..c r;; 0 [.tJ ~ .. .... g -<: - E= CI) ..c f- CI) H~ CO 0 U r;; < -<: >:::.: :I: C :E 'S E- -<: [.tJ ~ f$: E- o I:: ~ .- 0 -<: c:: ~ C ~ CI) CI) c:: CO c:: ~:z 0 [.tJ -<: E- ~ ... II) oo!: .~ E- O '(I{O ... U CI) ....J o:.:l E- W;J ~ .::2 .... - <( CI) CI) CI) 0 u.. ,Ll :E ::l I:: [.tJ < ---, ...... ... U ...~ 0 CI) ..- 0 - -<: 0 ~:E- 0.. t ~ [.tJ c:: f- CI) ~ U [.tJ ....J 0 [.tJ U [.tJ ~ [.tJ z:: ;z: - Vi ~ - ....J '" C ll;l: Z E- f- [.tJ < CI) CI) < ~ :o:.tJ.l II) II) ... CI) u.. CI) CI) [.tJ -<: ... ... ~ ~ -<: ~ 2: [.tJ f- f- x ...:.' x II) II) ~ rn f- [.tJ U [.tJ :~.:c:: .$ - '. ~ ....J [.tJ 0 0 Z IX CI) 0 -<: -= f: f: f: -<: &d < Z Z u.. f- 0 ;I: U .-:~ = 0 0 [.tJ c:: < ~ ~u ~ ~ :! :! ... :! F".i: a:l ri3 CI) :E ....J < ....J Z 0.. ,... CI) II) Q) <l> <l> ~ <l> ~ 0 - -<: [.tJ ~ ... ::: CI) ;::l ;::l ~. 0 Z E- [.tJ 5 ::: -<: 0 en =::00 ... ... QI: QI: f: QI: ;z: [.tJ U U a:l >- -<: U U "l:s "l:s "l:s 0 0 U U Z [.tJ N ~ -<: 0 0 ....J .....; ....J a:l ..:-<: < -<: <l> <l> :! <l> - 0 ::i ~ ::: ~ N N .::l E- f- < H..: o:.:l .... :.:: <l> Z Z Z l- f- - QI: .... - ;> < E- CI) Z I- CI) CI) ~ ~ ~ a Q tJ.l < .., < 5 z c: CI) H-:: f- CI) :::J ::c ::c - ::c 0 == :E -' 0 0.. 0 ...... CI) [.tJ ....J I:: I:: ~ ::: W ~ c:: :;;;. U a:l ;z: < < U .::...:0 ....J 0.. ::: ::: ~ ::: ..... a:l rn W :E U U .:::::::-:-:U ~ ~ ~ , 0 ,0 ,0 ,0 ,0 C\ "'1" t'"'l M \Q 0' 0' C' C' V) I'" 'r. ('I -0 . V) \Q .,., C - "':l v-i 00 ....; C C ""T 01 \Q r-- 00 C'- ~ "'1" 'r. C --0 00 II') "'1" 0>- \Q 6 ~ V) V) V) V) 0 ~I 0 \Q I'" ~ 0>- 00 V C C/) I.C) ,..., :.0 r-: -=' .c 0 .... S! - ~ "'1" ""T .... 0 :r: Q. ~ \Q "'1" - ("l "'1" 0>- ::l ~ ~ '1) C N V) ClIO 0>- -~ V C/'J -6 .c r-: c: r-- .0 .Q "'1" ~ 'T ""T .~ ~ ~ I'" r-- .,<> ~ ,0 ,0 .....0 Q5~ r-- "'1" 0 M r-- 0 0' 0' 0' ~..Q t:: ~ 'T ~ 0>- 0 V) ~ "'t: 0' 0 00 r-- 'T "':l -i- ,..., r--: 0 ci 00 ,..., ""1: N \Q r-- 00 & 'T r-- - "'1" V) ("I C .~ V) V) V) V"l t: "., 0>- r-- r-- ("'1 0>-, 0, <tl Q) 00 0 - C: ~ - "'1" "'1" M Q: ~ C/) ...... N V"l "'1" c: Q) ~ "'. ...... 0>-. - 0 0'\.. 0 C/) 0 . r-.: ~ V V) V"l '" O~ N N N N ~- 0 0 0 0 -,0 .. .... .... <Ii .... ~ ~ 0 0 0 III <a <a <a ~~ <a "5 0 0 0 0 ~ 0 0 0' C - V <I.l <I.l V ci ci ci ci 0 = >;- >- >;- >- ] 0 0 C 0 = ~~ 0 '" a: N , 0 ,..., V"l U = r- '" u III CI) E ::l -< ... ~ V r- e u :j u.. N r-- 0>- 0 0 0>- "'1" ~ r-- ~ I'" 0 0 r-- "0 '" 0 0 "'1" V"l V"l 0 V) '-0 V C N ...... ...... "'1" 00 ::l 0>- 0 0 00 03 0 00 r-: -0 -6 t:: l":1 U 'T ...... 00 00 V) U ~ -< '" N 00 00 r-- ei 0 ei N N N N 0 0 0 0 0 0 ,0 v;-, > 2 0; ,..., N 0 0 N 0 0' "'1" 0\ 0\ 0\ N a: C 'T "'1" 0 0 00 V"\ "'1" 0'1 0'1 "'1" :< <a O. N N. ~ 00. 0 ~ U 0 N .... 0 on ~ <I.l ~ 0 - - o. ::l r-: r-: r-.: r-- 00 N r- N V"\ I- 0 0 I- 00 ,0 V"l ~ ,0 ~ ~ ~ OJ Z 0"'" .,;. 0' i '" ~ ~ 0 0 ~ r-- I- 'T 0 V"l [;Iil ci ci '-0 0 l'-; "'1" ('I '" '" ...... ...... N \Q 0- a.. ~ il 0>- 'T "'1" 'T - 0 ...... ~ 00 0- I- ,..., r-- 0 I r- vi N 00 00 N ..... ..... 00 >- ...... "'1" 00 N N 00 I [;Iil 00 0'1 0>- 00 00 ;;. -0 -0 -0 -6 ~ ~ > 0 N N 0 0 N V) ,0 ...... ~ ~ ~ ,0 ...:l I ... 0' N ...... on 0 0 V) ,..., 0' N '" N N "'1" 0 ~ :::: ci 0.:. 'T ~ * 0; V"l ~ ('I ;; 0>- "'1" ...... 0 ...... "'1" '" .t,! ~ 03' '" N 0>- 0>- r-- ..c 'T ...., Z 81 N '"""!. on V) ('I 0 V C ~ -0 -0 -0 00 0 - V"\ "" 0 ;:: 0'1 on "'1" "'1" .... ~ s:: ~ I- 00 00 00 <I.l s:: -0 -0 -0 -0 :> ...... ~ -< ... ~ ~ ~ ~ ~ '" I- 0 - V"\ as 0 -l I'" 0; 0 "': <"! ~ -i- ...... ...... 00 <ti N :> -< "" ~ '" '" >< <I.l III "'0 "'0 <I.l ~ CoI 5 c "'0 ~:. :; ell 0 .5 I ell co \i t::l f- <I.l ~ - <I.l E - ..... :> ~ u LlJ ~ u as 0 0 .;: .;: ...~" LlJ <I.l :J ..-, ..:lll Cl 0 0 Q., Q., ::l ... C/'J ... .... C :J -l ~ ex: = 0 <I.l .~. ....J ~ ~ <a -< ...:c ~ 0>- E 00 V > ... -< ... E I:: -< ::i -< > ~ LlJ V 00 ::l Jlit > o:J f- -< '" = f- -< ~ ...:0:: f- >- c U .~::: '-' ... c 0 f- C/'J > C/'J ~ ... LlJ ::: .... ~. "" 0 "" U LlJ ~ f- ::.c:: "- LlJ f- ~ ..c E ~ 0::: en 0::: \i 0 C/'J >: LlJ Cl ~ ..c ~ ::.c:: 0 :I: 00 -< :z c <I.l .ti.. -< f- t:: ~ ':::l -< co -l ~ ~ ex: c.. f- :a e 0::: E -< u.J ~ ~". Cl t:: 0 :z ..c >- Cl ~ UJ Z \i <I.l f- UJ -l -l "':l ~ 0 ....J :< C2 :J 0 -< -< ~ :z ... r:: 2: 0::: ~ t: t: In ~ ::: < :J :J 'l; U U Cl c.. c.. :.0- 0 1: ex: ~ U ;z -< -< -< LlJ ~ :J .... 00 -< ~ u u co Cl & SCHEDULE OF CITY FUNDS Month Ending: Sep-30-99 MANAGED FUNDS PORTFOLIO TOTAL COMPOSITION COST CITY FUNDS PERCENT AGE BASIS PERCENTAGE I DANA INVESTMENT ADVISORS. INe.: CASH 0.00% 0.00 TRUSTSAVTNGSACCOUNT 0.00% 0.00 MUTUAL FUNDS (US GOVERNMENT) 3.35% 231,063.34 CERTIFICATES OF DEPOSIT 0.00010 0.00 US TREASURY OBLIGATIONS 0.00010 0.00 FEDERAL AGENCY OBLIGATIONS 96.65% 6,663.820.52 TOTAL 100.00% 6,894,883.86 14.87% IDUBUQUE BANK & TRUST COMPANY: CASH 0.000/0 0.00 TRUST SAVTNGS ACCOUNT 0.00% 0.00 MUTUAL FUNDS (US GOVERNMENT) 9.00% 622,505.40 CERTIFICATES OF DEPOSIT 0.00% 0.00 US TREASURY OBLIGATIONS 21.76% 1,505,632.50 FEDERAL AGENCY OBLIGATIONS 69.25% 4,791,937.55 TOTAL 100.00% 6,920,075.45 14.93% I MERCANTILE BANK MIDWEST CASH 0.00% 0.00 TRUSTSAVTNGSACCOUNT 0.00% 0.00 MUTUAL FUNDS (US GOVERNMENT) 6.19% 436,727.43 CERTIFICATES OF DEPOSIT 4.25% 300,000.00 US TREASURY OBLIGATIONS 65.38% 4,613,524.65 FEDERAL AGENCY OBLIGA nONS 24.18% 1,706,416.44 TOTAL 100.00% 7,056.668.52 15.22% TOTAL MANAGED FUNDS 20,871,627.83 45.02% I CUSTODIAL ACCOUNT: A T&S BANK CASH 0.00% 0.00 TRUSTSAVlNGSACCOUNT 0.00% 0.00 MUTUAL FUNDS (US GOVERNMENT) 0.00% 0.00 CERTIFICATES OF DEPOSIT 0.00% 0.00 US TREASURY OBLIGATIONS 0.00% 0.00 FEDERAL AGENCY OBLIGA nONS 0.00% 0.00 TOTAL 0.000/0 0.00 0.00% I BREAKDOWN BY TYPE OF SECURITY: CASH 0.00% 0.00 0.00% TRUSTSAVlNGSACCOUNT 0.00% 0.00 0.00% MUTUAL FUNDS (US GOVERNMENT) 6.18% 1,290,296.17 2.78% CERTIFICATES OF DEPOSIT 1.44% 300,000.00 0.65% US TREASURY OBLIGA nONS 29.32% 6,119,157.15 13.20% FEDERAL AGENCY OBLIGATIONS 63.06% 13,162,174.51 28.39% Total Managed Funds and Custodial Acet. 100.00% 20,871,627.83 45.02% 1 of 3 , 4 SCHEDULE OF CITY FUNDS Month Ending: Sep-30-99 .. OTHEItFUNDS. APPROXIMATE IDENTIFICATION RETURN I EXPENSE ADVANCES CHANGE FUNDS & PC ADVANCES N/ A PErrY CASH PURCHASES N/ A INSURANCE DEPOSITS N/ A TOTAL I CASH I BANK N.O.W. ACCOUNTS: AMERICAN TRUST & SAVINGS BANK DUBUQUE BANK & TRUST CO. FIRSTAR BANK IOWA. N.A. MERCANTILE BANK MIDWEST TOTAL I BANK MONEY FUND SAVINGS ACCTS: AMERICAN TRUST & SAVINGS BANK DUBUQUE BANK & TRUST CO. TOTAL I TRUST POOLS: IP AIT TOTAL IMUTUAL FUNDS (US GOVERNMENT): TOTAL I CERTIFICATES OF DEPOSIT: DUBUQUE BANK & TRUST COMPANY AMERICAN TRUST & SAVINGS BANK DUPACO COMMUNITY CREDIT UNION FIRSTARBANK IOWA. N.A. TOTAL I U.s. TREASURY OBLIGA nONS: CHICAGO FEDERAL RESERVE BANK IREPURCHASE AGREEMENTS: ICORPORATE SECURITIES: AT&T & REGIONAL STOCK TOTAL OTHER FUNDS TOTAL CITY FUNDS N/A 2.9500% 2.5000010 2.0000% 2.0000% 4.3800% 2.8500% N/A N/A 5.3400% N/A 5.2290% 4.9100% N/A 20t3 COST CITY FUNDS BASIS PERCENTAGE 18.056.00 591.68 1.000.00 19.647.68 0.04% 14.123.43 0.03% 192.802.10 1.109,401.57 12.768.86 211. 752.86 1.526.725.39 3.29% 1.683.167.42 1.030.373.05 2,713.540.47 5.85% 0.00 0.00 0.00010 0.00 0.00 0.00010 790.045.69 0.00 1,272,922.81 0.00 2,062.968.50 4.45% 19,145,240.00 41.30010 0.00 0.00% 6.822.60 0.01% 25,489,068.07 54.98% 46,360,695.90 100.00% . , SCHEDULE OF CITY FUNDS Month Ending: Sep-30-99 ....Ar=;li~;(ilQMJJ~Pf~AGF.S:... MANAGED FUNDS 0.00% OTHER FUNDS 0.04% COMBINED TOTAL 0.04% EXPENSE ADVANCES CASH 0.00% 0.03% 0.03% BANK N.O.W. ACCOUNTS 0.00% 3.29% 3.2<}o1o BANK MONEY FUND SA VTNGS ACCTS 0.00% 5.85% 5.85% TRUSTSAVTNGSACCOUNTS 0.00% 0.00% 0.00% TRUST POOLS 0.00% 0.00% 0.00% MUTUAL FUNDS (US GOVERNMENT) 2.78% 0.00% 2.78% CERTIFICATES OF DEPOSIT 0.65% 4.45% 5.10% REPURCHASE AGREEMENTS 0.00% 0.00% 0.00% US TREASURY OBLIGATIONS 13.20% 41.30% 54.50% FEDERAL AGENCY OBLIGATIONS 28.39% 0.00% 28.39% CORPORATE SECURITIES 0.00% 0.01% 0.01% TOTAL 45.02% 54.98% 100.00% 30f3 , .., .~ - 'C = ~ ~ ~ =00 ;t' -= = = ... ... ~ - ~ ... r- =E- ,. ... .~ Q ~ ~ -= ~ GI .c ~ 00 0'1 ~~ ..,= <~ 0'1 , , ":l- ~ ~ I: ~ ~ - ~ = <- Q - - .- ... r- .....E ~ ~ =:; ~ .~ Q ~ u= ,. - .C ~ = - - ~ ~= :; GI GI =- ... ~ .:l= GI r- :: ~e; =-> ~ ~ > GI ~ 'C =- = z e: 00 .. u -T -T ...., ~. ...., - ~ ,..., -;;? ~ 00 N N -T ~ g co,' '" co, ~ o o 0\ '" 0\ 0\ 0\ -..... -T - -..... o - go 0\ -..... '" - -..... o - o o o o o O' o O. - ~ ,..., U U '" 0\ l"- N - 0\ ..0 ,..., N ,..., N.. co, ,..., ~ N -T '<t. '" o ~ -T 25 ~ =- r-:.. or\ .,... co, ~ 0\ ,..., .,... .,... 0\ 0\ co, -..... N - -..... - go 0\ -..... N - -..... - - o ~ o o o o o O. - ~ o u .,... co, l"- N - 0\ 00 'C 00 l"- e-.. ..:;) g xi -T '<t. N -T I"- -i- g ...., co, '" ..0 I"- 0\ ~ 0\ '" \Q r--: 0\ 0\ 0\ -..... go - -..... - - 0\ 0\ -..... o N -..... .,... o o o o o o 8A - ~ - > U '" 0\ l"- N - 0\ \Q 00 N 8 ..; o o -a I"- -;;? ~ \Q I"- 0\ -i- o o ~ ~ -T. '" I"- 0\ ~ 'C -T '" r--: 0- 0\ 0\ -..... 'C - -..... N - 0\ 0\ t:: - -..... \Q o o g o o' o o. - ~ '" >- u '" 0\ l"- N - co, S "1" 00 I"- r-: ..0 '" o go N ,..., r-- or) I"- '" xi...c N ...., xi o~ '" N N ,..., -;;? = '" N ~ -T '<t.'<t. N - r-- "1" '" 0 -T '" g 00 ~o o on 00.- '" or) .,... I"- 0-0\ ~~ ;;:; r-: I"- co, ~ '" r-- r-- 0- 00 .,... or) lOr--: 0\ 0\ ~ 25 -..... r-- ~ - 00 ~~ ,..., 0 -..... - N -..... N 0\ 0- -..... 0- N -..... r-- 0\ 0\ 0\ 0\ -..... -..... :!~ N -..... 00 o o o o o o o O. - ~ 00 00 00 00 00 0.0 00 O. O. - - ~~ 00 t.IJ o '" co, l"- N - 0\ ~G 00 '" '" co, 0\ r-- l"- N N - - 0\ 0\ or) "1" r-- r-- ~ 0\ r"~ N =~ ::\c\ - - N N 00 ~ - ~ - S:::~ NN '<t. ~ r::::: "1" ~'<t. :t:t r:::::r::::: "1" -T ;r; '" -T '" ~ ~ o o ~'C ..;..; I/"l '" ~ 0\ ~~ '" '" "1" '" ~ _0 \Q 'C "1" -T '" '" co, 0\ "=::: o ,..., -..... ,..., ~ ~~ N N -..... -..... -T -T 0\ 0\ -..... - -..... -T 0\ 0\ 0\ 0\ -..... -..... 0- 0\ N N -..... -..... -T -T o o g o O' o O. - ~ 00 00 00 00 00 8~ 8~ - - ~~ ,..., 0.. o I/"l 0- r-- N - 0\ I/"l or) E-E- 00 '" '" ~ 0\ I"- r-- N N - - 0\ 0\ ..0 'C 00 go "'1" -T t::S '.:: ...c 253 r--:r--: ...., ,..., N N ~'<t. r-- r-- .,... '" 00 go -T -T _5 =-0'\ ,..., ,..., '" '" co, 0\ OA ~ co, 0\ ,..., ,..., I/"l '" 0'\ 0\ 00 .:::::~ '" '" N N -..... -..... '" '" 0\ 0\ co, 0\ t::::r:::: N N -..... -..... .,... '" ~o 00 00 00 00 00 00 o. o. - - ~~ ..0 'C xx 00 .,... '" co, C\ r-- r-- N N - co, Q'\ or) -T co, 00 "1" -T r-- N I/"l ,...,0; ,..., o ~~ I/"l or) ..0 'C N N '#.'<t. -T -T -T .". - .,;.,; _0 ~o ~~ I/"l 'C. 0- '" '" 0- go ~N ~ 'C \Q .,... '" o~ .,... '" co, Q'\ 00 ~~ N N N N -..... -..... 'C'C 0- Q'\ 0\ 0\ -..... -..... -T .". N N -..... -..... \Q 'C 00 00 00 88 go. 08 -: ,..,..;' ~~ ,..., ,..., ~lXl t.IJt.IJ '" '" co, Q'\ r-- r-- N N - - Q'\ Q'\ r-- 00 r-- r-- '" '" =~ r:::~ N N ,..., ..0. on 25 o ~o 0- Q'\ -T .". ,..., ,..., N ,..., -;;? ~ '" o N '" '#.'#. r-- r-- \Q 'C N N '" '" ~ ~ 25 o o I/"l 0- ~ ~~ 00 \0 'C - ..; .".' N N -T. -T. - ~~ o o ~ .,... co, -T -T -T .". Q'\ Q'\ -T -T 0- co, o o t:: - -..... go 00 ~~ -T .". - - -..... -..... 0\ 0\ 0\ Q'\ -..... 0\ - -..... go Q'\ Q'\ 0\ 0'1 -..... -..... \Q 'C - - -..... -..... 0'1 0'1 o o o o o o' o o. - ~ 00 00 00 00 00 00 00 "'.."'.. - - ~~ r-- t.IJ t.IJ '" co, r-- N - 0'1 -T .". ~~ t.IJt.IJ '" '" '=" C\ r-- r-- N N - - 0'1 0'1 N co, xi ...., ~ r;:; fA ;:;; N .n -T .-.,.\ - ~ o o o o o o. o o o N fA ... e; - Q ~ <t} >. ~ o '" r-- N o N '#. o - 0'1 -i- io=. - 'c .e . ~ ~ GI - .c ~ .~ ~ -= 'il > ~ GI - .c ~ .~ ~ en ...J X ..J ...J in I- o o o .". N "'. .". - 0'1. - .... ~ ... . = 't:l Q U '" , .. - ";J g, QJ = ... QJ = = CO2 ::r'QJ =- .:: 1:0 =~ = "- ...t: = QJ ...u .~ "- u = QJ 'S ~ QJ ..c: Cj ~ ~ - QJ CO2 C ~ Cj QJ Cj - <.: =- - .C ~a 1:0 1:0 =:2 ~ QJ ~ =~ 8 .!t f> = u - CO2 a -;; u: ~ ~= QJ QJ QJ = E.. ': ~= ;~ ~ ... .c ~ a1C 1:0= :2 ~ -=! ~= If ~ ~ = ~ ~ QJ .. = ~7i > .;..; o ~ .. QJ e1 = z ,... C "T ?!. r--. M .,.; M \0 lI"\ lI"\ ..; lI"\ \0 ~ 0\ 0\ 23 <"l -- 0\ C 0\ 0\ -- ~ -- c 00 0\ -- ~ - -- c - M - -.c lI"\ lI"\ ~. lI"\ \0 ~ "T \0 C \0 M ::: o o M 00 ?!. <"l <"l 00 lI"\ 0\ \0 \0 \0 ""'- 00 - \0 ~ 0\ 0\ -- o <"l -- 0\ o c ~ C <"l -- <"l o 0\ 0\ -- C <"l -- 0\ C 0\ ~ \0 \0 ...... 00 - 1.0 ~ 00 0\ 1.0 l' M 'r) lI"\ "T lI"\ oot: M \0 "T ,..., ?!. ..... ..... 00 lI"\ 0\ \0 lI"\ "T o 0. 0\ r--. ~ 0\ 0\ -- o - -- ~ ~ 25 -- o - -- 0\ o 0\ 0\ -- o - -- C'\ o 0\ ~ lI"\ "T o o' C'\ r--. ~ N ::: lI"\ 'r) lI"\ "T lI"\ "T N ;A ir; 00 1.0 0\ N ~ N ;A o lI"\ 00 1.0 0\ N 1.0 O. M ~ '" e; - = E-o ~ .. 0\ o \0 lI"\ ~ ~ ,. ~ QJ - ..c: =tl .~ ~ o lI"\ 00 1.0 0\ N 1.0 o N ~ ;,; "i = - CO2 = U <II ..... :'3 o ;r; C'\ ... - "C = - 1:0 :2 ~ QJ - -= Oil "~ ~ ~ ~ ~ =~ ; .~ f> = u Q.} .= - CO2 ,. ,. CIl:= <II = o oa 'i: u <II <l) Cl <l) ~ ~ t:: <l) U ~ 3ll ,. '5 E .. E cf~ 'II = t ~~ ~ ~ ez '" E .. QJ E-o - '" ~ 'II - = - QJ 1C cc: 8- 'g "i: 0- .9 "1:l :g :'3 "1:l I: 1:0 ~ -;a = I: ~ ...!. ::: ~ ~ "1:l ~ ~ ~ U <II OIl .s i: 1:0 tIJ ?!. ..... ..... 00 lI"\ ~ r::: \0 lI"\ lI"\ \0 <"l ::::; 00 - o u ~ ~ co o N - - o lI"\ 8- '13 ::: 'i: 0- .9 "1:l :8 1:0 "1:l I: ell ..... ;:: <l) t:: ell 6 "1:l ~ ~ <l) ... U <II OIl I: "e 1:0 tIJ a 'g "t: 0- .9 "1:l :g 1:0 "1:l a ..... ;:: <l) t:: :'3 6 "1:l ~ ~ <l) ... U <II OIl I: 'E ell tIJ ?!. l' M - .,.; ~ .. ..... r""l 00 lI"\ en ~ ~ c (,) ?!. o o o lI"\ ?!. o l' ~ lI"\ C 1.0 ..... -- o 0\ o \0 ..... ~ o u a :::s o o 8- :::s o "T 1.0 o 1.0 N 00 0\ \0 r--. N ~ .\.~ CITY OF DUBUQUE, IOWA MEMORANDUM October 15, 1999 TO: Michael Van Milligen, City Manager SUBJECT: Quarterly Investment Report () \D \.0 ;.+ c:> 0'<: ("'") :0 c (- -i rn cr >. ) C (D C) ...0 ::::~"- co nl c: ~D (/) -0 h::: 0 =--' -- )> - I'll -h ..... 0 o' 00 (0 .r::- -.J ~ FROM: Duane Pitcher, Finance Director INTRODUCTION The purpose ofthe 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 July 1, 1999, and ending September 30, 1999. 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 of the City. The City is in compliance with the Investment Policy. REQUESTED ACTION This report is for your review and filing with the Honorable Mayor and City Council. Attachments CITY OF DUBUQUE, IOWA CASH AND INVESTMENTS SUMMARY AND SUMMARY OF INVESTMENT EARNINGS FOR THE QUARTER ENDED SEPTEMBER 30, 1999 AND mE ACCUMULATED YEAR- TO-DATE DESCRIPfION MONEY FUND SAVINGS ACCOUNTS MUTUAL FUNDS INVESTMENT POOLS CERTDnCATESOFDEPOSIT REPURCHASE AGREEMENTS US TREASURY SECURnnES FEDERAL AGENCY SECURITIES CORPORATE STOCK INVESTMENT ADVISOR ACCOUNTS INVESTMENTS MARKET VALUE CARRYING (INCLUDING VALUE o\CCRUED INTEREST 2,713,540 2,713,540 o 0 o 0 2,062~69 2,065,423 o 0 19,145,240 19,454,559 o 0 6,823 136,699 20,871,628 20,886,036 44,800,200 45,256,257 CASH ACCOUNTS 1,560,496 1,560,496 TOTAL FUNDS AVAILABLE 46,360,696 46,816,753 CITY METRO COMBINED 39,330,562 7,030,134 46,360,696 39,786,619 7,030.134 46,816,753 ,.............. . . . . . . . . . . . . .. ......... ........... . .......... . .................................. . ...............................". . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . - . . . . . . . . . . . . . . . . . . . . . . . . . . . ............... . . . . . . . . . . . . . . . . . . . . . . . . . . . . - . . . . . . . . . . . . . . . . . . . . ........................"................. ...-. . ............. '... ............. -.. CASH BASIS GROSS EARNINGS: CITY METRO COMBINED QUARTER YR-TO-DATE 455,936 90,130 546,066 455~36 90,130 546,066 INVESTMENT FEES: CITY METRO COMBINED 33,571 102 33,673 33,571 102 33,673 NET EARNINGS: CITY METRO COMBINED 422,365 90.028 512,393 422,365 90,028 512,393 Qinvsum1 UNREALIZED GAIN OR (LOSS) o o o 2,455 o 309,319 o 129,876 14,408 456,057 o 456,057 456,057 o 456,057 00 0'1 V) ~ 0 V) ~ 0'1 ~ V) 0 ~ = ~ '0 ~ ~ ~ ~ ~ 0 00 C'! 0 V) ~ ~ 0 0 V) 0\ ~ C'! V) l'- 0'1 '"0 0 -i- 0 iii \Ci 00 ~ '0 N 0'1 (U N N ~ 00 Irl 00 '0 ~ 0 N N N l'- ~ 0 C ~, Irl '0 ~ - N 0 ~ ~ 00 ~ 0\ ~ l'- 00 Irl :E 00 N - - 00 N 0 0'1 o~ N IoC 0'1 0 '0 Irl Irl ~ Irl ~ "0 N ori' l'-~ N ~ ~~ ~ t~ ~ l'-~ O'I~ r-: Q.. E f- 0'1 0 '-' 0'1 00 0'1 00 ~ ~ 0'1 (U 0 ~ N ~ N - fO'l ~ '0 Irl ~ C/'J U r-: r-: - \IS r-: r-: ~ ~ ..,. ~ ~ eo l'- l'- 0 l'- 0 0 ~ ~ 0 ~ 0 ~ l'- 0 0 l'- l'- ~ ~ ~ c I C! 0 0 0 '0 ~ ~ Irl 0 Irl 0 ~ C! ~ C! :0 -i- 0 -i- 0 0 0 000 ~ 00 ~ 00 00 00 Irl 00 l'- ~ Irl 00 ""! N C ~ l'- l'- 0 0 0 '0 ~ '0 0 '0 l'- \Ci WJ '0 00 00 N l"! ~ '0 N 0 ~ Irl. l'- Irl ~ ~ o~ ~. ~ N N ~. 0\ . ..c N ~ ~ 00 - '0 C N 0'1 0'1 0'1 N 00 - 0'1 - N ~ '0 -:, ~. '0 ~ ~ Irl 0 '0" '0. ..0 '0' ::E - Irl N N N N N 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ~ ~ :::R ~ C 0 0 0 0 0 0 0 0 0 0 0 0 0 0 C! 0 0 0 :g 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ::l 0 0 0 0 0 0 0 1i; U ::l U U <( - N Irl l'- 0 Irl 0 Irl ~ N 0 0 ~ M '0 l'- ~ ~ ~ ~ M 0'1 00 0 0 Irl 0 Irl 00 Irl 0 o 00 00 C'! C! ~ 0; r..: -i- 0 0 0 Or..: r..: l'- ~ - '"0 ell ~ Irl Irl l'- 00 Irl Irl l'- l'- ""! ~ (U C 0 00 ~ ~ N N N N N 0 M bO ::l l"! M - N ~ ~ ~ ~ 'O~ ~ Irl. 0'1 O. Irl Irl Irl o:l 0 l'-~ ori' N 0' r-: c - - - 00 '" U l'- 0 0 l'- 0 l'- l'- M ~ l'- ::E u l'- 00 00 00 N N 00 <( 0' 0' 0' o' 0' N N N N N l'- M 00 Irl 0 0 0 0 N Irl 0 0 N N M 0 0'1 ~ ~ ~ ~ ~ ~ ~ ~ N ~ 0 ~ 0 ~ Irl C! 0 0 V) Irl ~ ~ r..: 0 0 0 0 0 00 0 0 00 00 0; ~ ~ 0'1 l'- 00 0': - M l'- ~ ~ C M '0 N ~ '0 M '0 '0 l'- M .n 0 < o:l 0 N N '0 '0 ~ '0 '0 '0 l"! N '0. Irl Irl ~ (,) 0' l'-~ r-: '0 ..0 ..0 'O~ M O' M ... (U N M M Irl M Irl Irl 0 0 Irl ~ ~ 0 0 0 0 - 0 ~ l'-~ r-: r-: r-: r-: 00 ~ Eo- ,-.. 0 CD Z 0'1 M 0 N N Irl ~ 0 0 Irl Irl ~ Irl '0 :::R ~ ~ ~ CD ""! M ~ 0 ~ 0 ~ ~ 0 0 ~ ~ ~ ~ Irl 0 (lJ ~ N 0 0 N 0 0 \Ci r..: ~ '0 l'- '0 ~I M 00 00 Irl Irl Irl ~ 00 ~ 0 ~ a.. ~ 00 0 0 l'- M l'- l'- l'- ~ ~ -i- M '0 '0 0 l'-~ 0 0 Irl M 00. Irl Irl Irl 00 oC M O' 0' 0' 0' N~ ~ 00 M N M N N 00 00 N 00 0'1 0'1 0'1 0'1 '0' ..0 ..0 '0' ..0 > M 0 0 ~ 0 M '0 ~ 0 0 '0 '0 0'1 N 0'1 ~ ~ ~ ~ ~ or: 00 0 l'- 0 l'- ~ M 0 0 00 00 ~ M ~ ~ 0 \Ci 0 \Ci 0 0 -i- N '0 '0 00 ~ ~ Irl M M '0 l'- C! M 0 ~I N ~ 0 0 00 Irl 00 00 Irl N Irl Z 00 '0 '0 oo~ 0 00 00 '0. M Irl. Irl Irl Irl Irl 0 N ~ N ~ ~. ~ Irl' V) '0 0'1 M 0'1 0'1 Irl Irl 0'1 ~ 00 00 00 00 00 'O~ ..0 ..0 '0' '0' C/'J C/'J ...... 00 ~ ~ ,-.. ...... ..c - en WJ ! '....h ~ <( - ~ en ...... ..c f- en <( - 'S I lXl - U - :::-:.:.:.:::: ::c c ~ Q ~ en ~ 0 &:: f- ,-.. Q <( ~.f- ::E - ~ ..~ en en lXl 0::: ... ....z 5 0 f- WJ <( f- U 0 ~:o .51 l: U en en .....l lXl f- WJ C/'J .... en en Q .....l ~ ;:::~ ::l &:: ~ 0 ~ :J ... U .~ WJ C/'J en 0 '-' ~ Q c.. ~ f: c:I'I U WJ .....l 0 WJ U WJ WJ 1i; 1i; to; ~ '-' WJ .....l en ~ Z:.Z (U (U a .... 1'$' z f- en f- C/'J <( C/'J ~ Q:::~ ... <( ~ ~ ~ WJ C/'J WJ <( f- t (U ~ ~ ..~ f- WJ f- U WJ I' - - '. f: .....l 00 WJ 0 0 Z 0::: 00 @ <( c c E E E <( ~ z z ~ - - =: 0 0 WJ 0::: f- <( U 0 U aU '"0 '"0 a a .... a lXl C/'J .....l ~ ~ c.. f- (U (U ~ :~ 00 ~ Q ... ~ <( ~ WJ - C/'J ~ ::l " " " I Eo- - .... :::gz Clc: Clc: Clc: ..~ Z WJ 5 Q ~ C/'J ... E 0 WJ U 0 U >< <( .'. :':C/'J 8 l ~ ~ :0.. WJ N ~ <( 0 0 :E .....l ~ co ::........::<( <( <( " a " E Q - ~ <( '" ;g J;t ~ f- ::-:-:':...:. lXl :; " :> z :g z ~ f- f- f- f- ::.::::::.:f- C/'J C/'J l::t Clc: ~ 0 Q ~ <( <( ~ z E: E: C/'J C/'J :J :::c :::c - :::c WJ ~ 5 ffi ~ U co 0 <( <( 0 ::~ WJ .....l &:: &:: ~ &:: ~ U .....l c.. &:: &:: ~ &:: co 00 WJ U U .:::::::::::::U "'l:: "'l:: "'l:: '" ..". ~ 0 M 1.0 ~ ?t- ';!( ?t- ?t- o V'! 0 V) N 1.0 V) 1.0 V) 0 '" "'0 .,.; CO :;i 0 0 ..,f ..,f V) t"J 'C! r- OO '" V - I c "al 1.0 00 ..". '" 1.0 0 C .J:: V) V) V) V) fI) It) 0 :.E 0 1.0 l"'- N '" 00 V C M '0 r-: "'~ ..c ..,f' O~ ..".~ .... ~ ..... I E .... 0 ::t c.. E-< 1.0 ..". - N ..". '" ;:l :::E CO v 0 N V) QC) - '" 1.0 U 0::: t::: r:n U \l:S ..c - r-: r-: ..". ...,. ..". ..". .00 Oil ?t- ~ ~ ~ ~~ r- r- ..". 0 M r- r- ~ I ~:Q c ! ..". ~ '" C! V) ~ ~ 0 0 CO r- ..". :a ..,f ~ 0 - N 'C! r- OO & M 0 CO M ..". "- C ..". r- - ..". V) N 0 .... -5 V) V) V) V) t::: c.J '" r- r- N '" O~ 0 c .s ~ .J:: 00 - 0 ..,f' ..,f' M .;: 0 fI) g - - M N V) ..". Q.. :::E t::: ~ ~ M '" - 0 '" :::E V) v) - r-: 1.0" 8~ N N N N ~- 0 0 0 0 0 0 0 ~ QI) .... .... a .... :;:, ~ "a c.a ctl ctl ctl ~~ - 0 C! 0 0 0 0 0 v v v v 3 0 0 0 0 0 0 0 >- >- >- >- :a 0 0 :I all ~tf ...1:Il: I I I I 0 8 0 - N M V) - all E-o '" QI CIj E ;:l <: "" ~ U E-o ~ u :::i N r- '" 0 0 '" ..". ~ r- C! r- 0 0 r- - '" 0 0 0 ..". "'0 V) V) V) 1.0 V - C N M M ..". 0 CD ;:l - '" 0 0 ~ ctl 0 OO~ r-: \l:S \l:S c ctl U ..". M co 00 V) u :::E <: 1.0 N co co r- 0 0" 0 0 N N N N 0 0 0 0 0 0 ~ V) I > ~ '" ~ N 0 0 N 0 ..". ..,f 0\ 0 0 0\ 0\ N ~ - ..". 00 C V) ..". 0- 0- ..". 0 B 0" C"!, N" C"!, co - 0 - - N" ~ - 0 .- .- V) ~ :::E 0 - 0 ;:;:l r-: r-: r-: r-: rI;i ('II ~ N V) r- 0 0 r- co ~ V) ?t- ~ ~ ~ ~ CD I fi 1.0 ~ C! 0 0 C! r- ..". r- ..". 0 V) IiIil '" 0 0 1.0 C! t'-: ..". ~I 1.0 M M N 1.0 - t"J 0- Q. ~ '" ..". ..". ..". - 0 0 M N 00 0- E-o r- M .- - r- . I v) N " 00 N E-< ..... rI;i co >- ...... ~ ..". co N N 00 I 00 0- '" co ~ \l:S \l:S \l:S \l:S > 0 N N 0 0 N V) ~ M ~ ~ '::f? ~ ~ I t; .. N ~ V) 0 0 V) M N N N ..". 0 ~ 0\ 0 0\ ..". ctl * 0- V) ~ t"J .~ ..". M 0 M ..". ....J '" ~I 1.0 N 0- '" r- 0 .J:: ..; M '7 ~ C"!, M V) V) N V C - " 1.0" \l:S 00 ~ - V) 1.0 ctl 0 ;:s 0- V) ..". ..". ~ :::E ~ ~ r- oo 00 00 ~ \l:S \l:S \l:S \l:S > M ;-: <: - ~ ~ '::f? ~ ?t- '" ~ as 0 r- .- .- V) ....J :::E r- ~ C! ~ t"J ..". M M 00 II) N > <: ....... QI) a '" '" >< V QI "'0 "'0 v ~ ~ 6 6 "'0 ::~:: :; l%l c I l%l l%l - 'Ill III E-< v ~ - >.~ ~ ll) E - u ~ ~ ~ as 0 0 ;:E ;:E H~' U.l V ,..., 00 0 ;:l ~ r:n "" ~ I:: H~' :J ~ r:n "a ....J ~ all ~ E ....J ....J > <: ~ < ~ 00 ~ v .... ~ < <: > ~ U.l v 00 Hm. > ....J l) E-< <: '" E-< ~ ~ ..Ioi: E-< >- 6 u E-< r:n r:n ~ a c.J .s '-' t:: a ~ ~ U.l 0 U ~ E-< E-< :::E .J:: E en 'Ill 0 U.l 0 ~ r:n -5 <~: U.l ::.c 0 :I: 00 ~ ;z c I <: E-< c c: ~ ctl ....J :::E ~ ~ Q.. E-< :a e E ~ U.l ~ c 0 0 ;z .J:: >- 0 U.l ~ 'Ill V E-< ~ 0 ....J ....J as ~ 0 ....J ii! ;z ~ <: - ~ - E= t: '" z: ~ :J 0 ;:l a 'Ill u U Q.. Q.. :.a' ~ c.J U ;z < < < U.l ~ :J H, r:n <: U.l u U l%l 0 ...... SCHEDULE OF CITY FUNDS Month Ending: Sep-30-99 oMDA(;tJ)F.lJNDS 0 "0 "" 0 PORTFOLIO TOTAL ~.<~~>~~~:~~:~:><:~:~:~ : :.';::';.' .:~". . :; :.,'.>~ -. .. - . -.....,............ "," ",- '", . ..,.................... . ... .. COMPOSITION COST CITY FUNDS PERCENTAGE BASIS PERCENTAGE IDANA INVESTMENT ADVISORS, INC.: CASH 0.00% 0.00 TRUST SAVTNGS ACCOUNT 0.00% 0.00 MUTUAL FUNDS (US GOVERNMENT) 3.35% 231,063.34 CERTIFICATES OF DEPOSIT 0.00010 0.00 US TREASURY OBLIGATIONS 0.00010 0.00 FEDERAL AGENCY OBLIGATIONS 96.65% 6,663,820.52 TOTAL 100.00% 6,894,883.86 14.87% IDUBUQUE BANK & TRUST COMPANY: CASH 0.00010 0.00 TRUSTSAVTNGSACCOUNT 0.00% 0.00 MUTUAL FUNDS (US GOVERNMENT) 9.00% 622,505.40 CERTIFICATES OF DEPOSIT 0.00% 0.00 US TREASURY OBLIGATIONS 21.76% 1,505,632.50 FEDERAL AGENCY OBLIGATIONS 69.25% 4,791,937.55 TOTAL 100.00% 6,920,075.45 14.93% lMERCANTILE BANK MIDWEST CASH 0.00% 0.00 TRUSTSAVTNGSACCOUNT 0.00% 0.00 MUTUAL FUNDS (US GOVERNMENT) 6.19% 436,727.43 CERTIFICATES OF DEPOSIT 4.25% 300,000.00 US TREASURY OBLIGATIONS 65.38% 4,613,524.65 FEDERAL AGENCY OBLIGATIONS 24.18% 1,706,416.44 TOTAL 100.00% 7,056,668.52 15.22% TOTAL MANAGED FUNDS 20,871,627.83 45.02% ICUSTODIAL ACCOUNT: AT&S BANK CASH 0.00% 0.00 TRUSTSAVTNGSACCOUNT 0.00% 0.00 MUTUAL FUNDS (US GOVERNMENT) 0.00010 0.00 CERTIFICATES OF DEPOSIT 0.00% 0.00 US TREASURY OBLIGATIONS 0.00% 0.00 FEDERAL AGENCY OBLIGATIONS 0.00% 0.00 TOTAL 0.00% 0.00 0.00% IBREAKDOWN BY TYPE OF SECURITY: CASH 0.00% 0.00 0.00010 TRUST SAVTNGS ACCOUNT 0.00% 0.00 0.00% MUTUAL FUNDS (US GOVERNMENT) 6.18% 1,290,296.17 2.78% CERTIFICATES OF DEPOSIT 1.44% 300,000.00 0.65% US TREASURY OBLIGATIONS 29.32% 6,119,157.15 13 .20% FEDERAL AGENCY OBLIGATIONS 63.06% 13,162,174.51 28.39% Total Mtlllaged Funds and Custodial Acet. 100.00010 20,871,627.83 45.02% 1 of 3 ........~Jii'NJ)s}<..................... . ............... ..... ...... SCHEDULE OF CITY FUNDS Month Ending: Sep-30-99 4.3800% 1,683,167.42 2.8500% 1,030,373.05 2,713,540.47 5.85% N/A 0.00 0.00 0.00010 APPROXIMATE IDENTIFICATION RETURN 'EXPENSE ADVANCES CHANGE FUNDS & PC ADVANCES N/ A PElTY CASH PURCHASES N/ A INSURANCE DEPOSITS N/ A TOTAL I CASH I BANK N.O.W. ACCOUNTS: AMERICAN TRUST & SAVINGS BANK DUBUQUE BANK & TRUST CO. FIRSTAR BANK IOWA, N.A. MERCANTILE BANK MIDWEST N/A 2.95000/0 2.5000010 2.0000% 2.0000% TOTAL I BANK MONEY FUND SAVINGS ACCTS: AMERICAN TRUST & SAVINGS BANK DUBUQUE BANK & TRUST CO. TOTAL ITRUST POOLS: IP AIT TOTAL IMUTUAL FUNDS (US GOVERNMENT): N/A TOTAL ICERTIFICA TES OF DEPOSIT: DUBUQUE BANK & TRUST COMPANY AMERICAN TRUST & SAVINGS BANK DUPACO COMMUNITY CREDIT UNION FIRST AR BANK IOWA. N.A. 5.3400% N/A 5.2290% TOTAL lu.s. TREASURY OBUGATIONS: CHICAGO FEDERAL RESERVE BANK 4.9100% IREPURCHASE AGREEMENTS: ICORPORATE SECURITIES: AT&T & REGIONAL STOCK N/A TOTAL OTHER FUNDS TOTAL CIlY FUNDS 2of3 COST CITY FUNDS BASIS PERCENTAGE 18,056.00 591.68 1,000.00 19,647.68 0.04% 14,123.43 0.03% 192,802.10 1,109,401.57 12,768.86 211,752.86 1,526,725.39 3 .2~1o 0.00 0.00 0.00010 790,045.69 0.00 1,272.922.81 0.00 2,062,968.50 4.45% 19,145,240.00 41.30010 0.00 0.00010 6,822.60 0.01% 25,489,068.07 54.98% 46,360,695.90 100.00% SCHEDULE OF CITY FUNDS Month Ending: Sep-30-99 .....~Jit~~:qggMP.:t~~t\.q~::::. MANAGED FUNDS EXPENSE ADVANCES 0.00% OTHER FUNDS 0.04% COMBINED TOTAL 0.04% CASH 0.00% 0.03% 0.03% BANK N.O.W. ACCOUNTS 0.00% 3.29% 3.2<)010 BANK MONEY FUND SAVINGS ACCTS 0.00% 5.85% 5.85% TRUST SAVINGS ACCOUNTS 0.00% 0.00% 0.00% TRUST POOLS 0.00% 0.00% 0.00% MUTUAL FUNDS (US GOVERNMENT) 2.78% 0.00% 2.78% CERTIFICATES OF DEPOSIT 0.65% 4.45% 5.10% REPURCHASE AGREEMENTS 0.00% 0.00% 0.00% US TREASURY OBLIGATIONS 13.20% 41.30% 54.50% FEDERAL AGENCY OBLIGATIONS 28.39% 0.00% 28.39% CORPORATE SECURITIES 0.00% 0.01% 0.01% TOTAL 45.02% 54.98% 100.00% 30f3 "" .!t - 'C t ~oo got' .c = = "" = ~ ... 100 QEo- E'S U ~ :; -= ~ .I:l y 00 ';':0\ Q~ ""= <~ 0\ 1::';; 2 f: y~ <~ Q - - 'C "" = ....- = = =~ ~ .= Q "" u~ .... - 'C ~ i~ ~ ~ ~ ~. .== ~ 100 = =";1 =-> -= ~ s:: ~ y 'C =- = z ~ 00 ~ u -.t -.t o - ...., 0'." ...., o ~ ...., - ~ 00 N N ~ o o o o o 0'.. on 0'. ~ 8 0'. on 0'. 0'. ~ -.t - -- o - 00 0'. -- on - -- o - 8 o o o o 8. - ~ ...., u u on 0'. l"- N - 0'. -a ...., N ...., N ~ ...., o ~ N -.t ~ on o -a ~ o o o 0'. ...., v) on 0'. ~ 0'. ...., on on 0'. 0'. 0'. -- N - -- - - 00 ~ N - -- - - o o o o o o. o o. - ~ - o u on 0'. l"- N - 0'. 00 ~ 00 I"- 0'. -a. - o ~ 00 -.t ~ N -.t I"- ~ ~ o 0'. on -a. I"- 0'. ~ 0'. on -a r....: 0'. 0'. 0'. -- 00 - -- - - 0'. 0'. -- o ~ on 8 8 o o 8. - ~ > u on 0'. l"- N - 0'. -a 00 N N o ~ - 8 ~ ~ -a I"- 0'. ~ o ~ o -a -.t .,.) I"- 0'. ~ \0 -.t on r....: 0'. 0'. ~ \0 - -- N - 0'. 0'. f:;: - -- -a 8 o o o o. o o. - ~ on >< u on 0'. l"- N - 0'. I"- ~ -.t 00 I"- r" -a on ~oo N ...., I"- on I"- on 00. ...0 N -.t - o o -a N" N I"- I"- 0'. 0'. NN 00 00 0.0 0'. 0'.. - - -a-a 00 00 -.t~ I"- I"- 0.0 \0 -a. - - 88 r....:r....: M ...., N N ~~ I"- l"- on on 00 00 ~~ 00 ~o 00 0'. 0'. - - ~ ....," on on 0'. 0'. ~~ 0'. 0'. - - l"') ...., on on 0'. 0'. 00 QQ on on ~~ on on 0'. 0'. 0'. 0'. f:;:f:;: ~~ on on 00 00 00 00 00 0.0 00 o. o. - - ~~ ~~ on on 0'. 0'. 1"-1"- N N - - 0'. 0'. on -.t 0'. 00 ~~ I"- N - on ~~ -...., 00 ~~ on on \0 \0 N N ~~ -.t -.t -.t-.t - - tOtO 88 00 \0 00 on \0 0-" on on 0'. 00 ~ . N ~ \0 \0 on on ~~ on on 0'. 0'. ~~ N N N~ \0\0 0'. 0'. Q\~ ;;:-.t ~~ -a \0 00 00 ~~ 8.8. o. o. -...., ~~ l"') ...., l:Ql:Q ~~ on on 0'. 0'. I"- l"- N N - - 0'. 0'. o o 00 - - 00 ~~ on N N l"') - - ~ on N ~ -.t ~~ N - I"--.t on~ ~on o o o on - r" I"- 0'. ~ 00 00 00 - on 00 - .,.) on" on I"- 0'. 0'. ~~ on - I"- r....: 0'. - on 00 - on on onr....: 0'. 0'. ~ ~ - 00 QQ ...., 0 -- - N __ N 0'. 0'. -- 0'. ~ 0'. 0'. ~~ ~N N~ 00 o o o o o o o O. - ~ 00 00 00 00 00 O. o. 8.8. - - ~~ 00 ~ on 0'. l"- N - 0'. ~8 00 on on 0'. 0'. 1"-1"- N N - - 0'. 0'. ~ ~8 0'.0\ 00 N N - 00 - ~ 0'. o I"- ~ ~~ -.t -.t 00 1"-1"- ~-.t o o o on on ~ on 0'. ~ 00 00 00 00 -a \0 ~ -.t. on on 0'. 0'. ~~ on on "': on 0'. 00 -a \0 """': on on 0'. 0'. o Q o ...., -- M 00 ~~ ~~ -.t -.t 0'. 0'. -- - ;;: 0'. 0'. ~Q\ 0'.0\ ~~ -.t -.t 8 ~ 0" o o. - ~ 00 00 00 00 00 8~~ - - ~~ ~ on 0'. l"- N - 0'. on on E-<E-< 00 on on 0'\ 0'. 1"-1"- N N - - 0'. 0'. I"- 00 I"- I"- ~on 0000 00 I"- l"- N" N. - ...., -a on" o ~ - N ...., 00 ~O 0'.0\ -.t -.t ...., M ~ on o C"! on ~~ 1"-1"- -a-a C"!C"! on on o o o o o O. on 0'. ~ 00 ~O 00 -a \0 - - -.t. ~ N N -.t. -.t. - - ~~ 8 to 0'. -.t "" -.t -.t ~Q\ -.t~ 0'. 0'. o ~ - 00 00 QQ "" "" - - 0\0\ 0'. 0'. -- 0'. - -- 00 0'. 0'. 0'. 0'. \0\0 - - -- -- 0'. 0'. o o ~ O. o O. - ~ 00 ~o 88 00 o. o. 00 "l"l - - ~~ I"- ~ on 0'. l"- N - 0'. -.t"" ~~ ~~ on on 0'. 0'. I"- l"- N N - - 0'. 0'. N 0'. 00 - ...., 0'." o ...., ~ o o o -.t N on" -.t - ~ - ~ o o 8 o o o o 0" N ~ .. 1; ~ '" ~ o on l"- N o N ~ o - 0'. ~ ~ 'c i ::!1 -= ~ - .I:l \)I) 'u ~ -= ~ s:: -= ~ - .I:l \)I) 'u ~ (/) ....J X .J ....J in I- o o o "" N on. -.t - 0'.. - ~ .:5 ... = = ';; Q U - l ~ = ~'S = ... ="~ =1; -= y =lC = .. 'St ,..l;.,l .t: .... l;.,l = ~ '; " ~ -= y en ,,- ~ ... 2 ~ y ~ y- <oS =- -1: :.a . . =~ " ~ " =" g~ Q.>o E a -= .:2 = ... l;.,lc3 -= ~= ~ ~ ~ !E1; ~ ~= .=- ~ ,.. - .C ~ ~1; ~= ~ ~ ~ ~1; d:= 0'1 ~ Q ~ 0'1 ~ ;-i =-> o o o o o ~ - ~ ~ M - ori M - \(j on on ~ on \0 ~ 0\ 0\ -... o <"'l -... 0\ o 0\ 0\ -... ~ - 23 - 00 ~ ~ - -... o - M - \(j on on ~ on \0 {A ~ \0 o \0 M o o o o ~ M 00 - '$. <"'l <"'l 00 on 0'1 ~ \0 \0 <"'l 00" - \0 {A 0\ 0\ -... o <"'l -... 0\ o o Q o <"'l -... <"'l o 0\ 0\ -... o <"'l 0\ o 0'1 \0 \(j \0 <"'l 00 - \0 {A 00 0\ \0 " M on on ~ on ~ M" o o \(j ~ <"'l '$. <"'l <"'l 00 on 0\ ~ on ~ o 0" 0'\ " {A 0'\ 0'\ -... o - -... 0'\ o o Q o - -... 0- o 0'1 0- -... o - -... 0'\ o 0- ~ on ~ o 0" 0- " {A M - - - o on on on ~ on ~ M" {A o on 00 \0 0- M" \0 o M" {A o on 00 \0 0\ M" \0 o c-i {A ... e; - ~ '$. 0- o ~ on -= "a:S ;;: " ~ -= OIl "Q:j ~ o on 00 \0 0\ M" \0 o c-i (A ;.; "i = -= = l;.,l ~ < ... ~ sj = z '" >. Cl:I Cl o on - 0'\ - ;.:. - .C = 1; ~ " ~ - -= OIl "Q:j ~ " ~ " =" =- = .S:! Q.>o E = l;.,l Q.l .~ 1; ... cr::c3 '" = o 'R 'e ~ ~ Q) I3 s 1:: Q) U " ! -= E ~ e cf~ ~ - ... B ~ lC-= :e ~ ez ... ~ ~ - ... ~ j ~ ~ a 'u = 'C 0. g "0 ;g Cl:I "0 ; ~ -; = :: ~ I 's Q) en -g ~ ~ u '" b.l) = 's Cl:I ~ '$. <"'l <"'l 00 on '$. g ~ on on \0 <"'l -... - 00 - ci U ~ Q/:l cci ci N - - - o on a 'g 'C 0. o - a 'u :: 'C 0. o - "0 ~ "0 = Cl:I >. i: ~ Cl:I cSt "0 Q) ~ ~ u ~ :: 's Cl:I ~ "0 ;g Cl:I "0 :: Cl:I ~ .... ~ & "0 Q) ~ .... u '" gp 's Cl:I ~ '$. " N - ori '$. l"l l"l 00 on C/) ..J ><; o u '$. 8 o ori '$. g ~ on o \0 l"l 23 0- o \0 l"l ~ o ! o ! ~ ~ \0 N 00 0- \0 " N