Снуся -
Finance Department - Treasury Division
MEMORANDUM
To: Mayor and Members of the City Council
From: Andrea Miller, Director of Finance
Jerry Chak, Accounting Manager
Date: October 17, 2023
Subject: MONTHLY CASH BALANCES & INVESTMENT REPORT
August 2023
Enclosed for your information are the Investment Report, Portfolio ummary, and Comparative Cash Report for the month of August 202 repared by the City Treasurer pursuant to the statutory requirements o the State of California.
City of Richmond
Investment Report for August 2023
Pooled Investment Portfolio Analysis
UNAUDITED
Book Value History
Investment Composition: (in millions)
Book Value of Investments Held 268,869,303.97
$350.0
Market Value of Investments Held 268,869,303.97
Unrealized Gain (Loss) - amount 5283 2 52955 306.3
$300.0
Unrealized Gain (Loss) - percentage 0.00% $276.9 $263.8 $250.0 $251.95241.85246.85244.6
S211.0$211.8 $206.0$203.8
$200.0
% Book Value
Federal Agency Securities 0.00% $150.0
-
JPFA Pooled Investment (CalTrust -
$100.0
Short Term Fund) 92.93% 249,849,031.60
Local Agency Investment Fund (LAIF) 7.07% 19,020,272.37 $50.0 Certificates of Deposit 0.00%
Total Investments Held 100.00% 268,869,303.97 So.0
Dec Jan 23 Feb Mar Apr Aug
122 23 23 '23 '23 '23
Cash Summary: Book Value by Investment Type
Pooled Investments (Unrestricted) 268.869.303.97
Fiscal Agent & Other Restricted Investments:
City 18,112,295.98 Certificates of
LAIF
Successor Agency to the RCRA 19,020,272.37 Deposit
22,099,735.52
Total Fiscal Agent & Other Investments 40,212.031.50 7% 0% Checking Accounts & Other Activity -Federal Agency
Securities
General Checking - All Funds 50,943,441.68
Workers Comp & General Liability (784,581.70) 0%
Petty Cash 3,740.00
CalPERS CERBT •Federal Agency Securities
9,746,154.97
OPEB Plan Trust - PARS 42,323,107.99
•Money Market
102,231,862.94 Money Market
Variance - All Restricted & Unrestricted 630,125.69 249,849,031.60 •LAIF 93%
102.861.988.63
• Certificates of Deposit
Total Cash Balance (Fund detail attached) 411,943,324.10 City of Richmond
Cty di
Richmon City of Richmond Finance Department
450 Civic Center Plaza
Portfolio Management Richmond, Richmond, CA 94804
Portfolio Summary (510)620-6740
August 31, 2023
Par Matte Book Portio Days to YTM/C YTM/C
Investments Value Value Term Maturity 360 Equiv. 365 Equiv.
Local Agency Investment Funds 19,020,272.37 19,020,272.37 19,020,272.37 1 1 3.387 3.434 JPA Pooled Investments (CalTrust) 249,849,031.60 249,849,031.60 2230 249,849,031.60 1 1 5.150 5.222
268,869,303.97 268,869,303.97 268,869,303.97 100.00% 1 1 5.025 5.095 Investments
Cash
assbook/Checkin 14,058,570.09 14,058,570.09 14,058,570.09 1 1 0.000 0.000 not included in yield calculations
Total Cash and Investments 282,927,874.06
282,927,874.06 282,927,874.06 5.025 5.095
Total Earnings August 31 Month Ending
Current Year 1,172,105.89
Average Daily Balance 286,924,943.71
Effective Rate of Return 4.81%
The above investments are consistent with the City's Investment Policy and allowable under current legislation of the State of California. Investments were selected using safety, liquidity and yield s the criteria. The source of the market values for the investments are provided by Union Bank of California in accordance with the California Government Code requirement. The City ha ufficient cash flow to cover anticipated expenditures through the next six month:
9l22/23
Andrea Miller, Director of Finance
Reporting period 08/01/2023-08/31/2023 Portfolio CITY
CP
Run Date: 09/19/2023 - 12:33 No fiscal year history available IE (PRF_PM1) 7.3.11
Report Ver. 7.3.11
City of Richmond
Portfolio Management Page 1
Portfolio Details - Investments
August 31, 2023
Average Purchase Stated YM/C Daysto Maturity
CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value S&P 365 Maturity Rate Date
Local Agency Investment Funds
11-07-003 200676 L.A.L.F. - TRAN 0.00 0.00 0.00 0.278 0.278 98-07-724 1000 L.A.!.F. - City of Richmond 19.020.272.37 19.020.272.37 19,020,272.37 3.434 3.434 Subtotal and Average 25,100,917.53 19,020,272.37 19,020,272.37 19,020,272.37 3.434 1 JPA Pooled Investments (CalTrust)
SYS200595 200595 Torrey Pines/Alta Alliance 0.00 0.00 0.00 0.203
0.200 1
SYS200602 200810 CALTRUST TRAN 0.00 0.00 0.00 1
0.510 0.517
SYS200601 200601 Cal Trust 249,849,031.60 249,849,031.60 249,849,031.60
5.150 5.222 1
1601111894 200581 Wells Fargo Bank 0.00 0.00 0.00 0.100 0.101 1 431114503 200534 Union Bank of Calif - Safekeep 07/01/2015
0.00 0.00 0.00 0.000 1
Subtotal and Average 248,866,625.91 249,849,031.60 249,849,031.60 249,849,031.60 5.222 1 Total and Average 286,924,943.71 268.869.303.97 268,869,303.97 268,869,303.97 5.095 1 Portfolio CITY
CP
Run Date: 09/19/2023 - 12:33
PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
City of Richmond
Portfolio Management Page 2
Portfolio Details - Cash
August 31, 2023
verag Purchate Stated YTM/C Days to
CUSIP Investment # Issuer aland Par Value Market Value Book Value Rate S&P 365 Maturit Cash In Banks
SYS200723 200723 Mechanics Bank 14,058,570.09 14.058,570.09 14.058,570.09 0.000 1 Average Balance 0.00 1
Total Cash and Investments 286,924,943.71 282,927,874.06 282,927,874.06 282,927,874.06 5.095 Portfolio CITY
CP
Run Date: 09/19/2023 - 12:33
PM (PRF_PM2) 7.3.11
City of Richmond
Portfolio Management
Investment Status Report - Investments Page 1
August 31, 2023
Stated Maturity Purchas YTM/C YTM/C Payment Accrued Current CUSIP Investment# Issuer Par Value 360
Dates Interest Principal Book Value
Local Agency Investment Funds
11-07-003 200676 L-TRAN 0.00 0.278 0.274 0.278 11/30 - Quarterly 98-07-724 0.00 0.00
1000 LAIF 19,020,272.37 3.434 3.387 3.434 07/01 - Quarterly_ 19,020,272.37 19,020,272.37
Local Agency Investment Funds Totals 19,020,272.37 3.387 3.434 0.00 19,020,272.37 19,020,272.37 JPA Pooled Investments (CalTrust)
SYS200595 200595 ALTA 0.00 0.200 0.200
SYS200602 0.203 07/01 - Monthiy 0.00 0.00
200810 CALTR- 0.00 0.510 0.510 0.517 12/01 - Monthly
SYS200601 200601 0,00 0.00
CALTRU 249,849,031.60 5.150 5.150 5.222 07/01 - Monthly 1601111894 200581 249,849,031.60 249,849,031.60
GRBAY 0.00 0.100 0.100 0.101 07/01 - Monthly
431114503 200534 0.00 0.00
UBOC 0.00 07/01/2015 0.000 0.000 08/01 - Monthly 0.00 0.00 JPA Pooled Investments (CalTrust) Totals 249,849,031.60 5.150 5.222 0.00 249,849,031.60 249,849,031.60
Investment Totals 268,869,303.97 5.025 5.095
0.00 268,869,303.97 268,869,303.97
Portfolio CITY
Run Date: 09/19/2023 - 12:33 CP
PM (PRF_PMS) 7.3.11
Report Ver. 7.3.11
City of Richmond
Portfolio Management
Investment Status Report - Cash
August 31, 2023
Stated Maturity Purchas VIC Payment Accrued Curren
CUSIP Investment# Issuer Par Value Rate Date Dates Interest Principa Book Value Cash In Banks
SYS200723 200723 MECHBK 14.058.570.09 0.000 0.000 07/31 - Monthly 14,058,570.09 14.058,570.09 Cash Totals 14,058,570.09 0.00 14,058,570.09 14,058,570.09 Total Cash and Investments 282,927,874.06 5.025 5.095 0.00 282,927,874.06 282,927,874.06 Portfolio CITY
CP
Run Date: 09/19/2023 - 12:33 PM (PRF_PMS) 7.3.11
CITY OF RICHMOND
CASH BALANCES BY FUND
COMPARATIVE REPORT - August 2022 AND August 2023
August 2022 August 2022 August 2023 August 2023
FUND FUND DESCRIPTION FUND BALANCE TOTAL, FUND BALANCE TOTAL % of Change
GENERAL FUND
0001 GENERAL FUND 72,951,121.72 82,499,251.33
General Fund Total 72,951,121.72 -82,499,25L.33 13.1%
SPECIAL REVENUE FUNDS
1001 SECURED PENSION OVERRIDE 5,805,053.64 (19,672,013.88) 1002 STATE GAS TAX 1,193,117.13 1,428,373.01
1003 TRANSPORTATION OPERATIONS (801,310.14) (881,400.80) 1004 ASSET SEIZURE FUND 307,433.88 262,355.65
1005 LIBRARY FUND 5,526,473.73 5,509,699.84
1006 OUTSIDE FUNDED SVCS - GRANTS 1,106,716.79 449,801.60 1007 EMERGENCY MED SERV 359,200.91 271,949.86
1008 PT MOLATE SEC & MAINT
1009 VEOLIA MITIGATION 301,584.82 314,638.27
1010 N.RICHMOND WASTE 164,718.41 162,982.54
1011 OUTSIDE FUNDED SVCS - DONATION 6,896.71 6,909.36
1012 HILLTOP LANDSCAPE MAINT DIST 497,795.32
1013 HAZMAT FUND
1014 EDA GRANT FUND
1015 MARINA BAY LNDSCP & LIGHT DIST 748,818.91 6033982.72 1016
1017 CHEVRON MODERNIZATION PROJECT 18,190,620.61 12,954,918.30 1018 RENT CONTROL 1,326,959.46 1,713,578.33
1019 GAS TAX SEC 201 1,965,264.82 2,716,038.28
1050 CR-PLANNING & BUILDING 11,283,229.05 12,363,425.36 1051 CR-ENGINEERING 636,602.50 659,602.50
1053 CR-CODE ENFORCEMENT (185,139.83) (185,139.83)
1054 ENGINEERING GRANTS (5,728,555.25) (5,709,280.17)
1055 ENCROACHMENT SERVICES 2,744,505.19 2,881,062.30
1056 RENT CONTROL
1200 HOUSING ADMINISTRATION 923,661.26 1,367,781.82
1201 CDBG 1,261,283.79 1,288,928.84
1202 HOME PROGRAM 421,277.28 421,571.43
1203 NEIGHBORHOOD STABILIZATION 69,992.97 69,992.97
1204 COBG RECOVERY
1205 EMPLOYMENT & TRAINING 885,145.09 962,046.04
1206 CDBG HOMELESS PREV RAPID RESP
1207 COR-NEIGHBORHOOD STAB(CITY) (107,007.81) (107,007.81) 1208 SUCCESSOR HOUSING AGENCY 2,574,641.15 2,641,545.81 1209 CAL-HOME GRANT FUND 1,000,884.57 1,065,769.02
1302 HOUSING IN LIEU 1,263,077.49 1,707,273.96
1303 KIDS FIRST 4,168,505.97 4,361,518.59
1304 EMERGENCY RECOVERY 247,938.14 309,764.16
1305 PUBLIC ART 2,504,085.11 2,541,839.52
1306 ARPA 23,886,642.18 23,862,648.77
Special Revenue Funds 84,550,113.85 61,47/238.00 -27%
CAPITAL PROJECT FUNDS
2001 GENERAL CAPITAL FUND 21,424,081.28 21,857,881.33
2002 MEASURE J 1,080,048.88 940,935.26
2003 CIP LSE REV BOND 01
2004 CIVIC CENTER :
2006 PARKS FUND
2007 HARBOR FUND 46,645.92 16,731.52
2008 TRANSPORTATION FUND
2009 STATE HIGHWAY FUND
2110 IMPACT FEE - PARKS 156,646.01 161,248.83
2111 IMPACT FEE - TRAFFIC 1,563,816.24 1,586,382.02
2113 IMPACT FEE - FIRE 60,731.66 65,619.76
2114 IMPACT FEE - POLICE 642,912.48 647,999.85
2115 IMPACT FEE - COMM/AQUATC 575,434.52 593,142.01
2116 IMPACT FEE - PARKS/OPEN 2,965,031.02 3,039,894.54
2117 IMPACT FEE - LIBRARY 1,801,218.08 1,823,323.76
2118 IMPACT FEE - HILLTOP 32,386.00 32,445.43
2119 IMPACT FEE - STORM DRAINAGE 1,038,211.35 1,047,220.29 2120 IMPACT FEE - WASTEWATER 2,515,628.63 2,425,269.06
2125 SECTION 108 IRON TRIANGLE 265,462.29 265,911.13
2126 HOUSING CIP FUND
Capital Project Funds Total 34,168,254.36 :34,534,004.79 1.1% Cash Bal by FUND August 2023, page 1 of 3 9/13/2023
August 2022 August 2022 August 2023 August 2023
FUND FUND DESCRIPTION FUND BALANCE TOTAL FUND BALANCE TOTAL % of Change
DEBT SERVICE FUNDS
3001 DS - 2005 TAXABLE POB 236,788.28 12,870.71
3002 DS - 99A PENSION OBLIG BOND 80,526.37 80,526.37
3003 DS - 95A SER REV REDG BDS
3005 DS-2007 REFNDING&CVC CTR 3096752
212,978.88
Debt Service Funds Total 408,282.17 306,375.96 -25.0%
ENTERPRISE FUNDS
4001 PORT OF RICHMOND 10,859,855.63 16,862,653.61
4003 WASTEWATER 46,436,804.48 36,425,157.79
4005 MARINA 4,999,056.93 4,951,776.64
4006 STORMWATER 2,008,485.19 1708, 170003
4007 UTL-ENCROC
4008 KCRT - CABLE TELEVIS
4009 638,724.58
PARKING AUTHORITY
4101 RHA-HSNG CHOICE VOUCHER-SEC 8 796,184.89 196,184.89 4102 RHA-HOPE 6 236,457.65 236,457.63
4103 RHA-PROJECT REAL (33,203.52) (33,203.52)
4201 RHA-CAPITAL FUND 686,075.02 640,388.48
4401 RHA-HACIENDA 1,224,356.72 1,222,795.56
4402 RHA-FRIENDSHIP MANOR (14,439.98) (14,439.98)
4403 RHA-TRIANGLE COURT (73,168.83) (73,168.83)
4404 RHA-NEVIN PLAZA (412,734.99) (324,311.10)
4405 RHA-NYSTROM VILLAGE 1,353,421.11 1,311,402.34
4406 RHA-RICHMOND VILLAGE ONE 73,350.35 73,350.35
4407 RHA-RICHMOND VILLAGE TWO 98,968.00 98,968.00
4408 RHA-RICHMOND VILLAGE THREE 8,780.00 8,780.00
4409 RHA-LOCAL FUND 19,892.40 19,892.40
4501 RHA-CENTRAL OFFICE COST CNTR (1,123,739.89) (1,204,803.50) 4502 RHA - HSG CORP 137,179.04 127,437.13
Enterprise Funds Total 67,846,370.53 63,472,212.67 -6.4%
INTERNAL SERVICE FUNDS
5001 INSURANCE RESERVES 53,801,437.90 52,653,505.05
5002 INFORMATION TECHNOLOGY (2,195.00)
5003 EQUIPMENT SERVICES 6,630,612.44 6,238,407.18
5004 FACILITIES MANAGEMENT
5005 CAD DISPATCH SYSTEM :
5006 RMS RECORDS SERVICES
5007 800 MHZ TELECOM SYSTEM
5008 COMP ABSENCES 1,240,892.00 1,176,797.13
Internal Service Funds Total 61,672,942.34 60,066,514.36 -2.6%
TRUST & AGENCY FUNDS
6001 GENERAL TRUST & AGENCY 855.11 856.68
6002 JOHNSON TRUST 11,049.84 11,070.12
6003 CUBA FRIENDSHIP
6004 COMMISSION ON AGING 38,213.70 39,311.41
6005 SEAVER GALLERY TRUST FUND 219,816.88 280,915.24
6006 POLICE GENERAL TRUST 2,689,043.59 2,702,022.16
6007 SENIOR TRUST DEPOSIT 73,749.83 76,462.18
6047 CALPERS CERT ACCT 9,746,154.97 9,746,154.97
6048 OPEB PL FUND 41,321,443.39 42,323,107.99
6049 PT MOLATE NAVY GRANT 979,746.49 867,131.54
6050 GENERAL PENSION FUND 1,006,769.98 1,121,402.28
6051 POLICE & FIRE PENSION 10,037,483.41 7,986,486.09
6052 GARFIELD PENSION FUND
6053 JPFA: 99 REV REFUND
6054 CUTTING CANAL A.D. 8 : :
6055 HILLTOP REDEMPTION F
6056 SAN PABLO 854 ASSES 271,780.26 272,279.00
6057 HARBOR NAVIGATION IM 183,359.42 183,695.89
6058 MARINA WESTSHORE DEB 785,226.16 786,525.43
6059 COUNTRY CLUB VISTA 1,033,948.60 1,035,687.91
6060 REASSESSMENT DISTRICT 2003-1 1,894,324.09 1,897,800.27 6061 REGLA CITY 864.07 580.07
6062 SHIMADA CITY 14,693.95 14,693.95
6064 ZHOUSHAN FRIENDSHIP COM. 2,788.71 2,788.71
6999 PAYROLL LIABILITIES FUND 3,119,794.84 15,524,915.52 Trust & Agency Funds Total 73,431,107.29 84,873,887.41 15.6%
SUCCESSOR AGENCY - FIDUCIARY FUNDS
6101 SA - PROPERTY TAX TRUST FUND 2,848,410.76 622,186.07 6102 SA-ADMINISTRATION 134.52 232,880.01
6103 SA-CAPITAL PROJECT FUNDS 8,085,153.98 8,238,843.76 Cash Bal by FUND August 2023, page 2 of 3 9/13/2023
August 2022 August 2022 August 2023 August 2023
FUND FUND DESCRIPTION FUND BALANCE TOTAL FUND BALANCE TOTAL % of Change 6104 SA-LOW/MOD INCOME HOUSING
6105 SA-WELLS FARGO 2002 LOAN
6106 EPA IN POL
6201 SA-CIP O0A TARB BND PRCDS-JPFA
6202 SA-CIP OOB TARB BND PRCDS-HSNG
6203 SA-CIP 03B TARB BND PRCDS
6204 SA-CIP 04A TARB BND PRCDS
6205 SA-CIP 04A TARB BND PROS-HSG
6206 SA-CIP 04B TARB BND PRCOS-HSG
6207 SA-CIP 07A TAR8 BND PRCDS
6208 SA-CIP 078 TAR8 BND PRCDS-HSG
6300 SA-DS HARBOR 98 TARB 1,280,239.94 163,009.65
6301 SA-DS 2000A TARB
6302 SA-DS 2000B TARB - HOUSING
6303 SA-DS 2003A TARB
6304 SA-DS 2003B TARB 1,729,971.80 1,755,099.10
6305 SA-DS 2004A TARB 2/3 1,644,512.41 1,657,727.47
6306 SA-DS 2004A TARB -1/3 HSING 888,231.37 1,247,871.10 6307 SA-DS 2004B TARB - HOUSING
6308 SA-DS 2007/10A TARB
6309 SA-DS 2007/10B TARB - HOUSING 2,194,570.63 3,311,962.54 6401 SA-DS 2014A NON-TAXABLE BONDS 3,325,023.20 3,352,892.43 6402 SA-DS 2014B TAXABLE BONDS
6403 SA-DS LOANS PAYABLE
6404 SA-DS 2021 ANTB 429,915,86 433,517.83
6405 SA-DS 2021 BTRB 1,693,423.52 1,707,616.58
6996 SUCCESSOR AGENCY - GLTDAG
6997 SUCCESSOR AGENCY - GFAAG
Successor Agency - Fiduciary Funds 24,119,587.99 22,723,606.54 -5.79%
RHA CONVL FUNDS
8101 RHA CONVNL
RHA Convni Funds 0.00%
TREASURER'S FUNDS
9999 TREASURER'S FUND. (1,195,227.86) 2,020,233.04
Treasurer's Fund Total (1,195,227.86) 2,020,233.04 269.02% TOTAL CASH 417,952,552.39. / 411,943,324.10 / -1.44%
Cash Bal by FUND August 2023, page 3 of 3 9/13/2023