Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Debt Model Report Sept 30, 2013 Updated Sept 13, 2012
For Fl*scal Year Ending September 30, 2013 0 Updated. September 13, 2012 ,Table of Contents Section A: Debt Model Section B: Debt Service Schedules City of S' hertz, Texas Debt Model For Fiscal Year En ing September 30, 2013 General Fund Debt Obliaations Fiscal Year CO's CO's GO's CO's, S -2007 CO's, S -2007 GO's GPO's Ending 9/30 GO's and Ref. Notes, S -2010 GO Ref. GO's GO Ref. GO Bonds Total Ending 9/30 S -2003 S -2004 S -2006 Pub. Works Comm. E ui P. S -2007 S -4008 $2341331 S -2009 EMS Series 2010 Series 2011 Series 2011 -A Series 2012 Debt Service 2012 2016 $237,031 $4861428 $3361475 $11059,934 2017 $2351531 $488,796 $330,475 $1,054,802 2018 $233,831 $4,369,228 2013 $2131833 $331,906 $842,981 $821231 $1101639 $4241560 $7341088 $973,173 $468,875 $63,720 $327,125 $5671238 $223,081 $528,784 $41919,060 2014 $247,200 $834,981 $84,424 $106,830 $424,792 $762,259 $5381063 $67,389 $330,750 $568,038 $760,101 $504,284 $4,981,908 2015 $234,573 $973,981 $86,416 $103,020 $424,617 $731141706 $4661613 $65,829 $328,525 $569,438 $740,830 $501,443 $4,9951417 2016 $4881847 $1,008,981 $831208 $1091211 $424,035 $73-3,947 $455,538 $330,425 $566,663 $721,675 $504,721 $4,941,403 2017 $1,017,216 $427,945 $73� , 362 $4491538 $332,025 $569,763 $722,404 $501,755 $4,759,006 2018 $11048,475 $426,345 $73� 054 $438,369 $323,475 $567,038 $722,783 $503,095 $417631633 2019 $11204,418 $424,339 $7331921 $446,525 $329,700 $568,463 $559,735 $502,945 $4,775,044 2020 $1,205,351 $426,823 $73 , 858 $478,163 $329,000 $568,888 $538,551 $504,170 $4,7881802 2021 $1,204,636 $4231799 $738, 969 $409,628 $3261400 $566,938 $5371367 $5031370 $4,708,106 2022 $112041219 $425,267 $73 1150 $3721540 $567,350 $708,911 $503,676 $41520,113 2023 $11203,794 $426,123 $73 1403 $380,581 $566,263 $6981242 $5051126 $41514,532 2024 $11206,138 $426,370 $734,726 $412,294 $566,713 $667,689 $5001920 $4,514,848 2025 $1,2061119 $426,005 $733,914 $3881225 $5681606 $5001645 $318281514 2026 $11203,738 $4251031 $73 3,965 $389,000 $5691469 $504,435 $3,828,637 2027 $1,203,863 $423,445 $73 , 985 $389,325 $5691263 $5021250 $3,8221130 2028 $1,204,566 $73,4, 868 $682,450 $567,950 $504,275 $3,694,109 2029 $1,201,119 ! $583,013 $565,494 $5001925 $2,850,550 2030 $1,,205,359 $582,300 $5661738 $502,200 $2,856,597 2031 $1,2021172 $585,075 $566,250 $502,785 $2,856,282 2032 $586,200 $5691125 $502, 673 $1,657998 2033 $585,675 $565,875 $11151,550 2034 $566,500 $566,500 2035 $565,875 $565t875 2036 $568,875 $568,875 Total $213,833 $331,906 $21,382,105 $336,278 $429,699 $6,379,496 $11,81'05,173 $10,087,986 $196,938 $2,957,425 $13,622X6 806 $7, 601, 366 $10,084,477 $75,345,010 Utility System Supported Debt-Obligations Fiscal Year CO's CO's, S -2007 GO Ref. Total Ending 9/30 S -2005 Town Creek S -2011 Debt Service 2012 $1,0661923 2013 $2351031 $4861515 $338,975 $1,060,521 2014 $2341331 $485,287 $3381275 $1,0571893 2015 $238,331 $4881658 $342,475 $11069,464 2016 $237,031 $4861428 $3361475 $11059,934 2017 $2351531 $488,796 $330,475 $1,054,802 2018 $233,831 $485,563 $249,475 $968,869 2019 $236,831 $4861929 $2491413 $973,173 2020 $234,416 $487,694 $2481663 $970,772 2021 $236,505 $4871857 $247,200 $9711562 2022 $2371951 $487,418 $7251369 2023 $2331925 $491,378 $725,303 2024 $234,573 $489,536 $724,109 2025 $229,894 $492,093 $721,986 2026 $488,847 $4881847 $13,639,527 Total $3,058,182 $61832,997 $2,681,425 Sales Tax Supported Debt Obligations Fiscal Year CO's, S -2007 GO's and Ref. Notes, S -2010 Total Ending 9/30 EDC Proiects S -2009 EDC Projects Debt Service 2012 $795,154 2013 $153,459 $3691075 $2701045 $7971579 2014 $163,045 $366,138 $264,626 $793,809 2015 $16 ,231 $367,188 $268,379 $7971797 2016 $16 11 , 216 $3671138 $528,353 2017 $366,788 $366,788 2018 $360,769 $360,769 $316 093 Total $644,950 $2,1971094 $8031050 SSLGC -SAWS PROJECT Fiscal Year The Schertz/Seguin Local Government Corporation Ending 9/30 Fiscal Year 2012 2013 $110961069 Total Schertz Debt Ending 9/30 Debt Service Payment Series 2001 Refunding 20051 Rev. and Ref. 2007 Series 2010 2012 $11510,188 2018 $115111788 2019 $4,339,843 $211691921 2013 $520,000 $726,036 $2,141,138 $9511088 $4,338,261 $211691131 2014 $520,000 $728,436 $211401138 $113891413 $417771986 $213881993 2015 $520,000 $734,936 $211387338 $1,390,838 $41784f 111 $21392,056 2016 $520,000 $735,536 $2,135,738 $113911813 $417831086 $2,391,543 2017 $520,000 $740,236 $21127,438 $1,387,413 $41775,086 $21387,543 2018 $5201000 $739,036 $2,133,238 $11391,300 $41783,574 $29391,787 2019 $520,000 $737,036 $211281038 $1,388,363 $41773,436 $21386,718 2020 $520,000 $738,844 $21131,419 $1,389,813 $4,780,075 $213901038 2021 $520,000 $7399194 $2,118,044 $1,3892163 $4,766,400 $21383,200 2022 $5201000 $7381201 $2,123,188 $173911263 $4$772,651 $273861326 2023 $520,000 $740,735 $211211950 $1$392,363 $4,775,048 $213871524 2024 $520,000 $7411661 $2,124,331 $1,387,563 $41773,555 $2,386,778 2025 $520,000 $740,859 $2,125,225 $113911763 $4,777,847 $213881923 2026 $520,000 $2,912,525 $1,389,434 $41821,959 $214103980 2027 $520,000 $2,903,438 $11390,113 $4,813,550 $2,406,775 2028 $5201000 $2,908,900 $1,389,088 $478171988 $2,408,994 2029 $520,000 $2,910,538 $11391,681 $4,822,219 $21411,109 2030 $520,000 $219031463 $1,391,769 $4,815,231 $214071616 2031 $2,268,330 $11167,500 $1,389,306 $41825,136 $214121568 2032 $2,272,390 $1,169,113 $1,390,156 $4,831,659 $21415,829 2033 $2,271,250 $11170,050 $1,388,625 $41829,925 $2,414,963 2034 $2,269,780 $191703313 $11389,572 $4,829,664 $214141832 2035 $2,272,590 $111691900 $1,388,438 $4,830,928 $214151464 2036 $3,426,838 $1,389,438 $418161275 $2,408,138 2037 $314281650 $1,392,306 $438201956 $2,410,478 2038 $3,434,613 $1,387,681 $418221294 $2,411,147 2039 $3,434,500 $113901444 $41824,944 $214121472 2040 $3,433,200 $11390,356 $4,823,556 $2,411,778 2041 $3,430,488 $113921300 $408221788 $27411,394 Total $20,714,340 $915801748 $68,662,244 $39,872,856 $1381830,188 $6914151094 SSLGC -SAWS PROJECT Fiscal Year Revenue Bonds Ending 9/30 Sereis 2012 2012 2013 $110961069 2014 $9391488 2015 $1,508,738 2016 $115121088 2017 $11510,188 2018 $115111788 2019 $115111488 2020 $115101188 2021 $115121788 2022 $115091288 2023 $11509,688 2024 $1,508,888 2025 $11510,963 2026 $11511,138 2027 $115101022 2028 $1,510,284 2029 $115121206 2030 $11512,859 2031 $115121244 2032 $1,510,359 2033 $11510,100 2034 $1,511,200 2035 $115101500 2036 $1,508,000 2037 $115081600 2038 $115121100 2039 $1,508,500 2040 $1,512,700 2041 $1,509,600 Total $421822,056 SVGS SOUTH EST GROUP 'SECURITIES BuUd nq what uou value Sep 7, 2012 2:58 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -CO03) Page I BOND DEBT SERVICE City of Schertz, Texas Certificates of Obligation, Series 2003 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2013 210,000 3.650% 3,832.50 213,832.50 09/30/2013 213,832.50 210,000 3,832.50 2131832.50 213,832.50 Sep 7, 2012 2:58 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -CO03) Page I SWS:;SOUTHWEST GROUP` Buddinq what uou value.' Sep 7, 2012 2:58 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ-CO04) Page 2 BOND DEBT SERVICE City of Schertz, Texas Certificates of Obligation, Series 2004 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2013 325,000 4.250% 6,906.25 331:1906.25 09/30/2013 331,906.25 325,000 6:1906.25 331,906.25 331)906.25 Sep 7, 2012 2:58 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ-CO04) Page 2 SWS:SOUTHWEST OUP SECURITIES Buitd ha what uou vatue.' BOND DEBT SERVICE Period Ending Principal City of Schertz, Texas Certificates of Obligations, Series 2005 Coupon Interest Debt Service Annual Debt Service 02/01/2013 1403000 4.000% 48,915.63 188,915.63 08/01/2013 46,115.63 46,115.63 09/30/2013 235,031.26 02/01/2014 145,000 4.000% 46,115.63 1911115.63 08/01/2014 43,215.63 43,215.63 09/30/2014 234,331.26 02/01/2015 155,000 4.000% 43,215.63 1981215.63 08/01/2015 40,115.63 40,115.63 09/30/2015 238,331.26 02/01/2016 160,000 4.000% 40,115.63 200,115.63 08/01/2016 36,915.63 36,915.63 09/30/2016 2371;031.26 02/01/2017 165,000 4.000% 36,915.63 2011915.63 08/01/2017 33,615.63 33,615.63 09/30/2017 235)531.26 02/01/2018 1701000 4.000% 33,615.63 203,615.63 08/01/2018 305215.63 30,215.63 09/30/2018 233,831.26 02/01/2019 1803000 4.000% 30,215.63 210,215.63 08/01/2019 261615.63 26,615.63 09/30/2019 2363831.26 02/01/2020 1851000 4.125% 26,615.63 211,615.63 08/01/2020 2200.00 221800.00 09/30/2020 234,415.63 02/01/2021 195,000 4.200% 22,800.00 217,800.00 08/01/2021 18,705.00 18,705.00 09/30/2021 236,505.00 02/01/2022 20500 4.350% 18,705.00 223,705.00 08/01/2022 14,246.25 147246.25 09/30/2022 23 7,951.25 02/01/2023 2105000 4.350% 14,246.25 2241246.25 08/01/2023 911678.75 91678.75 09/30/2023 233,925.00 02/01/2024 22000 4.350% 9,678.75 2291678.75 08/01/2024 4,893.75 4,893.75 09/30/2024 234,572.50 02/01/2025 2253000 4.350% 41893.75 2291893.75 09/30/2025 2291893.75 213551000 703,181.95 3,058,181.95 3,0581,181.95 Sep 7, 2012 2:59 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -COOS) Page 3 J i SOUTH EST GROUP: SECURITIES Buildinq what you value BOND DEBT SERVICE Period Ending Principal City of Schertz, Texas General Obligation Bonds, Series 2006 Coupon Interest Debt Service Annual Debt Service 02/01/2013 200,000 4.000% 323,490.63 523,490.63 08/01/2013 319,490.63 319,490.63 09/30/2013 842,981.26 02/01/2014 20011000 4.000% 319,490.63 519,490.63 08/01/2014 315,490.63 315,490.63 09/30/2014 834,981.26 02/01/2015 350,000 4.000% 315,490.63 665,490.63 08/01/2015 308,490.63 308,490.63 09/30/2015 973,981.26 02/01/2016 4007000 4.000% 3081490.63 708,490.63 08/01/2016 3001490.63 300,490.63 09/30/2016 1,008,981.26 02/01/2017 42500 4.125% 3007490.63 725,490.63 08/01/2017 291,725.00 291,725.00 09/30/2017 1,017,215.63 02/01/2018 475,000 4.200% 291,725.00 766,725.00 08/01/2018 2811750.00 281,750.00 09/30/2018 1,048,475.00 02/01/2019 655,000 4.300% 281,750.00 9363750.00 08/01/2019 267,667.50 267,667.50 09/30/2019 1,204,417.50 02/01/2020 6851000 4.375% 2671667.50 952,667.50 08/01/2020 252,683.13 252,683.13 09/30/2020 1,205,350.63 02/01/2021 715,000 4.400% 252,683.13 9675683.13 08/01/2021 2361953.13 2363953.13 09/30/2021 1,204,636.26 02/01/2022 750,000 5.250% 236,953.13 986,953.13 08/01/2022 217,265.63 2171265.63 09/30/2022 1,204,218.76 02/01/2023 7903000 5.250% 2171265.63 1,007,265.63 08/01/2023 1963528.13 196,528.13 09/30/2023 1,2031793.76 02/01/2024 835,000 5.250% 196,528.13 110313528.13 08/01/2024 174,609.38 174,609.38 09/30/2024 11206,137.51 02/01/2025 880,000 5.250% 174,609.38 1,05409.38 08/01/2025 151,509.38 151,509.38 09/30/2025 17206,118.76 02/01/2026 9257000 5.250% 1511509.38 1,076,509.38 08/01/2026 1273228.13 127,228.13 09/30/2026 1,203,737.51 02/01/2027 97500 5.250% 127,228.13 1,102,228.13 08/01/2027 101,634.38 101,634.38 09/30/2027 1,203,862.51 02/01/2028 11025,000 4.625% 101,634.38 15126,634.38 08/01/2028 77,931.25 77,931.25 09/30/2028 13204,565.63 02/01/2029 1,070,000 4.625% 77,931.25 1,147,931.25 08/01/2029 53,187.50 531187.50 09/30/2029 15201,118.75 02/01/2030 1,1253000 4.625% 53,187.50 1378,187.50 08/01/2030 271171.88 273171.88 09/30/2030 11205,359.38 02/01/2031 1,175,000 4.625% 27,171.88 1,202,171.88 09/30/2031 1,202,171.88 131165511000 73727,104.51 21,3 82,104.51 21:13821)104.51 Sep 7, 2012 3:00 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -GO06) Page 4 SWS SOUTHWEST GROUP SECURITIES Huddinq what you t 'a1ue.'° BOND DEBT SERVICE Period Ending Principal City of Schertz, Texas Certificates of Obligation, Series 2007 Coupon Interest Debt Service Annual Debt Service 02/01/2013 128,921.50 128,921.50 08/01/2013 580,000 4.010% 128,921.50 708,921.50 09/30/2013 837,843.00 02/01/2014 117,292.50 117,292.50 08/01/2014 605,000 4.010% 117,292.50 722,292.50 09/30/2014 839,585.00 02/01/2015 105,162.25 105,162.25 08/01/2015 630,000 4.010% 105,162.25 735,162.25 09/30/2015 840,324.50 02/01/2016 92,530.75 92,530.75 08/01/2016 655,000 4.010% 92,530.75 747,530.75 09/30/2016 840,061.50 02/01/2017 79,398.00 797398.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 4281846.75 09/30/2020 487,693.50 02/01/2021 517428.25 51,428.25 08/01/2021 3857000 4.010% 517428.25 436,428.25 09/30/2021 487,856.50 02/01/2022 43,709.00 437709.00 08/01/2022 4001000 4.010% 43,709.00 4437709.00 09/30/2022 4877418.00 02/01/2023 3509.00 35,689.00 08/01/2023 4207000 4.010% 3509.00 4553689.00 09/30/2023 4911378.00 02/01/2024 277268.00 27,268.00 08/01/2024 43500 4.010% 273268.00 462,268.00 09/30/2024 489,536.00 02/01/2025 187546.25 18,546.25 08/01/2025 4551000 4.010% 187546.25 4731546.25 09/30/2025 492,092.50 02/01/2026 9,423.50 9,423.50 08/01/2026 4703000 4.010% 9,423.50 479,423.50 09/30/2026 488,847.00 6,43000 17813,923.50 81243,923.50 8,243,923.50 Sep 7, 2012 3:02 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -CO07) Page 5 SWS SOUTH EST GROUPISECURITiES Build na what uou uatue.' DETAILED BOND DEBT SERVICE City of S chertz, Texas Certificates of Obligation, Series 2007 Town Creek (TC) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2013 103,257.50 103,257.50 08/01/2013 28000 4.010% 1031257.50 383,257.50 09/30/2013 486,515.00 02/01/2014 97,643.50 97,643.50 08/01/2014 29000 4.010% 97,643.50 387,643.50 09/30/2014 485,287.00 02/01/2015 91,829.00 913829.00 08/01/2015 3051000 4.010% 91,829.00 3965829.00 09/30/2015 488,658.00 02/01/2016 85,713.75 85,713.75 08/01/2016 3153000 4.010% 85,713.75 4007713.75 09/30/2016 486,427.50 02/01/2017 79,398.00 793398.00 08/01/2017 330,000 4.010% 79,398.00 409,398.00 09/30/2017 488,796.00 02/01/2018 72,78 1.50 72,781.50 08/01/2018 340,000 4.010% 72,781.50 412,781.50 09/30/2018 4851563.00 02/01/2019 65,964.50 651964.50 08/01/2019 3551000 4.010% 651964.50 420,964.50 09/30/2019 486,929.00 02/01/2020 58,846.75 58,846.75 08/01/2020 3701000 4.010% 58,846.75 428,846.75 09/30/2020 487,693.50 02/01/2021 511428.25 51,428.25 08/01/2021 385,000 4.010% 51,428.25 4363428.25 09/30/2021 487,856.50 02/01/2022 43,709.00 431709.00 08/01/2022 4001000 4.010% 43,709.00 443,709.00 09/30/2022 487,418.00 02/01/2023 357689.00 355689.00 08/01/2023 420,000 4.010% 355689.00 45509.00 09/30/2023 4917378.00 02/01/2024 273268.00 27,268.00 08/01/2024 43500 4.010% 27,268.00 462,268.00 09/30/2024 4895536.00 02/01/2025 185546.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 913423.50 9)423.50 08/01/2026 4701000 4.010% 91423.50 4791423.50 09/30/2026 4885847.00 5,150,000 1,6823997.00 6,8323997.00 6,832,997.00 Sep 7, 2012 3:02 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -CO07) Page 6 SWS SOUTHWEST GROUP SECURITIES Buad ng what you Value DETAILED BOND DEBT SERVICE City of Schertz, Texas Certificates of Obligation, Series 2007 Public Works Equipment (PWE) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2013 6,115.25 6,115.25 08/01/2013 70,000 4.010% 6,115.25 76,115.25 09/30/2013 82,230.50 02/01/2014 4,711.75 4,711.75 08/01/2014 75,000 4.010% 4,711.75 79,711.75 09/30/2014 84,423.50 02/01/2015 3,208.00 3,208.00 08/01/2015 80,000 4.010% 3,208.00 83,208.00 09/30/2015 86,416.00 02/01/2016 1,604.00 1,604.00 08/01/2016 805000 4.010% 1,604.00 81,604.00 09/30/2016 833208.00 3051000 311278.00 3365278.00 336,278.00 Sep 7, 2012 3:02 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -CO07) Page 7 SWSISOUTHWEST GROUP: Build na what uou value.' DETAILED BOND DEBT SERVICE City of Schertz, Texas Certificates of Obligation, Series 2007 Communication Equipment (CE) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2013 7,819.50 7,819.50 08/01/2013 95,000 4.010% 7,819.50 102,819.50 09/30/2013 110,639.00 02/01/2014 5,914.75 5,914.75 08/01/2014 9500 4.010% 5,914.75 1001914.75 09/30/2014 1067829.50 02/01/2015 4,010.00 4,010.00 08/01/2015 955000 4.010% 4,010.00 99,010.00 09/30/2015 103,020.00 02/01/2016 2,105.25 2,105.25 08/01/2016 105,000 4.010% 2,105.25 107,105.25 09/30/2016 109,210.50 390,000 39,699.00 429,699.00 429,699.00 Sep 7, 2012 3:02 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -CO07) Page 8 SWS SOUTHWEST GROUP' SECURITIES Buiidtna what uou Luiue.e DETAILED BOND DEBT SERVICE City of Schertz, Texas Certificates of Obligation, Series 2007 EDC Projects (EDC) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2013 115729.25 11,729.25 08/01/2013 135,000 4.010% 11,729.25 1461729.25 09/30/2013 1581458.50 02/01/2014 9,022.50 9,022.50 08/01/2014 145,000 4.010% 9,022.50 154,022.50 09/30/2014 1633045.00 02/01/2015 6,115.25 6,115.25 08/01/2015 150,000 4.010% 6,115.25 1561115.25 09/30/2015 1623230.50 02/01/2016 3,107.75 3,107.75 08/01/2016 155,000 4.010% 3,107.75 158,107.75 09/30/2016 161,215.50 585,000 59,949.50 644,949.50 644,949.50 Sep 7, 2012 3:02 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -CO07) Page 9 SOUTH EST GROUP'EUITIES Buddinq what uou Uatue." BOND DEBT SERVICE Period Ending Principal City of Schertz, Texas General Obligation Bonds, Series 2007 Coupon Interest Debt Service Annual Debt Service 02/01/2013 235,000 4.070% 97,171.25 332,171.25 08/01/2013 921389.00 92,389.00 09/30/2013 424,560.25 02/01/2014 2451000 4.070% 921389.00 337,389.00 08/01/2014 87,403.25 87,403.25 09/30/2014 424,792.25 02/01/2015 255,000 4.070% 87,403.25 342,403.25 08/01/2015 82,214.00 82,214.00 09/30/2015 424,617.25 02/01/2016 265,000 4.070% 825214.00 347,214.00 08/01/2016 76,821.25 76,821.25 09/30/2016 424,035.25 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 3001,000 4.070% 657221.75 365,221.75 08/01/2019 59,116.75 59,116.75 09/30/2019 424,338.50 02/01/2020 3155000 4.070% 591116.75 374,116.75 08/01/2020 52,706.50 521706.50 09/30/2020 4265823.25 02/01/2021 3255000 4.070% 52,706.50 377,706.50 08/01/2021 461092.75 46,092.75 09/30/2021 423,799.25 02/01/2022 3401000 4.070% 46,092.75 386,092.75 08/01/2022 391,173.75 39,173.75 09/30/2022 425,266.50 02/01/2023 355,000 4.070% 391173.75 394,173.75 08/01/2023 311949.50 31,949.50 09/30/2023 426,123.25 02/01/2024 3703000 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 3851000 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 40000 4.070% 16,585.25 4163585.25 08/01/2026 81445.25 8,445.25 09/30/2026 425,030.50 02/01/2027 4153000 4.070% 81445.25 423,445.25 09/30/2027 423,445.25 4,7751000 11604,495.75 6,379,495.75 6,379,495.75 Sep 7, 2012 3:04 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -GO07) Page 10 SOU THEST GROUP: SECURITIES Buftdinu what uou value' BOND DEBT SERVICE Period Ending Principal City of Schertz, Texas General Obligation Bonds, Series 2008 Coupon Interest Debt Service Annual Debt Service 02/01/2013 385,000 4.130% 178,519.25 563,519.25 08/01/2013 170,569.00 170,569.00 09/30/2013 734,088.25 02/01/2014 430,000 4.130% 1703569.00 600,569.00 08/01/2014 161,689.50 1611689.50 09/30/2014 762,258.50 02/01/2015 420,000 4.130% 1611689.50 581,689.50 08/01/2015 153,016.50 153,016.50 09/30/2015 734,706.00 02/01/2016 4401000 4.130% 153,016.50 593,016.50 08/01/2016 143,930.50 143,930.50 09/30/2016 736,947.00 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 4753000 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 1147297.75 114,297.75 09/30/2019 738,920.50 02/01/2020 5201000 4.130% 114,297.75 6341297.75 08/01/2020 10311559.75 1037559.75 09/30/2020 737,857.50 02/01/2021 540,000 4.130% 1031559.75 643,559.75 08/01/2021 921408.75 92,408.75 09/30/2021 7351968.50 02/01/2022 56500 4.130% 92,408.75 657,408.75 08/01/2022 803741.50 805741.50 09/30/2022 7387150.25 02/01/2023 5851000 4.130% 80,741.50 665,741.50 08/01/2023 685661.25 68,661.25 09/30/2023 7347402.75 02/01/2024 6101000 4.130% 6801.25 67801.25 08/01/2024 56,064.75 56,064.75 09/30/2024 734,726.00 02/01/2025 64011000 4.130% 563064.75 696,064.75 08/01/2025 4211848.75 423848.75 09/30/2025 738,913.50 02/01/2026 6651000 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 72000 4.130% 14,868.00 7343868.00 09/30/2028 734,868.00 8,645,000 311601172.75 11,805,172.75 11,805,172.75 Sep 7, 2012 3:04 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- GO08PP) Page 11 SWSISOUTHWEST �ROUp SECURITIES Buitdiriq cvhw uou value.' BOND DEBT SERVICE Period Ending City of Schertz, Texas General Obligation and Refunding Bonds, Series 2009 Principal Coupon Interest Debt Service Annual Debt Service 02/01/2013 510,000 2.500% 167,162.50 677,162.50 08/01/2013 160,787.50 160,787.50 09/30/2013 837,950.00 02/01/2014 590,000 2.500% 160,787.50 750,787.50 08/01/2014 153,412.50 153,412.50 09/30/2014 904,200.00 02/01/2015 535,000 3.000% 153,412.50 688,412.50 08/01/2015 145,387.50 145,387.50 09/30/2015 833,800.00 02/01/2016 5401000 3.000% 145,387.50 685,387.50 08/01/2016 137,287.50 137,287.50 09/30/2016 822,675.00 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 8161325.00 02/01/2018 5503000 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 2503000 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 19000 4.050% 111,737.50 301,737.50 08/01/2021 107,890.00 107,890.00 09/30/2021 40911627.50 02/01/2022 1601000 4.050% 1072890.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 2795650.00 08/01/2023 100,931.25 100,931.25 09/30/2023 380:1581.25 02/01/2024 21500 4.250% 100,931.25 315,931.25 08/01/2024 961362.50 96,362.50 09/30/2024 412,293.75 02/01/2025 2001000 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 21000 4.500% 9102.50 301,862.50 08/01/2026 87,137.50 87, 137.50 09/30/2026 3891000.00 02/01/2027 22000 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 5301000 4.500% 82,187.50 6123187.50 08/01/2028 70,262.50 703262.50 09/30/2028 6827450.00 02/01/2029 45500 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 4803000 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 5541550.00 08/01/2031 301,525.00 30,525.00 09/30/2031 5853075.00 02/01/2032 5401000 5.500% 301,525.00 570,525.00 08/01/2032 15,675.00 15,675.00 09/30/2032 5863200.00 02/01/2033 5701000 5.500% 153675.00 585,675.00 09/30/2033 585,675.00 8,190,000 4,09500.00 12,2857080.00 1212857080.00 Sep 7, 2012 3:06 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- GOREF09) Page 12 SWS SOUTHWEST GROUP` SECURITIES Building what uou value DETAILED BOND DEBT SERVICE City of Schertz, Texas General Obligation and Refunding Bonds, Series 2009 General Fund (GF) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2013 195,000 2.500% 138,156.25 333,156.25 08/01/2013 135,718.75 135,718.75 09/30/2013 468,875.00 02/01/2014 270,000 2.500% 135,718.75 4051718.75 08/01/2014 132,343.75 132,343.75 09/30/2014 538,062.50 02/01/2015 205,000 3.000% 132,343.75 3373343.75 08/01/2015 1291,268.75 129,268.75 09/30/2015 466,612.50 02/01/2016 200,000 3.000% 1293268.75 329,268.75 08/01/2016 126,268.75 1267268.75 09/30/2016 4551537.50 02/01/2017 20000 3.000% 126,268.75 326,268.75 08/01/2017 1231268.75 1233268.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 4381368.75 02/01/2019 210,000 3.500% 120,100.00 330,100.00 08/01/2019 1163425.00 116,425.00 09/30/2019 446,525.00 02/01/2020 25000 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 19000 4.050% 111,737.50 301,737.50 08/01/2021 1077890.00 107,890.00 09/30/2021 409:1627.50 02/01/2022 160,000 4.050% 107,890.00 267,890.00 08/01/2022 1041650.00 104,650.00 09/30/2022 372,540.00 02/01/2023 17500 4.250% 1043650.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 3151931.25 08/01/2024 96,362.50 96,362.50 09/30/2024 4121293.75 02/01/2025 200,000 4.500% 963362.50 296,362.50 08/01/2025 911862.50 9102.50 09/30/2025 388,225.00 02/01/2026 2103000 4.500% 91,862.50 3013862.50 08/01/2026 87,137.50 871137.50 09/30/2026 389:1000.00 02/01/2027 2203000 4.500% 871137.50 3077137.50 08/01/2027 821187.50 82,187.50 09/30/2027 3891325.00 02/01/2028 530,000 4.500% 823187.50 6123187.50 08/01/2028 7011262.50 70,262.50 09/30/2028 682,450.00 02/01/2029 4553000 5.500% 701262.50 525,262.50 08/01/2029 57,750.00 57,750.00 09/30/2029 583,012.50 02/01/2030 48000 5.500% 57,750.00 5377750.00 08/01/2030 44,550.00 441550.00 09/30/2030 582,300.00 02/01/2031 5101000 5.500% 44,550.00 5543550.00 08/01/2031 30,525.00 303525.00 09/30/2031 5851,075.00 02/01/2032 540,000 5.500% 30,525.00 5701525.00 Sep 7, 2012 3:06 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- GOREF09) Page 13 SWSISOUTHWEST GROUP'SE'UF]TES Buildfria what uou vatue.' DETAILED BOND DEBT SERVICE City of Schertz, Texas General Obligation and Refunding Bonds, Series 2009 General Fund (GF) Period Ending Principal Coupon Annual Interest Debt Service Debt Service 08/01/2032 155675.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,180,000 3,907,986.25 10,0871986.25 10,087,986.25 Sep 7, 2012 3:06 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- GOREF09) Page 14 S S SOUTH EST GROUP SECURITIES Buildinq what uou Value' DETAILED BOND DEBT SERVICE City of Schertz, Texas General Obligation and Refunding Bonds, Series 2009 Sales Tax Supported (EDC) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2013 3153000 2.500% 291006.25 344,006.25 08/01/2013 25,068.75 25,068.75 09/30/2013 369,075.00 02/01/2014 320,000 2.500% 25,068.75 345,068.75 08/01/2014 21,068.75 21,068.75 09/30/2014 366,137.50 02/01/2015 3301000 3.000% 21,068.75 3517068.75 08/01/2015 16,118.75 16,118.75 09/30/2015 3677187.50 02/01/2016 3403000 3.000% 16,118.75 3563118.75 08/01/2016 111018.75 11,018.75 09/30/2016 367,137.50 02/01/2017 350,000 3.000% 11,018.75 3615018.75 08/01/2017 5,768.75 5,768.75 09/30/2017 366,787.50 02/01/2018 355,000 3.250% 5,768.75 360,768.75 09/30/2018 360:1768.75 2,010,000 1877093.75 211971093.75 2,197,093.75 Sep 7, 2012 3:06 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- GOREF09) Page 15 SWS SOUTH EST GROUP SECURITIES BuUdijv _q what you Value Sep 7, 2012 3:07 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- NOTESIO) Page 16 BOND DEBT SERVICE City of Schertz, Texas Tax Notes, Series 2010 Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2013 315,000 2.000% 10,957.50 325,957.50 08/01/2013 7,807.50 7,807.50 09/30/2013 333,765.00 02/01/2014 320,000 2.250% 7,807.50 327,807.50 08/01/2014 4,207.50 4,207.50 09/30/2014 332,015.00 02/01/2015 330,000 2.550% 41207.50 334,207.50 09/30/2015 334,207.50 965,000 34,987.50 999,987.50 999,987.50 Sep 7, 2012 3:07 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- NOTESIO) Page 16 S S SOUTHWEST GROUP = SECURITIES BuiWina what uou Value DETAILED BOND DEBT SERVICE City of Schertz, Texas Tax Notes, Series 2010 EMS (EMS) Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2013 60,000 2.000% 2,160.00 62,160.00 08/01/2013 1,560.00 1,560.00 09/30/2013 63,720.00 02/01/2014 65,000 2.250% 11560.00 667560.00 08/01/2014 828.75 828.75 09/30/2014 67,388.75 02/01/2015 653000 2.550% 828.75 65,828.75 09/30/2015 65,828.75 190,000 6,937.50 1961937.50 1961937.50 Sep 7, 2012 3:07 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- NOTES10) Page 17 S if S ` SOVTH WEST G RO U P' SECURITIES Buddtnq what Uou Lu ue DETAILED BOND DEBT SERVICE City of Schertz, Texas Tax Notes, Series 2010 Economic Development Corporation (EDC) Period Ending Principal Coupon Annual Interest Debt Service Debt Service 02/01/2013 255,000 2.000% 8,797.50 263,797.50 08/01/2013 61247.50 6,247.50 09/30/2013 270,045.00 02/01/2014 255,000 2.250% 6,247.50 261,247.50 08/01/2014 3,378.75 3,378.75 09/30/2014 264,626.25 02/01/2015 265,000 2.550% 3,378.75 268,378.75 09/30/2015 268,378.75 775,000 28,050.00 8037050.00 803,050.00 Sep 7, 2012 3:07 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- NOTESIO) Page 18 S S SOUTHWEST GROUP: SECURITIES BuiUuiy what t4ou value.' Sep 7, 2012 3:08 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- REF10) Page 19 BOND DEBT SERVICE City of Schertz, Texas General Obligation Refunding Bonds, Series 2010 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2013 2505000 2.500% 40,125 290,125 08/01/2013 37,000 37,000 09/30/2013 327,125 02/01/2014 2603000 2.500% 37,000 297,000 08/01/2014 33,750 33,750 09/30/2014 330,750 02/01/2015 265,000 3.000% 33,750 298,750 08/01/2015 29,775 29,775 09/30/2015 328,525 02/01/2016 275,000 3.000% 29,775 3045775 08/01/2016 25,650 25,650 09/30/2016 330,425 02/01/2017 285,000 3.000% 251650 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 3003000 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 61400 6,400 09/30/2020 3293000 02/01/2021 3201000 4.000% 6,400 326,400 09/30/2021 326,400 2155000 407,425 21957,425 2,957,425 Sep 7, 2012 3:08 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- REF10) Page 19 SWSISOUTHWEST GROUP: SECURITIES Builduuw what uou value.' BOND DEBT SERVICE Period Ending City of Schertz, Texas General Obligation Bonds, Series 2011 Pricing Principal Coupon Interest Debt Service Annual Debt Service 02/01/2013 2007000 5.000% 186,118.75 386,118.75 08/01/2013 181,118.75 181,118.75 09/30/2013 5671)237.50 02/01/2014 210,000 4.000% 1811118.75 391,118.75 08/01/2014 176,918.75 176,918.75 09/30/2014 568,037.50 02/01/2015 2201000 4.000% 176,918.75 396,918.75 08/01/2015 172,518.75 172,518.75 09/30/2015 569,437.50 02/01/2016 225,000 3.000% 172,518.75 397,518.75 08/01/2016 1695143.75 169,143.75 09/30/2016 5667662.50 02/01/2017 23511000 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 4051618.75 08/01/2018 161,418.75 161,418.75 09/30/2018 567,037.50 02/01/2019 25000 3.500% 1611418.75 411,418.75 08/01/2019 157,043.75 157,043.75 09/30/2019 568,462.50 02/01/2020 2601000 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 2703000 5.000% 151,843.75 421,843.75 08/01/2021 145,093.75 1457093.75 09/30/2021 566,937.50 02/01/2022 2857000 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 30000 5.500% 137,256.25 437,256.25 08/01/2023 129,006.25 1297006.25 09/30/2023 566,262.50 02/01/2024 3153000 4.000% 1291006.25 444,006.25 08/01/2024 1223706.25 1221706.25 09/30/2024 566,712.50 02/01/2025 33000 4.125% 122,706.25 452,706.25 08/01/2025 115,900.00 1157900.00 09/30/2025 56806.25 02/01/2026 3451P000 4.250% 115,900.00 460,900.00 08/01/2026 1081568.75 108,568.75 09/30/2026 569,468.75 02/01/2027 360,000 4.375% 10811568.75 4683568.75 08/01/2027 100,693.75 100,693.75 09/30/2027 5697262.50 02/01/2028 37500 4.500% 100,693.75 47503.75 08/01/2028 92,256.25 92,256.25 09/30/2028 5671950.00 02/01/2029 3903000 4.625% 923256.25 482,256.25 08/01/2029 83,237.50 83,237.50 09/30/2029 5651493.75 02/01/2030 410,000 4.750% 83,237.50 493,237.50 08/01/2030 733500.00 73,500.00 09/30/2030 5663737.50 02/01/2031 4303000 5.000% 733500.00 503,500.00 08/01/2031 62,750.00 62,750.00 09/30/2031 5661250.00 02/01/2032 4553000 5.000% 62,750.00 517,750.00 08/01/2032 51,375.00 51,375.00 09/30/2032 5691125.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 5003000 5.000% 39,500.00 539,500.00 08/01/2034 27,000.00 27,000.00 Sep 7, 2012 3:09 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -GOI 1P) Page 20 S S' SOUTH H Y EST GROUP SECURITIES BuUdinq what L4ou value' Sep 7, 2012 109 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -GOI 1P) Page 21 BOND DEBT SERVICE City of Schertz, Texas General Obligation Bonds, Series 2011 Pricing Period Annual Ending Principal Coupon Interest Debt Service Debt Service 09/30/2034 566,500.00 02/01/2035 525,000 5.000% 27,000.00 5521000.00 08/01/2035 13,875.00 133875.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 8,160,000 55462,806.25 13,622,806.25 13,622,806.25 Sep 7, 2012 109 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -GOI 1P) Page 21 SWS SO THWEST GROUP' SECURITIES BuiLd na what uou value." BOND DEBT SERVICE Period Ending Principal City of Schertz, Texas General Obligation Bonds, Series 2011 Coupon Interest Debt Service Annual Debt Service 03/01/2013 26,987.50 26,987.50 09/01/2013 285,000 2.000% 26,987.50 311,987.50 09/30/2013 338,975.00 03/01/2014 24,13 7.50 24,13 7.50 09/01/2014 29000 2.000% 24, 137.50 3143137.50 09/30/2014 338,275.00 03/01/2015 21,237.50 21,237.50 09/01/2015 3001000 2.000% 21,237.50 321,237.50 09/30/2015 342,475.00 03/01/2016 18,237.50 181237.50 09/01/2016 3007000 2.000% 18,237.50 3181237.50 09/30/2016 3367475.00 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 300.00 3,600.00 09/01/2021 2403000 3.000% 3,600.00 243,600.00 09/30/2021 2477200.00 2,4051000 276,425.00 2,6813425.00 27681,425.00 Sep 7, 2012 3:12 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -REFI 1) Page 22 SAYS SOUTHWEST GROUP SECURITIES BuMinq what uou value.' BOND DEBT SERVICE Period Ending City of Schertz, Texas Private Placement Refunding Bonds, Series 2011 -A Principal Coupon Interest Debt Service Annual Debt Service 02/01/2013 703000 2.330% 76,948.25 1461948.25 08/01/2013 76,132.75 76,132.75 09/30/2013 223,081.00 02/01/2014 6151000 2.330% 76,132.75 6911132.75 08/01/2014 68,968.00 68,968.00 09/30/2014 7603100.75 02/01/2015 610,000 2.330% 68,968.00 678,968.00 08/01/2015 61,861.50 61,861.50 09/30/2015 740,829.50 02/01/2016 6053000 2.330% 615861.50 666,861.50 08/01/2016 54,813.25 54,813.25 09/30/2016 721,674.75 02/01/2017 6203000 2.330% 54,813.25 67411813.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 4851000 2.330% 4011192.50 525,192.50 08/01/2019 343542.25 34,542.25 09/30/2019 559,734.75 02/01/2020 4753000 2.330% 34,542.25 509,542.25 08/01/2020 2908.50 2908.50 09/30/2020 538,550.75 02/01/2021 48500 2.330% 29,008.50 5145008.50 08/01/2021 23,358.25 231,358.25 09/30/2021 537,366.75 02/01/2022 67000 2.330% 23,358.25 693,358.25 08/01/2022 1511552.75 15,552.75 09/30/2022 708,911.00 02/01/2023 6751000 2.330% 1511552.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% 709.00 6673689.00 09/30/2024 6671689.00 6160500 996,366.25 7,601,366.25 7,601,366.25 Sep 7, 2012 3:13 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -REFI IA) Page 23 S SOUTHWEST GROUP SECURITIES BuUdina what uou value BOND DEBT SERVICE 7,62500 274593476.90 10,084,476.90 1030841476.90 Sep 7, 2012 3:14 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -GO12) Page 24 City of Schertz, Texas General Obligation Bonds, Series 2012 (After Adjustments) Period Annual Ending Principal Coupon Interest Debt Service Debt Service 02/01/2013 295,000 5.000% 1205579.38 415,579.38 08/01/2013 113,204.38 113,204.38 09/30/2013 528,783.76 02/01/2014 285,000 5.000% 113,204.38 398,204.38 08/01/2014 106,079.38 106,079.38 09/30/2014 504,283.76 02/01/2015 295,000 3.875% 106,079.38 4013079.38 08/01/2015 100,363.75 100,363.75 09/30/2015 501,443.13 02/01/2016 310,000 3.875% 100,363.75 410,363.75 08/01/2016 94,357.50 94,357.50 09/30/2016 504,721.25 02/01/2017 3201000 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 3351000 4.000% 87,397.50 4221397.50 08/01/2018 80,697.50 801697.50 09/30/2018 503,095.00 02/01/2019 3451000 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 3557000 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 36500 3.000% 71,922.50 436,922.50 08/01/2021 661447.50 66,447.50 09/30/2021 503,370.00 02/01/2022 3753000 2.250% 66,447.50 441,447.50 08/01/2022 623228.75 62,228.75 09/30/2022 503,676.25 02/01/2023 38500 2.250% 62,228.75 4471228.75 08/01/2023 571897.50 57,897.50 09/30/2023 505,126.25 02/01/2024 3903000 2.500% 573897.50 4477897.50 08/01/2024 533022.50 53,022.50 09/30/2024 500,920.00 02/01/2025 40000 2.700% 535022.50 453,022.50 08/01/2025 47,622.50 471P622.50 09/30/2025 5005645.00 02/01/2026 41511000 2.800% 473622.50 4627622.50 08/01/2026 41,812.50 415812.50 09/30/2026 504,435.00 02/01/2027 4255000 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 4403000 3.000% 351437.50 4757437.50 08/01/2028 28,837.50 281837.50 09/30/2028 504,275.00 02/01/2029 45000 3.000% 287837.50 4781837.50 08/01/2029 22,087.50 221087.50 09/30/2029 5001925.00 02/01/2030 4653000 3.000% 223087.50 487,087.50 08/01/2030 15,112.50 15,112.50 09/30/2030 502,200.00 02/01/2031 4801000 3.100% 15,112.50 4951112.50 08/01/2031 7,672.50 7,672.50 09/30/2031 5027785.00 02/01/2032 49500 3.100% 7,672.50 5023672.50 09/30/2032 502,672.50 7,62500 274593476.90 10,084,476.90 1030841476.90 Sep 7, 2012 3:14 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ -GO12) Page 24 S S ` ::SOUTHWEST GROUP SECURITIES Buddfnq what you value' BOND DEBT SERVICE City of Schertz, Texas S/S LGC Contract Revenue Bonds, Series 2001 Annual Period Debt Debt Ending Principal Coupon Interest Service Service 02/01/2013 260,000 08/01/2013 260,000 09/30/2013 02/01/2014 08/01/2014 260,000 09/30/2014 02/01/2015 260,000 08/01/2015 09/30/2015 520,000 02/01/2016 260,000 08/01/2016 260,000 09/30/2016 02/01/2017 08/01/2017 2601000 09/30/2017 02/01/2018 26000 08/01/2018 09/30/2018 520,000 02/01/2019 260,000 08/01/2019 2601000 09/30/2019 02/01/2020 08/01/2020 260,000 09/30/2020 02/01/2021 260,000 08/01/2021 09/30/2021 520,000 02/01/2022 2601000 08/01/2022 260,000 09/30/2022 02/01/2023 08/01/2023 26000 09/30/2023 02/01/2024 260,000 08/01/2024 09/30/2024 520,000 02/01/2025 260,000 08/01/2025 2601000 09/30/2025 02/01/2026 08/01/2026 260,000 09/30/2026 02/01 /2027 2601000 08/01/2027 09/30/2027 520,000 02/01/2028 260,000 08/01/2028 260,000 09/30/2028 02/01/2029 08/01/2029 2607000 09/30/2029 02/01/2030 260,000 08/01/2030 09/30/2030 520,000 02/01/2031 1,795,000 08/01/2031 2601000 09/30/2031 02/01/2032 1,895,000 08/01/2032 260,000 09/30/2032 02/01/2033 0951000 08/01/2033 09/30/2033 520,000 02/01/2034 23100,000 260,000 260,000 260,000 260,000 520,000 260,000 2601,000 260,000 260,000 520,000 260,000 260,000 260,000 260,000 520,000 2601000 2603000 2601000 26000 520,000 260,000 260,000 2601000 260,000 520,000 260,000 260,000 2601000 260,000 520,000 26000 2601000 260,000 26000 520,000 26000 260,000 2603000 260,000 520,000 2603000 260,000 2601000 260,000 520,000 260,000 260,000 260,000 2601000 520,000 2603000 260,000 260,000 260,000 520,000 2607000 2603000 26000 260,000 520,000 260;000 2601000 2601000 260,000 520,000 260,000 2601000 2603000 260,000 520,000 2601000 2603000 260,000 2601000 520,000 260,000 2603000 260,000 260,000 520,000 2603000 260,000 260,000 260,000 520,000 260,000 2607000 2603000 260,000 520,000 5.200% 260,000 2,0551000 213,330 213,330 2,268,330 5.200% 213,330 21108,330 164,060 164,060 2,272,390 5.200% 164,060 2,159,060 112,190 112,190 2,271,250 5.200% 1121190 2,212,190 Sep 7, 2012 3:14 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- LGCO1) Page 25 S S SOUTHWEST GROUP SECURITIES BuUdvtq what you value' Sep 7, 2012 3:14 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- LGCOI) Page 26 BOND DEBT SERVICE City of Schertz, Texas S/S LGC Contract Revenue Bonds, Series 2001 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,2727590 09/30/2035 2,272,590 10,000,000 10,714,340 20,714,340 20,714,340 Sep 7, 2012 3:14 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- LGCOI) Page 26 SWS 1 SOUTHWEST GROUP SECURITIES Buildirw what uou value BOND DEBT SERVICE City of Schertz, Texas S/S LGC Contract Revenue Bonds, Series 2005 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2013 430,000 4.000% 152,318.13 582,318.13 08/01/2013 143,718.13 143,718.13 09/30/2013 726,036.26 02/01/2014 450,000 4.000% 143,718.13 593,718.13 08/01/2014 134,718.13 1343718.13 09/30/2014 728,436.26 02/01/2015 47500 4.000% 1343718.13 609,718.13 08/01/2015 1253218.13 1253218.13 09/30/2015 734,936.26 02/01/2016 495,000 4.000% 1253218.13 620,218.13 08/01/2016 1153318.13 115,318.13 09/30/2016 735,536.26 02/01/2017 520,000 4.000% 115,318.13 635,318.13 08/01/2017 104,918.13 104,918.13 09/30/2017 740,236.26 02/01/2018 54000 4.000% 104,918.13 644,918.13 08/01/2018 94,118.13 94,118.13 09/30/2018 739,036.26 02/01/2019 560,000 4.000% 94,118.13 654,118.13 08/01/2019 821918.13 82,918.13 09/30/2019 7373036.26 02 /01/2020 585,000 4.100% 82,918.13 667,918.13 08/01/2020 70,925.63 70,925.63 09/30/2020 738,843.76 02/01/2021 610,000 4.150% 70,925.63 680,925.63 08/01/2021 58,268.13 58,268.13 09/30/2021 7393193.76 02/01/2022 6353000 4.200% 581268.13 6933268.13 08/01/2022 4411933.13 44,933.13 09/30/2022 7387201.26 02/01/2023 6651000 4.250% 44,933.13 709,933.13 08/01/2023 303801.88 305801.88 09/30/2023 7403735.01 02/01/2024 6951,000 4.300% 3001.88 725,801.88 08/01/2024 153859.38 151859.38 09/30/2024 74101.26 02/01/2025 72500 4.375% 151859.38 740,859.38 09/30/2025 740,859.38 7,385,000 211195,748.25 95580,748.25 9,580,748.25 Sep 7, 2012 3:15 pm Prepared by Southwest. Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- LGC05) Page 27 SY t S O V j i C H K EST GROUP: SECURITIES Buildutq what i4ou mluP" BOND DEBT SERVICE City of Schertz, Texas S/S LGC Contract Rev. and Ref. Bonds, Series 2007 Period Ending Principal Coupon Interest Debt Service Annual Debt Service 02/01/2013 515,000 4.000% 8187218.75 1,333,218.75 08/01/2013 807,918.75 807,918.75 09/30/2013 2,141,137.50 02/01/2014 53500 4.000% 807,918.75 1,342,918.75 08/01/2014 797,218.75 797,218.75 09/30/2014 2,140,137.50 02/01/2015 555,000 4.000% 797,218.75 1,352,218.75 08/01/2015 786,118.75 786,118.75 09/30/2015 2,13 8,33 7.50 02/01/2016 575,000 4.000% 786,118.75 1,361,118.75 08/01/2016 7743618.75 774,618.75 09/30/2016 2,135,737.50 02/01/2017 590,000 4.000% 774,618.75 1,364,618.75 08/01/2017 762,818.75 762,818.75 09/30/2017 2,127,437.50 02/01/2018 620,000 4.000% 7627818.75 1,382,818.75 08/01/2018 750,418.75 750,418.75 09/30/2018 2,133,237.50 02/01/2019 640,000 4.000% 750,418.75 17390,418.75 08/01/2019 737,618.75 737,618.75 09/30/2019 2,128,037.50 02/01/2020 6703000 4.125% 7373618.75 1,407,618.75 08/01/2020 7233800.00 723,800.00 09/30/2020 2,131,418.75 02/01/2021 6851000 4.250% 7233,800.00 17408,800.00 08/01/2021 709,243.75 709,243.75 09/30/2021 21118,043.75 02/01/2022 720,000 4.250% 7095243.75 1,4291243.75 08/01/2022 693,943.75 693,943.75 09/30/2022 2,123,187.50 02/01/2023 75000 4.250% 6935943.75 1,443,943.75 08/01/2023 67806.25 67806.25 09/30/2023 21,121,950.00 02/01/2024 78500 4.250% 678,006.25 1,4633006.25 08/01/2024 661,325.00 661,325.00 09/30/2024 2,124,331.25 02/01/2025 820,000 4.250% 661,325.00 1,481,325.00 08/01/2025 6433900.00 643,900.00 09/30/2025 2,125,225.00 02/01/2026 100,000 4.250% 6437900.00 21,303,900.00 08/01/2026 608,625.00 608,625.00 09/30/2026 2,912,525.00 02/01/2027 1,725,000 4.500% 608,625.00 21333,625.00 08/01/2027 5693812.50 569,812.50 09/30/2027 21903,437.50 02/01/2028 1,8103000 4.500% 569,812.50 2,379,812.50 08/01/2028 52907.50 529,087.50 09/30/2028 2,908,900.00 02/01/2029 1,89500 4.500% 529,087.50 2,42407.50 08/01/2029 4863450.00 4863450.00 09/30/2029 239101537.50 02/01/2030 1,9751000 4.500% 4861450.00 2,461,450.00 08/01/2030 442,012.50 4423012.50 09/30/2030 2,9037462.50 02/01/2031 290,000 4.500% 4421012.50 732,012.50 08/01/2031 4351487.50 4353487.50 09/30/2031 1,167,500.00 02/01/2032 3051000 4.500% 4351487.50 7403487.50 08/01/2032 428,625.00 428,625.00 09/30/2032 1,169,112.50 02/01/2033 3201000 4.500% 4283625.00 748,625.00 08/01/2033 4211425.00 421,425.00 09/30/2033 11170,050.00 02/01/2034 335,000 4.500% 421,425.00 756,425.00 08/01/2034 41311887.50 4133887.50 Sep 7, 2012 3:15 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- LGC07) Page 28 SWS: SOUTHWEST GROUP! SECURITIES Buddinq what uou mtuee Period Ending BOND DEBT SERVICE City of Schertz, Texas S/S LGC Contract Rev. and Ref. Bonds, Series 2007 Principal Coupon Interest Debt Service Annual Debt Service 09/30/2034 1,170,312.50 02/01/2035 3501000 4.500% 413,887.50 7631887.50 08/01/2035 406,012.50 406,012.50 09/30/2035 1,169,900.00 02/01/2036 2,675,000 4.500% 406,012.50 3,081,012.50 08/01/2036 345,825.00 345,825.00 09/30/2036 3,426,837.50 02/01/2037 2,800,000 4.500% 345,825.00 3,145,825.00 08/01/2037 282,825.00 282,825.00 09/30/2037 3,4283650.00 02/01/2038 2,9351000 4.500% 282,825.00 3,217,825.00 08/01/2038 216,787.50 216,787.50 09/30/2038 31434,612.50 02/01/2039 3,070,000 4.500% 216,787.50 3,2863787.50 08/01/2039 147,712.50 147,712.50 09/30/2039 3,434,500.00 02/01/2040 3,2101000 4.500% 147,712.50 33357,712.50 08/01/2040 751487.50 75,487.50 09/30/2040 3,433,200.00 02/01/2041 31355,000 4.500% 75,487.50 354301,487.50 09/30/2041 3,430,487.50 37, 170,000 3 1,492,243.75 68,662,243.75 687662,243.75 Sep 7, 2012 3:15 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- LGC07) Page 29 SWS SOUTH EST GROUP SECURITIES Buildirua what uou uatue.e BOND DEBT SERVICE Period Ending City of Schertz, Texas S/S LGC Contract Revenue Bonds, Series 2010 Principal Coupon Interest Debt Service Annual Debt Service 02/01/2013 475,543.75 475,543.75 08/01/2013 475,543.75 475,543.75 09/30/2013 951,087.50 02/01/2014 445,000 3.000% 475,543.75 920,543.75 08/01/2014 4683868.75 468,868.75 09/30/2014 1,389,412.50 02/01/2015 460,000 3.000% 468,868.75 9287868.75 08/01/2015 461,968.75 461,968.75 09/30/2015 1,3901837.50 02/01/2016 475,000 3.000% 4613968.75 936,968.75 08/01/2016 4547843.75 454,843.75 09/30/2016 1,391,812.50 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 50500 3.500% 447,568.75 952,568.75 08/01/2018 4383731.25 438,731.25 09/30/2018 11391,300.00 02/01/2019 5207000 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 5403000 3.500% 4297631.25 969,631.25 08/01/2020 4201,181.25 420,181.25 09/30/2020 133891,812.50 02/01/2021 56000 4.000% 420,181.25 9803181.25 08/01/2021 4087981.25 408,981.25 09/30/2021 1,3895162.50 02/01/2022 5853000 4.000% 408,981.25 993,981.25 08/01/2022 3971281.25 397,281.25 09/30/2022 113917262.50 02/01/2023 610,000 4.000% 3977281.25 1,007,281.25 08/01/2023 38511081.25 385,081.25 09/30/2023 1,3923362.50 02/01/2024 630,000 4.000% 38501.25 1,015,081.25 08/01/2024 372,481.25 372,481.25 09/30/2024 1:)387:1562.50 02/01/2025 66000 4.000% 37211481.25 1,032,481.25 08/01/2025 35911281.25 35911281.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 11389,434.38 02/01/2027 715,000 4.250% 345,153.13 110607153.13 08/01/2027 329,959.38 3291,959.38 09/30/2027 1,390,112.51 02/01/2028 74500 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 11094328.13 08/01/2029 297,553.13 2973553.13 09/30/2029 1,3911681.26 02/01/2030 81500 4.500% 2973553.13 13112,553.13 08/01/2030 279,215.63 2791,215.63 09/30/2030 091,768.76 02/01/2031 850,000 4.500% 2793215.63 1,129,215.63 08/01/2031 260,090.63 2601090.63 09/30/2031 13389,306.26 02/01/2032 8903000 4.500% 2607090.63 11150,090.63 08/01/2032 240,065.63 2401065.63 09/30/2032 1,390,156.26 02/01/2033 930,000 4.625% 2401065.63 111703065.63 08/01/2033 218,559.38 218,559.38 09/30/2033 1,388,625.01 02/01/2034 9753000 4.625% 218,559.38 1,193,559.38 08/01/2034 196,012.50 196,012.50 Sep 7, 2012 3:16 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- LGC10) Page 30 S S SO THWEST GROUP SECURITIES Buildinq what uou value.' Period Ending BOND DEBT SERVICE City of Schertz, Texas S/S LGC Contract Revenue Bonds, Series 2010 Principal Coupon Interest Debt Service Annual Debt Service 09/30/2034 1,389,571.88 02/01/2035 1,020,000 4.625% 1961012.50 1,216,012.50 08/01/2035 172,425.00 1723425.00 09/30/2035 1,388,437.50 02/01/2036 1,0701000 4.750% 1721425.00 1,242,425.00 08/01/2036 147,012.50 1471012.50 09/30/2036 1,3895437.50 02/01/2037 1,1253000 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,2351000 4.750% 921387.50 1,3273387.50 08/01/2039 633056.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 321300.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 22,14000 1717323856.33 39,8721856.33 39,872,856.33 Sep 7, 2012 3:16 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- LGC10) Page 31 S W SOUTHWEST GROUP SECURITIES Building u ml uou value BOND DEBT SERVICE Period Ending Schertz/Seguin Local Government Corporation (San Antonio Water System Expansion Water Treatment Project 2) Contract Revenue Bonds, Series 2012 Principal Coupon Interest Debt Service Annual Debt Service 02/01/2013 6263325.00 626,325.00 08/01/2013 469,743.75 469,743.75 09/30/2013 1,0961068.75 02/01/2014 469,743.75 469,743.75 08/01/2014 469,743.75 4691743.75 09/30/2014 9391487.50 02/01/2015 575,000 2.000% 469,743.75 130443743.75 08/01/2015 463,993.75 463,993.75 09/30/2015 111508,737.50 02/01/2016 5903000 2.000% 463,993.75 1,053,993.75 08/01/2016 458,093.75 458,093.75 09/30/2016 1,512,087.50 02/01/2017 600,000 2.000% 4585093.75 1,058,093.75 08/01/2017 452,093.75 452,093.75 09/30/2017 1,510,187.50 02/01/2018 620,000 4.000% 4521093.75 1,0721093.75 08/01/2018 439,693.75 439,693.75 09/30/2018 1,51 1,787.50 02/01/2019 645,000 4.000% 4391693.75 1,084,693.75 08/01/2019 426,793.75 426,793.75 09/30/2019 1151 1,487.50 02/01/2020 67000 4.000% 426,793.75 1,096,793.75 08/01/2020 4131393.75 413,393.75 09/30/2020 115101187.50 02/01/2021 70000 4.000% 413,393.75 1,113,393.75 08/01/2021 399,393.75 3993393.75 09/30/2021 15512,787.50 02/01/2022 7253000 4.000% 399,393.75 11124,393.75 08/01/2022 3841893.75 384,893.75 09/30/2022 135091287.50 02/01/2023 755,000 4.000% 384,893.75 1,1391893.75 08/01/2023 369,793.75 369,793.75 09/30/2023 13509,687.50 02/01/2024 785,000 4.000% 369,793.75 1,154,793.75 08/01/2024 3543093.75 354,093.75 09/30/2024 11,508,887.50 02/01/2025 8153000 3.000% 354,093.75 1,169,093.75 08/01/2025 3413868.75 3411,868.75 09/30/2025 1,510,962.50 02/01/2026 84000 3.000% 341,868.75 1,1811868.75 08/01/2026 329,268.75 3295268.75 09/30/2026 11511,137.50 02/01/2027 8655000 3.125% 32911268.75 1,194,268.75 08/01/2027 315,753.13 3151753.13 09/30/2027 1,510,021.88 02/01/2028 89500 3.625% 3153753.13 11210,753.13 08/01/2028 299,531.25 299,531.25 09/30/2028 1,510,284.3 8 02/01/2029 93000 3.625% 299,531.25 1 ,229153 1.25 08/01/2029 282,675.00 282,675.00 09/30/2029 11512,206.25 02/01/2030 96500 3.625% 2823675.00 1,2473675.00 08/01/2030 2655184.38 2651184.38 09/30/2030 1,512,859.38 02/01/2031 1,000,000 3.625% 2657184.38 111265,184.38 08/01/2031 2471059.38 247,059.38 09/30/2031 1,512,243.76 02/01/2032 1,0353000 3.625% 247,059.38 1128211059.38 08/01/2032 2283300.00 228,300.00 09/30/2032 135103359.38 02/01/2033 13075,000 4.000% 228,300.00 1,303,300.00 08/01/2033 2063800.00 2061800.00 09/30/2033 1,510,100.00 02/01/2034 1,1203000 4.000% 20600.00 133263800.00 Sep 7, 2012 3:17 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- LGC12) Page 32 SWS 1 SOUTHWEST GROUP SECURITIES Budd nq LvhW tjou value.' Period Ending BOND DEBT SERVICE Schertz/Seguin Local Government Corporation (San Antonio Water System Expansion Water Treatment Project 2) Contract Revenue Bonds, Series 2012 Principal Coupon Interest Debt Service Annual Debt Service 08/01/2034 184,400.00 184,400.00 09/30/2034 1,511,200.00 02/01/2035 13165,000 4.000% 184,400.00 1,349,400.00 08/01/2035 161,100.00 161,100.00 09/30/2035 1,510,500.00 02/01/2036 1,210,000 4.000% 161,100.00 1,371,100.00 08/01/2036 136,900.00 136,900.00 09/30/2036 1,508,000.00 02/01/2037 1,260,000 4.000% 136,900.00 1,396,900.00 08/01/2037 111,700.00 111,700.00 09/30/2037 11508,600.00 02/01/2038 1,3153000 4.000% 111,700.00 1,426,700.00 08/01/2038 85,400.00 85,400.00 09/30/2038 1,512,100.00 02/01/2039 1,365,000 4.000% 85,400.00 1,450,400.00 08/01/2039 58,100.00 58,100.00 09/30/2039 1,5087500.00 02/01/2040 1,42500 4.000% 581100.00 11483,100.00 08/01/2040 29,600.00 29,600.00 09/30/2040 1115127700.00 02/01/2041 1,4803000 4.000% 29,600.00 1,50900.00 09/30/2041 1,509,600.00 25,42500 17,397,056.28 423822,056.28 42,822,056.28 Sep 7, 2012 3:17 pm Prepared by Southwest Securities, Inc. (Finance 7.002 Schertz:SCHERTZ- LGC12) Page 33