Staff Report with attachments
PREPARED BY: Gitta Ungvari
Finance Director
Reviewed by: Town Manager, Town Attorney, and Assistant Town Manager
110 E. Main Street Los Gatos, CA 95030 ● 406-354-6832
www.losgatosca.gov
TOWN OF LOS GATOS
FINANCE COMMISSION REPORT
MEETING DATE:01/17/2023 ITEM NO: 10
DATE: January 11, 2023
TO: Mayor and Town Council
FROM: Laurel Prevetti, Town Manager
SUBJECT: Receive Monthly Investment Reports for October and November 2022
RECOMMENDATION:
Receive Monthly Investment Reports for October and November 2022.
DISCUSSION:
Staff is changing the frequency of the reporting from quarterly to monthly to comply with the
California Government Code Section 41004.
As of November 30, 2022, the Town’s weighted portfolio yield was 2.03% which exceeded by 2
basis points the Local Agency Investment Fund (LAIF) yield of 2.01% as of the same reporting
period. Currently the LAIF portfolio weighted average maturity (WAM) is304 days versus the
Town’s longer WAM of 435 days. The Town’s weighted average rate of return of 2.03% at the
close of November was 23 basis points higher when compared to the First quarter return of
1.80% reported as of September 30, 2022.
Since September 30, 2022, LAIF yields had climbed from 151 basis points (1.51%) to 201 basis
points (2.01%) through the end of November 2022. Staff in coordination with the Town’s
investment advisor primarily replaced maturing investments in shorter to medium term
maturities in the two- to three-year maturity range. These investments capture current yields
that exceed the rates expected to be earned in the State LAIF pool during that same time
period. The State LAIF pool typically lags the market when current market yields are either
increasing or decreasing.
At its most recent meeting in December 2022, the Fed indicated it expected to raise interest
rates further in 2023 to approximately 5.25% from its current rate of 4.25% to 4.5%, with the
Fed anticipating that 5.25% rate to hold steady for the remainder of calendar year 2023.
PAGE 2 OF 2 SUBJECT: Receive the Monthly Investment Reports for October and November 2022 DATE: January 11, 2023
DISCUSSION (continued):
The Finance Commission was scheduled to receive the reports at its January 10, 2023 meeting.
The item was pulled from the consent calendar and moved to the end of the agenda. Given
other items and the time constraint for the meeting, the Commission did not have time to
discuss the reports. These reports will be provided again to the Finance Commission for its
February meeting.
CONCLUSION:
Staff recommends that the Town Council receive the Monthly Investment Reports for October
and November 2022.
Attachments:
1. Monthly Investment Report for October 2022
2. Monthly Investment Report for November 2022
Town of Los Gatos
Summary Investment Information
October 31, 2022
Weighted Average YTM Portfolio Yield: 1.82%Weighted Average Maturity (days)425
This Month Last Month One year ago
Portfolio Balance $62,569,240 $62,736,952 $59,763,609
Benchmarks/ References:
Town's Average Yield 1.82%1.80%1.24%
LAIF Yield for month 1.77%1.51%0.20%
3 mo. Treasury 4.09%3.29%0.06%
6 mo. Treasury 4.55%3.97%0.06%
2 yr. Treasury 4.49%4.28%0.50%
5 yr. Treasury (most recent)4.23%4.09%1.19%
10 Yr. Treasury 4.05%3.84%1.56%
0 -1 year
30%
1 -2 years
30%
2 -3 years
25%
3 -5 years
15%
Portfolio Maturity Profile
Compliance:The Town's investments are in compliance with the Town's investment policy dated September 21, 2021
and also in compliance with the requirements of Section 53601 of the California State Code. Based on the information available,the Town has sufficient funds to meet the cash demands for the next six months.
Page 1 ATTACHMENT 1
Town of Los Gatos
Portfolio Allocation & Treasurer's Fund Balances
October 31, 2022 Month YTDFund Balances - Beginning of Month/Period $62,736,951.51 $72,886,942.83
Receipts 2,970,841.52 14,361,634.16Disbursements(3,138,553.40)(24,679,337.36)
Fund Balances - End of Month/Period $62,569,239.63 $62,569,239.63
Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy
BNY MM $179,619.69 0.33%20% of Town Portfolio
US Treasury Notes $9,883,589.53 18.39%No Max. on US Treasuries
Government Agency Debenture Notes $23,416,349.00 43.56%No Max. on Non-Mortgage BackedCorporate Medium Term Bonds $13,336,173.01 24.81%30% of Town PortfolioLocal Agency Investment Fund $6,941,939.56 12.91%$75 M per State Law
Subtotal - Investments 53,757,670.79 100.00%
Reconciled Demand Deposit Balances 8,811,568.84
Total Treasurer's Fund $62,569,239.63
BNY MM0.33%US Treasury Notes
18.39%
Government Agency Debenture Notes43.56%
Corporate Medium Term Bonds24.8%
Local Agency Investment Fund12.9%
Portfolio Investment Allocation
0
10000000
20000000
30000000
40000000
50000000
60000000
70000000
80000000
90000000
Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22
Treasurer's Fund Balances
page 2
Town of Los GatosNon-Treasury Restricted Fund BalancesOctober 31, 2022
OCT 22 OCT 22 OCT 22
Beginning Deposits Interest/Ending
Balance Realized Gain/Adj.Earnings Withdrawals Balance
Non-Treasury Funds:`
Cert. of Participation 2002 Series A Reserve Fund 688,224.79 1,029.47$ 1,973.79$ 687,280.47$ Note 1
Cert. Of Participation 2010 Ser A Lease Pymt Fund 132.26 0.27 132.53$ Note 1
Cert. of Participation 2002 Lease Payment Fund 65.79 1,973.79 2,039.58$ Note 1
Cert. of Participation 2010 Series Reserve Fund 1,282,093.98 2,396.58 1,284,490.56 Note 2Total Restricted Funds:1,970,516.82$ 1,973.79$ 3,426.32$ 1,973.79$ 1,973,943.14$
CEPPT IRS Section 115 Trust 638,355.08 5,466.39 0.00 643,821.47$
Grand Total COP's and CEPPT Trust 2,608,871.90$ 1,973.79$ 8,892.71$ 1,973.79$ 2,617,764.61$
These accounts are not part of the Treasurer's fund balances reported elsewhere in this report, as they are for separate and distinct
entities.
Note 1: The three original funds for the Certificates of Participation 2002 Series A consist of construction funds which will be expended over the
next few years, reserve funds which will guarantee the payment of lease payments, and a third fund for the disbursement of lease payments
and initial delivery costs.
Note 2: The 2010 COP Funds are all for the Library construction, reserves to guarantee lease payments, and a lease payment fund for the
life of the COP issue. The COI fund was closed in September 2010.
Note 3: The CEPPT Section IRS Section 115 Trust was established as an irrevocable trust dedicated to accumulate resources to fund the Town's unfunded liabilities related to pension and other p
Page 3
Town of Los Gatos
Statement of Interest Earned
October 31, 2022
Interest by Month
July 2022 $60,107.76
August 2022 61,456.65
September 2022 60,153.38
October 2022 68,965.25
November 2022
December 2022
January 2023
February 2023
March 2023
April 20203
May 2023
June 2023
$250,683.04
Page 4
Town of Los Gatos Investment Schedule October
2022 Maturity Yield to Interest Interest Interest DaysDepositParOriginalMarketPurchasedDate or Maturity Received Earned Earned to
Institution CUSIP #Security Date Value Cost Value Interest Call Date or Call to Date Prior Yrs.Current FY MaturityTreasury91282CAP6US Treasury Note 6/30/2021 1,000,000.00 995,390.63 957,734.38 10/15/2023 0.33%1,615.44$ 3,260.06$ 1,098.60$ 349Toyota Motor Credit 89236THA6_1 Corporate Bond 04/12/21 500,000.00 510,580.00 485,471.94 8/25/2023 0.45%9,243.75$ 2,780.30$ 770.22$ 298
Toyota Motor Credit 89236THA6 Corporate Bond 1/11/2022 1,100,000.00 1,107,315.00 1,068,038.27 8/25/2023 0.94%9,240.00$ 4,812.29$ 3,481.84$ 298US Treasury 91282CDD0 US Treasury Note 1/13/2022 1,100,000.00 1,090,675.78 1,054,023.43 10/31/2023 0.85%3,281.77$ 4,286.54$ 3,138.36$ 365US Treasury 91282CCN9 US Treasury Note 1/13/2022 1,200,000.00 1,188,375.00 1,160,250.00 7/31/2023 0.75%823.37$ 4,153.18$ 3,040.72$ 273FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 968,808.22 2/23/2024 1.90%73,775.83$ 55,756.94$ 6,451.65$ 480FFCB3133EMBE1Gov. Agency Debenture 10/8/2020 1,600,000.00 1,598,000.00 1,504,220.59 3/28/2024 0.34%9,453.34$ 9,279.41$ 1,811.69$ 514FFCB3133EMCQ3Gov. Agency Debenture 10/16/2020 2,000,000.00 1,998,000.00 1,912,165.36 10/13/2024 0.31%11,153.33$ 10,396.24$ 2,055.85$ 713BankAmerica Corp 06051GHC6 Corporate Bond 10/9/2020 1,300,000.00 1,366,287.00 1,295,318.96 12/20/2023 0.66%66,279.92$ 31,569.88$ 6,173.44$ 415Home Depot 437076BM3 Corporate Bond 8/4/2022 1,000,000.00 991,960.00 939,937.13 1/1/2026 3.04%4,750.00$ -$ 7,800.71$ 1158Home Depot 912828ZW3 US Treasury Note 8/9/2022 350,000.00 322,096.88 313,960.94 95.11 6/30/2025 3.16%(95.11)$ -$ 2,392.12$ 973
IBM 459200JY8 Corporate Bond 3/25/2021 1,000,000.00 1,071,040.00 970,339.39 5/15/2024 0.71%34,166.67$ 9,358.41$ 2,491.52$ 562US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 493,261.72 4/30/2023 1.77%27,046.54$ 26,507.80$ 2,980.31$ 181Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 1,976,295.56 6/19/2023 1.79%160,416.67$ 107,829.55$ 12,314.80$ 231FFCB3133EKVF0Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 994,936.65 1/17/2023 1.89%55,989.58$ 55,482.90$ 6,354.19$ 78Treasury91282CBT7US Treasury Note 9/30/2022 800,000.00 712,565.18 707,875.00 3/31/2026 4.14%-$ -$ 2,630.46$ 1247FFCB3133ENP95Gov. Agency Debenture 9/30/2022 900,000.00 900,939.60 891,494.81 9/30/2025 4.14%-$ -$ 3,222.05$ 1065US Treasury 91282CDA6 Gov. Agency Debenture 1/31/2022 1,100,000.00 1,085,222.44 1,057,031.25 9/30/2023 1.07%1,820.74$ 4,781.92$ 3,921.18$ 334US Treasury 91282CAW1 Gov. Agency Debenture 7/15/2021 1,200,000.00 1,199,437.50 1,146,796.87 11/15/2023 0.27%2,502.72$ 3,107.52$ 1,092.07$ 380American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 957,536.74 6/27/2024 2.12%72,733.34$ 55,189.68$ 7,175.82$ 605JP Morgan Chase 46625HRS1 Gov. Agency Debenture 9/23/2022 500,000.00 474,660.00 462,877.42 4,355.56 3/15/2026 4.70%(4,355.56)$ -$ 2,424.56$ 1231Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 957,664.07 7/15/2024 1.64%62,483.33$ 51,828.99$ 6,689.37$ 623
Caterpillar Financial Serv 14913Q2V0 Corporate Bond 2/23/2021 1,000,000.00 1,077,370.00 970,099.77 5/17/2024 0.44%35,150.00$ 6,129.72$ 1,532.43$ 564FNMA3135G0V75Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,050,134.43 7/2/2024 1.63%52,456.25$ 48,706.74$ 6,069.84$ 610US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 979,313.57 1/5/2024 2.12%88,218.75$ 54,380.13$ 7,278.30$ 431FHLB3133834G3Gov. Agency Debenture 3/11/2021 1,400,000.00 1,460,522.00 1,377,991.73 6/9/2023 0.19%37,022.22$ 3,664.98$ 947.04$ 221FFCB3133EKQA7Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 954,400.43 9/10/2024 1.66%60,031.11$ 45,130.78$ 5,647.09$ 680PNC Financial 69349LAM0 Corporate Bond 2/7/2022 1,000,000.00 1,033,470.00 989,670.62 6/25/2023 1.49%17,733.33$ 5,372.34$ 4,620.97$ 237FHLB3135G05X7Gov. Agency Debenture 6/10/2022 1,200,000.00 1,102,952.40 1,069,830.90 8/25/2025 3.04%937.50$ 1,902.68$ 11,701.47$ 1029Treasury912828ZL7Gov. Agency Debenture 4/12/2022 1,700,000.00 1,583,927.57 1,539,296.88 4/30/2025 2.72%3,504.49$ 9,611.14$ 14,964.18$ 912JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,382,875.52 2/1/2024 2.39%154,913.89$ 96,022.89$ 11,682.31$ 458American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 591,047.52 5/10/2023 1.75%28,145.00$ 25,034.14$ 3,551.56$ 191Treasury912828V23US Treasury Note 11/29/2021 1,000,000.00 1,032,933.04 972,968.75 12/31/2023 0.66%13,206.52$ 3,924.44$ 2,266.23$ 426
Treasury 91282CBE0 2 Gov. Agency Debenture 10/7/2021 1,000,000.00 994,768.98 947,070.31 1/15/2024 0.36%964.67$ 2,587.41$ 1,196.43$ 441FHLB3130ALH98Gov. Agency Debenture 2/26/2021 1,000,000.00 997,610.00 940,126.43 2/26/2024 0.33%3,750.00$ 4,416.63$ 1,110.93$ 483Treasury912828M80US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 998,690.43 11/30/2022 1.81%57,158.47$ 53,444.10$ 6,120.69$ 30Treasury912828U57US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 973,789.06 11/30/2023 1.84%60,208.33$ 54,014.24$ 6,238.26$ 395Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 961,679.69 4/30/2024 1.75%62,703.30$ 48,922.73$ 6,590.90$ 547Treasury912828XT2US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 960,000.00 5/31/2024 1.64%51,639.34$ 44,208.50$ 5,588.54$ 578American Honda 02665WCQ2 Corporate Bond 9/14/2021 950,000.00 1,012,871.00 937,058.14 10/10/2023 0.41%36,924.65$ 3,232.93$ 1,375.95$ 344FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,465,477.95 12/21/2023 2.12%121,348.96$ 64,945.24$ 7,703.24$ 416Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,542,347.67 2/8/2023 1.82%117,606.25$ 86,008.42$ 9,599.85$ 100Treasury91282CBE0Gov. Agency Debenture 9/15/2021 650,000.00 647,615.46 615,595.70 1/15/2024 0.28%675.62$ 1,447.14$ 618.05$ 441
Subtotal 46,200,000.00$ 46,636,111.54$ 44,495,504.20$ 4,450.67$ 1,606,624.32$ 1,103,488.93$ 205,915.78$
BNY MM Money Market 179,619.69 179,619.69 0.00%1
LAIF State Investment Pool 6,941,939.56 6,941,939.56 1.77%33,791.70 1
$53,757,670.79 $51,617,063.45 1,606,624.32$ 1,103,488.93$ 239,707.48$
Matured AssetsIBM 459200HG9 Corporate Bond 8/8/2019 1,000,000.00 995,010.00 8/1/2022 2.05%55,885.42$ 59,141.32$ 1,790.47$ JP Morgan Chase 46625HJE1 Gov. Agency Debenture 2/11/2020 900,000.00 934,587.00 9/23/2022 1.74%76,537.50$ 38,210.60$ 3,733.22$ Treasury 912828L57 US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 9/30/2022 2.09%67,016.39$ 63,644.66$ 5,451.87$
Total Investments "Matured"10,975.56$
Total Interest FY 22_23 Matured and Current 250,683.04$
Maturity Profile Amount0-1 year $23,358,334.421-2 years $24,310,234.742-3 years $3,909,916.453-5 years 2,179,185.18$ $53,757,670.79
Amortized
Institution Cost BNY Assets $46,636,111.54BNY MM 179,619.69
LAIF 6,941,939.56Totals:$53,757,670.79
Market to Cost Position Report
Page 5
This Page Intentionally Left Blank
Town of Los Gatos
Summary Investment Information
November 30, 2022
Weighted Average YTM Portfolio Yield: 2.03%Weighted Average Maturity (days)435
This Month Last Month One year ago
Portfolio Balance $65,273,987 $62,569,240 $61,676,887
Benchmarks/ References:
Town's Average Yield 2.01%1.82%1.21%
LAIF Yield for month 1.77%1.77%0.20%
3 mo. Treasury 4.38%4.09%0.05%
6 mo. Treasury 4.71%4.55%0.10%
2 yr. Treasury 4.31%4.49%0.52%
5 yr. Treasury (most recent)3.74%4.23%1.15%
10 Yr. Treasury 3.61%4.05%1.45%
0 -1 year
30%
1 -2 years
30%
2 -3 years
25%
3 -5 years
15%
Portfolio Maturity Profile
Compliance:The Town's investments are in compliance with the Town's investment policy dated September 21, 2021
and also in compliance with the requirements of Section 53601 of the California State Code. Based on the information available,the Town has sufficient funds to meet the cash demands for the next six months.
Page 1 ATTACHMENT 2
Town of Los Gatos
Portfolio Allocation & Treasurer's Fund Balances
November 30, 2022 Month YTDFund Balances - Beginning of Month/Period $62,569,239.63 $72,886,942.83
Receipts 5,801,425.93 20,163,060.09Disbursements(3,096,678.62)(27,776,015.98)
Fund Balances - End of Month/Period $65,273,986.94 $65,273,986.94
Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy
BNY MM $79,480.09 0.15%20% of Town Portfolio
US Treasury Notes $10,037,973.70 18.65%No Max. on US Treasuries
Government Agency Debenture Notes $23,416,349.00 43.52%No Max. on Non-Mortgage BackedCorporate Medium Term Bonds $13,336,173.01 24.78%30% of Town PortfolioLocal Agency Investment Fund $6,941,939.56 12.90%$75 M per State Law
Subtotal - Investments 53,811,915.36 100.00%
Reconciled Demand Deposit Balances 11,462,071.58
Total Treasurer's Fund $65,273,986.94
BNY MM
0.15%US Treasury Notes18.65%
Government Agency Debenture Notes43.52%
Corporate Medium Term Bonds24.8%
Local Agency Investment Fund12.9%
Portfolio Investment Allocation
0
10000000
20000000
30000000
40000000
50000000
60000000
70000000
80000000
90000000
Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22
Treasurer's Fund Balances
page 2
Town of Los GatosNon-Treasury Restricted Fund BalancesNovember 30, 2022
NOV 22 NOV 22 NOV 22
Beginning Deposits Interest/Ending
Balance Realized Gain/Adj.Earnings Withdrawals Balance
Non-Treasury Funds:`
Cert. of Participation 2002 Series A Reserve Fund 687,280.47 1,399.90$ 688,680.37$ Note 1
Cert. Of Participation 2010 Ser A Lease Pymt Fund 132.53 0.31 132.84$ Note 1
Cert. of Participation 2002 Lease Payment Fund 2,039.58 3.78 2,043.36$ Note 1
Cert. of Participation 2010 Series Reserve Fund 1,284,490.56 3,008.68 1,287,499.24 Note 2Total Restricted Funds:1,973,943.14$ -$ 4,412.67$ -$ 1,978,355.81$
CEPPT IRS Section 115 Trust 643,821.47 29,920.82 0.00 673,742.29$
Grand Total COP's and CEPPT Trust 2,617,764.61$ -$ 34,333.49$ -$ 2,652,098.10$
These accounts are not part of the Treasurer's fund balances reported elsewhere in this report, as they are for separate and distinct
entities.
Note 1: The three original funds for the Certificates of Participation 2002 Series A consist of construction funds which will be expended over the
next few years, reserve funds which will guarantee the payment of lease payments, and a third fund for the disbursement of lease payments
and initial delivery costs.
Note 2: The 2010 COP Funds are all for the Library construction, reserves to guarantee lease payments, and a lease payment fund for the
life of the COP issue. The COI fund was closed in September 2010.
Note 3: The CEPPT Section IRS Section 115 Trust was established as an irrevocable trust dedicated to accumulate resources to fund the Town's unfunded liabilities related to pension and other p
Page 3
Town of Los Gatos
Statement of Interest Earned
November 30, 2022
Interest by Month
July 2022 $60,107.76
August 2022 61,456.65
September 2022 60,153.38
October 2022 68,965.25
November 2022 68,430.71
December 2022
January 2023
February 2023
March 2023
April 20203
May 2023
June 2023
$319,113.75
Page 4
Town of Los Gatos Investment Schedule November
2022
Maturity Yield to Interest Interest Interest DaysDepositParOriginalMarketPurchasedDate or Maturity Received Earned Earned to
Institution CUSIP #Security Date Value Cost Value Interest Call Date or Call to Date Prior Yrs.Current FY MaturityTreasury91282CAP6US Treasury Note 6/30/2021 1,000,000.00 995,390.63 960,468.75 10/15/2023 0.33%1,615.44$ 3,260.06$ 1,366.55$ 319Toyota Motor Credit 89236THA6_1 Corporate Bond 04/12/21 500,000.00 510,580.00 487,892.44 8/25/2023 0.45%9,243.75$ 2,780.30$ 958.08$ 268
Toyota Motor Credit 89236THA6 Corporate Bond 1/11/2022 1,100,000.00 1,107,315.00 1,073,363.37 8/25/2023 0.94%9,240.00$ 4,812.29$ 4,331.06$ 268US Treasury 91282CDD0 US Treasury Note 1/13/2022 1,100,000.00 1,090,675.78 1,056,988.28 10/31/2023 0.85%3,281.77$ 4,286.54$ 3,903.81$ 335US Treasury 91282CCN9 US Treasury Note 1/13/2022 1,200,000.00 1,188,375.00 1,163,859.37 7/31/2023 0.75%823.37$ 4,153.18$ 3,782.36$ 243FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 970,232.63 2/23/2024 1.90%73,775.83$ 55,756.94$ 8,025.22$ 450FFCB3133EMBE1Gov. Agency Debenture 10/8/2020 1,600,000.00 1,598,000.00 1,508,219.33 3/28/2024 0.34%9,453.34$ 9,279.41$ 2,253.57$ 484FFCB3133EMCQ3Gov. Agency Debenture 10/16/2020 2,000,000.00 1,998,000.00 1,917,840.74 10/13/2024 0.31%11,153.33$ 10,396.24$ 2,557.27$ 683BankAmerica Corp 06051GHC6 Corporate Bond 10/9/2020 1,300,000.00 1,366,287.00 1,298,477.34 12/20/2023 0.66%66,279.92$ 31,569.88$ 7,679.16$ 385Home Depot 437076BM3 Corporate Bond 8/4/2022 1,000,000.00 991,960.00 957,879.31 1/1/2026 3.04%4,750.00$ -$ 10,460.04$ 1128Home Depot 912828ZW3 US Treasury Note 8/9/2022 350,000.00 322,096.88 317,269.53 95.11 6/30/2025 3.16%(95.11)$ -$ 3,256.74$ 943IBM 459200JY8 Corporate Bond 3/25/2021 1,000,000.00 1,071,040.00 975,063.37 5/15/2024 0.71%49,166.67$ 9,358.41$ 3,099.21$ 532US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 493,847.66 4/30/2023 1.77%27,046.54$ 26,507.80$ 3,707.22$ 151Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 1,977,773.54 6/19/2023 1.79%160,416.67$ 107,829.55$ 15,318.40$ 201FFCB3133EKVF0Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 996,621.89 1/17/2023 1.89%55,989.58$ 55,482.90$ 7,903.99$ 48Treasury91282CBT7US Treasury Note 9/30/2022 800,000.00 712,565.18 719,406.25 3/31/2026 4.14%-$ -$ 5,176.08$ 1217FFCB3133ENP95Gov. Agency Debenture 9/30/2022 900,000.00 900,939.60 898,884.76 9/30/2025 4.14%-$ -$ 6,340.17$ 1035US Treasury 91282CDA6 Gov. Agency Debenture 1/31/2022 1,100,000.00 1,085,222.44 1,059,867.18 9/30/2023 1.07%1,820.74$ 4,781.92$ 4,877.56$ 304US Treasury 91282CAW1 Gov. Agency Debenture 7/15/2021 1,200,000.00 1,199,437.50 1,149,656.26 11/15/2023 0.27%4,002.72$ 3,107.52$ 1,358.43$ 350American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 962,210.06 6/27/2024 2.12%72,733.34$ 55,189.68$ 8,926.03$ 575JP Morgan Chase 46625HRS1 Gov. Agency Debenture 9/23/2022 500,000.00 474,660.00 475,651.94 4,355.56 3/15/2026 4.70%(4,355.56)$ -$ 4,338.68$ 1201Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 963,960.61 7/15/2024 1.64%62,483.33$ 51,828.99$ 8,320.92$ 593
Caterpillar Financial Serv 14913Q2V0 Corporate Bond 2/23/2021 1,000,000.00 1,077,370.00 974,035.65 5/17/2024 0.44%49,400.00$ 6,129.72$ 1,906.19$ 534FNMA3135G0V75Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,053,545.45 7/2/2024 1.63%52,456.25$ 48,706.74$ 7,550.29$ 580US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 984,049.79 1/5/2024 2.12%88,218.75$ 54,380.13$ 9,053.49$ 401FHLB3133834G3Gov. Agency Debenture 3/11/2021 1,400,000.00 1,460,522.00 1,382,160.43 6/9/2023 0.19%37,022.22$ 3,664.98$ 1,178.03$ 191FFCB3133EKQA7Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 957,952.26 9/10/2024 1.66%60,031.11$ 45,130.78$ 7,024.42$ 650PNC Financial 69349LAM0 Corporate Bond 2/7/2022 1,000,000.00 1,033,470.00 993,945.43 6/25/2023 1.49%17,733.33$ 5,372.34$ 5,748.03$ 207FHLB3135G05X7Gov. Agency Debenture 6/10/2022 1,200,000.00 1,102,952.40 1,083,265.30 8/25/2025 3.04%937.50$ 1,902.68$ 14,555.48$ 999Treasury912828ZL7Gov. Agency Debenture 4/12/2022 1,700,000.00 1,583,927.57 1,551,914.05 4/30/2025 2.72%3,504.49$ 9,611.14$ 18,613.99$ 882JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,386,956.65 2/1/2024 2.39%154,913.89$ 96,022.89$ 14,531.65$ 428American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 592,837.25 5/10/2023 1.75%33,995.00$ 25,034.14$ 4,417.79$ 161Treasury912828V23US Treasury Note 11/29/2021 1,000,000.00 1,032,933.04 973,671.88 12/31/2023 0.66%13,206.52$ 3,924.44$ 2,818.97$ 396
Treasury 91282CBE0 2 Gov. Agency Debenture 10/7/2021 1,000,000.00 994,768.98 950,742.19 1/15/2024 0.36%964.67$ 2,587.41$ 1,488.24$ 411FHLB3130ALH98Gov. Agency Debenture 2/26/2021 1,000,000.00 997,610.00 943,234.98 2/26/2024 0.33%3,750.00$ 4,416.63$ 1,381.89$ 453FHLB3130AQF65US Treasury Note 11/30/2022 1,300,000.00 1,160,559.40 1,166,829.33 7,177.08 12/21/2026 4.15%(7,177.08)$ -$ -$ 1482Treasury912828U57US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 974,335.94 11/30/2023 1.84%70,833.33$ 54,014.24$ 7,759.79$ 365Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 964,218.75 4/30/2024 1.75%62,703.30$ 48,922.73$ 8,198.44$ 517Treasury912828XT2US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 962,734.38 5/31/2024 1.64%61,639.34$ 44,208.50$ 6,951.59$ 548American Honda 02665WCQ2 Corporate Bond 9/14/2021 950,000.00 1,012,871.00 936,168.88 10/10/2023 0.41%36,924.65$ 3,232.93$ 1,711.55$ 314FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,466,647.35 12/21/2023 2.12%121,348.96$ 64,945.24$ 9,582.08$ 386Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,544,142.57 2/8/2023 1.82%117,606.25$ 86,008.42$ 11,941.28$ 70Treasury91282CBE0Gov. Agency Debenture 9/15/2021 650,000.00 647,615.46 617,982.42 1/15/2024 0.28%675.62$ 1,447.14$ 768.79$ 411
Subtotal 46,500,000.00$ 46,790,495.71$ 44,846,805.54$ 11,627.75$ 1,599,513.77$ 1,050,044.83$ 255,122.55$
BNY MM Money Market 79,480.09 79,480.09 0.00%1
LAIF State Investment Pool 6,941,939.56 6,941,939.56 2.01%45,402.09 1
$53,811,915.36 $51,868,225.19 1,599,513.77$ 1,050,044.83$ 300,524.64$
Matured AssetsIBM 459200HG9 Corporate Bond 8/8/2019 1,000,000.00 995,010.00 8/1/2022 2.05%55,885.42$ 59,141.32$ 1,790.47$ JP Morgan Chase 46625HJE1 Gov. Agency Debenture 2/11/2020 900,000.00 934,587.00 9/23/2022 1.74%76,537.50$ 38,210.60$ 3,733.22$ Treasury 912828L57 US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 9/30/2022 2.09%67,016.39$ 63,644.66$ 5,451.87$
Treasury 912828M80 US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 11/30/2022 1.81%67,158.47$ 53,444.10$ 7,613.55$
Total Investments "Matured"18,589.10$
Total Interest FY 22_23 Matured and Current 319,113.75$
Maturity Profile Amount0-1 year $24,463,332.091-2 years $22,098,922.242-3 years $3,909,916.453-5 years 3,339,744.58$ $53,811,915.36
Amortized
Institution Cost BNY Assets $46,790,495.71BNY MM 79,480.09
LAIF 6,941,939.56Totals:$53,811,915.36
Market to Cost Position Report
Page 5