Loading...
Investment Report Qtrly 3 31 04 D~~~E .~~~ MEMORANDUM April 26, 2004 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: March 31, 2004 Quarterly Investment Report Finance Director Ken TeKippe is transmitting the attached March 31, 2004 Quarterly Investment Report. (Yl¡JJ ~ Ihh Micháel C. Van Milligen MCVM/jh Attachment cc: Barry Lindahl, Corporation Counsel Cindy Steinhauser, Assistant City Manager Kenneth J. TeKippe, Finance Director ::¡, F tcv -.J :<-; ""? CITY OF DUBUQUE, IOWA MEMORANDUM TO: Michael Van Milligen, City Manager FROM: Kenneth J. TeKippe, Finance Director ~d'(/~ RE: March 31,2004 Quarterly Investment Report DATE: April 20, 2004 INTRODUCTION The Finance Department is submitting the quarterly investment report as prescribed within the City of Dubuque Investment Policy Section 17.0 "Reporting." DISCUSSION This report covers the period from January 1,2004 through March 31,2004. The report includes: Cash Investments and Investment Eamings Summary for quarter ended March 31,2004 and fiscal year to date Schedule of City Funds (2 pages) Monthly Investment Summary Schedule of Certificates of Deposit The valuations reflect the same basis that the assets are carried on the financial records of the City. The City of Dubuque is in compliance with the Investment Policy. REQUESTED ACTION This report is f~r your review and filing with the Honorable Mayor and City Council. KT/jg Enclosures CITY OF DUBUQUE Cash, Investments and Investment Earnings Summary For The Quarter Ended March 31, 2004 & Fiscal 2003-04 YTD Market Value I Unrealized Carrying Including Gain (Loss) I Description Value Accrued Interest Accrued Interest Deposits, Change & Petty Cash Funds 90,100 90,100 0 Checking/Savings Accounts 8,304,043 8,304,043 0 Certificates Of Deposit 19,500,000 19,575,717 75,717 US Treasury Securities Corporate Stock 11,522 60,931 49,409 Investment Advisor Accounts 22,828,724 233,066,472 210,237,748 Total Fnnds 50,734,389 261,097,263 210,362,874 Breakdown City 40,466,790 250,799,189 210,332,400 Metro 10,267,599 10,298,074 30,475 Total Combined Fnnds 50,734,389 261,097,263 210,362,875 Cash Basis Gross Earninl!S: City Metro Combined I Qnarter Year-To-Date I 47,666 687,597 37,911 101,944 85,57 789,541 (29,856) (112,934) (198) (436) (30,054) (113,370) 17,810 574,663 37,713 101,508 55,523 676,171 Investment Fees: City Metro Combined Net Earnin!!s: City Metro Combined . \ It , CITY OF DUBUQUE SCHEDULE OF CITY FUNDS FOR MONTH ENDING: MARCH 31,2004 MANAGED FUNDS PORTFOLIO COMPOSITION PERCENTAGE COST BASIS TOTAL CITY FUNDS PERCENTAGE DANA INVESTMENT ADVISORS, INC.: Cash Mutual Funds (US Government) Certificates Of Deposit US Treasury Obligations Federal Agency Obligations Total DUBUQUE BANK & TRUST: Cash Mutual Funds (US Government) Certificates Of Deposit US Treasury Obligations Federal Agancy Obligations Total FIRST COMMUNITY TRUST: Cash Mutual Funds (US Government) Certificates Of Deposit US Treasury Obligations Federal Agency Obligations US BANK: Cash Mutual Funds (US Government) Certificates Of Deposit US Treasury Obligations Federal Agency Obligations GRAND TOTAL BREAKDOWN BY TYPE OF SECURITY: Cash Mutual Fonds (US Government) Certificates Of Deposit US Treasury Obligations Federal Agency Obligations TOTAL MANAGED FUNDS Total Total 0.00% 0.31% 0.00"10 0.00"10 99.69% 100.00% 0.00% 13.26% 0.00"10 0.00"10 86.74% 100.00"10 0.00% 2.53% 0.00% 0.00"10 97.47% 100.00% 0.00"10 20.19% 1.40% 12.01% 66.41% 100.00% 0.00% 10.76% 0.44% 3.77% 85.03% 100.00"10 0.00 18,465.18 0.00 0.00 5,866,986.07 5,885,451.25 0.00 920,606.54 0.00 0.00 6,024,109.23 6,944,715.77 0.00 71,563.62 0.00 0.00 2,761,292.79 2,832,856.41 1,446,447.96 100,000.00 860,469.20 4,758,783.51 7,165,700.67 22,8211,7Z4.lU 0.00 2,457,083.30 100,000.00 860,469.20 19,411,171.60 22,828,724.10 11.60"10 13.69% 5.58% 14.12% 45.00% 0.00"10 4.84% 0.20% 1.70% 38.26% 45.00% Page 1 ", I ~ CITY OF DUBUQUE SCHEDULE OF CITY FUNDS FOR MONTH ENDING: MARCH 31,2004 CASH Change and Petty Cash Funds Prescriptions & Workers Comp Deposits COST BASIS TOTAL CITY FUNDS PERCENTAGE OTIIER FUNDS Total 10,100,00 80,000.00 90,100.00 0.18% CHECKING I SAVINGS ACCOUNTS: American Trust & Savinga Bank (General & Health) American Trust & Savings Bank (America's River G.O.Bonds) American Trust & Savinga Bank (Housing Rehab & Section 8) American Trust & Savings Bank (America's River-Vision Iowa) Dubuque Bank & Trust (GenerallMetrolLeisurelGreyhound) Dubuque Bank & Trust (GO Bonds Water Projects) Dubuque Bank & Trust (GO Bonds Stonnwater Projects) US Bank (GenerallAmbuiancel5 Flags) Premier (Utility) Libetty (Utility) East Dubuque Savinga Bank (Utility) State Central (Utility) Total 3,623,206.17 520,152,91 253,527.72 1,000.00 1,656,272.14 246,059.43 1,748,900.46 244,826.74 2,739.38 5,946.82 1,147.38 263.68 8,304,042.83 16.37% CERTIFICATES OF DEPOSIT: American Trust & Savings Bank Dupaco Conununity Creilit Union Dubuque Bank &Trust East Dubuque Savinga Bank US Bank Libetty Bank Premier Bank State Central Total 0.00 0,00 0.00 7,000,000.00 1,000,000,00 9,500,000.00 2,000,000.00 0.00 19,500,000.00 38.44% U.S. TREASURY OBLIGATIONS 0.00 0.00% 11,521.95 27,905,664.78 0.02% CORPORATE STOCK (Lyon, Peony Trust) TOTAL OTIIER FUNDS 55,00% TOTAL CITY FUNDS ¡RECAP OF PORTFOLIO PERCENTAGES 50,734,388.88 100.00% 0.18% COMBINED TOTAL 0.18% CASH MANAGED FUNDS 0.00% OTHER FUNDS CHECKlNG I SAVINGS ACCTS 0.00"10 16.37% 16.37% MUTUAL FUNDS (U.S. GOVERNMENT) 4.84% 0.00"/. 4.84% CERTIFICATES OF DEPOSIT 0.20% 38.44% 38.63% U.S. TREASURY OBUGATIONS 1.70% 0.00% 1.70% FEDERAL AGENCY OBUGATIONS 38.26% 0.00"/. 38.26% CORPORATE STOCK 0.00% 0.02% 0.02% Total 45.00"10 55.00"10 100.00"10 Page 2 >- 0: .. '" '" ~~ '" ¡¡: if¡ ;¡ §E !íl "'" .: , CO- ~Eo- i!;~ <3 ~;!; ¡;~ i!: z c '" <! -g ~HI " <3 = ~ C ~ UJ n ~o I !I ¡ ~I 8 ¡¡; ~ '" :¡JiB8<J; iBiêí28:ï; ~ ~ ~ ì'i~ò~ U~Ò! M ã ~ ~,:; ~ (!!:,,¡,:; ~ 0 oi ì! ~ '" 0 ~ ¡¡¡ ~ g ;¡; ~ g ;¡; í2 ¡¡¡ ~ N ~ ~ ~ g ~ ,:; ,:; ~ oi ~ '" ~ ~ s ï! ¡:f miB88 iBiê88;=' 0 0 0 ~~ò¡¡¡ UÒÒ~ i!' ò ~ \'1"':; ¡f (!!:,,¡ ß ~ ~ ¡:f ¡:f ~ ~ ~ .- ~- m :;:~ IE ;!<J; 0 ¡:¡ ¡¡i ¡; ~ g '" ~~ ~~ !~ ~ ~ ~ g "' :¡¡m iB¡¡- ~~ ~ ~~ ;;0;- ¡¡i - g¡ ~ ¡¡; "' ~~ 0 0 S1¡¡J &: ~!1£ ;f .. ~ ;¡ ~ ~ ~ ! 1111 " .. '" ::i' ~ L ! l¡¡U 0 o1 o" jUn iB ~ ¡g ~ ~ ~ .- 0 i íf ~ ~ ¡¡¡ - !i! '" ~ ~ :!! g>: ! "' ~ !! ;=' ~ !! ¡§ "' 0 I ~ ~ ~ ~ i ~ ~ ;;; ;ä ~ i 'i , . m " 0: ,; -a ii 3 Æ i3 go ~ ~ ~ om~- ~~-~ ~~~~ ~%i!i¡¡¡ '<I" '" ONe M~-~ ¡:¡¡;!¡oj::: ~~- ~:eg..: ~ O~~~ -~O~ ~:ì!~~ ~~!i!M ¡:f ¡: ID í1 !! ~MN~ ~m~~ ~U¡g ~~:¡¡~ .- ¡¡¡ N :;;8re¡;¡ g8";:!! ~N;¡O;N !i!"~¡¡¡ '" '" ~ ~ ¡f <D ~~~~ ~~~~ :!!:8gj:B i~$i "' ~ ~ ~-- N~~ ~~~~ ¡§¡;¡¡¡¡~ '" ~ ~ ~ ~ ~ ~ " ~~~ ~dU 0 -~~. " H:ลก~ a~H ~HH '" m,,"m ~g~ N ~~~ ~ N ~ ~~- . -m- ~ ~ ~g¡:B 8 ~ 0 ~~~ oi :: ~ '1j '1j '" N ~NO ~ ~ ~ M~O ~ ~ ¡:¡ sH! ã g ¡;¡ ~"';: oi !!1 ~ ~ ~ '" re 0 ~~~ 0 ~ N~- ~ ~n 0 ¡¡j ~ ::::.: ~ ¡;¡ ¡;¡ '"' M M 0 ~ Nm- @ ~ïI~ ò ~ ~ ¡&~¡¡ g ~ .- .- ~~ d'" re g¡8;; 8 ;; '" "'8'" ò '" ß :::N¡oj ¡oj ~ !"*" m '" '" '" U dd ID ~'<I" 8 " !11 U~ ò ~ 1j ;¡;g~ 11 ~ .- .- ~~ d'" ~ 1õ;;S 0 N ¡ ~~~ ò ~ g ~r.g ~ ~ '" '" ~ .... <I~ dd I ~ ~ .. ~ I ~ : ~ ;~ ~ ~ ~ ~ '" ~ n~o ~ ~ ~ t; ~.- - i! . ~ ~H ~" ~ ~ ~~i i i eJ ~ ~b ! ! H~ E ë ~ ~ ~ ;, g ~~ --;C !~! ~ ~ ~H .5 '" w.. ~ ~ ............ 8:;JgJ¡;¡ß8 ò""""'d'" ~ ......""" 8<1:Ji8;: """"',,;'" . ~U~~ ò""""'ò , H~ ,¡¡,¡¡"'" !iUH Æ~\;H~ &:!i',¡j.. ~ ~ :;¡:;¡'¿<38 E E. ~~E ~~§ d Co ~i >- ;:0; i~ ,,- ~~ ~~ 8!~ ~ l!! ." ~~ 1M City of Dubuque Schedule of Certificates of Deposit As of March 31, 2004 Certificate Purchased Cost Purchase Maturity Last Interest Interest Days to Accrued Accrued Number From Basis Date Date Payment Rate Maturity Days Interest 52166 Liberty(M) 500,000 01/29104 04101/04 01/29/04 1.370% 1 62 1,163.56 349003020 US Bank 1,000,000 10116103 04108104 10/16103 1.100% 8 167 5,032.88 52130 LIberty 1,000,000 12122/03 04/30104 12122103 1.270% 30 100 3,479.45 9928 EDgB (M) 1,000,000 09/25/03 05108/04 09/25/03 1.130% 36 188 5,820.27 52137 LIberty 1,000,000 12/26103 05/13104 12/26/03 1.460% 43 96 3,840.00 406668 Premier 1,000,000 11126103 06/01104 11/26103 1.254% 62 126 4,328.88 52136 Liberty 1,000,000 12/26/03 06/01/04 12126/03 1.480% 62 96 3,692.60 52090 Llberty(M) 1,000,000 10/30/03 06/10/04 10/30/03 1.210% 71 153 5,072.05 10339 EDgB (M) 1,000,000 12/11/03 06110/04 12/11/03 1.180% 71 111 3,588.49 52105 Liberty(M) 1,000,000 11120103 06124104 11/20/03 1.270% 85 132 4,592.88 52119 Liberty 1,000,000 12/11/03 07/08/04 12111/03 1.270% 99 111 3,862.19 10503 EDgB (M) 1,000,000 02/05/04 07/08/04 02/05/04 1.521% 99 55 2,291.92 52157 Liberty 1,000,000 01/22/04 07/22104 01/22/04 1.470% 113 69 2,778.90 52118 Llberty(M) 1,000,000 12111103 08105104 12/11103 1.320% 127 111 4,014.25 10570 EDgB 1,000,000 02/19/04 08/05/04 02/19/04 1.539% 127 41 1,728.74 406769 Premier 1,000,000 02/12/04 08/19/04 02/12/04 1.544% 141 48 2,030.47 52148 Llberty(M) 1,000,000 01/08/04 09/09/04 01/08/04 1.370% 162 83 3,115.34 10657 EDgB (M) 1,000,000 03111/04 10/14104 03111104 1.489% 197 20 815.89 10669 EDgB 1,000,000 03/18/04 09/16/04 03/18/04 1.489% 169 13 530.33 52212 Liberty(M) 1,000,000 03/31/03 11/04/04 03/31/03 1.370% 218 366 13,737.53 Totals $19,500,000 $75,718.62 Weighted Yield: 1.355% Weighted Maturity: 98.49 Days (M)' DUBUQUE AREA METROPOLITAN SOLID WASTE AGENCY