Loading...
Debt Model Report Sept 30, 2022 Updated Feb 3, 2022City of Schertz, Texas Debt Model Updated: February 3, 2022 Presented by: SAMCO Capital Markets, Inc. Mark McLiney Andrew Friedman (210) 832‐9760 Debt Model Fiscal Year GO's GO Bonds GO Ref Tax Notes GO Ref GO's CO's CO's CO's GO Bonds GO Ref CO's GO and Ref CO's GO Ref GO Ref CO's Total Ending 9/30 S‐2007 S‐2012 S‐2014 S‐2015A S‐2015 S‐2016 S‐2016A S‐2016B S‐2017 S‐2017 S‐2018 S‐2018 S‐2018 S‐2019 S‐2020 S‐2021 S‐2022* Debt Service 2022 425,267$         379,219$         1,018,025$        157,387$         37,050$          376,606$        235,469$        100,263$        534,425$        265,050$        671,125$        408,888$         366,819$         379,900$         1,146,963$       98,850$            99,692$            6,700,995$               2023 426,123           ‐ 1,020,150           ‐ 37,050            376,606         237,469          103,388         418,400          265,025         668,617         411,263          377,069          381,800          1,134,063         474,800            341,525            6,673,347                 2024 426,370           ‐ 1,019,525           ‐ 37,050            376,206         97,319             101,438         418,800          264,850         670,844         408,013          410,694          375,675          1,105,463         470,600            337,650            6,520,495                 2025 426,005           ‐ 1,021,000           ‐ 37,050            375,406         100,144          104,413         271,150          264,525         672,753         409,138          383,569          372,875          439,463            466,000            338,400            5,681,890                 2026 425,031           ‐ 1,021,425           ‐ 37,050            374,206         97,894             102,313         270,525          264,050         669,397         297,388          386,444          375,975          440,963            470,800            333,775            5,567,234                 2027 423,445           ‐ 1,018,575           ‐ 37,050            375,556         100,969          104,950         269,750          263,425         665,829         297,888          383,694          197,175          441,863            469,900            338,650            5,388,718                 2028 ‐ ‐ 1,022,175           ‐ 37,050            374,606         99,369             102,325         268,825          262,650         666,996         297,888          675,794          196,675          437,263            470,500            333,025            5,245,140                 2029 ‐ ‐ 1,014,375           ‐ 37,050            373,366         97,719             104,613         267,750          266,650         ‐297,388          579,494          197,063          437,163            467,750            336,900            4,477,278                 2030 ‐ ‐ 1,022,588           ‐ 37,050            371,638         100,913          101,813         271,450          265,425         ‐297,513          579,294          193,075          435,513            464,700            335,150            4,476,119                 2031 ‐ ‐ ‐ ‐ 1,158,525      374,350         98,947             103,925         269,925          264,050         ‐299,488          580,634          193,650          439,031            463,600            337,775            4,583,900                 2032 ‐ ‐ ‐ ‐‐376,425         101,869          100,844         268,250          267,450         ‐297,363          583,256          194,075          438,425            459,550            336,100            3,423,606                 2033 ‐ ‐ ‐ ‐‐372,275         99,675             102,563         271,350          265,625         ‐299,856          579,619          194,350          437,238            ‐ 336,675            2,959,225                 2034 ‐ ‐ ‐ ‐‐372,075         97,200             104,094         268,925          263,356         ‐296,806          ‐194,475          435,975            ‐ 333,350            2,366,256                 2035 ‐ ‐ ‐ ‐‐376,500         99,425             100,531         270,963          265,556         ‐298,356          ‐194,450          434,638            ‐ 334,800            2,375,219                 2036 ‐ ‐ ‐ ‐‐375,550         101,500          101,875         267,756          262,513         ‐299,409          ‐194,275          433,225            ‐ 340,875            2,376,978                 2037 ‐ ‐ ‐ ‐‐‐ ‐‐ 269,306          264,225         ‐299,959          ‐193,950          ‐ ‐ 333,250            1,360,691                2038 ‐ ‐ ‐ ‐‐‐ ‐‐ ‐‐‐295,075          ‐193,475          ‐ ‐ 238,050            726,600  2039 ‐ ‐ ‐ ‐‐‐ ‐‐ ‐‐‐‐‐192,850          ‐ ‐ 238,563            431,413  2040 ‐ ‐ ‐ ‐‐‐ ‐‐ ‐‐‐‐‐‐ ‐ ‐ 238,694            238,694  2041 ‐ ‐ ‐ ‐‐‐ ‐‐ ‐‐‐‐‐‐ ‐ ‐ 238,431            238,431  2042 ‐ ‐ ‐ ‐‐‐ ‐‐ ‐‐‐‐‐‐ ‐ ‐  242,850            242,850  Total 2,552,240$      379,219$         9,177,838$        157,387$         1,491,975$     5,621,372$     1,765,878$     1,539,344$      4,877,550$      4,234,425$     4,685,561$     5,511,675$      5,886,378$      4,415,763$      8,637,244$       4,777,050$       6,344,179$       72,055,077$             * Includes debt service related to energy efficiency upgrades that are intended to be repaid from a guaranteed savings contract with a 3rd party.  Separate amortization schedule is included herein. Fiscal Year CO's GO Ref. CO's GO and Ref. CO's GO Ref. CO's Total Ending 9/30 S‐2013 S‐2013 S‐2018 S‐2018 S‐2019 S‐2021 S‐2022 Debt Service 2022 157,325$         224,028$         400,050$            463,500$         233,000$        45,338$          94,186$          1,617,426$       2023 ‐ 218,739           399,550              464,500           234,025         202,550         307,713          1,827,076        2024 ‐ 223,321           398,550              464,500           233,500         201,650         309,963          1,831,483        2025 ‐ 217,774           397,050              468,375           232,100         205,450         306,838          1,827,586        2026 ‐ ‐ 399,925              461,250           236,100         203,950         308,338          1,609,563        2027 ‐ ‐ 397,175              ‐234,800         207,150         309,338          1,148,463        2028 ‐ ‐ 398,800              ‐233,300         205,950         309,838          1,147,888        2029 ‐ ‐ 399,675              ‐232,875         210,400         309,838          1,152,788        2030 ‐ ‐ 396,425              ‐233,125         209,625         309,338          1,148,513        2031 ‐ ‐ 395,775              ‐232,800         214,650         308,338          1,151,563        2032 ‐ ‐ 396,325              ‐232,325         215,500         308,013          1,152,163        2033 ‐ ‐ 396,369              ‐236,625         171,700         309,638          1,114,331        2034 ‐ ‐ 395,688              ‐235,700         ‐ 307,213          938,600          2035 ‐ ‐ 399,394              ‐234,625         ‐ 309,563          943,581          2036 ‐ ‐ 397,466              ‐233,400         ‐ 306,688          937,553          2037 ‐ ‐ 394,978              ‐236,950         ‐ 305,013          936,941          2038 ‐ ‐ 396,825              ‐235,275         ‐ 309,513          941,613          2039 ‐ ‐ ‐ ‐233,450         ‐ 308,684          542,134          2040 ‐ ‐ ‐ ‐‐‐ 307,394          307,394          2041 ‐ ‐ ‐ ‐‐‐ 305,628          305,628          2042 ‐ ‐ ‐ ‐‐‐  303,563          303,563          Total 157,325$         883,860$         6,760,019$        2,322,125$      4,213,975$     2,293,913$     6,254,630$     22,885,846$     City of Schertz, Texas General Fund Debt Obligations Debt Model Utility System Supported Debt Obligations Fiscal Year Rev Bonds Ref Bonds Rev & Ref Bonds Rev Bonds BP Loan Ref Bonds Rev Ref Bonds Total Schertz Debt Fiscal Year Rev Ref Bonds Ending 9/30 S‐2001 S‐2014 S‐2015 S‐2016 S‐2016 S‐2018 S‐2022 Debt Service Payment Ending 9/30 S‐2019 2022 520,000$             598,850$                        875,900$                       2,229,242$                    828,137$                       1,326,825$                    486,444$                       6,865,398$            3,432,699$              2022 1,388,450$              2023 520,000                 ‐                                       877,200                         2,226,390                     828,137                        1,328,600                      2,103,588                     7,883,915             3,941,957                2023 1,390,188                2024 520,000                 ‐                                       ‐                                      2,227,166                     828,137                        1,323,475                      2,981,678                     7,880,456             3,940,228                2024 1,388,988                2025 520,000                 ‐                                       ‐                                      2,226,361                     828,137                        1,326,850                      2,978,980                     7,880,327             3,940,164                2025 1,388,294                2026 520,000                 ‐                                       ‐                                      2,224,201                     828,137                        1,323,600                      3,104,599                     8,000,536             4,000,268                2026 1,392,206                2027 520,000                 ‐                                       ‐                                      2,225,659                     828,137                        1,323,725                      3,094,106                     7,991,627             3,995,813                2027 1,390,725                2028 520,000                 ‐                                       ‐                                      2,219,166                     828,137                        1,326,975                      3,100,288                     7,994,566             3,997,283                2028 1,388,275                2029 520,000                 ‐                                       ‐                                      2,220,811                     828,137                        1,328,225                      3,097,857                     7,995,029             3,997,515                2029 1,393,900                2030 520,000                 ‐                                       ‐                                      2,217,486                     828,137                        1,327,475                      3,091,333                     7,984,431             3,992,215                2030 1,392,400                2031 2,268,330             ‐                                       ‐                                      2,216,266                     828,137                        1,324,200                      1,354,435                     7,991,368             3,995,684                2031 1,393,775                2032 2,272,390             ‐                                       ‐                                      2,217,804                     828,137                        1,323,700                      1,358,441                     8,000,472             4,000,236                2032 1,388,025                2033 2,271,250             ‐                                       ‐                                      2,217,790                     828,137                        1,321,800                      1,361,140                     8,000,117             4,000,059                2033 1,390,025                2034 2,269,780             ‐                                       ‐                                      2,216,040                     828,137                        1,323,400                      1,362,487                     7,999,844             3,999,922                2034 1,389,800                2035 2,272,590             ‐                                       ‐                                      2,216,437                     1,128,137                     1,323,400                      1,357,670                     8,298,234             4,149,117                2035 1,387,800                2036 ‐                             ‐                                       ‐                                      2,216,117                     1,518,567                     1,326,700                      3,614,816                     8,676,200             4,338,100                2036 1,389,100                2037 ‐                             ‐                                       ‐                                      2,219,127                     1,920,887                     1,328,200                      3,621,256                     9,089,470             4,544,735                2037 1,388,600                2038 ‐                             ‐                                       ‐                                      2,217,979                     1,921,962                     1,323,000                      3,631,933                     9,094,874             4,547,437                2038 1,391,200                2039 ‐                             ‐                                       ‐                                      2,220,580                     1,921,653                     1,326,000                      3,625,838                     9,094,071             4,547,035                2039 1,386,900                2040 ‐                             ‐                                       ‐                                      2,221,791                     1,924,960                     1,327,000                      3,623,500                     9,097,251             4,548,626                2040 1,390,600                2041 ‐                             ‐                                       ‐                                      2,221,612                     1,921,710                     1,326,000                      3,622,050                     9,091,372             4,545,686                2041 1,387,200                2042 ‐                             ‐                                       ‐                                      2,225,043                     1,927,076                     ‐                                      305,375                        4,457,494             2,228,747                2042 ‐                                2043 ‐                             ‐                                       ‐                                      2,220,642                     1,925,084                     ‐                                      305,400                        4,451,126             2,225,563                2043 ‐                                2044 ‐                             ‐                                       ‐                                      2,219,531                     1,921,152                     ‐                                      300,163                        4,440,845             2,220,423                2044 ‐                                2045 ‐                             ‐                                       ‐                                      2,216,553                     1,915,280                     ‐                                      ‐                                     4,131,833             2,065,917                2045 ‐                                2046 ‐                             ‐                                       ‐                                      2,211,710                     1,912,468                     ‐                                      ‐                                     4,124,178             2,062,089                2046 ‐                                2047 ‐                             ‐                                       ‐                                      ‐                                     1,912,522                     ‐                                      ‐                                     1,912,522             956,261                   2047 ‐                                2048 ‐                             ‐                                       ‐                                      ‐                                     1,910,063                     ‐                                      ‐                                     1,910,063             955,032                   2048 ‐                                2049 ‐                             ‐                                       ‐                                      ‐                                     1,905,635                     ‐                                      ‐                                     1,905,635             952,818                   2049 ‐                                2050 ‐                             ‐                                       ‐                                      ‐                                     1,904,238                     ‐                                      ‐                                     1,904,238             952,119                   2050 ‐                                2051 ‐                            ‐                                      ‐                                     ‐                                    1,900,693                    ‐                                     ‐                                    1,900,693            950,347                   2051 ‐                                Total 16,034,340$         598,850$                        1,753,100$                   55,511,500$                42,157,868$                  26,509,150$                53,483,375$                196,048,183$      98,024,091$            Total 27,796,450$            The Schertz/Seguin Local Government Corporation SSLGC‐SAWS PROJECT Fiscal Year Contract Rev Bonds Contract Rev Bonds Ending 9/30 S‐2014 S‐2018 Total 2022 412,750$303,100$715,850$ 2023 412,800 302,850 715,650 2024 412,700 302,350 715,050 2025 412,450 301,600 714,050 2026 410,250 300,600 710,850 2027 412,850 304,350 717,200 2028 410,050 302,600 712,650 2029 412,050 300,600 712,650 2030 413,650 303,350 717,000 2031 409,850 300,600 710,450 2032 410,850 302,600 713,450 2033 411,450 304,100 715,550 2034 411,650 300,100 711,750 2035 411,450 300,850 712,300 2036 413,200 301,100 714,300 2037 414,200 300,850 715,050 2038 409,450 305,100 714,550 2039 409,200 303,600 712,800 2040 413,200 304,000 717,200 2041 409,600 304,000 713,600 2042 410,600 303,600 714,200 2043 411,000 302,800 713,800 2044 410,800 301,600 712,400 Total 9,466,050$6,956,300$16,422,350$ Cibolo Creek Municipal Authority ‐ Southern Wastewater Treatment Plant Debt Service Schedules Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 1 BOND DEBT SERVICE City of Schertz, Texas $6,000,000 General Obligation Bonds, Series 2007 Callable at Par plus Prepayment Penalty Dated Date 09/27/2007 Delivery Date 09/27/2007 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 340,000 4.070% 46,092.75 386,092.75 08/01/2022 39,173.75 39,173.75 09/30/2022 425,266.50 02/01/2023 355,000 4.070% 39,173.75 394,173.75 08/01/2023 31,949.50 31,949.50 09/30/2023 426,123.25 02/01/2024 370,000 4.070% 31,949.50 401,949.50 08/01/2024 24,420.00 24,420.00 09/30/2024 426,369.50 02/01/2025 385,000 4.070% 24,420.00 409,420.00 08/01/2025 16,585.25 16,585.25 09/30/2025 426,005.25 02/01/2026 400,000 4.070% 16,585.25 416,585.25 08/01/2026 8,445.25 8,445.25 09/30/2026 425,030.50 02/01/2027 415,000 4.070% 8,445.25 423,445.25 09/30/2027 423,445.25 2,265,000 287,240.25 2,552,240.25 2,552,240.25 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 2 BOND DEBT SERVICE City of Schertz, Texas $7,625,000 General Obligation Bonds, Series 2012 Callable 2/1/2022 at Par Dated Date 08/01/2012 Delivery Date 09/13/2012 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 375,000 2.250% 4,218.75 379,218.75 09/30/2022 379,218.75 375,000 4,218.75 379,218.75 379,218.75 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 3 BOND DEBT SERVICE City of Schertz, Texas $4,965,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2013 Callable 2/1/2022 at Par Dated Date 09/01/2013 Delivery Date 10/10/2013 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2022 155,000 3.000% 2,325 157,325 09/30/2022 157,325 155,000 2,325 157,325 157,325 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 4 BOND DEBT SERVICE City of Schertz, Texas $2,160,000 General Obligation Refunding Bonds, Series 2013 Callable 2/1/2023 at Par Dated Date 10/10/2013 Delivery Date 10/10/2013 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 205,000 2.580% 10,836.00 215,836.00 08/01/2022 8,191.50 8,191.50 09/30/2022 224,027.50 02/01/2023 205,000 2.580% 8,191.50 213,191.50 08/01/2023 5,547.00 5,547.00 09/30/2023 218,738.50 02/01/2024 215,000 2.580% 5,547.00 220,547.00 08/01/2024 2,773.50 2,773.50 09/30/2024 223,320.50 02/01/2025 215,000 2.580% 2,773.50 217,773.50 09/30/2025 217,773.50 840,000 43,860.00 883,860.00 883,860.00 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 5 BOND DEBT SERVICE City of Schertz, Texas $8,450,000 General Obligation Refunding Bonds, Series 2014 Callable 2/1/2023 at Par Dated Date 05/15/2014 Delivery Date 06/26/2014 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 750,000 3.000% 139,637.50 889,637.50 08/01/2022 128,387.50 128,387.50 09/30/2022 1,018,025.00 02/01/2023 775,000 3.000% 128,387.50 903,387.50 08/01/2023 116,762.50 116,762.50 09/30/2023 1,020,150.00 02/01/2024 800,000 3.500% 116,762.50 916,762.50 08/01/2024 102,762.50 102,762.50 09/30/2024 1,019,525.00 02/01/2025 830,000 3.500% 102,762.50 932,762.50 08/01/2025 88,237.50 88,237.50 09/30/2025 1,021,000.00 02/01/2026 860,000 3.500% 88,237.50 948,237.50 08/01/2026 73,187.50 73,187.50 09/30/2026 1,021,425.00 02/01/2027 890,000 4.000% 73,187.50 963,187.50 08/01/2027 55,387.50 55,387.50 09/30/2027 1,018,575.00 02/01/2028 930,000 4.000% 55,387.50 985,387.50 08/01/2028 36,787.50 36,787.50 09/30/2028 1,022,175.00 02/01/2029 960,000 4.000% 36,787.50 996,787.50 08/01/2029 17,587.50 17,587.50 09/30/2029 1,014,375.00 02/01/2030 1,005,000 3.500% 17,587.50 1,022,587.50 09/30/2030 1,022,587.50 7,800,000 1,377,837.50 9,177,837.50 9,177,837.50 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 6 BOND DEBT SERVICE City of Schertz, Texas $1,020,000 Tax Notes, Series 2015A Non Callable Dated Date 11/19/2015 Delivery Date 11/19/2015 Annual Period Debt Ending Principal Coupon Interest Debt Service Service 02/01/2022 1,193.50 1,193.50 08/01/2022 155,000 1.540% 1,193.50 156,193.50 09/30/2022 157,387 155,000 2,387.00 157,387.00 157,387 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 7 BOND DEBT SERVICE City of Schertz, Texas $4,185,000 General Obligation Refunding Bonds, Series 2015 Callable 2/1/2025 at Par Dated Date 11/01/2015 Delivery Date 12/15/2015 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2022 18,525 18,525 08/01/2022 18,525 18,525 09/30/2022 37,050 02/01/2023 18,525 18,525 08/01/2023 18,525 18,525 09/30/2023 37,050 02/01/2024 18,525 18,525 08/01/2024 18,525 18,525 09/30/2024 37,050 02/01/2025 18,525 18,525 08/01/2025 18,525 18,525 09/30/2025 37,050 02/01/2026 18,525 18,525 08/01/2026 18,525 18,525 09/30/2026 37,050 02/01/2027 18,525 18,525 08/01/2027 18,525 18,525 09/30/2027 37,050 02/01/2028 18,525 18,525 08/01/2028 18,525 18,525 09/30/2028 37,050 02/01/2029 18,525 18,525 08/01/2029 18,525 18,525 09/30/2029 37,050 02/01/2030 18,525 18,525 08/01/2030 18,525 18,525 09/30/2030 37,050 02/01/2031 1,140,000 3.250% 18,525 1,158,525 09/30/2031 1,158,525 1,140,000 351,975 1,491,975 1,491,975 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 8 BOND DEBT SERVICE City of Schertz, Texas $5,880,000 General Obligation Bonds, Series 2016 Callable 2/1/2026 at Par Dated Date 08/01/2016 Delivery Date 09/01/2016 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 245,000 4.000% 68,253.13 313,253.13 08/01/2022 63,353.13 63,353.13 09/30/2022 376,606.26 02/01/2023 255,000 4.000% 63,353.13 318,353.13 08/01/2023 58,253.13 58,253.13 09/30/2023 376,606.26 02/01/2024 265,000 4.000% 58,253.13 323,253.13 08/01/2024 52,953.13 52,953.13 09/30/2024 376,206.26 02/01/2025 275,000 4.000% 52,953.13 327,953.13 08/01/2025 47,453.13 47,453.13 09/30/2025 375,406.26 02/01/2026 285,000 4.000% 47,453.13 332,453.13 08/01/2026 41,753.13 41,753.13 09/30/2026 374,206.26 02/01/2027 295,000 2.000% 41,753.13 336,753.13 08/01/2027 38,803.13 38,803.13 09/30/2027 375,556.26 02/01/2028 300,000 2.000% 38,803.13 338,803.13 08/01/2028 35,803.13 35,803.13 09/30/2028 374,606.26 02/01/2029 305,000 2.125% 35,803.13 340,803.13 08/01/2029 32,562.50 32,562.50 09/30/2029 373,365.63 02/01/2030 310,000 2.250% 32,562.50 342,562.50 08/01/2030 29,075.00 29,075.00 09/30/2030 371,637.50 02/01/2031 320,000 2.375% 29,075.00 349,075.00 08/01/2031 25,275.00 25,275.00 09/30/2031 374,350.00 02/01/2032 330,000 2.500% 25,275.00 355,275.00 08/01/2032 21,150.00 21,150.00 09/30/2032 376,425.00 02/01/2033 335,000 3.000% 21,150.00 356,150.00 08/01/2033 16,125.00 16,125.00 09/30/2033 372,275.00 02/01/2034 345,000 3.000% 16,125.00 361,125.00 08/01/2034 10,950.00 10,950.00 09/30/2034 372,075.00 02/01/2035 360,000 3.000% 10,950.00 370,950.00 08/01/2035 5,550.00 5,550.00 09/30/2035 376,500.00 02/01/2036 370,000 3.000% 5,550.00 375,550.00 09/30/2036 375,550.00 4,595,000 1,026,371.95 5,621,371.95 5,621,371.95 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 9 BOND DEBT SERVICE City of Schertz, Texas $2,375,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2016A Callable 2/1/2026 at Par Dated Date 08/01/2016 Delivery Date 09/01/2016 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 195,000 4.000% 22,184.38 217,184.38 08/01/2022 18,284.38 18,284.38 09/30/2022 235,468.76 02/01/2023 205,000 4.000% 18,284.38 223,284.38 08/01/2023 14,184.38 14,184.38 09/30/2023 237,468.76 02/01/2024 70,000 3.000% 14,184.38 84,184.38 08/01/2024 13,134.38 13,134.38 09/30/2024 97,318.76 02/01/2025 75,000 3.000% 13,134.38 88,134.38 08/01/2025 12,009.38 12,009.38 09/30/2025 100,143.76 02/01/2026 75,000 3.000% 12,009.38 87,009.38 08/01/2026 10,884.38 10,884.38 09/30/2026 97,893.76 02/01/2027 80,000 2.000% 10,884.38 90,884.38 08/01/2027 10,084.38 10,084.38 09/30/2027 100,968.76 02/01/2028 80,000 2.000% 10,084.38 90,084.38 08/01/2028 9,284.38 9,284.38 09/30/2028 99,368.76 02/01/2029 80,000 2.125% 9,284.38 89,284.38 08/01/2029 8,434.38 8,434.38 09/30/2029 97,718.76 02/01/2030 85,000 2.250% 8,434.38 93,434.38 08/01/2030 7,478.13 7,478.13 09/30/2030 100,912.51 02/01/2031 85,000 2.375% 7,478.13 92,478.13 08/01/2031 6,468.75 6,468.75 09/30/2031 98,946.88 02/01/2032 90,000 2.375% 6,468.75 96,468.75 08/01/2032 5,400.00 5,400.00 09/30/2032 101,868.75 02/01/2033 90,000 2.500% 5,400.00 95,400.00 08/01/2033 4,275.00 4,275.00 09/30/2033 99,675.00 02/01/2034 90,000 3.000% 4,275.00 94,275.00 08/01/2034 2,925.00 2,925.00 09/30/2034 97,200.00 02/01/2035 95,000 3.000% 2,925.00 97,925.00 08/01/2035 1,500.00 1,500.00 09/30/2035 99,425.00 02/01/2036 100,000 3.000% 1,500.00 101,500.00 09/30/2036 101,500.00 1,495,000 270,878.22 1,765,878.22 1,765,878.22 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 10 BOND DEBT SERVICE City of Schertz, Texas $1,475,000 Combination Tax & Limited Pledge Revenue Certificates of Obligation, Taxable Series 2016B Callable 2/1/2026 at Par YMCA Lease Payment Supported Dated Date 08/01/2016 Delivery Date 09/01/2016 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 60,000 3.000% 20,581.25 80,581.25 08/01/2022 19,681.25 19,681.25 09/30/2022 100,262.50 02/01/2023 65,000 3.000% 19,681.25 84,681.25 08/01/2023 18,706.25 18,706.25 09/30/2023 103,387.50 02/01/2024 65,000 3.000% 18,706.25 83,706.25 08/01/2024 17,731.25 17,731.25 09/30/2024 101,437.50 02/01/2025 70,000 3.000% 17,731.25 87,731.25 08/01/2025 16,681.25 16,681.25 09/30/2025 104,412.50 02/01/2026 70,000 3.000% 16,681.25 86,681.25 08/01/2026 15,631.25 15,631.25 09/30/2026 102,312.50 02/01/2027 75,000 3.500% 15,631.25 90,631.25 08/01/2027 14,318.75 14,318.75 09/30/2027 104,950.00 02/01/2028 75,000 3.500% 14,318.75 89,318.75 08/01/2028 13,006.25 13,006.25 09/30/2028 102,325.00 02/01/2029 80,000 3.500% 13,006.25 93,006.25 08/01/2029 11,606.25 11,606.25 09/30/2029 104,612.50 02/01/2030 80,000 3.500% 11,606.25 91,606.25 08/01/2030 10,206.25 10,206.25 09/30/2030 101,812.50 02/01/2031 85,000 3.500% 10,206.25 95,206.25 08/01/2031 8,718.75 8,718.75 09/30/2031 103,925.00 02/01/2032 85,000 3.750% 8,718.75 93,718.75 08/01/2032 7,125.00 7,125.00 09/30/2032 100,843.75 02/01/2033 90,000 3.750% 7,125.00 97,125.00 08/01/2033 5,437.50 5,437.50 09/30/2033 102,562.50 02/01/2034 95,000 3.750% 5,437.50 100,437.50 08/01/2034 3,656.25 3,656.25 09/30/2034 104,093.75 02/01/2035 95,000 3.750% 3,656.25 98,656.25 08/01/2035 1,875.00 1,875.00 09/30/2035 100,531.25 02/01/2036 100,000 3.750% 1,875.00 101,875.00 09/30/2036 101,875.00 1,190,000 349,343.75 1,539,343.75 1,539,343.75 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 11 BOND DEBT SERVICE City of Schertz, Texas $5,475,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2017 Callable 2/1/2027 at Par Dated Date 05/15/2017 Delivery Date 06/20/2017 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 420,000 3.000% 60,362.50 480,362.50 08/01/2022 54,062.50 54,062.50 09/30/2022 534,425.00 02/01/2023 315,000 3.000% 54,062.50 369,062.50 08/01/2023 49,337.50 49,337.50 09/30/2023 418,400.00 02/01/2024 325,000 3.000% 49,337.50 374,337.50 08/01/2024 44,462.50 44,462.50 09/30/2024 418,800.00 02/01/2025 185,000 3.000% 44,462.50 229,462.50 08/01/2025 41,687.50 41,687.50 09/30/2025 271,150.00 02/01/2026 190,000 3.000% 41,687.50 231,687.50 08/01/2026 38,837.50 38,837.50 09/30/2026 270,525.00 02/01/2027 195,000 3.000% 38,837.50 233,837.50 08/01/2027 35,912.50 35,912.50 09/30/2027 269,750.00 02/01/2028 200,000 3.000% 35,912.50 235,912.50 08/01/2028 32,912.50 32,912.50 09/30/2028 268,825.00 02/01/2029 205,000 3.000% 32,912.50 237,912.50 08/01/2029 29,837.50 29,837.50 09/30/2029 267,750.00 02/01/2030 215,000 3.000% 29,837.50 244,837.50 08/01/2030 26,612.50 26,612.50 09/30/2030 271,450.00 02/01/2031 220,000 3.000% 26,612.50 246,612.50 08/01/2031 23,312.50 23,312.50 09/30/2031 269,925.00 02/01/2032 225,000 3.000% 23,312.50 248,312.50 08/01/2032 19,937.50 19,937.50 09/30/2032 268,250.00 02/01/2033 235,000 3.000% 19,937.50 254,937.50 08/01/2033 16,412.50 16,412.50 09/30/2033 271,350.00 02/01/2034 240,000 3.250% 16,412.50 256,412.50 08/01/2034 12,512.50 12,512.50 09/30/2034 268,925.00 02/01/2035 250,000 3.250% 12,512.50 262,512.50 08/01/2035 8,450.00 8,450.00 09/30/2035 270,962.50 02/01/2036 255,000 3.250% 8,450.00 263,450.00 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 12 BOND DEBT SERVICE City of Schertz, Texas $5,475,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2017 Callable 2/1/2027 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2036 4,306.25 4,306.25 09/30/2036 267,756.25 02/01/2037 265,000 3.250% 4,306.25 269,306.25 09/30/2037 269,306.25 3,940,000 937,550.00 4,877,550.00 4,877,550.00 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 13 BOND DEBT SERVICE City of Schertz, Texas $3,935,000 General Obligation Bonds, Series 2017 Callable 2/1/2027 at Par Dated Date 05/15/2017 Delivery Date 06/20/2017 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 165,000 3.000% 51,262.50 216,262.50 08/01/2022 48,787.50 48,787.50 09/30/2022 265,050.00 02/01/2023 170,000 3.000% 48,787.50 218,787.50 08/01/2023 46,237.50 46,237.50 09/30/2023 265,025.00 02/01/2024 175,000 3.000% 46,237.50 221,237.50 08/01/2024 43,612.50 43,612.50 09/30/2024 264,850.00 02/01/2025 180,000 3.000% 43,612.50 223,612.50 08/01/2025 40,912.50 40,912.50 09/30/2025 264,525.00 02/01/2026 185,000 3.000% 40,912.50 225,912.50 08/01/2026 38,137.50 38,137.50 09/30/2026 264,050.00 02/01/2027 190,000 3.000% 38,137.50 228,137.50 08/01/2027 35,287.50 35,287.50 09/30/2027 263,425.00 02/01/2028 195,000 3.000% 35,287.50 230,287.50 08/01/2028 32,362.50 32,362.50 09/30/2028 262,650.00 02/01/2029 205,000 3.000% 32,362.50 237,362.50 08/01/2029 29,287.50 29,287.50 09/30/2029 266,650.00 02/01/2030 210,000 3.000% 29,287.50 239,287.50 08/01/2030 26,137.50 26,137.50 09/30/2030 265,425.00 02/01/2031 215,000 3.000% 26,137.50 241,137.50 08/01/2031 22,912.50 22,912.50 09/30/2031 264,050.00 02/01/2032 225,000 3.000% 22,912.50 247,912.50 08/01/2032 19,537.50 19,537.50 09/30/2032 267,450.00 02/01/2033 230,000 3.000% 19,537.50 249,537.50 08/01/2033 16,087.50 16,087.50 09/30/2033 265,625.00 02/01/2034 235,000 3.250% 16,087.50 251,087.50 08/01/2034 12,268.75 12,268.75 09/30/2034 263,356.25 02/01/2035 245,000 3.250% 12,268.75 257,268.75 08/01/2035 8,287.50 8,287.50 09/30/2035 265,556.25 02/01/2036 250,000 3.250% 8,287.50 258,287.50 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 14 BOND DEBT SERVICE City of Schertz, Texas $3,935,000 General Obligation Bonds, Series 2017 Callable 2/1/2027 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2036 4,225.00 4,225.00 09/30/2036 262,512.50 02/01/2037 260,000 3.250% 4,225.00 264,225.00 09/30/2037 264,225.00 3,335,000 899,425.00 4,234,425.00 4,234,425.00 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 15 BOND DEBT SERVICE City of Schertz, Texas $6,035,000 General Obligation Refunding Bonds, Series 2018 Callable 2/1/2023 at Par Dated Date 01/04/2018 Delivery Date 01/04/2018 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2022 585,000 2.120% 46,163 631,163 08/01/2022 39,962 39,962 09/30/2022 671,125 02/01/2023 595,000 2.120% 39,962 634,962 08/01/2023 33,655 33,655 09/30/2023 668,617 02/01/2024 610,000 2.120% 33,655 643,655 08/01/2024 27,189 27,189 09/30/2024 670,844 02/01/2025 625,000 2.120% 27,189 652,189 08/01/2025 20,564 20,564 09/30/2025 672,753 02/01/2026 635,000 2.120% 20,564 655,564 08/01/2026 13,833 13,833 09/30/2026 669,397 02/01/2027 645,000 2.120% 13,833 658,833 08/01/2027 6,996 6,996 09/30/2027 665,829 02/01/2028 660,000 2.120% 6,996 666,996 09/30/2028 666,996 4,355,000 330,561 4,685,561 4,685,561 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 16 BOND DEBT SERVICE City of Schertz, Texas $10,440,000 Combination Tax and Limited Pledge Revenues Certificates of Obligation, Series 2018 Callable 2/1/2028 at Par Dated Date 07/01/2018 Delivery Date 08/08/2018 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 450,000 5.000% 185,093.75 635,093.75 08/01/2022 173,843.75 173,843.75 09/30/2022 808,937.50 02/01/2023 475,000 5.000% 173,843.75 648,843.75 08/01/2023 161,968.75 161,968.75 09/30/2023 810,812.50 02/01/2024 495,000 5.000% 161,968.75 656,968.75 08/01/2024 149,593.75 149,593.75 09/30/2024 806,562.50 02/01/2025 520,000 5.000% 149,593.75 669,593.75 08/01/2025 136,593.75 136,593.75 09/30/2025 806,187.50 02/01/2026 435,000 5.000% 136,593.75 571,593.75 08/01/2026 125,718.75 125,718.75 09/30/2026 697,312.50 02/01/2027 455,000 5.000% 125,718.75 580,718.75 08/01/2027 114,343.75 114,343.75 09/30/2027 695,062.50 02/01/2028 480,000 5.000% 114,343.75 594,343.75 08/01/2028 102,343.75 102,343.75 09/30/2028 696,687.50 02/01/2029 505,000 5.000% 102,343.75 607,343.75 08/01/2029 89,718.75 89,718.75 09/30/2029 697,062.50 02/01/2030 525,000 4.000% 89,718.75 614,718.75 08/01/2030 79,218.75 79,218.75 09/30/2030 693,937.50 02/01/2031 545,000 3.000% 79,218.75 624,218.75 08/01/2031 71,043.75 71,043.75 09/30/2031 695,262.50 02/01/2032 560,000 3.000% 71,043.75 631,043.75 08/01/2032 62,643.75 62,643.75 09/30/2032 693,687.50 02/01/2033 580,000 3.125% 62,643.75 642,643.75 08/01/2033 53,581.25 53,581.25 09/30/2033 696,225.00 02/01/2034 595,000 3.250% 53,581.25 648,581.25 08/01/2034 43,912.50 43,912.50 09/30/2034 692,493.75 02/01/2035 620,000 3.250% 43,912.50 663,912.50 08/01/2035 33,837.50 33,837.50 09/30/2035 697,750.00 02/01/2036 640,000 3.375% 33,837.50 673,837.50 08/01/2036 23,037.50 23,037.50 09/30/2036 696,875.00 02/01/2037 660,000 3.375% 23,037.50 683,037.50 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF) (Finance 8.500 Schertz:AGG)   Page 17 BOND DEBT SERVICE City of Schertz, Texas $10,440,000 Combination Tax and Limited Pledge Revenues Certificates of Obligation, Series 2018 Callable 2/1/2028 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2037 11,900.00 11,900.00 09/30/2037 694,937.50 02/01/2038 680,000 3.500% 11,900.00 691,900.00 09/30/2038 691,900.00 9,220,000 3,051,693.75 12,271,693.75 12,271,693.75 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 18 DETAILED BOND DEBT SERVICE City of Schertz, Texas $10,440,000 Combination Tax and Limited Pledge Revenues Certificates of Obligation, Series 2018 Callable 2/1/2028 at Par Dated Date 07/01/2018 Delivery Date 08/08/2018 General Fund Bond Component (GF) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 245,000 5.000% 85,006.25 330,006.25 08/01/2022 78,881.25 78,881.25 09/30/2022 408,887.50 02/01/2023 260,000 5.000% 78,881.25 338,881.25 08/01/2023 72,381.25 72,381.25 09/30/2023 411,262.50 02/01/2024 270,000 5.000% 72,381.25 342,381.25 08/01/2024 65,631.25 65,631.25 09/30/2024 408,012.50 02/01/2025 285,000 5.000% 65,631.25 350,631.25 08/01/2025 58,506.25 58,506.25 09/30/2025 409,137.50 02/01/2026 185,000 5.000% 58,506.25 243,506.25 08/01/2026 53,881.25 53,881.25 09/30/2026 297,387.50 02/01/2027 195,000 5.000% 53,881.25 248,881.25 08/01/2027 49,006.25 49,006.25 09/30/2027 297,887.50 02/01/2028 205,000 5.000% 49,006.25 254,006.25 08/01/2028 43,881.25 43,881.25 09/30/2028 297,887.50 02/01/2029 215,000 5.000% 43,881.25 258,881.25 08/01/2029 38,506.25 38,506.25 09/30/2029 297,387.50 02/01/2030 225,000 4.000% 38,506.25 263,506.25 08/01/2030 34,006.25 34,006.25 09/30/2030 297,512.50 02/01/2031 235,000 3.000% 34,006.25 269,006.25 08/01/2031 30,481.25 30,481.25 09/30/2031 299,487.50 02/01/2032 240,000 3.000% 30,481.25 270,481.25 08/01/2032 26,881.25 26,881.25 09/30/2032 297,362.50 02/01/2033 250,000 3.125% 26,881.25 276,881.25 08/01/2033 22,975.00 22,975.00 09/30/2033 299,856.25 02/01/2034 255,000 3.250% 22,975.00 277,975.00 08/01/2034 18,831.25 18,831.25 09/30/2034 296,806.25 02/01/2035 265,000 3.250% 18,831.25 283,831.25 08/01/2035 14,525.00 14,525.00 09/30/2035 298,356.25 02/01/2036 275,000 3.375% 14,525.00 289,525.00 08/01/2036 9,884.38 9,884.38 09/30/2036 299,409.38 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 19 DETAILED BOND DEBT SERVICE City of Schertz, Texas $10,440,000 Combination Tax and Limited Pledge Revenues Certificates of Obligation, Series 2018 Callable 2/1/2028 at Par General Fund Bond Component (GF) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2037 285,000 3.375% 9,884.38 294,884.38 08/01/2037 5,075.00 5,075.00 09/30/2037 299,959.38 02/01/2038 290,000 3.500% 5,075.00 295,075.00 09/30/2038 295,075.00 4,180,000 1,331,675.01 5,511,675.01 5,511,675.01 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 20 DETAILED BOND DEBT SERVICE City of Schertz, Texas $10,440,000 Combination Tax and Limited Pledge Revenues Certificates of Obligation, Series 2018 Callable 2/1/2028 at Par Dated Date 07/01/2018 Delivery Date 08/08/2018 Utility Fund Component (UF) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 205,000 5.000% 100,087.50 305,087.50 08/01/2022 94,962.50 94,962.50 09/30/2022 400,050.00 02/01/2023 215,000 5.000% 94,962.50 309,962.50 08/01/2023 89,587.50 89,587.50 09/30/2023 399,550.00 02/01/2024 225,000 5.000% 89,587.50 314,587.50 08/01/2024 83,962.50 83,962.50 09/30/2024 398,550.00 02/01/2025 235,000 5.000% 83,962.50 318,962.50 08/01/2025 78,087.50 78,087.50 09/30/2025 397,050.00 02/01/2026 250,000 5.000% 78,087.50 328,087.50 08/01/2026 71,837.50 71,837.50 09/30/2026 399,925.00 02/01/2027 260,000 5.000% 71,837.50 331,837.50 08/01/2027 65,337.50 65,337.50 09/30/2027 397,175.00 02/01/2028 275,000 5.000% 65,337.50 340,337.50 08/01/2028 58,462.50 58,462.50 09/30/2028 398,800.00 02/01/2029 290,000 5.000% 58,462.50 348,462.50 08/01/2029 51,212.50 51,212.50 09/30/2029 399,675.00 02/01/2030 300,000 4.000% 51,212.50 351,212.50 08/01/2030 45,212.50 45,212.50 09/30/2030 396,425.00 02/01/2031 310,000 3.000% 45,212.50 355,212.50 08/01/2031 40,562.50 40,562.50 09/30/2031 395,775.00 02/01/2032 320,000 3.000% 40,562.50 360,562.50 08/01/2032 35,762.50 35,762.50 09/30/2032 396,325.00 02/01/2033 330,000 3.125% 35,762.50 365,762.50 08/01/2033 30,606.25 30,606.25 09/30/2033 396,368.75 02/01/2034 340,000 3.250% 30,606.25 370,606.25 08/01/2034 25,081.25 25,081.25 09/30/2034 395,687.50 02/01/2035 355,000 3.250% 25,081.25 380,081.25 08/01/2035 19,312.50 19,312.50 09/30/2035 399,393.75 02/01/2036 365,000 3.375% 19,312.50 384,312.50 08/01/2036 13,153.13 13,153.13 09/30/2036 397,465.63 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 21 DETAILED BOND DEBT SERVICE City of Schertz, Texas $10,440,000 Combination Tax and Limited Pledge Revenues Certificates of Obligation, Series 2018 Callable 2/1/2028 at Par Utility Fund Component (UF) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2037 375,000 3.375% 13,153.13 388,153.13 08/01/2037 6,825.00 6,825.00 09/30/2037 394,978.13 02/01/2038 390,000 3.500% 6,825.00 396,825.00 09/30/2038 396,825.00 5,040,000 1,720,018.76 6,760,018.76 6,760,018.76 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 22 BOND DEBT SERVICE City of Schertz, Texas $8,570,000 General Obligation and Refunding Bonds, Series 2018 Callable 2/1/2028 at Par Dated Date 10/15/2018 Delivery Date 11/27/2018 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 555,000 5.000% 144,596.88 699,596.88 08/01/2022 130,721.88 130,721.88 09/30/2022 830,318.76 02/01/2023 595,000 5.000% 130,721.88 725,721.88 08/01/2023 115,846.88 115,846.88 09/30/2023 841,568.76 02/01/2024 660,000 5.000% 115,846.88 775,846.88 08/01/2024 99,346.88 99,346.88 09/30/2024 875,193.76 02/01/2025 670,000 5.000% 99,346.88 769,346.88 08/01/2025 82,596.88 82,596.88 09/30/2025 851,943.76 02/01/2026 700,000 5.000% 82,596.88 782,596.88 08/01/2026 65,096.88 65,096.88 09/30/2026 847,693.76 02/01/2027 260,000 5.000% 65,096.88 325,096.88 08/01/2027 58,596.88 58,596.88 09/30/2027 383,693.76 02/01/2028 570,000 4.000% 58,596.88 628,596.88 08/01/2028 47,196.88 47,196.88 09/30/2028 675,793.76 02/01/2029 495,000 4.000% 47,196.88 542,196.88 08/01/2029 37,296.88 37,296.88 09/30/2029 579,493.76 02/01/2030 515,000 4.000% 37,296.88 552,296.88 08/01/2030 26,996.88 26,996.88 09/30/2030 579,293.76 02/01/2031 535,000 3.125% 26,996.88 561,996.88 08/01/2031 18,637.50 18,637.50 09/30/2031 580,634.38 02/01/2032 555,000 3.250% 18,637.50 573,637.50 08/01/2032 9,618.75 9,618.75 09/30/2032 583,256.25 02/01/2033 570,000 3.375% 9,618.75 579,618.75 09/30/2033 579,618.75 6,680,000 1,528,503.22 8,208,503.22 8,208,503.22 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 23 DETAILED BOND DEBT SERVICE City of Schertz, Texas $8,570,000 General Obligation and Refunding Bonds, Series 2018 Callable 2/1/2028 at Par Dated Date 10/15/2018 Delivery Date 11/27/2018 General Fund Bond Component (GF) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 185,000 5.000% 93,221.88 278,221.88 08/01/2022 88,596.88 88,596.88 09/30/2022 366,818.76 02/01/2023 205,000 5.000% 88,596.88 293,596.88 08/01/2023 83,471.88 83,471.88 09/30/2023 377,068.76 02/01/2024 250,000 5.000% 83,471.88 333,471.88 08/01/2024 77,221.88 77,221.88 09/30/2024 410,693.76 02/01/2025 235,000 5.000% 77,221.88 312,221.88 08/01/2025 71,346.88 71,346.88 09/30/2025 383,568.76 02/01/2026 250,000 5.000% 71,346.88 321,346.88 08/01/2026 65,096.88 65,096.88 09/30/2026 386,443.76 02/01/2027 260,000 5.000% 65,096.88 325,096.88 08/01/2027 58,596.88 58,596.88 09/30/2027 383,693.76 02/01/2028 570,000 4.000% 58,596.88 628,596.88 08/01/2028 47,196.88 47,196.88 09/30/2028 675,793.76 02/01/2029 495,000 4.000% 47,196.88 542,196.88 08/01/2029 37,296.88 37,296.88 09/30/2029 579,493.76 02/01/2030 515,000 4.000% 37,296.88 552,296.88 08/01/2030 26,996.88 26,996.88 09/30/2030 579,293.76 02/01/2031 535,000 3.125% 26,996.88 561,996.88 08/01/2031 18,637.50 18,637.50 09/30/2031 580,634.38 02/01/2032 555,000 3.250% 18,637.50 573,637.50 08/01/2032 9,618.75 9,618.75 09/30/2032 583,256.25 02/01/2033 570,000 3.375% 9,618.75 579,618.75 09/30/2033 579,618.75 4,625,000 1,261,378.22 5,886,378.22 5,886,378.22 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 24 DETAILED BOND DEBT SERVICE City of Schertz, Texas $8,570,000 General Obligation and Refunding Bonds, Series 2018 Callable 2/1/2028 at Par Dated Date 10/15/2018 Delivery Date 11/27/2018 Utility Fund Bond Component (UF) Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2022 370,000 5.000% 51,375 421,375 08/01/2022 42,125 42,125 09/30/2022 463,500 02/01/2023 390,000 5.000% 42,125 432,125 08/01/2023 32,375 32,375 09/30/2023 464,500 02/01/2024 410,000 5.000% 32,375 442,375 08/01/2024 22,125 22,125 09/30/2024 464,500 02/01/2025 435,000 5.000% 22,125 457,125 08/01/2025 11,250 11,250 09/30/2025 468,375 02/01/2026 450,000 5.000% 11,250 461,250 09/30/2026 461,250 2,055,000 267,125 2,322,125 2,322,125 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 25 BOND DEBT SERVICE City of Schertz, Texas $7,495,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2019 Callable 2/1/2028 at Par Dated Date 08/01/2019 Delivery Date 08/21/2019 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 395,000 3.000% 111,912.50 506,912.50 08/01/2022 105,987.50 105,987.50 09/30/2022 612,900.00 02/01/2023 410,000 3.000% 105,987.50 515,987.50 08/01/2023 99,837.50 99,837.50 09/30/2023 615,825.00 02/01/2024 420,000 5.000% 99,837.50 519,837.50 08/01/2024 89,337.50 89,337.50 09/30/2024 609,175.00 02/01/2025 435,000 4.000% 89,337.50 524,337.50 08/01/2025 80,637.50 80,637.50 09/30/2025 604,975.00 02/01/2026 460,000 4.000% 80,637.50 540,637.50 08/01/2026 71,437.50 71,437.50 09/30/2026 612,075.00 02/01/2027 295,000 4.000% 71,437.50 366,437.50 08/01/2027 65,537.50 65,537.50 09/30/2027 431,975.00 02/01/2028 305,000 4.000% 65,537.50 370,537.50 08/01/2028 59,437.50 59,437.50 09/30/2028 429,975.00 02/01/2029 315,000 2.500% 59,437.50 374,437.50 08/01/2029 55,500.00 55,500.00 09/30/2029 429,937.50 02/01/2030 320,000 3.000% 55,500.00 375,500.00 08/01/2030 50,700.00 50,700.00 09/30/2030 426,200.00 02/01/2031 330,000 3.000% 50,700.00 380,700.00 08/01/2031 45,750.00 45,750.00 09/30/2031 426,450.00 02/01/2032 340,000 3.000% 45,750.00 385,750.00 08/01/2032 40,650.00 40,650.00 09/30/2032 426,400.00 02/01/2033 355,000 3.000% 40,650.00 395,650.00 08/01/2033 35,325.00 35,325.00 09/30/2033 430,975.00 02/01/2034 365,000 3.000% 35,325.00 400,325.00 08/01/2034 29,850.00 29,850.00 09/30/2034 430,175.00 02/01/2035 375,000 3.000% 29,850.00 404,850.00 08/01/2035 24,225.00 24,225.00 09/30/2035 429,075.00 02/01/2036 385,000 3.000% 24,225.00 409,225.00 08/01/2036 18,450.00 18,450.00 09/30/2036 427,675.00 02/01/2037 400,000 3.000% 18,450.00 418,450.00 08/01/2037 12,450.00 12,450.00 09/30/2037 430,900.00 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 26 BOND DEBT SERVICE City of Schertz, Texas $7,495,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2019 Callable 2/1/2028 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2038 410,000 3.000% 12,450.00 422,450.00 08/01/2038 6,300.00 6,300.00 09/30/2038 428,750.00 02/01/2039 420,000 3.000% 6,300.00 426,300.00 09/30/2039 426,300.00 6,735,000 1,894,737.50 8,629,737.50 8,629,737.50 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 27 DETAILED BOND DEBT SERVICE City of Schertz, Texas $7,495,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2019 Callable 2/1/2028 at Par Dated Date 08/01/2019 Delivery Date 08/21/2019 Road Improvement Component (GF) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 110,000 3.000% 43,587.50 153,587.50 08/01/2022 41,937.50 41,937.50 09/30/2022 195,525.00 02/01/2023 115,000 3.000% 41,937.50 156,937.50 08/01/2023 40,212.50 40,212.50 09/30/2023 197,150.00 02/01/2024 115,000 5.000% 40,212.50 155,212.50 08/01/2024 37,337.50 37,337.50 09/30/2024 192,550.00 02/01/2025 120,000 4.000% 37,337.50 157,337.50 08/01/2025 34,937.50 34,937.50 09/30/2025 192,275.00 02/01/2026 125,000 4.000% 34,937.50 159,937.50 08/01/2026 32,437.50 32,437.50 09/30/2026 192,375.00 02/01/2027 135,000 4.000% 32,437.50 167,437.50 08/01/2027 29,737.50 29,737.50 09/30/2027 197,175.00 02/01/2028 140,000 4.000% 29,737.50 169,737.50 08/01/2028 26,937.50 26,937.50 09/30/2028 196,675.00 02/01/2029 145,000 2.500% 26,937.50 171,937.50 08/01/2029 25,125.00 25,125.00 09/30/2029 197,062.50 02/01/2030 145,000 3.000% 25,125.00 170,125.00 08/01/2030 22,950.00 22,950.00 09/30/2030 193,075.00 02/01/2031 150,000 3.000% 22,950.00 172,950.00 08/01/2031 20,700.00 20,700.00 09/30/2031 193,650.00 02/01/2032 155,000 3.000% 20,700.00 175,700.00 08/01/2032 18,375.00 18,375.00 09/30/2032 194,075.00 02/01/2033 160,000 3.000% 18,375.00 178,375.00 08/01/2033 15,975.00 15,975.00 09/30/2033 194,350.00 02/01/2034 165,000 3.000% 15,975.00 180,975.00 08/01/2034 13,500.00 13,500.00 09/30/2034 194,475.00 02/01/2035 170,000 3.000% 13,500.00 183,500.00 08/01/2035 10,950.00 10,950.00 09/30/2035 194,450.00 02/01/2036 175,000 3.000% 10,950.00 185,950.00 08/01/2036 8,325.00 8,325.00 09/30/2036 194,275.00 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 28 DETAILED BOND DEBT SERVICE City of Schertz, Texas $7,495,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2019 Callable 2/1/2028 at Par Road Improvement Component (GF) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2037 180,000 3.000% 8,325.00 188,325.00 08/01/2037 5,625.00 5,625.00 09/30/2037 193,950.00 02/01/2038 185,000 3.000% 5,625.00 190,625.00 08/01/2038 2,850.00 2,850.00 09/30/2038 193,475.00 02/01/2039 190,000 3.000% 2,850.00 192,850.00 09/30/2039 192,850.00 2,680,000 819,412.50 3,499,412.50 3,499,412.50 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 29 DETAILED BOND DEBT SERVICE City of Schertz, Texas $7,495,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2019 Callable 2/1/2028 at Par Dated Date 08/01/2019 Delivery Date 08/21/2019 Fire Truck Component (FT) Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2022 155,000 3.000% 15,850 170,850 08/01/2022 13,525 13,525 09/30/2022 184,375 02/01/2023 160,000 3.000% 13,525 173,525 08/01/2023 11,125 11,125 09/30/2023 184,650 02/01/2024 165,000 5.000% 11,125 176,125 08/01/2024 7,000 7,000 09/30/2024 183,125 02/01/2025 170,000 4.000% 7,000 177,000 08/01/2025 3,600 3,600 09/30/2025 180,600 02/01/2026 180,000 4.000% 3,600 183,600 09/30/2026 183,600 830,000 86,350 916,350 916,350 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 30 DETAILED BOND DEBT SERVICE City of Schertz, Texas $7,495,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2019 Callable 2/1/2028 at Par Dated Date 08/01/2019 Delivery Date 08/21/2019 Utility Fund Component (UF) Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2022 130,000 3.000% 52,475 182,475 08/01/2022 50,525 50,525 09/30/2022 233,000 02/01/2023 135,000 3.000% 50,525 185,525 08/01/2023 48,500 48,500 09/30/2023 234,025 02/01/2024 140,000 5.000% 48,500 188,500 08/01/2024 45,000 45,000 09/30/2024 233,500 02/01/2025 145,000 4.000% 45,000 190,000 08/01/2025 42,100 42,100 09/30/2025 232,100 02/01/2026 155,000 4.000% 42,100 197,100 08/01/2026 39,000 39,000 09/30/2026 236,100 02/01/2027 160,000 4.000% 39,000 199,000 08/01/2027 35,800 35,800 09/30/2027 234,800 02/01/2028 165,000 4.000% 35,800 200,800 08/01/2028 32,500 32,500 09/30/2028 233,300 02/01/2029 170,000 2.500% 32,500 202,500 08/01/2029 30,375 30,375 09/30/2029 232,875 02/01/2030 175,000 3.000% 30,375 205,375 08/01/2030 27,750 27,750 09/30/2030 233,125 02/01/2031 180,000 3.000% 27,750 207,750 08/01/2031 25,050 25,050 09/30/2031 232,800 02/01/2032 185,000 3.000% 25,050 210,050 08/01/2032 22,275 22,275 09/30/2032 232,325 02/01/2033 195,000 3.000% 22,275 217,275 08/01/2033 19,350 19,350 09/30/2033 236,625 02/01/2034 200,000 3.000% 19,350 219,350 08/01/2034 16,350 16,350 09/30/2034 235,700 02/01/2035 205,000 3.000% 16,350 221,350 08/01/2035 13,275 13,275 09/30/2035 234,625 02/01/2036 210,000 3.000% 13,275 223,275 08/01/2036 10,125 10,125 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 31 DETAILED BOND DEBT SERVICE City of Schertz, Texas $7,495,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2019 Callable 2/1/2028 at Par Utility Fund Component (UF) Annual Period Debt Debt Ending Principal Coupon Interest Service Service 09/30/2036 233,400 02/01/2037 220,000 3.000% 10,125 230,125 08/01/2037 6,825 6,825 09/30/2037 236,950 02/01/2038 225,000 3.000% 6,825 231,825 08/01/2038 3,450 3,450 09/30/2038 235,275 02/01/2039 230,000 3.000% 3,450 233,450 09/30/2039 233,450 3,225,000 988,975 4,213,975 4,213,975 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 32 BOND DEBT SERVICE City of Schertz, Texas $7,555,000 General Obligation Refunding Bonds, Series 2020 Callable 2/1/2029 at Par Dated Date 11/15/2020 Delivery Date 11/18/2020 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 935,000 4.000% 115,331.25 1,050,331.25 08/01/2022 96,631.25 96,631.25 09/30/2022 1,146,962.50 02/01/2023 960,000 4.000% 96,631.25 1,056,631.25 08/01/2023 77,431.25 77,431.25 09/30/2023 1,134,062.50 02/01/2024 970,000 4.000% 77,431.25 1,047,431.25 08/01/2024 58,031.25 58,031.25 09/30/2024 1,105,462.50 02/01/2025 330,000 4.000% 58,031.25 388,031.25 08/01/2025 51,431.25 51,431.25 09/30/2025 439,462.50 02/01/2026 345,000 4.000% 51,431.25 396,431.25 08/01/2026 44,531.25 44,531.25 09/30/2026 440,962.50 02/01/2027 360,000 4.000% 44,531.25 404,531.25 08/01/2027 37,331.25 37,331.25 09/30/2027 441,862.50 02/01/2028 370,000 4.000% 37,331.25 407,331.25 08/01/2028 29,931.25 29,931.25 09/30/2028 437,262.50 02/01/2029 385,000 4.000% 29,931.25 414,931.25 08/01/2029 22,231.25 22,231.25 09/30/2029 437,162.50 02/01/2030 395,000 2.000% 22,231.25 417,231.25 08/01/2030 18,281.25 18,281.25 09/30/2030 435,512.50 02/01/2031 405,000 1.250% 18,281.25 423,281.25 08/01/2031 15,750.00 15,750.00 09/30/2031 439,031.25 02/01/2032 410,000 1.500% 15,750.00 425,750.00 08/01/2032 12,675.00 12,675.00 09/30/2032 438,425.00 02/01/2033 415,000 1.500% 12,675.00 427,675.00 08/01/2033 9,562.50 9,562.50 09/30/2033 437,237.50 02/01/2034 420,000 1.500% 9,562.50 429,562.50 08/01/2034 6,412.50 6,412.50 09/30/2034 435,975.00 02/01/2035 425,000 1.500% 6,412.50 431,412.50 08/01/2035 3,225.00 3,225.00 09/30/2035 434,637.50 02/01/2036 430,000 1.500% 3,225.00 433,225.00 09/30/2036 433,225.00 7,555,000 1,082,243.75 8,637,243.75 8,637,243.75 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 33 BOND DEBT SERVICE City of Schertz, Texas $6,015,000 General Obligation Refunding Bonds, Series 2021 Callable 2/1/2030 at Par Dated Date 11/01/2021 Delivery Date 11/09/2021 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2022 144,187.50 144,187.50 09/30/2022 144,187.50 02/01/2023 495,000 4.000% 96,125.00 591,125.00 08/01/2023 86,225.00 86,225.00 09/30/2023 677,350.00 02/01/2024 510,000 4.000% 86,225.00 596,225.00 08/01/2024 76,025.00 76,025.00 09/30/2024 672,250.00 02/01/2025 530,000 4.000% 76,025.00 606,025.00 08/01/2025 65,425.00 65,425.00 09/30/2025 671,450.00 02/01/2026 555,000 4.000% 65,425.00 620,425.00 08/01/2026 54,325.00 54,325.00 09/30/2026 674,750.00 02/01/2027 580,000 4.000% 54,325.00 634,325.00 08/01/2027 42,725.00 42,725.00 09/30/2027 677,050.00 02/01/2028 600,000 3.000% 42,725.00 642,725.00 08/01/2028 33,725.00 33,725.00 09/30/2028 676,450.00 02/01/2029 620,000 3.000% 33,725.00 653,725.00 08/01/2029 24,425.00 24,425.00 09/30/2029 678,150.00 02/01/2030 635,000 3.000% 24,425.00 659,425.00 08/01/2030 14,900.00 14,900.00 09/30/2030 674,325.00 02/01/2031 655,000 2.000% 14,900.00 669,900.00 08/01/2031 8,350.00 8,350.00 09/30/2031 678,250.00 02/01/2032 665,000 2.000% 8,350.00 673,350.00 08/01/2032 1,700.00 1,700.00 09/30/2032 675,050.00 02/01/2033 170,000 2.000% 1,700.00 171,700.00 09/30/2033 171,700.00 6,015,000 1,055,962.50 7,070,962.50 7,070,962.50 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 34 DETAILED BOND DEBT SERVICE City of Schertz, Texas $6,015,000 General Obligation Refunding Bonds, Series 2021 Callable 2/1/2030 at Par Dated Date 11/01/2021 Delivery Date 11/09/2021 General Fund Portion (GF) Annual Period Debt Debt Ending Principal Coupon Interest Service Service 08/01/2022 98,850 98,850 09/30/2022 98,850 02/01/2023 350,000 4.000% 65,900 415,900 08/01/2023 58,900 58,900 09/30/2023 474,800 02/01/2024 360,000 4.000% 58,900 418,900 08/01/2024 51,700 51,700 09/30/2024 470,600 02/01/2025 370,000 4.000% 51,700 421,700 08/01/2025 44,300 44,300 09/30/2025 466,000 02/01/2026 390,000 4.000% 44,300 434,300 08/01/2026 36,500 36,500 09/30/2026 470,800 02/01/2027 405,000 4.000% 36,500 441,500 08/01/2027 28,400 28,400 09/30/2027 469,900 02/01/2028 420,000 3.000% 28,400 448,400 08/01/2028 22,100 22,100 09/30/2028 470,500 02/01/2029 430,000 3.000% 22,100 452,100 08/01/2029 15,650 15,650 09/30/2029 467,750 02/01/2030 440,000 3.000% 15,650 455,650 08/01/2030 9,050 9,050 09/30/2030 464,700 02/01/2031 450,000 2.000% 9,050 459,050 08/01/2031 4,550 4,550 09/30/2031 463,600 02/01/2032 455,000 2.000% 4,550 459,550 09/30/2032 459,550 4,070,000 707,050 4,777,050 4,777,050 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 35 DETAILED BOND DEBT SERVICE City of Schertz, Texas $6,015,000 General Obligation Refunding Bonds, Series 2021 Callable 2/1/2030 at Par Dated Date 11/01/2021 Delivery Date 11/09/2021 Utility Fund Portion (UF) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2022 45,337.50 45,337.50 09/30/2022 45,337.50 02/01/2023 145,000 4.000% 30,225.00 175,225.00 08/01/2023 27,325.00 27,325.00 09/30/2023 202,550.00 02/01/2024 150,000 4.000% 27,325.00 177,325.00 08/01/2024 24,325.00 24,325.00 09/30/2024 201,650.00 02/01/2025 160,000 4.000% 24,325.00 184,325.00 08/01/2025 21,125.00 21,125.00 09/30/2025 205,450.00 02/01/2026 165,000 4.000% 21,125.00 186,125.00 08/01/2026 17,825.00 17,825.00 09/30/2026 203,950.00 02/01/2027 175,000 4.000% 17,825.00 192,825.00 08/01/2027 14,325.00 14,325.00 09/30/2027 207,150.00 02/01/2028 180,000 3.000% 14,325.00 194,325.00 08/01/2028 11,625.00 11,625.00 09/30/2028 205,950.00 02/01/2029 190,000 3.000% 11,625.00 201,625.00 08/01/2029 8,775.00 8,775.00 09/30/2029 210,400.00 02/01/2030 195,000 3.000% 8,775.00 203,775.00 08/01/2030 5,850.00 5,850.00 09/30/2030 209,625.00 02/01/2031 205,000 2.000% 5,850.00 210,850.00 08/01/2031 3,800.00 3,800.00 09/30/2031 214,650.00 02/01/2032 210,000 2.000% 3,800.00 213,800.00 08/01/2032 1,700.00 1,700.00 09/30/2032 215,500.00 02/01/2033 170,000 2.000% 1,700.00 171,700.00 09/30/2033 171,700.00 1,945,000 348,912.50 2,293,912.50 2,293,912.50 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 36 BOND DEBT SERVICE City of Schertz, Texas $9,390,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2022 Callable 2/1/31 at Par Dated Date 01/01/2022 Delivery Date 02/02/2022 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2022 193,878.13 193,878.13 09/30/2022 193,878.13 02/01/2023 325,000 5.000% 166,181.25 491,181.25 08/01/2023 158,056.25 158,056.25 09/30/2023 649,237.50 02/01/2024 340,000 5.000% 158,056.25 498,056.25 08/01/2024 149,556.25 149,556.25 09/30/2024 647,612.50 02/01/2025 355,000 5.000% 149,556.25 504,556.25 08/01/2025 140,681.25 140,681.25 09/30/2025 645,237.50 02/01/2026 370,000 5.000% 140,681.25 510,681.25 08/01/2026 131,431.25 131,431.25 09/30/2026 642,112.50 02/01/2027 395,000 5.000% 131,431.25 526,431.25 08/01/2027 121,556.25 121,556.25 09/30/2027 647,987.50 02/01/2028 410,000 5.000% 121,556.25 531,556.25 08/01/2028 111,306.25 111,306.25 09/30/2028 642,862.50 02/01/2029 435,000 5.000% 111,306.25 546,306.25 08/01/2029 100,431.25 100,431.25 09/30/2029 646,737.50 02/01/2030 455,000 5.000% 100,431.25 555,431.25 08/01/2030 89,056.25 89,056.25 09/30/2030 644,487.50 02/01/2031 480,000 5.000% 89,056.25 569,056.25 08/01/2031 77,056.25 77,056.25 09/30/2031 646,112.50 02/01/2032 500,000 4.000% 77,056.25 577,056.25 08/01/2032 67,056.25 67,056.25 09/30/2032 644,112.50 02/01/2033 520,000 3.000% 67,056.25 587,056.25 08/01/2033 59,256.25 59,256.25 09/30/2033 646,312.50 02/01/2034 530,000 3.000% 59,256.25 589,256.25 08/01/2034 51,306.25 51,306.25 09/30/2034 640,562.50 02/01/2035 550,000 3.000% 51,306.25 601,306.25 08/01/2035 43,056.25 43,056.25 09/30/2035 644,362.50 02/01/2036 570,000 3.000% 43,056.25 613,056.25 08/01/2036 34,506.25 34,506.25 09/30/2036 647,562.50 02/01/2037 575,000 2.000% 34,506.25 609,506.25 08/01/2037 28,756.25 28,756.25 09/30/2037 638,262.50 02/01/2038 495,000 2.000% 28,756.25 523,756.25 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 37 BOND DEBT SERVICE City of Schertz, Texas $9,390,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2022 Callable 2/1/31 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2038 23,806.25 23,806.25 09/30/2038 547,562.50 02/01/2039 505,000 2.125% 23,806.25 528,806.25 08/01/2039 18,440.63 18,440.63 09/30/2039 547,246.88 02/01/2040 515,000 2.250% 18,440.63 533,440.63 08/01/2040 12,646.88 12,646.88 09/30/2040 546,087.51 02/01/2041 525,000 2.375% 12,646.88 537,646.88 08/01/2041 6,412.50 6,412.50 09/30/2041 544,059.38 02/01/2042 540,000 2.375% 6,412.50 546,412.50 09/30/2042 546,412.50 9,390,000 3,208,809.40 12,598,809.40 12,598,809.40 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 38 DETAILED BOND DEBT SERVICE City of Schertz, Texas $9,390,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2022 Callable 2/1/31 at Par Dated Date 01/01/2022 Delivery Date 02/02/2022 General Fund Portion (GF) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2022 73,500.00 73,500.00 09/30/2022 73,500.00 02/01/2023 120,000 5.000% 63,000.00 183,000.00 08/01/2023 60,000.00 60,000.00 09/30/2023 243,000.00 02/01/2024 125,000 5.000% 60,000.00 185,000.00 08/01/2024 56,875.00 56,875.00 09/30/2024 241,875.00 02/01/2025 130,000 5.000% 56,875.00 186,875.00 08/01/2025 53,625.00 53,625.00 09/30/2025 240,500.00 02/01/2026 135,000 5.000% 53,625.00 188,625.00 08/01/2026 50,250.00 50,250.00 09/30/2026 238,875.00 02/01/2027 145,000 5.000% 50,250.00 195,250.00 08/01/2027 46,625.00 46,625.00 09/30/2027 241,875.00 02/01/2028 150,000 5.000% 46,625.00 196,625.00 08/01/2028 42,875.00 42,875.00 09/30/2028 239,500.00 02/01/2029 160,000 5.000% 42,875.00 202,875.00 08/01/2029 38,875.00 38,875.00 09/30/2029 241,750.00 02/01/2030 165,000 5.000% 38,875.00 203,875.00 08/01/2030 34,750.00 34,750.00 09/30/2030 238,625.00 02/01/2031 175,000 5.000% 34,750.00 209,750.00 08/01/2031 30,375.00 30,375.00 09/30/2031 240,125.00 02/01/2032 185,000 4.000% 30,375.00 215,375.00 08/01/2032 26,675.00 26,675.00 09/30/2032 242,050.00 02/01/2033 190,000 3.000% 26,675.00 216,675.00 08/01/2033 23,825.00 23,825.00 09/30/2033 240,500.00 02/01/2034 195,000 3.000% 23,825.00 218,825.00 08/01/2034 20,900.00 20,900.00 09/30/2034 239,725.00 02/01/2035 200,000 3.000% 20,900.00 220,900.00 08/01/2035 17,900.00 17,900.00 09/30/2035 238,800.00 02/01/2036 210,000 3.000% 17,900.00 227,900.00 08/01/2036 14,750.00 14,750.00 09/30/2036 242,650.00 02/01/2037 215,000 2.000% 14,750.00 229,750.00 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 39 DETAILED BOND DEBT SERVICE City of Schertz, Texas $9,390,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2022 Callable 2/1/31 at Par General Fund Portion (GF) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2037 12,600.00 12,600.00 09/30/2037 242,350.00 02/01/2038 215,000 2.000% 12,600.00 227,600.00 08/01/2038 10,450.00 10,450.00 09/30/2038 238,050.00 02/01/2039 220,000 2.125% 10,450.00 230,450.00 08/01/2039 8,112.50 8,112.50 09/30/2039 238,562.50 02/01/2040 225,000 2.250% 8,112.50 233,112.50 08/01/2040 5,581.25 5,581.25 09/30/2040 238,693.75 02/01/2041 230,000 2.375% 5,581.25 235,581.25 08/01/2041 2,850.00 2,850.00 09/30/2041 238,431.25 02/01/2042 240,000 2.375% 2,850.00 242,850.00 09/30/2042 242,850.00 3,630,000 1,252,287.50 4,882,287.50 4,882,287.50 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 40 DETAILED BOND DEBT SERVICE City of Schertz, Texas $9,390,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2022 Callable 2/1/31 at Par Dated Date 01/01/2022 Delivery Date 02/02/2022 Energy Efficiency Portion (ENERGY) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2022 26,191.67 26,191.67 09/30/2022 26,191.67 02/01/2023 55,000 5.000% 22,450.00 77,450.00 08/01/2023 21,075.00 21,075.00 09/30/2023 98,525.00 02/01/2024 55,000 5.000% 21,075.00 76,075.00 08/01/2024 19,700.00 19,700.00 09/30/2024 95,775.00 02/01/2025 60,000 5.000% 19,700.00 79,700.00 08/01/2025 18,200.00 18,200.00 09/30/2025 97,900.00 02/01/2026 60,000 5.000% 18,200.00 78,200.00 08/01/2026 16,700.00 16,700.00 09/30/2026 94,900.00 02/01/2027 65,000 5.000% 16,700.00 81,700.00 08/01/2027 15,075.00 15,075.00 09/30/2027 96,775.00 02/01/2028 65,000 5.000% 15,075.00 80,075.00 08/01/2028 13,450.00 13,450.00 09/30/2028 93,525.00 02/01/2029 70,000 5.000% 13,450.00 83,450.00 08/01/2029 11,700.00 11,700.00 09/30/2029 95,150.00 02/01/2030 75,000 5.000% 11,700.00 86,700.00 08/01/2030 9,825.00 9,825.00 09/30/2030 96,525.00 02/01/2031 80,000 5.000% 9,825.00 89,825.00 08/01/2031 7,825.00 7,825.00 09/30/2031 97,650.00 02/01/2032 80,000 4.000% 7,825.00 87,825.00 08/01/2032 6,225.00 6,225.00 09/30/2032 94,050.00 02/01/2033 85,000 3.000% 6,225.00 91,225.00 08/01/2033 4,950.00 4,950.00 09/30/2033 96,175.00 02/01/2034 85,000 3.000% 4,950.00 89,950.00 08/01/2034 3,675.00 3,675.00 09/30/2034 93,625.00 02/01/2035 90,000 3.000% 3,675.00 93,675.00 08/01/2035 2,325.00 2,325.00 09/30/2035 96,000.00 02/01/2036 95,000 3.000% 2,325.00 97,325.00 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 41 DETAILED BOND DEBT SERVICE City of Schertz, Texas $9,390,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2022 Callable 2/1/31 at Par Energy Efficiency Portion (ENERGY) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2036 900.00 900.00 09/30/2036 98,225.00 02/01/2037 90,000 2.000% 900.00 90,900.00 09/30/2037 90,900.00 1,110,000 351,891.67 1,461,891.67 1,461,891.67 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 42 DETAILED BOND DEBT SERVICE City of Schertz, Texas $9,390,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2022 Callable 2/1/31 at Par Dated Date 01/01/2022 Delivery Date 02/02/2022 Utility Fund Portion (UF) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2022 94,186.46 94,186.46 09/30/2022 94,186.46 02/01/2023 150,000 5.000% 80,731.25 230,731.25 08/01/2023 76,981.25 76,981.25 09/30/2023 307,712.50 02/01/2024 160,000 5.000% 76,981.25 236,981.25 08/01/2024 72,981.25 72,981.25 09/30/2024 309,962.50 02/01/2025 165,000 5.000% 72,981.25 237,981.25 08/01/2025 68,856.25 68,856.25 09/30/2025 306,837.50 02/01/2026 175,000 5.000% 68,856.25 243,856.25 08/01/2026 64,481.25 64,481.25 09/30/2026 308,337.50 02/01/2027 185,000 5.000% 64,481.25 249,481.25 08/01/2027 59,856.25 59,856.25 09/30/2027 309,337.50 02/01/2028 195,000 5.000% 59,856.25 254,856.25 08/01/2028 54,981.25 54,981.25 09/30/2028 309,837.50 02/01/2029 205,000 5.000% 54,981.25 259,981.25 08/01/2029 49,856.25 49,856.25 09/30/2029 309,837.50 02/01/2030 215,000 5.000% 49,856.25 264,856.25 08/01/2030 44,481.25 44,481.25 09/30/2030 309,337.50 02/01/2031 225,000 5.000% 44,481.25 269,481.25 08/01/2031 38,856.25 38,856.25 09/30/2031 308,337.50 02/01/2032 235,000 4.000% 38,856.25 273,856.25 08/01/2032 34,156.25 34,156.25 09/30/2032 308,012.50 02/01/2033 245,000 3.000% 34,156.25 279,156.25 08/01/2033 30,481.25 30,481.25 09/30/2033 309,637.50 02/01/2034 250,000 3.000% 30,481.25 280,481.25 08/01/2034 26,731.25 26,731.25 09/30/2034 307,212.50 02/01/2035 260,000 3.000% 26,731.25 286,731.25 08/01/2035 22,831.25 22,831.25 09/30/2035 309,562.50 02/01/2036 265,000 3.000% 22,831.25 287,831.25 08/01/2036 18,856.25 18,856.25 09/30/2036 306,687.50 02/01/2037 270,000 2.000% 18,856.25 288,856.25 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 43 DETAILED BOND DEBT SERVICE City of Schertz, Texas $9,390,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2022 Callable 2/1/31 at Par Utility Fund Portion (UF) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2037 16,156.25 16,156.25 09/30/2037 305,012.50 02/01/2038 280,000 2.000% 16,156.25 296,156.25 08/01/2038 13,356.25 13,356.25 09/30/2038 309,512.50 02/01/2039 285,000 2.125% 13,356.25 298,356.25 08/01/2039 10,328.13 10,328.13 09/30/2039 308,684.38 02/01/2040 290,000 2.250% 10,328.13 300,328.13 08/01/2040 7,065.63 7,065.63 09/30/2040 307,393.76 02/01/2041 295,000 2.375% 7,065.63 302,065.63 08/01/2041 3,562.50 3,562.50 09/30/2041 305,628.13 02/01/2042 300,000 2.375% 3,562.50 303,562.50 09/30/2042 303,562.50 4,650,000 1,604,630.23 6,254,630.23 6,254,630.23 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 44 BOND DEBT SERVICE $41,040,000 Contract Revenue Bonds, Series 2001 Schertz/Seguin Local Government Corp. Non Callable Dated Date 08/01/2006 Delivery Date 08/01/2006 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2022 260,000 260,000 08/01/2022 260,000 260,000 09/30/2022 520,000 02/01/2023 260,000 260,000 08/01/2023 260,000 260,000 09/30/2023 520,000 02/01/2024 260,000 260,000 08/01/2024 260,000 260,000 09/30/2024 520,000 02/01/2025 260,000 260,000 08/01/2025 260,000 260,000 09/30/2025 520,000 02/01/2026 260,000 260,000 08/01/2026 260,000 260,000 09/30/2026 520,000 02/01/2027 260,000 260,000 08/01/2027 260,000 260,000 09/30/2027 520,000 02/01/2028 260,000 260,000 08/01/2028 260,000 260,000 09/30/2028 520,000 02/01/2029 260,000 260,000 08/01/2029 260,000 260,000 09/30/2029 520,000 02/01/2030 260,000 260,000 08/01/2030 260,000 260,000 09/30/2030 520,000 02/01/2031 1,795,000 5.200% 260,000 2,055,000 08/01/2031 213,330 213,330 09/30/2031 2,268,330 02/01/2032 1,895,000 5.200% 213,330 2,108,330 08/01/2032 164,060 164,060 09/30/2032 2,272,390 02/01/2033 1,995,000 5.200% 164,060 2,159,060 08/01/2033 112,190 112,190 09/30/2033 2,271,250 02/01/2034 2,100,000 5.200% 112,190 2,212,190 08/01/2034 57,590 57,590 09/30/2034 2,269,780 02/01/2035 2,215,000 5.200% 57,590 2,272,590 09/30/2035 2,272,590 10,000,000 6,034,340 16,034,340 16,034,340 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 45 BOND DEBT SERVICE $6,275,000 Contract Revenue Refunding Bonds, Series 2014 Schertz/Seguin Local Government Corp. Callable 2/1/2022 Dated Date 09/01/2014 Delivery Date 10/15/2014 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2022 590,000 3.000%8,850 598,850 09/30/2022 598,850 590,000 8,850 598,850 598,850 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 46 BOND DEBT SERVICE $41,720,000 Contract Revenue Improvement and Refunding Bonds, New Series 2015 Schertz/Seguin Local Government Corp. Callable 2/1/2023 at Par Dated Date 12/01/2014 Delivery Date 01/13/2015 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2022 825,000 4.000%33,700 858,700 08/01/2022 17,200 17,200 09/30/2022 875,900 02/01/2023 860,000 4.000% 17,200 877,200 09/30/2023 877,200 1,685,000 68,100 1,753,100 1,753,100 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 47 BOND DEBT SERVICE $43,670,000 Contract Revenue Bonds, New Series 2016 (TWDB SWIRFT Project Financing) Schertz/Seguin Local Government Corp. Callable 8/1/2027 at Par Dated Date 08/01/2016 Delivery Date 11/16/2016 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2022 484,621.00 484,621.00 08/01/2022 1,260,000 1.020% 484,621.00 1,744,621.00 09/30/2022 2,229,242.00 02/01/2023 478,195.00 478,195.00 08/01/2023 1,270,000 1.120% 478,195.00 1,748,195.00 09/30/2023 2,226,390.00 02/01/2024 471,083.00 471,083.00 08/01/2024 1,285,000 1.230% 471,083.00 1,756,083.00 09/30/2024 2,227,166.00 02/01/2025 463,180.25 463,180.25 08/01/2025 1,300,000 1.320% 463,180.25 1,763,180.25 09/30/2025 2,226,360.50 02/01/2026 454,600.25 454,600.25 08/01/2026 1,315,000 1.410% 454,600.25 1,769,600.25 09/30/2026 2,224,200.50 02/01/2027 445,329.50 445,329.50 08/01/2027 1,335,000 1.610% 445,329.50 1,780,329.50 09/30/2027 2,225,659.00 02/01/2028 434,582.75 434,582.75 08/01/2028 1,350,000 1.730% 434,582.75 1,784,582.75 09/30/2028 2,219,165.50 02/01/2029 422,905.25 422,905.25 08/01/2029 1,375,000 2.060% 422,905.25 1,797,905.25 09/30/2029 2,220,810.50 02/01/2030 408,742.75 408,742.75 08/01/2030 1,400,000 2.230% 408,742.75 1,808,742.75 09/30/2030 2,217,485.50 02/01/2031 393,132.75 393,132.75 08/01/2031 1,430,000 2.340% 393,132.75 1,823,132.75 09/30/2031 2,216,265.50 02/01/2032 376,401.75 376,401.75 08/01/2032 1,465,000 2.390% 376,401.75 1,841,401.75 09/30/2032 2,217,803.50 02/01/2033 358,895.00 358,895.00 08/01/2033 1,500,000 2.450% 358,895.00 1,858,895.00 09/30/2033 2,217,790.00 02/01/2034 340,520.00 340,520.00 08/01/2034 1,535,000 2.580% 340,520.00 1,875,520.00 09/30/2034 2,216,040.00 02/01/2035 320,718.50 320,718.50 08/01/2035 1,575,000 2.560% 320,718.50 1,895,718.50 09/30/2035 2,216,437.00 02/01/2036 300,558.50 300,558.50 08/01/2036 1,615,000 2.600% 300,558.50 1,915,558.50 09/30/2036 2,216,117.00 02/01/2037 279,563.50 279,563.50 08/01/2037 1,660,000 2.780% 279,563.50 1,939,563.50 09/30/2037 2,219,127.00 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 48 BOND DEBT SERVICE $43,670,000 Contract Revenue Bonds, New Series 2016 (TWDB SWIRFT Project Financing) Schertz/Seguin Local Government Corp. Callable 8/1/2027 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2038 256,489.50 256,489.50 08/01/2038 1,705,000 2.780% 256,489.50 1,961,489.50 09/30/2038 2,217,979.00 02/01/2039 232,790.00 232,790.00 08/01/2039 1,755,000 2.780% 232,790.00 1,987,790.00 09/30/2039 2,220,580.00 02/01/2040 208,395.50 208,395.50 08/01/2040 1,805,000 2.780% 208,395.50 2,013,395.50 09/30/2040 2,221,791.00 02/01/2041 183,306.00 183,306.00 08/01/2041 1,855,000 2.780% 183,306.00 2,038,306.00 09/30/2041 2,221,612.00 02/01/2042 157,521.50 157,521.50 08/01/2042 1,910,000 3.110% 157,521.50 2,067,521.50 09/30/2042 2,225,043.00 02/01/2043 127,821.00 127,821.00 08/01/2043 1,965,000 3.110% 127,821.00 2,092,821.00 09/30/2043 2,220,642.00 02/01/2044 97,265.25 97,265.25 08/01/2044 2,025,000 3.110% 97,265.25 2,122,265.25 09/30/2044 2,219,530.50 02/01/2045 65,776.50 65,776.50 08/01/2045 2,085,000 3.110% 65,776.50 2,150,776.50 09/30/2045 2,216,553.00 02/01/2046 33,354.75 33,354.75 08/01/2046 2,145,000 3.110% 33,354.75 2,178,354.75 09/30/2046 2,211,709.50 39,920,000 15,591,499.50 55,511,499.50 55,511,499.50 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 49 BOND DEBT SERVICE $22,830,000 SWIFT Funding Board Participation Loan, Series 2016 Schertz/Seguin Local Government Corp. Non‐Callable Dated Date 11/16/2016 Delivery Date 11/16/2016 Annual Period Debt Ending Principal Coupon Interest Debt Service Service 02/01/2022 414,068.50 414,068.50 08/01/2022 414,068.50 414,068.50 09/30/2022 828,137 02/01/2023 414,068.50 414,068.50 08/01/2023 414,068.50 414,068.50 09/30/2023 828,137 02/01/2024 414,068.50 414,068.50 08/01/2024 414,068.50 414,068.50 09/30/2024 828,137 02/01/2025 414,068.50 414,068.50 08/01/2025 414,068.50 414,068.50 09/30/2025 828,137 02/01/2026 414,068.50 414,068.50 08/01/2026 414,068.50 414,068.50 09/30/2026 828,137 02/01/2027 414,068.50 414,068.50 08/01/2027 414,068.50 414,068.50 09/30/2027 828,137 02/01/2028 414,068.50 414,068.50 08/01/2028 414,068.50 414,068.50 09/30/2028 828,137 02/01/2029 414,068.50 414,068.50 08/01/2029 414,068.50 414,068.50 09/30/2029 828,137 02/01/2030 414,068.50 414,068.50 08/01/2030 414,068.50 414,068.50 09/30/2030 828,137 02/01/2031 414,068.50 414,068.50 08/01/2031 414,068.50 414,068.50 09/30/2031 828,137 02/01/2032 414,068.50 414,068.50 08/01/2032 414,068.50 414,068.50 09/30/2032 828,137 02/01/2033 414,068.50 414,068.50 08/01/2033 414,068.50 414,068.50 09/30/2033 828,137 02/01/2034 414,068.50 414,068.50 08/01/2034 414,068.50 414,068.50 09/30/2034 828,137 02/01/2035 414,068.50 414,068.50 08/01/2035 300,000 3.190% 414,068.50 714,068.50 09/30/2035 1,128,137 02/01/2036 409,283.50 409,283.50 08/01/2036 700,000 3.240% 409,283.50 1,109,283.50 09/30/2036 1,518,567 02/01/2037 397,943.50 397,943.50 08/01/2037 1,125,000 3.460% 397,943.50 1,522,943.50 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 50 BOND DEBT SERVICE $22,830,000 SWIFT Funding Board Participation Loan, Series 2016 Schertz/Seguin Local Government Corp. Non‐Callable Annual Period Debt Ending Principal Coupon Interest Debt Service Service 09/30/2037 1,920,887 02/01/2038 378,481.00 378,481.00 08/01/2038 1,165,000 3.460% 378,481.00 1,543,481.00 09/30/2038 1,921,962 02/01/2039 358,326.50 358,326.50 08/01/2039 1,205,000 3.460% 358,326.50 1,563,326.50 09/30/2039 1,921,653 02/01/2040 337,480.00 337,480.00 08/01/2040 1,250,000 3.460% 337,480.00 1,587,480.00 09/30/2040 1,924,960 02/01/2041 315,855.00 315,855.00 08/01/2041 1,290,000 3.460% 315,855.00 1,605,855.00 09/30/2041 1,921,710 02/01/2042 293,538.00 293,538.00 08/01/2042 1,340,000 3.880% 293,538.00 1,633,538.00 09/30/2042 1,927,076 02/01/2043 267,542.00 267,542.00 08/01/2043 1,390,000 3.880% 267,542.00 1,657,542.00 09/30/2043 1,925,084 02/01/2044 240,576.00 240,576.00 08/01/2044 1,440,000 3.880% 240,576.00 1,680,576.00 09/30/2044 1,921,152 02/01/2045 212,640.00 212,640.00 08/01/2045 1,490,000 3.880% 212,640.00 1,702,640.00 09/30/2045 1,915,280 02/01/2046 183,734.00 183,734.00 08/01/2046 1,545,000 3.880% 183,734.00 1,728,734.00 09/30/2046 1,912,468 02/01/2047 153,761.00 153,761.00 08/01/2047 1,605,000 3.580% 153,761.00 1,758,761.00 09/30/2047 1,912,522 02/01/2048 125,031.50 125,031.50 08/01/2048 1,660,000 3.580% 125,031.50 1,785,031.50 09/30/2048 1,910,063 02/01/2049 95,317.50 95,317.50 08/01/2049 1,715,000 3.580% 95,317.50 1,810,317.50 09/30/2049 1,905,635 02/01/2050 64,619.00 64,619.00 08/01/2050 1,775,000 3.580% 64,619.00 1,839,619.00 09/30/2050 1,904,238 02/01/2051 32,846.50 32,846.50 08/01/2051 1,835,000 3.580% 32,846.50 1,867,846.50 09/30/2051 1,900,693 22,830,000 19,327,868.00 42,157,868.00 42,157,868 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 51 BOND DEBT SERVICE $19,045,000 Contract Revenue Refunding Bonds, Series 2018 Schertz/Seguin Local Government Corp. Callable at Par on 2/1/2027 Dated Date 11/15/2018 Delivery Date 12/13/2018 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2022 565,000 3.000% 385,150 950,150 08/01/2022 376,675 376,675 09/30/2022 1,326,825 02/01/2023 590,000 5.000% 376,675 966,675 08/01/2023 361,925 361,925 09/30/2023 1,328,600 02/01/2024 615,000 5.000% 361,925 976,925 08/01/2024 346,550 346,550 09/30/2024 1,323,475 02/01/2025 650,000 5.000% 346,550 996,550 08/01/2025 330,300 330,300 09/30/2025 1,326,850 02/01/2026 680,000 5.000% 330,300 1,010,300 08/01/2026 313,300 313,300 09/30/2026 1,323,600 02/01/2027 715,000 5.000% 313,300 1,028,300 08/01/2027 295,425 295,425 09/30/2027 1,323,725 02/01/2028 755,000 5.000% 295,425 1,050,425 08/01/2028 276,550 276,550 09/30/2028 1,326,975 02/01/2029 795,000 5.000% 276,550 1,071,550 08/01/2029 256,675 256,675 09/30/2029 1,328,225 02/01/2030 835,000 5.000% 256,675 1,091,675 08/01/2030 235,800 235,800 09/30/2030 1,327,475 02/01/2031 870,000 4.000% 235,800 1,105,800 08/01/2031 218,400 218,400 09/30/2031 1,324,200 02/01/2032 905,000 4.000% 218,400 1,123,400 08/01/2032 200,300 200,300 09/30/2032 1,323,700 02/01/2033 940,000 4.000% 200,300 1,140,300 08/01/2033 181,500 181,500 09/30/2033 1,321,800 02/01/2034 980,000 4.000% 181,500 1,161,500 08/01/2034 161,900 161,900 09/30/2034 1,323,400 02/01/2035 1,020,000 4.000% 161,900 1,181,900 08/01/2035 141,500 141,500 09/30/2035 1,323,400 02/01/2036 1,065,000 4.000% 141,500 1,206,500 08/01/2036 120,200 120,200 09/30/2036 1,326,700 02/01/2037 1,110,000 4.000% 120,200 1,230,200 08/01/2037 98,000 98,000 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 52 BOND DEBT SERVICE $19,045,000 Contract Revenue Refunding Bonds, Series 2018 Schertz/Seguin Local Government Corp. Callable at Par on 2/1/2027 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 09/30/2037 1,328,200 02/01/2038 1,150,000 4.000% 98,000 1,248,000 08/01/2038 75,000 75,000 09/30/2038 1,323,000 02/01/2039 1,200,000 4.000% 75,000 1,275,000 08/01/2039 51,000 51,000 09/30/2039 1,326,000 02/01/2040 1,250,000 4.000% 51,000 1,301,000 08/01/2040 26,000 26,000 09/30/2040 1,327,000 02/01/2041 1,300,000 4.000% 26,000 1,326,000 09/30/2041 1,326,000 17,990,000 8,519,150 26,509,150 26,509,150 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 53 BOND DEBT SERVICE $39,150,000 Contract Revenue Refunding Bonds, Taxable New Series 2022 Schertz/Seguin Local Government Corporation Callable 2/1/2031 at Par Dated Date 02/24/2022 Delivery Date 02/24/2022 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2022 486,444.20 486,444.20 09/30/2022 486,444.20 02/01/2023 995,000 1.372% 557,706.73 1,552,706.73 08/01/2023 550,881.03 550,881.03 09/30/2023 2,103,587.76 02/01/2024 1,895,000 1.592% 550,881.03 2,445,881.03 08/01/2024 535,796.83 535,796.83 09/30/2024 2,981,677.86 02/01/2025 1,925,000 1.830% 535,796.83 2,460,796.83 08/01/2025 518,183.08 518,183.08 09/30/2025 2,978,979.91 02/01/2026 2,090,000 2.083% 518,183.08 2,608,183.08 08/01/2026 496,415.73 496,415.73 09/30/2026 3,104,598.81 02/01/2027 2,125,000 2.233% 496,415.73 2,621,415.73 08/01/2027 472,690.10 472,690.10 09/30/2027 3,094,105.83 02/01/2028 2,180,000 2.302% 472,690.10 2,652,690.10 08/01/2028 447,598.30 447,598.30 09/30/2028 3,100,288.40 02/01/2029 2,230,000 2.452% 447,598.30 2,677,598.30 08/01/2029 420,258.50 420,258.50 09/30/2029 3,097,856.80 02/01/2030 2,280,000 2.560% 420,258.50 2,700,258.50 08/01/2030 391,074.50 391,074.50 09/30/2030 3,091,333.00 02/01/2031 580,000 2.660% 391,074.50 971,074.50 08/01/2031 383,360.50 383,360.50 09/30/2031 1,354,435.00 02/01/2032 600,000 2.760% 383,360.50 983,360.50 08/01/2032 375,080.50 375,080.50 09/30/2032 1,358,441.00 02/01/2033 620,000 2.910% 375,080.50 995,080.50 08/01/2033 366,059.50 366,059.50 09/30/2033 1,361,140.00 02/01/2034 640,000 3.010% 366,059.50 1,006,059.50 08/01/2034 356,427.50 356,427.50 09/30/2034 1,362,487.00 02/01/2035 655,000 3.110% 356,427.50 1,011,427.50 08/01/2035 346,242.25 346,242.25 09/30/2035 1,357,669.75 02/01/2036 2,970,000 3.210% 346,242.25 3,316,242.25 08/01/2036 298,573.75 298,573.75 09/30/2036 3,614,816.00 02/01/2037 3,075,000 3.310% 298,573.75 3,373,573.75 08/01/2037 247,682.50 247,682.50 09/30/2037 3,621,256.25 02/01/2038 3,190,000 3.350% 247,682.50 3,437,682.50 Feb 3, 2022  10:26 am  Prepared by SAMCO Capital (ATF)(Finance 8.500 Schertz:AGG)   Page 54 BOND DEBT SERVICE $39,150,000 Contract Revenue Refunding Bonds, Taxable New Series 2022 Schertz/Seguin Local Government Corporation Callable 2/1/2031 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2038 194,250.00 194,250.00 09/30/2038 3,631,932.50 02/01/2039 3,295,000 3.500% 194,250.00 3,489,250.00 08/01/2039 136,587.50 136,587.50 09/30/2039 3,625,837.50 02/01/2040 3,410,000 3.500% 136,587.50 3,546,587.50 08/01/2040 76,912.50 76,912.50 09/30/2040 3,623,500.00 02/01/2041 3,530,000 3.500% 76,912.50 3,606,912.50 08/01/2041 15,137.50 15,137.50 09/30/2041 3,622,050.00 02/01/2042 280,000 3.500% 15,137.50 295,137.50 08/01/2042 10,237.50 10,237.50 09/30/2042 305,375.00 02/01/2043 290,000 3.500% 10,237.50 300,237.50 08/01/2043 5,162.50 5,162.50 09/30/2043 305,400.00 02/01/2044 295,000 3.500% 5,162.50 300,162.50 09/30/2044 300,162.50 39,150,000 14,333,375.07 53,483,375.07 53,483,375.07