Quarterly Investment Report 9 30 08THE CITY OF DUBUQUE
Masterpiece on the Mississippi
Dubuque
All-American City
2007
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: September 30, 2008 Quarterly Investment Report
DATE: October 28, 2008
Finance Director Ken TeKippe is transmitting the attached September 30, 3008
Quarterly Investment Report.
Michael C. Van Milligen
MCVM/jh
Attachment
cc: Barry Lindahl, City Attorney
Cindy Steinhauser, Assistant City Manager
Kenneth J. TeKippe, Finance Director
THE CITY OF DUBUQUE
Masterpiece on the Mississippi
Dubuque
All-American City
2007
Memroandum
TO: Michael C. Van Milligen, City Manager
FROM: Kenneth J. TeKippe, Finance Director
RE: September 30, 2008 Quarterly Investment Report
DATE: October 23, 2008
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, 2008 through September 30, 2008.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended September 30, 2008 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, 2008 8~ Fiscal 2009 YTD
Market Value / Unrealized
Carrying Including Gain (Loss) /
Description Value Accrued Interest Accrued Interest
Deposits, Change 8~ 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
Cash Basis
Gross Earnings:
City
Metro
Combined
Investment Fees:
City
Metro
Combined
Net Earnings:
City
Metro
Combined
96,412 96,412 -
21,681,839 21,681,839 -
26,700,000 26,937,738 237,738
2,015,125 2,182,478 167,353
11,514 64,550 53,036
24,662,551 24,908,612 246,061
75,167,441 75,871,629 704,188
63,816,107 64,376,007 559,900
11,351,334 11,495,622 144,288
75,167,441 75,871,629 704,188
Quarter Year-To-Date
689,434 689,434
111,676 111,676
801,110 801,110
(34,701) (34,701)
(126) (126)
(34,827) (34,827)
654,732 654,732
111,550 111,550
766,282 766,282
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
September 30, 2008
FY09
MANAGED FUNDS
PORTFOLIO TOTAL
COMPOSITION COST CITY FUNDS
PERCENTAGE BASIS PERCENTAGE
DANA INVESTMENT ADVISORS, INC:
Cash and Equivalents
US Treasury Obligations
US Agencies
Mortgaged Backed Securities
Municipal Bonds
Tota!
DUBUQUE BANK 8~ TRUST:
Cash and Equivalents
US Treasury Obligations
US Agencies
Mortgaged Backed Securities
Municipal Bonds
Mutual Funds
Total
FIRST COMMUNITY TRUST:
Cash and Equivalents
US Treasury Obligations
US Agencies
Mortgaged Backed Securities
Municipal Bonds
Tota!
US BANK:
Cash and Equivalents
US Treasury Obligations
US Agencies
Mortgaged Backed Securities
Municipal Bonds
Total
GRAND TOTAL
BREAKDOWN BY TYPE OF SECURITY:
Cash
Municipal Bonds
Mortgage Backed Securities
Mutual Funds
US Treasury Obligations
US Agency Obligations
TOTAL MANAGED FUNDS
2.3% 144,835
0.0% 0
97.7% 6,116,219
0.0% 0
0.0% 0
100.0% 6,261,054 8.3%
4.3% 334,158
10.0% 776,816
54.8% 4,264,886
17.0% 1, 325, 045
0.0% 0
13.9% 1, 085, 335
100.0% 7,786,240 10.4%
0.5% 13,609
0.0% 0
68.8% 2,068,297
30.7% 923,364
0.0% 0
100.0% 3,005,270 4.0%
1.7% 129,768
2.6% 200, 781
62.8% 4,779,439
32.9% 2, 500, 000
0.0% 0
100.0% 7,609, 988 10.1
24,662, 552 32.8%
2.5% 622,370 0.8%
0.0% 0.0%
19.3% 4,748,409 6.3%
4.4% 1, 085, 335 1.4%
4.0% 977, 597 1.3%
69.9% 17,228,841 22.9%
100.0% 24,662,552 32.8%
Page 1
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
September 30, 2008
FY09
TOTAL
COST CITY FUNDS
OTHER FUNDS BASIS PERCENTAGE
CASH
Change and Petty Cash Funds 11,412
Prescriptions & Workers Comp Deposits 85,000
Total 96, 412 0.1
CHECKING /SAVINGS ACCOUNTS:
American Trust & Savings Bank (General a Healtn) 166,315
American Trust & Savings Bank (Housing F2enab & section e} 110,529
DUbUgUe Bank & Trust (General/Metro/Leisure) 5,679,402
Dubuque Bank & Trust (~icw Bond Proceeds) 455,616
DUbUgUe Bank & TfUSt (CommVlnd Bldg Rehab & Econ Dev) 83,278
DUbUgUe Bank 8e TfUSt (Cable Franchise Equipment Fund) 271,402
US Bank (General/Ambulance) 18,110
US Bank (Sanitary Sewer Bond Proceeds) 418, 799
Premier (utility) 8,235
Liberty (utility) 7,326
East Dubuque Savings Bank (utility) 11,074
State Central (utility) 3,705
Total 7, 233, 791 9.6%
CERTIFICATES OF DEPOSIT:
American Trust & Savings Bank 4,000,000
Dubuque Bank & Trust 7,700,000
East Dubuque Savings-Bank 4,000,000
Liberty Bank 2,000,000
Premier Bank 0
State Central 6,000,000
US Bank 3,000,000
Total 26, 700, 000 35.5%
PORT OF DUBUQUE PARKING RAMP
Capitalized Interest Fund EDSB (Bond Proceeds) ~o2a 2,847,190 3.8%
Project Construction Fund US Bank (Bond Proceeds) ~o2s 10,883,076 14.5%
North Facade EDSB (Bond Proceeds) X030 717,783 1.0%
Debt Service Reserve u s Treasury Obligations (Bond Proceeds) 2, 015,125 2.7%
Total 16,463,174 21.9%
CORPORATE STOCK (Lyons Peony Trust) 11,514 0.0%
TOTAL OTHER FUNDS 50,504,891 67.2%
TOTAL CITY FUNDS 75,167,443 100.0%
RECAP OF PORTFOLIO PERCENTAGES Managed City Combined
CASH 0.8% 0.13% 0.96%
CHECKING /SAVINGS ACCTS 0.0% 28.84% 28.84%
MUNICIPAL BONDS 0.0% 0.00% 0.00%
MUTUAL FUNDS (U.S. GOVERNMENT) 1.4% 0.00% 1.44%
MORTGAGE BACKED SECURITIES 6.3% 0.00% 6.32%
CERTIFICATES OF DEPOSIT 0.0% 35.52% 35.52%
U.S. TREASURY OBLIGATIONS 1.3% 2.68% 3.98%
FEDERAL AGENCY OBLIGATIONS 22.9% 0.00% 22.92%
CORPORATE STOCK 0.0% 0.02% 0.02%
Total 32.8°k 67.2°k 100.0%
Page 2
CITY OF DUBUQUE
MONTHLY INVESTMENT SUMMARY
City of Dubuque
Schedule of Certificates of Deposit
As of
September 30, 2008