Investment Report, Qtrly, June 05
.
DU~~E
~~~
MEMORANDUM
July 25, 2005
TO:
The Honorable Mayor and City Council Members
FROM:
Michael C. Van Milligen, City Manager
SUBJECT: June 30, 2005 Quarterly Investment Report
Finance Director Ken TeKippe is transmitting the attached June 30,2005 Quarterly
Investment Report.
~~~
MCVM/jh
Attachment
cc: Barry Lindahl, Corporation Counsel
Cindy Steinhauser, Assistant City Manager
Kenneth J. TeKippe, Finance Director
..
,
D~~%&uE
~Vk.~
Memorandum
TO:
Michael C. Van Milligen, City Manager
~J,~
FROM:
Kenneth J. TeKippe, Finance Director
RE:
June 30, 2005 Quarterly Investment Report
DATE:
July 20,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 April 1 , 2005 through June 30, 2005.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended June 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 fjg
Enclosures
CITY OF DUBUQUE
Cash, Investments and Investment Earnings Summary
For The Quarter Ended June 30, 2005 & Fiscal 2005 YTD
Market Value I Unrealized
Carrying Including Gain (Loss) I
Description Value Accrued Interest Accrued Interest
Deposits, Change & Petty Cash Funds 89,225 89,225
Checking/Savings Accounts 12,318,917 12,318,917
Certificates Of Deposit 23,500,000 23,726,928 226,928
US Treasury Securities
Corporate Stock 11 ,425 58,283 46,858
Investment Advisor Accounts 21,749,872 21,973,093 223,221
Total Funds 57,669,439 58,166,446 497,007
Breakdown
City
Metro
Total Combined Funds
48,745,594
8,923,845
57,669,439
49,174,142
8,992,304
58,166,446
428,548
68,459
497,007
Cash Basis
Gross Earninas:
City
Metro
Combined
I Quarter Year-To-Date ~I
455,560 1,355,952
65,837 148,667
521,397 1,504,619
(30,698) (150,886)
(261 ) (583)
(30,959) (151,469)
424,862 1,205,066
65,576 148,084
490,438 1,353,150
Investment Fees:
City
Metro
Combined
Net Earninas:
City
Metro
Combined
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
June 30, 2005
FY05
MANAGED FUNDS
PORTFOLIO TOTAL
COMPOSITION COST CITY FUNDS
PERCENTAGE BASIS PERCENTAGE
DANA INVESTMENT ADVISORS, INC.:
Cash 0.49% 27,188
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 99.51 % 5,511,709
Total 99.51 % 5,538,897 9.60%
DUBUQUE BANK & TRUST:
Cash 5.45% 365,855
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 94.55% 6,348,254
Total 94.55% 6,714,109 11.64%
FIRST COMMUNITY TRUST:
Cash 2.38% 63,915
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 0.00%
Federal Agency Obligations 97.62% 2,624,039
Total 97.62% 2,687,954 4.66%
US BANK:
Cash 7.30% 497,049
Mutual Funds (US Government) 0.00%
Certificates Of Deposit 0.00%
US Treasury Obligations 9.20% 626,124
Federal Agency Obligations 83.50% 5,685,738
Total 100.00% 6,808,911 11.81 %
GRAND TOTAL 21,749,872 37.71%
BREAKDOWN BY TYPE OF SECURITY:
Cash
Mutual Funds (US Government)
Certificates Of Deposit
US Treasury Obligations
Federal Agency Obligations
TOTAL MANAGED FUNDS
4.39%
0.00%
0.00%
2.88%
92.73%
100.00%
954,007
o
o
626,124
20,169,741
21,749,872
1.65%
0.00%
0.00%
1.09%
34.97%
37.71%
Page 1
t
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
June 30, 2005
OTHER FUNDS
COST
BASIS
FY05
TOTAL
CITY FUNDS
PERCENTAGE
4,500,000
3,000,000
2,000,000
23,500,000 40.75%
0.00%
11,425
0.00%
35,908,142 62.27%
57,669,438 99.98%
MANAGED OTHER COMBINED
FUNDS FUNDS TOTAL
1.65% 0.15% 1.81%
0.00% 21.36% 21.36%
0.00% 0.00% 0.00%
0.00% 40.75% 40.75%
1.09% 0.00% 1.09%
34.97% 0.00% 34.97%
0.00% 0.00% 0.00%
37.71% 62.27% 99.98%
Page 2
CASH
Change and Petty Cash Funds
Prescriptions & Workers Comp Deposits
Total
CHECKING / 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)
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
9,225
80,000
89,225
0.15%
1,653,328
1,269,479
1,131,966
316,197
1,001
1,125,196
2,493,649
4,267,436
20,670
12,996
8,628
16,945
1,426
12,318,917
21.36%
14,000,000
Total
U.S. TREASURY OBLIGATIONS
CORPORATE STOCK (Lyons Peony Trust)
TOTAL OTHER FUNDS
TOTAL CITY FUNDS
I RECAP 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
m i 0 &,;:o-~ (")
::l z (,,)OJ(")~6- i
a.
:r !l III ! C III : lIlaa.
r 'E. "" !!l. .! 'E'-~f f
Ul &> iir N' II
(") 9[(")~~ ~ i!!~!I! '"
i ::r in ~l~ g in
;:0 (") QIll "0
f ~ c [lli~!I! Ill. 3 :L
;; ::l -' ~
'" m. 1 i ~~~
in "0 ::l f
It r-
.. !il g
f Qo f '"
'" ~
Ai '0 !
::l ~ '"'l
Q 1ir ~
l:T
C
~ en
en
~ ~
g ~
r-
~
en
-f
9-
!l!. -f
(J) 9-
C !l!.
S?: 6:
~ g
~r 0
"
'" '"
en en en
0. 0. 0.
~ ~ -" 0iCi3 ~ i
0. ~ Ui Ui ~ :'w ~
~ en en --I ~!Z ~
--I W W cD -"
:..... ~ 0> 0. 00> :..... Z
-" --' ~ cD ~N cD -I
:r
01 01 01 !((")
':...j ':...j -." -=I
~ --' N -~ cD ~ ~-<
~ W -"
:.. 01 ~ 15 cDW c.., m~
0 ~ -" gg ~
cD 0 0 --I -10
~ c... 0. 0. ~ io~ t I:C:
--I .$ .$ cD ~--' mID
ZC:
N N N (") -Ig
~ &l -."
~ t[~" ~m
--I CD CD I:
Co Co ~ ~ :.. -:::J' N 23-'
en UI UI CD'R :;j "'cia ~
CN W CD --101 ::l
io io 0 0 ::J .3!k :..... ~
N N ~ ~ CD
01 01 01
~ ~ CN CN ~ I~
CD UI UI W
~ Co ~ ~ -." -:::J&l Co
--' -" ~ ~
--' --' en UI N OCN
~ ~ :..... :..... ~ 0.0. c... ""
~ ~ ~OI 01
~ ~ ~
':...j '~ "g: I>~
~ ~ 1'> CD Oi~ ~ ~
cD cD 0 --'
0. 0. --' ~ ~~ ~
--I ~ cD cD ::lCC
--' 0 NO NO CD 0--'0 ~ It!!
::J 8 ::J ~g i->o 0. ok:r..
~o cD o_w --I
CN Ui ~ ~ ; f
t1I 0 0
Co ~ ~ --' --' 0. ::l
--' ~ ~ Q) 01 --' ~
cD ,01 en en t1I ~
8: --' "g: N N ~ ':...j :.. ~ m
--' 0 0 ~ ~ ::l
01 N CD CN CN --' --' -" Cl a.
0. ~ io 0. ~ :..... ~ :..... 01 3'
cD en ~ 0 0 CN '!=!
~ Ui 01 01 (") g:
N N
[$ 0 ':...j N N :,.. I~~ w
t1I N 01 'i:"N ~ ~UI CD
,01 en 01 OICN t1I Q
e --' 0. c.., ~~ 0 Coo 0. -::l C$
--' en (0 0(0 :g N--' en !! en
CD N 0 ?' OCNNO O--'N 01
a. ~ ~ --' oo.i->g 0. o~:" c...
en N ~ o~~ (0 O_CN 0
,
~
~
~
~
r-
Iii
~
~
r-
~
en
3'
~
'"
g
'"
::l
..
J
[
~
i:
'"
"0
:L
o
...
I:
o
~
)>
.9:
c
'"
[
Q'
~
2
!l!.
~
UI
0.
o
(0
o
--I
W
~
01
Co
~
~
UI
o
--I
N
-."
~
~
en
0.
UI
Cl
':...j
(0
--I
Co
(0
--I
~
~
~
o
:..
~
--'
UI
01
c.>
o
N
c.>
-....
8
c...
01
~
--'
--'
--'
CN
~
N
--'
1:>3'
D1Cl~
~ Cl '"
!l2 g
<~'"
!..:ri
;~J
>ll;.
~o!l
~ C <
'" 3 DI
a.~i:
"'-Q>
~~(")
1:'Sc
n:r~
2 a.
~ f
::l
~
U1~ Ul
0. :,..
--'N(o
(0-"0>
t~~
oWaJ
o~i->
ONCD
-f~"O
a- g ~
--~
;:oS: -
!l ~ 0
~fS'
(")cE'
!!i,33
!!l III
~ I
m -g
S [
Ii? ~
;- 5"
N ~
8 -
Ul 3
~
~
~
!
-"Q
U,N
CQQ
~~
i~
!i!:
Ii
r-
!-!r-
33!-
III 3
~~~!~
"'",-0><0
~ ~ ~ ~l& ~
:;; ~ ~ -f~ ~
::l. -0 iii' 1I/ !l!. -f
3~ii30lm
01 2 G>QG>s:
~:r~~~'"
Ol c.. .
'~OJOJOJ
g g [
~6trA
.
~
~J
-" N -" '" elg Ol
I~~~~i
;/.;/.;/.;/.;/. i
Cl 01
Co 0.
CNOI--I
~ow
1B~~
oWaJ
t.>o.o.
--IenN
N N
-." -."
CD-"--I
<o--IN
~~~
U1NN
WOIaJ
ioioio
ClCDO>
-"Q
WN
CD--I
~;!.
aJ~ 01
0. ':...j
~~~
CD~W
OcD--'
(OW 01
:r..i->i->
U1U10
~ ~
10.......0,
--IUl--'
w<ow
~Rl8:
W--IUI
~o.io
CDOO>
CN~ W
01 Ul
~~~
WaJaJ
c..,<o:'"
~Sl~
:r..:r..io
--I CD <0
en Ul
~I~~
0101<0
t~Co
--I~:g
i->i->io
U1CD--I
.... Q
WN
CQ CD
"ift.-.e.
-"Q
NW
enQ
:/!.~
:~
:tlQi
!!till
~ Co
Co~
~
~S -<
o~ lB&'
iil' tII :. ii'
CD 'I'" -" -" Q ~ -" 0 ::l
Co NU,a.q,CQNOg.
tJlN ....WID!!.~
i;/.;/.~;/.;/.;/.Ol
CIl
a
i
::l
o
...
III
Ii
i
~
III
--'~
~J
~ 1" ~ ~ ~Ig 01
~:~==rIr-
~';/!.';1.~';/t. t!
,
...
en
n
:7'
<D
a.
~~
o 0
o .... -.
~o~
C <D 0
:s::1....
<D -. e
=C
(j.)n
OmCT
w _ C
N<D.Q
OUlC
00<D
Ut....
e
<D
"t'J
o
UI
::+
~
'l.' -f ......CJ'1CJ'1............................................................~........................~..................CJ'1...... Z~
......~~............~..........................................O........................O..................~......C
o a .....O'>O'>~~w.....~~~~~~.....enCJ'1...............~~O'>~O'> 33:
C m co 0'> 0'1 en en 0'1 en en en en CX) CX) en co ~ ..... 0'> ..... ..... ~ ..... ...... 0'> ~ ::!l
to - encocoenCX) ...............O'>wCJ'1CJ'1o......~enCJ'1CX)CX)owen~ CTn
CUI W 0'1..... ~owO'>COCOCJ'1o) ~.....o.....o <D m
0'> ........
o <D
C
m
~ ~cc~~m~~~~~)>)>~mm)>)>~)>)>~cm ~
~ poggpopo~popopopopo~~Ci3 ~~~~Ci3 ~~Ci3 g~ "(;
;0 en ::L ::L en en to en en en en en en en 2. OJ OJ en en 2. en en 2. ::L OJ a :7'
O '<~ ........ CD CD CD'< 3m
~ ~ ~ ~ ..., ...,........ UI
~ - - ~ - ~ ~ 8.
r -
~
Z ....
)> ~ .......................................................................................... ................................................
fg bt '0'0'0'0'0'0'0'0'0'0'0'00'0'00'1'0'0'00'0'0'00 mo
)> 0 000000000000000000000000 mo
en ~ 9999~09~0~0999999999999~0999 !!!.~
o 000000000000000000000000 UI
o 0 000000000000000000000000
C 0 000000000000000000000000
o
~ 000000000000000000......0......0......0"
)> o)CJ'1CJ'1CJ'1CJ'1~~~~~www~w............~~~~..................ec
~~~~~~~~~~~~~~~~~~~~~~~~ ~
en ......~......OO~~O......O......w~............O............O......~......O~mn
-I o,>o,>co~CJ'1en...........eno,>o......~o..........coenenco~w~o....:7'
------------------------<Dft,
m 000000000000000000000000;
)> CJ'lCJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1~CJ'1~CJ'1~CJ'1 <D
G)
m 0......0......0......................................................0000000000 ~
z ~~~~~~Q~~~~QQQ~~~~~~~~~~em
a ~~~~......owow......o......oo......oo............oo~......om~
~ o,>w~~~en............oowwo)o)CJ'1en......CX)......co~......~.........
~ oooooooooooooooooooooooo<D.~
<D 0)CJ'1CJ'1CJ'10)CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1CJ'1 ~
~. ~
:7' _m
- VUl
<D ...... m_
a. 0)0'10'1 ~~ ~ www~w ......~......~~.................. '<-
< -< ~i\3~~~i\3i\3~~~~wi\3~~"""~~~~i\3~~i\3 3 a
<D< i. O)O)co~CJ'1en""".....eneno"""~o.....=:::Jcoenenco~w~o <D <D
~~~~~~~~~~~~~~~~~~~~~~~~=~
CQ_. a:: 0 0 0 0 0 0 0 0 00 0 0 0 0 0 0 0 0 0 0 0 0 0 0 _ <D
:7''' 0'1 CJ'1 0'1 0'1 CJ'1 0'1 0'1 0'1 0'1 CJ'1 CJ'1 CJ'1 CJ'1 CJ'1 0'1 0'1 0'1 CJ'1 ~ CJ'1 ~ 0'1 ~ 0'1 ~
-
<D
a.
~ wwwwwwwwwwwwwwwwww~www~w =
m (j.) 00 en (n en :......Ii:." (n 0, 0, en 0, en 0, N 0, 0 N W 00 N 0 0 ~ 0 ;;Q CD
~ ~ enco......O)......enwcoen~w~wCJ'1wO)o~coCX)CJ'1eno~!a....
"" 0 ~~~~~~~~~~~~~~OJ~~~~~~~~~ <D <D
~ ~ ~~~~~~~~~~~()'~~()'Ci'Ci'Ci'Ci'Ci'~Ci'Ci'Ci' ~
.. ~
~e
.~ mm
- -'<
~ ~...... ...................................................... CUI
~ ......~CX).....COo)~CJ'1CJ'1W~ococo..........en~~~w~...... .~_
co oen~CJ'1en......w~wwenCJ'1enen.....owco~oCJ'1......~.....~o
e >
m en
'< mn
UI ...... ..............................~ ............~......'<2
......w~CJ'1CJ'1en.....en.....CX)......coco~o.....O)wo.....coO)wO) UI<D
~CJ'1~.....o)wO~WCJ'1~......CX)OCJ'1~~~~~oCX)en...... a.
....
N
N ...... ............ .................. ........................
51>> ~ ~ !"- 91 91 ~en S1> ~ ~..... ~ 9 :0 :0 ~~ 9 _..... !"- .!" _en ~en ~CJ'1 _~ ~..... ~ _)>
co ~CJ'1O.....o)...........~......~CX)O.....~......WI'\.)O......~CO......O)w :J n
N CX)ww......co.....encoenwwl'\.)~co...........OI'\.)CX).....O......O~ -<Dn
Of) CX)CX)CX)CJ'1~COCO~OO......CJ'1O)~~o~~oo~enCJ'1w ""
. ........................... "" c:
~ ~wcoeno......enoo...........l'\.)wO)ow.....enl'\.)...........O)~...... <D <D
Of) ~enOI'\.)CJ'1CX)0)CJ'10~CX)......o0CJ'1CX)~en.....~~oCX)CJ'1 ~a.