Zayo — Q1 2015 Earnings Presentation
68 slides from Zayo's earnings presentation, Nov 7, 2014
Slide 1: Fiscal Year 2015 Q1 Supplemental Earnings Information
Zayo Group Holdings, Inc. Fiscal Year 2015 Q1 Supplemental Earnings Information Proprietary and Confidential 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
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, and levered free cash flow. Adjusted EBITDA is defined as earnings/(loss) from conti
Slide 5: Limitations of free cash flow measures
Unlevered free cash flow has limitations as an analytical tool and should not be considered in isolation from, or as a substitute for, analysis of our results as reported under GAAP. For example, levered free cash flow: does not reflect changes in, or cash requirements for, our working capital needs
Slide 6: 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 7: ZGH Acquisition History
Weighted Average Multiple = 9.6x Pre-Synergy and 6.9x Post Synergy ZGH Acquisition History1 1 Companies denoted by * indicate Purchase Price was adjusted for value attributed to Onvoy Voice Services / Zayo Enterprise Networks /spin-offs 2Estimated Revenue LQA and Adjusted EBITDA LQA represents the R
Slide 8: ZGH Acquired and Organic Revenue Growth
ZGH Acquired and Organic Revenue Growth Cumulative Acquired Revenue Annualized Organic Revenue Incremental Acquired Revenue 3 4 5 6 7 8 2 Organic vs. Inorganic Revenue Growth 10 11 Organic growth is a derived figure calculated as the difference between reported Revenue (annualized) and cumulative ac
Slide 9: ZGH Adjusted EBITDA Growth
8First Telecommunications (2.5 mos), Litecast (3 mos) 9Core NAP (1 mo) 10 Adjustment to normalize for one-time $10.2M lease termination cost 11 Core NAP (2 mos), CoreLink (2 mos) 12 Corelink (1 mo), Access Communications, Fiberlink 13 CoreXchange (1 mo) 14 CoreXchange (2 mos), Geo (1.5 mos, based on
Slide 10: Planned Synergies Summary
Planned Synergies Summary Planned Synergies ($M) 1Estimate of realized synergies to date is calculated 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
Slide 11: AtlantaNAP Acquisition
On July 1, 2014, the Company acquired 100% of the equity of Colo Facilities Atlanta, LLC (“AtlantaNAP”), a Georgia limited liability company, for a total consideration of $52.5 million. AtlantaNAP is a provider of colocation services through the operation of a single datacenter facility in the Atlan
Slide 12: Neo Acquisition
Neo Acquisition Neo Statistics On July 1, 2014, the Company acquired 96% of the equity interest (plus a contractual mechanism to acquire the remaining interest at a later date) in Neo Telecoms Group (“Neo”) for a purchase price of 54.1M € net of cash acquired ($73.9M USD based on the exchange rate o
Slide 13: 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 2 During the three months ended June 30, 2013, the Company recorde
Slide 14: 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 2 In the three months ended June 30, 2013
Slide 15: 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 2 In the three months ended June 30,
Slide 16: Invested Capital
Invested Capital Invested Capital 1 1 September 30, 2014 market capitalization based on 223 million pre-primary shares at $22 per share closing price on October 17, 2014 (first day of trading)
Slide 17: Financial Data Stratification
Financial Data 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 Cas
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: 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 20: 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 21: Net New Sales (Bookings) and Estimated Payback
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 22: Estimated Capital and Upfront Expenditures and Net New Sales
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 23: Discussion of Unique Sep-14 Projects
Discussion of Unique Sep-14 Projects 42% of the $227M (or $96M) of Estimated Capital and Upfront Expenditures associated to Sep-14 Net Bookings driven by 2 large projects Payback period without these projects would be 17 months (versus reported 35 months) Provides for construction of ~1800 route net
Slide 24: Stratification of Net New Sales (Bookings)
Stratification of Net New Sales (Bookings) Net New Sales (Bookings) Stratification
Slide 25: Stratification of Speculative Projects
Stratification of Speculative Projects Speculative Capital Expenditure Commitments
Slide 26: Quota Bearing Headcount (QBHC)
Quota Bearing Headcount (QBHC) Quota Bearing Headcount Quota Bearing Headcount Monthly Average Net New Sales (Bookings) per QBHC thousands Headcount Net New Sales (Bookings) MRR and MAR
Slide 27: 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 28: 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 previo
Slide 29: 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 30: 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 31: 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 32: 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 33: Revenue Under Contract
Revenue Under Contract Revenue Under Contract Revenue Under Contract millions Average Remaining Contract Term Months
Slide 34: Employee Data
Employee Data Employee Data Number of Employees Employee Related Cost thousands millions thousands Headcount Financial Statement Revenue SG&A SG&A % of Revenue = Annualized Revenue per Employee Annualized Employee Related Cost per Employee
Slide 35: 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 36: Customer Concentration
Customer Concentration Customer Concentration % of MRR Customer #1 Customer #2 Customer #3 Top 20 Top 10 Top 5
Slide 37: Customer Metrics
Customer Metrics Customer Metrics Number of Customers Customers MRR and MAR (MRR and MAR)/Customer thousands
Slide 38: Network Metrics
Network Metrics Network Metrics1,2 Fiber Network - Route Miles Route Miles Fiber Miles On-Net Buildings Number of Markets thousands States = Pre-existing Network Metrics Fiber Network - Fiber Miles Number of On-net Buildings Number of Markets 1 Acquired additions to quarterly network metrics represe
Slide 39: 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 40: 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 41: Fiber to the Tower
Fiber to the Tower 41 | Proprietary and Confidential zayoO
Slide 42: Fiber to the Tower (FTT)
Total FTT Tenants 2,3 Revenue/Tower & Revenue/Tenant Revenue/Tower Revenue/Tenant Fiber to the Tower (FTT) Total FTT Towers 2,3 Bandwidth/Tenant (Mbs)1 thousands Towers Tenants MRR and MAR Mbs In Service Tenants/In Service Tower = 1Bandwidth/Tenant excludes Dark Fiber sites 2 In Service counts refle
Slide 43: Fiber to the Tower: 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 millions MRR and MAR % of FTT MRR and MAR % of Zayo Group’s MRR and MAR Contract Value = Fiber to the Tower FTT as % of MRR/MAR FTT Product Mix
Slide 44: Financial Data by Reporting Segment
Financial Data by Reporting Segment
Slide 45: 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 2 In the three months ended June 30, 2013
Slide 46: Physical Infrastructure Revenue Stratification & Operational Data
millions Revenue Stratification Net New Sales (Bookings) thousands MRR and MAR Zayo Physical Infrastructure Segment Revenue Stratification & Operational Data thousands Churn Processed Gross Installations MRR and MAR MRR and MAR thousands Net Installations thousands MRR and MAR Churn % =
Slide 47: Physical Infrastructure Segment Financial Data 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 % of Revenue millions Levered FCF4 $4.3 million lease termination cost adj
Slide 48: 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 2 In the three months ended June 30,
Slide 49: Lit Services 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 % =
Slide 50: Lit Services Segment Financial Data 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 % of Revenue millions Levered FCF4 $5.9 million lease termination cost adj
Slide 51: 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 2 The three months ended September 30, 2014 include three m
Slide 52: Segment Financial Data Rollup
Segment Financial Data Rollup Segment Data Rollup
Slide 53: Segment Financial Data
Segment Financial Data Segment Data1 1The Physical Infrastructure reporting segment is comprised of the following SPGs: Zayo Dark Fiber, Zayo Mobile Infrastructure, and Zayo Colocation. The Lit Services reporting segment is comprised of the following SPGs: Zayo Wavelength Services, Zayo SONET Servic
Slide 54: Invested Capital Ratio by Reporting Segment
Invested Capital Ratio by Reporting Segment Invested Capital
Slide 55: Historical Financial Data & Reconciliations
Historical Financial Data & Reconciliations
Slide 56: Consolidated Historical Financial Data
Consolidated Historical Financial Data Consolidated Financial Data
Slide 57: Consolidated Historical Reconciliations
Consolidated Historical Reconciliations Consolidated Financial Data
Slide 58: 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 59: 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 60: 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 61: 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 62: 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 63: 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 64: Price Per Unit Trends
Price Per Unit Trends 64| Proprietary and Confidential zayoO
Slide 65: Pricing Trends – Waves
Pricing Trends – Waves thousands MRR MRR thousands thousands MRR MRR thousands thousands MRR MRR thousands
Slide 66: Pricing Trends – Ethernet
Pricing Trends – Ethernet 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 67: Pricing Trends – OC3, OC12, and OC48
Pricing Trends – OC3, OC12, and OC48 thousands MRR MRR thousands thousands MRR MRR thousands thousands MRR MRR thousands
Slide 68: Pricing Trends – DS1 and DS3
Pricing Trends – DS1 and DS3 thousands MRR MRR thousands thousands MRR MRR thousands