Zayo — Q3 2015 Earnings Presentation
65 slides from Zayo's earnings presentation, May 13, 2015
Slide 1: Fiscal Year 2015 Q3 Supplemental Earnings Information
Zayo Group Holdings, Inc. Fiscal Year 2015 Q3 Supplemental Earnings Information Exhibit 99.2
Slide 2: Forward-Looking Statements
Forward-Looking Statements 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,” “plans,” “intends,” “estimates,” “projects,” “
Slide 3: Presentation of Certain Consolidated Pro-forma Financial Data
Presentation of Certain Consolidated Pro-forma Financial Data 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 sets forth its pro-forma annualized revenue grow
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 Adjusted EBITDA, Adjusted EBITDA Margin, unlevered free cash flow, adjusted unlevered free cash flow, levered free cash flo
Slide 5: Adjusted EBITDA and debt covenants
We also monitor Adjusted EBITDA because our subsidiaries have debt covenants that restrict their borrowing capacity that are based on a leverage ratio, which utilizes a modified EBITDA, as defined in our credit agreement and the indentures governing our notes. The modified EBITDA is consistent with
Slide 6: Non-GAAP Financial Measures (continued)
Non-GAAP Financial Measures (continued) Our computation of Adjusted EBITDA, unlevered free cash flow, adjusted unlevered free cash flow, levered free cash flow, AFFO, and Net AFFO may not be comparable to other similarly titled measures computed by other companies because all companies do not calcul
Slide 7: Recent Developments
Recent Developments IdeaTek Acquisition On December 3, 2014, the Company entered into a stock purchase agreement with the shareholders of IdeaTek Systems, Inc. ("IdeaTek"). The acquisition closed on January 1, 2015. The purchase price, subject to certain post-closing adjustments, was $53.6 million a
Slide 8: Financial Highlights
Financial Highlights 8| FY2015 Q3 Supplemental Earnings Information zayo
Slide 9: Consolidated Financial Data
Consolidated Financial Data 1Pro-forma annualized growth for revenue and Adjusted EBITDA are calculated as if the acquisitions occurred on the first day of the quarter preceding the respective quarter in which the acquisitions closed Financial Data
Slide 10: Foreign Exchange Impact & Exposure
Foreign Exchange Impact & Exposure Foreign Exchange Impact & Exposure d 1 Pro-forma Acquisition Adjusted growth rates reflective of IdeaTek and Latisys acquisitions 2 Constant currency is based on the average US Dollar to British Pound and to Euro foreign exchange rates for the base comparative peri
Slide 11: Estimated Bookings less Netex
Estimated Bookings less Netex1 Net New Sales (Bookings) Net New Sales (Bookings) Net New Sales (Bookings) Estimated Capital and Upfront Expenditures associated with Net New Sales (Bookings) less Upfront Charges thousands thousands millions months MRR and MAR Monthly Bookings less Netex Est Bookings
Slide 12: Estimated Capital and Upfront Expenditures and Net New Sales (Bookings)
Estimated Capital and Upfront Expenditures and Net New Sales (Bookings) IRU and Upfront Charges Net New Sales (Bookings) – IRU and Upfront Charges Net New Sales (Bookings) from IRUs Net New Sales (Bookings) Upfront Charges Net New Sales (Bookings) Other Charges (Construction Services, Other) million
Slide 13: Stratification of Net New Sales (Bookings)
Stratification of Net New Sales (Bookings) Net New Sales (Bookings) Stratification
Slide 14: Major Committed Capital Projects
Major Committed Capital Projects FTT: Dallas FTT: Denver LH DF: Phoenix-Dallas zColo: Facility Additions & Expansions Adds unique link in Zayo US longhaul dark fiber network Mix of self-construct, existing and acquired conduit assets Net Capex ~$15M over 2015-17 Substantially expands already extensi
Slide 15: Installation and Churn Processed
Installation and Churn Processed Installation and Churn Processed Net Installations thousands thousands thousands MRR and MAR MRR and MAR MRR and MAR Gross Installations Churn Processed Churn =
Slide 16: Service Activation and Churn Pipeline
Service Activation and Churn Pipeline 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 millions Service Orders – MRR Service Orders – MAR R
Slide 17: Revenue Under Contract
Revenue Under Contract Revenue Under Contract Revenue Under Contract millions Average Remaining Contract Term Months
Slide 18: Stratification of Revenue
Stratification of Revenue millions millions millions millions MRR and MAR on the Last Day of the Quarter1 MRR on the last day of the quarter MAR of the last day of the quarter millions Revenue Stratification MAR – Upfront Charges MAR - IRU 1 The change in MRR and MAR on the last day of the quarter i
Slide 19: Stratification of Adjusted EBITDA
Stratification of Adjusted EBITDA millions 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 Early Termination Revenue and Construction Servic
Slide 20: Purchases of Property and Equipment
millions Purchases of Property and Equipment Purchases of Property and Equipment by Driver Capital Expenditures Purchases of Property and Equipment Maintenance, Integration and Other Growth Capital Expenditures Capital Expenditures Capital Expenditures millions millions millions Purchases of Propert
Slide 21: Cash Flow Stratification
Cash Flow Stratification % of Revenue millions Purchases of Property and Equipment % of Revenue millions Adjusted EBITDA % of Revenue millions Net Capital1 1 Net Capital is equal to “Cash Outflows for Purchases of Property and Equipment” less “Additions to Deferred Revenue” 2 Unlevered Free Cash Flo
Slide 22: Net AFFO
Net AFFO millions Plus: <12 month payback net sales millions millions Less: Churn processed millions Plus: Upfront customer payments on <12 mo. payback net sales millions millions Net AFFO % of Revenue Less: CapEx from <12 mo. payback net sales and Network Capacity CapEx AFFO % of Revenue
Slide 23: Inorganic Activity
Inorganic Activity 23| FY2015 Q3 Supplemental Earnings Information zayo
Slide 24: IdeaTek Acquisition
IdeaTek Acquisition On January 1, 2015, the Company acquired IdeaTek Systems Inc. (“IdeaTek”). The purchase price, subject to certain closing and post-closing adjustments, was $52.0 million and was paid with cash on hand. The high Adjusted EBITDA multiple reflects the large revenue install pipeline
Slide 25: Latisys Acquisition
Latisys Acquisition Latisys Statistics On February 23, 2015, the Company acquired the operating units of Latisys Holdings, LLC (“Latisys”), a colocation and infrastructure as a service (“IaaS”) provider for a price of $675.0 million, subject to certain post-closing adjustments. The Latisys acquisiti
Slide 26: ZGH Acquisition History
Weighted Average Multiple = 10.1x Pre-Synergy and 7.4x Post Synergy ZGH Acquisition History 1Estimated Revenue LQA and Adjusted EBITDA LQA represents the Revenue and Adjusted EBITDA (adjusted for estimated purchase accounting adjustments) recognized by the acquired entity during the last quarterly p
Slide 27: Organic vs. Inorganic Revenue Growth
Organic vs. Inorganic Revenue Growth Organic growth is a derived figure calculated as the difference between reported Revenue (annualized) and cumulative acquired Revenue ZGH Acquired and Organic Revenue Growth Cumulative Acquired Revenue Annualized Organic Revenue Incremental Acquired Revenue 5 6 7
Slide 28: Organic vs. Inorganic Adj EBITDA Growth
Organic vs. Inorganic Adj EBITDA Growth 8First Telecommunications (2.5 mos), Litecast (3 mos) 9Core NAP (1 mo) 10 Core NAP (2 mos), CoreLink (2 mos) 11 Corelink (1 mo), Access Communications, Fiberlink 12 CoreXchange (1 mo) 13 CoreXchange (2 mos), Geo (1.5 mos, based on 1.6548 FX rate) 14Geo (1.5 mo
Slide 29: Synergy Attainment Assessment through Dec-14
Synergy Attainment Assessment through Dec-14 Synergy Attainment through Dec-14 Assuming a 70% Adjusted EBITDA contribution on incremental organic revenue (see analysis1 below), we have concluded that we attained all planned synergies related to acquisitions closed prior to the quarter ended Dec-14 1
Slide 30: Mar-15 Synergy Update
Mar-15 Synergy Update Per prior slide, have concluded that no more remaining synergies from acquisitions closed prior to quarter ended Dec-14 Expect to achieve $8M of synergies from combined IdeaTek and Latisys acquisitions, both of which closed in Mar-15 quarter Expect to achieve these synergies by
Slide 31: Operational Data
Operational Data 34| FY2015 Q3 Supplemental Earnings Information zayo
Slide 32: Customer Verticals and Product Mix
Customer Verticals and Product Mix Customer Verticals and Product Mix1 1 Customer Verticals and Product Mix excludes the Other segment
Slide 33: Fiber to the Tower (FTT) and Small Cell Metrics
Total FTT Tenants 2,3 Mobile Infrastructure (FTT & Small Cell) Total FTT Towers & Small Cells 2,3 FTT Bandwidth/Tenant (Mbs)1 Towers & Small Cells Tenants Mbs In Service Tenants/In Service Tower = 1 Bandwidth/Tenant excludes Dark Fiber sites 2 In Service counts reflect instances where Zayo owns the
Slide 34: Customer Metrics
Customer Metrics Customer Metrics Number of Customers Customers MRR and MAR (MRR and MAR)/Customer thousands % of MRR Customer #1 Customer #2 Customer #3 Top 20 Top 10 Top 5 Customer Concentration
Slide 35: Employee Data
Employee Data Employee & QBHC Data Number of Employees thousands Headcount Financial Statement Revenue Annualized Revenue per Employee Quota Bearing Headcount Monthly Average Net New Sales (Bookings) per QBHC thousands Headcount Net New Sales (Bookings) MRR and MAR
Slide 36: Network Metrics
Network Metrics Network Metrics1 Fiber Network - Route Miles Route Miles Fiber Miles On-Net Buildings Number of Markets thousands States = Fiber Network - Fiber Miles Number of On-net Buildings Number of Markets 1 As the Company audits network and building metrics any adjustments are reflected in th
Slide 37: Network Metrics On-Net Buildings
Network Metrics On-Net Buildings1 1 As the Company audits network and building metrics, any adjustments are reflected in the metrics above
Slide 38: Network Metrics Colocation Cabinet Utilization
Network Metrics Colocation Cabinet Utilization Billable Colocation Square Feet Utilized Colocation Cabinet Equivalents Square Feet Colocation Cabinet Equivalents Colocation Cabinet Equivalents Utilization = Colocation Cabinet Equivalents
Slide 39: Breakdown of Installations and Churn Processed
Breakdown of Installations and Churn Processed Installation and Churn Processed1 thousands thousands MRR and MAR MRR and MAR Churn % = Gross Installations Churn Processed 1Beginning in the three months ended September 30, 2013, the Company began reporting Replacement Services. The installs were prev
Slide 40: Price Changes and Renewals
Price Changes and Renewals Price Increases Price Decreases thousands millions thousands MRR Contract Value MRR Price Changes Net of Price Increases and Price Decreases thousands MRR Price increases as % of MRR = Price decreases as % of MRR = Price Increases MRR before Price Increases Price Decreases
Slide 41: Upgrades
Upgrades Upgrades Gross Installations Associated with Upgrades thousands thousands Churn Processed Associated with Upgrades1 Net Installations Associated with Upgrades MRR and MAR MRR and MAR MRR and MAR Contract Value Contract Value = Contract Value = 1Churn Processed Associated with Upgrades may o
Slide 42: Replacement Services
1Beginning in the three months ended September 30, 2013, the Company began reporting Replacement Services. The installs were previously reported as New Services, and the churn was included in Hard Disconnects 2 Churn Processed associated with Replacement Services may occur in a different fiscal quar
Slide 43: Financial Data by Reporting Segment
Financial Data by Reporting Segment
Slide 44: Zayo Physical Infrastructure Segment Financial Data
Zayo Physical Infrastructure Segment Financial Data 1 Pro-forma annualized growth for revenue and Adjusted EBITDA are calculated as if the acquisitions occurred on the first day of the quarter preceding the respective quarter in which the acquisitions closed Financial Data
Slide 45: Zayo Physical Infrastructure Segment Revenue Stratification & Operational Data
millions Revenue Stratification Estimated Capital and Upfront Expenditures associated with Net New Sales (Bookings) less Upfront Charges millions Zayo Physical Infrastructure Segment Revenue Stratification & Operational Data thousands Churn Processed Gross Installations MRR and MAR MRR and MAR thous
Slide 46: Zayo Physical Infrastructure Segment Cash Flow Stratification
% of Revenue millions Purchases of Property and Equipment % of Revenue millions Adjusted EBITDA % of Revenue millions Net Capital1 % of Revenue millions Adj Unlevered FCF3 % of Revenue millions Unlevered Free Cash Flow (FCF)2 $4.3 million lease termination cost adjustment Zayo Physical Infrastructur
Slide 47: Zayo Cloud & Connectivity Segment Financial Data
Zayo Cloud & Connectivity Segment Financial Data Financial Data 1 Pro-forma annualized growth for revenue and Adjusted EBITDA are calculated as if the acquisitions occurred on the first day of the quarter preceding the respective quarter in which the acquisitions closed
Slide 48: Zayo Cloud & Connectivity Segment Revenue Stratification & Operational Data
millions Revenue Stratification Net New Sales (Bookings) thousands MRR and MAR Zayo Cloud & Connectivity Segment Revenue Stratification & Operational Data thousands Churn Processed Gross Installations MRR and MAR MRR and MAR thousands Net Installations thousands MRR and MAR Churn % = Estimated Capit
Slide 49: Zayo Cloud & Connectivity Segment Cash Flow Stratification
% of Revenue millions Purchases of Property and Equipment % of Revenue millions Adjusted EBITDA % of Revenue millions Net Capital1 % of Revenue millions Adj Unlevered FCF3 % of Revenue millions Unlevered Free Cash Flow (FCF)2 $5.9 million lease termination cost adjustment Zayo Cloud & Connectivity S
Slide 50: Zayo Other Segment Financial Data
Zayo Other Segment Financial Data 1 Pro-forma annualized growth for revenue and Adjusted EBITDA are calculated as if the acquisitions occurred on the first day of the quarter preceding the respective quarter in which the acquisitions closed Financial Data
Slide 51: Segment Financial Data Rollup
Segment Financial Data Rollup Segment Data Rollup
Slide 52: Segment Financial Data
Segment Financial Data Segment Data
Slide 53: Invested Capital Ratio by Reporting Segment
Invested Capital Ratio by Reporting Segment Invested Capital
Slide 54: Historical Financial Data & Reconciliations
Historical Financial Data & Reconciliations
Slide 55: Consolidated Historical Financial Data
Consolidated Historical Financial Data Consolidated Financial Data
Slide 56: Consolidated Historical Reconciliations
Consolidated Historical Reconciliations Consolidated Financial Data
Slide 57: Segment Data Reconciliation: Net (Loss)/Earnings to Adjusted EBITDA
Segment Data Reconciliation: Net (Loss)/Earnings to Adjusted EBITDA Segment Data Reconciliation1 1A reconciliation of previous quarters’ legacy segment information can be found in our historical earnings supplements found on our website at http://www.zayo.com/financial-earnings-release
Slide 58: Cash from Operating Activities to Adjusted EBITDA
Consolidated Historical Reconciliation: Cash from Operating Activities to Adjusted EBITDA Consolidated Financial Data 1 1 Amortization of deferred revenue is equal to monthly amortized revenue (MAR)
Slide 59: AFFO & Net AFFO Reconciliation
AFFO & Net AFFO Reconciliation AFFO & Net AFFO Reconciliation
Slide 60: Pro-forma Growth Reconciliation (FY 2014 Q2)
Pro-forma Growth Reconciliation (Supporting FY 2014 Q2 Pro-forma Growth) Pro-forma Growth Reconciliation 1, 2 1 A reconciliation of previous quarter pro-forma growth can be found in our historical earnings supplements found on our website at http://www.zayo.com/financial-earnings-release 2 Includes
Slide 61: Pro-forma Growth Reconciliation (FY 2014 Q3)
Pro-forma Growth Reconciliation (Supporting FY 2014 Q3 Pro-forma Growth) Pro-forma Growth Reconciliation 1, 2 1 A reconciliation of previous quarter pro-forma growth can be found in our historical earnings supplements found on our website at http://www.zayo.com/financial-earnings-release 2 Includes
Slide 62: Pro-forma Growth Reconciliation (FY 2014 Q4)
Pro-forma Growth Reconciliation (Supporting FY 2014 Q4 Pro-forma Growth) Pro-forma Growth Reconciliation 1, 2 1 A reconciliation of previous quarter pro-forma growth can be found in our historical earnings supplements found on our website at http://www.zayo.com/financial-earnings-release 2 Includes
Slide 63: Pro-forma Growth Reconciliation (FY 2015 Q1)
Pro-forma Growth Reconciliation (Supporting FY 2015 Q1 Pro-forma Growth) Pro-forma Growth Reconciliation 1, 2 1 A reconciliation of previous quarter pro-forma growth can be found in our historical earnings supplements found on our website at http://www.zayo.com/financial-earnings-release 2 Includes
Slide 64: Pro-forma Growth Reconciliation (FY 2015 Q2)
Pro-forma Growth Reconciliation (Supporting FY 2015 Q2 Pro-forma Growth) Pro-forma Growth Reconciliation 1, 2 1 A reconciliation of previous quarter pro-forma growth can be found in our historical earnings supplements found on our website at http://www.zayo.com/financial-earnings-release 2 Includes
Slide 65: Pro-forma Growth Reconciliation (FY 2015 Q3)
Pro-forma Growth Reconciliation (Supporting FY 2015 Q3 Pro-forma Growth) Pro-forma Growth Reconciliation 1, 2 1 A reconciliation of previous quarter pro-forma growth can be found in our historical earnings supplements found on our website at http://www.zayo.com/financial-earnings-release 2 Includes