Zayo — Q2 FY2012 Earnings Presentation
50 slides from Zayo's earnings presentation, Feb 14, 2012
Slide 1: Fiscal Year 2Q 2012 Supplemental Earnings Information
Privileged and Confidential 1 Fiscal Year 2Q 2012 Supplemental Earnings Information
Slide 2: Forward-Looking Statements
Forward-Looking Statements 2 FY 2Q 2012 Supplemental Earnings Information Information contained in this supplemental presentation that is not historical by nature constitutes "forward-looking statements" which can be identified by the use of forward-looking terminology such as "believes," "expects,"
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 Adjusted EBITDA a
Slide 4: Presentation of Certain Consolidated Pro-forma Financial Data
Presentation of Certain Consolidated Pro-forma Financial Data 4 FY 2Q 2012 Supplemental Earnings Information Acquisitions have been, and are expected to continue to be, a component of the Company's strategy. In this Supplemental Earnings Information under "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: 360networks Acquisition
360networks Acquisition 6 FY 2Q 2012 Supplemental Earnings Information 360networks Statistics On December 1, 2011, Zayo completed the acquisition of 360networks Holdings (USA) Inc. ("360networks") for a purchase price of $345.0 million. The net cash consideration paid was $318.0 million after adjust
Slide 7: MarquisNet Acquisition
MarquisNet Acquisition 7 FY 2Q 2012 Supplemental Earnings Information MarquisNet Statistics On December 31, 2011, the Company acquired substantially all of the net assets of MarquisNet in an asset purchase agreement for approximately $15.9 million, subject to post-closing adjustments. The acquisitio
Slide 8: Consolidated Financial Data
Consolidated Financial Data 8 FY 2Q 2012 Supplemental Earnings Information Financial Data 1 The three months ended December 31, 2010 amounts include the operating results of the October 1, 2011 AFS acquisition. Adjusting for the effect of the transaction as if it had occurred on April 1, 2010, the a
Slide 9: Consolidated Invested Capital Ratio
Consolidated Invested Capital Ratio 9 FY 2Q 2012 Supplemental Earnings Information Invested Capital
Slide 10: Segment Financial Data
Segment Financial Data 10 FY 2Q 2012 Supplemental Earnings Information Segment Data
Slide 11: Invested Capital Ratio by Business Unit
Invested Capital Ratio by Business Unit 11 FY 2Q 2012 Supplemental Earnings Information Invested Capital
Slide 12: Stratification of Revenue
Stratification of Revenue 12 (CHART) (CHART) (CHART) millions millions millions millions FY 2Q 2012 Supplemental Earnings Information MRR and MAR on the Last Day of the Quarter 1 (CHART) MRR on the last day of the quarter MAR of the last day of the quarter millions Revenue Stratification (CHART) 1 O
Slide 13: Stratification of Adjusted EBITDA
(CHART) Stratification of Adjusted EBITDA 13 millions FY 2Q 2012 Supplemental Earnings Information millions Adjusted EBITDA Associated with Other Revenue Stratification of Adjusted EBITDA Adjusted EBITDA Stratification Adjusted EBITDA associated with Credits and Adjustments Adjusted EBITDA associate
Slide 14: Gross New Sales (Bookings)
(CHART) (CHART) (CHART) Gross New Sales (Bookings) 14 FY 2Q 2012 Supplemental Earnings Information Gross New Sales (Bookings) Gross New Sales (Bookings) Estimated Gross Profit and Gross Profit Percentage on Gross New Sales (Bookings) Estimated Capital Expenditures associated with Gross New Sales (Bo
Slide 15: Gross New Sales (Bookings) - IRU, Installation and Other
(CHART) Gross New Sales (Bookings) IRU, Installation and Other 15 FY 2Q 2012 Supplemental Earnings Information Gross New Sales (Bookings) - IRU, Installation and Other Gross New Sales (Bookings) - IRU, Installation and Other Estimated Gross Profit and Gross Profit Percentage on Gross New Sales (Book
Slide 16: Stratification of Gross New Sales (Bookings)
Stratification of Gross New Sales (Bookings) 16 FY 2Q 2012 Supplemental Earnings Information Gross New Sales (Bookings) Stratification 1 For the quarter ended September 30, 2011, network capacity estimated capital expenditures include 165 Halsey power upgrades and 60 Hudson generator upgrade 2 Specu
Slide 17: Stratification of Speculative Projects
Stratification of Speculative Projects FY 2Q 2012 Supplemental Earnings Information 17 Speculative Capital Expenditure Commitments 1 The estimated Infrastructure Capital and Success 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 2Q 2012 Supplemental Earnings Information 18 Quota Bearing Headcount (CHART) (CHART) Quota Bearing Headcount Monthly Average Gross New Sales (Bookings) per QBHC thousands Headcount Gross New Sales (Bookings) MRR and MAR
Slide 19: Installation and Churn Processed
(CHART) Installation and Churn Processed 19 FY 2Q 2012 Supplemental Earnings Information Installation and Churn Processed (CHART) (CHART) (CHART) Gross Installations Churn Processed Net Installations Gross Profit from Net Installations thousands thousands thousands thousands MRR and MAR MRR and MAR
Slide 20: Breakdown of Installations and Churn Processed
Breakdown of Installations and Churn Processed Installation and Churn Processed 20 FY 2Q 2012 Supplemental Earnings Information Gross Installations thousands Churn Processed thousands MRR and MAR MRR and MAR (CHART) Churn = (CHART)
Slide 21: Price Changes and Renewals
(CHART) Price Changes and Renewals (CHART) (CHART) Price Increases Net Contract Value Associated with Price Changes and Renewals Price Decreases thousands millions thousands MRR Contract Value MRR (CHART) Price Changes Net of Price Increases and Price Decreases thousands MRR 21 FY 2Q 2012 Supplement
Slide 22: Upgrades
Upgrades Upgrades (CHART) (CHART) (CHART) (CHART) Gross Installations Associated with Upgrades Average % Increase in Monthly Recurring Revenue Associated with Upgrades thousands thousands thousands Churn Processed Associated with Upgrades Net Installations Associated with Upgrades 22 FY 2Q 2012 Supp
Slide 23: Service Activation and Churn Pipeline
(CHART) Service Activation and Churn Pipeline 23 FY 2Q 2012 Supplemental Earnings Information Service Activation and Churn Pipeline (CHART) (CHART) Service Activation Pipeline Estimated Timing of Service Activation Pipeline Churn Pipeline Net Installation Pipeline millions millions millions MRR and
Slide 24: Revenue Under Contract
Revenue Under Contract 24 FY 2Q 2012 Supplemental Earnings Information Revenue Under Contract Revenue Under Contract millions (CHART) Average Remaining Contract Term (CHART) Months
Slide 25: Employee Data
Employee Data FY 2Q 2012 Supplemental Earnings Information 25 Employee Data (CHART) (CHART) (CHART) (CHART) Number of Employees Employee Related SG&A thousands millions thousands Headcount Financial Statement Revenue SG&A SG&A % of Revenue = Annualized Revenue per Employee Annualized Employee Relate
Slide 26: Customer Verticals and Product Mix
Customer Verticals and Product Mix 26 FY 2Q 2012 Supplemental Earnings Information Customer Verticals and Product Mix
Slide 27: Customer Concentration
(CHART) (CHART) (CHART) (CHART) Customer Concentration 27 FY 2Q 2012 Supplemental Earnings Information Customer Concentration % of MRR Customer #2 Customer #3 Top 20 Top 10 Top 5
Slide 28: Customer and Unit Metrics
Customer and Unit Metrics Customer and Unit1 Metrics (CHART) (CHART) (CHART) Number of Customers Number of Units (MRR and MAR)/Unit 28 FY 2Q 2012 Supplemental Earnings Information Customers MRR and MAR MRR and MAR Units (CHART) (MRR and MAR)/Customer thousands thousands thousands 1 Units and (MRR an
Slide 29: Pricing Trends - Waves
Pricing Trends1 - Waves FY 2Q 2012 Supplemental Earnings Information 29 (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) thousands MRR MRR thousands (CHART) 1 Pricing trends based on ZB only
Slide 30: Pricing Trends - Ethernet
Pricing Trends1 - Ethernet FY 2Q 2012 Supplemental Earnings Information 30 (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) (CHART) thousands MRR MRR thousands GigE Full Rate (>1000Mb) - MRR/Unit Fractional GigE (101-1000Mb) - MR
Slide 31: Pricing Trends - OC3, OC12, and OC48
Pricing Trends1 - OC3, OC12, and OC48 FY 2Q 2012 Supplemental Earnings Information 31 (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) thousands MRR MRR thousands 1 Pricing trends based on ZB only 2 As part of organizational chan
Slide 32: Pricing Trends - DS1 and DS3
Pricing Trends1 - DS1 and DS3 FY 2Q 2012 Supplemental Earnings Information 32 (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) (CHART) thousands MRR MRR thousands 1 Pricing trends based on ZB only
Slide 33: Purchases of Property and Equipment
millions Purchases of Property and Equipment Purchases of Property and Equipment by Driver 1 (CHART) 33 FY 2Q 2012 Supplemental Earnings Information Capital Expenditures Purchases of Property and Equipment (CHART) Maintenance, Integration and Other (CHART) Growth Capital Expenditures Capital Expendi
Slide 34: Network Metrics
Network Metrics 34 FY 2Q 2012 Supplemental Earnings Information Network Metrics (CHART) (CHART) Fiber Network - Route Miles Fiber Network - Fiber Miles Number of On-net Buildings Number of Markets Route Miles Fiber Miles On-Net Buildings # of Markets (CHART) (CHART) States = 27 + DC States = 31 + DC
Slide 35: Network Metrics - On-Net Buildings
Network Metrics 35 FY 2Q 2012 Supplemental Earnings Information On-Net Buildings 1 In the three months ended June 30, 2011, decreases in building counts by category are due to reclassification of building types, not a result of buildings being physically removed from the Zayo network
Slide 36: Network Metrics - Colocation Cabinet Utilization
(CHART) (CHART) Network Metrics 36 FY 2Q 2012 Supplemental Earnings Information Colocation Cabinet Utilization Billable Colocation Square Feet Colocation Cabinet Equivalents Utilized Colocation Cabinet Equivalents Square Feet Colocation Cabinet Equivalents Colocation Cabinet Equivalents Utilization
Slide 37: Fiber to the Tower
FY 2Q 2012 Supplemental Earnings Information 37 Fiber to the Tower
Slide 38: Fiber to the Tower (FTT)
(CHART) (CHART) Fiber to the Tower (FTT) Fiber to the Tower (CHART) (CHART) Total FTT Towers Bandwidth/Tenant (Mbs)1 Revenue/Tower & Revenue/Tenant thousands (CHART) 38 FY 2Q 2012 Supplemental Earnings Information Towers Tenants MRR and MAR Mbs Revenue/Tower Revenue/Tenant Total FTT Tenants Tenants/
Slide 39: Fiber to the Tower (FTT) MRR and Capital Expenditures
(CHART) (CHART) % of MRR and MAR % of Zayo Group's Wireless Carrier MRR and MAR Fiber to the Tower (FTT) Fiber to the Tower (CHART) (CHART) FTT MRR and MAR FTT Cumulative Capital Expenditures FTT Product Mix millions millions 39 FY 2Q 2012 Supplemental Earnings Information % of MRR and MAR MRR and M
Slide 40: FTT Markets
FTT Markets FTT Markets Mid-Atlantic includes Washington D.C., Maryland, New Jersey, Virginia, West Virginia, and Pennsylvania North Central includes Indiana, Minnesota, Kentucky, and Ohio Pacific Northwest includes Idaho and Washington Southeast includes Tennessee and Georgia Southwest includes Ari
Slide 41: Financial Data by Business Unit
FY 2Q 2012 Supplemental Earnings Information 41 Financial Data by Business Unit
Slide 42: Zayo Bandwidth Financial Data
Zayo Bandwidth Financial Data 42 Financial Data FY 2Q 2012 Supplemental Earnings Information 1 The financial data for the three months ended December 31, 2011 includes one month of operating results of the acquired 360networks business
Slide 43: Zayo Fiber Solutions Financial Data
Zayo Fiber Solutions Financial Data FY 2Q 2012 Supplemental Earnings Information 43 Financial Data 1 The financial data for the three months ended December 31, 2011 includes one month of operating results of the acquired 360networks business
Slide 44: zColo Financial Data
zColo Financial Data FY 2Q 2012 Supplemental Earnings Information 44 Financial Data 1 Total Invested Capital as of December 31, 2011 includes $15.5 million of additional capital invested in zColo in conjunction with the MarquisNet acquisition. As the acquisition occurred on December 31, 2011, the An
Slide 45: Historical Financial Data & Reconciliations
FY 2Q 2012 Supplemental Earnings Information 45 Historical Financial Data & Reconciliations
Slide 46: Consolidated Historical Financial Data
Consolidated Historical Financial Data 46 FY 2Q 2012 Supplemental Earnings Information Consolidated Financial Data
Slide 47: Consolidated Historical Reconciliations
Consolidated Historical Reconciliations 47 FY 2Q 2012 Supplemental Earnings Information Consolidated Financial Data
Slide 48: Segment Data Reconciliation
48 FY 2Q 2012 Supplemental Earnings Information Segment Data Reconciliation Segment Data Reconciliation Note: A reconciliation of previous quarters segment information can be found on our historical earnings supplements found on our website at http://www.zayo.com/financial-earnings-release
Slide 49: Pro-forma Growth Reconciliation (AFS)
49 FY 2Q 2012 Supplemental Earnings Information Pro-forma Growth Reconciliation (AFS) Pro-forma Growth Reconciliation 1 Revenue 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, f
Slide 50: Pro-forma Growth Reconciliation (360networks)
50 FY 2Q 2012 Supplemental Earnings Information Pro-forma Growth Reconciliation (360networks) Pro-forma Growth Reconciliation 1 The 360networks Corporation historical results include the operating results of VoIP 360 Inc., and other non-operating legal subsidiaries of 360networks Corporation which w