Investment Report - Qtrly 9 30 06
THE CITY OF ~
DUB E
~ck~
MEMORANDUM
-,
October 27, 2006
TO: The Honorable Mayor and City Council Members
'"
FROM:
Michael C. Van Milligen, City Manager
SUBJECT: September 30, 2006 Quarterly Investment Report
Finance Director Ken TeKippe is transmitting the attached September 30,2006
Quarterly Investment Report.
(l1tvI4"Y]/Zzlt _
Mict'Jael C. Van Milligen
MCVM/jh
Attachment
cc: Barry Lindahl, City Attorney
Cindy Steinhauser, Assistant City Manager
Kenneth J. TeKippe, Finance Director
D~~~E
~c/k.~
Memorandum
TO:
Michael C. Van Milligen, City Manager
FROM:
Kenneth J. TeKippe, Finance Director
~ J-. ([ru1:/lLf
RE:
September 30,2006 Quarterly Investment Report
DATE:
October 26, 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 July 1, 2006 through September 30, 2006.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended September 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 September 30, 2006 & Fiscal 2007YTD
Market Value / Unrealized
Carrying Including Gain (Loss) /
Descri tion Value Accrued Interest Accrued Interest
Deposits, Change & Petty Cash Funds 93,300 93,300
Checking/Savings Accounts 9,788,237 9,788,237
Certificates Of Deposit 20,500,000 20,927,730 427,730
US Treasury Securities
Corporate Stock 11,514 75,509 63,995
Investment Advisor Accounts 22,555,637 22,666,453 110,816
Total Funds 52,948,688 53,551,229 602,541
Breakdown
City
Metro
Total Combined Funds
43,772,082
9,176,606
52,948,688
44,202,648
9,348,581
53,551,229
430,566
171,975
602,541
Cash Basis Quarter Year- To-Date
Gross Earninas:
City 391,888 391,888
Metro 88,518 88,518
Combined 480,406 480,406
Investment Fees:
City (35,664)
Metro 152)
Combined 35,816
Net Earninas:
City 356,224 356,224
Metro 88,366 88,366
Combined 444,590 444,590
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
September 30, 2006
FY07
MANAGED FUNDS
PORTFOLIO TOTAL
COMPOSITION COST CITY FUNDS
PERCENTAGE BASIS PERCENTAGE
DANA INVESTMENT ADVISORS, INC.:
Cash 1.88% 107,777
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 98.12% 5,637,996
Total 100.00% 5,745,773 10.85%
DUBUQUE BANK & TRUST:
Cash 9.34% 649,773
Mutual Funds (US Govemment) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 90.66% 6,305,459
Total 100.00% 6,955,232 13.14%
FIRST COMMUNITY TRUST:
Cash 3.83% 107,254
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 96.17% 2,689,621
Total 100.00% 2,796,875 5.28%
US BANK:
Cash 2.95% 208,033
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 7.09% 500,289
Federal Agency Obligations 89.96% 6,349,435
Total 100.00% 7,057,757 13.33%
GRAND TOTAL 22,555,637 42.60%
BREAKDOWN BY TYPE OF SECURITY:
Cash
Mutual Funds (US Government)
Certificates Of Deposit
US Treasury Obligations
Federal Agency Obligations
TOTAL MANAGED FUNDS
4.76%
0.00%
0.00%
2.22%
93.03%
100.00%
1,072,837
o
o
500,289
20,982,511
22,555,637
2.03%
0.00%
0.00%
0.94%
39.63%
42.60%
Page 1
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
September 30, 2006
OTHER FUNDS
CASH
Change and Petty Cash Funds
Prescriptions & Workers Comp Deposits
Total
CHECKING / SAVINGS ACCOUNTS:
American Trust & Savings Bank (General & Health)
American Trust & Savings Bank (America's River Bonds)
American Trust & Savings Bank (Stormwater 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
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
Total
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
MANAGED FUNDS
2.03%
0.00%
0.00%
0.00%
0.94%
39.63%
0.00%
42.60%
Page 2
COST
BASIS
8,300
85,000
93,300
1,756,756
438,618
131,145
211,538
2,574,095
1,087,703
56,408
208,942
10,395
24,701
4,656
2,871,000
390,524
18,837
2,919
9,788,237
11,700,000
4,800,000
1,000,000
3,000,000
20,500,000
11,514
30,393,051
52.948,688
OTHER FUNDS
0.18%
18.49%
0.00%
38.72%
0.00%
0.00%
0.02%
57.40%
FY07
TOTAL
CITY FUNDS
PERCENTAGE
0.18%
18.49%
38.72%
0.00%
0.02%
57.40%
100.00%
COMBINED TOTAL
2.20%
18.49%
0.00%
38.72%
0.94%
39.63%
0.02%
100.00%
~
:Ii
:Ii
w::>
::>.,
01-
::>z
lOW
::>:Ii
CI-
"-.,
o~
~~
->-
u....
:I:
I-
Z
o
:Ii
'"
o
o
.,
;;;
o
"
~ -\
._ ro
~ -
E 0
01-
U
0,
o
'6
o
w
=
o
o
:Ii
z.
;;.~ ;;1
.= E 2
"-EI-
o
U
!
" 00\
ID-
",0
ro '
00
ro 0
::;.:t
!I
il
~I
!!.!
~
...
~
'" "'
~ 'E
., 0
~ :Ii
... is
., "
o ..
u .~
ro
10
.
o
U
.,
~
'"
'"
'"
<<i
'"
"'
or
~
1.0;::'00:1"
1"--.......0(0
Mccicilt'i
"'~ .,
"'0 '"
triM N-
"'- '"
'"
'"
ci
;:
.,.;
'"
.,
ci
.,
'"
'"
ili
v
<<i
~
'"
.;
'"
"l
;;
~
or
'"
1'-.;::-0<.0
00.....01'--
cOccic:icci
"'~ .,
vO v
ai M co.
"'- '"
'"
'"
'"
.,
.,
<i
~
o
'"
",f':
.,.,
cicci
.,-
o
<i
'"
~
0;
'"
~
~
or
00
"!~
~r:::
0'"
00-
'"
~
~v
"'-
cO...;
"''''
~O
0:;.....-
'"
;:
'"
.,
'"
<<i
'"
o
<ci
'"
'"
'"
.,
~
.,.;
~~
r-.:ai
"'~
"''''
MM
"'-
-.;
ID
00
00
o
Ul:::::!.Ul
.~ ~~
E 'tij 0
ro(!) g.
j,jUJ-co
c1i):!:lro
~ ~~.B.
:c~&a
II
",Moom
M"<tOOr--.
c:icriciom
0_ ~
"'''' '"
NN .q:
=.-- :::.
'"
'"
ili
'"
<<i
"'
'"
'"
'"
.,
~
:;:'c;;
~v
cim
~~
"''''
~ci
~
'"
ci
.,
o
<i
o
'"
'"
'"
.,
'"
~
'"
'"
V
'"
.,.;
'"
$;;:-
"'-
c:icci
co<<;
ci--
'"
'"
.;
'"
~
'"
NO)
"'"'
aid
~'"
O~
~--
00
o
o
~
'6
"
<:
]i
o
I-
00
~ ~
~~Ul~
in ljiu.. ~E
6 ~.ffi ~ s:
ngB~~
~ C III C c.
~~8~J
.,
"'
"'
'"
~
"'
~
<ci
'"
'"
"'
'"
'"
'"
.,
~
0;'
o~
ci6
'"
o
or
"'
"'
'"
~
"'
~
<ci
'"
'"
M
o
'"
'"
v
~
;::
ci
'"
'"
to
00
o
o
U
~
:E
,
</)
"
"5
I-
"'
~
.,.;
0;
ili
'"
or
~
'"
o
.;
~
~
'"
.,
v
ci
.,
'"
'"
'"
.,
'"
.,.;
~
~
or
'"
'"
'"
<ci
~
~
'"
~
o
'"
;;
<i
~
"'
<<i
'"
~
or
"'
'"
N
.,
'"
.,.;
~
'"
<<i
;;
'"
~
~
.n
v
~
.,.;
=
o
o
:Ii
C
.
t
,
u
00
;;
ro
10
.
o
U
;,
o
.;
'"
~
<<i
'"
;,
o
.;
'"
~
<<i
'"
o
o
ci
-.;
C
ID
E
ID
~
,
~
00
e.
'"
00
0.
;;;
o
ID
0:
"'
00
ro
U
0;
Z
~
'"
"'
'"
00
v
'"
or
~
~
o
ci
~
o
'"
'"
.,
ci
.,
'"
v
'"
.,
'"
.,.;
~
~
or
'"
'"
'"
<ci
'"
~
'"
~
o
'"
;;
<i
~
'"
<<i
'"
~
or
'"
'"
N
.,
'"
.,.;
~
'"
<<i
;;
'"
~
~
.,.;
v
~
.,.;
o
o
o
.
..
10
.
.;;
.
10
.
o
U
0>
o
'6
o
w
!!.!
~
...
~
'"
!!i
...
;::
...
~
:Ij
"'
c
o
:Ii
~
o
.0
..
.
,
..~
>'"
_ro
~ ~
..:t
:Ii~
'E.E
~al
tj~
0-
~~
'"
~
<i
'"
'"
~
v
.,
'"
~
., ~'"
~.,'"
aicriaj
"'''''''
~"''''
r-: M.....~
~.,~
"''''~
c-.f M
~ ~
;;
'"
.,
~
'"
o
'"
o
.,
"'~~
~:g:ri
C!~~
f'--.,.... ~
~"''''
v"''''
ci ci
., .,
;::
'"
'"
o
o
v
~
or
'"
_ o~
.,"'~
..tcOM
~"'~
~"'v
o..ocO
"'0'"
"'''''''
N N"
'" '"
'"
o
'"
'"
'"
'"
'"
'"
<<i
~~:$
~gg
~ "'~
NOM
~"'.,
'" 0
cO r--:
'"
'"
<i
~
'"
U;
~
'"
","'v
.,"''''
It'icciM
~"''''
"'''''''
M o:t-oi
v"''''
~ ~
N N
~
~
'"
a;
'"
'"
o
~
~~'"
"''''~
MaiM
"'''''''
~ "'0
N"alN'
~"'v
o
r-: 1'-"
0;
N
o
~
o
'"
'"
.,.;
o"'~
~~'"
t":ir-.:o
"'~'"
"'~'"
"':cic-J
"'.,'"
'" ~
vi 1(')-
=
o
o
:Ii .!!
_ ro
i..c2
t_O
:::J l5:i
U::; ~
~ co2
ii ~-g
:: U'.
. ,
"S ~~
::E (ua>>
_ c.2
0-.
0">
E ~Q1
if u..:.:
> 0 ~
.5 <C~
';;t.'J!.
..~
"''''
ON
:::t~
~m
"'-
OM
~~
7!~
ON
~';t.
- -
"'N
OM
C
ID
E
;;
ID
>
"
>-
~
"
-"
,
~
E
o
~
ro
"
o
. ID
E E ro
.a ::10
G> n; E
D::: __ ex: B
o ~ >>Ill
:=11l:COC
.g g>cro
"t:co"O
~~::21-
'"
o
o
'"
ID
ro
o
B
ro
~
iJ
~
s
~
:l1
$~'$.';/!.'J!.';/!.';/!.
'-(tIIt'l.........MMIt'l
(lIOItJU>....OlIt'lN Ul
-gOMNMNNccito~
~::: ~~
o~ <'7':
>- OI.g
0,,-
";"';lIl
o E
00 ,
ro_
~&:
~:
Ul 'J!.';J!.';/!.';j!.';j!.
~:sg:;;~~:€
11l5..tMMMN
i?::;
ID'"
>~
<:
III 'ot'*';ft.'*'*
~.s~:7!~~P;;;
Q)C.....MNNO
"'0
~:Ii
~.,
<:
fJl fJl.fJl
"""
5 5 5
lIllIl!Ilx
. 5....;.g;.Q)
fJl~o~E<<i
ffi(!)C)C)~~
~ $! E $!'c E
>,C'C Q).!!!O-'l::
C'C Cll-"O L..O-
o ~t: ~ ~"E
o Cl.,8 L..:J Q)
0'l<U)~~~
~ffi~8u
E E ro
1515~
""""0
....
-
"in
o
Co
Gl
C
...
Gl 0
::l III
C"Gl
::l-
.c ~
5!Eo
...t::~
o Gl
~~
() 0
..!
::l
"
Gl
.r:
u
III
N~~ONNIDONNM~M~roNomM
~~NM~N~~~M~~~m~~~NID
~ ~~~woooomo~~~oo~Mci~~MOO
~ m~OONOID~NMM~~M~~O~N~
~~~q~~~q~~~~~~~~~qq~M
~~M~m~MmOO~IDM~NN~OOOOO~N
~SMN~MN~NN~N~NNNN~~~~
.5
-
" ;;:
GlIllN
::J '"
Ii co
..,0
c(
-
O~U">
- .-
III ~
",.a
CO CO
0:;;
f--
OOIDMM~U">oovM~mIDmoooo~om~M
~MMIDMOm~ID~U">U">~MNNO~U">N
~~N~~N~~~~~~~~~~~
NIDMmN~~OOOOU">NIDMov~oom~M
~NMMU">mIDmm~OOmO~NMMU">OO~
'1""""'1""""'1""""..............-.........-
~ ~~~#~~~~~#~~~~~~~~~~~
~SO~OO~OOOOMONOONaU">oooo
~mMM..-~mNN..-mOIDU">Noo~mMN..-N...-
S~~..-Mm..-M..-...-MN..-NMNMMVU">~~V
= v~~~~~~~~~~~~~~~~~U">v~
CQ
o
-
o
M
-
c>>
o
r---COCDCD
~ QQQ
'i:S:g~~
='cu---~
n;co~o
:E ...--."'-
f--
Gl
III
CO
J:
e
::J
II.
f--
00000000000
_ 00000000000
lI)eI)OOOOOOOOOOO
o 'en 00000000606
(Jraooooooooooo
m qqo_qo_qo_qo~o~r---
.........-.,.-...-.............,.-.,.-............
c.otOCOc.o
0000
NCi3;::o
00 N C"')
----
.,.-............ ...--
...-.,.......- ......
CDCOr---"'''''''''I''--f''''-t--.......r---.......
oooooQoQeee
~;::~;::Ci5...-Ci3l.OroLON
~N~e~~ee~eg~
"I ~ ~ ~ "I "I "I M ... ,.~
~~ooooooooo
CD CD
ee
to to (0 to (0 to to
t>>eeeeeee
1G~eC::~~~~
O;::"d"iDC\j:;;riDM
0000000
to to (0 to to to to to to to (0 (0
oooooeeeoooo
tocooto:;a:,....-.;;tLOiD;::NM
~e~e~~Q~~e~~
M (0 "d" "d" "d" "d" LO LO ...~ (0 (0 ,....
000000000000
"'....'"
00'"
<ciaid
r--OM
N....r--
Lri' M,....~
N
~
CD CD
00
--
or--
~ 0
--
CXlOl
00
00000000000
00000000000
00000000000
cicicicicicicicicicici
00000000000
qqo~o~o~o~o~o_co 0 U')
~~~~~~~~ ~ci
'"
....
Gl
- ~
ca G) CJ) en
u~~ tOLOMCJ)""'LOCJ)-.;;tO "1M ~LOLOCJ)
;E"d"CJ)COLOCJ),....COMc.oeN,....LOCJ)COON~~LOLOB
~~~~~~~~~~~~~~~~~~~~~~~~
-
~
--
l:
o ~ ~ ~
+:t Q) Q) Q) __
::J~m~~-~~~~-~m~~m~-~€mm
;~~~~~~~~~~~~~~~~~~~~~
IIl~O~~~~~~~~~O~~O~~~DOO
.5~w~~~~~~~~~w~~w~~~~ww
-
~
~
~
~
~
~
~ ~ ~
~ ~ ~
~ ~
~ ~
~~~
~ ~
'#. M
r-- Cl
~ an
.n GO
"
"ii
>=
"
Gl
-
J:
Cl
"Gj
3:
en
'"
CO
o
l:
~
.;:
::J
-
CO
:;;
"
Gl
- >-
"5,ll
"a; ~
3:'-"
<:
w
f-
~
;;:
"
:J
o
(f)
<:
w
'"
<:
z
<:
f-
:J
o
a.
o
'"
f-
W
::;
W
:0
"
:0
Cll
:0
"
"
~