Zayo — Q2 2015 Earnings Presentation
65 slides from Zayo's earnings presentation, Feb 11, 2015
Slide 1: Fiscal Year 2015 Q2 Supplemental Earnings Information
Zayo Group Holdings, Inc. Fiscal Year 2015 Q2 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: Non-GAAP Financial Measures (Adjusted EBITDA use)
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: Other Notes
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 8: Recent Developments
Recent Developments Early Redemption of Senior Notes On December 15, 2014, the Company redeemed $75.0 million of its outstanding 8.125% Senior Secured Notes at a price of 108.125% of the principal amount and $174.4 million of its outstanding 10.125% Senior Unsecured Notes at a price of 110.125% (col
Slide 9: Financial Highlights
Financial Highlights 9| FY2015 Q2 Supplemental Earnings Information zayo
Slide 10: 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 11: Foreign Exchange Impact & Exposure
Foreign Exchange Impact & Exposure Foreign Exchange Impact & Exposure 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 2 Constant currency is
Slide 12: Estimated Bookings less Netex
Estimated Bookings less Netex2 Net New Sales (Bookings) Net New Sales (Bookings) 1 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 Booking
Slide 13: Estimated Capital and Upfront Expenditures and Net New Sales (Bookings)
Estimated Capital and Upfront Expenditures and Net New Sales (Bookings) IRU and Upfront Charges Contract Value = 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 Service
Slide 14: Stratification of Net New Sales (Bookings)
Stratification of Net New Sales (Bookings) Net New Sales (Bookings) Stratification
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: 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 17: 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 18: 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 19: 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 20: AFFO
AFFO millions Non-cash Adjustments1 millions Income/(Loss) from Continuing Operations millions Other Adjustments2 millions Maintenance CapEx (As Reported) 1 Includes MAR, Depreciation & Amortization, Stock-based Compensation, Foreign Currency Loss/(Gain) on Intercompany Loan, and Non-cash Loss on In
Slide 21: Net AFFO
Net AFFO millions <12 month payback net sales millions millions Churn processed millions Plus: Upfront customer payments on <12 mo. payback net sales millions millions Net AFFO AFFO % of Revenue Less: CapEx from <12 mo. payback net sales and Network Capacity CapEx
Slide 22: Inorganic Activity
Inorganic Activity 22| FY2015 Q2 Supplemental Earnings Information zayo
Slide 23: ZGH Acquisition History
Weighted Average Multiple = 9.6x Pre-Synergy and 6.9x Post Synergy ZGH Acquisition History1 1Companies denoted by * indicate Purchase Price was adjusted for value attributed to Onvoy Voice Services / Zayo Enterprise Networks /spin-offs 2Revenue and Adjusted EBITDA (adjusted for estimated purchase ac
Slide 24: 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 4 5 6
Slide 25: Organic vs. Inorganic Adj EBITDA Growth
Organic vs. Inorganic Adj EBITDA Growth Organic growth is a derived figure calculated as the difference between reported Adjusted EBITDA (annualized) and cumulative acquired Adjusted EBITDA plus Planned (not necessarily realized) Synergies 8First Telecommunications (2.5 mos), Litecast (3 mos) 9Core
Slide 26: Planned Synergies Summary
Planned Synergies Summary Planned Synergies ($M) 1Calculated by comparing pro-forma revenue growth (further adjusted to remove other revenue) multiplied by 70% (an estimated incremental Adjusted EBITDA margin) to actual pro-forma Adjusted EBITDA growth. The amount by which the latter is greater than
Slide 27: IdeaTek Acquisition
IdeaTek Acquisition On December 3, 2014, the Company entered into a stock purchase agreement with the shareholders of IdeaTek Systems, Inc. ("IdeaTek"). The acquisition of IdeaTek closed on January 1, 2015. Upon the close of the IdeaTek acquisition, the Company acquired all of the equity interest in
Slide 28: Latisys Acquisition
Latisys Acquisition Latisys Statistics On January 13, 2015, the Company entered into an acquisition agreement to acquire the operating units of Latisys Holdings, LLC (“Latisys”), a colocation and infrastructure as a service (“IaaS”) provider for a price of $675.0 million. The Latisys acquisition wil
Slide 29: Latisys Fills zColo Market Gaps
Latisys Fills zColo Market Gaps 60 Hudson, NYC The Infomart, Dallas 12201 Tukwila, Seattle 7185 Pollock, Las Vegas 600 S Federal, Chicago 7218 McNeil, Austin 1100 White St, Atlanta 111 8th, NYC Pro-forma: 45 sites in US & France 8 additional from Latisys >503,000 billable sq ft 187K additional from
Slide 30: Latisys & IdeaTek to Reporting Segments
Latisys & IdeaTek à Reporting Segments 1 Reflects renaming from Zayo Lit Services post-close of Latisys acquisition Reporting Segment Breakdown Zayo Cloud & Connectivity1 (47% of Pro-forma Revenue) Zayo Physical Infrastructure (49% of Pro-forma Revenue) Zayo Dark Fiber Zayo Colocation Zayo Ethernet
Slide 31: Operational Data
Operational Data 34| FY2015 Q2 Supplemental Earnings Information zayo
Slide 32: Customer Verticals and Product Mix
Customer Verticals and Product Mix Customer Verticals and Product Mix 1 1 Customer Verticals and Product Mix excludes the Other segment
Slide 33: Fiber to the Tower (& Small Cell)
Total FTT Tenants 2,3 FTT Revenue/Tower & FTT Revenue/Tenant Revenue/Tower Revenue/Tenant Mobile Infrastructure (FTT & Small Cell) Total FTT Towers & Small Cells 2,3 FTT Bandwidth/Tenant (Mbs)1 thousands Towers & Small Cells Tenants MRR and MAR Mbs In Service Tenants/In Service Tower = 1 Bandwidth/T
Slide 34: Fiber to the Tower (FTT)
Fiber to the Tower (FTT) FTT MRR and MAR millions MRR and MAR % of FTT MRR and MAR Fiber to the Tower FTT Product Mix
Slide 35: 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 36: Revenue Under Contract
Revenue Under Contract Revenue Under Contract Revenue Under Contract millions Average Remaining Contract Term Months
Slide 37: 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 38: 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 39: 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 40: 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 41: 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 42: 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 43: 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 44: 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 45: 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 46: Financial Data by Reporting Segment
Financial Data by Reporting Segment
Slide 47: 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 48: 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 49: 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 50: Zayo Lit Services Segment Financial Data
Zayo Lit Services 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 51: Zayo Lit Services Segment Revenue Stratification & Operational Data
millions Revenue Stratification Net New Sales (Bookings) thousands MRR and MAR Zayo Lit Services 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 Capital and U
Slide 52: Zayo Lit Services 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 Lit Services Segment C
Slide 53: 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 54: Segment Financial Data Rollup
Segment Financial Data Rollup Segment Data Rollup
Slide 55: Segment Financial Data
Segment Financial Data Segment Data
Slide 56: Historical Financial Data & Reconciliations
Historical Financial Data & Reconciliations
Slide 57: Consolidated Historical Financial Data
Consolidated Historical Financial Data Consolidated Financial Data
Slide 58: Consolidated Historical Reconciliations
Consolidated Historical Reconciliations Consolidated Financial Data
Slide 59: 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 60: Reconciliation: 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 61: AFFO & Net AFFO Reconciliation
AFFO & Net AFFO Reconciliation AFFO & Net AFFO Reconciliation
Slide 62: Pro-forma Growth Reconciliation (FY 2014 Q1)
Pro-forma Growth Reconciliation (Supporting FY 2014 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 63: 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 64: 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 65: 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