Zayo Group Holdings Inc

Zayo — Q1 FY2011 Earnings Presentation

47 slides from Zayo's earnings presentation, Nov 12, 2010

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

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

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

  3. Slide 3: Other Notes

    Other Notes The enclosed supplement should be read in conjunction with the Company’s Fiscal Year 2010 Earnings Release and Annual Report Forward-Looking Statements Statements made in this presentation and conference call that are not historical in nature constitute forward-looking statements.We cann

  4. Slide 4: Presentation of Financial Data

    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. 4 Summary Organizational ChartZayo Capital, Inc. FY 1Q 2011 Supplemental Earnings Information Onvoy, Inc. (“Onvoy Voi

  5. Slide 5: Recent Acquisitions Pro-Forma Statistics

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

  6. Slide 6: Reporting Impacts

    ReportingImpacts Effective January 1, 2011, the Company intends to implement certain organizational changes. These changes, in conjunction with previously announced acquisitions, will impact our reporting and comparability of prior periods. The Company will provide an explanation and analysis of the

  7. Slide 7: Consolidated Pro-forma Financial Data

    Consolidated Pro-forma Financial Data7 FY 1Q 2011 Supplemental Earnings Information Pro-forma1Financial 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 Onvoy Voice Services (spun-off March 12, 2010) as a related p

  8. Slide 8: Consolidated Invested Capital Ratio

    Consolidated Invested Capital Ratio 8 FY 1Q 2011 Supplemental Earnings Information Invested Capital 1 The increase in member’s interest during the three months ended September 30, 2010 is a result of additional capital contributions from Zayo Group Holdings, Inc. in the amount of $35.5 million, a ta

  9. Slide 9: Consolidating Financial Data

    Consolidating Financial Data 9FY 1Q 2011 Supplemental Earnings Information Consolidating Data($ in millions)Zayo BandwidthZayo Enterprise NetworkszColoZFSCorporate / Intercompany EliminationZayo GroupRevenue$47.2$8.2$7.2$7.5($1.5)$68.6Gross profit34.14.33.67.4(0.6)48.7 Gross profit %72%53%50%98%42%7

  10. Slide 10: Invested Capital Ratio by Business Unit

    Invested Capital Ratio by Business Unit 10FY 1Q 2011 Supplemental Earnings Information Invested Capital 1Certain assets and liabilities are not allocated to the business units (e.g. debt issuance costs, deferred income taxes, corporate stock based compensation accrual, etc.), as such, $56.5 million

  11. Slide 11: Stratification of Revenue

    Stratification of Revenue 11 $58.8 $59.7 $66.1 $0.4 $0.4 $0.5 $0.6 $0.6 $1.3 $0.1 $0.6 $0.7 $59.9 $61.4 $68.6 $0$10 $20 $30 $40 $50 $60 $70 Mar-10 Jun-10Sep-10 Revenue Stratification MRR and Usage Revenue excluding Amortization of Deferred Revenue Amortization of Deferred Revenue -Installs Amortizat

  12. Slide 12: Stratification of Adjusted EBITDA

    Stratification of Adjusted EBITDA 12 $21.0 $21.7 $24.4 $0 $5$10 $15 $20 $25 Mar-10 Jun-10 Sep-10 millions millions $0.8 $1.1 $1.3-$1 $0 $1 $2 Mar-10 Jun-10 Sep-10 Capitalized Labor FY 1Q 2011 Supplemental Earnings Information millions Adjusted EBITDA excluding Amortization of Deferred Revenue and EB

  13. Slide 13: Stratification of Gross New Sales

    Stratification of Gross New Sales 14FY 1Q 2011 Supplemental Earnings Information Gross New Sales StratificationMarch 31,June 30,September 30,2010201020101.Network capacityGross New Sales ($ in thousands)$0$0$0Estimated Capital Expenditures on Gross New Sales ($ in millions)1.90.50.84%2.<12 Month Pay

  14. Slide 14: Stratification of Speculative Projects

    Stratification of Speculative Projects FY 1Q 2011 Supplemental Earnings Information 15 Speculative Capital Expenditure Commitments($ in millions)March 31,June 30,September 30,201020102010Estimated Success Based Capital2.6$ -$2.9$ Estimated Speculative Capital4.1 0.9 2.9 Estimated Total Capital for S

  15. Slide 15: Quota Bearing Headcount (QBHC)

    Quota Bearing Headcount (QBHC) FY 1Q 2011 Supplemental Earnings Information 16 Quota Bearing Headcount 37 36 43 0 10 20 30 40 50 Mar-10 Jun-10 Sep-10 $14$13 $14 $0 $5 $10 $15 Mar-10 Jun-10 Sep-10 Quota Bearing Headcount Monthly Average Gross New Salesper QBHC thousands Headcount Gross New Sales MRR

  16. Slide 16: Installation and Churn

    Installation and Churn 17 FY 1Q 2011 Supplemental Earnings Information Installation and Churn $1,032 $1,287 $1,580 $0 $400 $800 $1,200 $1,600 Mar-10 Jun-10 Sep-10 ($901) ($692) ($864) ($1,600) ($1,200) ($800) ($400) $0 Mar-10 Jun-10 Sep-10 Gross Profit = 79% $131 $595 $716 $0 $400 $800 $1,200 $1,600

  17. Slide 17: Breakdown of Installations and Churn

    Breakdown of Installations and Churn Installs and Churn 18 FY 1Q 2011 Supplemental Earnings Information $935 $1,030 $1,422 $38 $184 $106 $59 $73 $52 $1,032 $1,287 $1,580 $0 $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800 Mar-10 Jun-10 Sep-10 Installations from New Serivce Installations from P

  18. Slide 18: 8% 5% 83% 6% 11% MRR MRR 100% 100% 100% 100% 90% 3% 7%

    8% 5% 83% 6% 11% MRR MRR 100% 100% 100% 100% 90% 3% 7% 100% 82% 14% 4% 100% Churn = -1.6% Churn = -1.2% Churn = -1.3%

  19. Slide 19: Price Changes

    Price Changes Price Changes $38 $184 $106 $0 $50 $100 $150 $200 Mar-10 Jun-10 Sep-10 $1.5 $1.8 $5.7 $5.7 $1.5 $4.5 $7.1 $3.3 $10.2 $0 $2 $4 $6 $8 $10 $12 Mar-10 Jun-10 Sep-10 CV associated with Price Increases CV associated with Price Decreases ($76) ($44) ($120) ($200) ($150) ($100) ($50) $0 Mar-10

  20. Slide 20: Price Changes Net of Price Increases and Price Decreases

    Price Changes Net of Price Increases and Price Decreases thousands MRR 19 FY 1Q 2011 Supplemental Earnings Information

  21. Slide 21: Upgrades

    Upgrades Upgrades $59 $73 $52 $0 $20 $40 $60 $80 Mar-10 Jun-10 Sep-10 ($44) ($73) ($37) ($80) ($60) ($40) ($20) $0 Mar-10 Jun-10 Sep-10 $15 $1 $16 $0 $20 $40 $60 $80 Mar-10 Jun-10 Sep-10 36% 1% 44% 0% 10% 20% 30% 40% 50% Mar-10 Jun-10 Sep-10 Gross Installations Associated with Upgrades Average % Inc

  22. Slide 22: Revenue Under Contract

    Gross Profit = 102% Gross Profit = 65% Gross Profit = 66% Gross Profit = 101% Gross Profit = 101% Revenue Under Contract 22 FY 1Q 2011 Supplemental Earnings Information Revenue Under Contract $390 $400 $577 $80 $95 $153 $57 $56 $65 $528 $552 $795 $0 $200 $400 $600 $800 $1,000 Mar-10 Jun-10 Sep-10 Em

  23. Slide 23: Employee Data

    Employee Data FY 1Q 2011 Supplemental Earnings Information 23 Employee Data 339 347 393 0 100 200 300 400 500 Mar-10 Jun-10 Sep-10 $706 $708 $698 $0 $200 $400 $600 $800 Mar-10 Jun-10 Sep-10 $10.7 $11.2 $12.4 $0 $2 $4 $6 $8 $10 $12 $14 Mar-10 Jun-10 Sep-10 $126 $129 $126 $0 $200 $400 $600 $800 Mar-10

  24. Slide 24: Customer Verticals and Product Mix

    Customer Verticals and Product Mix 24 FY 1Q 2011 Supplemental Earnings Information Customer Verticals and Product MixZayo Group Customer VerticalsMarch 31,June 30,September 30,% of MRR201020102010Wireless27%28%29%National Carrier/ISP24%24%24%Public Sector/Enterprises16%15%14%PTT11%11%10%Regional Car

  25. Slide 25: Customer Concentration

    Customer Concentration 25 FY 1Q 2011 Supplemental Earnings Information Customer Concentration

  26. Slide 26: Customer and Unit Metrics

    56% 55% 56% 0% 10% 20% 30% 40% 50% 60% 70% 80% 44% 44% 43% 34% 35% 34% 12% 12% 11% 9% 9% 9% 6% 7% 7% Mar-10 Jun-10 Sep-10 % of MRR 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 — 500 1,000 1,500 2,000 2,500 Mar-10 Jun-10

  27. Slide 27: Pricing Trends - Waves

    Pricing Trends —Waves1 FY 1Q 2011 Supplemental Earnings Information 27 1Pricing trends for waves are Zayo Bandwidth only $931 $1,037 $1,287 $0 $1,000 $2,000 $3,000 Mar-10 Jun-10 Sep-10 10G Waves -MRR 108 122 137 0 40 80 120 160 Mar-10 Jun-10 Sep-10 10G Waves -Units $8.6 $8.5 $9.4 $0 $20 $40 $60 $80

  28. Slide 28: Pricing Trends - Ethernet

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

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

    Pricing Trends —OC3, OC12, and OC481 FY 1Q 2011 Supplemental Earnings Information 29 $1,089 $1,081 $1,106 $0 $500 $1,000 $1,500 $2,000 $2,500 Mar-10 Jun-10 Sep-10 OC48 -MRR 80 76 78 0 100 200 300 400 Mar-10 Jun-10 Sep-10 OC48 -Units $13.6 $14.2 $14.2 $0 $5 $10 $15 Mar-10 Jun-10 Sep-10 OC48 —MRR/Unit

  30. Slide 30: Pricing Trends - DS1 and DS3

    Pricing Trends —DS1 and DS31 FY 1Q 2011 Supplemental Earnings Information 30 $3,969 $4,004 $3,963 $0 $1,000 $2,000 $3,000 $4,000 $5,000 Pro-forma Mar-10 Jun-10 Sep-10 DS3—MRR 3,410 3,440 3,359 0 2,000 4,000 6,000 8,000 10,000 Pro-forma Mar-10 Jun-10 Sep-10 DS3—Units $1.2 $1.2 $1.2 $0.0 $0.5 $1.0 $1.

  31. Slide 31: Purchases of Property and Equipment

    2 2 2 2 2 2 3 3 3 3 3 3 millions Purchases of Property and Equipment Purchases of Property and Equipment by Driver $15.1 $19.5 $20.4 $0.4 $0.4 $0.2 $0.8 $0.6 $0.4 $0.3 $1.1 $0.4 $16.7 $21.6 $21.4 $0 $5 $10 $15 $20 $25 Mar-10 Jun-10 Sep-10 Growth Maintenance Integration Other 31 FY 1Q 2011 Supplement

  32. Slide 32: Capital Expenditures and Network Metrics

    Integration $13.5 $17.3 $19.2 $1.6 $2.2 $1.2 $15.1 $19.5 $20.4 $0 $5 $10 $15 $20 $25 Mar-10 Jun-10 Sep-10 Success Based Infrastructure Growth Capital Expenditures Capital Expenditures Capital Expenditures millions millions millions Network Metrics 32 FY 1Q 2011 Supplemental Earnings Information Netw

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

    Network Metrics 33 FY 1Q 2011 Supplemental Earnings Information On-Net BuildingsMarch 31,June 30,September 30,201020102010On-Net Building TypeCell Site9131,0451,346Enterprise8638771,152Local Serving Office (“LSO”)107116153Carrier Point of Presence (“PoP”)119120151Carrier Hotel/Data Center7476100Wire

  34. Slide 34: Network Metrics - Colocation Cabinet Utilization

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

  35. Slide 35: Fiber to the Tower

    FY 1Q 2011 Supplemental Earnings Information 35 Fiber to the Tower

  36. Slide 36: FTT Sites/Customer Metrics

    1Bandwidth / Site excludes Dark Fiber Sites FTT Sites/Customer Metrics FTT Sites and Customer Metrics 856 913 1,045 1,346 487 552 564 872 1,343 1,465 1,609 2,218 — 500 1,000 1,500 2,000 2,500 Dec-09 Mar-10 Jun-10 Sep-10 In Service Under Construction 19 23 27 0 5 10 15 20 25 30 Dec-09 Mar-10 Jun-10 S

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

    $1.2 $1.2 $1.3 $1.3 Towers Sites MRR Mbs Customers/ Site = 1.5 Customers/ Site = 1.6 Not available Revenue/Tower Revenue/Site Total FTT sites Customers/ Site = 1.5 % of Zayo Group’s Wireless Carrier MRR1 34% 38% 41% 0% 10% 20% 30% 40% 50% Mar-10 Jun-10 Sep-10 Fiber to the Tower (FTT) Fiber to the To

  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 38 FY 1Q 2011 Suppl

  39. Slide 39: Financial Data by Business Unit

    FY 1Q 2011 Supplemental Earnings Information 39 Financial Data by Business Unit

  40. Slide 40: Zayo Bandwidth Financial Data

    Zayo Bandwidth Financial Data 40 Financial Data1The three months ended September 30, 2010 amounts include the transfer of $1.4 Revenue and $1.1 EBITDA from Zayo Bandwidth to Zayo Fiber Solutions in conjunction with the launch of Zayo Fiber Solutions (“ZFS”) on July 1, 2010. Excluding the effect of t

  41. Slide 41: ZEN Financial Data

    ZEN Financial Data 41 FY 1Q 2011 Supplemental Earnings Information1The three months ended September 30, 2010 amounts include the transfer of $0.7M Revenue and $0.3M EBITDA from Zayo Enterprise Networks to Zayo Fiber Solutions, (“ZFS”) in conjunction with the launch of ZFS on July 1, 2010 ($ in milli

  42. Slide 42: zColo Financial Data

    zColo Financial Data FY 1Q 2011 Supplemental Earnings Information 42 Financial Data($ in millions)March 31,June 30,September 30,201020102010Revenue$6.9 $7.1 $7.2 Annualized revenue growth11%5%Gross profit3.6 3.7 3.6 Gross profit %52%52%50%Operating income/(loss)$1.0 $1.3 $1.0 Adjusted EBITDA$2.4 $2.

  43. Slide 43: ZFS Financial Data

    ZFS Financial Data FY 1Q 2011 Supplemental Earnings Information43 Financial Data($ in millions)June 30,September 30,20102010Revenue$ — $7.5 Annualized revenue growth-Gross profit-7.4 Gross profit %-98%Operating income/(loss)-$2.0 Adjusted EBITDA-$4.3 Purchases of property and equipment-1.5 Unlevered

  44. Slide 44: Historical Financial Data & Reconciliations

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

  45. Slide 45: Consolidated Historical Financial Data

    Consolidated Historical Financial Data 45 FY 1Q 2011 Supplemental Earnings Information($ in millions)Fiscal Year 2009Fiscal Year 2011September 30,December 31,March 31,June 30,September 30,Total2009200920102010Total2010Revenue$150.8 $45.5 $58.2 $58.9 $61.4 $224.0 $68.6 Annualized revenue growth50%112

  46. Slide 46: Consolidated Historical Reconciliations

    Consolidated Historical Reconciliations 46 FY 1Q 2011 Supplemental Earnings Information($ in millions)Fiscal Year 2009Fiscal Year 2011September 30,December 31,March 31,June 30,September 30,Total2009200920102010Total2010Earnings/(loss) from continuing operations($9.3)$0.1 $2.9 ($11.4)$5.4 ($3.0)($0.3

  47. Slide 47: Financial Data Reconciliation

    47 FY 1Q 2011 Supplemental Earnings Information Financial DataReconciliationZayo BandwidthZayo Enterprise NetworkszColoZFSCorporate / Interco EliminationZayo GroupEarnings/(loss) from continuing operations$8.5 $0.0 $0.9 $2.0 ($11.7)($0.3)Depreciation and amortization8.2 1.0 1.3 1.9 0.0 12.4 Interest

Zayo Group — Q1 FY2011 Earnings Presentation on 6ix