{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Form Page 1","Form Page 2","Form Page 3","Form Page 4","Form Page 4a","Form Page 5","Verification Page"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":38,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"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":"Form Page 1","index":0,"n_rows":85,"n_cols":5,"rows_kept":85,"cut":false,"hidden":false,"merged":[[42,0,42,2],[7,0,7,4],[8,0,8,4],[13,0,13,4],[1,0,1,4],[14,0,14,4],[15,2,15,4],[9,0,9,2],[17,2,17,4],[40,0,40,2],[10,0,11,5],[17,5,18,5],[19,2,19,4],[36,2,36,4],[37,2,37,4],[34,2,34,4],[0,0,0,4],[2,0,2,4],[4,0,4,4],[5,0,5,4],[6,0,6,4],[3,0,3,4],[23,0,23,5],[25,2,25,4],[27,2,28,4],[29,2,30,5],[32,0,32,5]]}
["AT&T Corp."]
["Company Name"]
["(Provide the full name of the company as certificated or registered with the Missouri Public \nService Commission, including any Commission approved d/b/a, if applicable.  Please do not abbreviate.)"]
[]
["TELECOMMUNICATIONS COMPANY OR IVoIP PROVIDER"]
["ANNUAL REPORT"]
["TO THE"]
["MISSOURI PUBLIC SERVICE COMMISSION"]
["For the Calendar Year of"]
["    January 1 - December 31, ",null,null,2019]
["This filing is required pursuant to Commission Rule 20 CSR 4240-28.012 and/or Section 392.210 RSMO."]
[]
[]
["Please select how the company is certificated and/or registered with the Commission (check all that apply):"]
[]
[null,null,"Incumbent Local Telecommunications Company (ILEC)"]
[]
[null,"X","Competitive Local Exchange Telecommunications Company (CLEC) "]
[]
[null,"X","Interexchange or Local Non-Switched Telecommunications Company (IXC) "]
[]
[null,"X","Interconnected Voice over Internet Protocol Service Provider  (IVoIP) "]
[]
["If more than one certificate or registration is held by the company you must file an annual report in the Commission's Electronic Filing and Information System (EFIS) for each certificate or registration.  In such situations, we anticipate the annual reports to be identical; however please verify the following:"]
[]
[null,"X","The various annual reports filed in EFIS are identical. "]
[]
[null,null,"The various annual reports filed in EFIS are different."]
[]
[null,null,"Not applicable (Company only has one certificate or registration; therefore only one annual report \nwas filed in EFIS.)"]
[]
[]
["Please choose one of the following filing options to indicate the security level of the filing:"]
[]
[null,"X","Public submission (NOT Confidential)"]
[]
[null,null,"Non-Public submission (Confidential) (See instructions for special requirements.) "]
[null,null," For this filing to be considered Confidential, additional submission of materials is required, pursuant to Commission Rule 20 CSR 4240-2.135."]
[]
[]
[]
[null,null,null,null,"Public"]
["Excel Issue Date: 11/08/2019",null,null,null,"For use when filing under seal."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Confidential"]

{"sheet":"Form Page 2","index":1,"n_rows":28,"n_cols":8,"rows_kept":28,"cut":false,"hidden":false,"merged":[[6,6,6,7],[7,1,7,4],[8,1,8,2],[8,6,8,7],[9,1,9,2],[9,6,9,7],[0,2,0,7],[0,0,0,1],[22,1,22,2],[20,1,20,4],[7,6,7,7],[17,1,17,4],[17,6,17,7],[5,1,5,4],[5,6,5,7],[6,1,6,4],[1,0,1,1],[3,1,3,7],[4,1,4,4],[4,6,4,7],[19,1,19,4],[19,6,19,7],[32,1,32,7],[27,5,27,7],[28,5,28,7],[29,5,29,7],[31,1,31,7],[29,1,29,3],[27,1,27,3],[28,1,28,3],[26,5,26,7],[25,1,25,7],[23,1,23,2],[23,6,23,7],[14,1,14,7],[26,1,26,3],[20,6,20,7],[21,1,21,4],[21,6,21,7],[15,1,15,7],[16,1,16,4],[16,6,16,7],[18,1,18,4],[18,6,18,7]]}
["Annual Report of",null,{"$f":"IF('Form Page 1'!A1>0, 'Form Page 1'!A1, \" \")","v":"AT&T Corp."}]
[null,null,null,null,null,null,"for the calendar year of January 1 - December 31, ",{"$f":"IF('Form Page 1'!D10>0, 'Form Page 1'!D10, \" \")","v":2019}]
[]
["1.","State in full the company's information below:        "]
[null,"One AT&T Way, Room 3B111H",null,null,null,null,"(908) 234-6495"]
[null,"Company Street Address",null,null,null,null,"Telephone Number"]
[]
[null,"Company Mailing Address (if different from street address)"]
[null,"Bedminster",null,"NJ","07921"]
[null,"City",null,"State","Zip"]
[]
["2.","The company's contact information in EFIS has been reviewed (and updated as applicable)."]
[]
[]
["3.","Annual Report Contact Information:  "]
[null,"List the contact information of the person completing the form, whether an employee or a third-party preparer.  This may differ from the address in Item No. 1."]
[null,"Robert Cancillieri",null,null,null,null,"(908) 234-6495"]
[null,"Name",null,null,null,null,"Telephone Number"]
[null,"One AT&T Way, Room 3B111H"]
[null,"Street Address"]
[]
[null,"Mailing Address"]
[null,"Bedminster",null,"NJ","07921"]
[null,"City",null,"State","Zip"]
[]
[{"$f":"SUM(A15+1)& (\".\")","v":"4."},"Identify the company's top three principal or general officers at the end of the year.    "]
[null,"Title",null,null,null,"Name "]
[null,"See Attachment A",null,null,null,"See Attachment A"]

{"sheet":"Form Page 3","index":2,"n_rows":67,"n_cols":10,"rows_kept":67,"cut":false,"hidden":false,"merged":[[5,1,5,3],[0,0,0,1],[0,2,0,5],[1,0,1,1],[1,2,1,5],[4,1,4,3],[17,1,17,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,5],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[18,1,18,2],[20,0,20,8],[21,1,21,9],[22,1,22,9],[23,1,23,9]]}
["Annual Report of",null,"AT&T Corp."]
[null,null,"for the calendar year of January 1 - December 31, ",null,null,null,2019]
[]
[5,"Please provide the following revenue information:"]
[]
["Row","RETAIL END USER REVENUES",null,null,"**","MO Intrastate\n(Column A)","**","**","Total Company\n(Column B)","**"]
[{"$f":"SUM(1)&(\".\")","v":"1."},"Local Service (Basic local telecommunications service, IVoIP service and features associated with these services)",null,null,"**",null,"**","**",null,"**"]
[{"$f":"SUM(A7+1)&(\".\")","v":"2."},"Interexchange Service (Message toll services, 800 services, interexchange operator services).",null,null,"**",null,"**","**",null,"**"]
[{"$f":"SUM(A8+1)&(\".\")","v":"3."},"Non-Switched Services (Dedicated non-switched private line services typically used by business customers.  Do not include special access or private line services provided to other telecommunications or IVoIP service providers which are reported in Row 7).",null,null,"**",null,"**","**",null,"**"]
[{"$f":"SUM(A9+1)&(\".\")","v":"4."},"Bundled Voice Service  (If telecommunications or IVoIP service is bundled with non-regulated services then a company may apply either of two methods in reporting bundled revenue in Column A.  Method 1:  Report bundled revenue in Column A based on the unbundled rate for telecommunications or IVoIP service; or Method 2:  Report all bundled revenue in Column A.)  ",null,null,"**",null,"**","**",null,"**"]
[{"$f":"SUM(A10+1)&(\".\")","v":"5."},"Retail Uncollectibles.  (Amount is typically a negative number.)  ",null,null,"**",null,"**","**",null,"**"]
[{"$f":"SUM(A11+1)&(\".\")","v":"6."},"RETAIL END-USER TOTAL (Row 1+2+3+4+5)  Revenue in Column A will be provided to Missouri USF Administrator for assessment purposes.)",null,null,"**",null,"**","**",null,"**"]
[null,"WHOLESALE CARRIER'S CARRIER AND UNIVERSAL SERVICE FUND REVENUES"]
[{"$f":"SUM(A12+1)&(\".\")","v":"7."},"Revenue from services provided for resale as telecommunications or IVoIP services from another telecommunications or IVoIP service provider.  This row typically includes revenue associated with switched access service, special access service, billing and collection service.  NECA settlements, if any, should be reported solely in Column B.",null,null,"**",null,"**","**",null,"**"]
[{"$f":"SUM(A14+1)&(\".\")","v":"8."},"Miscellaneous Carrier's Carrier Revenue (Remaining Carrier's Carrier Revenue provided in FCC Form 499-A, Block 3 that is not reported in Row 7).   ",null,null,"**",null,"**","**",null,"**"]
[{"$f":"SUM(A15+1)&(\".\")","v":"9."},"Wholesale Uncollectibles. (Amount is typically a negative number.)  ",null,null,"**",null,"**","**",null,"**"]
[{"$f":"SUM(A16+1)&(\".\")","v":"10."},"Federal USF Revenue (List federal USF revenue in Column B; however, any Connect America Fund Intercarrier Compensation funding used to replace revenue caused by mandatory  intrastate switched access rate reductions should be reported in Column A.)",null,null,"**",null,"**","**",null,"**"]
[11,"State USF Revenue  ",null,null,"**",null,"**","**",null,"**"]
[12,"TOTAL REVENUES (Row 6+7+8+9+10+11) The Total Revenue in Column A should match the Total Gross Intrastate Operating Revenue reported on the Missouri PSC's Statement of Revenue form. ",null,null,"**",null,"**","**"]
[]
["Revenue reporting clarifications: "]
[null,"Total Company Revenue (Column B) = Missouri Intrastate revenue in Column A + Interstate revenues + International revenues."]
[null,"IVoIP revenue: If unable to distinguish Missouri Jurisdictional revenue in Column A then a safe harbor percentage can be applied to total revenue that corresponds to the FCC's safe harbor percentage. "]
[null,"Retail non-switched private line service revenue:  All of a customer's non-switched private line service revenue can be reported in Column B if 10% of more of the customer's private line network traffic is considered interstate traffic."]
[null,null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,null,"For use when filing under seal."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Public"]
[null,null,null,null,null,"Confidential"]

{"sheet":"Form Page 4","index":3,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[41,7,41,9],[39,1,39,7],[2,1,2,7],[3,1,4,1],[3,2,3,7],[36,1,36,7],[37,1,37,7],[38,1,38,7]]}
[null,"Annual Report of",null,"AT&T Corp."]
[null,null,null,null,null,null,"for the calendar year of January 1 - December 31, ",2019]
[6,"Line Quantities for Basic Local Telecommunications &/or IVoIP Services"]
[null,"Exchange","Line Quantities"]
[null,null,"**","Residential","**","**","Business","**"]
[null,"BELTON","**",null,"**","**",null,"**"]
[null,"BLUE SPG","**",null,"**","**",null,"**"]
[null,"CAMERON","**",null,"**","**",null,"**"]
[null,"CAPEGIRARD","**",null,"**","**",null,"**"]
[null,"CARTHAGE","**",null,"**","**",null,"**"]
[null,"CHESTERFLD","**",null,"**","**",null,"**"]
[null,"CREVECOEUR","**",null,"**","**",null,"**"]
[null,"DARDENNE","**",null,"**","**",null,"**"]
[null,"FENTON","**",null,"**","**",null,"**"]
[null,"FERRELVIEW","**",null,"**","**",null,"**"]
[null,"FULTON","**",null,"**","**",null,"**"]
[null,"HANNIBAL","**",null,"**","**",null,"**"]
[null,"HARVESTER","**",null,"**","**",null,"**"]
[null,"JACKSON","**",null,"**","**",null,"**"]
[null,"JEFFERSNCY","**",null,"**","**",null,"**"]
[null,"JOPLIN","**",null,"**","**",null,"**"]
[null,"KANSASCITY","**",null,"**","**",null,"**"]
[null,"KIRKSVILLE","**",null,"**","**",null,"**"]
[null,"KIRKWOOD","**",null,"**","**",null,"**"]
[null,"LADUE","**",null,"**","**",null,"**"]
[null,"LEESSUMMIT","**",null,"**","**",null,"**"]
[null,"LIBERTY","**",null,"**","**",null,"**"]
[null,"LKOZKOSBCH","**",null,"**","**",null,"**"]
[null,"MANCHESTER","**",null,"**","**",null,"**"]
[null,"MARYVILLE","**",null,"**","**",null,"**"]
[null,"MAXVILLE","**",null,"**","**",null,"**"]
[null,"MEHLVILLE","**",null,"**","**",null,"**"]
[null,"MONETT","**",null,"**","**",null,"**"]
[null,"Totals:","**",null,"**","**",{"$f":"IF(COUNT(G6:G33),SUM(G6:G33),\"\")","v":""},"**"]
[]
[null,"About reporting line quantities:"]
[null,"1. Report line quantities for basic local telecommunications service and/or IVoIP service as those terms are defined in 386.020(4) and (23). "]
[null,"2. Lines include analog and digital.  For DS-1 or higher band-width facilities a voice grade equivalency must be used.  For channelized service report the number of channels subscribed to by the customer.  For non-channelized facilities, filers are instructed to use a good-faith esitmate of the number of voice grade equivalent lines used for voice service."]
[null,"3.  Exchange refers to areas as listed in ILEC tariffs.  (Exchanges are not always the same as rate centers, wire centers and central offices.)"]
[null,"4.  Per 392.550(7)(c) IVoIP line quantities must be filed on a confidential basis.  See instructions for how to file annual report information on a confidential basis."]
[]
[null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,"For use when filing under seal."]

{"sheet":"Form Page 4a","index":4,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[39,1,39,7],[41,7,41,9],[2,1,2,7],[3,1,4,1],[3,2,3,7],[36,1,36,7],[37,1,37,7],[38,1,38,7]]}
[null,"Annual Report of",null,"AT&T Corp."]
[null,null,null,null,null,null,"for the calendar year of January 1 - December 31, ",2019]
[6,"Line Quantities for Basic Local Telecommunications &/or IVoIP Services"]
[null,"Exchange","Line Quantities"]
[null,null,"**","Residential","**","**","Business","**"]
[null,"PACIFIC","**",null,"**","**",null,"**"]
[null,"PIERCECITY","**",null,"**","**",null,"**"]
[null,"ROLLA","**",null,"**","**",null,"**"]
[null,"SALEM","**",null,"**","**",null,"**"]
[null,"SAPPINGTON","**",null,"**","**",null,"**"]
[null,"SIKESTON","**",null,"**","**",null,"**"]
[null,"SPRINGFLD","**",null,"**","**",null,"**"]
[null,"ST CHARLES","**",null,"**","**",null,"**"]
[null,"ST JOSEPH","**",null,"**","**",null,"**"]
[null,"ST LOUIS","**",null,"**","**",null,"**"]
[null,"ST PETERS","**",null,"**","**",null,"**"]
[null,"VALLEYPARK","**",null,"**","**",null,"**"]
[null,"WARRENSBG","**",null,"**","**",null,"**"]
[null,"VoIP Exchange Breakdown","**",null,"**","**",null,"**"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Totals:","**",{"$f":"IF(COUNT(D6:D33),SUM(D6:D33),\"\")","v":""},"**","**",null,"**"]
[]
[null,"About reporting line quantities:"]
[null,"1. Report line quantities for basic local telecommunications service and/or IVoIP service as those terms are defined in 386.020(4) and (23). "]
[null,"2. Lines include analog and digital.  For DS-1 or higher band-width facilities a voice grade equivalency must be used.  For channelized service report the number of channels subscribed to by the customer.  For non-channelized facilities, filers are instructed to use a good-faith esitmate of the number of voice grade equivalent lines used for voice service."]
[null,"3.  Exchange refers to areas as listed in ILEC tariffs.  (Exchanges are not always the same as rate centers, wire centers and central offices.)"]
[null,"4.  Per 392.550(7)(c) IVoIP line quantities must be filed on a confidential basis.  See instructions for how to file annual report information on a confidential basis."]
[]
[null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,"For use when filing under seal."]

{"sheet":"Form Page 5","index":5,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,5,0,7],[4,1,4,7],[8,1,8,3],[9,1,9,3],[10,1,10,3],[21,6,21,7],[19,1,19,7],[7,1,7,3],[13,1,13,7],[17,1,17,7]]}
[null,"Annual Report of",null,null,null,{"$f":"IF('Form Page 1'!A1>0, 'Form Page 1'!A1, \"\")","v":"AT&T Corp."}]
[null,null,null,null,null,null,"for the calendar year of January 1 - December 31,",{"$f":"IF('Form Page 1'!D10>0, 'Form Page 1'!D10, \" \")","v":2019}]
[]
[]
[null,"Relay Missouri Assessment1"]
[]
[]
[null,null,null,null,null,"Annual Totals "]
["7.","Revenue Collected From Relay Missouri Surcharge",null,null,"**",null,"**"]
[null,"Amount Retained for Billing and Collecting the Surcharge",null,null,"**",null,"**"]
[null,"Relay Missouri Revenue Remitted to Relay Missouri Fund",null,null,"**",null,"**"]
[]
[]
[8,"Please indicate the per line value of the Relay Missouri Surcharge applied to your customers in December.\n\n"]
[null,0]
[]
[{"$f":"SUM(A14+1)","v":9},"If your firm did not impose the Relay Missouri Surcharge, please explain: "]
[]
[]
[1,"ILECs, CLECs and IVoIP providers are required to complete this page; however, companies classified solely as IXCs are not expected to complete this page."]
[]
[null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,"For use when filing under seal."]

{"sheet":"Verification Page","index":6,"n_rows":36,"n_cols":16,"rows_kept":36,"cut":false,"hidden":false,"merged":[[22,9,22,11],[23,4,23,5],[18,4,18,13],[19,4,19,13],[15,4,15,13],[23,9,23,11],[16,4,16,13],[17,4,17,13],[21,2,21,13],[22,2,22,3],[22,4,22,5],[0,1,0,13],[1,2,1,4],[1,5,1,15],[2,7,2,14],[5,3,5,13],[7,2,7,14],[8,3,8,13],[14,4,14,13],[11,4,11,8],[12,4,12,9],[9,4,9,8],[11,2,11,3],[13,4,13,9],[35,1,35,15],[24,7,24,13],[25,7,25,13],[29,6,29,11],[28,8,28,9],[34,1,34,15],[29,2,29,5],[30,6,30,13],[32,6,32,13],[33,6,33,13],[31,6,31,13],[28,3,28,5]]}
[]
[null,null,"Annual Report of",null,null,{"$f":"IF('Form Page 1'!A1>0, 'Form Page 1'!A1, \"\")","v":"AT&T Corp."}]
[null,null,null,null,null,null,null,"for the calendar year of January 1 - December 31,",null,null,null,null,null,null,null,{"$f":"IF('Form Page 1'!D10>0, 'Form Page 1'!D10, \" \")","v":2019}]
[]
[]
[null,null,null,"VERIFICATION"]
[]
[null,null,"The foregoing report must be verified by the Oath of the President, Treasurer, General Manager or Receiver of the company. The Oath required may be taken before any person authorized to administer an oath (Notary Public) by the laws of the State in which the same is taken."]
[null,null,null,"OATH"]
[null,null,"State Of",null,"New Jersey",null,null,null,null,"}"]
[null,null,null,null,null,null,null,null,null,"}","ss:"]
[null,null,"County Of",null,"Somerset",null,null,null,null,"}"]
[null,null,null,null,"Barbara Monte",null,null,null,null,null,"makes oath and says that"]
[null,null,null,null,"Name of Affiant (Company Official/Representative)"]
[null,null,"s/he is",null,"Director - Accounting"]
[null,null,null,null,"Official Title of the Affiant (Company Official/Representative)"]
[null,null,"of",null,"AT&T Corp."]
[null,null,null,null,"Exact Legal Title or Name of the Respondent (Certificated Company Name)"]
[null,null,"and is located at",null,"One AT&T Way, Bedminster, NJ  07921      (908) 234-7233",null,null,null,null,null,null,null,null,null,", "]
[null,null,null,null,"Address and Telephone Number of the Affiant (Company Official/Representative)"]
[]
[null,null,"that s/he has 1) examined the foregoing report; to the best of his or her knowledge, information, and belief, all statements of fact contained in the said report are true and the said report is a correct statement of the business and affairs of the above-named respondent, and 2) examined (and updated as applicable) the company's contact information in EFIS; to the best of his or her knowledge, information, and belief, all listed contacts are correct."]
[null,null,"from",null,"January 1",null,", ",{"$f":"IF('Form Page 1'!D10>0, 'Form Page 1'!D10, \" \")","v":2019},", to and including","December 31",null,null,", ",{"$f":"IF('Form Page 1'!D10>0, 'Form Page 1'!D10, \" \")","v":2019}]
[null,null,null,null,"Month/Day",null,null,"Year",null,"Month/Day",null,null,null,"Year"]
[]
[null,null,null,null," ",null,null,"Signature of Affiant (Company Official/Representative)\n(If electronic signatures are used, you must use \"/s/\" before the name.)"]
[]
[null,null,"Subscribed and sworn to before me, a Notary Public, in and for the State and County above named, "]
[null,null,"this     ",null,null,null,null,"day of","March",null,",",2020]
[null,null,"My Commission expires",null,null,null,"June 18",null,null,null,null,null,",",2023]
[]
[null,null,null,null,null,null,"Signature of Notary Public\n(If electronic signatures are used, you must use \"/s/\" before the name.)"]
[null,null,null,null,null,null,"Robert Cancillieri - ID # 2435315"]
[null,null,null,null,null,null,"Notary Commission Number"]
[null,"Missouri Revised Statutes § 392.210 or §393.140"]
[null,"See the instructions for more information to complete this page. "]