Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Quarterly Investment Report
Dli~-@uE ~Yk-~ MEMORANDUM July 26, 2004 TO: The Honorable Mayor and City Council Members FROM: Michael C. Van Milligen, City Manager SUBJECT: June 30, 2004 Quarterly Investment Report Finance Director Ken TeKippe is transmitting the attached June 30, 2004 Quarterly Investment Report. (ìl tJt{{~1/ìIL Michaèl C. Van Milligen MCVM/jh Attachment cc: Barry Lindahl, Corporation Counsel Cindy Steinhauser, Assistant City Manager Kenneth J. TeKippe, Finance Director ," ) i -, , (c' CITY OF DUBUQUE, IOWA MEMORANDUM TO: Michael Van Milligen, City Manager ~9'(/~ FROM: Kenneth J. TeKippe, Finance Director RE: June 30, 2004 Quarterly Investment Report DATE: July 19, 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 April 1, 2004 through June 30, 2004. The report includes: Cash Investments and Investment Earnings Summary for quarter ended June 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 June 30, 2004 & Fiscal 2003-04 YTD Deseri tion 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 Funds Casb Basis Gross Earnint!S: City Metro Combined Investment Fees: City Metro Combined Net Earnint!S: City Metro Combined Market Value I Unrealized Carrying Including Gain (Loss) I Value Accrued Interest Accrued Interest 90,251 90,251 4,534,804 4,534,804 30,012,985 30,091,475 78,490 11,522 57,349 45,827 23,013,990 23,123,298 109,308 57,663,552 57,897,177 233,625 47,939,377 9,724,175 57,663,552 48,145,662 9,751,515 57,897,177 206,285 27,340 233,626 I Quarter Year-To-Date I 276,137 1,186,383 36,304 138,249 312,441 1,324,632 (21,129) (151,597) (]86 (622) (21,315 (152,219) 255,008 1,034,786 36,118 137,627 291,126 1,172,413 CITY OF DUBUQUE SCHEDULE OF CITY FUNDS June 30, 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 To/al 0.00% 0.42% 0.00% 0.00% 99.58% 100.00% 0.00 24,647.62 0.00 0.00 5,891,777.52 5,916,425.14 10.26% DUBUQUE BANK & TRUST: Cash Mutual Funds (US Government) Certificates Of Deposit US Treasury Obligations Federal Agency Obligations Total 0.00% 2.27% 0.00% 0.00% 97,73% 100,00% 0.00 159,220.47 0.00 0.00 6,868,950.25 7,028,170.72 12.19% FIRST COMMUNITY TRUST: Cash Mutual Funds (US Government) Certificates Of Deposit US Treasury Obligations Federal Agency Obligations To/al 0.00% 4.16% 0.00% 0.00% 95,84% 100.00% 0.00 118,580.84 0.00 0.00 2,731,131.76 2,849,712.60 4.94% US BANK: Cash Mutual Funds (US Government) Certificates Of Deposit US Treasury Obligations Federal Agency Obligations To/al 0,00% 11.56% 1.39"10 8.26% 78.79"10 100.00% 834,837.27 100,000,00 596,625.00 5,688,218.80 7,219,681.07 12.52% GRAND TOTAL 23,013,989.53 39.91% BREAKDOWN BY TYPE OF SECURITY: Cash Mutual Funds (US Government) Certificates Of Deposit US Treasury Obligations Federal Agency Obligations TOTAL MANAGED FUNDS 0.00% 4.94% 0.43% 2.59% 92.03% 100.00% 0.00 1,137,286.20 100,000.00 596,625.00 21,180,078.33 23,013,989.53 0.00% 1.97% 0.17% 1.03% 36.73% 39.91% Page 1 CITY OF DUBUQUE SCHEDULE OF CITY FUNDS June 30, 2004 OTHER FUNDS CASH Change and Perty Cash Funds Prescriptions & Workers Comp Deposits COST BASIS Total 10,255.50 80,000.00 90,255.50 CHECKING I SAVINGS ACCOUNTS: American Trust & Savings Bank (General & Health) American Trust & Savings Bank (America's River G.O.Bonds) American Trust & Savings Bank (Housing Rehab & Section 8) American Trust & Savings Bank (America's River-Vision Iowa) Dubuque Bank & Trust (GenerallMetrolLeisureiGreyhound) Dubuque Bank & Trust (GO Bonds Water Projects) Dubuque Bank & Trust (GO Bonds Stormwater Projects) US Bank (General/Ambulance/5 Flags) Premier (Utility) Liberty (Utility) East Dubuque Savings Bank (Utility) State Central (Utility) 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 u.S. TREASURY OBLIGATIONS CORPORATE STOCK (Lyom Poooy T""t) TOTAL OTHER FUNDS TOTAL CITY FUNDS 682.332.99 338,455.92 224,304.90 2,785.67 1,959,453.07 240,243.92 1,012,722.74 52,785.22 4,802.34 11,371.84 5,082.72 462.71 4,534,804.04 Total Total 2,000,000.00 0.00 0.00 6,000,000.00 10,000,000.00 8,012,985.48 4,000,000.00 0.00 30,012,985.48 0.00 11,521.95 TOTAL CITY FUNDS PERCENTAGE 0,16% 7.86% 52.05% 0.00% 0.02% 60.09% 34,649,566.97 100.00% 57,663,556.50 OTHER FUNDS IRECAP OF PORTFOLIO PERCENTAGES CASH CHECKING I SAVINGS ACCTS MUTUAL FUNDS (U.S. GOVERNMENT) CERTIFICATES OF DEPOSIT U.S. TREASURY OBLIGATIONS FEDERAL AGENCY OBLIGATIONS CORPORATE STOCK MANAGED FUNDS 0.00% 0.16% 0.00% 7.86% 1.97% 0.00% 0.17% 52.05% 1.03% 0.00% 36.73% 0.00% 0.00% 0.02% 100.00% Total 39.91% 60.09% Page 2 COMBINED TOTAL 0.16% 7.86% 1.97% 52.22% 1.03% 36.73% 0.02% COST BASIS ANALYSIS Co" Baa'a Prio, Month Addition" ""er..1 Eamlng, Rea'.ed Gal", (Lo,,",) Capital Dopo,lt, Total AdOltlon' Sob""ctlon" Msnagemo'" Fea, C..todlan Fea, BankC""",,, Capital Wlthd",wal, Total SobITactlon, Coat Baala Co",nt Month Net Cash Rocolpt' '{Dlaburumo"',} End'ng Co" "alo B"anco CHANGE IN cosr BASIS ADJUSTED FOR ACCRUALS Co" ...,. Co,"",t Month PI.., Accruedlnier..tCuITeni Month "",Awoedl"'er..tPrl..M- Co" Ba.l. AdJoe"" fo, Acc..a'. MARKET VALUEANAL YSIS 'nmtmant Ma"" Va'oa Prio, Month 'nvestm.nt Ma"" Va'oa Co",nt Month Awoad ""areot Corront Month Ma"" Va'oa Adlooted for Acc..a'. Net Ca,h Recelpte 0 (DI'bora.m.nte) Ending 'nvestm..t Ma"at V.'oa AdJo"" Portfolio Ratomo Monthl, Retom Tctal Retum Calender Year to Date 2004 -- C'TY OF DUBUQUE MONTHLY 'NVESTMENT SUMMARY Month Ending, Jon-30-<>4 Fl,ot Commonlt, Managed Comblnod Dana DBOT TNot US Bank Accounts Ci~ Flnanco Total 5,004,04450 7,010,970.49 2,843,79506 7,185,830,30 22,9<4,64035 35,789,53008 58,734,170.43 17,757,64 20,134.43 7,64339 34,48460 79,920,06 57,028,71 136,948,77 (4,809,20) {2,305,57} (1,19165) (1118) (8,317,60) (8,317,60) 0,00 0,00 12,948,44 17,828,86 6,351.74 34,473.42 71,602,46 57,028,71 128,63117 0,00 0,00 (567,60) {628,63} (434,20) (622,65) (2,25328) (2,253,28) 0,00 (2,137,55) {2,137,55} 0,00 0,00 (56780) (626.63) (43420) (622,65) (2,253,28) (2,137,55) (4,360.63) 5,916.425,14 7,O2B,170,72 2,849,71260 7,219,68107 23,013,869,53 35,844,421,24 58,B68,410,77 0,00 (1,194,864.23) (1,194,864,23) 5,916,425,14 7028170,72 2,849 712,60 7,219 68107 230t39B9,53 34 649 557,01 ""'.548,54 5,916.425.14 7,O2B,17072 2,849,712,60 7,219,681,07 23,013,989,53 35,844,421.24 58,858,410,77 20,484,20 79.098,07 19,76B21 53,645,34 172,97582 78,409,37 251,385.19 {20,875 09) (72.519,64) (17,O42,40) {62,911,27} (173,348.30) {89,133,37} (262,46167) 5,916,014,25 7034 749,25 2852 43B,41 7,210415,14 23013,61705 35833 697,24 5B 847 31429 5,848,102,06 7,359,528,08 2,B17,585,31 7,206,430,24 23,231,645,66 39,290,176,52 82,521,B22,18 5,843,76530 7,290,13684 2,B14,22935 7,175,16449 23,123,297,98 34,695,419,91 57,818,717.89 20,484,20 79,098.07 19,768,21 53,645,34 172,975,82 78,490,37 251,365.19 5,864,229,50 7,369,236.91 2,833,997,66 7,228,809,83 23,296,27360 34,773,910,28 58,070,103,08 0.00 0,00 0,00 0,00 0.00 (1,194,864,23) (1,194,864,23) 5,864,229.50 7369236,91 2833997,56 7,22B 809,83 23 296,273,80 33,579 04605 68,876238,85 0,"" 0,14" 0,,"" 0,3'" 0,57" 0,45" 0.2'" 0,24" A"",go Laot AveragoLast Calondar 3 Month, 12 Months Yo" 1o Date 0.24" 0,98% 0,- (2.98%1 (1,35"1 (0,13"1 ('.13"1 0,51" (0,""1 (2.30%1 ,D.-I ,0,'""1 1,31" 2.84" 2,12% "'5" .Rat",o""""" ~Rotorn'prio'fo"" 90Da,T-B"" L_an Ag.rog"a Govt, Bond' LehmanShortTermGovtBond' Lohman Intermodlet. Govt, Bond,~ Co",omar Prlco Ind.. Co".nt Prime Rete. City of Dubuque Schedule of CertifICates of Deposit As of June 30. 2004 CertifICate Purchased Cost Purchase Maturity Last Interest Interest Days to Accrued Accrued Number From Basis Date Date Payment Rate Maturity Days Interest 52119 Liberty 1,006,367 12t11/03 07/08/04 06t08tO4 1,270% 8 22 770,35 10503 EDSB (M) 1,000,000 02t05/O4 07t08tO4 02105/04 1,521% 8 146 6,084,00 52157 Liberty 1,000,000 01t22/O4 07t22/O4 01/22tO4 1.470% 22 160 6,443,84 52118 Liberty(M) 1,006,618 12111t03 08/05t04 06/08/04 1,320% 36 22 800,88 10570 EDSB 1,000,000 02119tO4 08/05/04 02/19/04 1,539% 36 132 5,565,70 406769 Premier 1,000,000 02/12/04 08/19/04 02t12/O4 1,544% 50 139 5,879,89 52148 Liberty(M) 1,000,000 01/08/04 09/09/04 01t08lO4 1,370% 71 174 6,530,96 10657 EDSB (M) 1,000,000 03111/04 10t14/O4 03/11/04 1,489% 106 111 4,528,19 10669 EDSB 1,000,000 03t18/O4 09/16tO4 03/18/04 1.489% 78 104 4,242,63 52212 Liberty(M) 1,000,000 03/31/04 11/04t04 03/31/04 1,370% 127 91 3,415,62 10715 EDSB 1,000,000 O4106tO4 10/07/04 04/08/04 1,153% 99 83 2,621,89 397011248 US Bank (M) 1,000,000 04/01/04 12/09/04 O4tO1/O4 1,110% 162 90 2,736,99 350029458 US Bank 1,000,000 04/19/04 12/01/04 O4t19tO4 1,230% 154 72 2,426,30 350029459 US Bank 1,000,000 04/19/04 09/02/04 04t19/O4 1.110% 64 72 2,189,59 350029510 US Bank 1,000,000 04/21/04 11t01tO4 04/21/04 1,240% 124 70 2,378,08 52254 Liberty 1,000,000 O4t28/O4 11t10tO4 04/28tO4 1,370% 133 63 2,364,66 350029876 US Bank (M) 1,000,000 05t06tO4 01/06t05 05/06/04 1,440% 190 55 2,169,86 350029957 US Bank 1,000,000 05t10tO4 01/20/05 05t10/O4 1,650% 204 51 2,305.48 338038561 US Bank 1,000,000 05/13tO4 01/19/05 05t13tO4 1,670% 203 48 2,196,16 10842 EDSB 1,000,000 05/19/04 12/09/04 05t19tO4 1,849% 162 42 1,897.48 407054 Premier 1,000,000 OS/20/04 12/22tO4 05/20/04 1.710% 175 41 1,920,82 407076 Premier 1,000,000 OS/27/04 01/05/05 05127104 1,725% 189 34 1,606,85 407093 Premier 1,000,000 06/02104 01t13t05 06/02104 1,710% 197 28 1,311,78 350030332 US Bank 1,000,000 06t03/O4 02104/05 06/03/04 1,780% 219 27 1,316,71 350030333 US Bank 1,000,000 06/03/04 02/18t05 06/03/04 1,820% 233 27 1,346,30 116851-7 AT&S 1,000,000 06t07/O4 03/04/05 06t07/O4 1,995% 247 23 1,257,12 1168517t116778 AT&S (M) 1,000,000 06t11/O4 02/10t05 06t11/O4 1,998% 244 19 1,040,05 52322 Liberty 1,000,000 06tl7lO4 03/17/05 06t17tO4 2,270% 273 13 808.49 350030704 US Bank (M) 1,000,000 06/24/04 03/10/05 06/24tO4 2,030% 259 6 333,70 52346 Liberty 1,000,000 06/30/04 02/11t05 06/30/04 2,350% 226 0 0,00 Totals $30,012,986 $78,490.37 Weighted Yield: 1.580% Weighted Maturity: 143.26 Days (M) = DUBUQUE AREA METROPOLITAN SOLID WASTE AGENCY