Loading...
Debt Model Report Sept 30, 2020 Updated Aug 1, 2019City of Schertz, Texas R1- 1U, 170- For Fiscal Year Ending September 30, 2020 Updated: August 1, 2019 Presented by: SAMCO Capital Markets, Inc. Mark McLiney Andrew Friedman (210) 832-9760 M -• We 2020 $ 426,823 $ 568,888 $ 538,551 $ 504,170 $ 383,775 $ 36,313 $ 157,007 $ 741,188 $ 375,406 $ 235,569 $ 103,863 $ 538,875 $ 264,650 $ 670,346 $ 407,263 $ 807,444 $ 380,275 $ 7,140,403 2021 423,799 x7566,938 537,367 is 503,370 380,775 40,700 154,697 737,400 376,206 r. 238,169 102,063 531;800 264,925 668,368 410,888 729,694 377,700 7,044,857:: 2022 425,267 567,350 708,911 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 6,756,210 2023 426,123 566,263 698,242: 505,126 1;020,150 - 37,050 376,606 237,469 : 103,388 418,400 365,025 '- 668,617 411,263 377,069 1381,800 -. 6,492,590'- 2024 426,370 566,713 667,689 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 6,342,104 2025 426,005 :' 568,606 399,675 500,645 1;021,000 - _. 37;050 375,406 ':: 100,144 104,413 271;150 264,525 672,753 409,138 383;569 372,875 ; 5,507,278 2026 425,031 569,469 - 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 5,395,600 2027 : 423,445 569,263 502,250 1,018,575 - 37;050 375,556 : 100,969 ! 104,950 269;750 263,425 :. 665,829 : 297,888 383;694 - 197,175 5,209,818 2028 567,950 - 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 5,076,577 2029 565,494 500,925 1,014,375 37;050 373,366 97,719 104,613 267,750 266,650 297,388 579;494 397,063 4,301,884' 2030 - 566,738 - 502,200 1,022,588 - - 37,050 371,638 100,913 101,813 271,450 265,425 - 297,513 579,294 193,075 4,309,694 2031 'r 566,250 - 502,785 - @ 1,158;525 374,350 ! 98,947 1 103,925 269,925 264,050 299,488 580,634 :193,650 '. 4,412,529:: 2032 569,125 502,673 - 376,425 101,869 100,844 268,250 267,450 297,363 583,256 194,075 3,261,329 2033 - r 565,875 - 372,275 99,675 ( 102,563: 271,350 '265,625 299,856 579,619 P194,350 :. 2,751,188: 2034 566,500 - - - - 372,075 97,200 104,094 268,925 263,356 - 296,806 194,475 2,163,431 2035 'i 565,875 - 376,500 99,425 100,5311 270,963 :265,556 298,356 '194,450 S 2,171,656= 2036 568,875 - - 375,550 101,500 101,875 267,756 262,513 299,409 194,275 2,171,753 2037 - s - - 269;306 264,225 299,959 :193,950 .....:193,475 1,027,441 2038..... _ 295,075 488,550.. 2039 : 192,850 192,850:1 Total $ 3,402,863 $ 9,646,169 $ 3,150,759 $ 6,537,450 $ 9,942,388 $ 77,013 $ 469,091 $ 2,970,563 $ 6,372,984 $ 2,239,616 $ 1,745,269 $ 5,948,225 $ 4,764,000 $ 6,024,275 $ 6,329,825 $ 7,423,516 $ 5,173,738 $ 82,217,741 2020 $ 248,663 $ 507,813 $ 219,283 $ 25,963 $ 399,550 $ 463,625 $ 235,725 $ 2,100,621 2020 $ 124,200 2021 247,200 506,525 224,252: 30,525 400,050 461,500 236,900 2,106,952? 2021 395,688 - 122,100 2022 - 237,975 224,028 - 400,050 463,500 233,000 1,558,553 Total $ 246,300 2023 - '' 238,250 218,739- (399,550 ': 464,500 : 234,025 1,555,064 233,450 233,490- 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.:'. -'.a 2026 236,063 - 399,925 461,250 236,100 1,333,338 • a. 2027 - 239,300 397,175 234,800 871,275- 2020 167;888 2028 236,800 - 398,800 233,300 868,900 2021 - 2029 239,000 399,675 232,875 871,550' Total $ 167,888 2030 - 235,900 - - 396,425 - 233,125 865,450 2031 =.237,500 395,775 232,800 866,075'1. 2032 238,700 - 396,325 232,325 867,350 2033 € 234,600 :396,369 236,625 867,594 2034 - 395,688 - 235,700 631,388 2035 : 399,394 234,625. 634;019:: 2036 - - - - 397,466 - 233,400 630,866 2037 394,978 236,950 631,928': 2038 - 396,825 235,275 632,100 2039 : 233,450 233,490- Total $ 495,863 $ 3,863,488 $ 1,327,395 $ 56,488 $ 7,559,619 $ 3,247,250 $ 4,686,600 $ 21,236,701 2020 $ 520,000 $ 664,450 $ 2,444,175 $ 2,231,531 $ 828,137 $ 1,325,175 $ 8,013,468 $ 4,006,734 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 3,214,125 2,225,659 828,137 1,323,725 8,111,646 4,055,823 2028 520,000 2048 3,222,250 2,219,166 828,137 1,326,975 8,116,528 4,058,264 2029 520,000 $ 33,232,213 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,271250 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 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 $ 17,074,340 $ 3,988,263 $ 61,835,400 $ 59,973,898 $ 43,814,142 $ 29,158,125 $ 215,844,167 $ 107,922,084 2020 $ 1,510,188 2021 1,512,788 2022 1,509,288 2023 1,509,688 2024 1,508,888 2025 1,510,963 2026 1,511,138 2027 1,510,022 2028 1,510,284 2029 1,512,206 2030 1,512,859 2031 1,512,244 2032 1,510,359 2033 1,510,100 2034 1,511,200 2035 1,510,500 2036 11508,000 2037 1508,600 2038 1:512,100 2039 1,508,500 2040 1,512,700 2041 1,509,600 2042 - 2043 2044 2045 2046 2047 2048 2049 2050 2051 - Total $ 33,232,213 2019 $ 412,250 $ 165,125 $ 577,375 2020 414,150 302,850 i 717,000 2021 410,950 303,100 714,050 2022 412,750 303,100 ? 715,850 2023 412,800 302,850 715,650 20241 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 $ 10,703,400 $ 7,727,375 $ 18,430,775 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/2020 315,000 4.070% 59,116.75 374,116.75 08/01/2020 52,706.50 52,706.50 09/30/2020 426,823.25 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,905,000 497,862.75 3,402,862.75 3,402,862.75 Aug 1, 2019 2:54 pm Prepared by ATF (y: \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 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2020 260,000 4.000% 157,043.75 417,043.75 08/01/2020 151,843.75 151,843.75 09/30/2020 568,887.50 02/01/2021 270,000 5.000% 151,843.75 421,843.75 08/01/2021 145,093.75 145,093.75 09/30/2021 566,937.50 02/01/2022 285,000 5.500% 145,093.75 430,093.75 08/01/2022 137,256.25 137,256.25 09/30/2022 567,350.00 02/01/2023 300,000 5.500% 137,256.25 437,256.25 08/01/2023 129,006.25 129,006.25 09/30/2023 566,262.50 02/01/2024 315,000 4.000% 129,006.25 444,006.25 08/01/2024 122,706.25 122,706.25 09/30/2024 566,712.50 02/01/2025 330,000 4.125% 122,706.25 452,706.25 08/01/2025 115,900.00 115,900.00 09/30/2025 568,606.25 02/01/2026 345,000 4.250% 115,900.00 460,900.00 08/01/2026 108,568.75 108,568.75 09/30/2026 569,468.75 02/01/2027 360,000 4.375% 108,568.75 468,568.75 08/01/2027 100,693.75 100,693.75 09/30/2027 569,262.50 02/01/2028 375,000 4.500% 100,693.75 475,693.75 08/01/2028 92,256.25 92,256.25 09/30/2028 567,950.00 02/01/2029 390,000 4.625% 92,256.25 482,256.25 08/01/2029 83,237.50 83,237.50 09/30/2029 565,493.75 02/01/2030 410,000 4.750% 83,237.50 493,237.50 08/01/2030 73,500.00 73,500.00 09/30/2030 566,737.50 02/01/2031 430,000 5.000% 73,500.00 503,500.00 08/01/2031 62,750.00 62,750.00 09/30/2031 566,250.00 02/01/2032 455,000 5.000% 62,750.00 517,750.00 08/01/2032 51,375.00 51,375.00 09/30/2032 569,125.00 02/01/2033 475,000 5.000% 51,375.00 526,375.00 08/01/2033 39,500.00 39,500.00 09/30/2033 565,875.00 02/01/2034 500,000 5.000% 39,500.00 539,500.00 08/01/2034 27,000.00 27,000.00 09/30/2034 566,500.00 02/01/2035 525,000 5.000% 27,000.00 552,000.00 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 2 Capital Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 3 BOND DEBT SERVICE City of Schertz, Texas $8,250,000 General Obligation Bonds, Series 2011 Callable 2/1/2021 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2035 13,875.00 13,875.00 09/30/2035 565,875.00 02/01/2036 555,000 5.000% 13,875.00 568,875.00 09/30/2036 568,875.00 6,580,000 3,066,168.75 9,646,168.75 9,646,168.75 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 3 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 Interest Debt Service Annual Debt Service 02/01/2020 475,000 2.330% 34,542.25 509,542.25 08/01/2020 29,008.50 29,008.50 09/30/2020 538,550.75 02/01/2021 485,000 2.330% 29,008.50 514,008.50 08/01/2021 23,358.25 23,358.25 09/30/2021 537,366.75 02/01/2022 670,000 2.330% 23,358.25 693,358.25 08/01/2022 15,552.75 15,552.75 09/30/2022 708,911.00 02/01/2023 675,000 2.330% 15,552.75 690,552.75 08/01/2023 7,689.00 7,689.00 09/30/2023 698,241.75 02/01/2024 660,000 2.330% 7,689.00 667,689.00 09/30/2024 667,689.00 2,965,000 185,759.25 3,150,759.25 3,150,759.25 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 4 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 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 03/01/2020 6,831.25 6,831.25 09/01/2020 235,000 2.750% 6,831.25 241,831.25 09/30/2020 248,662.50 03/01/2021 3,600.00 3,600.00 09/01/2021 240,000 3.000% 3,600.00 243,600.00 09/30/2021 247,200.00 475,000 20,862.50 495,862.50 495,862.50 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 5 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/2020 355,000 3.000% 77,247.50 432,247.50 08/01/2020 71,922.50 71,922.50 09/30/2020 504,170.00 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,440,000 1,097,450.00 6,537,450.00 6,537,450.00 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 6 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/2020 405,000 2.500% 53,937.50 458,937.50 08/01/2020 48,875.00 48,875.00 09/30/2020 507,812.50 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 3,095,000 768,487.50 3,863,487.50 3,863,487.50 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 7 Capital DETAILED 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 General Obligation Portion (CI61) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2020 260,000 2.500% 7,225 267,225 08/01/2020 3,975 3,975 09/30/2020 271,200 02/01/2021 265,000 3.000% 3,975 268,975 09/30/2021 268,975 525,000 15,175 540,175 540,175 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 8 Capital DETAILED 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 Utility Fund Portion (CI62) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2020 145,000 2.500% 46,712.50 191,712.50 08/01/2020 44,900.00 44,900.00 09/30/2020 236,612.50 02/01/2021 150,000 3.000% 44,900.00 194,900.00 08/01/2021 42,650.00 42,650.00 09/30/2021 237,550.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,570,000 753,312.50 3,323,312.50 3,323,312.50 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 9 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/2020 190,000 2.580% 15,867.00 205,867.00 08/01/2020 13,416.00 13,416.00 09/30/2020 219,283.00 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,230,000 97,395.00 1,327,395.00 1,327,395.00 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 10 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/2020 100,000 3.000% 142,637.50 242,637.50 08/01/2020 141,137.50 141,137.50 09/30/2020 383,775.00 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 8,000,000 1,942,387.50 9,942,387.50 9,942,387.50 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 11 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 Period Ending Principal Coupon Annual Interest Debt Service Debt Service 02/01/2020 4,681.25 4,681.25 08/01/2020 345,000 1.750% 4,681.25 349,681.25 09/30/2020 354,362.50 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.00 535,000 12,687.50 547,687.50 547,687.50 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 12 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 EMS 6 Years (CI61) Period Ending Principal Coupon Annual Interest Debt Service Debt Service 02/01/2020 1,443.75 1,443.75 08/01/2020 165,000 1.750% 1,443.75 166,443.75 09/30/2020 167,887.50 165,000 2,887.50 167,887.50 167,887.50 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 13 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) 240,000 6,300 246,300 246,300 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 14 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2020 2,100 2,100 08/01/2020 120,000 1.750% 2,100 122,100 09/30/2020 124,200 02/01/2021 1,050 1,050 08/01/2021 120,000 1.750% 1,050 121,050 09/30/2021 122,100 240,000 6,300 246,300 246,300 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 14 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 EMS 6 Years (CI61) Period Ending Principal Coupon Annual Interest Debt Service Debt Service 02/01/2020 1,443.75 1,443.75 08/01/2020 165,000 1.750% 1,443.75 166,443.75 09/30/2020 167,887.50 165,000 2,887.50 167,887.50 167,887.50 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 15 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) 240,000 6,300 246,300 246,300 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 16 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2020 2,100 2,100 08/01/2020 120,000 1.750% 2,100 122,100 09/30/2020 124,200 02/01/2021 1,050 1,050 08/01/2021 120,000 1.750% 1,050 121,050 09/30/2021 122,100 240,000 6,300 246,300 246,300 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 16 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) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2020 481.25 481.25 08/01/2020 25,000 1.750% 481.25 25,481.25 09/30/2020 25,962.50 02/01/2021 262.50 262.50 08/01/2021 30,000 1.750% 262.50 30,262.50 09/30/2021 30,525.00 55,000 1,487.50 56,487.50 56,487.50 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 17 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) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2020 481.25 481.25 08/01/2020 25,000 1.750% 481.25 25,481.25 09/30/2020 25,962.50 02/01/2021 262.50 262.50 08/01/2021 30,000 1.750% 262.50 30,262.50 09/30/2021 30,525.00 55,000 1,487.50 56,487.50 56,487.50 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 18 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) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2020 656.25 656.25 08/01/2020 35,000 1.750% 656.25 35,656.25 09/30/2020 36,312.50 02/01/2021 350.00 350.00 08/01/2021 40,000 1.750% 350.00 40,350.00 09/30/2021 40,700.00 75,000 2,012.50 77,012.50 77,012.50 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 19 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/2020 3,503.50 3,503.50 08/01/2020 150,000 1.540% 3,503.50 153,503.50 09/30/2020 157,007 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 455,000 14,091.00 469,091.00 469,091 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 20 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/2020 675,000 2.500% 37,312.50 712,312.50 08/01/2020 28,875.00 28,875.00 09/30/2020 741,187.50 02/01/2021 690,000 3.000% 28,875.00 718,875.00 08/01/2021 18,525.00 18,525.00 09/30/2021 737,400.00 02/01/2022 18,525.00 18,525.00 08/01/2022 18,525.00 18,525.00 09/30/2022 37,050.00 02/01/2023 18,525.00 18,525.00 08/01/2023 18,525.00 18,525.00 09/30/2023 37,050.00 02/01/2024 18,525.00 18,525.00 08/01/2024 18,525.00 18,525.00 09/30/2024 37,050.00 02/01/2025 18,525.00 18,525.00 08/01/2025 18,525.00 18,525.00 09/30/2025 37,050.00 02/01/2026 18,525.00 18,525.00 08/01/2026 18,525.00 18,525.00 09/30/2026 37,050.00 02/01/2027 18,525.00 18,525.00 08/01/2027 18,525.00 18,525.00 09/30/2027 37,050.00 02/01/2028 18,525.00 18,525.00 08/01/2028 18,525.00 18,525.00 09/30/2028 37,050.00 02/01/2029 18,525.00 18,525.00 08/01/2029 18,525.00 18,525.00 09/30/2029 37,050.00 02/01/2030 18,525.00 18,525.00 08/01/2030 18,525.00 18,525.00 09/30/2030 37,050.00 02/01/2031 1,140,000 3.250% 18,525.00 1,158,525.00 09/30/2031 1,158,525.00 2,505,000 465,562.50 2,970,562.50 2,970,562.50 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 21 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/2020 225,000 4.000% 77,453.13 302,453.13 08/01/2020 72,953.13 72,953.13 09/30/2020 375,406.26 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 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 22 Capital Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 23 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 5,055,000 1,317,984.47 6,372,984.47 6,372,984.47 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 23 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/2020 180,000 4.000% 29,584.38 209,584.38 08/01/2020 25,984.38 25,984.38 09/30/2020 235,568.76 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 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 24 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,865,000 374,615.74 2,239,615.74 2,239,615.74 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 25 Capital DETAILED 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 Remodel Component (REMODEL) Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 26 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2020 120,000 4.000% 10,200 130,200 08/01/2020 7,800 7,800 09/30/2020 138,000 02/01/2021 125,000 4.000% 7,800 132,800 08/01/2021 5,300 5,300 09/30/2021 138,100 02/01/2022 130,000 4.000% 5,300 135,300 08/01/2022 2,700 2,700 09/30/2022 138,000 02/01/2023 135,000 4.000% 2,700 137,700 09/30/2023 137,700 510,000 41,800 551,800 551,800 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 26 Capital DETAILED 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 Road Work Component (ROAD) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2020 60,000 4.000% 19,384.38 79,384.38 08/01/2020 18,184.38 18,184.38 09/30/2020 97,568.76 02/01/2021 65,000 4.000% 18,184.38 83,184.38 08/01/2021 16,884.38 16,884.38 09/30/2021 100,068.76 02/01/2022 65,000 4.000% 16,884.38 81,884.38 08/01/2022 15,584.38 15,584.38 09/30/2022 97,468.76 02/01/2023 70,000 4.000% 15,584.38 85,584.38 08/01/2023 14,184.38 14,184.38 09/30/2023 99,768.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 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 27 Capital DETAILED 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 Road Work Component (ROAD) Period Ending Principal Coupon Annual Interest Debt Service Debt Service 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 1000% 1,500.00 101,500.00 09/30/2036 101,500.00 1,355,000 332,815.74 1,687,815.74 1,687,815.74 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 28 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/2020 60,000 3.000% 22,381.25 82,381.25 08/01/2020 21,481.25 21,481.25 09/30/2020 103,862.50 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 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 29 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,310,000 435,268.75 1,745,268.75 1,745,268.75 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 30 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/2020 400,000 3.000% 72,437.50 472,437.50 08/01/2020 66,437.50 66,437.50 09/30/2020 538,875.00 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 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 31 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/2036 255,000 3.250% 8,450.00 263,450.00 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,745,000 1,203,225.00 5,948,225.00 5,948,225.00 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 32 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/2020 155,000 3.000% 55,987.50 210,987.50 08/01/2020 53,662.50 53,662.50 09/30/2020 264,650.00 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 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 33 Capital Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 34 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/2036 250,000 3.250% 8,287.50 258,287.50 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,650,000 1,114,000.00 4,764,000.00 4,764,000.00 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 34 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 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2020 560,000 2.120% 58,141 618,141 08/01/2020 52,205 52,205 09/30/2020 670,346 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 5,485,000 539,275 6,024,275 6,024,275 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 35 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/2020 405,000 5.000% 205,968.75 610,968.75 08/01/2020 195,843.75 195,843.75 09/30/2020 806,812.50 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 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 36 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 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2036 640,000 3.375% 33,837.50 673,837.50 08/01/2036 23,037.50 23,037.50 09/30/2036 696,875.00 02/01/2037 660,000 3.375% 23,037.50 683,037.50 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 10,055,000 3,834,443.75 13,889,443.75 13,889,443.75 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 37 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/2020 220,000 5.000% 96,381.25 316,381.25 08/01/2020 90,881.25 90,881.25 09/30/2020 407,262.50 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 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 38 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/2035 265,000 3.250% 18,831.25 283,831.25 08/01/2035 14,525.00 14,525.00 09/30/2035 298,356.25 02/01/2036 275,000 3.375% 14,525.00 289,525.00 08/01/2036 9,884.38 9,884.38 09/30/2036 299,409.38 02/01/2037 285,000 3.375% 9,884.38 294,884.38 08/01/2037 5,075.00 5,075.00 09/30/2037 299,959.38 02/01/2038 290,000 3.500% 5,075.00 295,075.00 09/30/2038 295,075.00 4,635,000 1,694,825.01 6,329,825.01 6,329,825.01 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 39 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/2020 185,000 5.000% 109,587.50 294,587.50 08/01/2020 104,962.50 104,962.50 09/30/2020 399,550.00 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 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 40 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/2035 355,000 3.250% 25,081.25 380,081.25 08/01/2035 19,312.50 19,312.50 09/30/2035 399,393.75 02/01/2036 365,000 3.375% 19,312.50 384,312.50 08/01/2036 13,153.13 13,153.13 09/30/2036 397,465.63 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,420,000 2,139,618.76 7,559,618.76 7,559,618.76 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 41 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/2020 915,000 5.000% 189,471.88 1,104,471.88 08/01/2020 166,596.88 166,596.88 09/30/2020 1,271,068.76 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 8,475,000 2,195,765.74 10,670,765.74 10,670,765.74 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 42 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/2020 580,000 5.000% 120,971.88 700,971.88 08/01/2020 106,471.88 106,471.88 09/30/2020 807,443.76 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,735,000 1,688,515.74 7,423,515.74 7,423,515.74 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 43 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) Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 44 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2020 335,000 5.000% 68,500 403,500 08/01/2020 60,125 60,125 09/30/2020 463,625 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,740,000 507,250 3,247,250 3,247,250 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 44 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/2020 375,000 3.000% 123,312.50 498,312.50 08/01/2020 117,687.50 117,687.50 09/30/2020 616,000.00 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 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 45 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 Ending Principal Coupon Interest Debt Service Annual Debt Service 09/30/2035 429,075.00 02/01/2036 385,000 3.000% 24,225.00 409,225.00 08/01/2036 18,450.00 18,450.00 09/30/2036 427,675.00 02/01/2037 400,000 3.000% 18,450.00 418,450.00 08/01/2037 12,450.00 12,450.00 09/30/2037 430,900.00 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,495,000 2,365,337.50 9,860,337.50 9,860,337.50 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 46 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/2020 375,000 3.000% 123,312.50 498,312.50 08/01/2020 117,687.50 117,687.50 09/30/2020 616,000.00 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 Aug 1, 2019 3:13 pm Prepared by ATF ( y: \dbc \Schertz:SCHERTZ- 2019_GF) Page 47 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/2036 385,000 3.000% 24,225.00 409,225.00 08/01/2036 18,450.00 18,450.00 09/30/2036 427,675.00 02/01/2037 400,000 3.000% 18,450.00 418,450.00 08/01/2037 12,450.00 12,450.00 09/30/2037 430,900.00 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,495,000 2,365,337.50 9,860,337.50 9,860,337.50 Aug 1, 2019 3:13 pm Prepared by ATF ( y: \dbc \Schertz:SCHERTZ- 2019_GF) Page 48 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/2020 105,000 3.000% 46,737.50 151,737.50 08/01/2020 45,162.50 45,162.50 09/30/2020 196,900.00 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 Aug 1, 2019 3:13 pm Prepared by ATF ( y: \dbc \Schertz:SCHERTZ- 2019_GF) Page 49 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/2035 170,000 3.000% 13,500.00 183,500.00 08/01/2035 10,950.00 10,950.00 09/30/2035 194,450.00 02/01/2036 175,000 1000% 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 3.000% 8,325.00 188,325.00 08/01/2037 5,625.00 5,625.00 09/30/2037 193,950.00 02/01/2038 185,000 3.000% 5,625.00 190,625.00 08/01/2038 2,850.00 2,850.00 09/30/2038 193,475.00 02/01/2039 190,000 3.000% 2,850.00 192,850.00 09/30/2039 192,850.00 2,890,000 1,000,062.50 3,890,062.50 3,890,062.50 Aug 1, 2019 3:13 pm Prepared by ATF ( y: \dbc \Schertz:SCHERTZ- 2019_GF) Page 50 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) Aug 1, 2019 3:13 pm Prepared by ATF ( y: \dbc \Schertz:SCHERTZ- 2019_GF) Page 51 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2020 145,000 3.000% 20,275 165,275 08/01/2020 18,100 18,100 09/30/2020 183,375 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 1,125,000 158,675 1,283,675 1,283,675 Aug 1, 2019 3:13 pm Prepared by ATF ( y: \dbc \Schertz:SCHERTZ- 2019_GF) Page 51 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/2020 125,000 3.000% 56,300 181,300 08/01/2020 54,425 54,425 09/30/2020 235,725 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 Aug 1, 2019 3:13 pm Prepared by ATF ( y: \dbc \Schertz:SCHERTZ- 2019_GF) Page 52 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) Aug 1, 2019 3:13 pm Prepared by ATF ( y: \dbc \Schertz:SCHERTZ- 2019_GF) Page 53 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 09/30/2034 235,700 02/01/2035 205,000 3.000% 16,350 221,350 08/01/2035 13,275 13,275 09/30/2035 234,625 02/01/2036 210,000 3.000% 13,275 223,275 08/01/2036 10,125 10,125 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,480,000 1,206,600 4,686,600 4,686,600 Aug 1, 2019 3:13 pm Prepared by ATF ( y: \dbc \Schertz:SCHERTZ- 2019_GF) Page 53 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/2020 260,000 260,000 08/01/2020 260,000 260,000 09/30/2020 520,000 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 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 54 BOND DEBT SERVICE $41,040,000 Contract Revenue Bonds, Series 2001 Schertz /Seguin Local Government Corp. Non Callable Annual Period Debt Debt Ending Principal Coupon Interest Service Service 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 7,074,340 17,074,340 17,074,340 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 55 Capital BOND DEBT SERVICE $25,425,000 Contract Revenue Bonds, Series 2012 (SAWS Expansion Water Treatment Project 2) Schertz /Seguin Local Government Corp. Callable 2/1/2020 at Par Dated Date 06/01/2012 Delivery Date 07/19/2012 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2020 670,000 4.000% 426,793.75 1,096,793.75 08/01/2020 413,393.75 413,393.75 09/30/2020 1,510,187.50 02/01/2021 700,000 4.000% 413,393.75 1,113,393.75 08/01/2021 399,393.75 399,393.75 09/30/2021 1,512,787.50 02/01/2022 725,000 4.000% 399,393.75 1,124,393.75 08/01/2022 384,893.75 384,893.75 09/30/2022 1,509,287.50 02/01/2023 755,000 4.000% 384,893.75 1,139,893.75 08/01/2023 369,793.75 369,793.75 09/30/2023 1,509,687.50 02/01/2024 785,000 4.000% 369,793.75 1,154,793.75 08/01/2024 354,093.75 354,093.75 09/30/2024 1,508,887.50 02/01/2025 815,000 3.000% 354,093.75 1,169,093.75 08/01/2025 341,868.75 341,868.75 09/30/2025 1,510,962.50 02/01/2026 840,000 3.000% 341,868.75 1,181,868.75 08/01/2026 329,268.75 329,268.75 09/30/2026 1,511,137.50 02/01/2027 865,000 3.125% 329,268.75 1,194,268.75 08/01/2027 315,753.13 315,753.13 09/30/2027 1,510,021.88 02/01/2028 895,000 3.625% 315,753.13 1,210,753.13 08/01/2028 299,531.25 299,531.25 09/30/2028 1,510,284.38 02/01/2029 930,000 3.625% 299,531.25 1,229,531.25 08/01/2029 282,675.00 282,675.00 09/30/2029 1,512,206.25 02/01/2030 965,000 3.625% 282,675.00 1,247,675.00 08/01/2030 265,184.38 265,184.38 09/30/2030 1,512,859.38 02/01/2031 1,000,000 3.625% 265,184.38 1,265,184.38 08/01/2031 247,059.38 247,059.38 09/30/2031 1,512,243.76 02/01/2032 1,035,000 3.625% 247,059.38 1,282,059.38 08/01/2032 228,300.00 228,300.00 09/30/2032 1,510,359.38 02/01/2033 1,075,000 4.000% 228,300.00 1,303,300.00 08/01/2033 206,800.00 206,800.00 09/30/2033 1,510,100.00 02/01/2034 1,120,000 4.000% 206,800.00 1,326,800.00 08/01/2034 184,400.00 184,400.00 09/30/2034 1,511,200.00 02/01/2035 1,165,000 4.000% 184,400.00 1,349,400.00 08/01/2035 161,100.00 161,100.00 09/30/2035 1,510,500.00 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 56 Capital BOND DEBT SERVICE $25,425,000 Contract Revenue Bonds, Series 2012 (SAWS Expansion Water Treatment Project 2) Schertz /Seguin Local Government Corp. Callable 2/1/2020 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2036 1,210,000 4.000% 161,100.00 1,371,100.00 08/01/2036 136,900.00 136,900.00 09/30/2036 1,508,000.00 02/01/2037 1,260,000 4.000% 136,900.00 1,396,900.00 08/01/2037 111,700.00 111,700.00 09/30/2037 1,508,600.00 02/01/2038 1,315,000 4.000% 111,700.00 1,426,700.00 08/01/2038 85,400.00 85,400.00 09/30/2038 1,512,100.00 02/01/2039 1,365,000 4.000% 85,400.00 1,450,400.00 08/01/2039 58,100.00 58,100.00 09/30/2039 1,508,500.00 02/01/2040 1,425,000 4.000% 58,100.00 1,483,100.00 08/01/2040 29,600.00 29,600.00 09/30/2040 1,512,700.00 02/01/2041 1,480,000 4.000% 29,600.00 1,509,600.00 09/30/2041 1,509,600.00 22,395,000 10,837,212.53 33,232,212.53 33,232,212.53 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 57 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/2020 555,000 3.000% 58,887.50 613,887.50 08/01/2020 50,562.50 50,562.50 09/30/2020 664,450.00 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,610,000 378,262.50 3,988,262.50 3,988,262.50 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 58 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/2020 775,000 3.000% 840,400 1,615,400 08/01/2020 828,775 828,775 09/30/2020 2,444,175 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 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 59 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/2035 1,479,000 02/01/2036 2,960,000 4.000% 418,200 3,378,200 08/01/2036 359,000 359,000 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,850,000 22,985,400 61,835,400 61,835,400 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 60 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/2020 495,765.50 495,765.50 08/01/2020 1,240,000 0.860% 495,765.50 1,735,765.50 09/30/2020 2,231,531.00 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 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 61 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/2036 300,558.50 300,558.50 08/01/2036 1,615,000 2.600% 300,558.50 1,915,558.50 09/30/2036 2,216,117.00 02/01/2037 279,563.50 279,563.50 08/01/2037 1,660,000 2.780% 279,563.50 1,939,563.50 09/30/2037 2,219,127.00 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 42,410,000 17,563,897.50 59,973,897.50 59,973,897.50 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 62 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/2020 414,068.50 414,068.50 08/01/2020 414,068.50 414,068.50 09/30/2020 828,137 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 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 63 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 09/30/2035 02/01/2036 409,283.50 409,283.50 08/01/2036 700,000 3.240% 409,283.50 1,109,283.50 09/30/2036 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 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 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 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 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 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 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 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 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 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 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 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 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 02/01/2050 64,619.00 64,619.00 08/01/2050 1,775,000 3.580% 64,619.00 1,839,619.00 Annual Debt Service 1,128,137 1,518,567 1,920,887 1,921,962 1,921,653 1,924,960 1,921,710 1,927,076 1,925,084 1,921,152 1,915,280 1,912,468 1,912,522 1,910,063 1,905,635 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 64 Capital BOND DEBT SERVICE $22,830,000 SWIFT Funding Board Participation Loan, Series 2016 Schertz /Seguin Local Government Corp. Non - Callable Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 65 Annual Period Debt Ending Principal Coupon Interest Debt Service Service 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,984,142.00 43,814,142.00 43,814,142 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 65 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/2020 515,000 5.000% 411,525 926,525 08/01/2020 398,650 398,650 09/30/2020 1,325,175 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 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 66 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/2035 1,323,400 02/01/2036 1,065,000 4.000% 141,500 1,206,500 08/01/2036 120,200 120,200 09/30/2036 1,326,700 02/01/2037 1,110,000 4.000% 120,200 1,230,200 08/01/2037 98,000 98,000 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 19,045,000 10,113,125 29,158,125 29,158,125 Aug 1, 2019 2:54 pm Prepared by ATF (y: \dbc \Schertz:AGG) Page 67 Texas Municipal Reports Schertz, City Texas Municipal Reports i ➢, (General Obligation Debt) Last Revised: 4/2/2019 ' TMR # 2302 ,f- Guadalupe, Bexar, Comal Counties Page 1 of 14 ��1►T1�L+3I�[����1�1i� iii FOR OPERATING DATA OF THE WATERWORKS AND SEWER SYSTEM, SEE SEPARATE TEXAS MUNICIPAL REPORT. FINANCIAL STATEMENT (As of September 30, 2018) Net Taxable Assessed Valuation ( "A.V. "), 2018 $4,055,582,301(a) New Debt $8,570,000 Outstanding Debt 72,575.000 Total General Obligation Debt $81.145,000 Less: Self - Supporting (b) MSRB Water & Sewer 1.4,362,036 EMS Building 369,338 Drainage 329,525 GO Debt payable from Ad Valorem Taxes $66,084,102 Less: I &S Fund 1.099,858 Net Debt $64.984.244 (a) Includes $99,519,923 under review. (b) The October 23, 2018 Official Statement reports the following General Obligation Debt being paid from revenues other than ad valorem taxes: thus considered self- supporting. Net Debt Per Net Taxable Assessed Valuation - 1.60% Net Debt Per Sq mile - $2,272,176.35 Net Debt Per Capita $1,620.88 Net Taxable Assessed Valuation Per Capita - $101,156.90 Bureau of Census Pop: 2000 18,694 Bureau of Census Pop: 2010 31,465 2018 Estimated Population 40.092 Area 28.60 Sol mile PAYMENT RECORD Never defaulted. TAX DATA Tax Tax Adjusted % Collected Total % Collected Year A.U. Rate Levy within FY as of 09/30/2018 ** 2013 $2,752,562,574 $0.4974 $13,383,759 99.35 99.86 2014 3.037,267,611 0.4974 14,793.867 99.63 99.93 2015 3.375,850,131 0.4911 16,238.180 99.52 99.88 2016 3,647,504,903 0.4911 17,356,822 99.34 99.75 2017 3,783,027,833 0.4910 18,010,824 99.38 99.38 2018 4,055,582,301* 0.5146 20,870,027 (In process of collection) * Includes $99,519,923 for 2018 under review. ** Delinquent tax collections are allocated to the respective years in which the taxes are levied. Tax Rate Distribution 2018 2017 2016 2015 Operations $0.3497 $0.3248 $0.3168 $0.3159 I &S 0.1649 0.1662 0.1743 0.1752 - - - - -- - - - - -- - - - - -- - - - - -- Totals $0.5146 $0.4910 $0.4911 $0.4911 cities of more than 5.000 population; $2.50 per $100 assessed valuation. City operates under a Home Rule Charter which adopts constitutional provisions. TAX ABATEMENT The tax abatement for the 2018 assessed valuation was $902.273. TAX INCREMENT REINVESTMENT ZONE #2 The City is participating in Tax Increment Financing (TIF). Under the terms of the Zone agreement, the City of Schertz, Bexar County, and San Antonio River Authority are funding infrastructure improvements through tax increment financing to the Sedona Development Project. The Zone was created in December 2006 with a base value of $3,127,500. The Zone has a statutory termination date of December 31, 2027. TAX INCREMENT CAPTURED VALUE: 2013 $15,046,362 2014 11,664,298 2015 15,879,383 2016 18,033,005 2017 17,315,650 2018 21,398,191 Municipal Sales Tax: The City has adopted the provisions of Municipal Sales and Use Tax Act V.T.C.A, Tax Code, Chapter 321, which grants the City power to impose and levy a 1% Local Sales and Use Tax within the City; the proceeds are credited to the General Fund and are not pledged to the payment of the bonds in this report. Voters approved an additional sales and use tax of 112 of 1% for Cohorts Economic Development Corporation (Type B) effective January 1, 1998. Net allocations on calendar year basis are as follows: Calendar Total % of Ad Val Equiv of Ad Year Rate Collected Tax Levy Val Tax Rate 2015 1.500% $10,303,429 63.45% $0.31 2016 1.500 10,992,476 63.33 0.31. 2017 1.500 10,849,278 60.23 0.30 2018 1.500 12,631,749 60.52 0.31 DETAILS OF OUTSTANDING DEBT Details of Limited Tax Debt (Outstanding 9/30/2018) Comb Tax & Ltd Pledge Rev C/O Ser 2007 Tax Treatment: Tax Exempt Original Issue Amount $9,915,000.00 Dated Date: 0110112007 Sale Date: 12/19/2006 Delivery Date: 01/17/2007 Sale Type: Private Placement Record Date: MSRB Bond Form: FR Denomination $100,000 Interest pays Semi - Annually: 02101, 08 /01 1st Coupon Date: 08/01/2007 Paying Agent: The Bank of New York Mellon Trust Company, N.A., Houston, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Purchaser: JPMorgan Chase Bank, N.A. Security : Limited Tax and a subordinate lien on the net revenues of the Waterworks & Sewer system not to exceed $1,000. Water & Sewer 100.00% Use of Proceeds: Utility, Streets & Drainage, Public Works, Energy Management Sys, Communication Equipment. ,; i Texas Municipal Reports Fe F i ➢, (General Obligation Debt) Last Revised: 4/2/2019 ' TMR # 2302 ,f- Guadalupe, Bexar, Comal Counties Page 2 of 14 08/01/2019 355,000.00 4.0100% N/A $355,000.00 Call Option: Bonds maturing on 08/01/2018 to 08/01/2019 callable in whole or in part on any date beginning 08/01/2017 @ par. Refunded Notes: Maturities refunded by GO & Ref Bds Ser 2018 Refunded Amount Mat Date Coupon Price Sched Call 370,000.00 08/01/2020 4.010 Par 11/28/2018 385,000.00 08/01/2021 4.010 Par 11/28/2018 400,000.00 08/01/2022 4.010 Par 11/28/2018 420,000.00 08/01/2023 4.010 Par 11/28/2018 435,000.00 08/01/2024 4.010 Par 11/28/2018 455,000.00 08/01/2025 4.010 Par 11/28/2018 470,000.00 08/01/2026 4.010 Par 11/28/2018 GO Bds Ser 2007 Tax Treatment: Tax Exempt Original Issue Amount $6,000,000.00 Dated Date: 09/01/2007 Sale Date: 09/04/2007 Delivery Date: 09/24/2007 Sale Type: Private Placement Record Date: MSRB Bond Form: FR Denomination $100,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 02/01/2008 Paying Agent: The Bank of New York Mellon Trust Company, N.A., Houston, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Purchaser: JPMorgan Chase Bank, N.A. Use of Proceeds: Recreational Facilities, Streets & Sidewalks. Drainage. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2027T 3,205,000.00 4.0700% N/A - - $3,205,000.00 Call Option: Term bonds maturing on 02/01/2027 callable in whole or in part on any date @ par plus a Prepayment Fee as specified in the Indenture. Term Call: Term bonds maturing on 0210112027: Mandatory Redemption Date Principal Amount 02/01/2008 $190,000 02/01/2009 $285,000 0210112010 $250.000 0210112011 $275,000 0210112012 $225,000 0210112013 $235,000 02/01/2014 $245,000 02/01/2015 $255,000 02/01/2016 $265,000 02/01/2017 $280.000 02/01/2018 $290,000 02/01/2019 $300,000 0210112020 $315,000 02/01/2021 $325,000 0210112022 $340,000 02/01/2023 $355,000 02/01/2024 $370.000 02/01/2025 $385,000 02/01/2026 $400,000 0210112027 $415.000 r, °" GO & Ref Bds Ser 2009 Tax Treatment: Bank Qualified Original Issue Amount $9,500,000.00 Dated Date: 07/01/2009 Sale Date: 07/14/2009 Delivery Date: 08/13/2009 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 0210112010 Paying Agent: Wells Fargo Bank, N.A., Austin, 1X Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Lead Manager: SAMCO Capital Markets, Inc. Co- Manager: First Southwest Company Use of Proceeds: Streets, Refunding, Recreational Facilities. Refunding Notes: This bond refunded maturities from the following issues: GO Bds Ser 98 Refunded Amount Mat Date Coupon Price Sched Call 255,000.00 0210112010 4.400 Par 08/17/2009 270.000.00 02/01/2011 4.375 Par 08/17/2009 285,000.00 0210112012 4.375 Par 08/17/2009 300,000.00 0210112013 4.375 Par 08/17/2009 315,000.00 0210112014 4.375 Par 08/17/2009 335,000.00 02/01/2015 4.375 Par 08/17/2009 355.000.00 02/01/2016 4.375 Par 08/17/2009 375,000.00 02/01/2017 4.375 Par 08/17/2009 395.000.00 02/01/2018 4.375 Par 08/17/2009 Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 210,000.00 3.5000% 3.510% --------------------------------------------- - - - - -- $210.000.00 Call Option: Non - callable Refunded Notes: Maturities refunded by GO & Ref Bds Ser 2018 Refunded Amount Mat Date Coupon Price Sched Call 250.000.00 0210112020 3.750 Par 02/01/2019 350,000.00 02/01/2022 4.050 Par 0210112019 390.000.00 02/01/2024 4.250 Par 02/01/2019 1,160,000.00 0210112028 4.500 Par 02/01/2019 2.555.000.00 02/01/2033 5.500 Par 02/01/2019 GO Ref Bds Ser 2010 Tax Treatment: Bank Qualified Original Issue Amount $2,865,000.00 Dated Date: 1010112010 Sale Date: 1110212010 Delivery Date: 11/30/2010 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 0210112011 Paying Agent: Wells Fargo Bank, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Lead Manager: SAMCO Capital Markets, Inc. Use of Proceeds: Refunding. ,; i Texas Municipal Reports '_' i ➢, (General Obligation Debt) Last Revised: 4/2/2019 ' TMR # 2302 ,f- Guadalupe, Bexar, Comal Counties Page 3 of 14 Refunding Notes: This bond refunded maturit Comb Tax & Ltd Pledge Rev C/O Ser 2001 Refunded Amount Mat Date Coupon Price 225,000.00 0210112012 4.400 Par 235,000.00 02/01/2013 4.500 Par 250,000.00 02/01/2014 4.600 Par 260,000.00 02/01/2015 4.700 Par 275,000.00 02/01/2016 4.800 Par 290,000.00 02/01/2017 4.900 Par 300,000.00 02/01/2018 5.000 Par 320,000.00 02/01/2019 5.000 Par 335,000.00 02/01/2020 5.000 Par 350.000.00 0210112021 5.000 Par es from the following issue=_ Schad Call 02/01/2011 02/01/2011 02/01/2011 02/01/2011 02/01/2011 02/01/2011 02/01/2011 02/01/2011 02/01/2011 02/01/2011 Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 300,000.00 3.0000% 2.650% - -- $300,000.00 Call Option: Bonds maturing on 02/01/2019 callable in whole or in part on any date beginning 02/01/2018 @ par. Refunded Notes: Maturities refunded by GO & Ref Bds Ser 2018 Refunded Amount Mat Date Coupon Price Sched Call 310,000.00 0210112020 4.000 Par 11/28/2018 320.000.00 0210112021 4.000 Par 11/28/2018 GO Bds Ser 2011 Tax Treatment: Tax Treatment: Tax Exempt Original Issue Amount $8.250,000.00 Dated Date: 0310112011 Sale Date: 03/29/2011 Delivery Date: 04/26/2011 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 0210112012 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Lead Manager: SAMCO Capital Markets, Inc. Co- Manager: Piper Jaffray & Co. Use of Proceeds: Sports Complex, Aquatic Center, Animal Shelter. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 250,000.00 0210112020 260,000.00 0210112021 270,000.00 02/01/2023T 585,000.00 02/01/2024 315,000.00 02/01/2025 330,000.00 02/01/2026 345,000.00 0210112027 360,000.00 02/01/2028 375,000.00 02/01/2029 390,000.00 02/01/2030 410,000.00 02/01/20327 885,000.00 02/01/2034T 975,000.00 02/01/2036T 1,080,000.00 3.5000% 4.0000% 5.0000% 5.5000% 4.0000% 4.1250% 4.2500% 4.3750% 4.5000% 4.6250% 4.7500% 5.0000% 5.0000% 5.0000% 3.010% 3.300% 3.500% 3.900% 4.130% 4.260% 4.400% 4.500% 4.61.0% 4.720% 4.800% 100.00% 5.050% 5.110% --- - - - - -- $6.830.000.00 Call Option: Bonds maturing on 02/01/2024 to 02/01/2030 and term bonds maturing on 02/01/2023 and 02/01/2032 and 02/01/2034 and 02/01/2036 callable in whole or ri in part on any date beginning 0210112021 @ par Term Call: Term bonds maturing on 02/01/2023: Mandatory Redemption Date Principal Amount 0210112022 $285,000 0210112023 $300,000 Term bonds maturing on 0210112032: Mandatory Redemption Date Principal Amount 02/01/2031 $430,000 02/01/2032 $455,000 Term bonds maturing on 02/01/2034: Mandatory Redemption Date Principal Amount 02/01/2033 $475,000 02/01/2034 $500,000 Term bonds maturing on 02/01/2036: Mandatory Redemption Date Principal Amount 02/01/2035 $525,000 02/01/2036 $555,000 GO Ref Bds Ser 2011 Tax Treatment: Tax Treatment: Tax Exempt Original Issue Amount $2,675,000.00 Dated Date: 06/01/2011 Sale Date: 06/07/2011 Delivery Date: 06/30/2011 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 09/01, 03/01 1st Coupon Date: 03/01/2012 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Lead Manager: SAMCO Capital Markets, Inc. Water & Sewer 100.00% Use of Proceeds: Refunding. Refunding Notes: This issue defeased mty(s) 9/1/2012- 9/1/2021 of Util Sys Rev & Ref Bds Ser 2001 @ par. Orig Reoffering Maturity Amount Coupon Price /Yield 09/01/2019 230,000.00 2.5000% 2.750% 09/01/2020 235,000.00 2.7500% 3.000% 09/01/2021 240,000.00 3.0000% 1200% $705,000.00 Call Option: Bonds maturing on 09/01/2020 to 09/01/2021 callable in whole or in part on any date beginning 09/01/2019 @ par. GO Ref Bds Ser 2011A Tax Treatment: Tax Exempt Original Issue Amount $6,745,000.00 Dated Date: 12/01/2011 Sale Date: 11/15/2011 Delivery Date: 12/15/2011 Sale Type: Private Placement Record Date: MSRB Bond Form: FR Denomination $100,000 Interest pays Semi - Annually: 08/01, 02101 ,; i Texas Municipal Reports '_' i ➢, (General Obligation Debt) Last Revised: 4/2/2019 ' TMR # 2302 ,f- Guadalupe, Bexar, Comal Counties Page 4 of 14 1st Coupon Date: 0210112012 Paying Agent: Compass Bank, Houston, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Purchaser: Compass Mortgage Corporation, Houston, TX Use of Proceeds: Refunding. Refunding Notes: This issue defeased mty(s) 2/1/2014 - 2/1/2018 of Comb Tax & Ltd Pledge Rev C/O Ser 2003 @ par. This issue defeased mty(s) 02/01/2014- 02/01/2022, 02/01/2024 of Comb Tax & Ltd Pledge Rev C/O Ser 2004 @ par. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 485,000.00 2.3300% N/A 0210112020 475,000.00 2.3300% N/A 0210112021 485,000.00 2.3300% N/A 0210112022 670,000.00 2.3300% N/A 0210112023 675,000.00 2.3300% N/A 0210112024 660,000.00 2.3300% N/A 1st Coupon Date: 02/01/2013 2.7000% $3.450.000.00 Call Option: Bonds maturing on 0210112022 to 0210112024 callable in whole or in part on any date beginning 0210112021 @ par. GO Bds Ser 2012 345,000.00 Tax Treatment: Tax Exempt Original Issue Amount $7,625,000.00 Dated Date: 0810112012 Sale Date: 08/28/2012 Delivery Date: 09/13/2012 Sale Type: Competitive TIC: 2.8627% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 02/01/2013 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Lead Manager: Hutchinson Shockey Erley & Co. Use of Proceeds: Aquatic Center, Sports Complex, Downtown Area Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 345,000.00 2.0000% 1.550% 0210112020 355,000.00 3.0000% 1.800% 0210112021 365,000.00 3.0000% 2.000% 0210112022 375,000.00 2.2500% 2.150% 0210112023 385,000.00 2.2500% 2.400% 0210112024 390,000.00 2.5000% 2.600% 02/01/2025 400,000.00 2.7000% 2.750% 02/01/2026 415.000.00 2.8000% 2.900% 02/01/2028T 865,000.00 3.0000% 3.100% 02/01/2030T 915,000.00 3.0000% 3.160% 02/O1/2032T 975,000.00 3.1000% 3.240% 3.400% 02/01/20307 405.000.00 $5,785,000.00 Call Option: Bonds maturing on 0210112023 to 02/01/2026 and term bonds maturing on 02/01/2028 and 02/01/2030 and 0210112032 callable in whole or in part on any date beginning 0210112022 @ par. Term Call: Term bonds maturing on 02/01/2028: Mandatory Redemption Date Principal Amount 0210112027 $425,000 02/01/2028 $440,000 Term bonds maturing on 02/01/2030: Mandatory Redemption Date Principal Amount 0210112029 $450,000 02/01/2030 $465.000 Term bonds maturing on 02/01/2032: Mandatory Redemption Date Principal Amount 02/01/2031 $480,000 0210112032 $495.000 Comb Tax & Ltd Pledge Rev C/O Ser 2013 Tax Treatment: Bank Qualified Original Issue Amount $4,965,000.00 Dated Date: 09/01/2013 Sale Date: 09/10/2013 Delivery Date: 10/10/2013 Sale Type: Competitive TIC: 3.1347% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 02/01/2014 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski LLP Financial Advisor: Southwest Securities, San Antonio, TX Lead Manager: First Southwest Company Security : Limited Tax and a Subordinate lien on the Net revenues of the Utility system anticipated to be $1,000. Water & Sewer 100.00% Use of Proceeds: Public Improvements. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 395,000.00 2.2500% 1.600% 0210112020 405.000.00 2.5000% 1.900% 0210112021 415.000.00 3.0000% 2.180% 0210112022 155,000.00 3.0000% 2.350% 0210112023 160,000.00 3.0000% 2.550% 0210112024 165,000.00 3.5000% 2.700% 02/01/2025 170,000.00 3.5000% 2.850% 02/01/2026 175,000.00 3.5000% 3.000% 02/01/20287 375.000.00 4.0000% 3.400% 02/01/20307 405.000.00 4.0000% 1800% 02/01/20337 670.000.00 4.0000% 4.150% $3,490,000.00 Call Option: Bonds maturing on 0210112023 to 02/01/2026 and term bonds maturing on 02/01/2028 and 02/01/2030 and 02/01/2033 callable in whole or in part on any date beginning 0210112022 @ par. Term Call: Term bonds maturing on 02/01/2028: Mandatory Redemption Date Principal Amount 0210112027 $185,000 0210112028 $190.000 Term bonds maturing on 02/01/2030: Mandatory Redemption Date Principal Amount 0210112029 $200,000 02/01/2030 $205,000 i �. . ,; i Texas Municipal Reports '_' i ➢, (General Obligation Debt) Last Revised: 4/2/2019 ' TMR # 2302 ,f- Guadalupe, Bexar, Comal Counties Page 5 of 14 Term bonds maturing on 02/01/2033: Mandatory Redemption Date Principal Amount 02/01/2031 $215,000 02/01/2032 $225,000 02/01/2033 $230.000 GO Ref Bds Ser 2013 Mat Date Tax Treatment: Bank Qualified Original Issue Amount $2,160,000.00 Dated Date: 09/01/2013 Sale Date: 09/10/2013 Delivery Date: 10/10/2013 Sale Type: Private Placement Record Date: MSRB Bond Form: FR Denomination $100,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 0210112014 Paying Agent: Compass Bank, Houston, TX Bond Counsel: Fulbright & Jaworski LLP Financial Advisor: Southwest Securities, San Antonio, TX Purchaser: Compass Bank Water & Sewer 100.00% Use of Proceeds: Refunding. Refunding Notes: This bond refunded maturities from the following issues Comb Tax & Subord Lien Rev C/O Ser 2005 Refunded Amount Mat Date Sched Call Price 155,000 02/01/2015 02/01/2014 Par 325,000 0210112017 0210112014 Par 170,000 02/01/2018 02/01/2014 Par 180,000 02/01/2019 02/01/2014 Par 185,000 0210112020 0210112014 Par 195.000 0210112021 0210112014 Par 860,000 02/01/2025 02/01/2014 Par Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 190,000.00 2.5800% N/A 0210112020 190,000.00 2.5800% N/A 0210112021 200,000.00 2.5800% N/A 0210112022 205,000.00 2.5800% N/A 0210112023 205,000.00 2.5800% N/A 02/01/2024 215,000.00 2.5800% N/A 02/01/2025 215,000.00 2.5800% N/A 3.5000% 2.200% 02/01/2025 $1,420,000.00 Call Option: Bonds maturing on 0210112024 to 02/01/2025 callable in whole or in part on any date beginning 02/01/2023 @ par. GO Ref Bds Ser 2014 100,000.00 Tax Treatment: Bank Qualified Original Issue Amount $8,450,000.00 Dated Date: 05/1.5/2014 Sale Date: 06/03/2014 Delivery Date: 06/26/2014 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 02/01/2015 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski LLP U s .�,f. „ IJ " Financial Advisor: Southwest Securities, San Antonio, TX Lead Manager: SAMCO Capital Markets, Inc. Underwriter's Counsel: McCall Parkhurst & Horton L.L.P. Co- Purchaser: Frost Bank Use of Proceeds: Refunding Refunding Notes: This bond refunded maturities from the following issues: GO Bds Ser 2006 Refunded Amount Mat Date Coupon Price Sched Call 1,540,000.00 0210112023 5.250 Par 02/01/2016 1,715,000.00 02/01/2025 5.250 Par 02/01/2016 1,900,000.00 0210112027 5.250 Par 02/01/2016 3.220.000.00* 0210112031 4.625 Par 02/01/2016 * Partial Maturity Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 100,000.00 Tax Treatment: 3.0000% 1.250% 0210112020 100.000.00 12/01/2014 10000% 1.550% 0210112021 100,000.00 Sale Type: 10000% 1.750% 0210112022 750,000.00 FR 3.0000% 1.900% 0210112023 775,000.00 1st Coupon Date: 3.0000% 2.050% 0210112024 800,000.00 3.5000% 2.200% 02/01/2025 830,000.00 3.5000% 2.400% 02/01/2026 860,000.00 3.5000% 2.500% 0210112027 890.000.00 4.0000% 2.550% 02/01/2028 930,000.00 4.0000% 2650% 02/01/2029 960,000.00 4.0000% 2.750% 0210112030 1,005,000.00 3.5000% 3.100% - -- $8.100.000.00 Call Option: Bonds maturing on 0210112024 to 0210112030 callable in whole or in part on any date beginning 02/01/2023 @ par. Tax Notes Ser 2015 Tax Treatment: Tax Exempt Original Issue Amount $2,125,000.00 Dated Date: 12/01/2014 Sale Date: 12/16/2014 Delivery Date: 01/08/2015 Sale Type: Private Placement Record Date: MSRB Bond Form: FR Denomination $100,000 Interest pays Semi - Annually: 02101, 08/01 1st Coupon Date: 08/01/2015 Paying Agent: Frost Bank, San Antonio, TX Bond Counsel: Norton Rose Fulbright US LLP Financial Advisor: Southwest Securities, San Antonio, TX Purchaser: Frost Bank, San Antonio, TX Water & Sewer 8.44% EMS Building 42.21% Drainage 37.66% Use of Proceeds: Public Works. Orig Reoffering Maturity Amount Coupon Price /Yield 08/01/2019 340,000.00 1.7500% N/A 0810112020 345,000.00 1.7500% N/A 08/01/2021 190,000.00 1.7500% N/A $875,000.00 Call Option: Non Callable ,; i Texas Municipal Reports Fe F i ➢, (General Obligation Debt) Last Revised: 4/2/2019 ' TMR # 2302 ,f- Guadalupe, Bexar, Comal Counties Page 6 of 14 Tax Notes Ser 2015A 150,000.00 Tax Treatment: Tax Exempt Original Issue Amount $1.020,000.00 Dated Date: 10/15/2015 Sale Date: 10/27/2015 Delivery Date: 11/19/2015 Sale Type: Private Placement Record Date: MSRB Bond Form: FR Denomination $100,000 Interest pays Semi- Annually: 02101, 08/01 1st Coupon Date: 08/01/2016 Paying Agent: First National Bank Texas, Killeen, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, San Antonio, TX Purchaser: First National Bank Texas Use of Proceeds: Fire Truck. Orig Reoffering Maturity Amount Coupon Price /Yield 08/01/2019 150,000.00 1.5400% N/A 08/01/2020 150,000.00 1.5400% N/A 08/01/2021 150,000.00 1.5400% N/A 08/01/2022 155,000.00 1.5400% N/A --------------------------------------------- MSRB Bond Form: - - - - -- $605.000.00 Call Option: Non Callable GO Ref Bds Ser 2015 08/01/2016 Tax Treatment: Tax Exempt Original Issue Amount $4,185,000.00 Dated Date: 11/01/2015 Sale Date: 11 /17/2015 Delivery Date: 12/15/2015 Sale Type: Competitive TIC: 2.6015% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 0210112016 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: BOSC, Inc. Use of Proceeds: Refunding. Refunding Notes: This bond refunded GO Bds Ser 2006 Refunded Amount Mat Date Coupon 425,000.00 0210112017 4.125 475,000.00 02/01/201.8 4.200 655,000.00 02/01/2019 4.300 685,000.00 0210112020 4.375 715,000.00 0210112021 4.400 1,175,000.00 ** 0210112031 4.625 ** Remainder iaturit Price Par Par Par Par Par Par es from the following issues Sched Call 02/01/2016 021011201.6 02/01/2016 02/01/2016 02/01/2016 02/01/2016 Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 660.000.00 2.0000% 1.150% 0210112020 675.000.00 2.5000% 1.360% 0210112021 690.000.00 3.0000% 1.550% 02/01/2031 1,140,000.00 3.2500% 3.400% $1165.000.00 Call Option: Bonds maturing on 0210112031 callable in whole or in part on any date beginning 02/01/2025 @ par. Comb Tax & Ltd Pledge Rev C/O Ser 2016A Tax Treatment: Tax Exempt Original Issue Amount $2,375,000.00 Dated Date: 08/01/2016 Sale Date: 08/02/2016 Delivery Date: 09/01/2016 Sale Type: Competitive TIC: 2.2663% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 0210112017 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Fidelity Capital Markets Co- Manager: City Securities Co- Manager: Jefferies LLC Co- Manager: Morgan Stanley Co- Manager: Raymond James Security : Limited Tax and a Subordinate lien on the Net revenues of the Utility system not to exceed $1,000. Use of Proceeds: Public Improvements. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 175,000.00 4.0000% 0.840% 0210112020 180,000.00 4.0000% 0.980% 0210112021 190,000.00 4.0000% 1.070% 0210112022 195,000.00 4.0000% 1.240% 0210112023 205.000.00 4.0000% 1.400% 0210112024 70.000.00 3.0000% 1.530% 02/01/2025 75.000.00 10000% 1.670% 0210112026 75,000.00 3.0000% 1.820% 0210112027 80,000.00 2.0000% 2.020% 02/01/2028 80,000.00 2.0000% 2.150% 02/01/2029 80,000.00 2.1250% 2.300% 0210112030 85.000.00 2.2500% 2.400% 0210112031 85.000.00 2.3750% 2.500% 0210112032 90.000.00 2.3750% 2600% 02/01/2033 90,000.00 2.5000% 2.650% 02/01/20367 285,000.00 3.0000% 100.00% -- - -- --- ------- --- $2,040,000.00 Call Option: Bonds maturing on 0210112027 to 02/01/2033 and term bonds maturing on 02/01/2036 callable in whole or in part on any date beginning 02/01/2026 @ par. Term Call: Term bonds maturing on 02/01/2036 subject to mandatory redemption as follows: Redemption Date Principal Amount 02/01/2034 $90,000 02/01/2035 $95.000 02/01/2036 $100,000 , s, $285,000 ,; i Texas Municipal Reports "o X i ➢, (General Obligation Debt) Last Revised: 4/2/2019 ' TMR # 2302 ,f- Guadalupe, Bexar, Comal Counties Page 7 of 14 Comb Tax & Ltd Pledge Rev C/O Taxable Ser 2016B Tax Treatment: Taxable Original Issue Amount $1,475,000.00 Dated Date: 08/01/2016 Sale Date: 08/02/2016 Delivery Date: 09/01/2016 Sale Type: Competitive TIC: 3.1726% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 02/01/2017 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Robert W. Baird & Co., Inc. Co- Manager: Alamo Capital Co- Manager: CL King & Associates Co- Manager: Crews & Associates, Inc. Co- Manager: Cronin & Co. Co- Manager: Davenport & Co. LLC Co- Manager: Duncan - Williams, Inc. Co- Manager: Edward Jones Co- Manager: First Empire Securities Co- Manager: FMSbonds, Inc. Co- Manager: FTN Financial Co- Manager: IFS Securities, Inc. Co- Manager: Isaak Bond Co- Manager: Loop Capital Markets LLC Co- Manager: Midland Securities, Ltd Co- Manager: Oppenheimer & Co. Inc. Co- Manager: R. Seelaus & Co., Inc. Co- Manager: Rafferty Capital Markets, LLC Co- Manager: Ross, Sinclaire & Associates, Inc. Co- Manager: Sierra Pacific Co- Manager: SumRidge Partners, LLC Co- Manager: W. H. Me]] Associates, Inc Co- Manager: Wayne Hummer Investments Co- Manager: Wedbush Morgan Securities Co- Manager: WNJ Capital Security : Limited Tax and a Subordinate lien on the Net revenues of the Utility system. Use of Proceeds: Aquatic Center. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 55,000.00 3.0000% 1.250% Tax Exempt 0210112020 60,000.00 3.0000% 1.450% 08/01/2016 0210112021 60,000.00 3.0000% 1.650% 09/01/2016 0210112022 60,000.00 3.0000% 1.800% 2.4799% 02/01/2023 65,000.00 3.0000% 2.000% BE 0210112024 65,000.00 3.0000% 2.200% Semi - Annually: 08/01, 02101 02/01/2025 70,000.00 3.0000% 2.350% 02/01/2026 70,000.00 3.0000% 2.500% 02/01/2031T 395,000.00 3.5000% 2.800% 02/01/2036T 465,000.00 3.7500% 3.000% ------------------------------------------- - - - - -- $1.365.000.00 Call Option: Term bonds maturing on 02/01/2031 and 02/01/2036 callable in whole or in part on any date beginning 02/01/2026 @ par. Term Call: Term bonds maturing on 02/01/2031 subject to mandatory redemption as follows: Redemption Date Principal Amount 0210112027 $75,000 c 02/01/2028 $75,000 02/01/2029 $80,000 02/01/2030 $80,000 02/01/2031 $85,000 $395,000 Term bonds maturing on 02/01/2036 subject to mandatory redemption as follows: Redemption Date Principal Amount 02/01/2032 $85,000 02/01/2033 $90,000 02/01/2034 $95,000 02/01/2035 $95,000 02/01/2036 $100.000 $465,000 GO Bds Ser 2016 Tax Treatment: Tax Exempt Original Issue Amount $5,880,000.00 Dated Date: 08/01/2016 Sale Date: 08/02/2016 Delivery Date: 09/01/2016 Sale Type: Competitive TIC: 2.4799% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 08/01, 02101 Tat Coupon Date: 0210112017 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Fidelity Capital Markets Co- Manager: City Securities Co- Manager: Jefferies LLC Co- Manager: Morgan Stanley Co- Manager: Raymond James Use of Proceeds: Streets & Drainage Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 215,000.00 4.0000% 0.840% 0210112020 225,000.00 4.0000% 0.980% 0210112021 235,000.00 4.0000% 1.070% 0210112022 245,000.00 4.0000% 1.240% 0210112023 255,000.00 4.0000% 1.400% 0210112024 265,000.00 4.0000% 1.530% 02/01/2025 275,000.00 4.0000% 1.670% 0210112026 285,000.00 4.0000% 1.820% 0210112027 295,000.00 2.0000% 2.020% 0210112028 300,000.00 2.0000% 2.150% 02/01/2029 305,000.00 2.1250% 2.300% 0210112030 310,000.00 2.2500% 2.400% 0210112031 320,000.00 2.3750% 2.500% 0210112032 330,000.00 2.5000% 2.600% 02/01/2033 335,000.00 3.0000% 2.700% 02/01/20367 1,075,000.00 3.0000% 100.00% ------------------------------------------- - - - - -- $5.270.000.00 Call Option: Bonds maturing on 0210112027 to 02/01/2033 and term bonds maturing on 02/01/2036 callable in whole or in part on any date beginning 02/01/2026 @ par. Term Call: Term bonds maturing on 02/01/2036 subject to mandatory redemption as follows: Redemption Date Principal Amount ,; i Texas Municipal Reports "C i ➢, (General Obligation Debt) Last Revised: 4/2/2019 ' TMR # 2302 ,f- Guadalupe, Bexar, Comal Counties Page 8 of 14 02/01/2034 $345,000 02/01/2035 $360,000 02/01/2036 $370,000 $1.075.000 Comb Tax & Ltd Pledge Rev C/O Ser 2017 Tax Treatment: Bank Qualified Original Issue Amount $5,475,000.00 Dated Date: 05/15/2017 Sale Date: 05/23/2017 Delivery Date: 0612012017 Sale Type: Competitive TIC: 2.6239% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02101 Ist Coupon Date: 02/01/2018 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Robert W. Baird & Co., Inc. Co- Manager: Alamo Capital Co- Manager: CL King & Associates Co- Manager: Commerce Bank Co- Manager: Country Club Bank Co- Manager: Davenport & Co. LLC Co- Manager: Dougherty & Company LLC Co- Manager: Duncan - Williams, Inc. Co- Manager: Edward Jones Co- Manager: First Empire Securities Co- Manager: First Kentucky Securities Co- Manager: FMSbonds, Inc. Co- Manager: IFS Securities, Inc. Co- Manager: Isaak Bond Co- Manager: Loop Capital Markets LLC Co- Manager: Midland Securities, Ltd Co- Manager: Oppenheimer & Co. Inc. Co- Manager: Rafferty Capital Markets, LLC Co- Manager: Ross, Sinclaire & Associates, Inc. Co- Manager: Sierra Pacific Co- Manager: Stephens Inc. Co- Manager: SumRidge Partners, LLC Co- Manager: UMB Bank Co- Manager: Vining- Sparks ISO Co- Manager: W. H. Me]] Associates, Inc Co- Manager: Wayne Hummer Investments Co- Manager: Wedbush Securities Co- Manager: WNJ Capital Security : Limited Tax and a Subordinate lien on the Net revenues of the Utility system not to exceed $1,000. Use of Proceeds: Public Improvements. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 385,000.00 3.0000% 1.050% 3.0000% 0210112020 400,000.00 3.0000% 1.190% 05/15/2017 0210112021 405,000.00 3.0000% 1.350% 220,000.00 0210112022 420,000.00 3.0000% 1.500% 02/01/20337 0210112023 315,000.00 3.0000% 1.650% 2.800% 0210112024 325,000.00 3.0000% 1.750% 3.2500% 02/01/2025 185.000.00 3.0000% 1.900% 02/01/2026 190,000.00 3.0000% 2.000% 0210112027 195,000.00 3.0000% 2.150% 02/01/2028 200,000.00 3.0000% 2.300% 0210112029 205.000.00 Tax Treatment: 3.0000% 2.400% 02/01/2030 215.000.00 05/15/2017 10000% 2.500% 02/01/2031 220,000.00 Sale Type: 3.0000% 2.600% 02/01/20337 460,000.00 MSRS 3.0000% 2.800% 02/01/20357 490,000.00 Interest pays 3.2500% 3.000% 02/01/20377 520.000.00 3.2500% 3.150% $5,130,000.00 Call Option: Bonds maturing on 0210112028 to 0210112031 and term bonds maturing on 02/01/2033 and 0210112035 and 02/01/2037 callable in whole or in part on any date beginning 0210112027 @ par. Term Call: Term bonds maturing on 02/01/2033 subject to mandatory redemption as follows: Redemption Date Principal Amount 02/01/2032 $225,000 02/01/2033 $235,000 $460.000 Term bonds maturing on 02/01/2035 subject to mandatory redemption as follows: Redemption Date Principal Amount 02/01/2034 $240.000 02/01/2035 $250.000 $490,000 Term bonds maturing on 0210112037 subject to mandatory redemption as follows: Redemption Date Principal Amount 02/01/2036 $255,000 02/01/2037 $265,000 $520.000 GO Bids Ser 2017 Tax Treatment: Bank Qualified Original Issue Amount $3,935,000.00 Dated Date: 05/15/2017 Sale Date: 05/23/2017 Delivery Date: 06/20/2017 Sale Type: Competitive TIC: 2.7797% Record Date: MSRS Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08 /01, 02101 1st Coupon Date: 02/01/2018 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Robert W. Baird & Co., Inc. Co- Manager: Alamo Capital Co- Manager: CL King & Associates Co- Manager: Commerce Bank Co- Manager: Country Club Bank Co- Manager: Davenport & Co. LLC Co- Manager: Dougherty & Company LLC Co- Manager: Duncan - Williams, Inc. Co- Manager: Edward Jones Co- Manager: First Empire Securities Co- Manager: First Kentucky Securities Co- Manager: FMSbonds, Inc. Co- Manager: IFS Securities, Inc. Co- Manager: Isaak Bond Co- Manager: Loop Capital Markets LLC Co- Manager: Midland Securities, Ltd Co- Manager: Oppenheimer & Co. Inc. Co- Manager: Rafferty Capital Markets, LLC Co- Manager: Ross, Sinclaire & Associates, Inc. i.. �r' Litio- Ij . . oi ill �. !c if pr �; �..�' ,; i Texas Municipal Reports "C t i ➢, (General Obligation Debt) Last Revised: 4/2/2019 ' TMR # 2302 ,f- Guadalupe, Bexar, Comal Counties Page 9 of 14 Co- Manager: Stephens Inc. Co- Manager: SumRidge Partners, LLC Co- Manager: UMB Bank Co- Manager: Vining- Sparks IBG Co- Manager: W. H. Me]] Associates, Inc Co- Manager: Wayne Hummer Investments Co- Manager: Wedbush Securities Co- Manager: WNJ Capital Co- Manager: Sierra Pacific Use of Proceeds: Public Safety. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 150,000.00 3.0000% 1.090% Bank Qualified 0210112020 155,000.00 3.0000% 1.190% 12/15/2017 0210112021 160,000.00 3.0000% 1.350% 01/04/2018 0210112022 165,000.00 3.0000% 1.500% 2.1198% 0210112023 170,000.00 3.0000% 1.650% FR 0210112024 175,000.00 3.0000% 1.750% 02/01/2025 180,000.00 3.0000% 1.900% 2.1200% 02/01/2026 185,000.00 3.0000% 2.000% 610,000.00 0210112027 190,000.00 3.0000% 2.150% 02/01/2028 195,000.00 3.0000% 2.300% 2.1200% 02/01/2029 205,000.00 3.0000% 2.400% 635.000.00 02/01/2030 210,000.00 3.0000% 2.500% 0210112031 215,000.00 3.0000% 2.600% 2.1200% 02/01/2033T 455,000.00 3.0000% 2.800% 660.000.00 02/01/2035T 480,000.00 3.2500% 3.000% 02/01/2037T 510,000.00 3.2500% 3.150% $3.800.000.00 Call Option: Bonds maturing on 0210112028 to 0210112031 and term bonds maturing on 02/01/2033 and 02/01/2035 and 0210112037 callable in whole or in part on any date beginning 0210112027 @ par. Term Call: Term bonds maturing on 02/01/2033 subject to mandatory redemption as follows: Redemption Date Principal Amount 02/01/2032 $225,000 02/01/2033 $230.000 $455,000 Term bonds maturing on 02/01/2035 subject to mandatory redemption as follows Redemption Date Principal Amount 02/01/2034 $235,000 02/01/2035 $245.000 $480.000 Term bonds maturing on 02/01/2037 subject to mandatory redemption as follows Redemption Date Principal Amount 02/01/2036 $250.000 0210112037 $260.000 $510,000 GO Ref Bds Ser 2018 550,000.00 Tax Treatment: Bank Qualified Original Issue Amount $6,035,000.00 Dated Date: 12/15/2017 Sale Date: 1211212017 Delivery Date: 01/04/2018 Sale Type: Private Placement TIC: 2.1198% Record Date: MSRB Bond Form: FR Denomination $100,000 i..1 J in Interest pays Semi - Annually: 02101, 08/01 1st Coupon Date: 08/01/2018 Paying Agent: First National Bank Texas, Killeen, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Purchaser: First National Bank Texas, Killeen, TX Use of Proceeds: Refunding. Refunding Notes: This bond refunded maturities from the following issues: GO Dos Ser 2008 Refunded Amount Mat Date Coupon Price Sched Call 500,000.00 02/01/2019 4.130 Par 02/01/2018 520,000.00 0210112020 4.130 Par 0210112018 540,000.00 0210112021 4.130 Par 02/01/2018 565,000.00 0210112022 4.130 Par 02/01/2018 585,000.00 02/01/2023 4.130 Par 02/01/2018 610,000.00 0210112024 4.130 Par 02/01/2018 640,000.00 02/01/2025 4.130 Par 02/01/2018 665,000.00 0210112026 4.130 Par 0210112018 690,000.00 0210112027 4.130 Par 0210112018 720,000.00 0210112028 4.130 Par 02/01/2018 Grid Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 550,000.00 Sale Date: 2.1200% 100.00% 08/08/2018 0210112020 560.000.00 TIC: 2.1200% 100.00% MSRB 0210112021 570.000.00 Denomination 2.1200% 100.00% Semi - Annually: 08/01, 02101 0210112022 585,000.00 2.1200% 100.00% 0210112023 595,000.00 2.1200% 100.00% 0210112024 610,000.00 2.1200% 100.00% 02/01/2025 625,000.00 2.1200% 100.00% 02/01/2026 635.000.00 2.1200% 100.00% 0210112027 645,000.00 2.1200% 100.00% 02/01/2028 660.000.00 2.1200% 100.00% $6.035.000.00 Call Option: Bonds maturing on 0210112024 to 02/01/2028 callable in whole or in part on any date beginning 02/01/2023 @ par. Comb Tax & Ltd Pledge Rev C/O Ser 2018 Tax Treatment: Tax Exempt Original Issue Amount $10.440,000.00 Dated Date: 07/01/2018 Sale Date: 07/10/2018 Delivery Date: 08/08/2018 Sale Type: Competitive TIC: 3.1999% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 02/01/2019 Paying Agent: UMB Bank, N.A., Dallas, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Morgan Stanley Co- Manager: Fidelity Capital Markets Co- Manager: Raymond James Co- Manager: UBS Financial Services, Inc. Co- Manager: Ziegler Securities Inc. Security : Limited Tax and a Subordinate lien on the Net revenues of the Utility system not to exceed $1.000. Water & Sewer 53.49% ,; i Texas Municipal Reports Fe F i ➢, (General Obligation Debt) Last Revised: 4/2/2019 ' TMR # 2302 ,f- Guadalupe, Bexar, Comal Counties Page 10 of 14 Use of Proceeds: Public Improvements. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 385,000.00 5.0000% 1.550% 0210112020 405,000.00 5.0000% 1.750% 0210112021 430,000.00 5.0000% 1.900% 0210112022 450,000.00 5.0000% 2.020% 02/01/2023 475,000.00 5.0000% 2.130% 02/01/2024 495,000.00 5.0000% 2.240% 02/01/2025 520,000.00 5.0000% 2.380% 02/01/2026 435,000.00 5.0000% 2.500% 0210112027 455,000.00 5.0000% 2.590% 02/01/2028 480,000.00 5.0000% 2.640% 02/01/2029 505,000.00 5.0000% 2.680% 02/01/2030 525,000.00 4.0000% 2.850% 02/01/2031 545,000.00 3.0000% 3.150% 0210112032 560,000.00 3.0000% 3.250% 02/01/2033 580,000.00 3.1250% 3.300% 0210112034 595,000.00 3.2500% 3.350% 02/01/2035 620,000.00 3.2500% 3.400% 02/01/2036 640,000.00 3.3750% 3.452% 02/01/2037 660,000.00 3.3750% 3.486% 02/01/2038 680,000.00 3.5000% 100.00% $10,440,000.00 Call Option: Bonds maturing on 02/01/2029 to 02/01/2038 callable in whole or in part on any date beginning 0210112028 @ par. GO & Ref Bds Ser 2018 Tax Treatment: Tax Exempt Original Issue Amount $8,570,000.00 Dated Date: 10/15/2018 Sale Date: 10/23/2018 Delivery Date: 11/27/2018 Sale Type: Competitive TIC: 3.0987% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 02/01/2019 Paying Agent: UMB Bank, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Citigroup Global Markets Inc. Co- Manager: Academy Securities Co- Manager: Amuni Financial Inc. Co- Manager: Drexel Hamilton, LLC Co- Manager: Estrada Hinodosa & Company, Inc. Co- Manager: George K. Baum & Company Co- Manager: Intercoastal Capital Markets Inc. Co- Manager: Protective Securities Co- Manager: Ramirez & Co., Inc. Co- Manager: Roosevelt & Cross Co- Manager: Siebert Cisneros Shank & Co., L.L.C. Co- Manager: UMB Bank Co- Manager: Wells Nelson & Associates. LLC Co- Manager: Wiley Bros. Aintree Capital Water & Sewer 31.90% Use of Proceeds: Refunding, Street & Bridge. Refunding Notes: This bond refunded maturities from the following issues Comb Tax & Ltd Pledge Rev C/O Ser 2007 Refunded Amount Mat Date Coupon Price Sched Call 370,000.00 08/01/2020 4.010 Par 11/28/2018 385,000.00 0810112021 4.010 Par 1112812018 400,000.00 08/01/2022 4.010 Par 11/28/2018 420,000.00 08/01/2023 4.010 Par 11/28/2018 435,000.00 08/01/2024 4.010 Par 11/28/2018 455,000.00 08/01/2025 4.010 Par 11/28/2018 470,000.00 08/01/2026 4.010 Par 11/28/2018 GO & Ref Bds Ser 2009 Refunded Amount Mat Date Coupon Price Sched Call 250,000.00 0210112020 1750 Par 02/01/2019 350,000.00 0210112022 4.050 Par 02/01/2019 390,000.00 0210112024 4.250 Par 02/01/2019 1,160,000.00 0210112028 4.500 Par 02/01/2019 2,555.000.00 02/01/2033 5.500 Par 02/01/2019 GO Ref Bds Ser 2010 Refunded Amount Mat Date Coupon Price Sched Call 310,000.00 0210112020 4.000 Par 11/28/2018 320,000.00 0210112021 4.000 Par 11/28/2018 Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 95,000.00 5.0000% 1.920% 0210112020 915,000.00 ,r i, 5.0000% 2.110% 0210112021 880,000.00 5.0000% 2.180% 0210112022 555,000.00 5.0000% 2.270% 0210112023 595,000.00 5.0000% 2.380% 0210112024 660,000.00 5.0000% 2.480% 02/01/2025 670,000.00 5.0000% 2.600% 02/01/2026 700,000.00 5.0000% 2.720% 0210112027 260,000.00 5.0000% 2.840% 0210112028 570,000.00 4.0000% 3.000% 0210112029 495,000.00 4.0000% 3.120% 0210112030 515,000.00 4.0000% 3.220% 0210112031 535,000.00 3.1250% 1402% 02/01/2032 555,000.00 12500% 1524% 02/01/2033 570.000.00 3.3750% 3.601% $8,570,000.00 Call Option: Bonds maturing on 0210112029 to 02/01/2033 callable in whole or in part on any date beginning 0210112028 @ par. Grand Total _ ______________> $81,145,000.00 Bond Debt Service Period Ending Principal Interest Debt Service 09/30/19 09/30/20 09/30/21 09/30/22 09/30/23 09/30/24 09/30/25 09/30/26 09/30/27 09/30/28 09/30/29 09/30/30 09/30/31 09/30/32 09/30/33 09/30/34 09/30/35 09/30/36 09/30/37 6,320,000.00 6,405,000.00 6,360,000.00 5,610,000.00 5,530,000.00 5,580,000.00 4,930,000.00 4,770,000.00 4,470,000.00 4,495,000.00 3,875,000.00 4,025,000.00 4,270,000.00 3,245,000.00 2,835,000.00 2,100,000.00 2,190,000.00 2,270,000.00 1.185.000.00 2,670,829.66 2,512,111.25 2,299,309.25 2,091,862.00 1,901,828.00 1,710,761.75 1,524,701.75 1,346,862.50 1,179,118.00 1,020,502.25 868,496.88 723,943.75 582,153.75 457,278.75 352-,806.25 264,643.75 186,600.00 104,943.75 43.468.75 8,990,829.66 8,917,111.25 8,659,309.25 7,701.862.00 7,431,828.00 7,290,761.75 6,454,701.75 6,1.16,862.50 5,649,118.00 5,515,502.25 4,743,496.88 4,748,943.75 4,852,153.75 3,702,278.75 3,1.87,806.25 2,364,643.75 2,376,600.00 2,374,943.75 1.228.468.75 , .. .,, ,r i, . ,. ., ,, c, ... .. .. .. ,,� !f« '4. Schertz, City Texas Municipal Reports '_' I i ➢, (General Obligation Debt) Last Revised: 4/2/2019 ' TMR # 2302 ,f- Guadalupe, Bexar, Comal Counties Page 11 of 14 09/30/38 680,000.00 11,900.00 691,900.00 81,145,000.00 21,854,122.03 102,999,122.03 COMPUTED ON BASIS OF MANDATORY REDEMPTION Debt Amortization Rates condensed statements have been compiled using accounting principles customarily employed in the % of Principal available for debt service, Period Ending Principal Retired depreciation, transfers, 09/30/2019 6,320,000.00 expenditures 07.79% capital. 09/30/2020 6,405,000.00 Total: 15.68% $15,000,000 09/30/2021 6,360,000.00 Year Ended 23.52% from the following election 09/30/2022 5,610,000.00 09 -30 -2016 30.43% Revenues: 09/30/2023 5.530,000.00 12/16/1961- 37.25% Fees & Charges 09/30/2024 5,580,000.00 $5,921,223 44.12% Other 09/30/2025 4,930,000.00 814 50.20% Total Revenues 09/30/2026 4,770,000.00 -- - - - - -- $5,922,037 56.08% Expenses 09/30/2027 4,470,000.00 $4,681,742 61.59% Available For 09/30/2028 4,495,000.00 Inactive employees entitled to but 67.13% Debt Service 09/30/2029 3,875,000.00 $1,240,295 71.90% 322 09/30/2030 4.025,000.00 76.86% 09/30/2031 4,270,000.00 82.12% 09/30/2032 3,245,000.00 86.12% 09/30/2033 2,835,000.00 89.62% 09/30/2034 2,100,000.00 92.21% 09/30/2035 2,190,000.00 94.90% 09/30/2036 2,270,000.00 97.70% 09/30/2037 1,185,000.00 99.16% 09/30/2038 680,000.00 100.00% G.O. Debt Service Requirements for fiscal year- ending 09/30/2019 I &S Fds all G.O. issues 09/30/2018 2018 I &S Fund Tax Levy @ 90% Water & Sewer EMS Building Drainage 1:24:7 1Z[tj&t IF—All 1114ky,14►k1 $8,990,83C $1,099,858 6,018,890 1,957,577 149,977 133,811 SCHERTZ EMS OPERATING EXPERIENCES The following condensed statements have been compiled using accounting principles customarily employed in the determination of net revenues available for debt service, and in all instances exclude depreciation, transfers, debt service payments and expenditures identified as capital. 2,605,000 4,395,000 Total: Contributions Employee $15,000,000 $10,605,000 Fiscal Year Ended authorizations from the following election 09 -30 -2018 09 -30 -2017 09 -30 -2016 09 -30 -2015 Revenues: too old: $14,634,709 12/16/1961- $14,000 Fees & Charges $6,092,559 $6,366,894 $5,921,223 $4,415,126 Other 10,640 3,649 814 1,014 Total Revenues -- - - - - -- $6,103,199 -- - - - - -- $6.370,543 -- - - - - -- $5,922,037 -- - - - - -- $4,416.140 Expenses $5,726,157 $5,649,614 $4,681,742 $4,467,869 Available For 98 84 Inactive employees entitled to but Debt Service $377,042 $720,929 $1,240,295 ($51,729)* * The EMS had a deficit net positon. The City planned to remedy this deficit with a review of expenditures as well as an increase in fees from participants. GENERAL OBLIGATION BONDS AUTHORIZED BUT UNISSUED* Election 74.71% Amount Issued $17,603,310 Date Purpose Authorized To Date Unissued 11/03/15 Public Safety $8,000,000 $8,000,000 $0 11/03/15 Street & Bridge 7,000,000 2,605,000 4,395,000 Total: Contributions Employee $15,000,000 $10,605,000 $4,395.000 * Excludes authorizations from the following election propositions) because the remaining authorization is deemed too small or too old: $14,634,709 12/16/1961- $14,000 Sewer % of Total Pension Liability 07/18/1970- $250,000 Sewer 17,603,310 16,478,620 08/09/1997- $595 Fire Improvements of Covered Payroll 83.14% 08/09/1997- $330 hospital Inactive employees or beneficiaries :24i,NIs]tl1[]i I all Itr_1:3 III ki1 All qualified employees of the City are members of the Texas Municipal Retirement System. The City employees also participate in the U.S. Social Security program. Required Contribution Rates (Percentage of gross covered salary) 2019 2018 Employee: 7.00% 7.00% City: 16.16% 16.14% Actuarial Valuation as of 1213112017 12/31/2016 Assets $49,347,226 $44,121,457 Accrued Liabilities $66.054.349 $60,296,483 (Unfunded) /Overfunded Liab. ($16,707,123) ($16.175,026) Funded Ratio 74.71% 73.17% Annual Covered Payroll $17,603,310 $16,478,620 (Unfunded) /Overfunded Liability as a % of Covered Payroll (94.91)% (98.16)% Pension Liability - Beginning $60,296,483 $55,119,232 Pension Liability Ending (a) $66,054,349 $60,296,483 Contributions Employer $2,793,644 $2,627,335 Contributions Employee $1,232,232 $1,152,864 Plan Fiduciary Net Position Beg $43,270,388 $38,499,857 Plan Fiduciary Net Position End (b) $51,419,640 $43,270,388 Net Pension Liability (a) - (b) (Pension Liab - Fiduciary Position) $14,634,709 $17,026,095 Plan Fiduciary Net Position as a % of Total Pension Liability 77.84% 71.76% Covered Employee Payroll 17,603,310 16,478,620 Net Pension Liability as a % of Covered Payroll 83.14% 103.32% Membership Data Inactive employees or beneficiaries currently receiving benefits 98 84 Inactive employees entitled to but not yet receiving benefits 166 155 Active employees 322 317 Total 586 556 , �,,,, n ,A ,. , .., . , , , „r " ,frs �� ,.,.,. Schertz, City Texas Municipal Reports i ➢, (General Obligation Debt) Last Revised: 4/2/2019 ' TMR # 2302 ,f- Guadalupe, Bexar, Comal Counties Page 12 of 14 Source: Texas Municipal Retirement System. POST EMPLOYMENT HEALTH BENEFITS: GASB STATEMENT 45 GASB released the Statement of Governmental Accounting Standards No. 45 (GASB 45), Accounting and Financial Reporting by Employers for Post Employment Benefits Other Than Pensions (OPEB), in June 2004. The City has implemented GASB 45 for the fiscal year ending September 30, 2014. GASB 45 sets forth standards for measurement, recognition, and display of post - employment benefits, other than pensions, such as health and life insurance for current and future retirees. Measurement Year 2018 Net change in total OPEB liability Total OPEB liability Beg. Total OPEB liability - Ending Covered employee payroll Total OPEB liability as a %age of covered employee payroll $103,785 $519.156 $622,941 $17,603,310 3.54% SUPPLEMENTAL DEATH BENEFIT PLAN SUPPLEMENTAL DEATH BENEFIT PLAN The City also participates in the cost sharing multiple- employer defined benefit group -term life insurance plan operated by TMRS known as the Supplemental Death Benefits Fund (SDBF). The City elected, by ordinance, to provide group -term life insurance coverage to both current and retired employees. The death benefit for active employees provides a lump -sum payment approximately equal to the employee's annual salary: retired employees are insured for $7,500; this coverage is an "other postemployment benefit." Source: City of Schertz CAFR 9 -30 -2018. NON FUNDED DEBT NON- FUNDED DEBT PAYABLE (As of September 30, 2018) The City reports additional debt in the principal amount of $2,701.398 under Emergency Medical Services and $14,398,565 under Govt Activities as follows: Amount Next Year's Reported Outstanding Requirements Under Compensated Absences $191,420 N/A Emergency Medical Services OPEB* $411,613 N/A Emergency Medical Services Pension Liability* $2.098,365 N/A Emergency Medical Services Capital Lease $34.264 $8,565* *Govt Activities Compensated Absences $1,227,324 N/A Govt Activities Pension Liability* $11,11.3,219 N/A Govt Activities OPEB* $2,023,758 N/A Govt Activities * See PENSION FUND LIABILITY section for details of this obligation. ** Amount excludes interest ESTIMATED OVERLAPPING DEBT STATEMENT Taxing Body Debt Amount As Of %Ovlpg Ovlpg Amt Alamo CCD $470,915,000 * 02/28/19 0.29 $1,365,654 Bexar Cc 1,469,227,300 09/30/17 0.29 4,260,759 Bexar Co Hosp Dist 840,300,000 * 02/28/19 0.29 2,436,870 Comal Cc 138,670,000 10/01/18 4.84 6,711,628 Comal ISD 747,720,504 * 02/28/19 4.92 36,787.849 Guadalupe Cc 11,570,000 * 02/28/19 20.26 2,344,082 Schertz- Cibolo- Universal City ISD 402,091,192 10/01/18 48.79 196,180,293 Total Overlapping Debt: $250,087,134 Schertz. City of 09/30/18 $64,984,244 Total Direct and Overlapping Debt: $315,071,378 Total Direct and Overlapping Debt % of A.V.: 7.77% Total Direct and Overlapping Debt per Capita: $7,859 * Gross Debt r• This section contains excerpt(s) from or a summary of filings made by or on behalf of the issuer. The information below is an extract or summary only. The complete filing should be viewed on the Texas MAC website (www.mactexas.com) or the Electronic Municipal Market Access (EMMA) System of the Municipal Securities Rulemaking Board (https: / /emma.msrb.org /). See TMR disclaimer at the bottom of this page. 11/16/2015 - Standard & Poor's Underlying: Upgrade on 05/28/2014 "On May 28, 201.4, Standard and Poor's ( "S &P ") upgraded the rating on the City's existing general obligation debt from "AA" to "AA + ". "Notice of this event was timely filed on May 28, 2014, but was inadvertently associated with the wrong base CUSIP for outstanding City debt. Accordingly, this filing is made to correct this technical error." 05/19/201.5 - Standard & Poor's Underlying: Upgrade on 05/08/201.5 "Standard & Poor's Rating Services upgraded the rating for the general obligation debt of Bexar County from 'AA +" (Positive Outlook) to "AAA" (Stable Outlook), due primarily to the county's consistent trend of improved budgetary performance and the continued growth and diversification of the county's economic base." 05/28/2014 - S &P Underlying Rating Upgrade "Standard & Poor's Ratings Services raised its rating on Schertz, Texas' general obligation (GO) debt one notch to 'AA +' from 'AA'. The stable outlook reflects Standard & Poor's opinion of Schertz's very strong budget flexibility and liquidity, supported by a strong management team and economy." The City of Schertz is a retail center and fast - growing suburb located approximately 20 miles northeast of San Antonio and is between the Cities of San Antonio and New Braunfels, on Interstate 35 and FM 78 and on Interstate 10. between San Antonio and Seguin. The City is near the center of the San Antonio Metropolitan Statistical Area. The City serves an agricultural area in the process of transforming into an urban setting with rapid growth. The City is located in Guadalupe County with a portion extending into Bexar and Comal Counties. The City's 2010 census was 31,465, increasing 68.32% since 2000. COUNTY CHARACTERISTICS: Guadalupe County was created and organized in 1846 from Bexar and Gonzales Counties and named after the Guadalupe River, which runs through the middle. The county is located in south central Texas and traversed by Interstate Highways 10 and 35. COUNTY SEAT: Seguin 2010 census: 131,533 increasing 47.8% since 2000 2000 census: 89,023 increasing 37.2% since 1990 1990 census: 64,873 ECONOMIC BASE Mineral: oil, gravel, gas and clay. Industry: varied manufacturing and agribusiness ,.i'. ., o .., .. i Schertz, City Texas Municipal Reports "C I i ➢, (General Obligation Debt) Last Revised: 4/2/2019 ' TMR # 2302 ,f- Guadalupe, Bexar, Comal Counties Page 13 of 14 Agricultural: wheat, pecans, nursery crops, mild, hay, cotton, corn and cattle OIL AND GAS - 2018 The oil production for this county accounts for 0.06% of the total state production. The county ranks 88 out of all the counties in Texas for oil production. OIL PRODUCTION (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2015 Oil 741,580 BBL -17.31 2016 Oil 708,784 BBL -4.42 2017 Oil 658,374 BBL -7.11 2018 Oil 648,064 BBL -1.57 CASINGHEAD (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2015 Casinghead 35,184 MCC -19.20 2016 Casinghead 38,784 MCF 10.23 2017 Casinghead 10,649 MCF -72.54 2018 Casinghead 10 MCF -99.91 RETAIL SALES & EFFECTIVE BUYING INCOME (The Nielsen Company) Year 2018 2017 2016 Retail Sales $2.9B $1.3B $1.4B Effective Buying Income (EBI) $4.OB $3.8B $3.4B County Median Household Income $59,902 $56,645 $53,189 State Median Household Income $61,175 $57,227 $55,352 % of Households with EBI below $25K 16.3% 16.6% 9.4% % of Households with EBI above $25K 70.3% 71.5% 70.9% EMPLOYMENT DATA (Texas Workforce Commission) 2018 2017 2016 Employed Earnings Employed Earnings Employed Earnings 1st Q: 41,005 $449.6M 39,254 $403.6M 37,487 $366.611 end Q: 41,561 $457.7M 40,377 $426.3M 38,428 $383.111 3rd Q: 41,703 $450.2M 41,313 $428.6M 38,632 $397.611 4th Q: N/A N/A 41,556 $455.3M 39,745 $416.4M MAJOR COLLEGES AND UNIVERSITIES: Texas Lutheran University COLLEGES AND UNIVERSITIES Year Total Fall Enrollment 2018 1 1,447 2017 1 1,394 2016 1 1,295 2015 1 1,373 2014 1 1,319 2013 1 1,338 2012 1 1,317 2011 1 1,415 2010 1 1,340 2009 1 1,387 2008 1 1,432 Major Employers # Employees Schertz /Cibolo /UC ISO 1,837 Education 1.58% Amazon.com 900 Online Retail 1.38% Sysco Central Texas 807 Food Distributor 0.94% Baker Hughes, a GE Company 500 Oil & Gas The Brandt Companies, LLC 476 Engineering FedEx Ground 462 Package Shipping Company Visionworks 396 Optical Goods Republic Beverage Company 372 Beverage Services FEB Grocery Co. 350 Grocery Store City of Schertz 316 Government Source: City of Schertz CAFR dated September 30, 2018. TOP TAXPAYERS Principal Taxpayers 1. Caterpillar Equipment 2. Sysco Central Texas Food Packaging /Processing 3. Amazon LLC Wholesale Supplier /Distribution Center 4. US Real Estate LP Commercial Land 5. Republic Beverage Co. Wholesale Supplier /Distribution Center 6. Colfin 2018 -3 Industrial Owner LLC Commercial Land 7. Shell US Gas & Power LLC Oil & Gas 8. GE Oil & Gas Inc. Oil & Gas 9. SA WFR Partners LLC Apartments 10. EM LP Commercial Land Total: Mayor Michael Carpenter 1400 Schertz Parkway Schertz, TX 78154 Phone: 210 -619 -1040 Fax: 210 -619 -1039 mcarpenter @schertz.com City Manager Dr. Mark Browne 1400 Schertz Parkway Schertz, TX 78154 Phone: 210- 619 -1000 Fax: 210 -619 -1039 mbrowne @schertz.com City Secretary Brenda Dennis 1400 Schertz Parkway Schertz, TX 78154 Phone: 210- 619 -1030 Fax: 210- 619 -1039 bdennis @schertz.com Director of Finance James Walters 1400 Schertz Parkway Schertz, TX 78154 Phone: 210- 619 -1140 Fax: 210 - 619 -1039 2018 A. V. % of A. V. $127,829,440 3.15% 108,437,649 2.67% 64,043,532 1.58% 60,564,813 1.49% 56,088.100 1.38% 44,527,470 1.10% 37.942.000 0.94% 28,301,316 0.70% 26,108.900 0.64% 20,176,800 0.50% - - - -- - - - - -- $574.020.020 14.15% . �. .t tom.. �. .. .. .� ;; <, ,z '.. "t �. ,.. ,. i .,, t , ,. i' t f'r 4 Iff �. .4 ,� Schertz, City Texas Municipal Reports ,_' i ➢, (General Obligation Debt) Last Revised: 4/2/2019 ' TMR # 2302 ,f- Guadalupe, Bexar, Comal Counties Page 14 of 14 jwalters @schertz.com Tax Assessor /Collector Daryl John Guadalupe County Tax Office 307 W Court St. Seguin, TX 78155 Phone: 830- 303 -3421 Fax: 830 - 372 -9940 daryl.john @co.guadalupe.tx.us Chief Appraiser Jamie Osborne Guadalupe Appraisal District 3000 N Austin St. Seguin, TX 78155 Phone: 830- 303 -3313 Fax: 830 -372 -2874 gadprotest @guadalupead.org Chief Appraiser Rufino Lozano Comal County Appraisal District 900 S. Seguin Ave. New Braunfels, TX 78131 Phone: 830 - 625 -8597 Fax: 830- 625 -8598 lozanr @co.comal.tx.us Chief Appraiser Michael Amezquita Bexar County Appraisal District 411 N. Frio San Antonio, Tx 78207 Phone: 210 - 224 -8511 Fax: 210 - 242 -2454 cs @bcad.org i . Uf r _ c ,; z/ i t Government Corp Texas Municipal Reports 'IC � p i (San Antonia Water System Expansion) Last Revised: 10/24/2018 o TIVIR # 2854 ,f- Guadalupe County Page 1 of 4 FINANCIAL STATEMENT FOR OTHER BONDS FOR THIS ISSUER, SEE SEPARATE MUNICIPAL REPORTS FINANCIAL STATEMENT (As of September 30, 2017) Special Obligation Debt Senior Lien $23,660,000 PAYMENT RECORD Never defaulted. DETAILS OF OUTSTANDING DEBT Details of Senior Lien Debt (Outstanding 9/3012017) Contract Rev Bds Ser 2012 (San Antonio Water System Expansion Water Treatment Project 2) Lien: Senior Tax Treatment: Tax Exempt Original Issue Amount $25,425,000.00 Dated Date: 06/01/2012 Sale Date: 06/19/2012 Delivery Date: 07/19/2012 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 0210112013 Paying Agent: Regions Bank, Houston, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Co- Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Piper Jaffray & Co. Co- Manager: Allison, M.E. & Co., Inc. Co- Manager: BBC Capital Markets Underwriter's Counsel: Andrews Kurth L.L.P. Use of Proceeds: Water. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 620,000.00 02/01/2019 645,000.00 0210112020 670,000.00 0210112021 700,000.00 0210112022 725,000.00 0210112023 755,000.00 0210112024 785,000.00 02/01/2025 815,000.00 02/01/2026 840,000.00 0210112027 865,000.00 02/01/2032T 4,825,000.00 02/01/2041T 11,415,000.00 4.0000% 1.4508 4.0000% 1.750% 4.0000% 2.050% 4.0000% 2.300% 4.0000% 2.490% 4.0000% 2.710% 4.0000% 2.910% 3.0000% 3.140% 3.0000% 3.230% 3.1250% 3.320% 3.6250% 3.8507 4.0000% 4.090% $23,660,000.00 Call Option: Bonds maturing on 0210112021 to 0210112027 and term bonds maturing on 0210112032 and 0210112041 callable in whole or in part on any date beginning 0210112020 @ par. Term Call: Term bonds maturing on 0210112032: Mandatory Redemption Date Principal Amount 0210112028 $895,000 02/01/2029 $930,000 0210112030 $965,000 02/01/2031 $1.000.000 02/01/2032 $1,035,000 Term bonds maturing on 02/01/2041: Mandatory Redemption Date Principal Amount 02/01/2033 $1,075,000 02/01/2034 $1,120,000 02/01/2035 $1,165,000 02/01/2036 $1,210,000 02/01/2037 $1,260,000 02/01/2038 $1,315,000 02/01/2039 $1,365,000 0210112040 $1,425,000 0210112041 $1,480.000 Grand Total _ ______________> $23,660,000.00 Bond Debt Service Period Ending Principal Interest Debt Service 09/30/18 620,000.00 02.62% 891,787.50 09/30/2019 1,511,787.50 09/30/1.9 645,000.00 09/30/2020 866,487.50 08.18% 1,511,487.50 09/30/20 670,000.00 11.14% 840,187.50 0913012022 1,510,187.50 09/30/21 700,000.00 09/30/2023 812,787.50 17.39% 1,512,787.50 09/30/22 725,000.00 20.71% 784,287.50 09/30/2025 1,509,287.50 09/30/23 755,000.00 09/30/2026 754,687.50 27.70% 1,509,687.50 09/30/24 785,000.00 31.36% 723,887.50 09/30/2028 1,508,887.50 09/30/25 815,000.00 09/30/2029 695,962.50 39.07% 1,510,962.50 09/30/26 840,000.00 43.15% 671,1.37.50 1,511,137.50 09/30/27 865,000.00 645,021.88 1,510,021.88 09/30/28 895,000.00 615,284.38 1,510,284.38 09/30/29 930,000.00 582,206.25 1,512,206.25 09/30/30 965,000.00 547,859.38 1,512,859.38 09/30/31 1,000,000.00 512,243.75 1,512,243.75 09/30/32 1,035,000.00 475,359.38 1,510,359.38 09/30/33 1,075,000.00 435,1.00.00 1,510,100.00 09/30/34 1,120,000.00 391,200.00 1,511,200.00 09/30/35 1,165,000.00 345,500.00 1,510,500.00 09/30/36 1,210,000.00 298,000.00 1,508,000.00 09/30/37 1,260,000.00 248,600.00 1,508,600.00 09/30/38 1,315,000.00 197,100.00 1,512,100.00 09/30/39 1,365,000.00 143,500.00 1,508,500.00 09/30/40 1,425,000.00 87,700.00 1,512,700.00 09/30/41 1,480,000.00 29,600.00 1,509,600.00 23,660,000.00 12,595,487.50 36,255,487.50 COMPUTED ON BASIS OF MANDATORY REDEMPTION Debt Amortization Rates % of Principal Period Ending Principal Retired 09/30/2018 620,000.00 02.62% 09/30/2019 645,000.00 05.35% 09/30/2020 670,000.00 08.18% 09/30/2021 700,000.00 11.14% 0913012022 725,000.00 14.20% 09/30/2023 755,000.00 17.39% 09/30/2024 785,000.00 20.71% 09/30/2025 815,000.00 24.15% 09/30/2026 840,000.00 27.70% 09/30/2027 865,000.00 31.36% 09/30/2028 895,000.00 35.14% 09/30/2029 930,000.00 39.07% 09/30/2030 965,000.00 43.15% r r n c, r, t , �" ,� .. .. '` ,; Schertz/Seguin i t Government Corp Texas Municipal Reports "o p i (San Antonia Water System Expansion) Last Revised: 10/24/2018 o TMR # 2854 ,f- Guadalupe County Page 2 of 4 09/30/2031 1,000,000.00 47.38% 09/30/2032 1,035,000.00 Year Ended 51.75% $2,467,171 09/30/2033 1,075,000.00 09 -30 -2015 56.30% Revenues: 09/30/2034 1,120,000.00 85.399 61.03% Water Revenue 09/30/2035 1,165,000.00 $16,278,709 65.96% Impact Fees 09/30/2036 1,210,000.00 910,030 71.07% Reservation Fees 09/30/2037 1,260,000.00 0 76.39% Lease Revenue 09/30/2038 1,315,000.00 129,600 81.95% Other 09/30/2039 1,365,000.00 158,800 87.72% 09/30/2040 1,425,000.00 93.74% 09/30/2041 1,480,000.00 100.00% SECURITY The Series 2012 bonds are special limited obligations of the Schertz /Seguin Local Government Corporation payable and secured solely by a lien on and pledge of the bonds payment portion of the annual payments to be paid independently by the City of San Antonio to the Corporation pursuant to the Mutual Regional Water Supply Contract, dated as of January 1, 2011, among the Corporation, San Antonio Water System (SAWS), City of Schertz and the City of Seguin. The Bonds are also secured by a lien on and pledge of the money in all funds created, established and maintained by a Resolution. RESERVE FUND The Corporation has not created, and there does not exist, a debt service reserve fund relating to or providing additional security for the bonds, though the Corporation has, in the Resolution, reserved the right to create such a debt service reserve fund in conjunction with the future issuance of additional bonds or additional obligations. RATES AND CHARGES The Corporation has covenanted, while any of the bonds are outstanding to establish and maintain rates and charges for facilities and services afforded by the system that are reasonably expected, on the basis of available information and experience and with due allowance for contingencies to produce gross revenues in each year sufficient (i) to pall all maintenance and operating expenses, (ii) to produce net revenues sufficient to pay the debt service on any prior lien obligations issued by the Corporation and any amounts required to be on deposit, (iii) to produce net revenues sufficient to pay the debt service on any junior lien obligations issued by the Corporation and any amounts required to be on deposit, (iv) to produce net revenues sufficient to pay the debt service on and inferior lien obligations issued by the Corporation and any amounts required to be on deposit, and (v) to produce net revenues to pay debt service on the bonds similarly secured as the same become due and payable and to deposit the amounts required to be deposited in any special fund or account. ADDITIONAL BONDS The Corporation reserves the right to issue additional obligations that are payable from a lien on and pledge of the Pledged Revenues on parity with the lien thereon and pledge thereof securing the bonds and additional obligations without limitation as to principal amount but subject to any terms, conditions or restrictions as may be applicable thereto under law or otherwise. PROJECT SAWS desires to obtain additional water supply to supplement its existing sources, and has identified excess water supply of the Corporation, derived from the Corporation's own and existing resources, and the development by SAWS of its own well field in western Gonzales County, which is in the vicinity of the system but farther from the SAWS System, as sources for this excess water supply. SCHERTZ /SEGUIN LOCAL GOVERNMENT CORPORATION Lease Payments Fiscal Year Ended $2,234,066 $2,467,171 09 -30 -2017 09 -30 -2016 09 -30 -2015 09 -30 -2014 Revenues: Amortization Expense 80,156 85.399 85,399 Water Revenue $16,415,653 $14,675,393 $16,278,709 $13,790,208 Impact Fees 849,289 927,843 910,030 449,997 Reservation Fees 0 0 0 269,000 Lease Revenue 53,698 146,214 129,600 93,369 Other 349,871 260,967 158,800 124,447 7, = J 'A. JI ., _, .. -- - - - - -- -- - - - - -- -- - - - - -- -- - - - - -- Total Revenues $17,668,511 $16.010,417 $17,477,139 $14,727,021 Expenses: Lease Payments $2,414,771 $2,252,353 $2,234,066 $2,467,171 Depreciation 2,436,451 2,395,014 1,962,622 1,547,003 Amortization Expense 80,156 85.399 85,399 85.399 Other 4,188,273 4,574,831 4,735,359 3,256,985 Total Expenses $9,119,651 $9,307,597 $9,017,446 $7,356,558 Available For Debt Service $8,548,860 $6,702,820 $8,459,693 $7,370,463 Nonoperating Income (Expense) Interest Income $ 772,494 $ 85,829 $ 17,595 $ 14,551 Contribution from Cities of Schertz & Seguin -0- -0- -0- (269,000) Interest Expense (5,131,266) (4,313,689) (2,668,447) (3,521,370) Gain (Loss) on Disposal of Assets 1,414 -0- (912,761) -0- Bond Issuance Costs (916,291) -0- -0- -0- ---------- ---- - - - - -- ---- - - - - -- ---- - - - - -- Change in Net Assets $ 3,275,211 $ 2,474,960 $ 4,896,080 $ 3,594,644 Beg. Balance 10 -1 $12,892,618 $10,417,658 $ 5,521,578 $ 1,926,934 End. Balance 9 -30 $16,167,829 $12,892,618 $10,417,658 $ 5,521,578 NON FUND DEBT NON- FUNDED DEBT PAYABLE (As of September 30, 2017) None. MATERIAL EVENTS AND OTHER FILINGS This section contains excerpt(s) from or a summary of filings made by or on behalf of the issuer. The information below is an extract or summary only. The complete filing should be viewed on the Texas MAC website (www.mactexas.com) or the Electronic Municipal Market Access (EMMA) System of the Municipal Securities Rulemaking Board (https: / /emma.msrb.org /). See TMR disclaimer at the bottom of this page. 10/17/2018 - Notice of Failure to File Disclosure - City of Seguin (FYE 2013, 2014, 2016 & 2017) "The audits for the City of Seguin, Texas for the years 2013, 2014, 2016 and 2017 were not filed under the Schertz /Seguin Local Government Corporation CUSIPs. The issuer has implemented procedures in an attempt to eliminate future non - compliance in accordance with the Rule." 10/02/2018 - Notice of Failure to File Disclosure - City of Schertz (FYE 2013, 2014, 2016 & 2017) "Certain tables associated with the City of Schertz's Utility System were not updated in accordance to the Rule. The City of Schertz audits for the years 2013, 2014, 2016 and 2017 were not filed under this CUSIP. This filing includes all required information. "The issuer has implemented procedures in an attempt to eliminate future noncompliance in accordance with the Rule." 11/26/2014 - Standard & Poor's Underlying: Upgrade on 11/25/2014 "Standard & Poor's Ratings Services has raised its rating on Schertz /Seguin Local Government Corp., Texas' existing contract revenue debt issued for Schertz and Seguin one notch to 'A +' from 'A'. Standard & Poor's has also assigned its 'A +' rating to the LGC's series 2015 contract revenue improvement and refunding bonds. The outlook is stable." ,; Schertz/Seguin i t Government Corp Texas Municipal Reports 'Ic p i (San Antonia Water System Expansion) Last Revised: 10/24/2018 o TMR # 2854 ,f- Guadalupe County Page 3 of 4 SCHERTZ /SEGUIN LOCAL GOVERNMENT CORPORATION Schertz /Seguin Local Government Corporation is a public, non - profit corporation created by the Cities of Schertz and Seguin, Texas, pursuant to Subchapter D of Chapter 431, Texas Transportation Code, as amended. The Corporation was formed on December 23, 1998, among other things, for the purpose to assist, and act on behalf of the cities in acquiring, constructing, leasing, improving, enlarging, extending, repairing, maintaining, developing and operating a wholesale water utility supply system pursuant to the provisions of Texas Local Government Code 402.001. (Chapter 402) and other applicable laws of the State and to assist and act on behalf of the Cities of Schertz and Seguin in accomplishing a governmental purpose in the provision of water for public use. The Corporation is governed by a board of 5 directors appointed by the City Councils of the Cities. The Corporation is not authorized to levy a tax COUNTY CHARACTERISTICS: Guadalupe County was created and organized in 1846 from Bexar and Gonzales Counties and named after the Guadalupe River, which runs through the middle. The county is located in south central Texas and traversed by Interstate Highways 10 and 35. COUNTY SEAT: Seguin 2010 census: 131,533 increasing 47.8% since 2000 2000 census: 89,023 increasing 37.2% since 1990 1990 census: 64,873 ECONOMIC BASE Mineral: oil, gravel, gas and clay. Industry: varied manufacturing and agribusiness. Agricultural: wheat, pecans, nursery crops, mile, hay, cotton, corn and cattle. OIL AND GAS - 2017 The oil production for this county accounts for 0.07% of the total state production. The county ranks 86 out of all the counties in Texas for oil production. OIL PRODUCTION (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2014 Oil 896.850 BBL -7.31 2015 Oil 741,580 BBL -17.31 2016 Oil 708,784 BBL -4.42 2017 Oil 658,374 BBL -7.11 CASINGHEAD (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2014 Casinghead 43,544 MCF 43.82 2015 Casinghead 35,184 MCF -19.20 2016 Casinghead 38,784 MCF 10.23 2017 Casinghead 10,649 MCF -72.54 RETAIL SALES & EFFECTIVE BUYING INCOME (The N Year 2017 Retail Sales $1.3B Effective Buying Income (EBI) $3.8B County Median Household Income $56,645 State Median Household Income $57,227 % of Households with ENT below $25K 16.6% % of Households with EBI above $25K 71.5% elsen Company) 2016 2015 $1.4B $1.5B $3.4B $3.5B $53,189 $58,134 $55,352 $53,037 9.4% 8.0% 70.9% 70.5% EMPLOYMENT DATA (Texas Workforce Commission) 2018 2017 2016 Employed Earnings Employed Earnings Employed Earnings 1st Q: 41,033 $453.9M 39,254 $403.6M 37,487 $366.6M 2nd Q: N/A N/A 40,377 $426.3M 38,428 $383.1M 3rd Q: N/A N/A 41,313 $428.6M 38,632 $397.6M 4th Q: N/A N/A 41,556 $455.311 39,745 $416.4M MAJOR COLLEGES AND UNIVERSITIES: Texas Lutheran University COLLEGES AND UNIVERSITIES Year Total Fall Enrollment 2017 1 1,394 2016 1 1,295 2015 1 1,373 2014 1 1,319 2013 1 1,338 2012 1 1,317 2011 1 1,415 2010 1 1,340 2009 1 1,387 2008 1 1,432 General Manager R. Alan Cockerell Schertz- Seguin Local Government Corporation 205 N River Street Seguin, TX 78155 Phone: 830 - 401 -2302 Fax: 830 - 386 -2588 acockerell @seguintexas.gov Assistant General Manager Amber Briggs -Beard Schertz /Seguin Local Government Corporation 205 N River Street Seguin, TX 78155 Phone: 830 - 401 -2409 Fax: 830 -401 -2320 abriggs @seguintexas.gov City Manager Dr. Mark Browne 1400 Schertz Parkway Schertz, TX 781,54 Phone: 210 -619 -1000 Fax: 210 -619 -1139 mbrowne @schertz.com City Manager Douglas Faseler 205 N River Street Seguin, TX 78155 -0591 Phone: 830 - 401 -2302 Fax: 830- 386 -2588 dfaseler @seguintexas.gov Director of Finance James Walters 1400 Schertz Parkway Schertz, TX 78154 Phone: 210 -619 -1140 Fax: 210 -619 -1149 jwalters @schertz.com Director of Finance Susan Caddell 205 N River Street Seguin, TX 78155 -0591 Phone: 830 -401 -2450 Fax 830 -401 -2499 scaddell @seguintexas.gov <, r. ry Y 1, � „ Schertz/Seguin Local Government Corp Texas Municipal Reports (San Antonio Water System Expansion) Last Revised: 10/24/2018 Guadalupe County Page 4 of 4 act mxmx nmu000nnme��um.a�cnmmenuamm.enuom�men�o,wun�muoun�uuvn,omoanvaeou���mo/muumrmww.cxua c�m."r�oo�me/�avaranuonmmov�e anummurn^o�r�,�n�uunu.w�nmnuem�nua�meemouo�.meoum���nenm�oonu�u��ouu,mmnm�/onmm/auonnenuv.m/o��enmec�.munnauvnao�ma�u� yex�a �um�oame.uu�me��oxoanm/nu��nuenmv,enn,�oun�m�nnouo"rxe��om��noanv�/amu/n�anv��nonm/�m��r. o �ommmnmauv"um��n.nm/urmT!�ueumen ���n�/nmmrmm.anunn��onmnnnuaeca/��uvme�woonmmm/ooue,Tx/or��wmuaupua�u/nmno�mm�ooue�aannnooa��c���momm�/�mu�r`uu�mm m�oopeomca/�u/��m/mmo"v�o»nno/m/nxunuo/mamrxee�umrmm/snmn/uouw�mmou�mnummn�.m"nn�/onmzmomeroou��muam�momnuo,p/mmumen�ue�a/un �mpo�momeaeourmeo��/n�euac ,; z/ i t Government Corp Texas Municipal Reports "C ➢, (Schertz & Seguin, Cities of, Project) Last Revised: 11/19/2018 o TIVIR # 1764 - ,f- Guadalupe County Page 1 of 7 FOR OTHER BONDS FOR THIS ISSUER, SEE SEPARATE MUNICIPAL REPORTS FINANCIAL STATEMENT (As of September 30, 2017)(a) Special Obligation Debt Senior Lien Junior Lien Special Fund Balances Debt Service Repair & Replacement Reserve $11,025,000 $130,550,000 $141,575,000 $882,168 $500,000 $1,297,887(b) (a) Includes Contract Revenue Refunding Bonds New Series 2018 dated November 1, 2018. (b) Cash balance. Excludes surety bonds for Series 2001. PAYMENT RECORD Never defaulted. DETAILS F OUTSTANDING DEBT Details of Senior Lien Debt (Outstanding 9/30/2017) Contract Rev Bds Ser 2001 Lien: Senior Tax Treatment: Tax Exempt Original Issue Amount $41,040,000.00 Dated Date: 0210112001 Sale Date: 0212212001 Delivery Date: 03/15/2001 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 02101, 08/01 1st Coupon Date: 08/01/2001 Paying Agent: The Bank of New York Mellon Trust Company, N.A., New York, NY Bond Counsel: Fulbright & Jaworski Financial Advisor: Southwest Securities, San Antonio, TX Co- Financial Advisor: SAMCO Capital Markets Lead Manager: First Southwest Company Co- Manager: Coastal Securities Co- Manager: Dain Rauscher Incorporated Co- Manager: PaineWebber Incorporated Insurance: Assured Guaranty Municipal Corp. (FSA) Use of Proceeds: Utility. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2035T 10,000,000.00 5.2000% 100.00% $10,000,000.00 Call Option: Non Callable Term Call: Term bonds maturing on 02/01/2035: Mandatory Redemption Date Principal Amount 02/01/2031 $1,795,000 02/01/2032 $1,895,000 02/01/2033 $1,995,000 02/01/2034 $2,100,000 0210112035 $2,215.000 Refunded Notes: Maturities refunded by Contract Revenue & Ref Bus Ser 2007 Refunded Amount Mat Date Coupon Price Schell Call 290,000.00 0210112012 4.500 Par 0210112011 305,000.00 02/01/2013 4.625 Par 0210112011 310,000.00 0210112014 4.700 Par 0210112011 325,000.00 02/01/2015 4.800 Par 0210112011 340,000.00 02/01/2016 5.000 Par 0210112011 350,000.00 0210112017 5.000 Par 0210112011 375,000.00 02/01/2018 5.000 Par 0210112011 390,000.00 02/01/2019 5.125 Par 02/01/2011 410,000.00 02/01/2020 5.125 Par 0210112011 10,000,000.00 0210112030 5.375 Par 0210112011 4,765,000.00 0210112037 5.250 Par 0210112011 11,185,000.00 0210112041 5.250 Par 0210112011 Contract Rev Bds Ser 2010 Lien: Senior Tax Treatment: Bank Qualified Original Issue Amount $22,140,000.00 Dated Date: 06/01/2010 Sale Date: 06/15/2010 Delivery Date: 07/14/2010 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 0210112011 Paying Agent: Wells Fargo Bank, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Co- Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Coastal Securities, Inc. Co- Manager: Allison, M.E. & Co., Inc. Co- Manager: NBC Capital Markets Insurance: Assured Guaranty Municipal Corp. (FSA) Use of Proceeds: Utility. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 505,000.00 15000% 1250% 02/01/2019 520,000.00 3.5000% 3.450% ------------------------------------------- - - - - -- $1.025,000.00 Call Option: Non - callable Refunded Notes: Maturities refunded by Contract Rev Ref Bds New Ser 2018 Refunded Amount Mat Date Coupon Price Schell Call 540,000.00 0210112020 1500 Par 02/01/2019 560,000.00 0210112021 4.000 Par 02/01/2019 585,000.00 0210112022 4.000 Par 02/01/2019 610,000.00 0210112023 4.000 Par 02/01/2019 630.000.00 0210112024 4.000 Par 02/01/2019 660,000.00 0210112025 4.000 Par 02/01/2019 685,000.00 0210112026 4.125 Par 02/01/2019 715,000.00 0210112027 4.250 Par 02/01/2019 745,000.00 0210112028 4.250 Par 02/01/2019 780,000.00 02/01/2029 4.250 Par 02/01/2019 815,000.00 02/01/2030 4.500 Par 02/01/2019 850.000.00 0210112031 4.500 Par 02/01/2019 890,000.00 0210112032 4.500 Par 02/01/2019 2,925,000.00 02/01/2035 4.625 Par 02/01/2019 3,370,000.00 02/01/2038 4.750 Par 02/01/2019 3,890,000.00 0210112041 4.750 Par 02/01/2019 r vn ,; z/ i t Government Corp Texas Municipal Reports "o ➢, (Schertz & Seguin, Cities of, Project) Last Revised: 11/19/2018 o TIVIR # 1764 - ,f- Guadalupe County Page 2 of 7 Grand Total _ ______________> $11,025,000.00 Bond Debt Service Period Ending Principal Interest Debt Service 09/30/18 09/30/1.9 09/30/20 09/30/21 09/30/22 09/30/23 09/30/24 09/30/25 09/30/26 09/30/27 09/30/28 09/30/29 09/30/30 09/30/31 09/30/32 09/30/33 09/30/34 09/30/35 505,000.00 520,000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1,795,000.00 1,895,000.00 1,995,000.00 2,100,000.00 2,215,000.00 1,406,300.00 529,100.00 520,000.00 520,000.00 520,000.00 520,000.00 520,000.00 520,000.00 520,000.00 520,000.00 520,000.00 520,000.00 520,000.00 473,330.00 377,390.00 276,250.00 169,780.00 57,590.00 1,911,300.00 1,049,100.00 520,000.00 520,000.00 520,000.00 520,000.00 520,000.00 520,000.00 520,000.00 520,000.00 520,000.00 520,000.00 520,000.00 2,268,330.00 2,272,390.00 2,271,250.00 2,269,780.00 2,272,590.00 11,025,000.00 9,009,740.00 20,034,740.00 COMPUTED ON BASIS OF MANDATORY REDEMPTION Debt Amortization Rates % of Principal Period Ending Principal Retired 09/30/2018 505,000.00 Sale Date: 09/16/2014 04.58% 10/15/2014 09/30/2019 520,000.00 Record Date: MSRB 09.30% BE 09/30/2020 $5.000 0.00 0210112021 09.30% 02/01/2015 0913012021 2.050% 0.00 590,000.00 09.30% 3.0000% 09/30/2022 0210112023 0.00 09.30% 2.600% 09/30/2023 630,000.00 0.00 3.5000% 09.30% 02/01/2025 09/30/2024 0.00 2.900% 09.30% 09/30/2025 0.00 09.30% 09/30/2026 0.00 09.30% 09/30/2027 0.00 09.30% 09/30/2028 0.00 09.30% 09/30/2029 0.00 09.30% 09/30/2030 0.00 09.30% 09/30/2031 1,795,000.00 25.58% 09/30/2032 1,895,000.00 42.77% 09/30/2033 1,995,000.00 60.86% 09/30/2034 2,100,000.00 79.91% 09/30/2035 2.215.000.00 100.00% Details of Junior Lien Debt (Outstanding 9130/2017) Contract Rev Ref Bds New Ser 2014 Lien: Junior Tax Treatment: Bank Qualified Original Issue Amount $6,275,000.00 Dated Date: 09/01/2014 Sale Date: 09/16/2014 Delivery Date: 10/15/2014 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5.000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 02/01/2015 Paying Agent: Regions Bank, Houston, TX Bond Counsel: Fulbright & Jaworski LLP Financial Advisor: Southwest Securities, San Antonio, TX Co- Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Raymond James Co- Manager: Allison, M.E. & Co., Inc. Underwriter's Counsel: Andrews Kurth L.L.P. Insurance: Build America Mutual Use of Proceeds: Refunding. Refunding Notes: This bond refunded maturities from the following issues: Contract Rev Ref Bds Ser 2005 Refunded Amount Mat Date Coupon Price Sched Call 475,000.00 02/01/2015 4.000 Par 1012112014 495,000.00 02/01/2016 4.000 Par 1012112014 520.000.00 0210112017 4.000 Par 1012112014 540,000.00 0210112018 4.000 Par 1012112014 560,000.00 02/01/2019 4.000 Par 10/21/2014 585,000.00 0210112020 4.100 Par 1012112014 610,000.00 0210112021 4.150 Par 10/21/2014 635,000.00 0210112022 4.200 Par 1012112014 665,000.00 0210112023 4.250 Par 1012112014 695.000.00 0210112024 4.300 Par 1012112014 725,000.00 0210112025 4.375 Par 1012112014 Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 530,000.00 Sale Date: 2.0000% 1.200% 02/01/2019 540.000.00 Negotiated 2.0000% 1.600% 0210112020 555,000.00 Denomination 10000% 1.850% 0210112021 570.000.00 02/01/2015 10000% 2.050% 0210112022 590,000.00 3.0000% 2.350% 0210112023 610,000.00 3.5000% 2.600% 0210112024 630,000.00 3.5000% 2.750% 02/01/2025 655,000.00 3.5000% 2.900% $4.680.000.00 Call Option: Bonds maturing on 0210112023 to 02/01/2025 callable in whole or in part on any date beginning 0210112022 @ par. Contract Rev Imp & Ref Bds New Ser 2015 Lien: Junior Tax Treatment: Tax Exempt Original Issue Amount $41,720,000.00 Dated Date: 1210112014 Sale Date: 1210212014 Delivery Date: 01/13/2015 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 02/01/2015 Paying Agent: Regions Bank, Houston, TX Bond Counsel: Fulbright & Jaworski LLP Financial Advisor: Southwest Securities, San Antonio, TX Co- Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Raymond James Co- Manager: Allison, M.E. & Co., Inc. Co- Manager: RBC Capital Markets Underwriter's Counsel: Andrews Kurth L.L.P. Insurance: Build America Mutual D. v ... _ Schertz/Seguin Local Government Corp Texas Municipal Reports ➢, (Schertz & Seguin, Cities of, Project) Last Revised: 11/19/2018 o TMR # 1764 - ,f- Guadalupe County Page 3 of 7 Use of Proceeds: Refunding. Refunding Notes: This bond refunded Contract Revenue & Ref Bds Ser 2007 Refunded Amount Mat Date Coupon 575,000.00 02/01/2016 4.000 590,000.00 0210112017 4.000 620,000.00 02/01/2018 4.000 640,000.00 02/01/2019 4.000 670,000.00 0210112020 4.125 685,000.00 0210112021 4.250 720,000.00 0210112022 4.250 750,000.00 0210112023 4.250 785,000.00 0210112024 4.250 820,000.00 02/01/2025 4.250 1,660,000.00 02/01/2026 4.250 7,405,000.00 02/01/2030 4.500 4,275,000.00 02/01/2036 4.500 15,370,000.00 0210112041 4.500 iaturit Price Par Par Par Par Par Par Par Par Par Par Par Par Par Par es from the following issues_ Sched Call 02/01/2015 02/01/2015 02/01/2015 02/01/2015 02/01/2015 02/01/2015 02/01/2015 02/01/2015 02/01/2015 02/01/2015 02/01/2015 02/01/2015 02/01/2015 02/01/2015 Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 730,000.00 3.0000°% 1.130% 02/01/2019 745,000.00 3.0000% 1.450% 0210112020 775,000.00 3.0000% 1.760% 0210112021 785,000.00 4.0000% 2.060% 0210112022 825,000.00 4.0000% 2.330% 02/01/2023 860,000.00 4.0000% 2.560% 02/01/2024 900,000.00 5.0000% 2.740% 02/01/2025 945,000.00 5.0000% 2.850% 0210112026 1,805,000.00 5.0000% 2.930% 0210112027 1,885,000.00 5.0000% 3.030% 0210112028 1,990,000.00 5.0000% 3.120% 02/01/2029 2,090,000.00 5.0000% 3.180% 02/01/2030 2,190,000.00 5.0000% 3.260% O2/01/2033T 1,650,000.00 5.0000% 3.390% O2/01/2O41T 20,950,000.00 4.0000% 4.062% O2/01/2O44T 1,200,000.00 4.0000% 4.066% $40,325,000.00 Call Option: Bonds maturing on 0210112024 to 0210112030 and term bonds maturing on 02/01/2033 and 0210112041 and 02/01/2044 callable in whole or in part on any date beginning 02/01/2023 @ par. Term Call: Term bonds maturing on 02/01/2033: Mandatory Redemption Date Principal Amount 02/01/2031 $520.000 0210112032 $550,000 02/01/2033 $580.000 Term bonds maturing on 0210112041: 08/01/2016 Mandatory Redemption Date Principal Amount 02/01/2034 $610.000 02/01/2035 $630.000 02/01/2036 $2,960,000 0210112037 $3,085,000 02/01/2038 $3,220,000 02/01/2039 $3,345,000 0210112040 $3,480,000 0210112041 $3,620,000 Term bonds maturing on 0210112044: Mandatory Redemption Date Principal Amount 02/01/2042 $385,000 02/01/2043 $400,000 02/01/2044 $415,000 Contract Rev Bds New Ser 2016 (Texas Water Development Board SWIRFT Project Financing) Lien: Junior Tax Treatment: Tax Exempt Original Issue Amount $43,670,000.00 Dated Date: 08/01/2016 Sale Date: 1012012016 Delivery Date: 11/16/2016 Sale Type: Private Placement Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 02101, 08/01 1st Coupon Date: 08/01/2017 Paying Agent: Regions Bank, Houston, TX 08/30/201.6 Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Purchaser: Texas Water Development Board Use of Proceeds: Water. Orig Reoffering Maturity Amount Coupon Price /Yield 08/01/2018 25,000.00 0.6600% N/A 08/01/2019 1,235,000.00 0.7800% N/A 08/01/2020 1,240,000.00 0.8600% N/A 08/01/2021 1,250,000.00 0.9300% N/A 08/01/2022 1,260,000.00 1.0200% N/A 08/01/2023 1,270,000.00 1.1200% N/A 0810112024 1,285,000.00 1.2300% N/A 08/01/2025 1,300,000.00 1.3200% N/A 08/01/2026 1,315,000.00 1.4100% N/A 08/01/2027 1,335,000.00 1.6100% N/A 08/01/2028 1,350,000.00 1.7300% N/A 08/01/2029 1,375,000.00 2.0600% N/A 08/01/2030 1,400,000.00 2.2300% N/A 08/01/2031 1,430,000.00 2.3400% N/A 08/01/2032 1,465,000.00 2.3900% N/A 08/01/2033 1,500,000.00 2_4500% N/A 08/01/2034 1,535,000.00 2.5800% N/A 08/01/2035 1,575,000.00 2.5600% N/A 08/01/2036 1,615,000.00 2.6000% N/A 08/01/2037 1,660,000.00 2.7800% N/A 08/01/2038 1,705,000.00 2.7800% N/A 08/01/2039 1,755,000.00 2.7800% N/A 08/01/2040 1,805,000.00 2.7800% N/A 08/01/2041 1,855,000.00 2.7800% N/A 08/01/2042 1,910,000.00 3.1100% N/A 08/01/2043 1,965,000.00 3.1100% N/A 08/01/2044 2,025,000.00 3.1100% N/A 08/01/2045 2,085,000.00 3.1100% N/A 08/01/2046 2,145,000.00 3.1100% N/A $41670.000.00 Call Option: Bonds maturing on 08/01/2028 to 08/01/2046 callable in whole or in part inversely on any date beginning 08/01/2027 @ par. The Bonds are also subject to Special Mandatory redemption as specified in the authorizing resolution. SWIFT Funding BP Loan Ser 2016 Lien: Junior Tax Treatment: Tax Exempt Original Issue Amount $22,830,000.00 Dated Date: 11/16/2016 Sale Date: 08/30/201.6 Delivery Date: 11/16/2016 Sale Type: Private Placement Record Date: N/A Bond Form: N/A tr'.', J > E ,; z/ i t Government Corp Texas Municipal Reports Fe � ➢, (Schertz & Seguin, Cities of, Project) Last Revised: 11/19/2018 o T 1764 ,f- Guadalupe County Page 4 of 7 Denomination $0 Interest pays Semi- Annually: 02101, 08/01 1st Coupon Date: 08/01/2017 Paying Agent: The Bank of New York Mellon Trust Company, N.A., Dallas, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Purchaser: Texas Water Development Board Use of Proceeds: Project Costs. Orig Reoffering Maturity Amount Coupon Price /Yield 08/01/2035 300,000.00 3.1900% N/A 08/01/2036 700,000.00 3.2400% N/A 08/01/2037 1,125,000.00 3.4600% N/A 08/01/2038 1,165,000.00 3.4600% N/A 08/01/2039 1,205,000.00 3.4600% N/A 08/01/2040 1,250,000.00 3.4600% N/A 08/01/2041 1,290,000.00 3.4600% N/A 08/01/2042 1,340,000.00 3.8800% N/A 08/01/2043 1,390,000.00 3.8800% N/A 08/01/2044 1,440,000.00 3.8800% N/A 08/01/2045 1,490,000.00 3.8800% N/A 08/01/2046 1,545,000.00 3.8800% N/A 08/01/2047 1,605,000.00 3.5800% N/A 08/01/2048 1,660,000.00 3.5800% N/A 08/01/2049 1,715,000.00 3.5800% N/A 08/01/2050 1,775,000.00 3.5800% N/A 08/01/2051 1,835,000.00 3.5800% N/A $22,830,000.00 Call Option: Callable on the date prior to which the Corporation cannot purchase the TWDB's portion of the Project as specified in the authorizing resolution. Contract Rev Ref Bds New Ser 2018 Lien: Junior Tax Treatment: Tax Exempt Original Issue Amount $19,045,000.00 Dated Date: 11/15/2018 Sale Date: 11/01/2018 Delivery Date: 12/13/2018 Sale Type: Negotiated NIC: 3.9032% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 02/01/2019 Paying Agent: Amegy Bank, Houston, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Hilltop Securities Inc. Co- Manager: UBS Financial Services, Inc. Underwriter's Counsel: McCall, Parkhurst & Horton L.L.P., San Antonio, TX Insurance: Build America Mutual Use of Proceeds: Refunding. Refunding Notes: This bond refunded maturities from the following issues Contract Rev Bds Ser 2010 Refunded Amount 540,000.00 560,000.00 585,000.00 610,000.00 630,000.00 660,000.00 Mat Date Coupon 0210112020 3.500 0210112021 4.000 0210112022 4.000 0210112023 4.000 02/01/2024 4.000 02/01/2025 4.000 Price Sched Call Par 02/01/2019 Par 02/01/2019 Par 02/01/2019 Par 02/01/2019 Par 02/01/2019 Par 02/01/2019 685,000.00 0210112026 4.125 Par 0210112019 715,000.00 0210112027 4.250 Par 02/01/2019 745,000.00 0210112028 4.250 Par 02/01/2019 780,000.00 02/01/2029 4.250 Par 02/01/2019 815,000.00 0210112030 4.500 Par 02/01/2019 850,000.00 0210112031 4.500 Par 02/01/2019 890.000.00 0210112032 4.500 Par 02/01/2019 2,925,000.00 02/01/2035 4.625 Par 0210112019 3.370,000.00 02/01/2038 4.750 Par 02/01/2019 3.890.000.00 0210112041 4.750 Par 02/01/2019 Orig Reoffering Maturity Amount Coupon Price /Yield 0210112020 515,000.00 5.0000% 2.140% 0210112021 540,000.00 x^ �,r ... ,. , 5.0000% 2.270% 0210112022 565,000.00 . .. . , .. .. ,. n , , . ... 3.0000% 2.400% 0210112023 590,000.00 5.0000% 2.510% 0210112024 615,000.00 5.0000% 2.650% 02/01/2025 650,000.00 5.0000% 2.760% 02/01/2026 680,000.00 5.0000% 2.940% 0210112027 715,000.00 5.0000% 1080% 02/01/2028 755,000.00 5.0000% 1200% 02/01/2029 795,000.00 5.0000% 3.330% 0210112030 835,000.00 5.0000% 3.430% 02/01/2031 870,000.00 4.0000% 3.560% 0210112032 905,000.00 4.0000% 3.680% 02/01/2033 940,000.00 4.0000% 3.830% 02/01/2034 980,000.00 4.0000% 1930% 02/01/2035 1,020,000.00 4.0000% 1980% 02/01/2036 1,065,000.00 4.0000% 4.030% 0210112037 1,110,000.00 4.0000% 4.060% 02/01/2038 1,150,000.00 4.0000% 4.090% 02/01/2039 1,200,000.00 4.0000% 4.120% 0210112040 1,250,000.00 4.0000% 4.150% 0210112041 1,300.000.00 4.0000% 4.160% $19,045.000.00 Call Option: Bonds maturing on 02/01/2028 to 02/01/2041 callable in whole or in part on any date beginning 0210112027 @ par. Grand Total _ ______________> $130,550,000.00 Bond Debt Service Period Ending Principal Interest Debt Service 09/30/18 09/30/19 09/30/20 09/30/21 09/30/22 09/30/23 09/30/24 09/30/25 09/30/26 09/30/27 09/30/28 09/30/29 09/30/30 09/30/31 09/30/32 09/30/33 09/30/34 09/30/35 09/30/36 09/30/37 09/30/38 1,285,000.00 2,520,000.00 3,085,000.00 3,145,000.00 3,240,000.00 3,330,000.00 3,430,000.00 3,550,000.00 3,800,000.00 3,935,000.00 4,095,000.00 4,260,000.00 4,425,000.00 2,820,000.00 2,920,000.00 3,020,000.00 3,125,000.00 3,525,000.00 6,340,000.00 6,980,000.00 7.240.000.00 3,677,441.00 4,229,731.00 4,408,468.00 4,327,229.00 4,244,029.00 4,154,727.00 4,048,978.00 3,932,935.00 3,802,312.50 3,656,646.00 3,501,52/.50 3,337,422.50 3,161,347.50 3,024,102.50 2,928,390.50 2,828,227.00 2,726,377.00 2,621,974.00 2,458,584.00 2,229,514.00 1.973.141.00 4,962,441.00 6,749,731.00 7,493,468.00 7,4/2,229.00 7,484,029.00 7,484,727.00 7,478,978.00 7,482,935.00 7,602,312.50 7,591,646.00 7,596,52/.50 7,597,422.50 7,586.347.50 5,844,102.50 5,848,390.50 5,848,227.00 5,851,377.00 6,146,974.00 8,798,584.00 9,209.514.00 9.213.141.00 x^ �,r ... ,. , ":7 .. j A .,, .. . . .. . , .. .. ,. n , , . ... �.., .. , ,. �. . .. .. ., i ,; z/ i t Government Corp Texas Municipal Reports Fe � ➢, (Schertz & Seguin, Cities of, Project) Last Revised: 11/19/2018 o TMR # 1764 - ,f- Guadalupe County Page 5 of 7 09/30/39 7,505,000.00 ?, . 1,707,133.00 9,212,133.00 09/30/40 7,785,000.00 ._ 1,431,151.00 9,216,151.00 09/30/41 8,065,000.00 1,144,722.00 9,209,722.00 09/30/42 3,635,000.00 942,419.00 4,577,419.00 09/30/43 3,755,000.00 815,326.00 4,570,326.00 09/30/44 3,880,000.00 683,982.50 4,563,982.50 09/30/45 3,575,000.00 556,833.00 4,131,833.00 09/30/46 3,690,000.00 434,177.50 4,124,177.50 09/30/47 1,605,000.00 307,522.00 1,912,522.00 09/30/48 1,660,000.00 250,063.00 1,910,063.00 09/30/49 1,715,000.00 190,635.00 1,905,635.00 09/30/50 1,775,000.00 129,238.00 1,904,238.00 09/30/51 1,835,000.00 65,693.00 1,900,693.00 09/30/2031 130,550,000.00 79.931,999.00 210,481,999.00 COMPUTED ON BASIS OF MANDATORY REDEMPTION Debt Amortization Rates % of Principal Period Ending Principal Retired 09/30/2018 1,285,000.00 ?, . 00.98% -v �. A P , .. , .., . 09/30/2019 2,520,000.00 ._ 02.91% 09/30/2020 3,085,000.00 05.28% 09/30/2021 3,145,000.00 07.69% 09/30/2022 3,240,000.00 10.17% 09/30/2023 3,330,000.00 12.72% 09/30/2024 3.430,000.00 15.35% 09/30/2025 3,550,000.00 18.07% 09/30/2026 3,800,000.00 20.98% 09/30/2027 3,935,000.00 23.99% 09/30/2028 4,095,000.00 27.13% 09/30/2029 4,260,000.00 30.39% 09/30/2030 4,425,000.00 33.78% 09/30/2031 2,820,000.00 35.94% 09/30/2032 2,920,000.00 38.18% 09/30/2033 3,020,000.00 40.49% 09/30/2034 3,125,000.00 42.88% 09/30/2035 3,525,000.00 45.58% 09/30/2036 6,340,000.00 50.44% 09/30/2037 6,980,000.00 55.79% 09/30/2038 7,240,000.00 61.33% 09/30/2039 7,505,000.00 67.08% 09/30/2040 7385,000.00 73.04% 09/30/2041 8,065,000.00 79.22% 09/30/2042 3,635,000.00 82.01% 09/30/2043 3,755,000.00 84.88% 09/30/2044 3,880,000.00 87.86% 09/30/2045 3.575,000.00 90.59% 09/30/2046 3,690,000.00 93.42% 09/30/2047 1,605,000.00 94.65% 09/30/2048 1,660,000.00 95.92% 09/30/2049 1,715,000.00 97.23% 09/30/2050 1,775,000.00 98.59% 09/30/2051 1.835.000.00 100.00% SECURITY The Senior Lien Bonds are special obligations of the Schertz /Seguin Local Government Corporation which are payable solely both as to principal and interest from and secured solely by a lien on and pledge of the Bond Payment. The Junior Lien bonds are special limited obligations of the Schertz /Seguin Local Government Corporation payable and secured solely by a junior and inferior lien on and pledge of the Bonds Payment portion of the annual payments to be paid independently by the City of Schertz, Texas and the City of Seguin, Texas, (a proportionate share of 50% each - as an operations and maintenance expense from the gross revenues of such City's utility system as defined in Chapter 1502, as amended, Texas Government Code) to the Corporation pursuant to the Regional Water Supply Contract, dated as of November 15, 1999, among the Corporation and the Cities. The Bonds are also secured by a lien on and pledge of the money in all funds created, established and maintained by a Resolution. INTEREST AND SINKING FUND For purposes of providing funds to pay the new Bonds as they become due and payable, the Corporation agrees to maintain, at the Depository, a new Interest Sinking Fund. The Corporation covenants that the Bond Payment portion of the Annual Payments shall be deposited upon receipt by the Corporation into the Fund. The Authorized Officials covenant that there shall be deposited into the Fund prior to each principal and interest payment date from the available Bond Payment portion of the Annual Payments an amount equal to 100% of the amount required to fully pay the interest on and the principal of the New Bonds. The Series 2018 Bond proceeds included a deposit into the Fund of $64,015. RESERVE FUND The Reserve Fund is to accumulate and maintain a reserve for the payment of the outstanding bonds equal to the average annual debt service requirements. After the issuance of the Series 2010 bonds, Required Reserve Fund balance shall be $4.681,081.82. The Reserve Fund is funded with three separate Credit Facilities from, Assured Guaranty Municipal Corporation (Series 2001 and 2005 Bonds) and Ambac Assurance Corporation (Series 2007). The Series 2010 Reserve Requirement was funded with $1,000,000 cash from available Corporation funds and $275,621 from bond proceeds. No debt service reserve fund has been established with respect to the 2016 or 2018 Bonds. RENEWAL AND REPLACEMENT FUND As additional security for the Bonds, there has been established a Renewal and Replacement Fund. The Renewal and Replacement Fund was initially funded from previously issued bonds in the amount of $500,000, the Emergency amount. RATE COVENANT Pursuant to the Contract, each City is required to pay its proportionate share of the Annual Payments at least equal to (a) the amount required to pay for all Operations and Maintenance Expenses; (b) to pay Overhead Expenses; and (c) the establish and maintain the debt service and the debt service reserve funds for the Priority Bonds and the Renewal and Replacement Fund requirements contained in the Priority Resolution and the Bond Fund for the New Series Bonds. ADDITIONAL OBLIGATIONS The Corporation reserves the right to issue Additional New Series Bonds without limitation as to principal amount but subject to restrictions applicable under law or otherwise. Additional New Series Bonds, when issued, together with the Bonds and other New Series Bonds at such time outstanding, shall be payable from and secured solely by a junior and inferior lien on and pledge of the Bond Payment portion of the Annual Payments. In addition to Additional New Series Bonds, the Corporation has reserved the right to issue additional obligations payable from a lien on and pledge of all or part of the Bond Payment portion of the Annual Payments, so long as such lien and pledge is subordinate to the lien thereon. The Corporation has also reserved the right to issue Additional Obligations, which are obligations of the Corporation secured by and payable from the Corporation's Net Revenues (but which specifically exclude the Bond Payment portion of the Annual Payments), PROJECTS 41111041 =191 Proceeds from the Series 2001 Bonds were used to improve the Corporation's utility system to deliver water to the Cities and to fund a Reserve Fund. Proceeds from the Series 2010 Bonds were used for improving the utility system to deliver water to the Cities and to fund a Reserve Fund. Proceeds from the Series 2018 Bonds will be used to refund a portion of the Series 2010 Contract Revenue Bonds. 111111117:aA/a1 �.. L', ?, . �. �r .. , -v �. A P , .. , .., . ret ._ y -,.. Schertz/Seguin t Government Corp Texas Municipal Reports ➢, (Schertz & Seguin, Cities of, Project) Last Revised: 11/19/2018 o TIVIR # 1764 - ,f- Guadalupe County Page 6 of 7 Proceeds from the sale of the Series 2014 and 2015 Bonds will be used for the purpose of discharge and final payment of obligations of the Issuer, for the purchase of land for the first phase of the Guadalupe Project. The Project includes the construction of a well -field and cross - country pipeline. Construction of twelve wells, the cross - county pipeline, treatment facilities, pumping stations, water storage and gathering lines from the well -field is complete in Gonzales County. This production capacity was designed for the current needs of the Cities. After completion of the construction and with the written consent of the Cities, the Corporation contracted to sell water to the City of Selma, the City of Universal City, and Spring Hill Water Supply Corporation. Additional acreage has been acquired in Guadalupe County since the completion of construction to support expansion of a new well - field. The Corporation obtained the necessary permits and drilled two additional wells in Gonzales County to enable the Corporation to supply the new customers and maintain safe operational abilities. With the addition of the two new wells, the Corporation increased the permitted production to 12,910 acre -feet of water per year. The Corporation is currently operating eight wells, a water treatment plant and transmission facilities with operations personnel provided by the City of Seguin and the City of Schertz on a contractual basis. The Corporation is delivering water to the Cities at a rate that is very competitive when compared to other wholesale water rates in the area and increases in production are expected to continue over time as demand warrants. The Corporation has revised its rate structure to authorize impact fees. The purpose of the fee is to obtain customer contributions toward construction of capital projects and to provide additional funds to be used to pay debt service on the bond similarly secured. With a portion of the Series 2010 bond proceeds the Corporation intends to acquire land and groundwater leases, drill and equip wells #9 -12 which is expected to increase the total permitted capacity of the Corporation to 19,362 acre -feet per year. Proceeds from the 2016 Bonds will be used to provide funds to finance, acquire, and construct treatment facilities, water supply pipelines, booster pumps, other appurtenances, and necessary easements and other interests in land, and pay the costs and expenses or issuing the Bonds, under and in strict conformity with the laws of the State of Texas, particularly the Act, Chapter 1201, Texas Government Code, as amended, the Contract, and the Resolution. OPERATING STMT. Fiscal Year Ended 09 -30 -2017 09 -30 -2016 09 -30 -2015 09 -30 -2014 Revenues: Water Revenue $16,415,653 $14,675,393 $16,278,709 $13,790,208 Impact Fees 849,289 927,843 910,030 449,997 Reservation Fees 0 0 0 269,000 Lease Revenue 53,698 1.46,21.4 129,600 93,369 Other 349,871 260,967 158,800 124,447 Total Revenues $17,668,511 $16.010,417 $17,477,139 $14,727,021 Expenses: Lease Payments $2,414,771 $2,252,353 $2,234,066 $2,467,171 Depreciation 2,436,451 2,395,01.4 1,962,622 1,547,003 Amortization Expense 80,156 85,399 85,399 85,399 Other 4,188,273 4,571,831 4,735,359 3,256,985 Total Expenses -- - - - - -- $9,119,651 -- - - - - -- $9,304,597 -- - - - - -- $9,017,446 -- - - - - -- $7,356,558 Available For Debt Service $8,548,860 $6,705,820 $8,459,693 $7,370,463 Nonoperating Income (Expense) Interest Income $ 772,494 $ 85,829 $ 17,595 $ 14,551 Contribution from Cities of Schertz & Seguin -0- -0- -0- (269,000) Interest Expense (5,131,266) (4,31.3,689) (2,668,447) (3,521,370) Gain (Loss) on Disposal of Assets 1,414 -0- (912,761) -0- Bond Issuance Costs (916,291) -0- -0- -0- ---------- ---- - - - - -- ---- - - - - -- ---- - - - - -- Change in Net Assets $ 3,275,211 $ 2,477,960 $ 4,896,080 $ 3,594,644 Beg. Balance 10 -1 $12,895,618 $10,417,658 $ 5,521,578 $ 1,926,934 End. Balance 9 -30 $16,170,829 $12,895,618 $10,417,658 $ 5,521,578 NON FUNDED DEBT NON- FUNDED DEBT PAYABLE (As of September 30, 2017) None. MATERIAL EVENTS AND OTHER FILINGS This section contains excerpt(s) from or a summary of filings made by or on behalf of the issuer. The information below is an extract or summary only. The complete filing should be viewed on the Texas MAC website (www.mactexas.com) or the Electronic Municipal Market Access (EMMA) System of the Municipal Securities Rulemaking Board (https: / /emma.msrb.org /), See TMR disclaimer at the bottom of this page. 10/17/2018 - Notice of Failure to File Disclosure - City of Seguin (FYE 2013, 2014, 2016 & 2017) "The audits for the City of Seguin, Texas for the years 2013, 2014, 2016 and 2017 were not filed under the Schertz /Seguin Local Government Corporation CUSIPs. The issuer has implemented procedures in an attempt to eliminate future non - compliance in accordance with the Rule." 10/02/2018 - Notice of Failure to File Disclosure - City of Schertz (FYE 2013, 2014, 2016 & 2017) "Certain tables associated with the City of Schertz's Utility System were not updated in accordance to the Rule. The City of Schertz audits for the years 2013, 2014, 2016 and 2017 were not filed under this CUSIP. This filing includes all required information. "The issuer has implemented procedures in an attempt to eliminate future noncompliance in accordance with the Rule." 1112612014 - Standard & Poor's Underlying: Upgrade on 11/25/2014 "Standard & Poor's Ratings Services has raised its rating on Schertz /Seguin Local Government Corp., Texas' existing contract revenue debt issued for Schertz and Seguin one notch to 'A +' from 'A'. Standard & Poor's has also assigned its 'A +' rating to the LGC's series 2015 contract revenue improvement and refunding bonds. The outlook is stable." SCHERTZ /SEGUIN LOCAL GOVERNMENT CORPORATION Schertz /Seguin Local Government Corporation is a public, non - profit corporation created by the Cities of Schertz and Seguin, Texas, pursuant to Subchapter D of Chapter 431, Texas Transportation Code, as amended. The Corporation was formed on December 23. 1998, among other things, for the purpose to assist, and act on behalf of the cities in acquiring, constructing, leasing, improving, enlarging, extending, repairing, maintaining, developing and operating a wholesale water utility supply system pursuant to the provisions of Texas Local Government Code 402.001. (Chapter 402) and other applicable laws of the State and to assist and act on behalf of the Cities of Schertz and Seguin in accomplishing a governmental purpose in the provision of water for public use. The Corporation is governed by a board of 5 directors appointed by the City Councils of the Cities. The Corporation is not authorized to levy a tax. a .r .. art _ ,,., t °. ,; Schertz/Seguin i t Government Corp Texas Municipal Reports Fe � ➢, (Schertz & Seguin, Cities of, Project) Last Revised: 11/19/2018 o TMR # 1764 - ,f- Guadalupe County Page 7 of 7 COUNTY CHARACTERISTICS: Guadalupe County was created and organized in 1846 from Bexar and Gonzales Counties and named after the Guadalupe River, which runs through the middle. The county is located in south central Texas and traversed by Interstate Highways 10 and 35. COUNTY SEAT: Seguin 2010 census: 131,533 increasing 47.8% since 2000 2000 census: 89,023 increasing 37.2% since 1990 1990 census: 64,873 ECONOMIC BASE Mineral: oil, gravel, gas and clay. Industry: varied manufacturing and agribusiness. Agricultural: wheat, pecans, nursery crops, mile, hay, cotton, corn and cattle. OIL AND GAS - 2017 The oil production for this county accounts for 0.07% of the total state production. The county ranks 86 out of all the counties in Texas for oil production. OIL PRODUCTION (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2014 Oil 896,850 BBL -7.31 2015 Oil 741,580 BBL -17.31 2016 Oil 708,784 BBL -4.42 2017 Oil 658,374 BBL -7.11 CASINGHEAD (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2014 Casinghead 43,544 MCF 43.82 2015 Casinghead 35,184 MCF -19.20 2016 Casinghead 38,784 MCF 10.23 2017 Casinghead 10,649 MCF -72.54 RETAIL SALES & EFFECTIVE BUYING INCOME (The N Year 2017 Retail Sales $1.3B Effective Buying Income (EBI) $3.8B County Median Household Income $56,645 State Median Household Income $57,227 % of Households with EBI below $25K 16.6% % of Households with EBI above $25K 71.5% elsen Company) 2016 2015 $1.4B $1.5B $3.4B $3.5B $53,189 $58,134 $55.352 $53,037 9.4% 8.0% 70.9% 70.5% EMPLOYMENT DATA (Texas Workforce Commission) 2018 2017 2016 Employed Earnings Employed Earnings Employed Earnings 1st Q: 41,033 $453.9M 39,254 $403.6M 37.487 $366.611 End Q: N/A N/A 40,377 $426.3M 38,428 $383.1M 3rd Q: N/A N/A 41,313 $428.6M 38,632 $397.6M 4th Q: N/A N/A 41,556 $455.3M 39,745 $416.4M MAJOR COLLEGES AND UNIVERSITIES: Texas Lutheran University COLLEGES AND UNIVERSITIES Year Total Fall Enrollment 2017 1 1,394 2016 1 1,295 2015 1 1,373 2014 1 1,319 2013 1 1,338 2012 1 1,317 2011 1 1,415 2010 1 1,340 2009 1 1,387 2008 1 1,432 General Manager R. Alan Cockerell Schertz- Seguin Local Government Corporation 205 N River Street Seguin, TX 78155 Phone: 830 - 401 -2302 Fax 830- 386 -2588 acockerell @seguintexas.gov Assistant General Manager Amber Briggs -Beard Schertz /Seguin Local Government Corporation 205 N River Street Seguin, TX 78155 Phone: 830 - 401 -2409 Fax 830 -401 -2320 abriggs @seguintexas.gov City Manager Douglas Faseler 205 N River Street Seguin, TX 78155 -0591 Phone: 830 -401 -2302 Fax: 830 -386 -2588 dfaseler @seguintexas.gov Director of Finance James Walters 1400 Schertz Parkway Schertz, TX 78154 Phone: 210 -619 -1140 Fax: 21.0 - 619 -11.49 jwalters @schertz.com Director of Finance Susan Caddell 205 N River Street Seguin, TX 78155 -0591 Phone: 830 - 401 -2450 Fax: 830 - 401 -2499 scaddell @seguintexas.gov City Manager Dr. Mark Browne 1400 Schertz Parkway Schertz, TX 787.54 Phone: 210 -619 -1000 Fax: 210 -619 -1139 mbrowne @schertz.com 12 ?r a �D. r �s ,; i I Municipal t Texas Municipal Reports 'IC '" (Southern Wastewater Treatment Plant) Last Revised: 1/31/2019 U TMIR # 6774 Bexar, Comal, Guadalupe Counties Page 1 of 4 FINANCIAL STATEMENT FOR OTHER BONDS FOR THIS ISSUER, SEE SEPARATE MUNICIPAL REPORTS FINANCIAL STATEMENT (As of September 30, 2018) Special Obligation Debt Senior Lien $10.905.000 Special Fund Balances I &S and Reserve $2,051,267* * Includes funds for TMR #5386. PAYMENT RECORD Cibolo Creek Municipal Authority has never defaulted. i' , i • Ii Details of Senior Lien Debt (Outstanding 9130/2018) Contract Rev Bds (Southern Wastewater Treatment Plant Proj) Ser 2014 Lien: Senior Tax Treatment: Bank Qualified Original issue Amount $6,950,000.00 Dated Date: 09/01/2014 Sale Date: 09/11/2014 Delivery Date: 1010812014 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 09/01, 03/01 1st Coupon Date: 03/01/2015 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski LLP Financial Advisor: Southwest Securities, San Antonio, TX Lead Manager: Raymond James Co- Manager: Frost Bank Underwriter's Counsel: Andrews Kurth L.L.P. Insurance: Assured Guaranty Municipal Corp.(AGM- Formerly FSA) Use of Proceeds: Wastewater Treatment Plant. Orig Reoffering Maturity Amount Coupon Price /Yield 09/01/2019 155,000.00 09/01/2020 160,000.00 09/01/2021 160,000.00 09/01/2022 165,000.00 09/01/2023 170,000.00 09/01/2024 175,000.00 09/01/2026T 365,000.00 09/01/2028T 395,000.00 09/01/2030T 430,000.00 09/01/2032T 460,000.00 09/01/2034T 500,000.00 09/01/2039T 1,465,000.00 09/01/2044T 1,830,000.00 -------------------- - - - - -- 2.0000% 2.0000% 2.0000% 3.0000% 3.0000% 3.0000% 4.0000% 4.0000% 4.0000% 4.0000% 4.0000% 5.0000% 4.0000% 1.550% 1.800% 100.00% 2.300% 2.550% 2.700% 2.850% 3.050% 3.300% 3.450% 3.550% 3.560% 100.00% $6,430,000.00 Call Option: Term bonds maturing on 09/01/2026 and 09/01/2028 and 09/01/2030 and 09/01/2032 and 09/01/2034 and 09/01/2039 and 09/01/2044 callable in whole or in part on any date beginning 09/01/2024 @ par. Term Call: Term bonds maturing on 09/01/2026: Mandatory Redemption Date Principal Amount 09/01/2025 $180,000 09/01/2026 $185,000 Term bonds maturing on 09/01/2028: Mandatory Redemption Date Principal Amount 0910112027 $195,000 09/01/2028 $200,000 Term bonds maturing on 09/01/2030: Mandatory Redemption Date Principal Amount 09/01/2029 $210,000 09/01/2030 $220,000 Term bonds maturing on 09/01/2032: Mandatory Redemption Date Principal Amount 09/01/2031 $225,000 09/01/2032 $235,000 Term bonds maturing on 09/01/2034: Mandatory Redemption Date Principal Amount 09/01/2033 $245,000 09/01/2034 $255.000 Term bonds maturing on 09/01/2039: Mandatory Redemption Date Principal Amount 09/01/2035 $265,000 09/01/2036 $280,000 09/01/2037 $295,000 09/01/2038 $305,000 09/01/2039 $320,000 Term bonds maturing on 09/01/2044: Mandatory Redemption Date Principal Amount 09/01/2040 $340,000 09/01/2041 $350,000 09/01/2042 $365,000 09/01/2043 $380,000 09/01/2044 $395,000 Contract Rev Bds Ser 2018 (Southern Wastewater Treatment Plant Proj) Lien: Senior Tax Treatment: Bank Qualified Original Issue Amount $4,475,000.00 Dated Date: 11/15/2018 Sale Date: 11/08/2018 Delivery Date: 12/06/2018 Sale Type: Negotiated NIC: 4.0578% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 03/01, 09/01 1st Coupon Date: 09/01/2019 Paying Agent: UMB Bank, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Hilltop Securities Inc. Underwriter's Counsel: McCall, Parkhurst & Horton L.L.P., San Antonio, TX Use of Proceeds: Wastewater Treatment Plant. Orig Reoffering Maturity Amount Coupon Price /Yield 09/01/2020 95.000.00 5.0000% 2290% 09/01/2021 100,000.00 5.0000% 2.380% 09/01/2022 105,000.00 5.0000% 2.510% 09/01/2023 110,000.00 5.0000% 2.610% Y r of f,,,,r J nr, Tf, �F ,; i I Municipal t Texas Municipal Reports Fe ' "� (Southern Wastewater Treatment Plant) Last Revised: 1/31/2019 o T 6774 Bexar, Comal, Guadalupe Counties Page 2 of 4 09/01/2024 115,000.00 5.0000% 2.740% 09/01/2043 i t , .,. r. �. ., .. 7r . .. $280,000 09/01/2025 120,000.00 5.0000% 2.840% 09/01/2044 $290,000 09/01/2026 125,000.00 5.0000% 2.960% 09/01/2027 135,000.00 5.0000% 3.070% $570,000 09/01/2028 140,000.00 5.0000% 3.210% 09/01/2030T 300,000.00 5.0000% 3.250% 09/01/20327 330, 000.00 5.0000% 3.350% Grand Total _ ______________> $10,905,000.00 09/O1/2034T 365,000.00 5.0000% 3.470% 09/01/2036T 400,000.00 5.0000% 3.620% 09/01/2038T 445,000.00 5.0000% 3.700% 09/01/2040T 490,000.00 4.0000% 4.110% Bond Debt Service 09/01/2042T 530,000.00 4.0000% 4.150% 09/O1/2044T 570,000.00 4.0000% 4.170% Period Ending Principal Interest Debt Service $4,475, 000. 00 --------------------------------------------------------- 09/30/19 155,000.00 422,375.28 577,375.28 Call Option: Term bonds maturing on 09/01/2030 and 09/01/2032 and 09/01/2034 and 09/30/20 255,000.00 462,000.00 717,000.00 09/01/2036 and 09/01/2038 and 09/01/2040 and 09/01/2042 and 09/01/2044 callable 09/30/21 260,000.00 454,050.00 714,050.00 in whole or in part on any date beginning 09/01/2028 @ par. 09/30/22 270,000.00 445,850.00 715,850.00 09/30/23 280,000.00 435,650.00 715.650.00 Term Call: Term bonds maturing on 09/01/2030 subject to mandatory redemption as 09/30/24 290,000.00 425,050.00 715,050.00 follows: 09/30/25 300,000.00 414,050.00 714,050.00 Redemption Date Principal Amount 09/30/26 310,000.00 400,850.00 710,850.00 09/01/2029 $145,000 09/30/27 330,000.00 387,200.00 717,200.00 09/01/2030 $155,000 09/30/28 340,000.00 372,650.00 712,650.00 09/30/29 355,000.00 357,650.00 772,650.00 $300,000 09/30/30 375,000.00 342,000.00 717.000.00 09/30/31 385,000.00 325,450.00 710,450.00 Term bonds maturing on 09/01/2032 subject to mandatory redemption as follows: 09/30/32 405,000.00 308,450.00 713.450.00 Redemption Date Principal Amount 09/30/33 425,000.00 290,550.00 715,550.00 09/01/2031 $160,000 09/30/34 440,000.00 271,750.00 711,750.00 09/01/2032 $170,000 09/30/35 460,000.00 252,300.00 712,300.00 09/30/36 485,000.00 229,300.00 714,300.00 $330,000 09/30/37 510,000.00 205,050.00 715.050.00 09/30/38 535,000.00 179,550.00 714,550.00 Term bonds maturing on 09/01/2034 subject to mandatory redemption as follows: 09/30/39 560,000.00 152,800.00 712,800.00 Redemption Date Principal Amount 09/30/40 590,000.00 127,200.00 717,200.00 09/01/2033 $180,000 09/30/41 610,000.00 103,600.00 713,600.00 09/01/2034 $185,000 09/30/42 635,000.00 79,200.00 714,200.00 09/30/43 660,000.00 53,800.00 713,800.00 $365,000 09/30/44 685,000.00 27,400.00 712,400.00 Term bonds maturing on 09/01/2036 subject to mandatory redemption as follows: 10,905,000.00 7,525,775.28 18,430.775.28 Redemption Date Principal Amount --------------- ,; Cibolo t Texas Municipal Reports '_' '" p . (Southern Wastewater Treatment Plant) Last Revised: 1/31/2019 o TMR # 6774 Bexar, Comal, Guadalupe Counties Page 3 of 4 09/30/2039 560,000.00 Revenue 70.84% 10.60% 09/30/2040 590,000.00 28.41 76.25% Randolph Air Force Base 09/30/2041 610,000.00 San Antonio Water System 81.84% 09/30/2042 635,000.00 87.67% 8.82 09/30/2043 660,000.00 2.50 93.72% 09/30/2044 685,000.00 100.00% PERTINENT PROVISIONS PERTINENT PROVISIONS OF THE REVENUE BOND INDENTURE - PRIOR LIEN 1. Nature of Pledge: The Bonds are special obligations payable as to principal and interest from, and secured by lien on and pledge of Special Payments to be paid to the Authority initially by the City of Schertz. 2. Special Payments: Payments the Authority expects to receive by participating members pursuant to the terms of the contract to be put towards debt service requirements. Contract - Regional Wastewater Treatment Contract, dated as of September 11, 2014, together with amendments and supplements thereto which by the term of such instrument is designated as a supplement or amendment to such contract. 3. Issuance of Additional Bonds: The Authority reserves the right to issue "Additional Bonds" and "Additional Obligations" without limitation as to principal amount but subject to any terms, conditions, or restrictions as may be applicable thereto under law or otherwise. Additional Bonds, when issued, together with the Bonds and the currently outstanding Previously Issued Bonds, shall be payable from and secured solely by a lien on and pledge of the Special Payments, which consists of the Annual Payment as a portion of the Annual Requirement. Additional Obligations, which include the Authority's Prior Lien Obligations, Junior Lien Obligations, and Inferior Lien Obligations, when issued, shall be secured by a prior lien on and pledge of the Net Revenues of the System 4. Rate Covenant: The Authority has agreed, while any of the Bonds Similarly Secured and the currently outstanding Previously Issued Bonds are Outstanding, to establish and maintain rates and charges for facilities and services afforded by the System that are reasonably expected, on the basis of available information and experience and with due allowance for contingencies, to produce Gross Revenues in each Fiscal Year sufficient: (1) to pay all Maintenance and Operating Expenses of the System, or any expenses required by statute to be a first claim on and charge against the Gross Revenues of the System; (2) to produce Net Revenues, together with any other lawfully available funds, sufficient to pay the principal of and interest on any Prior Lien Obligations hereafter issued by the Authority and the amounts required to be deposited in any reserve, contingency, or redemption fund or account created for the payment and security of any Prior Lien Obligations, and any other obligations or evidences of indebtedness issued or incurred that are payable from and secured solely by a prior and first lien on and pledge of the Net Revenues of the System: (3) to produce Net Revenues, together with any other lawfully available funds, sufficient to pay the principal of and interest on any Junior Lien Obligations hereafter issued by the Authority and the amounts required to be deposited in any reserve, contingency, or redemption fund or account created for the payment and security of any Junior Lien Obligations, and any other obligations or evidences of indebtedness issued or incurred that are payable from and secured solely by a junior and inferior lien on and pledge of the Net Revenues of the System; (4) to produce Net Revenues, together with any other lawfully available funds, sufficient to pay the principal of and interest on any Inferior Lien Obligations hereafter issued by the Authority and the amounts required to be deposited in any reserve, contingency, or redemption fund or account created for the payment and security of any Inferior Lien Obligations, and any other obligations or evidences of indebtedness issued or incurred that are payable from and secured solely by a subordinate and inferior lien on and pledge of the Net Revenues of the System; and (5) to produce Net Revenues, together with any other lawfully available funds. including Special Payments, to pay the principal of and interest on the Bonds Similarly Secured as the same become due and payable and to deposit the amounts required to be deposited in any special fund or account created and established for the payment and security of the Bonds Similarly Secured. However, the Bonds Similarly Secured, are secured solely by a lien on and pledge of the Special Payments, which consists of the Annual Payment as a portion of the Annual Requirement to be paid to the Authority initially solely by the City pursuant to the Contract. 5. PROJECT: The Southern Wastewater Treatment Plant is a joint effort by the City of Cibolo and the Authority to bring wastewater service to Southern Schertz, Southern Cibolo, and the Interstate 10 Corridor. SYSTEM DESCRIPTION AND PERTINENT CONTRACTS WASTEWATER TREATMENT CONTRACTS The Authority was created to provide a regional waste treatment system to a 28,672 acre area which includes portions of Bexar, Comal, and Guadalupe Counties. Entity % of Total Revenue City of Universal City 10.60% City of Schertz 28.41 Randolph Air Force Base 4.31 San Antonio Water System 5.99 City of Cibolo 18.45 City of Selma 8.82 City of Live Oak 2.50 The Cities agree to pay the Authority a single monthly payment composed of: a) Base monthly charge - a pro rata cost of maintenance and operation expense of the system; b) Sewer charge - a pro -rata share of the system's debt service c) Additional monthly charge - an amount charge for the treatment of each 1.000 gallons of inadmissible discharge into the system. Randolph Air Force Base: On August 13, 1976 CCMA entered into a contract with the Federal Government to provide wastewater treatment to Randolph AFB. The contract continues until such time as Randolph AFB provides a sixty day notice of cancellation. RATES AND FEES Sewer /Wastewater Rates Old Rates (Effective as of October 1, 2016) Impact Fees - $1,800.00* $3.35/M gallons * One -time charge per connection. New Rates (Effective as of October 1, 2017) Impact Fees - $1,800.00* $3.58/M gallons * One -time charge per connection. AUTHORIZED BUT UNISSUED REVENUE BONDS AUTHORIZED BUT UNISSUED None PENSION FUND LIABILITY PENSION FUND LIABILITY Employees of the Authority participate in an eligible state deferred compensation plan under Section 457 of the IRS Act of 1986. Participation is mandatory after ninety days employment. Each employee contributes a minimum of 6% of their gross salary with a matching 10% provided by the Authority. The Authority does not participate in the U.S. Social Security program. The total payroll for the fiscal year September 30, 2018 was $2,169,913. The Authority contributed $396,169 to the plan for the fiscal year ended September 30, 2018. f q 'l . .. 1r� , . , tti ., ., t , fi ,: f vii ,; Cibolo t Texas Municipal Reports Fe '" (Southern Wastewater Treatment Plant) Last Revised: 1/31/2019 U TMR # 6774 Bexar, Comal, Guadalupe Counties Page 4 of 4 Cibolo Creek Municipal Authority was created in 1971 as a conservation and reclamation district for the purpose of providing a regional sewer system for an area comprising some 58.26 square miles and encompassing the City of Schertz, the City of Cibolo, and parts of the Cities of Live Oak, Universal City, San Antonio, Selma, and the Randolph Air Force Base, all of which lie within the Austin -San Antonio growth corridor. The economy of the area is dominated by Randolph Air Force Base. A mall within the Authority's boundaries stimulates commercial and residential development. COUNTY CHARACTERISTICS: Bexar County was created in 1836. The south central Texas county is the major component of the San Antonio Metropolitan Statistical Area and is traversed by Interstate Highways 10 and 35, four U.S. Highways, and two State Highways. COUNTY SEAT: San Antonio 2010 census: 1,714,773 increasing 23.1% since 2000 2000 census: 1,392,931 increasing 17.5% since 1990 1990 census: 1,185,394 ECONOMIC BASE Mineral: sand, limestone and gravel. Industry: tourism, military bases, medical /biomedical research & services, government and education center. Agricultural: nursery crops, hay, grain sorghum, corn and beef cattle. OIL AND GAS - 2017 The county ranks 165 out of all the counties in Texas for oil production. OIL PRODUCTION (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2015 Oil 95,355 BBL -19.88 2016 Oil 128.211 BBL 34.46 2017 Oil 74,078 BBL -42.22 CASINGHEAD (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2015 Casinghead 23 MCF -4.17 2016 Casinghead 59,809 MCF 259,939.13 2017 Casinghead 22 MCF -99.96 PARKS (Texas Parks & Wildlife) Year Description Volume 2015 Government Canyon State Natural Area 54,987 Visitors 2016 Government Canyon State Natural Area 72,321 Visitors 2017 Government Canyon State Natural Area 81,353 Visitors 2018 Government Canyon State Natural Area 80.767 Visitors 2015 San Antonio Missions National Historic Park 1,322,154 Visitors 2016 San Antonio Missions National Historic Park 1.358.911 Visitors CIVIL / MILITARY PERSONNEL (TEXAS MILITARY PREPAREDNESS COMMISSION) Year Description Volume 2015 Joint Base San Antonio 79,601 Members Prepared Bi- Annually. 2016 Joint Base San Antonio N/A 2017 Joint Base San Antonio 51,314 Members RETAIL SALES & EFFECTIVE BUYING INCOME (The N Year 2017 Retail Sales $28.78 Effective Buying Income (EBI) $43.38 County Median Household Income $46,558 State Median Household Income $57,227 % of Households with EBI below $25K 24.8% % of Households with EBI above $25K 66.2% elsen Company) 2016 2015 $28.1B $25.88 $40.78 $39.5B $45,381 $45,298 $55,352 $53.037 12.0% 120% 65.8% 66.7% EMPLOYMENT DATA (Texas Workforce Commission) 2018 2017 2016 Employed Earnings Employed Earnings Employed Earnings 1st Q: 855,381 $11.28 848,200 $10.8B 830,742 $10.18 End Q: 865,683 $10.6B 853,681 $10.18 839,061 $9.6B 3rd Q: N/A N/A 852,605 $10.OB 841,750 $10.OB 4th Q: N/A N/A 862,793 $11.OB 853,919 $10.6B MAJOR COLLEGES AND UNIVERSITIES: University of the Incarnate Word of San Antonio, University of Texas at San Antonio, Trinity University, The University of Texas Health Science Center at San Antonio, Texas A &M University - San Antonio, St. Mary's University, Our Lady of the Lake University, Alamo Community College District COLLEGES AND UNIVERSITIES Year Total Fall Enrollment 2017 8 119.431 2016 8 115,582 2015 8 114.939 2014 8 112.588 2013 8 113,184 2012 8 114,580 2011 8 117,520 2010 8 116,078 2009 8 106.985 2008 7 99.166 [�>; Its [+i:LrZ +1►1T1�+����Z +I��[+3�\ General Manager Clint Ellis 100 Dietz Road Schertz, TX 78154 Phone: 210 -658 -6241 Fax: 210- 658 -5830 cdb @ccmatx.org ME > > „ Iq o I C, ,