ATTACHMENT A
CITY OF LANCASTER
MONTHLY REPORT OF INVESTMENTS
July 2024
Interest Rate Amount Total
Pooled Cash/Investments
City of Lancaster
Wells Fargo Bank $18,271,228.29
City of Lancaster Account 0.00% S18,271,228.29
U S Bank - Safekeeping (Insight) $37,600,529.07
US Treasury Notes 3.32% $19,364,543.68
Federal Government Agencies 2.44% $11,651,916.19
Corporate Securities 3.00% S6,550,671.00
Short Term Bills and Notes 0.00% $323,967.32
Municipal/Provincial Bonds 0.51% S1,500,000.00
Cash & Equivalents 0.00% (S1,790,569.12)
Chase Bank $153,368.74
Certificate of Deposit 0.01% $153,368.74
California Class $49,708,804.39
City of Lancaster 5.42% S42,115,099.91
ity of Lancaster-Enhanced Casl 5.43% $7,593,704.48
ocal Agency Investment Fund (L.A.I.F. 4.30% S11,442,219.80 _S11,442,219.80 Total City of Lancaster $117,176,150.29
lifornia Cle S10,975,982.04
Successor Agency 5.42% $10,975,982.04
4.30% S462,534.62 $462,534.62
Total enor Agent for Fund ancaster Redevelopment Agency S11,438,516.66
Total Pooled Portfolio $128,614,666.95
Weighted Average
Restricted Cash/Investments Held in Trust
S12,797,261.65
City of Lancaster ICS Sweep Account 4.34% $10,086,436.44 Lancaster Choice Energy LockBox Account 0.00% S2,710,825.21 The Bank of New York Mellon Trust Company, N.A. S13,040,000.00 LRA & LA County Escrow Account - Government Bonds 0.00% S13,040,000.00 S93,469,708.27
LPA Solar Renewable Energy Issue of 2021 4.76% $574.62
SA Combined Project Areas Refunding Bonds 2015A & B 5.18% $1,110,785.36 SA Combined Project Areas Refunding Bonds 2016 A-1 & A-2 5.18% $3,861,438.69 SA Combined Project Areas Refunding Bonds 2016B 4.33% $222,598.56 LEA 2016 Assessment Revenue Bonds (Streetlights Acquisition) 5.17% $481.83 SA 2017 Tax Allocation Revenue Bonds (TARB) 5.18% $3,325,013.20 LEA LRB 2018 Construction and Improvements 5.18% S2,619,328.06 LFA LRB 2019 Street Improvement: 5.18% $12,720,593.88
LFA LRB 2024 Stadium Projec 20.36% S69,608,894.07
Total Restricted Cash/Investments Held in Trust (note 4) S119.306,969.92 George N. Harris II
Finance Director
City of Lancaster
Recap of Securities Held
July 2024
Unrealized Gain Weighted % Portfolio/ Weighted
Historical Cost Amortized Cost Fair Value (Loss) Average Effective Segment Average Market Cash and Equivalents $89,223,569 $89,223,569 $89,223,569 $0 1 69.37% 0.00 Corporate Bonds $6,550,671 $6,520,559 S6,443,228 ($77,332) 453 5.09% 1.16 Government Agencies $11,651,916 $11,627,052 $11,581,339 ($45,713) 575 9.06% 1.35 Government Bonds $19,364,544 $19,483,168 $19,417,279 ($65,889) 802 15.06% 2.04 Municipal/Provincial Bonds $1,500,000 $1,500,000 $1,500,000 $O 1 1.17% 0.00 Short Term Bills and Notes $323,967 $325,000 $325,000 $0 0.25% 0.00 $128,614,667 $128,679,347 $128,490,414 ($188,934) 670 100.00% 1.67 Portfolio Diversification
• Cash and Equivalents
• Corporate Bonds
1.17%
• Government Agencies
15.06% 0.25%
• Government Bonds
•Municipal/Provincial Bonds
9.06% • Short Term Bills and Notes
5.09% 69.37%
City of Lancaster
Maturity Distribution
July 2024
Maturity Historical Cost Percent
Under 90 Days $93,179,450 72.45%
March 2024 $4,345,697 3.38%
180 Days to 1 Year $4,850,975 3.77%
1 to 2 Years $13,267,328 10.32%
2 to 3 Years $4,725,828 3.67%
3 to 4 Years $7,225,659 5.62%
4 to 5 Years $1,019,730 0.79%
Over 5 Years $0 0.00%
$128,614,667 100.00%
(Millions) Maturity Distribution
$100
$90
$80
$70
$60
Historical Cost $50
$40
$30
$20
$10
SO
Under 90 Days March 2024 180 Days to 1 1 to 2 Years 2 to 3 Years
ATTACHMENT A
CITY OF LANCASTER
MONTHLY REPORT OF INVESTMENTS
July 2024
(1) This is the actual City bank account balance as of 07/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 12.81% None
CDs 0.12% 25% of total portfolio
Commercial Paper 0.25% 25% of total portfolio
US Treasury 15.06% None
Federal Securities 9.06% None
Corporate Securities 5.09% 30% of total portfolio
Municipal/Provincial 1.17% None
California CLASS 47.18% None
LAIF 9.26% None
(4) These are restricted cash and investments are held in trust by the banks indicated.
These amounts cannot be pooled for other investments.