Loading...
Investment Report Qtrly DU~~E ~cÆ~ MEMORANDUM October 25, 2004 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: September 30, 2004 Quarterly Investment Report Finance Director Ken TeKippe is transmitting the attached September 30,2004 Quarterly Investment Report. (ìL1Jj ç~ /1À Míchael C. Van Mnligen MCVM/jh Attachment cc: Barry Lindahl, Corporation Counsel Cindy Steinhauser, Assistant City Manager Kenneth J. TeKippe, Finance Director n t CITY OF DUBUQUE, IOWA MEMORANDUM FROM: Michael C. Van Milligen, City Manager Kenneth J. TeKippe, Finance Director ~ J. (/ ru1~ TO: RE: September 30, 2004 Quarterly Investment Report DATE: October 18, 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 July 1, 2004 through September 30, 2004. The report includes: Cash Investments and Investment Earnings Summary for quarter ended September 30, 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 for 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 September 30, 2004 & Fiscal 2005 YTD Descri non Market Value I Unrealized Carrying Including Gain (Loss) I Valne AccJ1Ied Interest AccJ1Ied Interest 89,981 89,981 3,475,762 3,475,762 25,800,000 25,945,509 145,509 11,522 60,683 49,161 23,195,526 23,445,506 249,980 52,572,791 53,017,441 444,650 Deposits, Change & Petty Cash Funds Checking/Savings Accounts Certificates Of Deposit US Treasury Securities Corporate Stock Investment Advisor Accounts Total Funds Breakdown City Metro Total Combined Fonds 43,441,880 9,130,911 52,572,791 43,843,%2 9,173,479 53,017,441 402,082 42,568 444,650 Cash Basis Gross Eaminl!S: City Metro Combined I Quarter Year-To-Date I 258,942 258,942 18,334 18,334 277,277 277,277 (36,531) (36,531) (135 (135\ (36,666) (36,666) 222,411 222,411 18,200 18,200 240,611 240,611 Investment Fees: City Metro Combined Net Eaminl!S: City Metro Combined .' ", . ,I CITY OF DUBUQUE SCHEDULE OF CITY FUNDS September 30, 2004 MANAGED FUNDS PORTFOliO COMPOSITION PERCENTAGE COST BASIS DANA INVESTMENT ADVISORS, INC.: Cash Mutual Funds (US Government) Certificates Of Deposit US Treaswy Obligations Federal Agency Obligations 19,323 0.32% 0.()0% 0.00% 0.00% 99.68% 99.68% 5,928,872 5,948,195 Total DUBUQUE BANK & TRUST: Cash Mutual Funds (US Government) Certificates Of Deposit US Treaswy Obligations Federal Agency Ob1igstions 567,792 7.98% 0'('0% 0.00% 0.00% 92.02% 92.02% 6,548,863 7,116,655 Total FIRST COMMUNITY TRUST: Casb Mutnsl Funds (US Government) Certificates Of Deposit US Treaswy Obligations Federal Agency Obligations 157,378 5.48% 0.00% 0.00% 0.00% 94.52% 94.52% 2,713,512 2,870,890 Total US BANK: Casb Mutual Funds (US Government) Certificates Of Deposit US Treaswy Ob1igstions Federal Agency Obligations 4.05% O.OO"A> 1.38% 10.96% 83.61% loo.OO"A> 294,211 100,000 795,703 6,069,872 7,259,786 Total FY05 TOTAL CITY FUNDS PERCENTAGE 11.31% 13.54% 5.46% 13.81% GRAND IVTAL LJ,lY:;,~:u. 44.120/0 BREAKDOWN BY TYPE OF SECURITY: Casb Mutual Funds (US Government) Certificates Of Deposit US TreaswyObligstions Federal Agency Obligations TOTAL MANAGED FUNDS 4.48% 0.00% 0.43% 3.43% 91.66% loo.OO"A> 1,038,703 0 100,000 795,703 21,261,120 23,195,526 Page' 1.98% O.OO"A> 0.19% 1.51% 40.44% 44.12% 10114i2004 .' "', CITY OF DUBUQUE SCHEDULE OF CITY FUNDS September 30, 2004 ;. OTHER FUNDS COST BASIS CASH Change and Petty Casb Funds Prescriptions & Workers Comp Deposits 9,981 80,000 89,981 Total CHECKING I SA VlNGS ACCOUNTS: American Trust & Savings Bank (General & Health) American Trust & Savings Bank (America's River G.O.Bonds) American Trust & Savings Bank (Housing Rebab & Section 8) American Trust & Savings Bank (America's River-Vision Iowa) Dubuque Bank & Trust (Genera\IMetrolLeisureiGreyhound) Dubuque Bank & Trust (GO Bonds Water Projects) Dubuque Bank & Trust (GO Bonds Stormwater Projects) US Bank (GeneraVAmbu1ancel5 Flags) Premier (Utility) Liberty (Utility) East Dubuque Savings Bank (Utility) State Central (Utility) 395,401 339,727 133,993 1,003 1,915,557 203,221 436,689 18,240 7,628 15,868 7,514 922 3,475,762 Total CERTIFICATES OF DEPOSIT: American Trust & Savings Bank Dupaco Community Credit Union Dubuque Bank & Trust East Dubuque Savings Bank US Bank Liberty Bank Premier Bank State Central 2,000,000 3,000,000 9,000,000 7,800,000 4,000,000 FY05 TOTAL CITY FUNDS PERCENTAGE 0.17% 6.61% Total 25,800,000 49.07% U.s. TREASURY OBUGATIONS CORPORATE STOCK(LyoruoPoonyTnøI) 11,522 55.88% TOTAL OTHER FUNDS 29,377,265 O.OO"A> 0.02% TOTAL CITY FUNDS 52,572,791 1110.00% IRECAP OF PORTFOUO PERCENTAGES CASH MANAGED FUNDS 1.98% OTHER FUNDS 0.17% CHECKING I SA VJNGS ACCTS 6.61% 0.00% MUTUAL FUNDS (U.S. GOVERNMENT) CER1lF1CATES OF DEPOSIT 0.00% 0.00% 0.19% 49.07% U.S. TREASURY OBLIGATIONS 1.51% O.OO"A> FEDERAL AGENCY OBLIGATIONS 0.00% 40.44% CORPORATE STOCK 0.02% lOO.OO"A> O.OO"A> Total 55.88% """"""" 44.12% _2 COMBINED TOTAL 2.15% 6.61% 0.00% 49.27% 1.51% 40.44% 0.02% COST u,SIS ANALYSIS Coot..... P.or Mo.," Addltlo.o: I.'e""" Eemleg' R..'~ed Oel.. (Lo"..) Cepllel- Total Add"',", Su"""o." Ma.egeme.. F... Custodio. F... Sa.k Cherg.. Cepllel Wühd",wol, TotaISubtree'o", Coot I.... Cu..." Mo.," NetC..h Reoelpts & (Œsbu...mo",) E.dl.. Cost 1..10 la'a.co C/IANOEIN COST u,SlB JlDJUBT2D POR ~ Coot..... Cu..." Mo.," Plu., -"<rued I.'...., Curre.. Mo.'" L...,-"<ruedlnte"""Prk>rM- Cost ...Ie AdJusted.... Accruala AlARIŒTVALUUNALYSIB '._a" Market Valua P.or Mo'" '.v.-a"MarketVa'uaCu....tMonUI A"rued Inter..' Cu,,"" Mo.'" Market Va'ua Ad)u"'d for Accrua'o Net C..h R&O8I"" & (Otebu...me"') E.dl.O '.........e" Mar'" Value Adjusted Portfolio ."'mo MoethlyRetum Total Return C,'e.der Y..r to O,te2004 ~ 90 Day T.BIII, Lehme. Aggregete Ooy!, Bo'" Lehmen Short Term Oovt, Bo"", Lehme. I.termedl... Oovt Bo.d," Consumer P"co I""ex Curren' P"me Re'e' CITY OF DUIUQUE MONTHLY INVESTMENT SUMMARY Month E.dl.o: - Firs' Commun" M..aged Combined Qom! OB&T Truel US Sank Aoooun" ~ Im! 5,g34"",",67 7,001,62214 2,665,271.66 7,239,041.44 23,120,635,11 30,660,30431 63,600,63942 16,29767 26,609,65 17,010,66 21,45332 83,57170 5,4g340 69,066,10 (4,132,14) (1,144,62) (S54,69) (61.07) (6,31272) (6,312,72) O,(}() 0,00 14,165,53 26,665,03 16,066,17 21,372,26 77,26996 5,49340 82,762,38 0,00 0,00 (670,10) (831.97) (438,23) (52771) (2,266,01) (2,266,01) (2,236.69) (2,238,69) 0,00 0,00 (57010) (831,97) (43823) (627,71) (2,266,01) (2,238,69) (4,604,70) 5,948,105,10 7,118,666,20 2,670,869,80 7,269,795,66 23,105,52"-08 30,692,661.02 53,668,087,10 0,00 (1,315,296,10) (1,315,266,10) 5L94~I~JO],11.M6(i<Q. _V!?Q6~MIL - _1,1.5!m~.'16- _1.3~O5ß.1.M8.- - ___1.!I,:m,~,"'____..JI~791,oo 5,948,105,10 7,118,665,20 2,670,66S,8O 7.269,765,66 23. 195,S26,08 30,692,661.02 53,668,087,10 Ig,866,61 82,053,80 20,389.08 80,530,34 183,636,83 145,609,36 329,046,18 (19055.91) 178 369.50) (26 081,66) (62 303,65) (165 610,84) (126,373,66) (314184,40) 5,~,604,8O 7,123~239,§O 2,6R1jI,;!Qu .1,1.6M.12AL _1.W!3264,07 30700696.61 53902960,68 5,682,466,62 7,387,239,24 2,658,707.89 1,294,'161-11.. _1.>.>I~,437.67. 30 737 907.33 54 111 346,00 5,911,338,87 7,368,302,82 2,671,160,21 1,216,113,90 23,445,60S,68 26,426,426.18 62,S11,931,", 19866,81 92053,80 20369,08 80530,34 163636,63 14560936 329046,18 5,931,004,28 7,469,256,62 2,691,639,36 1,331,244,24 23.629.04449 20,511,935,53 53,200,980,02 0,00 O,(}() (1,315,296,10) (1,315,296,10) O,(}() 0,00 0,00 5,931,OO4,~ 1,489,256,62 2,89t5¡S,:!5 - 1.831,1.44-,,--~___1.M.2! ,O44,49 262566¡S,43 51.888,883.92 D- 1.11% 0.38% "- 0.18% 2.32% O.ls" 1.88% Avo...e Lest 3Moeth, rn% 3.11% 1.- 2.28% 0..0% Avo",ge Laet 12Monthe TIõ% 2.82% 1.11% "- 2.42% eatendor Y..rto Date m;¡; 2.11% 1.01% 2.11" 2.32% 4.75" 'Rete e. of O"""'s H Ro",," prior to - ¡ . ""._,"',,""" I . City of Dubuque Schedule of Certificates of Deposit As of September 30, 2004 Certificate Purchased Cost Purchase Maturity Last Interest Interest Deys to Accrued Accrued Number From BasIs Date Date Payment Rate Maturity Days Interest 10657 EDSB (M) 1,000,000 03/11104 10/14104 03111104 1.489% 14 203 8,281,29 52212 Liberly(M) 1,000,000 03131104 11104104 03131104 1.370% 35 183 6,868,77 10715 EDSB 1,000,000 04108/04 10107104 04106104 1.153% 7 175 5,528.08 397011248 US Bank (M 1 ,000,000 04101104 12109104 04101104 1,110% 70 182 5,534.79 350029458 US Bank 1,000,000 04/19104 12/01104 04119104 1.230% 62 164 5,526.58 350029510 US Bonk 1 ,000,000 04/21104 11101104 04121104 1.240% 32 162 5,503.56 52254 Liberty 1 ,000,000 04l28IO4 11/10104 04/28104 1.370% 41 155 5,817.81 350029876 US Bonk (M 1,000,000 05106/04 01I06IO5 05I06IO4 1.440% 98 147 5,799.45 350029957 US Bank 1 ,000,000 05110104 01120105 05110104 1,650% 112 143 6,464,38 338038561 US Bank 1,000,000 05/13104 01119105 05/13104 1,670% 111 140 6,405,48 10842 EDSB 1 ,000,000 05/19104 12109104 05/19104 1,649% 70 134 6,053.68 407054 Premier 1 ,000,000 OS/20104 12122104 05120104 1,710% 83 133 6,230.98 407076 Premier 1,000,000 OS/27104 01105/05 05127104 1,725% 97 126 5,954.79 407093 Premier 1,000,000 06102/04 01113105 05102/04 1.710% 105 120 5,621.92 350030332 US Bank 1,000,000 06103104 02/04105 06103104 1.780% 127 119 5,803,29 350030333 US Bank 1,000,000 06I03IO4 02118105 06103104 1.820% 141 119 5,933,70 116851.7 AT&S 1,000,000 06107104 03104105 06107104 1.995% 156 115 6,285,62 1168517/116; AT&S (M) 1 ,000,000 06/11104 02110105 06111104 1.998% 0 111 6,076,11 52322 Liberty 1 ,000,000 06117104 03117105 05/17104 2.270% 273 105 6,530,14 350030704 US Bonk (M 1 ,000,000 06/24104 03/10105 06124104 2.030% 259 98 5,450.41 52346 Liberty 1,000,000 06130104 02111105 06130104 2,350% 226 92 5,923.29 52354 Liberty 1,000,000 07108104 04107105 07108/04 2.170% 273 84 4,993.97 407188 Promler 1,000,000 07120104 03124105 07I20IO4 2.150% 247 72 4,241.10 52378 Liberty 1,000,000 07122104 03131105 07122104 2.150% 252 70 4,123.29 52388 Llberty(M) 1,000,000 08105104 05105/05 08105104 2.250% 273 56 3,452,05 52413 Liberly(M) 800,000 09109104 05119105 09109104 2.400% 252 21 1,104.66 Totals $25,800,000 $145,509.35 Weighted Yield: 1.760% Weighted Maturity: 130.41 Days 1M) = DUBUQUE AREA METROPOLITAN SOLIO WASTE AGENCY FI123DATAIFinoncelinveetmentslinveotmonts 05lMONTHlCD & T-BILLSlCD-Accrued IntO5xl. Print Qote: 1011812004