Quarterly Investment Report March 31, 2009THE 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: March 31, 2009 Quarterly Investment Report
DATE: April 28, 2009
Finance Director Ken TeKippe is transmitting the March 31, 2009, Quarterly Investment
Report to be received and file.
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 DUBQUE
Masterpiece on the Mississippi
Dubuque
All-American City
2007
TO: Michael C. Van Milligen, City Manager
FROM: Kenneth J. TeKippe, Finance Director
RE: March 31, 2009 Quarterly Investment Report
DATE: April 22, 2009
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 January 1, 2009 through March 31, 2009.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended March 31, 2009 and fiscal year to date
Schedule of City Funds (3 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 March 31, 2009 & Fiscal 2009 YTD
Market Value / Unrealized
Carrying Including Gain (Loss) /
Description Value Accrued Interest Accrued Interest
Deposits, Change & Petty Cash Funds
Checking/Savings Accounts
Certificates Of Deposit
US Treasury Securities
Corporate Stock
Investment Advisor Accounts
Total Funds
96, 337 96, 337 -
15, 304, 944 15, 304, 944 -
29,000,000 29,278,751 278,751
2,015,125 2,442,627 427,502
11, 514 56, 665 45,151
25,389,128 25,518,336 129,208
71,817,048 72,697,660 880,612
Breakdown
City
Metro
Total Combined Funds
Cash Basis
Gross Earnings:
City
Metro
Combined
Investment Fees:
city
Metro
Combined
Net Earnings:
City
Metro
Combined
60,472,454 61,259,979 787,525
11, 344, 594 11, 437, 681 93, 087
71,817,048 72,697,660 880,612
Quarter Year-To-Date
693, 786
87, 726 2, 097, 793
329,133
781, 512 2, 426, 926
(34,713)
101 (104,258}
415
(34, 814) (104, 673)
659, 073
87,625 1, 993, 535
328,718
746,698 2,322,253
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
March 31, 2009
TOTAL
COST CITY FUNDS
OTHER FUNDS BASIS PERCENTAGE
CASH
Change and Petty Cash Funds 11,337
Prescriptions & Workers Comp Deposits 85,000
Total 96, 337 0.1
CHECKING /SAVINGS ACCOUNTS:
American Trust & Savings Bank (cenerdi & Fiealtn) 213,535
American Trust & Savings Bank (Housing Renab a section s) 227,503
Dubuque Bank & TrUSt (GeneravMetro/Leisure) 3,934,145
Dubuque Bank & Trust (Commuind Bidg Renab & Econ Dev) 94,697
Dubuque Bank & TfUSt (Cable Franchise Equipment Fund) 165,992
US Bank (GeneraVAmbulance) 19,297
Premier (util~y) 3,232
Liberty (utility) 4,981
East Dubuque Savings Bank (utility) 4,456
State Central (utility) 3,705
First Bank - Pet~ata 0
Total 4,671,543 6.5%
BOND PROCEEDS:
US Bank (Sanitary Sewer Bond Proceeds) 405,947
DB&T GO Stormwater Series 2008A 1,266,081
DB&T GO Urban Renewal Series 20088 2,931,054
DB&T GO Urban Renewal Series 2008C 724,098
DB&T Water Rev Bond Series 2008D 612,394
Total 5, 939, 574 8.3%
CERTIFICATES OF DEPOSIT:
American Trust & Savings Bank
Dubuque Bank & Trust
East Dubuque Saving's Bank
Liberty Bank
Premier Bank
State Central
US Bank
Tofa/
PORT OF DUBUQUE PARKING RAMP
Capitalized Interest Fund EDSB (Bona Prooeeds) ~o2s
Project Construction Fund US Bank (Bond Prooeeds) io2s
North Fagade EDSB (Bond Prooeeds) Soso
Debt SeNICe Reserve U. S. Treasury Obligations (Bond Proceeds)
Tofa/
CORPORATE STOCK (Lyons Peony Trust)
TOTAL OTHER FUNDS
TOTAL CITY FUNDS
14, 000, 000
6, 000, 000
2, 000, 000
5, 000, 000
1, 000, 000
1, 000, 000
0
29, 000, 000 40.4%
1, 868,195 2.6%
2, 090,114 2.9%
735,518 1.0%
2, 015,125 2.8%
6, 708, 952 9.3%
11,514 0.0%
46,427,920 64.7%
71,817,048 100.0%
Page 2
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
March 31, 2009
TOTAL
COST CITY FUNDS
OTHER FUNDS BASIS PERCENTAGE
CASH
Change and Petty Cash Funds 11,337
Prescriptions & Workers Comp Deposits 85,000
Total 96, 337 0.1
CHECKING /SAVINGS ACCOUNTS:
American Trust & Savings Bank (cenera~ a Fieaitn) 213,535
American Trust & Savings Bank (Housing Renab ~ seotion s) 227,503
Dubuque Bank & Trust (GenerauMetro/Leisure} 3,934,145
Dubuque Bank & Trust (commv~nd Bidg Renab a, Econ rev) 94,697
DUbUgUe Bank & TrUSt (Cable Franchise Equipment Fund) 165,992
US Bank (GeneraVAmbulance) 19,297
Premier (ut~iity) 3,232
Liberty (utility) 4,981
East Dubuque Savings Bank (utility) 4,456
State Central (Utility) 3,705
First Bank - Petoata 0
Total 4, 671, 543 6.5%
BOND PROCEEDS:
US Bank (Sanitary Sewer Bond Proceeds) 405,947
DB&T GO Stormwater Series 2008A 1,266,081
DB&T GO Urban Renewal Series 20086 2,931,054
DB&T GO Urban Renewal Series 2008C 724,098
DB&T Water Rev Bond Series 2008D 612,394
Total 5,939,574 8.3%
CERTIFICATES OF DEPOSIT:
American Trust & Savings Bank
Dubuque Bank & Trust
East Dubuque Savings Bank
Liberty Bank
Premier Bank
State Central
US Bank
Total
PORT OF DUBUQUE PARKING RAMP
Capitalized Interest Fund EDSB (Bond Prooeeds) Roza
Project Construction Fund US Bank (Bond Prooeeds) ~ozs
North Fagade EDSB (Bond Prooeeds) Soso
Debt Service Reserve u.s. treasury obligations (Bond Proceeds)
Total
CORPORATE STOCK (Lyons Peony Trust)
TOTAL OTHER FUNDS
TOTAL CITY FUNDS
14,000,000
6, 000, 000
2, 000, 000
5, 000, 000
1, 000, 000
1, 000, 000
0
29, 000, 000 40.4%
1, 868,195 2.6%
2, 090,114 2.9%
735, 518 1.0%
2, 015,125 2.8%
6, 708, 952 9.3%
11,514 0.0%
46,427,920 64.7%
71,817,048 100.0%
Page 2
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
March 31, 2009
RECAP OF PORTFOLIO PERCENTAGES Managed City Combined
CASH 1.5% 0.13% 1.63%
CHECKING !SAVINGS ACCTS 0.0% 21.30% 21.30%
MUNICIPAL BONDS 0.0% 0.00% 0.00%
MUTUAL FUNDS (U.S. GOVERNMENT) 1.4% 0.00% 1.41%
MORTGAGE BACKED SECURITIES 7.6% 0.00% 7.60%
CERTIFICATES OF DEPOSIT 0.0% 40.38% 40.38%
U.S. TREASURY OBLIGATIONS 0.5% 2.81% 3.32%
FEDERAL AGENCY OBLIGATIONS 24.3% 0.00% 24.33%
CORPORATE STOCK 0.0% 0.02% 0.02%
Total 35.4% 64.6% 100.0%
Page 3
CITY OF DUBUQUE
MONTHLY INVESTMENT SUMMARY
CO 1~ N O O N M~ In O n M a0 N Q M C
N X0000 0 Of~M O t~ IA M l0 N C
~ ~COOO O to O00 O h O O ~[) O C
p~ ~ O N 00 M Q h O V7 O Q 00 O a
p 0)
C Il) N Q O M B CO N N O O V
~ d~ W M O
O 0 .M...N.. V7 N V7 n Q h C
0`l E F ~ ~- N Q Ov a0 O N~
M
° p
U
~
~
n
n
n
M M M
~ N r` N N n M O N a
'a O O N N O 00 O O O M It) C
C C Q N N v N ~ N ~ M 0
~
W C a
0 0
0
L
LL N
M O
N O
N M
N In
N h
N ~
O W C
00 C
~ _ 0 ~ O (O Q O 00 C
~ U v v v v v
O OtnOO N 07~ O N N N M OI`
Q 0 00 0 0 h 0 r` O Q a0 c0 r• O ~
'O y
d o 00
0 N O O O
uim Q
Q V7 0
MQ O U7
ao 1~ n
n N C
M
~~
V7
O
O
O M
M ~ ~
O ~
N
A O ~ N ~ Q .M
i .N
. ~ 0 0 V M q
I .
. 0
0 0
0
~ Q N
W M
N M
V7 M
V7 M e
V7
N N N N N
W 00 ~ 00 00 M M V7 O C
In N O M 00 O O O O O C
~ ° C `r Q
o o rn ~ ~ c v c
o i
u
m r
lA 0
M 00
M 00 00 M
a0 M
00 IA
a0 IA
00 U
~ n ~ ~ ~ ro roa
~ ~ ~ ~ ~
Q ~ w
^ N ~ ~ ~ ~ ~ m u
~ r
i a
o
~ C Q O N O N N M M f0 N~
W~ ~~ N V N N v Q O O ~ ~
`
Li £F ^ Qv Q c
o c
o ~ Q
^ ^ O
Or
7Z U o 0 0 0 0
ri ri ci c~ ri
~ ~
~~ M N N
LL h N
C9 O
O O
GO
O 0
V7
n
h O)
h O ~
O a
O~ O M M l17 t0 N N N 00 Q C
F O 0n O MIA 0 M M Q O
Z
a6
O M
N
O O
V7
O
O
Q e
W
~ 0 .
. V M M Q
U J Q
O 0 O . r ~ p
O p
~
S
=
F M 00 00 M 00
~ O O 0
~ In l
0 ~ M a
0 a
0 ~ ~ 0
0 ~
N O O Q
C O N O a
0 a
0 ~ ~ N Y
of
~ O .ln..
N
N .~-. V7 O O N n 0
M M f`O') M R O
O O O O O
y y
C
O C
O
e e
h N
Q, v,
0 0
a o
r O
l+l OD
r O
o e
n OD
ID r
O N
e e
OD n
~ r`
O N
d a e v a v a
~
07 ~ b Of N aD aa 10
O Of C! O b N
~«
C
N O O O O O M
is m w
Q
U } M
c o
y
N y
L a e e e e
O b N OI O ~
h
~
J
N
C O Of Cf OI '7
N 00 M t0 0 G
m`
0
07 ~ r ,~ ~
~ N
~ ~
Q
y e o e a o
l
9 y
J L b Of N O et
O W M O 10
O) 0 0 0 0 0 0
CA O
07
> M
Q
~
Q ~
2
~
3
~
0 O
F to °
Vl
~
F
~
~ o
'"
~
L ~
a
c 0
y
y
C
Q L
C G
~ y ~ ~
o N
y y 'O C
C O O
Z 0)
E
Q O
~ la E y0), ~ O m m
m
d
~ p C `
~ ~ m N
-'~ ~ ~ ~
5 0 ~ c °'
~ ~ o Q
~ a
0
° ° C7 `°
m t y
0 O
A
O ~
7 a !
~ ~
t0 y ~ la U 0)
d E
~p N
( L
C m
N y ~
~ ~ m ~~
« ~ 07 ~ m
~ Ol d
N
7
~ O
J
m
C
N
~ >
W >
W U 7
~ C y
L
-
~ L « 7 C
V y .
-.
C j
~ ` ~.
0) ~ Q Y ` N~ N m
F Q (!~ C C `)
O C
E N
O LL m y
ro ~
O v
y
m ~ ~ ~ d Q ``
U
~ c c c o~
fa A o C
) U
y R
W~ 0) C LL
L
C y C l0 ~ V R
' y ~ ~ d d
C~ 3 C
V d ~
.
~ r
• ..
y 'O
m N
D
w
O E la L ~
g N y
~
N
O
C
~
C - N
~ O~ 3
Q' K
O a f L L
O 07 0) 0)
0 J J J
m O
y m a O y ~_
7 C n m U OI
C N N O
••
o
a ~~ l
a
U la
N N
~ ~UmU
c d
z
~
> O Y
U
> `m
a `~
-
~ ~ r
o
°~~
v a vi v w 5 ~
~ a
City of Dubuque
Schedule of Certifiacte of Deposit
As of
March 31, 2009