|
City of Arden Hills
<br />Investment Portfolio Analysis
<br />September 30, 2009
<br />er
<br />. .....
<br />aspri:
<br />Eat�
<br />trf::aV:t:ap
<br />.:.:.
<br />::::::::::...•
<br />::ytqsttaeht�
<br />eP
<br />:C:ata' o h!
<br />: C:b71Ce��:
<br />:: .:.: e'! o st:::::::::
<br />�t•i a
<br />Aniia:. auzed: -
<br />:
<br />ce
<br />ta'
<br />: C liSip:
<br />•
<br />t ati • bit
<br />�tiu'
<br />sA "u' '�
<br />n#
<br />4M Fund
<br />30 Days
<br />MM
<br />MN Municipal.
<br />al Liquid Asset Fund (General.)
<br />17%
<br />583 166.82
<br />0.130%
<br />.sd .ma
<br />$758.12
<br />4M Fund
<br />30 Days
<br />MM
<br />MN Municipal Liquid Asset Fund (Payroll)
<br />2%
<br />74 897.03
<br />0.130%
<br />$97.37
<br />4M PLUS Fund
<br />90 Days
<br />MM
<br />MN Municipal PLUS Fund General
<br />9%
<br />320 346.01
<br />0.330%
<br />1,057.14
<br />4M PLUS Fund
<br />90 Days
<br />MM
<br />MN Municipal PLUS Fund PIR
<br />3%
<br />112 684.39
<br />0.330%
<br />371.86
<br />Affinity Plus
<br />30 days
<br />MM
<br />Share-S1
<br />Affinity Plus Share Account
<br />0%
<br />69.56
<br />0.500%
<br />0.35
<br />Affinity Plus
<br />01/22/09
<br />884 Days
<br />MM/CD
<br />178
<br />Affinity Plus Odyssey Certificate
<br />0%
<br />0.00
<br />5.461%
<br />0.00
<br />Affinity Plus
<br />01/22/09
<br />884 Days
<br />MM/CD
<br />178.1
<br />Affinity Plus Odyssey Certificate
<br />0%
<br />0.00
<br />5.461%
<br />0.00
<br />Affinity Plus
<br />10/03/10
<br />884 Days
<br />MM/CD
<br />195
<br />Affinity Plus Odyssey Certificate
<br />39%
<br />1,375,768061
<br />3.203%
<br />44 065.87
<br />Wells Faro
<br />30 Days
<br />MM
<br />Wells Faro Govt MM Fund
<br />1%1
<br />23 861.56
<br />0.009%
<br />2.15
<br />Saloman Smith BarneySB
<br />Cash Clearing Account
<br />0%1
<br />0.00
<br />0.000%
<br />0.00
<br />Wachovia
<br />30 Days
<br />MM
<br />Ever reen US Govt MM Fund
<br />29%1
<br />994 606.52
<br />0.010%
<br />99.46
<br />Sub -Total
<br />I
<br />29%
<br />3,485,400.50
<br />1.333%1
<br />46 452.31
<br />Dain Rauscher Corp0.00
<br />Dain Rauscher Corp
<br />Dain Rauscher Corp
<br />Saloman Smith Barne
<br />Saloman Smith Barney12/12/07
<br />12/07/07
<br />12/12/12
<br />12/12/11
<br />5 yr
<br />4 yr
<br />CD
<br />CD
<br />381426FEO
<br />9393791-197
<br />Goldman Sachs Bank
<br />Washington Mutual Bank
<br />1%,
<br />1%
<br />96 000.00
<br />96 000.00
<br />4.600%
<br />4.550%
<br />4,416.00
<br />4,368.00
<br />Saloman Smith Barney12/14/07
<br />12/14/10
<br />3 yr
<br />CD
<br />95989P6M6
<br />Western Bank PR
<br />1%
<br />96 000.00
<br />4.600%
<br />4,416.00
<br />Saloman Smith Barney12/20/07
<br />12/20/12
<br />5 yr
<br />CD
<br />844776DF8
<br />Southwest Bank of St Louis MO
<br />1%
<br />96 000.00
<br />4.650%
<br />4,464.00
<br />Saloman Smith Barney12/20/07
<br />12/20/12
<br />5 yr
<br />CD
<br />553036FG4
<br />M&I Bank FSB NV
<br />1%
<br />96 000.00
<br />4.650%
<br />4,464.00
<br />Saloman Smith Barney12/20/07
<br />12/20/12
<br />5 yr
<br />CD
<br />55405PFBO
<br />M&I Marshall & lisley Bk WI
<br />1%.
<br />96 000.00
<br />4.650%
<br />4,464.00
<br />Saloman Smith Barney12/28/07
<br />12/28/11
<br />':>':: "':<':1>
<br />CD
<br />173702CL3
<br />Citizens Bank MI - Callable
<br />0%
<br />0.00
<br />4.900%
<br />0.00
<br />Wells Faro
<br />07/16/09
<br />08/16/10
<br />1 r
<br />Muni
<br />050006BS3
<br />Atwater -Cosmos -Grove City Bond
<br />4%
<br />502 665.00
<br />1.502%
<br />7,550.03
<br />Wells Faro
<br />07/15/09
<br />12/01/12
<br />3.5 Vr
<br />Muni
<br />777543PD5
<br />Rosemount IL Taxable FACS Im r
<br />2%
<br />217 449.11
<br />2.500%
<br />5,436.23
<br />Wells Faro
<br />11/24/08
<br />05/ 11/ 3
<br />M Muni
<br />977100AS5
<br />Wisconsin State Rev Bond -Callable
<br />4%
<br />501 322.50
<br />4.140%
<br />20 754.75
<br />Wells Faro
<br />01/29/09
<br />12/01/13
<br />5 yr
<br />Muni
<br />604129LN4
<br />State of Minnesota GO -Taxable
<br />3%
<br />355 484.50
<br />2.900%
<br />10 309.05
<br />Wells Faro
<br />02/12/09
<br />02/01/14
<br />5 yr
<br />Muni
<br />777594WX6
<br />Rosemount MN School Dist 196
<br />3%
<br />337 461.30
<br />3.500%
<br />11 811.15
<br />Wells Faro
<br />01/07/09
<br />02/01/17
<br />8 yr
<br />Muni
<br />688443,127
<br />Osseo MN School Dist 279 OPEB Bonds
<br />2%
<br />259 692.50
<br />5.400%1
<br />14 023.40
<br />Wells Faro
<br />07/06/09
<br />07/06/12''
<br />'Aenc`
<br />3133XTZ41
<br />FHL Step-up Callable
<br />2%
<br />250 000.00
<br />1.250%
<br />3,125.00
<br />Wells Faro
<br />08/27/09
<br />08/27/19
<br />#3 .'"'s}<':
<br />Agency
<br />3133XUKJ1
<br />FHL Step-up Callable
<br />2%
<br />250 000.00
<br />3.000%
<br />7,500.00
<br />Wells Faro
<br />08/26/09
<br />08/26/14
<br />5 yr
<br />CD
<br />06740KAY3
<br />Barclays Bank DE Willington, DE
<br />1%
<br />95 000.00
<br />3.150%
<br />2,992.50
<br />Wells Faro
<br />12/12/07
<br />12/12/12
<br />5 Yr
<br />CD
<br />14041AVJ5
<br />Capital One Bk-VA/CD
<br />1%
<br />95 000.00
<br />4.500%
<br />4,275.00
<br />Wells Faro
<br />09/02/09
<br />09/04/12
<br />3 Yr
<br />CD
<br />149159GV1
<br />Cathay Bk. Los Angeles, CA
<br />1%
<br />95 000.00
<br />2.350%
<br />2,232.50
<br />Wells Faro
<br />09/08/09
<br />03/08/13
<br />3.5 Yr
<br />CD
<br />300185AN5
<br />Ever reen Bank Grp,IL
<br />1%
<br />95 000.00
<br />2.400%
<br />2,280.00
<br />Wachovia Securities
<br />01/06/09
<br />07/06/12
<br />>> 5i' :>':€':
<br />Agency
<br />3128X8CG5
<br />FHLMC Step-up,Callable
<br />0%
<br />0.00
<br />2.653%
<br />0.00
<br />Wachovia Securities
<br />06/03/08
<br />06/03/13
<br />Agency
<br />3136F9-QX-4
<br />Fannie Mae Step -Up - Callable
<br />0%
<br />0.00
<br />4.125%
<br />0.00
<br />Wachovia Securities
<br />01/29/09
<br />01/29/14
<br />i<i ' ':`":>':
<br />Agency
<br />31288X8FN7
<br />FHLMC Step-up Med Trm Note Callable
<br />3%
<br />349 825.00
<br />3.312%
<br />11 586.20
<br />Wachovia Securities
<br />02/04/09
<br />02/04/14
<br />;' :
<br />A enc
<br />3136F95G4
<br />FNMA Step-up,Callable
<br />1%
<br />150 000.00
<br />2.000%
<br />3,000.00
<br />Wachovia Securities
<br />05/19/09
<br />05/19/14
<br />:'":;>` <
<br />A enc
<br />3128X8-ZN-5
<br />FHLMCSCMTN-Callable
<br />8%
<br />1,000,000.00
<br />2.000%
<br />20 000.00
<br />Wachovia Securities
<br />06/25/09
<br />06/25/14::
<br />Aqencv
<br />3133XT-TK-2
<br />FHLSCB Series 2 - Callable
<br />0%
<br />0.00
<br />2.000%
<br />0.00
<br />Wachovia Securities
<br />06/30/09
<br />06/30/14
<br />;:''":
<br />Agency
<br />3133XT-VW-3
<br />FHLBSCB Series 7 - Callable
<br />0%
<br />0.00
<br />2.000%
<br />0.00
<br />Wachovia Securities
<br />Wachovia Securities
<br />08/26/09
<br />10/15/09
<br />08/26/14
<br />10/15/14
<br />.... '':
<br />€ ::'`:
<br />Aqency
<br />Agency
<br />3128X9-DE-7
<br />3133XU-YV 9
<br />FHLMCSCMTN Callable
<br />FHLBSCB Callable
<br />3%
<br />5%
<br />300 000.00
<br />650 000.00
<br />2.000%
<br />2.000%
<br />6,000.00
<br />13 000.00
<br />Wachovia Securities
<br />10/22/09
<br />10/22/14
<br />:: ` <>1
<br />Agency
<br />3133XV-6X-4
<br />FHLBSCB Series 2 Callable
<br />4%
<br />500 000.00
<br />2.000%
<br />10 000.00
<br />Wachovia Securities
<br />03/03/08
<br />03/03/15
<br />" * :"':
<br />Agency
<br />3128X6-4X 1
<br />FHLMCC Med Term Note - Callable
<br />0%
<br />0.00
<br />4.810%
<br />0.00
<br />Wachovia Securities
<br />02/08/08
<br />08/06/15:"'''
<br />Agency
<br />3135A1-CN-5
<br />Fannie Mae Step -Up - Callable
<br />0%
<br />0.00
<br />4.276%
<br />0.00
<br />Wachovia Securities
<br />12/14/07
<br />12/12/17#"::
<br /><
<br />Agency
<br />3136F8XS9
<br />FNMA StepUp Coupon Bond -Callable
<br />0%1
<br />0.00
<br />4.990%
<br />0.00
<br />Wachovia Securities
<br />12/18/07
<br />12/18/17
<br />ii"'':
<br />Agency
<br />3128X6-TD-8
<br />FREDDIE MAC/Step Coupon Bond - Callable
<br />0%
<br />0.00
<br />5.260%
<br />0.00
<br />Wachovia Securities
<br />10/29/08
<br />04/29/16
<br />Agency
<br />3128X7-3F-9
<br />FHLMCMTN-Callable
<br />0%
<br />0.00
<br />6.000%
<br />0.00
<br />Wachovia Securities
<br />04/16/08
<br />04/16/18
<br />?:>':i:.`:?
<br />Agency
<br />3128X7JX3
<br />FHLMC Ste U -Callable
<br />0%
<br />0.00
<br />4.000%
<br />0.00
<br />Wachovia Securities
<br />03/14/08
<br />03/13/09
<br />1 yr
<br />CD
<br />36185A-QY-7
<br />GMAC Bank - Midvale UT
<br />0%
<br />0.00
<br />3.600%
<br />0.00
<br />Wachovia Securities
<br />03/18/08
<br />03/18/09
<br />1 r
<br />CD
<br />98233P-ND-5
<br />Wright Express Finl - UT
<br />0%
<br />0.00
<br />3.600%
<br />0.00
<br />Wachovia Securities
<br />06/18/08
<br />06/18/09
<br />1 yr
<br />CD
<br />140653-VX 1
<br />Ca mark Bank
<br />0%
<br />0.00
<br />3.450%
<br />0.00
<br />Wachovia Securities
<br />06/18/08
<br />06/18/09
<br />1 yr
<br />CD
<br />795450-DL-6
<br />Sallie Mae Bank
<br />0%
<br />0.00
<br />3.400%
<br />0.00
<br />Wachovia Securities
<br />06/19/08
<br />06/19/09
<br />1 W
<br />CD
<br />19882-DE-9
<br />Columbus Bank & Tr Co
<br />0%
<br />0.00
<br />3.400%
<br />0.00
<br />Wachovia Securities
<br />03/12/08
<br />09/14/09
<br />1.5 yr
<br />CD
<br />00759T-XR-5
<br />Advanta Bank Corp- UT
<br />0%
<br />0.00
<br />3.600%
<br />0.00
<br />Wachovia Securities
<br />12/26/08
<br />12/28/09
<br />:''":
<br />CD
<br />61747-M-TG-6
<br />Morgan Stanley Bank UT
<br />1%
<br />96 000.00
<br />2.150%
<br />2,064.00
<br />Wachovia Securities
<br />12/30/08
<br />12/30/09
<br />1 w
<br />CD
<br />36159S-EQ-0
<br />GE Money Bank
<br />1%1
<br />96 000.00
<br />2.200%
<br />2,112.00
<br />Wachovia Securities
<br />07/25/08
<br />01/25/10
<br />ti
<br />CD
<br />92977E-PW-5
<br />Wachovia Bank Charolotte NC
<br />1%
<br />96 000.00
<br />4.000%
<br />3,840.00
<br />Wachovia Securities
<br />07/25l08
<br />01/25/10
<br />CD
<br />929781-FB-3
<br />Wachovia Bank Las Vegas NV
<br />1%
<br />96 000.00
<br />4.000%
<br />3,840.00
<br />Wachovia Securities
<br />07/30/08
<br />02/01/10
<br />itr 1
<br />CD
<br />5252OK-WL-7
<br />Lehman Bros Coml Bank
<br />1%
<br />96 000.00
<br />4.000%
<br />3,840.00
<br />Wachovia Securities
<br />08/13/08
<br />02/16/10
<br />€; i # s €
<br />CD
<br />25469J-RG-6
<br />Discover Bank DE
<br />1%
<br />96 000.00
<br />4.200%
<br />4,032.00
<br />Wachovia Securities
<br />09/15/08
<br />03/15/10
<br />18 mo
<br />CD
<br />59012Y-TS-6
<br />Merrick Bank UT
<br />1%
<br />96 000.00
<br />4.000%
<br />3,840.00
<br />Wachovia Securities
<br />10/08/08
<br />04/08/10
<br />'
<br />CD
<br />200339-CN-7
<br />Comerica Bank
<br />1%1
<br />96 000.00
<br />4.050%
<br />3,888.00
<br />Wachovia Securities
<br />10/15/08
<br />04/15/10f
<br />CD
<br />195554-PH-7
<br />Colonial Bank NA
<br />0%
<br />0.00
<br />4.050%
<br />0.00
<br />Wachovia Securities
<br />10/29/08
<br />04/29/10
<br />i<'i1
<br />CD
<br />17284P-M9-3
<br />CIT Bank Salt Lake City,UT
<br />1%
<br />96 000.00
<br />4.050%
<br />3,888.00
<br />Wachovia Securities
<br />11/07/08
<br />05/07/10
<br />?Ii
<br />CD
<br />433411-BV-6
<br />Hinsdale Bank & Trust
<br />1 %
<br />96 000.00
<br />4.050%
<br />3,888.00
<br />Wachovia Securities
<br />11/13/08
<br />05/13/10
<br />'i# f »':
<br />CD
<br />319054-KE-1
<br />1st Bank Beverly Hills
<br />0%
<br />0.00
<br />4.050%
<br />0.00
<br />Wachovia Securities
<br />10/07/08
<br />10/07/10
<br />€#1
<br />CD
<br />336472-CY-9
<br />1 st State Bank Union City TN
<br />1%
<br />96 000.00
<br />4.000%
<br />3,840.00.
<br />Wachovia Securities
<br />10/08/08
<br />10/08/10
<br />ffiao
<br />CD
<br />42721 E-FZ-7
<br />Heritage Bank of Commerce
<br />1%
<br />96 000.00
<br />4.000%
<br />3,840.00
<br />Wachovia Securities
<br />10/08/08
<br />10/08/10
<br />2 #
<br />CD
<br />49306S-FS-0
<br />Key Bank Nati Assoc Cleveland OH
<br />1%
<br />96 000.00
<br />4.250%
<br />4,080.00
<br />Wachovia Securities
<br />10/08/08
<br />10/08/10
<br />` €€I
<br />CD
<br />61747M-NT-4
<br />Morgan Stanley Bank UT
<br />1%
<br />96,000.00
<br />4.250%
<br />41080.00
<br />Wachovia Securities
<br />10/09/08
<br />10/12/10
<br />CD
<br />36159S-BW-0
<br />GE Money Bank
<br />1%
<br />96 000.00
<br />4.200%
<br />4,032.00
<br />Wachovia Securities
<br />11/12/08
<br />11/12/10
<br />24 mos
<br />CD
<br />0258OV-AW-5
<br />American Express Bank
<br />1%
<br />96 000.00
<br />4.250%
<br />4,080.00
<br />Wachovia Securities
<br />12/01/08
<br />12/01/10
<br /><'; r;
<br />CD
<br />05568PMKO
<br />BMW Bank Salt Lake City1%
<br />96 000.00
<br />4.150%
<br />3,984.00
<br />Wachovia Securities
<br />06/03/09
<br />12/03/11
<br />i
<br />CD
<br />795450-LU-7
<br />Sallie Mae Bank
<br />1%
<br />150 000.00
<br />2.650%
<br />3,975.00
<br />Sub Total
<br />Fixed Rate Instruments
<br />71%
<br />8,361,899.91
<br />2.985%
<br />249 610.80
<br />�. ---
<br />:I tyre t " :ptccr�e�# :
<br />:Ma e. Haire � r�'�e�st:
<br />$583 166.82 2,966.67 -
<br />$74 897.03 705.27 -
<br />320 346.01 1,691.63 -
<br />112 684.39 341.65 -
<br />69.56 0.27 -
<br />0.00 2,098.34 -
<br />0.00 2,099.34 1,375,768.61 30 061.34 -
<br />23 861.56 43.84 -
<br />0.00 - -
<br />99,363.84
<br />98,925.12
<br />99,192.00
<br />99,192.00
<br />99,192.00
<br />0.00
<br />504,775.00
<br />205,902.00
<br />480,990.00
<br />357,875.00
<br />343,965.60
<br />273,250.00
<br />250,625.00
<br />251,485.00
<br />94,249.50
<br />98,658.45
<br />94,908.80
<br />94,415.75
<br />�0.00
<br />0.00
<br />349,024.20
<br />150,281.25
<br />17002,561.00
<br />0.00
<br />0.00
<br />301,024.50
<br />650,000.00
<br />500,000.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />0.00
<br />96,335.04
<br />96,349.44
<br />96,949.44
<br />96,949.44
<br />97,002.24
<br />97,188.48
<br />97,340.16
<br />97,526.40
<br />0.00
<br />98,513.28
<br />98,518.08
<br />98,761.92
<br />98,746.56
<br />99.025.05
<br />Total Investments
<br />100%1
<br />$11,847,300.411 T499%1 $296,063.111 $ 1 11,897,980.701
<br />$240 826.88 $0.00
<br />= callable
<br />Overall Annualized Rate of Return
<br />2.499%
<br />Interest Rec' 2009
<br />$240,826.88
<br />Annualized Rate of Return w/o Money Market
<br />2.985%
<br />2008 Int Rec'd 2009
<br />$58,192.70
<br />Benchmark - 4M Plus Rate
<br />0.330%
<br />2009 Int not Rec'd
<br />Total 2009 Int Income
<br />$182,634.18
<br />
|