Investment Report Quarterly (September)
i5li~~E
~~~
MEMORANDUM
November 2, 2005
TO:
The Honorable Mayor and City Council Members
FROM:
Michael C. Van Milligen, City Manager
SUBJECT: September 30, 2005 Quarterly Investment Report
Finance Director Ken TeKippe is transmitting the September 30,2005 Quarterly
Investment Report.
.JJ.t1IG,;2t/',
Mi ael C. Van Milligen
MCVM/jh
Attachment
cc: Barry Lindahl, Corporation Counsel
Cindy Steinhauser, Assistant City Manager
Kenneth J. TeKippe, Finance Director
~---j
c:
D~~~E
~~~
Memorandum
TO: Michael C. Van Milligen, City Manager
FROM:
Kenneth J. TeKippe, Finance Director ~ (/:p f::.1-P
September 30, 2005 Quarterly Investment Report
RE:
DATE:
November 2, 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 July 1, 2005 through September 30, 2005.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended September 30,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 September 30, 2005 & Fiscal 2006 YTD
Market Value / Unrealized
Carrying Including Gain (Loss) /
Description Value Accrued Interest Accrued Interest
Deposits, Change & Petty Cash Funds 93,625 93,625
Checking/Savings Accounts 8,706,931 8,706,931
Certificates Of Deposit 17,500,000 17,740,718 240,718
US Treasury Securities
Corporate Stock 11,518 58,062 46,544
Investment Advisor Accounts 21,870,499 21,977,595 107,096
Total Funds 48,182,573 48,576,931 394,358
Breakdown
City
Metro
Total Combined Funds
40,413,209
7,769,364
48,182,573
40,723,134
7,853,797
48,576,931
309,925
84,433
394,358
Cash Basis Quarter Year-To-Date
Gross Earninas:
City 339,187 339,187
Metro 62,858 62,858
Combined 402,046 402,046
Investment Fees:
City (42,807) (42,807)
Metro (132) (132)
Combined (42,939) (42,939)
Net Earninas:
City 296,381 296,381
Metro 62 726 62,726
Combined 359,106 359,106
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
September 30, 2005
FY06
MANAGED FUNDS
PORTFOLIO TOTAL
COMPOSITION COST CITY FUNDS
PERCENTAGE BASIS PERCENTAGE
DANA INVESTMENT ADVISORS, INC.:
Cash 1.04% 57,851
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 98.96% 5,509,474
Total 98.96% 5,567,325 11.55%
DUBUQUE BANK & TRUST:
Cash 4.59% 309,980
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 95.41% 6,450,067
Total 95.41% 6,760,046 14.03%
FIRST COMMUNITY TRUST:
Cash 2.47% 66,705
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 97.53% 2,639,069
Total 97.53% 2,705,773 5.62%
US BANK:
Cash 1.54% 105,344
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 4.38% 299,508
Federal Agency Obligations 94.08% 6,432,504
Total 100.00% 6,837,355 14.19%
GRAND TOTAL 21,870,499 45.39%
BREAKDOWN BY TYPE OF SECURITY:
Cash 2.47% 539,879 1.12%
Mutual Funds (US Government) 0.00% 0 0.00%
Certificates Of Deposit 0.00% 0 0.00%
US Treasury Obligations 1.37% 299,508 0.62%
Federal Agency Obligations 96.16% 21,031,112 43.65%
TOTAL MANAGED FUNDS 100.00% 21 ,870,499 45.39%
Page 1
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
September 30, 2005
.1
OTHER FUNDS
.
COST
BASIS
FY06
TOTAL
CITY FUNDS
PERCENTAGE
CASH
Change and Petty Cash Funds
Prepaid Postage
Prescriptions & Workers Comp Deposits
Total
CHECKING I SAVINGS ACCOUNTS:
American Trust & Savings Bank (General & Health)
American Trust & Savings Bank ( G.O.Bonds Series A Stormwater Projects)
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)
Dubuque Bank & Trust (GO Bonds Industrial Series C West Projects)
Dubuque Bank & Trust (GO Bonds Industrial Series B West Projects)
Dubuque Bank & Trust (Comml/lndustrial Building Rehabilitation RLF)
Dubuque Bank & Trust (Economic Development RLF)
Dubuque Bank & Trust (Cable Franchise Equipment Fund)
US Bank (General/Ambulance)
Premier (Utility)
Liberty (Utility)
East Dubuque Savings Bank (Utility)
State Central (Utility)
Total
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
8,625
5,000
80,000
93,625
334,005
925,490
1,083,904
280,344
1,002
1,144,392
708,321
3,963,613
4,677
4,973
176,400
28,602
16,419
12,671
20,421
1,697
8,706,931
12,000,000
2,500,000
2,000,000
1,000,000
0.19%
18.07%
Total
U.S. TREASURY OBLIGATIONS
CORPORATE STOCK (Lyons Peony Trust)
TOTAL OTHER FUNDS
TOTAL CITY FUNDS
IRECAP OF PORTFOLIO PERCENTAGES
MANAGED
FUNDS
1.12%
0.00%
0.00%
0.00%
0.62%
43.65%
0.00%
45.39%
CASH
CHECKING / SAVINGS ACCTS
MUTUAL FUNDS (U.S. GOVERNMENT)
CERTIFICATES OF DEPOSIT
U.S. TREASURY OBLIGATIONS
FEDERAL AGENCY OBLIGATIONS
CORPORATE STOCK
Total
P8!j1e2
17,500,000
11,518
26,312,074
48,182,573
OTHER
FUNDS
0.19%
18.07%
0.00%
36.32%
0.02%
0.00%
0.00%
54.61%
36.32%
0.02%
0.00%
54.61%
100.00%
COMBINED
TOTAL
1.31%
18.07%
0.00%
36.32%
0.65%
43.65%
0.00%
100.00%
.
1;:
<0:
::;
::;
w=>
=>'"
a....
=>z
IDW
OJ::;
0....
...'"
o!!;!
~;;
u~
J:
....
Z
o
::;
'"
e
o
~
o
;;,
c
'6
c
W
J:
"E
o
::;
~
C _I
o ~ 0
.= E 2
...E....
o
u
"
~ -I
.- "
.Q-
E 0
0....
u
!
" 01
~-
"'c
" ~
c 0
" u
:;;.:t
!I
il
~I
'"
~
-J
~
'"
!(!
'"
ill
... J:
'" "E
o 0
o ::;
<;
t..
o
.~
"
ID
-.;
o
o
;!
o
t-
..
.;
"'
t-
o
"'
'"
<'>
<ri
21
'"
:;l
oS
N
<0
t-
M
..
..
oS
<0.
-
N
;;;
-
'"
'"
ri
N
'"
<D
t-
..
0;
;g
oS
ill
N
'"
N
M
<0
'"
ai
..
t-
<D
o
t-
o;
..
"'
<D
"'
"'
.;
t!~8g
N..tO<ri
g:~ ~
;t~ :g
"'
-
:;l
~
m:!8~
ili<iolli
t-N ..
0" 00" N"
t-- <0
10M N
t--iO C"!
~ ei. ~
rn- ('")-
- -
~~
~0
t-<O
oS-
t-F:'
t-'"
"":00
t-<'>
t-t-
ai-
-
N_
..'"
NN
-'"
N'"
00" (!I
--
..
~
o
o
o
III::'(/)
.~ ~ ~
E "m 8-
"" ~
UjI.U"CD
.c:~CIl-
~ w.t:I,g!
:0 2 m":i"
-o.5o::::u
<0:
"'
-
:;l
~
~
.0
..
oS
o
'"
<ri
<'>
o
ai
-
0;
0;
N
<'>.
-
-
o
c
~
i5
"
<(
..
<;
....
o
Kl m
...~ 0 ~
ell III l!
Uj 'C1f~:g
.~ ~ .c: :v ~
tl ~:6t5-
!lI!!..s.:a.:~
- - III C c..
~~8~J
'"
m~~8~
~~~o;:
N....O to
e~!i NO
ijj'~
<illi
N_
eci
F:'
-
"
~
w
<'>
N
N
:!-
~~
..t""";
..-
N<O
e-
"'
<0
..;
"'
!!l.
N N
l!! ~
;:::: t::-
o 0
ci ci
gR:
ciei
..
..
o
-
F:'
-
"
~
w
<'>
N
N
:!-
~
.0
"'
'"
~
~
..;
!R
o
C
o
t;
~
:E
~
'"
]j
{!.
N
'"
<ri
;g
ai
'"
'"
o
"'
0;
"
..
ai
21
ai
N
;:;
0;
'"
..
o
t-
"'.
-
N
<0
<'>
.0
"'
<'>
'"
<'>
'"
<D
<'>
o
M
t-
t-
~
N
'"
o
<ri
..
o
fi
t-
<D
1ri
..;
Pi
'"
m
ui
J:
"E
o
::;
E
~
5
o
o
.~
"
ID
-
.
o
o
w
..;
t-
o
'"
;::
!i
w
;!'
o
'"
;::
!i
g
o
o
"
~
E
~
~
~
.Q
o
e.
""
2l
~
.;;
u
~
0:
J:
o
"
U
..
z
<0
t-
N
t-
"'
N
'"
oS
..
"'
t-
l:!
o
N
-
<'>
<D
N
;:;
0;
~
o
t-
"'.
N
<0
<'>
.0
"'
<'>
'"
<'>
'"
<D
<'>
o
M
t-
t-
~
N
'"
o
<ri
..
o
fi
t-
<D
<'>
"'
..;
N
<'>
'"
m
ui
~
u
C
"
';ij
ID
o
.~
"
ID
-.;
o
o
'"
C
'6
C
W
'"
~
-J
~
'"
'!I
-J
::!
...
llJ
l€
;;
~
~.
!;;~co
iiig:;j
a;",,,,
as...... <<:i
~;J1O
~ ~
-
N.
0;
t-
"1
~
~
ai
N
~~~
t-"'~
<Ot-<'>
~f ~ sf
<'>N",
tri to"
N N
t-
'"
<ri
'"
"'.
N
o
N
N
<Ot-<'>
<'>"'N
~u:i~
<'>N",
0"1"-1'--"
t-ot-
......_NO'>_
N N
i8
M
t-
"'
~
'"
<D
(q~g:
m~~
<'>"'<'>
""':ON
""'N
t- '"
<<:i CD"
<0
-
0<'><'>
oqo
N'<t(!)
t-<O<'>
"Nt-
""'"(!)"rn"
~""ffi
N N
;:;
'"
..;
'"
<0
N
..
<'>
<i
"'.
~
<D
"''''t-
N",'"
~~~
N""'" oj
<'>"'-
'" '"
CD- CD-
'"
..
0;
t-
N
<'>
"'
.;
<0..0
~O'lv
m~~
as (") 'f":
NN",
"' "'
lO L6
..
..
2
u
.:t
.e
"
.!!!
o
~
!
J:
"E
o
::;
.~
Ii.
~
~
';ij
>
..
'"
:;
::;
"E
~
.s
o
~
>
.E
J:
"E
o
::;
o
';ij
"E 2
!.r:. CJ
:;~.;:
~::E 0
::Jli;
~~~
~o::J
~-:g
:v~<(
::; ~ ~
c:E.g
~a:>
ti 2 CIl
~ U '"
> u .
..=<C::i
<fe.<fe.
l!lill
e.....:
<fe.';ft
~:5l
e.....:
';ft';je.
"''''
"''''
e....:
';ft.<fe.
"''''
"''''
ON
~
~
'"
"
C
"
:;;
"
~
E
11l
~
>
.EO
'"
.Q
"
~
'i
~
E
o
"-
:;
~
>-
:;
"
c
. ~
5 E ~
-; ~ E
0::::0:::2
.!2~~
'Oem
~~~
0.
8
N
~
ii
B
~
u
'6
S
w
~
~
~
~
iiim
,,0
m2
lii iii
u ~
>-
';ft.';!.';;!.';!...,.'$-
M......C"'JO)....1l)
....00001),....
N"":"":"":"'" cD
11l
" 0
~J:
~"
",0
~::;
~'"
.i(-
*"';ft';:{e,';{e,';ft
N.....cn~cn
(O"IIt'q~(O
NN~~<oi
11l
. 0
~J:
&c
. 0
.::;
~<'>
<(
~~~~~
~:"~N"'"
OOcnOLON
o e..o e..N
.
.
00.
"""
c c c
.g.g.g
x
~~-s:~w
~~~~.5~
~ Q) E Q) B Q)
I- iV :v iV;f.s
>'0)1-:0 n..
~l'!'t::Q)Q)c
@~~~~~
C:c:.5158
~ ~ 1ij 0
"ii "ii E
...J...J"ii
~
.
'" .
",-I!
<:\.e
"I -
.. .~
"'a
"-: (,/)
o 0
. s
".,;
~o:
"I
9'
""
on
o
Q.
!
on
o
_ 0
ell 0 N
::Itn 0
g.! eo)
..QRJ_...
::J .!::! o.!
O~onE
_t::e(eII
o ell _
~o Q.
._ _ CD
00 en
ell
:;
...
ell
.c
"
en
~ti
2 f
"S
" <:
c(
...
g: ~
... '"
So
c(
.s~
on ...
:-..E!
'" '"
0::;;
-
on
l!!S
.!&!
<:
'Ui
f1:
S ell
.= [
- '"
lQQ.
...I
~
'i: S
~~
::;;
ell
on
]~
~o
::I
Q.
on
t) .-
o on
o&l
...
ell
lQ E
.c e
~LL
::I
Q.
S ...
~1l
~ E
'E ::I
eIIZ
o
MmO>ONNClOCDCO...q-N
OCOIt)V("")It),-l,()COt--..CO
Nuim,....:m~mMNNc:i
OmvCONl.{)('l')COmOv
......~ oo~ ,... co~......~ I,{)~ ClO~ ,... ......~ N O)~
000 COl,()m......NCOI"-..nV
N,....,...,....'l""'''''''''''''''''''''''''''''''
N"''''
~~m
"'....:
"'lO
ON
loff ~
~ ~
("')0,....<0
O>,...c:o~
~~~;:
COCOr-...M
cci Lf)~ ,....- ~
~
N
N
0>
P.:g~~C!;(:::~~~~~~~~
N,....,...,....N,....,...'I""""""""''''' ,....,....
OOOIl>N
......1,(') ,-N
coco M,-..q-,-..q-,....NmMClOv OOM 0......00
,....MM..q-U1COCOCOClOOlO..-MCO COClO
,...,....,...,...,... ,....
~~~~~~~*~~~~~~~~~~
......ODDOOOOOOOOOO,....vON
It)M NM MNmoo moo coco,.... 00 It) (0 00 It)
NCOCOIt)It)COCOIt)CO~~~~~q~,....M
MMMMMMMMMMMMMMvvv~
LOlOlOU1l{)I/')l{)L()
eeee~Qee
~~~~~~~~
'" '"
a a
t::03
...C:!
...
~
- -
lO....
'" '"
ee
88
00
Lf)1J')1.()L()LOLO
~~~a~a
,....MO,...~M
00;::;::,...;::
,....,....,.... ,...
lOlOl.()(O
QQoo
o~Rl~
"''''''';::
~ ~ a
co co <0 co co co
eeeeee
~~~8~~
:;::,....NMM~
000000
,...,....,... ,...
1t)1t)1t)lt)1t)lt)1t)1t)1t) It) It) It) It) It) It) It) It) It)
Qoeeeeeeeeee~eeeeeQ
v,....,....ococo 00...... OOV ,-It)(Ov,-1t) 00
,....~M~,....O~,....ONOOO,....,....,....,....o
NMMVM~~.~~~~~~ID~ro~m
ooooooooooooooooaa
aaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaa
aaaaaaaaaaaaaaaaaa
000000000000000000
aaaaaaaaaaaaaaaaaa
qqqqqqqqqqqqqqqqq~
~~~~~~~~~~~~~~~~~
~
...
OJ
"E
OJ
-
a.
"'-
6. ~ ~IE~ ~
.j;'cncnlDenlDcnena::cncnlD
eIIo/lo/lcno/leno/lo/lwo/lo/lcn
-"I-I-Ol-Ol-I-!!:!I-I-O
:::;<l:<l:W<l:Wc(<l:...I<l:c(W
~
cnenenenen
o/lo/lo/lo/lo/l
!;(!;(!;(!;(!;(
CD~mNmCD Ma ~ r--.M M
a~~"""MCDm""""""~OO'VCOCOMa
moocoCOCOCOCDCOOOMco~comam
~~~~~~~~~~~~~~~~
'V~~~~~~~~~~~~~~......
N
~~
....'"
~N
~ ~
....
...
a:i
~
....
ci
...
N
...
o
o
o
.;
o
on
,..:
~
.,.
on
iij
~
~
.
~
...
CD
..;
i:i
"ii
>=
...
ell
-
.c
'"
~
on
:-.
'"
o
'"
N
00
CD
i-
";:
::I
'iii
::;;
...
~
'"
~
>-
o
z
W
C>
c(
~
en
~
o
:J
o
cn
L1i
a::
c(
z
~
:J
o
a.
o
a::
I-
W
::;:
W
::>
a
::>
lD
::>
o
"
~