Loading...
Item 3B1 Financial ReportReference Page 3 Page 3 Page 4 Page 4 Page 5 GENERAL FUND PositiveGeneral Fund Exp. Vs. Rev. Sales Tax Revenue (2 months prior activity) Property Tax Revenue Positive Positive Positive Positive Positive PERFORMANCE INDICATORS Positive Warning Permit Revenues Positive Positive Departmental Expenditures Summary Positive = Negative variance of 1-4% compared to seasonal trends = Positive variance or negative variance <1% compared to seasonal trends. PERFORMANCE AT A GLANCE Year to Date 3 year Trend Negative MONTHLY FINANCIAL REPORT January 2021 = Negative Variance of > 4% compared to seasonal trends. Positive City of Southlake Monthly Financial Report 1 2/11/2021 National GDP: ECONOMIC INDICATORS NATIONAL ECONOMY FINANCIAL ACTIVITY4.0% 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 "fourth" estimated GDP for the 4th quarter of 2020 increased at a rate of 4.0%. In the 3rd quarter of 2020, GDP increased at a rate of 33.4%. The National Unemployment rate for January 2021 decreased to 6.3% when compared to 6.7% in December 2020. National: 5 YEAR TREND OF NEW CONSTRUCTION PERMIT VALUES Housing Starts: Housing starts in December 2020 were at a seasonally adjusted rate of 1,669,000, which is 5.8% above the revised previous month figure of 1,578,000, and 5.2% above the same month last year. 5.8% UNEMPLOYMENT RATES 6.3% The Dallas/Fort Worth/Arlington Metropolitan Area unemployment rate for December 2020 (preliminary) decreased to 6.3% when compared to 7.2% in November 2020. 6.3% State-wide:7.2% The Texas Unemployment rate for December 2020 (preliminary) decreased to 7.2% from 8.1% in November 2020. DFW Area: $- $5,000,000 $10,000,000 $15,000,000 $20,000,000 $25,000,000 $30,000,000 $35,000,000 $40,000,000 $45,000,000 $50,000,000 2017*2018*2019*2020*2021* New Construction permit values*October-January City of Southlake Monthly Financial Report 2 2/11/2021 FY 2021 REVENUE FY 2021 EXPENDITURE VARIANCE Oct 1,291,213$ 2,174,348$ (883,135)$ Nov 1,854,477$ 2,812,519$ (958,042)$ Dec 7,709,639$ 4,221,574$ 3,488,065$ Jan 14,803,845$ 2,749,631$ 12,054,214$ Feb -$ -$ -$ Mar -$ -$ -$ Apr -$ -$ -$ May -$ -$ -$ Jun -$ -$ -$ Jul -$ -$ -$ Aug -$ -$ -$ Sep -$ Tot 25,659,174$ 11,958,072$ 13,701,102$ POSITIVE FY 2021 FY 2020 FY 2019 Oct 1,299,576$ 1,278,635$ 1,253,417$ Nov 1,084,677$ 1,309,584$ 1,140,440$ Dec 1,926,407$ 1,993,686$ 1,613,337$ Jan -$ 1,360,873$ 1,030,047$ Feb -$ 1,011,429$ 1,094,354$ Mar -$ 1,162,936$ 1,321,691$ Apr -$ 1,038,287$ 1,294,023$ May -$ 1,153,263$ 1,295,321$ Jun -$ 1,375,636$ 1,274,338$ Jul -$ 1,190,064$ 1,179,145$ Aug 1,233,673$ 1,344,868$ Sep 1,416,226$ 1,354,327$ Tot 4,310,660$ 15,524,291$ 15,195,307$ The outlook for the year is positive as overall revenues and expenditures are on target with budget.The revenues are higher than expenditures by $13.7M.The significant variance is due to the significant portion of property tax revenue collected (over 85%) of the budgeted property tax revenue which is the largest revenue source for the general fund. Year to date sales tax collections are trending below FY 2020 (-5.9%)and above FY 2019 (7.6%)collections.The largest variance compared to FY 2020 is primarily related to a large audit adjustment in November collections. However year to date collections are trending above budget for the year therefore the outlook is considered positive. Staff will continue to closely monitor collections. POSITIVE GENERAL FUND REVENUE VS EXPENDITURES 2021 OVERALL FUND PERFORMANCE: REVENUE ANALYSIS GENERAL FUND SALES TAX 2021-2019 COMPARISON CHART OUTLOOK: GENERAL FUND CHART OUTLOOK: $- $500,000 $1,000,000 $1,500,000 $2,000,000 $2,500,000 FY 2021 FY 2020 FY 2019 $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep FY 2021 REVENUE FY 2021 EXPENDITURE 2020 EXPEND. City of Southlake Monthly Financial Report 3 2/11/2021 GENERAL FUND FY 2021 FY 2020 FY 2019 Oct 778,578$ 790,236$ 1,151,812$ Nov 1,582,957$ 1,426,054$ 1,552,708$ Dec 6,036,699$ 9,161,119$ 10,397,278$ Jan 13,167,125$ 10,088,389$ 9,985,201$ Feb -$ 4,237,797$ 3,385,436$ Mar -$ 420,930$ 395,710$ Apr -$ 55,958$ 156,647$ May -$ 105,567$ -$ Jun -$ 448,670$ 312,620$ Jul *-$ (1,457,677)$ (1,295,201)$ Aug -$ 52,000$ 59,318$ Sep -$ 28,446$ 46,464$ Tot 21,565,359$ 25,357,489$ 26,147,993$ POSITIVE FY 2021 FY 2020 FY 2019 Oct 50,043$ 134,067$ 85,534$ Nov 69,734$ 238,528$ 75,588$ Dec 102,515$ 135,168$ 160,859$ Jan 88,737$ 204,931$ 121,526$ Feb -$ 212,195$ 121,533$ Mar -$ 126,842$ 186,152$ Apr -$ 188,968$ 111,970$ May -$ 128,791$ 601,621$ Jun -$ 148,103$ 111,503$ Jul -$ 152,920$ 163,760$ Aug -$ 69,101$ 155,328$ Sep 246,547$ 474,884$ Tot 311,029$ 1,986,161$ 2,370,258$ POSITIVE 2021 YTD property tax collections ($21,565,359)are approximately 0.46%higher than 2020 YTD ($21,465,798)and 6.59%less and 2019 YTD ($23,086,999 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. * Net transfer of TIF revenues to TIF fund The value of new construction permits ($33.3M+)issued for FY 2021 YTD is approximately 3.9%higher and 1.74%lower when compared to FY 2020 and FY 2019 respectively.However,the revenue collected YTD is trending below the two previous years.FY 2021 collections are 56.6%and 29.9%below FY 2020 and 2019,respectively.The primary reason for the significant variance is due to the timing related to one commercial permit issued in Q1 (October 2, 2020) but revenue was collected in Q4 of FY 2020. The permit revenue year to date is trending above budget therefore the outlook is considered positive. PERMIT REVENUE 2021-2019 COMPARISON CHART OUTLOOK: REVENUE ANALYSIS (continued) PROPERTY TAX 3 YEAR TREND CHART OUTLOOK: $(4,000,000) $(2,000,000) $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 Oct Nov Dec Jan Feb Mar Apr May Jun Jul *Aug FY 2021 FY 2020 FY 2019 $- $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep FY 2021 FY 2020 FY 2019 City of Southlake Monthly Financial Report 4 2/11/2021 FY 2021 ACTUAL YTD (JANUARY) FY 2020 ACTUAL YTD (JANUARY) FY 2021 BUDGET YTD (JANUARY)FY 2021 % SPENT 250,066$ 308,045$ 359,682$ 69.52% 180,638$ 173,280$ 207,295$ 87.14% 1,541,933$ 1,838,919$ 2,265,850$ 68.05% 164,819$ 158,541$ 208,326$ 79.12% 5,553,044$ 5,797,035$ 6,735,926$ 82.44% 46,529$ 49,254$ 95,084$ 48.93% 637,491$ 837,180$ 978,992$ 65.12% 238,309$ 246,070$ 311,821$ 76.42% 773,595$ 702,419$ 1,231,854$ 62.80% 683,025$ 667,959$ 795,748$ 85.83% 1,174,584$ 1,275,346$ 1,553,485$ 75.61% 787,282$ 778,411$ 962,821$ 81.77% 12,031,315$ 12,832,459$ 15,706,884$ 76.60%3,675,569$ CHART OUTLOOK: 175,539$ 378,901$ 7,761$ 112,723$ PDS BUDGET VARIANCE 109,616$ 723,917$ (15,066)$ 100,762$ (8,871)$ 801,144$ As indicated above,2021 expenditures are below 2020 expenditures for the same period with a decrease of 6.24%primarily due to DPS expenditures eligible for CARES/grants funding and timing of Tarrant County contract payment. The outlook is positive expenditures are on pace to be below budgeted expenditures for the fiscal year. FY 2020/2021 YTD VARIANCE 57,979$ 296,986$ (6,278)$ 243,991$ 2,725$ 199,689$ SS Totals PW CMO CS COMM (71,176)$ 43,507$ 1,182,882$ 48,555$ 341,501$ 73,512$ 458,259$ CSO DPS ED FIN HR IT DEPARTMENTAL EXPENDITURES SUMMARY (7,358)$ 26,657$ EXPENDITURE ANALYSIS POSITIVE $- $2,000,000 $4,000,000 $6,000,000 $8,000,000 $10,000,000 $12,000,000 $14,000,000 $16,000,000 $18,000,000 CMO COMM CS CSO DPS ED FIN HR IT PDS PW SS FY 2021 ACTUAL YTD (JANUARY)FY 2020 ACTUAL YTD (JANUARY)FY 2021 BUDGET YTD (JANUARY) City of Southlake Monthly Financial Report 5 2/11/2021 City of Southlake Investment Portfolio Summary December 31, 2020 For the Quarter Ended Prepared by HilltopSecurities Asset Management Table of Contents / Market Recap Report Name Executive Summary Benchmark Comparison Detail of Security Holdings Change in Value Earned Income Investment Transactions Amortization and Accretion Projected Fixed Income Cash Flows Certification Page MARKET RECAP - DECEMBER 2020: The fourth quarter story was multifaceted, with a global resurgence of the virus, FDA approval of two extremely effective vaccines, a contested election that will presumably result in a Biden presidency, and signs of a slowdown in economic growth. During the quarter, Covid-19 hospitalizations quadrupled and the total number of Covid deaths jumped by 70%. Because the broad economy remained open for the most part during the holidays, experts are bracing for another rise in cases in January. Economic data released during December confirmed prior signals that the economic recovery was slipping. The ISM manufacturing index fell from 59.3 to a still solid 56.7, but the employment index was more concerning as it fell from 53.2 into contraction territory at 48.4. November’s employment report confirmed that signal and was clear in its depiction of moderating job growth with nonfarm payrolls increasing just 245k, well below the 460k median forecast. Payrolls are still down more than 10 million from the pre-pandemic period early in the year. The sidelined workers primarily represent the service sector, with restaurants, bars, gyms, conferences and sporting events still far from normal. The unemployment rate dropped from 6.9% to 6.7% last month, although this improvement is a little deceptive as it was driven by a decline in the labor force participation rate which, at 61.5%, is now within one tenth of a 45-year low. First time filings for unemployment benefits spiked to a three-month high of 892k in mid-December and stubbornly remain nearly 4x pre-pandemic norms. Some 20 million Americans continue to receive unemployment benefits in combined state and federal programs. Consumer spending has slowed as well, with overall retail sales for November down -1.1% following a downwardly revised -0.1% October decline. Inflation remains on the backburner with overall CPI holding steady at +1.6% year-over-year, while core CPI runs at a +1.2% pace. The 2020 housing boom finally moderated with existing home sales slipping by -2.5% in November, breaking a five-month string of advances. However, the 6.7 million unit annualized sales pace was still +25.8% above the same period a year ago. New home sales dropped -11.0% in November but are still up more than +20% year-over-year. It’s important to note that the recovery thus far has been wildly uneven. Census data revealed in early December that nearly 83 million adults in the U.S. are finding it “somewhat” or “very difficult” to cover basic monthly expenses such as food, rent or mortgage, car payments, medical expenses, or student loans. This is in sharp contrast to the surge in overall wealth that has driven household net worth to a new record high. Congress did finally pass an aid package by the end of the year, offering another month of eviction protection, an extension of federal jobless benefits and a $600 stimulus check for individuals, in addition to a replenishing of the Paycheck Protection Program. The forward-looking stock markets focused on the vaccine rollout and the additional aid package rather than the rapid spread of the virus and the weakening economic numbers. Both the DOW and the S&P 500 closed the year at fresh record highs. First quarter GDP growth is likely to be relatively weak, but should improve in subsequent quarters as an increasing number of Americans are vaccinated and begin a return to pre-pandemic normality. Page 2 of 16 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 report 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. December 31, 2020 For the Quarter Ended Officer Names and Titles: Name: Sharen Jackson Title: Chief Financial Officer Name: Mary Morgan Title: Deputy Director of Finance Page 3 of 16 Sharen Jackson Mary Morgan Executive Summary As of 12/31/20 City of Southlake 163,193,822.97 163,035,121.51 162,467,980.62 158,701.46 Unrealized Gain /(Loss) Par Value Book Value Beginning Values as of 09/30/20 Market Value Market Value % 100.10% Weighted Avg. YTW Weighted Avg. YTM 0.681% 0.680% Account Summary Ending Values as of 12/31/20 140,230,394.64 140,176,663.66 139,438,614.59 53,730.98 100.04% 0.338% 0.338% Allocation by Security Type AGCY CALL 7% CP 9% LGIP 59% MUNICIPAL 10% TREASURY 14% Total:100% TEXSTAR 25% TEXPOOL 15% US TREAS 14% LONESTRGOV 8% LONESTRCRP 7% TAMU 5% Other Issuers 25% Total:100% Allocation by Issuer 0% 10% 20% 30% 40% 50% 60% Overnight 2 - 90 Days 6 - 12 Months 1 - 2 Years 2 - 3 Years 3 - 4 Years 59% 24% 4%5%6%3% Maturity Distribution % Weighted Average Days to Maturity: 149 A-1+13% AA+1% AAA 86% Total:100% Credit Quality Page 1 of 1Print Date: 1/14/2021 Print Time: 12:34 pm Page 4 of 16 As of 12/31/2020 Benchmark Comparison City of Southlake 0.00% 0.40% 0.80% 1.20% 1.60% 2.00% 2.40% 2.80% Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 Aug-20 Sep-20 Oct-20 Nov-20 Dec-20 1-YR CMT 3-MO CMT 6-MO CMT TEXPOOL City of Southlake Note 2: Benchmark data for TexPool is the monthly average yield. 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 CMT's are the daily averages for the previous 12-months. Page 1 of 1Print Time: 12:36 pmPrint Date: 1/14/2021 Page 5 of 16 Mty DateCUSIPSec. Description CPN Par Value Orig Cost Book Value Market Value Detail of Security Holdings As of 12/31/2020 Sec. Type Mkt Price Days to Mty Days to CallNext Call City of Southlake YTM Settle Date YTWCall Type Purch Price General Operating 10,126,728.86 10,126,728.86 10,126,728.86 10,126,728.86LNSTCRPLoneStar Corp O/N 1LGIP 100.000 100.000 0.130 0.130 10,687,489.68 10,687,489.68 10,687,489.68 10,687,489.68LNSTGOVLoneStar Gov O/N 1LGIP 100.000 100.000 0.070 0.070 20,784,825.08 20,784,825.08 20,784,825.08 20,784,825.08TEXPOOLTexPool 1LGIP 100.000 100.000 0.091 0.091 35,540,439.47 35,540,439.47 35,540,439.47 35,540,439.47TEXSTARTexSTAR 1LGIP 100.000 100.000 0.068 0.068 5,314,131.50 5,314,131.50 5,314,131.50 5,314,131.50TXCLASSTexas CLASS 1LGIP 100.000 100.000 0.140 0.140 5,000,000.00 5,022,265.63 5,000,947.00 5,002,778.0002/21/20 1.498 1.498U.S. Treasury9128283Q1TREAS NOTE 2.000 01/15/21 100.445 100.056 15 5,000,000.00 4,992,206.94 4,998,923.60 4,999,639.0007/29/20 0.310 0.310Toyota Mtr Cr89233GNS1CP - DISC 01/26/21 99.844 99.993 26 5,000,000.00 5,037,304.69 5,004,655.55 5,011,974.0002/21/20 1.483 1.483U.S. Treasury9128283X6TREAS NOTE 2.250 02/15/21 100.746 100.239 46 5,000,000.00 4,997,550.00 4,998,325.00 4,997,837.0012/01/20 0.180 0.180Baylor Scott & White07287CQ96CP - DISC 03/09/21 99.951 99.957 68 5,000,000.00 5,047,265.63 5,009,006.70 5,021,691.0002/21/20 1.475 1.475U.S. Treasury9128284B3TREAS NOTE 2.375 03/15/21 100.945 100.434 74 3,000,000.00 2,998,356.67 2,998,951.68 2,998,937.4011/20/20 0.170 0.170Univ of TX91510KQG5CP - DISC 03/16/21 99.945 99.965 75 5,000,000.00 5,038,867.19 5,007,960.05 5,025,027.0001/17/20 1.594 1.594U.S. Treasury912828C57TREAS NOTE 2.250 03/31/21 100.777 100.501 90 5,000,000.00 5,185,450.00 5,122,769.95 5,124,600.0009/02/20 0.211 0.211State of TX882724SY4MUNICIPAL 4.000 08/26/21 103.709 102.492 238 2,000,000.00 2,000,000.00 2,000,000.00 1,999,660.0012/23/20 0.219 0.219TX Pub Fin Auth882669BQ6MUNICIPAL 0.219 02/01/22 100.000 99.983 397 5,000,000.00 4,993,250.00 4,993,980.00 4,997,372.5010/13/20 0.228 0.228FFCB3133EMCH3AGCY CALL 10/13/2021 0.160 10/13/22 CONT 99.865 99.947 651 286 2,500,000.00 2,800,650.00 2,780,054.23 2,781,250.0010/28/20 0.260 0.260Texas A&M Univ8821356W1MUNICIPAL 5.000 05/15/23 112.026 111.250 865 5,000,000.00 5,000,000.00 5,000,000.00 5,000,514.5012/11/20 0.350 0.350FHLMC3134GXGR9AGCY CALL 6/11/2021 0.350 12/11/23 QRTLY 100.000 100.010 1,075 162 4,485,000.00 4,831,735.35 4,807,475.31 4,815,499.6509/29/20 0.400 0.400Texas A&M Univ88213AKB0MUNICIPAL 2.549 05/15/24 107.731 107.369 1,231 139,438,614.59 140,398,516.69 140,176,663.66 140,230,394.64 149Total for General Operating 100.730 100.607 0.338 0.338 139,438,614.59 140,398,516.69 140,176,663.66 140,230,394.64 149Total for City of Southlake 100.730 100.607 0.338 0.338 0 Print Date: 1/14/2021 Print Time: 12:36 pm Page 1 of 1 Page 6 of 16 CUSIP Change in Value From 09/30/2020 to 12/31/2020 Amortization / Accretion Realized Gain/(Loss) Book Value Cost of Purchases Market ValueMarket Value Book Value Maturities / Calls / Sales City of Southlake Change in Mkt Value 09/30/20 12/31/20 12/31/2009/30/20Security Type Security Description Community Enhancement Dev Corp TEXPOOL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 LGIP 0.00 TexPool 0.00 0.00 Total for Community Enhancement Dev Corp 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Crime Control District TEXSTAR 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 LGIP 0.00 TexSTAR 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 0.00 10,126,728.86 9,123,347.55 10,126,728.86 9,123,347.55 1,003,381.31 0.00 0.00 LGIP 1,003,381.31 LoneStar Corp O/N LNSTGOV 0.00 10,687,489.68 9,685,571.09 10,687,489.68 9,685,571.09 1,001,918.59 0.00 0.00 LGIP 1,001,918.59 LoneStar Gov O/N TEXPOOL 0.00 20,784,825.08 20,830,284.77 20,784,825.08 20,830,284.77 2,291,584.94 0.00 (2,337,044.63)LGIP (45,459.69)TexPool TEXSTAR 0.00 35,540,439.47 38,031,718.80 35,540,439.47 38,031,718.80 6,666.12 0.00 (2,497,945.45)LGIP (2,491,279.33)TexSTAR TXCLASS 0.00 5,314,131.50 5,312,058.41 5,314,131.50 5,312,058.41 2,073.09 0.00 0.00 LGIP 2,073.09 Texas CLASS 78009AKD5 0.00 0.00 4,999,873.50 0.00 4,997,133.35 0.00 2,866.65 (5,000,000.00)CP - DISC (4,999,873.50)Royal Bank of Canada 0.000 10/13/20 9128282Z2 0.00 0.00 5,002,915.00 0.00 5,000,209.80 0.00 (209.80)(5,000,000.00)TREAS NOTE (5,002,915.00)U.S. Treasury 1.625 10/15/20 3130AHEM1 0.00 0.00 10,009,036.00 0.00 9,999,969.40 0.00 30.60 (10,000,000.00)AGCY BULET (10,009,036.00)FHLB 1.625 10/23/20 9128283G3 0.00 0.00 10,020,043.00 0.00 9,998,864.95 0.00 1,135.05 (10,000,000.00)TREAS NOTE (10,020,043.00)U.S. Treasury 1.750 11/15/20 07287CM17 0.00 0.00 4,998,131.50 0.00 4,998,644.45 0.00 1,355.55 (5,000,000.00)CP - DISC (4,998,131.50)Baylor Scott & White 0.000 12/01/20 9128283L2 0.00 0.00 5,017,970.50 0.00 5,002,830.70 0.00 (2,830.70)(5,000,000.00)TREAS NOTE (5,017,970.50)U.S. Treasury 1.875 12/15/20 9128283Q1 0.00 5,000,947.00 5,026,562.50 5,002,778.00 5,007,170.10 0.00 (6,223.10) 0.00 TREAS NOTE (23,784.50)U.S. Treasury 2.000 01/15/21 89233GNS1 0.00 4,998,923.60 4,996,607.50 4,999,639.00 4,994,962.50 0.00 3,961.10 0.00 CP - DISC 3,031.50 Toyota Mtr Cr 0.000 01/26/21 9128283X6 0.00 5,004,655.55 5,039,062.50 5,011,974.00 5,014,173.60 0.00 (9,518.05) 0.00 TREAS NOTE (27,088.50)U.S. Treasury 2.250 02/15/21 07287CQ96 0.00 4,998,325.00 0.00 4,997,837.00 0.00 4,997,550.00 775.00 0.00 CP - DISC 4,997,837.00 Baylor Scott & White 0.000 03/09/21 9128284B3 0.00 5,009,006.70 5,050,000.00 5,021,691.00 5,020,357.60 0.00 (11,350.90) 0.00 TREAS NOTE (28,309.00)U.S. Treasury 2.375 03/15/21 91510KQG5 0.00 2,998,951.68 0.00 2,998,937.40 0.00 2,998,356.67 595.01 0.00 CP - DISC 2,998,937.40 Univ of TX 0.000 03/16/21 912828C57 0.00 5,007,960.05 5,052,539.00 5,025,027.00 5,016,188.40 0.00 (8,228.35) 0.00 TREAS NOTE (27,512.00)U.S. Treasury 2.250 03/31/21 882724SY4 0.00 5,122,769.95 5,171,300.00 5,124,600.00 5,170,427.50 0.00 (47,657.55) 0.00 MUNICIPAL (46,700.00)State of TX 4.000 08/26/21 882669BQ6 0.00 2,000,000.00 0.00 1,999,660.00 0.00 2,000,000.00 0.00 0.00 MUNICIPAL 1,999,660.00 TX Pub Fin Auth 0.219 02/01/22 3134GVKS6 0.00 0.00 5,001,793.50 0.00 5,000,000.00 0.00 0.00 (5,000,000.00)AGCY CALL (5,001,793.50)FHLMC 0.800 04/20/22 3133EMCH3 0.00 4,993,980.00 0.00 4,997,372.50 0.00 4,993,250.00 730.00 0.00 AGCY CALL 4,997,372.50 FFCB 0.160 10/13/22 8821356W1 0.00 2,780,054.23 0.00 2,781,250.00 0.00 2,800,650.00 (20,595.77) 0.00 MUNICIPAL 2,781,250.00 Texas A&M Univ 5.000 05/15/23 Print Date: 1/14/2021 Print Time: 12:36 pm Page 1 of 2 Page 7 of 16 CUSIP Change in Value From 09/30/2020 to 12/31/2020 Amortization / Accretion Realized Gain/(Loss) Book Value Cost of Purchases Market ValueMarket Value Book Value Maturities / Calls / Sales City of Southlake Change in Mkt Value 09/30/20 12/31/20 12/31/2009/30/20Security Type Security Description General Operating 3134GXGR9 0.00 5,000,000.00 0.00 5,000,514.50 0.00 5,000,000.00 0.00 0.00 AGCY CALL 5,000,514.50 FHLMC 0.350 12/11/23 88213AKB0 0.00 4,807,475.31 4,825,007.85 4,815,499.65 4,831,208.54 0.00 (23,733.23) 0.00 MUNICIPAL (9,508.20)Texas A&M Univ 2.549 05/15/24 140,176,663.66 0.00 Total for General Operating 163,193,822.97 140,230,394.64 163,035,121.51 27,095,430.72 (49,834,990.08) (118,898.49)(22,963,428.33) Parks Development Corporation TEXPOOL 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 LGIP 0.00 TexPool TEXSTAR 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 LGIP 0.00 TexSTAR 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 140,176,663.66 Total for City of Southlake 163,193,822.97 140,230,394.64 163,035,121.51 27,095,430.72 (49,834,990.08)(118,898.49)(22,963,428.33) Print Date: 1/14/2021 Print Time: 12:36 pm Page 2 of 2 Page 8 of 16 From 09/30/2020 to 12/31/2020 City of Southlake Beg. Accrued Net Income Security DescriptionCUSIP Disc Accr / Prem Amort Earned Income Interest Earned Interest Rec'd / Sold / Matured Interest Purchased Ending AccruedSecurity Type Community Enhancement Dev Corp 0.00 0.00 0.00 0.00 0.00 0.00 Total for Community Enhancement Dev Corp 0.00 Crime Control District 0.00 0.00 0.00 0.00 0.00 0.00 Total for Crime Control District 0.00 General Operating LNSTCRP LoneStar Corp O/N 0.00 3,381.31 0.00 0.00 3,381.31 3,381.31 LGIP 0.00 LNSTGOV LoneStar Gov O/N 0.00 1,918.59 0.00 0.00 1,918.59 1,918.59 LGIP 0.00 TEXPOOL TexPool 0.00 5,623.17 0.00 0.00 5,623.17 5,623.17 LGIP 0.00 TEXSTAR TexSTAR 0.00 8,720.67 0.00 0.00 8,720.67 8,720.67 LGIP 0.00 TXCLASS Texas CLASS 0.00 2,073.09 0.00 0.00 2,073.09 2,073.09 LGIP 0.00 78009AKD5 Royal Bank of Canada 0.000 10/13/20 0.00 2,866.65 0.00 0.00 0.00 0.00 CP - DISC 2,866.65 9128282Z2 U.S. Treasury 1.625 10/15/20 0.00 2,898.12 37,517.08 0.00 3,107.92 40,625.00 TREAS NOTE (209.80) 3130AHEM1 FHLB 1.625 10/23/20 0.00 9,961.16 71,319.44 0.00 9,930.56 81,250.00 AGCY BULET 30.60 9128283G3 U.S. Treasury 1.750 11/15/20 0.00 22,534.51 66,100.54 0.00 21,399.46 87,500.00 TREAS NOTE 1,135.05 07287CM17 Baylor Scott & White 0.000 12/01/20 0.00 1,355.55 0.00 0.00 0.00 0.00 CP - DISC 1,355.55 9128283L2 U.S. Treasury 1.875 12/15/20 0.00 16,380.37 27,663.93 0.00 19,211.07 46,875.00 TREAS NOTE (2,830.70) 9128283Q1 U.S. Treasury 2.000 01/15/21 0.00 18,776.90 21,195.65 46,195.65 25,000.00 0.00 TREAS NOTE (6,223.10) 89233GNS1 Toyota Mtr Cr 0.000 01/26/21 0.00 3,961.10 0.00 0.00 0.00 0.00 CP - DISC 3,961.10 9128283X6 U.S. Treasury 2.250 02/15/21 0.00 18,606.95 14,368.21 42,493.21 28,125.00 0.00 TREAS NOTE (9,518.05) 07287CQ96 Baylor Scott & White 0.000 03/09/21 0.00 775.00 0.00 0.00 0.00 0.00 CP - DISC 775.00 9128284B3 U.S. Treasury 2.375 03/15/21 0.00 18,828.66 5,248.62 35,428.18 30,179.56 0.00 TREAS NOTE (11,350.90) 91510KQG5 Univ of TX 0.000 03/16/21 0.00 595.01 0.00 0.00 0.00 0.00 CP - DISC 595.01 912828C57 U.S. Treasury 2.250 03/31/21 0.00 20,205.71 309.07 28,743.13 28,434.06 0.00 TREAS NOTE (8,228.35) 882724SY4 State of TX 4.000 08/26/21 0.00 2,753.41 15,890.41 66,301.37 50,410.96 0.00 MUNICIPAL (47,657.55) 882669BQ6 TX Pub Fin Auth 0.219 02/01/22 0.00 97.33 0.00 97.33 97.33 0.00 MUNICIPAL 0.00 3134GVKS6 FHLMC 0.800 04/20/22 0.00 2,111.11 18,222.22 0.00 2,111.11 20,333.33 AGCY CALL 0.00 3133EMCH3 FFCB 0.160 10/13/22 0.00 2,463.33 0.00 1,733.33 1,733.33 0.00 AGCY CALL 730.00 8821356W1 Texas A&M Univ 5.000 05/15/23 (56,597.22) 1,279.23 0.00 15,972.22 21,875.00 62,500.00 MUNICIPAL (20,595.77) 3134GXGR9 FHLMC 0.350 12/11/23 0.00 972.22 0.00 972.22 972.22 0.00 AGCY CALL 0.00 88213AKB0 Texas A&M Univ 2.549 05/15/24 0.00 4,847.43 43,188.56 14,607.89 28,580.66 57,161.33 MUNICIPAL (23,733.23) Print Time: 12:36 pmPrint Date: 1/14/2021 Page 1 of 2 Page 9 of 16 From 09/30/2020 to 12/31/2020 City of Southlake Beg. Accrued Net Income Security DescriptionCUSIP Disc Accr / Prem Amort Earned Income Interest Earned Interest Rec'd / Sold / Matured Interest Purchased Ending AccruedSecurity Type (56,597.22) 173,986.58 252,544.53 292,885.07 321,023.73 417,961.49 Total for General Operating (118,898.49) Parks Development Corporation 0.00 0.00 0.00 0.00 0.00 0.00 Total for Parks Development Corporation 0.00 (56,597.22) 173,986.58 321,023.73 252,544.53 292,885.07 417,961.49 Total for City of Southlake (118,898.49) Print Time: 12:36 pmPrint Date: 1/14/2021 Page 2 of 2 Page 10 of 16 Investment Transactions CUSIP Price Total AmountSecurity Description From 10/01/2020 to 12/31/2020 Security Type Coupon Mty Date Call Date Trade Date Settle Date Par Value City of Southlake Realized Gain / Loss YTM YTW Principal Amount Int Purchased / Received General Operating Calls 100.00004/20/22 0.800FHLMCAGCY CALL3134GVKS610/20/2010/19/20 5,000,000.00 5,000,000.00 0.800 0.800 0.00 5,000,000.00 10/20/20 5,000,000.00 5,000,000.00 Total for: Calls 0.800 0.800 5,000,000.00 0.00 Maturities 100.00010/13/20Royal Bank of CanadaCP - DISC78009AKD510/13/2010/13/20 5,000,000.00 5,000,000.00 1.742 0.00 5,000,000.00 100.00010/15/20 1.625U.S. TreasuryTREAS NOTE9128282Z210/15/2010/15/20 5,000,000.00 5,000,000.00 1.514 0.00 5,000,000.00 100.00010/23/20 1.625FHLBAGCY BULET3130AHEM110/23/2010/23/20 5,000,000.00 5,000,000.00 1.630 0.00 5,000,000.00 100.00010/23/20 1.625FHLBAGCY BULET3130AHEM110/23/2010/23/20 5,000,000.00 5,000,000.00 1.630 0.00 5,000,000.00 100.00011/15/20 1.750U.S. TreasuryTREAS NOTE9128283G311/15/2011/15/20 5,000,000.00 5,000,000.00 2.172 0.00 5,000,000.00 100.00011/15/20 1.750U.S. TreasuryTREAS NOTE9128283G311/15/2011/15/20 5,000,000.00 5,000,000.00 1.517 0.00 5,000,000.00 100.00012/01/20Baylor Scott & WhiteCP - DISC07287CM1712/01/2012/01/20 5,000,000.00 5,000,000.00 0.160 0.00 5,000,000.00 100.00012/15/20 1.875U.S. TreasuryTREAS NOTE9128283L212/15/2012/15/20 5,000,000.00 5,000,000.00 1.597 0.00 5,000,000.00 40,000,000.00 40,000,000.00 Total for: Maturities 1.495 40,000,000.00 0.00 Purchases 99.86510/13/22 0.160FFCBAGCY CALL3133EMCH310/13/2010/06/20 5,000,000.00 4,993,250.00 0.228 0.228 0.00 4,993,250.00 10/13/21 112.02605/15/23 5.000Texas A&M UnivMUNICIPAL8821356W110/28/2010/26/20 2,500,000.00 2,857,247.22 0.260 0.260 56,597.22 2,800,650.00 05/15/23 99.94503/16/21Univ of TXCP - DISC91510KQG511/20/2011/19/20 3,000,000.00 2,998,356.67 0.170 0.170 0.00 2,998,356.67 99.95103/09/21Baylor Scott & WhiteCP - DISC07287CQ9612/01/2012/01/20 5,000,000.00 4,997,550.00 0.180 0.180 0.00 4,997,550.00 100.00012/11/23 0.350FHLMCAGCY CALL3134GXGR912/11/2012/09/20 5,000,000.00 5,000,000.00 0.350 0.350 0.00 5,000,000.00 06/11/21 100.00002/01/22 0.219TX Pub Fin AuthMUNICIPAL882669BQ612/23/2012/11/20 2,000,000.00 2,000,000.00 0.219 0.219 0.00 2,000,000.00 22,846,403.89 22,500,000.00 Total for: Purchases 0.239 0.239 22,789,806.67 56,597.22 Income Payments 10/15/20 1.625U.S. TreasuryTREAS NOTE9128282Z210/15/2010/15/20 40,625.00 40,625.00 0.00 04/20/22 0.800FHLMCAGCY CALL3134GVKS610/20/2010/20/20 20,333.33 20,333.33 0.00 10/23/20 1.625FHLBAGCY BULET3130AHEM110/23/2010/23/20 40,625.00 40,625.00 0.00 10/23/20 1.625FHLBAGCY BULET3130AHEM110/23/2010/23/20 40,625.00 40,625.00 0.00 05/15/23 5.000Texas A&M UnivMUNICIPAL8821356W111/15/2011/16/20 62,500.00 62,500.00 0.00 05/15/24 2.549Texas A&M UnivMUNICIPAL88213AKB011/15/2011/16/20 57,161.33 57,161.33 0.00 Page 1 of 3Print Date: 1/14/2021 Print Time: 12:36 pm Page 11 of 16 Investment Transactions CUSIP Price Total AmountSecurity Description From 10/01/2020 to 12/31/2020 Security Type Coupon Mty Date Call Date Trade Date Settle Date Par Value City of Southlake Realized Gain / Loss YTM YTW Principal Amount Int Purchased / Received General Operating Income Payments 11/15/20 1.750U.S. TreasuryTREAS NOTE9128283G311/15/2011/16/20 43,750.00 43,750.00 0.00 11/15/20 1.750U.S. TreasuryTREAS NOTE9128283G311/15/2011/16/20 43,750.00 43,750.00 0.00 12/15/20 1.875U.S. TreasuryTREAS NOTE9128283L212/15/2012/16/20 46,875.00 46,875.00 0.00 396,244.66 Total for: Income Payments 0.00 396,244.66 Page 2 of 3Print Date: 1/14/2021 Print Time: 12:36 pm Page 12 of 16 Investment Transactions CUSIP Price Total AmountSecurity Description From 10/01/2020 to 12/31/2020 Security Type Coupon Mty Date Call Date Trade Date Settle Date Par Value City of Southlake Realized Gain / Loss YTM YTW Principal Amount Int Purchased / Received YTWYTMRealized G/LTotal AmountQuantityTransaction Type 5,000,000.00 5,000,000.00Total Calls 0.800 0.800 40,000,000.00 40,000,000.00Total Maturities 1.495 22,846,403.89 22,500,000.00Total Purchases 0.239 0.239 396,244.66 0.00Total Income Payments Total for All Portfolios Page 3 of 3Print Date: 1/14/2021 Print Time: 12:36 pm Page 13 of 16 CUSIP Amortization and Accretion From 09/30/2020 to 12/31/2020 Purchase QtySettle Date Orig Price Original Cost Amrt/Accr for Period Total Amrt/Accr Since Purch Remaining Disc / Prem Book ValueNext Call Date City of Southlake Security DescriptionSecurity Type General Operating 78009AKD5 0.00 2,866.65 0.00 0.00 0.0001/21/20 98.729 0.00Royal Bank of Canada 0.000 10/13/20CP - DISC 9128282Z2 0.00 (209.80) 0.00 0.00 0.0002/21/20 100.070 0.00U.S. Treasury 1.625 10/15/20TREAS NOTE 3130AHEM1 0.00 30.60 0.00 0.00 0.0010/25/19 99.995 0.00FHLB 1.625 10/23/20AGCY BULET 9128283G3 0.00 1,135.05 0.00 0.00 0.0005/31/19 100.168 0.00U.S. Treasury 1.750 11/15/20TREAS NOTE 07287CM17 0.00 1,355.55 0.00 0.00 0.0009/22/20 99.969 0.00Baylor Scott & White 0.000 12/01/20CP - DISC 9128283L2 0.00 (2,830.70) 0.00 0.00 0.0001/17/20 100.250 0.00U.S. Treasury 1.875 12/15/20TREAS NOTE 9128283Q1 5,022,265.63 (6,223.10) (21,318.63) (947.00) 5,000,000.0002/21/20 100.445 5,000,947.00U.S. Treasury 2.000 01/15/21TREAS NOTE 89233GNS1 4,992,206.94 3,961.10 6,716.66 1,076.40 5,000,000.0007/29/20 99.844 4,998,923.60Toyota Mtr Cr 0.000 01/26/21CP - DISC 9128283X6 5,037,304.69 (9,518.05) (32,649.14) (4,655.55) 5,000,000.0002/21/20 100.746 5,004,655.55U.S. Treasury 2.250 02/15/21TREAS NOTE 07287CQ96 4,997,550.00 775.00 775.00 1,675.00 5,000,000.0012/01/20 99.951 4,998,325.00Baylor Scott & White 0.000 03/09/21CP - DISC 9128284B3 5,047,265.63 (11,350.90) (38,258.93) (9,006.70) 5,000,000.0002/21/20 100.945 5,009,006.70U.S. Treasury 2.375 03/15/21TREAS NOTE 91510KQG5 2,998,356.67 595.01 595.01 1,048.32 3,000,000.0011/20/20 99.945 2,998,951.68Univ of TX 0.000 03/16/21CP - DISC 912828C57 5,038,867.19 (8,228.35) (30,907.14) (7,960.05) 5,000,000.0001/17/20 100.777 5,007,960.05U.S. Treasury 2.250 03/31/21TREAS NOTE 882724SY4 5,185,450.00 (47,657.55) (62,680.05) (122,769.95) 5,000,000.0009/02/20 103.709 5,122,769.95State of TX 4.000 08/26/21MUNICIPAL 882669BQ6 2,000,000.00 0.00 0.00 0.00 2,000,000.0012/23/20 100.000 2,000,000.00TX Pub Fin Auth 0.219 02/01/22MUNICIPAL 3134GVKS6 0.00 0.00 0.00 0.00 0.0004/17/20 100.000 0.00FHLMC 0.800 04/20/22AGCY CALL 10/20/20 3133EMCH3 4,993,250.00 730.00 730.00 6,020.00 5,000,000.0010/13/20 99.865 4,993,980.00FFCB 0.160 10/13/22AGCY CALL 10/13/21 8821356W1 2,800,650.00 (20,595.77) (20,595.77) (280,054.23) 2,500,000.0010/28/20 112.026 2,780,054.23Texas A&M Univ 5.000 05/15/23MUNICIPAL 3134GXGR9 5,000,000.00 0.00 0.00 0.00 5,000,000.0012/11/20 100.000 5,000,000.00FHLMC 0.350 12/11/23AGCY CALL 06/11/21 88213AKB0 4,831,735.35 (23,733.23) (24,260.04) (322,475.31) 4,485,000.0009/29/20 107.731 4,807,475.31Texas A&M Univ 2.549 05/15/24MUNICIPAL (118,898.49) 57,944,902.10Total for General Operating (221,853.03) (738,049.07) 56,985,000.00 57,723,049.07 57,944,902.10 (118,898.49)Total for City of Southlake (221,853.03)(738,049.07) 56,985,000.00 57,723,049.07 0.00 0 Print Date: 1/14/2021 Print Time: 12:37 pm Page 1 of 1 Page 14 of 16 CUSIP Pay Date Interest City of Southlake Projected Cash Flows Total AmountSecurity Type Cash Flows for next 180 days from 12/31/2020 Security Description Principal General Operating 50,000.00 5,050,000.009128283Q1TREAS NOTE U.S. Treasury 2.000 01/15/21 01/15/21 5,000,000.00 0.00 5,000,000.0089233GNS1CP - DISC Toyota Mtr Cr 0.000 01/26/21 01/26/21 5,000,000.00 56,250.00 5,056,250.009128283X6TREAS NOTE U.S. Treasury 2.250 02/15/21 02/15/21 5,000,000.00 0.00 5,000,000.0007287CQ96CP - DISC Baylor Scott & White 0.000 03/09/21 03/09/21 5,000,000.00 59,375.00 5,059,375.009128284B3TREAS NOTE U.S. Treasury 2.375 03/15/21 03/15/21 5,000,000.00 0.00 3,000,000.0091510KQG5CP - DISC Univ of TX 0.000 03/16/21 03/16/21 3,000,000.00 56,250.00 5,056,250.00912828C57TREAS NOTE U.S. Treasury 2.250 03/31/21 03/31/21 5,000,000.00 4,000.00 4,000.003133EMCH3AGCY CALL FFCB 0.160 10/13/22 04/13/21 0.00 62,500.00 62,500.008821356W1MUNICIPALTexas A&M Univ 5.000 05/15/23 05/15/21 0.00 57,161.32 57,161.3288213AKB0MUNICIPALTexas A&M Univ 2.549 05/15/24 05/15/21 0.00 8,750.00 8,750.003134GXGR9AGCY CALL FHLMC 0.350 12/11/23 06/11/21 0.00 33,354,286.32Total for General Operating 354,286.32 33,000,000.00 Page 1 of 2Print Date: 1/14/2021 Print Time: 12:37 pm Page 15 of 16 CUSIP Pay Date Interest City of Southlake Projected Cash Flows Total AmountSecurity Type Cash Flows for next 180 days from 12/31/2020 Security Description Principal 50,000.00 10,050,000.00January 2021 10,000,000.00 56,250.00 5,056,250.00February 2021 5,000,000.00 115,625.00 18,115,625.00March 2021 18,000,000.00 4,000.00 4,000.00April 2021 0.00 119,661.32 119,661.32May 2021 0.00 8,750.00 8,750.00June 2021 0.00 354,286.32 33,354,286.32Total Projected Cash Flows for City of Southlake 33,000,000.00 Total for All Portfolios Page 2 of 2Print Date: 1/14/2021 Print Time: 12:37 pm Page 16 of 16