Investment Report Qtrly March 05
j
~~~JE
~<!N--~
MEMORANDUM
April 25, 2005
TO:
The Honorable Mayor and City Council Members
FROM:
Michael C. Van Milligen, City Manager
SUBJECT: March 31,2005 Quarterly Investment Report
Finance Director Ken TeKippe is transmitting the attached March 31,2005 Quarterly
I nvestment Report.
~~ ~/ ~
i'). .. . ... r1;
I, kJ ...,! V"-../
Mich~el C. Van Milligen
MCVM/jh
Attachment
cc: Barry Lindahl, Corporation Counsel
Cindy Steinhauser, Assistant City Manager
Kenneth J. TeKippe, Finance Director
---.
lU
i5~~~E
~<Ik-~
Memorandum
TO: Michael C. Van Milligen, City Manager
RE:
Kenneth J. TeKippe. Finance Director ~ J.c'~
March 31,2005 Quarterly Investment Report
FROM:
DATE:
April 21 , 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 January 1, 2005 through March 31 , 2005.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended March 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 March 31, 2005 & Fiscal 2005 YTD
Market Value I Unrealized
Carrying Including Gain (Loss) I
Description Value Accrued Interest Accrued Interest
Deposits, Change & Petty Cash Funds 88,150 88,150
Checking/Savings Accounts 4,263,291 4,263,291
Certificates Of Deposit 25,300,000 25,507,864 207,864
US Treasury Securities
Corporate Stock 11 ,522 59,458 47,936
Investment Advisor Accounts 21,542,809 21,648,126 105,317
Total Funds 51,205,772 51,566,889 361,117
Breakdown
City
Metro
Total Combined Funds
42,463,797
8,741,975
51,205,772
42,735,567
8,831,322
51,566,889
271,770
89,347
361,117
Net Earninas:
City
Metro
Combined
I Quarter I Year-lo-Date I
341,441 900,392
38,850 82,830
380,291 983,222
(45,170) (120,188)
- (3221
(45,170) (120,510
296,271 780,204
38,850 82,508
335,121 862,712
Cash Basis
Gross Earninas:
City
Metro
Combined
Investment Fees:
City
Metro
Combined
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
March 31, 2005
FY05
MANAGED FUNDS
PORTFOLIO TOTAL
COMPOSITION COST CITY FUNDS
PERCENTAGE BASIS PERCENTAGE
DANA INVESTMENT ADVISORS, INC.:
Cash 0.12% 6,777
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 99.88% 5,500,305
Total 99.88% 5,507,082 10.75%
DUBUQUE BANK & TRUST:
Cash 11.48% 760,359
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 88.52% 5,864,461
Total 88.52% 6,624,819 12.94%
FIRST COMMUNITY TRUST:
Cash 3.51% 93,773
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 96.49% 2,575,600
Total 96.49% 2,669,374 5.21%
US BANK:
Cash 3.23% 217,610
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 1.48% 100,000
US Treasury Obligations 6.25% 421,225
Federal Agency Obligations 89.04% 6,002,698
Total 100.00% 6,741,534 13.17%
GRAND TOTAL 21,542,809 42.07%
I CUSTODIAL ACCOUNT: AT &S BANK
CASH 0.00% 0
TRUST SAVINGS ACCOUNT 0.00% 0
MUTUAL FUNDS (US GOVERNMENT) 0.00% 0
CERTIFICATES OF DEPOSIT 0.00% 0
US TREASURY OBLIGATIONS 0.00% 0
FEDERAL AGENCY OBLIGATIONS 0.00% 0
TOTAL 0.00% 0 0.00%
BREAKDOWN BY TYPE OF SECURITY:
Cash 5.01% 1,078,520 2.11%
Mutual Funds (US Government) 0.00% 0 0.00%
Certificates Of Deposit 0.46% 100,000 0.20%
US Treasury Obligations 1.96% 421,225 0.82%
Federal Agency Obligations 92.57% 19,943,064 38.95%
TOTAL MANAGED FUNDS 100.00% 21,542,809 42.07%
Page 1
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
March 31, 2005
OTHER FUNDS
FY05
TOTAL
COST CITY FUNDS
BASIS PERCENTAGE
8,150
80,000
88,150 0.17%
1,115,697 1,115,696.94
1,142,797 1,142,797.30
96,761 96,761.29
1,007 1,007.22
1,790,017 1,790,017.45
73,145 73,144.79
13,009 13,008.68
11,018 11,017.91
4,423 4,422.59
14,185 14,184.56
1,232 1,231.96
4,263,291 8.33%
9,000,000
7,500,000
4,800,000
4,000,000
0
25,300,000 49.41%
0.00%
11,522 0.02%
29,662,963 57.93%
51,205,772 100.00%
OTHER COMBINED
FUNDS TOTAL
0.17% 2.28%
8.33% 8.33%
0.00% 0.00%
49.41% 49.60%
0.00% 0.82%
0.00% 38.95%
0.02% 0.02%
57.93% 100.00%
CASH
Change and Petty Cash Funds
Prescriptions & Workers Comp Deposits
Total
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)
Dubuque Bank & Trust (GO Bonds Stormwater Projects)
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
Total
U.S. TREASURY OBLIGATIONS
CORPORATE STOCK (lyons Peony Trust)
TOTAL OTHER FUNDS
TOTAL CITY FUNDS
I RECAP OF PORTFOLIO PERCENTAGES I
MANAGED
FUNDS
2.11%
0.00%
0.00%
0.20%
0.82%
38.95%
0.00%
42.07%
CASH
CHECKING / SAVINGS ACCTS
MUTUAL FUNDS (U.S. GOVERNMENT)
CERTIFICATES OF DEPOSIT
U.S. TREASURY OBLIGATIONS
FEDERAL AGENCY OBLIGATIONS
CORPORATE STOCK
Total
Page 2
,
al :2:28~ g~i8 s 0 ~ N CO NCO al
0 CO ~ 01 ,...~
It) "i 0 0.00"': lri~Mc:i 0 ~ .0 ~ .0 ,...:~ ~
S! <: -I ,... ~~ 10 OCOIO ~ M I:: g: ~~
~ .- III 0 t'? t'?~CO 0
..0- ~ N N ~!i:S. N N ~ ~ g~- cD
~ ~~ ....
10 10 ~ ~ CI CO
N ~ ~ N ....._t'? lO_
CI U N N N
:s ~ ~ ~
10 10 It) 10 10 10
i:iI a; 10 10 i i N ~ ;2; t'? coco ~
r:: I t'? t'? t'? 01 0110
'6 oj M M M M oj .0 N oi rOM N
r:: ~ I! I! 10 10 ,... M ~ 10 01 CO Ie
W co_ co_ N 01 coco
.5 ~ 6 6 :s :s ai lB- 1i t'?- 6,...- co-
co co co 8. .....0 ~
j co ~ co ,...N 01
0- 6 :s g:' M g:' 01-
t'? t'? N
~ ~:28 10 MM 8~ co 0 co t'? VN co
t'? o~ N 0 N 0 ,...CO t'?
~ ~I a; J::~o -i U'i~ 0.0 oi 0 oi .0 rO"': .0
<0_ oco ~ as 0 t'? NOl N
[ij'<: co_ v_~ t'?~ co t'? 1010 ~
<: is ~- ~ r::- ~~ 6 N N i IO-N aj
III 0 ,... ~ ~ ~ ~-~ ;2;_
::i:~
N N N N N N
iO iO --
01 COOl 10 01 01 10 ~:e N ~~
CO COOl co co co CO CO t'? ~ ~!i
!I 0 ,..:,..: .0 ~ N M M 0 ~o ~
~ gas ~ 0 t'? t'? 10 ,...~ a~
!e. 10. 10_ 01
.0 NM co- ~ ~ aj co- t'?- 6
~ ~ ~ r::- 1010 r::-
CO
cD cD cD cD co- co-
lB~ iO iO rn ~:2 --
10 co 18 18 a; ~~
V N co co ~9i
~ N"': S rO rO M M ~ M.o 0
~ :go! ~ ~ ,... ,... ~~ f8 st!Ei
CO ~ :!. t'? t'?
i -'g -I M CO cD ai ~ g ,.: co- M
.~ E 2 10 ~ ~ CO N~ ;2;
CO CO CO CO CO
:I u..~1- N N N N N N
w~ U
a~
~z
lOW ~~ M~ ~ --
~:I 0 ~ ~ ~ ~ ~;2; co :::e:::e
O~ ,... o~ ~ 0 ~~
~13 il N ~M rO .0"': N oi oi M ~N S
a; NO C;; ~-~ C;; a; a; t'? ~~ sa
CO_c co co
>~ ~- 10 ~ e ~ ~ ~- 01- ~N ~
e- N t'? ,...""
C)~ CO CO co co
cD cD cD cD CO- CO-
:I:
~ lOr::- s s
~ 10 co t'? t'? t'? S;~ 10 ~~
N CON t'? t'? t'? t'? t'? CO t'? ~r::
:I ~I oi .00 .0 ~ N N N M N"': g
10 OlN ,... 10 co co ~ ~~ ==
V CO 10 ~ e e 0 0 ~
M cDN ~- ,.: ,.: t! t'?-6 t
01 ~~ ~ 0 ~N
V 10 V v-
10- .0 10- .0 10 10
"' "'
~ !5
'C ~ (i)
"C 1U
<( E 2
1U ::l 0
15 CIl ~ j
I- ~ .t1
[ij'
I- "i <:
~ III
~ ~ OJ ::i:
::l ~
~ ... ~ i
... ~ E 10 B
0
~ (i) "C 5 J ~
~ r:: VI '6
"C ~ :i ii III
~ ... .5 ~ .5
~ r:: 2
... ~ ~.s::o >- 0 ..
~ ..0 ~
:i ::l or:: ::I6.:i "i .9
.Q 8 .... Il. C)::i:'" ~ i
5 "' :;
.... i Q. <: ~ III &_.2
8 j III ::I i Li Cl. >-
5 ~ cd ;! ii ~ l;l
j "' i >
~ 1U ... "' VI ~ > ::l VI ~ ~
~d.~ r:: Q. -;U::I
~ u.. ~ ~ ~ 'iIl Ui i)! E E 1U
c:: en .- ~
"t: 'E'~ ~ Ui~u..Sl~ ::I ~ ~ .a::lU
Il. C) 0:: 8
Ill"! ~ ~ ~ N~ ... ...<:::1 III 'al E
VI 00 W"i VI .s:: r:: r::-ii a: 0::.3
Ui 1Il_ Ojjj 1a C) III GI~> ,g i" &!
~ 5 Sl.~ 19 .{;I~~! ~ U C) ~ ~2-;
:e!!1! r:: 0-19
8 ~ 'al '6 III III g ~ i !5 0
"<:0:: .g UID Z
~- c: > }<(~ 1l.::i:1-
C) Ul W .5
III
~1;j
~o
55.9
1U ...
U ~
>-
.!!!
.Q
.!!
j
"
I
..
o
c:
-8
~
....
~
....
~ ~
Ill.!
III 0
~~
NCl..
~ .,
E
i5~
"'0:
III .
OJ .
~
~~ii';e-~~
o!;joo..
t; :Qf85'l~
ce..e..e..clli
;;!.";;t~~fIt.
,...~oo....v
e,g..-N\o....
~Qe.e.M
---
~~~~;;
........Nf81t)
=ste..eci
.
U) Cf.I "f/.l
"C"C"C
!5 !5 !5
ID ~ III ~.
.!Il~~~]j
="""1Il
III o III
~~~~'<:E
>- III ._ Q. .<:
1ll~I-"illiQ.
06,5~E-
~~t5_iil~
\ij <:.5 !58
EIll<:U
ii E ~
..J~ii
..J
~~
III !5
;::i:
>N
<(~
11 "'
..J.s::
III 6
f::i:
>t'?
<(
..
'iij
o
Q.
CIl
Oil)
CIlog
~UlN
CTCIl
~..~
.a CUM
~,~ ~
O~O
....1::..
o CIl CU
~()::E
,- 0 '0
().!!~
~
'C
CIl
~
o
UJ
'CUi
! !
.. CIl
0..
:i.5
'C
CIl Ul
~ >.
.. CU
00
:i
.s~
Ul ..
>..a
CU CU
O::E
..
Ul
!S
CIl CU
..0::
.5
..
Ul..
! c
CIl CIl
:5 E
>.
CU
D..
..
Ul
~
~
'C CIl
~..
.. CU
cuO
::E
CIl
Ul
CUS
~ CU
~O
~
D..
Ul
~ ,-
o Ul
()~
'C
CIl
Ul E
CO 0
~ ..
~u.
~
D..
CIl
.. ..
CU CIl
O.a
!E E
1:: ~
CIlZ
o
~M~MmNOOOO~~~~~OO~Mv~~~~M~~~O
~~MmNooqq~~~~mooom~~~~~m~N~q
v~OO~~NOOOO~M~~~OO~~~OM~N~O~~O
~~~voo~~~~mmM~N~oo~~O~MM~m
~~~~~~~~MOOM~NmMovvNOOM~OM~
~vo~~~~~ooomm~~~~~~~~~N~
~~~~~~~~""-""-T"'""
~OOMOOMMOOO~~~~MmmM~~om~~v~o
~MO~~~~~~vvvN~mmoo~~~vvN~
C'\INC\.IT"'""T"'""~T"'""""-""-""-~~~T"'""
~~m~vNNmN~~~vM~O~Nvoomo~oom~
Mv~M~N~vO~ OOMNm~~~moov~~oom
N ~ ~T"'"" .,..-.,..-.,..- T"'""T"'""C'\I.,..-.,..-.,..-
~~~~~~~~~~~~~~~~~~~~~~~~~~
OOOON~OOOOOO~OO~~~O~~~O~OO
~~OMMM~~Nom~~O~~~~NN~NMMMN
~Nv~~~~~~~~~~mq~qoNo~~~~~~
NNNNNNNNNNNNNNMNM~~~MMM~~M
vvvvvvvvvvvvvvvv~~
000000000000000000
~~m~mmNN~~OO~~NN-t::~
---~~~NN--~~NNNN ~
~oomOOOOO~~~~~~NN~~
.,..-.,..-.,..-.,..-.,..- .,....~.,..- T"'""T"'""
~~~~~~
000000
-- -- '"'- '"'- -- ---.
mooooo~
.,..-N.,..-.,..-T"'""T"'""
;:;::C\iNMM
~ ~
00
--
v~
NM
--
MM
~~~~~~~~~~~~~~~~~~~~~~
QQQQQQQQQQQQQQQQQQQQQQ
~~m~v~~ooNv~~M~vmoo~~~~oo
QQ~~QQQQ~~~Q~~Q~Q~QQQ~
v~~~~~~~~~~v~oooo~m~m~ooo
OOOOOOOOOOOOOOOOOOOO~O
~~~~
0000
---. ---. -.... --
M~~M
o~o~
-... -- -.... --
~moo
~OT"'""T"'""
vvvvvvvvvvvv
QQQQQQOOQQQQ
oo~mvmmNN~voo
QOO~~~NNOO~~
~~mooooo~~;::;::
OOOT"'""T"'""T"'""T"'""""-T"'""T"'""T"'"""""
~~~~~~
QQQQQQ
~Mmoooo
O~~N~~
;::~:;::~NN
000000
~~~~
QQQQ
o~v~
~~NM
-... ......... ........ --
MMMM
0000
vvvv
0000
......... -- ......... --
vOONN
NONN
;::C\;NC\i
.,..- ~ ~ T"'""
00000000000000000000000000
00000000000000000000000000
00000000000000000000000000
00000000000000000000000000
00000000000000000000000000
qqooqqqqqqqqqqqqq~qqqqqqqqq
~ ~
T"'""T"'""""""(""""T"'""T"'"" T"'"""""T"""T"'""T""" T"'""T"'""
.,..-.,..-.,.....,....~T"'""T"'"".,..-T"'""
- -_::E ~
~~~~~ ::E ~ ~~~ 6 ~
~~~~~~oooo~~~oo~}oo~~~oo~}oo~~oooo
~~~oooooo~~oo~~~~~~~oo~~oo~~~oo~~
DDDOOO~~ODD~~~~~O~~O~~~O~~
~~~www~~w~~~~~~~w~~w~~~w~~
~
v~
vOOMOO~~~NOOOO
~oo~m~~~v~~~
MMvNMMvvMvv
NNN~~~~~~NN
~~~~~~~~~~~
m~oo~
NNOOO~vM N
~~~~OO~~ov
v~~v~~~~~
~OO~O~~M~
~vv~v~~v~
~ m ~m
o M~~~
mvoovoooo
~NvOOvv
OV~~~~
vV""-"""""-T"'""
CD
Il)
M
CD
CD
....:
o
N
.".
o
o
o
o
o
M
an
N
.".
Ul
'ii
..
o
~
~
o
~
~
CD
N
'C
Gi
>=
'C
S
~
Cl
';
~
10
o
o
~
N
~
iIi
'l;j
o
c
it
Ul
>.
cu
o
M
en
.....:
o
~
i-
'C
~
..
CO
::E
'C
CIl
..
~
Cl
';
~
>-
()
Z
w
C9
~
w
~
00
~
~
9
...J
o
00
~
UJ
ex::
~
z
~
~
:J
o
~
o
ex::
~
w
::E
w
=>
o
=>
~
=>
Q
II
~
-