HomeMy WebLinkAboutItem 08 - Periodic Quarterly Report of Investments as of September 30, 2021 Finance and Management Services
www.santa-ana.org/finance
Item # 8
City of Santa Ana
20 Civic Center Plaza, Santa Ana, CA 92701
Staff Report
November 16, 2021
TOPIC: Periodic Quarterly Report of Investments as of September 30, 2021
AGENDA TITLE:
Receive and File Quarterly Report of Investments as of September 30, 2021
RECOMMENDED ACTION
Receive and file.
DISCUSSION
California Code Section 53646 (b) states that if a quarterly report is rendered to the
legislative body, the quarterly investment report shall be submitted within 30 days
following the end of the quarter covered by the report. In an effort to meet the statutory
requirement, Finance & Management Services Agency (“FMSA”) submits the Report via
email for review and distribution to the City Council in advance. The report was emailed
for distribution on October 25, 2021. The legislation specifies that this quarterly report
contain the seven major elements listed below:
1. Type of investments,
2. Date of maturity,
3. Par and dollar amounts invested in each security,
4. Weighted average maturity of the investments,
5. Market value as of the date of the report,
6. Source of the market value information, and
7. Any funds, investments or programs, including loans,
under the management of contracted parties.
These specifications include a statement outlining the ability of the City to meet the
budgeted expenditures for the subsequent six months be submitted to the City Council
on a quarterly basis. Staff performs an end-of-month expenditure analysis to comply with
the expenditure requirement and a statement confirming the ability to meet this
requirement in the monthly and quarter-ending Treasurer’s Report. The information is in
compliance with State law and the City’s Investment Policy.
The attached Treasurer’s Report (Exhibit 1) accurately reflects all pooled investments
held on behalf of the City as of September 30, 2021.
Quarterly Report of Investments
November 16, 2021
Page 2
2
2
3
2
The attached Cash held by Bank and Cash held by Fund(s) Listing (Exhibit 2) is a
schedule of cash by funds added to the monthly and quarterly Report of Investments to
enhance FMSA’s reporting and transparency.
The following two tables represent: (1) percentage limits set by the City’s Investment
Policy and State Law and shows respective City investment portfolio investment types,
amounts, and percentages; and (2) the restricted cash balance as of September 30, 2021.
Type of Investment Amounts
Invested $
Portfolio
%
COSA
Policy
Limits
%
State Law
Limits %
Federal Farm Credit Bank (FFCB)$51,909,210 13.30%None None
Federal Home Loan Bank (FHLB)$133,648,358 34.23%None None
Federal Home Loan Mortgage Corp. (FHLMC)$49,991,250 12.80%None None
Federal National Mortgage Association (FNMA)$61,899,880 15.85%None None
Local Agency Investment Fund (LAIF)$29,027,540 7.44%None None
Local Agency Investment Fund (LAIF – ARPA)$63,936,641 16.38%None None
Sub- Total:$390,412,880 100%None None
Cash :$32,248,630
Total:$422,661,509
Restricted Cash In $
Restricted Cash †,$43,662,267
Total $43,662,267
† Restricted cash is held by various Trustees such as Bank of New York Mellon; US Bank; Signature Bank; and
State of California Condemnation Fund. Restricted Cash is segregated from cash used for daily operations.
The following City investment portfolio graph represents percentages within the
respective investment types as of September 30, 2021.
Quarterly Report of Investments
November 16, 2021
Page 3
2
2
3
2
The following two tables represent, as of September 30, 2021: (1) the aggregate Average
Market Yield To Date (AMTD); and (2) the breakdown of by investment type.
Aggregate Average Market Yield To Date
Average Month To Date (AMTD)0.730%
Investments Par Value of Investments YTM
% of
Portfolio
LAIF $29,027,539.85 0.206%7.44%0.015%
LAIF (ARPA)$63,936,641.14 0.206%16.38%0.034%
Federal Agency Securities $297,448,698.58 0.894%76.19%0.681%
$390,412,880 0.730%100.00%0.730%
Cash held by Bank and Cash by Fund(s) Listing (Exhibit 2)
The above-referenced exhibit (Exhibit 2) includes a comparison of bank balances
between each City Cash account including Investments; Cash held at a City designated
financial institution; Cash on Hand; and Restricted Cash versus the Cash held by various
Fund(s).
ENVIRONMENTAL IMPACT
There is no environmental impact associated with this action.
FISCAL IMPACT
There is no fiscal impact associated with this action.
EXHIBIT(S)
1. Treasurer’s Report
2. Cash Held by Bank and Cash Fund(s) Listing
Submitted By: Kathryn Downs, FMSA Executive Director
Approved By: Kristine Ridge, City Manager
City of Santa Ana
Portfolio Management
September 30, 2021
Portfolio Summary
% of
Portfolio
Book
ValueInvestmentsMarket
Value
Par
Value
Days to
MaturityTerm
YTM/C
Local Agency Investment Funds 29,027,539.85 17.44 0.206129,027,539.8529,027,539.85
Cash in Banks 63,936,641.14 116.38 0.206163,936,641.1463,936,641.14
Federal Agency Coupon Securities 297,448,698.58 1,71376.19 0.894400297,570,931.75297,600,000.00
390,412,879.57 100.00%Investments 390,535,112.74390,564,180.99 1,305 305 0.730
Cash
(not included in yield calculations)Passbook/Checking 32,248,629.54 1 0.000132,248,629.5432,248,629.54
422,661,509.11Total Cash and Investments 422,783,742.28422,812,810.53 1,305 305 0.730
Current Year
September 30
228,314.25
Fiscal Year To Date
750,620.87
Average Daily Balance
Effective Rate of Return
453,785,589.60 464,648,534.52
0.64%0.61%
Total Earnings Month Ending
This report contains all the required information in SB 866 and SB 564 and accurately reflects all pooled investments held during this reporting period on behalf of the City and the City of Santa Ana acting
on behalf of the Community Redevelopment Agency. The information reported herein is in compliance with State law and the City's Investment Policy. Based on liquidity of investments, the City of Santa
Ana is able to meet budgeted expenditure requirements for the next six months, barring any catastrophic natural disasters. Market pricings are obtained through the City's third party trust services at BNY
Mellon Trust.
__________________________________________________ ____________________
Finance & Mgmt Services Agency,
Portfolio COSA
CP
Reporting period 09/01/2021-09/30/2021
Run Date: 10/11/2021 - 17:38 PM (PRF_PM1) 7.3.0
Report Ver. 7.3.5
EXHIBIT 1
YTM/C
365
Page 1
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
September 30, 2021
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
City of Santa Ana
Days to
Maturity
YTM/C
360CUSIPInvestment #
Purchase
Date
Local Agency Investment Funds
0.206Local Agency Investment FundLAIFCITY 29,027,539.85 29,027,539.85 0.20629,027,539.85 0.203LAIFCITY 1
29,027,539.85 0.20329,027,539.8529,027,539.8572,527,539.85Subtotal and Average 0.206 1
Cash in Banks
0.206Local Agency Investment FundLAIF ARPA 63,936,641.14 63,936,641.14 0.20663,936,641.14 0.203LAIF ARPA 1
63,936,641.14 0.20363,936,641.1463,936,641.14102,974,851.17Subtotal and Average 0.206 1
Federal Agency Coupon Securities
2.670Federal Farm Credit Bank13868 925,000.00 924,195.25 10/23/20232.65001/29/2019 968,817.25 2.6343133EJ5W5 752
2.619Federal Farm Credit Bank13876 3,000,000.00 2,998,740.00 02/27/20242.61003/04/2019 3,156,030.00 2.5833133EKBW5 879
2.430Federal Farm Credit Bank13884 2,000,000.00 1,975,960.00 05/15/20232.12503/15/2019 2,061,020.00 2.3963133ECPM0 591
1.920Federal Farm Credit Bank13897 1,500,000.00 1,512,465.00 09/05/20232.12506/10/2019 1,552,245.00 1.8943133EKPG5 704
1.420Federal Farm Credit Bank13932 2,500,000.00 2,496,700.00 10/11/20221.37510/11/2019 2,532,750.00 1.4013133EKY91 375
1.606Federal Farm Credit Bank13934 5,000,000.00 5,003,650.00 10/23/20231.62510/23/2019 5,131,650.00 1.5843133EK3M6 752
0.690Federal Farm Credit Bank13974 6,000,000.00 6,000,000.00 07/22/20250.69007/22/2020 5,972,640.00 0.6813133ELX33 1,390
0.530Federal Farm Credit Bank13988 5,000,000.00 5,000,000.00 09/29/20250.53009/29/2020 4,924,300.00 0.5233133EMBH4 1,459
0.550Federal Farm Credit Bank13991 5,000,000.00 4,997,500.00 11/03/20250.54011/03/2020 4,958,550.00 0.5433133EMFR8 398
0.800Federal Farm Credit Bank14005 4,000,000.00 4,000,000.00 03/09/20260.80003/09/2021 3,979,560.00 0.7893133EMSU7 524
0.710Federal Farm Credit Bank14006 6,000,000.00 6,000,000.00 04/01/20250.71004/01/2021 5,997,360.00 0.7003133EMUP5 182
0.710Federal Farm Credit Bank14016 5,000,000.00 5,000,000.00 04/21/20250.71004/21/2021 5,001,100.00 0.7003133EMWH1 202
0.710Federal Farm Credit Bank14032 6,000,000.00 6,000,000.00 08/10/20260.71008/10/2021 5,928,900.00 0.7003133EM2C5 678
1.980Federal Home Loan Bank13825 3,175,000.00 3,170,488.33 01/10/20221.95001/11/2017 3,191,319.50 1.9533130AAKW7 101
1.815Federal Home Loan Bank13845 5,000,000.00 5,000,000.00 06/27/20221.81506/27/2017 5,062,950.00 1.7903130ABBNS1 269
2.699Federal Home Loan Bank13854 1,500,000.00 1,486,650.00 03/10/20232.50005/31/2018 1,550,340.00 2.6623130ADMX7 525
2.541Federal Home Loan Bank13873 2,000,000.00 1,996,220.00 02/13/20242.50002/27/2019 2,101,080.00 2.5063130AFW94 865
2.380Federal Home Loan Bank13889 3,000,000.00 2,999,250.00 03/08/20242.37504/29/2019 3,148,980.00 2.3483130AB3H7 889
0.580Federal Home Loan Bank13996 4,000,000.00 4,000,000.00 01/28/20260.58001/28/2021 3,960,320.00 0.5723130AKPQ3 119
0.520Federal Home Loan Bank13997 5,000,000.00 5,000,000.00 01/28/20260.52001/28/2021 4,941,500.00 0.5133130AKU53 27
0.500Federal Home Loan Bank13998 6,000,000.00 6,000,000.00 01/28/20260.50001/28/2021 5,929,980.00 0.4933130AKN69 119
0.600Federal Home Loan Bank13999 5,000,000.00 5,000,000.00 02/25/20260.60002/25/2021 4,949,300.00 0.5923130ALA53 147
0.625Federal Home Loan Bank14001 5,000,000.00 5,000,000.00 02/24/20260.62502/24/2021 4,953,100.00 0.6163130ALBM5 54
0.375Federal Home Loan Bank14002 5,000,000.00 5,000,000.00 02/25/20250.37502/25/2021 4,969,300.00 0.3703130ALB52 147
0.500Federal Home Loan Bank14003 4,000,000.00 4,000,000.00 03/10/20250.50003/10/2021 3,984,040.00 0.4933130ALDZ4 70
0.500Federal Home Loan Bank14004 4,000,000.00 4,000,000.00 09/24/20240.50003/24/2021 3,994,880.00 0.4933130ALKN3 84
0.702Federal Home Loan Bank14007 6,000,000.00 5,997,000.00 03/17/20250.65003/29/2021 5,990,700.00 0.6923130ALLP7 77
1.100Federal Home Loan Bank14008 5,000,000.00 5,000,000.00 04/22/20261.10004/22/2021 4,998,850.00 1.0853130ALW67 21
Portfolio COSA
CP
Run Date: 10/11/2021 - 17:38 PM (PRF_PM2) 7.3.0
Report Ver. 7.3.5
YTM/C
365
Page 2
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
September 30, 2021
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
City of Santa Ana
Days to
Maturity
YTM/C
360CUSIPInvestment #
Purchase
Date
Federal Agency Coupon Securities
1.050Federal Home Loan Bank14024 6,000,000.00 6,000,000.00 06/30/20261.05006/30/2021 5,988,600.00 1.0363130AMYU0 90
1.000Federal Home Loan Bank14025 6,000,000.00 6,000,000.00 03/30/20261.00006/30/2021 5,991,300.00 0.9863130AMYC0 90
0.400Federal Home Loan Bank14026 6,000,000.00 6,000,000.00 06/28/20240.40006/28/2021 5,990,880.00 0.3953130AMSF0 88
0.850Federal Home Loan Bank14027 5,000,000.00 5,000,000.00 07/29/20260.85007/29/2021 4,968,000.00 0.8383130ANFU9 301
0.875Federal Home Loan Bank14028 5,000,000.00 5,000,000.00 05/18/20260.87508/18/2021 4,985,900.00 0.8633130ANFG0 140
0.908Federal Home Loan Bank14029 5,000,000.00 5,000,000.00 07/29/20260.50007/29/2021 4,983,400.00 0.8963130ANE30 28
0.550Federal Home Loan Bank14033 5,000,000.00 5,000,000.00 12/19/20240.55008/19/2021 4,991,700.00 0.5423130ANHV5 49
0.700Federal Home Loan Bank14034 6,000,000.00 6,000,000.00 08/26/20250.70008/26/2021 5,981,280.00 0.6903130ANPE4 329
0.900Federal Home Loan Bank14035 6,000,000.00 6,000,000.00 08/27/20260.90008/27/2021 5,970,720.00 0.8883130ANQ78 514
0.820Federal Home Loan Bank14036 5,000,000.00 5,000,000.00 09/30/20260.82009/30/2021 4,948,150.00 0.8093130AP3E3 364
0.650Federal Home Loan Bank14037 5,000,000.00 5,000,000.00 06/30/20250.65009/30/2021 4,991,000.00 0.6413130ANX62 180
1.000Federal Home Loan Bank14038 5,000,000.00 5,000,000.00 09/30/20261.00009/30/2021 4,993,800.00 0.9863130APB79 364
0.855Federal Home Loan Bank14039 5,000,000.00 4,998,750.00 06/29/20260.85009/29/2021 4,975,050.00 0.8443130AP3A1 179
1.936Federal Home Loan Mortgage Co.13839 5,000,000.00 4,997,500.00 06/29/20221.92506/29/2017 5,068,350.00 1.9093134GBVA7 271
0.720Federal Home Loan Mortgage Co.13962 5,000,000.00 4,995,000.00 05/05/20250.70005/05/2020 5,002,150.00 0.7113134GVQX9 1,312
0.767Federal Home Loan Mortgage Co.13964 5,000,000.00 4,998,750.00 05/28/20250.75005/28/2020 4,994,250.00 0.7563134GVVX3 58
0.700Federal Home Loan Mortgage Co.13967 6,000,000.00 6,000,000.00 06/25/20250.70006/25/2020 5,973,180.00 0.6903134GVR26 267
0.650Federal Home Loan Mortgage Co.13968 6,000,000.00 6,000,000.00 06/30/20250.65006/30/2020 5,969,400.00 0.6413134GVT99 272
0.570Federal Home Loan Mortgage Co.13979 6,000,000.00 6,000,000.00 07/15/20240.57007/15/2020 6,001,260.00 0.5623134GV5R5 14
0.500Federal Home Loan Mortgage Co.13987 5,000,000.00 5,000,000.00 09/30/20250.50009/30/2020 4,931,350.00 0.4933134GWUE4 364
0.540Federal Home Loan Mortgage Co.13989 6,000,000.00 6,000,000.00 10/27/20250.54010/27/2020 5,922,060.00 0.5333134GW4Z6 391
0.500Federal Home Loan Mortgage Co.13995 6,000,000.00 6,000,000.00 12/30/20250.50012/30/2020 5,935,560.00 0.4933134GXJL9 90
2.689Federal Nat'l Mtg. Assoc.13850 2,000,000.00 1,971,780.00 01/19/20232.37503/28/2018 2,056,540.00 2.6533135G0T94 475
2.647Federal Nat'l Mtg. Assoc.13856 1,000,000.00 971,950.00 04/05/20221.87505/31/2018 1,009,210.00 2.6113135G0T45 186
2.702Federal Nat'l Mtg. Assoc.13857 1,000,000.00 971,400.00 10/05/20222.00005/31/2018 1,019,330.00 2.6653135G0T78 369
1.664Federal Nat'l Mtg. Assoc.13940 5,000,000.00 4,990,750.00 01/07/20251.62501/15/2020 5,169,450.00 1.6413135G0X24 1,194
1.651Federal Nat'l Mtg. Assoc.13941 5,000,000.00 4,994,000.00 10/15/20241.62501/15/2020 5,166,050.00 1.6293135G0W66 1,110
0.750Federal Nat'l Mtg. Assoc.13965 5,000,000.00 5,000,000.00 06/16/20250.75006/16/2020 4,999,250.00 0.7403136G4WV1 1,354
0.510Federal Nat'l Mtg. Assoc.13976 8,000,000.00 8,000,000.00 07/28/20250.51007/28/2020 7,960,640.00 0.5033136G4D42 665
0.650Federal Nat'l Mtg. Assoc.13977 6,000,000.00 6,000,000.00 08/14/20250.65008/14/2020 5,954,280.00 0.6413136G4C43 1,413
0.560Federal Nat'l Mtg. Assoc.13978 6,000,000.00 6,000,000.00 08/12/20250.56008/12/2020 5,966,760.00 0.5523136G4G98 315
0.530Federal Nat'l Mtg. Assoc.13990 6,000,000.00 6,000,000.00 10/28/20250.53010/28/2020 5,950,320.00 0.5233136G45Q2 392
0.625Federal Nat'l Mtg. Assoc.13992 5,000,000.00 5,000,000.00 11/25/20250.62511/25/2020 4,969,500.00 0.6163135GA4V0 420
0.600Federal Nat'l Mtg. Assoc.13993 6,000,000.00 6,000,000.00 12/17/20250.60012/17/2020 5,950,620.00 0.5923135GAAN1 77
0.650Federal Nat'l Mtg. Assoc.13994 6,000,000.00 6,000,000.00 12/10/20250.65012/10/2020 5,950,080.00 0.6413135G06J7 70
297,448,698.58 0.881297,570,931.75297,600,000.00278,283,198.58Subtotal and Average 0.894 400
Portfolio COSA
CP
Run Date: 10/11/2021 - 17:38 PM (PRF_PM2) 7.3.0
YTM/C
365
Page 3
Par Value Book Value
Stated
RateMarket Value
September 30, 2021
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
City of Santa Ana
Days to
Maturity
YTM/C
360CUSIPInvestment #
Purchase
Date
0.720453,785,589.60 390,564,180.99 0.730 305390,535,112.74 390,412,879.57Total and Average
Portfolio COSA
CP
Run Date: 10/11/2021 - 17:38 PM (PRF_PM2) 7.3.0
YTM/C
365
Page 4
Par Value Book Value
Stated
RateMarket Value
September 30, 2021
Portfolio Details - Cash
Average
BalanceIssuer
Portfolio Management
City of Santa Ana
Days to
Maturity
YTM/C
360CUSIPInvestment #
Purchase
Date
Cash in Banks
0.000CITY OF SANTA ANAPETTY CASH 90,052.99 90,052.9907/01/2021 90,052.99 0.000PETTY CASH 1
0.000JP MORGAN CHASE13943 3,961,924.00 3,961,924.0007/01/2021 3,961,924.00 0.000HOUSING 1
0.000JP MORGAN CHASE37983 2,599,346.91 2,599,346.912,599,346.91 0.000WORKERS COMPENS 1
0.000JP MORGAN CHASE38130 2,267,806.64 2,267,806.642,267,806.64 0.000GENERAL LIABILI 1
0.000JP MORGAN CHASE8695 36,584.30 36,584.3007/01/2021 36,584.30 0.000PROPERTY MANAGE 1
0.000JP MORGAN CHASEPROP MGMT 2 1,492.50 1,492.5007/01/2021 1,492.50 0.000PROPERTY MGMT 2 1
0.000JPMorgan Chase0112 349,206.59 349,206.59349,206.59 0.000HEALTHCARE SPEN 1
0.000JPMorgan Chase7962 434,485.60 434,485.60434,485.60 0.000COMMISSARY 1
0.000JPMorgan Chase9500 21,763,824.66 21,763,824.6621,763,824.66 0.000GENERAL ACCOUNT 1
0.000Santa Ana Federal Credit UnionFSS 743,905.35 743,905.35743,905.35 0.000FSS 1
0.00
0.720453,785,589.60 422,812,810.53 0.730 305
1Average Balance
422,783,742.28 422,661,509.11Total Cash and Investments
Portfolio COSA
CP
Run Date: 10/11/2021 - 17:38 PM (PRF_PM2) 7.3.0
CUSJP Investment# Issuer
Money Market Accounts
X9USDDTPC 80364 Dreyfus Treasury
X9USDDTPC 80365 Dreyfus Treasury
X9USDDEFU-80107 INSTL RES TRE AND AGNY CASH
9AMMF05B2-80406 US BANK MONEY MARKET
9AMMF05B2-80407 US BANK MONEY MARKET
SYS80418 80418 US BANK MONEY MARKET
SYS80419 80419 US BANK MONEY MARKET
SYS80421 80421 US BANK MONEY MARKET
X9USDMOR3-80243 MORGAN ST AN LEY GOVT INSTL
X9USDMOR3 80248 MORGAN ST AN LEY GOVT !NSTL
Subtotal and Average
Other
S86209710 80225 MBIA INSURANCE POLICY
981NP5PV2 80396 ASSURED GUARANTY MUNI CORP
Subtotal and Average
Cash in Bank
SYS80414 80414 SIGNATURE BANK
SYS80415 80415 CONDEMNATION DEPOSIT FUND
Subtotal and Average
Total and Average
Run Date: 10/12/2021-09:55
CASH/SECURITIES HELD IN TRUST
Portfolio Management
Portfolio Details -Investments
September 30, 2021
Par Value Market Value
10,571.46 10,571.46
1,204.24 1,204.24
19.19 19.19
0.71 0.71
1.05 1.05
41,125,871.78 41,125,871.78
105,343.76 105,343.76
5.29 5.29
108,850.82 108,850.82
1.56 1.56 --
41,351,869.86 41,351,869.86
1.00 1.00
1.00 1.00 --
2.00 2.00
1,268,869.87 1,268,869.87
1,041,525.00 1,041,525.00
2,310,394.87 2,310,394.87
43,662.266.73 43,662,266.73
Book Value
10,571.46
1,204.24
19.19
0.71
1.05
41,125,871.78
105,343.76
5.29
108,850.82
1.56
41,351,869.86
1.00
1.00
2.00
1,268,869.87
1,041,525.00
2,310,~94.87
43,662,266.73
Page 1
d Digitally signed by Alexan e Alexandecninidad
T . "d d Date,2021.10.12 r n rn a m20,11 -07'00'
Maturity
Date
Portfolio TRST
AC
PM (PRF_PM2) 7.3.0
Report Ver. 7.3.5
Quarterly Report of Investments as of September 30, 2021
Exhibit 2 - Cash held by Bank and Cash by Fund(s) Listing
Page 1 of 3
Investments Amount
Bank of New York Mellon - Investment Custodian 297,448,699
Local Agency Investment Fund (L.A.I.F)29,027,540
Local Agency Investment Fund (L.A.I.F) - ARPA 63,936,641
Total - Investments 390,412,880
Cash Held at City Financial Institution(s) and Cash on Hand Amount
General Account 21,763,825
General Liability Account 2,267,807
Housing Account 3,961,924
Workers Compensation Account 2,599,347
Santa Ana Federal Credit Union - Family Self Sufficiency (FSS-Housing) 743,905
Commissary Account 434,486
Flexible Benefit Spending Account 349,207
Property Management Account 36,584
Property Management - Phase 2 Account 1,493
Petty Cash 90,053
Total - Cash Held at City Financial Institution(s) and Cash on Hand 32,248,630
Restricted Cash Amount
Signature Bank - Streetlight Project 1,268,870
US Bank - Pension Stability Funds (Section 115 Trust with PARS)41,125,872
Bank of New York Mellon - Various 120,627
US Bank - Warner Industrial Community 105,344
State of California Condemnation Fund - Right of Way Deposits 1,041,525
US Bank - Gas Tax Bonds 30
Total - Restricted Cash 43,662,267
Total Cash Held City at Financial Institution(s), Cash on Hand and Restricted Cash 466,323,776
Cash by Fund(s) - Total (see below for listing)466,323,776
Fund Fund description Amount
011 GENERAL FUND 66,190,988
012 CANNABIS PUBLIC BENEFIT 17,264,158
016 CASP CERTIFICATION & TRAINING 265,251
020 OTS-TRAFFIC OFFENDER PROGRAM 37,708
021 PRCSA CATV FUND 1,289,728
022 PRCSA FEE & DONATION 346,505
023 INMATE WELFARE FUND 1,627,345
024 PD ATHLETIC ACTIVITIES LEAGUE (75,825)
025 IDB & EZ VOUCHER MONITORING 197,126
026 ASSET FORFEITURE FUND 135,355
027 PARKING FUND 312,133
029 SPECIAL GAS TAX 27,116,074
030 PROP 1B BOND ACT OF 2006 152,913
031 AIR QUALITY IMPR. (AB 2766)1,656,812
032 MEASURE M-STREET CONSTRUCTION (2,806,400)
033 NEW TRANSPO SYS IMPR AREA B 542,658
034 NEW TRANSPO SYS IMPR AREA E 1,540,215
035 NEW TRANSPO SYS IMPR AREA F 1,664,729
041 TRANSP SYS IMPR AREA A-2 329,920
042 TRANSPO SYS IMPR AREA B 9,529
048 TRANSPO SYS IMPR AREA C-2 212,847
049 TRANSPO SYS IMPR AREA G 98,104
051 CAPITAL OUTLAY FUND 5,153,516
053 CITY SERVICES 6,781,982
054 SANITARY SEWER CAPITAL 21,115,367
055 SEWER CONNECTION FEE 11,024,737
056 SANITARY SEWER SERVICE 7,068,207
057 FED CLEAN WATER PROTECTION ENT 4,926,781
058 RESIDENTIAL STREET IMPROVEMENT 4,565,491
059 SELECT STREET CONSTRUCTION 18,436,278
060 WATER REVENUE 46,541,062
066 ACQUISITION & CONSTRUCTION 2,069,236
067 REGIONAL TRANSP CENTER (1,653,868)
068 SANITATION FUND 7,078,054
069 REFUSE COLLECTION SERVICE 5,869,040
EXHIBIT 2
Quarterly Report of Investments as of September 30, 2021
Exhibit 2 - Cash held by Bank and Cash by Fund(s) Listing
Page 2 of 3
070 EQUIPMENT REPLACEMENT FUND 6,510,595
071 CENTRAL SERVICES (146,383)
073 BUILDING MAINT FUND 987,524
074 CIVIC CENTER MAINTENANCE (905,641)
075 FLEET MAINTENANCE/STORES 321,773
076 STORES & PROPERTY CONTROL (304,521)
078 RETIREMENT SYSTEM 982,690
080 LIABILITY AND PROPERTY INS FND 12,668,119
081 EMPLOYEE GROUP INSURANCE (1,598,917)
082 WORKERS COMPENSATION FUND 15,616,577
083 PAYROLL REVOLVING 6,611,602
085 CITY YARD OPERATION 124,826
086 PUB WKS ENG/PROJ MGMT (703,682)
087 PT RETIREMENT FUND 8,671
088 QUALITY SERVICE TRAINING 375,463
089 CA SEISMIC HAZARD PROGRAM 6,041
090 ORANGE CO SANITATION DIST 2&3 1,260,468
093 BUSINESS IMPROVEMENT DISTRICT 147,889
094 INTEREST AGENCY -
095 POLICE COMMISSARY ACCOUNT 310,657
096 SA TOURISM MARKETING DISTRICT 99,433
100 SECTION 457 FIDUCIARY ADMIN 67,141
101 PUB WKS-ADMIN & PLANNING 1,037,634
103 PMA RETIREE HEALTH INSURANCE (84,449)
104 SEIU RETIREE HEALTH INSURANCE 23,250
106 MGMT RETIREE HEALTH INSURANCE 8,201
107 UC RETIREE HEALTH INSURANCE 2,012
109 INFO SYS STRATEGIC PLAN 13,157,967
110 STRONG MOTION INSTRUMENTATION 98,108
120 FIRE FACILITIES FUND 1,608,825
121 SPECIAL REPAIR/DEMOLITION 562,433
122 EMERGENCY & HEALTH GRANTS 9,244,161
123 WORKFORCE INVESTMENT ACT (297,143)
124 ORANGE COUNTY SSA GRANTS (155,286)
125 OES UASI (443,700)
127 D.O.J. GRANT FUND (61,796)
128 POLICE BLOCK GRANTS 586,361
130 HOME PROGRAM FEDERAL GRANT 1,199,903
133 HOUSING AUTHORITY-ISSUER FEE 2,718,788
135 COMMUNITY DEV BLOCK GRANT (785,314)
136 HOUSING AUTHORITY-VOUCHER HAP 835,946
137 HOUSING AUTHORITY- MAINSTREAM -
138 HOUSING AUTHORITY-MS 5 1,144,430
139 HOUSING AUTHORITY-NEW CONSTR 141,224
140 HOUSING AUTHORITY-VOUCHER ADM 2,191,899
142 NSP FEDERAL GRANT 1,402,314
143 CALHOME MFGD HSG LOAN 627,958
144 PRISON TO EMPLOYMENT PROGRAM (338,959)
145 RENTAL REHABILITATION GRANT 394,378
147 FEDERAL AID SAFETY PROGRAM (879,756)
148 TRAFFIC SYSTEM MGMT GRANT (6,818,450)
149 WIC ASSESSMENT DIST ST IMPRV 32,654
152 PUBLIC LIBRARY GRANT FUND (324)
153 LIBRARY GRANTS 42,388
154 LIBRARY SVCS & TECHNOLOGY ACT 5,978
155 OCJP GRANT 36,355
157 HSG ADMIN CARES ACT COVID-19 5,512
158 PLANNING GRANTS PROGRAM 2,639,109
160 HSG HAP CARES ACT COVID-19 -
161 PRCSA CAPITAL GRANTS (652,515)
162 ENERGY CONSERVATION PROGRAM 86,445
164 PUB WKS-WTR QUALITY & CONTROL (1,793,071)
165 OFFICE OF SAFETY GRANT 165,472
166 US DOJ ASSET FORFEITURE FUND 1,135,559
167 US TREASURY ASSET FORFEITURE 138,969
169 RECREATION GRANTS FUND 429,364
170 MS5 HAP CARES ACT COVID-19 (1,062,375)
172 NATL RECREATION TRAILS FND ACT 17,102
175 CARES ACT - CESF -
176 CARES ACT - State -
177 EMERGENCY RENTAL ASSISTANCE PG 4,387,803
178 COVID RELIEF FUND -
179 GENERAL FIXED ASSETS 329,223
180 ARPA EHV ADMIN FEES 222,024
181 AMERICAN RESCUE PLAN ACT 63,836,280
Quarterly Report of Investments as of September 30, 2021
Exhibit 2 - Cash held by Bank and Cash by Fund(s) Listing
Page 3 of 3
201 LOCAL DRAINAGE AREA NO 1 132
202 LOCAL DRAINAGE AREA NO 2 1,426
203 LOCAL DRAINAGE AREA NO 3 753,186
204 LOCAL DRAINAGE AREA NO 4 1,053
205 LOCAL DRAINAGE AREA NO 5 598
206 LOCAL DRAINAGE AREA NO 6 878
207 LOCAL DRAINAGE AREA NO 7 193,697
209 LOCAL DRAINAGE AREA NO 9 731
210 LOCAL DRAINAGE AREA NO 10 17,128
211 LOCAL DRAINAGE AREA NO 11 222
212 LOCAL DRAINAGE AREA NO 12 13
213 LOCAL DRAINAGE AREA NO 13 2,691
221 LOCAL DRAINAGE AREA I 979,990
222 LOCAL DRAINAGE AREA II 235,108
223 LOCAL DRAINAGE AREA III 418,723
224 LOCAL DRAINAGE AREA IV 481,402
225 LOCAL DRAINAGE AREA V 256,133
226 LOCAL DRAINAGE AREA VI 216,964
301 REC/COMM SVS 5,375
311 RESIDENTIAL DEVELOP DISTRICT 1 3,232,047
312 RESIDENTIAL DEVELOP DISTRICT 2 4,182,860
313 RESIDENTIAL DEVELOP DISTRICT 3 11,228,478
314 RESIDENTIAL DEVELOP DISTRICT 4 568,229
400 POLICE UUT LEASE REVENUE BONDS 1,161,260
403 SCAG GRANTS -
404 COSA 2014 LEASE FINANCING 1,363,245
417 INCLUSIONARY HOUSING FEE 15,504,515
418 CDA - PEEBLER CAPITAL FUND 4,450,979
607 HOUSING AUTHORITY LMIHF 3,647,769
652 2003A SERIES TAX ALLOC BOND -
654 2011A SERIES TAX ALLOC BOND -
655 2018A SERIES TAX ALLOC BOND 11,768
658 2003B SERIES ALLOC BOND -
670 COSA RDA 397,821
671 COSA RDA OBLIGATION RETIREMENT 461,675
980 SAN JUANQUIN TRANS CORRIDOR -
981 EASTERN FOOTHILL TRANS CORRIDO -
991 TRAN SYS IMP AUT C-2 TUSTIN 2,168,567
992 TRAN SYS IMP AUT AREA D-TUSTIN 10,743,405
993 WIC ASSESSMENT DISTRICT 272,907
998 TREASURERS AGENCY COLLECTIONS 27,962
999 Lawson Clearing 1,693
Reconciling Item(s) - Outstanding Checks *2,014,145
Reconciling Item(s) - Bank Direct Deposits*1,008,575
Reconciling Item(s) - Deposits in Transit*470,895
Reconciling Item(s) - Withdrawals in Transit*3,486,117
Reconciling Item(s) - Various*(293,556)
Reconciling Item(s) - Various: A difference between C ash held by Financial Institution, Fiscal Agent and Cash on Hand exists when comparing to Cash by
Fund due, to reconciling items such as timing of payments; outstanding checks; and deposits in transit