CC SR 20200901 F - July Treasurer Report
CITY COUNCIL MEETING DATE: 09/01/2020
AGENDA REPORT AGENDA HEADING: Consent Calendar
AGENDA TITLE:
Consideration and possible action to receive and file the July 2020 Cash
Balances/Monthly Treasurer’s Report.
RECOMMENDED COUNCIL ACTION:
(1) Receive and file the July 2020 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: Trang Nguyen, Director of Finance
APPROVED BY: Ara Mihranian, AICP, 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
July 2020. A separate report is prepared monthly for the Improvement Authority and
presented under separate cover before the Authority Commission.
The overall cash balances of the City totaled $62,945,695, with more than $34 million or
54% of the total cash balance in the Local Agency Investment Fund (LAIF). The City
has more than $3 million or 5% of the total cash balance with Bank of the West and
over $4.2 million or 7% with Malaga Bank. In addition, the City has a total Certificates of
Deposit (CD) investments and Treasury Bills $20.5 million or 33% of the total cash
balance and a money market account of over $1 million or 1% with Vining Sparks, our
investment brokerage firm. The high cash balance in the Vining Sparks money market
account is from the maturity of an investment. The securities are held by the Bank of
New York and are FDIC-insured.
1
In summary, the City’s General Fund has almost $20 million or 32% in the cash
balance, and the Capital Improvement Projects (CIP) Fund has over $25.3 million or
40% 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.8 million or 1% in the Habitat Restoration Fund, over $1.2 million or 2% in the
Quimby Fund, and over $11.5 million or 19% in Other Restricted Funds.
The City’s cash balance decreased by $3 million from last month. In comparison to the
July balance from last year, the cash balance in this month increased by $1.1 million,
mainly attributed to the timing of disbursements for City-approved projects. The major
disbursements for this month included Aleshire & Wynder for legal services, Sunbeam
Consulting for various city projects, Palp Inc. for the Transit Improvement Turnout
Station Project, Vigilant Solution for the ALPR Camera Project, the California Joint
Powers Insurance Authority for the annual contribution to Liability and Workers’
Compensation Programs, and the Los Angeles County Sheriff ’s Department for law
enforcement services. All other expenditures were disbursed in accordance with both
Fiscal Year 2019-20 and 2020-2021 budgets.
2
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
CalpPers SB Billing
CaiPers Lump Payment
Bank and Merchant Fees
Bank of the West
Operating
3,260,928.74
1,938,116.00
(3,588,986 26)
(1,429,556.48)
(155.89)
3, 000,000 00
(1 00,000 00)
3,080,346.11
360,549 .84
222,073 .85
5,712.00
835,201.00
6,019.79
1,429,556.48
(3) The net adjustment was due to void checks and deposit adjustment
CITY OF RANCHO PALOS VERDES
MONTHLY TREASURER'S REPORT
JULY 2020
Malaga Bank
Non-Negotiable Vining Sparks
Petty Cuh LAIF-CITY CD Money Marl<et
5,000.00 35,941,946.79 4,224 ,963.35 1,038,545.55
117,672.67
(62,779.35)
100,000.00
(2.000,000.00)
5,000.00 34 ,059,619.46 4 ,224,963.35 1,075, 766.20
JULY 2020 CASH BALANCE BY MAJOR FUNDS
1%
Vining Sparks YTDint
lnveatment TotaiCaah Rect~ived
21,500,000 00 65,971 ,384.43
1,938,116.00
117,672.67 730,066.27
(3,588, 986 26)
(1 ,429,556 48)
(62,935 .24)
3,100,000 00
(1,000,000 00) (3,1 00,000.00)
20,500,000.00 62,945,695.12 730,066.27
.GENERAL FUND 32%
• EQUIPMENT REPLACEMENT 4%
.1911 ACT 2%
!:I HABITAT RESTORATION 1%
mQUIMBY 2%
.OTHER RESTRICTED FUNDS 19%
A-1
CASH BALANCES BY FUND
Unrestricted
GENERAL FUND
Restricted by Council Action
BEAUTIFICATION FUND
CIP
EQUIPMENT REPLACEMENT
BUILDING REPLACEMENT
EMPLOYEE BENEFITS
SubiDtal
Restricted by Law or External Agencies
STREET MAINTENANCE
1972 ACT
EL PRADO
CDBG
CDBG-R
1911 ACT
SOLID WASTE
AIR QUALITY MANAGEMENT
PROPOSITIO N 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 BU ILDING
DONOR RESTRICTED CONTRIBUTIONS
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 PROTECTION
REDEVELOPMENT OBLIGATION RETIRE
IMPROVEMENT DISTRICT 9
SPECIAL TRUSTS
Subtotal
GRANO TOTAL
BALANCE
FORWARD
23.150,817.01
0 .00
25,480,972 .72
2,618,683 .01
0 .00
0 .00
28,099,655.73
1,667,168.60
28,832.80
36,121 .86
12.677.32
0.00
1.263,488.28
457,580 .32
139,199.33
923.457 93
2,275,178.50
76,229.90
1,290,998.40
101 ,542 .09
810,536 .90
771 ,379 .32
0 .00
298,737 .17
0 .00
0 .00
782,213.65
98 .314 .23
0 .00
1,176,249 .02
193,248.90
854 ,586.70
263,278 .25
0 .00
0 .00
0 .00
0.00
0.00
195,955 .75
0.00
1,003,936.47
14,720,911 .69
65,971 ,384.43
CITY OF RANCHO PALOS VERDES
MONTHLY TREASURER'S REPORT
JULY 2020
DEBIT CREDIT CASH
7,096,918.21 10,271.071.62 19,976,663.60
0.00 0 .00 0.00
50,851.45 225 ,187.58 25.306 ,636.59
4 ,709.52 8 ,844.45 2.614 .548 08
0.00 0 .00 0.00
0.00 0.00 0 00
55,560.97 234,032.03 27,921 ,184.67
139.615.70 30 .225.56 1,776,558.74
51 .98 0 .00 28 .884 78
90.53 0 .00 36 ,212 .39
23,000.00 12 .307 .50 23 .369 .82
0.00 0 .00 0 00
216,873.61 21 ,851 .99 1,458,509.90
10,496.42 19 .806 .66 448 ,270.08
242.56 0 .00 139,441.89
66,359 .81 4 ,808 .00 985 ,009.74
82.760.67 241.208.40 2.116,730 .77
190.01 0 00 76,419 .91
50 ,860.68 25 ,332 .50 1,316 ,526 .58
55,350.25 2 ,761 .44 154,130.90
4,961 .24 0 .00 815 ,498 .14
1,387 .80 1,534 .71 771 ,232.41
93.963 00 32 ,679.40 61 ,283 .60
1,042.09 38 ,505 .03 261 ,274 .23
0.00 0.00 0.00
0.00 0.00 0.00
1,410.47 1,670 .32 781 ,953.80
0.00 0 00 98,314 .23
30,407.84 30,407 .84 0.00
25,772.86 0 .00 1,202 .021 .88
348.39 0.00 193.597 .29
1,540 64 0 .00 856 ,127 .34
547.11 16 ,096.00 247 .729 .36
0.00 0 .00 0.00
0.00 0 .00 0.00
0.00 0 .00 0.00
0.00 0 .00 0.00
0.00 0 .00 0.00
353.27 0 .00 196,309.02
0.00 0 .00 0.00
70,225.25 71 ,721 .67 1,002,440.05
877 852.18 550,917.02 15,047,846.85
8,030,331 .38 11 ,058,020.67 62,945,695.12
Total Investment: 62,945,695.12
Change In
Ending Cash
Balance
(3, 174,153.41)
0 .00
(174.336 .13)
(4 .134 .93)
0 .00
0 .00
(178,471 .06)
109.390 .14
51 .98
90 .53
10.692.50
0 .00
195,021.62
(9.310 .24)
242 .56
61 .551.81
(158,447 .7 3)
190.01
25 .528.18
52.588 .81
4 ,961 .24
(146.91
6 1.283.60
(37,462.94)
0.00
0.00
(259.85)
0.00
0.00
25,772 86
348 39
1.540 .64
(15,548 .89
0 .00
0 .00
000
0.00
0 .00
353.27
0 .00
(1,496 42
326,935.16
(3,025,889.31
Change In
Ending Cash
Balance in%
-14%
0%
-1°/o
0%
Oo/o
0%
-1%
7%
0%
0%
84 %
Oo/o
15%
-2%
0%
7%
-7%
0%
2%
52 %
1%
0%
0%
-13%
0%
0%
0%
0%
0%
2%
0%
0%
-6%
0%
0%
0%
0%
0%
0%
0%
0%
2%
-5%
A-2
Investment
Local Agency Investment FunC 1LAIF-CITY)
Note 111
CD-Non-Negot1able
CD-Non-Negotiable
CD-Bank of New York -V1n1ng Sparks (Non-
Negotiable)
Issuer of
Investment
State of Cal1forn1a
Malaga Bank
Malaga Bank
Alleg1ance Bank
Texas
Ally Bank
Amer1can Bank Na
Le Mars
Amencan Express
Bank FSB
Amencan Express
Centunon
AXOS Bank
BMW Bank North
Amenca
BMO Hams Bank
Rob1n
Bank of Deerfield
Bank Forward
Bankers Bank
Mad1son WI
Bar Harbor Bank &
Trust
Barclays Bank
Delaware
Baycoast Bank
Benef1c1al Bank
Bus1ness Bk of St
LOUIS
CIT Bank
Cap1tal One NA
Cap1tal One Bank
USA
Cathy Bank
Celt1c Bank
Commun1ty West
Bank
Continental Bank UT
Crossf1rst Bank
Eagle bank
East Boston Sav1ngs
Bank
Enerbank USA
Exchange Bank
F armers&Merchants
BK NEB
F 1rst Bank of
H1ghland
F1rst Commerc1al
Bank MS
F1rst Fmanc1al Bank
F~rst Federal SVGS
Bank
F 1rst Internet Bank of
In
F1rst Nat1onal Bank
of Amenca
Flagstar Bank
Goldman Sachs
Bank USA
Henry County Bank
OH
lnd.Jstr1ai&Com Bank
Ch1na
LCA Bank Corp
Lakes1de Bank
CITY OF RANCHO PALOS VERDES
MONTHLY INVESTMENT REPORT
JULY 2020
CUSIP#
01748DAY2
02007GKW2
024373AZ5
02587CHR4
02587DN38
05465DAK4
05580ASE5
05581W504
06063HMT7
061785EG2
062163BN9
06610RAT6
066851WV4
06740KKD8
072727AZ3
081730BT2
12325EHV7
12556LBB1
14042RDA6
14042TBD8
149159NX9
15118RUX3
20415QGX1
211163GYO
22766ABBO
27002YET9
27113PBM2
29266N6P7
301074DF4
30781TBD9
319141GE1
31984GFA2
32021 MFC8
32031YCD4
32056GC01
32110Y JT3
33847E2J5
38149MAU7
426336BF9
45581 EAF8
801798LK6
51210SMD6
Acquisition
Date
N/A
212312020
212312020
11/3/2017
7/25/2019
9/27/2019
12/19/2017
3/21/2017
3/26/2020
8/16/2019
2/28/2020
712212020
9/25/2019
12/28/2019
12/20/2017
6/28/2019
7/12/2017
1/24/2020
10/7/2016
7/19/2017
8/23/2019
10/13/2016
7/24/2019
9/25/2019
4/17/2020
7/26/2019
2/23/2018
6/9/2017
1/17/2020
1/20/2017
10/13/2017
7 /19/2019
1/18/2017
6/7/2017
7/31/2019
2/21/2018
1/17/2018
7 /14/2017
1/20/2017
6/12/2019
5/31/2019
1/2712017
6/212017
111212018
111312017
Term
NIA
24 Mas
24 Mas
60 Mas
36 Mos
36 Mas
48 Mas
60 Mos
48 Mas
18 Mas
60 Mas
60 Mas
42 Mos
60 Mas
48 Mas
24 Mas
60 Mas
48 Mas
60 Mas
30 Mas
48 Mas
36 Mas
24 Mas
60 Mas
18 Mas
36 Mas
60 Mas
36 Mas
60 Mas
48 Mas
.24 Mas
60 Mas
60 Mas
24 Mas
48 Mas
37 Mas
6G Mas
60 Mas
36 Mas
36 Mas
60 Mas
60 Mas
60 Mas
54 Mas
Maturity
Date
011 Demand
2/21/2022
212112022
11/312022
712512022
912'12022
12120/2021
415/2022
312612024
211612021
212812025
712212025
312412023
12/18/2024
1212012021
6/28/2021
7112/2022
1/24/2025
10/7/2020
//19/2022
2/23/2022
10/13/2020
7/25/2022
9/24/2021
4/17/2025
1/26/2021
8/23/2021
6/9/2022
1/17/2023
1/20/2022
10/13/2021
7119/2021
i/18/2022
6/7/2022
7/30/2021
2/22/2022
2/17/2021
7/14/2022
1120/2022
6113/2022
5/31/2022
1127/2022
6/2/2022
• 1'12/2023
7/13/2021
Market
Value
$ 34 059 619
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
258 DOG
3974963
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
25G 000
250 000
250 000
250 000
250 000
250 ooc
250 000
25C 000
25C 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
25[ 000
250 000
250 000
250 000
250 000
$
$
$
$
$
$
$
$
$
Book
Value Yield
34 059 619 c 92%
250 000 1 50%
3 974 963 1 40°/c
250 000 2 20%
250 000 2 15%
250 000 •. 65°/c
250 000 2 20%
250 000 2 45°/,
250 000 1 65%
250 000 1 9C%
250 000 1 90%
250 000
250 000 1 65%
250 000 1 75%
250 000 215%
250 000 2 10%
250 000 2 20%
250 000 1 70%
250 000 1 35%
250 000 2 05%
250 000 1 95%
250 000 1 40%
250000 210%
250 000 1 75%
250 000 1 50%
250 000 1 95%
250.000 2 30%
250 000 2 05%
250 000 1 70%
250 000 2 00%
250 000 2 00%
250 000 2 05%
250 000 2 05%
250 000 2 10%
250 000 I 95%
250 000 2 45%
250 000 2 15%
250 000 2 05%
250 000 2 00%
250 000 2 50%
250 000 2 50%
250 000 1 90%
250 000 2 05%
250 000 2 35%
250 000 1 95%
A-3
Investment
Treasury-Bank of New York1Vtr"l 1'1Q Sparks}
Summary
Local Agency Investment Funa tLAIF-CITY)
Certrfrcate of Deposrt -Malaga Bank
Certrf rcate of Depostl -Malaga Bank
Certrfrcate of Deposrt -Vrnrng Sparks
T re asury Brtls -V tnrng Sparks
T ota In vestment
Issuer of
Investment
Landmark
Communrt y Bank
Lrv e Oak Bankrng
Company
Malaga Bank FSB
Marlrn Busrness
Bank
Medall1 on Bank Utah
Mercantrl Bank NA
Merrrck Bank
M rd-Mrssourr Ba nk
Morgan Stanley
Bank NA
Morgar Stanley PVT
Bank
Morton Communrly
Northfiled Bank
Peoples Un1ted Bank
Preferred Bank LA
Raymond James
Bank
Sallie Mae Ba nk!Salt
Lake
Srgnature Bk
Ch1cago
Southern States
Bank
State Bank of lndra
Sterl1ng Bank POP
BL MO
Summrt Communrty
Bank
Suntrust Bank
Synchrony Bank
Thtrd Fed Sav&Ln
Clevland
V1sron Ba nk of Iowa
Well esley Bank
Well s Fargo Nan
Ba nk West
Wells Fa rgo Ba nk
Umted States Treas
Ur1rted States T reas
Unrted States Treas
34 .059.6 19 46
250 000 00
3 974 963 35
17 500 000 00
3 000 000 00
58 784 582 81
CITY OF RANCHO PALOS VERDES
MONTHLY TREASURER'S REPORT
JUly 2020
CUSIP#
5 ' 507L BVS
538036CG7
56102AAJ5
57 1 16ATMC
58404DFE6
58733AES4
59013JC23
59541KBP1
6-747MD73
61760AZ5 1
619165HP1
66612ABX5
7127000J8
740367MA2
75472RAN1
7954504P7
82669VBY6
843879BB2
856285RS2
85916VDN2
86604XML7
86789VUPO
87165HRY8
884130BU1
92834CCL4
94948LCRO
949495AQ8
949763045
912828S35
912828576
912828XZ8
Acquisition
Date
812312019
8/19/2016
512912020
'I' 512020
9/1812019
'21291201 7
10/1112017
111912018
12/2112017
911912019
1 1912018
-0125120 17
1/1812017
-117/2020
1112612019
11116/20 19
1'/812017
12120/2017
11/27/2019
9/1812019
1/2612018
812912017
61212017
<112412017
1112912019
711 9/2019
1117/2020
61'0/2019
911212019
713112018
613012020
Term
36 Mos
48 Mos
60 Mos
6C Mos
36 Mos
36 Mos
60 Mos
60 Mos
36 Mos
48 Mos
36 Mos
60 Mos
60 Mos
60 Mos
72 Mas
60 Mos
60 Mos
40 Mos
72 Mos
48 M os
30 Mos
60 Mos
60 Mos
48 Mos
72 Mas
18 Mos
3E Mos
36 Mos
45 Mos
36 Mos
60 Mos
Maturity
Date
2.'23/2J2:.'
81'19/2020
5129120 25
1115/2025
911912022
1212912020
10111/2022
111912023
12/2 1/2020
911912023
11"912021
1012512022
1118/2022
7;1-12025
11126/2024
101 161202 4
11/8/2022
4120/2021
11127/2024
911812023
712612021
812912022
61212022
1112412021
111291202 4
1119/2021
111 ;-12023
6 11 012 022
6130/2023
7131/2021
6/3012025
Tota1 Investment
$
s
$
$
$
$
$
$
$
$
$
$
Market
Value
250 a:>~
25C 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
250 000
25C 000
25C 000
250 000
25C 000
25G 000
25G 000
25C 000
25C 000
250 000
250 000
25C 000
25C 000
25C 000
250 000
250 000
250 000
1 ooc 000
1 OGG 000
1 OOC DOG
s
$
$
$
$
$
$
Book
Value Yreld
250 ooc ~ 90%.
250 000 1 2~%
250 000 0 70%
250 000 1 ~5%
2so ooo 1 -o%
250 000 2 20%
250 000 2 10%
250 000 2 35%
250 000 2 15'k
250 000 1 85'k
250 000 2 '5%
250 000 2 '5%
250 000 2 05%
250 000 0 5C%
250 000 1 85%
250 000 1 90%
250000 2 1 5%
250 000 2 00%
250 000 2 05%
250 000 1 65%
250 000 2 2C%
250.000 1 80%
250 000 2 40%
250 000 2 10%
250 000 1 75%
250.000 2 00%
250 000 1 90%
250 000 2 50%
$ 1 000 000 1 38%
$ 1 000 000 1 13%
$ 1000000 275%
58 784 583
We1g~ted Return 1 30%
A-4
NOTE:
Malaga Ba nk • CD
7%
CITY OF RANCHO PALOS VERDES
MONTHLY TREASURER'S REPORT
J Uly 2020
SUMMARY OF CASH BALANCE BY INSTITUTION
JUNE 2020
Vining Sparks • Treasury
S%
Bank of t he West
5%
Vining Sparks· Money Market
1%
State of California -lAIF
54%
(1) LAIF mar1<el values will be reported to vary from book value if the City calculated share of total LAIF assets is tess than the City book value.
To the best of my knowledge, there are no misstatements of matenat amounts within this report,
or omissions of material 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 Crty Council Furthennore. I certify that sufficient investment liquidity
and anticipated revenues are available to meet the City's expenditure requirements for the next six months.
Respectfully submitted.
Treasurer Dated
A-5