05 Staff Report. Financial and Investment Report November 2024 with attachments
PREPARED BY: Eric Lemon
Finance and Accounting Manager
Reviewed by: Town Manager, Town Attorney, and Finance Director
110 E. Main Street Los Gatos, CA 95030 ● 406-354-6832
www.losgatosca.gov
TOWN OF LOS GATOS
COUNCIL AGENDA REPORT
MEETING DATE: 01/21/2025 ITEM NO: 5
DATE:
January 14, 2025
TO: Mayor and Town Council
FROM: Chris Constantin, Town Manager
SUBJECT: Receive the Monthly Financial and Investment Report for November 2024
RECOMMENDATION:
Receive the monthly Financial and Investment Report for November 2024.
BACKGROUND:
California Government Code Section 41004 requires that the Town Treasurer submit to the
Town Clerk and the legislative body a written report and accounting of all receipts,
disbursements, and fund balances. The Finance Director assumes the Town Treasurer role.
Attachment 1 contains the November 2024 monthly Financial and Investment Report which
fulfills this requirement.
The November 2024 Monthly Financial and Investment Report was received by the Finance
Commission at its January 13, 2025, special meeting.
DISCUSSION:
The November 2024 Monthly Financial and Investment Report includes a Fund Balance
Schedule, representing estimated funding available for all funds at the beginning of the fiscal
year and at the end of the respective month.
As operations fluctuate month to month, there are differences between balances in one month
to balances in another. Such differences may be significant due to the type of activity in those
months and the timing of any estimates used in the presentation based on the information
available. This is demonstrated by the attached November 30, 2024, fund balance report.
PAGE 2 OF 3 SUBJECT: Monthly Financial and Investment Report for November 2024 DATE: January 14, 2025
In the case that the differences are extraordinary and unanticipated, we will ensure we present
more information to explain the differences.
The November 30, 2024, estimated fund balances differ from the October 31, 2024 estimated
fund balances due to the normal day-to-day activity where revenue and expenditure activity in
one month have a larger shift in one month from the other.
Please note that the amount in the Fund Schedule differs from the Portfolio Allocation and
Treasurer’s Cash Fund Balances Summary schedule because assets and liabilities are
components of the Fund Balance.
As illustrated in the summary below, Total Cash is adjusted by adding Total Assets less the
amount of Total Liabilities to arrive at the Ending Fund Balance – which represents the actual
amount of funds available.
As of November 30, 2024, the Town’s financial position (Assets $86.24M, Liabilities $29.20M,
and Fund Equity $57.04M) remains strong and the Town has sufficient funds to meet the cash
demands for the next six months.
As of November 30, 2024, the Town’s weighted portfolio yield for investments under
management was 4.45% which was 3 basis points below the Local Agency Investment Fund
(LAIF) yield of 4.48% for the same reporting period. As of October 31, 2024, the LAIF portfolio’s
weighted average maturity (WAM) is 257 days versus the Town’s longer WAM of 676 days on
November 30, 2024. The longer WAM for Town assets under management reflects the Town’s
strategy to take advantage of higher yields associated with longer maturities balanced with
shorter-term yields available on investments held with the State’s LAIF. The Town’s weighted
average rate of return on investments under management of 4.45% at the close of November
remained flat when compared to the October 31, 2024, investment report.
Since November 2023, LAIF yields have climbed from 384 basis points (3.84%) to 448 basis
points (4.48%) through the end of November 2024. The State LAIF pool typically lags the market
when current market yields are either increasing or decreasing.
After the rate change back in July of 2023, the Federal Open Market Committee (FOMC) did not
change rates again until their September 18, 2024, meeting when they approved a 1/2
PAGE 3 OF 3 SUBJECT: Monthly Financial and Investment Report for November 2024 DATE: January 14, 2025
percentage basis point decrease from 5.5% to 5.0%. Furthermore, on November 7, 2024, the
Federal Reserve voted to approve an additional 1/4 basis point decrease from 5.0% to 4.75%.
The most recent change was at their December 2024 meeting when the Federal Reserve voted
to approve another 1/4 basis point decrease from 4.75% to 4.50%. These changes support the
Federal Open Market Committee’s goal to support maximum employment and bring year-to-
year inflation to its targeted level of 2%.
The economy added only 12,000 jobs in October, less than the 100,000 the market expected
and lowest since December 2020. However, the figure was significantly impacted by
hurricanes Helene and Milton as well as industrial strikes. The unemployment rate remained at
4.1% and the labor force participation rate remained at 63%. Wage growth rose from 3.9% to
4%.
The Town's investments are in compliance with the Town's Investment Policy dated February
21, 2023, and are also in compliance with the requirements of Section 53600 at seq. 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.
CONCLUSION:
Receive the Monthly Financial and Investment Report for November 2024.
Attachments:
1. Financial and Investment Report (November 2024)
Weighted Average YTM Portfolio Yield on Investments
under Management 4.45%
Weighted Average Maturity (days)676
This Month Last Month One year ago
Portfolio Allocation & Treasurer's Cash Balances $69,393,525 $68,118,481 $65,687,227
Managed Investments $50,337,771
Local Agency Investment Fund $11,874,049
Reconciled Demand Deposit Balances $7,181,705
Portfolio Allocation & Treasurer's Cash Balances $69,393,525
Benchmarks/ References:
Town's Average Yield 4.45%4.45%4.20%
LAIF Yield for month 4.48%4.52%3.84%
3 mo. Treasury 4.49%4.54%5.40%
6 mo. Treasury 4.44%4.46%5.41%
2 yr. Treasury 4.15%4.17%4.68%
5 yr. Treasury (most recent)4.05%4.16%4.27%
10 Yr. Treasury 4.17%4.28%4.33%
Town of Los Gatos
Summary Investment Information
November 30, 2024
0 -1 year35%
1 -2 years19%
2 -3 years
22%
3 -5 years24%
Portfolio Maturity Profile
Compliance:The Town's investments are in compliance with the Town's investment policy dated February 21, 2023, and also in compliance with the requirements of Section 53600 at seq. 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.
ATTACHMENT 11
Month YTD
Cash & Investment Balances - Beginning of Month/Period 68,118,481.28$ 81,368,409.88$
Receipts 6,060,311.07 27,373,744.06
Disbursements (4,785,267.59)(39,348,629.18)
Cash & Investment Balances - End of Month/Period $69,393,524.76 $69,393,524.76
Portfolio Allocation Amount % of Portfolio
Max. % or $ Allowed
per State Law or Policy
BNY MM $438,736.64 0.71%20% of Town Portfolio
US Treasury Notes $20,054,713.77 32.23%No Max. on US Treasuries
Government Agency Debenture Notes $15,904,019.60 25.56%No Max. on Non-Mortgage Backed
Corporate Medium Term Bonds $13,940,300.50 22.41%30% of Town Portfolio
Local Agency Investment Fund $11,874,049.16 19.09%$75 M per State Law
Subtotal - Investments 62,211,819.67 100.00%
Reconciled Demand Deposit Balances 7,181,705.09
Total Portfolio Allocation & Treasurer's Cash Balances $69,393,524.76
0.0401
0.0388
Town of Los Gatos
Portfolio Allocation & Treasurer's Cash Balances
November 30, 2024
BNY MM
0.71%
US Treasury Notes32.23%
Government Agency Debenture Notes
25.56%
Corporate Medium Term Bonds
22.41%
Local Agency Investment Fund19.09%
Portfolio Investment Allocation
$65.7 M $69.4 M
$0.0 M
$10.0 M
$20.0 M
$30.0 M
$40.0 M
$50.0 M
$60.0 M
$70.0 M
$80.0 M
$90.0 M
Nov-23 Dec-23 Jan-24 Feb-24 Mar-24 Apr-24 May-24 Jun-24 Jul-24 Aug-24 Sep-24 Oct-24 Nov-24
Treasurer's Fund Balances
2
November 2024 November 2024 November 2024
Beginning Deposits Interest/Ending
Balance Realized Gain/Adj.Earnings Withdrawals Balance
Non-Treasury Funds:
Cert. of Participation 2002 Ser A Reserve Fund 694,631.85$ -$ 2,555.66$ -$ 697,187.51$ Note 1
Cert. of Participation 2010 Ser Lease Payment Fund 972.95 - 3.93 - 976.88 Note 2
Cert. of Participation 2002 Ser A Lease Payment Fund 17,455.59 - 64.25 - 17,519.84 Note 1
Cert. of Participation 2010 Ser Reserve Fund 1,412,837.13 - 5,681.67 - 1,418,518.80 Note 2
Total Restricted Funds:2,125,897.52$ -$ 8,305.51$ -$ 2,134,203.03$
CEPPT IRS Section 115 Trust 2,267,568.84 - 40,212.73 - 2,307,781.57$ Note 3
Grand Total COP's and CEPPT Trust 4,393,466.36$ -$ 48,518.24$ -$ 4,441,984.60$
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 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 Gatos
Non-Treasury Restricted Fund Balances
November 30, 2024
3
July 2024 247,221.75$
August 2024 212,684.25$
September 2024 265,151.31$
October 2024 234,237.63$
November 2024 227,312.31$
December 2024 -$
January 2025 -$
February 2025 -$
March 2025 -$
April 2025 -$
May 2025 -$
June 2025 -$
1,186,607.25$
Town of Los Gatos
Statement of Interest Earned
November 30, 2024
4
Original Issue Market Value Maturity Yield to Interest Interest Interest DaysDepositParOriginal(Discount)Market Above (Under)Purchased Date or Maturity Received Earned Earned toInstitutionCUSIP #Security Coupon Date Value Cost Premium Value Cost Interest Call Date or Call to Date Prior Yrs.Current FY Maturity
Apple 037833DB3 Corporate Bond 2.90%12/20/2022 1,300,000.00 1,228,591.00 (71,409.00)1,253,538.00 24,947.00 6/21/2027 4.19%65,137.22$ 81,871.88$ 22,448.74$ 933Home Depot 437076BM3 Corporate Bond 3.00%8/4/2022 1,000,000.00 991,960.00 (8,040.00)982,250.00 (9,710.00)1/1/2026 3.04%64,750.00$ 61,696.52$ 13,562.60$ 397US Treasury 912828ZW3 US Treasury Note 0.25%8/9/2022 350,000.00 322,096.88 (27,903.12)341,803.00 19,706.12 6/30/2025 3.16%1,654.89$ 19,915.08$ 4,409.56$ 212FFCB3133EN5V8Gov. Agency Debenture 4.13%1/17/2023 236,000.00 239,174.20 3,174.20 235,542.16 (3,632.04)1/11/2027 3.76%14,440.25$ 12,979.52$ 3,746.92$ 772US Treasury 91282CBT7 US Treasury Note 0.75%9/30/2022 800,000.00 712,565.18 (87,434.82)763,688.00 51,122.82 3/31/2026 4.14%12,000.00$ 54,221.52$ 12,982.62$ 486FFCB3133ENP95Gov. Agency Debenture 4.25%9/30/2022 900,000.00 900,939.60 939.60 898,551.00 (2,388.60)9/30/2025 4.14%76,500.00$ 66,415.88$ 15,902.39$ 304JP Morgan Chase 46625HRS1 Corporate Bond 3.20%9/23/2022 500,000.00 474,660.00 (25,340.00)490,275.00 15,615.00 3/15/2026 4.70%27,644.44$ 41,217.45$ 9,762.03$ 470FHLB3135G05X7Gov. Agency Debenture 0.38%6/10/2022 1,200,000.00 1,102,952.40 (97,047.60)1,165,668.00 62,715.60 8/25/2025 3.04%9,937.50$ 71,445.55$ 14,555.48$ 268
US Treasury 912828ZL7 US Treasury Note 0.38%4/12/2022 1,700,000.00 1,583,927.57 (116,072.43)1,672,018.00 88,090.43 4/30/2025 2.72%16,254.49$ 98,544.63$ 18,613.99$ 151FHLB3130AQF65Gov. Agency Debenture 1.25%11/30/2022 1,300,000.00 1,160,559.40 (139,440.60)1,228,006.00 67,446.60 12/21/2026 4.15%25,322.92$ 80,116.59$ 21,207.33$ 751FHLB3130APJH9Gov. Agency Debenture 1.00%1/17/2023 1,000,000.00 907,010.00 (92,990.00)958,270.00 51,260.00 10/28/2026 4.17%18,354.17$ 50,234.10$ 14,501.54$ 697FFCB3133EN5N6Gov. Agency Debenture 4.00%2/8/2023 1,700,000.00 1,706,732.00 6,732.00 1,690,225.00 (16,507.00)1/6/2028 3.91%95,955.56$ 92,733.76$ 27,929.66$ 1132Freddie Mac 3137EAEX3 Gov. Agency Debenture 0.38%5/1/2023 750,000.00 689,032.50 (60,967.50)726,135.00 37,102.50 9/23/2025 3.97%3,921.87$ 32,931.11$ 11,827.37$ 297American Honda 02665WED9 Corporate Bond 4.70%5/11/2023 600,000.00 608,856.00 8,856.00 603,948.00 (4,908.00)1/12/2028 4.34%32,978.33$ 29,982.05$ 11,027.05$ 1138US Treasury 91282CEF4 US Treasury Note 2.50%6/9/2023 1,500,000.00 1,416,626.12 (83,373.88)1,445,745.00 29,118.88 3/31/2027 4.09%49,077.87$ 62,956.31$ 24,889.71$ 851US Treasury 91282CGA3 US Treasury Note 4.00%6/20/2023 2,100,000.00 2,080,558.59 (19,441.41)2,092,503.00 11,944.41 12/15/2025 4.40%82,852.46$ 94,573.28$ 38,483.28$ 380
Colgate-Palmolive 194162AR4 Corporate Bond 4.60%7/14/2023 500,000.00 504,655.00 4,655.00 509,675.00 5,020.00 2/1/2028 4.37%26,002.79$ 21,195.52$ 9,212.82$ 1158
FannieMae 3135G06G3 Gov. Agency Debenture 0.50%7/14/2023 500,000.00 455,157.00 (44,843.00)482,320.00 27,163.00 11/7/2025 4.63%3,284.72$ 21,047.01$ 9,148.27$ 342FFCB3133EPQC2Gov. Agency Debenture 4.63%7/17/2023 500,000.00 501,957.50 1,957.50 502,945.00 987.50 7/17/2026 4.48%23,125.00$ 21,487.97$ 9,420.23$ 594FFCB3133EPBM6Gov. Agency Debenture 4.13%7/14/2023 600,000.00 596,220.00 (3,780.00)598,782.00 2,562.00 8/23/2027 4.29%27,431.25$ 24,754.94$ 10,759.96$ 996PNC Bank 69353RFJ2 Corporate Bond 3.25%7/25/2023 1,000,000.00 921,490.00 (78,510.00)962,450.00 40,960.00 12/23/2027 5.23%32,229.17$ 46,970.90$ 21,074.92$ 1118US Treasury 91282CFU0 US Treasury Note 4.13%7/31/2023 1,300,000.00 1,290,660.60 (9,339.40)1,300,507.00 9,846.40 10/31/2027 4.31%67,031.25$ 51,232.08$ 23,398.53$ 1065Toyota Motor Credit 89236TKL8 Corporate Bond 5.45%8/25/2023 1,600,000.00 1,617,168.00 17,168.00 1,644,640.00 27,472.00 11/10/2027 5.16%105,366.67$ 70,599.88$ 34,844.46$ 1075US Treasury 912810FE3 US Treasury Note 5.50%10/3/2023 1,200,000.00 1,238,207.14 38,207.14 1,260,564.00 22,356.86 8/15/2028 4.76%57,211.96$ 43,179.27$ 24,377.96$ 1354
Pepsico Inc 713448DF2 Corporate Bond 2.85%10/16/2023 1,000,000.00 947,570.00 (52,430.00)981,830.00 34,260.00 11/24/2025 5.24%24,383.33$ 37,712.66$ 22,364.48$ 359
FFCB 3133EPUW3 Gov. Agency Debenture 4.75%10/13/2023 1,000,000.00 994,338.00 (5,662.00)1,008,310.00 13,972.00 9/1/2026 4.96%41,958.33$ 35,367.82$ 20,732.86$ 640Freddie Mac 3137EAEP0 Gov. Agency Debenture 1.50%10/13/2023 1,000,000.00 951,540.00 (48,460.00)994,050.00 42,510.00 2/12/2025 5.32%12,458.33$ 36,644.18$ 21,481.07$ 74US Treasury 91282CEW7 US Treasury Note 3.25%10/16/2023 1,000,000.00 950,039.06 (49,960.94)978,710.00 28,670.94 6/30/2027 4.73%22,961.96$ 32,499.52$ 19,272.97$ 942US Treasury 91282CEN7 US Treasury Note 2.75%10/31/2023 1,300,000.00 1,214,336.39 (85,663.61)1,258,816.00 44,479.61 4/30/2027 4.82%35,750.00$ 40,101.59$ 25,249.15$ 881US Treasury 912828YV6 US Treasury Note 1.50%11/15/2023 700,000.00 673,667.97 (26,332.03)700,000.00 26,332.03 11/30/2024 5.26%10,930.33$ 22,316.65$ 14,975.65$ 0US Treasury 91282CAB7 US Treasury Note 0.25%11/15/2023 675,000.00 623,900.39 (51,099.61)656,781.75 32,881.36 7/31/2025 4.92%1,196.84$ 19,725.12$ 13,236.59$ 243US Treasury 91282CGU9 US Treasury Note 3.88%11/30/2023 1,000,000.00 983,515.62 (16,484.38)998,040.00 14,524.38 3/31/2025 5.17%32,291.67$ 29,822.81$ 21,422.02$ 121
US Treasury 91282CCH2 US Treasury Note 1.25%12/21/2023 900,000.00 798,647.55 (101,352.45)814,644.00 15,996.45 6/30/2028 3.99%5,930.71$ 17,690.14$ 14,096.83$ 1308
FNMA 3135G0Q22 Gov. Agency Debenture 1.88%12/21/2023 900,000.00 845,676.00 (54,324.00)864,180.00 18,504.00 9/24/2026 4.22%12,796.88$ 19,224.14$ 15,319.24$ 663US Treasury 91282CFB2 US Treasury Note 2.75%1/2/2024 1,000,000.00 960,354.91 (39,645.09)965,120.00 4,765.09 7/31/2027 3.95%15,917.12$ 19,025.75$ 16,171.88$ 973US Treasury 91282CHE4 US Treasury Note 3.63%1/17/2024 1,800,000.00 1,775,185.72 (24,814.28)1,771,164.00 (4,021.72)5/31/2028 3.97%56,692.63$ 32,061.96$ 29,730.18$ 1278JP Morgan Chase 46647PDG8 Corporate Bond 4.85%2/1/2024 1,400,000.00 1,396,528.00 (3,472.00)1,402,520.00 5,992.00 7/25/2027 4.93%32,825.10$ 28,319.94$ 28,886.34$ 967US Bancorp 91159HJF8 Corporate Bond 4.55%2/5/2024 1,000,000.00 989,200.00 (10,800.00)995,140.00 5,940.00 7/22/2027 4.89%21,097.67$ 19,440.46$ 20,372.53$ 964Treasury91282CHB0US Treasury Note 3.63%2/23/2024 1,175,000.00 1,151,962.92 (23,037.08)1,164,577.75 12,614.83 5/15/2026 4.56%30,892.17$ 18,568.45$ 22,195.10$ 531FHLB3130AXB31Gov. Agency Debenture 4.88%2/27/2024 1,000,000.00 1,003,060.00 3,060.00 1,006,710.00 3,650.00 3/13/2026 4.72%27,354.17$ 16,052.33$ 19,806.50$ 468FFCB3133EP5U5Gov. Agency Debenture 4.13%3/28/2024 1,700,000.00 1,687,981.00 (12,019.00)1,697,246.00 9,265.00 3/20/2029 4.28%33,504.17$ 18,681.03$ 30,406.36$ 1571
US Treasury 9128285M8 US Treasury Note 3.13%4/30/2024 1,200,000.00 1,123,832.14 (76,167.86)1,157,256.00 33,423.86 11/15/2028 4.69%20,295.34$ 9,066.06$ 22,739.47$ 1446Cisco Systems 17275RBR2 Corporate Bond 4.85%5/15/2024 1,000,000.00 999,130.00 (870.00)1,016,030.00 16,900.00 1/26/2029 4.87%13,606.94$ 6,135.64$ 20,407.66$ 1518Home Depot 437076CW0 Corporate Bond 4.90%5/17/2024 1,000,000.00 1,001,790.00 1,790.00 1,016,640.00 14,850.00 4/15/2029 4.86%20,144.44$ 5,862.95$ 20,387.07$ 1597Treasury91282CJR3US Treasury Note 3.75%5/31/2024 1,200,000.00 1,154,629.02 (45,370.98)1,183,548.00 28,918.98 12/31/2028 4.68%3,708.79$ 4,511.24$ 23,007.35$ 1492American Honda 02665WEY3 Corporate Bond 4.95%6/27/2024 1,000,000.00 995,640.00 (4,360.00)1,003,580.00 7,940.00 1/9/2026 5.25%1,787.50$ 430.16$ 21,938.41$ 405FHLB3130B1BT3Gov. Agency Debenture 4.88%7/2/2024 1,150,000.00 1,150,966.00 966.00 1,159,234.50 8,268.50 8,720.83 6/12/2026 4.82%(8,720.83)$ -$ 22,987.53$ 559Citibank17325FBK3Corporate Bond 4.84%8/15/2024 1,250,000.00 1,263,062.50 13,062.50 1,257,387.50 (5,675.00)1,511.88 7/6/2029 4.60%(1,511.88)$ -$ 16,945.71$ 1679FNMA3135G05Y5Gov. Agency Debenture 0.75%9/10/2024 1,100,000.00 1,010,724.00 (89,276.00)1,002,232.00 (8,492.00)10/8/2027 3.56%641.67$ -$ 8,270.14$ 1042
Subtotal 51,586,000.00$ 49,899,033.87$ (1,686,966.13)$ 50,863,795.66$ 964,761.79$ 10,232.71$ 1,407,358.16$ 1,721,563.43$ 920,490.54$
BNY MM Money Market 438,736.64 438,736.64 0.00 0.00%1LAIFState Investment Pool 11,874,049.16 11,898,522.57 24,473.41 4.48%260,203.58 1
62,211,819.67 $63,201,054.87 $989,235.20 $10,232.71 1,407,358.16$ 1,721,563.43$ 1,180,694.11$
Matured Assets
FNMA 3135G0V75 Gov. Agency Debenture 1.75%10/17/2019 1,100,000.00 1,105,833.30 5,833.30 7/2/2024 1.63%90,956.25$ 84,780.33$ 98.70$ Honeywell Int'l.438516BW5 Corporate Bond 2.30%11/20/2019 1,000,000.00 1,014,660.00 14,660.00 8/15/2024 1.64%108,483.33$ 91,844.87$ 2,508.83$ FFCB 3133EKQA7 Gov. Agency Debenture 2.08%10/21/2019 1,000,000.00 1,019,780.00 19,780.00 9/10/2024 1.66%101,631.11$ 78,691.92$ 3,305.61$
Total Investments "Matured"5,913.13$
Total Interest FY 24_25 Matured and Current 1,186,607.25$
Maturity Profile Amount Percent0-1 year 20,873,417.76$ 34%
1-2 years $11,810,354.19 19%
2-3 years $14,070,181.68 23%3-5 years 14,784,198.07$ 24%$61,538,151.70 100%
Town of Los Gatos
Investment ScheduleNovember 30, 2024
5
Date Cusip/Id Description Transaction Type Settlement Date Par Coupon Maturity Date Price Principal Interest
Transaction Total
11/4/2024 Cash-USD Cash-USD
SHORT TERM INVESTMENT
FUND INCOME 11/4/2024 1,159.84 0.00%100.00 - - 1,159.84
11/7/2024 3135G06G3 FANNIE MAE 0.5% 07NOV2025 BOND INTEREST 11/7/2024 500,000.00 0.50%11/7/2025 - - 1,250.00 1,250.00
11/12/2024 89236TKL8 TOYOTA MOTOR CREDIT CORP 5.45% 10NOV2027 BOND INTEREST 11/12/2024 1,600,000.00 5.45%11/10/2027 - - 43,600.00 43,600.00
11/15/2024 91282CHB0 USA TREASURY 3.625% 15MAY2026 BOND INTEREST 11/15/2024 1,175,000.00 3.63%5/15/2026 - - 21,296.88 21,296.88
11/15/2024 9128285M8 USA TREASURY 3.125% 15NOV2028 BOND INTEREST 11/15/2024 1,200,000.00 3.13%11/15/2028 - - 18,750.00 18,750.00
Town of Los Gatos
Investment Transaction Detail
November 30, 2024
6
Security Description Maturity Date Par/Shares S&P Rating Moody Rating Insight ESG Rating Environment Social Governance
AMERICAN HONDA FINANCE 4.95% 09JAN2026 1/9/2026 1,000,000$ A-A3 3 3 3 3
PEPSICO INC 2.85% 24FEB2026 (CALLABLE 24NOV25)2/24/2026 1,000,000$ A+A1 2 2 2 3
HOME DEPOT INC. 3% 01APR2026 (CALLABLE 01JAN2026)46113 1,000,000$ A A2 3 3 2 3
JPMORGAN CHASE & CO 3.2 15JUN2026 (CALLABLE 15MAR26)46188 500,000$ A A1 3 1 3 4
APPLE INC. 2.9% 12SEP2027 (CALLABLE 12JUN27)9/12/2027 1,300,000$ AA+Aaa 5 1 4 5
TOYOTA MOTOR CREDIT CORP 5.45% 10NOV2027 11/10/2027 1,600,000$ A+A1 3 2 3 4
AMERICAN HONDA FINANCE 4.7% 12JAN2028 1/12/2028 600,000$ A-A3 3 3 3 3
PNC BANK NA 3.25% 22JAN2028 (CALLABLE 01 FEB28)1/22/2028 1,000,000$ A A2 3 2 3 3
COLGATE-PALMOLIVE CO 4.6% 01MAR2028 (CALLABLE 01FEB28)3/1/2028 500,000$ A+Aa3 3 2 3 3
US BANCORP 4.548% 22JUL2028 (CALLABLE 22JUL27)7/222028 1,000,000$ A A3 4 3 4 4
JPMORGAN CHASE & CO 4.851% 25JUL2028 (CALLABLE 25JUL28)7/25/2028 1,400,000$ A A1 3 1 3 4
CISCO INC. 4.85% 26FEB2029 (CALLABLE 26JAN2029)2/26/2029 1,000,000$ AA-A1 2 1 4 3
HOME DEPOT INC. 4.9% 15APR2029 (CALLABLE 15MAR2029)47223 1,000,000$ A A2 3 3 2 3
CITIBANK 4.838% 06AUG2029 (CALLABLE 06JUL2029)8/6/2029 1,250,000$ A+Aa3 3 1 3 4
Total/Average 14,150,000$ 3.1 2.0 3.0 3.5
*ESG ratings are from 1 to 5, with 1 as the highest rating and 5 as the lowest. All ratings are weighted by industry rankings, based on the importance of the category within the individual industry.
Town of Los Gatos
Insight ESG Ratings as of November 30, 2024
7
Fund Schedule
Fund
Number Fund Description
Current
Revenue
Current
Expenditure
Transfer
In
Transfer
Out
GENERAL FUND
Non-Spendable:
Loans Receivable 159,000 - - - - - 159,000
Restricted Fund Balances:
Pension 2,188,659 - - - - - 2,188,659
Land Held for Resale 344,338 - - - - - 344,338
Committed Fund Balances:
Budget Stabilization 6,736,781 - - - - - 6,736,781
Catastrophic 6,736,781 - - - - - 6,736,781
Pension/OPEB 300,000 - - - - - 300,000
Measure G District Sales Tax 590,581 - - - - - 590,581
Assigned Fund Balances:
Open Space 410,000 - - - - - 410,000
Sustainability 140,553 - - - - - 140,553
Capital/Special Projects 8,651,059 - - - - - 8,651,059
Carryover Encumbrances 85,861 - - - - - 85,861
Compensated Absences 1,555,478 - - - - - 1,555,478
ERAF Risk Reserve 1,430,054 - - - - - 1,430,054
Market Fluctuations 1,712,246 - - - - - 1,712,246
Council Priorities - Economic Recovery 20,684 - - - - - 20,684
Unassigned Fund Balances:
111 Other Unassigned Fund Balance Reserve (Pre YE distribution)- (2,754,488) 5,233,166 (4,882,479) - - (2,403,801)
General Fund Total 31,062,075 (2,754,488) 5,233,166 (4,882,479) - - 28,658,274
* Interfund transfers and Council Priorities/Economic Recovery funding allocation to be performed as part of the fiscal year end closing entries.
November 2024 Prior Year
Carryforward
7/1/2024*
Increase/
(Decrease)
July - October
Estimated Fund
Balance
11/30/2024*
8
Fund Schedule
Fund
Number Fund Description
Current
Revenue
Current
Expenditure
Transfer
In
Transfer
Out
SPECIAL REVENUE
211/212 CDBG 166,653 - - - - - 166,653
222 Urban Runoff (NPDES)754,134 (27,477) 13,641 (29,455) - - 710,843
231-236 Landscape & Lighting Districts 182,625 (5,176) - (4,577) - - 172,872
251 Los Gatos Theatre 171,035 118,177 9,922 (13,810) - - 285,324
711-716 Library Trusts 556,849 50,216 - (7,381) - - 599,684
Special Revenue Total 1,831,296 135,740 23,563 (55,223) - - 1,935,376
CAPITAL PROJECTS
411 GFAR - General Fund Appropriated Reserve 20,253,300 (12,163) 92,974 (333,184) - - 20,000,927
412 Community Center Development 866,281 - - - - - 866,281
421 Grant Funded Projects (2,563,503) 137,377 (3,903) (293,285) - - (2,723,314)
461-463 Storm Basin Projects 3,531,248 16,607 6,340 - - - 3,554,195
471 Traffic Mitigation Projects 509,491 - - - - - 509,491
472 Utility Undergrounding Projects 3,584,251 4,557 - - - - 3,588,808
481 Gas Tax Projects 1,928,167 418,418 164,433 - - - 2,511,018
Capital Projects Total 28,109,235 564,796 259,844 (626,469) - - 28,307,406
INTERNAL SERVICE FUNDS
611 Town General Liability 177,876 (1,326,978) - (165) - - (1,149,267)
612 Workers Compensation 586,246 (570,836) 4,060 - - - 19,470
621 Information Technology 2,523,347 (379,764) 5,602 (102,748) - - 2,046,437
631 Vehicle & Equipment Replacement 3,287,527 (192,327) - (181,027) - - 2,914,173
633 Facility Maintenance 960,526 (210,837) 24,836 (121,063) - - 653,462
Internal Service Funds Total 7,535,522 (2,680,742) 34,498 (405,003) - - 4,484,275
Trust/Agency
942 RDA Successor Agency (4,632,040) (1,713,620) - (2,051) - - (6,347,711)
Trust/Agency Fund Total (4,632,040) (1,713,620) - (2,051) - - (6,347,711)
Total Town 63,906,088 (6,448,314) 5,551,071 (5,971,225) - - 57,037,620
* Interfund transfers and Council Priorities/Economic Recovery funding allocation to be performed as part of the fiscal year end closing entries.
Deposit Accounts of Interest:
111-23541 General Plan Update deposit account balance $433,010.56
111-23521 BMP Housing deposit account balance $4,039,055.78
Prior Year
Carryforward
7/1/2024*
Increase/
(Decrease)
July - October
November 2024 Estimated Fund
Balance
11/30/2024*
9