Loading...
HomeMy WebLinkAbout2019-11-19; City Council; ; Report on City Investments as of Sept. 30, 20199 CITY COUNCIL Staff Report Meeting Date: To: From: Staff Contact: Nov. 19, 2019 Mayor and City Council Scott Chadwick, City Manager Craig Lindholm, City Treasurer CA Review ~ Laura Rocha, Deputy City Manager -Administrative Services, Laura.Rocha@carlsbadca.gov or 760-602-2415 Subject: Report on City Investments as of Sept. 30, 2019 Recommended Action Accept and file Report on City Investments as of Sept. 30, 2019. Executive Summary The city's Investment Policy requires the city treasurer to report to the City Council monthly the status of the city's pooled investment portfolio. A quarterly report is also required for the investments of bond proceeds held separately. Discussion The city's pooled investment portfolio as of the month ending Sept. 30, 2019 is summarized below. Pooled Investment Portfolio (Cash and Securities) Par Value Investment Cost Amortized Cost (1) Market Value (2) Current Month $772,869,419 $774,164,956 $773,750,354 $779,530,733 Prior Month $771,675,111 $772,368,494 $772,271,175 $778,038,180 (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 Wells Fargo Bank's custodial report, as of Sept. 30, 2019. The equity portion of the various funds in the total portfolio is summarized in the graph on the next page. Fund balances are restricted for various purposes. See Exhibit 8 for a more detailed breakdown. Nov. 19, 2019 Item #1 Page 1 of 22 The pooled investment portfolio has the ability to meet the city's cash flow demands for the next six months. Fiscal Analysis None. Next Steps The report on city investments will continue to be 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 and Outreach This item was noticed in accordance with the Ralph M. Brown Act and was available for viewing at least 72 hours prior to the posting of the agenda. Exhibits 1. Investments by Amortized Cost, Market Value, Cash Income, and Average Yield 2. Maturities by Classification and Length of Time at Market Value 3. Yield Comparison 4. Market Yield Curve 5. Cumulative Cash Income Graph 6. Maturities, Purchases and Calls this Quarter 7. Detailed Investment Report 8. Fund Equity in Pooled Investments 9. Corporate Note and Commercial Paper Ratings 10. Corporate and Federal Agency Issuers -Percent of Total Portfolio 11. Investments of Bond Proceeds Held Separately as of Sept. 30, 2019 12. Summary of Outstanding Housing Loans as of Sept. 30, 2019 Nov. 19, 2019 Item #1 Page 3 of 22 City of Carlsbad Investment Portfolio As of September 30, 2019 Investments by Amortized Cost, Market Value, Cash Income, and Average Yield by Class Amortized Cost Market Value Average Yield Class Current Month Prior Month Current Month Prior Month Cash Income Current Month Prior Month CD $17,264,317 $18,006,317 $17,505,605 $18,247,533 $112,103 1.99% 2.01% FN 7,641,820 12,603,579 8,130,476 13,422,685 0 1.71 1.66 TR 78,577,770 78,577,770 78,977,698 78,977,698 528,700 1.75 1.75 FA 361,589,019 357,721,243 363,298,651 359,403,693 2,005,004 1.58 1.60 SN 21,534,726 21,534,726 21,906,665 21,906,665 147,093 1.75 1.75 CN 175,430,885 174,134,747 177,585,219 176,289,795 918,106 2.87 2.84 LAIF 106,306,794 98,306,794 106,306,794 98,306,794 734,902 2.34 2.38 Custody 1,351,270 4,057,369 1,351,270 4,057,369 3,745 0.75 0.75 Sweep 4,103,024 6,115,779 4,103,024 6,115,779 36,077 2.00 2.00 Bank Account 365,332 1,310,170 365,332 1,310,170 0 0.75 0.75 Total $774,164,956 $772,368,494 $779,530,733 $778,038,180 $4,485,729 2.01% 2.10% CD -Certificate of Deposit Custody -Investment Cash account FN -Federal Discount Notes Sweep -General Fund Overnight Cash account TR -US Treasury Bank Account -General Fund Cash account SN -Supranational m X :::c c:, =i .... Nov. 19, 2019 Item #1 Page 4 of 22 City of Carlsbad Investment Portfolio As of September 30, 2019 Maturities by Classification and Length of Time at Market Value Class Within 6 Months 7 Months to 1 Year 1 to 5 Years Total CD $3,960,388 $1,940,476 $10,842,209 $16,743,073 FN 0 5,188,976 2,941,500 8,130,476 TR 0 13,734,538 65,243,160 78,977,698 FA 45,802,195 49,945,695 267,550,762 363,298,651 SN 0 3,085,431 18,821,234 21,906,665 CN 24,849,564 14,022,800 139,475,388 178,347,751 LAIF 106,306,794 0 0 106,306,794 Custody 1,351,270 0 0 1,351,270 Sweep 4,103,024 0 0 4,103,024 Bank Acct 365,332 0 0 365,332 Totals $186,738,565 (1) $87,917,915 (1) $504,874,252 $779,530,733 % Totals 24.0% 11.3% 64.8% 100.0% Total within One Year $274,656,480 (1) 35.2% % Total 2.1% 1.04 10.13 46.60 2.81 22.88 (2) 13.64 0.17 0.53 0.05 100.0% Policy: (1) Not less than $199,022,000 to mature within one year. Two-thirds of current year operating budget of $297,048,458 (2) Policy states that not more than 30% of portfolio is to be invested in corporate notes. m X ::c c::, =i N Nov. 19, 2019 Item #1 Page 5 of 22 Maturities, Purchases, and Calls this Quarter EXHIBIT 6 Maturities CUSIP Investment# Issuer Settled Maturity Rate Par Value Book Value Interest Total Net Income 3137EADK2 11434 FHLMC 1/21/2015 8/1/2019 1.25 2,500,000 2,500,000 15,625 2,515,625 15,625 940637HS3 11674 WASHT 8/30/2016 8/30/2019 1.20 248,000 248,000 1,484 249,484 1,484 912828TNO 11391 USTR 10/6/2014 8/31/2019 1.00 1,000,000 1,000,000 5,000 1,005,000 5,000 912828D80 11721 USTR 1/10/2017 8/31/2019 1.63 1,250,000 1,250,000 10,156 1,260,156 10,156 313383VN8 11398 FHLB 10/23/2014 9/13/2019 2.00 1,500,000 1,500,000 15,000 1,515,000 15,000 313380FB8 11435 FHLB 1/21/2015 9/13/2019 1.38 2,000,000 2,000,000 13,750 2,013,750 13,750 465076JL2 11680 ISRAEL 9/14/2016 9/16/2019 1.30 248,000 248,000 18 248,018 18 254672AG3 11388 DISCOV 9/24/2014 9/24/2019 2.15 247,000 247,000 2,677 249,677 2,677 38147J5T5 11387 GOLDMA 9/24/2014 9/24/2019 2.15 247,000 247,000 2,677 249,677 2,677 31771KAA5 11467 FICO 4/1/2015 9/26/2019 2,100,000 2,100,000 2,100,000 31771KAA5 11546 FICO 9/23/2015 9/26/2019 1.51 3,200,000 3,200,000 3,200,000 3133EG2D6 11735 FFCB 1/27/2017 9/27/2019 1.55 1,000,000 1,000,000 7,750 1,007,750 7,750 15,540,000 15,540,000 74,137 15,614,137 74,137 Purchases CUSIP Investment # Issuer Settled Maturity Payment Rate Principal Par Value Book Value 89236TCQ6 12063 TOYOTA 7/1/2019 7/13/2022 07 /13 -01/13 2.80 2,500,000 2,551,875 2,547,600 3134GTYK3 12064 FHLMC 7/2/2019 7/2/2024 01/02 -07 /02 2.00 2,500,000 2,500,000 2,500,000 3134GTYS6 12065 FHLMC 7/3/2019 7/1/2022 01/01 -07 /01 2.00 2,500,000 2,500,000 2,500,000 313383WD9 12067 FHLB 7/5/2019 9/9/2022 09/09 -03/09 3.13 1,800,000 1,874,106 1,868,535 3134GTXQ1 12066 FHLMC 7/5/2019 12/23/2022 12/23 -06/23 2.00 1,500,000 1,500,000 1,500,000 3134GTTK9 12068 FHLMC 7/30/2019 6/26/2024 12/26 -06/26 2.38 2,000,000 2,004,000 2,003,862 9128284A5 12069 USTR 7/30/2019 2/28/2023 08/31 -02/29 2.63 3,000,000 3,085,572 3,081,454 037833BU32 12072 APPLEI 7/31/2019 2/23/2023 08/23 -02/23 2.85 3,500,000 3,592,680 3,588,342 14042RMN8 12071 CAPITA 7/31/2019 7/31/2024 01/31 -07 /31 2.25 247,000 247,000 247,000 46625HJX9 12074 JPMORG 7/31/2019 5/13/2024 11/13 -05/13 3.63 2,000,000 2,119,320 2,115,163 3133EKYR1 12075 FFCB 8/8/2019 2/8/2022 02/08 -08/08 2.16 2,000,000 2,000,000 2,000,000 3133EKWV4 12076 FFCB 8/8/2019 7/26/2024 01/26 -07 /26 1.85 2,500,000 2,532,125 2,531,173 44329MA45 12077 HSBC 8/13/2019 8/13/2024 02/13 -08/13 2.30 246,000 246,000 246,000 023135AZ9 12079 AMAZ.C 8/26/2019 8/22/2024 02/22 -08/22 2.80 2,000,000 2,087,280 2,085,579 3133EKNXO 12081 FFCB 8/28/2019 6/3/2024 12/03 -06/03 2.16 1,470,000 1,517,378 1,516,466 3133EKF27 12083 FFCB 8/28/2019 8/26/2022 02/26 -08/26 1.85 1,500,000 1,499,565 1,499,578 09247XAL5 12086 BLACKR 8/29/2019 3/18/2024 09/18 -03/18 3.50 2,000,000 2,162,500 2,159,327 19416QEA4 12085 COLGAT 8/29/2019 2/1/2023 02/01 -08/01 1.95 1,000,000 1,011,600 1,011,299 3133EKEC6 12082 FFCB 8/29/2019 6/25/2024 12/25 -06/25 2.45 1,183,000 1,237,524 1,236,519 459056HV2 12084 IBRD 8/29/2019 8/28/2024 02/28 -08/28 1.50 2,000,000 2,006,920 2,006,797 3133EKQA7 12087 FFCB 8/30/2019 9/10/2024 09/10 -03/10 2.08 2,500,000 2,572,420 2,571,180 93882.8BM1 12078 WASHIN 8/30/2019 8/30/2024 09/30 -Monthly 2.00 249,000 249,000 249,000 3133EKH41 12080 FFCB 9/3/2019 9/3/2024 03/03 -09/03 2.00 4,000,000 4,000,000 4,000,000 3130A3DL5 12088 FHLB 9/3/2019 9/8/2023 09/08 -03/08 2.38 2,000,000 2,069,108 2,067,769 3133EKQN9 12091 FFCB 9/10/2019 12/13/2021 12/13 -06/13 1.88 2,000,000 2,017,240 2,016,795 084670BJ6 12092 BRK 9/12/2019 2/11/2023 02/11 -08/11 3.00 1,250,000 1,296,138 1,295,424 3133XN4B2 12093 FHLB 9/12/2019 12/9/2022 12/09 -06/09 5.25 1,500,000 1,670,736 1,667,956 29278TLH1 12090 EN ERB 9/13/2019 9/13/2024 10/13 -Monthly 1.75 249,000 249,000 249,000 3133EKZK5 12095 FFCB 9/13/2019 8/14/2023 02/14 -08/14 1.60 1,800,000 1,796,580 1,796,624 3133EKG42 12096 FFCB 9/13/2019 8/28/2023 02/28 -08/28 1.92 1,000,000 997,650 997,680 3134GUBQ2 12097 FHLMC 9/23/2019 9/23/2024 03/23 -09/23 2.10 1,000,000 1,000,000 1,000,000 54,994,000 56,193,317 56,156,121 Calls CUSIP Investment# Issuer Settled Maturity Redeemed Rate Par Value Interest Total Net Income 3134GB6Ul 11832 FHLMC 12/29/2017 12/29/2022 07/01/2019 2.500 2,000,000 2,000,000 3133EJGJ2 11883 FFCB 04/13/2018 09/15/2020 07/02/2019 2.470 1,750,000 12,847 1,762,847 13,464 3133EKFK7 12027 FFCB 04/12/2019 07/05/2022 07/05/2019 2.600 2,000,000 13,000 2,013,000 13,371 3130ADHR6 11867 FHLB 02/23/2018 02/01/2023 07/18/2019 2.630 2,750,000 33,551 2,783,551 53,240 3133EJVG1 11925 FFCB 08/03/2018 07/25/2023 07/25/2019 3.220 1,500,000 24,150 1,524,150 25,355 05581WE50 11942 BMO 10/26/2018 10/26/2023 07/26/2019 3.350 249,000 249,000 3136G3F75 11703 FNMA 11/17/2016 07/28/2021 07/28/2019 1.000 2,600,000 26,000 2,626,000 27,661 3134GSCD5 11874 FHLMC 03/09/2018 01/30/2023 07/30/2019 2.550 2,000,000 25,500 2,025,500 46,393 3133EH3Y7 11845 FFCB 01/03/2018 12/21/2021 08/14/2019 2.230 3,000,000 9,849 3,009,849 14,298 3134GSCJ2 11881 FHLMC 04/10/2018 02/16/2023 08/16/2019 2.625 2,500,000 32,813 2,532,813 51,215 3134G8L31 11614 FHLMC 02/26/2016 02/26/2021 08/26/2019 1.250 1,000,000 7,500 1,007,500 7,650 3133EHTA1 11945 FFCB 11/07/2018 08/01/2023 08/27/2019 2.350 1,400,000 2,376 1,402,376 43,978 3133EHTA1 11947 FFCB 11/08/2018 08/01/2023 08/27/2019 2.350 1,350,000 2,291 1,352,291 44,325 3130ACX66 11825 FHLB 11/30/2017 11/28/2022 08/28/2019 2.300 2,500,000 14,375 2,514,375 14,375 31422BDN7 12015 FAMCA 03/20/2019 03/20/2024 09/20/2019 3.000 2,000,000 30,000 2,030,000 30,000 687377DR9 11537 ORRSTO 08/20/2015 08/20/2020 09/20/2019 2.000 249,000 249,000 3134GTAC7 12024 FHLMC 04/11/2019 03/27/2023 09/27/2019 2.830 2,000,000 28,300 2,028,300 24,766 3134GBCWO 11754 FHLMC 03/29/2017 03/29/2022 09/29/2019 2.350 1,150,000 13,513 1,163,513 13,513 31,998,000 276,065 32,274,065 423,603 Nov. 19, 2019 Item #1 Page 8 of 22 City of Carlsbad Investment Summary Detailed Investment Report As of September 30, 2019 Settled Matures !YJ2g Security Par Cost Return (Yield) Weight~d Avg Yield Interest Exgected Return at Maturity: Term (Da~sl 7/19/2016 10/2/2019 FA FHLMC 1.25% NON-CALL 3,000,000.00 3,027,363.00 1.250% 0.0001047 92,741.17 3,120,104.17 1,170 10/6/2015 10/24/2019 FA FNMA 1.33% NON-CALL 4,183,000.00 4,197,807.82 1.240% 0.0001440 210,509.47 4,408,317.29 1,479 5/26/2016 11/26/2019 FA FNMA 1.30% QRTLY CALL 4,000,000.00 4,000,000.00 1.300% 0.0001438 182,000.00 4,182,000.00 1,279 6/15/2015 12/13/2019 FA FHLB 2.375% NON-CALL 3,370,000.00 3,468,026.56 1.700% 0.0001630 261,697.54 3,729,724.10 1,642 2/21/2017 12/13/2019 FA FHLB 2.375% NON-CALL 1,000,000.00 1,024,070.00 1.497% 0.0000424 42,693.89 1,066, 763.8_9 1,025 5/19/2017 12/27/2019 FA FNMA 1.20% QUARTERLY CALL 2,500,000.00 2,482,475.00 1.475% 0.0001013 95,691.67 2,578,166.67 952 10/5/2015 1/9/2020 FA FHLMC 1.40% NON-CALL 3,500,000.00 3,519,495.00 1.265% 0.0001231 189,299.44 3,708,794.44 1,557 4/26/2017 1/17/2020 FA FHLMC 1.50% NON-CALL 1,250,000.00 1,251,150.00 1.465% 0.0000507 49,943.75 1,301,093.75 996 2/7/2019 1/17/2020 FA FHLMC 1.5% BULLET 2,000,000.00 1,981,420.00 2.500% 0.0001370 46,913.33 2,028,333.33 344 7/28/2016 1/28/2020 FA FNMA 1.20% CALL 7 /28/17 ONE TIME 4,850,000.00 4,850,000.00 1.200% 0.0001610 203,700.00 5,053,700.00 1,279 5/13/2016 2/13/2020 FA FHLMC 1.30% CALL 2/13/17 ONE TIME 2,750,000.00 2,750,000.00 1.300% 0.0000989 134,062.50 2,884,062.50 1,371 6/11/2018 2/14/2020 FA FHLB 2.15% CALL 2/14/19 QRTLY 1,500,000.00 1,491,780.00 2.485% 0.0001025 6i,238.75 1,554,018.75 613 2/24/2016 2/24/2020 FA FHLMC 1.50% CONT CALL 1,750,000.00 1,750,000.00 1.500% 0.0000726 105,000.00 1,855,000.00 1,461 2/24/2016 2/24/2020 FA FFCB 1.4% CONT CALL 1,000,000.00 1,000,000.00 1.400% 0.0000387 56,000.00 1,056,000.00 1,461 1/4/2017 2/28/2020 FA FHLMC 1.25% QRTLY CALL 2,000,000.00 1,978,000.00 1.610% 0.0000881 100,750.00 2,078,750.00 1,150 5/23/2016 3/15/2020 FA PEFCO 2.25% NON-CALL 3,000,000.00 3,099,000.00 1.358% 0.0001164 158,250.00 3,257,250.00 1,392 5/4/2018 3/15/2020 FA TENN VALLEY AUTHORITY 2.25% NON-CALL 1,700,000.00 1,692,265.00 2.500% 0.0001170 79,028.75 1,771,293.75 681 6/12/2018 3/15/2020 FA TENN VALLEY AUTHORITY 2.25% NON-CALL 1,250,000.00 1,244,200.00 2.520% 0.0000867 55,253.13 1,299,453.13 642 6/11/2018 3/15/2020 FA TENN VALLEY AUTHORITY 2.25% NON-CALL 1,250,000.00 1,244,622.50 2.500% 0.0000861 54,908.75 1,299,531.25 643 8/29/2017 4/3/2020 FA FFCB 1.67% CALL 7 /2/18 CONT 2,000,000.00 1,999,600.00 1.678% 0.0000928 87,054.44 2,086,654.44 948 7/13/2016 4/13/2020 FA FNMA 1.25% CALL 4/13/17 ONE TIME 5,000,000.00 5,000,000.00 1.250% 0.0001728 234,375.00 5,234,375.00 1,370 1/6/2017 4/13/2020 FA FFCB 1.4% CONT CALL 1,000,000.00 992,000.00 1.652% 0.0000453 53,772.22 1,045,772.22 1,193 12/15/2017 4/17/2020 FA FAMCA 1.64% NON-CALL 1,500,000.00 1,487,706.00 2.000% 0.0000823 69,830.67 1,557,536.67 854 7/28/2016 4/28/2020 FA FNMA 1.25% CALL 4/28/17 ONE TIME 3,750,000.00 3,750,000.00 1.250% 0.0001296 175,781.25 3,925,781.25 1,370 11/3/2017 5/15/2020 FA FHLB 1.7% ONE CALL 5/15/19 1,650,000.00 1,650,000.00 1.700% .0.0000776 71,060.00 1,721,060.00 924 5/22/2017 5/22/2020 FA FHLMC 1.625% ONE CALL 5/22/18 1,200,000.00 1,200,000.00 1.625% 0.0000539 58,500.00 1,258,500.00 1,096 5/24/2017 5/29/2020 FA FHLMC 1.625% ONE CALL 5/19/20 2,250,000.00 2,255,062.50 1.548% 0.0000965 104,523.44 2,359,585.94 1,101 6/27/2017 5/29/2020 FA FHLMC 1.625% ONE CALL 5/19/20 1,600,000.00 1,604,000.00 1.537% 0.0000682 71,977.78 1,675,977.78 1,067 6/5/2017 6/5/2020 FA FHLB 1.6% CALL 12/5/17 CONT 1,300,000.00 1,300,000.00 1.600% 0.0000575 62,400.00 1,362,400.00 1,096 6/8/2017 6/5/2020 FA FHLB 1.60% CALL 12/5/17 CONT 2,500,000.00 2,500,000.00 1.600% 0.0001106 120,000.00 2,620,000.00 1,093 6/12/2015 6/12/2020 FA FHLB 1.75% NON-CALL 3,000,000.00 3,000,000.00 1.750% 0.0001452 262,500.00 3,262,500.00 1,827 2/23/2016 6/12/2020 FA FHLB 1.75% NON-CALL 2,000,000.00 2,039,980.00 1.271% 0.0000717 110,617.22 2,150,597.22 1,571 4/15/2016 6/26/2020 FA FNMA 1.35% NON-CALL 2,150,000.00 2,159,632.00 1.240% 0.0000741 112,192.37 2,271,824.37 1,533 7/13/2016 7/13/2020 FA FFCB 1.19% CALL 7/13/17 CONT 4,250,000.00 4,250,000.00 1.190% 0.0001399 202,300.00 4,452,300.00 1,461 4/13/2018 7/13/2020 FA FFCB 1.29% CALL 4/19/18 CONT 2,000,000.00 1,948,000.00 2.485% 0.0001339 110,050.00 2,058,050.00 822 4/27/2017 7/27/2020 FA FHLMC 1.7% CALL4/27/18 1,600,000.00 1,600,000.00 1.700% 0.0000752 88,400.00 1,688,400.00 1,187 1/21/2016 7/29/2020 FA FHLB 1.83% NON-CALL 2,500,000.00 2,549,375.00 1.378% 0.0000972 157,516.67 2,706,891.67 1,651 9/7/2016 8/24/2020 FA FFCB 1.32% CALL 8/24/17 CONT 3,000,000.00 2,998,260.00 1.335% 0.0001107 158,710.00 3,156,970.00 1,447 4/19/2016 8/28/2020 FA FHLMC 1.65% NON-CALL 1,000,000.00 1,017,760.00 1.230% 0.0000346 54,152.50 1,071,912.50 1,592 6/8/2016 9/11/2020 FA FHLB 2.875% NON-CALL 3,000,000.00 3,206,160.00 1.214% 0.0001076 161,121.25 3,367,281.25 1,556 10/12/2016 9/11/2020 FA FHLB 1.375% NON-CALL 1,800,000.00 1,808,975.18 1.244% 0.0000622 87,893.57 1,896,868.75 1,430 10/12/2016 10/6/2020 FA FHLB 1.375% CALL 1/6/17 1,800,000.00 1,797,300.00 1.414% 0.0000703 101,287.50 1,898,587.50 1,455 m 4/26/2017 10/16/2020 FA FNMA 2.35% SEMI-ANNUAL CALL 1,300,000.00 1,332,019.00 1.618% 0.0000596 74,057.39 1,406,076.39 1,269 X 5/6/2019 10/16/2020 FA FHLMC 1.85% CALL 7/16/19 QUARTERLY 1,500,000.00 1,488,345.00 2.400% 0.0000988 51,738.33 1,540,083.33 529 :::c 4/23/2018 10/27/2020 FA FNMA 1.9% CALL 7/27/18 CONT 1,721,125.00 2.583% 0.0001229 112,369.44 1,833,494.44 918 c:, 1,750,000.00 =i 7/22/2016 11/27/2020 FA FNMA 1.65% NON-CALL 3,250,000.00 3,316,612.00 1.165% 0.0001069 166,507.79 3,483,119.79 1,589 -.J Nov. 19, 2019 Item #1 Page 9 of 22 Settled Matures ~ Security Par Cost Return {Yield) Weighted Avg Yield Interest Expected Return at Maturity Term /Days) 11/27/2017 11/27/2020 FA FHLMC 1.875% ONE CALL 11/27 /18 1,500,000.00 1,500,000.00 1.875% 0.0000778 84,375.00 1,584,375.00 1,096 6/15/2017 11/30/2020 FA FNMA 2.0% NON-CALL 1,100,000.00 1,113,618.00 1.630% 0.0000502 62,404.22 1,176,022.22 1,264 6/14/2016 12/14/2020 FA FFCB 1.54% CALL 6/14/17 CONT 2,250,000.00 2,250,000.00 1.540% 0.0000958 155,925.00 2,405,925.00 1,644 6/21/2016 12/21/2020 FA FFCB 1.55% CALL 9/21/16 CONT 2,000,000.00 2,000,000.00 1.550% 0.0000857 139,500.00 2,139,500.00 1,644 3/10/2017 1/15/2021 FA FAMCA 2.0% NON-CALL 1,580,000.00 1,576,287.00 2.063% 0.0000899 125,285.22 1,701,572.22 1,407 4/26/2016 1/19/2021 FA FFCB 1.60% CALL 7/19/16 CONT 3,250,000.00 3,247,010.00 1.620% 0.0001455 248,978.89 3,495,988.89 1,729 7/19/2016 1/19/2021 FA FHLB 1.40% CALL 10/19/16 CONT 3,500,000.00 3,500,000.00 1.400% 0.0001355 220,500.00 3,720,500.00 1,645 9/9/2016 1/25/2021 FA FAMCA 1.550% NON-CALL 2,000,000.00 2,018,640.00 1.550% 0.0000865 117,071.11 2,135,711.11 1,599 10/12/2016 2/15/2021 FA TENN VALLEY AUTHORITY 3.875% NON-CALL 3,000,000.00 3,315,660.00 1.370% 0.0001256 189,058.75 3,504,718.75 1,587 8/16/2017 2/16/2021 FA FNMA 1.75% CALL 8/16/18 2,000,000.00 2,000,000.00 1.750% 0.0000968 122,500.00 2,122,500.00 1,280 12/12/2018 2/16/2021 FA FHLMC 2.000% CALL 2/16/19 1,000,000.00 982,400.00 2.838% 0.0000771 61,155.56 1,043,555.56 797 1/10/2019 2/23/2021 FA FFCB 2.7% BULLET 1,500,000.00 1,502,895.00 2.605% 0.0001083 82,942.50 1,585,837.50 775 12/12/2018 2/24/2021 FA FHLB 1.750% NON-CALL 1,000,000.00 977,940.00 2.790% 0.0000755 60,560.00 1,038,500.00 805 2/26/2016 2/26/2021 FA FHLB 1.69% CALL 8/26/16 CONT 480,000.00 480,000.00 1.690% 0.0000224 74,495.20 554,495.20 1,827 2/14/2018 3/12/2021 FA FHLB 2.375% NON-CALL 1,500,000.00 1,500,768.00 2.357% 0.0000978 108,778.87 1,609,546.87 1,122 6/12/2018 3/12/2021 FA FHLB 1.75% NON-CALL 1,000,000.00 976,760.00 2.631% 0.0000711 71,365.00 1,048,125.00 1,004 3/22/2016 3/22/2021 FA "FHLB 1.25% QRTLY CALL 6/22/16 STEP 2,500,000.00 2,498,750.00 1.870% 0.0001292 235,625.00 2,734,375.00 1,826 3/26/2019 3/26/2021 FA FH LMC 2.5% CALL 3/26/20 2,000,000.00 2,000,000.00 2.500% 0.0001383 100,000.00 2,100,000.00 731 9/29/2017 3/26/2021 FA FHLMC 1.75% ONE CALL 9/26/18 2,535,000.00 2,531,197.50 1.794% 0.0001256 158,701.56 2,689,899.06 1,274 1/8/2019 4/9/2021 FA FFCB 2. 7% BULLET 1,500,000.00 1,504,860.00 2.550% 0.0001061 86,377.50 1,591,237.50 822 10/26/2017 4/26/2021 FA FHLMC 1.85% ONE CALL 10/26/18 1,975,000.00 1,974,012.50 1.865% 0.0001018 128,868.75 2,102,881.25 1,278 4/28/2016 4/28/2021 FA FHLMC 1.25% QRTLY CALL 10/28/16 STEP 2,500,000.00 2,496,250.00 2.122% 0.0001465 269,375.00 2,765,625.00 1,826 5/25/2016 5/25/2021 FA FFCB 1.66% CALL 5/25/17 CONT 4,000,000.00 3,997,600.00 1.673% 0.0001850 334,400.00 4,332,000.00 1,826 9/12/2017 6/1/2021 FA FHLB 1.875% CALL 9/18/17 CONT 2,500,000:00 2,498,750.00 1.875% 0.0001296 175,598.96 2,674,348.96 1,358 10/12/2016 6/11/2021 FA FHLB 2.25% NON-CALL 1,500,000.00 1,559,427.00 1.370% 0.0000591 97,979.25 1,657,406.25 1,703 6/15/2017 6/14/2021 FA FFCB 1.81% CALL 6/14/18 CONT 1,760,000.00 1,760,000.00 1.810% 0.0000881 127,335.51 1,887,335.51 1,460 6/15/2017 6/15/2021 FA FHLMC 1.8% CALL 6/15/18 ONE TIME 1,400,000.00 1,400,000.00 1.800% 0.0000697 100,800.00 1,500,800.00 1,461 10/26/2016 7/14/2021 FA FHLB 1.125% NON-CALL 2,500,000.00 2,476,850.00 1.328% 0.0000910 155,806.25 2,632,656.25 1,722 1/11/2019 7/19/2021 FA FHLMC 1.5% QTLY CALL 1/19/19 2,000,000.00 1,976,000.00 2.776% 0.0001517 139,666.67 2,115,666.67 920 2/16/2017 7/26/2021 FA FHLMC 1.875% NON-CALL 1,400,000.00 1,392,580.00 2.000% 0.0000770 124,086.67 1,516,666.67 1,621 4/24/2018 7/27/2021 FA FHLB 1.0% CALL 7/27/18 QRTLY 1,400,000.00 1,358,518.00 2.743% 0.0001031 141,348.67 1,499,866.67 1,190 10/2/2017 7/27/2021 FA FHLMC 2.0% ONE CALL 7/27/18 3,000,000.00 3,004,500.00 1.959% 0.0001628 224,666.67 3,229,166.67 1,394 12/19/2017 8/12/2021 FA FHLMC 1.125% NON-CALL 1,000,000.00 967,646.98 2.050% 0.0000549 73,384.27 1,041,031.25 1,332 2/16/2017 8/16/2021 FA FHLB 2.0% CALL 2/16/18 ONE TIME 1,325,000.00 1,325,000.00 2.000% 0.0000733 119,250.00 1,444,250.00 1,642 5/1/2018 9/13/2021 FA FFCB 1.84% CALL 5/7 /18 CONT 2,000,000.00 1,946,000.00 2.684% 0.0001444 177,893.33 2,123,893.33 1,231 3/27/2019 9/27/2021 FA FHLB 2.55% CALL 3/27/20 1,500,000.00 1,500,000.00 2.550% 0.0001058 95,625.00 1,595,625.00 915 12/11/2017 10/5/2021 FA FFCB 2.0% CALL 10/05/18 CONT 2,750,000.00 2,739,907.50 2.100% 0.0001591 220,009.17 2,959,916.67 1,394 10/28/2016 10/7/2021 FA FNMA 1.375% NON-CALL 2,500,000.00 2,491,075.00 1.450% 0.0000999 178,794.79 2,669,869.79 1,805 1/3/2018 10/29/2021 FA FAMCA 1.625% QRTLY CALL 2,000,000.00 1,951,928.00 2.285% 0.0001233 172,294.22 2,124,222.22 1,395 12/14/2018 11/26/2021 FA FHLMC 3.16% CALL 11/26/19 2,000,000.00 2,005,000.00 3.160% 0.0001752 181,440.00 2,186,440.00 1,078 11/29/2016 11/29/2021 FA FFCB 1.76% NON-CALL 3,000,000.00 3,000,000.00 1.760% 0.0001460 264,000.00 3,264,000.00 1,826 4/12/2017 12/10/2021 FA FHLB 1.875% NON-CALL 2,000,000.00 2,003,620.00 1.834% 0.0001016 171,171.67 2,174,791.67 1,703 9/10/2019 12/13/2021 FA FFCB 1.88% BULLET 2,000,000.00 2,017,240.00 1.490% 0.0000831 67,673.33 2,084,913.33 825 1/4/2019 12/27/2021 FA FHLMC 3.05% ONE CALL 12/27/19 1,250,000.00 1,255,937.50 2.566% 0.0000891 107,696.18 1,363,633.68 1,088 4/11/2019 1/24/2022 FA FHLMC 2.5% CALL ONE TIME 1/24/20 2,000,000.00 2,000,000.00 2.501% 0.0001383 137,500.00 2,137,500.00 1,019 3/25/2019 2/3/2022 FA FFCB 2.03% NON-CALL 2,500,000.00 2,483,900.00 2.264% 0.0001555 161,019.44 2,644,919.44 1,046 8/8/2019 2/8/2022 FA FFCB 2.16% CALL 11/8/19 2,000,000.00 2,000,000.00 2.160% 0.0001195 108,000.00 2,108,000.00 915 2/23/2017 2/23/2022 FA FAMCA 2.1% NON-CALL 2,600,000.00 2,609,204.00 2.025% 0.0001461 263,796.00 2,873,000.00 1,826 3/8/2019 2/28/2022 FA FHLB 2.0% CALL 5/28/19 CONT 2,000,000.00 1,969,400.00 2.000% 0.0001089 219,488.89 2,188,888.89 1,088 3/1/2019 3/1/2022 FA FFCB 2.55% NON-CALL 2,000,000.00 2,000,000.00 2.550% 0.0001410 153,000.00 2,153,000.00 1,096 3/29/2017 3/29/2022 FA FHLMC 1.375 ONE CALL 3/29/18 STEP 1,500,000.00 1,500,000.00 2.265% 0.0000940 170,625.00 1,670,625.00 1,826 Nov. 19, 2019 Item #1 Page 10 of 22 Settled Matures Tung Security Par Cost Return !Yield) Weighted Avg Yield fnterest Expected Return at Maturity Term (Daysl 5/25/2017 4/5/2022 FA FNMA 1.875% NON-CALL 1,600,000.00 1,600,581.01 1.867% 0,0000826 145,252.32 1,745,833.33 1,776 4/23/2019 4/8/2022 FA FHLMC 2.5% CALL4/8/20 1,500,000.00 1,501,562.50 2.500% 0,0001038 109,375.00 1,610,937.50 1,081 8/18/2017 4/19/2022 FA FFCB 1.92% CALL4/19/17 CONT 2,000,000.00 1,992,860.00 2.200% 0.0001213 186,446.67 2,179,306.67 1,705 11/3/2017 4/25/2022 FA FHLB 2.0% ONE CALL 10/25/19 2,000,000.00 1,998,000.00 2.020% 0.0001116 181,111.11 2,179,111.11 1,634 4/27/2017 4/27/2022 FA FHLMC 2.625% CALL 4/27 /22 3,500,000.00 3,545,920.00 2.345% 0.0002300 413,455.00 3,959,375.00 1,826 4/27/2017 4/27/2022 FA FHLMC 1.75% QRTLY CALL STEP 1,180,000.00 1,180,000.00 2.62S% 0.0000857 154,875.00 1,334,875.00 1,826 3/13/2019 6/8/2022 FA FHLMC 2.1% CALL 6/8/19 1,800,000.00 1,776,708.00 2.518% 0.0001237 145,617.00 1,922,325.00 1,183 3/9/2018 6/14/2022 FA FHLMC 2.070% CALL 6/14/18 QRTLY 1,000,000.00 980,000.00 2.568% 0.0000696 108,262.50 1,088,262.50 1,558 6/5/2018 6/15/2022 FA FFCB 1.83% CALL 6/11/18 CONT 1,000,000.00 965,500.00 2.740% 0.0000732 108,208.33 1,073,708.33 1,471 6/22/2017 6/22/2022 FA FHLMC 2.00% QRTLY CALL STEP 875,000.00 875,000.00 2.175% 0.0000526 95,156.25 970,156.25 1,826 1/16/2019 6/22/2022 FA FFCB 2.06% CALL 1/23/19 CONT 1,205,000.00 1,180,900.00 2.673% 0.0000873 109,325.63 1,290,225.63 1,253 6/29/2017 6/29/2022 FA FHLMC 2.15% QRTLY CALL 2,500,000.00 2,500,000.00 2.150% 0.0001486 268,750.00 2,768,750.00 1,826 12/19/2017 6/29/2022 FA FHLMC 2.15% QRTLY CALL 1,500,000.00 1,494,000.00 2.243% 0.0000927 152,020.83 1,646,020.83 1,653 1/8/2018 7/1/2022 FA FHLMC 2.22% ONE CALL 7/1/20 1,500,000.00 1,500,000.00 2.220% 0.0000921 149,202.50 1,649,202.50 1,635 7/3/2019 7/1/2022 FA FHLMC 2.0% ONR CALL 7/1/20 2,500,000.00 2,500,000.00 2.000% 0.0001383 149,722.22 2,649,722.22 1,094 4/27/2018 7/18/2022 FA FHLMC 1.75% CALL 7/18/18 QRTLY STEP 1,000,000.00 981,100.00 2.901% 0.0000787 121,837.50 1,102,937.50 1,543 11/3/2017 7/26/2022 FA FFCB 2.15% CALL 1/26/18 CONT 1,400,000.00 1,400,000.00 2.150% 0.0000832 142,389.72 1,542,389.72 1,726 4/17/2018 8/23/2022 FA FFCB 1.670% CALL 4/23/18 CONT 2,000,000.00 1,912,000.00 2.750% 0.0001454 233,290.00 2,145,290.00 1,589 8/28/2019 8/26/2022 FA FFCB 1.85% CALL 8/26/22 1,500,000.00 1,499,565.00 1.860% 0.0000771 83,530.83 1,583,095.83 1,094 12/1/2017 9/9/2022 FA FHLB 2.0% NON-CALL 1,750,000.00 1,739,692.50 2.130% 0.0001025 177,335.28 1,917,027.78 1,743 7/5/2019 9/9/2022 FA FHLB 3.125% BULLET 1,800,000.00 1,874,106.00 1.786% 0.0000926 104,644.00 1,978,750.00 1,162 12/1/2017 9/12/2022 FA FFCB 1.94% CALL 9/12/18 CONT 1,250,000.00 1,236,950.00 2.171% 0.0000743 128,978.47 1,365,928.47 1,746 1/15/2019 9/26/2022 FA FHLB 2.15% CALL 3/26/19 QTLY 1,000,000.00 979,710.00 2.730% 0.0000740 99,780.28 1,079,490.28 1,350 9/28/2017 9/28/2022 FA FNMA 2.0% ONE CALL 9/28/18 2,500,000.00 2,500,000.00 2.000% 0.0001383 249,861.11 2,749,861.11 1,826 4/9/2019 10/4/2022 FA FHLB 2.26% CALL QUARTERLY 1,000,000.00 995,340.00 2.400% 0.0000661 83,383.33 1,078,723.33 1,274 3/9/2018 10/5/2022 FA FNMA 2.0% NON-CALL 1,000,000.00 971,120.00 2.000% 0.0000537 120,324.44 1,091,444.44 1,671 10/5/2018 10/5/2022 FA FNMA 2.0% NON-CALL 1,000,000.00 962,S70.00 3.000% 0.0000799 117,430.00 1,080,000.00 1,461 8/3/2018 10/12/2022 FA FHLB 1.875% CALL 8/9/18 CONT 1,250,000.00 1,199,750.00 2.900% 0.0000962 148,492.19 1,348,242.19 1,531 10/26/2017 10/26/2022 FA FHLMC 2.05% CALL 1/26/18 3,250,000.00 3,250,000.00 2.342% 0.0002105 382,687.50 3,632,687.50 1,826 9/10/2019 12/9/2022 FA FHLB 5.25% BULLET 1,500,000.00 1,670,736.00 1.630% 0.0000753 84,545.25 1,755,281.25 1,186 4/24/2018 12/9/2022 FA FHLB 2.5% NON-CALL 2,250,000.00 2,215,102.50 2.500% 0.0001532 295,053.75 2,510,156.25 1,690 7/5/2019 12/23/2022 FA FHLMC 2.0% CALL 6/23/20 1,500,000.00 1,500,000.00 2.000% 0,0000830 104,416.67 1,604,416.67 1,267 12/27/2017 12/27/2022 FA FH LMC 2.30% CALL 12/27 /19 3,000,000.00 3,000,000.00 2.300% 0.0001908 345,000.00 3,345,000.00 1,826 4/16/2019 1/24/2023 FA FHLMC 2.55% CALL ONE TIME 1/24/20 1,750,000.00 1,750,000.00 2.551% 0,0001234 167,343.7S 1,917,343.75 1,379 3/22/2019 3/10/2023 FA FHLB 2.75% BULLET 2,000,000.00 2,028,220.00 2.375% 0.0001332 189,946.67 2,218,166.67 1,449 5/22/2019 4/28/2023 FA FHLMC 2.625% CALL QUARTERLY 4/28/20 5,000,000.00 5,000,000.00 2.625% 0.0003630 516,250.00 5,516,250.00 1,437 6/4/2018 6/26/2023 FA FHLMC 3.05% CALL 6/26/20 ONE CALL 1,250,000.00 1,250,000.00 3.050% 0.0001054 190,625.00 1,440,625.00 1,848 6/28/2019 6/26/2023 FA FHLMC 2.05% CALL 6/26/20 ONE CALL 3,000,000.00 3,000,000.00 2.050% 0.0001701 246,000.00 3,246,000.00 1,459 7/24/2018 6/29/2023 FA FHLMC 3.10% CALL 6/29/20 ONE CALL 1,000,000.00 1,000,000.00 3.100% 0.0000857 152,847.22 1,152,847.22 1,801 7/30/2018 7/28/2023 FA FHLMC 3.07% CALL 7/28/20 ONE TIME 2,500,000.00 2,500,000.00 3.070% 0.0002123 383,323.61 2,883,323.61 1,824 9/13/2019 8/14/2023 FA FFCB 1.60% BULLET 1,800,000.00 1,796,580.00 1.650% 0.0000820 116,300.00 1,912,880.00 1,431 9/13/2019 8/28/2023 FA FFCB 1.92% CALL 8/28/20 1,000,000.00 997,650.00 1.982% 0,0000547 78,350.00 1,076,000.00 1,445 8/24/2018 8/24/2023 FA FHLB 3.125% CALL8/24/20 ONE TIME 1,750,000.00 1,750,000.00 3.125% 0.0001512 273,437.50 2,023,437.50 1,826 9/18/2018 9/5/2023 FA FFCB 2.8% NON-CALL 1,000,000.00 991,290.00 2.990% 0.0000820 147,698.89 1,138,988.89 1,813 10/10/2018 9/5/2023 FA FFCB 2.8% NON-CALL 2,300,000.00 2,266,190.00 3.125% 0.0001959 349,548.89 2,615,738.89 1,791 9/3/2019 9/8/2023 FA FHLB 2.375% BULLET 2,000,000.00 2,069,108.00 1.485% 0.0000850 121,551.72 2,190,659.72 1,466 2/27/2019 9/12/2023 FA FNMA 2.875% BULLET 1,000,000.00 1,016,210.00 2.495% 0.0000701 114,362.92 1,130,572.92 1,658 4/16/2019 9/12/2023 FA FNMA 2.875% BULLET 1,750,000.00 1,783,757.50 2.410% 0.0001189 187,617.50 1,971,37S.OO 1,610 9/18/2018 9/18/2023 FA FHLB 3.06% CALL 9/18/20 ONE TIME 1,000,000.00 999,250.00 3.076% 0.0000850 153,750.00 1,153,000.00 1,826 9/28/2018 9/28/2023 FA FHLB 3.2% CALL 9/28/20 ONE TIME 1,250,000.00 1,250,000.00 3.200% 0.0001106 200,000.00 1,450,000.00 1,826 Nov. 19, 2019 Item #1 Page 11 of 22 Settled Matures ~ Security Par Cost Return (Yield) Weighted Avg Yield Interest Exgected Return at Maturi:tv Term (Da~sl 10/17/2018 10/2/2023 FA FFCB 3.05% NON-CALL 2,500,000.00 2,493,150.00 3.050% 0.0002103 384,922.92 2,878,072.92 1,811 10/4/2018 10/4/2023 FA FFCB 3.34% CALL 10/04/19 CONT 1,000,000.00 1,000,000.00 3.340% 0.0000924 167,000.00 1,167,000.00 1,826 11/7/2018 10/10/2023 FA FAMCA 3.41% CALL 10/10/19 SEMI ANNUAL 1,150,000.00 1,147,987.50 3.449% 0.0001095 195,146.38 1,343,133.88 1,798 2/7/2019 10/23/2023 FA FFCB 3.0% BULLET 1,000,000.00 1,017,530.00 2.602% 0.0000732 123,803.33 1,141,333.33 1,719 5/9/2019 11/8/2023 FA FFCB 2.3% BULLET 2,000,000.00 2,001,700.00 2.280% 0.0001262 205,172.22 2,206,872.22 1,644 11/19/2018 11/22/2023 FA FAMCA 3.48% CALL 11/22/19 SEMI ANNUAL 2,600,000.00 2,600,000.00 3.480% 0.0002502 451,394.67 3,051,394.67 1,829 11/27/2018 11/27/2023 FA FHLB 3.35% CALL 11/27/20 ONE TIME 1,800,000.00 1,800,000.00 3.350% 0.0001668 301,500.00 2,101,500.00 1,826 6/28/2019 12/5/2023 FA FFCB 2.96% BULLET 1,500,000.00 1,569,280.50 1.870% 0.0000812 127,682.83 1,696,963.33 1,621 12/18/2018 12/18/2023 FA FHLB 3.050% CALL 12/18/19 1,750,000.00 1,750,000.00 3.050% 0.0001476 266,875.00 2,016,875.00 1,826 5/9/2019 12/20/2023 FA FFCB 3.5% BULLET 1,000,000.00 1,052,900.00 3.500% 0.0001019 108,586.11 1,161,486.11 1,686 12/28/2018 12/28/2023 FA FHLB 3.10% CALL 12/28/20 2,000,000.00 2,000,000.00 3.100% 0.0001715 310,000.00 2,310,000.00 1,826 1/22/2019 1/22/2024 FA FFCB 3.01% CALL 1/22/20 CONT 1,750,000.00 1,750,000.00 3.010% 0.0001457 263,375.00 2,013,375.00 1,826 1/29/2019 1/29/2024 FA FHLB 2.875% CALL 1/29/21 ONE TIME 1,500,000.00 . 1,501,125.00 2.859% 0.0001187 214,500.00 1,715,625.00 1,826 1/30/2019 1/30/2024 FA FHLB 3.050% CALL 1/30/20 QTLY 2,500,000.00 2,500,000.00 3.050% 0.0002109 381,250.00 2,881,250.00 1,826 2/26/2019 2/26/2024 FA FHLB 2.8% CALL 2/26/21 ONE TIME 2,500,000.00 2,500,000.00 2.800% 0.0001936 350,000.00 2,850,000.00 1,826 3/6/2019 2/27/2024 FA FFCB 2.61% BULLET 1,500,000.00 1,498,950.00 2.610% 0.0001082 195,821.25 1,694,771.25 1,819 3/8/2019 3/8/2024 FA FHLB 3.25% BULLET 3,000,000.00 3,100,851.00 2.530% 0.0002170 386,649.00 3,487,500.00 1,827 4/9/2019 4/5/2024 FA FFCB 2.3% BULLET 2,000,000.00 1,994,380.00 2.360% 0.0001302 234,725.56 2,229,105.56 1,823 4/9/2019 4/15/2024 FA FHLB 2.45% CALL ANNUALLY ON 4/15 2,000,000.00 2,000,000.00 2.742% 0.0001517 245,000.00 2,245,000.00 1,833 4/11/20i9 4/15/2024 FA FHLMC 2.5% CALL ANNUALLY 4/15/20 1,000,000.00 1,000,000.00 2.791% 0.0000772 112,500.00 1,112,500.00 1,831 4/10/2019 4/15/2024 FA FHLMC 2.5% CALL ANNUALLY 4/15/20 2,000,000.00 2,000,000.00 2.791% 0.0001544 250,000.00 2,250,000.00 1,832 5/9/2019 5/7/2024 FA FHLB 2.4% BULLET 1,000,000.00 1,005,320.00 2.287% 0.0000636 114,546.67 1,119,866.67 1,825 5/9/2019 5/8/2024 FA FHLB 2.73% CONT CALL 11/18/19 3,000,000.00 2,998,800.00 2.739% 0.0002272 410,472.50 3,409,272.50 1,826 5/20/2019 5/20/2024 FA FHLMC 2.7% CALL ANNUALLY 5/20/20 2,500,000.00 2,500,000.00 2.700% 0.0001867 337,500.00 2,837,500.00 1,827 8/28/2019 6/30/2024 FA FFCB 2.16% BULLET 1,470,000.00 1,517,378.10 1.457% 0.0000611 103,884.90 1,621,263.00 1,768 6/26/2019 6/20/2024 FA FHLMC 2.25% CALL 12/20/19 2,790,000.00 2,790,000.00 2.249% 0.0001735 312,480.00 3,102,480.00 1,821 8/28/2019 6/25/2024 FA FFCB 2.45% BULLET 1,183,000.00 1,237,524.47 1.457% 0.0000499 85,320.92 1,322,845.39 1,763 7/30/2019 6/26/2024 FA FHLMC 2.375% CALL 6/26/20 2,000,000.00 2,004,000.00 2.150% 0.0001192 229,013.89 2,233,013.89 1,793 7/2/2019 7/2/2024 FA FHLMC 2.0% CALL QUARTERLY 2,500,000.00 2,500;000.00 2.000% 0.0001383 250,000.00 2,750,000.00 1,827 6/27/2019 7/15/2024 FA PEFCO 2.45% BULLET 2,500,000.00 2,565,850.00 1.900% 0.0001348 243,292.36 2,809,142.36 1,845 8/8/2019 7/26/2024 FA FFCB 1.85% BULLET 2,500,000.00 2,532,125.00 1.582% 0.0001108 197,583.33 2,729,708.33 1,814 9/3/2019 9/3/2024 FA FFCB 2.0% CALL 9/3/20 4,000,000.00 4,000,000.00 2.000% 0.0002212 400,000.00 4,400,000.00 1,827 8/30/2019 9/10/2024 FA FFCB 2.08% BULLET 2,500,000.00 2,572,420.00 1.480% 0.0001053 189,024.44 2,761,444.44 1,838 9/23/2019 9/23/2024 FA FHLMC 2.1% CALL 9/23/20 QTR 1,000,000.00 1,000,000.00 2.100% 0.0000581 10,500.00 1,010,500.00 1,827 SUB-TOTAL FA 360,511,000.00 361,589,019.12 2.045% 30,117,801.67 391,706,820.79 1,457 3/3/2015 10/9/2019 FN FNMA 0% NON-CALL 2,000,000.00 1,825,044.00 2.000% 0.0047765 174,956.00 2,000,000.00 1,681 11/7/2016 10/9/2019 FN FNMA 0% NON-CALL 2,200,000.00 2,115,792.80 1.340% 0.0037101 84,207.20 2,200,000.00 1,066 1/27/2017 10/9/2019 FN FNMA 0% NON-CALL 1,000,000.00 950,223.00 1.900% 0.0023626 49,777.00 1,000,000.00 985 10/23/2015 10/15/2020 FN RFCSP 0% NON-CALL 3,000,000.00 2,750,760.00 1.750% 0.0062993 249,240.00 3,000,000.00 1,819 SUB-TOTAL 8,200,000.00 7,641,819.80 1.7148% 558,180.20 8,200,000.00 1,388 Federal Investments Total 368,711,000.00 369,230,838.92 30,675,981.87 399,906,820.79 1,456 8/3/2017 8/10/2020 SN IBRD 1.125% NON-CALL 2,000,000.00 1,972,100.00 1.600% 0.0014652 95,837.50 2,067,937.50 1,103 11/8/2018 9/4/2020 SN IBRD 1.625% NON-CALL 1,100,000.00 1,074,711.00 2.930% 0.0014622 57,859.27 1,132,570.27 666 1/8/2018 10/5/2020 SN IBRD 1.625% ONE CALL4/5/19 STEP 1,500,000.00 1,486,500.00 2.164% 0.0014938 88,765.62 1,575,265.62 1,001 1/8/2018 1/18/2022 SN IADB 2.125% NON-CALL 2,000,000.00 1,988,880.00 2.270% 0.0020965 182,300.56 2,171,180.56 1,471 Nov. 19, 2019 Item #1 Page 12 of 22 Settled Matures ~ Security Par Cost Return (Yield} Weighted Avg Yield Interest Exgected Return at Maturity Term (Da¥sl 12/18/2017 1/26/2022 SN IBRD 2.00% NON-CALL 2,500,000.00 2,485,325.00 2.150% 0.0024813 219,952.78 2,705,277.78 1,500 10/10/2017 10/7/2022 SN IBRD 1.875% NON-CALL 1,300,000.00 1,290,907.89 2.024% 0.0012133 130;763.88 1,421,671.77 1,823 2/8/2019 10/24/2022 SN IFC 2.0% BULLET 1,500,000.00 1,470,780.00 2.553% 0.0002140 140,553.33 1,611,333.33 1,354 5/9/2019 10/24/2023 SN IADB 3.0% BULLET 2,000,000.00 2,058,280.00 2.300% 0.0002699 205,886.67 2,264,166.67 1,629 1/18/2018 1/18/2023 SN IADB 2.50% NON-CALL 1,700,000.00 1,702,652.00 2.467% 0.0019505 209,848.00 1,912,500.00 1,826 1/24/2018 1/18/2023 SN IADB 2.50% NON-CALL 1,000,000.00 997,670.00 2.550% 0.0011814 126,913.33 1,124,583.33 1,820 2/15/2019 2/15/2024 SN QTLYIBRD 2.625% {STEP) CALL 2/15/21 3,000,000.00 3,000,000.00 2.625% 0.0036569 468,750.00 3,468,750.00 1,826 8/29/2019 8/28/2024 SN IBRD 1.5% BULLET 2,000,000.00 2,006,920.00 1.428% 0.0013308 142,996.67 2,149,916.67 1,826 Supranational Investment Total 21,600,000.00 21,534,725.89 1.882% 2,070,427.61 23,605,153.50 1,487 12/22/2016 2/29/2020 TR US TREASURY 1.375% 2,200,000.00 2,184,531.25 1.602% 0.0004454 111,901.07 2,296,432.32 1,164 I 1/10/2017 2/29/2020 TR US TREASURY 1.375% 1,400,000.00 1,395,520.00 1.480% 0.0002628 64,835.66 1,460,355.66 1,145 5/24/2016 4/30/2020 TR US TREASURY 1.375% 2,300,000.00 2,315,093.75 1.204% 0.0003547 109,343.75 2,424,437.50 1,437 12/19/2016 6/30/2020 TR US TREASURY 1.625% 1,350,000.00 1,345,570.31 1.721% 0.0002947 81,926.29 1,427,496.60 1,289 12/2/2016 7/31/2020 TR US TREASURY 1.625% 1,500,000.00 1,500,000.00 1.625% 0.0003102 89,286.68 1,589,286.68 1,337 6/7/2017 7/31/2020 TR US TREASURY 1.625% 2,000,000.00 2,011,320.00 1.440% 0.0003686 91,028.07 2,102,348.07 1,150 9/22/2015 8/31/2020 TR US TREASURY 2.125% 3,000,000.00 3,085,500.00 2.097% 0.0008234 229,396.98 3,314,896.98 1,805 10/28/2016 10/31/2020 TR US TREASURY 1.375% 1,750,000.00 1,759,570.31 1.235% 0.0002766 86,875.85 1,846,446.16 1,464 12/2/2016 10/31/2020 TR US TREASURY 1.375% 1,200,000.00 1,186,200.00 1.680% 0.0002536 78,341.44 1,264,541.44 1,429 1/13/2017 10/31/2020 TR US TREASURY 1.375% 1,300,000.00 1,289,234.38 1.601% 0.0002627 78,611.61 1,367,845.99 1,387 1/5/2016 12/31/2020 TR US TREASURY 2.375% 4,000,000.00 4,127,500.00 1.705% 0.0008956 346,195.00 4,473,695.00 1,822 5/5/2016 12/31/2020 TR US TREASURY 1.75% 2,000,000.00 2,049,174.00 1.205% 0.0003142 113,710.62 2,162,884.62 1,701 1/20/2017 2/28/2021 TR US TREASURY 1.125% 2,750,000.00 2,673,515.63 1.831% 0.0006230 203,567.42 2,877,083.05 1,500 2/17/2017 2/28/2021 TR US TREASURY 1.125% 1,225,000.00 1,194,853.52 1.760% 0.0002676 85,690.25 1,280,543.77 1,472 5/9/2017 3/31/2021 TR US TREASURY 1.25% 1,400,000.00 1,374,786.00 1.730% 0.0003027 93,349.25 1,468,135.25 1,422 8/19/2016 4/30/2021 TR US TREASURY 1.375% 3,000,000.00 3,037,662.00 1.100% 0.0004252 156,145.74 3,193,807.74 1,715 12/16/2016 5/31/2021 TR US TREASURY 2.000% 2,250,000.00 2,250,000.00 2.000% 0.0005727 200,521.98 2,450,521.98 1,627 10/28/2016 6/30/2021 TR US TREASURY 1.125% 2,500,000.00 2,477,400.00 1.325% 0.0004177 154,053.80 2,631,453.80 1,706 12/16/2016 6/30/2021 TR US TREASURY 1.125% 2,650,000.00 2,547,312.50 2.022% 0.0006555 238,058.93 2,785,371.43 1,657 1/20/2017 7/31/2021 TR US TREASURY 1.125% 1,500,000.00 1,448,203.13 1.925% 0.0003548 145,113.79 1,593,316.92 1,653 2/20/2018 8/31/2021 TR US TREASURY 1.125% 2,000,000.00 1,911,080.00 2.450% 0.0005959 168,167.24 2,079,247.24 1,288 12/2/2016 9/30/2021 TR US TREASURY 2.125% 1,600,000.00 1,615,500.00 1.913% 0.0003933 148,615.38 1,764,115.38 1,763 3/10/2017 9/30/2021 TR US TREASURY 1.125% 1,200,000.00 1,150,500.00 2.078% 0.0003043 111,028.85 1,261,528.85 1,665 5/19/2017 9/30/2021 TR US TREASURY 1.125% 1,500,000.00 1,464,375.00 1.691% 0.0003151 109,303.28 1,573,678.28 1,595 2/14/2018 9/30/2021 TR US TREASURY 2.125% 1,500,000.00 1,486,406.25 2.387% 0.0004515 129,096.84 1,615,503.09 1,324 11/17/2016 10/31/2021 TR US TREASURY 2.00% 2,000,000.00 2,030,000.00 1.683% 0.0004348 168,121.55 2,198,121.55 1,809 11/18/2016 10/31/2021 TR US TREASURY 2.00% 2,000,000.00 2,028,360.00 1.700% 0.0004388 169,651.15 2,198,011.15 1,808 11/22/2016 11/15/2021 TR US TREASURY 2.00% 2,000,000.00 2,016,562.50 1.825% 0.0004684 182,664.02 2,199,226.52 1,819 1/6/2017 12/31/2021 TR US TREASURY 2.125% 4,000,000.00 4,052,128.00 1.850% 0.0009540 371,463.16 4,423,591.16 1,820 2/3/2017 12/31/2021 TR US TREASURY 2.125% 1,850,000.00 1,867,632.81 1.920% 0.0004563 175,237.36 2,042,870.17 1,792 1/20/2017 1/31/2022 TR US TREASURY 1.50% 3,000,000.00 2,928,555.00 2.000% 0.0007454 297,790.11 3,226,345.11 1,837 4/23/2019 2/28/2022 TR US TREASURY 1.875% 1,500,000.00 1,481,015.63 1.875% 0.0003534 99,232.33 1,580,247.96 1,042 3/2/2017 3/31/2022 TR US TREASURY 1.750% 3,000,000.00 2,963,925.00 2.000% 0.0007544 302,757.69 3,266,682.69 1,855 5/15/2017 5/15/2022 TR US TREASURY 1.750% 2,000,000.00 1,985,625.00 1.901% 0.0004804 189,375.00 2,175,000.00 1,826 8/25/2017 7/31/2022 TR US TREASURY 1.875% 1,250,000.00 1,257,346.25 1.750% 0.0002800 108,249.03 1,365,595.28 1,801 8/31/2017 8/31/2022 TR US TREASURY 1.875% 3,000,000.00 3,019,290.00 1.740% 0.0006686 261,960.0Q 3,281,250.00 1,826 11/28/2017 11/15/2022 TR US TREASURY 1.625% 1,000,000.00 980,950.00 2.030% 0.0002534 99,716.44 1,080,666.44 1,813 7/30/2019 2/28/2023 TR US TREASURY 2.625% 3,000,000.00 3,085,572.00 1.800% 0.0007068 275,650.83 3,361,222.83 1,309 Nov. 19, 2019 Item #1 Page 13 of 22 Settled Matures ~ Security Par Cost Return {Yield) Weighted Avg Yield Interest Expected Return at Maturity Term (Days) SUB-TOTAL TR 78,675,000.00 78,577,770.22 1.754% 6,126,034.44 84,703,804.66 1,576 11/18/2014 11/15/2019 CN CHEVRON CORP 2.193% 3,000,000.00 3,017,400.00 2.070% 0,0003560 311,001.75 3,328,401.75 1,823 12/22/2015 11/15/2019 CN CHEVRON CORP 2.193% 2,800,000.00 2,811,200.00 2.083% 0.0003338 228,105.03 3,039,305.03 1,424 12/13/2017 11/15/2019 CN CHEVRON CORP 2.193% 2,500,000.00 2,512,725.00 1.190% 0.0001704 92,660.83 2,605,385.83 702 4/20/2016 12/5/2019 CN JOHNSON & JOHNSON 1.875% 2,250,000.00 2,315,250.00 1.057% 0,0001395 87,679.69 2,402,929.69 1,324 1/17/2018 12/6/2019 CN WELLS FARGO BANK 2.15% 2,500,000.00 2,499,750.00 2.155% 0.0003071 101,628.47 2,601,378.47 688 4/9/2015 2/11/2020 CN NY LIFE GOLBAL 1.95% NON-CALL 2,000,000.00 2,017,520.00 1.760% 0.0002024 171,196.67 2,188,716.67 1,769 1/20/2017 2/11/2020 CN NY LIFE GOLBAL 1.95% NON-CALL 2,000,000,00 2,000,000.00 1.950% 0.0002223 119,275.00 2,119,275.00 1,117 9/25/2015 3/3/2020 CN CHEVRON 1.961% 2,800,000.00 2,790,704.00 2.039% 0.0003244 253,026.51 3,043,730.51 1,621 11/4/2015 3/6/2020 CN EXXON MOBIL 1.912% 5,000,000.00 5,057,700.00 1.630% 0.0004699 I 357,097,78 5,414,797.78 1,584 11/3/2015 5/6/2020 CN APPLE 2.0% 4,000,000.00 4,028,000.00 1.837% 0.0004218 332,666.66 4,360,666.66 1,646 5/24/2016 5/15/2020 CN IBM 1.625% 1,500,000.00 1,503,000.00 1.573% 0.0001348 93,890.62 1,596,890.62 1,452 11/3/2015 8/7/2020 CN 3M COMPANY 2.0% CALL 3,500,000.00 3,554,215.00 1.660% 0.0003363 279,062.78 3,833,277.78 1,739 9/25/2015 9/1/2020 CN JOHNSON & JOHNSON 2.95% 1,000,000.00 1,058,028.49 1.718% 0.0001036 87,504.84 1,145,533.33 1,803 9/24/2015 9/15/2020 CN AUTOMATIC DATA PROCESSING 2.25% 4,000,000.00 4,029,600.00 2.090% 0.0004801 418,150.00 4,447,750.00 1,818 11/10/2015 11/3/2020 CN MICROSOFT 2.00% CALL 5,000,000.00 S,018,550.00 1.920% 0.0005493 479,505.56 5,498,055.56 1,820 6/10/2016 11/3/2020 CN MICROSOFT 2.00% CALL 1,500,000.00 1,S39,450.00 1.370% 0.0001202 92,466.67 1,631,916.67 1,607 11/13/2017 11/13/2020 CN APPLE INC 2.0% 2,500,000.00 2,497,900.00 2.000% 0.0002848 152,100.00 2,650,000.00 1,096 1/7/2019 12/15/2020 CN WALMARTl.9% 1,500,000.00 1,481,805.00 2.545% 0.0002150 73,453.33 1,555,258.33 708 6/29/2017 12/29/2020 CN TOYOTA 2.0% CALL 6/29/20 3,000,000.00 3,000,000.00 2.000% 0.0003420 210,000.00 3,210,000.00 1,279 2/26/2018 1/15/2021 CN WELLS FARGO BANK 2.6% NON-CALL 2,000,000.00 1,982,700.00 2.914% 0.0003293 167,377.77 2,lS0,077.77 1,054 4/28/2016 3/1/2021 CN EXXON MOBIL 2.222% 2,000,000.00 2,042,900.00 1.750% 0,0002038 172,263.67 2,215,163.67 1,768 7/26/2016 3/1/2021 CN EXXON MOBIL 2.222% 1,000,000.00 1,034,050.00 1.440% 0.0000849 68,038.55 1,102,088.55 1,679 9/16/2016 4/8/2021 CN TOYOTA 1.90% 3,000,000.00 3,031,680.00 1.659% 0.0002867 228,303.33 3,259,983.33 1,665 6/13/2018 5/16/2021 CN CHEVRON 2.1% 3,250,000.00 3,175,770.00 2.920% 0.0005286 273,861.25 3,449,631.25 1,068 5/26/2016 5/19/2021 CN ALPHABET, INC 3.625% 1,000,000.00 1,094,000.00 1.651% 0.0001030 86,545.14 1,180,545.14 1,819 4/17/2017 5/19/2021 CN ALPHABET, INC 3.625% 2,000,000.00 2,136,700.00 1.883% 0,0002293 159,744.44 2,296,444.44 1,493 5/14/2017 5/19/2021 CN ALPHABET, INC 3.625% 2,000,000.00 2,133,400.00 1.900% 0.0002311 159,620.83 2,293,020.83 1,466 9/13/2016 8/8/2021 CN MICROSOFT 1.55% 6,000,000.00 5,995,740.00 1.565% 0.0005349 460,218.33 6,45S,958.33 1,790 2/7/2017 8/8/2021 CN MICROSOFT 1.55% 2,000,000.00 1,947,120.00 2.170% 0.0002408 192,466.11 2,139,586.11 1,643 2/22/2018 8/8/2021 CN MICROSOFT 1.55% 1,500,000.00 1,441,912.50 2.730% 0.0002244 138,558.33 1,580,470.83 1,263 10/14/2016 9/1/2021 CN COCA COLA 1.55% 3,600,000.00 3,581,496.00 1.660% 0.0003389 290,839.00 3,872,335.00 1,783 1/10/2018 9/1/2021 CN COCA COLA 3.30% 1,500,000.00 1,549,740.00 2.344% 0.0002071 130,522.50 1,680,262.50 1,330 11/7/2016 11/1/2021 CN IBM 2.90% 1,000,000.00 1,052,600.00 1.792% 0.0001075 91,916.67 1,144,S16.67 1,820 10/10/2017 11/3/2021 CN PROCTER & GAMBLE 1.7% NON-CALL 2,000,000.00 1,982,100.00 1.930% 0.0002181 156,072.22 2,138,172.22 1,485 12/4/2017 11/15/2021 CN COLGATE PALMOLIVE 2.450% 2,250,000.00 2,271,141.00 2.200% 0.0002848 196,449.62 2,467,590.62 1,442 12/20/2017 2/6/2022 CN MICROSOFT 2.4% 1,250,000.00 1,254,025.00 2.316% 0.0001656 119,808.33 1,373,833.33 1,509 3/7/2019 3/3/2022 CN JOHNSON & JOHNSON 2.25% CALL 2/3/22 1,250,000.00 1,236,787.50 2.620% 0.0001847 97,275.00 1,334,062.50 1,092 3/6/2017 3/6/2022 CN EXXON MOBLIE 2.397% 2,000,000.00 2,003,380.00 2.360% 0.0002695 236,320.00 2,239,700.00 1,826 5/23/2017 5/11/2022 CN APPLE INC 2.3% 3,300,000.00 3,318,150.00 2.181% 0,0004125 358,820.00 3,676,970.00 1,814 12/6/2017 5/15/2022 CN BERKSHIRE HATHAWAY 3.0% 1,503,000.00 1,540,770.39 2.400% 0.0002108 162,504.36 1,703,274.75 1,621 1/8/2018 5/15/2022 CN BERKSHIRE HATHAWAY 3.0% 1,000,000.00 1,023,300.00 2.432% 0.0001419 107,283.33 1,130,583.33 1,588 10/9/2018 5/15/2022 CN BERKSHIRE HATHAWAY 3.0% 1,100,000.00 1,091,810.50 3.220% 0.0002004 126,989.50 1,218,800.00 1,314 2/19/2019 5/17/2022 CN TOYOTA 3.083% BULLET 2,000,000.00 2,000,000.00 3.083% 0.0003515 200,044.66 2,200,044.66 1,183 8/9/2018 6/1/2022 CN BLACKROCK 3.375% 1,000,000.00 1,011,600.00 3.050% 0.0001759 117,306.25 1,128,906.25 1,392 8/24/2017 7/13/2022 CN TOYOTA2.8% 1,500,000.00 1,547,160.00 2.119% 0.0001869 158,056.67 1,705,216.67 1,784 Nov. 19, 2019 Item #1 Page 14 of 22 Settled .M.i!!l!ru !YM . Security Par ~ Return (Yield) Weighted Avg Yield Interest Exg~g~Q Return at Maturity: Term (Days) 1/16/2019 7/13/2022 CN TOYOTA2.8% 1,500,000.00 1,483,770.00 3.129% 0.0002646 162,880.00 1,646,650.00 1,274 7/1/2019 7/13/2022 CN TOYOTA2.8% 2,500,000.00 2,551,875.00 2.090% 0.0003040 160,458.33 2,712,333.33 1,108 11/6/2017 8/11/2022 CN PROCTER & GAMBLE 2.15% 1,800,000.00 1,799,161.20 2.160% 0.0002215 185,201.30 1,984,362.50 1,739 11/9/2018 8/11/2022 CN PROCTER & GAMBLE 2.15% 1,900,000.00 1,826,627.70 3.250% 0.0003384 226,786.74 2,053,414.44 1,371 5/2/2019 8/11/2022 CN PROCTER & GAMBLE 2.15% BULLET 2,000,000.00 1,986,800.00 2.150% 0.0002435 154,025.00 2,140,825.00 1,197 1/18/2018 9/21/2022 CN NOVARTIS CAPITAL CORP 2.4% 1,500,000.00 1,489,500.00 2.560% 0,0002174 178,400.00 1,667,900.00 1,707 1/4/2018 11/15/2022 CN COLGATE-PALMOLIVE 2.25% 2,000,000.00 1,982,400.00 2.443% 0.0002761 236,475.00 2,218,875.00 1,776 9/17/2018 11/15/2022 CN COLGATE-PALMOLIVE 2.25% 2,000,000.00 1,935,820.00 3.077% 0.0003395 251,430.00 2,187,250.00 1,520 12/6/2017 11/29/2022 CN TOYOTA 2.125% NON-CALL 2,250,000.00 2,250,000.00 2.125% 0.0002725 238,132.81 2,488,132.81 1,819 1/14/2019 12/15/2022 CN WALMART 2.35% 2,720,000.00 2,653,088.00 3.020% 0.0004567 317,442.89 2,970,530.89 1,431 1/24/2018 1/26/2023 CN TOYOTA 2.75% NON-CALL 3,000,000.00 3,000,000.00 2.750% 0.0004703 412,500.00 3,412,500.00 1,828 8/29/2019 2/1/2023 CN COLGATE PALMOLIVE 1.95% BULLET 1,000,000.00 1,011,600.00 1.600% 0.0000923 55,133.33 1,066,733.33 1,252 9/12/2019 2/11/2023 CN BERKSHIRE HATHAWAY 3.0% BULLET 1,250,000.00 1,296,137.50 1.878% 0,0001388 81,883.33 1,378,020.83 1,248 7/31/2019 2/23/2023 CN APPLE INC 2.85% 2/23/22 3,500,000.00 3,592,680.00 2.039% 0.0004176 262,540.83 3,855,220.83 1,303 3/20/2018 3/15/2023 CN BERKSHIRE HATHAWAY 2.75% 1,000,000.00 983,890.00 3.101% 0.0001739 153,228.06 1,137,118.06 1,821 4/18/2018 3/15/2023 CN BERKSHIRE .HATHAWAY 2.75% 1,750,000.00 1,719,130.00 3.140% 0.0003077 267,083.54 1,986,213.54 1,792 4/25/2018 3/15/2023 CN BERKSHIRE HATHAWAY 2.75% 2,000,000.00 1,953,300.00 3.270% 0.0003641 315,588.89' 2,268,888.89 1,785 5/7/2018 4/11/2023 CN WALMART 2.55% CALL 1/11/23 1,000,000.00 974,100.00 3.121% 0.0001733 151,558.33 1,125,658.33 1,800 12/18/2018 4/11/2023 CN WALMART 2.55% CALL 1/11/23 1,000,000.00 969,800.00 3.301% 0.0001825 141,054.17 1,110,854.17 1,575 5/16/2019 4/28/2023 CN BANK OF NY MELLON 3.5% BULLET 2,000,000.00 2,061,800.00 2.670% 0.0003138 214,700.00 2,276,500.00 1,443 5/2/2018 5/1/2023 CN COLGATE-PALMOLIVE 2.10% 4,666,000.00 4,443,179.84 3.140% 0.0007953 712,477.98 5,155,657.82 1,825 5/9/2018 5/3/2023 CN APPLE INC 2.4% 4,000,000.00 3,862,600.00 3.150% 0.0006936 615,800.00 4,478,400.00 1,820 8/6/2016 6/26/2023 CN WALMART 3.4% 1,750,000.00 1,763,895.00 3.220% 0.0003238 276,993.89 2,040,888.89 2,515 7/25/2018 6/26/2023 CN WALMART 3.40% 1,500,000.00 1,512,000.00 3.220% 0.0002775 238,891.66 1,750,891.66 1,797 2/19/2019 6/26/2023 CN WALMART 3.40% CALL 5/26/23 1,000,000.00 1,025,140.00 2.770% 0.0001619 122,665.56 1,147,805.56 1,588 7/24/2018 7/24/2023 CN US BANK 3.4% CALL 6/23/23 ONE TIME 1,250,000.00 1,251,625.00 3.371% 0.0002405 210,756.94 1,462,381.94 1,826 1/24/2019 7/24/2023 CN US BANK NA CINCINNATI 3.4% CALL 6/23/23 1,000,000.00 1,010,000.00 3.156% 0.0001817 143,000.00 1,153,000.00 1,642 2/28/2019 7/24/2023 CN US BANK NA CINCINNATI 3.4% CALL 6/23/23 1,800,000.00 1,835,100.00 2.916% 0.0003050 234,520.00 2,D69,620.00 1,607 12/11/2018 7/24/2023 CN US BANK NA CINCINNATI 3.4% CALL 6/23/23 2,500,000.00 2,489,250.00 3.400% 0.0004824 32,347.22 2,521,597.22 1,686 2/28/2019 8/14/2023 CN WELLS FARGO BANK 3.55% CALL 7/14/23 2,000,000.00 2,040,700.00 3.050% 0,0003548 276,038.89 2,316,738.89 1,628 10/1/2018 8/14/2023 CN WELLS FARGO BANK 3.55% 1,500,000.00 1,500,000.00 3.550% 0.0003035 259,297.92 1,759,297.92 1,778 1/28/2019 12/5/2023 CN JOHNSON & JOHNSON 3.375% NON CALL 1,500,000.00 1,541,250.00 2.765% 0,0002429 204,421.87 1,745,671.87 1,772 3/7/2019 1/8/2024 CN TOYOTA MOTOR CREDIT 3.35% BULLET 1,000,000.00 1,017,865.00 2.950% 0.0001712 144,144.72 1,162,009.72 1,768 5/16/2019 1/23/2024 CN CITIBANK NA 3.65% 1,000,000.00 1,034,870.00 2.836% 0.0001673 136,173.06 1,171,043.06 1,713 8/29/2019 3/18/2024 CN BLACKROCK 3.5% BULLET 2,000,000.00 2,162,500.00 1.640% 0.0002022 156,194.44 2,318,694.44 1,663 7/31/2019 5/13/2024 CN JP MORGAN CHASE 3.625% BULLET 2,000,000.00 2,119,320.00 2.300% 0.0028234 227,471.67 2,346,791.67 1,748 8/22/2019 8/22/2024 CN AMAZON.COM INC 2.8% 6/22/24 2,000,000.00 2,087,280.00 2.800% 0.0033852 192,097.78 2,279,377.78 1,827 SUB-TOTAL CN 174,489,000.00 175,430,884.62 2.865% 16,947,474.20 192,378,358.82 1,557 10/8/2014 10/8/2019 CD CAPITAL ONE ABANK USA 2.10% 247,000.00 247,000.00 2.100% 0.0003004 25,935.00 272,935.00 1,826 10/10/2014 10/10/2019 CD GE CAPITAL BANK 2.0% 247,000.00 245,641.50 2.000% 0.0002846 26,058.50 271,700.00 1,826 10/29/2014 10/29/2019 CD PEOPLES UTD BANK CT 1.9% 247,000.00 247,000.00 1.900% 0.0002718 23,465.00 270,465.00 1,826 11/3/2014 11/4/2019 CD WEBSTER BANK NAT'L ASSOC 1.9% 247,000.00 247,000.00 1.900% 0.0002718 23,465.00 270,465.00 1,827 12/3/2014 12/3/2019 CD CIT BANK SALT LAKE CITY 2.2% 247,000.00 247,000.00 2.200% 0.0003148 27,170.00 274,170.00 1,826 12/4/2014 12/4/2019 CD AMERICAN EXPRESS CENTURION 2.2% 247,000.00 247,000.00 2.200% 0.0003148 27,170.00 274,170.00 1,826 12/10/2014 12/10/2019 CD BMW BANK OF N AMERICA 2.15% 247,000.00 247,000.00 2.150% 0.0003076 26,552.50 273,552.50 1,826 12/23/2014 12/10/2019 CD SALLIE MAE BANK SALT LAKE 2.2% 247,000.00 247,000.00 2.200% 0.0003148 26,976.46 273,976.46 1,813 Nov. 19, 2019 Item #1 Page 15 of 22 Settled Matures ~ Security Par ~ Return {Yield) Weighted Avg Yield Interest Exgected Return at Maturity: T~rm {Days) 12/21/2017 12/23/2019 CD MORGAN STANLEY BANK 2.1% 247,000.00 247,000.00 .2.100% 0.0003004 10,402.82 257,402.82 732 1/23/2015 1/23/2020 CD PRIVATE BANK & TRUST 1.90% 247,000.00 247,000.00 1.900% 0.0002718 23,465.00 270,465.00 1,826 7/24/2015 1/24/2020 CD EAGLE BANK 1.80% 249,000.00 249,000.00 1.800% 0.0002596 20,169.00 269,169.00 1,645 1/27/2015 1/27/2020 CD NORTHFIELD BANK 1.65% 249,000.00 249,000.00 1.650% 0.0002380 20,542.50 269,542.50 1,826 1/26/2018 1/27/2020 CD FLAGSTAR BANK 2.15% 247,000.00 247,000.00 2.150% 0.0003076 10,635.7S 257,635.75 731 1/30/2015 1/30/2020 CD BANK OF GEORGETOWN 1.65% 249,000.00 249,000.00 1.650% 0.0002380 20,S42.50 269,542.50 1,826 2/6/2015 2/6/2020 CD MACHIAS SAVINGS BANK 1.65% 247,000.00 247,000.00 1.650% 0.0002361 20,377.50 267,377.50 1,826 3/3/2015 2/26/2020 CD THIRD FEDERAL SAVING & LOAN 1.75% 247,000.00 246,407.20 1.754% 0.0002503 22,146.09 268,553.29 1,821 4/22/2015 4/22/2020 CD MARLIN BUSINESS BANK SALT LAKE 1.6% 247,000.00 247,000.00 1.600% 0.0002289 19,760.00 266,760.00 1,827 5/13/2015 5/13/2020 CD WORLD FOREMOST BANK SYDNEY 2.00% 200,000.00 200,000.00 2.000% 0.0002317 20,000.00 220,000.00 1,827 6/29/2015 6/29/2020 CD FIRST SOURCE BANK 1.85% 247,000.00 246,382.50 1.904% 0.0002717 23,465.00 269,847.50 1,827 7/31/2015 7/31/2020 CD INSTITUTION FOR SAVINGS 2.05% 249,000.00 249,000.00 2.050% 0.0002957 25,522.50 274,522.50 1,827 8/2/2017 8/3/2020 CD WEX BANK 1.85% 247,000.00 247,000.00 1.850% 0.0002647 13,721.19 260,72i.19 1,097 8/11/2015 8/25/2020 CD INVESTOR BANK 2.0% 247,000.00 247,000.00 2.000% 0.0002861 24,700.00 271,700.00 1,841 9/10/2015 9/10/2020 CD MERRICK BANK 1.85% 249,000.00 248,377.50 1.910% 0.0002748 23,655.00 272,032.50 1,827 9/22/2015 9/16/2020 CD BARCLAYS BANK 2.2% 248,000.00 248,000.00 2.200% 0.0003160 27,190.31 275,190.31 1,821 10/19/2015 10/13/2020 CD COMENITY CAP BANK 2.0% 249,000.00 249,000.00 2.000% 0.0002885 24,818.14 273,818.14 1,821 12/14/2017 12/14/2020 CD ALLY BANK 2.10% 247,000.00 247,000.00 2.100% 0.0003004 15,561.00 262,561.00 1,096 1/15/2016 1/15/2021 CD INVESTORS CMNTY BANK 1.85% 249,000.00 249,000.00 1.850% 0.0002668 23,032.50 272,032.50 1,827 5/9/2018 5/10/2021 CD CONNECTONE BANK 2.85% 249,000.00 249,000.00 2.850% 0.0004111 21,309.21 270,309.21 1,097 6/10/2016 6/7/2021 CD UBS BANK USA SALT LAKE CITY 1.65% 249,000.00 249,000.00 1.650% 0.0002380 20,508.73 269,508.73 1,823 6/21/2018 6/21/2021 CD MERCANTIL BANK 3.0% 246,000.00 246,000.00 3.000% 0.0004275 22,140.00 268,140.00 1,096 6/22/2017 6/22/2021 CD LAKESIDE BANK 1.90% 249,000.00 249,000.00 1.900% 0.0002740 18,924.00 267,924.00 1,461 6/23/2016 6/23/2021 CD EAST BOSTON SAVING BANK 1.5% 248,000.00 248,000.00 1.500% 0.0002155 18,600.00 .266,600.00 1,826 6/24/2016 6/24/2021 CD FIRST BUSINESS BK MADISON 1.5% 248,000.00 248,000.00 1.500% 0.0002155 18,600.00 266,600.00 1,826 6/30/2016 6/30/2021 CD FIRST TECHNOLOGY FEDERAL 1.75% 248,000.00 248,000.00 1.750% 0.0002514 21,700.00 269,700.00 1,826 9/21/2017 9/21/2021 CD PINACLE BANK TN 2.00% 249,000.00 249,000.00 2.000% 0.0002885 19,920.00 268,920.00 1,461 1/12/2018 1/12/2022 CD LCA BANK CORPORATION 2.3% 246,000.00 246,000.00 2.300% 0.0003277 22,632.00 268,632.00 1,461 1/18/2017 1/18/2022 CD MB FINANCIAL BANK 2.050% 249,000.00 249,000.00 2.050% 0.0002957 25,522.50 274,522.50 1,826 1/20/2017 1/20/2022 CD FIRST NATL BANKO AMERICA 2.05% 249,000.00 249,000.00 2.050% 0.0002957 25,522.50 274,522.50 1,826 1/24/2019 1/24/2022 CD DOLLAR BANK 2.85% BULLET 246,000.00 246,000.00 2.850% 0.0004061 21,033.00 267,033.00 1,096 6/7/2017 6/7/2022 CD MECHANTILE BANK OF MICHIGAN 2.10% 247,000.00 247,000.00 2.100% 0.0003004 25,935.00 272,935.00 1,826 7/31/2017 7/29/2022 CD KS STATE BANK 2.1% 245,000.00 245,000.00 2.100% 0.0002980 25,710.71 270,710.71 1,824 8/16/2017 8/16/2022 CD EVER BANK 2.2% 247,000.00 247,000.00 2.200% 0.0003148 27,170.00 274,170.00 1,826 8/30/2017 8/30/2022 CD WILLAMETTE VALLEY BANK 2.1% 249,000.00 249,000.00 2.100% 0.0003029 26,145.00 275,145.00 1,826 9/29/2017 9/29/2022 CD ALLEGIANE BANK TEXS 2.15% 249,000.00 249,000.00 2.150% 0.0003101 26,767.50 275,767.50 1,826 9/14/2017 9/14/2022 CD FIRST BANK OF HIGHLAND 2.15% 247,000.00 247,000.00 2.150% 0.0003076 26,552.50 273,552.50 1,826 10/18/2017 10/18/2022 CD BENEFICIAL BANK 2.15% NON-CALL 247,000.00 247,000.00 2.150% 0.0003076 26,552.50 273,552.50 1,826 12/22/2017 12/22/2022 CD INDUSTRIAL & COML BAK CHINA 2.5% 249,000.00 249,000.00 2.500% 0.0003606 31,125.00 280,125.00 1,826 1/11/2019 1/11/2023 CD STERLING BANK 3.10% BULLET 246,000.00 246,000.00 3.100% 0.0004417 30,S04.00 276,504.00 1,461 1/29/2018 1/30/2023 CD SUNTRUST BANK 2.30% CALL 1/30/20 STEP 246,000.00 245,508.00 2.792% 0.0003970 "34,547.50 280,055.50 1,827 4/24/2018 4/24/2023 CD CITIBANK 3.0% NON-CALL 246,000.00 246,000.00 3.000% 0.0004275 36,900.00 282,900.00 1,826 5/8/2019 5/8/2023 CD BANK3 2.5% NON-CALL 249,000.00 249,000.00 2.336% 0.0003369 24,900.00 273,900.00 1,461 5/16/2018 5/16/2023 CD BELMONT SAVINGS BANK 3.05% 245,000.00 245,000.00 3.050% 0.0004328 37,362.50 282,362.50 1,826 6/20/2018 6/20/2023 CD RBC BANK 3.15% NON-CALL 249,000.00 249,000.00 3.150% 0.0004543 39,217.50 288,217.50 1,826 7/31/2018 7/31/2023 CD 'BANK OF NEW ENGLAND 3.25% NON-CALL 249,000.00 249,000.00 3.250% 0.0004687 40,462.50 289,462.50 1,826 7/31/2018 7/31/2023 CD MEDALLION BANK UTAH 3.25% NON-CALL 249,000.00 249,000.00 3.150% 0.0004543 40,462.50 289,462.50 1,826 2/13/2019 8/14/2023 CD FIRST MISSOURI STATE BANK 2.85% BULLET 246,000.00 246,000.00 2.850% 0.0004061 31,549.50 277,549.50 1,643 9/26/2018 9/26/2023 CD BANK MIDWEST 3.15% NON-CALL 245,000.00 245,000.00 3.150% 0.0004470 38,587.50 283,587.50 1,826 9/28/2018 9/28/2023 CD BANK OF BARODA 3.3% NON-CALL 245,000.00 245,000.00 3.300% 0.0004683 40,425.00 285,425.00 1,826 Nov. 19, 2019 Item #1 Page 16 of 22 Settled Matures ~ Security Par Cost Return (Yield} Weighted Avg Yield Interest Exgected Return at Maturi!¥ Term (Da¥sl 11/15/2018 10/30/2023 CD NATIONAL COOPERATIVE BANK 3.45% 245,000.00 245,000.00 3.450% 0.0004896 41,891.98 286,891.98 1,810 11/14/2018 11/14/2023 CD BANK HAPOALIM BM 3.5% NON-CALL 245,000.00 245,000.00 3.500% 0.0004967 42,875.00 287,875.00 1,826 11/15/2018 11/15/2023 CD MORGAN STANLEY PVT BANK 3.55% 245,000.00 245,000.00 3.550% 0.0005038 43,487.50 288,487.50 1,826 11/19/2018 11/29/2023 CD STATE BANK OF INDIA 3.6% BULLET 245,000.00 245,000.00 3.600% 0.0005109 44,100.00 289,100.00 1,836 2/26/2019 2/15/2024 CD JP MORGAN CHASE 3.15% CALL 2/15/20 245,000.00 245,000.00 3.150% 0.0004470 38,587.50 283,587.50 1,815 5/16/2019 5/16/2024 CD ENTERPRISE BANK/PA 2.6% NON-CALL 246,000.00 246,000.00 2.600% 0.0003705 31,980.00 277,980.00 1,827 5/24/2019 5/24/2024 CD EAGLE BANK 2.5% BULLET 249,000.00 249,000.00 2._500% 0.0003606 31,125.00 280,125.00 1,827 6/28/2019 6/28/2024 CD FIRST STATE BANK DEQUEEN 2.3% BULLET 249,000.00 249,000.00 2.300% 0.0003317 28,635.00 277,635.00 1,827 7/31/2019 7/31/2024 CD CAPITAL ONE 2.25% BULLET 247,000.00 247,000.00 2.250% 0.0003219 27,787.50 274,7B7.50 1,827 8/13/2019 8/13/2024 CD HSBC BANK 2.3% CALL 8/13/20 246,000.00 246,000.00 2.300% 0.0003277 28,290.00 274,290.00 1,827 8/30/2019 8/30/2024 CD WASHINGTON FEDERAL 2.0% BULLET 249,000.00 249,000.00 2.000% 0.0002885 24,900.00 273,900.00 1,827 9/13/2019 9/13/2024 CD ENERBANK USA 1.75% BULLET 249,000.00 249,000.00 1.750% 0.0002524 21,787.50 270,787.50 1,827 Sub-total CD 17,268,000.00 17,264,316.70 2.309% 1,869,234.89 19,133,551.59 1,711 10152 0 WELLS FARGO BANK-General Fund 365,332.00 365,332.00 0.750% 0.0000244 7.51 365,339.51 10151 0 CORPORATE CASH MANAGEMENT ACCOUNT 4,103,023.65 4,103,023.65 2.000% 0.0007319 224.82 4,103,248.47 11880 0 WELLS FARGO CUSTODY 1,351,269.85 1,351,269.85 0.750% 0.0000904 28.15 1,351,298.00 10047 0 LA IF WATER DISTRICT 22,394,529.85 22,394,529.85 2.340% 0.0046736 1,455.64 22,395,985.49 10045 0 LA IF PUBLIC IMPROVEMENT CORPORATION 19,784,574.01 19,784,574.01 2.340% 0.0041289 1,286.00 19,785,860.01 1 10391 0 LA IF PUBLIC FINANCING CORPORATION 24,222,181.32 24,222,181.32 2.340% 0.0050550 1,574.44 24,223,755.76 1 10046 0 LA I F CITY OF CARLSBAD 39,905,508.56 39,905,508.56 2.340% 0.0083280 2,593.86 39,908,102.42 Sub-total 112,126,419.24 112,126,419.24 2.303% 7,170.42 112,133,589.66 Grand Total 772,869,419.24 774,164,955.59 2.236% 55,625,895.82 808,256,125.52 Nov. 19, 2019 City of Carlsbad Investment Portfolio Fund Equity in Pooled Investments As of September 30, 2019 Cash Balance by Fund: General Special Revenue Capital Projects: General Capital Construction Traffic Impact Fees Public Facilities Fees Park Development Transnet Taxes Drainage Fees Special Districts Infrastructure Replacement Gas Tax Capital Project Subtotal Enterprise: Carlsbad Municipal Water District Sewer Fund Solid Waste Storm Water Golf Course Enterprise Subtotal Internal Service Trust and Agency Total General Ledger Balance ** Reconciling Adjustments (1) 47,606,796 23,881,910 27,026,695 11,772,338 7,355,012 5,983,832 104,682,523 124,362,773 14,758,935 138,833,751 49,087,719 6,640,598 7,854,497 1,504,953 Total Treasurer's Investment Portfolio at Amortized Cost 103,889,778 37,232,178 367,430,815 203,921,518 48,490,500 16,042,391 777,007,180 {3,256,826) 773,750,354 (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 10/10/2019. EXHIBIT 8 Nov. 19, 2019 Item #1 Page 18 of 22 EXHIBIT 9 City of Carlsbad Investment Portfolio Corporate Note and Commercial Paper Ratings As of September 30, 2019 Corporate Notes Moody's S&P Fitch Outlook 3M Company Al AA-Stable/Negative Alphabet Inc. Aa2 AA+ Stable Amazon.com Inc. A3 AA-A+ Positive/Stable/Positive Apple Inc. Aal AA+ Stable Automatic Data Processing Aa3 AA Stable Bank of New York Mellon Al A AA-Stable Berkshire Hathaway Aa2 AA AA-Stable Blackrock Inc. Aa3 AA-Stable Chevron Aa2 AA Stable Citibank Aa3 A+ A+ Stable Coca Cola Company Al A+ A Stable Colgate-Palmolive Aa3 AA-Stable Exxon Mobil Aaa AA+ Stable/Negative IBM Corp. A2 A Stable/Negative Johnson & Johnson Aaa AAA Negative/Stable JP Morgan Chase Bank A2 A-AA-Stable Microsoft Aaa AAA AA+ Stable New York Life Aaa AA+ AAA Stable Novartis Capital Corp Al AA-AA-Stable Procter & Gamble Aa3 AA-Stable Toyota Aa3 AA-A+ Stable US Bank NA Al AA-AA-Stable Wal-Mart Aa2 AA AA Stable Wells Fargo Bank NA Aa2 A+ AA-Stable Commercial paper investments meeting the current investment policy: Ratings of corporate notes must be AA or better by two of the three: Moody's, S&P, or Fitch Investments with Subsequent Changes in Credit Rating * Corporate Notes Moody's S&P Fitch Maturity Date Purchased Book Value 3M Company Al AA-08/07/20 11/03/15 3,509,679 Amazon.com Inc. A3 AA-A+ 08/22/24 08/26/19 2,085,579 Bank of New York Mellon Al A AA-04/28/23 05/16/19 2,055,933 Citibank Aa3 A+ A+ 01/23/24 05/16/19 1,032,080 Coca Cola Company Al A+ A 09/01/21 01/10/18 5,118,912 IBM Corp. A2 A 11/01/21 11/07/16 2,522,460 JP Morgan Chase Bank A2 A-AA-05/13/24 07 /31/19 2,115,163 * 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 . Nov. 19, 2019 Item #1 Page 19 of 22 City of Carlsbad Investment Portfolio Corporate and Federal Agency Issuers -Percent of Total Portfolio As of September 30, 2019 Corporate Notes 3M Company Alphabet Inc. Amazon.com Inc. Apple Inc. Automatic Data Processing Bank of New York Mellon Berkshire Hathaway Blackrock Inc. Chevron Citibank Coca Cola Company Colgate-Palmolive Exxon Mobil IBM Corp Johnson & Johnson JP Morgan Chase Bank Microsoft New York Life Novartis Capital Corp Procter & Gamble Toyota US Bank NA Wal-Mart Wells Fargo Bank NA Investment Cost Portfolio Allocation* $ 3,509,679 0.45% 5,139,342 0.66% 2,085,579 0.27% 17,301,859 2.24% 4,005,685 0.52% 2,055,933 0.27% 9,612,888 1.24% 3,167,426 0.41% 14,309,463 1.85% 1,032,080 0.13% 5,118,912 0.66% 11,719,434 1.51% 10,030,414 1.30% 2,522,460 0.33% 6,038,787 0.78% 2,115,163 0.27% 17,211,650 2.22% 4,001,307 0.52% 1,493,309 0.19% 7,622,866 0.99% 19,837,852 2.56% 6,581,226 0.85% 10,402,251 1.34% 8,027,552 1.04% EXHIBIT 10 Federal Agencies Investment Cost Portfolio Allocation** Federal Agricultural Mortgage Corp. Federal Farm Credit Bank Federal Home Loan · Federal Home Loan Mortgage Corp. Federal National Mortgage As soc. Private Export Funding Corp. RFCO STRIPS Tennessee Valley Authority Supranational US Treasury 13,408,131 88,236,883 92,065,803 107,283,593 52,394,851 5,574,313 2,947,932 7,294,983 21,590,064 78,616,856 Other Investment Cost Cash and Investments Total Portfolio Book Value $ * No more than 5% may be invested with a single corporate issuer. **There are no percentage limits on federal agency issuers. 129,393,827 773,750,354 1.73% 11.40% 11.90% 13.87% 6.77% 0.72% 0.38% 0.94% 2.79% 10.16% Portfolio Allocation 16.72% Nov. 19, 2019 Item #1 Page 20 of 22 City of Carlsbad Investments of Bond Proceeds Held Separately September 30, 2019 Stated Int. Maturity Name and Fund Type Investments Rate Date Par Value Assessment District 03-01 (College/Cannon) Project Fund Invesco Gov. & Agency-Institutional Money Market N/A N/A $ 972,648 Assessment District 96-01 (Rancho Carrillo) Reserve Fund Repub Natl Bank Repo Agreement: HSBC (GIC) 6.03% 09/02/28 $ 1,292,770 Reassessment District 2012-1 (College/Cannon & Poinsettia Lane) Reserve Fund Invesco Gov. & Agency-Institutional Money Market various N/A $ 2,264,419 Other Invesco Gov. & Agency-Institutional Money Market various N/A $ 183 Communities Facilities District#3 lmprovementArea 1, 2016 Bonds Reserve Fund Invesco Gov. & Agency-Institutional Money Market various 09/01/36 $ 568,021 Other Invesco Gov. & Agency-Institutional Money Market various 09/01/36 $ 52 Communities Facilities District#3 lmprovementArea 2, 2016 Bonds Reserve Fund Invesco Gov. & Agency-Institutional Money Market various 09/01/38 $ 828,520 Other Invesco Gov. & Agency-Institutional Money Market various 09/01/38 $ 424 $ $ $ $ $ $ $ $ $ 5,927,037 $ Cost Fiscal Agent: 972,648 Fiscal Agent: 1,292,770 Fiscal Agent: 2,264,419 183 Fiscal Agent: 568,021 52 Fiscal Agent: 828,520 424 5,927,037 Source BNYMellon Invesco BNYMellon HSBC Bank of New York BNYMellon BNYMellon BNYMellon BNYMellon BNYMellon BNYMellon BNYMellon BNYMellon BNYMellon m X ::c C::J =i .... .... Nov. 19, 2019 Item #1 Page 21 of 22 City of Carlsbad Investment Portfolio Summary of Outstanding Housing Loans As of September 30, 2019 Loans issued by city Loans issued by Loan amount due Developer loan First date # of loans to developers/ developer to #of loans City loan Developer loan to city amount due to city Borrower Development Purpose issued issued homeowners homeowners outstanding repaid to city repaid to city (recorded as AR) (not on city's books) Total Individual homebuyers City-wide (CHAP) Sale 06/28/99 133 $1,680,000 $ 0 ($1,680,000) $ ($0.08) $ (O) Individual homebuyers Calavera Hills Sale 10/15/99 5 75,000 150,000 1 (60,000) (120,000) 15,000 30,000 15,000 Individual homebuyers Cherry Tree Walk Sale 06/28/99 42 453,600 452,600 12 (324,000) (283,250) 129,600 169,350 129,600 Individual homebuyers Serrano Sale 05/25/01 90 1,350,000 4,050,000 23 (1,050,135) (2,790,000) 299,865 1,260,000 299,865 Individual homebuyers Rancho Carlsbad Sale 05/20/99 22 752,533 5 (616,633) 135,900 135,900 Individual homebuyers Solamar Sale 09/26/88 9 147,726 1 (135,065) 12,661 12,661 Catholic Charities Homeless shelter Shelter 09/19/97 1 200,000 1 200,000 200,000 CB Laurel Tree Apartments Laurel Tree Rentals 12/24/98 2 1,134,000 2 (1,134,000) (0) (0) USA Properties c/o CFHP Rancho Carrillo Rentals 03/05/01 1 1,157,584 1 (1,157,584) (0) (0) Pacific Vista Las Flores Vista Las Flores Rentals 02/27/01 1 363,948 1 363,948 363,948 Poinsettia Housing Assoc Poinsettia Station Rentals 10/21/99 1 920,000 1 (690,529) 229,471 229,471 Bridge Housing Corp Villa Loma Rentals 11/04/94 2 2,212,000 0 (2,212,000) Dove Family Housing La Costa Paloma Rentals 07/15/03 1 2,070,000 1 (2,070,000) (0) (0) CIC calavera LP Mariposa Apts Rentals 09/15/04 1 1,060,000 1 1,060,000 1,060,000 Individual homebuyers Bressi Ranch Sale 04/29/05 100 1,840,000 19,660,200 100 1,840,000 19,660,200 1,840,000 Individual homebuyers Village by the Sea Sale 10/28/05 11 220,000 4,087,200 11 220,000 4,087,200 220,000 El Camino Family Housing Cassia Heights Rentals 03/07/06 1 1,454,276 1 (1,454,276) Individual homebuyers Laguna Point Sale 07/06/06 3 210,000 2 (70,000) 140,000 140,000 Individual homebuyers The Bluffs Sale 06/14/07 10 200,000 10 200,000 200,000 Individual homebuyers Roosevelt Gardens Sale 08/30/07 11 1,583,423 11 1,583,423 1,583,423 CIC La Costa Hunter1s Point Rentals 08/19/08 1 1,932,000 1 1,932,000 1,932,000 Down Payment & Closing Cost Assistance Various Assistance 06/25/09 22 255,518 20 (31,900) 223,618 223,618 CIC Glen Ridge, LP Glen Ridge Rentals 10/05/09 1 1,014,000 1 1,014,000 1,014,000 Tavarua Senior Apartments, LP Tavarua Rentals 12/14/11 North County Solutions for Change Property Acquisition Rentals 06/28/12 1 780,000 1 780,000 780,000 Catholic Charities Homeless shelter Shelter 03/01/10 3 507,585 3 507,585 507,585 Individual homeowners N/A Mi~or ~ome Repair 05/20/10 12 30,677 6 (4,083) 26,594 26,594 Hospice of North Coast N/A Acq.uisit!on 02/27/13 1 1,065,000 1 1,065,000 1,065,000 Harding Street Neighbors, LP Duplex Acquisition 03/14/13 1 7,408,000 1 7,408,000 7,408,000 Tracy Templeton Laguna Point Sale 04/17/13 1 108,150 1 108,150 108,150 Thomas & Judy Kim Rose Bay Sale 08/23/13 1 229,775 1 229,775 229,775 Solutions for Change N/A Acquisition 12/19/14 1 2,646,000 1 2,646,0QO 2,646,000 Chelsea Inv Corp/Quarry Creek CiC LLP Quarry Creek Rentals 08/31/16 1 1,280,000 1 (285,908) 994,092 994,092 Allowances (1,798,379) (1,798,379) (1,798,379) 494 $ 34,542,416 $ 28,400,000 224 $ (12,976,114) $ (3,193,250) $ 21,566,302 $ 25,206,750 21,566,302 Seotember: received a $62,434.34 oavment related to t he Quarrv Creek develooment m X :::c: 0:, =i .... N Nov. 19, 2019 Item #1 Page 22 of 22