Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
2020-08-18; City Council; ; Report on City Investments as of June 30, 2020
Meeting Date: Aug. 18, 2020 To: Mayor and City Council From: Scott Chadwick, City Manager Staff Contact: Craig Lindholm, City Treasurer craig.lindholm@carlsbadca.gov, 760-602-2473 Laura Rocha, Deputy City Manager, Administrative Services laura.rocha@carlsbadca.gov, 760-602-2415 Subject: Report on City Investments as of June 30, 2020 Recommended Action Accept and file Report on City Investments as of June 30, 2020. Executive Summary The city’s Investment Policy requires the city treasurer to report the status of the city’s pooled investment portfolio to the City Council each month. Discussion & Fiscal Analysis The city’s pooled investment portfolio as of the month ending June 30, 2020 is summarized below. (1)The face value of the investments. (2)The cost of investments adjusted for amortized premiums and discounts. (3)The amount at which the investments could be sold. Source of market value is Wells Fargo Bank’s custodial report, as of June 30, 2020. Pooled investment portfolio (cash and securities) Current month Prior month Par value1 $807,311,873 $805,058,480 Investment cost $814,122,940 $811,454,775 Amortized cost2 $812,848,717 $810,213,529 Market value3 $827,577,140 $824,621,827 Aug. 18, 2020 Item #1 Page 1 of 21 The equity portion of the various funds in the total portfolio is summarized in the graph below. Fund balances are restricted for various purposes. (See Exhibit 7 for a more detailed breakdown.) All pooled investments have been made in accordance with the city’s Investment Policy, which was adopted Jan. 2, 1985, and last revised Dec. 17, 2019. All investments were initially made in accordance with the city’s Investment Policy, however, events after the purchase might have resulted in non-compliance with the current policy. These events are typically a change in the credit rating after a purchase, a change in the city’s Investment Policy or a temporary reduction in total portfolio assets. Exhibit 8 shows that the investments out of compliance with the current policy had a subsequent change in credit rating. Ratings on five investments have dropped to less than the rating required by the Investment Policy. Corporate notes require an AA or A rating while mortgage backed securities require an AA rating from one rating company. The city’s Investment Policy allows the city treasurer to determine the course of action that would correct Capital projects $372 Enterprise $198 General $136 Internal service $53 Special revenue $38 Agency/trust $22 Fund equity in pooled investments June 30, 2020 ($ in millions) Pooled investment interest income Year to date* Prior month*Current month Cash income $17,031,603 $15,930,621 $1,100,982 *The cash income received is adjusted for any accrued interest purchased. Pooled investment performance Average life (years) Yield to maturity Modified duration April 2020 1.85 1.84%1.77 May 2020 1.85 1.77%1.77 June 2020 1.84 1.69%1.77 Aug. 18, 2020 Item #1 Page 2 of 21 exceptions to the policy. These investments are paying interest at the required times and their principal is 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. 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 the California Environmental Quality Act 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 Public notice of this item was posted in accordance with the Ralph M. Brown Act and it was available for public viewing and review at least 72 hours prior to the scheduled meeting date. Exhibits 1. Investments by cost, market value, cash income, and average yield by class 2. Maturities by classification and length of time at market value 3. Yield comparison & market yield curve 4. Cumulative cash income 5. Maturities, purchases and calls this quarter 6. Detailed investment report 7. Fund equity in pooled investments 8. Corporate note and mortgage backed security ratings 9. Portfolio allocation at amortized cost by issuer 10. Investments of bond proceeds held separately as of June 30, 2020 11. Summary of housing loans as of June 30, 2020 Aug. 18, 2020 Item #1 Page 3 of 21 City of Carlsbad investment portfolio As of June 30, 2020Investments by cost, market value, cash income, and average yield by classInvestment costMarket valueAverage yieldClassCurrent monthPrior monthCurrent monthPrior monthYTD incomeCurrent monthPrior monthFA $238,374,968 242,836,703$ 242,273,461$ 246,881,101$ 7,229,231$ 1.75%1.83%FN2,750,760 2,750,760 2,997,330 2,997,420- 1.751.75SN39,669,269 39,669,269 40,575,352 40,600,179 482,803 1.821.82TR80,628,59881,974,169 82,219,190 83,671,040 1,546,821 1.751.75CN234,863,954 231,621,082 240,987,959 237,246,620 4,276,615 2.062.10CD18,329,263 18,327,034 18,956,503 18,902,976 624,233 2.052.06MBS (agency)7,165,895 7,169,266 7,227,112 7,216,000 39,857 1.471.47MBS (non-agency)- - - - - 0.000.00Bank account3,193,463 3,079,242 3,193,463 3,079,242- 0.100.10Sweep755,812 2,209,654 755,812 2,209,654 79,113 0.060.06IRT3,064,499 1,491,704 3,064,499 1,491,704 8,080 0.010.01CAMP1,004,415 1,003,846 1,004,415 1,003,846 4,415 0.570.57LAIF184,322,044 179,322,044 184,322,044 179,322,044 2,740,435 1.311.31Total$814,122,940 $811,454,775 $827,577,140 $824,621,827 $17,031,603 1.69%1.77%FA - Federal agency notesMBS - Passthrough/mortgage backed securitiesFN - Federal discount notesBank account - General cash accountSN - SupranationalSweep - Overnight cash accountTR - US TreasuryIRT - Investment cash accountCN - Corporate notesCAMP - California Asset Management ProgramCD - Certificate of depositLAIF - Local Area Investment FundAug. 18, 2020Item #1 Page 4 of 21 City of Carlsbad investment portfolio As of June 30, 2020Maturities by classification and length of time at market valueClassWithin 6 months7 to 12 months 1 to 5 yearsTotal% TotalFA$17,122,123 $22,801,659 $202,349,679 $242,273,46129.28%FN2,997,330 - - 2,997,330 0.36SN4,611,845 - 35,963,507 40,575,352 4.90TR16,839,143 15,925,878 49,454,170 82,219,190 9.93CN19,071,525 17,552,505 204,363,929 240,987,959 29.12(2)CD1,743,673 2,018,753 15,194,077 18,956,503 2.29MBS (agency)20,400 20,400 7,186,312 7,227,112 0.87(3)MBS (non-agency)- - - - 0.00(4)Bank account3,193,463 - - 3,193,463 0.39Sweep755,812 - - 755,812 0.09IRT3,064,499 - - 3,064,499 0.37CAMP1,004,415 - - 1,004,415 0.12LAIF184,322,044 - - 184,322,044 22.27Totals$254,746,271 $58,319,195 $514,511,673 $827,577,140100.0%% Totals30.8% 7.1%62.2%100.0%Total within One Year$313,065,467(1)37.8%Policy:(1) Not less than $198,032,000 to mature within one year, two-thirds of FY 19-20 operating budget of $297,048,458.FY 20-21 operating budget is $292,643,525. Two-thirds requirement will be $195,096,000 beginning July 1, 2020.(2) Policy states that not more than 30% of portfolio is to be invested in corporate notes at time of purchase. (3) Policy states that not more than 20% of portfolio is to be invested in mortgage backed securities at time of purchase.(4) Total non-agency mortgage backed securities shall be limited to 5% of the city's portfolio. Aug. 18, 2020Item #1 Page 5 of 21 0.00 0.20 0.40 0.60 0.80 1.001.20 1.401.60 1.802.00 2.20 2.40 2.60 2.80 2013 JanAprJulyOct2014 JanAprJulOct2015 JanAprJulOct2016 JanAprJulyOct2017 JanAprJulyOct2018 JanAprJulyOct2019 JanAprJulyOct2020 JanAprYield (%)City of Carlsbad investment portfolio Yield comparisonPortfolio yield ex pool money investment accounts(PMIA) vs CAMP yield vs LAIF yield Portfolio ex PMIA CAMP LAIF Began tracking published data for CAMP at time of investment, Jan. 2019. 0.00 0.50 1.00 1.50 2.00 2.50 3.00 3.50 3 month 2 year 5 year 10 year FY 2017-18 end 1.91 2.53 2.74 2.86 FY 2018-19 end 2.09 1.74 1.76 2.00 FY 2019-20 end 0.13 0.16 0.31 0.68Market rate (%)City of Carlsbad investment portfolio Market yield curve Fiscal year end compared to current Aug. 18, 2020 Item #1 Page 6 of 21 $0.99 $2.16 $0.95 $1.34 $1.72 $1.24 $1.24 $1.75 $1.00 $1.58 $1.79 $1.16 $1.10 $14.84 $17.03 - 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Jun Jul Aug Sept Oct Nov Dec Jan Feb Mar Apr May JuneInterest income ($ in millions)City of Carlsbad investment portfolio Cumulative cash income 13-month comparison FY 2018-19 FY 2019-20 FY 2018-19 cumulative FY 2019-20 cumulative Aug. 18, 2020 Item #1 Page 7 of 21 City of Carlsbad investment portfolio Maturities, purchases, and calls this quarter Maturities CUSIP Issuer Settled Maturity Par value Book value Interest Total 3136G3UG8 FNMA 7/13/2016 4/13/2020 5,000,000 5,000,000 31,250 5,031,250 3132X0SA0 FAMCA 12/15/2017 4/17/2020 1,500,000 1,500,000 12,300 1,512,300 57116AJP4 Marlin Bank 4/22/2015 4/22/2020 247,000 247,000 1,981 248,981 3136G3Q40 FNMA 7/28/2016 4/28/2020 3,750,000 3,750,000 23,438 3,773,438 912828K58 US Treasury 5/24/2016 4/30/2020 2,300,000 2,300,000 15,813 2,315,813 3138L14F3 FNMA AM1721 12/26/2019 4/27/2020 3,329 3,352 3,719 7,071 037833BD1 Apple 11/3/2015 5/6/2020 4,000,000 4,000,000 38,444 4,038,444 981571BD3 World Fist Bank 5/13/2015 5/13/2020 200,000 200,000 329 200,329 3130ACN83 FHLB 11/3/2017 5/15/2020 1,650,000 1,650,000 14,025 1,664,025 459200HM6 IBM 5/24/2016 5/15/2020 1,500,000 1,500,000 12,188 1,512,188 3134GBLL4 FHLMC 5/22/2017 5/22/2020 1,200,000 1,200,000 9,750 1,209,750 3138L14F3 FNMA AM1721 12/26/2019 5/27/2020 3,513 3,538 3,592 7,130 3134GBNK4 FHLMC 5/30/2017 5/29/2020 2,250,000 2,250,000 18,281 2,268,281 3134GBNK4 FHLMC 6/27/2017 5/29/2020 1,600,000 1,600,000 13,000 1,613,000 313383HU8 FHLB 6/12/2015 6/12/2020 3,000,000 3,000,000 26,250 3,026,250 313383HU8 FHLB 2/23/2016 6/12/2020 2,000,000 2,000,000 17,500 2,017,500 3136G16D6 FNMA 4/15/2016 6/26/2020 2,150,000 2,150,000 14,513 2,164,513 33646CFA7 First Bank 6/29/2015 6/29/2020 247,000 247,000 2,291 249,291 912828XH8 US Treasury 12/19/2016 6/30/2020 1,350,000 1,350,000 10,969 1,360,969 3138L14F3 FNMA AM1721 12/26/2019 6/25/2020 3,349 3,373 3,705 7,078 33,954,191 33,954,262 273,337 34,227,600 Purchases CUSIP Issuer Settled Maturity Payment Rate Par value Dollar price Book value 3133ELTP9 FFCB 4/3/2020 6/16/2021 6/16/2020 0.30%2,000,000 100.240 2,004,800 90331HPJ6 US Bank 4/3/2020 1/21/2022 7/21/2020 1.30%2,000,000 100.846 2,016,916 478160CJ1 Johnson & Johnson 4/8/2020 1/15/2025 7/15/2020 0.91%3,000,000 107.732 3,231,960 14042TDD6 Capital One 4/8/2020 4/8/2025 10/8/2020 1.60%248,000 100.000 248,000 3130A4CH3 FHLB 4/9/2020 3/14/2025 9/14/2020 0.78%3,000,000 107.710 3,231,300 3133ELWC4 FFCB 4/9/2020 4/9/2025 10/9/2020 1.15%2,000,000 100.000 2,000,000 3133ELWC4 FFCB 4/9/2020 4/9/2025 10/9/2020 1.17%2,500,000 99.925 2,498,125 66989HAP3 Novartis Capital Corp 4/13/2020 2/14/2025 8/14/2020 1.30%3,310,000 102.102 3,379,576 3137F32A1 FHMS KHG1 A1 4/15/2020 11/25/2024 4/25/2020 1.00%3,000,000 107.188 3,215,625 3133ELXC3 FFCB 4/22/2020 4/22/2024 10/22/2020 0.80%3,000,000 100.000 3,000,000 931142DP5 Walmart 4/24/2020 4/22/2024 10/22/2020 0.88%2,500,000 109.499 2,737,468 931142DP5 Walmart 4/24/2020 4/22/2024 10/22/2020 0.70%2,000,000 109.593 2,191,860 3136G4VE0 FNMA 4/27/2020 4/27/2023 10/27/2020 0.55%2,000,000 100.000 2,000,000 19416QDZ0 Colgate-Palmolive 5/7/2020 5/3/2022 11/3/2020 0.42%3,500,000 103.699 3,629,465 3133ELYV0 FFCB 5/11/2020 8/11/2023 8/11/2020 0.50%2,250,000 100.000 2,250,000 341081FZ53 Florida Power & Light 5/13/2020 4/1/2025 10/1/2020 1.02%3,667,000 108.551 3,980,565 3134GVQC5 FHLMC 5/13/2020 1/30/2024 10/30/2020 0.55%2,000,000 100.000 2,000,000 3130A0F70 FHLB 5/13/2020 12/8/2023 6/8/2020 0.34%1,000,000 110.763 1,107,630 74456QBW5 Public Service Electric 5/14/2020 9/1/2023 9/1/2020 0.72%2,500,000 108.023 2,700,575 0947XAL5 Blackrock Inc 5/14/2020 3/18/2024 9/18/2020 0.85%3,000,000 110.020 3,300,600 33847E3H8 Flagstar Bank 5/15/2020 5/15/2025 11/15/2020 0.85%248,000 100.000 248,000 29260MBF1 Encore Bank 5/15/2020 5/15/2025 6/15/2020 0.80%249,000 100.000 249,000 3135G0T78 FNMA 5/20/2020 10/5/2022 10/5/2020 0.19%1,923,000 104.287 2,005,439 3133ELXW9 FFCB 5/20/2020 4/27/2022 10/27/2020 0.21%2,000,000 100.174 2,003,480 404730CR2 Haddon Savings Bank 5/26/2020 5/27/2025 11/26/2020 0.75%248,000 100.000 248,000 43719LAE5 Home Loan Inv Bank 5/29/2020 5/29/2025 7/1/2020 0.80%249,000 100.000 249,000 69506YRT8 Pacific Western Bank 5/29/2020 5/29/2025 11/29/2020 0.70%249,000 100.000 249,000 56102AAJ5 Malaga Bank 5/29/2020 5/29/2025 6/29/2020 0.70%249,000 100.000 249,000 3133ELC28 FFCB 6/3/2020 5/27/2025 11/27/2020 0.73%3,500,000 99.980 3,499,300 3134GVB31 FHLMC 6/3/2020 5/28/2025 11/28/2020 0.75%2,000,000 100.000 2,000,000 3133ELE67 FFCB 6/3/2020 6/3/2024 12/3/2020 0.58%2,000,000 100.000 2,000,000 12572QAG0 CME Group Inc 6/3/2020 3/15/2025 9/15/2020 0.73%2,771,000 110.104 3,050,982 742718FF1 Proctor & Gamble 6/9/2020 3/25/2025 9/25/2020 0.70%1,000,000 108.224 1,082,240 86128QCF3 Stockman Bank 6/10/2020 6/10/2025 12/10/2020 0.60%249,000 100.000 249,000 3134GVL30 FHLMC 6/11/2020 6/11/2025 12/11/2020 0.75%2,000,000 100.000 2,000,000 3134GV2L1 FHLMC 6/30/2020 6/30/2025 12/30/2020 0.77%3,000,000 100.000 3,000,000 06406RAG2 Bank of NY Mellon 6/25/2020 4/28/2023 10/30/2020 0.51%2,000,000 108.424 2,168,480 3134GV2M9 FHLMC 6/30/2020 6/30/2022 12/30/2020 0.30%3,000,000 100.000 3,000,000 75,410,000 103.081 78,275,386 Aug. 18, 2020 Item #1 Page 8 of 21 Calls CUSIP Issuer Settled Maturity Redeemed Par value Book value Interest Total 3133EGSA4 FFCB 09/07/2016 08/24/2020 04/01/2020 3,000,000 2,999,827 4,070 3,004,070 3133EGLB9 FFCB 07/13/2016 07/13/2020 04/06/2020 4,250,000 4,250,000 11,660 4,261,660 3134GTEW9 FHLMC 04/23/2019 04/08/2022 04/08/2020 1,500,000 1,500,000 18,750 1,518,750 3130AGAA3 FHLB 04/15/2019 04/15/2024 04/15/2020 2,000,000 2,000,000 24,500 2,024,500 3134GTGZ0 FHLMC 04/15/2019 04/15/2024 04/15/2020 1,000,000 1,000,000 12,500 1,012,500 3134GTGZ0 FHLMC 04/15/2019 04/15/2024 04/15/2020 2,000,000 2,000,000 25,000 2,025,000 3134GUKY5 FHLMC 11/15/2019 10/21/2022 04/21/2020 2,000,000 2,001,691 18,600 2,018,600 48125LRN4 JP Morgan 11/18/2019 04/26/2021 04/27/2020 1,500,000 1,505,287 129 1,500,129 3134GTNE9 FHLMC 05/22/2019 04/28/2023 04/28/2020 5,000,000 5,000,000 65,625 5,065,625 3132X0GH8 FAMCA 01/03/2018 10/29/2021 04/29/2020 2,000,000 1,981,100 16,250 2,016,250 3133ELMH4 FFCB 02/07/2020 05/06/2024 05/06/2020 2,000,000 1,999,057 8,850 2,008,850 3130AHJQ7 FHLB 11/19/2019 11/19/2024 05/19/2020 3,000,000 3,000,000 31,050 3,031,050 3134GTMR1 FHLMC 05/20/2019 05/20/2024 05/20/2020 2,500,000 2,500,000 33,750 2,533,750 3133ELQU1 FFCB 03/03/2020 06/03/2024 06/03/2020 1,500,000 1,500,000 6,263 1,506,263 3133ELQT4 FFCB 03/09/2020 09/09/2022 06/09/2020 1,000,000 1,000,000 3,750 1,003,750 3134GTXQ1 FHLMC 07/05/2019 12/23/2022 06/23/2020 1,500,000 1,500,000 15,000 1,515,000 3130AHQ71 FHLB 12/23/2019 06/23/2022 06/23/2020 1,500,000 1,500,000 12,975 1,512,975 3134GSPF6 FHLMC 06/26/2018 06/26/2023 06/26/2020 1,250,000 1,250,000 19,063 1,269,063 3134GTYC1 FHLMC 06/28/2019 06/26/2023 06/26/2020 3,000,000 3,000,000 30,750 3,030,750 3134GTTK9 FHLMC 07/30/2019 06/26/2024 06/26/2020 2,000,000 2,003,264 23,750 2,023,750 89236TDZ5 Toyota 06/29/2017 12/29/2020 06/29/2020 3,000,000 3,000,000 15,000 3,015,000 3134GSQL2 FHLMC 07/24/2018 06/29/2023 06/29/2020 1,000,000 1,000,000 15,500 1,015,500 47,500,000 47,490,226 412,784 47,912,784 Aug. 18, 2020 Item #1 Page 9 of 21 EXHIBIT 6 City of Carlsbad Investment summary As of June 30, 2020 Settlement Maturity Issuer Par Invested Yield Interest expected Return Federal investments 04/27/17 07/27/20 FHLMC 1,600,000.00 1,600,000.00 1.700%88,400.00 1,688,400.00 01/21/16 07/29/20 FHLB 2,500,000.00 2,549,375.00 1.378%157,516.67 2,706,891.67 04/19/16 08/28/20 FHLMC 1,000,000.00 1,017,760.00 1.230%54,152.50 1,071,912.50 06/08/16 09/11/20 FHLB 3,000,000.00 3,206,160.00 1.214%161,121.25 3,367,281.25 10/12/16 09/11/20 FHLB 1,800,000.00 1,808,975.18 1.244%87,893.57 1,896,868.75 04/26/17 10/16/20 FNMA 1,300,000.00 1,332,019.00 1.618%74,057.39 1,406,076.39 07/22/16 11/27/20 FNMA 3,250,000.00 3,316,612.00 1.165%166,507.79 3,483,119.79 11/27/17 11/27/20 FHLMC 1,500,000.00 1,500,000.00 1.875%84,375.00 1,584,375.00 06/15/17 11/30/20 FNMA 1,100,000.00 1,113,618.00 1.630%62,404.22 1,176,022.22 03/10/17 01/15/21 FAMCA 1,580,000.00 1,576,287.00 2.063%125,285.22 1,701,572.22 09/09/16 01/25/21 FAMCA 2,000,000.00 2,018,640.00 1.550%117,071.11 2,135,711.11 10/12/16 02/15/21 TENN 3,000,000.00 3,315,660.00 1.370%189,058.75 3,504,718.75 08/16/17 02/16/21 FNMA 2,000,000.00 2,000,000.00 1.750%122,500.00 2,122,500.00 01/10/19 02/23/21 FFCB 1,500,000.00 1,502,895.00 2.605%82,942.50 1,585,837.50 12/12/18 02/24/21 FHLB 1,000,000.00 977,940.00 2.790%60,560.00 1,038,500.00 02/14/18 03/12/21 FHLB 1,500,000.00 1,500,768.00 2.357%108,778.87 1,609,546.87 06/12/18 03/12/21 FHLB 1,000,000.00 976,760.00 2.631%71,365.00 1,048,125.00 09/29/17 03/26/21 FHLMC 2,535,000.00 2,531,197.50 1.794%158,701.56 2,689,899.06 01/08/19 04/09/21 FFCB 1,500,000.00 1,504,860.00 2.550%86,377.50 1,591,237.50 10/26/17 04/26/21 FHLMC 1,975,000.00 1,974,012.50 1.865%128,868.75 2,102,881.25 10/12/16 06/11/21 FHLB 1,500,000.00 1,559,427.00 1.370%97,979.25 1,657,406.25 06/15/17 06/15/21 FHLMC 1,400,000.00 1,400,000.00 1.800%100,800.00 1,500,800.00 04/03/20 06/16/21 FFCB 2,000,000.00 2,004,800.00 0.300%7,227.78 2,012,027.78 10/26/16 07/14/21 FHLB 2,500,000.00 2,476,850.00 1.328%155,806.25 2,632,656.25 02/16/17 07/26/21 FHLMC 1,400,000.00 1,392,580.00 2.000%124,086.67 1,516,666.67 12/19/17 08/12/21 FHLMC 1,000,000.00 967,646.98 2.050%73,384.27 1,041,031.25 10/28/16 10/07/21 FNMA 2,500,000.00 2,491,075.00 1.450%178,794.79 2,669,869.79 11/29/16 11/29/21 FFCB 3,000,000.00 3,000,000.00 1.760%264,000.00 3,264,000.00 04/12/17 12/10/21 FHLB 2,000,000.00 2,003,620.00 1.834%171,171.67 2,174,791.67 09/10/19 12/13/21 FFCB 2,000,000.00 2,017,240.00 1.490%67,673.33 2,084,913.33 11/04/19 01/03/22 FAMCA 2,000,000.00 1,998,180.00 2.169%95,553.01 2,093,733.01 11/12/19 01/13/22 FHLMC 1,000,000.00 1,015,200.00 1.658%36,324.31 1,051,524.31 03/25/19 02/03/22 FFCB 2,500,000.00 2,483,900.00 2.264%161,019.44 2,644,919.44 02/23/17 02/23/22 FAMCA 2,600,000.00 2,609,204.00 2.025%263,796.00 2,873,000.00 03/01/19 03/01/22 FFCB 2,000,000.00 2,000,000.00 2.550%153,000.00 2,153,000.00 03/29/17 03/29/22 FHLMC 1,500,000.00 1,500,000.00 2.265%170,625.00 1,670,625.00 05/25/17 04/05/22 FNMA 1,600,000.00 1,600,581.01 1.867%145,252.32 1,745,833.33 01/09/20 04/05/22 FNMA 2,500,000.00 2,517,775.00 1.550%87,172.92 2,604,947.92 04/27/17 04/27/22 FHLMC 3,500,000.00 3,545,920.00 2.345%413,455.00 3,959,375.00 05/19/20 04/27/22 FFCB 2,000,000.00 2,003,480.00 0.210%8,136.67 2,011,616.67 01/09/20 06/10/22 FHLB 3,000,000.00 3,297,270.00 1.560%120,084.17 3,417,354.17 06/30/20 06/30/22 FHLMC 3,000,000.00 3,000,000.00 0.300%18,000.00 3,018,000.00 01/08/18 07/01/22 FHLMC 1,500,000.00 1,500,000.00 2.220%149,202.50 1,649,202.50 07/03/19 07/01/22 FHLMC 2,500,000.00 2,500,000.00 2.000%149,722.22 2,649,722.22 01/15/20 07/15/22 FHLMC 1,500,000.00 1,500,510.00 1.586%59,490.00 1,560,000.00 08/28/19 08/26/22 FFCB 1,500,000.00 1,499,565.00 1.860%83,530.83 1,583,095.83 12/01/17 09/09/22 FHLB 1,750,000.00 1,739,692.50 2.130%177,335.28 1,917,027.78 07/05/19 09/09/22 FHLB 1,800,000.00 1,874,106.00 1.786%104,644.00 1,978,750.00 01/15/20 09/09/22 FHLB 2,000,000.00 2,021,180.00 1.590%84,820.00 2,106,000.00 09/28/17 09/28/22 FNMA 2,500,000.00 2,500,000.00 2.000%249,861.11 2,749,861.11 03/09/18 10/05/22 FNMA 1,000,000.00 971,120.00 2.000%120,324.44 1,091,444.44 05/20/20 10/05/22 FNMA 1,923,000.00 2,005,439.01 0.190%8,903.49 2,014,342.50 10/05/18 10/05/22 FNMA 1,000,000.00 962,570.00 3.000%117,430.00 1,080,000.00 09/10/19 12/09/22 FHLB 1,500,000.00 1,670,736.00 1.630%84,545.25 1,755,281.25 04/24/18 12/09/22 FHLB 2,250,000.00 2,215,102.50 2.500%295,053.75 2,510,156.25 01/06/20 01/06/23 FAMCA 2,000,000.00 2,000,000.00 1.750%105,000.00 2,105,000.00 03/22/19 03/10/23 FHLB 2,000,000.00 2,028,220.00 2.375%189,946.67 2,218,166.67 03/16/20 03/16/23 FFCB 2,500,000.00 2,500,000.00 1.050%78,750.00 2,578,750.00 04/27/20 04/27/23 FNMA 2,000,000.00 2,000,000.00 0.550%33,000.00 2,033,000.00 07/30/18 07/28/23 FHLMC 2,500,000.00 2,500,000.00 3.070%383,323.61 2,883,323.61 05/11/20 08/11/23 FFCB 2,250,000.00 2,250,000.00 0.500%36,562.50 2,286,562.50 09/13/19 08/14/23 FFCB 1,800,000.00 1,796,580.00 1.650%116,300.00 1,912,880.00 09/13/19 08/28/23 FFCB 1,000,000.00 997,650.00 1.982%78,350.00 1,076,000.00 08/24/18 08/24/23 FHLB 1,750,000.00 1,750,000.00 3.125%273,437.50 2,023,437.50 09/18/18 09/05/23 FFCB 1,000,000.00 991,290.00 2.990%147,698.89 1,138,988.89 Aug. 18, 2020 Item #1 Page 10 of 21 Settlement Maturity Issuer Par Invested Yield Interest expected Return 10/10/18 09/05/23 FFCB 2,300,000.00 2,266,190.00 3.125%349,548.89 2,615,738.89 09/03/19 09/08/23 FHLB 2,000,000.00 2,069,108.00 1.485%121,551.72 2,190,659.72 02/27/19 09/12/23 FNMA 1,000,000.00 1,016,210.00 2.495%114,362.92 1,130,572.92 04/16/19 09/12/23 FNMA 1,750,000.00 1,783,757.50 2.410%187,617.50 1,971,375.00 09/18/18 09/18/23 FHLB 1,000,000.00 999,250.00 3.076%153,750.00 1,153,000.00 09/28/18 09/28/23 FHLB 1,250,000.00 1,250,000.00 3.200%200,000.00 1,450,000.00 10/17/18 10/02/23 FFCB 2,500,000.00 2,493,150.00 3.050%384,922.92 2,878,072.92 02/07/19 10/23/23 FFCB 1,000,000.00 1,017,530.00 2.602%123,803.33 1,141,333.33 05/09/19 11/08/23 FFCB 2,000,000.00 2,001,700.00 2.280%205,172.22 2,206,872.22 11/27/18 11/27/23 FHLB 1,800,000.00 1,800,000.00 3.350%301,500.00 2,101,500.00 12/13/19 11/27/23 FHLMC 1,965,000.00 1,964,017.50 1.788%138,947.33 2,102,964.83 06/28/19 12/05/23 FFCB 1,500,000.00 1,569,280.50 1.870%127,682.83 1,696,963.33 05/13/20 12/08/23 FHLB 1,000,000.00 1,107,630.00 0.339%12,838.75 1,120,468.75 12/18/19 12/18/23 FHLMC 1,500,000.00 1,500,000.00 1.850%111,000.00 1,611,000.00 05/09/19 12/20/23 FFCB 1,000,000.00 1,052,900.00 3.500%108,586.11 1,161,486.11 12/28/18 12/28/23 FHLB 2,000,000.00 2,000,000.00 3.100%310,000.00 2,310,000.00 01/29/19 01/29/24 FHLB 1,500,000.00 1,501,125.00 2.859%214,500.00 1,715,625.00 05/13/20 01/30/24 FHLMC 2,000,000.00 2,000,000.00 0.550%40,852.78 2,040,852.78 02/26/19 02/26/24 FHLB 2,500,000.00 2,500,000.00 2.800%350,000.00 2,850,000.00 03/06/19 02/27/24 FFCB 1,500,000.00 1,498,950.00 2.610%195,821.25 1,694,771.25 02/28/20 02/28/24 FFCB 2,500,000.00 2,500,000.00 1.550%155,000.00 2,655,000.00 03/08/19 03/08/24 FHLB 3,000,000.00 3,100,851.00 2.530%386,649.00 3,487,500.00 03/12/20 03/12/24 FFCB 3,000,000.00 3,000,000.00 1.050%126,000.00 3,126,000.00 04/09/19 04/05/24 FFCB 2,000,000.00 1,994,380.00 2.360%234,725.56 2,229,105.56 04/22/20 04/22/24 FFCB 3,000,000.00 3,000,000.00 0.800%96,000.00 3,096,000.00 05/09/19 05/07/24 FHLB 1,000,000.00 1,005,320.00 2.287%114,546.67 1,119,866.67 12/19/19 06/03/24 FFCB 3,000,000.00 2,997,750.00 1.830%246,860.00 3,244,610.00 06/03/20 06/03/24 FFCB 2,000,000.00 2,000,000.00 0.580%46,400.00 2,046,400.00 08/28/19 06/30/24 FFCB 1,470,000.00 1,517,378.10 1.457%103,884.90 1,621,263.00 08/28/19 06/25/24 FFCB 1,183,000.00 1,237,524.47 1.457%85,320.92 1,322,845.39 07/02/19 07/02/24 FHLMC 2,500,000.00 2,500,000.00 2.000%250,000.00 2,750,000.00 06/27/19 07/15/24 PEFCO 2,500,000.00 2,565,850.00 1.900%243,292.36 2,809,142.36 08/08/19 07/26/24 FFCB 2,500,000.00 2,532,125.00 1.582%197,583.33 2,729,708.33 02/12/20 08/12/24 FHLMC 2,000,000.00 2,000,000.00 1.800%162,000.00 2,162,000.00 09/03/19 09/03/24 FFCB 4,000,000.00 4,000,000.00 2.000%400,000.00 4,400,000.00 08/30/19 09/10/24 FFCB 2,500,000.00 2,572,420.00 1.480%189,024.44 2,761,444.44 09/23/19 09/23/24 FHLMC 1,000,000.00 1,000,000.00 2.100%10,500.00 1,010,500.00 10/15/19 10/15/24 FFCB 2,000,000.00 2,000,000.00 1.920%192,000.00 2,192,000.00 10/28/19 10/15/24 FHLMC 2,500,000.00 2,495,000.00 1.917%237,682.29 2,732,682.29 10/18/19 10/16/24 FHLB 2,250,000.00 2,250,000.00 2.000%224,750.00 2,474,750.00 11/15/19 11/01/24 FAMCA 2,000,000.00 1,999,720.00 1.793%177,887.78 2,177,607.78 01/10/20 01/10/25 FHLMC 2,000,000.00 2,000,000.00 1.800%180,000.00 2,180,000.00 01/15/20 01/15/25 FHLMC 2,000,000.00 2,000,000.00 1.900%190,000.00 2,190,000.00 02/10/20 02/10/25 FHLB 2,500,000.00 2,496,875.00 1.866%233,125.00 2,730,000.00 02/12/20 02/12/25 FHLMC 1,500,000.00 1,500,000.00 1.800%680,000.00 2,180,000.00 02/14/20 02/14/25 FHLMC 2,500,000.00 2,500,000.00 1.850%231,250.00 2,731,250.00 03/06/20 02/21/25 FHLB 2,000,000.00 2,008,202.00 1.050%185,173.00 2,193,375.00 04/09/20 03/14/25 FHLB 3,000,000.00 3,231,300.00 0.778%120,002.08 3,351,302.08 04/09/20 04/09/25 FFCB 2,000,000.00 2,000,000.00 1.150%115,000.00 2,115,000.00 04/09/20 04/09/25 FFCB 2,500,000.00 2,498,125.00 1.165%145,625.00 2,643,750.00 06/03/20 05/27/25 FFCB 3,500,000.00 3,499,300.00 0.734%128,024.17 3,627,324.17 06/03/20 05/28/25 FHLMC 2,000,000.00 2,000,000.00 0.750%74,791.66 2,074,791.66 06/11/20 06/11/25 FHLMC 2,000,000.00 2,000,000.00 0.750%75,000.00 2,075,000.00 06/30/20 06/30/25 FHLMC 3,000,000.00 3,000,000.00 0.770%115,500.00 3,115,500.00 Sub total FA 236,131,000.00 238,374,968.25 1.748%18,334,569.25 256,709,537.50 10/23/15 10/15/20 RFCSP 3,000,000.00 2,750,760.00 1.750%249,240.00 3,000,000.00 Sub total FN 3,000,000.00 2,750,760.00 1.750%249,240.00 3,000,000.00 Federal investments 239,131,000.00 241,125,728.25 18,583,809.25 259,709,537.50 Aug. 18, 2020 Item #1 Page 11 of 21 Settlement Maturity Issuer Par Invested Yield Interest expected Return Supranationals 08/03/17 08/10/20 IBRD 2,000,000.00 1,972,100.00 1.600%95,837.50 2,067,937.50 11/08/18 09/04/20 IBRD 1,100,000.00 1,074,711.00 2.930%57,859.27 1,132,570.27 01/08/18 10/05/20 IBRD 1,500,000.00 1,486,500.00 2.164%88,765.62 1,575,265.62 01/08/18 01/18/22 IADB 2,000,000.00 1,988,880.00 2.270%182,300.56 2,171,180.56 12/18/17 01/26/22 IBRD 2,500,000.00 2,485,325.00 2.150% 219,952.78 2,705,277.78 10/10/17 10/07/22 IBRD 1,300,000.00 1,290,907.89 2.024% 130,763.88 1,421,671.77 02/08/19 10/24/22 IFC 1,500,000.00 1,470,780.00 2.553% 140,553.33 1,611,333.33 05/09/19 10/24/23 IADB 2,000,000.00 2,058,280.00 2.300% 205,886.67 2,264,166.67 01/18/18 01/18/23 IADB 1,700,000.00 1,702,652.00 2.467% 209,848.00 1,912,500.00 01/24/18 01/18/23 IADB 1,000,000.00 997,670.00 2.550% 126,913.33 1,124,583.33 02/19/20 01/27/23 IBRD 1,170,000.00 1,170,538.20 1.734% 59,635.55 1,230,173.75 10/25/19 10/25/23 IBRD 3,000,000.00 3,000,000.00 1.700% 204,000.00 3,204,000.00 02/15/19 02/15/24 IBRD 3,000,000.00 3,000,000.00 2.625% 468,750.00 3,468,750.00 08/29/19 08/28/24 IBRD 2,000,000.00 2,006,920.00 1.428% 142,996.67 2,149,916.67 10/10/19 09/23/24 IBRD 3,500,000.00 3,510,500.00 2.136%370,863.89 3,881,363.89 12/10/19 09/23/24 IBRD 3,000,000.00 3,006,000.00 1.941%310,066.67 3,316,066.67 11/13/19 11/13/24 IBRD 1,500,000.00 1,500,000.00 2.050% 153,750.00 1,653,750.00 03/26/20 12/12/24 IBRD 3,500,000.00 3,522,505.00 1.096% 329,777.78 3,829,777.78 01/08/20 12/15/24 IBRD 1,425,000.00 1,425,000.00 1.700%119,577.30 1,544,577.30 01/27/20 01/15/25 IFC 1,000,000.00 1,000,000.00 1.625% 80,708.33 1,080,708.33 Supranationals 39,695,000.00 39,669,269.09 1.824%3,698,807.13 43,345,571.22 US Treasury 12/02/16 07/31/20 US Treasury 1.625%1,500,000.00 1,500,000.00 1.625% 89,286.68 1,589,286.68 06/07/17 07/31/20 US Treasury 1.625%2,000,000.00 2,011,320.00 1.440% 91,028.07 2,102,348.07 09/22/15 08/31/20 US Treasury 2.125%3,000,000.00 3,085,500.00 2.097% 229,396.98 3,314,896.98 10/28/16 10/31/20 US Treasury 1.375%1,750,000.00 1,759,570.31 1.235% 86,875.85 1,846,446.16 12/02/16 10/31/20 US Treasury 1.375%1,200,000.00 1,186,200.00 1.680%78,341.44 1,264,541.44 01/13/17 10/31/20 US Treasury 1.375%1,300,000.00 1,289,234.38 1.601%78,611.61 1,367,845.99 01/05/16 12/31/20 US Treasury 2.375%4,000,000.00 4,127,500.00 1.705% 346,195.00 4,473,695.00 05/05/16 12/31/20 US Treasury 1.75%2,000,000.00 2,049,174.00 1.205% 113,710.62 2,162,884.62 01/20/17 02/28/21 US Treasury 1.125%2,750,000.00 2,673,515.63 1.831% 203,567.42 2,877,083.05 02/17/17 02/28/21 US Treasury 1.125%1,225,000.00 1,194,853.52 1.760% 85,690.25 1,280,543.77 05/09/17 03/31/21 US Treasury 1.25%1,400,000.00 1,374,786.00 1.730% 93,349.25 1,468,135.25 08/19/16 04/30/21 US Treasury 1.375%3,000,000.00 3,037,662.00 1.100% 156,145.74 3,193,807.74 12/16/16 05/31/21 US Treasury 2.000%2,250,000.00 2,250,000.00 2.000% 200,521.98 2,450,521.98 10/28/16 06/30/21 US Treasury 1.125%2,500,000.00 2,477,400.00 1.325% 154,053.80 2,631,453.80 12/16/16 06/30/21 US Treasury 1.125%2,650,000.00 2,547,312.50 2.022% 238,058.93 2,785,371.43 02/06/20 07/15/21 US Treasury 2.625%3,000,000.00 3,048,960.00 1.475% 64,405.38 3,113,365.38 01/20/17 07/31/21 US Treasury 1.125%1,500,000.00 1,448,203.13 1.925% 145,113.79 1,593,316.92 02/20/18 08/31/21 US Treasury 1.125%2,000,000.00 1,911,080.00 2.450% 168,167.24 2,079,247.24 12/02/16 09/30/21 US Treasury 2.125%1,600,000.00 1,615,500.00 1.913% 148,615.38 1,764,115.38 03/10/17 09/30/21 US Treasury 1.125%1,200,000.00 1,150,500.00 2.078% 111,028.85 1,261,528.85 05/19/17 09/30/21 US Treasury 1.125%1,500,000.00 1,464,375.00 1.691% 109,303.28 1,573,678.28 02/14/18 09/30/21 US Treasury 2.125%1,500,000.00 1,486,406.25 2.387% 129,096.84 1,615,503.09 11/17/16 10/31/21 US Treasury 2.00%2,000,000.00 2,030,000.00 1.683% 168,121.55 2,198,121.55 11/18/16 10/31/21 US Treasury 2.00%2,000,000.00 2,028,360.00 1.700% 169,651.15 2,198,011.15 11/22/16 11/15/21 US Treasury 2.00%2,000,000.00 2,016,562.50 1.825% 182,664.02 2,199,226.52 01/06/17 12/31/21 US Treasury 2.125%4,000,000.00 4,052,128.00 1.850% 371,463.16 4,423,591.16 02/03/17 12/31/21 US Treasury 2.125%1,850,000.00 1,867,632.81 1.920% 175,237.36 2,042,870.17 11/27/19 12/31/21 US Treasury 2.125%2,000,000.00 2,022,656.25 1.572% 66,270.38 2,088,926.63 01/20/17 01/31/22 US Treasury 1.50%3,000,000.00 2,928,555.00 2.000% 297,790.11 3,226,345.11 04/23/19 02/28/22 US Treasury 1.875%1,500,000.00 1,481,015.63 1.875% 99,232.33 1,580,247.96 03/02/17 03/31/22 US Treasury 1.750%3,000,000.00 2,963,925.00 2.000% 302,757.69 3,266,682.69 11/20/19 04/15/22 US Treasury 2.25%1,200,000.00 1,219,125.00 1.571% 45,719.26 1,264,844.26 05/15/17 05/15/22 US Treasury 1.750%2,000,000.00 1,985,625.00 1.901% 189,375.00 2,175,000.00 08/25/17 07/31/22 US Treasury 1.875%1,250,000.00 1,257,346.25 1.750% 108,249.03 1,365,595.28 08/31/17 08/31/22 US Treasury 1.875%3,000,000.00 3,019,290.00 1.740% 261,960.00 3,281,250.00 11/20/19 10/15/22 US Treasury 1.375%1,500,000.00 1,491,720.00 1.570% 68,126.31 1,559,846.31 02/27/20 10/15/22 US Treasury 1.375%1,500,000.00 1,509,082.03 1.141% 45,185.39 1,554,267.42 11/28/17 11/15/22 US Treasury 1.625%1,000,000.00 980,950.00 2.030% 99,716.44 1,080,666.44 07/30/19 02/28/23 US Treasury 2.625%3,000,000.00 3,085,572.00 1.800% 275,650.83 3,361,222.83 US Treasury 80,625,000.00 80,628,598.19 1.746%6,047,734.39 86,676,332.58 Aug. 18, 2020 Item #1 Page 12 of 21 Settlement Maturity Issuer Par Invested Yield Interest expected Return Corporate notes 11/03/15 08/07/20 3M Company 3,500,000.00 3,554,215.00 1.660% 279,062.78 3,833,277.78 09/25/15 09/01/20 Johnson & Johnson 1,000,000.00 1,058,028.49 1.718% 87,504.84 1,145,533.33 09/24/15 09/15/20 Automatic Data Processing 4,000,000.00 4,029,600.00 2.090% 418,150.00 4,447,750.00 11/10/15 11/03/20 Microsoft 5,000,000.00 5,018,550.00 1.920% 479,505.56 5,498,055.56 06/10/16 11/03/20 Microsoft 1,500,000.00 1,539,450.00 1.370% 92,466.67 1,631,916.67 11/13/17 11/13/20 Apple Inc.2,500,000.00 2,497,900.00 2.000% 152,100.00 2,650,000.00 01/07/19 12/15/20 Wal-Mart 1,500,000.00 1,481,805.00 2.545% 73,453.33 1,555,258.33 02/26/18 01/15/21 Wells Fargo Bank NA 2,000,000.00 1,982,700.00 2.914% 167,377.77 2,150,077.77 04/28/16 03/01/21 Exxon Mobil 2,000,000.00 2,042,900.00 1.750% 172,263.67 2,215,163.67 07/26/16 03/01/21 Exxon Mobil 1,000,000.00 1,034,050.00 1.440% 68,038.55 1,102,088.55 09/16/16 04/08/21 Toyota 3,000,000.00 3,031,680.00 1.659% 228,303.33 3,259,983.33 11/18/19 04/26/21 US Bank NA 1,000,000.00 1,019,220.00 1.710% 26,105.00 1,045,325.00 06/13/18 05/16/21 Chevron 3,250,000.00 3,175,770.00 2.920% 273,861.25 3,449,631.25 05/26/16 05/19/21 Alphabet Inc.1,000,000.00 1,094,000.00 1.651% 86,545.14 1,180,545.14 04/17/17 05/19/21 Alphabet Inc.2,000,000.00 2,136,700.00 1.883% 159,744.44 2,296,444.44 05/14/17 05/19/21 Alphabet Inc.2,000,000.00 2,133,400.00 1.900% 159,620.83 2,293,020.83 02/06/20 07/23/21 Wells Fargo Bank NA 3,500,000.00 3,507,848.93 1.741% 110,314.37 3,618,163.30 09/13/16 08/08/21 Microsoft 6,000,000.00 5,995,740.00 1.565% 460,218.33 6,455,958.33 02/07/17 08/08/21 Microsoft 2,000,000.00 1,947,120.00 2.170% 192,466.11 2,139,586.11 02/22/18 08/08/21 Microsoft 1,500,000.00 1,441,912.50 2.730% 138,558.33 1,580,470.83 10/14/16 09/01/21 Coca Cola Company 3,600,000.00 3,581,496.00 1.660% 290,839.00 3,872,335.00 01/10/18 09/01/21 Coca Cola Company 1,500,000.00 1,549,740.00 2.344% 130,522.50 1,680,262.50 12/19/19 10/22/21 Wells Fargo Bank 4,000,000.00 4,122,000.00 1.851% 145,041.67 4,267,041.67 10/10/17 11/03/21 Procter & Gamble 2,000,000.00 1,982,100.00 1.930% 156,072.22 2,138,172.22 12/04/17 11/15/21 Colgate-Palmolive 2,250,000.00 2,271,141.00 2.200% 196,449.62 2,467,590.62 12/23/19 11/16/21 US Bank NA 3,000,000.00 3,091,620.00 1.730% 104,742.50 3,196,362.50 04/03/20 01/21/22 US Bank NA 2,000,000.00 2,016,916.00 1.300% 47,884.00 2,064,800.00 12/20/17 02/06/22 Microsoft 1,250,000.00 1,254,025.00 2.316% 119,808.33 1,373,833.33 11/29/19 02/09/22 Apple Inc.2,000,000.00 2,017,980.00 1.730% 76,381.11 2,094,361.11 03/07/19 03/03/22 Johnson & Johnson 1,250,000.00 1,236,787.50 2.620% 97,275.00 1,334,062.50 02/24/20 03/03/22 Johnson & Johnson 2,000,000.00 2,029,760.00 1.470% 61,365.00 2,091,125.00 05/07/20 05/03/22 Colgate-Palmolive 3,500,000.00 3,629,465.00 0.420% 30,640.56 3,660,105.56 03/06/17 03/06/22 Exxon Mobil 2,000,000.00 2,003,380.00 2.360% 236,320.00 2,239,700.00 05/23/17 05/11/22 Apple Inc.3,300,000.00 3,318,150.00 2.181% 358,820.00 3,676,970.00 12/06/17 05/15/22 Berkshire Hathaway 1,503,000.00 1,540,770.39 2.400% 162,504.36 1,703,274.75 01/08/18 05/15/22 Berkshire Hathaway 1,000,000.00 1,023,300.00 2.432% 107,283.33 1,130,583.33 10/09/18 05/15/22 Berkshire Hathaway 1,100,000.00 1,091,810.50 3.220% 126,989.50 1,218,800.00 02/19/19 05/17/22 Toyota 2,000,000.00 2,000,000.00 3.083% 200,044.66 2,200,044.66 01/06/20 05/27/22 Wells Fargo Bank NA 3,000,000.00 3,040,020.00 1.920% 167,839.75 3,207,859.75 08/09/18 06/01/22 Blackrock Inc.1,000,000.00 1,011,600.00 3.050% 117,306.25 1,128,906.25 12/11/19 06/15/22 Cisco Systems Inc 500,000.00 515,230.00 1.755% 22,436.67 537,666.67 02/20/20 06/20/22 JP Morgan Chase Bank 3,000,000.00 3,000,000.00 1.775% 124,250.00 3,124,250.00 12/19/19 06/26/22 3M Company 2,000,000.00 2,010,920.00 1.777% 89,857.78 2,100,777.78 08/24/17 07/13/22 Toyota 1,500,000.00 1,547,160.00 2.119% 158,056.67 1,705,216.67 01/16/19 07/13/22 Toyota 1,500,000.00 1,483,770.00 3.129% 162,880.00 1,646,650.00 07/01/19 07/13/22 Toyota 2,500,000.00 2,551,875.00 2.090% 160,458.33 2,712,333.33 11/06/17 08/11/22 Procter & Gamble 1,800,000.00 1,799,161.20 2.160% 185,201.30 1,984,362.50 11/09/18 08/11/22 Procter & Gamble 1,900,000.00 1,826,627.70 3.250% 226,786.74 2,053,414.44 05/02/19 08/11/22 Procter & Gamble 2,000,000.00 1,986,800.00 2.150% 154,025.00 2,140,825.00 01/18/18 09/21/22 Novartis Capital Corp 1,500,000.00 1,489,500.00 2.560% 178,400.00 1,667,900.00 10/10/19 11/03/22 Microsoft 2,000,000.00 2,064,180.00 1.514% 98,206.11 2,162,386.11 01/04/18 11/15/22 Colgate-Palmolive 2,000,000.00 1,982,400.00 2.443% 236,475.00 2,218,875.00 09/17/18 11/15/22 Colgate-Palmolive 2,000,000.00 1,935,820.00 3.077% 251,430.00 2,187,250.00 11/18/19 11/18/22 JP Morgan Chase Bank 3,000,000.00 3,000,000.00 3.077% 189,000.00 3,189,000.00 12/06/17 11/29/22 Toyota 2,250,000.00 2,250,000.00 2.125% 238,132.81 2,488,132.81 01/14/19 12/15/22 Wal-Mart 2,720,000.00 2,653,088.00 3.020% 317,442.89 2,970,530.89 12/23/19 12/15/22 Wal-Mart 2,000,000.00 2,032,580.00 1.770% 107,375.56 2,139,955.56 01/24/18 01/26/23 Toyota 3,000,000.00 3,000,000.00 2.750% 412,500.00 3,412,500.00 08/29/19 02/01/23 Colgate-Palmolive 1,000,000.00 1,011,600.00 1.600% 55,133.33 1,066,733.33 09/12/19 02/11/23 Berkshire Hathaway 1,250,000.00 1,296,137.50 1.878% 81,883.33 1,378,020.83 07/31/19 02/23/23 Apple Inc.3,500,000.00 3,592,680.00 2.039% 262,540.83 3,855,220.83 10/04/19 03/15/23 3M Company 1,762,000.00 1,798,080.47 1.620% 100,144.15 1,898,224.62 03/20/18 03/15/23 Berkshire Hathaway 1,000,000.00 983,890.00 3.101% 153,228.06 1,137,118.06 04/18/18 03/15/23 Berkshire Hathaway 1,750,000.00 1,719,130.00 3.140% 267,083.54 1,986,213.54 Aug. 18, 2020 Item #1 Page 13 of 21 Settlement Maturity Issuer Par Invested Yield Interest expected Return 04/25/18 03/15/23 Berkshire Hathaway 2,000,000.00 1,953,300.00 3.270% 315,588.89 2,268,888.89 05/07/18 04/11/23 Wal-Mart 1,000,000.00 974,100.00 3.121% 151,558.33 1,125,658.33 12/18/18 04/11/23 Wal-Mart 1,000,000.00 969,800.00 3.301% 141,054.17 1,110,854.17 05/16/19 04/28/23 Bank of New York Mellon 2,000,000.00 2,061,800.00 2.670% 214,700.00 2,276,500.00 06/23/20 04/28/23 Bank of New York Mellon 2,000,000.00 2,168,480.00 0.510% 30,436.67 2,198,916.67 05/02/18 05/01/23 Colgate-Palmolive 4,666,000.00 4,443,179.84 3.140% 712,477.98 5,155,657.82 05/09/18 05/03/23 Apple Inc.4,000,000.00 3,862,600.00 3.150% 615,800.00 4,478,400.00 08/06/16 06/26/23 Wal-Mart 1,750,000.00 1,763,895.00 3.220% 276,993.89 2,040,888.89 07/25/18 06/26/23 Wal-Mart 1,500,000.00 1,512,000.00 3.220% 238,891.66 1,750,891.66 02/19/19 06/26/23 Wal-Mart 1,000,000.00 1,025,140.00 2.770% 122,665.56 1,147,805.56 07/24/18 07/24/23 US Bank NA 1,250,000.00 1,251,625.00 3.371% 210,756.94 1,462,381.94 01/24/19 07/24/23 US Bank NA 1,000,000.00 1,010,000.00 3.156% 143,000.00 1,153,000.00 02/28/19 07/24/23 US Bank NA 1,800,000.00 1,835,100.00 2.916% 234,520.00 2,069,620.00 12/11/18 07/24/23 US Bank NA 2,500,000.00 2,489,250.00 3.400% 32,347.22 2,521,597.22 02/28/19 08/14/23 Wells Fargo Bank NA 2,000,000.00 2,040,700.00 3.050% 276,038.89 2,316,738.89 10/01/18 08/14/23 Wells Fargo Bank NA 1,500,000.00 1,500,000.00 3.550% 259,297.92 1,759,297.92 05/14/20 09/01/23 Public Service Electric 2,500,000.00 2,700,575.00 0.720% 67,324.31 2,767,899.31 12/23/19 11/20/23 State Street Corporation 2,000,000.00 2,130,440.00 1.958% 158,776.67 2,289,216.67 01/28/19 12/05/23 Johnson & Johnson 1,500,000.00 1,541,250.00 2.765% 204,421.87 1,745,671.87 03/07/19 01/08/24 Toyota 1,000,000.00 1,017,865.00 2.950% 144,144.72 1,162,009.72 01/16/20 01/15/24 Wal-Mart 2,000,000.00 2,067,790.00 1.900% 192,646.11 2,260,436.11 05/16/19 01/23/24 Citibank 1,000,000.00 1,034,870.00 2.836% 136,173.06 1,171,043.06 02/13/20 01/23/24 Citibank 2,500,000.00 2,674,670.00 1.770% 185,260.56 2,859,930.56 02/13/20 01/23/24 Citibank 2,000,000.00 2,142,600.00 1.733% 145,344.44 2,287,944.44 02/20/20 01/23/24 Citibank 1,500,000.00 1,603,710.00 1.780% 111,183.75 1,714,893.75 10/11/19 02/01/24 JP Morgan Chase Bank 1,765,000.00 1,900,834.40 2.000% 158,638.70 2,059,473.10 10/08/19 03/07/24 Microsoft 1,500,000.00 1,581,000.00 1.604% 107,379.17 1,688,379.17 08/29/19 03/18/24 Blackrock Inc.2,000,000.00 2,162,500.00 1.640% 156,194.44 2,318,694.44 10/28/19 03/18/24 Blackrock Inc.1,000,000.00 1,071,360.00 1.801% 82,251.11 1,153,611.11 11/14/19 03/18/24 Blackrock Inc.1,000,000.00 1,065,420.00 1.923% 86,635.56 1,152,055.56 05/14/20 03/18/24 Blackrock Inc.3,000,000.00 3,300,600.00 0.845% 103,066.67 3,403,666.67 04/24/20 04/22/24 Wal-Mart 2,500,000.00 2,737,467.50 0.875% 92,074.17 2,829,541.67 04/24/20 04/22/24 Wal-Mart 2,000,000.00 2,191,860.00 0.700% 71,773.33 2,263,633.33 07/31/19 05/13/24 JP Morgan Chase Bank 2,000,000.00 2,119,320.00 2.300% 227,471.67 2,346,791.67 10/17/19 08/22/24 Amazon.com Inc.2,500,000.00 2,604,850.00 1.860% 234,455.56 2,839,305.56 08/22/19 08/22/24 Amazon.com Inc.2,000,000.00 2,087,280.00 2.800% 192,097.78 2,279,377.78 02/18/20 10/24/24 Bank of NY Mellon 3,055,000.00 3,093,737.40 1.816% 261,721.85 3,355,459.25 12/23/19 12/23/24 JP Morgan Chase Bank 3,500,000.00 3,500,000.00 2.200% 390,775.03 3,890,775.03 01/15/20 01/15/25 Johnson & Johnson 1,820,000.00 1,882,380.50 1.586% 176,494.50 2,058,875.00 04/08/20 01/15/25 Johnson & Johnson 3,000,000.00 3,231,960.00 0.906% 143,633.75 3,375,593.75 04/13/20 02/14/25 Novartis Capital Corp 3,310,000.00 3,379,576.20 1.300% 210,555.54 3,590,131.74 06/03/20 03/15/25 CME Group Inc 2,771,000.00 3,050,981.84 0.730% 117,656.66 3,168,638.50 06/09/20 03/25/25 Procter & Gamble 1,000,000.00 1,082,240.00 0.703% 35,223.89 1,117,463.89 05/13/20 04/01/25 Florida Power & Light 3,667,000.00 3,980,565.17 1.020% 195,628.34 4,176,193.51 Corporate notes 230,289,000.00 234,863,954.03 2.058%19,357,849.09 254,221,803.12 Aug. 18, 2020 Item #1 Page 14 of 21 Settlement Maturity Issuer Par Invested Yield Interest expected Return Certificate of deposit 07/31/15 07/31/20 Institution For Savings 249,000.00 249,000.00 2.050% 25,522.50 274,522.50 08/02/17 08/03/20 Wex Bank 247,000.00 247,000.00 1.850% 13,721.19 260,721.19 08/11/15 08/25/20 Investor Bank 247,000.00 247,000.00 2.000% 24,700.00 271,700.00 09/10/15 09/10/20 Merrick Bank 249,000.00 248,377.50 1.910% 23,655.00 272,032.50 09/22/15 09/16/20 Barclays Bank 248,000.00 248,000.00 2.200%27,190.31 275,190.31 10/19/15 10/13/20 Comenity Cap Bank 249,000.00 249,000.00 2.000%24,818.14 273,818.14 12/14/17 12/14/20 Ally Bank 247,000.00 247,000.00 2.100%15,561.00 262,561.00 01/15/16 01/15/21 Investors Cmnty Bank 249,000.00 249,000.00 1.850%23,032.50 272,032.50 05/09/18 05/10/21 Connectone Bank 249,000.00 249,000.00 2.850%21,309.21 270,309.21 06/10/16 06/07/21 Ubs Bank Usa 249,000.00 249,000.00 1.650%20,508.73 269,508.73 06/21/18 06/21/21 Mercantil Bank 246,000.00 246,000.00 3.000%22,140.00 268,140.00 06/22/17 06/22/21 Lakeside Bank 249,000.00 249,000.00 1.900%18,924.00 267,924.00 06/23/16 06/23/21 East Boston Saving 248,000.00 248,000.00 1.500%18,600.00 266,600.00 06/24/16 06/24/21 First Business Bk 248,000.00 248,000.00 1.500%18,600.00 266,600.00 06/30/16 06/30/21 First Technology Federal 248,000.00 248,000.00 1.750%21,700.00 269,700.00 09/21/17 09/21/21 Pinacle Bank Tn 249,000.00 249,000.00 2.000%19,920.00 268,920.00 01/12/18 01/12/22 LCA Bank Corporation 246,000.00 246,000.00 2.300%22,632.00 268,632.00 01/18/17 01/18/22 Mb Financial Bank 249,000.00 249,000.00 2.050%25,522.50 274,522.50 01/20/17 01/20/22 First Natl Bank 249,000.00 249,000.00 2.050%25,522.50 274,522.50 01/24/19 01/24/22 Dollar Bank 246,000.00 246,000.00 2.850%21,033.00 267,033.00 02/12/20 02/14/22 Sallie Mae Bank 247,000.00 247,000.00 1.700%8,432.52 255,432.52 06/07/17 06/07/22 Mechantile Bank Of 247,000.00 247,000.00 2.100%25,935.00 272,935.00 07/31/17 07/29/22 KS State Bank 245,000.00 245,000.00 2.100%25,710.71 270,710.71 08/16/17 08/16/22 Everbank 247,000.00 247,000.00 2.200%27,170.00 274,170.00 08/30/17 08/30/22 Willamette Valley Bank 249,000.00 249,000.00 2.100%26,145.00 275,145.00 09/29/17 09/29/22 Allegiane Bank Texs 249,000.00 249,000.00 2.150%26,767.50 275,767.50 09/14/17 09/14/22 First Bank Of 247,000.00 247,000.00 2.150%26,552.50 273,552.50 10/18/17 10/18/22 Beneficial Bank 247,000.00 247,000.00 2.150%26,552.50 273,552.50 10/23/19 10/11/22 Goldman Sachs Bank USA 247,000.00 247,000.00 1.900%13,898.99 260,898.99 12/22/17 12/22/22 Industrial & Coml Bak China 249,000.00 249,000.00 2.500%31,125.00 280,125.00 01/11/19 01/11/23 Sterling Bank 246,000.00 246,000.00 3.100% 30,504.00 276,504.00 01/29/18 01/30/23 Suntrust Bank 246,000.00 245,508.00 2.792% 34,547.50 280,055.50 02/07/20 02/07/23 BMW Bank 247,000.00 247,000.00 1.650% 12,237.67 259,237.67 02/21/20 02/21/23 Wells Fargo Bank 249,000.00 249,000.00 1.750%13,084.44 262,084.44 04/24/18 04/24/23 Citibank 246,000.00 246,000.00 3.000%36,900.00 282,900.00 05/08/19 05/08/23 Bank3 249,000.00 249,000.00 2.336%24,900.00 273,900.00 05/16/18 05/16/23 Belmont Savings Bank 245,000.00 245,000.00 3.050%37,362.50 282,362.50 06/20/18 06/20/23 RBC Bank 249,000.00 249,000.00 3.150%39,217.50 288,217.50 07/31/18 07/31/23 Bank Of New England 249,000.00 249,000.00 3.250%40,462.50 289,462.50 07/31/18 07/31/23 Medallion Bank Utah 249,000.00 249,000.00 3.150%40,462.50 289,462.50 02/13/19 08/14/23 First Missouri State Bank 246,000.00 246,000.00 2.850%31,549.50 277,549.50 09/26/18 09/26/23 Bank Midwest 245,000.00 245,000.00 3.150%38,587.50 283,587.50 09/28/18 09/28/23 Bank Of Baroda 245,000.00 245,000.00 3.300%40,425.00 285,425.00 11/15/18 10/30/23 National Cooperative Bank 245,000.00 245,000.00 3.450%41,891.98 286,891.98 11/14/18 11/14/23 Bank Hapoalim Bm 245,000.00 245,000.00 3.500%42,875.00 287,875.00 11/15/18 11/15/23 Morgan Stanley Pvt Bank 245,000.00 245,000.00 3.550%43,487.50 288,487.50 11/19/18 11/29/23 State Bank Of India 245,000.00 245,000.00 3.600%44,100.00 289,100.00 05/16/19 05/16/24 Enterprise Bank 246,000.00 246,000.00 2.600%31,980.00 277,980.00 05/24/19 05/24/24 Eagle Bank 249,000.00 249,000.00 2.500%31,125.00 280,125.00 06/28/19 06/28/24 First State Bank Dequeen 249,000.00 249,000.00 2.300%28,635.00 277,635.00 07/31/19 07/31/24 Capital One 247,000.00 247,000.00 2.250%27,787.50 274,787.50 08/13/19 08/13/24 HSBC Bank 246,000.00 246,000.00 2.300%28,290.00 274,290.00 08/30/19 08/30/24 Washington Federal 249,000.00 249,000.00 2.000% 24,900.00 273,900.00 09/13/19 09/13/24 Enerbank Usa 249,000.00 249,000.00 1.750% 21,787.50 270,787.50 09/18/19 09/30/24 Celtic Bank 249,000.00 249,000.00 1.700% 20,956.25 269,956.25 11/26/19 11/26/24 Raymond James Bank NA 247,000.00 247,000.00 1.850% 22,872.54 269,872.54 Aug. 18, 2020 Item #1 Page 15 of 21 Settlement Maturity Issuer Par Invested Yield Interest expected Return 01/09/20 01/09/25 Morgan Stanley Bank NA 247,000.00 247,000.00 1.900% 23,490.72 270,490.72 02/27/20 02/27/25 Bell Bank Corp 249,000.00 249,000.00 1.600% 19,941.88 268,941.88 02/28/20 02/28/25 Congressional Bank 249,000.00 248,377.50 1.750% 22,433.88 270,811.38 03/13/20 03/13/25 Choice Financial Group 248,000.00 248,000.00 1.100% 13,647.47 261,647.47 03/13/20 03/13/25 American Eagle bank 249,000.00 249,000.00 1.100% 13,702.54 262,702.54 03/18/20 03/18/25 Poppy Bank 249,000.00 249,000.00 1.100% 13,702.54 262,702.54 03/19/20 03/19/25 Somerset Trust 249,000.00 249,000.00 1.000% 12,456.88 261,456.88 03/20/20 03/20/25 Iberia Bank 248,000.00 248,000.00 1.000% 12,406.79 260,406.79 03/27/20 03/27/25 Baycoast Bank 248,000.00 248,000.00 0.950% 11,786.45 259,786.45 03/27/20 03/27/25 American Commerce Bank 249,000.00 249,000.00 0.950% 11,834.03 260,834.03 04/08/20 04/08/25 Capital One 248,000.00 248,000.00 1.600% 19,850.88 267,850.88 05/15/20 05/15/25 Flagstar Bank 248,000.00 248,000.00 0.850% 10,545.77 258,545.77 05/15/20 05/15/25 Encore Bank 249,000.00 249,000.00 0.800%9,965.41 258,965.41 05/26/20 05/27/25 Haddon Savings Bank 248,000.00 248,000.00 0.750%9,310.19 257,310.19 05/29/20 05/29/25 Home Loan Inv Bank 249,000.00 249,000.00 0.800%9,965.41 258,965.41 05/29/20 05/29/25 Pacific Western Bank 249,000.00 249,000.00 0.700%8,719.77 257,719.77 05/29/20 05/29/25 Malaga Bank 249,000.00 249,000.00 0.700%8,719.87 257,719.87 06/10/20 06/10/25 Stockman Bank 249,000.00 249,000.00 0.600%7,474.10 256,474.10 Certificate of deposit 18,331,000.00 18,329,263.00 2.045%1,743,785.76 20,073,048.76 Mortgage backed securities (agency) 12/26/19 12/01/22 FNMA AM1721 1,900,640.26 1,913,707.15 2.001% 68,146.46 1,981,853.61 02/04/20 11/01/22 FNMA AM0982 2,000,000.00 2,036,562.50 1.704% 27,844.88 2,064,407.38 04/15/20 11/25/24 FHMS KHG1 A1 3,000,000.00 3,215,625.00 0.999%1,505.28 3,217,130.28 Mortgage backed securities (agency)6,900,640.26 7,165,894.65 1.467%97,496.62 7,263,391.27 Cash or cash equivalents Wells Fargo Bank - General 3,193,463.00 3,193,463.00 0.100%262.48 3,193,725.48 Sweep account 755,812.02 755,812.02 0.060%37.27 755,849.29 Wells Fargo Bank - Custody 3,064,498.71 3,064,498.71 0.010%25.54 3,064,524.25 CAMP 1,004,414.52 1,004,414.52 0.480%396.26 1,004,810.78 LAIF City 71,206,246.51 71,206,246.51 1.150% 68,239.32 71,274,485.83 LAIF CMWD 71,076,058.80 71,076,058.80 1.150% 68,114.56 71,144,173.36 LAIF CPFA 42,039,738.87 42,039,738.87 1.150% 40,288.08 42,080,026.95 LAIF CPIC - - 1.150%- - Cash or cash equivalents 192,340,232.43 192,340,232.43 1.107%177,363.51 192,517,595.94 Grand total 807,311,872.69 814,122,939.64 1.694%49,706,845.75 863,807,280.39 Aug. 18, 2020 Item #1 Page 16 of 21 City of Carlsbad investment portfolio Fund equity in pooled investments As of June 30, 2020 Cash balance by fund: General 135,632,969 Special revenue 37,734,258 Capital projects: General capital construction 42,896,378 Traffic impact fees 24,805,433 Public facilities fees 28,924,538 Park development 12,625,750 Transnet taxes 8,166,191 Drainage fees 5,588,098 Special districts 111,342,316 Infrastructure replacement 121,710,015 Gas tax 15,932,086 Capital project subtotal 371,990,805 Enterprise: Carlsbad Municipal Water District 134,689,496 Sewer fund 48,258,937 Solid waste 6,301,937 Storm water 7,962,574 Golf course 720,923 Enterprise subtotal 197,933,867 Internal service 52,882,155 Trust and agency 22,583,641 Total general ledger balance **818,757,695 Reconciling adjustments (1)(5,908,978) Total treasurer's investment portfolio at amortized cost 812,848,717 **Figures based on best estimate at the time report run on 7/7/2020. (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. Aug. 18, 2020 Item #1 Page 17 of 21 City of Carlsbad investment portfolio Corporate note and mortgage backed security ratings As of June 30, 2020 Corporate notes Moody's S&P Fitch Outlook 3M Company A1 A+Negative/negative Alphabet Inc.Aa2 AA+Stable Amazon.com Inc.A2 AA- A+ Positive/stable/positive Apple Inc.Aa1 AA+Stable Automatic Data Processing Aa3 AA Negative/stable Bank of New York Mellon A1 A AA- Stable Berkshire Hathaway Aa2 AA AA- Stable Blackrock Inc.Aa3 AA-Stable Chevron Aa2 AA Stable/negative Cisco Systems Inc.A1 AA-Stable Citibank A3 BBB+A Stable/stable/negative CME Group Aa3 AA- AA- Stable Coca Cola Company A1 A+A Stable/negative/stable Colgate-Palmolive Aa3 AA-Stable Exxon Mobil Aa1 AA Negative Florida Power & Light Aa2 A+ AA- Stable Johnson & Johnson Aaa AAA Negative/stable JP Morgan Chase Bank A2 A- AA- Stable/stable/negative Merck & Co A1 AA- A+ Stable/negative/stable Microsoft Aaa AAA AA+ Stable New York Life Aaa AA+ AAA Negative/stable/stable Novartis Capital Corp A1 AA- AA- Stable Procter & Gamble Aa3 AA-Stable Public Service Electric Aa3 A Stable State Street Corporation A1 A AA- Stable Toyota A1 A+ A+ Negative US Bank NA A1 A+ AA- Stable/stable/negative Wal-Mart Aa2 AA AA Stable Wells Fargo Bank NA A2 A- A+ Stable/negative/negative Mortgage backed securities Moody's S&P Fitch Outlook FHLMC (KHG1 A1)Aaa AAA Stable FNMA (AM0982)Aaa AAA Stable FNMA (AM1721)Aaa AAA Stable Ratings of corporate notes must be AA or better by one and A or better another of the three: Moody's, S&P, or Fitch. Ratings of mortgage backed securities must be AA or better by one 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 A1 A+03/07/24 12/19/19 8,867,750$ Citibank A3 BBB+A 01/23/24 02/20/20 7,407,030$ Coca Cola Company A1 A+A 09/01/21 01/10/18 5,111,512$ Toyota A1 A+ A+01/08/24 07/01/19 16,813,293$ Wells Fargo Bank NA A2 A- A+02/06/20 08/14/23 16,149,474$ * All investments were in compliance with the city's investment policy when initially purchased. The city's investment policy allows the city treasurer to determine the course of action that would correct exceptions to the policy. All current exceptions 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.Aug. 18, 2020 Item #1 Page 18 of 21 City of Carlsbad investment portfolio Portfolio allocation at amortized cost by issuer As of June 30, 2020 Corporate notes Amortized cost Portfolio allocation* 3M Company 8,867,750$ 1.09% Alphabet Inc.5,075,359 0.62% Amazon.com Inc.4,662,046 0.57% Apple Inc.15,310,249 1.88% Automatic Data Processing 4,001,223 0.49% Bank of New York Mellon 7,302,372 0.90% Berkshire Hathaway 9,608,370 1.18% Blackrock Inc.8,545,081 1.05% Chevron 3,227,794 0.40% Cisco Systems Inc.511,861 0.06% Citibank 7,407,030 0.91% CME Group 3,046,429 0.37% Coca Cola Company 5,111,512 0.63% Colgate-Palmolive 15,380,299 1.89% Exxon Mobil 5,011,981 0.62% Florida Power & Light 3,972,004 0.49% Johnson & Johnson 10,895,656 1.34% JP Morgan Chase Bank 13,474,503 1.66% Microsoft 19,272,436 2.37% Novartis Capital Corp 4,871,456 0.60% Procter & Gamble 8,725,169 1.07% Public Service Electric 2,692,633 0.33% State Street Corporation 2,113,011 0.26% Toyota 16,813,293 2.07% US Bank NA 12,667,051 1.56% Wal-Mart 19,420,604 2.39% Wells Fargo Bank NA 16,149,474 1.99% Mortgage backed securities (agency)Amortized cost Portfolio allocation* FHLMC 3,215,625 0.40% FNMA 3,950,270 0.49% Federal agencies Amortized cost Portfolio allocation** Federal Agricultural Mortgage Corp.12,183,409 1.50% Federal Farm Credit Bank 77,246,449 9.50% Federal Home Loan Bank 60,550,796 7.45% Federal Home Loan Mortgage Corp.56,385,259 6.94% Federal National Mortgage Assoc.25,524,426 3.14% Private Export Funding Corp.2,552,695 0.31% RFCO STRIPS 2,985,476 0.37% Tennessee Valley Authority 3,045,239 0.37% Other Amortized cost Portfolio allocation Supranational 39,743,080 4.89% US Treasury 80,658,974 9.92% Certificate of deposits 18,330,141 2.26% Cash 192,340,232 23.66% Total portfolio amortized cost 812,848,717$ * No more than 5% may be invested with a single issuer. **There are no percentage limits on federal agency issuers. Aug. 18, 2020 Item #1 Page 19 of 21 City of CarlsbadInvestments of bond proceeds held separately June 30, 2020Stated int.MaturityGL Acct #Name and fund typeInvestmentsrate datePar valueCostSourceAssessment District 03-01 (College/Cannon)Fiscal agent:BNY Mellon40770001132Project fund Invesco Gov. & Agency - Institutional Money MarketN/A N/A980,040$ 980,040$ InvescoAssessment District 96-01 (Rancho Carrillo)Fiscal agent:BNY Mellon40900001133Reserve fund Repub Natl Bank Repo Agreement: HSBC (GIC)6.03% 09/02/28942,770$ 942,770$ HSBC Bank of New YorkReassessment District 2012-1 (College/Cannon & Poinsettia Lane)Fiscal agent:BNY Mellon42000001132Reserve fund Invesco Gov. & Agency - Institutional Money MarketvariousN/A2,285,388$ 2,285,388$ BNY Mellon42000001132 OtherInvesco Gov. & Agency - Institutional Money MarketvariousN/A428$ 428$ BNY MellonCommunities Facilities District #3 Improvement Area 1, 2016 BondsFiscal agent:BNY Mellon43413501133Reserve fund Invesco Gov. & Agency - Institutional Money Marketvarious 09/01/36573,281$ 573,281$ BNY Mellon43413501133 OtherInvesco Gov. & Agency - Institutional Money Marketvarious 09/01/3611$ 11$ BNY MellonCommunities Facilities District #3 Improvement Area 2, 2016 BondsFiscal agent:BNY Mellon43413601133Reserve fund Invesco Gov. & Agency - Institutional Money Marketvarious 09/01/38836,192$ 836,192$ BNY Mellon43413601133 OtherInvesco Gov. & Agency - Institutional Money Marketvarious 09/01/38378$ 378$ BNY Mellon5,618,490$ 5,618,490$ Aug. 18, 2020Item #1 Page 20 of 21 City of CarlsbadSummary of outstanding housing loansAs of June 30, 2020BorrowerDevelopmentPurposeStatusFirst date issued# of loans issuedLoans issued by city to developers/homeownersLoans issued by developer to homeowners# of loans outstandingCity loan repaid to cityDeveloper loan repaid to cityLoan amount due to city(recorded as AR)Developer loan amount due to city (not on city's books)TotalIndividual homebuyersSolamarSaleOutstanding 09/26/889147,726 - 1(135,065) - 12,661 - 12,661 Catholic CharitiesHomeless shelterShelterOutstanding 09/19/971200,000 - 1- - 200,000 - 200,000 Individual homebuyersRancho CarlsbadSaleOutstanding 05/20/99 22752,533 - 4(616,633) - 135,900 - 135,900 Individual homebuyersCherry Tree WalkSaleOutstanding 06/28/99 42453,600 452,600 11(334,800) (283,250) 118,800 169,350 118,800 Individual homebuyersCalavera HillsSaleOutstanding 10/15/99575,000 150,000 1(60,000) (120,000) 15,000 30,000 15,000 Pacific Vista Las FloresVista Las FloresRentalsOutstanding 02/27/011363,948 - 1- - 363,948 - 363,948 Individual homebuyersSerranoSaleOutstanding 05/25/01 901,350,000 4,050,000 21(1,050,135) (2,790,000) 299,865 1,260,000 299,865 CIC Calavera LPMariposa AptsRentalsOutstanding 09/15/0411,060,000 - 1- - 1,060,000 - 1,060,000 Individual homebuyersMulberry at Bressi RanchSaleOutstanding 04/29/05 1001,840,000 19,660,200 100- - 1,840,000 19,660,200 1,840,000 Individual homebuyersVillage by the SeaSaleOutstanding 10/28/05 11220,000 4,087,200 11- - 220,000 4,087,200 220,000 Individual homebuyersLaguna PointSaleOutstanding 07/06/063210,000 2(70,000) 140,000 - 140,000 Individual homebuyersThe BluffsSaleOutstanding 06/14/07 10200,000 10- 200,000 - 200,000 Individual homebuyersRoosevelt GardensSaleOutstanding 08/30/07 111,583,423 111,583,423 - 1,583,423 CIC La CostaHunter's PointRentalsOutstanding 08/19/0811,932,000 - 1- - 1,932,000 - 1,932,000 Down Payment & Closing Cost AssistVariousAssistanceOutstanding 06/25/09 22255,518 20(31,900) - 223,618 - 223,618 CIC Glen Ridge, LPGlen RidgeRentalsOutstanding 10/05/0911,014,000 - 11,014,000 - 1,014,000 Catholic CharitiesHomeless shelterShelterOutstanding 03/01/103507,585 - 3- 507,585 - 507,585 Individual homeownersN/AMinor Home RepairOutstanding 05/20/10 1235,559 - 7(4,083) - 31,476 - 31,476 North County Solutions for Change Property AcquisitionRentalsOutstanding 06/28/121780,000 - 1- 780,000 - 780,000 Hospice of North CoastN/AProperty AcquisitionOutstanding 02/27/1311,065,000 - 1- - 1,065,000 - 1,065,000 Harding Street Neighbors, LPCarol-Harding Duplex Property AcquisitionOutstanding 03/14/1317,408,000 - 1- 7,408,000 - 7,408,000 Tracy TempletonLaguna PointSaleOutstanding 04/17/131108,150 - 1- 108,150 - 108,150 Thomas & Judy KimRose BaySaleOutstanding 08/23/131229,775 1- 229,775 - 229,775 Solutions for ChangeN/AProperty AcquisitionOutstanding 12/19/1412,646,000 12,646,000 - 2,646,000 Chelsea Inv Corp/Quarry Creek CiC LLP Quarry CreekRentalsOutstanding 08/31/1611,280,000 1(285,908) 994,092 - 994,092 35225,717,817 28,400,000 214(2,588,524) (3,193,250) 23,129,293 25,206,750 23,129,293 Bridge Housing CorpVilla LomaRentalsPaid-Off11/04/9422,212,000 - 0(2,212,000) - - - - CB Laurel Tree ApartmentsLaurel Tree RentalsPaid-Off12/24/9821,134,000 - 0(1,134,000) - (0) - (0) Individual homebuyersCity-wide (CHAP)SalePaid-Off06/28/99 1331,680,000 - 0(1,680,000) - 0 - 0 Poinsettia Housing AssocPoinsettia StationRentalsPaid-Off10/21/991920,000 - 0(920,001) - 0 - 0 USA Properties c/o CFHPRancho Carrillo RentalsPaid-Off03/05/0111,157,584 - 0(1,157,584) - (0) - (0) Dove Family HousingLa Costa PalomaRentalsPaid-Off07/15/0312,070,000 - 0(2,070,000) - 0 - 0 El Camino Family HousingCassia Heights RentalsPaid-Off03/07/0611,454,276 - 0(1,454,276) - - - - 14110,627,860 - 0(10,627,861) - 0 -$ 0 AllowancesOther(1,798,379) (1,798,379) (1,798,379) 493.00 34,547,298.41 28,400,000.00 214.00 (13,216,385.17) (3,193,250.00) 21,330,914.22 25,206,750.00 21,330,914.22 Aug. 18, 2020Item #1 Page 21 of 21