Quarterly Investment Report 3 31 08THE CTTY OF Dubuque
a
DUB E
Masterpiece on the Mississippi
2007
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: March 31, 2008 Quarterly Investment Report
DATE: April 29, 2008
Finance Director Ken TeKippe is transmitting the March 31, 2008 Quarterly Investment
Report.
~ ~ ~~~
Mic ael C. 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
RE: March 31, 2008 Quarterly Investment Report
DATE: April 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 January 1, 2008 through March 31, 2008.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended March 31, 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 March 31, 2008 8 Fiscal 2008 YTD
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, 062 96, 062 -
28, 995, 325 28, 995, 325 -
26, 000, 000 26, 337, 431 337, 431
2, 015,125 2,194, 091 178, 966
11, 514 83, 383 71, 869
24,119, 418 24, 711, 564 592,146
81,237,444 82,417,856 1,180,412
70, 648, 078 72, 272, 723 1, 624, 645
10, 589, 366 10,145,133 (444, 233)
81,237,450 82,417,856 1,180,412
Quarter Year-To-Date
756, 220
85,518 2, 319, 533
402,428
841, 738 2, 721, 961
(34, 629)
122 (103, 264)
429
(34, 751) (103, 693}
721, 591
85, 396 2, 216, 269
401, 999
806, 987 2, 618, 268
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
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
March 31, 2008
FY08
PORTFOLIO TOTAL
COMPOSITION COST CITY FUNDS
PERCENTAGE BASIS PERCENTAGE
4.26% 260, 973
0.00%
95.74% 5,865,276
0.00%
0.00%
Total 100.00% 6,126,249 7.54%
3.77% 284, 602
0.00%
73.46% 5, 544,198
6.61 % 498, 750
0.00% 0
16.16% 1,219,754
Total 100.00% 7, 547, 304 9.29%
Tora/
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
11.45%
0.00%
70.79%
17.76%
0.00%
100. oo°i°
34.26%
2.68%
39.06%
24.00%
0.00%
100.00%
337, 284
2, 086,105
523, 364
2, 946, 753
3.63%
2, 569, 067
200, 781
2, 929, 264
1, 800, 000
7,499,112
24,119,418
9.23%
29.69%
14.31% 3,451,926
0.00% 0
11.70% 2, 822,114
5.06% 1,219,754
0.83% 200, 781
68.10% 16,424,843
100.00% 24,119,418
4.25%
0.00%
3.47%
1.50%
0.25%
20.22%
29.69%
Page 1
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
March 31, 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 (America's River Bond Proceeds)
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
Escrow Fund DB&T ~02~
Project Construction Fund US Bank (Bond Proceeds) ~o2s
Capitalized Interest Fund EDSB (Bond Proceeds) ~o2a
North Fagade EDSB (Bond Proceeds) ioso
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, 062
85, 000
96, 062 0.12%
330, 073
221,157
311, 632
4, 690, 396
557, 558
71, 303
133, 009
23, 680
515, 775
42, 488
30, 093
907, 465
16,958
3, 577
7, 855,164 9.67%
6, 000, 000
9, 000, 000
0
1,000,000
1,000,000
3, 000, 000
6, 000, 000
26, 000, 000 32.00%
0
16, 641, 473
3, 798, 495
700,193
2,015,125 2.48%
23,155,286 28.50%
11,514 0.01%
57,118,026 70.31
81,237,444 100.00%
Page 2
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
March 31, 2008
FY08
RECAP OF PORTFOLIO PERCENTAGES MANAGED FUNDS OTHER FUNDS COMBINED TOTAL
CASH 4.25% 0.12% 4.37%
CHECKING /SAVINGS ACCTS 0.00% 9.67% 9.67%
MUNICIPAL BONDS 0.00% 0 0.00%
MUTUAL FUNDS (U.S. GOVERNMENT) 1.50% 0.00% 1.50%
MORTGAGE BACKED SECURITIES 3.47% 0 3.47%
CERTIFICATES OF DEPOSIT 0.00% 58.02% 58.02%
U.S. TREASURY OBLIGATIONS 0.25% 2.48% 2.73%
FEDERAL AGENCY OBLIGATIONS 20.22% 0.00% 20.22%
CORPORATE STOCK 0.00% 0.01% 0.01%
Total 29.69% 70.30% 99.99%
Page 3
ao y
O C
T ~
M
M p
o U
om
C N
U
C
W c
t LL
C
o U
'p N
0) C
m ~
O7 O
C V
N
~a
y
C
l0
m
M
7
Q ~
W = ~ £ ~
Z ~ ~ H
U
0 ~
LL N
~ W
>
Z
U J ~
2
F
Z
O
m
C
0
U
`~
u
Q ~ a
~
O 3
N
~ 03 ° N 0) 'Np
_ H (n
~ G L
C A pp
O 0]
m O~
~.
w
J
L
C
O
~
~ O X
N 41
Q
2 y
~ Z
Q O
~2 ~
C E N
m i0 07
G Yl p~ V' c a,
U
Q
H
W
C
~ '_-' V
- ~
G O y N
m
H p~~
h
_
~
Ol
J
d C
U p a
~ „ O
a
...
~ m~ y a d
m L ~ ~ ~ N 0)
~ 5 N Y ~ `of ~ £ W c
~ W C
h O ~ N N
1O N m > > 7 N
7 °. ~
t C p U
C C
m ~
U ~, m
LL n y yU U
° •~ c .o d~ v ~ ~
N m ~ A
~ R awi Q
~ C E tj
w d d L
J J
J
N l!J ~ 0)
to 'per O E C~ y
1CL~ W L p C C j
C /0 ~ N~
Q'
m o d.~,a ~ m N ~,a m ~j ~ E E ~> o >.~
y
O) l0
N 7
N
Yl Y
w C 10
°
o a S~ U ~~ U m U o z c > > Q 10 °
`o g
~
U Q N U w C S ~ d
~' ~ O 1~ O~ 0 0 ~ O O In n N
f~ M In O h N O CA O f~ _
00 O N~ 1~
N M O 00 N f0 O O O O M M O) 10 (O
O N O r In M O 00 V In In O to
I~ V ~ I1') O M ~
.
. I~ In CO V O M IA 00
O ~ ~ .
~
N ~ O ^ M N ~ ~
.
..
N f
0 M
O M ~-' M N O N O 00 In ~
~ ~ ~
00 ~ O ~
N
~ ~ ~ ~ O ~ 0
c
0 a
0 O n LL
") M
f0 f~ I~ O O N M CO N O N
(O N N lI) In V OD N M 10 M O
V ~! ~ ~ OD O O W M N
O O O ^ O
00 N 1~ ~ O
O N N O M M M E
~ ~
~ II 10 U ~
r 10 O t0 N f0 O 00 d) O) M V O) M
10 In M O N O O 00 I~ ~ ~ N V
~ ~
O O) O d) M N V ~ O) ~ 10
0 ~
N
N In O O 0 ~
N ~ .
...
,. M N 0
0
~ ~"' O N r I~
N
N N N N N
O n ~ O O ~ e o
~f C
7 M O) O N N II
O N M 00 00 ~ ~ f~ I~ O n N~
~ _ W O ~
f~
00 O W 00 O O ~ O N
~
M ~ f0
M (O ~ ~ ~
(
O C
7 ~ 0 f~
f M
V V ~ f0 10 O
n ~ n ~ ~ n
~
j
j O
O 0 ~ ~ M O M M e o 07 e e e e e e
0
0 ~
l
O f
0
~ (
0 O
D 0
O 00 f0 O I
~ n
~ M
to M
In 1~
N O N
O CO O
0 a 00 l
0 OD O 01 ~~ N
I~ n O ~ ~ n n M O O 0
O O ~ C O O a N a 0 O
O O M I~ f0 (O ~ In I~ ~ o
~ W ~ O H M O U N N
N } N~
N N M N M
ao M~
M N O O~
O N 00 ~
O M
<f M
V V M A O c
N ~ n O M~ N N N 10 f0 N N y m
L
00
In
O n N CO
~ ~ ~ M N M l0 M M J .
.. 10 ~ h N ~ m
M O
O f~ O N I
V
O O O N
O O
M O
M 00 ~ M I~ C N
~
0
~
O N
1~ O V
M N v
M
I~
I~ N
O N O
I~ ~ O ~
~
01 0
10 0)
l6 ~ ~ ~
~ ~ `'' M [ ~ ~ 0
~ 0 N x
I 0
0 0
0 >
~
I~ n ~ n n n Q
~ ~~ ~ M M ~ ~ ~ ~~ ~ e e N e e e e o
0
0
~
O
W ~ ~ ^ ~ f0 M 1
0
J t 0
0 O W r r
f
7
i!') M O to 00
N v OD
lC) N N 00 to V ~
M ,
O r B O O ~ N V O
N ~ ~ ~~
O M
~ N N_ _ _ f
0 M O) j M
O (O (O t0 f0 f0 Q
W N
C
O C
O
00 ~ O~ ~ O I~ O O 00 M O N 00 O I~ O r r (p I~ r N W M
O (fl N 1~ M I~ O r O r (p M N~ M N r N f~ 00 ~ r In Ln 0
. . . . . . . . . . . . . . .
CO r M 0 1~ M M (O N O ~O (O 00 O CO O N E CO W M~~ M Cfl
O op f~ ~ r r O N r r 0~ O N 00 O O f0 M O I~ O O t0 CO
~~ CO CO r O O N 00 O r OO ~ M M I~ ~~ B O O r N N 00 O O
N N~ O N~ M~ ~ V~ 00 B O O ~ -n r M N r- ~~
L L N N N N N N o r r r r r T T
V ~
a~
M
O
~ ~ O
C N I~ O
O 00 ~ M
~.. (O I~ ~
7
r ~ M
..
L
.N
O
a
d
0
N ~ ~
7 ~ O
,F, O
~ N
~ V ~ r
Q :. ~ M
N
ova ~
A ~
V O ~
t
V
~ M~~ r 0 0 00 GO r~ O N~ r O M O M M 0 LS") ~f Ln r M
O O O CO 00 I~ M (p r Ln I~ ~p M I~ r (p N r r r 0 N O O -n
O tq r r r r r r r r r r r r
V ~
Q
M O I~ O r M M (O M O I~ r OO -!') N O (O M O 1~ r 00 to I~ ~
r ~ r r M M ~ ~ CO I~ 00 00 O O r N N M ~f t[) ~ 1~ 1~ 00 N ~
N 'L r r r r r r r r r r r r N N
~ a0+
lQ Ri
~ 5
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 ~ ~ ~ ~ o o ~ ~ ~ o ~ ~ ~ o o ~ ~ ~ o
L~ O O lf) 00 I~ O~~ O O 00 O O r 0 0 0 0 0 0 0 0 0 r 0
!C (O N O S I~ r (p r N -n r N M O N I~ ~ r M O N r I~ O N
~~ M O O O O O O c0 (O M O~~ M~~ N~ (O M M E to M d'
~ ~ ~ ~ ~ ~ ~ ~ ~ ~ d' M ~ ~ N M ~ M N N ~ M N ~ ~ M
0 0~ o~ ro o~ w o 0 0 0 0 0 0 0 0 0 0~ w o 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
M O I~ O r M M to N O (O O I~ ~' r I~ ~ r CO ~ 00 ~ N M r
L +O+ O r r M O N N O r r N r r N M O r N N O r N O r r
7 lC ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ ~ ~ ~ ~ ~ to ~ to CO Cfl (O CO 1~ I~ ~ n M M O M O O O O r N
~ o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o r r r
~ ~~~~~~~~~oo~ooo~o~o~~~~~o
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
R G1 ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~
~ +'' O O 00 N~ M to t7' r I~ N O CO O r o N 00 00 M CO I~ ~ O~
V~ N r r 0 0 0 r 0 0 ~-- N N r N M N r r r r O N N r 0
O O O O O O O O N r r r r r M r r M M M N M M N r N
d O O r r r r r r r O O r 0 0 0 r O O O r O O 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
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 O O O O O O O O O O O O O O O O O O O
++ 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
N 'y 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 O O O O O O O O O O O O O O O O O O O O
O ~ N
O ~ ~ "''
y;, YYYYY N N ` y
~ >, ~~~~ ~ U U a~ U
~F-~mmmmmUf- O(n~- OfnH(nF-UUH'~H O!-
N ~ ~ N a~ °~ ~' ~S ~ .~ o~ ~S otf ~iS olf otf otS ~tS .-• atS
O mm~f/~(/~(/~(/~(/~F-m.O.~--mwF-mHmF-Hm ~m.O.m
~ O J~~~~~ Q ~ fn Q ~ fn Q ~ Q ~ Q Q ~ d 0 fn ~
v d~ M ~ n O ~ O O~ r~~ O (O f~ M~ CO r I~ ~ O to N~
~ ~ ~ ~ r (p M O ~ O r 00 tl' N 00 I~ ~ ~O M 00 (O ~p 00 M I~ O M
00 CO r O O O N~ 'd' 00 I~ O M O O O r 00 r to 00 ~~ I~ M
O O O r N N N M O O ~ ~t O~ r 0~ O~ r 0 OO O H O
O r r O M M M M M N r r N r r N r N r N N r r r r r
t+ Z~~ 0 0 0 0 0 0 r Ln r In r In r l!') r r l1') ~ Ln ~
U -f) M M M M M ~
M M M M M
d' ~ tt ~ ~
~ ~
Q N
N
~ ~
o ~
~ co
r ~
~ O
'a ~+
d ~
~ 0
~ c
•-
t
'L
~ ~
r0+
t
a1