Investment Report, Quarterly
D~~~E
~Yk.~
MEMORANDUM
April 25, 2006
TO:
The Honorable Mayor and City Council Members
FROM:
Michael C. Van Milligen, City Manager
SUBJECT: March 31,2006 Quarterly Investment Report
Finance Director Ken T eKippe is transmitting the attached March 31, 2006 Quarterly
Investment Report.
f71J ~/I)JL
Michael C. Van Milligen
MCVM/jh
Attachment
cc: Barry Lindahl, Corporation Counsel
Cindy Steinhauser, Assistant City Manager
Kenneth J. TeKippe, Finance Director
]
i3~~~E
~c/k.~
Memorandum
TO: Michael C. Van Milligen, City Manager
RE:
Kenneth J. TeKippe, Finance Director ~rJ' 0 ~
March 31, 2006 Quarterly Investment Report
FROM:
DATE:
April 25, 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 January 1, 2006 through March 31, 2006.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended March 31, 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 March 31, 2006 & Fiscal 2006 YTD
Market Value / Unrealized
Carrying Including Gain (Loss) /
Description Value Accrued Interest Accrued Interest
Deposits, Change & Petty Cash Funds 88,325 88,325 -
Checking/Savings Accounts 6,881,458 6,881,458 -
Certificates Of Deposit 21,000,000 21,259,924 259,924
US Treasury Securities -
Corporate Stock 11,514 64,100 52,586
Investment Advisor Accounts 22,272,992 22,164,699 (108,293)
Total Funds 50,254,289 50,458,506 204,217
Breakdown
City 22,794,737.75 41,828,516.73 19,033,779
Metro 8,513,707.95 8,629,989.00 116,281
Total Combined Funds 31,308,445.70 50,458,505.73 19,150,060
Cash Basis I Quarter Year-To-Date I
Gross EarninQs:
City 386,266 1,225,076
Metro 75,543 226,759
Combined 461,809 1,451,835
Investment Fees:
City (37,923) (108,916)
Metro (138 (453)
Combined (38,061 ) (109,369)
Net EarninQs:
City 348,343 1,116,160
Metro 75,405 226,306
Combined 423,748 1,342,466
~
<
:E
:E
w=>
=>en
01-
=>2
",W
=>:E
CI-
,,-en
O~
~~
U~
:I:
I-
2
o
:E
<D
g
~
M
;:;
o
"0
m
,5 "I
.0-
E 0
01-
o
I
'"
c
rn
'"
<f)
::>
il
~I
(J)
~
-J
~
0:(
!2
(J)
tt'i E
.... c
(J) 0
o :E
(J
N
o
.,;
'"
'"
o
...
'"
'"
moDO)
CX)MQI.()
lli..ro"':
gij5 g
f'-..-{,)- v.
1'-- I'-
lDr:::-;::-OM
N(<').--Ol'-
Lri"';""':OM
::g~l::: ~
~ct~ ef
...
N
N
...
o
ui
'"
LOr:::-
N'"
Lri...:
coo
"'N
~ct
'"
I'-
.,;
"'
'"
N
I'-
I'-
'"
00
'"
'"
"'
.,;
'"
N
a
'"
ii);;t
N'"
lliC\i
co ~
"'"'
~-
iD
'"
::g
~
ii)
'"
N
N
::!.
iD
"'
".:
'"
~
".:
I'-
1'-.
~
8~
ciw
co
I'-
t:::
-
-
".:
I'-
1'-.
~
iD
'"
::g
~
ii)
'"
N
N
::!.
ii)
<ri
'"
~
iD
"'
".:
'"
~
w
c
o
"'
u
~
J5
~
<f)
}9
o
I-
co
co
N
I'-
co
'"
"'
'"
'"
'"
'"
I'-
o
co
co
i,
"l
;;;
'"
N
'"
'"
N
I'-
N
N
N
'"
"'
to
...
"'
'"
...
'"
<6
N
I'-
'"
...
co
00
...
I'-
N
N
N
"'
N
N
'"
<6
I'-
'"
o
co
co
'"
'"
"'
ui
J::
1:
o
:E
1:
m
~
~
"
(J
'"
'..
..
'"
-
'"
o
(J
it)
"
co
'"
'"
M.
~
it)
"
co
'"
'"
M
~
:$
c
m
E
m
~
"
.0
W
8
""
w
a.
'w
u
m
"
J::
W
rn
'-'
;;
2
'"
I'-
<ri
~
..
'"
N
a
'"
o
"'
to
'"
"l
00
'"
'"
N
'"
N
81
N
I'-
N
N
N
'"
"'
to
...
"'
'"
...
'"
<6
N
I'-
'"
...
co
00
...
I'-
N
N
N
"'
N
N
'"
<6
I'-
'"
o
co
co
'"
'"
"'
ui
m
u
c
..
"
'"
'"
'..
..
'"
-
'"
o
'-'
'"
c
'C
c
w
!2
~
-J
~
0:(
~
-J
:;
....
~
a:
~
'"
c
'C
c
w
E
c
o
:E
"OJ!)
m c
"'"
rn 0
c u
rn u
:E<
""
~.~ ~I
iLE~
o
o
N
"'
.,;
<ii
o
"l
M
...
N
N
...
o
ui
'"
o
...
oi
iii.
o
N
N
N
tl3g8~
M..tOa)
",0 '"
co", N
(,,f(<)- m-
co - I'-
...
N
oi
co
N
ui
'"
'"
<D
coM
...
~~
'"
N
...
'"
o
'"
....
;;;
I'-
N
",iD
"'I'-
.....:....:
"'...
ON
00-
-
I'-
I'-
'"
N
'"
00
'"
co
<6
",5'
0'"
C"it--:
NN
"'N
0-
'"
'"
~
fR
N
<6
'"
"'
ui
0;1'-
row
ON
"'.-
~'"
N-
~
o
'"
l1.
'"
'..
..
'"
~
o
(J
Vi'
m
w
w
o
-'
~-2
.~ ~ '(ij
E"n; 8-
rn CJ m
UiW-oCl
c iil Q)-
o Q).~ .B
E .$ ~ "g-
:g.so::o
<
o
N
N
co
~
00
w
c
o
"'
'6
::l'
}9
o
I-
w
~ (ij
m w ~
u... Q) ~
- Q) lG-c
iti c l..L O)..c
,_O_CECrn5
Q) .~ ..c :>
u 0)"00 m
cu CO:.8~::e
~ eWe 0..
.:c (lJ:::::I (tl (ll
~~U(I)O
en
'"
'"
".:
"'
'"
..
co
'"
a
'"
"'...'"
Ol'-CO
<DNa:;)
000
I'-CO'"
m" ro-ai
"'''''''
"'......
cr"- 0"
... '"
N
...
o
'"
'"
'"
N
N
00
N
'" _0
"''''~
<ocr>O
CON_
co "'co
criOl-""
"'''''''
ONN
as 00
N N
I'-
'"
".:
'"
"'
a
"'
~
N
N
0"''''
"'NI'-
O'icria:i
Q3{Offi
l{)-o::i-.:;t-
"''''"'
~.--~
'"
...
"
"'
'"
oj
'"
co
<6
M~~
c.riC'i0'l
"'N_
",01'-
('f')-6C")-
"'I'-",
I'- co
CD- (!)-
co
"'
~
co
oj
'"
"'
N
I'-N'"
co'"
Mg;j~
O~N
cri (rf (0-
I'-N'"
"' "'
N- ,,,j
N
'"
o
"'
'"
a
'"
'"
<D
I'-"'N
"'''''''
~~8
","'N
C\i6ri
~co~
(!)- c.O
N
~
t:-
co
oj
ij5
ui
"'~"'
o coco
LricriC'"i
"'co'"
"'0'"
<01.{)"":
"'NN
'" "'
lli l("j
"
~
~
"
~
.
~
,,-
"
E
c
o
:E
~
o
't:
l1.
m
"
;;
>
';j
'"
~
..
:E
1:
m
E
-
'"
m
>
.E
E
c
o
:E '"
_ "
c "
f=:ti
~ 5 ~
():;;~
~~.g
- m...
~ t:,!!
~ '"
~ U ::J
"fiil~
I'IS ~ <C
:E m ..
...c.:
c-..
""0>
5 2 ti
'" u '"
~ 0 ~
.=<(:iiE
~?t
:Do>
0'"
00
f/!.?/..
NO
~ N
eo
f!.fI!.
<D <D
0'"
eo
'#-fI!.
"'1'-
N I'-
00
i
.
.
c
.
I
~
o
u
~
!
rn
"0
C
'" m
E c -orn
" .i!
Qi dl E
0:::0::.2
.2 ~~
:g'E"
't: 0-
o::E~
l1.
"'
o
o
N
j!i
rn
o
.9
~
m
>-
~
u
'6
.s
';j
'l!
~
j!i
~ rn
{io
c 0
m-
oo ro
o m
>-
~';f!.';!.
N"I""N
~cn'Ot
..... e. 0
(;j(/)?/..~fI!.;;!!.';/!.
.5~~~;~~
~5MNNNM
~:E
mN
>
<(
1il
rn w
-',s
m c
"'a
~:;;
~'"
<(
f/!.'?f!.?/..
N ~ N
~o"t
eo
!Ii
.
2
o
o
.
.
o
15.
.
o
..
>
~
.
" "
~ .~
.9 0
, ..
.;...: .g >
C Q. 5
~ Cf.l .~
~ ~ ~
. _ 0
9==&3
I
~';f!.;J!.
O<D'"
MO'"
e....:~
~
9
~
~
~::-!!
0"'
M 0
e.....;
IJ) tJI.{g
"O"Oc
ceo
ciS a5 CD ;,
t~~~~
~<3(9(9 IX:
C9Q.\E2~Ql
I- 1U ..... ,~ - E
>. C'J~"'O a.. ~
~~t~di~
~9~2~~
>" ....... (/) c: (/)
;c~58
E cu ro 0
J:: E E
~~ii
-'-,
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
March 31. 2006
FY06
MANAGED FUNDS
PORTFOLIO TOTAL
COMPOSITION COST CITY FUNDS
PERCENTAGE BASIS PERCENTAGE
DANA INVESTMENT ADVISORS. INC.:
Cash 3.33% 188,487
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 96.67% 5,465,394
Total 100.00% 5,653,881 11.25%
DUBUQUE BANK & TRUST:
Cash 10.31% 713,465
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 89.69% 6,209,156
Total 100.00% 6,922,621 13.78%
FIRST COMMUNITY TRUST:
Cash 1.86% 51,107
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 98.14% 2,697,736
Total 100.00% 2,748,843 5.47%
US BANK:
Cash 0.59% 40,888
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 12.12% 842,282
Federal Agency Obligations 87.29% 6,064,476
Total 100.00% 6,947,646 13.82%
GRAND TOTAL 22,272.992 44.32%
BREAKDOWN BY TYPE OF SECURITY:
Cash
Mutual Funds (US Government)
Certificates Of Deposit
US Treasury Obligations
Federal Agency Obligations
TOTAL MANAGED FUNDS
4.46%
0.00%
0.00%
3.78%
91.76%
100.00%
993,947
o
o
842,282
20,436,763
22,272,992
1.98%
0.00%
0.00%
1.68%
40.67%
44.32%
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
March 31, 2006
OTHER FUNDS
CASH
Change and Petty Cash Funds
Prescriptions & Workers Comp Deposits
COST
BASIS
FY06
TOTAL
CITY FUNDS
PERCENTAGE
Total
8,325
80,000
88,325
0.18%
CHECKING / SAVINGS ACCOUNTS:
American Trust & Savings Bank (General & Health)
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 (General/Metro/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 (General/Ambulance)
Premier (Utility)
Liberty (Utility)
East Dubuque Savings Bank (Utility)
State Central (Utility)
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
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
U.S. TREASURY OBLIGATIONS
FEDERAL AGENCY OBLIGATIONS
CORPORATE STOCK
Total
Total
1,410,900
509.101
978,199
153,958
1.951.708
1.691,170
30,949
68,758
26,436
20.628
21,132
16,171
2,348
6,881,458
13.69%
14,500,000
4,500,000
1,000,000
1.000.000
21,000,000 41.79%
0.00%
11,514 0.02%
27,981,297 55.68%
50,254,289 100.00%
MANAGED FUNDS OTHER FUNDS COMBINED TOTAL
1.98% 0.18% 2.15%
0.00% 13.69% 13.69%
0.00% 0.00% 0.00%
0.00% 41.79% 41.79%
1.68% 0.00% 1.68%
40.67% 0.00% 40.67%
0.00% 0.02% 0.02%
44.32% 55.68% 100.00%
Total
.
:t::
VI
o
C-
O)
C
.....
0) 0
;:j VI
tTO)
;:j-
..c nl
::J.~ ....
c:= ~
.....t<C
o 0)
>.u
::....
u 0
0)
"'5
"C
0)
.c
(,)
lJ)
Q) III
::l >.
... ..
~c
<C
o >.
_:!::
III ...
>.E
.. ..
:i;
'" '" '" N ~ '" a> '" CD a> '" 0 ~ I'- CD '" N a> 0 M 0 M ~
I'- a> '" M ~ '" I'- '" ~ ~ ": M '" .... <q M ~ I'- "": ~ 0 I'- '"
~ ,...: cD oi ... cD ... N CD N a> cD ~ ... CD ... '" N ~ CD ci a> M
CD N .... 0 .... .... a> a> I'- '" .... '" I'- M ~ .... 0 0 0 '" 0 M N
~ CD_ 1'-- CD_ ~ ~ N_ ~ CD CD_ a> 1'-- ....- 0_ CD_ '" O_ N 0 a>
III o.ri cD '" '" N m
E N ~ ~ a> '" '" '" CD '" .... N ~ ~ ~ '" ....
~ N N ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ '"
Q) N
~ '"
.5
~~IDro~ro~mroo~o~W~vomMN~~
O~~~~vvNNN~omooooW~NNN
N ~ ~
IDvNNf'--vNLOC\lOC>>M...-r--
M<DCDNO(DLOMCOCOCOvC>>
~ ~
T""OOIDMf'--vV"'-
......CO...-LOtO"'li'-.;tCO
'I""""...-N...-...-NN...-
~ ~~~~~~~~##~#~#######~#
e!NOOOOOOOOONOOMf'--OaCOOOoo
~~L()<D......M......O............N,....MVNLOOOM,....MOON...-O
_~MVL()L()VL(),.....<D,....,.....,.....,.....~OO,.....C>>C>>~~ ......
C v~~~~~~~~~~VVVVVVLOLO~~~
<0(0(0<0
QQQe
!~~oo
ns----
o;g~~:g
CD CD CD
000
- --
I'-M~
N ~ 0
- --
....I'-CD
000
CD CD
00
- -
'" 0
N ~
- -
"''''
00
CD CD
00
- -
1'-'"
00
- -
a> CD
00
CD CD
00
- -
N ~
N~
- -
CD'"
00
(OtO(OCO<DCOCD<DC.D
~a~~~~~~~
O~OOM...-MMN
t:::,.....o;:03m;::;::m
00 ......00.........-0
CD
o
-
....
C'?
-
C'?
o
LOLOLOLOLOLOLOLOLOLOLOLOLO<D<D<D<D(o(o(oID(o
!~~~~~~~~~~~~~~~~~~~~~a
nsOOONMO......NNoaN~OO~OOOO...-M
OmooaO;::;::;::;::NNNN;::;::......NMMMMM
0...............................................................-......000000000
o
o
0_
o
III ~
'iij
..
aI
00000000
00000000
00000000
ci ci ci ci ci ci a~ ci
00000000
0_ 0_ 0_ a~ 0_ 0_ 0_ LO
0000000000000
0000000000000
0000000000000
ci 0- ci ci ci ah 0 ah 0- ci ci ci ci
0000000000000
o~ 0_ o~ 0_ o~ 0_ o~ 0_ o~ Oh Oh 0_ O~
T""" T""" T""" T""" T""" T""" T"""
T"""T"""T"""T"""T"""T"""T"""T"""T"""'-T"""T"""'-
~~~
~~~
~
~~
~~
~~
:?
~
c:
o -"
+: c:
::lal~~~ro~~~~~aI~aI~aI~~m~~~~
~~~~~aI~~Q)~~~~~~~~~~~~~~
IIl0~~~~~~~~~O~c~c~~c~~~~
c:w~<C~~~~~~~w~w~w~~w~<C~<C
M
Q)
~ ... ~
.. Q) ~
!:!.Q <OO)NO("')v <OeD
+:E;;';~~~g;:~~~~o
...::Jo)OJOJlJ1OJOJOJOJlJ1OJ......
G.lZNT"""T"""T"""v N'-T"""("')
T"""T"""T"""T"""("') lJ1'-T"""
~ ~
~ ~
'" ....
~ N
~ ~
'" '"
~ ~
~ ~
lJ1 <0...... lJ1 a
lJ1o)OJOJM(",)
T""" lJ1 T""" T""" M N
lJ10lJ1lJ1OJlJ1
T"""VT""" T"""T"""T"""
T""" T""" T""" T""" T"""
~
MO....
CD I'- ~
I'- I'- '"
M M ~
~ ~ ~
o
o
o
<5
o
o.
~
N
...
III
ili
'0
~
~
.
I'-
'"
I'-
...
III
>.
..
C
I'-
"!
'"
~
-
;;.
~
';:
::l
~
..
:i;
"
Q)
~
.<:
'"
';;;
::
>-
u
z
w
"
'"
W
f-
<n
~
o
:J
o
<n
'"
w
'"
'"
z
>"
:J
o
lL
o
'"
f-
W
:::;
W
::J
o
::J
"'
::J
o
"
~