HomeMy WebLinkAboutResolution 2002-127 N.C.S. 08/05/2002Resolution No. 2002-127 N.C.S.
of the City of Petaluma, California
RESOLUTION TO REVIEW AND FILE
THE JUNE 30, 2002
QUARTERLY CITY TREASURER'S REPORT
WHEREAS, State Law requires that the City Council review the City's Treasurer's
Report on a quarterly basis for compliance with the adopted City Investment Policy.
NOW, THEREFORE, BE IT RESOLVED that the City Council has reviewed said
report and directs the City Clerk to file it.
Under the power and authority conferred upon this Council by the Charter of said City.
REFERENCE: I hereby certify the foregoing Resol~rtion was introduced and adopted by the Approved as to
Council of the City of Petaluma at a (Regular) (Adjourned) (Special) meeting
on the .........S.th............ day of ........E~UgUSt ................................... 20.QZ., by the
following vote: ..............~i......................
malty Attbi`ney
AYES: Cader-Thompson, Vice Mayor Healy, Maguire, Moynihan, O'Brien, Toiliatt
NOES: None
ABSENT: Thompson
ATTEST: ... .. .. .. ................................... ............................ ..... ...................................................................................
Cl Clerk Mayor
Council File ...................................
Res. Nn........2Q02>.1.27.........N.C.S.
City of Petaluma, California
Cash/Investments by Type -June,. 2002
Total Cash/Investments $78,735,337
Cash
$ 1, 563,400
7~
0
z
a
N
0
0
N
N
z
LAIF
$35,851,951
Fiscal Agents
$22;060,970
icy Securities
$17,558,762
r e ~av
N
filename: s:\accountant\cinde\excel\tr\2nd -
CITY O)F PETALiJiVIA,.CA
CITY'~ItEASIIR)Elt'S ~IJAIt'FERY,Y ~P®RT
For-theiQuarterending June; 2i)02 -
Cash;activity foc the quarter ,'
Cash and Investments; $eginning of the quarter $ -"77;1'38,690
Cash~:Receipts -24;895,072:
Cash Disbursements (23;298,426)
Cash and Investments, end of the quarter $ 78,735,337
Cash and Investment: Eortfolio at June 30, 2002
Investments 1Vlanaged by City.'Treasurer:
Local Agency Investment Eund
We11s:~Fargo/Government 1Vloney Market
Wells F,.argolFederal Agency Securities
~GA,Asset Management;Program
CAMP/Federal Agency Securities
.Wells Fargo Sweep.AC'count
Subtotal
Investments Managed by ~1'iscal Agents:
CA Asset Management Program
US Bank/First Am Treas Obligations
Wells Fargo Money Market
JP Morgan
'Union Bank/Blackrock
Subtotal
Checking Accounts
• •Total-.Cash and Investments
Percent Weighted
Fair P>ar Value of Days to Current
Value* (Cost) Portfolio Maturity Annual :Yield
35,95.1,625 35",851,951 45.53% - 1
-100 100 0.00% 1
.3,096,445 3,054,268 3.88% 743
1;700,254 1,700;254. 2.16% 1
14;681,110 14,504;494- 18.42% 751
885',486 885,486 1:12% 1
56,315;020 55;996,552 ~~ 71.12%
21;985,636 21;920,138 27.84% 63
80;606 80,606 0.10% 1
10,651 10;65:1 0.01% 1
42,061 42,061 0.05% 1
"7,514 7;514 ~ 0.01% 1
22;126;468 22;06®;970 28.02%
677;815 677,815 0.86% 1
79,1~1'~9,;302 78,735,337 100.00%
Fair Values were furnished by the State of California; Local Agency Investments and Wells Fazgo Securities.
,I certify that this report:containsahetotal amounts ofcash:and investments at Jurie 30, 2002:,
The investments are in conformitywith-the Investment Policy as stated. in Resolution Number 2001-020, dated
January 16, 2001. A copy of the Investment Policy:is available for review in the Finance Department. The
City Treasurer's cash management program provides sufficient .liquidity to meet expenditure requirements for
the next six months.
* adjustedao FV quarterly -
William J. Thomas, Treasurer
Reso. No. 2002-127 N.C.S.
Page 3
2.75%
1:20%
6:36%
1.77%
3.90.%
0.73%
1.77%
1.1':0%
1.43%
120%
1.75%
CITY OF PETALUMA,.CA
CTTY TREASURER'S QUARTERLY REPORT
For the Quarter ending June, 2002
Cash and'Invesfinent.Portfolio Changes
Beginning End of
Maturity of Quarter Receipts* Transfers Disbursements .Quarter
Local Agency Investment-Fund .Demand.
Local.Agency Investment Fund Demand
WF-Federal Home Loan Bank 8/15/02
WF-Federal Home Loan Bank 7/16/04
WF-Federal National-Mortgage 6/6/06
WF-Government. Money Market Demand
CA Asset Management Program Demand
CA-FHLBC Global Ref Note 11/15/03
CA-FHLMC Global Ref Note 1/15/04
CA-FFCB Notes 2/17/04
CA-FNMA Benchmark Note 4/15/04
CA-FHLB`Global Note 6/28/04
GA-FHLMC Global Reference Note 7/.15%04
CA=FNMA Benchmark Note 8/TS/04
CA-FHLB Global Note 1/14/05
CA-FHLMC Global Reference Note 7/15/05
Wells Fargo Sweep Account Demand
Subtotal
Investments Managed by Fiscal Agents
35;995;392.45 227;488:72' (5,000,000.00) 31;222;881.17
1,751,167.98 27,90.1...63 2,850;000.00 4,629,069.63
1,005,992.31 16;643.84 1,022;636.15
1,OI2,471.91 16,150.69 1,028,622.60
1,017,656:70 14,252.05 (28,900.00) 1,003,008.75
100.05 0:30 100.35
3,662,525.66 9,545.24 (1,970,1.08.73) (1,708.63) 1,700,253.54
2,138,791.67 31,875.00 (63,750.00) 2,106,916:67
11,86L.11 1,461,153.87- 1,473,014:98
1,009,700.00 11,250.00 1,020,950:00
12,284.72 2;008,017.36 2,020,302:08
2,050,713:55 .23,750:00 (47,500.00) .2,026;963.55
1,056,046.00 15,625.00 ~ 1,07.1;6.71:00
1'6,520.83 ;1;612,187.50 1,628;708:33-
2,033,200:83 20,625.00 2,053,825`.83
1,084,641.78 17;500:00 1;102,141:78
7;463,288.56 762.86 (578,565.72) 885,485`.70
55,281;689:45 474;036:99 242,534.28 (1,708:63) 55,996;552.09
CA Asset Management Program Various 22;040;639:67 136,456.70 (255,519:61) (1,438.37) 21;920,138:39
US Bank/First Am Treas Obligations Demand `80.314.36 291.44 80;605.80 .
Wells Fargo Money Market Demand. 595.62 5,737,797:02 (5;015,847.13) (711;894.04) 10`;651.47
JP Morgan Demand 42,051..,58 23.61 503,720.55 (503;735.00) 42;060.74
.Union Bank/Blackroek Demand SL;9.16.06 139.00 6,215,065:73 (6,259;606:70) 7,514'.09
Subtotal '22,215,517.29 5,874;707.77 1,447,419.54 (7,476;674.11) .22;060;970:49
~: Checlang Accounts
General Operating Demand (381,482.3:1) 18,104,898.09 (5,281,339.82) (11,801,172.20) 640,903.76
Payroll Demand 2,657.51 4,014,386.00 (4,011,918.89) 8,724:62
Mast Demand 17,121.78 441,423.78 (423,000.00) (6;951.77) 2.8,593.79
.Thomas Lee Demand 283.82 283.82-
Po_IioetTiust. Demand 2;902.97 5.60 2,908:59
Subtotal (358,516.23) 18;546;327.47 (1,689,953.82) (15;820,042.86)'; 677,814:56
Total Cash and Investments 77,138;690:51 24;895,072.23 - (23,298,425:60) 78,735;337.14
* accrual basis
Reso. No. 2002-127 N.C.S.
Page 4
C1['I'Y OF PE'1cAI.J1V><A,,CA
' CT~'X ~`REASI<JI~EIt'S;QgJAR'TER><.X REPORT
For the Quarter~endirig June, 2002
Iteconcilaation of Cash 1)isburseenents
Check Register
Voided Checks
Check Written to Trustee -Recorded as a Transfer on Page Two
;Payment made by Trustees related to Bond Refunding
` Payment made by Trustees on City bebt Issues
Fiscal Agent Fees
Payroll Cash Disbursements
Voided Payroll "Cheeks
.Credit Card Fees
Bank Fees Net
Police Trust Cash Disbursements
Thomas Lee Charity Cash Disbursements
13,360,090:09.
(1 T6248;02)
(1,796,474.54)
6,.131;041.33
1,693,229:39
1,458.39
4,012,031..30
(112:41)
6,951.7.7
6,45'8:30
23,298;425.60
Comparison of Current Investanents to ;prior q uarter and to. ,prior year
:Cash and Investments at the end of the month March, 20.02. _,
$ 77,138,691 ' $ June; 2002..
78,735,337 $ June; 20.01
70,246,561
Interest Received or Accrued from July 1
$ 1.,981-;273 $
2,538;739 $
3,907,,.1.97,
'
E~stimated.Average Interest Rate
-2.48%
2.06%
4.76%
.
US T-bill 91 day-Yield o
1..82 /o ' fl.69% 4 48% '
- . Reso. No. 2002-127.N.C:S.
Page 5
7~
0
z
0
N
0
0
N
:~
N
z
b
vo
CITY OE PETALUMA, CA
CITY TREASURER'S QUARTERLY REPORT
For the Quarter ending;June, 2002 '
Interfund Loans
Amount ..Loan To Loan From Purpose
54;92Q Airport Operations Wafer Utility Fund Water Lines to Airport
30,76.3 Airport-Operations Water Pollution Control
Fund Sewer Lines to Airport
32,000 Marina Fund General Fund Cash Flow
1,274,685 Marina Fund PCDC-Comm Develop Loan Payments
Project Area Fund
421,950 PCDC-Central Business PCDC-Comm Develop Cash Flow '
District Project Area
60,700 Community-Develop HOME Cash Flow
Block-Grant
97,810 ,Transient Occupancy. Tax ..General. Fund Cash Flow
1,972,828
Currertf Period Interest.
Accrue_d_ Paid
131.09 131.09
73.43 73.43
26:38. 76.38
3,042.67 3,042:67
768.25 768.25.
33.20 33.20
Year to Date Interest
Accrued. Paid
2,484 2;484
1,391 1,391
1,617 1,617
' 48,167 48;167
4,433 4,433
33 33
Repayment
Schedule
per amortization schedule
per amortization schedule
as cash flow permits
as cash flow:permits
when transferred funds received
whenreimbursement received
~ when accruals received
rn