Qtrly Investment Report detail
D~~~E
~ck~
MEMORANDUM
January 26, 2005
TO:
The Honorable Mayor and City Council Members
FROM:
Michael C. Van Milligen, City Manager
SUBJECT: December 31,2004 Quarterly Investment Report
Finance Director Ken TeKippe is transmitting the attached December 31,2004
Quarterly Investment Report.
fYlJA LQVL
Michael C. Van Milligen '.
MCVM/jh
Attachment
cc: Barry Lindahl, Corporation Counsel
Cindy Steinhauser, Assistant City Manager
Kenneth J. TeKippe, Finance Director
.
5~~CSduE
~~~
Memorandum
TO:
FROM:
Michael C. Van Milligen, City Manager
Kenneth J. TeKippe, Finance Director
~J.(j~
RE:
December 31,2004 Quarterly Investment Report
DATE:
January 19, 2005
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 October 1,2004 through December 31,2004.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended December 31, 2004 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.
DC,,\I U:C!Tcn ^I"-Tln....
CITY OF DUBUQUE
Cash, Investments and Investment Earnings Summary
For The Quarter Ended December 31,2004 & Fiscal 2005 YTD
Market Value / Unrealized
Carrying Including Gain (Loss) /
Descri tion Value Accrued Interest Accrued Interest
Deposits, Change & Petty Cash Funds 89,881 89,881
Checking/Savings Accounts 3,984,959 3,984,959
Certificates Of Deposit 29,800,000 30,020,481 220,481
US Treasury Securities
Corporate Stock 11,522 64,123 52,601
Investment Advisor Accounts 21,400,907 21,721,717 320,810
Total Funds 55,287,269 55,881,160 593,891
Breakdown
City
Metro
Total Combined Funds
46,360,391
8,926,878
55,287,269
46,948,338
8,932,822
55,881,160
587,947
5,944
593,891
Cash Basis
Gross Earninl!:s:
City
Metro
Combined
I
Quarter
Year-To-Date I
Investment Fees:
City
300,009
25,646
325,655
C3RAR7J
558,952
43,980
602,932
{7<;Olll\
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
December 31, 2004
, FY05
MANAGED FUNDS
PORTFOLIO TOTAL
COMPOSITION COST CITY FUNDS
PERCENTAGE BASIS PERCENTAGE
DANA INVESTMENT ADVISORS, INC.:
Cash 0.71% 38,645
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 99.29% 5,435,130
Total 99.29% 5,473,775 9.90%
DUBUQUE BANK & TRUST:
Cash 5.15% 338,458
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 94.85% 6,234,364
Total 94.85% 6,572,822 11.89%
FIRST COMMUNITY TRUST:
Cash 3.01% 79,548
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 96.99% 2,565,161
Total 96.99% 2,644,709 4.78%
US BANK:
Cash 2.03% 136,045
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 1.49% 100,000
US Treasury Obligations 13.66% 916,454
Federal Agency Obligations 82.82% 5,557,103
Total 100.00% 6,709,602 12.14%
GRAND TOTAL 21,400,907 38.71%
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
December 31, 2004
FY05
-'I
OTHER FUNDS
CASH
Change and Petty Cash Funds
Prescriptions & Workers Comp Deposits
COST
BASIS
TOTAL
CITY FUNDS
PERCENTAGE
Total
9,881
80,000
89,881
0.16%
CHECKING I SAVINGS ACCOUNTS:
American Trust & Savings Bank (General & Health)
American Trust & Savings Bank (America's River G.O.Bonds)
American Trust & Savings Bank (Housing Rehab & Section 8)
American Trust & Savings Bank (America's River-Vision Iowa)
Dubuque Bank & Trust (General/Metro/Leisure/Greyhound)
Dubuque Bank & Trust (GO Bonds Stormwater Projects)
US Bank (General/Ambulance)
Premier (Utility)
Liberty (Utility)
East Dubuque Savings Bank (Utility)
State Central (Utility)
Tota/
1,525,974
1,163,053
157,172
1,005
907,455
163,066
24,408
9,383
21,241
11,183
1,019
3,984,959
7.21%
CERTIFICATES OF DEPOSIT:
American Trust & Savings Bank
Dupaco Community Credit Union
Dubuque Bank & Trust
East Dubuque Savings Bank
US Bank
Liberty Bank
Premier Bank
State Central
6,000,000
U.S. TREASURY OBLIGATIONS
CORPORATE STOCK (Lyons Peony Trust)
TOTAL OTHER FUNDS
TOTAL CITY FUNDS
I RECAP OF PORTFOLIO PERCENTAGES
4,000,000
6,000,000
7,800,000
6,000,000
Tota/ 29,800,000 53.90%
0.00%
11,522 0.02%
33,886,362 61.29%
55,287,269 100.00%
MANAGED OTHER COMBINED
FlINn.": 1=/INn.c:: Tf'lT..11
1<
<
~
~
w=>
=>IIl
g!z
lOW
=>~
0....
~f:l
~~
,,>
...I
"
!z
o
~
.,.
~
l:l
'"
~
~-I
,_ rn
.0-
E 0
0....
(j
;;,
e
'li
e
w
.0
15
o
~
~ -
.-
",e
rn 0
Iii tl
::!;<
~
~.~ ~I
iLE'::
o
(j
!
il
~I
~I
'"
j;j
'"
....
~
""
!2
...
'"
N
M
'"
..;
M
...
f,
...
'"
en
o
'"
oj
:;
'"
M
o
...
N
'"
"'.
N
M.
~
N
N
.,.
.,;
o
M.
;::
'"
<si
...
'"
<0
~
'"
M
'"
oj
N
...
6
.,.
.,.
<si
~
",'
'"
'"
en
N
M
oj
'"
.,.
.0
O'l:;;'o",
lJ"}OOl()
C\ir--:cilli
...'" 0
"'''' 0
~-~ r;J
~
'"
'"
;;;
'"
M
(,,)~OO'l
iXlOO",""
0"": 0 rt:i
M'" '"
.,.'" .,.
~.~ ;;-
1J"l00 t--
...~ '"
ccid cci
o~ '"
"'- '"
ro" as
M M
.,.~
NM
&ri~
"'...
N'"
<si-
"'N
"'0
"":0
;!~
co....:
N-
"''''
"''''
tON
~N
~~
r-:l(i
~-
00'0
0.,.0
cicio
M
~
'"
...
;;;
",'
M
ON
o~
oeri
...
~
~
M
'"
6
'"
'"
.0
'"
'"
,.:
'"
'"
..;
N
M
M
<0
'"
en.
:::
-
~
i3
;a>
~
N
...
en
M
o
oj
a;-
M
N
o
!!O
N
~
en
~
"'
...
<0
o
!!O
;:
'"
6
'"
e
00
0.,.
dol
M
N
...
en
M
o
oj
ON
~"'"":
0'"
...
~
a;-
M
N
o
!!O
N
~
en
~
"'
...
<0
o
!!O
;:
'"
"
'"
e
-
5
1i
~
E
o
if)
~
N
'"
.;
'"
M
.0
'"
'"
f,
'"
..,
;;;
.,.
f,
.,.
'"
M
...
M
,.:
o
'"
ci
o
...
N
"'
<;
'"
'"
o
...
<si
'"
...
.;
o
...
..;
..
'"
oj
M
en.
~
N
'"
oj
...
'"
<si
'"
o
.,;
...
...
'"
...
.,.
.0
N
..
"
...
"'.
;;;
.,.
N
..
"
...
"'.
~
M
..
o
o
"
2'
e
.
E
.
~
.,.
'"
cri
..
'"
,.:
..
'"
.0
'"
...
'"
~
'"
M
<si
'"
'"
'"
M
...
M
,.:
o
'"
ci
o
.,..
~
N
~
'"
~
o
'"
'"
o
...
<si
'"
...
.;
o
...
..;
..
'"
oj
M
en.
N
'"
oj
...
'"
<si
'"
o
.n
...
...
'"
...
..
.0
'"
j;j
'"
....
~
""
~
~
.n
..
"'.
;;;
'"
f,
M~"
0....
0:)""':0)
"'0'"
""'N
~..qo-crl
"''''..
OM"
.n IJ")"
'" '"
...
'"
"
'"
M
oj
'"
..
'"
M
;!~a:;
NON
"''''...
0.,.",
r-:or.:
~~~
('1')- ~:i
M M
'"
'"
..;
'"
M
",'
'"
...
~
N
"'.,.M
"'''''''
Ll'icicci
"'N~
MM'"
,....-~...-:
"''''N
1.0_..-....._
~
N
'"
M
,.:
'"
.-:
'"
'"
<si
;r;~~
NN~
~'"
c<i C") a)
0.,..,.
... ...
cO co.
...
'"
.,;
'"
M
'"
N
'"
oj
MOM
"'N",
~ci.q:
N "'~
"'''''''
1"--"..... en
MN'"
'" '"
N- N"
'"
..,
M
"'.
<0
...
<si
OMM
"'M'"
cOlOM
~ "'0
O~N
l.ria lli
"'''''''
... '"
(D" CJ;J-
..
...
en
..
'"
ci
N
..
.0
"''''N
0"''''
ONN
"'0"
MOM
......(J'l0.
M~'"
.,. ..
..n l/)-
.0
15
o
~
~
.:2
;;
e
o
~
-
..
E 2
f.l:. U
~~~
N
~~
o~
.,..,.
CN
~~
;t;
CN
~;f!.
;~
c::iN
?f!.?f!.
CM
"'.,.
ON
'f
25,
rn
e
rn
::!;
00
.
oS
-
~
.E
>-
.0
.,.
o
o
N
."l
rn
o
"
~I
'6
.s
.
ffiro
~o
53.9
" "
(j ~
>
"$.*~?t-?f!.?f!.
MCO....Mlnlt)
M"ltQM"ItN
"':coi"":C"IiMui
- -
.5-5
. 5
W::!;
~N
<~
f!.;f!.';/e't!.'/!.
MCO.....MIn
MVOM"lt
"":e<i"':NM
t;
rn _
...1.0
.00
16'0
"::!;
~M
<
'::!e.'::!!.';/!,?f!.~
~o,fcNC
~ddd~
I
~{l{l
~~~~~
.;;: ~ '0 a>
>0 0 c5 oS ro
~ ,n Cl C!J 0:::.
jjiv ~
~ i ffi.~ (t.~
~ :l3
;;-S:
c-:..e
~ -
Q
'"
Q.
~
~ E
rn.2
. .
"",
~t
-
"0;
o
"-
"''Ot
CO
....0
'" 0 N
""~
"'CIl'"
.ECO'-
:J .S:! .oCll
C:t:
....t:E
o CD ~
>.0 CIl
i3'OC
CIl'O
~~
CIl
.c
U
en
,,-
CIl ..
" ~
~S
~.5
"
CIl ..
" >.
~ ..
Uc
~
.s~
.. ~
>..3
.. ..
C:;;
-
..
eS
CIl ..
-II::
.5
-
..
t!'C
J!! CIl
.5 E
>.
- ..
=0.
..J
>.
-
'i: CD
,,-
- ..
..C
:;;
CIl
..
"J!!
.c ..
~C
"
a.
- ..
~ ':i
OlD
"
CIl
= E
'fi .~
v"l;f"LOQ')CJ')(OtOCOO..-N
r--.:~O""'NCO l.()~'I""""'l"'""
N(J')N...tMaiNc.O..-...t~
ONM..-NCO..-<o::tN"I"'""tO
MvO>(o(oN~COUl'"lLO
0- 0> cn- ci ci o~ ~- ~- 0 ~ ci
~ ~~~~~~~~
COt---t---N
t---N~~
~ciNr--:
LO(OvO
N(oLOUl
c-JO>O>M
~
(oOcnt---~MO~~CO
LOO,,!~~(oO"d':~LO
CV;.q:MN.q:OONOOtO
(O(ONvvLO(OcncnO
vo~~cnt---OCOCOv
ciLOO>v-LOC""iLOv-v-LO
~
t---MvcnO
C"':!~"d':~v
~CO(O(Or--:
cnN~LON
(Ot---Nt---~
c-J -c::i
cocnNNLO~MV~t---O~vN~(oMCOOM~MOOCOt---cnt---cnM
~M~MM~OCO~Ocncn~(oLOt---t---V(o~LOt--.t---t---t---M LO N
NNNNNNN~NN~~~~ ~ ~ ~
LO(oMcnOLO~NcnMcn(oMO(Ot---VLONcn(oNNcnt---VOLO(oM
~~NMVVV(o~t--.COcncncnNNMMVLONLO(Ot---COcn~N
~~~~~~N~ ~~~NN
'#.'#.'#.'#.'#.'#.?fe'#.
LOOOOOOCOO
Nv~t---LOCOcnLO
f'-.:"d':f'-.:~~f'-.:~C"':!
~~~~~~~N
'Ot'Ot..,.
000
r=::rDN
~i:Oco
III
III III III
QQQ
IlltO'"
OO~
---
~ ~ ~
000
vvvvv
00000
-----
MOM~O
~~CO~s:?:
i:Ot/5 (0(0
LO LO LO LO LO
QQQQQ
cnOvo~
~NO~~
;::;::NNN
00000
vvvvvvvv
00000000
--------
t---(ONMOM.,...-O
NOO~~O~M
--------
LOLO~LOLO(o(o~
00000000
'#.'#.
o III
NO>
~~
~~
..,.'Ot'Ot
000
M~~
CO(O~
to
III III III
000
---
CO'OtO
~Q~
NMcY5
000
'Ot..,.'Ot
OOQ
cY5r:::v
QQ~
to tOtO
000
'#.'#.'#.
000
"'....Ill
O,,!,,:
NNN
'#.'#.'#.?fe'#.'#.'#.cftcftcftcft
OOONOOOO~OO
L()~t---ML()NOcnML()L()
~L()~~,,!L()v(O~L()L()
NNNNNNNNNNN
'Ot'Ot'Ot
000
r:::ON
~~~
to........
..,.'Ot
00
--
o CO
~r:::
~
~
'Ot'Ot
00
--
0> III
~ -
_CO
o
~
L()ll:lll:lll:l
QQQQ
t---v~(O
~NMO
----
MMMv
0000
III III
QO
....~
00
~t/5
00
III III
00
--
IllN
o ~
--
III III
00
'Ot'Ot
00
--
....0
~N
--
to....
00
vvvvvvv
OOOOOOQ
NO co a> i:O;:: cn
N~O~OOO
r:::;::t::0Q5;::a>
o~o~o~o
00000000000000000000
00000000000000000000
00000000000000000000
cicicicicicicicicicicicicicicicicicicici
00000000000000000000
qqqqqqqqqqqqqqqqqqqco
~~~~~~~~~~~~~~~~~~~
~
~ -" ~
Q) c: Q)
.c ~'c
~~~~ ~
l::l::l::_ l::
~~~(J)~~
~
'Ot'Ot
00
--
~ 0>
;::05
~
vvvv
0000
o05NN
~~N~
;::000
~ ~ ~ ~
ll:lll:lLOll:lll:lLOLO
QQQQQQQ
cn~~~CO(OM
~~QQQ~~
LOLO(o(o(o(O(O
0000000
vvvvvv
QQoQQg
OO>NN'Ot~
~~~N~~
;::oooo~
~~~~~~
cft?feeF.cftcftcft
OLOLOOOO
MLOLOOt---O
LO(O~t---Ocn
NNNNCV;N
'Ot'Ot
00
--
'Ot'Ot
~N
--
o~
~ ~
vvvv
-NoQQQ
..,.NCO
~-NN
N:::N~
~ ~
III III
00
--
O>'Ot
~~
to....
00
III III
QQ
'Ot~
Q~
CO CO
00
'Ot'Ot
00
N~
~Q
N~
~ ~
'Ot'Ot
QO
NOO
~o
NN
~
0000000000
0000000000
0000000000
ci ci 0- 0- ci ci ci ci ci 0-
0000000000
qqo_qqo_qo~qo_
~~~~~~~~~~
-" ~ 5E5E::; 5E
l:: CI) -- - -
en ~ .f:";= ~en ~cc ~cc ~~cc rr>
~~
Q)
ell CO .;:
~
,'"-
~'n
~
.~
....
....
o
00
'Ot
o'
N
N
<It
o
o
o
C
o
00
'"
N
<It
..
>.
..
C
'Ot
o
iii
o
~
~
o
'Ot
....
N
N
>.
-
";:
"
-
..
:;;
"
CIl
-
.c
Ol
'ijj
;:
"
"ijj
>=
"
CIl
-
.c
Ol
"ijj
;:
>-
o
z
w
(9
<(
W
f-
en
<(
$:
Q
..J
o
en
<(
w
a:
<(
z
<(
f-