March 21, 2022
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…………………………………………………………………………………………. 234,782,564.12
64%
A,G
Rialto Successor Agency (RSA) + Cash Sweep Bank Account…………………………………………………………………………………................................ 7,547,023.48
2%
B,H
Rialto Utility Authority (RUA) Pre-existing Investments + Cash Sweep Bank Account……………………………………………………………………………………………. 24,996,361.91
7%
C,I
Other Bank Accounts + Cash Sweep Bank Accounts……………………………………………………………………………………………………………………............. 1,789,816.60
1%
D,J
Escrow Accounts……………………………………………………………………………………………………………………………................................................. 14,191,152.75
4%
E
Cemetery Endowment Fund (Restricted Accounts)…………………………………………………………………........................................................................... 408,956.21
0%
F,K
Pepper Avenue Extension (Restricted Accounts)………………………………………………………………….......................................................... 163,921.27
0%
L
General Fund Economic Reserve (Restricted Funds)……………………………………………………………………............................................... 25,776,726.53
7%
M
Public Agency Retirement Services - OPEB (Restricted Funds)…………………………………………………………………….................................. 27,790,819.37
8%
N
Cash with Fiscal Agents - (Restricted Bond Issues)…………………………………………………………………………...................................................... 8,542,846.36
2%
O
Cash with Fiscal Agents - RUA (Concession Agreement)………………………………………………………………….......................................................... 22,236,158.91
6%
P
TREASURER'S PORTFOLIO
368,226,347.51
100%
TREASURER'S MONTHLY REPORT - FEBRUARY 2022
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
JANUARY 2022
FEBRUARY 2022
ACTIVE ACCOUNTS
BALANCE
RECEIPTS
DISBURSEMENTS
BALANCE
REF
GENERAL BANK ACCOUNT **
(960,772.12)
24,622,743.58
24,266,872.25
(604,900.79)
A
RSA BANK ACCOUNT **
-
291,327.44
269,847.50
21,479.94
B
RUA BANK ACCOUNT **
(35,210.35)
78,114.11
45,416.76
(2,513.00)
C
SPORTS CENTER/POOL **
-
12,868.84
12,868.84
-
AMBULANCE LOCKBOX
56,419.35
251,820.16
219,588.88
88,650.63
FLEXIBLE BENEFIT**
-
0.29 0.29
-
ALARM LOCKBOX
29,238.76
6,229.28
31,928.66
3,539.38
BANK CARD
1,092.01
-
-
1,092.01
PAYROLL CLEARING
17,905.94
4,398,424.90
4,401,347.73
14,983.11
LIABILITY ACCT./CARL WARREN & CO.
2,173.45
-
-
2,173.45
LIABILITY ACCT./GEORGE HILLS
99,985.00
80,015.00
85,857.84
94,142.16
PEPPER AVENUE
-
-
-
-
WORKERS COMP/LWP CLAIMS SOLUTIONS
75,095.74
40,393.50
110,097.10
5,392.14
PROPERTY EVIDENCE MONIES
1,382,207.11
25,117.00
11.08 1,407,313.03
OTHER BANK ACCOUNTS
1,664,117.36
4,814,868.97
4,861,700.42
1,617,285.91
D
ENERGY CONSERVATION PROJECT
84,786.55
-
-
84,786.55
AYALA @ 210 PARTNERS LLC
310,687.41
9.54 -
310,696.95
LEWIS HILLWOOD
2,750,193.76
495.88
2,733.80
2,747,955.84
ALDER AVENUE
3,273,659.89
589.19
10,746.68
3,263,502.40
LAUREL/WALNUT/LOCUST
2,984,349.40
537.02
10,459.09
2,974,427.33
SUB ACCOUNT A
4,817,450.58
868.09
8,534.99
4,809,783.68
ESCROW ACCOUNTS
14,221,127.59
2,499.72
32,474.56
14,191,152.75
E
CEMETERY ENDOWMENT FUND
79,373.86
7,243.39
-
86,617.25
RESTRICTED ACCOUNTS
79,373.86
7,243.39
-
86,617.25
F
TOTAL - ACTIVE ACCOUNTS
14,968,636.34
15,309,122.06
(A-F)
Note (**) All cash is swept in Government Money Market Fund Sweep Accounts with Wells Fargo.
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
02/01/22
---
02/01/22
---
---
0 1
---
---
---
57,565,490.79
57,565,490.79
57,565,490.79
SHARES PURCHASED
02/01/22
---
02/28/22
---
---
30 1
---
---
---
5,329,275.99
5,329,275.99
5,329,275.99
SHARES REDEEMED
02/01/22
---
02/28/22
---
---
30 1
---
---
---
(9,588,433.70)
(9,588,433.70)
(9,588,433.70)
INTEREST EARNED - GENERAL FUND ACCOUNT
02/01/22
---
02/28/22
---
0.01%
27 1
---
---
---
441.35
441.35
441.35
CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) - GENERAL 02/01/22
---
02/28/22
---
---
27 1
---
---
---
104,811.92
104,811.92
104,811.92
SUBTOTAL
53,411,586.35
53,411,586.35
53,411,586.35
PACIFIC PREMIER BANK #0314
POOLED FUNDS - #0314
02/01/22
---
02/01/22
---
0.10%
0 0
---
---
---
5,197,294.72
5,197,294.72
5,197,294.72
BANKING FEE
02/01/22
---
02/28/22
---
---
27 1
---
---
---
(2.00)
(2.00)
(2.00)
INTEREST EARNED #0314
02/01/22
---
02/28/22
---
---
27 1
---
---
---
279.09
279.09
279.09
SUBTOTAL
5,197,571.81
5,197,571.81
5,197,571.81
PACIFIC PREMIER BANK #7667
POOLED FUNDS - #7667
02/01/22
---
02/01/22
---
0.10%
0 0
---
---
---
3,531,209.01
3,531,209.01
3,531,209.01
BANKING FEE
02/01/22
---
02/28/22
---
---
27 1
---
---
---
(32.00)
(32.00)
(32.00)
INTEREST EARNED #7667
02/01/22
---
02/28/22
---
---
27 1
---
---
---
189.63
189.63
189.63
SUBTOTAL
3,531,366.64
3,531,366.64
3,531,366.64
LAIF - CALIFORNIA STATE POOL
POOLED FUNDS - LAIF
02/01/22
---
02/28/22
---
0.27%
27 1
---
---
---
20,227,042.18
20,227,042.18
20,227,042.18
SUBTOTAL
20,227,042.18
20,227,042.18
20,227,042.18
JP MORGAN ADVISORS - GENERAL
3133ENLD0 - FEDERAL FARM CR BKS
01/11/22
01/26/26
1.53%
1.54%
1476
49 47
2,000,000.00
2,000,000.00
1,971,303.58
3133ENNE6 - FEDERAL FARM CREDIT BANK
02/03/22
01/26/24
01/26/26
1.53%
1.55%
1453
48 47
AAA
AA+
745,000.00
745,000.00
740,324.78
3130AQJK0 - FEDERAL HOME LOAN BANK
01/05/22
04/25/24
1.00%
1.00%
841
28 26
AAA
AA+
2,000,000.00
2,000,000.00
1,980,541.64
3134GXGQ1 - FREDDIE MAC
12/07/21
03/15/22
12/15/22
0.20%
0.20%
373
12 10
AAA
N/A
1,248,601.53
1,250,000.00
1,241,829.63
78015K7L2 - ROYAL BANK OF CANADA
01/04/22
01/19/24
0.43%
0.43%
745
25 23
A1
A
2,006,072.53
2,026,000.00
1,969,388.62
83369NHL7 - SOCIETE GENERALE
01/18/22
01/20/27
1.95%
1.96%
1828
60 59
A1
A
2,000,000.00
2,000,000.00
1,977,431.18
JP MORGAN ADVISORS ---TREASURY MONEY MARKET
12/01/21
---
12/31/21
---
0.01%
30 1
---
---
---
2,541.94
2,541.94
2,541.94
JP MORGAN ADVISORS --- CASH
12/01/21
---
12/31/21
---
---
30 1
---
---
---
0.00 0.00
0.00 SUBTOTAL
10,002,216.00
10,023,541.94
9,883,361.37
WELLS FARGO ADVISORS - CUSTODIAL
2254EBBU4 - CREDIT SUISSE NEW YORK CP
06/03/21
---
02/28/22
---
0.16%
270
9 ---
---
---
---
---
---
94974BFC9 - WELLS FARGO BANK SENIOR NOTES
01/29/19
---
03/08/22
3.50%
3.49%
1134
37 0
A1
BBB+
5,044,300.00
5,000,000.00
5,002,100.00
38150AEJ0 - GOLDMAN SACHS GRP INC MTN CALLABLE
11/20/20
02/24/22
11/25/22
0.40%
0.40%
735
24 9
A2
BBB+
7,497,500.00
7,500,000.00
7,444,275.00
94973VBA4 - WELLPOINT INC SR UNSECURED
07/13/21
---
01/15/23
3.30%
3.25%
551
18 11
BAA2
A
1,566,150.00
1,500,000.00
1,522,845.00
94974BFN5 -WELLS FARGO & CO SUBORDINATED
06/03/21
---
08/15/23
4.13%
3.99%
803
26 18
A3
BBB
5,519,832.00
5,100,000.00
5,260,752.00
38150AEF8 - GOLDMAN SACH GRP MTN CALLABLE
11/20/20
05/24/22
11/24/23
0.60%
0.61%
1099
36 21
A2
BBB+
3,000,000.00
3,000,000.00
2,925,270.00
17329F6E9 - CITIGROUP GLOBAL MARKETS MTN CALLABLE
03/30/21
03/31/22
03/31/24
0.70%
0.72%
1097
36 25
A3
BBB+
8,250,000.00
8,250,000.00
8,006,790.00
02665WDS7 - AMERICAN HONDA FINANCE MTN
02/25/21
---
07/12/24
0.55%
0.56%
1233
41 28
A3
A-
3,827,410.50
3,825,000.00
3,702,676.50
45950VQE9 - INTL FINANCE CORP MTN
09/08/21
---
09/10/24
0.43%
0.44%
1098
36 30
AAA
AAA
5,000,000.00
5,000,000.00
4,838,500.00
38150AFC4 - GOLDMAN SACHS GRP INC MTN CALLABLE
03/26/21
03/20/22
09/30/24
1.00%
1.03%
1284
42 31
A2
BBB+
4,500,000.00
4,500,000.00
4,338,135.00
61761JVL0 - MORGAN STANLEY MTN SR UNSECURED
07/15/21
---
10/23/24
3.70%
3.57%
1196
39 32
A1
BBB+
5,048,828.40
4,620,000.00
4,775,139.60
38150AFM2 - GOLDMAN SACHS GRP INC MTN CALLABLE
05/10/21
05/14/22
11/12/24
1.00%
1.04%
1282
42 32
A2
BBB+
10,000,000.00
10,000,000.00
9,578,000.00
037833AZ3 - APPLE INC SR UNSECURED
02/04/21
---
02/09/25
2.50%
2.46%
1466
48 35
AAA
AA+
2,157,500.00
2,000,000.00
2,032,180.00
06048WK66 - BANK OF AMERICA CORP MULTISTEP UP MTN CALLABLE 02/04/21
03/23/22
12/23/25
0.65%
0.69%
1783
59 46
A2
A-
1,994,000.00
2,000,000.00
1,866,820.00
17290AEA4 - CITIGROUP INC. MTN CALLABLE
10/15/21
10/19/24
10/19/26
1.45%
1.49%
1830
60 56
A3
BBB+
5,000,000.00
5,000,000.00
4,836,700.00
48128G5Y2 - JPMORGAN CHASE & CO MTN CALLABLE
01/27/22
01/31/24
01/29/27
2.10%
2.23%
1828
60 59
A2
A-
3,000,000.00
3,000,000.00
2,817,270.00
3815AL29 - GOLDMAN SACHS GRP INC MTN CALLABLE
02/28/22
03/02/23
03/02/27
3.00%
3.00%
1828
60 60
A2
BBB+
5,000,000.00
5,000,000.00
5,000,000.00
3135G05G4 - FEDERAL NATIONAL MTG ASSN NOTES
12/02/21
---
07/10/23
0.25%
0.25%
585
19 16
AAA
AA+
3,896,901.50
3,910,000.00
3,855,807.40
3130ANZ60 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/08/21
03/27/22
06/27/25
0.40%
0.41%
1388
46 40
AAA
AA+
1,500,000.00
1,500,000.00
1,453,140.00
3130ALZA5 - FEDERAL HOME LOAN BANK MULTI STEP COUPON BONDS CALLABLE 04/13/21
04/29/22
04/29/26
0.50%
0.51%
1842
61 50
AAA
AA+
6,000,000.00
6,000,000.00
5,876,520.00
NOTE. G (CONTINUED TO NEXT PAGE)
City of Rialto
SCHEDULE OF INVESTMENTS
GENERAL POOLED FUNDS / INVESTMENTS - REF: G
FEBRUARY 2022
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
FEBRUARY 2022
3130AMB76 - FEDERAL HOME LOAN BANK BONDS CALLABLE
05/18/21
05/18/22
05/18/26
1.25%
1.27%
1826
60 51
AAA
AA+
1,108,800.00
1,100,000.00
1,076,163.00
3130AMKN1 - FEDERAL HOME LOAN MULTISTEP UP COUPON BONDS CALLABLE 05/18/21
02/27/22
05/27/26
0.50%
0.50%
1835
60 51
AAA
AA+
8,900,000.00
8,900,000.00
8,738,643.00
3130ANUT5 - FEDERAL HOME LOAN BANK MULTI STEP COUPON BONDS CALLABLE 08/30/21
03/16/22
09/16/26
0.50%
0.51%
1843
61 55
AAA
AA+
10,000,000.00
10,000,000.00
9,726,400.00
3130ANZ52 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/08/21
03/28/22
09/28/26
0.50%
0.51%
1846
61 55
AAA
AA+
2,500,000.00
2,500,000.00
2,434,225.00
3130ANXC9 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/02/21
03/29/22
09/29/26
0.60%
0.62%
1853
61 55
AAA
AA+
5,000,000.00
5,000,000.00
4,806,050.00
78658RFR7 - SAFRA NATIONAL BANK CD
10/12/21
---
10/19/22
0.15%
0.15%
372
12 8
N.A.
N.A.
249,000.00
249,000.00
248,375.01
99000FGR3 - WORLD'S FOREMOST BANK CD
09/20/21
---
05/08/23
2.45%
2.41%
595
20 14
N.A.
N.A.
206,936.00
200,000.00
202,854.00
99000QMY7 - COMENITY BANK CD
09/23/21
---
08/15/23
2.15%
2.12%
691
23 18
N.A.
N.A.
206,372.00
200,000.00
202,034.00
05580AD92 - BMW BK N AMERICA CD
09/20/21
---
09/25/23
0.35%
0.35%
735
24 19
N.A.
N.A.
249,000.00
249,000.00
245,401.95
87165HD64 - SYNCHRONY BANK CD
09/20/21
---
09/25/23
0.40%
0.40%
735
24 19
N.A.
N.A.
249,000.00
249,000.00
245,593.68
38149MA52 - GOLDMAN SACHS BK USA CD
09/20/21
---
09/29/23
0.35%
0.35%
739
24 19
N.A.
N.A.
249,000.00
249,000.00
245,349.66
856285XP1 - STATE BANK OF INDIA CD
09/20/21
---
09/29/23
0.40%
0.40%
739
24 19
N.A.
N.A.
249,000.00
249,000.00
245,543.88
947547NE1 - WEBBANK CD
09/20/21
---
09/29/23
0.30%
0.30%
739
24 19
N.A.
N.A.
249,000.00
249,000.00
245,128.05
538036SD7 - LIVE OAK BANKING CO CD
09/21/21
---
10/02/23
0.25%
0.25%
741
24 19
N.A.
N.A.
249,000.00
249,000.00
244,908.93
649447UA5 - NEW YORK CMNTY BK CD
10/05/21
---
10/16/23
0.30%
0.30%
741
24 20
N.A.
N.A.
250,000.00
250,000.00
245,902.50
45581ECS8 - INDUSTRIAL & COM BK CD
09/21/21
---
10/18/23
0.35%
0.35%
757
25 20
N.A.
N.A.
249,000.00
249,000.00
245,093.19
06251A2J8 - BANK HAPOALIM BM NY CD
09/28/21
---
10/26/23
0.25%
0.25%
758
25 20
N.A.
N.A.
248,253.00
249,000.00
244,577.76
88241TFP6 - TEXAS EXCHANGE BK SSB CD
09/22/21
---
12/18/23
0.35%
0.35%
817
27 22
N.A.
N.A.
248,000.00
248,000.00
243,255.76
61765QQ28 - MORGAN STANLEY BK NA CD
10/01/21
---
01/08/24
0.25%
0.25%
829
27 22
N.A.
N.A.
250,000.00
250,000.00
245,002.50
47804GGX5 - JOHN MARSHALL BANK CD
09/29/21
---
06/17/24
0.25%
0.25%
992
33 28
N.A.
N.A.
243,020.40
245,000.00
237,407.45
29278TPT1 - ENERBANK USA CD
10/12/21
---
06/26/24
0.50%
0.51%
988
32 28
N.A.
N.A.
210,578.00
211,000.00
205,562.53
89235MLG4 - TOYOTA FINL SGS BK CD
09/23/21
---
08/12/24
0.60%
0.61%
1054
35 29
N.A.
N.A.
248,927.79
249,000.00
242,645.52
795451AW3 - SALLIE MAE BANK/SALT CD
09/20/21
---
09/23/24
0.70%
0.71%
1099
36 31
N.A.
N.A.
249,000.00
249,000.00
242,824.80
90348JT75 - UBS BANK USA CD
09/28/21
---
10/07/24
0.65%
0.66%
1105
36 31
N.A.
N.A.
249,000.00
249,000.00
242,336.76
59013KNU6 - MERRICK BANK CD
10/06/21
---
10/21/24
0.55%
0.56%
1111
37 32
N.A.
N.A.
249,000.00
249,000.00
241,534.98
48128WBQ7 - JP MORGAN CHASE BK NA CD
10/13/21
04/29/22
10/29/26
0.55%
0.52%
1842
61 56
N.A.
N.A.
125,000.00
125,000.00
120,133.75
53944VAS8 - LLOYDS BANK PLC SR NOTE
12/09/19
---
08/14/22
2.25%
2.23%
979
32 5
A1
A+
2,009,300.00
2,000,000.00
2,012,020.00
13605WQ79 - CANADIAN IMPERIAL BK COMM MTN CALLABLE
12/28/20
12/22/22
06/22/24
0.55%
0.57%
1272
42 28
A2
A-
3,000,000.00
3,000,000.00
2,878,470.00
459056HV2 - INTL BK RECON & DEVELOP SR UNSECURED
09/07/21
---
08/28/24
1.50%
1.50%
1086
36 30
AAA
AAA
1,031,750.00
1,000,000.00
997,380.00
89114TDD1 - TORONTO DOMINION BANK MTN CALLABLE
03/09/21
03/11/22
09/11/24
0.70%
0.72%
1282
42 30
A1
A
7,000,000.00
7,000,000.00
6,772,010.00
89114TF49 - TORONTO DOMINION BANK MTN CALLABLE
03/20/21
04/01/22
04/01/25
1.00%
1.03%
1473
48 37
A1
A
5,000,000.00
5,000,000.00
4,827,500.00
06747PKV0 - BARCLAYS BANK PLC - MTN CALLABLE
06/08/20
04/08/23
04/08/25
3.25%
3.25%
0 37
A1
A
5,136,480.00
4,920,000.00
4,912,078.80
WFA ---TREASURY MONEY MARKET
02/01/22
---
02/28/22
---
0.01%
27 1
---
---
---
2,746.64
2,746.64
2,746.64
WFA --- CASH
02/01/22
---
02/28/22
---
---
27 1
---
---
---
(449,904.30)
(449,904.30)
(449,904.30)
SUBTOTAL
143,017,681.93
141,643,842.34
138,748,169.30
TOTAL - GENERAL POOLED FUNDS / INVESTMENTS
235,387,464.91
G
234,034,951.26
230,999,097.65
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 **
02/01/22
---
02/01/22
---
---
0 0
---
---
---
7,263,064.69
7,263,064.69
7,263,064.69
SHARES PURCHASED
02/01/22
---
02/28/22
---
---
27 1
---
---
---
263,959.40
263,959.40
263,959.40
SHARES REDEEMED
02/01/22
---
02/28/22
---
---
27 1
---
---
---
(1,538.74)
(1,538.74)
(1,538.74)
CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) - RSA ACCOUNT ** 02/01/22
---
02/28/22
---
---
27 1
---
---
---
0.75 0.75
0.75 INTEREST EARNED - WELLS FARGO
02/01/22
---
02/28/22
----
0.01%
27 1
---
---
---
57.44 57.44
57.44 TOTAL - RSA INVESTMENTS
7,525,543.54
H
7,525,543.54
7,525,543.54
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 **
02/01/22
---
02/01/22
---
---
0 0
---
---
---
6,895,963.86
6,895,963.86
6,895,963.86
SHARES REDEEMED
02/01/22
---
02/28/22
---
---
27 1
---
---
---
(72,217.43)
(72,217.43)
(72,217.43)
CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) - RUA ACCOUNT ** 02/01/22
---
02/28/22
---
---
27 1
---
---
---
(6,341.32)
(6,341.32)
(6,341.32)
INTEREST EARNED - WELLS FARGO
02/01/22
---
02/28/22
---
0.01%
27 1
---
---
---
52.53 52.53
52.53 SUBTOTAL
6,817,457.64
6,817,457.64
6,817,457.64
LAIF - CALIFORNIA STATE POOL
POOLED FUNDS - LAIF
02/01/22
---
02/28/22
---
0.27%
27 1
---
---
---
100,742.34
100,742.34
100,742.34
SUBTOTAL
100,742.34
100,742.34
100,742.34
WELLS FARGO ADVISORS - RUA
94974BFN5 - WELLS FARGO & CO SUBORDINATED
06/03/21
---
08/15/23
3.93%
3.99%
803
26 18
A3
BBB
974,088.00
900,000.00
928,368.00
38150AJK2 - GOLDMAN SACHS GRP INC MTN
11/22/21
05/24/22
11/24/23
1.00%
1.01%
732
24 21
A2
BBB+
3,900,000.00
3,900,000.00
3,826,173.00
02665WDS7 - AMERICAN HONDA FINANCE MTN
02/04/21
---
07/12/24
0.56%
0.57%
1254
41 28
A3
A-
3,477,991.50
3,475,000.00
3,363,869.50
3815AJ48 - GOLDMAN SACHS GRP INC MTN
10/27/21
10/29/22
10/29/24
1.15%
1.19%
1098
36 32
A2
BBB+
413,000.00
413,000.00
398,780.41
3130AMRA2 - FEDERAL HOME LOAN BANK
06/02/21
03/24/22
06/24/26
0.63%
0.64%
1848
61 52
AAA
AA+
1,000,000.00
1,000,000.00
969,820.00
83369MM74 - SOCIETE GENERALE BANK MTN
10/14/20
04/19/22
10/19/22
0.40%
0.40%
735
24 8
A1
A
2,000,000.00
2,000,000.00
1,980,260.00
13605WQ79 - CANADIAN IMPERIAL BANK COMM MTN CALLABLE
12/18/20
12/22/22
06/22/24
0.56%
0.57%
1282
42 28
A2
A-
270,000.00
270,000.00
259,062.30
89114TDD1 - TORONTO DOMINION BANK MTN CALLABLE
03/09/21
03/11/22
09/11/24
0.71%
0.72%
1282
42 30
A1
A
3,000,000.00
3,000,000.00
2,902,290.00
89114TF49 - TORONTO DOMINION BANK MTN CALLABLE
03/30/21
04/01/22
04/01/25
1.01%
1.03%
1463
48 37
A1
A
3,000,000.00
3,000,000.00
2,896,500.00
WFA --- TREASURY MONEY MARKET
02/01/22
---
02/28/22
---
0.01%
27 1
---
---
---
858.42
858.42
858.42
WFA --- CASH
02/01/22
---
02/28/22
---
---
27 1
---
---
---
44,737.01
44,737.01
44,737.01
SUBTOTAL
18,080,674.93
18,003,595.43
17,570,718.64
TOTAL - RUA PRE-EXISTING INVESTMENTS
24,998,874.91
I
24,921,795.41
24,488,918.62
SCHEDULE OF INVESTMENTS
RUA PRE-EXISTING / INVESTMENTS - REF: I
SCHEDULE OF INVESTMENTS
RSA STAGE COACH SWEEP ACCOUNT - REF: H
FEBRUARY 2022
FEBRUARY 2022
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 **
02/01/22
---
02/01/22
---
---
0 0
---
---
---
125,456.74
125,456.74
125,456.74
SHARES PURCHASED
02/01/22
---
02/28/22
---
---
27 1
---
---
---
12,224.16
12,224.16
12,224.16
INTEREST EARNED - SPORTS CENTER &POOL ACCOUNT **
02/01/22
---
02/28/22
---
0.01%
27 1
---
---
---
1.02 1.02
1.02 CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) - SPORTS CENTER &POOL ** 02/01/22
---
02/28/22
---
---
27 1
---
---
---
331.50
331.50
331.50
SUBTOTAL
138,013.42
138,013.42
138,013.42
WELLS FARGO CASH SWEEP ACCOUNT - FLEXIBLE BENEFIT
FLEXIBLE BENEFIT ACCOUNT**
02/01/22
---
02/01/22
---
---
0 0
---
---
---
34,517.01
34,517.01
34,517.01
INTEREST EARNED - FLEXIBLE BENEFIT ACCOUNT**
02/01/22
---
02/28/22
---
0.01%
27 1
---
---
---
0.26 0.26
0.26 SUBTOTAL
34,517.27
34,517.27
34,517.27
TOTAL - OTHER BANK ACCOUNTS INVESTMENTS
172,530.69
J
172,530.69
172,530.69
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.43%
1828
60 50
A2
BBB+
320,000.00
320,000.00
301,280.00
WFA --- TREASURY MONEY MARKET
02/01/22
---
02/28/22
---
0.01%
27 1
---
---
---
100.84
100.84
100.84
WFA --- CASH
02/01/22
---
02/28/22
---
---
27 1
---
---
---
2,238.12
2,238.12
2,238.12
TOTAL - CEMETERY ENDOWMENT FUND
322,338.96
K
322,338.96
303,618.96
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
COLLATERAL CERTIFICATE OF DEPOSIT - WELLS FARGO
07/12/21
---
07/12/22
---
0.01%
365
12 4
---
---
163,921.27
163,921.27
163,921.27
TOTAL - PEPPER AVENUE EXTENSION RESTRICTED ACCOUNTS
163,921.27
L
163,921.27
163,921.27
SCHEDULE OF INVESTMENTS
OTHER BANK ACCOUNTS - CASH SWEEP ACCOUNTS - REF: J
FEBRUARY 2022
FEBRUARY 2022
SCHEDULE OF INVESTMENTS
PEPPER AVENUE EXTENSION (RESTRICTED FUNDS) - REF: L
FEBRUARY 2022
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
02665KB30 - AMERICAN HONDA FINANCE CP
11/08/21
---
02/03/22
---
0.16%
87 3
---
---
---
---
---
---
62479MBN2 - MUFG BANK LTD/NY CP
11/23/21
---
02/22/22
---
0.15%
91 3
---
80285QDB3 - SANTANDER UK PLC CP
01/10/22
---
04/11/22
---
0.20%
91 3
1 P1
A1
7,796,056.63
7,800,000.00
7,797,114.00
2254EBE31 - CREDIT SUISSE NEW YORK
02/03/22
---
05/03/22
---
0.29%
89 3
2 P1
A1
14,989,060.34
15,000,000.00
14,990,400.00
74725AE3 - QUALCOMM INC
02/22/22
---
05/20/22
---
0.50%
87 3
3 A2
A
2,987,671.50
2,970,000.00
2,975,435.10
WFA --- TREASURY MONEY MARKET
02/01/22
---
02/28/22
---
0.01%
27 1
---
---
---
3,843.56
3,843.56
3,843.56
WFA --- CASH
02/01/22
---
02/28/22
---
---
27 1
---
---
---
94.50 94.50
94.50 SUBTOTAL
25,776,726.53
25,773,938.06
25,766,887.16
TOTAL - GENERAL FUND ECONOMIC RESERVE
25,776,726.53
M
25,773,938.06
25,766,887.16
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
02/01/22
---
02/01/22
---
---
0 0
---
---
---
17,791,736.67
17,791,736.67
20,110,874.27
TRANSFER TO GENERAL BANK ACCOUNT
02/01/22
---
02/28/22
---
---
27 1
---
---
---
(130,243.19)
(130,243.19)
(130,243.19)
TRUST FEES
02/01/22
---
02/28/22
---
---
27 1
---
---
---
(7,518.60)
(7,518.60)
(7,518.60)
TRANSFERS FROM GENERAL BANK ACCOUNT
02/01/22
---
02/28/22
---
---
27 1
---
---
---
10,000,000.00
10,000,000.00
10,000,000.00
INTEREST EARNED
02/01/22
---
02/28/22
---
---
27 1
---
---
---
136,844.49
136,844.49
136,844.49
UNREALIZED GAIN/LOSS
02/01/22
---
02/28/22
---
---
27 1
---
---
---
0.00 0.00
(486,312.38)
TOTAL - PUBLIC AGENCY RETIREMENT (RESTRICTED FUNDS)
27,790,819.37
N
27,790,819.37
29,623,644.59
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
02/01/22
---
02/28/22
---
---
27 1
---
---
---
0.00 0.00
0.00 2 - 2008 SERIES B
02/01/22
---
02/28/22
---
---
27 1
---
---
---
3,821,264.97
3,821,264.97
3,821,264.97
3 - 2008 SERIES C
02/01/22
---
02/28/22
---
---
27 1
---
---
---
2,493,111.30
2,493,111.30
2,493,111.30
4 - 2014 SERIES A
02/01/22
---
02/28/22
---
---
27 1
---
---
---
215,351.36
215,351.36
215,351.36
5 - 2015 SERIES A & B
02/01/22
---
02/28/22
---
---
27 1
---
---
---
679,746.89
679,746.89
679,746.89
6 - 2015 SERIES C
02/01/22
---
02/28/22
---
---
27 1
---
---
---
139,110.13
139,110.13
139,110.13
7 - 2018 REFUNDING 2008 SERIES A
02/01/22
---
02/28/22
---
---
27 1
---
---
---
651,627.09
651,627.09
651,627.09
8 - 2016 ELM PARK
02/01/22
---
02/28/22
---
---
27 1
---
---
---
542,634.62
542,634.62
542,634.62
TOTAL - CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES)
8,542,846.36
O
8,542,846.36
8,542,846.36
SCHEDULE OF INVESTMENTS
GENERAL FUND ECONOMIC RESERVE (RESTRICTED FUNDS) - REF: M FEBRUARY 2022
SCHEDULE OF INVESTMENTS
FEBRUARY 2022
SCHEDULE OF INVESTMENTS
PUBLIC AGENCY RETIREMENT - OPEB (RESTRICTED FUNDS) - REF: N CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES) - REF: O FEBRUARY 2022
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
02/01/22
---
02/28/22
---
---
27 1
---
---
---
5,184,475.41
5,184,475.41
5,184,475.41
2 - WASTEWATER ACCOUNTS
02/01/22
---
02/28/22
---
---
27 1
---
---
---
9,898,613.19
9,898,613.19
9,740,228.23
3 - WATER ACCOUNTS
02/01/22
---
02/28/22
---
---
27 1
---
---
---
7,153,070.31
7,153,070.31
7,067,700.03
TOTAL - CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT) 22,236,158.91
P
22,236,158.91
21,992,403.67
NOTE. P2. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 02/28/2022, INCLUDES CASH AND INVESTMENTS OF $273,080.05 AND $6,144,000.00 RESPECTIVELY.
NOTE. P3. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 02/28/2022, INCLUDES CASH AND INVESTMENTS OF $327,678.53 AND $3,348,000.00 RESPECTIVELY.
REF
235,387,464.91
G
7,525,543.54
H
24,998,874.91
I
172,530.69
J
322,338.96
K
163,921.27
L
25,776,726.53
M
27,790,819.37
N
8,542,846.36
O
22,236,158.91
P
352,917,225.45
(G-P)
SCHEDULE OF INVESTMENTS
CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT) - REF: P
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
FEBRUARY 2022
OTHER BANK ACCOUNTS / STAGE COACH ACCOUNTS
PUBLIC AGENCY RETIREMENT - OPEB (RESTRICTED FUNDS)
CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES)
INTEREST & GAIN/(LOSS) SUMMARY
07/31/21 - 01/31/22
02/28/22
TOTAL
TO DATE
374,098.01
161,253.08
535,351.09
574.10
57.44 631.54
21,094.38
18,562.77
39,657.15
7.68 1.28
8.96 (28,616.06)
(11,224.84)
(39,840.90)
2,173.07
2.01 2,175.08
9.74 1.41
11.15 11,402.53
(16,326.57)
(4,924.04)
1,526,064.02
136,844.49
1,662,908.51
176.40
28.72 205.12
1,044.59
28,288.22
29,332.81
TOTAL
1,908,028.46
317,488.01
2,225,516.47
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
(505,952.98)
989,309.18
7,636.54
475,719.66
01/31/22
(803,834.52)
51,068.27
7,739.67
(760,505.92)
02/28/22
(486,312.38)
136,844.49
7,518.60
(356,986.49)
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)
(2,234,951.86)
1,662,908.51
61,722.84
(633,766.19)
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
INVESTMENT INTEREST & GAINS/(LOSS) SCHEDULE
FEBRUARY 2022
GENERAL POOLED FUNDS / INVESTMENTS
RSA BANK SWEEP ACCOUNT INTEREST
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.