December 18, 2021
TO: The Honorable Mayor and City Council,
City Administrator, Deputy City Manager, Interim Finance Director FROM: Edward J. Carrillo - City Treasurer
REF
General Pooled Funds Investments + Cash Sweep Bank Account…………………………………………………………………………………………. 213,813,826.60
64%
A,G
Rialto Successor Agency (RSA) + Cash Sweep Bank Account…………………………………………………………………………………................................ 7,061,896.74
2%
B,H
Rialto Utility Authority (RUA) Pre-existing Investments + Cash Sweep Bank Account……………………………………………………………………………………………. 23,337,281.61
7%
C,I
Other Bank Accounts + Cash Sweep Bank Accounts……………………………………………………………………………………………………………………............. 1,781,592.39
1%
D,J
Escrow Accounts……………………………………………………………………………………………………………………………................................................. 14,245,097.97
4%
E
Cemetery Endowment Fund (Restricted Accounts)…………………………………………………………………........................................................................... 401,708.71
0%
F,K
Pepper Avenue Extension (Restricted Accounts)………………………………………………………………….......................................................... 324,107.48
0%
L
General Fund Economic Reserve (Restricted Funds)……………………………………………………………………............................................... 25,791,431.51
8%
M
Public Agency Retirement Services - OPEB (Restricted Funds)…………………………………………………………………….................................. 17,028,601.69
5%
N
Cash with Fiscal Agents - (Restricted Bond Issues)…………………………………………………………………………...................................................... 5,271,987.21
2%
O
Cash with Fiscal Agents - RUA (Concession Agreement)………………………………………………………………….......................................................... 23,315,808.74
7%
P
TREASURER'S PORTFOLIO
332,373,340.65
100%
TREASURER'S MONTHLY REPORT - NOVEMBER 2021
The City’s Treasurer expects to have sufficient cash for the next six months , including use of General
Fund’s cash reserves.
The City of Rialto’s Investments and funds management is in compliance with the City’s Investment Policy and S tate
Mandates. Pooled Investments have liquidity below 30 days, and therefore carry Market Value at Issued Value.
Wells Fargo
Advisor
s, Clearwater Analytics and
Union Bank of California provided the Market Value of the investments held in custody.
Union
Bank of California (C
orporate Trust Dept)
and
US Bank (Corporate Trust Dept.)
provided Fiscal Agent information.
City of Rialto
TREASURER'S BANK
RECONCILIATION BALANCE SHEET
NOVEMBER 2021
ACTIVE ACCOUNTS
BALANCE
REF
GENERAL BANK ACCOUNT**
(1,481,614.05)
A
RSA BANK ACCOUNT**
-
B
RUA BANK ACCOUNT**
(24,520.82)
C
SPORTS CENTER/POOL**------------------------------------------------------------------------------------------------------------------------------------------------ -
AMBULANCE LOCKBOX------------------------------------------------------------------------------------------------------------------------------------------------- 48,117.67
FLEXIBLE BENEFIT**------------------------------------------------------------------------------------------------------------------------------------------------------------ -
ALARM LOCKBOX--------------------------------------------------------------------------------------------------------------------------------------------------------------- 2,728.90
BANK CARD-------------------------------------------------------------------------------------------------------------------------------------------------------------- 1,532.51
PAYROLL CLEARING --------------------------------------------------------------------------------------------------------------------------------------------------- 56,381.13
LIABILITY ACCT./CARL WARREN & CO.-------------------------------------------------------------------------------------------------------------------- 51,017.14
PEPPER AVENUE--------------------------------------------------------------------------------------------------------------------------------------------------- -
WORKERS COMP/LWP CLAIMS SOLUTIONS--------------------------------------------------------------------------------------------------------------- 393.17
PROPERTY EVIDENCE MONIES--------------------------------------------------------------------------------------------------------------------------------- 1,481,540.06
OTHER BANK ACCOUNTS
1,641,710.58
D
ENERGY CONSERVATION PROJECT---------------------------------------------------------------------------------------------------------------------- 84,786.55
AYALA @ 210 PARTNERS LLC------------------------------------------------------------------------------------------------------------------------------------ 310,666.30
LEWIS HILLWOOD------------------------------------------------------------------------------------------------------------------------------------------------------- 2,754,966.14
ALDER AVENUE---------------------------------------------------------------------------------------------------------------------------------------------------------- 3,279,340.63
LAUREL/WALNUT/LOCUST----------------------------------------------------------------------------------------------------------------------------------------------- 2,989,528.10
SUB ACCOUNT A-------------------------------------------------------------------------------------------------------------------------------------------------------- 4,825,810.25
ESCROW ACCOUNTS
14,245,097.97
E
CEMETERY ENDOWMENT FUND------------------------------------------------------------------------------------------------------------------------------- 79,369.82
RESTRICTED ACCOUNTS
79,369.82
F
TOTAL - ACTIVE ACCOUNTS
14,460,043.50
(A-F)
Note (**) - Cash is swept into Goverment Money Market Fund Sweep Accounts with Wells Fargo to earn interest on undisbursed monies. Accounts with negative balances are due to current month's outstanding checks.
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
REMAINING LIFE
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
IN MONTHS
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
WELLS FARGO CASH SWEEP ACCOUNT
POOLED FUNDS - GENERAL
11/01/21
---
11/01/21
---
---
0 1
---
---
---
36,630,362.64
36,630,362.64
36,630,362.64
SHARES PURCHASED
11/01/21
---
11/30/21
---
---
30 1
---
---
---
9,694,032.56
9,694,032.56
9,694,032.56
SHARES REDEEMED
11/01/21
---
11/30/21
---
---
30 1
---
---
---
(3,679,839.15)
(3,679,839.15)
(3,679,839.15)
INTEREST EARNED - GENERAL FUND ACCOUNT
11/01/21
---
11/30/21
---
0.01%
29 1
---
---
---
310.59
310.59
310.59
CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) - GENERAL 11/01/21
---
11/30/21
---
---
29 1
---
---
---
405,549.40
405,549.40
405,549.40
SUBTOTAL
43,050,416.04
43,050,416.04
43,050,416.04
PACIFIC PREMIER BANK #0314
POOLED FUNDS - #0314
11/01/21
---
11/01/21
---
0.10%
0 0
---
---
---
5,196,383.80
5,196,383.80
5,196,383.80
BANKING FEE
11/01/21
---
11/30/21
---
---
29 1
---
---
---
(2.00)
(2.00)
(2.00)
INTEREST EARNED #0314
11/01/21
---
11/30/21
---
---
29 1
---
---
---
298.98
298.98
298.98
SUBTOTAL
5,196,680.78
5,196,680.78
5,196,680.78
PACIFIC PREMIER BANK #7667
POOLED FUNDS - #7667
11/01/21
---
11/01/21
---
0.10%
0 0
---
---
---
3,530,682.02
3,530,682.02
3,530,682.02
BANKING FEE
11/01/21
---
11/30/21
---
---
29 1
---
---
---
(32.00)
(32.00)
(32.00)
INTEREST EARNED #7667
11/01/21
---
11/30/21
---
---
29 1
---
---
---
203.14
203.14
203.14
SUBTOTAL
3,530,853.16
3,530,853.16
3,530,853.16
LAIF - CALIFORNIA STATE POOL
POOLED FUNDS - LAIF
11/01/21
---
11/30/21
---
0.22%
29 1
---
---
---
20,215,404.28
20,215,404.28
20,215,404.28
SUBTOTAL
20,215,404.28
20,215,404.28
20,215,404.28
WELLS FARGO ADVISORS - CUSTODIAL
8025PZ13 - SANTANDER UK PLC CP
07/14/21
---
12/01/21
---
0.13%
140
5 0
P1
A1
3,898,117.71
3,900,000.00
3,899,961.00
46625HJD3 - JPMORGAN CHASE & CO SR UNSECURED
09/13/17
---
01/24/22
4.50%
4.47%
1594
52 2
A2
A-
3,265,620.00
3,000,000.00
3,017,700.00
2254EBBU4 - CREDIT SUISSE NEW YORK CP
06/03/21
---
02/28/22
---
0.16%
270
9 3
P1
A1
4,544,540.00
4,550,000.00
4,548,407.50
94974BFC9 - WELLS FARGO BANK SENIOR NOTES
01/29/19
---
03/08/22
3.50%
3.47%
1134
37 3
A1
BBB+
5,044,300.00
5,000,000.00
5,041,850.00
38150AEJ0 - GOLDMAN SACHS GRP INC MTN CALLABLE
11/20/20
02/24/22
11/25/22
0.40%
0.40%
735
24 12
A2
BBB+
7,497,500.00
7,500,000.00
7,482,900.00
94973VBA4 - WELLPOINT INC SR UNSECURED
07/13/21
---
01/15/23
3.30%
3.20%
551
18 14
BAA2
A
1,566,150.00
1,500,000.00
1,542,465.00
94974BFN5 -WELLS FARGO & CO SUBORDINATED
06/03/21
---
08/15/23
4.13%
3.91%
803
26 20
A3
BBB
5,519,832.00
5,100,000.00
5,367,801.00
38150AEF8 - GOLDMAN SACH GRP MTN CALLABLE
11/20/20
02/24/22
11/24/23
0.60%
0.60%
1099
36 24
A2
BBB+
3,000,000.00
3,000,000.00
2,966,670.00
17329F6E9 - CITIGROUP GLOBAL MARKETS MTN CALLABLE
03/30/21
03/31/22
03/31/24
0.70%
0.70%
1097
36 28
A3
BBB+
8,250,000.00
8,250,000.00
8,139,697.50
02665WDS7 - AMERICAN HONDA FINANCE MTN
02/25/21
---
07/12/24
0.55%
0.55%
1233
41 31
A3
A-
3,827,410.50
3,825,000.00
3,774,395.25
45950VQE9 - INTL FINANCE CORP MTN
09/08/21
---
09/10/24
0.43%
0.43%
1098
36 33
AAA
AAA
5,000,000.00
5,000,000.00
4,939,550.00
38150AFC4 - GOLDMAN SACHS GRP INC MTN CALLABLE
03/26/21
03/20/22
09/30/24
1.00%
1.01%
1284
42 34
A2
BBB+
4,500,000.00
4,500,000.00
4,428,540.00
61761JVL0 - MORGAN STANLEY MTN SR UNSECURED
07/15/21
---
10/23/24
3.70%
3.47%
1196
39 35
A1
BBB+
5,048,828.40
4,620,000.00
4,924,642.80
38150AFM2 - GOLDMAN SACHS GRP INC MTN CALLABLE
05/10/21
05/14/22
11/12/24
1.00%
1.02%
1282
42 35
A2
BBB+
10,000,000.00
10,000,000.00
9,782,800.00
037833AZ3 - APPLE INC SR UNSECURED
02/04/21
---
02/09/25
2.50%
2.39%
1466
48 38
AA1
AA+
2,157,500.00
2,000,000.00
2,085,740.00
06048WK66 - BANK OF AMERICA CORP MULTISTEP UP MTN CALLABLE 02/04/21
12/23/21
12/23/25
0.65%
0.67%
1783
59 49
A2
A-
1,994,000.00
2,000,000.00
1,923,640.00
17290AEA4 - CITIGROUP INC. MTN CALLABLE
10/15/21
10/19/24
10/19/26
1.45%
1.46%
1830
60 59
A3
BBB+
5,000,000.00
5,000,000.00
4,960,750.00
3130ANZ60 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/08/21
12/27/21
06/27/25
0.40%
0.40%
1388
46 43
AAA
AA+
1,500,000.00
1,500,000.00
1,481,445.00
3130ALZA5 - FEDERAL HOME LOAN BANK MULTI STEP COUPON BONDS CALLABLE 04/13/21
01/29/22
04/29/26
0.50%
0.50%
1842
61 53
AAA
AA+
6,000,000.00
6,000,000.00
5,969,160.00
3130AMB76 - FEDERAL HOME LOAN BANK BONDS CALLABLE
05/18/21
05/18/22
05/18/26
1.25%
1.25%
1826
60 54
AAA
AA+
1,108,800.00
1,100,000.00
1,096,359.00
NOTE. G (CONTINUED TO NEXT PAGE)
City of Rialto
SCHEDULE OF INVESTMENTS
GENERAL POOLED FUNDS / INVESTMENTS - REF: G
NOVEMBER 2021
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
REMAINING LIFE
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
IN MONTHS
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
City of Rialto
SCHEDULE OF INVESTMENTS
GENERAL POOLED FUNDS / INVESTMENTS - REF: G
NOVEMBER 2021
3130AMKN1 - FEDERAL HOME LOAN MULTISTEP UP COUPON BONDS CALLABLE 05/18/21
02/27/22
05/27/26
0.50%
0.50%
1835
60 54
AAA
AA+
8,900,000.00
8,900,000.00
8,851,050.00
3130ANUT5 - FEDERAL HOME LOAN BANK MULTI STEP COUPON BONDS CALLABLE 08/30/21
03/16/22
09/16/26
0.50%
0.50%
1843
61 58
AAA
AA+
10,000,000.00
10,000,000.00
9,906,500.00
3130ANZ52 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/08/21
12/28/21
09/28/26
0.50%
0.50%
1846
61 58
AAA
AA+
2,500,000.00
2,500,000.00
2,477,150.00
3130ANXC9 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/02/21
12/29/21
09/29/26
0.60%
0.60%
1853
61 58
AAA
AA+
5,000,000.00
5,000,000.00
4,933,650.00
78658RFR7 - SAFRA NATIONAL BANK CD
10/12/21
---
10/19/22
0.15%
0.15%
372
12 11
N.A.
N.A.
249,000.00
249,000.00
248,738.55
99000FGR3 - WORLD'S FOREMOST BANK CD
09/20/21
---
05/08/23
2.45%
2.39%
595
20 17
N.A.
N.A.
206,936.00
200,000.00
205,018.00
99000QMY7 - COMENITY BANK CD
09/23/21
---
08/15/23
2.15%
2.10%
691
23 20
N.A.
N.A.
206,372.00
200,000.00
204,758.00
05580AD92 - BMW BK N AMERICA CD
09/20/21
---
09/25/23
0.35%
0.35%
735
24 22
N.A.
N.A.
249,000.00
249,000.00
248,407.38
87165HD64 - SYNCHRONY BANK CD
09/20/21
---
09/25/23
0.40%
0.40%
735
24 22
N.A.
N.A.
249,000.00
249,000.00
248,633.97
38149MA52 - GOLDMAN SACHS BK USA CD
09/20/21
---
09/29/23
0.35%
0.35%
739
24 22
N.A.
N.A.
249,000.00
249,000.00
248,394.93
856285XP1 - STATE BANK OF INDIA CD
09/20/21
---
09/29/23
0.40%
0.40%
739
24 22
N.A.
N.A.
249,000.00
249,000.00
248,621.52
947547NE1 - WEBBANK CD
09/20/21
---
09/29/23
0.30%
0.30%
739
24 22
N.A.
N.A.
249,000.00
249,000.00
248,158.38
538036SD7 - LIVE OAK BANKING CO CD
09/21/21
---
10/02/23
0.25%
0.25%
741
24 22
N.A.
N.A.
249,000.00
249,000.00
247,926.81
649447UA5 - NEW YORK CMNTY BK CD
10/05/21
---
10/16/23
0.30%
0.30%
741
24 23
N.A.
N.A.
250,000.00
250,000.00
249,092.50
45581ECS8 - INDUSTRIAL & COM BK CD
09/21/21
---
10/18/23
0.35%
0.35%
757
25 23
N.A.
N.A.
249,000.00
249,000.00
248,322.72
06251A2J8 - BANK HAPOALIM BM NY CD
09/28/21
---
10/26/23
0.25%
0.25%
758
25 23
N.A.
N.A.
248,253.00
249,000.00
247,819.74
88241TFP6 - TEXAS EXCHANGE BK SSB CD
09/22/21
---
12/18/23
0.35%
0.35%
817
27 25
N.A.
N.A.
248,000.00
248,000.00
247,040.24
61765QQ28 - MORGAN STANLEY BK NA CD
10/01/21
---
01/08/24
0.25%
0.25%
829
27 25
N.A.
N.A.
250,000.00
250,000.00
248,925.00
47804GGX5 - JOHN MARSHALL BANK CD
09/29/21
---
06/17/24
0.25%
0.25%
992
33 31
N.A.
N.A.
243,020.40
245,000.00
242,042.85
29278TPT1 - ENERBANK USA CD
10/12/21
---
06/26/24
0.50%
0.50%
988
32 31
N.A.
N.A.
210,578.00
211,000.00
209,723.45
89235MLG4 - TOYOTA FINL SGS BK CD
09/23/21
---
08/12/24
0.60%
0.60%
1054
35 32
N.A.
N.A.
248,927.79
249,000.00
247,759.98
795451AW3 - SALLIE MAE BANK/SALT CD
09/20/21
---
09/23/24
0.70%
0.70%
1099
36 34
N.A.
N.A.
249,000.00
249,000.00
248,103.60
90348JT75 - UBS BANK USA CD
09/28/21
---
10/07/24
0.65%
0.65%
1105
36 34
N.A.
N.A.
249,000.00
249,000.00
247,637.97
59013KNU6 - MERRICK BANK CD
10/06/21
---
10/21/24
0.55%
0.55%
1111
37 35
N.A.
N.A.
249,000.00
249,000.00
246,806.31
48128WBQ7 - JP MORGAN CHASE BK NA CD
10/13/21
---
10/29/26
0.55%
0.50%
1842
61 59
N.A.
N.A.
125,000.00
125,000.00
123,435.00
53944VAS8 - LLOYDS BANK PLC SR NOTE
12/09/19
---
08/14/22
2.25%
2.22%
979
32 8
A1
A+
2,009,300.00
2,000,000.00
2,024,640.00
13605WQ79 - CANADIAN IMPERIAL BK COMM MTN CALLABLE
12/28/20
12/22/21
06/22/24
0.55%
0.56%
1272
42 31
A2
BBB+
3,000,000.00
3,000,000.00
2,929,290.00
459056HV2 - INTL BK RECON & DEVELOP SR UNSECURED
09/07/21
---
08/28/24
1.50%
1.47%
1086
36 33
AAA
AAA
1,031,750.00
1,000,000.00
1,018,370.00
89114TDD1 - TORONTO DOMINION BANK MTN CALLABLE
03/09/21
12/11/21
09/11/24
0.70%
0.70%
1282
42 33
A1
A
7,000,000.00
7,000,000.00
6,913,410.00
89114TF49 - TORONTO DOMINION BANK MTN CALLABLE
03/20/21
01/01/22
04/01/25
1.00%
1.01%
1473
48 40
A1
A
5,000,000.00
5,000,000.00
4,943,850.00
06747PKV0 - BARCLAYS BANK PLC - MTN CALLABLE
06/08/20
04/08/23
04/08/25
3.25%
3.18%
1765
58 40
A1
A
5,136,480.00
4,920,000.00
5,021,155.20
WFA ---TREASURY MONEY MARKET
11/01/21
---
11/30/21
---
0.01%
29 1
---
---
---
3,356.52
3,356.52
3,356.52
WFA --- CASH
11/01/21
---
11/30/21
---
---
29 1
---
---
---
22,514.07
22,514.07
22,514.07
SUBTOTAL
143,302,086.39
141,656,870.59
141,374,776.74
TOTAL - GENERAL POOLED FUNDS / INVESTMENTS
215,295,440.65
G
213,650,224.85
213,368,131.00
City of Rialto
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
REMAINING LIFE
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
IN MONTHS
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
WELLS FARGO CASH SWEEP ACCOUNT
RSA ACCOUNT **
11/01/21
---
11/01/21
---
---
0 0
---
---
---
7,070,908.30
7,070,908.30
7,070,908.30
SHARES PURCHASED
11/01/21
---
11/30/21
---
---
29 1
---
---
---
36,536.77
36,536.77
36,536.77
SHARES REDEEMED
11/01/21
---
11/30/21
---
---
29 1
---
---
---
(45,606.39)
(45,606.39)
(45,606.39)
INTEREST EARNED - WELLS FARGO
11/01/21
---
11/30/21
----
0.01%
29 1
---
---
---
58.06 58.06
58.06 TOTAL - RSA INVESTMENTS
7,061,896.74
H
7,061,896.74
7,061,896.74
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
REMAINING LIFE
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
IN MONTHS
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
WELLS FARGO CASH SWEEP ACCOUNT
POOLED FUNDS - RUA ACCOUNT **
11/01/21
---
11/01/21
---
---
0 0
---
---
---
6,752,267.78
6,752,267.78
6,752,267.78
SHARES REDEEMED
11/01/21
---
11/30/21
---
---
29 1
---
---
---
(1,527,129.28)
(1,527,129.28)
(1,527,129.28)
INTEREST EARNED - WELLS FARGO
11/01/21
---
11/30/21
---
0.01%
29 1
---
---
---
44.89 44.89
44.89 SUBTOTAL
5,225,183.39
5,225,183.39
5,225,183.39
LAIF - CALIFORNIA STATE POOL
POOLED FUNDS - LAIF
11/01/21
---
11/30/21
---
0.22%
29 1
---
---
---
100,684.38
100,684.38
100,684.38
SUBTOTAL
100,684.38
100,684.38
100,684.38
WELLS FARGO ADVISORS - RUA
61746BED4 - MORGAN STANLEY SR UNSECURED
08/11/20
---
11/17/21
2.63%
2.62%
---
---
---
---
---
---
---
---
94974BFN5 - WELLS FARGO & CO SUBORDINATED
06/03/21
---
08/15/23
4.13%
3.91%
803
26 1
A3
BBB
974,088.00
900,000.00
947,259.00
38150AJK2 - GOLDMAN SACHS GRP INC MTN
11/22/21
05/24/22
11/24/23
1.00%
1.00%
732
24 21
A2
BBB+
3,900,000.00
3,900,000.00
3,897,699.00
02665WDS7 - AMERICAN HONDA FINANCE MTN
02/04/21
---
07/12/24
0.55%
0.56%
1254
41 32
A3
A-
3,477,991.50
3,475,000.00
3,429,025.75
3815AJ48 - GOLDMAN SACHS GRP INC MTN
10/27/21
10/29/22
10/29/24
1.15%
1.15%
1098
36 36
A2
BBB+
413,000.00
413,000.00
411,521.46
3130AMRA2 - FEDERAL HOME LOAN BANK
06/02/21
12/24/21
06/24/26
0.63%
0.63%
1848
61 56
AAA
AA+
1,000,000.00
1,000,000.00
988,870.00
83369MM74 - SOCIETE GENERALE BANK MTN
10/14/20
01/19/22
10/19/22
0.40%
0.40%
735
24 12
A1
A
2,000,000.00
2,000,000.00
1,982,580.00
13605WQ79 - CANADIAN IMPERIAL BANK COMM MTN CALLABLE
12/18/20
12/22/21
06/22/24
0.55%
0.56%
1282
42 32
A2
BBB+
270,000.00
270,000.00
263,636.10
89114TDD1 - TORONTO DOMINION BANK MTN CALLABLE
03/09/21
12/11/21
09/11/24
0.70%
0.70%
1282
42 34
A1
A
3,000,000.00
3,000,000.00
2,962,890.00
89114TF49 - TORONTO DOMINION BANK MTN CALLABLE
03/30/21
01/01/22
04/01/25
1.00%
1.01%
1463
48 41
A1
A
3,000,000.00
3,000,000.00
2,966,310.00
WFA --- TREASURY MONEY MARKET
11/01/21
---
11/30/21
---
0.01%
29 1
---
---
---
854.88
854.88
854.88
WFA --- CASH
11/01/21
---
11/30/21
---
---
29 1
---
---
---
0.28 0.28
0.28 SUBTOTAL
18,035,934.66
17,958,855.16
17,850,646.47
TOTAL - RUA PRE-EXISTING INVESTMENTS
23,361,802.43
I
23,284,722.93
23,176,514.24
NOVEMBER 2021
SCHEDULE OF INVESTMENTS
RUA PRE-EXISTING / INVESTMENTS - REF: I
SCHEDULE OF INVESTMENTS
RSA STAGE COACH SWEEP ACCOUNT - REF: H
NOVEMBER 2021
City of Rialto
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
REMAINING LIFE
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
IN MONTHS
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
WELLS FARGO CASH SWEEP ACCOUNT - SPORTS CENTER & POOL
SPORTS CENTER & POOL ACCOUNT **
11/01/21
---
11/01/21
---
---
0 0
---
---
---
92,404.23
92,404.23
92,404.23
SHARES PURCHASED
11/01/21
---
11/30/21
---
---
29 1
---
---
---
12,773.99
12,773.99
12,773.99
INTEREST EARNED - SPORTS CENTER &POOL ACCOUNT **
11/01/21
---
11/30/21
---
0.01%
29 1
---
---
---
0.83 0.83
0.83 CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) - SPORTS CENTER &POOL ** 11/01/21
---
11/30/21
---
---
29 1
---
---
---
186.50
186.50
186.50
SUBTOTAL
105,365.55
105,365.55
105,365.55
WELLS FARGO CASH SWEEP ACCOUNT - FLEXIBLE BENEFIT
FLEXIBLE BENEFIT ACCOUNT**
11/01/21
---
11/01/21
---
---
0 0
---
---
---
34,515.98
34,515.98
34,515.98
INTEREST EARNED - FLEXIBLE BENEFIT ACCOUNT**
11/01/21
---
11/30/21
---
0.01%
29 1
---
---
---
0.28 0.28
0.28 SUBTOTAL
34,516.26
34,516.26
34,516.26
TOTAL - OTHER BANK ACCOUNTS INVESTMENTS
139,881.81
J
139,881.81
139,881.81
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
REMAINING LIFE
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
IN MONTHS
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
WELLS FARGO ADVISORS - CEMETERY ENDOWMENT FUND
38150AFG5 - GOLDMAN SACHS GRP INC MTN CALLABLE
04/28/21
04/30/22
04/30/26
1.35%
1.38%
1828
60 53
A2
BBB+
320,000.00
320,000.00
313,040.00
WFA --- TREASURY MONEY MARKET
11/01/21
---
11/30/21
---
0.01%
29 1
---
---
---
100.84
100.84
100.84
WFA --- CASH
11/01/21
---
11/30/21
---
---
29 1
---
---
---
2,238.05
2,238.05
2,238.05
TOTAL - CEMETERY ENDOWMENT FUND
322,338.89
K
322,338.89
315,378.89
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
REMAINING LIFE
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
IN MONTHS
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
PEPPER AVENUE EXTENSION - RESTRICTED FUNDS
LINE OF CREDIT - WELLS FARGO
06/01/20
---
12/31/21
---
---
578
19 1
---
---
160,190.40
160,190.40
160,190.40
COLLATERAL CERTIFICATE OF DEPOSIT - WELLS FARGO
07/12/21
---
07/12/22
---
0.01%
365
12 7
---
---
163,917.08
163,917.08
163,917.08
TOTAL - PEPPER AVENUE EXTENSION RESTRICTED ACCOUNTS
324,107.48
L
324,107.48
324,107.48
SCHEDULE OF INVESTMENTS
OTHER BANK ACCOUNTS - CASH SWEEP ACCOUNTS - REF: J
NOVEMBER 2021
NOVEMBER 2021
SCHEDULE OF INVESTMENTS
PEPPER AVENUE EXTENSION (RESTRICTED FUNDS) - REF: L
NOVEMBER 2021
SCHEDULE OF INVESTMENTS
CEMETERY ENDOWMENT FUND - REF: K
City of Rialto
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
REMAINING LIFE
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
IN MONTHS
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
WELLS FARGO ADVISORS - ECONOMIC RESERVE
87019RY26 - SWEDBANK CP
08/19/21
---
11/02/21
---
0.09%
75 2
---
---
---
---
---
---
02665JY38 - AMERICAN HONDA FINANCE CP
08/13/21
---
11/03/21
---
0.12%
82 3
---
---
---
---
---
---
87019RYF7 - SWEDBANK CP
08/13/21
---
11/15/21
---
0.09%
94 3
---
---
---
---
---
---
53943RYN3 - LLOYDS BANK PLD CP
08/19/21
---
11/22/21
---
0.08%
95 3
---
---
---
---
---
---
66522UAA1 - NORTHERN ILLINOIS GAS CO CP
11/18/21
---
01/10/22
---
0.14%
53 2
1 P1
A2
7,793,393.38
7,795,000.00
7,793,596.90
02665KB30 - AMERICAN HONDA FINANCE CP
11/08/21
---
02/03/22
---
0.16%
87 3
2 P2
A2
14,994,199.96
15,000,000.00
14,994,750.00
62479MBN2 - MUFG BANK LTD/NY CP
11/23/21
---
02/22/22
---
0.15%
91 3
3 P1
A1
2,998,862.49
3,000,000.00
2,998,680.00
WFA --- TREASURY MONEY MARKET
11/01/21
---
11/30/21
---
0.01%
29 1
---
---
---
3,828.60
3,828.60
3,828.60
WFA --- CASH
11/01/21
---
11/30/21
---
---
29 1
---
---
---
1,147.08
1,147.08
1,147.08
SUBTOTAL
25,791,431.51
25,799,975.68
25,792,002.58
TOTAL - GENERAL FUND ECONOMIC RESERVE
25,791,431.51
M
25,799,975.68
25,792,002.58
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
REMAINING LIFE
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
IN MONTHS
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
HIGHMARK CAPITAL MANAGEMENT
PARS OPEB TRUST PROGRAM
11/01/21
---
11/01/21
---
---
0 0
---
---
---
16,929,201.40
16,929,201.40
21,002,143.87
TRUST FEES
11/01/21
---
11/30/21
---
---
29 1
---
---
---
(7,739.72)
(7,739.72)
(7,739.72)
INTEREST EARNED
11/01/21
---
11/30/21
---
---
29 1
---
---
---
107,140.01
107,140.01
107,140.01
UNREALIZED GAIN/LOSS
11/01/21
---
11/30/21
---
---
29 1
---
---
---
0.00 0.00
(444,017.37)
TOTAL - PUBLIC AGENCY RETIREMENT (RESTRICTED FUNDS)
17,028,601.69
N
17,028,601.69
20,657,526.79
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
REMAINING LIFE
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
IN MONTHS
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
CASH WITH FISCAL AGENT
1 - 2007 COPS
11/01/21
---
11/30/21
---
---
29 1
---
---
---
0.00 0.00
0.00 2 - 2008 SERIES B
11/01/21
---
11/30/21
---
---
29 1
---
---
---
2,960,053.42
2,960,053.42
2,960,053.42
3 - 2008 SERIES C
11/01/21
---
11/30/21
---
---
29 1
---
---
---
1,858,409.12
1,858,409.12
1,858,409.12
4 - 2014 SERIES A
11/01/21
---
11/30/21
---
---
29 1
---
---
---
3.90 3.90
3.90 5 - 2015 SERIES A & B
11/01/21
---
11/30/21
---
---
29 1
---
---
---
5.44 5.44
5.44 6 - 2015 SERIES C
11/01/21
---
11/30/21
---
---
29 1
---
---
---
2.10 2.10
2.10 7 - 2018 REFUNDING 2008 SERIES A
11/01/21
---
11/30/21
---
---
29 1
---
---
---
3.48 3.48
3.48 8 - 2016 ELM PARK
11/01/21
---
11/30/21
---
---
29 1
---
---
---
453,509.75
453,509.75
453,509.75
TOTAL - CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES)
5,271,987.21
O
5,271,987.21
5,271,987.21
PUBLIC AGENCY RETIREMENT - OPEB (RESTRICTED FUNDS) - REF: N CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES) - REF: O NOVEMBER 2021
SCHEDULE OF INVESTMENTS
GENERAL FUND ECONOMIC RESERVE (RESTRICTED FUNDS) - REF: M NOVEMBER 2021
SCHEDULE OF INVESTMENTS
NOVEMBER 2021
SCHEDULE OF INVESTMENTS
City of Rialto
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
REMAINING LIFE
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
IN MONTHS
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
CASH WITH FISCAL AGENTS - RUA (CONCESSION AGREEMENT)
1 - RIALTO TRUST AND RUA LOCKBOX ACCOUNTS
11/01/21
---
11/30/21
---
---
29 1
---
---
---
5,438,916.92
5,438,916.92
5,438,916.92
2 - WASTEWATER ACCOUNTS
11/01/21
---
11/30/21
---
---
29 1
---
---
---
10,109,994.34
10,109,994.34
10,078,131.98
3 - WATER ACCOUNTS
11/01/21
---
11/30/21
---
---
29 1
---
---
---
7,766,897.48
7,766,897.48
7,750,501.58
TOTAL - CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT) 23,315,808.74
P
23,315,808.74
23,267,550.48
NOTE. P2. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 11/30/2021, INCLUDES CASH AND INVESTMENTS OF $254,867.38 AND $6,144,000.00 RESPECTIVELY.
NOTE. P3. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 11/30/2021, INCLUDES CASH AND INVESTMENTS OF $306,583.44 AND $3,348,000.00 RESPECTIVELY.
REF
215,295,440.65
G
7,061,896.74
H
23,361,802.43
I
139,881.81
J
322,338.89
K
324,107.48
L
25,791,431.51
M
17,028,601.69
N
5,271,987.21
O
23,315,808.74
P
317,913,297.15
(G-P)
OTHER BANK ACCOUNTS / STAGE COACH ACCOUNTS
PUBLIC AGENCY RETIREMENT - OPEB (RESTRICTED FUNDS)
CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES)
CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT)
TOTAL - RECAP INVESTMENTS & CASH W/FISCAL AGENTS
PEPPER AVENUE EXTENSION - LINE OF CREDIT & CD (RESTRICTED FUNDS)
GENERAL FUND ECONOMIC RESERVE (RESTRICTED FUNDS)
CEMETERY ENDOWMENT FUND / INVESTMENTS
RECAP - INVESTMENTS & CASH W/FISCAL AGENTS
GENERAL POOLED FUNDS / INVESTMENTS
RUA / INVESTMENTS & STAGE COACH SWEEP ACCOUNT
RSA / STAGE COACH SWEEP ACCOUNT
NOVEMBER 2021
SCHEDULE OF INVESTMENTS
CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT) - REF: P
INTEREST & GAIN/(LOSS) SUMMARY
07/31/21 - 10/31/21
11/30/2021
TOTAL
TO DATE
374,490.42
105,244.63
479,735.05
335.21
58.06 393.27
56,400.65
(61,541.73)
(5,141.08)
3.23 1.11
4.34 (6,527.18)
1,881.50
(4,645.68)
7.01 2,161.97
2,168.98
5.55 1.41
6.96 9,769.96
10.98 9,780.94
378,546.56
107,140.01
485,686.57
107.73
23.13 130.86
335.95
219.90
555.85
TOTAL
813,475.09
155,200.97
968,676.06
PUBLIC AGENCY RETIREMENT OPEB (RESTRICTED FUNDS)
MONTHLY DETAIL
UNREALIZED
GAIN(LOSS)
INTEREST
EXPENSES
TOTAL TO DATE
07/31/21
72,159.51
16,209.55
7,798.09
80,570.97
08/31/21
78,376.25
226,649.13
7,803.57
297,221.81
09/30/21
(701,832.17)
32,470.05
7,828.42
(677,190.54)
10/31/21
556,461.80
103,217.83
7,658.23
652,021.40
11/30/21
(444,017.37)
107,140.01
7,739.72
(344,617.08)
12/31/21
0.00 01/31/22
0.00 02/28/22
0.00 03/31/22
0.00 04/30/22
0.00 05/31/22
0.00 06/30/22
0.00 TOTAL- PUBLIC AGENCY RETIREMENT OPEB
(RESTRICTED FUNDS)
(438,851.98)
485,686.57
38,828.03
8,006.56
City of Rialto
INVESTMENT INTEREST & GAINS/(LOSS) SCHEDULE
NOVEMBER 2021
GENERAL POOLED FUNDS / INVESTMENTS
RSA BANK SWEEP ACCOUNT INTEREST
GENERAL FUND ECONOMIC RESERVE (RESTRICTED FUNDS)
PUBLIC AGENCY RETIREMENT OPEB (RESTRICTED FUNDS)
CASH W/FISCAL AGENTS - (RESTRICTED BOND ISSUES)
CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT)
RUA PRE-EXISTING / INVESTMENTS
OTHER BANK ACCOUNTS
ESCROW ACCOUNTS
CEMETERY ENDOWMENT (RESTRICTED ACCOUNTS)
PEPPER AVENUE EXTENSION (RESTRICTED ACCOUNTS)
City of Rialto
TREASURER’S REPORT
-
GLOSSARY OF TERMS
A
ccrue
d
I
n
terest
‐
T
h
e
i
n
ter
e
s
t
tha
t
ha
s
acc
u
m
u
lated
o
n
a
b
o
n
d
si
n
ce
th
e
last
i
n
te
r
e
st
pay
me
n
t
u
p
to
,
bu
t
n
o
t
i
n
cl
ud
i
n
g,
th
e
se
ttl
e
me
n
t
dat
e
.
A
c
crued
i
n
terest
occ
u
r
s
a
s
a r
e
s
u
lt
o
f
th
e
d
i
ff
e
r
e
n
ce
in
t
i
m
i
n
g
o
f cash
flo
w
s
an
d
th
e
me
a
s
u
r
em
e
n
t
o
f
th
es
e
cash
fl
o
ws.
Call Date
-
Th
e
call date
is the
date
on which a bond can be redeemed before maturity. If the issuer feels there is a benefit to refinancing the issue, the bond may be
redeemed on the
call date
at par or at a small premium to par.
Coupon Rate
-
A coupon rate is the yield paid by a
fixed
-
income
security; a fixed
-
income security's coupon rate is
simply just the annual coupon
payments paid by the issuer relative to the bond's face or par value.
Credit Rating
-
The
credit rating
is a financial indicator to potential
investors
of debt securities such as bonds. These are assigned by
credit
rating
age
ncies such as Moody's, Standard & Poor's, and Fitch, which publish code designations (such as AAA, B, CC) to express their as sessment of
the risk quality of a
bond.
O
r
igi
n
a
l
Cost
/Amount Invested
‐
T
h
e
origi
n
al
c
o
s
t
o
f
a
n
a
s
s
e
t
tak
e
s
i
n
to
co
n
s
i
d
eration
all
o
f
th
e
costs
tha
t
c
a
n
b
e
attribut
e
d
to
its
pur
c
h
a
s
e
an
d
to
putt
i
n
g
th
e
a
sse
t
to
u
se
.
Market Value
-
is the price an asset would fetch in the marketplace, or the value that the investment community gives to a particular equity
or
business.
Par
Val
u
e
‐
T
h
e
f
a
c
e
v
a
l
u
e
o
f a
bond
.
Par
v
a
l
u
e
is
im
p
orta
n
t
f
or
a
bon
d
o
r
fixe
d
‐
i
n
come
i
n
str
u
me
n
t
b
e
c
a
u
s
e
it
d
e
t
e
r
m
i
n
e
s
i
t
s
m
a
turity
v
a
l
u
e
a
s
w
e
ll
a
s
th
e
d
ollar
v
a
l
u
e
o
f
co
upon pay
me
n
t
s
.
Realized Gain/
(
Loss
)
-
Realized gain/loss
is the cumulative amount of
realized gains
and
losses
resulting from the sale of securities. A
realized
loss
is the monetary value of a
loss
that results from a trade
StageCoach Sweep Account
–
A sweep account automatically transfers
cash funds into a safe but higher interest
-
earning investment option at the
close of each business day, e.g. into a money market fund.
Sweep accounts try to minimize idle cash drag by capitalizing on the immediate availability of higher
-
interest accounts.
City of Rialto
TREASURER’S REPORT
-
GLOSSARY OF TERMS
U
nr
ealiz
e
d
Gai
n
s
/
(L
o
ss)
‐
a
p
rofita
b
le/(l
o
si
n
g)
pos
i
t
i
o
n
tha
t
ha
s
y
e
t
to
b
e
cas
h
e
d
i
n
.
T
h
e
a
ct
ua
l
gai
n
/(lo
s
s
)
is
no
t
reali
z
e
d
unt
il
th
e
po
s
i
t
i
o
n
is
close
d
.
A
po
s
i
t
i
o
n
with
a
n
un
re
a
lized gain
m
a
y
e
v
e
n
t
ua
lly
turn
i
n
to
a
po
s
i
t
i
o
n
with
a
n
un
re
a
lized
l
o
ss
,
a
s
th
e
m
a
r
k
et
fl
u
ct
ua
t
e
s
an
d
v
i
c
e
v
e
r
s
a.
Yield
‐
T
h
e
i
n
co
m
e
return
o
n
a
n
i
n
ves
t
me
n
t.
T
h
i
s
r
e
fe
r
s
to
th
e
i
n
ter
e
st
o
r
d
i
v
i
d
e
nd
s
r
e
c
e
i
ve
d
fr
o
m
a
s
e
c
u
rity
an
d
is
ex
p
r
e
s
se
d
a
s
a
p
e
r
c
e
nta
ge
bas
e
d
o
n
th
e
i
n
ves
t
me
n
t
'
s
cost
and
its
current
m
a
r
k
et
v
a
l
u
e.