Zayo — Q3 FY2012 Earnings Presentation
54 slides from Zayo's earnings presentation, May 9, 2012
Slide 1: Supplemental Earnings Information
\ Supplemental Earnings Informatiot
Slide 2: Forward-Looking Statements
Forward-Looking Statements 2 FY 3Q 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 3Q 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: Recent 8-K Filings
Recent 8-K Filings Change in the Company’s Independent Registered Public Accounting Firm On May 3rd, 2012, the Company made a filing on Form 8-K with the Securities and Exchange Commission (“SEC”) which announced that the Company has dismissed Grant Thornton LLP as the Company’s independent register
Slide 7: Restatement of Historical Financial Information
Restatement of Historical Financial Information Impact of restatement on the fiscal 2010 Statement of Operations: FY 3Q 2012 Supplemental Earnings Information 7 Restatement Impact (in thousands) Year Ended June 30, 2010 Previously Correction Restated Reported Revenue $ 199,330 $—$ 199,330 Operating
Slide 8: Restatement of Historical Financial Information
Restatement of Historical Financial Information The misstatement discussed on the previous slide will have the following impact on the fiscal 2010 Balance Sheet: FY 3Q 2012 Supplemental Earnings Information 8 1 The adjustments to the balance sheet in fiscal 2010 will flow through each of the quarter
Slide 9: Arialink Acquisition
Arialink Acquisition 9 FY 3Q 2012 Supplemental Earnings Information Arialink Statistics On May 1, 2012, the Company acquired substantially all of the net assets of Arialink for approximately $18.0 million, subject to post-closing adjustments. The acquisition was funded with cash on hand. The acquire
Slide 10: AboveNet Acquisition
AboveNet Acquisition 10 FY 3Q 2012 Supplemental Earnings Information AboveNet Statistics On March 18, 2012, the Company entered into an Agreement and Plan of Merger with AboveNet Inc. (“AboveNet”), a provider of high-bandwidth connectivity solutions Upon the close of the transaction contemplated by
Slide 11: Consolidated Financial Data
Consolidated Financial Data 11 FY 3Q 2012 Supplemental Earnings Information Financial Data 1 The three months ended December 31, 2011 include one month of operating results of the December 1, 2011 360networks acquisition and the three months ended March 31, 2012 include three months of operating res
Slide 12: Consolidated Invested Capital Ratio
Consolidated Invested Capital Ratio 12 FY 3Q 2012 Supplemental Earnings Information Invested Capital
Slide 13: Segment Financial Data
Segment Financial Data 13 FY 3Q 2012 Supplemental Earnings Information Segment Data
Slide 14: Invested Capital Ratio by Business Unit
Invested Capital Ratio by Business Unit 14 FY 3Q 2012 Supplemental Earnings Information Invested Capital
Slide 15: Stratification of Revenue
Stratification of Revenue 15 millions millions millions millions MRR and MAR on the Last Day of the Quarter MRR on the last day of the quarter MAR of the last day of the quarter millions Revenue Stratification FY 3Q 2012 Supplemental Earnings Information
Slide 16: Stratification of Adjusted EBITDA
Stratification of Adjusted EBITDA 16 millions FY 3Q 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 associated with T
Slide 17: Gross New Sales (Bookings)
Gross New Sales (Bookings) 17 FY 3Q 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 and Upfront Expenditures associated with Gross New Sales (Bookings) less
Slide 18: Estimated Capital and Upfront Expenditures and Gross New Sales
18 FY 3Q 2012 Supplemental Earnings Information Estimated Capital and Upfront Expenditures and Gross New Sales (Bookings) IRU and Upfront Charges Contract Value = Gross New Sales (Bookings) – IRU and Upfront Charges Gross New Sales (Bookings) from IRUs Gross New Sales Upfront Charges Gross New Sales
Slide 19: Stratification of Gross New Sales (Bookings)
Stratification of Gross New Sales (Bookings) 19 FY 3Q 2012 Supplemental Earnings Information Gross New Sales (Bookings) Stratification 1 For the three months ended September 30, 2011, network capacity estimated capital expenditures include 165 Halsey power upgrades and 60 Hudson generator upgrade 2
Slide 20: Stratification of Speculative Projects
Stratification of Speculative Projects FY 3Q 2012 Supplemental Earnings Information 20 Speculative Capital Expenditure Commitments 1 Speculative capital for the three months ended June 30, 2011 includes $2.9 million success based capital for fiber associated with the GigE PAC government stimulus awa
Slide 21: Quota Bearing Headcount (QBHC)
Quota Bearing Headcount (QBHC) FY 3Q 2012 Supplemental Earnings Information 21 Quota Bearing Headcount Quota Bearing Headcount Monthly Average Gross New Sales (Bookings) per QBHC thousands Headcount Gross New Sales (Bookings) MRR and MAR
Slide 22: Installation and Churn Processed
Installation and Churn Processed 22 FY 3Q 2012 Supplemental Earnings Information Installation and Churn Processed Gross Installations Churn Processed Net Installations Gross Profit from Net Installations thousands thousands thousands thousands MRR and MAR MRR and MAR MRR and MAR Monthly Gross Profit
Slide 23: Breakdown of Installations and Churn
Breakdown of Installations and Churn Processed Installation and Churn Processed 23 FY 3Q 2012 Supplemental Earnings Information Gross Installations thousands Churn Processed thousands MRR and MAR MRR and MAR Churn =
Slide 24: Price Changes and Renewals
Price Changes and Renewals Price Increases Net Contract Value Associated with Price Changes and Renewals Price Decreases thousands millions thousands MRR Contract Value MRR Price Changes Net of Price Increases and Price Decreases thousands MRR 24 FY 3Q 2012 Supplemental Earnings Information Price in
Slide 25: Upgrades
Upgrades Upgrades 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 25 FY 3Q 2012 Supplemental Earnings Information MR
Slide 26: Service Activation and Churn Pipeline
Service Activation and Churn Pipeline 26 FY 3Q 2012 Supplemental Earnings Information Service Activation and Churn Pipeline Service Activation Pipeline Estimated Timing of Service Activation Pipeline Churn Pipeline Net Installation Pipeline millions millions millions MRR and MAR MRR MRR and MAR mill
Slide 27: Revenue Under Contract
Revenue Under Contract 27 FY 3Q 2012 Supplemental Earnings Information Revenue Under Contract Revenue Under Contract millions Average Remaining Contract Term Months
Slide 28: Employee Data
Employee Data FY 3Q 2012 Supplemental Earnings Information 28 Employee Data 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 Related SG&A per Employee
Slide 29: Customer Verticals and Product Mix
Customer Verticals and Product Mix 29 FY 3Q 2012 Supplemental Earnings Information Customer Verticals and Product Mix
Slide 30: Customer Concentration
Customer Concentration 30 FY 3Q 2012 Supplemental Earnings Information Customer Concentration % of MRR Customer #1 Customer #2 Customer #3 Top 20 Top 10 Top 5
Slide 31: Customer and Unit Metrics
Customer and Unit Metrics Customer and Unit1 Metrics Number of Customers Number of Units (MRR and MAR)/Unit 31 FY 3Q 2012 Supplemental Earnings Information Customers MRR and MAR MRR and MAR Units (MRR and MAR)/Customer thousands thousands thousands 1 Units and (MRR and MAR)/Unit exclude Fiber Miles
Slide 32: Pricing Trends – Waves
Pricing Trends1 – Waves FY 3Q 2012 Supplemental Earnings Information 32 thousands MRR MRR thousands thousands MRR MRR thousands 1 Pricing trends based on ZB only
Slide 33: Pricing Trends – Ethernet
Pricing Trends1 – Ethernet FY 3Q 2012 Supplemental Earnings Information 33 thousands MRR MRR thousands thousands MRR MRR thousands thousands MRR MRR thousands GigE Full Rate (>1000Mb) – MRR/Unit Fractional GigE (101-1000Mb) – MRR/Unit 1 Pricing trends based on ZB only
Slide 34: Pricing Trends – OC3, OC12, and OC48
Pricing Trends1 – OC3, OC12, and OC48 FY 3Q 2012 Supplemental Earnings Information 34 thousands MRR MRR thousands thousands MRR MRR thousands thousands MRR MRR thousands 1 Pricing trends based on ZB only
Slide 35: Pricing Trends – DS1 and DS3
Pricing Trends1 – DS1 and DS3 FY 3Q 2012 Supplemental Earnings Information 35 thousands MRR MRR thousands thousands MRR MRR thousands 1 Pricing trends based on ZB only
Slide 36: Purchases of Property and Equipment
millions Purchases of Property and Equipment Purchases of Property and Equipment by Driver 1 36 FY 3Q 2012 Supplemental Earnings Information Capital Expenditures Purchases of Property and Equipment Maintenance, Integration and Other Growth Capital Expenditures Capital Expenditures Capital Expenditur
Slide 37: Network Metrics
Network Metrics 37 FY 3Q 2012 Supplemental Earnings Information Network Metrics 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 States = 31 + DC States = 31 + DC States = 31 + DC States = 42 + DC S
Slide 38: Network Metrics: On-Net Buildings
Network Metrics 38 FY 3Q 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 39: Network Metrics: Colocation Cabinet Utilization
Network Metrics 39 FY 3Q 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 40: Fiber to the Tower
FY 3Q 2012 Supplemental Earnings Information 40 Fiber to the Tower
Slide 41: Fiber to the Tower (FTT)
Fiber to the Tower (FTT) Fiber to the Tower Total FTT Towers Bandwidth/Tenant (Mbs)1 Revenue/Tower & Revenue/Tenant thousands 41 FY 3Q 2012 Supplemental Earnings Information Towers Tenants MRR and MAR Mbs Revenue/Tower Revenue/Tenant Total FTT Tenants Tenants/Tower = 1 Bandwidth/Tenant excludes Dark
Slide 42: Fiber to the Tower: MRR and MAR, Capex, Product Mix
% of MRR and MAR % of MRR and MAR % of Zayo Group’s Wireless Carrier MRR and MAR Fiber to the Tower (FTT) Fiber to the Tower FTT MRR and MAR FTT Cumulative Capital Expenditures FTT Product Mix millions millions 42 FY 3Q 2012 Supplemental Earnings Information MRR and MAR % of FTT MRR and MAR Capital
Slide 43: 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, Montana, and Washington Southeast includes Tennessee and Georgia Southwest in
Slide 44: Financial Data by Business Unit
FY 3Q 2012 Supplemental Earnings Information 44 Financial Data by Business Unit
Slide 45: Zayo Bandwidth Financial Data
Zayo Bandwidth Financial Data 45 Financial Data FY 3Q 2012 Supplemental Earnings Information 1 The three months ended December 31, 2011 include one month of operating results of the December 1, 2011 360networks acquisition. The Pro-forma annualized revenue growth and pro-forma annualized Adjusted EB
Slide 46: Zayo Fiber Solutions Financial Data
Zayo Fiber Solutions Financial Data FY 3Q 2012 Supplemental Earnings Information 46 Financial Data 1 1 1 The three months ended December 31, 2011 include one month of operating results of the December 1, 2011 360networks acquisition. The Pro-forma annualized revenue growth and pro-forma annualized A
Slide 47: zColo Financial Data
zColo Financial Data FY 3Q 2012 Supplemental Earnings Information 47 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 48: Historical Financial Data & Reconciliations
FY 3Q 2012 Supplemental Earnings Information 48 Historical Financial Data & Reconciliations
Slide 49: Consolidated Historical Financial Data
Consolidated Historical Financial Data 49 FY 3Q 2012 Supplemental Earnings Information Consolidated Financial Data
Slide 50: Consolidated Historical Reconciliations
Consolidated Historical Reconciliations 50 FY 3Q 2012 Supplemental Earnings Information Consolidated Financial Data
Slide 51: Segment Data Reconciliation: Net Earnings/(loss) to Adjusted EBITDA
51 FY 3Q 2012 Supplemental Earnings Information Segment Data Reconciliation: Net Earnings/(loss) to Adjusted EBITDA 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
Slide 52: Segment Data Reconciliation: Cash flows from operating activities to Adjusted EBITDA
Segment Data Reconciliation: Cash flows from operating activities to Adjusted EBITDA FY 2Q 2011 Supplemental Earnings Information 52 Segment Data Reconciliation
Slide 53: Pro-forma Growth Reconciliation (FY 2012 Q3)
53 FY 3Q 2012 Supplemental Earnings Information Pro-forma Growth Reconciliation (Supporting FY 2012 Q3 Pro-forma Growth) 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 360n
Slide 54: Pro-forma Growth Reconciliation (FY 2012 Q2)
54 FY 3Q 2012 Supplemental Earnings Information Pro-forma Growth Reconciliation (Supporting FY 2012 Q2 Pro-forma Growth) 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 360n