Zayo Group Holdings Inc

Zayo — Q2 FY2011 Earnings Presentation

52 slides from Zayo's earnings presentation, Feb 11, 2011

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

    FY 2Q 2011 Supplemental Earnings Information 1 Fiscal Year 2Q 2011 Supplemental Earnings Information Exhibit 99.2 FY 2Q 2011 Supplemental Earnings Information

  2. Slide 2: Forward-Looking Statements

    Forward-Looking Statements 2 FY 2Q 2011 Supplemental Earnings Information Information contained or incorporated by reference in this supplement presentation, in other SEC filings by the Company, in press releases and in presentations by the Company or its management that are not historical by nature

  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 AdjustedEBITDA ar

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

    Presentation of Certain Consolidated Pro-forma Financial Data 4 FY 2Q 2011 Supplemental Earnings Information Acquisitions have been, and are expected to continue to be, a component of the Company’s strategy. In this Supplemental Earnings Informationunder “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: Presentation of Financial Data: Summary Organizational Chart

    Presentation of Financial Data Zayo Group Holdings, Inc. Zayo Group, LLC Zayo Bandwidth, LLC Zayo Enterprise Networks, LLC Zayo Colocation, Inc. Zayo Fiber Solutions, LLC Onvoy, Inc. 6 Summary Organizational Chart 1 Zayo Capital, Inc. FY 2Q 2011 Supplemental Earnings Information Zayo Fiber Solutions

  7. Slide 7: Presentation of Financial Data: Anticipated Organizational Chart

    Presentation of Financial Data Zayo Group Holdings, Inc. Zayo Group, LLC “ZG” Zayo Bandwidth, LLC “ZB” Zayo Colocation, Inc. “zColo” Zayo Fiber Solutions, LLC “ZFS“Onvoy, Inc. “OVS” 7 Anticipated Organizational Chart as of March 31, 20111 FY 2Q 2011 Supplemental Earnings Information Zayo Capital, In

  8. Slide 8: Detail behind the Anticipated Organization Changes

    Zayo Group Holdings, Inc. Zayo Group, LLC “ZG” Zayo Bandwidth, LLC “ZB” Zayo Enterprise Networks, LLC Zayo Colocation, Inc. “zColo” Zayo Fiber Solutions, LLC “ZFS” Onvoy, Inc. “OVS” Presentation of Financial Data 8 Detail behind the Anticipated Organization Changes Zayo Enterprise Networks, LLC “ZEN

  9. Slide 9: Reporting Impacts

    ReportingImpacts As previously disclosed during the three months ended December 31, 2010, management approved a restructuring of the Company’s operating segments effective January 1, 2011. The Company has restructured its operating segments to more closely align with its product offerings. The follo

  10. Slide 10: Recent Acquisitions Pro-Forma Statistics

    Recent Acquisitions 10 FY 2Q 2011 Supplemental Earnings Information Pro-Forma Statistics Acquisition of AGL Networks closed on July 1, 2010; merger with American Fiber Systems closed on October 1, 2010. Nashville colofacility signed and closed on September 20, 2010 1 Quarterly financial results incl

  11. Slide 11: Consolidated Pro-forma Financial Data

    Consolidated Pro-forma Financial Data 11 FY 2Q 2011 Supplemental Earnings Information Pro-forma Financial Data 1 The three months ended December 31, 2009, and the three months ended March 31, 2010, are presented pro-forma for the treatment of OVS (spun-off March 12, 2010) as a related party rather t

  12. Slide 12: Consolidated Invested Capital Ratio

    Consolidated Invested Capital Ratio 12 FY 2Q 2011 Supplemental Earnings Information Invested Capital 1The decrease in member’s interest during the three months ended December 31, 2010, is a result of net deferred tax liability of $0.6 million transferred to OVS. Offsetting this decrease is an increa

  13. Slide 13: Consolidating Financial Data

    Consolidating Financial Data 13 FY 2Q 2011 Supplemental Earnings Information Consolidating Data($ in millions)Zayo BandwidthZayo Enterprise NetworkszColoZayo Fiber SolutionsCorporate / Intercompany EliminationZayo GroupRevenue$52.8$8.1$7.4$11.1($1.6)$77.9Gross profit38.84.23.911.0(0.7)57.2 Gross pro

  14. Slide 14: Invested Capital Ratio by Business Unit

    Invested Capital Ratio by Business Unit 14 FY 2Q 2011 Supplemental Earnings Information Invested Capital1The $71.6 million Invested Capital at Corporate primarily relates to an accumulated deficit at the Corporate business segment in the amount of $75.2 million.Thisdeficit is a result of the Corpora

  15. Slide 15: Stratification of Revenue

    Stratification of Revenue 15 $57.8 $59.7 $66.1 $75.2 $1.0 $1.0 $1.8 $2.4 $0.1 $0.7 $0.7 $0.3 $58.9 $61.4 $68.6 $77.9 $0 $10 $20 $30 $40$50 $60 $70 $80 $90 Mar-10 Jun-10 Sep-10 Dec-10 Revenue Stratification MRR and Usage Revenue MAR Other Revenue $0.4 $0.4 $0.5 $0.6 $0.6 $0.6 $1.3 $1.8 $1.0 $1.0 $1.8

  16. Slide 16: Stratification of Adjusted EBITDA

    Stratification of Adjusted EBITDA 16 millions FY 2Q 2011 Supplemental Earnings Information millionsAdjusted EBITDA Associated with Other Revenue 1 1 Adjusted EBITDA associated with other revenue includes EBITDA from other revenue. There were no asset sales during the period Stratification of Adjuste

  17. Slide 17: Gross New Sales

    17 FY 2Q 2011 Supplemental Earnings Information Gross New Sales $1,358 $1,185 $1,675 $1,566 $0 $500 $1,000 $1,500 $2,000 Mar-10 Jun-10 Sep-10 Dec-10 21 13 26 14 — 5 10 15 20 25 30 Mar-10 Jun-10 Sep-10 Dec-10Gross New Sales Estimated Gross Profit and Gross Profit Percentage on Gross New Sales Estimat

  18. Slide 18: Stratification of Gross New Sales

    thousands thousands millions months MRR and MAR Monthly Gross Profit Capital Expenditures Contract Value = $64M $116M $61M $101M Est. Gross Profit = 87%87% 93% 93% Stratification of Gross New Sales 18 FY 2Q 2011 Supplemental Earnings Information Gross New Sales StratificationMarch 31,June 30,Septemb

  19. Slide 19: Stratification of Speculative Projects

    Stratification of Speculative Projects FY 2Q 2011 Supplemental Earnings Information 19 Speculative Capital Expenditure Commitments($ in millions)March 31,June 30,September 30,December 31,2010201020102010Estimated Success Based Capital2.6$ -$2.9$4.5$ Estimated Speculative Capital4.1 0.9 2.9 5.1 Estim

  20. Slide 20: Quota Bearing Headcount (QBHC)

    Quota Bearing Headcount (QBHC) FY 2Q 2011 Supplemental Earnings Information 20 Quota Bearing Headcount

  21. Slide 21: Quota Bearing Headcount and Gross New Sales per QBHC

    37 36 43 46 0 10 20 30 40 50 Mar-10 Jun-10 Sep-10 Dec-10 $14 $13 $14 $12 $0 $10 $20 $30 $40 Mar-10 Jun-10 Sep-10 Dec-10 Quota Bearing Headcount Monthly Average Gross New Salesper QBHC thousands Headcount Gross New Sales MRR and MAR Installation and Churn 21 FY 2Q 2011 Supplemental Earnings Informati

  22. Slide 22: Breakdown of Installations and Churn

    $1,032 $1,287 $1,580 $1,548 $27 $1,032 $1,287 $1,580 $1,576 $0 $300 $600 $900 $1,200 $1,500 $1,800 Mar-10 Jun-10 Sep-10 Dec-10 Goss Installed Revenue -MRR Goss Installed Revenue -MAR ($901) ($692) ($864) ($923) $0 $0 $0 ($0) ($901) ($692) ($864) ($924) ($1,800) ($1,500) ($1,200) ($900) ($600) ($300)

  23. Slide 23: Installations and Churn Detail

    FY 2Q 2011 Supplemental Earnings Information $935 $1,030 $1,422 $1,460 $38 $184 $106 $66 $59 $73 $52 $51 $1,032 $1,287 $1,580 $1,576 $0 $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800 Mar-10 Jun-10 Sep-10 Dec-10 Installations from New Service Installations from Price Increases Installations f

  24. Slide 24: Change in MRR and MAR

    24 FY 2Q 2011 Supplemental Earnings Information MRR and MAR MRR and MAR MRR and MAR % Change in MRR and MAR Contract Value = $2.2M $1.7M $1.8M $1.4M Contract Value = ($0.5M) ($0.5M) ($0.1M) ($0.4M) Contract Value = $1.7M $1.2M $1.6 M $1.1M 1 A portion of Ethernet upgrades were processed as net chang

  25. Slide 25: Service Activation and Churn Pipeline

    $1.7 $1.6 $1.6 $1.6 $0.5 $0.6 $1.0 $1.2 $2.2 $2.3 $2.6 $2.9 $0 $2 $4 $6 Mar-10 Jun-10 Sep-10 Dec-10 Delivery date within the next 6 months Delivery date after 6 months $1.5 $1.6 $2.0 $2.2 $0.1 $0.7 $0.6 $0.7 $0.6 $2.2 $2.3 $2.6 $2.9 $0 $2 $4 $6 Mar-10 Jun-10 Sep-10 Dec-10 Service Orders -MRR Service

  26. Slide 26: Revenue Under Contract: Pipeline Detail

    ($0.5) ($0.4) ($0.6) ($0.5) ($0.5) ($0.4) ($0.6) ($6) ($4) ($2) $0 Mar-10 Jun-10 Sep-10 Dec-10 Churn Pipeline -MRR Churn Pipeline -MAR $1.7 $1.8 $2.3 $2.3 — - — $0.0 $1.7 $1.8 $2.3 $2.3 $0 $2 $4 $6 Mar-10 Jun-10 Sep-10 Dec-10 Net Install Pipeline -MRR Net Install Pipeline -MAR Service Activation Pip

  27. Slide 27: Revenue Under Contract

    Revenue Under Contract millions Months 24 25 32 36 — 10 20 30 40 Mar-10 Jun-10 Sep-10 Dec-10 Average Remaining Contract Term $390 $400 $577 $704 $71 $80 $95 $153 $180 $57 $56 $61 $55 $528 $552 $790 $1,009 $0 $200 $400 $600 $800 $1,000 $1,200 Mar-10 Jun-10 Sep-10 Dec-10 Embedded Base -MRR Embedded Ba

  28. Slide 28: Employee Data; Customer Verticals and Product Mix

    339 347 393 443 0 100 200 300 400 500 Mar-10 Jun-10 Sep-10 Dec-10 $706 $708 $698 $717 $0 $200 $400 $600 $800 Mar-10 Jun-10 Sep-10 Dec-10 $10.7 $11.2 $12.4 $13.7 $0 $2 $4 $6 $8 $10 $12 $14 Mar-10 Jun-10 Sep-10 Dec-10 $126 $129 $126 $123 $0 $200 $400 $600 $800 Mar-10 Jun-10 Sep-10 Dec-10 Number of Emp

  29. Slide 29: Customer Concentration and Customer and Unit Metrics

    Customer Concentration 29 FY 2Q 2011 Supplemental Earnings Information Customer Concentration % of MRR 12% 12% 11% 11% 9% 9% 9% 8% 6% 7% 7% 7% Mar-10 Jun-10 Sep-10 Dec-10 Customer #1 Customer #2 Customer #3 Top 20 Top 10 Top 5 Customer and Unit Metrics Customer and Unit Metrics 2,046 2,048 2,074 2,2

  30. Slide 30: Customers and Units Metrics

    30 FY 2Q 2011 Supplemental Earnings Information Customers MRR and MAR MRR and MAR Units $10 $10 $11 $12 $0 $5 $10 $15 Mar-10 Jun-10 Sep-10 Dec-10 (MRR and MAR)/Customer thousands thousands thousands 1 1 1Units and (MRR and MAR)/Unit exclude Fiber Miles and ZFS MRR 1 1

  31. Slide 31: Pricing Trends - Waves

    Pricing Trends —Waves1 FY 2Q 2011 Supplemental Earnings Information 31 1Pricing trends based on ZB only $931 $1,037 $1,287 $1,462 $0 $1,000 $2,000 $3,000 Mar-10 Jun-10 Sep-10 Dec-10 10G Waves -MRR 108 122 137 152 0 40 80 120 160 200 Mar-10 Jun-10 Sep-10 Dec-10 10G Waves -Units $8.6 $8.5 $9.4 $9.6 $0

  32. Slide 32: Pricing Trends - Ethernet

    Pricing Trends -Ethernet 1,3 FY 2Q 2011 Supplemental Earnings Information 32 $567 $574 $698 $1,033 $0 $500 $1,000 $1,500 $2,000 $2,500 $3,000 $3,500 Pro-formaMar-10 Jun-10 Sep-10 Dec-10 101-1000Mb Ethernet—MRR 182 176 200 296 0 500 1,000 1,500 2,000 2,500 Pro-forma Mar-10 Jun-10 Sep-10 Dec-10 101-10

  33. Slide 33: Ethernet MRR/Unit; Pricing Trends - OC3, OC12, OC48

    101-1000Mb Ethernet—MRR/Unit 1-100Mb Ethernet —MRR/Unit 2 2 2 Pricing Trends —OC3, OC12, and OC481 FY 2Q 2011 Supplemental Earnings Information 33

  34. Slide 34: Pricing Trends - OC3, OC12, OC48

    $1,089 $1,081 $1,106 $1,130 $0 $500 $1,000 $1,500 $2,000 $2,500 Mar-10 Jun-10 Sep-10 Dec-10 OC48 - -MRR 80 76 78 85 0 100 200 300 400 500 Mar-10 Jun-10 Sep-10 Dec-10 OC48 -Units $13.6 $14.2 $14.2 $13.3 $0 $5 $10 $15 $20 Mar-10 Jun-10 Sep-10 Dec-10 OC48 —MRR /Unit thousands MRR MRR thousands $1,593 $

  35. Slide 35: Pricing Trends - DS1 and DS3

    $3,969 $4,004 $3,963 $4,121 $0 $1,000 $2,000 $3,000 $4,000 $5,000 Pro-forma Mar-10 Jun-10 Sep-10 Dec-10 DS3—MRR 3,410 3,440 3,359 3,572 0 2,000 4,000 6,000 8,000 10,000 12,000 Pro-forma Mar-10 Jun-10 Sep-10 Dec-10 DS3—Units $1.2 $1.2 $1.2 $1.2 $0.0 $0.5 $1.0 $1.5 Pro-formaMar-10 Jun-10 Sep-10 Dec-10

  36. Slide 36: Capital Expenditures and Network Metrics

    $0.4 $0.4 $0.2 $0.5 $0.3 $1.1 $0.4 $0.1 $0.7 $1.5 $0.6 $0.6 $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 Mar-10 Jun-10 Sep-10 Dec-10 Maintenance Other $0.8 $0.6 $0.4 $0.4 $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 $3.0 Mar-10 Jun-10 Sep-10 Dec-10 Maintenance and Other Integration $13.5 $17.3 $19.2 $35.4 $1.6 $2.2 $1.2 $1.

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

    Network Metrics 37 FY 2Q 2011 Supplemental Earnings Information On-Net BuildingsMarch 31,June 30,September 30,December 31,2010201020102010On-Net Building TypeCell Site9131,0451,3461,681Enterprise8638771,1521,628Carrier Point of Presence (“PoP”)119120151188Local Serving Office (“LSO”)107116153177Carr

  38. Slide 38: Network Metrics: Colocation Cabinet Utilization

    Network Metrics 38 FY 2Q 2011 Supplemental Earnings Information Colocation Cabinet Utilization 39,949 41,091 50,091 50,091 — 10,000 20,000 30,000 40,000 50,000 60,000 Mar-10 Jun-10 Sep-10 Dec-10 1,598 1,642 2,004 2,004 0 500 1,000 1,500 2,000 2,500 Mar-10 Jun-10 Sep-10 Dec-10 1,330 1,327 1,361 1,314

  39. Slide 39: Fiber-to-the-Tower

    FY 2Q 2011 Supplemental Earnings Information 39 Fiber-to-the-Tower $2.0 $2.1 $2.0 $1.9 $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 Mar-10 Jun-10 Sep-10 Dec-10 $1.2 $1.3 $1.3 $1.3 1Bandwidth/Site excludes Dark-Fiber sites Fiber-to-the-Tower (FTT) Fiber-to-the-Tower 913 1,045 1,346 1,681 552 564 872 628 1,465 1,609

  40. Slide 40: Fiber-to-the-Tower (FTT) MRR and Product Mix

    40 FY 2Q 2011 Supplemental Earnings Information Towers Sites MRR and MAR Mbs 1.5 Customers/ Site = 1.6 Revenue/Tower Revenue/Site Total FTT sites 1.5 1.5 34% 38% 41% 42% 0% 10% 20% 30% 40% 50% Mar-10 Jun-10 Sep-10 Dec-10 13% 11% 12% 12% % of Zayo Group’s Wireless Carrier MRR and MAR1 Fiber-to-the-To

  41. Slide 41: FTT Share of MRR and MAR and Capital Expenditures

    41 FY 2Q 2011 Supplemental Earnings Information % of MRR and MAR MRR and MAR % of MRR and MAR % of FTT MRR and MAR Capital Expenditures % of Zayo Group’s MRR and MAR 1 Zayo Group’s wireless carrier MRR and MAR was $5.2 million on March 31, 2010, $5.7 million on June 30, 2010, $6.6million on Septembe

  42. Slide 42: FTT Markets

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

  43. Slide 43: Financial Data by Business Unit

    FY 2Q 2011 Supplemental Earnings Information 43 Financial Data by Business Unit

  44. Slide 44: Zayo Bandwidth Financial Data

    Zayo Bandwidth Financial Data 44 Financial Data 1The three months ended September 30, 2010, amounts include the transfer of $1.4M Revenue and $1.1M Adjusted EBITDA from ZB toZFS in conjunction with the launch of ZFS on July 1, 2010. Excluding the effect of these intercompany transfers, the annualize

  45. Slide 45: Zayo Fiber Solutions Financial Data

    Zayo FiberSolutionsFinancial Data FY 2Q 2011 Supplemental Earnings Information 45 Financial Data($ in millions)September 30,December 31,20102010Revenue$7.5 $11.1 Annualized revenue growth194%Gross profit7.4 11.0 Gross profit %98%99%Operating income$2.0 $3.0 Adjusted EBITDA$4.3 $7.0 Purchases of prop

  46. Slide 46: zColo Financial Data

    zColo Financial Data FY 2Q 2011 Supplemental Earnings Information 46 Financial Data($ in millions)March 31,June 30,September 30,December 31,2010201020102010Revenue$6.9 $7.1 $7.2 $7.4 Annualized revenue growth11%5%11%Gross profit3.6 3.7 3.6 3.9 Gross profit %52%52%50%53%Operating income$1.0 $1.3 $1.0

  47. Slide 47: Zayo Enterprise Networks Financial Data

    Zayo Enterprise Networks Financial Data 47 FY 2Q 2011 Supplemental Earnings Information 1The three months ended September 30, 2010, amounts include the transfer of $0.7 million Revenue and $0.3 million Adjusted EBITDA from ZEN to ZFS in conjunction with the launch of ZFS on July 1, 2010 Financial Da

  48. Slide 48: Historical Financial Data & Reconciliations

    FY 2Q 2011 Supplemental Earnings Information 48 HistoricalFinancial Data & Reconciliations

  49. Slide 49: Consolidated Historical Financial Data

    Consolidated Historical Financial Data 49 FY 2Q 2011 Supplemental Earnings Information Financial Data($ in millions)Fiscal Year 2009September 30,December 31,March 31,June 30,September 30,December 31,Total2009200920102010Total20102010Revenue$150.8 $45.5 $58.2 $58.9 $61.4 $224.0 $68.6 $77.9 Annualized

  50. Slide 50: Consolidated Historical Reconciliations

    Consolidated Historical Reconciliations 50 FY 2Q 2011 Supplemental Earnings Information Financial Data($ in millions)Fiscal Year 2009September 30,December 31,March 31,June 30,September 30,December 31,Total2009200920102010Total20102010Earnings/(loss) from continuing operations($9.3)$0.1 $2.9 ($11.4)$

  51. Slide 51: Financial Data Reconciliation

    51 FY 2Q 2011 Supplemental Earnings Information Financial DataReconciliation Financial DataZayo BandwidthZayo Enterprise NetworkszColoZayo Fiber SolutionsCorporate / Interco EliminationZayo GroupEarnings/(loss) from continuing operations$10.1 ($0.2)$1.0 $3.0 ($12.0)$1.9 Depreciation and amortization

  52. Slide 52: Pro-forma Growth Reconciliation

    52 FY 2Q 2011 Supplemental Earnings Information Pro-forma Growth Reconciliation Pro-forma Growth Reconciliation 1Revenue 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 as

Zayo Group — Q2 FY2011 Earnings Presentation on 6ix