Quarterly investment reportCITY OF DUBUQUE, IOWA
MEMORANDUM
January 12, 2000
TO: The Honorable Mayor and City Council Members
FROM:
SUBJECT:
Michael C. Van Milligen, City Manager
Quarterly Investment Report
Finance Director Duane Pitcher is submitting the City's quarterly investment
reports.
Michael C Van Mdl'igen ~
MCVM/dd
Attachment
CC:
Barry Lindahl, Corporation Counsel
Tim Moerman, Assistant City Manager
CITY OF DUBUQUE, IOWA
MEMORANDUM
January 7, 2000
TO: Michael Van Milllgen, City Manager
FROM: Duane Pitcher, Finance Director
SUBJECT: Quarterly Investment Report
INTRODUCTION
The purpose of the memorandum is to transmit the quarterly investment report as prescribed
within the City of Dubuque Investment Policy Section 17.0 "Reporting".
DISCUSSION
This report covers the period beginning July 1, 1999, and ending December 31, 1999.
The report presems a summary of the investments on hand at the end of the quarter and
indicates the earnings recorded for the period and fiscal year end. Also included are reports
s~mmarizing investment advisor performance and composition of the investment portfolio by
type of investment and specific account.
The valuation reflects the same basis that the assets are carded on the financial records of the
City.
The City is in compliance with the Investment Policy.
REQUESTED ACTION
This report is for your review and filing with the Honorable Mayor and City Council.
Attachments
CITY OF DUBUQUE, IOWA
CASH AND INVESTMENTS SUMMARY
AND SUMMARY OF INVESTMENT EARNINGS
FOR THE QUARTER ENDED DECEMBER 31, 1999
AND THE ACCUMULATED YEAR-TO-DATE
CARRYING
DESCRIPTION VALUE
MONEY FUND SAVINGS ACCOUNTS 7,124,364
MUTUAL FUNDS 0
INVESTMENT POOLS 0
CERTIFICATES OF DEPOSIT 2,081,019
REPURCHASE AGREEMENTS 0
US TREASURY SECURITIES 20,067,150
FEDERAL AGENCY SECURITIES 0
CORPORATE STOCK 6,825
INVESTMENT ADVISOR ACCOUNTS 21,180,948
IN3rESTMENTS
CASH ACCOUNTS
TOTAL FUNDS AVAILABLE
MARKET VALUE UNREALIZED
(INCLUDING GAIN OR
~CCRUED INTEREST (LOSS)
7,124,364 0
0 0
0 0
2,094,764 13,745
0 0
20,490,404 423,254
0 0
142,105 135,280
21,042,114 -138,834
50,460,306 50,893,751 433,445
1,732,255 1,732,255 0
52,192,561 52,626,006 433,445
CITY 45,166,077 45,446,677 280,600
METRO 7,026,484 7,179,329 152,845
COMBINED 52,192,561 52,626,006 433,445
CASH BASIS ~ QUARTER
GROSS EARNINGS:
CITY 504,215
METRO 49,004
COMBINED
INVESTMENT FEES:
YR-TO-DATE [
960,151
139,134
553,219 1,099,285
CITY 35,802
METRO 226
COMBINED 36,028
NET EARNINGS:
CITY 468,413
METRO 48,778
COMBINED 517,191
69373
328
69,701
890,778
138,806
1,029,584
SCHEDULE OF CITY FUNDS
Month Ending:
COMPOSITIOI COST
PERCENTAGI BASIS
Dec-31-99
TOTAL
CITY FUNDS
PERCENTAGE
{DANA INVESTMENT ADVISORS, INC.:
CASH 0.00% 0.00
TRUST SAVINGS ACCOUNT 0.00% 0.00
MUTUAL FUNDS (US GOVERNMENT) 0.73% 50,916.29
CERTW!CATES OF DEPOSIT 0.00% 0.00
US TREASURY OBLIGATIONS 0.00% 0.00
FEDERAL AGENCY OBLIGATIONS 99.27% 6,938,915.61
TOTAL t 00.00% 6,989,831.90
13.39°/o
{DUBUQUE BANK & TRUST COMPANY:
CASH 0.00% 0.00
TRUST SAVINGS ACCOUNT 0.00% 0.00
MUTUAL FUNDS (US GOVERNMENT) 14.34% 1,003,865.90
CERTIFICATES OF DEPOSIT 0.00% 0.00
US TREASURY OBLIGATIONS 21.51% 1,505,632.50
FEDERAL AGENCY OBLIGATIONS 64.15% 4,490,562.17
TOTAL 100.00% 7,000,060.57
13.41%
]MERCANTll ,F, BANK MIDWEST {
CASH 0.00% 0.00
TRUST SAVINGS ACCOUNT 0.00% 0.00
Mu'rUAL FUNDS (US GOVERNMENT) 5.92% 425,555.86
CERTIIqCATES OF DEPOSIT 4.17% 300,000.00
US TREASURY OBLIGATIONS 55.81% 4,012,985.15
FEDERAL AGENCY OBLIGATIONS 34.11% 2,452,514.85
TOTAL 100.00% 7,191,055~86 13.78%
TOTAL MANAGED FUNDS
{CUSTODIAL ACCOUNT: AT&S BANK
21,180,948.33 40.58%
I
CASH 0.00%
TRUST SAVINGS ACCOUNT 0.00%
MUTUAL FUNDS (US GOVERNMENT) 0.00%
CERTIFICATES OF DEPOSIT 0.00%
US TREASURY OBLIGATIONS 0.00%
FEDERAL AGENCY OBLIGATIONS 0.00%
TOTAL 0.00%
0.00
0.00
0.00
0.00
0.00
0.00
0.00 0.00%
]BREAKDOWN BY TYPE OF SECURITY:
CASH 0.00% 0.00
TRUST SAVINGS ACCOUNT 0.00% 0.00
MUTUAL FLrNDS (US GOVERNMENT) 6.99% 1,480,338.05
CEKfI~'ICATES OF DEPOSIT 1.42% 300,000.00
US TREASURY OBLIGATIONS 26.05% 5,518,617.65
FEDERAL AGENCY OBLIGATIONS 65.54% 13,881,992.63
Total Managed Funds and Custodial Acct. 100.00% 21,180,948.33
0.000/0
0.00%
2.84%
0.57%
10.57%
26.60'/6
40.58%
lof3
SCHI~DULE OF CITY FUNDS
Month Ending:
APPROXIMAT COST
IDENTIFICATION RETURN BASIS
Dec-31-99
CITY FUNDS
PERCENTAGE
CHANGE FUNDS & PC ADVANCES N/A
PETTY CASH PURCHASES N/A
INSURANCE DEPOSITS N/A
TOTAL
17,956.00
1,194.99
1,000.00
20,150.99
0.04%
CASH { N/A
54,703.07
0.10%
{BANK N.O.W. ACCOUNTS:
AMERICAN TRUST & SAVINGS BANK 2.95000/0
DUBUQUE BANK & TRUST CO. 2.5000%
FIRSTAR BANK IOWA, N.A. 2.0000%
MERCAN'fJLE BANK MIDWEST 2.0000%
TOTAL
196,015.62
1,175,850~86
2,613.61
282,921.28
1,657,401.37
3.18%
[BANK MONEY FUND SAVINGS ACCTS: ]
AMERICAN TRUST & SAVINGS BANK 4.3800%
DUBUQUE BANK & TRUST CO. 2.8500%
TOTAL
6,088, t99.86
t,036,163.74
7,124,363.60
13.65%
]TRUST POOLS:
IPAIT N/A
TOTAL
0.00
0.00
0.00%
TOTAL
N/A
0.00
0.00
0.00%
[CERTIYlCATES OF DEPOSIT:
DUBUQUE BANK & TRUST COMPANY
AMERICAN TRUST & SAVINGS BANK
DUPACO COMMUNITY CREDIT UNION
FIRSTAR BANK IOWA, N.A.
TOTAL
]
5.3400%
N/A
5.2290%
790,045.69
0.00
t,290,972.90
0.00
2,081,018.59
3.990/0
U.S. TREASURY OBLIGATIONS:
CHICAGO FEDERAL RESERVE BANK
5.0990% 20,067,150.00
38.45%
{REPURCHASE AGREEMEaNTS: I
0.00 0.00%
]CORPORATE SECURrrlES: ]
AT&T & REGIONAL STOCK
N/A
6,825.38 0.01%
TOTAL O'I'H ER FUNDS
31,011,613.00 59.42%
TOTAL CITY FUNDS
52,192,561.33 100.00%
2of3
SCBEDULE OF CITY FUNDS
Month Ending:
OTHER
FUNDS
Dec-31-99
COMBINED
TOTAL
EXPENSE ADVANCES
CASH
BANK N,O.W. ACCOUNTS
BANK MONEY FUND SAVINGS ACCTS
TRUST SAVINGS ACCOUNTS
TRUST POOLS
MUTUAL FUNDS (US GOVERNMENT)
CER't IP'iCATES OF DEPOSIT
REPURCHASE AGREEMENTS
US TREASURY OBLIGATIONS
FEDERAL AGENCY OBLIGATIONS
CORPORATE SECURITIES
0.00% 0.04% 0.04%
0.00%0 O. 10% O. 10%
0.00% 3.18% 3.18%
0.00% 13.65% 13.65%
0.00%o 0.00%o 0.00%
0.00% 0.00% 0.00%
2.84% 0.00% 2.84%
0-57O/o 3.99% 4.56o/o
0.00% 0.00% 0.00%
10.57% 38.45% 49.02%
26.60% 0.00% 26.60%
0.00% 0.01% 0.01%
TOTAL 40.58%
59.42% 100.00%
3of3