ATTACHMENT A
CITY OF LANCASTER
MONTHLY REPORT OF INVESTMENTS
August 2024
Interest Rate Amount Total
Pooled Cash/Investments
City of Lancaster
Wells Fargo Bank $22,263,100.61
City of Lancaster Account 0.00% S22,263,100.61
U S Bank - Safekeeping (Insight) S35,802,385.75
US Treasury Notes 3.32% S19,364,543.68
Federal Government Agencies 2.65% S10,551,916.19
Corporate Securities 3.28% $7,676,495.00
Short Term Bills and Notes S0.00
Municipal/Provincial Bonds 0.00% $0.00
Cash & Equivalents 0.00% ($1,790,569.12)
Chase Bank $153,368.74
Certificate of Deposit 0.01% $153,368.74
California Class $49,936,429.28
City of Lancaster 5.41% S42,307,995.87
City of Lancaster-Enhanced Cash 5.40% $7,628,433.41
Local Agency Investment Fund (L.A.I.F.) 4.30% $6,442,219.80 S6,442,219.80 Total City of Lancaster S114,597,504.18
Successor Agency for the Lancaster Redevelopment Agency California Class $11,026,254.33
Successor Agency 5.41% S11,026,254.33
ocal Agency Investment Fund (L.A.L.F. 4.30% $462,534.62 $462,534.62 Total Successor Agency for the Lancaster Redevelopment Agenc $11,488,788.95 Total Pooled Portfolio S126,086,293.13
Weighted Average 3.454%
Restricted Cash/Investments Held in Trust
River City Bank $16,352,402.17
City of Lancaster ICS Sweep Account 4.34% $11,752,144.79 Lancaster Choice Energy LockBox Account 0.00% S4,600,257.38 The Bank of New York Mellon Trust Company, N.A. $13,040,000.00 LRA & LA County Escrow Account - Government Bonds 0.00% S13,040,000.00 $76,427,999.01
LPA Solar Renewable Energy Issue of 2021 4.75% $576.94
SA Combined Project Areas Refunding Bonds 2015A & B 5.18% $8,150.70 SA Combined Project Areas Refunding Bonds 2016 A-1 & A-2 5.18% $16,047.73 SA Combined Project Areas Refunding Bonds 2016B 4.33% S1,462.69 LFA 2016 Assessment Revenue Bonds (Streetlights Acquisition) 4.08% $811,383.29 SA 2017 Tax Allocation Revenue Bonds (TARB) 5.18% $9,935.90 LFA LRB 2018 Construction and Improvements 5.18% $2,630,855.14 LFA LRB 2019 Street Improvements 5.17% $7,276,645.89
LFA LRB 2024 Stadium Project 35.65% $65,672,940.73
Total Restricted Cash/Investments Held in Trust (note 4) $105,820,401.18 All is inder es dution ized per sant to and consistent with the investment policy of the City of Lancaster. Policy adopted George N. Harris II
Finance Director
City of Lancaster
Recap of Securities Held
August 2024
Unrealized Gain Average Effective % Portfolio/ Average Market Historical Cost Amortized Cost Fair Value (Loss) Maturity (Days) Segment Duration (Years) Cash and Equivalents $88,493,338 $88,493,338 $88,493,338 $0 70.18% 0.00 Corporate Bonds $7,676,495 $7,646,643 $7,602,938 ($43,704) 465 6.09% 1.18 Government Agencies $10,551,916 $10,531,078 $10,541,239 $10,161 604 8.37% 1.40 Government Bonds $19,364,544 $19,490,807 $19,536,473 $45,666 772 15.36% 1.96 Municipal/Provincial Bonds $0 SO $0 $0 0.00% 0.00
Short Term Bills and Notes $0 SO $O $0 0.00% 0.00
$126,086,293 S126,161,865 $126,173,988 $12,122 670 100.00% 1.67 Portfolio Diversification
•Cash and Equivalents
•Corporate Bonds
0.00%
M Government Agencies
15.36% 0.00%
•Government Bonds
#Municipal/Provincial Bonds
8.37%
• Short Term Bills and Notes
6.09% 70.18%
City of Lancaster
Maturity Distributior
ugust 2024
Maturity Historical Cost Percent
Under 90 Days $92,491,046 72.29%
March 2024 $3,245,807 2.54%
180 Days to 1 Year $6,425,963 5.02%
1 to 2 Years $12,818,164 10.02%
2 to 3 Years $4,725,828 3.69%
3 to 4 Years $7,225,659 5.65%
4 to 5 Years $1,019,730 0.80%
Over 5 Years $O 0.00%
$127,952,196 100.00%
Maturity Distribution
(Millions)
$100
$90
$80
$70
$60
Historical Cost
$50
$40
$30
$20
$10
SO
Under 90 March 2024 180 Days to 1 1 to 2 Years 2 to 3 Years 3 to 4 Years 4 to 5 Years Over 5 Years Days
ATTACHMENT A
CITY OF LANCASTER
MONTHLY REPORT OF INVESTMENTS
August 2024
(1) This is the actual City bank account balance as of 08/31/2024. It only reflects checks that have been presented for payment and deposits received by the bank.
The balance on deposit per the City books would reflect reductions for all checks and warrants issued and all deposits transmitted.
(2) This is the safekeeping account utilized for investing City funds pursuant to and consistent with the investment policy adopted on 02/13/2018. The current portfolio consists of treasury notes, government agencies, corporates, and CDs. (3) Pooled Portfolio:
% of Portfolio Policy Limit
Cash 16.24% None
CDs 0.12% 25% of total portfolio
Commercial Paper 0.00% 25% of total portfolio
US Treasury 15.36% None
Federal Securities 8.37% None
Corporate Securities 6.09% 30% of total portfolio
Municipal/Provincial 0.00% None
California CLASS 48.35% None
LAIF 5.48% None
(4) These are restricted cash and investments are held in trust by the banks indicated.
These amounts cannot be pooled for other investments.