Loading...
HomeMy WebLinkAbout2017-02-14; City Council; ; Approve: Report on City Investments as of December 31, 2016CA Review a*C4444.CITY COUNCIL 41':O Staff Report %Fool? Meeting Date February 14, 2017 To:Mayor and Council Members/From:Kevin Crawford, City Manage Staff Contact:Craig Lindholm, City Treasurer; Nancy Sullivan, Deputy City Treasurer Nancy.Sullivan@carlsbadca.gov or 760-602-2473 Subject Approve: Report on City Investments as of December 31, 2016 Recommended Action Accept and file report. Executive Summary/Discussion The city's Investment Policy requires the City Treasurer to report to the City Council on a monthly basis the status of the city's pooled investment portfolio.A quarterly report is also required for the investments of bond proceeds held separately.The city's pooled investment portfolio as of the month ended September 30, 2016 is summarized below. Pooled Investment Portfolio (Cash and Securities) Current Month Prior Month Par Value 688,127,730 671,722,249 Cost of Investments 692,313,343 675,952,981 Amortized Cost (1)690,360,572 674,099,853 Market Value (2)687,209,766 671,348,924 (1) The cost of investments adjusted for amortized premiums and discounts. (2) The amount at which the investments could be sold.Source of market values is Union Bank of California's custodial report as of 12/31/16. The equity portion of the various funds in the total portfolio is summarized in the graph one the next page.Fund balances are restricted for various purposes.See Exhibit 8 for a more detailed breakdown. The $16 million dollar increase between the November and December 2016 report was due mainly to the receipt of $19 million for property taxes. Report on City Investments December 31, 2016 Meeting Date: February 14, 2017 Page 2 FUND EQUITY IN POOLED INVESTMENTS (Dollar Amounts in Millions) General Special Revenue $110.5 $26 Internal Service $44 Capital Projects Agency/Trust $14.7 $ 316 Enterprise $178.8 Total Treasurer's Investment Portfolio at Amortized Cost December 31, 2016 $690 million Pooled Investment Interest Income Current Prior Current Month Cash Income Fiscal Year-to-Date *4,445,470 3,868,723 576,747 *The cash income received is adjusted for any accrued interest purchased. Pooled Investment Performance/Measurement Average Life Average Yield (Years)To Maturity Modified Du ration October 2016 1.92 1.184%1.864 November 2016 1.95 1.210%1.878 December 2016 1.92 1.207%1.847 All pooled investments have been made in accordance with the city's Investment Policy adopted January 2,1985 and last revised January 12, 2016.All investments were initially made in accordance with the city's Investment Policy.Events subsequent to the purchase might have resulted in some investments not being in compliance with the current policy.These events are typically a change in the city's Investment Policy,a change in the credit rating subsequent to a purchase, or a temporary reduction in total portfolio assets.See Exhibit 9 for details. The pooled investment portfolio has the ability to meet the city's cash flow demands for the next six (6) months. Report on City Investments December 31, 2016 Meeting Date: February 14,2017 Page 3 Investment Portfolio for Bond Proceeds Current Quarter Prior Quarter Par Value 21,078,776 21,075,363 Cost 21,078,776 21,075,363 Fiscal Analysis None Next Steps The Report on City Investments is produced monthly by the City Treasurer. Environmental Evaluation (CEQA) Pursuant to Public Resources Code section 21065, this action does not constitute a "project" within the meaning of CEQA in that it has no potential to cause either a direct physical change in the environment, or a reasonably foreseeable indirect physical change in the environment, and therefore does not require environmental review. Public Notification This report is made available at least 72 hours prior to the posting of the agenda. Exhibits 1.Investment Portfolio Breakdown By Amortized Cost, Market Value,Cash Income, and Average Yield 2.Investment Portfolio Breakdown Of Maturities 3.Yield Comparison Graph 4.Market Yield Curve 5.Cumulative Cash Income Graph 6.Second Quarter Transactions 7.Detailed Investment Report 8.Fund Equity in Pooled Investments 9.Corporate Note and Commercial Paper Ratings 10.Percentage Weightings By Corporate Note Issuer Exhibit for Investments of Bond Proceeds Held Separately: 11.Detailed Investment Report —Quarterly Report Exhibit for Summary of outstanding Housing Loans: 12.Detail Of Outstanding Housing Loans —Quarterly Report CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF DECEMBER 31, 2016 BREAKDOWN BY AMORTIZED COST, MARKET VALUE, CASH INCOME, AND AVERAGE WELD BY CLASS AMORTIZED COST MARKET VALUE AVERAGE YIELD Cash Income Class Current Month Prior Month Current Month Prior Month Year to Date Current Month Prior Month CD 15,037,338 15,037,149 15,123,502 15,249,660 114,500 1.58 1.58 FN 16,906,109 16,883,124 16,860,252 16,847,933 0 1.59 1.59 TR 99,981,750 81,744,462 99,773,700 81,548,085 380,308 1.25 1.21 FA 287,348,966 298,878,161 285,372,446 297,165,557 1,922,789 1.23 1.20 CN 162,445,679 162,521,708 161,439,137 161,502,440 1,697,273 1.50 1.50 LAI F 90,427,000 95,703,000 90,427,000 95,703,000 330,360 0.68 0.67 CUSTODY 12,152,953 675 12,152,953 675 32 0.00 0.00 SWEEP 5,519,623 2,108,439 5,519,623 2,108,439 210 0.02 0.02 BANK ACCT 541,155 1,223,135 541,155 1,223,135 0 0.02 0.02 TOTALS 690,360,572 $674,099,853 $687,209,766 $671,348,925 4,445,470 1.21%1.21% CD -Certificate of Deposit FA -Federal Agency Custody -Investment Cash account FN -Federal Discount Notes CN -Corporate Notes SWEEP -General Fund Overnight Cash acccount t7iTR-US Treasury LAW -Local Agency Investment Fund Bank Account -General Fund Cash account X WH WH 1-3 H CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF DECEMBER 31, 2016 BREAKDOWN OF MATURITIES BY CLASSIFICATION AND LENGTH OF TIME CLASS WITHIN 6 MONTHS 7 MONTHS TO 1 YEAR 1 TO 5 YEARS TOTAL % TOTAL CD 247,380 1,489,332 13,293,206 15,029,917 2.2% FN 0 0 16,511,804 16,511,804 2.4% TR 8,993,327 19,093,008 71,971,753 100,058,088 14.5% FA 21,650,485 34,767,885 231,311,301 287,729,671 41.6% CN 35,829,211 3,272,778 125,241,144 164,343,132 23.7% (2) LAIF 90,427,000 0 0 90,427,000 13.1% CUSTODY 12,152,953 0 0 12,152,953 1.8% SWEEP 5,519,623 0 0 5,519,623 0.8% BANK ACCT 541,155 0 0 541,155 0.1% TOTALS $175,361,133 (1)$58,623,002 (1)$458,329,207 $692,313,343 100.0% % TOTALS 25.3%8.5%66.2%100.0% Total within One Year $233,984,135 (1) 33.8% POLICY:(1) Not less than $168,954,000 to mature within one year.(2/3rds of current year operating budget of$253,430.000.00) (2)Policy states that not more than 30%of portfolio is to be invested in corporate notes.txix= i—t enHtH N.) ,,, YIELD COMPARISON PORTFOLIO EX-LAIF VS. LAIF JULY 2010 -DECEMBER 2016 2.70 2.602.50 2.40 2.302/0 -4-EX -LAI I- 2.10 2.00 1.901.801.70 1.60 1.50 1.40 1.30 1.20 1.10 1.00 0.900.800.70 0.600.50 0.400.30 0.20 0.10 041/41 4‘\itt 04‘e pgs 06*4%n3 gp4Q‘VC\OC> 4‘111 ttit #Oc>v-gt #Oc>to ttit v* -\Oc> MARKET YIELD CURVE 6/3 0/1 5, 6/30/1 6, 12/31 /1 6 Market Rates3.5 3 2.5 —sw 2 — -- 1.5 —see ....... A 4.4.sat ee1 ........radeeeeeewagonesome 0.5 e°5-4'6D ......—...... 0 3 Mth 2Yr 5Yr 10 Yr 3 Mth 2Yr 5Yr 10 Yr —N-6/30/2015 .01 .65 1.65 2.35 Li —gal-6/30/2016 .26 .58 1.00 1.47 to" 0-12/31/2016 .50 1.19 1.93 2.44 HI 4. Cumulative Cash Income FY1 6 -1 7 Cumulative Monthly Interest Income Millions $(December 2016)Millions $ 10 -8 9 -7 8 ar--67 6 .r'-55r" 5 Ape 4 4 -3 3 0.95 -220.66 ____0.76 0.83 0.68 0 58 -11e-• 0 ti 1i 0 Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun tri Interest Income -4 --Budget -•-Actual YTD Ls. TRANSACTIONS FOR PERIOD: 10/01116 TO 12/31/16 2nd QUARTER 2016-2017 Trans Investment Call Par Amount Return Investment Date Date Type Security Date Value Coupon %Costt Rate Interest Return BUYS OCTOBER 10/11/16 10/12/16 FA FHLB N/A 1,800,000.00 1.375%1,808,975.18 1.244%87,893.57 1,896,868.75 10/11/16 10/12/16 FA FHLB 1/6/2017 1,800,000.00 1.375%1,797,300.00 1.414%101,287.50 1,898,587.50 10/11/16 10/12/16 FA WA N/A 3,000,000.00 3.875%3,315,660.00 1.370%189,058.75 3,504,718.75 10/11/16 10/12/16 FA FHLB N/A 1,500,000.00 2.250%1,559,427.00 1.370%97,979.25 1,657,406.25 10/11/16 10/14/16 CN COCA COLA N/A 3,600,000.00 1.550%3,581,496.00 1.660%290,839.00 3,872,335.00 10/25/16 10/26/16 FA FFCB N/A 1,600,000.00 0.750%1,598,592.00 0.810%19,141.33 1,617,733.33 10/25/16 10/26/16 TR US TREASURY N/A 2,400,000.00 0.750%2,400,000.00 0.750%27,244.57 2,427,244.57 10/25/16 10/26/16 FA FHLB N/A 2,500,000.00 1.125%2,476,850.00 1.328%155,806.25 2,632,656.25 10/27/16 10/28/16 TR US TREASURY N/A 1,750,000.00 1.375%1,759,570,31 1.235%86,875.85 1,846,446.16 10/27/16 10/28/16 TR US TREASURY N/A 2,500,000.00 1.125%2,477,400.00 1.325%154,053.80 2,631,453.80 10/27/16 10/28/16 FA FNMA N/A 2,500,000.00 1.375%2,491,075.00 1.450%178,794.79 2,669,869.79 NOVEMBER 11/04/16 11/07/16 FN FNMA N/A 2,200,000.00 0.000%2,115,792.80 1.340%84,207.20 2,200,000.00 11/02/16 11/07/16 CN IBM N/A 1,000,000.00 2.900%1,052,600.00 1.792%91,916.67 1,144,516.67 11/16/16 11/17/16 TR US TREASURY N/A 2,000,000.00 2.000%2,030,000.00 1.683%168,121.55 2,198,121.55 11/16/16 11/17/16 FA FNMA 1/28/2017 2,600,000.00 1.000%2,596,100.00 2.079%256,027.78 2,852,127.78 11/17/16 11/18/16 TR US TREASURY N/A 2,000,000.00 2.000%2,028,360.00 1.700%169,651.05 2,198,011.05 11/21/16 11/22/16 TR US TREASURY N/A 2,000,000.00 2.000%2,016,562.50 1.825%182,664.02 2,199,226.52 11/17/16 11/29/16 FA FFCB N/A 3,000,000.00 1.760%3,000,000.00 1.760%264,000.00 3,264,000.00 DECEMBER 12/01/16 12/02/16 TR US TREASURY N/A 2,750,000.00 1.875%2,776,034.25 0.830%20,970.24 2,797,004.49 12/01/16 12/02/16 TR US TREASURY N/A 1,500,000.00 1.625%1,500,000.00 1.625%89,286.68 1,589,286.68 12/01/16 12/02/16 TR US TREASURY N/A 1,200,000.00 1.375%1,186,200.00 1.680%78,341.44 1,264,541.44 12/01/16 12/02/16 TR US TREASURY N/A 1,600,000.00 2.125%1,615,500.00 1.913%148,615.38 1,764,115.38 ..12/15/16 12/16/18 TR US TREASURY N/A 2,000,000.00 2.875%2,045,792,00 1.080%28,294.54 2,074,086.54 12/16/16 12/19/16 FA FAMCA N/A 500,000.00 1.860%505,300.00 1.390%16,167.50 521,467.50 12/16/16 12/19/16 TR US TREASURY N/A 800,000.00 1.250%798,640,00 1.323%25,006.41 823,646.41 12/16/16 12/19/16 TR US TREASURY N/A 1,350,000.00 1.625%1,345,570.31 1.721%81,926.29 1,427,496.60 12/15/16 12/16/16 TR US TREASURY N/A 2,250,000.00 2.000%2,250,000.00 2.000%200,521.98 2,450,521.98 12/15/16 12/16/16 TR US TREASURY N/A 2,650,000.00 1.125%2,547,312,50 2.022%238,058.93 2,785,371.43 12/21/16 12/22/16 TR US TREASURY N/A 2,200,000.00 1.375%2,184,531.25 1.602%111,901.07 2,296,432.32 TOTAL SECOND QUARTER 2016-2017 58,550,000.00 58,860,641.10 1.496%3,644,653.39 62,505,294.49 MATURITIES OCTOBER 10/06/11 FA FFCB N/A 5,000,000.00 1.300%5,000,000.00 1.300%325,000.00 5,325,000.00 11/03/15 TR US TREASURY N/A 3,000,000.00 1.000%3,016,308.00 0.450%13,444.75 3,029,752.75 NOVEMBER NONE DECEMBER 11/27/12 FA FHLB N/A 5,000,000.00 0.550%5,000,000,00 0.550%112,291.67 5,112,291.67 tr1 12/27/12 FA FFCB N/A 3,000,000.00 0.600%3,000,000.00 0.600%90,000.00 3,090,000.00 Z 04/30/13 FA FHLB N/A 4,000,000.00 0.500%4,000,000.00 0.500%73,333.33 4,073,333.33 H edHTOTAL SECOND QUARTER 2016-2017 20,000,000.00 20,016,308.00 0.720%614,069.75 20,630,377.75 H cm _. TRANSACTIONS FOR PERIOD: 10/01/16 TO 12/31/16 2nd QUARTER 2016-2017 Trans Investment Call Par Amount Return Investment Date Date Type Security Date Value Coupon fCosB Rate Interest Return CALLS - OCTOBER 02/25/16 02/26/16 FA FHLB (partial call)10/5/2016 3,520,000.00 1.690%3,520,000.00 1.690%782,374.80 4,302,374.80 08/21/15 08/26/15 CD WESTERN STATE BANK 10/14/2016 249,000.00 1.950%248,377.50 2.000%25,145.00 273,522.50 10/15/15 10/27/15 FA FNMA 10/27/2016 5,000,000.00 1.470%5,000,000.00 1.470%367,500.00 5,367,500.00 04/18/16 04/28/16 FA FHLMC 10/28/2016 1,500,000.00 1.500%1,500,000.00 1.500%95,625.00 1,595,625.00 05/15/15 05/18/15 FA FNMA 10/30/2015 4,416,000.00 1.125%4,418,428.80 1.106%144,127.20 4,562,556.00 05/22/13 05/23/13 FA FHLMC 10/30/2015 3,000,000.00 1.050%3,000,000.00 1.050%155,487.50 3,155,487.50 01/14/14 01/15/14 FA FHLMC 10/30/2015 1,000,000.00 1.100%980,870.00 1.538%69,088.33 1,049,958.33 NOVEMBER 03/07/13 03/12/13 FA FFCB 11/8/2016 5,000,000.00 1.030%4,991,500.00 1.065%266,000.00 5,257,500.00 TOTAL SECOND QUARTER 2016-2017 23,685,000.00 23,659,176.30 1.306%1,905,347.83 25,564,524.13 INVESTMENT REPORT AS OF DECEMBER 31, 2016 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN fEsni 1/3/2013 FA FHLMC .60% BULLET 3,000,000.00 2,998,500.00 0.613%73,500.00 3,072,000.00 1,461 4/25/2014 FA FHLB .875% NON-CALL 3,000,000.00 3,002,460.00 0.846%73,008.75 3,075,468.75 1,050 10/30/2015 FA FHLB .075% NON-CALL 3,500,000.00 3,507,910.00 0.580%27,235.83 3,535,145.83 489 6/26/2015 FA FNMA 1.125%NON-CALL 1,250,000.00 1,260,975.00 0.643%14,845.31 1,275,820.31 671 9/6/2013 FA FHLMC .70% CALL 5/8/15 ONE TIME 5,000,000.00 4,855,000.00 1.515%273,527.78 5,128,527.78 1,340 1/27/2015 FA FHLMC 1.25% NON-CALL 2,000,000.00 2,025,640.00 0.685%31,651.67 2,057,291.67 836 8/16/2012 FA FHLB .875% NON-CALL 4,000,000.00 4,000,000.00 0.875%169,166.67 4,169,166.67 1,765 5/15/2015 FA NA 5.50% NON-CALL 500,000.00 551,225.00 0.742%8,587.50 559,812.50 795 7/25/2016 FA FHLB .625% NON-CALL 2,000,000.00 1,999,700.00 0.640%12,800.00 2,012,500.00 365 5/20/2015 FA FHLMC 1.0% NON-CALL 2,125,000.00 2,138,812.50 0.702%32,701.39 2,171,513.89 800 10/28/2015 FA FHLMC 0.70% QRTLY CALL 3,000,000.00 3,000,000.00 0.700%36,750.00 3,036,750.00 639 11/20/2013 FA FFCB .700% CALL 11/26/13 QRTLY 2,000,000.00 1,975,000.00 1.043%77,072.22 2,052,072.22 1,358 10/9/2015 FA FHLB 0.75% NON-CALL 2,000,000.00 2,004,800.00 0.622%23,491.67 2,028,291.67 689 12/29/2015 FA FHLB .75% NON-CALL 1,000,000.00 995,550.00 1.020%16,929.17 1,012,479.17 608 4/26/2016 FA FHLB .75% NON-CALL 2,700,000.00 2,700,000.00 0.750%27,112.50 2,727,112.50 489 4/26/2016 FA FNMA 1.0% NON-CALL 2,096,000.00 2,102,707.20 0.770%22,636.80 2,125,344.00 512 3/26/2014 FA FHLB 1.05% CALL 9/26/14 ONE TIME STEP 2,000,000.00 2,000,000.00 1.050%73,500.00 2,073,500.00 1,280 1/23/2014 FA FFCB 1.160% NON-CALL 2,000,000.00 1,995,000.00 1.229%92,000.00 2,087,000.00 1,369 2/19/2013 FA FFCB .87% CALL 11/27/13 CONT 2,000,000.00 1,985,000.00 1.030%98,036.67 2,083,036.67 1,742 5/28/2013 FA FHLMC .75% CALL 5/28/15 ONE TIME 5,000,000.00 5,000,000.00 0.750%168,750.00 5,168,750.00 1,645 3/6/2013 FA FNMA 1.0% CALL 3/6/15 ONE TIME 3,050,000.00 3,050,000.00 1.000%144,875.00 3,194,875.00 1,736 12/3/2012 FA FHLB 2.625% NON-CALL 3,000,000.00 3,270,090.00 0.790%124,75315 3,394,843.75 1,831 1/22/2013 FA FHLMC .95% CALL 1/22/15 QRTLY 3,350,000.00 3,341,826.00 1.000%167,299.00 3,509,125.00 1,826 1/25/2013 FA FAMCA .93% NON-CALL 5,000,000.00 5,004,870.00 0.910%227,500.83 5,232,370.83 1,825 2/1/2013 FA FAMCA 1.05% NON-CALL 5,000,000.00 5,000,000.00 1.000%262,354.17 5,262,354.17 1,824 11/3/2015 FA FNMA .875% NON-CALL 2,700,000.00 2,700,891.00 0.860%52,593.37 2,753,484.37 828 5/8/2013 FA FHLB 1.10%CALL 2/20/14 CONT 1,000,000.00 1,000,774.00 1.080%51,842.67 1,052,616.67 1,749 2/20/2015 FA FFCB 1.11% NON-CALL 2,500,000.00 2,500,000.00 1.110%83,250.00 2,583,250.00 1,096 7/21/2016 FA FHLB 1.375% NON-CALL 5,000,000.00 5,048,990.00 0.770%63,301.67 5,112,291.67 596 10/26/2016 FA FFCB 0.75% NON-CALL 1,600,000.00 1,598,592.00 0.810%19,141.33 1,617,733.33 539 8/5/2014 FA FNMA 0.875% NON-CALL 2,500,000.00 2,460,777.84 1.300%122,225.63 2,583,003.47 1,385 5/30/2013 FA FHLB 1.050% CALL 7/4/13 CONT 3,000,000.00 2,964,750.00 1.050%193,100.00 3,157,850.00 1,831 6/21/2016 FA FHLB 1.25% NON-CALL 4,000,000.00 4,034,280.00 0.809%63,914.44 4,098,194.44 717 10/19/2015 FA FFCB 1.03% CALL 1/13/16 CONT 3,000,000.00 3,000,000.00 1.030%84,460.00 3,084,460.00 998 12/29/2015 FA FNMA 1.125% NON-CALL 1,000,000.00 997,610.00 1.220%31,171.25 1,028,781.25 934 XCri 7/27/2016 FA FNMA .875% ONE CALL 7/27/17 3,000,000.00 2,997,750.00 0.913%54,750.00 3,052,500.00 730 1/27/2015 FA FNMA 1.0% NON-CALL 1,100,000.00 1,096,139.00 1.102%42,452.67 1,138,591.67 1,280 H I:d5/5/2014 FA FFCB 1.6% NON-CALL 2,500,000.00 2,515,710.93 1.450%157,622.40 2,673,333.33 1,584 H 10/27/2015 FA FHLB 1.125% NON-CALL 4,000,000.00 4,020,840.00 0.941%108,785.00 4,129,625.00 1,053 I-R 5/2/2014 FA FNMA 1.875% NON-CALL 1,500,000.00 1,524,000.00 1.500%99,125.00 1,623,125.00 1,600 -....I INVESTMENT REPORT AS OF DECEMBER 31, 2016 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN fan" 1/16/2014 FA FHLMC 1.20% CALL 9/24/14 ONE TIME 2,250,000.00 2,196,562.50 1.729%180,037.50 2,376,600.00 1,712 5/23/2016 FA FNMA 1.125% NON-CALL 2,000,000.00 2,006,660.00 0.984%47,465.00 2,054,125.00 879 3/30/2015 FA FHLB 1.30% NON-CALL 1,000,000.00 1,000,000.00 1.300%46,583.33 1,046,583.33 1,310 5/2/2014 FA FNMA 1.625% NON-CALL 2,000,000.00 2,008,347.18 1.530%140,159.76 2,148,506.94 1,670 6/3/2014 FA FNMA 1.625% NON-CALL 2,000,000.00 2,010,791.92 1.500%134,826.14 2,145,618.06 1,638 7/21/2015 FA FNMA 1.50% NON-CALL 1,000,000.00 1,006,875.00 1.290%43,500.00 1,050,375.00 1,228 5/15/2015 FA FNMA 1.25% CALL 6114/15 QRTLY 1,000,000.00 997,500.00 1.322%47,256.94 1,044,756.94 1,309 6/5/2015 FA FHLB 1.75% NON-CALL 2,000,000.00 2,034,100.00 1.254%16,625.00 2,050,725.00 1,288 2/20/2015 FA FNMA 1.1% NON-CALL 1,000,000.00 992,180.00 1.300%49,925.56 1,042,105.56 1,397 10/28/2015 FA FFCB 1.15% CALL 1/28/16 4,650,000.00 4,648,837.50 1.158%174,956.25 4,823,793.75 1,188 11/2/2015 FA FNMA 1.20% CALL 4/29/16 5,000,000.00 4,992,500.00 1.247%202,000.00 5,194,500.00 1,184 2/26/2016 FA FFCB 1.03% NON-CALL 4,000,000.00 4,004,640.00 0.990%117,357.78 4,121,997.78 1,096 12/9/2014 FA FNMA 1.75% NON-CALL 2,500,000.00 2,515,625.00 1.596%168,854.17 2,684,479.17 1,541 12/12/2014 FA FNMA 1.70% NON-CALL 1,852,000.00 1,863,630.56 1.545%120,864.61 1,984,495.17 1,538 10/6/2014 FA FHLB 1.875% NON-CALL 2,000,000.00 2,011,440.00 1.875%154,393.33 2,165,833.33 1,614 1/29/2016 FA FHLB 4.250% NON-CALL 1,500,000.00 1,643,640.00 1.166%20,895.83 1,664,535.83 1,158 12/19/2016 FA FAMCA 1.86% NON-CALL 500,000.00 505,300.00 1.390%16,167.50 521,467.50 842 6/6/2014 FA FHLMC 1.2%CALL 5/7/15 1,000,000.00 976,800.00 1.693%82,233.33 1,059,033.33 1,796 6/5/2015 FA FHLMC 1.75% NON-CALL 1,650,000.00 1,670,229.00 1.432%94,869.96 1,765,098.96 1,455 7/10/2015 FA FHLMC 1.75% NON-CALL 1,000,000.00 1,015,100.00 1.350%52,955.56 1,068,055.56 1,420 7/15/2015 FA FAMCA 1.50% NON-CALL 1,060,000.00 1,060,000.00 1.500%62,230.83 1,122,230.83 1,430 2/26/2016 FA FAMCA 1.50% NON-CALL 3,000,000.00 3,033,300.00 1.156%115,200.00 3,148,500.00 1,204 6/24/2015 FA FFCB 1.52% NON CALL 2,000,000.00 2,002,320.00 1.490%119,280.00 2,121,600.00 1,461 6/26/2015 FA FFCB 1.52%NON-CALL 2,250,000.00 2,251,282.50 1.505%135,327.50 2,386,610.00 1,459 6/28/2016 FA FNMA 1.20% CALL 12/28/16 2,500,000.00 2,500,000.00 1.200%90,000.00 2,590,000.00 1,095 1/23/2015 FA FFCB 2.15% NON-CALL 3,250,000.00 3,354,097.50 1.410%209,175.42 3,563,272.92 1,636 7/26/2016 FA FNMA 1.05% ONE CALL 7/26/18 2,300,000.00 2,300,000.00 1.050%48,300.00 2,348,300.00 1,095 1/21/2015 FA FHLMC 1.25% NON-CALL 2,500,000.00 2,493,975.00 1.305%147,518.06 2,641,493.06 1,653 8/30/2016 FA FNMA 1.0% ONE CALL 8/28/18 2,400,000.00 2,400,000.00 1.000%71,866.67 2,471,866.67 1,093 10/23/2014 FA FHLB 2.00% NON-CALL 1,500,000.00 1,525,968.30 1.630%120,698.37 1,646,666.67 1,786 1/21/2015 FA FHLB 1.375% NON-CALL 2,000,000.00 2,000,440.00 1.370%127,282.22 2,127,722.22 1,696 7/19/2016 FA FHLMC 1.25% NON-CALL 3,000,000.00 3,027,363.00 1.250%92,741.17 3,120,104.17 1,170 10/6/2015 FA FNMA 1.33% NON-CALL 4,183,000.00 4,197,807.82 1.240%210,509.47 4,408,317.29 1,479 5/26/2016 FA FNMA 1.30% QRTLY CALL 4,000,000.00 4,000,000.00 1.300%182,000.00 4,182,000.00 1,279 6/15/2015 FA FHLB 2.375% NON-CALL 3,370,000.00 3,468,026.56 1.700%261,697.54 3,729,724.10 1,642 12/30/2015 FA FFCB 1.72% CALL 12/30/16 2,600,000.00 2,600,000.00 1.720%178,880.00 2,778,880.00 1,461 10/5/2015 FA FHLMC 1.40% NON-CALL 3,500,000.00 3,519,495.00 1.265%189,299.44 3,708,794.44 1,557 4/27/2016 FA FHLMC .75% ONE CALL 1/27/17 STEP 2,000,000.00 1,999,000.00 1.559%117,250.00 2,116,250.00 1,370 5/13/2016 FA FHLMC 1.30% CALL 2/13/17 ONE TIME 2,750,000.00 2,750,000.00 1.300%134,062.50 2,884,062.50 1,371 7/28/2016 FA FNMA 1.20% CALL 7/28/17 ONE TIME 4,850,000.00 4,850,000.00 1.200%203,700.00 5,053,700.00 1,279 2/24/2016 FA FHLMC 1.50% CONT CALL 1,750,000.00 1,750,000.00 1.500%105,000.00 1,855,000.00 1,461 ... INVESTMENT REPORT AS OF DECEMBER 31, 2016 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN 1121yEl 2/24/2016 FA FFCB 1.4% CONT CALL 1,000,000.00 1,000,000.00 1.400%56,000.00 1,056,000.00 1,461 7/13/2016 FA FNMA 1.25% CALL 4/13/17 ONE TIME 5,000,000.00 5,000,000.00 1.250%234,375.00 5,234,375.00 1,370 7/28/2016 FA FNMA 1.25% CALL 4/28/17 ONE TIME 3,750,000.00 3,750,000.00 1.250%175,781.25 3,925,781.25 1,370 5/26/2015 FA FNMA 1.7% CALL 5/26/17 ONE CALL 3,000,000.00 3,000,000.00 1.700%255,000.00 3,255,000.00 1,827 6/12/2015 FA FHLB 1.75% NON-CALL 3,000,000.00 3,000,000.00 1.750%262,500.00 3,262,500.00 1,827 2/23/2016 FA FHLB 1.75% NON-CALL 2,000,000.00 2,039,980.00 1.271%110,617.22 2,150,597.22 1,571 4/15/2016 FA FNMA 1.35% NON-CALL 2,150,000.00 2,159,632.00 1.240%112,192.37 2,271,824.37 1,533 7/13/2016 FA FFCB 1.19% CALL 7/13/17 CONT 4,250,000.00 4,250,000.00 1.190%202,300.00 4,452,300.00 1,461 1/21/2016 FA FHLB 1.83% NON-CALL 2,500,000.00 2,549,375.00 1.378%157,516.67 2,706,891.67 1,651 9/7/2016 FA FFCB 1.32% CALL 8/24/17 CONT 3,000,000.00 2,998,260.00 1.335%158,710.00 3,156,970.00 1,447 4/19/2016 FA FHLMC 1.65% NON-CALL 1,000,000.00 1,017,760.00 1.230%54,152.50 1,071,912.50 1,592 6/8/2016 FA FHLB 2.875% NON-CALL 3,000,000.00 3,206,160.00 1.214%161,121.25 3,367,281.25 1,556 10/12/2016 FA FHLB 1.375% NON-CALL 1,800,000.00 1,808,975.18 1.244%87,893.57 1,896,868.75 1,430 10/12/2016 FA FHLB 1.375% CALL 1/6/17 1,800,000.00 1,797,300.00 1.414%101,287.50 1,898,587.50 1,455 7/22/2016 FA FNMA 1.65% NON-CALL 3,250,000.00 3,316,612.00 1.165%166,507.79 3,483,119.79 1,589 6/14/2016 FA FFCB 1.54% CALL 6/14/17 CONT 2,250,000.00 2,250,000.00 1.540%155,925.00 2,405,925.00 1,644 6/21/2016 FA FFCB 1.55% CALL 9/21/16 CONT 2,000,000.00 2,000,000.00 1.550%139,500.00 2,139,500.00 1,644 4/26/2016 FA FFCB 1.60% CALL 7/19/16 CONT 3,250,000.00 3,247,010.00 1.620%248,978.89 3,495,988.89 1,729 7/19/2016 FA FHLB 1.40% CALL 10/19/16 CONT 3,500,000.00 3,500,000.00 1.400%220,500.00 3,720,500.00 1,645 9/9/2016 FA FAMCA 1.550% NON-CALL 2,000,000.00 2,018,640.00 1.550%117,071.11 2,135,711.11 1,599 10/12/2016 FA TENN VALLEY AUTHORITY 3.875% NON-CALL 3,000,000.00 3,315,660.00 1.370%189,058.75 3,504,718.75 1,587 2/26/2016 FA FHLMC 1.25% QRTLY CALL STEP 1,000,000.00 999,500.00 2.103%106,750.00 1,106,250.00 1,827 2/26/2016 FA FHLB 1.69% CALL 8/26/16 CONT 480,000.00 480,000.00 1.690%74,495.20 554,495.20 1,827 3/10/2016 FA FNMA 1.00% CALL 3/10/17 ONE TIME STEP 2,500,000.00 2,498,750.00 1.724%216,250.00 2,715,000,00 1,826 3/22/2016 FA FHLB 1.25% QRTLY CALL 6/22/16 STEP 2,500,000.00 2,498,750.00 1.870%235,625.00 2,734,375.00 1,826 4/28/2016 FA FHLMC 1.25% QRTLY CALL 10/28/16 STEP 2,500,000.00 2,496,250.00 2.122%269,375.00 2,765,625.00 1,826 5/25/2016 FA FFCB 1.66% CALL 5/25/17 CONT 4,000,000.00 3,997,600.00 1.673%334,400.00 4,332,000.00 1,826 10/12/2016 FA FHLB 2.25% NON-CALL 1,500,000.00 1,559,427.00 1.370%97,979.25 1,657,406.25 1,703 10/26/2016 FA FHLB 1.125% NON-CALL 2,500,000.00 2,476,850.00 1.328%155,806.25 2,632,656.25 1,722 11/17/2016 FA FNMA1.00% CALLI 1/28/17 QRTLY CALL STEP 2,600,000.00 2,596,100.00 2.079%256,027.78 2,852,127.78 1,714 10/28/2016 FA FNMA 1.375%NON-CALL 2,500,000.00 2,491,075.00 1.450%178,794.79 2,669,869.79 1,805 11/29/2016 FA FFCB 1.76% NON-CALL 3,000,000.00 3,000,000.00 1.760%264,000.00 3,264,000.00 1,826 SUB-TOTAL 286,216,000.00 287,729,670.99 1.228%13,898,260.99 301,627,931.98 1,376 1/23/2015 FN FNMA 0% NON-CALL 1,163,000.00 1,086,447.85 1.700%76,552.15 1,163,000.00 1,470 1/21/2015 FN FICO 0% NON-CALL 4,000,000.00 3,772,000.00 1.400%228,000.00 4,000,000.00 1,535 4/1/2015 FN FICO 0% NON-CALL 2,100,000.00 1,958,591.39 1.560%141,408.61 2,100,000.00 1,639 9/23/2015 FN FICO 0% NON-CALL 3,200,000.00 3,003,168.00 1.590%196,832.00 3,200,000.00 1,464 3/3/2015 FN FNMA 0% NON-CALL 2,000,000.00 1,825,044.00 2.000%174,956.00 2,000,000.00 1,681 11/7/2016 FN FNMA 0% NON-CALL 2,200,000.00 2,115,792.80 1.340%84,207.20 2,200,000.00 1,066 INVESTMENT REPORT AS OF DECEMBER 31, 2016 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN pm' 10/23/2015 FN RFCSP 0% NON-CALL 3,000,000.00 2,750,760.00 1.750%249,240.00 3,000,000.00 1,819 SUB-TOTAL 17,663,000.00 16,511,804.04 1.5902%1,151,195.96 17,663,000.00 3,0D5 Federal Investments Total 303,879,000.00 304,241,475.03 15,049,456.95 319,290,931.98 2,191 4/25/2014 TR US TREASURY 1.0%3,000,000.00 3,010,827.00 0.870%77,123.82 3,087,950.82 1,071 9/18/2015 TR US TREASURY 1.875%2,500,000.00 2,551,660.00 0.805%39,772.01 2,591,432.01 713 12/2/2016 TR US TREASURY 1.875%2,750,000.00 2,776,034.25 0.830%20,970.24 2,797,004.49 333 9/19/2014 TR US TREASURY 0.875%3,000,000.00 2,996,484.38 0.920%72,136.54 3,068,620.92 954 7/21/2015 TR US TREASURY .50%2,000,000.00 1,995,000.00 0.642%22,771.74 2,017,771.74 649 9/19/2014 TR US TREASURY 0.625%1,000,000.00 991,015.63 0.963%25,838.88 1,016,854.51 985 11/22/2013 TR US TREASURY .50%2,000,000.00 1,974,619.96 0.850%62,282.21 2,036,902.17 1,347 5/22/2015 TR US TREASURY .50%1,000,000.00 996,900.00 0.643%14,066.85 1,010,966.85 801 7/21/2015 TR US TREASURY .625%2,000,000.00 1,994,352.00 0.760%32,040.66 2,026,392.66 772 1/29/2016 TR US TREASURY 1.00%2,800,000.00 2,809,078.13 0.800%36,460.33 2,845,538.46 595 7/21/2015 TR US TREASURY .625%1,500,000.00 1,494,787.50 0.785%25,781.15 1,520,568.65 802 3/5/2015 TR US TREASURY .75%2,000,000.00 1,989,531.25 0.950%50,289.19 2,039,820.44 971 10/27/2015 TR US TREASURY 75%2,500,000.00 2,506,045.00 0.629%31,658.80 2,537,703.80 735 7/21/2015 TR US TREASURY .75%1,700,000.00 1,691,765.61 0.932%42,582.75 1,734,348.36 984 12/16/2016 TR US TREASURY 2.875%2,000,000.00 2,045,792.00 1.080%28,294.54 2,074,086.54 470 10/26/2016 TR US TREASURY .75%2,400,000.00 2,400,000.00 0.750%27,244.57 2,427,244.57 551 10/7/2014 TR US TREASURY 1.375%1,400,000.00 1,400,251.69 1.370%73,191.24 1,473,442.93 1,393 7/16/2014 TR US TREASURY 1.50%4,000,000.00 4,009,600.00 1.496%237,900.00 4,247,500.00 1,507 7/24/2014 TR US TREASURY 1.50%2,000,000.00 2,006,348.00 1.420%116,749.83 2,123,097.83 1,499 10/7/2014 TR US TREASURY 1.50%1,500,000.00 1,505,664.36 1.400%82,035.92 1,587,700.28 1,424 8/5/2014 TR US TREASURY 1.25%3,000,000.00 2,974,200.00 1.460%184,665.49 3,158,865.49 1,548 12/29/2015 TR US TREASURY 1.25%2,000,000.00 1,998,878.00 1.270%72,069.80 2,070,947.80 1,037 4/15/2016 TR US TREASURY 1.25%1,500,000.00 1,515,292.97 0.850%33,127.36 1,548,420.33 944 10/3/2014 TR US TREASURY 1.50%1,000,000.00 1,000,000.00 1.500%63,627.72 1,063,627.72 1,550 6/5/2015 TR US TREASURY 1.50%2,000,000.00 2,015,296.00 1.285%94,344.88 2,109,640.88 1,336 10/6/2015 TR US TREASURY 1.625%4,000,000.00 4,083,992.00 1.010%142,442.43 4,226,434.43 1,272 12/19/2016 TR US TREASURY 1.25%800,000.00 798,640.00 1.323%25,006.41 823,646.41 862 7/21/2015 TR US TREASURY 1.5%1,500,000.00 1,505,156.25 1.408%81,708.50 1,586,864.75 1,410 8/1/2014 TR US TREASURY 1.625%2,515,000.00 2,500,019.15 1.750%219,213.54 2,719,232.69 1,825 10/6/2014 TR US TREASURY 1.00%1,000,000.00 964,920.00 1.036%84,085.52 1,049,005.52 1,790 12/22/2016 TR US TREASURY 1.375%2,200,000.00 2,184,531.25 1.602%111,901.07 2,296,432.32 1,164 5/24/2016 TR US TREASURY 1.375%2,300,000.00 2,315,093.75 1.204%109,343.75 2,424,437.50 1,437 12/19/2016 TR US TREASURY 1.625%1,350,000.00 1,345,570.31 1.721%81,926.29 1,427,496.60 1,289 12/2/2016 TR US TREASURY 1.625%1,500,000.00 1,500,000.00 1.625%89,286.68 1,589,286.68 1,337 INVESTMENT REPORT AS OF DECEMBER 31, 2016 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN QUA' 9/22/2015 TR US TREASURY 2.125%3,000,000.00 3,085,500.00 2.097%229,396.98 3,314,896.98 1,805 10/28/2016 TR US TREASURY 1.375%1,750,000.00 1,759,570.31 1.235%86,875.85 1,846,446.16 1,464 12/2/2016 TR US TREASURY 1.375%1,200,000.00 1,186,200.00 1.680%78,341.44 1,264,541.44 1,429 1/5/2016 TR US TREASURY 2.375%4,000,000.00 4,127,500.00 1.705%346,195.00 4,473,695.00 1,822 5/5/2016 TR US TREASURY 1.75%2,000,000.00 2,049,174.00 1.205%113,710.62 2,162,884.62 1,701 8/19/2016 TR US TREASURY 1.375%3,000,000.00 3,037,662.00 1.100%156,145.74 3,193,807.74 1,715 12/16/2016 TR US TREASURY 2.000%2,250,000.00 2,250,000.00 2.000%200,521.98 2,450,521.98 1,627 10/28/2016 TR US TREASURY 1.125%2,500,000.00 2,477,400.00 1.325%154,053.80 2,631,453.80 1,706 12/16/2016 TR US TREASURY 1.125%2,650,000.00 2,547,312.50 2.022%238,058.93 2,785,371.43 1,657 12/2/2016 TR US TREASURY 2.125%1,600,000.00 1,615,500.00 1.913%148,615.38 1,764,115.38 1,763 11/17/2016 TR US TREASURY 2.00°A)2,000,000.00 2,030,000.00 1.683%168,121.55 2,198,121.55 1,809 11/18/2016 TR US TREASURY 2.00%2,000,000.00 2,028,360.00 1.700%169,651.15 2,198,011.15 1,808 11/22/2016 TR US TREASURY 2.00%2,000,000.00 2,016,562.50 1.825%182,664.02 2,199,226.52 1,819 SUB-TOTAL 99,665,000.00 100,058,087.75 1.248%4,784,293.15 104,842,380.90 1,266 9/18/2014 CN COLGATE-PALMOLIVE 1.30% MAKE WHOLE CALL 500,000.00 504,585.00 0.009%10,527.50 515,112.50 850 1/31/2012 CN BERSHIRE HATHAWAY 1.90%NON-CALL 5,000,000.00 5,047,739.83 1.700%427,260.17 5,475,000.00 1,827 1/31/2012 CN HSBC BANK USA 2.5% FLOATING RATE 5,000,000.00 5,000,000.00 1.748%425,000.00 5,425,000.00 1,827 3/5/2012 CN BERSHIRE HATHAWAY 1.90%NON-CALL 2,850,000.00 2,914,809.00 1.418%200,676.42 3,115,485.42 1,793 8/6/2012 CN IBM CORP 1.250% NON-CALL 5,000,000.00 5,077,000.00 0.900%204,250.00 5,281,250.00 1,645 2/16/2012 CN WESTPAC BANKING CORP 2.3% NON-CALL 5,000,000.00 5,000,000.00 2.300%574,680.56 5,574,680.56 1,826 2/5/2016 CN PEFCO 1.375% NON-CALL 2,000,000.00 2,012,360.00 0.770%15,903.89 2,028,263.89 376 4/18/2012 CN WAL-MART STORES 5.375% NON-CALL 3,000,000.00 3,568,354.19 1.400%229,833.31 3,798,187.50 1,813 4/9/2015 CN NY LIFE GOLBAL 1.65% NON-CALL 1,675,000.00 1,704,362.75 0.806%28,676.00 1,733,038.75 767 6/5/2012 CN HSBC BANK USA 1.925% FLOATER 5,000,000.00 5,000,000.00 1.037%342,500.00 5,342,500.00 1,826 9/29/2016 CN ROYAL BANK OF CANADA 1.20%NON-CALL 1,275,000.00 1,276,597.58 1.070%13,277.42 1,289,875.00 355 6/12/2014 CN CHEVRON CORP 1.104% NON CALL 2,000,000.00 1,996,180.00 1.160%80,670.67 2,076,850.67 1,272 3/8/2013 CN WAL-MART 5.8% NON CALL 3,000,000.00 3,669,120.00 1.140%189,763.33 3,858,883.33 1,805 5/27/2015 CN WAL-MART 5.8% NON CALL 2,000,000.00 2,249,440.00 1.125%65,693.33 2,315,133.33 995 3/26/2013 CN COCA COLA CA 1.150% MAKE-WHOLE CALL 1,000,000.00 1,000,000.00 1.150%57,627.78 1,057,627.78 1,832 10/29/2015 CN WAL-MART STORES 1.125% MAKE WHOLE 4,000,000.00 4,024,400.00 0.873%85,850.00 4,110,250.00 895 9/18/2014 CN COLGATE-PALMOLIVE .90% MAKE WHOLE CALL 1,000,000.00 980,600.00 1.452%51,975.00 1,032,575.00 1,321 1/27/2015 CN COLGATE-PALMOLIVE .90% MAKE WHOLE CALL 2,000,000.00 1,983,000.00 1.166%75,700.00 2,058,700.00 1,190 2/25/2016 CN COLGATE-PALMOLIVE .90% MAKE WHOLE CALL 2,500,000.00 2,495,450.00 0.984%53,675.00 2,549,125.00 796 5/11/2015 CN APPLE 1.0% MAKE WHOLE CALL 2,000,000.00 1,989,840.00 1.174%69,715.56 2,059,555.56 1,088 5/15/2013 CN BERKSHIRE HATAWAY 1.30% MAKE WHOLE CALL 5,000,000.00 5,019,345.05 1.220%305,654.95 5,325,000.00 1,826 12/24/2015 CN CHEVRON CORP 1.718% MAKE WHOLE CALL 2,250,000.00 2,253,600.00 1.650%93,037.50 2,346,637.50 913 12/31/2015 CN CHEVRON CORP 1.718% MAKE WHOLE CALL 1,000,000.00 996,300.00 1.871%46,315.94 1,042,615.94 906 • INVESTMENT REPORT AS OF DECEMBER 31, 2016 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN fEigni 1/28/2016 CN TOYOTA 1.55% NON-CALL 2,000,000.00 2,014,400.00 1.252%61,808.33 2,076,208.33 897 12/19/2014 CN MASS MUTUAL GLOBAL 2.10% NON-CALL 3,500,000.00 3,555,685.00 1.645%210,344.17 3,766,029.17 1,322 2/19/2015 CN ROYAL BANK OF CANADA 2.00%NON-CALL 2,250,000.00 2,289,442.50 1.500%123,307.50 2,412,750.00 1,320 7/12/2016 CN IBM CORP 7.625% MAKE WHOLE CALL 2,628,000.00 3,005,118.00 1.167%75,418.12 3,080,536.12 825 4/19/2016 CN NY LIFE 1.55% NON-CALL 2,000,000.00 2,014,620.00 1.256%63,999.45 2,078,619.45 927 12/24/2013 CN COCA COLA CA 1.650%MAKE-WHOLE CALL 3,500,000.00 3,491,856.17 1.700%288,391.75 3,780,247.92 1,782 10/28/2015 CN JOHNSON &JOHNSON 1.65% MAKE WHOLE 4,000,000.00 4,070,600.00 1.070%134,183.33 4,204,783.33 1,134 4/9/2015 CN MICROSOFT 1.625% NON-CALL 2,000,000.00 2,037,820.00 1.096%81,075.83 2,118,895.83 1,337 4/6/2015 CN PEFCO 4.375% NON-CALL 2,274,000.00 2,527,892.10 1.450%138,254.46 2,666,146.56 1,439 12/22/2015 CN EXXON MOBIL 1.819% NON-CALL 1,250,000.00 1,259,125.00 1.580%64,329.76 1,323,454.76 1,179 6/30/2015 CN MASS MUTUAL GLOBAL 2.35%NON-CALL 3,250,000.00 3,286,335.00 2.040%251,980.62 3,538,315.62 1,379 10/8/2015 CN APPLE 2.10% MAKE WHOLE CALL 2,500,000.00 2,558,025.00 1.432%129,808.33 2,687,833.33 1,306 5/27/2015 CN IBM CORP 1.8750% NON-CALL 2,150,000.00 2,169,715.50 1.635%140,190.75 2,309,906.25 1,449 7/16/2015 CN TOYOTA 2.125% NON-CALL 2,000,000.00 2,009,760.00 1.998%160,476.11 2,170,236.11 1,463 4/28/2016 CN PEFCO 1.45% NON-CALL 2,600,000.00 2,617,570.80 1.240%106,734.48 2,724,305.28 1,204 11/18/2014 CN CHEVRON CORP 2.193% MAKE-WHOLE CALL 3,000,000.00 3,017,400.00 2.070%311,001.75 3,328,401.75 1,823 12/22/2015 CN CHEVRON CORP 2.193% MAKE-WHOLE CALL 2,800,000.00 2,811,200.00 2.083%228,105.03 3,039,305.03 1,424 4/20/2016 CN JOHNSON & JOHNSON 1.875% MAKE WHOLE CALL 2,250,000.00 2,315,250.00 1.057%87,679.69 2,402,929.69 1,324 4/9/2015 CN NY LIFE GOLBAL 1.95% NON-CALL 2,000,000.00 2,017,520.00 1.760%171,196.67 2,188,716.67 1,769 9/25/2015 CN CVX 1.961% MAKE WHOLE CALL 2,800,000.00 2,790,704.00 2.039%253,026.51 3,043,730.51 1,621 11/4/2015 CN EXXON MOBIL 1.912% MAKE WHOLE CALL 5,000,000.00 5,057,700.00 1.630%357,097.78 5,414,797.78 1,584 5/23/2016 CN PEFCO 2.25% NON-CALL 3,000,000.00 3,099,000.00 1.358%158,250.00 3,257,250.00 1,392 11/3/2015 CN APPLE 2.0% MAKE WHOLE CALL 4,000,000.00 4,028,000.00 1.837%332,666.66 4,360,666.66 1,646 5/24/2016 CN IBM 1.625% MAKE-WHOLE CALL 1,500,000.00 1,503,000.00 1.573%93,890.62 1,596,890.62 1,452 11/3/2015 CN MMM 2.0% MAKE WHOLE CALL 3,500,000.00 3,554,215.00 1.660%279,062.78 3,833,277.78 1,739 9/25/2015 CN JOHNSON & JOHNSON 2.95% MAKE WHOLE 1,000,000.00 1,058,028.49 1.718%87,504.84 1,145,533.33 1,803 9/24/2015 CN AUTOMATIC DATA PROCESSING 2.25% MAKE-WHOL 4,000,000.00 4,029,600.00 2.090%418,150.00 4,447,750.00 1,818 11/10/2015 CN MICROSOFT 2.00% MAKE WHOLE CALL 5,000,000.00 5,018,550.00 1.920%479,505.56 5,498,055.56 1,820 6/10/2016 CN MICROSOFT 2.00% MAKE WHOLE CALL 1,500,000.00 1,539,450.00 1.370%92,466.67 1,631,916.67 1,607 4/28/2016 CN EXXON MOBIL 2.222% MAKE WHOLE CALL 2,000,000.00 2,042,900.00 1.750%172,263.67 2,215,163.67 1,768 7/26/2016 CN EXXON MOBIL 2.222% MAKE WHOLE CALL 1,000,000.00 1,034,050.00 1.440%68,038.55 1,102,088.55 1,679 9/16/2016 CN TOYOTA 1.90% MAKE WHOLE CALL 3,000,000.00 3,031,680.00 1.659%228,303.33 3,259,983.33 1,665 5/26/2016 CN ALPHABET, INC 3.625% MAKE WHOLE CALL 1,000,000.00 1,094,000.00 1.651%86,545.14 1,180,545.14 1,819 9/13/2016 CN MIRCOSOFT 1.55% MAKE WHOLE CALL 6,000,000.00 5,995,740.00 1.565%460,218.33 6,455,958.33 1,790 10/14/2016 CN COCA COLA 1.55% MAKE WHOLE CALL 3,600,000.00 3,581,496.00 1.660%290,839.00 3,872,335.00 1,783 11/7/2016 CN IBM 2.90% MAKE WHOLE CALL 1,000,000.00 1,052,600.00 1.792%91,916.67 1,144,516.67 1,820 SUB-TOTAL 160,902,000.00 164,343,131.96 1.498%10,426,296.57 174,769,428.53 1,421 2/28/2012 CD MERCANTILE BANK OF MICHIGAN 1.15%248,000.00 247,380.00 1.150%14,895.62 262,275.62 1,827 INVESTMENT REPORT AS OF DECEMBER 31, 2016 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN ipayai 12/24/2012 CD DELTA NATL BANK & TRUST .90%249,000.00 248,377.50 0.952%11,624.88 260,002.38 1,792 12/24/2012 CD PACIFIC CONTL BANK .90%249,000.00 248,452.20 0.946%11,556.33 260,008.53 1,793 12/11/2012 CD BANCO POPULAR DE PR HATO 1.1%248,000.00 248,000.00 1.100%13,595.16 261,595.16 1,820 12/11/2014 CD ALLY BANK 1.55%247,000.00 247,000.00 1.550%11,485.50 258,485.50 1,096 12/14/2014 CD FIRST BANK OF PUERTO RICO 1.25%249,000.00 249,000.00 1.250%15,562.50 264,562.50 1,096 12/14/2012 CD BANKERS BANK KANSAS 1.0%249,000.00 248,502.00 1.000%12,948.00 261,450.00 1,826 1/16/2013 CD THE BANK OF HOLLAND 1.00%249,000.00 248,751.00 1.000%12,699.00 261,450.00 1,826 1/16/2013 CD BANK OF NORTHERN MICHIGAN 1.00%249,000.00 248,751.00 1.000%12,699.00 261,450.00 1,826 1/18/2013 CD STEARNS BANK .90%249,000.00 248,253.00 1.000%11,952.00 260,205.00 1,826 3/4/2013 CD GATEWAY BANK OF SW FLORIDA .95%209,000.00 208,373.00 1.070%10,367.28 218,740.28 1,792 1/29/2016 CD CUSTOMERS BANK 1.20%248,000.00 248,000.00 1.200%5,960.27 253,960.27 731 1/30/2013 CD FARMERS & MERCHANTS BANK .90%249,000.00 248,253.00 0.900%11,952.00 260,205.00 1,826 2/10/2016 CD ORIENTAL BANK SAN JAUN PR 1.2% NON-CALL 248,000.00 248,000.00 1.200%5,943.73 253,943.73 730 2/10/2016 CD CADENCE BANK 1.25% NON-CALL 248,000.00 248,000.00 1.250%6,217.22 254,217.22 733 3/28/2013 CD WASHINGTON FEDERAL SAVINGS 1.0% CALL 249,000.00 248,253.00 1.000%13,197.00 261,450.00 1,826 4/5/2013 CD BOSTON PRIVATE BANK & TRUST .95% CALL 248,000.00 247,008.00 1.032%12,765.55 259,773.55 1,825 4/18/2013 CD FIRST STATE BANK NE .95% CALL 249,000.00 248,502.00 0.991%12,325.50 260,827.50 1,826 4/30/2013 CD FOREST COMMERCIAL BANK .90% CALL 249,000.00 248,253.00 0.960%11,952.00 260,205.00 1,826 5/29/2015 CD COMPASS BANK BIRMINGHAM NON-CALL 248,000.00 248,000.00 1.300%9,672.00 257,672.00 1,096 6/4/2015 CD MEDALLION BANK SALT LAKE 1.25 % NON-CALL 249,000.00 249,000.00 1.250%9,337.50 258,337.50 1,096 6/15/2016 CD AMERICA'S CREDIT UNION 1.10%248,000.00 248,000.00 1.100%5,456.00 253,456.00 730 8/25/2016 CD BMO HARRIS BANK 1.10%248,000.00 248,000.00 1.100%5,456.00 253,456.00 729 1/20/2016 CD KEY BANK NATL ASSN OHIO 1.55%247,000.00 247,000.00 1.550%11,528.04 258,528.04 1,098 7/15/2015 CD CAPTIAL ONE 1.95% NON-CALL 249,000.00 249,000.00 1.950%19,422.00 268,422.00 1,461 7/24/2014 CD AMERICAN EXPRESS BANK 2.00%247,000.00 247,000.00 2.000%24,700.00 271,700.00 1,826 8/28/2014 CD ENERBANK USA 2.05%247,000.00 247,000.00 2.050%25,317.50 272,317.50 1,826 8/29/2014 CD SYNCHRONY BANK 2.1%247,000.00 247,000.00 2.100%25,935.00 272,935.00 1,826 8/30/2016 CD WASHINGTON TRUST 1.2%248,000.00 248,000.00 1.200%8,928.00 256,928.00 1,095 9/16/2016 CD ISRAEL DISCOUNT BK OF NY 1.3%248,000.00 248,000.00 1.300%9,689.91 257,689.91 1,095 9/24/2014 CD DISCOVER 2.15%247,000.00 247,000.00 2.150%26,552.50 273,552.50 1,826 9/24/2014 CD GOLDMAN SACHS BANK 2.15%247,000.00 247,000.00 2.150%26,552.50 273,552.50 1,826 10/8/2014 CD CAPITAL ONE ABANK USA 2.10%247,000.00 247,000.00 2.100%25,935.00 272,935.00 1,826 10/10/2014 CD GE CAPITAL BANK 2.0%247,000.00 245,641.50 2.000%26,058.50 271,700.00 1,826 10/29/2014 CD PEOPLES UTD BANK CT 1.9%247,000.00 247,000.00 1.900%23,465.00 270,465.00 1,826 11/3/2014 CD WEBSTER BANK NAT'L ASSOC 1.9%247,000.00 247,000.00 1.900%23,465.00 270,465.00 1,827 12/3/2014 CD CIT BANK SALT LAKE CITY 2.2%247,000.00 247,000.00 2.200%27,170.00 274,170.00 1,826 12/4/2014 CD AMERICAN EXPRESS CENTURION 2.2%247,000.00 247,000.00 2.200%27,170.00 274,170.00 1,826 12/10/2014 CD BMW BANK OF N AMERICA 2.15%247,000.00 247,000.00 2.150%26,552.50 273,552.50 1,826 12/23/2014 CD SALLIE MAE BANK SALT LAKE 2.2%247,000.00 247,000.00 2.200%26,976.46 273,976.46 1,813 1/23/2015 CD PRIVATE BANK &TRUST 1.90%247,000.00 247,000.00 1.900%23,465.00 270,465.00 1,826 INVESTMENT REPORT AS OF DECEMBER 31, 2016 INVESTMENT PAR INVESTED RETURN INVESTMENT TERM DATE TYPE SECURITY VALUE AMOUNT RATE INTEREST RETURN ipayai 7/24/2015 CD EAGLE BANK 1.80%249,000.00 249,000.00 1.800%20,169.00 269,169.00 1,645 1/27/2015 CD NORTHFIELD BANK 1.65%249,000.00 249,000.00 1.650%20,542.50 269,542.50 1,826 1/30/2015 CD BANK OF GEORGETOWN 1.65%249,000.00 249,000.00 1.650%20,542.50 269,542.50 1,826 2/6/2015 CD MACHIAS SAVINGS BANK 1.65%247,000.00 247,000.00 1.650%20,377.50 267,377.50 1,826 3/3/2015 CD THIRD FEDERAL SAVING & LOAN 1.75%247,000.00 246,407.20 1.754%22,146.09 268,553.29 1,821 3/25/2015 CD WELLS FARGO BANK SIOUX FALLS 1.5%247,000.00 247,000.00 1.500%18,525.00 265,525.00 1,827 4/22/2015 CD MARLIN BUSINESS BANK SALT LAKE 1.6%247,000.00 247,000.00 1.600%19,760.00 266,760.00 1,827 5/13/2015 CD WORLD FOREMOST BANK SYDNEY 2.00%200,000.00 200,000.00 2.000%20,000.00 220,000.00 1,827 6/29/2015 CD FIRST SOURCE BANK 1.85%247,000.00 246,382.50 1.904%23,465.00 269,847.50 1,827 7/31/2015 CD INSTITUTION FOR SAVINGS 2.05%249,000.00 249,000.00 2.050%25,522.50 274,522.50 1,827 8/6/2015 CD ORRSTOWN BANK 2.0%249,000.00 249,000.00 2.000%24,706.33 273,706.33 1,841 8/11/2015 CD INVESTOR BANK 2.0%247,000.00 247,000.00 2.000%24,700.00 271,700.00 1,841 9/10/2015 CD MERRICK BANK 1.85%249,000.00 248,377.50 1.910%23,655.00 272,032.50 1,827 9/22/2015 CD BARCLAYS BANK 2.2%248,000.00 248,000.00 2.200%27,190.31 275,190.31 1,821 10/19/2015 CD COMENITY CAP BANK 2.0%249,000.00 249,000.00 2.000%24,818.14 273,818.14 1,821 1/15/2016 CD INVESTORS CMNTY BANK 1.85%249,000.00 249,000.00 1.850%23,032.50 272,032.50 1,827 6/10/2016 CD UBS BANK USA SALT LAKE CITY 1.65%249,000.00 249,000.00 1.650%20,508.73 269,508.73 1,823 6/23/2016 CD EAST BOSTON SAVING BANK 1.5%248,000.00 248,000.00 1.500%18,600.00 266,600.00 1,826 6/24/2016 CD FIRST BUSINESS BK MADISON 1.5%248,000.00 248,000.00 1.500%18,600.00 266,600.00 1,826 6/30/2016 CD FIRST TECHNOLOGY FEDERAL CR UNION 1.75%248,000.00 248,000.00 1.750%21,700.00 269,700.00 1,826 SUB-TOTAL 15,041,000.00 15,029,917.40 1.577%1,097,064.05 16,126,981.45 1,642 O WELLS FARGO BANK 540,810.00 540,810.00 0.020%0.30 540,810.30 1 O CORPORATE CASH MANAGEMENT ACCOUNT 5,519,622.97 5,519,622.97 0.020%3.02 5,519,625.99 1 O LIBRARY ACCOUNT 344.81 344.81 0.000%-344.81 1 O UNION TRUST 12,152,952.58 12,152,952.58 0.000%0.03 12,152,952.61 1 O L A I F WATER DISTRICT 20,984,000.00 20,984,000.00 0.680%396.36 20,984,396.36 1 O LA I F PUBLIC IMPROVEMENT CORPORATION 23,651,000.00 23,651,000.00 0.680%446.74 23,651,446.74 1 O LA I F PUBLIC FINANCING CORPORATION 23,460,000.00 23,460,000.00 0.680%443.13 23,460,443.13 1 O L A I F CITY OF CARLSBAD 22,332,000.00 22,332,000.00 0.680%421.83 22,332,421.83 1 SUB-TOTAL 108,640,730.36 108,640,730.36 0.567%1,711.42 108,642,441.78 GRAND TOTAL 688,127,730.36 692,313,342.50 1.2074%31,358,822.14 723,672,164.64 EXHIBIT 8 CITY OF CARLSBAD Fund Equity in Pooled Investments AS OF DECEMBER 31, 2016 Cash Balance by Fund: General 110,584,271 Special Revenue 26,070,406 Capital Projects: General Capital Construction 38,505,851 Traffic Impact Fees 18,196,363 Public Facilities Fees 26,782,883 Park Development 9,810,158 Transnet Taxes 5,838,368 Drainage Fees 6,659,379 Special Districts 93,196,176 Infrastructure Replacement 100,504,643 Other Capital Construction 16,635,156 316,128,977 Total Enterprise: Carlsbad Municipal Water District 119,196,247 Sewer Fund 44,828,002 Solid Waste 7,236,821 Storm Water 6,021,782 Golf Course 1,546,327 Total 178,829,179 Internal Service 44,989,301 Agency Funds 14,549,845 Trust Funds 158,438 Total General Ledger Balance**691,310,417 Reconciling Adjustments (1)(949,845) Total Treasurer's Investment Portfolio at Amortized Cost 690,360,572 (1) The Reconciling Adjustments consist of differences between the General Ledger which is prepared on an accrual basis and the Treasurer's report which is prepared on the cash basis.Accrued Interest, amortized premium or discounts and outstanding checks and deposits in transit are not included in the Treasurer's summary.Differences between the time journal entries are posted and the time this report is produced may also be a component of the adjustment. ""Figures based on best estimate at the time report run on 1/10/17 EXHIBIT 9 CITY OF CARLSBAD INVESTMENT PORTFOLIO As of DECEMBER 31, 2016 CORPORATE NOTE AND COMMERCIAL PAPER RATINGS Corporate Note Investments Meeting the Current Investment Policy: (Ratings must be AA or better by two of the three:Moody's S&P or Fitch) Moody's,S&P Fitch ADP AA3 AA NR ALPHABET, INC AA2 AA NR APPLE AA1 AA+NR BERKSHIRE HATAWAY AA2 AA+A+ CHEVRON AA2 AA-NR COCA COLA AA3 AA-A+ COLGATE-PALMOLIVE AA3 M -AA- EXXON MOBIL AAA AA+NR IBM CORP AA3 AA-A+ JOHNSON & JOHNSON AAA AAA AAA MASS MUTUAL GLOBAL AA2 AA+AA+ MICROSOFT AAA AM AA+ NEW YORK LIFE AAA AA+AAA PRIVATE EXPORT FUNDING (PEFCO)AAA NR AAA ROYAL BANK OF CANADA AAA AM AAA TOYOTA AA3 AA-A WAL-MART AA2 AA AA WESTPAC BANKING CORP AA2 AA-AA- Commercial Paper Investments Meeting the Current Investment Policy: (Ratings must be Al/P1 or better by two of the three:Moody's, S&P or Fitch) (Ratings of other debt must be AA or better by two of the three:Moody's, S&P or Fitch) NONE Investments with Subsequent Changes in Credit Rating * Latest Carrying Market Moody's S&P Fitch Maturity Date Value Value HSBC BANK USA Al AA+NR 06/05/2017 10,000,000 9,862,500 3M COMPANY Al M -NR 08/07/2020 3,540,993 3,496,360 "The City's Investment Policy allows the City Treasurer to determine the course of action that would correct exceptions to the policy.All of these investments are paying interest at the required times.The principal of all investments are considered secure.It is the intent of the City Treasurer to hold these assets in the portfolio until maturity unless events indicate they should be sold. EXHIBIT 10 CITY OF CARLSBAD INVESTMENT PORTFOLIO AS OF DECEMBER 31, 2016 WEIGHTINGS FOR CORPORATE AND FEDERAL AGENCY ISSUERS PERCENTAGE WEIGHTINGS BY CORPORATE NOTE ISSUER Investment Cost Percent of Portfolio* ADP 4,029,600.00 0.58% ALPHABET, INC 1,094,000.00 0.16% APPLE INC 8,575,865.00 1.24% BERKSHIRE HATHAWAY 12,981,893.88 1.88% CHEVRON 13,865,384.00 2.00% COCA COLA CO 8,073,352.17 1.17% COLGATE-PALMOLIVE 5,963,635.00 0.86% EXXON MOBIL 9,393,774.99 1.36% HSBC BANK USA 10,000,000.00 1.44% IBM CORP 9,138,239.42 1.32% JOHNSON & JOHNSON 7,443,878.49 1.08% MASS MUTUAL 6,842,020.01 0.99% MICROSOFT 14,591,560.00 2.11% 3M COMPANY 3,554,215.00 0.51% NEW YORK LIFE 9,405,696.83 1.36% PE FCO 10,256,822.90 1.48% ROYAL BANK OF CANADA 3,566,040.08 0.52% TOYOTA 7,055,840.00 1.02% WAL-MART 13,511,314.19 1.95% WESTPAC BANKING CORP 5,000,000.00 0.72% PERCENTAGE WEIGHTINGS BY FEDERAL AGENCY ISSUER Investment Cost Percent of Portfolio** FAMCA 16,622,110.00 2.40% FICO 8,733,759.39 1.26% FEDERAL FARM CREDIT BANK 57,173,350.43 8.26% FEDERAL HOME LOAN BANK 79,150,576.04 11.43% FEDERAL HOME LOAN MORTGAGE CORP 49,271,813.00 7.12% FEDERAL NATIONAL MORTGAGE ASSOC 86,672,221,17 12.52% RFCO STRIP PRINCIPAL 2,750,760.00 0.40% TENNESSEE VALLEY AUTHORITY 3,866,885.00 0.56% U.S.TREASURY 100,058,087.76 14.45% Total Portfolio $692,313,342.50 No more than 5% may be invested with a single corporate issuer. **There are no percentage limits on federal agency issuers. City of Carlsbad Bond Proceeds Investment Report December 31, 2016 Stated Int.Maturity Fund Type Investments Rate Date Par Value Cost Source Assessment District 03-01 (College/Cannon)Fiscal Agent:BNY Mellon Project Fund Invesco Gov. & Agency -Institutional Money Market N/A N/A $932,703 $932,703 Invesco Re-Assessment District 97-01 (Alga Road & College Blvd)Fiscal Agent:US Bank Imprvmnt Fund -Alga Invesco Gov. & Agency -Institutional Money Market N/A N/A $279,813 $279,813 Invesco Assessment District 95-01 (Carlsbad Ranch)Fiscal Agent:BNY Mellon Reserve Fund Repub Natl Bank Repo Agreement: HSBC (GIC)5.83%N/A $1,084,962 $1,084,962 HSBC Bank of New York Assessment District 96-01 (Rancho Carrillo)Fiscal Agent:BNY Mellon Reserve Fund Repub Natl Bank Repo Agreement: HSBC (GIC)6.03%09/02/28 $1,292,770 $1,292,770 HSBC Bank of New York ReAssessment District 2012-1 (College/Cannon & Poinsettia Lane)Fiscal Agent:BNY Mellon Reserve Fund Invesco Gov. & Agency -Institutional Money Market various N/A $2,174,323 $2,174,323 BNY Mellon Other Invesco Gov. & Agency -Institutional Money Market various N/A $29 $29 BNY Mellon Communities Facilities District #3 Improvement Area 1, 2016 Bonds Fiscal Agent:BNY Mellon Reserve Fund Invesco Gov. & Agency -Institutional Money Market various 09/01/36 $547,876 $547,876 BNY Mellon Cost of Issuance Invesco Gov. & Agency -Institutional Money Market various 09/01/36 $18,401 $18,401 BNY Mellon Communities Facilities District #3 Improvement Area 2, 2016 Bonds Fiscal Agent:BNY Mellon Escrow Fund Invesco Gov. & Agency -Institutional Money Market various 09/01/18 $13,926,893 $13,926,893 BNY Mellon Reserve Fund Invesco Gov. & Agency -Institutional Money Market various 09/01/38 $811,103 $811,103 BNY Mellon Cost of Issuance Invesco Gov. & Agency -Institutional Money Market various 09/01/38 $9,903 $9,903 BNY Mellon $21,078,776 $21,078,776 tliX H edH 1-3 i— FAMy Documents\junk\Qtr Inv Rpt 1216 i— City of Carlsbad Summary of Outstanding Housing Loans As of December 31, 2016 Loan amount Developer roan Loans issued by City Loans issued by Developer due to City amount due toFirst date #of loans to developers/Developer to #of loans City loan repaid loan repaid to (recorded as City (not onBorrowerDevelopmentPurposeissuedissuedhomeownershomeownersoutstandingto City City AR)City's books)Type of Loan Individual homebuyers City-wide (CHAP)Sale 06/28/99 133 $1,680,000 $-4 ($1,680,000)$-($0.08)$-(0)uPnalYmessenhtodm'er'''issoldtbM"reefa.1131Beh irn""tpear Isdun Payment deferred 30 years.No interest Is dueIndividual homebuyers Calavera Hills Sale 10/15/99 5 75,000 150,000 1 (60,000)(120,000)15,000 30,000 45,000 unless home is arid before 37th year Payment deferred 30 years.No interest Is dosIndividual homebuyers Cherry Tree Walk Sale 06/28/99 42 453,600 452,600 12 (324,000)(283,250)129,600 169,350 298,950 unless home is sold before 37th year Payment deferred 30 years.No Interest Is dueIndividual homebuyers Serrano Sale 05/25/01 90 1,350,000 4,050,000 23 (1,020,135)(2,745,000)329,865 1,305,000 1,634,865 unless home is sold before 31thyeaIndividual homebuyers Rancho Carlsbad Sale 05/20/99 22 752,533 5 (592,646)159,887 159,887 Principal is due when homeis soldIndividual homebuyers Solamar Sale 09/26/88 9 147,726 -1 (135,065)-12,661 -12,661 Principal is due when homeis soldCatholic Charities Homeless shelter Shelter 09/19/97 1 200,000 -1 -200,000 -200,000 Principal is due when property Is sold Principal and 3% interest each year for 30 yearsCB Laurel Tree Apartments Laurel Tree Rentals 12/24/98 2 1,134,000 -2 (1,134,000)-(0)-(0)when surplus cash is available Principal and 3% interest each year for 55 yearsUSA Properties c/o CFHP Rancho Carrillo Rentals 03/05/01 1 1,157,584 -1 (54,385)-1,103,199 -1,103,199 when surplus cash is available Principal and 3% interest each year for 55 yearsPacific Vista Las Flores Vista Las Flores Rentals 02/27/01 1 363,948 -1 -363,948 -363,948 whsrplus cashis available Principal end3interteahyearfor 55ye.r.Poinsettia Housing Assoc Poinsettia Station Rentals 10/21/99 1 920,000 -1 (458,964)-461,036 -461,036 when surplus cashis available Principal and 3% interest each year for 15yet.Bridge Housing Corp Villa Loma Rentals 11/04/94 2 2,212,000 -0 (2,212,000)---when surplus cash is available Principal and 3% interest each year far 55 yearsDove Family Housing La Costa Paloma Rentals 07/15/03 1 2,070,000 -1 (2,070,000)-(0)-(0)when surplus cashis available Principal and 3% interest each year for 55 yearsCIC Calavera LP Mariposa Apts Rentals 09/15/04 1 1,060,000 -1 -1,060,000 -1,060,000 when surplus cashis availablemulberry at Payment deferred 30 years.No Interest is dueIndividual homebuyers Bressi Ranch Sale 04/29/05 100 1,840,000 19,660,200 100 -1,840,000 19,660,200 21,500,200 unless home is sold before 37th year Payment deferred 30 years.No interest Is dueIndividual homebuyers Village by the Sea Sale 10/28/05 11 220,000 4,087,200 11 --220,000 4,087,200 4,307,200 unless home is sold before 31th year Principal and 3% interest each year for 55 yearsEl Camino Family Housing Cassia Heights Rentals 03/07106 1 1,454,276 -1 --1,454,276 -1,454,276 when surplus cash is available Payment deferred 45 years,No Interest Is dueIndividual homebuyers Laguna Point Sale 07/06/06 3 210,000 2 (70,000)140,000 -/40,000 unless home isreo45efore,sold before 46th year Payment deferred 30 years.No intense le dueIndividual homebuyers The Bluffs Sale 06/14/07 10 200,000 10 -200,000 -200,000 unless home is sold before314h yew Refer to Agenda B11118,589/Resolution 2006-131 &Individual homebuyers Roosevelt Gardens Sale 08/30/07 11 1,583,423 11 1,583,423 -1,583,423 ABI9,183iR2007-255 CIC La Costa Hunter's Point Rentals 08/19/08 I 1,932,000 -1 --1,932,000 -1,932,000 Refer to 9818.251 / Resolution 2005-269 Down Payment 8 Closing Cost Assistance Various Assistance 06/25/09 22 255,518 21 (12,500)-243,018 -243,018 Refer to Agenda SR 19,416/ Resolution 2006-121 CIC Glen Ridge, LP Glen Ridge Rentals 10/05/09 1 1,014,000 1 1,014,000 -1,014,000 Refer to Agenda 8111397/ Resolution 435 Tavarua Senior Apartments, LP Tavarua Rentals 12/14/11 1 -1 _-_Refer to AgendaBID418/Resolution 975 North County Solutions for Change Property Acquisition Rentals 06/28/12 1 780,000 -1 -780,000 -780,000 Refer to AgendaBM20,530/Resolution 2012-136 Refer to AB111,76B/R2000-068; AB20,530/R2011-Catholic Charities Homeless shelter Shelter 03/01/10 3 507,585 -3 -507,585 -507,585 oat; AB20,764/R2011-288Minor Home Individual homeowners N/A Repair 05/20/10 10 22,877 -5 (2,083)20,794 -20,794 Refer to AB19,415/Resolution 2008-121 Property Hospice of North Coast N/A Acquisition 02/27/13 1 1,065,000 -1 --1,065,000 1,065,000 Refer to AB21,1181Resolution 2013-027 Property Harding Street Neighbors, LP Carol-Harding Duplex Acquisition 03/14/13 1 7,408,000 -1 -7,408,000 -7,408,000 Refer ta AB21,02a/Resaluthen 2012-235 Tracy Templeton Laguna Point Sale 04/17/13 1 108,150 -1 -108,150 -108,150 TBD Payment deferred 30 yearn.No Interest Is dueThomas 8 Judy Kim Rose Bay Sale 08/23/13 1 229,775 1 -229,775 -229,775 unless hams 9sold before 31th year Property Solutions for Change N/A Acquisition 12/19/14 1 2,646,000 1 2,646,000 -2,646,000 Refer to AB21.763/Resalutlen 2014-293 Chelsea Inv Corp/Quarry Creek CiC LLP Quarry Creek Rentals 08/31/16 1 1,280,000 1 1,280,000 -1,280,000 Allowances (1,593,379)(1,593,379) 492 $34,739,616 $28,400,000 228 $(9,825,778)$(3,148,250)$ 24,913,838 $25,251,750 $51,758,967 July 16: received 81,081.31 in CHAP loan payments.August16: received $678 in CHAP loan payments; issued a $1,280,000 affordable housing loan for Quarry Creek rentals: received 0 8112,942 payment related to the Poinsettia Station development.September 16: recieved $562 inCHAP loan payments.November16: received$15,000 loan pay-off related to the Serrano development.December 2016: CHAP loans officially paid-off LI MH COH F._k Ni ..