Bichelor
Finance Department - Treasury Division
MEMORANDUM
To: Mayor and Members of the City Council
From: Belinda Brown, Finance Director/Treasurer
Date: April 5, 2022
Subject: MONTHLY CASH BALANCES & INVESTMENT REPORT =
February 2022
Enclosed for your information are the Investment Report, Portfolio ummary, and Comparative Cash Report for the month of February 202 repared by the City Treasurer pursuant to the statutory requirements o City of Richmond
Investment Report for February 2022
Pooled Investment Portfolio Analysis
UNAUDITED
Book Value History
Investment Composition: (in millions)
Book Value of Investments Held 166,614,648.34
$200.0
Market Value of Investments Held 166,614,648.34
$180.0 $177.2
Unrealized Gain (Loss) - amount
0.00% $160.0 $158.2$158.2 $148.3$155.4$152.4 5138.45145. 5156.5 5264.6$166.6 Unrealized Gain (Loss) - percentage
$140.0 $135.8$130.3
$120.0
$100.0
% Book Value $80.0
Federal Agency Securities 0.00%
CalTrust - Short Term Fund 54.99% 91,614,789.31 $600
Local Agency Investment Fund (LAIF) 45.01% 74,999,859.03 $40.0 Certificates of Deposit 0.00% $20.0
Total Investments Held 100.00% 166,614,648.34 $0.0
Feb Mar Apr May June July Aug Sept Oct Nov Dec Jan '22 Feb '21 '21 '21 '21 '21 '21 '21 '21 '21 '21 '22
Book Value by Investment Type
LAIF
Cash Summary: 74,999,859.03
45% Certificates of Deposit
Pooled Investments (Unrestricted) 166,614,648.34
Fiscal Agent & Other Restricted Investments: 0%
City 43,003,071.48
Successor Agency to the RCRA 21,119,256.59 _Federal Agency Securities
Total Fiscal Agent & Other Investments 64,122,328.07
0%
Checking Accounts & Other Activity 54,053,297.50 • Federal Agency Securities Total Cash Balance (Fund detail attached) 284,790,273.91 • Money Market
• LAIF
99614.18.34 • Certificates of Deposit
55%
City of Richmond
= *SymPro City of Richmond Finance Department
450 Civic Center Plaza
THEF Portfolio Management Richmond, Richmond, CA 94804
Portfolio Summary (510)620-6740
February 28, 2022
Par Market Book Portio Days to YTM/C YTM/C
Investments Value Value Value Term Maturity 360 Equiv. 365 Equiv.
Local Agency Investment Funds 74,999,859.03 74,999,859.03 74,999,859.03 45.01 1 1 0.274 0.278 Money Markets 91,614,789.31 91,614,789.31 91,614,789.31 54.99 1 1 0.530 0.537 166,614,648.34 166,614,648.34 166,614,648.34 100.00% 1 1 0.415 0.421 Investments
Cash
assbook/Checki 13,262,765.90 13,262,765.90 13,262,765.90 1 1 0.000 0.000 ot included in yield calculation
Total Cash and Investments 179,877,414.24 179,877,414.24 179,877,414.24 1 1 0.421
0.415
Total Earnings February 28 Month Ending
Current Year
Average Daily Balance 184,323,931.68
Effective Rate of Return
he 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 yiel is 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 sufficient cash flow to cover anticipated expenditures through the next six months. donk 3.17.22
Belinda Brown, Directorof Finance
Reporting period 02/01/2022-02/28/2022 Portfolio CITY
CP
Run Date: 03/16/2022 - 09:22 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
February 28, 2022
Average Purchase Stated YTM/C Days to Maturity
CUSIP Investment# Issuer Balance Date Par Value
Market Value Book Value Rate S&P 365 Maturity Date
Local Agency Investment Funds
11-07-003 200676 L.A.I.F. - TRAN 0.00 0.00 0.00 0.278 0.278 1 98-07-724 1000 LA.I.F. - City of Richmond 74,999,859.03 74,999,859.03 74,999,859.03 0.278 0.278 1 Subtotal and Average 74,999,859.03 74,999,859.03 74,999,859.03 74,999,859.03 0.278 1 Money Markets
SYS200595 200595 Torrey Pines/Alta Alliance 0.00 0.00 0.00 0.200 0.203 1 SYS200602 200810 CALTRUST TRAN 0.00 0.00 0.00 0.510 0.517 1 SYS200601 200601 Cal Trust 91,614,789.31 91,614,789.31 91,614,789.31 0.530 0.537 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 92,637,287.53 91,614,789.31 91,614,789.31 91,614,789.31 0.537 1 Total and Average 184,323,931.68 166,614,648.34 166,614,648.34 166,614,648.34 0.421 1 Portfolio CITY
CP
Run Date: 03/16/2022 - 09:22
PM (PRF_PM2) 7.3.11
Report Ver. 7.3.11
City of Richmond
Portfolio Management Page 2
Portfolio Details - Cash
February 28, 2022
Average Purchase Stated YTM/C Days to
CUSIP Investment # Issuer Balance Date Par Value Market Value Book Value Rate S&P 365 Maturity Cash In Banks
SYS200723 200723 Mechanics Bank 13,262,765.90 13,262,765.90 13,262,765.90 0.000 1 Average Balance 0.00 1
Total Cash and Investments 184,323,931.68 179,877,414.24 179,877,414.24 179,877,414.24 0.421 1 Portfolio CITY
CP
Run Date: 03/16/2022 - 09:22 PM (PRF_PM2) 7.3.11
City of Richmond
Portfolio Management
Investment Status Report - Investments Page 1
February 28, 2022
Investment # Stated Maturity Purchas YTM/C YTM/C Payment Accrued Current CUSIP Issuer Par Value Rate Date 365 Dates Interest Principal Book Value
Local Agency Investment Funds
11-07-003 200676 L-TRAN 0.00 0.274 0.278 11/30 - Quarterly 0.00 0.00 98-07-724 1000 LAIF 74,999,859.03 0.274 0.278 07/01 - Quarterly 74,999,859.03 74,999,859.03 74,999,859.03 панинии
Local Agency Investment Funds Totals 0.274 0.278 0.00 74,999,859.03 74,999,859.03 Money Markets
SYS200595 200595 ALTA 0.00 0.200 0.200 0.203 07/01 - Monthly 0.00 0.00 SYS200602 200810 CALTR- 0.00 0.510 0.510 0.517 12/01 - Monthly 0.00 0.00 SYS200601 200601 CALTRU 91,614,789.31 0.530 0.530 0.537 07/01 - Monthly 91,614,789.31 91,614,789.31 1601111894 200581 GRBAY 0.00 0.100 0.100 0.101 07/01 - Monthly 0.00 431114503 200534 UBOC 0.00 07/01/2015 0.000 0,000 08/01 - Monthiy 0.00 Money Markets Totals 91,614,789.31 91,614,789.31 3161478900
0.530 0.537 0.00
Investment Totals 166,614,648.34 0.415 0.421 0.00 166,614,648.34 166,614,648.34 Portfolio CITY
CP
Run Date: 03/16/2022 - 09:22
PM (PRF_PMS) 7.3.11
Report Ver. 7.3.11
City of Richmond
Portfolio Management
Investment Status Report - Cash
February 28, 2022
Stated Maturity Purchas aG YTM/C Payment Accrued Current CUSIP Investment # Issuer Par Value Rate Date 365 Dates Interest Principal Book Value Cash In Banks
SYS200723 200723 MECHBK 13,262,765.90 0.000 0.000 07/31 - Monthly 13,262,765.90 13,262,765.90 Cash Totals 13,262,765.90 0.00 13,262,765.90 13,262,765.90 Total Cash and Investments 179,877,414.24 0.415 0.421 0.00 179,877,414.24 179,877,414.24 Portfolio CITY
CP
Run Date: 03/16/2022 - 09:22 PM (PRF_PMS) 7.3.11
CITY OF RICHMOND
CASH BALANCES BY FUND
COMPARATIVE REPORT -FEBRUARY 2021 AND FEBRUARY 2022
FEBRUARY 2021 FEBRUARY 2021 FEBRUARY 2022 FEBRUARY 2022 FUND FUND DESCRIPTION FUND BALANCE TOTAL FUND BALANCE TOTAL % of Change
GENERAL FUND
0001 GENERAL FUND 28,578,077.47 35,226,101.67
General Fund Total 28,678,077.47 35,226,101.67 22.8%
SPECIAL REVENUE FUNDS
1001 SECURED PENSION OVERRIDE (10,301,593.82) (11,625,738.81) 1002 STATE GAS TAX 470,953.69 681,794.12
1003 TRANSPORTATION OPERATIONS 23,212.47 267,520.87
1004 ASSET SEIZURE FUND 339,759.58 321,142.99
1005 LIBRARY FUND 467,208.77 438,683.25
1006 OUTSIDE FUNDED SVCS - GRANTS 726,371.98 384,814.95 1007 EMERGENCY MED SERV 275,201.74 316,547.81
1008 PT MOLATE SEC & MAINT
1009 VEOLIA MITIGATION 243,806.03 269,571.73
1010 N.RICHMOND WASTE (6,054.63) (106,313.31)
1011 OUTSIDE FUNDED SVCS - DONATION 6,711.47 6,732.24
1012 HILLTOP LANDSCAPE MAINT DIST 295,013.02 346,306.46 1013 HAZMAT FUND (899.51) 71,748.00
1014 EDA GRANT FUND 43,263.60
1015 MARINA BAY LNDSCP & LIGHT DIST 916,112.93 874,647.27 1016
1017 CHEVRON MODERNIZATION PROJECT 12,853,529.88 14,357,228.90 1018 RENT CONTROL 1,401,293.79 1,937,053.50
1019 GAS TAX SEC 201 2,522,010.09 3,233,467.11
1050 CR-PLANNING & BUILDING 4,668,661.92 5,376,379.25
1051 CR-ENGINEERING (2,963,404.89) (2,911,404,89)
1053 CR-CODE ENFORCEMENT (211,677.83) (211,677.83)
1054 ENGINEERING GRANTS (1,366,950.03) (6,176,024.95)
1055 ENCROACHMENT SERVICES 1,374,165.21 1,872,360.67
1056 RENT CONTROL
1200 HOUSING ADMINISTRATION (1,139,720.94) 260,255.86
1201 CDBG 1,399,988.04 1,489,801.61
1202 HOME PROGRAM 871,025.18 384,512.46
1203 NEIGHBORHOOD STABILIZATION 158,546.01 131,659.12
1204 CDBG RECOVERY
1205 EMPLOYMENT & TRAINING 2,442,594.07 280,283.92
1206 CDBG HOMELESS PREV RAPID RESP
1207 COR-NEIGHBORHOOD STAB(CITY) (97,567.32) (103,643.27) 1208 SUCCESSOR HOUSING AGENCY 1,862,093.13 1,875,040.31 1209 CAL-HOME GRANT FUND 776,607.09 831,921.68
1302 HOUSING IN LIEU 2,872,281.99 2,715,955.16
1303 KIDS FIRST 291,700.45 1,360,114.57
1304 EMERGENCY RECOVERY 91,360.86 (232,162.08)
1305 PUBLIC ART 371,644.87 891,560.20
1306 ARPA 13,851,368.13
Special Revenue Funds 21,677,248.89 33,461,513.01 54%
CAPITAL PROJECT FUNDS
2001 GENERAL CAPITAL FUND 3,096,720.85 2,746,779.01
2002 MEASURE J 585,413.26 830,200.26
2003 CIP LSE REV BOND 01
2004 CIVIC CENTER :
2006 PARKS FUND
2007 HARBOR FUND 45,533.48
2008 TRANSPORTATION FUND
2009 STATE HIGHWAY FUND
2110 IMPACT FEE - PARKS 122,582.76 154,795.09
2111 IMPACT FEE - TRAFFIC 861,136.26 1,029,778.44
2113 IMPACT FEE - FIRE 164,123.28 178,848.37
2114 IMPACT FEE - POLICE 401,941.81 580,585.47
2115 IMPACT FEE - COMM/AQUATC 384,286.40 516,786.12
2116 IMPACT FEE - PARKS/OPEN 1,951,981.32 2,927,153.75
2117 IMPACT FEE - LIBRARY 1,409,214.48 1,658,168.56
2118 IMPACT FEE - HILLTOP 31,516.14 31,613.65
2119 IMPACT FEE - STORM DRAINAGE 638,221.74 798,011.29
2120 IMPACT FEE - WASTEWATER 2,353,421.28 2,459,060.43
2125 SECTION 108 IRON TRIANGLE 382,496.66 287,152.94
2126 HOUSING CIP FUND (166,431.90) (166,431.90)
Capital Project Funds Total 12,262,017.37 14,078,034.96 14.8% Cash Bal by FUND February 2022, page 1 of 3 3/16/2022
FEBRUARY 2021 FEBRUARY 2021 FEBRUARY 2022 FEBRUARY 2022 FUND FUND DESCRIPTION FUND BALANCE TOTAL FUND BALANCE TOTAL % of Change
DEBT SERVICE FUNDS
3001 DS - 2005 TAXABLE POB 12,331,548.06 13,072,923.59
3002 DS - 99A PENSION OBLIG BOND 3,939.28 153,354.12
3003 DS - 95A SER REV REDG BDS
3005 DS-2007 REFNDING&CVC CTR 490590.37 563,210.44
Debt Service Funds Total 12,831,077.71 13,789,488.15 7.5%
ENTERPRISE FUNDS
4001 PORT OF RICHMOND 7,211,518.49 10,385,911.90
4003 WASTEWATER 47,958,571.80 39,744,022.12
4005 MARINA 4,186,043.22 4,452,355.66
4006 STORMWATER (133,853.75) 996,535.82
4007 UTL-ENCROC
4008 KCRT - CABLE TELEVIS 681,465.74 792,598.87
4009 PARKING AUTHORITY
4101 RHA-HSNG CHOICE VOUCHER-SEC & (3,213,294.61) (2,046,843.61) 4102 RHA-HOPE 6 (473,379.67) 275,141.12
4103 RHA-PROJECT REAL (40,216.09) (33,203.52)
4201 RHA-CAPITAL FUND 317,986.21 389,861.85
4401 RHA-HACIENDA (2,006,013.07) 1,316,773.97
4402 RHA-FRIENDSHIP MANOR (76,304.94) (14,439.98)
4403 RHA-TRIANGLE COURT (191,796.85) (73,168.83)
4404 RHA-NEVIN PLAZA (997,352.93) 2,000,414.23
4405 RHA-NYSTROM VILLAGE 1,530,360.99 3,285,117.80
4406 RHA-RICHMOND VILLAGE ONE 62,817.05 66,665.44
4407 RHA-RICHMOND VILLAGE TWO 69,617.81 91,194.00
4408 RHA-RICHMOND VILLAGE THREE 11,956.00 5,926.00
4409 RHA-LOCAL FUND 13,736.87 19,892.40
4501 RHA-CENTRAL OFFICE COST CNTR (3,080,222.67) (2,739,582.55) 4502 RHA - HSG CORP 4,758.87 73,269.87.
Enterprise Funds Total 52,836,398.47 58,993,442.56 11.7%
INTERNAL SERVICE FUNDS
5001 INSURANCE RESERVES 49,419,778.80 46,481,241.43
5002 INFORMATION TECHNOLOGY
5003 EQUIPMENT SERVICES 1,509,895.48 2,660,763.55
5004 FACILITIES MANAGEMENT
5005 CAD DISPATCH SYSTEM :
5006 RMS RECORDS SERVICES :
5007 800 MHZ TELECOM SYSTEM
5008 COMP ABSENCES 674,167.87 656,082.74
Internal Service Funds Total 51,603,842.15 49,798,087.72 -3.5%
TRUST & AGENCY FUNDS
6001 GENERAL TRUST & AGENCY 832.16 834.73
6002 JOHNSON TRUST 10,753.05 10,786.31
6003 CUBA FRIENDSHIP
6004 COMMISSION ON AGING 40,549.60 38,617.31
6005 SEAVER GALLERY TRUST FUND 68,811.35 139,676.01
6006 POLICE GENERAL TRUST 2,650,849.02 2,650,491.66
6007 SENIOR TRUST DEPOSIT 66,094.65 61,548.71
6047 CALPERS CERT ACCT 5,653,936.14 6,849,452.29
6048 OPEB PL FUND 29,115,711.59 32,657,496.28
5049 PT MOLATE NAVY GRANT 2,317,127.17 2,087,400.29
6050 GENERAL PENSION FUND 1,215,285.82 833,666.65
6051 POLICE & FIRE PENSION 8,678,414.64 9,419,846.64
6052 GARFIELD PENSION FUND 265,520.64 215,332.61
6053 JPFA: 99 REV REFUND
6054 CUTTING CANAL A.D. 8
6055 HILLTOP REDEMPTION F
6056 SAN PABLO 854 ASSES 264,480.56 265,298.80
6057 HARBOR NAVIGATION IM 178,434.59 178,986.63
6058 MARINA WESTSHORE DEB 715,248.82 700,314.40
6059 COUNTRY CLUB VISTA 1,310,696.59 1,510,463.71
6060 REASSESSMENT DISTRICT 2003-1 1,843,444.85 1,849,148.00 6061 REGLA CITY 1,380.12 1,380.12
6062 SHIMADA CITY 14,594.81 14,219.81
6064 ZHOUSHAN FRIENDSHIP COM. 288.71 1,288.71
6999 PAYROLL LIABILITIES FUND 2.782.914.74 (2,087,042.88) Trust & Agency Funds Total 57,195,369.62 57,399,206.79 0.4%
SUCCESSOR AGENCY - FIDUCIARY FUNDS
6101 SA - PROPERTY TAX TRUST FUND 6,211,457.00 1,099,502.49 6102 SA-ADMINISTRATION 249,353.60 229,511.87
6103 SA-CAPITAL PROJECT FUNDS 11,477,901.98 6,631,925.91 Cash Balby FUND February 2022, page 2 of 3 3/16/2022
FEBRUARY 2021 FEBRUARY 2021 FEBRUARY 2022
FUND FUND DESCRIPTION FUND BALANCE TOTAL FUND BALANCE FEBRUA 2022 % of Change
6104 SA-LOW/MOD INCOME HOUSING
6105 SA-WELLS FARGO 2002 LOAN
6106 EPA LN POL
6201 SA-CIP O0A TARB BND PRCDS-JPFA
6202 SA-CIP 00B TARB BND PRODS-HSNG
6203 SA-CIP 03B TARB BND PRODS
6204 SA-CIP 04A TARB BND PRCDS
6205 SA-CIP 04A TARB BND PRCDS-HSG
6205 SA-CIP 048 TARB BND PRCDS-HSG
6207 SA-CIP O7A TARB BND PRCDS
6208 SA-CIP 078 TARB BND PRCDS-HSG
6300 SA-DS HARBOR 98 TARB 1,244,974.40 2,362,180.04
6301 SA-DS 2000A TARB
6302 SA-DS 2000B TARB - HOUSING
6303 SA-DS 2003A TARB
6304 SA-DS 2003B TARB 1,851,129.85 1,848,524.85
6305 SA-DS 2004A TARB 2/3 1,861,300.41 1,775,475.29
6306 SA-DS 2004A TARB -1/3 HSING 594,878.62 976,349.02
6307 SA-DS 2004B TARB - HOUSING 342,685.48
6308 SA-DS 2007/10A TARB 6,014,501.12
6309 SA-DS 2007/10B TARB - HOUSING 2,018,733.63 2,066,313.46 6401 SA-DS 2014A NON-TAXABLE BONDS 3,771,261.85 3,713,285.16 6402 SA-DS 20148 TAXABLE BONDS -
6403 SA-DS LOANS PAYABLE :
6404 SA-DS 2021 ANTB 1,313,056.61
6405 SA-DS 2021 BTRB 9,010.10
6996 SUCCESSOR AGENCY - GLTDAG :
6997 SUCCESSOR AGENCY - GFAAG
Successor Agency - Fiduciary Funds 35,638,178.94 22,025,134.80 -38.20%
RHA CONVL FUNDS
8101 RHA CONVNI. (2.215,969.76)
RHA Convni Funds (2,215,969.76) -100.00%
TREASURER'S FUNDS
9999 TREASURER'S FUND- 42,210.62 19,264.25
Treasurer's Fund Total 42,210.62 19,264.25 -54.36%
TOTAL CASH 2.70,548,151.48 284,790,273.91 5.26%
Cash Bal by FUND February 2022, page 3 of 3 3/16/2022