ATTACHMENT 1
CASH AND INVESTMENT REPORT
CITY OF RIVERSIDE
Quarterly Investment Report
September 30, 2023
AMORTIZED MARKET
COST VALUE
POOLED INVESTMENT PORTFOLIO
Deposit Accounts 65,762,119.09$ 65,762,119.09$
Joint Powers Authority Pool 63,484,252.51 63,484,252.51 Medium Term Notes 208,068,887.03 196,959,427.52 U.S. Govt Agency Mortgage Backed Securities 29,869,788.08 28,252,810.27 Asset Backed Securities 81,789,522.61 80,536,374.75 Supranational Securities 55,884,851.95 52,983,814.19 U.S. Govt Agency Securities 112,263,680.60 106,200,615.45 U.S. Govt Treasury Securities 306,197,095.83 295,598,820.82 TOTAL POOLED INVESTMENT PORTFOLIO 923,320,197.70 889,778,234.60
INVESTMENTS HELD BY FISCAL AGENT -
SECTION 115 PENSION TRUST FUND 34,167,295.92 33,584,606.79 OTHER INVESTMENTS HELD BY FISCAL AGENT 218,339,836.32 216,022,777.02 OTHER MISCELLANEOUS CASH 4,928,918.29 4,928,918.29 TOTAL CASH & INVESTMENTS 1,180,756,248.23$ 1,144,314,536.70$ Verified by:
Nancy Garcia, Controller
Approved by:
Edward P. Enriquez, Assistant City Manager/CFO
It has been verified that this investment portfolio is in conformity, exclusive of items identified, with the City of Riverside's investment policy which was approved by City Council on 3/11/2020. The Treasurer's cash management program and cash flow analysis indicates that sufficient liquidity is on hand to meet estimated future expenditures for a period of six months. The weighted average maturity of the City's investment portfolio is 2.06 years. Market prices of securities are obtained from Interactive Data Corporation. Weighted average yield on cost for the City's investment portfolio is 2.69%. The cash held and invested with fiscal agents is subject to the investment provisions of the related trust indentures associated with the bond transaction which generated the cash. 33%
22%
12%
9%
8%
7%
6% 3%
COMPOSITION OF POOLED
PORTFOLIO
U.S. Govt Treasury Securities (33.22%)
Medium Term Notes (22.14%)
U.S. Govt Agency Securities (11.94%)
Asset Backed Securities (9.05%)
Deposit Accounts (7.39%)
Joint Powers Authority Pool (7.13%)
Supranational Securities (5.95%)
U.S. Govt Agency Mortgate Backed Securities (3.18%)
$306,588
$251,852
$122,451
$104,930
$53,227 $50,730
COMPOSITION OF POOLED
PORTFOLIO BY FUND
Electric Fund (34.46%) All Other Funds (28.31%)
General Fund (13.76%) Sewer Fund (11.79%)
Water Fund (5.98%) Measure Z Fund (5.70%)
DESCRIPTION COUPON MATURITY *INVEST PURCH COST **MARKET
OF SECURITY RATE DATE RATING DATE VALUE VALUE
DEPOSIT ACCOUNTS
Bank of America Checking and Reserve N/A Varies NR Varies 60,435,782.42 60,435,782.42 Federated Investors Federated Treasury N/A Varies AAA Varies 5,326,336.67 5,326,336.67 SUBTOTAL DEPOSIT ACCOUNTS 65,762,119.09 65,762,119.09
JOINT POWERS AUTHORITY POOL
California Asset Management Program (CAMP) N/A Varies AAA Varies 63,484,252.51 63,484,252.51 SUBTOTAL JOINT POWERS AUTHORITY POOL 63,484,252.51 63,484,252.51
MEDIUM TERM NOTES
Amazon.com Inc 0.450 05/12/24 AA 05/10/21 3,649,663.70 3,548,093.08 John Deere Capital Corp 0.450 06/07/24 A 06/07/21 2,077,400.00 2,014,126.40 Salesforce.com Inc 0.625 07/15/24 A+ 06/29/21 1,064,456.85 1,024,990.56 Royal Bank of Canada 2.250 11/01/24 A 02/06/20 3,037,950.00 2,912,010.00 John Deere Capital Corp 2.050 01/09/25 A 02/06/20 3,024,810.00 2,886,454.33 American Honda Finance 1.500 01/13/25 A- Various 4,483,050.30 4,283,248.50 Toyota Motor Credit Corp 1.800 02/13/25 A+ 05/05/21 2,072,840.00 1,905,408.00 JP Morgan Chase & Co 3.220 03/01/25 A- 08/18/20 3,238,920.00 2,968,696.00 Bank of America Corp 3.458 03/15/25 A- 04/23/20 5,263,900.00 4,940,929.44 Chubb INA Holdings Inc 3.150 03/15/25 A Various 6,518,943.13 5,742,748.17 Royal Bank of Canada 3.375 04/14/25 A 04/14/22 1,497,420.00 1,470,667.88 Bank of Montreal 1.850 05/01/25 A- 08/12/21 5,162,100.00 4,731,036.67 Caterpillar Financial Service 3.400 05/13/25 A 05/10/22 2,736,520.20 2,684,929.65 Qualcomm Inc 3.450 05/20/25 A Various 5,245,703.20 4,901,830.83 Morgan Stanley 0.790 05/30/25 A- Various 7,461,656.65 7,190,260.23 Honeywell Intl 1.350 06/01/25 A 06/23/20 5,119,000.00 4,702,115.00 Royal Bank of Canada 1.150 06/10/25 A Various 5,044,880.00 4,641,404.17 Northwestern Mutual Glbl 4.000 07/01/25 AA+ 06/27/22 6,402,822.30 6,282,837.44 American Honda Finance 1.200 07/08/25 A- 06/22/21 2,017,540.00 1,858,121.33 Toronto Dominion Bank 0.750 09/11/25 A 09/15/20 4,986,850.00 4,552,658.33 National Rural Utilities 3.250 11/01/25 A- 04/14/22 2,994,000.00 2,902,724.00 Simon Property Group 3.300 01/15/26 A- 08/11/21 4,750,593.75 4,182,752.30 Goldman Sachs Group Inc 0.855 02/12/26 BBB+ 06/18/21 4,334,706.25 4,059,491.41 Bank of America Corp 2.015 02/13/26 A- 03/04/21 2,066,760.00 1,887,239.33 JP Morgan Chase & Co 2.005 03/13/26 A- 03/12/21 3,086,490.00 2,828,023.50 Citigroup Inc 3.106 04/08/26 BBB+ Various 6,788,825.00 6,178,911.73 Mass Mutual Global funding 4.500 04/10/26 AA+ 04/04/23 1,998,620.00 1,994,966.00 JP Morgan Chase & Co 2.083 04/22/26 A- 06/23/21 3,105,570.00 2,843,414.75 Guardian Life Glob Fun 1.250 05/13/26 AA+ 02/09/22 2,307,168.00 2,139,966.40 United Health Group Inc 1.150 05/15/26 A+ Various 2,852,118.20 2,711,719.34 Toyota Motor Credit Corp 1.125 06/18/26 A+ Various 4,989,707.50 4,480,993.75 Bank of America Corp 1.319 06/19/26 A- 06/18/21 2,004,120.00 1,841,622.33 Met Tower Global Funding 1.250 09/14/26 AA- 09/07/21 2,927,304.40 2,583,203.08 Bank of Montreal 1.250 09/15/26 A- Various 2,495,539.50 2,198,868.89 Wal-Mart Stores 1.050 09/17/26 AA 09/08/21 1,332,476.85 1,190,875.19 Morgan Stanley 6.138 10/16/26 A- 10/19/22 1,498,185.00 1,543,623.75 Metlife 1.875 01/11/27 AA- 01/03/22 4,240,160.70 3,780,480.97 Toronto-Dominion Bank 1.950 01/12/27 A 01/25/22 992,295.35 894,972.17 Charles Schwab Corp 2.450 03/03/27 A- 03/01/22 1,668,196.40 1,490,723.09 Goldman Sachs Group Inc 1.431 03/09/27 BBB+ Various 2,914,727.50 2,896,281.38
CITY OF RIVERSIDE
Pooled Investment Portfolio Holdings
September 30, 2023
DESCRIPTION COUPON MATURITY *INVEST PURCH COST **MARKET
OF SECURITY RATE DATE RATING DATE VALUE VALUE
CITY OF RIVERSIDE
Pooled Investment Portfolio Holdings
September 30, 2023
Berkshire Hathaway 2.300 03/15/27 AA 03/07/22 4,924,064.25 4,522,904.39 Toyota Motor Credit Corp 3.050 03/22/27 A+ 06/14/23 1,881,520.00 1,855,831.00 Amazon.com Inc 3.300 04/13/27 AA 04/25/22 2,994,810.00 2,868,903.00 Virginia Electric Power Corp 3.750 05/15/27 BBB+ Various 5,509,511.95 5,268,805.67 Qualcomm Inc 3.250 05/20/27 A Various 4,754,650.00 4,723,256.94 Citigroup Inc 1.462 06/09/27 BBB+ 06/21/22 1,753,880.00 1,776,964.89 Merck & Co 1.700 06/10/27 A+ 06/23/22 3,966,221.40 3,902,880.76 Caterpillar Financial Service 3.600 08/12/27 A Various 3,213,062.50 3,082,170.00 Wal-Mart Stores 3.950 09/09/27 AA Various 2,495,938.60 2,418,414.72 Amazon.com Inc 4.550 12/01/27 AA Various 3,027,460.00 2,983,427.00 Toronto-Dominion Bank 5.156 01/10/28 A Various 3,980,080.00 3,950,368.00 John Deere Capital Corp 4.750 01/20/28 A Various 7,069,150.00 6,938,533.39 Bank of America Corp 3.824 01/20/28 A- Various 2,356,757.55 2,340,454.44 United Health Group Inc 5.250 02/15/28 A+ 02/21/23 4,061,040.00 4,033,629.33 Comcast Corp 3.550 05/01/28 A- Various 4,785,920.00 4,713,523.33 JP Morgan Chase & Co 3.540 05/01/28 A- 06/12/23 1,872,100.00 1,868,490.00 Apple Inc 4.000 05/10/28 AA+ 05/08/23 1,571,960.25 1,537,005.75 Merck & Co 4.050 05/17/28 A+ Various 3,997,647.20 3,909,348.00 Bank of NY Mellon Corp 3.992 06/13/28 A 07/14/23 1,922,520.00 1,909,450.00 American Honda Finance 5.125 07/07/28 A- 09/22/23 998,142.60 1,006,300.71 Royal Bank of Canada 5.200 08/01/28 A 09/07/23 1,478,460.00 1,475,346.83 SUBTOTAL MEDIUM TERM NOTES 208,068,887.03 196,959,427.52 U.S. GOVERNMENT AGENCY MORTGAGE BACKED SECURITIES
FHLMC - K041 A2 3.171 10/25/24 AAA 07/01/21 5,357,486.33 4,863,900.63 FHLMC - K047 A2 3.329 05/25/25 NR 05/20/22 5,028,906.25 4,843,050.83 FHLMC - K049 A2 3.010 07/25/25 NR 06/23/21 1,789,016.21 1,590,020.83 FHLMC - K059 A2 3.120 09/25/26 AAA 02/18/22 3,128,437.50 2,833,944.00 FHLMC - K073 A2 3.350 01/25/28 NR 05/24/23 5,156,267.97 4,993,775.98 FHLMC - K074 A2 3.600 01/25/28 NR 07/25/23 2,386,035.15 2,350,010.00 FHLMC - K077 A2 3.850 05/25/28 NR 05/24/23 7,023,638.67 6,778,108.00 SUBTOTAL U.S. GOVERNMENT AGENCY MORTGAGE BACKED SECURITIES 29,869,788.08 28,252,810.27
ASSET BACKED SECURITIES
Toyota Auto Receivables Trust 0.440 10/15/24 AAA 07/21/20 33,296.67 33,234.16 Honda Auto Receivables Trust 0.370 10/18/24 AAA 09/22/20 252,483.26 250,440.50 Toyota Lease Owner Trust 0.420 10/21/24 NR 07/27/21 701,683.45 697,788.92 GM Financial Auto Lease Trust 0.390 10/21/24 AAA 04/18/22 515,796.76 527,899.72 John Deere Owner Trust 0.510 11/15/24 NR 07/14/20 22,763.63 22,722.38 Mercedes-Benz Auto Lease Trust 0.400 11/15/24 AAA 06/22/21 1,014,686.90 1,006,294.07 BMW Vehicle Lease Trust 0.330 12/26/24 NR 09/08/21 308,338.32 306,636.48 Hyundai Auto Lease Trust 1.160 01/15/25 AAA 01/11/22 1,570,044.88 1,553,619.75 Toyota Lease Owner Trust 1.960 02/20/25 AAA 02/23/22 4,194,870.22 4,144,193.62 GM Financial Auto Lease Trust 1.900 03/20/25 NR 02/15/22 2,967,730.09 2,931,583.30 BMW Vehicle Lease Trust 1.100 03/25/25 AAA 01/11/22 927,299.30 916,724.50 Honda Auto Receivables Trust 0.270 04/21/25 NR 02/17/21 314,495.97 308,926.58 Toyota Auto Receivables Owners 0.260 05/15/25 NR 02/02/21 1,159,456.41 1,139,792.05 GM Financial Auto Lease Trust 3.420 06/20/25 AAA 05/03/22 2,399,749.68 2,373,528.00 John Deere Owner Trust 0.360 09/15/25 NR 03/02/21 702,037.85 685,642.24 Hyundai Auto Receivables Trust 0.380 09/15/25 AAA 04/20/21 640,740.32 627,913.98 BMW Vehicle Lease Trust 5.160 11/25/25 AAA 02/07/23 894,978.70 888,205.16 DESCRIPTION COUPON MATURITY *INVEST PURCH COST **MARKET
OF SECURITY RATE DATE RATING DATE VALUE VALUE
CITY OF RIVERSIDE
Pooled Investment Portfolio Holdings
September 30, 2023
Hyundai Auto Receivables Trust 0.380 01/15/26 AAA 07/20/21 2,905,335.88 2,824,519.46 Honda Auto Receivables Trust 0.880 01/21/26 NR 11/16/21 1,499,677.50 1,441,880.12 John Deere Owner Trust 0.520 03/16/26 NR 07/13/21 1,627,835.18 1,572,780.64 Hyundai Auto Receivables Trust 0.740 05/15/26 AAA 11/09/21 1,070,845.07 1,035,457.63 Honda Auto Receivables Trust 1.880 05/15/26 AAA 02/15/22 2,814,576.62 2,718,182.48 BMW Vehicle Owner Trust 3.210 08/25/26 AAA 05/10/22 1,999,896.00 1,952,172.00 GM Financial Securitized Term 0.680 09/16/26 AAA 10/13/21 1,151,080.95 1,104,682.95 John Deere Owner Trust 2.320 09/16/26 NR 03/10/22 1,724,618.43 1,671,839.15 Hyundai Auto Receivables Trust 2.220 10/15/26 AAA 03/09/22 3,079,881.42 2,983,447.10 GM Financial Auto Receivables 1.260 11/16/26 AAA 01/11/22 1,129,484.18 1,092,114.10 GM Financial Securitized ART 3.100 02/16/27 AAA 04/05/22 1,674,649.93 1,630,377.44 John Deere Owner Trust 3.740 02/16/27 NR 07/12/22 2,689,743.11 2,622,992.70 Honda Auto Receivables Owner 5.040 04/21/27 NR 02/16/23 1,849,656.27 1,833,823.60 American Express Credit Trust 3.390 05/17/27 AAA 05/17/22 5,188,851.97 5,016,527.71 John Deere Owner Trust 5.090 06/15/27 NR 10/12/22 3,454,731.89 3,425,909.67 Verizon Master Trust 3.720 07/20/27 AAA 08/02/22 2,349,896.60 2,337,722.82 American Express Credit Trust 3.750 08/16/27 NR 10/28/22 3,868,125.00 3,878,066.00 Mercedes-Benz Auto Receivables 5.210 08/16/27 AAA 11/15/22 6,158,781.55 6,133,521.58 John Deere Owner Trust 5.010 11/15/27 NR 02/22/23 2,814,487.11 2,788,397.62 GM Auto Receivable Trust 4.470 02/16/28 AAA 04/04/23 1,549,957.38 1,518,224.25 BMW Vehicle Owner Trust 5.470 02/25/28 AAA 07/11/23 1,499,734.20 1,497,422.50 John Deere Owner Trust 5.180 03/15/28 NR 06/21/23 2,649,557.98 2,632,860.39 Chase Issuance Trust 5.160 09/15/28 AAA 09/07/23 8,417,665.98 8,408,307.43 SUBTOTAL ASSET BACKED SECURITIES 81,789,522.61 80,536,374.75
SUPRANATIONAL SECURITIES
Inter-American Dev Bank 0.500 09/23/24 AAA 09/15/21 8,403,776.60 8,002,057.06 Intl. Bank Recon & Development 0.625 04/22/25 AAA 04/15/20 4,278,378.35 4,003,349.82 Inter-American Dev Bank 0.625 07/15/25 AAA 01/13/21 5,071,967.50 4,664,086.29 Intl. Bank Recon & Development 0.500 10/28/25 AAA Various 9,994,372.85 9,121,800.02 Inter-American Dev Bank 0.875 04/20/26 AAA 04/13/21 9,342,016.70 8,505,064.23 Intl. Bank Recon & Development 3.500 07/12/28 AAA Various 14,429,190.65 14,326,463.34 International Finance Corp 4.500 07/13/28 AAA 07/06/23 4,365,149.30 4,360,993.43 SUBTOTAL SUPRANATIONAL SECURITIES 55,884,851.95 52,983,814.19 U.S. GOVERNMENT AGENCY SECURITIES
FHLB 2.750 12/13/24 AA+ 02/06/20 5,281,300.00 4,885,745.00 FNMA 1.625 01/07/25 AA+ 03/04/20 8,281,440.00 7,664,933.33 FHLMC 1.500 02/12/25 AA+ 02/13/20 6,599,914.15 6,291,650.00 FHLB 2.375 03/14/25 AA+ 03/19/20 6,346,620.00 5,760,315.17 FNMA 0.625 04/22/25 AA+ 04/22/20 5,199,267.40 4,863,037.01 FHLB 0.500 06/13/25 AA+ 06/29/20 5,007,400.00 4,627,210.00 FNMA 0.500 06/17/25 AA+ 06/17/20 6,506,503.60 6,037,796.74 FHLMC 0.375 07/21/25 AA+ 07/21/20 4,606,942.60 4,258,822.93 FNMA 0.375 08/25/25 AA+ Various 7,962,282.50 7,320,488.01 FHLMC 0.375 09/23/25 AA+ Various 7,970,197.55 7,294,754.67 FNMA 0.500 11/07/25 AA+ 11/09/20 6,063,215.70 5,545,741.22 FHLB 4.500 12/12/25 AA+ 02/03/23 7,592,925.00 7,506,420.00 FFCB 4.375 06/23/26 AA+ 06/20/23 7,745,892.50 7,740,589.35 FHLB 4.500 03/10/28 AA+ Various 10,246,000.00 9,972,430.00 Tennessee Valley Authority 3.875 03/15/28 AA+ Various 10,325,114.60 9,958,773.58 DESCRIPTION COUPON MATURITY *INVEST PURCH COST **MARKET
OF SECURITY RATE DATE RATING DATE VALUE VALUE
CITY OF RIVERSIDE
Pooled Investment Portfolio Holdings
September 30, 2023
FHLB 4.375 06/09/28 AA+ 07/26/23 6,528,665.00 6,471,908.44 SUBTOTAL U.S. GOVERNMENT AGENCY SECURITIES 112,263,680.60 106,200,615.45 U.S. GOVERNMENT TREASURY SECURITIES
US Treasury 2.000 04/30/24 AA+ Various 17,578,257.82 17,203,076.64 US Treasury 0.250 06/15/24 AA+ 06/18/21 4,965,429.69 4,824,198.52 US Treasury 1.750 06/30/24 AA+ 09/09/19 9,358,759.77 9,037,976.63 US Treasury 1.500 02/15/25 AA+ Various 15,947,968.76 15,705,323.04 US Treasury 1.125 02/28/25 AA+ 03/24/20 6,177,656.25 5,669,184.63 US Treasury 1.750 03/15/25 AA+ 05/04/22 4,827,539.06 4,758,536.15 US Treasury 2.750 05/15/25 AA+ Various 9,795,000.00 9,723,792.29 US Treasury 3.125 08/15/25 AA+ 09/27/22 4,826,171.88 4,843,590.84 US Treasury 0.250 09/30/25 AA+ 10/16/20 6,975,937.50 6,370,047.81 US Treasury 4.250 10/15/25 AA+ 10/28/22 3,983,750.00 4,015,841.27 US Treasury 0.375 12/31/25 AA+ 12/29/20 2,249,824.22 2,036,184.05 US Treasury 0.375 01/31/26 AA+ Various 8,625,488.28 7,882,234.45 US Treasury 4.000 02/15/26 AA+ 02/16/23 7,425,585.94 7,379,817.72 US Treasury 0.750 03/31/26 AA+ 03/30/21 3,969,843.75 3,617,269.97 US Treasury 0.750 05/31/26 AA+ Various 9,942,773.44 9,006,064.92 US Treasury 0.750 08/31/26 AA+ Various 5,170,878.90 4,678,520.36 US Treasury 1.125 10/31/26 AA+ Various 12,919,453.14 11,709,410.44 US Treasury 1.500 01/31/27 AA+ Various 15,585,117.20 14,898,149.87 US Treasury 2.750 04/30/27 AA+ Various 18,449,570.32 17,985,877.89 US Treasury 3.250 06/30/27 AA+ Various 20,141,015.63 19,166,606.30 US Treasury 4.125 09/30/27 AA+ Various 20,091,445.31 19,585,854.09 US Treasury 3.875 12/31/27 AA+ Various 20,147,968.81 19,579,455.98 US Treasury 3.625 03/31/28 AA+ Various 20,028,125.00 19,175,420.88 US Treasury 3.625 05/31/28 AA+ Various 26,998,242.19 26,692,060.37 US Treasury 4.125 07/31/28 AA+ Various 30,015,292.97 30,054,325.71 SUBTOTAL U.S. GOVERNMENT TREASURY SECURITIES 306,197,095.83 295,598,820.82
TOTAL POOLED CASH & INVESTMENTS 923,320,197.70 889,778,234.60 *The City uses S&P ratings
** Includes accrued interest
DESCRIPTION COST MARKET
OF SECURITY VALUE VALUE
CASH AND EQUIVALENTS
*Cash 74,982.44 74,982.44
First American Government Obligation Fund CL "Z" 1,238,546.32 1,238,546.32 SUBTOTAL CASH AND EQUIVALENTS 1,313,528.76 1,313,528.76
MUTUAL FUNDS - EQUITY
Ishares Core - S P500 Etf 4,115,917.00 4,604,777.89
Ishares S P - 500 Growth Etf 1,616,334.53 1,812,172.12
Ishares S P - 500 Value Etf 1,930,488.83 2,079,916.80
Ishares - Russell Mid Cap Etf 1,785,396.84 1,788,381.25 Ishares - Russell 2000 Value Etf 1,159,116.47 1,110,425.60 Ishares - Russell 2000 Growth Etf 1,148,484.58 1,107,301.00 Ishares Core - Msci Eafe Etf 2,025,997.29 2,026,831.95
Vanguard Ftse - Emerging Markets Etf 1,185,955.69 1,111,603.50 Vanguard Real - Estate Etf 594,216.85 521,751.36
SUBTOTAL MUTUAL FUNDS - EQUITY 15,561,908.08 16,163,161.47
MUTUAL FUNDS - FIXED INCOME
Ishares Core - U.S. Aggregate Bond Etf 15,159,333.90 14,072,051.56 Ishares Mbs - Etf 1,066,292.79 1,016,404.80
Ishares US - Treasury Bond Etf 1,066,232.39 1,019,460.20 SUBTOTAL MUTUAL FUNDS - FIXED INCOME 17,291,859.08 16,107,916.56 TOTAL ASSETS 34,167,295.92 33,584,606.79
* Includes accrued income
CITY OF RIVERSIDE
Investments held by Fiscal Agent
September 30, 2023
Section 115 Pension Trust Fund
DESCRIPTION COUPON MATURITY *INVEST PURCH COST **MARKET
OF SECURITY RATE DATE RATING DATE VALUE VALUE
CASH & MONEY MARKET ACCOUNTS
Cash - Custodial Cash Account US Bank N/A Varies NR Varies 39,177.38 39,177.38 Cash - Bank of America Equipment Lease N/A Varies NR Varies 11,271,564.00 11,271,564.00 US Bank Commercial Paper Sweep N/A Varies NR Varies 330,379.03 330,379.03 US Bank Gcts0170 N/A Varies NR Varies 47,314,825.76 47,314,825.76 US Bank Gcts0185 N/A Varies NR Varies 26,353,133.59 26,353,133.59 First American Government Obligation CL "Y" N/A Varies AAA Varies 74,789.24 74,789.24 First American Government Obligation CL "Z" N/A Varies AAA Varies 4,700,376.37 4,700,376.37 First American Treasury MMF Class "Z" N/A Varies AAA 03/31/23 58,206,718.75 58,206,718.75 SUBTOTAL CASH & MONEY MARKET ACCOUNTS 148,290,964.12 148,290,964.12 LOCAL AGENCY INVESTMENT FUND (LAIF) N/A Varies NR Varies 1,277,830.56 1,288,546.54
MEDIUM TERM NOTES
Charles Schwab Corp 0.750 03/18/24 A- Various 601,166.80 585,808.72 Amazon.com Inc 0.450 05/12/24 AA 05/10/21 394,423.30 383,446.46 John Deere Capital Corp 0.450 06/07/24 A 06/07/21 369,537.50 358,282.12 Salesforce.com Inc 0.625 07/15/24 A+ 06/29/21 94,951.55 91,431.09 American Honda Finance 1.500 01/13/25 A- Various 695,744.40 666,283.10 Toyota Motor Credit Corp 1.800 02/13/25 A+ 05/05/21 777,315.00 714,528.00 Chubb INA Holdings Inc 3.150 03/15/25 A 01/26/21 659,406.00 579,198.00 Caterpillar Financial Service 3.400 05/13/25 A 05/10/22 209,733.30 205,779.28 Morgan Stanley 0.790 05/30/25 A- 05/26/21 640,340.50 616,445.61 Honeywell Intl 1.350 06/01/25 A 06/10/21 717,066.00 658,296.10 Eli Lilly & Co 2.750 06/01/25 A+ 06/10/21 699,166.00 628,857.24 PNC Bank 3.250 06/01/25 A 06/10/21 710,365.50 628,103.02 Royal Bank of Canada 1.150 06/10/25 A 02/22/21 607,344.00 556,968.50 Toronto Dominion Bank 0.750 09/11/25 A 02/10/21 650,292.50 591,845.58 Simon Property Group 3.300 01/15/26 A- 08/11/21 678,656.25 597,536.05 Goldman Sachs Group Inc 0.855 02/12/26 BBB+ 06/18/21 619,243.75 579,927.35 Bank of America Corp 2. 015 02/13/26 A- 03/04/21 620,028.00 566,171.80 JP Morgan Chase & Co 2.005 03/13/26 A- 03/12/21 617,298.00 565,604.70 Citigroup Inc 3.106 04/08/26 BBB+ 06/18/21 669,075.00 605,775.67 United Health Group Inc 1.
150 05/15/26 A+ Various 130,420.30 117,507.84 Wal-Mart Stores 1.050 09/17/26 AA 09/08/21 119,773.20 107,044.97 Target Corp 1.950 01/15/27 A 01/19/22 264,549.50 240,422.75 Virginia Electric Power Corp 3.750 05/15/27 BBB+ 05/16/22 119,625.60 114,955.76 Merck & Co 4.050 05/17/28 A+ 05/15/23 600,024.00 586,402.21 SUBTOTAL MEDIUM TERM NOTES 12,265,545.95 11,346,621.92
ASSET BACKED SECURITIES
Mercedes-Benz Auto Lease Trust 0.400 11/15/24 AAA 06/22/21 94,025.03 93,247.33 BMW Vehicle Lease Trust 0.330 12/26/24 NR 09/08/21 28,461.97 28,304.88 GM Financial Auto Lease Trust 1.900 03/20/25 NR 02/15/22 255,554.54 252,441.90 BMW Vehicle Lease Trust 1.100 03/25/25 AAA 01/11/22 80,869.13 79,946.91 Honda Auto Receivables Trust 0.270 04/21/25 NR 02/17/21 34,789.38 34,173.29 Toyota Auto Receivables Owners 0.260 05/15/25 NR 02/02/21 130,071.69 127,865.70 Hyundai Auto Receivables Trust 0.380 09/15/25 AAA 04/20/21 71,676.06 70,241.24 John Deere Owner Trust 0.360 09/15/25 NR 03/02/21 77,764.17 75,948.06 Hyundai Auto Receivables Trust 0.380 01/15/26 AAA 07/20/21 268,042.66 260,586.64
CITY OF RIVERSIDE
Investments Held by Fiscal Agent
September 30, 2023
DESCRIPTION COUPON MATURITY *INVEST PURCH COST **MARKET
OF SECURITY RATE DATE RATING DATE VALUE VALUE
CITY OF RIVERSIDE
Investments Held by Fiscal Agent
September 30, 2023
Honda Auto Receivables Trust 0.880 01/21/26 NR 11/16/21 132,828.59 127,709.38 John Deere Owner Trust 0.520 03/16/26 NR 07/13/21 151,340.68 146,222.23 Honda Auto Receivables Trust 1.880 05/15/26 AAA 02/15/22 244,963.15 236,573.61 Hyundai Auto Receivables Trust 0.740 05/15/26 AAA 11/09/21 94,234.37 91,120.27 BMW Vehicle Owner Trust 3.210 08/25/26 AAA 05/10/22 149,992.20 146,412.90 GM Financial Securitized Term 0.680 09/16/26 AAA 10/13/21 99,156.79 95,159.97 John Deere Owner Trust 2.320 09/16/26 NR 03/10/22 179,960.19 174,452.79 GM Financial Auto Receivables 1.260 11/16/26 AAA 01/11/22 99,077.56 95,799.48 GM Financial Securitized ART 3.100 02/16/27 AAA 04/05/22 139,970.75 136,270.36 John Deere Owner Trust 3.740 02/16/27 NR 07/12/22 184,982.33 180,391.69 Honda Auto Receivables Owner 5.040 04/21/27 NR 02/16/23 139,973.99 138,775.84 John Deere Owner Trust 5.090 06/15/27 NR 10/12/22 239,981.38 237,979.26 Verizon Master Trust 3.720 07/20/27 AAA 08/02/22 159,992.96 159,164.12 Mercedes-Benz Auto Receivables 5.210 08/16/27 AAA 11/15/22 414,917.91 413,216.14 SUBTOTAL ASSET BACKED SECURITIES 3,472,627.48 3,402,003.99
SUPRANATIONAL SECURITIES
Inter-American Dev Bank 0.500 09/23/24 AAA 09/15/21 764,433.90 727,892.23 International Finance Corp 1.375 10/16/24 AAA 07/12/21 1,026,900.00 963,946.08 Intl. Bank Recon & Development 0.500 10/28/25 AAA 01/26/21 1,000,640.00 912,180.00 Inter-American Dev Bank 0.875 04/20/26 AAA 04/13/21 1,040,213.90 947,021.01 SUBTOTAL SUPRANATIONAL SECURITIES 3,832,187.80 3,551,039.32 U.S. GOVERNMENT AGENCY SECURITIES
FHLB 4.500 10/03/24 AA+ 10/27/22 799,128.00 809,020.80 FFCB 4.500 11/18/24 AA+ 11/15/22 809,141.40 815,265.00 FFCB 1.750 02/14/25 AA+ 02/10/22 603,384.65 577,258.17 FHLB 4.500 12/12/25 AA+ 01/30/23 1,264,562.50 1,251,070.00 SUBTOTAL U.S. GOVERNMENT AGENCY SECURITIES 3,476,216.55 3,452,613.97 U.S. GOVERNMENT TREASURY SECURITIES
US Treasury 0.500 11/30/23 AA+ 01/30/23 1,448,203.13 1,490,629.99 US Treasury 0.125 02/15/24 AA+ 02/23/21 822,679.69 809,147.34 US Treasury 0.250 05/15/24 AA+ 05/18/21 1,870,458.99 1,816,931.80 US Treasury 3.250 08/31/24 AA+ 09/30/22 1,703,341.53 1,698,425.04 US Treasury 0.375 09/15/24 AA+ 09/29/21 1,990,312.50 1,906,189.68 US Treasury 3.000 07/15/25 AA+ 09/30/22 247,159.51 242,507.67 US Treasury 3.125 08/15/25 AA+ 08/25/22 1,241,503.90 1,210,897.71 US Treasury 4.250 10/15/25 AA+ Various 2,523,849.62 2,534,999.81 US Treasury 0.375 01/31/26 AA+ Various 1,724,482.43 1,576,446.90 US Treasury 4.000 02/15/26 AA+ 09/06/23 7,404,702.04 7,404,417.11 US Treasury 0.750 03/31/26 AA+ 05/18/21 2,194,070.32 1,989,498.48 US Treasury 0.750 05/31/26 AA+ 06/23/21 3,232,099.61 2,926,971.10 US Treasury 4.375 08/15/26 AA+ 09/06/23 200,867.63 200,619.46 US Treasury 1.500 01/31/27 AA+ 03/30/22 765,312.50 722,334.54 US Treasury 3.250 06/30/27 AA+ Various 1,486,835.94 1,437,495.48 US Treasury 3.125 08/31/27 AA+ 09/30/22 670,665.96 653,050.78 US Treasury 4. 125 09/30/27 AA+ Various 2,533,158.21 2,472,714.07 US Treasury 3.875 12/31/27 AA+ 01/30/23 1,007,656.26 978,972.80 DESCRIPTION COUPON MATURITY *INVEST PURCH COST **MARKET
OF SECURITY RATE DATE RATING DATE VALUE VALUE
CITY OF RIVERSIDE
Investments Held by Fiscal Agent
September 30, 2023
US Treasury 3.625 03/31/28 AA+ 05/25/23 987,265.62 958,771.04 US Treasury 4.125 07/31/28 AA+ 08/30/23 719,392.58 714,406.10 US Treasury 3.125 08/31/29 AA+ 09/30/22 189,730.51 184,844.88 SUBTOTAL U.S. GOVERNMENT TREASURY SECURITIES 34,963,748.48 33,930,271.78
INVESTMENT CONTRACTS
Trinity Plus 0.047 10/01/29 NR 05/14/08 6,411,744.65 6,411,744.65 Trinity Plus 0.047 10/01/35 NR 05/14/08 4,348,970.73 4,348,970.73 SUBTOTAL INVESTMENT CONTRACTS 10,760,715.38 10,760,715.38 TOTAL INVESTMENTS HELD WITH FISCAL AGENT 218,339,836.32 216,022,777.02 *The City uses S&P ratings
**Includes accrued interest
General Fund 101 122,450,659 - 122,450,659 Measure Z 110 50,729,721 - 50,729,721 Pension Trust 115 6,533,972 - 6,533,972 Enterprise Funds
Electric 510 275,917,771 2,002,899 277,920,670 Electric - Public Benefits Program 511 30,670,249 - 30,670,249 Water 520 49,524,486 - 49,524,486 Water - Conservation & Reclamation Program 521 3,703,086 - 3,703,086 Airport 530 1,765,114 - 1,765,114 Refuse Collection 540 15,611,835 - 15,611,835 Sewer Service 550 104,929,972 1,130,944 106,060,916 Special Transit 560 782,001 - 782,001 Public Parking 570 7,407,456 - 7,407,456 Civic Entertainment (Convention Center, Visitors Bureau, Sports Commission) 580 (298,813) - (298,813) Civic Entertainment (Fox, Box, RMA, Showcase) 581 3,546,690 - 3,546,690 Civic Entertainment (Cheech Marin Center) 582 (3,210,447) - (3,210,447) SubTotal - Enterprise Funds 490,349,400 3,133,843 493,483,243 Special Revenue Funds
Urban Areas Security Initiative 205 (1,357,537) - (1,357,537) Grants and Restricted Programs 215 43,555,927 - 43,555,927 Community Development Block Grant 220 (576,874) - (576,874) Home Investment Partnership Program 221 1,059,481 - 1,059,481 Housing Opportunities for Persons with AIDS 222 (2,029,341) - (2,029,341) Community Development Grants 223 17,163,625 - 17,163,625 Neighborhood Stabilization Program 225 63,112 - 63,112 Special Gas Tax 230 29,106,927 - 29,106,927 Air Quality Improvement 240 1,988,654 - 1,988,654 NPDES Storm Drain 260 74,135 - 74,135 Housing Authority 280 315,241 - 315,241 Housing Assets 281 8,652,874 - 8,652,874 Special Districts Various (67,250) - (67,250) SubTotal - Special Revenue Funds 97,948,974 - 97,948,974 Capital Projects Funds
Capital Outlay 401 13,571,853 - 13,571,853 Storm Drain 410 774,795 - 774,795 Local Park Special Capital Improvements 411 2,133,769 - 2,133,769 Regional Park Special Capital Improvements 413 4,481,781 - 4,481,781 Measure Z Capital Outlay 420 29,480,626 - 29,480,626 Capital Outlay Grants 430 786,039 - 786,039 Transportation Projects 431 109 - 109 Measure A Capital Outlay 432 34,701,618 - 34,701,618 Transportation Development Impact Fees 433 8,091,520 - 8,091,520 Transportation Uniform Mitigation Fees 434 (2,439,237) - (2,439,237) Community Facilities Districts and Assessment Districts Various 2,142,065 - 2,142,065 SubTotal - Capital Project Funds 93,724,938 - 93,724,938 Debt Service Funds
Debt Service Fund - General 390 (16,483,541) - (16,483,541) Debt Service Fund - Public Works 391 864,785 - 864,785 SubTotal Debt Service Funds (15,618,756) - (15,618,756) Agency Funds
Successor Agency Various 20,623,101 - 20,623,101 Community Facilities Districts and Assessment Districts Various 702,267 - 702,267 Special Deposits Various (19,430,096) - (19,430,096) SubTotal Agency Funds 1,895,272 - 1,895,272 Internal Service Funds
Workers' Compensation Insurance Trust 610 22,773,904 - 22,773,904 Unemployment Insurance Trust 620 395,940 - 395,940 Liability Insurance Trust 630 4,789,723 - 4,789,723 Parada Settlement Fund 631 3,054,253 - 3,054,253 Central Stores 640 (636,018) - (636,018) Central Garage 650 11,386,253 - 11,386,253 SubTotal - Internal Service Funds 41,764,055 - 41,764,055 889,778,235$ 3,133,843$ 892,912,078$
1 Amount reflects each fund's share of the City's pooled investment portfolio. 2 Amounts shown are interfund loans outstanding. Interfund loan receivable balances are treated as available cash due to the ability to move loan receivables to other funds as needed.
City of Riverside
Cash Balances by Fund
As of September 30, 2023
Total - All Funds
Cash
Balance 1Fund Interfund Loan
Receivables 2
Cash Balance
+ Loan
Receivables