CC SR 20190806 N - June 2019 Treasurer Report - CityRANCHO PALOS VERDES CITY COUNCIL MEETING DATE: 08/06/2018
AGENDA REPORT AGENDA HEADING: Consent Calendar
AGENDA DESCRIPTION:
Consideration and possible action regarding the June 2019 Cash Balances/Monthly
Treasurer’s Report
RECOMMENDED COUNCIL ACTION:
(1) Receive and file the June 2019 Cash Balances/Monthly Treasurer’s Report
FISCAL IMPACT: None
Amount Budgeted: N/A
Additional Appropriation: N/A
Account Number(s): N/A
ORIGINATED BY: Jane Lin, Accountant
REVIEWED BY: Deborah Cullen, Director of Finance
APPROVED BY: Doug Willmore, City Manager
ATTACHED SUPPORTING DOCUMENTS:
A. Monthly Treasurer’s Report (page A-1)
BACKGROUND AND DISCUSSION:
This report summarizes the cash balance of all funds and investments for the month of
June 2019. A separate report is prepared monthly for the Improvement Authority, and is
presented under separate cover before the Authority Commission.
The overall cash balances of the City totaled $64,006,641, with more than $31.2 million
or 49% of the total cash balance in the Local Agency Investment Fund (LAIF). The City
has more than $5.3 million or 8% of the total cash balance with Bank of the West, and
over $4.1 million or 7% with Malaga Bank. In addition, the City has Certificates of
Deposit (CD) investments over $17.2 million or 27% and Treasury Bills in the amount of
$6 million or 9% of the total cash balance. The CD and securities are held by the Bank
of New York and are FDIC-insured.
In summary, the City’s General Fund has over $19.8 million or 31% in cash balance,
and the Capital Improvement Projects (CIP) Fund has over $26.5 million or 42% in cash
balance. The remaining cash balances are in the Equipment Replacement Fund with
over $2.6 million or 4%, over $1.4 million or 2% in the 1911 Act Fund, over $0.9 million
1
or 1% in the Habitat Restoration Fund, over $1.7 million or 3% in the Quimby Fund, and
over $10.8 million or 17% in Other Restricted Funds.
The City’s cash balance increased by almost $0.4 million from last month, and in
comparison to the same period last year, the cash balance increased by $0.7 million.
The major variance was attributed to the decrease in CIP Fund expenditures. CIP Fund
expenditures were down due to the timing of disbursements for the City projects. The
major disbursements for this month included Stay Green for the Landscaping
Maintenance Project, United Storm Water for the Santa Monica Bay Catch Basin
Project, Sunbeam Consulting for the various City projects, Daniel B. Stephens for the
Portuguese Landslide Mediation Project, and All Environmental for the Civic Center
Phase II Subsurface Investigation Project. All other operating expenditures were
disbursed in accordance with the Fiscal Year 2018-19 budget.
2
A-1
BEGINNING BALANCE
PLUS: DEPOSITS
PLUS INTEREST EARNINGS(1)
LESS: CHECK DISBURSEMENTS
LESS ELECTRONIC DISBURSEMENTS(2)
ADJUSTMENTS(3)
PLUS: TRANSFERS IN
LESS: TRANSFERS OUT
ENDING BALANCE
(1) All LAIF interest is paid quarterly
(2) Electronic Disbursements·
Payroll
Payroll Charges
Bank and Merchant Fees
CITY OF RANCHO PALOS VERDES
MONTHLY TREASURER'S REPORT
JUNE 2019 (PRELIMINARY)
The June Treasurer Report will be re-submitted after the year-end adjustment is completed
Bank
of the West
OPERATING
5,865,408.60
1 ,814,840. 73
(1 ,529, 136.68)
(600,320.83)
(22, 799.36)
(203,227.45)
5,324,765.01
368,171.30
223,080.03
9,069.50
600,320.83
Malaga
Bank
OPERATING
Malaga Bank
Non-Negotiable
PETTY CASH LAIF-CITY CD
5 000 00 31,259,265.49 4,149,553 75
5,000.00 31,259,265 49 4,149,553.75
(3) The net adjustment was due to void checks, returned item, and other adjustments.
JUNE 2019 CASH BALANCE BY MAJOR FUNDS
1%
YTD INT
INVESTMENT
CD TOTAL CASH RECEIVED
22,314,829 03 63,594,056 87
1,814,840 73
555,252.16
(1,529,13668)
(600,320.83)
(22,799 36)
953,227 45 953,227 45
(203,227 .45)
23,268,056 48 64,006,640.73 555,252.16
.GENERAL FUND 31%
.CIP42%
• EQUIPMENT REPLACEMENT 4%
.1911 ACT 2%
C HABITAT RESTORATION 1%
.QUIMBY 3%
.OTHER RESTRICTED FUNDS 17%
A-2
CASH BAlANCES BY FUND
Unrestricted
GENERAL FUND
Restricted by Council Action
BEAUTIFICATION FUND
CIP
EQUIPMENT REPlACEMENT
BUILDING REPlACEMENT
EMPLOYEE BENEFITS
Sublolal
Restricted by Law or External Agencies
STREET MAINTENANCE
1972 ACT
EL PRADO
CDBG
CDBG-R
1911 ACT
SOLID WASTE
AIR QUALITY MANAGEMENT
PROPOSITION C
PROPOSITION A
PUBLIC SAFETY GRANTS
MEASURER
MEASURE M
HABITAT RESTORATION
SUBREGION 1 MAINTENANCE
MEASURE A MAINTENANCE
ABALONE COVE SEWER DISTRICT
RPVTV
GINSBURG CULTURE ARTS BUILDING
DONOR RESTRICTED CONTRIBUTION
FEDERAL GRANTS
STATE GRANTS
QUIMBY
LOW-MODERATE INCOME HOUSING
AFFORDABLE HSNG IN LIEU
EET
MEASURE A CAPITAL
BIKEWAYS
UNDERGROUND UTILITIES
ROADWAY BEAUTIFICATION
WATER QUALITY FLOOD PROTECTim
REDEVELOPMENT OBLIGATION RETIR
IMPROVEMENT DISTRICT 9
SPECIAL TRUSTS
Subtotal
GRAND TOTAL
BAlANCE
FORWARD
20,459,952 .03
21 ,640 .61
25 ,612 ,959.48
2 ,608 ,865 .62
0.00
0 .00
28 ,243,465.71
743 ,832.26
28 ,097 .98
32,429.19
0.00
0 00
1.524 ,647.87
446,600 .09
81 ,884.66
895 ,383 .81
2 ,022 ,142.84
124 ,713 .64
797 ,795 .82
51,720 .33
939 ,371 .29
763 ,345 .51
88 ,472 .84
333 ,605.81
0.00
1,752.05
769,271 .15
903 ,692 .99
0.00
1, 759 ,649 .30
153,813 .37
830 ,397 .81
506 ,544 .99
0 .00
79 ,134 .11
0.00
0.00
200 ,000.00
190 ,314.62
0 00
622 ,024 .80
14 ,890,639.13
63,594,056.87
CITY OF RANCHO PALOS VERDES
MONTHLY TREASURER'S REPORT
JUNE 2019
DEBIT CRED IT CASH
3,969 ,483.89 4,622,183.53 19 ,807,252.39
5 ,469 .83 27 .1 10.44 0 .00
1,208 ,925 .00 277 ,052 .09 26 ,544 ,832 .39
75 ,225 .00 11,443 .95 2 ,672 ,646 .67
0 .00 0 .00 0 .00
000 000 0 .00
1,289,619.83 315,606.48 29,217,479.06
137 ,304 .87 33 ,356 .76 847,780 37
0 .00 0.00 28 ,097 .98
11.49 19 .01 32 ,421 .6 7
15 ,119 .00 7 ,550 .00 7 ,569 .00
0 .00 0.00 0.00
2 ,885 .49 32.219.23 1,495 ,314 .13
30 ,494 .60 16 ,517.47 460 ,577 .22
0 .00 0.00 81 ,884 .66
56 ,949 .75 28 ,105 .01 924 .228 .55
68 ,658 .52 0 00 2 ,090 ,801 .36
0 .00 32 ,500 .00 92 ,213 .64
42 ,711 .79 6,123.50 834 ,384 .1 1
48 ,761 .30 19 ,627 .36 80 .854 .27
0.00 0 .00 939 ,371 .29
0 .00 2 ,423.02 760 ,922 .49
0 .00 22 ,500.00 65 ,972 .84
0 .00 3 ,341 .05 330 ,264 .76
0 .00 0.00 0 .00
0 .00 0.00 1,752 .05
6 ,500 .00 11 ,356.42 764 ,414 .73
0 .00 79 ,000 .00 824 ,692 .99
89 ,047 .21 89 ,047 .21 0.00
0 .00 48,468.00 1,71 1,181 .30
0.00 0 .00 153 ,813 .37
0 .00 0.00 830 ,397 .81
0 .00 0 00 506 ,544 .99
0 .00 0.00 0.00
0 .00 0.00 79 ,134 .1 1
0 .00 0.00 0 .00
0 .00 0.00 0 .00
0 .00 0.00 200 ,000 .00
0 .00 0.00 190 ,314 .62
0 .00 0 00 0 .00
55 ,248 .95 30 ,268 .78 647 ,004 .97
553,692.97 462,422.82 14,981,909.28
5,812,796.89 5,400,212.83 64,006,640 .73 .
Total Investment: 64 ,006 ,640 .7 3
Change In
End ing Cash
Balance
(652,699.64
(21 ,640 61)
931 ,872 .91
63 ,781 .05
0 .00
0 00
974,013.35
103,948 .11
0 .00
(7 .52)
7,569 .00
0 00
(29 ,333 .74)
13 ,977 .13
0 00
28 ,844 .74
68 ,658 .52
(32 ,500 .00)
36 ,588 .29
29 ,133.94
0 .00
(2 ,423 .02)
(22 ,500 .00)
(3 ,341 .05)
0 .00
0.00
(4 ,856 .42)
(7 9 ,000.00)
0 00
(48 ,468 .00)
0.00
0 .00
0.00
0.00
0 .00
0 .00
0 .00
0 .00
0 .00
0 .00
24,980 .17
91 270.15
412,583.86
Change In
Ending Cash
Balance in %
-3%
100%
4%
2%
0%
0%
3%
14 %
0%
0%
0%
0%
-2 %
3%
0%
3%
3%
-26 %
5%
56 %
0%
0%
-25 %
-1%
0%
0%
-1%
-9%
0%
-3%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
4%
1%
1%
A-3
Investment
Check1ng Accounts
Check1ng Accounts
Issuer of
Investment
Bank of t'le West
Ma1aga Bar,k
Petty Cash NiA
Local Agenc} Investment Fund tLAIF-CITY! State of Cal1forn1a
Note 111
CD -Non-Negotiable Malaga Bank
CD -Non-Negotrable Malaga Bank
CD-Bank of New York -Vtntng Sparks 1Non-Abacus Federal
Negot1able 1 Sav1ngs Bank
Alleg1ance Bank
Texas
Amer1can Express
Bank FSB
A'iler1can Express
Centunon
Bank of New
England NH
Bankers Bank
Mad1sor. WI
Bankers Bank of the
West
Bar Harbor Bank &
Trust
Barclays Bank
Delaware
Benef1c1al Bank
Bus mess Bk of St
LOUIS
Caldwell Bank &
Trust Co
Caprtal Bank Lrttle
Rock
Caprtal One NA
Carroll County State
Bank Iowa
Community F1nl
SVCS Bank
Cont1nerttal Bank UT
Crossf1rst Bank
East Boston Savmgs
Bark
Enerbank USA
Everbank /
JacKsonville FL
Farmers&Merchants
BK NEB
F1rst Bank of
H1gll1and
F1rst Fmanc1al Bank
Frrst Federal SVGS
Bank
F1rst Internet Bank of
In
F:rst Nat1ona! Ba'1k
of Amenca
F1rst Nat'l Bank
M1ch1gan
F1rst Western Bank
Flags tar Bank
Gold Cast
Bank!Chrcago
Goldrr.af"\ Sachs
Bank USA
HSBC Bank USA
Henry County Bank
OH
CUSIP#
01748DAY2
02587CHR4
02587DN38
063847AM9
06610RAT6
06610TDN2
066851WV4
06740KKD8
08 1 73QBT2
12325EHV7
128829ADO
139797FRO
14042RDA6
145087AF9
20364ABW4
2 1 1163GYC
22766ABBO
2-1 13PBM2
29266N6P;-
29976DQ78
30781TBD9
319141GE1
3202' MFC8
32C31YCD4
32056GCQ1
3211 OY JT3
32114VBJ5
33749VAG3
33847E2J5
38058KDM5
38149MAU7
40434YGK7
426336BF9
CITY OF RANCHO PALOS VERDES
MONTHLY TREASURER'S REPORT
JUNE 2019
Acquisit1on
Date
N/A
N/A
N/A
N/A
2/23/2018
2123/2018
6120/2016
11'3/2017
12/19/2017
312 1 /2017
10121/2016
12120/2017
9/14/2016
6/28/2019
7/12/2017
10/7/2016
Bli 9/2016
6/22/2016
10/13/2016
8/12/2016
-.'12/2016
2123/2018
6/9/2017
1 C0/2017
1 Ot13/20'7
8/12/~016
1/18/2017
617i:.:.c~ 7
2/21 i2C18
1/1712018
'/14/2017
1120/2017
1/12/2018
-'15.'2016
6/1 2/2019
5.'31/2019
3/21/2017
1/27/2017
Term
NIA
N/A
N/A
24 Mas
24 Mas
39 Mos
60 Mos
48 Mas
60 Mos
36 Mos
48 l~os
36 Mas
24 Mas
6C Mas
48 Mas
60 Mas
36 Mas
39 Mas
48 Mas
36 Mas
36 Mos
36 Mos
60 Mos
60 Mos
48 Mos
36 Mos
60 Mas
6C Mas
48 Mas
37 Mas
60 Mas
60 Mos
21 Mas
36 Mas
36 Mas
45 Mos
36 Mas
60 Mas
60 Mas
Matunty
Date
Or, Der1a"d
On Demand
On Der1ar,d
Or Demand
2/23/202C
2123 '2020
91'7'2019
~ ~ 13/20'22
12120/2021
4/5/2022
10/21/2019
12/20/2021
9.'13/2019
6128/2021
1/12/2022
10/7/2020
7 /' 9/2022
8/19/2019
9/23/2019
10113/2020
8/12/2019
7/12/2019
8/23/2021
6/9/2022
1120/2022
10/1312021
8/12/2019
1118/2022
6/7/2022
212212022
211//2021
7/14/2022
1/20/2022
4113/2020
7.115/2019
6.'13/2022
6/9/202C
5/31/2022
3121/202:.:
1/21/2022
$
Market
Value
5 DOC
31 259 265
250 ODD
3 899 554
250 ODD
25C ODD
250 DOD
250 DOD
250 DOD
250 000
250 DOD
250 000
250 DOD
250 000
250 000
250 DOD
25C 008
250 000
250 000
250 000
250 OJO
25C ODD
250 000
25C DOC
250 DOD
250 000
250 ooc:
250 000
250 000
250 OOJ
250 ODD
250 000
250 000
250 DOD
250 000
250 000
250 000
250 000
Vining Sparks
Cash
NiA
N/A
NIA
NIA
$
$
Book
Value Yield
5 324 765 Q 00%
c 25%
5 .000 :J 00%
31.259 265 2 43%
250 DOC 1 -5%
3 899 554 1 60°/o
250 000 1 25%
250 000 ;: 20°/c
250 000 2 20%
250.000 2 45%
250 ODD 1 20%
250 000 2 15%
250 000 1 1 5°/c
250.000 2 '0%
250 DOD 2 20%
250 DOD 1 35%
250 000 2 05%
250 000 1 DO%
250.000 1 20%
250 000 1 40%
250.000 1 00%
250 000 ~ C5%
250 000 2 30'/,
250 ODD 2 J5%
250 DOC 2 DO'k
250 ODD 2 DO%
250 000 ~ -5%
250 000 2 05%
2so ooo .::: ~c%
250 000 ~ 45%
250.000 2 15%
250 000 2 05%
250 ODD 2 00%
250 000 2 00%
250 000 1 00%
250 000 2 50%
250000 ; 15%
250.000 2 50%
250 DOC 2 45%
250 000 1 90%
A-4
Treasury-Bank of New YorktVInlng Sparks)
CD-Bank of New York (V1n1ng Sparos1 AdJ
Independent
BK/Memph1s
lnduS!rlai&Com BallK
China
International Bk
Chicago
lsbella Bank
JP MORGAN
CHASE BANK
LCA Bank Corp
Lakes1de Ba11k
L ve Oak Bankmg
Company
Luana Sav1ngs Bank
Mercafltll Bank NA
Merr1ck Bank
M1d-M1ssour1 Bank
Morgan Stanley
Bank NA
Morgan Stanley PVT
Bank
Marion Commun1ty
Noncf1led Bank
Partners Bank
Cal•forn1a
Peoples Un1ted Bank
Preferred Bank La
Cal1fornta
Sallie Mae Bank! Salt
Lake
S1gnature Bank of
Arkansas
S1gnature Bk
Cn1cago
Southerr States
Bank
Stearns Bank NA
Summ1t Commun1ty
Bank
Suntrust Bank
Synchrony Bank
Third Fed Sav&Ln
Clevland
Tr1ad Bank
Un1on Bank and
Trust/OX
Unrted Commun1ty
BK II•
\1\/as"l,llgton Trust
Weterly
We s Fargo Bank
Wh1tney Bank/MS
Worlds Foremost
Bank
Yadk1n Bank
Un1ted States Treas
Ufllted States Treas
U'11ted Sta~es T:eas
U111ted States Treas
Un1ted States Treas
U111tea States Treas
Unrted States Treas
45383USK2
455E 1 EAFB
45906ABR7
464209CJ2
48' 2~ C802
801 "98LK6
51210SMD6
538036CG7
549103WGO
58733AES4
59013JC23
59541 KBP1
6F47MD73
61760ADT3
619165HP1
66612ABX5
702 12YAU6
740367EW3
795450ZF5
82669LGD9
82669VBY6
843879BB2
857894SD2
86604XML7
86789VUPO
87155HRY8
884130BU1
89579NBP7
905200CE9
90983WBNO
940637HW4
949763045
966594AW3
981571 CV2
984308EG7
9~ 28282T6
912828080
9' 2828S:C6
912828TH3
912828WS5
9'2828XH8
912828XM7
1 A '1612016
6 '2/2C17
1:)/20'2['17
2/15'2017
'1 12/20'8
A '13/20A 7
8119/2016
-/8/2016
12/29/2017
1 8/11.'2C17
'/19/2016
12/2"/2017
9/7/2017
1119/20'8
10/25/2017
111912C16
10112/2016
7/15/2016
11/8/2017
12/20/2017
1/13/2017
1/26/2018
8/29/2017
6/2/2017
1112412017
6/2/2016
1/20/2017
10/12/2017
1' 118/2016
6/'10/20'9
• 12512017
~/2'/2017
9/19/2016
813/2018
8/3/2018
-~3A/2018
7131/2018
8/24/2018
6130/2019
7/31/2018
37 Mos
5C Mos
54 Mas
36 Mas
6C Mos
6C Mas
54 Mas
48 Mas
36 Mas
60 Mas
50 Mas
35 Mas
24 Mos
36 Mos
60 Mas
36 Mas
62 Mas
36 Mas
36 Mas
48 Mas
60 Mas
40 Mas
36 Mas
30 Mas
60 Mos
60 Mos
48 Mos
46 Mos
3G Mos
54 Mas
36 Mas
36 Mas
36 Mas
36 Mas
36 Mas
12 Mas
12 Mas
36 Mos
12 Mos
10 Mas
'2 Mas
24 Mas
12/15/2019
6/2/2022
412012022
9/912019
21' 512022
1/12/2023
7r 3/202 1
8/19/2020
71812020
12/29/2020
10/11/2022
1 "9/2023
12/2'/2020
919/2019
1119/2021
10/25/2022
11/18/2019
1118/2022
1118/2019
10/15/2019
7/15/2020
11/8/2022
4/20/2021
1/13/2020
7126/2021
8/29/2022
6/2/2022
11/24/2021
4/212020
7/22/2019
4/12/2022
11/18/20'9
6/10/2022
1127/2020
1/21/2020
9/19/2019
8131/2019
8/31/2019
7'3~/202A
7/31/2019
6/30/2019
6/30/2020
7131/2020
$
$
$
$
$
250 OJO
25C OOC
25S DOD
250 JOO
250 :J8[,
250 DOC
25C DJO
25C DOD
25C OOC
250 000
250 000
25C OOC
250 080
25C 080
25C 000
250 000
25C DOD
250 DOD
25C OOC
250 000
250 000
250 000
250 000
250 000
25C 000
250 000
250 ODO
250 000
250 000
25G 000
250 000
250 000
250 000
250 000
200 000
250 000
5DO DDO
500 000
1 DOC OGC
1 ooc 000
1 000 000
1 000 000
1 000 ODD
23 45C ODO
Total Investment:
5
s
$
$
$
$
250 000 1 15'/,
250000 2A0%
250 000 1 15%
250 ooc 2 30%
250 000 2 35%
250 ODD 1 95%
250 000 1 25%
250000 1 ~5%
250 000 2 20%
250 000 2 10%
250 000 2 35%
250 000 2 15%
250 000 1 75%
250 000 215%
250 000 215%
250 000 1 10%
250 000 2 05%
250000 115%
250 000 1 30%
250 000 1 15%
250 000 2 15%
250 000 2 00%
250 000 1 60%
250 880 2 20%
250 000 1 80%
250 000 2 40%
250 000 2 10%
250.000 1 25'/,
250 000 1 45%
250 000 2 05%
250 000 1 35%
250 000 2 50%
250 ooo 1 -o%
200 000 1 75%
250000 110%
500 000 1 25%
500 000 1 63%
1 000 ooc ; 25%
1 000 000 0 88%
1 000 000 1 63%
1 000 000 1 63%
1 000 000 1 63%
(181 944 )
64 006 640
Total Investment Weighted Average Return 1 91%
A-5
NOTE :
Malaga Bank -CD
7%
SUMMARY OF CASH BALANCE BY INSTITUTION
JUNE 2019
Bank of the West
8%
State of California· LAIF
49%
(1) LAtF market values will be reported to vary from book value ~the City calculated share of total LAIF assets IS less than the City book value.
To the best of my knowledge, there are no misstatements of material amounts within this report :
or omissions of matenal amounts to cause the report to be misleading
I certify that this report accurately reflects all City investments and complies with the investment policy of the City
of Rancho Palos Verdes as approved by the City Council. Furthermore. I certify that sufficient investment liquidity
and anticipated revenues are available to meet the City's expenditure raqu~rements for the next six months
~1(~/t<J
Treasurer Dated