Zayo — Q1 FY2013 Earnings Presentation
60 slides from Zayo's earnings presentation, Nov 16, 2012
Slide 1: Fiscal Year 1Q 2013 Supplemental Earnings Information
1 Fiscal Year 1Q 2013 Supplemental Earnings Information FY 1Q 2013 Supplemental Earnings Information
Slide 2: Forward-Looking Statements
Forward-Looking Statements 2 FY 1Q 2013 Supplemental Earnings Information Information contained in this supplemental presentation that is not historical by nature constitutes "forward-looking statements" which can be identified by the use of forward-looking terminology such as "believes," "expects,"
Slide 3: Presentation of Certain Consolidated Pro-forma Financial Data
Presentation of Certain Consolidated Pro-forma Financial Data 3 FY 1Q 2013 Supplemental Earnings Information Acquisitions have been, and are expected to continue to be, a component of the Company's strategy. In this Supplemental Earnings Information under "Consolidated Financial Data," the Company s
Slide 4: Non-GAAP Financial Measures
Non-GAAP Financial Measures The Company provides financial measures that are not defined under generally accepted accounting principles in the United States, or GAAP, including earnings before interest, taxes, depreciation and amortization ("EBITDA") and Adjusted EBITDA. EBITDA and Adjusted EBITDA a
Slide 5: Other Notes: Operating Measures
Other Notes Operating Measures This earnings supplement contains operating measures used by the Company in managing the business. Management believes that providing this information enables analysts, investors, and others to obtain a better understanding of the Company's operating performance and to
Slide 6: Other Notes: Reporting Segments
Zayo Colocation Zayo Bandwidth Other Notes Reporting Segments The Company's segments (also referred to herein as business units) are aligned to our product offerings and currently consist of the following: Zayo Bandwidth ("ZB") offers lit bandwidth infrastructure services Zayo Colocation ("zColo") p
Slide 7: New Invested Capital and New Indebtedness
New Invested Capital New Indebtedness On July 2, 2012, the Company issued $750.0 million aggregate principal amount of 8.125% senior secured first-priority notes due 2020 and $500.0 million aggregate principal amount of 10.125% senior unsecured notes due 2020 (collectively, the "Notes Offering"). Th
Slide 8: Spin-Off of Professional Services Business
Spin-Off of Professional Services Business Zayo Professional Services As previously disclosed, in connection with certain business combinations, the Company may acquire assets or liabilities that support products outside of the Company's primary focus of providing bandwidth infrastructure services.
Slide 9: AboveNet Acquisition
AboveNet Acquisition 9 FY 1Q 2013 Supplemental Earnings Information AboveNet Statistics On March 18, 2012, the Company entered into an Agreement and Plan of Merger with AboveNet Inc. ("AboveNet"), a publicly traded company listed on the New York Stock Exchange. On July 2, 2012, the closing of the tr
Slide 10: FiberGate Acquisition
FiberGate Acquisition 10 FY 1Q 2013 Supplemental Earnings Information FiberGate Statistics On June 4, 2012, the Company entered into an agreement to acquire 100% of the equity interest in FiberGate. On August 31, 2012, the closing of the transaction contemplated by the agreement occurred, pursuant t
Slide 11: USCarrier Acquisition
USCarrier Acquisition 11 FY 1Q 2013 Supplemental Earnings Information US Carrier Statistics On August 15, 2012, the Company entered into a Unit Purchase Agreement with the owners of USCarrier Telecom Holdings LLC ("USCarrier") to purchase all remaining ownership units of USCarrier. On October 1, 201
Slide 12: First Telecom Services Purchase Agreement
First Telecom Services Purchase Agreement 12 FY 1Q 2013 Supplemental Earnings Information First Telecom Services Statistics 1 Annualized revenue and Adjusted EBITDA are based on the operating results of First Telecom for the three months ended September 30, 2012. Financial results do not reflect any
Slide 13: Acquisition History
Weighted Avg Multiple = 9.3x Pre-Synergy and 6.8x Post Synergy 13 Acquisition History1 Average age of investment (weighted by size, in years): 1.3 years 0.8 years FY 1Q 2013 Supplemental Earnings Information 1 LQA Revenue/EBITDA have been adjusted for purchase accounting adjustments and intercompany
Slide 14: Consolidated Financial Data
Consolidated Financial Data 14 FY 1Q 2013 Supplemental Earnings Information Financial Data 1 The three months ended September 30, 2012 include one month of operating results from the FiberGate acquisition and three months of operating results from the AboveNet acquisition. Adjusting for the effect o
Slide 15: Pro-Forma Annualized Growth
Pro-Forma Annualized Growth 15 FY 1Q 2013 Supplemental Earnings Information Zayo Group Adjusted EBITDA Growth1 Adjusted EBITDA Associated with Other Revenue Zayo AboveNet millions Annualized Adjusted EBITDA Growth: millions 13% 1 Adjusted EBITDA of acquired entities is net of estimated purchase acco
Slide 16: Net Earnings Stratification
Net Earnings Stratification 16 millions Net Income/(loss) from Continuing Operations millions Net Earnings EBITDA Interest expense Provision for income tax Depreciation and amortization Other add backs1 Other Add Backs millions Income from continuing operations Income from discontinued operations, n
Slide 17: Cash Flow Stratification
Cash Flow Stratification 17 millions millions millions Net Increase/(Decrease) in Cash and Cash Equivalents millions Ending Cash Balance Cash from operating activities Cash from financing Cash from investing Cash from discontinued operations millions Net Cash Provided by/(Used in) Investing Activiti
Slide 18: Consolidated Invested Capital Ratio
Consolidated Invested Capital Ratio 18 FY 1Q 2013 Supplemental Earnings Information Invested Capital 1 For the three months ended September 30, 2012, the increase in member's interest is primarily due to an additional $337.2 million in equity which was contributed to the Company on July 2, 2012 in c
Slide 19: Segment Financial Data
Segment Financial Data 19 FY 1Q 2013 Supplemental Earnings Information Segment Data 1 Represents intercompany eliminations associated with transactions with ZPS 1
Slide 20: Invested Capital Ratio by Business Unit
Invested Capital Ratio by Business Unit 20 Invested Capital FY 1Q 2013 Supplemental Earnings Information 1 Represents intercompany eliminations associated with transactions with ZPS 1
Slide 21: Acquired and Organic Revenue Growth
Acquired and Organic Revenue Growth 8% Organic Revenue Growth (Date Weighted CAGR) Cumulative Acquired Revenue Annualized Organic Revenue 2 The Company acquired annualized revenue through Sep-08 includes Memphis Networx, IFW, Onvoy, Citynet, Ctel Tri-State Markets, CFS Incremental Acquired Revenue 1
Slide 22: Organic vs. Inorganic Adjusted EBITDA Growth
Cumulative Acquired EBITDA Annualized Organic EBITDA growth Adjusted EBITDA Growth Adjusted EBITDA Margin 22% Organic EBITDA Growth - 52% with Synergies (Date Weighted CAGR)1 Planned Synergies Incremental Acquired EBITDA 2 2 3 4 5 6 2 Fibernet 3 AGL Networks & Dolphini 4 AFS 5 360Networks (1 month o
Slide 23: Stratification of Revenue
Stratification of Revenue 23 millions millions millions millions MRR and MAR on the Last Day of the Quarter MRR on the last day of the quarter MAR of the last day of the quarter millions Revenue Stratification FY 1Q 2013 Supplemental Earnings Information MRR Usage MAR Other Revenue MAR - Upfront Cha
Slide 24: Stratification of Adjusted EBITDA
Stratification of Adjusted EBITDA 24 millions FY 1Q 2013 Supplemental Earnings Information millions Adjusted EBITDA Associated with Other Revenue Stratification of Adjusted EBITDA Adjusted EBITDA Stratification Adjusted EBITDA associated with Credits and Adjustments Adjusted EBITDA associated with E
Slide 25: Gross New Sales (Bookings)
Gross New Sales (Bookings) 25 FY 1Q 2013 Supplemental Earnings Information Gross New Sales (Bookings) Gross New Sales (Bookings) Estimated Gross Profit and Gross Profit Percentage on Gross New Sales (Bookings) Estimated Capital and Upfront Expenditures associated with Gross New Sales (Bookings) less
Slide 26: Estimated Capital and Upfront Expenditures and Gross New Sales
26 FY 1Q 2013 Supplemental Earnings Information Estimated Capital and Upfront Expenditures and Gross New Sales (Bookings) IRU and Upfront Charges Contract Value = Gross New Sales (Bookings) - IRU and Upfront Charges Gross New Sales (Bookings) from IRUs Gross New Sales (Bookings) Upfront Charges Gros
Slide 27: Stratification of Gross New Sales (Bookings)
Stratification of Gross New Sales (Bookings) 27 FY 1Q 2013 Supplemental Earnings Information Gross New Sales (Bookings) Stratification
Slide 28: Stratification of Speculative Projects
Stratification of Speculative Projects FY 1Q 2013 Supplemental Earnings Information 28 Speculative Capital Expenditure Commitments 1 For the three months ended September 30, 2012, Speculative Capital Expenditure Commitments include $5 thousand of Gross New Sales (Bookings) and $1.5 million of capita
Slide 29: Quota Bearing Headcount (QBHC)
Quota Bearing Headcount (QBHC) FY 1Q 2013 Supplemental Earnings Information 29 Quota Bearing Headcount Quota Bearing Headcount Monthly Average Gross New Sales (Bookings) per QBHC thousands Headcount Gross New Sales (Bookings) MRR and MAR
Slide 30: Installation and Churn Processed
Installation and Churn Processed 30 FY 1Q 2013 Supplemental Earnings Information Installation and Churn Processed Net Installations Gross Profit from Net Installations thousands thousands thousands thousands MRR and MAR MRR and MAR MRR and MAR Monthly Gross Profit Est. Gross Profit = Est. Gross Prof
Slide 31: Breakdown of Installations and Churn Processed
Breakdown of Installations and Churn Processed Installation and Churn Processed 31 FY 1Q 2013 Supplemental Earnings Information Gross Installations thousands Churn Processed thousands MRR and MAR MRR and MAR Churn =
Slide 32: Price Changes and Renewals
Price Changes and Renewals Price Increases Net Contract Value Associated with Price Changes and Renewals Price Decreases thousands millions thousands MRR Contract Value MRR Price Changes Net of Price Increases and Price Decreases thousands MRR 32 FY 1Q 2013 Supplemental Earnings Information Price in
Slide 33: Upgrades
Upgrades Upgrades Gross Installations Associated with Upgrades Average % Increase in Monthly Recurring Revenue Associated with Upgrades thousands thousands thousands Churn Processed Associated with Upgrades Net Installations Associated with Upgrades 33 FY 1Q 2013 Supplemental Earnings Information MR
Slide 34: Service Activation and Churn Pipeline
Service Activation and Churn Pipeline 34 FY 1Q 2013 Supplemental Earnings Information Service Activation and Churn Pipeline Service Activation Pipeline Estimated Timing of Service Activation Pipeline Churn Pipeline Net Installation Pipeline millions millions millions MRR and MAR MRR MRR and MAR mill
Slide 35: Revenue Under Contract
Revenue Under Contract 35 FY 1Q 2013 Supplemental Earnings Information Revenue Under Contract Revenue Under Contract millions Average Remaining Contract Term Months
Slide 36: Employee Data
Employee Data FY 1Q 2013 Supplemental Earnings Information 36 Employee Data Number of Employees Employee Related SG&A thousands millions thousands Headcount Financial Statement Revenue SG&A SG&A % of Revenue = Annualized Revenue per Employee Annualized Employee Related SG&A per Employee
Slide 37: Customer Verticals and Product Mix
Customer Verticals and Product Mix 37 FY 1Q 2013 Supplemental Earnings Information Customer Verticals and Product Mix
Slide 38: Customer Concentration
Customer Concentration 38 FY 1Q 2013 Supplemental Earnings Information Customer Concentration % of MRR Customer #1 Customer #2 Customer #3 Top 20 Top 10 Top 5
Slide 39: Customer and Unit Metrics
Customer and Unit Metrics Customer and Unit Metrics Number of Customers Number of Units (MRR and MAR)/Unit 39 FY 1Q 2013 Supplemental Earnings Information Customers MRR and MAR MRR and MAR Units (MRR and MAR)/Customer thousands thousands thousands 1 For the three months ended September 30, 2012, Zay
Slide 40: Pricing Trends - Waves
Pricing Trends1 - Waves FY 1Q 2013 Supplemental Earnings Information 40 thousands MRR MRR thousands thousands MRR MRR thousands thousands MRR MRR thousands 1 Increase in MRR and units for Wavelengths in the three months ended September 2012 driven primarily by acquired AboveNet base. 10G MRR and uni
Slide 41: Pricing Trends - Ethernet
Pricing Trends - Ethernet FY 1Q 2013 Supplemental Earnings Information 41 thousands MRR MRR thousands thousands MRR MRR thousands thousands MRR MRR thousands GigE Full Rate (>1000Mb) - MRR/Unit Fractional GigE (101-1000Mb) - MRR/Unit
Slide 42: Pricing Trends - OC3, OC12, and OC48
Pricing Trends - OC3, OC12, and OC48 FY 1Q 2013 Supplemental Earnings Information 42 thousands MRR MRR thousands thousands MRR MRR thousands thousands MRR MRR thousands
Slide 43: Pricing Trends - DS1 and DS3
Pricing Trends - DS1 and DS3 FY 1Q 2013 Supplemental Earnings Information 43 thousands MRR MRR thousands thousands MRR MRR thousands
Slide 44: Purchases of Property and Equipment
millions Purchases of Property and Equipment Purchases of Property and Equipment by Driver 44 FY 1Q 2013 Supplemental Earnings Information Capital Expenditures Purchases of Property and Equipment Maintenance, Integration and Other Growth Capital Expenditures Capital Expenditures Capital Expenditures
Slide 45: Network Metrics
Network Metrics 45 FY 1Q 2013 Supplemental Earnings Information Network Metrics Fiber Network - Route Miles Fiber Network - Fiber Miles Number of On-net Buildings Number of Markets Route Miles Fiber Miles On-Net Buildings Number of Markets thousands States = 1 1
Slide 46: Network Metrics: On-Net Buildings
Network Metrics 46 FY 1Q 2013 Supplemental Earnings Information On-Net Buildings
Slide 47: Network Metrics: Colocation Cabinet Utilization
Network Metrics 47 FY 1Q 2013 Supplemental Earnings Information Colocation Cabinet Utilization Billable Colocation Square Feet Colocation Cabinet Equivalents Utilized Colocation Cabinet Equivalents Square Feet Colocation Cabinet Equivalents Colocation Cabinet Equivalents Utilization =
Slide 48: Fiber to the Tower
FY 1Q 2013 Supplemental Earnings Information 48 Fiber to the Tower
Slide 49: Fiber to the Tower (FTT)
1 Bandwidth/Tenant excludes Dark-Fiber sites Revenue/Tenant Fiber to the Tower (FTT) Fiber to the Tower Total FTT Towers Bandwidth/Tenant (Mbs)1 Revenue/Tower & Revenue/Tenant thousands 49 FY 1Q 2013 Supplemental Earnings Information Towers Tenants MRR and MAR Mbs Revenue/Tower Total FTT Tenants In
Slide 50: FTT MRR and MAR, Capital Expenditures and Product Mix
% of MRR and MAR % of MRR and MAR % of Zayo Group's Wireless Carrier MRR and MAR Fiber to the Tower (FTT) FTT MRR and MAR FTT Cumulative Capital Expenditures FTT Product Mix millions millions 50 FY 1Q 2013 Supplemental Earnings Information MRR and MAR % of FTT MRR and MAR Capital Expenditures % of Z
Slide 51: FTT Markets
FTT Markets FTT Markets Mid-Atlantic includes Washington D.C., Maryland, New Jersey, Virginia, West Virginia, and Pennsylvania North Central includes Indiana, Minnesota, Kentucky, and Ohio Pacific Northwest includes Idaho, Montana, Oregon and Washington Southeast includes Tennessee, Mississippi and
Slide 52: Financial Data by Business Unit
FY 1Q 2013 Supplemental Earnings Information 52 Financial Data by Business Unit
Slide 53: Zayo Bandwidth Financial Data
Zayo Bandwidth Financial Data 53 Financial Data FY 1Q 2013 Supplemental Earnings Information 1 The three months ended September 30, 2012 include three months of operating results from acquired AboveNet business. Adjusting for the effect of the transaction as if it had occurred on April 1, 2012, the
Slide 54: Zayo Fiber Solution Financial Data
Zayo Fiber Solution Financial Data FY 1Q 2013 Supplemental Earnings Information 54 Financial Data 1 The three months ended September 30, 2012 include one month of operating results from the acquired FiberGate business and three months of operating results from acquired AboveNet business. Adjusting f
Slide 55: zColo Financial Data
1 The three months ended September 30, 2012 include three month of operating results from acquired AboveNet business. Adjusting for the effect of the acquisition as if it had occurred on April 1, 2012, the annualized revenue and Adjusted EBITDA growth rates for the three months ended September 30, 2
Slide 56: Historical Financial Data & Reconciliations
FY 1Q 2013 Supplemental Earnings Information 56 Historical Financial Data & Reconciliations
Slide 57: Consolidated Historical Financial Data
Consolidated Historical Financial Data 57 FY 1Q 2013 Supplemental Earnings Information Consolidated Financial Data
Slide 58: Consolidated Historical Reconciliations
Consolidated Historical Reconciliations 58 FY 1Q 2013 Supplemental Earnings Information Consolidated Financial Data
Slide 59: Segment Data Reconciliation: Net Earnings/(loss) to Adjusted EBITDA
59 FY 1Q 2013 Supplemental Earnings Information Segment Data Reconciliation: Net Earnings/(loss) to Adjusted EBITDA Segment Data Reconciliation 1 A reconciliation of previous quarters' segment information can be found in our historical earnings supplements found on our website at http://www.zayo.com
Slide 60: Pro-forma Growth Reconciliation
60 FY 1Q 2013 Supplemental Earnings Information Pro-forma Growth Reconciliation (Supporting FY 2013 Q1 Pro-forma Growth) Pro-forma Growth Reconciliation3 As discussed on the slide titled "Spin-off of Professional Services Business," on September 30th, 2012, the Company spun-off ZPS to Zayo Group Hol