Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Attachment 1
Weighted Average 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 2 - 3 years 25% Town of Los Gatos Summary Investment Information March 31, 2017 0.98% Weighted Average Maturity (days) 385 This Month Last Month One Year ago $72,979,656 $72,979,311 $70,638,421 0.98% 0.82% 0.75% 0.90% 1.26% 1.92% 2.39% 0.91% 0.72 % 0.61% 0.74% 1.26% 1.93% 2.39% Portfolio Maturity Profile 0.76% 0.45% 0.20% 0.38% 0.72% 1.21% 1.77% 1 - 2 years 30% Compliance: The Town's investments are in compliance with the Town's investment policy dated November 1, 2016 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 March 31, 2017 Month YTD Fund Balances - Beginning of Month/Period $72,979,311.32 $74,913,936.39 Receipts 3,647,343.04 31,012,544.61 Disbursements (3,646,998.70) (32,946,825.34) Fund Balances - End of Month/Period 572,979,655.66 $72,979,655.66 Portfolio Allocation: BNY MM US Govt Agencies & Corp. Bonds Local Agency Investment Fund Subtotal - Investments Reconciled Demand Deposit Balances Total Treasurer's Fund Local Agency Investment Fund 7.95% $1,028,380.31 47,651,781.92 4,205,831.01 52,885,993.24 20,093,662.42 $72,979,655.66 Portfolio Investment Allocation BNY MM 1.94% US Govt Agencies & Corp. Bonds 90.10% 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 Treasurer's Fund Balances page 2 Town of Los Gatos Non -Treasury Restricted Fund Balances March 31, 2017 MAR 17 MAR 17 MAR 17 Previous Deposits Ending Balance Realized Gain/Adi. Interest Withdrawals Balance Non -Treasury Funds: Cert. of Participation 2002 Series A Reserve Fund $ 686,268.36 $ 5.28 $ - $ 686,273.64 Note 1 Cert. Of Participation 2002 Ser A Lease Pymt Fund 28.76 0.00 0.00 0.00 28.76 Note 1 Cert. of Participation 2002 Series A Const. Fund 0.58 0.00 0.00 0.00 0.58 Note 1 COP 2010 Library Reserve Fund 1,278,796.75 0.00 369.71 0.00 1,279,166.46 Notez Total Restricted Funds: $1,964,239.87 $0.00 $374.99 $0.00 $1,965,469.44 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 March 31, 2017 Interest by Month July 2016 August 2016 September 2016 October 2016 November 2016 December 2016 January 2017 February 2017 March 2017 April 2017 May 2017 June 2017 $40,143.04 41,290.98 39,945.53 40,937.76 41,154.71 42,859.62 43,069.29 39,281.97 43,826.01 $372,508.91 Page 4 Town of Los Gatos Investment Schedule March 31, 2017 Orginal Issue Maturity Yield to Interest Interest Interest Days Deposit Par Original (Discount) Market Purchased Date or Maturity Received Earned Earned to Institution Secur Date Value Cost Premium yitia Interest Call Date or Cab to Date Prior Yrs. Current. FY Matur' PFIZER Corporate Note 03/11/15 750,000.00 753,037.50 3,037.50 749,839.88 5/15/2017 0.91% $ 13,727.08 $ 8,855.98 $ 5,140.97 45 Freddie Mac Coupon Note 08/01/16 1,000,000.00 1,005,560.00 5,560.00 995,161.00 4/15/2019 0.92% $ 1,562.50 $ $ 6,095.66 745 ToyotaMotor Credit Coupon Note 07/30/15 500,000.00 502,200.00 2,200.00 499,817.50 10/5/2017 1.05% $ 7,725.69 $ 5,138.43 $ 3,954.86 188 Toyota Motor Credit Corporate Note 07/25/16 950,000.00 954,246.50 4,246.50 942,416.15 5/20/2019 1.24% $ 4,248.61 $ $ 780 Treasury Note 06/23/14 500,000.00 499,804.69 (195.31) 500,079.00 4/30/2017 0.8936 $ 10,295.52 $ 8,984.22 $3,335.608p45.57 30 Berk Hath Coupon Note 01/11/13 500,000.00 509,280.00 9,280.00 500,106.00 5/15/2017 1.61% $ 30,755.56 $ 20,335.65 $ 4,401.24 45 FNMA Callable Note 10/19/12 1,500,000.00 1,504,050.00 4,050.00 1,500,087.00 9/20/2017 0.9436 $ 66,291.67 5 52,436.88 $ 10,642.74 173 US Bancorp Corporate Note 8/8/2016 1,000,000.00 1,019,550.00 19,550.00 1,005,990.00 10/15/2018 1.0894 $ 5,254.17 $ 5 6,797,59 563 Microsoft Corporate Note 8/8/2016 1,000,000.00 999,470.00 (530.00) 989,079.00 8/8/2019 1.1236 $ 5,500.00 $ 5 7,195.94 860 FNMA Callable Note 11/30/12 1,000,000.00 1,003,200.00 3,200.00 1,000,058.00 9/20/2017 0.93% $ 43,055.56 $ 33,450.66 5 7,007.25 173 FNMA Callable Note 12/04/12 1,000,003.00 1,002,750.00 2,750.00 1,000,058.00 9/20/2017 0.94% $ 42,916.67 $ 33,651.06 $ 7,076.28 173 FFCB Coupon Note 10/18/12 2,003,000.00 1,996,960.00 (3,040.00) 1,999,220.00 9/21/2017 0.86% $ 73,455.00 5 63,725.70 5 12,924.38 174 FHLB Coupon Note 12/12/12 2,OOO,OOO.O0 1,998,720.00 (1,280.00) 1,995,480.00 12/8/2017 0.76% $ 58,583.33 5 54.170.75 5 11,452.77 252 FNMA Callable Note 04/17/13 1,000,000.00 1,004,400.00 4,400.00 998,660.00 3/5/2018 1.03% $ 43,687.50 $ 33,174.36 $ 7,769.04 339 AAPL Corporate Note 05/16/13 1,000,000.00 991,680.01 (8,319.99) 996,976.00 5/3/2018 1.1736 $ 34,638.89 5 36,496.41 $ 8,764.26 398 FHLB Coupon Note 06/09/15 1,000,000.00 997,710.00 (2,290.00) 999,400.00 8/27/2018 1.22% $ 19,741.66 5 12,947.39 $ 9,166.89 514 Treasury Note 06/09/15 1,000,000.00 1,000,468.75 468.75 999.766.00 6/30/2017 0.73% $ 11,685.08 5 7,710.82 $ 5,459.34 91 Treasury Note 06/09/15 1,000,000.00 1,004,140.63 4,140.63 1,000,469.00 9/15/2017 0.82% $ 17,663.04 5 8,669.78 $ 6,138.29 168 Treasury Note 06/11/15 1,000,000.00 990,468.75 (9,531.25) 996,406.00 4/15/2018 1.09% 5 10,081.97 5 11,442.75 5 8,143.67 380 FHLB Coupon Note 06/11/15 2,000,000.00 1,991,820.00 (8,180.00) 1,997,100.00 5/25/2018 1.1936 5 31,033.33 $ 25,069.41 5 17,841.60 420 Treasury Note 07/31/15 1,000,000.00 1,010,625.00 10,625.00 1,002,891.00 6/30/2018 1.00% $ 19,466.71 $ 9,277.73 $ 7,588.35 456 FFCB Coupon Note 07/30/15 2,500,000.00 2,509,525.00 9,525.00 2,501,405.00 12/18/2017 0.96% $ 38,906.25 $ 22,220.23 $ 18,120.07 262 FHLB Coupon Note 8/20/2015 1,250,000.00 1,247,075.00 (2,925.00) 1,247,575.00 7/25/2018 1.13% $ 19,104.17 $ 12,188.15 $ 10,601.76 481 FHLB Coupon Note 8/25/2015 1,000,000.00 999,500.00 (500.00) 998,060.00 7/25/2018 1.07% $ 15,137.50 $ 9,063.35 5 8,010.83 481 FFCB Coupon Note 8/27/2015 1,000,000.00 1,002,060.00 2,060.00 1,000,050.00 4/24/2017 0.63% $ 11,187.50 5 5,281.77 $ 4,698.72 24 Walmart Corporate Note 9/25/2015 1,000,000.00 998,960.00 (1,040.00) 998,248.00 4/11/2018 1.17% $ 11,750.00 $ 8,911.65 $ 8,751.94 376 Disney Corporate Note 9/25/2015 995,000.00 995,298.50 298.50 993,623.92 12/1/2017 1.09% $ 12,951.58 $ 8,261.82 $ 8,113.75 245 FFCB Coupon Note 10/27/2015 1,003,000.00 1,048,230.00 48,230.00 1,018,770.00 6/1/2018 0.8636 5 30,097.22 5 6,043.33 $ 6,703.94 427 FHLB Coupon Note 10/27/2015 1,000,000.00 1,005,030.00 5,030.00 998,069.00 9/14/2018 0.95% 5 15,531.25 $ 6,433.14 $ 7,136.35 532 FFCB Coupon Note 10/29/2015 1,500,000.00 1,494,840.00 (5,160.00) 1,492,755.00 10/9/20113 0.9916 $ 12.395.83 $ 9,984.84 $ 11,166.72 557 Chevron Corporate Note 12/15/2015 1,250,000.00 1,252,262.50 2,262.50 1,250,418.75 11/9/2017 1.25% $ 15,493.33 $ 8,468.86 $ 11,719.53 223 Treasury Note 1/26/2016 1,500,000.00 1,494,902.34 (5,097.66) 1,495,782.00 2/28/2018 0.91% $ 12,300.82 $ 5,849.10 $ 10,273.02 334 Wells Fargo Corporate Note 2/2/2016 1,000,000.00 1,001,680.00 1,680.00 999,442.O0 1l22/2018 1.5636 $ 16,362.50 $ 6,387.95 $ 11,746.97 297 FHLMC Coupon Note 4/29/2016 1,000,000.00 1,008,050.00 8,650.00 1,000,320.00 12/17/2018 1.0436 $ 8,550.00 $ 1,774.34 5 7,841.42 626 FFCB Coupon Note 4/29/2016 1,000,000.00 1,001,870.00 1,870.00 997,680.00 3/21/2019 1.09% 5 10,375.56 $ 1,860.62 5 8,222.74 720 FFC8 Coupon Note 10/28/2016 1,000,000.00 997,507.00 2,493.00 988,150.00 320.83 10/17/2019 1.14% $ (320.83) $ - 5 4,784,31 930 FNMA Coupon Note 11/15(2016 1,500,000.00 1,487,505.00 12,495.00 1,484,065.50 8/28/2019 1.31% $ 4,291.66 $ - $ 7,261.60 880 FHLMC Coupon Note 3/14/2017 2,000,000.00 1,970,160.00 29,820.00 1,975,698.00 2,673:61 7/19/2019 1.5236 $ (2,673.61) $ - $ 1A06,60 840 FHLMC Coupon Note 3/27/2017 1,000,000.00 999,750.00 250.00 999,730.00 - 9/27/2017 1.5236 $ $ 5 197.22 180 1P Morgan Chase Corporate Note 3/28/2017 1,400,000.00 1,393,196.00 6,804.00 1,392,731.20 320.83 8/23/2019 1.86% $ (320.83) 5 - $ 213.11 875 US Treasury Note 3/31/2017 1,000,000.00 1,004,218.75 (4,218.75) 1,004,727.00 - 3/31/2019 1.2936 5 - 5 - 5 730 Subtotal 5 47,651,781.92 $ 152,068.42 $ 47,506,359.90 $ 3,315.27 $ 782,489.45 $ 538,267.12 5 311,913.29 BNY MM 1,028,380.31 1,028,380.31 LAIF N/A 12/31/14 4,205,831.01 4,205,831.01 21,712.29 552,885,993.24 552,740,571.22 $ 782,499.45 $ 538,267,12 $ 333,625.58 Bank of the West Matured Assets IBM Corporation Corporate Note 11/13/12 750,000.00 782,505.00 32,505.00 7/22/2016 0.76% $ 53,990.62 $ 21,116.64 $ 350.62 Treasury Note 08/16/11 1,000,000.00 1,025,390.63 25,390.63 8/1/2016 0.97% $ 74,347.83 5 48,194.68 $ 1,273.97 Treasury Note 06/10/14 1,000,00,3.00 1,000,000.00 0.00 8/4/2016 0.00% $ 13,434.10 $ 12,859.59 $ 574.51 Treasury Note 06/10/14 1,000,000.00 1,004,062.50 4,062.50 8/4/2016 0.42% $ 23,107.73 5 14,121.82 $ 658.14 FNMA Callable Note 03/28/14 1,000,000.00 1,014,600.00 14,600.00 9/28/2016 0.66% 5 31,250.00 $ 15,089.49 $ 1,646.13 FNMA Callable Note 05/14/13 1,500,000.00 1,500,000.00 0.00 11/14/2016 0.55% $ 28,875.00 $ 25,834.93 $ 3,096.58 FNMA Callable Note 04/04/13 4,000,000.00 4,064,800.00 4,800.00 3/14/2017 0.72% $ 118,333.33 $ 93,289.54 $ 20,266.62 Treasury Note 05/27/14 2,000,000.00 2015,156.25 15,156.25 3/31/2017 0.73% $ 46,885.25 $ 30,758.49 $ 11,016.77 Total Investments "Matured" $12,346,514.38 $ 1.172,713.31 $ 799,532.32 $ 372,508.91 Maturity Profile 01 year 1-2 years 2-3 years 3-5 years Market to Cost Position Report Amount 527,268,701.23 $15,805,408.76 $9,811,883.25 $0.00 $52,885,993.24 Amortised Institution CO51 8NY Assets 547,651,781.92 BNY MM 1,028,380,31 LAIF 4,205,831.01 Totals: $52,885,993.24 Page 5 Weighted Average 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 2 - 3 years 25% Town of Los Gatos Summary Investment Information February 28, 2017 0.91% Weighted Average Maturity (days) 341 This Month Last Month One year ago $72,979,311 $73,735,874 $69,921,985 0.91% 0.72% 0.61% 0.74% 1.26% 1.93% 2.39% 0.88% 0.74% 0.52% 0.63% 1.21% 1.91% 2.45% Portfolio Maturity Profile 0.76% 0.40% 0.32% 0.47% 0.78% 1.21% 1.74% 1- 2 years 30% Compliance: The Town's investments are in compliance with the Town's investment policy dated November 1, 2016 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 February 28, 2017 Fund Balances - Beginning of Month/Period Receipts Disbursements Fund Balances - End of Month/Period Portfolio Allocation: BNY MM US Govt Agencies & Corp. Bonds Local Agency Investment Fund Subtotal - Investments Reconciled Demand Deposit Balances Total Treasurer's Fund Local Agency Investment Fund 7.96% Month YTD $73,735,873.61 $74,913,936.39 2,540,498.19 27,365,201.57 (3,297,060.48) (29,299,826.64) $72,979,311.32 $72,979,311.32 $325,771.20 48,304,393.42 4,205,831.01 52,835,995.63 20,143,315.69 $72,979,311.32 Portfolio Investment Allocation BNY MM 0.62% US Govt Agencies & Corp. Bonds 91.42% 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 Treasurer's Fund Balances page 2 Town of Los Gatos Non -Treasury Restricted Fund Balances February 28, 2017 FEB17 FEB17 FEB17 Previous Deposits Ending Balance Realized Gain/Adi. interest Withdrawals Balance Non -Treasury Funds: Cert. of Participation 2002 Series A Reserve Fund $ 686,262.51 $ 5.85 $ $ 686,268.36 Note 1 Cert. Of Participation 2002 Ser A Lease Pymt Fund 244,012.50 0.00 28.76 244,012.50 28.76 Note t Cert. of Participation 2002 Series A Const. Fund 174,208.75 0.00 0.58 174,208.75 0.58 Note t COP 2010 Library Reserve Fund 1,278,431.05 0.00 365.70 0.00 1,278,796.75 Note 2 Total Restricted Funds: $1,964,239.87 $0.00 $400.89 $418,221.25 $1,965,094.45 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 dosed in September 2010. Page 3 Town of Los Gatos Statement of Interest Earned February 28, 2017 Interest by Month July 2016 August 2016 September 2016 October 2016 November 2016 December 2016 January 2017 February 2017 March 2017 April 2017 May 2017 June 2017 $40,143.04 41,290.98 39,945.53 40,937.76 41,154.71 42,859.62 43,069.29 39,281.97 $ 328, 682.90 Page 4 Town of Los Gatos Investment Schedule February 28, 2017 Orginal Issue Maturity Yield to Interest Interest Interest Days Deposit Par Original (Discount) Market Purchased Date or Maturity Received Earned Earned to Institution Security Qe Value Cost Premium Value Interest Call Date or Call to Date Prior Yrs. Current FY Maturity PFIZER Corporate Note 03/11/15 750,000.00 753,037.50 3,037.50 750,229.50 5/15/2017 0.91% $ 13,727.08 5 8,855.98 $ 4,559.33 76 Freddie Mac Coupon Note 08/01/16 1,000,000.00 1,035,560.00 5,560.00 996,370.00 4/15/2019 0.92% 5 1,562.50 $ 5 5,314.81 776 Toyota Motor Credit Coupon Note 07/10/15 500,000.00 502,200.00 2,200.00 500,406.50 10/5/2017 1.05% $ 7,725.69 $ 5,138.43 $ 3,507.41 219 Toyota Motor Credit Corporate Note 07/25/16 950,000.00 954,246.50 4,246.50 943,297.75 5/20/2019 1.24% $ 4,248.61 $ $ 7,043.91 811 FNMA Callable Note 04/04/13 4,000,000.00 4,004,800.00 4,800.00 4,000,320.00 3/14/2017 0.72% 5 103,333.33 $ 93,289.54 $ 19,162.60 14 Treasury Note 05/27/14 2,000,000.00 2,015,156.25 15,156.25 2,000,986.00 3/31/2017 0.73% $ 46,885.25 $ 30,758.49 $ 9,770.34 31 Treasury Note 06/23/14 500,000.00 499,804.69 (195.31) 500,326.00 4/30/2017 0.89% $ 10,295.52 $ 8,984.22 $ 2,958.22 61 Berk Bath Coupon Note 01/11/13 500,000.00 509,280.00 9,280,00 500,768.00 5/15/2017 1.6194 $ 30,755.56 $ 20,335.65 5 3,903.29 76 FNMA Callable Note 10/19/12 1,500,000.00 1,504,050.00 4,050.00 1,502,124.00 9/20/2017 0.94% $ 511,791.67 5 52,436.88 $ 9,438.64 204 95 Bancorp Corporate Note 8/8/2016 1,000,000.00 1,019,550.00 19,550.00 1,007,408.00 10/15/2018 L08% $ 5,254.17 $ - $ 5,900.89 594 Microsoft Corporate Note 8/8/2016 1,000,000.00 999,470.00 (530.00) 990,108.00 8/8/2019 1.12% $ 5,500.00 $ - $ 6,246.68 891 FNMA Callable Note 11/30/12 1,000,000.00 1,003,200.00 3,200.00 1,001,416.00 9/20/2017 0.93% $ 38,055.56 $ 33,450.66 $ 6,214.46 204 FNMA Callable Note 12/04/12 1,000,000.00 1,002,750.00 2,750.00 1,001,416.00 9/20/2017 0.94% 5 37,916.67 $ 33,651.06 $ 6,275.68 204 FFCB Coupon Note 10/18/12 2,000,000.00 1,996,960.00 (3,040.00) 2,001,380.00 9/21/2017 0.86% 5 65,155.00 5 63,725.70 5 11,462.13 205 FHLB Coupon Note 12/12/12 2,030,000.00 1,998,720.00 (1,280.00) 1,997,800.00 12/8/2017 0.76% $ 58,583.33 5 54,170.75 $ 10,157.01 283 FNMA Callable Note 04/17/13 1,000,000.00 1,004,400.00 4,400.00 999,810.00 3/5/2018 1.03% $ 38,062.50 5 33,174.38 $ 6,890.06 370 AAPL Corporate Note 05/16/13 1,000,000.00 991,680.01 (8,319.99) 996,943.00 5/3/2018 1.17% $ 34,638.89 $ 36,496.41 $ 7,772.68 429 FHLB Coupon Note 06/09/15 1,000,000.00 997,710.00 (2,290.00) 999,470.00 8/27/2018 1.22% $ 19,741.66 $ 12,947.39 $ 8,129.76 545 Treasury Note 06/09/15 1,000,000.00 1,000,468.75 468.75 1,000,624.00 6/30/2017 0.73% $ 11,685.08 $ 7,710.82 $ 4,841.68 122 Treasury Note 06/09/15 1,000,000.00 1,004,140.63 4,140.63 1,001,484.00 9/15/2017 0.8216 5 12,663.04 5 8,669.78 $ 5,443.82 199 Treasury Note 06/11/15 1,000,000.00 990,468,75 (9,531.25) 997,383.00 4/15/2018 1.09% $ 10,081.97 5 11,442.75 5 7,222.31 411 FHLB Coupon Note 06/11/15 2,000,000.00 1,991,820.00 (8,180.00) 1,997,060.00 5/25/2018 1.19% $ 31,033.33 $ 25,069.41 $ 15,823.03 451 Treasury Note 07/31/15 1,000,000.00 1,010,625.00 10,625.00 1,004,531.00 6/30/2018 1.00% $ 19,466.71 5 9,277.73 $ 6,729.81 487 FFCB Coupon Note 07/30/15 2,500,000.00 2,509,525.00 9,525.00 2,506,432.50 12/18/2017 0.9696 $ 38,906.25 $ 22,220.23 $ 16,069.99 293 FHL8 Coupon Note 8/20/2015 1,250,000.00 1,247,075.00 (2,925.00) 1,247,537.50 7/25/2018 1.13% 5 19,104.17 5 12,188.15 5 9,402.29 512 9818 Coupon Note 8/25/2015 1,000,000.00 999,500.00 (500.00) 998,030.00 7/25/20113 1.0794 5 15,137.50 5 9,063.35 5 7,104.50 512 FFCB Coupon Note 8/27/2015 1,000,000.00 1,002,060.00 2,060.00 1,000,410.00 4/24/2017 0.63% $ 11,187.50 $ 5,281.77 5 4,167.11 55 Warman Corporate Note 9/25/2015 1,000,00000 998,960.00 (1,040.00) 999,100,00 4/11/2018 1.17% $ 1L750.00 $ 8,911.65 $ 7,761.76 407 Disney Corporate Note 9/25/2015 995,000.00 995,298.50 298.50 994,667.67 12/1/2017 1.09% $ 12,951.58 $ 8,261.82 $ 7,195.77 276 FFCB Coupon Note 10/27/2015 1,000,000.00 1,048,230.00 48,230.00 1,020,180.00 6/1/2018 0.86% 5 30,097.22 5 6,043.33 $ 5,945.47 458 FHLB Coupon Note 10/27/2015 1,000,000.00 1,005,030.00 5,030.00 1,000,056.00 9/14/2018 0.95% 5 9,906.25 5 6,433.14 5 6,328.96 563 FFC8 Coupon Note 10/29/2015 1,500,000.00 1,494,840.00 (5,160.00) 1,492,500.00 10/9/2018 0.99% $ 12,395.83 $ 9,984.84 $ 9,903.33 588 Chevron Corporate Note 12/15/2015 1,250,000.00 1,252,262.50 2,262.50 1,251,131.25 11/9/2017 1.25% $ 15,493.33 $ 13,468.86 $ 10,393.60 254 Treasury Note 1/26/2016 1.500.000.00 1,494,902.34 (5,097.66) 1,497,012.00 2/28/2018 0.9194 $ 12,300.82 $ 5,849.10 5 9,111.10 365 Webs Fargo Corporate Note 2/2/2016 1,000,000.00 1,001,680.00 1,680.00 1,001,528.00 1/22/2018 1.56% $ 16,362.50 $ 6,387.95 $ 10,417.93 328 FHLMC Coupon Note 4/29/2016 1,000,000.00 1,008,050.00 8,050.00 1,000,810.00 12/17/2018 1.04% $ 8,550.00 5 1,774.34 5 6,954.25 657 FFCB Coupon Note 4/29/2016 1,000,000.00 1,001,870.00 1,870.00 997,930.00 3/21/2019 1.09% 5 4,575.56 $ L860.62 $ 7,292.43 751 FFCB Coupon Note 10/28/2016 1,000,000.00 997,507.00 2,493.00 987,910.00 320.83 10/17/2019 1.14% $ (320.83) $ - 5 3,821.23 961 FNMA Coupon Note 11/15/2016 1.500.000.00 1,487,505.00 12,495.00 1,484,136.00 • 8/28/2019 1.31% $ 4,291.66 $ - $ 5,606.38 911 Subtotal 5 48,304,393.42 $ 139,369.42 $ 48,171,031.67 $ 320.83 $ 887,852.47 $ 662,315.16 5 302,244.65 BNY MM 325,771.20 325,771.20 LAIF 8/0 12/31/14 4,205,831.01 4,205,831.01 18,838.30 552,835,995.63 $52,702,633.88 5 887,852.47 5 662,315.16 $ 321,082.95 Bank of the West Matured Assets IBM Corporation Corporate Note 11/13/12 750,000-00 782,505.00 32,505.00 7/22/2016 0.76% $ 53,990.62 5 21,116.64 $ 350.62 Treasury Note 08/16/11 1,000,000.00 1,025,390.63 25,390.63 8/1/2016 0.97% $ 74,347.83 5 48,194,68 $ 1,273.97 Treasury Note 06/10/14 1,000,000.00 1,000,003.00 0.00 8/4/2016 0.00% 5 13,434.10 $ 12,859.59 $ 574.51 Treasury Note 06/10/14 1,000,000.00 1,004,062.50 4,062.50 8/4/2016 0.42% $ 23,107.73 $ 14,121.82 $ 658.14 FNMA Callable Note 03/28/14 1,000,000.00 1,014,600.00 14,601100 9/28/2016 0.66% $ 31,250.00 $ 15,089.49 $ 1,646.13 FNMA Callable Note 05/14/13 1,500,000.00 1,500,000.00 0.00 11/14/2016 0.5596 $ 28,875.00 $ 25,834.93 $ 3,096.58 Total Investments "Matured" 56,326,558.13 Maturity Profile 0-1 year 1-2 years 2-3 years 3-5 years Market to Cost Position Report Institution BNY Assets BNY MM IAIF Totals: Amount $30,581,898.37 $15,807,938.76 $6,446,158.50 50.00 $52,835,995.63 Amortized Cost $48,304,393A2 325,771.20 4,205,831.01 552,835,995.63 5 1112,857.75 5 799,532.32 $ 328,692.90 Page 5 Weighted Average 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 2 - 3 years 25% Town of Los Gatos Summary Investment Information January 31, 2017 0.91% Weighted Average Maturity (days) 366 This Month Last Month One year ago $73,735,874 $70,272,720 $70,618,927 0.91% 0.74% 0.52% 0.63% 1.21% 1.91% 2.45% 0.88% 0.72% 0.50% 0.61 % 1.19% 1.93% 2.45% Portfolio Maturity Profile 0.75% 0.27% 0.02% 0.08% 0.59% 1.26% 1.92% 1 - 2 years 30% Compliance: The Town's investments are in compliance with the Town's investment policy dated November I, 2016 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 January 31, 2017 Fund Balances - Beginning of Month/Period Receipts Disbursements Fund Balances - End of Month/Period Portfolio Allocation: BNY MM US Govt Agencies & Corp. Bonds Local Agency Investment Fund Subtotal - Investments Reconciled Demand Deposit Balances Total Treasurer's Fund Local Agency Investment Fund 7.96% Month YTD $70,272,720.45 $74,913,936.39 6,530,063.86 24,824,703.38 (3,066,910.70) (26,002,766.16) $73,735,873.61 $73,735,873.61 $301,470.16 48,304,393.42 4,205,831.01 52,811,694.59 20,924,179.02 $73,735,873.61 Portfolio Investment Allocation BNY MM 0.57% US Govt Agencies & Corp. Bonds 91.47% 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 January 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 COP 2010 Library Reserve Fund Total Restricted Funds: DEC 16 DEC 16 DEC 16 Previous Deposits Ending Balance Realized Gain/Adi. Interest Withdrawals Balance $ 686,256.66 4.88 78.19 1,278,134.11 244,007.62 174,130.56 0.00 $ 5.85 $ 0.00 0.00 296.94 - $ 686,262.51 0.00 244,012.50 0.00 174,208.75 0.00 1,278,431.05 $1,964,239.87 $418,138.18 $302.79 $0.00 $2,382,914.81 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. October includes gain on sale of zmoney market fund of $255.50 and reconciling adjustment for Sep 16 interest. 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 January 31, 2017 Interest by Month July 2016 August 2016 September 2016 October 2016 November 2016 December 2016 January 2017 February 2017 March 2017 April 2017 May 2017 June 2017 $40,143.04 41,290.98 39,945.53 40,937.76 41,154.71 42,859.62 43,069.29 $289,400.93 Page 4 Town of Los Gatos Investment Schedule January 31, 2017 Orginal Issue Maturity Yield to Interest Interest Interest Days Deposit Par Original (0iscount) Market Purchased Date or Maturity Received Earned Earned to Institution 5etsrnj Date Value Cost Premium Value Interest Call Date or Call to Date Prior Yrs. Current FY M3180) PFIZER Corporate Note 03/11/15 750,000.00 753,037.50 3,037.50 750.148.88 5/15/2017 0.91% $ 13,727.08 $ 8,855.98 $ 4,033.97 104 Freddie Mac Coupon Note 08/01/16 1,000,000.00 1,005,560.00 5,560.00 995,547.00 4/15/2019 0.92% $ 1,562.50 $ $ 4,609.53 804 Toyota Motor Credit Coupon Note 07/10/15 500,000.00 502,200.00 2,200.00 500,100.00 10/5/2017 1.05% $ 7,725.69 $ 5,138.43 $ 3,103.27 247 Toyota Motor Credit Corporate Note 07/25/16 950,000.00 954,246.50 4,246.50 941,111.80 5/20/2019 1.24% $ 4,248.61 S $ 6,139.19 839 FNMA Callable Note 04/04/13 4,000.000.00 4,004,800.00 4,800.00 4,001,080.00 3/14/2017 0.72% $ 103,333.33 $ 93,289.54 $ 16,954.57 42 Treasury Note 05/27/14 2,000,000.00 2,015.156.25 15,156.25 2,001,682.00 3/31/2017 0.73% $ 46,885.25 $ 30,758.49 $ 8,604.54 59 Treasury Note 06/23/14 500,000.00 499,804.69 (195.31) 500,454.00 4/30/2017 0.89% $ 10,295.52 $ 8,984.22 5 2,617.35 89 Berk Math Coupon Note 01/11/13 500,000.00 509,280.00 9,280.00 500,844.50 5/15/2017 L61% $ 30,755.56 $ 20,335.65 $ 3,453.53 104 FNMA Callable Note 10/19/12 1,50(3,000.00 1,504,050.00 4,050.00 1,502,518.50 9/20/2017 0.94% 5 58,791.67 $ 52,436.88 5 8,351.06 232 US Bancorp Corporate Note 8/8/2016 1,000,000.00 1,019,550.00 19,550.00 1,006,042.00 10/15/2018 1.08% S 5,254.17 $ $ 5,090.96 622 Microsoft Corporate Note 8/8/2016 1,000,000.00 999,470,00 (530.00) 985,178.00 8/8/2019 1.12% $ - $ - $ 5,389.30 919 FNMA Callable Note 11/30/12 1,000,000.00 1,003,200.00 3,200.00 1,001,679.00 9/20/2017 0.9396 $ 38,055.56 $ 33,450.66 $ 5A98.39 232 FNMA Callable Note 12/04/12 1,000,000.00 1,002,750.00 2,750.00 1,001,679.00 9/20/2017 0.94% $ 37,916.67 $ 33,651.06 $ 5,552.55 232 FFCB Coupon Note 10/18/12 2,000,000.00 1,996,960.00 (3,040.00) 2,001,100.00 9/21/2017 0.86% $ 65,155.00 $ 63,725.70 $ 10,141.40 233 FHLB Coupon Note 12/12/12 2,000,000.00 1,998,720.00 (1,280.00) 1,998,640.00 12/8/2017 0.76% $ 58,583.33 $ 54,170.75 $ 8,986.66 311 FNMA Callable Note 04/17/13 1,000,003.00 1,004,400.00 4,400.00 999,510.00 3/5/2018 1.03% $ 38,062.50 $ 33,174.38 $ 6,096.15 398 AAPL Corporate Note 05/16/13 1,000,000.00 991,680.01 (8,319.99) 996,632.00 5/3/2018 1.17% 5 34,638.89 $ 36,496.41 $ 6,877.06 457 FHLB Coupon Note 06/09/15 1,000,000.00 997,710.00 (2,290.00) 999,330.00 8/27/2018 1.22% $ 13,991.66 $ 12,947.39 $ 7,192.99 573 Treasury Note 06/09/15 1,000,000.00 1,000,468.75 468.75 1,000,544.00 6/30/2017 0.73% $ 11,685.08 $ 7,710.82 $ 4,283.79 150 Treasury Note 06/09/15 1,000,000.00 1,004,140.63 4,140.63 1,001,719.00 9/15/2017 0.82% $ 12,663.04 $ 8,669.78 $ 4,816.54 227 Treasury Note 06/11/15 1,000,000.00 990,468.75 (9,531.25) 997,578.00 4/15/2018 1.09% $ 10,081.97 $ 11,442.75 $ 6,390.11 439 FHLB Coupon Note 06/11/15 2,000,000.00 1,991,820.00 (8,180.00) 1,996,680.00 5/25/2018 1.19% $ 31,033.33 5 25,069.41 5 13,999.80 479 Treasury Note 07/31/15 1,000,000.00 1,010,625.00 10,625.00 1,005,078.00 6/30/2018 1.00% $ 19,466.71 $ 9,277.73 5 5,954.36 515 FFCB Coupon Note 07/30/15 2,500,000.00 2,509,525.00 9,525.00 2,506,692.50 12/18/2017 0.96% $ 38,906.25 $ 22,220.23 $ 14,218.30 321 FHLB Coupon Note 8/20/2015 1,250,0E0.00 1,247,075.00 (2,925.00) 1,247,275.00 7/25/2018 1.13% $ 19,104.17 $ 12,1.98.15 5 8,318.90 540 FHLB Coupon Note 8/25/2015 1,000,000.00 999,500.00 (500.00) 997,820.00 7/25/2018 1.07% $ 15,137.50 $ 9,063.35 5 6,285.87 540 FFCB Coupon Note 8/27/2015 1,000,000.00 1,002,060.00 2,060.00 1,000,520.00 4/24/2017 0.63% 5 11,187.50 5 5,281.77 $ 3,686.95 83 Walmart Corporate Note 9/25/2015 1,000,000,00 998,960.00 (1,040.00) 998,456.00 4/11/2018 1.17% $ 11,750.00 5 8,911.65 $ 6,867.40 435 Disney Corporate Note 9/25/2015 995,000.00 995,298.50 298.50 99,1,138.33 12/1/2017 1.09% $ 12,951.58 5 8,261.82 $ 6,366.63 304 FFCB Coupon Note 10/27/2015 1,000,000.00 1,048,230.00 08,230.00 1,020,220.00 6/1/2018 0.86% 5 30,097.22 $ 6,043.33 5 5,260.39 486 FHLB Coupon Note 10/27/2015 1,000,000.00 1,005,030.00 5,030.00 999,396.00 9/14/2018 0.95% 5 9,906.25 $ 6,433.14 $ 5,599.69 591 FFCB Coupon Note 10/29/2015 1,500,000.00 1,494,840.00 (5,160.00) 1,490,850.00 10/9/2018 0.99% 5 12,3953.83 $ 9,984.84 $ 8,762.21 616 Chevron Corporate Note 12/15/2015 1,250,000.00 1,252,262.50 2,262.50 1,251,772.50 11/9/2017 1.2596 5 15,493.33 5 8,468.86 5 9,195.98 282 Treasury Note 1/26/2016 1.500,000.00 1,494,902.34 (5,097.66) 1,497,304.50 2/28/2018 0.91% $ 6,675,82 $ 5,349:10 $ 8,061.26 393 Wells Fargo Corporate Note 2/2/2016 1,000,000.00 1,001,680.00 1,630.00 1,001,451.00 1/22/2018 1.5696 $ 16,362.50 5 6,387.95 5 9,217.51 356 FHLMC Coupon Note 4/29/2016 1,000,000.00 1,008,050.00 8,050.00 1,000,720.00 12/17/2018 1.04% $ 8,550.00 $ 1,774.34 $ 6,152.94 685 FFCB Coupon Note 4/29/2016 1,000,000.00 1,001,870.00 1,870.00 997,490.00 3/21/2019 1.09% $ 4,575.56 $ 1,860.62 $ 6,452.15 779 FFCB Coupon Note 10/28/2016 1,000,000.00 997,507.00 2,493.00 987,540.00 320,83 10/17/2019 1.14% $ (320.83) $ - 5 2,951.36 989 FNMA Coupon Note 11/15/2016 1,500,000.00 1,487,505.00 12,495.00 1,483,683.00 3,041.67 8/28/2019 1.31% $ (3,041.67) $ - $ 4,111.35 939 Subtotal 5 48,304,393.42 $ 139,369.42 $ 48,160,204.51 5 3,362.50 5 863,644.13 $ 662,315.16 $ 265,685.96 BNY MM 301,470.16 301,470.16 IAIF N/A 12/31/14 4,205,831.01 4,205,831.01 16,115.03 $52,811,694.59 552,667,505.68 $ 863,644.13 $ 662,315.16 $ 281,800.98 Bank of the West Matured Assets IBM Corporation Corporate Note 11/13/12 750,000.00 782,505.00 32,505.00 7/22/2016 0.76% 5 53,990.62 $ 21,116.64 5 350.62 Treasury Note 08/16/11 1,000,000.00 1,025,390.63 25,390.63 8/1/2016 0.97% $ 74,347.83 $ 48,194.68 $ 1,273.97 Treasury Note 06/10/14 1,003,030.00 1,000,000.00 0.00 8/4/2016 0.00% $ 13,434.10 $ 12,859.59 $ 574.51 Treasury Note 06/10/14 1,000,000.00 1,004,062.50 4,062.50 8/4/2016 0.42% $ 18,732.73 $ 14,121.82 $ 658.14 FNMA Callable Note 03/28/14 1,000,000.00 1,014,600.00 14,600.00 9/28/2016 0.66% $ 31,250.00 $ 15,089.49 5 1,646.13 FNMA Callable Note 05/14/13 1,500,000.00 1,500,000.00 0.00 11/14/2016 0.5516 $ 28,875.00 5 25,834.93 5 3,096.58 Total Investments"Matured" $6,326,558.13 5 1,084,274.41 5 799,532.32 5 289,400.93 Maturity Profile 0-1 year 1.2 years 2-3 years 3-5 years Market to Cart Position Report Amount 529,062,690.99 $17,302,841.10 56,446,158.50 50.00 $52,811,694.59 Amortized Institution Cost BNY Assets 548,304,393.42 BNY MM 301,470.16 LAIF 4,205,831.01 Totals. 552,811,694.59 Page 5