Loading...
Investment Report Qtr 12 31 00CITY OF DUBUQUE, IOWA MEMORANDUM January 31, 2001 TO: FROM: SUBJECT: The Honorable Mayor and City Council Members Michael C. Van Milligen, City Manager December 31, 2000 Quarterly Investment Report Finance Director Ken TeKippe is transmitting the attached quarterly investment report. MCVM/jh Attachment cc: Barry Lindahl, Corporation Counsel Tim Moerman, Assistant City Manager Kenneth J. TeKJppe, Finance Director CITY OF DUBUQUE, IOWA MEMORANDUM TO: FROM: RE: DATE: Michael Van Milligen, City Manager Kenneth J. TeKippe, Finance Director ~ December 31, 2000 Quarterly Investment Report January 12, 2001 INTRODUCTION The purpose of the memorandum is to transmit the quarterly investment report as prescribed with/n the City of Dubuque Investment Policy Section 17.0 "Reporting." DISCUSSION This report covers the period from October l, 2000 through December 31, 2000. The report includes: Cash Investments and Investment Earnings Summary for quarter ended December 31, 2000 and fiscal year to date Schedule of City Funds Monthly Investment Summary Schedule of U.S. Treasury Securities 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. KJT/gmm Enclosures CITY OF DUBUQUE CASH, DIVERS AND INVESTMENT EARNINGS SUMMARY FOR rl'l~ QUARTER ENDED DECEMBER 31, 2000 AND FISCAL 2000--2001 YEAR--TO--DATE DESCRIPTION CHECKING/SAVINGS ACCOUNTS MUTUAL FUNDS CERTIFICATES OF DEPOSIT REPURCHASE AGREEMENTS US TREASURY SECURITIES lqe~DERAL AGENCY SECURITIES CORPORATE STOCK INVESTMENT ADVISOR ACCOUN3~ INVESTMENTS CASH ACCOUNTS TOTAL FUNDS AVAH~I~tBLE MARKET VALUE UNREAl CARRYING 0NCLUDING GAIN (LOSS) / VA, I21~ ACCRUED INTEREST} ACCRUED 19,032,584 19,032,584 0 0 0 0 11,175,630 11,311,577 135,947 0 0 0 11,121,545 11,367,117 245,572 0 0 0 10,391 98,871 88,480 22,346,693 22,716,516 369,823 63,686,843 64,526,665 8~9,822 19,600 19,600 0 63,706,444 64,546,265 839,822 CITY lVIETRO COMBINED 57,032,911 57,756,131 723,220 6,673,533 6,790,134 116,601 CASH BASIS GROSS EARNINGS: CITY METRO COMBUNF~ INVESTMENT FEES: CITY M~TRO COMBINED NET EARNINGS: CITY METRO COM~INED I s49,azsI 1,484,201 179,331[ 259,180 1,029,159] 1,743,380 37,Z371 72,175 IS31 2~ 37,390[ 72,434 812,592[ 1,412,026 179,17SI Z5S,920 991,769~ 1,670,946 Cf fY OF DUBUQUE SCI~DULE OF CITY FUNDS FOR MONTH ENDING DECEMBER 31, 2000 MANAGED FUNDS PORTFOLIO COMPOSITION PERCENTAGE COST BASIS TOTAL CITY FUNDS PERCENTAGE DANA INVESTMENT ADVISORS, INC.: Cash Mutual Funds (US Government) Certificates Of Deposit US Treasm3~ Obligatiuns Federal Agency Obligations Total 0.00% 0.00 3.64% 269,402.74 0.00% 0.00 0.00% 0.00 96.36% 7,123,613.69 100.00% ~393,016.43 11.OO% DUBUQUE BANK & TRUS~ COMPANY: Cash Mutual Funds (US Gove~ment) Certificates Of Deposit US Trcasuxy Obligations Federal Agency Obligations Total 0.00% 0.00 8.18% 603,428.14 0.00% 0.00 0.00% 0.OO 91.82% 6,773,799.08 100.00% 7,377,227.22 11.58% FIRSTAR: Cash Mutual Funds (US Govemmunt) Certificates Of Deposit US Treasury Obligations Federal Agency Obligations Total GRAND TOTAL 0.00% 0.00 8.36% 633,672.79 5.33% 403,490.81 38.41% 2,910,478.77 47.90% 3,628,807.47 loo.00% 7,576,449.84 11.89% 22,346,693.49 35.08% BREAKDOWN BY TYPE OF SECURITY: Cash Mutual Funds (US Gov~mnent) Certiticates Of Dq~sit US Treasury Obligafiuns Federal Agency Obligations TOTAL MANAGED FUNDS 0.00% 0.00 0.00% 6.74% 1,506,503.67 2.36% 1.81% 403,490.81 0.63% 13.02% 2,910,478.77 4.57% 78.43% 17,526,220.24 27.51% 1 OO.00°/6 22,346,693.49 35.08% Page 1 CASH Change Funds Petty Cash Insurance Deposit CH'Y OF DUBUQUE SCHEDULE OF CfI'Y FUNDS FOR MONfH ENDING DECEMBER 31, 2000 OTHER FUNDS TOTAL COST CITY FUNDS BASIS PERCENTAGE Total 18,175.00 425.t6 1,000.00 1%600.16 0.03% CHECKING / SAVINGS ACCOUNTS: American Trust & Savings Bank (Sweep Acct) American Trust & Savings Bank (Bo~ Proc~!s) American Trust & Savings Bank (P. omng Rehab) Dubuque Bank & Trust Co. (Sv~eep Acas) Firstar Bank ( Amb,da,x::e) Lib~ (U~) Premier C,O~iW) Total 9,324,710.12 5,604,399.73 103,824.66 3,627,478.11 368,613.26 822.64 2,735.77 19,032,584.29 29.88% CERTIFICATES OF DEPOSIT: American Trust & Savings Bank Dupaco Community Credit Union Dubuque Bank & Trust Co. East Dubuque Savings Bank 2,oo0,ooo.o0 1,175,629.96 2,000,000.00 6,000,000.00 11,175,629.96 17.54% U.S. TREASURY OBLIGATIONS 11,121,545.00 17.46% CORPORATE STOCK (L~m Peony Trust) 10,390.70 0.02°/0 TOTAL OIHER FUNDS 41,359,750.11 64.92% TOTAL CfI'Y FUNDS 100.00% [RECAP OF PORTFOLIO PERCENTAGES CASH CHECKING / SAVINGS ACC'TS MUTUAL FUNDS (U.S. GOVERNMENT) CER'IIFICATES OF DEPOSIT U.S. TREASURY OBLIGATIONS FEDERAL AGENCY OBLIGATIONS CORPORATE STOCK Total Page 2 MANAGED FUNDS 0.00%0 0.00% 2.360/0 0.63% 4.570/0 27.51% 0.00%0 OTHER FUNDS 0.03% 29.880/0 0.00%o 17.54% 17.46% 0.00% 0.02% C O MB1NED TOTAL 0.03% 29.88% 2.36% 18.18% 22.03% 27.51% 0.02% 35.08% 100.00%o COST BASIS ANALYSIS ]BEGINNING BALANCE (COST BASIS) I ADDITIONS: DIVIDENDS & INTEREST REALIZED GAINS (LOSSES) TOTAL ADDITIONS SUBTRACTIONS: MANAGEMENT FEES CUSTODIAL FEES BANK CHARGES TOTAL SUBTRACTIONS [ENDING BALANCE (COST BASIS) MONTIILY INCREASE (DECREASE) CITY OF DUBUQUE MONTHLY INVESTMENT SUMMARY Month Ending: Dec-31~O0 Managed Combined Dana DB&T Firstar Accounts City Finance Total 7,341,421.32 7,349,936.02 7,571,296.14 22,262,653.48 37,233,220.89 59,495,874.37 53,902.47 28,458.49 5,809.72 88,170.68 257,054.42 345,225. l0 (1,68131) (532.69) (20.64) (2,234.64) 0.00 (2,234.64) 52,221.16 27~925.80 5,789.08 85,936.04 257,054.42 342,990.46 0.00 0.00 0.00 0.00 0,00 0~00 626.05 634.60 635.38 1,896.03 0.00 1,896.03 0,00 0.00 0.00 0,00 1,566.41 1,566.41 626.05 634.60 635.38 1,896.03 1,566.41 3,462.44 7,393,016.43 7,377,227.22 7,576,449.84 22,346,693.49 37,488,708.90 59,835,402.39 51,595.11 27~291.20 5,153.70 84,040.01 ~55,488.01 339,528.02 0.00 0.00 0.00 0.00 3,871,041.21 3,871,041.21 7,393,016.43 7,377,227.22 7~5761449.84 22,346,693.49 41,359,750.11 63,706,443.60 NET RECEIPTS & DISBURSEMENTS COST BASIS CARRIED FORWARD RETURN ON ASSETS COST BASIS CURRENT MONTH LESS: Accrued Intcr~st Prior Month PLUS: Accrued Interest Current Month Annualized Return: Curreat Month MARKET VALUE ANALYSIS SECURITY MARKET VALUE ACCRUED INTEREST ENDING MARKET VALUE NET RECEIPTS & (DISBURSEMENTS) Adjusted Ending Market Value BEGINNING MARKET VALUE Percentage Change in Market Value 7,393,016.43 7,377,227.22 7,576,449.84 22,346,693.49 37,488,708.90 59,835,402.39 (68,18Z21) (101,173.73) (74,773.73) (244,134.67) (489,033.65) (733,168.32) 58,093.69 113,415.78 111,344.8t 282,854.28 381,519.05 664,373.33 7,382,922.91 7,389,469.27 7,613,020.92 22,385,413.10 37,381,194.30 59,766,607.40 6. 78% 6.45% 6.61% 6.62% 4. 77% 5.46% 7,262,161.06 7,557,267.50 7,614,233.30 22,433,661.86 41,448,230.12 63,881,891.98 58,093.69 113~415.78 111,344.81 282,854.28 381~519.05 664,373.33 7~320,254.75 7,670,683.28 7,725,578.11 22,716,516.14 41,829,749.17 64,~46,265.3 I 0.00 0.00 0.00 0.00 3,871,041.21 3,871,041.2l 7,320,254.75 7,670,683.28 7,725,578.11 22,716,516.14 37,958,707.96 60,675,224.10 7,293,493.37 7,531,482.72 7,623,8t5.62 22,448,791.71 37,871,095.13 60,319,886.84 0.37% t.81% 1.32% 1.18% 0.23% 0.59% Page 1 CITY OF DUBUQUE · MONTHLY INVESTMENT SUMMARY '~ · Month Ending: Dec-31-00 ~' Market Indices Ave. Last 12 Mo. Average Last 3 Monlhs* 90 Day T-Bills Lehman Short Term Govt. Bonda LehmauAgg. Govt. Bonds Consumer Prig Index Currcat Prime Ram 6,18%I 8. t7%I 11.63% 3,04% 1.10°/ot 2.76%I 4.21% 0.90% *,,lnnual~zed YTD 6.18%I 8.17% 11.63%[ 3.04% 9.00% 12-31-00 Page 2 City of Dubuque Schedule of U.S. Treasury Securities As of December 31, 2000 Par Issue Maturity Cost Days to CUSIP No. Value Date Date Price Basis Yield Maturity 912795ES6 1,000,000.00 07/06/2000 01/04/2001 96.979 969,790.00 6.247% 3 912795FQ9 2,000,000.00 07/27/2000 01/25/2001 96.962 1,939,240.00 6.284% 24 912795FR7 1,000,000.00 02/03/2000 02/01/2001 94.029 940,290~00 6.287% 31 912795FS5 1,000,000.00 08/10/2000 02/08/2001 96.936 969,360.00 6.339% 38 912795FT3 1,000,000.00 08/17/2000 02/15/2001 96.929 969,290.00 6.354% 45 912795FX4 1,500,000.00 09/14/2000 03/15/2001 96.989 1,454,835.00 6.226% 73 912795GA3 1,000,000.00 10/05/2000 04/05/2001 96.946 969,460.00 6.318% 94 912795GD7 1,000,000.00 10/26/2000 04/26/2001 96.941 969,410.00 6.328% 115 912795GF2 1,000,000.00 11/09/2000 05/10/2001 96.914 969,140.00 6.386% 129 912795GL9 1,000,000.00 12/14/2000 06/14/2001 97.073 970,730.00 6.047% 164 Totals $11,500,000.00 $11,121,545.00 Interest 29,380.05 52,080.00 54,296.73 23,905.93 22,779.40 26,553.05 14,430.99 10,925.00 8,647.58 2,573.19 $245,571.92 Weighted Yield: 6.279% Weighted Maturity: 67.52 Days City of Dubuque Schedule of Certificates of Deposit As of December 31, 2000 t Certificate Number 29018 104639 4213 4303 4311 4334 4408 30742 4530 501153 113289 5335 5364 505504 Totals Purchased From A.T.&S. EDSB EDSB EDSB EDSB EDSB Dupaco EDSB DB&T A.T.&S. EDSB EDSB DB&T Cost Basis Purchase Maturity Last Interest Compounded Days to Date Date Pa~nent Yield Maturit~ Interest ]Certificate Descrip~oa~ Certificate Number 668,879.28 03/29/00 03/29/01 12/31/00 6.810% 88 0.00 1,000,000.00 03/29/00 03/29101 03/29/00 6.470% 88 49,101.10 500,000.00 08/25/00 02/23/01 08/25/00 7.000% 54 12,273.97 500,000.00 09/08/00 03/08/01 09/08/00 6.780% 67 10,587.95 500,000.00 09/11/00 09/11/01 09/11/00 7.036% 254 t0~339.73 500,000.00 09/14/00 03/14/01 09/14/00 6.780% 73 10,030.68 500,000.00 09/29/00 06/29/01 09/29/00 6.800% t 80 8,663.01 506,750.68 I0/16/00 04/16/01 12/31/00 6.400% 106 0.00 1,000,000~00 10/16/00 10/16/01 10/16/00 6.918% 289 13,929.86 1,000,000.00 11/16/00 11/16/01 11/16/00 6.690% 320 8,112.33 1,000,000.00 11/29/00 05/30/01 11/29/00 6.520% 150 5,716.16 1,000,000.00 t2/15/00 06/15/01 12/15/00 6.422% 166 2,814.25 1,500,000.00 12/21/00 12/21/01 12/21/00 6.609% 355 2,630.14 1,000,000.00 12/21/00 06/21/01 12/21/00 6.380% 172 1,747.95 Weighted Yield: $11,175,629.96 6,649% Weighted Maturity: 191.85 Days Purchased Rate Interest Compounded From Basis Rate Yield $135,947.13 29018 104639 4213 4303 4311 4334 4408 30742 4530 501153 113289 5335 5364 505504 Dupaco 90/360 6.70% 6.810% A.T.&S. 365/365 6.47% 6.470% EDSB 182/365 7.00% 7.000% EDSB 181/365 6.78% 6.780% EDSB 181/365 6.80% 7.036% EDSB t 81/365 6.78% 6.780% EDSB 181/365 6.80% 6.800% Dupaco 90/360 6.40% 6.400% EDSB 181/365 6.69% 6.918% DB&T 181/365 6.58% 6.690% A.T.&S. 182/365 6.52% 6.520% EDSB 182/365 6.42% 6.422% EDSB 182/365 6.40% 6.609% DB&T 182/365 6.38% 6.380% Earnings credited quarterly and added to principal. Earnings credited at maturity. Earnings credited at maturity. Earnings credited at maturity. Earnings credited semi-annually and added to principal Earnings credited at maturity. Earnings credited semi-annually and added to principal Earnings credited quarterly and added to principal. Earnings credited semi-annually and added to prioeipal. Earnings credited semi-annually aed added to principal. Earnings credited at maturity. Earnings credited at maturity. Earnings credited semi-annually and added to principal. Earnings credited at maturity.