Quarterly Investment Report 1 30 08Tx~ crrY of Dubuque
D~~ E AII-An~lcaCilY
Masterpiece on the 1Vlississippi ~ -„
2007
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: December 31, 2007 Quarterly Investment Report
DATE: January 30, 2008
Finance Director Ken TeKippe is transmitting the December 31, 2007 Quarterly
Investment Report.
l ~
V
~1 /i
Michael C. Van Mi ligen
MCVM/jh
Attachment
cc: Barry Lindahl, City Attorney
Cindy Steinhauser, Assistant City Manager
Kenneth J. TeKippe, Finance Director
THE CTI'Y OF
DUB E
~-~~
MEMORANDUM
TO: Michael C. Van Milligen, City Manager ~ ~,~,,
FROM: Kenneth J. TeKippe, Finance Director ~ 'v ~` ~`Y~~
RE: December 31, 2007 Quarterly Investment Report
DATE: January 28, 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 October 1, 2007 through December 31, 2007.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended December 31, 2007 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 December 31, 2007 & 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, 012 96, 012 -
33,329,548 33,329,548 -
23,000,000 23,284,193 284,193
2,015,125 2,015,125 -
11, 514 92, 856 81, 342
23,882,722 24,278,792 396,070
82,334,921 83,096,526 761,605
71,645,850 72,299,234 653,384
10,689,071 10,797,292 108,221
82,334,921 83,096,526 761,605
Quarter Year-To-Date
851,380
185,511 1,563,313
316,910
1,036,891 1,880,223
(34,323}
(185) (68,635)
(307)
(34,508 (68,942)
817,057
185,326 1,494,678
316,603
1,002,383 1,811,281
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
December 31, 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
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
Total
Total
Total
Total
GRAND TOTAL
BREAKDOWN BY TYPE OF SECURITY:
Cash
Municipal Bonds
Mortgage Backed Securities
US Treasury Obligations
US Agency Obligations
TOTAL MANAGED FUNDS
PORTFOLIO
COMPOSITION
PERCENTAGE
1.24%
0.00%
98.76%
0.00%
0.00%
100.00%
FY08
TOTAL
COST CITY FUNDS
BASIS PERCENTAGE
74, 977
5,979,746
6,054,723
7.35%
6.32% 470,376
0.00%
79.09% 5,890,844
6.70% 498,750
7.90% 588,486
100.00% 7,448,456
2.58%
0.00%
90.66%
6.77%
0.00%
100.00%
15.34%
2.70%
59.82%
22.15%
0.00%
100.00%
9.05%
75,527
2,657,699
198,394
2,931,620
3.56%
1,142,313
200,781
4,455,079
1,649,750
7,447,923
23,882,722
7.38% 1,763,193
2.46% 588,486
9.83% 2,346,894
0.84% 200,781
79.49% 18,983,368
100.00% 23,882,722
Page 1
9.05%
29.01
2.14%
0.71
2.85%
0.24%
23.06%
29.01
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
December 31, 2008
FY08
OTHER FUNDS TOTAL
COST C1TY FUNDS
BASIS PERCENTAGE
CASH
Change and Petty Cash Funds 11,012
Prescriptions & Workers Comp Deposits 85,000
Total 96,012 0.12%
CHECKING I SAVINGS ACCOUNTS:
American Trust & Savings Bank (General & Health) 370,665
American Trust & Savings Bank (America's River Bond Proceeds) 219,764
American Trust & Savings Bank (Housing Rehab & Section 8) 103,855
Dubuque Bank & Trust (General/Metro/Leisure) 4,239,666
Dubuque Bank & Trust (DICW Bond Proceeds) 795,535
Dubuque Bank 8~ Trust (Comm)/Ind Bldg Rehab 8~ Econ Dev) 87,942
Dubuque Bank & Trust (Cable Franchise Equipment Fund) 155,226
US Bank (General/Ambulance) 12,009
US Bank (Sanitary Sewer Bond Proceeds) 567,045
Premier (Utility) 39,452
Liberty (Utility) 25,770
East Dubuque Savings Bank (Stormwater Bond Proceeds) 1,833,378
East Dubuque Savings Bank (Parking Bond Proceeds) 18,953
East Dubuque Savings Bank (Utility) 35,216
State Central (Utility) 3,558
Total 8,508,034 10.33%
CERTIFICATES OF DEPOSIT:
American Trust & Savings Bank 4,000,000
Dubuque Bank & Trust 3,000,000
East Dubuque Savings Bank 1,000,000
Liberty Bank 1,000,000
Premier Bank 0
State Central 3,000,000
US Bank 11,000,000
Total 23,000,000 27.93%
PORT OF DUBUQUE PARKING RAMP
Project Construction Fund US Bank (Bond Proceeds) 16,454,737
Escrow Fund D68~T 3,970,615
Capitalized Interest Fund EDSB (Bond Proceeds) 3,704,497
North Facade EDSB (Bond Proceeds) 691,666
Debt Service Reserve U.S. Treasury Obligations (Bond Proceeds) 2,015,125
Tota! 26,836,640
CORPORATE STOCK (Lyons Peony Trust)
TOTAL OTHER FUNDS
TOTAL CITY FUNDS
11,514
58,452,201
82,334,923
2.45%
32.59%
0.01
70.99%
100.00%
Pape 2
CITY OF DUBUQUE
SCHEDULE OF CITY FUNDS
December 31, 2008
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
MANAGED FUNDS
2.14%
0.00%
0.71
2.85%
0.24%
23.06%
0.00%
OTHER FUNDS
0.12%
42.93%
0.00%
27.93%
2.45%
0.00%
0.01
FY08
COMBINED TOTAL
2.26%
42.93%
0.71
30.79%
2.69%
23.06%
0.01
Total
29.01 % 73.44% 102.45%
Page 3
O O M O M O (O V O N 'V ap O a
f
v (000 (0 M~r` S lC1 (O v w l
)
o ao~o ~ ~~ ~
0 o M ~ o ~ m r`C
~. N r` M In In O) 0 M CO r` N ~!i CO
p O
O O
~ O 0p a0 M N '~t
`~ r` m O O N M
' ~ ~ .
..I M M N N u7 N o0 ~ O d0 d
N ~~ ~ M M O ~ M V ~ t
U ~ ~ ~ ~ ~ w
O1
~
N
N
~
~
O
C N ~ r ~
-- r` (O C
U
C ~ ~ te im ~ C
W ~ ~ (
7 (
7 '
a' V
' N O ~ ~
~
~ C
V O N N v ~ O ~ M M a
.1
a
C - ~ t
N t
N r` ~ N V7 C
O
g
U
°m _
co
~
~ _
co
u00'~
~ W M O O CO p (O O O V7 O c
O M O O v M v O r` r` r` ao CO
O C (V
O l0
h M 0 ~
~
U~
O ~
l
7 ~
N ~
N ('M
ap V7 U
N U
~ 7 d' O O ~ m N !
N r` r` N W C
~ ~ C
0 O N N t!) N N O N u
n a
0 a
0
~ Q r`
f7 ~ OD
M OD
M N
V .-
V
N N N N N
Q) U7 N r` U7 ~f/ ~ O U
Y N ~ pp O .-- 'C W l!
C N ~ M M M N N E N C
`0 N C
O
m v ~ ~ cfl cp rn rn M O r
~ M m M v v ° n u
v o
~ v v ~n v
} r- r` r` r` r`
Ct'
Q ~ N N ~
C
~` (D ~ W O ((~ f
7 O (
'
~ C r, O ~ M (h d) O CO N C
W O ~~ j m N .~ r ~ ~ O O ~ ~
N LL
F
I ~ c0 v co ao cV o
~
~ -
o rn rn rn rn rn~
U
m W N N N N N
~
0 N l!') O lA O l(') In N N N O C
LL W
~~
~ N aJ O
m M W
N M r`
N~ O
~ O
~ O
~ O)
~ CO r
N C
?~ Z m ~ O aD O Q1 O U') ~ v ao O~
~ ~ M M ~v M V a ~ ~ s
U J V M ~ '
t O
_
~
~ c
r
~ O
r;
z
p M ~n co rn cfl co co co ao cD r
~ O Q OD u7 N N N N V M ~!
O O r, W r` r` N N N (D C
N _ ~
~ M
C O O
D N v ~ r` r` O (
O ~
I
~
~ ~ N V N v ~ ~ ^
((
O ll
O
O dD
O ~
p C
O
O O V1 O (O
(~ N
C C
O O
}. ~Y
U
(C N
m
Q ~ Q
O ~ o _
1-
m
= °m
~ ~
m
FO- h a ~
m
y N ~'
J y =
O ~
J ~ Z ~ ~_ ~ d
Z ~ Q ~ = L N
Q ~ W
~ `o iY~
v~
~
a
~
Q
a oa
c~ g
m Y N p ~ tQ ~ > > y y d
y Co No w g otS m W > j j~ E a`°i
~
V ~
`o N~
Y
~ a aNi `°
~ 3
LL~ m ~
w
~ ~a
~~ ~
m ~
Q w
` wU~
` N v $ r
~
c
~` •C .C NO ++ N ~ ~ 7 ~ m ~ A lQ ~ Q y N
a
YJ ~ l~ CL
l1J 0 ~
C ~ Ur ~ ~
C N
E
~ ~
VI ~ Y
~ L
~' G y d
a+ = 7 =
> L ~..~
>
.
~ v! -per
c N O
~ Nt
~'v U t
~ O
U C
d C R
d a> d
a d E
N m
O N i.5
.~
O
0 R
V
D7
~
E j .+
O o:
.
m
a+ R ~
.. Y m
N
y ~
~
'"
O Y N (6
'9
cC~'U ~''
3 (Q ~ f0 N
~UmU ~''
p N
Z
C
> U Y
>
i O
o c is
a o
U 0
Q V) U W ~ Q t
p
_ ~ a ~ ~-
0 0 0 0 0
O {O O h
O 10 V O
~ ~ 1!7 W Ih W M
}
U
0 0 0 0 0
N L O (00 ~ V U
l0
J C N O r• OD M
°' o
m ~
m
a
0 0 0 0 0
ra y o n r°~ r~i v
-~ L fM N P'> G
o
d ~
Q
0 0
M ~
O tG
0 0
f~D
o so
o e
r ~
o e
a of
N N
v r•
0 0
o ~ci
N
N ~
C
~
O O
C O
m m ~ M
N
O
>
^ ~
a o ~
~
a
~
~ d
~' € ~ ~ i
l
is
m F O ~ ~ ~
~ ~ o ~ d
a
m O) L ~,
a E
~ ¢ 'n -` `y ii a
T C C C
1O E E E=
c c
0 N
L L L C `) ~
rn ~ J J U U U
0
n
E
K
(O 07 ~ M N r S O N f~ M CO I~ N M~ N N (O 00 M N ~
r~ r M N 00 I~ M M M O M O N M I~ M~ N~ O o0 O
. . . . . . . . . . . . .
st N O N ~ ~ N (D to r (~ `V M 00 N ~ ~ cf' I~ (D ~ O M
O O N I~ O U7 (p 00 O 00 CO ~ N~ 1~ M r 0 1~ O (D O O
,r ~ M N r O O O f~- I~ ~ r 0 0 I~ O N d' X 0 0 r In r
N ~ N r O (p ~ I~ ~ ~ M t1' O ~ ~-- ~- O M I~ ~ ~ N d'
i N N N r r r r r r r ~ r r r N 00
y N
C
N ~- '~7 O (O O I~ N ~' N M ~' O o0 O I~ I~ O r N 00 ~
I~ ~ ~' M r O r 0 0 0 0 f~ O M O~ N (p 'a' M r
V/ r r r r r r r r r r r
I~
a
O O r o0 N CO N M O I~ d' r M r N O 07 I~ E N O OO (D
~,, ~ r M M ~ (O f~ i~ 00 00 O O O N N d' ~ ~ (O O N ~ I~
N '~„ r r r r r r r r r N N N
~ ~
~ ~
w
.N
O
a
d
3 O ~
~ ~ N
~ ~ r
~ V y. M
~ ~
N
ova ~
+= `'' V
O
U ~ ~
3
V
0 0 0 0 0 0 0 0 0 0 0 0 0 0 o a o 0 0 0 0 0
O o~~ o 0 0 0 0 0 0 0~ o 0 0~ o 0 0~ 0 0
w, r r r M O M M O r O O ~A 00 I~ O~ ~ O O O O O
~ O O 00 00 r~ N d' (O (O N O S I~ r (p r N N I~ O I~
M M M M M M M r r CO O O 00 00 O> 00 CO (p N A M lA
u7 ~ ~ ~ to ~ ~ ~ ~ ~ N ~ ~ ~ d' clr ~ ~ ti' '~t ~ d'
M M O O M M O O O M M O O O O O M O O O M M
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
O r r (Q N M O i~ M O I~ O r O M N N O 1~- d' N
+0+ r M O N O r r N N O r r M O N N O r r 0 0 0
0 ~ ~ N N M M M M M ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~ ~p
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o r
~~~~~~titi~~~~~~~~ti~~~~~
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~ ~ ~
~ N N O M CO M In M O O OD N ~t M lA `d' r O O M I~
Q r O O N O r O r r N r r O O O r O O N N r N
I~ M M O O O O O O O O O O O O O N r r r N N
O O O O O O O O O O O r ~- r r r ~ r r r r r
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
y O O O O O O O O O O O O O O O O O O O O O O
O ,y O O O O O O O O O O O O O O O O O O O O O O
V N O O O O O O O O O O O O O O O O O O O O O O
~ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
~ ~ N c`C
O C C C
~, N p N Y Y Y Y Y Y Y Y Y Y
+0+ V U U N CO CC C4 (6 ~+ N CC fII (B CB
y 4:«~fmmf~mmm~~ ~mmmmm~~ ~~~
C :~w ~~(n(Afn(4(AODO~~fA(AfAf4fnHF-mH00
~ ~ M O O ~ M M ~ ~ r ll') M ~ I~ 00 I~ O O ~ [` M ~ ~
~ ~ ~-' N M t1~ (p (p ~ ~ O ~ ~ r (p M O ~ O r N (D CO I~
V r N N N N~ N~ ~ 00 00 r 0 0 0 N~~ 00 00 In -f')
~ ~?' ~ 00 r r r r r 0 0 0 r N N N M O~ O r 0
O r r r r M M M M M r r O M M M M M N N r N r
t' Z O O O O O U7 In O O O O O O r r~ r L1')
O M M M M M t!') M M M M M
N f~ O
~ r r M
p N f~ O
~, N O r
p M N ~
~ O I~ O
~ r r N
~_
p
L
4~/
p Q
U ~ ~
a~~
o c~
o ~
w a+
m ~
07 ~
'~ r
'a N
~_ ~
~" ~
~ ,__
t
a~•~
m w
~ ~
d
L
OI
M
N
N
O
H