{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Form Page 1","Form Page 2","Form Page 3","Form Page 4","Form Page 5","Verficiation Page"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":31,"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":88,"n_cols":5,"rows_kept":88,"cut":false,"hidden":false,"merged":[[0,0,0,4],[12,0,12,4],[13,2,13,4],[9,0,9,2],[17,2,17,4],[7,0,7,4],[8,0,8,4],[11,0,11,4],[1,0,1,4],[2,0,2,4],[4,0,4,4],[5,0,5,4],[6,0,6,4],[3,0,3,4],[17,5,18,5],[19,2,19,4],[21,2,22,4],[38,2,38,4],[39,2,39,4],[42,0,42,2],[25,0,25,5],[27,2,27,4],[29,2,30,4],[31,2,32,5],[34,0,34,5],[36,2,36,4]]}
["MCImetro Access Transmission Services LLC d/b/a Verizon Access Transmission Services"]
["Company Name"]
["(Provide the full name of the company as certificated or registered with the Missouri Public \nService Commission.  Do not abbreviate; include any Commission approved d/b/a or fictitious name, if applicable.)  "]
[]
["TELECOMMUNICATIONS COMPANY OR IVoIP PROVIDER"]
["ANNUAL REPORT"]
["TO THE"]
["MISSOURI PUBLIC SERVICE COMMISSION"]
["For the Calendar Year of"]
["    January 1 - December 31,",null,null,2012]
[]
["Please select how the company is certificated or registered with the Commission\nunder the Company Name as shown above (check all that apply):"]
[]
[null,null,"Incumbent Local Telecommunications Company (not competitively classified ILEC)"]
[]
[null,null,"Incumbent Local Exchange Telecommunications Company (competitively classified ILEC)"]
[]
[null,"X","Competitive Local Exchange Telecommunications Company (CLEC) "]
[]
[null,"X","Interexchange Telecommunications Company (IXC) "]
[]
[null,null,"Local Non-switched Telecommunications Provider (classified in EFIS as IXC )\n"]
[]
[null,null,"Interconnected Voice over Internet Protocol Service Provider  (IVoIP) "]
[]
["If more than one certificate or registration is held by the company then keep in mind\nthat you must file an annual report in the Commission's Electronic Filing and \nInformation System (EFIS) based on each certificate or registration.  In such situations, \nwe anticipate the annual reports to be identical; however please verify the following:"]
[]
[null,null,"The various annual reports filed in EFIS are identical. "]
[]
[null,null,"The various annual reports filed in EFIS are different."]
[]
[null,"X","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 Proprietary or Highly Confidential)"]
[]
[null,null,"Non-Public submission (Highly Confidential or Proprietary)"]
[null,null,"(See instructions for special requirements.)"]
[]
["Please review the instructions document before proceeding by using the link below:  "]
["Instructions - Annual Report Telco and IVoIP"]
[null,null,null,null,"Public"]
["Excel Rev. 12/07/2011",null,null,null,"For use when filing under seal."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Public"]
[null,null,null,"Highly Confidential"]
[null,null,null,"Proprietary"]

{"sheet":"Form Page 2","index":1,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[16,1,16,7],[28,1,28,3],[23,1,23,4],[23,6,23,7],[28,5,28,7],[27,1,27,7],[25,1,25,2],[18,6,18,7],[20,6,20,7],[22,6,22,7],[21,1,21,4],[21,6,21,7],[25,6,25,7],[1,0,1,1],[3,1,3,7],[10,5,10,7],[7,1,7,4],[9,1,9,2],[9,6,9,7],[4,1,4,4],[6,1,6,4],[8,1,8,2],[4,6,4,7],[6,6,6,7],[8,6,8,7],[0,2,0,7],[0,0,0,1],[24,1,24,2],[7,6,7,7],[11,1,11,7],[12,1,12,7],[13,1,13,7],[14,1,14,7],[19,1,19,4],[19,6,19,7],[5,1,5,4],[5,6,5,7],[10,2,10,3],[17,1,17,7],[18,1,18,4],[20,1,20,4],[36,1,36,7],[34,1,34,7],[35,1,35,7],[29,5,29,7],[30,5,30,7],[31,5,31,7],[32,5,32,7],[32,1,32,3],[31,1,31,3],[29,1,29,3],[30,1,30,3]]}
["Annual Report of",null,{"$f":"IF('Form Page 1'!A1>0, 'Form Page 1'!A1, \" \")","v":"MCImetro Access Transmission Services LLC d/b/a Verizon Access Transmission Services"}]
[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":2012}]
[]
["1.","State in full the company's information below:        "]
[null,"22001 Loudoun County Parkway",null,null,null,null,"(703) 886-5600"]
[null,"Company Street Address",null,null,null,null,"Telephone Number"]
[null,"22001 Loudoun County Parkway",null,null,null,null,"(703) 886-0860"]
[null,"Company Mailing Address (if different from street address)",null,null,null,null,"Fax Number"]
[null,"Ashburn",null,"VA","20147",null,"WWW.Verizon.Com"]
[null,"City",null,"State","Zip",null,"E-Mail Address"]
[]
[{"$f":"SUM(A4+1)& (\".\")","v":"2."},"This company is currently a (check appropriate box):  "]
[]
[]
[]
[]
[{"$f":"SUM(A12+1)& (\".\")","v":"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,"Haleh Davary",null,null,null,null,"(415) 228-1072"]
[null,"Name",null,null,null,null,"Telephone Number"]
[null,"201 Spear Street, 7th Floor",null,null,null,null,"(415) 228-1276"]
[null,"Street Address",null,null,null,null,"Fax Number"]
[null,"201 Spear Street, 7th Floor",null,null,null,null,"Haleh.Davary@Verizon.Com"]
[null,"Mailing Address",null,null,null,null,"E-mail Address"]
[null,"San Francisco",null,"CA","94105"]
[null,"City",null,"State","Zip"]
[]
[{"$f":"SUM(A17+1)& (\".\")","v":"4."},"Identify the principal or general officers of the company at the end of the year.  Please include an additional sheet, if enough space is not provided on this page, to completely provide the requested information.  "]
[null,"Title of General Officer",null,null,null,"Name of Person Holding Office"]
[null,"President and CEO",null,null,null,"John G. Stratton"]
[null,"Senior Vice President and CFO",null,null,null,"Steven R. Small"]
[null,"Senior VP, General Counsel and Secretary",null,null,null,"Michelle C. Ifill"]
[null,"Treasurer",null,null,null,"Michael T. Stefanski"]
[]
[{"$f":"SUM(A28+1)& (\".\")","v":"5."},"Please provide a list of all mergers, consolidations, and reorganizations involving the registered or certificated company and completed during the last year. Do not include internal company reorganizations or personnel issues."]
[null,"None"]

{"sheet":"Form Page 3","index":2,"n_rows":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":false,"merged":[[7,1,7,2],[8,1,8,2],[9,1,9,2],[1,0,1,1],[1,2,1,8],[2,0,2,1],[2,2,2,7],[4,1,4,8],[6,0,6,3],[5,1,5,3],[10,1,10,2],[11,1,11,2],[12,1,12,2],[25,1,25,5],[25,6,25,8],[13,0,13,3],[20,1,20,2],[22,0,22,5],[23,0,23,5],[24,1,24,8],[17,1,17,2],[18,1,18,2],[19,1,19,2],[14,1,14,2],[15,1,15,2],[16,1,16,2]]}
[]
["Annual Report of",null,{"$f":"IF('Form Page 1'!A1>0, 'Form Page 1'!A1, \" \")","v":"MCImetro Access Transmission Services LLC d/b/a Verizon Access Transmission Services"}]
[null,null,"for the calendar year of January 1 - December 31, ",null,null,null,null,null,{"$f":"IF('Form Page 1'!D10>0, 'Form Page 1'!D10, \" \")","v":2012}]
[]
[{"$f":"'Form Page 2'!A35+1","v":6},"Please provide the following information concerning the company's revenues for this calendar year:"]
["Row","Revenues",null,null,null,"MO Jurisdictional\n(Column A)",null,null,"Total Company1\n(Column B)"]
["I. RETAIL",null,null,null,"**",null,"**","**",null,"**"]
[{"$f":"SUM(1)&(\".\")","v":"1."},"Local Service Revenues include tariffed revenues attributed to local telecommunications services, extended area service, secondary features such as call forwarding, caller ID, local operator services, directory-related services, etc. and for IVoIP service."]
[{"$f":"SUM(A8+1)&(\".\")","v":"2."},"Interexchange Revenues include revenues attributed to interexchange telecommunications services such as toll services, 800 services, interexchange operator services and interexchange IVoIP services.",null,null,"**",null,"**","**",null,"**"]
[{"$f":"SUM(A9+1)&(\".\")","v":"3."},"Non-Switched Telecommunications Service Revenues include revenues attributed to retail local and interexchange private line services (but not special access or private line services provided to other telecommunications carriers)."]
[{"$f":"SUM(A10+1)&(\".\")","v":"4."},"Bundled or Packaged Revenues include any revenues whereby the company is providing voice services in combination with multiple services whereby revenue can not be easily attributed to local, interexchange or non-switched categories. If such bundles includes Internet, video or some non-regulated service then the company's revenue shall be based on the company's rate offer for solely voice services.  The excess revenue associated with the bundled service which is over the amount related to revenue associated with voice only service shall be recorded in the Total Company column.  If voice service is only offered as part of a bundled service, the company shall identify all revenue associated with the bundle of services in the Missouri Jurisdictional column."]
[{"$f":"SUM(A11+1)&(\".\")","v":"5."},"Retail Uncollectible Revenues from telecommunications revenues. \n(This amount is generally a negative number.)  "]
[{"$f":"SUM(A12+1)&(\".\")","v":"6."},"RETAIL TOTAL \n(This amount should equal the total of Rows 1 - 5 above and should also match your Missouri Universal Service Fund Net Jurisdictional Revenue Report amount.) ",null,null,"**",{"$f":"IF(COUNT(F8:F12),SUM(F8:F12),\"\")","v":""},"**","**",{"$f":"IF(COUNT(I8:I12),SUM(I8:I12),\"\")","v":""},"**"]
["II. OTHER"]
[{"$f":"SUM(A13+1)&(\".\")","v":"7."},"Wholesale Revenues include intrastate switched, special access service revenues, carrier billing and collection revenues, and any other revenues derived from other telecommunications carriers.  ",null,null,"**",null,"**","**",null,"**"]
[{"$f":"SUM(A15+1)&(\".\")","v":"8."},"Miscellaneous Revenues2 associated with non-retail services, such as, advertising revenues, rent revenues, corporate operations revenues, special billing arrangements, customer operations, plant operations, other incidental regulated revenues, and other revenue settlements. (NOTE FOR ILEC ONLY: refer to FCC account #s: 5230, 5240, 5250, 5261, 5262, 5263, 5264, 5269, and 5270.)"]
["9.","Other Uncollectible Revenues from other revenues. \n(This amount is generally a negative number.)  "]
["10.","High-Cost Federal USF Revenues include all revenues received as support from the Universal Service Fund for the High-Cost program. ",null,null,null,"N/A"]
["11.","Other Federal USF Revenues include all revenues received as support from the Universal Service Fund for the following programs:  Low Income, Schools and Libraries, and Rural Health. ",null,null,null,"N/A"]
["12.","State USF Revenues include all revenues received as support from the Universal Service Fund.  "]
["13.","TOTAL REVENUES (This amount should equal the total of Rows 6 - 12 above.)  Total MO Jurisdictional Revenue (Column A) should match Total Gross Intrastate Operating Revenue on the Statement of Revenue.",null,null,"**",{"$f":"IF(COUNT(F13:F20),SUM(F13:F20),\"\")","v":""},"**","**",{"$f":"IF(COUNT(I13:I20),SUM(I13:I20),\"\")","v":""},"**"]
[]
["\"Telecommunications Service\" as defined by Missouri Revised Statutes Section 386.020(54)."]
["\"Interconnected Voice over Internet Protocol service\" as defined by Section 386.020(23) RSMo."]
[1,"List total regulated revenue and IVoIP revenue provided by a registered company and, if applicable, non-regulated revenue for company name as listed at the top of this page.  \nDo not include revenues for any company NOT listed at the top of the page. "]
[2,"If you have miscellaneous revenue related to retail telecommunications services, then enter it in Row 1.",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,"Highly Confidential"]
[null,null,null,null,null,"Proprietary"]

{"sheet":"Form Page 4","index":3,"n_rows":80,"n_cols":11,"rows_kept":80,"cut":false,"hidden":false,"merged":[[37,1,37,10],[39,8,39,10],[0,3,0,9],[2,1,2,9],[3,1,4,1],[3,2,3,7],[3,9,4,9],[36,1,36,10]]}
[null,"Annual Report of",null,{"$f":"IF('Form Page 1'!A1>0, 'Form Page 1'!A1, \" \")","v":"MCImetro Access Transmission Services LLC d/b/a Verizon Access Transmission Services"}]
[null,null,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":2012}]
[{"$f":"'[1]Form Page 3'!A5+1","v":7},"Line Quantities for Local Voice Service & IVoIP Service1"]
[null,"Exchange2","Retail",null,null,null,null,null,null,"Wholesale to \nNon-Registered Nomadic IVoIP Providers3"]
[null,null,"**","Residential","**","**","Business","**","**",null,"**"]
[]
[null,"Please see the attached"]
[null,"confidential Attachment A"]
[null,"for the retail section of this "]
[null,"page. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Totals:",null,{"$f":"IF(COUNT(D6:D33),SUM(D6:D33),\"\")","v":""},null,null,{"$f":"IF(COUNT(G6:G33),SUM(G6:G33),\"\")","v":""},null,null,{"$f":"IF(COUNT(J6:J33),SUM(J6:J33),\"\")","v":""}]
[]
[1,"See instructions for additional clarification about filling out this page."]
[2,"Exchange refers to areas as listed in ILEC tariffs.  (Exchanges are not always the same as rate centers, wire centers and central offices.)"]
[3,"Wholesale to Non-registered Nomadic IVoIP Providers refers to arrangements where your company is providing wholesale services for a nomadic IVoIP provider who is not registered with the Missouri PSC.   (Do not use this column for retail line quantities or if your company sets the end user’s rates.)"]
[]
[null,null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,null,null,null,"For use when filing under seal."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,null,null,"Highly Confidential"]
[null,null,null,null,null,null,null,null,null,"Proprietary"]

{"sheet":"Form Page 5","index":4,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":false,"merged":[[33,8,33,10],[25,1,25,9],[29,1,29,9],[0,3,0,9],[4,1,4,9],[6,1,6,9],[8,2,8,4],[8,5,8,7],[8,8,8,10],[8,1,9,1]]}
[null,"Annual Report of",null,{"$f":"IF('Form Page 1'!A1>0, 'Form Page 1'!A1, \"\")","v":"MCImetro Access Transmission Services LLC d/b/a Verizon Access Transmission Services"}]
[null,null,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":2012}]
[]
[]
[null,"Relay Missouri Annual Billing, Collections and Retention "]
[]
[{"$f":"'Form Page 4'!A3+1","v":8},"Any ILEC, CLEC or VoIP provider must submit information in the table below.1  \n(The table should be completely filled-in.  The only exception is if a company is reporting “0” line quantities on page 4 whereby insert $0 in the total row for each of the three columns.)  "]
[]
[null,"Month","Relay Missouri Revenue Collected \n(collected or received, according to your record-keeping methods)",null,null,"Relay Missouri Retention Amount\n(of the amount collected)",null,null,"Relay Missouri Revenue Remitted to Commission\n(of the amount collected)"]
[null,null,"**",null,"**","**",null,"**","**",null,"**"]
[null,"January","**",null,"**","**",null,"**","**",null,"**"]
[null,"February","**",null,"**","**",null,"**","**",null,"**"]
[null,"March","**",null,"**","**",null,"**","**",null,"**"]
[null,"April","**",null,"**","**",null,"**","**",null,"**"]
[null,"May","**",null,"**","**",null,"**","**",null,"**"]
[null,"June","**",null,"**","**",null,"**","**",null,"**"]
[null,"July","**",null,"**","**",null,"**","**",null,"**"]
[null,"August","**",null,"**","**",null,"**","**",null,"**"]
[null,"September","**",null,"**","**",null,"**","**",null,"**"]
[null,"October","**",null,"**","**",null,"**","**",null,"**"]
[null,"November","**",null,"**","**",null,"**","**",null,"**"]
[null,"December","**",null,"**","**",null,"**","**",null,"**"]
[null,"Total","**",{"$f":"IF(COUNT(D11:D22), SUM(D11:D22), \"\")","v":""},"**","**",{"$f":"IF(COUNT(G11:G22), SUM(G11:G22), \"\")","v":""},"**","**",{"$f":"IF(COUNT(J11:J22), SUM(J11:J22), \"\")","v":""},"**"]
[]
[]
[{"$f":"SUM(A7+1)","v":9},"Please indicate the per line value of the Relay Missouri Surcharge applied to your customers in December.\n\n"]
[]
[]
[{"$f":"SUM(A26+1)","v":10},"If your firm did not impose the Relay Missouri Surcharge, please explain: "]
[]
[]
[1,"Companies classified in the MoPSC’s EFIS system solely as IXCs are not expected to complete this page."]
[]
[null,null,null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,null,null,null,null,"For use when filing under seal."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Public"]
[null,null,null,null,null,null,"Highly Confidential"]
[null,null,null,null,null,null,"Proprietary"]

{"sheet":"Verficiation Page","index":5,"n_rows":34,"n_cols":16,"rows_kept":34,"cut":false,"hidden":false,"merged":[[22,9,22,11],[18,4,18,13],[23,4,23,5],[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],[32,2,32,7],[24,7,24,13],[25,7,25,13],[28,4,28,5],[29,3,29,5],[29,6,29,11],[30,7,30,13],[28,8,28,9],[31,8,31,12]]}
[]
[null,null,"Annual Report of",null,null,{"$f":"IF('Form Page 1'!A1>0, 'Form Page 1'!A1, \"\")","v":"MCImetro Access Transmission Services LLC d/b/a Verizon Access Transmission Services"}]
[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":2012}]
[]
[]
[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,"California",null,null,null,null,"}"]
[null,null,null,null,null,null,null,null,null,"}","ss:"]
[null,null,"County Of",null,"San Francisco",null,null,null,null,"}"]
[null,null,null,null,"Haleh Davary",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,"Regulatory Analyst"]
[null,null,null,null,"Official Title of the Affiant (Company Official/Representative)"]
[null,null,"of",null,"MCImetro Access Transmission Services LLC d/b/a Verizon Access Transmission Services"]
[null,null,null,null,"Exact Legal Title or Name of the Respondent (Certificated Company Name)"]
[null,null,"and is located at",null,"201 Spear Street, 7th Fl, San Francisco, CA 94105,  (415) 228-1072  Public",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":2012},", to and including","December 31",null,null,", ",{"$f":"IF('Form Page 1'!D10>0, 'Form Page 1'!D10, \" \")","v":2012}]
[null,null,null,null,"Month/Day",null,null,"Year",null,"Month/Day",null,null,null,"Year"]
[]
[null,null,null,null,null,null,null,"Signature of Affiant (Company Official/Representative)"]
[]
[null,null,"Subscribed and sworn to before me, a Notary Public, in and for the State and County above named, "]
[null,null,null,"this     ","11th",null,null,"day of","April ",null,",",2013]
[null,null,null,"        My Commission expires",null,null,null,null,null,null,null,null,","]
[]
[null,null,null,null,null,null,null,null,"Signature of Notary Public"]
[null,null,"Missouri Revised Statutes § 392.210 or §393.140"]
[null,"When filing this form electronically, electronic signatures are acceptable.  See the instructions for details. "]