Investment Report December 01UB E
MEMORANDUM
January 14,2002
TO:
FROM:
SUBJECT:
The Honorable Mayor and City Council Members
Michael C. Van Milligen, City Manager
December 31, 2001 Quarterly Investment Report
Finance Director Ken TeKippe is transmitting the attached December 31, 2001
Quarterly Investment Report.
Michael C. Van Milligen
MCVM/jh
Attachment
cc: Barry Lindahl, Corporation Counsel
Cindy Steinhauser, Assistant City Manager
Kenneth J. TeKippe, Finance Director
CITY OF DUBUQUE, IOWA
MEMORANDUM
TO:
FROM:
RE:
DATE:
Michael Van Milligen, City Manager
Kenneth J. T eKippe, Finance Director ~~(]. ~'~'~
December 31, 2001 Quarterly Investment Report
January 11, 2002
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 October 1, 2001 through December 31, 2001.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended December 31, 2001 and fiscal year to date
Schedule of City Funds (2 pages)
Monthly Investment Summary (2 pages)
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, Investments and Investment Earnings Summary
For The Quarter Ended December 31, 2001 & Fiscal 2001-02 YTD
Market Value /
Carrying Including
Description Value Accrued Interest
Deposits, Ch~mge & Petty Cash Funds
Checking/Savings Accounts
Certificates O£Deposit
US Treasury Securities
Corporate Stock
Investment Ad~sor Accounts
Total Funds
Unrealized
Gain (Loss) /
Accrued Interest
62,075 62,075 0
16,506,123 16,506,123 0
32,027,621 32,241,316 213,695
2,962,540 2,979,307 16,767
10,391 84,338 73,948
23,629,132 24,285,053 655,921
75,197,881 76,158,212 960,330
Bccakdown
Metro
Total Combined Funds
67,128,994
8,068,887
75,197,881
68,089,325 960,330
8,068,887 0
76,158,212 96o,33o
Cash Basis
Gross Earnings:
City
Metro
Combined
hrvestment Fees:
CRy ' 39,70~
Metro 16~
Combined 39,874
Net Earnings:
City 679,932
Metro 89,173
Combined 769,105
1,468,812
166,925
1,635,736
76,929
279
77,208
1,391,883
166,646
1,558,S29
01/08/2002 13:02
F:~123DATA\Finance[Inv~er~s 02~QUARTERI[QINVSU M~2002 ~dslQINVS U M-Dec01
CITY OF DUBUQUE
SCI~DULE OF CITY FUNDS
FOR MONTH ENDING DECEMBER 31, 2001
MANAGED FUNDS
PORTFOLIO
COMPOSITION
PERCENTAGE
COST
BASIS
TOTAL
CITY FUNDS
PERCENTAGE
Mutual Funds (US Govcmmem)
Certificates Of Deposit
US Treasury Obligations
Federal Agency Obligations
Total
0.00%
0.970/0
0.00%
0.00%
99.03%
100.00%
0.00
75,343.02
0.00
0.00
7,716,196.02
7,791,539.04 10.36%
DUBUQUE BANK & TRUST COMPANY:
Cash
Mutual Funds (US Govea'nme~)
Certificates Of Deposit
US Treasury Obligations
Federal Agency Obligations
Total
0.00%
10.48%
0.00%
0.00%
89.52%
0.00
816,543.22
0.00
0.00
6,975,464.80
100.00%
7,792,008.02
10.36%
FIRSTA!~
Cash
Mutual Funds (US Government)
Certificates Of Deposit
US Treasury Obligations
Federal Agency Obligations
Total
GRAND TOTAL
0.00%
24.03%
3.86%
15.65%
56.46%
100.00%
0.00
1,932,961,95
310,875.48
1259,065.69
4,542,681.74
8,045,584.86
23,6,29,131.92
10.70%
31.42%
BREAKDOWN BY TYPE OF SECURITY:
Cash
Mutual Funds (US Government)
Certificates Of Deposit
US Treasury Obligations
Federal Agency Obligations
TOTAL MANAGED FUNDS
0.00%
11.95%
1.32%
5.33%
81.40%
0.00
2,824,848.19
310,875.48
1,259,065.69
19,234,342.56
0.00%
3.76%
0.41%
1.67%
25.58%
100.00%
23,629,131.92
31.42%
Page t
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
FOR MONTH ENDING DECEMBER 31, 2001
OTHER FUNDS ]
CASH
Change Funds and Petty Cash
NPA & Wod<ers Comp Deposit
COST
B.4SIS
TOTAL
CITY FUNDS
PERCENTAGE
Total
9,075.00
53,000.00
62,075.00 O.08%
IsHECKENG / SAVINGS ACCOUN'I~:
Amexican Trust & S~ ~ (~ S~ep A~)
~ T~ & S~ ~d P~s)
~ T~ & S~ ~ (~ea's Riv~)
~ T~ & Sa~n~ ~ ~g Rehab)
~que ~ & Tm~ ~. (~ei~
F~ ~ (~e~l~b~ce/5 ~)
~ ~tfli~)
Total
1,853,518.12
2,154,324.34
9,448,405.54
516,587.86
2,223,132.70
301,220.91
1,047.13
7,885.97
16,506,122.57
21.95%
CER'ffflCATES OF DEPOSIT:
American Trust & Savings Bank
Dupaco Community Credit Union
Dubuque Bank & Trust Co.
East Dubuque Savings Bank
Firstar Bank
Libeoay Bank
Premier Bank
Total
1,000,000.00
1,000,000.00
5,500,000.00
3,500,000.00
5,500,000.00
13,527,621.10
2,000,000.00
32,027,621.10
42.59%
U.S. TREASURY OBLIGATIONS
2,962,54O.00
3.94%
CORPORAT~ STOCK (Lyons Peony Trust)
10,390.70
0.01%
TOTAL OI'HER FUNl~
51,568,749.37
68.58%
TOTAL CITY FUNDS
75,197,881.29
10~00%
[RECAP OF PORT]FOLIO PERCENTAGES
CASH
CHECKING / SAVINGS ACCTS
CERTIFICATES OF DEPOS1T
U.S. TREASURY OBLIGATIONS
FEDERAL AGENCY OBLIGATIONS
CORPORATE STOCK
Total
M~AGED
FUNDS
0.00%
0.00%
3.76%
0.41%
1.67%
25.58%
0.00%
OTHER
FUNDS
0.08%
21.95%
0.00%
42.59%
3.94%
0.00%
0.01%
COM~EVED
TOTAL
0.08%
21.95%
3.76%
43:00%
5.61%
25.58%
0.01%
31.42%
Page 2
68.58%
100.00%
C~-
'~Z
O~
~-Z
l-
Z
0