Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Debt Model Report Sept 30, 2023 updated Aug 31, 2022
City of Schertz, Texas Debt Model Updated: August 31, 2022 Presented by: SAMCO Capital Markets, Inc. Mark McLiney Andrew Friedman Ryan Cunningham (210) 832-9760 Debt Model Fiscal Year GO's GO Ref 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 CO's GO's Total Ending 9/30 S-2007 S-2014 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*S-2022A S-2022 Debt Service 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$ 639,225$ 1,431,975$ 8,744,547$ 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 615,725 1,381,725 8,517,945 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 617,100 1,381,225 7,680,215 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 612,850 1,379,225 7,559,309 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 612,975 1,380,600 7,382,293 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 612,350 1,380,225 7,237,715 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 615,850 1,378,100 6,471,228 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 613,475 1,379,100 6,468,694 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 615,225 1,378,100 6,577,225 2032 - - - 376,425 101,869 100,844 268,250 267,450 - 297,363 583,256 194,075 438,425 459,550 336,100 615,975 1,379,975 5,419,556 2033 - - - 372,275 99,675 102,563 271,350 265,625 - 299,856 579,619 194,350 437,238 - 336,675 615,725 1,379,600 4,954,550 2034 - - - 372,075 97,200 104,094 268,925 263,356 - 296,806 - 194,475 435,975 - 333,350 614,475 1,376,975 4,357,706 2035 - - - 376,500 99,425 100,531 270,963 265,556 - 298,356 - 194,450 434,638 - 334,800 614,500 1,377,200 4,366,919 2036 - - - 375,550 101,500 101,875 267,756 262,513 - 299,409 - 194,275 433,225 - 340,875 615,900 1,380,500 4,373,378 2037 - - - - - - 269,306 264,225 - 299,959 - 193,950 - - 333,250 616,500 1,377,100 3,354,291 2038 - - - - - - - - - 295,075 - 193,475 - - 238,050 616,300 1,377,000 2,719,900 2039 - - - - - - - - - - - 192,850 - - 238,563 615,300 1,380,000 2,426,713 2040 - - - - - - - - - - - - - - 238,694 613,500 1,381,000 2,233,194 2041 - - - - - - - - - - - - - - 238,431 615,800 1,380,000 2,234,231 2042 - - - - - - - - - - - - - - 242,850 617,100 1,377,000 2,236,950 Total 2,126,974$ 8,159,813$ 1,454,925$ 5,244,766$ 1,530,409$ 1,439,081$ 4,343,125$ 3,969,375$ 4,014,436$ 5,102,788$ 5,519,559$ 4,035,863$ 7,490,281$ 4,678,200$ 6,244,488$ 12,325,850$ 27,636,625$ 105,316,557$ * 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 GO Ref.CO's GO and Ref.CO's GO Ref.CO's CO's TotalEnding 9/30 S-2013 S-2018 S-2018 S-2019 S-2021 S-2022 S-2022A Debt Service 2023 218,739$ 399,550$ 464,500$ 234,025$ 202,550$ 307,713$ 792,450$ 2,619,526$ 2024 223,321 398,550 464,500 233,500 201,650 309,963 765,700 2,597,183 2025 217,774 397,050 468,375 232,100 205,450 306,838 763,825 2,591,411 2026 - 399,925 461,250 236,100 203,950 308,338 766,075 2,375,638 2027 - 397,175 - 234,800 207,150 309,338 762,450 1,910,913 2028 - 398,800 - 233,300 205,950 309,838 762,950 1,910,838 2029 - 399,675 - 232,875 210,400 309,838 762,450 1,915,238 2030 - 396,425 - 233,125 209,625 309,338 765,825 1,914,338 2031 - 395,775 - 232,800 214,650 308,338 763,075 1,914,638 2032 - 396,325 - 232,325 215,500 308,013 764,200 1,916,363 2033 - 396,369 - 236,625 171,700 309,638 764,075 1,878,406 2034 - 395,688 - 235,700 - 307,213 762,700 1,701,300 2035 - 399,394 - 234,625 - 309,563 762,900 1,706,481 2036 - 397,466 - 233,400 - 306,688 764,800 1,702,353 2037 - 394,978 - 236,950 - 305,013 765,700 1,702,641 2038 - 396,825 - 235,275 - 309,513 765,600 1,707,213 2039 - - - 233,450 - 308,684 764,500 1,306,634 2040 - - - - - 307,394 762,400 1,069,794 2041 - - - - - 305,628 764,200 1,069,828 2042 - - - - - 303,563 759,900 1,063,463 Total 659,833$ 6,359,969$ 1,858,625$ 3,980,975$ 2,248,575$ 6,160,444$ 15,305,775$ 36,574,195$ Utility System Supported Debt Obligations City of Schertz, Texas Debt Model General Fund Debt Obligations Fiscal Year Rev Bonds Rev & Ref Bonds Rev Bonds(1)BP Loan(2)Ref Bonds Rev Ref Bonds Rev Bonds Total Fiscal Year Rev Ref Bonds Ending 9/30 S-2001 S-2015 S-2016 S-2016 S-2018 S-2022 S-2022A Debt Service Ending 9/30 S-20192023520,000$ 877,200$ 2,226,390$ 331,255$ 1,328,600$ 2,103,588$ 183,029$ 7,570,062$ 2023 1,390,188$ 2024 520,000 - 2,227,166 455,475 1,323,475 2,981,678 236,925 7,744,719 2024 1,388,988 2025 520,000 - 2,226,361 579,696 1,326,850 2,978,980 235,675 7,867,561 2025 1,388,294 2026 520,000 - 2,224,201 703,916 1,323,600 3,104,599 234,425 8,110,741 2026 1,392,206 2027 520,000 - 2,225,659 828,137 1,323,725 3,094,106 233,175 8,224,802 2027 1,390,725 2028 520,000 - 2,219,166 828,137 1,326,975 3,100,288 231,925 8,226,491 2028 1,388,275 2029 520,000 - 2,220,811 1,213,122 1,328,225 3,097,857 230,675 8,610,689 2029 1,393,900 2030 520,000 - 2,217,486 1,598,107 1,327,475 3,091,333 229,425 8,983,826 2030 1,392,400 2031 2,268,330 - 2,216,266 1,598,107 1,324,200 1,354,435 228,175 8,989,513 2031 1,393,775 2032 2,272,390 - 2,217,804 1,598,107 1,323,700 1,358,441 226,925 8,997,367 2032 1,388,025 2033 2,271,250 - 2,217,790 1,598,107 1,321,800 1,361,140 225,800 8,995,887 2033 1,390,025 2034 2,269,780 - 2,216,040 1,598,107 1,323,400 1,362,487 224,800 8,994,614 2034 1,389,800 2035 2,272,590 - 2,216,437 1,898,107 1,323,400 1,357,670 223,800 9,292,004 2035 1,387,800 2036 - - 2,216,117 1,903,552 1,326,700 3,614,816 222,800 9,283,985 2036 1,389,100 2037 - - 2,219,127 1,920,887 1,328,200 3,621,256 221,800 9,311,270 2037 1,388,600 2038 - - 2,217,979 1,921,962 1,323,000 3,631,933 220,800 9,315,674 2038 1,391,200 2039 - - 2,220,580 1,921,653 1,326,000 3,625,838 219,800 9,313,871 2039 1,386,900 2040 - - 2,221,791 1,924,960 1,327,000 3,623,500 218,800 9,316,051 2040 1,390,600 2041 - - 2,221,612 1,921,710 1,326,000 3,622,050 217,800 9,309,172 2041 1,387,200 2042 - - 2,225,043 1,927,076 - 305,375 442,200 4,899,694 2042 - 2043 - - 2,220,642 1,925,084 - 305,400 431,681 4,882,807 2043 - 2044 - - 2,219,531 1,921,152 - 300,163 420,844 4,861,689 2044 - 2045 - - 2,216,553 1,915,280 - - 410,006 4,541,839 2045 - 2046 - - 2,211,710 1,912,468 - - 399,169 4,523,346 2046 - 2047 - - - 1,912,522 - - 660,375 2,572,897 2047 - 2048 - - - 1,910,063 - - 638,500 2,548,563 2048 - 2049 - - - 1,905,635 - - 616,375 2,522,010 2049 - 2050 - - - 1,904,238 - - 608,625 2,512,863 2050 - 2051 - - - 1,900,693 - - 604,750 2,505,443 2051 - Total 15,514,340$ 877,200$ 53,282,258$ 45,477,317$ 25,182,325$ 52,996,931$ 9,499,079$ 202,829,450$ Total 26,408,000$ (1) The Revenue Bond, Series 2016 is not equally split between Schertz and Seguin. Please refer to the Cost Allocation Agreement Relating to the Guadalupe Project. (2) The board particpation loan repayment schedule, shown above, is not the same as the Annual Debt Service Schedule. This reflects both the deferred payments and the repayment of the deferred payments. SSLGC-SAWS PROJECTThe Schertz/Seguin Local Government Corporation Fiscal Year Contract Rev Bonds Contract Rev Bonds Ending 9/30 S-2014 S-2018 Total 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,053,300$ 6,653,200$ 15,706,500$ Cibolo Creek Municipal Authority - Southern Wastewater Treatment Plant Debt Service Schedules Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 1 BOND DEBT SERVICE City of Schertz, Texas $6,000,000 General Obligation Bonds, Series 2007 Callable at Par plus Prepayment Penalty Period Annual Ending Principal Coupon Interest Debt Service Debt Service 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.2502/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.2509/30/2026 425,030.50 02/01/2027 415,000 4.070%8,445.25 423,445.25 09/30/2027 423,445.25 1,925,000 201,973.75 2,126,973.75 2,126,973.75 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 2 BOND DEBT SERVICE City of Schertz, Texas $2,160,000 General Obligation Refunding Bonds, Series 2013 Callable 2/1/2023 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 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.5002/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 635,000 24,832.50 659,832.50 659,832.50 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 3 BOND DEBT SERVICE City of Schertz, Texas $8,450,000 General Obligation Refunding Bonds, Series 2014 Callable 2/1/2023 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 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.0002/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.5009/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.0002/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,050,000 1,109,812.50 8,159,812.50 8,159,812.50 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 4 BOND DEBT SERVICE City of Schertz, Texas $4,185,000 General Obligation Refunding Bonds, Series 2015 Callable 2/1/2025 at Par Annual Period Debt Debt Ending Principal Coupon Interest Service Service 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,05002/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,52508/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,52509/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 314,925 1,454,925 1,454,925 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 5 BOND DEBT SERVICE City of Schertz, Texas $5,880,000 General Obligation Bonds, Series 2016 Callable 2/1/2026 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 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.2602/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.1309/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.2602/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.0008/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.0009/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.0009/30/2036 375,550.00 4,350,000 894,765.69 5,244,765.69 5,244,765.69 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 6 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 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 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.7602/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.3809/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.7602/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.1308/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.0009/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.0009/30/2036 101,500.00 1,300,000 230,409.46 1,530,409.46 1,530,409.46 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 7 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 SupportedPeriod Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2023 65,000 3.000%19,681.25 84,681.2508/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.2509/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.7508/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.2509/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.7502/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.0009/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,130,000 309,081.25 1,439,081.25 1,439,081.25 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 8 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 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.0002/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.5009/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.0002/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.5008/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.5009/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.0008/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,520,000 823,125.00 4,343,125.00 4,343,125.00 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 9 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 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.0002/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.5009/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.0002/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.5008/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.5009/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.5008/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,170,000 799,375.00 3,969,375.00 3,969,375.00 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 10 BOND DEBT SERVICE City of Schertz, Texas $6,035,000 General Obligation Refunding Bonds, Series 2018 Callable 2/1/2023 at Par Annual Period Debt Debt Ending Principal Coupon Interest Service Service 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,84402/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,83308/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 3,770,000 244,436 4,014,436 4,014,436 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 11 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 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.5002/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.7509/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.5002/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.7508/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.2509/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.5008/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 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 8,770,000 2,692,756.25 11,462,756.25 11,462,756.25 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 12 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 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2023 260,000 5.000% 78,881.25 338,881.2508/01/2023 72,381.25 72,381.25 09/30/2023 411,262.5002/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.5002/01/2025 285,000 5.000% 65,631.25 350,631.25 08/01/2025 58,506.25 58,506.2509/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.2509/30/2026 297,387.50 02/01/2027 195,000 5.000% 53,881.25 248,881.2508/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.2508/01/2028 43,881.25 43,881.25 09/30/2028 297,887.5002/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.5002/01/2030 225,000 4.000% 38,506.25 263,506.25 08/01/2030 34,006.25 34,006.2509/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.2509/30/2031 299,487.50 02/01/2032 240,000 3.000% 30,481.25 270,481.2508/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.2508/01/2033 22,975.00 22,975.00 09/30/2033 299,856.2502/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.2502/01/2035 265,000 3.250% 18,831.25 283,831.25 08/01/2035 14,525.00 14,525.0009/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.3809/30/2036 299,409.38 02/01/2037 285,000 3.375% 9,884.38 294,884.3808/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.0009/30/2038 295,075.00 3,935,000 1,167,787.51 5,102,787.51 5,102,787.51 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 13 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 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2023 215,000 5.000% 94,962.50 309,962.5008/01/2023 89,587.50 89,587.50 09/30/2023 399,550.0002/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.0002/01/2025 235,000 5.000% 83,962.50 318,962.50 08/01/2025 78,087.50 78,087.5009/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.5009/30/2026 399,925.00 02/01/2027 260,000 5.000% 71,837.50 331,837.5008/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.5008/01/2028 58,462.50 58,462.50 09/30/2028 398,800.0002/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.0002/01/2030 300,000 4.000% 51,212.50 351,212.50 08/01/2030 45,212.50 45,212.5009/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.5009/30/2031 395,775.00 02/01/2032 320,000 3.000% 40,562.50 360,562.5008/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.5008/01/2033 30,606.25 30,606.25 09/30/2033 396,368.7502/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.5002/01/2035 355,000 3.250% 25,081.25 380,081.25 08/01/2035 19,312.50 19,312.5009/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.1309/30/2036 397,465.63 02/01/2037 375,000 3.375% 13,153.13 388,153.1308/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.0009/30/2038 396,825.00 4,835,000 1,524,968.76 6,359,968.76 6,359,968.76 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 14 BOND DEBT SERVICE City of Schertz, Texas $8,570,000 General Obligation and Refunding Bonds, Series 2018 Callable 2/1/2028 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 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.7602/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.8809/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.7602/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.8808/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,125,000 1,253,184.46 7,378,184.46 7,378,184.46 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 15 BOND DEBT SERVICE City of Schertz, Texas $8,570,000 General Obligation and Refunding Bonds, Series 2018 Callable 2/1/2028 at Par General Fund Period Annual Ending Principal Coupon Interest Debt Service Debt Service 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.7602/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.8809/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.7602/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.5008/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,440,000 1,079,559.46 5,519,559.46 5,519,559.46 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 16 BOND DEBT SERVICE City of Schertz, Texas $8,570,000 General Obligation and Refunding Bonds, Series 2018 Callable 2/1/2028 at Par Utility Fund Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2023 390,000 5.000% 42,125 432,125 08/01/2023 32,375 32,37509/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,37502/01/2026 450,000 5.000% 11,250 461,250 09/30/2026 461,250 1,685,000 173,625 1,858,625 1,858,625 Aug 30, 2022 1:51 pm Prepared by SAMCO Capital Markets, Inc. (RBC)(Finance 8.800 Schertz:SCHERTZ-2019) Page 17 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 AnnualEnding Principal Coupon Interest Debt Service Debt Service 02/01/2023 410,000 3.000% 105,987.50 515,987.50 08/01/2023 99,837.50 99,837.5009/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.5009/30/2024 609,175.00 02/01/2025 435,000 4.000% 89,337.50 524,337.5008/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.5008/01/2026 71,437.50 71,437.50 09/30/2026 612,075.0002/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.0002/01/2028 305,000 4.000% 65,537.50 370,537.50 08/01/2028 59,437.50 59,437.5009/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.0009/30/2029 429,937.50 02/01/2030 320,000 3.000% 55,500.00 375,500.0008/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.0008/01/2031 45,750.00 45,750.00 09/30/2031 426,450.0002/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.0002/01/2033 355,000 3.000% 40,650.00 395,650.00 08/01/2033 35,325.00 35,325.0009/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.0009/30/2034 430,175.00 02/01/2035 375,000 3.000% 29,850.00 404,850.0008/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.0008/01/2036 18,450.00 18,450.00 09/30/2036 427,675.0002/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.0002/01/2038 410,000 3.000% 12,450.00 422,450.00 08/01/2038 6,300.00 6,300.0009/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,340,000 1,676,837.50 8,016,837.50 8,016,837.50 Aug 30, 2022 1:51 pm Prepared by SAMCO Capital Markets, Inc. (RBC)(Finance 8.800 Schertz:SCHERTZ-2019) Page 18 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 General Fund Period AnnualEnding Principal Coupon Interest Debt Service Debt Service 02/01/2023 275,000 3.000% 55,462.50 330,462.50 08/01/2023 51,337.50 51,337.5009/30/2023 381,800.00 02/01/2024 280,000 5.000% 51,337.50 331,337.50 08/01/2024 44,337.50 44,337.5009/30/2024 375,675.00 02/01/2025 290,000 4.000% 44,337.50 334,337.5008/01/2025 38,537.50 38,537.50 09/30/2025 372,875.00 02/01/2026 305,000 4.000% 38,537.50 343,537.5008/01/2026 32,437.50 32,437.50 09/30/2026 375,975.0002/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.0002/01/2028 140,000 4.000% 29,737.50 169,737.50 08/01/2028 26,937.50 26,937.5009/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.0009/30/2029 197,062.50 02/01/2030 145,000 3.000% 25,125.00 170,125.0008/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.0008/01/2031 20,700.00 20,700.00 09/30/2031 193,650.0002/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.0002/01/2033 160,000 3.000% 18,375.00 178,375.00 08/01/2033 15,975.00 15,975.0009/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.0009/30/2034 194,475.00 02/01/2035 170,000 3.000% 13,500.00 183,500.0008/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.0008/01/2036 8,325.00 8,325.00 09/30/2036 194,275.0002/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.0002/01/2038 185,000 3.000% 5,625.00 190,625.00 08/01/2038 2,850.00 2,850.0009/30/2038 193,475.00 02/01/2039 190,000 3.000% 2,850.00 192,850.00 09/30/2039 192,850.00 3,245,000 790,862.50 4,035,862.50 4,035,862.50 Aug 30, 2022 1:51 pm Prepared by SAMCO Capital Markets, Inc. (RBC)(Finance 8.800 Schertz:SCHERTZ-2019) Page 19 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 AnnualPeriod Debt DebtEnding Principal Coupon Interest Service Service 02/01/2023 135,000 3.000% 50,525 185,525 08/01/2023 48,500 48,500 09/30/2023 234,02502/01/2024 140,000 5.000% 48,500 188,500 08/01/2024 45,000 45,00009/30/2024 233,500 02/01/2025 145,000 4.000% 45,000 190,000 08/01/2025 42,100 42,10009/30/2025 232,100 02/01/2026 155,000 4.000% 42,100 197,10008/01/2026 39,000 39,000 09/30/2026 236,100 02/01/2027 160,000 4.000% 39,000 199,00008/01/2027 35,800 35,800 09/30/2027 234,80002/01/2028 165,000 4.000% 35,800 200,800 08/01/2028 32,500 32,500 09/30/2028 233,30002/01/2029 170,000 2.500% 32,500 202,500 08/01/2029 30,375 30,37509/30/2029 232,875 02/01/2030 175,000 3.000% 30,375 205,375 08/01/2030 27,750 27,75009/30/2030 233,125 02/01/2031 180,000 3.000% 27,750 207,75008/01/2031 25,050 25,050 09/30/2031 232,800 02/01/2032 185,000 3.000% 25,050 210,05008/01/2032 22,275 22,275 09/30/2032 232,32502/01/2033 195,000 3.000% 22,275 217,275 08/01/2033 19,350 19,350 09/30/2033 236,62502/01/2034 200,000 3.000% 19,350 219,350 08/01/2034 16,350 16,35009/30/2034 235,700 02/01/2035 205,000 3.000% 16,350 221,350 08/01/2035 13,275 13,27509/30/2035 234,625 02/01/2036 210,000 3.000% 13,275 223,27508/01/2036 10,125 10,125 09/30/2036 233,400 02/01/2037 220,000 3.000% 10,125 230,12508/01/2037 6,825 6,825 09/30/2037 236,95002/01/2038 225,000 3.000% 6,825 231,825 08/01/2038 3,450 3,450 09/30/2038 235,27502/01/2039 230,000 3.000% 3,450 233,450 09/30/2039 233,450 3,095,000 885,975 3,980,975 3,980,975 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 20 BOND DEBT SERVICE City of Schertz, Texas $7,555,000 General Obligation Refunding Bonds, Series 2020 Callable 2/1/2029 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 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.5002/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.2509/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.5002/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.2508/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.5009/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.0009/30/2036 433,225.00 6,620,000 870,281.25 7,490,281.25 7,490,281.25 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 21 BOND DEBT SERVICE City of Schertz, Texas $6,015,000 General Obligation Refunding Bonds, Series 2021 Callable 2/1/2030 at Par Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2023 495,000 4.000% 96,125 591,125 08/01/2023 86,225 86,225 09/30/2023 677,350 02/01/2024 510,000 4.000% 86,225 596,225 08/01/2024 76,025 76,025 09/30/2024 672,25002/01/2025 530,000 4.000% 76,025 606,025 08/01/2025 65,425 65,425 09/30/2025 671,450 02/01/2026 555,000 4.000% 65,425 620,425 08/01/2026 54,325 54,325 09/30/2026 674,750 02/01/2027 580,000 4.000% 54,325 634,32508/01/2027 42,725 42,725 09/30/2027 677,050 02/01/2028 600,000 3.000% 42,725 642,725 08/01/2028 33,725 33,725 09/30/2028 676,450 02/01/2029 620,000 3.000% 33,725 653,725 08/01/2029 24,425 24,42509/30/2029 678,150 02/01/2030 635,000 3.000% 24,425 659,425 08/01/2030 14,900 14,900 09/30/2030 674,325 02/01/2031 655,000 2.000% 14,900 669,900 08/01/2031 8,350 8,350 09/30/2031 678,250 02/01/2032 665,000 2.000% 8,350 673,35008/01/2032 1,700 1,700 09/30/2032 675,050 02/01/2033 170,000 2.000% 1,700 171,700 09/30/2033 171,700 6,015,000 911,775 6,926,775 6,926,775 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 22 DEBT SERVICE City of Schertz, Texas $6,015,000 General Obligation Refunding Bonds, Series 2021 Callable 2/1/2030 at Par General Fund Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2023 350,000 4.000% 65,900 415,900 08/01/2023 58,900 58,90009/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,00002/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,40008/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,05009/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 608,200 4,678,200 4,678,200 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 23 DEBT SERVICE City of Schertz, Texas $6,015,000 General Obligation Refunding Bonds, Series 2021 Callable 2/1/2030 at Par Utility Fund Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2023 145,000 4.000% 30,225 175,225 08/01/2023 27,325 27,32509/30/2023 202,550 02/01/2024 150,000 4.000% 27,325 177,325 08/01/2024 24,325 24,325 09/30/2024 201,650 02/01/2025 160,000 4.000% 24,325 184,325 08/01/2025 21,125 21,125 09/30/2025 205,45002/01/2026 165,000 4.000% 21,125 186,125 08/01/2026 17,825 17,825 09/30/2026 203,950 02/01/2027 175,000 4.000% 17,825 192,825 08/01/2027 14,325 14,325 09/30/2027 207,150 02/01/2028 180,000 3.000% 14,325 194,32508/01/2028 11,625 11,625 09/30/2028 205,950 02/01/2029 190,000 3.000% 11,625 201,625 08/01/2029 8,775 8,775 09/30/2029 210,400 02/01/2030 195,000 3.000% 8,775 203,775 08/01/2030 5,850 5,85009/30/2030 209,625 02/01/2031 205,000 2.000% 5,850 210,850 08/01/2031 3,800 3,800 09/30/2031 214,650 02/01/2032 210,000 2.000% 3,800 213,800 08/01/2032 1,700 1,700 09/30/2032 215,500 02/01/2033 170,000 2.000% 1,700 171,70009/30/2033 171,700 1,945,000 303,575 2,248,575 2,248,575 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 24 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 02/01/2023 325,000 5.000% 166,181.25 491,181.2508/01/2023 158,056.25 158,056.2509/30/2023 649,237.50 02/01/2024 340,000 5.000% 158,056.25 498,056.2508/01/2024 149,556.25 149,556.25 09/30/2024 647,612.5002/01/2025 355,000 5.000% 149,556.25 504,556.25 08/01/2025 140,681.25 140,681.2509/30/2025 645,237.50 02/01/2026 370,000 5.000% 140,681.25 510,681.2508/01/2026 131,431.25 131,431.25 09/30/2026 642,112.5002/01/2027 395,000 5.000% 131,431.25 526,431.25 08/01/2027 121,556.25 121,556.2509/30/2027 647,987.5002/01/2028 410,000 5.000% 121,556.25 531,556.25 08/01/2028 111,306.25 111,306.2509/30/2028 642,862.50 02/01/2029 435,000 5.000% 111,306.25 546,306.2508/01/2029 100,431.25 100,431.25 09/30/2029 646,737.5002/01/2030 455,000 5.000% 100,431.25 555,431.25 08/01/2030 89,056.25 89,056.2509/30/2030 644,487.50 02/01/2031 480,000 5.000% 89,056.25 569,056.2508/01/2031 77,056.25 77,056.2509/30/2031 646,112.5002/01/2032 500,000 4.000% 77,056.25 577,056.2508/01/2032 67,056.25 67,056.25 09/30/2032 644,112.5002/01/2033 520,000 3.000% 67,056.25 587,056.25 08/01/2033 59,256.25 59,256.2509/30/2033 646,312.50 02/01/2034 530,000 3.000% 59,256.25 589,256.2508/01/2034 51,306.25 51,306.25 09/30/2034 640,562.5002/01/2035 550,000 3.000% 51,306.25 601,306.25 08/01/2035 43,056.25 43,056.2509/30/2035 644,362.5002/01/2036 570,000 3.000% 43,056.25 613,056.25 08/01/2036 34,506.25 34,506.2509/30/2036 647,562.50 02/01/2037 575,000 2.000% 34,506.25 609,506.2508/01/2037 28,756.25 28,756.25 09/30/2037 638,262.5002/01/2038 495,000 2.000% 28,756.25 523,756.25 08/01/2038 23,806.25 23,806.2509/30/2038 547,562.50 02/01/2039 505,000 2.125% 23,806.25 528,806.2508/01/2039 18,440.63 18,440.63 09/30/2039 547,246.8802/01/2040 515,000 2.250% 18,440.63 533,440.6308/01/2040 12,646.88 12,646.88 09/30/2040 546,087.5102/01/2041 525,000 2.375% 12,646.88 537,646.88 08/01/2041 6,412.50 6,412.5009/30/2041 544,059.38 02/01/2042 540,000 2.375% 6,412.50 546,412.5009/30/2042 546,412.50 9,390,000 3,014,931.27 12,404,931.27 12,404,931.27 Aug 30, 2022 4:39 pm Prepared by SAMCO Capital Markets, Inc. (RBC)(Finance 8.800 Schertz:SCHERTZ-2022_DM) Page 25 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 + Energy Efficiency Period AnnualEnding Principal Coupon Interest Debt Service Debt Service 02/01/2023 175,000 5.000% 85,450.00 260,450.00 08/01/2023 81,075.00 81,075.0009/30/2023 341,525.00 02/01/2024 180,000 5.000% 81,075.00 261,075.00 08/01/2024 76,575.00 76,575.0009/30/2024 337,650.00 02/01/2025 190,000 5.000% 76,575.00 266,575.0008/01/2025 71,825.00 71,825.00 09/30/2025 338,400.00 02/01/2026 195,000 5.000% 71,825.00 266,825.0008/01/2026 66,950.00 66,950.00 09/30/2026 333,775.0002/01/2027 210,000 5.000% 66,950.00 276,950.00 08/01/2027 61,700.00 61,700.00 09/30/2027 338,650.0002/01/2028 215,000 5.000% 61,700.00 276,700.00 08/01/2028 56,325.00 56,325.0009/30/2028 333,025.00 02/01/2029 230,000 5.000% 56,325.00 286,325.00 08/01/2029 50,575.00 50,575.0009/30/2029 336,900.00 02/01/2030 240,000 5.000% 50,575.00 290,575.0008/01/2030 44,575.00 44,575.00 09/30/2030 335,150.00 02/01/2031 255,000 5.000% 44,575.00 299,575.0008/01/2031 38,200.00 38,200.00 09/30/2031 337,775.0002/01/2032 265,000 4.000% 38,200.00 303,200.00 08/01/2032 32,900.00 32,900.00 09/30/2032 336,100.0002/01/2033 275,000 3.000% 32,900.00 307,900.00 08/01/2033 28,775.00 28,775.0009/30/2033 336,675.00 02/01/2034 280,000 3.000% 28,775.00 308,775.00 08/01/2034 24,575.00 24,575.0009/30/2034 333,350.00 02/01/2035 290,000 3.000% 24,575.00 314,575.0008/01/2035 20,225.00 20,225.00 09/30/2035 334,800.00 02/01/2036 305,000 3.000% 20,225.00 325,225.0008/01/2036 15,650.00 15,650.00 09/30/2036 340,875.0002/01/2037 305,000 2.000% 15,650.00 320,650.00 08/01/2037 12,600.00 12,600.00 09/30/2037 333,250.0002/01/2038 215,000 2.000% 12,600.00 227,600.00 08/01/2038 10,450.00 10,450.0009/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.5009/30/2039 238,562.50 02/01/2040 225,000 2.250% 8,112.50 233,112.5008/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 Aug 30, 2022 4:39 pm Prepared by SAMCO Capital Markets, Inc. (RBC)(Finance 8.800 Schertz:SCHERTZ-2022_DM) Page 26 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 + Energy Efficiency Period AnnualEnding Principal Coupon Interest Debt Service Debt Service 08/01/2041 2,850.00 2,850.00 09/30/2041 238,431.2502/01/2042 240,000 2.375% 2,850.00 242,850.00 09/30/2042 242,850.00 4,740,000 1,504,487.50 6,244,487.50 6,244,487.50 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 27 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 Period AnnualEnding Principal Coupon Interest Debt Service Debt Service 02/01/2023 150,000 5.000% 80,731.25 230,731.25 08/01/2023 76,981.25 76,981.2509/30/2023 307,712.50 02/01/2024 160,000 5.000% 76,981.25 236,981.2508/01/2024 72,981.25 72,981.2509/30/2024 309,962.50 02/01/2025 165,000 5.000% 72,981.25 237,981.2508/01/2025 68,856.25 68,856.25 09/30/2025 306,837.5002/01/2026 175,000 5.000% 68,856.25 243,856.25 08/01/2026 64,481.25 64,481.2509/30/2026 308,337.50 02/01/2027 185,000 5.000% 64,481.25 249,481.2508/01/2027 59,856.25 59,856.25 09/30/2027 309,337.5002/01/2028 195,000 5.000% 59,856.25 254,856.25 08/01/2028 54,981.25 54,981.2509/30/2028 309,837.5002/01/2029 205,000 5.000% 54,981.25 259,981.25 08/01/2029 49,856.25 49,856.2509/30/2029 309,837.50 02/01/2030 215,000 5.000% 49,856.25 264,856.2508/01/2030 44,481.25 44,481.25 09/30/2030 309,337.5002/01/2031 225,000 5.000% 44,481.25 269,481.25 08/01/2031 38,856.25 38,856.2509/30/2031 308,337.50 02/01/2032 235,000 4.000% 38,856.25 273,856.2508/01/2032 34,156.25 34,156.2509/30/2032 308,012.5002/01/2033 245,000 3.000% 34,156.25 279,156.2508/01/2033 30,481.25 30,481.25 09/30/2033 309,637.5002/01/2034 250,000 3.000% 30,481.25 280,481.25 08/01/2034 26,731.25 26,731.2509/30/2034 307,212.50 02/01/2035 260,000 3.000% 26,731.25 286,731.2508/01/2035 22,831.25 22,831.25 09/30/2035 309,562.5002/01/2036 265,000 3.000% 22,831.25 287,831.25 08/01/2036 18,856.25 18,856.2509/30/2036 306,687.5002/01/2037 270,000 2.000% 18,856.25 288,856.25 08/01/2037 16,156.25 16,156.2509/30/2037 305,012.50 02/01/2038 280,000 2.000% 16,156.25 296,156.2508/01/2038 13,356.25 13,356.25 09/30/2038 309,512.5002/01/2039 285,000 2.125% 13,356.25 298,356.25 08/01/2039 10,328.13 10,328.1309/30/2039 308,684.38 02/01/2040 290,000 2.250% 10,328.13 300,328.1308/01/2040 7,065.63 7,065.63 09/30/2040 307,393.7602/01/2041 295,000 2.375% 7,065.63 302,065.6308/01/2041 3,562.50 3,562.50 09/30/2041 305,628.1302/01/2042 300,000 2.375% 3,562.50 303,562.50 09/30/2042 303,562.50 4,650,000 1,510,443.77 6,160,443.77 6,160,443.77 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 28 BOND DEBT SERVICE City of Schertz, Texas $18,530,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2022A Callable 2/1/2031 at Par Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2023 615,000 5.000% 416,025 1,031,02508/01/2023 400,650 400,650 09/30/2023 1,431,67502/01/2024 595,000 5.000% 400,650 995,650 08/01/2024 385,775 385,77509/30/2024 1,381,42502/01/2025 625,000 5.000% 385,775 1,010,77508/01/2025 370,150 370,15009/30/2025 1,380,925 02/01/2026 655,000 5.000% 370,150 1,025,15008/01/2026 353,775 353,775 09/30/2026 1,378,92502/01/2027 685,000 5.000% 353,775 1,038,775 08/01/2027 336,650 336,65009/30/2027 1,375,425 02/01/2028 720,000 5.000% 336,650 1,056,65008/01/2028 318,650 318,650 09/30/2028 1,375,30002/01/2029 760,000 5.000% 318,650 1,078,65008/01/2029 299,650 299,650 09/30/2029 1,378,30002/01/2030 800,000 5.000% 299,650 1,099,650 08/01/2030 279,650 279,65009/30/2030 1,379,300 02/01/2031 840,000 5.000% 279,650 1,119,65008/01/2031 258,650 258,650 09/30/2031 1,378,30002/01/2032 885,000 5.000% 258,650 1,143,650 08/01/2032 236,525 236,52509/30/2032 1,380,175 02/01/2033 930,000 5.000% 236,525 1,166,52508/01/2033 213,275 213,27509/30/2033 1,379,800 02/01/2034 975,000 5.000% 213,275 1,188,27508/01/2034 188,900 188,900 09/30/2034 1,377,17502/01/2035 1,020,000 4.000% 188,900 1,208,900 08/01/2035 168,500 168,50009/30/2035 1,377,400 02/01/2036 1,065,000 4.000% 168,500 1,233,50008/01/2036 147,200 147,200 09/30/2036 1,380,70002/01/2037 1,110,000 4.000% 147,200 1,257,20008/01/2037 125,000 125,00009/30/2037 1,382,20002/01/2038 1,155,000 4.000% 125,000 1,280,000 08/01/2038 101,900 101,90009/30/2038 1,381,900 02/01/2039 1,200,000 4.000% 101,900 1,301,90008/01/2039 77,900 77,900 09/30/2039 1,379,80002/01/2040 1,245,000 4.000% 77,900 1,322,900 08/01/2040 53,000 53,00009/30/2040 1,375,900 02/01/2041 1,300,000 4.000% 53,000 1,353,00008/01/2041 27,000 27,00009/30/2041 1,380,000 02/01/2042 1,350,000 4.000% 27,000 1,377,00009/30/2042 1,377,000 18,530,000 9,101,625 27,631,625 27,631,625 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 29 BOND DEBT SERVICE City of Schertz, Texas $18,530,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2022A Callable 2/1/2031 at Par General Fund AnnualPeriod Debt Debt Ending Principal Coupon Interest Service Service 02/01/2023 275,000 5.000% 185,550 460,550 08/01/2023 178,675 178,67509/30/2023 639,225 02/01/2024 265,000 5.000% 178,675 443,67508/01/2024 172,050 172,050 09/30/2024 615,72502/01/2025 280,000 5.000% 172,050 452,050 08/01/2025 165,050 165,05009/30/2025 617,10002/01/2026 290,000 5.000% 165,050 455,05008/01/2026 157,800 157,80009/30/2026 612,850 02/01/2027 305,000 5.000% 157,800 462,80008/01/2027 150,175 150,175 09/30/2027 612,97502/01/2028 320,000 5.000% 150,175 470,175 08/01/2028 142,175 142,17509/30/2028 612,350 02/01/2029 340,000 5.000% 142,175 482,17508/01/2029 133,675 133,675 09/30/2029 615,85002/01/2030 355,000 5.000% 133,675 488,67508/01/2030 124,800 124,800 09/30/2030 613,47502/01/2031 375,000 5.000% 124,800 499,800 08/01/2031 115,425 115,42509/30/2031 615,225 02/01/2032 395,000 5.000% 115,425 510,42508/01/2032 105,550 105,550 09/30/2032 615,97502/01/2033 415,000 5.000% 105,550 520,550 08/01/2033 95,175 95,17509/30/2033 615,725 02/01/2034 435,000 5.000% 95,175 530,17508/01/2034 84,300 84,30009/30/2034 614,475 02/01/2035 455,000 4.000% 84,300 539,30008/01/2035 75,200 75,200 09/30/2035 614,50002/01/2036 475,000 4.000% 75,200 550,200 08/01/2036 65,700 65,70009/30/2036 615,900 02/01/2037 495,000 4.000% 65,700 560,70008/01/2037 55,800 55,800 09/30/2037 616,50002/01/2038 515,000 4.000% 55,800 570,80008/01/2038 45,500 45,500 09/30/2038 616,30002/01/2039 535,000 4.000% 45,500 580,500 08/01/2039 34,800 34,80009/30/2039 615,300 02/01/2040 555,000 4.000% 34,800 589,80008/01/2040 23,700 23,700 09/30/2040 613,50002/01/2041 580,000 4.000% 23,700 603,700 08/01/2041 12,100 12,10009/30/2041 615,800 02/01/2042 605,000 4.000% 12,100 617,10009/30/2042 617,100 8,265,000 4,060,850 12,325,850 12,325,850 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 30 BOND DEBT SERVICE City of Schertz, Texas $18,530,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2022A Callable 2/1/2031 at Par Utility Fund AnnualPeriod Debt Debt Ending Principal Coupon Interest Service Service 02/01/2023 340,000 5.000% 230,475 570,475 08/01/2023 221,975 221,97509/30/2023 792,450 02/01/2024 330,000 5.000% 221,975 551,97508/01/2024 213,725 213,725 09/30/2024 765,70002/01/2025 345,000 5.000% 213,725 558,725 08/01/2025 205,100 205,10009/30/2025 763,82502/01/2026 365,000 5.000% 205,100 570,10008/01/2026 195,975 195,97509/30/2026 766,075 02/01/2027 380,000 5.000% 195,975 575,97508/01/2027 186,475 186,475 09/30/2027 762,45002/01/2028 400,000 5.000% 186,475 586,475 08/01/2028 176,475 176,47509/30/2028 762,950 02/01/2029 420,000 5.000% 176,475 596,47508/01/2029 165,975 165,975 09/30/2029 762,45002/01/2030 445,000 5.000% 165,975 610,97508/01/2030 154,850 154,850 09/30/2030 765,82502/01/2031 465,000 5.000% 154,850 619,850 08/01/2031 143,225 143,22509/30/2031 763,075 02/01/2032 490,000 5.000% 143,225 633,22508/01/2032 130,975 130,975 09/30/2032 764,20002/01/2033 515,000 5.000% 130,975 645,975 08/01/2033 118,100 118,10009/30/2033 764,075 02/01/2034 540,000 5.000% 118,100 658,10008/01/2034 104,600 104,60009/30/2034 762,700 02/01/2035 565,000 4.000% 104,600 669,60008/01/2035 93,300 93,300 09/30/2035 762,90002/01/2036 590,000 4.000% 93,300 683,300 08/01/2036 81,500 81,50009/30/2036 764,800 02/01/2037 615,000 4.000% 81,500 696,50008/01/2037 69,200 69,200 09/30/2037 765,70002/01/2038 640,000 4.000% 69,200 709,20008/01/2038 56,400 56,400 09/30/2038 765,60002/01/2039 665,000 4.000% 56,400 721,400 08/01/2039 43,100 43,10009/30/2039 764,500 02/01/2040 690,000 4.000% 43,100 733,10008/01/2040 29,300 29,300 09/30/2040 762,40002/01/2041 720,000 4.000% 29,300 749,300 08/01/2041 14,900 14,90009/30/2041 764,200 02/01/2042 745,000 4.000% 14,900 759,90009/30/2042 759,900 10,265,000 5,040,775 15,305,775 15,305,775 Aug 3, 2022 9:27 am Prepared by SAMCO (JTM)(Finance 8.800 Schertz:AGG2022) Page 31 BOND DEBT SERVICE City of Schertz, Texas $18,535,000 General Obligation Bonds, Series 2022 Callable 2/1/2031 at Par Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2023 615,000 5.000% 416,175 1,031,17508/01/2023 400,800 400,800 09/30/2023 1,431,97502/01/2024 595,000 5.000% 400,800 995,800 08/01/2024 385,925 385,92509/30/2024 1,381,72502/01/2025 625,000 5.000% 385,925 1,010,92508/01/2025 370,300 370,30009/30/2025 1,381,225 02/01/2026 655,000 5.000% 370,300 1,025,30008/01/2026 353,925 353,925 09/30/2026 1,379,22502/01/2027 690,000 5.000% 353,925 1,043,925 08/01/2027 336,675 336,67509/30/2027 1,380,600 02/01/2028 725,000 5.000% 336,675 1,061,67508/01/2028 318,550 318,550 09/30/2028 1,380,22502/01/2029 760,000 5.000% 318,550 1,078,55008/01/2029 299,550 299,550 09/30/2029 1,378,10002/01/2030 800,000 5.000% 299,550 1,099,550 08/01/2030 279,550 279,55009/30/2030 1,379,100 02/01/2031 840,000 5.000% 279,550 1,119,55008/01/2031 258,550 258,550 09/30/2031 1,378,10002/01/2032 885,000 5.000% 258,550 1,143,550 08/01/2032 236,425 236,42509/30/2032 1,379,975 02/01/2033 930,000 5.000% 236,425 1,166,42508/01/2033 213,175 213,17509/30/2033 1,379,600 02/01/2034 975,000 5.000% 213,175 1,188,17508/01/2034 188,800 188,800 09/30/2034 1,376,97502/01/2035 1,020,000 4.000% 188,800 1,208,800 08/01/2035 168,400 168,40009/30/2035 1,377,200 02/01/2036 1,065,000 4.000% 168,400 1,233,40008/01/2036 147,100 147,100 09/30/2036 1,380,50002/01/2037 1,105,000 4.000% 147,100 1,252,10008/01/2037 125,000 125,00009/30/2037 1,377,10002/01/2038 1,150,000 4.000% 125,000 1,275,000 08/01/2038 102,000 102,00009/30/2038 1,377,000 02/01/2039 1,200,000 4.000% 102,000 1,302,00008/01/2039 78,000 78,000 09/30/2039 1,380,00002/01/2040 1,250,000 4.000% 78,000 1,328,000 08/01/2040 53,000 53,00009/30/2040 1,381,000 02/01/2041 1,300,000 4.000% 53,000 1,353,00008/01/2041 27,000 27,00009/30/2041 1,380,000 02/01/2042 1,350,000 4.000% 27,000 1,377,00009/30/2042 1,377,000 18,535,000 9,101,625 27,636,625 27,636,625