Zayo — FY2012 Q4 Earnings Presentation
59 slides from Zayo's earnings presentation, Sep 14, 2012
Slide 1: Fiscal Year 4Q 2012 Supplemental Earnings Information
Exhibit 99.2 1 Fiscal Year 4Q 2012 Supplemental Earnings Information Privileged and Confidential
Slide 2: Forward-Looking Statements
Forward-Looking statements” “anticipates” forward-looking expectations These customers acquisition Other on circumstances these factors risks forward-looking and of and which and or and AboveNet after attract uncertainties the statements beliefs risks Statements can negatives releasing new be that a
Slide 3: Non-GAAP Financial Measures
Non-GAAP before measures non-cash forecasting method analytical expenditures, not computation fashion. has limitations. In operating depreciation assess terms addition be reflect used used value considered interest, used Because capital items. of costs, tool, the throughout to of As Financial our cr
Slide 4: Presentation of Financial Data
Presentation Company’s Adjusted growth earnings revenue closed. to Historical 2012, EBITDA segments. entitled: the fair March In on growth “Zayo presentation growth EBITDA value making Reconciliations.” The astrategy. more of 31, pro-forma Bandwidth Certain rate of 2012, rates comparable such the gr
Slide 5: Notes on Operating Measures
Other analysts, evaluate items Company new approximation were Networks June the reclassifications estimates. sales activation full sale 30, not (bookings); reported Notes value and 2011. revised. is investors, occurred changed pipeline The equivalent Operating measure ofby measures When ofthe of(3)
Slide 6: Arialink Acquisition
Arialink $18.0 certain Holdings, months parent—Zayo price 2012 of quarterly million, managed ended Arialink, Acquisition the Company’s Group March subject operating services less6Holdings, 31, the to FYpost-closing results 2012 product value parent 4Q 2012 and ascribed on of 1offerings Route Arialin
Slide 7: AboveNet Acquisition
(“AboveNet”), acquired common Adjusted calculating AboveNet 100% stock EBITDA Acquisition 1the 2 Adjusted was aofpublicly the are converted outstanding based 7 EBITDA FY traded 4Q on into 2012 the company capital multiple, the historical Supplemental right stock listed to theoperating receive of ful
Slide 8: FiberGate Acquisition
FiberGate in which cash purchase June FiberGate, on 30, the hand 2012 accounting Company Purchase 1aquarterly Annualized privately Agreement acquired adjustments operating held revenue corporation, 100% 8 2FY results In and of4Q calculating the Adjusted 2012 ofincorporated outstanding FiberGate Supp
Slide 9: USCarrier Acquisition
USCarrier interests approximately at method, recognize June is divided closing 30, therefore in 2012. and 100% by Telecom Purchase USCarrier. the post-closing. 49% Financial of 51% the the Holdings of Agreement results of USCarrier the USCarrier the results equity In annualized of LLC the operations
Slide 10: New Indebtedness and Equity Financing
New aggregate facility on of were Company’s theequity the AboveNet Invested converted New (the financing principal existing Term “New Capital acquisition, into Loan Revolving in amount 257,548,148.92 credit which New Facility to facilities, Indebtedness of98,916,060.11 refinance Credit 10.125% on Ju
Slide 11: Pro-Forma Adjusted EBITDA
Pro-Forma for the threeAdjusted months ended EBITDA June FY30, 4Q2012 2012asSupplemental if the acquisitions Earnings of AboveNet, Information FiberGate, 11 Pro-Forma and Arialink Adjustedoccurred EBITDA on (FY AprilQ4 1, Annualized) 2012 The following table reflects the pro-forma results of Zayo Gr
Slide 12: ZG Acquisition History
12 ZG Acquisition OVS/ZEN spin off History1 Acquisition Average History age(closed of investment through (weighted Jun-12) 2 360 by size, purchase in years): price2.6 includes years 2.2 seller years liability 1 Companies assumeddenoted by Zayoby 2 FY * indicate 4Q 2012Purchase Supplemental Price was
Slide 13: Consolidated Financial Data
Consolidated December revenue acquisition growth 31, 1 1Financial 2011 and MarquisNet pro-forma Data 13annualized FY acquisition, 4Q 2012Adjusted and Supplemental theEBITDA three months Earnings growth ended Information haveJune been 30,calculated Financial 2012 include as Data if two these 1 The mo
Slide 14: Invested Capital Ratio
Consolidated June AboveNet 30, 2012, acquisition. Invested the increase Capital Alsoin contributing member’s Ratio 14 FY interest to 4Q the 2012 increase is primarily Supplemental was adue non-cash to Earnings an additional settlement Information $133.2 of a payable million Invested toinCII Capital
Slide 15: Segment Financial Data
Segment Financial Data 15 FY 4Q 2012 Supplemental Earnings Information Segment Data
Slide 16: Invested Capital Ratio by Business Unit
Invested Capital Ratio by Business Unit 16 FY 4Q 2012 Supplemental Earnings Information Invested Capital
Slide 17: Revenue Growth: Organic and Inorganic
ZG Acquired through 360Networks Inorganic Sep-08 Revenue and (1includes mo Organic Growth only)Memphis 7Revenue 17 360Networks FY 4Q Networx, Growth 2012(2Supplemental 12% IFW, mos)Organic Onvoy, &Revenue Earnings Citynet, Marquisnet Ctel Growth Information 1Tri-State CAGR (Datebased Markets, W
Slide 18: Adjusted EBITDA Growth and Synergies
Cumulative CAGR) CAGR Earnings based Planned Information Acquired on establishing Synergies EBITDAIncremental a weighted Annualized Acquired average Organic date EBITDA EBITDA based1on 1growth 2acquisition 3 4 5ZG 1 Fibernet Adjusted date and 3 EBITDA AGL EBITDA Networks Growth 6 7 Arialink & A
Slide 19: Cash Flow History
ZG Cash for outflows Flow fixed from asset Operations purchases less Cash PP&E Flow History Cash19 from FYOperations 4Q 2012 Supplemental less Cash Outflows Earnings forInformation Fixed Asset Purchases Cumulative Last 6 Quarters = +$49M millions Cash from operations Cash
Slide 20: Revenue Stratification
Stratification Revenue Stratification is related of Revenue to early FY20 4Q termination millions 2012 Supplemental millions chargesmillions andEarnings the millions accelerated Information MRRrecognition and MRR MAR Usage ofon corresponding the MAR LastOther Day deferred of Revenue the Quarter reve
Slide 21: Adjusted EBITDA Stratification
Stratification Adjusted $1.1 million EBITDA related of Adjusted Stratification associated to a fiber EBITDA asset with Adjusted Other sale 21 millions 1 Revenue EBITDA FY Adjusted 4Q associated 2012 EBITDA Supplemental with Credits excluding Earnings and Adjustments Other Information Revenue Adjuste
Slide 22: Net Earnings to Adjusted EBITDA
Net 4Q add transaction FY Earnings backs1 2012costs, Other Supplemental Stratification loss/(gain) Add Backs Earnings 22on millions millions operating Information Income Netassets Earnings/(loss) from and 1 continuing stock-based fromoperations Continuing compensation Income Operations Stock-based f
Slide 23: Cash Flow Measures
“Cash Cash purchases repayments and financings from fromChange financing on Operations” capital Measure in Cash deferred Deferred of less from CAPX “Cash revenue financing investing +/- Outflows IRUs Cash Cash costs and from forfrom Equity MAR Fixed Financing discontinued FY contributions Asset 4Q“C
Slide 24: Gross New Sales (Bookings)
Gross(Bookings) Sales New Sales (Bookings) thousands thousands 24 FY 4Qmillions Estimated 2012 Capital Supplemental months and Upfront MRR Earnings Expenditures and MARInformation Monthly associated Gross Gross with Profit New Gross Sales Est. New Gross (Bookings) Sales Profit (Bookings) Gross = Con
Slide 25: Gross New Sales (Bookings) and Capital Expenditures
25 FY 4Q 2012 (Bookings)—IRU Expenditures Estimated Charges Capital associated Supplemental Expenditures and Upfront with Gross Earnings Charges associated NewInformation Gross Sales withNew (Bookings) Gross Sales Estimated New(Bookings) millions Sales Capital (Bookings) Capital from and IRUs Upfron
Slide 26: Gross New Sales Payback Stratification
Stratification network >12 capacity Month of Gross estimated Payback Newand capital Sales Positive (Bookings) expenditures IRR, and 26 include FY Speculative 4Q 2012 165 Halsey Projects Supplemental power where upgrades Earnings applicable and Information 160 2 2Hudson 2 Gross generator New Sal
Slide 27: Speculative Projects Capital Expenditure
Stratification 2011 several capital outside includes for ZB plant the projects construction, of $2.9 three Speculative million associated monthsexpanding success ended Projects withJune based national FY two 30, 4Q capital of2012 carriers 2012 Zayo’s for includes Supplemental fiber existing 3 Specul
Slide 28: Quota Bearing Headcount
Quota Bearing QBHC thousands Headcount Headcount (QBHC) Gross FY New4Q Sales 2012(Bookings) Supplemental MRREarnings and MAR Information 28 Quota Bearing Headcount Quota Bearing Headcount Monthly Average Gross New Sales (Bookings) per
Slide 29: Installation and Churn Processed
Installation and Installations thousands Churn Processed thousands 29 thousands FY 4Q 2012 thousands Supplemental MRR andEarnings MAR MRR Information and MARInstallation MRR andandMAR Churn Monthly Processed GrossGross ProfitInstallations Est. Gross Profit Churn=Processed Est. GrossNet Profit Instal
Slide 30: Installation and Churn Breakdown
Churn = Breakdown thousands MRR and MAR of Installations MRR andandMAR Churn Processed Installation and Churn Processed 30 FY 4Q 2012 Supplemental Earnings Information Gross Installations thousands Churn Processed
Slide 31: Price Changes and Renewals
PriceofChanges Net before associated Pricewith Increases and Renewals Renewals and Price Net Price Decreases Price Contract Decreases Increases MRR Value thousands Net before associated Contract Price MRRwith Decreases Value 31Price FYAssociated 4Q Increases Renewals 2012 Supplemental with thousands
Slide 32: Upgrades Associated with Churn
Upgrades Associated MAR On the period thisContract slide, Upgrades inwith which the Value Upgrades timing the Gross = Churn Contract ofNet Installations Churn was Installations Value Processed processed =Associated Contract Associated Associated 1 Value withwith Upgrades with = 1 Upgrades Churn Upgr
Slide 33: Service Activation Pipeline
Service Activation Pipeline Orders—MAR Churn Revenue Pipeline and Churn Net Commitments Installation Pipeline 33 Implied Pipeline FY 4QAverage millions 2012 Supplemental Days millions to Install millions Earnings = MRR MRRInformation and andMAR MARService MRR MRR Activation and MAR and Churn million
Slide 34: Revenue Under Contract
Revenue Under Contract 34 FY 4Q 2012 Supplemental Earnings Information Revenue Under Contract Revenue Under Contract millions Average Remaining Contract Term Months
Slide 35: Employee Data and SG&A
Employee Revenue Statement Data FY 4Q SG&A 2012 Supplemental SG&A Earnings % of Revenue Information = Annualized 35 Employee Revenue Data per Number Employee of Employees Annualized Employee Employee Related Related SG&A SG&A thousands per Employee millions thousands Headcount Fi
Slide 36: Customer Verticals and Product Mix
Customer Verticals and Product Mix 36 FY 4Q 2012 Supplemental Earnings Information Customer Verticals and Product Mix
Slide 37: Customer Concentration
Customer Concentration 37 FY 4Q 2012 Supplemental Earnings Information Customer Concentration % of MRR Customer #1 Customer #2 Customer #3 Top 20 Top 10 Top 5
Slide 38: Customer and Unit Metrics
Customer MAR of Customers MRRand and dropped Unit MAR Metrics due Units toCustomer (MRR spinning and and off MAR)/Customer the Unit1 ZEN Metrics business Number thousands unit toofthe thousands Customers Company’s thousands Number parent, of1CII Units 2 (MRR and (MRR and MAR)/Unit and MAR)/Unit 38 F
Slide 39: Pricing Trends—Waves
Pricing Trends—Waves FY 4Q 2012 Supplemental Earnings Information 39 thousands MRR MRR thousands thousands MRR MRR thousands thousands thousands MRR
Slide 40: Pricing Trends—Ethernet
Pricing Trends—Ethernet (>1000Mb)—MRR/Unit to-the-tower circuits at an FY average 4QFractional 2012 priceSupplemental perGigE circuit (101-1000Mb)—MRR/Unit of Earnings ~$1K 1 Information 40 1 In thousands the threeMRR months MRRended thousands June 30,thousands 2012, Fractional MRR MRR GigEthou
Slide 41: Pricing Trends—OC3, OC12, and OC48
Pricing Trends—OC3, OC12, and OC48 FY 4Q 2012 Supplemental Earnings Information 41 thousands MRR MRR thousands thousands MRR MRR thousands thousands MRR MRR thousands
Slide 42: Pricing Trends—DS1 and DS3
Pricing Trends—DS1 and DS3 FY 4Q 2012 Supplemental Earnings Information 42 thousands MRR MRR thousands thousands MRR MRR thousands
Slide 43: Capital Expenditures by Type
millions Purchases Equipment Purchases ofMaintenance, property of Property andIntegration equipment and Equipment and are net Other ofPurchases Growth grant monies Capital of Property received Expenditures and from Equipment stimulus Capital awards. by Expenditures Driver During 1 43Capital FY the 4
Slide 44: Network Metrics
Network Route an increase Miles Metrics ofFiber 39 markets 44Miles FY 4QOn-Net from 2012 the Buildings Supplemental previous#quarter of Earnings Markets 1 thousands Information 1 In Network the three Metrics monthsFiber endedNetwork—Route June 30, 2012, Zayo Mileschanged Fiber Network—Fiber the defi
Slide 45: Network Metrics: On-Net Buildings
Network Metrics 45 FY 4Q 2012 Supplemental Earnings Information On-Net Buildings
Slide 46: Network Metrics: Colocation
Network Metrics Equivalents Square 46Feet FY 4Q Colocation 2012 Supplemental Cabinet Equivalents Earnings Colocation InformationCabinet Colocation Equivalents Cabinet Utilization Utilization =Billable Colocation Square Feet Colocation Cabinet Equivalents Utilized Colocation Cabinet
Slide 47: Fiber to the Tower
FY 4Q 2012 Supplemental Earnings Information 47 Fiber to the Tower
Slide 48: Fiber to the Tower Towers and Tenants
Fiber toTenants Towers the Tower MRR (FTT) andFiber MARtoMbs the Tower Revenue/Tower Total FTTRevenue/Tenant Towers Bandwidth/Tenant Total FTT Tenants (Mbs)1 In Revenue/Tower Service Tenants/In &Service Revenue/Tenant Tower = 1 Bandwidth/Tenant thousands 48 FY 4Q excludes 2012 Supplemental Dark
Slide 49: FTT Product Mix and Capital Expenditures
% of MRR Expenditures MAR 1 Revenue andFTT MAR Under Product % Contract of Mix MRRmillions = and MAR millions % of 49 Zayo FYGroup’s 4Q 2012Wireless Supplemental CarrierEarnings MRR andInformation MAR FiberMRR to theand Tower MAR(FTT) % ofFiber FTT MRR to the and Tower MAR FTTCapital MRR andExpendit
Slide 50: FTT Markets
FTT Markets Pacific Information Northwest FTT includes Markets Idaho, Mid-Atlantic Montana, includes and Washington WashingtonSoutheast D.C., Maryland, includesNew Tennessee Jersey,and Virginia, GeorgiaWest Southwest Virginia,includes and Pennsylvania Arizona, Nevada, North Central and Colorado incl
Slide 51: Financial Data by Business Unit
FY 4Q 2012 Supplemental Earnings Information 51 Financial Data by Business Unit
Slide 52: Zayo Bandwidth Financial Data
Zayo Bandwidth December revenue acquisition growth 1,closed 2011 and Financial 1360networks pro-forma 1 Dataannualized acquisition, 52 Financial Adjusted and Data theFY EBITDA three 4Q months 2012 growth Supplemental ended have June been 30, Earnings calculated 2012 include Information as if two the
Slide 53: Zayo Fiber Solutions Financial Data
Zayo the annualized respective December Fiberacquisition revenue Solutions 1, 2011 growth Financial closed 360networks and Data pro-forma acquisition, FY 4Qannualized 2012and Supplemental the Adjusted three months EBITDA Earnings ended growth Information Junehave 30, 2012 been 53 Financial include c
Slide 54: zColo Financial Data
zColo the growth 2 1 MarquisNet Financial in and conjunction pro-forma business Data with FY annualized 24Q the The 2012 MarquisNet three Adjusted Supplemental months acquisition. EBITDA ended Earnings March growth As the Information 31,have acquisition 2012 been include 54 calculated occurred Finan
Slide 55: Historical Financial Data & Reconciliations
FY 4Q 2012 Supplemental Earnings Information 55 Historical Financial Data & Reconciliations
Slide 56: Consolidated Historical Financial Data
Consolidated Historical Financial Data 56 FY 4Q 2012 Supplemental Earnings Information Consolidated Financial Data
Slide 57: Consolidated Historical Reconciliations
Consolidated Historical Reconciliations 57 FY 4Q 2012 Supplemental Earnings Information Consolidated Financial Data
Slide 58: Segment Data Reconciliation
58 FY 4Qinformation segment 2012 Supplemental can be found Earnings in ourInformation historical earnings Segmentsupplements Data Reconciliation: found on our Net website Earnings/(loss) at http://www.zayo.com/financial-earnings-release to Adjusted EBITDA Segment Data Reconciliation 1 1 A reconcilia
Slide 59: Pro-forma Growth Reconciliation
59 FY 4Q acquisition Arialink’s approximately growth can2012 business were be found $1.7 Supplemental certain that million. in our supported assets historical TheEarnings and operating those liabilities earnings Information enterprise results which supplements relating product supported Pro-forma to