HomeMy WebLinkAboutAgenda Report - February 1, 2006 E-04AGENDA ITEM F.4
j" CITY OF LODI
COUNCIL COMMUNICATION
AGENDA TITLE: Accept the Quarterly InvestmentAccount report as required by law SB 564
MEETING DATE: February 1,2006
PREPARED BY: Finance Director/Treasurer
RECOMMENDED ACTION: That the City Council by motion/action accept the quarterly report of the
City of Lodi pooled money investment account as required by SB 564.
BACKGROUND INFORMATION: SB 564 required local agency treasurers to submit a report on
investments at a public meeting. The City of Lodi has an investment policy, which is submitted to council
for approval on an annual basis. Copies of the policy are available in the Finance Department.
City of Lodi maintains membership in the California Municipal Treasurers Association and conformsto
guide lines set forth by the CMTA investment report committee.
FUNDING: None
Prepared by Maxine Cadwallader, Revenue Manager
Attachment
52 • �
Ruby P ' to
Interim Finance Director
APPROVED: or —'
Blair King, City Manager
City of Lodi
Portfolio Management
Portfolio Summary
December 31,2005
City of Lodi
300W. PineSt.
Lodi. CA 95240
(209) 333-6800
Investments
27,342,461.10
27,342,461.10
Total Earnings December 31. Month Ending Fiscal Year To Date
Current Year 42, 535.82 337,797.48
Average Dally Balance 25,507,783.69 25,251,142.26
Effective Rate of Return 1.96% 2.65%
27,342,461.10
100.00% 4
3 1.283 1.300
Based on the approved budget and to the extent the budget is adhered to, liquidity is available for the next six months. Union Bank of California is the source of market valuation.
Marcella Maxine
II 011162906 - 15:28
, Revenue Manager
Portfolio CITY
AC
PM(PRF_PM7) Symflept V6.21
Report ver, 5A0
Par
Market
Book
%of
Days to
YTM
YTM
Investments
Value
Value
Value
Portfolio
Term Maturity
360Equly.
365Equly.
Local Agency Investment Funds
10,960,000 00
101960,000 00
10,960,000 00
4008
1 1
3 136
3150
Certificates d Deposit - Bank
200,000 W
200,000 W
200,000 00
073
365 229
3475
3-923
Passbook/Checking Accounts
16,162,461 10
16,182,461 10
16,182,461 10
5918
1 1
0.000
0.000
Investments
27,342,461.10
27,342,461.10
Total Earnings December 31. Month Ending Fiscal Year To Date
Current Year 42, 535.82 337,797.48
Average Dally Balance 25,507,783.69 25,251,142.26
Effective Rate of Return 1.96% 2.65%
27,342,461.10
100.00% 4
3 1.283 1.300
Based on the approved budget and to the extent the budget is adhered to, liquidity is available for the next six months. Union Bank of California is the source of market valuation.
Marcella Maxine
II 011162906 - 15:28
, Revenue Manager
Portfolio CITY
AC
PM(PRF_PM7) Symflept V6.21
Report ver, 5A0
City of Lodi
Portfolio Management
Portfolio Details- Investments
December31,20O5
Page 2
Average Purchase
Slated
YTM Days to Maturity
CUSIP fnvestment # Issuer Balance Date
Par Value
Market Value
Book Value
Rate Moody's
360 Maturity Dam
Local Agency Investment Funds
1
CENTRAL PLUME 77
Fanners and Merchants Bank 08/01/2005
7,839,876,00
7,839,876.00
LAIF 1000 Local Agency Invest Fund
101560,000.00
10,560,000.00
10,560,000.00
3.180
3.136 I
LPIC 1001 Local Agency Inv Fund (LP IC)
400,000.00
400,000.00
400,000.00
3.180
3,136 1
Subtotal and Average 13,630,987,74
10,960,000.00
10,960,000,00
10,960,000.00
1
3.136 1
Certificatesof Deposit - Bank
SYS76WEST 76 Bank of the West 04/17/2005 1001000.00 100,000.00 100,000.00 2,100 3.100 106 04/17@006
SY578 78 Bank of America 12/19/2005 100,000.00 100,000.00 100,000,00 3.850 3850 352 12!18/2008
Subtotal and Average
200,000.00 2w.ow.w 200,000.00 200,000 00
3.475 229
Passbook/Checking Accounts
BACK 4003
Bank of America 07/01/2005
0.00
0.00
000
0.000
1
CENTRAL PLUME 77
Fanners and Merchants Bank 08/01/2005
7,839,876,00
7,839,876.00
718-39,876.00
0.000
1
SYS4000 4000
Farmers Merchants
8,320,632.57
8,320,832,57
8,320,632.57
0,000
1
F8MPAYROLL 74
Fanners& Merchants Payroll 0710112005
21,952.53
21,95253
21,952,53
0,000
1
Subtotal and Average 11,676.815.95
16.182,481.10
16,182,46110
16.182,461,10
0 1 000
1
Total and Average 59
27,342,451,10
7
2, 461,10
1.283
3
Run Date: 01716/2006 - 1 5:27
Portfolio CITY
AC
PM(PRF_PM2) SymRaRt V6.21
Raoort Ver. 5.W
City of Lodi
Portfolio Management Page
Activity By Type
December 1,2005 through December 31,2005
Stated Transaction Purchases Redemptions
CUSIP Investinent# Issuer Rate Date or Deposits or Withdrawals Balance
Local Agency Investment Funds (Monthly Summary)
tAIF 1000 LocalAgencylrwesl Fund 3630 OW 4,600,00000
Subtotal 0.00 4,600,000.00 10,960,000.00
Certificatesof Deposit- Bank
SYS75 75 Bankof America 2450 12119/2005 OW 100,000.00
SYS78 78 Bank of America 3850 12/19/2005 100,000 00 OW
Subtotal 100.000.00 1 W. M. W 2w.ow.w
Passbook/Checking Accounts (Monthly Summary)
CENTRAL PLUME 77 Farmers and Merchants Bank
3,725,000-00
85.125.W
SYS4000 4wo Farmers& Merchants
17,790,166.86
13,816,660.74
F & M PAYROLL 74 Farmers& Merchants Payroll
233,142.11
237,223.24
Subtotal
21,748,308.97
14,139,008.98 16,182,461.10
Total
Run Dale: 01/1 &20D6 - 15:27
21,848,308.97 18,839,008.98
27,342,461.10
PortfolioCITY
AC
PM (PRF_PM3) SymRept V6.21
Report Ver. 5.DD
City of Lodi
Month
End
Year
Numberof
Securities
Portfolio Management
Activity Summary
December 2004 through December 2005
Yield to Maturity Managed
Total 360 365 Pool
Inverted Equivalent Equivalent Rata
Number
of Investments
Purchased
Number
of Investments
Redeemed
Average
Term
Page 4
Average
Days to Maturity
December
2004
7
30,790,072.40
1.519 1.540
1.980
1
1
3
2
January
2005
7
33,559,134.34
1.926 1.953
2.260
0
0
3
2
February
2005
7
36,714,529.16
1.942 1.969
2.260
0
0
3
2
March
2005
7
27,841,232.32
1.970 1.998
2.368
0
0
4
2
April
2005
7
25,915,748.41
1.987 2.015
2.380
1
1
4
3
2005
7
26,719,658.48
2.256 2.287
2.790
0
0
4
3
June
2005
7
25,1185,340.03
2.421 2.454
2.856
0
0
4
3
July
2005
7
25,895,548.17
2.273 2.305
2.856
2
0
4
3
August
2005
8
25,871,155.73
2.530 2.565
3.179
1
0
4
2
September
2005
8
26,0110,808.77
2.646 2.683
3.190
0
0
4
2
October
2005
8
25,098,221.20
2.755 2.793
3.180
0
0
4
2
November
2005
8
24,333,16111
2.028 2.057
3.180
0
0
4
2
December
2005
8
27,342,461.10
1.283 1,300
3.180
1
1
4
3
Average 7
27,813,620.66
2.11ffi 2.148%
2.743
0
0
4
2
Run Dale:01118l2006 - 1527
Portfolio CITY
AC
PM (PRF_PM4) SymRept V6.21
Report Ver. 5.00
City of Lodi
Portfolio Management
Distributionof Investments By Type
December 2004 through December 2005
Page5
Run Dale: 0111812006-15:27
Portfolio CITY
AC
PM (PRF PMS) SymAept V6.21
Report Ver. 5.00
December
January
February
March
April
May
June
July
August September
October November
December
Average
Security Type
2W4
2p05
2005
2005
2005
2005
2005
2006
2005
2005
2005
2005
2005
by Period
Local Agency Investment Funds
772
859
867
83.8
838
812
852
79.9
80.0
83A
87.1
64.0
40.1
78.3%
Certificates of Deposit- Bank
07
0 6
05
0.7
08
08
08
08
0.8
0.8
0.8
08
07
0.7%
Certificates of Deposit- S & L
Passbook/Checking Accounts
222
13.5
127
155
155
18.0
141
193
192
15.8
12.1
35.2
59.2
20.9%
Corporate Medium Term Note
....
_....
Commercial Paper- Interest Bearing
Repurchase Agreements
_ ...
FederalAgency Issues• Coupon
Treasury Securities - Coupon
Mortgage Backed Securities
Bankers Acceptances-Amortlzing
Commercial Paper Disc. -Amortizing
Federal Agency DISC. -Amortizing
__ ..
Treasury Discounts -Amortizing
Misceilaneous Discounts -Amortizing
Run Dale: 0111812006-15:27
Portfolio CITY
AC
PM (PRF PMS) SymAept V6.21
Report Ver. 5.00
City of Lodi
Portfolio Management
Page
Interest Earnings Summary
December31,2005
December 31 Month Ending
Fiscal Year To Date
CDICouponlDlscount Investments:
Interest Collected
389.44
2,952,34
Plus Accrued Interestat Endof Period
170.65
170.65
Less Accrued interest at Beginning of Period
f 31.61)
{ 235.76)
Less Accred Interest at Purchase During Period
( 0.00)
( 0.00)
Interest Earned during Period
528.48
2,887.23
Adjusted by Premiums and Discounts
0.00
0.00
Adjusted by Capital Gains or Losses
0.00
0.00
Earnings during Periods
520.48
2,867.23
Pass Through Securities:
Interest Collected
0.00
0.00
Plus Accred Interestat End of Period
0.00
0.00
Less Accred Interest at Beginning of Period
( 0.00)
{ 0.00)
Less Accred Interest at Purchase During Period
{ 0.00)
( 0.00)
interest Earned during Period
0.00
0.00
Adjusted by Premiums and Discounts
0.00
0.00
Adjusted by Capital Gains or Losses
0.00
0.00
Eamingsduring Periods
0.00
0.00
Cash/Checking Accounts:
Interest Collected
0.00
327,010.65
Plus Accred Interest at End of Period
170,867,22
170,867.22
Less Accred Interestat Beginningof Period
{ 128,859.88)
{ 162,967.62)
Interest Earned during Period
42,007.34
334,910.25
Total Interest Earnedduring Period 42,535.82 337,797.40
Total Adjustments from Premiums and Discounts 0.00 0.00
Total Capital Gains or Losses 0.00 0.00
Total Earnings during Period
Run Date: 01/1812006- 1527
42,535.82 337,797.48
Portfolio CITY
AC
PM (PRF—PM6) SyrriRept W.21
RspOr! ver. 5.00