April 19, 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…………………………………………………………………………………………. 233,518,990.71
64%
A,G
Rialto Successor Agency (RSA) + Cash Sweep Bank Account…………………………………………………………………………………................................ 7,656,957.53
2%
B,H
Rialto Utility Authority (RUA) Pre-existing Investments + Cash Sweep Bank Account……………………………………………………………………………………………. 25,205,298.06
7%
C,I
Other Bank Accounts + Cash Sweep Bank Accounts……………………………………………………………………………………………………………………............. 3,913,421.19
1%
D,J
Escrow Accounts……………………………………………………………………………………………………………………………................................................. 14,153,656.13
4%
E
Cemetery Endowment Fund (Restricted Accounts)…………………………………………………………………........................................................................... 408,958.44
0%
F,K
Pepper Avenue Extension (Restricted Accounts)………………………………………………………………….......................................................... 163,922.55
0%
L
General Fund Economic Reserve (Restricted Funds)……………………………………………………………………............................................... 25,776,726.53
7%
M
Public Agency Retirement Services - OPEB (Restricted Funds)…………………………………………………………………….................................. 27,704,813.22
8%
N
Cash with Fiscal Agents - (Restricted Bond Issues)…………………………………………………………………………...................................................... 5,272,046.26
1%
O
Cash with Fiscal Agents - RUA (Concession Agreement)………………………………………………………………….......................................................... 22,601,353.96
6%
P
TREASURER'S PORTFOLIO
366,376,144.58
100%
TREASURER'S MONTHLY REPORT - MARCH 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
FEBRUARY 2022
MARCH 2022
ACTIVE ACCOUNTS
BALANCE
RECEIPTS
DISBURSEMENTS
BALANCE
REF
GENERAL BANK ACCOUNT **
(604,900.79)
40,197,235.49
40,430,473.42
(838,138.72)
A
RSA BANK ACCOUNT **
21,479.94
120,586.32
142,066.26
-
B
RUA BANK ACCOUNT **
(2,513.00)
344,564.32
368,620.50
(26,569.18)
C
SPORTS CENTER/POOL **
-
15,551.81
15,551.81
-
AMBULANCE LOCKBOX
88,650.63
361,010.22
342,381.83
107,279.02
FLEXIBLE BENEFIT**
-
0.26 0.26
-
ALARM LOCKBOX
3,539.38
20,007.32
-
23,546.70
BANK CARD
1,092.01
-
-
1,092.01
PAYROLL CLEARING
14,983.11
6,519,688.19
4,481,005.87
2,053,665.43
LIABILITY ACCT./CARL WARREN & CO.
2,173.45
-
-
2,173.45
LIABILITY ACCT./GEORGE HILLS
94,142.16
5,857.84
108.20
99,891.80
PEPPER AVENUE
-
-
-
-
WORKERS COMP/LWP CLAIMS SOLUTIONS
5,392.14
327,529.20
298,995.90
33,925.44
PROPERTY EVIDENCE MONIES
1,407,313.03
923.52
4,120.20
1,404,116.35
OTHER BANK ACCOUNTS
1,617,285.91
7,250,568.36
5,142,164.07
3,725,690.20
D
ENERGY CONSERVATION PROJECT
84,786.55
-
-
84,786.55
AYALA @ 210 PARTNERS LLC
310,696.95
10.55 -
310,707.50
LEWIS HILLWOOD
2,747,955.84
731.81
8,202.85
2,740,484.80
ALDER AVENUE
3,263,502.40
869.10
9,741.79
3,254,629.71
LAUREL/WALNUT/LOCUST
2,974,427.33
792.12
8,878.89
2,966,340.56
SUB ACCOUNT A
4,809,783.68
1,280.89
14,357.56
4,796,707.01
ESCROW ACCOUNTS
14,191,152.75
3,684.47
41,181.09
14,153,656.13
E
CEMETERY ENDOWMENT FUND
86,617.25
2.21 -
86,619.46
RESTRICTED ACCOUNTS
86,617.25
2.21 -
86,619.46
F
TOTAL - ACTIVE ACCOUNTS
15,309,122.06
17,101,257.89
(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
MONTHS
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
REMAINING
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
WELLS FARGO CASH SWEEP ACCOUNT
POOLED FUNDS - GENERAL
03/01/22
---
03/01/22
---
---
0 1
---
---
---
53,411,586.35
53,411,586.35
53,411,586.35
SHARES PURCHASED
03/01/22
---
03/31/22
---
---
30 1
---
---
---
8,485,014.17
8,485,014.17
8,485,014.17
SHARES REDEEMED
03/01/22
---
03/31/22
---
---
30 1
---
---
---
(25,689,013.42)
(25,689,013.42)
(25,689,013.42)
INTEREST EARNED - GENERAL FUND ACCOUNT
03/01/22
---
03/31/22
---
0.17%
30 1
---
---
---
2,379.00
2,379.00
2,379.00
CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) - GENERAL 03/01/22
---
03/31/22
---
---
30 1
---
---
---
767,072.08
767,072.08
767,072.08
SUBTOTAL
36,977,038.18
36,977,038.18
36,977,038.18
PACIFIC PREMIER BANK #0314
POOLED FUNDS - #0314
03/01/22
---
03/01/22
---
0.07%
0 0
---
---
---
5,197,878.83
5,197,878.83
5,197,878.83
BANKING FEE
03/01/22
---
03/31/22
---
---
30 1
---
---
---
(2.00)
(2.00)
(2.00)
INTEREST EARNED #0314
03/01/22
---
03/31/22
---
---
30 1
---
---
---
309.02
309.02
309.02
SUBTOTAL
5,197,878.83
5,198,185.85
5,198,185.85
PACIFIC PREMIER BANK #7667
POOLED FUNDS - #7667
03/01/22
---
03/01/22
---
0.07%
0 0
---
---
---
3,531,366.64
3,531,366.64
3,531,366.64
BANKING FEE
03/01/22
---
03/31/22
---
---
30 1
---
---
---
(32.00)
(32.00)
(32.00)
INTEREST EARNED #7667
03/01/22
---
03/31/22
---
---
30 1
---
---
---
209.95
209.95
209.95
SUBTOTAL
3,531,544.59
3,531,544.59
3,531,544.59
LAIF - CALIFORNIA STATE POOL
POOLED FUNDS - LAIF
03/01/22
---
03/31/22
---
0.29%
30 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
02665WDM0 - AMERICAN HONDA FIN CORP
03/24/22
---
09/08/23
0.65%
0.67%
533
18 17
A3
A-
978,249.27
1,000,000.00
974,615.95
13607HVC3 - CANADIAN IMPERIAL BANK
03/24/22
---
06/22/23
0.45%
0.46%
455
15 15
A2
A-
1,468,289.18
1,500,000.00
1,464,342.36
3133ENLD0 - FEDERAL FARM CR BKS
01/11/22
01/26/24
01/26/26
1.53%
1.59%
1476
49 46
N/A
N/A
2,000,000.00
2,000,000.00
1,920,966.32
3133ENNE6 - FEDERAL FARM CREDIT BANK
02/03/22
05/09/22
02/09/24
1.23%
1.25%
736
24 22
AAA
AA+
745,000.00
745,000.00
730,645.10
3130AQJK0 - FEDERAL HOME LOAN BANK
01/05/22
04/25/22
04/25/24
1.00%
1.03%
841
28 25
AAA
AA+
2,000,000.00
2,000,000.00
1,950,276.82
3130ARJ44 - FEDERAL HOME LOAN BANK
03/24/22
07/22/22
04/22/24
2.40%
2.40%
760
25 25
AAA
AA+
2,000,000.00
2,000,000.00
1,997,102.52
3134GXGQ1 - FREDDIE MAC
12/07/21
06/15/22
12/15/22
0.20%
0.20%
373
12 9
AAA
N/A
1,248,601.53
1,250,000.00
1,238,580.24
78015K7L2 - ROYAL BANK OF CANADA
01/04/22
---
01/19/24
0.43%
0.44%
745
25 22
A1
A
2,007,017.00
2,026,000.00
1,955,207.79
83369NHL7 - SOCIETE GENERALE
01/18/22
07/20/22
01/20/27
1.95%
2.04%
1828
60 58
A1
A
2,000,000.00
2,000,000.00
1,914,083.26
89788JAB5 - TRUIST BK GLOBAL BK
03/22/22
02/09/23
03/09/23
1.25%
1.26%
352
12 11
A2
A
995,798.70
1,000,000.00
992,787.18
91282CBU4 - UNITED STATES TREASURY
03/22/22
---
03/31/23
0.13%
0.13%
374
12 12
AAA
N/A
1,972,598.16
2,000,000.00
1,968,828.12
91282CCN9 - UNITED STATES TREASURY
03/24/22
---
07/31/23
0.13%
0.13%
494
16 16
AAA
N/A
1,955,249.26
2,000,000.00
1,949,609.38
91282CAR2 - UNITED STATES TREASURY
03/24/22
---
10/31/22
0.13%
0.13%
221
7 7
AAA
N/A
4,973,537.56
5,000,000.00
4,969,140.60
JP MORGAN ADVISORS ---TREASURY MONEY MARKET
03/01/22
---
03/31/22
---
0.01%
30 1
---
---
---
(2,000,000.00)
(2,000,000.00)
(2,000,000.00)
JP MORGAN ADVISORS --- CASH
03/01/22
---
03/31/22
---
---
30 1
---
---
---
2,655,991.35
2,655,991.35
2,655,991.35
SUBTOTAL
25,000,332.01
25,176,991.35
24,682,176.99
NOTE. G (CONTINUED TO NEXT PAGE)
City of Rialto
SCHEDULE OF INVESTMENTS
GENERAL POOLED FUNDS / INVESTMENTS - REF: G
MARCH 2022
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
MONTHS
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
REMAINING
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
City of Rialto
SCHEDULE OF INVESTMENTS
GENERAL POOLED FUNDS / INVESTMENTS - REF: G
MARCH 2022
WELLS FARGO ADVISORS - CUSTODIAL
94974BFC9 - WELLS FARGO BANK SENIOR NOTES
01/29/19
---
03/08/22
3.50%
3.49%
1134
37 ---
---
---
---
---
---
38150AEJ0 - GOLDMAN SACHS GRP INC MTN CALLABLE
11/20/20
05/24/22
11/25/22
0.40%
0.40%
735
24 8
A2
BBB+
7,497,500.00
7,500,000.00
7,401,825.00
94973VBA4 - WELLPOINT INC SR UNSECURED
07/13/21
---
01/15/23
3.30%
3.27%
551
18 10
BAA2
A
1,566,150.00
1,500,000.00
1,511,130.00
94974BFN5 -WELLS FARGO & CO SUBORDINATED
06/03/21
---
08/15/23
4.13%
4.03%
803
26 17
A3
BBB
5,519,832.00
5,100,000.00
5,213,577.00
38150AEF8 - GOLDMAN SACH GRP MTN CALLABLE
11/20/20
05/24/22
11/24/23
0.60%
0.62%
1099
36 20
A2
BBB+
3,000,000.00
3,000,000.00
2,890,380.00
17329F6E9 - CITIGROUP GLOBAL MARKETS MTN CALLABLE
03/30/21
06/30/22
03/31/24
0.70%
0.73%
1097
36 24
A3
BBB+
8,250,000.00
8,250,000.00
7,889,392.50
02665WDS7 - AMERICAN HONDA FINANCE MTN
02/25/21
---
07/12/24
0.55%
0.57%
1233
41 27
A3
A-
3,827,410.50
3,825,000.00
3,647,826.00
45950VQE9 - INTL FINANCE CORP MTN
09/08/21
---
09/10/24
0.43%
0.45%
1098
36 29
AAA
AAA
5,000,000.00
5,000,000.00
4,749,300.00
38150AFC4 - GOLDMAN SACHS GRP INC MTN CALLABLE
03/26/21
06/30/22
09/30/24
1.00%
1.05%
1284
42 30
A2
BBB+
4,500,000.00
4,500,000.00
4,257,450.00
61761JVL0 - MORGAN STANLEY MTN SR UNSECURED
07/15/21
---
10/23/24
3.70%
3.63%
1196
39 31
A1
BBB+
5,048,828.40
4,620,000.00
4,702,882.80
38150AFM2 - GOLDMAN SACHS GRP INC MTN CALLABLE
05/10/21
05/14/22
11/12/24
1.00%
1.06%
1282
42 31
A2
BBB+
10,000,000.00
10,000,000.00
9,392,800.00
037833AZ3 - APPLE INC SR UNSECURED
02/04/21
---
02/09/25
2.50%
2.50%
1466
48 34
AAA
AA+
2,157,500.00
2,000,000.00
1,995,100.00
06048WK66 - BANK OF AMERICA CORP MULTISTEP UP MTN CALLABLE 02/04/21
06/23/22
12/23/25
0.65%
0.71%
1783
59 45
A2
A-
1,994,000.00
2,000,000.00
1,824,340.00
17290AEA4 - CITIGROUP INC. MTN CALLABLE
10/15/21
10/19/24
10/19/26
1.45%
1.59%
1830
60 55
A3
BBB+
5,000,000.00
5,000,000.00
4,533,450.00
48128G5Y2 - JPMORGAN CHASE & CO MTN CALLABLE
01/27/22
01/31/24
01/29/27
2.10%
2.30%
1828
60 58
A2
A-
3,000,000.00
3,000,000.00
2,729,880.00
3815AL29 - GOLDMAN SACHS GRP INC MTN CALLABLE
02/28/22
03/02/23
03/02/27
3.00%
3.10%
1828
60 59
A2
BBB+
5,000,000.00
5,000,000.00
4,833,100.00
3135G05G4 - FEDERAL NATIONAL MTG ASSN NOTES
12/02/21
---
07/10/23
0.25%
0.25%
585
19 15
AAA
AA+
3,896,901.50
3,910,000.00
3,820,265.50
3130ANZ60 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/08/21
06/27/22
06/27/25
0.40%
0.42%
1388
46 39
AAA
AA+
1,500,000.00
1,500,000.00
1,420,320.00
3130ALZA5 - FEDERAL HOME LOAN BANK MULTI STEP COUPON BONDS CALLABLE 04/13/21
04/29/22
04/29/26
0.50%
0.52%
1842
61 49
AAA
AA+
6,000,000.00
6,000,000.00
5,710,440.00
3130AMB76 - FEDERAL HOME LOAN BANK BONDS CALLABLE
05/18/21
05/18/22
05/18/26
1.25%
1.31%
1826
60 50
AAA
AA+
1,108,800.00
1,100,000.00
1,047,596.00
3130AMKN1 - FEDERAL HOME LOAN MULTISTEP UP COUPON BONDS CALLABLE 05/18/21
05/27/22
05/27/26
0.50%
0.52%
1835
60 50
AAA
AA+
8,900,000.00
8,900,000.00
8,487,663.00
3130ANUT5 - FEDERAL HOME LOAN BANK MULTI STEP COUPON BONDS CALLABLE 08/30/21
06/16/22
09/16/26
0.50%
0.52%
1843
61 54
AAA
AA+
10,000,000.00
10,000,000.00
9,470,200.00
3130ANZ52 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/08/21
03/28/22
09/28/26
0.50%
0.52%
1846
61 54
AAA
AA+
2,500,000.00
2,500,000.00
2,370,075.00
3130ANXC9 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/02/21
06/29/22
09/29/26
0.60%
0.66%
1853
61 54
AAA
AA+
5,000,000.00
5,000,000.00
4,672,000.00
78658RFR7 - SAFRA NATIONAL BANK CD
10/12/21
---
10/19/22
0.15%
0.15%
372
12 7
N.A.
N.A.
249,000.00
249,000.00
247,981.59
99000FGR3 - WORLD'S FOREMOST BANK CD
09/20/21
---
05/08/23
2.45%
2.42%
595
20 13
N.A.
N.A.
206,936.00
200,000.00
201,978.00
99000QMY7 - COMENITY BANK CD
09/23/21
---
08/15/23
2.15%
2.13%
691
23 17
N.A.
N.A.
206,372.00
200,000.00
201,224.00
05580AD92 - BMW BK N AMERICA CD
09/20/21
---
09/25/23
0.35%
0.35%
735
24 18
N.A.
N.A.
249,000.00
249,000.00
244,049.88
87165HD64 - SYNCHRONY BANK CD
09/20/21
---
09/25/23
0.40%
0.40%
735
24 18
N.A.
N.A.
249,000.00
249,000.00
244,234.14
38149MA52 - GOLDMAN SACHS BK USA CD
09/20/21
---
09/29/23
0.35%
0.35%
739
24 18
N.A.
N.A.
249,000.00
249,000.00
243,982.65
856285XP1 - STATE BANK OF INDIA CD
09/20/21
---
09/29/23
0.40%
0.40%
739
24 18
N.A.
N.A.
249,000.00
249,000.00
244,166.91
947547NE1 - WEBBANK CD
09/20/21
---
09/29/23
0.30%
0.30%
739
24 18
N.A.
N.A.
249,000.00
249,000.00
243,768.51
538036SD7 - LIVE OAK BANKING CO CD
09/21/21
---
10/02/23
0.25%
0.25%
741
24 18
N.A.
N.A.
249,000.00
249,000.00
243,569.31
649447UA5 - NEW YORK CMNTY BK CD
10/05/21
---
10/16/23
0.30%
0.30%
741
24 19
N.A.
N.A.
250,000.00
250,000.00
244,500.00
45581ECS8 - INDUSTRIAL & COM BK CD
09/21/21
---
10/18/23
0.35%
0.35%
757
25 19
N.A.
N.A.
249,000.00
249,000.00
243,673.89
06251A2J8 - BANK HAPOALIM BM NY CD
09/28/21
---
10/26/23
0.25%
0.25%
758
25 19
N.A.
N.A.
248,253.00
249,000.00
243,146.01
88241TFP6 - TEXAS EXCHANGE BK SSB CD
09/22/21
---
12/18/23
0.35%
0.35%
817
27 21
N.A.
N.A.
248,000.00
248,000.00
241,544.56
61765QQ28 - MORGAN STANLEY BK NA CD
10/01/21
---
01/08/24
0.25%
0.25%
829
27 21
N.A.
N.A.
250,000.00
250,000.00
243,205.00
47804GGX5 - JOHN MARSHALL BANK CD
09/29/21
---
06/17/24
0.25%
0.26%
992
33 27
N.A.
N.A.
243,020.40
245,000.00
234,604.65
29278TPT1 - ENERBANK USA CD
10/12/21
---
06/26/24
0.50%
0.51%
988
32 27
N.A.
N.A.
210,578.00
211,000.00
203,051.63
89235MLG4 - TOYOTA FINL SGS BK CD
09/23/21
---
08/12/24
0.60%
0.62%
1054
35 28
N.A.
N.A.
248,927.79
249,000.00
239,388.60
NOTE. G (CONTINUED TO NEXT PAGE)
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
MONTHS
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
REMAINING
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
City of Rialto
SCHEDULE OF INVESTMENTS
GENERAL POOLED FUNDS / INVESTMENTS - REF: G
MARCH 2022
795451AW3 - SALLIE MAE BANK/SALT CD
09/20/21
---
09/23/24
0.70%
0.72%
1099
36 30
N.A.
N.A.
249,000.00
249,000.00
239,244.18
90348JT75 - UBS BANK USA CD
09/28/21
---
10/07/24
0.65%
0.67%
1105
36 30
N.A.
N.A.
249,000.00
249,000.00
238,678.95
59013KNU6 - MERRICK BANK CD
10/06/21
---
10/21/24
0.55%
0.57%
1111
37 31
N.A.
N.A.
249,000.00
249,000.00
237,809.94
48128WBQ7 - JP MORGAN CHASE BK NA CD
10/13/21
04/29/22
10/29/26
0.55%
0.53%
1842
61 55
N.A.
N.A.
125,000.00
125,000.00
116,840.00
53944VAS8 - LLOYDS BANK PLC SR NOTE
12/09/19
---
08/14/22
2.25%
2.24%
979
32 4
A1
A+
2,009,300.00
2,000,000.00
2,003,340.00
89114V4M6 - TORONTO-DOMINION BANK MTN
03/07/22
06/09/22
06/09/23
1.40%
1.41%
459
15 14
A1
A
5,000,000.00
5,000,000.00
4,962,000.00
13605WQ79 - CANADIAN IMPERIAL BK COMM MTN CALLABLE
12/28/20
12/22/22
06/22/24
0.55%
0.58%
1272
42 27
A2
A-
3,000,000.00
3,000,000.00
2,831,790.00
459056HV2 - INTL BK RECON & DEVELOP SR UNSECURED
09/07/21
---
08/28/24
1.50%
1.53%
1086
36 29
AAA
AAA
1,031,750.00
1,000,000.00
978,020.00
89114TDD1 - TORONTO DOMINION BANK MTN CALLABLE
03/09/21
06/11/22
09/11/24
0.70%
0.73%
1282
42 29
A1
A
7,000,000.00
7,000,000.00
6,646,920.00
89114TF49 - TORONTO DOMINION BANK MTN CALLABLE
03/20/21
07/01/22
04/01/25
1.00%
1.06%
1473
48 36
A1
A
5,000,000.00
5,000,000.00
4,712,100.00
06747PKV0 - BARCLAYS BANK PLC - MTN CALLABLE
06/08/20
04/08/23
04/08/25
3.25%
3.30%
0 36
A1
A
5,136,480.00
4,920,000.00
4,837,983.60
WFA ---TREASURY MONEY MARKET
03/01/22
---
03/31/22
---
0.01%
30 1
---
---
---
2,746.64
2,746.64
2,746.64
WFA --- CASH
03/01/22
---
03/31/22
---
---
30 1
---
---
---
7.41 7.41
7.41 SUBTOTAL
143,423,293.64
142,093,754.05
136,386,542.85
TOTAL - GENERAL POOLED FUNDS / INVESTMENTS
234,357,129.43
G
233,204,556.20
227,002,530.64
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
MONTHS
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
REMAINING
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
WELLS FARGO CASH SWEEP ACCOUNT
RSA ACCOUNT **
03/01/22
---
03/01/22
---
---
0 0
---
---
---
7,525,543.54
7,525,543.54
7,525,543.54
SHARES PURCHASED
03/01/22
---
03/31/22
---
---
30 1
---
---
---
134,514.08
134,514.08
134,514.08
SHARES REDEEMED
03/01/22
---
03/31/22
---
---
30 1
---
---
---
(5,289.20)
(5,289.20)
(5,289.20)
CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) - RSA ACCOUNT ** 03/01/22
---
03/31/22
---
---
30 1
---
---
---
1,762.00
1,762.00
1,762.00
INTEREST EARNED - WELLS FARGO
03/01/22
---
03/31/22
----
0.17%
30 1
---
---
---
427.11
427.11
427.11
TOTAL - RSA INVESTMENTS
7,656,957.53
H
7,656,957.53
7,656,957.53
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
MONTHS
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
REMAINING
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
WELLS FARGO CASH SWEEP ACCOUNT
POOLED FUNDS - RUA ACCOUNT **
03/01/22
---
03/01/22
---
---
0 0
---
---
---
6,817,457.64
6,817,457.64
6,817,457.64
SHARES PURCHASED
03/01/22
---
03/31/22
---
---
30 1
---
---
---
291,062.29
291,062.29
291,062.29
SHARES REDEEMED
03/01/22
---
03/31/22
---
---
30 1
---
---
---
(63,703.09)
(63,703.09)
(63,703.09)
INTEREST EARNED - WELLS FARGO
03/01/22
---
03/31/22
---
0.17%
30 1
---
---
---
382.72
382.72
382.72
SUBTOTAL
7,045,199.56
7,045,199.56
7,045,199.56
LAIF - CALIFORNIA STATE POOL
POOLED FUNDS - LAIF
03/01/22
---
03/31/22
---
0.29%
30 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%
4.03%
803
26 17
A3
BBB
974,088.00
900,000.00
920,043.00
38150AJK2 - GOLDMAN SACHS GRP INC MTN
11/22/21
05/24/22
11/24/23
1.00%
1.03%
732
24 20
A2
BBB+
3,900,000.00
3,900,000.00
3,779,412.00
02665WDS7 - AMERICAN HONDA FINANCE MTN
02/04/21
---
07/12/24
0.56%
0.58%
1254
41 27
A3
A-
3,477,991.50
3,475,000.00
3,314,038.00
3815AJ48 - GOLDMAN SACHS GRP INC MTN
10/27/21
10/29/22
10/29/24
1.15%
1.21%
1098
36 31
A2
BBB+
413,000.00
413,000.00
391,040.79
3130AMRA2 - FEDERAL HOME LOAN BANK
06/02/21
06/24/22
06/24/26
0.63%
0.66%
1848
61 51
AAA
AA+
1,000,000.00
1,000,000.00
944,560.00
83369MM74 - SOCIETE GENERALE BANK MTN
10/14/20
04/19/22
10/19/22
0.40%
0.40%
735
24 7
A1
A
2,000,000.00
2,000,000.00
1,976,020.00
13605WQ79 - CANADIAN IMPERIAL BANK COMM MTN CALLABLE
12/18/20
12/22/22
06/22/24
0.56%
0.58%
1282
42 27
A2
A-
270,000.00
270,000.00
254,861.10
89114TDD1 - TORONTO DOMINION BANK MTN CALLABLE
03/09/21
06/11/22
09/11/24
0.71%
0.73%
1282
42 29
A1
A
3,000,000.00
3,000,000.00
2,848,680.00
89114TF49 - TORONTO DOMINION BANK MTN CALLABLE
03/30/21
07/01/22
04/01/25
1.01%
1.06%
1463
48 36
A1
A
3,000,000.00
3,000,000.00
2,827,260.00
WFA --- TREASURY MONEY MARKET
03/01/22
---
03/31/22
---
0.01%
30 1
---
---
---
858.42
858.42
858.42
WFA --- CASH
03/01/22
---
03/31/22
---
---
30 1
---
---
---
49,987.42
49,987.42
49,987.42
SUBTOTAL
18,085,925.34
18,008,845.84
17,306,760.73
TOTAL - RUA PRE-EXISTING INVESTMENTS
25,231,867.24
I
25,154,787.74
24,452,702.63
SCHEDULE OF INVESTMENTS
RUA PRE-EXISTING / INVESTMENTS - REF: I
SCHEDULE OF INVESTMENTS
RSA STAGE COACH SWEEP ACCOUNT - REF: H
MARCH 2022
MARCH 2022
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
MONTHS
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
REMAINING
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
WELLS FARGO CASH SWEEP ACCOUNT - SPORTS CENTER & POOL
SPORTS CENTER & POOL ACCOUNT **
03/01/22
---
03/01/22
---
---
0 0
---
---
---
138,013.42
138,013.42
138,013.42
SHARES PURCHASED
03/01/22
---
03/31/22
---
---
30 1
---
---
---
15,181.03
15,181.03
15,181.03
INTEREST EARNED - SPORTS CENTER &POOL ACCOUNT **
03/01/22
---
03/31/22
---
0.17%
30 1
---
---
---
8.50 8.50
8.50 CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) - SPORTS CENTER &POOL ** 03/01/22
---
03/31/22
---
---
30 1
---
---
---
9.00 9.00
9.00 SUBTOTAL
153,211.95
153,211.95
153,211.95
WELLS FARGO CASH SWEEP ACCOUNT - FLEXIBLE BENEFIT
FLEXIBLE BENEFIT ACCOUNT**
03/01/22
---
03/01/22
---
---
0 0
---
---
---
34,517.27
34,517.27
34,517.27
INTEREST EARNED - FLEXIBLE BENEFIT ACCOUNT**
03/01/22
---
03/31/22
---
0.17%
30 1
---
---
---
1.77 1.77
1.77 SUBTOTAL
34,519.04
34,519.04
34,519.04
TOTAL - OTHER BANK ACCOUNTS INVESTMENTS
187,730.99
J
187,730.99
187,730.99
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
MONTHS
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
REMAINING
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.49%
1828
60 49
A2
BBB+
320,000.00
320,000.00
301,280.00
WFA --- TREASURY MONEY MARKET
03/01/22
---
03/31/22
---
0.01%
30 1
---
---
---
100.84
100.84
100.84
WFA --- CASH
03/01/22
---
03/31/22
---
---
30 1
---
---
---
2,238.14
2,238.14
2,238.14
TOTAL - CEMETERY ENDOWMENT FUND
322,338.98
K
322,338.98
303,618.98
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
MONTHS
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
REMAINING
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 3
---
---
163,922.55
163,922.55
163,922.55
TOTAL - PEPPER AVENUE EXTENSION RESTRICTED ACCOUNTS
163,922.55
L
163,922.55
163,922.55
SCHEDULE OF INVESTMENTS
OTHER BANK ACCOUNTS - CASH SWEEP ACCOUNTS - REF: J
MARCH 2022
MARCH 2022
SCHEDULE OF INVESTMENTS
PEPPER AVENUE EXTENSION (RESTRICTED FUNDS) - REF: L
MARCH 2022
SCHEDULE OF INVESTMENTS
CEMETERY ENDOWMENT FUND - REF: K
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
MONTHS
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
REMAINING
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
WELLS FARGO ADVISORS - ECONOMIC RESERVE
80285QDB3 - SANTANDER UK PLC CP
01/10/22
---
04/11/22
---
0.20%
91 3
0 P1
A1
7,796,056.63
7,800,000.00
7,799,142.00
2254EBE31 - CREDIT SUISSE NEW YORK
02/03/22
---
05/03/22
---
0.29%
89 3
1 P1
A1
14,989,060.34
15,000,000.00
14,993,250.00
74725AE3 - QUALCOMM INC
02/22/22
---
05/20/22
---
2.99%
87 3
2 A2
A
2,987,671.50
2,970,000.00
2,977,543.80
WFA --- TREASURY MONEY MARKET
03/01/22
---
03/31/22
---
0.01%
30 1
---
---
---
3,843.56
3,843.56
3,843.56
WFA --- CASH
03/01/22
---
03/31/22
---
---
30 1
---
---
---
94.50 94.50
94.50 SUBTOTAL
25,776,726.53
25,773,938.06
25,773,873.86
TOTAL - GENERAL FUND ECONOMIC RESERVE
25,776,726.53
M
25,773,938.06
25,773,873.86
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
MONTHS
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
REMAINING
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
HIGHMARK CAPITAL MANAGEMENT
PARS OPEB TRUST PROGRAM
03/01/22
---
03/01/22
---
---
0 0
---
---
---
27,790,819.37
27,790,819.37
29,623,644.59
TRANSFER TO GENERAL BANK ACCOUNT
03/01/22
---
03/31/22
---
---
30 1
---
---
---
(128,336.29)
(128,336.29)
(128,336.29)
TRUST FEES
03/01/22
---
03/31/22
---
---
30 1
---
---
---
(8,572.56)
(8,572.56)
(8,572.56)
INTEREST EARNED
03/01/22
---
03/31/22
---
---
30 1
---
---
---
50,902.70
50,902.70
50,902.70
UNREALIZED GAIN/LOSS
03/01/22
---
03/31/22
---
---
30 1
---
---
---
0.00 0.00
186,256.94
TOTAL - PUBLIC AGENCY RETIREMENT (RESTRICTED FUNDS)
27,704,813.22
N
27,704,813.22
29,723,895.38
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
MONTHS
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
REMAINING
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
CASH WITH FISCAL AGENT
1 - 2007 COPS
03/01/22
---
03/31/22
---
---
30 1
---
---
---
0.00 0.00
0.00 2 - 2008 SERIES B
03/01/22
---
03/31/22
---
---
30 1
---
---
---
2,960,092.43
2,960,092.43
2,960,092.43
3 - 2008 SERIES C
03/01/22
---
03/31/22
---
---
30 1
---
---
---
1,858,433.56
1,858,433.56
1,858,433.56
4 - 2014 SERIES A
03/01/22
---
03/31/22
---
---
30 1
---
---
---
2.20 2.20
2.20 5 - 2015 SERIES A & B
03/01/22
---
03/31/22
---
---
30 1
---
---
---
5.81 5.81
5.81 6 - 2015 SERIES C
03/01/22
---
03/31/22
---
---
30 1
---
---
---
1.78 1.78
1.78 7 - 2018 REFUNDING 2008 SERIES A
03/01/22
---
03/31/22
---
---
30 1
---
---
---
4.64 4.64
4.64 8 - 2016 ELM PARK
03/01/22
---
03/31/22
---
---
30 1
---
---
---
453,505.84
453,505.84
453,505.84
TOTAL - CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES)
5,272,046.26
O
5,272,046.26
5,272,046.26
SCHEDULE OF INVESTMENTS
GENERAL FUND ECONOMIC RESERVE (RESTRICTED FUNDS) - REF: M MARCH 2022
SCHEDULE OF INVESTMENTS
MARCH 2022
SCHEDULE OF INVESTMENTS
PUBLIC AGENCY RETIREMENT - OPEB (RESTRICTED FUNDS) - REF: N CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES) - REF: O MARCH 2022
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
MONTHS
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
REMAINING
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
CASH WITH FISCAL AGENTS - RUA (CONCESSION AGREEMENT)
1 - RIALTO TRUST AND RUA LOCKBOX ACCOUNTS
03/01/22
---
03/31/22
---
---
30 1
---
---
---
5,654,756.18
5,654,756.18
5,654,756.18
2 - WASTEWATER ACCOUNTS
03/01/22
---
03/31/22
---
---
30 1
---
---
---
9,811,661.81
9,811,661.81
9,572,088.69
3 - WATER ACCOUNTS
03/01/22
---
03/31/22
---
---
30 1
---
---
---
7,134,935.97
7,134,935.97
7,005,405.57
TOTAL - CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT) 22,601,353.96
P
22,601,353.96
22,232,250.44
NOTE. P2. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 03/31/2022, INCLUDES CASH AND INVESTMENTS OF $273,186.71 AND $6,144,000.00 RESPECTIVELY.
NOTE. P3. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 03/31/2022, INCLUDES CASH AND INVESTMENTS OF $327,681.00 AND $3,348,000.00 RESPECTIVELY.
REF
234,357,129.43
G
7,656,957.53
H
25,231,867.24
I
187,730.99
J
322,338.98
K
163,922.55
L
25,776,726.53
M
27,704,813.22
N
5,272,046.26
O
22,601,353.96
P
349,274,886.69
(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
MARCH 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 - 02/28/22
03/31/22
TOTAL
TO DATE
535,351.09
181,354.45
716,705.54
631.54
427.11
1,058.65
39,657.15
5,250.41
44,907.56
8.96 10.27
19.23 (39,840.90)
(37,496.62)
(77,337.52)
2,175.08
2.23 2,177.31
11.15 1.28
12.43 (4,924.04)
-
(4,924.04)
1,662,908.51
50,902.70
1,713,811.21
205.12
33.82 238.94
29,332.81
191.20
29,524.01
TOTAL
2,225,516.47
200,676.85
2,426,193.32
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
186,256.94
50,902.70
8,572.56
228,587.08
04/30/22
0.00 05/31/22
0.00 06/30/22
0.00 TOTAL- PUBLIC AGENCY RETIREMENT OPEB
(RESTRICTED FUNDS)
(2,048,694.92)
1,713,811.21
70,295.40
(405,179.11)
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
MARCH 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.
REFERENCE: O
ISSUE
Account
Account
Fund
Security
Bank Balance
Ref
(cost)
C.O.P.S. 2007 - US BANK
Fees Account
6711833500
******3500
520
Blackrock Prov T-Fund
0.00 Revenue Fund
6711833501
******3501
520
Blackrock Prov T-Fund
0.00 Lease Payment Fund
6711833502
******3502
520
Blackrock Prov T-Fund
0.00 Prepayment Fund
6711833503
******3503
520
Blackrock Prov T-Fund
0.00 Total
0.00 RSA 2008 SERIES B - US BANK
Fees Account
6711841500
******1500
343
Blackrock Prov T-Fund
0.00 Special Fund
6711841501
******1501
343
Blackrock Prov T-Fund
4.82 Interest Account
6711841502
******1502
343
Blackrock Prov T-Fund
0.00 Principal Account
6711841503
******1503
343
Blackrock Prov T-Fund
0.00 Reserve Account
6711841504
******1504
343
Blackrock Prov T-Fund
2,960,087.61
Total
2,960,092.43
RSA 2008 SERIES C - US BANK
Fees Account
6711841600
******1600
343
Blackrock Prov T-Fund
0.00 Special Fund
6711841601
******1601
343
Blackrock Prov T-Fund
3.55 Interest Account
6711841602
******1602
343
Blackrock Prov T-Fund
0.00 Principal Account
6711841603
******1603
343
Blackrock Prov T-Fund
0.00 Reserve Account
6711841604
******1604
343
Blackrock Prov T-Fund
1,858,430.01
Total
1,858,433.56
RSA 2014 SERIES A - US BANK
Fees Account
6712100600
******0600
343
Blackrock Prov T-Fund
0.00 Special Fund
6712100601
******0601
343
Blackrock Prov T-Fund
1.20 Interest Account
6712100602
******0602
343
Blackrock Prov T-Fund
0.00 Principal Account
6712100603
******0603
343
Blackrock Prov T-Fund
0.00 Reserve Account
6712100604
******0604
343
Blackrock Prov T-Fund
1.00 Redemption Fund
6712100605
******0605
343
Blackrock Prov T-Fund
0.00 Total
2.20 CITY OF RIALTO
CASH W/FISCAL AGENTS
(RESTRICTED BOND ISSUES)
TRUSTEE BALANCES AS OF 03/31/2022
REFERENCE: O
ISSUE
Account
Account
Fund
Security
Bank Balance
Ref
(cost)
CITY OF RIALTO
CASH W/FISCAL AGENTS
(RESTRICTED BOND ISSUES)
TRUSTEE BALANCES AS OF 03/31/2022
RSA 2015 SERIES A & B - US BANK
Fees Account
6712139300
******9300
343
Blackrock Prov T-Fund
0.00 Special Fund
6712139301
******9301
343
Blackrock Prov T-Fund
3.81 Interest Account
6712139302
******9302
343
Blackrock Prov T-Fund
0.00 Principal Account
6712139303
******9303
343
Blackrock Prov T-Fund
0.00 Reserve Account
6712139304
******9304
343
Blackrock Prov T-Fund
2.00 Redemption Fund
6712139305
******9305
343
Blackrock Prov T-Fund
0.00 Total
5.81 RSA 2015 SERIES C - US BANK
Fees Account
6712139400
******9400
343
Blackrock Prov T-Fund
0.00 Special Fund
6712139401
******9401
343
Blackrock Prov T-Fund
0.78 Interest Account
6712139402
******9402
343
Blackrock Prov T-Fund
0.00 Principal Account
6712139403
******9403
343
Blackrock Prov T-Fund
0.00 Reserve Account
6712139404
******9404
343
Blackrock Prov T-Fund
1.00 Redemption Fund
6712139405
******9405
343
Blackrock Prov T-Fund
0.00 Total
1.78 RSA 2018 REFUNDING 2008 SERIES A - US BANK
Fees Account
6712214700
******4700
343
Blackrock Prov T-Fund
0.00 Special Fund
6712214701
******4701
343
Blackrock Prov T-Fund
3.64 Interest Account
6712214702
******4702
343
Blackrock Prov T-Fund
0.00 Principal Account
6712214703
******4703
343
Blackrock Prov T-Fund
0.00 Reserve Account
6712214704
******4704
343
Blackrock Prov T-Fund
1.00 Total
4.64 ELM PARK SERIES 2016 - US BANK
Special Tax Fund
215615000
******5000
871
T-Fund
0.49 Interest Account
215615001
******5001
871
T-Fund
13.87 Principal Account
215615002
******5002
871
T-Fund
0.00 Reserve Account
215615003
******5003
871
T-Fund
453,489.58
Admin Expense Account
215615004
******5004
871
T-Fund
0.00 Surplus Account
215615005
******5005
871
T-Fund
1.90 Redemption Fund
215615007
******5007
871
T-Fund
0.00 Total
453,505.84
TOTAL - CASH W/FISCAL AGENTS
(RESTRICTED BOND ISSUES)
5,272,046.26
O
CITY OF RIALTO
C.O.P.S. SERIES 2007
Account No.
******3500
******3501
******3502
******3503
Account Description
Fee Acct.
Revenue Fund
Lease Payment Fund
Prepayment Fund
Total
Balance 07/01/2021
-
5,373.00
-
-
5,373.00
Interest
July
-
-
-
-
-
August
-
-
-
-
-
September
-
-
-
-
-
October
-
-
-
-
-
November
-
-
-
-
-
December
-
-
-
-
-
January
-
-
-
-
-
February
-
-
-
-
-
March
-
-
-
-
-
April
-
-
-
-
-
May
-
-
-
-
-
June
-
-
-
-
-
Total Interest
-
-
-
-
-
Debt Service
Wire In
275,373.00
275,373.00
Debt Service - Principal
(270,000.00)
(270,000.00)
Debt Service - Interest
(10,746.00)
(10,746.00)
Wire In
-
Debt Service - Principal
-
Debt Service - Interest
-
Transfers
Paid to City of Rialto
-
Wire Transfer
-
Other Transactions
To/From ******3502
(280,746.00)
280,746.00
-
To/From ******3503
-
To/From ******3504
-
To/From ******3501
-
Payment from City of Rialto
-
Invoices Paid
-
Balance 03/31/2022
-
-
-
-
-
NOTE: The activity shown above is cumulative throughout the months of 07/2021 - 06/2022.
CITY OF RIALTO
RSA 2008 SERIES B
Account No.
******1500
******1501
******1502
******1503
******1504
Account Description
Fee Acct.
Special Fund
Interest Account
Principal Account
Reserve Account
Total
Balance 07/01/2021
-
3.05 0.00
0.00 2,960,255.50
2,960,258.55
Interest
July
-
-
-
-
12.30 12.30
August
-
-
-
-
12.71 12.71
September
-
1.44 0.74
0.49 12.83
15.50 October
-
-
-
-
12.42 12.42
November
-
-
-
-
12.79 12.79
December
-
-
-
-
12.31 12.31
January
-
-
-
-
12.84 12.84
February
-
1.45 -
-
12.83 14.28
March
-
2.53 0.84
-
11.59 14.96
April
-
-
-
-
-
-
May
-
-
-
-
-
-
June
-
-
-
-
-
-
Total Interest
-
5.42 1.58
0.49 112.62
120.11
Debt Service
Wire In
1,473,041.65
1,473,041.65
Debt Service - Principal
(590,000.00)
(590,000.00)
Debt Service - Interest
(883,312.50)
(883,312.50)
Wire In
861,172.12
861,172.12
Debt Service - Principal
-
Debt Service - Interest
(861,187.50)
(861,187.50)
Wire In
-
Debt Service - Principal
-
Debt Service - Interest
-
Other Transactions
To/From ******1501
282.58
(282.09)
(0.49)
0.00 To/From ******1502
(1,744,500.00)
1,744,500.00
-
To/From ******1503
(590,000.00)
590,000.00
-
To/From ******1504
280.51
(280.51)
-
To/From ******1505
-
To/From ******1605
-
To/From 7-00003-00-5
-
Payment from RSA
-
Balance 03/31/2022
-
4.82 (0.00)
0.00 2,960,087.61
2,960,092.43
NOTE: The activity shown above is cumulative throughout the months of 07/2021 - 06/2022.
CITY OF RIALTO
RSA 2008 SERIES C
Account No.
******1600
******1601
******1602
******1603
******1604
Account Description
Fee Acct.
Special Fund
Interest Account
Principal Account
Reserve Account
Total
Balance 07/01/2021
-
2.25 (0.00)
0.00 1,858,535.28
1,858,537.53
Interest
July
-
-
-
-
7.80 7.80
August
-
-
-
-
8.06 8.06
September
-
1.17 0.55
0.46 8.06
10.24 October
-
-
-
-
7.79 7.79
November
-
-
-
-
8.03 8.03
December
-
-
-
-
7.73 7.73
January
-
-
-
-
8.06 8.06
February
-
1.07 -
-
8.06 9.13
March
-
1.86 0.62
-
7.28 9.76
April
-
-
-
-
-
-
May
-
-
-
-
-
-
June
-
-
-
-
-
-
Total Interest
-
4.10 1.17
0.46 70.87
76.60 Debt Service
Wire In
1,199,954.67
1,199,954.67
Debt Service - Principal
(545,000.00)
(545,000.00)
Debt Service - Interest
(655,125.00)
(655,125.00)
Wire In
634,677.26
634,677.26
Debt Service - Principal
-
Debt Service - Interest
(634,687.50)
(634,687.50)
Wire In
-
Debt Service - Principal
-
Debt Service - Interest
-
Other Transactions
To/From ******1601
177.77
(177.31)
(0.46)
0.00 To/From ******1602
(1,289,812.50)
1,289,812.50
-
To/From ******1603
(545,000.00)
545,000.00
-
To/From ******1604
176.14
(176.14)
-
To/From ******1605
-
To/From ******6801
-
To/From ******1505
-
To/From 7-00003-00-5
-
Invoices Paid
-
Balance 03/31/2022
-
3.55 (0.00)
0.00 1,858,430.01
1,858,433.56
NOTE: The activity shown above is cumulative throughout the months of 07/2021 - 06/2022.
CITY OF RIALTO
RSA 2014 SERIES A BOND
Account No.
******0600
******0601
******0602
******0603
******0604
******0605
Account Description
Fee Acct.
Special Fund
Interest Acct.
Principal Acct.
Reserve Acct.
Redemption Fund
Total
Balance 07/01/2021
-
1.85 -
-
1.00 -
2.85 Interest
July
-
-
-
-
-
-
-
August
-
-
-
-
-
-
-
September
-
1.45 0.24
1.21 -
-
2.90 October
-
-
-
-
-
-
-
November
-
-
-
-
-
-
-
December
-
-
-
-
-
-
-
January
-
-
-
-
-
-
-
February
-
0.36 -
-
-
-
0.36 March
-
0.63 0.21
-
-
-
0.84 April
-
-
-
-
-
-
-
May
-
-
-
-
-
-
-
June
-
-
-
-
-
-
-
Total Interest
-
2.44 0.45
1.21 -
-
4.10 Debt Service
Wire In
1,486,349.15
1,486,349.15
Debt Service - Principal
(1,240,000.00)
(1,240,000.00)
Debt Service - Interest
(246,350.00)
(246,350.00)
Wire In
215,347.10
215,347.10
Debt Service - Principal
-
Debt Service - Interest
(215,350.00)
(215,350.00)
Wire In
-
Debt Service - Principal
-
Debt Service - Interest
-
Other Transactions
To/From ******0601
1.66 (0.45)
(1.21)
-
To/From ******0602
(461,700.00)
461,700.00
-
To/From ******0603
(1,240,000.00)
1,240,000.00
-
To/From ******0606
-
To/From ******0607
-
To/From ******0608
-
Payment from RSA
-
Muni Bond Ins. Policy
(1.00)
(1.00)
Invoices Paid
-
Balance 03/31/2022
-
1.20 (0.00)
0.00 1.00
-
2.20 NOTE: The activity shown above is cumulative throughout the months of 07/2021 - 06/2022.
CITY OF RIALTO
RSA 2015 SERIES A & B BOND
Account No. New
******9300
******9301
******9302
******9303
******9304
******9305
Account Description
Fee Acct.
Special Fund
Interest Acct.
Principal Acct.
Reserve Acct.
Redemption Fund
Total
Balance 07/01/2021
0.00 4.40
0.00 0.00
2.00 0.00
6.40 Interest
July
-
-
-
-
-
-
-
August
-
-
-
-
-
-
-
September
-
1.72 0.68
1.04 -
-
3.44 October
-
-
-
-
-
-
-
November
-
-
-
-
-
-
-
December
-
-
-
-
-
-
-
January
-
-
-
-
-
-
-
February
-
1.14 -
-
-
-
1.14 March
-
2.00 0.67
-
-
-
2.67 April
-
-
-
-
-
-
-
May
-
-
-
-
-
-
-
June
-
-
-
-
-
-
-
Total Interest
-
4.86 1.35
1.04 -
-
7.25 Debt Service
Wire In
1,289,368.75
1,289,368.75
Wire In
468,922.60
468,922.60
Debt Service - Series A Principal
(1,060,000.00)
(1,060,000.00)
Debt Service - Series A Interest
(468,925.00)
(468,925.00)
Debt Service - Series B Principal
-
Debt Service - Series B Interest
(229,368.75)
(229,368.75)
Wire In
210,818.75
210,818.75
Wire In
468,921.56
468,921.56
Debt Service - Series A Principal
-
Debt Service - Series A Interest
(468,925.00)
(468,925.00)
Debt Service - Series B Principal
-
Debt Service - Series B Interest
(210,818.75)
(210,818.75)
Other Transactions
To/From ******9301
2.39 (1.35)
(1.04)
-
To/From ******9302
(1,378,037.50)
1,378,037.50
-
To/From ******9303
(1,060,000.00)
1,060,000.00
-
To/From ******9306
-
To/From ******9307
-
To/From ******9308
-
Payment from RSA
-
Muni Bond Ins. Policy
(2.00)
(2.00)
Balance 03/31/2022
-
3.81 0.00
0.00 2.00
-
5.81 NOTE: The activity shown above is cumulative throughout the months of 07/2021 - 06/2022.
CITY OF RIALTO
RSA 2015 SERIES C BOND
Account No.
******9400
******9401
******9402
******9403
******9404
******9405
Account Description
Fee Acct.
Special Fund
Interest Acct.
Principal Acct.
Reserve Acct.
Redemption Fund
Total
Balance 07/01/2021
-
1.50 0.00
(0.00)
1.00 -
2.50 Interest
July
-
-
-
-
-
-
-
August
-
-
-
-
-
-
-
September
-
0.55 0.14
0.41 -
-
1.10 October
-
-
-
-
-
-
-
November
-
-
-
-
-
-
-
December
-
-
-
-
-
-
-
January
-
-
-
-
-
-
-
February
-
0.23 -
-
-
-
0.23 March
-
0.41 0.14
-
-
-
0.55 April
-
-
-
-
-
-
-
May
-
-
-
-
-
-
-
June
-
-
-
-
-
-
-
Total Interest
0.00 1.19
0.28 0.41
0.00 0.00
1.88 Debt Service
Wire In
561,370.90
561,370.90
Debt Service - Principal
(415,000.00)
(415,000.00)
Debt Service - Interest
(146,371.40)
(146,371.40)
Wire In
139,107.80
139,107.80
Debt Service - Principal
-
Debt Service - Interest
(139,108.90)
(139,108.90)
Wire In
-
Debt Service - Principal
-
Debt Service - Interest
-
Other Transactions
To/From ******9401
0.69 (0.28)
(0.41)
-
To/From ******9402
(285,480.30)
285,480.30
-
To/From ******9403
(415,000.00)
415,000.00
-
To/From ******9404
-
To/From ******9406
-
To/From ******9407
-
Muni Bond Ins. Policy
(1.00)
(1.00)
Invoices Paid
-
Balance 03/31/2022
-
0.78 0.00
(0.00)
1.00 -
1.78 NOTE: The activity shown above is cumulative throughout the months of 07/2021 - 06/2022.
CITY OF RIALTO
RSA 2018 RFUNDING 2008 SERIES A
Account No.
******4700
******4701
******4702
******4703
******4704
Account Description
Fee Acct.
Special Fund
Interest Account
Principal Account
Reserve Account
Total
Balance 07/01/2021
-
2.30 -
(0.00)
1.00 3.30
Interest/(Accrued Interest)
July
-
-
-
-
-
-
August
-
-
-
-
-
-
September
-
1.39 0.65
0.44 -
2.48 October
-
-
-
-
-
-
November
-
-
-
-
-
-
December
-
-
-
-
-
-
January
-
-
-
-
-
-
February
-
1.09 -
-
-
1.09 March
-
1.91 0.64
-
-
2.55 April
-
-
-
-
-
-
May
-
-
-
-
-
-
June
-
-
-
-
-
-
Total Interest
-
4.39 1.29
0.44 -
6.12 Debt Service
Wire In
1,107,747.70
1,107,747.70
Debt Service - Principal
(445,000.00)
(445,000.00)
Debt Service - Interest
(662,750.00)
(662,750.00)
Wire In
651,622.52
651,622.52
Debt Service - Principal
-
Debt Service - Interest
(651,625.00)
(651,625.00)
Wire
-
Debt Service - Principal
-
Debt Service - Interest
-
Other Transactions
To/From ******1401
-
To/From ******1404
-
To/From ******4701
1.73 (1.29)
(0.44)
-
To/From ******4702
(1,314,375.00)
1,314,375.00
-
To/From ******4703
(445,000.00)
445,000.00
-
To/From ******4705
-
To/From ******4706
-
Payment from RSA
2,500.00
2,500.00
Invoices Paid
(2,500.00)
(2,500.00)
Balance 03/31/2022
-
3.64 (0.00)
(0.00)
1.00 4.64
NOTE: The activity shown above is cumulative throughout the months of 07/2021 - 06/2022.
NOTE: RSA 2018 Refunded RSA 2008 Series A, 09/2018.
CITY OF RIALTO
ELM PARK BONDS SERIES 2016
Account No.
******5000
******5001
******5002
******5003
******5004
******5005
******5007
Account Description
Special Tax
Interest Acct.
Principal
Reserve
Admin Exp.
Surplus
Redemption
Total
Balance 07/01/2021
0.07 13.72
0.00 453,496.45
0.00 0.00
0.00 453,510.24
Interest
July
-
-
-
2.23 -
-
-
2.23 August
0.67 -
-
2.31 -
-
-
2.98 September
1.23 -
-
2.32 -
-
-
3.55 October
-
-
-
2.23 -
-
-
2.23 November
-
-
-
2.31 -
-
-
2.31 December
-
-
-
2.29 -
-
-
2.29 January
-
-
-
2.31 -
-
-
2.31 February
0.18 -
-
2.31 -
-
-
2.49 March
0.31 0.10
-
2.08 -
-
-
2.49 April
-
-
-
-
-
-
-
-
May
-
-
-
-
-
-
-
-
June
-
-
-
-
-
-
-
-
Total Interest
2.39 0.10
0.00 20.39
0.00 0.00
0.00 22.88
Debt Service
Wire In
240,992.48
240,992.48
Debt Service - Principal
(150,000.00)
(150,000.00)
Debt Service - Interest
(91,006.27)
(91,006.27)
Wire In
89,117.78
89,117.78
Debt Service - Principal
-
Debt Service - Interest
(89,131.27)
(89,131.27)
Transfers
Transfer In Wire ACH
-
To/From 104310000
-
To/From 104310004
-
To/From 104310005
-
To/From 104310006
-
To/From ******5000
27.21 (27.21)
-
To/From ******5001
(180,137.54)
180,137.54
-
To/From ******5002
(150,000.00)
150,000.00
-
To/From ******5003
27.26 (27.26)
-
To/From ******5005
(1.90)
1.90 -
To/From 218483000
-
-
Invoices Paid
-
Balance 03/31/2022
0.49 13.87
-
453,489.58
-
1.90 -
453,505.84
NOTE: The activity shown above is cumulative throughout the months of 07/2021 - 06/2022.
Issue
Account
Security
Bank Balance
Bank Balance
Bank Balance
Ref
(Cost)
(Par Value)
(Market Value)
RIALTO TRUST AND RUA LOCKBOX ACCOUNTS
RUA LOCKBOX
******4459
N/A
181,598.07
181,598.07
181,598.07
MASTER REVENUE
******5001
N/A
5,470,031.33
5,470,031.33
5,470,031.33
ENVIRONMENTAL COMPLIANCE
******5002
N/A
3,068.82
3,068.82
3,068.82
REGULATORY COMPLIANCE
******5003
N/A
-
-
-
POST TERMINATION REVENUE
******5030
N/A
-
-
-
EXCLUDED
******5031
N/A
57.96 57.96
57.96 PRE-EXISTING
******5032
N/A
-
-
-
Total
5,654,756.18
5,654,756.18
5,654,756.18
WASTEWATER ACCOUNTS
WASTEWATER RATE STABILIZATION
******5004
N/A
-
-
-
WASTEWATER MASTER
******5006
N/A
-
-
-
WASTEWATER OPERATING
******5008
N/A
-
-
-
WASTEWATER FACILITY AUTHORITY EXPENSE
******5010
N/A
552,603.82
552,603.82
552,603.82
WASTEWATER OPERATING R & R
******5012
N/A
1,448,930.29
1,448,930.29
1,448,930.29
WASTEWATER CAPITAL CHARGES
******5014
N/A
-
-
-
WASTEWATER RESERVE
******5016
N/A
273,186.71
273,186.71
273,186.71
P2
WASTEWATER RESERVE
******5016
CD'S
6,144,000.00
6,144,000.00
5,904,426.88
P2
WASTEWATER INTERIM RETENTION
******5018
N/A
738,745.85
738,745.85
738,745.85
WASTEWATER SURPLUS
******5020
N/A
-
-
-
WASTEWATER CONST. RESTRICTED
******5022
N/A
610,600.73
610,600.73
610,600.73
WASTEWATER CONST. UNRESTRICTED
******5023
N/A
43,594.41
43,594.41
43,594.41
WASTEWATER TAKINGS
******5026
N/A
-
-
-
WASTEWATER LOSS PROCEEDS
******5028
N/A
-
-
-
Total
9,811,661.81
9,811,661.81
9,572,088.69
WATER ACCOUNTS
WATER RATE STABILIZATION
******5005
N/A
700,033.70
700,033.70
700,033.70
WATER MASTER
******5007
N/A
-
-
-
WATER OPERATING
******5009
N/A
-
-
-
WATER FACILITY AUTHORITY EXPENSE
******5011
N/A
879,883.34
879,883.34
879,883.34
WATER OPERATING R & R
******5013
N/A
1,418,382.32
1,418,382.32
1,418,382.32
WATER CAPITAL CHARGES
******5015
N/A
-
-
-
WATER RESERVE
******5017
N/A
327,681.00
327,681.00
327,681.00
P3
WATER RESERVE
******5017
CD'S
3,348,000.00
3,348,000.00
3,218,469.60
P3
WATER INTERIM RETENTION
******5019
N/A
431,599.07
431,599.07
431,599.07
WATER SURPLUS
******5021
N/A
-
-
-
WATER CONST. RESTRICTED
******5024
N/A
4,355.24
4,355.24
4,355.24
WATER CONST. UNRESTRICTED
******5025
N/A
-
-
-
WATER TAKINGS
******5027
N/A
-
-
-
WATER LOSS PROCEEDS
******5029
N/A
25,001.30
25,001.30
25,001.30
Total
7,134,935.97
7,134,935.97
7,005,405.57
TOTAL CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT) 22,601,353.96
22,601,353.96
22,232,250.44
P
CITY OF RIALTO
CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT)
REFERENCE: P
NOTE. P2. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 03/31/2022, INCLUDES CASH AND INVESTMENTS OF $273,186.71 AND $6,144,000.00 RESPECTIVELY.
NOTE. P3. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 03/31/2022, INCLUDES CASH AND INVESTMENTS OF $327,681.00 AND $3,348,000.00 RESPECTIVELY.
CITY OF RIALTO
RIALTO TRUST AND RUA LOCKBOX ACCOUNTS
Account No.
******4459
******5001
******5002
******5003
******5030
******5031
******5032
Account Description
MASTER
ENVIRONMENTAL
REGULATORY
POST TERM
EXCLUDED
PRE-EXISTING
Total
LOCKBOX
REVENUE
COMP
COMP
REV
ACCT
Bal 07/01/2021
155,037.40
5,048,619.92
3,068.64
-
-
-
-
5,206,725.96
Interest
July
-
-
-
-
-
-
-
-
August
-
-
-
-
-
-
-
-
September
-
1.64 0.01
-
-
8.52 -
10.17 October
-
21.00 0.03
-
-
28.44 -
49.47 November
-
23.29 0.03
-
-
19.91 -
43.23 December
-
26.88 0.03
-
-
-
-
26.91 January
-
28.63 0.03
-
-
-
-
28.66 February
-
26.73 0.03
-
-
0.27 -
27.03 March
-
27.37 0.02
-
-
-
-
27.39 April
-
-
-
-
-
-
-
-
May
-
-
-
-
-
-
-
-
June
-
-
-
-
-
-
-
-
Total Interest
-
155.54
0.18 -
-
57.14 -
212.86
Debt Service
Wire In
-
Debt Service - Principal
-
Debt Service - Interest
-
Other Transactions
PAID TO/FROM ******5001
-
PAID TO/FROM ******5002
-
PAID TO/FROM ******5006
(20,483,597.22)
(20,483,597.22)
PAID TO/FROM ******5007
(11,280,157.69)
(11,280,157.69)
PAID TO/FROM ******5010
-
PAID TO/FROM ******5011
-
PAID TO/FROM ******5020
1,462,389.99
1,462,389.99
PAID TO/FROM ******5021
537,610.83
537,610.83
PAID TO/FROM ******5022
(106,019.31)
(106,019.31)
PAID TO/FROM ******5024
-
PAID TO/FROM ******5101
-
PAID TO/FROM ******5600
-
PAID TO CITY OF RIALTO
(2,068,301.38)
(5,459,460.81)
(7,527,762.19)
RECEIVED FROM RUA ******4459
(34,528,067.23)
34,528,067.23
-
RECEIVED FROM VEOLIA CHEMICAL REIMB.
-
RECEIVED FROM CITY OF RIALTO
3,459,460.81
3,459,460.81
INVOICES PAID & VOIDED CHECKS
(168,735.76)
(168,735.76)
DEPOSITS
34,677,303.16
34,677,303.16
DEPOSITS - WIRE
-
NSF & CHARGE BACK
(122,675.26)
(122,675.26)
Balance 03/31/2022
181,598.07
5,470,031.33
3,068.82
-
-
57.96 -
5,654,756.18
NOTE: The activity shown above is cumulative throughout the months of 07/2021 - 06/2022.
CITY OF RIALTO
WASTEWATER ACCOUNTS
Account No.
******5004
******5006
******5008
******5010
******5012
******5014
******5016
******5018
******5020
******5022
******5023
******5026
******5028
Account Description
WASTE
WASTE
WASTE
WASTE
WASTE
WASTE
WASTE
WASTE
WASTE
WASTE
WASTE
WASTE
TOTAL
RATE STAB
MASTER
OPER
FACILITY EXP
OP R&R
CAP CHARGES
RESERVE
INTERIM RET
SURPLUS
CONST RESTRIC
CONST UNRESTRIC
TAKINGS
LOSS PROCEEDS
Bal 07/01/2021
-
0.00 -
600,626.77
1,410,390.77
-
6,398,542.47
1,072,320.03
897,762.06
161,186.38
43,592.14
-
-
10,584,420.62
Interest/
(Accrued Interest)/
Adjustment on Current Year
Market Discount
July
-
-
August
(24.46)
(24.46)
September
2.01 3.49
117.16
0.07 2.85
0.11 125.69
October
9.01 11.99
114.20
0.02 9.50
0.36 145.08
November
7.70 12.76
118.01
1.94 9.82
0.37 150.60
December
8.38 12.76
151.39
1.24 9.59
0.36 183.72
January
7.77 12.08
118.02
4.83 0.15
8.06 0.37
151.28
February
6.90 12.39
17,943.26
3.53 0.31
8.90 0.37
17,975.66
March
6.51 10.78
106.66
4.26 5.32
0.33 133.86
April
-
-
May
-
-
June
-
Total Interest
-
-
-
48.28 76.25
-
18,644.24
15.89 0.46
54.04 2.27
-
-
18,841.43
Debt Service
Wire In
-
Debt Service - Principal
-
Debt Service - Interest
-
Other Transactions
PAID TO/FROM ******5001
20,483,597.22
106,019.31
20,589,616.53
PAID TO/FROM ******5004
-
PAID TO/FROM ******5006
-
PAID TO/FROM ******5007
-
PAID TO/FROM ******5008
(6,100,953.17)
6,100,953.17
-
PAID TO/FROM ******5010
(2,627,404.91)
2,627,404.91
-
PAID TO/FROM ******5012
(393,750.00)
393,750.00
-
PAID TO/FROM ******5014
(9,511,499.97)
9,511,499.97
-
PAID TO/FROM ******5016
-
PAID TO/FROM ******5018
(1,849,989.17)
1,849,989.17
-
PAID TO/FROM ******5020
(2,183,579.24)
2,183,579.24
-
PAID TO/FROM ******5023
-
PAID TO/FROM ******5031
(3,081,341.76)
(3,081,341.76)
PAID TO/FROM ******5032
-
PAID TO/FROM ******5101
(6,100,953.17)
(9,511,499.97)
(15,612,453.14)
PAID TO/FROM ******5106
(837,307.86)
(837,307.86)
PAID TO/FROM ******5108
(355,286.73)
(355,286.73)
PAID TO CITY OF RIALTO
1,180,648.86
1,180,648.86
INVOICES PAID
(2,675,476.14)
(2,675,476.14)
M2
Balance 03/31/2022
-
0.00 -
552,603.82
1,448,930.29
-
6,417,186.71
738,745.85
0.00 610,600.73
43,594.41
-
-
9,811,661.81
NOTE. P2
. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 03/31/2022, INCLUDES CASH AND INVESTMENTS OF $273,186.71 AND $6,144,000.00 RESPECTIVELY.
NOTE
: THE ACTIVITY SHOWN ABOVE IS CUMULATIVE THROUGHOUT THE MONTHS OF 07/2021 - 06/2022.
CITY OF RIALTO
WATER ACCOUNTS
Account No.
******5005
******5007
******5009
******5011
******5013
******5015
******5017
******5019
******5021
******5024
******5025
******5027
******5029
Account Description
WATER
WATER
WATER
WATER
WATER
WATER
WATER
WATER
WATER
WATER
WATER
WATER
Total
RATE STAB
MASTER
OPERATING
FACILITY EXP
OPER R&R
CAP CHARGES
RESERVE
INTERIM RET
SURPLUS
CONST RESTRIC
CONST UNRESTRIC
TAKINGS
LOSS PROCEEDS
Bal 07/01/2021
1,500,000.00
0.00 0.00
784,335.49
1,462,526.67
0.00 3,614,370.41
122,116.75
102,237.94
4,355.00
0.00 0.00
25,000.00
7,614,942.26
Interest/
(Accrued Interest)/
Adjustment on Current Year
Market Discount
July
0.00 August
(4.76)
(4.76)
September
3.38 3.53
0.74 0.20
0.01 0.06
7.92 October
12.47 11.62
2.48 0.02
0.04 0.21
26.84 November
11.54 11.61
2.57 0.10
0.04 0.21
26.07 December
10.11 11.49
11.18 26.05
0.49 0.04
0.21 59.57
January
11.89 8.32
11.62 2.67
3.73 0.12
0.04 0.21
38.60 February
6.33 8.51
11.82 10,254.26
4.12 0.24
0.04 0.21
10,285.53
March
5.37 8.55
10.69 2.47
2.65 0.03
0.19 29.95
April
0.00 May
0.00 June
0.00 Total Interest
33.70 0.00
0.00 64.26
72.07 0.00
10,286.48
11.31 0.36
0.24 0.00
0.00 1.30
10,469.72
Debt Service
Wire In
0.00 Debt Service - Principal
0.00 Debt Service - Interest
0.00 Other Transactions
PAID TO/FROM ******5001
11,359,421.74
11,359,421.74
PAID TO/FROM ******5002
0.00 PAID TO/FROM ******5005
0.00 PAID TO/FROM ******5006
0.00 PAID TO/FROM ******5007
(2,200,000.00)
2,200,000.00
0.00 PAID TO/FROM ******5009
(5,115,130.58)
5,115,130.58
0.00 PAID TO/FROM ******5010
(3,328,650.39)
3,328,650.39
0.00 PAID TO/FROM ******5011
(225,000.00)
225,000.00
0.00 PAID TO/FROM ******5013
(2,175,000.03)
2,175,000.03
0.00 PAID TO/FROM ******5015
(51,024.11)
51,024.11
0.00 PAID TO/FROM ******5017
0.00 PAID TO/FROM ******5018
0.00 PAID TO/FROM ******5019
(2,664,616.63)
2,585,352.58
(79,264.05)
PAID TO/FROM ******5021
(2,275,881.57)
2,275,881.57
0.00 PAID TO/FROM ******5031
(2,378,119.87)
(2,378,119.87)
PAID TO/FROM ******5032
0.00 PAID TO/FROM ******5101
(5,115,130.58)
(2,175,000.03)
(7,290,130.61)
PAID TO/FROM ******5108
0.00 PAID TO/FROM ******5109
(269,216.42)
(269,216.42)
PAID TO/FROM ******5600
0.00 MISC. DEPOSIT
47.81 47.81
WIRE FROM CITY OF RIALTO
1,400,000.00
1,400,000.00
INVOICES PAID
(3,233,214.61)
(3,233,214.61)
M3
Balance 03/31/2022
700,033.70
0.00 0.00
879,883.34
1,418,382.32
0.00 3,675,681.00
431,599.07
(0.00)
4,355.24
0.00 0.00
25,001.30
7,134,935.97
NOTE. P3
. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 03/31/2022, INCLUDES CASH AND INVESTMENTS OF $327,681.00 AND $3,348,000.00 RESPECTIVELY.
NOTE
: THE ACTIVITY SHOWN ABOVE CUMULATIVE THROUGHT THE MONTHS OF 07/2021 - 06/2022.