Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Debt Model Report Sept 30, 2021 Updated Nov 5, 2020
City of Schertz, Texas R- 1U, 10 - Presented by: SAMCO Capital Markets, Inc. Mark McLiney Andrew Friedman (210) 832 -9760 2022 425,267 503,676 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 6,626,911 2023 426,123'! 505,126 1,020,150 - .37,050 376,606 237,469'.: 103,388 418,400 :265,025 f 668,617 ( 411,263: 377;069 381,800 ;1,134,063 6,362,148 2024 426,370 - - 500,920 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 6,213,165 2026 425,031 - 504,435 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 5,267,094 2027 423,445:: - 502,250 1,018,575.: (- - ? 37,050 is 375,556 100,969:: 104,950 269,750 :263,425 665,829 297,888 383,694 197,175 "441,863 5,082;418 2028 - 504,275 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 4,945,890 2029 500,925 1,014,375 = !' 37,050 373,366 97,719!. 104,613 267,750 :266,650 297,388: 579;494 197,063 437,163 4,173;553 4 2030 - 502,200 1,022,588 37,050 371,638 100,913 101,813 271,450 265,425 - 297,513 579,294 193,075 435,513 4,178,469 2032 101,869 297,363 583,256 2035 - - : 376,500 99,425 100,531 270,963 ::265,556 298,356: 194,450 F434,639 2,040;419'. 2036 - - - - - 375,550 101,500 101,875 267,756 262,513 299,409 194,275 433,225 2,036,103 `- 2037 . 269,306 x264,225 299,959: 193,950 .......193,475 1,027;441^ 2038. _. - - 1,555,064 295,075 237,963 488,550 '.2039 464;500 233,500 1,557,833 192,850 192,850': Total $ 2,976,040 $ 276,750 $ 490,650 $ 6,033,280 $ 9,558,613 $ 40,700 $ 312,084 $ 2,229,375 $ 5,997,578 $ 2,004,047 $ 1,641,406 $ 5,409,350 $ 4,499,350 $ 5,353,929 $ 5,922,563 $ 6,616,072 $ 4,793,463 $ 8,801,270 $ 72,956,519 2021 $ 247,200 $ 506,525 $ 224,252 $ 30,525 $ 400,050 $ 461,500 $ 236,900 $m 2,106,952 2021 $ 122,100 2022 237,975 :224,028 400,050:: 463,500 233,000 1558,553:k Total $ 122,100 2023 - 238,250 218,739 399,550 464,500 234,025 1,555,064 2024 237,963 223,321 - 398,550. 464;500 233,500 1,557,833 2025 - 237,100 217,774 397,050 468,375 232,100 1,552,399 2026 - 236,063 - - 399,925'> 461;250 236,100 1;333,338:' 2027 - 239,300 397,175 234,800 871,275 2028 236,800 398,800' 233,300 '868,900` - 2029 - 239,000 399,675 232,875 871,550 -:2030 235;900 - 396,425:: 233,125 !865,450' 2031 - 237,500 395,775 232,800 866,075 2032 238,700 396,325:. 232,325 :867,350- 2033 - 234,600 - - 396,369 - 236,625 867,594 .:2034 395,688E 235,700 '631,388= 2035 - 399,394 234,625 634,019 2036 397,4669 - 233,400 1630,866': 2037 - - - - 394,978 236,950 631,928 :. 2038 _.. - 396,8255 235,275 :'632,100= ........233,450 2039 - _. 233,450 Total $ 247,200 $ 3,355,675 $ 1,108,112 $ 30,525 $ 7,160,069 $ 2,783,625 $ 4,450,875 $ 19,136,081 2021 $ 520,000 $ 662,575 $ 2,426,850 $ 2,230,867 $ 828,137 $ 1,323,800 $ 7,992,229 $ 3,996,115 2022 520;000 665,175 2,434,650 2,229,242 828;137 1,326,825 8,004,029 4,002,015 2023 520,000 665,650 2,435,950 2,226,390 828,137 1,328,600 8,004,727 4,002,364 2024 520,000 663,950 2,436,250 2,227,166 828,137 1,323,475 7,998,978 3,999,489 2025 520,000 666,463 2,435,125 2,226,361 828,137 1,326,850 8,002,935 4,001,468 2026 520,000 3,226,375 2,224,201 828,137 1,323,600 8,122,313 4,061,156: 2027 520,000 2049 3,214,125 2,225,659 828,137 1,323,725 8,111,646 4,055,823 2028 520,000 3,222,250 2,219,166 828;137 1,326,975 8,116,528 4,058,264 2029 520,000 3,220,250 2,220,811 828,137 1,328,225 8,117,423 4,058,711 2030 520;000 3,213,250 2,217,486 828,137 1,327,475 8,106,348 4,053,174'! 2031 2,268,330 1,475,500 2,216,266 828,137 1,324,200 8,112,433 4,056,216 2032 2,272,390 1,478,750 ! 2,217,804 828;137 1,323,700 8,120,781 4,060,390 2033 2,271,250 1,480,500 2,217,790 828,137 1,321,800 8,119,477 4,059,739 2034 2,269;780 1,483,800 2,216,040 828;137 1,323,400 8,121,157 4,060,579 2035 2,272,590 1,479,000 2,216,437 1,128,137 1,323,400 8,419,564 4,209,782 2036 - 3,737,200 2,216,117 1,518,567 1,326,700 8,798,584 4,399,292; 2037 3,741,300 2,219,127 1,920,887 1,328,200 9,209,514 4,604,757 2038 3,750,200 2,217,979 1,921,962 1,323,000 9,213,141 4,606,571' 2039 3,743,900 2,220,580 1,921,653 1,326,000 9,212,133 4,606,067 2040 3,742,400 2,221,791 1,924,960 1,327,000 9,216,151 4,608,076 S 2041 3,740,400 2,221,612 1,921,710 1,326,000 9,209,722 4,604,861 2042 425,300 ? 2,225,043 1,927;076 - 4,577,419 2,288,710 2043 424,600 2,220,642 1,925,084 4,570,326 2,285,163 2044 423,300 2,219,531 1,921,152 4,563,983 2,281,991 2045 2,216,553 1,915,280 4,131,833 2,065,917 2046 2,211,710 1,912;468 4,124,178 2,062,089 2047 1,912,522 1,912,522 956,261' 2048 1,910,063 1,910,063 955,032 2049 1,905,635 1,905,635 952,818 2050 1,904;238 1,904,238 952,119 2051 1,900,693 1,900,693 950,347 Total $I 16,554,340 $ 3,323,813 $ 59,391,225 $ 57,742,367 $ 42,986,005 $ 27,832,950 $ 207,830,699 $ 103,915,350 2021 $ 1,390,975 2022 1388,450 2023 1,390,188 2024 1;388,988 2025 1,388,294 2026 1,392,206 2027 1,390,725 2028 1,388,275 2029 1,393,900 2030 1;392,400 2031 1,393,775 2032 1,388,025 2033 1,390,025 2034 1,389,800 2035 1,387,800 2036 1,389,100 2037 1,388,600 2038 1391,200 2039 1,386,900 2040 1,390, 600 2041 11387,200 2042 2043 2044 2045 - 2046 2047 2048 2049 2050 2051 Total $ 29,187,425 2021 $ 410,950 $ 303,100 $ 714,050 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 'i 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 x 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 Totals $ 9,877,000 $ 7,259,400 $ 17,136,400 Debt Service Schedules Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 325,000 4.070% 52,706.50 377,706.50 08/01/2021 46,092.75 46,092.75 09/30/2021 423,799.25 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,590,000 386,039.50 2,976,039.50 2,976,039.50 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 1 Capital BOND DEBT SERVICE City of Schertz, Texas $8,250,000 General Obligation Bonds, Series 2011 Callable 2/1/2021 at Par Dated Date 03/01/2011 Delivery Date 04/26/2011 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 2 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2021 270,000 5.000% 6,750 276,750 09/30/2021 276,750 270,000 6,750 276,750 276,750 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 2 Capital BOND DEBT SERVICE City of Schertz, Texas $6,745,000 General Obligation Refunding Bonds, Series 2011A Callable 2/1/2021 at Par Dated Date 12/15/2011 Delivery Date 12/15/2011 Period Ending Principal Coupon Annual Interest Debt Service Debt Service 02/01/2021 485,000 2.330% 5,650.25 490,650.25 09/30/2021 490,650.25 485,000 5,650.25 490,650.25 490,650.25 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 3 Capital BOND DEBT SERVICE City of Schertz, Texas $2,675,000 General Obligation Refunding Bonds, Series 2011 Callable 9/1/2019 at Par Dated Date 06/01/2011 Delivery Date 06/30/2011 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 4 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 03/01/2021 3,600 3,600 09/01/2021 240,000 3.000% 3,600 243,600 09/30/2021 247,200 240,000 7,200 247,200 247,200 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 4 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 365,000 3.000% 71,922.50 436,922.50 08/01/2021 66,447.50 66,447.50 09/30/2021 503,370.00 02/01/2022 375,000 2.250% 66,447.50 441,447.50 08/01/2022 62,228.75 62,228.75 09/30/2022 503,676.25 02/01/2023 385,000 2.250% 62,228.75 447,228.75 08/01/2023 57,897.50 57,897.50 09/30/2023 505,126.25 02/01/2024 390,000 2.500% 57,897.50 447,897.50 08/01/2024 53,022.50 53,022.50 09/30/2024 500,920.00 02/01/2025 400,000 2.700% 53,022.50 453,022.50 08/01/2025 47,622.50 47,622.50 09/30/2025 500,645.00 02/01/2026 415,000 2.800% 47,622.50 462,622.50 08/01/2026 41,812.50 41,812.50 09/30/2026 504,435.00 02/01/2027 425,000 3.000% 41,812.50 466,812.50 08/01/2027 35,437.50 35,437.50 09/30/2027 502,250.00 02/01/2028 440,000 3.000% 35,437.50 475,437.50 08/01/2028 28,837.50 28,837.50 09/30/2028 504,275.00 02/01/2029 450,000 3.000% 28,837.50 478,837.50 08/01/2029 22,087.50 22,087.50 09/30/2029 500,925.00 02/01/2030 465,000 3.000% 22,087.50 487,087.50 08/01/2030 15,112.50 15,112.50 09/30/2030 502,200.00 02/01/2031 480,000 3.100% 15,112.50 495,112.50 08/01/2031 7,672.50 7,672.50 09/30/2031 502,785.00 02/01/2032 495,000 3.100% 7,672.50 502,672.50 09/30/2032 502,672.50 5,085,000 948,280.00 6,033,280.00 6,033,280.00 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 5 Capital 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 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 415,000 3.000% 48,875.00 463,875.00 08/01/2021 42,650.00 42,650.00 09/30/2021 506,525.00 02/01/2022 155,000 3.000% 42,650.00 197,650.00 08/01/2022 40,325.00 40,325.00 09/30/2022 237,975.00 02/01/2023 160,000 3.000% 40,325.00 200,325.00 08/01/2023 37,925.00 37,925.00 09/30/2023 238,250.00 02/01/2024 165,000 3.500% 37,925.00 202,925.00 08/01/2024 35,037.50 35,037.50 09/30/2024 237,962.50 02/01/2025 170,000 3.500% 35,037.50 205,037.50 08/01/2025 32,062.50 32,062.50 09/30/2025 237,100.00 02/01/2026 175,000 3.500% 32,062.50 207,062.50 08/01/2026 29,000.00 29,000.00 09/30/2026 236,062.50 02/01/2027 185,000 4.000% 29,000.00 214,000.00 08/01/2027 25,300.00 25,300.00 09/30/2027 239,300.00 02/01/2028 190,000 4.000% 25,300.00 215,300.00 08/01/2028 21,500.00 21,500.00 09/30/2028 236,800.00 02/01/2029 200,000 4.000% 21,500.00 221,500.00 08/01/2029 17,500.00 17,500.00 09/30/2029 239,000.00 02/01/2030 205,000 4.000% 17,500.00 222,500.00 08/01/2030 13,400.00 13,400.00 09/30/2030 235,900.00 02/01/2031 215,000 4.000% 13,400.00 228,400.00 08/01/2031 9,100.00 9,100.00 09/30/2031 237,500.00 02/01/2032 225,000 4.000% 9,100.00 234,100.00 08/01/2032 4,600.00 4,600.00 09/30/2032 238,700.00 02/01/2033 230,000 4.000% 4,600.00 234,600.00 09/30/2033 234,600.00 2,690,000 665,675.00 3,355,675.00 3,355,675.00 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 6 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 200,000 2.580% 13,416.00 213,416.00 08/01/2021 10,836.00 10,836.00 09/30/2021 224,252.00 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 1,040,000 68,112.00 1,108,112.00 1,108,112.00 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 7 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 100,000 3.000% 141,137.50 241,137.50 08/01/2021 139,637.50 139,637.50 09/30/2021 380,775.00 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,900,000 1,658,612.50 9,558,612.50 9,558,612.50 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 8 Capital BOND DEBT SERVICE City of Schertz, Texas $2,125,000 Tax Notes, Series 2015 Non Callable Dated Date 01/08/2015 Delivery Date 01/08/2015 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 9 Annual Period Debt Ending Principal Coupon Interest Debt Service Service 02/01/2021 1,662.50 1,662.50 08/01/2021 190,000 1.750% 1,662.50 191,662.50 09/30/2021 193,325 190,000 3,325.00 193,325.00 193,325 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 9 Capital DETAILED BOND DEBT SERVICE City of Schertz, Texas $2,125,000 Tax Notes, Series 2015 Non Callable Dated Date 01/08/2015 Delivery Date 01/08/2015 Drainage Equipment (CIB2) Period Ending Principal Coupon Interest Annual Debt Debt Service Service 02/01/2021 1,050 1,050 08/01/2021 120,000 1.750% 1,050 121,050 09/30/2021 122,100 120,000 2,100 122,100 122,100 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 10 Capital DETAILED BOND DEBT SERVICE City of Schertz, Texas $2,125,000 Tax Notes, Series 2015 Non Callable Dated Date 01/08/2015 Delivery Date 01/08/2015 Water Equipment (CIB3) Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 11 Annual Period Debt Ending Principal Coupon Interest Debt Service Service 02/01/2021 262.50 262.50 08/01/2021 30,000 1.750% 262.50 30,262.50 09/30/2021 30,525 30,000 525.00 30,525.00 30,525 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 11 Capital DETAILED BOND DEBT SERVICE City of Schertz, Texas $2,125,000 Tax Notes, Series 2015 Non Callable Dated Date 01/08/2015 Delivery Date 01/08/2015 General Fund Equipment (CI64) Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 12 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2021 350 350 08/01/2021 40,000 1.750% 350 40,350 09/30/2021 40,700 40,000 700 40,700 40,700 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 12 Capital 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 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 2,348.50 2,348.50 08/01/2021 150,000 1.540% 2,348.50 152,348.50 09/30/2021 154,697 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 305,000 7,084.00 312,084.00 312,084 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 13 Capital 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 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 690,000 3.000% 28,875 718,875 08/01/2021 18,525 18,525 09/30/2021 737,400 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,830,000 399,375 2,229,375 2,229,375 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 14 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 235,000 4.000% 72,953.13 307,953.13 08/01/2021 68,253.13 68,253.13 09/30/2021 376,206.26 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 15 Capital Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 16 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 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,830,000 1,167,578.21 5,997,578.21 5,997,578.21 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 16 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 190,000 4.000% 25,984.38 215,984.38 08/01/2021 22,184.38 22,184.38 09/30/2021 238,168.76 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 17 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 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,685,000 319,046.98 2,004,046.98 2,004,046.98 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 18 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 60,000 3.000% 21,481.25 81,481.25 08/01/2021 20,581.25 20,581.25 09/30/2021 102,062.50 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 19 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 Period Ending Annual Principal Coupon Interest Debt Service Debt Service 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,250,000 391,406.25 1,641,406.25 1,641,406.25 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 20 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 405,000 3.000% 66,437.50 471,437.50 08/01/2021 60,362.50 60,362.50 09/30/2021 531,800.00 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 21 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 4,345,000 1,064,350.00 5,409,350.00 5,409,350.00 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 22 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 160,000 3.000% 53,662.50 213,662.50 08/01/2021 51,262.50 51,262.50 09/30/2021 264,925.00 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 23 Capital Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 24 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,495,000 1,004,350.00 4,499,350.00 4,499,350.00 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 24 Capital 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 25 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2021 570,000 2.120% 52,205 622,205 08/01/2021 46,163 46,163 09/30/2021 668,368 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,925,000 428,929 5,353,929 5,353,929 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 25 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 430,000 5.000% 195,843.75 625,843.75 08/01/2021 185,093.75 185,093.75 09/30/2021 810,937.50 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 26 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/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 9,650,000 3,432,631.25 13,082,631.25 13,082,631.25 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 27 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 235,000 5.000% 90,881.25 325,881.25 08/01/2021 85,006.25 85,006.25 09/30/2021 410,887.50 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 28 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 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 02/01/2037 285,000 3375% 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,415,000 1,507,562.51 5,922,562.51 5,922,562.51 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 29 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 195,000 5.000% 104,962.50 299,962.50 08/01/2021 100,087.50 100,087.50 09/30/2021 400,050.00 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 30 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 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 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,235,000 1,925,068.76 7,160,068.76 7,160,068.76 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 31 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 880,000 5.000% 166,596.88 1,046,596.88 08/01/2021 144,596.88 144,596.88 09/30/2021 1,191,193.76 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 7,560,000 1,839,696.98 9,399,696.98 9,399,696.98 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 32 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 530,000 5.000% 106,471.88 636,471.88 08/01/2021 93,221.88 93,221.88 09/30/2021 729,693.76 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 5,155,000 1,461,071.98 6,616,071.98 6,616,071.98 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 33 Capital 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) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 350,000 5.000% 60,125 410,125 08/01/2021 51,375 51,375 09/30/2021 461,500 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,405,000 378,625 2,783,625 2,783,625 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 34 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 385,000 3.000% 117,687.50 502,687.50 08/01/2021 111,912.50 111,912.50 09/30/2021 614,600.00 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 35 Capital 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/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 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 7,120,000 2,124,337.50 9,244,337.50 9,244,337.50 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 36 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 105,000 3.000% 45,162.50 150,162.50 08/01/2021 43,587.50 43,587.50 09/30/2021 193,750.00 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 37 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 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 02/01/2037 180,000 1000% 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,785,000 908,162.50 3,693,162.50 3,693,162.50 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 38 Capital 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) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 150,000 3.000% 18,100 168,100 08/01/2021 15,850 15,850 09/30/2021 183,950 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 980,000 120,300 1,100,300 1,100,300 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 39 Capital 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) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 130,000 3.000% 54,425 184,425 08/01/2021 52,475 52,475 09/30/2021 236,900 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 40 Capital 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) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 09/30/2035 234,625 02/01/2036 210,000 3.000% 13,275 223,275 08/01/2036 10,125 10,125 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,355,000 1,095,875 4,450,875 4,450,875 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 41 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 08/01/2021 164,026.67 164,026.67 09/30/2021 164,026.67 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 42 Capital Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 43 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 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,246,270.42 8,801,270.42 8,801,270.42 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 43 Capital 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 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 260,000 260,000 08/01/2021 260,000 260,000 09/30/2021 520,000 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,554,340 16,554,340 16,554,340 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 44 Capital 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 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 570,000 3.000% 50,562.50 620,562.50 08/01/2021 42,012.50 42,012.50 09/30/2021 662,575.00 02/01/2022 590,000 3.000% 42,012.50 632,012.50 08/01/2022 33,162.50 33,162.50 09/30/2022 665,175.00 02/01/2023 610,000 3.500% 33,162.50 643,162.50 08/01/2023 22,487.50 22,487.50 09/30/2023 665,650.00 02/01/2024 630,000 3.500% 22,487.50 652,487.50 08/01/2024 11,462.50 11,462.50 09/30/2024 663,950.00 02/01/2025 655,000 3.500% 11,462.50 666,462.50 09/30/2025 666,462.50 3,055,000 268,812.50 3,323,812.50 3,323,812.50 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 45 Capital 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 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 785,000 4.000% 828,775 1,613,775 08/01/2021 813,075 813,075 09/30/2021 2,426,850 02/01/2022 825,000 4.000% 813,075 1,638,075 08/01/2022 796,575 796,575 09/30/2022 2,434,650 02/01/2023 860,000 4.000% 796,575 1,656,575 08/01/2023 779,375 779,375 09/30/2023 2,435,950 02/01/2024 900,000 5.000% 779,375 1,679,375 08/01/2024 756,875 756,875 09/30/2024 2,436,250 02/01/2025 945,000 5.000% 756,875 1,701,875 08/01/2025 733,250 733,250 09/30/2025 2,435,125 02/01/2026 1,805,000 5.000% 733,250 2,538,250 08/01/2026 688,125 688,125 09/30/2026 3,226,375 02/01/2027 1,885,000 5.000% 688,125 2,573,125 08/01/2027 641,000 641,000 09/30/2027 3,214,125 02/01/2028 1,990,000 5.000% 641,000 2,631,000 08/01/2028 591,250 591,250 09/30/2028 3,222,250 02/01/2029 2,090,000 5.000% 591,250 2,681,250 08/01/2029 539,000 539,000 09/30/2029 3,220,250 02/01/2030 2,190,000 5.000% 539,000 2,729,000 08/01/2030 484,250 484,250 09/30/2030 3,213,250 02/01/2031 520,000 5.000% 484,250 1,004,250 08/01/2031 471,250 471,250 09/30/2031 1,475,500 02/01/2032 550,000 5.000% 471,250 1,021,250 08/01/2032 457,500 457,500 09/30/2032 1,478,750 02/01/2033 580,000 5.000% 457,500 1,037,500 08/01/2033 443,000 443,000 09/30/2033 1,480,500 02/01/2034 610,000 4.000% 443,000 1,053,000 08/01/2034 430,800 430,800 09/30/2034 1,483,800 02/01/2035 630,000 4.000% 430,800 1,060,800 08/01/2035 418,200 418,200 09/30/2035 1,479,000 02/01/2036 2,960,000 4.000% 418,200 3,378,200 08/01/2036 359,000 359,000 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 46 Capital 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 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 09/30/2036 3,737,200 02/01/2037 3,085,000 4.000% 359,000 3,444,000 08/01/2037 297,300 297,300 09/30/2037 3,741,300 02/01/2038 3,220,000 4.000% 297,300 3,517,300 08/01/2038 232,900 232,900 09/30/2038 3,750,200 02/01/2039 3,345,000 4.000% 232,900 3,577,900 08/01/2039 166,000 166,000 09/30/2039 3,743,900 02/01/2040 3,480,000 4.000% 166,000 3,646,000 08/01/2040 96,400 96,400 09/30/2040 3,742,400 02/01/2041 3,620,000 4.000% 96,400 3,716,400 08/01/2041 24,000 24,000 09/30/2041 3,740,400 02/01/2042 385,000 4.000% 24,000 409,000 08/01/2042 16,300 16,300 09/30/2042 425,300 02/01/2043 400,000 4.000% 16,300 416,300 08/01/2043 8,300 8,300 09/30/2043 424,600 02/01/2044 415,000 4.000% 8,300 423,300 09/30/2044 423,300 38,075,000 21,316,225 59,391,225 59,391,225 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 47 Capital 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 490,433.50 490,433.50 08/01/2021 1,250,000 0.930% 490,433.50 1,740,433.50 09/30/2021 2,230,867.00 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 48 Capital 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/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 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 41,170,000 16,572,366.50 57,742,366.50 57,742,366.50 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \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 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 414,068.50 414,068.50 08/01/2021 414,068.50 414,068.50 09/30/2021 828,137 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 50 Capital BOND DEBT SERVICE $22,830,000 SWIFT Funding Board Participation Loan, Series 2016 Schertz /Seguin Local Government Corp. Non - Callable Period Ending Principal Coupon Interest Debt Service Annual Debt Service 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 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 20,156,005.00 42,986,005.00 42,986,005 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 51 Capital 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 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2021 540,000 5.000% 398,650 938,650 08/01/2021 385,150 385,150 09/30/2021 1,323,800 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 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 52 Capital BOND DEBT SERVICE $19,045,000 Contract Revenue Refunding Bonds, Series 2018 Schertz /Seguin Local Government Corp. Callable at Par on 2/1/2027 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 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 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 18,530,000 9,302,950 27,832,950 27,832,950 Nov 6, 2020 1:01 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 53