Zayo Group Holdings Inc

Zayo — Q3 FY2012 Earnings Presentation

54 slides from Zayo's earnings presentation, May 9, 2012

  1. Slide 1: Supplemental Earnings Information

    \ Supplemental Earnings Informatiot

  2. Slide 2: Forward-Looking Statements

    Forward-Looking Statements 2 FY 3Q 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 3Q 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: Recent 8-K Filings

    Recent 8-K Filings Change in the Company’s Independent Registered Public Accounting Firm On May 3rd, 2012, the Company made a filing on Form 8-K with the Securities and Exchange Commission (“SEC”) which announced that the Company has dismissed Grant Thornton LLP as the Company’s independent register

  7. Slide 7: Restatement of Historical Financial Information

    Restatement of Historical Financial Information Impact of restatement on the fiscal 2010 Statement of Operations: FY 3Q 2012 Supplemental Earnings Information 7 Restatement Impact (in thousands) Year Ended June 30, 2010 Previously Correction Restated Reported Revenue $ 199,330 $—$ 199,330 Operating

  8. Slide 8: Restatement of Historical Financial Information

    Restatement of Historical Financial Information The misstatement discussed on the previous slide will have the following impact on the fiscal 2010 Balance Sheet: FY 3Q 2012 Supplemental Earnings Information 8 1 The adjustments to the balance sheet in fiscal 2010 will flow through each of the quarter

  9. Slide 9: Arialink Acquisition

    Arialink Acquisition 9 FY 3Q 2012 Supplemental Earnings Information Arialink Statistics On May 1, 2012, the Company acquired substantially all of the net assets of Arialink for approximately $18.0 million, subject to post-closing adjustments. The acquisition was funded with cash on hand. The acquire

  10. Slide 10: AboveNet Acquisition

    AboveNet Acquisition 10 FY 3Q 2012 Supplemental Earnings Information AboveNet Statistics On March 18, 2012, the Company entered into an Agreement and Plan of Merger with AboveNet Inc. (“AboveNet”), a provider of high-bandwidth connectivity solutions Upon the close of the transaction contemplated by

  11. Slide 11: Consolidated Financial Data

    Consolidated Financial Data 11 FY 3Q 2012 Supplemental Earnings Information Financial Data 1 The three months ended December 31, 2011 include one month of operating results of the December 1, 2011 360networks acquisition and the three months ended March 31, 2012 include three months of operating res

  12. Slide 12: Consolidated Invested Capital Ratio

    Consolidated Invested Capital Ratio 12 FY 3Q 2012 Supplemental Earnings Information Invested Capital

  13. Slide 13: Segment Financial Data

    Segment Financial Data 13 FY 3Q 2012 Supplemental Earnings Information Segment Data

  14. Slide 14: Invested Capital Ratio by Business Unit

    Invested Capital Ratio by Business Unit 14 FY 3Q 2012 Supplemental Earnings Information Invested Capital

  15. Slide 15: Stratification of Revenue

    Stratification of Revenue 15 millions millions millions millions MRR and MAR on the Last Day of the Quarter MRR on the last day of the quarter MAR of the last day of the quarter millions Revenue Stratification FY 3Q 2012 Supplemental Earnings Information

  16. Slide 16: Stratification of Adjusted EBITDA

    Stratification of Adjusted EBITDA 16 millions FY 3Q 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 associated with T

  17. Slide 17: Gross New Sales (Bookings)

    Gross New Sales (Bookings) 17 FY 3Q 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 and Upfront Expenditures associated with Gross New Sales (Bookings) less

  18. Slide 18: Estimated Capital and Upfront Expenditures and Gross New Sales

    18 FY 3Q 2012 Supplemental Earnings Information Estimated Capital and Upfront Expenditures and Gross New Sales (Bookings) IRU and Upfront Charges Contract Value = Gross New Sales (Bookings) – IRU and Upfront Charges Gross New Sales (Bookings) from IRUs Gross New Sales Upfront Charges Gross New Sales

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

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

  20. Slide 20: Stratification of Speculative Projects

    Stratification of Speculative Projects FY 3Q 2012 Supplemental Earnings Information 20 Speculative Capital Expenditure Commitments 1 Speculative capital for the three months ended June 30, 2011 includes $2.9 million success based capital for fiber associated with the GigE PAC government stimulus awa

  21. Slide 21: Quota Bearing Headcount (QBHC)

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

  22. Slide 22: Installation and Churn Processed

    Installation and Churn Processed 22 FY 3Q 2012 Supplemental Earnings Information Installation and Churn Processed Gross Installations Churn Processed Net Installations Gross Profit from Net Installations thousands thousands thousands thousands MRR and MAR MRR and MAR MRR and MAR Monthly Gross Profit

  23. Slide 23: Breakdown of Installations and Churn

    Breakdown of Installations and Churn Processed Installation and Churn Processed 23 FY 3Q 2012 Supplemental Earnings Information Gross Installations thousands Churn Processed thousands MRR and MAR MRR and MAR Churn =

  24. Slide 24: Price Changes and Renewals

    Price Changes and Renewals Price Increases Net Contract Value Associated with Price Changes and Renewals Price Decreases thousands millions thousands MRR Contract Value MRR Price Changes Net of Price Increases and Price Decreases thousands MRR 24 FY 3Q 2012 Supplemental Earnings Information Price in

  25. Slide 25: Upgrades

    Upgrades Upgrades 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 25 FY 3Q 2012 Supplemental Earnings Information MR

  26. Slide 26: Service Activation and Churn Pipeline

    Service Activation and Churn Pipeline 26 FY 3Q 2012 Supplemental Earnings Information 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 mill

  27. Slide 27: Revenue Under Contract

    Revenue Under Contract 27 FY 3Q 2012 Supplemental Earnings Information Revenue Under Contract Revenue Under Contract millions Average Remaining Contract Term Months

  28. Slide 28: Employee Data

    Employee Data FY 3Q 2012 Supplemental Earnings Information 28 Employee Data 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 Related SG&A per Employee

  29. Slide 29: Customer Verticals and Product Mix

    Customer Verticals and Product Mix 29 FY 3Q 2012 Supplemental Earnings Information Customer Verticals and Product Mix

  30. Slide 30: Customer Concentration

    Customer Concentration 30 FY 3Q 2012 Supplemental Earnings Information Customer Concentration % of MRR Customer #1 Customer #2 Customer #3 Top 20 Top 10 Top 5

  31. Slide 31: Customer and Unit Metrics

    Customer and Unit Metrics Customer and Unit1 Metrics Number of Customers Number of Units (MRR and MAR)/Unit 31 FY 3Q 2012 Supplemental Earnings Information Customers MRR and MAR MRR and MAR Units (MRR and MAR)/Customer thousands thousands thousands 1 Units and (MRR and MAR)/Unit exclude Fiber Miles

  32. Slide 32: Pricing Trends – Waves

    Pricing Trends1 – Waves FY 3Q 2012 Supplemental Earnings Information 32 thousands MRR MRR thousands thousands MRR MRR thousands 1 Pricing trends based on ZB only

  33. Slide 33: Pricing Trends – Ethernet

    Pricing Trends1 – Ethernet FY 3Q 2012 Supplemental Earnings Information 33 thousands MRR MRR thousands thousands MRR MRR thousands thousands MRR MRR thousands GigE Full Rate (>1000Mb) – MRR/Unit Fractional GigE (101-1000Mb) – MRR/Unit 1 Pricing trends based on ZB only

  34. Slide 34: Pricing Trends – OC3, OC12, and OC48

    Pricing Trends1 – OC3, OC12, and OC48 FY 3Q 2012 Supplemental Earnings Information 34 thousands MRR MRR thousands thousands MRR MRR thousands thousands MRR MRR thousands 1 Pricing trends based on ZB only

  35. Slide 35: Pricing Trends – DS1 and DS3

    Pricing Trends1 – DS1 and DS3 FY 3Q 2012 Supplemental Earnings Information 35 thousands MRR MRR thousands thousands MRR MRR thousands 1 Pricing trends based on ZB only

  36. Slide 36: Purchases of Property and Equipment

    millions Purchases of Property and Equipment Purchases of Property and Equipment by Driver 1 36 FY 3Q 2012 Supplemental Earnings Information Capital Expenditures Purchases of Property and Equipment Maintenance, Integration and Other Growth Capital Expenditures Capital Expenditures Capital Expenditur

  37. Slide 37: Network Metrics

    Network Metrics 37 FY 3Q 2012 Supplemental Earnings Information Network Metrics 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 States = 31 + DC States = 31 + DC States = 31 + DC States = 42 + DC S

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

    Network Metrics 38 FY 3Q 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

  39. Slide 39: Network Metrics: Colocation Cabinet Utilization

    Network Metrics 39 FY 3Q 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 =

  40. Slide 40: Fiber to the Tower

    FY 3Q 2012 Supplemental Earnings Information 40 Fiber to the Tower

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

    Fiber to the Tower (FTT) Fiber to the Tower Total FTT Towers Bandwidth/Tenant (Mbs)1 Revenue/Tower & Revenue/Tenant thousands 41 FY 3Q 2012 Supplemental Earnings Information Towers Tenants MRR and MAR Mbs Revenue/Tower Revenue/Tenant Total FTT Tenants Tenants/Tower = 1 Bandwidth/Tenant excludes Dark

  42. Slide 42: Fiber to the Tower: MRR and MAR, Capex, Product Mix

    % of MRR and MAR % of MRR and MAR % of Zayo Group’s Wireless Carrier MRR and MAR Fiber to the Tower (FTT) Fiber to the Tower FTT MRR and MAR FTT Cumulative Capital Expenditures FTT Product Mix millions millions 42 FY 3Q 2012 Supplemental Earnings Information MRR and MAR % of FTT MRR and MAR Capital

  43. Slide 43: 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, Montana, and Washington Southeast includes Tennessee and Georgia Southwest in

  44. Slide 44: Financial Data by Business Unit

    FY 3Q 2012 Supplemental Earnings Information 44 Financial Data by Business Unit

  45. Slide 45: Zayo Bandwidth Financial Data

    Zayo Bandwidth Financial Data 45 Financial Data FY 3Q 2012 Supplemental Earnings Information 1 The three months ended December 31, 2011 include one month of operating results of the December 1, 2011 360networks acquisition. The Pro-forma annualized revenue growth and pro-forma annualized Adjusted EB

  46. Slide 46: Zayo Fiber Solutions Financial Data

    Zayo Fiber Solutions Financial Data FY 3Q 2012 Supplemental Earnings Information 46 Financial Data 1 1 1 The three months ended December 31, 2011 include one month of operating results of the December 1, 2011 360networks acquisition. The Pro-forma annualized revenue growth and pro-forma annualized A

  47. Slide 47: zColo Financial Data

    zColo Financial Data FY 3Q 2012 Supplemental Earnings Information 47 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

  48. Slide 48: Historical Financial Data & Reconciliations

    FY 3Q 2012 Supplemental Earnings Information 48 Historical Financial Data & Reconciliations

  49. Slide 49: Consolidated Historical Financial Data

    Consolidated Historical Financial Data 49 FY 3Q 2012 Supplemental Earnings Information Consolidated Financial Data

  50. Slide 50: Consolidated Historical Reconciliations

    Consolidated Historical Reconciliations 50 FY 3Q 2012 Supplemental Earnings Information Consolidated Financial Data

  51. Slide 51: Segment Data Reconciliation: Net Earnings/(loss) to Adjusted EBITDA

    51 FY 3Q 2012 Supplemental Earnings Information Segment Data Reconciliation: Net Earnings/(loss) to Adjusted EBITDA 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

  52. Slide 52: Segment Data Reconciliation: Cash flows from operating activities to Adjusted EBITDA

    Segment Data Reconciliation: Cash flows from operating activities to Adjusted EBITDA FY 2Q 2011 Supplemental Earnings Information 52 Segment Data Reconciliation

  53. Slide 53: Pro-forma Growth Reconciliation (FY 2012 Q3)

    53 FY 3Q 2012 Supplemental Earnings Information Pro-forma Growth Reconciliation (Supporting FY 2012 Q3 Pro-forma Growth) 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 360n

  54. Slide 54: Pro-forma Growth Reconciliation (FY 2012 Q2)

    54 FY 3Q 2012 Supplemental Earnings Information Pro-forma Growth Reconciliation (Supporting FY 2012 Q2 Pro-forma Growth) 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 360n

Zayo Group — Q3 FY2012 Earnings Presentation on 6ix