The URL can be used to link to this page

Debt Model Report Sept 30, 2018 Updated Dec 12, 2017City of Schertz, Texas L For Fiscal Year Ending September 30, 2018 III Mllll� �M Presented by. SAMCO Capital Markets, Inc. Mark McLiney Andrew Friedman (210) 832-9760 On- 74A T� roV 2020 426,823 478,163 329,000 568,888 538,551 504,170 - 383,775 36,313 157,007 741,188 375,406 235,569 103,863 538,875 264,650 670,346 6,352,585 2021 423,799 - 409,628 '326,400 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 6,262,604 2022 425,267 372,540 567,350 708,911 503,676 1,018,025 157,387 37,050 376,606 235,469 100,263 534,425 265,050 671,125 5,973,143 2023 426,123 - :380,581 - 566,263 698,242 = 505,126: - - 1,020,150 - - ( 37,050 376,606 237,469 103,388 418,400 :265,025 - 668,617 5,703,040F. 2024 426,370 412,294 566,713 667,689 500,920 1,019,525 -� 37,050 376,206 97,319 101,438 418,800 264,850 670,844 5,560,016 2025 426,005 - :388225 - 568,606 - 500,645 - ` - 1,021,000 - - 37,050': 375;406 100,144 104,413 :271,150 ::264,525 672,753 : 4,729,922:'. 2026 425,031 389,000 569,469 - 504,435 1,021,425 - 37,050 374,206 97,894 102,313 270,525 264,050 669,397 4,724,794 2027 423,445 389,325 - 569,263 902,250: - 1;018,579 - 37,050 375,556 100;969 104,950 :269750 '..263,425 - 665,829 4,720,387 -' 2028 - 682,450 567,950 - 504,275 - - 1,022,175 - 37,050 374,606 99,369 102,325 268,825 262,650 666,996 4,588,671 2029 : - - 583,013 - S! 565,494 - !' 500,925 - - - 1,014,375 - - 37,050 `. 373,356 97;719 104,613 267,750 266,690 - 3,810,953 = 2030 582,300 566,738 - 502,200 1,022,588 - 37,050 371,638 100,913 101,813 271,450 265,425 - 3,822,113 2031 '585,075 :: 566,250 902,785 - - - - 1,158,525:' 374;350 98;947 103,925 1269,925 = 264,050 - 3,923,832:; 2032 - - 586,200 - 569,125 - 502,673 - - - 376,425 101,869 100,844 268,250 267,450 2.772,835 2037 - - :269,306 '- 264,225 533,531:':: Total $ 4,253,546 $ 484,809 $ 7,709,361 $ 1,308,575 $10,781,669 $ 4,433,277 $ 7,543,490 $ 171,445 $ 166,073 $10,718,938 $ 151,475 $ 784,958 $ 4,294,513 $ 7,119,797 $ 2,711,753 $ 1,948,094 $ 7,025,683 $ 5,307,169 $ 6,769,954 $83,684,577 2018 $ 485,563 $ 249,475 $ 510,663 $ 218,958 $ 26,838 $ 1,491,496 2019 486,929 249,413 507,319 :224,185 26,400 i. 1,494,245': 2020 487,694 248,663 507,813 219,283 25,963 1,489,414 2021 487,857 247;200 506,525 224,252 30,525 1,496,359:: 2022 487,418 2028 - 237,975 224,028 - 949,421 2023 491,378 2021 238,250 :218,739 is 948,367 2024 489,536 - 237,963 223,321 - 950,819 2025 492,093 237,100 :217,774 - '- 946,966:: 2026 488,847 - 236,063 - - 724,910 2027 - 239,300 239,300 2028 236,800 236,800 2029 239,000 '.: 239,000 2030 - - 235,900 - - 235,900 2032 - - 238,700 - - 238,700 2033 234,600 234,600 Total $ 4,397,314 $ 994,750 $ 4,881,469 $ 1,770,538 $ 109,725 $12,153,795 2018 $ 360,769 $ 360,769 2018 $ 123,225 2019 :: 2019 121,2135. 2020 2020 124,200 2021 - = 2021 122,100 2022 - - Total $ 490,738 2023 2024 2025 ri - -` Fiscal Year ._ Tax Notes 2026 Ending 9136 S -2015 2027 - % 2018 $ 168,575 2028 - 2019 170,775 2029 '. - ': 2020 167,888: 2030 2021 2031 :. Total $ 507,238 2032 2033 - Total $ 360,769 $ 360,769 2018 $ 520,000 $ 1,391,300 $ 663,875 $ 2,444,100 $ 5,019,275 $ 2,509,638 2019 520,000 1,388,363 663,175 2,436,975 5,008,513 2,504,256 2020 520,000 1,389,813 664,450 2,444,175 5,018,438 2,509,219 2021 520,000 1,389,163 662,575 2,426,850 4,998,588 2,499,294 2022 520,000 1,391,263 665,175 2,434,650 5,011,088 2,505,544 2023 520,000 1,392,363 665,650 2,435,950 5,013,963 2,506,981 2024 520,000 1,387,563 663,950 2,436,250 5,007,763 2,503,881 2025 520,000 1,391,763 666,463 2,435;125 5,013,350 2,506,675 2026 520,000 1,389,434 3,226,375 5,135,809 2,567,905 2027 520,000 1,390,113 3,214,125 5,124,238 ` 2,562,119 2028 520,000 1,389,088 3,222,250 5,131,338 2,565,669 2029 520,000 1,391,681 - 3,220,250 5,131,931 ! 2,565,966 2030 520,000 1,391,769 3,213,250 5,125,019 2,562,509 2031 2,268,330 1,389,306 - 1,475;500 5,133,136 2,566,568 2032 2,272,390 1,390,156 1,478,750 5,141,296 2,570,648 2033 2271,250 1,388,625 1,480,500 5,140,375 2,570,188' 2034 2,269,780 1,389,572 1,483,800 5,143,152 2,571,576 2035 2,272,590 1,388,438 - 1,479,000 5,140,028 2,570,014 2036 - 1,389,438 3,737,200 5,126,638 2,563,319 2037 1,392,306 - 3,741,300 5,133,606 '+ 2,566,803 2038 - 1,387,681 3,750,200 5,137,881 2,568,941 2039 - 1,390,444 ` - 3,743,900 5,134,344 2,567,172 2040 - 1,390,356 3,742,400 5,132,756 2,566,378 2041 1,392,300 ? 3,740,400 5,132,700 .. 2,566,350 425,300 425,300 212,650 - - - 423,300 423,300 211,650 Total $ 18,114,340 $ 33,362,294 $ 5,315,313 $ 66,716;475 $ 123,508,421 $ 61,754,211 2018 $ 1,511,788 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,359 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 i 2042 -. 2044 - Total $ ! 36,255,488 2018 $ 410,250 2019 412,250 2020 414,150 2022 412,750 2023 412,800 2024 412,700 2025 412,450 2026 410,250 2027 412,850 2028 410,050 2030 413,650 2031 409,850 2032 410,850 2033 411,450 2034 411,650 2035 411,450 2036 413,200 2038 409,450 2039 409,200 2040 413,200 2041 409,600 2042 410,600 2043 411,000 2044 410,800 Total $ 11,113,650 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2007 Dated Date 01/17/2007 Delivery Date 01/17/2007 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 72,781.50 72,781.50 08/01/2018 340,000 4.010% 72,781.50 412,781.50 09/30/2018 485,563.00 02/01/2019 65,964.50 65,964.50 08/01/2019 355,000 4.010% 65,964.50 420,964.50 09/30/2019 486,929.00 02/01/2020 58,846.75 58,846.75 08/01/2020 370,000 4.010% 58,846.75 428,846.75 09/30/2020 487,693.50 02/01/2021 51,428.25 51,428.25 08/01/2021 385,000 4.010% 51,428.25 436,428.25 09/30/2021 487,856.50 02/01/2022 43,709.00 43,709.00 08/01/2022 400,000 4.010% 43,709.00 443,709.00 09/30/2022 487,418.00 02/01/2023 35,689.00 35,689.00 08/01/2023 420,000 4.010% 35,689.00 455,689.00 09/30/2023 491,378.00 02/01/2024 27,268.00 27,268.00 08/01/2024 435,000 4.010% 27,268.00 462,268.00 09/30/2024 489,536.00 02/01/2025 18,546.25 18,546.25 08/01/2025 455,000 4.010% 18,546.25 473,546.25 09/30/2025 492,092.50 02/01/2026 9,423.50 9,423.50 08/01/2026 470,000 4.010% 9,423.50 479,423.50 09/30/2026 488,847.00 3,630,000 767,313.50 4,397,313.50 4,397,313.50 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 1 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas General Obligation Bonds, Series 2007 Dated Date 09/27/2007 Delivery Date 09/27/2007 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 290,000 4.070% 71,123.25 361,123.25 08/01/2018 65,221.75 65,221.75 09/30/2018 426,345.00 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,495,000 758,546.25 4,253,546.25 4,253,546.25 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 2 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas General Obligation Bonds, Series 2008 Dated Date 09/10/2008 Delivery Date 09/10/2008 Period Ending Principal Coupon Annual Interest Debt Service Debt Service 02/01/2018 475,000 4.130% 9,808.75 484,808.75 09/30/2018 484,808.75 475,000 9,808.75 484,808.75 484,808.75 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 3 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas General Obligation and Refunding Bonds, Series 2009 Dated Date 07/01/2009 Delivery Date 08/13/2009 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 550,000 3.250% 129,037.50 679,037.50 08/01/2018 120,100.00 120,100.00 09/30/2018 799,137.50 02/01/2019 210,000 3.500% 120,100.00 330,100.00 08/01/2019 116,425.00 116,425.00 09/30/2019 446,525.00 02/01/2020 250,000 3.750% 116,425.00 366,425.00 08/01/2020 111,737.50 111,737.50 09/30/2020 478,162.50 02/01/2021 190,000 4.050% 111,737.50 301,737.50 08/01/2021 107,890.00 107,890.00 09/30/2021 409,627.50 02/01/2022 160,000 4.050% 107,890.00 267,890.00 08/01/2022 104,650.00 104,650.00 09/30/2022 372,540.00 02/01/2023 175,000 4.250% 104,650.00 279,650.00 08/01/2023 100,931.25 100,931.25 09/30/2023 380,581.25 02/01/2024 215,000 4.250% 100,931.25 315,931.25 08/01/2024 96,362.50 96,362.50 09/30/2024 412,293.75 02/01/2025 200,000 4.500% 96,362.50 296,362.50 08/01/2025 91,862.50 91,862.50 09/30/2025 388,225.00 02/01/2026 210,000 4.500% 91,862.50 301,862.50 08/01/2026 87,137.50 87,137.50 09/30/2026 389,000.00 02/01/2027 220,000 4.500% 87,137.50 307,137.50 08/01/2027 82,187.50 82,187.50 09/30/2027 389,325.00 02/01/2028 530,000 4.500% 82,187.50 612,187.50 08/01/2028 70,262.50 70,262.50 09/30/2028 682,450.00 02/01/2029 455,000 5.500% 70,262.50 525,262.50 08/01/2029 57,750.00 57,750.00 09/30/2029 583,012.50 02/01/2030 480,000 5.500% 57,750.00 537,750.00 08/01/2030 44,550.00 44,550.00 09/30/2030 582,300.00 02/01/2031 510,000 5.500% 44,550.00 554,550.00 08/01/2031 30,525.00 30,525.00 09/30/2031 585,075.00 02/01/2032 540,000 5.500% 30,525.00 570,525.00 08/01/2032 15,675.00 15,675.00 09/30/2032 586,200.00 02/01/2033 570,000 5.500% 15,675.00 585,675.00 09/30/2033 585,675.00 5,465,000 2,605,130.00 8,070,130.00 8,070,130.00 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 4 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas General Obligation and Refunding Bonds, Series 2009 Dated Date 07/01/2009 Delivery Date 08/13/2009 General Fund (GF) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 195,000 3.250% 123,268.75 318,268.75 08/01/2018 120,100.00 120,100.00 09/30/2018 438,368.75 02/01/2019 210,000 3.500% 120,100.00 330,100.00 08/01/2019 116,425.00 116,425.00 09/30/2019 446,525.00 02/01/2020 250,000 3.750% 116,425.00 366,425.00 08/01/2020 111,737.50 111,737.50 09/30/2020 478,162.50 02/01/2021 190,000 4.050% 111,737.50 301,737.50 08/01/2021 107,890.00 107,890.00 09/30/2021 409,627.50 02/01/2022 160,000 4.050% 107,890.00 267,890.00 08/01/2022 104,650.00 104,650.00 09/30/2022 372,540.00 02/01/2023 175,000 4.250% 104,650.00 279,650.00 08/01/2023 100,931.25 100,931.25 09/30/2023 380,581.25 02/01/2024 215,000 4.250% 100,931.25 315,931.25 08/01/2024 96,362.50 96,362.50 09/30/2024 412,293.75 02/01/2025 200,000 4.500% 96,362.50 296,362.50 08/01/2025 91,862.50 91,862.50 09/30/2025 388,225.00 02/01/2026 210,000 4.500% 91,862.50 301,862.50 08/01/2026 87,137.50 87,137.50 09/30/2026 389,000.00 02/01/2027 220,000 4.500% 87,137.50 307,137.50 08/01/2027 82,187.50 82,187.50 09/30/2027 389,325.00 02/01/2028 530,000 4.500% 82,187.50 612,187.50 08/01/2028 70,262.50 70,262.50 09/30/2028 682,450.00 02/01/2029 455,000 5.500% 70,262.50 525,262.50 08/01/2029 57,750.00 57,750.00 09/30/2029 583,012.50 02/01/2030 480,000 5.500% 57,750.00 537,750.00 08/01/2030 44,550.00 44,550.00 09/30/2030 582,300.00 02/01/2031 510,000 5.500% 44,550.00 554,550.00 08/01/2031 30,525.00 30,525.00 09/30/2031 585,075.00 02/01/2032 540,000 5.500% 30,525.00 570,525.00 08/01/2032 15,675.00 15,675.00 09/30/2032 586,200.00 02/01/2033 570,000 5.500% 15,675.00 585,675.00 09/30/2033 585,675.00 5,110,000 2,599,361.25 7,709,361.25 7,709,361.25 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 5 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas General Obligation and Refunding Bonds, Series 2009 Dated Date 07/01/2009 Delivery Date 08/13/2009 Sales Tax Supported (EDC) Period Ending Principal Coupon Annual Interest Debt Service Debt Service 02/01/2018 355,000 3.250% 5,768.75 360,768.75 09/30/2018 360,768.75 355,000 5,768.75 360,768.75 360,768.75 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 6 81010 WO M XUKETS, M. 0s]011H91:1c11[011:1. TJ141; City of Schertz, Texas General Obligation Refunding Bonds, Series 2010 Dated Date 10/01/2010 Delivery Date 11/30/2010 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 285,000 3.000% 21,375 306,375 08/01/2018 17,100 17,100 09/30/2018 323,475 02/01/2019 300,000 3.000% 17,100 317,100 08/01/2019 12,600 12,600 09/30/2019 329,700 02/01/2020 310,000 4.000% 12,600 322,600 08/01/2020 6,400 6,400 09/30/2020 329,000 02/01/2021 320,000 4.000% 6,400 326,400 09/30/2021 326,400 1,215,000 93,575 1,308,575 1,308,575 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 7 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas General Obligation Bonds, Series 2011 Dated Date 03/01/2011 Delivery Date 04/26/2011 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 240,000 3.500% 165,618.75 405,618.75 08/01/2018 161,418.75 161,418.75 09/30/2018 567,037.50 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 02/01/2035 525,000 5.000% 27,000.00 552,000.00 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 8 81010 WO M XUKETS, M. Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 9 BOND DEBT SERVICE City of Schertz, Texas General Obligation Bonds, Series 2011 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2035 13,875.00 13,875.00 09/30/2035 565,875.00 02/01/2036 555,000 5.000% 13,875.00 568,875.00 09/30/2036 568,875.00 7,070,000 3,711,668.75 10,781,668.75 10,781,668.75 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 9 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas General Obligation Refunding Bonds, Series 2011A Dated Date 12/15/2011 Delivery Date 12/15/2011 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 635,000 2.330% 47,590.25 682,590.25 08/01/2018 40,192.50 40,192.50 09/30/2018 722,782.75 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 2330% 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 4,085,000 348,276.75 4,433,276.75 4,433,276.75 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 10 81010 WO M XUKETS, M. 0s]011H91:1c11[011:1. TJ141; City of Schertz, Texas General Obligation Refunding Bonds, Series 2011 Dated Date 06/01/2011 Delivery Date 06/30/2011 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 03/01/2018 12,237.50 12,237.50 09/01/2018 225,000 2.250% 12,237.50 237,237.50 09/30/2018 249,475.00 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 930,000 64,750.00 994,750.00 994,750.00 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 11 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas General Obligation Bonds, Series 2012 Dated Date 08/01/2012 Delivery Date 09/13/2012 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 335,000 4.000% 87,397.50 422,397.50 08/01/2018 80,697.50 80,697.50 09/30/2018 503,095.00 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 6,120,000 1,423,490.00 7,543,490.00 7,543,490.00 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 12 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas Tax Notes, Series 2013 Dated Date 04/30/2013 Delivery Date 04/30/2013 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 13 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2018 170,000 1.700% 1,445 171,445 09/30/2018 171,445 170,000 1,445 171,445 171,445 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 13 81010 WO M RUKETS, M. 0s]011H91:1c11[011:11. TJ141; City of Schertz, Texas Tax Notes, Series 2013A Dated Date 06/04/2013 Delivery Date 06/04/2013 Period Ending Principal Coupon Annual Interest Debt Service Debt Service 02/01/2018 165,000 1.300% 1,072.50 166,072.50 09/30/2018 166,072.50 165,000 1,072.50 166,072.50 166,072.50 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 14 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2013 Dated Date 09/01/2013 Delivery Date 10/10/2013 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 390,000 2.000% 62,281.25 452,281.25 08/01/2018 58,381.25 58,381.25 09/30/2018 510,662.50 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,880,000 1,001,468.75 4,881,468.75 4,881,468.75 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 15 81010 WO M XUKETS, M. 0s]011H91:1c11[011:1. TJ141; City of Schertz, Texas General Obligation Refunding Bonds, Series 2013 Dated Date 10/10/2013 Delivery Date 10/10/2013 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 180,000 2.580% 20,640.00 200,640.00 08/01/2018 18,318.00 18,318.00 09/30/2018 218,958.00 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,600,000 170,538.00 1,770,538.00 1,770,538.00 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 16 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas General Obligation Refunding Bonds, Series 2014 Dated Date 05/15/2014 Delivery Date 06/26/2014 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 100,000 3.000% 145,637.50 245,637.50 08/01/2018 144,137.50 144,137.50 09/30/2018 389,775.00 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,200,000 2,518,937.50 10,718,937.50 10,718,937.50 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 17 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas Tax Notes, Series 2015 Dated Date 01/08/2015 Delivery Date 01/08/2015 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 10,587.50 10,587.50 08/01/2018 335,000 1.750% 10,587.50 345,587.50 09/30/2018 356,175.00 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 1,210,000 49,175.00 1,259,175.00 1,259,175.00 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 18 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas Tax Notes, Series 2015 Dated Date 01/08/2015 Delivery Date 01/08/2015 EMS 6 Years (CI131) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 4,287.50 4,287.50 08/01/2018 160,000 1.750% 4,287.50 164,287.50 09/30/2018 168,575.00 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 490,000 17,237.50 507,237.50 507,237.50 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 19 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas Tax Notes, Series 2015 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/2018 4,112.50 4,112.50 08/01/2018 115,000 1.750% 4,112.50 119,112.50 09/30/2018 123,225.00 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 470,000 20,737.50 490,737.50 490,737.50 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 20 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas Tax Notes, Series 2015 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/2018 918.75 918.75 08/01/2018 25,000 1.750% 918.75 25,918.75 09/30/2018 26,837.50 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 105,000 4,725.00 109,725.00 109,725.00 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 21 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas Tax Notes, Series 2015 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/2018 1,268.75 1,268.75 08/01/2018 35,000 1.750% 1,268.75 36,268.75 09/30/2018 37,537.50 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 145,000 6,475.00 151,475.00 151,475.00 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 22 81010 WO M RUKETS, M. 0s]011H91:1c11[011:11. TJ141; City of Schertz, Texas Tax Notes, Series 2015A Dated Date 11/19/2015 Delivery Date 11/19/2015 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 5,775.00 5,775.00 08/01/2018 145,000 1.540% 5,775.00 150,775.00 09/30/2018 156,550 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 750,000 34,958.00 784,958.00 784,958 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 23 81010 WO M XUKETS, M. 0s]011H91:1c11[011:1. TJ141; City of Schertz, Texas General Obligation Refunding Bonds, Series 2015 Dated Date 11/01/2015 Delivery Date 12/15/2015 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 490,000 2.000% 48,812.50 538,812.50 08/01/2018 43,912.50 43,912.50 09/30/2018 582,725.00 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,655,000 639,512.50 4,294,512.50 4,294,512.50 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 24 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas General Obligation Bonds, Series 2016 Dated Date 08/01/2016 Delivery Date 09/01/2016 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 205,000 4.000% 85,853.13 290,853.13 08/01/2018 81,753.13 81,753.13 09/30/2018 372,606.26 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 02/01/2035 360,000 3.000% 10,950.00 370,950.00 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 25 81010 WO M XUKETS, M. Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 26 BOND DEBT SERVICE City of Schertz, Texas General Obligation Bonds, Series 2016 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2035 5,550.00 5,550.00 09/30/2035 376,500.00 02/01/2036 370,000 3.000% 5,550.00 375,550.00 09/30/2036 375,550.00 5,475,000 1,644,796.99 7,119,796.99 7,119,796.99 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 26 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2016A Dated Date 08/01/2016 Delivery Date 09/01/2016 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 165,000 4.000% 36,384.38 201,384.38 08/01/2018 33,084.38 33,084.38 09/30/2018 234,468.76 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 02/01/2035 95,000 3.000% 2,925.00 97,925.00 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 27 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2016A Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2035 1,500.00 1,500.00 09/30/2035 99,425.00 02/01/2036 100,000 3.000% 1,500.00 101,500.00 09/30/2036 101,500.00 2,205,000 506,753.26 2,711,753.26 2,711,753.26 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 28 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2016A Dated Date 08/01/2016 Delivery Date 09/01/2016 Remodel Component (REMODEL) Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 29 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2018 110,000 4.000% 14,700 124,700 08/01/2018 12,500 12,500 09/30/2018 137,200 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 735,000 91,700 826,700 826,700 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 29 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2016A 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/2018 55,000 4.000% 21,684.38 76,684.38 08/01/2018 20,584.38 20,584.38 09/30/2018 97,268.76 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 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 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 30 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2016A Road Work Component (ROAD) Period Ending Principal Coupon Annual Interest Debt Service Debt Service 08/01/2035 1,500.00 1,500.00 09/30/2035 99,425.00 02/01/2036 100,000 3.000% 1,500.00 101,500.00 09/30/2036 101,500.00 1,470,000 415,053.26 1,885,053.26 1,885,053.26 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 31 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas Combination Tax and Limited Pledge Revenue Certificates of Obligation, Taxable Series 2016B 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/2018 55,000 3.000% 24,031.25 79,031.25 08/01/2018 23,206.25 23,206.25 09/30/2018 102,237.50 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 09/30/2034 104,093.75 02/01/2035 95,000 3.750% 3,656.25 98,656.25 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 32 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas Combination Tax and Limited Pledge Revenue Certificates of Obligation, Taxable Series 2016B YMCA Lease Payment Supported Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2035 1,875.00 1,875.00 09/30/2035 100,531.25 02/01/2036 100,000 3.750% 1,875.00 101,875.00 09/30/2036 101,875.00 1,420,000 528,093.75 1,948,093.75 1,948,093.75 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 33 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2017 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 34 Dated Date 05/15/2017 Delivery Date 06/20/2017 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2018 345,000 3.000% 118,595.56 463,595.56 08/01/2018 78,212.50 78,212.50 09/30/2018 541,808.06 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 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 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 34 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2017 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2036 255,000 3.250% 8,450.00 263,450.00 08/01/2036 4,306.25 4,306.25 09/30/2036 267,756.25 02/01/2037 265,000 3.250% 4,306.25 269,306.25 09/30/2037 269,306.25 5,475,000 1,550,683.06 7,025,683.06 7,025,683.06 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 35 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas General Obligation Bonds, Series 2017 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 36 Dated Date 05/15/2017 Delivery Date 06/20/2017 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2018 135,000 3.000% 85,706.67 220,706.67 08/01/2018 58,237.50 58,237.50 09/30/2018 278,944.17 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 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 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 36 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas General Obligation Bonds, Series 2017 Period Ending Principal Coupon Annual Interest Debt Service Debt Service 08/01/2036 4,225.00 4,225.00 09/30/2036 262,512.50 02/01/2037 260,000 3.250% 4,225.00 264,225.00 09/30/2037 264,225.00 3,935,000 1,372,169.17 5,307,169.17 5,307,169.17 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 37 81010 WO M XUKETS, M. 0s]011H91:1c11[011:1. TJ141; City of Schertz, Texas General Obligation Refunding Bonds, Series 2018 Dated Date 01/04/2018 Delivery Date 01/04/2018 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 08/01/2018 73,566.65 73,566.65 09/30/2018 73,566.65 02/01/2019 550,000 2.120% 63,971.00 613,971.00 08/01/2019 58,141.00 58,141.00 09/30/2019 672,112.00 02/01/2020 560,000 2.120% 58,141.00 618,141.00 08/01/2020 52,205.00 52,205.00 09/30/2020 670,346.00 02/01/2021 570,000 2.120% 52,205.00 622,205.00 08/01/2021 46,163.00 46,163.00 09/30/2021 668,368.00 02/01/2022 585,000 2.120% 46,163.00 631,163.00 08/01/2022 39,962.00 39,962.00 09/30/2022 671,125.00 02/01/2023 595,000 2.120% 39,962.00 634,962.00 08/01/2023 33,655.00 33,655.00 09/30/2023 668,617.00 02/01/2024 610,000 2.120% 33,655.00 643,655.00 08/01/2024 27,189.00 27,189.00 09/30/2024 670,844.00 02/01/2025 625,000 2.120% 27,189.00 652,189.00 08/01/2025 20,564.00 20,564.00 09/30/2025 672,753.00 02/01/2026 635,000 2.120% 20,564.00 655,564.00 08/01/2026 13,833.00 13,833.00 09/30/2026 669,397.00 02/01/2027 645,000 2.120% 13,833.00 658,833.00 08/01/2027 6,996.00 6,996.00 09/30/2027 665,829.00 02/01/2028 660,000 2.120% 6,996.00 666,996.00 09/30/2028 666,996.00 6,035,000 734,953.65 6,769,953.65 6,769,953.65 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 38 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas Contract Revenue Bonds, Series 2001 Schertz /Seguin local Government Corp. Dated Date 08/01/2006 Delivery Date 08/01/2006 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 260,000 260,000 08/01/2018 260,000 260,000 09/30/2018 520,000 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 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 39 81010 WO M XUKETS, M. Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 40 BOND DEBT SERVICE City of Schertz, Texas Contract Revenue Bonds, Series 2001 Schertz /Seguin local Government Corp. Annual Period Debt Debt Ending Principal Coupon Interest Service Service 08/01/2034 57,590 57,590 09/30/2034 2,269,780 02/01/2035 2,215,000 5.200% 57,590 2,272,590 09/30/2035 2,272,590 10,000,000 8,114, 340 18,114, 340 18,114, 340 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 40 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas Contract Revenue Bonds, Series 2010 Schertz /Seguin local Government Corp. Dated Date 06/01/2010 Delivery Date 07/14/2010 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2018 505,000 3.500% 08/01/2018 438,731.25 09/30/2018 1,391,300.00 02/01/2019 520,000 3.500% 08/01/2019 429,631.25 09/30/2019 1,388,362.50 02/01/2020 540,000 3.500% 08/01/2020 420,181.25 09/30/2020 1,389,812.50 02/01/2021 560,000 4.000% 08/01/2021 408,981.25 09/30/2021 1,389,162.50 02/01/2022 585,000 4.000% 08/01/2022 397,281.25 09/30/2022 1,391,262.50 02/01/2023 610,000 4.000% 08/01/2023 385,081.25 09/30/2023 1,392,362.50 02/01/2024 630,000 4.000% 08/01/2024 372,481.25 09/30/2024 1,387,562.50 02/01/2025 660,000 4.000% 08/01/2025 359,281.25 09/30/2025 1,391,762.50 02/01/2026 685,000 4.125% 08/01/2026 345,153.13 09/30/2026 1,389,434.38 02/01/2027 715,000 4.250% 08/01/2027 329,959.38 09/30/2027 1,390,112.51 02/01/2028 745,000 4.250% 08/01/2028 314,128.13 09/30/2028 1,389,087.51 02/01/2029 780,000 4.250% 08/01/2029 297,553.13 09/30/2029 1,391,681.26 02/01/2030 815,000 4.500% 08/01/2030 279,215.63 09/30/2030 1,391,768.76 02/01/2031 850,000 4.500% 08/01/2031 260,090.63 09/30/2031 1,389,306.26 02/01/2032 890,000 4.500% 08/01/2032 240,065.63 09/30/2032 1,390,156.26 02/01/2033 930,000 4.625% 08/01/2033 218,559.38 09/30/2033 1,388,625.01 02/01/2034 975,000 4.625% 08/01/2034 196,012.50 09/30/2034 1,389,571.88 02/01/2035 1,020,000 4.625% 08/01/2035 172,425.00 09/30/2035 1,388,437.50 02/01/2036 1,070,000 4.750% 447,568.75 952,568.75 438,731.25 438,731.25 1,391,300.00 438,731.25 958,731.25 429,631.25 429,631.25 1,388,362.50 429,631.25 969,631.25 420,181.25 420,181.25 1,389,812.50 420,181.25 980,181.25 408,981.25 408,981.25 1,389,162.50 408,981.25 993,981.25 397,281.25 397,281.25 1,391,262.50 397,281.25 1,007, 281.25 385,081.25 385,081.25 1,392,362.50 385,081.25 1,015,081.25 372,481.25 372,481.25 1,387,562.50 372,481.25 1,032,481.25 359,281.25 359,281.25 1,391,762.50 359,281.25 1,044, 281.25 345,153.13 345,153.13 1,389,434.38 345,153.13 1,060,153.13 329,959.38 329,959.38 1,390,112.51 329,959.38 1,074,959.38 314,128.13 314,128.13 1,389,087.51 314,128.13 1,094,128.13 297,553.13 297,553.13 1,391,681.26 297,553.13 1,112,553.13 279,215.63 279,215.63 1,391,768.76 279, 215.63 1,129, 215.63 260,090.63 260,090.63 1,389,306.26 260,090.63 1,150,090.63 240,065.63 240,065.63 1,390,156.26 240,065.63 1,170,065.63 218,559.38 218,559.38 1,388,625.01 218,559.38 1,193,559.38 196,012.50 196,012.50 1,389,571.88 196,012.50 1,216,012.50 172,425.00 172,425.00 1,388,437.50 172,425.00 1, 242, 425.00 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 41 81010 WO M XUKETS, M. Period Ending Principal BOND DEBT SERVICE City of Schertz, Texas Contract Revenue Bonds, Series 2010 Schertz /Seguin local Government Corp. Coupon Interest Debt Service Annual Debt Service 08/01/2036 147,012.50 147,012.50 09/30/2036 1,389,437.50 02/01/2037 1,125,000 4.750% 147,012.50 1,272,012.50 08/01/2037 120,293.75 120,293.75 09/30/2037 1,392,306.25 02/01/2038 1,175,000 4.750% 120,293.75 1,295,293.75 08/01/2038 92,387.50 92,387.50 09/30/2038 1,387,681.25 02/01/2039 1,235,000 4.750% 92,387.50 1,327,387.50 08/01/2039 63,056.25 63,056.25 09/30/2039 1,390,443.75 02/01/2040 1,295,000 4.750% 63,056.25 1,358,056.25 08/01/2040 32,300.00 32,300.00 09/30/2040 1,390,356.25 02/01/2041 1,360,000 4.750% 32,300.00 1,392,300.00 09/30/2041 1,392,300.00 20,275,000 13,087,293.83 33,362,293.83 33,362,293.83 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 42 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas Contract Revenue Refunding Bonds, Series 2014 Schertz /Seguin Local Government Corp. Dated Date 09/01/2014 Delivery Date 10/15/2014 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 530,000 2.000% 69,587.50 599,587.50 08/01/2018 64,287.50 64,287.50 09/30/2018 663,875.00 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,680,000 635,312.50 5,315,312.50 5,315,312.50 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 43 BOND DEBT SERVICE Schertz- Seguin Local Governement Corporation $7,300,000 Contract Revenue Bond, Series 2015 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 44 Dated Date 12/01/2014 Delivery Date 01/13/2015 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2018 730,000 3.000% 862,525 1,592,525 08/01/2018 851,575 851,575 09/30/2018 2,444,100 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 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 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 44 BOND DEBT SERVICE Schertz- Seguin Local Governement Corporation $7,300,000 Contract Revenue Bond, Series 2015 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 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 40,325,000 26,391,475 66,716,475 66,716,475 Dec 12, 2017 11:57 am Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 45 Schertz, City Texas Municipal Reports i➢. (General Obligation Debt) Last Revised: $/1/2017 o TIVIR # 2302 ,- Guadalupe, Comal, Bexar Counties Page 1 of 13 1;�1�11�L .�31t1� FOR OPERATING DATA OF THE WATERWORKS AND SEWER SYSTEM, SEE SEPARATE TEXAS MUNICIPAL REPORT. FINANCIAL STATEMENT (As of September 30, 2016) Net Taxable Assessed Valuation ( "A.V. "), 2016 New Debt Outstanding Debt Total General Obligation Debt Less: Self - Supporting (a) Water & Sewer EMS Building Drainage Economic Development (Type B) GO Debt payable from Ad Valorem Taxes Less: I &S Fund Net Debt $3.683.394,908 $9,410,000 73.175.000 $82.585.000 11,359,976 650,034 579,964 390.374 $69,604.652 1,311,577 $68,293,075 (a) The May 23, 2017 Official Statement reports the following General Obligation Debt being paid from revenues other than ad valorem taxes: thus considered self- supporting. Net Debt Per Net Taxable Assessed Valuation - 1.85% Net Debt Per SO mile $2,764,901.82 Net Debt Per Capita $1,803.59 Net Taxable Assessed Valuation Per Capita - $97,277.03 Bureau of Census Pop: 2000 18,694 Bureau of Census Pop: 2010 31,465 2016 Estimated Population - 37,865 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/2016* 2011 $2,411,270,623 $0.4843 $11,239.572 99.29 99.90 2012 2,600.365,551 0.4999 12,536.540 99.35 99.88 2013 2,752,562,574 0.4974 13,383,759 99.35 99.78 2014 3,037,267,611 0.4974 14,793,867 99.63 99.83 2015 3,375,850,131 0.4911 16,238,180 99.52 99.52 2016 3,683,394,908 0.4911 18,089,152 (In process of collection) * Delinquent tax collections are allocated to the respective years in which the taxes are levied. Tax Rate Distribution 2016 2015 2014 2013 Operations $0.3168 $0.3159 $0.3164 $0.3010 I &S 0.1743 0.1752 0.1810 0.1964 Totals $0.4911 $0.4911 $0.4974 $0.4974 Tax Rate Limitation: Article XI, Section 5 of Texas Constitution, applicable to cities of more than 5,000 population, $2.50 per $100 assessed valuation. City operates under a Home Rule Charter which adopts constitutional provisions. TAX ABATEMENTS The City currently has 4 tax abatement agreements. There were no tax abatement losses for the 2016 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 Senora 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: 2011 16,279,087 2012 14,300,641 2013 15,046,362 2014 11.664.298 2015 15,879,383 2016 18,033.005 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 Schertz 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 2013 1.500% $9,716,195 72.59% $0.36 2014 1.500 10,445,078 70.60 0.35 2015 1.500 10.303,429 61.77 0.30 2016 1.500 10.992,476 59.57 0.29 DETAILS OF OUTSTANDING DEBT Details of Limited Tax Debt (Outstanding 9/3012016) Comb Tax & Ltd Pledge Rev C/O Ser 2007 Tax Treatment: Tax Exempt Original Issue Amount $9,915,000.00 Dated Date: 0110112007 Sale Date: 12/19/2006 Delivery Date: 0111712007 Sale Type: Private Placement Record Date: MSRB Bond Form: BE Denomination $100,000 Interest pays Semi - Annually: 02101, 08/01 1st Coupon Date: 08/01/2007 Paying Agent: The Bank of New York Mellon Trust Company, N.A., Houston, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Purchaser: JPMorgan Chase Bank, N.A. Security : Limited Tax and a subordinate lien on the net revenues of the Waterworks & Sewer system not to exceed $1,000. Water & Sewer 100.00% Use of Proceeds: Utility, Streets & Drainage, Public Works, Energy Management Sys, Communication Equipment. r ...�` , a' Orig Reoffering Maturity Amount Coupon Price /Yield 08/01/2017 330,000.00 4.0100% N/A 08/01/2018 340,000.00 4.0100% N/A 08/01/2019 355,000.00 4.0100% N/A r ...�` , a' ,; i Texas Municipal Reports Fe � i➢. (General Obligation Debt) Last Revised: 8/1/2017 o TMR # 2302 , - Guadalupe, Comal, Bexar Counties Page 2 of 13 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 02/01/2020 $315,000 02/01/2021 $3,960,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 Tax Treatment: Original Issue Amount Dated Date: Sale Date: Delivery Date: Sale Type: Record Date: Bond Form: Denomination Interest pays 1st Coupon Date: Tax Exempt $6,000,000.00 09/01/2007 09/04/2007 09/24/2007 Private Placement MSRB BE $100,000 Semi- Annually: 08/01, 02101 02/01/2008 Paying Agent: The Bank of New York Mellon Trust Company, N.A., Houston, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Purchaser: JPMorgan Chase Bank, N.A. Use of Proceeds: Recreational Facilities, Streets & Sidewalks, Drainage. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/20277 3,775,000.00 4.0700% N/A $3,775,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 02/01/2011 $275,000 02/01/2012 $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 0210112018 $290,000 02/01/2019 $300,000 02/01/2020 $315,000 02/01/2021 $325,000 02/01/2022 $340,000 0210112023 $355,000 0210112024 $370,000 02/01/2025 $385,000 02/01/2026 $400,000 02/01/2027 $415.000 GO Bds Ser 2008 Tax Freatment: Bank Qualified Original Issue Amount $9,900,000.00 Dated Date: 08/01/2008 Sale Date: 08/12/2008 Delivery Date: 09/10/2008 Sale Type: Private Placement Record Date: MSRB Bond Form: BE Denomination $100,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 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/2017 460,000.00 Tax Treatment: 4.1300% N/A 02/01/2018 475,000.00 Sale Date: 4.1300% N/A 02/01/2019 500.000.00 Negotiated 4.1300% N/A 0210112020 520,000.00 Denomination 4.1300% N/A 02/01/2021 540,000.00 0210112010 4.1300% N/A 0210112022 565,000.00 4.1300% N/A 02/01/2023 585,000.00 4.1300% N/A 02/01/2024 610,000.00 4.1300% N/A 02/01/2025 640,000.00 4.1300% N/A 02/01/2026 665,000.00 4.1300% N/A 0210112027 690.000.00 4.1300% N/A 02/01/2028 720,000.00 4.1300% N/A $6,970,000.00 Call Option: Bonds maturing on 02/01/2019 to 02/01/2028 callable in whole or in part on any date beginning 02/01/2018 @ par. 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 Economic Development (Type B) 6.49% Use of Proceeds: Streets, Refunding, Recreational Facilities. Refunding Notes: This issue defeased mty(s) 2/1 /2010- 2/1/2018 of GO Bds Ser 98 @ par. Orig Reoffering Maturity Amount Coupon Price /Yield 0210112017 550,000.00 3.0000% 3.160% 02/01/2018 550,000.00 "l, 3.2500% 3.340% 02/01/2019 210,000.00 3.5000% 1510% 0210112020 250,000.00 3.7500% 3.760% 02101120227 350,000.00 4.0500% 4.060% 02/01/20247 390,000.00 4.2500% 100.00% 5 .. 1. "l, ,; i Texas Municipal Reports "o E i➢. (General Obligation Debt) Last Revised: $/1/2017 o TMR # 2302 ,- Guadalupe, Comal, Bexar Counties Page 3 of 13 02/01/2028T 1,160,000.00 4.5000% 4.600% 02/01/2033T 2,555,000.00 5.5000% 4.700% $6,015,000.00 Call Option: Bonds maturing on 0210112020 and term bonds maturing on 0210112022 and 0210112024 and 02/01/2028 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: 285,000.00 Mandatory Redemption Date Principal Amount 02/01/2029 $455.000 0210112030 $480,000 02/01/2031 $510,000 0210112032 $540,000 02/01/2033 $570.000 GO Ref Bds Ser 2010 285,000.00 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 0210112017 285,000.00 3.0000% 2.150% Tax Exempt 02/01/2018 285,000.00 3.0000% 2.400% 03/01/2011 02/01/2019 300,000.00 3.0000% 2.650% 04/26/2011 0210112020 310,000.00 4.0000% 2.850% MSRB 0210112021 320,000.00 4.0000% 3.020% $5,000 $1,500,000.00 Call Option: Bonds maturing on 02/01/2019 to 0210112021 callable in whole or in part on any date beginning 0210112018 @ par. GO Bds Ser 2011 "fax 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: Sports Complex, Aquatic Center, Animal Shelter. Orig Reoffering Maturity Amount Coupon Price /Yield 0210112017 235,000.00 3.0000% 2.410% 02/01/2018 240,000.00 15000% 2.730% 02/01/2019 250,000.00 3.5000% 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% 02/01/2028 375,000.00 4.5000% 4.610% 02/01/2029 390,000.00 4.6250% 4.720% 0210112030 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,305,000.00 Call Option: Bonds maturing on 0210112024 to 02/01/2030 and term bonds maturing on 0210112023 and 0210112032 and 02/01/2034 and 02/01/2036 callable in whole or in part on any date beginning 0210112021 @ 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/0112034: Mandatory Redemption Date Principal Amount 02/01/2033 $475,000 02/01/2034 $500,000 Term bonds maturing on 02/01/2036: Mandatory Redemption Date Principal Amount 02/01/2035 $525,000 02/01/2036 $555,000 GO Ref Bds Ser 2011 Tax Treatment: Tax Exempt Original Issue Amount $2,675,000.00 Dated Date: 06/01/2011 ., ..< c, -d _ t f u, , a. ..... .. a " t, , ,; i Texas Municipal Reports Fe E i (General Obligation Debt) Last Revised: 8/1/2017 TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 4 of 13 Sale Date: 06/07/2011 Delivery Date: 06/30/2011 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 09/01, 03/01 1st Coupon Date: 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/2017 300,000.00 2.0000% 2.100% 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% Semi- Annually: 08/01, 02101 1st Coupon Date: 0210112012 $1,230,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: BE 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. prig Reoffering Maturity Amount Coupon Price /Yield 02/01/2017 620,000.00 2.3300% N/A 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 ------------------------------------------- - - - - -- $4,705,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 320,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 0210112017 320,000.00 4.3500% 1.000% 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 2.2500% 2.400% 0210112024 390,000.00 2.5000% 2.600% 02/01/2025 400,000.00 2.7000% 2.750% 0210112026 415,000.00 Z8000% Z900% 02/01/20287 865,000.00 3.0000% 3.100% 02/01/20307 915,000.00 3.0000% 3.160% 02/01/20327 975,000.00 3.1000% 3.240% $6.440.000.00 Call Option: Bonds maturing on 0210112023 to 0210112026 and term bonds maturing on 02/01/2028 and 02/01/2030 and 0210112032 callable in whole or in part on any date beginning 0210112022 @ par. Term Call: Term bonds maturing on 02/01/2028: Mandatory Redemption Date Principal Amount 0210112027 $425,000 02/01/2028 $440,000 Term bonds maturing on 0210112030: Mandatory Redemption Date Principal Amount 02/01/2029 $450,000 0210112030 $465,000 Term bonds maturing on 0210112032: Mandatory Redemption Date Principal Amount 0210112031 $480,000 02/01/2032 $495,000 Tax Notes Ser 2013 Tax Treatment: Tax Exempt Original Issue Amount $835,000.00 Dated Date: 04/01/2013 Sale Date: 04/09/2013 Delivery Date: 04/30/2013 _ „ ,, w.n ; ret .., .. , . ,., 7' Ti""!; ,w. r ,; i Texas Municipal Reports '_' F i (General Obligation Debt) Last Revised: 8/1/2017 TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 5 of 13 Sale Type: Private Placement Record Date: MSRB Bond Form: BE Denomination $100,000 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. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2017 170,000.00 1.3000% 100.00% 02/01/2018 170,000.00 1.7000% 100.00% $340,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: BE Denomination $100,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 02/01/2014 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, NO Use of Proceeds: Public Safety. Orig Reoffering Maturity Amount Coupon Price /Yield 0210112017 160,000.00 1.3000% N/A 02/01/2018 165,000.00 1.3000% N/A --------- - - - - -- $325,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 C/O Ser 2013 Tax Treatment: Bank Qualified Original Issue Amount $4,965,000.00 Dated Date: 09/01/2013 Sale Date: 09/1.0/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: 0210112014 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 0210112017 380,000.00 Tax Treatment: 2.0000% 1.000% 02/01/2018 390.000.00 09/01/2013 2.0000% 1.350% 02/01/2019 395.000.00 Sale Type: 2.2500% 1.600% 0210112020 405,000.00 BE 2.5000% 1.900% 0210112021 415,000.00 1st Coupon Date: 3.0000% 2.180% 0210112022 155,000.00 3.0000% 2.350% 0210112023 160,000.00 3.0000% 2.550% 0210112024 165,000.00 3.5000% 2.700% 02/01/2025 170,000.00 15000% 2.850% 02/01/2026 175.000.00 15000% 3.000% 02/01/20287 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% $4,260.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 0210112032 $225,000 02/01/2033 $230.000 GO Ref Bds 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: BE 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. Y .�. �U �. t,w« 0, �. �< C, , .., . „C �s r r ,. �f , J in ,; i Texas Municipal Reports '_' i (General Obligation Debt) Last Revised: 8/1/2017 TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 6 of 13 Refunding Notes: This bond refunded maturities from the following issues Comb Tax & Subord Lien Rev C/O Ser 2005 Refunded Amount Mat Date Sched Call Price 155,000 02/01/2015 02/01/2014 Par 325,000 0210112017 0210112014 Par 170,000 02/01/2018 0210112014 Par 180.000 02/01/2019 0210112014 Par 185,000 0210112020 0210112014 Par 195,000 0210112021 02/01/2014 Par 860.000 0210112025 02/01/2014 Par Orig Reoffering Maturity Amount Coupon Price /Yield 0210112017 180,000.00 2.5800% N/A 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 ------------------------------------------- - - - - -- $1.780.000.00 Call Option: Bonds maturing on 0210112024 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: BODE, 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 0210112023 5.250 1,715,000.00 0210112025 5.250 1,900,000.00 0210112027 5.250 3.220.000.00* 0210112031 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 0210112017 100,000.00 2.0000% 0.800% 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% 02/01/2021 100,000.00 3.0000% 1.750% 02/01/2022 750,000.00 3.0000% 1.900% 02/01/2023 775,000.00 3.0000% 2.050% 0210112024 800,000.00 Tax Treatment: 3.5000% 2.200% 02/01/2025 830,000.00 1210112014 15000% 2.400% 02/01/2026 860,000.00 Sale Type: 3.5000% 2.500% 0210112027 890,000.00 BE 4.0000% 2.550% 0210112028 930,000.00 1st Coupon Date: 4.0000% 2.650% 0210112029 960,000.00 4.0000% 2.750% 0210112030 1,005,000.00 3.5000% 3.100% $8,300,000.00 Call Option: Bonds maturing on 0210112024 to 02/01/2030 callable in whole or in part on any date beginning 02/01/2023 @ par. Tax Notes Ser 2015 330,000.00 Tax Treatment: Tax Exempt Original Issue Amount $2,125,000.00 Dated Date: 1210112014 Sale Date: 12/16/2014 Delivery Date: 01/08/2015 Sale Type: Private Placement Record Date: MSRB Bond Form: BE Denomination $100,000 Interest pays Semi - Annually: 02101, 08/01 1st Coupon Date: 08/01/2015 Paying Agent: Frost Bank, San Antonio, TX Bond Counsel: Norton Rose Fulbright US LLP Financial Advisor: Southwest Securities, San Antonio, TX Purchaser: Frost Bank, San Antonio, TX Water & Sewer 8.44% EMS Building 42.21% Drainage 37.66% Use of Proceeds: Public Works. Orig Reoffering Maturity Amount Coupon Price /Yield 08/01/2017 330,000.00 Tax Treatment: 1.7500% N/A 08/01/2018 335,000.00 1011512015 1.7500% N/A 08/01/2019 340,000.00 Sale Type: 1.7500% N/A 08/01/2020 345,000.00 BE 1.7500% N/A 0810112021 190,000.00 1st Coupon Date: 1.7500% N/A $1,540,000.00 Call Option: Non Callable Tax Notes Ser 2015A Tax Treatment: Tax Exempt Original Issue Amount $1,020,000.00 Dated Date: 1011512015 Sale Date: 1012712015 Delivery Date: 11/19/2015 Sale Type: Private Placement Record Date: MSRB Bond Form: BE Denomination $1.00,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 ,. T, { t "q _ .I .. .,. _._ . , .t ,; i Texas Municipal Reports "C t i (General Obligation Debt) Last Revised: 8/1/2017 TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 7 of 13 Maturity Amount Coupon Price /Yield 08/01/2017 145,000.00 1.5400% N/A 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 08/01/2021 150,000.00 1.5400% N/A 08/01/2022 155,000.00 1.5400% N/A --------------------- ------------ ------------ - - - - -- $895.000.00 Call Option: Non Callable GO Ref Bds Ser 2015 Pledge Rev C/O Ser 2016A Tax Treatment: Tax Exempt Original Issue Amount $4,185,000.00 Dated Date: 11/01/2015 Sale Date: 11/17/2015 Delivery Date: 12/15/2015 Sale Type: Competitive TIC: 2.6015% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 0210112016 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: BOSC, Inc. Use of Proceeds: Refunding. Refunding Notes: This bond refunded GO Bds Ser 2006 Refunded Amount Mat Date Coupon 425,000.00 0210112017 4.125 475,000.00 02/01/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 Call 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/2017 02/01/2018 02/01/2019 02/01/2020 02/01/2021 02/01/2031 450,000.00 490,000.00 660,000.00 675,000.00 690,000.00 1.140.000.00 2.0000% 0.600% 2.0000% 0.940% 2.0000% 1.150% 2.5000% 1.360% 3.0000% 1.550% 3.2500% 3.400% $4,105,000.00 Call Option: Bonds maturing on 02/01/2031 callable in whole or in part on any date beginning 0210112025 @ par. Comb Tax & Ltd Pledge Rev C/O Ser 2016A Tax Treatment: Tax Exempt Original Issue Amount $2,375,000.00 Dated Date: 08/01/2016 Sale Date: 08/02/2016 Delivery Date: 09/01/2016 Sale Type: Competitive TIC: 2.2663% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 0210112017 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Fidelity Capital Markets Co- Manager: City Securities Co- Manager: Jefferies LLC Co- Manager: Morgan Stanley Co- Manager: Raymond James Security : Limited Tax and a Subordinate lien on the Net revenues of the Utility system not to exceed $1,000. Use of Proceeds: Public Improvements. Orig Reoffering Maturity Amount Coupon Price /Yield 0210112017 170,000.00 Sale Date: 4.0000% 0.600% 02/01/2018 165,000.00 Competitive 4.0000% 0.740% 02/01/2019 175,000.00 Bond Form: 4.0000% 0.840% 0210112020 180,000.00 Semi- Annually: 08/01, 02101 4.0000% 0.980% 0210112021 190,000.00 4.0000% 1.070% 0210112022 195,000.00 4.0000% 1.240% 0210112023 205,000.00 4.0000% 1.400% 0210112024 70,000.00 3.0000% 1.530% 02/01/2025 75,000.00 10000% 1.670% 02/01/2026 75,000.00 3.0000% 1.820% 0210112027 80,000.00 2.0000% 2.020% 0210112028 80,000.00 2.0000% 2.150% 0210112029 80,000.00 2.1250% 2.300% 0210112030 85,000.00 2.2500% 2.400% 0210112031 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/20367 285,000.00 3.0000% 100.00% - - - -- - -- ---- - - - - -- $2,375,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 0210112034 $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: BOKF, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX t w ,; i Texas Municipal Reports "o F i (General Obligation Debt) Last Revised: 8/1/2017 so q TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 8 of 13 Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Robert W. Baird & Co., Inc. Co- Manager: Alamo Capital Co- Manager: CL King & Associates Co- Manager: Crews & Associates, Inc. Co- Manager: Cronin & Co. Co- Manager: Davenport & Co. LLC Co- Manager: Duncan-Williams, Inc. Co- Manager: Edward Jones Co- Manager: First Empire Securities Co- Manager: FMSbonds, Inc. Co- Manager: FTN Financial Co- Manager: IFS Securities, Inc. Co- Manager: Isaak Bond Co- Manager: Loop Capital Markets LLC Co- Manager: Midland Securities, Ltd Co- Manager: Oppenheimer & Co. Inc. Co- Manager: R. Seelaus & Co., Inc. Co- Manager: Rafferty Capital Markets, LLC Co- Manager: Ross, Sinclaire & Associates, Inc. Co- Manager: Sierra Pacific Co- Manager: SumRidge Partners, LLC Co- Manager: W. I. Mel] Associates, Inc Co- Manager: Wayne Hummer Investments Co- Manager: Wedbush Morgan Securities Co- Manager: WNJ Capital Security : Limited Tax and a Subordinate lien on the Net revenues of the Utility system. Use of Proceeds: Aquatic Center. Orig Reoffering Maturity Amount Coupon Price /Yield 0210112017 55,000.00 3.0000% 1.000% $75.000 02/01/2018 55,000.00 3.0000% 1.100% $80,000 02/01/2019 55,000.00 3.0000% 1.250% $85.000 0210112020 60,000.00 3.0000% 1.450% 2.4799% 0210112021 60,000.00 3.0000% 1.650% BE 0210112022 60,000.00 3.0000% 1.800% Semi- Annually: 08/01, 02101 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/20317 395,000.00 3.5000% 2.800% 02/O1/2036T 465.000.00 3.7500% 3.000% $1,475,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 A Y r 7� . , $465.000 GO Bds Ser 2016 Tax Treatment: Tax Exempt Original Issue Amount $5,880,000.00 Dated Date: 08/01/2016 Sale Date: 08/02/2016 Delivery Date: 09/01/2016 Sale. Type: Competitive TIC: 2.4799% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 0210112017 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Fidelity Capital Markets Co- Manager: City Securities Co- Manager: Jefferies LLC Co- Manager: Morgan Stanley Co- Manager: Raymond James Use of Proceeds: Streets & Drainage. Orig Reoffering Maturity Amount Coupon Price /Yield 0210112017 405.000.00 2.0000% 0.650% 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% 0210112022 245,000.00 4.0000% 1.240% 0210112023 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% 02/01/2028 300,000.00 2.0000% 2.150% 02/01/2029 305,000.00 2.1250% 2.300% 0210112030 310,000.00 2.2500% 2.400% 0210112031 320.000.00 2.3750% 2.500% 0210112032 330.000.00 2.5000% 2.600% 02/01/2033 335,000.00 3.0000% 2.700% 02/01/20367 1.075.000.00 3.0000% 100.00% -- ---- - - - - -- $5.880.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 ,; i Texas Municipal Reports Fe � i (General Obligation Debt) Last Revised: 8/1/2017 TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 9 of 13 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: 0210112018 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Robert W. Baird & Co., Inc. Co- Manager: Alamo Capital Co- Manager: CL King & Associates Co- Manager: Commerce Bank Co- Manager: Country Club Bank Co- Manager: Davenport & Co. LLC Co- Manager: Dougherty & Company LLC Co- Manager: Duncan - Williams, Inc. Co- Manager: Edward Jones Co- Manager: First Empire Securities Co- Manager: First Kentucky Securities Co- Manager: FMSbonds, Inc. Co- Manager: IFS Securities, Inc. Co- Manager: Isaak Bond Co- Manager: Loop Capital Markets LLC Co- Manager: Midland Securities, Ltd Co- Manager: Oppenheimer & Co. Inc. Co- Manager: Rafferty Capital Markets, LLC Co- Manager: Ross, Sinclaire & Associates, Inc. Co- Manager: Sierra Pacific Co- Manager: Stephens Inc. Co- Manager: SumRidge Partners, LLC Co- Manager: UMB Bank Co- Manager: Vining- Sparks IBG Co- Manager: W. H. Mull Associates, Inc Co- Manager: Wayne Hummer Investments Co- Manager: Wedbush Securities Co- Manager: WNJ Capital Security : Limited Tax and a Subordinate lien on the Net revenues of the Utility system not to exceed $1,000. Use of Proceeds: Public Improvements. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/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 0210112023 315,000.00 3.0000% 1.650% Semi - Annually: 08/01, 02101 0210112024 325,000.00 3.0000% 1.750% 02/01/2025 185,000.00 3.0000% 1.900% 02/01/2026 190,000.00 3.0000% 2.000% 0210112027 195,000.00 3.0000% 2.150% 02/01/2028 200,000.00 3.0000% 2.300% 02/01/2029 205,000.00 3.0000% 2.400% 0210112030 215,000.00 3.0000% 2.500% 02/01/2031 220,000.00 3.0000% 2.600% 02/01/2033T 460,000.00 3.0000% 2.800% 02/01/2035T 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 0210112037 callable in whole or in part on any date beginning 0210112027 @ par. Term Call: Term bonds maturing on 02/01/2033 subject to mandatory redemption as follows: Redemption Date Principal Amount 02/01/2032 $225,000 02/01/2033 $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 0210112037 $265.000 $520,000 GO Bds Ser 2017 Tax Treatment: Bank Qualified Original Issue Amount $3,935,000.00 Dated Date: 05/15/2017 Sale Date: 05/23/2017 Delivery Date: 06/20/2017 Sale Type: Competitive TIC: 2.7797% Record Date: 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: Alamo Capital Co- Manager: CL King & Associates Co- Manager: Commerce Bank Co- Manager: Country Club Bank Co- Manager: Davenport & Co. LLC Co- Manager: Dougherty & Company LLC Co- Manager: Duncan - Williams, Inc. Co- Manager: Edward Jones Co- Manager: First Empire Securities Co- Manager: First Kentucky Securities Co- Manager: FMSbonds, Inc. Co- Manager: IFS Securities, Inc. Co- Manager: Isaak Bond Co- Manager: Loop Capital Markets LLC Co- Manager: Midland Securities, Ltd Co- Manager: Oppenheimer & Co. Inc. Co- Manager: Rafferty Capital Markets, LLC Co- Manager: Ross, Sinclaire & Associates, Inc. Co- Manager: Stephens Inc. Co- Manager: SumRidge Partners, LLC Co- Manager: UMB Bank Co- Manager: Vining- Sparks ISO Co- Manager: W. H. Mel] Associates, Inc Co- Manager: Wayne Hummer Investments Co- Manager: Wedbush Securities Co- Manager: WNJ Capital Co- Manager: Sierra Pacific Use of Proceeds: Public Safety r„ .�r,,rr. .....,,, ,, j.r ...,.. ., ,,,,. ,,C: ..t` ..,. .ry ,,, _,u , E ,; i Texas Municipal Reports Fe � i (General Obligation Debt) Last Revised: 8/1/2017 TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 10 of 13 Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2018 135,000.00 3.0000% 0.980% 02/01/2019 150,000.00 3.0000% 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% 02/01/2023 170,000.00 3.0000% 1.650% 02/01/2024 175,000.00 3.0000% 1.750% 02/01/2025 180,000.00 3.0000% 1.900% 0210112026 185,000.00 3.0000% 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% 02/01/2030 210,000.00 3.0000% 2.500% 02/01/2031 215,000.00 3.0000% 2.600% 02/01/2033T 455,000.00 3.0000% 2.800% 02/01/2035T 480,000.00 3.2500% 3.000% 02/01/2037T 510,000.00 3.2500% 3.150% 09/30/2034 1,505,000.00 95.49% $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 02/01/2037 callable in whole or in part on any date beginning 02/01/2027 @ par. Term Call: Term bonds maturing on 02/01/2033 subject to mandatory redemption as follows: Redemption Date Principal Amount 02/01/2032 $225,000 02/01/2033 $230,000 $455,000 Term bonds maturing on 02/01/2035 subject to mandatory redemption as follows: Redemption Date Principal Amount 02/01/2034 $235,000 02/01/2035 $245.000 $480,000 Term bonds maturing on 02/01/2037 subject to mandatory redemption as follows Redemption Date Principal Amount 02/01/2036 $250,000 02/01/2037 $260,000 $510.000 Grand Total _ ______________> $82,585,000.00 Bond Debt Service Period Ending Principal Interest Debt Service 09/30/17 5,925,000.00 4,161,331.88 2,462,938.50 8,387,938.50 09/30/18 6,255,000.00 21.76% 2,638,392.72 8,893,392.72 09/30/1.9 5,790,000.00 242,637.50 2,403,438.50 8,193,438.50 09/30/20 5,975,000.00 09/30/2022 2,226,597.50 8,201,597.50 09/30/21 5,915,000.00 1,570,000.00 2,033,662.50 7,948,662.50 09/30/22 5,145,000.00 09/30/36 1,844,589.00 6,989,589.00 09/30/23 5,045,000.00 1,678,068.75 1,672,191.75 6,717,191.75 09/30/24 5,075,000.00 09/30/2027 1,499,717.25 6,574,717.25 09/30/25 4,410,000.00 23.844.102.97 1,333,048.50 5,743,048.50 09/30/26 4,345,000.00 79.03% 1,172,271.50 5,517,271.50 09/30/27 4,020,000.00 1,007,842.25 5,027,842.25 09/30/28 4,035,000.00 09/30/2032 858,343.00 4,893,343.00 09/30/29 3,330,000.00 2,255,000.00 719.953.13 4,049,953.13 09/30/31 3,700,000.00 07.17% 461,331.88 09/30/2018 4,161,331.88 09/30/32 2,670,000.00 09/30/2019 341,535.00 21.76% 3,011,535.00 09/30/33 2,255,000.00 28.99% 242,637.50 09/30/2021 2,497,637.50 09/30/34 1,505,000.00 09/30/2022 167,150.00 42.39% 1,672,150.00 09/30/35 1,570,000.00 48.50% 108,850.00 09/30/2024 1,678,850.00 09/30/36 1,630,000.00 09/30/2025 48,068.75 59.98% 1,678,068.75 09/30/37 525.000.00 65.24% 8,531.25 09/30/2027 533,531.25 70.11% 82.585.000.00 09/30/2028 23.844.102.97 75.00% 106.429.102.97 COMPUTED ON BASIS OF MANDATORY REDEMPTION Debt Amortization Rates % of Principal Period Ending Principal Retired 09/30/2017 5,925,000.00 07.17% 09/30/2018 6,255,000.00 14.75% 09/30/2019 5,790,000.00 21.76% 09/30/2020 5,975,000.00 28.99% 09/30/2021 5,915,000.00 36.16% 09/30/2022 5,145,000.00 42.39% 09/30/2023 5,045,000.00 48.50% 09/30/2024 5,075,000.00 54.64% 09/30/2025 4,410,000.00 59.98% 09/30/2026 4,345,000.00 65.24% 09/30/2027 4,020,000.00 70.11% 09/30/2028 4,035,000.00 75.00% 09/30/2029 3,330,000.00 79.03% 09/30/2030 3,465,000.00 83.22% 09/30/2031 3,700,000.00 87.70% 09/30/2032 2,670,000.00 90.94% 09/30/2033 2,255,000.00 93.67% 09/30/2034 1,505,000.00 95.49% 09/30/2035 1,570,000.00 97.39% 09/30/2036 1,630,000.00 99.36% 09/30/2037 525,000.00 100.00% • � � t 1 G.O. Debt Service Requirements for fiscal year ending 09/30/2017 I &S Fds all G.O. issues 09/30/2016 2016 I &S Fund Tax Levy @ 90% Water & Sewer Economic Development (Type B) EMS Building Drainage [•7:74:7-A 111IZRIME1111: tl_Akill $8,387,939 $1,311,577 5,778,142 1,581,362 52,979 150,669 134,427 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. Fiscal Year Ended 09 -30 -2016 09 -30 -2015 09 -30 -2014 09 -30 -2013 Revenues: Taxes $3,660,101 $3,442,819 $3,521,338 $3,215,620 Interest 52,546 14,461 9,599 8,821 Other 0 1,478 0 0 -- - - - - -- -- - - - - -- -- - - - - -- -- - - - - -- Total Revenues $3,712,647 $3,458,758 $3,530,937 $3,224,441 Schertz, City Texas Municipal Reports 'IC I E i (General Obligation Debt) Last Revised: 8/1/2017 TIVIR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 11 of 13 Debt Service 161,215 430,609 427,671 428,504 Other 322,596 351.812 519,831 197,859 Total Expenses -- - - - - -- $770,754 -- - - - - -- $1,062,401 -- - - - - -- $1,512,824 -- - - - - -- $1,199,243 Available For Debt Service $2,941,893 $2.396,357 $2,018,113 $2,025,198 SCHERTZ EMS 09 -30 -2016 Fees & Charges $5,922,037 Expenses $4,681,742 Available For Debt Service $1,240,295 * Ending Balance $9,821,747, AUTHORIZED BUT UNISSUED Fiscal Year Ended 09 -30 -2015 09 -30 -2014 09 -30 -2013 $4,416,140 $4,533,828 $4,459,945 $4.467.869 $4.056.994 $3.802.397 ($51,729)* $476,834 $657,548 GENERAL OBLIGATION BONDS AUTHORIZED BUT UNISSUED Election Amount Issued Date Purpose Authorized To Date Unissued 11/03/15 Street & Bridge $7,000,000 $2,000,000 $5,000,000 11/03/15 Public Safety 8,000,000 8,000,000 0 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/1.970- $250,000 Sewer 08/09/1997- $595 Fire Improvements 08/09/1997- $330 Hospital •; t c 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 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) 2017 2016 Employee: 7.00% 7.00% City: 16.00% 16.06% Actuarial Valuation as of 12/31/2015 12/31/2014 Assets $39,338,018 $35,200,062 Accrued Liabilities $55,119.232 $50,229,051 (Unfunded) /Overfunded Liab. ($15,781,214) ($15.028,989) Funded Ratio 71.37% 70.08% Annual Covered Payroll $15,648,114 $15,389,154 (Unfunded) /Overfunded Liability as a % of Covered Payroll (100.85)% (97.66)% Source: City of Schertz 09/30/2016 CAFR SCHEDULE OF CHANGES IN NET PENSION LIABILITY AND RELATED RATIOS 12 -31 -2014 12 -31 -2015 Pension Liability - Beginning $45,615,815 $50,229,051 Pension Liability - Ending (a) $50,229,051 $55,119,232 Contributions Employer $ 2,403,929 $ 2,542,565 Contributions Employee $ 1,077,097 $ 1,095,260 Plan Fiduciary Net Position - Beg $32,179,518 $36,412,844 Plan Fiduciary Net Position - End (b) $36,412,844 $38,499,857 Net Pension Liability (a) - (b) (Pension Liab - Fiduciary Position) $13,816,207 $16,619,375 Plan Fiduciary Net Position as a % of Total Pension Liability 72.4% 69.85% Covered Employee Payroll $15,389,154 $15,648,114 Net Pension Liability as a % of Covered Payroll 89.78% 106.21% Membership data for the pension plans are as follows: Inactive employees or beneficiaries 2014 2015 currently receiving benefits 67 79 Inactive employees entitled to but not yet receiving benefits 133 138 Active employees 302 312 Total 502 529 Source: City of Schertz CAFR 9 -30 -2016 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 (OPEN), 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 OPEB Year Costs Contributed Cost Contributed Obligation t e,t j 1 .r C, C, i t. 0 ,; i Texas Municipal Reports 'IC t i (General Obligation Debt) Last Revised: 8/1/2017 TIVIR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 12 of 13 2014 $79,513 $13,645 17% $364,906 2015 81,159 15,485 19% 430,580 2016 136,557 23,519 17% 543,618 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 $114,356,845 and the ratio of the UAAL to the covered payroll was 7.4 %. 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 2016, 2015, and 2014, were $20,324, $21,681, and $20,81, respectively, which equaled the required contributions each year. Source: City of Schertz CAFR 9 -30 -2016. NON FUNDED DEBT NON- FUNDED DEBT PAYABLE (As of September 30, 2016) The City reports additional debt in the principal amount of $2,668,285 under Emergency Medical Services and $14,141,520 under Govt Activities as follows: * See PENSION FUND LIABILITY section for details of this obligation OVERLAPPING DEBT ESTIMATED OVERLAPPING DEBT STATEMENT Taxing Body Debt Amount As Of %Ovlpg Ovlpg Amt Alamo CCD $369,638,157 12/31/16 Bexar Co 1,311,941,457 09/30/16 Bexar Co Hosp Dist 636,510,971 03/31/17 Comal Co 98,228,740 01/18/17 Comal ISD 794,859,783 06/30/16 Guadalupe Co 10,674,174 09/30/15 Schertz- Cibolo- Universal 384,936,834 08/31/16 Total Overlapping Debt: Schertz, City of 09/30/16 Total Direct and Overlapping Debt: Total Direct and Overlapping Debt % of A.V.: Total Direct and Overlapping Debt per Capita: 0.22 $813,204 0.22 2,886,271 0.22 1,400,324 5.00 4,911,437 6.17 49,042,849 21.11 2,253,318 49.71 191,352,100 $252,659,503 $68,293,075 $320,952,578 8.71% $8,476 The City of Schertz is a retail center and fast- growing suburb located approximately 20 miles northeast of San Antonio and is between the Cities of San Antonio and New Braunfels, on Interstate 35 and FM 78 and on Interstate 10, between San Antonio and Seguin. The City is near the center of the San Antonio Metropolitan Statistical Area, The City serves an agricultural area in the process of transforming into an urban setting with rapid growth. The City is located in Guadalupe County with a portion extending into Bexar and Comal Counties. The City's 2010 census was 31.465, increasing 68.32% since 2000. COUNTY CHARACTERISTICS: Guadalupe County was created and organized in 1846 from Bexar and Gonzales Counties and named after the Guadalupe River. The County is located in south central Texas. 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, tourism and agribusiness. Agricultural: row crops, nursery crops, hay and cattle. OIL AND GAS - 2016 The oil production for this county accounts for 0.07% of the total state production. The county ranks 88 out of all the counties in Texas for oil production. OIL PRODUCTION (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2013 Oil 967,534 BBL -2.68 2014 Oil 896,850 BBL -7.31 2015 Oil 741,580 BBL -17.31 2016 Oil 708.784 BBL -4.42 CASINGHEAD (Texas Amount Next Year's Outstanding Requirements Reported Under Compensated Absences $198,839 N/A EMS Fund OPEB* $77,106 N/A EMS Fund Pension Liability* $2,392,340 N/A EMS Fund Capital Leases $58,321 $36,230 Govt Activities Compensated Absences $1,022,543 N/A Govt Activities Pension Liability* $12,653,778 N/A Govt Activities OPEB* $406,878 N/A Govt Activities * See PENSION FUND LIABILITY section for details of this obligation OVERLAPPING DEBT ESTIMATED OVERLAPPING DEBT STATEMENT Taxing Body Debt Amount As Of %Ovlpg Ovlpg Amt Alamo CCD $369,638,157 12/31/16 Bexar Co 1,311,941,457 09/30/16 Bexar Co Hosp Dist 636,510,971 03/31/17 Comal Co 98,228,740 01/18/17 Comal ISD 794,859,783 06/30/16 Guadalupe Co 10,674,174 09/30/15 Schertz- Cibolo- Universal 384,936,834 08/31/16 Total Overlapping Debt: Schertz, City of 09/30/16 Total Direct and Overlapping Debt: Total Direct and Overlapping Debt % of A.V.: Total Direct and Overlapping Debt per Capita: 0.22 $813,204 0.22 2,886,271 0.22 1,400,324 5.00 4,911,437 6.17 49,042,849 21.11 2,253,318 49.71 191,352,100 $252,659,503 $68,293,075 $320,952,578 8.71% $8,476 The City of Schertz is a retail center and fast- growing suburb located approximately 20 miles northeast of San Antonio and is between the Cities of San Antonio and New Braunfels, on Interstate 35 and FM 78 and on Interstate 10, between San Antonio and Seguin. The City is near the center of the San Antonio Metropolitan Statistical Area, The City serves an agricultural area in the process of transforming into an urban setting with rapid growth. The City is located in Guadalupe County with a portion extending into Bexar and Comal Counties. The City's 2010 census was 31.465, increasing 68.32% since 2000. COUNTY CHARACTERISTICS: Guadalupe County was created and organized in 1846 from Bexar and Gonzales Counties and named after the Guadalupe River. The County is located in south central Texas. 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, tourism and agribusiness. Agricultural: row crops, nursery crops, hay and cattle. OIL AND GAS - 2016 The oil production for this county accounts for 0.07% of the total state production. The county ranks 88 out of all the counties in Texas for oil production. OIL PRODUCTION (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2013 Oil 967,534 BBL -2.68 2014 Oil 896,850 BBL -7.31 2015 Oil 741,580 BBL -17.31 2016 Oil 708.784 BBL -4.42 CASINGHEAD (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2013 Casinghead 30.277 MCF -40.93 2014 Casinghead 43,544 MCF 43.82 2015 Casinghead 35,184 MCF -19.20 2016 Casinghead 38,784 MCF 10.23 RETAIL SALES & EFFECTIVE BUYING INCOME (The Nielsen Company) Year 2016 2015 2014 Retail Sales $1.4B $1.5B $2.2B Effective Buying Income (EBI) $3.4B $3.5B $3.3B County Median Household Income $53,189 $58,134 $54,803 State Median Household Income $55,352 $53,037 $50,464 % of Households with EBI below $25K 9.4 % 8.0 % 8.5 % % of Households with EBI above $25K 70,9 % 70.5 % 71.2 % EMPLOYMENT DATA (Texas Workforce Commission) 2016 2015 2014 Employed Earnings Employed Earnings Employed Earnings 1st Q: 37,487 $366.6M 33,204 $328.8M 32,404 $313.2M 2nd Q: 38,455 $383.OM 33,980 $334.6M 33,259 $318.2M 3rd Q: N/A N/A 34,291 $345.5M 32,677 $322.5M 4th Q: N/A N/A 35,026 $378.OM 33,740 $355.6M MAJOR COLLEGES AND UNIVERSITIES: Texas Lutheran University COLLEGES AND UNIVERSITIES Year Total Fall Enrollment 2016 1 1,295 2015 1 1,373 2014 1 1,319 2013 1 1,338 • it t ,. .... t . i_ ,,,. .I <. _ . nn r, Schertz, City Texas Municipal Reports 'IF I i (General Obligation Debt) Last Revised: 8/1/2017 so q TMR # 2302 ,f- Guadalupe, Comal, Bexar Counties Page 13 of 13 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,877 Education 3.84% Amazon.com 1,256 Online Retail 2. Sysco San Antonio Inc. Sysco Central Texas 815 Food Distributor GE Oil Gas 552 Oil & Gas 2.20% FedEx Ground 500 Package Shipping Company 4. US Real Estate LP HVHC 420 Supply % Distribution Service Republic Beverage Company 408 Beverage Services 1.34% Brandt Engineering 396 Engineering 6. Shell US Gas & Power LLC City of Schertz 351 Government HER Grocery Co. 350 Retail 0.66% (a) Source: City of Schertz CAFR dated September 30, 2016- TOP 10 TAXPAYERS Principal Taxpayers 2016 A.V. % of A.V. 1. Capterpillar Inc. $141,584,070 3.84% Manufacturer 2. Sysco San Antonio Inc. 105,604,943 2.87% Foodservice Distribution 3. Amazon.com.KYDC LLC 80,987,236 2.20% Distribution Center 4. US Real Estate LP 57,155,244 1.55% Retail Center 5. Republic Beverage Co. 49,373,850 1.34% Wine Wholesaler & Importer 6. Shell US Gas & Power LLC 27,182,290 0.74% Oil & Gas 7. San Antonio MTA LP 24,351,699 0.66% Mass Transit 8. Capital Group 23,941,023 0.65% Health Care 9. SC Shertz LLC 23,430,800 0.64% Building Materials Supplier 10. H E Butt Grocery Cc 20,524,572 0.56% Grocery Store Total: ---- - - - - -- $554.135.727 - - - - -- 15.05% Mayor Michael Carpenter 1400 Schertz Parkway Schertz, TX 78154 Phone: 210- 619 -1040 Ext: 1132 Fax: 210 - 619 -1139 mayor @schertz.com City Manager John C. Kessel 1400 Schertz Parkway Schertz, TX 78154 Phone: 210 - 619 -1000 Ext: 1112 Fax: 210 -619 -1139 jkessel @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 - 303 -3421 Fax: 830 - 372 -9940 daryl.john @co.guadalupe.tx.us Chief Appraiser Jamie Osborne Guadalupe Appraisal District 3000 N Austin St. Seguin, TX 78155 Phone: 830 - 303 -3313 Fax: 830 - 372 -2874 gadprotest @guadalupead.org Chief Appraiser Rufino Lozano Coma] County Appraisal District 900 S. Seguin Ave. New Braunfels, TX 78131 Phone: 830- 625 -8597 Fax: 830 - 625 -8598 lozanr @co.comal.tx.us Chief Appraiser Michael Amezquita Bexar County Appraisal District 411 N. Frio San Antonio, Tx 78207 Phone: 210- 224 -8511 Fax: 210- 242 -2454 cs @bcad.org M AT ft .L a ,. fxlj SfI ,. ... �.. f.. if if Iff 1! r, r JI ,; z/ i t Government Corp Texas Municipal Reports 'IC � p I ➢. (San Antonia Water System Expansion) Last Revised: 3/29/2017 o TIVIR # 2854 ,f- Guadalupe County Page 1 of 3 FINANCIAL STATEMENT FOR OTHER BONDS FOR THIS ISSUER, SEE SEPARATE MUNICIPAL REPORTS FINANCIAL STATEMENT (As of September 30, 2015) Special Obligation Debt Senior Lien $24,850,000 PAYMENT RECORD: Never defaulted. DETAILS OF OUTSTANDING DEBT Details of Senior Lien Debt (Outstanding 9/30/2015) Contract Rev Bds Ser 2012 (San Antonio Water System Expansion Water Treatment Project 2) Lien: Senior Original Issuer: Schertz /Seguin Local Government Corp (San Antonio. City of Project) Tax Treatment: Tax Exempt Original Issue Amount $25,425,000.00 Dated Date: 0610112012 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: 02/01/2013 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/2016 590,000.00 0210112017 600,000.00 02/01/2018 620,000.00 02/01/2019 645,000.00 0210112020 670,000.00 0210112021 700,000.00 0210712022 725,000.00 02/01/2023 755,000.00 0210112024 785,000.00 0210112025 815,000.00 0210112026 840,000.00 0210112027 865,000.00 02/01/2032T 4,825,000.00 02/01/2041T 11,41.5,000.00 2.0000% 0.900% 2.0000% 1.140r 4.0000% 1.450% 4.0000% 1.750% 4.0000% 2.050% 4.0000% 2.300% 4.0000% 2.490% 4.0000% 2.710% 4.0000% 2.910r 3.0000% 3.140° 3.0000% 3.230% 3.1250% 3.320% 3.6250% 3.850% 4.0000% 4.090% $24.850.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 02/01/2028 $895,000 02/01/2029 $930,000 02/01/2030 $965.000 02/01/2031 02/01/2032 $1,000.000 $1,035.000 Term bonds maturing on 02/01/2041: Mandatory Redemption Date Principal Amount 02/01/2033 $1,075,000 0210112034 $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 _ ______________> $24,850,000.00 Bond Debt Service Period Ending Principal Interest Debt Service 09/30/16 590,000.00 02.37% 922,087.50 09/30/2017 1,512,087.50 09/30/17 600,000.00 09/30/2018 910,187.50 07.28% 1,510,187.50 09/30/18 620,000.00 09.88% 891,787.50 09/30/2020 1,511,787.50 09/30/19 645,000.00 09/30/2021 866,487.50 15.39% 1,511,487.50 09/30/20 670,000.00 18.31% 840,187.50 09/30/2023 1,510,187.50 09/30/21 700,000.00 09/30/2024 812,787.50 24.51% 1,512,787.50 09/30/22 725,000.00 27.79% 784,287.50 1,509,287.50 09/30/23 755,000.00 754,687.50 1,509,687.50 09/30/24 785,000.00 723,887.50 1,508,887.50 09/30/25 815,000.00 695,962.50 1,510,962.50 09/30/26 840,000.00 671,137.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,100.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 24.850.000.00 14.427.762.50 39,277.762.50 COMPUTED ON BASIS OF MANDATORY REDEMPTION Debt Amortization Rates % of Principal Period Ending Principal Retired 09/30/2016 590,000.00 02.37% 09/30/2017 600,000.00 04.79% 09/30/2018 620,000.00 07.28% 09/30/2019 645,000.00 09.88% 09/30/2020 670,000.00 12.58% 09/30/2021 700,000.00 15.39% 09/30/2022 725,000.00 18.31% 09/30/2023 755,000.00 21.35% 09/30/2024 785,000.00 24.51% 09/30/2025 815,000.00 27.79% J �.. olf .i. ., . . . .. .. . F .t . ,. ., ., o i' r, '" ,� r. ., ,; Schertz/Seguin i t Government Corp Texas Municipal Reports Fe � p I ➢, (San Antonia Water System Expansion) Last Revised: 3/29/2017 o TIVIR # 2854 ,f- Guadalupe County Page 2 of 3 09/30/2026 840,000.00 31.17% 09/30/2027 865,000.00 $13.790,208 34.65% $9,265,407 09/30/2028 895,000.00 449,997 38.25% 515,522 09/30/2029 930,000.00 269,000 41.99% 538,000 09/30/2030 965,000.00 93,369 45.88% 133,466 09/30/2031 1,000,000.00 124,447 49.90% 83,871 09/30/2032 1,035,000.00 54.06% 09/30/2033 1,075,000.00 58.39% 09/30/2034 1,120,000.00 62.90% 09/30/2035 1,165,000.00 67.59% 09/30/2036 1,210,000.00 72.45% 09/30/2037 1,260,000.00 77.53% 09/30/2038 1,315,000.00 82.82% 09/30/2039 1,365,000.00 88.31% 09/30/2040 1,425,000.00 94.04% 09/30/2041 1,480,000.00 100.00% I» A d I Z I :I Z k 2:2 a*116K01H.1 SECURITY The 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 (1) 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 Fiscal Year Ended 09 -30 -2015 09 -30 -2014 09 -30 -2013 09 -30 -2012 Revenues: Water Revenue $16,278,709 $13.790,208 $9,107,237 $9,265,407 Impact Fees 910,030 449,997 417,297 515,522 Reservation Fees 0 269,000 538,000 538,000 Lease Revenue 129,600 93,369 126,444 133,466 Other 158,800 124,447 103,876 83,871 Total Revenues $17,477,139 $14,727,021 $10,292,854 $10,536,266 Expenses: Lease Payments $2,234,066 $2,467,171 $2,473,882 $2,221,928 Depreciation 1,962,622 1,547,003 1,506,043 1,312,738 Amortization Expense 85,399 85,399 85,399 85,399 Other 4,735,359 3,256,985 2,225,818 2,634,245 Total Expenses $9,017,446 $7,356,558 $6,291,142 $6,254,310 Operating Income(Loss) $8,459,693 $7,370,463 $4,001,712 $4,281,956 Nonoperating Income (Expense) Interest Income $ 17,595 Contribution from Cities of Schertz & Seguin -0- Interest Expense (2,668,447) Gain (Loss) on Disposal of Assets (912,761) Amortization of Bond $ 14,551 $ 51,441 $ 51,702 (269,000) (538,000) (538,000) (3,521,370) (4,334,835) (3,679,231) -0- -0- (489.955) Change in Net Assets $ 4,896,080 $ 3,594,644 $ (819,682) $ (373,528) Capital Contributions from SAWS $ -0- $ -0- $ -0- $ 555,245 Contributions Refunded to SAWS $ -0- $ -0- $ -0- $ (757,900) Beg. Balance 10 -1 $ 5,521,578 $ 1,926,934 $2,746,616 $ 4,772,834 Prior Period Adj $ -0- $ -0- $ -0- $(1,450,035) End. Balance 9 -30 $10,417,658 $ 5,521,578 $1,926,934 $ 2,746,616 NON FUNDED DEBT NON- FUNDED DEBT PAYABLE (As of September 30, 2015) None, ECONOMIC BACKGROUND 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. The County is located in south central Texas. ,; z/ i t Government Corp Texas Municipal Reports Fe � p I ➢, (San Antonia Water System Expansion) Last Revised: 3/29/2017 o TMR # 2854 ,f- Guadalupe County Page 3 of 3 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, tourism and agribusiness. Agricultural: row crops, nursery crops, hay and cattle. OIL AND GAS - 2015 The oil production for this county accounts for 0.08% of the total state production. The county ranks 89 out of all the counties in Texas for oil production. OIL PRODUCTION (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2013 Oil 967,534 BBL -2.68 2014 Oil 896,850 BBL -7.31 2015 Oil 741.580 BBL -17.31 CASINGHEAD (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2013 Casinghead 30,277 MCF -40.93 2014 Casinghead 43,544 MCF 43.82 2015 Casinghead 35.184 MCF -19.20 RETAIL SALES & EFFECTIVE BUYING INCOME (The N Year 2015 Retail Sales $1.5B Effective Buying Income (EBI) $3.5B County Median Household Income $58,134 State Median Household Income $53,037 % of Households with EBI below $25K 8.0 % % of Households with EBI above $25K 70.5 % elsen Company) 2014 2013 $2.2B $1.5B $3.3B $3.OB $54,803 $51,246 $50.464 $48,646 8.5 % 9.6 % 71.2 % 73.6 % EMPLOYMENT DATA (Texas Workforce Commission) 2016 2015 2014 Employed Earnings Employed Earnings Employed Earnings 1st Q: 37,487 $366.6M 33,204 $328.8M 32.404 $313.211 2nd Q: 38,455 $383.OM 33,980 $334.6M 33,259 $318.2M 3rd Q: N/A N/A 34,291 $345.511 32,677 $322.5M 4th Q: N/A N/A 35,026 $378.011 33,740 $355.611 MAJOR COLLEGES AND UNIVERSITIES: Texas Lutheran University COLLEGES AND UNIVERSITIES Year Total Fall Enrollment 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 President, Board of Directors Robin V. Dwyer Schertz- Seguin Local Government Corporation P.O. Box 833 Seguin, TX 78156 Phone: 830 -401-2409 Fax: 830 - 401 -2320 General Manager R. Alan Cockerell Schertz- Seguin Local Government Corporation P. 0 Box 833 Seguin, TX 78156 -0833 Phone: 830 - 401 -2320 Fax 830 - 401 -2481 acockerell @seguintexas.gov Assistant General Manager Amber Briggs -Beard Schertz /Seguin Local Government Corporation P.O. Box 833 Seguin, TX 78156 Phone: 830 -401 -2409 Fax: 830 -401 -2320 Office Administrator Angela Kleinschmidt Schertz /Seguin Local P.O. Box 833 Seguin, TX 78156 Phone: 830 - 401 -2409 Fax: 830 -401 -2320 Government Corporation City Manager John C. Kessel 1400 Schertz Parkway Cohorts, TX 78154 Phone: 210 -619 -1000 Ext: 1112 Fax: 210 -619 -1139 jkessel @schertz.com City Manager Douglas Faseler 205 N River Street Seguin, TX 78155 -0591 Phone: 830 - 401 -2302 Fax: 830 - 401 -2499 dfaseler @seguintexas.gov IOU . r ,; z/ i t Government Corp Texas Municipal Reports 'Ic p I ➢, (chertz & Seguin, Cities of, Project) Last Revised: 10/6/2017 o TMR # 1764 ,- Guadalupe County Page 1 of 6 ��1►T1�L+3�[��1�1i� iii FOR OTHER BONDS FOR THIS ISSUER, SEE SEPARATE MUNICIPAL REPORTS FINANCIAL STATEMENT (As of September 30, 2016)(a) Special Obligation Debt Senior Lien Junior Lien Special Fund Balances I &S Repair & Replacement Reserve $53,590,000 $89,895,000 $143.485,000 $912,641 $500,000 $1,286,349(b) (a) Includes $22.830,000 of the SWIFT Bond Participation Loan Series 2016 bonds dated November 16, 2016. (b) Cash balance. Excludes surety bonds for Series 2001. Details of Senior Lien Debt (Outstanding 9/30/2016) 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: Rain Rauscher Incorporated Co- Manager: PaineWebber Incorporated Insurance: Assured Guaranty Municipal Corp. (FSA) Use of Proceeds: Utility. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/203ST 10,000,000.00 5.2000% 100.00% $10,000,000.00 Call Option: Non Callable Term Call: Term bonds maturing on 02/01/2035: Mandatory Redemption Date Principal Amount 02/01/2031 $1,795,000 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 Ser 2007 Refunded Amount Mat Date Coupon Price Sched Call 290,000.00 0210112012 4.500 Par 0210112011 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 02/01/2013 02/01/2014 02/01/2015 02/01/2016 02/01/2017 02/01/2018 02/01/2019 02/01/2020 02/01/2030 02/01/2037 02/01/2041 4.625 4.700 4.800 5.000 5.000 5.000 5.125 5.125 5.375 5.250 5.250 Contract Rev Bds Ser 2010 Lien: Senior Tax Treatment: Bank Qualified Original Issue Amount $22,140,000.00 Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 Par 0210112011 Dated Date: 06/01/2010 Sale Date: 06/15/2010 Delivery Date: 0711412010 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 0210112011 Paying Agent: Wells Fargo Bank, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Co- Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Coastal Securities, Inc. Co- Manager: Allison, M.E. & Co., Inc. Co- Manager: RBC Capital Markets Insurance: Assured Guaranty Municipal Corp, (FSA) Use of Proceeds: Utility, Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2017 485,000.00 3.0000% 3.050% 02/01/2018 505,000.00 3.5000% 3.250% 02/01/2019 520.000.00 3.5000% 3.450% 02/01/2020 540.000.00 3.5000% 3.650% 0210112021 560.000.00 4.0000% 1850% 02/01/2022 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% 02/01/2028 745.000.00 4.2500% 4.390% 02/01/2029 780,000.00 4.2500% 4.480% 0210112030 815,000.00 4.5000% 4.570% 02/01/2031 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,760,000.00 Call Option: Bonds maturing on 0210112020 to 02/01/2032 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 02/01/2034 $975,000 r II ^;7 , a v a,. .. x „ . �;,.� �, , ,; z/ i t Government Corp Texas Municipal Reports Ov p I ➢, (chertz & Seguin, Cities of, Project) Last Revised: 10/6/2017 o TMR # 1764 ,- Guadalupe County Page 2 of 6 02/01/2035 $1,020,000 Term bonds maturing on 02/01/2038: Mandatory Redemption Date Principal Amount 02/01/2036 $1,070,000 02/01/2037 $1,125,000 02/01/2038 $1,175.000 Term bonds maturing on 0210112041: Mandatory Redemption Date Principal Amount 02/01/2039 $1,235,000 0210112040 $1,295,000 0210112041 $1.360.000 SWIFT Funding BP Loan Ser 2016 Lien: Senior Tax Treatment: Tax Exempt Original Issue Amount $22,830,000.00 Dated Date: 11/16/2016 Sale Date: 08/30/2016 Delivery Date: 11/16/2016 Sale Type: Private Placement Record Date: N/A Bond Form: N/A Denomination $0 Interest pays Semi- Annually: 02101, 08/01 1st Coupon Date: 08/01/2017 Paying Agent: The Bank of New York Mellon Trust Company, N.A., Dallas, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Purchaser: Texas Water Development Board Use of Proceeds: Project Costs. Orig Reoffering Maturity Amount Coupon Price /Yield 08/01/2035 300,000.00 3.1900% N/A 08/01/2036 700,000.00 3.2400% N/A 08/01/2037 1,125,000.00 3.4600% N/A 08/01/2038 1,165,000.00 3.4600% N/A 08/01/2039 1,205,000.00 3.4600% N/A 08/01/2040 1,250,000.00 3.4600% N/A 08/01/2041 1,290,000.00 3.4600% N/A 08/01/2042 1,340,000.00 3.8800% N/A 08/01/2043 1,390,000.00 3.8800% N/A 08/01/2044 1,440,000.00 3.8800% N/A 08/01/2045 1,490,000.00 3.8800% N/A 08/01/2046 1,545,000.00 3.8800% N/A 08/01/2047 1,605,000.00 3.5800% N/A 08/01/2048 1,660,000.00 3.5800% N/A 08/01/2049 1,715,000.00 3.5800% N/A 08/01/2050 1,775,000.00 3.5800% N/A 08/01/2051 1.835.000.00 3.5800% N/A $22,830,000.00 Call Option: Callable on the date prior to which the Corporation cannot purchase the TWDB's portion of the Project as specified in the authorizing resolution. Contract Rev Ref Bds New Ser 2014 Lien: Junior Tax Treatment: Bank Qualified Original Issue Amount $6,275,000.00 Dated Date: 09/01/2014 Sale Date: 09/1.6/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 Bus Ser 2005 Refunded Amount Mat Date Coupon Price Sched Call 475,000.00 02/01/2015 4.000 Par 1012112014 495.000.00 02/01/2016 4.000 Par 1012112014 520,000.00 0210112017 4.000 Par 1012112014 540,000.00 0210112018 4.000 Par 10/21/2014 560,000.00 02/01/2019 4.000 Par 1012112014 585,000.00 0210112020 4.100 Par 10/21/2014 610,000.00 0210112021 4.150 Par 1012112014 635,000.00 0210112022 4.200 Par 1012112014 665.000.00 02/01/2023 4.250 Par 1012112014 695,000.00 0210112024 4.300 Par 1012112014 725,000.00 02/01/2025 4.375 Par 10/21/2014 Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2017 520,000.00 Sale Date: 2.0000% 0.900% 02/01/2018 530.000.00 Negotiated 2.0000% 1.200% 02/01/2019 540,000.00 Denomination 2.0000% 1.600% 02/01/2020 555,000.00 02/01/2015 3.0000% 1.850% 0210112021 570,000.00 3.0000% 2.050% 0210112022 590,000.00 3.0000% 2.350% 0210112023 610,000.00 3.5000% 2.600% 02/01/2024 630,000.00 3.5000% 2.750% 02/01/2025 655,000.00 15000% 2.900% $5,200,000.00 Call Option: Bonds maturing on 0210112023 to 02/01/2025 callable in whole or in part on any date beginning 0210112022 @ par. Contract Rev Imp & Ref Bds New Ser 2015 Lien: Junior Tax Treatment: Tax Exempt Original Issue Amount $41,720,000.00 Dated Date: 12/01/2014 Sale Date: 1210212014 Delivery Date: 01/13/2015 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 02/01/2015 Paying Agent: Regions Bank, Houston, TX Bond Counsel: Fulbright & Jaworski LLP Financial Advisor: Southwest Securities, San Antonio, TX Co- Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Raymond James Co- Manager: Allison, M.E. & Co., Inc. Co- Manager: RBC Capital Markets Underwriter's Counsel: Andrews Kurth L.L.P. _ ,.. f„ „ t, � ,� ..r �.r, r it .. C a`.. . ,, ,.. .,, . Uf .. _ , .. Ill I . ?, ti ti i:, Jlo "i-K: �S; n , , . , , , , �� (,x= ,; z/ i t Government Corp Texas Municipal Reports '1z p I ➢, (chertz & Seguin, Cities of, Project) Last Revised: 10/6/2017 o TMR # 1764 ,- Guadalupe County Page 3 of 6 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 575,000.00 590,000.00 620,000.00 640,000.00 670,000.00 685,000.00 720.000.00 750,000.00 785,000.00 820,000.00 1,660,000.00 7,405,000.00 4,275,000.00 15,370.000.00 Mat Date Coupon 02/01/2016 4.000 0210112017 4.000 02/01/2018 4.000 02/01/2019 4.000 0210112020 4.125 0210112021 4.250 0210112022 4.250 02/01/2023 4.250 02/01/2024 4.250 0210112025 4.250 02/01/2026 4.250 0210112030 4.500 02/01/2036 4.500 0210112041 4.500 Price Sched Call Par 02/01/2015 Par 02/01/2015 Par 02/01/2015 Par 02/01/2015 Par 02/01/2015 Par 02/01/2015 Par 02/01/2015 Par 02/01/2015 Par 02/01/2015 Par 02/01/2015 Par 02/01/2015 Par 02/01/2015 Par 02/01/2015 Par 02/01/2015 Orig Reoffering Maturity Amount Coupon Price /Yield 0210112017 700,000.00 02/01/2018 730,000.00 02/01/2019 745,000.00 0210112020 775,000.00 0210112021 785,000.00 0210112022 825,000.00 0210112023 860,000.00 0210112024 900,000.00 02/01/2025 945,000.00 02/01/2026 1,805,000.00 02/01/2027 1,885,000.00 02/01/2028 1,990,000.00 02/01/2029 2,090,000.00 02/01/2030 2,190,000.00 O2/O1/2O33T 1,650,000.00 O2/O1/2O41T 20,950,000.00 O2/O1/2044T 1,200,000.00 3.0000% 0.8101 3.0000% 1.130% 3.0000% 1.4501 3.0000% 1.7601 4.0000% 2.060% 4.0000% 2.330% 4.0000% 2.5601 5.0000% 2.7401 5.0000% 2.850% 5.0000% 2.9301 5.0000% 3.030% 5.0000% 3.120% 5.0000% 3.180% 5.0000% 3.2601 5.0000% 3.3901 4.0000% 4.0621 4.0000% 4.0661 $41,025,000.00 Call Option: Bonds maturing on 02/01/2024 to 02/01/2030 and term bonds maturing on 02/01/2033 and 0210112041 and 02/01/2044 callable in whole or in part on any date beginning 0210112023 @ par. Term Call: Term bonds maturing on 02/01/2033: Mandatory Redemption Date Principal Amount 02/01/2031 $520,000 02/01/2032 $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 02/01/2037 $3,085,000 02/01/2038 $3,220,000 02/01/2039 $3,345.000 0210112040 $3,480,000 02/01/2041 $1620.000 Term bonds maturing on 02/01/2044: Mandatory Redemption Date Principal Amount 0210112042 $385.000 02/01/2043 $400.000 02/01/2044 $415,000 Contract Rev Bds New Ser 2016 (Texas Water Development Board SWIRFT Project Financing) Lien: Junior Tax Treatment: Tax Exempt Original Issue Amount $43.670,000.00 Dated Date: 08/01/2016 Sale Date: 1012012016 Delivery Date: 11/16/2016 Sale Type: Private Placement Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 02101, 08/01 1st Coupon Date: 08/01/2017 Paying Agent: Regions Bank, Houston, TX 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 J 800% N/A 08/01/2020 1,240,000.00 Uf ,. n >. 0.8600% N/A 08/01/2021 1,250,000.00 0.9300% N/A 0810112022 1,260,000.00 1.0200% N/A 08/01/2023 1,210,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 25800% 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 2J800% N/A 08/01/2042 1,910,000.00 3.1100% N/A 08/01/2043 1,965,000.00 3.1100% N/A 08/01/2044 2,025,000.00 3.1100% N/A 08/01/2045 2,085,000.00 3.1100% N/A 08/01/2046 2,145,000.00 3.1100% N/A $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 08/01./2027 @ par. The Bonds are also subject to Special Mandatory redemption as specified in the authorizing resolution. Grand Total _ ______________> $143,485,000.00 Bond Debt Service Period Ending Principal Interest Debt Service r ,.. ., t" ,,,. .� .. . �r .0 r, r r. 7r . .. .,, , f Uf ,. n >. vi ,; Schertz/Seguin i t Government Corp Texas Municipal Reports 'Ic p I ➢, (Schertz & Seguin, Cities of, Project) Last Revised: 10/6/2017 o TMR # 1764 ,- Guadalupe County Page 4 of 6 'r 1 . _ Uf .. _ . , r n , N, " ,..,. 09/30/2041 8,125,000.00 81.10% 09/30/17 1,705,000.00 4,598,209.25 6,303,209.25 09/30/2042 3,635,000.00 83.63% 09/30/18 1,790,000.00 5,083,741.00 6,873,741.00 09/30/2043 3,755,000.00 86.25% 09/30/19 3,040,000.00 5,032,813.50 8,072,813.50 09/30/2044 3,880,000.00 88.95% 09/30/20 3,110,000.00 4,968,105.50 8,078,105.50 09/30/2045 3,575,000.00 91.44% 09/30/21 3,165,000.00 4,892,591.50 8,057,591.50 09/30/2046 3,690,000.00 94.01% 09/30/22 3,260,000.00 4.808,466.50 8,068,466.50 09/30/2047 1,605,000.00 95.13% 09/30/23 3,350,000.00 4,718,489.50 8,068,489.50 09/30/2048 1,660,000.00 96.29% 09/30/24 3,445,000.00 4,618,065.50 8,063,065.50 09/30/2049 1,715,000.00 97.48% 09/30/25 3,560,000.00 4,507,847.50 8,067,847.50 09/30/2050 1,775,000.00 98.72% 09/30/26 3,805,000.00 4,383,146.88 8,188,146.88 09/30/2051 1,835,000.00 100.00% 09/30/27 3,935,000.00 4,243,033.50 8,178,033.50 09/30/28 4,085,000.00 4,093,640.00 8,178,640.00 09/30/29 4,245,000.00 3,935,878.75 8,180,878.75 PERTINENT PROVISIONS 09/30/30 4,405,000.00 3,765,641.25 8,170,641.25 09/30/31 4,595,000.00 3,582,538.75 8,177,538.75 SECURITY The bonds are special limited obligations of the Schertz /Seguin Local 09/30/32 4,800,000.00 3,387,236.75 8,187,236.75 Government Corporation payable and secured solely by a junior and inferior lien 09/30/33 5,005,000.00 3,181,302.00 8,186,302.00 on and pledge of the Bonds Payment portion of the annual payments to be paid 09/30/34 5,220,000.00 2,967,328.88 8,187,328.88 independently by the City of Schertz, Texas and the City of Seguin, Texas, (a 09/30/35 5,740,000.00 2,744,601.50 8,484,601.50 proportionate share of 50% each - as an operations and maintenance expense from 09/30/36 6,345,000.00 2,516,321.50 8,861,321.50 the gross revenues of such City's utility system as defined in Chapter 1502, as 09/30/37 6,995,000.00 2,278,620.25 9,273,620.25 amended, Texas Government Code) to the Corporation pursuant to the Regional 09/30/38 7,265,000.00 2,012,822.25 9,277,822.25 Water Supply Contract, dated as of November 15, 1999, among the Corporation and 09/30/39 7,540,000.00 1,736,576.75 9,276,576.75 the Cities. The Bonds are also secured by a lien on and pledge of the money in 09/30/40 7,830,000.00 1,449,507.25 9,279,507.25 all funds created, established and maintained by a Resolution. 09/30/41 8,125,000.00 1,151,022.00 9,276,022.00 09/30/42 3,635,000.00 942,419.00 4,577,419.00 RESERVE FUND The Reserve Fund is to accumulate and maintain a reserve for the 09/30/43 3,755,000.00 815,326.00 4,570,326.00 payment of the outstanding bonds equal to the average annual debt service 09/30/44 3,880,000.00 683,982.50 4,563,982.50 requirements. After the issuance of the Series 2010 bonds, Required Reserve Fund 09/30/45 3,575,000.00 556,833.00 4,131,833.00 balance shall be $4,681,081.82. The Reserve Fund is funded with three separate 09/30/46 3,690,000.00 434,177.50 4,124,177.50 Credit Facilities from, Assured Guaranty Municipal Corporation (Series 2001 and 09/30/47 1,605,000.00 307,522.00 1,912,522.00 2005 Bonds) and Ambac Assurance Corporation (Series 2007). The Series 2010 09/30/48 1,660,000.00 250,063.00 1,910,063.00 Reserve Requirement was funded with $1,000,000 cash from available Corporation 09/30/49 1,715,000.00 190,635.00 1,905,635.00 funds and $275,621 from bond proceeds. No debt service reserve fund has been 09/30/50 1,775,000.00 129,238.00 1,904,238.00 established with respect to the 2016 Bonds. 09/30/51 1,835,000.00 65,693.00 1,900,693.00 RENEWAL AND REPLACEMENT FUND As additional security for the Bonds, there has 143,485,000.00 95,033,437.00 238,518,437.00 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. COMPUTED ON BASIS OF MANDATORY REDEMPTION 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 Debt Amortization Rates required to pay for all Operations and Maintenance Expenses; (b) to pay Overhead % of Principal Expenses; and (c) the establish and maintain the debt service and the debt Period Ending Principal Retired 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 09/30/2017 1,705,000.00 01.19% New Series Bonds. 09/30/2018 1,790,000.00 02.44% 09/30/2019 3,040,000.00 04.55% PROJECT Proceeds from the sale of the Bonds will be used for the purpose of 09/30/2020 3,110.000.00 06.72% discharge and final payment of obligations of the Issuer, for the purchase of 09/30/2021 3.165,000.00 08.93% land for the first phase of the Guadalupe Project. The Project includes the 09/30/2022 3,260,000.00 11.20% construction of a well -field and cross - country pipeline. 09/30/2023 3,350,000.00 13.53% 09/30/2024 3,445,000.00 15.94% Construction of twelve wells, the cross - county pipeline, treatment facilities, 09/30/2025 3,560,000.00 18.42% pumping stations, water storage and gathering lines from the well -field is 09/30/2026 3,805,000.00 21.07% complete in Gonzales County. This production capacity was designed for the 09/30/2027 3,935.000.00 23.81% current needs of the Cities. After completion of the construction and with the 09/30/2028 4.085,000.00 26.66% written consent of the Cities. the Corporation contracted to sell water to the 09/30/2029 4,245,000.00 29.62% City of Selma, the City of Universal City. and Spring Hill Water Supply 09/30/2030 4,405,000.00 32.69% Corporation. Additional acreage has been acquired in Guadalupe County since the 09/30/2031 4,595,000.00 35.89% completion of construction to support expansion of a new well- field. 09/30/2032 4,800,000.00 39.23% 09/30/2033 5,005,000.00 42.72% The Corporation obtained the necessary permits and drilled two additional wells 09/30/2034 5,220.000.00 46.36% in Gonzales County to enable the Corporation to supply the new customers and 09/30/2035 5.740,000.00 50.36% maintain safe operational abilities. With the addition of the two new wells, 09/30/2036 6,345,000.00 54.78% the Corporation increased the permitted production to 12,910 acre -feet of water 09/30/2037 6,995,000.00 59.66% per year. The Corporation is currently operating eight wells, a water treatment 09/30/2038 7,265,000.00 64.72% plant and transmission facilities with operations personnel provided by the City 09/30/2039 7,540,000.00 69.98% of Seguin and the City of Schertz on a contractual basis. 09/30/2040 7,830,000.00 75.43% 'r 1 . _ Uf .. _ . , r n , N, " ,..,. Schertz/Seguin t Government Corp Texas Municipal Reports p I ➢, (Schertz & Seguin, Cities of, Project) Last Revised: 10/6/2017 o TMR # 1764 ,- Guadalupe County Page 5 of 6 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 Expenses Lease Payments $2,252,353 Depreciation 2,395,014 Amortization Expense 85,399 Other 4,571,831 Total Expenses $9,304,597 Operating Income(Loss) $6,705,820 Nonoperating Income (Expense) Interest Income $ 85.829 Contribution from Cities of Schertz & Seguin -0- Interest Expense (4,313,689) Gain (Loss) on Disposal $2,234,066 $2,467,171 $2,473,882 1,962,622 1,547,003 1,506,043 85,399 85,399 85,399 4,735,359 3.256,985 2,225,818 $9,017,446 $7,356,558 $6,291,142 $8,459,693 $7,370,463 $4,001,712 $ 17,595 $ 14,551 $ 51,441 -0- (269,000) (538,000) (2,668,447) (3,521,370) (4,334,835) of Assets -0- (912,761) -0- -0- ---------- ---- - - - - -- ---- - - - - -- ---- - - - - -- Change in Net Assets $ 2,477,960 $ 4,896,080 $ 3,594,644 $ (819,682) Beg. Balance 10 -1 $10,417,658 $ 5,521,578 $ 1,926,934 $ 2,746,616 End. Balance 9 -30 $12,895,618 $10,417,658 $ 5,521,578 $ 1,926,934 NON FUNDED DEBT NON- FUNDED DEBT PAYABLE (As of September 30, 2016) None. ECONOMIC BACKGROUND 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 or 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 - 2016 The oil production for this county accounts for 0.07% of the total state production. The county ranks 88 out of all the counties in Texas for oil production. OIL PRODUCTION (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2013 Oil 967,534 BBL -2.68 2014 Oil 896,850 BBL -7.31 2015 Oil 741,580 BBL -17.31 2016 Oil 708.784 BBL -4.42 CASINGHEAD (Texas Railroad Commission) Fiscal Year Ended Description Volume 09 -30 -2016 09 -30 -2015 09 -30 -2014 09 -30 -2013 Revenues: MCF -40.93 2014 Casinghead Water Revenue $14,675,393 $16,278,709 $13,790,208 $9,107,237 Impact Fees 927,843 910,030 449,997 417,297 Reservation Fees 0 0 269,000 538,000 Lease Revenue 146,214 129,600 93,369 126,444 Other 260,967 158,800 124,447 103,876 Total Revenues -- - - - - -- $16.010.417 -- - - - - -- $17.477.139 -- - - - - -- $14.727.021 -- - - - - -- $10.292.854 Expenses Lease Payments $2,252,353 Depreciation 2,395,014 Amortization Expense 85,399 Other 4,571,831 Total Expenses $9,304,597 Operating Income(Loss) $6,705,820 Nonoperating Income (Expense) Interest Income $ 85.829 Contribution from Cities of Schertz & Seguin -0- Interest Expense (4,313,689) Gain (Loss) on Disposal $2,234,066 $2,467,171 $2,473,882 1,962,622 1,547,003 1,506,043 85,399 85,399 85,399 4,735,359 3.256,985 2,225,818 $9,017,446 $7,356,558 $6,291,142 $8,459,693 $7,370,463 $4,001,712 $ 17,595 $ 14,551 $ 51,441 -0- (269,000) (538,000) (2,668,447) (3,521,370) (4,334,835) of Assets -0- (912,761) -0- -0- ---------- ---- - - - - -- ---- - - - - -- ---- - - - - -- Change in Net Assets $ 2,477,960 $ 4,896,080 $ 3,594,644 $ (819,682) Beg. Balance 10 -1 $10,417,658 $ 5,521,578 $ 1,926,934 $ 2,746,616 End. Balance 9 -30 $12,895,618 $10,417,658 $ 5,521,578 $ 1,926,934 NON FUNDED DEBT NON- FUNDED DEBT PAYABLE (As of September 30, 2016) None. ECONOMIC BACKGROUND 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 or 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 - 2016 The oil production for this county accounts for 0.07% of the total state production. The county ranks 88 out of all the counties in Texas for oil production. OIL PRODUCTION (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2013 Oil 967,534 BBL -2.68 2014 Oil 896,850 BBL -7.31 2015 Oil 741,580 BBL -17.31 2016 Oil 708.784 BBL -4.42 CASINGHEAD (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2013 Casinghead 30,277 MCF -40.93 2014 Casinghead 43,544 MCF 43.82 2015 Casinghead 35,184 MCF -19.20 2016 Casinghead 38.784 MCF 10.23 RETAIL SALES & EFFECTIVE BUYING INCOME (The Nielsen Company) Year 2016 2015 2014 Retail Sales $1.4B $1.5B $2.2B Effective Buying Income (EBI) $3.4B $3.5B $3.3B County Median Household Income $53.189 $58,134 $54,803 State Median Household Income $55.352 $53,037 $50,464 % of Households with EBI below $25K 9.4 % 8.0 % 8.5 % % of Households with EBI above $25K 70.9 % 70.5 % 71.2 % EMPLOYMENT DATA (Texas Workforce Commission) 2017 2016 2015 Employed Earnings Employed Earnings Employed Earnings 1st Q: 39,205 $398.9M 37,487 $366.6M 33,204 $328.8M 2nd Q: N/A N/A 38,428 $383.111 33,980 $334.6M 3rd Q: N/A N/A 38,632 $397.611 34,291 $345.511 4th Q: N/A N/A 39,745 $416.4M 35,026 $378.OM MAJOR COLLEGES AND UNIVERSITIES: Texas Lutheran University COLLEGES AND UNIVERSITIES Year Total Fall Enrollment „,. ,; Schertz/Seguin i t Government Corp Texas Municipal Reports Fe � p I ➢, (Schertz & Seguin, Cities of, Project) Last Revised: 10/6/2017 o TMR # 1764 ,- Guadalupe County Page 6 of 6 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 President, Board of Directors Robin V. Dwyer Schertz- Seguin Local Government Corporation P.O. Box 833 Seguin, TX 78156 Phone: 830 -401 -2409 Fax: 830 -401 -2320 General Manager R. Alan Cockerell Schertz- Seguin Local Government Corporation P. 0 Box 833 Seguin, TX 78156 -0833 Phone: 830 -401 -2320 Fax: 830 - 401 -2481 acockerell @seguintexas.gov Assistant General Manager Amber Briggs -Beard Schertz /Seguin Local Government Corporation P.O. Box 833 Seguin, TX 78156 Phone: 830 - 401 -2409 Fax: 830 -401 -2320 abriggs @seguintexas.gov Office Administrator Angela Kleinschmidt Schertz /Seguin Local Government Corporation P.O. Box 833 Seguin, TX 78156 Phone: 830 - 401 -2409 Fax: 830 -401 -2320 akleinschmidt @seguintexas.gov City Manager John C. Kessel 1400 Schertz Parkway Schertz, TX 78154 Phone: 210- 619 -1000 Ext: 1112 Fax: 210- 619 -1139 jkessel @schertz.com City Manager Douglas Faseler 205 N River Street Seguin, TX 78155 -0591 Phone: 830 -401 -2302 Fax: 830 -401 -2499 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 i l' s . .. r �, r,�� dh ,; i I Municipal t Texas Municipal Reports 'IC '" (Southern Wastewater Treatment Plant Project) Last Revised: 10/27/2017 o TMIR # 6774 Bexar, Comal, Guadalupe Counties Page 1 of 3 FINANCIAL STATEMENT FOR OTHER BONDS FOR THIS ISSUER, SEE SEPARATE MUNICIPAL REPORTS FINANCIAL STATEMENT (As of September 30, 2016) Special Obligation Debt Senior Lien $6,730,000 PAYMENT RECORD: Cibolo Creek Municipal Authority has never defaulted. PAYMENT RECORD Cibolo Creek Municipal Authority has never defaulted. DETAILS OF OUTSTANDING DEBT Details of Senior Lien Debt (Outstanding 9/30/2016) Contract Rev Bds (Southern Wastewater Treatment Plant Proj) Ser 2014 Lien: Senior Tax Treatment: Bank Qualified Original Issue Amount $6.950,000.00 Dated Date: 09/01/2014 Sale Date: 09/11/2014 Delivery Date: 10/08/2014 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 09/01, 03/01 1st Coupon Date: 03/01/2015 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski LLP Financial Advisor: Southwest Securities, San Antonio, TX Lead Manager: Raymond James Co- Manager: Frost Bank Underwriter's Counsel: Andrews Kurth L.L.P. Insurance: Assured Guaranty Municipal Corp. (FSA) Use of Proceeds: Wastewater Treatment Plant. Orig Reoffering Maturity Amount Coupon Price /Yield 09/01/2017 09/01/2018 09/01/2019 09/01/2020 09/01/2021 09/01/2022 09/01/2023 09/01/2024 09/01/2026T 09/01/2028T 09/01/2030T 09/01/2032T 09/01/2034T 09/01/2039T 09/01/2044T 150,000.00 150,000.00 155,000.00 160.000.00 160,000.00 165,000.00 170,000.00 175,000.00 365,000.00 395,000.00 430.000.00 460,000.00 500,000.00 1,465,000.00 1,830,000.00 2.0000% 0.900X 2.0000% 1.200% 2.0000% 1.5501 2.0000% 1.800 2.0000% 100.00< 3.0000% 2.3001 3.0000% 2.5501 3.0000% 2.700X 4.0000% 2.850% 4.0000% 3.0501 4.0000% 3.300 4.0000% 3.450< 4.0000% 3.5501 5.0000% 3.5601 4.0000% 100.001 $6.730.000.00 Call Option: Term bonds maturing on 09/01/2026 and 09/01/2028 and 09/01/2030 and 09/01/2032 and 09/01/2034 and 09/01/2039 and 09/01/2044 callable in whole or in part on any date beginning 09/01/2024 @ par. Term Call: Term bonds maturing on 09/01/2026: Mandatory Redemption Date Principal Amount 09/01/2025 09/01/2026 $180.000 $185,000 Term bonds maturing on 09/01/2028: Mandatory Redemption Date Principal Amount 09/01/2027 $195,000 09/01/2028 $200,000 Term bonds maturing on 09/01/2030: Mandatory Redemption Date Principal Amount 09/01/2029 $210,000 09/01/2030 $220,000 Term bonds maturing on 09/01/2032: Mandatory Redemption Date Principal Amount 09/01/2031 $225,000 09/01/2032 $235,000 Term bonds maturing on 09/01/2034: Mandatory Redemption Date Principal Amount 09/01/2033 $245,000 09/01/2034 $255,000 Term bonds maturing on 09/01/2039: Mandatory Redemption Date Principal Amount 09/01/2035 $265,000 09/01/2036 $280,000 09/01/2037 $295,000 09/01/2038 $305,000 09/01/2039 $320,000 Term bonds maturing on 09/01/2044: Mandatory Redemption Date Principal Amount 09/01/2040 $340,000 09/01/2041 $350,000 09/01/2042 $365.000 09/01/2043 $380.000 09/01/2044 $395.000 Grand Total _ ______________> $6,730,000.00 Bond Debt Service Period Ending Principal Interest Debt Service 09/30/17 150,000.00 263,250.00 413,250.00 09/30/18 150,000.00 260,250.00 410,250.00 09/30/19 155,000.00 257,250.00 412,250.00 09/30/20 160,000.00 254,150.00 414,150.00 09/30/21 160,000.00 250,950.00 410,950.00 09/30/22 165,000.00 247,750.00 412,750.00 09/30/23 170,000.00 242,800.00 412,800.00 09/30/24 175,000.00 237,700.00 412,700.00 09/30/25 180,000.00 232,450.00 412,450.00 09/30/26 185,000.00 225,2.50.00 410,250.00 09/30/27 195,000.00 217,850.00 412,850.00 09/30/28 200,000.00 210,050.00 41.0,050.00 09/30/29 210,000.00 202,050.00 412,050.00 09/30/30 220,000.00 193,650.00 413,650.00 09/30/31 225,000.00 184,850.00 409,850.00 09/30/32 235,000.00 175,850.00 410,850.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 09/30/35 265,000.00 146,450.00 411,450.00 09/30/36 280,000.00 133,200.00 413,200.00 09/30/37 295,000.00 119,200.00 414,200.00 09/30/38 305,000.00 104,450.00 409,450.00 09/30/39 320.000.00 89.200.00 409.200.00 Uf .. . ,; Cibolo t Texas Municipal Reports "o '" (Southern Wastewater Treatment Plant Project) Last Revised: 10/27/2017 o TMIR # 6774 Bexar, Comal, Guadalupe Counties Page 2 of 3 09/30/40 340,000.00 City of Universal City 73,200.00 413,200.00 09/30/41 350,000.00 4.31 59,600.00 409,600.00 09/30/42 365,000.00 City of Selma 45,600.00 410,600.00 09/30/43 380,000.00 31,000.00 411,000.00 09/30/44 395,000.00 15,800.00 410,800.00 09/30/2022 6,730,000.00 4,796,900.00 11,526,900.00 COMPUTED ON BASIS OF MANDATORY REDEMPTION Debt Amortization Rates % of Principal Period Ending Principal Retired 09/30/2017 150,000.00 City of Universal City 02.23% City of Schertz 09/30/2018 150,000.00 4.31 04.46% 5.99 09/30/2019 155,000.00 City of Selma 06.76% City of Live Oak 09/30/2020 160,000.00 09.14% 09/30/2021 160,000.00 11.52% 09/30/2022 165,000.00 13.97% 09/30/2023 170.000.00 16.49% 09/30/2024 175,000.00 19.09% 09/30/2025 180,000.00 21.77% 09/30/2026 185,000.00 24.52% 09/30/2027 195,000.00 27.41% 09/30/2028 200,000.00 30.39% 09/30/2029 210,000.00 33.51% 09/30/2030 220,000.00 36.78% 09/30/2031 225,000.00 40.12% 09/30/2032 235,000.00 43.61% 09/30/2033 245,000.00 47.25% 09/30/2034 255,000.00 51.04% 09/30/2035 265,000.00 54.98% 09/30/2036 280,000.00 59.14% 09/30/2037 295,000.00 63.52% 09/30/2038 305,000.00 68.05% 09/30/2039 320,000.00 72.81% 09/30/2040 340,000.00 77.86% 09/30/2041 350,000.00 83.06% 09/30/2042 365,000.00 88.48% 09/30/2043 380,000.00 94.13% 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 Cjj- r 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, SYSTEM DESCRIPTION AND PERTINENT CONTRACTS WASTEWATER TREATMENT CONTRACTS The Authority was created to provide a regional waste treatment system to a 28,672 acre area which includes portions of Bexar, Coma], 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 1.3, 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, FEES AND OPERATING DATA SEWER RATES (Monthly billing)(Based on 3 month winter averaging) Effective since October 1, 2013, October 1, 2014, October 1, 2015 and October 1, 2016 Old Rates (Effective October 1, 2015) Impact Fees - $1,800.00* $3.15/M gallons * One -time charge per connection. New Rates (Effective October 1, 2016) Impact Fees - $1,800.00* $3.35/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 1971 as a conservation and reclamation district for the purpose of providing a regional sewer system for an area comprising some 58.26 square miles and encompassing the City of Schertz, the City of Cibolo, and parts of the Cities of Live Oak, Universal City, San Antonio. Selma, and the Randolph Air Force Base, all of which lie within the Austin -San Antonio growth corridor. The economy of the area is dominated by Randolph Air Force Base. A mall within the Authority's boundaries stimulates commercial and residential development. COUNTY CHARACTERISTICS: Bexar County was created in 1836. The south central Texas county is the major component of the San Antonio Metropolitan Statistical Cibolo Creek Municipal Auth Texas Municipal Reports ,_' '" (Southern Wastewater Treatment Plant Project) Last Revised: 10/27/2017 o TMR # 6774 Bexar, Comal, Guadalupe Counties Page 3 of 3 Area and is traversed by Interstate Highways 10 and 35, four U.S. Highways, and two State Highways. COUNTY SEAT: San Antonio 2010 census: 1,714,773 increasing 23.1 % since 2000 2000 census: 1,392,931 increasing 17.5 % since 1990 1990 census: 1,185,394 ECONOMIC BASE Mineral: sand, limestone and gravel. Industry: tourism, military bases, medical /biomedical research & services, government and education center. Agricultural: nursery crops, hay, grain sorghum, corn and beef cattle. OIL AND GAS - 2016 The oil production for this county accounts for 0.01% of the total state production. The county ranks 152 out of all the counties in Texas for oil production. OIL PRODUCTION (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2013 Oil 125,446 BBL 5.15 2014 Oil 119,014 BBL -5.13 2015 Oil 95,355 BBL -19.88 2016 Oil 128.211 BBL 34.46 CASINGHEAD (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2013 Casinghead 44 MCF 22.22 2014 Casinghead 24 MCF -45.45 2015 Casinghead 23 MCF -4.17 2016 Casinghead 59,809 MCF 259,939.13 PARKS (Texas Parks & Wildlife) Year Description Volume 2013 Government Canyon State Natural Area 58,540 Visitors 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 2013 San Antonio Missions National Historic Park 521,705 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 2013 Brooks City Air Force Base 13 Members 2014 Brooks City Air Force Base 7 Members 2013 Fort Sam Houston 21,256 Members 2014 Fort Sam Houston 22,810 Members 2013 Kelly Air Force Base 206 Members 2014 Kelly Air Force Base 642 Members 2013 Lackland Air Force Base 32,116 Members 2014 Lackland Air Force Base 30,341 Members 2013 Randolph Air Force Base 7,333 Members 2014 Randolph Air Force Base 7,398 Members 2013 San Antonio Callaghan US Army Recruiting 4 Members 2014 San Antonio Callaghan US Army Recruiting 5 Members RETAIL SALES & EFFECTIVE BUYING INCOME (The Nielsen Company) Year 8 115,582 2016 2015 2014 Retail Sales 2013 $28.18 $25.88 $24.OB Effective Buying Income (EBI) $40.78 $39.5B $36.OB County Median Household Income $45,381 $45,298 $42,396 State Median Household Income $55,352 $53,037 $50,464 % of Households with EBI below $25K 12.0 % 12.0 % 13.0 % % of Households with EBI above $25K 65.8 % 66.7 % 65.6 % EMPLOYMENT DATA (Texas Workforce Commission) 2017 2016 2015 Employed Earnings Employed Earnings Employed Earnings 1st Q: 847,979 $10.88 830,742 $10.1B 806,522 $9.8B 2nd Q: N/A N/A 839,061 $9.6B 817,903 $9.18 3rd Q: N/A N/A 841,723 $10.OB 817,129 $9.38 4th Q: N/A N/A 853,892 $10.6B 832,495 $10.4B 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 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 N >` ,, C-'q n ME X�MO�� •