Zayo Group Holdings Inc

Zayo — Q2 2015 Earnings Presentation

65 slides from Zayo's earnings presentation, Feb 11, 2015

  1. Slide 1: Fiscal Year 2015 Q2 Supplemental Earnings Information

    Zayo Group Holdings, Inc. Fiscal Year 2015 Q2 Supplemental Earnings Information 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

    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

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

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

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

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

  9. Slide 9: Financial Highlights

    Financial Highlights 9| FY2015 Q2 Supplemental Earnings Information zayo

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

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

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

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

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

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

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

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

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

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

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

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

  22. Slide 22: Inorganic Activity

    Inorganic Activity 22| FY2015 Q2 Supplemental Earnings Information zayo

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

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

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

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

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

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

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

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

  31. Slide 31: Operational Data

    Operational Data 34| FY2015 Q2 Supplemental Earnings Information zayo

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

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

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

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

  36. Slide 36: Revenue Under Contract

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

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

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

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

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

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

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

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

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

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

  46. Slide 46: Financial Data by Reporting Segment

    Financial Data by Reporting Segment

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

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

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

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

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

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

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

  54. Slide 54: Segment Financial Data Rollup

    Segment Financial Data Rollup Segment Data Rollup

  55. Slide 55: Segment Financial Data

    Segment Financial Data Segment Data

  56. Slide 56: Historical Financial Data & Reconciliations

    Historical Financial Data & Reconciliations

  57. Slide 57: Consolidated Historical Financial Data

    Consolidated Historical Financial Data Consolidated Financial Data

  58. Slide 58: Consolidated Historical Reconciliations

    Consolidated Historical Reconciliations Consolidated Financial Data

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

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

  61. Slide 61: AFFO & Net AFFO Reconciliation

    AFFO & Net AFFO Reconciliation AFFO & Net AFFO Reconciliation

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

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

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

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

Zayo Group Holdings — Q2 2015 Earnings Presentation on 6ix