January 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…………………………………………………………………………………………. 226,061,245.50
65%
A,G
Rialto Successor Agency (RSA) + Cash Sweep Bank Account…………………………………………………………………………………................................ 10,455,412.01
3%
B,H
Rialto Utility Authority (RUA) Pre-existing Investments + Cash Sweep Bank Account……………………………………………………………………………………………. 25,111,983.63
7%
C,I
Other Bank Accounts + Cash Sweep Bank Accounts……………………………………………………………………………………………………………………............. 1,815,453.32
1%
D,J
Escrow Accounts……………………………………………………………………………………………………………………………................................................. 14,233,176.12
4%
E
Cemetery Endowment Fund (Restricted Accounts)…………………………………………………………………........................................................................... 401,710.76
0%
F,K
Pepper Avenue Extension (Restricted Accounts)………………………………………………………………….......................................................... 324,108.85
0%
L
General Fund Economic Reserve (Restricted Funds)……………………………………………………………………............................................... 25,791,446.48
7%
M
Public Agency Retirement Services - OPEB (Restricted Funds)…………………………………………………………………….................................. 17,880,275.56
5%
N
Cash with Fiscal Agents - (Restricted Bond Issues)…………………………………………………………………………...................................................... 5,272,009.54
2%
O
Cash with Fiscal Agents - RUA (Concession Agreement)………………………………………………………………….......................................................... 22,885,954.01
7%
P
TREASURER'S PORTFOLIO
350,232,775.78
100%
TREASURER'S MONTHLY REPORT - DECEMBER 2021
The City’s Treasurer expects to have sufficient cash for the next six months , including use of General
Fund’s cash reserves.
The City of Rialto’s Investments and funds management is in compliance with the City’s Investment Policy and S tate
Mandates. Pooled Investments have liquidity below 30 days, and therefore carry Market Value at Issued Value.
Wells Fargo
Advisor
s, Clearwater Analytics and
Union Bank of California provided the Market Value of the investments held in custody.
Union
Bank of California (C
orporate Trust Dept)
and
US Bank (Corporate Trust Dept.)
provided Fiscal Agent information.
City of Rialto
TREASURER'S BANK
RECONCILIATION BALANCE SHEET
DECEMBER 2021
ACTIVE ACCOUNTS
BALANCE
REF
GENERAL BANK ACCOUNT**
(225,019.77)
A
RSA BANK ACCOUNT**
(729.25)
B
RUA BANK ACCOUNT**
(1,617.98)
C
SPORTS CENTER/POOL**------------------------------------------------------------------------------------------------------------------------------------------------ -
AMBULANCE LOCKBOX------------------------------------------------------------------------------------------------------------------------------------------------- 76,729.84
FLEXIBLE BENEFIT**------------------------------------------------------------------------------------------------------------------------------------------------------------ -
ALARM LOCKBOX--------------------------------------------------------------------------------------------------------------------------------------------------------------- 17,175.20
BANK CARD-------------------------------------------------------------------------------------------------------------------------------------------------------------- 1,390.01
PAYROLL CLEARING --------------------------------------------------------------------------------------------------------------------------------------------------- 56,931.44
LIABILITY ACCT./CARL WARREN & CO.-------------------------------------------------------------------------------------------------------------------- 2,173.45
PEPPER AVENUE--------------------------------------------------------------------------------------------------------------------------------------------------- -
WORKERS COMP/LWP CLAIMS SOLUTIONS--------------------------------------------------------------------------------------------------------------- 24,577.70
PROPERTY EVIDENCE MONIES--------------------------------------------------------------------------------------------------------------------------------- 1,486,315.92
OTHER BANK ACCOUNTS
1,665,293.56
D
ENERGY CONSERVATION PROJECT---------------------------------------------------------------------------------------------------------------------- 84,786.55
AYALA @ 210 PARTNERS LLC------------------------------------------------------------------------------------------------------------------------------------ 310,676.86
LEWIS HILLWOOD------------------------------------------------------------------------------------------------------------------------------------------------------- 2,752,592.55
ALDER AVENUE---------------------------------------------------------------------------------------------------------------------------------------------------------- 3,276,515.26
LAUREL/WALNUT/LOCUST----------------------------------------------------------------------------------------------------------------------------------------------- 2,986,952.42
SUB ACCOUNT A-------------------------------------------------------------------------------------------------------------------------------------------------------- 4,821,652.48
ESCROW ACCOUNTS
14,233,176.12
E
CEMETERY ENDOWMENT FUND------------------------------------------------------------------------------------------------------------------------------- 79,371.84
RESTRICTED ACCOUNTS
79,371.84
F
TOTAL - ACTIVE ACCOUNTS
15,750,474.52
(A-F)
Note (**) - Cash is swept into Goverment Money Market Fund Sweep Accounts with Wells Fargo to earn interest on undisbursed monies. Accounts with negative balances are due to current month's outstanding checks.
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
REMAINING LIFE
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
IN MONTHS
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
WELLS FARGO CASH SWEEP ACCOUNT
POOLED FUNDS - GENERAL
12/01/21
---
12/01/21
---
---
0 1
---
---
---
43,050,416.04
43,050,416.04
43,050,416.04
SHARES PURCHASED
12/01/21
---
12/31/21
---
---
30 1
---
---
---
20,505,672.95
20,505,672.95
20,505,672.95
SHARES REDEEMED
12/01/21
---
12/31/21
---
---
30 1
---
---
---
(19,489,817.08)
(19,489,817.08)
(19,489,817.08)
INTEREST EARNED - GENERAL FUND ACCOUNT
12/01/21
---
12/31/21
---
0.01%
30 1
---
---
---
485.94
485.94
485.94
CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) - GENERAL 12/01/21
---
12/31/21
---
---
30 1
---
---
---
(1,711.60)
(1,711.60)
(1,711.60)
SUBTOTAL
44,065,046.25
44,065,046.25
44,065,046.25
PACIFIC PREMIER BANK #0314
POOLED FUNDS - #0314
12/01/21
---
12/01/21
---
0.10%
0 0
---
---
---
5,196,680.78
5,196,680.78
5,196,680.78
BANKING FEE
12/01/21
---
12/31/21
---
---
30 1
---
---
---
(2.00)
(2.00)
(2.00)
INTEREST EARNED #0314
12/01/21
---
12/31/21
---
---
30 1
---
---
---
308.96
308.96
308.96
SUBTOTAL
5,196,987.74
5,196,987.74
5,196,987.74
PACIFIC PREMIER BANK #7667
POOLED FUNDS - #7667
12/01/21
---
12/01/21
---
0.10%
0 0
---
---
---
3,530,853.16
3,530,853.16
3,530,853.16
BANKING FEE
12/01/21
---
12/31/21
---
---
30 1
---
---
---
(32.00)
(32.00)
(32.00)
INTEREST EARNED #7667
12/01/21
---
12/31/21
---
---
30 1
---
---
---
209.92
209.92
209.92
SUBTOTAL
3,531,031.08
3,531,031.08
3,531,031.08
LAIF - CALIFORNIA STATE POOL
POOLED FUNDS - LAIF
12/01/21
---
12/31/21
---
0.22%
30 1
---
---
---
20,215,404.28
20,215,404.28
20,215,404.28
SUBTOTAL
20,215,404.28
20,215,404.28
20,215,404.28
JP MORGAN ADVISORS - GENERAL
3134GXGQ1 - FREDDIE MAC
12/07/21
03/15/22
12/15/22
0.20%
0.20%
373
12 ---
AAA
N/A
1,248,601.53
1,250,000.00
1,248,407.04
JP MORGAN ADVISORS ---TREASURY MONEY MARKET
12/01/21
---
12/31/21
---
0.01%
30 1
---
---
---
8,751,447.08
8,751,447.08
8,751,447.08
JP MORGAN ADVISORS --- CASH
12/01/21
---
12/31/21
---
---
30 1
---
---
---
0.00 0.00
0.00 SUBTOTAL
10,000,048.61
10,001,447.08
9,999,854.12
WELLS FARGO ADVISORS - CUSTODIAL
8025PZ13 - SANTANDER UK PLC CP
07/14/21
---
12/01/21
---
0.13%
140
5 ---
---
---
---
---
---
46625HJD3 - JPMORGAN CHASE & CO SR UNSECURED
09/13/17
---
01/24/22
4.50%
4.48%
1594
52 1
A2
A-
3,265,620.00
3,000,000.00
3,006,960.00
2254EBBU4 - CREDIT SUISSE NEW YORK CP
06/03/21
---
02/28/22
---
0.16%
270
9 2
P1
A1
4,544,540.00
4,550,000.00
4,548,862.50
94974BFC9 - WELLS FARGO BANK SENIOR NOTES
01/29/19
---
03/08/22
3.50%
3.48%
1134
37 2
A1
BBB+
5,044,300.00
5,000,000.00
5,028,500.00
38150AEJ0 - GOLDMAN SACHS GRP INC MTN CALLABLE
11/20/20
02/24/22
11/25/22
0.40%
0.40%
735
24 11
A2
BBB+
7,497,500.00
7,500,000.00
7,474,200.00
94973VBA4 - WELLPOINT INC SR UNSECURED
07/13/21
---
01/15/23
3.30%
3.21%
551
18 12
BAA2
A
1,566,150.00
1,500,000.00
1,539,000.00
94974BFN5 -WELLS FARGO & CO SUBORDINATED
06/03/21
---
08/15/23
4.13%
3.93%
803
26 19
A3
BBB
5,519,832.00
5,100,000.00
5,348,268.00
38150AEF8 - GOLDMAN SACH GRP MTN CALLABLE
11/20/20
02/24/22
11/24/23
0.60%
0.60%
1099
36 23
A2
BBB+
3,000,000.00
3,000,000.00
2,959,890.00
17329F6E9 - CITIGROUP GLOBAL MARKETS MTN CALLABLE
03/30/21
03/31/22
03/31/24
0.70%
0.71%
1097
36 27
A3
BBB+
8,250,000.00
8,250,000.00
8,120,062.50
02665WDS7 - AMERICAN HONDA FINANCE MTN
02/25/21
---
07/12/24
0.55%
0.55%
1233
41 30
A3
A-
3,827,410.50
3,825,000.00
3,774,854.25
45950VQE9 - INTL FINANCE CORP MTN
09/08/21
---
09/10/24
0.43%
0.43%
1098
36 32
AAA
AAA
5,000,000.00
5,000,000.00
4,924,150.00
38150AFC4 - GOLDMAN SACHS GRP INC MTN CALLABLE
03/26/21
03/20/22
09/30/24
1.00%
1.01%
1284
42 33
A2
BBB+
4,500,000.00
4,500,000.00
4,415,040.00
61761JVL0 - MORGAN STANLEY MTN SR UNSECURED
07/15/21
---
10/23/24
3.70%
3.47%
1196
39 34
A1
BBB+
5,048,828.40
4,620,000.00
4,920,069.00
38150AFM2 - GOLDMAN SACHS GRP INC MTN CALLABLE
05/10/21
05/14/22
11/12/24
1.00%
1.02%
1282
42 34
A2
BBB+
10,000,000.00
10,000,000.00
9,753,200.00
037833AZ3 - APPLE INC SR UNSECURED
02/04/21
---
02/09/25
2.50%
2.40%
1466
48 37
AAA
AA+
2,157,500.00
2,000,000.00
2,081,220.00
06048WK66 - BANK OF AMERICA CORP MULTISTEP UP MTN CALLABLE 02/04/21
03/23/22
12/23/25
0.65%
0.67%
1783
59 48
A2
A-
1,994,000.00
2,000,000.00
1,917,720.00
17290AEA4 - CITIGROUP INC. MTN CALLABLE
10/15/21
10/19/24
10/19/26
1.45%
1.46%
1830
60 58
A3
BBB+
5,000,000.00
5,000,000.00
4,937,450.00
3135G05G4 - FEDERAL NATIONAL MTG ASSN NOTES
12/02/21
---
07/10/23
0.25%
0.25%
585
19 18
AAA
AA+
3,896,901.50
3,910,000.00
3,888,690.50
3130ANZ60 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/08/21
03/27/22
06/27/25
0.40%
0.40%
1388
46 42
AAA
AA+
1,500,000.00
1,500,000.00
1,479,525.00
3130ALZA5 - FEDERAL HOME LOAN BANK MULTI STEP COUPON BONDS CALLABLE 04/13/21
01/29/22
04/29/26
0.50%
0.50%
1842
61 52
AAA
AA+
6,000,000.00
6,000,000.00
5,968,140.00
3130AMB76 - FEDERAL HOME LOAN BANK BONDS CALLABLE
05/18/21
05/18/22
05/18/26
1.25%
1.25%
1826
60 53
AAA
AA+
1,108,800.00
1,100,000.00
1,095,468.00
NOTE. G (CONTINUED TO NEXT PAGE)
City of Rialto
SCHEDULE OF INVESTMENTS
GENERAL POOLED FUNDS / INVESTMENTS - REF: G
DECEMBER 2021
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
REMAINING LIFE
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
IN MONTHS
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
City of Rialto
SCHEDULE OF INVESTMENTS
GENERAL POOLED FUNDS / INVESTMENTS - REF: G
DECEMBER 2021
3130AMKN1 - FEDERAL HOME LOAN MULTISTEP UP COUPON BONDS CALLABLE 05/18/21
02/27/22
05/27/26
0.50%
0.50%
1835
60 53
AAA
AA+
8,900,000.00
8,900,000.00
8,870,808.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 57
AAA
AA+
10,000,000.00
10,000,000.00
9,904,400.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 57
AAA
AA+
2,500,000.00
2,500,000.00
2,478,350.00
3130ANXC9 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/02/21
03/29/22
09/29/26
0.60%
0.60%
1853
61 57
AAA
AA+
5,000,000.00
5,000,000.00
4,930,800.00
78658RFR7 - SAFRA NATIONAL BANK CD
10/12/21
---
10/19/22
0.15%
0.15%
372
12 10
N.A.
N.A.
249,000.00
249,000.00
248,671.32
99000FGR3 - WORLD'S FOREMOST BANK CD
09/20/21
---
05/08/23
2.45%
2.39%
595
20 16
N.A.
N.A.
206,936.00
200,000.00
204,754.00
99000QMY7 - COMENITY BANK CD
09/23/21
---
08/15/23
2.15%
2.10%
691
23 19
N.A.
N.A.
206,372.00
200,000.00
204,546.00
05580AD92 - BMW BK N AMERICA CD
09/20/21
---
09/25/23
0.35%
0.35%
735
24 21
N.A.
N.A.
249,000.00
249,000.00
248,046.33
87165HD64 - SYNCHRONY BANK CD
09/20/21
---
09/25/23
0.40%
0.40%
735
24 21
N.A.
N.A.
249,000.00
249,000.00
248,260.47
38149MA52 - GOLDMAN SACHS BK USA CD
09/20/21
---
09/29/23
0.35%
0.35%
739
24 21
N.A.
N.A.
249,000.00
249,000.00
248,026.41
856285XP1 - STATE BANK OF INDIA CD
09/20/21
---
09/29/23
0.40%
0.40%
739
24 21
N.A.
N.A.
249,000.00
249,000.00
248,243.04
947547NE1 - WEBBANK CD
09/20/21
---
09/29/23
0.30%
0.30%
739
24 21
N.A.
N.A.
249,000.00
249,000.00
247,804.80
538036SD7 - LIVE OAK BANKING CO CD
09/21/21
---
10/02/23
0.25%
0.25%
741
24 21
N.A.
N.A.
249,000.00
249,000.00
247,575.72
649447UA5 - NEW YORK CMNTY BK CD
10/05/21
---
10/16/23
0.30%
0.30%
741
24 21
N.A.
N.A.
250,000.00
250,000.00
248,712.50
45581ECS8 - INDUSTRIAL & COM BK CD
09/21/21
---
10/18/23
0.35%
0.35%
757
25 22
N.A.
N.A.
249,000.00
249,000.00
247,929.30
06251A2J8 - BANK HAPOALIM BM NY CD
09/28/21
---
10/26/23
0.25%
0.25%
758
25 22
N.A.
N.A.
248,253.00
249,000.00
247,436.28
88241TFP6 - TEXAS EXCHANGE BK SSB CD
09/22/21
---
12/18/23
0.35%
0.35%
817
27 24
N.A.
N.A.
248,000.00
248,000.00
246,596.32
61765QQ28 - MORGAN STANLEY BK NA CD
10/01/21
---
01/08/24
0.25%
0.25%
829
27 24
N.A.
N.A.
250,000.00
250,000.00
248,520.00
47804GGX5 - JOHN MARSHALL BANK CD
09/29/21
---
06/17/24
0.25%
0.25%
992
33 30
N.A.
N.A.
243,020.40
245,000.00
241,917.90
29278TPT1 - ENERBANK USA CD
10/12/21
---
06/26/24
0.50%
0.50%
988
32 30
N.A.
N.A.
210,578.00
211,000.00
209,586.30
89235MLG4 - TOYOTA FINL SGS BK CD
09/23/21
---
08/12/24
0.60%
0.60%
1054
35 31
N.A.
N.A.
248,927.79
249,000.00
247,687.77
795451AW3 - SALLIE MAE BANK/SALT CD
09/20/21
---
09/23/24
0.70%
0.70%
1099
36 33
N.A.
N.A.
249,000.00
249,000.00
248,111.07
90348JT75 - UBS BANK USA CD
09/28/21
---
10/07/24
0.65%
0.65%
1105
36 33
N.A.
N.A.
249,000.00
249,000.00
247,690.26
59013KNU6 - MERRICK BANK CD
10/06/21
---
10/21/24
0.55%
0.55%
1111
37 34
N.A.
N.A.
249,000.00
249,000.00
246,915.87
48128WBQ7 - JP MORGAN CHASE BK NA CD
10/13/21
04/29/22
10/29/26
0.55%
0.50%
1842
61 58
N.A.
N.A.
125,000.00
125,000.00
123,403.75
53944VAS8 - LLOYDS BANK PLC SR NOTE
12/09/19
---
08/14/22
2.25%
2.22%
979
32 7
A1
A+
2,009,300.00
2,000,000.00
2,019,540.00
13605WQ79 - CANADIAN IMPERIAL BK COMM MTN CALLABLE
12/28/20
12/22/22
06/22/24
0.55%
0.56%
1272
42 30
A2
BBB+
3,000,000.00
3,000,000.00
2,922,300.00
459056HV2 - INTL BK RECON & DEVELOP SR UNSECURED
09/07/21
---
08/28/24
1.50%
1.47%
1086
36 32
AAA
AAA
1,031,750.00
1,000,000.00
1,014,350.00
89114TDD1 - TORONTO DOMINION BANK MTN CALLABLE
03/09/21
03/11/22
09/11/24
0.70%
0.71%
1282
42 32
A1
A
7,000,000.00
7,000,000.00
6,891,920.00
89114TF49 - TORONTO DOMINION BANK MTN CALLABLE
03/20/21
04/01/22
04/01/25
1.00%
1.01%
1473
48 39
A1
A
5,000,000.00
5,000,000.00
4,928,800.00
06747PKV0 - BARCLAYS BANK PLC - MTN CALLABLE
06/08/20
04/08/23
04/08/25
3.25%
3.20%
0 39
A1
A
5,136,480.00
4,920,000.00
4,990,798.80
WFA ---TREASURY MONEY MARKET
12/01/21
---
12/31/21
---
0.01%
30 1
---
---
---
2,746.64
2,746.64
2,746.64
WFA --- CASH
12/01/21
---
12/31/21
---
---
30 1
---
---
---
1.08 1.08
1.08 SUBTOTAL
143,277,747.31
141,643,747.72
141,086,519.68
TOTAL - GENERAL POOLED FUNDS / INVESTMENTS
226,286,265.27
G
224,653,664.15
224,094,843.15
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 **
12/01/21
---
12/01/21
---
---
0 0
---
---
---
7,061,896.74
7,061,896.74
7,061,896.74
SHARES PURCHASED
12/01/21
---
12/31/21
---
---
30 1
---
---
---
3,574,014.00
3,574,014.00
3,574,014.00
SHARES REDEEMED
12/01/21
---
12/31/21
---
---
30 1
---
---
---
(179,871.97)
(179,871.97)
(179,871.97)
INTEREST EARNED - WELLS FARGO
12/01/21
---
12/31/21
----
0.01%
30 1
---
---
---
102.49
102.49
102.49
TOTAL - RSA INVESTMENTS
10,456,141.26
H
10,456,141.26
10,456,141.26
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 **
12/01/21
---
12/01/21
---
---
0 0
---
---
---
5,225,183.39
5,225,183.39
5,225,183.39
SHARES PURCHASED
12/01/21
---
12/31/21
---
---
30 1
---
---
---
1,790,267.83
1,790,267.83
1,790,267.83
SHARES REDEEMED
12/01/21
---
12/31/21
---
---
30 1
---
---
---
(47,668.08)
(47,668.08)
(47,668.08)
INTEREST EARNED - WELLS FARGO
12/01/21
---
12/31/21
---
0.01%
30 1
---
---
---
78.36 78.36
78.36 SUBTOTAL
6,967,861.50
6,967,861.50
6,967,861.50
LAIF - CALIFORNIA STATE POOL
POOLED FUNDS - LAIF
12/01/21
---
12/31/21
---
0.22%
30 1
---
---
---
100,684.38
100,684.38
100,684.38
SUBTOTAL
100,684.38
100,684.38
100,684.38
WELLS FARGO ADVISORS - RUA
94974BFN5 - WELLS FARGO & CO SUBORDINATED
06/03/21
---
08/15/23
3.93%
3.91%
---
---
---
A3
BBB
974,088.00
900,000.00
943,812.00
38150AJK2 - GOLDMAN SACHS GRP INC MTN
11/22/21
05/24/22
11/24/23
1.00%
1.00%
732
24 1
A2
BBB+
3,900,000.00
3,900,000.00
3,886,935.00
02665WDS7 - AMERICAN HONDA FINANCE MTN
02/04/21
---
07/12/24
0.56%
0.56%
1254
41 21
A3
A-
3,477,991.50
3,475,000.00
3,429,442.75
3815AJ48 - GOLDMAN SACHS GRP INC MTN
10/27/21
10/29/22
10/29/24
1.15%
1.15%
1098
36 32
A2
BBB+
413,000.00
413,000.00
410,067.70
3130AMRA2 - FEDERAL HOME LOAN BANK
06/02/21
03/24/22
06/24/26
0.63%
0.63%
1848
61 36
AAA
AA+
1,000,000.00
1,000,000.00
988,200.00
83369MM74 - SOCIETE GENERALE BANK MTN
10/14/20
01/19/22
10/19/22
0.40%
0.40%
735
24 56
A1
A
2,000,000.00
2,000,000.00
1,981,940.00
13605WQ79 - CANADIAN IMPERIAL BANK COMM MTN CALLABLE
12/18/20
12/22/22
06/22/24
0.56%
0.56%
1282
42 12
A2
BBB+
270,000.00
270,000.00
263,007.00
89114TDD1 - TORONTO DOMINION BANK MTN CALLABLE
03/09/21
03/11/22
09/11/24
0.71%
0.70%
1282
42 32
A1
A
3,000,000.00
3,000,000.00
2,953,680.00
89114TF49 - TORONTO DOMINION BANK MTN CALLABLE
03/30/21
04/01/22
04/01/25
1.01%
1.01%
1463
48 34
A1
A
3,000,000.00
3,000,000.00
2,957,280.00
WFA --- TREASURY MONEY MARKET
12/01/21
---
12/31/21
---
0.01%
30 1
---
---
---
858.42
858.42
858.42
WFA --- CASH
12/01/21
---
12/31/21
---
---
30 1
---
---
---
9,117.81
9,117.81
9,117.81
SUBTOTAL
18,045,055.73
17,967,976.23
17,824,340.68
TOTAL - RUA PRE-EXISTING INVESTMENTS
25,113,601.61
I
25,036,522.11
24,892,886.56
DECEMBER 2021
SCHEDULE OF INVESTMENTS
RUA PRE-EXISTING / INVESTMENTS - REF: I
SCHEDULE OF INVESTMENTS
RSA STAGE COACH SWEEP ACCOUNT - REF: H
DECEMBER 2021
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
REMAINING LIFE
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
IN MONTHS
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
WELLS FARGO CASH SWEEP ACCOUNT - SPORTS CENTER & POOL
SPORTS CENTER & POOL ACCOUNT **
12/01/21
---
12/01/21
---
---
0 0
---
---
---
105,178.22
105,178.22
105,178.22
SHARES PURCHASED
12/01/21
---
12/31/21
---
---
30 1
---
---
---
10,580.37
10,580.37
10,580.37
SHARES REDEEMED
12/01/21
---
12/31/21
---
---
30 1
---
---
---
(176.81)
(176.81)
(176.81)
INTEREST EARNED - SPORTS CENTER &POOL ACCOUNT **
12/01/21
---
12/31/21
---
0.01%
30 1
---
---
---
1.56 1.56
1.56 CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) - SPORTS CENTER &POOL ** 12/01/21
---
12/31/21
---
---
30 1
---
---
---
59.70 59.70
59.70 SUBTOTAL
115,643.04
115,643.04
115,643.04
WELLS FARGO CASH SWEEP ACCOUNT - FLEXIBLE BENEFIT
FLEXIBLE BENEFIT ACCOUNT**
12/01/21
---
12/01/21
---
---
0 0
---
---
---
34,516.26
34,516.26
34,516.26
INTEREST EARNED - FLEXIBLE BENEFIT ACCOUNT**
12/01/21
---
12/31/21
---
0.01%
30 1
---
---
---
0.46 0.46
0.46 SUBTOTAL
34,516.72
34,516.72
34,516.72
TOTAL - OTHER BANK ACCOUNTS INVESTMENTS
150,159.76
J
150,159.76
150,159.76
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.39%
1828
60 52
A2
BBB+
320,000.00
320,000.00
310,025.60
WFA --- TREASURY MONEY MARKET
12/01/21
---
12/31/21
---
0.01%
30 1
---
---
---
100.84
100.84
100.84
WFA --- CASH
12/01/21
---
12/31/21
---
---
30 1
---
---
---
2,238.08
2,238.08
2,238.08
TOTAL - CEMETERY ENDOWMENT FUND
322,338.92
K
322,338.92
312,364.52
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 0
---
---
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 6
---
---
163,918.45
163,918.45
163,918.45
TOTAL - PEPPER AVENUE EXTENSION RESTRICTED ACCOUNTS
324,108.85
L
324,108.85
324,108.85
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
0 P1
A2
7,793,393.38
7,795,000.00
7,794,532.30
02665KB30 - AMERICAN HONDA FINANCE CP
11/08/21
---
02/03/22
---
0.16%
87 3
1 P2
A2
14,994,199.96
15,000,000.00
14,996,400.00
62479MBN2 - MUFG BANK LTD/NY CP
11/23/21
---
02/22/22
---
0.15%
91 3
2 P1
A1
2,998,862.49
3,000,000.00
2,999,400.00
WFA --- TREASURY MONEY MARKET
12/01/21
---
12/31/21
---
0.01%
30 1
---
---
---
3,843.56
3,843.56
3,843.56
WFA --- CASH
12/01/21
---
12/31/21
---
---
30 1
---
---
---
1,147.09
1,147.09
1,147.09
SUBTOTAL
25,791,446.48
25,799,990.65
25,795,322.95
TOTAL - GENERAL FUND ECONOMIC RESERVE
25,791,446.48
M
25,799,990.65
25,795,322.95
SCHEDULE OF INVESTMENTS
OTHER BANK ACCOUNTS - CASH SWEEP ACCOUNTS - REF: J
DECEMBER 2021
DECEMBER 2021
SCHEDULE OF INVESTMENTS
PEPPER AVENUE EXTENSION (RESTRICTED FUNDS) - REF: L
DECEMBER 2021
SCHEDULE OF INVESTMENTS
CEMETERY ENDOWMENT FUND - REF: K
SCHEDULE OF INVESTMENTS
GENERAL FUND ECONOMIC RESERVE (RESTRICTED FUNDS) - REF: M DECEMBER 2021
PURCHASE
CALL
MATURITY
COUPON
DAYS
MONTHS
REMAINING LIFE
RATING
RATING
AMOUNT
PAR
MARKET
SOURCE
DATE
DATE
DATE
RATE
YIELD
OF INV.
OF INV.
IN MONTHS
MOODY'S
S&P
INVESTED
REF
VALUE
VALUE
HIGHMARK CAPITAL MANAGEMENT
PARS OPEB TRUST PROGRAM
12/01/21
---
12/01/21
---
---
0 0
---
---
---
17,028,601.69
17,028,601.69
20,657,526.79
TRANSFER TO GENERAL BANK ACCOUNT
12/01/21
---
12/31/21
---
---
30 1
---
---
---
(129,998.77)
(129,998.77)
(129,998.77)
TRUST FEES
12/01/21
---
12/31/21
---
---
30 1
---
---
---
(7,636.54)
(7,636.54)
(7,636.54)
INTEREST EARNED
12/01/21
---
12/31/21
---
---
30 1
---
---
---
989,309.18
989,309.18
989,309.18
UNREALIZED GAIN/LOSS
12/01/21
---
12/31/21
---
---
30 1
---
---
---
0.00 0.00
(505,952.98)
TOTAL - PUBLIC AGENCY RETIREMENT (RESTRICTED FUNDS)
17,880,275.56
N
17,880,275.56
21,003,247.68
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
12/01/21
---
12/31/21
---
---
30 1
---
---
---
0.00 0.00
0.00 2 - 2008 SERIES B
12/01/21
---
12/31/21
---
---
30 1
---
---
---
2,960,065.73
2,960,065.73
2,960,065.73
3 - 2008 SERIES C
12/01/21
---
12/31/21
---
---
30 1
---
---
---
1,858,416.85
1,858,416.85
1,858,416.85
4 - 2014 SERIES A
12/01/21
---
12/31/21
---
---
30 1
---
---
---
3.90 3.90
3.90 5 - 2015 SERIES A & B
12/01/21
---
12/31/21
---
---
30 1
---
---
---
5.44 5.44
5.44 6 - 2015 SERIES C
12/01/21
---
12/31/21
---
---
30 1
---
---
---
2.10 2.10
2.10 7 - 2018 REFUNDING 2008 SERIES A
12/01/21
---
12/31/21
---
---
30 1
---
---
---
3.48 3.48
3.48 8 - 2016 ELM PARK
12/01/21
---
12/31/21
---
---
30 1
---
---
---
453,512.04
453,512.04
453,512.04
TOTAL - CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES)
5,272,009.54
O
5,272,009.54
5,272,009.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
CASH WITH FISCAL AGENTS - RUA (CONCESSION AGREEMENT)
1 - RIALTO TRUST AND RUA LOCKBOX ACCOUNTS
12/01/21
---
12/31/21
---
---
30 1
---
---
---
5,329,220.34
5,329,220.34
5,329,220.34
2 - WASTEWATER ACCOUNTS
12/01/21
---
12/31/21
---
---
30 1
---
---
---
10,013,772.18
10,013,772.18
9,980,398.90
3 - WATER ACCOUNTS
12/01/21
---
12/31/21
---
---
30 1
---
---
---
7,542,961.49
7,542,961.49
7,526,565.59
TOTAL - CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT) 22,885,954.01
P
22,885,954.01
22,836,184.83
NOTE. P2. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 12/31/2021, INCLUDES CASH AND INVESTMENTS OF $255,018.77 AND $6,144,000.00 RESPECTIVELY.
NOTE. P3. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 12/31/2021, INCLUDES CASH AND INVESTMENTS OF $314,541.06 AND $3,348,000.00 RESPECTIVELY.
REF
226,286,265.27
G
10,456,141.26
H
25,113,601.61
I
150,159.76
J
322,338.92
K
324,108.85
L
25,791,446.48
M
17,880,275.56
N
5,272,009.54
O
22,885,954.01
P
334,482,301.26
(G-P)
OTHER BANK ACCOUNTS / STAGE COACH ACCOUNTS
PUBLIC AGENCY RETIREMENT - OPEB (RESTRICTED FUNDS) - REF: N
PUBLIC AGENCY RETIREMENT - OPEB (RESTRICTED FUNDS)
CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES)
CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES) - REF: O DECEMBER 2021
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
SCHEDULE OF INVESTMENTS
DECEMBER 2021
DECEMBER 2021
SCHEDULE OF INVESTMENTS
SCHEDULE OF INVESTMENTS
CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT) - REF: P
INTEREST & GAIN/(LOSS) SUMMARY
07/31/21 - 11/30/21
12/31/2021
TOTAL
TO DATE
479,735.05
25,565.25
505,300.30
393.27
102.49
495.76
(5,141.08)
9,121.07
3,979.99
4.34 2.02
6.36 (4,645.68)
(11,921.85)
(16,567.53)
2,168.98
2.05 2,171.03
6.96 1.37
8.33 9,780.94
14.97 9,795.91
485,686.57
989,309.18
1,474,995.75
130.86
22.33 153.19
555.85
270.20
826.05
TOTAL
968,676.06
1,012,489.08
1,981,165.14
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
0.00 02/28/22
0.00 03/31/22
0.00 04/30/22
0.00 05/31/22
0.00 06/30/22
0.00 TOTAL- PUBLIC AGENCY RETIREMENT OPEB
(RESTRICTED FUNDS)
(944,804.96)
1,474,995.75
46,464.57
483,726.22
City of Rialto
INVESTMENT INTEREST & GAINS/(LOSS) SCHEDULE
DECEMBER 2021
GENERAL POOLED FUNDS / INVESTMENTS
RSA BANK SWEEP ACCOUNT INTEREST
GENERAL FUND ECONOMIC RESERVE (RESTRICTED FUNDS)
PUBLIC AGENCY RETIREMENT OPEB (RESTRICTED FUNDS)
CASH W/FISCAL AGENTS - (RESTRICTED BOND ISSUES)
CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT)
RUA PRE-EXISTING / INVESTMENTS
OTHER BANK ACCOUNTS
ESCROW ACCOUNTS
CEMETERY ENDOWMENT (RESTRICTED ACCOUNTS)
PEPPER AVENUE EXTENSION (RESTRICTED ACCOUNTS)
City of Rialto
TREASURER’S REPORT
-
GLOSSARY OF TERMS
A
ccrue
d
I
n
terest
‐
T
h
e
i
n
ter
e
s
t
tha
t
ha
s
acc
u
m
u
lated
o
n
a
b
o
n
d
si
n
ce
th
e
last
i
n
te
r
e
st
pay
me
n
t
u
p
to
,
bu
t
n
o
t
i
n
cl
ud
i
n
g,
th
e
se
ttl
e
me
n
t
dat
e
.
A
c
crued
i
n
terest
occ
u
r
s
a
s
a r
e
s
u
lt
o
f
th
e
d
i
ff
e
r
e
n
ce
in
t
i
m
i
n
g
o
f cash
flo
w
s
an
d
th
e
me
a
s
u
r
em
e
n
t
o
f
th
es
e
cash
fl
o
ws.
Call Date
-
Th
e
call date
is the
date
on which a bond can be redeemed before maturity. If the issuer feels there is a benefit to refinancing the issue, the bond may be
redeemed on the
call date
at par or at a small premium to par.
Coupon Rate
-
A coupon rate is the yield paid by a
fixed
-
income
security; a fixed
-
income security's coupon rate is
simply just the annual coupon
payments paid by the issuer relative to the bond's face or par value.
Credit Rating
-
The
credit rating
is a financial indicator to potential
investors
of debt securities such as bonds. These are assigned by
credit
rating
age
ncies such as Moody's, Standard & Poor's, and Fitch, which publish code designations (such as AAA, B, CC) to express their as sessment of
the risk quality of a
bond.
O
r
igi
n
a
l
Cost
/Amount Invested
‐
T
h
e
origi
n
al
c
o
s
t
o
f
a
n
a
s
s
e
t
tak
e
s
i
n
to
co
n
s
i
d
eration
all
o
f
th
e
costs
tha
t
c
a
n
b
e
attribut
e
d
to
its
pur
c
h
a
s
e
an
d
to
putt
i
n
g
th
e
a
sse
t
to
u
se
.
Market Value
-
is the price an asset would fetch in the marketplace, or the value that the investment community gives to a particular equity
or
business.
Par
Val
u
e
‐
T
h
e
f
a
c
e
v
a
l
u
e
o
f a
bond
.
Par
v
a
l
u
e
is
im
p
orta
n
t
f
or
a
bon
d
o
r
fixe
d
‐
i
n
come
i
n
str
u
me
n
t
b
e
c
a
u
s
e
it
d
e
t
e
r
m
i
n
e
s
i
t
s
m
a
turity
v
a
l
u
e
a
s
w
e
ll
a
s
th
e
d
ollar
v
a
l
u
e
o
f
co
upon pay
me
n
t
s
.
Realized Gain/
(
Loss
)
-
Realized gain/loss
is the cumulative amount of
realized gains
and
losses
resulting from the sale of securities. A
realized
loss
is the monetary value of a
loss
that results from a trade
StageCoach Sweep Account
–
A sweep account automatically transfers
cash funds into a safe but higher interest
-
earning investment option at the
close of each business day, e.g. into a money market fund.
Sweep accounts try to minimize idle cash drag by capitalizing on the immediate availability of higher
-
interest accounts.
City of Rialto
TREASURER’S REPORT
-
GLOSSARY OF TERMS
U
nr
ealiz
e
d
Gai
n
s
/
(L
o
ss)
‐
a
p
rofita
b
le/(l
o
si
n
g)
pos
i
t
i
o
n
tha
t
ha
s
y
e
t
to
b
e
cas
h
e
d
i
n
.
T
h
e
a
ct
ua
l
gai
n
/(lo
s
s
)
is
no
t
reali
z
e
d
unt
il
th
e
po
s
i
t
i
o
n
is
close
d
.
A
po
s
i
t
i
o
n
with
a
n
un
re
a
lized gain
m
a
y
e
v
e
n
t
ua
lly
turn
i
n
to
a
po
s
i
t
i
o
n
with
a
n
un
re
a
lized
l
o
ss
,
a
s
th
e
m
a
r
k
et
fl
u
ct
ua
t
e
s
an
d
v
i
c
e
v
e
r
s
a.
Yield
‐
T
h
e
i
n
co
m
e
return
o
n
a
n
i
n
ves
t
me
n
t.
T
h
i
s
r
e
fe
r
s
to
th
e
i
n
ter
e
st
o
r
d
i
v
i
d
e
nd
s
r
e
c
e
i
ve
d
fr
o
m
a
s
e
c
u
rity
an
d
is
ex
p
r
e
s
se
d
a
s
a
p
e
r
c
e
nta
ge
bas
e
d
o
n
th
e
i
n
ves
t
me
n
t
'
s
cost
and
its
current
m
a
r
k
et
v
a
l
u
e.
REFERENCE: O
ISSUE
Account
Account
Fund
Security
Bank Balance
Ref
(cost)
C.O.P.S. 2007 - UNION 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 - UNION BANK
Fees Account
6711841500
******1500
343
Blackrock Prov T-Fund
0.00 Special Fund
6711841501
******1501
343
Blackrock Prov T-Fund
5.72 Interest Account
6711841502
******1502
343
Blackrock Prov T-Fund
9.66 Principal Account
6711841503
******1503
343
Blackrock Prov T-Fund
0.00 Reserve Account
6711841504
******1504
343
Blackrock Prov T-Fund
2,960,050.35
Total
2,960,065.73
RSA 2008 SERIES C - UNION BANK
Fees Account
6711841600
******1600
343
Blackrock Prov T-Fund
0.00 Special Fund
6711841601
******1601
343
Blackrock Prov T-Fund
4.43 Interest Account
6711841602
******1602
343
Blackrock Prov T-Fund
5.81 Principal Account
6711841603
******1603
343
Blackrock Prov T-Fund
0.00 Reserve Account
6711841604
******1604
343
Blackrock Prov T-Fund
1,858,406.61
Total
1,858,416.85
RSA 2014 SERIES A - UNION BANK
Fees Account
6712100600
******0600
343
Blackrock Prov T-Fund
0.00 Special Fund
6712100601
******0601
343
Blackrock Prov T-Fund
2.90 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
3.90 CITY OF RIALTO
CASH W/FISCAL AGENTS
(RESTRICTED BOND ISSUES)
TRUSTEE BALANCES AS OF 12/31/2021
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 12/31/2021
RSA 2015 SERIES A & B - UNION BANK
Fees Account
6712139300
******9300
343
Blackrock Prov T-Fund
0.00 Special Fund
6712139301
******9301
343
Blackrock Prov T-Fund
3.44 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.44 RSA 2015 SERIES C - UNION BANK
Fees Account
6712139400
******9400
343
Blackrock Prov T-Fund
0.00 Special Fund
6712139401
******9401
343
Blackrock Prov T-Fund
1.10 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
2.10 RSA 2018 REFUNDING 2008 SERIES A - UNION BANK
Fees Account
6712214700
******4700
343
Blackrock Prov T-Fund
0.00 Special Fund
6712214701
******4701
343
Blackrock Prov T-Fund
2.48 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
3.48 ELM PARK SERIES 2016 - US BANK
Special Tax Fund
215615000
******5000
871
T-Fund
0.00 Interest Account
215615001
******5001
871
T-Fund
13.49 Principal Account
215615002
******5002
871
T-Fund
0.00 Reserve Account
215615003
******5003
871
T-Fund
453,496.65
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,512.04
TOTAL - CASH W/FISCAL AGENTS
(RESTRICTED BOND ISSUES)
5,272,009.54
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
-
Debt Service - Principal
-
Debt Service - Interest
(5,373.00)
(5,373.00)
Wire In
-
Debt Service - Principal
-
Debt Service - Interest
-
Transfers
Paid to City of Rialto
-
Wire Transfer
-
Other Transactions
To/From ******3502
(5,373.00)
5,373.00
-
To/From ******3503
-
To/From ******3504
-
To/From ******3501
-
Payment from City of Rialto
-
Invoices Paid
-
Balance 12/31/2021
-
-
-
-
-
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
-
-
-
-
-
-
February
-
-
-
-
-
-
March
-
-
-
-
-
-
April
-
-
-
-
-
-
May
-
-
-
-
-
-
June
-
-
-
-
-
-
Total Interest
-
1.44 0.74
0.49 75.36
78.03 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
-
Debt Service - Principal
-
Debt Service - Interest
-
Wire In
-
Debt Service - Principal
-
Debt Service - Interest
-
Other Transactions
To/From ******1501
272.08
(271.59)
(0.49)
0.00 To/From ******1502
(883,312.50)
883,312.50
-
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 12/31/2021
-
5.72 9.66
0.00 2,960,050.35
2,960,065.73
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
-
-
-
-
-
-
February
-
-
-
-
-
-
March
-
-
-
-
-
-
April
-
-
-
-
-
-
May
-
-
-
-
-
-
June
-
-
-
-
-
-
Total Interest
-
1.17 0.55
0.46 47.47
49.65 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
-
Debt Service - Principal
-
Debt Service - Interest
-
Wire In
-
Debt Service - Principal
-
Debt Service - Interest
-
Other Transactions
To/From ******1601
171.34
(170.88)
(0.46)
0.00 To/From ******1602
(655,125.00)
655,125.00
-
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 12/31/2021
-
4.43 5.81
0.00 1,858,406.61
1,858,416.85
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
-
-
-
-
-
-
-
March
-
-
-
-
-
-
-
April
-
-
-
-
-
-
-
May
-
-
-
-
-
-
-
June
-
-
-
-
-
-
-
Total Interest
-
1.45 0.24
1.21 -
-
2.90 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
-
Debt Service - Principal
-
Debt Service - Interest
-
Wire In
-
Debt Service - Principal
-
Debt Service - Interest
-
Other Transactions
To/From ******0601
1.45 (0.24)
(1.21)
-
To/From ******0602
(246,350.00)
246,350.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 12/31/2021
-
2.90 0.00
0.00 1.00
-
3.90 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
-
-
-
-
-
-
-
March
-
-
-
-
-
-
-
April
-
-
-
-
-
-
-
May
-
-
-
-
-
-
-
June
-
-
-
-
-
-
-
Total Interest
-
1.72 0.68
1.04 -
-
3.44 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
-
Debt Service - Series A Principal
-
Debt Service - Series A Interest
-
Debt Service - Series B Principal
-
Debt Service - Series B Interest
-
Other Transactions
To/From ******9301
1.72 (0.68)
(1.04)
-
To/From ******9302
(698,293.75)
698,293.75
-
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 12/31/2021
-
3.44 0.00
0.00 2.00
-
5.44 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
-
-
-
-
-
-
-
March
-
-
-
-
-
-
-
April
-
-
-
-
-
-
-
May
-
-
-
-
-
-
-
June
-
-
-
-
-
-
-
Total Interest
0.00 0.55
0.14 0.41
0.00 0.00
1.10 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
-
Debt Service - Principal
-
Debt Service - Interest
-
Wire In
-
Debt Service - Principal
-
Debt Service - Interest
-
Other Transactions
To/From ******9401
0.55 (0.14)
(0.41)
-
To/From ******9402
(146,371.40)
146,371.40
-
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 12/31/2021
-
1.10 0.00
(0.00)
1.00 -
2.10 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
-
-
-
-
-
-
March
-
-
-
-
-
-
April
-
-
-
-
-
-
May
-
-
-
-
-
-
June
-
-
-
-
-
-
Total Interest
-
1.39 0.65
0.44 -
2.48 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
-
Debt Service - Principal
-
Debt Service - Interest
-
Wire
-
Debt Service - Principal
-
Debt Service - Interest
-
Other Transactions
To/From ******1401
-
To/From ******1404
-
To/From ******4701
1.09 (0.65)
(0.44)
-
To/From ******4702
(662,750.00)
662,750.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 12/31/2021
-
2.48 (0.00)
(0.00)
1.00 3.48
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
-
-
-
-
-
-
-
-
February
-
-
-
-
-
-
-
-
March
-
-
-
-
-
-
-
-
April
-
-
-
-
-
-
-
-
May
-
-
-
-
-
-
-
-
June
-
-
-
-
-
-
-
-
Total Interest
1.90 0.00
0.00 13.69
0.00 0.00
0.00 15.59
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
-
Debt Service - Principal
-
Debt Service - Interest
-
Transfers
Transfer In Wire ACH
-
To/From 104310000
-
To/From 104310004
-
To/From 104310005
-
To/From 104310006
-
To/From ******5000
13.72 (13.72)
-
To/From ******5001
(91,006.27)
91,006.27
-
To/From ******5002
(150,000.00)
150,000.00
-
To/From ******5003
13.49 (13.49)
-
To/From ******5005
(1.90)
1.90 -
To/From 218483000
-
-
Balance 07/31/2021
-
Invoices Paid
-
Balance 12/31/2021
Balance 12/31/2021
0.00 13.49
-
453,496.65
-
1.90 -
453,512.04
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
71,567.62
71,567.62
71,567.62
MASTER REVENUE
******5001
N/A
5,254,527.11
5,254,527.11
5,254,527.11
ENVIRONMENTAL COMPLIANCE
******5002
N/A
3,068.74
3,068.74
3,068.74
REGULATORY COMPLIANCE
******5003
N/A
-
-
-
POST TERMINATION REVENUE
******5030
N/A
-
-
-
EXCLUDED
******5031
N/A
56.87 56.87
56.87 PRE-EXISTING
******5032
N/A
-
-
-
Total
5,329,220.34
5,329,220.34
5,329,220.34
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
613,259.36
613,259.36
613,259.36
WASTEWATER OPERATING R & R
******5012
N/A
1,421,660.44
1,421,660.44
1,421,660.44
WASTEWATER CAPITAL CHARGES
******5014
N/A
-
-
-
WASTEWATER RESERVE
******5016
N/A
255,018.77
255,018.77
255,018.77
P2
WASTEWATER RESERVE
******5016
CD'S
6,144,000.00
6,144,000.00
6,110,626.72
P2
WASTEWATER INTERIM RETENTION
******5018
N/A
22,795.66
22,795.66
22,795.66
WASTEWATER SURPLUS
******5020
N/A
564,627.47
564,627.47
564,627.47
WASTEWATER CONST. RESTRICTED
******5022
N/A
948,817.14
948,817.14
948,817.14
WASTEWATER CONST. UNRESTRICTED
******5023
N/A
43,593.34
43,593.34
43,593.34
WASTEWATER TAKINGS
******5026
N/A
-
-
-
WASTEWATER LOSS PROCEEDS
******5028
N/A
-
-
-
Total
10,013,772.18
10,013,772.18
9,980,398.90
WATER ACCOUNTS
WATER RATE STABILIZATION
******5005
N/A
1,400,010.11
1,400,010.11
1,400,010.11
WATER MASTER
******5007
N/A
-
-
-
WATER OPERATING
******5009
N/A
-
-
-
WATER FACILITY AUTHORITY EXPENSE
******5011
N/A
630,101.53
630,101.53
630,101.53
WATER OPERATING R & R
******5013
N/A
1,368,003.18
1,368,003.18
1,368,003.18
WATER CAPITAL CHARGES
******5015
N/A
-
-
-
WATER RESERVE
******5017
N/A
314,541.06
314,541.06
314,541.06
P3
WATER RESERVE
******5017
CD'S
3,348,000.00
3,348,000.00
3,331,604.10
P3
WATER INTERIM RETENTION
******5019
N/A
17,577.26
17,577.26
17,577.26
WATER SURPLUS
******5021
N/A
435,372.53
435,372.53
435,372.53
WATER CONST. RESTRICTED
******5024
N/A
4,355.13
4,355.13
4,355.13
WATER CONST. UNRESTRICTED
******5025
N/A
-
-
-
WATER TAKINGS
******5027
N/A
-
-
-
WATER LOSS PROCEEDS
******5029
N/A
25,000.69
25,000.69
25,000.69
Total
7,542,961.49
7,542,961.49
7,526,565.59
TOTAL CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT) 22,885,954.01
22,885,954.01
22,836,184.83
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 12/31/2021, INCLUDES CASH AND INVESTMENTS OF $255,018.77 AND $6,144,000.00 RESPECTIVELY.
NOTE. P3. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 12/31/2021, INCLUDES CASH AND INVESTMENTS OF $314,541.06 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
-
-
-
-
-
-
-
-
February
-
-
-
-
-
-
-
-
March
-
-
-
-
-
-
-
-
April
-
-
-
-
-
-
-
-
May
-
-
-
-
-
-
-
-
June
-
-
-
-
-
-
-
-
Total Interest
-
72.81 0.10
-
-
56.87 -
129.78
Debt Service
Wire In
-
Debt Service - Principal
-
Debt Service - Interest
-
Other Transactions
PAID TO/FROM ******5001
-
PAID TO/FROM ******5002
-
PAID TO/FROM ******5006
(13,577,791.86)
(13,577,791.86)
PAID TO/FROM ******5007
(7,862,919.11)
(7,862,919.11)
PAID TO/FROM ******5010
-
PAID TO/FROM ******5011
-
PAID TO/FROM ******5020
897,762.06
897,762.06
PAID TO/FROM ******5021
102,237.94
102,237.94
PAID TO/FROM ******5022
-
PAID TO/FROM ******5024
-
PAID TO/FROM ******5101
-
PAID TO/FROM ******5600
-
PAID TO CITY OF RIALTO
(1,443,925.05)
(4,459,460.81)
(5,903,385.86)
RECEIVED FROM RUA ******4459
(23,133,804.31)
23,133,804.31
-
RECEIVED FROM VEOLIA CHEMICAL REIMB.
-
RECEIVED FROM CITY OF RIALTO
3,459,460.81
3,459,460.81
INVOICES PAID & VOIDED CHECKS
(43,333.91)
(43,333.91)
DEPOSITS
23,133,720.05
23,133,720.05
DEPOSITS - WIRE
-
NSF & CHARGE BACK
(83,385.52)
(83,385.52)
Balance 12/31/2021
71,567.62
5,254,527.11
3,068.74
-
-
56.87 -
5,329,220.34
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
-
-
February
-
-
March
-
-
April
-
-
May
-
-
June
-
Total Interest
-
-
-
27.10 41.00
-
476.30
3.27 -
31.76 1.20
-
-
580.63
Debt Service
Wire In
-
Debt Service - Principal
-
Debt Service - Interest
-
Other Transactions
PAID TO/FROM ******5001
13,577,791.86
13,577,791.86
PAID TO/FROM ******5004
-
PAID TO/FROM ******5006
-
PAID TO/FROM ******5007
-
PAID TO/FROM ******5008
(4,083,104.32)
4,083,104.32
-
PAID TO/FROM ******5010
(1,757,135.96)
1,757,135.96
-
PAID TO/FROM ******5012
(262,500.00)
262,500.00
-
PAID TO/FROM ******5014
(6,340,999.98)
6,340,999.98
-
PAID TO/FROM ******5016
-
PAID TO/FROM ******5018
(1,134,051.60)
1,134,051.60
-
PAID TO/FROM ******5020
(2,183,579.24)
2,183,579.24
-
PAID TO/FROM ******5023
-
PAID TO/FROM ******5031
(2,516,713.83)
(2,516,713.83)
PAID TO/FROM ******5032
-
PAID TO/FROM ******5101
(4,083,104.32)
(6,340,999.98)
(10,424,104.30)
PAID TO/FROM ******5106
(393,049.86)
(393,049.86)
PAID TO/FROM ******5108
(251,271.33)
(251,271.33)
PAID TO CITY OF RIALTO
1,180,648.86
1,180,648.86
INVOICES PAID
(1,744,530.47)
(1,744,530.47)
M2
Balance 12/31/2021
-
0.00 -
613,259.36
1,421,660.44
-
6,399,018.77
22,795.66
564,627.47
948,817.14
43,593.34
-
-
10,013,772.18
NOTE. P2
. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 12/31/2021, INCLUDES CASH AND INVESTMENTS OF $255,018.77 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
0.00 February
0.00 March
0.00 April
0.00 May
0.00 June
0.00 Total Interest
10.11 0.00
0.00 38.88
37.94 0.00
27.08 0.81
0.00 0.13
0.00 0.00
0.69 115.64
Debt Service
Wire In
0.00 Debt Service - Principal
0.00 Debt Service - Interest
0.00 Other Transactions
PAID TO/FROM ******5001
7,942,183.16
7,942,183.16
PAID TO/FROM ******5002
0.00 PAID TO/FROM ******5005
0.00 PAID TO/FROM ******5006
0.00 PAID TO/FROM ******5007
(1,500,000.00)
1,500,000.00
0.00 PAID TO/FROM ******5009
(3,347,474.59)
3,347,474.59
0.00 PAID TO/FROM ******5010
(2,195,959.66)
2,195,959.66
0.00 PAID TO/FROM ******5011
(150,000.00)
150,000.00
0.00 PAID TO/FROM ******5013
(1,450,000.02)
1,450,000.02
0.00 PAID TO/FROM ******5015
(48,143.57)
48,143.57
0.00 PAID TO/FROM ******5017
(2,250,605.32)
2,171,341.27
(79,264.05)
PAID TO/FROM ******5018
0.00 PAID TO/FROM ******5019
0.00 PAID TO/FROM ******5021
(2,275,881.57)
2,275,881.57
0.00 PAID TO/FROM ******5031
(1,942,746.98)
(1,942,746.98)
PAID TO/FROM ******5032
0.00 PAID TO/FROM ******5101
(3,347,474.59)
(1,450,000.02)
(4,797,474.61)
PAID TO/FROM ******5108
0.00 PAID TO/FROM ******5109
(244,561.43)
(244,561.43)
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
(2,350,280.31)
(2,350,280.31)
M3
Balance 12/31/2021
1,400,010.11
0.00 0.00
630,101.53
1,368,003.18
0.00 3,662,541.06
17,577.26
435,372.53
4,355.13
0.00 0.00
25,000.69
7,542,961.49
NOTE. P3
. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 12/31/2021, INCLUDES CASH AND INVESTMENTS OF $314,541.06 AND $3,348,000.00 RESPECTIVELY.
NOTE
: THE ACTIVITY SHOWN ABOVE CUMULATIVE THROUGHT THE MONTHS OF 07/2021 - 06/2022.