Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Attachment 1
Town of Los Gatos Portfolio Allocation & Treasurer's Fund Balances March 31, 2018 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 $72,446,082.29 $75,983,998.32 6,308,293.77 33,607,166.46 (3,821,207.17) J34,657,995.89) $74,933,168.89 $74,933,168.89 $189,975.41 $6,502,636.72 $28,478,495.96 $12,985,107.01 6,259,475.09 54,415,690.19 20,517,478.70 $74,933,168.89 Portfolio Investment Allocation Local Agency Investment Fund BNY MM 11.5% 0.35% Corporate Medium Term Bonds 23.9% % of Portfolio Max. %Or $ Allowed Per State Law or Policy 0.35% 11.95% 52.34% 23.86% 11.50% 100.00% 20%ofTown Portfolio No Max. on US Treasuries No Max. on Non -Mortgage Backed 30% of Town Portfolio $65M per State Law US Treasury Notes 11.95% Government Agency Debenture Notes 52.34% 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 Summary Investment Information March 31, 2018 Weighted Average YTM Portfolio Yield: 1.60% Weighted Average Maturity (days) 404 This Month Last Month One year ago Portfolio Balance $74,933,169 $72,446,082 $72,979,656 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.60% 1.52% 1.71% 1.92% 2.27% 2.56% 2.71% 1.56% 1.41% 1.66% 1.85% 2.25% 2.64% 2.86% 0.98% 0.82% 0.75% 0.90% 1.26% 1.92% 2.39% 3-5years 15% 2 - 3 years 25% Portfolio Maturity Profile 1 - 2 years 30% 0-lyear 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 March 31, 2018 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 $72,446,082.29 575,983,998.32 6,308,293.77 33,607,166.46 (3,821,207.17) (34,657,995.89) $74,933,168.89 $74,933,168.89 $189,975.41 $6,502,636.72 $28,478,495.96 $12,985,107.01 6,259,475.09 54,415,690.19 20.517.478.70 $74,933,168.89 % of Portfolio Max. %0r $ Allowed Per State Law or Policy 0.35% 11.95% 52.34% 23.86% 11.50% 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.5% 0.35% Corporate Medium Term Bonds 23.9% 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 US Treasury Notes 11 95% Government Agency Debenture Notes 52.34% page 2 Town of Los Gatos Non -Treasury Restricted Fund Balances March 31, 2018 MAR 18 Previous Deposits Balance Realized Gain/Atli. Non -Treasury Funds: Cert. of Participation 2002 Series A Reserve Fund $ 688,685.61 Cert. Of Participation 2002 Ser A Lease Pymt Fund 51.57 Cert. of Participation 2002 Series A Const. Fund 24.17 1,288,837.56 Total Restricted Funds: $ 1,977,598.91 $0.00 MAR 18 MAR 18 Interest $ 411.29 0.04 1,234.79 $1,646.12 Ending Withdrawals Balance These accounts are not part of the Treasurer's fund balances reported elsewhere in this report, as they are for separate and distinct entities. $ 689,096.90 51.61 24.17 1,290,072.35 $0.00 $1,979,245.03 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 March 31, 2018 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 69,007.27 63,484.43 72,902.24 $560,405.19 Page 4 Town of Los Gatos Investment Schedule March 31, 2018 Maturity Yield to Interest Interest Interest Days Deposit Par Original Market Purchased Date or Maturity Received Earned Earned to Institution Security Date Value Cost Value Interest Call Date or Call to Date Prbr Yrs. CurrentFY Maw Aog_17 Security Freddie Mac Gov. Agency Debentun, 08/01/16 1,000,000.00 1,005,560.00 989,349.00 4/15/2019 0.92% $ 12,812.50 $ 8,387.83 5 6,901.70 380 Toyota Motor Credit Corporate Bond 07/25/16 950,000.00 954,246.50 937,457.15 5/20/2019 3.24% $ 17,548.61 $ 10,985.92 $ 8,853.36 415 FHLB Gov. Agency Debentur, 9/20/2017 1,785,000.00 1,776,432.00 1,746,872.40 6/12/2020 1.56% $ 5,590.53 $ $ 14,562.35 604 U5 Bancorp Corporate Bond 8/8/2016 1,000,000.00 1,019,550.00 9%,900.00 10/15/2018 1.08% $ 24,754.17 $ 9,429.85 $ 7,925.70 198 Microsoft Corporate Bond 8/8/2016 1,000,000.00 999,470.00 983,312.00 8/8/2019 1.12% $ 16,500.00 $ 9,982.45 $ 8,390.16 495 FFCB Gov. Agency Debentur, 9/20/2017 1,600,000.00 1,602,304.00 1,576,304.00 4/6/2020 1.54% $ 1,137.78 $ $ 12,990.12 737 FNMA Gov. Agency Debentur, 9/21/2017 1,300,000.00 1,295,866.00 1,271,257.00 9/14/2020 1.61% $ 9,370.83 $ $, 10,929.17 898 US Treasury US Treasury Note 9/21/2017 1,000,000.00 997,109.38 979,883.00 5/31/2020 1.48% $ 2,629.78 $ $ 7,756.86 792 FNMA Gov. Agency Debentur, 12/13/2017 2,000,000.00 2,017,900.00 1,997,520.00 7,44L67 10/16/2020 2.02% $ 17,441.67) $ $ 12,1344.42 930 FNMA G.Agency Debentun 04/17/13 1,000,000.00 981,984.01 982,016.00 802.08 8/2/2019 2.17% $ I802.08) 5 $ 1,532.83 489 AAPL Corporate Bond 05/16/13 1,000,000.00 991,680.01 999,000.00 5/3/2018 1.17% 5 44,638.89 $ 48,171.42 5 8,764.26 33 FHLB Goa. Agency Debentun 06/09/15 1,000,000.00 997,710.00 996,630.00 8/27/2018 1.22% $ 31,241.66 $ 25,158.75 5 9,166.89 149 American Express Corporate Bond 9/15/2017 1,000,000.00 1,007,980.00 986,003.00 1/2/2020 1.87% $ 10,266.67 $ $ 10,000.24 642 Treasury US Treasury Note 06/11/15 1,000,000.00 990,468.75 999,702.00 4/15/2018 1.09% 5 17,581.97 $ 22,291.07 5 8,143.67 15 FHLB Gov. Agency Debentun, 06/11/15 2,030,000.00 1,991,820.00 1,997,806.00 5/25/2018 1.1904 $ 52,033.33 $ 48,836.51 $ 17,841.60 55 Treasury US Treasury Note 07/31/15 1,000,000.00 1,010,625.00 998,920.00 6/30/2018 1.00% $ 33,216.71 $ 19,386.29 $ 7,588.35 91 Frnklichtac Gov. Agency Debentun 12/20/2017 1,000,000.00 991,200.00 985,736.00 1/17/2020 1.93% 5 1,125.03 $ - $ 5,323.24 657 FHLB Gov. Agency Debentun, 8/20/2015 1,250,000.00 1,247,075.00 1,246,575.00 7/25/2018 1.13% $ 32,229.17 $ 26,310.93 $ 10,601.76 116 FHLB Gov. Agency Debentun, 8/25/2015 1,000,030.00 999,500.00 997,260.00 7/25/2018 1.07% $ 25,637.50 $ 19,734.71 $ 8,010.83 116 Walmart Corporate Bond 9/25/2015 1,000,000.00 998,960.00 999,725.00 4/11/2018 1.17% $ 23,000.00 $ 20,570.26 5 8,751.94 11 Disney Corporate Bond 12/1/2017 1,000,000.00 998,190.00 985,891.00 3/4/2020 2.03% $ 5,034.50 $ - $ 6,674.55 704 FFCB Gov. Agency Debentun 10/27/2015 1,000,000.00 1,048,230.00 1,002,260.00 6/1/2018 0.86% 5 57,597.22 $ 14,973.77 $ 6,703.94 62 FHLB Gov. Agency Debentun 10/27/2015 1,000,000.00 1,005,030.00 996,065.00 9/14/2018 0.95% $ 26,781.25 $ 15,939.59 $ 7,136.35 167 FFCB Gov. Agency 0ebentun, 10/29/2015 1,500,000.00 1,494,840.00 1,492,485.00 10/9/2018 0.99% $ 25,520.83 $ 24,860.21 $ 11,166.72 192 Chevron Corporate Bond 11/9/2017 1.350,000.00 1,366,834.50 1,342,872.00 5/24/2020 1.94% $ 4,095.56 $ - $ 10,167.99 785 FHLMC Gov. Agency Debentur, 4/29/2016 1,000,000.00 1,008,050.00 995,160.00 12/17/2018 1.04% $ 22,050.00 $ 12,220.02 $ 7,841.42 261 FFCB Gov. Agency 0ebentur, 4/29/2016 1,000,000.00 1,001,870.00 991,540.00 3/21/2019 1.09% $ 21,975.56 $ 12,814.27 5 8,222.74 355 FFCB Gov. Agency Debentun 10/28/2016 1,000,003.00 997,507.00 981,570.00 10/17/2019 1.14% $ 10,179.17 $ 7,611.40 5 8,512.34 565 FNMA Gov. Agency 0ebentur, 11/15/2016 1,500,000.00 1,487,505.00 1,475,112.00 - 8/28/2019 1.31% $ 19,291.66 $ 12,120.46 5 14,629.99 515 FHLMC Gov. Agency Debentur, 3/14/2017 2,000,000.00 1,970,180.00 1,965,650.00 7/19/2019 1.52% 5 14,826.39 $ 8,936.03 5 22,671.04 475 FNMA Gov. Agency Debentur, 12/20/2017 1,550,000.00 1,545,642.95 1,537,148.95 11/26/2019 1.90% $ )1,808.33) 5 - 5 8,129.14 605 Freddie Mac Gov. Agency Oehentur, 9/29/2017 1,000,000.00 998,900.00 983,SSO.OD 6/29/2018 1.67% $ 4,062.50 $ - $ 8,884.62 90 1P Morgan Chase Corporate Bond 3/28/2017 1,400,000.00 1,393,196.00 1,380,772.40 8/23/2019 1.86% 5 22,779.17 $ 6,677.49 $ 19,464.17 510 US Treasury US Treasury Note 3/31/2017 1,000,000.00 1,004,218.75 993,789.00 - 3/31/2019 1.29% 5 15,000.00 $ 3,213.83 $ 9,676.80 365 FNMA Gov. Agency Debentun 4/25/2017 1,000,000.00 1,013,390.00 994,480.00 2/7/2020 1.50% $ 15,666.67 $ 2,748.32 $ 11,409.71 678 PNC Bank Corporate Bond 4/4/2017 1,000,000.03 1,003,120.00 993,684.00 2/2/2019 1.29% $ 17,875.00 5 4,242.21 $ 13,360.51 308 Treasury US Treasury Note 5/2/2017 500,000.00 503,339.84 496,582.00 6/30/2019 1.31% $ 5,386.74 $ 1,063.61 $ 4,939.47 456 I'sp.im Corporate Bond 5/15/2017 1;250,000.00 1,249,600.00 1,229,200.110 3/30/2020 1.3106 $ 10,598.96 $ 2,931.91 $ 17,463.97 730 Piker Corporate Bond 6/30/2017 1,000,000.00 1,OD2,280.00 986,719.00 12/15/2019 1.60% $ 7,791.67 $ - $ 12,065.96 624 Treasury US Treasury Note 6/30/2017 1,000,000.00 1,002,148.44 988,320.00 10/31/2019 1.41% $ 5,013.59 $ $ 10,570.15 579 Treasury US Treasury Note 6/30/2017 1,000,000.00 994,726.56 981,641.00 1/31/2020 1.46% 5 7,320.44 5 - $ 10,912.58 671 Toyota Motor Credit Corporate Bond 10/6/2017 500,000.00 503,545.00 494,036.50 3/12/2020 1.85% $ 4,658.33 $ - $ 4,480.95 712 Berkshire Hathaway Corporate Bond 1/22/2018 1,100,000.00 1,086,305.00 1,080,070.20 6,236.39 8/15/2019 2.11% $ 913.61 5 - $ 4,297.90 502 Freddie Mac Gov. Agency Debentur, 3/1/2018 1,500,000.00 1,482,225.00 1,483,125.00 3,489.58 6/24/2019 2.11% $ 13,489.58) $ 5 2,652.03 450 Subtotal 5 51,038,314.69 5 50,520,340.60 $ 17,969.72 $ 672,192.26 $ 399,599.11 $ 428,114.50 8NY MM 189,975.41 189,975.41 0.00% LAIF N/A 12/31/14 6,259,475.09 6,259,475.09 1.35% 59,081.52 557,487,765.19 $56,969,791.10 $ 672,192.26 $ 399,599.11 $ 487,196.02 Bank of the West Matured Assets Treasury US Treasury Note 06/09/15 1,000,000.00 1,004,140.63 9/15/2017 0.82% $ 22,663.04 $ 16,846.70 $ 1,724.99 FNMA Gov. Agency Debentur, 10/19/12 1,500,000.00 1,504,050.00 9/20/2017 0.94% $ 73,791.67 $ 66,614.26 $ 3,185.06 FNMA Gov. Agency Debentur, 11/30/12 1,000,000.00 1,003,200.00 9/20/2017 0.93% $ 48,055.56 $ 42,785.13 $ 2,097.06 FNMA Gov. Agency Debentur, 12/04/12 1,000,000.00 1,002,750.00 9/20/2017 0.94% $ 47,916.67 $ 43,077.49 $ 2,117.72 FFCB Gov. Agency Debentun 1D/18/12 2,000,000.00 1,996,960.00 9/21/2017 0.86% $ 81,755.00 $ 80,942.48 5 3,915.05 FHLMC Gov. Agency Debentur, 3/27/2017 1,000,000.00 999,750.00 - 9/27/2017 1.52% $ 17,500.00 $ 4,683.87 $ 4,388.05 Toyota Motor Credit Corporate Bond 07/10/15 500,000.00 502,200.00 10/5/2017 1.05% $ 13,975.69 $ 10,406.77 $ 1,400.08 Chevron Corponate Bond 12/15/2015 1,250,000.00 1,252,262.50 11/9/2017 1.25% $ 32,293.33 $ 24,080.64 $ 5,645.90 Disney Corporate Bond 9/25/2015 995,000.00 995,298.50 12/1/2017 1.09% $ 23,896.58 5 19,070.28 $ 4,560.29 FHLB Gov. Agency Debentur, 12/12/12 2,000,000.00 1,998,720.00 12/8/2017 0.76% $ 73,583.33 5 69,427.17 $ 6,729.54 FFCB Gov. Agency Debentur, 07/30/15 2,500.000.00 2,509,525.00 12/18/2017 0.96% $ 67,031.25 $ 46,358.27 $ 11,308.51 Wells Fargo Corporate Bond 2/2/2016 1,000,000.00 1,001,680.00 1/22/2018 156% $ 32,862.50 5 22,036.28 $ 8,831.66 Treasury US Treasury Note 1/26/2016 1,500,000.00 1,494,902.34 2/28/2018 0.91% $ 23,550.82 $ 19,534.50 5 10,273.42 FNMA Gov. Agency Debentun 04/17/13 1,000,000.00 1,004,400.00 3/5/2018 1.03% $ 54,937.50 $ 43,523.65 $ 7,031.83 Total Investments "Matured" $17,265,438.97 $ 1,286,005.20 $ 908,986.61 5 560,405.19 Maturity Profile 0-1 year 1-2 years 2-3 years 3-5 years Market to Cost Position Report Amount 525,261,098.01 $21,920,621.30 $10,306,045.88 50.00 557,487,765.19 Amortized Institution Cost BNY Assets 551,038,314.69 BNY MM 189,975.41 LAIF 6,259,475.09 Totals: 557,487,765.19 Page 5 Town of Los Gatos Summary Investment Information February 28, 2018 Weighted Average YTM Portfolio Yield: 1.56% Weighted Average Maturity (days) 411 This Month Last Month One year ago Portfolio Balance $72,446,082 $72,035,804 $72,979,311 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.56% 1.41% 1.66% 1.85% 2.25% 2.64% 2.86% 2 - 3 years 25% 3 - 5 years 15% 1.55% 1.35% 1.46% 1.65% 2.14% 2.52% 2.71% 0.91% 0.72% 0.61% 0.74% 1.26% 1.93% 2.39% Portfolio Maturity Profile 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 February 28, 2018 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 572,035,803.81 $75,983,998.32 2,988,984.25 27,298,872.69 (2,578,705.77) J30,836,788.72) $72,446,082.29 $72,446,082.29 $1,584,140.55 $6,502,636.72 $28,500,911.95 $12,985,107.01 6,259,475.09 55,832,271.32 16,613,810.97 $72,446,082.29 % of Portfolio Max. % 0r $ Allowed Per State Law or Policy 2.84% 11.65% 51.05% 23.26% 11.21% 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.2% 2.84% Corporate Medium Term Bonds 23.3% 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 US Treasury Notes 11.65% Government Agency Debenture Notes 51.05% ( Town of Los Gatos Non -Treasury Restricted Fund Balances February 28, 2018 FEB 18 FEB 18 FEB 18 Previous Deposits Ending Balance Realized Gain/Adi. Interest Withdrawals Balance Non -Treasury Funds: Cert. of Participation 2002 Series A Reserve Fund $ 688,250.11 $ 435.50 Cert. Of Participation 2002 Ser A Lease Pymt Fund 224,762.50 51.57 Cert. of Participation 2002 Series A Const. Fund 166,755.01 24.16 1,287,582.42 1,255.14 Total Restricted Funds: 224,762.50 166,755.00 $ 688,685.61 Note'. 51.57 Note s 24.17 Note 1 1,288,837.56 Note2 $ 2,367,350.04 $0.00 $1,766.37 $391,517.50 $1,977,598.91 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, 2018 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 69,007.27 63,484.43 $487,502.95 Page 4 Town of Los Gatos Investment Schedule February 28,2018 Maturity Yield to Interest Interest Interest Days Deposit Par Original Market Purchased Date or Maturity Received Earned famed to Institution Security Date Value Cost Value Interest Call Date or Call to Date Prior Yrs. Current FY Maturt Au4 17 Security Freddie Mac Gov. Agency Debentun 08/01/16 1,000,000.00 1,005,560.00 988,685.00 4/15/2019 0.92% $ 12,812.50 $ 9,387,83 $ 6,120.85 411 Toyota Motor Credit Corporate Bond 07/25/16 950,000,00 954,246.50 937,986.30 5/20/2019 1.24% 5 17,548.61 $ 10,985.92 $ 7,851.70 446 FHLB Gov. Agency Debentur, 9/20/2017 1,785,000.00 1,776,432.00 1,741,124.70 6/12/2020 1.56% 5 5,590.53 $ - S 12,211.14 835 US Bancorp Corporate Bond 8/8/2016 1,000,000.00 1,019,550.00 997,906.00 10/15/2018 1.08% $ 24,754.17 $ 9,429.85 $ 7,029.00 229 Microsoft Corporate Bond 8/8/2016 1,000,000.00 999,470.00 982,314.00 8/8/2019 1.12% $ 16,500.00 $ 9,982.45 $ 7,440.90 526 FFCB Gov. Agency Debentur, 9/20/2017 1,600,000.00 1,602,304.00 1,575.472.00 4/6/2020 1.54% $ 1,137.78 $ • 5 10,892.76 768 FNMA Gov. Agency Debentur, 9/21/2017 1,300,000.00 1,295,866.00 1,270,230.00 379.17 9/14/2020 1.61% $ (379.17) $ - $ 9,155.33 929 US Treasury U5 Treasury Note 9/21/2017 1,000,000.00 997,109.38 978,984.00 5/31/2020 1.48% $ 2,629.78 $ - 5 6,497.89 823 FNMA Gov. Agency Debentur, 12/13/2017 2,000,000.00 2,017,900.00 1,996,300.00 7,441.67 10/16/2020 2.02% $ 17,441.67) $ - 5 8,587.23 961 FNMA Gov. Agency 0eben10r, 04/17/13 1,000,000.00 1,004,400.00 999,980.00 3/5/2018 1,03% $ 49,312.50 $ 43,523.65 $ 6,890.06 5 AAPL Corporate Bond 05/16/13 1,000,000.00 991,680.01 998,220.00 5/3/2018 1.17% 5 44,638.89 5 48,171.42 S 7,772.68 64 FHLB Gov. Agency Debentur, 06/09/15 1,000,000.00 997,710.00 996,850.00 8/27/2018 1.22% 5 31,241.66 $ 25,158.75 $ 8,129.76 180 American Express Corporate Bond 09/15/17 1,000,000.00 1,007,980.00 987,899.00 1/2/2020 1.87% 5 (733.33) 5 - $ 8,426.60 673 Treasury 135 Treasury Note 06/11/15 1,010,000.00 990,068.75 999,082.00 4/15/2018 1.09% 5 17,58197 $ 22,291.07 $ 7,222,31 46 FHLB Gov. Agency Debentur. 06/11/15 2,000,000.00 1.991,820.00 1,997,414.00 5/25/2018 1.19% $ 52,033.33 5 48,836.51 $ 15,823.03 86 Treasury 05 Treasury Note 07/31/15 1,000,000.00 1,010,625.00 998,711.00 6/30/2018 1.00% $ 33,216.71 $ 19,386.29 5 6,729.81 122 FraldicMac Gov. Agency Debentun 12/20/2017 1,000,000.00 991,200.00 985,866.00 1/17/2020 193% $ 1,125.00 $ $ 3,689.38 688 FHLB Gov. Agency Debentur, 8/20/2015 1250,000.00 1,247,075.00 1,246,312.50 7/25/2018 1.13% $ 32,229.17 5 26,310.93 $ 9,402,29 147 FHLB Gov. Agency Debentur, 8/25/2015 1,000,000.00 999,500.00 997,050.00 7/25/2018 1.07% 5 25,637.50 $ 19,734.71 $ 7,104.50 147 Walman Corporate Bond 9/25/2015 1,000,000.00 998,960.00 998,992.00 4/11/2018 1.17% 5 23,000.00 5 20,570.26 $ 7,761.76 42 Disney Corporate Bond 12/1/2017 1,000,000.00 998,190.00 988,050.00 3/4/2020 2.03% 5 (4,715.50) $ - $ 4,950.29 735 FFCB Gov. Agency Debentur. 10/27/2015 1,000,000.00 1,048,230.00 1,003,210.00 6/1/2018 0.86% $ 57,597.22 $ 14,973.77 5 5,945.47 93 FHLB Gov. Agency Debentun 10/27/2015 1,000,000.00 1,005,030.00 995,433.00 9/14/2018 0.95% $ 21,156.25 $ 15,939.59 $ 6,328.96 198 FFCB Gov. Agency 0ebentur, 10/29/2015 1,500,000.00 1,494,840.00 1,490,895.00 10/9/2018 0.99% $ 25,520.83 $ 24,860.21 $ 9,903.33 223 Chevron Corporate Bond 11/9/2017 1,350,003.00 1,366,834.50 1,343,391.75 5/24/2020 1.94% $ 4,095.56 $ • $ 7,948.22 816 FHLMC Gov. Agency 0ebentur, 4/29/2016 1,000,000.00 L008,050.00 994,650.00 12/17/2018 1.04% $ 22,050.00 5 12,220.02 $ 6,954.25 292 FFCB Gov. Agency Debentur, 4/29/2016 1,000,000.00 1,001,870.00 990,360.00 3/21/2019 1.09% $ 16,175.56 $ 12,814.27 5 7,292.43 386 FFCB Gov. Agency Debentur, 10/28/2016 1000,000.00 997,507.00 980,700.00 10/17/2019 1.14% $ 10,179.17 $ 7,611.40 5 7,549.27 596 FNMA Gov. Agency Debentur, 11/15/16 1,500,000.00 1,497,505.00 1,473,342.00 8/28/2019 1.31% 5 19,291.66 $ 12,120.46 $ 12,974.77 546 FHLMC Gov. Agency Debentur, 3/14/2017 2,000,000.00 1,970.180.00 1,963,904,00 7/19/2019 1.52% $ 14,826.39 $ 8,936.03 $ 20,106.06 506 FNMA Gov. Agency Debentur, 12/20/2017 1,550,000.00 1,545,642.95 1,536,595.60 11/26/2019 1.90% 5 (1,808.33) $ $ 5,634.06 636 Freddie Mac Gov. Agency Debentur, 9/29/2017 1,0110,000.00 998,900.00 983,120.00 6/29/2018 1.67% $ 4,062.50 $ $ 7,379.58 121 JP Morgan Chase Corporate Bond 3/28/2017 1,400,000.00 1,393,196.00 1,379,896.00 8/23/2019 1.8636 5 11,229.17 5 6,677.49 5 17,262.02 541 US Treasury US Treasury Note 3/31/2017 1,000,000.00 1,004,218.75 993,398.00 3/31/2019 1.29% $ 7,500.00 $ 3,213.83 5 8,581.98 396 FNMA Gov. Agency Debentur, 4/25/2017 1,000,000.00 1,013,390.00 992,620.00 2/7/2020 1.50% $ 15,666.67 $ 2,748.32 5 10,118.83 709 INC Bank Corporate Bond 4/4/2017 1,000,000.00 1,003,120.00 994,174.00 2/2/2019 1.29% 5 8,125.00 $ 4,242.21 5 11,848.92 339 Treasury US Treasury Note 5/2/2017 500,000.00 503,339.84 496,465.00 6/30/2019 1.31% $ 5,386.74 $ 1063.61 $ 4,380.63 487 Pgnico Corporate Bond 5/15/2017 1,250,000.00 1,249,600.00 1,230,607.50 3/30/2020 1.31% $ 10,598.96 $ 2.931,91 $ 15,488.12 761 Pliny Corporate Bond 6/30/2017 1,000,000.00 1,002,280.00 986,667.00 12/15/2019 1.60% $ 7,791.67 $ - $ 10,700.84 655 Treasury US Treasury Note 6/30/2017 1,000,000.00 1,002,148.44 988,164.00 10/31/2019 1.41% $ 5,013.59 5 - $ 9,374.26 610 Treasury US Treasury Note 6/30/2017 1,000,000.00 994,726.56 981,055.00 1/31/2020 1.46% $ 7,320.44 5 - $ 9,677.95 702 Toyota Motor Credit Corporate Bond 10/6/2017 500,000.00 503,545.00 495,083.50 716.67 3/12/2020 1.85% 5 1716.67) $ - $ 3,691.69 743 Berkshire Hathaway Corporate Bond 1/22/2018 1,100,000.00 1,086,305.00 1,083,580.30 8/15/2019 2,11% $ 913.61 $ - $ 2,338.56 533 Subtotal $ 49,578,505.68 $ 49,040,780.15 5 8,537.51 $ 649,696.42 $ 443,122.75 $ 371,169.43 BNy MM 1,584,140.55 1,584,140.55 0.00% LAIF N/A 12/31/14 6,259,475.09 6,259,475.09 1.35% 51,318.51 557,422,121.32 $56,880,395.79 $ 649,696.42 5 443,122.75 $ 422,487.94 Bank of the West Matured Assets Treasury US Treasury Note 06/09/15 1,000,000.00 1,004,140.63 9/15/2017 0.82% 5 22,663.04 5 16,846.70 $ 1,724.99 FNMA Gov. Agency Debentun 10/19/12 1,500,000.00 1,504,050.00 9/20/2017 0.94% 5 73,79167 $ 66,614.26 $ 3,185.06 FNMA Gov. Agency Debentur, 11/30/12 1000,000.00 1,003,200.00 9/20/2017 0.93% 5 48,055.56 5 42,785.13 $ 2,097.06 FNMA Gov. Agency Debentur, 12/04/12 1,000,000.00 1,002,750.00 9/20/2017 0.94% 5 47,916.67 $ 43,077.49 $ 2,117.72 FFCB Gov. Agency Debentur, 10/18/12 2,010,030.00 1,996,960.00 9/21/2017 0.86% $ 81,755.00 $ 80,942,48 $ 3,915.05 FHLMC Gov. Agency Debentur, 3/27/2017 1,000,000.00 999,750.00 9/27/2017 1.52% 5 8,750.00 5 4,683.87 $ 4,388.05 Toyota Motor Credit Corporate Bond 07/10/15 500,000.00 502,200.00 10/5/2017 1.05% $ 13,975.69 5 10,406.77 $ 1,400.08 0 Chevron Corporate Bond 12/15/2015 1,250,000.00 1,252,262.50 11/9/2017 1.25% $ 32,293.33 $ 24,080.64 $ 5,645.90 0 Disney Corporate bond 9/25/2015 995,000.00 995,298.50 12/1/2017 1.09% $ 23,896.58 $ 19,070.28 5 4,560.29 0 FHLB Gov. Agency Debentur, 12/12/12 2,000,000.00 1,998,720.00 12/8/2017 0.76% $ 73,583.33 $ 69,427.17 5 6,729.54 0 FFCB Gov. Agency Debentur, 07/30/15 2,500,000.00 2,509,525.00 12/18/2017 096% $ 67,031.25 $ 46,358.27 5 11,308.51 0 Wells Fargo Corporate Bond 2/2/2016 1,000,000.00 1,001,680.00 1/22/2018 1.56% $ 32,862.50 $ 22,036.28 $ 8,831.66 0 Treasury US Treasury Note 1/26/2016 1,500,000.00 1,494,902.34 2/28/2018 0.91% $ 23,550.82 $ 19,534.50 $ 9,111.10 0 Total Investments "Matured" $17,265,438.97 $ 1,199,821.86 5 908,986.61 $ 487,502.95 Maturity Profile 0-1 year 1-2 years 2-3 years 3-5 years Market to Cost Position Report Amount $25,653,574.40 519,960,766.04 511,807,780.88 $0.00 $57,422,121.32 Amortized 1!lptwn Cost BNY Assets 549,578,505.68 BNY MM 1,584,140.55 LAIF 6.259 475.09 Totals: $57,422,121.32 Page 5 Weighted Average YTM Portfolio Yield: 1.55% 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 Town of Los Gatos Summary Investment Information January 31, 2018 This Month Last Month $72,035,804 $67,391,974 2 - 3 years 25% 1.55% 1.35% 1.46% 1.65% 2.14% 2.52% 2.71% 3 - 5 years 15% 1.53% 1.24% 1.38% 1.53% 1.89% 2.21% 2.41% Weighted Average Maturity (days) 436 One year ago $73,735,874 Portfolio Maturity Profile 0.91% 0.74% 0.52% 0.63% 1.21% 1.91% 2.45% 1 - 2 years 30% 0 - 1 year 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 Califomia 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, 2018 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,391,973.57 $75,983,998.32 7,334,287.31 24,309,888.44 (2,690,457.07) (28,258,082.95) $72,035,803.81 $72,035,803.81 $42,542.91 $7,997,539.06 $28,500,911.95 $12,985,107.01 6,259,475.09 55,785,576.02 16,250,227.79 $72,035,803.81 % of Portfolio Max. % Or $ Allowed Per State Law or Policy 0.08% 14.34% 51.09% 23.28% 11.22% 20%ofTown 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.2% 0.08% Corporate Medium Term Bonds 23.3% US Treasury Notes 14.34% Government Agency Debenture Notes S1.09% 76,000,000 74,000,000 Treasurer's Fund Balances 72,000,000 70,000,000 - J 68,000,000 66,000,000 64,000,000 62,000,000 jiii 60,000,000 page 2 Town of Los Gatos Non -Treasury Restricted Fund Balances January 31, 2018 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: JAN 18 JAN 18 JAN 18 Previous Deposits Ending Balance Realized Gain/Adi. Interest Withdrawals Balance $ 687,876.22 $ 373.89 $ 688,250.11 Note t 287.69 224,474.54 0.27 224,762.50 Note 1 72.24 166,682.76 0.01 166,755.01 Note 1 1,286,438.98 1,143.44 1,287,582.42 Note 2 $ 1,974,675.13 $391,157.30 $1,517.61 $0.00 $2,367,350.04 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 January 31, 2018 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 69,007.27 $424,018.52 Page 4 Town of Los Gatos investment Schedule January 31, 2018 Maturity Yield to Interest Interest Interest Days Deposit Par Original Market Purchased Date or Maturity Received Earned Earned to Institution 5ecu' Date Value of Value Interest Call Date or Call to Date Prior Yrs. Current FY Metur5y Aug 17 Seturky Freddie Mac Gov. Agency Debentun 08/01/16 1,000,000.00 1,005,560.00 989,236.00 4/15/2019 0.92% $ 12,812.50 $ 8,387.83 $ 5,415.57 439 Toyota Motor Credit Corporate Bond 07/25/16 950,000.00 954,246.50 939,705.80 5/20/2019 1.24% $ 17,548.61 $ 10,985.92 $ 6,946.98 474 FHLB Gov. Agency Debentur, 9/20/2017 1,785,000.00 1,776,432.00 1,745,444.40 6/12/2020 1.56% 5 5,590.53 $ 5 10,067.46 863 US Bancorp Corporate Bond 8/8/2016 1,000,000,00 1,019,550.00 999,320.00 10/15/2018 1.08% $ 24,754.17 $ 9,429.85 5 6,219.07 257 Microsoft Corporate Bond 8/8/2016 1,000,000.00 999,470.00 983,959.00 8/8/2019 1.1296 $ 11,000.00 $ 9,982.45 5 6,563.52 554 FFCB Gov. Agency Debentur, 9/20/2017 1,600,000.00 1,602,304.00 1,578,208.00 4/6/2020 1.54% $ 1,137.78 $ - $ 8,998.3J 796 FNMA Gov. Agency Debentur, 9/21/2017 1,300,000.00 1,295,866.00 1,272,102.00 379.17 9/14/2020 1.6196 $ (379.17) 5 5 7,553.15 957 US Treasury US Treasury Note 9/21/2017 1,000,000.00 997,109.38 980,898.00 5/31/2020 1.48% 5 2,629.78 $ - $ 5,360.76 851 FNMA Gov. Agency 04bentun, 12/13/2017 2,000,000,00 2,017,900.00 2,004,220.00 7,441.67 10/16/2020 2.0296 $ (7,441.67) 5 $ 5,464.60 989 FNMA Gov. Agency Debentur, 04/17/13 1,000,000.00 1,004,400.OD 999,660.00 3/5/2018 1.03% 5 49,312.50 $ 43,523.65 $ 6,096.15 33 AAPL Corporate Bond 05/16/13 1,000,000.00 991,680.01 998,410.00 5/3/2018 1.1796 5 44,638.89 $ 48,171.42 5 6,877.06 92 FHLB Gov. Agency Debentun, 06/09/15 1,000,000.00 997,710.00 996,930.00 8/27/2018 1.2296 $ 25,491.66 $ 25,158.75 5 7,192.99 208 American Express Corporate Bond 9/15/2017 1,000,OOD.00 1,007,980.00 992,541.01/ 733.33 1/2/2020 1.87% $ (733.33) $ - $ 7,1705.25 701 Treasury US Treasury Note 06/11/15 1,000,000.00 990,468.75 998,614.00 4/15/2018 1.0996 $ 17,581.97 $ 21,291.07 $ 6,390.11 74 FHLB Gov. Agency Debentur. 06/11/15 2,000,000.00 1,991,820.00 1,996,820.00 5/25/2018 1.1996 $ 52,033.33 5 46,836.57 $ 13,999.80 114 Treasury 05 Treasury Note 07/31/15 1,000,000.00 1,010,625.00 999,219.00 6/30/2018 1.0076 5 33,216.71 5 19,386.29 $ 5,954.36 150 FroblicMac Gov. Agency Debentun 12/20/2017 1,000000,00 991,200.00 987,416.00 1/17/2020 1.93% $ 1,125.00 $ $ 52,213.63 716 FHLB 504. Agency Debentun 8/20/2015 1,250,000.00 1,247,075.00 1,246,200.00 7/25/2018 1.1396 5 32,229.17 5 26,310.93 5 8,318.90 175 FHLB Gov. Agency Debentur, 8/25/2015 1,000,000.00 999,500.00 996,960.00 7/25/2018 1.0796 $ 25,637.50 $ 19,734.71 $ 6,285.87 175 Walmart Corporate Bond 9/25/2015 1,000,000.00 998,960.00 998,863.00 4/11/2018 1.1796 $ 23,000.00 $ 20,570.26 5 6,867.87 70 Disney Corporate Bond 12/1/2017 1,000,000.00 998,190.00 992,175.00 3/4/2020 2.03% 5 (4,715.50) 5 $ 3,392.9040 763 FFCB Gov. Agency Debentur, 10/27/2015 1,000,000.00 1,048,230.00 1,004,350.00 6/1/2018 0.8696 1 57,597.22 $ 14,973.77 5 5,260.39 121 FHLB Gov. Agency Debentury 10/27/2015 1,000,000.00 1,005,030.00 995,492.00 9/14/2018 0.9596 5 21,156.25 $ 15,939.59 $ 5,599.69 226 FFCB 600. Agency 3ebentur, 10/29/2015 1,500,000,00 1,494,840.00 1,490,820.00 10/9/2018 0.9996 5 25,520.83 1 24,860.21 $ 8,762.21 251 Chevron Corporate Bond 11/9/2017 1,350,000.00 1,366,834.50 1,350,379.35 5/24/2020 1.9496 $ 4,095.56 5 - $ 5,943.26 844 Treasury U5 Treasury Note 1/26/2016 1,500,000.00 1,494,902.34 1,499,295.00 2/28/2018 0.9196 5 17,925.82 $ 19,534.50 $ 8,061.26 28 FHLMC Gov. Agency Debentur. 4/29/2016 1,000,000.00 1,008,050.00 995,150.00 12/17/2018 1.0496 $ 22,050.00 5 12,220.02 5 6,152.94 320 FFCB Gov. Agency Debentur. 4/29/2016 1,000,000.00 1,001,870.00 990,650.00 3/21/2019 1.0996 5 16,175.56 5 12,814.27 $ 6,452.15 414 FFCB Gov. Agency Debentur, 10/28/2016 I,000,000.00 997,507.OD 981,030.00 10/17/2019 1.14% 5 10,179.17 $ 7,611.40 $ 6,679.39 624 FNMA Gov. Agency Debentur, 11/15/2016 1,500,000.00 1,487,505.00 1,474,678.50 8/28/2019 1.31% 5 11,791.66 $ 12,120.46 5 11,479.74 574 FHLMC Gov. Agency Debentur, 3/14/2017 2,000,000.00 1,970,180.00 1,965,326.00 7/19/2019 1.52% 5 14,826.39 $ 8,936,03 $ 17,789.32 534 FNMA Gov. Agency Debentur, 12/20/2017 1,550,000.00 1,545,642.95 1,538,849.30 11/26/2019 1.9096 5 I1,808.33) $ $ 3,380.43 664 Freddie Mac G. Agency Debentur, 9/29/2017 1,000,000.00 998,900.00 986,530.00 6/29/2018 167% $ 4,062.50 $ - $ 6,020.18 149 1P Morgan Chase Corporate Bond 3/28/2017 1,400,000.00 1,393,196.00 1,382,768.80 8/23/2019 1.86% $ 11,229.17 $ 6,677.49 5 15,272.98 569 US Treasury US Treasury Note 3/31/2017 1,000,000.00 1,004,218.75 994,336.00 3/31/2019 1.2996 5 7,500.00 5 3,233.83 $ 7,593.11 424 FNMA Gov. Agency Debentur, 4/25/2017 1,000,000.00 1,013,390.00 996,420.00 2/7/2020 LSO% $ 5,666.67 5 2,748.32 $ 8,952.87 737 PNC Bank Corporate Bond 4/4/2017 1,000,000.00 1,003,120.00 996,143.00 2/2/2019 1.2996 5 8,125.00 $ 4,242.21 $ 10,483.61 367 Treasury US Treasury Note 5/2/2017 500,000.00 503,339.84 497,031.50 6/30/2019 1.31% $ 5,386.74 5 1,063.61 $ 3,875.86 515 Ptpsico Corporate Bond 5/15/2017 1,250,000.00 1,249,600,00 1,235,733.75 3/30/2020 1.31% $ 10,598.96 $ 2,931.91 $ 13,703.48 789 Pillar Corporate Bond 6/30/2017 1,000,000.00 1,002,280.00 989,033.00 12/15/2019 1.6076 5 7,791.67 5 - 5 9,467.82 683 Treasury US Treasury Note 6/30/2017 1,000,000.00 1,002,148.44 989,453.00 30/31/2019 1.41% $ 5,013.59 $ $ 8,294.10 638 Treasury US Treasury Note 6/30/2017 1,000,000.00 994,726.56 982,422.00 1/31/2020 1.46% $ 7,320.44 $ $ 8,562.79 730 Toyota Motor Credit Corporate Bond 10/6/2017 500,000.00 503,545.00 497,159.00 716.67 3/12/2020 1.85% $ 1716.67) $ - $ 2,9J8.81 771 Berkshire Hathaway Corporate Bond 1/22/2018 1,100,000.00 1,086,305.00 1,084,556.00 6,236.39 8/15/2019 2.11% $ 16,236.39) 5 • $ 568.84 561 Subtotal $ 51,073,408.02 $ 50,614,307.40 $ 15,507.23 $ 631,722.24 $ 462,657.26 5 324,559.11 BNY MM 42,542.91 42,542.91 0,0096 LAIF N/A 12/31/14 6,259,475.09 6,259,475.09 1.35% 43,555.50 $57,375,426.02 556,916,325.40 $ 631,722.24 $ 462,657.26 $ 368,114.61 Bank of the West Matured Assets Treasury U5 Treasury Note 06/09/15 1,000,000.00 1,004,140.63 FNMA Gov. Agency Debemun 10/19/12 1,500,000.00 1,504,050.00 FNMA Gov. Agency Debentur, 11/30/12 1,000,000.00 1,003,200.00 FNMA Gov. Agency Debentur, 12/04/12 1,000,000.00 1,002,750.00 FFCB Gov. Agency Debentur, 10/18/12 2,000,000.00 1,996,960.00 FHLMC Gov. Agency Debentur, 3/27/2017 1,000000.00 999,750.00 Toyota Motor Credit Corporate Bond 07/10/15 500,000.00 502,200.00 Chevron Corporate Bond 12/15/2015 1,250,000.00 1,252,262.50 Disney - Corporate Bond 9/25/2015 995,000.00 995,298.50 FHL8 Gov. Agency Debentur, 12/12/12 2,000,000.00 1,998,720.00 FFCB Gov. Agency Debentur, 07/30/15 2,500,000.00 2,509,525.00 Wells Fargo Corporate Bond 2/2/2016 1,000,000.00 1,001,680.00 9/15/2017 0.82% 5 22,663.04 $ 16,846.70 $ 1,724.99 9/20/2017 0.94% $ 73,791.67 5 66,614.26 $ 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% $ 81,755.00 $ 80,942.48 $ 3,915.05 9/27/2017 1.52% $ 8,750.00 $ 4,683.87 $ 4,388.05 10/5/2017 L05% $ 13,975.69 $ 10,406.77 $ 1,400.08 0 11J9/2017 1.25% $ 32,293.33 $ 24,080.64 $ 5,645.90 0 12/1/2017 1.09% $ 23,896.58 $ 19,070.28 $ 4,560.29 0 12/8/2017 0.76% $ 73,583.33 $ 69,427.17 $ 6,729.54 0 12/18/2017 0.96% $ 67,031.25 $ 46,358.27 $ 11,308.51 0 1/22/2018 1.56% $ 32,862.50 $ 22,036.28 5 8,831.66 0 Total Investments"Matured" $15,770536.63tl $ 1.158,296.86 $ 908,986.61 5 424,018.52 Maturity Profile Amount 0-1 year $24,603,759.10 1-2 years $18,955,769.48 2-3 years $13,815,897.44 3-5 years 50.00 $57,375,426.02 Market to Cost Position Report Amortized Institution Cos BNY Assets $51,073,408.02 BNY MM 42,542.91 LAIF 6,259,475.09 Totals: 557,375,426.02 Page 5