Loading...
Item 3B3 - Financial ReportCITY OF S0UTHLA1<4,,E MONTHLY FINANCIAL REPORT or— 11 1 April 2022 PERFORMANCE AT A GLANCE Year to Date 3 year Trend Reference 7G...,.I.FundVs. Rev. Positive Positive Page 3 (2 months prior activity) Positive Positive Page 3 Property Tax Revenue Positive Positive Page 4 Permit Revenues Positive Positive Page 4 Departmental Expenditures Summary Positive Positive Page 5 Positive = Positive variance or negative variance <1 % compared to seasonal trends. Warning = Negative variance of 14% compared to seasonal trends Negative = Negative Variance of > 4% compared to seasonal trends. City of Southlake Monthly Financial Report 1 5/12/2022 ECONOMIC INDICATORS NATIONAL ECONOMY 1.40% GDP is defined as the output of goods and services produced by labor and property located in the United States, The Bureau of Labor and Economic Analysis reported that the "advance" estimated GDP for the 1st quarter of 2022 decreased at a rate of 1.4%. In the 4th $100,000,000 quarter of 2021, GDP increased at a rate of 6.9%. $90,000,000 $80,000,000 Housing Starts: V 0.3% Housing starts in March were at a seasonally adjusted $70,000,000 rate of 1,793,000, which is 0.3% above the revised previous month figure of 1,788,000. $60,000,000 $50,000,000 $40,000,000 UNEMPLOYMENT RATES National: V 3.6% The National Unemployment rate for April 2022 remained unchanged at 3.6% when compared to March $30,000,000 2022. $20,000,000 State-wide: 4.4% The Texas Unemployment rate for March 2022 $10,000,000 (preliminary) decreased slightly to 4.4% from 4.7% in February 2022. $- FINANCIAL ACTIVITY DFW Area: V 3.4% 1 2018* 2019* 2020* 2021* 2022* The Dallas/Fort Worth/Arlington Metropolitan Area *October - April ■ New Construction permit values unemployment rate for March 2022 (preliminary) decreased to 3.4% when compared to 4.1 % in February City of Southlake Monthly Financial Report 2 5/12/2022 GENERAL FUND OVERALL FUND PERFORMANCE: GENERAL FUND REVENUE VS EXPENDITURES 2022 FY 2022 FY 2022 FY 2022 REVENUE FY 2022 EXPENDITURE 2021 EXPEND. REVENUE EXPENDITURE VARIANCE Oct $ 1,158,989 $ 2,430,309 $ (1,271,320) $16,000,000 Nov $ 2,530,286 $ 3,030,028 $ (499,742) $14,000,000 Dec $ 8,051,473 $ 4,395,374 $ 3,656,099 Jan $ 13,878,168 $ 3,110,936 $ 10,767,232 $12,000,000 Feb $ 9,221,772 $ 3,292,649 $ 5,929,123 Mar $ 3,062,209 $ 3,845,975 $ (783,766) $10,000,000 Apr $ 2,606,899 $ 3,280,619 $ (673,720) $8,000,000 May $ - $ - $ Jun $ $ $ $6,000,000 — Jul $ $ $ Aug $ - $ - $ _ $4,000,000 Sep $ $ $ $2,000,000 Tot $ 40,509,796 $ 23,385,890 $ 17,123,906 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep CHART OUTLOOK: I POSITIVE The outlook for the year is positive as overall revenues are exceeding budget projections and expenditures are on target to be below budget. The revenues are higher than expenditures by approximately $17.1 M. The significant variance is due to the significant portion of property tax revenue collected (over 90%) of the budgeted property tax revenue which is the largest revenue sources for the general fund. REVENUE ANALYSIS GENERAL FUND SALES TAX 2022-2020 COMPARISON FY 2022 FY 2021 FY 2020 FY 2022 FY 2021 FY 2020 Oct $ 1,613,415 $ 1,299,576 $ 1,278,635 $3,000,000 Nov $ 1,652,674 $ 1,084,677 $ 1,309,584 Dec $ 2,456,532 $ 1,926,407 $ 1,993,686 $2,500,000 Jan $ 1,602,323 $ 1,256,119 $ 1,360,873 Feb $ 1,388,859 $ 978,395 $ 1,011,429 $2,000,000 ' Mar $ 1,975,175 $ 1,727,925 $ 1,162,936 Apr $ - $ 1,470,896 $ 1,038,287 $1,500,000 May $ - $ 1,262,973 $ 1,153,263 ' ■ Jun $ $ 2,586,036 $ 1,375,636 $1,000,000 Jul $ - $ 1,449,136 $ 1,190,064 Aug $ $ 1,427,525 $ 1,233,673 $500,000 Sep $ $ 1,687,605 $ 1,416,226 Tot $ 10,688,978 $ 18,157,270 $ 15,524,291 $- Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep CHART OUTLOOK: POSITIVE Year to date sales tax collections are trending above FY 2021 (29.2%) and FY 2020 (31.2%) collections. The most recent collection for March sales were 14.3% and 41.1% above March collections for FY 2021 and FY 2020, respectively. November collections included an audit adjustment which represented 12% of collections for the month. Year to date collections are above budget for the year therefore the outlook is considered positive. Staff will continue to closely monitor collections. City of Southlake Monthly Financial Report 3 5/12/2022 GENERAL FUND REVENUE ANALYSIS (continued) PROPERTY TAX 3 YEAR TREND FY 2022 FY 2021 FY 2020 ■ FY 2022 ■ FY 2021 FY 2020 Oct $ 653,703 $ 778,578 $ 790,236 $14,000,000 Nov $ 2,017,203 $ 1,582,957 $ 1,426,054 $12,000,000 Dec $ 6,068,454 $ 6,036,699 $ 9,161,119 $10,000,000 Jan $ 11,588,414 $ 13,167,125 $ 10,088,389 $8,000,000 Feb $ 5,872,247 $ 4,445,041 $ 4,237,797 $6,000,000 Mar $ 584,684 $ 411,151 $ 420,930 Apr $ 554,247 $ 259,058 $ 55,958 $4,000,000 May $ - $ 152,945 $ 105,567 $2,000,000 .■ Jun $ $ 389,839 $ 448,670 $- Jul * $ - $ (1,365,991) $ (1,457,677) $(2,000,000) Oct Nov Dec Jan Feb Mar Apr May Jun Aug Aug $ $ 52,655 $ 52,000 $(4,000,000) Sep $ $ 190,848 $ 28,446 Tot $ 27,338,952 $ 26,100,905 $ 25,357,489 * Net transfer of TIF revenues to TIF CHART OUTLOOK: POSITIVE fund 2022 YTD property tax collections ($27,338,952) are higher than 2021 YTD ($26,680,609) and 2020 YTD ($26,180,483).as of April. As indicated on the chart, the majority of the property tax revenue is collected in the first few months of the fiscal year. YTD collections are trending slightly below budget. PERMIT REVENUE 2022-2020 COMPARISON FY 2022 FY 2021 FY 2020 FY 2022 FY 2021 FY 2020 Oct $ 214,445 $ 50,043 $ 134,067 $300,000 Nov $ 185,109 $ 69,734 $ 238,528 Dec $ 94,663 $ 102,515 $ 135,168 $250,000 Jan $ 167,045 $ 88,737 $ 204,931 Feb $ 111,545 $ 76,270 $ 212,195 Mar $ 154,046 $ 150,142 $ 126,842 $200,000 Apr $ 277,691 $ 124,870 $ 188,968 May $ - $ 136,364 $ 128,791 $150,000 Jun $ $ 158,786 $ 148,103 Jul $ - $ 170,985 $ 152,920 $100,000 Aug $ $ 217,599 $ 69,101 Sep $ $ 221,982 $ 246,547 $50,000 Tot $ 1,204,544 $ 1,568,027 $ 1,986,161 CHART OUTLOOK: POSITIVE Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep The value of new construction permits ($80.OM+) issued for FY 2022 YTD is approximately 53.2% and 48.4% higher when compared to FY 2021 and FY 2020, respectively. FY 2022 collections are 81.9% higher and 2.9% lower when compared to FY 2021 and 2020, respectively. The permit revenue year to date is trending above budget therefore the outlook is considered positive. City of Southlake Monthly Financial Report 4 5/12/2022 EXPENDITURE ANALYSIS DEPARTMENTAL EXPENDITURES SUMMARY FY 2022 ACTUAL FY 2021 ACTUAL YTD FY 2022 BUDGET FY 2021/2022 YTD YTD (APRIL) (APRIL) YTD (APRIL) VARIANCE BUDGET VARIANCE FY 2022 % SPENT CIVIC) $ 592,457 $ 462,618 $ 601,430 $ (129,839) $ 8,973 98.51% COMM $ 291,022 $ 275,110 $ 345,985 $ (15,912) $ 54,963 84.11% CS $ 3,074,964 $ 2,747,095 $ 3,819,147 $ (327,869) $ 744,183 80.51% CSO $ 302,103 $ 290,187 $ 351,628 $ (11,916) $ 49,525 85.92% DPS $ 10,498,585 $ 9,676,929 $ 11,510,796 $ (821,656) $ 1,012,211 91.21% ED $ 171,970 $ 87,576 $ 158,999 $ (84,394) $ (12,971) 108.16% FIN $ 1,451,603 $ 1,402,317 $ 1,595,371 $ (49,286) $ 143,768 90.99% HR $ 436,737 $ 470,968 $ 514,010 $ 34,231 $ 77,273 84.97% IT $ 1,934,439 $ 1,672,617 $ 2,209,195 $ (261,822) $ 274,756 87.56% PDS $ 1,186,168 $ 1,197,562 $ 6,344,573 $ 11,394 $ 5,158,405 18.70% PW $ 2,355,159 $ 2,276,283 $ 2,859,339 $ (78,876) $ 504,180 82.37% SS $ 1,090,684 $ 1,172,479 $ 1,362,630 $ 81,795 $ 271,946 80.04% Totals $ 23,385,891 $ 21,731,741 $ 31,673,103 $ (1,654,150) $ 8,287,212 73.84% FY 2022 ACTUAL YTD (APRIL) FY 2021 ACTUAL YTD (APRIL) FY 2022 BUDGET YTD (APRIL) $18,000,000 $16,000,000 $14,000,000 $12,000,000 $10,000,000 $8,000,000 $6,000,000 $4,000,000 $2,000,000 - $- CMO COMM CS CSO DPS ED FIN HR IT PDS PW SS CHART OUTLOOK: I POSITIVE As indicated above, 2022 expenditures are above 2021 expenditures for the same period with a increase of 7.1 % primarily due to DPS expenditures eligible for CARES/grant funding and reduction in programing cost in FY 2021.The outlook is positive expenditures are below budgeted expenditures for the fiscal year. mu - City of Southlake Monthly Financial Report 5 5/12/2022 HilitopSecurities Asset Management - City of Southlake Investment Portfolio Summary CITY OF SOUTHLAKE For the Quarter Ended March 31, 2022 Prepared by HilltopSecurities Asset Management J�* HilltopSecurities Asset Management., Report Name Certification Page Executive Summary Benchmark Comparison Detail of Security Holdings Change in Value Earned Income Investment Transactions Amortization and Accretion Projected Fixed Income Cash Flows MARKET RECAP - MARCH 2O22: The first quarter of 2022, capped by a dramatic March, brought substantial changes to the financial landscape. However, the change wasn't due to a shift in the economy's performance but rather a begrudging acknowledgement by policy makers that inflation has become a problem that must be dealt with. February's consumer price index, based entirely on conditions that predate Russia's actions in Ukraine, was up +7.9% year -over -year with the core rate up +6.4%. Both were 40-year highs that will track even higher in the months ahead as Russia's invasion of Ukraine has exacerbated inflationary pressures that were already boiling over. Russia is the world's second leading producer of oil behind the United States and the third leading wheat producer, with Ukraine checking in at #9. Ukraine is also a major corn producer, and the world's leader in sunflower production (Russian is #2). The war, together with sanctions against Russia, have taken much of that supply out of the market and sent prices skyward. The S&P GSCI, a global commodities price index, rose 29% in the first quarter and is up 55% over the last year. Meanwhile, U.S. employment conditions show no signs of moderating. The economy added another 678k jobs during February, taking the six-month tally to 3.5 million and pulling the unemployment rate down to 3.8%. Initial claims for unemployment benefits set new record lows during March while the Job Openings and Labor Turnover survey logged a third straight month with job openings above the 11 million mark. There are now 1.8 job openings for every officially unemployed American actively seeking work. On March 16th, the Federal Reserve's FOMC finally raised the fed funds target rate, though only by a modest 25 basis points, and also projected at least a 25 basis point rate hike at all six of the year's remaining meetings, while cracking open the door for larger increases if necessary. A few days later, Chair Powell blew the door open in a speech, saying, "The labor market is very strong, and inflation is much too high." He added, "There is an obvious need to move expeditiously to return the stance of monetary policy to a more neutral level, and then to move to more restrictive levels if that is what is required to restore price stability." Near the end of his speech, Powell was even more clear: "If the committee concludes that it is appropriate to move more aggressively by raising the federal funds rate by more than 25 bps at a meeting or meetings, we will do so." In the days that followed, Powell's hawkish message was repeated by a parade of Fed speakers, all indicating in one way or another that they were either in favor of, or open to, a series of larger 50 basis point hikes. Bond markets, already worried about inflation, were sent reeling by the Fed's abrupt shift to inflation fighting hawks. When the year began, fed funds futures were calling for a mere 75 basis points of hikes this year. By the end of March, fed funds futures were pricing in another 200 basis points of rate hikes and an implied fed funds rate of 2.40% by year end. The yield on the two-year Treasury note, which is very sensitive to monetary policy, shot up 90 basis points from 1.43% at the end of February to 2.34% at the end of March. The 10-year note rose 51 basis points to close at 2.34%. The first quarter will go down as one of the worst bond market performances ever. Page 2 of 17 J�* HilltopSecurities Asset Management_ For the Quarter Ended March 31, 2022 City of Southlake Investment Officers' Certification This report is prepared for the City of Southlake (the "Entity") in accordance with Chapter 2256 of the Texas Public Funds Investment Act ("PFIA"). Section 2256.023(a) of the PFIA states that: "Not less than quarterly, the investment officer shall prepare and submit to the governing body of the entity a written reporl of the investment transactions for all funds covered by this chapter for the preceding reporting period." This report is signed by the Entity's investment officers and includes the disclosures required in the PFIA. To the extent possible, market prices have been obtained from independent pricing sources. The investment portfolio complied with the PFIA and the Entity's approved Investment Policy and Strategy throughout the period. All investment transactions made in the portfolio during this period were made on behalf of the Entity and were made in full compliance with the PFIA and the approved Investment Policy. Officer Names and Titles: Sharen Jackson Name: Sharen Jackson Title: Chief Financial Officer Mary Morgan Name: Mary Morgan Title: Deputy Director of Finance Page 3 of 17 J�* HilltopSecurities Asset Management.. Beginning Values as of 12131/21 Par Value Market Value Book Value Unrealized Gain /(Loss) Market Value % Weighted Avg. YTW Weighted Avg. YTM 180,269,790.95 180,437,661.50 180,676,670.87 (239,009.37) 99.87% 0.162% 0.162% ■ US TREAS 26% ■ TEXPOOL 18% ■ TEXSTAR 10% ■ LONESTRGOV 7% ■ LONESTRCRP 6% ■ TOYMCC 5% ■ Other Issuers 28% Total: 100% Ending Values as of 03131122 191,850,585.86 190,876,044.88 192,190,771.04 (1,314,726.16) 99.32% 0.289% 0.289% 45% 40% 35% 30 % 25% 21% 20% 15% 10% 8% 5% 0% td Overnight 2 - 90 Days 91 - 180 6 - 12 1 - 2 Years 2 - 3 Years Days Months Weighted Average Days to Maturity: 179 City of Southlake Executive Summary As of 03/31/22 ■ AGCY BULLET 5% ■ AGCY CALL 3% ■ CID 19% ■ LGIP 44% ■ MUNICIPAL 4% ■ TREASURY 26% Total: 100% ■ A-1+ 19% ■ AAA 81% Total: 100% Print Date: 4/25/2022 Print Time: 9:11 pm Page 4 of 17 Page 1 of 1 J�w HilltopSecurities Asset Management_ 0.70% 0.60% 0.50% 0.40% 0.30% 0.20% 0.10% City of Southlake Benchmark Comparison As of 0313112022 r . o Oct-20 Nov-20 Dec-20 Jan-21 Feb-21 Mar-21 Apr-21 May-21 Jun-21 Jul-21 Aug-21 Sep-21 Oct-21 Nov-21 Dec-21 Jan-22 Feb-22 Mar-22 �— 1 YR CMT 3-MO CMT 6-MO CMT - TEXPOOL f City of Southlake Note 1: CMT stands for Constant Maturity Treasury. This data is published in Federal Reserve Statistical Release H.15 and represents an average of all actively traded Treasury securities having that time remaining until maturity. This is a standard industry benchmark for Treasury securities. The CMT benchmarks are moving averages. The 3-month CMT is the daily average for the previous 3 months, the 6-month CMT is the daily average for the previous 6 months, and the 1-year and 2-year CMTs are the daily averages for the previous 12-months. Note 2: Benchmark data for TexPool is the monthly average yield. Print Date: 4/25/2022 Print Time: 9:12 pm Page 1 of 1 Page 5 of 17 J�* HilltopSecurities Asset Management. City of Southlake Detail of Security Holdings As of 0313112022 Settle Purch Mkt Days Days CUSIP Date Sec. Type Sec. Description CPN Mty Date Next Call Call Type Par Value Price Orig Cost Book Value Price Market Value to Mty to Call YTM YTW General Operating M LNSTCRP LGIP LoneStar Corp O/N 12,140,957.26 100.000 12,140,957.26 12,140,957.26 100.000 12,140,957.26 1 0.245 0.245 LNSTGOV LGIP LoneStar Gov O/N 12,718,791.62 100.000 12,718,791.62 12,718,791.62 100.000 12,718,791.62 1 0.113 0.113 TEXPOOL LGIP TexPool 34,437,129.97 100.000 34,437,129.97 34,437,129.97 100.000 34,437,129.97 1 0.154 0.154 TEXSTAR LGIP TexSTAR 19,248,402.33 100.000 19,248,402.33 19,248,402.33 100.000 19,248,402.33 1 0.107 0.107 TXCLASS LGIP Texas CLASS 5,320,304.68 100.000 5,320,304.68 5,320,304.68 100.000 5,320,304.68 1 0.286 0.286 48306BD51 10/05/21 CP - DISC Kaiser Foundation Hospital 04/05/22 5,000,000.00 99.939 4,996,966.67 4,999,933.35 99.995 4,999,754.00 5 0.120 0.120 89233HDN1 07/27/21 CP- DISC Toyota MtrCr 04/22/22 5,000,000.00 99.888 4,994,395.83 4,999,562.50 99.972 4,998,594.50 22 0.150 0.150 07286NFG9 03/17/22 CP - DISC Baylor Univ 06/16/22 5,000,000.00 99.810 4,990,520.83 4,992,083.35 99.850 4,992,514.00 77 0.751 0.751 46640QG13 10/05/21 CP - DISC J.P.Morgan Sec 07/01/22 5,000,000.00 99.873 4,993,648.61 4,997,851.40 99.747 4,987,363.00 92 0.170 0.170 91512DG13 10/05/21 CP - DISC Univ of TX 07/01/22 5,000,000.00 99.895 4,994,769.44 4,998,230.55 99.762 4,988,116.50 92 0.140 0.140 89233HHK3 11/23/21 CP - DISC Toyota Mtr Cr 08/19/22 5,000,000.00 99.768 4,988,418.06 4,993,972.20 99.540 4,977,009.00 141 0.311 0.311 92181PJE3 01/12/22 CP - DISC Vanderbilt Univ 09/14/22 3,000,000.00 99.728 2,991,833.33 2,994,466.68 99.402 2,982,047.40 167 0.401 0.401 912828YF1 09/28/21 TREAS NOTE U.S. Treasury 1.500 09/15/22 5,000,000.00 101.363 5,068,164.06 5,032,091.95 100.238 5,011,914.00 168 0.085 0.085 912828YKO 02/10/22 TREAS NOTE U.S. Treasury 1.375 10/15/22 5,000,000.00 100.449 5,022,460.94 5,017,911.75 100.121 5,006,054.50 198 0.707 0.707 912828TY6 09/28/21 TREAS NOTE U.S. Treasury 1.625 11/15/22 5,000,000.00 101.707 5,085,351.56 5,046,941.65 100.211 5,010,547.00 229 0.113 0.113 92181PM17 03/09/22 CP - DISC Vanderbilt Univ 12/01/22 3,000,000.00 99.184 2,975,525.00 2,977,633.32 98.761 2,962,841.70 245 1.109 1.109 912828YW4 02/10/22 TREAS NOTE U.S. Treasury 1.625 12/15/22 5,000,000.00 100.684 5,034,179.69 5,028,628.40 100.191 5,009,570.50 259 0.810 0.810 91282CBG5 02/02/22 TREAS NOTE U.S. Treasury 0.125 01/31/23 2,000,000.00 99.344 1,986,875.00 1,988,985.42 98.816 1,976,328.20 306 0.789 0.789 912828ZD5 10/15/21 TREAS NOTE U.S. Treasury 0.500 03/15/23 5,000,000.00 100.402 5,020,117.19 5,013,547.05 98.906 4,945,312.50 349 0.215 0.215 912828ZH6 10/14/21 TREAS NOTE U.S. Treasury 0.250 04/15/23 5,000,000.00 100.008 5,000,390.63 5,000,270.10 98.465 4,923,242.00 380 0.245 0.245 8821356W1 10/28/20 MUNICIPAL Texas A&M Univ 5.000 05/15/23 2,500,000.00 112.026 2,800,650.00 2,632,696.20 103.726 2,593,142.75 410 0.260 0.260 3133EMH96 06/25/21 AGCY BULET FFCB 0.125 06/14/23 5,000,000.00 99.713 4,985,650.00 4,991,227.75 97.838 4,891,897.00 440 0.271 0.271 912828ZY9 12/15/21 TREAS NOTE U.S. Treasury 0.125 07/15/23 5,000,000.00 99.359 4,967,968.75 4,973,900.15 97.605 4,880,273.50 471 0.532 0.532 91282CCU3 08/31/21 TREAS NOTE U.S. Treasury 0.125 08/31/23 4,000,000.00 99.766 3,990,625.00 3,993,371.84 97.289 3,891,562.40 518 0.243 0.243 91282CAK7 08/26/21 TREAS NOTE U.S. Treasury 0.125 09/15/23 4,000,000.00 99.750 3,990,000.00 3,992,918.28 97.160 3,886,406.40 533 0.247 0.247 91282CAP6 10/14/21 TREAS NOTE U.S. Treasury 0.125 10/15/23 5,000,000.00 99.535 4,976,757.81 4,982,131.35 96.918 4,845,898.50 563 0.358 0.358 3133ENDR8 11/15/21 AGCY BULET FFCB 0.400 11/09/23 5,000,000.00 99.713 4,985,665.00 4,988,384.60 97.369 4,868,436.00 588 0.546 0.546 313OAQAFO 12/22/21 AGCY CALL FHLB 0.800 12/22/23 6/22/2022 QRTLY 5,000,000.00 100.000 5,000,000.00 5,000,000.00 97.944 4,897,192.50 631 83 0.800 0.800 88213AKBO 09/29/20 MUNICIPAL Texas A&M Univ 2.549 05/15/24 4,485,000.00 107.731 4,831,735.35 4,688,445.34 99.988 4,484,441.17 776 0.400 0.400 Total for General Operating 191,850,585.86 100.375 192,538,254.61 192,190,771.04 99.497 190,876,044.88 179 0.289 0.289 Print Date: 4/25/2022 Print Time: 9:13 pm Page 1 of 2 Page 6 of 17 J�* HilltopSecurities Asset Management. City of Southlake Detail of Security Holdings As of 03/31/2022 Settle Purch Mkt Days Days CUSIP Date Sec. Type Sec. Description CPN Mty Date Next Call Call Type Par Value Price Orig Cost Book Value Price Market Value to Mty to Call YTM YTW Total for City of Southlake 191,850,585.86 100.375 192,538,254.61 192,190,771.04 99.497 190,876,044.88 179 0.289 0.289 Print Date: 4/25/2022 Print Time: 9:13 pm Page 2 of 2 Page 7 of 17 J�* HilltopSecurities Asset Management. City of Southlake Change in Value From 1213112021 to 03/31/2022 CUSIP Security Type Security Description 12/31121 Cost of Maturities / Amortization I Realized 03/31122 12/31121 03/31122 Change in Book Value Purchases Calls I Sales Accretion Gainl(Loss) Book Value Market Value Market Value Mkt Value Community Enhancement Dev Co� TEXPOOL LGIP TexPool 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total for Community Enhancement Dev Corp 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Crime Control District TEXSTAR LGIP TexSTAR 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total for Crime Control District General Operating LNSTCRP LGIP LoneStar Corp O/N LNSTGOV LGIP LoneStar Gov O/N TEXPOOL LGIP TexPool TEXSTAR LGIP TexSTAR TXCLASS LGIP Texas CLASS 92181 PACE CP - DISC Vanderbilt Univ 0.000 01/12/22 8826691306 MUNICIPAL TX Pub Fin Auth 0.219 02/01/22 92181 PC91 CP - DISC Vanderbilt Univ 0.000 03/09/22 07286NCHO CP - DISC Baylor Univ 0.000 03/17/22 48306BD51 CP - DISC Kaiser Foundation Hospital 0.000 04/05/22 89233HDN1 CP - DISC Toyota Mtr Cr 0.000 04/22/22 07286NFG9 CP - DISC Baylor Univ 0.000 06/16/22 46640QG13 CP - DISC J.P.Morgan Sec 0.000 07/01/22 91512DG13 CP - DISC Univ of TX 0.000 07/01/22 89233HHK3 CP - DISC Toyota Mtr Cr 0.000 08/19/22 92181 PJE3 CP - DISC Vanderbilt Univ 0.000 09/14/22 912828YF1 TREAS NOTE U.S. Treasury 1.500 09/15/22 912828YKO TREAS NOTE U.S. Treasury 1.375 10/15/22 912828TY6 TREAS NOTE U.S. Treasury 1.625 11/15/22 92181PM17 CP - DISC Vanderbilt Univ 0.000 12/01/22 912828YW4 TREAS NOTE U.S. Treasury 1.625 12/15/22 91282CBG5 TREAS NOTE U.S. Treasury 0.125 01/31/23 912828ZD5 TREAS NOTE U.S. Treasury 0.500 03/15/23 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 12,136,428.09 4,529.17 0.00 0.00 0.00 12,140,957.26 12,136,428.09 12,140,957.26 4,529.17 12,717,299.63 1,491.99 0.00 0.00 0.00 12,718,791.62 12,717,299.63 12,718,791.62 1,491.99 32,866,649.45 13,505,852.59 (11,935,372.07) 0.00 0.00 34,437,129.97 32,866,649.45 34,437,129.97 1,570,480.52 19,246,337.20 2,065.13 0.00 0.00 0.00 19,248,402.33 19,246,337.20 19,248,402.33 2,065.13 5,318,076.58 2,228.10 0.00 0.00 0.00 5,320,304.68 5,318,076.58 5,320,304.68 2,228.10 2,999,908.32 0.00 (3,000,000.00) 91.68 0.00 0.00 2,999,870.10 0.00 (2,999,870.10) 2,000,000.00 0.00 (2,000,000.00) 0.00 0.00 0.00 1,999,940.00 0.00 (1,999,940.00) 2,999,274.18 0.00 (3,000,000.00) 725.82 0.00 0.00 2,998,923.30 0.00 (2,998,923.30) 4,998,958.35 0.00 (5,000,000.00) 1,041.65 0.00 0.00 4,997,255.50 0.00 (4,997,255.50) 4,998,433.35 0.00 0.00 1,500.00 0.00 4,999,933.35 4,996,370.00 4,999,754.00 3,384.00 4,997,687.50 0.00 0.00 1,875.00 0.00 4,999,562.50 4,997,245.00 4,998,594.50 1,349.50 0.00 4,990,520.83 0.00 1,562.52 0.00 4,992,083.35 0.00 4,992,514.00 4,992,514.00 4,995,726.40 0.00 0.00 2,125.00 0.00 4,997,851.40 4,990,620.00 4,987,363.00 (3,257.00) 4,996,480.55 0.00 0.00 1,750.00 0.00 4,998,230.55 4,990,394.50 4,988,116.50 (2,278.00) 4,990,097.20 0.00 0.00 3,875.00 0.00 4,993,972.20 4,992,075.00 4,977,009.00 (15,066.00) 0.00 2,991,833.33 0.00 2,633.35 0.00 2,994,466.68 0.00 2,982,047.40 2,982,047.40 5,049,613.50 0.00 0.00 (17,521.55) 0.00 5,032,091.95 5,042,775.00 5,011,914.00 (30,861.00) 0.00 5,022,460.94 0.00 (4,549.19) 0.00 5,017,911.75 0.00 5,006,054.50 5,006,054.50 5,065,709.75 0.00 0.00 (18,768.10) 0.00 5,046,941.65 5,053,515.00 5,010,547.00 (42,968.00) 0.00 2,975,525.00 0.00 2,108.32 0.00 2,977,633.32 0.00 2,962,841.70 2,962,841.70 0.00 5,034,179.69 0.00 (5,551.29) 0.00 5,028,628.40 0.00 5,009,570.50 5,009,570.50 0.00 1,986,875.00 0.00 2,110.42 0.00 1,988,985.42 0.00 1,976,328.20 1,976,328.20 5,017,062.05 0.00 0.00 (3,515.00) 0.00 5,013,547.05 5,001,955.00 4,945,312.50 (56,642.50) Print Date: 4/25/2022 Print Time: 9:13 pm Page 1 of 2 Page 8 of 17 J�* HilltopSecurities Asset Management. City of Southlake Change in Value From 1213112021 to 03/31/2022 CUSIP Security Type Security Description 12/31121 Cost of Maturities / Amortization I Realized 03/31122 12/31121 03/31122 Change in Book Value Purchases Calls I Sales Accretion Gainl(Loss) Book Value Market Value Market Value Mkt Value General Operatin 912828ZH6 TREAS NOTE U.S. Treasury 0.250 04/15/23 5,000,334.30 0.00 0.00 (64.20) 0.00 5,000,270.10 4,983,400.00 4,923,242.00 (60,158.00) 8821356W1 MUNICIPAL Texas A&MUniv 5.000 05/15/23 2,662,205.93 0.00 0.00 (29,509.73) 0.00 2,632,696.20 2,662,675.00 2,593,142.75 (69,532.25) 3133EMH96 AGCY BULET FFCB 0.125 06/14/23 4,989,407.50 0.00 0.00 1,820.25 0.00 4,991,227.75 4,985,274.00 4,891,897.00 (93,377.00) 912828ZY9 TREAS NOTE U.S. Treasury 0.125 07/15/23 4,968,899.35 0.00 0.00 5,000.80 0.00 4,973,900.15 4,964,260.00 4,880,273.50 (83,986.50) 91282CCU3 TREAS NOTE U.S. Treasury 0.125 08/31/23 3,992,214.84 0.00 0.00 1,157.00 0.00 3,993,371.84 3,965,156.00 3,891,562.40 (73,593.60) 91282CAK7 TREAS NOTE U.S. Treasury 0.125 09/15/23 3,991,713.68 0.00 0.00 1,204.60 0.00 3,992,918.28 3,963,752.00 3,886,406.40 (77,345.60) 91282CAP6 TREAS NOTE U.S. Treasury 0.125 10/15/23 4,979,269.60 0.00 0.00 2,861.75 0.00 4,982,131.35 4,950,585.00 4,845,898.50 (104,686.50) 3133ENDR8 AGCY BULET FFCB 0.400 11/09/23 4,986,584.85 0.00 0.00 1,799.75 0.00 4,988,384.60 4,972,766.00 4,868,436.00 (104,330.00) 313OAQAFO AGCY CALL FHLB 0.800 12/22/23 5,000,000.00 0.00 0.00 0.00 0.00 5,000,000.00 5,001,685.50 4,897,192.50 (104,493.00) 88213AKBO MUNICIPAL Texas A&M Univ 2.549 05/15/24 4,712,298.72 0.00 0.00 (23,853.38) 0.00 4,688,445.34 4,642,378.65 4,484,441.17 (157,937.48) Total for General Operating 180,676,670.87 36,517,561.77 (24,935,372.07) (68,089.53) 0.00 192,190,771.04 180,437,661.50 190,876,044.88 10,438,383.38 TEXPOOL LGIP TexPool 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 TEXSTAR LGIP TexSTAR 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total for Parks Development Corporation 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total for City of South lake 180,676,670.87 36,517,561.77 (24,935,372.07) (68,089.53) 0.00 192,190,771.04 180,437,661.50 190,876,044.88 10,438,383.38 Print Date: 4/25/2022 Print Time: 9:13 pm Page 2 of 2 Page 9 of 17 J�* HilltopSecurities Asset Management.. City of Southlake Earned Income From 1213112021 to 03/31/2022 CUSIP Security Type Security Description Beg. Accrued Interest Earned Interest Rec'd I Interest Purchased Ending Accrued Disc Accr / Net Income Sold I Matured Prem Amort Community Enhancement Dev Corp Total for Community Enhancement Dev Corp Crime Control District 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total for Crime Control District 0.00 0.00 0.00 0.00 0.00 0.00 0.00 General Operating LNSTCRP LGIP LoneStar Corp O/N 0.00 4,529.17 4,529.17 0.00 0.00 0.00 4,529.17 LNSTGOV LGIP LoneStar GovO/N 0.00 1,491.99 1,491.99 0.00 0.00 0.00 1,491.99 TEXPOOL LGIP TexPool 0.00 7,696.73 7,696.73 0.00 0.00 0.00 7,696.73 TEXSTAR LGIP TexSTAR 0.00 2,065.13 2,065.13 0.00 0.00 0.00 2,065.13 TXCLASS LGIP Texas CLASS 0.00 2,228.10 2,228.10 0.00 0.00 0.00 2,228.10 92181 PAC6 CP - DISC Vanderbilt Univ 0.000 01/12/22 0.00 0.00 0.00 0.00 0.00 91.68 91.68 882669BQ6 MUNICIPAL TX Pub Fin Auth 0.219 02/01/22 1,825.00 365.00 2,190.00 0.00 0.00 0.00 365.00 92181 PC91 CP - DISC Vanderbilt Univ 0.000 03/09/22 0.00 0.00 0.00 0.00 0.00 725.82 725.82 07286NCHO CP - DISC Baylor Univ 0.000 03/17/22 0.00 0.00 0.00 0.00 0.00 1,041.65 1,041.65 48306BD51 CP - DISC Kaiser Foundation Hospital 0.000 04/05/22 0.00 0.00 0.00 0.00 0.00 1,500.00 1,500.00 89233HDN1 CP - DISC Toyota Mtr Cr 0.000 04/22/22 0.00 0.00 0.00 0.00 0.00 1,875.00 1,875.00 07286NFG9 CP - DISC Baylor Univ 0.000 06/16/22 0.00 0.00 0.00 0.00 0.00 1,562.52 1,562.52 46640QG13 CP - DISC J.P.MorganSec 0.000 07/01/22 0.00 0.00 0.00 0.00 0.00 2,125.00 2,125.00 91512DG13 CP - DISC Univ of TX 0.000 07/01/22 0.00 0.00 0.00 0.00 0.00 1,750.00 1,750.00 89233HHK3 CP - DISC Toyota Mtr Cr 0.000 08/19/22 0.00 0.00 0.00 0.00 0.00 3,875.00 3,875.00 92181 PJE3 CP - DISC Vanderbilt Univ 0.000 09/14/22 0.00 0.00 0.00 0.00 0.00 2,633.35 2,633.35 912828YF1 TREAS NOTE U.S. Treasury 1.500 09/15/22 22,375.69 18,588.98 37,500.00 0.00 3,464.67 (17,521.55) 1,067.43 912828YKO TREAS NOTE U.S. Treasury 1.375 10/15/22 0.00 9,443.68 0.00 (22,287.09) 31,730.77 (4,549.19) 4,894.49 912828TY6 TREAS NOTE U.S. Treasury 1.625 11/15/22 10,549.03 20,200.28 0.00 0.00 30,749.31 (18,768.10) 1,432.18 92181PM17 CP - DISC Vanderbilt Univ 0.000 12/01/22 0.00 0.00 0.00 0.00 0.00 2,108.32 2,108.32 912828YW4 TREAS NOTE U.S. Treasury 1.625 12/15/22 0.00 11,160.72 0.00 (12,723.21) 23,883.93 (5,551.29) 5,609.43 91282CBG5 TREAS NOTE U.S. Treasury 0.125 01/31/23 0.00 400.55 0.00 (13.81) 414.36 2,110.42 2,510.97 912828ZD5 TREAS NOTE U.S. Treasury 0.500 03/15/23 7,458.56 6,196.33 12,500.00 0.00 1,154.89 (3,515.00) 2,681.33 912828ZH6 TREAS NOTE U.S. Treasury 0.250 04/15/23 2,678.57 3,090.66 0.00 0.00 5,769.23 (64.20) 3,026.46 8821356W1 MUNICIPAL Texas A&MUniv 5.000 05/15/23 15,972.22 31,250.00 0.00 0.00 47,222.22 (29,509.73) 1,740.27 3133EMH96 AGCY BULET FFCB 0.125 06/14/23 295.14 1,562.50 0.00 0.00 1,857.64 1,820.25 3,382.75 Print Date: 4/25/2022 Print Time: 9:13 pm Page 1 of 2 Page 10 of 17 J�* HilltopSecurities Asset Management. City of Southlake Earned Income From 1213112021 to 03/31/2022 CUSIP Security Type Security Description Beg. Accrued Interest Earned Interest Rec'd I Interest Purchased Ending Accrued Disc Accr / Net Income Sold I Matured Prem Amort General Operating 912828ZY9 TREAS NOTE U.S. Treasury 0.125 07/15/23 2,887.23 1,549.92 3,125.00 0.00 1,312.15 5,000.80 6,550.72 91282CCU3 TREAS NOTE U.S. Treasury 0.125 08/31/23 1,698.90 1,235.88 2,500.00 0.00 434.78 1,157.00 2,392.88 91282CAK7 TREAS NOTE U.S. Treasury 0.125 09/15/23 1,491.71 1,239.27 2,500.00 0.00 230.98 1,204.60 2,443.87 91282CAP6 TREAS NOTE U.S. Treasury 0.125 10/15/23 1,339.29 1,545.33 0.00 0.00 2,884.62 2,861.75 4,407.08 3133ENDR8 AGCY BULET FFCB 0.400 11/09/23 2,888.89 5,000.00 0.00 0.00 7,888.89 1,799.75 6,799.75 3130AGAFO AGCY CALL FHLB 0.800 12/22/23 1,000.00 10,000.00 0.00 0.00 11,000.00 0.00 10,000.00 88213AKBO MUNICIPAL Texas A&MUniv 2.549 05/15/24 14,607.89 28,580.67 0.00 0.00 43,188.56 (23,853.38) 4,727.29 Total for General Operating 87,068.12 169,420.89 78,326.12 (35,024.11) 213,187.00 (68,089.53) 101,331.36 Parks Development Corporation M Total for Parks Development Corporation 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total for City of Southlake 87,068.12 169,420.89 78,326.12 (35,024.11) 213,187.00 (68,089.53) 101,331.36 Print Date: 4/25/2022 Print Time: 9:13 pm Page 2 of 2 Page 11 of 17 J�w HilltopSecurities Asset Management. City of Southlake Investment Transactions From 0110112022 to 03/31/2022 Trade Settle Security Principal Int Purchased / Realized Date Date CUSIP Type Security Description Coupon Mty Date Call Date Par Value Price Amount Received Total Amount Gain / Loss YTM YTW Maturities 01/12/22 01/12/22 92181PAC6 CP - DISC Vanderbilt Univ 01/12/22 3,000,000.00 100.000 3,000,000.00 0.00 3,000,000.00 0.100 02/01/22 02/01/22 882669BQ6 MUNICIPAL TX Pub Fin Auth 0.219 02/01/22 2,000,000.00 100.000 2,000,000.00 0.00 2,000,000.00 0.219 03/09/22 03/09/22 92181 PC91 CP - DISC Vanderbilt Univ 03/09/22 3,000,000.00 100.000 3,000,000.00 0.00 3,000,000.00 0.130 03/17/22 03/17/22 07286NCHO CP - DISC Baylor Univ 03/17/22 5,000,000.00 100.000 5,000,000.00 0.00 5,000,000.00 0.100 Total for: Maturities 13,000,000.00 13,000,000.00 0.00 13,000,000.00 0.125 Purchases 01/12/22 01/12/22 92181PJE3 CP - DISC Vanderbilt Univ 09/14/22 3,000,000.00 99.728 2,991,833.33 0.00 2,991,833.33 0.401 0.401 02/01/22 02/02/22 91282CBG5 TREAS NOTE U.S. Treasury 0.125 01/31/23 2,000,000.00 99.344 1,986,875.00 13.81 1,986,888.81 0.789 0.789 02/09/22 02/10/22 912828YKO TREAS NOTE U.S. Treasury 1.375 10/15/22 5,000,000.00 100.449 5,022,460.94 22,287.09 5,044,748.03 0.707 0.707 02/09/22 02/10/22 912828YW4 TREAS NOTE U.S. Treasury 1.625 12/15/22 5,000,000.00 100.684 5,034,179.69 12,723.21 5,046,902.90 0.810 0.810 03/09/22 03/09/22 92181PM17 CP - DISC Vanderbilt Univ 12/01/22 3,000,000.00 99.184 2,975,525.00 0.00 2,975,525.00 1.109 1.109 03/17/22 03/17/22 07286NFG9 CP - DISC Baylor Univ 06/16/22 5,000,000.00 99.810 4,990,520.83 0.00 4,990,520.83 0.751 0.751 Total for: Purchases 23,000,000.00 23,001,394.79 35,024.11 23,036,418.90 0.759 0.759 Income Payments 01/18/22 01/15/22 912828ZY9 TREAS NOTE U.S. Treasury 0.125 07/15/23 0.00 3,125.00 3,125.00 02/01/22 02/01/22 882669BQ6 MUNICIPAL TX Pub Fin Auth 0.219 02/01/22 0.00 2,190.00 2,190.00 02/28/22 02/28/22 91282CCU3 TREAS NOTE U.S. Treasury 0.125 08/31/23 0.00 2,500.00 2,500.00 03/15/22 03/15/22 912828YF1 TREAS NOTE U.S. Treasury 1.500 09/15/22 0.00 37,500.00 37,500.00 03/15/22 03/15/22 912828ZD5 TREAS NOTE U.S. Treasury 0.500 03/15/23 0.00 12,500.00 12,500.00 03/15/22 03/15/22 91282CAK7 TREAS NOTE U.S. Treasury 0.125 09/15/23 0.00 2,500.00 2,500.00 Total for: Income Payments 0.00 60,315.00 60,315.00 Print Date: 4/25/2022 Print Time: 9:13 pm Page 12 of 17 Page 1 of 2 J�w HilltopSecurities Asset Management. City of Southlake Investment Transactions From 0110112022 to 03/31/2022 Trade Settle Security Principal Int Purchased 1 Realized Date Date CUSIP Type Security Description Coupon Mty Date Call Date Par Value Price Amount Received Total Amount Gain I Loss YTM YTW Transaction Type Quantity Total Amount Realized GIL YTM YTW Total Maturities 13,000,000.00 Total Purchases 23,000,000.00 Total Income Payments 0.00 13,000,000.00 0.125 23,036,418.90 0.759 60,315.00 0.759 Print Date: 4/25/2022 Print Time: 9:13 pm Page 13 of 17 Page 2 of 2 J�* HilltopSecurities Asset Management. City of Southlake Amortization and Accretion From 1213112021 to 03/31/2022 Orig Amrt/Accr Total Amrt/Accr Remaining CUSIP Settle Date Security Type Security Description Next Call Date Purchase City Price Original Cost for Period Since Purch Disc I Prem Book Value 92181 PAC6 07/12/21 CP - DISC Vanderbilt Univ 0.000 01/12/22 0.00 99.949 0.00 91.68 0.00 0.00 0.00 882669BQ6 12/23/20 MUNICIPAL TX Pub Fin Auth 0.219 02/01/22 0.00 100.000 0.00 0.00 0.00 0.00 0.00 92181 PC91 07/12/21 CP - DISC Vanderbilt Univ 0.000 03/09/22 0.00 99.913 0.00 725.82 0.00 0.00 0.00 07286NCHO 10/20/21 CP - DISC Baylor Univ 0.000 03/17/22 0.00 99.959 0.00 1,041.65 0.00 0.00 0.00 48306BD51 10/05/21 CP - DISC Kaiser Foundation Hospital 0.000 04/05/22 5,000,000.00 99.939 4,996,966.67 1,500.00 2,966.68 66.65 4,999,933.35 89233HDN1 07/27/21 CP - DISC Toyota Mtr Cr 0.000 04/22/22 5,000,000.00 99.888 4,994,395.83 1,875.00 5,166.67 437.50 4,999,562.50 07286NFG9 03/17/22 CP - DISC Baylor Univ 0.000 06/16/22 5,000,000.00 99.810 4,990,520.83 1,562.52 1,562.52 7,916.65 4,992,083.35 46640QG13 10/05/21 CP - DISC J.P.Morgan Sec 0.000 07/01/22 5,000,000.00 99.873 4,993,648.61 2,125.00 4,202.79 2,148.60 4,997,851.40 91512DG13 10/05/21 CP - DISC Univ of TX 0.000 07/01/22 5,000,000.00 99.895 4,994,769.44 1,750.00 3,461.11 1,769.45 4,998,230.55 89233HHK3 11/23/21 CP - DISC Toyota Mtr Cr 0.000 08/19/22 5,000,000.00 99.768 4,988,418.06 3,875.00 5,554.14 6,027.80 4,993,972.20 92181 PJE3 01/12/22 CP - DISC Vanderbilt Univ 0.000 09/14/22 3,000,000.00 99.728 2,991,833.33 2,633.35 2,633.35 5,533.32 2,994,466.68 912828YF1 09/28/21 TREAS NOTE U.S. Treasury 1.500 09/15/22 5,000,000.00 101.363 5,068,164.06 (17,521.55) (36,072.11) (32,091.95) 5,032,091.95 912828YKO 02/10/22 TREAS NOTE U.S. Treasury 1.375 10/15/22 5,000,000.00 100.449 5,022,460.94 (4,549.19) (4,549.19) (17,911.75) 5,017,911.75 912828TY6 09/28/21 TREAS NOTE U.S. Treasury 1.625 11/15/22 5,000,000.00 101.707 5,085,351.56 (18,768.10) (38,409.91) (46,941.65) 5,046,941.65 92181PM17 03/09/22 CP - DISC Vanderbilt Univ 0.000 12/01/22 3,000,000.00 99.184 2,975,525.00 2,108.32 2,108.32 22,366.68 2,977,633.32 912828YW4 02/10/22 TREAS NOTE U.S. Treasury 1.625 12/15/22 5,000,000.00 100.684 5,034,179.69 (5,551.29) (5,551.29) (28,628.40) 5,028,628.40 91282CBG5 02/02/22 TREAS NOTE U.S. Treasury 0.125 01/31/23 2,000,000.00 99.344 1,986,875.00 2,110.42 2,110.42 11,014.58 1,988,985.42 912828ZD5 10/15/21 TREAS NOTE U.S. Treasury 0.500 03/15/23 5,000,000.00 100.402 5,020,117.19 (3,515.00) (6,570.14) (13,547.05) 5,013,547.05 912828ZH6 10/14/21 TREAS NOTE U.S. Treasury 0.250 04/15/23 5,000,000.00 100.008 5,000,390.63 (64.20) (120.53) (270.10) 5,000,270.10 8821356W1 10/28/20 MUNICIPAL Texas A&M Univ 5.000 05/15/23 2,500,000.00 112.026 2,800,650.00 (29,509.73) (167,953.80) (132,696.20) 2,632,696.20 3133EMH96 06/25/21 AGCY BULET FFCB 0.125 06/14/23 5,000,000.00 99.713 4,985,650.00 1,820.25 5,577.75 8,772.25 4,991,227.75 912828ZY9 12/15/21 TREAS NOTE U.S. Treasury 0.125 07/15/23 5,000,000.00 99.359 4,967,968.75 5,000.80 5,931.40 26,099.85 4,973,900.15 91282CCU3 08/31/21 TREAS NOTE U.S. Treasury 0.125 08/31/23 4,000,000.00 99.766 3,990,625.00 1,157.00 2,746.84 6,628.16 3,993,371.84 91282CAK7 08/26/21 TREAS NOTE U.S. Treasury 0.125 09/15/23 4,000,000.00 99.750 3,990,000.00 1,204.60 2,918.28 7,081.72 3,992,918.28 91282CAP6 10/14/21 TREAS NOTE U.S. Treasury 0.125 10/15/23 5,000,000.00 99.535 4,976,757.81 2,861.75 5,373.54 17,868.65 4,982,131.35 3133ENDRB 11/15/21 AGCY BULET FFCB 0.400 11/09/23 5,000,000.00 99.713 4,985,665.00 1,799.75 2,719.60 11,615.40 4,988,384.60 313OAQAFO 12/22/21 AGCY CALL FHLB 0.800 12/22/23 06/22/22 5,000,000.00 100.000 5,000,000.00 0.00 0.00 0.00 5,000,000.00 88213AKBO 09/29/20 MUNICIPAL Texas A&MUniv 2.549 05/15/24 4,485,000.00 107.731 4,831,735.35 (23,853.38) (143,290.01) (203,445.34) 4,688,445.34 Total for General Operating 107,985,000.00 108,672,668.75 (68,089.53) (347,483.57) (340,185.18) 108,325,185.18 Print Date: 4/25/2022 Print Time: 9:13 pm Page 1 of 2 Page 14 of 17 J�w HilltopSecurities Asset Management_ City of Southlake Amortization and Accretion From 1213112021 to 03/31/2022 Orig AmrtIAccr Total Amrt/Accr Remaining CUSIP Settle Date Security Type Security Description Next Call Date Purchase Qty Price Original Cost for Period Since Purch Disc 1 Prem Book Value Total for City of Southlake 107,985,000.00 108,672,668.75 (68,089.53) (347,483.57) (340,185.18) 108,325,185.18 Print Date: 4/25/2022 Print Time: 9:13 pm Page 2 of 2 Page 15 of 17 J�* HilltopSecurities Asset Management.. City of Southlake Projected Cash Flows Cash Flows for next 180 days from 03/31/2022 CUSIP Security Type Security Description Pay Date Interest Principal Total Amount General Operating 11111111� 48306BD51 CP - DISC Kaiser Foundation Hospital 0.000 04/05/22 04/05/22 0.00 5,000,000.00 5,000,000.00 912828YKO TREAS NOTE U.S. Treasury 1.375 10/15/22 04/15/22 34,375.00 0.00 34,375.00 912828ZH6 TREAS NOTE U.S. Treasury 0.250 04/15/23 04/15/22 6,250.00 0.00 6,250.00 91282CAP6 TREAS NOTE U.S. Treasury 0.125 10/15/23 04/15/22 3,125.00 0.00 3,125.00 89233HDN1 CP - DISC Toyota Mtr Cr 0.000 04/22/22 04/22/22 0.00 5,000,000.00 5,000,000.00 3133ENDR8 AGCY BULET FFCB 0.400 11/09/23 05/09/22 10,000.00 0.00 10,000.00 8821356W1 MUNICIPAL Texas A&M Univ 5.000 05/15/23 05/15/22 62,500.00 0.00 62,500.00 88213AKBO MUNICIPAL Texas A&MUniv 2.549 05/15/24 05/15/22 57,161.32 0.00 57,161.32 912828TY6 TREAS NOTE U.S. Treasury 1.625 11/15/22 05/15/22 40,625.00 0.00 40,625.00 3133EMH96 AGCY BULET FFCB 0.125 06/14/23 06/14/22 3,125.00 0.00 3,125.00 912828YW4 TREAS NOTE U.S. Treasury 1.625 12/15/22 06/15/22 40,625.00 0.00 40,625.00 07286NFG9 CP - DISC Bavlor Univ 0.000 06/16/22 06/16/22 0.00 5,000,000.00 5,000,000.00 313OAQAFO AGCY CALL FHLB 0.800 12/22/23 06/22/22 20,000.00 0.00 20,000.00 46640QG13 CP - DISC J.P.Morgan Sec 0.000 07/01/22 07/01/22 0.00 5,000,000.00 5,000,000.00 91512DG13 CP - DISC Univ of TX 0.000 07/01/22 07/01/22 0.00 5,000,000.00 5,000,000.00 912828ZY9 TREAS NOTE U.S. Treasury 0.125 07/15/23 07/15/22 3,125.00 0.00 3,125.00 91282CBG5 TREAS NOTE U.S. Treasury 0.125 01/31/23 07/31/22 1,250.00 0.00 1,250.00 89233HHK3 CP - DISC Tovota Mtr Cr 0.000 08/19/22 08/19/22 0.00 5,000,000.00 5,000,000.00 91282CCU3 TREAS NOTE U.S. Treasury 0.125 08/31/23 08/31/22 2,500.00 0.00 2,500.00 92181PJE3 CP - DISC Vanderbilt Univ 0.000 09/14/22 09/14/22 0.00 3,000,000.00 3,000,000.00 912828YF1 TREAS NOTE U.S. Treasury 1.500 09/15/22 09/15/22 37,500.00 5,000,000.00 5,037,500.00 912828ZD5 TREAS NOTE U.S. Treasury 0.500 03/15/23 09/15/22 12,500.00 0.00 12,500.00 91282CAK7 TREAS NOTE U.S. Treasury 0.125 09/15/23 09/15/22 2,500.00 0.00 2,500.00 Total for General Operating 337,161.32 38,000,000.00 38,337,161.32 Print Date: 4/25/2022 Print Time: 9:13 pm Page 1 of 2 Page 16 of 17 1�* HilltopSecurities Asset Management_ City of Southlake Projected Cash Flows Cash Flows for next 180 days from 03/31/2022 CUSIP Security Type Security Description Pay Date Interest Principal Total Amount April 2022 43,750.00 10,000,000.00 10,043,750.00 May 2022 170,286.32 0.00 170,286.32 June 2022 63,750.00 5,000,000.00 5,063,750.00 July 2022 4,375.00 10,000,000.00 10,004,375.00 August 2022 2,500.00 5,000,000.00 5,002,500.00 September 2022 52,500.00 8,000,000.00 8,052,500.00 Total Projected Cash Flows for City of Southlake 337,161.32 38,000,000.00 38,337,161.32 Print Date: 4/25/2022 Print Time: 9:13 pm Page 2 of 2 Page 17 of 17