Loading...
Item 3B2CITY OF S0UTHLA1<4,,E MONTHLY FINANCIAL REPORT or— 11 1 Janaury 2022 PERFORMANCE AT A GLANCE Year to Date 3 year Trend Reference 7G...r.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 2/10/2022 ECONOMIC INDICATORS NATIONAL ECONOMY FINANCIAL ACTIVITY DP is defined as the output of goods and services oduced by labor and property located in the United ates, The Bureau of Labor and Economic Analysis ported that the "advance" estimated GDP for the 4th carter of 2021 increased at a rate of 6.9%. In the 3rd $45,000,000 carter of 2021, GDP increased at a rate of 2.3%. V -2.3% Housing starts in December were at a seasonally adjusted rate of 1,172,000, which is 2.3% below the revised previous month figure of 1,199,000. UNEMPLOYMENT RATES National: V 4.0% The National Unemployment rate for January 2022 increased to 4.0% when compared to 3.9% in December 2021. State-wide: V 5.0% The Texas Unemployment rate for December 2021 (preliminary) decreased slightly to 5.0% from 5.2% in November 2021. DFW Area: 3.6% The Dallas/Fort Worth/Arlington Metropolitan Area unemployment rate for December 2021 (preliminary) decreased to 3.6% when compared to 3.9% in November 2021. $40,000,000 $35,000,000 $30,000,000 $25,000,000 $20,000,000 $15,000,000 $10,000,000 $5,000,000 2018* 2019* 2020* 2021* 2022* *October -January ■ New Construction permit values City of Southlake Monthly Financial Report 2 2/10/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,910,711 $ 3,110,936 $ 10,799,775 $12,000,000 Feb $ $ $ Mar $ $ $ $10,000,000 Apr $ $ $ $8,000,000 May $ $ $ Jun $ $ $ $6,000,000 Jul $ $ $ Aug $ _ $ _ $ _ $4,000,000 Sep $ $ $ $2,000,000 Tot $ 25,651,459 $ 12,966,647 $ 12,684,812 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep CHART OUTLOOK: POSITIVE The outlook for the year is positive as overall revenues and expenditures are on target with budget. The revenues are higher than expenditures by approximately $12.7M. The significant variance is due to the significant portion of property tax revenue collected (over 76%) 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,256,119 $ 1,360,873 Feb $ $ 978,395 $ 1,011,429 $2,000,000 ' Mar $ - $ 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 $ 5,722,621 $ 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 (32.8%) and FY 2020 (24.9%) collections. December sales were 28% and 19% above December 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 2/10/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 $ - $ 4,445,041 $ 4,237,797 $6,000,000 Mar $ - $ 411,151 $ 420,930 Apr $ $ 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 $ 20,327,774 $ 26,100,905 $ 25,357,489 * Net transfer of TIF revenues to TIF CHART OUTLOOK: POSITIVE fund 2022 YTD property tax collections ($20,327,774) are approximately 5.7% lower than 2021 YTD ($21,565,359) and 5.3% less and 2020 YTD ($21,465,798) as of January. 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 $ - $ 76,270 $ 212,195 Mar $ - $ 150,142 $ 126,842 $200,000 Apr $ $ 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 $ 661,262 $ 1,568,027 $ 1,986,161 $- T Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep CHART OUTLOOK: POSITIVE The value of new construction permits ($42.1M+) issued for FY 2022 YTD is approximately 26.6% and 29.7% higher when compared to FY 2021 and FY 2020, respectively. FY 2022 collections are 112.6% higher and 7.2% 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 2/10/2022 EXPENDITURE ANALYSIS DEPARTMENTAL EXPENDITURES SUMMARY FY 2022 ACTUAL FY 2021 ACTUAL YTD FY 2022 BUDGET FY 2021/2022 YTD YTD (JANUARY) (JANUARY) YTD (JANUARY) VARIANCE BUDGET VARIANCE FY 2022 % SPENT CIVIC) $ 336,128 $ 250,066 $ 362,038 $ (86,062) $ 25,910 92.84% COMM $ 206,301 $ 180,638 $ 230,183 $ (25,663) $ 23,882 89.62% CS $ 1,737,633 $ 1,541,933 $ 2,345,120 $ (195,700) $ 607,487 74.10% CSO $ 167,552 $ 164,819 $ 223,024 $ (2,733) $ 55,472 75.13% DPS $ 5,731,154 $ 5,553,044 $ 7,043,576 $ (178,110) $ 1,312,422 81.37% ED $ 88,881 $ 46,529 $ 98,085 $ (42,352) $ 9,204 90.62% FIN $ 816,982 $ 637,491 $ 1,002,598 $ (179,491) $ 185,616 81.49% HR $ 245,015 $ 238,309 $ 313,450 $ (6,706) $ 68,435 78.17% IT $ 917,775 $ 773,595 $ 1,167,979 $ (144,180) $ 250,204 78.58% PDS $ 664,520 $ 683,025 $ 845,970 $ 18,505 $ 181,450 78.55% PW $ 1,228,741 $ 1,174,584 $ 1,655,643 $ (54,157) $ 426,902 74.22% SS $ 825,962 $ 787,282 $ 1,052,541 $ (38,680) $ 226,579 78.47% Totals $ 12,966,644 $ 12,031,315 $ 16,340,207 $ (935,329) $ 3,373,563 79.35% FY 2022 ACTUAL YTD (JANUARY) FY 2021 ACTUAL YTD (JANUARY) FY 2022 BUDGET YTD (JANUARY) $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.8% primarily due to DPS expenditures eligible for CARES/grant funding, timing of Tarrant County contract payment and reduction in programing cost in FY 2021.The outlook is positive expenditures are below budgeted expenditures for the fiscal year. City of Southlake Monthly Financial Report 5 2/10/2022 HilitopSecurities Asset Management - City of Southlake Investment Portfolio Summary CITY OF SOUTH LAKE For the Quarter Ended December 31, 2021 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 - DECEMBER 2021: The month of December was a headscratcher. Omicron cases absolutely exploded, becoming the dominant strain within three weeks of detection, while new daily COVID cases smashed the previous high from last January and quickly climbed toward the one million new cases per day mark. Fortunately, hospitalizations and fatalities haven't followed the same trajectory as prior strains, which supports the belief that the latest variant isn't nearly as severe. The front -loaded holiday spending season appeared to be solid, and GDP growth improved significantly from the previous quarter as indicated by the Atlanta's Fed's GDPNow measure of +7.4% as of January 4th. Usually, hiring is well correlated with economic growth, but the November employment report was a disappointment as only 210k jobs were added to company payrolls. Some of the miss can blamed on faulty seasonal adjustment factors, but it's becoming clear that the labor market is very tight, which means continued pressure on wages. As growth accelerated in the final quarter of another uneven year, and employers paid higher wages to attract and retain workers, inflation climbed higher. Both the Consumer Price Index (CPI) and Personal Consumption Expenditures (PCE) climbed to levels not seen since the early 80's, and Fed officials finally acknowledged that inflationary pressure would not be retreating any time soon. At the December FOMC meeting, committee members announced a doubling of the taper pace, which would effectively end asset purchases in mid -March. Fed officials also released an updated "dot plot" that was significantly more hawkish than the previous rate outlook. September's dot plot showed committee members were equally split on whether the first 25 bps hike would take place at the end of 2022 or the beginning of 2023. The updated December outlook clearly indicated three 25 bps hikes in 2022, with liftoff occurring as early as the second quarter. The most recent Bloomberg survey showed forecasts by U.S. economists mirrored Fed expectations. Yields climbed throughout month as the bond market adjusted to the dramatic shift in the outlook. The two-year Treasury note, trading at a yield of 0.26% in early October, ended December at 0.73% and would drift higher in the initial days of 2022. The bond market ended the month of December having priced -in all three expected rate increases for the year 2022. Although at this point it would be a surprise if the Fed did not begin the tightening process in May or June, the past two years have introduced quite a few surprises. If inflation were to rise further in 2022, the Fed could hike more aggressively, but if prices retreat, the Fed would be afforded patience. Both the FOMC and the nation's economists expect inflationary pressure to fall; what's far from clear, with CPI at a 40-year high, is when this price moderation will start. Page 2 of 18 J�* HilltopSecurities Asset Management_ For the Quarter Ended December 31, 2021 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 18 J�* HilltopSecurities Asset Management.. Beginning Values as of 09130/21 Par Value Market Value Book Value Unrealized Gain /(Loss) Market Value % Weighted Avg. YTW Weighted Avg. YTM 174,147,951.13 174,710,597.67 174,744,008.43 (33,410.76) 99.98% 0.088% 0.088% ■ USTREAS 21% ■ TEXPOOL 18% ■ TEXSTAR 11% ■ LONESTRGOV 7% ■ LONESTRCRP 7% ■ TOYMCC 6% ■ Other Issuers 31% Total: 100% Ending Values as of 12131121 180,269,790.95 180,437,661.50 180,676,670.87 (239,009.37) 99.87% 0.162% 0.162% 50% 46% 45% 40% 35 % 30 25% 25% 20% 15% 10% 7% 6% 5% 3% 0% Overnight 2 - 90 Days 91 - 180 6 - 12 1 - 2 Years 2 - 3 Years Days Months Weighted Average Days to Maturity: 212 City of Southlake Executive Summary As of 12131121 ■ AGCY BULLET 6% ■ AGCY CALL 3% ■ CID 20% ■ LGIP 46% ■ MUNICIPAL 5% TREASURY 21% Total: 100% ■ A-1+ 20% ■ AA+ 1% ■ AAA 79% Total: 100% Print Date: 1/11/2022 Print Time: 6:59 pm Page 4 of 18 Page 1 of 1 J�w HilltopSecurities Asset Management_ 1.20% 1.00% 0.80% 0.60% 0.40% 0.20% City of Southlake Benchmark Comparison As of 1213112021 ............................................................................................ . o Jul-20 Aug-20 Sep-20 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 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: 1/11/2022 Print Time: TOOpm Page 1 of 1 Page 5 of 18 J�* HilltopSecurities Asset Management. City of Southlake Detail of Security Holdings As of 1213112021 Settle Purch Mkt Days Days CUSIP Date Sec. Type Sec. Description CPN Mty Date Next Call Call Type Par Value Price Ong Cost Book Value Price Market Value to Mty to Call YTM YTW General Operating M LNSTCRP LGIP LoneStar Corp O/N 12,136,428.09 100.000 12,136,428.09 12,136,428.09 100.000 12,136,428.09 1 0.075 0.075 LNSTGOV LGIP LoneStar Gov O/N 12,717,299.63 100.000 12,717,299.63 12,717,299.63 100.000 12,717,299.63 1 0.005 0.005 TEXPOOL LGIP TexPool 32,866,649.45 100.000 32,866,649.45 32,866,649.45 100.000 32,866,649.45 1 0.038 0.038 TEXSTAR LGIP TexSTAR 19,246,337.20 100.000 19,246,337.20 19,246,337.20 100.000 19,246,337.20 1 0.014 0.014 TXCLASS LGIP Texas CLASS 5,318,076.58 100.000 5,318,076.58 5,318,076.58 100.000 5,318,076.58 1 0.069 0.069 92181 PAC6 07/12/21 CP - DISC Vanderbilt Univ 01/12/22 3,000,000.00 99.949 2,998,466.67 2,999,908.32 99.996 2,999,870.10 12 0.100 0.100 882669BQ6 12/23/20 MUNICIPAL TX Pub Fin Auth 0.219 02/01/22 2,000,000.00 100.000 2,000,000.00 2,000,000.00 99.997 1,999,940.00 32 0.219 0.219 92181 PC91 07/12/21 CP - DISC Vanderbilt Univ 03/09/22 3,000,000.00 99.913 2,997,400.00 2,999,274.18 99.964 2,998,923.30 68 0.130 0.130 07286NCHO 10/20/21 CP - DISC Baylor Univ 03/17/22 5,000,000.00 99.959 4,997,944.44 4,998,958.35 99.945 4,997,255.50 76 0.100 0.100 48306BD51 10/05/21 CP - DISC Kaiser Foundation Hospital 04/05/22 5,000,000.00 99.939 4,996,966.67 4,998,433.35 99.927 4,996,370.00 95 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,997,687.50 99.945 4,997,245.00 112 0.150 0.150 46640QG13 10/05/21 CP- DISC J.P.Morgan Sec 07/01/22 5,000,000.00 99.873 4,993,648.61 4,995,726.40 99.812 4,990,620.00 182 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,996,480.55 99.808 4,990,394.50 182 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,990,097.20 99.841 4,992,075.00 231 0.311 0.311 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,049,613.50 100.855 5,042,775.00 258 0.085 0.085 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,065,709.75 101.070 5,053,515.00 319 0.113 0.113 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,017,062.05 100.039 5,001,955.00 439 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,334.30 99.668 4,983,400.00 470 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,662,205.93 106.507 2,662,675.00 500 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,989,407.50 99.705 4,985,274.00 530 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,968,899.35 99.285 4,964,260.00 561 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,992,214.84 99.129 3,965,156.00 608 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,991,713.68 99.094 3,963,752.00 623 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,979,269.60 99.012 4,950,585.00 653 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,986,584.85 99.455 4,972,766.00 678 0.546 0.546 3130AQAFO 12/22/21 AGCY CALL FHLB 0.800 12/22/23 3/22/2022 QRTLY 5,000,000.00 100.000 5,000,000.00 5,000,000.00 100.034 5,001,685.50 721 81 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,712,298.72 103.509 4,642,378.65 866 0.400 0.400 Total for General Operating 180,269,790.95 100.398 180,949,876.02 180,676,670.87 100.104 180,437,661.50 212 0.162 0.162 Print Date: 1/11/2022 Print Time: 7:01 pm Page 1 of 2 Page 6 of 18 J�* HilltopSecurities Asset Management. City of Southlake Detail of Security Holdings As of 1213112021 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 180,269,790.95 100.398 180,949,876.02 180,676,670.87 100.104 180,437,661.50 212 0.162 0.162 Print Date: 1/11/2022 Print Time: 7:01 pm Page 2 of 2 Page 7 of 18 J�* HilltopSecurities Asset Management. City of Southlake Change in Value From 0913012021 to 1213112021 CUSIP Security Type Security Description 09/30121 Cost of Maturities / Amortization I Realized 12/31121 09/30121 12/31121 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 48306AX51 CP - DISC Kaiser Foundation Hospital 0.000 10/05/21 9128285F3 TREAS NOTE U.S. Treasury 2.875 10/15/21 19865WXL2 CP - DISC Columbia Univ 0.000 10/20/21 23506FAC1 CP - INT DFW Intl Airport 0.130 11/15/21 912828RR3 TREAS NOTE U.S. Treasury 2.000 11/15/21 21920NYJ5 CP - DISC Cornell Univ 0.000 11/18/21 9128285R7 TREAS NOTE U.S. Treasury 2.625 12/15/21 92181 PACE CP - DISC Vanderbilt Univ 0.000 01/12/22 882669BQ6 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 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 912828YF1 TREAS NOTE U.S. Treasury 1.500 09/15/22 3133EMCH3 AGCY CALL FFCB 0.160 10/13/22 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 12,134,169.48 2,258.61 0.00 0.00 0.00 12,136,428.09 12,134,169.48 12,136,428.09 2,258.61 12,688,739.98 28,559.65 0.00 0.00 0.00 12,717,299.63 12,688,739.98 12,717,299.63 28,559.65 23,777,000.76 10,001,673.19 (912,024.50) 0.00 0.00 32,866,649.45 23,777,000.76 32,866,649.45 9,089,648.69 39,245,709.25 387.81 (19,999,759.86) 0.00 0.00 19,246,337.20 39,245,709.25 19,246,337.20 (19,999,372.05) 5,317,331.66 744.92 0.00 0.00 0.00 5,318,076.58 5,317,331.66 5,318,076.58 744.92 4,999,916.65 0.00 (5,000,000.00) 83.35 0.00 0.00 4,999,919.00 0.00 (4,999,919.00) 5,005,316.50 0.00 (5,000,000.00) (5,316.50) 0.00 0.00 5,005,386.00 0.00 (5,005,386.00) 4,999,788.90 0.00 (5,000,000.00) 211.10 0.00 0.00 4,999,694.50 0.00 (4,999,694.50) 3,000,000.00 0.00 (3,000,000.00) 0.00 0.00 0.00 2,999,962.50 0.00 (2,999,962.50) 5,011,606.65 0.00 (5,000,000.00) (11,606.65) 0.00 0.00 5,011,870.00 0.00 (5,011,870.00) 4,999,333.35 0.00 (5,000,000.00) 666.65 0.00 0.00 4,999,183.50 0.00 (4,999,183.50) 5,026,162.45 0.00 (5,000,000.00) (26,162.45) 0.00 0.00 5,026,397.50 0.00 (5,026,397.50) 2,999,141.67 0.00 0.00 766.65 0.00 2,999,908.32 2,998,873.20 2,999,870.10 996.90 2,000,000.00 0.00 0.00 0.00 0.00 2,000,000.00 2,000,601.20 1,999,940.00 (661.20) 2,998,277.49 0.00 0.00 996.69 0.00 2,999,274.18 2,997,999.90 2,998,923.30 923.40 0.00 4,997,944.44 0.00 1,013.91 0.00 4,998,958.35 0.00 4,997,255.50 4,997,255.50 0.00 4,996,966.67 0.00 1,466.68 0.00 4,998,433.35 0.00 4,996,370.00 4,996,370.00 4,995,770.85 0.00 0.00 1,916.65 0.00 4,997,687.50 4,995,466.50 4,997,245.00 1,778.50 0.00 4,993,648.61 0.00 2,077.79 0.00 4,995,726.40 0.00 4,990,620.00 4,990,620.00 0.00 4,994,769.44 0.00 1,711.11 0.00 4,996,480.55 0.00 4,990,394.50 4,990,394.50 0.00 4,988,418.06 0.00 1,679.14 0.00 4,990,097.20 0.00 4,992,075.00 4,992,075.00 5,067,578.25 0.00 0.00 (17,964.75) 0.00 5,049,613.50 5,066,797.00 5,042,775.00 (24,022.00) 4,996,508.70 0.00 (5,000,000.00) 3,491.30 0.00 0.00 4,999,870.00 0.00 (4,999,870.00) Print Date: 1/11/2022 Print Time: 7:01 pm Page 1 of 2 Page 8 of 18 J�* HilltopSecurities Asset Management. City of Southlake Change in Value From 0913012021 to 1213112021 CUSIP Security Type Security Description 09/30121 Cost of Maturities / Amortization I Realized 12/31121 09/30121 12/31121 Change in Book Value Purchases Calls I Sales Accretion Gainl(Loss) Book Value Market Value Market Value Mkt Value General Operati 912828TY6 TREAS NOTE U.S. Treasury 1.625 11/15/22 5,084,736.50 0.00 0.00 (19,026.75) 0.00 5,065,709.75 5,084,375.00 5,053,515.00 (30,860.00) 912828ZD5 TREAS NOTE U.S. Treasury 0.500 03/15/23 0.00 5,020,117.19 0.00 (3,055.14) 0.00 5,017,062.05 0.00 5,001,955.00 5,001,955.00 912828ZH6 TREAS NOTE U.S. Treasury 0.250 04/15/23 0.00 5,000,390.63 0.00 (56.33) 0.00 5,000,334.30 0.00 4,983,400.00 4,983,400.00 8821356W1 MUNICIPAL Texas A&MUniv 5.000 05/15/23 2,691,696.93 0.00 0.00 (29,491.00) 0.00 2,662,205.93 2,693,252.50 2,662,675.00 (30,577.50) 3133EMH96 AGCY BULET FFCB 0.125 06/14/23 4,987,589.10 0.00 0.00 1,818.40 0.00 4,989,407.50 4,991,246.00 4,985,274.00 (5,972.00) 912828ZY9 TREAS NOTE U.S. Treasury 0.125 07/15/23 0.00 4,967,968.75 0.00 930.60 0.00 4,968,899.35 0.00 4,964,260.00 4,964,260.00 91282CCU3 TREAS NOTE U.S. Treasury 0.125 08/31/23 3,991,025.68 0.00 0.00 1,189.16 0.00 3,992,214.84 3,989,375.20 3,965,156.00 (24,219.20) 91282CAK7 TREAS NOTE U.S. Treasury 0.125 09/15/23 3,990,478.80 0.00 0.00 1,234.88 0.00 3,991,713.68 3,987,812.40 3,963,752.00 (24,060.40) 91282CAP6 TREAS NOTE U.S. Treasury 0.125 10/15/23 0.00 4,976,757.81 0.00 2,511.79 0.00 4,979,269.60 0.00 4,950,585.00 4,950,585.00 3133ENDRB AGCY BULET FFCB 0.400 11/09/23 0.00 4,985,665.00 0.00 919.85 0.00 4,986,584.85 0.00 4,972,766.00 4,972,766.00 313OAQAFO AGCY CALL FHLB 0.800 12/22/23 0.00 5,000,000.00 0.00 0.00 0.00 5,000,000.00 0.00 5,001,685.50 5,001,685.50 88213AKBO MUNICIPAL Texas A&MUniv 2.549 05/15/24 4,736,128.83 0.00 0.00 (23,830.11) 0.00 4,712,298.72 4,699,564.64 4,642,378.65 (57,185.99) Total for General Operating 174,744,008.43 64,956,270.78 (58,911,784.36) (111,823.98) 0.00 180,676,670.87 174,710,597.67 180,437,661.50 5,727,063.83 Parks Development Corporation 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 Southlake 174,744,008.43 64,956,270.78 (58,911,784.36) (111,823.98) 0.00 180,676,670.87 174,710,597.67 180,437,661.50 5,727,063.83 Print Date: 1/11/2022 Print Time: 7:01 pm Page 2 of 2 Page 9 of 18 J�* HilltopSecurities Asset Management.. City of Southlake Earned Income From 0913012021 to 1213112021 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 1,945.04 1,945.04 0.00 0.00 0.00 1,945.04 LNSTGOV LGIP LoneStar Gov O/N 0.00 163.44 163.44 0.00 0.00 0.00 163.44 TEXPOOL LGIP TexPool 0.00 2,263.29 2,263.29 0.00 0.00 0.00 2,263.29 TEXSTAR LGIP TexSTAR 0.00 627.95 627.95 0.00 0.00 0.00 627.95 TXCLASS LGIP Texas CLASS 0.00 744.92 744.92 0.00 0.00 0.00 744.92 48306AX51 CP - DISC Kaiser Foundation Hospital 0.000 10/05/21 0.00 0.00 0.00 0.00 0.00 83.35 83.35 91282851`3 TREAS NOTE U.S. Treasury 2.875 10/15/21 66,376.37 5,498.63 71,875.00 0.00 0.00 (5,316.50) 182.13 19865WXL2 CP - DISC Columbia Univ 0.000 10/20/21 0.00 0.00 0.00 0.00 0.00 211.10 211.10 23506FAC1 CP - INT DFW Intl Airport 0.130 11/15/21 931.67 487.50 1,419.17 0.00 0.00 0.00 487.50 912828RR3 TREAS NOTE U.S. Treasury 2.000 11/15/21 37,771.74 12,228.26 50,000.00 0.00 0.00 (11,606.65) 621.61 21920NYJ5 CP - DISC Cornell Univ 0.000 11/18/21 0.00 0.00 0.00 0.00 0.00 666.65 666.65 9128285R7 TREAS NOTE U.S. Treasury 2.625 12/15/21 38,729.51 26,895.49 65,625.00 0.00 0.00 (26,162.45) 733.04 92181 PACE CP - DISC Vanderbilt Univ 0.000 01/12/22 0.00 0.00 0.00 0.00 0.00 766.65 766.65 882669BQ6 MUNICIPAL TX Pub Fin Auth 0.219 02/01/22 730.00 1,095.00 0.00 0.00 1,825.00 0.00 1,095.00 92181 PC91 CP - DISC Vanderbilt Univ 0.000 03/09/22 0.00 0.00 0.00 0.00 0.00 996.69 996.69 07286NCHO CP - DISC Baylor Univ 0.000 03/17/22 0.00 0.00 0.00 0.00 0.00 1,013.91 1,013.91 48306BD51 CP - DISC Kaiser Foundation Hospital 0.000 04/05/22 0.00 0.00 0.00 0.00 0.00 1,466.68 1,466.68 89233HDN1 CP - DISC Toyota Mtr Cr 0.000 04/22/22 0.00 0.00 0.00 0.00 0.00 1,916.65 1,916.65 46640QG13 CP - DISC J.P.MorganSec 0.000 07/01/22 0.00 0.00 0.00 0.00 0.00 2,077.79 2,077.79 91512DG13 CP - DISC Univ of TX 0.000 07/01/22 0.00 0.00 0.00 0.00 0.00 1,711.11 1,711.11 89233HHK3 CP - DISC Toyota Mtr Cr 0.000 08/19/22 0.00 0.00 0.00 0.00 0.00 1,679.14 1,679.14 912828YF1 TREAS NOTE U.S. Treasury 1.500 09/15/22 3,314.92 19,060.77 0.00 0.00 22,375.69 (17,964.75) 1,096.02 3133EMCH3 AGCY CALL FFCB 0.160 10/13/22 3,733.33 266.67 4,000.00 0.00 0.00 3,491.30 3,757.97 912828TY6 TREAS NOTE U.S. Treasury 1.625 11/15/22 30,689.54 20,484.49 40,625.00 0.00 10,549.03 (19,026.75) 1,457.74 912828ZD5 TREAS NOTE U.S. Treasury 0.500 03/15/23 0.00 5,386.74 0.00 (2,071.82) 7,458.56 (3,055.14) 2,331.60 912828ZH6 TREAS NOTE U.S. Treasury 0.250 04/15/23 0.00 2,712.72 6,250.00 (6,215.85) 2,678.57 (56.33) 2,656.39 Print Date: 1/11/2022 Print Time: 7:01 pm Page 1 of 2 Page 10 of 18 J�* HilltopSecurities Asset Management.. City of Southlake Earned Income From 0913012021 to 1213112021 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 8821356W1 MUNICIPAL Texas A&MUniv 5.000 05/15/23 47,222.22 31,250.00 62,500.00 0.00 15,972.22 (29,491.00) 1,759.00 3133EMH96 AGCY BULET FFCB 0.125 06/14/23 1,857.64 1,562.50 3,125.00 0.00 295.14 1,818.40 3,380.90 912828ZY9 TREAS NOTE U.S. Treasury 0.125 07/15/23 0.00 288.72 0.00 (2,598.51) 2,887.23 930.60 1,219.32 91282CCU3 TREAS NOTE U.S. Treasury 0.125 08/31/23 428.18 1,270.72 0.00 0.00 1,698.90 1,189.16 2,459.88 91282CAK7 TREAS NOTE U.S. Treasury 0.125 09/15/23 220.99 1,270.72 0.00 0.00 1,491.71 1,234.88 2,505.60 91282CAP6 TREAS NOTE U.S. Treasury 0.125 10/15/23 0.00 1,356.37 3,125.00 (3,107.92) 1,339.29 2,511.79 3,868.16 3133ENDR8 AGCY BULET FFCB 0.400 11/09/23 0.00 2,555.56 0.00 (333.33) 2,888.89 919.85 3,475.41 313OAQAFO AGCY CALL FHLB 0.800 12/22/23 0.00 1,000.00 0.00 0.00 1,000.00 0.00 1,000.00 88213AKBO MUNICIPAL Texas A&MUniv 2.549 05/15/24 43,188.56 28,580.66 57,161.33 0.00 14,607.89 (23,830.11) 4,750.55 Total for General Operating 275,194.67 168,996.16 371,450.14 (14,327.43) 87,068.12 (111,823.98) 57,172.18 Parks Development Corpo Total for Parks Development Corporation 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total for City of Southlake 275,194.67 168,996.16 371,450.14 (14,327.43) 87,068.12 (111,823.98) 57,172.18 Print Date: 1/11/2022 Print Time: 7:01 pm Page 2 of 2 Page 11 of 18 J�w HilltopSecurities Asset Management. City of Southlake Investment Transactions From 1010112021 to 1213112021 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 calls 10/12/21 10/13/21 3133EMCH3 AGCY CALL FFCB 0.160 10/13/22 10/13/21 5,000,000.00 100.000 5,000,000.00 0.00 5,000,000.00 0.228 0.160 Total for: Calls 5,000,000.00 5,000,000.00 0.00 5,000,000.00 0.228 0.160 Maturities 10/05/21 10/05/21 48306AX51 CP - DISC Kaiser Foundation Hospital 10/05/21 5,000,000.00 100.000 5,000,000.00 0.00 5,000,000.00 0.150 10/15/21 10/15/21 91282851`3 TREAS NOTE U.S. Treasury 2.875 10/15/21 5,000,000.00 100.000 5,000,000.00 0.00 5,000,000.00 0.094 10/20/21 10/20/21 19865WXL2 CP - DISC Columbia Univ 10/20/21 5,000,000.00 100.000 5,000,000.00 0.00 5,000,000.00 0.080 11/15/21 11/15/21 23506FAC1 CP - INT DFW Intl Airport 0.130 11/15/21 3,000,000.00 100.000 3,000,000.00 1,419.17 3,001,419.17 0.130 11/15/21 11/15/21 912828RR3 TREAS NOTE U.S. Treasury 2.000 11/15/21 5,000,000.00 100.000 5,000,000.00 0.00 5,000,000.00 0.101 11/18/21 11/18/21 21920NYJ5 CP - DISC Cornell Univ 11/18/21 5,000,000.00 100.000 5,000,000.00 0.00 5,000,000.00 0.100 12/15/21 12/15/21 9128285R7 TREAS NOTE U.S. Treasury 2.625 12/15/21 5,000,000.00 100.000 5,000,000.00 0.00 5,000,000.00 0.071 Total for: Maturities 33,000,000.00 33,000,000.00 1,419.17 33,001,419.17 0.102 Purchases 10/04/21 10/05/21 46640QG13 CP - DISC J.P.Morgan Sec 07/01/22 5,000,000.00 99.873 4,993,648.61 0.00 4,993,648.61 0.170 0.170 10/04/21 10/05/21 91512DG13 CP - DISC Univ of TX 07/01/22 5,000,000.00 99.895 4,994,769.44 0.00 4,994,769.44 0.140 0.140 10/05/21 10/05/21 48306BD51 CP - DISC Kaiser Foundation Hospital 04/05/22 5,000,000.00 99.939 4,996,966.67 0.00 4,996,966.67 0.120 0.120 10/13/21 10/14/21 912828ZH6 TREAS NOTE U.S. Treasury 0.250 04/15/23 5,000,000.00 100.008 5,000,390.63 6,215.85 5,006,606.48 0.245 0.245 10/13/21 10/14/21 91282CAP6 TREAS NOTE U.S. Treasury 0.125 10/15/23 5,000,000.00 99.535 4,976,757.81 3,107.92 4,979,865.73 0.358 0.358 10/14/21 10/15/21 912828ZD5 TREAS NOTE U.S. Treasury 0.500 03/15/23 5,000,000.00 100.402 5,020,117.19 2,071.82 5,022,189.01 0.215 0.215 10/20/21 10/20/21 07286NCHO CP - DISC Baylor Univ 03/17/22 5,000,000.00 99.959 4,997,944.44 0.00 4,997,944.44 0.100 0.100 11/12/21 11/15/21 3133ENDR8 AGCY BULET FFCB 0.400 11/09/23 5,000,000.00 99.713 4,985,665.00 333.33 4,985,998.33 0.546 0.546 11/22/21 11/23/21 89233HHK3 CP - DISC Toyota Mtr Cr 08/19/22 5,000,000.00 99.768 4,988,418.06 0.00 4,988,418.06 0.311 0.311 12/07/21 12/22/21 3130AGAFO AGCY CALL FHLB 0.800 12/22/23 03/22/22 5,000,000.00 100.000 5,000,000.00 0.00 5,000,000.00 0.800 0.800 12/13/21 12/15/21 912828ZY9 TREAS NOTE U.S. Treasury 0.125 07/15/23 5,000,000.00 99.359 4,967,968.75 2,598.51 4,970,567.26 0.532 0.532 Total for: Purchases 55,000,000.00 54,922,646.60 14,327.43 54,936,974.03 0.322 0.322 Income Payments 10/13/21 10/13/21 3133EMCH3 AGCY CALL FFCB 0.160 10/13/22 0.00 4,000.00 4,000.00 10/15/21 10/15/21 91282851`3 TREAS NOTE U.S. Treasury 2.875 10/15/21 0.00 71,875.00 71,875.00 Print Date: 1/11/2022 Print Time: 7:01 pm Page 1 of 3 Page 12 of 18 J�w HilltopSecurities Asset Management. City of Southlake Investment Transactions From 1010112021 to 1213112021 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 Income Payments 10/15/21 10/15/21 912828ZH6 TREAS NOTE U.S. Treasury 10/15/21 10/15/21 91282CAP6 TREAS NOTE U.S. Treasury 11/15/21 11/15/21 8821356W1 MUNICIPAL Texas A&MUniv 11/15/21 11/15/21 88213AKBO MUNICIPAL Texas A&MUniv 11/15/21 11/15/21 912828RR3 TREAS NOTE U.S. Treasury 11/15/21 11/15/21 912828TY6 TREAS NOTE U.S. Treasury 12/14/21 12/14/21 3133EMH96 AGCY BULET FFCB 12/15/21 12/15/21 9128285R7 TREAS NOTE U.S. Treasury Total for: Income Payments 0.250 04/15/23 0.00 6,250.00 6,250.00 0.125 10/15/23 0.00 3,125.00 3,125.00 5.000 05/15/23 0.00 62,500.00 62,500.00 2.549 05/15/24 0.00 57,161.33 57,161.33 2.000 11/15/21 0.00 50,000.00 50,000.00 1.625 11/15/22 0.00 40,625.00 40,625.00 0.125 06/14/23 0.00 3,125.00 3,125.00 2.625 12/15/21 0.00 65,625.00 65,625.00 0.00 364,286.33 364,286.33 Print Date: 1/11/2022 Print Time: 7:01 pm Page 13 of 18 Page 2 of 3 J�w HilltopSecurities Asset Management. City of Southlake Investment Transactions From 1010112021 to 1213112021 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 Calls 5,000,000.00 Total Maturities 33,000,000.00 Total Purchases 55,000,000.00 Total Income Payments 0.00 5,000,000.00 0.228 0.160 33,001,419.17 0.102 54,936,974.03 0.322 0.322 364,286.33 Print Date: 1/11/2022 Print Time: 7:01 pm Page 14 of 18 Page 3 of 3 J�* HilltopSecurities Asset Management. City of Southlake Amortization and Accretion From 0913012021 to 1213112021 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 / Prem Book Value 48306AX51 04/07/21 CP - DISC Kaiser Foundation Hospital 0.000 10/05/21 0.00 99.925 0.00 83.35 0.00 0.00 0.00 91282851`3 01/22/21 TREAS NOTE U.S. Treasury 2.875 10/15/21 0.00 102.023 0.00 (5,316.50) 0.00 0.00 0.00 19865WXL2 06/24/21 CP - DISC Columbia Univ 0.000 10/20/21 0.00 99.974 0.00 211.10 0.00 0.00 0.00 23506FAC1 07/13/21 CP - INT DFW Intl Airport 0.130 11/15/21 0.00 100.000 0.00 0.00 0.00 0.00 0.00 912828RR3 01/15/21 TREAS NOTE U.S. Treasury 2.000 11/15/21 0.00 101.578 0.00 (11,606.65) 0.00 0.00 0.00 21920NYJ5 08/05/21 CP - DISC Cornell Univ 0.000 11/18/21 0.00 99.971 0.00 666.65 0.00 0.00 0.00 9128285R7 03/15/21 TREAS NOTE U.S. Treasury 2.625 12/15/21 0.00 101.922 0.00 (26,162.45) 0.00 0.00 0.00 92181PAC6 07/12/21 CP - DISC Vanderbilt Univ 0.000 01/12/22 3,000,000.00 99.949 2,998,466.67 766.65 1,441.65 91.68 2,999,908.32 882669BQ6 12/23/20 MUNICIPAL TX Pub Fin Auth 0.219 02/01/22 2,000,000.00 100.000 2,000,000.00 0.00 0.00 0.00 2,000,000.00 92181 PC91 07/12/21 CP - DISC Vanderbilt Univ 0.000 03/09/22 3,000,000.00 99.913 2,997,400.00 996.69 1,874.18 725.82 2,999,274.18 07286NCHO 10/20/21 CP - DISC Baylor Univ 0.000 03/17/22 5,000,000.00 99.959 4,997,944.44 1,013.91 1,013.91 1,041.65 4,998,958.35 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,466.68 1,466.68 1,566.65 4,998,433.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,916.65 3,291.67 2,312.50 4,997,687.50 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,077.79 2,077.79 4,273.60 4,995,726.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,711.11 1,711.11 3,519.45 4,996,480.55 89233HHK3 11/23/21 CP - DISC Toyota MtrCr 0.000 08/19/22 5,000,000.00 99.768 4,988,418.06 1,679.14 1,679.14 9,902.80 4,990,097.20 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,964.75) (18,550.56) (49,613.50) 5,049,613.50 3133EMCH3 10/13/20 AGCY CALL FFCB 0.160 10/13/22 10/13/21 0.00 99.865 0.00 3,491.30 0.00 0.00 0.00 912828TY6 09/28/21 TREAS NOTE U.S. Treasury 1.625 11/15/22 5,000,000.00 101.707 5,085,351.56 (19,026.75) (19,641.81) (65,709.75) 5,065,709.75 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,055.14) (3,055.14) (17,062.05) 5,017,062.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 (56.33) (56.33) (334.30) 5,000,334.30 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,491.00) (138,444.07) (162,205.93) 2,662,205.93 3133EMH96 06/25/21 AGCY BULET FFCB 0.125 06/14/23 5,000,000.00 99.713 4,985,650.00 1,818.40 3,757.50 10,592.50 4,989,407.50 912828ZY9 12/15/21 TREAS NOTE U.S. Treasury 0.125 07/15/23 5,000,000.00 99.359 4,967,968.75 930.60 930.60 31,100.65 4,968,899.35 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,189.16 1,589.84 7,785.16 3,992,214.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,234.88 1,713.68 8,286.32 3,991,713.68 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,511.79 2,511.79 20,730.40 4,979,269.60 3133ENDR8 11/15/21 AGCY BULET FFCB 0.400 11/09/23 5,000,000.00 99.713 4,985,665.00 919.85 919.85 13,415.15 4,986,584.85 313OAQAFO 12/22/21 AGCY CALL FHLB 0.800 12/22/23 03/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,830.11) (119,436.63) (227,298.72) 4,712,298.72 Total for General Operating 97,985,000.00 98,665,085.07 (111,823.98) (273,205.15) (406,879.92) 98,391,879.92 Print Date: 1/11/2022 Print Time: 7:01 pm Page 1 of 2 Page 15 of 18 J�* HilltopSecurities Asset Management. City of Southlake Amortization and Accretion From 09/30/2021 to 1213112021 Orig AmrtIAccr Total AmrtfAccr 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 97,985,000.00 98,665,085.07 (111,823.98) (273,205.15) (406,879.92) 98,391,879.92 Print Date: 1/11/2022 Print Time: 7:01 pm Page 2 of 2 Page 16 of 18 J�* HilltopSecurities Asset Management.. City of Southlake Projected Cash Flows Cash Flows for next 180 days from 1213112021 CUSIP Security Type Security Description Pay Date Interest Principal Total Amount General Operating 11111111� 92181PAC6 CP - DISC Vanderbilt Univ 0.000 01/12/22 01/12/22 0.00 3,000,000.00 3,000,000.00 912828ZY9 TREAS NOTE U.S. Treasury 0.125 07/15/23 01/15/22 3,125.00 0.00 3,125.00 882669BQ6 MUNICIPAL TX Pub Fin Auth 0.219 02/01/22 02/01/22 2,190.00 2,000,000.00 2,002,190.00 91282CCU3 TREAS NOTE U.S. Treasury 0.125 08/31/23 02/28/22 2,500.00 0.00 2,500.00 92181 PC91 CP - DISC Vanderbilt Univ 0.000 03/09/22 03/09/22 0.00 3,000,000.00 3,000,000.00 912828YF1 TREAS NOTE U.S. Treasury 1.500 09/15/22 03/15/22 37,500.00 0.00 37,500.00 912828ZD5 TREAS NOTE U.S. Treasury 0.500 03/15/23 03/15/22 12,500.00 0.00 12,500.00 91282CAK7 TREAS NOTE U.S. Treasury 0.125 09/15/23 03/15/22 2,500.00 0.00 2,500.00 07286NCHO CP - DISC Baylor Univ 0.000 03/17/22 03/17/22 0.00 5,000,000.00 5,000,000.00 48306BD51 CP - DISC Kaiser Foundation Hospital 0.000 04/05/22 04/05/22 0.00 5,000,000.00 5,000,000.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&M Univ 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 313OAQAFO AGCY CALL FHLB 0.800 12/22/23 06/22/22 20,000.00 0.00 20,000.00 Total for General Operating 263,101.32 23,000,000.00 23,263,101.32 Print Date: 1/11/2022 Print Time: 7:01 pm Page 1 of 2 Page 17 of 18 1�* HilltopSecurities Asset Management_ City of Southlake Projected Cash Flows Cash Flows for next 180 days from 1213112021 CUSIP Security Type Security Description Pay Date Interest Principal Total Amount January 2022 3,125.00 3,000,000.00 3,003,125.00 February 2022 4,690.00 2,000,000.00 2,004,690.00 March 2022 52,500.00 8,000,000.00 8,052,500.00 April 2022 9,375.00 10,000,000.00 10,009,375.00 May 2022 170,286.32 0.00 170,286.32 June 2022 23,125.00 0.00 23,125.00 Total Projected Cash Flows for City of Southlake 263,101.32 23,000,000.00 23,263,101.32 Print Date: 1/11/2022 Print Time: 7:01 pm Page 2 of 2 Page 18 of 18 EXPERIENCE SOUTHLAKE January 25, 2022 The Marq Financial Review MARQ 89.55% V 65.12% 137.52% Target A -FT Loom 1.12M Revenue Expense 1 U1112421 9h134l2[le2 CC 96.58% 71.01% 136.01% Target ATT 852.95K 471.61 K Revenue Expense Net Revenue: Current &Previous Year GGR • LHR —Trial Revenue LY CEDC FINANCIAL DASHBOARD - of 112512022 4=44 PM LH 63.25% 44.UD'70 -11" Z70 0 Target ATT 149.25K 133.09K Revenue Expense mm a2K �OK 25K ME EMS eau 39K 258 24£iC 220K 211K 220K 2NK 212K 19(1G INK 202K 175K 149C 14M4K 1471C dC Jm2021 Fvb2M1 PA.2W1 Apr3121 Nmy2121 J-2121 U2W1 A.p2721 Sp2021 Od2O7 N-2021 U-201 Jan7U22 g GGJZentsl-� u+Re,t.W?ba nue 50K 40K 30K 20K 10K The Marq Rentals Revenue (Net) Jan 2021 Feb 2021 Mar2021 AR 21221 May2021 Jm2021 Ad 2021 Aug 2021 Sep 2021 Om Ml Hw2021 Oec2021 Jan 2022 The Mara Membership Revenue (Net) 100K 180K 170K 100K 150K 140K 130K 120K Jan 2021 Fe62021 Mar2021 Apr 2021 May 2M Jun 2021 Jd 2021 Au02021 Sep 2021 Ot2021 Nw2021 ❑e M21 Jan2M CHAMPIONS CLUB MEMBERSHIP TRENDS 2800 261 2585 2600 / 25062513 2252/ 458/0000 o574 26015 2444 /� 2453 2400 '2504 2527 25 // \ /� //— � � � 0000 18 228 2378 2360 � 2331 2327 2340 2200 203 240 22 20 1968 2001/ 2- 2000 195819561941 19451944 y 2062� — /� / /� /� / /0-00 s 1955 d 1800 � 1 1 1600 1 h 1400 183 188 178 179 186 184 177 142 153 1200 1000 1 24 9 1 1 LO (O � 00 m O N N cl) �t LO O r` W O O N N (M It LO (O � co O O N *_ O O O O O r r O O O O O O O O O r r r O O O O O O O O O _O O O O O O O O O O {_ N N N N N N N N N N N N N N N N N N N N N O O O O O O O O N N N N O O O O O O O O O O O O O O O O O O N N N N N N N O O N N O O O O N N N N N N N N N N N N N N N N N N CD N Period 400 350 300 250 N C O N 200 a N 7 N 150 100 50 0 CC Membership Joins vs. Terminations, and Retention Rate (Month -to -Month) through 12/31/2021 450 4 400 350 333 300 250 200 150 50 371 224 124 01203 206 187 164 157 12 14 138 02 12J24 22 25120 127 1 78 63 0 25 0 _ 0 0' 1 285 i 198 157 155 153 128 28 130 18 109 113 103 10 81 6 306 304 190 1 100.0% /00000— 95.0% 90.0% 85.0% � Joins 80.0% � Terminations Retention 250 75.0% Rate 231 222 224 149■ 70.0% 197 201 18 170 65.0% 16 tio`l�tio`l^ 13 1 60.0% 55.0% 50.0% 45.0% 40.0% 'i 300 0 1 -100 i _2no _oo -4SD 1m0—N Cn.fdda 4 8 5 Ywnhr�hyrY — 35 iw(rndwi Suer 2G CC MEMBERSHIP JOINS VS TERMINATIONS BY MONTH & TYPE .Adult Fam Fam-HC SR .Youth 28 1S a :5 24 19 pp 15 13 0 3 13 B2 W 8 ® 7 153 D. , d7 21) 95 57 91 a5 — .315 �4 4M ## 30 3d 29 11 if s I� f _25 18 -28 i y Q -2G 3 I'. -20 3 438 -; 26 I I 'I 28 Aa -.10 -d4 -40 -7 -71 -4 -9 -7 �9 I -50 f3 -1P. 7 15 -12 -13_ ,2 1 -1- -13 _sua G 8 J"s 8 G G G E Jfs 1< G 8 G G G 8I g G E .G g v G -G a G 8 .G E m i .G i J"r 8 -ra i v o o a o a o y a o o $ o o $ o o o Apr-20 May-20 Jun-24 Ju�20 Aug-20 Sep-20 Oct-26 Now-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 EXPERIENCE SOUTHLAKE k Three Year Revenue Comparison by Month $1,000,000 $900,000 $800,000 $700,000 $600,000 $500,000 $400,000 $300,000 $200,000 $100,000 $0 " — — I - �t �t o��10 �0 O�G FISCAL YEAR 2020 ■ FISCAL YEAR 2021 FISCAL YEAR 2022 EXPERIENCE SOUTHLAI<,.,.,E