Loading...
Debt Model Report Sept 30, 2017 Updated May 23, 2017City of Schertz, Texas Debt Model For Fiscal Year Ending September 30, 2017 Elm Presented by. SAMCO Capital Markets, Inc. Mark McLiney Andrew Friedman (210) 832-9760 On- 74A T� roV 738,921 446,525 329,700 568,463 559,735 386,775 237 264,225 6,407,206 2021 423,799 735,969 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 6,330,204 2022 425,267 738;150 1372,540 567;350 708;911 :503,676 - : '- 1,018;025 ':157387 37,050 !' 376,606 235,469 100,263 :534,425 265,050 6,040,159:' 2023 426,123 734,403 380,581 - 566,263 698,242 505,126 - - 1,020,150 - - 37,050 376,606 237,469 103,388 418,400 265,025 5,768,825 2024 426,370:: 734,726 412,294 - 566,713 667;689 :500,920 - 1,019;525 - 2026 37,050 376,206 97,319 101,438 :418,800 264,850 ` 5,623,898- 2025 426,005 738,914 388,225 - 568,606 - 500,645 - - 1,021,000 - - 37,050 375,406 100,144 104,413 271,150 264,525 4,796,083 2026 425,031! 736;965 C 389,000 569,469 504,435 - 1,021;425 - 37,050 1 374,206 97;894 102,313 :270,525 264,050 +. 4,792,362' 2027 423,445 733,985 389,325 - 569,263 - 502,250 - - 1,018,575 - - 37,050 375,556 100,969 104,950 269,750 263,425 4,788,542 !'. 2028 - 734,868 ;:682,450 - 567,950 ` - (504,275 - " - 1,022;175 - 37,050 374,606 99,369 102,325 368,825 ` 262,650 '< 4,656,543s 2029 - - 583,013 - 565,494 - 500,925 - - 1,014,375 - - 37,050 373,366 97,719 104,613 267,750 266,650 3,810,953 2030 - ::582,300 566,738 1502,200 - 1,022;588 37,050 371,638 100;913 101,813 :271,450 265,425 r 3,822,113? 2031 - 585,075 - 566,250 - 502,785 - - - - 1,158,525 374,350 98,947 103,925 269,925 264,050 3,923,832 2032 - 586,200 569,125 502,673 - 376,425 101;869 100,844 :'268,250 267,450 i 2,772,835:: 2033 - 885,675 - 565,875 - - - - 372,275 99,675 102,563 271,350 265,625 2,263,038 2034 - - 566;500 - 372;075 97,200 104,094 :268,925 263,356 1,672,150e: 2035 - - 565,875 - - - - - 376,500 99,425 100,531 270,963 265,556 1,678,850 i 2036 - - 568,875 -._ - :_ - : 375;550 ,._ 101,500 , -: 101,875 267,756 - 262,513 : 1,678,069' 2037 ..269.306 264,225 533,531 I'. Total :.14,681,491':: L_8837173 1_1158899 1 :11,640,600 i$11,351,431P $ 5,155;680 $ 8045,245 $ ;I 345,440 $ 329;258 $11,111;213 $ 1:89,625 $ '.943,741 $`::4,846638 ;:$ 7,700;553 $ 2,957;922 $ 2;051,981 $ 7;025,683 $: ::5,307,169 - :$90679,741::: 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 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' 2020 :238,250 - 218,739 'r - 948;367;:. 2024 489,536 - 237,963 223,321 - 950,819 2025 492,093): - 1237,100 <; 217774 '- - 948;966: 2026 488,847 236,063 -.. - 724,910 2028 236,800 236,800 2030 - 235,900 - - 235,900 'z 2031 237,500 - 237;500- 2032 - 238,700 - 238,700 2033 z - :234,600 234;600;: Total $4,886,110 $ 1,325,225 $ 5,389,831 $ 1,994,140 $ 137,000 $ 13,732,306 2018 360,769 360,769 2018 123,225 2019 12019 121,213`'. 2020 - - 2020 124,200 2021 2021 '- 122,100 -. 2022 - - Total $ 610,888 2023 2024 2025 Fiscal Year Tax Notes: 2026 - - Ending 9130 : 5.2015 2027 2017 $. 171,375 2028 - -.:: ......2018 168,575... '. 2029 ' -2019 '. 170,775 2030 - - 2020 167,888 'i 2031 - '2021 2032 Total $ 678,613 2033 Total $ 727,556 $ 727,556 2017 $ 520,000 $ 1,387,413 $ 664,375 $ 2,435,550 $ 5,007,338 $ 2,503,669 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 2,271,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 r 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 424,600 424,600 212,300 Total $ 18,634,340 $ 34,749,706 $ 5,979,688 $ 69,152,025 $ 128,515,759 $ 64,257,879 2017 $ 1,510,188 2018 1,511,788 2019 1,511,488 2020 1,510,188 2021 1,512,788 2022 1,509,288 i 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 2042 - 2043 2044 Total $ 37,765,675 2017 $ 413,250 2018 410,250 2019 412,250 2021 410,950 2022 412,750 2023 412,800 2024 412,700 2025 412,450 2026 410,250 2027 412,850 2029 412,050 2030 413,650 2031 409,850 2032 410,850 2033 411,450 2034 411,650 2035 411,450 2037 414,200 2038 409,450 2039 409,200 2040 413,200 2041 409,600 2042 410,600 2043 411,000 2044 410,800 Total $ 11,526,900 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/2017 79,398.00 79,398.00 08/01/2017 330,000 4.010% 79,398.00 409,398.00 09/30/2017 488,796.00 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,960,000 926,109.50 4,886,109.50 4,886,109.50 May 23, 2017 12:19 pm 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/2017 280,000 4.070% 76,821.25 356,821.25 08/01/2017 71,123.25 71,123.25 09/30/2017 427,944.50 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,775,000 906,490.75 4,681,490.75 4,681,490.75 May 23, 2017 12:19 pm 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 Interest Debt Service Annual Debt Service 02/01/2017 460,000 4.130% 143,930.50 603,930.50 08/01/2017 134,431.50 134,431.50 09/30/2017 738,362.00 02/01/2018 475,000 4.130% 134,431.50 609,431.50 08/01/2018 124,622.75 124,622.75 09/30/2018 734,054.25 02/01/2019 500,000 4.130% 124,622.75 624,622.75 08/01/2019 114,297.75 114,297.75 09/30/2019 738,920.50 02/01/2020 520,000 4.130% 114,297.75 634,297.75 08/01/2020 103,559.75 103,559.75 09/30/2020 737,857.50 02/01/2021 540,000 4.130% 103,559.75 643,559.75 08/01/2021 92,408.75 92,408.75 09/30/2021 735,968.50 02/01/2022 565,000 4.130% 92,408.75 657,408.75 08/01/2022 80,741.50 80,741.50 09/30/2022 738,150.25 02/01/2023 585,000 4.130% 80,741.50 665,741.50 08/01/2023 68,661.25 68,661.25 09/30/2023 734,402.75 02/01/2024 610,000 4.130% 68,661.25 678,661.25 08/01/2024 56,064.75 56,064.75 09/30/2024 734,726.00 02/01/2025 640,000 4.130% 56,064.75 696,064.75 08/01/2025 42,848.75 42,848.75 09/30/2025 738,913.50 02/01/2026 665,000 4.130% 42,848.75 707,848.75 08/01/2026 29,116.50 29,116.50 09/30/2026 736,965.25 02/01/2027 690,000 4.130% 29,116.50 719,116.50 08/01/2027 14,868.00 14,868.00 09/30/2027 733,984.50 02/01/2028 720,000 4.130% 14,868.00 734,868.00 09/30/2028 734,868.00 6,970,000 1,867,173.00 8,837,173.00 8,837,173.00 May 23, 2017 12:19 pm 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/2017 550,000 3.000% 137,287.50 687,287.50 08/01/2017 129,037.50 129,037.50 09/30/2017 816,325.00 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 6,015,000 2,871,455.00 8,886,455.00 8,886,455.00 May 23, 2017 12:19 pm 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/2017 200,000 3.000% 126,268.75 326,268.75 08/01/2017 123,268.75 123,268.75 09/30/2017 449,537.50 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,310,000 2,848,898.75 8,158,898.75 8,158,898.75 May 23, 2017 12:19 pm 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 Interest Debt Service Annual Debt Service 02/01/2017 350,000 3.000% 11,018.75 361,018.75 08/01/2017 5,768.75 5,768.75 09/30/2017 366,787.50 02/01/2018 355,000 1250% 5,768.75 360,768.75 09/30/2018 360,768.75 705,000 22,556.25 727,556.25 727,556.25 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 6 81010 WO M XUKETS, M. 00IND11DN.11W:I ATJ 1419 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/2017 285,000 3.000% 25,650 310,650 08/01/2017 21,375 21,375 09/30/2017 332,025 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,500,000 140,600 1,640,600 1,640,600 May 23, 2017 12:19 pm 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/2017 235,000 3.000% 169,143.75 404,143.75 08/01/2017 165,618.75 165,618.75 09/30/2017 569,762.50 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 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 8 81010 WO M XUKETS, M. May 23, 2017 12:19 pm 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,305,000 4,046,431.25 11,351,431.25 11,351,431.25 May 23, 2017 12:19 pm 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/2017 620,000 2.330% 54,813.25 674,813.25 08/01/2017 47,590.25 47,590.25 09/30/2017 722,403.50 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 2.330% 34,542.25 509,542.25 08/01/2020 29,008.50 29,008.50 09/30/2020 538,550.75 02/01/2021 485,000 2.330% 29,008.50 514,008.50 08/01/2021 23,358.25 23,358.25 09/30/2021 537,366.75 02/01/2022 670,000 2.330% 23,358.25 693,358.25 08/01/2022 15,552.75 15,552.75 09/30/2022 708,911.00 02/01/2023 675,000 2.330% 15,552.75 690,552.75 08/01/2023 7,689.00 7,689.00 09/30/2023 698,241.75 02/01/2024 660,000 2.330% 7,689.00 667,689.00 09/30/2024 667,689.00 4,705,000 450,680.25 5,155,680.25 5,155,680.25 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 10 81010 WO M XUKETS, M. 00IND11DN.11W:I ATJ 1419 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/2017 15,237.50 15,237.50 09/01/2017 300,000 2.000% 15,237.50 315,237.50 09/30/2017 330,475.00 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 1,230,000 95,225.00 1,325,225.00 1,325,225.00 May 23, 2017 12:19 pm 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/2017 320,000 4.350% 94,357.50 414,357.50 08/01/2017 87,397.50 87,397.50 09/30/2017 501,755.00 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,440,000 1,605,245.00 8,045,245.00 8,045,245.00 May 23, 2017 12:19 pm 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 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2017 170,000 1.300% 2,550 172,550 08/01/2017 1,445 1,445 09/30/2017 173,995 02/01/2018 170,000 1.700% 1,445 171,445 09/30/2018 171,445 340,000 5,440 345,440 345,440 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 13 81010 WO M RUKETS, M. OW III DlQ:I.11W:I ATJ 1419 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/2017 160,000 1.300% 2,112.50 162,112.50 08/01/2017 1,072.50 1,072.50 09/30/2017 163,185.00 02/01/2018 165,000 1.300% 1,072.50 166,072.50 09/30/2018 166,072.50 325,000 4,257.50 329,257.50 329,257.50 May 23, 2017 12:19 pm 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/2017 380,000 2.000% 66,081.25 446,081.25 08/01/2017 62,281.25 62,281.25 09/30/2017 508,362.50 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 4,260,000 1,129,831.25 5,389,831.25 5,389,831.25 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 15 81010 WO M XUKETS, M. DETAILED 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 General Obligation Portion (CI131) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2017 245,000 2.000% 15,043.75 260,043.75 08/01/2017 12,593.75 12,593.75 09/30/2017 272,637.50 02/01/2018 250,000 2.000% 12,593.75 262,593.75 08/01/2018 10,093.75 10,093.75 09/30/2018 272,687.50 02/01/2019 255,000 2.250% 10,093.75 265,093.75 08/01/2019 7,225.00 7,225.00 09/30/2019 272,318.75 02/01/2020 260,000 2.500% 7,225.00 267,225.00 08/01/2020 3,975.00 3,975.00 09/30/2020 271,200.00 02/01/2021 265,000 3.000% 3,975.00 268,975.00 09/30/2021 268,975.00 1,275,000 82,818.75 1,357,818.75 1,357,818.75 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 16 81010 WO M XUKETS, M. DETAILED 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 Utility Fund Portion (CIB2) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2017 135,000 2.000% 51,037.50 186,037.50 08/01/2017 49,687.50 49,687.50 09/30/2017 235,725.00 02/01/2018 140,000 2.000% 49,687.50 189,687.50 08/01/2018 48,287.50 48,287.50 09/30/2018 237,975.00 02/01/2019 140,000 2.250% 48,287.50 188,287.50 08/01/2019 46,712.50 46,712.50 09/30/2019 235,000.00 02/01/2020 145,000 2.500% 46,712.50 191,712.50 08/01/2020 44,900.00 44,900.00 09/30/2020 236,612.50 02/01/2021 150,000 3.000% 44,900.00 194,900.00 08/01/2021 42,650.00 42,650.00 09/30/2021 237,550.00 02/01/2022 155,000 3.000% 42,650.00 197,650.00 08/01/2022 40,325.00 40,325.00 09/30/2022 237,975.00 02/01/2023 160,000 3.000% 40,325.00 200,325.00 08/01/2023 37,925.00 37,925.00 09/30/2023 238,250.00 02/01/2024 165,000 3.500% 37,925.00 202,925.00 08/01/2024 35,037.50 35,037.50 09/30/2024 237,962.50 02/01/2025 170,000 3.500% 35,037.50 205,037.50 08/01/2025 32,062.50 32,062.50 09/30/2025 237,100.00 02/01/2026 175,000 3.500% 32,062.50 207,062.50 08/01/2026 29,000.00 29,000.00 09/30/2026 236,062.50 02/01/2027 185,000 4.000% 29,000.00 214,000.00 08/01/2027 25,300.00 25,300.00 09/30/2027 239,300.00 02/01/2028 190,000 4.000% 25,300.00 215,300.00 08/01/2028 21,500.00 21,500.00 09/30/2028 236,800.00 02/01/2029 200,000 4.000% 21,500.00 221,500.00 08/01/2029 17,500.00 17,500.00 09/30/2029 239,000.00 02/01/2030 205,000 4.000% 17,500.00 222,500.00 08/01/2030 13,400.00 13,400.00 09/30/2030 235,900.00 02/01/2031 215,000 4.000% 13,400.00 228,400.00 08/01/2031 9,100.00 9,100.00 09/30/2031 237,500.00 02/01/2032 225,000 4.000% 9,100.00 234,100.00 08/01/2032 4,600.00 4,600.00 09/30/2032 238,700.00 02/01/2033 230,000 4.000% 4,600.00 234,600.00 09/30/2033 234,600.00 2,985,000 1,047,012.50 4,032,012.50 4,032,012.50 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 17 81010 WO M XUKETS, M. 00IND11DN.11W:I ATJ 1419 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/2017 180,000 2.580% 22,962.00 202,962.00 08/01/2017 20,640.00 20,640.00 09/30/2017 223,602.00 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,780,000 214,140.00 1,994,140.00 1,994,140.00 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 18 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/2017 100,000 2.000% 146,637.50 246,637.50 08/01/2017 145,637.50 145,637.50 09/30/2017 392,275.00 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,300,000 2,811,212.50 11,111,212.50 11,111,212.50 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 19 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/2017 13,475.00 13,475.00 08/01/2017 330,000 1.750% 13,475.00 343,475.00 09/30/2017 356,950.00 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,540,000 76,125.00 1,616,125.00 1,616,125.00 May 23, 2017 12:19 pm 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 EMS 6 Years (CIB1) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2017 5,687.50 5,687.50 08/01/2017 160,000 1.750% 5,687.50 165,687.50 09/30/2017 171,375.00 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 650,000 28,612.50 678,612.50 678,612.50 May 23, 2017 12:19 pm 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 Drainage Equipment (CIB2) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2017 5,075.00 5,075.00 08/01/2017 110,000 1.750% 5,075.00 115,075.00 09/30/2017 120,150.00 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 580,000 30,887.50 610,887.50 610,887.50 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 22 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/2017 1,137.50 1,137.50 08/01/2017 25,000 1.750% 1,137.50 26,137.50 09/30/2017 27,275.00 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 130,000 7,000.00 137,000.00 137,000.00 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 23 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/2017 1,575.00 1,575.00 08/01/2017 35,000 1.750% 1,575.00 36,575.00 09/30/2017 38,150.00 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 180,000 9,625.00 189,625.00 189,625.00 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 24 81010 WO M RUKETS, M. OW III DlQ:I.11W:I ATJ 1419 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/2017 6,891.50 6,891.50 08/01/2017 145,000 1.540% 6,891.50 151,891.50 09/30/2017 158,783 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 895,000 48,741.00 943,741.00 943,741 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 25 81010 WO M XUKETS, M. BOND DEBT SERVICE 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/2017 450,000 2.000% 53,312.50 503,312.50 08/01/2017 48,812.50 48,812.50 09/30/2017 552,125.00 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 4,105,000 741,637.50 4,846,637.50 4,846,637.50 May 23, 2017 12:19 pm 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 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/2017 405,000 2.000% 89,903.13 494,903.13 08/01/2017 85,853.13 85,853.13 09/30/2017 580,756.26 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 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 27 81010 WO M XUKETS, M. May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 28 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,880,000 1,820,553.25 7,700,553.25 7,700,553.25 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 28 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/2017 170,000 4.000% 39,784.38 209,784.38 08/01/2017 36,384.38 36,384.38 09/30/2017 246,168.76 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 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 29 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,375,000 582,922.02 2,957,922.02 2,957,922.02 May 23, 2017 12:19 pm 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 Dated Date 08/01/2016 Delivery Date 09/01/2016 Remodel Component (REMODEL) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2017 110,000 4.000% 16,900 126,900 08/01/2017 14,700 14,700 09/30/2017 141,600 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 845,000 123,300 968,300 968,300 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 31 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 Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2017 60,000 4.000% 22,884.38 82,884.38 08/01/2017 21,684.38 21,684.38 09/30/2017 104,568.76 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 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 32 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 Interest Debt Service Annual Debt Service 09/30/2034 97,200.00 02/01/2035 95,000 3.000% 2,925.00 97,925.00 08/01/2035 1,500.00 1,500.00 09/30/2035 99,425.00 02/01/2036 100,000 3.000% 1,500.00 101,500.00 09/30/2036 101,500.00 1,530,000 459,622.02 1,989,622.02 1,989,622.02 May 23, 2017 12:19 pm 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, Taxable Series 2016B YMCA Lease Payment Supported Dated Date 08/01/2016 Delivery Date 09/01/2016 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2017 55,000 3.000% 24,856.25 79,856.25 08/01/2017 24,031.25 24,031.25 09/30/2017 103,887.50 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 May 23, 2017 12:19 pm 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, 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,475,000 576,981.25 2,051,981.25 2,051,981.25 May 23, 2017 12:19 pm 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 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2017 May 23, 2017 12:19 pm 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 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 02/01/2036 255,000 3.250% 8,450.00 263,450.00 May 23, 2017 12:19 pm 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 Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2017 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 08/01/2036 4,306.25 4,306.25 09/30/2036 267,756.25 02/01/2037 265,000 3.250% 4,306.25 269,306.25 09/30/2037 269,306.25 5,475,000 1,550,683.06 7,025,683.06 7,025,683.06 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 37 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2017 Dated Date 05/15/2017 Delivery Date 06/20/2017 20 -Year Project Bond Component (BOND) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2018 130,000 3.000% 87,448.89 217,448.89 08/01/2018 59,537.50 59,537.50 09/30/2018 276,986.39 02/01/2019 155,000 3.000% 59,537.50 214,537.50 08/01/2019 57,212.50 57,212.50 09/30/2019 271,750.00 02/01/2020 160,000 3.000% 57,212.50 217,212.50 08/01/2020 54,812.50 54,812.50 09/30/2020 272,025.00 02/01/2021 165,000 3.000% 54,812.50 219,812.50 08/01/2021 52,337.50 52,337.50 09/30/2021 272,150.00 02/01/2022 170,000 3.000% 52,337.50 222,337.50 08/01/2022 49,787.50 49,787.50 09/30/2022 272,125.00 02/01/2023 175,000 3.000% 49,787.50 224,787.50 08/01/2023 47,162.50 47,162.50 09/30/2023 271,950.00 02/01/2024 180,000 3.000% 47,162.50 227,162.50 08/01/2024 44,462.50 44,462.50 09/30/2024 271,625.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 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 38 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2017 20 -Year Proiect Bond Component (BOND) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 08/01/2035 8,450.00 8,450.00 09/30/2035 270,962.50 02/01/2036 255,000 3.250% 8,450.00 263,450.00 08/01/2036 4,306.25 4,306.25 09/30/2036 267,756.25 02/01/2037 265,000 3.250% 4,306.25 269,306.25 09/30/2037 269,306.25 4,015,000 1,399,536.39 5,414,536.39 5,414,536.39 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 39 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2017 Dated Date 05/15/2017 Delivery Date 06/20/2017 Fire Truck (7 YR) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2018 115,000 3.000% 19,626.67 134,626.67 08/01/2018 12,075.00 12,075.00 09/30/2018 146,701.67 02/01/2019 125,000 3.000% 12,075.00 137,075.00 08/01/2019 10,200.00 10,200.00 09/30/2019 147,275.00 02/01/2020 130,000 3.000% 10,200.00 140,200.00 08/01/2020 8,250.00 8,250.00 09/30/2020 148,450.00 02/01/2021 130,000 3.000% 8,250.00 138,250.00 08/01/2021 6,300.00 6,300.00 09/30/2021 144,550.00 02/01/2022 135,000 3.000% 6,300.00 141,300.00 08/01/2022 4,275.00 4,275.00 09/30/2022 145,575.00 02/01/2023 140,000 3.000% 4,275.00 144,275.00 08/01/2023 2,175.00 2,175.00 09/30/2023 146,450.00 02/01/2024 145,000 3.000% 2,175.00 147,175.00 09/30/2024 147,175.00 920,000 106,176.67 1,026,176.67 1,026,176.67 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 40 81010 WO M XUKETS, M. DETAILED BOND DEBT SERVICE City of Schertz, Texas Combination Tax and Limited Pledge Revenue Certificates of Obligation, Series 2017 Dated Date 05/15/2017 Delivery Date 06/20/2017 Ambulances (5 YR) May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 41 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2018 100,000 3.000% 11,520 111,520 08/01/2018 6,600 6,600 09/30/2018 118,120 02/01/2019 105,000 3.000% 6,600 111,600 08/01/2019 5,025 5,025 09/30/2019 116,625 02/01/2020 110,000 3.000% 5,025 115,025 08/01/2020 3,375 3,375 09/30/2020 118,400 02/01/2021 110,000 3.000% 3,375 113,375 08/01/2021 1,725 1,725 09/30/2021 115,100 02/01/2022 115,000 3.000% 1,725 116,725 09/30/2022 116,725 540,000 44,970 584,970 584,970 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 41 81010 WO M XUKETS, M. BOND DEBT SERVICE City of Schertz, Texas General Obligation Bonds, Series 2017 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 42 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 May 23, 2017 12:19 pm 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 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 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 43 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/2017 260,000 260,000 08/01/2017 260,000 260,000 09/30/2017 520,000 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 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 44 81010 WO M XUKETS, M. May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 45 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,634,340 18,634,340 18,634,340 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 45 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/2017 485,000 3.000% 454,843.75 939,843.75 08/01/2017 447,568.75 447,568.75 09/30/2017 1,387,412.50 02/01/2018 505,000 3.500% 447,568.75 952,568.75 08/01/2018 438,731.25 438,731.25 09/30/2018 1,391,300.00 02/01/2019 520,000 3.500% 438,731.25 958,731.25 08/01/2019 429,631.25 429,631.25 09/30/2019 1,388,362.50 02/01/2020 540,000 3.500% 429,631.25 969,631.25 08/01/2020 420,181.25 420,181.25 09/30/2020 1,389,812.50 02/01/2021 560,000 4.000% 420,181.25 980,181.25 08/01/2021 408,981.25 408,981.25 09/30/2021 1,389,162.50 02/01/2022 585,000 4.000% 408,981.25 993,981.25 08/01/2022 397,281.25 397,281.25 09/30/2022 1,391,262.50 02/01/2023 610,000 4.000% 397,281.25 1,007,281.25 08/01/2023 385,081.25 385,081.25 09/30/2023 1,392,362.50 02/01/2024 630,000 4.000% 385,081.25 1,015,081.25 08/01/2024 372,481.25 372,481.25 09/30/2024 1,387,562.50 02/01/2025 660,000 4.000% 372,481.25 1,032,481.25 08/01/2025 359,281.25 359,281.25 09/30/2025 1,391,762.50 02/01/2026 685,000 4.125% 359,281.25 1,044,281.25 08/01/2026 345,153.13 345,153.13 09/30/2026 1,389,434.38 02/01/2027 715,000 4.250% 345,153.13 1,060,153.13 08/01/2027 329,959.38 329,959.38 09/30/2027 1,390,112.51 02/01/2028 745,000 4.250% 329,959.38 1,074,959.38 08/01/2028 314,128.13 314,128.13 09/30/2028 1,389,087.51 02/01/2029 780,000 4.250% 314,128.13 1,094,128.13 08/01/2029 297,553.13 297,553.13 09/30/2029 1,391,681.26 02/01/2030 815,000 4.500% 297,553.13 1,112,553.13 08/01/2030 279,215.63 279,215.63 09/30/2030 1,391,768.76 02/01/2031 850,000 4.500% 279,215.63 1,129,215.63 08/01/2031 260,090.63 260,090.63 09/30/2031 1,389,306.26 02/01/2032 890,000 4.500% 260,090.63 1,150,090.63 08/01/2032 240,065.63 240,065.63 09/30/2032 1,390,156.26 02/01/2033 930,000 4.625% 240,065.63 1,170,065.63 08/01/2033 218,559.38 218,559.38 09/30/2033 1,388,625.01 02/01/2034 975,000 4.625% 218,559.38 1,193,559.38 08/01/2034 196,012.50 196,012.50 09/30/2034 1,389,571.88 02/01/2035 1,020,000 4.625% 196,012.50 1,216,012.50 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 46 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/2035 172,425.00 172,425.00 09/30/2035 1,388,437.50 02/01/2036 1,070,000 4.750% 172,425.00 1,242,425.00 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,760,000 13,989,706.33 34,749,706.33 34,749,706.33 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 47 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/2017 520,000 2.000% 74,787.50 594,787.50 08/01/2017 69,587.50 69,587.50 09/30/2017 664,375.00 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 5,200,000 779,687.50 5,979,687.50 5,979,687.50 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 48 BOND DEBT SERVICE Schertz- Seguin Local Government Corporation Contract Revenue Bond, Series 2015 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 49 Dated Date 12/01/2014 Delivery Date 01/13/2015 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2017 700,000 3.000% 873,025 1,573,025 08/01/2017 862,525 862,525 09/30/2017 2,435,550 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 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 49 BOND DEBT SERVICE Schertz- Seguin Local Government CorporationContract Revenue Bond, Series 2015 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2035 630,000 4.000% 430,800 1,060,800 08/01/2035 418,200 418,200 09/30/2035 1,479,000 02/01/2036 2,960,000 4.000% 418,200 3,378,200 08/01/2036 359,000 359,000 09/30/2036 3,737,200 02/01/2037 3,085,000 4.000% 359,000 3,444,000 08/01/2037 297,300 297,300 09/30/2037 3,741,300 02/01/2038 3,220,000 4.000% 297,300 3,517,300 08/01/2038 232,900 232,900 09/30/2038 3,750,200 02/01/2039 3,345,000 4.000% 232,900 3,577,900 08/01/2039 166,000 166,000 09/30/2039 3,743,900 02/01/2040 3,480,000 4.000% 166,000 3,646,000 08/01/2040 96,400 96,400 09/30/2040 3,742,400 02/01/2041 3,620,000 4.000% 96,400 3,716,400 08/01/2041 24,000 24,000 09/30/2041 3,740,400 02/01/2042 385,000 4.000% 24,000 409,000 08/01/2042 16,300 16,300 09/30/2042 425,300 02/01/2043 400,000 4.000% 16,300 416,300 08/01/2043 8,300 8,300 09/30/2043 424,600 02/01/2044 415,000 4.000% 8,300 423,300 09/30/2044 423,300 41,025,000 28,127,025 69,152,025 69,152,025 May 23, 2017 12:19 pm Prepared by SAMCO Capital Markets, Inc. (ATF) (Finance 7.017 Schertz:AGG) Page 50 ME X�MO�� • Schertz, City Texas Municipal Reports (General Obligation Debt) Last Revised: 10/20/2016 2302 ,f- Guadalupe, Comal, Bexar Counties Page 1 of 13 FOR OPERATING DATA OF THE WATERWORKS AND SEWER SYSTEM, SEE SEPARATE TEXAS MUNICIPAL REPORT. FINANCIAL STATEMENT (As of September 30, 2015) Net Taxable Assessed Valuation ( "A.S. "), 2016 $3,757,413,736 New Debt $14,935,000 Outstanding Debt 63,620,000 Total General Obligation Debt $78.555,000 Less: Self - Supporting (a) Water & Sewer 12,409,759 Economic Development (Type B) 1,384,993 EMS Building 804,885 Drainage 684,866 GO Debt payable from Ad Valorem Taxes $63.270,497 Less: I &S Fund 847,178 Net Debt $62,423,319 (a) The August 01, 2016 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.66% Net Debt Per Sq mile - $2,527,259.88 Net Debt Per Capita $1,737.41 Net Taxable Assessed Valuation Per Capita - $104,578.86 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. MATERIAL INFORMATION: MATERIAL EVENT NOTICE (As of May 28, 2014) Standard & Poor's Ratings Services (S &P) raised its rating on the City's general obligation debt one notch to AA+ from AA based on S &P's local GO criteria published September 1.2, 2013. The outlook is stable. The rating reflects S &P's opinion of the following factors for the City: (i) strong economy; (ii) very strong budgetary flexibility; (iii) strong budgetary performance (iv) very strong liquidity with strong access to external liquidity: (v) strong management; and (vi) very weak debt and contingent liabilities due mostly to high carrying charges and net direct debt. The stable outlook reflects S &P's opinion of the City's very strong budgetary flexibility and liquidity, supported by a strong management team and economy. Tax Tax Adjusted % Collected Total % Collected Year A.V. Rate Levy within FY as of 09/30/2015* 2010 $2,363,893,708 $0.4493 $9,978,430 99.17 Denomination 99.91 2011 2,411,270,623 0.4843 11,239,572 99.29 99.95 2012 2,600,365,551 0.4999 12,536,540 99.35 99.61 2013 2,752,562,574 0.4974 13,383,759 99.35 99.66 2014 3,037,267,611 0.4974 14393,867 99.63 99.63 2015 3.396,288,285 0.4911 16,679,172 (In process of collection) 2016 3.757,413,736 0.4911 18,452,659 * 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 Sedona Development Project. The Zone was created in December 2006 with a base value of $3,127,500. The Zone has a statutory termination date of December 31, 2027. TAX INCREMENT CAPTURED VALUE: 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 2012 1.500% $8.130,275 64.85% $0.32 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 DETAILS OF OUTSTANDING DEBT Details of Limited Tax Debt (Outstanding 9/3012015) GO Bds Ser 2006 Tax Treatment: Tax Exempt Original Issue Amount $15,000,000.00 Dated Date: 08/01/2006 Sale Date: 08/15/2006 Delivery Date: 09/20/2006 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 0210112007 Paying Agent: Wells Fargo Bank, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski L.L.P. ,; i Texas Municipal Reports "o (General Obligation Debt) Last Revised: 10/20/2016 2302 ,f- Guadalupe, Comal, Bexar Counties Page 2 of 13 Financial Advisor: Southwest Securities, San Antonio, TX Lead Manager: SAMCO Capital Markets Co- Manager: BBC Capital Markets Insurance: National Public Finance Guarantee Corporation Use of Proceeds: Library, Streets & Sidewalks, Drainage. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2016 400,000.00 4.0000% 4.110% $400,000.00 Call Option: Non Callable Refunded Notes: M, Refunded Amount 1,540,000.00 1,715,000.00 1,900,000.00 3,220,000.00* 3turities refunded Mat Date Coupon 02/01/2023 5.250 02/01/2025 5.250 02/01/2027 5.250 02/01/2031 4.625 )y GO RE Price Par Par Par Par �f Bds Ser 2014 Sched Call 02/01/2016 02/01/2016 02/01/2016 02/01/2016 Maturities refunded by GO Ref Bds Ser 2015 Refunded Amount Mat Date Coupon Price Sched Call 425,000.00 0210112017 4.125 Par 02/01/2016 475,000.00 02/01/2018 4.200 Par 02/01/2016 655,000.00 02/01/2019 4.300 Par 02/01/2016 685,000.00 0210112020 4.375 Par 02/01/2016 715,000.00 0210112021 4.400 Par 02/01/2016 1,175,000.00 ** 02/01/2031 4.625 Par 02/01/2016 * Partial Maturity ** Remainder 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 81,000. Economic Development (Type B) 7.37% Water & Sewer 92.63% Use of Proceeds: Utility, Streets & Drainage, Public Works, Energy Management Sys, Communication Equipment. Orig Reoffering Maturity Amount Coupon Price /Yield 08/01/2016 655,000.00 4.0100% N/A 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 08/01/2020 370,000.00 4.0100% N/A 08/01/2021 385,000.00 Tax Treatment: 4.0100% N/A 08/01/2022 400,000.00 09/01/2007 4.0100% N/A 08/01/2023 420,000.00 Sale Type: 4.0100% N/A 08/01/2024 435,000.00 BE 4.0100% N/A 08/01/2025 455,000.00 1st Coupon Date: 4.0100% N/A 08/01/2026 470,000.00 8300,000 4.0100% N/A 0210112021 8325,000 0210112022 8340.000 $4,615,000.00 Call Option: Bonds maturing on 08/01/2018 to 08/01/2026 callable in whole or in part on any date beginning 08/01/2017 @ par. GO Bds Ser 2007 on 0210112027: Tax Treatment: Tax Exempt Original Issue Amount $6,000,000.00 Dated Date: 09/01/2007 Sale Date: 09/04/2007 Delivery Date: 09/24/2007 Sale Type: Private Placement Record Date: MSRB Bond Form: BE Denomination $100,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 02/01/2008 Paying Agent: The Bank of New York Mellon Trust Company, N.A., Houston, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Purchaser: JPMorgan Chase Bank, N.A. Use of Proceeds: Recreational Facilities, Streets & Sidewalks, Drainage. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/20277 4,040,000.00 4.0700% N/A $4,040,000.00 Call Option: Term bonds maturing on 0210112027 callable in whole or in part on any date @ par plus a Prepayment Fee as specified in the Indenture. Term Call: Term bonds maturing on 0210112027: Mandatory Redemption Date Principal Amount 02/01/2008 $190.000 02/01/2009 $285,000 0210112010 $250,000 0210112011 8275,000 02/01/2012 8225,000 02/01/2013 8235,000 0210112014 8245,000 0210112015 8255.000 0210112016 8265,000 0210112017 8280,000 02/01/2018 8290,000 02/01/2019 8300,000 0210112020 8315,000 0210112021 8325,000 0210112022 8340.000 0210112023 8355,000 0210112024 8370,000 02/01/2025 8385,000 0210112026 8400,000 0210112027 8415,000 GO Bds Ser 2008 Tax Treatment: Bank Qualified Original Issue Amount $9,900,000.00 Dated Date: 08/01/2008 Sale Date: 08/12/2008 Delivery Date: 09/10/2008 ,; i Texas Municipal Reports Fe F (General Obligation Debt) Last Revised: 10/20/2016 2302 ,f- Guadalupe, Comal, Bexar Counties Page 3 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: 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/2016 440,000.00 4.1300% N/A 0210112017 460,000.00 4.1300% N/A 02/01/2018 475,000.00 4.1300% N/A 02/01/2019 500,000.00 4.1300% N/A 0210112020 520,000.00 4.1300% N/A 0210112021 540,000.00 4.1300% N/A 0210112022 565,000.00 4.1300% N/A 02/01/2023 585,000.00 4.1300% N/A 0210112024 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 $7,410,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/2909 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) 15.94% Use of Proceeds: Streets, Refunding, Recreational Facilities. Refunding Notes: This issue defeased mty(s) 2/1/2010- 2/1/2018 of GO Bds Per 98 @ par. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2016 540,000.00 3.0000% 2.880% 0210112017 550,000.00 3.0000% 3.160% 02/01/2018 550,000.00 3.2500% 3.340% 02/01/2019 210,000.00 3.5000% 3.510% 02/01/2020 250,000.00 3.7500% 3.760% 02/01/2022T 350,000.00 4.0500% 4.060% 02/01/20247 390,000.00 4.2500% 100.00% 02/01/20287 1,160,000.00 4.5000% 4.600% 02/01/20337 2,555,000.00 5.5000% 4.700% $6,555,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 02/01/2023 $175,000 02/01/2024 $215.000 Term bonds maturing on 0210112028: Mandatory Redemption Date Principal Amount 02/01/2025 $200,000 02/01/2026 $210,000 0210112027 $220,000 02/01/2028 $530,000 Term bonds maturing on 02/01/2033: Mandatory Redemption Date Principal Amount 0210112029 $455,000 02/01/2030 $480,000 02/01/2031 $510,000 02/01/2032 $540,000 02/01/2033 $570.000 GO Ref Bds Ser 2010 275,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/112021 of Comb Tax & Ltd Pledge Rev C/O Ser 2001 @ par. Orig Reoffering Maturity Amount Coupon Price /Yield 0210112016 275,000.00 3.0000% 1.850% 0210112017 285,000.00 3.0000% 2.150% 02/01/2018 285,000.00 3.0000% 2.400% 02/01/2019 300.000.00 3.0000% 2.650% 0210112020 310,000.00 4.0000% 2.850% 02/01/2021 320,000.00 4.0000% 3.020% $1375.000.00 Call Option: Bonds maturing on 02/01/2019 to 0210112021 callable in whole or in part on any date beginning 02/01/2018 @ par. j 4 , >, 1- ., .. , . ... 'le, P b ,; i Texas Municipal Reports '_' F (General Obligation Debt) Last Revised: 10/20/2016 2302 ,f- Guadalupe, Comal, Bexar Counties Page 4 of 13 GO Bds Ser 2011 06/01/2011 Tax Treatment: Tax Exempt Original Issue Amount $8,250,000.00 Dated Date: 03/01/2011 Sale Date: 03/29/2011 Delivery Date: 04/26/2011 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5.000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 0210112012 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Lead Manager: SAMCO Capital Markets, Inc. Co- Manager: Piper Jaffray & Co. Use of Proceeds: Sports Complex, Aquatic Center, Animal Shelter Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2016 225,000.00 0210112017 235,000.00 02/01/2018 240,000.00 02/01/2019 250,000.00 0210112020 260,000.00 0210112021 270,000.00 02/01/2023T 585,000.00 0210112024 315,000.00 0210112025 330,000.00 02/01/2026 345,000.00 02/01/2027 360,000.00 0210112028 375,000.00 02/01/2029 390,000.00 02/01/2030 410,000.00 02/01/2032T 885,000.00 02/01/2034T 975,000.00 02/O1/2036T 1,080,000.00 -------------------- - - - - -- 3.0000% 3.0000% 3.5000% 3.5000% 4.0000% 5.0000% 5.5000% 4.0000% 4.1250% 4.2500% 4.3750% 4.5000% 4.6250% 4.7500% 5.0000% 5.0000% 5.0000% 2.070% 2.410% 2.730% 3.010% 3.300% 3.500% 3.900% 4.130% 4.260% 4.400% 4.500% 4.610% 4.720% 4.800% 100.00% 5.050% 5.110% --- - - - - -- $7,530,000.00 Call Option: Bonds maturing on 0210112024 to 0210112030 and term bonds maturing on 02/01/2023 and 0210112032 and 02/01/2034 and 02/01/2036 callable in whole or in part on any date beginning 0210112021 @ par. Term Call: Term bonds maturing on 02/01/2023: Mandatory Redemption Date Principal Amount 0210112022 $285.000 0210112023 $300,000 Term bonds maturing on 0210112032: Mandatory Redemption Date Principal Amount 02/01/2031 $430,000 02/01/2032 $455,000 Term bonds maturing on 02/01/2034: Mandatory Redemption Date Principal Amount 02/01/2033 $475,000 02/01/2034 $500,000 Term bonds maturing on 02/01/2036: Mandatory Redemption Date Principal Amount 02/01/2035 $525,000 02/01/2036 $555.000 GO Ref Bds Ser 2011 Tax Treatment: Tax Exempt Original Issue Amount $2,675,000.00 Dated Date: 06/01/2011 Sale Date: 06/07/2011 Delivery Date: 06/30/2011 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 09/01, 03/01 lst Coupon Date: 03/01/2012 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Lead Manager: SAMCO Capital Markets, Inc. Water & Sewer 100.00% Use of Proceeds: Refunding. Refunding Notes: This issue defeased mty(s) 9/1/2012 - 911/2021 of Util Sys Rev & Ref Bds Ser 2001 @ par. Orig Reoffering Maturity Amount Coupon Price /Yield 09/01/2016 300.000.00 Tax Exempt 2.0000% 1.700% 09/01/2017 300.000.00 Sale Date: 2.0000% 2.100% 09/01/2018 225.000.00 Private Placement 2.2500% 2.450% 09/01/2019 230,000.00 Denomination 2.5000% 2.750% 09/01/2020 235,000.00 0210112012 2.7500% 3.000% 09/01/2021 240,000.00 3.0000% 3.200% $1,530,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 lot Coupon Date: 0210112012 Paying Agent: Compass Bank, Houston, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Purchaser: Compass Mortgage Corporation, Houston, TX Use of Proceeds: Refunding. Refunding Notes: This issue defeased mty(s) 2/1/2014- 2/1/2018 of Comb Tax & Ltd Pledge Rev C/O Ser 2003 @ par. This issue defeased mty(s) 02/01/2014- 02/01/2022, 0210112024 of Comb Tax & Ltd Pledge Rev C/O Ser 2004 @ par. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2016 605,000.00 23300% N/A 0210112017 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 . . ,. .. a .. ... f.. ... _ n A. a �.t ".. K ,, .rr .,, .. 'tzf" or" : d if .1 .. ,, r, el: f,"' ,; i Texas Municipal Reports Fe E (General Obligation Debt) Last Revised: 10/20/2016 2302 ,f- Guadalupe, Comal, Bexar Counties Page 5 of 13 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 Denomination $5,000 Interest pays $5,310,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 310,000.00 Tax Treatment: Tax Exempt Original Issue Amount $7,625,000.00 Dated Date: 08/01/2012 Sale Date: 08/28/2012 Delivery Date_ 09/13/2012 Sale Type: Competitive TIC: 2.8627% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 02/01/2013 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski L.L.P. Financial Advisor: Southwest Securities, San Antonio, TX Lead Manager: Hutchinson Shockey Erley & Co. Use of Proceeds: Aquatic Center, Sports Complex, Downtown Area, Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2016 310,000.00 3.8750% 0.800% 02/01/2017 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% 02/01/2023 385,000.00 2.2500% 2.400% 02/01/2024 390,000.00 2.5000% 2.600% 02/01/2025 400,000.00 2.7000% 2.750% 02/01/2026 415,000.00 2.8000% 2.900% 02/01/2028T 865,000.00 3.0000% 3.100% 02/01/2030T 915,000.00 3.0000% 3.160% 02/01/2032T 975,000.00 3.1000% 3.240% - $6.750.000.00 Call Option: Bonds maturing on 0210112023 to 02/01/2026 and term bonds maturing on 02/01/2028 and 0210112030 and 0210112032 callable in whole or in part on any date beginning 02/01/2022 @ 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 02/01/2030 $465,000 Term bonds maturing on 0210112032: Mandatory Redemption Date Principal Amount 02/01/2031 $480,000 0210112032 $495.000 Tax Notes Ser 2013 Pledge Rev C/O 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 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: BOKF, N.A., Austin, 1X 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 0210112016 170,000.00 1.0000% 100.00% 0210112017 170,000.00 1.3000% 100.00% 02/01/2018 170,000.00 1.7000% 100.00% $510,000.00 Call Option: Non Callable Tax Notes Ser 2013A Pledge Rev C/O Ser 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, NO Bond Counsel: Fulbright & Jaworski LLP Financial Advisor: Southwest Securities, San Antonio, TX Purchaser: Branch Banking & Trust Company, Charlotte, NC Use of Proceeds: Public Safety. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2016 160,000.00 1.3000% N/A 0210112017 160,000.00 1.3000% N/A 02/01/2018 165,000.00 1.3000% N/A $485,000.00 Call Option: Bonds maturing on 0210112016 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/10/2013 Delivery Date: 10/10/2013 Sale Type: Competitive TIC: 3.1347% Cl s , r r, °" ,; i Texas Municipal Reports Fe F (General Obligation Debt) Last Revised: 10/20/2016 2302 ,f- Guadalupe, Comal, Bexar Counties Page 6 of 13 Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 02/01/2014 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Fulbright & Jaworski LLP Financial Advisor: Southwest Securities, San Antonio, TX Lead Manager: First Southwest Company Security : Limited Tax and a Subordinate lien on the Net revenues of the Utility system anticipated to be $1,000. Water & Sewer 100.00% Use of Proceeds: Public Improvements. Orig Reoffering Maturity Amount Coupon Price /Yield 0210112016 240,000.00 2.0000% 0.750% Bank Qualified 0210112017 380,000.00 2.0000% 1.000% 09/01/2013 02/01/2018 390,000.00 2.0000% 1.350% 10/10/2013 02/01/2019 395,000.00 2.2500% 1.600% MSRB 0210112020 405,000.00 2.5000% 1.900% $100,000 0210112021 415,000.00 3.0000% 2.180% 02/01/2014 0210112022 155,000.00 3.0000% 2.350% Par 0210112023 160,000.00 3.0000% 2.550% Par 0210112024 165,000.00 3.5000% 2.700% 0210112023 02/01/2025 170,000.00 3.5000% 2.850% N/A 02/01/2026 175,000.00 3.5000% 3.000% 2.5800% 02/01/2028T 375,000.00 4.0000% 3.400% 02/01/2030T 405,000.00 4.0000% 3.800% 02/01/2033T 670,000.00 4.0000% 4.150% $4,500,000.00 Call Option: Bonds maturing on 02/01/2023 to 02/01/2026 and term bonds maturing on 02/01/2028 and 02/01/2030 and 02/01/2033 callable in whole or in part on any date beginning 0210112022 @ par. Term Call: Term bonds maturing on 02/01/2028: Mandatory Redemption Date Principal Amount 0210112027 $185,000 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 Mat Date Tax Treatment: Bank Qualified Original Issue Amount $2,160,000.00 Dated Date: 09/01/2013 Sale Date: 09/10/2013 Delivery Date: 10/10/2013 Sale Type: Private Placement Record Date: MSRB Bond Form: 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. Refunding Notes: This bond refunded maturities from the following issues Comb Tax & Subord Lien Rev C/O Ser 2005 Refunded Amount Mat Date Sched Call Price 155,000 02/01/2015 0210112014 Par 325,000 0210112017 0210112014 Par 170,000 02/01/2018 0210112014 Par 180,000 02/01/2019 0210112014 Par 185,000 0210112020 02/01/2014 Par 195,000 0210112021 0210112014 Par 860.000 02/01/2025 0210112014 Par Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2016 175,000.00 Tax Treatment: 2.5800% N/A 0210112017 180,000.00 05/15/2014 2.5800% N/A 02/01/2018 180,000.00 Sale Type: 2.5800% N/A 02/01/2019 190,000.00 BE 2.5800% N/A 0210112020 190.000.00 1st Coupon Date: 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,955,000.00 Call Option: Bonds maturing on 0210112024 to 0210112025 callable in whole or in part on any date beginning 0210112023 @ par. GO Ref Bds Ser 2014 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 Co- Purchaser: Frost Bank Lead Manager: SAMCO Capital Markets, Inc. Underwriter's Counsel: McCall Parkhurst & Horton L.L.P. Use of Proceeds: Refunding Refunding Notes: This bond refunded maturities from the following issues: GO Bds Ser 2006 Refunded Amount Mat Date Coupon Price Sched Call 1,540,000.00 0210112023 5.250 Par 02/01/2016 1,715.000.00 02/01/2025 5.250 Par 02/01/2016 1,900.000.00 0210112027 5.250 Par 0210112016 3.220.000.00* 02/01/2031 4.625 Par 0210112016 * Partial Maturity ,, n " �, ,; i Texas Municipal Reports '_' F (General Obligation Debt) Last Revised: 10/20/2016 2302 ,f- Guadalupe, Comal, Bexar Counties Page 7 of 13 Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2016 100,000.00 2.0000% 0.450% 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% 0210112021 100,000.00 3.0000% 1.750% 0210112022 750,000.00 3.0000% 1.900% 02/01/2023 775,000.00 3.0000% 2.050% 0210112024 800,000.00 3.5000% 2.200% 02/01/2025 830,000.00 3.5000% 2.400% 02/01/2026 860,000.00 3.5000% 2.500% 0210112027 890,000.00 4.0000% 2.550% 02/01/2028 930,000.00 4.0000% 2.650% 02/01/2029 960,000.00 4.0000% 2.750% 02/01/2030 1,005,000.00 3.5000% 3.100% $8,400,000.00 Call Option: Bonds maturing on 0210112024 to 0210112030 callable in whole or in part on any date beginning 0210112023 @ par. Tax Notes Ser 2015 315,000.00 Tax Treatment: Tax Exempt Original Issue Amount $2,125,000.00 Dated Date: 12/01/2014 Sale Date: 12/16/2014 Delivery Date: 01/08/2015 Sale Type: Private Placement Record Date: MSRB Bond Form: 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.08% EMS Building 43.39% Drainage 36.92% Use of Proceeds: Public Works. Orig Reoffering Maturity Amount Coupon Price /Yield 08/01/2016 315,000.00 1.7500% N/A 08/01/2017 330,000.00 1.7500% N/A 08/01/2018 335.000.00 1.7500% N/A 08/01/2019 340,000.00 1.7500% N/A 08/01/2020 345,000.00 1.7500% N/A 08/01/2021 190,000.00 1.7500% N/A N/A 0810112021 150,000.00 $1,855,000.00 Call Option: Non Callable Tax Notes Ser 2015A Tax Treatment: Tax Exempt Original Issue Amount $1,020,000.00 Dated Date: 10/15/2015 Sale Date: 1007/2015 Delivery Date: 11/19/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/2016 Paying Agent: First National Bank Texas, Killeen, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, San Antonio, TX Purchaser: First National Bank Texas Use of Proceeds: Fire Truck. Orig Reoffering Maturity Amount Coupon Price /Yield 08/01/2016 125,000.00 Tax Treatment: 1.5400% N/A 08/01/2017 145,000.00 11/01/2015 1.5400% N/A 08/01/2018 145,000.00 Sale Type: 1.5400% N/A 08/01/2019 150,000.00 MSRB 1.5400% N/A 08/01/2020 150,000.00 Interest pays 1.5400% N/A 0810112021 150,000.00 1.5400% N/A 0810112022 155,000.00 1.5400% N/A $1,020,000.00 Call Option: Non Callable GO Ref Bds Ser 2015 80,000.00 Tax Treatment: Tax Exempt Original Issue Amount $4,185,000.00 Dated Date: 11/01/2015 Sale Date: 11/17/2015 Delivery Date: 12/15/2015 Sale Type: Competitive TIC: 2.6015% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 02/01/2016 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: BOSC, Inc. Use of Proceeds: Refunding. Refunding Notes: This bond refunded maturities from the following issues: GO Bds Ser 2006 Refunded Amount Mat Date Coupon Price Sched Call 425,000.00 02/01/2017 4.125 Par 02/01/2016 475,000.00 02/01/2018 4.200 Par 02/01/2016 655,000.00 02/01/2019 4.300 Par 02/01/2016 685,000.00 0210112020 4.375 Par 0210112016 715,000.00 0210112021 4.400 Par 0210112016 1,175,000.00 ** 02/01/2031 4.625 Par 02/01/2016 ** Remainder prig Reoffering Maturity Amount Coupon Price /Yield 0210112016 80,000.00 2.0000% 0.240% 02/01/2017 450,000.00 2.0000% 0.600% 02/01/2018 490,000.00 2.0000% 0.940% 02/01/2019 660.000.00 2.0000% 1.150% 0210112020 675,000.00 2.5000% 1.360% 0210112021 690,000.00 3.0000% 1.550% 02/01/2031 1.140.000.00 3.2500% 3.400% $4,185,000.00 i',:r , . qir v , t . _.. ,; i Texas Municipal Reports '_' (General Obligation Debt) Last Revised: 10/20/2016 2302 ,f- Guadalupe, Comal, Bexar Counties Page 8 of 13 Call Option: Bonds maturing on 02/01/2031 callable in whole or in part on any date beginning 02/01/2025 @ par. Comb Tax & Ltd Pledge Rev 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 tat Coupon Date: 0210112017 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Fidelity Capital Markets Co- Manager: City Securities Co- Manager: Jefferies LLC Co- Manager: Morgan Stanley Co- Manager: Raymond James 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 4.0000% 0.600% 02/01/2018 165,000.00 4.0000% 0.740% 02/01/2019 175,000.00 4.0000% 0.840% 0210112020 180,000.00 4.0000% 0.980% 0210112021 190.000.00 4.0000% 1.070% 0210112022 195,000.00 4.0000% 1.240% 02/01/2023 205,000.00 4.0000% 1.400% 0210112024 70,000.00 3.0000% 1.530% 02/01/2025 75,000.00 3.0000% 1.670% 02/01/2026 75,000.00 3.0000% 1.820% 0210112027 80,000.00 2.0000% 2.020% 02/01/2028 80.000.00 2.0000% 2.150% 02/01/2029 80,000.00 2.1250% 2.300% 02/01/2030 85,000.00 2.2500% 2.400% 02/01/2031 85,000.00 2.3750% 2.500% 02/01/2032 90,000.00 2.3750% 2.600% 02/01/2033 90,000.00 2.5000% 2.650% 02/01/2036T 285,000.00 3.0000% 100.00% $2.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 02/01/2034 $90,000 02/01/2035 $95,000 02/01/2036 $100,000 $285,000 Comb Tax & Ltd Pledge Rev C/O Taxable Ser 2016B Tax Treatment: Taxable Original Issue Amount $1,475,000.00 Dated Date: 08/01/2016 Sale Date: 08/02/2016 Delivery Date: 09/01/2016 Sale Type: Competitive TIC: 3.1726% Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi - Annually: 08/01, 02101 1st Coupon Date: 0210112017 Paying Agent: BOKF, N.A., Austin, TX Bond Counsel: Norton Rose Fulbright US LLP, San Antonio, TX Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Robert W. Baird & Co., Inc. Co- Manager: Alamo Capital Co- Manager: CL King & Associates Co- Manager: Crews & Associates, Inc. Co- Manager: Cronin & Co. Co- Manager: Davenport & Co. LLC Co- Manager: Duncan - Williams, Inc. Co- Manager: Edward Jones Co- Manager: First Empire Securities Co- Manager: FMSbonds, Inc. Co- Manager: FTN Financial Co- Manager: IFS Securities, Inc. Co- Manager: Isaak Bond Co- Manager: Loop Capital Markets LLC Co- Manager: Midland Securities, Ltd Co- Manager: Oppenheimer & Co. Inc. Co- Manager: R. Seelaus & Co., Inc. Co- Manager: Rafferty Capital Markets, LLC Co- Manager: Ross, Sinclaire & Associates, Inc. Co- Manager: Sierra Pacific Co- Manager: SumRidge Partners, LLC Co- Manager: W. H. Me]] Associates, Inc Co- Manager: Wayne Hummer Investments Co- Manager: Wedbush Morgan Securities Co- Manager: WNJ Capital Security : Limited Tax and a Subordinate lien on the Net revenues of the Utility system. Use of Proceeds: Aquatic Center. Orig Reoffering Maturity Amount Coupon Price /Yield 0210112017 55,000.00 3.0000% 1.000% 02/01/2018 55.000.00 10000% 1.100% 02/01/2019 55,000.00 3.0000% 1.250% 0210112020 60,000.00 3.0000% 1.450% 0210112021 60,000.00 3.0000% 1.650% 0210112022 60,000.00 3.0000% 1.800% 0210112023 65.000.00 3.0000% 2.000% 0210112024 65,000.00 10000% 2.200% 02/01/2025 70.000.00 10000% 2.350% 02/01/2026 70,000.00 3.0000% 2.500% 02/01/20317 395,000.00 3.5000% 2.800% 02/01/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 pars; on any date beginning 0210112026 @ par. Term Call: Term bonds maturing on 02/01/2031 subject to mandatory redemption as follows: Redemption Date Principal Amount 0210112027 $75,000 02/01/2028 $75,000 ic,.. ,. x„ _ . ., ,. r a .. , a v .. ,,.a. , r ,1 -, �: x., ,of .. ,.. .. , . ,; i Texas Municipal Reports Fe X (General Obligation Debt) Last Revised: 10/20/2016 2302 ,f- Guadalupe, Comal, Bexar Counties Page 9 of 13 02/01/2029 02/01/2030 02/01/2031 $80,000 $80,000 $85,000 $395.000 Term bonds maturing on 02/01/2036 subject to mandatory redemption as follows Redemption Date Principal Amount 0210112032 $85,000 02/01/2033 $90,000 02/01/2034 $95,000 02/01/2035 $95,000 02/01/2036 $100.000 $465,000 GO Bds Ser 2016 5,380,000.00 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 02/01/2017 02/01/2018 02/01/2019 02/01/2020 02/01/2021 02/01/2022 02/01/2023 02/01/2024 02/01/2025 02/01/2026 02/01/2027 02/01/2028 02/01/2029 02/01/2030 02/01/2031 02/01/2032 02/01/2033 02/01/20367 405,000.00 205,000.00 215,000.00 225,000.00 235,000.00 245,000.00 255,000.00 265,000.00 275.000.00 285,000.00 295,000.00 300,000.00 305,000.00 310,000.00 320,000.00 330.000.00 335,000.00 1.075.000.00 2.0000% 0.650% 4.0000% 0.7408 4.0000% 0.840% 4.0000% 0.980% 4.0000% 1.070% 4.0000% 1.240% 4.0000% 1.400% 4.0000% 1. 530% 4.0000% 1.6708 4.0000% 1.820% 2.0000% 2.020% 2.0000% 2.150% 2.1250% 2.300% 2.2500% 2.400% 2.3750% 2.500% 2.5000% 2.6008 3.0000% 2.700% 3.0000% 100.00% - $5.880.000.00 Call Option: Bonds maturing on 02/01/2027 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 02/01/2034 02/01/2035 02/01/2036 Principal Amount $345,000 $360,000 $370,000 $1,075,000 Grand Total _ ______________> $78,555,000.00 Bond Debt Service Period Ending Principal Interest Debt Service 09/30/16 5,380,000.00 06.85% 2,288,738.10 09/30/2017 7,668,738.10 09/30/1.7 5,925,000.00 09/30/2018 2,462,938.50 21.74% 8,387,938.50 09/30/18 5,775,000.00 28.43% 2,297,640.50 09/30/2020 8,072,640.50 09/30/19 5,255,000.00 09/30/2021 2,138,563.50 42.14% 7,393,563.50 09/30/20 5,420,000.00 47.95% 1,978,072.50 09/30/2023 7,398.072.50 09/30/21 5,350,000.00 09/30/2024 1,801,937.50 59.58% 7,151,937.50 09/30/22 4,560,000.00 64.73% 1,630,114.00 09/30/2026 6,190,114.00 09/30/23 4,560,000.00 09/30/2027 1,473,766.75 74.41% 6,033,766.75 09/30/24 4,575,000.00 79.04% 1,316,067.25 09/30/2029 5,891,067.25 09/30/25 4,045,000.00 09/30/2030 1,162,373.50 86.63% 5,207,373.50 09/30/26 3,970,000.00 90.78% 1,012,696.50 09/30/2032 4,982,696.50 09/30/27 3,635,000.00 09/30/2033 859,667.25 95.89% 4,494,667.25 09/30/28 3,640,000.00 97.20% 721,868.00 09/30/2035 4,361,868.00 09/30/29 2,920,000.00 09/30/2036 595,553.13 100.00% 3,515,553.13 09/30/30 3,040,000.00 481,137.50 3,521,137.50 09/30/31 3,265,000.00 362,356.88 3,627,356.88 09/30/32 2,220,000.00 255,835.00 2,4/5,835.00 09/30/33 1,790,000.00 170,662.50 1,960,662.50 09/30/34 1,030,000.00 109,868.75 1,139.868.75 09/30/35 1,075,000.00 67,331.25 1,142,331.25 09/30/36 1,125,000.00 22,800.00 1,147,800.00 78.555.000.00 23.209.988.85 101.764.988.85 COMPUTED ON BASIS OF MANDATORY REDEMPTION Debt Amortization Rates % of Principal Period Ending Principal Retired 09/30/2016 5,380,000.00 06.85% 09/30/2017 5,925,000.00 14.39% 09/30/2018 5,775,000.00 21.74% 09/30/2019 5,255,000.00 28.43% 09/30/2020 5,420,000.00 35.33% 09/30/2021 5,350,000.00 42.14% 09/30/2022 4,560,000.00 47.95% 09/30/2023 4,560,000.00 53.75% 09/30/2024 4,575,000.00 59.58% 09/30/2025 4,045,000.00 64.73% 09/30/2026 3,970,000.00 69.78% 09/30/2027 3,635,000.00 74.41% 09/30/2028 3,640,000.00 79.04% 09/30/2029 2,920,000.00 82.76% 09/30/2030 3,040,000.00 86.63% 09/30/2031 3,265,000.00 90.78% 09/30/2032 2,220,000.00 93.61% 09/30/2033 1,790,000.00 95.89% 09/30/2034 1,030,000.00 97.20% 09/30/2035 1,075,000.00 98.57% 09/30/2036 1.125.000.00 100.00% , r ;a " �, Schertz, City Texas Municipal Reports ,_' I (General Obligation Debt) Last Revised: 10/20/2016 2302 ,f- Guadalupe, Comal, Bexar Counties Page 10 of 13 G.O. Debt Service Requirements for fiscal year- ending 09/30/2016 I &S Fos all G.O. issues 09/30/2015 2015 I &S Fund Tax Levy @ 90% Economic Development Corp (Type B) Water & Sewer EMS Building Drainage ECONOMIC DEVELOPMENT CORPORATION Total Revenues $3,458,758 Expenses: Economic Development Debt Service Other Total Expenses Excess (Deficiency) of Revenues Over (Under) Expenditures SCHERTZ EMS $7,668,738 $847,178 5,355,267 1.93,046 1,740,442 150,763 128.283 Fiscal Year Ended 09 -30 -2014 09 -30 -2013 09 -30 -2012 $3,521,338 $3,215,620 $2,659,194 9,599 8,821 9,195 0 0 16,848 $3,530,937 $3,224,441 $2,685,237 $279,980 $565,322 $572,880 $918,928 430,609 427,671 428,504 428,329 351,812 519,831 197,859 0 $1,062,401 $1,512,824 $1,199,243 $1,347,257 $2,396,357 $2,018,113 $2,025,198 $1,337,980 09 -30 -2015 Fees & Charges $4,416,140 Expenses $4,467,869 Excess (Deficiency) of Revenues Over (Under) Expenditures ($51,729) f_A1ji:[i1 41"A4E7.1111111111 il Ib*13114 Fiscal Year Ended 09 -30 -2014 09 -30 -2013 09 -30 -2012 $4,533,828 $4,459,945 $3,561J83 $4.056.994 $3.802.397 $3.611.004 $476,834 $657,548 ($49,221) GENERAL OBLIGATION BONDS AUTHORIZED BUT UNISSUED Election 09 -30 -2015 Revenues: Issued Taxes $3,442,819 Interest 14,461 Other 1.478 Total Revenues $3,458,758 Expenses: Economic Development Debt Service Other Total Expenses Excess (Deficiency) of Revenues Over (Under) Expenditures SCHERTZ EMS $7,668,738 $847,178 5,355,267 1.93,046 1,740,442 150,763 128.283 Fiscal Year Ended 09 -30 -2014 09 -30 -2013 09 -30 -2012 $3,521,338 $3,215,620 $2,659,194 9,599 8,821 9,195 0 0 16,848 $3,530,937 $3,224,441 $2,685,237 $279,980 $565,322 $572,880 $918,928 430,609 427,671 428,504 428,329 351,812 519,831 197,859 0 $1,062,401 $1,512,824 $1,199,243 $1,347,257 $2,396,357 $2,018,113 $2,025,198 $1,337,980 09 -30 -2015 Fees & Charges $4,416,140 Expenses $4,467,869 Excess (Deficiency) of Revenues Over (Under) Expenditures ($51,729) f_A1ji:[i1 41"A4E7.1111111111 il Ib*13114 Fiscal Year Ended 09 -30 -2014 09 -30 -2013 09 -30 -2012 $4,533,828 $4,459,945 $3,561J83 $4.056.994 $3.802.397 $3.611.004 $476,834 $657,548 ($49,221) 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 Pub Saftey 8,000,000 4,000,000 4,000,000 Total: $15,000,000 $6,000,000 *$9,000,000 * Excludes authorizations from the following election propositions(s) because the remaining authorization is deemed too small or too old: 12/16/1961- $14,000 Sewer Imprs 07/18/1970- $250,000 Sewer Imprs 08/09/1997- $595 Fire Station 08/09/1997- $330 EMS Building 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 (TORS) 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 $16,309,269 $15,389,154 (Unfunded) /Overfunded Liability as a % of Covered Payroll (96.76)% (97.66)% 2015 Source: Texas Municipal Retirement System 12/31/2015 CAFR 2014 Source: City of Schertz 09/30/2015 CAFR SCHEDULE OF CHANGES IN NET PENSION LIABILITY AND RELATED RATIOS 12 -31 -2014 Pension Liability - Beginning $45,615,815 Pension Liability - Ending (a) $50,229,051 Contributions Employer $ 2,403,929 Contributions Employee $ 1,077,097 Plan Fiduciary Net Position - Beg $32,179,518 Plan Fiduciary Net Position - End (b) $36,412,844 Net Pension Liability (a) - (b) (Pension Liab - Fiduciary Position) $13,816,207 Plan Fiduciary Net Position as a % of Total Pension Liability 72.49 .e l t ( ,�l` Schertz, City Texas Municipal Reports (General Obligation Debt) Last Revised: 10/20/2016 2302 ,f- Guadalupe, Comal, Bexar Counties Page 11 of 13 Covered Employee Payroll $15,389,154 Net Pension Liability as a % of Covered Payroll 89.78 Membership data for the pension plans are as follows: Inactive employees or beneficiaries currently receiving benefits 67 Inactive employees entitled to but not yet receiving benefits 133 Active employees 302 Total 502 Source: City of Schertz CAFR 9 -30 -2015. POST EMPLOYMENT HEALTH BENEFITS: GASB STATEMENT 45 GARB released the Statement of Governmental Accounting Standards No. 45 (GARB 45), Accounting and Financial Reporting by Employers for Post Employment Benefits Other Than Pensions (OPEB). in June 2004. The City has implemented GASB 45 for the fiscal year ending September 30, 2014. GASB 45 sets forth standards for measurement, recognition, and display of post- employment benefits, other than pensions, such as health and life insurance for current and future retirees. Fiscal Year Annual OPEB Cost % of Annual OPEB Net OPEB Year Costs Contributed Cost Contributed Obligation 2013 $77,014 $13,248 17% $299,038 2014 79,512 13,645 17% 364,905 2015 79.728 15.485 19% 63,766 As of December 31, 2014, the most recent actuarial valuation date, the actuarial accrued liability for benefits was $493,114, and the actuarial value of assets was $0, resulting in an unfunded actuarial accrued liability of $493,114 . The covered payroll was $14,365,845 and the ratio of the UAAL to the covered payroll was 3.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 (SORE). 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 2015, 2014, and 2013, were $21,681, $20,815, and $21,151, respectively, which equaled the required contributions each year. Source: Source: City of Schertz CAER 9 -30 -2015. NON FUNDED DEBT NON- FUNDED DEBT PAYABLE (As of September 30, 2015) The City reports additional debt in the principal amount of $2,171,095 under Emergency Medical Services and $1,024,001 under Govt Activities as follows: Amount Next Year's Reported Outstanding Requirements Under Compensated Absences $125,035 N/A EMS Fund OPEB* $62,053 N/A EMS Fund Pension Liability $1,984,007 N/A EMS Fund Compensated Absences $932,506 N/A Govt Activities Capital Lease $91,495 $36,230 Govt Activities * See PENSION FUND LIABILITY section for details of this obligation. ESTIMATED OVERLAPPING DEBT STATEMENT Taxing Body Debt Amount As Of %Ovlpg Ovlpg Amt Alamo CCD $405,723,444 02/29/16 0.19 $770,875 Bexar Co 1,351,262,228 09/30/15 0.19 2,567,398 Bexar Cc Fiosp Dist 664,198,424 03/31/16 0.19 1,261,977 Coma] Co 43,030.875 12/31/15 4.75 2,043,967 Comal ISO 596,231,727 08/01/15 6.17 36,787,498 Guadalupe Co 9,000,000 * 09/30/16 21.31 1,917,900 Schertz - Cibolo- Universal 312,981,031 08/31/15 50.56 158,243,209 Total Overlapping Debt: $203,592,823 Schertz, City of 09/30/15 $62,423,319 Total Direct and Overlapping Debt: $266,016,142 Total Direct and Overlapping Debt % of A.V.: 7.08% Total Direct and Overlapping Debt per Capita: $7,025 * Gross Debt 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 - 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 2012 Oil 994,226 BBL 0.57 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 2012 Casinghead 51,255 MCF -30.38 ;x .. . .. "I c Schertz, City Texas Municipal Reports 'IF I (General Obligation Debt) Last Revised: 10/20/2016 2302 ,f- Guadalupe, Comal, Bexar Counties Page 12 of 13 2013 Casinghead 30,277 MCF -40.93 Commercial Truck Leasing 2014 Casinghead 43,544 MCF 4182 4. AL95 Creekside Town Center LP 72,868,540 2.15% 2015 Casinghead 35,184 MCF -19.20 Retail Center 5. US Real Estate LP 58,192,474 1.71% RETAIL SALES & EFFECTIVE BUYING INCOME (The Nielsen Company) Retail Center Year 2014 2013 2012 6. Western Rim Investors 2011 2 LP 33,904,150 1.00% Retail Sales $2.2B $1.5B $1.4B Retail Center Effective Buying Income (EBI) $3.3B $3.OB $2.7B 7. Villas at Sundance I LLC 26,977,530 0.79% County Median Household Income $54,803 $51,246 $46,505 Apartments State Median Household Income $50,464 $48,646 $47,613 8. San Antonio MTA LP 24,394,783 0.72% % of Households with EBI below $25K 8.5 % 9.6 % 11.3 % Mass Transit % of Households with EBI above $25K 71.2 % 73.6 % 70.6 % 9. Augusta Gruene Apartments LP 21,918,970 0.65% Apartments EMPLOYMENT DATA (Texas Workforce Commission) 10. Resolute Health /Family Urgent Care 20,653.050 0.61% 2016 2015 2014 Health Care Employed Earnings Employed Earnings Employed Earnings ---- - - - - -- - - - - -- Isis Q: 37,226 $364.6M 33,204 $328.8M 32,404 $313.2M Total: $541,960,706 15.97% 2nd Q: N/A N/A 33,980 $334.6M 33,259 $318.2M 3rd Q: N/A N/A 34,291 $345.5M 32,677 $322.5M FINANCE CONNECTED OFFICIALS 4th Q: N/A N/A 35,026 $378.OM 33,740 $355.61,`l MAJOR COLLEGES AND UNIVERSITIES: Texas Lutheran University Mayor Michael Carpenter COLLEGES AND UNIVERSITIES 1400 Schertz Parkway Year Total Fall Enrollment Schertz, TX 78154 2015 1 1,373 Phone: 210- 619 -1040 Ext: 1132 2014 1 1,319 Fax 210- 619 -1139 2013 1 1,338 mcarpenter @schertz.com 2012 1 1,317 2011 1 1,415 City Manager 2010 1 1,340 John C. Kessel 2009 1 1,387 1400 Schertz Parkway 2008 1 1,432 Schertz, TX 78154 Phone: 210- 619 -1000 Ext: 1112 TOP 10 EMPLOYERS Fax: 210- 619 1139 jkessel @schertz.com Major Employers(a) # Employees City Secretary Schert /Cibolo /UC ISD 1,810 Brenda Dennis Education 1400 Schertz Parkway Amazon.com 1,073 Schertz, TX 78154 Online Retail Phone: 210 -619 -1030 Ext: 1131 Sysco Central Texas 837 Fax: 21.0- 619 -11.39 Food Distributor bdennis @schertz.com GE Oil Gas 600 Oil & Gas Director of Finance Brandt Engineering 437 Juan F. Santoya Jr. Engineering 1400 Schertz Parkway HVHC 400 Schertz, TX 78154 Supply % Distrubution Service Phone: 210- 619 -1140 Republic Beverage Company 382 Fax: 210 -619 -1149 Beverage Services jsantoya @schertz.com HER Grocery Co. 350 Retail Assistant Director of Finance City of Schertz 341 James Walters Government 1400 Schertz Parkway Wal -Mart Stores 323 Schertz, TX 781,54 Retail Phone: 210 -619 -1140 Fax: 210 -619 -1149 jwalters @schertz.com (a) Source: City of Schertz CAFR dated September 30, 2015. Tax Assessor /Collector TOPIOTAXPAYERS Tavie Murphy RTA Guadalupe County Tax Office Principal Taxpayers 2015 A.V. % of A.V. 307 W Court St. Suite 205 1. Central Texas Corridor Hospital Co. LLC $126,908,263 3.74% Seguin, TX 78155 Health Care Phone: 830 - 303 -3421 2. Amazon.com.KYDC LLC 82,416,686 2.43% Fax 830- 372 -9940 Distribution Center tavie@co.guadalupe.tx.us 3. Rush Truck Leasing 73,726,260 2.17% r IA u. { �, , Schertz, City of Texas Municipal Reports Fe @ (General Obligation Debt) Last Revised: 10/20/2016 TIVIR # 2302 Guadalupe, Cornal, Bexar Counties Page 13 of 13 Chief Appraiser Jamie Osborne Guadalupe Appraisal District 3000 N Austin St. Seguin, TX 78155 Phone: 830-303-3313 Fax: 830-372-2874 josborne@guadalupead.org Chief Appraiser Curtis Koehler Comal County Appraisal District 900 S. Seguin Ave. New Braunfels, TX 78131 Phone: 830-625-8597 Fax- 830-625-8598 comalad@co.comal.tx.us Chief Appraiser Michael Amezquita Bexar County Appraisal District 411 N. Frio San Antonio, To 78207 Phone- 210-242-2406 Fax: 210-242-2451 esca@bcad.org 11-1 I"f f�et Uf r f ,; z/ i t Government Corp Texas Municipal Reports 'IC � p I ➢, (chertz & Seguin, Cities of, Project) Last Revised: 3/29/2017 o TMR # 1764 ,- Guadalupe County Page 1 of 6 I�I►T 1�L+� �[����l�11� iii FOR OTHER BONDS FOR THIS ISSUER, SEE SEPARATE MUNICIPAL REPORTS FINANCIAL STATEMENT (As of September 30, 2015)(a) Special Obligation Debt Senior Lien Junior Lien Special Fund Balances I &S Repair & Replacement Reserve $54,065,000 $91,095,000 $145.160,000 $818,083 $500,000 $1,282,806(b) (a) Includes $43,670,000 Contract Revenue Bond, New Series 2016 dated August 1, 2016 and $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, 2005, and 2007. MATERIAL INFORMATION: RATING UPGRADE (As of November 25, 2014) Standard & Poor's Rating Services has raised its long -term and underlying rating to 'A +' from 'A' for the Issuer. The higher ratings reflect the stable service areas that participate in the San Antonio metropolitan area, stabilizing income levels, employment opportunities, and historically strong financial risk for both member cities. Outlook is stable. Details of Senior Lien Debt (Outstanding 913012015) 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 Ist Coupon Date: 08/01/2001 Paying Agent: The Bank of New York Mellon Trust Company, N.A., New York, NY Bond Counsel: Fulbright & Jaworski Financial Advisor: Southwest Securities, San Antonio, TX Co- Financial Advisor: SAMCO Capital Markets Lead Manager: First Southwest Company Co- Manager: Coastal Securities Co- Manager: Dain Rauscher Incorporated Co- Manager: PaineWebber Incorporated Insurance: Assured Guaranty Municipal Corp. (FSA) Use of Proceeds: Utility. Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/20357 10,000,000.00 5.2000% 100.00% $10,000,000.00 Call Option: Non Callable Term Call: Term bonds maturing on 02/01/2035: Mandatory Redemption Date Principal Amount 02/01/2031 $1,795,000 02/01/2032 $1,895,000 02/01/2033 $1,995,000 02/01/2034 $2,100,000 02/01/2035 $2.215.000 Refunded Notes: Maturities refunded by Contract Revenue & Ref Bus Ser 2007 Refunded Amount Mat Date Coupon Price Sched Call 290,000.00 0210112012 4.500 Par 0210112011 305,000.00 02/01/2013 4.625 Par 02/01/2011 310,000.00 02/01/2014 4.700 Par 02/01/2011 325,000.00 02/01/2015 4.800 Par 02/01/2011 340,000.00 02/01/2016 5.000 Par 02/01/2011 350.000.00 02/01/2017 5.000 Par 02/01/2011 375,000.00 02/01/2018 5.000 Par 02/01/2011 390,000.00 02/01/2019 5.125 Par 02/01/2011 410,000.00 02/01/2020 5.125 Par 02/01/2011 10,000,000.00 02/01/2030 5.375 Par 02/01/2011 4,765,000.00 02/01/2037 5.250 Par 02/01/2011 11,185,000.00 02/01/2041 5.250 Par 02/01/2011 Contract Rev Bds Ser 2010 Lien: Senior Tax Treatment: Bank Qualified Original Issue Amount $22.140,000.00 Dated Date: 06/01/2010 Sale Date: 06/15/2010 Delivery Date: 07/14/2010 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 02/01/2011 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: BBC Capital Markets Insurance: Assured Guaranty Municipal Corp. (FSA) Use of Proceeds: Utility. Orig Reoffering Maturity Amount Coupon Price /Yield 0210112016 475,000.00 3.0000% 2.750% 0210112017 485,000.00 3.0000% 3.050% 02/01/2018 505,000.00 15000% 1250% 02/01/2019 520,000.00 3.5000% 3.450% 0210112020 540,000.00 3.5000% 3.650% 0210112021 560,000.00 4.0000% 3.850% 0210112022 585,000.00 4.0000% 3.950% 0210112023 610.000.00 4.0000% 100.00% 0210112024 630,000.00 4.0000% 4.100% 02/01/2025 660,000.00 4.0000% 4.180% 0210112026 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/2041T 3,890,000.00 4.7500% 4.890% Schertz/Seguin Local Government Corp Texas Municipal Reports p I ➢, ( chertz & Seguin, Cities of, Project) Last Revised: 3/29/2017 o q TMR # 1764 ,- Guadalupe County Page 2 of 6 $21,235,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 0210112035: Mandatory Redemption Date Principal Amount 02/01/2033 $930,000 02/01/2034 $975,000 02/01/2035 $1,020,000 Term bonds maturing on 02/01/2038: Mandatory Redemption Date Principal Amount 02/01/2036 $1,070,000 0210112037 $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 02/01/2041 $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 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 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/16/2014 Delivery Date: 10/15/2014 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5,000 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 02/01/2015 Paying Agent: Regions Bank, Houston, TX Bond Counsel: Fulbright & Jaworski LLP Financial Advisor: Southwest Securities, San Antonio, TX Co- Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Raymond James Co- Manager: Allison, M.E. & Co., Inc. Underwriter's Counsel: Andrews Kurth L.L.P. Insurance: Build America Mutual Use of Proceeds: Refunding. Refunding Notes: This bond refunded maturities from the following issues: Contract Rev Ref Bds Ser 2005 Refunded Amount Mat Date Coupon Price Soled 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 02/01/2018 4.000 Par 1012112014 560,000.00 02/01/2019 4.000 Par 1012112014 585,000.00 0210112020 4.100 Par 1012112014 610,000.00 0210112021 4.150 Par 1012112014 635,000.00 0210112022 4.200 Par 1012112014 665.000.00 0210112023 4.250 Par 1012112014 695,000.00 0210112024 4.300 Par 1012112014 725.000.00 02/01/2025 4.375 Par 1012112014 Call Option: Bonds maturing on 0210112023 to 02/01/2025 callable in whole or in part on any date beginning 0210112022 @ par. Contract Rev Imp & Ref Bds New Ser 2015 Lien: Junior Tax Treatment: Tax Exempt Original Issue Amount $41,720,000.00 Dated Date: 1210112014 Sale Date: Orig Reoffering Maturity Amount Sale Type: Coupon Price /Yield 02/01/2016 505,000.00 BE 2.0000% 0.650% 0210112017 520,000.00 2.0000% 0.900% 02/01/2018 530,000.00 2.0000% 1.200% 02/01/2019 540,000.00 2.0000% 1.600% 0210112020 555,000.00 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% 0210112024 630,000.00 3.5000% 2.750% 02/01/2025 655,000.00 15000% 2900% $5.705.000.00 Call Option: Bonds maturing on 0210112023 to 02/01/2025 callable in whole or in part on any date beginning 0210112022 @ par. Contract Rev Imp & Ref Bds New Ser 2015 Lien: Junior Tax Treatment: Tax Exempt Original Issue Amount $41,720,000.00 Dated Date: 1210112014 Sale Date: 12/02/2014 Delivery Date: 01/13/201.5 Sale Type: Negotiated Record Date: MSRB Bond Form: BE Denomination $5.000 Ji a . in ., ,�. "r ._t` , Schertz/Seguin Local Government Corp Texas Municipal Reports p I ➢, (chertz & Seguin, Cities of, Project) Last Revised: 3/29/2017 o TMR # 1764 ,- Guadalupe County Page 3 of 6 Interest pays Semi- Annually: 08/01, 02101 1st Coupon Date: 02/01/2015 Paying Agent: Regions Bank, Houston, TX Bond Counsel: Fulbright & Jaworski LLP Financial Advisor: Southwest Securities, San Antonio, TX Co- Financial Advisor: SAMCO Capital Markets, Inc., San Antonio, TX Lead Manager: Raymond James Co- Manager: Allison, M.E. & Co., Inc. Co- Manager: RBC Capital Markets Underwriter's Counsel: Andrews Kurth L.L.P. Insurance: Build America Mutual 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 02/01/2017 4.000 02/01/2018 4.000 02/01/2019 4.000 0210112020 4.125 02/01/2021 4.250 02/01/2022 4.250 0210112023 4.250 02/01/2024 4.250 02/01/2025 4.250 02/01/2026 4.250 02/01/2030 4.500 02/01/2036 4.500 02/01/2041 4.500 Price Sched Call Par 02/01/2015 Par 02/01/2015 Par 02/01/2015 Par 02/01/2015 Par 0210112015 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 0210112015 Par 02/01/2015 Par 02/01/2015 Orig Reoffering Maturity Amount Coupon Price /Yield 02/01/2016 695,000.00 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 02/01/2023 860,000.00 02/01/2024 900,000.00 02/01/2025 945,000.00 02/01/2026 1,805,000.00 0210112027 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 02/01/2033T 1,650,000.00 02/01/2041T 20,950,000.00 02/01/2044T 1,200,000.00 2.0000% 0.480% 3.0000% 0.810% 3.0000% 1.130% 3.0000% 1.450% 3.0000% 1.760% 4.0000% 2.060% 4.0000% 2.330% 4.0000% 2.560% 5.0000% 2.740% 5.0000% 2.850% 5.0000% 2.930% 5.0000% 3.030% 5.0000% 3.120% 5.0000% 3.180% 5.0000% 3.260% 5.0000% 3.390% 4.0000% 4.062° 4.0000% 4.066% $41.720.000.00 Call Option: Bonds maturing on 02/01/2024 to 0210112030 and term bonds maturing on 02/01/2033 and 0210112041 and 02/01/2044 callable in whole or in part on any date beginning 0210112023 @ par. Term Call: Term bonds maturing on 02/01/2033: Mandatory Redemption Date Principal Amount 0210112031 $520,000 0210112032 $550,000 02/01/2033 $580.000 Term bonds maturing on 0210112041: 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 0210112041 $3,620,000 Term bonds maturing on 02/01/2044: Mandatory Redemption Date Principal Amount 0210112042 $385,000 02/01/2043 $400,000 0210112044 $415,000 Contract Rev Bds New Ser 2016 (Texas Water Development Board SWIRFT Project Financing) Lien: Junior Tax Treatment: Tax Exempt Original Issue Amount $43,670,000.00 Dated Date: 08/01/2016 Sale Date: 10/20/2016 Delivery Date: 11/16/2016 Sale Type: Private Placement Record Date: MSRB Bond Form: BF 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.7800% N/A 08/01/2020 1,240,000.00 0.8600% N/A 08/01/2021 1,250,000.00 ., t 0.9300% N/A 0810112022 1,260,000.00 1.0200% N/A 08/01/2023 1,270,000.00 1.1200% N/A 0810112024 1,285,000.00 1.2300% N/A 08/01/2025 1,300,000.00 1.3200% N/A 08/01/2026 1,315,000.00 1.4100% N/A 08/01/2027 1,335,000.00 1.6100% N/A 08/01/2028 1,350,000.00 1J300% N/A 08/01/2029 1,375,000.00 2.0600% N/A 08/01/2030 1,400,000.00 2.2300% N/A 08/01/2031, 1,430,000.00 2.3400% N/A 08/01/2032 1,465,000.00 2.3900% N/A 08/01/2033 1,500,000.00 2.4500% N/A 08/01/2034 1,535,000.00 2.5800% N/A 08/01/2035 1,575,000.00 2.5600% N/A 08/01/2036 1,615,000.00 2.6000% N/A 08/01/2037 1,660,000.00 2.7800% N/A 08/01/2038 1,705,000.00 2.7800% N/A 08/01/2039 1,755,000.00 2.7800% N/A 08/01/2040 1,805,000.00 2.7800% N/A 08/01/2041 1,855,000.00 2.7800% N/A 08/01/2042 1,910,000.00 11100% 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 „., ti. .. . t ,I .. ., c .. ., t .t' Schertz/Seguin Local Government Corp Texas Municipal Reports ,Is p I ➢, (Schertz & Seguin, Cities of, Project) Last Revised: 3/29/2017 o TMR # 1764 ,- Guadalupe County Page 4 of 6 part inversely on any date beginning 0810112027 @ par. The Bonds are also subject to Special Mandatory redemption as specified in the authorizing resolution. Grand Total _ ______________> $145,160,000.00 Bond Debt Service Period Ending Principal Interest Debt Service 09/30/16 1,675,000.00 3.344,437.50 5,019,437.50 09/30/17 1,705,000.00 4,598,209.25 6,303,209.25 09/30/18 1,790,000.00 5,083,741.00 6,873,741.00 09/30/19 3,040,000.00 5,032,813.50 8,072,813.50 09/30/20 3,110,000.00 4,968,105.50 8,078,105.50 09/30/21 3,165,000.00 4,892,591.50 8,057,591.50 09/30/22 3,260,000.00 4,808,466.50 8,068,466.50 09/30/23 3,350,000.00 4,718,489.50 8,068,489.50 09/30/24 3,445,000.00 4,618,065.50 8,063,065.50 09/30/25 3,560,000.00 4,507,847.50 8,067,847.50 09/30/26 3,805,000.00 4,383,146.88 8,188,146.88 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 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 09/30/32 4,800,000.00 3,387,236.75 8,187,236.75 09/30/33 5,005,000.00 3,181,302.00 8,186,302.00 09/30/34 5,220,000.00 2,967,328.88 8,187,328.88 09/30/35 5,740,000.00 2,744,601.50 8,484,601.50 09/30/36 6,345,000.00 2,516,321.50 8,861,321.50 09/30/37 6,995,000.00 2,278,620.25 9,273,620.25 09/30/38 7,265,000.00 2,012,822.25 9,277,822.25 09/30/39 7,540,000.00 1,736,576.75 9,276,576.75 09/30/40 7,830,000.00 1,449,507.25 9,279,507.25 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 09/30/43 3,755,000.00 815,326.00 4,570,326.00 09/30/44 3,880,000.00 683,982.50 4,563,982.50 09/30/45 3,575,000.00 556,833.00 4,131,833.00 09/30/46 3,690,000.00 434,177.50 4,124,177.50 09/30/47 1,605,000.00 307,522.00 1,912,522.00 09/30/48 1,660,000.00 250,063.00 1,910,063.00 09/30/49 1,715,000.00 190,635.00 1,905,635.00 09/30/50 1,775,000.00 129,238.00 1,904,238.00 09/30/51 1,835,000.00 65,693.00 1,900,693.00 145,160,000.00 98,377,874.50 243,537,874.50 COMPUTED ON BASIS OF MANDATORY REDEMPTION Debt Amortization Rates % of Principal Period Ending Principal Retired 09/30/2016 1,675,000.00 24.69% 01.15% 09/30/2028 09/30/2017 1,705,000.00 02.33% 4,245,000.00 09/30/2018 1,790,000.00 09/30/2030 03.56% 33.46% 09/30/2019 3,040,000.00 4,595,000.00 05.66% 09/30/2020 3,110,000.00 39.94% 07.80% 09/30/2033 09/30/2021 3,165,000.00 09.98% 5,220,000.00 09/30/2022 3,260,000.00 09/30/2035 12.22% 50.93% 09/30/2023 3,350,000.00 6,345,000.00 14.53% 09/30/2024 3,445,000.00 60.12% 16.91% 09/30/2038 09/30/2025 3,560,000.00 19.36% 7,540,000.00 09/30/2026 3,805,000.00 09/30/2040 21.98% 75.72% 09/30/2027 3,935,000.00 24.69% 09/30/2028 4,085,000.00 27.50% 09/30/2029 4,245,000.00 30.43% 09/30/2030 4,405,000.00 33.46% 09/30/2031 4,595,000.00 36.63% 09/30/2032 4,800,000.00 39.94% 09/30/2033 5,005,000.00 43.38% 09/30/2034 5,220,000.00 46.98% 09/30/2035 5,740,000.00 50.93% 09/30/2036 6,345,000.00 55.30% 09/30/2037 6,995,000.00 60.12% 09/30/2038 7,265,000.00 65.13% 09/30/2039 7,540,000.00 70.32% 09/30/2040 7,830,000.00 75.72% 09/30/2041 8,125,000.00 81.31% 09/30/2042 3,635,000.00 83.82% 09/30/2043 3,755,000.00 86.40% 09/30/2044 3,880,000.00 89.08% 09/30/2045 3,575,000.00 91.54% 09/30/2046 3,690,000.00 94.08% 09/30/2047 1,605,000.00 95.19% 09/30/2048 1,660,000.00 96.33% 09/30/2049 1,715,000.00 97.51% 09/30/2050 1,775,000.00 98.74% 09/30/2051 1,835,000.00 100.00% SECURITY The bonds are special limited obligations of the Schertz /Seguin Local Government Corporation payable and secured solely by a junior and inferior lien on and pledge of the Bonds Payment portion of the annual payments to be paid independently by the City of Schertz, Texas and the City of Seguin, Texas. (a proportionate share of 50% each - as an operations and maintenance expense from the gross revenues of such City's utility system as defined in Chapter 1502, as amended, Texas Government Code) to the Corporation pursuant to the Regional Water Supply Contract, dated as of November 15, 1999, among the Corporation and the Cities. The Bonds are also secured by a lien on and pledge of the money in all funds created, established and maintained by a Resolution. PLEDGE For the Series 2016 BP Loan the Corporation pledges and grants to the Texas Water Development Board (TWDB) as security for the payments hereunder, a lien and pledge on the Bond Payment portion of the Annual Payments from the Contract, in such amounts as may be necessary to purchase the FWDB's undivided ownership interest in the Project when, and as required by this Agreement, the Schedules incorporated herein require. RESERVE FUND The Reserve Fund is to accumulate and maintain a reserve for the payment of the outstanding bonds equal to the average annual debt service requirements. After the issuance of the Series 2010 bonds, Required Reserve Fund balance shall be $4,681,081.82. The Reserve Fund is funded with three separate Credit Facilities from, Assured Guaranty Municipal Corporation (Series 2001 and 2005 Bonds) and Ambac Assurance Corporation (Series 2007). The Series 2010 Reserve Requirement was funded with $1,000,000 cash from available Corporation funds and $275,621 from bond proceeds. No debt service reserve fund has been established with respect to the 2016 Bonds. RENEWAL AND REPLACEMENT FUND As additional security for the Bonds, there has been established a Renewal and Replacement Fund. The Renewal and Replacement Fund was initially funded from previously issued bonds in the amount of $500,000, the Emergency amount. RATE COVENANT Pursuant to the Contract, each City is required to pay its proportionate share of the Annual Payments at least equal to (a) the amount required to pay for all Operations and Maintenance Expenses; (b) to pay Overhead Expenses; and (c) the establish and maintain the debt service and the debt service reserve funds for the Priority Bonds and the Renewal and Replacement Fund requirements contained in the Priority Resolution and the Bond Fund for the New Series Bonds. PROJECT Proceeds from the sale of the Bonds will be used for the purpose of t r 3 ,; Schertz/Seguin i t Government Corp Texas Municipal Reports "C p I ➢, (Schertz & Seguin, Cities of, Project) Last Revised: 3/29/2017 o TMR # 1764 ,- Guadalupe County Page 5 of 6 discharge and final payment of obligations of the Issuer, for the purchase of land for the first phase of the Guadalupe Project. The Project includes the construction of a well -field and cross - country pipeline. Construction of twelve wells, the cross - county pipeline, treatment facilities, pumping stations, water storage and gathering lines from the well -field is complete in Gonzales County. This production capacity was designed for the current needs of the Cities. After completion of the construction and with the written consent of the Cities, the Corporation contracted to sell water to the City of Selma, the City of Universal City, and Spring Hill Water Supply Corporation. Additional acreage has been acquired in Guadalupe County since the completion of construction to support expansion of a new well - field. The Corporation obtained the necessary permits and drilled two additional wells in Gonzales County to enable the Corporation to supply the new customers and maintain safe operational abilities. With the addition of the two new wells, the Corporation increased the permitted production to 12,910 acre -feet of water per year. The Corporation is currently operating eight wells, a water treatment plant and transmission facilities with operations personnel provided by the City of Seguin and the City of Schertz on a contractual basis. The Corporation is delivering water to the Cities at a rate that is very competitive when compared to other wholesale water rates in the area and increases in production are expected to continue over time as demand warrants. The Corporation has revised its rate structure to authorize impact fees. The purpose of the fee is to obtain customer contributions toward construction of capital projects and to provide additional funds to be used to pay debt service on the bond similarly secured. With a portion of the Series 2010 bond proceeds the Corporation intends to acquire land and groundwater leases, drill and equip wells #9 -12 which is expected to increase the total permitted capacity of the Corporation to 19,362 acre -feet per year. Proceeds from the 2016 Bonds will be used to provide funds to finance, acquire, and construct treatment facilities, water supply pipelines, booster pumps, other appurtenances, and necessary easements and other interests in land, and pay the costs and expenses of issuing the Bonds, under and in strict conformity with the laws of the State of Texas, particularly the Act, Chapter 1201, Texas Government Code. as amended. the Contract. and the Resolution. SCHERTZ /SEGUIN LOCAL GOVERNMENT CORPORATION of Assets (912,761) -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. 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 �- . a .. .� ' .. . ,. '�' zkw -7 nH r 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,31.2,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 $ 14,551 $ 51,441 $ 51,702 Contribution from Cities of Schertz & Seguin -0- (269,000) (538,000) (538,000) Interest Expense (2,668,447) (3,521,370) (4,334,835) (3,679,231) Gain (Loss) on Disposal of Assets (912,761) -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. 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 �- . a .. .� ' .. . ,. '�' zkw -7 nH r ,; Schertz/Seguin i t Government Corp Texas Municipal Reports Fe � p I ➢, (Schertz & Seguin, Cities of, Project) Last Revised: 3/29/2017 o TMR # 1764 ,- Guadalupe County Page 6 of 6 2013 Casinghead 30,277 MCF -40.93 2014 Casinghead 43,544 MCF 4182 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,28 $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.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 2012 1 1,317 2011 1 1,415 2010 1 1,340 2009 1 1,387 2008 1 1,432 • I1 • 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 Government Corporation P.O. Box 833 Seguin, TX 78156 Phone: 830 -401 -2409 Fax: 830 -401 -2320 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 �..i .rr , . .,, _ Uf ,; 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 ,; Cibolo Creek Municipal ut Texas Municipal Reports _' a O c p (Southern Wastewater Treatment Plant Project) Last Revised: 7/26/2016 TR # 6774 Bexar, Comal, Guadalupe Counties Page 1 of 3 FINANCIAL STATEMENT Mandatory Redemption Date Principal Amount 09/01/2027 $195,000 FOR OTHER BONDS FOR THIS ISSUER, SEE SEPARATE MUNICIPAL REPORTS 09/01/2028 $200,000 FINANCIAL STATEMENT (As of September 30, 2015) Term bonds maturing on 09/01/2030: Mandatory Redemption Date Principal Amount Special Obligation Debt 09/01/2029 $210,000 Senior Lien $6,875,000 09/01/2030 $220,000 PAYMENT RECORD: Cibolo Creek Municipal Authority has never defaulted. Term bonds maturing on 09/01/2032: Mandatory Redemption Date Principal Amount DETAILS OF OUTSTANDING DEBT 09/01/2031 $225,000 09/01/2032 $235,000 Details of Senior Lien Debt (Outstanding 9/30/2015) Term bonds maturing on 09/01/2034: Mandatory Redemption Date Principal Amount Contract Rev Bds (Southern Wastewater Treatment Plant Proj) Ser 2014 09/01/2033 $245,000 Lien: Senior 09/01/2034 $255,000 Tax Treatment: Bank Qualified Original Issue Amount $6,950,000.00 Term bonds maturing on 09/01/2039: Dated Date: 09/01/2014 Mandatory Redemption Date Principal Amount Sale Date: 09/11/2014 09/01/2035 $265,000 Delivery Date: 10/08/2014 09/01/2036 $280,000 Sale Type: Negotiated 09/01/2037 $295,000 Record Date: MSRB 09/01/2038 $305,000 Bond Form: BE 09/01/2039 $320,000 Denomination $5,000 Interest pays Semi- Annually: 09/01, 03/01 Term bonds maturing on 09/01/2044: 1st Coupon Date: 03/01/2015 Mandatory Redemption Date Principal Amount 09/01/2040 $340,000 Paying Agent: BOKF, N.A., Austin, TX 09/01/2041 $350,000 Bond Counsel: Fulbright & Jaworski LLP 09/01/2042 $365,000 Financial Advisor: Southwest Securities, San Antonio, TX 09/01/2043 $380,000 Lead Manager: Raymond James 09/01/2044 $395,000 Co- Manager: Frost Bank Underwriter's Counsel: Andrews Kurth L.L.P. Grand Total _ ______________> $6,875,000.00 Insurance: Assured Guaranty Municipal Corp. (FSA) Use of Proceeds: Wastewater Treatment Plant. Bond Debt Service Orig Reoffering Maturity Amount Coupon Price /Yield Period Ending Principal Interest Debt Service 09/01/2016 145,000.00 2.0000% 0.600% 09/30/16 145,000.00 266,150.00 411,150.00 09/01/2017 150,000.00 2.0000% 0.900% 09/30/1.7 1.50,000.00 263,250.00 413,250.00 09/01/2018 150,000.00 2.0000% 1.200% 09/30/18 150,000.00 260,250.00 410,250.00 09/01/2019 155.000.00 2.0000% 1.550% 09/30/19 155,000.00 257,250.00 412,250.00 09/01/2020 160,000.00 2.0000% 1.800% 09/30/20 160,000.00 254,150.00 414,150.00 09/01/2021 160,000.00 2.0000% 100.00% 09/30/21 160,000.00 250,950.00 410,950.00 09/01/2022 165,000.00 3.0000% 2.300% 09/30/22 165,000.00 247,750.00 412,750.00 09/01/2023 170,000.00 3.0000% 2.550% 09/30/23 170,000.00 242,800.00 412,800.00 09/01/2024 175,000.00 3.0000% 2.700% 09/30/24 175,000.00 237,700.00 412,700.00 09/01/2026T 365,000.00 4.0000% 2.850% 09/30/25 180,000.00 232,450.00 412,450.00 09/01/2028T 395.000.00 4.0000% 3.050% 09/30/26 185,000.00 225,250.00 410,250.00 09/01/2030T 430,000.00 4.0000% 3.300% 09/30/27 195,000.00 217,850.00 412,850.00 09/01/2032T 460,000.00 4.0000% 3.450% 09/30/28 200,000.00 210,050.00 410,050.00 09/01/2034T 500,000.00 4.0000% 3.550% 09/30/29 210,000.00 202,050.00 412,050.00 09/01/2039T 1,465,000.00 5.0000% 3.560% 09/30/30 220,000.00 193,650.00 413,650.00 09/01/2044T 1,830,000.00 4.0000% 100.00% 09/30/31 225,000.00 184,850.00 409,850.00 $6,875,000.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 Call Option: Term bonds maturing on 09/01/2026 and 09/01/2028 and 09/01/2030 and 09/30/34 255,000.00 156,650.00 411,650.00 09/01/2032 and 09/01/2034 and 09/01/2039 and 09/01/2044 callable in whole or in 09/30/35 265,000.00 146,450.00 411,450.00 part on any date beginning 09/01/2024 @ par. 09/30/36 280,000.00 133,200.00 413,200.00 09/30/37 295,000.00 119,200.00 414,200.00 Term Call: Term bonds maturing on 09/01/2026: 09/30/38 305,000.00 104,450.00 409,450.00 Mandatory Redemption Date Principal Amount 09/30/39 320,000.00 89,200.00 409,200.00 09/01/2025 $180,000 09/30/40 340,000.00 73,200.00 413,200.00 09/01/2026 $185,000 09/30/41 350,000.00 59,600.00 409,600.00 09/30/42 365,000.00 45,600.00 410,600.00 Term bonds maturing on 09/01/2028: 09/30/43 380,000.00 31,000.00 411,000.00 z F, s Y �.r,; .,q,. .. .. Z. �. t ,; Cibolo Creek Municipal ut Texas Municipal Reports _' a O c p l (Southern Wastewater Treatment Plant Project) Last Revised: 7/26/2016 TR # 6774 Bexar, Comal, Guadalupe Counties Page 2 of 3 09/30/44 395,000.00 15,800.00 410,800.00 6,875,000.00 5,063,050.00 11,938,050.00 COMPUTED ON BASIS OF MANDATORY REDEMPTION Debt Amortization Rates % of Principal Period Ending Principal Retired 09/30/2016 145,000.00 02.11% 09/30/2017 150,000.00 04.29% 09/30/2018 150,000.00 06.47% 09/30/2019 155,000.00 08.73% 09/30/2020 160,000.00 11.05% 09/30/2021 160,000.00 13.38% 09/30/2022 165,000.00 15.78% 09/30/2023 170,000.00 18.25% 09/30/2024 175,000.00 20.80% 09/30/2025 180,000.00 23.42% 09/30/2026 185,000.00 26.11% 09/30/2027 195,000.00 28.95% 09/30/2028 200,000.00 31.85% 09/30/2029 210,000.00 34.91% 09/30/2030 220,000.00 38.11% 09/30/2031 225,000.00 41.38% 09/30/2032 235,000.00 44.80% 09/30/2033 245,000.00 48.36% 09/30/2034 255,000.00 52.07% 09/30/2035 265,000.00 55.93% 09/30/2036 280,000.00 60.00% 09/30/2037 295,000.00 64.29% 09/30/2038 305,000.00 68.73% 09/30/2039 320,000.00 73.38% 09/30/2040 340,000.00 78.33% 09/30/2041 350,000.00 83.42% 09/30/2042 365,000.00 88.73% 09/30/2043 380,000.00 94.25% 09/30/2044 395.000.00 100.00% PERTINENT PROVISIONS PERTINENT PROVISIONS OF THE REVENUE BOND INDENTURE - PRIOR LIEN 1. Nature of Pledge: The Bonds are special obligations payable as to principal and interest from, and secured by lien on and pledge of Special Payments to be paid to the Authority initially by the City of Schertz. 2. Special Payments: Payments the Authority expects to receive by participating members pursuant to the terms of the contract to be put towards debt service requirements. Contract - Regional Wastewater Treatment Contract, dated as of September 11, 2014, together with amendments and supplements thereto which by the term of such instrument is designated as a supplement or amendment to such contract. 3. Issuance of Additional Bonds: In addition to the right to issue bonds of subordinate and inferior lien as authorized by the laws of this state of Texas, the Authority reserves the right hereafter to issue Additional Bonds. 4. Rate Covenant: The Authority agrees and reaffirms its covenants to the holders of the Parity Obligations that it will at all times maintain rates and charges for sewer services furnished, provided and supplied by the System to customers which will produce income and revenues sufficient to pay the interest on and principal of all Parity Obligations, the interest on and principal of all Subordinate Lien Obligations, and any legal debt or obligation of the System as and when the same shall become due. 5. PROJECT: The Southern Wastewater Treatment Plant is a joint effort by the City and the Authority to bring wastewater service to Southern Schertz, Southern Cibolo, and the Interstate 10 Corridor. � rl ►�i�r3 Y :71 11MI ii! %\I• loll ri a21;111911ON I���IEK+rI�>r� �tL WASTEWATER TREATMENT CONTRACTS The Authority was created to provide a regional waste treatment system to a 58,261 acre area which includes portions of Bexar, Comal, and Guadalupe Counties. Entity % of Total Revenue City of Universal City 24.3% City of Schertz 30.1 Randolph Air Force Base 14.9 Service Area Within City of San Antonio 9.2 City of Cibolo 8.6 City of Selma 6.6 Retama, Ltd. 5.3 City of Live Oak 1.0 The Cities agree to pay the Authority a single monthly payment composed of: a) Base monthly charge - a pro rata cost of maintenance and operation expense of the system, b) Sewer charge - a pro -rata share of the system's debt service c) Additional monthly charge - an amount charge for the treatment of each 1,000 gallons of inadmissible discharge into the system. Randolph Air Force Base: On August 13, 1976 CCMA entered into a contract with the Federal Government to provide wastewater treatment to Randolph AFB. The contract continues until such time as Randolph AFB provides a sixty day notice of cancellation. RATES, FEES AND OPERATING DATA SEWER RATES (Monthly billing)(Based on 3 month winter averaging) Effective since October 1, 2013, October 1, 2014, and October 1, 2015. Old Rates (Effective October 1, 2014) Impact Fees - $1,800.00* $3.27/M gallons New Rates (Effective October 1, 2015) Impact Fees - $1,800.00* $3.15/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 Area and is traversed by Interstate Highways 10 and 35, four U.S. Highways, and two State Highways. Texas A &M University - San Antonio was established on May 23, 2009. .,�z . Ciolo Creek Municipal Auth Texas Municipal Reports O c p (Southern Wastewater Treatment Plant Project) Last Revised: 7/26/2016 TR # 6774 Bexar, Comal, Guadalupe Counties Page 3 of 3 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, horses, hay, grain sorghum, corn and beef cattle OIL AND GAS - 2015 The oil production for this county accounts for 0.01% of the total state production. The county ranks 163 out of all the counties in Texas for oil production. OIL PRODUCTION (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2012 Oil 119,303 BBL 8.78 2013 Oil 125,446 BBL 5.15 2014 Oil 119,014 BBL -5.13 2015 Oil 95,355 BBL -19.88 CASINGHEAD (Texas Railroad Commission) Year Description Volume % Change From Previous Year 2012 Casinghead 36 MCF 38.46 2013 Casinghead 44 MCF 22.22 2014 Casinghead 24 MCF -45.45 2015 Casinghead 23 MCF -4.17 PARKS (Texas Parks & Wildlife) Year Description Volume 2012 Government Canyon State Natural Area 40,352 Visitors 2013 Government Canyon State Natural Area 58,540 Visitors 2014 Government Canyon State Natural Area 63,633 Visitors CIVIL / MILITARY PERSONNEL (US Department of Defense) Year Description Volume 2012 Brooks City Air Force Base 40 Members 2013 Brooks City Air Force Base 13 Members 2012 Brooks City -Base 1,965 Members 2012 Camp Bullis 2013 Camp Bullis 2012 Fort Sam Houston 2013 Fort Sam Houston 21,256 Members 2012 Kelly Air Force Base 600 Members 2013 Kelly Air Force Base 206 Members 2012 Lackland Air Force Base 2013 Lackland Air Force Base 32,116 Members 2012 Randolph Air Force Base 2013 Randolph Air Force Base 7,333 Members RETAIL SALES & EFFECTIVE BUYING INCOME (The N Year 2014 Retail Sales $24.08 Effective Buying Income (EBI) $36.OB County Median Household Income $42,396 State Median Household Income $50,464 % of Households with EBI below $25K 13.0 % % of Households with EBI above $25K 65.6 % elsen Company) 2013 2012 $30.98 $26.18 $35.5B $31.5B $41,514 $37,969 $48,646 $47,613 13.1 % 15.3 % 65.4 % 62.7 % EMPLOYMENT DATA (Texas Workforce Commission) 2015 2014 2013 Employed Earnings Employed Earnings Employed Earnings 1st Q: 806,522 $9.8B 778,165 $9.3B 759,308 $8.8B 2nd Q: 817,903 $9.18 794,010 $8.6B 770,700 $8.1B 3rd Q: 817,129 $9.3B 793,771 $8.8B 770.907 $8.3B 4th Q: 834,660 $10.68 809,353 $9.68 780,920 $8.98 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 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 ar, ?' . 5 ". ..