HomeMy WebLinkAboutAgenda Report - November 19, 2003 E-03CITY OF LODI
13TIN
AGENDA TITLE: Accept the Quarterly Investment Account report as required by law
SB564
MEETING DATE: November 19, 2003
PREPARED BY: Deputy Treasurer
RECQMMENDED ACTION, That the City Council by motion/action accept.the
quarterly report of the City of Lodi pooled money
investment account as required by 51 564.
BACKGROUND INFORMATION: The investment report is currently included in the
monthly executive report distributed to Council.
56564 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. In addition to the quarterly report on investments in
the City of Lodi.pooled money investment account, a breakdown Treasury Inventory by type has been
included in a chart tormal. Also included is the most current report of the Local Agency Summary of
Investment Data and the State of California pooled money investment account market valuation.
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. The Finance Department will continue to
include the investment report monthly as part of the executive report,
FUNDING: None.
Vicky�McAth
Finance Director/Treasurer
Por"blie Summary
September 30, 2003
l
PW Maw
Virtue Value
Value
porftuo
'farm
Days to
Mataft
LSE Ngemy Investment Funds
14 jAW,4 3..3€3 14,M,458.39
14,90,4,58,39
6&.74
1
1
Ce-fi sk-,-Barak
1;3Dtt;Ot1#.UG 4,C
�i8030,Y00
9.,3tio,ow'00
209
,ate.30ff'i
Pass�rfV+':Mbedl ng A'3k.ti4unts
C3,
'3y L+4Qe-R [Tfi: ii c"i�C ,t:6TF3.53f
� iEi�X�®'.SJ3
✓�G
<Y -Z3
R
1
tAvestments
......._..,_ �_`-.. _
24,602,647,06 i p"7.06
._. _- ..._..-.,. _..'-_._..
21, s 7;
1 a. A
14
4
................ .:............
t Earnfts .....
- --
_._._...._._.. ._.... _........ .., _. .. .,.._._-. __....., ..........._.
Seownber
_ an _ndirg To DaW
.... _.... __.-
-----
..._..........
... ... .......... ........
cufferk Yew
--M_._ .
24;602.1$0 71,9W.85
....... .... .. ...... ._ _ . .
AverAverago Dally Balance
22,M,740.57 ,74$.57 20,.640, 6=Q0
of .'ave Rate of- attkm
1.36% 1,3
eon the apps to ft eAWt t is adhevEd to, HWIdAy is avaiiable for the qon of Califomia it #Ie sourcevaluation.
MarcOa MC Duty Treas.
Run Date: 10AD312003 - 11,.2-0
City of Lodi
912 W Pine St.
Lodi, CA 9U40
(209)333-5800
YTM
3w zqVIV.
YT
365 EqWv.
1.346
9.774
1,355
1,374
O.0
1.299
IZ17
Pordolio-CITY
AC
PM (PRF_PMI) 8>yMRW V5.01t
City .- d;
Portfoho Management
A
P01#050 CiTy
Run Gate: #Q M003 -11:24 AC
PM (PRP-PV,2) SYMRept V5.01#
Average
nfthase
ed
YTM Days to Maturny
Cush
awance
Date
Pax Value
Market VAwe
Book Value
Rate MOWS
aw Maurtty Rafe
Local Investment Funds
LAM
low
Lei Agenoy 6two%t, F;a
14, 978:86
14, 8? .36
1A, . 3 _3
1,770
1.7416
1
Lp1c
1001
U=1 Agency by Fund (LPIC)
9121
912,480.03
912,480.09
1.770
1.746
1
Subtotala ea
1 1'
14,
_ .
14
1d;
1,745
1
Certwates of Deposit - Bank
------
WEST
59
Oatnkofthe wea
04117f2003
IQQ.,QW-00
100,M0,00
1wow,00
1,190
1.790
199 04/17/2004
BA
57
Sankof America
12fi7120G2
100,6 0.00
100,000,M
1.30
1,300
77 1211712003
FM
60
Farmers and .Marcl ams Bank
04126f29
1>
I'DOU0040
1, OO
1.400
1,400
22 1012312M
LOU
61
Sank of L"
0912MM3
11344 W-00
100, .. 3
100,M—M
1,140
1.124
177 03/2612004
tabtptal and Average
9, . � t
ei � .
7:
1,
x,855
52
PassbooMhackmg
Accounts
$ACK
4OW
Bank of Amagioa
0710132003
589. 07
89,M,07
189, .07
0,0w
1
4000
Fwmars & Memba'3t5
4 1
016,290:60
5,0.15,290:
$
Subtotal and Mwage
GOwmisl
5�,1 7
51WOOM67
6 ' . ,1 7
1
TOW lrtvest ntsandAverage
22,248,74€9.57
21,MS47.06
21,50E6411M
21,MC4748
i,2W
4
P01#050 CiTy
Run Gate: #Q M003 -11:24 AC
PM (PRP-PV,2) SYMRept V5.01#
Se ptember 30, 2003
Aver,.Aver,Ve Pwchm stated YTM Days to
cuWp ent 0 t=uer Balame Date fDar Vain
°poi Cash aW lnvestmrft 2ZM,740.57 2i,5QZG47.06 21,SWS4Z0S 21,SMW7,OS 1.2w 4
Rua fate: IOM3120M - 11:24
zm
Portfdio CITY
AC
RM (PRF PM2) S jmRagt V5.01f
City of Lodi
Portfolio Management
Investment ActiVity By Type
September 1, 2003 through September 30,2003
staud Transacftn puff
cUMP Inv"-bnant4 Pssuef RAU Date or.oeposft of withdr"Ols Balance
Local AgeMy Java s (Monthly )
.Lw I= L=ai.Agwicy Imear.. Fund 1.770 2, '. 2
Cermcatesof - Bank,
Lai> 58 Back of Lodi 1-00 OWW2000-00
L= al Sank Of Lodi 1.340 OWWO03 100, .00
swowtal 100;
im
PassbGoWChecking Accounts ( )
SACK 4= Bank of Anvmca 3W,17314 367.,623.13
Farmem & Wnhants 33; 33,397,748.16
subtow 13,8KIoD,14 1-3, : . r)s 16&67
AC
FSA �P&RF_P ) SymPept V5.01f
City of Lodi
Portfolio Management
Investment Activity Summary
i' of11olio CITY
AC
Run Data: 1 C1{rM12003 - 1124 PM .(PRF_PM4) SyrnRept il.5.01P
yield to .... ...
__.
Merged
Number
Number
month
Hwnbef Of
pool
of ftaa
ot securmes
Average
Mirage
End
Yew
secufffies
&Weaftd
aqwVaient
equty 'm
Rate
PuTthased
Matured f Soid
Term
Days to MaWrfty
r
12,1-83,1.02-24
2.430
2.464
2.7SO
0
i
Ice
24
October
2002
8
14,537,6.82
I -M
1.994
2,630
2
2
91
29
2
8
12,026;947:62
2Z77
2-4 tO
2,wo
0
0
IC9
29
14,147,f508.12
2.03;
2.0592.�EM
1
0
96
23
January
2063
9
14,999,5DI.So
1.767
1.792
2,310
0
0
90
17
february
2003
9
17,129,142.84
1.879
1.905
2,31€7
0
0
79
11
March
20W
9
17,242;1 .1
1.867
1.
2.3917
0
0
79
7
pr11
2803
9
17,437,901,80
1 .635
1.
1,
3
2
75
1
May
2003
8
13,03,764.27
1.394
1.414
1 :9w
0
1
9e
12
Jum
2003
5
16; ,213.39
1.5m
1.5m
1:
0
0
17
11
July
2M
a
20,9,950.24
1,339
1.35$
1,7713
1
0
14
7
August
2M
5
21,377,916.21
1.311
1,329
1,7709
0
0
14
5
September
2003
5
23,502;647.06
1,299
1,317
1.770
1
1
14
4
Average
a
16,787,674,83
12640%
1.7.72%
2,217
1
4
62
16
i' of11olio CITY
AC
Run Data: 1 C1{rM12003 - 1124 PM .(PRF_PM4) SyrnRept il.5.01P
City of Lodi
Portfolio Management
Distribution
f Investments: By Type
.;
Qweptember 2002 through September 2003
Portfak
CITY
RC
Run Date: IM312003 - 11:24 PM {PRF—PMS) SymRapt V5V f
September
r fiD
November
December
janu&Fy
februwy
March
Apfil
may
June
July
AUqSeptember
Average
1
Local Agency InveafterAFunds
59.3
53.7
61.E
52.1
40.4
57.8
57.4
57.1
M2
71.6
71.774�e2
89.7
51.2%
Catific.5€ A .. ;
9:9
0-0
R2
8:7
.7:6
75
7.
7,2
7.8
6.2
.I 6.1
7.8%
C ate .o - L
_
-
_-- -
--
--- ..------
PazsbooMh
21,9
1
2.3
31.6
35,2
-------------------
28.7
29.1
_._._--_- _-_-
29.7
_.-__._.,------------------------------------------------------
26.5
20,6
--________
22.1
_---__-- _._-__,____- ---
23.8 24.2
25.3%
CGrP"e.. e
83
7,0
8.
7.2
+:
4.
+
CommercialGp- —Interest
—Pap!!--
— ------
Portfak
CITY
RC
Run Date: IM312003 - 11:24 PM {PRF—PMS) SymRapt V5V f
Ciof Lodi
ty
Portfolio Management
Interest Earnings Summary
September 30, 2003
Interest Eck Tmd during Period 1,524.52
Adjusted by Frernium. and Dismunts 0.00
Adjusted by Capft Gains or Losses OW
Earnhgs during Per�od
1,524.52
---- — ----------------------------
ftas Ttwougb Securftfes:
interest c0ected
0.00
Plus Accnied Interest at End of Period
OLD
Less Accrued Interest at Begmng of Penod
C.i)
Less Aconjed interest at Purchase Dunng Period
0-00)
Interest Earned duri% Period
OM
Adjusted by Premiums and Discounts
0,00
Adjusted by Capital Gains or Losses
O.CO
Eamings du" PefW
0.00
I
0.00
ODD
0.00
E
cashtchecking ACCOUFAS,
Interest Collected O -OD 47,772,47
Plus Accrued Interest at End of Period 67,102.46 67,102,46
Less Accrue interest at. Beginning of PerW 44,024,68) 47,~63,33)
hiterest Eamed &nV Pened 23�07758 67,221.60
TOW Interest Eamed duliag PL410d 24,60LIO 71,900.85
Total Add stvnerft fr= Pmmkms andiDiscounts U.0 Q.
Total Capital Gains or Losses 0-00 Q.
TOW Eala ings durift:Pedod 24,802.10 711MA
Run Date: 10t,)2003- 11:24
Portfolio CITY
AC
PM (PRfz_PM) swrRept V5.0-' f
September 30, 2003
AM—Ount
ortfolior
percent Of r
$1,300,000M
6.0457670k
a
0.0000000/,
Corporate Medum Tera
Treasury urit€es - Note Federal Agemy issues -
Coupon Coupon
,01
$5,206,188.67
i assbocWCherckinr
Accounts
24%
$1,3= 000,00
Tiftates ofBank
6%
'14,996.,468.39
Agency e at
Fund
T
ice# AMnoy Investment Fund $14,996,458.39 � Cefflcates of DepOs#= k $1,3001OW-00
S si taChesc3cin txcau s $5s .670 Comate Medium Term Note
MTreaswy Securitm - Coupon 13 FedFederai Agwcy issues - Coupon
PHILIP ANGELIDES
TREASURER
STATE OF CALIFORNIA
INVESTMENT DIVISION SELECTED INVESTMENT DATA
ANALYSIS OF THE POOLED MONEY INVESTMENT ACCOUNT PORTFOLIO
(000 OMITTED)
IYPE OF SECURI FY
Government
Bills
Bonds
Notes
Strips
Total Goverurnents
1EM3NNK=
Average. Life of Portfolio as of June 30, X103 is 212 Days
5 Revised June 30, 2003
PERCENTAGE
CHANGE FROM
AMOUNT
PERCENT'
PRIOR MONTH
1,593,303
2.87
+2=02
0
0
0
8,311,148
15.04
+3.31
0
-0
0
$ 9,904,451
17-87
+533
4,6654606
8.42
+3,41
5,740,493
10.36
-9.04
100,003
0.18
-0.67
0
0
0
0
0
0
8,440,754
15.23
+2.24
5,575,095
10.06
+0.58
572
0
0
14,023,307
25.30
+4.59
4,910
0.01
0
2,236,844
4.04
+OkS
4,730,471
8n53
+1,15
0
0
-&27
0
-0
0
55,422,506
100-00
Average. Life of Portfolio as of June 30, X103 is 212 Days
5 Revised June 30, 2003
_-.---- .-._._.---
State California
Pooled Money Investment Account
Market
g Valuation
6130/0.
.!✓F){ r / if l� -_. y�{.. .z`py 3 `3 �$ gq; i .'1 if �hF .n - Yf 1 A ;s
CkEyR
J i- ., � f r•: it
['�ex5„E
ri-pig
United totes Tri ��ia
Bills1
Notes
593 302 628.44 1 594 820 514.45
8 311 143 231.63 8 309 4Q8 466.47
q 1 594 487 OOQ.QO
8 387 837 750.001
SFA
57 535 050.75
Federal A enc
BA
418240 502.15 418 193 019,64
414 684.597.42
1 169 460.25
MBS
563 169 383.63562 001 552..66
557 524 284.67
2 89 111.37
m Bonds
3.684 196 081.50 3676 197 528.58
3 727 374 9.15.20
27 399 962.94
Floaters-
iiSCU�lrtt Nate
FHLMC PC
I 44 753 808 79 8 447 281 574.36
4 910 307.30 4 910 301.30
8 447 522 204.80
a 361 043.64
NA
78 920.45
GNMA
$ 571 948.84 571 948.84
671.481 69
568812
Bankers Acct tnces
e
NA
Bank Notes
CDS
Cornrnerci l P er
100 003 100.12 1 999 989.00
5 744 493 275.49 5 74fl 069.608 83
14 023 307 029.39 14 038 546 0401.13
10Q 017 433.00
5 739 690 540.95
14 0403 328 864.80
80 888.89
6 9.85 758.35
NA
Floaters
3133 5ffi3 6903.213 3 583 6913.21
3013 221 090,61)
581 331.39
Bond
9.933 260 633.79 1 92& 418 579.56
1 963.(349 6001.06
1. 25 630 194.53
Rc urchase Ate=menItsNA
Reverse Re u
_
Tune e wits
ALS 55 & GF Lawns
iC iAL
5575 095.000.0 5 575 095.00D.0Q
4 730 470 588.9 5 4 73D 470 588.15
55 422 506 1Q9.43 55 429 568 408.28
5.575 095 Q030'003
4.730 �470 5&8.15
55,587 336 494.38
1 NA
NA
122 156 3F17.04
Fair Value Including Accrued Interest
55,709,492,881.42
Repurchase Agreements, Time Deposits, AB 55 & General Fund loans, and
Reverse Repurchase agreements are carried at portfolio book value (carrying cast),
The value of each participating dollar equals the fair value divided by the amortized cast (1.002846280 ),
As an exarnple: if an agency has an account balance of $20,000,000.00, then the agency would report its
participation in the LAIF valued at $20,656,925.01 or $20,0010,000.00 x 1 M28462
12 Revised June 30, 2003