{"text_format":"2","workbook":"xlsx","n_sheets":8,"sheets":["Table of Contents","1 - Contact Information","2 - Individual Debt Obligations","3 - Summary of Debt Obligations","Hide","4 - Additional Notes","5 - Optional Reporting","6 - Instructions and Glossary"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Table of Contents","index":0,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Texas Comptroller’s Annual Local Debt Report"]
["Table of Contents"]
["1 - Contact Information"]
["2 - Individual Debt Obligations"]
["3 - Summary of Debt Obligations"]
["4 - Additional Notes"]
["5 - Optional Reporting"]
["6 - Instructions and Glossary"]
["End of Worksheet"]

{"sheet":"1 - Contact Information","index":1,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
["Texas Comptroller’s Annual Local Debt Report"]
["Fill in the cells in column B that correspond with the requested information. (*) indicates required information. "]
["Entity Information"]
["Political Subdivision Name*:","City of Bryan, Texas"]
["Political Subdivision Type*:","City"]
["If \"other\", please specify"]
["Reporting Fiscal Year*:",2018]
["Fiscal Year Start (MM/DD/YYYY)*:","2017-10-01"]
["Fiscal Year End (auto):",{"$f":"IF(ISBLANK(B8),\"\",DATE(YEAR(B8)+1,MONTH(B8),DAY(B8)-1))","v":"2018-09-30"}]
["Political Subdivision Website, if applicable:","www.bryantx.gov"]
["Political Subdivision Telephone*:","979-209-5080"]
["Political Subdivision Email, if applicable:"]
["Does the Political Subdivision have any reportable debt?*","Yes"]
[]
["Contact Information"]
["Contact Name*:","Alicia Kenney"]
["Contact Title*:","Senior Accountant"]
["Contact Phone*:","979-209-5080"]
["Contact Email:","akenney@bryantx.gov"]
["Physical Address, Line 1*:","300 S. Texas Ave."]
["Physical Address, Line 2:"]
["City*:","Bryan"]
["Zip*:",77803]
["County*:","Brazos"]
["Is the entity's physical and mailing address the same?*","No"]
["Mailing Address, Line 1:","P.O. Box 1000"]
["Mailing Address, Line 2:"]
["Mailing City:","Bryan"]
["Mailing Zip:",77805]
["Mailing County:","Brazos"]
["End of Worksheet"]

{"sheet":"2 - Individual Debt Obligations","index":2,"n_rows":111,"n_cols":19,"rows_kept":111,"cut":false,"hidden":false,"merged":[]}
["Texas Comptroller’s Annual Local Debt Report"]
["Entity Information (Auto)"]
["Political Subdivision Name:",{"$f":"IF('1 - Contact Information'!B4=\"\",\"\",'1 - Contact Information'!B4)","v":"City of Bryan, Texas"}]
["Reporting Fiscal Year:",{"$f":"IF(OR('1 - Contact Information'!B7=\"\",'1 - Contact Information'!B7=\"(select)\"),\"\",'1 - Contact Information'!B7)","v":2018}]
[]
["Directions: Beginning with the row immediately below the column headings, list each of the political subdivision's individual debt obligations along with the information for each obligation. Every column except B, Q, R and S is required for each debt obligation and must be provided for this report to be considered complete."]
["All information entered should reflect the last day of the political subdivision's fiscal year identified on this form. If the political subdivision has no debt to report for the fiscal year, enter \"No Reportable Debt\" in the first cell below the column title in column A."]
["Individual Debt Obligations (click column titles for more information)"]
["Outstanding debt obligation*","If debt is conduit or component debt, enter related entity name:","Principal issued*","Principal outstanding*","Combined principal and interest required to pay each outstanding debt obligation on time and in full*","Final maturity date* (MM/DD/YYYY)","Is the debt secured in any way by ad valorem taxes?*","Total proceeds received*","Proceeds spent*","Proceeds unspent*","Official stated purpose for which the debt obligation was authorized*","Is the debt obligation rated by any nationally recognized credit rating organization?*","Moody's","S&P","Fitch","Kroll","Other rating (if applicable)","Optional: Explanation of repayment source ","Optional: Comments or additional information per individual debt obligation"]
["General Obligation Refunding, Series 2010",null,10635000,3300000,3567600,"2021-08-15","Yes",11011119.4,11011119.4,{"$f":"H10-I10","v":0},"Proceeds from the sale of the Bonds will be used to refund a portion of the City’s outstanding general obligation debt and to pay certain costs of issuance of the Bonds. (Refunded Obligations include: 1998 CO's & 2001A Water & Wastewater CO's)","Yes","Aa3","AA","Not Rated","Not Rated"]
["General Obligation Refunding, Series 2013",null,27685000,16980000,{"$f":"19022713-2","v":19022711},"2026-08-15","Yes",27811772.399999999,27811772.399999999,{"$f":"H11-I11","v":0},"Proceeds from the sale of the Bonds will be used (1) for the acquisition, construction, replacement and repair ro the City's rural electric system; (2 )to refund a portion of the City's outstanding debt (the \"Refunded Obligations\"), for debt service savings, and (3) to pay costs of issuing the Obligations. (Refunded Obligations include: 2001, 2003, 2004, 2005 CO's, 2004 and 2005 Water & Wastewater Revenue Bonds) ","Yes","Not Rated","AA","Not Rated","Not Rated"]
["General Obligation Refunding, Series 2014",null,9245000,6975000,8315883,"2031-08-15","Yes",9322079.9100000001,9322079.9100000001,0,"Proceeds from the sale of the Bonds will be used (i) to refund a portion of the City’s outstanding debt (the “Refunded Obligations”), for debt service savings, and (ii) to pay the costs of issuing the Bonds. (Refunded obligations include 2005 CO's & 2005 Water & Wastewater Revenue Bonds)","Yes","Not Rated","AA","Not Rated","Not Rated"]
["General Obligation Refunding, Series 2015",null,19480000,12915000,{"$f":"12915000+1576425","v":14491425},"2025-08-15","Yes",20404064.510000002,20404064.510000002,{"$f":"H13-I13","v":0},"Proceeds from the sale of the Bonds will be used (i) to refund a portion of the City's outstanding debt (the \"Refunded Obligations\"), for debt service savings, and (ii) to pay costs of issuing the Bonds. (Refunded Obligations include: 2005 GO's & 2005 Electric Revenue Bonds)","Yes","Not Rated","AA","Not Rated","Not Rated"]
["General Obligation Refunding, Series 2016",null,7755000,6295000,{"$f":"6295000+704950","v":6999950},"2026-08-15","Yes",8127164.9800000004,8127164.9800000004,{"$f":"H14-I14","v":0},"Proceeds from the sale of the Bonds will be used (i) to refund a portion of the City's outstanding debt (the \"Refunded Obligations\"), for debt service savings, and (ii) to pay costs of issuing the Bonds. (Refunded Obligations are 2007 CO's)","Yes","Not Rated","AA","Not Rated","Not Rated"]
["General Obligation Refunding, Series 2018",null,6265000,6265000,{"$f":"6265000+1227930","v":7492930},"2028-08-15","Yes",6579046.4000000004,6579046.4000000004,0,"Proceeds from the sale of the Bonds will be used (i) to refund a portion of the City’s outstanding debt (the “Refunded Obligations”), for debt service savings, and (ii) to pay the costs of issuing the Bonds. (Refunded Obligations are 2008 CO's)","Yes","Not Rated","AA","Not Rated","Not Rated"]
["Certificate of Obligation-Combination Tax \n& Revenue, Series 2009",null,8730000,5260000,{"$f":"5260000+1474328","v":6734328},"2029-08-15","Yes",8840228.2200000007,8840228.2200000007,0,"Proceeds from the sale of the Certificates will be used to pay contractual obligations incurred for (i) constructing, improving, renovating, extending, expanding and developing streets, including drainage, traffic signalization, lighting, sidewalks, and landscaping; (ii) equipping a municipal golf course; and (iii) professional services, including legal, fiscal, engineering and design fees, and costs of issuance.","Yes","Aa3","AA","Not Rated","Not Rated"]
["Certificate of Obligation-Combination Tax \n& Revenue, Series 2010",null,13790000,8835000,{"$f":"8835000+2504175","v":11339175},"2030-08-15","Yes",13968726.189999999,{"$f":"H17","v":13968726.189999999},0,"Proceeds from the sale of the Certificates will be used to pay contractual obligations incurred for (i) constructing, improving, renovating, extending, expanding and developing streets, including drainage, traffic signalization, lighting, sidewalks, soundwalls and landscaping, and acquiring right-of-way related thereto,  (ii) restoring historic structures, (iii)acquiring, purchasing, constructing, improving, renovating, enlarging, and equipping property, buildings, structures, facilities, and related infrastructure for a solid waste disposal system, and (iv) professional services, including legal, fiscal, engineering and design fees, and costs of issuance.","Yes","Aa3","AA","Not Rated","Not Rated"]
["Certificate of Obligation-Combination Tax \n& Revenue Refunding, Series 2011, CTRR","Water & Wastewater",10785000,3580000,{"$f":"3580000+335669","v":3915669},"2022-07-01","Yes",11387608.300000001,11387608.300000001,{"$f":"H18-I18","v":0},"Proceeds from the sale of the Bonds will be used to refund a portion of the City's outstanding System debt and to pay certain costs of issuance of the Bonds. (Refunded Obligations are 2001 Water & Wastewater Revenue Bonds)","Yes","Aa2","AA","Not Rated","Not Rated"]
["Certificate of Obligation-Combination Tax \n& Revenue, Series 2013","Bryan Texas Utilities",5600000,4495000,{"$f":"4495000+1580978","v":6075978},"2033-08-15","Yes",5652871.0999999996,{"$f":"H19-J19","v":5652871.0999999996},0,"Proceeds from the sale of the Bonds will be used for the acquisition, construction, replacement and repair of substations, feeders and other distribution improvements to the City's rural electric system.","Yes","Not Rated","AA","Not Rated","Not Rated"]
["Certificate of Obligation-Combination Tax \n& Revenue, Series 2014","Partial Bryan Texas Utilities",42615000,36715000,51748834,"2039-08-15","Yes",42683738.170000002,{"$f":"H20","v":42683738.170000002},0,"Proceeds from the sale of the Certificates will be used for (i) the acquisition and construction of improvements, additions and extensions to the City’s electric system, including facilities for the transmission and distribution of electric power and energy, (ii) constructing, improving, renovating, extending, expanding and developing streets, including drainage, traffic signalization, lighting, sidewalks, soundwalls and landscaping, and acquiring right-of-way related thereto, (iii) the purchase of fire-fighting equipment, including fire trucks, and (iv) related professional services, including legal, fiscal, engineering and design fees, and costs of issuance of the Certificates.","Yes","Not Rated","AA","Not Rated","Not Rated"]
["Certificate of Obligation-Combination Tax \n& Revenue, Series 2016",null,10435000,9485000,{"$f":"9485000+2641244","v":12126244},"2036-08-15","Yes",10919567.43,{"$f":"+H21-J21","v":9434179.1999999993},{"$f":"890662.22+506788.2+63937.81+24000","v":1485388.23},"Proceeds from the sale of the Certificates will be used for (i) constructing, improving, renovating, extending, expanding and developing streets, including drainage, traffic signalization, lighting, sidewalks, soundwalls and landscaping, and acquiring right-of-way related thereto, (ii) constructing, renovating and improving fire department facilities and purchasing fire fighting equipment, including fire trucks; (iii) constructing, renovating and improving airport facilities, including hangars; and (iv) related professional services, including legal, fiscal, engineering and design fees, and costs of issuance of the Certificates.","Yes","Not Rated","AA","Not Rated","Not Rated"]
["Certificate of Obligation-Combination Tax \n& Revenue, Series 2018",null,11965000,11965000,{"$f":"11965000+4845605","v":16810605},"2038-08-15","Yes",12324537.779999999,{"$f":"+H22-J22","v":6618284.6399999997},{"$f":"5613753.14+92500","v":5706253.1399999997},"Proceeds from the sale of the Certificates will be used for (i) constructing, improving, renovating, extending, expanding and\ndeveloping streets, including drainage, traffic signalization, lighting, sidewalks, soundwalls and landscaping, and acquiring right-of-way\nrelated thereto; (ii) constructing, renovating and improving fire department facilities and purchasing fire-fighting equipment, including\nfire trucks; and (iii) related professional services, including legal, fiscal, engineering and design fees, and costs of issuance of the\nCertificates.","Yes","Not Rated","AA","Not Rated","Not Rated"]
["Water and Sewer System Revenue, \nSeries 2009A","Water & Wastewater",5680000,3625000,4633174.75,"2029-07-01","No",5689564.6200000001,{"$f":"H23","v":5689564.6200000001},0,"Proceeds from the sale of the Bonds will be used (i) to construct, improve, repair, renovate, enlarge, extend and equip the Waterworks and Sewer System and (ii) to pay the costs of issuing of the Bonds.","Yes","Aa2","AAA","Not Rated","Not Rated"]
["Sewer System Revenue, Series 2009B","Wastewater",1270000,145000,{"$f":"145000+3770","v":148770},"2019-07-01","No",{"$f":"1246932+23068","v":1270000},{"$f":"H24","v":1270000},0,"The Bonds are being issued for the purpose financing improvements and extensions to the Waterworks and Sewer System and paymg the costs of issuing the Bonds.","No"]
["Water Revenue, Series 2010A","Water",5105000,3485000,4448888,"2030-07-01","No",5126949.43,{"$f":"+H25-J25","v":4922601.01},{"$f":"159405.42+44943","v":204348.42},"Proceeds from the sale of the Bonds will be used (i) to construct, improve, repair, renovate, enlarge, extend and equip the Waterworks and Sewer System and (ii) to pay the costs of issuing of the Bonds.","Yes","Aa2","A+","Not Rated","Not Rated"]
["Sewer System Revenue, Series 2011","Wastewater",15685000,12875000,{"$f":"12875000+1631295","v":14506295},"2030-07-01","No",15400098,15400098,{"$f":"H26-I26","v":0},"The Bonds are being issued for the purpose of (i) constructing, improving, repairing, renovating, enlarging, extending and equipping the Waterworks an Sewer System and (ii) paying the costs of issuing the Bonds.","No"]
["Water and Sewer System Revenue, \nSeries 2016A","Water",4370000,4015000,{"$f":"4015000+1270400","v":5285400},"2036-07-01","No",4501212,{"$f":"+H27-J27","v":2290404.19},{"$f":"1653845.31+556962.5","v":2210807.81},"Proceeds from the sale of the Bonds will be used for (i) constructing, improving, repairing, renovating, enlarging, extending and equip the Waterworks and Sewer System, and (ii) paying related professional services, including legal, fiscal, engineering and design fees, and costs of issuance of the Bonds.","Yes","Not Rated","AA−","Not Rated","Not Rated"]
["Water and Sewer System Revenue, \nSeries 2016B","Water",2345000,2170000,{"$f":"2170000+627947","v":2797947},"2041-07-01","No",2345000,{"$f":"+H28-J28","v":358582.83000000007},{"$f":"322004+1664413.17","v":1986417.17},"Proceeds from the sale of the Bonds will be used for (i) constructing, improving, repairing, renovating, enlarging, extending and equip the Waterworks and Sewer System, and (ii) paying related professional services, including legal, fiscal, engineering and design fees, and costs of issuance of the Bonds.","No"]
["Water and Sewer System Revenue, \nSeries 2017","Water & Wastewater",19900000,17450000,{"$f":"17450000+3731900","v":21181900},"2032-07-01","No",21708122,{"$f":"H29","v":21708122},{"$f":"H29-I29","v":0},"Proceeds from the sale of the Bonds will be used to refund a portion of the City’s outstanding 2007 Waterworks and Sewer System Revenue Bonds in order to provide debt service savings for the City, to purchase a surety bond to fund the 2017 Reserve Fund, and to pay issuance costs on the Bonds.","Yes","Not Rated","AA","Not Rated","Not Rated"]
["Electric System Revenue City, Series 2010","Bryan Texas Utilities",64190000,20975000,{"$f":"20975000+1048750","v":22023750},"2019-07-01","No",68988702.650000006,{"$f":"H30","v":68988702.650000006},0,"Proceeds from the sale of the Bonds will be used (i) to refund certain contractual obligations of the City incurred pursuant to a power sales contract between the City and the Texas Municipal Power Agency, (ii) to fund a reserve fund, and (iii) to pay the costs associated with the issuance of the Bonds.","Yes","A2","A+","A+","Not Rated"]
["Electric System Revenue Rural, Series 2011","Bryan Texas Utilities",3045000,1005000,{"$f":"1005000+77950","v":1082950},"2021-07-01","No",3115081.8,{"$f":"H31","v":3115081.8},0,"Proceeds from the sale of the Bonds will be used for the acquisition, equipment, improvement and expansion of the System and to pay the costs associated with the issuance of the Bonds. ","Yes","A2","A+","A+","Not Rated"]
["Electric System Revenue City, Series 2012","Bryan Texas Utilities",65675000,39130000,{"$f":"39130000+17578800","v":56708800},"2037-07-01","No",70588679.849999994,{"$f":"H32","v":70588679.849999994},0,"Proceeds from the sale of the Bonds will be used for (i) transmission system improvements, (ii) the acquisition and installation of automated metering, (iii) refunding portions of oustanding bonds for debt service savings, (iv) funding a reserve fund, and (v) to pay the costs of issuance.","Yes","A2","A+","A+","Not Rated"]
["Electric System Revenue City, Series 2016","Bryan Texas Utilities",71435000,70680000,{"$f":"70680000+38796650","v":109476650},"2041-07-01","No",82623854.650000006,{"$f":"H33-J33","v":59898784.650000006},22725070,"Proceeds from the sale of the Bonds will be used for (i) financing costs or expenses incurred in relation to the acquisition or construction of improvements, additions, or extensions to the Electric System, including facilities for the generation, transmission, or distribution of electric power and energy, and capital assets, facilities and equipment incident and related to the operation, maintenance, or administration of the Electric System; (ii) funding the reserve fund requirement for the Bonds with a municipal bond reserve fund insurance policy issued by Assured Guaranty Municipal Corp.; (iii) refunding portions of outstanding bonds for debt service savings and (iv) paying the cost of issuing the Bonds.","Yes","Not Rated","A+","A+","Not Rated"]
["Electric System Revenue Rural, Series 2016","Bryan Texas Utilities",15770000,14945000,{"$f":"14945000+6552500","v":21497500},"2041-07-01","No",17180560.5,{"$f":"H34-J34","v":17180560.5},0,"Proceeds from the sale of the Bonds will be used for (i) financing costs or expenses incurred in relation to the acquisition or construction of improvements, additions, or extensions to the Rural System, including facilities for the generation, transmission, or distribution of electric power and energy, and capital assets, facilities and equipment incident and related to the operation, maintenance, or administration of the Rural System; (ii) funding the reserve fund requirement for the Bonds with a municipal bond reserve fund insurance policy issued by Assured Guaranty Municipal Corp.; (iii) refunding portions of outstanding bonds for debt service savings, and (iv) paying the cost of issuing the Bonds.","Yes","Not Rated","A+","A+","Not Rated"]
["Electric System Revenue City, Series 2017","Bryan Texas Utilities",57225000,54690000,{"$f":"54690000+20922250","v":75612250},"2034-07-01","No",69063020.700000003,{"$f":"H35-J35","v":69063020.700000003},0,"Proceeds from the sale of the Bonds will be used (i) to refund portions of the City's outstanding bonds for debt service savings, (ii) to purchase a surety bond to fund the reserve fund requirement for the Bonds, and (iii) for paying the costs of issuing the Bonds.","Yes","Not Rated","A+","A+","Not Rated"]
["Authorized but Unissued - 1984","Streets",0,0,0,"N/A","No",0,0,{"$f":"H36-I36","v":0},"Authorized but Unissued","No",{"$nulls":6},"Authorized but Unissued - $8,225,000"]
["Authorized but Unissued - 1984","Parks",0,0,0,"N/A","No",0,0,0,"Authorized but Unissued","No",{"$nulls":6},"Authorized but Unissued - $1,775,000"]
["Authorized but Unissued - 1984","Railroad Grade Separation",0,0,0,"N/A","No",0,0,0,"Authorized but Unissued","No",{"$nulls":6},"Authorized but Unissued - $2,850,000"]
["Authorized but Unissued - 1984","Sanitary Landfill",0,0,0,"N/A","No",0,0,0,"Authorized but Unissued","No",{"$nulls":6},"Authorized but Unissued - $200,000"]
["Authorized but Unissued - 1984","Sanitary Landfill",0,0,0,"N/A","No",0,0,0,"Authorized but Unissued","No",{"$nulls":6},"Authorized but Unissued - $200,000"]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,{"$f":"H62-I62","v":0}]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
[null,null,0,0,0,null,null,0,0,0]
["End of Worksheet",null,null,"End of Worksheet"]

{"sheet":"3 - Summary of Debt Obligations","index":3,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Texas Comptroller’s Annual Local Debt Report"]
["Entity Information (Auto)"]
["Political Subdivision Name:",{"$f":"IF('1 - Contact Information'!B4=\"\",\"\",'1 - Contact Information'!B4)","v":"City of Bryan, Texas"}]
["Reporting Fiscal Year:",{"$f":"IF(OR('1 - Contact Information'!B7=\"\",'1 - Contact Information'!B7=\"(select)\"),\"\",'1 - Contact Information'!B7)","v":2018}]
[]
["Directions: Fill in the cells in column B that correspond with the requested information. "]
["All information entered should reflect the last day of the political subdivision's fiscal year identified on this form."]
["If there is no debt to report for the fiscal year, enter \"N/A\" or \"$0\" in each cell along column B."]
["Total Tax-Supported and Revenue Debt "]
["Total authorized debt obligations:",{"$f":"SUM('2 - Individual Debt Obligations'!C:C)+13050000","v":529730000}]
["Total principal of all outstanding debt obligations:",{"$f":"SUM('2 - Individual Debt Obligations'!D:D)","v":378255000}]
["Combined principal and interest required to pay all outstanding debt obligations on time and in full:",{"$f":"SUM('2 - Individual Debt Obligations'!E:E)","v":508045606.75}]
[]
["Total debt secured by Ad Valorem Taxation (includes combination tax and revenue debt obligations) "]
["Total authorized debt obligations secured by ad valorem taxation:",{"$f":"SUM('2 - Individual Debt Obligations'!C10:C22)","v":184985000}]
["Total principal of all outstanding debt obligations secured by ad valorem taxation:",{"$f":"SUM('2 - Individual Debt Obligations'!D10:D22)","v":133065000}]
["Combined principal and interest required to pay all outstanding debt obligations secured by ad valorem taxation on time and in full:",{"$f":"SUM('2 - Individual Debt Obligations'!E10:E22)","v":168641332}]
[]
["Per Capita Total Debt secured by Ad Valorem Taxation  (required for municipalities, counties, and school districts only) "]
["Population of the political subdivision:",84021]
["Source and year of population data:","U.S. Census Bureau and https://www.census.gov/quickfacts/fact/table/bryancitytexas,US/PST045218"]
["Total authorized debt obligations secured by ad valorem taxation expressed as a per capita amount:",{"$f":"+B15/B20","v":2201.6519679603907}]
["Total principal of outstanding debt obligations secured by ad valorem taxation as a per capita amount:",{"$f":"+B16/B20","v":1583.7112150533794}]
["Combined principal and interest required to pay all outstanding debt obligations secured by ad valorem taxation on time and in full as a per capita amount:",{"$f":"+B17/B20","v":2007.1331214815343}]
["End of Worksheet"]

{"sheet":"Hide","index":4,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["(select)","(select)","(select)","Moody's","S&P","Fitch","Kroll","N/A - No Reportable Debt"]
["Yes","City",2016,"(select)","(select)","(select)","(select)"]
["No","County",{"$f":"C2+1","v":2017},"Not Rated","Not Rated","Not Rated","Not Rated"]
[null,"ISD",{"$f":"C3+1","v":2018},"Aaa","AAA","AAA","AAA"]
[null,"CCD",2019,"Aa1","AA+","AA+","AA"]
[null,"Water District",2020,"Aa2","AA","AA","A"]
[null,"Other",null,"Aa3","AA−","AA−","BBB"]
[null,null,null,"A1","A+","A+","BB"]
[null,null,null,"A2","A","A","B"]
[null,null,null,"A3","A−","A−","CCC"]
[null,null,null,"Baa1","BBB+","BBB+","CC"]
[null,null,null,"Baa2","BBB","BBB","C"]
[null,null,null,"Baa3","BBB−","BBB−","D"]
[null,null,null,"Ba1","BB+","BB+"]
[null,null,null,"Ba2","BB","BB"]
[null,null,null,"Ba3","BB−","BB−"]
[null,null,null,"B1","B+","B+"]
[null,null,null,"B2","B","B"]
[null,null,null,"B3","B−","B−"]
[null,null,null,"Caa","CCC","CCC"]
[null,null,null,"Ca","CC","CC"]
[null,null,null,"C","C","C"]
[{"$nulls":4},"D","D"]
{"$rows_empty":7}
["Protection Pasword:",null,"hb1378"]

{"sheet":"4 - Additional Notes","index":5,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Texas Comptroller’s Annual Local Debt Report"]
["Additional Notes (optional)"]
["Please use this space to enter any other information the political subdivision considers relevant or necessary to explain information submitted in this report."]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
["End of Worksheet"]

{"sheet":"5 - Optional Reporting","index":6,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Texas Comptroller’s Annual Local Debt Report"]
["Optional Reporting"]
["Directions: Please complete each of the cells in the right-most column (column E) for all debt obligations in aggregate (or total) as of the last day of the political subdivision's most recently completed fiscal year."]
["For political subdivisions other than school districts, municipalities and counties"]
["Item #","Optional Item","Instructions","References, Local Government Code","Response"]
[1,"Total authorized debt obligations secured by ad valorem taxation expressed as a per capita amount for political subdivisions other than municipalities, school districts and counties. ","Sum all authorized debt obligations secured in any way by ad valorem taxation that have yet to be repaid. Include combination tax and revenue debt in this calculation. Divide this sum by the population of the political subdivision for the corresponding year of debt obligation data.","140.008(b)(3)(A)"]
[2,"Population total used to calculate per capita figure in #1:","The denominator used to calculate per capita figure requested in #1.This is a population total for your entity. ","140.008(b)(3)(A)"]
[3,"Source and year of population estimate used to calculate per capita figure in #1: ","The source of population data comprising the denominator of per capita figure in #1.","140.008(b)(3)(A)"]
[4,"Total principal on outstanding debt obligations secured by ad valorem taxation expressed as a per capita amount:","Sum the total amount borrowed of all obligations secured in any way by ad valorem taxation that have yet to be repaid. Include combination tax and revenue debt obligations in this total. Ensure that the population data matches time frame of the fiscal year for which you are reporting.","140.008(b)(3)(A)"]
[5,"Population total used to calculate per capita figure in #4:","The denominator used to calculate per capita figure requested in #4.This is a population total for your entity. ","140.008(b)(3)(A)"]
[6,"Source and year of population estimate used to calculate per capita figure in #4: ","The source of population data comprising the denominator of per capita figure in #4.","140.008(b)(3)(A)"]
[7,"Total combined principal and interest required to pay all outstanding ad valorem-secured debt obligations on time and in full, expressed as a per capita amount:","Sum the total amount borrowed of all obligations secured in any way by ad valorem taxation that have yet to be repaid. Include combination tax and revenue debt obligations in this total. Add to this the cost of debt service for these debt obligations. Divide this total by the population of the political subdivision. Ensure that the population data matches time frame of the fiscal year for which you are reporting.","140.008(b)(3)(A)"]
[8,"Population total used to calculate per capita figure in #7:","The denominator used to calculate per capita figure requested in #7.This is a population total for your entity. ","140.008(b)(3)(A)"]
[9,"Source and year of population estimate used to calculate per capita figure in #7: ","The source of population data comprising the denominator of per capita figure in #7.","140.008(b)(3)(A)"]
[]
["For all political subdivisions"]
["Item #","Optional Item","Instructions","References, Local Government Code","Response"]
[10,"Total authorized and outstanding debt obligations secured by ad valorem taxation, expressed as a per capita amount, projected as of the last day of the maximum term of the most recent debt obligation:","Sum any and all authorized debt obligations secured in any way by ad valorem taxation that have yet to be repaid. Include combination tax and revenue debt obligations in this total. Divide this by the projected population of the political subdivision as of the entity's last day of the maximum term of the most recently issued debt obligation. ","140.008(b)(3)(C)"]
[11,"Population projection total used to calculate per capita figure in #10:","The denominator used to calculate per capita figure requested in #10.This is a population projection total for your entity. ","140.008(b)(3)(C)"]
[12,"Source and year of population projection used to calculate per capita figure in #10: ","The source of population projection comprising the denominator of per capita figure in #10.","140.008(b)(3)(C)"]
[13,"Date of last day of maximum term of most recently issued debt obligation in #10(MM/DD/YYYY):","The bill asks for the \"most recent debt obligation\" which is interpreted to mean the most recently issued debt obligation issued by the political subdivision. ","140.008(b)(3)(C)"]
[14,"Total principal on outstanding debt obligations secured by ad valorem taxation expressed as a per capita amount, projected as of the last day of the maximum term of the most recently issued debt obligation:","Sum the total amount borrowed of all obligations secured in any way by ad valorem taxation that have yet to be repaid. Include combination tax and revenue debt obligations in this total. Divide by the projected population total for the political subdivision corresponding to the last day of the maximum term of the most recently issued debt obligation.","140.008(b)(3)(C)"]
[15,"Population projection total used to calculate per capita figure in #14:","The denominator used to calculate per capita figure requested in #14.This is a population projection total for your entity. ","140.008(b)(3)(C)"]
[16,"Source and year of population projection used to calculate per capita figure in #14: ","The source of the population projection comprising the denominator of per capita figure in #14.","140.008(b)(3)(C)"]
[17,"Date of last day of maximum term of most recently issued debt obligation in #14(MM/DD/YYYY):","The bill asks for the \"most recent debt obligation\" which is interpreted to mean the most recently issued debt obligation issued by the political subdivision. ","140.008(b)(3)(C)"]
[18,"Total combined principal and interest required to pay all outstanding ad valorem-secured debt obligations on time and in full, expressed as a per capita amount, projected as of the last day of the maximum term of the most recently issued debt obligation:","Sum the total amount borrowed of all obligations secured in any way by ad valorem taxation that have yet to be repaid. Include combination tax and revenue debt obligations in this total. Add to this the cost of debt service for these debt obligations. Divide this total by the projected population of the political subdivision corresponding to the last day of the maximum term of the most recently issued debt obligation. ","140.008(b)(3)(C)"]
[19,"Population total used to calculate per capita figure in #18:","The denominator used to calculate per capita figure requested in #18.This is a population projection total for your entity. ","140.008(b)(3)(C)"]
[20,"Source and year of population estimate used to calculate projected per capita figure in #18: ","The source of the population projection comprising the denominator of per capita figure in #18.","140.008(b)(3)(C)"]
[21,"Date of last day of maximum term of most recently issued debt obligation in #18(MM/DD/YYYY):","The bill asks for the \"most recent debt obligation\" which is interpreted to mean the most recently issued debt obligation issued by the political subdivision. ","140.008(b)(3)(C)"]
["End of Worksheet"]

{"sheet":"6 - Instructions and Glossary","index":7,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Texas Comptroller’s Annual Local Debt Report"]
["Instructions and Glossary"]
["The tables below provide further guidance on properly completing this report. Please contact the Texas Comptroller's office if you have any further questions, by phone (844) 519-5676; or email, Transparency@cpa.texas.gov"]
["Tab 1: Contact Information"]
["Item #","Terms","Definitions ","Directions","References, Local Government Code"]
[1,"Political Subdivision Name","Political subdivisions are counties, municipalities, school districts, junior college districts, other special districts, or other subdivisions of state government (Local Government Code, section 140.008 (a) (2))","Enter the legal name of your political subdivision. ","140.008(2)"]
[2,"Political Subdivision Type","Political subdivisions are counties, municipalities, school districts, junior college districts, other special districts, or other subdivisions of state government (Local Government Code, section 140.008 (a) (2))","Click on the cell to access the drop down menu. Select the appropriate type of political entity from the list. If \"other\" is selected, the blank cell below it must specify the type. Selecting another entity will black the lower cell out.","140.008(2)"]
[3,"Does the Political Subdivision have reportable debt?","A political subdivision must annually compile and report the required financial information under Local Government Code, Section 140.008. There is not an exception to the filing requirement for a political subdivision with no outstanding debt.","Click on the cell to the right to access the drop down menu. Selecting \"No\" still requires tabs 2 and 3 to be completed. All contact and entity information needs to be completed regardless if there is no reportable debt.",140.00800000000001]
[]
["Tab 2: Individual Debt Obligations"]
["Column","Terms","Definitions ","Directions","References, Local Government Code"]
["column A","Outstanding debt obligation ","an issued public security, as defined under Government Code §1201.002, that has yet to be repaid.","Enter the name of the individual debt obligation or bond series. If the entity has no debt to report, enter \"No Reportable Debt\" in the first cell below the column title (row 10).","140.008(b)(1)(C)"]
["column B","If debt is conduit or component debt, enter related entity name","debt that is not a legal liability of the political subdivision but is secured by another entity, such as an Economic Development Corporation","Enter the name of the entity who the debt is issued to on behalf of the political subdivision.","N/A"]
["column C","Principal issued","total amount borrowed (par)","Enter the amount borrowed for each individual debt obligation or bond series.","140.008(b)(1)(G)(i)"]
["column D","Principal outstanding","total amount borrowed (par) of obligation that has yet to be repaid","Enter the amount borrowed that has yet to be repaid for each individual debt obligation or bond series. ","140.008(b)(1)(C)"]
["column E","Combined principal and interest required to pay each outstanding debt obligation on time and in full","the total amount borrowed (par) plus the cost of interest for each individual debt obligation or bond series","Enter the amount borrowed plus the cost of interest for each individual debt obligation or bond series; total debt service.","140.008(b)(1)(E )"]
["column F","Final maturity date","final payment date of individual debt obligation at which point all principal and interest will be paid off","Enter the date of the final payment of principal and interest for each individual debt obligation. ","140.008(b)(1)(G)(iii)"]
["column G","Is the debt secured in any way by ad valorem taxes?","indicates which individual debt obligations are in part or whole pledged with property taxes","Select \"Yes\" from the dropdown list if any part of the debt obligation is secured with ad valorem taxes. If not, select \"No\".","140.008(b)(1)(F)"]
["column H","Total proceeds received","total assets received from the sale of a new issue of public securities ","Enter the total assets received from the individual debt obligation. ","140.008(b)(1)(G)(ii)"]
["column I","Proceeds spent","the portion of total proceeds received (column H) that have been spent","Enter the portion of the total assets received from the individual debt obligation that have been spent. The spreadsheet automatically calculates this amount.","140.008(b)(1)(G)(ii)"]
["column J","Proceeds unspent","the portion of total proceeds received that are remaining to be spent","Enter the portion of the total assets received from the individual debt obligation that have not been spent. (Formula: subtract column I from column H)","140.008(b)(1)(G)(ii)"]
["column K","Official stated purpose for which the debt obligation was authorized","The reason for the debt issuance as defined in ballot language if applicable or the Official Statement","Enter the purpose for the issuance of this individual series as defined in ballot language if applicable or the Official Statement. If there is not sufficient space in column K, use the Additional Notes (tab 4) to add further information regarding purpose. Be sure to label any additional notes you enter in the Additional Notes tab. ","140.008(b)(1)(G)(iv)"]
["columns L - Q","current credit rating","existing rating given by any nationally recognized credit rating organization to debt obligations","Identify if the obligation has received a credit rating. If so, enter the current rating in the appropriate column. Enter credit ratings for all agencies that apply. If the credit rating organization is not listed, enter the rating organization and rating in the \"Other Rating\" column. If the debt obligation is identified as unrated, columns M - Q will be blacked out. ","140.008(b)(2)"]
[]
["Tab 3: Summary of Debt Obligations"]
["Item #","Terms","Definitions ","Directions","References, Local Government Code"]
[1,"Total authorized debt obligations","1. Debt obligations are defined in the bill as issued public securities which are instruments, including bonds, certificates, notes, or other types of obligations authorized to be issued by an issuer under a statute, a municipal home-rule charter, or the constitution of this state (Government Code section 1201.002 (2)).\n2. Issuance is the process of authorizing, selling and delivering public debt.\n3. Public security authorization means a resolution , order, or ordinance that is approved or adopted, or any other action taken in a proceeding, by the governing body of an issuer in authorizing the issuance of a public security (Government Code section 1201.002 (3)).","Sum any and all authorized debt obligations. This includes voter-approved and non-voter approved debt obligations. ","140.008(b)(1)(A), 1201.002"]
[2,"Total principal of all outstanding debt obligations","Total amount borrowed (par) of all obligations that have yet to be repaid","Sum the total amount borrowed of all debt obligations that have yet to be repaid. ","140.008(b)(1)(B) "]
[3,"Combined principal and interest required to pay all outstanding debt obligations on time and in full","Total amount borrowed (par) that has yet to be repaid plus the cost of interest","Sum the amount borrowed that has yet to be repaid and the cost of interest; total debt service. ","140.008(b)(1)(D)"]
[4,"Total authorized debt obligations secured by ad valorem taxation","Total debt obligations secured by a pledge of property taxes","Sum any and all authorized debt obligations secured in any way by ad valorem taxation. Include combination tax and revenue debt obligations in this total. ","140.008(b)(1)(F) & 140.008(b)(1)(A) "]
[5,"Total principal of all outstanding debt obligations secured by ad valorem taxation","Total amount borrowed (par) of obligations secured by a pledge of property taxes that have yet to be repaid","Sum the total amount borrowed of all obligations secured in any way by ad valorem taxation that have yet to be repaid. Include combination tax and revenue debt obligations in this total. ","140.008(b)(1)(F) & 140.008(b)(1)(B)"]
[6,"Combined principal and interest required to pay all outstanding debt obligations secured by ad valorem taxation on time and in full","Total amount borrowed (par)of all property tax-secured obligations plus the cost of interest","Sum the amount borrowed for obligations secured in any way by ad valorem taxation plus debt service costs. Include combination tax and revenue debt obligations in this total.  ","140.008(b)(1)(F) & 140.008(b)(1)(D)"]
[7,"Political subdivision's population","The denominator used to calculate per capita figures requested on the Summary of Debt Obligations tab. This is a population total for the entity. ","Make sure that the year of the population figures being used match the fiscal year being reporting on.  ","140.008(b)(1)(F)"]
[8,"Source and year of population data","The source of population data comprising the denominator of per capita figures.","Include the data source, year and any other pertinent information on the data. For example, if you are using the American Community Survey data, specify the table number. Note that school district population data is available from the U.S. Census Bureau's Poverty Estimates for School Districts which is part of their Small Area Income and Poverty Program (SAIPE)","140.008(b)(1)(F) "]
[9,"Total authorized debt obligations secured by ad valorem taxation expressed as a per capita amount (required for a municipality, county, and school districts only)","Total authorized debt obligations secured by a pledge of property taxes divided by the population of the political subdivision (only school districts, municipalities and counties are required to provide a response to this question). ","Sum any and all authorized debt obligations secured in any way by ad valorem taxation that have yet to be repaid and divide this by the population of the political subdivision. Include combination tax and revenue debt obligations in this total. ","140.008(b)(1)(F) & 140.008(b)(1)(A)"]
[10,"Total principal of outstanding debt obligations secured by ad valorem taxation as a per capita amount (required for municipalities, counties, and school districts only)","Total amount borrowed (par) secured by a pledge of property taxes divided by the population of the political subdivision (only school districts, municipalities and counties are required to provide a response to this question). ","Sum the total amount borrowed of all obligations secured in any way by ad valorem taxation that have yet to be repaid. Include combination tax and revenue debt obligations in this total. Divide this figure by the population total for the political subdivision.  ","140.008(b)(1)(F) & 140.008(b)(1)(B)"]
[11,"Combined principal and interest required to pay all outstanding debt obligations secured by ad valorem taxation on time and in full as a per capita amount (required for municipalities, counties, and school districts only)","Total debt obligations secured by a pledge of property taxes plus the cost of debt service on these obligations divided by the population of the political subdivision (only school districts, municipalities and counties are required to provide a response to this question). ","Sum the total amount borrowed of all obligations secured in any way by ad valorem taxation that have yet to be repaid. Include combination tax and revenue debt obligations in this total. Add to this the cost of debt service for these debt obligations. Divide this total by the population of the political subdivision. ","140.008(b)(1)(F) & 140.008(b)(1)(D)"]
["End of Worksheet"]