Zayo Group Holdings Inc

Zayo — Q1 2015 Earnings Presentation

68 slides from Zayo's earnings presentation, Nov 7, 2014

  1. 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

  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,” “

  3. 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

  4. 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

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

  14. 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

  15. 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,

  16. 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)

  17. 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

  18. 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

  19. 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

  20. 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

  21. 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

  22. 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

  23. 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

  24. Slide 24: Stratification of Net New Sales (Bookings)

    Stratification of Net New Sales (Bookings) Net New Sales (Bookings) Stratification

  25. Slide 25: Stratification of Speculative Projects

    Stratification of Speculative Projects Speculative Capital Expenditure Commitments

  26. 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

  27. 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 =

  28. 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

  29. 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

  30. 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

  31. 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

  32. 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

  33. Slide 33: Revenue Under Contract

    Revenue Under Contract Revenue Under Contract Revenue Under Contract millions Average Remaining Contract Term Months

  34. 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

  35. 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

  36. Slide 36: Customer Concentration

    Customer Concentration Customer Concentration % of MRR Customer #1 Customer #2 Customer #3 Top 20 Top 10 Top 5

  37. Slide 37: Customer Metrics

    Customer Metrics Customer Metrics Number of Customers Customers MRR and MAR (MRR and MAR)/Customer thousands

  38. 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

  39. 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

  40. 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

  41. Slide 41: Fiber to the Tower

    Fiber to the Tower 41 | Proprietary and Confidential zayoO

  42. 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

  43. 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

  44. Slide 44: Financial Data by Reporting Segment

    Financial Data by Reporting Segment

  45. 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

  46. 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 % =

  47. 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

  48. 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,

  49. 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 % =

  50. 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

  51. 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

  52. Slide 52: Segment Financial Data Rollup

    Segment Financial Data Rollup Segment Data Rollup

  53. 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

  54. Slide 54: Invested Capital Ratio by Reporting Segment

    Invested Capital Ratio by Reporting Segment Invested Capital

  55. Slide 55: Historical Financial Data & Reconciliations

    Historical Financial Data & Reconciliations

  56. Slide 56: Consolidated Historical Financial Data

    Consolidated Historical Financial Data Consolidated Financial Data

  57. Slide 57: Consolidated Historical Reconciliations

    Consolidated Historical Reconciliations Consolidated Financial Data

  58. 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

  59. 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)

  60. 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

  61. 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

  62. 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

  63. 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

  64. Slide 64: Price Per Unit Trends

    Price Per Unit Trends 64| Proprietary and Confidential zayoO

  65. Slide 65: Pricing Trends – Waves

    Pricing Trends – Waves thousands MRR MRR thousands thousands MRR MRR thousands thousands MRR MRR thousands

  66. 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

  67. 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

  68. Slide 68: Pricing Trends – DS1 and DS3

    Pricing Trends – DS1 and DS3 thousands MRR MRR thousands thousands MRR MRR thousands

Zayo Group Holdings — Q1 2015 Earnings Presentation on 6ix