Zayo — FY 3Q 2011 Earnings Presentation
48 slides from Zayo's earnings presentation, May 13, 2011
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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% -
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
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
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
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
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
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
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
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
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
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
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-
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 $
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
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
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
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
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,
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
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
Slide 40: Financial Data by Business Unit
FY 3Q 2011 Supplemental Earnings Information 40 Financial Data by Business Unit
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
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
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
Slide 44: Historical Financial Data & Reconciliations
FY 3Q 2011 Supplemental Earnings Information 44 HistoricalFinancial Data & Reconciliations
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
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
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
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