Zayo Group Holdings Inc

Zayo — Q2 FY2012 Earnings Presentation

50 slides from Zayo's earnings presentation, Feb 14, 2012

  1. Slide 1: Fiscal Year 2Q 2012 Supplemental Earnings Information

    Privileged and Confidential 1 Fiscal Year 2Q 2012 Supplemental Earnings Information

  2. Slide 2: Forward-Looking Statements

    Forward-Looking Statements 2 FY 2Q 2012 Supplemental Earnings Information 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,"

  3. Slide 3: 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 earnings before interest, taxes, depreciation and amortization ("EBITDA") and Adjusted EBITDA. EBITDA and Adjusted EBITDA a

  4. Slide 4: Presentation of Certain Consolidated Pro-forma Financial Data

    Presentation of Certain Consolidated Pro-forma Financial Data 4 FY 2Q 2012 Supplemental Earnings Information Acquisitions have been, and are expected to continue to be, a component of the Company's strategy. In this Supplemental Earnings Information under "Consolidated Pro-forma Financial Data," the

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

  6. Slide 6: 360networks Acquisition

    360networks Acquisition 6 FY 2Q 2012 Supplemental Earnings Information 360networks Statistics On December 1, 2011, Zayo completed the acquisition of 360networks Holdings (USA) Inc. ("360networks") for a purchase price of $345.0 million. The net cash consideration paid was $318.0 million after adjust

  7. Slide 7: MarquisNet Acquisition

    MarquisNet Acquisition 7 FY 2Q 2012 Supplemental Earnings Information MarquisNet Statistics On December 31, 2011, the Company acquired substantially all of the net assets of MarquisNet in an asset purchase agreement for approximately $15.9 million, subject to post-closing adjustments. The acquisitio

  8. Slide 8: Consolidated Financial Data

    Consolidated Financial Data 8 FY 2Q 2012 Supplemental Earnings Information Financial Data 1 The three months ended December 31, 2010 amounts include the operating results of the October 1, 2011 AFS acquisition. Adjusting for the effect of the transaction as if it had occurred on April 1, 2010, the a

  9. Slide 9: Consolidated Invested Capital Ratio

    Consolidated Invested Capital Ratio 9 FY 2Q 2012 Supplemental Earnings Information Invested Capital

  10. Slide 10: Segment Financial Data

    Segment Financial Data 10 FY 2Q 2012 Supplemental Earnings Information Segment Data

  11. Slide 11: Invested Capital Ratio by Business Unit

    Invested Capital Ratio by Business Unit 11 FY 2Q 2012 Supplemental Earnings Information Invested Capital

  12. Slide 12: Stratification of Revenue

    Stratification of Revenue 12 (CHART) (CHART) (CHART) millions millions millions millions FY 2Q 2012 Supplemental Earnings Information MRR and MAR on the Last Day of the Quarter 1 (CHART) MRR on the last day of the quarter MAR of the last day of the quarter millions Revenue Stratification (CHART) 1 O

  13. Slide 13: Stratification of Adjusted EBITDA

    (CHART) Stratification of Adjusted EBITDA 13 millions FY 2Q 2012 Supplemental Earnings Information millions Adjusted EBITDA Associated with Other Revenue Stratification of Adjusted EBITDA Adjusted EBITDA Stratification Adjusted EBITDA associated with Credits and Adjustments Adjusted EBITDA associate

  14. Slide 14: Gross New Sales (Bookings)

    (CHART) (CHART) (CHART) Gross New Sales (Bookings) 14 FY 2Q 2012 Supplemental Earnings Information Gross New Sales (Bookings) Gross New Sales (Bookings) Estimated Gross Profit and Gross Profit Percentage on Gross New Sales (Bookings) Estimated Capital Expenditures associated with Gross New Sales (Bo

  15. Slide 15: Gross New Sales (Bookings) - IRU, Installation and Other

    (CHART) Gross New Sales (Bookings) IRU, Installation and Other 15 FY 2Q 2012 Supplemental Earnings Information Gross New Sales (Bookings) - IRU, Installation and Other Gross New Sales (Bookings) - IRU, Installation and Other Estimated Gross Profit and Gross Profit Percentage on Gross New Sales (Book

  16. Slide 16: Stratification of Gross New Sales (Bookings)

    Stratification of Gross New Sales (Bookings) 16 FY 2Q 2012 Supplemental Earnings Information Gross New Sales (Bookings) Stratification 1 For the quarter ended September 30, 2011, network capacity estimated capital expenditures include 165 Halsey power upgrades and 60 Hudson generator upgrade 2 Specu

  17. Slide 17: Stratification of Speculative Projects

    Stratification of Speculative Projects FY 2Q 2012 Supplemental Earnings Information 17 Speculative Capital Expenditure Commitments 1 The estimated Infrastructure Capital and Success Based Capital for Government Stimulus in the quarter ended December 31, 2010 relate to a network build for a healthcar

  18. Slide 18: Quota Bearing Headcount (QBHC)

    Quota Bearing Headcount (QBHC) FY 2Q 2012 Supplemental Earnings Information 18 Quota Bearing Headcount (CHART) (CHART) Quota Bearing Headcount Monthly Average Gross New Sales (Bookings) per QBHC thousands Headcount Gross New Sales (Bookings) MRR and MAR

  19. Slide 19: Installation and Churn Processed

    (CHART) Installation and Churn Processed 19 FY 2Q 2012 Supplemental Earnings Information Installation and Churn Processed (CHART) (CHART) (CHART) Gross Installations Churn Processed Net Installations Gross Profit from Net Installations thousands thousands thousands thousands MRR and MAR MRR and MAR

  20. Slide 20: Breakdown of Installations and Churn Processed

    Breakdown of Installations and Churn Processed Installation and Churn Processed 20 FY 2Q 2012 Supplemental Earnings Information Gross Installations thousands Churn Processed thousands MRR and MAR MRR and MAR (CHART) Churn = (CHART)

  21. Slide 21: Price Changes and Renewals

    (CHART) Price Changes and Renewals (CHART) (CHART) Price Increases Net Contract Value Associated with Price Changes and Renewals Price Decreases thousands millions thousands MRR Contract Value MRR (CHART) Price Changes Net of Price Increases and Price Decreases thousands MRR 21 FY 2Q 2012 Supplement

  22. Slide 22: Upgrades

    Upgrades Upgrades (CHART) (CHART) (CHART) (CHART) Gross Installations Associated with Upgrades Average % Increase in Monthly Recurring Revenue Associated with Upgrades thousands thousands thousands Churn Processed Associated with Upgrades Net Installations Associated with Upgrades 22 FY 2Q 2012 Supp

  23. Slide 23: Service Activation and Churn Pipeline

    (CHART) Service Activation and Churn Pipeline 23 FY 2Q 2012 Supplemental Earnings Information Service Activation and Churn Pipeline (CHART) (CHART) Service Activation Pipeline Estimated Timing of Service Activation Pipeline Churn Pipeline Net Installation Pipeline millions millions millions MRR and

  24. Slide 24: Revenue Under Contract

    Revenue Under Contract 24 FY 2Q 2012 Supplemental Earnings Information Revenue Under Contract Revenue Under Contract millions (CHART) Average Remaining Contract Term (CHART) Months

  25. Slide 25: Employee Data

    Employee Data FY 2Q 2012 Supplemental Earnings Information 25 Employee Data (CHART) (CHART) (CHART) (CHART) Number of Employees Employee Related SG&A thousands millions thousands Headcount Financial Statement Revenue SG&A SG&A % of Revenue = Annualized Revenue per Employee Annualized Employee Relate

  26. Slide 26: Customer Verticals and Product Mix

    Customer Verticals and Product Mix 26 FY 2Q 2012 Supplemental Earnings Information Customer Verticals and Product Mix

  27. Slide 27: Customer Concentration

    (CHART) (CHART) (CHART) (CHART) Customer Concentration 27 FY 2Q 2012 Supplemental Earnings Information Customer Concentration % of MRR Customer #2 Customer #3 Top 20 Top 10 Top 5

  28. Slide 28: Customer and Unit Metrics

    Customer and Unit Metrics Customer and Unit1 Metrics (CHART) (CHART) (CHART) Number of Customers Number of Units (MRR and MAR)/Unit 28 FY 2Q 2012 Supplemental Earnings Information Customers MRR and MAR MRR and MAR Units (CHART) (MRR and MAR)/Customer thousands thousands thousands 1 Units and (MRR an

  29. Slide 29: Pricing Trends - Waves

    Pricing Trends1 - Waves FY 2Q 2012 Supplemental Earnings Information 29 (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) thousands MRR MRR thousands (CHART) 1 Pricing trends based on ZB only

  30. Slide 30: Pricing Trends - Ethernet

    Pricing Trends1 - Ethernet FY 2Q 2012 Supplemental Earnings Information 30 (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) (CHART) thousands MRR MRR thousands GigE Full Rate (>1000Mb) - MRR/Unit Fractional GigE (101-1000Mb) - MR

  31. Slide 31: Pricing Trends - OC3, OC12, and OC48

    Pricing Trends1 - OC3, OC12, and OC48 FY 2Q 2012 Supplemental Earnings Information 31 (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) thousands MRR MRR thousands 1 Pricing trends based on ZB only 2 As part of organizational chan

  32. Slide 32: Pricing Trends - DS1 and DS3

    Pricing Trends1 - DS1 and DS3 FY 2Q 2012 Supplemental Earnings Information 32 (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) (CHART) thousands MRR MRR thousands 1 Pricing trends based on ZB only

  33. Slide 33: Purchases of Property and Equipment

    millions Purchases of Property and Equipment Purchases of Property and Equipment by Driver 1 (CHART) 33 FY 2Q 2012 Supplemental Earnings Information Capital Expenditures Purchases of Property and Equipment (CHART) Maintenance, Integration and Other (CHART) Growth Capital Expenditures Capital Expendi

  34. Slide 34: Network Metrics

    Network Metrics 34 FY 2Q 2012 Supplemental Earnings Information Network Metrics (CHART) (CHART) Fiber Network - Route Miles Fiber Network - Fiber Miles Number of On-net Buildings Number of Markets Route Miles Fiber Miles On-Net Buildings # of Markets (CHART) (CHART) States = 27 + DC States = 31 + DC

  35. Slide 35: Network Metrics - On-Net Buildings

    Network Metrics 35 FY 2Q 2012 Supplemental Earnings Information On-Net Buildings 1 In the three months ended June 30, 2011, decreases in building counts by category are due to reclassification of building types, not a result of buildings being physically removed from the Zayo network

  36. Slide 36: Network Metrics - Colocation Cabinet Utilization

    (CHART) (CHART) Network Metrics 36 FY 2Q 2012 Supplemental Earnings Information Colocation Cabinet Utilization Billable Colocation Square Feet Colocation Cabinet Equivalents Utilized Colocation Cabinet Equivalents Square Feet Colocation Cabinet Equivalents Colocation Cabinet Equivalents Utilization

  37. Slide 37: Fiber to the Tower

    FY 2Q 2012 Supplemental Earnings Information 37 Fiber to the Tower

  38. Slide 38: Fiber to the Tower (FTT)

    (CHART) (CHART) Fiber to the Tower (FTT) Fiber to the Tower (CHART) (CHART) Total FTT Towers Bandwidth/Tenant (Mbs)1 Revenue/Tower & Revenue/Tenant thousands (CHART) 38 FY 2Q 2012 Supplemental Earnings Information Towers Tenants MRR and MAR Mbs Revenue/Tower Revenue/Tenant Total FTT Tenants Tenants/

  39. Slide 39: Fiber to the Tower (FTT) MRR and Capital Expenditures

    (CHART) (CHART) % of MRR and MAR % of Zayo Group's Wireless Carrier MRR and MAR Fiber to the Tower (FTT) Fiber to the Tower (CHART) (CHART) FTT MRR and MAR FTT Cumulative Capital Expenditures FTT Product Mix millions millions 39 FY 2Q 2012 Supplemental Earnings Information % of MRR and MAR MRR and M

  40. Slide 40: FTT Markets

    FTT Markets FTT Markets Mid-Atlantic includes Washington D.C., Maryland, New Jersey, Virginia, West Virginia, and Pennsylvania North Central includes Indiana, Minnesota, Kentucky, and Ohio Pacific Northwest includes Idaho and Washington Southeast includes Tennessee and Georgia Southwest includes Ari

  41. Slide 41: Financial Data by Business Unit

    FY 2Q 2012 Supplemental Earnings Information 41 Financial Data by Business Unit

  42. Slide 42: Zayo Bandwidth Financial Data

    Zayo Bandwidth Financial Data 42 Financial Data FY 2Q 2012 Supplemental Earnings Information 1 The financial data for the three months ended December 31, 2011 includes one month of operating results of the acquired 360networks business

  43. Slide 43: Zayo Fiber Solutions Financial Data

    Zayo Fiber Solutions Financial Data FY 2Q 2012 Supplemental Earnings Information 43 Financial Data 1 The financial data for the three months ended December 31, 2011 includes one month of operating results of the acquired 360networks business

  44. Slide 44: zColo Financial Data

    zColo Financial Data FY 2Q 2012 Supplemental Earnings Information 44 Financial Data 1 Total Invested Capital as of December 31, 2011 includes $15.5 million of additional capital invested in zColo in conjunction with the MarquisNet acquisition. As the acquisition occurred on December 31, 2011, the An

  45. Slide 45: Historical Financial Data & Reconciliations

    FY 2Q 2012 Supplemental Earnings Information 45 Historical Financial Data & Reconciliations

  46. Slide 46: Consolidated Historical Financial Data

    Consolidated Historical Financial Data 46 FY 2Q 2012 Supplemental Earnings Information Consolidated Financial Data

  47. Slide 47: Consolidated Historical Reconciliations

    Consolidated Historical Reconciliations 47 FY 2Q 2012 Supplemental Earnings Information Consolidated Financial Data

  48. Slide 48: Segment Data Reconciliation

    48 FY 2Q 2012 Supplemental Earnings Information Segment Data Reconciliation Segment Data Reconciliation Note: A reconciliation of previous quarters segment information can be found on our historical earnings supplements found on our website at http://www.zayo.com/financial-earnings-release

  49. Slide 49: Pro-forma Growth Reconciliation (AFS)

    49 FY 2Q 2012 Supplemental Earnings Information Pro-forma Growth Reconciliation (AFS) Pro-forma Growth Reconciliation 1 Revenue and depreciation expense have been adjusted from historical actual results to reflect the pro-forma impact of purchase price adjustments to the acquired deferred revenue, f

  50. Slide 50: Pro-forma Growth Reconciliation (360networks)

    50 FY 2Q 2012 Supplemental Earnings Information Pro-forma Growth Reconciliation (360networks) Pro-forma Growth Reconciliation 1 The 360networks Corporation historical results include the operating results of VoIP 360 Inc., and other non-operating legal subsidiaries of 360networks Corporation which w

Zayo Group — Q2 FY2012 Earnings Presentation on 6ix