Zayo Group Holdings Inc

Zayo — FY 3Q 2011 Earnings Presentation

48 slides from Zayo's earnings presentation, May 13, 2011

  1. Slide 1: FY 3Q 2011 Supplemental Earnings Information

    FY 2Q 2011 Supplemental Earnings Information 1 Fiscal Year 3Q 2011 Supplemental Earnings Information FY 3Q 2011 Supplemental Earnings InformationForward-Looking Statements

  2. Slide 2: Forward-Looking Statements

    2 FY 3Q 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 constitute “forward-lookin

  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 3Q 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: Zayo Group Capital Summary Structure

    ZayoGroup Holdings Onvoy ZayoEnterprise Networks ZayoGroup ZayoBandwidth (“ZB”) ZayoFiber Solutions (“ZFS”) zColo ZayoCapital Summary Structure 6 FY 3Q 2011 Supplemental Earnings Information

  7. Slide 7: Reporting Company Restructuring

    Reporting Company Restructuring The chart below depicts the Company’s organizational structure1as of April 1, 2011 and includes the following restructuring events: ·March 12, 2010 spin-off of Onvoy(see Note 4 of the Notes to Condensed Consolidated Financial Statements) ·January 1, 2011 restructuring

  8. Slide 8: Reporting Impacts of Restructuring

    ReportingImpactsof Restructuring The spin-off and associated restructuring of our operating segments (as more fully described in the Notes to Condensed Consolidated Financial Statements and Management’s Discussion and Analysis of Financial Condition and Results of Operations) impact the supplemental

  9. Slide 9: Consolidated Pro-forma Financial Data

    Consolidated Pro-forma Financial Data 8 FY 3Q 2011 Supplemental Earnings Information Pro-forma Financial Data 1 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 than as intercompany 2 The three months ended Se

  10. Slide 10: Consolidated Invested Capital Ratio

    Consolidated Invested Capital Ratio 9 FY 3Q 2011 Supplemental Earnings InformationInvested Capital1The increase in member’s interest during the three months ended March 31, 2011 is a result of the Company’s utilization of $11.6 million of CII’s net operating loss carry forward during the quarter whi

  11. Slide 11: Consolidating Financial Data

    Consolidating Financial Data 10FY 3Q 2011 Supplemental Earnings Information Consolidating Data($ in millions)Zayo BandwidthZayo Enterprise NetworkszColoZayo Fiber SolutionsCorporate / Intercompany EliminationZayo GroupRevenue$54.7$5.6$9.1$11.9($1.6)$79.7Gross profit40.72.44.711.5(0.6)58.6 Gross prof

  12. Slide 12: Invested Capital Ratio by Business Unit

    Invested Capital Ratio by Business Unit 11 FY 3Q 2011 Supplemental Earnings Information Invested Capital 1The $91.2 million invested capital at corporate primarily related to an accumulated deficit at the corporate business segmentinthe amount of $98.3 million. This deficit is a result of the corpor

  13. Slide 13: Stratification of Revenue

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

  14. Slide 14: Stratification of Adjusted EBITDA

    Stratification of Adjusted EBITDA 13 millionsFY 3Q 2011 Supplemental Earnings Information millions Adjusted EBITDA Associated with Other Revenue 1 Stratification of Adjusted EBITDA Adjusted EBITDA Stratification 1 Adjusted EBITDA associated with other revenue includes EBITDA from other revenue. Ther

  15. Slide 15: Gross New Sales (Bookings)

    Gross New Sales (Bookings) 14 FY 3Q 2011 Supplemental Earnings Information Gross New Sales (Bookings)1 21 13 26 14 16 — 5 10 15 20 25 30 Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 Gross New Sales (Bookings) Estimated Gross Profit and Gross Profit Percentage on Gross New Sales (Bookings) Estimated Capital Ex

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

    Stratification of Gross New Sales (Bookings) 15 FY 3Q 2011 Supplemental Earnings Information Gross New Sales (Bookings) Stratification1 1The operating measures for the period ended March 31, 2011 exclude ZEN. Periods prior to March 31, 2011 include ZEN and will not be restated to exclude ZEN as mana

  17. Slide 17: Stratification of Speculative Projects

    Stratification of Speculative Projects FY 3Q 2011 Supplemental Earnings Information 16 Speculative Capital Expenditure Commitments 1 The estimated Infrastructure Capital andSuccess 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 3Q 2011 Supplemental Earnings Information 17 Quota Bearing Headcount1 37 36 43 46 39 0 10 20 30 40 50 Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 $14 $13 $14 $12 $14 $0 $10 $20 $30 $40 Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 Quota Bearing Headcount Monthly Average Gross New Sales

  19. Slide 19: Installation and Churn Processed

    Installation and Churn Processed 18 FY 3Q 2011 Supplemental Earnings Information Installation and Churn Processed1 ($901) ($692) ($864) ($923) ($950) ($0) ($0) ($901) ($692) ($864) ($924) ($951) 74% 79% 86% 76% 87% ($2,000) ($1,600) ($1,200) ($800) ($400) $0 Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 Churn

  20. Slide 20: Breakdown of Installations and Churn Processed

    Breakdown of Installations and Churn Processed Installs and Churn Processed1 19 FY 3Q 2011 Supplemental Earnings Information Gross Installations thousands ($784) ($576) ($707) ($808) ($740) ($76) ($44) ($120) ($70) ($116) ($41) ($73) ($37) ($45) ($94) ($901) ($692) ($864) ($924) ($951) -1.6% -1.2% -

  21. Slide 21: Price Changes

    Price Changes Churn Processed associated with Upgrades Churn Processed thousands MRR and MAR MRR and MAR 87% 8% 5% 83% 6% 11% 82% 14% 4% 87% 8% 5% 19% Churn = 78% 12% 10% 1The operating measures for the period ended March 31, 2011 exclude ZEN. Periods prior to March 31, 2011 include ZEN and will not

  22. Slide 22: Upgrades

    1 A portion of Ethernet upgrades were processed as net change orders during the quarters ended March 31, 2010, June 30, 2010, and September 30, 2010. This treatment does not impact net install amounts, but caused a slight understatement of both gross installations associated with Upgrades and Churn

  23. Slide 23: Service Activation and Churn Pipeline

    Service Activation and Churn Pipeline 22 FY 3Q 2011 Supplemental Earnings Information Service Activation and Churn Pipeline2 ($0.5) ($0.5) ($0.4) ($0.6) ($0.5) ($0.5) ($0.5) ($0.4) ($0.6) ($0.5) 66% 65% 70% 70% 87% ($6) ($4) ($2) $0 Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 Churn Pipeline -MRR $1.7 $1.8 $2

  24. Slide 24: Revenue Under Contract

    Revenue Under Contract 23 FY 3Q 2011 Supplemental Earnings Information Revenue Under Contract1,2 Revenue Under Contract millions Months 24 25 32 36 37 — 10 20 30 40 Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 Average Remaining Contract Term $390 $400 $577 $704 $702 $71 $70 $80 $95 $153 $180 $203 $57 $56 $61

  25. Slide 25: Employee Data

    Employee Data FY 3Q 2011 Supplemental Earnings Information 24 Employee Data1 339 347 393 443 393 0 100 200 300 400 500 Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 $706 $708 $698 $703 $754 $0 $200 $400 $600 $800 Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 $10.7 $11.2 $12.4 $13.7 $12.5 18% 18% 18% 17% 17% $0 $5 $10 $15

  26. Slide 26: Customer Verticals and Product Mix

    Customer Verticals and Product Mix 25 FY 3Q 2011 Supplemental Earnings Information Customer Verticals and Product Mix2 1Period ending September 30, 2010, reflects $282 thousand MRR and MAR transitioned from SONET/Digital Signal service to Ethernet services for Fiber-to-the-Tower site level billing m

  27. Slide 27: Customer Concentration

    Customer Concentration 1 % of MRR Customer #1 Customer #2 Customer #3 Top 20 Top 10 Top 5 1The operating measures for the period ended March 31, 2011 exclude ZEN. Periods prior to March 31, 2011 include ZEN and will not be restated to exclude ZEN as management has determined it is impractical to do

  28. Slide 28: Customer and Unit Metrics

    Customer and Unit Metrics Customer and Unit Metrics2 2,046 2,048 2,074 2,227 994 — 500 1,000 1,500 2,000 2,500 Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 23 24 25 27 26 — 5 10 15 20 25 30 Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 $0.86 $0.84 $0.80 $0.97 $0.96 $0 $5 $10 $15 $20 $25 $30 Mar-10 Jun-10 Sep-10 Dec-10 M

  29. Slide 29: Pricing Trends - Waves

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

  30. Slide 30: Pricing Trends Notes

    1Pricing trends based on ZB only 2 Three months ended March 31, 2010 are shown on a pro-forma basis, adjusted to include one OVS 200Mb Ethernet unit as if OVS had been a related party rather than a discontinued operation for the entire period 3Period ending September 30, 2010 reflects $282 thousand

  31. Slide 31: Pricing Trends - Ethernet

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

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

    Pricing Trends —OC3, OC12, and OC481,3 FY 3Q 2011 Supplemental Earnings Information 30 $1,089 $1,098 $1,126 $1,149 $1,112 $0 $500 $1,000 $1,500 $2,000 $2,500 Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 OC48 -MRR 80 79 81 88 82 0 100 200 300 400 500 Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 OC48 -Units $13.6 $13.9 $

  33. Slide 33: Pricing Trends - DS1 and DS3

    Pricing Trends —DS1 and DS31 FY 3Q 2011 Supplemental Earnings Information 31 $3,969 $4,004 $3,963 $4,121 $3,989 $0 $1,000 $2,000 $3,000 $4,000 $5,000 Pro-forma Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 DS3—MRR 3,410 3,440 3,359 3,572 3,381 0 2,000 4,000 6,000 8,000 10,000 12,000 Pro-forma Mar-10 Jun-10 Sep

  34. Slide 34: Network Metrics

    Network Metrics 33 FY 3Q 2011 Supplemental Earnings Information Network Metrics 20,172 20,409 20,823 21,993 23,351 761 1,049 20,172 20,409 21,584 23,042 23,351 — 5,000 10,000 15,000 20,000 25,000 Mar-10 Jun-10 Sep-10 Dec-10Mar-11 AGL AFS532,428 538,810 561,041 755,158 935,425 192,048 172,415 532,428

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

    Network Metrics 34 FY 3Q 2011 Supplemental Earnings Information On-Net BuildingsMarch 31,June 30,September 30,December 31,March 31,20102010201020102011On-Net Building TypeCell Site9131,0451,3461,6811,826Enterprise8638771,1521,6281,652Carrier Point of Presence (“PoP”)119120151188189Local Serving Offi

  36. Slide 36: Network Metrics: Colocation Cabinet Utilization

    Network Metrics 35 FY 3Q 2011 Supplemental Earnings Information Colocation Cabinet Utilization 39,949 41,091 50,091 50,091 72,716 — 20,000 40,000 60,000 80,000 Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 1,598 1,642 2,004 2,004 2,909 0 500 1,000 1,500 2,000 2,500 3,000 Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 1,33

  37. Slide 37: Fiber to the Tower

    FY 3Q 2011 Supplemental Earnings Information 36 Fiber to the Tower $2.0 $2.1 $2.0 $1.9 $2.0 $0.0 $0.5 $1.0 $1.5 $2.0 $2.5 Mar-10 Jun-10 Sep-10 Dec-10 Mar-11 $1.2 $1.3 $1.3 $1.3 $1.3 Fiber to the Tower (FTT) Fiber to the Tower 913 1,045 1,346 1,681 1,826 552 564 872 628 595 1,465 1,609 2,218 2,309 2,

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

  39. Slide 39: FTT Markets by Region

    FY 3Q 2011 Supplemental Earnings InformationMarch 31,June 30,September 30,December 31,March 31,20102010201020102011In Service:Mid-Atlantic99131616North Central4592121Pacific Northwest11233Southeast-1122Southwest—Total FTT Markets In Service1416254242Under Construction: Mid-Atlantic67634North Central

  40. Slide 40: Financial Data by Business Unit

    FY 3Q 2011 Supplemental Earnings Information 40 Financial Data by Business Unit

  41. Slide 41: Zayo Bandwidth Financial Data

    Zayo Bandwidth Financial Data 41 Financial Data 1 FY 3Q 2011 Supplemental Earnings Information 1 Effective January 1, 2011, the Company restructured the ZEN operating segment to more closely align with its product offerings resulting in bandwidth infrastructure and colocation products being allocate

  42. Slide 42: ZFS Financial Data

    ZFS Financial Data FY 3Q 2011 Supplemental Earnings Information 42 Financial Data 1 1Effective January 1, 2011, the Company restructured the ZEN operating segment to more closely align with its product offerings resulting in bandwidth infrastructure and colocation products being allocated from ZEN t

  43. Slide 43: zColo Financial Data

    zCOLO Financial Data FY 3Q 2011 Supplemental Earnings Information 43 Financial Data 1 1Effective January 1, 2011, the Company restructured the ZEN operating segment to more closely align with its product offerings resulting in bandwidth infrastructure and colocation products being allocated from ZEN

  44. Slide 44: Historical Financial Data & Reconciliations

    FY 3Q 2011 Supplemental Earnings Information 44 HistoricalFinancial Data & Reconciliations

  45. Slide 45: Consolidated Historical Financial Data

    Consolidated Historical Financial Data 45 FY 3Q 2011 Supplemental Earnings Information Financial Data($ in millions)Fiscal Year 2009September 30,December 31,March 31,June 30,September 30,December 31,March 31,Total2009200920102010Total201020102011Revenue$150.8 $45.5 $58.2 $58.9 $61.4 $224.0 $68.6 $77

  46. Slide 46: Consolidated Historical Reconciliations

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

  47. Slide 47: Financial Data Reconciliation

    47 FY 3Q 2011 Supplemental Earnings Information Financial DataReconciliation Financial Data($ in millions)Zayo BandwidthZayo Enterprise NetworkszColoZayo Fiber SolutionsCorporate / Interco EliminationZayo GroupEarnings/(loss) from continuing operations$3.5 $0.0 $1.3 $1.2 ($22.6)($16.7)Depreciation a

  48. Slide 48: Pro-forma Growth Reconciliation

    48 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 — FY 3Q 2011 Earnings Presentation on 6ix