Attachment 1 - October 2022 Investment ReportTown 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