Investment Report, Qtrly
DU~%duE
~Yk.~
MEMORANDUM
August 1, 2006
TO:
FROM:
The Honorable Mayor and City Council Members
Michael C. Van Milligen, City Manager
SUBJECT: June 30, 2006 Quarterly Investment Report
Finance Director Ken TeKippe is transmitting the attached June 30, 2006 Quarterly
Investment Report.
AJ l{0,!V ~
Michael C. Van Milligen
MCVM/jh
Attachment
cc: Barry Lindahl, Corporation Counsel
Cindy Steinhauser, Assistant City Manager
Kenneth J. TeKippe, Finance Director
'')
D~~%&uE
~ck~
Memorandum
RE:
Michael C. Van Milligen, City Manager .
Kenneth J. TeKippe, Finance Director 1.~J - c:;~
June 30, 2006 Quarterly Investment Report
TO:
FROM:
DATE:
August 1,2006
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 April 1, 2006 through June 30, 2006.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended June 30, 2006 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 June 30, 2006 & Fiscal 2006 YTD
Market Value / Unrealized
Carrying Including Gain (Loss) /
Description Value Accrued Interest Accrued Interest
Deposits, Change & Petty Cash Funds 88,925 88,925
Checking/Savings Accounts 8,547,601 8,547,601
Certificates Of Deposit 26,200,000 26,544,696 344,696
US Treasury Securities
Corporate Stock 11,514 66,720 55,206
Investment Advisor Accounts 22,383,095 22,239,918 (143,177)
Total Funds 57,231,135 57,487,860 256,725
Breakdown
City
Metro
Total Combined Funds
22,480,963.70
8,827,482.00
31,308,445.70
48,512,217.00
8,975,643.00
57,487,860.00
26,031,253
148,161
26,179,414
Cash Basis Quarter Year-To-Date
Gross Earninas:
City 408,666 1,633,742
Metro 74,196 300,955
Combined 482,862 1,934,697
Investment Fees:
City (43,718) (152,635)
Metro (239) (691)
Combined (43,957) (153,326)
Net Earninas:
City 364,948 1 ,481 ,107
Metro 73,957 300,264
Combined 438,905 1,781,371
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
June 30, 2006
FY06
MANAGED FUNDS
PORTFOLIO TOTAL
COMPOSITION COST CITY FUNDS
PERCENTAGE BASIS PERCENTAGE
DANA INVESTMENT ADVISORS, INC.:
Cash 4.42% 251.408
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 95.58% 5,441,628
Total 100.00% 5,693,036 9.95%
DUBUQUE BANK & TRUST:
Cash 7.42% 510,825
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 92.58% 6,375,067
Total 100.00% 6,885,892 12.04%
FIRST COMMUNITY TRUST:
Cash 2.23% 62,000
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 97.77% 2,719,081
Total 100.00% 2,781,081 4.86%
US BANK:
Cash 2.30% 161,258
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 7.12% 500,289
Federal Agency Obligations 90.58% 6,361,539
Total 100.00% 7,023,086 12.28%
GRAND TOTAL 22,383,095 39.12%
BREAKDOWN BY TYPE OF SECURITY:
Cash
Mutual Funds (US Government)
Certificates Of Deposit
US Treasury Obligations
Federal Agency Obligations
TOTAL MANAGED FUNDS
4.40%
0.00%
0.00%
2.24%
93.36%
100.00%
985,491
o
o
500,289
20,897,315
22,383,095
1.72%
0.00%
0.00%
0.87%
36.53%
39.12%
Pagel
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
June 30, 2006
CASH
Change and Petty Cash Funds
Prescriptions & Workers Camp Deposits
COST
BASIS
FY06
TOTAL
CITY FUNDS
PERCENTAGE
OTHER FUNDS
Total
8,925
80,000
88,925
0.16%
CHECKING / SAVINGS ACCOUNTS:
American Trust & Savings Bank (General & Hea~h)
American Trust & Savings Bank ( Stormwater Bonds)
American Trust & Savings Bank (America's River Bonds)
American Trust & Savings Bank (Housing Rehab & Section 8)
Dubuque Bank & Trust (General/Metro/Leisure)
Dubuque Bank & Trust (DICW Bonds)
Dubuque Bank & Trust (Comml/lnd Bldg Rehab & Econ Dev)
Dubuque Bank & Trust (Cable Franchise Equipment Fund)
US Bank (General/Ambulance)
Premier (Utility)
Liberty (Utility)
East Dubuque Savings Bank (Stormwater Bonds)
East Dubuque Savings Bank (Parking Bonds)
East Dubuque Savings Bank (Utility)
State Central (Utility)
Total
718,085
330,134
620,964
180,468
1,423,699
1,186,475
44,414
199,630
32,797
22,820
25,568
2,900,000
717,961
124,041
2,544
8,529,601
14.91%
CERTIFICATES OF DEPOSIT:
American Trust & Savings Bank
Dubuque Bank & Trust
Dupaco Community Credit Union
East Dubuque Savings Bank
Liberty Bank
Premier Bank
State Central
US Bank
17,200,000
6,000,000
3,000,000
Total
26,200,000 45.79%
0.00%
11,514 0.02%
34,830,040 60,88%
57,213,135 100,00%
MANAGED FUNDS OTHER FUNDS COMBINED TOTAL
1.72% 0.16% 1.88%
0.00% 14.91% 14.91%
0.00% 0.00% 0.00%
0.00% 45.79% 45.79%
0.87% 0.00% 0.87%
36.53% 0.00% 36.53%
0.00% 0.02% 0.02%
39.12% 60.88% 100.00%
U,S, TREASURY OBLIGATIONS
CORPORATE STOCK (Lyons Peony Trust)
TOTAL OTHER FUNDS
TOTAL CITY FUNDS
IRECAP OF PORTFOLIO PERCENTAGES
CASH
CHECKING / SAVINGS ACCTS
MUTUAL FUNDS (U.S. GOVERNMENT)
CERTIFICATES OF DEPOSIT
US. TREASURY OBLIGATIONS
FEDERAL AGENCY OBLIGATIONS
CORPORATE STOCK
Total
~
<C
:;
:;
w::>
::>en
a....
::>z
mW
::>:;
0....
...en
o~
~~
->
u-,
:I:
....
Z
o
:;
<Xl
o
c;
..,
;;;
o
"
ID
~ ~I
o
u
I
"
c
.
<0
en
::J
il
~I
'"
~
...J
~
q;
'"
OJ
q;
!Xl
....
'"
o
u
N
N
<ri
N
'"
oi
<;;
en
'"
Nt::'OI,()
... ON
~go~
"'N 0
I!)- (0- (j)-
"'''" '"
"'-
O~aJON
OC'1lJ")OO':!
o...rr....:o
00
N'"
ct:t
;;
o
'"
~
;;;
0'<
0'"
o'<i
o
N
!i
""
o
~
'"
N
'"
giB
ogj
~
00
'"
'"
o
...
::::
~
;;
~
00
'"
'"
!if
::::
8~
o~
o
N
!i
iO
o
en
o
~
iO
'"
N
N
:!.
;;;
oi
~
M
'"
oj
'"
!!l-
w
c
o
'15
.
"
-0
~
en
]
o
....
'"
'"
N
'"
""
.0
'"
'"
ai
'"
'"
'"
'"
'"
'"
N
'"
N
'"
'"
'"
'"
'"
'"
o
oi
'"
'"
N
N
'"
'"
<ri
'"
o
oi
N
o
'"
'"
'"
o
'"
0,
'"
""
N
'"
'"
0;
'"
.0
'"
'"
<D
'"
""
<ri
'"
o
oi
'"
'"
.0
5
c
o
:;
C
~
~
~
u
w
;;
.
m
-
w
o
U
iO
o
oj
'"
'"
...
'"
...
!i
iO
o
oj
'"
'"
...
'"
...
!i
$'
c
ID
E
ID
W
5
-0
W
e.
.,
.I!l
"-
.~
U
ID
<to
L
W
.
U
Q;
Z
o
'"
'"
'"
~.
;;;
N
,..:
'"
...
'"
ai
'"
o
",'
...
'"
...
'"
'"
'"
'"
'"
o
oi
'"
'"
N
N
'"
'"
<ri
'"
o
oi
N
o
,..:
'"
'"
o
'"
o.
<Xi
""
N
'"
'"
0;
'"
.0
:?l
<D
'"
""
<ri
'"
o
oi
'"
'"
.0
~
u
C
.
rn
m
w
';;;
..
m
-
~
o
U
'"
c
;;
c
W
~
~
...J
~
q;
~
...J
~
....
i:!
It
:l!
L
C
o
:;
'"
o
'"
'"
,..:
...
""
en
'"
N~~
cOC'\io
0"''''
"'N'"
N-I,()-r-:
"'''''''
"'......
(!)- ......-
'" '"
?t~
~~
d~
~ft.
"" 0
0""
co
ft.';/!.
~ '"
"'<Xl
eo
~~
~~
o~
i
.
>
ij
~
~
E
~
D
o
~
~
.!.
'"
o
o
N
$
..
o
.s
~
~
~
"
c
~ ID
E c -u"
~ 5
Q; Q) E
0:::0:::2
.2 ~~
0-5-
t= 5 ~
~~1-
~
u
'6
S
';;
'l!
~
:!e.r;.';t.';!.:!e.';!.
.2:!a,f7JllO"",c=.,'I)
rorn.....COOOMN
-CONe~ONcci
;.s
rn~
o ~
>
1;; w
.5,s
~ c
",0
~:;
~N
>~
<(
~';t..;.~.;.
:OfDr--.~M
cn~CC!ClM
M~""C"
!Ii
.
2
u
u
.
.
,
c.
.
,
"
>
0;
~
~ :;
.. . :;
:; ~ .~
:8.2 ~
-...: .~ >
o 0. c
~ ~ .g
.B! E ~
III ~.~
!.tlt:.J
: :
0.
c
;;
c
W
5
c
o
:;
" w
~-
mC
. ~
c 0
.. u
::E~
""
." -I
~ ~ ~
U:E~
o
o
'"
'"
'"
'"
'"
.0
o
~
,..:
'"
;;
o
'"
'":
;;;
'"
'"
;:::
'"
,..:
o
...
N
N
a;~8~
r;;go~
~N 0
"'<t-<!)- 0.1-
tnf'-. ~
::.
""
~
;:::
""
o
'"
'"
<D
OM
""'"
~~
'"
N
'"
""
""
<ri
N
N
o
'"
""
N
fil~
gFj
<D_e
N
'"
N
'"
",F:'
"''''
to..,r
~C;;
""-N
""""
'":
;;;
'"
to
'"
o
N
...
N
.0
""
'"
.0
"'M
N'"
crier)
~~
....:("')-
N-
L
-
c
o
:;
~
o
."
Q.
~
.;;;
..
m
-
~
o
U
00-
ID
W
W
o
-'
~-~
.5 ~ 'ii)
E "(ij ~
.. (!J ~
;,;UJ-cO
c tl ~
~~=]j
;; .2:l ~ 'g.
"C..Ec:::o
<(
'"
""
~
N.
N
8:2
ON
N
:!.
a;-
...
<ri
N
'"
...
e.
8;;;
ocr>
~
o
'"
N
'"
'"
oci
813
cieri
'"
!!l-
w
c
o
.,
'5
::i!
]
o
....
w
W rn
ID ~
ID W ..
U. Q) (/) ....
:.: 'E,~ Ql::g
... ID..... Ol;p
a ~ .~ ~ ~
~ ~E ~ ~
b~~aig.
.g::20mo
en
~
o
'i:
Q.
~
iu;-
>rn
1i 2
~s
..<C
:; ~
_.2
lii."
E J!l
- ~
~ ~
~:s
.=5.
'"
'"
M
N
'"
N
N
'"
,..:
'"
0......
N ~'"
r.OWN
..."'...
N"''''
ri~r--:
0......
"''''N
'<;f- tri
'" '"
N
'"
<ri
'"
'"
...
N
N
N
N
o~~
N<ricO
"''''~
"'''''''
ai 0" m-
"'''''''
o ~N
N N
N N
;:::
'"
'"
'"
N
'"
'"
<D
~~o
c;;~~
"'''''''
6 (!ic.o-
"'''''''
'" '"
<<) (0-
N
o
'"
'"
oci
'"
'"
N
lO~~
mN""':
N"''''
~"''''
6l!}-tri
"'~O
'" ""
N N
'"
...
o
<;;
,..:
8
,..:
N"''''
"'N
cairn
"''''''"
"''''N
N-m-f\i
......'"
'" '"
W <<)
N
oj
'"
'"
.0
'"
'"
.0
comB
mr--:r--:
~"'O
00
U) cri Ll'i
~N'"
'" '"
l!) Il'l
L
C
o
:;
~
rn
C 2
~.:;o
~ C U
~ 0 <C
u:;
~~
~ C
Ci ~
> 5
';;0
~1;)
.. 2'
:; ID
_1"
c
~
S
~
~
>
.=
~
o
~
."
J!l
~
~
;;'
<(
~
~
rn
1l>
2 ~
u""
u ~
<(~
1;) ~~~~~
ro(Jl~N~b:-
..J-S....o(Q("),....
~a ooo~
~::E
~'"
<(
tJl 1Il..@
.,,"c
C c 0
o 0 <0
CD CD .x
~~~~~
~<3(!)(!)-cr:
~ !l! ~ ~ ~ Q)
I- (ij t: .~ .~ E
>-Ol~"'Ol:L~
8 ~ t:: E 4i c
g9,g$5~
...... (I) C III :;
; c ~ :5 ()
E ro ro U
LEE
~LL
..J.5.3
~
III
o
c..
CIl
o
....
CIl 0
~ III
C"CIl
~ ....
.0 lU
::J~'O
0._ fJl
....t<
o CIl
>,0
~14-
o 0
CIl
~
"C
CIl
..c:
o
en
M IJ") t'-- 0..-
t--:t--:~~~
"C MLO.......Or-
<u M(Ol.()CO......
::J tn LO_"'lt_Ol_'I"""""-
""eMC>>NVm
~Q)NNN'I""""
<C~
-
"
.,
"
...
U
U
<
-
o >- <D
-:!::
fJl ...
>-.E!
co co
0::;:
-
r--
r--
fJl~
>-
co
o
mNomNN
~~~"':~~
M..q(o"<;f"LOM
CO...... COIJ") ("') 0
1.0_ IJ")_ CO_ 00_ m_ ......
COr--LONON
..- N.........- N......
oOOMO
or:"-~~
......e>>o>CO
Qa:lQlO
"l:I"_...... ......l.()
<00:10(0
~ ~
<DO
~~
00
'" ...
00_ 0::>_
'" ...
~ ~
r--
'"
co
...
"!.
M
Q..-IDNoomCONID"'l;t
~~~~~""'''-~lX:!:'''''
O..-OCOI.OOCDcom(O
N......"I;tN"'lt..................om
..- '''It_ CD_ M_ N.. r-_ M_ M_ N_ CO_
ocomcnCOCDLO"'lt......V
~ ...
M
."
OlLOOlLOO......"'I:tNLO(O"'lt..-......LOMIDN..-LOt'--"'I:tt'--(O(OC>>co
Mr-......wN............mLOCOVVt'--v......ONr-CO(O(OLOVMN
N......N ......N.,.......... ..- ...-......
0000
_ 0000
(1)(1)0000
o 'Vi cicicici
0",0000
m 0_0_0_1.0
~ ~ ~
~
~
(l)
o
-
o
M
-
(l)
o
--(0(0(0(0(0(0(0(0(0(0(0(0(0(0(0(0(0
~QQQQQQQQQQQQQQQQ
IDMOOr-..-r-"'I:tCOLONIDNCO..-OO
e~~ ~e~~e~~ee~~~
r-r-r- oommmooo..-........................
000 aoco ........-..............-
MO......OONC>>(OOt'--"'I:tCOLO......"'I:tMMOOr-VCOLONIDMQ
......Nvv(Owr-mmO......NMvLOLO(O(O(Ot'--comO..-NM
................................-........-....................-..-NNNN
~ ~
- -
co co
00
~ ~ ~
tn ~~~~~~~~~~~~~~~~~~~~~~~~~~~
e~~g~~~~~ggg~~~~~~~~~g~~g~~~~
!~COLO~~..-~~~..-m......Mm..-~............MN..-NMNM~~LO
= v~vv~~~~~~~~v~~~~~~~~~~~~~~
>-
-
'i:: .!!
" co
"0
::;:
-
~ ID~ID~IDID~IDIDIDIDIDIDIDIDIDIDIDIDIDIDIDIDIDIDIDID
~.!!~~~~~~~~~~~~~~~~~~~~~~~~~~~
umooo~~oONOM~O~O~~O~ONONNO~NON
~C---~~- --~---~-------------
~ ~~~~vM MM~v~Nv~MMIDvvvv~~~IDID
~ O~O~OO~OOOOOOOOOOOOOOOOOOOO
-
-
-
l:
o
:g
-
:;:::
fJl
l:
-
<D <D
~~
00
NN
IDID....................................
QQQQQQQQ
v..-v.....oo~oo~
~Ne~~ee~
NN..-..-..-NNN
..-..-000000
~ ~
000000000000000000000000
000000000000000000000000
000000000000000000000000
000000000000000000000000
000000000000000000000000
qqqqoooqqooqqqq......OOOOOOON
..-..-..-..-..-..-..-..-..-..-..-~~..-..... ~~~~~~~~
N
."
~
~
~
~
~
~
~
~
~
...
wwmwwmwwwwmww~wwww
~~wo~~wo~~~~wo~~~~~~~
~~ ~~ ~~~~ ~~...~~~~
~~w<~w<~<~w~<~~~~~
~
~
~
~
~
.,
- ...
co .,
U,Q
i;:EM
:e,,~
"2M
u
M <D
~ 0 co
~ r-- 0
co r-- '"
~ M ~
..-..-..- ..-
... ...
'E!!1 w m w w m w .!!1 w
~w~~w~~~
~~o~~o~...~
~<w~<w<~~
fJl
ID IDIDO..- ID~Mm"""~mvo NM ..-~~~
vmOOOMvmoo~m......OOMIDmN......~mOOONv~
OO~N..-N..-mm..-..-m..-Mo.....m..-OOOOIDO~..-c
~~~~~~~~~~oo~oom~~~~~~~~~~
..-..-..-.......-..-~..........v v..-..-..-...............v.....
............... .....
............... .....
'#. ""
.., r--
~ .n
.n ~
"
a;
:;:
"
.,
-
.<::
Cl
~
fJl
>-
co
o
,!:
>-
-
'I:
"
-
co
::;:
"
.,
- >-
.<:: ()
Clz
~ ~
w
I-
fJl
~
Cl
:J
o
<f)
<(
W
lY
<(
Z
;::
:J
o
Q.
o
lY
I-
w
::;;
w
::J
o
::J
""
::J
Cl
"
~