Zayo — Q2 FY2011 Earnings Presentation
52 slides from Zayo's earnings presentation, Feb 11, 2011
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
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
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 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
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: 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
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
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
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
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
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
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
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
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
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
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
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
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
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
Slide 20: Quota Bearing Headcount (QBHC)
Quota Bearing Headcount (QBHC) FY 2Q 2011 Supplemental Earnings Information 20 Quota Bearing Headcount
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
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)
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
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
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
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
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
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
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
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
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
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
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
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 $
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
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.
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
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
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
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
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
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
Slide 43: Financial Data by Business Unit
FY 2Q 2011 Supplemental Earnings Information 43 Financial Data by Business Unit
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
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
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
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
Slide 48: Historical Financial Data & Reconciliations
FY 2Q 2011 Supplemental Earnings Information 48 HistoricalFinancial Data & Reconciliations
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
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)$
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
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