Quarterly Investment Report June 30, 2009THE CITY OF Dubuque
~T TR ~ AlhAna;dcaCity
~.J l.J
Masterpiece on the Mississippi
2007
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: June 30, 2009 Quarterly Investment Report
DATE: July 29, 2009
Finance Director Ken TeKippe is transmitting the attached June 30, 2009 Quarterly
Investment Report.
Y
Michael C. Van Milligen
MCVM:jh
Attachment
cc: Barry Lindahl, City Attorney
Cindy Steinhauser, Assistant City Manager
Kenneth J. TeKippe, Finance Director
THE CTTY OF
DUS E
Masterpiece on the Mississippi
TO: Michael C. Van Milligen, City Manager
FROM: Kenneth J. TeKippe, Finance Director -
RE: June 30, 2009 Quarterly Investment Report
DATE: July 21, 2009
INTRODUCTION
Dubuque
AAA-AmerlcaCfty
1
2007
~~
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 April 1, 2009 through June 30, 2009.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended June 30, 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 June 30, 2009 & Fiscal 2009 YTD
Market Value / Unrealized
Carrying Including Gain (Loss) /
Description Value Accrued Interest Accrued Interest
Deposits, Change & Petty Cash Funds 97,012 97,012 -
Checking/Savings Accounts 12,243,716 12,243,716 -
Certificates Of Deposit 29,550,000 29,637,634 87,634
US Treasury Securities 2,015,125 2,210,157 195,032
Corporate Stock 11,514 57,412 45,898
Investment Advisor Accounts 25,618,398 25,793,903 175,505
Total Funds 69,535,765 70,039,834 504,069
Breakdown
City
Metro
Total Combined Funds
Cash Basis
Gross Earnings:
City
Metro
Combined
Investment Fees:
City
Metro
Combined
Net Earnings:
City
Metro
Combined
71, 215, 650 71, 563,146 347, 496
11, 028, 872 11, 063, 799 34, 927
69,535,765 70,039,834 382,423
Quarter Year-To-Date
612, 308
106,419 2, 710,101
435,552
718,727 3,145,653
(34,646}
(100) (138,904)
(515)
(34,746) (139,419)
577, 662
106,319 2, 571,197
435,037
683, 981 3, 006, 234
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
June 30, 2009
MANAGED FUNDS
DANA INVESTMENT ADVISORS, INC:
Cash and Equivalents
US Treasury Obligations
US Agencies
Mortgaged Backed Securities
Municipal Bonds
DUBUQUE BANK 8 TRUST:
Cash and Equivalents
US Treasury Obligations
US Agencies
Mortgaged Backed Securities
Municipal Bonds
Mutual Funds
FIRST COMMUNITY TRUST:
Cash and Equivalents
US Treasury Obligations
US Agencies
Mortgaged Backed Securities
Municipal Bonds
US BANK:
Cash and Equivalents
US Treasury Obligations
US Agencies
Mortgaged Backed Securities
Municipal Bonds
Total
Total
Total
Total
BREAKDOWN BY TYPE OF SECURITY:
Cash
Municipal Bonds
Mortgage Backed Securities
Mutual Funds
US Treasury Obligations
US Agency Obligations
GRAND TOTAL
TOTAL MANAGED FUNDS
PORTFOLIO TOTAL
COMPOSITION COST CITY FUNDS
PERCENTAGE BASIS PERCENTAGE
2.294% 147, 952
0.000% 0
97.706% 6, 301,674
0.000% 0
0.000% 0
100.000% 6,449,626 9.3%
2.608% 215, 036
29.791% 2,456,790
28.806% 2, 375, 589
13.434% 1,107,871
10.074% 830, 775
15.287% 1,260,655
100.000% 8,246,716 11.9%
4.751 % 147, 565
0.000% 0
28.899% 897,638
66.351 % 2, 060, 947
0.000% 0
100.000% 3,106,150 4.5%
3.795% 296, 590
2.569% 200, 781
62.985% 4,922,836
30.652% 2,395,698
0.000% 0
100.000% 7,815,906 11.2%
25,618,398 36.9%
3.150% 807,144 1.2%
3.240% 830, 775 1.2%
21.720% 5,564,516 8.0%
4.920% 1,260,655 1.8%
10.370% 2,657,571 3.8%
56.590% 14,497,737 20.8%
100.000% 25,618,398 36.8%
Page 1
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
June 30, 2009
OTHER FUNDS
CASH
Change and Petty Cash Funds
Prescriptions & Workers Comp Deposits
CHECKING /SAVINGS ACCOUNTS:
American Trust & Savings Bank (General & Healtn)
American Trust & Savings Bank (Housing Rehab a section s>
Dubuque Bank & TfUSt (GeneraVMetro/t_eisure)
DUbUgUe Bank & TfUSt (CommUlnd Bldg Rehab & Econ Dev)
DUbUgUe Bank 8c TfUSt (Cable Franchise Equipment Fund)
US Bank (General/Ambulance)
Premier (ut~l~ty)
Liberty (utility)
East Dubuque Savings Bank (utility)
State Central (utility)
BBVA Compass
BOND PROCEEDS:
US Bank (Sanitary Sewer Bond Proceeds)
DB&T GO Stormwater Series 2008A
DB&T GO Urban Renewal Series 20086
DB&T GO Urban Renewal Series 2008C
DB&T Water Rev Bond Series 2008D
CERTIFICATES OF DEPOSIT:
American Trust & Savings Bank
Dubuque Bank & Trust
East Dubuque Savings Bank
Liberty Bank
Premier Bank
State Central
Total
Total
Total
Total
PORT OF DUBUQUE PARKING RAMP
Project Construction Fund US Bank (Bond Proceeds) ions
Capitalized Interest Fund EDSB (Bond Proceeds) Roza
Debt Service Reserve u.s. Treasury obligations (Bond Proceeds)
Tota!
CORPORATE STOCK (tyouns Peony Trust)
TOTAL OTHER FUNDS
TOTAL CITY FUNDS
COST
BASIS
12,012
85, 000
97, 012
TOTAL
CITY FUNDS
PERCENTAGE
0.1%
191,872
172, 011
4,148,533
98, 848
332, 873
212, 442
5, 505
8, 536
9, 920
3,858
14, 682
5,199, 080
304,468
807,628
1, 406, 712
655,167
523, 596
3, 697, 571
9, 750, 000
11, 000, 000
2, 000, 000
5, 800, 000
0
1, 000, 000
29, 550, 000
1, 256, 088
2, 090, 977
2, 015,125
5, 362,190
11,514
7.5%
5.3%
42.5%
1.8%
3.0%
2.9%
7.7%
0.0%
43,917,367 63.2%
69, 535,764 100.0%
Page 2
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
June 30, 2009
RECAP OF PORTFOLIO PERCENTAGES Managed City Combined
CASH 1.2% 0.1 % 1.3%
CHECKING /SAVINGS ACCTS 0.0% 17.6% 17.6%
MUNICIPAL BONDS 1.2% 0.0% 1.2%
MUTUAL FUNDS (U.S. GOVERNMENT) 1.8% 0.0% 1.8%
MORTGAGE BACKED SECURITIES 8.0% 0.0% 8.0%
CERTIFICATES OF DEPOSIT 0.0% 42.5% 42.5%
U.S. TREASURY OBLIGATIONS 3.8% 2.9% 6.7%
FEDERAL AGENCY OBLIGATIONS 20.8% 0.0% 20.8%
CORPORATE STOCK 0.0% 0.0% 0.0%
Total 36.8% 63.2°k 100.0°~
Page 3
r N r 0 0
~ N tnMOO
p ^ V
~
N f
0 q)
M ~ H N
~ N
~ U ~
CI M I~
C M ~
~
C O
W
C q) N
t lL
C
O _
U
~
~
O
c0 Or
C
N C~O
m
~ 7 n
n W
r W
M
C U
07 U
~ f~ N
q) N
I
N
M ~ V
N IA h
0
~
c h 0
0
I
ql O q)
M O ~
O W
n
}
O ~
Q V M
~ R
~ M N
= ~ f~ O N
y
7 LL ~ ~
F a) r
~ ~
-
0
Z ~j ai
0 ~
Q W ~ ~' q)
~ ? °~ 0 N q)
U ~ m i
= o rn q
yr
H ~
Z
O
~ M M
CO ~ M
l0 ~ N
c V O N
O7
0
N
~
q)
M M
O
RO ~ W
f
7 M N ~ N
~O O
R Nq) 0 N O O M C
N O M B IA 7 q) h ~ e
M ~~~ ~ M
M M M
N l
0
M q) f
Q
lA
r V C
~ ('
~ C m m O
c
o
^
° ° ° rn ~
u
i
v v ~
n in o a
00 q) d] N In ~ M ~
N M ~ M
N O f
0 V
~ ^
N `-' 11
M
I~ q)
01 ~
M N C
'
n C v n v
~
n MMOO n M f00
q) q) O
O
0 0 ~ ~
O N q) 0
0 O 0 N t
O O M M M M O q
O
M
N lf) q) Q) ~ q) ~
.
.. .
.. q) q) h q) ~
M N M ~
N N N N
~~
~
h l
O M q) O n N O
O M M N N n V
~
~ c
N
q) .0
. q) N ~
_
O IA M N q)
q) q) ~ 0^D r
n ~ n n
O N N O O O
1
f1 n M
V
~ ~
o m v
~ o o
o nd
_ _ _ 0
M M M M
O
M n n n O
f
7 1
A M n
N ~ l17 V (~
h
q) q) ~
R O fv f0 h f~ N 0 6
~ ~ M v v
ii o ~
N N N N
ro ai ai ai
~
In ~ V ~7 h N q;
0 N N q) q) N N q:
q) 0 0 N N
M
h 10 N W q) q
7 ~ 6.
N V ~
'R R '7
O O O q)
N N `
C
O C
O V
V
U Q
e e
W ID
O Of
O O
0 0 o e e e e o
M q) ~ tl1 OOf fO0 ~ ~ O N
0o J ~ orovmvri
m
o
m ~
j N
r 4 y
Q M
O ~
0 0 d
O1 M e e e o O
~
O ~ 0 P O Ir 1~
N r r~ h
~
O M C Y O O v 0 m~
m ~ ~
U }
e e o o ~ e
Of ~ Of r M ~
N M L r O r r
O~ y C 0 0 0 0
J O ~..
'~
Q 07
~
r0.
3
y
d
F' W
o
y y
~
~ N y '6
v ~° c
c
y F
~
Q c
o
m m
Q C ~ O m
X
Q d p ~ R °~' 01 y O O~ C d'
~
Q y ~ ` t ~ ~ ~ a m a
i E~ ~~
~
` ~ OQ a
~ a~,F a
'
m t
c ~ v
A Q
~ a U~
~ o `m
~ } ~ ~
r E ~'
i d
rn L
~ s m ~ ~ ~ c
~ d
o
y C
0
N N ~ a6 m
' R 01
W o ~ C
C 3
c
U
~
O N .J..
C N N
`~ ~ 3
LL N /y4 C
~ a
m N
R a
Q
~ d
Y W U 7
Y N~ ~` y
C N a U
~ R t
L L
•
d 'C C
W ~
d N m "O
N c LL CA
L ~ ~
r m p,
Q 10 m Q
r2 an E U
0 3 J J 0
J
N Hl w -O ~ .
_..
O E~ L~ U
N a
t O C d
C C N c
R' d' 7
ey0
m c N m
O N .N .R-. U Ol'OU
RI W O Y SR-' N
m ~
U U
O W
E d-O~
E~ ~ y
E L K
N 'O O w C
p -O Cd' U j ~UOOU p Z C >
U
>
~`a
Q 0
~ O
°~F-
v ¢ h v w ~ S
L a
~N
a
w
d 0
~ `~'~ 0
,~ V w N
O M
N
O ~ Q ~
,~ ,~,,, ~
U C ~
N
a
V
'O
2y
d
Q
2y
fQ
(~ ~
Q
>+ r3+
t9 t4
~+
N ~
L ~+
d ~
~`- ~
7 ~p
R 0
d
t ~
~ ~
a
N 'yl
O ~
U m
O (O to O O M r 0 ~A O st O N ~' O M CO 1~ I~ W In N r 00 ~ 1~ <O In O M
M N o0 00 1~ (O LA r 1~ ~ M `a' 67 (O O I~ O M ~ O O r ~ O Ln (O N N V' O
(O 1~ (p to M oO N In W~~ r r 00 O O H O O N~ O~ O~ n~~ (O
et M O~ r 0 1~ O~ 00 1n O O O Ln r r OO (p I~ O (O O M N I~ r N 0
00 M I~ M M O I~ r O O eh 0 0 00 ~' ~ N I~ N~ N~ r N 0 0 0 f~ ~~
~ O M r r~ (p r N r l(') r~ r 'ct r M M N r N r
M M O to O Lf) O 'st (O f0 r 00 00 OD 11') ~ OO M I~ O O li) (p N N r I~ M O O
N I~ r I~ f~ ~ ~ Lf) O I~ M el' O r 1~ r (O O O s}' O ~ ~ r ~ (Q ~ M N r
N r r r r r r r r
r O~ M 0 (O 1~ M e} O ~ O~ N O O (p N M O 1~ M i r lC) W M O
r N M M M ~ ~ tt to ~ l() (p 1~ f~ 1~ 1~ 00 O O O O r r N M ~ (O 1~
r r r r r r r r r
N r r O O r ~ O r O r O O r O r O r r O r O r 0 0 0 0 0 0 0
0 0 0 0 0 o O o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o O o 0
O O O t1') X 0 0 LA O~ O O O O O O O O O O~ O O N O 0 0 0 0 0
M 1~ M O 00 r 1~ ~ N~ N O 1~ r r Ln ~ M r I~ (fl Ln r 0 00 O O 00 00
eF O N (O (O -n (O P- r O O (O ~ O I~ ~ O M N ~ r 00 O I~ O ~ ~ ~ ~ ~
O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
r O~ M 0~ (O N M oO O (O 1~ M O O (O 1~ 'at O r OO to r N O N~ 0 I~
O O r N M O O r r r N N N O O r r N M O O r N N N r N r r
Ian I~I~1~ 000000000000 Op GOOOOOOOOOOOOOOrrNN
O O O O O O O O O O O O O O O O O O O O r r r r r r r r r r
a o rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn rn a> rn rn rn a~ rn rn rn rn rn rn rn rn
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O ao N CO O N E ONO M M 'cF (fl H M O to r N (O ~ 00 0 0~ 00 O r
r O r r N 0 0 0 N r r N O r O N r N N O r r r r M
~ ~ M ~ ~ N N ~! M ~ N ~ ~ M ~ M ~ M M tf ~ ~ ~ ~ ~ ~ N ~ ~ ~
rooooo000000000000000000000000
000000000000000000000000000000
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0~ o 0 0 0
r r r ~ r r r r r ~ r r r r r r r r r r r r r ~ r r r r
~ y ~ ~ ~I
M
~ N
~ N O
O ~ M
O
N
M ^
00 N t a
O
U
Q
~ O O O
C O O O
~
f9 tt
O ~
CD ~? O ~
Q O O 01
U N
7 fn
O Q
Q ~ U
rn
N
C
O
~ N
H ~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~¢a`Q~~oo~¢~oooQOQOQQO~o~wo¢¢oQ¢
d
++ L
V
~ 7
V Z
r ~ M M L() 1~ (fl f~ ~ ~' O N Ln ~ 00 LS') O ~ 00 CA
00 M 00 O O 00 00 00 00 fD O r 00 d' 00 O (O O OO 00 00 00
DD O W N N f~ 1~ 'st 0p r 1~ M OO M 00 OO r (fl 00 00 O 00
O N ~ ao O N N 00 ~A 00 N r M 'ct O ~ d' ~ ~ ~ I~ t0 00 ~ O In ~ to O ~
N~ N N N r r N N N r r~ N r N N N N N N r N M st N N 1~ N N
r 'd' r N N O O N r N In lf) st r~ r~ r r to N~ N N In r r In r r
M
~O 00
O ~
r ti
'a N
d ~
~D
~ ,c
s ~'
_Ct 'C
•~ ~
R
G
d