Investment Report, Qtrly, Dec. 05
D~~~E
~~~
MEMORANDUM
January 23, 2006
TO:
The Honorable Mayor and City Council Members
FROM:
Michael C. Van Milligen, City Manager
SUBJECT: December 31,2005 Quarterly Investment Report
Finance Director Ken T eKippe is transmitting the December 31, 2005 Quarterly
Investment Report.
(11J ltJtLL
Midiael C. Van Milligen
MCVM/jh
Attachment
cc: Barry Lindahl, Corporation Counsel
Cindy Steinhauser, Assistant City Manager
Kenneth J. TeKippe, Finance Director
i5'G~~JE
~t/k.~
Memorandum
TO:
FROM:
Michael C. Van Milligen, City Manager
Kenneth J. TeKippe, Finance Director ~ 0 ~
December 31,2005 Quarterly Investment Report
RE:
DATE:
January 23, 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 October 1,2005 through December 31,2005.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended December 31, 2005 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 December 31,2005 & Fiscal 2006 YTD
Market Value / Unrealized
Carrying Including Gain (Loss) /
Description Value Accrued Interest Accrued Interest
Deposits, Change & Petty Cash Funds 88,275 88,275
Checking/Savings Accounts 9,938,653 9,938,653
Certificates Of Deposit 21,000,000 21,204,696 204,696
US Treasury Securities
Corporate Stock 11,518 56,461 44,943
Investment Advisor Accounts 22,105,679 22,080,581 (25,098)
Total Funds 53,144,125 53,368,666 224,541
Breakdown
City
Metro
Total Combined Funds
44,719,157
8,424,968
53,144,125
44,846,140
8,522,526
53,368,666
126,983
97,558
224,541
Cash Basis Quarter Year- To-Date
Gross Earninas:
City 499,621 838,810
Metro 88,357 151,215
Combined 587,978 990,025
Investment Fees:
City (28,186) (70,993)
Metro (182) (314)
Combined (28,368) (71,307)
Net Earninas:
City 471,435 767,817
Metro 88,175 150,901
Combined 559,610 918,718
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
December 31, 2005
FY06
MANAGED FUNDS
PORTFOLIO TOTAL
COMPOSITION COST CITY FUNDS
PERCENTAGE BASIS PERCENTAGE
DANA INVESTMENT ADVISORS, INC.:
Cash 0.66% 36,748
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 99.34% 5,567,324
Total 99.34% 5,604,071 10.55%
DUBUQUE BANK & TRUST:
Cash 8.19% 561.927
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 91.81% 6,303,220
Total 91.81% 6,865,146 12.92%
FIRST COMMUNITY TRUST:
Cash 0.61% 16,656
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 99.39% 2,715,627
Total 99.39% 2,732,283 5.14%
US BANK:
Cash 1.26% 87,017
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 5.80% 400,751
Federal Agency Obligations 92.94% 6,416,410
Total 100.00% 6,904,178 12.99%
GRAND TOTAL 22,105,679 41.60%
BREAKDOWN BY TYPE OF SECURITY:
Cash
Mutual Funds (US Government)
Certificates Of Deposit
US Treasury Obligations
Federal Agency Obligations
TOTAL MANAGED FUNDS
3.18%
0.00%
0.00%
1.81%
95.01%
100.00%
7n2,~47
o
o
400,751
21,002,580
22,105,679
112%,
0.00%
0.00%
0.75%
39.52%
41.60%
Pagel
OTHER FUNDS
CASH
Change and Petty Cash Funds
Prescriptions & Workers Camp Deposrts
Total
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
December 31, 2005
COST
BASIS
FY06
TOTAL
CITY FUNDS
PERCENTAGE
8,275
80,000
88,275
0.17%
CHECKING I SAVINGS ACCOUNTS:
American Trust & Savings Bank (General & Hearth)
American Trust & Savings Bank ( G.O.Bonds Series A Stormwater)
American Trust & Savings Bank (America's River G.O.Bonds)
American Trust & Savings Bank (Housing Rehab & Section 8)
Dubuque Bank & Trust (GeneraVMetro/Leisure)
Dubuque Bank & Trust (GO Bonds Industrial Series B West Projects)
Dubuque Bank & Trust (Comml/lndustrial Building Rehabilitation & Econ Developmen
Dubuque Bank & Trust (Cable Franchise Equipment Fund)
US Bank (GeneraI/Ambulance)
Premier (Utility)
Liberty (Utility)
East Dubuque Savings Bank (Utility)
State Central (Utility)
CERTIFICATES OF DEPOSIT:
American Trust & Savings Bank
Dubuque Bank & Trust
Dupaco Communrty Credrt Union
East Dubuque Savings Bank
Liberty Bank
Premier Bank
State Central
US Bank
U.S. TREASURY OBLIGATIONS
CORPORATE STOCK (Lyons Peony Trust)
TOTAL OTHER FUNDS
TOTAL CITY FUNDS
IRECAP OF PORTFOLIO PERCENTAGES
CASH
CHECKING I SAVINGS ACCTS
MUTUAL FUNDS (U.S. GOVERNMENT)
CERTIFICATES OF DEPOSIT
U.S. TREASURY OBLIGATIONS
FEDERAL AGENCY OBLIGATIONS
CORPORATE STOCK
Total
Total
Total
2,094,648
682,154
1,090,008
200,416
2,757,683
2,937,930
18,835
86,266
19,853
18,667
16,910
13,375
1,908
9,938,653
18.70%
13,500,000
3,500,000
3,000,000
1,000,000
21,000,000 39.52%
0.00%
11,518 0.02%
31,038,446 58.40%
53,144,125 100.00%
MANAGED FUNDS OTHER FUNDS COMBINED TOTAL
1.32% 0.17% 1.49%
0.00% 18.70% 18.70%
0.80% O.CO% 0.80%
0.00% 39.52% 39.52%
0.75% 0.00% 0.75%
39.52% 0.00% 39.52%
0.00% 0.02% 0.02%
41.60% 58.40% 100.00%
P;oge2
>-
0:
<l:
:;
:;
w::J
::J'"
0....
::JZ
lDW
::J:;
0....
..'"
O~
~;;;
O~
J:
....
Z
o
:;
on
~
M
N
~
c,
c
'C
c
W
"'
E
o
:;
~
~ ~ ~I
U::E'=
o
l.)
"0
$
.S "I
.0-
E 0
0....
l.)
I
"00
$-
~C
. "
C 0
. 0
,.:i
!I
il
~I
!(!
~
....
~
""
'"
<;;
0\ "'
... E
'" 0
o ,.
"
'"
N
6
'"
'"
ai
....
'"
6
'"
;;;
u;
o
'"
'"
....
'"
ai
N
'"
'"
..,
'"
N
o
o.
'"
'"
'"
o
<"i
00
"'.
0:::
'"
",'
'"
....
oj
'"
o
'"
~
....
N
'"
'"
<<i
'"
'"
ri
'"
'"
ai
'"
....
en
o
'"
oi
:li
<ti
~
o
~
o
';;;
.
lD
..
o
"
.
$
o
o
o
fJJCt/J
.~ ~ ~
E"lij ~
. to $
iJ)W"'CO
cij)Q)-
~ ~ ~.~
:c2mg-
-c.EO:::U
<l:
~88 ~
o(<')cir-...:
O~ 00
~'" '"
N"LCi (!i
N - ~
'"
<<i
'"
'"
oi
'"
1'--00f'-,
",!OON
Ne>?ciai
~;;; :;l
~-~ 8"
",6
"''''
cieri
0-
'"
ri
'"
"'~
"''''
(<j""':
"''''
"''''
<ti-
",ro
"''''
uir....:
....'"
"'-
N
'"
"';::-
"'~
M<D
ill~
dLtl-
"'-
~
<<i
(l;
oi
'"
'"
"
o
'"
ri
'"
'"
'"
oj
<D
<ti
~
'"
'"
.;
o
'"
N
'"
'"
'"
,..:
::;
<ti
o
C
~
'5
"0
<l:
"
'0
....
o
Kl iU
$ 0 ~
LL $ ~ ~
~ ~ LL ~:6
~ ~.~ ~ s:
U 0l"C U-
e~.s.:.::~
:c Itl ~ ; :i
:::l::EOCDO
'"
8MSom
tOt-ON
o~gci:g
~'" '"
ri~ ti
813
6:1:
~
ci
6
'"
u;
o
~
~
oj
'"
:!-
,::
'"
6
?e-
"'
'"
u;
'"
~
~ ~
Ii Ii
co_ co.
~ ~
8'"
'"
6",
'"
"
6
'"
8
~
~
~
'"
'"
:!-
,::
'"
o
?e-
"'
'"
u;
'"
~
o
c
o
t;
~
E
"
'"
"
'0
....
'"
'"
oj
'"
~
;;;
'"
6
'"
N
<"i
'"
'"
<ti
....
....
ai
'"
....
~
en
....
'"
8'
~
N
'"
'"
'"
<<i
....
..,
ill
ai
o
'"
<"i
'"
'"
N
'"
....
N
'"
'"
ai
'"
<ti
'"
00
ai
'"
'"
~
....
o
..,
ill
<ti
"'
E
o
:;
E
~
S
u
o
';;;
.
lD
..
o
"
'"
'"
oj
'"
'"
N
'"
'"
N
'"
'"
oj
ill
fi
'"
N
~
c
$
E
$
~
"
.0
o
e
'"
.
Q.
.~
o
$
0:
"'
o
.
U
;;
Z
....
'"
..,
'"
1
~
ri
'"
o
....
u;
'"
'"
ai
'"
o.
M
....
en
....
'"
8'
~
N
'"
'"
'"
<<i
....
~
t
'"
ai
o
'"
<"i
'"
'"
N
'"
....
N
'"
'"
ai
;!
<ti
'"
'"
ai
'"
N
~
....
o
..,
o
'"
<ti
$
o
c
.
"
lD
o
';;;
.
lD
..
o
U
0>
C
'C
c
W
'"
~
....
~
""
lU
'"
....
~
...
lU
~
~
ill
,..:
'"
'"
..,
'"
'"
N
'"
~"'o
~"''''
M~
~~~
l:f~~
0"''''
f!l ("'J-
'" '"
'"
....
en
'"
.....
<D
'"
6
'"
~~~
~~~
"''''0
rrf'<t cO
"'000
O_NN_
M M
'"
~
<<i
'"
'"
N
'"
"'.
N
"''''....
CO((l~
Nr--:O
~~~
a:;..... 0-
~"'oo
"'~O
.....- N-
'" '"
'"
00
.;
'"
o
6
;;;
ai
0"''''
Lq'<tQ')
~~~
0"''''
~U!i~
.... '"
cD (6
'"
'"
u;
'"
'"
<ti
....
'"
N
~~~
~;g~
"'N'"
ollO"<t"
....~'"
'" '"
N N
'"
u;
'"
'"
ri
0;
ai
"'....'"
...."'~
~~~
00-001'---
"'''''''
"'. '"
'" ai
'"
....
.;
....
'"
ri
'"
'"
<ti
"'''''''
"'....~
NOO""':
"'''''''
"'''''''
~~f ~ g
'" '"
an- l()-
"
.
!
<
J>
.
1i
~
~
"'
E
o
,.
:;
."
..
$
"
~
;;
'"
:;
,.
E
$
S
o
$
>
.E
"'
E
o
,.
o
"
E 2
~:6tl
:::I :5 <(
u,.~
~c.E
-$"0
~t::.!
_ 8 III
Q.I .2,
~'i!~
. ~-
:; $ $
c:E~
$"0>
S ~-;
III ti..:.::
~ u :;;
.f<:;:
~::.e
~1-
N~
ci~
*-<ft
on",
"''''
0"':
:.e::.e
H
ON
~<fl.
....N
NO
OM
~
i
,
~
]
:3
o
'"
$
rn
o
.s
~
.
$
>-
:;
"0
"
E c ~
.a~O
~~~
o ~ $
'-:E 0:::
"Oem
t 0 '0
0,.....
..
~
.
'-
1
~
o
'0
.!;
-
$
~
~
:;;"*~~~~~~
"CCl~U)"l()'<tN
lEBMN"";"';(,,):"':
" ~
u ~
>-
~(/)~~~~~
...J.!:OtDf'-:Il1'<t
~~ <"'i N..... M
.,.
~'"
;c~
lJ) ::,e~~<ft~
llIf/1Nr:..OJM,....
...J..ccn(QUJ<DCD
&1: ci ci ci ci ci
~~
~'"
'"
,
. . 0
"0"0"0
C C "
sss
,
x
~>~~~
~ 0 0 O.E 0::
"- C) C) C) a>
"1l a> E <1l 0 ~
~~~"~;t&
I'IJ a> a:: ~
a~t:::E"'c
ogo~E<1l
m<ct52~~
ffic-=su
E E ffi u
"'"'E
$ $ "'
""....$
....
..
~
"
~
.
~
"
o
"
"
i'l
~
"
8
~ ~
~~
~.2
~ ~
o
"a
13 ~
~.2
~~
. ,
\'"
-
.. 0
::I III
"'''
::I,.
.Q,,-
::s ._ 0
C~tI)
_'1::_
0"-
~U
.- -
U 0
~
::I
""
..
.<:
"
en
~
'Vi
o
Co
..
C
""~
.. III
2 f
" .$
".5
<
mC'\lf""-..-
NLOCO......
("j.q:"":w
OO>oq-f'..
C'\{ M On co_
m -.q--,- CIO
~NN
r--M
CD~
,.:.,
CDr--
.,r--
co-cti
~
r::~
cOM
., '"
"'_N
CDN
~ ~
'" r--....
"N~
criwo
N '" r--
~ r-- M
,-- CD- ,....-
"'0
"'M
",cD
NN
"'CD
-.:fci
~
.,
CD
ci
M
CD
ci
~
LOQ'I""""MCOmLOM
v~OC!c.qc.qo>l,()f""-
mT""",-OJowom
MOO COQ')I,/")t,{')Nt--.
vl.()O>N vO)M
a:i<D-N~r--.-NM-
"" r--
.. III r--
::I ,.,~
... '"
llc
<
OCOLOOvN......mvT'""......m(OCOT'""MOCOCOOM
...,.0>.....................,.0 T'""(OOOMCOCOLON..-LOMM
N .,......-..... 'I""""
.s~<D
III ...
,.,,S
'" '"
c::;:
~~~~w~~~~~~~~~~m~~~~M
'I"""" '1""""""" '1""""'1"""" 'I"""".,-.......,-N N...-
~
'1:
::I
~
'"
::;:
(O<DCOCO<O
QQQQQ
.!~NCOMO
~;::;;~~~
00000
~ ~~~~~~~~~~~~~~#~~~~~~~
f.!ooaO..-OVOONOOaOOONOOaOO
!~~~~~~~~~~~;~~~~~~~~~~~
c MMMV~~~VVV~~~VV~~VVV~~
II)
o
o
N
~
M
...
..
.Q
E
..
"
..
c
coco CO COCO COCO COCO COCO CO CO CO COCO CO
QQQQO~_QQQQQQQ~QQQQ
Nmcoa ......vLO'I""""T'""'I""""CONMO........-
00..-("') NO~OOaO~..-'I""""O'l""""
MMMM~~~LOIDIDWIDCO~OOm~
00000000000000000
~ LOLOLOLOLOLOLOLOLOl.()I,()LOLOLOLOLOLOLO
m~QQQQQQQQQQQQQQQQQQ
~~"""LOCO"""VCO..-LONCO'l""""LONCOVOCO..-
~cQQ~~~~O~~~Q~QO~eO~~~~
::s ......LOcoa...... ~u~NmO ..- O..-(~(~
~ 000 0..-00..-0..-'1""""'1""""'1"""" '1"""""-"-
""
..
III E
'" 0
.<: ...
~LL
::I
D..
..
~ ...
'" ..
".Q
l;: E
'E ::I
..Z
U
L{) LO I,() L()
QQQQ
M M..- co
e~~N
~~"'N
.................. ......
_ .sa
III III
o '"
Um
0000000000000000000000
0000000000000000000000
0000000000000000000000
0000000000000000000000
0000000000000000000000
qqqqqqqqq~qqqqqqqqq~qq
......................................................
~
m(/)(/)(/)
en~~~
Of-f-f-
W<(<<
......................................................
~ ~
E..
~ ~ 6~~ ~ ~~~
ffi~(/)enenm(/)~(/)~(/)en(/)m(/)enen(/)m
m~~~~oen~~~~~en~~~~en
,.~~~~W~~ f-f-f-Of-f-f-f-O
~~___ ~_::;<<<(W<<<(<W
M
~
~
......MCO MN...... 0<0
;!~~~8~:$~~~8~~
<0 "It'...... CO......CO............l/) CJ)CO COCO
N..................NN..................N"It'......N
........................~~........................M......l/)
'" N
;g~
., '"
~ ~
~ ~
"It' ~M(O<O"It'
N..................COON
......O............ON......
CO......LOCO~CO~
...... M..............................
.................................... ......
....
.,
.,.;
'"
CD
<i
o
N
<I>
o
o
o
ci
o
O.
~
N
....
III
iii
-
o
f-
~
.
....
M
M
..;
III
,.,
'"
C
...
N
00
o
~
~
'1:
::I
~
'"
::;:
""
..
~
.<:
'"
~
>-
U
Z
w
(!)
<(
W
f-
(/)
~
o
::J
o
(/)
<
w
a::
<(
z
~
::J
o
a.
o
~
w
::;
w
::J
a
::J
lD
::J
o
"
~
~