HomeMy WebLinkAboutAgenda Report - September 7, 2005 E-03AGENDA ITEM FW003
CITY OF LODI
COUNCIL COMMUNICATION
TM
AGENDA TITLE: Accept the Quarterly Investment Account report as required by law SB 564
MEETING DATE: September 7, 2005
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.
The City of Lodi maintains membership in the California Municipal Treasurers Association and conforms
to guide lines set forth by the CMTA investment report committee.
FUNDING: None
J es Krueger, Finance irectorlTreasurer
JK/mmc
Attachments
APPROVED: /��
Blair King, ii Manager
City of Lodi
Portfolio Management
Portfolio Summary
June 30, 2005
City of Lodi
300 W. Pine St.
Lodi, CA 95240
(2D9)333-6800
investments
25,485,340.03 25,485,340.03
25,485,340.03 100.00% 4
3 2.421 2.454
Total Earnings June 30 Month Ending Fiscal Year To Date Fiscal Year Ending
Current Year 51,266.76 477,937.09 477,937.09
Average Daily Balance 26,678,514.53 27,377,982.44
Effective Rate of Return 2.34% 1.75%
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 Cadwallader, Revenue Manager
Run Date: 08A)32005. 14:31
Portfolio CITY
AC
PM (PRF !`W) SrAept V$.21
Report Ver. 5.00
Per
Market
Book
% of
Days to
YTM
Y7M
Investments
value
value
value
Portfolio
Torm
MeturttS+
361) Equiv.
365 E**K
Local Agency Investment Funds
21,705,117.20
21,705,117.20
21,705,117.20
85.17
1
1
2.817
2.8%
Certificates of Deposit - Bank
200,000.00
200,000.00
200,000.00
0.78
366
231
2.775
2.814
Passbook/Checking Accounts
3,580,222.83
3,580,222.83
3,580,222.83
14.05
1
1
0.000
0.000
investments
25,485,340.03 25,485,340.03
25,485,340.03 100.00% 4
3 2.421 2.454
Total Earnings June 30 Month Ending Fiscal Year To Date Fiscal Year Ending
Current Year 51,266.76 477,937.09 477,937.09
Average Daily Balance 26,678,514.53 27,377,982.44
Effective Rate of Return 2.34% 1.75%
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 Cadwallader, Revenue Manager
Run Date: 08A)32005. 14:31
Portfolio CITY
AC
PM (PRF !`W) SrAept V$.21
Report Ver. 5.00
City of Lodi
Portfolio Management
Portfolio Details - Investments
June 30, 2005
Page 2
Average Purchase Stated YTM Days to Maturity
CUSIP Investment li Issuer Balance Date Par Value Market Value Book Value Rate Moody's 360 Maturity Date
Local Agency Investment Funds
LAIF 1000 Local Agency Invest. Fund 21,000,000.00 21,000,000.00
LPIC 1001 Local Agency Inv Fund (LPIC) 705,117.20 705,117.20
Subtotal and Average 21,705,117.20 21,705,117.20 21,705,117.20
Certificates of Deposit • Bank
SYS76WEST 76 Bank of the West
SYS75 75 Bank of America
Subtotal and Average 200,000.00
PassbooldChecking Accounts
04/17/2005 100,000.00 100,000.00
1017Y1004 100,000.00 100,DDO.OD
20D,000.00 200,000.00
21,000,000.00 2.856 2:817 1
705,117.20 2.856 2.817 1
21,705,117.20 2.817 1
100,000.00 3.100 3.100 290 04!17!2006
100,000.00 2.450 2.450 171 12119/2005
2DD,000.DD
2.775 231
BACK 4003 Bank of America 07/01/2004
0.0D
0.00
0.00
0.000 1
SYS4000 400D Farmers & Merchants
3,552,549.16
3,552,549.16
3,552,549.16
0.000 1
F & M PAYROLL 74 Farmers & Merchants Payroll 10/01/2004
27,673.67
27,673.67
27,673.67
0.000 1
Subtotal and Average 4,773,397.33
3,580,222.83
3,580,222.83
3,560,222.83
0.000 1
Total and Average 26,67$514.53
25,485,340.03
25,485,340.03
25,485,340.03
2.421 3
Run Date: {38!03!2005 - 14:31
Portfolio CITY
AC
PM (PRF_PM2) SymRept V8.21
Report Ver. 5.00
City of Lodi
Portfolio Management
Activity By Type
June 9, 2005 through June 30, 2005
s
Stated Transaction Purchases Redemptions
CUSIP Investment N Issuer Rate Date or Deposits or Withdrawals Balance
Local Agency Investment Funds (Monthly Summary)
Subtotal 21,705,117.20
Certificates of Deposit - Bank
Subtotal 200,000•00
PassbooklChecking Accounts (Monthly Summary)
SYS4000 4004 Farmers & Merchants 11,205,798.10 12,407#135.83
F & M PAYROLL 74 Fanners & Merchants Payroll 301,780.37 334,261.09
Subtotal 11,507,578.47 12,741,896.92 3,580,222.83
Total
Run Date: 0810312005. 14:31
11,507,576.47 12,741,896.92
25,485,340.03
Page 3
Portfolio CITY
AC
PM (PRF_PM3) SymRept V6.21
Report Ver. 5.00
City of Lodi
Portfolio Management
Activity Summary
June 2004 through June 2005
Paye 4
Portfolio CITY
AC
PM (PRF_PM4) SyMRept V8.21
Report Ver. 5.00
Yield to Maturity
Managed
Number
Number
Month
Number of
Total
380
365
Pod
of Investments
of Investments
Average
Average
End
Year
Securities
Invested
Equivalent
Equivalent
Rate
Purchased
Redeemed
Term
Days to Maturity
June
2004
8
24,704,427.13
1.062
1.077
1.450
0
0
12
8
July
2004
8
22,523,593.60
0.992
1.006
1.450
1
0
13
6
August
2004
8
26,584,137.20
0.841
0.852
1.450
0
0
11
4
September
2004
7
23,078,628.54
1.108
1.123
1.680
0
1
12
3
October
2004
7
25,225,379.30
1.173
1.190
1.890
1
1
4
2
November
2004
7
24,373,034.02
1.396
1.416
1.930
0
0
4
2
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
May
2005
7
26,719,658.48
2.256
2.287
2.790
0
0
4
3
June
2005
7
25,485,340.03
2.421
2.454
2.856
0
0
4
3
Average 7
27,193,454.99
1.584%
1.606%
2.057
0
0
6
3
Portfolio CITY
AC
PM (PRF_PM4) SyMRept V8.21
Report Ver. 5.00
City of Lodi
Portfolio Management
Distribution of investments By Type
- June 2004 through June 2005
Page 5
Portfolio CITY
i AC
Run Date: 0 810312 0 05. 14:31 PM (PRF -PMS) Sr~ V6.21
Repmi Ver. 5.00
Jure
July
August September
October
November
December
January
February
March
April
May
June
Average
Security Type
2004
2004
2004
2004
2004
2004
2004
2006
2005
2005
2005
2005
2005
by Period
Local Agency Investment Funds
70.5
65.3
55.3
63.7
62.5
72.9
77.2
85.9
86.7
83.8
.. ..,.
83.8
81.2
85.2
7.4.9%
Certificates of Deposit - Bank
5.3
5.8
4.9
5.2
0.8
0.6
0.7
0.6
.............................
0.5
0.7
0.8
0.8
__ 0.8
21%
.,.,..,.
Certificates of Deposit - S & L
Passbook/Checking Accounts
24.2
29.0
39.8
31.1
36.7
26.3
22.2
13.5
12.7
15.5
15.5
18.0
14.1
23.0%
Corporate Medium Term Note
. .............. ...
Commercial Paper - Interest Bearing
Repurchase Agreements
Federal Agency Issues - Coupon
Treasury Securities - Coupon
Mortgage Backed Securities
Bankers Acceptances -Amortizing
.............. .
--
Commercial Paper Disc. -Amortizing
Federal Agency Disc. -Amortizing
Treasury Discounts -Amortizing
Miscellaneous Discounts -Amortizing
Portfolio CITY
i AC
Run Date: 0 810312 0 05. 14:31 PM (PRF -PMS) Sr~ V6.21
Repmi Ver. 5.00
City of Lodi
Portfolio Management Page 6
interest Earnings Summary
June 30, 2005
June 30 Month Ending Fiscal Year To Date
C.D/CouponNlscount Investments:
Interest Collected 256.33 8,330.84
Plus Accrued Interest at End of Period 253.93 253.93
Less Accrued Interest at Beginning of Period { 49.76) { 1,976.83)
Less Accrued Interest at Purchase During Period { 0.00) { 0.00)
Interest Earned during Period
462.50
6,607.94
Adjusted by Premiums and Discounts
0.00
0.00
Adjusted by Capital Gains or Losses
0.00
0.00
Earnings during Periods
462.50
6,607.94
Pass Through Securities:
Interest Collected
0.00
0.00
Plus Accrued Interest at End of Period
0.00
0.00
Less Accrued Interest at Beginning of Period
( 0.00)
( 0.00)
Less Accrued 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
Earnings during Periods
0.00
0.00
Cash/Checking Accounts:
Interest Collected 0.00 375,930.26
Plus Accrued Interest at End of Period 162,967.62 162,967.62
Less Accrued Interest at Beginning of Period { 112,163.36) ( 67,568.73)
Interest Earned during Period 50,804.26 471,329.15
Total Interest Earned during Period 51,266.76 477,937.09
Total Adjustments from Premiums and Discounts 0.00 0.00
Total Capital Gains or Losses 0.00 0.00
Total Earnings during Period 51,266.76 477,937.09
Run Date: 08M32005. 14:31
Portfolio CITY
AC
PM (PRF—PW) SyMRept V621
Report Ver. 5.00