Attachment 1 - First Quarter Investment Report FY 2022-23Weighted Average YTM Portfolio Yield: 1.80%Weighted Average Maturity (days)453
This Month Last Month One year ago
Portfolio Balance $62,736,952 $65,471,423 $59,898,959
Benchmarks/ References:
Town's Average Yield 1.80%1.49%1.27%
LAIF Yield for month 1.51%1.28%0.21%
3 mo. Treasury 3.29%2.95%0.04%
6 mo. Treasury 3.97%3.36%0.05%
2 yr. Treasury 4.28%3.50%0.28%
5 yr. Treasury (most recent)4.09%3.35%0.97%
10 Yr. Treasury 3.84%3.20%1.49%
Town of Los Gatos
Summary Investment Information
September 30, 2022
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
Month YTDFund Balances - Beginning of Month/Period $65,471,423.28 $72,886,942.83
Receipts 2,764,523.98 11,390,792.64Disbursements(5,498,995.75)(21,540,783.96)
Fund Balances - End of Month/Period $62,736,951.51 $62,736,951.51
Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy
BNY MM $124,284.61 0.23%20% of Town Portfolio
US Treasury Notes $9,883,589.53 18.41%No Max. on US Treasuries
Government Agency Debenture Notes $23,416,349.00 43.62%No Max. on Non-Mortgage BackedCorporate Medium Term Bonds $13,336,173.01 24.84%30% of Town PortfolioLocal Agency Investment Fund $6,918,398.79 12.89%$75 M per State Law
Subtotal - Investments 53,678,794.94 100.00%
Reconciled Demand Deposit Balances 9,058,156.57
Total Treasurer's Fund $62,736,951.51
Town of Los Gatos
Portfolio Allocation & Treasurer's Fund Balances
September 30, 2022
BNY MM0.23%US Treasury Notes
18.41%
Government Agency Debenture Notes43.62%
Corporate Medium Term Bonds24.8%
Local Agency Investment Fund12.9%
Portfolio Investment Allocation
0
10000000
20000000
30000000
40000000
50000000
60000000
70000000
80000000
90000000
Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22
Treasurer's Fund Balances
page 2
SEP 22 SEP 22 SEP 22
Beginning Deposits Interest/Ending
Balance Realized Gain/Adj.Earnings Withdrawals Balance
Non-Treasury Funds:`
Cert. of Participation 2002 Series A Reserve Fund 687,317.89 906.90$ 688,224.79$ Note 1
Cert. Of Participation 2010 Ser A Lease Pymt Fund 132.01 0.25 132.26$ Note 1
Cert. of Participation 2002 Lease Payment Fund 65.79 65.79$ Note 1
Cert. of Participation 2010 Series Reserve Fund 1,280,188.55 1,905.43 1,282,093.98 Note 2Total Restricted Funds:1,967,704.24$ -$ 2,812.58$ -$ 1,970,516.82$
CEPPT IRS Section 115 Trust 677,890.30 (39,535.22)0.00 638,355.08$
Grand Total COP's and CEPPT Trust 2,645,594.54$ -$ (36,722.64)$ -$ 2,608,871.90$
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 post employment benefits.
Town of Los GatosNon-Treasury Restricted Fund BalancesSeptember 30, 2022
Page 3
Town of Los Gatos
Statement of Interest Earned
September 30, 2022
Interest by Month
July 2022 $60,107.76
August 2022 61,456.65
September 2022 60,153.38
October 2022
November 2022
December 2022
January 2023
February 2023
March 2023
April 20203
May 2023
June 2023
$181,717.79
Page 4
Town of Los Gatos Investment Schedule September 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,890.62 10/15/2023 0.33%990.44$ 3,260.06$ 821.71$ 380Toyota Motor Credit 89236THA6_1 Corporate Bond 04/12/21 500,000.00 510,580.00 485,470.00 8/25/2023 0.45%9,243.75$ 2,780.30$ 576.10$ 329
Toyota Motor Credit 89236THA6 Corporate Bond 1/11/2022 1,100,000.00 1,107,315.00 1,068,034.00 8/25/2023 0.94%9,240.00$ 4,812.29$ 2,604.30$ 329US Treasury 91282CDD0 US Treasury Note 1/13/2022 1,100,000.00 1,090,675.78 1,054,367.18 10/31/2023 0.85%1,219.27$ 4,286.54$ 2,347.39$ 396US Treasury 91282CCN9 US Treasury Note 1/13/2022 1,200,000.00 1,188,375.00 1,159,875.00 7/31/2023 0.75%823.37$ 4,153.18$ 2,274.36$ 304FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 971,811.35 2/23/2024 1.90%73,775.83$ 55,756.94$ 4,825.62$ 511FFCB3133EMBE1Gov. Agency Debenture 10/8/2020 1,600,000.00 1,598,000.00 1,502,713.78 3/28/2024 0.34%9,453.34$ 9,279.41$ 1,355.09$ 545FFCB3133EMCQ3Gov. Agency Debenture 10/16/2020 2,000,000.00 1,998,000.00 1,912,674.66 10/13/2024 0.31%8,353.33$ 10,396.24$ 1,537.71$ 744BankAmerica Corp 06051GHC6 Corporate Bond 10/9/2020 1,300,000.00 1,366,287.00 1,293,097.70 12/20/2023 0.66%66,279.92$ 31,569.88$ 4,617.53$ 446Home Depot 437076BM3 Corporate Bond 8/4/2022 1,000,000.00 991,960.00 944,643.14 10,250.00 1/1/2026 3.04%(10,250.00)$ -$ 5,052.73$ 1189Home Depot 912828ZW3 US Treasury Note 8/9/2022 350,000.00 322,096.88 314,138.67 95.11 6/30/2025 3.16%(95.11)$ -$ 1,498.67$ 1004
IBM 459200JY8 Corporate Bond 3/25/2021 1,000,000.00 1,071,040.00 972,680.13 5/15/2024 0.71%34,166.67$ 9,358.41$ 1,863.58$ 593US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 493,046.88 4/30/2023 1.77%22,984.04$ 26,507.80$ 2,229.18$ 212Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 1,978,254.26 6/19/2023 1.79%160,416.67$ 107,829.55$ 9,211.07$ 262FFCB3133EKVF0Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 995,158.88 1/17/2023 1.89%55,989.58$ 55,482.90$ 4,752.73$ 109Treasury91282CBT7US Treasury Note 9/30/2022 800,000.00 712,565.18 710,343.75 3/31/2026 4.14%-$ -$ -$ 1278FFCB3133ENP95Gov. Agency Debenture 9/30/2022 900,000.00 900,939.60 896,970.80 9/30/2025 4.14%-$ -$ -$ 1096US Treasury 91282CDA6 Gov. Agency Debenture 1/31/2022 1,100,000.00 1,085,222.44 1,056,515.63 9/30/2023 1.07%1,820.74$ 4,781.92$ 2,932.91$ 365US Treasury 91282CAW1 Gov. Agency Debenture 7/15/2021 1,200,000.00 1,199,437.50 1,147,031.26 11/15/2023 0.27%2,502.72$ 3,107.52$ 816.83$ 411American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 960,463.79 6/27/2024 2.12%72,733.34$ 55,189.68$ 5,367.28$ 636JP Morgan Chase 46625HRS1 Gov. Agency Debenture 9/23/2022 500,000.00 474,660.00 464,179.21 4,355.56 3/15/2026 4.70%(4,355.56)$ -$ 446.63$ 1262Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 959,787.36 7/15/2024 1.64%62,483.33$ 51,828.99$ 5,003.43$ 654
Caterpillar Financial Serv 14913Q2V0 Corporate Bond 2/23/2021 1,000,000.00 1,077,370.00 973,305.92 5/17/2024 0.44%35,150.00$ 6,129.72$ 1,146.21$ 595FNMA3135G0V75Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,053,162.83 7/2/2024 1.63%52,456.25$ 48,706.74$ 4,540.04$ 641US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 982,792.66 1/5/2024 2.12%88,218.75$ 54,380.13$ 5,443.93$ 462FHLB3133834G3Gov. Agency Debenture 3/11/2021 1,400,000.00 1,460,522.00 1,379,349.69 6/9/2023 0.19%37,022.22$ 3,664.98$ 708.36$ 252FFCB3133EKQA7Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 957,920.18 9/10/2024 1.66%60,031.11$ 45,130.78$ 4,223.84$ 711PNC Financial 69349LAM0 Corporate Bond 2/7/2022 1,000,000.00 1,033,470.00 994,488.14 6/25/2023 1.49%17,733.33$ 5,372.34$ 3,456.33$ 268FHLB3135G05X7Gov. Agency Debenture 6/10/2022 1,200,000.00 1,102,952.40 1,072,980.47 8/25/2025 3.04%937.50$ 1,902.68$ 8,752.32$ 1060Treasury912828ZL7Gov. Agency Debenture 4/12/2022 1,700,000.00 1,583,927.57 1,539,894.53 4/30/2025 2.72%316.99$ 9,611.14$ 11,192.72$ 943JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,383,451.22 2/1/2024 2.39%154,913.89$ 96,022.89$ 8,737.99$ 489American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 591,917.98 5/10/2023 1.75%28,145.00$ 25,034.14$ 2,656.45$ 222Treasury912828V23US Treasury Note 11/29/2021 1,000,000.00 1,032,933.04 975,390.62 12/31/2023 0.66%13,206.52$ 3,924.44$ 1,695.07$ 457
Treasury 91282CBE0 2 Gov. Agency Debenture 10/7/2021 1,000,000.00 994,768.98 947,851.56 1/15/2024 0.36%964.67$ 2,587.41$ 894.89$ 472FHLB3130ALH98Gov. Agency Debenture 2/26/2021 1,000,000.00 997,610.00 941,164.91 2/26/2024 0.33%3,750.00$ 4,416.63$ 830.94$ 514Treasury912828M80US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 998,087.75 11/30/2022 1.81%57,158.47$ 53,444.10$ 4,578.08$ 61Treasury912828U57US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 975,781.25 11/30/2023 1.84%60,208.33$ 54,014.24$ 4,666.02$ 426Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 964,570.31 4/30/2024 1.75%51,703.30$ 48,922.73$ 4,929.78$ 578Treasury912828XT2US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 963,085.94 5/31/2024 1.64%51,639.34$ 44,208.50$ 4,180.04$ 609American Honda 02665WCQ2 Corporate Bond 9/14/2021 950,000.00 1,012,871.00 941,710.15 10/10/2023 0.41%19,705.90$ 3,232.93$ 1,029.17$ 375FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,475,983.77 12/21/2023 2.12%121,348.96$ 64,945.24$ 5,761.78$ 447Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,543,058.90 2/8/2023 1.82%117,606.25$ 86,008.42$ 7,180.38$ 131Treasury91282CBE0Gov. Agency Debenture 9/15/2021 650,000.00 647,615.46 616,103.51 1/15/2024 0.28%675.62$ 1,447.14$ 462.28$ 472
Subtotal 46,200,000.00$ 46,636,111.54$ 44,571,200.34$ 14,700.67$ 1,550,668.07$ 1,103,488.93$ 147,201.46$
BNY MM Money Market 124,284.61 124,284.61 0.00%1
LAIF State Investment Pool 6,918,398.79 6,918,398.79 1.51%23,540.77 1
$53,678,794.94 $51,613,883.74 1,550,668.07$ 1,103,488.93$ 170,742.23$
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 181,717.79$
Maturity Profile Amount0-1 year $20,180,521.161-2 years $25,411,172.152-3 years $5,006,976.853-5 years 3,080,124.78$ $53,678,794.94
Amortized
Institution Cost BNY Assets $46,636,111.54BNY MM 124,284.61
LAIF 6,918,398.79Totals:$53,678,794.94
Market to Cost Position Report
Page 5
Town of Los Gatos
Summary Investment Information
August 31, 2022
Weighted Average YTM Portfolio Yield: 1.49%Weighted Average Maturity (days)429
This Month Last Month One year ago
Portfolio Balance $65,471,423 $67,683,852 $61,207,129
Benchmarks/ References:
Town's Average Yield 1.49%1.37%1.32%
LAIF Yield for month 1.28%1.09%0.22%
3 mo. Treasury 2.95%2.41%0.05%
6 mo. Treasury 3.36%2.88%0.06%
2 yr. Treasury 3.50%2.89%0.21%
5 yr. Treasury (most recent)3.35%2.68%0.78%
10 Yr. Treasury 3.20%2.65%1.31%
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
Month YTDFund Balances - Beginning of Month/Period $67,683,851.97 $72,886,942.83
Receipts 2,581,038.80 8,626,268.66Disbursements(4,793,467.49)(16,041,788.21)
Fund Balances - End of Month/Period $65,471,423.28 $65,471,423.28
Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy
BNY MM $77,171.39 0.14%20% of Town Portfolio
US Treasury Notes $10,369,012.75 19.32%No Max. on US Treasuries
Government Agency Debenture Notes $22,975,336.40 42.80%No Max. on Non-Mortgage BackedCorporate Medium Term Bonds $13,336,173.01 24.85%30% of Town PortfolioLocal Agency Investment Fund $6,918,398.79 12.89%$75 M per State Law
Subtotal - Investments 53,676,092.34 100.00%
Reconciled Demand Deposit Balances 11,795,330.94
Total Treasurer's Fund $65,471,423.28
Town of Los Gatos
August 31, 2022
Portfolio Allocation & Treasurer's Fund Balances
BNY MM0.14%US Treasury Notes19.32%
Government Agency Debenture Notes42.80%
Corporate Medium Term Bonds24.8%
Local Agency Investment Fund12.9%
Portfolio Investment Allocation
0
10000000
20000000
30000000
40000000
50000000
60000000
70000000
80000000
90000000
Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22 Aug-22
Treasurer's Fund Balances
page 2
AUG 22 AUG 22 AUG 22
Beginning Deposits Interest/Ending
Balance Realized Gain/Adj.Earnings Withdrawals Balance
Non-Treasury Funds:`
Cert. of Participation 2002 Series A Reserve Fund 686,739.26 578.63 687,317.89$ Note 1
Cert. Of Participation 2010 Ser A Lease Pymt Fund 1,087,362.50 132.01 1,087,362.50 132.01$ Note 1
Cert. of Participation 2002 Lease Payment Fund 551,462.50 65.79 551,462.50 65.79$ Note 1
Cert. of Participation 2010 Series Reserve Fund 1,278,873.31 1,315.24 1,280,188.55 Note 2Total Restricted Funds:3,604,437.57$ -$ 2,091.67$ 1,638,825.00$ 1,967,704.24$
CEPPT IRS Section 115 Trust 700,570.36 (22,680.06)0.00 677,890.30
Grand Total COP's and CEPPT Trust 4,305,007.93$ -$ (20,588.39)$ 1,638,825.00$ 2,645,594.54$
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 post employment benefits.
Town of Los GatosNon-Treasury Restricted Fund BalancesAugust 31, 2022
Page 3
Town of Los Gatos
Statement of Interest Earned
August 31, 2022
Interest by Month
July 2022 $60,107.76
August 2022 61,456.65
September 2022
October 2022
November 2022
December 2022
January 2023
February 2023
March 2023
April 20203
May 2023
June 2023
$121,564.41
Page 4
Town of Los Gatos Investment Schedule August 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 963,320.31 10/15/2023 0.33%990.44$ 3,260.06$ 553.76$ 410Toyota Motor Credit 89236THA6_1 Corporate Bond 04/12/21 500,000.00 510,580.00 488,090.12 8/25/2023 0.45%9,243.75$ 2,780.30$ 388.24$ 359
Toyota Motor Credit 89236THA6 Corporate Bond 1/11/2022 1,100,000.00 1,107,315.00 1,073,798.26 8/25/2023 0.94%9,240.00$ 4,812.29$ 1,755.07$ 359US Treasury 91282CDD0 US Treasury Note 1/13/2022 1,100,000.00 1,090,675.78 1,061,585.93 10/31/2023 0.85%1,219.27$ 4,286.54$ 1,581.94$ 426US Treasury 91282CCN9 US Treasury Note 1/13/2022 1,200,000.00 1,188,375.00 1,164,000.00 7/31/2023 0.75%823.37$ 4,153.18$ 1,532.72$ 334FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 981,098.07 2/23/2024 1.90%73,775.83$ 55,756.94$ 3,252.05$ 541FFCB3133EMBE1Gov. Agency Debenture 10/8/2020 1,600,000.00 1,598,000.00 1,515,962.93 3/28/2024 0.34%7,053.34$ 9,279.41$ 913.21$ 575FFCB3133EMCQ3Gov. Agency Debenture 10/16/2020 2,000,000.00 1,998,000.00 1,923,113.90 10/13/2024 0.31%8,353.33$ 10,396.24$ 1,036.28$ 774BankAmerica Corp 06051GHC6 Corporate Bond 10/9/2020 1,300,000.00 1,366,287.00 1,295,197.48 12/20/2023 0.66%66,279.92$ 31,569.88$ 3,111.82$ 476Home Depot 437076BM3 Corporate Bond 8/4/2022 1,000,000.00 991,960.00 970,739.39 10,250.00 1/1/2026 3.04%(10,250.00)$ -$ 2,393.40$ 1219Home Depot 912828ZW3 US Treasury Note 8/9/2022 350,000.00 322,096.88 319,798.83 95.11 6/30/2025 3.16%(95.11)$ -$ 634.05$ 1034
IBM 459200JY8 Corporate Bond 3/25/2021 1,000,000.00 1,071,040.00 987,684.83 5/15/2024 0.71%34,166.67$ 9,358.41$ 1,255.89$ 623US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 494,296.88 4/30/2023 1.77%22,984.04$ 26,507.80$ 1,502.27$ 242Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 1,986,759.14 6/19/2023 1.79%160,416.67$ 107,829.55$ 6,207.46$ 292FFCB3133EKVF0Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 994,819.42 1/17/2023 1.89%55,989.58$ 55,482.90$ 3,202.92$ 139Treasury912828L57US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 1,199,487.73 9/30/2022 2.09%56,516.39$ 63,644.66$ 3,674.09$ 30US Treasury 91282CDA6 Gov. Agency Debenture 1/31/2022 1,100,000.00 1,085,222.44 1,062,617.18 9/30/2023 1.07%445.74$ 4,781.92$ 1,976.53$ 395US Treasury 91282CAW1 Gov. Agency Debenture 7/15/2021 1,200,000.00 1,199,437.50 1,155,093.74 11/15/2023 0.27%2,502.72$ 3,107.52$ 550.47$ 441American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 975,141.05 6/27/2024 2.12%72,733.34$ 55,189.68$ 3,617.08$ 666JP Morgan Chase 46625HJE1 Gov. Agency Debenture 2/11/2020 900,000.00 934,587.00 900,099.56 9/23/2022 1.74%61,912.50$ 38,210.60$ 2,723.05$ 23Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 974,353.77 7/15/2024 1.64%62,483.33$ 51,828.99$ 3,371.88$ 684Caterpillar Financial Serv 14913Q2V0 Corporate Bond 2/23/2021 1,000,000.00 1,077,370.00 984,524.44 5/17/2024 0.44%35,150.00$ 6,129.72$ 772.44$ 625
FNMA 3135G0V75 Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,067,213.17 7/2/2024 1.63%52,456.25$ 48,706.74$ 3,059.59$ 671US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 995,128.01 1/5/2024 2.12%88,218.75$ 54,380.13$ 3,668.74$ 492FHLB3133834G3Gov. Agency Debenture 3/11/2021 1,400,000.00 1,460,522.00 1,386,298.19 6/9/2023 0.19%37,022.22$ 3,664.98$ 477.37$ 282FFCB3133EKQA7Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 971,772.51 9/10/2024 1.66%49,631.11$ 45,130.78$ 2,846.50$ 741PNC Financial 69349LAM0 Corporate Bond 2/7/2022 1,000,000.00 1,033,470.00 998,771.46 6/25/2023 1.49%17,733.33$ 5,372.34$ 2,329.27$ 298FHLB3135G05X7Gov. Agency Debenture 6/10/2022 1,200,000.00 1,102,952.40 1,094,574.72 8/25/2025 3.04%937.50$ 1,902.68$ 5,898.30$ 1090Treasury912828ZL7Gov. Agency Debenture 4/12/2022 1,700,000.00 1,583,927.57 1,566,058.60 4/30/2025 2.72%316.99$ 9,611.14$ 7,542.92$ 973JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,405,397.60 2/1/2024 2.39%154,913.89$ 96,022.89$ 5,888.64$ 519American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 591,503.28 5/10/2023 1.75%28,145.00$ 25,034.14$ 1,790.22$ 252Treasury912828V23US Treasury Note 11/29/2021 1,000,000.00 1,032,933.04 983,984.38 12/31/2023 0.66%13,206.52$ 3,924.44$ 1,142.33$ 487Treasury91282CBE0 2 Gov. Agency Debenture 10/7/2021 1,000,000.00 994,768.98 955,234.38 1/15/2024 0.36%964.67$ 2,587.41$ 603.08$ 502
FHLB 3130ALH98 Gov. Agency Debenture 2/26/2021 1,000,000.00 997,610.00 948,590.09 2/26/2024 0.33%3,750.00$ 4,416.63$ 559.98$ 544Treasury912828M80US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 997,942.90 11/30/2022 1.81%57,158.47$ 53,444.10$ 3,085.23$ 91Treasury912828U57US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 983,867.19 11/30/2023 1.84%60,208.33$ 54,014.24$ 3,144.49$ 456Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 976,445.31 4/30/2024 1.75%51,703.30$ 48,922.73$ 3,322.24$ 608Treasury912828XT2US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 975,273.44 5/31/2024 1.64%51,639.34$ 44,208.50$ 2,816.99$ 639American Honda 02665WCQ2 Corporate Bond 9/14/2021 950,000.00 1,012,871.00 948,376.01 10/10/2023 0.41%19,705.90$ 3,232.93$ 693.57$ 405FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,488,729.56 12/21/2023 2.12%121,348.96$ 64,945.24$ 3,882.94$ 477Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,544,306.76 2/8/2023 1.82%117,606.25$ 86,008.42$ 4,838.95$ 161Treasury91282CBE0Gov. Agency Debenture 9/15/2021 650,000.00 647,615.46 620,902.35 1/15/2024 0.28%675.62$ 1,447.14$ 311.54$ 502
Subtotal 46,100,000.00$ 46,680,522.16$ 44,971,952.87$ 10,345.11$ 1,659,277.52$ 1,205,344.19$ 103,909.51$
BNY MM Money Market 77,171.39 77,171.39 0.00%1LAIFState Investment Pool 6,918,398.79 6,918,398.79 1.28%15,864.43 1
$53,676,092.34 $51,967,523.05 1,659,277.52$ 1,205,344.19$ 119,773.94$
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$
Total Investments "Matured"1,790.47$
Total Interest FY 22_23 Matured and Current 121,564.41$
Maturity Profile Amount0-1 year $21,180,760.90
1-2 years $24,462,214.592-3 years $6,026,756.853-5 years 991,960.00$ $52,661,692.34
AmortizedInstitution Cost BNY Assets $46,680,522.16
BNY MM 77,171.39LAIF6,918,398.79Totals:$53,676,092.34
Market to Cost Position Report
Page 5
Town of Los Gatos
Summary Investment Information
July 31, 2022
Weighted Average YTM Portfolio Yield: 1.37%Weighted Average Maturity (days)426
This Month Last Month One year ago
Portfolio Balance $67,683,852 $72,886,943 $61,422,761
Benchmarks/ References:
Town's Average Yield 1.37%1.37%1.32%
LAIF Yield for month 1.09%0.86%0.22%
3 mo. Treasury 2.41%1.71%0.05%
6 mo. Treasury 2.88%2.52%0.05%
2 yr. Treasury 2.89%2.96%0.19%
5 yr. Treasury (most recent)2.68%3.04%0.69%
10 Yr. Treasury 2.65%3.02%1.47%
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
Month YTDFund Balances - Beginning of Month/Period $72,886,942.83 $72,886,942.83
Receipts 6,045,229.86 6,045,229.86Disbursements(11,248,320.72)(11,248,320.72)
Fund Balances - End of Month/Period $67,683,851.97 $67,683,851.97
Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy
BNY MM $292,775.99 0.55%20% of Town Portfolio
US Treasury Notes $10,046,915.87 18.75%No Max. on US Treasuries
Government Agency Debenture Notes $22,975,336.40 42.89%No Max. on Non-Mortgage BackedCorporate Medium Term Bonds $13,339,223.01 24.90%30% of Town PortfolioLocal Agency Investment Fund $6,918,398.79 12.91%$75 M per State Law
Subtotal - Investments 53,572,650.06 100.00%
Reconciled Demand Deposit Balances 14,111,201.91
Total Treasurer's Fund $67,683,851.97
Town of Los Gatos
Portfolio Allocation & Treasurer's Fund Balances
July 31, 2022
BNY MM0.55%US Treasury Notes18.75%
Government Agency Debenture Notes42.89%
Corporate Medium Term Bonds24.9%
Local Agency Investment Fund12.9%
Portfolio Investment Allocation
0
10000000
20000000
30000000
40000000
50000000
60000000
70000000
80000000
90000000
Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 Apr-22 May-22 Jun-22 Jul-22
Treasurer's Fund Balances
page 2
JULY 22 JULY 22 JULY 22
Beginning Deposits Interest/Ending
Balance Realized Gain/Adj.Earnings Withdrawals Balance
Non-Treasury Funds:`
Cert. of Participation 2002 Series A Reserve Fund 686,433.38 305.88$ 686,739.26$ Note 1
Cert. Of Participation 2010 Ser A Lease Pymt Fund 0.65 1,087,361.85 1,087,362.50$ Note 1
Cert. of Participation 2002 Lease Payment Fund 0.16 551,462.34 551,462.50$ Note 1
Cert. of Participation 2010 Series Reserve Fund 1,278,000.08 873.23 1,278,873.31 Note 2Total Restricted Funds:1,964,434.27$ 1,638,824.19$ 1,179.11$ -$ 3,604,437.57$
CEPPT IRS Section 115 Trust 676,150.03 24,420.33 0.00 700,570.36
Grand Total COP's and CEPPT Trust 2,640,584.30$ 1,638,824.19$ 25,599.44$ -$ 4,305,007.93$
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 post employment benefits.
Town of Los GatosNon-Treasury Restricted Fund BalancesJuly 31, 2022
Page 3
Town of Los Gatos
Statement of Interest Earned
July 31, 2022
Interest by Month
July 2022 $60,107.76
August 2022
September 2022
October 2022
November 2022
December 2022
January 2023
February 2023
March 2023
April 20203
May 2023
June 2023
$60,107.76
Page 4
Town of Los Gatos Investment Schedule July 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 966,757.81 10/15/2023 0.33%990.44$ 3,260.06$ 276.88$ 441Toyota Motor Credit 89236THA6_1 Corporate Bond 04/12/21 500,000.00 510,580.00 491,158.32 8/25/2023 0.45%5,868.75$ 2,780.30$ 194.12$ 390
Toyota Motor Credit 89236THA6 Corporate Bond 1/11/2022 1,100,000.00 1,107,315.00 1,080,548.30 8/25/2023 0.94%1,815.00$ 4,812.29$ 877.54$ 390US Treasury 91282CDD0 US Treasury Note 1/13/2022 1,100,000.00 1,090,675.78 1,065,539.07 10/31/2023 0.85%1,219.27$ 4,286.54$ 790.97$ 457US Treasury 91282CCN9 US Treasury Note 1/13/2022 1,200,000.00 1,188,375.00 1,166,437.50 7/31/2023 0.75%823.37$ 4,153.18$ 766.36$ 365FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 988,757.79 2/23/2024 1.90%62,625.83$ 55,756.94$ 1,626.03$ 572FFCB3133EMBE1Gov. Agency Debenture 10/8/2020 1,600,000.00 1,598,000.00 1,534,039.87 3/28/2024 0.34%7,053.34$ 9,279.41$ 456.61$ 606FFCB3133EMCQ3Gov. Agency Debenture 10/16/2020 2,000,000.00 1,998,000.00 1,935,042.84 10/13/2024 0.31%8,353.33$ 10,396.24$ 518.14$ 805BankAmerica Corp 06051GHC6 Corporate Bond 10/9/2020 1,300,000.00 1,366,287.00 1,296,544.02 12/20/2023 0.66%66,279.92$ 31,569.88$ 1,555.91$ 507IBM 459200HG9 Corporate Bond 8/8/2019 1,000,000.00 995,010.00 1,000,000.00 8/1/2022 2.05%46,510.42$ 59,141.32$ 1,734.51$ 1IBM 459200JY8 Corporate Bond 3/25/2021 1,000,000.00 1,071,040.00 994,068.43 5/15/2024 0.71%34,166.67$ 9,358.41$ 627.95$ 654US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 494,921.88 4/30/2023 1.77%22,984.04$ 26,507.80$ 751.14$ 273Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 1,993,735.16 6/19/2023 1.79%160,416.67$ 107,829.55$ 3,103.73$ 323FFCB3133EKVF0Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 994,917.05 1/17/2023 1.89%55,989.58$ 55,482.90$ 1,601.46$ 170Treasury912828L57US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 1,199,057.11 9/30/2022 2.09%56,516.39$ 63,644.66$ 1,837.04$ 61US Treasury 91282CDA6 Gov. Agency Debenture 1/31/2022 1,100,000.00 1,085,222.44 1,066,011.72 9/30/2023 1.07%445.74$ 4,781.92$ 988.26$ 426US Treasury 91282CAW1 Gov. Agency Debenture 7/15/2021 1,200,000.00 1,199,437.50 1,159,500.00 11/15/2023 0.27%2,502.72$ 3,107.52$ 275.24$ 472American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 982,700.65 6/27/2024 2.12%60,733.34$ 55,189.68$ 1,808.54$ 697JP Morgan Chase 46625HJE1 Gov. Agency Debenture 2/11/2020 900,000.00 934,587.00 900,823.91 9/23/2022 1.74%61,912.50$ 38,210.60$ 1,361.53$ 54Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 984,036.55 7/15/2024 1.64%50,983.33$ 51,828.99$ 1,685.94$ 715Caterpillar Financial Serv 14913Q2V0 Corporate Bond 2/23/2021 1,000,000.00 1,077,370.00 995,968.94 5/17/2024 0.44%35,150.00$ 6,129.72$ 386.22$ 656FNMA3135G0V75Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,077,972.84 7/2/2024 1.63%52,456.25$ 48,706.74$ 1,529.80$ 702
US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 1,003,078.28 1/5/2024 2.12%71,343.75$ 54,380.13$ 1,834.37$ 523FHLB3133834G3Gov. Agency Debenture 3/11/2021 1,400,000.00 1,460,522.00 1,389,660.92 6/9/2023 0.19%37,022.22$ 3,664.98$ 238.69$ 313FFCB3133EKQA7Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 981,794.31 9/10/2024 1.66%49,631.11$ 45,130.78$ 1,423.25$ 772PNC Financial 69349LAM0 Corporate Bond 2/7/2022 1,000,000.00 1,033,470.00 1,005,428.34 6/25/2023 1.49%17,733.33$ 5,372.34$ 1,164.63$ 329FHLB3135G05X7Gov. Agency Debenture 6/10/2022 1,200,000.00 1,102,952.40 1,112,130.08 1,312.50 8/25/2025 3.04%(1,312.50)$ 1,902.68$ 2,949.15$ 1121Treasury912828ZL7Gov. Agency Debenture 4/12/2022 1,700,000.00 1,583,927.57 1,589,167.97 4/30/2025 2.72%316.99$ 9,611.14$ 3,771.46$ 1004JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,416,853.45 2/1/2024 2.39%127,788.89$ 96,022.89$ 2,944.32$ 550American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 594,901.12 5/10/2023 1.75%28,145.00$ 25,034.14$ 895.11$ 283
Treasury 912828V23 US Treasury Note 11/29/2021 1,000,000.00 1,032,933.04 989,960.94 12/31/2023 0.66%13,206.52$ 3,924.44$ 571.16$ 518Treasury91282CBE0_2 Gov. Agency Debenture 10/7/2021 1,000,000.00 994,768.98 959,843.75 1/15/2024 0.36%964.67$ 2,587.41$ 301.54$ 533FHLB3130ALH98Gov. Agency Debenture 2/26/2021 1,000,000.00 997,610.00 961,515.73 2/26/2024 0.33%2,500.00$ 4,416.63$ 279.99$ 575
Treasury 912828M80 US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 997,656.25 11/30/2022 1.81%57,158.47$ 53,444.10$ 1,542.61$ 122Treasury912828U57US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 989,335.94 11/30/2023 1.84%60,208.33$ 54,014.24$ 1,572.25$ 487Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 983,945.31 4/30/2024 1.75%51,703.30$ 48,922.73$ 1,661.12$ 639Treasury912828XT2US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 983,750.00 5/31/2024 1.64%51,639.34$ 44,208.50$ 1,408.49$ 670American Honda 02665WCQ2 Corporate Bond 9/14/2021 950,000.00 1,012,871.00 955,372.65 10/10/2023 0.41%19,705.90$ 3,232.93$ 346.79$ 436FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,499,882.07 12/21/2023 2.12%121,348.96$ 64,945.24$ 1,941.47$ 508Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,545,814.19 2/8/2023 1.82%100,168.75$ 86,008.42$ 2,419.47$ 192Treasury91282CBE0Gov. Agency Debenture 9/15/2021 650,000.00 647,615.46 623,898.44 1/15/2024 0.28%675.62$ 1,447.14$ 155.77$ 533
Subtotal 45,750,000.00$ 46,361,475.28$ 44,952,529.50$ 1,312.50$ 1,605,745.55$ 1,264,485.51$ 52,175.54$
BNY MM Money Market 292,775.99 292,775.99 0.00%1LAIFState Investment Pool 6,918,398.79 6,918,398.79 1.09%7,932.22 1
$53,572,650.06 $52,163,704.28 1,605,745.55$ 1,264,485.51$ 60,107.76$
Matured Assets
Total Investments "Matured"-$
Total Interest FY 20_21 Matured and Current 60,107.76$
Maturity Profile Amount0-1 year $20,773,480.501-2 years $27,094,509.59
2-3 years $4,601,707.573-5 years 1,102,952.40$ $53,572,650.06
AmortizedInstitution Cost BNY Assets $46,361,475.28BNY MM 292,775.99
LAIF 6,918,398.79Totals:$53,572,650.06
Market to Cost Position Report
Page 5