Quarterly Investment Report 9 30 09THE CITY OF Dubuque
~T '~~ ~ AlaAmedcaCity
~„J t
Masterpiece on the Mississippi
2007
TO: The Honorable Mayor and City Council Members
FROM: Michael C. Van Milligen, City Manager
SUBJECT: September 30, 2009 Quarterly Investment Report
DATE: October 29, 2009
Finance Director Ken TeKippe is transmitting the attached September 30, 2009
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 ~~
~_
UB "~
Masterpiece on the Mississippi
TO:
FROM:
RE:
DATE:
Dubuque
AA-AmedcaC~f-
2007
Michael C. Van Milligen, City Manager
Kenneth J. TeKippe, Finance Director
e c ~,;
September 30, 2009 Quarterly Investment Report
October 27, 2009
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 July 1, 2009 through September 30, 2009.
The report includes: Cash Investments and Investment Earnings Summary
for quarter ended September 30, 2009 and fiscal year to date
Schedule of City Funds
Monthly Investment Summary
Schedule of Accrued Interest
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 September 30, 2009 8~ Fiscal 2010 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 Earninas:
City
Metro
Combined
96, 934 96, 934 -
10,729,696 10,730,943 1,247
19, 550, 000 19, 592, 315 42, 315
2,015,125 2,275,954 260,829
11, 514 61, 950 50, 436
25,842,497 26,103,577 261,080
58,245,766 58,861,673 615,907
71,215,650 71,563,146 347,496
10, 911, 771 10, 933, 545 21, 774
58,245,766 58,861,673 369,270
Quarter Year-To-Date
440,452
39,087 440,452
39,087
479,539 479,539
33,132
125 33,132
125
33,257 33,257
407,320
38, 962 407,320
38, 962
446,282 446,282
City of Dubuque
Schedule of City Funds
September 30, 2009
FY10
FINANCIAL ADVISORS MANAGED FUNDS
PORTFOLIO TOTAL
COMPOSITION COST CITY FUNDS
PERCENTAGE BASIS PERCENTAGE
DANA INVESTMENT ADVISORS, INC:
Cash and Equivalents 2.4% 156,280
US Treasury Obligations 0.0%
US Agencies 97.6% 6,346,938
Mortgaged Backed Securities 0.0%
Total 100.0% 6,503,218 11.2%
DUBUQUE BANK 8~ TRUST:
Cash and Equivalents 2.7% 221,397
US Treasury Obligations 83.0% 6,880,197
US Agencies 0.3% 26,012
Mortgaged Backed Securities 0.0%
Mutual Funds 14.0% 1,159,405
Total 100.0% 8,287,011 14.2%
FIRST COMMUNITY TRUST:
Cash and Equivalents - 3.5% 111,280
US Treasury Obligations 0.0%
US Agencies 32.7% 1,036,583
Mortgaged Backed Securities 63.8% 2,025,328
Total 100.0% 3,173,191 5.5%
US BANK:
Cash and Equivalents 18.5% 1,456,734
US Treasury Obligations 2.5% 200,781
US Agencies 56.6% 4,459,344
Mortgaged Backed Securities 22.4% 1,762,218
Total 100.0% 7,879,077 13.5%
GRAND TOTAL 25,842,497 44.4%
BREAKDOWN BY TYPE OF SECURITY:
Cash
Mortgage Backed Securities
Mutual Funds
US Treasury Obligations
US Agency Obligations
TOTAL MANAGED FUNDS
TOTAL CITY FUNDS
7.5% 1,945,691 3.3%
14.7% 3,787,546 6.5%
4.5% 1,159,405 2:0%
27.4% 7,080,978 12.2%
45.9% 11, 868, 877 20.4%
100.0% 25,842,497 44.4%
58,245,766 100.0°~
RECAP OF PORTFOLIO PERCENTAGES Managed City Combined
CASH 3°h 0% 4°i6
CHECKING /SAVINGS ACCTS 0% 18°k X18%
MUTUAL FUNDS {U. S. GOVERNMENT) 2°h 0% 2°h
MORTGAGE BACKED SECURITIES 7% 0°h 7°h
CERTIFICATES OF DEPOSIT 0°h 34% 34%
U. S. TREASURY OBLIGATIONS 12°h 3°h 16%
FEDERAL AGENCY OBLIGATIONS 20% 0% 20%
rora- as ~ ss ~ ~ 00°~
Page 2
City of Dubuque FY10
_
Schedule of City Funds
September 30, 2009
TOTAL
COST CITY FUNDS
City Managed Funds BASIS PERCENTAGE
CASH
Change and Petty Cash Funds 11,934
Prescriptions & Workers-Comp Deposits 85,000
Total 96, 934 0.2%
CHECKING /SAVINGS ACCOUNTS:
American Trust & Savings Bank (General & Fieaitn) 689;987
American Trust & Savings Bank (Housing Rehab ~ section a) 148,868
Dubuque Bank & Trust (Premium savings) 1,000,000
Dubuque Bank & Trust (GeneravMetro/Leisure) 2,331,816
Dubuque Bank & Trust (comml/Ind Bldg Rehab ~ Econ cev) 100,160
Dubuque Bank & TfUSt (Cable Franchise Equipment Fund) 273,916
US Bank (General/Ambulance) 14,109
Premier (utlllry) 8, 539
Liberty (utlllry) 12,657
East Dubuque Savings Bank (Advantage savings) 1,000,000
East Dubuque Savings Bank (utlliry) 15,527
State Central (utihry) 4,017
Total 5, 599, 596 9.6%
BOND PROCEEDS:
US Bank (Sanitary Sewer Bond Proceeds) 305,914
DB&T GO Stormwater Series 2008A 746,483
DB&T GO Urban Renewal Series 20086 523,590
DB&T Water Rev Bond Series 2008D 181,783
Total 1, 757, 770 3.0%
CERTIFICATES OF DEPOSIT:
American Trust & Savings Bank 2,750,000
Dubuque Bank & Trust 7,000,000
East Dubuque Savings Bank 2,000,000
Liberty Bank 4,800,000
Premier Bank 3,000,000
State Central 0
Total
PORT OF DUBUQUE PARKING RAMP
Project Construction Fund US Bank (Bond Proceeds) ~o2s
Capitalized Interest Fund EDSB (Bond Proceeds) ~o2s
Debt Service Reserve u.s. Treasury obligations (Bond Proceeds)
Total
CORPORATE STOCK (Lyons Peony Trust>
TOTAL OTHER FUNDS
19,550,000 33.6%
2, 057, 362 3.5%
1, 314, 968 2.3%
2, 015,125 3.5%
5,387,455 9.3%
11,514 0.0%
32,403,269 55.6%
Pape 1
0 ~
O N
C
O ,p
M E
~ O
o U
O)
C
V
C
W
L
c U
0
d
N
C
R
H
~"' ~ _
LL
~ f~q U
0 ~
S ojj
Z
0
N
R
N M m O O OVA O '7 0 ~O R n ~ N 0
o
v on oao nvmo n v ~ ao ~ n
n
OO 00 S O N O) x 0 0 0 O •'V t0 t0 n 10 N
O N 0 f0 O 0 In 00 (0 n
~
M r ~ O N R
.
. t0 M N n O e
-•
~ N
~ O O . ll] O N ~ O n
~
'
V f
~I j
~v ~' v f
0 V O
0
O
N O N n t0 r 00
.M
. N N N
~ t0 .. (0
O ~ ~ N O l ~ ~ N
M
N
r ^ ~ f
0 f
D f
7
O
N
N 0
N O v '7 CO In 'Q ~O
O
n
O
-
~
N
N
O
W ~
p
O N 0
M l
fJ st O R fD n n
~ ~ ~ ~ M M
~
N 00(000 V 00 O O f0 (0 M M f0O
M NnOOO t~tt O r N N N Apr ,
O M
N 0O r 0
0 ~ ~ M CEO ^r
N
N t
O
@') r 0
R 0
0
O N 00
N V' '7 ~ 0 0 IO
v v M ~ 'N 0
00 V
00
O O r r
0
N N N
N N N
N~ ~ ~ ~ N N 0
0
~ e e
N V 0
0
0
0
N b
N ~ W ~ Ov (O O O ~ e00- N~ O r
0 O n n O N b
0
C N f
7 f
0 0
c0 00 OD 0 0 0
n n n n n r~
M ~ ~ ~ v r v
~
0 e e
O V M n t V f
O
0 0 '~T ~ 0 f0 O 10
M
Q) M
n ~ 00 V 'V' 0 0 0
f0 CD
0~ 0 O N
m" rn m u~o
~°- ~ r ~
M M M M M M
In N M 0 O a) W In N 0 N M V1 0 0
rn ov in nM o v, v ~n vOV, n ~
0
0 M 0
0 ~ ~ r M N~O 10 0
N
0 0
0
1
In 'V' a
0
O ~
0 (
(
O fv 0 O O O O O O N
~
0 0 v .M
i n n O O~~
N `
-' . N N CM~1 M N M
0 CD OD CO O 00
~ N ~ ~ N N ~ M
M
O e e
e
- e
-• ~ O
O
O
D
00 00 'R V) l0 n n 00 O n n N p
~ n N'
OD N N
f0 to
v to
IA
N
~
N t0
00 M )n a0
'R iD 0O O )ri
v N N
~ N N N N N N
V) 0 N f0 f0 0
N N
O O C
v 't'' E o
Q ~
t c
~ C y C ~ N > N
h
o
V)
~
- ~ ~
~ ~ m
F-'
N
01
` C `
` t U
~ ~
~
-~ o ~ ,
o_ `' ~ v
Q ~ ~
V
d = oa
U~ ~
7
`m
Z
Q L N
~
7 O
7 C m
~
._+ m O A O ,O E
(7 C N N ~ ~ m ~ Of , 3 .~' v V
Q ~ N v ~
3
d ~ ~' d ` ~ d~ d U~ m
0 C V) w ~
lL m ` O) A Y U Y N~ N
C ~ C 07
_C N N
_ O ~O
L ~ U m Op U
Q A m Q
7 U
7
~ a W O d N C IL w a
-. V ~ ~ ~ 0 d
V v_)
• W~
Y! ~ p E~ A~
= N L O C w C C;
A ~ 6' O
m y O) d ` m
m m
w w m W ~ N~ (Ctl l0 d C ~ 7 B U Y ~ w N C l0
O 'O C d' U' j~ U 00 U p Z C >~ > Q Oi ~ A~ F
U Q h v w S a 5 ~ a ~
m ~ ~ ~ °a
~ eV b N to ~'
q~ ~
J ~'
M
n ~ ~ ~ N
'O ~ O N h O ~ ~
m
U m •.0.
} o
.O
N M ^ ~ N V a
Y N 1
oei u v uo .
- ri m
~
J
~E
J O ~ N H q
ry,o
m 0 0 0 0
c
~ o
Q
O
m c
m o
m
~
m ~
m
16
O
~ ~
c
m m
~
~ F
- ~
-
m t
~ a E
~ p E E N m
L c t
p
Y W
J
J
J O
U ~
U
A
~.+
H
L
Q~ ~
~ O C
~ N ~
~ M
L ~
.fl Q
0
~ ~
U ~ ~
N ~
m
s
v
L N
d
V d
Q ~
d
L
V
U
Q
r
0 C~
L
..~
N ~
` ++
d lQ
C ~
~L ~
7 ~
~ G
0)
l6 y
t ~
~~
a
H NI
O H
U ~
m
c
0
~~ .~
N N
O =
Q
0)
O
d
~~
V w
U Z
V
I~ O O O 01 CA 00 N ~ r OO OO r ~ I~ I~ ~ tf~ 00 I~
M OO 1~ r ~ O ~} ~ O ~ ~ O r M O ~ I~ 'cr t1') ~
r ~ ~ N OO CO ~ M N 00 ~ ~' ~ ~ ~ N ~ O (O N
CD -n M tf) O M O O I~ N tt 'ct O 00 O ~ (O M ~ ~
CO 00 CA ~' O O I~ M M O 0 M M~ CO Op 0 M N r
~t ~ M N M N N N N N r r r
r OO I~ M O of ~ N r~ 00 CA CO O M r -n r O M
00 0 (fl ~ M M N r r 0 I~ (fl ~ d' ~ ~' M N N r
r r r r r r r r r r
r~ 00 O M N <O r 00 r 0 In I~ e r r OO N r M
r N ~ N ~ I~ f~ N O to N 0 (O d' ~ (O (O r
r r r r r T r
\ \ \° \ \ \ \ \ \ \ \ \° \ \ \° \° \ \ \ \
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 N O r 0 4[') 0 0 0 0 0 0
I~ ~ (fl 00 O O O 00 OO r 1~ r ~ 00 O -n O O ~ O
r O 00 I~ ~ 00 f~ 1~ I~ I~ 1~ 1~ 00 -n ~ I~ -n -C) ~ ~
Ir x 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
rn rn rn rn rn rn rn rn rn rn o rn o rn rn o 0 0 0 0
O O O O O O O O O O r O r O O r r r r r
r~ OO O N N~ O n r ~t ~~ M O 00 ~ r O r
O r O N r N N r r N r N O O M r N r r N
O O O O r 0 r N N O r r N N r N N M M r
r r r r r r r r r r O r O 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 O
N~ c0 O H O 00 O r 00 sr M l[') N ao 0 0 0 O~
O r r M r r N r r r r N O r r N N O r r
v v v~ ~n ~n ~n co m cfl ~ ~ o ao 0 o ao rn rn rn
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
O O O to 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
M o o 1~ 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
N N W ~ ~+{J ~ W W W V/ ~N VJ ~ N ~ W ~ ~ Q~
~.n00HI-000~~H-pmp ~~ X00 ~00~00
J J p Q Q p p Q Q W p W 4. J d p a p J p
~' M O
O (00 000 0~0 000 000 O O r ~ ~
1~ r 00 00 00 00 CD 00 O r r 'cF N
r 00 (O ~ 0 0~ Ln ~ 0 M I~ O N O N 00 r N
M N r N N ~t I~ N N M I~ M C~• O ~t r~ 1~ M O
N N d' r r -~ ~ r r N P• N (~• -n ~ O) ~ O N r
INII
0
0
0
0
tf~
rn
r
w
O
H
~ r ~ ~
~ r O r
N ~ ~ ~
~ I~ ~ N
~ r ~ O
U N ~ M
U
Q
U O O O
U O O O
C O O O_
~ O O O
f0 ~ O Ln
m ~ O In
p
U r
v Q
~I ~
O
C ~ f"~
p U
0
C9 ~'
~ ~
O 1~
m ~
o
r
t ~
Cl 'L
t
C1
(~O• N
~ H r Ln
` L ~ O
V ,~~,,
Q ~
.a
~ = o 0
Q Q 'ct O
r N
°o °o_
rn
~ ~ °o °o
:a ~ O O
~ ~ r r
W m
c
H o1S (A
N ~ p W
C
3
O
r
a `°
~°;~~
.tie Q Z c0 ~
00
I0
~ r
0
0
0
0
O
O