Loading...
Debt Model Report Sept 30, 2019 Updated Nov 15, 2018City of Schertz, Texas L For Fiscal Year Ending September 30, 2019 Presented by. SAMCO Capital Markets, Inc. Mark McLiney Andrew Friedman (210) 832-9760 566,938 537,367 503,370 380,775 40,700 154,697 737,400 376,206 238,169 102,063 531,800 264,925 668,368 410,888 729,694 2023 426,123 - 566,263 698,242 505,126 1,020,150 - 37,050 376,606 237,469 103,388 418,400 265,025 668,617 411,263 377,069 6,110,790 2024 426,370 - - 966,793 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 5,966,429 2025 426,005 - - 568,606 - 500,645 1,021,000 - 37,050 375,406 100,144 104,413 271,150 264,525 672,753 409,138 383,569 5,134,403 2029 - - - 565,494 - 500,925 1,014,375 - - 37,050 373,366 97,719 104,613 267,750 266,650 - 297,388 579,494 4,104,822 2030 - - - 566,738 - 502,200 1,022,588 - - 37,050 371,638 100,913 :101,813 271,450 265,425 ' 297,513 579,294 4,116,619'- 2031 566,250 502,785 1,158,525 374,350 98,947 103,925 269,925 264,050 299,488 580,634 4,218,879 2036 - - - 568,875 - - - - 375,550 101,500 101,875 267,756 262,513 299,409 - 1,977,478 2037 _..: ,. _.... 269,306.... 264,225.... 299,959 .......833,491': 2038 295,075 - '295,075:1 Total $ 3,827,201 $ 213,675 $ 304,500 $ 10,214,631 $ 3,710,494 $ 7,040,395 $ 10,329,163 $ 113,938 $ 628,408 $ 3,711,788 $ 6,747,191 $ 2,477,285 $ 1,845,856 $ 6,483,875 $ 5,028,225 $ 6,696,387 $ 6,754,776 $ 7,712,125 $ 83,839,912 2019 $ 369,236 $ 249,413 $ 507,319 $ 224,185 $ 26,400 $ 417,544 $ 108,839 $ 1,902,934 2019 $ 121,213 2020 :248,663 507,813 l 219283 25,963 399,550 :463,625 :1864,896 2020 '124,200= 2021 - 247,200 506,525 224,252 30,525 400,050 461,500 1,870,052 2021 122,100 2022 - € 237,975 ':! 224,028 400,050 ':463,500 :1,325553`. Total $ 367,513 2023 - 238,250 218,739 399,550 464,500 1,321,039 2024 - - r 237,963 ':: 223,321 398,550 '464,500 1,324333' 2025 - 237,100 217,774 397,050 468,375 1,320,299 Fiscal Year Tax Notes '. 2026 >. 236,063 399,925 :461250 1,097,238 Ending 9136 8.2015 2027 - 239,300 - - 397,175 636,475 2019 $ 170,775 2028 - 236,800 - 398,800 635,600': 2020 167,888= 2029 - - 239,000 - - 399,675 - 638,675 2021 2030 235,900 396,425 ' 632,325% Total $ 338,663 2031 237,500 395,775 633,275 2032 ? 238,700 396,325 635,025'. 2033 - - 234,600 - - 396,369 - 630,969 2034 395,688 395,688:: 2035 399,394 399,394 2036 397,466 397,466? 2037 - 394,975 394,978 2038 396,825 396,8251. Total $ 369,236 $ 745,275 $4,370806 $ 1,551,580 $ 82,888$ 7,977,163 $ 3,356,089 $18,453,036 2019 $ 520,000 $ 529,100 $ 663,175 $ 2,436,975 $ 2,236,164 $ 828,137 $ 585,280 $ 7,798,831 $ 3,899,416 2020 520,000 - 664,450 2,444,175 2,231,531 828,137 1,325,175 8,013,468 4,006,734 2021 520,000 - 662,575 2,426,850 2,230,867 828,137 1,323,800 7,992,229 3,996,115 2022 520,000 = 665,175 2,434,650 2,229,242 828,137 1,326,825 8,004,029 4,002,015 2023 520,000 665,650 2,435,950 2,226,390 828,137 1,328,600 8,004,727 4,002,364 2024 520,000 'i 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 3,222,250 2,219,166 828;137 1,326,975 8,116,528 4,058,264 2029 520,000 3,220,250 2,220,811 828,137 1,328,225 8,117,423 4,058,711 2030 520,000 - 3,213,250 2,217,486 828,137 1,327,475 8,106,348 4,053,174 s 2031 2,268,330 - 1,475,500 2,216,266 828,137 1,324,200 8,112,433 4,056,216 2032 2,272,390 1,478,750 2,217,804 828,137 1,323,700 8,120,781 4,060,390 2033 2,271,250 - 1,480,500 2,217,790 828,137 1,321,800 8,119,477 4,059,739 2034 2,269,780 i 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 r 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,594,340 $ 529,100' $ 4,651,438 $ 64,272,375 $ 62,210;062 $ 44,642,279 $ d 29,743,405 $ 223,642,998 $ 111,821,499 m� Fiscal Year Ending 9/30' S -2012 2019 $ 1,511,488 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,3591 2033 1,510,100 2034 1,511,200 2035 1,510,500 2036 1,508,000 2037 1,508,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 $ 34,743,7007; 2019 $ 412,250 $ 165,125 $ 577,375 2020 414,150 302,850 717,000 2021 410,950 303,100 714,050 2022 412,750 303,100 715,850 2023 412,800 302,850 715,650 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 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas $9,915,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2007 Callable 8/1/2017 at Par Dated Date 01/17/2007 Delivery Date 01/17/2007 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2019 7,117.75 7,117.75 08/01/2019 355,000 4.010% 7,117.75 362,117.75 09/30/2019 369,235.50 355,000 14,235.50 369,235.50 369,235.50 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 1 81010 WO M XUKETS, M. 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/2019 300,000 4.070% 65,221.75 365,221.75 08/01/2019 59,116.75 59,116.75 09/30/2019 424,338.50 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 3,205,000 622,201.25 3,827,201.25 3,827,201.25 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 2 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas $9,500,000 General Obligation and Refunding Bonds, Series 2009 Callable 2/1/2019 at Par Dated Date 07/01/2009 Delivery Date 08/13/2009 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 3 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2019 210,000 3.500% 3,675 213,675 09/30/2019 213,675 210,000 3,675 213,675 213,675 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 3 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas $2,865,000 General Obligation Refunding Bonds, Series 2010 Callable 2/1/2018 at Par Dated Date 10/01/2010 Delivery Date 11/30/2010 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 4 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2019 300,000 3.000% 4,500 304,500 09/30/2019 304,500 300,000 4,500 304,500 304,500 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 4 81010 WO M XUKETS, M. 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/2019 250,000 3.500% 161,418.75 411,418.75 08/01/2019 157,043.75 157,043.75 09/30/2019 568,462.50 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 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 5 81010 WO M XUKETS, M. Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 6 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 02/01/2035 525,000 5.000% 27,000.00 552,000.00 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,830,000 3,384,631.25 10,214,631.25 10,214,631.25 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 6 81010 WO M XUKETS, M. 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/2019 485,000 2.330% 40,192.50 525,192.50 08/01/2019 34,542.25 34,542.25 09/30/2019 559,734.75 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 3,450,000 260,494.00 3,710,494.00 3,710,494.00 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 7 81010 WO M XUKETS, M. 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/2019 9,706.25 9,706.25 09/01/2019 230,000 2.500% 9,706.25 239,706.25 09/30/2019 249,412.50 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 705,000 40,275.00 745,275.00 745,275.00 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 8 81010 WO M XUKETS, M. 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/2019 345,000 2.000% 80,697.50 425,697.50 08/01/2019 77,247.50 77,247.50 09/30/2019 502,945.00 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,785,000 1,255,395.00 7,040,395.00 7,040,395.00 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 9 81010 WO M XUKETS, M. 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/2019 395,000 2.250% 58,381.25 453,381.25 08/01/2019 53,937.50 53,937.50 09/30/2019 507,318.75 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,490,000 880,806.25 4,370,806.25 4,370,806.25 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 10 81010 WO M XUKETS, M. 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/2019 190,000 2.580% 18,318.00 208,318.00 08/01/2019 15,867.00 15,867.00 09/30/2019 224,185.00 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,420,000 131,580.00 1,551,580.00 1,551,580.00 Nov 7, 2018 1:22 pm Prepared by ATE (s: \dbc \Schertz:AGG) Page 11 81010 WO M XUKETS, M. 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/2019 100,000 3.000% 144,137.50 244,137.50 08/01/2019 142,637.50 142,637.50 09/30/2019 386,775.00 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,100,000 2,229,162.50 10,329,162.50 10,329,162.50 Nov 7, 2018 1:22 pm Prepared by ATE (s: \dbc \Schertz:AGG) Page 12 81010 WO M XUKETS, M. 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 Interest Debt Service Annual Debt Service 02/01/2019 7,656.25 7,656.25 08/01/2019 340,000 1.750% 7,656.25 347,656.25 09/30/2019 355,312.50 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 875,000 28,000.00 903,000.00 903,000.00 Nov 7, 2018 1:22 pm Prepared by ATE (s: \dbc \Schertz:AGG) Page 13 81010 WO M XUKETS, M. 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 (CIB1) Period Ending Principal Coupon Annual Interest Debt Service Debt Service 02/01/2019 2,887.50 2,887.50 08/01/2019 165,000 1.750% 2,887.50 167,887.50 09/30/2019 170,775.00 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 330,000 8,662.50 338,662.50 338,662.50 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 14 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas $2,125,000 Tax Notes, Series 2015 Non Callable Dated Date 01/08/2015 Delivery Date 01/08/2015 Drainage Equipment (CIB2) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2019 3,106.25 3,106.25 08/01/2019 115,000 1.750% 3,106.25 118,106.25 09/30/2019 121,212.50 02/01/2020 2,100.00 2,100.00 08/01/2020 120,000 1.750% 2,100.00 122,100.00 09/30/2020 124,200.00 02/01/2021 1,050.00 1,050.00 08/01/2021 120,000 1.750% 1,050.00 121,050.00 09/30/2021 122,100.00 355,000 12,512.50 367,512.50 367,512.50 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 15 81010 WO M XUKETS, M. 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/2019 700.00 700.00 08/01/2019 25,000 1.750% 700.00 25,700.00 09/30/2019 26,400.00 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 80,000 2,887.50 82,887.50 82,887.50 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 16 81010 WO M XUKETS, M. 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 (CIB4) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2019 962.50 962.50 08/01/2019 35,000 1.750% 962.50 35,962.50 09/30/2019 36,925.00 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 110,000 3,937.50 113,937.50 113,937.50 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 17 81010 WO M XUKETS, M. 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/2019 4,658.50 4,658.50 08/01/2019 150,000 1.540% 4,658.50 154,658.50 09/30/2019 159,317 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 605,000 23,408.00 628,408.00 628,408 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 18 81010 WO M XUKETS, M. 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/2019 660,000 2.000% 43,912.50 703,912.50 08/01/2019 37,312.50 37,312.50 09/30/2019 741,225.00 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 3,165,000 546,787.50 3,711,787.50 3,711,787.50 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 19 81010 WO M XUKETS, M. 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/2019 215,000 4.000% 81,753.13 296,753.13 08/01/2019 77,453.13 77,453.13 09/30/2019 374,206.26 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 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 20 81010 WO M XUKETS, M. Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 21 BOND DEBT SERVICE City of Schertz, Texas $5,880,000 General Obligation Bonds, Series 2016 Callable 2/1/2026 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2035 360,000 3.000% 10,950.00 370,950.00 08/01/2035 5,550.00 5,550.00 09/30/2035 376,500.00 02/01/2036 370,000 3.000% 5,550.00 375,550.00 09/30/2036 375,550.00 5,270,000 1,477,190.73 6,747,190.73 6,747,190.73 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 21 81010 WO M XUKETS, M. 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/2019 175,000 4.000% 33,084.38 208,084.38 08/01/2019 29,584.38 29,584.38 09/30/2019 237,668.76 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 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 22 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas $2,375,000 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2016A Callable 2/1/2026 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2035 95,000 3.000% 2,925.00 97,925.00 08/01/2035 1,500.00 1,500.00 09/30/2035 99,425.00 02/01/2036 100,000 3.000% 1,500.00 101,500.00 09/30/2036 101,500.00 2,040,000 437,284.50 2,477,284.50 2,477,284.50 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 23 81010 WO M XUKETS, M. 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) Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 24 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2019 115,000 4.000% 12,500 127,500 08/01/2019 10,200 10,200 09/30/2019 137,700 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 625,000 64,500 689,500 689,500 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 24 81010 WO M XUKETS, M. 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/2019 60,000 4.000% 20,584.38 80,584.38 08/01/2019 19,384.38 19,384.38 09/30/2019 99,968.76 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 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 25 81010 WO M XUKETS, M. 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 Interest Debt Service Annual Debt Service 02/01/2034 90,000 3.000% 4,275.00 94,275.00 08/01/2034 2,925.00 2,925.00 09/30/2034 97,200.00 02/01/2035 95,000 3.000% 2,925.00 97,925.00 08/01/2035 1,500.00 1,500.00 09/30/2035 99,425.00 02/01/2036 100,000 3.000% 1,500.00 101,500.00 09/30/2036 101,500.00 1,415,000 372,784.50 1,787,784.50 1,787,784.50 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 26 81010 WO M XUKETS, M. 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/2019 55,000 3.000% 23,206.25 78,206.25 08/01/2019 22,381.25 22,381.25 09/30/2019 100,587.50 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 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 27 81010 WO M XUKETS, M. 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 Annual Ending Principal Coupon Interest Debt Service Debt Service 09/30/2034 104,093.75 02/01/2035 95,000 3.750% 3,656.25 98,656.25 08/01/2035 1,875.00 1,875.00 09/30/2035 100,531.25 02/01/2036 100,000 3.750% 1,875.00 101,875.00 09/30/2036 101,875.00 1,365,000 480,856.25 1,845,856.25 1,845,856.25 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 28 81010 WO M XUKETS, M. 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/2019 385,000 3.000% 78,212.50 463,212.50 08/01/2019 72,437.50 72,437.50 09/30/2019 535,650.00 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 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 29 81010 WO M XUKETS, M. 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/2035 250,000 3.250% 12,512.50 262,512.50 08/01/2035 8,450.00 8,450.00 09/30/2035 270,962.50 02/01/2036 255,000 3.250% 8,450.00 263,450.00 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 5,130,000 1,353,875.00 6,483,875.00 6,483,875.00 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 30 81010 WO M XUKETS, M. 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/2019 150,000 3.000% 58,237.50 208,237.50 08/01/2019 55,987.50 55,987.50 09/30/2019 264,225.00 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 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 31 81010 WO M XUKETS, M. Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 32 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/2035 245,000 3.250% 12,268.75 257,268.75 08/01/2035 8,287.50 8,287.50 09/30/2035 265,556.25 02/01/2036 250,000 3.250% 8,287.50 258,287.50 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,800,000 1,228,225.00 5,028,225.00 5,028,225.00 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 32 81010 WO M XUKETS, M. 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/2019 550,000 2.120% 63,971 613,971 08/01/2019 58,141 58,141 09/30/2019 672,112 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 6,035,000 661,387 6,696,387 6,696,387 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 33 81010 WO M XUKETS, M. 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/2019 385,000 5.000% 251,526.04 636,526.04 08/01/2019 205,968.75 205,968.75 09/30/2019 842,494.79 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 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 34 81010 WO M XUKETS, M. 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/2035 620,000 3.250% 43,912.50 663,912.50 08/01/2035 33,837.50 33,837.50 09/30/2035 697,750.00 02/01/2036 640,000 3.375% 33,837.50 673,837.50 08/01/2036 23,037.50 23,037.50 09/30/2036 696,875.00 02/01/2037 660,000 3.375% 23,037.50 683,037.50 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,440,000 4,291,938.54 14,731,938.54 14,731,938.54 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 35 81010 WO M XUKETS, M. 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/2019 210,000 5.000% 118,569.79 328,569.79 08/01/2019 96,381.25 96,381.25 09/30/2019 424,951.04 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 Nov 7, 2018 1:40 pm Prepared by ATF (s: \dbc \Schertz:SCHERTZ -2018) Page 36 81010 WO M XUKETS, M. 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/2034 255,000 3.250% 22,975.00 277,975.00 08/01/2034 18,831.25 18,831.25 09/30/2034 296,806.25 02/01/2035 265,000 3.250% 18,831.25 283,831.25 08/01/2035 14,525.00 14,525.00 09/30/2035 298,356.25 02/01/2036 275,000 3375% 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,845,000 1,909,776.05 6,754,776.05 6,754,776.05 Nov 7, 2018 1:40 pm Prepared by ATF (s: \dbc \Schertz:SCHERTZ -2018) Page 37 81010 WO M XUKETS, M. 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/2019 175,000 5.000% 132,956.25 307,956.25 08/01/2019 109,587.50 109,587.50 09/30/2019 417,543.75 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 Nov 7, 2018 1:40 pm Prepared by ATF (s: \dbc \Schertz:SCHERTZ -2018) Page 38 81010 WO M XUKETS, M. 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/2034 340,000 3.250% 30,606.25 370,606.25 08/01/2034 25,081.25 25,081.25 09/30/2034 395,687.50 02/01/2035 355,000 3.250% 25,081.25 380,081.25 08/01/2035 19,312.50 19,312.50 09/30/2035 399,393.75 02/01/2036 365,000 3375% 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,595,000 2,382,162.51 7,977,162.51 7,977,162.51 Nov 7, 2018 1:40 pm Prepared by ATF (s: \dbc \Schertz:SCHERTZ -2018) Page 39 81010 WO M XUKETS, M. 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/2019 95,000 5.000% 112,976.49 207,976.49 08/01/2019 189,471.88 189,471.88 09/30/2019 397,448.37 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,570,000 2,498,214.11 11,068,214.11 11,068,214.11 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 40 81010 WO M XUKETS, M. 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/2019 95,000 5.000% 72,637.60 167,637.60 08/01/2019 120,971.88 120,971.88 09/30/2019 288,609.48 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 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 41 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas $8,570,000 General Obligation and Refunding Bonds, Series 2018 Callable 2/1/2028 at Par General Fund Bond Component (GF) Period Ending Principal Coupon Annual Interest Debt Service Debt Service 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,830,000 1,882,125.22 7,712,125.22 7,712,125.22 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 42 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas $8,570,000 General Obligation and Refunding Bonds, Series 2018 Callable 2/1/2028 at Par Dated Date 10/15/2018 Delivery Date 11/27/2018 Utility Fund Bond Component (UF) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2019 40,338.89 40,338.89 08/01/2019 68,500.00 68,500.00 09/30/2019 108,838.89 02/01/2020 335,000 5.000% 68,500.00 403,500.00 08/01/2020 60,125.00 60,125.00 09/30/2020 463,625.00 02/01/2021 350,000 5.000% 60,125.00 410,125.00 08/01/2021 51,375.00 51,375.00 09/30/2021 461,500.00 02/01/2022 370,000 5.000% 51,375.00 421,375.00 08/01/2022 42,125.00 42,125.00 09/30/2022 463,500.00 02/01/2023 390,000 5.000% 42,125.00 432,125.00 08/01/2023 32,375.00 32,375.00 09/30/2023 464,500.00 02/01/2024 410,000 5.000% 32,375.00 442,375.00 08/01/2024 22,125.00 22,125.00 09/30/2024 464,500.00 02/01/2025 435,000 5.000% 22,125.00 457,125.00 08/01/2025 11,250.00 11,250.00 09/30/2025 468,375.00 02/01/2026 450,000 5.000% 11,250.00 461,250.00 09/30/2026 461,250.00 2,740,000 616,088.89 3,356,088.89 3,356,088.89 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 43 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/2019 260,000 260,000 08/01/2019 260,000 260,000 09/30/2019 520,000 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 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 44 BOND DEBT SERVICE $41,040,000 Contract Revenue Bonds, Series 2001 Schertz /Seguin Local Government Corp. Non Callable Period Ending Principal Coupon Interest Debt Service Annual Debt 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,594,340 17,594,340 17,594,340 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 45 BOND DEBT SERVICE $22,140,000 Contract Revenue Bonds, Series 2010 Schertz /Seguin Local Government Corp. Callable 2/1/2019 at Par Dated Date 06/01/2010 Delivery Date 07/14/2010 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 46 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2019 520,000 3.500% 9,100 529,100 09/30/2019 529,100 520,000 9,100 529,100 529,100 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 46 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/2019 645,000 4.000% 439,693.75 1,084,693.75 08/01/2019 426,793.75 426,793.75 09/30/2019 1,511,487.50 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 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 47 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/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 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 23,040,000 11,703,700.03 34,743,700.03 34,743,700.03 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 48 81010 WO M XUKETS, M. 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/2019 540,000 2.000% 64,287.50 604,287.50 08/01/2019 58,887.50 58,887.50 09/30/2019 663,175.00 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 4,150,000 501,437.50 4,651,437.50 4,651,437.50 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 49 81010 WO M XUKETS, M. 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/2019 745,000 3.000% 851,575 1,596,575 08/01/2019 840,400 840,400 09/30/2019 2,436,975 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 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 50 81010 WO M XUKETS, M. 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 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 09/30/2034 1,483,800 02/01/2035 630,000 4.000% 430,800 1,060,800 08/01/2035 418,200 418,200 09/30/2035 1,479,000 02/01/2036 2,960,000 4.000% 418,200 3,378,200 08/01/2036 359,000 359,000 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 39,595,000 24,677,375 64,272,375 64,272,375 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 51 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/2019 500,582.00 500,582.00 08/01/2019 1,235,000 0.780% 500,582.00 1,735,582.00 09/30/2019 2,236,164.00 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 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 52 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/2035 320,718.50 320,718.50 08/01/2035 1,575,000 2.560% 320,718.50 1,895,718.50 09/30/2035 2,216,437.00 02/01/2036 300,558.50 300,558.50 08/01/2036 1,615,000 2.600% 300,558.50 1,915,558.50 09/30/2036 2,216,117.00 02/01/2037 279,563.50 279,563.50 08/01/2037 1,660,000 2.780% 279,563.50 1,939,563.50 09/30/2037 2,219,127.00 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 43,645,000 18,565,061.50 62,210,061.50 62,210,061.50 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 53 BOND DEBT SERVICE $22,830,000 SWIFT Funding Board Participation Loan, Series 2016 Schertz /Seguin Local Government Corp. Dated Date 11/16/2016 Delivery Date 11/16/2016 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2019 414,068.50 414,068.50 08/01/2019 414,068.50 414,068.50 09/30/2019 828,137 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 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 54 BOND DEBT SERVICE $22,830,000 SWIFT Funding Board Participation Loan, Series 2016 Schertz /Seguin Local Government Corp. Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2035 414,068.50 414,068.50 08/01/2035 300,000 3.190% 414,068.50 714,068.50 09/30/2035 1,128,137 02/01/2036 409,283.50 409,283.50 08/01/2036 700,000 3.240% 409,283.50 1,109,283.50 09/30/2036 1,518,567 02/01/2037 397,943.50 397,943.50 08/01/2037 1,125,000 3.460% 397,943.50 1,522,943.50 09/30/2037 1,920,887 02/01/2038 378,481.00 378,481.00 08/01/2038 1,165,000 3.460% 378,481.00 1,543,481.00 09/30/2038 1,921,962 02/01/2039 358,326.50 358,326.50 08/01/2039 1,205,000 3.460% 358,326.50 1,563,326.50 09/30/2039 1,921,653 02/01/2040 337,480.00 337,480.00 08/01/2040 1,250,000 3.460% 337,480.00 1,587,480.00 09/30/2040 1,924,960 02/01/2041 315,855.00 315,855.00 08/01/2041 1,290,000 3.460% 315,855.00 1,605,855.00 09/30/2041 1,921,710 02/01/2042 293,538.00 293,538.00 08/01/2042 1,340,000 3.880% 293,538.00 1,633,538.00 09/30/2042 1,927,076 02/01/2043 267,542.00 267,542.00 08/01/2043 1,390,000 3.880% 267,542.00 1,657,542.00 09/30/2043 1,925,084 02/01/2044 240,576.00 240,576.00 08/01/2044 1,440,000 3.880% 240,576.00 1,680,576.00 09/30/2044 1,921,152 02/01/2045 212,640.00 212,640.00 08/01/2045 1,490,000 3.880% 212,640.00 1,702,640.00 09/30/2045 1,915,280 02/01/2046 183,734.00 183,734.00 08/01/2046 1,545,000 3.880% 183,734.00 1,728,734.00 09/30/2046 1,912,468 02/01/2047 153,761.00 153,761.00 08/01/2047 1,605,000 3.580% 153,761.00 1,758,761.00 09/30/2047 1,912,522 02/01/2048 125,031.50 125,031.50 08/01/2048 1,660,000 3.580% 125,031.50 1,785,031.50 09/30/2048 1,910,063 02/01/2049 95,317.50 95,317.50 08/01/2049 1,715,000 3.580% 95,317.50 1,810,317.50 09/30/2049 1,905,635 02/01/2050 64,619.00 64,619.00 08/01/2050 1,775,000 3.580% 64,619.00 1,839,619.00 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 55 BOND DEBT SERVICE $22,830,000 SWIFT Funding Board Participation Loan, Series 2016 Schertz /Seguin Local Government Corp. Period Ending Principal Coupon Interest Debt Service Annual Debt 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 21,812,279.00 44,642,279.00 44,642,279 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 56 81010 WO M XUKETS, M. 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/2019 173,755 173,755 08/01/2019 411,525 411,525 09/30/2019 585,280 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 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 57 81010 WO M XUKETS, M. BOND DEBT SERVICE $19,045,000 Contract Revenue Refunding Bonds, Series 2018 Schertz /Seguin Local Government Corp. Callable at Par on 2/1/2027 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 58 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 09/30/2034 1,323,400 02/01/2035 1,020,000 4.000% 161,900 1,181,900 08/01/2035 141,500 141,500 09/30/2035 1,323,400 02/01/2036 1,065,000 4.000% 141,500 1,206,500 08/01/2036 120,200 120,200 09/30/2036 1,326,700 02/01/2037 1,110,000 4.000% 120,200 1,230,200 08/01/2037 98,000 98,000 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,698,405 29,743,405 29,743,405 Nov 7, 2018 1:22 pm Prepared by ATF (s: \dbc \Schertz:AGG) Page 58 BOND DEBT SERVICE Cibolo Creek Municipal Authority $6,950,000 Contract Revenue Bonds, Series 2014 (Southern Wastewater Treatment Plant Project) Callable 9/1/2024 @ Par Dated Date 09/01/2014 Delivery Date 10/08/2014 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 03/01/2019 128,625 128,625 09/01/2019 155,000 2.000% 128,625 283,625 09/30/2019 412,250 03/01/2020 127,075 127,075 09/01/2020 160,000 2.000% 127,075 287,075 09/30/2020 414,150 03/01/2021 125,475 125,475 09/01/2021 160,000 2.000% 125,475 285,475 09/30/2021 410,950 03/01/2022 123,875 123,875 09/01/2022 165,000 3.000% 123,875 288,875 09/30/2022 412,750 03/01/2023 121,400 121,400 09/01/2023 170,000 3.000% 121,400 291,400 09/30/2023 412,800 03/01/2024 118,850 118,850 09/01/2024 175,000 3.000% 118,850 293,850 09/30/2024 412,700 03/01/2025 116,225 116,225 09/01/2025 180,000 4.000% 116,225 296,225 09/30/2025 412,450 03/01/2026 112,625 112,625 09/01/2026 185,000 4.000% 112,625 297,625 09/30/2026 410,250 03/01/2027 108,925 108,925 09/01/2027 195,000 4.000% 108,925 303,925 09/30/2027 412,850 03/01/2028 105,025 105,025 09/01/2028 200,000 4.000% 105,025 305,025 09/30/2028 410,050 03/01/2029 101,025 101,025 09/01/2029 210,000 4.000% 101,025 311,025 09/30/2029 412,050 03/01/2030 96,825 96,825 09/01/2030 220,000 4.000% 96,825 316,825 09/30/2030 413,650 03/01/2031 92,425 92,425 09/01/2031 225,000 4.000% 92,425 317,425 09/30/2031 409,850 03/01/2032 87,925 87,925 09/01/2032 235,000 4.000% 87,925 322,925 09/30/2032 410,850 03/01/2033 83,225 83,225 09/01/2033 245,000 4.000% 83,225 328,225 09/30/2033 411,450 03/01/2034 78,325 78,325 09/01/2034 255,000 4.000% 78,325 333,325 Nov 7, 2018 12:28 pm Prepared by ATF (s: \dbc \Cibolo Creek Municipal Authority:AGG) Page 59 BOND DEBT SERVICE Cibolo Creek Municipal Authority $6,950,000 Contract Revenue Bonds, Series 2014 (Southern Wastewater Treatment Plant Project) Callable 9/1/2024 @ Par Annual Period Debt Debt Ending Principal Coupon Interest Service Service 09/30/2034 411,650 03/01/2035 73,225 73,225 09/01/2035 265,000 5.000% 73,225 338,225 09/30/2035 411,450 03/01/2036 66,600 66,600 09/01/2036 280,000 5.000% 66,600 346,600 09/30/2036 413,200 03/01/2037 59,600 59,600 09/01/2037 295,000 5.000% 59,600 354,600 09/30/2037 414,200 03/01/2038 52,225 52,225 09/01/2038 305,000 5.000% 52,225 357,225 09/30/2038 409,450 03/01/2039 44,600 44,600 09/01/2039 320,000 5.000% 44,600 364,600 09/30/2039 409,200 03/01/2040 36,600 36,600 09/01/2040 340,000 4.000% 36,600 376,600 09/30/2040 413,200 03/01/2041 29,800 29,800 09/01/2041 350,000 4.000% 29,800 379,800 09/30/2041 409,600 03/01/2042 22,800 22,800 09/01/2042 365,000 4.000% 22,800 387,800 09/30/2042 410,600 03/01/2043 15,500 15,500 09/01/2043 380,000 4.000% 15,500 395,500 09/30/2043 411,000 03/01/2044 7,900 7,900 09/01/2044 395,000 4.000% 7,900 402,900 09/30/2044 410,800 6,430,000 4,273,400 10,703,400 10,703,400 Nov 7, 2018 12:28 pm Prepared by ATF (s: \dbc \Cibolo Creek Municipal Authority:AGG) Page 60 BOND DEBT SERVICE Cibolo Creek Municipal Authority $4,475,000 Contract Revenue Bonds, Series 2018 (Southern Wastewater Treatment Plant Project) Callable 9/1/2028 at Par Dated Date 11/15/2018 Delivery Date 12/06/2018 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 09/01/2019 165,125.28 165,125.28 09/30/2019 165,125.28 03/01/2020 103,925.00 103,925.00 09/01/2020 95,000 5.000% 103,925.00 198,925.00 09/30/2020 302,850.00 03/01/2021 101,550.00 101,550.00 09/01/2021 100,000 5.000% 101,550.00 201,550.00 09/30/2021 303,100.00 03/01/2022 99,050.00 99,050.00 09/01/2022 105,000 5.000% 99,050.00 204,050.00 09/30/2022 303,100.00 03/01/2023 96,425.00 96,425.00 09/01/2023 110,000 5.000% 96,425.00 206,425.00 09/30/2023 302,850.00 03/01/2024 93,675.00 93,675.00 09/01/2024 115,000 5.000% 93,675.00 208,675.00 09/30/2024 302,350.00 03/01/2025 90,800.00 90,800.00 09/01/2025 120,000 5.000% 90,800.00 210,800.00 09/30/2025 301,600.00 03/01/2026 87,800.00 87,800.00 09/01/2026 125,000 5.000% 87,800.00 212,800.00 09/30/2026 300,600.00 03/01/2027 84,675.00 84,675.00 09/01/2027 135,000 5.000% 84,675.00 219,675.00 09/30/2027 304,350.00 03/01/2028 81,300.00 81,300.00 09/01/2028 140,000 5.000% 81,300.00 221,300.00 09/30/2028 302,600.00 03/01/2029 77,800.00 77,800.00 09/01/2029 145,000 5.000% 77,800.00 222,800.00 09/30/2029 300,600.00 03/01/2030 74,175.00 74,175.00 09/01/2030 155,000 5.000% 74,175.00 229,175.00 09/30/2030 303,350.00 03/01/2031 70,300.00 70,300.00 09/01/2031 160,000 5.000% 70,300.00 230,300.00 09/30/2031 300,600.00 03/01/2032 66,300.00 66,300.00 09/01/2032 170,000 5.000% 66,300.00 236,300.00 09/30/2032 302,600.00 03/01/2033 62,050.00 62,050.00 09/01/2033 180,000 5.000% 62,050.00 242,050.00 09/30/2033 304,100.00 03/01/2034 57,550.00 57,550.00 09/01/2034 185,000 5.000% 57,550.00 242,550.00 09/30/2034 300,100.00 03/01/2035 52,925.00 52,925.00 Nov 7, 2018 12:28 pm Prepared by ATF (s: \dbc \Cibolo Creek Municipal Authority:AGG) Page 61 BOND DEBT SERVICE Cibolo Creek Municipal Authority $4,475,000 Contract Revenue Bonds, Series 2018 (Southern Wastewater Treatment Plant Project) Callable 9/1/2028 at Par Period Annual Ending Principal Coupon Interest Debt Service Debt Service 09/01/2035 195,000 5.000% 52,925.00 247,925.00 09/30/2035 300,850.00 03/01/2036 48,050.00 48,050.00 09/01/2036 205,000 5.000% 48,050.00 253,050.00 09/30/2036 301,100.00 03/01/2037 42,925.00 42,925.00 09/01/2037 215,000 5.000% 42,925.00 257,925.00 09/30/2037 300,850.00 03/01/2038 37,550.00 37,550.00 09/01/2038 230,000 5.000% 37,550.00 267,550.00 09/30/2038 305,100.00 03/01/2039 31,800.00 31,800.00 09/01/2039 240,000 4.000% 31,800.00 271,800.00 09/30/2039 303,600.00 03/01/2040 27,000.00 27,000.00 09/01/2040 250,000 4.000% 27,000.00 277,000.00 09/30/2040 304,000.00 03/01/2041 22,000.00 22,000.00 09/01/2041 260,000 4.000% 22,000.00 282,000.00 09/30/2041 304,000.00 03/01/2042 16,800.00 16,800.00 09/01/2042 270,000 4.000% 16,800.00 286,800.00 09/30/2042 303,600.00 03/01/2043 11,400.00 11,400.00 09/01/2043 280,000 4.000% 11,400.00 291,400.00 09/30/2043 302,800.00 03/01/2044 5,800.00 5,800.00 09/01/2044 290,000 4.000% 5,800.00 295,800.00 09/30/2044 301,600.00 4,475,000 3,252,375.28 7,727,375.28 7,727,375.28 Nov 7, 2018 12:28 pm Prepared by ATF (s: \dbc \Cibolo Creek Municipal Authority:AGG) Page 62 Schertz, City Texas Municipal Reports ➢, (General Obligation Debt) Last Revised: 7/20/2018 ' TMIR # 2302 ,f- Guadalupe, Comal, Bexar 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, 2017) Net Taxable Assessed Valuation ( "A.V. "), 2017 $3,81.3,920,281(a) New Debt $16,475,000 Outstanding Debt 70,625.000 Total General Obligation Debt $87.100,000 Less: Self - Supporting (b) MSRB Water & Sewer 15,726,480 EMS 510.741 Drainage 455,686 GO Debt payable from Ad Valorem Taxes $70,407,093 Less: I &S Fund 1.450,082 Net Debt $68.957.01.1 (a) Includes $18,278,189 under review. (b) The Financial Official Statement dated July 10, 2018 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.81% Net Debt Per Sq mile - $2,791,781.82 Net Debt Per Capita $1,719.97 Net Taxable Assessed Valuation Per Capita - $95,129.21 Bureau of Census Pop: 2000 18,694 Bureau of Census Pop: 2010 31,465 2018 Estimated Population - 40,092 Area: 24.70 Sq mile PAYMENT RECORD Never defaulted. TAX DATA Tax Tax Adjusted % Collected Total % Collected Year A.V. Rate Levy within FY as of 09/30/2017 ** 2012 $2,600,365,551 $0.4999 $12,536,540 99.35 99.91 2013 2,752,562,574 0.4974 13,383,759 99.35 99.84 2014 3.037,267,611 0.4974 14,793.867 99.63 99.90 2015 3.375,850,131 0.4911 16,238.180 99.52 99.79 2016 3,647,504,903 0.4911 17,356,822 99.34 99.34 2017 3,813,920,281* 0.4910 18,726,349 (In process of collection) * Includes $18,278,189 for 2017 under review. ** Delinquent tax collections are allocated to the respective years in which the taxes are levied. Tax Rate Distribution 2017 2016 2015 2014 Operations $0.3248 $0.3168 $0.3159 $0.3164 I &S 0.1662 0.1743 0.1752 0.1810 ------ ------ - - - - -- - - - - -- Totals $0.4910 $0.4911 $0.4911 $0.4974 Tax Rate L'im'itation: Article XI, Section 5 of Texas Constitution, applicable to operates under a Home Rule Charter which adopts constitutional provisions. TAX ABATEMENTS The City had 3 tax abatement agreements, and a Tax Abatement Act exemption of $300,000 for the 2017 Tax Year. 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: 2012 $14,300,641 2013 15,046,362 2014 11,664,298 2015 15,879,383 2016 18,033,005 2017 17,315,650 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 2014 1.500% $10,445,078 70.60% $0.35 2.01.5 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 57.93 0.28 DETAILS OF OUTSTANDING DEBT Details of Limited Tax Debt (Outstanding 9/30/2017) Comb Tax & Ltd Pledge Rev C/O Ser 2007 Tax Treatment: Tax Exempt Original Issue Amount $9,915,000.00 Dated Date: 01/01/2007 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: Communication Equipment, Energy Management Sys, Public Works, Streets & Drainage, Utility. ,; i Texas Municipal Reports "C X ➢, (General Obligation Debt) Last Revised: 7/20/2018 ' TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 2 of 14 08/01/2018 340,000.00 4.0100% N/A 08/01/2019 355,000.00 4.0100% N/A 08/01/2020 370,000.00 4.0100% N/A 08/01/2021 385,000.00 4.0100% N/A 08/01/2022 400,000.00 4.0100% N/A 08/01/2023 420,000.00 4.0100% N/A 08/01/2024 435,000.00 4.0100% N/A 08/01/2025 455,000.00 4.0100% N/A 08/01/2026 470.000.00 4.0100% N/A $3,630,000.00 Call Option: Bonds maturing on 08/01/2018 to 08/01/2026 callable in whole or in part on any date beginning 08/01/2017 @ par. GO Bds Ser 2007 on 0210112027: 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: Drainage, Recreational Facilities, Streets & Sidewalks. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2027T 3,495,000.00 4.0700% N/A $3,495,000.00 Call Option: Term bonds maturing on 0210112027 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 02/01/2013 $235,000 02/01/2014 $245,000 02/01/2015 $255,000 02/01/2016 $265,000 0210112017 $280,000 02/01/2018 $290,000 02/01/2019 $300.000 0210112020 $315,000 0210112021 $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 GO Bds Ser 2008 Tax Treatment: Bank Qualified Original Issue Amount Dated Date: Sale Date: Delivery Date: Sale Type: Record Date: Bond Form: Denomination Interest pays 1st Coupon Date: $9,900,000.00 08/01/2008 08/12/2008 09/10/2008 Private Placement MSRB FR $100,000 Semi - Annually: 08/01, 02101 02/01/2009 Paying Agent: Bank of America, N.A., Dallas, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Purchaser: Bank of America. N.A., Dallas, TX Use of Proceeds: Recreational Facilities, Streets & Sidewalks. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 475,000.00 4.1300% N/A $475,000.00 Call Option: Non - callable Refunded Notes: Maturities refunded by GO Ref Bds Ser 2018 Refunded Amount Mat Date Coupon Price Sched Call 500,000.00 02/01/2019 4.130 Par 0210112018 520,000.00 0210112020 4.130 Par 02/01/2018 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 02/01/2024 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 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, TX 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: Recreational Facilities, Refunding, Streets Refunding Notes: This issue defeased mty(s) 2/1/2010- 2/1/2018 of GO Bds Ser 98 @ par. a... _ .,. . Uf c ",. �: „C n Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 550.000.00 12500% 1340% 02/01/2019 210,000.00 3.5000% 3.510% 0210112020 250,000.00 3.7500% 3.760% 02/01/20227 350,000.00 4.0500% 4.060% a... _ .,. . Uf c ",. �: „C n ,; i Texas Municipal Reports Fe t ➢, (General Obligation Debt) Last Revised: 7/20/2018 ' TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 3 of 14 02/01/2024T 390,000.00 4.2500% 100.00% 02/01/2028T 1,160,000.00 4.5000% 4.600% 02/01/2033T 2,555,000.00 5.5000% 4.700% $5,465,000.00 Call Option: Bonds maturing on 0210112020 and term bonds maturing on 0210112022 and 0210112024 and 0210112028 and 02/01/2033 callable in whole or in part on any date beginning 02/01/2019 @ par. Term Call: Term bonds maturing on 0210112022: Mandatory Redemption Date Principal Amount 0210112021 $190,000 0210112022 $160,000 Term bonds maturing on 0210112024: Mandatory Redemption Date Principal Amount 0210112023 $175,000 02/01/2024 $215.000 Term bonds maturing on 02/01/2028: Mandatory Redemption Date Principal Amount 02/01/2025 $200,000 0210112026 $210,000 0210112027 $220,000 02/01/2028 $530,000 Term bonds maturing on 02/01/2033: Mandatory Redemption Date Principal Amount 02/01/2029 $455,000 02/01/2030 $480,000 02/01/2031 $510,000 02/01/2032 $540,000 02/01/2033 $570.000 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. Refunding Notes: This issue defeased mty(s) 2/1/2012 - 2/1/2021 of Comb Tax & Ltd Pledge Rev C/O Ser 2001 @ par. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 285,000.00 3.0000% 2.400% 02/01/2019 300,000.00 3.0000% 2.650% 0210112020 310,000.00 4.0000% 2.850% 0210112021 320,000.00 4.0000% 3.020% $1,215,000.00 Call Option: Bonds maturing on 02/01/2019 to 0210112021 callable in whole or in part on any date beginning 02/01/2018 @ par. GO Bds Ser 2011 Tax Treatment: Tax Exempt Original Issue Amount $8,250,000.00 Dated Date: 03/01/2011 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: Animal Shelter, Aquatic Center, Sports Complex. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 240,000.00 3.5000% 2.730% 02/01/2019 250,000.00 15000% 3.010% 0210112020 260,000.00 4.0000% 3.300% 0210112021 270,000.00 5.0000% 3.500% 02/01/20237 585,000.00 5.5000% 3.900% 0210112024 315,000.00 4.0000% 4.130% 02/01/2025 330,000.00 4.1250% 4.260% 02/01/2026 345,000.00 4.2500% 4.400% 0210112027 360,000.00 4.3750% 4.500% 0210112028 375,000.00 4.5000% 4.610% 0210112029 390,000.00 4.6250% 4.720% 02/01/2030 410,000.00 4.7500% 4.800% 02/01/20327 885,000.00 5.0000% 100.00% 02/01/20347 975,000.00 5.0000% 5.050% 02/01/20367 1,080,000.00 5.0000% 5.110% $7,070,000.00 Call Option: Bonds maturing on 02/01/2024 to 02/01/2030 and term bonds maturing on 02/01/2023 and 0210112032 and 02/01/2034 and 02/01/2036 callable in whole or in part on any date beginning 02/01/2021 @ par. Term Call: Term bonds maturing on 0210112023: Mandatory Redemption Date Principal Amount 0210112022 $285,000 02/01/2023 $300,000 Term bonds maturing on 0210112032: Mandatory Redemption Date Principal Amount 02/01/2031 $430,000 0210112032 $455,000 Term bonds maturing on 02/01/2034: Mandatory Redemption Date Principal Amount 02/01/2033 $475,000 0210112034 $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 Exempt Original Issue Amount $2,675,000.00 Dated Date: 06/01/2011 Sale Date: 06/07/2011 ..a ":3. •� r,.. � =..t ; -7 � ,. :. .., eta t r xs f ,; i Texas Municipal Reports Fe � ➢, (General Obligation Debt) Last Revised: 7/20/2018 ' TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 4 of 14 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: 0310112012 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/2018 225,000.00 2.2500% 2.450% 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% 3.200% FR Denomination $100,000 $930.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 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, 0210112024 of Comb Tax & Ltd Pledge Rev C/O Ser 2004 @ par. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 635,000.00 2.3300% N/A 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 02/01/2023 675,000.00 2.3300% N/A 0210112024 660.000.00 2.3300% N/A Z2500% Z400% 0210112024 $4.085.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 335,000.00 Tax Treatment: Tax Exempt Original Issue Amount $7,625,000.00 Dated Date: 08/01/2012 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/2018 335,000.00 4.0000% 1.300% 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 Z2500% Z400% 0210112024 390,000.00 2.5000% 2.600% 02/01/2025 400,000.00 2.7000% 2.750% 0210112026 415,000.00 2.8000% 2.900% 02/01/20287 865,000.00 3.0000% 3.100% 02/01/2030T 915.000.00 3.0000% 3.160% 02/01/20327 975.000.00 3.1000% 3.240% $6.120.000.00 Call Option: Bonds maturing on 02/01/2023 to 02/01/2026 and term bonds maturing on 02/01/2028 and 0210112030 and 02/01/2032 callable in whole or in part on any date beginning 0210112022 @ par. Term Call: Term bonds maturing on 0210112028: Mandatory Redemption Date Principal Amount 0210112027 $425,000 02/01/2028 $440,000 Term bonds maturing on 0210112030: Mandatory Redemption Date Principal Amount 02/01/2029 $450,000 02/01/2030 $465,000 Term bonds maturing on 02/01/2032: Mandatory Redemption Date Principal Amount 0210112031 $480.000 0210112032 $495.000 Tax Notes Ser 2013 Tax Treatment: Original Issue Amount Dated Date: Sale Date: Delivery Date: Sale Type: Record Date: Bond Form: Denomination Tax Exempt $835.000.00 04/01/2013 04/09/2013 04/30/2013 Private Placement MSRB BE $100.000 L!w �. f'.. ., ., a s 1'', u s �- 7',. ., ,; i Texas Municipal Reports Fe � ➢, (General Obligation Debt) Last Revised: 7/20/2018 ' TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 5 of 14 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 0210112014 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Purchaser: Presidio Short Term Tax Exempt Fund, LP Use of Proceeds: Public Safety. Ong Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 170,000.00 1.7000% 100.00% $170,000.00 Call Option: Non Callable Tax Notes Ser 2013A 09/01/2013 Tax Treatment: Bank Qualified Original issue Amount $800,000.00 Dated Date: 05/15/2013 Sale Date: 05/14/2013 Delivery Date: 06/04/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: Branch Banking & Trust Company, Charlotte, NC Bond Counsel: Fulbright & Jaworski LLP Financial Advisor: Southwest Securities, San Antonio, TX Purchaser: Branch Banking & Trust Company, Charlotte, NC Use of Proceeds: Public Safety. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 165,000.00 1.3000% N/A $165,000.00 Call Option: Bonds maturing on 02/01/2016 to 02/01/2018 callable in whole on any date beginning 02/01/2015 @ par. Comb Tax & Ltd Pledge Rev CIO 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/2018 390,000.00 Tax Treatment: 20000% 1.350% 02/01/2019 395,000.00 09/01/2013 2.2500% 1.600% 0210112020 405,000.00 Sale Type: 2.5000% 1.900% 0210112021 415,000.00 FR 3.0000% 2.180% 02/01/2022 155,000.00 1st Coupon Date: 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 15000% 2.850% 02/01/2026 175,000.00 15000% 3.000% 02/01/2028T 375,000.00 4.0000% 3.400% 02/01/20307 405,000.00 4.0000% 3.800% 02/01/20337 670,000.00 4.0000% 4.150% $3,880,000.00 Call Option: Bonds maturing on 0210112023 to 0210112026 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 02/01/2028 $190,000 Term bonds maturing on 02/01/2030: Mandatory Redemption Date Principal Amount 02/01/2029 $200,000 0210112030 $205,000 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 Bids Ser 2013 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: 02/01/2014 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 0210112014 Par 325,000 0210112017 0210112014 Par 170,000 02/01/2018 02/01/2014 Par 180,000 02/01/2019 02/01/2014 Par T. �> , ,"' , ,; i Texas Municipal Reports '_' ➢, (General Obligation Debt) Last Revised: 7/20/2018 ' TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 6 of 14 185,000 0210112020 0210112014 Par 195,000 0210112021 0210112014 Par 860,000 0210112025 02/01/2014 Par Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 180,000.00 2.5800% N/A 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 0210112024 215,000.00 2.5800% N/A 02/01/2025 215,000.00 2.5800% N/A 02/01/2026 860,000.00 3.5000% $1,600,000.00 Call Option: Bonds maturing on 02/01/2024 to 02/01/2025 callable in whole or in part on any date beginning 0210112023 @ par. GO Ref Bds Ser 2014 100,000.00 Tax Treatment: Bank Qualified Original Issue Amount $8,450,000.00 Dated Date: 05/15/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 Financial Advisor: Southwest Securities, San Antonio, TX Lead Manager: SAMCO Capital Markets, Inc. Co- Purchaser: Frost Bank Underwriter's Counsel: McCall Parkhurst & Horton L.L.P. Use of Proceeds: Refunding. Refunding Notes: This bond refunded GO Bds Ser 2006 Refunded Amount Mat Date Coupon 1,540,000.00 02/01/2023 5.250 1,715,000.00 02/01/2025 5.250 1,900,000.00 0210112027 5.250 3.220.000.00* 02/01/2031 4.625 * Partial Maturity iaturit Price Par Par Par Par es from the following issues Sched Call 02/01/2016 02/01/2016 02/01/2016 02/01/2016 Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 100,000.00 3.0000% 1.050% 02/01/2019 100,000.00 3.0000% 1.250% 0210112020 100,000.00 3.0000% 1.550% 0210112021 100,000.00 3.0000% 1.750% 0210112022 750,000.00 3.0000% 1.900% 0210112023 775,000.00 3.0000% 2.050% 02/01/2024 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% 2.650% 02/01/2029 960,000.00 4.0000% 2.750% 02/01/2030 1,005,000.00 3.5000% 3.100% $8,200,000.00 Call Option: Bonds maturing on 0210112024 to 0210112030 callable in whole or in part on any date beginning 0210112023 @ par. Tax Notes Ser 2015 335,000.00 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 42.21% Drainage 37.66% Use of Proceeds: Public Works. Orig Reoffering Maturity Amount Coupon Price /Yield 08/01/2018 335,000.00 Tax Treatment: 1.7500% N/A 08/01/2019 340,000.00 1011512015 1.7500% N/A 08/01/2020 345,000.00 Sale Type: 1.7500% N/A 08/01/2021 190,000.00 FR 1.7500% N/A - Semi - Annually: 02101, 08/01 - -- 08/01/2016 - $1.210.000.00 Call Option: Non Callable Tax Notes Ser 2015A 145,000.00 Tax Treatment: Tax Exempt Original Issue Amount $1,020,000.00 Dated Date: 1011512015 Sale Date: 1012712015 Delivery Date: 11/1.9/201.5 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/2018 145,000.00 1.5400% N/A 08/01/2019 150,000.00 1.5400% N/A 08/01/2020 150,000.00 1.5400% N/A 0810112021 150,000.00 1.5400% N/A 08/01/2022 155,000.00 1.5400% N/A $750.000.00 Call Option: Non Callable ,; i Texas Municipal Reports "o ➢, (General Obligation Debt) Last Revised: 7/20/2018 ' TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 7 of 14 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: 02/01/2016 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/2018 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 ** 02/01/2031 4.625 ** Remainder iaturit Price Par Par Par Par Par Par es from the following issues Sched Cal 02/01/2016 02/01/2016 02/01/2016 02/01/2016 02/01/2016 02/01/2016 Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 490,000.00 2.0000% 0.940% 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% $3.655.000.00 Call Option: Bonds maturing on 02/01/2031 callable in whole or in part on any date beginning 02/01/2025 @ par. Comb Tax & Ltd Pledge Rev CIO 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 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: Jefferies LLC Co- Manager: Morgan Stanley Co- Manager: City Securities 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/2018 165,000.00 Sale Date: 4.0000% 0.740% 02/01/2019 175,000.00 Competitive 4.0000% 0.840% 0210112020 180,000.00 Bond Form: 4.0000% 0.980% 0210112021 190,000.00 Semi - Annually: 08/01, 02101 4.0000% 1.070% 0210112022 195.000.00 4.0000% 1.240% 02/01/2023 205,000.00 4.0000% 1.400% 02/01/2024 70,000.00 3.0000% 1.530% 02/01/2025 75,000.00 3.0000% 1.670% 0210112026 75,000.00 3.0000% 1.820% 0210112027 80,000.00 2.0000% 2.020% 0210112028 80,000.00 2.0000% 2.150% 02/01/2029 80.000.00 2.1250% 2.300% 02/01/2030 85,000.00 2.2500% 2.400% 02/01/2031 85,000.00 2.3750% 2.500% 02/01/2032 90,000.00 2.3750% 2.600% 02/01/2033 90,000.00 2.5000% 2.650% 02/01/2036T 285,000.00 3.0000% 100.00% $2,205.000.00 Call Option: Bonds maturing on 0210112027 to 0210112033 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 $285,000 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: 0210112017 Paying Agent: DOKF, 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: Isaak Bond Co- Manager: Wedbush Morgan Securities Co- Manager: R. Seelaus & Co., Inc. Co- Manager: CL King & Associates Co- Manager. FMSbonds, Inc. Co- Manager: Cronin & Co. Co- Manager: Ross, Sinclaire & Associates, Inc. Co- Manager: Loop Capital Markets LLC Co- Manager: Davenport & Co. LLC Co- Manager: W. H. Mell Associates, Inc Co- Manager: First Empire Securities m Uf , , r ;�I ,fr= ,; i Texas Municipal Reports "C ➢, (General Obligation Debt) Last Revised: 7/20/2018 ' TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 8 of 14 Co- Manager Co- Manager Co- Manager Co- Manager Co- Manager Co- Manager Co- Manager Co- Manager Co- Manager Co- Manager Co- Manager Co- Manager Co- Manager Rafferty Capital Markets, LLC Midland Securities, Ltd SumRidge Partners, LLC Alamo Capital WNJ Capital IFS Securities, Inc. Wayne Hummer Investments Sierra Pacific Edward Jones FTN Financial Crews & Associates, Inc. Duncan - Williams, Inc. Oppenheimer & Co. Inc. 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/2018 55,000.00 3.0000% 1.100% $75.000 02/01/2019 55,000.00 3.0000% 1.250% $80,000 0210112020 60,000.00 3.0000% 1.450% $85.000 0210112021 60,000.00 3.0000% 1.650% $5,000 0210112022 60,000.00 3.0000% 1.800% 02/01/2018 0210112023 65,000.00 3.0000% 2.000% 0210112024 65,000.00 3.0000% 2.200% 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,420,000.00 Call Option: Term bonds maturing on 0210112031 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 0210112028 $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 0210112034 $95,000 02/01/2035 $95.000 02/01/2036 $100.000 GO Bds Ser 2016 Tax Treatment: Original Issue Amount Dated Date: Sale Date: Delivery Date: Sale Type: TIC: Record Date: Bond Form: Denomination Tax Exempt $5,880,000.00 08/01/2016 08/02/2016 09/01/2016 Competitive 2.4799% MSRB BE $5,000 $465,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 0210112017 Paying Agent: DOFF, 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: Jefferies LLC Co- Manager: Morgan Stanley Co- Manager: City Securities Co- Manager: Raymond James Use of Proceeds: Streets & Drainage. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 205,000.00 4.0000% 0.740% 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% 02/01/2022 245,000.00 4.0000% 1.240% 02/01/2023 255,000.00 4.0000% 1.400% 02/01/2024 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% 0210112029 305,000.00 2.1250°% 2.300% 02/01/2030 310,000.00 2.2500% 2.400% 02/01/2031 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,475,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 $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: 06/20/2017 Sale Type: Competitive TIC: 2.6239% Record Date: MSRB 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: Wedbush Securities Co- Manager: Country Club Bank Co- Manager: Vining- Sparks IBG „ , n z "o' .. ,. .1 .. ,, r. . •, '.,., ,; i Texas Municipal Reports Fe � ➢, (General Obligation Debt) Last Revised: 7/20/2018 ' TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 9 of 14 Co- Manager: CL King & Associates Co- Manager: Dougherty & Company LLC Co- Manager: Ross, Sinclaire & Associates, Inc. Co- Manager: FMSbonds, Inc. Co- Manager: Davenport & Co. LLC Co- Manager: Loop Capital Markets LLC Co- Manager: Isaak Bond Co- Manager: UMB Bank Co- Manager: Rafferty Capital Markets, LLC Co- Manager: Wayne Hummer Investments Co- Manager: W. H. Me]] Associates, Inc Co- Manager: First Kentucky Securities Co- Manager: Commerce Bank Co- Manager: Midland Securities, Ltd Co- Manager: First Empire Securities Co- Manager: Alamo Capital Co- Manager: SumRidge Partners, LLC Co- Manager: WNJ Capital Co- Manager: Sierra Pacific Co- Manager: IFS Securities, Inc. Co- Manager: Duncan - Williams, Inc. Co- Manager: Oppenheimer & Co. Inc. Co- Manager: Stephens Inc. Co- Manager: Edward Jones 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/2018 345,000.00 3.0000% 0.950% Bank Qualified 02/01/2019 385,000.00 3.0000% 1.050% 05/15/2017 0210112020 400,000.00 3.0000% 1.190% 06/20/2017 0210112021 405,000.00 3.0000% 1.350% 2.7797% 0210112022 420,000.00 3.0000% 1.500% BE 02/01/2023 315,000.00 3.0000% 1.650% Semi- Annually: 08/01, 02 101 0210112024 325,000.00 3.0000% 1.750% 02/01/2025 185,000.00 3.0000% 1.900% 175.000.00 02/01/2026 190,000.00 3.0000% 2.000% 02/01/2025 0210112027 195,000.00 3.0000% 2.150% 1.900% 02/01/2028 200,000.00 3.0000% 2.300% 10000% 02/01/2029 205,000.00 3.0000% 2.400% 02/01/2030 215,000.00 3.0000% 2.500% 195,000.00 0210112031 220,000.00 3.0000% 2.600% 02/01/2029 02/01/20337 460,000.00 3.0000% 2.800% 2.400% 02/O1/203ST 490,000.00 3.2500% 3.000% 02/01/2037T 520,000.00 3.2500% 3.150% --------------------- ------------ ---------- - -- - -- $5.475.000.00 Call Option: Bonds maturing on 02/01/2028 to 02/01/2031 and term bonds maturing on 02/01/2033 and 02/01/2035 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 0210112032 $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 Bds Ser 2017 135,000.00 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: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02 101 1st Coupon Date: 02/01/2018 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP Financial Advisor: SAMCO Capital Markets, Lead Manager: Robert W. Baird & Co., Inc. Co- Manager: UMB Bank Co- Manager: Isaak Bond Co- Manager: Davenport & Co. LLC Co- Manager: Dougherty & Company LLC Co- Manager: Ross, Sinclaire & Associates, Co- Manager: Loop Capital Markets LLC Co- Manager: CL King & Associates Co- Manager: Vining- Sparks IB6 Co- Manager: FMSbonds, Inc. Co- Manager: Country Club Bank Co- Manager: SumRidge Partners, LLC Co- Manager: Wedbush Securities Co- Manager: Stephens Inc. Co- Manager: Oppenheimer & Co. Inc. Co- Manager: Duncan - Williams, Inc. Co- Manager: Edward Jones Co- Manager: IFS Securities, Inc. Co- Manager: Wayne Hummer Investments Co- Manager: Sierra Pacific Co- Manager: W. H. Moll Associates, Inc Co- Manager: WNJ Capital Co- Manager: Alamo Capital Co- Manager: First Empire Securities Co- Manager: Rafferty Capital Markets, LLC Co- Manager: Midland Securities, Ltd Co- Manager: First Kentucky Securities Co- Manager: Commerce Bank San Antonio, TX Inc., San Antonio, TX Inc. Use of Proceeds: Public Safety. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 135,000.00 3.0000% 0.980% 02/01/2019 150.000.00 10000% 1.090% 0210112020 155,000.00 3.0000% 1.190% 0210112021 160,000.00 3.0000% 1.350% 0210112022 165,000.00 3.0000% 1.500% 0210112023 170,000.00 3.0000% 1.650% 0210112024 175.000.00 3.0000% 1.750% 02/01/2025 180.000.00 3.0000% 1.900% 02/01/2026 185.000.00 10000% 2.000% 0210112027 190,000.00 3.0000% 2.150% 0210112028 195,000.00 3.0000% 2.300% 02/01/2029 205,000.00 3.0000% 2.400% Uf r, sr ,,,r T"': � , ,; i Texas Municipal Reports Fe F ➢, (General Obligation Debt) Last Revised: 7/20/2018 ' TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 10 of 14 0210112030 210,000.00 3.0000% 2.500% 2.1200% 02/01/2031 215,000.00 3.0000% 2.600% 560,000.00 02/01/2033T 455,000.00 3.0000% 2.800% MSRB 02/01/2035T 480,000.00 3.2500% 3.000% 2.1200% 02/01/2037T 510.000.00 3.2500% 3.150% 585,000.00 $3,935,000.00 Call Option: Bonds maturing on 02/01/2028 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 0210112032 $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 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 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 Bds 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 02/01/2018 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 0210112025 4.130 Par 02/01/2018 665,000.00 0210112026 4.130 Par 02/01/2018 690,000.00 0210112027 4.130 Par 02/01/2018 720,000.00 02/01/2028 4.130 Par 02/01/2018 Orig 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 0210112023 2.1200% 100.00% 5.0000% 0210112023 595.000.00 495,000.00 2.1200% 100.00% 2.240% 0210112024 610,000.00 2.1200% 100.00% 0210112026 02/01/2025 625,000.00 5.0000% 2.1200% 100.00% 455,000.00 02/01/2026 635,000.00 2.590% 2.1200% 100.00% 0210112027 645,000.00 0210112029 2.1200% 100.00% 5.0000% 0210112028 660,000.00 525,000.00 2.1200% 100.00% 2.850% $6,035,000.00 Call Option: Bonds maturing on 0210112024 to 0210112028 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: UPS Financial Services, Inc. Co- Manager: Raymond James Co- Manager: Fidelity Capital Markets 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% Use of Proceeds: Public Improvements. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2019 385,000.00 .. .. ., . L.1 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% 0210112023 475,000.00 5.0000% 2.130% 0210112024 495,000.00 5.0000% 2.240% 02/01/2025 520,000.00 5.0000% 2.380% 0210112026 435.000.00 5.0000% 2.500% 0210112027 455,000.00 5.0000% 2.590% 0210112028 480,000.00 5.0000% 2.640% 0210112029 505,000.00 5.0000% 2.680% 0210112030 525,000.00 4.0000% 2.850% 0210112031 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% 02/01/2034 595,000.00 3.2500% 3.350% 02/01/2035 620,000.00 3.2500% 3.400% 02/01/2036 640,000.00 13750% 1452% 02/01/2037 660,000.00 3.3750% 3.486% 02/01/2038 680,000.00 3.5000% 100.00% ------------------------------------------------ $10,440,000.00 . ... _ r .. .. ., . L.1 ,; i Texas Municipal Reports Fe t ➢, (General Obligation Debt) Last Revised: 7/20/2018 ' TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 11 of 14 Call Option: Bonds maturing on 02/01/2029 to 02/01/2038 callable in whole or in part on any date beginning 02/01/2028 @ par. Grand Total _ ______________> $87,100,000.00 Bond Debt Service Period Ending Principal Interest Debt Service 09/30/18 6,255,000.00 2,462,713.87 8,717,713.87 09/30/19 6,225,000.00 2,744,124.79 8,969,124.79 09/30/20 6,420,000.00 2,520,898.50 8,940,898.50 09/30/21 6,375,000.00 2,316,999.50 8,691,999.50 09/30/22 5,61.5,000.00 2,116,501.25 7,731,501.25 09/30/23 5,530,000.00 1,932,218.50 7,462,218.50 09/30/24 5,570,000.00 1,747,397.75 7,317,397.75 09/30/25 4,915,000.00 1,568,075.50 6,483,075.50 09/30/26 4,750,000.00 1,397,015.75 6,147,015.75 09/30/27 4,430,000.00 1,224,749.25 5,654,749.25 09/30/28 4,455,000.00 1,067,158.50 5,522,158.50 09/30/29 3,835,000.00 912,015.63 4,747,015.63 09/30/30 3,990,000.00 761,950.00 4,751,950.00 09/30/31 4,245,000.00 611,594.38 4,856,594.38 09/30/32 3,230,000.00 475,222.50 3,705,222.50 09/30/33 2,835,000.00 358,862.50 3,193,862.50 09/30/34 2,100,000.00 264,643.75 2,364,643.75 09/30/35 2,190,000.00 186,600.00 2,376,600.00 09/30/36 2,270,000.00 104,943.75 2,374,943.75 09/30/37 1,185,000.00 43,468.75 1,228,468.75 09/30/38 680,000.00 11,900.00 691,900.00 87,100,000.00 24,829,054.41 111,929,054.41 COMPUTED ON BASIS OF MANDATORY REDEMPTION Debt Amortization Rates % of Principal Period Ending Principal Retired 09/30/2018 6,255,000.00 compiled using 07.18% customarily 09/30/2019 6,225,000.00 of net revenues 14.33% and in 09/30/2020 6,420,000.00 depreciation, transfers, 21.70% payments and 0913012021 6,375,000.00 capital. 29.02% $0 09/30/2022 5,615,000.00 7,000,000 35.46% Fiscal 09/30/2023 5,530,000.00 $15,000.000 41.81% 09 -30 -2016 09/30/2024 5.570,000.00 Revenues: 48.21% 09/30/2025 4,915,000.00 Fees & Charges 53.85% $5,921,223 09/30/2026 4,750,000.00 Other 59.31% 814 09/30/2027 4,430,000.00 Total Revenues 64.39% -- - - - - -- $5,922,037 09/30/2028 4,455,000.00 Expenses 69.51% $4,681,742 09/30/2029 3,835,000.00 Available For 73.91% 09/30/2030 3,990,000.00 Debt Service 78.49% $1,240,295 09/30/2031 4,245,000.00 83.36% 09/30/2032 3,230,000.00 87.07% 09/30/2033 2,835,000.00 90.33% 09/30/2034 2,100,000.00 92.74% 09/30/2035 2,1.90,000.00 95.25% 09/30/2036 2,270,000.00 97.86% 09/30/2037 1,185,000.00 99.22% 09/30/2038 680,000.00 100.00% G.O. Debt Service Requirements for fiscal year - ending 09/30/2018 $8,717,714 I &S Fos all G.O. issues 09/30/2017 $1,450.082 2017 I &S Fund Tax Levy @ 90% 5,704,862 Water & Sewer 1,494,720 EMS Building 150,341 Drainage 134,136 DOW 1MAI II RIM i_Aii LLy:14 1111 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. $8,000,000 $0 11/03/15 Street & Bridge 7,000,000 2,000,000 Fiscal Year Ended $15,000.000 09 -30 -2017 09 -30 -2016 09 -30 -2015 09 -30 -2014 Revenues: Fees & Charges $6,366,894 $5,921,223 $4,415,126 $4,533,753 Other 3,649 814 1,014 75 Total Revenues -- - - - - -- $6,370,543 -- - - - - -- $5,922,037 -- - - - - -- $4,416,140 -- - - - - -- $4,533,828 Expenses $5,649,614 $4,681,742 $4,467,869 $4,056.994 Available For Debt Service $720,929 $1,240,295 ($51,729)* $476,834 * The City had an ending fund balance of $9,821,747 AUTHORIZED BUT UNISSUED GENERAL OBLIGATION BONDS AUTHORIZED BUT UNISSUED* Election Amount Issued 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,000,000 5,000,000 Total: $15,000.000 $10.000,000 $5,000,000 * Excludes authorizations from the following election proposition(s) because the remaining authorization is deemed too small or too old: 12/16/1961- $14,000 Sewer 07/18/1970- $250,000 Sewer 08/09/1997- $595 Fire Improvements 08/09/1997- $330 Hospital 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. Changes in Texas Municipal Retirement System (TMRS) Actuarial Method and Plan Assumptions In early 2007, TMRS informed each of the member cities that the current actuarial assumptions did not take into account updated service credits or cost of living increases which are granted to retirees. These benefits, which some cities adopted, have been historically funded on a pay -as- you -go basis. This has led to regular increases in member cities' rates and a decrease in the overall funding of the retirement system. TMRS announced that it intended to study the impact of these benefit components and make potential changes in the way benefits are being funded. After careful deliberation, the TMRS board approved several changes at its r, ,. ... u �N311 n 1 .. �t °" , ,; i Texas Municipal Reports Fe � ➢, (General Obligation Debt) Last Revised: 7/20/2018 ' TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 12 of 14 November and December meetings to the actuarial methods and plan assumptions. The board changed the actuarial method from unit credit to projected unit credit. Projected unit credit will allow the actuaries to consider the future financial impact of updated service credits and cost of living increases, and these benefits will begin to be pre - funded instead of funded on a pay -as- you -go basis. To mitigate the impact of this change, the board approved an eight year transition period. During this time, cities will be able to phase in the higher contribution rates instead of being required to fund these new rates immediately. Also, the board changed the amortization period from a 25 -year open period to a 30 -year closed period. Under a closed amortization period, contribution rates are higher, but a greater percentage of the unfunded balance is paid off each year. Finally, the board approved changes to the investment policy. TMRS has historically invested solely in fixed income investments. The board authorized the selection of an investment advisor to begin shifting a portion of investments into equity securities as a way to diversify the portfolio's holdings and earn higher returns than could be obtained with fixed income investments. Required Contribution Rates (Percentage of gross covered salary) 2018 2017 Employee: 7.00% 7.00% City: 16.14% 16.00% Actuarial Valuation as of Assets Accrued Liabilities (Unfunded) /Overfunded Liab. Funded Ratio Annual Covered Payroll (Unfunded) /Overfunded Liability as a % of Covered Payroll Pension Liability Beginning Pension Liability - Ending (a) Contributions Employer Contributions Employee Plan Fiduciary Net Position Beg Plan Fiduciary Net Position End (b) Net Pension Liability (a) - (b) (Pension Liab - Fiduciary Position) Plan Fiduciary Net Position as a % of Total Pension Liability Covered Employee Payroll Net Pension Liability as a % of Covered Payroll 12/31/2016 12/31/2015 $44,121,457 $39,338,018 $60,296,483 $55,119,232 ($16,175,026) ($15,781,214) 73.17% 71.37% $16,478,620 $15,648,114 (98.16)% (100.85)% $55,119,232 $50,229,051 $60,296,483 $55,119,232 ---- - -- - - -- -------- - - -- -- $2,627,335 $2,542,565 $1,152,864 $1,095,260 $38,499,857 $36,412,844 $43.270.388 $38.499.857 $17,026,095 $16,619,375 71.76% 69.85% 16,478,620 15,648,114 103.32% 106.21% Membership Data Inactive employees or beneficiaries currently receiving benefits 84 79 Inactive employees entitled to but not yet receiving benefits 155 138 Active employees 317 312 Total 556 529 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. Fiscal Year Annual OPEB Cost % of Annual OPEB Net DEER Year Costs Contributed Cost Contributed Obligation 2015 $ 81,159 $15,485 19% $430,580 2016 136,357 23,519 17% 543,618 2017 136.244 24.107 18% 655.755 As of December 31, 2015, the most recent actuarial valuation date, the actuarial accrued liability for benefits was $1,055,757, and the actuarial value of assets was $0, resulting in an unfunded actuarial accrued liability of $1,055,757. The covered payroll was $15,648,114 and the ratio of the UAAL to the covered payroll was 6.7 %. 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." The City's contributions to the TMRS SDBF for the years ended 2017, 2016, and 2015 were $22,066, $20,324, and $21,681, respectively, which equaled the required contributions each year. Source: City of Schertz CAFR 9 -30 -2017. NON FUNDED DEBT NON- FUNDED DEBT PAYABLE (As of September 30, 2017) The City reports additional debt in the principal amount of $2,769,562 under Emergency Medical Services and $14,570,075 under Govt Activities as follows: Amount Next Year's Reported Outstanding Requirements Under Compensated Absences $214,566 NIA EMS Fund OPEB* $100,370 N/A EMS Fund Pension Liability* $2,454,626 N/A EMS Fund Capital Leases $25,147 $25,505 Govt Activities Compensated Absences $1,069.849 N/A Govt Activities Pension Liability* $12,968,145 N/A Govt Activities OPEB* $506,934 N/A Govt Activities * See PENSION FUND LIABILITY section for details of this obligation. ESTIMATED OVERLAPPING DEBT STATEMENT Taxing Body Debt Amount As Of % Ovlpg Ovlpg Amt Alamo CCD $488,500,000 * 06/30/18 0.26 $1,270,100 Bexar Cc 1,702,665,000 * 06/30/18 0.26 4.426,929 Bexar Cc Hosp Dist 876,814,000 12/31/17 0.26 2,279,716 Coma] Cc 122,864,914 05/01/18 5.02 6,167,819 Comal ISO 767,165,107 * 06/30/18 7.02 53,854,990 Guadalupe Cc 13,655,000 * 06/30/18 20.63 2,817,027 Schertz - Cibolo- Universal City ISD 418,156,092 * 06/30/18 49.49 206,945,450 Total Overlapping Debt: Schertz, City of Total Direct and Overlapping Debt: $277,762,031 09/30/17 $68,957,011 $346,719.042 ,. I co �. ��„ ,; i Texas Municipal Reports 'IC F ➢, (General Obligation Debt) Last Revised: 7/20/2018 ' TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 13 of 14 Total Direct and Overlapping Debt % of A.V. 9.09% Total Direct and Overlapping Debt per Capita: $8,648 * Gross Debt 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, 2014, 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/2015 - Standard & Poor's Underlying: Upgrade on 05/08/2015 "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 "This Notice is being provided by the City of Schertz (the "City "), pursuant to the requirement of Rule 15c2 -12 (the "Rule ") of the Securities and Exchange Act of 1934, as notification of occurrence of the following material events as defined in paragraph (b)(5)(i)(C) of the Rule. On May 28, 2014, Standard & Poor's ( "S &P ") upgraded the rating on the City's existing general obligation debt from "AA" to "AA + "." 1:101012160,1181 = T, T S 1: C c] Z T +1 1 l 1 l C 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 Coma] 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. Agricultural: wheat, pecans, nursery crops, mile, hay, cotton, corn and cattle „^ e Wj- t 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) Engineering 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 Nielsen Company) Year 2017 2016 2015 Retail Sales $1.3B $1.4B $1.5B Effective Buying Income (EBI) $3.8B $3.4B $3.5B County Median Household Income $56,645 $53,189 $58,134 State Median Household Income $57,227 $55,352 $53,037 % of Households with EBI below $25K 16.6% 9.4% 8.0% % of Households with EBI above $25K 71.5% 70.9% 70.5% EMPLOYMENT DATA (Texas Workforce Commission) 2017 2016 2015 Employed Earnings Employed Earnings Employed Earnings 1st Q: 39,254 $399.111 37,487 $366.6M 33,204 $328.8M 2nd Q: 40,377 $426.3M 38,428 $383.1M 33,980 $334.6M Ord Q: 41,313 $428.6M 38,632 $397.6M 34,291 $345.5M 4th Q: 43,069 $466.9M 39,745 $416.4M 35,026 $378.OM 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 Major Employers(a) # Employees Schert /Cibolo /UC ISD 1,837 Education Amazon. com 1,256 Online Retail Sysco Central Texas 815 Food Distributor GE Oil Gas 600 Oil & Gas FedEx Ground 475 Package Shipping Company Brandt Engineering 437 Engineering Visionworks 400 Optical Goods Republic Beverage Company 382 Beverage Services Schertz, City Texas Municipal Reports "'e I F ➢, (General Obligation Debt) Last Revised: 7/20/2018 ' TIVIR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 14 of 14 HEB Grocery Co. 350 Retail City of Schertz 341 Government (a) Source: City of Schertz CAER dated September 30, 2017, TOP TAXPAYERS Principal Taxpayers 2017 A.V. % of A.V. 1. Capterpillar Inc. $142,765,734 3.74% Manufacturer 2. Sysco San Antonio Inc. 105,389,350 2.76% Foodservice Distribution 3. Amazon.com.KYDC LLC 66.422,573 1.74% Distribution Center 4. US Real Estate LP 59,667,065 1.56% Retail Center 5. Republic Beverage Co. 50,525,410 1.32% Wine Wholesaler & Importer 6. GE Oil & Gas Inc. 30,427,735 0.80% Oil & Gas 7. WR Lookout Road LLC 29.669,770 0.78% Commercial 8. Shell US Gas & Power LLC 27,111,440 0.71% Oil & Gas 9. SC Shertz LI -C 23,650,000 0.62% Building Materials Supplier 10. H E Butt Grocery Cc 20.133,839 0.53% Grocery Store Total: ---- - - - - -- $555,762,916 - - - - -- 14.56% FINANCE CONNECTED OFFICIALS Mayor Michael Carpenter 1400 Schertz Parkway Schertz, TX 78154 Phone: 210 - 619 -1040 Ext: 1132 Fax: 210 -619 -1139 mcarpenter @schertz.com Acting City Manager Brian James 1400 Schertz Parkway Schertz, TX 78154 Phone: 210- 619 -1000 Fax 210 - 619 -1139 bjames @schertz.com City Secretary Brenda Dennis 1400 Schertz Parkway Schertz, TX 78154 Phone: 210 -619 -1030 Fax: 210- 619 -1139 bdennis @schertz.com Director of Finance James Walters 1400 Schertz Parkway Schertz, TX 78154 Phone: 210- 619 -1140 Fax: 210 - 619 -1149 jwalters @schertz.com Tax Assessor /Collector Daryl John Guadalupe County Tax Office 307 W Court St. Suite 205 Seguin, TX 78155 Phone: 830 - 379 -2315 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 - 372 -2871 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 -2432 Fax: 210- 242 -2454 cs @bcad.org 1u! ��. ,. r if r ,; z/ i t Government Corp Texas Municipal Reports "C p i (chertz & Seguin, Cities of, Project) Last Revised: 10/24/2018 o TIVIR # 1764 ,f- Guadalupe County Page 1 of 7 ��I►T l�t+� �������l�li� iii FOR OTHER BONDS FOR THIS ISSUER, SEE SEPARATE MUNICIPAL REPORTS FINANCIAL STATEMENT (As of September 30, 2017) Special Obligation Debt Senior Lien Junior Lien Special Fund Balances Debt Service Repair & Replacement Reserve $53,105,000 $88,675,000 $141,780,000 $882,168 $500,000 $1,297,887(a) 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: PaineWebber Incorporated Co- Manager: Gain Rauscher 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 0210112031 $1,795,000 0210112032 $1,895,000 02/01/2033 $1,995,000 02/01/2034 $2,100,000 02/01/2035 $2.215.000 Refunded Notes: Maturities refunded by Contract Revenue & Ref Bds Per 2007 Refunded Amount 290,000.00 305,000.00 310,000.00 325,000.00 340,000.00 350,000.00 375,000.00 390.000.00 410,000.00 10,000,000.00 4,765,000.00 11,185,000.00 Mat Date Coupon 0210112012 4.500 02/01/2013 4.625 0210112014 4.700 02/01/2015 4.800 02/01/2016 5.000 0210112017 5.000 0210112018 5.000 02/01/2019 5.125 0210112020 5.125 0210112030 5.375 02/01/2037 5.250 0210112041 5.250 Price Sched Call Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 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, 02 101 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: BBC Capital Markets Co- Manager: Allison, M.E. & Co., Inc. Insurance: Assured Guaranty Municipal Corp. (FSA) Use of Proceeds: Utility. prig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 505,000.00 3.5000% 3.250% 02/01/2019 520,000.00 3.5000% 3.450% 0210112020 540,000.00 15000% 1650% 0210112021 560,000.00 4.0000% 3.850% 0210112022 585,000.00 4.0000% 3.950% 0210112023 610,000.00 4.0000% 100.00% 0210112024 630,000.00 4.0000% 4.100% 02/01/2025 660.000.00 4.0000% 4.180% 02/01/2026 685,000.00 4.1250% 4.250% 0210112027 715,000.00 4.2500% 4.320% 0210112028 745,000.00 4.2500% 4.390% 0210112029 780,000.00 4.2500% 4.480% 02/01/2030 815,000.00 4.5000% 4.570% 0210112031 850,000.00 4.5000% 4.650% 0210112032 890.000.00 4.5000% 4.710% 02/01/20357 2,925,000.00 4.6250% 4.810% 02/01/20387 3.370,000.00 4.7500% 4.860% 02/01/20417 3,890,000.00 4.7500% 4.890% $20,275.000.00 Call Option: Bonds maturing on 0210112020 to 0210112032 and term bonds maturing on 02/01/2035 and 02/01/2038 and 0210112041 callable in whole or in part on any date beginning 02/01/2019 @ par. Term Call: Term bonds maturing on 02/01/2035: Mandatory Redemption Date Principal Amount 02/01/2033 $930,000 „. rz. �,<.., .. f ,r,, <<. .t ,; z/ i t Government Corp Texas Municipal Reports '1z p i (chertz & Seguin, Cities of, Project) Last Revised: 10/24/2018 o T 1764 ,f- Guadalupe County Page 2 of 7 02/01/2034 $975,000 09/30/19 520,000.00 2,216,499.50 2,736,499.50 02/01/2035 $1,020,000 09/30/20 540,000.00 2,197,949.50 2,737,949.50 09/30/21 560,000.00 2,177,299.50 2,737,299.50 Term bonds maturing on 02/01/2038: 09/30/22 585,000.00 2,154,399.50 2,739,399.50 Mandatory Redemption Date Principal Amount 09/30/23 610,000.00 2,130,499.50 2,740,499.50 02/01/2036 $1,070,000 09/30/24 630,000.00 2,105,699.50 2,735,699.50 0210112037 $1,125.000 09/30/25 660.000.00 2,079,899.50 2,739,899.50 0210112038 $1,175,000 09/30/26 685,000.00 2,052,571.38 2,737,571.38 09/30/27 715,000.00 2,023,249.50 2,738,249.50 Term bonds maturing on 0210112041: 09/30/28 745,000.00 1,992,224.50 2,737,224.50 Mandatory Redemption Date Principal Amount 09/30/29 780,000.00 1,959,818.25 2,739,818.25 02/01/2039 $1,235,000 09/30/30 815,000.00 1,924,905.75 2,739,905.75 02/01/2040 $1,295,000 09/30/31 2,645,000.00 1,840,773.25 4,485,773.25 0210112041 $1,360.000 09/30/32 2,785.000.00 1,705,683.25 4,490,683.25 09/30/33 2,925,000.00 1,563,012.00 4,488,012A0 09/30/34 3,075,000.00 1,412,488.88 4,487,488.88 SWIFT Funding BP Loan Ser2016 09/30/35 3,535,000.00 1,254,164.50 4,789,164.50 Lien: Senior 09/30/36 1,770,000.00 1,138,004.50 2,908,004.50 Tax Treatment: Tax Exempt 09/30/37 2,250,000.00 1,063,193.25 3,313,193.25 Original Issue Amount $22,830,000.00 09/30/38 2,340,000.00 969,643.25 3,309,643.25 Dated Date: 11/16/2016 09/30/39 2,440.000.00 872,096.75 3,312,096.75 Sale Date: 08/30/2016 09/30/40 2,545,000.00 770,316.25 3,315,316.25 Delivery Date: 11/16/2016 09/30/41 2,650,000.00 664,010.00 3,314,010.00 Sale Type: Private Placement 09/30/42 1,340,000.00 587,076.00 1,927,076.00 Record Date: N/A 09/30/43 1,390,000.00 535,084.00 1,925,084.00 Bond Form: N/A 09/30/44 1,440,000.00 481,152.00 1,921,152.00 Denomination $0 09/30/45 1,490,000.00 425,280.00 1,915,280.00 Interest pays Semi- Annually: 02101, 08 /01 09/30/46 1,545.000.00 367,468.00 1,912,468.00 1st Coupon Date: 08/01/2017 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,06100 Paying Agent: The Bank of New York Mellon Trust Company, N.A., Dallas, TX 09/30/49 1,715,000.00 190,635.00 1,905,635.00 Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX 09/30/50 1,775,000.00 129,238.00 1,904,238.00 Purchaser: Texas Water Development Board 09/30/51 1,835,000.00 65,693.00 1,900,693.00 Use of Proceeds: Project Costs. 53,105.000.00 43,842,049.75 96,947,049.75 Orig Reoffering Maturity Amount Coupon Price /Yield COMPUTED ON BASIS OF MANDATORY REDEMPTION 08/01/2035 300,000.00 3.1900% N/A 08/01/2036 700,000.00 3.2400% N/A Debt Amortization Rates 08/01/2037 1,125,000.00 3.4600% N/A % of Principal 08/01/2038 1,165,000.00 3.4600% N/A Period Ending Principal Retired 08/01/2039 1,205,000.00 3.4600% N/A 08/01/2040 1,250,000.00 3.4600% N/A 09/30/2018 505,000.00 00.95% 08/01/2041 1,290,000.00 3.4600% N/A 09/30/2019 520,000.00 01.93% 08/01/2042 1,340,000.00 3.8800% N/A 09/30/2020 540,000.00 02.95% 08/01/2043 1,390,000.00 3.8800% N/A 09/30/2021 560,000.00 04.00% 08/01/2044 1,440,000.00 3.8800% N/A 09/30/2022 585,000.00 05.10% 08/01/2045 1,490,000.00 3.8800% N/A 09/30/2023 610,000.00 06.25% 08/01/2046 1,545,000.00 3.8800% N/A 09/30/2024 630,000.00 07.44% 08/01/2047 1,605,000.00 3.5800% N/A 09/30/2025 660,000.00 08.68% 08/01/2048 1,660,000.00 3.5800% N/A 09/30/2026 685,000.00 09.97% 08/01/2049 1,715,000.00 3.5800% N/A 09/30/2027 715,000.00 11.32% 08/01/2050 1,775,000.00 3.5800% N/A 09/30/2028 745,000.00 12.72% 08/01/2051 1,835,000.00 3.5800% N/A 09/30/2029 780,000.00 14.19% $22,830,000.00 09/30/2030 815,000.00 15.72% 09/30/2031 2,645,000.00 20.70% Call Option: Callable on the date prior to which the Corporation cannot purchase 09/30/2032 2,785,000.00 25.95% the TWDB's portion of the Project as specified in the authorizing resolution. 09/30/2033 2,925,000.00 31.46% 09/30/2034 3,075,000.00 37.25% 09/30/2035 3,535,000.00 43.90% Grand Total_____ __________> $53,105,000.00 09/30/2036 1,770,000.00 47.24% 09/30/2037 2,250,000.00 51.47% 09/30/2038 2,340,000.00 55.88% 09/30/2039 2,440,000.00 60.47% Bond Debt Service 09/30/2040 2,545,000.00 65.27% 09/30/2041 2,650,000.00 70.26% Period Ending Principal Interest Debt Service 09/30/2042 1,340,000.00 72.78% 09/30/2043 1,390,000.00 75.40% 09/30/18 505,000.00 2,234,437.00 2,739,437.00 09/30/2044 1,440,000.00 78.11% ,.. •t` ,., .. ,; z/ i t Government Corp Texas Municipal Reports "o p i (chertz & Seguin, Cities of, Project) Last Revised: 10/24/2018 o TIVIR # 1764 ,f- Guadalupe County Page 3 of 7 09/30/2045 1,490,000.00 Sale Date: 80.92% Delivery Date: 09/30/2046 1,545,000.00 Negotiated 8182% MSRB 09/30/2047 1,605,000.00 Denomination 86.85% Interest pays 09/30/2048 1,660,000.00 02/01/2015 89.97% 2.060% 09/30/2049 1,715,000.00 3.5000% 2.600% 93.20% 02/01/2024 09/30/2050 1,775,000.00 96.54% 655,000.00 09/30/2051 1,835,000.00 100.00% 2.740% Details of Junior Lien Debt (Outstanding 9/30/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 475,000.00 495,000.00 520,000.00 540,000.00 560,000.00 585,000.00 610,000.00 635,000.00 665,000.00 695,000.00 725.000.00 Mat Date Coupon 0210112015 4.000 02/070016 4.000 0210112017 4.000 02/01/2018 4.000 02/01/2019 4.000 0210112020 4.100 0210112021 4.150 0210112022 4.200 02/010023 4.250 0210112024 4.300 02/01/2025 4.375 Price Sched Call Par 1012112014 Par 101211201.4 Par 1012112014 Par 1012112014 Par 1012112014 Par 1012112014 Par 1012112014 Par 1012112014 Par 101211201.4 Par 1012112014 Par 1012112014 Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 530,000.00 2.0000% 1.200% 1210212014 02/01/2019 540,000.00 2.0000% 1.600% Negotiated 0210112020 555,000.00 3.0000% 1.850% BE 0210112021 570,000.00 3.0000% 2.050% Semi - Annually: 08/01, 02101 0210112022 590,000.00 3.0000% 2.350% 2.060% 0210112023 610,000.00 3.5000% 2.600% 4.0000% 02/01/2024 630,000.00 3.5000% 2.750% 02/07/2025 655,000.00 3.5000% 2.900% 900,000.00 $4.680.000.00 Call Option: Bonds maturing on 0210112023 to 0210112025 callable in whole or in part on any date beginning 02/01/2022 @ 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: NBC Capital Markets 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 Revenue & Ref Bds Ser 2007 Refunded Amount Mat Date Coupon Price Sched Call 575,000.00 02/01/2016 4.000 Par 02/01/2015 590,000.00 0210112017 4.000 Par 02/01/2015 620,000.00 02/01/2018 4.000 Par 02/01/2015 640,000.00 02/01/2019 4.000 Par 02/01/2015 670,000.00 0210112020 4.125 Par 02/01/2015 685,000.00 0210112021 4.250 Par 02/01/2015 720.000.00 0210112022 4.250 Par 02/01/2015 750,000.00 0210112023 4.250 Par 02/01/2015 785,000.00 0210112024 4.250 Par 02/01/2015 820,000.00 02/01/2025 4.250 Par 02/01/2015 1,660,000.00 0210112026 4.250 Par 02/01/2015 7,405,000.00 0210112030 4.500 Par 02/01/2015 4,275,000.00 02/01/2036 4.500 Par 02/01/2015 15.370.000.00 0210112041 4.500 Par 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% 02/01/2020 775,000.00 3.0000% 1.760% 02/01/2021 785,000.00 4.0000% 2.060% 02/01/2022 825,000.00 4.0000% 2.330% 02/01/2023 860,000.00 4.0000% 2.560% 0210112024 900,000.00 5.0000% 2.740% 02/01/2025 945,000.00 5.0000% 2.850% 02/01/2026 1,805,000.00 5.0000% 2.930% 02/01/2027 1,885,000.00 5.0000% 3.030% 0210112028 1,990.000.00 5.0000% 1120% 02/01/2029 2,090,000.00 5.0000% 1180% 02/01/2030 2,190,000.00 5.0000% 3.260% 02/01/20337 1,650,000.00 5.0000% 3.390% 02/01/2041T 20,950,000.00 4.0000% 4.062% 02/01/2044T 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 02/01/2041 and 0210112044 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 0210112031 $520,000 it ,; z/ i t Government Corp Texas Municipal Reports 'Ic p i (chertz & Seguin, Cities of, Project) Last Revised: 10/24/2018 o T 1764 ,f- Guadalupe County Page 4 of 7 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: 10/20/2016 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: 0810112017 Paying Agent: Regions Bank, Houston, TX 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 08/01/2024 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 11100% N/A 08/01/2045 2,085,000.00 3.1100% N/A 08/01/2046 2.145.000.00 3.1100% N/A $43.670.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 0810112027 @ par. The Bonds are also subject to Special Mandatory redemption as specified in the authorizing resolution. Grand Total _ ______________> $88,675,000.00 Bond Debt Service Period Ending Principal Interest Debt Service 09/30/18 1,285,000.00 2,849,304.00 4,134,304.00 09/30/19 2,520,000.00 2,816,314.00 5,336,314.00 09/30/20 2,570,000.00 2,770,156.00 5,340,156.00 09/30/21 2,605,000.00 2,715,292.00 5,320,292.00 09/30/22 2,675,000.00 2,654,067.00 5,329,067.00 09/30/23 2,140,000.00 2,587,990.00 5,327,990.00 09/30/24 2,815,000.00 2,512,366.00 5,327,366.00 09/30/25 2,900,000.00 2,427,948.00 5,327,948.00 09/30/26 3,120,000.00 2,330,575.50 5,450,575.50 09/30/27 3,220,000.00 2,219,784.00 5,439,784.00 09/30/28 3,340,000.00 2,101,415.50 5,441,415.50 09/30/29 3,465,000.00 1,976,060.50 5,441,060.50 09/30/30 3,590,000.00 1,840,735.50 5,430,735.50 09/30/31 1,950,000.00 1,741,765.50 3,691,765.50 09/30/32 2,015,000.00 1,681,553.50 3,696,553.50 09/30/33 2,080,000.00 1,618,290.00 3,698,290.00 09/30/34 2,145,000.00 1,554,840.00 3,699,840.00 09/30/35 2,205,000.00 1,490,437.00 3,695,437.00 09/30/36 4,575,000.00 1,378,317.00 5,953,31.7.00 09/30/37 4,745,000.00 1,215,427.00 5,960,427.00 09/30/38 4,925,000.00 1,043,179.00 5,968,179.00 09/30/39 5,100,000.00 864,480.00 5,964,480.00 09/30/40 5,285,000.00 679,191.00 5,964,191.00 09/30/41 5,475,000.00 487,012.00 5,962,012.00 09/30/42 2,295,000.00 355,343.00 2,650,343.00 09/30/43 2, 365 ,000.00 280,242.00 2_,645,242.00 09/30/44 2,440,000.00 202,830.50 2,642,830.50 09/30/45 2,085,000.00 131,553.00 2,216,553.00 09/30/46 2,145,000.00 66,709.50 2,211,709.50 88,675,000.00 46,593,178.00 135,268,178.00 COMPUTED ON BASIS OF MANDATORY REDEMPTION Debt Amortization Rates % of Principal Period Ending Principal Retired 09/30/2018 1,285,000.00 01.45% 09/30/2019 2,520,000.00 04.29% 09/30/2020 2,570,000.00 07.19% 09/30/2021 2,605,000.00 10.13% 09/30/2022 2,675,000.00 13.14% 09/30/2023 2,740,000.00 16.23% 09/30/2024 2,815,000.00 19.41% 09/30/2025 2,900,000.00 22.68% 09/30/2026 3,120,000.00 26.20% 09/30/2027 3,220,000.00 29.83% 09/30/2028 3,340,000.00 33.59% .. ,. di e ,s f,, '@ ri ' Schertz/Seguin t Government Corp Texas Municipal Reports p i (Schertz & Seguin, Cities of, Project) Last Revised: 10/24/2018 o TMR # 1764 ,f- Guadalupe County Page 5 of 7 09/30/2029 3,465,000.00 37.50% 09/30/2030 3,590,000.00 Year Ended 41.55% $2,467,171 09/30/2031 1,950,000.00 09 -30 -2015 43.75% Revenues: 09/30/2032 2,015,000.00 85,399 46.02% Water Revenue 09/30/2033 2,080,000.00 $16,278,709 48.37% Impact Fees 09/30/2034 2,145,000.00 910,030 50.79% Reservation Fees 09/30/2035 2,205,000.00 0 53.27% Lease Revenue 09/30/2036 4,575,000.00 129,600 58.43% Other 09/30/2037 4345,000.00 158,800 6178% 09/30/2038 4,925,000.00 69.34% 09/30/2039 5,100,000.00 75.09% 09/30/2040 5,285,000.00 81.05% 09/30/2041 5,475,000.00 87.22% 09/30/2042 2,295,000.00 89.81% 09/30/2043 2,365,000.00 92.48% 09/30/2044 2,440,000.00 95.23% 09/30/2045 2,085,000.00 97.58% 09/30/2046 2.145.000.00 100.00% SECURITY The 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. 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 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. PROJECT 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 of 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. 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 240,230 260,967 158,800 1.24,447 Total Revenues $17,558,870 $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,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,439,219 $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,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,477,960 $ 4,896,080 $ 3,594,644 Beg. Balance 10 -1 $12,895,618 $1.0,41.7,658 $ 5,521,578 $ 1,926,934 End. Balance 9 -30 $16,170,829 $12,895,618 $10,417,658 $ 5,521,578 PION FUNDED DEBT NON- FUNDED DEBT PAYABLE (As of September 30, 2017) None. i, ',r ,.. t dkjl 1,R .. ,; Schertz/Seguin i t Government Corp Texas Municipal Reports Fe p i (Schertz & Seguin, Cities of, Project) Last Revised: 10/24/2018 o T 1764 ,f- Guadalupe County Page 6 of 7 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 (EYE 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." 1.1/26/2014 - Standard & Poor's Underlying: Upgrade on 1.1/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 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, milo, 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 Nielsen Company) Year 2017 2016 2015 Retail Sales $1.3B $1.4B $1.5B Effective Buying Income (EBI) $3.8B $3.4B $3.5B County Median Household Income $56,645 $53,189 $58,134 State Median Household Income $57,227 $55,352 $53,037 % of Households with EBI below $25K 16.6% 9.4% 8.0% % of Households with EBI above $25K 71.5% 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.311 38,428 $383.1M 3rd Q: N/A N/A 41,313 $428.611 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 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 Cockerel] 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 781.55 i ;. , 1 I, r, r ,.('O i s . -. , , +_ �,0, r . ,, ' s.'.� .. , ,. 7 .,, . , . u ti . E ,. ,.., ... 7r . .. ,. n il"A , ., ,. .4 J in ,; Schertz/Seguin i t Government Corp Texas Municipal Reports Fe � p i (Schertz & Seguin, Cities of, Project) Last Revised: 10/24/2018 o TIVIR # 1764 ,f- Guadalupe County Page 7 of 7 Phone: 830 - 401 -2409 Fax: 830 -401 -2320 abriggs @seguintexas.gov Office Administrator Angela Kleinschmidt Schertz /Seguin Local Government Corporation 205 N River Street Seguin, TX 78155 Phone: 830 -401 -2409 Fax: 830 -401 -2320 akleinschmidt @seguintexas.gov Acting City Manager Brian James 1400 Schertz Parkway Schertz, TX 78154 Phone: 210 -619 -1000 Fax: 210- 619 -1139 bjames @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 2UN . 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 Office Administrator Angela Kleinschmidt Schertz /Seguin Local Government Corporation 205 N River Street Seguin, TX 78155 Phone: 830 - 401 -2409 Fax: 830- 401 -2320 akleinschmidt @seguintexas.gov Acting City Manager Brian James 1400 Schertz Parkway Schertz, TX 78154 Phone: 210 -619 -1000 Fax: 210 -619 -1139 bjames @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 <, r. ,. ' a . , . .. . Schertz/Seguin Local Government Corp Texas Municipal Reports (San Antonio Water System Expansion) Last Revised: 10/24/2018 Guadalupe County Page 4 of 4 Director o/Finance Susan Caddell xsw River Street Seguin, rxruzss'05ez Phone: 830'401'2450 Fax: 830~401'249 FOUR �J r m�umnmumnonome��am.m�oommenuouon.enun��men��eunomit/on�j uuvo/oeoanvumu���m�/omu*ruww.'mua n �mam�m,uuonue,�u».nm/mnw�»mo�een o��.nemmommo/saueranuonmnouc�^m,/�v�m���oome.�u�mem�u»aon�/"uener�enuv,e,meuauox/monnamon��a��umpm�nca/�mac/a/mamnv��pnno/�m��,. vnomm�asno�p�oe��/nnn.=ananuamu,ovo�n�ooruoutmauomp/��nesau/mco ��uuxm�mn�mnmm/moonna�/un.m/m���emm�o/mu,mouonoeumeuo� I m/nmenmm.amuen�umomnonoa nn ;1 nono�,�e�monmme/�eue,.uu/me m��opecmranvu/oua/mnonv�opono/m/uroruomoaoI wnoanv/mm�men�uema/on mwpe�/nomaaeuurmeu�m/m��uar ,; i I Municipal t Texas Municipal Reports "o '" (Southern Wastewater Treatment Plant Project) Last Revised: 10/11/2018 U TIVIR # 6774 - Bexar, Comal, Guadalupe Counties Page 1 of 3 FINANCIAL STATEMENT Term bonds maturing on 09/01/2028: Mandatory Redemption Date Principal Amount FOR OTHER BONDS FOR THIS ISSUER, SEE SEPARATE MUNICIPAL REPORTS 09/01/2027 $195,000 09/01/2028 $200,000 FINANCIAL STATEMENT (As of September 30, 2017) Term bonds maturing on 09/01/2030: Special Obligation Debt Mandatory Redemption Date Principal Amount Senior Lien $6,580,000 09/01/2029 $210,000 09/01/2030 $220,000 PAYMENT RECORD Term bonds maturing on 09/01/2032: Mandatory Redemption Date Principal Amount Cibolo Creek Municipal Authority has never defaulted. 09/01/2031 $225,000 09/01/2032 $235,000 DETAILS OF OUTSTANDING DEBT Term bonds maturing on 09/01/2034: Details of Senior Lien Debt (Outstanding 9/3012017) Mandatory Redemption Date Principal Amount 09/01/2033 $245,000 Contract Rev Bds (Southern Wastewater Treatment Plant Proj) Ser 2014 09/01/2034 $255,000 Lien: Senior Tax Treatment: Bank Qualified Term bonds maturing on 09/01/2039: Original Issue Amount $6,950,000.00 Mandatory Redemption Date Principal Amount Dated Date: 09/01/2014 09/01/2035 $265,000 Sale Date: 09/11/2014 09/01/2036 $280,000 Delivery Date: 10/08/2014 09/01/2037 $295,000 Sale Type: Negotiated 09/01/2038 $305,000 Record Date: MSRB 09/01/2039 $320,000 Bond Form: BE Denomination $5,000 Term bonds maturing on 09/01/2044: Interest pays Semi - Annually: 09/01, 03/01 Mandatory Redemption Date Principal Amount 1st Coupon Date: 03/01/2015 09/01/2040 $340,000 09/01/2041 $350,000 Paying Agent: BOKF, N.A., Austin, TX 09/01/2042 $365,000 Bond Counsel: Fulbright & Jaworski LLP 09/01/2043 $380,000 Financial Advisor: Southwest Securities, San Antonio, TX 09/01/2044 $395,000 Lead Manager: Raymond James Co- Manager: Frost Bank Underwriter's Counsel: Andrews Kurth L.L.P. Grand Total_____ __________> $6,580,000.00 Insurance: Assured Guaranty Municipal Corp. (FSA) Use of Proceeds: Wastewater Treatment Plant. Bond Debt Service Orig Reoffering Period Ending Principal Interest Debt Service Maturity Amount Coupon Price /Yield 09/30/18 150,000.00 2.60,250.00 410,250.00 09/01/2018 150,000.00 2.0000% 1.200% 09/30/19 155,000.00 257,250.00 412,250.00 09/01/2019 155,000.00 2.0000% 1.550% 09/30/20 160,000.00 254,150.00 414,150.00 09/01/2020 160,000.00 2.0000% 1.800% 09/30/21 160,000.00 250,950.00 410,950.00 09/01/2021 160,000.00 2.0000% 100.00% 09/30/22 165,000.00 247,750.00 412,750.00 09/01/2022 165,000.00 3.0000% 2.300% 09/30/23 170,000.00 242,800.00 412,800.00 09/01/2023 170.000.00 3.0000% 2.550% 09/30/24 175,000.00 237,700.00 412,700.00 09/01/2024 175,000.00 3.0000% 2.700% 09/30/25 1.80,000.00 232,450.00 412,450.00 09/01/2026T 365,000.00 4.0000% 2.850% 09/30/26 185,000.00 225,250.00 410,250.00 09/01/2028T 395,000.00 4.0000% 3.050% 09/30/27 195,000.00 217,850.00 412,850.00 09/01/2030T 430,000.00 4.0000% 3.300% 09/30/28 200,000.00 210,050.00 410,050.00 09/01/2032T 460,000.00 4.0000% 3.450% 09/30/29 210,000.00 202,050.00 412,050.00 09/01/2034T 500,000.00 4.0000% 3.550% 09/30/30 220,000.00 193,650.00 413,650.00 09/01/2039T 1,465.000.00 5.0000% 3.560% 09/30/31 225,000.00 184,850.00 409,850.00 09/01/2044T 1,830,000.00 4.0000% 100.00% 09/30/32 235,000.00 175,850.00 41.0,850.00 $6,580,000.00 09/30/33 245,000.00 166,450.00 411,450.00 09/30/34 255,000.00 156,650.00 411,650.00 Call Option: Term bonds maturing on 09/01/2026 and 09/01/2028 and 09/01/2030 and 09/30/35 265,000.00 146,450.00 411,450.00 09/01/2032 and 09/01/2034 and 09/01/2039 and 09/01/2044 callable in whole or in 09/30/36 280,000.00 133,200.00 413,200.00 part on any date beginning 09/01/2024 @ par. 09/30/37 295,000.00 119,200.00 414,200.00 09/30/38 305,000.00 104,450.00 409,450.00 Term Call: Term bonds maturing on 09/01/2026: 09/30/39 320,000.00 89,200.00 409,200.00 Mandatory Redemption Date Principal Amount 09/30/40 340,000.00 73,200.00 413,200.00 09/01/2025 $180,000 09/30/41 350,000.00 59,600.00 409,600.00 09/01/2026 $185,000 09/30/42 365,000.00 45,600.00 410,600.00 09/30/43 380,000.00 31,000.00 411,000.00 nn 01 �. W J5 �. ,; Cibolo t Texas Municipal Reports '_' '" (Southern Wastewater Treatment Plant Project) Last Revised: 10/11/2018 U TMIR # 6774 - Bexar, Comal, Guadalupe Counties Page 2 of 3 09/30/44 395,000.00 15,800.00 410,800.00 6,580,000.00 4,533,650.00 11,113,650.00 COMPUTED ON BASIS OF MANDATORY REDEMPTION Debt Amortization Rates % of Principal Period Ending Principal Retired 09/30/2018 150,000.00 Revenue 02.28% 10.60% 09/30/2019 155,000.00 28.41 04.64% Randolph Air Force Base 09/30/2020 160,000.00 San Antonio Water System 07.07% 09/30/2021 160,000.00 09.50% 8.82 09/30/2022 165,000.00 2.50 12.01% 09/30/2023 170,000.00 14.59% 09/30/2024 175,000.00 17.25% 09/30/2025 180,000.00 19.98% 09/30/2026 185,000.00 22.80% 09/30/2027 195,000.00 25.76% 09/30/2028 200.000.00 28.80% 09/30/2029 210,000.00 31.99% 09/30/2030 220,000.00 35.33% 09/30/2031 225,000.00 38.75% 09/30/2032 235,000.00 42.33% 09/30/2033 245,000.00 46.05% 09/30/2034 255,000.00 49.92% 09/30/2035 265,000.00 53.95% 09/30/2036 280,000.00 58.21% 09/30/2037 295,000.00 62.69% 09/30/2038 305,000.00 67.33% 09/30/2039 320,000.00 72.19% 09/30/2040 340,000.00 77.36% 09/30/2041 350,000.00 82.67% 09/30/2042 365,000.00 88.22% 09/30/2043 380,000.00 94.00% 09/30/2044 395,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: In addition to the right to issue bonds of subordinate and inferior lien as authorized by the laws of this state of Texas, the Authority reserves the right hereafter to issue Additional Bonds. 4. Rate Covenant: The Authority agrees and reaffirms its covenants to the holders of the Parity Obligations that it will at all times maintain rates and charges for sewer services furnished, provided and supplied by the System to customers which will produce income and revenues sufficient to pay the interest on and principal of all Parity Obligations, the interest on and principal of all Subordinate Lien Obligations, and any legal debt or obligation of the System as and when the same shall become due. 5. PROJECT: The Southern Wastewater Treatment Plant is a joint effort by the City and the Authority to bring wastewater service to Southern Schertz, Southern Cibolo and the Interstate 10 Corridor. 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 ECONOMIC BACKGROUND Cibolo Creek Municipal Authority was created in 1.971 . 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 f i i _.r, . ,. `7� . i .l � r . ,; i I Municipal t Texas Municipal Reports Fe '" (Southern Wastewater Treatment Plant Project) Last Revised: 10/11/2018 U TMR # 6774 - Bexar, Comal, Guadalupe Counties Page 3 of 3 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 2014 Oil 119,014 BBL -5.13 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 2014 Casinghead 24 MCF -45.45 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 2014 Government Canyon State Natural Area 63,633 Visitors 2015 Government Canyon State Natural Area 54,987 Visitors 2016 Government Canyon State Natural Area 72,321 Visitors 2014 San Antonio Missions National Historic Park 1,395,337 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 (US Department of Defense) Year Description Volume 2014 Brooks City Air Force Base 7 Members 2014 Fort Sam Houston 22,810 Members 2014 Kelly Air Force Base 642 Members 2014 Lackland Air Force Base 30,341 Members 2014 Randolph Air Force Base 7,398 Members 2014 San Antonio Callaghan US Army Recruiting 5 Members RETAIL SALES & EFFECTIVE BUYING INCOME (The Nip Year 2017 Retail Sales $283B 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% EMPLOYMENT DATA (Texas Workforce Commission) 2018 2017 Employed Earnings Employed Earnings lst Q: 856,120 $11.2B 848,200 $10.88 2nd Q: N/A N/A 853,681 $10.18 3rd Q: N/A N/A 852,605 $10.0B 4th Q: N/A N/A 862,793 $11.OB alsen Company) 2016 2015 $28.1B $25.8B $40.7B $39.58 $45.381 $45,298 $55,352 $53,037 12.0% 12.0% 65.8% 66.7% 2016 Employed Earnings 830,742 $10.1B 839,061 $9.6B 841,750 $10.OB 853,919 $10.68 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 General Manager Clint Ellis 100 Dietz Road Schertz, TX 78154 Phone: 210 - 658 -6241 Fax 210- 658 -5830 cdb @ccmatx.org m t r , sa3 N., _ U. _ � m ME X�MO�� •