CC SR 20191001 C - Aug Treasurer ReportRANCHO PALOS VERDES CITY COUNCIL MEETING DATE: 10/01/2019
AGENDA REPORT AGENDA HEADING: Consent Calendar
AGENDA DESCRIPTION:
Consideration and possible action regarding the August 2019 Cash Balances/Monthly
Treasurer’s Report
RECOMMENDED COUNCIL ACTION:
(1) Receive and file the August 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
August 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 $61,654,613, with more than $28.9 million
or 47% of the total cash balance in the Local Agency Investment Fund (LAIF). The City
has more than $5.5 million or 9% 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 $18 million or 29% and Treasury Bills in the amount of
$5 million or 8% of the total cash balance. The CD and securities are held by the Bank
of New York and are FDIC-insured. The City currently holds a money market account
with Vining Sparks for the transaction of selling and purchase purposes.
In summary, the City’s General Fund has over $18 million or 29% in cash balance, and
the Capital Improvement Projects (CIP) Fund has over $26.7 million or 43% 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 2% in the Habitat Restoration Fund, over $1.5 million or 3% in the Quimby Fund, and
over $10.2 million or 17% in Other Restricted Funds.
The City’s cash balance decreased by more than $0.2 million from last month, and in
comparison to the same period last year, the cash balance from prior year recovered by
$0.1 million. Expenditures for this month included disbursements for both Fiscal Year
2018-19 and the month of August. The major variance was attributed to the decrease in
General Fund, CIP Fund, and Quimby Fund for normal operating expenditures. The
major disbursements for this month included Stay Green for the landscaping
maintenance project, Los Angeles County Sheriff for law enforcement services, Aleshire
& Wynder for legal services, Guggenheim Insurance for the settlement with Mark
Doddy, Kasa Construction for the Conestoga Trail Project, and Daniel B. Stephens for
the Portuguese Landslide Mediation Project. All other operating expenditures were
disbursed in accordance with the FY 18-19 and FY 19-20 budget.
2
A-1
CASH BALANCES BY FUND
Unrestricted
GENERAL FUND
Restricted by Council Action
BEAUTIFICATION FUND
CIP
EQUIPMENT REPLACEMENT
BUILDING REPLACEMENT
EMPLOYEE BENEFITS
Subtotal
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
18,267,834.79
1.88
26,933,177.51
2,676,230.54
0.00
0.00
29,609,409.93
913,617.17
28,189.50
32,540.71
0 00
0.00
1,462,228.93
446,511.33
82,135.69
653,668.03
2,175,035.95
92,584.58
876,102.89
103,794.53
904,121.73
760,390.85
66,236.59
330,907.77
0 00
1,757.76
766,700.45
95,587.83
0.00
1,716,374.44
154,314.39
833,102.68
508,178.02
0.00
0.00
0.00
0.00
190,382.04
190,934.53
0.00
634,820.90
14,020,219.29
61,897,464.01
CITY OF RANCHO PALOS VERDES
MONTHLY TREASURER'S REPORT
AUGUST 2019
DEBIT CREDIT CASH
4,064,193.00 4,328,486.14 18,003,541.65
0.00 1.88 (0.00)
1,908.66 147,738.90 26,787,347.27
0 00 13,798.28 2,662,432.26
0 00 0.00 0.00
0.00 0.00 0.00
1,908.66 161,539.06 29,449,779.53
168,496.71 164,943.97 917,169.91
0.00 0.00 28,189.50
102.49 8.42 32,634.78
23,618.00 23,618.00 0.00
0 00 0.00 0.00
25,593.74 51,728.84 1,436,093.83
9,700.33 24,302.09 431,909.57
14,366.21 0.00 96,501.90
57,462 25 17,097.00 694,033.28
341,557.70 5,208.40 2,511,385.25
0 00 0 00 92,584.58
42,215.14 29,461.70 888,856.33
46,657.98 73,164.75 77,287.76
0 00 0 00 904,121.73
0.00 4,592.56 755,798.29
0 00 0 00 66,236.59
2,765.35 1,320.87 332,352.25
0.00 0 00 0.00
0.00 0 00 1,757.76
1,500.00 721.00 767,479.45
0.00 0 00 95,587.83
144,320.00 144,320.00 0.00
0 00 152,487.00 1,563,887.44
0.00 0 00 154,314.39
2,444.00 0 00 835,546.68
0 00 0.00 508,178.02
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 190,382.04
0.00 0.00 190,934.53
0.00 0.00 0.00
28,373.75 35,126.36 628,068.29
909,173.65 728,100.96 14,201,291.98
4,975,275.31 5,218,126.16 61,654,613.16
Total Investment: 61,654,613.16
Change In
Ending Cash
Balance
(264,293.14)
(1.88)
(145,830.24)
(13, 798.28)
0.00
0.00
(159,630.40)
3,552.74
0.00
94.07
0 00
0.00
(26, 135.1 0)
(14,601.76)
14,366.21
40,365.25
336,349.30
0 00
12,753.44
(26,506.77)
0 00
(4,592.56)
0 00
1,444.48
0 00
0.00
779.00
0.00
0 00
(152,487.00)
0 00
2,444.00
0.00
0 00
0 00
0.00
0 00
0.00
0.00
0 00
(6,752.61)
181,072.69
(242,850.85)
Change In
Ending Cash
Balance in%
-1%
-100%
-1%
-1%
0%
0%
-1%
0%
0%
0%
0%
0%
-2%
-3%
17%
6%
15%
0%
1%
-26%
0%
-1%
0%
0%
0%
0%
0%
0%
0%
.. 9%
0%
0%
0%
0%
0%
0%
0%
0%
0%
0%
-1%
1%
0%
A-2
Investment
Local Agency Investment Fund (LAIF-CITY)
Note (1)
CD -Non-Negotiable
CD -Non-Negotiable
Issuer of
Investment
State of California
Malaga Bank
Malaga Bank
CD-Bank of New York -Vining Sparks (Non-Abacus Federal
Negotiable) Savings Bank
Alleg1ance Bank
Texas
Ally Bani<
Amencan Express
Bank FSB
American Express
Centurion
BMW Bank North
America
Bank of New
England NH
Bankers Bank
Madison WI
Bankers Bank of the
West
Bar Harbor Bank &
Trust
Barclays Bank
Delaware
Beneficial Bank
Business Bk of St
Louis
CIT Bank
Cap1tal Bank Little
Rock
Capital One NA
Capital One Bank
USA
Community West
Bank
Continental Bank UT
Crossf1rst Bank
East Boston Savings
Bank
Enerbank USA
Exchange Bank
F anners&Merchants
BK NEB
First Bank of
H1ghland
Ftrst Commercial
Bank MS
Ftrst Financial Bank
First Federal SVGS
Bank
First Internet Bank of
In
First National Bank
of America
F~rst Nat'l Bank
Michigan
Flagstar Bank
Gold Cast
Bank/Chicago
Goldman Sachs
Bank USA
HSBC Bank USA
Henry County Bank
OH
Independent
Bk/Memphis
lndustriai&Com Bank
China
International Bk
Chicago
lsbella Bank
CUSIP#
00257TAUO
01748DAY2
02007GKW2
02587CHR4
02587DN38
05580ASE5
063847AM9
06610RAT6
06610TDN2
066851WV4
06740KKD8
08173QBT2
12325EHV7
12556LBB1
139797FRO
14042RDA6
14042TBD8
204150GX1
211163GYO
22766ABBO
27113PBM2
29266N6P7
301074DF4
30781TBD9
319141GE1
31984GFA2
32021MFC8
32031YCD4
32056GCQ1
32110Y JT3
32114VBJ5
33847E2J5
38058KDM5
38149MAU7
40434YGK7
426336BF9
45383USK2
45581EAF8
45906ABR7
464209CJ2
CITY OF RANCHO PALOS VERDES
MONTHLY INVESTMENT REPORT
AUGUST 2019
Acquisition
Date
N/A
2/23/2018
2/23/2018
6/20/2016
11/3/2017
7/25/2019
12/19/2017
3/21/2017
8/16/2019
10/21/2016
12/20/2017
9/14/2016
6/28/2019
7112/2017
10/7/2016
7/19/2017
8/23/2019
6/22/2016
10/13/2016
7/24/2019
7/26/2019
2/23/2018
6/9/2017
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
1/12/2018
6/12/2019
9/9/2016
5/31/2019
3/21/2017
1/27/2017
11/16/2016
6/2/2017
10/20/2017
9/7/2016
Term
N/A
24 Mos
24 Mos
39 Mos
60 Mos
36 Mos
48 Mos
60 Mos
18 Mos
36 Mos
48 Mos
36 Mos
24 Mos
60 Mos
48 Mos
60 Mos
6 Mos
39 Mos
48 Mos
36 Mos
18 Mos
36 Mos
60 Mos
60 Mos
48 Mos
24 Mos
60 Mos
60 Mos
24 Mos
48 Mos
37 Mos
60 Mos
60 Mos
27 Mos
36 Mos
45 Mos
36 Mos
60 Mos
60 Mos
37 Mos
60 Mos
54 Mos
36 Mos
Maturity
Date
On Demand
2/23/2020
2/23/2020
9/17/2019
11/3/2022
7/25/2022
12/20/2021
4/5/2022
2/16/2021
10/21/2019
12/20/2021
9/13/2019
6/28/2021
7/12/2022
10/7/2020
7/19/2022
2/23/2020
9/23/2019
10/13/2020
7/25/2022
1/26/2021
8/23/2021
6/9/2022
1/20/2022
10/13/2021
7/19/2021
1/18/2022
6/7/2022
7/30/2021
2/22/2022
2/17/2021
7/14/2022
1/20/2022
4/13/2020
6/13/2022
6/9/2020
5/31/2022
3/21/2022
1/27/2022
12/16/2019
6/2/2022
4/20/2022
9/9/2019
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
Market
Value
28,950,734
250,000
3,915,130
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
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
Vining Sparks
Money Market
N/A
N/A
N/A
Book
Value Yield
$ 28,950.734 2.34%
$ 250,000 1.75%
$ 3.915,130 1.60%
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
250,000 1 25%
250,000 2 20%
250,000 2.15%
250,000 2 20%
250,000 2.45%
250,000 1.90%
250,000 1.20%
250,000 2 15%
250,000 1 15%
250.000 2.10%
250,000 2 20%
250,000 1. 35%
250,000 2. 05%
250,000 1. 95%
250,000 1.20%
250,000 1 40%
250,000 2.10%
250,000 1.95%
250,000 2.30%
250,000 2.05%
250,000 2 00%
250,000 2 00%
250,000 2. 05%
250,000 2.05%
250.000 2.10%
250,000 1. 95%
250,000 2.45%
250,000 2.15%
250,000 2 05%
250.000 2 00%
250,000 2 00%
250.000 2 50%
250,000 1.15%
250,000 2.50%
250,000 2.45%
250,000 1.90%
250,000 1.15%
250,000 2.05%
250,000 2.10%
250 000 1 15%
A-3
Investment
Treasury-Bank of New York(Vrning Sparks)
Summary
Local Agency Investment Fund (LAIF-CITY)
Certificate of Deposit-Malaga Bank
Certificate of Deposit-Malaga Bank
Certificate of Deposit-Vining Sparks
Treasury Bills-Vining Sparks
Money Market -Vrning Sparks
Total Investment
Issuer of
Investment
JP MORGAN
CHASE BANK
LCA Bank Corp
Lakesrde Bank
Landmark
Commun1ty Bank
Live Oak Bankrng
Company
Luana Sav1ngs Bank
Mercantil Bank NA
Merrick Bank
Mid-Missouri Bank
Morgan Stanley
Bank NA
Morgan Stanley PVT
Bank
Morton Community
Northfrled Bank
Partners Bank
California
Peoples Unrted Bank
Preferred Bank La
California
Sallie Mae Bank/Salt
Lake
Signature Bank of
Arkansas
Signature Bk
Chicago
Southern States
Bank
Stearns Bank NA
Summit Community
Bank
Suntrust Bank
Synchrony Bank
Thrrd Fed Sav&Ln
Clevland
Triad Bank
United Community
Bk Ill
Washington Trust
Weterly
Wellesley Bank
Wells Fargo Bank
Whitney Bank!MS
Worlds Fore most
Bank
Yadkin Bank
United States Treas
United States Treas
Unrted States Treas
United States Treas
United States Treas
United States Treas
28.950,733.61
250,000 00
3,915,129 92
18.200,000.00
5.000,000 00
343,615 52
56.659.479 05
CUSIP#
48121C8Q2
801798LK6
51210SMD6
51507LBV5
538036CG7
549103WGO
58733AES4
59013JC23
59541KBP1
61747MD73
61760ADT3
619165HP1
66612ABX5
70212YAU6
712700QJ8
740367EW3
795450ZF5
82669LGD9
82669VBY6
843879BB2
857894SD2
86604XML7
86789VUPO
87165HRY8
884130BU1
89579NBP7
90983WBNO
940637HW4
94948LCRO
949763D45
966594AW3
981571 CV2
984308EG7
9128282J8
9128282T6
912828D80
912828S76
912828XH8
912828XM7
CITY OF RANCHO PALOS VERDES
MONTHLY INVESTMENT REPORT
AUGUST 2019
Acquisition
Date
2/15/2017
1/12/2018
1/13/2017
8/23/2019
8/19/2016
7/8/2016
12/29/2017
10/11/2017
1/19/2018
12/21/2017
9/7/2017
1/19/2018
10/25/2017
11/18/2016
1/18/2017
11/9/2016
10/12/2016
7/15/2016
11/8/2017
12/20/2017
1/13/2017
1/26/2018
8/29/2017
6/2/2017
11/24/2017
6/2/2016
10/12/2017
11/18/2016
7/19/2019
6/10/2019
1/25/2017
1/21/2017
9/19/2016
7/15/2019
8/3/2018
8/3/2018
7/31/2018
6/30/2019
7/31/2018
Term
60 Mos
60 Mos
54 Mos
36 Mos
48 Mos
48 Mos
36 Mos
60 Mos
60 Mos
36 Mos
24 Mos
36 Mos
60 Mos
36 Mos
60 Mos
36 Mos
36 Mos
48 Mos
60 Mos
40 Mos
36 Mos
30 Mos
60 Mos
60 Mos
48 Mos
46 Mos
54 Mos
36 Mos
18 Mos
36 Mos
36 Mos
36 Mos
36 Mos
12 Mos
12 Mos
12 Mos
36 Mos
12 Mos
24 Mos
Maturity
Date
2/15/2022
1/12/2023
7/13/2021
2/23/2022
8/19/2020
7/8/2020
12/29/2020
10/11/2022
1/19/2023
12/21/2020
9/9/2019
1/19/2021
10/25/2022
11/18/2019
1/18/2022
11/8/2019
10/15/2019
7/15/2020
11/8/2022
4/20/2021
1/13/2020
7/26/2021
8/29/2022
6/2/2022
11/24/2021
4/2/2020
4/12/2022
11/18/2019
1/19/2021
6/10/2022
1/27/2020
1/21/2020
9/19/2019
Total
7/15/2020
8/31/2019
8/31/2019
7/31/2021
6/30/2020
7/31/2020
Total
Total Investment wrth Vining Sparks
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
Market
Value
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
250.000
250.000
250.000
250.000
250,000
250.000
250,000
250,000
250,000
250,000
$ 200.000
$ 250,000
$ 18.200.000
$
$
$
$
$
1,000 000
500,000
500,000
1,000.000
1,000,000
1,000,000
5,000,000
23,200,000
Vining Sparks
Money Market
343.615 52
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
Book
Value Yield
250.000 2.30%
250.000 2.35%
250.000 1.95%
250 000 1.90%
250,000 1 25%
250,000 115%
250,000 2 20%
250,000 2.10%
250,000 2.35%
250.000 2.15%
250,000 1.75%
250,000 2 15%
250.000 2.15%
250,000 1 1 0%
250,000 2 05%
250.000 1 15%
250,000 1.30%
250,000 1 15%
250,000 2.15%
250,000 2 00%
250,000 1 60%
250.000 2.20%
250,000 1.80%
250.000 2.40%
250,000 2.10%
250,000 1.25%
250,000 2 05%
250,000 1.35%
250,000 2 00%
250,000 2.50%
250.000 1 70%
$ 200,000 1.75%
$ 250,000 1.10%
$ 18,200,000
$ 1 000,000
$ 500,000
$ 500,000
1.000.000
1,000,000
1.50%
1.25%
1.63%
113%
163%
$ 1,000,000 1 63%
$ 5.000.000
Weighted Return 2 06%
A-4
A-5