HomeMy WebLinkAboutItem 11 - Quarterly Report of Investments Finance and Management Services
www.santa-ana.org/finance
Item # 11
City of Santa Ana
20 Civic Center Plaza, Santa Ana, CA 92701
Staff Report
August 17, 2021
TOPIC: Quarterly Report of Investments
AGENDA TITLE:
Receive and File Quarterly Report of Investments as of June 30, 2021
RECOMMENDED ACTION
Receive and file quarterly report of investments as of June 30, 2021.
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 July 26, 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
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 June 30, 2021.
Quarterly Report of Investments
August 17, 2021
Page 2
1
9
5
0
The attached Cash held by Bank and Cash held by Fund(s) Listing (Exhibit 2) is a new
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 June 30, 2021.
Type of Investment Amounts
Invested $
Portfolio
%
COSA
Policy
Limits
%
State Law
Limits %
Federal Farm Credit Bank (FFCB)$45,909,210 11.57%None None
Federal Home Loan Bank (FHLB)$86,649,608 21.83%None None
Federal Home Loan Mortgage Corp. (FHLMC)$52,991,250 13.35%None None
Federal National Mortgage Association (FNMA)$72,201,540 18.19%None None
Local Agency Investment Fund (LAIF)$74,966,332 18.89%None None
Local Agency Investment Fund (LAIF – ARPA)$64,180,407 16.17%None None
Sub- Total:$396,898,348 100%None None
Cash :$80,921,738
Total:$477,820,086
Restricted Cash In $
Restricted Cash †,$3,057,956
Total $3,057,956
† 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 June 30, 2021.
Federal Farm Credit
Bank (FFCB)
12%
Federal Home Loan
Bank (FHLB)
22%
Federal Home Loan
Mortgage Corp.
(FHLMC)
13%
Federal National
Mortgage
Association (FNMA)
18%
Local Agency
Investment Fund
(LAIF)
19%
Local Agency
Investment Fund
(LAIF ARPA)
16%
City of Santa Ana
Investment Portfolio
June 30, 2021
Quarterly Report of Investments
August 17, 2021
Page 3
1
9
5
0
The following two tables represent, as of June 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.698%
Investments Par Value of Investments YTM
% of
Portfolio
LAIF $74,966,332 0.262%18.89%0.049%
LAIF (ARPA)$64,180,407 0.262%16.17%0.042%
Federal Agency Securities $257,751,609 0.933%64.94%0.606%
$396,898,348 0.698%100.00%0.698%
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
June 30, 2021
Portfolio Summary
% of
Portfolio
Book
ValueInvestmentsMarket
Value
Par
Value
Days to
MaturityTerm
YTM/C
Local Agency Investment Funds 74,966,332.00 118.89 0.262174,966,332.0074,966,332.00
Cash in Banks 64,180,406.50 116.17 0.262164,180,406.5064,180,406.50
Federal Agency Coupon Securities 257,751,608.58 1,71064.94 0.933401258,240,382.50258,000,000.00
396,898,347.08 100.00%Investments 397,387,121.00397,146,738.50 1,111 261 0.698
Cash
(not included in yield calculations)Passbook/Checking 80,921,738.03 1 0.000180,921,738.0380,921,738.03
477,820,085.11Total Cash and Investments 478,308,859.03478,068,476.53 1,111 261 0.698
Current Year
June 30
219,006.56
Fiscal Year To Date
3,001,995.54 3,001,995.54
Fiscal Year Ending
Average Daily Balance
Effective Rate of Return
475,483,356.73 368,705,425.63
0.81%0.56%
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 06/01/2021-06/30/2021
Run Date: 07/22/2021 - 14:08 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
June 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.262Local Agency Investment FundLAIFCITY 74,966,332.00 74,966,332.00 0.26274,966,332.00 0.258LAIFCITY 1
74,966,332.00 0.25874,966,332.0074,966,332.0074,966,332.00Subtotal and Average 0.262 1
Cash in Banks
0.262Local Agency Investment FundLAIF ARPA 64,180,406.50 64,180,406.50 0.26205/01/2021 64,180,406.50 0.258LAIF ARPA 1
64,180,406.50 0.25864,180,406.5064,180,406.50151,298,749.49Subtotal and Average 0.262 1
Federal Agency Coupon Securities
2.670Federal Farm Credit Bank13868 925,000.00 924,195.25 10/23/20232.65001/29/2019 974,191.50 2.6343133EJ5W5 844
2.619Federal Farm Credit Bank13876 3,000,000.00 2,998,740.00 02/27/20242.61003/04/2019 3,175,170.00 2.5833133EKBW5 971
2.430Federal Farm Credit Bank13884 2,000,000.00 1,975,960.00 05/15/20232.12503/15/2019 2,070,060.00 2.3963133ECPM0 683
1.920Federal Farm Credit Bank13897 1,500,000.00 1,512,465.00 09/05/20232.12506/10/2019 1,558,905.00 1.8943133EKPG5 796
1.420Federal Farm Credit Bank13932 2,500,000.00 2,496,700.00 10/11/20221.37510/11/2019 2,539,650.00 1.4013133EKY91 467
1.606Federal Farm Credit Bank13934 5,000,000.00 5,003,650.00 10/23/20231.62510/23/2019 5,148,000.00 1.5843133EK3M6 844
0.690Federal Farm Credit Bank13974 6,000,000.00 6,000,000.00 07/22/20250.69007/22/2020 5,989,800.00 0.6813133ELX33 21
0.530Federal Farm Credit Bank13988 5,000,000.00 5,000,000.00 09/29/20250.53009/29/2020 4,952,750.00 0.5233133EMBH4 90
0.550Federal Farm Credit Bank13991 5,000,000.00 4,997,500.00 11/03/20250.54011/03/2020 4,916,050.00 0.5433133EMFR8 490
0.800Federal Farm Credit Bank14005 4,000,000.00 4,000,000.00 03/09/20260.80003/09/2021 3,976,080.00 0.7893133EMSU7 616
0.710Federal Farm Credit Bank14006 6,000,000.00 6,000,000.00 04/01/20250.71004/01/2021 6,001,920.00 0.7003133EMUP5 274
0.710Federal Farm Credit Bank14016 5,000,000.00 5,000,000.00 04/21/20250.71004/21/2021 4,988,450.00 0.7003133EMWH1 294
1.980Federal Home Loan Bank13825 3,175,000.00 3,170,488.33 01/10/20221.95001/11/2017 3,206,115.00 1.9533130AAKW7 193
1.815Federal Home Loan Bank13845 5,000,000.00 5,000,000.00 06/27/20221.81506/27/2017 5,081,550.00 1.7903130ABBNS1 361
2.699Federal Home Loan Bank13854 1,500,000.00 1,486,650.00 03/10/20232.50005/31/2018 1,557,915.00 2.6623130ADMX7 617
2.541Federal Home Loan Bank13873 2,000,000.00 1,996,220.00 02/13/20242.50002/27/2019 2,112,720.00 2.5063130AFW94 957
2.380Federal Home Loan Bank13889 3,000,000.00 2,999,250.00 03/08/20242.37504/29/2019 3,164,700.00 2.3483130AB3H7 981
0.580Federal Home Loan Bank13996 4,000,000.00 4,000,000.00 01/28/20260.58001/28/2021 3,944,320.00 0.5723130AKPQ3 211
0.520Federal Home Loan Bank13997 5,000,000.00 5,000,000.00 01/28/20260.52001/28/2021 4,920,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,910,660.00 0.4933130AKN69 211
0.600Federal Home Loan Bank13999 5,000,000.00 5,000,000.00 02/25/20260.60002/25/2021 4,941,150.00 0.5923130ALA53 239
0.625Federal Home Loan Bank14001 5,000,000.00 5,000,000.00 02/24/20260.62502/24/2021 4,952,250.00 0.6163130ALBM5 54
0.375Federal Home Loan Bank14002 5,000,000.00 5,000,000.00 02/25/20250.37502/25/2021 4,948,350.00 0.3703130ALB52 239
0.500Federal Home Loan Bank14003 4,000,000.00 4,000,000.00 03/10/20250.50003/10/2021 3,986,440.00 0.4933130ALDZ4 71
0.500Federal Home Loan Bank14004 4,000,000.00 4,000,000.00 09/24/20240.50003/24/2021 3,985,400.00 0.4933130ALKN3 85
0.757Federal Home Loan Bank14007 6,000,000.00 5,997,000.00 03/17/20250.65003/29/2021 5,977,980.00 0.7473130ALLP7 78
1.100Federal Home Loan Bank14008 5,000,000.00 5,000,000.00 04/22/20261.10004/22/2021 5,000,850.00 1.0853130ALW67 113
1.100Federal Home Loan Bank14017 5,000,000.00 5,000,000.00 04/30/20261.10004/30/2021 4,993,600.00 1.0853130AM5V0 29
Portfolio COSA
CP
Run Date: 07/22/2021 - 14:08 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
June 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,995,440.00 1.0363130AMYU0 182
1.000Federal Home Loan Bank14025 6,000,000.00 6,000,000.00 03/30/20261.00006/30/2021 6,000,420.00 0.9863130AMYC0 91
0.400Federal Home Loan Bank14026 6,000,000.00 6,000,000.00 06/28/20240.40006/28/2021 5,985,360.00 0.3953130AMSF0 89
1.936Federal Home Loan Mortgage Co.13839 5,000,000.00 4,997,500.00 06/29/20221.92506/29/2017 5,087,150.00 1.9093134GBVA7 363
1.800Federal Home Loan Mortgage Co.13938 3,000,000.00 3,000,000.00 01/16/20251.80001/16/2020 3,001,410.00 1.7753134GUS92 15
0.720Federal Home Loan Mortgage Co.13962 5,000,000.00 4,995,000.00 05/05/20250.70005/05/2020 4,979,000.00 0.7113134GVQX9 1,404
0.767Federal Home Loan Mortgage Co.13964 5,000,000.00 4,998,750.00 05/28/20250.75005/28/2020 5,000,700.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,900.00 0.6903134GVR26 359
0.650Federal Home Loan Mortgage Co.13968 6,000,000.00 6,000,000.00 06/30/20250.65006/30/2020 5,979,240.00 0.6413134GVT99 364
0.570Federal Home Loan Mortgage Co.13979 6,000,000.00 6,000,000.00 07/15/20240.57007/15/2020 5,996,640.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,932,400.00 0.4933134GWUE4 456
0.540Federal Home Loan Mortgage Co.13989 6,000,000.00 6,000,000.00 10/27/20250.54010/27/2020 5,926,320.00 0.5333134GW4Z6 483
0.500Federal Home Loan Mortgage Co.13995 6,000,000.00 6,000,000.00 12/30/20250.50012/30/2020 5,911,800.00 0.4933134GXJL9 182
1.742Federal Nat'l Mtg. Assoc.13820 4,400,000.00 4,301,660.00 08/17/20211.25011/18/2016 4,406,556.00 1.7193135G0N82 47
2.689Federal Nat'l Mtg. Assoc.13850 2,000,000.00 1,971,780.00 01/19/20232.37503/28/2018 2,067,420.00 2.6533135G0T94 567
2.647Federal Nat'l Mtg. Assoc.13856 1,000,000.00 971,950.00 04/05/20221.87505/31/2018 1,013,690.00 2.6113135G0T45 278
2.702Federal Nat'l Mtg. Assoc.13857 1,000,000.00 971,400.00 10/05/20222.00005/31/2018 1,022,950.00 2.6653135G0T78 461
1.664Federal Nat'l Mtg. Assoc.13940 5,000,000.00 4,990,750.00 01/07/20251.62501/15/2020 5,178,150.00 1.6413135G0X24 1,286
1.651Federal Nat'l Mtg. Assoc.13941 5,000,000.00 4,994,000.00 10/15/20241.62501/15/2020 5,179,500.00 1.6293135G0W66 1,202
0.750Federal Nat'l Mtg. Assoc.13965 5,000,000.00 5,000,000.00 06/16/20250.75006/16/2020 5,001,300.00 0.7403136G4WV1 1,446
0.410Federal Nat'l Mtg. Assoc.13971 6,000,000.00 6,000,000.00 07/13/20230.41007/13/2020 6,000,000.00 0.4043136G4YW7 12
0.510Federal Nat'l Mtg. Assoc.13976 8,000,000.00 8,000,000.00 07/28/20250.51007/28/2020 7,917,200.00 0.5033136G4D42 757
0.650Federal Nat'l Mtg. Assoc.13977 6,000,000.00 6,000,000.00 08/14/20250.65008/14/2020 5,972,460.00 0.6413136G4C43 1,505
0.560Federal Nat'l Mtg. Assoc.13978 6,000,000.00 6,000,000.00 08/12/20250.56008/12/2020 5,960,640.00 0.5523136G4G98 407
0.530Federal Nat'l Mtg. Assoc.13990 6,000,000.00 6,000,000.00 10/28/20250.53010/28/2020 5,930,040.00 0.5233136G45Q2 484
0.625Federal Nat'l Mtg. Assoc.13992 5,000,000.00 5,000,000.00 11/25/20250.62511/25/2020 4,957,250.00 0.6163135GA4V0 512
0.600Federal Nat'l Mtg. Assoc.13993 6,000,000.00 6,000,000.00 12/17/20250.60012/17/2020 5,937,540.00 0.5923135GAAN1 169
0.650Federal Nat'l Mtg. Assoc.13994 6,000,000.00 6,000,000.00 12/10/20250.65012/10/2020 5,950,380.00 0.6413135G06J7 71
257,751,608.58 0.921258,240,382.50258,000,000.00249,218,275.25Subtotal and Average 0.933 401
0.688475,483,356.73 397,146,738.50 0.698 261397,387,121.00 396,898,347.08Total and Average
Portfolio COSA
CP
Run Date: 07/22/2021 - 14:08 PM (PRF_PM2) 7.3.0
YTM/C
365
Page 3
Par Value Book Value
Stated
RateMarket Value
June 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,072.99 90,072.9903/01/2021 90,072.99 0.000PETTY CASH 1
0.000JP MORGAN CHASE13943 2,631,381.57 2,631,381.5707/01/2020 2,631,381.57 0.000HOUSING 1
0.000JP MORGAN CHASE37983 2,384,761.32 2,384,761.322,384,761.32 0.000WORKERS COMPENS 1
0.000JP MORGAN CHASE38130 4,547,073.91 4,547,073.914,547,073.91 0.000GENERAL LIABILI 1
0.000JP MORGAN CHASE8695 45,948.40 45,948.4007/01/2020 45,948.40 0.000PROPERTY MANAGE 1
0.000JP MORGAN CHASEPROP MGMT 2 3,542.50 3,542.5003/01/2021 3,542.50 0.000PROPERTY MGMT 2 1
0.000JPMorgan Chase0112 322,810.74 322,810.74322,810.74 0.000HEALTHCARE SPEN 1
0.000JPMorgan Chase7962 385,870.66 385,870.66385,870.66 0.000COMMISSARY 1
0.000JPMorgan Chase9500 69,757,975.94 69,757,975.9469,757,975.94 0.000GENERAL ACCOUNT 1
0.000Santa Ana Federal Credit UnionFSS 752,300.00 752,300.00752,300.00 0.000FSS 1
0.00
0.688475,483,356.73 478,068,476.53 0.698 261
1Average Balance
478,308,859.03 477,820,085.11Total Cash and Investments
Portfolio COSA
CP
Run Date: 07/22/2021 - 14:08 PM (PRF_PM2) 7.3.0
CUSIP Investment# Issuer
Money Market Accounts
X9USDDTPC 80364 Dreyfus Treasury
X9USDDTPC 80365 Dreyfus Treasury
9AMMF05B2-80406 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 lNSTL
X9USDMOR3 80248 MORGAN STANLEY GOVT JNSTL
Subtotal and Average
Other
$86209710 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: 07/14/2021 -14:44
CASH/SECURITIES HELD IN TRUST
Portfolio Management
Portfolio Details -Investments
June 30, 2021
Par Value Market Value
10,571.48 10,571.48
1,196.99 1,196.99
0.71 0.71
521,499.37 521,499.37
105,347.70 105,347.70
0.01 0.01
108,843.46 108,843.46
0.60 0.60
747,460.32 747,460.32
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,057,857.19 3,057,857.19
Book Value
10,571.48
1,196.99
0.71
521,499.37
105,347.70
0.01
108,843.46
0.60
747,460.32
1.00
1.00
2.00
1,268,869.87
1,041,525.00
2,310,394.87
3,057,857.19
Page 1
d Digitally signed by Alexan e AlexanderTrinidad
T . "d d Date:2021.07.14 r nn1 a 16:34:36-01·00·
Portfolio TRST
AC
PM (PRF_PM2} 7.3.0
Report Ver. 7.3.5
EXHIBIT 1
Quarterly Report of Investments as of June 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 257,751,609
Local Agency Investment Fund (L.A.I.F)74,966,332
Local Agency Investment Fund (L.A.I.F) - ARPA 64,180,407
Total - Investments 396,898,348
Cash Held at City Financial Institution(s) and Cash on Hand Amount
General Account 69,757,976
General Liability Account 4,547,074
Housing Account 2,631,382
Workers Compensation Account 2,384,761
Santa Ana Federal Credit Union - Family Self Sufficiency (FSS-Housing) 752,300
Commissary Account 385,871
Flexible Benefit Spending Account 322,811
Property Management Account 45,948
Property Management - Phase 2 Account 3,543
Petty Cash 90,073
Total - Cash Held at City Financial Institution(s) and Cash on Hand 80,921,738
Restricted Cash Amount
Signature Bank - Streetlight Project 1,268,870
US Bank - Pension Stability Funds (Section 115 Trust with PARS)521,499
Bank of New York Mellon - Various 108,843
US Bank - Warner Industrial Community 105,347
State of California Condemnation Fund - Right of Way Deposits 1,041,525
US Bank - Gas Tax Bonds 11,772
Total - Restricted Cash 3,057,857
Total Cash Held City at Financial Institution(s), Cash on Hand and Restricted Cash 480,877,943
Cash by Fund(s) - Total (see below for listing)480,877,943
Fund Fund description Amount
011 GENERAL FUND 77,204,717
012 CANNABIS PUBLIC BENEFIT 14,554,130
016 CASP CERTIFICATION & TRAINING 258,556
020 OTS-TRAFFIC OFFENDER PROGRAM 39,924
021 PRCSA CATV FUND 1,248,317
022 PRCSA FEE & DONATION 472,059
023 INMATE WELFARE FUND 1,440,091
024 PD ATHLETIC ACTIVITIES LEAGUE (23,051)
025 IDB & EZ VOUCHER MONITORING 320,842
026 ASSET FORFEITURE FUND 135,183
027 PARKING FUND 5,263
029 SPECIAL GAS TAX 25,613,322
030 PROP 1B BOND ACT OF 2006 152,540
031 AIR QUALITY IMPR. (AB 2766)1,505,984
032 MEASURE M-STREET CONSTRUCTION (1,928,278)
033 NEW TRANSPO SYS IMPR AREA B 541,336
034 NEW TRANSPO SYS IMPR AREA E 1,537,855
035 NEW TRANSPO SYS IMPR AREA F 1,589,409
041 TRANSP SYS IMPR AREA A-2 329,116
042 TRANSPO SYS IMPR AREA B 9,506
048 TRANSPO SYS IMPR AREA C-2 212,328
049 TRANSPO SYS IMPR AREA G 97,865
051 CAPITAL OUTLAY FUND 5,047,103
053 CITY SERVICES 7,388,303
054 SANITARY SEWER CAPITAL 22,367,356
055 SEWER CONNECTION FEE 11,231,005
056 SANITARY SEWER SERVICE 7,050,583
057 FED CLEAN WATER PROTECTION ENT 4,686,368
058 RESIDENTIAL STREET IMPROVEMENT 4,397,821
EXHIBIT 2
Quarterly Report of Investments as of June 30, 2021
Exhibit 2 - Cash held by Bank and Cash by Fund(s) Listing
Page 2 of 3
059 SELECT STREET CONSTRUCTION 19,282,167
060 WATER REVENUE 46,712,989
066 ACQUISITION & CONSTRUCTION 2,315,635
067 REGIONAL TRANSP CENTER (1,728,318)
068 SANITATION FUND 7,044,164
069 REFUSE COLLECTION SERVICE 5,615,963
070 EQUIPMENT REPLACEMENT FUND 6,494,638
071 CENTRAL SERVICES (99,658)
073 BUILDING MAINT FUND 1,135,685
074 CIVIC CENTER MAINTENANCE (425,697)
075 FLEET MAINTENANCE/STORES 975,417
076 STORES & PROPERTY CONTROL (555,241)
078 RETIREMENT SYSTEM 969,976
080 LIABILITY AND PROPERTY INS FND 19,425,778
081 EMPLOYEE GROUP INSURANCE (1,178,314)
082 WORKERS COMPENSATION FUND 15,367,082
083 PAYROLL REVOLVING 5,946,667
085 CITY YARD OPERATION 86,139
086 PUB WKS ENG/PROJ MGMT (782,430)
087 PT RETIREMENT FUND 7,193
088 QUALITY SERVICE TRAINING 400,463
089 CA SEISMIC HAZARD PROGRAM 5,733
090 ORANGE CO SANITATION DIST 2&3 748,309
093 BUSINESS IMPROVEMENT DISTRICT 142,057
094 INTEREST AGENCY 209,356
095 POLICE COMMISSARY ACCOUNT 362,944
096 SA TOURISM MARKETING DISTRICT 117,938
100 SECTION 457 FIDUCIARY ADMIN 46,407
101 PUB WKS-ADMIN & PLANNING 2,227,930
103 PMA RETIREE HEALTH INSURANCE 8,140
104 SEIU RETIREE HEALTH INSURANCE 21,369
106 MGMT RETIREE HEALTH INSURANCE 9,230
107 UC RETIREE HEALTH INSURANCE 2,036
109 INFO SYS STRATEGIC PLAN 13,040,608
110 STRONG MOTION INSTRUMENTATION 97,520
120 FIRE FACILITIES FUND 1,583,904
121 SPECIAL REPAIR/DEMOLITION 431,796
122 EMERGENCY & HEALTH GRANTS 7,028,979
123 WORKFORCE INVESTMENT ACT (1,014,023)
124 ORANGE COUNTY SSA GRANTS 398,534
125 OES UASI (556,897)
127 D.O.J. GRANT FUND 94,265
128 POLICE BLOCK GRANTS 1,114,720
130 HOME PROGRAM FEDERAL GRANT 1,176,405
133 HOUSING AUTHORITY-ISSUER FEE 2,731,388
135 COMMUNITY DEV BLOCK GRANT (255,103)
136 HOUSING AUTHORITY-VOUCHER HAP 599,767
137 HOUSING AUTHORITY- MAINSTREAM -
138 HOUSING AUTHORITY-MS 5 675,937
139 HOUSING AUTHORITY-NEW CONSTR 114,186
140 HOUSING AUTHORITY-VOUCHER ADM 2,085,140
142 NSP FEDERAL GRANT 1,319,612
143 CALHOME MFGD HSG LOAN 626,431
144 PRISON TO EMPLOYMENT PROGRAM (416,129)
145 RENTAL REHABILITATION GRANT 393,417
147 FEDERAL AID SAFETY PROGRAM (819,078)
148 TRAFFIC SYSTEM MGMT GRANT (6,274,433)
149 WIC ASSESSMENT DIST ST IMPRV 32,574
152 PUBLIC LIBRARY GRANT FUND 7,548
153 LIBRARY GRANTS 42,388
154 LIBRARY SVCS & TECHNOLOGY ACT 1,375
155 OCJP GRANT 36,355
157 HSG ADMIN CARES ACT COVID-19 (11,577)
158 PLANNING GRANTS PROGRAM (98,977)
160 HSG HAP CARES ACT COVID-19 174
161 PRCSA CAPITAL GRANTS (130,148)
162 ENERGY CONSERVATION PROGRAM 94,545
164 PUB WKS-WTR QUALITY & CONTROL (1,137,455)
165 OFFICE OF SAFETY GRANT 158,705
Quarterly Report of Investments as of June 30, 2021
Exhibit 2 - Cash held by Bank and Cash by Fund(s) Listing
Page 3 of 3
166 US DOJ ASSET FORFEITURE FUND 1,387,050
167 US TREASURY ASSET FORFEITURE 138,631
169 RECREATION GRANTS FUND 373,810
170 MS5 HAP CARES ACT COVID-19 (558,258)
172 NATL RECREATION TRAILS FND ACT 17,061
175 CARES ACT - CESF -
176 CARES ACT - State -
177 EMERGENCY RENTAL ASSISTANCE PG 13,086,606
178 COVID RELIEF FUND (83,353)
180 ARPA EHV ADMIN FEES 191,350
181 AMERICAN RESCUE PLAN ACT 64,180,407
201 LOCAL DRAINAGE AREA NO 1 132
202 LOCAL DRAINAGE AREA NO 2 1,422
203 LOCAL DRAINAGE AREA NO 3 751,351
204 LOCAL DRAINAGE AREA NO 4 1,050
205 LOCAL DRAINAGE AREA NO 5 597
206 LOCAL DRAINAGE AREA NO 6 876
207 LOCAL DRAINAGE AREA NO 7 193,226
209 LOCAL DRAINAGE AREA NO 9 729
210 LOCAL DRAINAGE AREA NO 10 17,086
211 LOCAL DRAINAGE AREA NO 11 222
212 LOCAL DRAINAGE AREA NO 12 13
213 LOCAL DRAINAGE AREA NO 13 2,684
221 LOCAL DRAINAGE AREA I 965,010
222 LOCAL DRAINAGE AREA II 225,553
223 LOCAL DRAINAGE AREA III 417,939
224 LOCAL DRAINAGE AREA IV 509,281
225 LOCAL DRAINAGE AREA V 254,185
226 LOCAL DRAINAGE AREA VI 216,436
301 REC/COMM SVS 6,013
311 RESIDENTIAL DEVELOP DISTRICT 1 3,209,325
312 RESIDENTIAL DEVELOP DISTRICT 2 3,725,313
313 RESIDENTIAL DEVELOP DISTRICT 3 11,216,622
314 RESIDENTIAL DEVELOP DISTRICT 4 530,022
400 POLICE UUT LEASE REVENUE BONDS 5,735
403 SCAG GRANTS 750
404 COSA 2014 LEASE FINANCING 74,214
417 INCLUSIONARY HOUSING FEE 10,187,800
418 CDA - PEEBLER CAPITAL FUND 4,647,031
607 HOUSING AUTHORITY LMIHF 3,612,618
652 2003A SERIES TAX ALLOC BOND -
654 2011A SERIES TAX ALLOC BOND -
655 2018A SERIES TAX ALLOC BOND 11,762
658 2003B SERIES ALLOC BOND -
670 COSA RDA 407,940
671 COSA RDA OBLIGATION RETIREMENT 5,706,086
980 SAN JUANQUIN TRANS CORRIDOR -
981 EASTERN FOOTHILL TRANS CORRIDO -
991 TRAN SYS IMP AUT C-2 TUSTIN 2,163,284
992 TRAN SYS IMP AUT AREA D-TUSTIN 11,058,323
993 WIC ASSESSMENT DISTRICT 357,923
998 TREASURERS AGENCY COLLECTIONS 20,262
999 Lawson Clearing (263)
Reconciling Item(s) - Outstanding Checks *2,080,751
Reconciling Item(s) - Bank Direct Deposits*102,265
Reconciling Item(s) - Deposits in Transit*(1,813,489)
Reconciling Item(s) - Various*(293,188)
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