TO: The Honorable Mayor and City Council,
City Manager, Assistant City Manager, Finance Director
FROM: Edward J. Carrillo - City Treasurer
REF
General Pooled Funds Investments + Cash Sweep Bank Account………………………………………………………………………………………….237,519,771 57% A,G Rialto Successor Agency (RSA) + Cash Sweep Bank Account…………………………………………………………………………………................................2,335,011 1% B,H Rialto Utility Authority (RUA) Pre-existing Investments + Cash Sweep Bank Account…………………………………………………………………………………………….15,906,955 4% C,I Other Bank Accounts + Cash Sweep Bank Accounts…………………………………………………………………………………………………………………….............2,521,256 1% D,J Escrow Accounts…………………………………………………………………………………………………………………………….................................................14,764,373 4% E Cemetery Endowment Fund (Restricted Accounts)…………………………………………………………………...........................................................................448,458 0% F,K General Fund Economic Reserve (Restricted Funds)……………………………………………………………………...............................................28,758,647 7% M Public Agency Retirement Services - OPEB (Restricted Funds)……………………………………………………………………..................................28,378,543 7% N Cash with Fiscal Agents - (Restricted Bond Issues)…………………………………………………………………………......................................................9,807,370 2% O Cash with Fiscal Agents - RUA (Concession Agreement)…………………………………………………………………..........................................................77,347,021 19% P CITY OF RIALTO'S PORTFOLIO 417,787,404 100%
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 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 the custody.
US Bank (Corporate Trust Department) provided Fiscal Agent information.
All figures are rounded to the nearest dollar.
City of Rialto
Treasurer's Monthly Report
November 30, 2024
OCTOBER 2024 NOVEMBER 2024
ACTIVE ACCOUNTS BALANCE RECEIPTS DISBURSEMENTS BALANCE REF GENERAL BANK ACCOUNT ** (1,374,820) 32,821,135 32,606,686 (1,160,371) A RSA BANK ACCOUNT ** (0) 28,295 28,295 (0) B RUA BANK ACCOUNT ** (6,095) 4,879,613 5,185,703 (312,186) C SPORTS CENTER/POOL ** - 37 37 - AMBULANCE LOCKBOX 344,827 363,254 - 708,081 FLEXIBLE BENEFIT** - 6,579 6,579 - ALARM LOCKBOX 21,735 13,408 27 35,116 BANK CARD 0 - - 0 PAYROLL CLEARING 140,741 140,741 GENERAL LIABILITY - GEORGE HILLS CO. 95,000 180,000 269,732 5,268 WORKERS COMPENSATION - LWP CLAIMS SOLUTIONS CO. 111,069 - - 111,069 WORKERS COMPENSATION - ADMINSURE 20,816 134,010 157,682 (2,856) PROPERTY EVIDENCE MONIES 1,503,038 - 5,926 1,497,112 OTHER BANK ACCOUNTS 2,237,227 697,288 439,984 2,494,531 D ENERGY CONSERVATION PROJECT 84,787 - - 84,787 AYALA @ 210 PARTNERS LLC 311,366 26 - 311,392 LEWIS/ HILLWOOD 4,520,345 16,369 4,489 4,532,225 ALDER AVENUE 3,581,161 12,968 3,556 3,590,573 SUB ACCOUNT A 6,229,027 22,557 6,186 6,245,397 ESCROW ACCOUNTS 14,726,685 51,919 14,231 14,764,373 E CEMETERY ENDOWMENT FUND 102,514 8 - 102,522 RESTRICTED ACCOUNTS 102,514 8 - 102,522 F TOTAL - ACTIVE ACCOUNTS 15,685,510 15,888,871 (A-F) OCTOBER 2024 NOVEMBER 2024
INVESTMENT ACCOUNTS BALANCE RECEIPTS DISBURSEMENTS BALANCE REF GENERAL POOLED FUNDS 240,034,838 23,666,268 25,020,965 238,680,141 G RIALTO SUCCESSOR AGENCY (RSA) 2,307,337 36,783 9,110 2,335,011 H RIALTO UTILITY AUTHORITY (RUA) 18,741,789 106,569 2,629,217 16,219,140 I OTHER BANK ACCOUNTS 33,193 148 6,616 26,725 J CEMETERY ENDOWMENT FUND 345,845 91 - 345,936 K GENERAL FUND ECONOMIC RESERVE 28,711,981 48,614 1,948 28,758,647 M PUBLIC AGENCY RETIREMENT SERVICES - OPEB 28,347,961 40,168 9,586 28,378,543 N CASH WITH FISCAL AGENTS - BOND ISSUES 9,764,432 67,754 24,815 9,807,370 O CASH WITH FISCAL AGENTS - RUA CONCESSION AGREEMENT 75,006,788 16,846,952 14,506,720 77,347,021 P TOTAL - ACTIVE ACCOUNTS 403,294,164 401,898,534 (G-P) 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.
City of Rialto
TREASURER'S BANK
RECONCILIATION BALANCE SHEET
SCHEDULE OF INVESTMENTS
PURCHASE CALL MATURITY COUPON MONTHS RATING RATING AMOUNT PAR MARKET CUSIP # ISSUER TYPE OF INVESTMENT DATE DATE DATE RATE YIELD REMAINING MOODY'S S&P INVESTED REF VALUE VALUE 94975H296 ALLSPRING TREASURY PLUS MONEY MARKET MUTUAL FUNDS 11/01/24 --- --- --- 4.50% --- AAA AAA 65,353,836 65,353,836 65,353,836 65,353,836 65,353,836 65,353,836
PURCHASE CALL MATURITY COUPON MONTHS RATING RATING AMOUNT PAR MARKET CUSIP # ISSUER TYPE OF INVESTMENT DATE DATE DATE RATE YIELD REMAINING MOODY'S S&P INVESTED REF VALUE VALUE 8000458474 PACIFIC PREMIER BANK BUSINESS MONEY MARKET 11/01/24 --- 4.88% 1,054,742 1,054,742 1,054,742 1,054,742 1,054,742 1,054,742
8000533018 PACIFIC PREMIER BANK BUSINESS MONEY MARKET 11/01/24 ---- 4.88% 5,266,173 5,266,173 5,266,173 5,266,173 5,266,173 5,266,173
800620123 PACIFIC PREMIER BANK BUSINESS MONEY MARKET 11/01/24 ---- 4.88% 4,082,127 4,082,127 4,082,127 4,082,127 4,082,127 4,082,127
98-36-722 LOCAL AGENCY INVESTMENT FUND LAIF 11/01/24 --- --- --- 4.43% --- --- --- 12,373,130 12,373,130 12,373,130 12,373,130 12,373,130 12,373,130
PURCHASE CALL MATURITY COUPON MONTHS RATING RATING AMOUNT PAR MARKET CUSIP # ISSUER TYPE OF INVESTMENT DATE DATE DATE RATE YIELD REMAINING MOODY'S S&P INVESTED REF VALUE VALUE 3133ENLD0 FEDERAL FARM CREDIT BANK CORPORATE BOND 01/11/22 --- 01/26/26 1.53% 1.58% 14 A2 A- 2,000,000 2,000,000 1,937,983 3134GXSM7 FEDERAL HOME LOAN BANK MTG CORP AGENCY BOND 04/22/22 11/17/24 05/17/27 4.00% 4.01% 30 AAA AA+ 1,000,000 1,000,000 997,144 3130ARX55 FEDERAL HOME LOAN BANK AGENCY BOND 04/27/22 11/26/24 11/26/24 3.13% 3.13% 0 AAA AA+ 0 0 0 83369NHL7 SOCIETE GENERALE AGENCY BOND 01/18/22 01/20/25 01/20/27 1.95% 2.06% 26 AAA N/A 2,000,000 2,000,000 1,894,454 --- TREASURY MONEY MARKET MONEY MARKET MUTUAL FUND 11/01/24 --- 11/30/24 4.95% --- AAA AAA 5,302,704 5,302,704 5,302,704 --- CASH CASH 11/01/24 --- 11/30/24 --- --- --- --- --- 0 0 0 10,302,704 10,302,704 10,132,285
GENERAL INVESTMENT FUNDS - SUBTOTAL
GENERAL INVESTMENT FUNDS - WELLS FARGO CASH SWEEP ACCOUNT
GENERAL INVESTMENT FUNDS - LOCAL AGENCY INVESTMENT FUND (LAIF) GENERAL INVESTMENT FUNDS - J.P. MORGAN ADVISORS
NOTE: REF G (CONTINUED TO NEXT PAGE)
GENERAL INVESTMENT FUNDS - SUBTOTAL
GENERAL INVESTMENT FUNDS - SUBTOTAL
GENERAL INVESTMENT FUNDS - SUBTOTAL
GENERAL INVESTMENT FUNDS - PACIFIC PREMIER BANK
GENERAL INVESTMENT FUNDS - SUBTOTAL
GENERAL INVESTMENT FUNDS - PACIFIC PREMIER BANK
GENERAL INVESTMENT FUNDS - SUBTOTAL
GENERAL INVESTMENT FUNDS - PACIFIC PREMIER BANK
GENERAL POOLED FUNDS / INVESTMENTS - REF: G
NOVEMBER 2024
PURCHASE CALL MATURITY COUPON MONTHS RATING RATING AMOUNT PAR MARKET CUSIP # ISSUER TYPE OF INVESTMENT DATE DATE DATE RATE YIELD REMAINING MOODY'S S&P INVESTED REF VALUE VALUE 38150AFM2 GOLDMAN SACHS GRP INC MTN CALLABLE CORPORATE BOND 05/10/21 05/12/24 11/12/24 1.00% 1.00% -1 A2 BBB+ 0 0 0 02665WEA5 AMERICAN HONDA FINANCE MEDIUM TERM NOTE CORPORATE BOND 09/27/23 --- 01/13/25 1.50% 1.50% 1 A3 A- 1,233,804 1,300,000 1,294,787 06051GFM6 BANK OF AMERICA CORP INTERNOTES MTN CORPORATE BOND 11/21/23 --- 01/22/25 4.00% 4.00% 2 A3 BBB+ 2,937,000 3,000,000 2,995,860 037833AZ3 APPLE INC SR UNSECURED CORPORATE BOND 02/04/21 --- 02/09/25 2.50% 2.51% 2 AAA AA+ 2,157,500 2,000,000 1,991,760 94974BGH7 WELLS FARGO & CO SR SECURED CORPORATE BOND 07/11/24 --- 06/30/25 3.00% 3.01% 7 A1 BBB+ 986,500 1,000,000 995,960 89236TKC8 TOYOTA MOTOR CREDIT CORP SR UNSECURED CORPORATE BOND 06/24/24 --- 06/30/25 3.95% 3.96% 7 A1 A+ 3,149,631 3,190,000 3,176,985 025816CY3 AMERICAN EXPRESS CO SR UNSECURED CALLABLE CORPORATE BOND 07/11/24 07/01/25 08/01/25 3.95% 3.96% 8 A2 BBB+ 5,011,187 5,060,000 5,036,117 06048WK66 BANK OF AMERICA CORP MULTISTEP UP MTN CALLABLE CORPORATE BOND 02/04/21 12/23/24 12/23/25 0.85% 0.88% 13 A2 A- 1,994,000 2,000,000 1,916,100 17290AEA4 CITIGROUP INC. MTN CALLABLE CORPORATE BOND 10/15/21 01/19/25 10/19/26 1.45% 1.56% 23 A3 BBB+ 5,000,000 5,000,000 4,647,150 46625HJZ4 JPMRGAN CHASE & CO SUB BOND CORPORATE BOND 10/28/24 --- 12/15/26 4.13% 4.16% 24 A3 BBB+ 5,214,458 5,250,000 5,202,173 48128G5Y2 JPMORGAN CHASE & CO MTN CALLABLE CORPORATE BOND 01/27/22 01/31/25 01/29/27 2.10% 2.24% 26 A2 A- 3,000,000 3,000,000 2,806,350 3815AL29 GOLDMAN SACHS GRP INC MTN CALLABLE CORPORATE BOND 02/28/22 03/02/25 03/02/27 3.00% 3.18% 27 A2 BBB+ 5,000,000 5,000,000 4,712,950 95001HJB8 WELLS FARGO FIN MTN CORPORATE BOND 10/18/24 10/23/25 10/23/27 4.50% 4.52% 35 A1 BBB+ 17,000,000 17,000,000 16,907,520 06055JGA1 BANK OF AMERICA CORP MTN CALLABLE CORPORATE BOND 09/06/24 03/10/25 09/10/29 5.00% 5.01% 57 A1 A- 17,000,000 17,000,000 16,932,850 912797KA4 US TREASURY BILL TREASURY BILL 04/01/24 --- 02/20/25 N/A N/A 3 N/A N/A 3,201,653 3,345,000 3,312,319 3130ANZ60 FEDERAL HOME LOAN BANK AGENCY BOND 09/08/21 12/27/24 06/27/25 0.90% 1.12% 7 AAA AA+ 1,500,000 1,500,000 1,472,430 3133EL3H5 FEDERAL HOME LOAN BANK AGENCY BOND 08/27/24 12/05/24 08/12/25 0.57% 0.58% 8 AAA AA+ 1,013,282 1,050,000 1,022,291 3130ALZA5 FEDERAL HOME LOAN BANK AGENCY BOND 04/13/21 01/29/25 04/29/26 1.00% 2.04% 17 AAA AA+ 6,000,000 6,000,000 5,866,080 3130AMB76 FEDERAL HOME LOAN BANK AGENCY BOND 05/18/21 02/18/25 05/18/26 1.25% 1.30% 18 AAA AA+ 1,108,800 1,100,000 1,052,568 3130AMKN1 FEDERAL HOME LOAN BANK AGENCY BOND 05/18/21 02/27/25 05/27/26 1.00% 1.55% 18 AAA AA+ 8,900,000 8,900,000 8,606,567 3130ANUT5 FEDERAL HOME LOAN BANK AGENCY BOND 08/30/21 12/16/24 09/16/26 1.00% 1.30% 22 AAA AA+ 10,000,000 10,000,000 9,608,000 3130ANZ52 FEDERAL HOME LOAN BANK AGENCY BOND 09/08/21 12/28/24 09/28/26 1.00% 1.30% 22 AAA AA+ 2,500,000 2,500,000 2,400,050 3130ANXC9 FEDERAL HOME LOAN BANK AGENCY BOND 09/02/21 12/29/24 09/29/26 0.88% 1.04% 22 AAA AA+ 5,000,000 5,000,000 4,789,600 68405VBC2 OPTUM BANK INC CD CERTIFICATES OF DEPOSIT 10/03/23 --- 04/16/25 5.45% 5.43% 5 N.A. N.A. 249,000 249,000 249,834 87165H3R9 SYNCHRONY BANK CD CERTIFICATES OF DEPOSIT 10/23/23 --- 04/28/25 5.40% 5.40% 5 N.A. N.A. 249,000 249,000 249,949 949764GX6 WELLS FARGO BANK CD CERTIFICATES OF DEPOSIT 10/17/23 --- 10/24/25 5.35% 5.30% 11 N.A. N.A. 249,000 249,000 251,199 06740KSC2 BARCLAYS BNK/DELWARE CD CERTIFICATES OF DEPOSIT 10/17/23 --- 10/27/25 5.35% 5.30% 11 N.A. N.A. 249,000 249,000 251,234 48128WBQ7 JP MORGAN CHASE BANK NORTH AMERICA CERTIFICATES OF DEPOSIT 10/13/21 04/29/25 10/29/26 1.00% 1.04% 23 N.A. N.A. 125,000 125,000 119,415 89114TF49 TORONTO DOMINION BANK MTN CALLABLE CORPORATE BOND 03/20/21 01/01/25 04/01/25 1.00% 1.01% 4 A1 A 5,000,000 5,000,000 4,940,000 06747PKV0 BARCLAYS BANK PLC MTN CALLABLE CORPORATE BOND 06/08/20 --- 04/08/25 3.25% 3.27% 4 A1 A 5,136,480 4,920,000 4,881,329 22553PTR0 CREDIT SUISSE AG LONDON MTN CALLABLE CORPORATE BOND 05/04/22 02/06/25 05/06/25 4.00% 4.04% 5 A1 N.A. 5,000,000 5,000,000 4,946,450 89114VCS4 TORONTO-DOMINION BANK MTN CORPORATE BOND 04/26/22 01/31/25 10/31/25 3.50% 4.04% 11 A1 A 5,000,000 5,000,000 4,946,250 89114X2S1 TORONOT-DOMINION BANK MTN CORPORATE BOND 06/27/22 01/31/25 06/30/27 5.00% 5.03% 31 A1 A 10,000,000 10,000,000 9,920,900 60934N500 FEDERATED HERMES TREASURY OBLIGATIONS FUND MONEY MARKET MUTUAL FUNDS 11/01/24 --- 11/30/24 --- 4.82% --- AAA AAA 1,402 1,402 1,402 --- CASH CASH 11/01/24 --- 11/30/24 --- 4.27% --- --- --- 80,735 80,735 80,735 140,247,430 140,318,137 137,585,162
238,680,141 G 229,402,548 226,499,154
GENERAL INVESTMENT FUNDS - SUBTOTAL
GENERAL FUNDS - TOTAL
GENERAL INVESTMENT FUNDS - WELLS FARGO ADVISORS
NOVEMBER 2024
SCHEDULE OF INVESTMENTS
GENERAL POOLED FUNDS / INVESTMENTS - REF: G (CONTINUED)
PURCHASE CALL MATURITY COUPON MONTHS RATING RATING AMOUNT PAR MARKET CUSIP # ISSUER TYPE OF INVESTMENT DATE DATE DATE RATE YIELD REMAINING MOODY'S S&P INVESTED REF VALUE VALUE 94975H296 ALLSPRING TREASURY PLUS MONEY MARKET MUTUAL FUNDS 11/01/24 11/30/24 --- 4.50% --- --- --- 2,335,011 2,335,011 2,335,011 2,335,011 H 2,335,011 2,335,011
PURCHASE CALL MATURITY COUPON MONTHS RATING RATING AMOUNT PAR MARKET CUSIP # ISSUER TYPE OF INVESTMENT DATE DATE DATE RATE YIELD REMAINING MOODY'S S&P INVESTED REF VALUE VALUE 94975H296 ALLSPRING TREASURY PLUS MONEY MARKET MUTUAL FUNDS 11/01/24 --- 11/30/24 --- 4.50% --- --- --- 6,319,059 6,319,059 6,319,059 6,319,059 6,319,059 6,319,059
PURCHASE CALL MATURITY COUPON MONTHS RATING RATING AMOUNT PAR MARKET CUSIP # ISSUER TYPE OF INVESTMENT DATE DATE DATE RATE YIELD REMAINING MOODY'S S&P INVESTED REF VALUE VALUE --- LOCAL AGENCY INVESTMENT FUND LAIF 11/01/2022 --- 11/30/24 --- 4.48% --- --- --- 108,960 108,960 108,960 108,960 108,960 108,960
PURCHASE CALL MATURITY COUPON MONTHS RATING RATING AMOUNT PAR MARKET CUSIP # ISSUER TYPE OF INVESTMENT DATE DATE DATE RATE YIELD REMAINING MOODY'S S&P INVESTED REF VALUE VALUE 06051GFM6 BANK OF AMERICA CORP CORPORATE BOND 11/21/23 --- 01/22/25 4.00% 4.00% 16 A3 BBB+ 1,958,000 2,000,000 1,997,240 06051GFP9 BANK OF AMERICA CORP INTERNOTES SUB CORPORATE BOND 08/16/23 --- 04/21/25 3.95% 3.96% 16 A3 BBB+ 1,098,362 1,135,000 1,130,369 3130AMRA2 FEDERAL HOME LOAN BANK GOVERNMENT BOND 06/02/21 12/24/24 06/24/26 1.00% 1.03% 36 A3 AA+ 1,000,000 1,000,000 967,320 89114TF49 TORONTO DOMINION BANK MTN CALLABLE CORPORATE BOND 03/30/21 01/01/25 04/01/25 1.00% 1.01% 21 A1 A 3,000,000 3,000,000 2,964,000 60934N500 FEDERATED HERMES TREASURY OBLIGATIONS FUND MONEY MARKET MUTUAL FUNDS 11/01/24 --- 11/30/24 --- 4.82% --- AAA AAA 2,109 2,109 2,109 --- CASH CASH 11/01/24 --- 11/30/24 --- 4.27% --- --- --- 2,732,650 2,732,650 2,732,650 9,791,121 9,869,759 9,793,688
16,219,140 I 16,297,778 16,221,707
PURCHASE CALL MATURITY COUPON MONTHS RATING RATING AMOUNT PAR MARKET CUSIP # ISSUER TYPE OF INVESTMENT DATE DATE DATE RATE YIELD REMAINING MOODY'S S&P INVESTED REF VALUE VALUE 94975H296 ALLSPRING TREASURY PLUS MONEY MARKET MUTUAL FUNDS 11/01/24 --- 11/30/24 --- 4.50% --- AAA AAA 9,436 9,436 9,436 9,436 9,436 9,436
PURCHASE CALL MATURITY COUPON MONTHS RATING RATING AMOUNT PAR MARKET CUSIP # ISSUER TYPE OF INVESTMENT DATE DATE DATE RATE YIELD REMAINING MOODY'S S&P INVESTED REF VALUE VALUE 94975H296 ALLSPRING TREASURY PLUS MONEY MARKET MUTUAL FUNDS 11/01/24 --- 11/30/24 --- 4.52% --- AAA AAA 17,289 17,289 17,289 17,289 17,289 17,289
26,725 J 26,725 26,725
OTHER BANK ACCOUNTS - CASH SWEEP ACCOUNTS - REF: J
NOVEMBER 2024
RUA INVESTMENTS - WELLS FARGO ADVISORS
RUA INVESTMENTS - LOCAL AGENCY INVESTMENT FUND (LAIF)
RUA INVESTMENTS - SUBTOTAL
RUA INVESTMENTS - SUBTOTAL
RUA INVESTMENTS - SUBTOTAL
RUA INVESTMENTS - TOTAL
SCHEDULE OF INVESTMENTS
RUA INVESTMENTS - WELLS FARGO CASH SWEEP ACCOUNT
RSA INVESTMENTS - TOTAL
SCHEDULE OF INVESTMENTS
RSA INVESTMENTS - WELLS FARGO CASH SWEEP ACCOUNT
RUA PRE-EXISTING / INVESTMENTS - REF: I
NOVEMBER 2024
SCHEDULE OF INVESTMENTS
RSA STAGE COACH SWEEP ACCOUNT - REF: H
NOVEMBER 2024
SPORTS CENTER & POOL - WELLS FARGO CASH SWEEP ACCOUNT
OTHER BANK ACCOUNTS INVESTMENTS - TOTAL
OTHER BANK ACCOUNTS INVESTEMENTS - SUBTOTAL
OTHER BANK ACCOUNTS INVESTEMENTS - SUBTOTAL
SCHEDULE OF INVESTMENTS
CEMETERY ENDOWMENT FUND - REF: K
NOVEMBER 2024
FLEXIBLE BENEFIT - WELLS FARGO CASH SWEEP ACCOUNT
PURCHASE CALL MATURITY COUPON MONTHS RATING RATING AMOUNT PAR MARKET CUSIP # ISSUER TYPE OF INVESTMENT DATE DATE DATE RATE YIELD REMAINING MOODY'S S&P INVESTED REF VALUE VALUE 38150AFG5 GOLDMAN SACHS GRP INC MTN CALLABLE CORPORATE BOND 04/28/21 01/30/25 04/30/26 1.50% 1.57% 17 A2 BBB+ 320,000 320,000 305,427 60934N500 FEDERATED HERMES TREASURY OBLIGATIONS FUND MONEY MARKET MUTUAL FUNDS 11/01/24 --- 11/30/24 --- 4.82% --- AAA AAA 113 113 113 --- CASH CASH 11/01/24 --- 11/30/24 --- 4.27% --- --- --- 25,824 25,824 25,824 345,936 K 345,936 331,363CEMETERY ENDOWMENT FUND - TOTAL
CEMETERY ENDOWMENT FUND - WELLS FARGO ADVISORS
PURCHASE CALL MATURITY COUPON MONTHS RATING RATING AMOUNT PAR MARKET CUSIP # ISSUER TYPE OF INVESTMENT DATE DATE DATE RATE YIELD REMAINING MOODY'S S&P INVESTED REF VALUE VALUE 912797LC9 US TREASURY GOVERNMENT BOND 08/07/24 --- 11/07/24 --- N/A -1 --- --- 0 0 0 912797LC9 US TREASURY GOVERNMENT BOND 08/08/24 --- 11/07/24 --- N/A -1 --- --- 0 0 0 62479LP4 MUFG BANK LTD/NY COMMERCIAL PAPER 11/07/24 --- 02/07/25 --- N/A 2 --- --- 3,707,402 3,750,000 3,716,588 912797LP0 US TREASURY GOVERNMENT BOND 09/11/24 --- 12/24/24 --- N/A 1 --- --- 5,652,203 5,720,000 5,712,736 912797LP0 US TREASURY GOVERNMENT BOND 09/11/24 --- 12/24/24 --- N/A 1 --- --- 5,494,100 5,560,000 5,552,939 912797LP0 US TREASURY GOVERNMENT BOND 09/12/24 --- 12/24/24 --- N/A 1 --- --- 5,499,959 5,565,000 5,557,932 912797LQ8 US TREASURY GOVERNMENT BOND 09/18/24 --- 12/19/24 --- N/A 1 --- --- 4,903,076 4,960,000 4,949,336 912797MZ7 US TREASURY GOVERNMENT BOND 10/28/24 --- 01/28/25 --- N/A 2 --- --- 3,500,765 3,540,000 3,514,901 FEDERATED HERMES TREASURY OBLIGATIONS FUND MONEY MARKET MUTUAL FUNDS 11/01/24 --- 11/30/24 --- 4.82% --- --- --- 679 679 679 --- CASH CASH 11/01/24 --- 11/30/24 --- 4.27% --- --- --- 463 463 463 28,758,647 M 29,096,142 29,005,574
PURCHASE CALL MATURITY COUPON MONTHS RATING RATING AMOUNT PAR MARKET CUSIP # ISSUER TYPE OF INVESTMENT DATE DATE DATE RATE YIELD REMAINING MOODY'S S&P INVESTED REF VALUE VALUE PARS OPEB TRUST PROGRAM 115P 11/01/24 --- 11/30/24 --- --- --- --- --- 28,378,543 28,378,543 29,574,746 PARS OPEB TRUST PROGRAM 115P - PENSION 11/01/24 --- 11/30/24 --- --- --- --- --- 0 0 0 28,378,543 N 28,378,543 29,574,746
PURCHASE CALL MATURITY COUPON MONTHS RATING RATING AMOUNT PAR MARKET CUSIP # ISSUER TYPE OF INVESTMENT DATE DATE DATE RATE YIELD REMAINING MOODY'S S&P INVESTED REF VALUE VALUE 2008 SERIES B 11/01/24 --- 11/30/24 --- --- --- --- --- 3,161,436 3,161,436 3,161,436 2008 SERIES C 11/01/24 --- 11/30/24 --- --- --- --- --- 1,985,431 1,985,431 1,985,431 2014 SERIES A 11/01/24 --- 11/30/24 --- --- --- --- --- 3,194 3,194 3,194 2015 SERIES A & B 11/01/24 --- 11/30/24 --- --- --- --- --- 3,675 3,675 3,675 2015 SERIES C 11/01/24 --- 11/30/24 --- --- --- --- --- 1,167 1,167 1,167 2018 REFUNDING 2008 SERIES A 11/01/24 --- 11/30/24 --- --- --- --- --- 2,268 2,268 2,268 2016 ELM PARK 11/01/24 --- 11/30/24 --- --- --- --- --- 482,214 482,214 482,214 2022 SERIES CFD 2019-2 FOOTHILL & SPRUCE 11/01/24 --- 11/30/24 --- --- --- --- --- 414,490 414,490 414,490 EL RANCHO VERDE SERIES 2023 11/01/24 --- 11/30/24 --- --- --- --- --- 3,753,495 3,753,495 3,753,495 9,807,370 O 9,807,370 9,807,370
SCHEDULE OF INVESTMENTS
SCHEDULE OF INVESTMENTS
PUBLIC AGENCY RETIREMENT - OPEB (RESTRICTED FUNDS) - REF: N NOVEMBER 2024
SCHEDULE OF INVESTMENTS
GENERAL FUND ECONOMIC RESERVE (RESTRICTED FUNDS) - REF: M NOVEMBER 2024
GENERAL FUND ECONOMIC RESERVE (RESTRICTED FUNDS) - TOTAL CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES) - REF: O NOVEMBER 2024
GENERAL FUND ECONOMIC RESERVE - WELLS FARGO ADVISORS
PUBLIC AGENCRY RETIREMENT OPEB - US BANK
CASH WITH FISCAL AGENTS - US BANK
PUBLIC AGENCY RETIREMENT OPEB (RESTRICTED FUNDS) TOTAL
TOTAL - CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES)
PURCHASE CALL MATURITY COUPON MONTHS RATING RATING AMOUNT PAR MARKET CUSIP # ISSUER TYPE OF INVESTMENT DATE DATE DATE RATE YIELD REMAINING MOODY'S S&P INVESTED REF VALUE VALUE RIALTO TRUST AND RUA LOCKBOX ACCOUNTS 11/01/24 --- 11/30/24 --- --- --- --- --- 8,693,768 8,693,768 8,693,768 WASTEWATER ACCOUNTS 11/01/24 --- 11/30/24 --- --- --- --- --- 47,914,005 47,914,005 47,914,005 WATER ACCOUNTS 11/01/24 --- 11/30/24 --- --- --- --- --- 20,739,247 20,739,247 20,739,247 77,347,021 P 77,347,021 77,347,021
REF
238,680,141 G
2,335,011 H
16,219,140 I
26,725 J
345,936 K
28,758,647 M
28,378,543 N
9,807,370 O
77,347,021 P
401,898,534 (G-P)
CASH WITH FISCAL AGENTS - RUA (CONCESSION AGREEMENT) - TOTAL
GENERAL POOLED FUNDS / INVESTMENTS
RSA / STAGE COACH SWEEP ACCOUNT
RUA / INVESTMENTS & STAGE COACH SWEEP ACCOUNT
RECAP - INVESTMENTS & CASH W/FISCAL AGENTS
SCHEDULE OF INVESTMENTS
CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT) - REF: P NOVEMBER 2024
CASH W/FISCAL AGENTS - RUA (CONCESSION AGREEMENT)
TOTAL - RECAP INVESTMENTS & CASH W/FISCAL AGENTS
OTHER BANK ACCOUNTS / STAGE COACH ACCOUNTS
CASH WITH FISCAL AGENTS RUA (CA) - US BANK
CEMETERY ENDOWMENT FUND / INVESTMENTS
GENERAL FUND ECONOMIC RESERVE (RESTRICTED FUNDS)
PUBLIC AGENCY RETIREMENT - OPEB (RESTRICTED FUNDS)
CASH W/FISCAL AGENTS (RESTRICTED BOND ISSUES)
INTEREST & GAIN/(LOSS) SUMMARY 07/2024-10/2024 11/30/2024 TOTAL TO DATE 3,534,407.94 539,701.70 4,074,109.64
92,482.91 8,644.54 101,127.45 275,702.93 39,655.60 315,358.53
706.56 110.96 817.52
288,092.87 37,688.24 325,781.11
2,805.67 99.12 2,904.79 285,010.85 46,666.29 331,677.14
2,960,212.82 40,167.78 3,000,380.60
243,051.58 42,938.65 285,990.23
687,863.18 290,809.59 978,672.77
TOTAL 8,370,337.31 1,046,482.47 9,416,819.78
PUBLIC AGENCY RETIREMENT OPEB (RESTRICTED FUNDS)
MONTHLY DETAIL
UNREALIZED
GAIN(LOSS) INTEREST EXPENSES TOTAL TO DATE
7/31/2024 567,136.27 100,143.51 9,736.20 657,543.58
8/31/2024 253,207.38 266,644.41 9,893.61 509,958.18
9/30/2024 (414,290.06) 822,239.55 9,606.56 398,342.93
10/31/2024 (2,353,214.73) 1,771,185.35 9,733.44 (591,762.82) 11/30/2024 824,966.53 40,167.78 9,586.34 855,547.97
12/31/2024 0.00 0.00
1/31/2025 0.00 0.00
2/28/2025 0.00 0.00
3/31/2025 0.00 0.00
4/30/2025 0.00 0.00
5/31/2025 0.00 0.00
6/30/2025 0.00 0.00
TOTAL- PUBLIC AGENCY RETIREMENT OPEB (RESTRICTED FUNDS) (1,122,194.61) 3,000,380.60 48,556.15 1,829,629.84
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)
City of Rialto
INVESTMENT INTEREST & GAINS/(LOSS) SCHEDULE
NOVEMBER 2024
GENERAL POOLED FUNDS / INVESTMENTS
RSA BANK SWEEP ACCOUNT INTEREST
Jul-24 Aug-24 Sep-24 Oct-24 Nov-24 Dec-24 Jan-25 Feb-25 Mar-25 Apr-25 May-25 Jun-25 YTD Total
GENERAL POOLED FUNDS /
INVESTMENTS LAIF#6722 136,430.44$ -$ -$ 145,012.50$ -$ 281,442.94$
GENERAL POOLED FUNDS /
INVESTMENTS PPB#3018 21,370.08$ 21,456.58$ 20,850.98$ 21,633.79$ 21,021.23$ 106,332.66$
GENERAL POOLED FUNDS /
INVESTMENTS PPB#8474 4,280.17$ 4,295.88$ 4,176.18$ 4,332.96$ 4,210.27$ 21,295.46$
GENERAL POOLED FUNDS /
INVESTMENTS PPB#0123 16,096.98$ 16,678.76$ 16,206.68$ 16,815.32$ 16,339.37$ 82,137.11$
GENERAL POOLED FUNDS /
INVESTMENTS CASH SWEEP - GENERAL 374,947.59$ 237,478.13$ 213,918.30$ 219,242.60$ 224,096.60$ 1,269,683.22$
GENERAL POOLED FUNDS /
INVESTMENTS CUSTODIAL INTEREST 441,101.67$ 195,192.62$ 423,001.88$ 500,350.69$ 175,083.91$ 1,734,730.77$
GENERAL POOLED FUNDS /
INVESTMENTS CUSTODIAL INTEREST ACCRUED (61,379.45)$ (3,737.61)$ -$ (80,609.38)$ -$ (145,726.44)$
GENERAL POOLED FUNDS /
INVESTMENTS CUSTODIAL GAIN(LOSS) (2,410.50)$ (31,677.79)$ -$ 105,828.22$ -$ 71,739.93$
GENERAL POOLED FUNDS /
INVESTMENTS JPMA GENERAL INTEREST 185,865.09$ 172,582.57$ 121,503.96$ 72,249.36$ 98,950.32$ 651,151.30$
GENERAL POOLED FUNDS /
INVESTMENTS JPMA GENERAL INTEREST ACCRUED -$ -$ -$ -$ -$ -$
GENERAL POOLED FUNDS /
INVESTMENTS JPMA GENERAL GAIN(LOSS) 1,322.69$ -$ -$ -$ -$ 1,322.69$ 1,117,624.76$ 612,269.14$ 799,657.98$ 1,004,856.06$ 539,701.70$ - $ -$ -$ -$ -$ -$ -$ 4,074,109.64$
RSA BANK SWEEP ACCOUNT
INTEREST WF CASH SWEEP ACCOUNT 43,984.18$ 30,666.10$ 8,878.30$ 8,954.33$ 8,644.54$ 101,127.45$ 43,984.18$ 30,666.10$ 8,878.30$ 8,954.33$ 8,644.54$ - $ -$ -$ -$ -$ -$ -$ 101,127.45$
RUA PRE-EXISTING /
INVESTMENTS CASH SWEEP ACCOUNT 18,816.46$ 24,609.09$ 35,145.12$ 35,945.97$ 30,081.25$ 144,597.89$
RUA PRE-EXISTING /
INVESTMENTS LAIF 1,201.43$ -$ -$ 1,277.00$ 2,478.43$
RUA PRE-EXISTING /
INVESTMENTS WFA - INTEREST 58,066.59$ 263.05$ 5,510.66$ 97,859.06$ 9,574.35$ 171,273.71$
RUA PRE-EXISTING /
INVESTMENTS WFA - INTEREST ACCRUED -$ -$ -$ -$ -$ -$
RUA PRE-EXISTING /
INVESTMENTS WFA - GAIN(LOSS) (2,991.50)$ -$ -$ -$ -$ (2,991.50)$ 75,092.98$ 24,872.14$ 40,655.78$ 135,082.03$ 39,655.60$ - $ -$ -$ -$ -$ -$ -$ 315,358.53$ OTHER BANKS WF - SPORT CENTER & POOL 40.51$ 40.54$ 38.09$ 37.47$ 35.13$ 191.74$ OTHER BANKS WF - FLEXIBLE BENEFIT 172.79$ 152.16$ 123.78$ 101.22$ 75.83$ 625.78$ 213.30$ 192.70$ 161.87$ 138.69$ 110.96$ - $ -$ -$ -$ -$ -$ -$ 817.52$ ESCROW ACCOUNTS ENERGY CONSERVATION PROJECT -$ -$ -$ -$ -$ -$ ESCROW ACCOUNTS AYALA @ 210 PARTNERS LLC 26.36$ 26.37$ 25.52$ 26.37$ 25.52$ 130.14$ ESCROW ACCOUNTS LEWIS HILLWOOD 19,728.09$ 17,723.58$ 18,062.72$ 17,781.00$ 16,369.04$ 89,664.43$
ESCROW ACCOUNTS
LEWIS HILLWOOD - UNREALIZED
GAIN(LOSS) 8,832.34$ 13,307.40$ 8,906.76$ (13,413.80)$ (4,488.92)$ 13,143.78 $ ESCROW ACCOUNTS ALDER AVENUE 15,662.42$ 14,041.18$ 14,309.87$ 14,086.68$ 12,968.08$ 71,068.23$
ESCROW ACCOUNTS
ALDER AVENUE - UNREALIZED
GAIN(LOSS) 7,012.11$ 10,542.54$ 7,056.23$ (10,626.84)$ (3,556.26)$ 10,427.78 $ ESCROW ACCOUNTS SUB ACCOUNT A 27,201.80$ 24,432.93$ 24,890.40$ 24,502.19$ 22,556.51$ 123,583.83$
ESCROW ACCOUNTS
SUB ACCOUNT A - UNREALIZED
GAIN(LOSS) 12,178.34$ 18,344.99$ 12,273.50$ (18,848.18)$ (6,185.73)$ 17,762.92 $ 90,641.46$ 98,418.99$ 85,525.00$ 13,507.42$ 37,688.24$ - $ -$ -$ -$ -$ -$ -$ 325,781.11$
CEMETERY ENDOWMENT
(RESTRICTED FUNDS) WFA - INTEREST 95.75$ 95.91$ 90.27$ 2,488.87$ 90.71$ 2,861.51$
CEMETERY ENDOWMENT
(RESTRICTED FUNDS) WFA - INTEREST ACCRUED -$ -$ -$ -$ -$ -$
CEMETERY ENDOWMENT
(RESTRICTED FUNDS) WFA - GAIN(LOSS) -$ -$ -$ -$ -$ -$
CEMETERY ENDOWMENT
(RESTRICTED FUNDS) BANNER BANK 9.11$ 8.68$ 8.40$ 8.68$ 8.41$ 43.28$ 104.86$ 104.59$ 98.67$ 2,497.55$ 99.12$ - $ -$ -$ -$ -$ -$ -$ 2,904.79$
GENERAL POOLED FUNDS /
INVESTMENTS ECONOMIC RESERVE INTEREST 34.31$ 490.55$ 14.35$ 437.63$ 453.95$ 1,430.79$
GENERAL POOLED FUNDS /
INVESTMENTS
ECONOMIC RESERVE INTEREST
ACCRUED -$ -$ -$ -$ -$ - $
GENERAL POOLED FUNDS /
INVESTMENTS ECONOMIC RESERVE GAIN(LOSS) -$ -$ 243,005.26$ 41,028.75$ 46,212.34$ 330,246.35$
34.31$ 490.55$ 243,019.61$ 41,466.38$ 46,666.29$ - $ -$ -$ -$ -$ -$ -$ 331,677.14$
PUBLIC AGENCY RETIREMENT
OPEB (RESTRICTED FUNDS)US BANK 100,143.51$ 266,644.41$ 822,239.55$ 1,771,185.35$ 40,167.78$ 3,000,380.60$
PUBLIC AGENCY RETIREMENT
OPEB (RESTRICTED FUNDS)US BANK UNREALIZED 567,136.27$ 253,207.38$ (414,290.06)$ (2,353,214.73)$ 824,966.53$ (1,122,194.61)$ 667,279.78$ 519,851.79$ 407,949.49$ (582,029.38)$ 865,134.31$ - $ -$ -$ -$ -$ -$ -$ 1,878,185.99$
CASH W/FISCAL AGENTS -
(RESTRICTED BOND ISSUES)2008 SERIES B 13,169.62$ 13,698.87$ 16,386.05$ 13,378.60$ 12,762.44$ 69,395.58$
CASH W/FISCAL AGENTS -
(RESTRICTED BOND ISSUES)2008 SERIES C 8,269.00$ 8,601.30$ 10,787.83$ 8,484.61$ 8,015.01$ 44,157.75$
CASH W/FISCAL AGENTS -
(RESTRICTED BOND ISSUES)2014 SERIES A 1.47$ 1.53$ 2,715.66$ 462.49$ 12.89$ 3,194.04$
CASH W/FISCAL AGENTS -
(RESTRICTED BOND ISSUES)2015 SERIES A & B 5.68$ 5.91$ 3,121.55$ 531.20$ 14.82$ 3,679.16$
CASH W/FISCAL AGENTS -
(RESTRICTED BOND ISSUES)2015 SERIES C 1.12$ 1.16$ 991.57$ 168.81$ 4.71$ 1,167.37$
CASH W/FISCAL AGENTS -
(RESTRICTED BOND ISSUES)2018 REFUNDING 2008 SERIES A 5.53$ 5.75$ 1,924.61$ 327.31$ 9.15$ 2,272.35$
CASH W/FISCAL AGENTS -
(RESTRICTED BOND ISSUES)2016 ELM PARK 1,843.99$ 1,910.67$ 2,318.26$ 1,860.05$ 1,752.38$ 9,685.35$
CASH W/FISCAL AGENTS -
(RESTRICTED BOND ISSUES)2019 CFD 2019-2 FOOTHILL & SPRUCE1,592.35$ 1,654.29$ 1,866.32$ 1,587.19$ 1,518.47$ 8,218.62$
CASH W/FISCAL AGENTS -
(RESTRICTED BOND ISSUES)
CFD 2020-1 EL RANCHO VERDE
SERIES 2023 30,786.02$ 31,884.79$ 32,550.68$ 30,149.74$ 18,848.78$ 144,220.01 $ 55,674.78$ 57,764.27$ 72,662.53$ 56,950.00$ 42,938.65$ - $ -$ -$ -$ -$ -$ -$ 285,990.23$
CASH W/FISCAL AGENTS - RUA
(CONCESSION AGREEMENT)TRUST 25,512.78$ 29,338.44$ 31,926.98$ 28,802.31$ 28,260.19$ 143,840.70$
CASH W/FISCAL AGENTS - RUA
(CONCESSION AGREEMENT)WASTEWATER 59,904.49$ 77,119.69$ 73,465.98$ 122,083.38$ 180,879.27$ 513,452.81$
CASH W/FISCAL AGENTS - RUA
(CONCESSION AGREEMENT)WATER 51,178.57$ 60,025.14$ 57,935.31$ 70,570.11$ 81,670.13$ 321,379.26$ 136,595.84$ 166,483.27$ 163,328.27$ 221,455.80$ 290,809.59$ - $ -$ -$ -$ -$ -$ -$ 978,672.77$ TOTAL INTEREST 2,187,246.25$ 1,511,113.54$ 1,821,937.50$ 902,878.88$ 1,871,449.00$ -$ -$ -$ -$ -$ -$ -$ 8,294,625.17$ LESS: UNREALIZED 567,136.27$ 253,207.38$ (414,290.06)$ (2,353,214.73)$ 824,966.53$ -$ -$ -$ -$ -$ -$ -$ (1,122,194.61)$ NET INTEREST 1,620,109.98$ 1,257,906.16$ 2,236,227.56$ 3,256,093.61$ 1,046,482.47$ -$ -$ -$ -$ -$ -$ -$ 9,416,819.78$ 9,416,819.78$
-$ VAR