Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Attachment 1
Weighted Average YTM Portfolio Yield: Portfolio Balance Benchmarks/ References: Town's Average Yield LAIF Yield for month 3 mo. Treasury 6 mo. Treasury 2 yr. Treasury 5 yr. Treasury (most recent) 10 Yr. Treasury This Month $67,391,974 2 - 3 years 25% 1.53% 1.24% 1.38% 1.53% 1.89% 2.21% 2.41% Town of Los Gatos Summary Investment Information December 31, 2017 1.53% Weighted Average Maturity (days) 453 Last Month $68,864,165 3 - 5 years 1.42% 1.17% 1.26% 1.44% 1.78% 2.14% 2.41% One year ago $70,272,720 Portfolio Maturity Profile 0.88% 0.72% 0.50% 0.61% 1.19% 1.93% 2.45% Compliance: The Town's investments are in compliance with the Town's investment policy dated May 16, 2017 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 Town of Los Gatos Portfolio Allocation & Treasurer's Fund Balances December 31, 2017 Fund Balances - Beginning of Month/Period Receipts Disbursements Fund Balances - End of Month/Period Portfolio Allocation: BNY MM US Treasury Notes Government Agency Debenture Notes Corporate Medium Term Bonds Local Agency lnvestment Fund Subtotal - Investments Reconciled Demand Deposit Balances Total Treasurer's Fund Month YTD $65,864,164.74 $75,983,998.32 4,416,189.72 16,975,601.13 (2,888,380.89) (25,567,625.881 $67,391,973.57 $67,391,973.57 $81,116.35 $7,997,539.06 $28,500,911.95 $13,986,787.01 6,223,682.60 56,790,036.97 10,601,936.60 $67,391,973.57 % of Portfolio Max. % $ Allowed Per State Law or Policy 0.14% 14.08% 50.19% 24.63% 10.96% 20% of Town Portfolio No Max. on US Treasuries No Max. on Non -Mortgage Backed 30% of Town Portfolio $65M per State Law 100.00% Portfolio Investment Allocation Local Agency Investment Fund BNY MM 11.0% 0.14% Corporate Medium Term Bonds 24.6% US Treasury Notes 14.08% Government Agency Debenture Notes 50.19% Treasurer's Fund Balances 76,000,000 74,000,000 72,000,000 70,000,000 68,000,000 66,000,000 64,000,000 62,000,000 60,000,000 page 2 Town of Los Gatos Non -Treasury Restricted Fund Balances December 31, 2017 Non -Treasury Funds: Cert. of Participation 2002 Series A Reserve Fund Cert. Of Participation 2002 Ser A Lease Pymt Fund Cert. of Participation 2002 Series A Const. Fund Total Restricted Funds: DEC 17 DEC 17 DEC 17 Previous Deposits Ending Balance Realized Gain/Adj. Interest Withdrawals Balance $ 687,587.38 $ 288.84 $ 687,876.22 Note1 287.43 0.26 287.69 Note]. 72.24 72.24 Note 1 1,285,433.41 1,005.57 1,286,438.98 Note2 $ 1,973,380.46 $0.00 $1,294.67 $0.00 $1,974,675.13 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. Page 3 Town of Los Gatos Statement of Interest Earned December 31, 2017 Interest by Month July 2017 August 2017 September 2017 October 2017 November 2017 December 2017 January 2018 February 2018 March 2018 April 2018 May 2018 June 2018 $58,520.73 54,113.45 50, 380.68 66,971.08 60,263.58 64, 761.73 $355,011.25 Page 4 Town of Los Gatos Investment Schedule December 31, 2017 Institution Ordinal Issue Maturity Yield to Interest Interest Interest Days Deposit Par Original (Discount) Market Purchased Date or Maturity Received Earned Earned to Date Value Cost Premium Value Interest Call Date or Call to Date Prior Yrs. Current FY Maturity Freddie Mac 08/01/16 1,000,000.00 1,005,560.00 5,560.00 Toyota Motor Credit 07/25/16 950,000.00 954,246.50 4,246.50 FHLB 9/20/2017 1,785,000.00 1,776,432.00 (8,568.00) 05 Bancorp 8/8/2016 1,000,000.00 1,019,550.00 19,550.00 Microsoft 8/8/2016 1,000,000.00 999,470.00 (530.00) FFCB 9/20/2017 1,600,000.00 1,602,304.00 2,304.00 FNMA 9/21/2017 1,300,000.00 1,295,866.00 (4,134.00) US Treasury 9/21/2017 1,000,000.00 997,109.38 (2,890.62) FNMA 12/13/2017 2,000,000.00 2,017,900.00 17,900.00 FNMA 04/17/13 1,000,000.00 1,004,400.00 4,400.00 AAPL 05/16/13 1,030,000.00 991,680.01 (8,319.99) FHLB 06/09/15 L000,000.00 997,710.00 (2,290.00) American Express 9/15/2017 1,000,000.00 1,007,980.00 7,980,00 Treasury 06/11/15 1,000,000.00 990,468.75 (9,531.25) FHLB 06/11/15 2,000,000.00 1,991,820.00 (8,180.00) Treasury 07/31/15 1,000,000.00 1,010,625.00 10,625.00 FroIIioMa, 12/20/2017 1,000,000.00 991,200.00 - (8,800.00) 3918 8/20/2015 1,250,000.00 1,247,075.00 (2,925.00) FHLB 8/25/2015 1,000,000,00 999,500.00 (500.00) Weimar' 9/25/2015 1,000,000,00 998,960.00 (1,040.00) Disney 12/1/2017 1,000,000.00 998,190.00 (1,810.00) FFCB 10/27/2015 1,000,000.00 1,048,230.00 48,230.00 FHLB 10/27/2015 1,000.000.00 1,005,030.00 5,030.00 FFCB 10/29/2015 1,500,030.00 1A94,840.00 (5,160.00) Chevron 11/9/2017 1,350,000.00 1,366,834.50 16,834.50 Treasury 1/26/2016 1,500,000.00 1,494,902.30 (5,097.66) Wells Fargo 2/2/2016 1,000,000.00 1,001,680.00 1,680.00 FHLMC 4/29/2016 1,000,000.00 1,008,050.00 8,050.00 FFCB 4/29/2016 1,000,000.00 L001,870.00 1,870.00 FFCB 10/28/2016 1,000,000.00 997,507.00 (2,493.00) FNMA 11/15/2016 1,500,000.00 1,487,505.00 (12,495.00) FHLMC 3/14/2017 2,000,000.00 1,970,180.00 (29.820.00) FNMA 12/20/2017 1,550,000.00 1,545,642.95 (4,357.05) Freddie Mac 9/29/2017 1,000,0(10.00 998.900.00 (1,100.00) JP Morgan Chase 3/28/2017 1,400,000.00 1,393,196.00 (6,804.00) US Treasury 3/31/2017 1.0013,000.00 1,004,218.75 4,218.75 FNMA 4/25/2017 1,000,000.00 1,013,390.00 13,390.00 PNC 19:utk 4/4/2017 1,000,000.00 1,003,120.00 3,120.00 Treasury 5/2/2017 500,000.00 503.339.84 3,339.84 Pg1,k. 5/15/2017 1,250,000.00 1,249,600.00 (400.00) Plix a 6/30/2017 1,000,000.00 1,0E12,280.00 2,280.00 Treasury 6/30/2017 1000,000.00 1,002,148.44 2,148.44 Treasury 6/30/2017 1,000,000.00 994,726.56 (5,273.44) Toyota Motor Credit 10/6/2017 500,000.00 503,545.00 3,545.00 Subtotal 990,847.00 4/15/2019 0.92% $ 12,812.50 $ 8,387.83 S 4,634.72 470 941,420.55 5/20/2019 1.24% $ 17,548.61 $ 10,985.92 $ 5,945.32 505 1,753,405.50 6/12/2020 1.56% 5 5,590.53 5 - $ 7,736.25 894 1,000,099.00 10/15/2018 1.0890 5 24,754.17 $ 9,429.85 5 5,322.37 288 986,628.00 8/8/2019 1.12% $ 11,000.00 $ 9,982.45 $ 5,634.26 585 1,584,672.00 4/6/2020 1.54% $ 1,137.78 $ - $ 6,901.00 827 1,281,345.00 379.17 9/14/2020 1.61% 5 (379.17) $ - $ 5,779.30 988 987,188.00 5/31/2020 1.48% $ 2,629.78 $ • $ 4,101.80 882 2,012,960.00 7,441.67 10/16/2020 2.02% 5 (7,441.67) S - $ 2,007.40 1020 999,540.03 3/5/2018 1.03% $ 49,312.50 $ 43,523.65 5 5,217.17 64 997,528.00 5/3/2018 1.17% $ 44,638.89 5 48,171.42 $ 5,885.49 123 996,930.00 8/27/2018 1.22% 5 25,491.66 $ 25,158.75 $ 6,155.86 239 996,973.00 733.33 1/2/2020 1.87% 5 (733.33) 5 - $ 5,431.60 732 998,276.00 4/15/2018 1.09% $ 17,581.97 $ 22,291.07 $ 5,468.74 105 1,996,100.00 5/25/2018 1.19% $ 52,033.33 5 48,836.51 $ 11,981.22 145 999,375.00 6/30/2018 1.00% 5 33,216.71 $ 19,386.29 5 5,035.83 181 990,538.00 1/17/2020 1.93% 5 (6,375.00) 5 - $ 579.76 747 1,245,825.00 7/25/2018 1.13% $ 25,666.67 $ 26,310.93 5 7,119.43 206 996,660.00 7/25/2018 1.07% 5 20,387.50 $ 19,734.71 5 5,379.54 206 999.750,00 4/11/2018 1.17% $ 23,000.00 5 20,570.26 $ 5,877.22 101 996,750.00 3/4/2020 2.03% 5 (4,715.50) 5 - $ 1,668.64 794 1,005,300.00 6/1/2018 0.86% $ 57,597.22 $ 14,973.77 $ 4,501.92 152 995,769.00 9/14/2018 0.95% $ 21,156.25 $ 15,939.59 $ 4,792.30 257 1,490,655.00 10/9/2018 0.99% $ 25,520.83 $ 24,860.21 $ 7,498.82 282 1,356,601.50 5/24/2020 1.94% 5 4,095.56 $ - $ 3,723.49 875 1,498,590.00 2/28/2018 0.91% 5 17,925.82 $ 19,534.50 $ 6,898.94 59 999,801.00 1/22/2018 1.56% 5 24.612.50 5 22,036.28 $ 7,888.47 22 995,780.00 12/17/2018 1.04% $ 22,050.00 $ 12,220.02 5 5,265.77 351 991,950.00 3/21/2019 1.09% $ 16,175.56 $ 12,814.27 $ 5,521.84 445 983,730.00 10/17/2019 1.14% $ 10,179.17 5 7,611.40 $ 5,716.32 655 1,477,873.50 8/28/2019 1.31% $ 11,791.66 $ 12,120.46 5 9,824.52 605 1,968,728.00 7/19/2019 1.52% 5 6,076.39 $ 8,936.03 $ 15,224.34 565 1.544,756.35 11/26/2019 1.90% 5 (1,808.33) $ - $ 885.35 695 992,180.00 6/29/2018 1.67% $ 4,062.50 $ - $ 4,515.14 180 1,388,177.00 8/23/2019 1.86% $ 11,229.17 $ 6,677.49 5 13,070.83 600 995,820.00 - 3/31/2019 1.29% $ 7,500.00 $ 3,213.83 5 6,498.29 455 1,00(1,640.00 2/7/2020 1.50% 5 5,666.67 $ 2,748.32 S 7,662.00 768 998,246.00 2/2/2019 1.29% $ 8,125.00 $ 4,242.21 5 8,972.02 398 498,261.50 6/30/2019 1.31% 5 5,386.74 5 1,063.61 $ 3,317.02 546 1,239,928.75 3/30/2020 1.31% $ 10,598.96 5 2,931.91 $ 11,727,63 820 993,711.00 12/15/2019 1.60% $ 7,791.67 $ - $ 8,102.69 714 993,125.00 10/31/2019 1.41% $ 5,013.59 $ - 5 7,098.21 669 986,758.00 1/31/2020 1.46% $ 1,070.44 $ - $ 7,328.16 761 498,421.50 716.67 3/12/2020 1.85% $ (716.67) $ - $ 2,189.55 802 . 50,988,783.02 $ 53,783.02 $ 50,647,613.15 $ 9,270.84 BNY MM 81,116.35 IAIF 12/31/14 6,223,682.60 81,116.35 0.00% 6,223,682.60 1.14% 557,293,581.97 Bank of the West Matured Assets Treasury 06/09/15 1,000,000.00 1,004,140.63 4,140.63 FNMA 10/19/12 1,500,003.00 1,504,050,00 4,050.00 FNMA 11/30/12 1,0(0,000.00 1,003,200.00 3,200.00 FNMA 12/04/12 1,000,0)0.00 1,002,750.00 2,750.00 FFCB 10/18/12 2,000,000.013 1,996,960.00 (3,040.00) FHLMC 3/27/2017 1,000,000.00 999,750.00 (250.00) Toyota Motor Credit 07/10/15 500,000.00 502,200.00 2,200.00 Chevron 12/15/2015 1,250,000.00 1,252,262.50 2,262.50 Disney 9/25/2015 995,000.00 995,298.50 298.50 FHLB 12/12/12 2,000,000.00 1,998,720.00 (1,280.00) FFCB 07/30/15 2,500,000.00 2,509.525.00 9,525.00 Total Investments "Matured" Maturity Profile Market to Con Positior Institution BNY Assets BNY MM (Alf Totals: $14,768,856.63 Amount 525,608,220.05 515,870,284.48 $15,815,077.44 50.00 $57,293,581.97 Amortized Cost $50,988,783.02 81,116.35 6,223,682.60 557,293,581.97 $56,952,412.10 $ 628,258.63 5 484,693.54 $ 272,146.51 35,792.49 $ 628,258.63 5 484,693.54 $ 307,939.00 9/15/2017 0.82% 5 22,663.04 $ 16,846.70 5 1,724.99 9/20/2017 0.94% 5 73,791.67 $ 66,614.26 5 3,185.06 9/20/2017 0.93% $ 48,055.56 $ 42,785.13 $ 2,097.06 9/20/2017 0.94% $ 47,916.67 $ 43,077.49 $ 2,117.72 9/21/2017 0.86% 5 81,755.00 $ 80,902.48 $ 3,915.05 9/27/2017 1.52% $ 8,750.00 $ 4,683.87 $ 4,38805 10/5/2017 1.05% $ 13,975.69 $ 10,408.77 $ 1,400.08 11/9/2017 1.25% $ 32,293.33 5 24,080.64 $ 5,645.90 12/1/2017 1.09% $ 23,896.58 $ 19,070.28 $ 4,560.29 12/8/2017 0.76% $ 73,583.33 $ 69,427.17 5 6,729.54 12/18/2017 0.96% $ 67,031.25 $ 46,358.27 $ 11,308.51 5 1,121,970.75 $ 908,986.61 $ 355,011.25 0 0 0 0 Page 5 Town of Los Gatos Summary Investment Information November 30, 2017 Weighted Average YTM Portfolio Yield: 1.42% Weighted Average Maturity (days) 398 This Month Last Month One year ago Portfolio Balance $65,864,165 $67,417,299 $68,749,199 Benchmarks/ References: Town's Average Yield LAIF Yield for month 3 mo. Treasury 6 mo. Treasury 2 yr. Treasury 5 yr. Treasury (most recent) 10 Yr. Treasury 1.42% 1.17% 1.26% 1.44% 1.78% 2.14% 2.41% 2 - 3 years 25% 1..35% 1.14% 1.13% 1.28% 1.60% 2.02% 2.38% Portfolio Maturity Profile 0.88% 0.68% 0.49% 0.61% 1.12% 1.85% 2.39% 1 - 2 years 30% Compliance: The Town's investments are in compliance with the Town's investment policy dated May 16, 2017 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 Town of Los Gatos Portfolio Allocation & Treasurer's Fund Balances November 30, 2017 Fund Balances - Beginning of Month/Period Receipts Disbursements Fund Balances - End of Month/Period Portfolio Allocation: BNY MM US Treasury Notes Government Agency Debenture Notes Corporate Medium Term Bonds Local Agency Investment Fund Subtotal -Investments Reconciled Demand Deposit Balances Total Treasurer's Fund Month YTD $67,417,298.68 $75,983,998.32 3,380,410.23 12,559,411.41 (4,933,544.17) (22,679,244.99) $65,864,164.74 $65,864,164.74 $70,575.44 $7,997,539.06 $28,454,414.00 $13,983,895.51 6,223,682.60 56,730,106.61 9,134,058.13 $65,864,164.74 % of Portfolio Max. % Or $ Allowed Per State Law or Polity 0.12% 14.10% 50.16% 24.65% 10.97% 100.00% 20% of Town Portfolio No Max. on US Treasuries No Max. on Non -Mortgage Backed 30% of Town Portfolio $65M per State Law Portfolio Investment Allocation Local Agency Investment Fund BNY MM 11.0% 0.12% Corporate Medium Terns Bonds 24.6% US Treasury Notes 14.10% Government Agency Debenture Notes 50.16% 76,000,000 74,000,000 72,000,000 70,000,000 68,000,000 66,000,000 64,000,000 62,000,000 60,000,000 0 0 Treasurer's Fund Balances ti 3 page 2 Town of Los Gatos Non -Treasury Restricted Fund Balances November 30, 2017 Non -Treasury Funds: Cert. of Participation 2002 Series A Reserve Fund Cert. Of Participation 2002 Ser A Lease Pymt Fund Cert. of Participation 2002 Series A Const. Fund Total Restricted Funds: NOV 17 NOV 17 NOV 17 Previous Deposits Ending Balance Realized Gain/Adj. Interest Withdrawals Balance $ 687,312.27 287.16 72.24 1,284,438.93 $ 1,972,110.60 $ 275.11 $ 687,587.38 0.27 287.43 72.24 994.48 1,285,433.41 $0.00 $1,269.86 $0.00 $1,973,380.46 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 1 Note 1 Note 1 Note 2 Page 3 Town of Los Gatos Statement of Interest Earned November 30, 2017 Interest by Month July 2017 August 2017 September 2017 October 2017 November 2017 December 2017 January 2018 February 2018 March 2018 April 2018 May 2018 June 2018 $58,520.73 54,113.45 50,380.68 66,971.08 60,263.58 $290,249.52 Page 4 Town of Los Gatos Investment Schedule November 30, 2017 Orginallssue Maturity Yield to Interest Interest Interest Days Deposit Par Original (Discount) Market Purchased Date or Maturity Received Famed Earned to Institution Clete Value Cast Premium Value Interest Call Date Or Call to Date Prior Yrs. Current FY Muuriry Aug 17 Cost Freddie Mac 08/01/16 1,000,000.00 1,035,560.00 5,560.00 991,339.00 4/15/2019 0.92% 5 12,812.50 $ 8,387.83 5 3,853.87 501 Toyota Motor Credit 07/25/16 950,000.00 954,246.50 4,246.50 941,365.45 5/20/2019 L24% $ 17,549.61 $ 10,985.92 $ 4,943.66 536 FHLB 9/20/2017 1,785,000.00 1,776,432,80 (8,568.00) 1,758,385.65 6,681.35 6/12/2020 1.56% $ (6,681.351 $ - $ 5,385.03 925 US Bancorp 8/8/2016 1,000,000.00 1,019,550.00 19,550.00 1,001,547.00 10/15/2018 1.0896 $ 24,754.17 $ 9,029.85 $ 4,425.66 319 Microsoft 8/8/2016 1,000,000.00 999,470.00 (530.00) 986,954.00 8/8/2019 1.12% 5 11,000.00 $ 9,982.45 $ 4,685.01 6I6 FFCB 9/20/2017 1,600,000.00 1,602,304.00 2,304.00 1,588,336.00 4/6/2020 1.54% $ 1,137.78 $ - $ 4,803.64 858 FNMA 9/21/2017 1,300,000.00 1.295,866.00 (4,134.00) 1,282,411.00 379.17 9/14/2020 1.61% $ (379.17) 5 - $ 4,005.46 1019 US Treasury 9/21/2017 1,000,000.00 997,109.38 (2,890.62) 988,164.00 5/31/2020 1.48% $ 2,629.78 3 - $ 2,842.83 913 FHLB 12/12/12 2,000,000.00 1,998,720.00 (1,280.00) 1,999,870.00 12/8/2017 0.76% $ 66,083,33 $ 69,427.17 $ 6,395.16 8 FNMA 04/17/13 1,000,000.00 1,004,400.00 4,400.00 999,480.00 3/5/2018 1.03% $ 49,312.50 $ 43,523.65 5 4,338.19 95 AAPL 05/16/13 1,000,000.00 991,680.01 (8,319.99) 997,615.00 5/3/2018 1.17% $ 44,638.89 $ 48,171.42 $ 4,893.91 154 FHLB 06/09/15 1,000,000.00 997,710.00 (2,290.00) 997,370.00 8/27/2018 1.22% $ 25,49L66 $ 25,158.75 $ 5,118.74 270 American Express 9/15/2017 1,000,000.00 1,007,980.00 7,980.00 998,395.00 733.33 1/2/2020 1.87% $ (733.33) $ - $ 3,857.96 763 Treasury 06/11/15 1,000,000.00 990,468.75 (9,531.25) 997,773.00 4/15/2018 1.09% $ 17,581.97 $ 22,291.07 $ 4,547.38 136 FHLB 06/11/15 2,000,000.00 1,991,820.00 (8,1130.00) 1,996,500.00 5/25/2018 1.19% $ 52,033.33 $ 48,836.51 $ 9,962.65 176 Treasury 07/31/15 1,000,000.00 1,010,625.00 10,625.00 999,336.00 6/30/2018 1.00% $ 26,341.71 $ 19,386.29 $ 4,237.29 212 FFCB 07/30/15 2,500,000.00 2,509,525.00 9,525.00 2,500,055.00 12/18/2017 0.96% $ 52,968.75 5 46,358.27 $ 10,118.14 18 FHLB 8/20/2015 1,250,000.00 1,247,075.00 (2,925.00) 1,246,225.00 7/25/2018 1.13% $ 25,666.67 $ 26,310.93 $ 5,919.96 237 FHLB 8/25/2015 1,000,000.00 999,500-00 (500.00) 996,980.00 7/25/2018 1.07% $ 20,387.50 $ 19,734.71 $ 4,473.20 237 Walmart 9/25/2015 1,000,000.00 998,960.00 (1,040.00) 998,433.00 4/11/2018 L1796 $ 23,000.00 $ 20,570.26 5 4,887.03 132 Disney 9/25/2015 995,000.00 995,298.50 298.50 995,000.00 12/1/2017 1.09% $ 18,424.08 $ 19,070.28 $ 4,530,67 1 FFCB 10/27/2015 1,000,000.00 1.048,230.00 48,230.00 1,006,300.00 6/1/2018 0.86% $ 43,847.22 $ 14,973.77 $ 3,743.44 183 FHLB 10/27/2015 1,000,000.00 1,005,030.00 5,030.00 996,032.00 9/14/2018 0.95% $ 21,156.25 $ 15,939.59 $ 3,984.90 288 FFCB 10/29/2015 1,500,000.00 1,494,840.00 (5,160,00) 1,491,030.00 10/9/2018 0.99% 5 25,520.83 $ 24,860.21 5 6,235.43 313 Chevron 11/9/2017 1,350,000.00 1,366,834.50 16,834.50 1,359A60.80 5/24/2020 1.94% $ (12,286.69) $ - 5 1,503.72 906 Treasury 1/26/2016 1,500,000.00 1,494,902.34 (5,097.66) 1,497,945.00 2/28/2018 0.91% $ 17,925.82 5 19,534.50 $ 5,736.62 90 Wells Fargo 2/2/2016 1,000,000.00 1,001,680.00 1,680.00 999,935.00 1/22/2018 1.56% 5 24,612.50 $ 22,036.28 $ 6,559.44 53 FHLMC 4/29/2016 1,000,000.00 1,008,050.00 8,050.00 996,420.00 12/17/2018 1.04% $ 15,300.00 5 12,220.02 $ 4,378.60 382 FFCB 4/29/2016 1,000,000.00 1,001,870.00 1,870.00 992,530.00 3/21/2019 1.09% 5 16,175.56 5 12,814,27 $ 0,591.53 476 FFCB 10/28/2016 1,000,000.00 997,507.00 (2A93.00) 985,300.00 10/17/2019 1.14% $ 10,179.17 $ 7,611.40 $ 4,753.24 686 FNMA 11/15/2016 1,500,000.00 1,487,505.00 (12,495.00) 1,478,833.50 - 8/28/2019 1.31% $ 11,791.66 $ 12,120.46 $ 8,169.30 636 FHLMC 3/14/2017 2,000,000.00 1,970,180.00 (29,820.001 1,969,710.00 7/19/2019 1.52% $ 6,076.39 $ 3,936.03 $ 12,659.37 596 Freddie Mac 9/29/2017 1,000,000.00 998,900,00 (1,100.00) 993,360.00 6/29/2018 1.67% 5 - 5 - $ 3,010.09 211 JP Morgan Chase 3/28/2017 1,400,000.00 1,393,196.00 (6,804.00) 1,390,978.40 8/23/2019 1.86% 5 11,229.17 $ 6,677.49 $ 10,868,68 631 US Treasury 3/31/2017 1,000,000.00 1,004,218.75 4,218.75 996,836.00 - 3/31/2019 1.29% 5 7,500.00 5 3,213.83 $ 5,403.47 486 FNMA 4/25/2017 1,000,000.00 1,013,390.00 13,390.00 1,000,820.00 2/7/2020 1.50% $ 5,666.67 $ 2,748.31 $ 6,371.12 799 PNC Bank 4/4/2017 1,0013,000.00 1,003,120.00 3,120.00 998,897.00 2/2/2019 1.29% $ 8,125.00 $ 4,242.21 $ 7,460.43 429 Treasury 5/2/2017 500,000.00 503,339.84 3,339.84 498,847.50 6/30/2019 1.31% $ 1,324.24 $ 1,063.61 $ 2,758.17 577 PoPvcn 5/15/2017 1,250,003.00 1,249,603.00 (400.00) 1,242,601.25 963.54 3/30/2020 1.31% $ 10,598.96 $ 2,931.91 $ 9,751.78 851 Pfizer 6/30/2017 1,000,000.00 1,002,280.00 2,280.00 994,362.00 708.33 12/15/2019 1.60% 5 (708.33) $ - 5 6,737.56 745 Treasury 6/30/2017 1,000,000.00 1,002,148.44 2,148.44 994,453.00 2A86.41 10/31/2019 1.41% $ 5,013.59 $ - $ 5,902.31 700 Treasury 6/30/2017 1,000,000.00 994,726,56 (5,273.44) 987,891.00 1/31/2020 1.46% $ 1.070.44 $ - $ 6,093.52 792 Toyota Motor Credit 10/6/2017 500,000.00 503,545.00 3,545.00 499,523.50 716.67 3/12/2020 1.85% $ (716.67) 5 - $ 1,400.30 833 Subtotal $ 50,939,393.57 $ 59,393.57 5 50633,600.05 $ 12,668.80 $ 713,421.16 5 619,549.26 $ 236,298.46 BNY MM 70,575.44 70,575.44 0.00% LAIF 12/31/14 6,223,682.60 6,223,682.60 1.14% 29,477.15 $57,233,651.61 $56,917,858.09 $ 713,42L16 $ 619,549.26 $ 265,775.62 Bank of the West Matured Assets Treasury 06/09/15 1,000,000.00 1,004,140.63 4,140.63 9/15/2017 0.82% $ 22,663.04 $ 16,846.70 5 1,724.99 FNMA 10/19/12 1,500,000.00 1,504,050.00 4,050.00 9/20/2017 0.94% 5 73,791.67 $ 66,614.26 $ 3,185.06 FNMA 11/30/12 1,010,000.00 1,003,200.00 3,200.00 9/20/2017 0.93% $ 48,055.56 $ 42,785.13 $ 2,097.06 FNMA 12/04/12 1,000,000.00 1,002,750.00 2,750.00 9/20/2017 0.94% $ 47,916.67 $ 43,077.49 $ 2,117.72 FFCB 10/113/12 2,000,000.00 1,996,960.00 (3,040.00) 9/21/2017 0.86% $ 81,755.00 $ 80,942.48 5 3,915.05 FHLMC 3/27/2017 1,000,000.00 999,750.00 (250,00) 9/27/2017 1.52% $ 8,750.00 $ 4,683.87 5 4,388.05 Toyota Motor Credit 07/10/15 500,000.00 502,200.00 2,200.00 10/5/2017 L05% $ 13,975.69 $ 10,406.77 $ 1,400.08 0 Chevron 12/15/2015 1,250,000.00 1,252,262.50 2,262.50 4N/A 11/9/1017 1.25% $ 32,293.33 $ 24,080.64 $ 5,645.90 0 Total Investments "Matured" $9,265,313.13 Maturity Profile Market to Cost Pusitlor Amount $30,093,172.64 514,330,411.53 $12,810,067.44 50.00 557,233,651.61 Amortized Institut on Cost 8NY Assets 550,939,393.57 BNY MM 70,575.44 IAIF 6,223,682.60 Totals: $57,233,651.61 $ 1,042,622.12 $ 908,986.61 $ 290,249.52 Page 5 Town of Los Gatos Summary Investment Information October 31, 2017 Weighted Average YTM Portfolio Yield: 1.35% Weighted Average Maturity (days) 403 This Month Last Month One year ago Portfolio Balance $67,417,299 $67,380,046 $69,818,409 Benchmarks/ References: Town's Average Yield LAIF Yield for month 3 mo. Treasury 6 mo. Treasury 2 yr. Treasury 5 yr. Treasury (most recent) 10 Yr. Treasury 2 - 3 years 25% 1..35% 1.14% 1.13% 1.28% 1.60% 2.02% 2.38% 3 - 5 years 15% 1.37% 1.11% 1.05% 1.19% 1.49% 1.94% 2.33% Portfolio Maturity Profile 0.86% 0.64% 0.30% 0.49% 0.84% 1.31% 1.83% 1- 2 years 30% Compliance: The Town's investments are in compliance with the Town's investment policy dated May 16, 2017 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 Town of Los Gatos Portfolio Allocation & Treasurer's Fund Balances October 31, 2017 Fund Balances - Beginning of Month/Period Receipts Disbursements Fund Balances - End of Month/Period Portfolio Allocation: BNY MM US Treasury Notes Government Agency Debenture Notes Corporate Medium Term Bonds Local Agency Investment Fund Subtotal - Investments Reconciled Demand Deposit Balances Total Treasurer's Fund Month YTD $67,380,045.53 $75,983,998.32 2,829,944.39 9,179,001.18 (2,792,691.24) (17,745,700.82) $67,417,298.68 $67,417,298.68 $152,415.69 $7,997,539.06 $28,454,414.00 $13,869,323.51 6,223,682.60 56,697,374.86 10,719,923.82 $67,417,298.68 Portfolio Investment Allocation Local Agency Investment Fund BNY MM 11.0% 0 2/% Corporate Medium Term Bonds 24.5% 76,000,000 74,000,000 72,000,000 70,000,000 68,000,000 66,000,000 64,000,000 62,000,000 60,000,000 % of Portfolio Max. % 0r $ Allowed Per State Law or Policy 0.27% 14.11% 50.19% 24.46% 10.98% 100.00% 20% of Town Portfolio No Max. on US Treasuries No Max. on Non -Mortgage Backed 30% of Town Portfolio $65M per State Law US Treasury Notes 14.11% Government Agency Debenture Notes 50.19% Treasurer's Fund Balances page 2 Town of Los Gatos Non -Treasury Restricted Fund Balances October 31, 2017 Non -Treasury Funds: Cert. of Participation 2002 Series A Reserve Fund Cert. Of Participation 2002 Ser A Lease Pymt Fund Cert. of Participation 2002 Series A Const. Fund Total Restricted Funds: OCT 17 OCT 17 OCT 17 Previous Deposits Ending Balance Realized Gain/Adj. Interest Withdrawals Balance $ 687,062.95 $ 249.32 $ 687,312.27 Note 1 286.91 0.25 287.16 Note 1 72.24 72.24 Note 1 1,283,504.36 934.57 1,284,438.93 Note2 $ 1,970,926.46 $0.00 $1,184.14 $0.00 $1,972,110.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. Page 3 Town of Los Gatos Statement of Interest Earned October 31, 2017 Interest by Month July 2017 August 2017 September 2017 October 2017 November 2017 December 2017 January 2018 February 2018 March 2018 April 2018 May 2018 June 2018 $58,520.73 54,113.45 50,380.68 66,971.08 $229,985.94 Page 4 Town of Los Gatos Investment Schedule October 31, 2017 0rginal Issue Maturity Yield to Interest Interest Interest Days Deposit Par Original (Discount) Market Purchased Date or Maturity Received Earned Earned to Institution 1b«to Value Cost Premium Value Interest IU I Date or Call to Date Prior Yrs. Current FY Muu Freddie Mac 08/01/16 1,000,000.00 1,005,560.00 5,560.00 993,509.00 4/15/2019 0.92% $ 12,812.50 5 8,387.83 $ 3,098.21 531 Toyota Motor Credit 07/25/16 950,000.00 954,246.50 4,246.50 944,828.20 5/20/2019 1.24% $ 10,898.61 $ 10,985.92 $ 3,974.32 566 FHLB 9/20/2017 1,785,000.00 1,776,432.00 (8,568.00) 1,767,614.10 6,681.35 6/12/2020 1.56% $ (6.681.35) $ - 5 3,109.67 955 US Bancorp 8/8/2016 1,000,000.00 1,019,550.00 19,550.00 1,002,386.00 10/15/2018 1.08% 5 15,004.17 $ 9,429.85 $ 3,557.89 349 Microsoft 8/8/2016 1,000,000.00 999,470.00 (530.00) 989,634.00 8/8/2019 1.12% $ 11,000.00 $ 9,982.45 $ 3,766.38 646 FFCB 9/20/2017 1,600,000.00 1,602,304.00 2,300.00 1,596,256.00 4/6/2020 1.54% 5 1,137.78 $ - $ 2,773.93 888 FNMA 9/21/2017 1,300,000.00 1,295,866.00 14,134.00) 1,288,976.00 379.17 9/14/2020 1.61% 5 1379.17) $ • $ 2,288.83 1049 US Treasury 9/21/2017 1,000,000.00 997,109.38 (2,890.621 992,188.00 4,245.22 5/31/2020 1.48% $ (4.245.22) $ - 5 1,624.47 943 FHLB 12/12/12 2,000,000.00 1,998,720.00 11,280.001 1,999,322.00 12/8/2017 0.76% $ 66,083.33 $ 69,427.17 5 5,141.21 38 FNMA 04/17/13 1,000000.00 L004,400.00 4,400.00 999,390.00 3/5/2018 1.03% $ 49,312.50 5 43,523.65 5 3,487.56 125 AAPL 05/16/13 1,000,000.00 991,680.01 (8,319.99) 997,796.00 5/3/2018 1.17% 5 39,638.89 $ 48,171.42 $ 3,934.32 184 FHLB 06/09/15 1,000,000.00 997,710.00 (2,290.00) 998,350.00 8/27/2018 1.22% $ 25,491.66 5 25,158.75 $ 4,115.06 300 American Express 9/15/2017 1,000,000.00 1,007,980.00 7,980.00 1,002,938.00 733.33 1/2/2020 1.87% $ (733.33) $ 5 2,335.08 793 Treasury 06/11/15 1,000,000.00 990,468.75 (9,531.25) 997,656.00 4/15/2018 L0996 $ 17,581.97 $ 22,291.07 $ 3,655.74 166 FHLB 06/11/15 2,000,000.00 1,991,820.00 (8,180.00) 1,997,540.00 5/25/2018 1.19% $ 41,533.33 $ 48,836.51 5 8,009.19 206 Trexury 07/31/15 1,000,000.00 1,010,625.00 10,625.00 1,000,080.00 6/30/2018 1.0096 S 26,341.71 $ 19,386.29 $ 3,406.45 242 FFCB 07/30/15 2,50 .000.00 2,509,525.00 9,525.00 2,499,887.50 12/18/2017 0.96% $ 52,968.75 $ 46,358.27 $ 8,134.19 48 FHLB 8/20/2015 1,250,000.00 1,247,075.00 (2,925.00) 1,247,175.00 7/25/2018 1.13% $ 25,666.67 $ 26,310.93 $ 4,759.18 267 FHLB 8/25/2015 1,000,000.00 999,500.00 1500.001 997,740.00 7/25/2018 1.07% $ 20,387.50 5 19,734.71 5 3,596.10 267 Walmart 9/25/2015 1,000,000.00 998,960.00 (1,040.00) 998,769.00 4/11/2018 1.17% $ 23,000.00 5 20,570.26 5 3,928.79 162 Disney 9/25/2015 995,000.00 995,298.50 298.50 994,856.72 12/1/2017 1.09% $ 18,024.08 $ 19,070.28 5 3,642.31 31 FFCB 10/27/2015 1,030,000.00 1,048,230.00 48,230.00 1,007,820.00 6/1/2018 0.86% 5 43,847.22 $ 14,973.77 5 3,009.43 213 FHLB 10/27/2015 1,000,000.00 1,005,030.00 5,030.130 997,267.00 9/14/2018 0.95% $ 21,156.25 $ 15,939.59 5 3,203.55 318 FFCB 10/29/2015 1,500,000.00 1,494,840.00 (5,160.00) 1,491,945.00 10/9/2018 0.99% $ 25,520.83 $ 24,860.21 $ 5,012.80 343 Chevron 12/15/2015 1,250,000.00 1,252,262.50 2,262.50 1,249,885.00 11/9/2017 1.25% $ 23,893.33 $ 24,080.64 5 5,260.96 9 Treasury 1/26/2016 1,500,003.00 1,494,902.34 (5,097.66) 1,497,675.00 2/28/2018 0.91% $ 17,925.82 $ 19,534.50 $ 4,611.79 120 Wells Fargo 2/2/2016 1,000,000.00 1,001,680.00 1,680.00 1,000.340.00 1/22/2018 1.56% $ 24.612.50 $ 22,036.28 $ 5,273.27 83 FHLMC 4/29/2016 1,000,000.00 1,008,050.00 8,050.00 996,78000 12/17/2018 1.04% 5 15,300.00 5 12,220.02 9 3,520.05 412 FFCB 4/29/2016 1,000,000.00 1.001,870.00 1,870.00 944,370.00 3/21/2019 1.09% $ 16,175.56 5 12,814.27 5 3,691.23 506 FFCB 10/28/2016 1,003,000.00 997,507,00 (2,493.00) 987,840.00 10/17/2019 1.14% $ 10,179.17 5 7,611.40 $ 3,821.23 716 FNMA 11/15/2016 1,500,000.00 1,487,505.00 (12,495.00) 1,483,273.50 - 8/28/2019 1.31% $ 11,791.66 $ 12,120.46 5 6,567.48 666 FHLMC 3/14/2017 2,000,000.00 1,970,180.00 (29,820.00) 1,975,188.00 7/19/2019 1.52% $ 6,076.39 5 8,936.03 $ 10,177.14 626 Freddie Mac 9/29/2017 1,000,000.00 998,900.00 (1,100.00) 995,860.00 6/29/2018 1.67% $ • $ - $ 1,553.60 241 IP Morgan Chase 3/28/2017 1,400,000.00 1,393,196.00 (6,804.00) 1,395,378.60 8/23/2019 1.86% $ 11,229.17 5 6.677.49 $ 8,737.56 661 US Treasury 3/31/2017 1,000,000.00 1,004,218.75 4,218.75 99.3,570.00 3/31/2019 1.29% 5 7,500.00 $ 3,213.83 $ 4,343.96 516 FNMA 4/25/2017 1,000,000.00 1,013,390.00 13,390.00 1,004,050.00 2/7/2020 1.50% $ 5,666.67 $ 2,748.32 $ 5,121.88 829 PNC Bank 4/4/2017 1,000,000.00 1,003,120.00 3,120.00 1,000,766.00 2/2/2019 1.29% $ 8,125.00 $ 4,242.21 5 5,997.60 459 Treasury 5/2/2017 560,000.00 503,339.84 3,339.84 500,390.50 6/30/2019 1.31% 5 1,324.24 5 1,063.61 5 2,217.35 607 Pspnm 5/15/2017 1,250,000.00 1,249,600.00 (400.00) 1,248,823.75 3/30/2020 1.31% $ 10,598.96 5 2,931.91 $ 7,839.67 881 Plirsr 6/30/2017 1,000,000.00 1,002,280.00 2,280.00 999,047.00 708.33 12/15/2019 1.60% $ (708.331 $ - 5 5,416.47 775 Treasury 6/30/2017 1,000,000.00 1,002,148.44 2,148.44 998,086.00 10/31/2019 1.41% $ 5,013.59 $ - $ 4,745.00 730 Treasury 6/30/2017 1,000,000.00 994,726.56 (5,273.44) 991,445.00 1/31/2020 1.46% $ 1,070.44 $ - $ 4,898.71 822 Toyota Motor Credit 10/6/2017 500,000.00 503,545.00 3,545.00 502,470.00 716.67 3/12/2020 1.85% 5 (716.67) $ - 5 636.50 863 Subtotal $ 50,824821.57 5 44,821.57 $ 50,625,161.87 $ 13,464.07 5 710,826.18 5 643,629.90 $ 187,996.12 BNY MM 152,415.69 152,415.69 0.00% 1 LAIF 12/31/14 6,223,682.60 6,223,682.60 1.14% 23,161.82 1 557,200,919.86 $57,001,260.16 5 710,826.18 9 643,629.90 5 211.157.93 Bank of the West Matured Assets Treasury 06/09/15 1,000,000.00 1,004,140.63 4,140.63 9/15/2017 0.82% $ 22,663.04 $ 16,806.70 $ 1,724.99 FNMA 10/19/12 1,500,000.00 1,504,050.00 4,050.00 9/20/2017 0.94% $ 73,791.67 $ 66,614,26 $ 3,185.06 FNMA 11/30/12 1,000,000.00 1,003,200.00 3,200.00 9/20/2017 0.93% 5 48,055.56 $ 42,785.13 5 2,097.06 FNMA 12/04/12 1,000,000.00 1,002,750.00 2,750.00 9/20/2017 0.94% $ 47,916.67 $ 43,077.49 $ 2,117.72 FFCB 10/18/12 2,000,000.00 1,996,960.00 (3,040.00) 9/21/2017 0.86% $ 81,755.00 $ 80,942.48 5 3,915.05 FHLMC 3/27/2017 L000,000.00 999,750.00 (250.00) 9/27/2017 1.52% 5 8,750.00 $ 4,683.137 $ 4,388.05 Toyota Motor Credit 07/10/15 500,000.00 502,200.00 2,200.00 10/5/2017 1.0596 $ 13,975.69 $ 10A06.77 $ 1,400.08 0 Total Investments "Matured" Maturity Profile Market to Cost Posinior 58,013,050.63 $ 1.007,733.81 $ 908,986.61 $ 229,985.94 Amount $31,427,275.39 513,328,263.09 $12,445,381.38 $0.00 $57,200,919.86 Amortized Institution Cost 8NY Assets 550,824,821.57 8NY MM 152,415.69 LAIF 6,223,682.60 Totals: 557,200,919.86 Page 5