CC SR 20190219 D - November 2018 Treasurer Report - CityRANCHO PALOS VERDES CITY COUNCIL
AGENDA REPORT
MEETING DATE: 2/19/2019
AGENDA HEADING: Consent Calendar
AGENDA DESCRIPTION:
Consideration and possible action regarding the November 2018 Cash
Balances/Monthly Treasurer’s Report
RECOMMENDED COUNCIL ACTION:
(1) Receive and file the November 2018 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
November 2018. 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 $58,679,114, with more than $26.6 million
or 45% of the total cash balance in the Local Agency Investment Fund (LAIF). The City
has more than $5.1 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 $17.9 million or 31% 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.
In summary, the City’s General Fund has over $14.2 million or 24% in cash balance,
and the Capital Improvement Projects (CIP) Fund has over $24.7 million or 42% in cash
balance. The remaining cash balances are in the Equipment Replacement Fund with
over $2.5 million or 4%, over $1.8 million or 3% in the 1911 Act Fund, over $1.1 million
or 2% in the Habitat Restoration Fund, over $1.8 million or 3% in the Quimby Fund, over
1
$9,000 negative cash in the Water Quality Fund which will be offset from a transfer in
December, and over $12.2 million or 21% in Other Restricted Funds.
The City’s cash balance decreased by $1.1 million from last month, and in comparison
to the same period last year, the cash balance was in a better position. There were $1
million more spending in November 2017 comparing with November 2018 in the capital
projects. The major disbursements for this month included Hardy & Harper for the
Residential Street Rehab Improvement Project, Stay Green for the park landscaping
maintenance, United Irrigation for the sidewalk and the beautification projects, and
Aleshire and Wynder for the legal services. All other operating expenditures were
disbursed in accordance with the FY18-19 budget.
2
Bank Malaga Malaga Bank YTD INT
of the West Bank Non-Negotiable INVESTMENT
OPERATING OPERATING PETTY CASH LAIF-CITY CD CD TOTAL CASH RECEIVED
BEGINNING BALANCE 6,235,337.58 3,000.00 26,616,519.91 4,121,236.01 22,814,829.03 59,790,922.53
PLUS: DEPOSITS 2,104,330.57 2,104,330.57
PLUS: INTEREST EARNINGS(1)- 184,188.84
LESS: CHECK DISBURSEMENTS (2,330,051.48) (2,330,051.48)
LESS: ELECTRONIC DISBURSEMENTS(2)(923,391.22) (923,391.22)
ADJUSTMENTS(3)37,303.59 37,303.59
PLUS: TRANSFERS IN -
LESS: TRANSFERS OUT -
ENDING BALANCE 5,123,529.04 3,000.00 26,616,519.91 4,121,236.01 22,814,829.03 58,679,113.99 184,188.84
(1) All LAIF interest is paid quarterly.
(2) Electronic Disbursements:
Payroll 556,406.19
Payroll Charges 355,350.82
Postage 5,000.00
Bank and Merchant Fees 6,634.21
923,391.22
(3) The net adjustment was due to void checks, returned item, and deposit adjustment.
CITY OF RANCHO PALOS VERDES
MONTHLY TREASURER'S REPORT
NOVEMBER 2018
24%42%
5%3%
2%
3%
0%
21%
NOVEMBER 2018 CASH BALANCE BY MAJOR FUNDS
GENERAL FUND 24%
CIP 42%
EQUIPMENT REPLACEMENT 5%
1911 ACT 3%
HABITAT RESTORATION 2%
QUIMBY 3%
WATER QUALITY FLOOD PROTECTION 0%
OTHER RESTRICTED FUNDS 21%
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
1972ACT
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
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
15,133,246.31
224,210.28
24,859,929.22
2,572,582.88
0 .00
0 .00
27,656,722.38
245,891 .19
27,926.71
30,022 .63
29,422.84
0 .00
2 ,035,100.19
449,207.75
65,390.93
743,115.81
1,908,755.82
102,190.82
2 ,692,577.02
78.493.84
1,007,511 .39
785,395.70
76 ,218.12
320,664.73
0.00
87,649.81
871 ,884.95
1,002,710.39
1,847,677.15
152,875.80
825,336.13
480,164.00
0.00
78,651 .75
0 .00
0 .00
7 ,914.55
414,856.57
0 .00
633,347.25
17,000,953.84
59,790,922.53
CITY OF RANCHO PALOS VERDES
MONTHLY TREASURER'S REPORT
NOVEMBER 2018
DEBIT CREDIT CASH
3,542,216.15 4 ,385,710.18 14,289,752.28
0 .00 118,996.00 105,214.28
40,820.96 159,724.67 24 ,741 ,025.51
0 .00 12,875.23 2,559,707.65
0 .00 0 .00 0.00
0 .00 0 .00 0.00
40,820.96 291 ,595.90 27,405,947.44
142,360.70 165,847.55 222,404.34
0 .00 0 .00 27,926.71
46.71 120.11 29,949.23
0 .00 665.00 28,757.84
0 .00 0 .00 0 .00
13,910.31 159,308.97 1,889,701 .53
164.92 14,239.60 435,1 33.07
0 .00 0 .00 65,390 .93
45,622.61 21 ,018.00 767 ,720.42
54,988.04 5 ,702.98 1,958,040.88
24,014.28 0 .00 126,205.10
34,238.71 24,679.10 2, 702,136.63
36,248.66 85,931 .58 28,810.92
106,785.60 0 .00 1,114,296.99
0 .00 7,588.45 777,807.25
51 ,633.66 0 .00 127,851.78
11 .24 3,641 .78 31 7,034.19
0 .00 0.00 0.00
0 .00 0 .00 87,649.81
1,500.00 7 ,500.00 865,884.95
0 .00 0 .00 1,002,710.39
0 .00 30,953.13 1,816,724.02
0 .00 0 .00 152,875.80
0 .00 0 .00 825,336.13
3,902.00 0.00 484,066.00
0 .00 0 .00 0.00
0 .00 0 .00 78,651 .75
0 .00 0.00 0.00
0 .00 0 .00 0 .00
0 .00 17 ,532.51 (9 ,617 .96
0 .00 1,916.49 412,940.08
0 .00 0 .00 0 .00
41 ,089.62 27 ,411 .38 647,025.49
556,517.06 574,056.63 16,983,414.27
4 ,139,554.17 5 ,251,362. 71 58,679,113.99
Total Investment: 58,67 9 ,11 3 .99
Change In
Ending Cash
Balance
(843,494.03
(118,996.00
(118,903. 71
(12,875.23
0 .00
0 .00
(250,774.94
(23,486.85
0.00
(73.40
(665.00
0 .00
_(_145 ,398.66
(14,074.68
0 .00
24,604.61
49,285.06
24,014 .28
9 ,559.61
(49,682.92
106,785.60
(7 ,588.45
5 1,633.66
(3 ,630.54
0.00
0.00
(6 ,000.00
0 .00
(30,953.13
0 .00
0 .00
3 ,902.00
0.00
0.00
0 .00
0.00
(17,532.51
(1 ,916.49
0 .00
13,678.24
(17,539.57
(1 ,111,808.54
Change In
End ing Cash
Balance in %
-6%
-53%
0%
-1%
0 %
0%
-1%
-10%
0%
0%
-2%
0%
-7%
-3%
0 %
3%
3 %
23%
0%
-63%
11 %
-1%
68%
-1%
0 %
0 %
-1%
0 %
-2%
0 %
0 %
1%
0%
0 %
0 %
0%
-222%
0 %
0%
2%
0 %
-2%
A-2
Investment
Checking Accounts
Checking Accounts
Petty Cash
Issuer of
Investment
Bank of the West
Malaga Bank
N/A
Local Agency Investment Fund (LAIF-CITY) State of California
CD Malaga Bank
CD Malaga Bank
CD -Bank of New York -Vining Sparks (Non-Abacus Federal
Negot1able) Sav1ngs Bank
Allegiance Bank
Texas
Amer ican Express
Bank FSB
American Express
Centurion
BMW Bank North
America
Bank of New
England NH
Bankers Bank
Madison WI
Bankers Bank of the
West
Barclays Bank
Delaware
Beneficial Bank
Business Bk of St
Louis
Caldwell Bank &
Trust Co.
Capital Bank Little
Rock
Capital One Bank
USA
Capital One NA
Capstone Bank
Carroll County State
Bank Iowa
Celtic Bank
Community Finl
SVCS Bank
Continental Bank UT
Crossfirst Bank
Discover Bank
East Boston Savings
Bank
Enerbank USA
Everbank I
Jacksonville FL
Farmers& Merchants
BK NEB
First Bank of
Highland
First Financial Bank
First Federal SVGS
Bank
First Internet Bank of
In
First National Bank
of America
First Nat'l Bank
Mi chigan
First Western Bank
Gold Cast
Bank/Chicago
HSBC Bank USA
CUSIPt
00257TAUO
01748DAY2
02587CHR4
02587DN38
05580AER1
063847AM9
06610RAT6
06610TDN2
06740KKD8
08173QBT2
12325EHV7
128829ADO
139797FRO
140420YN4
14042RDA6
14069TAH8
145087AF9
15118RPC9
20364ABW4
211163GYO
22766ABBO
254672ZB7
27 113PBM2
29266N6P7
29976DQ78
30781TBD9
319141GE1
32021MFC8
32031YCD4
32056GCQ1
32110YJT3
32114VBJ5
33749VAG3
38058KDM5
40434YGK7
CITY OF RANCHO PALOS VERDES
MONTHLY TREASURER'S REPORT
NOVEMBER 2018
Ac:quisition
Date
N/A
N/A
N/A
N/A
2123/2018
2/23/2018
6/20/2016
11/3/2017
12/19/2017
3/21 /2017
5/27/2016
10/2 112016
12/2 0/2017
9/14/2016
7/12/2017
10nt2016
7/19/2017
8/1 9/2016
6/22/2 016
5/4/2016
10/1 3/2016
6/1 5/2016
8/12/2016
6/15/2016
7112/2016
2/23/2018
6/9/2017
6/8/2016
1/20/2017
10/13/2017
8/12/2016
1/18/2017
6/7/201 7
2/21/2018
1117/2018
7/1 4/2 01 7
1/20/2017
1/1 2/2018
7/15/2016
9/9/2016
3/21 /2017
Term
N/A
N/A
N/A
N/A
24 Mas
24 Mas
39 Mas
60 Mas
48 Mas
60 Mas
36 Mas
36 Mas
48 Mas
36 Mas
60 Mas
48 Mas
60 Mas
36 Mas
39 Mas
36 Mas
48 Mas
36 Mas
36Mos
36 Mas
36 Mas
36 Mas
60 Mas
36 Mas
60Mos
48 Mas
36Mos
60 Mas
60 Mas
48 Mas
37 Mas
60 Mas
60 Mas
27 Mas
36 Mos
45 Mas
60 Mos
Maturity
Date
On Demand
On Demand
On Demand
On Demand
212312020
212312020
9/17/2019
11/3/2022
12/20/2021
4/5/2022
5/28/2019
10/21120 19
12/20/2021
9/13/2019
7/12/2022
10!7/2020
7/19/2022
8/19/2019
9/23/2019
5/6/2019
10/13/2020
6/14/2019
8/12/20 19
6/14/2019
7/12/2019
8/23/2021
6/9/2022
6/1 0/2019
1/20/2022
10/13/2021
8/12/20 19
1/18/2022
6 nt2022
212212022
2/17/2021
7/t 4/2022
1/20/2022
4/13/2020
7/15/2019
6/9/2020
3/21 /2022
$
$
$
Mart~;et
Value
5,123,529
3.000
$ 26,616,520
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
252.649
3.868.587
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
2 50 ,000
250,000
250,000
250,000
250,000
250.000
250.000
250,000
Vining Sparks
Cash
N/A
N/A
N/A
N/A
Book
Value Yield
$ 5.123,529 0 .00%
$ 0.25%
$ 3.000 000%
$ 26.616,520 2 .21%
$ 252,649 175%
$ 3,868,587 1.60%
$ 250,000 1.25%
$ 250,000 2.20%
$ 250,000 2.20%
$ 250,000 2.45%
$ 250,000 1.15%
$ 250,000 1.20%
$ 250 ,000 2 15%
$ 250,000 1 15%
$ 250,000 2.20%
$ 250,000 1 35%
$ 250,000 2.05%
$ 250.000 1.00%
$ 250,000 1.20%
$ 250,000 1.20%
$ 250,000 1.40%
$ 250 ,000 1.20%
$ 250,000 1.00%
$ 250,000 1 20%
$ 250,000 1.05%
$ 250,000 2 .30%
$ 250,000 2 05%
$ 250,000 1.15%
$ 250,000 2 .00%
$ 250,000 2.00%
$ 250,000 1.1 5%
250,000 2.05%
$ 250,000 2.10%
$ 250.000 2.45%
$ 250,000 2.15%
$ 250,000 2.05%
$ 250,000 2.00%
$ 250,000 2 00%
$ 250,000 1.00%
$ 250,000 1.15%
$ 250,000 2.45%
A-3
Henry County Bank
OH
Independent
Bk/Memphis
lndustriai&Com Bank
China
International Bk
Chicago
lsbella Bank
JP MORGAN
CHASE BANK
LCA Bank Corp
lakeside Bank
live Oak Banking
Company
luana Savings Bank
Mercantil Bank NA
Merrick Bank
Mid-Missouri Bank
Morgan Stanley
BankNA
Morgan Stanley PVT
Bank
Morton Community
Northfiled Bank
Pacific Continental
Bank
Partners Bank
California
Peoples United Bank
Preferred Bank La
California
Sallie Mae Bank/Salt
Lake
Signature Bank of
Arkansas
Signature Bk
Chicago
Southern States
Bank
Steams Bank NA
Summ~ Community
Bank
Suntrust Bank
SynChrony Bank
Third Fed Sav&Ln
Clevland
Triad Bank
Union Bank and
Trust/OX
United Community
Bk Ill
Washington Trust
Weterty
Whitney Bank/MS
Wo~ds Foremost
Bank
Yadkin Bank
Treasury-Bank Of New York(Vining Sparks) United States Treas
United States Treas
United States Trees
United States Treas
United States Treas
United States Trees
CO-Bank of New York (Vining Sparks) Adj
426336BF9
45383USK2
45581EAF8
45906ABR7
464209CJ2
48121C8Q2
801798LK6
51210SMD6
538036CG7
549103WGO
58733AES4
59013JC23
59541KBP1
61747M073
61760AOT3
619165HP1
66612A8X5
69413CEU9
70212YAU6
712700QJ8
740367EW3
795450ZF5
82669LGD9
82669V8Y6
843879882
857894SD2
86604XML7
86789VUPO
87165HRY8
88413Q8U1
89579NBP7
905200CE9
90983WBNO
940637HW4
986594AW3
981571CV2
984308EG7
9128282T6
912828080
912828S76
912828TH3
912828WS5
912828XM7
112712017
11/1612016
61212017
10120/2017
91712016
2/1512017
111212018
1/1312017
8/1912016
7/812016
1212912017
10/1112017
1/1912018
12121/2017
9f712017
1/1912018
1012512017
513112016
11/1812016
1/1812017
111912016
10/1212016
7/1512016
11/812017
1212012017
1/1312017
112612018
812912017
61212017
1112412017
61212016
112012017
10/1212017
11/1812016
112512017
112112017
9/1912016
81312018
81312018
713112018
713112018
812412018
713112018
60Mos
37 Mos
60Mos
54 Mos
36Mos
60Mos
60Mos
54Mos
48Mos
48Mos
36Mos
60Mos
60Mos
36Mos
24Mos
36Mos
60Mos
36Mos
36Mos
60Mos
36Mos
36Mos
48Mos
60Mos
40Mos
36Mos
30Mos
60Mos
60Mos
48Mos
46Mos
30Mos
54Mos
36Mos
36Mos
36Mos
36Mos
12Mos
12Mos
36 Mos
12Mos
10Mos
24 Mos
112712022
12/1612019
61212022
4120/2022
91912019
2/15/2022
1/1212023
711312021
8/1912020
7/812020
1212912020
10/1112022
1119/2023
1212112020
91912019
1119/2021
10/2512022
513112019
1111812019
1/1812022
11/812019
10/15/2019
7/15/2020
11/812022
412012021
111312020
712612021
8/2912022
61212022
1112412021
41212020
712212019
4/1212022
1111812019
112712020
112112020
911912019
813112019
813112019
713112021
7/3112019
6/3012019
713112020
$
$
$
s
$
$
$
$
$
$
$
$
s
s
$
$
$
s
$
$
$
$
$
$
$
$
$
$
s
$
s
$
$
$
$
$
$
$
$
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
200,000
250,000
500,000
500,000
$ 1,000,000
$ 1,000,000
$ 1,000,000
$ 1,000,000
$ 22,950,000
Total Investment:
s 250,000 1.90'M.
$ 250,000 1.15'111
$ 250,000 2.05'111
s 250,000 2 .10'111
$ 250,000 1.15'111
$ 250,000 2.30'111
$ 250,000 2 .35%
s 250,000 1.95'111
s 250,000 1.25'111
s 250,000 1.15'111
$ 250,000 2.20'111
s 250,000 2.10'111
s 250,000 2.35'111
$ 250,000 2.15'111
s 250,000 1. 75'111
$ 250,000 2.15'111
$ 250,000 2.15'111
$ 250,000 1.10'111
$ 250,000 1.10'111
s 250,000 2 .05'111
s 250,000 1.15'111
s 250,000 1.30'111
s 250,000 1.15'111
$ 250,000 2 .15'111
$ 250,000 2.00'111
$ 250,000 1.60'111
$ 250,000 2 .20'111
$ 250,000 1.80'111
$ 250,000 2.40'111
s 250,000 2 .10'111
s 250,000 1.25'111
$ 250,000 1.45'111
$ 250,000 2 .05'111
$ 250,000 1.35'111
$ 250,000 1.70'111
$ 200,000 1.75'111
s 250,000 1.10'111
$ 500,000 1.25'111
$ 500,000 1.63'111
$ 1,000,000 1.25'111
$ 1,000,000 0 .88'111
$ 1 ,000,000 1.63'111
$ 1,000,000 1.63'111
s (135,171 )
$ 58,679,114
Total Investment Weighted Average Return 1. 76'111
A-4
NOTE:
Malaga Bank -CD
7%
SUMMARY OF CASH BALANCE BY INSTITU TION
NOVEMBER 2018
Vlnin& Sparks -Treasury
8%
Bank ofthe West
9% Malaga Bank -MMDA
0%
(1) See footnote on the summary page
(2) LAIF 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 nsport;
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 City Council. Furthermore, I certify that sufficient investment liquidity
and anticipated revenues are available to meet the City's expend~ura nsquirements for the next six months.
Respedfully submitted,
~WJ--'/u/l'i
Treasurer ~ Datea
A-5