HomeMy WebLinkAboutAgenda Bill 4.B 04/05/20044 ,
4
.4
4
CITY OF PETALUMA, CALIFORNIA
AGENDA BILL April 5, 2C
Agenda Title Meeting Date:
Receive File Treasurer's
and Quarterly Report
April 5, 2004
Meeting' Time ❑ 3:00 PM
❑ 7:00 PM
Category (check one) (f Consent Calendar ❑ Public Dearing ❑ New Business
❑ Unfinished Business ❑ Presentation
Department
Director
Contact Person
Phone. Number
Finance
William Thomas
Cinde Rubaloff
778 -4357
Cost of Proposal NA
Account Number NA
Amount Budgeted NA
Name of Fund NA
Attachments to Agenda Packet Item
Resolution Filing Quarterly Treasurer's Report
September 30, 2003 Treasurer's Report
; Summary Statement
State law requires all local agencies to file reports on the status of their investment portfolio with their City
Council and City Manager. The Finance Director /City Treasurer provides the City Council with a monthly
Treasurer's Report that shows the market value and. the cost of all cash and investments held by the City of
Petaluma, along with a schedule that shows the monthly activity of receipts, transfers and disbursements.
The Quarterly Treasurer's report is presented to the City Council at a regularly scheduled public meeting.
State law also requires that the City Treasurer submit an annual Statement of Investment Policy to the City
Council. The City's investment practices comply with the approved City Investment Policy and with the
.requirements of State. law.
Recommended City Council Action /Suggested Motion
Approve resolution to receive and.file'September 30, 2003 Treasurer's. Report
Reviewed by Finance Director:
Reviewed by City Attorney
Dater
ApprOW&Y City. Manager:
Date:
I D te:
I t
f
n'
� \
Today's Date
Revision # and Date Revised:
File C de:
#
s:\accountantNcinde \word \tr\agendabilI
;1 ,'.
is
RESOLUTION TO REVIEW AND FILE THE
SEPTEMBER 30, 2003 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.
City of Petaluma, California
Cash/Investment by Type- September, 2003
Total Cash/Investments $75,959,129
Otter
Cash
rAIVIP
569;718
22% o
N
LATE
$18,752,297
25%
Fiscal Agents
$17,486,020
23 %
Federal Agency Securities
$36,955,353
49%
5lename:. s : \acc6untant\cinde \excel \trl4th
CITY OF PETALUMA, CA
CITY TREASURER'S QUARTERLY REPORT
For the quarter ending September, 2003
Cash Activity for the Quarter:
Cash and Investments, beginning of the quarter
Cash.Receipts
Cash; Disbursements
Cash and Investments, end of the quarter
$ 81,762,310
15,289,600
(21,092,781)
$ 75,959,129
Cash and Investment Portfolio at September 30, 2003
Investments Managed by City Treasurer:
AD 2000 -2001 Bond
Local Agency Investment Fund
CA Asset. Management Prog
CAMP/Fed Agency Securities
Wells Fargo Sweep Account
Subtotal
O 'Lents;Managed by Trustees:
CA Asset Management Prog
Trustee Money Market Accounts
Subtotal
Checking Accounts
Total Cash and Investments
Fair
Value*
Par Value
(Cost)
Percent
of
Portfolio
Weighted
Days to
Maturity
Current
Annual Yield
956,023
956
1.26%
4,096
6.00%
18,783,317
18,752,297
24.69%
1
0.16%
1,569,718
1,569;718
2.07%
39
0.90%
36;957,860
36,955,353
48.65%
639
2.30%
969,287
969
1.28%
1
0.10 %
59;236;204
59;202,677
77.94%
17 '17,333,629 22.82% 43 1.07%
152,390 152,390 0.20% 1 0.49%
17,507,176 17;486,020_ 23.02%
(729,568) (729,568) - 0.96%
$ 76,013,813 $ 75,,959 100.00%
Fair values were furnished by the State of California, Local Agency Investments and CAMP.
I certify that this report contains the total amounts of cash and investments at September 30, 2003.
The investments are inconformity with;tle Investment; Policy as stated in Resolution Number 2002- 036NCS, dated
February 25, 2002. A copy of the Investment Policy is available for review in the Finance Department. The
City Treasurer's cash managementprogram provides sufficient liquidity to meet expenditure requirements for
the next six months. ( l
*adjusted to FV quarterly f n
' J. Thomas, 1easurer
0
CITY OF PETALUMA, CA
CITY TREASURER'S QUARTERLY REPORT
For the quarter ending September; 2003
Beginning End
of Quarter Receipts *A Transfers Disbursements of Quarter
Investments Managed by City Treasurer:
AD 2000 -2001 Bond
Local Agency Investment Fund
Local, Agency Investment Fund
CA Asset Management Prog
FHLMC Global Ref Note 1/04
FFCB Notes 2/04
FNMA Benchmark Note 4/04
FHLB Note 6/04
FHLMC Ref Note 7/04
FNMA Benchmark Note 8/04
FNMA Benchmark Note 8/04
FHLB Global Note 1105 ,
FHLMC Global 'Ref Note 1105
FHLB 2/05
FHLMC Notes,-5/0
FHLMC Global Ref Note 7/05
FHLMC Note 9/05
FHMA Benchmark Note' 10105
FHLMC Note (callable) 12/65
FHLMC Global RefNote.1 /06
FHLB TAP Note 2/06
FNMA Benchmark Note 2/06
FHLB Note (callable) 2/06
FNMA Note (callable) 3 /,06
FHLMC Note (callable) 4/06.
FHLMC G16ba1.RefNote 7/06
FHLMC Note (callable) 1'2'/06
FHLMC,Note (callable) 12/06
FHLB Bond (callable) 12/06
FHLMC Discount Note 10/03
FHLMC Discount Note 1 1/03
FHLMC Discount.Note 10/03'
US Treasury N/B 2/05
US Treasury Note 3/05
US Treasury Note 6/05
US Treasury Note 11105
US Treasury Note 5/06.
US Treasury Note 5/06
Wells Fargo Sweep Account
Subtotal
984,933.08
10,960,499.92
2,217;479.51
17
1,473,014.97
1,020,950.00
2,021,7.1 1.81
2,047,470:00
1;082,886.69
1,628,708.33,
1,104,555.56
2,052,450.83
1,129,357.64
908,434.88
1,102,141.78
514,245.64
1,000,666.67
2,215,994.96
1,213, 134.53
1,132,486.00
6,000.00
1,207,424.67
1,500,916:67
1,085,968.22
1,000,152.08
1,041,720:39
1,002,99045
1,388,183.60
354,011.21
1,287,216.27
63:642616.33
65,228.55
9,088.81
18,088.47
17,500.01
11,250.00
33,399.58
(3,242.50)
(4,547.71)
24,375.00
16,250.00
20;625.00
17,187.50
4,218.75
2,673.6.1
17,500.00
2,274.33
7,283.33
5,000:00
26,250:00
14,646.87
17,416.67
6,780.00
1,605.33
15,125.00
9,187.50
6,645.62
5,550.00.
(28,910,36)
5,500,000.00
(16,397,320.63)
(35,000.00)
(22,500.00)
(2,055,11.1.39)
(2,044,227.50)
(1,078,338.98)
(48,750.00)
(32,500.00)
(41,250.00)
(34,375.00)
(8,859.38)
1,002,062.50
(35,000.00)
(516,519.97)
1,631,398.18
(52,500.00)
(29,293.75)
2,137,654, 52
(6,780.00)
(6,000.00)
(1,209,030.00)
1,639,648.17
(7,959.64)
956
16,525 ' 728.47
2,226,568.32
1,569,717.83
1,455,514.98
1,009,700.00
1,604,333.33
1,088,305.56
2,031,825.83
1,112,170.14
903,794.25
1,004,736.11
1,084,641.78
1,638,681.51
1,005,666.67
2,189,744.80
1,198,487.65
2,155,071.19
1,132,486.00
1,654,773.17
1,510,104.17
1,092,613_:84
1,005,702.08
2,296,744.22
2,294,311.33
514,606.03
1,037,834.83
998,950.65
999;913,38'
1,406,15235
1,526,737.09
1,750.00
15,047.72 (4,847,027.61)
(7,959.64)
2,296,744.22
2,294,311.33
514,606.03
3,914.44
(7,800.00)
4,084.70
(8,125.00)
2,781.93
997,131.45
1.7;968.75
17,000.68
1,155,725.20
1,750.00
18.7:50
(318,1,17.25)
(7,959.64)
956
16,525 ' 728.47
2,226,568.32
1,569,717.83
1,455,514.98
1,009,700.00
1,604,333.33
1,088,305.56
2,031,825.83
1,112,170.14
903,794.25
1,004,736.11
1,084,641.78
1,638,681.51
1,005,666.67
2,189,744.80
1,198,487.65
2,155,071.19
1,132,486.00
1,654,773.17
1,510,104.17
1,092,613_:84
1,005,702.08
2,296,744.22
2,294,311.33
514,606.03
1,037,834.83
998,950.65
999;913,38'
1,406,15235
1,526,737.09
1,750.00
15,047.72 (4,847,027.61)
(7,959.64)
CITY OF`PETALUMA, CA
CITY TREASURER'S QUARTERLY REPORT'
For the quarter ending September, 2003
Beginning End
of Quarter Receipts *^ Transfers Disbursements of Quarter
Investments Managed by Trustees:
CA Asset Management Prog
US'Bank First American Treas
JP Morgan US, Govern MM
Wells Fargo Govern MM
Union Bank Blackrock
Subtotal
Checking Accounts:
General Operating
Payroll
Mast
Thomas Lee
Police Trust
Subtotal
.Fotal Cash and Investments
includes gain /loss on maturity /disposal
* accrual basis
17,290,958.00
46,583.79
(3,478:85)
(433.68)
17,333,629.26
80,195.17
108.26
601,572.64
(601,881.25)
79,994.82
119,73721
166.72
914,002.50
(961,530.03)
72,376.40
1,1.3,6
0.03
1139
4,298:40
1033
1 PJJ 86:69
(115,487.70)
7.72
17
.46,869.13
1,623,282.98
(1,619,332.66)
17,486,019.59
'330077.72
14,244,959.00:
151;852.63
(15,525,006.81)
(798,117.46)
5,;29036
3,881;892:00
(3,867,574.82)
19,607.54
285
582,722.33
(810,000.00)
(12,807.00)
45,537.33
583.48
(100.00)
483.48
2
04
2,921.26
624,49408,
14,827,682.07'
3;223,744:63
(19,405,488.63)
(729,567.85)
$ 81;762,30:55, $ 15,289,598 :92 $ 1 (0.00): $ (21,092,780.93) $ 75,959,128.54
CITY OF PETALUMA, CA,
CITY TREASURER'S QUARTERLY REPORT
For the quarter ending September, 2003
Reconciliation of'Cash Disbursements:
Account&?> yabl'e Cash Disbursements
July, 2003
Accounts Payable Cash Disbursements
August, 2003
Accounts Payable Cash.D'isbursements
September 2003
Accounts Payable Cash, Disbursements after
September, 2603
Prior`Quarter's Cash .'Disbursements- Recorded in. current quarter
Voided Accounts.Payable Checks
Check Written to Trustee - ;Recorded':as a.transfer on page two
Payment:made by Trustees on Debt'Issues
Payroll Cash;Disbursements
July, 2003
Payroll Cash;Disbursements
August, -2003
Payroll Cash;Disbursenients
September,'2003`
Payroll Cash:Disburseinents after
September, 2003
Prior. Quarter's Payroll -Disbursements- Recorded in current quarter
Voided`Payroll Checks
Credit:Card Fees'
Bank/CA IP Fees Net`
Trustee'Fees
Police Trust Cash'Disbursements
Thomas Lee• Charity Cash. Disbursements
4,294;1.89.:1 -0
9;276;839:45!
3,822;606.94.
3 ;258,1 -5
(42,34398)
(210;42726)
(1,623 ; 282:98)
1,077',Q15.00
1
1 1 '879,960.00
1,263,457.17
6,227.55
(541:18)
T2,807.00
11,127.03
436AI
Comparison , of Current.Investments to Prior'Quarter`and to., Ju r.
ne, 2 03 September 2003 September,
2002'
Cash and`Investments at the end of the quarter $ 81,762;3 H $ 75 959,129 $ 78,209,384
Interest Received or Accrued froinjuly'1 $ 2,262,327 $ 481,657 $ 559;494
Estimated, Average Interest Rate 2.28% 1.41% 1.82%
US.T =bill 91 day Yield '0.84 % 0.94 % 1.61
0
4
CITY OF PETALUMA, CA
CITY TREASURER'S QUARTERLY REPORT
For the quarter ending September, 2003
Interfund Loans:
Current Period Interest
Year to Date Interest
Repayment
Amount_
Loan To
Loan From
Purpose
Accrued Paid
Accrued Paid
I Schedule
1,304,297
Marina Fund
PCDC -Comm Develop,Proj Area
Loan payments
8
8 -
ptincipal/interest "nonscheduled
2,912,000 "
PCDC - Central Business District
PCDC -Comm Develop. Proj Area
Project Financing
15;480
15,480
as cash flow permits
761,200
Housing in Lieu Fund
Low/Mod Income Fund
Program Funding
5
5,141
as cash flow permits
80
Comm Develop Block Grant
Housing in Lieu Fund
Program Funding
-
when cash received from,CDBG
Interfund loan interest calculation assumes that repayments are made the first day of the quarter. and loans are made the•last, day of the quarter.