HomeMy WebLinkAboutItem 10 - Periodic Quarterly Report of Investments as of December 31, 2021. Finance and Management Services
www.santa-ana.org/finance
Item # 10
City of Santa Ana
20 Civic Center Plaza, Santa Ana, CA 92701
Staff Report
February 15, 2022
TOPIC: Periodic Quarterly Report of Investments as of December 31, 2021.
AGENDA TITLE:
Receive and File Quarterly Report of Investments as of December 31, 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 and 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 January 24, 2022. 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
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 December 31, 2021.
Quarterly Report of Investments
February 15, 2022
Page 2
2
4
2
5
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 the following: (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
December 31, 2021.
Type of Investment Amounts
Invested $
Portfolio
%
COSA
Policy
Limits
%
State Law
Limits %
Certificates of Deposit (CDs)$5,208,000 1.29%30%30%
Federal Farm Credit Bank (FFCB)$51,909,210 12.88%None None
Federal Home Loan Bank (FHLB)$162,395,858 40.30%None None
Federal Home Loan Mortgage Corp. (FHLMC)$49,991,250 12.41%None None
Federal National Mortgage Association (FNMA)$61,899,880 15.36%None None
Local Agency Investment Fund (LAIF)$14,069,652 3.49%None None
Local Agency Investment Fund (LAIF – ARPA)$57,472,684 14.26%None None
Sub- Total:$402,946,534 100%None None
Cash :$45,606,721
Total:$448,553,255
Restricted Cash In $
Restricted Cash †,$3,059,372
Total $3,059,372
† 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 December 31, 2021.
Quarterly Report of Investments
February 15, 2022
Page 3
2
4
2
5
The following two tables represent, as of December 31, 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.788%
Investments Par Value of Investments YTM
% of
Portfolio
Certificates of Deposit $5,208,000 0.900%1.29%0.012%
LAIF $14,069,651.53 0.212%3.49%0.007%
LAIF (ARPA)$57,472,683.73 0.212%14.26%0.030%
Federal Agency Securities $326,196,198.58 0.912%80.95%0.738%
$402,946,534 0.788%100.00%0.788%
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.
Quarterly Report of Investments
February 15, 2022
Page 4
2
4
2
5
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
December 31, 2021
Portfolio Summary
% of
Portfolio
Book
ValueInvestmentsMarket
Value
Par
Value
Days to
MaturityTerm
YTM/C
Certificates of Deposit 5,208,000.00 1,6041.29 0.9001,5675,119,272.455,208,000.00
Local Agency Investment Funds 14,069,651.53 13.49 0.212114,069,651.5314,069,651.53
Cash in Banks 57,472,683.73 114.26 0.212157,472,683.7357,472,683.73
Federal Agency Coupon Securities 326,196,198.58 1,70980.95 0.912351323,032,051.75326,350,000.00
402,946,533.84 100.00%Investments 399,693,659.46403,100,335.26 1,404 305 0.788
Cash
(not included in yield calculations)Passbook/Checking 45,606,720.96 1 0.000145,606,720.9645,606,720.96
448,553,254.80Total Cash and Investments 445,300,380.42448,707,056.22 1,404 305 0.788
Current Year
December 31
254,499.26
Fiscal Year To Date
1,491,364.24
Average Daily Balance
Effective Rate of Return
439,900,865.03 448,996,594.50
0.66%0.68%
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 12/01/2021-12/31/2021
Run Date: 01/16/2022 - 12:14 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
December 31, 2021
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
City of Santa Ana
Days to
Maturity
YTM/C
360CUSIPInvestment #
Purchase
Date
Certificates of Deposit
0.600BANK OZK14051 248,000.00 248,000.00 05/12/20260.60011/12/2021 240,350.12 0.59206417NF73 1,592
0.700American Equity Bank14043 248,000.00 248,000.00 05/27/20260.70011/26/2021 241,355.39 0.69002568KAJ4 1,607
1.000PENTAGON FCU14050 248,000.00 248,000.00 11/10/20261.00011/10/2021 243,768.08 0.98670962LAV4 1,774
0.600LUANA SAVINGS BK14046 248,000.00 248,000.00 11/05/20260.60011/05/2021 239,087.18 0.592549104ZS9 1,769
1.100SYNCHRONY BANK14047 248,000.00 248,000.00 11/05/20261.10011/05/2021 244,964.73 1.08587165FD76 1,769
0.850CFBANK14044248,000.00 248,000.00 07/10/20260.85011/10/2021 242,692.65 0.83815721UET2 1,651
0.850FIRST FEDERAL14065 248,000.00 248,000.00 08/29/20250.85012/29/2021 244,491.17 0.83832022EAU0 1,336
0.800THIRD FEDERAL S&L14056 248,000.00 248,000.00 05/23/20250.80011/24/2021 244,581.42 0.78988413QDE5 1,238
1.000GOLDMAN SACHS14064 248,000.00 248,000.00 12/22/20251.00012/22/2021 245,259.18 0.98638149MR47 1,451
1.150ST BK INDIA NY14057 248,000.00 248,000.00 11/30/20261.15011/29/2021 245,519.85 1.134856285YQ8 1,794
1.100MERRICK BANK14049 248,000.00 248,000.00 11/09/20261.10011/09/2021 244,951.83 1.08559013KPN0 1,773
0.850FARMERS & MERCHANTS14054 248,000.00 248,000.00 11/19/20260.85011/19/2021 241,965.52 0.83830781JAW0 1,783
0.950BMW BANK OF NA14061 248,000.00 248,000.00 12/17/20240.95012/17/2021 246,545.65 0.93705580AH64 1,081
0.900INSBANK14062248,000.00 248,000.00 06/19/20260.90012/20/2021 243,367.76 0.88845776NEN2 1,630
1.250MEDALLION BK UT14063 248,000.00 248,000.00 12/21/20261.25012/20/2021 246,622.48 1.23358404DMQ1 1,815
1.100TOYOTA FINANCIAL14052 248,000.00 248,000.00 11/12/20261.10011/12/2021 244,953.30 1.08589235MMB4 1,776
0.900EMPIRE ST BK NA14045 248,000.00 248,000.00 07/13/20260.90011/12/2021 243,248.69 0.888292079AR1 1,654
0.800POPPY BANK14053 248,000.00 248,000.00 11/17/20260.80011/17/2021 241,378.77 0.78973319FBJ7 1,781
0.500FIRST GENERAL BK14048 248,000.00 248,000.00 02/05/20250.50011/05/2021 242,804.47 0.493320337EZ7 1,131
0.900GREENSTATE CU14055 248,000.00 248,000.00 11/24/20250.90011/23/2021 244,452.36 0.88839573LCC0 1,423
1.000SALLIE MAE BANK14060 248,000.00 248,000.00 12/16/20241.00012/15/2021 246,911.85 0.986795451BA0 1,080
5,208,000.00 0.8885,119,272.455,208,000.004,272,000.00Subtotal and Average 0.900 1,567
Local Agency Investment Funds
0.212Local Agency Investment FundLAIFCITY 14,069,651.53 14,069,651.53 0.21214,069,651.53 0.209LAIFCITY 1
14,069,651.53 0.20914,069,651.5314,069,651.5318,908,361.21Subtotal and Average 0.212 1
Cash in Banks
0.212Local Agency Investment FundLAIF ARPA 57,472,683.73 57,472,683.73 0.21257,472,683.73 0.209LAIF ARPA 1
57,472,683.73 0.20957,472,683.7357,472,683.7396,128,095.56Subtotal and Average 0.212 1
Federal Agency Coupon Securities
2.670Federal Farm Credit Bank13868 925,000.00 924,195.25 10/23/20232.65001/29/2019 961,620.75 2.6343133EJ5W5 660
2.619Federal Farm Credit Bank13876 3,000,000.00 2,998,740.00 02/27/20242.61003/04/2019 3,131,310.00 2.5833133EKBW5 787
2.430Federal Farm Credit Bank13884 2,000,000.00 1,975,960.00 05/15/20232.12503/15/2019 2,049,680.00 2.3963133ECPM0 499
1.920Federal Farm Credit Bank13897 1,500,000.00 1,512,465.00 09/05/20232.12506/10/2019 1,543,005.00 1.8943133EKPG5 612
Portfolio COSA
CP
Run Date: 01/16/2022 - 12:14 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
December 31, 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.420Federal Farm Credit Bank13932 2,500,000.00 2,496,700.00 10/11/20221.37510/11/2019 2,524,350.00 1.4013133EKY91 283
1.606Federal Farm Credit Bank13934 5,000,000.00 5,003,650.00 10/23/20231.62510/23/2019 5,105,950.00 1.5843133EK3M6 660
0.690Federal Farm Credit Bank13974 6,000,000.00 6,000,000.00 07/22/20250.69007/22/2020 5,903,760.00 0.6813133ELX33 1,298
0.530Federal Farm Credit Bank13988 5,000,000.00 5,000,000.00 09/29/20250.53009/29/2020 4,877,950.00 0.5233133EMBH4 1,367
0.550Federal Farm Credit Bank13991 5,000,000.00 4,997,500.00 11/03/20250.54011/03/2020 4,875,600.00 0.5433133EMFR8 306
0.800Federal Farm Credit Bank14005 4,000,000.00 4,000,000.00 03/09/20260.80003/09/2021 3,944,360.00 0.7893133EMSU7 432
0.710Federal Farm Credit Bank14006 6,000,000.00 6,000,000.00 04/01/20250.71004/01/2021 5,922,240.00 0.7003133EMUP5 90
0.710Federal Farm Credit Bank14016 5,000,000.00 5,000,000.00 04/21/20250.71004/21/2021 4,919,150.00 0.7003133EMWH1 110
0.710Federal Farm Credit Bank14032 6,000,000.00 6,000,000.00 08/10/20260.71008/10/2021 5,861,820.00 0.7003133EM2C5 586
1.980Federal Home Loan Bank13825 3,175,000.00 3,170,488.33 01/10/20221.95001/11/2017 3,176,016.00 1.9533130AAKW7 9
1.815Federal Home Loan Bank13845 5,000,000.00 5,000,000.00 06/27/20221.81506/27/2017 5,037,600.00 1.7903130ABBNS1 177
2.699Federal Home Loan Bank13854 1,500,000.00 1,486,650.00 03/10/20232.50005/31/2018 1,536,450.00 2.6623130ADMX7 433
2.541Federal Home Loan Bank13873 2,000,000.00 1,996,220.00 02/13/20242.50002/27/2019 2,072,220.00 2.5063130AFW94 773
2.380Federal Home Loan Bank13889 3,000,000.00 2,999,250.00 03/08/20242.37504/29/2019 3,100,290.00 2.3483130AB3H7 797
0.580Federal Home Loan Bank13996 4,000,000.00 4,000,000.00 01/28/20260.58001/28/2021 3,920,040.00 0.5723130AKPQ3 27
0.520Federal Home Loan Bank13997 5,000,000.00 5,000,000.00 01/28/20260.52001/28/2021 4,890,200.00 0.5133130AKU53 27
0.500Federal Home Loan Bank13998 6,000,000.00 6,000,000.00 01/28/20260.50001/28/2021 5,866,440.00 0.4933130AKN69 27
0.600Federal Home Loan Bank13999 5,000,000.00 5,000,000.00 02/25/20260.60002/25/2021 4,899,000.00 0.5923130ALA53 55
0.625Federal Home Loan Bank14001 5,000,000.00 5,000,000.00 02/24/20260.62502/24/2021 4,903,150.00 0.6163130ALBM5 54
0.375Federal Home Loan Bank14002 5,000,000.00 5,000,000.00 02/25/20250.37502/25/2021 4,889,400.00 0.3703130ALB52 55
0.500Federal Home Loan Bank14003 4,000,000.00 4,000,000.00 03/10/20250.50003/10/2021 3,926,360.00 0.4933130ALDZ4 68
0.500Federal Home Loan Bank14004 4,000,000.00 4,000,000.00 09/24/20240.50003/24/2021 3,954,200.00 0.4933130ALKN3 82
0.702Federal Home Loan Bank14007 6,000,000.00 5,997,000.00 03/17/20250.65003/29/2021 5,918,760.00 0.6923130ALLP7 75
1.100Federal Home Loan Bank14008 5,000,000.00 5,000,000.00 04/22/20261.10004/22/2021 4,971,200.00 1.0853130ALW67 21
1.050Federal Home Loan Bank14024 6,000,000.00 6,000,000.00 06/30/20261.05006/30/2021 5,941,860.00 1.0363130AMYU0 88
1.000Federal Home Loan Bank14025 6,000,000.00 6,000,000.00 03/30/20261.00006/30/2021 5,945,580.00 0.9863130AMYC0 88
0.400Federal Home Loan Bank14026 6,000,000.00 6,000,000.00 06/28/20240.40006/28/2021 5,950,440.00 0.3953130AMSF0 86
0.850Federal Home Loan Bank14027 5,000,000.00 5,000,000.00 07/29/20260.85007/29/2021 4,918,100.00 0.8383130ANFU9 209
0.875Federal Home Loan Bank14028 5,000,000.00 5,000,000.00 05/18/20260.87508/18/2021 4,925,050.00 0.8633130ANFG0 48
0.500Federal Home Loan Bank14029 5,000,000.00 5,000,000.00 07/29/20260.50007/29/2021 4,947,550.00 0.4933130ANE30 28
0.550Federal Home Loan Bank14033 5,000,000.00 5,000,000.00 12/19/20240.55008/19/2021 4,953,600.00 0.5423130ANHV5 1,083
0.700Federal Home Loan Bank14034 6,000,000.00 6,000,000.00 08/26/20250.70008/26/2021 5,897,100.00 0.6903130ANPE4 237
0.900Federal Home Loan Bank14035 6,000,000.00 6,000,000.00 08/27/20260.90008/27/2021 5,905,920.00 0.8883130ANQ78 422
0.820Federal Home Loan Bank14036 5,000,000.00 5,000,000.00 09/30/20260.82009/30/2021 4,917,200.00 0.8093130AP3E3 272
0.650Federal Home Loan Bank14037 5,000,000.00 5,000,000.00 06/30/20250.65009/30/2021 4,921,100.00 0.6413130ANX62 88
1.000Federal Home Loan Bank14038 5,000,000.00 5,000,000.00 09/30/20261.00009/30/2021 4,941,200.00 0.9863130APB79 272
Portfolio COSA
CP
Run Date: 01/16/2022 - 12:14 PM (PRF_PM2) 7.3.0
YTM/C
365
Page 3
Par Value Book Value
Maturity
Date
Stated
RateMarket Value
December 31, 2021
Portfolio Details - Investments
Average
BalanceIssuer
Portfolio Management
City of Santa Ana
Days to
Maturity
YTM/C
360CUSIPInvestment #
Purchase
Date
Federal Agency Coupon Securities
0.855Federal Home Loan Bank14039 5,000,000.00 4,998,750.00 06/29/20260.85009/29/2021 4,914,300.00 0.8443130AP3A1 87
0.950Federal Home Loan Bank14040 10,000,000.00 10,000,000.00 10/13/20260.95010/13/2021 9,852,200.00 0.9373130APB46 650
0.750Federal Home Loan Bank14041 5,000,000.00 5,000,000.00 05/23/20240.75011/23/2021 4,989,750.00 0.7403130APQC2 142
1.500Federal Home Loan Bank14042 5,000,000.00 5,000,000.00 11/23/20261.50011/23/2021 4,995,600.00 1.4793130APQB4 22
1.385Federal Home Loan Bank14058 5,000,000.00 4,997,500.00 12/01/20261.37512/14/2021 4,997,850.00 1.3663130APVC6 151
1.625Federal Home Loan Bank14059 3,750,000.00 3,750,000.00 12/30/20261.62512/30/2021 3,750,300.00 1.6033130AQAB9 88
1.936Federal Home Loan Mortgage Co.13839 5,000,000.00 4,997,500.00 06/29/20221.92506/29/2017 5,041,250.00 1.9093134GBVA7 179
0.720Federal Home Loan Mortgage Co.13962 5,000,000.00 4,995,000.00 05/05/20250.70005/05/2020 5,001,750.00 0.7113134GVQX9 1,220
0.763Federal Home Loan Mortgage Co.13964 5,000,000.00 4,998,750.00 05/28/20250.75005/28/2020 4,928,550.00 0.7523134GVVX3 58
0.700Federal Home Loan Mortgage Co.13967 6,000,000.00 6,000,000.00 06/25/20250.70006/25/2020 5,903,700.00 0.6903134GVR26 175
0.650Federal Home Loan Mortgage Co.13968 6,000,000.00 6,000,000.00 06/30/20250.65006/30/2020 5,909,880.00 0.6413134GVT99 180
0.570Federal Home Loan Mortgage Co.13979 6,000,000.00 6,000,000.00 07/15/20240.57007/15/2020 6,000,660.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,881,350.00 0.4933134GWUE4 272
0.540Federal Home Loan Mortgage Co.13989 6,000,000.00 6,000,000.00 10/27/20250.54010/27/2020 5,862,000.00 0.5333134GW4Z6 299
0.500Federal Home Loan Mortgage Co.13995 6,000,000.00 6,000,000.00 12/30/20250.50012/30/2020 5,871,840.00 0.4933134GXJL9 363
2.689Federal Nat'l Mtg. Assoc.13850 2,000,000.00 1,971,780.00 01/19/20232.37503/28/2018 2,041,080.00 2.6533135G0T94 383
2.647Federal Nat'l Mtg. Assoc.13856 1,000,000.00 971,950.00 04/05/20221.87505/31/2018 1,004,120.00 2.6113135G0T45 94
2.702Federal Nat'l Mtg. Assoc.13857 1,000,000.00 971,400.00 10/05/20222.00005/31/2018 1,012,710.00 2.6653135G0T78 277
1.664Federal Nat'l Mtg. Assoc.13940 5,000,000.00 4,990,750.00 01/07/20251.62501/15/2020 5,091,350.00 1.6413135G0X24 1,102
1.651Federal Nat'l Mtg. Assoc.13941 5,000,000.00 4,994,000.00 10/15/20241.62501/15/2020 5,094,100.00 1.6293135G0W66 1,018
0.750Federal Nat'l Mtg. Assoc.13965 5,000,000.00 5,000,000.00 06/16/20250.75006/16/2020 4,948,750.00 0.7403136G4WV1 1,262
0.510Federal Nat'l Mtg. Assoc.13976 8,000,000.00 8,000,000.00 07/28/20250.51007/28/2020 7,821,360.00 0.5033136G4D42 573
0.650Federal Nat'l Mtg. Assoc.13977 6,000,000.00 6,000,000.00 08/14/20250.65008/14/2020 5,895,240.00 0.6413136G4C43 1,321
0.560Federal Nat'l Mtg. Assoc.13978 6,000,000.00 6,000,000.00 08/12/20250.56008/12/2020 5,876,100.00 0.5523136G4G98 223
0.530Federal Nat'l Mtg. Assoc.13990 6,000,000.00 6,000,000.00 10/28/20250.53010/28/2020 5,861,040.00 0.5233136G45Q2 300
0.625Federal Nat'l Mtg. Assoc.13992 5,000,000.00 5,000,000.00 11/25/20250.62511/25/2020 4,900,900.00 0.6163135GA4V0 328
0.600Federal Nat'l Mtg. Assoc.13993 6,000,000.00 6,000,000.00 12/17/20250.60012/17/2020 5,873,820.00 0.5923135GAAN1 75
0.650Federal Nat'l Mtg. Assoc.13994 6,000,000.00 6,000,000.00 12/10/20250.65012/10/2020 5,863,680.00 0.6413135G06J7 68
326,196,198.58 0.899323,032,051.75326,350,000.00320,592,408.26Subtotal and Average 0.912 351
0.777439,900,865.03 403,100,335.26 0.788 305399,693,659.46 402,946,533.84Total and Average
Portfolio COSA
CP
Run Date: 01/16/2022 - 12:14 PM (PRF_PM2) 7.3.0
YTM/C
365
Page 4
Par Value Book Value
Stated
RateMarket Value
December 31, 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,053.00 90,053.0007/01/2021 90,053.00 0.000PETTY CASH 1
0.000JP MORGAN CHASE13943 3,584,835.07 3,584,835.0707/01/2021 3,584,835.07 0.000HOUSING 1
0.000JP MORGAN CHASE37983 1,122,829.42 1,122,829.421,122,829.42 0.000WORKERS COMPENS 1
0.000JP MORGAN CHASE38130 1,414,148.51 1,414,148.511,414,148.51 0.000GENERAL LIABILI 1
0.000JP MORGAN CHASE8695 34,084.30 34,084.3007/01/2021 34,084.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 344,349.86 344,349.86344,349.86 0.000HEALTHCARE SPEN 1
0.000JPMorgan Chase7962 472,363.64 472,363.64472,363.64 0.000COMMISSARY 1
0.000JPMorgan Chase9500 37,782,622.22 37,782,622.2237,782,622.22 0.000GENERAL ACCOUNT 1
0.000Santa Ana Federal Credit UnionFSS 759,942.44 759,942.44759,942.44 0.000FSS 1
0.00
0.777439,900,865.03 448,707,056.22 0.788 305
1Average Balance
445,300,380.42 448,553,254.80Total Cash and Investments
Portfolio COSA
CP
Run Date: 01/16/2022 - 12:14 PM (PRF_PM2) 7.3.0
CUSIP Investment# Issuer
Money Market Accounts
X9USDDTPC 80364 Dreyfus Treasury
X9USDDTPC 80365 Dreyfus Treasury
X9USDDEFU-80107 INSTL RES TRE AND AGNY CASH
9AMMF0582-80406 US BANK MONEY MARKET
9AMMF0582-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 STANLEY GOVT INSTL
XSUSDMOR3 80248 MORGAN STANLEY GOVT INSTL
Subtotal and Average
Other
S86209710 80225 MBIA INSURANCE POLICY
98INP5PV2 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: 01/1312022-08:42
CASH/SECURITIES HELD IN TRUST
Portfolio Management
Portfolio Details • Investments
December 31, 2021
Par Value Market Value
10,571.46 10,571.46
1,204.38 1,204.38
19.19 19.19
0.71 0.71
1.05 1.05
522,967.96 522,967.96
105,345.07 105,345.07
5.30 5.30
108,858.10 108,858-10
1.56 1.56
748,974.78 748,974.78
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
3,059,371.65 3,059,371.65
Book Value
10,571.46
1,204.38
19.19
0.71
1.05
522,967.96
105,345.07
5.30
108,858.10
1.56
748,974.78
1.00
1.00
2.00
1,268,869.87
1,041,525.00
2,310,394.87
3,059,371.65
Page 1
d Digitally signed by Alexan er AlexanderTrinidad
Trinidad Date_: 2022.01.14
17:06:44--08'00'
Maturity
Date
Portfolio TRST
AC
PM (PRF _PM2) 7.3.0
Report Ver. 7.3.5
Quarterly Report of Investments as of December 31, 2021
Exhibit 2 - Cash held by Bank and Cash by Fund(s) Listing
Page 1 of 3
Investments Amount
Certificates of Deposit 5,208,000
Bank of New York Mellon - Investment Custodian 326,196,199
Local Agency Investment Fund (L.A.I.F)14,069,652
Local Agency Investment Fund (L.A.I.F) - ARPA 57,472,684
Total - Investments 402,946,534
Cash Held at City Financial Institution(s) and Cash on Hand Amount
General Account 37,782,622
General Liability Account 1,414,149
Housing Account 3,584,835
Workers Compensation Account 1,122,829
Santa Ana Federal Credit Union - Family Self Sufficiency (FSS-Housing) 759,942
Commissary Account 472,364
Flexible Benefit Spending Account 344,350
Property Management Account 34,084
Property Management - Phase 2 Account 1,493
Petty Cash 90,053
Total - Cash Held at City Financial Institution(s) and Cash on Hand 45,606,721
Restricted Cash Amount
Signature Bank - Streetlight Project 1,268,870
US Bank - Pension Stability Funds (Section 115 Trust with PARS)522,968
Bank of New York Mellon - Various 120,634
US Bank - Warner Industrial Community 105,345
State of California Condemnation Fund - Right of Way Deposits 1,041,525
US Bank - Gas Tax Bonds 30
Total - Restricted Cash 3,059,372
Total Cash Held City at Financial Institution(s), Cash on Hand and Restricted Cash 451,612,626
Cash by Fund(s) - Total (see below for listing)451,612,626
Fund Fund description Amount
011 GENERAL FUND 49,269,855
012 CANNABIS PUBLIC BENEFIT 19,805,868
016 CASP CERTIFICATION & TRAINING 294,592
020 OTS-TRAFFIC OFFENDER PROGRAM 38,579
021 PRCSA CATV FUND 1,317,107
022 PRCSA FEE & DONATION 941,716
023 INMATE WELFARE FUND 1,722,824
024 PD ATHLETIC ACTIVITIES LEAGUE (116,016)
025 IDB & EZ VOUCHER MONITORING 477,024
026 ASSET FORFEITURE FUND 135,463
027 PARKING FUND 404,883
029 SPECIAL GAS TAX 27,637,193
030 PROP 1B BOND ACT OF 2006 153,148
031 AIR QUALITY IMPR. (AB 2766)1,574,871
032 MEASURE M-STREET CONSTRUCTION (5,712,965)
033 NEW TRANSPO SYS IMPR AREA B 572,636
034 NEW TRANSPO SYS IMPR AREA E 1,537,420
035 NEW TRANSPO SYS IMPR AREA F 1,807,604
041 TRANSP SYS IMPR AREA A-2 697,039
042 TRANSPO SYS IMPR AREA B 9,544
048 TRANSPO SYS IMPR AREA C-2 213,173
049 TRANSPO SYS IMPR AREA G 98,255
051 CAPITAL OUTLAY FUND 4,582,962
053 CITY SERVICES 6,858,153
054 SANITARY SEWER CAPITAL 18,977,190
055 SEWER CONNECTION FEE 9,762,022
056 SANITARY SEWER SERVICE 6,924,590
057 FED CLEAN WATER PROTECTION ENT 4,891,213
058 RESIDENTIAL STREET IMPROVEMENT 4,846,292
059 SELECT STREET CONSTRUCTION 17,862,843
060 WATER REVENUE 49,372,731
066 ACQUISITION & CONSTRUCTION 2,525,173
067 REGIONAL TRANSP CENTER (1,683,955)
EXHIBIT 2
Quarterly Report of Investments as of December 31, 2021
Exhibit 2 - Cash held by Bank and Cash by Fund(s) Listing
Page 2 of 3
068 SANITATION FUND 7,170,809
069 REFUSE COLLECTION SERVICE 5,702,550
070 EQUIPMENT REPLACEMENT FUND 7,211,538
071 CENTRAL SERVICES (221,692)
073 BUILDING MAINT FUND 475,025
074 CIVIC CENTER MAINTENANCE (730,562)
075 FLEET MAINTENANCE/STORES (597,297)
076 STORES & PROPERTY CONTROL (344,690)
078 RETIREMENT SYSTEM 1,861,278
080 LIABILITY AND PROPERTY INS FND 13,864,633
081 EMPLOYEE GROUP INSURANCE (1,865,873)
082 WORKERS COMPENSATION FUND 15,693,846
083 PAYROLL REVOLVING 7,457,251
085 CITY YARD OPERATION 129,710
086 PUB WKS ENG/PROJ MGMT (694,245)
087 PT RETIREMENT FUND 7,598
088 QUALITY SERVICE TRAINING 375,463
089 CA SEISMIC HAZARD PROGRAM 48,727
090 ORANGE CO SANITATION DIST 2&3 1,200,858
093 BUSINESS IMPROVEMENT DISTRICT 130,887
094 INTEREST AGENCY -
095 POLICE COMMISSARY ACCOUNT 419,069
096 SA TOURISM MARKETING DISTRICT 103,846
100 SECTION 457 FIDUCIARY ADMIN 77,034
101 PUB WKS-ADMIN & PLANNING (1,203,175)
103 PMA RETIREE HEALTH INSURANCE (455,634)
104 SEIU RETIREE HEALTH INSURANCE 34,602
106 MGMT RETIREE HEALTH INSURANCE 5,366
107 UC RETIREE HEALTH INSURANCE 1,824
109 INFO SYS STRATEGIC PLAN 12,709,643
110 STRONG MOTION INSTRUMENTATION 100,614
120 FIRE FACILITIES FUND 2,031,056
121 SPECIAL REPAIR/DEMOLITION 614,754
122 EMERGENCY & HEALTH GRANTS 5,385,916
123 WORKFORCE INVESTMENT ACT (922,220)
124 ORANGE COUNTY SSA GRANTS (110,824)
125 OES UASI (838,500)
127 D.O.J. GRANT FUND (318,491)
128 POLICE BLOCK GRANTS 990,478
130 HOME PROGRAM FEDERAL GRANT 1,422,260
133 HOUSING AUTHORITY-ISSUER FEE 2,737,138
135 COMMUNITY DEV BLOCK GRANT (956,133)
136 HOUSING AUTHORITY-VOUCHER HAP 852,814
137 HOUSING AUTHORITY- MAINSTREAM -
138 HOUSING AUTHORITY-MS 5 1,079,682
139 HOUSING AUTHORITY-NEW CONSTR 134,169
140 HOUSING AUTHORITY-VOUCHER ADM 1,911,780
142 NSP FEDERAL GRANT 1,400,911
143 CALHOME MFGD HSG LOAN 648,944
144 PRISON TO EMPLOYMENT PROGRAM (598,772)
145 RENTAL REHABILITATION GRANT 394,983
147 FEDERAL AID SAFETY PROGRAM (913,887)
148 TRAFFIC SYSTEM MGMT GRANT (7,566,154)
149 WIC ASSESSMENT DIST ST IMPRV 32,704
152 PUBLIC LIBRARY GRANT FUND (2,783)
153 LIBRARY GRANTS 42,388
154 LIBRARY SVCS & TECHNOLOGY ACT 1,375
155 OCJP GRANT 36,355
157 HSG ADMIN CARES ACT COVID-19 544
158 PLANNING GRANTS PROGRAM 2,554,402
160 HSG HAP CARES ACT COVID-19 -
161 PRCSA CAPITAL GRANTS (879,956)
162 ENERGY CONSERVATION PROGRAM 86,445
164 PUB WKS-WTR QUALITY & CONTROL (1,811,557)
165 OFFICE OF SAFETY GRANT 203,781
166 US DOJ ASSET FORFEITURE FUND 1,137,303
167 US TREASURY ASSET FORFEITURE 139,182
169 RECREATION GRANTS FUND 432,243
170 MS5 HAP CARES ACT COVID-19 (1,062,375)
172 NATL RECREATION TRAILS FND ACT 17,129
175 CARES ACT - CESF -
176 CARES ACT - State -
177 EMERGENCY RENTAL ASSISTANCE PG 6,357,195
178 COVID RELIEF FUND -
Quarterly Report of Investments as of December 31, 2021
Exhibit 2 - Cash held by Bank and Cash by Fund(s) Listing
Page 3 of 3
179 GENERAL FIXED ASSETS 548,705
180 ARPA EHV ADMIN FEES 215,808
181 AMERICAN RESCUE PLAN ACT 57,041,456
201 LOCAL DRAINAGE AREA NO 1 132
202 LOCAL DRAINAGE AREA NO 2 1,428
203 LOCAL DRAINAGE AREA NO 3 754,343
204 LOCAL DRAINAGE AREA NO 4 1,055
205 LOCAL DRAINAGE AREA NO 5 599
206 LOCAL DRAINAGE AREA NO 6 879
207 LOCAL DRAINAGE AREA NO 7 193,995
209 LOCAL DRAINAGE AREA NO 9 732
210 LOCAL DRAINAGE AREA NO 10 17,154
211 LOCAL DRAINAGE AREA NO 11 222
212 LOCAL DRAINAGE AREA NO 12 13
213 LOCAL DRAINAGE AREA NO 13 2,695
221 LOCAL DRAINAGE AREA I 987,323
222 LOCAL DRAINAGE AREA II 240,056
223 LOCAL DRAINAGE AREA III 419,366
224 LOCAL DRAINAGE AREA IV 465,708
225 LOCAL DRAINAGE AREA V 264,296
226 LOCAL DRAINAGE AREA VI 217,298
301 REC/COMM SVS 6,036
311 RESIDENTIAL DEVELOP DISTRICT 1 3,035,920
312 RESIDENTIAL DEVELOP DISTRICT 2 6,199,774
313 RESIDENTIAL DEVELOP DISTRICT 3 11,203,895
314 RESIDENTIAL DEVELOP DISTRICT 4 582,263
400 POLICE UUT LEASE REVENUE BONDS 1,933,289
403 SCAG GRANTS -
404 COSA 2014 LEASE FINANCING 1,781,272
417 INCLUSIONARY HOUSING FEE 16,519,602
418 CDA - PEEBLER CAPITAL FUND 3,993,037
607 HOUSING AUTHORITY LMIHF 4,761,168
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 369,738
671 COSA RDA OBLIGATION RETIREMENT 409,135
980 SAN JUANQUIN TRANS CORRIDOR -
981 EASTERN FOOTHILL TRANS CORRIDO -
991 TRAN SYS IMP AUT C-2 TUSTIN 2,171,898
992 TRAN SYS IMP AUT AREA D-TUSTIN 10,752,257
993 WIC ASSESSMENT DISTRICT 340,098
998 TREASURERS AGENCY COLLECTIONS 28,362
999 Lawson Clearing 2,035
Reconciling Item(s) - Outstanding Checks *2,719,108
Reconciling Item(s) - Bank Direct Deposits*11,281,824
Reconciling Item(s) - Deposits in Transit*209,726
Reconciling Item(s) - Withdrawals in Transit*-
Reconciling Item(s) - Various*794,847
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