Zayo Group Holdings Inc

Zayo — Q2 FY2013 Earnings Presentation

57 slides from Zayo's earnings presentation, Feb 8, 2013

  1. Slide 1: FY 2Q 2013 Supplemental Earnings Information

    1 Fiscal Year 2Q 2013 Supplemental Earnings Information FY 2Q 2013 Supplemental Earnings Information

  2. Slide 2: Forward-Looking Statements

    Forward-Looking Statements 2 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 3 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 gr

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

  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: Other Notes: Reporting Segments

    Zayo Colocation Zayo Bandwidth Other Notes Reporting Segments The Company's segments (also referred to herein as business units) are aligned to our product offerings and currently consist of the following: Zayo Bandwidth ("ZB") offers lit Bandwidth Infrastructure services Zayo Colocation ("zColo") p

  7. Slide 7: USCarrier Acquisition

    USCarrier Acquisition 7 USCarrier Statistics In connection with the Company's acquisition of AFS on October 1, 2010, the Company acquired an ownership interest in USCarrier. USCarrier is a provider of transport services, such as Ethernet and Wavelengths, primarily to other telecommunications provide

  8. Slide 8: First Telecom Acquisition

    First Telecom Acquisition 8 First Telecom Services Statistics 1 Annualized revenue and Adjusted EBITDA are based on the operating results of First Telecom for the three months ended September 30, 2012. Financial results do not reflect any purchase accounting adjustments or reductions for intercompan

  9. Slide 9: Litecast Acquisition

    Litecast Acquisition 9 Litecast Statistics 1 Annualized revenue and Adjusted EBITDA are based on the operating results of Litecast for the three months ended December 31, 2012. Financial results do not reflect any purchase accounting adjustments or reductions for intercompany transactions which will

  10. Slide 10: ZGL Acquisition History

    Weighted Avg Multiple = 9.3x Pre-Synergy and 6.8x Post Synergy 10 ZGL Acquisition History1 FY 2Q 2013 Supplemental Earnings Information 1 Companies denoted by * indicate Purchase Price was adjusted for value attributed to OVS/ZEN/ZPS spin-offs 2 Estimated Revenue LQA and Adjusted EBITDA LQA represen

  11. Slide 11: Organic vs. Inorganic Revenue Growth

    (CHART) ZG Acquired and Organic Revenue Growth 11% Organic Revenue Growth (Date Weighted CAGR) Cumulative Acquired Revenue Annualized Organic Revenue Incremental Acquired Revenue 1 3 4 5 6 7 8 1 CAGR based on establishing a weighted average date based on acquisition date and revenue 2 ZG Acquired an

  12. Slide 12: Organic vs. Inorganic Adj EBITDA Growth

    (CHART) (CHART) Cumulative Acquired EBITDA Annualized Organic EBITDA growth ZG Adjusted EBITDA Growth Adjusted EBITDA Margin 23% Organic EBITDA Growth 54% with Synergies (Date Weighted CAGR) Planned Synergies Incremental Acquired EBITDA 3 4 5 6 7 8 1 CAGR based on establishing a weighted average dat

  13. Slide 13: Planned Synergies Summary

    Planned Synergies Summary 13 Planned Synergies ($M) FY 2Q 2013 Supplemental Earnings Information

  14. Slide 14: Consolidated Financial Data

    Consolidated Financial Data 14 Financial Data 1 The three months ended December 31, 2012 include three months of operating results of the October 1, 2012 USCarrier acquisition and fifteen days of operating results of the December 14, 2012 First Telecom acquisition. The Company recognized $1.6M in re

  15. Slide 15: Net Earnings Stratification

    (CHART) (CHART) Net Earnings Stratification 15 millions Net Income/(loss) from Continuing Operations millions Net Earnings EBITDA Interest expense Provision for income tax Depreciation and amortization Other add backs (CHART) Other Add Backs millions Income from continuing operations Income from dis

  16. Slide 16: Cash Flow Stratification

    (CHART) (CHART) (CHART) Cash Flow Stratification 16 (CHART) millions millions millions Net Increase/(Decrease) in Cash and Cash Equivalents millions Ending Cash Balance Cash from operating activities Cash from financing Cash from investing Cash from discontinued operations (CHART) millions Net Cash

  17. Slide 17: Consolidated Invested Capital Ratio

    Consolidated Invested Capital Ratio 17 Invested Capital FY 2Q 2013 Supplemental Earnings Information 1 For the three months ended December 31, 2012, the increase in Member's interest is primarily due to an additional $4.4 million in equity which was contributed to the Company from Zayo Group Holding

  18. Slide 18: Segment Financial Data

    Segment Financial Data 18 Segment Data FY 2Q 2013 Supplemental Earnings Information

  19. Slide 19: Invested Capital Ratio by Business Unit

    Invested Capital Ratio by Business Unit 19 Invested Capital FY 2Q 2013 Supplemental Earnings Information

  20. Slide 20: Stratification of Revenue

    (CHART) Stratification of Revenue 20 (CHART) (CHART) (CHART) millions millions millions millions MRR and MAR on the Last Day of the Quarter (CHART) MRR on the last day of the quarter MAR of the last day of the quarter millions Revenue Stratification MRR Usage MAR Other Revenue MAR - Upfront Charges

  21. Slide 21: Stratification of Adjusted EBITDA

    (CHART) (CHART) Stratification of Adjusted EBITDA 21 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

  22. Slide 22: Gross New Sales (Bookings)

    (CHART) (CHART) (CHART) (CHART) Gross New Sales (Bookings) 22 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 Upfront Char

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

    23 Estimated Capital and Upfront Expenditures and Gross New Sales (Bookings) IRU and Upfront Charges (CHART) Contract Value = Gross New Sales (Bookings) - IRU and Upfront Charges Gross New Sales (Bookings) from IRUs Gross New Sales (Bookings) Upfront Charges Gross New Sales (Bookings) Other Charges

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

    Stratification of Gross New Sales (Bookings) 24 Gross New Sales (Bookings) Stratification

  25. Slide 25: Stratification of Speculative Projects

    Stratification of Speculative Projects 25 Speculative Capital Expenditure Commitments

  26. Slide 26: Quota Bearing Headcount (QBHC)

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

  27. Slide 27: Installation and Churn Processed

    (CHART) Installation and Churn Processed 27 Installation and Churn Processed (CHART) (CHART) (CHART) Net Installations Gross Profit from Net Installations thousands thousands thousands thousands MRR and MAR MRR and MAR MRR and MAR Monthly Gross Profit Est. Gross Profit = Est. Gross Profit = Est. Gro

  28. Slide 28: Breakdown of Installations and Churn Processed

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

  29. Slide 29: 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 29 Price increases as %

  30. Slide 30: 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 30 MRR and MAR MRR

  31. Slide 31: Service Activation and Churn Pipeline

    (CHART) Service Activation and Churn Pipeline 31 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 MAR MRR MRR and MAR millions Gross Profit = G

  32. Slide 32: Revenue Under Contract

    Revenue Under Contract 32 Revenue Under Contract Revenue Under Contract millions (CHART) Average Remaining Contract Term (CHART) Months FY 2Q 2013 Supplemental Earnings Information 1 Restated Revenue Under Contract for the three months ended September 30, 2012, from $3.2M to $3.0M, due to an AboveNe

  33. Slide 33: Employee Data

    Employee Data 33 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 Related SG&A per Employee

  34. Slide 34: Customer Verticals and Product Mix

    Customer Verticals and Product Mix 34 Customer Verticals and Product Mix FY 2Q 2013 Supplemental Earnings Information

  35. Slide 35: Customer Concentration

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

  36. Slide 36: Customer and Unit Metrics

    (CHART) Customer and Unit Metrics Customer and Unit Metrics (CHART) (CHART) (CHART) Number of Customers Number of Units (MRR and MAR)/Unit 36 Customers MRR and MAR MRR and MAR Units (MRR and MAR)/Customer thousands thousands thousands FY 2Q 2013 Supplemental Earnings Information 1 Number of Customer

  37. Slide 37: Pricing Trends - Waves

    Pricing Trends - Waves 37 (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) thousands MRR (CHART) (CHART) MRR thousands

  38. Slide 38: Pricing Trends - Ethernet

    Pricing Trends - Ethernet 38 (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) - MRR/Unit

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

    Pricing Trends - OC3, OC12, and OC48 39 (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) thousands MRR MRR thousands (CHART)

  40. Slide 40: Pricing Trends - DS1 and DS3

    Pricing Trends - DS1 and DS3 40 (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) (CHART) thousands MRR MRR thousands

  41. Slide 41: Purchases of Property and Equipment

    (CHART) millions Purchases of Property and Equipment Purchases of Property and Equipment by Driver (CHART) 41 Capital Expenditures Purchases of Property and Equipment (CHART) Maintenance, Integration and Other Growth Capital Expenditures Capital Expenditures Capital Expenditures millions millions mi

  42. Slide 42: Network Metrics

    Network Metrics 42 Network Metrics1 (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 Number of Markets (CHART) (CHART) thousands States = FY 2Q 2013 Supplemental Earnings Information Pre-exis

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

    Network Metrics 43 On-Net Buildings FY 2Q 2013 Supplemental Earnings Information

  44. Slide 44: Network Metrics: Colocation Cabinet Utilization

    (CHART) (CHART) (CHART) Network Metrics 44 Colocation Cabinet Utilization Billable Colocation Square Feet Colocation Cabinet Equivalents Utilized Colocation Cabinet Equivalents Square Feet Colocation Cabinet Equivalents Colocation Cabinet Equivalents Utilization = FY 2Q 2013 Supplemental Earnings In

  45. Slide 45: Fiber to the Tower

    45 Fiber to the Tower FY 2Q 2013 Supplemental Earnings Information

  46. Slide 46: Fiber to the Tower

    (CHART) (CHART) 1 Bandwidth/Tenant excludes Dark-Fiber sites Revenue/Tenant Fiber to the Tower (FTT) Fiber to the Tower (CHART) (CHART) Total FTT Towers Bandwidth/Tenant (Mbs)1 Revenue/Tower & Revenue/Tenant (CHART) thousands 46 Towers Tenants MRR and MAR Mbs Revenue/Tower Total FTT Tenants In Servi

  47. Slide 47: Fiber to the Tower: MRR and Capital Expenditures

    (CHART) (CHART) (CHART) % of MRR and MAR % of MRR and MAR % of Zayo Group's Wireless Carrier MRR and MAR Fiber to the Tower (FTT) (CHART) FTT MRR and MAR FTT Cumulative Capital Expenditures FTT Product Mix millions millions 47 MRR and MAR % of FTT MRR and MAR Capital Expenditures % of Zayo Group's M

  48. Slide 48: 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, Oregon and Washington Southeast includes Tennessee, Mississippi and

  49. Slide 49: Financial Data by Business Unit

    49 Financial Data by Business Unit FY 2Q 2013 Supplemental Earnings Information

  50. Slide 50: Zayo Bandwidth Financial Data

    Zayo Bandwidth Financial Data 50 Financial Data 1 The three months ended December 31, 2012 include three months of operating results of the October 1, 2012 USCarrier acquisition and one half month of operating results of the December 14, 2012 First Telecom acquisition. Adjusting for the effect of th

  51. Slide 51: Zayo Fiber Solution Financial Data

    Zayo Fiber Solution Financial Data 51 Financial Data 1 The three months ended December 31, 2012 include three months of operating results of the October 1, 2012 USCarrier acquisition and one half month of operating results of the December 14, 2012 First Telecom acquisition. Adjusting for the effect

  52. Slide 52: zColo Financial Data

    zColo Financial Data 52 Financial Data FY 2Q 2013 Supplemental Earnings Information 1 The three months ended December 31, 2012 include three months of operating results of the October 1, 2012 USCarrier acquisition and one half month of operating results of the December 14, 2012 First Telecom acquisi

  53. Slide 53: Historical Financial Data & Reconciliations

    53 Historical Financial Data & Reconciliations FY 2Q 2013 Supplemental Earnings Information

  54. Slide 54: Consolidated Historical Financial Data

    Consolidated Historical Financial Data 54 Consolidated Financial Data FY 2Q 2013 Supplemental Earnings Information

  55. Slide 55: Consolidated Historical Reconciliations

    Consolidated Historical Reconciliations 55 Consolidated Financial Data FY 2Q 2013 Supplemental Earnings Information

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

    56 Segment Data Reconciliation: Net Earnings/(loss) to Adjusted EBITDA Segment Data Reconciliation 1 A reconciliation of previous quarters' segment information can be found in our historical earnings supplements found on our website at http://www.zayo.com/financial-earnings-release FY 2Q 2013 Supple

  57. Slide 57: Pro-forma Growth Reconciliation

    57 Pro-forma Growth Reconciliation (Supporting FY 2013 Q2 Pro-forma Growth) Pro-forma Growth Reconciliation2 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 asse

Zayo Group — Q2 FY2013 Earnings Presentation on 6ix