Zayo — Q1 FY2012 Earnings Presentation
50 slides from Zayo's earnings presentation, Nov 10, 2011
Slide 1: Fiscal Year 1Q 2012 Supplemental Earnings Information
FY 2Q 2011 Supplemental Earnings Information 1 Fiscal Year 1Q 2012 Supplemental Earnings Information FY 1Q 2012 Supplemental Earnings Information
Slide 2: Forward-Looking Statements
Forward-Looking Statements 2 FY 1Q 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 1Q 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: Summary Structure Reporting Company Restructuring
Summary Structure 6 FY 1Q 2012 Supplemental Earnings Information Reporting Company Restructuring The chart below depicts the Company's current organizational structure1 (effective as of April 1, 2011), and includes the following restructuring events: January 1, 2011 restructuring of the business uni
Slide 7: Reporting Impacts of Restructuring
Reporting Impacts of Restructuring The spin-off and associated restructuring of our operating segments (as more fully described in our Annual Report filed on Form 10-K with the SEC) impact the supplemental reporting and comparability of prior periods January 1, 2011 restructuring of the operating se
Slide 8: Acquisition Statistics
360 Acquisition 8 FY 1Q 2012 Supplemental Earnings Information 360 Statistics On October 7, Zayo announced an agreement to acquire 360networks Holdings (USA) Inc.; the transaction is expected to close in December 2011. Upon close, Zayo will spin-off 360networks' VOIP operations. As such, the revenue
Slide 9: Consolidated Financial Data
Consolidated Financial Data 9 FY 1Q 2012 Supplemental Earnings Information Financial Data 1 The three months ended September 30, 2010 amounts include the operating results of the July 1, 2010, AGL acquisition. The three months ended December 31, 2010 amounts include the operating results of both the
Slide 10: Consolidated Invested Capital Ratio
Consolidated Invested Capital Ratio 10 FY 1Q 2012 Supplemental Earnings Information Invested Capital 1 The increase in member's interest during the three months ended September 30, 2011 is a result of the Company's use of $0.7 million of Zayo Group Holdings deferred tax assets which was settled as a
Slide 11: Segment Financial Data
Segment Financial Data 11 FY 1Q 2012 Supplemental Earnings Information Segment Data
Slide 12: Invested Capital Ratio by Business Unit
Invested Capital Ratio by Business Unit 12 FY 1Q 2012 Supplemental Earnings Information Invested Capital
Slide 13: Stratification of Revenue
Stratification of Revenue 13 (CHART) (CHART) (CHART) (CHART) millions millions millions millions FY 1Q 2012 Supplemental Earnings Information MRR and MAR on the Last Day of the Quarter 1 (CHART) 1 Other revenue for the three months ended September 30, 2011 included $0.7 million of other revenue asso
Slide 14: Stratification of Adjusted EBITDA
(CHART) (CHART) Stratification of Adjusted EBITDA 14 millions FY 1Q 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 a
Slide 15: Gross New Sales (Bookings)
(CHART) (CHART) (CHART) Gross New Sales (Bookings) 15 FY 1Q 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 16: Gross New Sales (Bookings) - IRU, Installation and Other
(CHART) Gross New Sales (Bookings) IRU, Installation and Other 16 FY 1Q 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 17: Stratification of Gross New Sales (Bookings)
Stratification of Gross New Sales (Bookings) 17 FY 1Q 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
Slide 18: Stratification of Speculative Projects
Stratification of Speculative Projects FY 1Q 2012 Supplemental Earnings Information 18 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 19: Quota Bearing Headcount (QBHC)
Quota Bearing Headcount (QBHC) FY 1Q 2012 Supplemental Earnings Information 19 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 20: Installation and Churn Processed
(CHART) Installation and Churn Processed 20 FY 1Q 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 21: Breakdown of Installations and Churn Processed
Breakdown of Installations and Churn Processed Installation and Churn Processed 21 FY 1Q 2012 Supplemental Earnings Information Gross Installations thousands Churn Processed thousands MRR and MAR MRR and MAR (CHART) Churn = (CHART)
Slide 22: 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 22 FY 1Q 2012 Supplement
Slide 23: 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 23 FY 1Q 2012 Supp
Slide 24: Service Activation and Churn Pipeline
(CHART) Service Activation and Churn Pipeline 24 FY 1Q 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 25: Revenue Under Contract
Revenue Under Contract 25 FY 1Q 2012 Supplemental Earnings Information Revenue Under Contract Revenue Under Contract millions (CHART) Average Remaining Contract Term (CHART) n/a Months
Slide 26: Employee Data
Employee Data FY 1Q 2012 Supplemental Earnings Information 26 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 27: Customer Verticals and Product Mix
Customer Verticals and Product Mix 27 FY 1Q 2012 Supplemental Earnings Information Customer Verticals and Product Mix
Slide 28: Customer Concentration
(CHART) (CHART) (CHART) (CHART) Customer Concentration 28 FY 1Q 2012 Supplemental Earnings Information Customer Concentration % of MRR Customer #2 Customer #3 Top 20 Top 10 Top 5
Slide 29: 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 29 FY 1Q 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 30: Pricing Trends - Waves
Pricing Trends1 - Waves FY 1Q 2012 Supplemental Earnings Information 30 (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) thousands MRR MRR thousands (CHART) 1 Pricing trends based on ZB only
Slide 31: Pricing Trends - Ethernet
Pricing Trends1 - Ethernet FY 1Q 2012 Supplemental Earnings Information 31 (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 32: Pricing Trends - OC3, OC12, and OC48
Pricing Trends1 - OC3, OC12, and OC48 FY 1Q 2012 Supplemental Earnings Information 32 (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 33: Pricing Trends - DS1 and DS3
Pricing Trends1 - DS1 and DS3 FY 1Q 2012 Supplemental Earnings Information 33 (CHART) (CHART) (CHART) thousands MRR MRR thousands (CHART) (CHART) (CHART) thousands MRR MRR thousands 1 Pricing trends based on ZB only
Slide 34: Purchases of Property and Equipment
millions Purchases of Property and Equipment Purchases of Property and Equipment by Driver 1 (CHART) 34 FY 1Q 2012 Supplemental Earnings Information Capital Expenditures Purchases of Property and Equipment (CHART) Maintenance, Integration and Other (CHART) Growth Capital Expenditures Capital Expendi
Slide 35: Network Metrics
Network Metrics 35 FY 1Q 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 = 27 + DC
Slide 36: Network Metrics: On-Net Buildings
Network Metrics 36 FY 1Q 2012 Supplemental Earnings Information On-Net Buildings 1 In the three months ended June 30, 2011, decreases in building counts by category due to reclassification of building types, not a result of buildings being physically removed from the Zayo network
Slide 37: Network Metrics: Colocation Cabinet Utilization
Network Metrics 37 FY 1Q 2012 Supplemental Earnings Information Colocation Cabinet Utilization (CHART) (CHART) (CHART) Billable Colocation Square Feet Colocation Cabinet Equivalents Utilized Colocation Cabinet Equivalents Square Feet Colocation Cabinet Equivalents Colocation Cabinet Equivalents Util
Slide 38: Fiber to the Tower
FY 1Q 2012 Supplemental Earnings Information 38 Fiber to the Tower
Slide 39: 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 thousands (CHART) 39 FY 1Q 2012 Supplemental Earnings Information Towers Tenants MRR and MAR Mbs Revenue/Tower Revenue/Tenant Total FTT Tenant
Slide 40: 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 40 FY 1Q 2012 Supplemental Earnings Information % of MRR and MAR MRR and M
Slide 41: 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 Las
Slide 42: Financial Data by Business Unit
FY 1Q 2012 Supplemental Earnings Information 42 Financial Data by Business Unit
Slide 43: Zayo Bandwidth Financial Data
Zayo Bandwidth Financial Data 43 Financial Data FY 1Q 2012 Supplemental Earnings Information 1 The financial data for the three months ended September 30, 2010 include the transfer of $1.4 million revenue and $1.1 million Adjusted EBITDA from ZB to ZFS in conjunction with the launch of ZFS on July 1
Slide 44: Zayo Fiber Solutions Financial Data
Zayo Fiber Solutions Financial Data FY 1Q 2012 Supplemental Earnings Information 44 Financial Data
Slide 45: zColo Financial Data
zColo Financial Data FY 1Q 2012 Supplemental Earnings Information 45 Financial Data 1 In connection with the restructuring of the Company's operating segments on January 1, 2011, ZB transferred 5 colocation sites to zColo. This transfer resulted in an increase of $1.1 million to zColo's revenue (net
Slide 46: Historical Financial Data & Reconciliations
FY 1Q 2012 Supplemental Earnings Information 46 Historical Financial Data & Reconciliations
Slide 47: Consolidated Historical Financial Data
Consolidated Historical Financial Data 47 FY 1Q 2012 Supplemental Earnings Information Consolidated Financial Data
Slide 48: Consolidated Historical Reconciliations
Consolidated Historical Reconciliations 48 FY 1Q 2012 Supplemental Earnings Information Consolidated Financial Data
Slide 49: Segment Data Reconciliation
49 FY 1Q 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 50: Pro-forma Growth Reconciliation
50 FY 1Q 2012 Supplemental Earnings Information Pro-forma Growth Reconciliation 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, fixed a