August 05, 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…………………………………………………………………………………………. 250,906,809.94 64% A,G Rialto Successor Agency (RSA) + Cash Sweep Bank Account…………………………………………………………………………………................................13,171,464.53 3% B,H Rialto Utility Authority (RUA) Pre-existing Investments + Cash Sweep Bank Account…………………………………………………………………………………………….25,754,120.46 7% C,I Other Bank Accounts + Cash Sweep Bank Accounts…………………………………………………………………………………………………………………….............1,880,556.68 1% D,J Escrow Accounts…………………………………………………………………………………………………………………………….................................................14,131,907.51 4% E Cemetery Endowment Fund (Restricted Accounts)…………………………………………………………………...........................................................................426,820.41 0% F,K Pepper Avenue Extension (Restricted Accounts)………………………………………………………………….......................................................... 163,926.74 0% L General Fund Economic Reserve (Restricted Funds)……………………………………………………………………............................................... 27,253,602.30 7% M Public Agency Retirement Services - OPEB (Restricted Funds)…………………………………………………………………….................................. 27,357,799.11 7% N Cash with Fiscal Agents - (Restricted Bond Issues)…………………………………………………………………………......................................................9,917,277.79 3% O Cash with Fiscal Agents - RUA (Concession Agreement)…………………………………………………………………..........................................................23,674,429.72 6% P TREASURER'S PORTFOLIO 394,638,715.19 100%
TREASURER'S MONTHLY REPORT - JUNE 2022
The City’s Treasurer expects to have sufficient cash for the next six months. The City of Rialto’s Investments and funds management is in compliance with the City’s Investment Policy and State Mandates. Pooled Investments have liquidity below 30 days, and therefore carry Market Value at Issued Value. Wells Fargo Advisors, JP Morgan Advisors and Clearwater Analytics provided the Market Value of the investments held in custody. US Bank (Corporate Trust Dept.) provided Fiscal Agent information.
City of Rialto
TREASURER'S BANK
RECONCILIATION BALANCE SHEET
MAY 2022 JUNE 2022
ACTIVE ACCOUNTS BALANCE RECEIPTS DISBURSEMENTS BALANCE REF GENERAL BANK ACCOUNT ** (2,530,967.49) 34,842,388.65 35,544,477.39 (3,233,056.23) A RSA BANK ACCOUNT ** - 38,090.21 38,090.21 - B RUA BANK ACCOUNT ** (19,564.98) 1,006,889.93 920,221.19 67,103.76 C SPORTS CENTER/POOL ** - 22,527.59 22,527.59 - AMBULANCE LOCKBOX 37,380.83 302,016.90 249,520.01 89,877.72 FLEXIBLE BENEFIT** - 15.54 15.54 - ALARM LOCKBOX 55,968.96 18,582.47 26,236.60 48,314.83
BANK CARD - - - - PAYROLL CLEARING 14,983.11 7,497,387.70 7,499,746.78 12,624.03 LIABILITY ACCT./CARL WARREN & CO. 22,741.01 - 22,741.01 0.00 LIABILITY ACCT./GEORGE HILLS 123,637.47 55,000.00 174,273.13 4,364.34
PEPPER AVENUE - - - - WORKERS COMP/LWP CLAIMS SOLUTIONS 93,795.24 163,736.34 181,863.54 75,668.04 PROPERTY EVIDENCE MONIES 1,404,089.55 5,759.18 3,487.70 1,406,361.03 OTHER BANK ACCOUNTS 1,752,596.17 8,065,025.72 8,180,411.90 1,637,209.99 D ENERGY CONSERVATION PROJECT 84,786.55 - - 84,786.55 AYALA @ 210 PARTNERS LLC 310,728.27 9.88 10.00 310,728.15 LEWIS HILLWOOD 2,738,066.53 2,278.54 8,197.80 2,732,147.27 ALDER AVENUE 3,257,704.60 2,710.97 9,753.61 3,250,661.96 LAUREL/WALNUT/LOCUST 2,969,143.08 2,470.84 8,889.65 2,962,724.27 SUB ACCOUNT A 4,801,238.81 3,995.46 14,374.96 4,790,859.31 ESCROW ACCOUNTS 14,161,667.84 11,465.69 41,226.02 14,131,907.51 E CEMETERY ENDOWMENT FUND 102,314.93 3.37 - 102,318.30 RESTRICTED ACCOUNTS 102,314.93 3.37 - 102,318.30 F TOTAL - ACTIVE ACCOUNTS 13,466,046.47 12,705,483.33 (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 06/01/22 --- 06/01/22 --- --- 0 1 --- --- --- 30,114,221.94 30,114,221.94 30,114,221.94 SHARES PURCHASED 06/01/22 --- 06/30/22 --- --- 30 1 --- --- --- 7,718,190.00 7,718,190.00 7,718,190.00 SHARES REDEEMED 06/01/22 --- 06/30/22 --- --- 30 1 --- --- --- (22,404,250.81) (22,404,250.81) (22,404,250.81) INTEREST EARNED - GENERAL FUND ACCOUNT 06/01/22 --- 06/30/22 --- 1.25% 29 1 --- --- --- 14,332.00 14,332.00 14,332.00 CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- (26,469.70) (26,469.70) (26,469.70) SUBTOTAL 15,416,023.43 15,416,023.43 15,416,023.43
LAIF - CALIFORNIA STATE POOL
POOLED FUNDS - LAIF 06/01/22 --- 06/30/22 --- 1.01% 29 1 --- --- --- 20,242,981.61 20,242,981.61 20,242,981.61 SUBTOTAL 20,242,981.61 20,242,981.61 20,242,981.61
JP MORGAN ADVISORS - GENERAL
02665WDM0 - AMERICAN HONDA FIN CORP 03/24/22 --- 09/08/23 0.65% 0.67% 533 18 14 A3 A- 981,946.77 1,000,000.00 969,629.79 05724BAB5 - BAKER HUGHES HLDGS LLC 04/20/22 --- 12/15/23 1.23% 1.27% 604 20 18 A3 A- 1,958,049.60 2,000,000.00 1,941,633.96 13607HVC3 - CANADIAN IMPERIAL BANK 03/24/22 --- 06/22/23 0.45% 0.46% 455 15 12 A2 A- 1,474,661.47 1,500,000.00 1,453,332.32 3133ENLD0 - FEDERAL FARM CR BKS 01/11/22 01/26/24 01/26/26 1.53% 1.62% 1476 49 43 N/A N/A 2,000,000.00 2,000,000.00 1,892,645.82 3133ENNE6 - FEDERAL FARM CREDIT BANK 02/03/22 --- 02/09/24 1.23% 1.26% 736 24 19 AAA AA+ 745,000.00 745,000.00 724,582.68 3134GXSM7 - FEDERAL HOME LOAN BANK 04/22/22 07/17/22 05/17/27 4.00% 4.01% 1851 61 59 AAA AA+ 1,000,000.00 1,000,000.00 998,312.13 3130AQJK0 - FEDERAL HOME LOAN BANK 01/05/22 07/25/22 04/25/24 1.00% 1.03% 841 28 22 AAA AA+ 2,000,000.00 2,000,000.00 1,934,618.70 3130ARJ44 - FEDERAL HOME LOAN BANK 03/24/22 07/22/22 04/22/24 2.40% 2.42% 760 25 22 AAA AA+ 2,000,000.00 2,000,000.00 1,979,806.48 3130ARWC1 - FEDERAL HOME LOAN BANK 04/27/22 05/15/23 11/16/23 2.50% 2.52% 568 19 17 AAA AA+ 3,000,000.00 3,000,000.00 2,980,676.70 3130ARX55 - FEDERAL HOME LOAN BANK 04/27/22 08/26/22 11/26/24 3.13% 3.14% 944 31 29 AAA AA+ 5,000,000.00 5,000,000.00 4,980,209.20 3134GXGQ1 - FREDDIE MAC 12/07/21 09/15/22 12/15/22 0.20% 0.20% 373 12 6 AAA N/A 1,248,601.53 1,250,000.00 1,238,119.54 606822BJ2 - MITSUBISHIA UFJ FINANICAL GROUP 04/22/22 --- 07/18/24 2.80% 2.88% 818 27 25 A1 A- 3,953,031.14 4,000,000.00 3,896,345.80 78015K7L2 - ROYAL BANK OF CANADA 01/04/22 --- 01/19/24 0.43% 0.44% 745 25 19 A1 A 2,009,623.74 2,026,000.00 1,940,683.38 83369NHL7 - SOCIETE GENERALE 01/18/22 07/20/22 01/20/27 1.95% 2.09% 1828 60 55 A1 A 2,000,000.00 2,000,000.00 1,869,451.64 89788JAB5 - TRUIST BK GLOBAL BK 03/22/22 02/09/23 03/09/23 1.25% 1.27% 352 12 8 A2 A 996,896.80 1,000,000.00 986,399.81 91282CBU4 - UNITED STATES TREASURY 03/22/22 --- 03/31/23 0.13% 0.13% 374 12 9 AAA N/A 1,979,368.02 2,000,000.00 1,961,171.88 91282CCD1 - UNITED STATES TREASURY 04/22/22 --- 05/31/23 0.13% 0.13% 404 13 11 AAA N/A 4,911,078.20 5,000,000.00 4,876,171.90 91282CCN9 - UNITED STATES TREASURY 03/24/22 --- 07/31/23 0.13% 0.13% 494 16 13 AAA N/A 1,963,579.58 2,000,000.00 1,940,000.00 91282CAR2 - UNITED STATES TREASURY 03/24/22 --- 10/31/22 0.13% 0.13% 221 7 4 AAA N/A 4,984,775.47 5,000,000.00 4,967,056.00 JP MORGAN ADVISORS ---TREASURY MONEY MARKET 06/01/22 --- 06/30/22 --- 0.64% 29 1 --- --- --- 848,050.22 848,050.22 848,050.22 JP MORGAN ADVISORS --- CASH 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 0.00 0.00 0.00 SUBTOTAL 45,054,662.54 45,369,050.22 44,378,897.95
NOTE. G (CONTINUED TO NEXT PAGE)
City of Rialto
SCHEDULE OF INVESTMENTS
GENERAL POOLED FUNDS / INVESTMENTS - REF: G
JUNE 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 ADVISORS - CUSTODIAL
38150AEJ0 - GOLDMAN SACHS GRP INC MTN CALLABLE 11/20/20 08/24/22 11/25/22 0.40% 0.40% 735 24 5 A2 BBB+ 7,497,500.00 7,500,000.00 7,394,775.00 94973VBA4 - WELLPOINT INC SR UNSECURED 07/13/21 --- 01/15/23 3.30% 3.29% 551 18 7 BAA2 A 1,566,150.00 1,500,000.00 1,502,040.00 94974BFN5 -WELLS FARGO & CO SUBORDINATED 06/03/21 --- 08/15/23 4.13% 4.09% 803 26 14 A3 BBB 5,519,832.00 5,100,000.00 5,136,873.00 38150AEF8 - GOLDMAN SACH GRP MTN CALLABLE 11/20/20 08/24/22 11/24/23 0.60% 0.63% 1099 36 17 A2 BBB+ 3,000,000.00 3,000,000.00 2,856,150.00 17329F6E9 - CITIGROUP GLOBAL MARKETS MTN CALLABLE 03/30/21 09/30/22 03/31/24 0.70% 0.73% 1097 36 21 A3 A 8,250,000.00 8,250,000.00 7,847,235.00 02665WDS7 - AMERICAN HONDA FINANCE MTN 02/25/21 --- 07/12/24 0.55% 0.58% 1233 41 24 A3 A- 3,827,410.50 3,825,000.00 3,592,401.75 94974BGA2 - WELLS FARGO & CO. MTN 04/22/22 --- 09/09/24 3.30% 3.34% 871 29 26 A1 BBB+ 5,000,000.00 5,000,000.00 4,932,850.00 45950VQE9 - INTL FINANCE CORP MTN 09/08/21 --- 09/10/24 0.43% 0.45% 1098 36 26 AAA AAA 5,000,000.00 5,000,000.00 4,708,450.00 38150AFC4 - GOLDMAN SACHS GRP INC MTN CALLABLE 03/26/21 09/30/22 09/30/24 1.00% 1.06% 1284 42 27 A2 BBB+ 4,500,000.00 4,500,000.00 4,221,405.00 61761JVL0 - MORGAN STANLEY MTN SR UNSECURED 07/15/21 --- 10/23/24 3.70% 3.70% 1196 39 28 A1 A- 5,048,828.40 4,620,000.00 4,610,067.00 38150AFM2 - GOLDMAN SACHS GRP INC MTN CALLABLE 05/10/21 08/12/22 11/12/24 1.00% 1.07% 1282 42 28 A2 BBB+ 10,000,000.00 10,000,000.00 9,288,600.00 037833AZ3 - APPLE INC SR UNSECURED 02/04/21 --- 02/09/25 2.50% 2.54% 1466 48 31 AAA AA+ 2,157,500.00 2,000,000.00 1,961,140.00 06048WK66 - BANK OF AMERICA CORP MULTISTEP UP MTN CALLABLE 02/04/21 09/23/22 12/23/25 0.65% 0.75% 1783 59 42 A2 A- 1,994,000.00 2,000,000.00 1,731,600.00 17290AEA4 - CITIGROUP INC. MTN CALLABLE 10/15/21 10/19/24 10/19/26 1.45% 1.65% 1830 60 52 A3 BBB+ 5,000,000.00 5,000,000.00 4,389,800.00 48128G5Y2 - JPMORGAN CHASE & CO MTN CALLABLE 01/27/22 01/31/24 01/29/27 2.10% 2.46% 1828 60 55 A2 A- 3,000,000.00 3,000,000.00 2,555,310.00 3815AL29 - GOLDMAN SACHS GRP INC MTN CALLABLE 02/28/22 03/02/23 03/02/27 3.00% 3.17% 1828 60 56 A2 BBB+ 5,000,000.00 5,000,000.00 4,717,750.00 3135G05G4 - FEDERAL NATIONAL MTG ASSN NOTES 12/02/21 --- 07/10/23 0.25% 0.25% 585 19 12 AAA AA+ 3,896,901.50 3,910,000.00 3,806,345.90 3130ANZ60 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/08/21 09/27/22 06/27/25 0.40% 0.53% 1388 46 36 AAA AA+ 1,500,000.00 1,500,000.00 1,405,665.00 3130ALZA5 - FEDERAL HOME LOAN BANK MULTI STEP COUPON BONDS CALLABLE 04/13/21 07/29/22 04/29/26 0.50% 0.79% 1842 61 46 AAA AA+ 6,000,000.00 6,000,000.00 5,649,660.00 3130AMB76 - FEDERAL HOME LOAN BANK BONDS CALLABLE 05/18/21 08/18/22 05/18/26 1.25% 1.33% 1826 60 47 AAA AA+ 1,108,800.00 1,100,000.00 1,030,920.00 3130AMKN1 - FEDERAL HOME LOAN MULTISTEP UP COUPON BONDS CALLABLE 05/18/21 08/27/22 05/27/26 0.50% 0.79% 1835 60 47 AAA AA+ 8,900,000.00 8,900,000.00 8,377,748.00 3130ANUT5 - FEDERAL HOME LOAN BANK MULTI STEP COUPON BONDS CALLABLE 08/30/21 09/16/22 09/16/26 0.50% 0.53% 1843 61 51 AAA AA+ 10,000,000.00 10,000,000.00 9,335,400.00 3130ANZ52 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/08/21 09/28/22 09/28/26 0.50% 0.53% 1846 61 51 AAA AA+ 2,500,000.00 2,500,000.00 2,336,375.00 3130ANXC9 - FEDERAL HOME LOAN BANK MULTISTEP COUPON BONDS CALLABLE 09/02/21 09/29/22 09/29/26 0.60% 0.67% 1853 61 51 AAA AA+ 5,000,000.00 5,000,000.00 4,601,200.00 78658RFR7 - SAFRA NATIONAL BANK CD 10/12/21 --- 10/19/22 0.15% 0.15% 372 12 4 N.A. N.A. 249,000.00 249,000.00 247,685.28 99000FGR3 - WORLD'S FOREMOST BANK CD 09/20/21 --- 05/08/23 2.45% 2.46% 595 20 10 N.A. N.A. 206,936.00 200,000.00 198,986.00 99000QMY7 - COMENITY BANK CD 09/23/21 --- 08/15/23 2.15% 2.17% 691 23 14 N.A. N.A. 206,372.00 200,000.00 197,572.00 05580AD92 - BMW BK N AMERICA CD 09/20/21 --- 09/25/23 0.35% 0.36% 735 24 15 N.A. N.A. 249,000.00 249,000.00 241,106.70 87165HD64 - SYNCHRONY BANK CD 09/20/21 --- 09/25/23 0.40% 0.41% 735 24 15 N.A. N.A. 249,000.00 249,000.00 241,256.10 38149MA52 - GOLDMAN SACHS BK USA CD 09/20/21 --- 09/29/23 0.35% 0.36% 739 24 15 N.A. N.A. 249,000.00 249,000.00 241,022.04 856285XP1 - STATE BANK OF INDIA CD 09/20/21 --- 09/29/23 0.40% 0.41% 739 24 15 N.A. N.A. 249,000.00 249,000.00 241,173.93 947547NE1 - WEBBANK CD 09/20/21 07/30/22 09/29/23 0.30% 0.31% 739 24 15 N.A. N.A. 249,000.00 249,000.00 240,812.88 538036SD7 - LIVE OAK BANKING CO CD 09/21/21 --- 10/02/23 0.25% 0.25% 741 24 15 N.A. N.A. 249,000.00 249,000.00 240,641.07 649447UA5 - NEW YORK CMNTY BK CD 10/05/21 --- 10/16/23 0.30% 0.31% 741 24 16 N.A. N.A. 250,000.00 250,000.00 241,475.00 45581ECS8 - INDUSTRIAL & COM BK CD 09/21/21 --- 10/18/23 0.35% 0.36% 757 25 16 N.A. N.A. 249,000.00 249,000.00 240,623.64 06251A2J8 - BANK HAPOALIM BM NY CD 09/28/21 --- 10/26/23 0.25% 0.25% 758 25 16 N.A. N.A. 248,253.00 249,000.00 240,133.11 88241TFP6 - TEXAS EXCHANGE BK SSB CD 09/22/21 07/18/22 12/18/23 0.35% 0.36% 817 27 18 N.A. N.A. 248,000.00 248,000.00 238,340.40 NOTE. G (CONTINUED TO NEXT PAGE)
GENERAL POOLED FUNDS / INVESTMENTS - REF: G (CONTINUED) JUNE 2022
SCHEDULE OF INVESTMENTS
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 61765QQ28 - MORGAN STANLEY BK NA CD 10/01/21 --- 01/08/24 0.25% 0.26% 829 27 18 N.A. N.A. 250,000.00 250,000.00 240,012.50 47804GGX5 - JOHN MARSHALL BANK CD 09/29/21 --- 06/17/24 0.25% 0.26% 992 33 24 N.A. N.A. 243,020.40 245,000.00 230,878.20 29278TPT1 - ENERBANK USA CD 10/12/21 --- 06/26/24 0.50% 0.52% 988 32 24 N.A. N.A. 210,578.00 211,000.00 199,660.86 89235MLG4 - TOYOTA FINL SGS BK CD 09/23/21 --- 08/12/24 0.60% 0.63% 1054 35 25 N.A. N.A. 248,927.79 249,000.00 235,287.57 795451AW3 - SALLIE MAE BANK/SALT CD 09/20/21 --- 09/23/24 0.70% 0.74% 1099 36 27 N.A. N.A. 249,000.00 249,000.00 235,031.10 90348JT75 - UBS BANK USA CD 09/28/21 --- 10/07/24 0.65% 0.69% 1105 36 27 N.A. N.A. 249,000.00 249,000.00 234,448.44 59013KNU6 - MERRICK BANK CD 10/06/21 --- 10/21/24 0.55% 0.58% 1111 37 28 N.A. N.A. 249,000.00 249,000.00 233,634.21 48128WBQ7 - JP MORGAN CHASE BK NA CD 10/13/21 10/29/22 10/29/26 0.55% 0.54% 1842 61 52 N.A. N.A. 125,000.00 125,000.00 113,778.75 53944VAS8 - LLOYDS BANK PLC SR NOTE 12/09/19 --- 08/14/22 2.25% 2.25% 979 32 1 A1 A+ 2,009,300.00 2,000,000.00 1,999,300.00 89114V4M6 - TORONTO-DOMINION BANK MTN 03/07/22 09/09/22 06/09/23 1.40% 1.42% 459 15 11 A1 A 5,000,000.00 5,000,000.00 4,920,550.00 22553PTV1 - CREDIT SUISSE AG LONDON MTN 04/27/22 10/29/22 10/29/23 3.00% 3.01% 550 18 16 A1 N.A. 5,000,000.00 5,000,000.00 4,974,800.00 13605WQ79 - CANADIAN IMPERIAL BK COMM MTN CALLABLE 12/28/20 12/22/22 06/22/24 0.55% 0.59% 1272 42 24 A2 A- 3,000,000.00 3,000,000.00 2,779,920.00 459056HV2 - INTL BK RECON & DEVELOP SR UNSECURED 09/07/21 --- 08/28/24 1.50% 1.54% 1086 36 26 AAA AAA 1,031,750.00 1,000,000.00 968,010.00 89114TDD1 - TORONTO DOMINION BANK MTN CALLABLE 03/09/21 09/11/22 09/11/24 0.70% 0.74% 1282 42 26 A1 A 7,000,000.00 7,000,000.00 6,601,840.00 89114TF49 - TORONTO DOMINION BANK MTN CALLABLE 03/20/21 10/01/22 04/01/25 1.00% 1.06% 1473 48 33 A1 A 5,000,000.00 5,000,000.00 4,694,250.00 06747PKV0 - BARCLAYS BANK PLC - MTN CALLABLE 06/08/20 04/08/23 04/08/25 3.25% 3.36% 1765 58 33 A1 A 5,136,480.00 4,920,000.00 4,753,113.60 22553PTR0 - CREDIT SUISSE AG LONDON - MTN CALLABLE 05/04/22 05/06/23 05/06/25 4.00% 3.99% 1098 36 34 A1 N.A. 5,000,000.00 5,000,000.00 5,003,500.00 89114VCS4 - TORONTO-DOMINION BANK MTN 04/26/22 10/31/23 10/31/25 3.50% 3.51% 1284 42 40 A1 A 5,000,000.00 5,000,000.00 4,973,250.00 89114X2S1 - TORONOT-DOMINION BANK MTN 06/27/22 09/30/22 06/30/27 5.00% 4.99% 1829 60 60 A1 A 10,000,000.00 10,000,000.00 10,002,200.00 WFA ---TREASURY MONEY MARKET 06/01/22 --- 06/30/22 --- 0.58% 29 1 --- --- --- 321.36 321.36 321.36 WFA --- CASH 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 5,337.64 5,337.64 5,337.64 SUBTOTAL 173,426,198.59 172,096,659.00 164,439,713.03
TOTAL - GENERAL POOLED FUNDS / INVESTMENTS 254,139,866.17 G 253,124,714.26 244,477,616.02
SCHEDULE OF INVESTMENTS
GENERAL POOLED FUNDS / INVESTMENTS - REF: G (CONTINUED) MAY 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
RSA ACCOUNT ** 06/01/22 --- 06/01/22 --- --- 0 0 --- --- --- 13,150,590.54 13,150,590.54 13,150,590.54 SHARES PURCHASED 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 22,602.50 22,602.50 22,602.50 SHARES REDEEMED 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- (11,917.09) (11,917.09) (11,917.09) INTEREST EARNED - WELLS FARGO 06/01/22 --- 06/30/22 ---- 1.25% 29 1 --- --- --- 10,188.58 10,188.58 10,188.58 TOTAL - RSA INVESTMENTS 13,171,464.53 H 13,171,464.53 13,171,464.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 ** 06/01/22 --- 06/01/22 --- --- 0 0 --- --- --- 6,701,610.29 6,701,610.29 6,701,610.29 SHARES PURCHASED 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 805,585.53 805,585.53 805,585.53 SHARES REDEEMED 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- (55,122.81) (55,122.81) (55,122.81) CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) - RUA ACCOUNT ** 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 0.16 0.16 0.16 INTEREST EARNED - WELLS FARGO 06/01/22 --- 06/30/22 --- 1.25% 29 1 --- --- --- 5,644.67 5,644.67 5,644.67 SUBTOTAL 7,457,717.84 7,457,717.84 7,457,717.84
LAIF - CALIFORNIA STATE POOL
POOLED FUNDS - LAIF 06/01/22 --- 06/30/22 --- 1.01% 29 1 --- --- --- 100,821.73 100,821.73 100,821.73 SUBTOTAL 100,821.73 100,821.73 100,821.73
WELLS FARGO ADVISORS - RUA
94974BFN5 - WELLS FARGO & CO SUBORDINATED 06/03/21 --- 08/15/23 3.93% 4.09% 803 26 14 A3 BBB 974,088.00 900,000.00 906,507.00 38150AJK2 - GOLDMAN SACHS GRP INC MTN 11/22/21 08/24/22 11/24/23 1.00% 1.04% 732 24 17 A2 BBB+ 3,900,000.00 3,900,000.00 3,742,947.00 02665WDS7 - AMERICAN HONDA FINANCE MTN 02/04/21 --- 07/12/24 0.56% 0.59% 1254 41 24 A3 A- 3,477,991.50 3,475,000.00 3,263,685.25 3815AJ48 - GOLDMAN SACHS GRP INC MTN 10/27/21 10/29/22 10/29/24 1.15% 1.22% 1098 36 28 A2 BBB+ 413,000.00 413,000.00 387,447.69 3130AMRA2 - FEDERAL HOME LOAN BANK 06/02/21 09/24/22 06/24/26 0.63% 0.67% 1848 61 48 AAA AA+ 1,000,000.00 1,000,000.00 931,820.00 83369MM74 - SOCIETE GENERALE BANK MTN 10/14/20 07/19/22 10/19/22 0.40% 0.40% 735 24 4 A1 A 2,000,000.00 2,000,000.00 1,975,420.00 13605WQ79 - CANADIAN IMPERIAL BANK COMM MTN CALLABLE 12/18/20 12/22/22 06/22/24 0.56% 0.59% 1282 42 24 A2 A- 270,000.00 270,000.00 250,192.80 89114TDD1 - TORONTO DOMINION BANK MTN CALLABLE 03/09/21 09/11/22 09/11/24 0.71% 0.74% 1282 42 26 A1 A 3,000,000.00 3,000,000.00 2,829,360.00 89114TF49 - TORONTO DOMINION BANK MTN CALLABLE 03/30/21 10/01/22 04/01/25 1.01% 1.06% 1463 48 33 A1 A 3,000,000.00 3,000,000.00 2,816,550.00 WFA --- TREASURY MONEY MARKET 06/01/22 --- 06/30/22 --- 0.58% 29 1 --- --- --- 858.90 858.90 858.90 WFA --- CASH 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 92,538.73 92,538.73 92,538.73 SUBTOTAL 18,128,477.13 18,051,397.63 17,197,327.37
TOTAL - RUA PRE-EXISTING INVESTMENTS 25,687,016.70 I 25,609,937.20 24,755,866.94
SCHEDULE OF INVESTMENTS
RUA PRE-EXISTING / INVESTMENTS - REF: I
SCHEDULE OF INVESTMENTS
RSA STAGE COACH SWEEP ACCOUNT - REF: H
JUNE 2022
JUNE 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 ** 06/01/22 --- 06/01/22 --- --- 0 0 --- --- --- 186,611.70 186,611.70 186,611.70 SHARES PURCHASED 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 21,399.21 21,399.21 21,399.21 INTEREST EARNED - SPORTS CENTER &POOL ACCOUNT ** 06/01/22 --- 06/30/22 --- 1.25% 29 1 --- --- --- 154.16 154.16 154.16 CASH SWEEP BALANCE / (FUNDS PENDING REDEMPTION) ** 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 616.00 616.00 616.00 SUBTOTAL 208,781.07 208,781.07 208,781.07
WELLS FARGO CASH SWEEP ACCOUNT - FLEXIBLE BENEFIT
FLEXIBLE BENEFIT ACCOUNT** 06/01/22 --- 06/01/22 --- --- 0 0 --- --- --- 34,539.74 34,539.74 34,539.74 INTEREST EARNED - FLEXIBLE BENEFIT ACCOUNT** 06/01/22 --- 06/30/22 --- 1.25% 29 1 --- --- --- 25.88 25.88 25.88 SUBTOTAL 34,565.62 34,565.62 34,565.62
TOTAL - OTHER BANK ACCOUNTS INVESTMENTS 243,346.69 J 243,346.69 243,346.69
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 07/30/22 04/30/26 1.35% 1.50% 1828 60 46 A2 BBB+ 320,000.00 320,000.00 286,512.00 WFA --- TREASURY MONEY MARKET 06/01/22 --- 06/30/22 --- 0.58% 29 1 --- --- --- 100.84 100.84 100.84 WFA --- CASH 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 4,401.27 4,401.27 4,401.27 TOTAL - CEMETERY ENDOWMENT FUND 324,502.11 K 324,502.11 291,014.11
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 0 --- --- 163,926.74 163,926.74 163,926.74 TOTAL - PEPPER AVENUE EXTENSION RESTRICTED ACCOUNTS 163,926.74 L 163,926.74 163,926.74
SCHEDULE OF INVESTMENTS
OTHER BANK ACCOUNTS - CASH SWEEP ACCOUNTS - REF: J
JUNE 2022
JUNE 2022
SCHEDULE OF INVESTMENTS
PEPPER AVENUE EXTENSION (RESTRICTED FUNDS) - REF: L
JUNE 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
5006E3GC8 - KOREA DEVELOPMENT BANK CP 04/11/22 --- 07/12/22 --- 0.85% 92 3 0 P1 A1+ 7,803,197.86 7,820,000.00 7,815,777.20 5148X1H48 - LANDESBANK BADEN-WURIT CP 05/04/22 --- 08/04/22 --- 1.33% 92 3 1 P1 N.A 14,948,940.00 15,000,000.00 14,973,600.00 2254EBHN4 - CREDIT SUISSE NEW YORK CP 05/20/22 --- 08/22/22 --- 1.50% 94 3 2 P1 A1 3,053,378.53 3,065,000.00 3,056,387.35 2254EBJP7 - CREDIT SUISSE NEW YORK CP 06/23/22 --- 09/23/22 --- 2.15% 92 3 3 P1 A1 1,442,032.69 1,450,000.00 1,442,286.00 WFA --- TREASURY MONEY MARKET 06/01/22 --- 06/30/22 --- 0.58% 29 1 --- --- --- 740.23 740.23 740.23 WFA --- CASH 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 5,312.99 5,312.99 5,312.99 SUBTOTAL 27,253,602.30 27,341,053.22 27,294,103.77
TOTAL - GENERAL FUND ECONOMIC RESERVE 27,253,602.30 M 27,341,053.22 27,294,103.77
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 06/01/22 --- 06/01/22 --- --- 0 0 --- --- --- 27,644,929.83 27,644,929.83 27,846,429.04 TRANSFER TO GENERAL BANK ACCOUNT 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- (261,749.60) (261,749.60) (261,749.60) TRUST FEES 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- (9,273.81) (9,273.81) (9,273.81) INTEREST EARNED 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- (16,107.31) (16,107.31) (16,107.31) UNREALIZED GAIN/LOSS 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 0.00 0.00 (1,583,740.53) TOTAL - PUBLIC AGENCY RETIREMENT (RESTRICTED FUNDS) 27,357,799.11 N 27,357,799.11 25,975,557.79
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
2008 SERIES B 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 2,962,593.93 2,962,593.93 2,962,593.93 2008 SERIES C 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 1,860,004.07 1,860,004.07 1,860,004.07 2014 SERIES A 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 2.20 2.20 2.20 2015 SERIES A & B 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 5.81 5.81 5.81 2015 SERIES C 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 1.78 1.78 1.78 2018 REFUNDING 2008 SERIES A 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 4.64 4.64 4.64 2016 ELM PARK 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 453,574.40 453,574.40 453,574.40 2022 SERIES CFD 2019-2 FOOTHILL/SPRUCE 05/01/22 --- 06/30/22 --- --- 60 2 --- --- --- 4,641,090.96 4,641,090.96 4,641,090.96 TOTAL - CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES) 9,917,277.79 O 9,917,277.79 9,917,277.79
SCHEDULE OF INVESTMENTS
JUNE 2022
SCHEDULE OF INVESTMENTS
CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES) - REF: O PUBLIC AGENCY RETIREMENT - OPEB (RESTRICTED FUNDS) - REF: N
SCHEDULE OF INVESTMENTS
GENERAL FUND ECONOMIC RESERVE (RESTRICTED FUNDS) - REF: M JUNE 2022
JUNE 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)
RIALTO TRUST AND RUA LOCKBOX ACCOUNTS 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 5,915,296.12 5,915,296.12 5,915,296.12 WASTEWATER ACCOUNTS 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 11,404,699.80 11,404,699.80 11,063,777.12 WATER ACCOUNTS 06/01/22 --- 06/30/22 --- --- 29 1 --- --- --- 6,354,433.80 6,354,433.80 6,169,648.38 TOTAL - CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT) 23,674,429.72 P 23,674,429.72 23,148,721.62 NOTE. P2. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 06/30/2022, INCLUDES CASH AND INVESTMENTS OF $273,732.10 AND $6,144,000.00 RESPECTIVELY.
NOTE. P3. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 06/30/2022, INCLUDES CASH AND INVESTMENTS OF $327,922.71 AND $3,348,000.00 RESPECTIVELY.
REF
254,139,866.17 G
13,171,464.53 H
25,687,016.70 I
243,346.69 J
324,502.11 K
163,926.74 L
27,253,602.30 M
27,357,799.11 N
9,917,277.79 O
23,674,429.72 P
381,933,231.86 (G-P)
JUNE 2022
CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT) - REF: P
SCHEDULE OF INVESTMENTS
PUBLIC AGENCY RETIREMENT - OPEB (RESTRICTED FUNDS)
CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES)
CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT)
TOTAL - RECAP INVESTMENTS & CASH W/FISCAL AGENTS
PEPPER AVENUE EXTENSION - LINE OF CREDIT & CD (RESTRICTED FUNDS)
GENERAL FUND ECONOMIC RESERVE (RESTRICTED FUNDS)
CEMETERY ENDOWMENT FUND / INVESTMENTS
RECAP - INVESTMENTS & CASH W/FISCAL AGENTS
GENERAL POOLED FUNDS / INVESTMENTS
RUA / INVESTMENTS & STAGE COACH SWEEP ACCOUNT
RSA / STAGE COACH SWEEP ACCOUNT
OTHER BANK ACCOUNTS / STAGE COACH ACCOUNTS
INTEREST & GAIN/(LOSS) SUMMARY 07/31/21 - 05/31/2206/30/22 TOTAL TO DATE 1,067,848.03 107,636.13 1,175,484.16
5,935.83 10,188.58 16,124.41
83,455.40 14,806.99 98,262.39
150.18 180.04 330.22
(64,325.81) (29,750.33) (94,076.14)
4,344.00 5.58 4,349.58
15.21 1.41 16.62
36,848.97 4.51 36,853.48
1,801,543.75 (16,107.31) 1,785,436.44
1,742.45 3,263.00 5,005.45
32,811.17 5,954.87 38,766.04
TOTAL 2,970,369.18 96,183.47 3,066,552.65
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 (1,854,684.93) 62,388.50 9,735.97 (1,802,032.40) 05/31/22 37,101.98 25,344.04 9,259.61 53,186.41
06/30/22 (1,583,740.53) (16,107.31) (9,273.81) (1,590,574.03) TOTAL- PUBLIC AGENCY RETIREMENT OPEB (RESTRICTED FUNDS)(5,450,018.40) 1,785,436.44 80,017.17 (3,744,599.13)
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
JUNE 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
Fund
Security
Bank Balance
Ref
(cost)
RSA 2008 SERIES B - US BANK
Fees Account
******1500
343
Blackrock Prov T-Fund
0.00 Special Fund
******1501
343
Blackrock Prov T-Fund
4.82 Interest Account
******1502
343
Blackrock Prov T-Fund
0.00 Principal Account
******1503
343
Blackrock Prov T-Fund
0.00 Reserve Account
******1504
343
Blackrock Prov T-Fund
2,962,589.11
Total
2,962,593.93
RSA 2008 SERIES C - US BANK
Fees Account
******1600
343
Blackrock Prov T-Fund
0.00 Special Fund
******1601
343
Blackrock Prov T-Fund
3.55 Interest Account
******1602
343
Blackrock Prov T-Fund
0.00 Principal Account
******1603
343
Blackrock Prov T-Fund
0.00 Reserve Account
******1604
343
Blackrock Prov T-Fund
1,860,000.52
Total
1,860,004.07
RSA 2014 SERIES A - US BANK
Fees Account
******0600
343
Blackrock Prov T-Fund
0.00 Special Fund
******0601
343
Blackrock Prov T-Fund
1.20 Interest Account
******0602
343
Blackrock Prov T-Fund
0.00 Principal Account
******0603
343
Blackrock Prov T-Fund
0.00 Reserve Account
******0604
343
Blackrock Prov T-Fund
1.00 Redemption Fund
******0605
343
Blackrock Prov T-Fund
0.00 Total
2.20 RSA 2015 SERIES A & B - US BANK
Fees Account
******9300
343
Blackrock Prov T-Fund
0.00 Special Fund
******9301
343
Blackrock Prov T-Fund
3.81 Interest Account
******9302
343
Blackrock Prov T-Fund
0.00 Principal Account
******9303
343
Blackrock Prov T-Fund
0.00 Reserve Account
******9304
343
Blackrock Prov T-Fund
2.00 Redemption Fund
******9305
343
Blackrock Prov T-Fund
0.00 Total
5.81 CITY OF RIALTO
CASH W/FISCAL AGENTS
(RESTRICTED BOND ISSUES)
TRUSTEE BALANCES AS OF 06/30/2022
REFERENCE: O
ISSUE
Account
Fund
Security
Bank Balance
Ref
(cost)
CITY OF RIALTO
CASH W/FISCAL AGENTS
(RESTRICTED BOND ISSUES)
TRUSTEE BALANCES AS OF 06/30/2022
RSA 2015 SERIES C - US BANK
Fees Account
******9400
343
Blackrock Prov T-Fund
0.00 Special Fund
******9401
343
Blackrock Prov T-Fund
0.78 Interest Account
******9402
343
Blackrock Prov T-Fund
0.00 Principal Account
******9403
343
Blackrock Prov T-Fund
0.00 Reserve Account
******9404
343
Blackrock Prov T-Fund
1.00 Redemption Fund
******9405
343
Blackrock Prov T-Fund
0.00 Total
1.78 RSA 2018 REFUNDING 2008 SERIES A - US BANK
Fees Account
******4700
343
Blackrock Prov T-Fund
0.00 Special Fund
******4701
343
Blackrock Prov T-Fund
3.64 Interest Account
******4702
343
Blackrock Prov T-Fund
0.00 Principal Account
******4703
343
Blackrock Prov T-Fund
0.00 Reserve Account
******4704
343
Blackrock Prov T-Fund
1.00 Total
4.64 ELM PARK SERIES 2016 - US BANK
Special Tax Fund
******5000
871
T-Fund
0.49 Interest Account
******5001
871
T-Fund
13.87 Principal Account
******5002
871
T-Fund
0.00 Reserve Account
******5003
871
T-Fund
453,558.14
Admin Expense Account
******5004
871
T-Fund
0.00 Surplus Account
******5005
871
T-Fund
1.90 Total
453,574.40
CFD 2019-2 SERIES 2022 - US BANK
Special Tax Fund
******5000
873
T-Fund
0.00 Interest Account
******5001
873
T-Fund
572.08
Principal Account
******5002
873
T-Fund
0.00 Redemption Fund
******5003
873
T-Fund
0.00 Reserve Account
******5004
873
T-Fund
399,725.18
Surplus Account
******5006
873
T-Fund
0.00 Acquisition & Construction Fund
******5007
873
T-Fund
4,234,590.93
Cost of Issuance Account
******5008
873
T-Fund
6,202.77
Total
4,641,090.96
TOTAL - CASH W/FISCAL AGENTS
(RESTRICTED BOND ISSUES)
9,917,277.79
O
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
-
-
-
-
262.67
262.67
May
-
-
-
-
658.16
658.16
June
-
-
-
-
1,580.67
1,580.67
Total Interest
-
5.42 1.58
0.49 2,614.12
2,621.61
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 06/30/2022
-
4.82 (0.00)
0.00 2,962,589.11
2,962,593.93
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
-
-
-
-
164.91
164.91
May
-
-
-
-
413.21
413.21
June
-
-
-
-
992.39
992.39
Total Interest
-
4.10 1.17
0.46 1,641.38
1,647.11
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 06/30/2022
-
3.55 (0.00)
0.00 1,860,000.52
1,860,004.07
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 06/30/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 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 06/30/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 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 06/30/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 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 06/30/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
-
-
-
2.33 -
-
-
2.33 May
-
-
-
2.23 -
-
-
2.23 June
-
-
-
64.00 -
-
-
64.00 Total Interest
2.39 0.10
0.00 88.95
0.00 0.00
0.00 91.44
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 06/30/2022
0.49 13.87
-
453,558.14
-
1.90 -
453,574.40
NOTE: The activity shown above is cumulative throughout the months of 07/2021 - 06/2022.
CITY OF RIALTO
CFD 2019-2 BONDS SERIES 2022
Account No.
******5000
******5001
******5002
******5003
******5004
******5005
******5007
******5008
******5009
Account Description
Special Tax
Interest Acct.
Principal
Reserve
Admin Exp.
Surplus
Redemption
Redemption
Redemption
Total
Balance 07/01/2021
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
0.00 0.00
Interest
July
-
-
-
-
-
-
-
-
-
-
August
-
-
-
-
-
-
-
-
-
-
September
-
-
-
-
-
-
-
-
-
-
October
-
-
-
-
-
-
-
-
-
-
November
-
-
-
-
-
-
-
-
-
-
December
-
-
-
-
-
-
-
-
-
-
January
-
-
-
-
-
-
-
-
-
-
February
-
-
-
-
-
-
-
-
-
-
March
-
-
-
-
-
-
-
-
-
-
April
-
-
-
-
-
-
-
-
-
-
May
-
-
-
-
-
-
-
-
-
-
June
-
-
-
-
53.86 -
570.64
1.44 -
625.94
Total Interest
0.00 0.00
0.00 0.00
53.86 0.00
570.64
1.44 0.00
625.94
Debt Service
Wire In
399,671.32
4,234,590.93
220,000.00
4,854,262.25
Debt Service - Principal
-
Debt Service - Interest
-
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 ******6500
-
To/From ******5001
`
-
To/From ******5002
-
To/From ******5003
-
To/From ******5004
-
To/From ******5005
-
To/From ******5006
-
To/From ******5007
570.64
(570.64)
-
To/From ******5008
1.44 (1.44)
-
Invoices Paid
(213,797.23)
(213,797.23)
Balance 06/30/2022
-
572.08
-
-
399,725.18
-
4,234,590.93
6,202.77
-
4,641,090.96
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 40,086.22 40,086.22 40,086.22 MASTER REVENUE ******5001 N/A 5,872,080.82 5,872,080.82 5,872,080.82 ENVIRONMENTAL COMPLIANCE ******5002 N/A 3,071.08 3,071.08 3,071.08 REGULATORY COMPLIANCE ******5003 N/A - - - POST TERMINATION REVENUE ******5030 N/A - - - EXCLUDED ******5031 N/A 58.00 58.00 58.00 PRE-EXISTING ******5032 N/A - - - Total 5,915,296.12 5,915,296.12 5,915,296.12
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 543,809.35 543,809.35 543,809.35 WASTEWATER OPERATING R & R ******5012 N/A 1,352,734.61 1,352,734.61 1,352,734.61 WASTEWATER CAPITAL CHARGES ******5014 N/A - - - WASTEWATER RESERVE ******5016 N/A 273,732.10 273,732.10 273,732.10 P2 WASTEWATER RESERVE ******5016 CD'S 6,144,000.00 6,144,000.00 5,803,077.32 P2 WASTEWATER INTERIM RETENTION ******5018 N/A 1,602,877.22 1,602,877.22 1,602,877.22 WASTEWATER SURPLUS ******5020 N/A 832,868.82 832,868.82 832,868.82 WASTEWATER CONST. RESTRICTED ******5022 N/A 611,051.14 611,051.14 611,051.14 WASTEWATER CONST. UNRESTRICTED ******5023 N/A 43,626.56 43,626.56 43,626.56 WASTEWATER TAKINGS ******5026 N/A - - - WASTEWATER LOSS PROCEEDS ******5028 N/A - - - Total 11,404,699.80 11,404,699.80 11,063,777.12
WATER ACCOUNTS
WATER RATE STABILIZATION ******5005 N/A 334.71 334.71 334.71 WATER MASTER ******5007 N/A 0.33 0.33 0.33 WATER OPERATING ******5009 N/A - - - WATER FACILITY AUTHORITY EXPENSE ******5011 N/A 666,354.88 666,354.88 666,354.88 WATER OPERATING R & R ******5013 N/A 1,493,663.59 1,493,663.59 1,493,663.59 WATER CAPITAL CHARGES ******5015 N/A - - - WATER RESERVE ******5017 N/A 327,922.71 327,922.71 327,922.71 P3 WATER RESERVE ******5017 CD'S 3,348,000.00 3,348,000.00 3,163,214.58 P3 WATER INTERIM RETENTION ******5019 N/A 321,648.21 321,648.21 321,648.21 WATER SURPLUS ******5021 N/A 167,131.18 167,131.18 167,131.18 WATER CONST. RESTRICTED ******5024 N/A 4,358.45 4,358.45 4,358.45 WATER CONST. UNRESTRICTED ******5025 N/A - - - WATER TAKINGS ******5027 N/A - - - WATER LOSS PROCEEDS ******5029 N/A 25,019.74 25,019.74 25,019.74 Total 6,354,433.80 6,354,433.80 6,169,648.38
TOTAL CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT) 23,674,429.72 23,674,429.72 23,148,721.62 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 06/30/2022, INCLUDES CASH AND INVESTMENTS OF $273,732.10 AND $6,144,000.00 RESPECTIVELY.
NOTE. P3. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 06/30/2022, INCLUDES CASH AND INVESTMENTS OF $327,922.71 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 - 331.51 0.23 - - - - 331.74 May - 525.64 0.56 - - 0.01 - 526.21 June - 1,735.33 1.47 - - 0.03 - 1,736.83 Total Interest - 2,748.02 2.44 - - 57.18 - 2,807.64 Debt Service
Wire In -
Debt Service - Principal -
Debt Service - Interest -
Other Transactions
PAID TO/FROM ******5001 -
PAID TO/FROM ******5002 -
PAID TO/FROM ******5006 (28,384,607.49) (28,384,607.49) PAID TO/FROM ******5007 (14,015,227.86) (14,015,227.86) 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,838,227.56) (5,459,460.81) (8,297,688.37) RECEIVED FROM RUA ******4459 (46,368,391.71) 46,368,391.71 - RECEIVED FROM VEOLIA CHEMICAL REIMB. -
RECEIVED FROM CITY OF RIALTO 3,459,460.81 3,459,460.81 INVOICES PAID & VOIDED CHECKS (203,596.61) (203,596.61) DEPOSITS 46,404,080.83 46,404,080.83
DEPOSITS - WIRE -
NSF & CHARGE BACK (150,640.30) (150,640.30)
Balance 06/30/2022 40,086.22 5,872,080.82 3,071.08 - - 58.00 - 5,915,296.12 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 STABMASTER OPER FACILITY EXPOP R&R CAP CHARGESRESERVE INTERIM RETSURPLUSCONST RESTRICCONST UNRESTRICTAKINGSLOSS 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 60.68 109.34 136.46 55.75 46.08 3.29 411.60 May 137.10 253.61 162.39 329.47 112.38 8.02 1,002.97 June 373.88 654.34 246.54 713.49 291.95 20.84 2,301.04 Total Interest - - - 619.94 1,093.54 - 19,189.63 1,114.60 0.46 504.45 34.42 - - 22,557.04 Debt Service
Wire In -
Debt Service - Principal -
Debt Service - Interest -
Other Transactions
PAID TO/FROM ******5001 28,384,607.49 106,019.31 28,490,626.80 PAID TO/FROM ******5004 -
PAID TO/FROM ******5006 -
PAID TO/FROM ******5007 -
PAID TO/FROM ******5008 (8,135,495.20) 8,135,495.20 - PAID TO/FROM ******5010 (3,496,221.68) 3,496,221.68 - PAID TO/FROM ******5012 (525,000.00) 525,000.00 - PAID TO/FROM ******5014 (12,681,999.96) 12,681,999.96 - PAID TO/FROM ******5016 -
PAID TO/FROM ******5018 (3,545,890.65) 3,545,890.65 - PAID TO/FROM ******5020 (3,016,448.06) 3,016,448.06 - PAID TO/FROM ******5023 -
PAID TO/FROM ******5031 (3,081,341.76) (3,081,341.76)
PAID TO/FROM ******5032 -
PAID TO/FROM ******5101 (8,135,495.20) (12,681,999.96) (20,817,495.16) PAID TO/FROM ******5106 (837,307.86) (837,307.86) PAID TO/FROM ******5108 (583,749.70) (583,749.70)
PAID TO CITY OF RIALTO 1,180,648.86 1,180,648.86
INVOICES PAID (3,553,659.04) (3,553,659.04)
M2
Balance 06/30/2022 - 0.00 - 543,809.35 1,352,734.61 - 6,417,732.10 1,602,877.22 832,868.82 611,051.14 43,626.56 - - 11,404,699.80 NOTE. P2. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 06/30/2022, INCLUDES CASH AND INVESTMENTS OF $273,732.10 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 EXPOPER R&RCAP CHARGESRESERVEINTERIM RETSURPLUSCONST RESTRICCONST UNRESTRICTAKINGSLOSS PROCEEDS Bal 07/01/2021 1,500,000.00 0.00 0.00 784,335.491,462,526.67 0.00 3,614,370.41 122,116.75 102,237.94 4,355.00 0.00 0.00 25,000.007,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 52.83 86.06 107.04 24.73 32.57 0.33 1.89 305.45
May 128.84 191.37 265.65 60.31 57.62 0.80 4.60 709.19
June 334.71 552.13 701.54 156.67 157.92 2.08 11.95 1,917.00 Total Interest 550.08 0.00 0.00 893.82 1,146.30 0.00 10,528.19 259.42 0.36 3.45 0.00 0.00 19.74 13,401.36 Debt Service
Wire In 0.00
Debt Service - Principal 0.00
Debt Service - Interest 0.00
Other Transactions
PAID TO/FROM ******5001 14,094,491.91 14,094,491.91
PAID TO/FROM ******5002 0.00
PAID TO/FROM ******5005 0.00
PAID TO/FROM ******5006 0.00
PAID TO/FROM ******5007 (2,900,215.37)2,900,215.37 0.00 PAID TO/FROM ******5009 (6,995,368.15)6,995,368.15 0.00 PAID TO/FROM ******5010 (4,026,765.81) 4,026,765.81 0.00 PAID TO/FROM ******5011 (300,000.00) 300,000.00 0.00
PAID TO/FROM ******5013 (2,900,000.04) 2,900,000.04 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,721,548.84) 2,642,284.79 (79,264.05) PAID TO/FROM ******5021 (2,443,012.75)2,443,012.75 0.00 PAID TO/FROM ******5031 (2,378,119.87) (2,378,119.87)
PAID TO/FROM ******5032 0.00
PAID TO/FROM ******5101 (6,995,368.15) (2,900,000.04) (9,895,368.19) PAID TO/FROM ******5108 0.00
PAID TO/FROM ******5109 (270,009.38) (270,009.38)
PAID TO/FROM ******5600 0.00
MISC. DEPOSIT 47.81 47.81
WIRE FROM CITY OF RIALTO1,400,000.00 1,400,000.00
INVOICES PAID (4,145,688.05) (4,145,688.05)
M3
Balance 06/30/2022 334.71 0.33 0.00 666,354.881,493,663.59 0.00 3,675,922.71 321,648.21 167,131.18 4,358.45 0.00 0.00 25,019.746,354,433.80 NOTE. P3. CASH W/FISCAL AGENTS - RUA, WATER RESERVE ACCOUNT AS OF 06/30/2022, INCLUDES CASH AND INVESTMENTS OF $327,922.71 AND $3,348,000.00 RESPECTIVELY.
NOTE: THE ACTIVITY SHOWN ABOVE CUMULATIVE THROUGHT THE MONTHS OF 07/2021 - 06/2022.