02 Attachment 1 - FY 2020-21 1Q Investment ReportTown of Los Gatos
Summary Investment Information
September 30, 2020
Weighted Average YTM Portfolio Yield: 1.86%Weighted Average Maturity (days)556
This Month Last Month One year ago
Portfolio Balance $59,981,525 $60,272,540 $61,720,311
Benchmarks/ References:
Town's Average Yield 1.86%1.86%2.02%
LAIF Yield for month 0.69%0.92%2.28%
3 mo. Treasury 0.11%0.11%1.82%
6 mo. Treasury 0.10%0.12%1.82%
2 yr. Treasury 0.13%0.13%1.62%
5 yr. Treasury (most recent)0.28%0.27%1.55%
10 Yr. Treasury 0.69%0.71%1.67%
0 -1 year30%
1 -2 years30%
2 -3 years25%
3 -5 years15%
Portfolio Maturity Profile
Compliance:The Town's investments are in compliance with the Town's investment policy dated November 3, 2020and 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
September 30, 2020 Month YTDFund Balances - Beginning of Month/Period $60,272,540.27 $72,729,892.43
Receipts 4,017,155.42 11,825,725.95Disbursements(4,308,171.03)(24,574,093.72)
Fund Balances - End of Month/Period $59,981,524.66 $59,981,524.66
Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy
BNY MM $340,145.64 0.60%20% of Town Portfolio
US Treasury Notes $7,723,416.42 13.52%No Max. on US Treasuries
Government Agency Debenture Notes $24,340,417.75 42.61%No Max. on Non-Mortgage BackedCorporate Medium Term Bonds $14,514,839.51 25.41%30% of Town PortfolioLocal Agency Investment Fund 10,210,051.74 17.87%$75 M per State Law
Subtotal - Investments 57,128,871.06 100.00%
Reconciled Demand Deposit Balances 2,852,653.60
Total Treasurer's Fund $59,981,524.66
BNY MM0.60%US Treasury Notes13.52%
Government Agency Debenture Notes
42.61%Corporate Medium Term Bonds25.4%
Local Agency Investment Fund17.9%
Portfolio Investment Allocation
60000000
62000000
64000000
66000000
68000000
70000000
72000000
74000000
Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20
Treasurer's Fund Balances
page 2
Town of Los GatosNon-Treasury Restricted Fund BalancesSeptember 30, 2020
SEP 20 SEP 20 SEP 20
Beginning Deposits Interest/Ending
Balance Realized Gain/Adj.Earnings Withdrawals Balance
Non-Treasury Funds:`
Cert. of Participation 2002 Series A Reserve Fund 686,268.48$ 5.89$ -$ 686,274.37$ Note 1
Cert. Of Participation 2010 Ser A Lease Pymt Fund 3.62 0.00 2.51 6.13$ Note 1
Cert. of Participation 2002 Lease Payment Fund 0.15 0.00 0.30 0.45$ Note 1
Cert. of Participation 2010 Series Reserve Fund 1,298,066.97 31.84 1,298,098.81 Note 2Total Restricted Funds:1,984,339.22$ $0.00 $40.54 $0.00 $1,984,379.76
CEPPT IRS Section 115 Trust 688,026.00 0.00 (5,181.38)682,844.62
Grand Total COP's and CEPPT Trust 2,672,365.22$ -$ (5,140.84)$ -$ 2,667,224.38$
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 po
Page 3
Town of Los Gatos
Statement of Interest Earned
September 30, 2020
Interest by Month
July 2020 $78,263.77
August 2020 78,263.76
September 2020 75,077.38
October 2020
November 2020
December 2020
January 2021
February 2021
March 2021
April 2021
May 2021
June 2021
$231,604.91
Page 4
Town of Los Gatos Investment Schedule September 2020
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 Maturity
Treasury 912828WR7 US Treasury Note 4/2/2019 1,000,000.00 995,625.00 1,015,000.00 6/30/2021 2.33%26,474.45$ 28,917.32$ 5,847.02$ 273
Toyota Motor Credit 89236TDP7 Corporate Bond 05/20/19 1,100,000.00 1,102,596.00 1,132,335.35 1/11/2022 2.50%32,651.67$ 30,798.33$ 6,961.78$ 468Toyota Motor Credit 89236TCZ6 Corporate Bond 3/13/2020 500,000.00 504,440.00 504,186.80 4/8/2021 1.06%659.72$ 1,599.24$ 1,349.81$ 190FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 1,066,655.41 2/23/2024 1.90%29,175.83$ 17,466.66$ 4,825.62$ 1241FFCB3133ELVV3Gov. Agency Debenture 4/8/2020 1,600,000.00 1,600,000.00 1,600,245.52 4/8/2022 0.93%-$ 3,456.44$ 3,831.23$ 555FNMA3136G0AW1Gov. Agency Debenture 12/13/2017 2,000,000.00 2,017,900.00 2,001,842.68 10/16/2020 2.02%110,058.33$ 103,715.85$ 10,260.06$ 16IBM 459200HG9 Corporate Bond 8/8/2019 1,000,000.00 995,010.00 1,030,096.03 8/1/2022 2.05%18,385.42$ 18,296.32$ 5,147.59$ 670Oracle68389XBL8Corporate Bond 7/8/2019 1,000,000.00 1,008,880.00 1,051,766.25 7/15/2023 2.18%28,466.67$ 21,374.17$ 5,492.80$ 1018
US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 519,101.56 4/30/2023 1.77%6,734.04$ 8,819.78$ 2,229.18$ 942American Express 0258M0EB1 Corporate Bond 2/11/2020 1,000,000.00 1,007,210.00 1,009,968.75 4/4/2021 1.66%5,250.00$ 6,215.30$ 4,084.34$ 186Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 2,135,202.18 6/19/2023 1.79%50,416.67$ 34,741.74$ 9,211.07$ 992
FFCB 3133EKVF0 Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 1,038,370.79 1/17/2023 1.89%18,489.58$ 17,771.06$ 4,752.73$ 839Treasury912828L57US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 1,238,812.50 9/30/2022 2.09%25,016.39$ 20,385.25$ 5,451.87$ 730Freddie Mac 3137EADB2 Gov. Agency Debenture 1/17/2020 2,100,000.00 2,132,039.70 2,160,618.12 1/13/2022 2.12%24,383.34$ 15,274.50$ 8,516.69$ 470US Treasury 912828Y20 Gov. Agency Debenture 1/31/2020 1,000,000.00 1,016,601.56 1,019,687.50 7/15/2021 1.47%11,971.16$ 6,138.62$ 3,740.09$ 288American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 1,058,224.52 6/27/2024 2.12%24,733.34$ 12,601.45$ 5,367.28$ 1366JP Morgan Chase 46625HJE1 Gov. Agency Debenture 2/11/2020 900,000.00 934,587.00 951,281.83 9/23/2022 1.74%18,037.50$ 6,148.83$ 4,040.66$ 723Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 1,066,416.20 7/15/2024 1.64%16,483.33$ 12,127.88$ 5,003.43$ 1384Disney254687CK0Corporate Bond 3/4/2020 1,000,000.00 1,029,080.00 1,015,665.65 2/15/2021 1.39%20,125.00$ 4,687.49$ 3,654.65$ 138
FNMA 3135G0V75 Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,160,982.15 7/2/2024 1.63%13,956.25$ 12,682.51$ 4,540.04$ 1371US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 1,088,038.71 1/5/2024 2.12%20,718.75$ 11,183.73$ 5,443.93$ 1192FFCB3133EKCS3Gov. Agency Debenture 3/21/2019 1,400,000.00 1,403,262.00 1,414,974.79 3/11/2021 2.43%52,558.33$ 43,563.60$ 8,582.12$ 162
FFCB 3133EKQA7 Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 1,069,965.29 9/10/2024 1.66%18,431.11$ 11,615.55$ 4,223.84$ 1441PNC Financial 693476BN2 Corporate Bond 8/15/2019 1,000,000.00 1,029,280.00 1,039,601.37 2/6/2022 2.12%35,108.33$ 18,589.78$ 5,344.56$ 494FHLB313379Q69Gov. Agency Debenture 7/22/2019 1,000,000.00 1,006,960.00 1,033,240.43 6/10/2022 1.87%18,770.83$ 17,755.82$ 4,748.65$ 618FNMA3135G0V59Gov. Agency Debenture 11/27/2019 1,540,000.00 1,562,924.44 1,589,858.22 4/12/2022 1.61%12,993.75$ 14,793.93$ 6,301.12$ 559JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,544,493.48 2/1/2024 2.39%46,413.89$ 26,688.85$ 8,737.99$ 1219American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 621,099.40 5/10/2023 1.75%4,745.00$ 3,955.80$ 2,656.45$ 952FHLB3130AABG2US Treasury Note 4/15/2019 1,000,000.00 988,250.00 1,019,983.17 11/29/2021 2.34%21,041.67$ 28,121.02$ 5,853.24$ 425FNMA3135G0Q89Gov. Agency Debenture 2/10/2020 1,000,000.00 998,702.00 1,012,368.18 10/7/2021 1.38%2,177.08$ 5,614.15$ 3,663.14$ 372FNMA3135G0J20Gov. Agency Debenture 2/10/2020 1,000,000.00 998,882.00 1,004,995.55 2/26/2021 1.48%7,486.11$ 5,724.31$ 3,735.01$ 149Treasury912828M80US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 1,040,351.56 11/30/2022 1.81%17,158.47$ 17,118.04$ 4,578.08$ 791Treasury912828U57US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 1,061,835.94 11/30/2023 1.84%17,708.33$ 16,990.40$ 4,666.02$ 1156
BankAmerica Corp 06051GGS2 Corporate Bond 4/30/2020 1,300,000.00 1,302,314.00 1,300,000.00 2,437.92 10/1/2020 1.21%(2,437.92)$ 4,141.23$ 6,245.80$ 1Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 1,064,687.50 4/30/2024 1.75%7,703.30$ 9,805.98$ 4,929.78$ 1308Treasury912828XT2US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 1,065,976.56 5/31/2024 1.64%11,639.34$ 11,040.77$ 4,180.04$ 1339
Wells Fargo 94988J6A0 Corporate Bond 6/24/2020 1,350,000.00 1,370,749.50 1,369,092.78 9/9/2021 0.80%5,357.48$ 163.99$ 2,514.48$ 344FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,626,578.42 12/21/2023 2.12%35,098.96$ 19,226.80$ 5,761.78$ 1177Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,624,507.76 2/8/2023 1.82%47,856.25$ 29,033.70$ 7,180.38$ 861
Subtotal 44,640,000.00$ 45,282,807.68$ 46,368,108.90$ 2,437.92$ 861,997.75$ 678,346.17$ 203,654.35$
BNY MM 436,084.15 436,084.15 0.00%1LAIFN/A 11,210,051.74 11,210,051.74 0.69%23,601.78 1
$56,928,943.57 $58,014,244.79 861,997.75$ 678,346.17$ 227,256.13$
Matured AssetsFNMA 3133EHYM9 Gov. Agency Debenture 9/21/2017 1,300,000.00 1,295,866.00 9/14/2020 1.61%58,120.83$ 57,964.67$ 4,348.78$
Total Investments "Matured"4,348.78$
Total Interest FY 20_21 Matured and Current 231,604.91$
Maturity Profile Amount0-1 year $23,292,199.95
1-2 years $11,415,762.142-3 years $9,893,808.723-5 years 12,327,172.76$ $56,928,943.57
Amortized
Institution Cost BNY Assets $45,282,807.68BNY MM 436,084.15
LAIF 11,210,051.74Totals:$56,928,943.57
Market to Cost Position Report
Page 5
Town of Los Gatos
Summary Investment Information
August 31, 2020
Weighted Average YTM Portfolio Yield: 1.86%Weighted Average Maturity (days)577
This Month Last Month One year ago
Portfolio Balance $60,272,540 $60,339,136 $62,530,263
Benchmarks/ References:
Town's Average Yield 1.86%1.86%1.99%
LAIF Yield for month 0.92%0.92%2.34%
3 mo. Treasury 0.11%0.10%2.07%
6 mo. Treasury 0.12%0.10%2.07%
2 yr. Treasury 0.13%0.11%1.87%
5 yr. Treasury (most recent)0.27%0.21%1.83%
10 Yr. Treasury 0.71%0.53%2.02%
0 -1 year30%
1 -2 years30%
2 -3 years25%
3 -5 years15%
Portfolio Maturity Profile
Compliance:The Town's investments are in compliance with the Town's investment policy dated November 3, 2020and 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
Town of Los Gatos
Portfolio Allocation & Treasurer's Fund Balances
August 31, 2020 Month YTDFund Balances - Beginning of Month/Period $60,339,136.48 $72,729,892.43
Receipts 4,194,315.64 7,808,570.53Disbursements(4,260,911.85)(20,265,922.69)
Fund Balances - End of Month/Period $60,272,540.27 $60,272,540.27
Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy
BNY MM $340,145.64 0.60%20% of Town Portfolio
US Treasury Notes $7,723,416.42 13.52%No Max. on US Treasuries
Government Agency Debenture Notes $24,340,417.75 42.61%No Max. on Non-Mortgage BackedCorporate Medium Term Bonds $14,514,839.51 25.41%30% of Town PortfolioLocal Agency Investment Fund 10,210,051.74 17.87%$75 M per State Law
Subtotal - Investments 57,128,871.06 100.00%
Reconciled Demand Deposit Balances 3,143,669.21
Total Treasurer's Fund $60,272,540.27
BNY MM0.60%US Treasury Notes13.52%
Government Agency Debenture Notes
42.61%Corporate Medium Term Bonds25.4%
Local Agency Investment Fund17.9%
Portfolio Investment Allocation
60000000
62000000
64000000
66000000
68000000
70000000
72000000
74000000
Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20
Treasurer's Fund Balances
page 2a
Town of Los GatosNon-Treasury Restricted Fund BalancesAugust 31, 2020
AUG 20 AUG 20 AUG 20
Beginning Deposits Interest/Ending
Balance Realized Gain/Adj.Earnings Withdrawals Balance
Non-Treasury Funds:`
Cert. of Participation 2002 Series A Reserve Fund 686,262.59$ 5.89$ -$ 686,268.48$ Note 1
Cert. Of Participation 2010 Ser A Lease Pymt Fund 1,057,162.50 0.00 3.62 1,057,162.50 3.62$ Note 1
Cert. of Participation 2002 Lease Payment Fund 535,306.25 0.00 0.15 535,306.25 0.15$ Note 1
Cert. of Participation 2010 Series Reserve Fund 1,297,995.22 71.75 1,298,066.97 Note 2Total Restricted Funds:1,987,621.42$ $0.00 $9.66 $1,592,468.75 $1,984,339.22
CEPPT IRS Section 115 Trust 684,349.85 0.00 3,676.15 688,026.00
Grand Total COP's and PARS Trust 2,671,971.27$ -$ 3,685.81$ 1,592,468.75$ 2,672,365.22$
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 po
Page 3
Town of Los Gatos
Statement of Interest Earned
August 31, 2020
Interest by Month
July 2020 $78,263.77
August 2020 78,263.76
September 2020
October 2020
November 2020
December 2020
January 2021
February 2021
March 2021
April 2021
May 2021
June 2021
$156,527.53
Page 4
Town of Los Gatos Investment Schedule August 2020
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 Maturity
Treasury 912828WR7 US Treasury Note 4/2/2019 1,000,000.00 995,625.00 1,016,171.88 6/30/2021 2.33%26,474.45$ 28,917.32$ 3,940.38$ 303
Toyota Motor Credit 89236TDP7 Corporate Bond 05/20/19 1,100,000.00 1,102,596.00 1,134,153.53 1/11/2022 2.50%32,651.67$ 30,798.33$ 4,691.64$ 498Toyota Motor Credit 89236TCZ6 Corporate Bond 3/13/2020 500,000.00 504,440.00 504,722.92 4/8/2021 1.06%659.72$ 1,599.24$ 909.66$ 220FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 1,066,943.82 2/23/2024 1.90%29,175.83$ 17,466.66$ 3,252.05$ 1271FFCB3133ELVV3Gov. Agency Debenture 4/8/2020 1,600,000.00 1,600,000.00 1,601,254.18 4/8/2022 0.93%-$ 3,456.44$ 2,581.92$ 585FNMA3133EHYM9Gov. Agency Debenture 9/21/2017 1,300,000.00 1,295,866.00 1,300,656.28 9/14/2020 1.61%48,370.83$ 57,964.67$ 3,547.69$ 14FNMA3136G0AW1Gov. Agency Debenture 12/13/2017 2,000,000.00 2,017,900.00 2,005,588.60 10/16/2020 2.02%110,058.33$ 103,715.85$ 6,914.39$ 46IBM 459200HG9 Corporate Bond 8/8/2019 1,000,000.00 995,010.00 1,030,994.25 8/1/2022 2.05%18,385.42$ 18,296.32$ 3,469.03$ 700
Oracle 68389XBL8 Corporate Bond 7/8/2019 1,000,000.00 1,008,880.00 1,056,686.20 7/15/2023 2.18%16,466.67$ 21,374.17$ 3,701.67$ 1048US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 519,707.03 4/30/2023 1.77%6,734.04$ 8,819.78$ 1,502.27$ 972American Express 0258M0EB1 Corporate Bond 2/11/2020 1,000,000.00 1,007,210.00 1,011,725.63 4/4/2021 1.66%5,250.00$ 6,215.30$ 2,752.49$ 216
Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 2,139,784.96 6/19/2023 1.79%50,416.67$ 34,741.74$ 6,207.46$ 1022FFCB3133EKVF0Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 1,039,390.68 1/17/2023 1.89%18,489.58$ 17,771.06$ 3,202.92$ 869Treasury912828L57US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 1,240,406.26 9/30/2022 2.09%14,516.39$ 20,385.25$ 3,674.09$ 760Freddie Mac 3137EADB2 Gov. Agency Debenture 1/17/2020 2,100,000.00 2,132,039.70 2,164,267.79 1/13/2022 2.12%24,383.34$ 15,274.50$ 5,739.51$ 500US Treasury 912828Y20 Gov. Agency Debenture 1/31/2020 1,000,000.00 1,016,601.56 1,021,367.19 7/15/2021 1.47%11,971.16$ 6,138.62$ 2,520.49$ 318American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 1,058,466.92 6/27/2024 2.12%24,733.34$ 12,601.45$ 3,617.08$ 1396JP Morgan Chase 46625HJE1 Gov. Agency Debenture 2/11/2020 900,000.00 934,587.00 952,641.00 9/23/2022 1.74%3,412.50$ 6,148.83$ 2,723.05$ 753Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 1,068,600.31 7/15/2024 1.64%16,483.33$ 12,127.88$ 3,371.88$ 1414
Disney 254687CK0 Corporate Bond 3/4/2020 1,000,000.00 1,029,080.00 1,018,729.13 2/15/2021 1.39%20,125.00$ 4,687.49$ 2,462.92$ 168FNMA3135G0V75Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,160,757.66 7/2/2024 1.63%13,956.25$ 12,682.51$ 3,059.59$ 1401US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 1,093,669.57 1/5/2024 2.12%20,718.75$ 11,183.73$ 3,668.74$ 1222
FFCB 3133EKCS3 Gov. Agency Debenture 3/21/2019 1,400,000.00 1,403,262.00 1,417,609.05 3/11/2021 2.43%34,708.33$ 43,563.60$ 5,783.60$ 192FFCB3133EKQA7Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 1,069,202.57 9/10/2024 1.66%8,031.11$ 11,615.55$ 2,846.50$ 1471PNC Financial 693476BN2 Corporate Bond 8/15/2019 1,000,000.00 1,029,280.00 1,042,408.32 2/6/2022 2.12%18,608.33$ 18,589.78$ 3,601.77$ 524FHLB313379Q69Gov. Agency Debenture 7/22/2019 1,000,000.00 1,006,960.00 1,034,853.52 6/10/2022 1.87%18,770.83$ 17,755.82$ 3,200.18$ 648FNMA3135G0V59Gov. Agency Debenture 11/27/2019 1,540,000.00 1,562,924.44 1,592,849.58 4/12/2022 1.61%12,993.75$ 14,793.93$ 4,246.40$ 589JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,549,260.96 2/1/2024 2.39%46,413.89$ 26,688.85$ 5,888.64$ 1249American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 622,457.58 5/10/2023 1.75%4,745.00$ 3,955.80$ 1,790.22$ 982FHLB3130AABG2US Treasury Note 4/15/2019 1,000,000.00 988,250.00 1,021,515.27 11/29/2021 2.34%21,041.67$ 28,121.02$ 3,944.58$ 455FNMA3135G0Q89Gov. Agency Debenture 2/10/2020 1,000,000.00 998,702.00 1,013,367.94 10/7/2021 1.38%2,177.08$ 5,614.15$ 2,468.63$ 402FNMA3135G0J20Gov. Agency Debenture 2/10/2020 1,000,000.00 998,882.00 1,006,037.97 2/26/2021 1.48%7,486.11$ 5,724.31$ 2,517.07$ 179Treasury912828M80US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 1,041,757.81 11/30/2022 1.81%17,158.47$ 17,118.04$ 3,085.23$ 821
Treasury 912828U57 US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 1,063,476.56 11/30/2023 1.84%17,708.33$ 16,990.40$ 3,144.49$ 1186BankAmerica Corp 06051GGS2 Corporate Bond 4/30/2020 1,300,000.00 1,302,314.00 1,302,036.58 2,437.92 10/1/2020 1.21%(2,437.92)$ 4,141.23$ 4,209.12$ 31Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 1,066,015.62 4/30/2024 1.75%7,703.30$ 9,805.98$ 3,322.24$ 1338
Treasury 912828XT2 US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 1,067,304.69 5/31/2024 1.64%11,639.34$ 11,040.77$ 2,816.99$ 1369Wells Fargo 94988J6A0 Corporate Bond 6/24/2020 1,350,000.00 1,370,749.50 1,371,280.31 8,197.87 9/9/2021 0.80%(8,197.87)$ 163.99$ 1,694.54$ 374FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,627,879.02 12/21/2023 2.12%35,098.96$ 19,226.80$ 3,882.94$ 1207Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,627,066.71 2/8/2023 1.82%47,856.25$ 29,033.70$ 4,838.95$ 891
Subtotal 45,940,000.00$ 46,578,673.68$ 47,743,065.85$ 10,635.79$ 814,938.23$ 736,310.84$ 140,793.01$
BNY MM 340,145.64 340,145.64 0.00%1
LAIF N/A 10,210,051.74 10,210,051.74 0.78%15,734.52 1
$57,128,871.06 $58,293,263.23 814,938.23$ 736,310.84$ 156,527.53$
Matured Assets
Total Investments "Matured"- - - -
Total Interest FY 19_20 Matured and Current 156,527.53$
Maturity Profile Amount0-1 year $22,121,377.941-2 years $12,786,511.642-3 years $9,893,808.723-5 years 12,327,172.76$ $57,128,871.06
Amortized
Institution Cost BNY Assets $46,578,673.68BNY MM 340,145.64
LAIF 10,210,051.74Totals:$57,128,871.06
Market to Cost Position Report
Page 5
Town of Los Gatos
Summary Investment Information
July 31, 2020
Weighted Average YTM Portfolio Yield: 1.86%Weighted Average Maturity (days)583
This Month Last Month One year ago
Portfolio Balance $60,339,136 $72,729,892 $65,922,912
Benchmarks/ References:
Town's Average Yield 1.86%1.86%1.98%
LAIF Yield for month 0.92%1.22%2.38%
3 mo. Treasury 0.10%0.15%2.07%
6 mo. Treasury 0.10%0.19%2.07%
2 yr. Treasury 0.11%0.15%1.87%
5 yr. Treasury (most recent)0.21%0.29%1.83%
10 Yr. Treasury 0.53%0.66%2.02%
0 -1 year30%
1 -2 years30%
2 -3 years25%
3 -5 years15%
Portfolio Maturity Profile
Compliance:The Town's investments are in compliance with the Town's investment policy dated November 3, 2020and 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
Town of Los Gatos
Portfolio Allocation & Treasurer's Fund Balances
July 31, 2020 Month YTDFund Balances - Beginning of Month/Period $72,729,892.43 $72,729,892.43
Receipts 3,614,254.89 3,614,254.89Disbursements(16,005,010.84)(16,005,010.84)
Fund Balances - End of Month/Period $60,339,136.48 $60,339,136.48
Portfolio Allocation:% of Portfolio Max. % 0r $ Allowed Per State Law or Policy
BNY MM $217,297.23 0.37%20% of Town Portfolio
US Treasury Notes $7,723,416.42 13.09%No Max. on US Treasuries
Government Agency Debenture Notes $24,340,417.75 41.25%No Max. on Non-Mortgage BackedCorporate Medium Term Bonds $14,514,839.51 24.60%30% of Town PortfolioLocal Agency Investment Fund 12,210,051.74 20.69%$75 M per State Law
Subtotal - Investments 59,006,022.65 100.00%
Reconciled Demand Deposit Balances 1,333,113.83
Total Treasurer's Fund $60,339,136.48
BNY MM0.37%US Treasury Notes13.09%
Government Agency Debenture Notes41.25%Corporate Medium Term Bonds24.6%
Local Agency Investment Fund20.7%
Portfolio Investment Allocation
60000000
62000000
64000000
66000000
68000000
70000000
72000000
74000000
Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20
Treasurer's Fund Balances
page 2
Town of Los GatosNon-Treasury Restricted Fund BalancesJuly 31, 2020
JULY 20 JULY 20 JULY 20
Beginning Deposits Interest/Ending
Balance Realized Gain/Adj.Earnings Withdrawals Balance
Non-Treasury Funds:`
Cert. of Participation 2002 Series A Reserve Fund 686,256.89$ 5.70$ -$ 686,262.59$ Note 1
Cert. Of Participation 2010 Ser A Lease Pymt Fund 732.26 1,589,014.25 0.01 532,584.02 1,057,162.50$ Note 1
Cert. of Participation 2002 Lease Payment Fund 2,722.23 532,584.02 535,306.25$ Note 1
Cert. of Participation 2010 Series Reserve Fund 1,297,910.04 85.18 1,297,995.22 Note 2Total Restricted Funds:1,987,621.42$ $2,121,598.27 $90.89 $532,584.02 $3,576,726.56
CEPPT IRS Section 115 Trust 669,978.13 0.00 14,371.72 684,349.85
Grand Total COP's and CEPPT Trust 2,657,599.55$ 2,121,598.27$ 14,462.61$ 532,584.02$ 4,261,076.41$
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 po
Page 3
Town of Los Gatos
Statement of Interest Earned
July 31, 2020
Interest by Month
July 2020 $78,263.77
August 2020
September 2020
October 2020
November 2020
December 2020
January 2021
February 2021
March 2021
April 2021
May 2021
June 2021
$78,263.77
Page 4
Town of Los Gatos Investment Schedule July 2020
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 Maturity
Treasury 912828WR7 US Treasury Note 4/2/2019 1,000,000.00 995,625.00 1,018,046.88 6/30/2021 2.33%26,474.45$ 28,917.32$ 1,970.19$ 334
Toyota Motor Credit 89236TDP7 Corporate Bond 05/20/19 1,100,000.00 1,102,596.00 1,135,475.00 1/11/2022 2.50%32,651.67$ 30,798.33$ 2,345.82$ 529Toyota Motor Credit 89236TCZ6 Corporate Bond 3/13/2020 500,000.00 504,440.00 505,664.96 4/8/2021 1.06%659.72$ 1,599.24$ 454.83$ 251FFCB3133EKMX1Gov. Agency Debenture 8/2/2019 1,000,000.00 1,014,400.00 1,070,267.19 2/23/2024 1.90%18,025.83$ 17,466.66$ 1,626.03$ 1302FFCB3133ELVV3Gov. Agency Debenture 4/8/2020 1,600,000.00 1,600,000.00 1,602,207.89 4/8/2022 0.93%-$ 3,456.44$ 1,290.96$ 616FNMA3133EHYM9Gov. Agency Debenture 9/21/2017 1,300,000.00 1,295,866.00 1,302,019.81 9/14/2020 1.61%48,370.83$ 57,964.67$ 1,773.84$ 45FNMA3136G0AW1Gov. Agency Debenture 12/13/2017 2,000,000.00 2,017,900.00 2,009,023.06 10/16/2020 2.02%110,058.33$ 103,715.85$ 3,457.20$ 77IBM 459200HG9 Corporate Bond 8/8/2019 1,000,000.00 995,010.00 1,031,999.71 8/1/2022 2.05%9,010.42$ 18,296.32$ 1,734.51$ 731
Oracle 68389XBL8 Corporate Bond 7/8/2019 1,000,000.00 1,008,880.00 1,057,070.39 7/15/2023 2.18%16,466.67$ 21,374.17$ 1,850.84$ 1079US Treasury 912828R28 US Treasury Note 7/2/2019 500,000.00 497,246.09 520,625.00 4/30/2023 1.77%6,734.04$ 8,819.78$ 751.14$ 1003American Express 0258M0EB1 Corporate Bond 2/11/2020 1,000,000.00 1,007,210.00 1,013,246.81 4/4/2021 1.66%5,250.00$ 6,215.30$ 1,376.25$ 247
Freddie Mac 3137EAEN5 Gov. Agency Debenture 7/19/2019 2,000,000.00 2,072,358.00 2,145,928.40 6/19/2023 1.79%50,416.67$ 34,741.74$ 3,103.73$ 1053FFCB3133EKVF0Gov. Agency Debenture 7/22/2019 1,000,000.00 999,630.00 1,040,569.80 1/17/2023 1.89%18,489.58$ 17,771.06$ 1,601.46$ 900Treasury912828L57US Treasury Note 7/22/2019 1,200,000.00 1,197,988.40 1,242,187.50 9/30/2022 2.09%14,516.39$ 20,385.25$ 1,837.04$ 791Freddie Mac 3137EADB2 Gov. Agency Debenture 1/17/2020 2,100,000.00 2,132,039.70 2,167,420.56 1/13/2022 2.12%24,383.34$ 15,274.50$ 2,869.75$ 531US Treasury 912828Y20 Gov. Agency Debenture 1/31/2020 1,000,000.00 1,016,601.56 1,023,710.94 7/15/2021 1.47%11,971.16$ 6,138.62$ 1,260.25$ 349American Honda 02665WCZ2 Corporate Bond 11/27/2019 1,000,000.00 1,012,410.01 1,061,433.09 6/27/2024 2.12%12,733.34$ 12,601.45$ 1,808.54$ 1427JP Morgan Chase 46625HJE1 Gov. Agency Debenture 2/11/2020 900,000.00 934,587.00 954,476.60 9/23/2022 1.74%3,412.50$ 6,148.83$ 1,361.53$ 784Honeywell Int'l.438516BW5 Corporate Bond 11/20/2019 1,000,000.00 1,014,660.00 1,071,906.73 7/15/2024 1.64%4,983.33$ 12,127.88$ 1,685.94$ 1445
Disney 254687CK0 Corporate Bond 3/4/2020 1,000,000.00 1,029,080.00 1,021,649.47 2,375.00 2/15/2021 1.39%(2,375.00)$ 4,687.49$ 1,231.46$ 199FNMA3135G0V75Gov. Agency Debenture 10/17/2019 1,100,000.00 1,105,833.30 1,163,444.66 7/2/2024 1.63%13,956.25$ 12,682.51$ 1,529.80$ 1432US Bancorp 91159HHV5 Corporate Bond 12/24/2019 1,000,000.00 1,049,040.00 1,096,164.11 1/5/2024 2.12%3,843.75$ 11,183.73$ 1,834.37$ 1253
FFCB 3133EKCS3 Gov. Agency Debenture 3/21/2019 1,400,000.00 1,403,262.00 1,420,405.06 3/11/2021 2.43%34,708.33$ 43,563.60$ 2,891.80$ 223FFCB3133EKQA7Gov. Agency Debenture 10/21/2019 1,000,000.00 1,019,780.00 1,072,159.18 9/10/2024 1.66%8,031.11$ 11,615.55$ 1,423.25$ 1502PNC Financial 693476BN2 Corporate Bond 8/15/2019 1,000,000.00 1,029,280.00 1,044,399.57 2/6/2022 2.12%18,608.33$ 18,589.78$ 1,800.89$ 555FHLB313379Q69Gov. Agency Debenture 7/22/2019 1,000,000.00 1,006,960.00 1,035,401.12 6/10/2022 1.87%18,770.83$ 17,755.82$ 1,600.09$ 679FNMA3135G0V59Gov. Agency Debenture 11/27/2019 1,540,000.00 1,562,924.44 1,595,335.31 4/12/2022 1.61%12,993.75$ 14,793.93$ 2,123.20$ 620JP Morgan Chase 46625HJT8 Corporate Bond 9/23/2019 1,400,000.00 1,485,414.00 1,556,712.00 2/1/2024 2.39%19,288.89$ 26,688.85$ 2,944.32$ 1280American Honda 02665WDH1 Corporate Bond 2/14/2020 600,000.00 603,756.00 622,583.70 5/10/2023 1.75%4,745.00$ 3,955.80$ 895.11$ 1013FHLB3130AABG2US Treasury Note 4/15/2019 1,000,000.00 988,250.00 1,023,028.12 11/29/2021 2.34%21,041.67$ 28,121.02$ 1,972.29$ 486FNMA3135G0Q89Gov. Agency Debenture 2/10/2020 1,000,000.00 998,702.00 1,014,630.05 10/7/2021 1.38%2,177.08$ 5,614.15$ 1,234.32$ 433FNMA3135G0J20Gov. Agency Debenture 2/10/2020 1,000,000.00 998,882.00 1,006,939.34 2/26/2021 1.48%611.11$ 5,724.31$ 1,258.54$ 210Treasury912828M80US Treasury Note 7/22/2019 1,000,000.00 1,006,175.23 1,043,710.94 11/30/2022 1.81%17,158.47$ 17,118.04$ 1,542.61$ 852
Treasury 912828U57 US Treasury Note 7/31/2019 1,000,000.00 1,011,875.00 1,066,093.75 11/30/2023 1.84%17,708.33$ 16,990.40$ 1,572.25$ 1217BankAmerica Corp 06051GGS2 Corporate Bond 4/30/2020 1,300,000.00 1,302,314.00 1,304,005.87 2,437.92 10/1/2020 1.21%(2,437.92)$ 4,141.23$ 2,104.56$ 62Treasury912828X70US Treasury Note 12/30/2019 1,000,000.00 1,010,589.29 1,068,906.25 4/30/2024 1.75%7,703.30$ 9,805.98$ 1,661.12$ 1369
Treasury 912828XT2 US Treasury Note 10/31/2019 1,000,000.00 1,015,667.41 1,070,312.50 5/31/2024 1.64%11,639.34$ 11,040.77$ 1,408.49$ 1400Wells Fargo 94988J6A0 Corporate Bond 6/24/2020 1,350,000.00 1,370,749.50 1,372,329.49 8,197.87 9/9/2021 0.80%(8,197.87)$ 163.99$ 847.27$ 405FFCB3133EJ3Q0Gov. Agency Debenture 8/28/2019 1,500,000.00 1,587,503.75 1,631,796.80 12/21/2023 2.12%35,098.96$ 19,226.80$ 1,941.47$ 1238Freddie Mac 3133EKKT2 Gov. Agency Debenture 6/24/2019 1,550,000.00 1,573,188.00 1,628,734.06 2/8/2023 1.82%30,418.75$ 29,033.70$ 2,419.47$ 922
Subtotal 45,940,000.00$ 46,578,673.68$ 47,832,021.67$ 13,010.79$ 680,100.73$ 736,310.84$ 70,396.51$
BNY MM 217,297.23 217,297.23 0.00%1
LAIF N/A 12,210,051.74 12,210,051.74 0.92%7,867.26 1
$59,006,022.65 $60,259,370.64 680,100.73$ 736,310.84$ 78,263.77$
Matured Assets
Total Investments "Matured"- - - -
Total Interest FY 19_20 Matured and Current 78,263.77$
Maturity Profile Amount0-1 year $23,998,529.531-2 years $11,791,501.642-3 years $10,888,818.723-5 years 12,327,172.76$ $59,006,022.65
AmortizedInstitution Cost
BNY Assets $46,578,673.68BNY MM 217,297.23LAIF12,210,051.74
Totals:$59,006,022.65
Market to Cost Position Report
Page 5
Security Description Maturity Date Par/Shares Moody Rating S&P Rating Insight ESG Rating Environment Social Governance
HONEYWELL INTERNATIONAL 2.3% 15AUG2024 (CALLABLE 15JUL24)8/15/2024 1,000,000$ A2 A 3 3 5 3
AMERICAN EXPRESS CREDIT 2.25% 05MAY2021 (CALLABLE 04APR21)5/5/2021 1,000,000$ A2 A-2 1 3 3
AMERICAN HONDA FINANCE 2.4% 27JUN2024 6/27/2024 1,000,000$ A3 A-3 2 4 3
ORACLE CORP 2.4% 15SEP2023 (CALLABLE 15JUL23)9/15/2023 1,000,000$ A3 A 3 1 3 4
TOYOTA MOTOR CREDIT CORP 2.6% 11JAN2022 1/11/2022 1,100,000$ A1 A+3 1 3 3
WALT DISNEY COMPANY/THE 4.5% 15FEB2021 2/15/2021 1,000,000$ A2 A-3 3 3 3
WELLS FARGO BANK NA 2.082% 09SEP2022 (CALLABLE 09SEP21)9/9/2022 1,350,000$ Aa2 A+4 1 5 4
TOYOTA MOTOR CREDIT CORP 1.9% 08APR2021 4/8/2021 500,000$ A1 A+3 1 3 3
JPMORGAN CHASE & CO 3.25% 23SEP2022 9/23/2022 900,000$ A2 A-4 1 3 5
US BANCORP 3.375% 05FEB2024 (CALLABLE 05JAN24)2/5/2024 1,000,000$ A1 A+3 2 4 3
PNC FINANCIAL SERVICES 3.3% 08MAR2022 (CALLABLE 06FEB22)3/8/2022 1,000,000$ A3 A-2 2 2 3
IBM CORP 1.875% 01AUG2022 8/1/2022 1,000,000$ A2 A 3 1 2 4
BANK OF AMERICA CORP 2.328% 01OCT2021 (CALLABLE 01OCT20)10/1/2021 1,300,000$ A2 A-4 1 4 4
JPMORGAN CHASE & CO 3.875% 01FEB2024 2/1/2024 1,400,000$ A2 A-4 1 3 5
AMERICAN HONDA FINANCE 1.95% 10MAY2023 5/10/2023 600,000$ A3 A-3 2 4 3
Total/Average 15,150,000$ 3.1 1.5 3.4 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 September 30, 2020