Zayo Group Holdings Inc

Zayo — Q1 FY2012 Earnings Presentation

50 slides from Zayo's earnings presentation, Nov 10, 2011

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

    FY 2Q 2011 Supplemental Earnings Information 1 Fiscal Year 1Q 2012 Supplemental Earnings Information FY 1Q 2012 Supplemental Earnings Information

  2. Slide 2: Forward-Looking Statements

    Forward-Looking Statements 2 FY 1Q 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 1Q 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: Summary Structure Reporting Company Restructuring

    Summary Structure 6 FY 1Q 2012 Supplemental Earnings Information Reporting Company Restructuring The chart below depicts the Company's current organizational structure1 (effective as of April 1, 2011), and includes the following restructuring events: January 1, 2011 restructuring of the business uni

  7. Slide 7: Reporting Impacts of Restructuring

    Reporting Impacts of Restructuring The spin-off and associated restructuring of our operating segments (as more fully described in our Annual Report filed on Form 10-K with the SEC) impact the supplemental reporting and comparability of prior periods January 1, 2011 restructuring of the operating se

  8. Slide 8: Acquisition Statistics

    360 Acquisition 8 FY 1Q 2012 Supplemental Earnings Information 360 Statistics On October 7, Zayo announced an agreement to acquire 360networks Holdings (USA) Inc.; the transaction is expected to close in December 2011. Upon close, Zayo will spin-off 360networks' VOIP operations. As such, the revenue

  9. Slide 9: Consolidated Financial Data

    Consolidated Financial Data 9 FY 1Q 2012 Supplemental Earnings Information Financial Data 1 The three months ended September 30, 2010 amounts include the operating results of the July 1, 2010, AGL acquisition. The three months ended December 31, 2010 amounts include the operating results of both the

  10. Slide 10: Consolidated Invested Capital Ratio

    Consolidated Invested Capital Ratio 10 FY 1Q 2012 Supplemental Earnings Information Invested Capital 1 The increase in member's interest during the three months ended September 30, 2011 is a result of the Company's use of $0.7 million of Zayo Group Holdings deferred tax assets which was settled as a

  11. Slide 11: Segment Financial Data

    Segment Financial Data 11 FY 1Q 2012 Supplemental Earnings Information Segment Data

  12. Slide 12: Invested Capital Ratio by Business Unit

    Invested Capital Ratio by Business Unit 12 FY 1Q 2012 Supplemental Earnings Information Invested Capital

  13. Slide 13: Stratification of Revenue

    Stratification of Revenue 13 (CHART) (CHART) (CHART) (CHART) millions millions millions millions FY 1Q 2012 Supplemental Earnings Information MRR and MAR on the Last Day of the Quarter 1 (CHART) 1 Other revenue for the three months ended September 30, 2011 included $0.7 million of other revenue asso

  14. Slide 14: Stratification of Adjusted EBITDA

    (CHART) (CHART) Stratification of Adjusted EBITDA 14 millions FY 1Q 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 a

  15. Slide 15: Gross New Sales (Bookings)

    (CHART) (CHART) (CHART) Gross New Sales (Bookings) 15 FY 1Q 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

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

    (CHART) Gross New Sales (Bookings) IRU, Installation and Other 16 FY 1Q 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

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

    Stratification of Gross New Sales (Bookings) 17 FY 1Q 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

  18. Slide 18: Stratification of Speculative Projects

    Stratification of Speculative Projects FY 1Q 2012 Supplemental Earnings Information 18 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

  19. Slide 19: Quota Bearing Headcount (QBHC)

    Quota Bearing Headcount (QBHC) FY 1Q 2012 Supplemental Earnings Information 19 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

  20. Slide 20: Installation and Churn Processed

    (CHART) Installation and Churn Processed 20 FY 1Q 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

  21. Slide 21: Breakdown of Installations and Churn Processed

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

  22. Slide 22: 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 22 FY 1Q 2012 Supplement

  23. Slide 23: 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 23 FY 1Q 2012 Supp

  24. Slide 24: Service Activation and Churn Pipeline

    (CHART) Service Activation and Churn Pipeline 24 FY 1Q 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

  25. Slide 25: Revenue Under Contract

    Revenue Under Contract 25 FY 1Q 2012 Supplemental Earnings Information Revenue Under Contract Revenue Under Contract millions (CHART) Average Remaining Contract Term (CHART) n/a Months

  26. Slide 26: Employee Data

    Employee Data FY 1Q 2012 Supplemental Earnings Information 26 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

  27. Slide 27: Customer Verticals and Product Mix

    Customer Verticals and Product Mix 27 FY 1Q 2012 Supplemental Earnings Information Customer Verticals and Product Mix

  28. Slide 28: Customer Concentration

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

  29. Slide 29: 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 29 FY 1Q 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

  30. Slide 30: Pricing Trends - Waves

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

  31. Slide 31: Pricing Trends - Ethernet

    Pricing Trends1 - Ethernet FY 1Q 2012 Supplemental Earnings Information 31 (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

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

    Pricing Trends1 - OC3, OC12, and OC48 FY 1Q 2012 Supplemental Earnings Information 32 (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

  33. Slide 33: Pricing Trends - DS1 and DS3

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

  34. Slide 34: Purchases of Property and Equipment

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

  35. Slide 35: Network Metrics

    Network Metrics 35 FY 1Q 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 = 27 + DC

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

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

  37. Slide 37: Network Metrics: Colocation Cabinet Utilization

    Network Metrics 37 FY 1Q 2012 Supplemental Earnings Information Colocation Cabinet Utilization (CHART) (CHART) (CHART) Billable Colocation Square Feet Colocation Cabinet Equivalents Utilized Colocation Cabinet Equivalents Square Feet Colocation Cabinet Equivalents Colocation Cabinet Equivalents Util

  38. Slide 38: Fiber to the Tower

    FY 1Q 2012 Supplemental Earnings Information 38 Fiber to the Tower

  39. Slide 39: 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 thousands (CHART) 39 FY 1Q 2012 Supplemental Earnings Information Towers Tenants MRR and MAR Mbs Revenue/Tower Revenue/Tenant Total FTT Tenant

  40. Slide 40: 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 40 FY 1Q 2012 Supplemental Earnings Information % of MRR and MAR MRR and M

  41. Slide 41: 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 Las

  42. Slide 42: Financial Data by Business Unit

    FY 1Q 2012 Supplemental Earnings Information 42 Financial Data by Business Unit

  43. Slide 43: Zayo Bandwidth Financial Data

    Zayo Bandwidth Financial Data 43 Financial Data FY 1Q 2012 Supplemental Earnings Information 1 The financial data for the three months ended September 30, 2010 include the transfer of $1.4 million revenue and $1.1 million Adjusted EBITDA from ZB to ZFS in conjunction with the launch of ZFS on July 1

  44. Slide 44: Zayo Fiber Solutions Financial Data

    Zayo Fiber Solutions Financial Data FY 1Q 2012 Supplemental Earnings Information 44 Financial Data

  45. Slide 45: zColo Financial Data

    zColo Financial Data FY 1Q 2012 Supplemental Earnings Information 45 Financial Data 1 In connection with the restructuring of the Company's operating segments on January 1, 2011, ZB transferred 5 colocation sites to zColo. This transfer resulted in an increase of $1.1 million to zColo's revenue (net

  46. Slide 46: Historical Financial Data & Reconciliations

    FY 1Q 2012 Supplemental Earnings Information 46 Historical Financial Data & Reconciliations

  47. Slide 47: Consolidated Historical Financial Data

    Consolidated Historical Financial Data 47 FY 1Q 2012 Supplemental Earnings Information Consolidated Financial Data

  48. Slide 48: Consolidated Historical Reconciliations

    Consolidated Historical Reconciliations 48 FY 1Q 2012 Supplemental Earnings Information Consolidated Financial Data

  49. Slide 49: Segment Data Reconciliation

    49 FY 1Q 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

  50. Slide 50: Pro-forma Growth Reconciliation

    50 FY 1Q 2012 Supplemental Earnings Information Pro-forma Growth Reconciliation 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, fixed a

Zayo Group — Q1 FY2012 Earnings Presentation on 6ix