February 18, 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…………………………………………………………………………………………. 238,613,808.87
66%
A,G
Rialto Successor Agency (RSA) + Cash Sweep Bank Account…………………………………………………………………………………................................ 7,263,064.69
2%
B,H
Rialto Utility Authority (RUA) Pre-existing Investments + Cash Sweep Bank Account……………………………………………………………………………………………. 25,023,608.01
7%
C,I
Other Bank Accounts + Cash Sweep Bank Accounts……………………………………………………………………………………………………………………............. 1,824,091.11
1%
D,J
Escrow Accounts……………………………………………………………………………………………………………………………................................................. 14,221,127.59
4%
E
Cemetery Endowment Fund (Restricted Accounts)…………………………………………………………………........................................................................... 401,712.80
0%
F,K
Pepper Avenue Extension (Restricted Accounts)………………………………………………………………….......................................................... 324,110.26
0%
L
General Fund Economic Reserve (Restricted Funds)……………………………………………………………………............................................... 25,793,053.10
7%
M
Public Agency Retirement Services - OPEB (Restricted Funds)…………………………………………………………………….................................. 17,791,736.67
5%
N
Cash with Fiscal Agents - (Restricted Bond Issues)…………………………………………………………………………...................................................... 8,542,817.64
2%
O
Cash with Fiscal Agents - RUA (Concession Agreement)………………………………………………………………….......................................................... 21,815,186.00
6%
P
TREASURER'S PORTFOLIO
361,614,316.74
100%
TREASURER'S MONTHLY REPORT - JANUARY 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
DECEMBER 2021
JANUARY 2022
ACTIVE ACCOUNTS
BALANCE
RECEIPTS
DISBURSEMENTS
BALANCE
REF
GENERAL BANK ACCOUNT **
(225,019.77)
29,275,979.78
29,971,596.13
(920,636.12)
A
RSA BANK ACCOUNT **
(729.25)
3,237,667.18
3,236,937.93
-
B
RUA BANK ACCOUNT **
(1,617.98)
72,479.51
106,071.88
(35,210.35)
C
SPORTS CENTER/POOL **
-
10,129.99
10,129.99
-
AMBULANCE LOCKBOX
76,729.84
230,025.75
250,336.24
56,419.35
FLEXIBLE BENEFIT**
-
0.46 0.46
-
ALARM LOCKBOX
17,175.20
12,063.56
-
29,238.76
BANK CARD
1,390.01
-
298.00
1,092.01
PAYROLL CLEARING
22,071.53
5,365,492.14
5,369,657.73
17,905.94
LIABILITY ACCT./CARL WARREN & CO.
2,173.45
-
-
2,173.45
LIABILITY ACCT./GEORGE HILLS
-
100,000.00
15.00 99,985.00
PEPPER AVENUE
-
-
-
-
WORKERS COMP/LWP CLAIMS SOLUTIONS
24,577.70
213,245.84
162,727.80
75,095.74
PROPERTY EVIDENCE MONIES
1,486,315.92
2,522.50
106,631.31
1,382,207.11
OTHER BANK ACCOUNTS
1,630,433.65
5,933,480.24
5,899,796.53
1,664,117.36
D
ENERGY CONSERVATION PROJECT
84,786.55
-
-
84,786.55
AYALA @ 210 PARTNERS LLC
310,676.86
10.55 -
310,687.41
LEWIS HILLWOOD
2,752,592.55
334.67
2,733.46
2,750,193.76
ALDER AVENUE
3,276,515.26
398.37
3,253.74
3,273,659.89
LAUREL/WALNUT/LOCUST
2,986,952.42
363.17
2,966.19
2,984,349.40
SUB ACCOUNT A
4,821,652.48
586.24
4,788.14
4,817,450.58
ESCROW ACCOUNTS
14,233,176.12
1,693.00
13,741.53
14,221,127.59
E
CEMETERY ENDOWMENT FUND
79,371.84
2.02 -
79,373.86
RESTRICTED ACCOUNTS
79,371.84
2.02 -
79,373.86
F
TOTAL - ACTIVE ACCOUNTS
15,715,614.61
15,008,772.34
(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
01/01/22
---
01/01/22
---
---
0 1
---
---
---
44,065,046.25
44,065,046.25
44,065,046.25
SHARES PURCHASED
01/01/22
---
01/31/22
---
---
30 1
---
---
---
19,404,637.04
19,404,637.04
19,404,637.04
SHARES REDEEMED
01/01/22
---
01/31/22
---
---
30 1
---
---
---
(5,993,588.97)
(5,993,588.97)
(5,993,588.97)
INTEREST EARNED - GENERAL FUND ACCOUNT
01/01/22
---
01/31/22
---
0.01%
30 1
---
---
---
408.66
408.66
408.66
CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) - GENERAL 01/01/22
---
01/31/22
---
---
30 1
---
---
---
88,987.81
88,987.81
88,987.81
SUBTOTAL
57,565,490.79
57,565,490.79
57,565,490.79
PACIFIC PREMIER BANK #0314
POOLED FUNDS - #0314
01/01/22
---
01/01/22
---
0.10%
0 0
---
---
---
5,196,987.74
5,196,987.74
5,196,987.74
BANKING FEE
01/01/22
---
01/31/22
---
---
30 1
---
---
---
(2.00)
(2.00)
(2.00)
INTEREST EARNED #0314
01/01/22
---
01/31/22
---
---
30 1
---
---
---
308.98
308.98
308.98
SUBTOTAL
5,197,294.72
5,197,294.72
5,197,294.72
PACIFIC PREMIER BANK #7667
POOLED FUNDS - #7667
01/01/22
---
01/01/22
---
0.10%
0 0
---
---
---
3,531,031.08
3,531,031.08
3,531,031.08
BANKING FEE
01/01/22
---
01/31/22
---
---
30 1
---
---
---
(32.00)
(32.00)
(32.00)
INTEREST EARNED #7667
01/01/22
---
01/31/22
---
---
30 1
---
---
---
209.93
209.93
209.93
SUBTOTAL
3,531,209.01
3,531,209.01
3,531,209.01
LAIF - CALIFORNIA STATE POOL
POOLED FUNDS - LAIF
01/01/22
---
01/31/22
---
0.26%
30 1
---
---
---
20,215,404.28
20,215,404.28
20,215,404.28
INTEREST EARNED
01/01/22
---
01/31/22
---
---
30 1
---
---
---
11,637.90
11,637.90
11,637.90
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 48
2,000,000.00
2,000,000.00
1,988,411.20
3130AQJK0 - FEDERAL HOME LOAN BANK
01/05/22
04/25/24
1.00%
1.00%
841
28 27
AAA
AA+
2,000,000.00
2,000,000.00
1,990,539.40
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,244,470.98
78015K7L2 - ROYAL BANK OF CANADA
01/04/22
01/19/24
0.43%
0.43%
745
25 24
A1
A
2,005,271.51
2,026,000.00
1,983,903.49
83369NHL7 - SOCIETE GENERALE
01/18/22
01/20/27
1.95%
1.96%
1828
60 60
A1
A
2,000,000.00
2,000,000.00
1,988,863.24
JP MORGAN ADVISORS ---TREASURY MONEY MARKET
12/01/21
---
12/31/21
---
0.01%
30 1
---
---
---
747,402.96
747,402.96
747,402.96
JP MORGAN ADVISORS --- CASH
12/01/21
---
12/31/21
---
---
30 1
---
---
---
0.00 0.00
0.00 SUBTOTAL
10,001,276.00
10,023,402.96
9,943,591.27
WELLS FARGO ADVISORS - CUSTODIAL
46625HJD3 - JPMORGAN CHASE & CO SR UNSECURED
09/13/17
---
01/24/22
4.50%
4.48%
1594
52 ---
---
---
---
---
---
2254EBBU4 - CREDIT SUISSE NEW YORK CP
06/03/21
---
02/28/22
---
0.16%
270
9 1
P1
A1
4,544,540.00
4,550,000.00
4,549,545.00
94974BFC9 - WELLS FARGO BANK SENIOR NOTES
01/29/19
---
03/08/22
3.50%
3.48%
1134
37 1
A1
BBB+
5,044,300.00
5,000,000.00
5,014,800.00
38150AEJ0 - GOLDMAN SACHS GRP INC MTN CALLABLE
11/20/20
02/24/22
11/25/22
0.40%
0.40%
735
24 10
A2
BBB+
7,497,500.00
7,500,000.00
7,455,525.00
94973VBA4 - WELLPOINT INC SR UNSECURED
07/13/21
---
01/15/23
3.30%
3.23%
551
18 11
BAA2
A
1,566,150.00
1,500,000.00
1,530,795.00
94974BFN5 -WELLS FARGO & CO SUBORDINATED
06/03/21
---
08/15/23
4.13%
3.96%
803
26 18
A3
BBB
5,519,832.00
5,100,000.00
5,299,512.00
38150AEF8 - GOLDMAN SACH GRP MTN CALLABLE
11/20/20
05/24/22
11/24/23
0.60%
0.61%
1099
36 22
A2
BBB+
3,000,000.00
3,000,000.00
2,936,160.00
17329F6E9 - CITIGROUP GLOBAL MARKETS MTN CALLABLE
03/30/21
03/31/22
03/31/24
0.70%
0.71%
1097
36 26
A3
BBB+
8,250,000.00
8,250,000.00
8,044,327.50
02665WDS7 - AMERICAN HONDA FINANCE MTN
02/25/21
---
07/12/24
0.55%
0.56%
1233
41 29
A3
A-
3,827,410.50
3,825,000.00
3,724,058.25
45950VQE9 - INTL FINANCE CORP MTN
09/08/21
---
09/10/24
0.43%
0.44%
1098
36 31
AAA
AAA
5,000,000.00
5,000,000.00
4,867,700.00
38150AFC4 - GOLDMAN SACHS GRP INC MTN CALLABLE
03/26/21
03/20/22
09/30/24
1.00%
1.03%
1284
42 32
A2
BBB+
4,500,000.00
4,500,000.00
4,364,235.00
61761JVL0 - MORGAN STANLEY MTN SR UNSECURED
07/15/21
---
10/23/24
3.70%
3.53%
1196
39 33
A1
BBB+
5,048,828.40
4,620,000.00
4,829,609.40
38150AFM2 - GOLDMAN SACHS GRP INC MTN CALLABLE
05/10/21
05/14/22
11/12/24
1.00%
1.03%
1282
42 33
A2
BBB+
10,000,000.00
10,000,000.00
9,637,200.00
037833AZ3 - APPLE INC SR UNSECURED
02/04/21
---
02/09/25
2.50%
2.44%
1466
48 36
AAA
AA+
2,157,500.00
2,000,000.00
2,045,600.00
06048WK66 - BANK OF AMERICA CORP MULTISTEP UP MTN CALLABLE 02/04/21
03/23/22
12/23/25
0.65%
0.68%
1783
59 47
A2
A-
1,994,000.00
2,000,000.00
1,902,680.00
17290AEA4 - CITIGROUP INC. MTN CALLABLE
10/15/21
10/19/24
10/19/26
1.45%
1.49%
1830
60 57
A3
BBB+
5,000,000.00
5,000,000.00
4,861,550.00
48128G5Y2 - JPMORGAN CHASE & CO MTN CALLABLE
01/27/22
01/31/24
01/29/27
2.10%
2.09%
1828
60 60
A2
A-
3,000,000.00
3,000,000.00
3,000,360.00
3135G05G4 - FEDERAL NATIONAL MTG ASSN NOTES
12/02/21
---
07/10/23
0.25%
0.25%
585
19 17
AAA
AA+
3,896,901.50
3,910,000.00
3,866,990.00
3130ANZ60 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/08/21
03/27/22
06/27/25
0.40%
0.40%
1388
46 41
AAA
AA+
1,500,000.00
1,500,000.00
1,464,195.00
3130ALZA5 - FEDERAL HOME LOAN BANK MULTI STEP COUPON BONDS CALLABLE 04/13/21
04/29/22
04/29/26
0.50%
0.50%
1842
61 51
AAA
AA+
6,000,000.00
6,000,000.00
5,919,600.00
NOTE. G (CONTINUED TO NEXT PAGE)
City of Rialto
SCHEDULE OF INVESTMENTS
GENERAL POOLED FUNDS / INVESTMENTS - REF: G
JANUARY 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
JANUARY 2022
3130AMKN1 - FEDERAL HOME LOAN MULTISTEP UP COUPON BONDS CALLABLE 05/18/21
02/27/22
05/27/26
0.50%
0.50%
1835
60 52
AAA
AA+
8,900,000.00
8,900,000.00
8,803,613.00
3130AMB76 - FEDERAL HOME LOAN BANK BONDS CALLABLE
05/18/21
05/18/22
05/18/26
1.25%
1.26%
1826
60 52
AAA
AA+
1,108,800.00
1,100,000.00
1,084,996.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 56
AAA
AA+
10,000,000.00
10,000,000.00
9,806,700.00
3130ANZ52 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/08/21
03/28/22
09/28/26
0.50%
0.50%
1846
61 56
AAA
AA+
2,500,000.00
2,500,000.00
2,454,350.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 56
AAA
AA+
5,000,000.00
5,000,000.00
4,811,450.00
78658RFR7 - SAFRA NATIONAL BANK CD
10/12/21
---
10/19/22
0.15%
0.15%
372
12 9
N.A.
N.A.
249,000.00
249,000.00
248,666.34
99000FGR3 - WORLD'S FOREMOST BANK CD
09/20/21
---
05/08/23
2.45%
2.40%
595
20 15
N.A.
N.A.
206,936.00
200,000.00
203,812.00
99000QMY7 - COMENITY BANK CD
09/23/21
---
08/15/23
2.15%
2.11%
691
23 18
N.A.
N.A.
206,372.00
200,000.00
203,376.00
05580AD92 - BMW BK N AMERICA CD
09/20/21
---
09/25/23
0.35%
0.35%
735
24 20
N.A.
N.A.
249,000.00
249,000.00
247,067.76
87165HD64 - SYNCHRONY BANK CD
09/20/21
---
09/25/23
0.40%
0.40%
735
24 20
N.A.
N.A.
249,000.00
249,000.00
247,271.94
38149MA52 - GOLDMAN SACHS BK USA CD
09/20/21
---
09/29/23
0.35%
0.35%
739
24 20
N.A.
N.A.
249,000.00
249,000.00
247,032.90
856285XP1 - STATE BANK OF INDIA CD
09/20/21
---
09/29/23
0.40%
0.40%
739
24 20
N.A.
N.A.
249,000.00
249,000.00
247,237.08
947547NE1 - WEBBANK CD
09/20/21
---
09/29/23
0.30%
0.30%
739
24 20
N.A.
N.A.
249,000.00
249,000.00
246,813.78
538036SD7 - LIVE OAK BANKING CO CD
09/21/21
---
10/02/23
0.25%
0.25%
741
24 20
N.A.
N.A.
249,000.00
249,000.00
246,584.70
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
247,657.50
45581ECS8 - INDUSTRIAL & COM BK CD
09/21/21
---
10/18/23
0.35%
0.35%
757
25 21
N.A.
N.A.
249,000.00
249,000.00
246,858.60
06251A2J8 - BANK HAPOALIM BM NY CD
09/28/21
---
10/26/23
0.25%
0.25%
758
25 21
N.A.
N.A.
248,253.00
249,000.00
246,355.62
88241TFP6 - TEXAS EXCHANGE BK SSB CD
09/22/21
---
12/18/23
0.35%
0.35%
817
27 23
N.A.
N.A.
248,000.00
248,000.00
245,269.52
61765QQ28 - MORGAN STANLEY BK NA CD
10/01/21
---
01/08/24
0.25%
0.25%
829
27 23
N.A.
N.A.
250,000.00
250,000.00
247,112.50
47804GGX5 - JOHN MARSHALL BANK CD
09/29/21
---
06/17/24
0.25%
0.25%
992
33 29
N.A.
N.A.
243,020.40
245,000.00
240,193.10
29278TPT1 - ENERBANK USA CD
10/12/21
---
06/26/24
0.50%
0.50%
988
32 29
N.A.
N.A.
210,578.00
211,000.00
208,041.78
89235MLG4 - TOYOTA FINL SGS BK CD
09/23/21
---
08/12/24
0.60%
0.60%
1054
35 30
N.A.
N.A.
248,927.79
249,000.00
245,777.94
795451AW3 - SALLIE MAE BANK/SALT CD
09/20/21
---
09/23/24
0.70%
0.70%
1099
36 32
N.A.
N.A.
249,000.00
249,000.00
246,121.56
90348JT75 - UBS BANK USA CD
09/28/21
---
10/07/24
0.65%
0.65%
1105
36 32
N.A.
N.A.
249,000.00
249,000.00
245,683.32
59013KNU6 - MERRICK BANK CD
10/06/21
---
10/21/24
0.55%
0.55%
1111
37 33
N.A.
N.A.
249,000.00
249,000.00
244,911.42
48128WBQ7 - JP MORGAN CHASE BK NA CD
10/13/21
04/29/22
10/29/26
0.55%
0.51%
1842
61 57
N.A.
N.A.
125,000.00
125,000.00
121,915.00
53944VAS8 - LLOYDS BANK PLC SR NOTE
12/09/19
---
08/14/22
2.25%
2.23%
979
32 6
A1
A+
2,009,300.00
2,000,000.00
2,016,200.00
13605WQ79 - CANADIAN IMPERIAL BK COMM MTN CALLABLE
12/28/20
12/22/22
06/22/24
0.55%
0.57%
1272
42 29
A2
BBB+
3,000,000.00
3,000,000.00
2,892,900.00
459056HV2 - INTL BK RECON & DEVELOP SR UNSECURED
09/07/21
---
08/28/24
1.50%
1.49%
1086
36 31
AAA
AAA
1,031,750.00
1,000,000.00
1,004,260.00
89114TDD1 - TORONTO DOMINION BANK MTN CALLABLE
03/09/21
03/11/22
09/11/24
0.70%
0.71%
1282
42 31
A1
A
7,000,000.00
7,000,000.00
6,812,820.00
89114TF49 - TORONTO DOMINION BANK MTN CALLABLE
03/20/21
04/01/22
04/01/25
1.00%
1.02%
1473
48 38
A1
A
5,000,000.00
5,000,000.00
4,861,850.00
06747PKV0 - BARCLAYS BANK PLC - MTN CALLABLE
06/08/20
04/08/23
04/08/25
3.25%
3.20%
0 38
A1
A
5,136,480.00
4,920,000.00
4,981,549.20
WFA ---TREASURY MONEY MARKET
01/01/22
---
01/31/22
---
0.01%
30 1
---
---
---
2,746.64
2,746.64
2,746.64
WFA --- CASH
01/01/22
---
01/31/22
---
---
30 1
---
---
---
6.06 6.06
6.06 SUBTOTAL
143,012,132.29
141,643,752.70
139,771,643.41
TOTAL - GENERAL POOLED FUNDS / INVESTMENTS
239,534,444.99
G
238,188,192.36
236,236,271.38
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 **
01/01/22
---
01/01/22
---
---
0 0
---
---
---
10,456,141.26
10,456,141.26
10,456,141.26
SHARES PURCHASED
01/01/22
---
01/31/22
---
---
30 1
---
---
---
21,807.28
21,807.28
21,807.28
SHARES REDEEMED
01/01/22
---
01/31/22
---
---
30 1
---
---
---
(3,214,962.19)
(3,214,962.19)
(3,214,962.19)
INTEREST EARNED - WELLS FARGO
01/01/22
---
01/31/22
----
0.01%
30 1
---
---
---
78.34 78.34
78.34 TOTAL - RSA INVESTMENTS
7,263,064.69
H
7,263,064.69
7,263,064.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 CASH SWEEP ACCOUNT
POOLED FUNDS - RUA ACCOUNT **
01/01/22
---
01/01/22
---
---
0 0
---
---
---
6,967,861.50
6,967,861.50
6,967,861.50
SHARES REDEEMED
01/01/22
---
01/31/22
---
---
30 1
---
---
---
(71,956.51)
(71,956.51)
(71,956.51)
INTEREST EARNED - WELLS FARGO
01/01/22
---
01/31/22
---
0.01%
30 1
---
---
---
58.87 58.87
58.87 SUBTOTAL
6,895,963.86
6,895,963.86
6,895,963.86
LAIF - CALIFORNIA STATE POOL
POOLED FUNDS - LAIF
01/01/22
---
01/31/22
---
0.26%
30 1
---
---
---
100,684.38
100,684.38
100,684.38
INTEREST EARNED
01/01/22
---
01/31/22
---
---
30 1
---
---
---
57.96 57.96
57.96 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.96%
803
26 18
A3
BBB
974,088.00
900,000.00
935,208.00
38150AJK2 - GOLDMAN SACHS GRP INC MTN
11/22/21
05/24/22
11/24/23
1.00%
1.01%
732
24 22
A2
BBB+
3,900,000.00
3,900,000.00
3,841,461.00
02665WDS7 - AMERICAN HONDA FINANCE MTN
02/04/21
---
07/12/24
0.56%
0.56%
1254
41 29
A3
A-
3,477,991.50
3,475,000.00
3,383,294.75
3815AJ48 - GOLDMAN SACHS GRP INC MTN
10/27/21
10/29/22
10/29/24
1.15%
1.17%
1098
36 33
A2
BBB+
413,000.00
413,000.00
405,053.88
3130AMRA2 - FEDERAL HOME LOAN BANK
06/02/21
03/24/22
06/24/26
0.63%
0.63%
1848
61 53
AAA
AA+
1,000,000.00
1,000,000.00
977,920.00
83369MM74 - SOCIETE GENERALE BANK MTN
10/14/20
04/19/22
10/19/22
0.40%
0.40%
735
24 9
A1
A
2,000,000.00
2,000,000.00
1,981,080.00
13605WQ79 - CANADIAN IMPERIAL BANK COMM MTN CALLABLE
12/18/20
12/22/22
06/22/24
0.56%
0.57%
1282
42 29
A2
BBB+
270,000.00
270,000.00
260,361.00
89114TDD1 - TORONTO DOMINION BANK MTN CALLABLE
03/09/21
03/11/22
09/11/24
0.71%
0.71%
1282
42 31
A1
A
3,000,000.00
3,000,000.00
2,919,780.00
89114TF49 - TORONTO DOMINION BANK MTN CALLABLE
03/30/21
04/01/22
04/01/25
1.01%
1.02%
1463
48 38
A1
A
3,000,000.00
3,000,000.00
2,917,110.00
WFA --- TREASURY MONEY MARKET
01/01/22
---
01/31/22
---
0.01%
30 1
---
---
---
858.42
858.42
858.42
WFA --- CASH
01/01/22
---
01/31/22
---
---
30 1
---
---
---
26,174.24
26,174.24
26,174.24
SUBTOTAL
18,062,112.16
17,985,032.66
17,648,301.29
TOTAL - RUA PRE-EXISTING INVESTMENTS
25,058,818.36
I
24,981,738.86
24,645,007.49
JANUARY 2022
SCHEDULE OF INVESTMENTS
RUA PRE-EXISTING / INVESTMENTS - REF: I
SCHEDULE OF INVESTMENTS
RSA STAGE COACH SWEEP ACCOUNT - REF: H
JANUARY 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 **
01/01/22
---
01/01/22
---
---
0 0
---
---
---
115,643.04
115,643.04
115,643.04
SHARES PURCHASED
01/01/22
---
01/31/22
---
---
30 1
---
---
---
9,366.03
9,366.03
9,366.03
SHARES REDEEMED
01/01/22
---
01/31/22
---
---
30 1
---
---
---
(42.36)
(42.36)
(42.36)
INTEREST EARNED - SPORTS CENTER &POOL ACCOUNT **
01/01/22
---
01/31/22
---
0.01%
30 1
---
---
---
1.03 1.03
1.03 CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) - SPORTS CENTER &POOL ** 01/01/22
---
01/31/22
---
---
30 1
---
---
---
489.00
489.00
489.00
SUBTOTAL
125,456.74
125,456.74
125,456.74
WELLS FARGO CASH SWEEP ACCOUNT - FLEXIBLE BENEFIT
FLEXIBLE BENEFIT ACCOUNT**
01/01/22
---
01/01/22
---
---
0 0
---
---
---
34,516.72
34,516.72
34,516.72
INTEREST EARNED - FLEXIBLE BENEFIT ACCOUNT**
01/01/22
---
01/31/22
---
0.01%
30 1
---
---
---
0.29 0.29
0.29 SUBTOTAL
34,517.01
34,517.01
34,517.01
TOTAL - OTHER BANK ACCOUNTS INVESTMENTS
159,973.75
J
159,973.75
159,973.75
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.41%
1828
60 51
A2
BBB+
320,000.00
320,000.00
305,097.60
WFA --- TREASURY MONEY MARKET
01/01/22
---
01/31/22
---
0.01%
30 1
---
---
---
100.84
100.84
100.84
WFA --- CASH
01/01/22
---
01/31/22
---
---
30 1
---
---
---
2,238.10
2,238.10
2,238.10
TOTAL - CEMETERY ENDOWMENT FUND
322,338.94
K
322,338.94
307,436.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
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 5
---
---
163,919.86
163,919.86
163,919.86
TOTAL - PEPPER AVENUE EXTENSION RESTRICTED ACCOUNTS
324,110.26
L
324,110.26
324,110.26
SCHEDULE OF INVESTMENTS
OTHER BANK ACCOUNTS - CASH SWEEP ACCOUNTS - REF: J
JANUARY 2022
JANUARY 2022
SCHEDULE OF INVESTMENTS
PEPPER AVENUE EXTENSION (RESTRICTED FUNDS) - REF: L
JANUARY 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
66522UAA1 - NORTHERN ILLINOIS GAS CO CP
11/18/21
---
01/10/22
---
0.14%
53 2
---
---
---
---
---
---
02665KB30 - AMERICAN HONDA FINANCE CP
11/08/21
---
02/03/22
---
0.16%
87 3
0 P2
A2
14,994,199.96
15,000,000.00
14,999,700.00
62479MBN2 - MUFG BANK LTD/NY CP
11/23/21
---
02/22/22
---
0.15%
91 3
1 P1
A1
2,998,862.49
3,000,000.00
2,999,820.00
80285QDB3 - SANTANDER UK PLC CP
01/10/22
---
04/11/22
---
0.20%
91 3
2 P1
A1
7,796,056.63
7,800,000.00
7,796,568.00
WFA --- TREASURY MONEY MARKET
01/01/22
---
01/31/22
---
0.01%
30 1
---
---
---
3,843.56
3,843.56
3,843.56
WFA --- CASH
01/01/22
---
01/31/22
---
---
30 1
---
---
---
90.46 90.46
90.46 SUBTOTAL
25,793,053.10
25,803,934.02
25,800,022.02
TOTAL - GENERAL FUND ECONOMIC RESERVE
25,793,053.10
M
25,803,934.02
25,800,022.02
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
01/01/22
---
01/01/22
---
---
0 0
---
---
---
17,880,275.56
17,880,275.56
21,003,247.68
TRANSFER TO GENERAL BANK ACCOUNT
01/01/22
---
01/31/22
---
---
30 1
---
---
---
(131,867.49)
(131,867.49)
(131,867.49)
TRUST FEES
01/01/22
---
01/31/22
---
---
30 1
---
---
---
(7,739.67)
(7,739.67)
(7,739.67)
INTEREST EARNED
01/01/22
---
01/31/22
---
---
30 1
---
---
---
51,068.27
51,068.27
51,068.27
UNREALIZED GAIN/LOSS
01/01/22
---
01/31/22
---
---
30 1
---
---
---
0.00 0.00
(803,834.52)
TOTAL - PUBLIC AGENCY RETIREMENT (RESTRICTED FUNDS)
17,791,736.67
N
17,791,736.67
20,110,874.27
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
01/01/22
---
01/31/22
---
---
30 1
---
---
---
0.00 0.00
0.00 2 - 2008 SERIES B
01/01/22
---
01/31/22
---
---
30 1
---
---
---
3,821,250.69
3,821,250.69
3,821,250.69
3 - 2008 SERIES C
01/01/22
---
01/31/22
---
---
30 1
---
---
---
2,493,102.17
2,493,102.17
2,493,102.17
4 - 2014 SERIES A
01/01/22
---
01/31/22
---
---
30 1
---
---
---
215,351.00
215,351.00
215,351.00
5 - 2015 SERIES A & B
01/01/22
---
01/31/22
---
---
30 1
---
---
---
679,745.75
679,745.75
679,745.75
6 - 2015 SERIES C
01/01/22
---
01/31/22
---
---
30 1
---
---
---
139,109.90
139,109.90
139,109.90
7 - 2018 REFUNDING 2008 SERIES A
01/01/22
---
01/31/22
---
---
30 1
---
---
---
651,626.00
651,626.00
651,626.00
8 - 2016 ELM PARK
01/01/22
---
01/31/22
---
---
30 1
---
---
---
542,632.13
542,632.13
542,632.13
TOTAL - CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES)
8,542,817.64
O
8,542,817.64
8,542,817.64
PUBLIC AGENCY RETIREMENT - OPEB (RESTRICTED FUNDS) - REF: N CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES) - REF: O JANUARY 2022
SCHEDULE OF INVESTMENTS
GENERAL FUND ECONOMIC RESERVE (RESTRICTED FUNDS) - REF: M JANUARY 2022
SCHEDULE OF INVESTMENTS
JANUARY 2022
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
01/01/22
---
01/31/22
---
---
30 1
---
---
---
4,407,834.23
4,407,834.23
4,407,834.23
2 - WASTEWATER ACCOUNTS
01/01/22
---
01/31/22
---
---
30 1
---
---
---
10,138,217.04
10,138,217.04
10,057,576.56
3 - WATER ACCOUNTS
01/01/22
---
01/31/22
---
---
30 1
---
---
---
7,269,134.73
7,269,134.73
7,226,090.61
TOTAL - CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT) 21,815,186.00
P
21,815,186.00
21,691,501.40
NOTE. P2. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 01/31/2022, INCLUDES CASH AND INVESTMENTS OF $255,136.79 AND $6,144,000.00 RESPECTIVELY.
NOTE. P3. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 01/31/2022, INCLUDES CASH AND INVESTMENTS OF $317,424.27 AND $3,348,000.00 RESPECTIVELY.
REF
239,534,444.99
G
7,263,064.69
H
25,058,818.36
I
159,973.75
J
322,338.94
K
324,110.26
L
25,793,053.10
M
17,791,736.67
N
8,542,817.64
O
21,815,186.00
P
346,605,544.40
(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
JANUARY 2022
SCHEDULE OF INVESTMENTS
CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT) - REF: P
INTEREST & GAIN/(LOSS) SUMMARY
07/31/21 - 12/31/21
1/31/2022
TOTAL
TO DATE
505,300.30
(131,202.29)
374,098.01
495.76
78.34 574.10
3,979.99
17,114.39
21,094.38
6.36 1.32
7.68 (16,567.53)
(12,048.53)
(28,616.06)
2,171.03
2.04 2,173.07
8.33 1.41
9.74 9,795.91
1,606.62
11,402.53
1,474,995.75
51,068.27
1,526,064.02
153.19
23.21 176.40
826.05
218.54
1,044.59
TOTAL
1,981,165.14
(73,136.68)
1,908,028.46
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
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)
(1,748,639.48)
1,526,064.02
54,204.24
(276,779.70)
City of Rialto
INVESTMENT INTEREST & GAINS/(LOSS) SCHEDULE
JANUARY 2022
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.