Quarterly Investment Report June 30, 2008TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: June 30, 2008 Quarterly Investment Report
DATE: July 23, 2008
Finance Director Ken TeKippe is transmitting the attached June 30, 2008 Quarterly
Investment Report.
l/
Mi hael .Van Milligen
MCVM/jh
Attachment
cc: Barry Lindahl, City Attorney
Cindy Steinhauser, Assistant City Manager
Kenneth J. TeKippe, Finance Director
THE CITY OF
DUB E
~~
Memorandum
TO: Michael C. Van Milligen, City Manager
FROM: Kenneth J. TeKippe, Finance Director . Gs..~"Y"~~
RE: June 30, 2008 Quarterly Investment Report
DATE: July 23, 2008
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, 2008 through June 30, 2008.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended June 30, 2008 and fiscal year to date
Schedule of City Funds (3 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 June 30, 2008 & Fiscal Year End 2008
Market Value / Unrealized
Carrying Including Gain (Loss) /
Description Value Accrued Interest Accrued Interest
Deposits, Change & Petty Cash Funds
Checking/Savings Accounts
Certificates Of Deposit
US Treasury Securities
Corporate Stock
Investment Advisor Accounts
Total Funds
Breakdown
City
Metro
Total Combined Funds
Cash Basis
Gross Earnings:
City
Metro
Combined
Investment Fees:
City
Metro
Combined
Net Earnings:
City
Metro
Combined
96, 712 96, 712 -
25,078,224 25,078,224 -
30, 700, 000 30, 984, 598 284, 598
2, 015,125 2,131, 300 116,175
11, 514 76, 060 64, 546
24, 449,160 24, 663, 548 214, 388
82,350,735 83,030,442 679,707
71, 215, 651 71, 731, 700 516, 049
11,135, 084 11, 298, 742 163, 658
82,350,735 83,030,442 679,707
Quarter Year-To-Date
960,445
86,376 3,279,978
488, 804
1,046,821 3,768,782
(35,445)
(301) (138,709)
(730)
(35,746) (139,439)
925, 000
86, 075 3,141, 269
488, 074
1, 011, 075 3, 629, 343
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
June 30, 2008
MANAGED FUNDS
DANA INVESTMENT ADVISORS, INC:
Cash and Equivalents
US Treasury Obligations
US Agencies
Mortgaged Backed Securities
Municipal Bonds
DUBUQUE BANK 8~ TRUST:
Cash and Equivalents
US Treasury Obligations
US Agencies
Mortgaged Backed Securities
Municipal Bonds
Mutual Funds
FIRST COMMUNITY TRUST:
Cash and Equivalents
US Treasury Obligations
US Agencies
Mortgaged Backed Securities
Municipal Bonds
US BANK:
Cash and Equivalents
US Treasury Obligations
US Agencies
Mortgaged Backed Securities
Municipal Bonds
PORTFOLIO
COMPOSITION
PERCENTAGE
Tota!
Total
Total
Total
GRAND TOTAL
BREAKDOWN BY TYPE OF SECURITY:
Cash
Municipal Bonds
Mortgage Backed Securities
Mutual Funds
US Treasury Obligations
US Agency Obligations
TOTAL MANAGED FUNDS
0.72%
0.00%
99.28%
0.00%
0.00%
100.00%
2.22%
6.47%
65.66%
6.49%
0.00%
19.17%
100.00%
11.01%
0.00%
58.01
30.99%
0.00%
100.00%
FY08
TOTAL
COST CITY FUNDS
BASIS PERCENTAGE
44, 393
6,147, 878
6,192, 271
7.52%
170, 423
497, 461
5, 047, 650
498, 750
1,473,500
7,687,784
9.34%
327, 951
1, 728, 437
923, 364
2, 979, 752
3.62%
10.02%
2.65%
51.10%
36.23%
0.00%
100.00%
760, 475
200, 781
3, 878, 097
2, 750, 000
7, 589, 353
24,449,160
5.33% 1, 303, 242
0.00%
17.06% 4,172,114
6.03% 1,473, 500
2.86% 698, 242
68.72% 16,802,062
100.00% 24,449,160
9.22%
29.70%
1.58%
0.00%
5.07%
1.79%
0.85%
20.40%
29.69%
Page 1
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
June 30, 2008
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 (Housing Rehab & Section 8)
Dubuque Bank & Trust (General/Metro/Leisure)
Dubuque Bank & Trust (DICW Bond Proceeds)
Dubuque Bank & Trust (Comm)/Ind Bldg Rehab & Econ Dev)
Dubuque Bank & Trust (Cable Franchise Equipment Fund)
US Bank (General/Ambulance)
US Bank (Sanitary Sewer Bond Proceeds)
Premier (Utility}
Liberty (Utility)
East Dubuque Savings Bank (Stormwater Bond Proceeds)
East Dubuque Savings Bank (Utility)
State Central (Utility)
Total
CERTIFICATES OF DEPOSIT:
American Trust & Savings Bank
Dubuque Bank & Trust
East Dubuque Savings Bank
Liberty Bank
Premier Bank
State Central
US Bank
Total
PORT OF DUBUQUE PARKING RAMP
Project Construction Fund US Bank (Bond Proceeds) ~o2s
Capitalized Interest Fund EDSB (Bond Proceeds) 1o2a
North Fagade EDSB (Bond Proceeds) Soso
Debt Service Reserve U.S. Treasury Obligations (Bond Proceeds)
Total
CORPORATE STOCK (Lyons Peony Trust)
TOTAL OTHER FUNDS
TOTAL CITY FUNDS
FY08
TOTAL
COST CITY FUNDS
BASIS PERCENTAGE
11,712
85, 000
96, 712 0.12%
157,452
149,079
4,701,122
525,230
77, 723
314, 385
4, 206
521, 481
4, 965
3, 751
404, 469
6, 041
3, 705
6, 873, 609 8.35%
6, 000, 000
10, 700, 000
1, 000, 000
1, 000, 000
8, 000, 000
4, 000, 000
30, 700, 000 37.28%
14, 732, 421
2, 763, 260
708, 934
2, 015,125 2.45%
20, 219, 740 24.55%
11,514 0.01%
57,901,575 70.31 °k
82,350,735 100.00°k
Page 2
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
June 30, 2008
FY08
RECAP OF PORTFOLIO PERCENTAGES MANAGED FUNDS OTHER FUNDS COMBINED TOTAL
CASH 1.58% 0.12% 1.70%
CHECKING /SAVINGS ACCTS 0.00% 8.35% 8.35%
MUNICIPAL BONDS 0.00% 0 0.00%
MUTUAL FUNDS (U.S. GOVERNMENT) 1.79% 0.00% 1.79%
MORTGAGE BACKED SECURITIES 5.07% 0 5.07%
CERTIFICATES OF DEPOSIT 0.00% 59.38% 59.38%
U.S. TREASURY OBLIGATIONS 0.85% 2.45% 3.30%
FEDERAL AGENCY OBLIGATIONS 20.40% 0.00% 20.40%
CORPORATE STOCK 0.00% 0.01 % 0.01
Total 29.69% 70.31 % 100.00%
Page 3
h ~ CO O CO N 00 .~. O .-. N ~ N to ~
I~ 0 0 0 O N M O M M I~ N M (O
In
V t` O
h
M i n O
CO .
V .
O .
V .
O .
T~
O ~ O N N W h r 0 01 O O M ~ O
O C R t` O V7 O O M O N 117 h h O N e
M V N CA ~ V r
... O n CO O O C
~ H ~ N `~' N ~ ~ M N II~ ~
10
~ ~
U ~ W V N p N
a) ao ao a7 ro
C N O) V 7 M M O I~ N n O C
=p C r M CM h 1~ ~ O V fM M C
C ~ ~ ~ O O ~ ~ N W
W
C a
O M U
L lL .
.
C _ N N N . r ~ ~ O O r
O U M M ~ ~ M N
f
0 (
O (
O
h p N N0000 0 N N N to U
p h 0 O O N O O N M M I~ 117 C
>3 N
N f` O n M M h O O O O N ~f C
C
~ ~ V to to to M N t0 M O
m O U
rn u
c V O p N M v N M O O) Oj V a
Q M _
~~ CO Q V ~ R U
'
N N
N N N
O M~ R T ~ M M Q p d
O N O 117 In N O O R V a
v ~ gy ~ M M N a
a) ~ .
p.. W
~ i
a o o 0 ro ~ °
~ n
° a
o
In
In c
7
cfl u
m
~ ~ ~ n r~
}
Q O O Q ~ ~ ~ r
r C
O M O ~ C
l
~ «_ M V I~ (O I~ ~ N N lA
~ ~ v rn n ~ v v ~ ~ m o u
W Q ...
~~ ?
~ O O W O M
° M (`
"
aH ~ ~ ~ m rn o rn
~ Z (~ N N N _
M N
~
D
LL W O R~ M N f0 GO ~ V O O if
O N CO In M O~ M N N O) h h
Z O N n N M CO O V V <A to a
H lf7 O R I~ V N O O CO p U
J O CO N M p f0 p t` n M CO IX
U ~ oco N of v ri r; ~: M N a
= m m °D ~ ~ ~
~ c
O
Z ~ ~ ~ ~ ~
f~ M O M f`7 M I~ ~ M p V
V N O M W O a7 O M V h
~ ~ O h ~
O C
O 1~ N N O n
Q
O N `-' N to O O CO ~
p CO O CO tD
0 0
O CO
M O
O N
o e o e e e e e
W M N O 10 ~~ O O
r 1~ E N O O O
O r B Q r N N N~ b
C M
m
U } 4 "
~
~
o
e e y N o o e e e ~
N~ A
M
L M O n O! M y
~ '~
J ~O a) O r t0 i
O r 6
~ M M P OI r m
f
R ~ ~ ~
~ N
Q r y
e e y e o o e e
M O
J
~
~
N
~ O
L
O N N C M Of a
D O
0
O ~ O V ~
~ O
j M
Q
O
. O t)
_
77 Q
Q
a w
o rn ~
F m
F
~ y
7
'o
v w N
N U L
c c o
y
y y a t n ao mmm
w r o
~ ~ °0 5 v m
Q
2 d Z
R ~ la v m N N 0 0 (~ C~
~
°' ~ ~ ~ ~ ~ ~ m d
~ ~ ~
' '~ ~ °Q a ° ~ m~ a'°iaa
N C a u
C ~ ~ 0
~ 5 ~ £~
Q O
m L
d ~
~
ti ~ j
`
~
~
` ~
c
C d
L
O to .d. 7
O
C
y ~ N N Lr ~ m i > d
> o t
a C C
C U
O N f' N ~ ~ d W ~ N~ H L
C
C E O LL
N C LL ~L
_
~
m
g `
Q
~ m N
~ 7 U L
J J J
d
N y W~ Q ..
O E m L~ y L O C W
C C al Q' ~ 7
R C m N« 'V N ~ (~ Y ~
m ~ U d W~~ O~
~ L
O '
C
gy j i
V R B O G
~
U
'
p ~ U m U O Z ~ > j
Q °O~~
v a v~ v w ~ 5
~ a
N
Q
N
d ~
~ ~
7 +~~'
.n ~
V w
~ i~ O
N
p U Q
_A
U ~
d
s
O
0
N
O
M
d
C
7
N r
7 N
L
U N
Q =
t9
3
C)
V
Q
O ~
++ .
N ~
~+ ar
R R
0 ~
~ V CA 0 0 M N I~ O ~' O M CA H O M O (O N f~ N M M O O O r In 1~ N DO
I~ M r I~ r O 00 O ~ CO I~ ~ ~ (O M N CO M N I~ O CO r l() r (p N l() (O O CO
. . . . . . . . . . . . . . . . . . . . .
M Ln N r N (D O M~ r M O ~ r ap r N 0 q0 ~ M CC) O O V' N lf) H O M O
I~ r O CIO CO CO ~ O LC) N O M lf) q0 I~ I.n ~~ CIO O N M r t(1 O O V N lf') LA r
lt7 Cp CO (O to CA N f~ CIO I~ V N O N N E N N N M O l!7 N O S ~t ~~ M In M
In f~ O CO ~ ~ Ln CO O I~ ~ lC) ~ tC) L() O CO ~ M Lf) CO V' ~ ~ ~ M r
N N r N N r N N r
N M CO N r O~~ O V V In O r O O L(') CO CO V C10 O LC) l(') N V In CO ~ tl0 lf)
DO N O O to N~ r r O O I~ O C10 I~ r O I~ C10 I~ C10 CO ~ N~~ r
N r r r N r r r N r r r r
CC) O 1~ ~ r (O I~ CC) to N CA ~ CO M O O 1~ M ~ ~ CIO N CA ~ CO ~ r (p M N O
r r N M M M M cT' ~~ CO CO I~ d0 C10 00 (A CA O O N N M M CO I~ ~ tlO O N
r r r r r r r r r r r N
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
N o o~ o 0 0 0 0~ o 0 0 0~~ o 0 0 0 0 0 0 0 0~~ o 0 0 0 0
d~ r O O r 0 0 lf) 0 0 0 0 0 0 0 In O O t17 O CO r r O r r 0 0 r N r 0
d~ O N M O N CO O~~ r M lf) CA C10 M N r M f~ l!) r (p V (O O N L(7 O C10 L(7 ~
~, ~ ~ lt7 lC) M L(') ~ lf~ Lf) N I~ O In M M L(') M V' Ln Sri CO l() I~ In CIO M ~ N r N r N
~ N~~NMNN V (''>NNN V CV NMNN V NNNNNif7('o('MC'h('M('M('M
ao O O 00 0o ao O O w w ao ao ao O ao ao ao 00 0o w ao ao O O 0o w ao O O rn rn
~ 0000000000000000000000000000000
•~ r M O~ V r In (O I~ ~ r CC) M i r CC) q0 t(~ r N Lf~ CO O (O N M r C10 M O 00 tf)
~ O r r N M 0 0 0 ~ N N O O r r r N O O r r M O r r r r N M 0 0
lC ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ Q~~~~ ti O 00 M CC) CC) O O O O O O O O O O O O r r r N N N N r N
~ O O O O O O O O O O O O O O O O O r r r r r r r r r r r r 0 0
~ aol~ao0oaoaocoraoaoaoaoraoao00000oro00oaoao0oaomaoaoaoao00
N O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O
t0 G1 ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
t +-' O O (O O r ~ f~ O N q0 d0 O M O lf) CO I~ tf) I~ ~ M r Cp ~ O I~ t(> V' CO N lf)
V Q O N r N C'7 0 r N r r r r r r r O N r N r O O r O r O N N N r N
3 ~ r r M r Cp ~ r M M M~ N ~t V M M~ N V~ lf) V (O r N CD CO (O CO CO
4. O r 0 0 0 0 0 r O 0 0 0 r O 0 0 0 0 r 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
wNOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOo
y'NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOo
o~ooooo0000000000000000000000000~
cLo ~ is m
c
O ~ ~ C C C C c C
~ N Y Y Y Y
7 U U ~~( ~,~[ ~ ~ a~ ~ ~~( ry~~ U U ~~( U U L U U
y ~+ W ry"~' ~+ W MW ~~/~ ryW~ ~L MW QU ryWM~ LWL LWL ~,~/^~ ryMW~ ~ ~~/~ ~YW~Y11 ~W/~ Y Y ryWry~~ Y Y f~~V1 ry~~ ~ ~ ~ ryry~~~
y~/~~ iV1 ~ L /V1 n~ r~~ W r r VJ W ~ CQ W VJ ~ y W ~ ~ W~ Y D Y W
•' ~ O M M O
V ~ 1~ O ~ CO (O M tf) CO r Cn I~ N (00 ~ M COO CC) (O CA ~ OD i~
~ N CO O~ O M t0 M CC) O tl0 CO N M 00 to M f~ M~ Cq O CO N M CA (~ f~ O O
` 3 lf) O O ~ O~ O CD r O r O lf) N O d0 d0 O l(7 O N LC) CC) r O CC) I~ O CC) (O f~
~ O H O (A r r M 0 lf') O In O r t(') M O r M O M O N 0 lL') f~ O r f~ M In r
V Z Ln N r~ N r M r N r N r N N M r~ M r M In Lf') r to ~' r r to O tt~ r
r r to r r Lf) ~ L(7 r In r L(') r r ~ L(') ~ ~ l() ~ r r In r r Ln lf~ r (~J r L(7
M
O
O
l!)
V
M
N
~ ~ O
C f~ O i~
O In ~ O
Y O O ~
~ M O ~
(O N aO
~ r r N
N
N
C
fII
N
c
N
U
o ~
O N
O O
r O
M
'~ ~,
m
~ Q
N
L ~'
~ '~
l0
~~
r
t
rn
.~