Item 3B2 - Financial ReportReference
Page 3
Page 3
Page 4
Page 4
Page 5
MONTHLY FINANCIAL REPORT
January 2023
= Negative Variance of > 4% compared to seasonal trends.
Positive
Negative
PERFORMANCE AT A GLANCE
Year to Date 3 year Trend
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.
GENERAL FUND
PositiveGeneral Fund Exp. Vs. Rev.
Sales Tax Revenue (2 months prior activity)
Property Tax Revenue
Positive
Positive Positive
Positive
City of Southlake Monthly Financial Report 1 2/15/2023
National GDP:
Housing Starts:
Housing starts in December were at a seasonally
adjusted rate of 1,382,000, which is 1.4% below the
revised previous month figure of 1,401,000.
-1.4%
UNEMPLOYMENT RATES
3.4%
The Dallas/Fort Worth/Arlington Metropolitan Area
unemployment rate for December 2022 (preliminary)
decreased slightly to 3.2% when compared to 3.3% in
November 2022.
3.2%
State-wide:3.9%
The Texas Unemployment rate for December 2022
(preliminary) decreased slightly to 3.9% from 4.0% in
November 2022.
DFW Area:
ECONOMIC INDICATORS
NATIONAL ECONOMY
FINANCIAL ACTIVITY2.9%
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 4th
quarter of 2022 increased at a rate of 2.9%. In the 3rd
quarter of 2022, GDP increased at a rate of 3.2%.
The National Unemployment rate for January 2023
decreased to 3.4% when compared to 3.5% in
December 2022.
National:
5 YEAR TREND OF NEW CONSTRUCTION PERMIT VALUES
$-
$10,000,000
$20,000,000
$30,000,000
$40,000,000
$50,000,000
$60,000,000
$70,000,000
$80,000,000
2019*2020*2021*2022*2023*
New Construction permit values
*October -January
City of Southlake Monthly Financial Report 2 2/15/2023
GENERAL FUND
FY 2023
REVENUE
FY 2023
EXPENDITURE VARIANCE
Oct 535,646$ 2,824,236$ (2,288,590)$
Nov 2,430,481$ 3,685,749$ (1,255,268)$
Dec 7,290,271$ 4,388,226$ 2,902,045$
Jan 15,363,722$ 3,407,553$ 11,956,169$
Feb -$ -$ -$
Mar -$ -$ -$
Apr -$ -$ -$
May -$ -$ -$
Jun -$ -$ -$
Jul -$ -$ -$
Aug -$ -$ -$
Sep -$ -$ -$
Tot 25,620,120$ 14,305,764$ 11,314,356$
POSITIVE
FY 2023 FY 2022 FY 2021
Oct 1,814,981$ 1,613,415$ 1,299,576$
Nov 1,813,575$ 1,652,674$ 1,084,677$
Dec 2,507,299$ 2,456,532$ 1,926,407$
Jan -$ 1,602,323$ 1,256,119$
Feb -$ 1,388,859$ 978,395$
Mar -$ 1,975,175$ 1,727,925$
Apr -$ 1,714,270$ 1,470,896$
May -$ 1,725,777$ 1,262,973$
Jun -$ 1,792,755$ 2,586,036$
Jul -$ 1,607,427$ 1,449,136$
Aug -$ 1,659,141$ 1,427,525$
Sep -$ 1,640,639$ 1,687,605$
Tot 6,135,855$ 20,828,987$ 18,157,270$
GENERAL FUND REVENUE VS EXPENDITURES 2022
OVERALL FUND PERFORMANCE:
REVENUE ANALYSIS
GENERAL FUND SALES TAX 2023-2021 COMPARISON
CHART OUTLOOK:
CHART OUTLOOK:
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 $11.3M.The significant variance is due to the significant
portion of property tax revenue collected (approximately 75%) of the budgeted property tax revenue which is the largest revenue sources for the general fund.
Year to date sales tax collections are trending above FY 2022 (7.2%)and FY 2021 (42.3%)collections.December sales were 2.1%and 30.2%above December collections for FY 2022 and FY 2021,respectively.Year to
date collections are above budget for the year therefore the outlook is considered positive. Staff will continue to closely monitor collections.
POSITIVE
$-
$500,000
$1,000,000
$1,500,000
$2,000,000
$2,500,000
$3,000,000
FY 2023 FY 2022 FY 2021
$-
$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
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2023 REVENUE FY 2023 EXPENDITURE 2022 EXPEND.
City of Southlake Monthly Financial Report 3 2/15/2023
GENERAL FUND
FY 2023 FY 2022 FY 2021
Oct 380,169$ 653,703$ 778,578$
Nov 2,011,080$ 2,017,203$ 1,582,957$
Dec 4,964,620$ 6,068,454$ 6,036,699$
Jan 12,756,146$ 11,588,414$ 13,167,125$
Feb -$ 5,872,247$ 4,445,041$
Mar -$ 584,684$ 411,151$
Apr -$ 554,247$ 259,058$
May -$ 151,717$ 152,945$
Jun -$ 502,344$ 389,839$
Jul *-$ (1,310,741)$ (1,365,991)$
Aug -$ 69,630$ 52,655$
Sep -$ 111,205$ 190,848$
Tot 20,112,015$ 26,863,107$ 26,100,905$
POSITIVE
FY 2023 FY 2022 FY 2021
Oct 137,332$ 214,445$ 50,043$
Nov 118,803$ 185,109$ 69,734$
Dec 88,212$ 94,663$ 102,515$
Jan 231,884$ 167,045$ 88,737$
Feb -$ 111,545$ 76,270$
Mar -$ 154,046$ 150,142$
Apr -$ 277,691$ 124,870$
May -$ 788,270$ 136,364$
Jun -$ 133,244$ 158,786$
Jul -$ 192,902$ 170,985$
Aug -$ 184,578$ 217,599$
Sep -$ 154,833$ 221,982$
Tot 576,231$ 2,658,371$ 1,568,027$
PERMIT REVENUE 2023-2021 COMPARISON
CHART OUTLOOK:
REVENUE ANALYSIS (continued)
PROPERTY TAX 3 YEAR TREND
CHART OUTLOOK:
As of December the 2023 YTD property tax collections ($20,112,015)are approximately 1.1%and 6.7%lower than 2022 YTD ($20,327,774)and 2021 YTD ($21,565,359),respectively.As indicated on the chart,the
majority of the property tax revenue is collected in the second quarter of the fiscal year. YTD collections are trending below budget.
* Net transfer of TIF revenues to TIF
fund
The value of new construction permits ($66.9M+)issued for FY 2023 YTD is approximately 58.8%and 104.8%higher when compared to FY 2022 and FY 2021,respectively.FY 2023 collections are 12.9%lower and
85.3% higher when compared to FY 2022 and 2021, respectively. The permit revenue year to date is trending above budget therefore the outlook is considered positive.
POSITIVE
$(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 2023 FY 2022 FY 2021
$-
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
$900,000
Oct Nov Dec Jan Feb Mar Apr May Jun Jul Aug Sep
FY 2023 FY 2022 FY 2021
City of Southlake Monthly Financial Report 4 2/15/2023
FY 2023 ACTUAL
YTD (JANUARY)
FY 2022 ACTUAL YTD
(JANUARY)
FY 2023 BUDGET
YTD (JANUARY)FY 2021 % SPENT
335,558$ 336,128$ 383,900$ 87.41%
224,537$ 206,301$ 279,176$ 80.43%
2,008,976$ 1,737,633$ 2,473,469$ 81.22%
183,446$ 167,552$ 239,301$ 76.66%
6,349,854$ 5,731,154$ 7,894,095$ 80.44%
113,254$ 88,881$ 118,419$ 95.64%
747,507$ 816,982$ 1,173,109$ 63.72%
283,571$ 245,015$ 345,942$ 81.97%
865,971$ 917,775$ 1,258,373$ 68.82%
785,960$ 664,520$ 913,524$ 86.04%
1,504,361$ 1,228,741$ 1,921,844$ 78.28%
903,166$ 825,962$ 1,516,650$ 59.55%
14,306,161$ 12,966,644$ 18,517,802$ 77.26%
EXPENDITURE ANALYSIS
POSITIVE
(51,804)$
55,855$
1,544,241$
5,165$
425,602$
62,371$
392,402$
CSO
DPS
ED
FIN
HR
IT
DEPARTMENTAL EXPENDITURES SUMMARY
18,236$ 54,639$ COMM
BUDGET VARIANCE
48,342$
464,493$
121,440$
275,620$
77,204$
1,339,517$
As indicated above,2023 expenditures are above 2022 expenditures for the same period with a increase of 10.3%primarily due to the employee compensation system moving DPS to the 80th percentile.The outlook is
positive expenditures are below budgeted expenditures for the fiscal year.
FY 2022/2023 YTD
VARIANCE
(570)$
271,343$
15,894$
618,700$
24,373$
(69,475)$
SS
Totals
PW
CMO
CS
4,211,641$
CHART OUTLOOK:
613,484$
417,483$
38,556$
127,564$ PDS
$-
$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 2023 ACTUAL YTD (JANUARY)FY 2022 ACTUAL YTD (JANUARY)FY 2023 BUDGET YTD (JANUARY)
City of Southlake Monthly Financial Report 5 2/15/2023
The Marq Financial Review
January 24, 2023
CEDC FINANCIAL DASHBOARD
as ar:11240023 10-33 AM
MARQ
93.53%
59.90%
156.14%
Target
ATT
1.34M
1.44M
Revenue
Expense
�a�rzo22 9I31)12023
cc
68.80%
102.38%
6720%
Target
ATT
1.15M
1.13M
Revenue
Expense
Net Revenue- Current & Previous Year
LH
44.06%
33.50%
131.51%
Target
ATT
192.74K
302.84K
Revenue
Expense
CCR ■LHR —Told Revenue LY
95p(
51K 73K 58K 50K 05K
_
9oac 46K 43K
270K 30K
48K 2R9K 257K
]5aK 27K 50K 27oC
_ 250K 257K
4aaC
193K
16aK 309K 3012K 293K 302K 293K
— 275K 281K 2.
235K 245K 250N
223N 228K
100K
50K
a
Jan 2U22 Feh 2922 Yar2(122 Apr = IIv720N Jin = Jil2022 ALq2022 Sep 2022 Od XQ] Hw 2022 Oc 2022 �n2(124
The Marq Rentals Revenue (Net)
MCC-Renid-R venue LH-R—t.VRev —
OON
50K
40K
30K
20K
10K .
1K
Jan 2022 Feb 2R2 Mar2022 Apr 20122 May2022 Jun 2022 Ju12022 Aug 2022 Sep 2022 Oct 2022 N-2022 Oec 2022 Jai 2R23
The Marq Membership Revenue [Net]
200K
150K
10RK
50K
OK
Jan 2022 Feb 2022 Mar2022 Apr2022 MW2022 Jrn 2022 Ad 2022 Aug 2022 Sep2022 Oe 2022 Nov 2022 Oec2022 Jan AM
186 184 177
153
123
70
27 17 24 1 1 -1 1 1 -----
1941 1945 1944
2001 2084
2289
2444 2506 2513
2458
2521 2585 2662 2679
2738
2827
2989
3076 3131 3197
3153
3162 3230
3291
0
100
200
300
400
500
600
1000
1500
2000
2500
3000
3500
2020-122021-012021-022021-032021-042021-052021-062021-072021-082021-102021-112021-122022-012022-022022-032022-042022-052022-062022-072022-082022-092022-102022-112022-12SuspensionsMembershipsPeriod
CHAMPIONS CLUB MEMBERSHIP TRENDS
JOINS TERMS JOINS TERMS JOINS TERMS JOINS TERMS
FY2020 FY2021 FY2022 FY2023
ADULT 379 -360 588 -410 780 -568 203 -140
FAM 224 -414 424 -334 565 -391 141 -143
FAM-NC 479 -700 804 -698 931 -761 229 -183
SENIOR 112 -140 201 -124 274 -165 90 -55
YOUTH 82 -66 157 -115 197 -156 41 -41
TOTALS 1276 -1680 2174 -1681 2747 -2041 704 -562
NET -404 493 706 142
379
-360
588
-410
780
-568
203
-140
224
-414
424
-334
565
-391
141
-143
479
-700
804
-698
931
-761
229
-183
112
-140
201
-124
274
-165
90
-55
82
-66
157
-115
197
-156
41
-41
-3000
-2000
-1000
0
1000
2000
3000
-1000
-800
-600
-400
-200
0
200
400
600
800
1000
1200
MULTI-YEAR MEMBERSHIPS ANALYSIS BY MEMBERSHIP TYPE
ADULT FAM FAM-NC SENIOR YOUTH TOTALS NET
FY2023 CC Membership Terminations by Reason and by Month
100 94
1
Sc 71
Sc
40
20
1
00D000000
a
Failed Payment
� Oct-22
71
m Nov-22
94
m Dec-22
81
mJar�23
0
m Feb-23
0
mMar-23
0
mApr-23
0
m May-23
0
■ Jun-23
0
r Jul-23
0
Aug-23
0
MSep-23
0
- Totals
248
%
43.8%
Top Reason Given:
"I am too busy."
54
2929
25
DODOODODO
Not Utilizing Membership
54
29
29
0
0
0
0
0
0
0
0
0
112
19.9%
000000000
Relocating/Travel
23
0 0 0 0 a 0 0 0 0
Transfer
22
19
23
0
0
0
0
0
0
0
0
0
64
11.4%
32 OOOO11D
Y _
Unsatisfied with Facility or
Amenities
3
2
3
0
0
0
0
0
0
0
0
0
8
1.4%
192121
55
1_ ODOQD0 OD
DOD00000D
Selected other service
No Reason! Other
provider
5
19
5
21
1
21
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
11
61
2.0°A
10.9%
Sales Tax Update
Sales Tax Collections
$-
$100,000
$200,000
$300,000
$400,000
$500,000
$600,000
$700,000
$800,000
$900,000
$1,000,000
Three Year Revenue Comparison by Month
FISCAL YEAR 2021 FISCAL YEAR 2022 Fiscal Year 2023
Questions?
INVESTMENT REPORT
City of Southlake
October 1 to December 31, 2022
Contents Investment Management Team
Scott McIntyre
Senior Portfolio Manager
512.481.2009
Scott.McIntyre@HilltopSecurities.com
Greg Warner
Senior Portfolio Manager
512.481.2012
Greg.Warner@HilltopSecurities.com
Jodi Jones
Investment Reporting Manager
512.481.2076
Jodi.Jones@HilltopSecurities.com
Page 2
Market Recap � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �3
Investment Officers’ Certification � � � � � � � � � � � � � � � � � � � � � � � � � � �4
Portfolio Overview � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �5
Portfolio Overview � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �6
Asset Allocation � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �7
Credit Rating Summary � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �8
Benchmark Comparison � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �9
Fund Overview � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �10
Detail of Security Holdings � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �11
Earned Income � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �13
Investment Transactions � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �15
Investment Transactions Totals � � � � � � � � � � � � � � � � � � � � � � � � � � � �16
Amortization and Accretion � � � � � � � � � � � � � � � � � � � � � � � � � � � � �17
Projected Cash Flows� � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �18
Projected Cash Flows Totals � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �20
Disclosures & Disclaimers � � � � � � � � � � � � � � � � � � � � � � � � � � � � � � �21
City of Southlake
As of December 31, 2022
Page 3
Market Recap
The final month of a brutal year began with the November ISM manufacturing index
slipping from 50�2 to 49�0, indicating contraction in the factory sector for the first time since
the covid lockdown 2½ years ago� The ISM prices paid index tumbled from 46�6 to 43�0 as
an increasing number of purchasing managers reported falling prices� Just eight months
ago, the ISM price index stood at 87.1� However, Fed officials understand that inflation won’t
be fully under control until the labor market is in balance� Unfortunately, the November
employment report from the Bureau of Labor Statistics proved stronger-than-expected
across the board� U�S� companies added +263k jobs during the month, well above the
Bloomberg median forecast of +200k, while October payrolls were revised upward from
+261k to +284k� The labor force participation rate slipped and the headline unemployment
rate held steady at 3�7%, just a fraction above the five-decade low of 3�5%� The continued
labor market tightness resulted in a +0�6% rise in average hourly earnings, pushing the year-
over-year wage increase from a +4�9% to +5�1%�
This prompted an immediate sell-off in the bond market, but it was an extremely volatile
month and a soft CPI report (just a day before the December FOMC decision) sparked a rally
that drove yields back down� The November consumer price index (CPI) proved a welcome
relief for both the markets and the Fed� Headline CPI rose by just +0�1% in November after
troubling +0�4% gains in the previous two months� Core CPI climbed +0�2%, the smallest
monthly advance in more than a year� On an annual basis, overall CPI retreated to a +7�1%
pace while the core rate slipped to +6�0%, off highs of +9�1% and +6�6% from months
earlier� When focusing on more recent underlying trends, the outlook brightens significantly�
Over the last five months, the increase in headline CPI has averaged just +0�2%, implying an
annual inflation rate of +2�4%� Core CPI is stickier, but the +0�4% monthly average since July
indicates an annualized rate below +5�0%�
It was no surprise the following day when Fed officials voted unanimously to increase the
overnight rate by 50 basis points to a 4�25%-4�50% target range, following four straight 75
bps hikes� Since March, the committee has now raised the funds rate by a total of 425 bps,
the most aggressive tightening pace in over 40 years� The updated December “dot plot”
indicated a higher-than-expected peak rate of 5�125%, implying an additional 75 bps of
hikes may still be on tap for the first quarter of 2023� After a likely pause of between nine
and 12 months, the committee has signaled rate cuts of 100 bps in both 2024 and 2025,
while leaving the long-term neutral rate unchanged at 2�5%�
The committee’s summary of economic projections shows significantly weaker GDP, with
the 2023 growth forecast trimmed from +1�2% to +0�5%� Fed officials still seem to believe
skirting recession is a possibility, and the possibility seemed to increase as December drew
to a close� The final reading of third quarter GDP was revised upward from +2�9% to +3�2%
on stronger consumer spending, while the Atlanta Fed’s fourth quarter GDPNow measure
was tracking at +3�7% just before Christmas�
Fed tightening is nearing an end, but the first quarter begins (yet again) amid significant
uncertainty� All eyes remain on inflation, and a good case can be made that the peak is
behind us, while we’ve most likely witnessed the cycle highs in yields from two-years out�
City of Southlake
As of December 31, 2022
Page 4Page 4
Investment Officers
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�
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�
Nicole Bradshaw
Deputy Director of Finance
Sharen Jackson
Chief Financial Officer
Nicole Bradshaw
Sharen Jackson
Page 5
City of Southlake
October 1, 2022 - December 31, 2022
Page 5
Portfolio Overview
Portfolio Summary
Asset Allocation
Prior
30 Sep-22
Current
31 Dec-22
Par Value 197,126,012�15 175,507,637�21
Original Cost 197,211,659�91 175,512,184�45
Book Value 196,827,607�21 175,373,937�99
Market Value 194,995,432�05 173,897,310�01
Accrued Interest 227,346�86 116,298�62
Book Value Plus Accrued 197,054,954�07 175,490,236�62
Market Value Plus Accrued 195,222,778�90 174,013,608�63
Net Unrealized Gain/Loss (1,832,175�17)(1,476,627�98)
Prior
30 Sep-22
Current
31 Dec-22
Yield to Maturity 1�907%2�915%
Yield to Worst 1�907%2�915%
Years to Final Maturity 0�35 0�26
Years to Effective Maturity 0�35 0�26
Duration 0�67 0�58
Transaction Summary
Transaction Type Quantity Principal Interest Total Amount Realized Gain/Loss
Maturity (23,000,000�00)23,000,000�00 0�00 23,000,000�00 0�00
Coupon 0�00 0�00 277,786�32 277,786�32 0�00
1 Oct-22 to 31 Dec-22
Interest Income $1,048,363�15
Net Amortization/Accretion $164,705�72
Realized Gain/Loss $0�00
Net Income $1,213,068�88
Portfolio CharacteristicsIncome Summary
City of Southlake
As of December 31, 2022
Page 6
Maturity Distribution by Security Type
Security Type Overnight 0-3 Months 3-6 Months 6-9 Months 9-12 Months 1-2 Years 2-3 Years 3-4 Years 4-5 Years Portfolio Total
AGCY ----4,996,711�06 --4,993,814�27 --------9,990,525.33
AGCY CALL --------5,000,000�00 4,970,540�76 ------9,970,540.76
CP --4,995,311�11 14,759,270�83 ------------19,754,581.94
LGIP 98,522,637�21 ----------------98,522,637.21
MUNI ----2,543,807�79 ----4,616,544�99 ------7,160,352.78
US GOVT --7,001,788�01 5,000,074�44 12,982,574�22 4,990,863�31 --------29,975,299.97
Total 98,522,637.21 11,997,099.12 27,299,864.11 12,982,574.22 14,984,677.58 9,587,085.75 ------175,373,937.99
Portfolio Overview
Top Ten Holdings
Issuer Allocation
TEXPOOL 27�54%
United States Department of The Treasury 17�09%
TEXSTAR 11�14%
LONESTRGOV 7�37%
LONESTRCRP 7�04%
Federal Farm Credit Banks Funding Corporation 5�70%
Federal Home Loan Banks 5�69%
Toyota Motor Credit Corporation 5�66%
Texas A&M University System Board of Regents 4�08%
TXCLASS 3�09%
Maturity Distribution by Security Type
City of Southlake
As of December 31, 2022
Page 7
Book Value Basis Security Distribution
Security Type Prior Balance
30-Sep-22
Prior Allocation
30-Sep-22 Change in Allocation Current Balance
31-Dec-22
Current Allocation
31-Dec-22 Yield to Maturity
AGCY 9,986,866�45 5�07%0�62%9,990,525�33 5�70%0�408%
AGCY CALL 9,964,272�07 5�06%0�62%9,970,540�76 5�69%2�471%
CP 27,537,070�83 13�99%(2�73%)19,754,581�94 11�26%3�527%
LGIP 97,141,012�15 49�35%6�83%98,522,637�21 56�18%4�061%
MUNI 7,214,299�67 3�67%0�42%7,160,352�78 4�08%0�350%
US GOVT 44,984,086�05 22�85%(5�76%)29,975,299�97 17�09%0�343%
Portfolio Total 196,827,607.21 100.00%175,373,937.99 100.00%2.915%
Asset Allocation
Asset Allocation by Security Type as of Asset Allocation by Security Type as of
30-Sep-2022 31-Dec-2022
City of Southlake
As of December 31, 2022
Page 8
Credit Rating Summary
Rating Distribution Allocation by Rating
Book Value Portfolio Allocation
Local Government Investment Pools & Money Market Funds
AAA 98,522,637�21 56�18%
Total Local Government Investment Pools & Money Market Funds 98,522,637.21 56.18%
Short Term Rating Distribution
A-1+14,836,281�94 8�46%
A-1 4,918,300�00 2�80%
Total Short Term Rating Distribution 19,754,581.94 11.26%
Long Term Rating Distribution
AAA 57,096,718�84 32�56%
Total Long Term Rating Distribution 57,096,718.84 32.56%
Portfolio Total 175,373,937.99 100.00%
City of Southlake
As of December 31, 2022
Page 9
Yield Overview
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 Apr-22 May-22 Jun-22 Jul-22 Aug-22 Sep-22 Oct-22 Nov-22 Dec-22
City of Southlake 0.24 0.20 0.09 0.09 0.09 0.08 0.09 0.09 0.09 0.11 0.13 0.16 0.16 0.21 0.29 0.44 0.59 0.79 1.10 1.49 1.91 2.23 2.64 2.92
6 Month CMT 0�11 0�10 0�08 0�07 0�06 0�05 0�05 0�05 0�05 0�05 0�06 0�07 0�12 0�21 0�34 0�54 0�78 1�12 1�55 1�96 2�43 2�93 3�45 3�87
1 Year CMT 0�25 0�15 0�13 0�12 0�11 0�10 0�09 0�09 0�08 0�08 0�09 0�10 0�14 0�21 0�32 0�47 0�64 0�85 1�10 1�37 1�68 2�05 2�42 2�79
TexPool 0�08 0�04 0�02 0�01 0�01 0�01 0�02 0�02 0�03 0�04 0�04 0�04 0�04 0�06 0�15 0�30 0�62 1�00 1�52 2�16 2�41 2�93 3�61 3�98
Benchmark Comparison
Page 10
City of Southlake
October 1, 2022 - December 31, 2022
Fund Overview
Fund Name Prior Book Value Prior Market Value Changes to Market
Value Current Book Value Current Market Value Net Income Days to Final Mty YTM YTW
General Operating 196,827,607�21 194,995,432�05 (21,098,122�04)175,373,937�99 173,897,310�01 1,213,068�88 95 2�915%2�915%
Total 196,827,607.21 194,995,432.05 (21,098,122.04)175,373,937.99 173,897,310.01 1,213,068.88 95 2.915%2.915%
City of Southlake
As of December 31, 2022
Page 11
Detail of Security Holdings
CUSIP Settle Date Security
Type Security Description CPN Maturity
Date
Next Call
Date Call Type Par Value Purch
Price Original Cost Book Value Mkt
Price Market Value Days
to Mty
Days to
Call YTM YTW Rating
General Operating
LNSTCRP LGIP LoneStar Corp O/N 12/31/22 12,353,821�73 100�000 12,353,821�73 12,353,821�73 100�000 12,353,821�73 1 4�390 4�390 AAA
LNSTGOV LGIP LoneStar Gov O/N 12/31/22 12,920,954�35 100�000 12,920,954�35 12,920,954�35 100�000 12,920,954�35 1 4�085 4�085 AAA
TEXPOOL LGIP TexPool 12/31/22 48,295,217�12 100�000 48,295,217�12 48,295,217�12 100�000 48,295,217�12 1 3�980 3�980 AAA
TEXSTAR LGIP TexSTAR 12/31/22 19,540,343�55 100�000 19,540,343�55 19,540,343�55 100�000 19,540,343�55 1 3�968 3�968 AAA
TXCLASS LGIP Texas CLASS 12/31/22 5,412,300�46 100�000 5,412,300�46 5,412,300�46 100�000 5,412,300�46 1 4�317 4�317 AAA
89233HNH3 04/25/22 CP Toyota Motor Credit
Corporation 0�000 01/17/23 5,000,000�00 98�435 4,921,754�17 4,995,311�11 99�780 4,988,975�00 17 2�138 2�138 A-1+
91282CBG5 02/02/22 US GOVT UNITED STATES TREASURY 0�125 01/31/23 2,000,000�00 99�344 1,986,875�00 1,998,922�31 99�656 1,993,125�00 31 0�789 0�789 AAA
912828ZD5 10/15/21 US GOVT UNITED STATES TREASURY 0�500 03/15/23 5,000,000�00 100�402 5,020,117�20 5,002,865�70 99�219 4,960,937�50 74 0�215 0�215 AAA
912828ZH6 10/14/21 US GOVT UNITED STATES TREASURY 0�250 04/15/23 5,000,000�00 100�008 5,000,390�65 5,000,074�44 98�781 4,939,062�50 105 0�245 0�245 AAA
89233HSC9 08/22/22 CP Toyota Motor Credit
Corporation 0�000 05/12/23 5,000,000�00 97�392 4,869,595�83 4,935,045�83 98�217 4,910,835�00 132 3�650 3�650 A-1+
8821356W1 10/28/20 MUNI
BOARD OF REGENTS
TEXAS A & M UNIVERSITY
SYSTEM
5�000 05/15/23 05/15/23 Continuous 2,500,000�00 112�026 2,800,650�00 2,543,807�79 100�869 2,521,725�00 135 135 0�260 0�260 AAA
46640QT27 09/08/22 CP J�P� Morgan Securities LLC 0�000 06/02/23 5,000,000�00 97�130 4,856,487�50 4,918,300�00 97�900 4,894,975�00 153 3�965 3�965 A-1
78009BT93 09/15/22 CP Royal Bank of Canada 0�000 06/09/23 5,000,000�00 96�840 4,842,025�00 4,905,925�00 97�886 4,894,285�00 160 4�376 4�376 A-1+
3133EMH96 06/25/21 AGCY FEDERAL FARM CREDIT
BANKS FUNDING CORP 0�125 06/14/23 5,000,000�00 99�713 4,985,650�00 4,996,711�06 97�931 4,896,535�00 165 0�271 0�271 AAA
912828ZY9 12/15/21 US GOVT UNITED STATES TREASURY 0�125 07/15/23 5,000,000�00 99�359 4,967,968�75 4,989,094�17 97�562 4,878,125�00 196 0�532 0�532 AAA
91282CCU3 08/31/21 US GOVT UNITED STATES TREASURY 0�125 08/31/23 4,000,000�00 99�766 3,990,625�00 3,996,900�69 96�984 3,879,375�00 243 0�243 0�243 AAA
91282CAK7 08/26/21 US GOVT UNITED STATES TREASURY 0�125 09/15/23 4,000,000�00 99�750 3,990,000�00 3,996,579�36 96�859 3,874,375�00 258 0�247 0�247 AAA
91282CAP6 10/14/21 US GOVT UNITED STATES TREASURY 0�125 10/15/23 5,000,000�00 99�535 4,976,757�80 4,990,863�31 96�469 4,823,437�50 288 0�358 0�358 AAA
3133ENDR8 11/15/21 AGCY FEDERAL FARM CREDIT
BANKS FUNDING CORP 0�400 11/09/23 5,000,000�00 99�713 4,985,665�00 4,993,814�27 96�272 4,813,580�00 313 0�545 0�545 AAA
3130AQAF0 12/22/21 AGCY CALL FEDERAL HOME LOAN
BANKS 0�800 12/22/23 03/22/23 Quarterly 5,000,000�00 100�000 5,000,000�00 5,000,000�00 96�147 4,807,330�00 356 81 0�800 0�800 AAA
3130ASXL8 09/16/22 AGCY CALL FEDERAL HOME LOAN
BANKS 3�625 02/28/24 02/28/23 Quarterly 5,000,000�00 99�265 4,963,250�00 4,970,540�76 98�684 4,934,180�00 424 59 4�151 4�151 AAA
88213AKB0 09/29/20 MUNI
BOARD OF REGENTS
TEXAS A & M UNIVERSITY
SYSTEM
2�549 05/15/24 4,485,000�00 107�731 4,831,735�35 4,616,544�99 97�298 4,363,815�30 501 0�400 0�400 AAA
City of Southlake
As of December 31, 2022
Page 12
Detail of Security Holdings
CUSIP Settle Date Security
Type Security Description CPN Maturity
Date
Next Call
Date Call Type Par Value Purch
Price Original Cost Book Value Mkt
Price Market Value Days
to Mty
Days to
Call YTM YTW Rating
Total General
Operating 175,507,637.21 175,512,184.45 175,373,937.99 173,897,310.01 95 83 2.915 2.915
Grand Total 175,507,637.21 175,512,184.45 175,373,937.99 173,897,310.01 95 83 2.915 2.915
Page 13
City of Southlake
October 1, 2022 - December 31, 2022
Earned Income
CUSIP Security
Type Security Description Beginning
Accrued
Interest
Earned
Interest Rec'd/
Sold/Matured
Interest
Purchased
Ending
Accrued
Disc Accr/Prem
Amort
Net Realized
Gain/Loss Net Income
General Operating
912828YK0 US GOVT UNITED STATES TREASURY 1�375 10/15/2022 31,745�22 2,629�78 34,375�00 0�00 0�00 (1,272�90)0�00 1,356�88
912828TY6 US GOVT UNITED STATES TREASURY 1�625 11/15/2022 30,689�54 9,935�46 40,625�00 0�00 0�00 (9,236�31)0�00 699�15
92181PM17 CP Vanderbilt University 0�0 12/01/2022 0�00 0�00 0�00 0�00 0�00 5,591�67 0�00 5,591�67
91512DME8 CP University of Texas - Permanent University Fund 0�0
12/14/2022 0�00 0�00 0�00 0�00 0�00 35,458�34 0�00 35,458�34
912828YW4 US GOVT UNITED STATES TREASURY 1�625 12/15/2022 23,975�41 16,649�59 40,625�00 0�00 0�00 (8,321�63)0�00 8,327�96
LNSTCRP LGIP LoneStar Corp O/N 0�0 12/31/2022 0�00 118,952�96 118,952�96 0�00 0�00 0�00 0�00 118,952�96
LNSTGOV LGIP LoneStar Gov O/N 0�0 12/31/2022 0�00 117,475�42 117,475�42 0�00 0�00 0�00 0�00 117,475�42
TEXPOOL LGIP TexPool 0�0 12/31/2022 0�00 424,250�87 424,250�87 0�00 0�00 0�00 0�00 424,250�87
TEXSTAR LGIP TexSTAR 0�0 12/31/2022 0�00 169,365�89 169,365�89 0�00 0�00 0�00 0�00 169,365�89
TXCLASS LGIP Texas CLASS 0�0 12/31/2022 0�00 51,579�92 51,579�92 0�00 0�00 0�00 0�00 51,579�92
89233HNH3 CP Toyota Motor Credit Corporation 0�0 01/17/2023 0�00 0�00 0�00 0�00 0�00 26,961�11 0�00 26,961�11
91282CBG5 US GOVT UNITED STATES TREASURY 0�125 01/31/2023 421�20 625�00 0�00 0�00 1,046�20 3,304�90 0�00 3,929�90
912828ZD5 US GOVT UNITED STATES TREASURY 0�5 03/15/2023 1,104�97 6,353�59 0�00 0�00 7,458�56 (3,611�56)0�00 2,742�03
912828ZH6 US GOVT UNITED STATES TREASURY 0�25 04/15/2023 5,771�86 3,156�71 6,250�00 0�00 2,678�57 (65�78)0�00 3,090�93
89233HSC9 CP Toyota Motor Credit Corporation 0�0 05/12/2023 0�00 0�00 0�00 0�00 0�00 45,616�67 0�00 45,616�67
8821356W1 MUNI BOARD OF REGENTS TEXAS A & M UNIVERSITY
SYSTEM 5�0 05/15/2033 47,222�22 31,250�00 62,500�00 0�00 15,972�22 (29,818�34)0�00 1,431�66
46640QT27 CP J�P� Morgan Securities LLC 0�0 06/02/2023 0�00 0�00 0�00 0�00 0�00 49,450�00 0�00 49,450�00
78009BT93 CP Royal Bank of Canada 0�0 06/09/2023 0�00 0�00 0�00 0�00 0�00 54,433�33 0�00 54,433�33
3133EMH96 AGCY FEDERAL FARM CREDIT BANKS FUNDING CORP
0�125 06/14/2023 1,857�64 1,562�50 3,125�00 0�00 295�14 1,834�91 0�00 3,397�41
912828ZY9 US GOVT UNITED STATES TREASURY 0�125 07/15/2023 1,324�73 1,562�50 0�00 0�00 2,887�23 5,054�87 0�00 6,617�37
91282CCU3 US GOVT UNITED STATES TREASURY 0�125 08/31/2023 428�18 1,270�72 0�00 0�00 1,698�90 1,191�95 0�00 2,462�66
91282CAK7 US GOVT UNITED STATES TREASURY 0�125 09/15/2023 220�99 1,270�72 0�00 0�00 1,491�71 1,237�88 0�00 2,508�60
91282CAP6 US GOVT UNITED STATES TREASURY 0�125 10/15/2023 2,885�93 1,578�36 3,125�00 0�00 1,339�29 2,932�49 0�00 4,510�85
3133ENDR8 AGCY FEDERAL FARM CREDIT BANKS FUNDING CORP 0�4
11/09/2023 7,888�89 5,000�00 10,000�00 0�00 2,888�89 1,823�97 0�00 6,823�97
3130AQAF0 AGCY CALL FEDERAL HOME LOAN BANKS 0�8 12/22/2023 11,000�00 10,000�00 20,000�00 0�00 1,000�00 0�00 0�00 10,000�00
3130ASXL8 AGCY CALL FEDERAL HOME LOAN BANKS 3�625 02/28/2024 17,621�53 45,312�50 0�00 0�00 62,934�03 6,268�69 0�00 51,581�19
Page 14
City of Southlake
October 1, 2022 - December 31, 2022
Earned Income
CUSIP Security
Type Security Description Beginning
Accrued
Interest
Earned
Interest Rec'd/
Sold/Matured
Interest
Purchased
Ending
Accrued
Disc Accr/Prem
Amort
Net Realized
Gain/Loss Net Income
88213AKB0 MUNI BOARD OF REGENTS TEXAS A & M UNIVERSITY
SYSTEM 2�549 05/15/2024 43,188�56 28,580�66 57,161�32 0�00 14,607�89 (24,128�55)0�00 4,452�11
Total General
Operating 227,346.86 1,048,363.15 1,159,411.38 0.00 116,298.62 164,705.72 0.00 1,213,068.88
Grand Total 227,346.86 1,048,363.15 1,159,411.38 0.00 116,298.62 164,705.72 0.00 1,213,068.88
Page 15
City of Southlake
October 1, 2022 - December 31, 2022
Investment Transactions
CUSIP Trade Date Settle Date Security Type Security Description Coupon Maturity
Date Call Date Par Value Price Principal
Amount
Interest
Purchased/
Received
Total Amount Realized
Gain/Loss YTM YTW
General
Operating
Coupon
912828YK0 10/15/22 10/15/22 US GOVT UNITED STATES TREASURY 1�375 10/15/22 0�00 0�00 34,375�00 34,375�00 0�00 ----
912828ZH6 10/15/22 10/15/22 US GOVT UNITED STATES TREASURY 0�250 04/15/23 0�00 0�00 6,250�00 6,250�00 0�00 ----
91282CAP6 10/15/22 10/15/22 US GOVT UNITED STATES TREASURY 0�125 10/15/23 0�00 0�00 3,125�00 3,125�00 0�00 ----
3133ENDR8 11/09/22 11/09/22 AGCY FEDERAL FARM CREDIT BANKS
FUNDING CORP 0�400 11/09/23 0�00 0�00 10,000�00 10,000�00 0�00 ----
8821356W1 11/15/22 11/15/22 MUNI BOARD OF REGENTS TEXAS A & M
UNIVERSITY SYSTEM 5�000 05/15/23 05/15/23 0�00 0�00 62,500�00 62,500�00 0�00 ----
912828TY6 11/15/22 11/15/22 US GOVT UNITED STATES TREASURY 1�625 11/15/22 0�00 0�00 40,625�00 40,625�00 0�00 ----
88213AKB0 11/15/22 11/15/22 MUNI BOARD OF REGENTS TEXAS A & M
UNIVERSITY SYSTEM 2�549 05/15/24 0�00 0�00 57,161�32 57,161�32 0�00 ----
3133EMH96 12/14/22 12/14/22 AGCY FEDERAL FARM CREDIT BANKS
FUNDING CORP 0�125 06/14/23 0�00 0�00 3,125�00 3,125�00 0�00 ----
912828YW4 12/15/22 12/15/22 US GOVT UNITED STATES TREASURY 1�625 12/15/22 0�00 0�00 40,625�00 40,625�00 0�00 ----
3130AQAF0 12/22/22 12/22/22 AGCY CALL FEDERAL HOME LOAN BANKS 0�800 12/22/23 03/22/23 0�00 0�00 20,000�00 20,000�00 0�00 ----
Total Coupon 0.00 0.00 277,786.32 277,786.32 0.00
Maturity
912828YK0 10/15/22 10/15/22 US GOVT UNITED STATES TREASURY 1�375 10/15/22 (5,000,000�00)100�000 5,000,000�00 0�00 5,000,000�00 0�00 ----
912828TY6 11/15/22 11/15/22 US GOVT UNITED STATES TREASURY 1�625 11/15/22 (5,000,000�00)100�000 5,000,000�00 0�00 5,000,000�00 0�00 ----
92181PM17 12/01/22 12/01/22 CP Vanderbilt University 0�000 12/01/22 (3,000,000�00)100�000 3,000,000�00 0�00 3,000,000�00 0�00 ----
91512DME8 12/14/22 12/14/22 CP University of Texas - Permanent
University Fund 0�000 12/14/22 (5,000,000�00)100�000 5,000,000�00 0�00 5,000,000�00 0�00 ----
912828YW4 12/15/22 12/15/22 US GOVT UNITED STATES TREASURY 1�625 12/15/22 (5,000,000�00)100�000 5,000,000�00 0�00 5,000,000�00 0�00 ----
Total Maturity (23,000,000.00)23,000,000.00 0.00 23,000,000.00 0.00
Page 16
City of Southlake
October 1, 2022 - December 31, 2022
Investment Transactions Totals
Transaction Type Quantity Principal Amount Interest Total Amount Realized G/L YTM YTW
Total Maturity (23,000,000�00)23,000,000�00 0�00 23,000,000�00 0�00 1�403 1�403
Total Coupon 0�00 0�00 277,786�32 277,786�32 0�00
Page 17
City of Southlake
October 1, 2022 - December 31, 2022
Amortization and Accretion
CUSIP Settle Date Security
Type Security Description Purchase Qty Orig Price Original Cost Amort/Accr for
Period
Total Amort/Accr
Since Purch
Remaining Disc/
Premium
Ending Book
Value
General Operating
912828YK0 02/10/22 US GOVT UNITED STATES TREASURY 1�375 10/15/2022 0�00 0�000 0�00 (1,272�90)0�00 0�00 0�00
912828TY6 09/28/21 US GOVT UNITED STATES TREASURY 1�625 11/15/2022 0�00 0�000 0�00 (9,236�31)0�00 0�00 0�00
92181PM17 03/09/22 CP Vanderbilt University 0�0 12/01/2022 0�00 0�000 0�00 5,591�67 0�00 0�00 0�00
91512DME8 09/29/22 CP University of Texas - Permanent University Fund 0�0 12/14/2022 0�00 0�000 0�00 35,458�34 0�00 0�00 0�00
912828YW4 02/10/22 US GOVT UNITED STATES TREASURY 1�625 12/15/2022 0�00 0�000 0�00 (8,321�63)0�00 0�00 0�00
89233HNH3 04/25/22 CP Toyota Motor Credit Corporation 0�0 01/17/2023 5,000,000�00 98�435 4,921,754�17 26,961�11 73,556�94 (4,688�89)4,995,311�11
91282CBG5 02/02/22 US GOVT UNITED STATES TREASURY 0�125 01/31/2023 2,000,000�00 99�344 1,986,875�00 3,304�90 12,047�31 (1,077�69)1,998,922�31
912828ZD5 10/15/21 US GOVT UNITED STATES TREASURY 0�5 03/15/2023 5,000,000�00 100�402 5,020,117�20 (3,611�56)(17,251�50)2,865�70 5,002,865�70
912828ZH6 10/14/21 US GOVT UNITED STATES TREASURY 0�25 04/15/2023 5,000,000�00 100�008 5,000,390�65 (65�78)(316�22)74�44 5,000,074�44
89233HSC9 08/22/22 CP Toyota Motor Credit Corporation 0�0 05/12/2023 5,000,000�00 97�392 4,869,595�83 45,616�67 65,450�00 (64,954�17)4,935,045�83
8821356W1 10/28/20 MUNI BOARD OF REGENTS TEXAS A & M UNIVERSITY SYSTEM 5�0
05/15/2033 2,500,000�00 112�026 2,800,650�00 (29,818�34)(256,842�21)43,807�79 2,543,807�79
46640QT27 09/08/22 CP J�P� Morgan Securities LLC 0�0 06/02/2023 5,000,000�00 97�130 4,856,487�50 49,450�00 61,812�50 (81,700�00)4,918,300�00
78009BT93 09/15/22 CP Royal Bank of Canada 0�0 06/09/2023 5,000,000�00 96�840 4,842,025�00 54,433�33 63,900�00 (94,075�00)4,905,925�00
3133EMH96 06/25/21 AGCY FEDERAL FARM CREDIT BANKS FUNDING CORP 0�125 06/14/2023 5,000,000�00 99�713 4,985,650�00 1,834�91 11,061�06 (3,288�94)4,996,711�06
912828ZY9 12/15/21 US GOVT UNITED STATES TREASURY 0�125 07/15/2023 5,000,000�00 99�359 4,967,968�75 5,054�87 21,125�42 (10,905�83)4,989,094�17
91282CCU3 08/31/21 US GOVT UNITED STATES TREASURY 0�125 08/31/2023 4,000,000�00 99�766 3,990,625�00 1,191�95 6,275�69 (3,099�31)3,996,900�69
91282CAK7 08/26/21 US GOVT UNITED STATES TREASURY 0�125 09/15/2023 4,000,000�00 99�750 3,990,000�00 1,237�88 6,579�36 (3,420�64)3,996,579�36
91282CAP6 10/14/21 US GOVT UNITED STATES TREASURY 0�125 10/15/2023 5,000,000�00 99�535 4,976,757�80 2,932�49 14,105�51 (9,136�69)4,990,863�31
3133ENDR8 11/15/21 AGCY FEDERAL FARM CREDIT BANKS FUNDING CORP 0�4 11/09/2023 5,000,000�00 99�713 4,985,665�00 1,823�97 8,149�28 (6,185�73)4,993,814�27
3130AQAF0 12/22/21 AGCY CALL FEDERAL HOME LOAN BANKS 0�8 12/22/2023 5,000,000�00 100�000 5,000,000�00 0�00 0�00 0�00 5,000,000�00
3130ASXL8 09/16/22 AGCY CALL FEDERAL HOME LOAN BANKS 3�625 02/28/2024 5,000,000�00 99�265 4,963,250�00 6,268�69 7,290�76 (29,459�24)4,970,540�76
88213AKB0 09/29/20 MUNI BOARD OF REGENTS TEXAS A & M UNIVERSITY SYSTEM 2�549
05/15/2024 4,485,000�00 107�731 4,831,735�35 (24,128�55)(215,190�36)131,544�99 4,616,544�99
Total General
Operating 76,985,000.00 76,989,547.24 164,705.72 (138,246.46)(133,699.22)76,851,300.78
Grand Total 76,985,000.00 76,989,547.24 164,705.72 (138,246.46)(133,699.22)76,851,300.78
Page 18
City of Southlake
December 31, 2022 to December 31, 2023
Projected Cash Flows
CUSIP Security Description Post Date Interest Principal Total Amount
General Operating
912828ZY9 UNITED STATES TREASURY 0�125 07/15/2023 01/17/23 3,125�00 3,125�00
89233HNH3 Toyota Motor Credit Corporation 0�0 01/17/2023 01/17/23 5,000,000�00 5,000,000�00
91282CBG5 UNITED STATES TREASURY 0�125 01/31/2023 01/31/23 1,250�00 1,250�00
91282CBG5 UNITED STATES TREASURY 0�125 01/31/2023 01/31/23 2,000,000�00 2,000,000�00
3130ASXL8 FEDERAL HOME LOAN BANKS 3�625 02/28/2024 02/28/23 91,631�94 91,631�94
91282CCU3 UNITED STATES TREASURY 0�125 08/31/2023 02/28/23 2,500�00 2,500�00
912828ZD5 UNITED STATES TREASURY 0�5 03/15/2023 03/15/23 12,500�00 12,500�00
912828ZD5 UNITED STATES TREASURY 0�5 03/15/2023 03/15/23 5,000,000�00 5,000,000�00
91282CAK7 UNITED STATES TREASURY 0�125 09/15/2023 03/15/23 2,500�00 2,500�00
912828ZH6 UNITED STATES TREASURY 0�25 04/15/2023 04/17/23 6,250�00 6,250�00
912828ZH6 UNITED STATES TREASURY 0�25 04/15/2023 04/17/23 5,000,000�00 5,000,000�00
91282CAP6 UNITED STATES TREASURY 0�125 10/15/2023 04/17/23 3,125�00 3,125�00
3133ENDR8 FEDERAL FARM CREDIT BANKS FUNDING CORP 0�4 11/09/2023 05/09/23 10,000�00 10,000�00
89233HSC9 Toyota Motor Credit Corporation 0�0 05/12/2023 05/12/23 5,000,000�00 5,000,000�00
8821356W1 BOARD OF REGENTS TEXAS A & M UNIVERSITY SYSTEM 5�0 05/15/2033 05/15/23 62,500�00 62,500�00
8821356W1 BOARD OF REGENTS TEXAS A & M UNIVERSITY SYSTEM 5�0 05/15/2033 05/15/23 2,500,000�00 2,500,000�00
88213AKB0 BOARD OF REGENTS TEXAS A & M UNIVERSITY SYSTEM 2�549 05/15/2024 05/15/23 57,161�32 57,161�32
46640QT27 J�P� Morgan Securities LLC 0�0 06/02/2023 06/02/23 5,000,000�00 5,000,000�00
78009BT93 Royal Bank of Canada 0�0 06/09/2023 06/09/23 5,000,000�00 5,000,000�00
3133EMH96 FEDERAL FARM CREDIT BANKS FUNDING CORP 0�125 06/14/2023 06/14/23 3,125�00 3,125�00
3133EMH96 FEDERAL FARM CREDIT BANKS FUNDING CORP 0�125 06/14/2023 06/14/23 5,000,000�00 5,000,000�00
3130AQAF0 FEDERAL HOME LOAN BANKS 0�8 12/22/2023 06/22/23 20,000�00 20,000�00
912828ZY9 UNITED STATES TREASURY 0�125 07/15/2023 07/17/23 3,125�00 3,125�00
912828ZY9 UNITED STATES TREASURY 0�125 07/15/2023 07/17/23 5,000,000�00 5,000,000�00
3130ASXL8 FEDERAL HOME LOAN BANKS 3�625 02/28/2024 08/28/23 90,625�00 90,625�00
91282CCU3 UNITED STATES TREASURY 0�125 08/31/2023 08/31/23 2,500�00 2,500�00
91282CCU3 UNITED STATES TREASURY 0�125 08/31/2023 08/31/23 4,000,000�00 4,000,000�00
91282CAK7 UNITED STATES TREASURY 0�125 09/15/2023 09/15/23 2,500�00 2,500�00
91282CAK7 UNITED STATES TREASURY 0�125 09/15/2023 09/15/23 4,000,000�00 4,000,000�00
91282CAP6 UNITED STATES TREASURY 0�125 10/15/2023 10/16/23 3,125�00 3,125�00
Page 19
City of Southlake
December 31, 2022 to December 31, 2023
Projected Cash Flows
CUSIP Security Description Post Date Interest Principal Total Amount
91282CAP6 UNITED STATES TREASURY 0�125 10/15/2023 10/16/23 5,000,000�00 5,000,000�00
3133ENDR8 FEDERAL FARM CREDIT BANKS FUNDING CORP 0�4 11/09/2023 11/09/23 10,000�00 10,000�00
3133ENDR8 FEDERAL FARM CREDIT BANKS FUNDING CORP 0�4 11/09/2023 11/09/23 5,000,000�00 5,000,000�00
88213AKB0 BOARD OF REGENTS TEXAS A & M UNIVERSITY SYSTEM 2�549 05/15/2024 11/15/23 57,161�32 57,161�32
3130AQAF0 FEDERAL HOME LOAN BANKS 0�8 12/22/2023 12/22/23 20,000�00 20,000�00
3130AQAF0 FEDERAL HOME LOAN BANKS 0�8 12/22/2023 12/22/23 5,000,000�00 5,000,000�00
Grand Total 464,704.59 67,500,000.00 67,964,704.59
Page 20
City of Southlake
December 31, 2022 to December 31, 2023
Month and Year Interest Principal Total Amount
January 2023 4,375�00 7,000,000�00 7,004,375�00
February 2023 94,131�94 94,131�94
March 2023 15,000�00 5,000,000�00 5,015,000�00
April 2023 9,375�00 5,000,000�00 5,009,375�00
May 2023 129,661�32 7,500,000�00 7,629,661�32
June 2023 23,125�00 15,000,000�00 15,023,125�00
July 2023 3,125�00 5,000,000�00 5,003,125�00
August 2023 93,125�00 4,000,000�00 4,093,125�00
September 2023 2,500�00 4,000,000�00 4,002,500�00
October 2023 3,125�00 5,000,000�00 5,003,125�00
November 2023 67,161�32 5,000,000�00 5,067,161�32
December 2023 20,000�00 5,000,000�00 5,020,000�00
Total 464,704.59 67,500,000.00 67,964,704.59
Projected Cash Flows Totals
City of Southlake
As of December 31, 2022
Page 21
Disclosures & Disclaimers
As a courtesy to investors this information: (1) is provided for informational purposes only; (2) should not be construed as an offer to sell or a solicitation of an offer to buy any security; and (3) does not replace customer statements�
This report is designed to provide general information and is not intended to provide specific legal, investment, accounting, tax or other professional advice�
It is important to review and save all source documents provided by a product sponsor or brokerage firm which may contain notices, disclosures and other information important to you and may also serve as a reference� If conflicts between this
report and sponsor reports or confirmations exist, the information provided by the product sponsors shall prevail� Fees and sales charges paid may not be reflected in the information�
The information and data contained herein is obtained from sources believed to be reliable but its accuracy or completeness is not guaranteed� Additionally, the information may contain assets held away from HTS, therefore investors should contact
customer service or other representatives from the respective distributors or issuers to determine SIPC coverage for held away assets� HTS and HSAM do not guarantee the information contained herein or its accuracy or completeness regarding
contributions, withdrawals, protected values� All information is subject to further review with client to validate final values�
It is not possible to directly invest in an index� Financial forecasts, rates of return, risk, inflation, and other assumptions may be used as the basis for illustrations� They should not be considered a guarantee of future performance or a guarantee of
achieving overall financial objectives� Past performance is not a guarantee or a predictor of future results of either the indices or any particular investment� S&P rates the creditworthiness of individual bonds from: AAA highest to D lowest�
Investing in fixed income securities involves interest rate risk, credit risk, and inflation risk� Interest rate risk is the possibility that bond prices will decrease because of an interest rate increase� When interest rates rise, bond prices and the values of fixed
income securities fall� When interest rates fall, bond prices and the values of fixed income securities rise� Credit risk is the risk that a company will not be able to pay its debts, including the interest on its bonds� Inflation risk is the possibility that the
interest paid on an investment in bonds will be lower than the inflation rate, decreasing purchasing power�
Cash alternatives typically include money market securities and U�S� treasury bills� Investing in such cash alternatives involves inflation risk� In addition, investments in money market securities may involve credit risk and a risk of principal loss� Because
money market securities are neither insured nor guaranteed by the Federal Deposit Insurance Corporation or any other government agency, there is no guarantee the value of your investment will be maintained at $1�00 per share, and your shares,
when sold, may be worth more or less than what you originally paid for them� U�S� Treasury bills are subject to market risk if sold prior to maturity� Market risk is the possibility that the value, when sold, might be less than the purchase price�
Investing in stock securities involves volatility risk, market risk, business risk, and industry risk� The prices of most stocks fluctuate� Volatility risk is the chance that the value of a stock will fall� Market risk is the chance that the prices of all stocks will fall
due to conditions in the economic environment� Business risk is the chance that a specific company’s stock will fall because of issues affecting it� Industry risk is the chance that a set of factors particular to an industry group will adversely affect stock
prices within the industry�
Securities offered by HTS: (1) are not FDIC (Federal Deposit Insurance Corporation) insured; (2) are not bank deposits; (3) are not guaranteed by any bank or by any other federal government agency� None of the named entities are affiliates of HTS or
HSAM�Hilltop Securities Asset Management (HSAM) is an SEC-registered investment advisor� Hilltop Securities Inc� (HTS) is a registered broker-dealer, registered investment adviser and municipal advisor firm that does not provide tax or legal advice�
Member of FINRA & SIPC� HTS and HSAM are wholly owned subsidiaries of Hilltop Holdings, Inc� (NYSE: HTH) located at 717 N� Harwood St�, Suite 3400, Dallas, Texas 75201, (214) 859-1800, 833-4HILLTOP�
Copyright 2022, S&P Global Market Intelligence� Reproduction of any information, data or material, including ratings (“Content”) in any form is prohibited except with the prior written permission of the relevant party� Such party, its affiliates and
suppliers (“Content Providers”) do not guarantee the accuracy, adequacy, completeness, timeliness or availability of any Content and are not responsible for any errors or omissions (negligent or otherwise), regardless of the cause, or for the results
obtained from the use of such Content� In no event shall� Content Providers be liable for any damages, costs, expenses, legal fees, or losses (including lost income or lost profit and opportunity costs) in connection with any use of the Content�
A reference to a particular investment or security, a rating or any observation concerning an investment that is part of the content is not a recommendation to buy, sell or hold such investment or security, does not address the suitability of an
investment or security and should not be relied on as investment advice� Credit ratings are statements of opinions and are not statements of fact�