Zayo — Q1 FY2011 Earnings Presentation
47 slides from Zayo's earnings presentation, Nov 12, 2010
Slide 1: Fiscal Year 1Q 2011 Supplemental Earnings Information
FY 1Q 2011 Supplemental Earnings Information 1 Fiscal Year 1Q 2011 Supplemental Earnings Information FY 1Q 2011 Supplemental Earnings Information
Slide 2: 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 3: Other Notes
Other Notes The enclosed supplement should be read in conjunction with the Company’s Fiscal Year 2010 Earnings Release and Annual Report Forward-Looking Statements Statements made in this presentation and conference call that are not historical in nature constitute forward-looking statements.We cann
Slide 4: Presentation of Financial Data
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. 4 Summary Organizational ChartZayo Capital, Inc. FY 1Q 2011 Supplemental Earnings Information Onvoy, Inc. (“Onvoy Voi
Slide 5: Recent Acquisitions Pro-Forma Statistics
Recent Acquisitions 5 FY 1Q 2011 Supplemental Earnings Information Pro-Forma Statistics Acquisition of AGL Networks closed on July 1, 2010; Acquisition of American Fiber Systems closed on October 1, 2010. Nashville Colo Facility signed and closed on September 20, 2010 1. Quarterly financial results
Slide 6: Reporting Impacts
ReportingImpacts Effective January 1, 2011, the Company intends to implement certain organizational changes. These changes, in conjunction with previously announced acquisitions, will impact our reporting and comparability of prior periods. The Company will provide an explanation and analysis of the
Slide 7: Consolidated Pro-forma Financial Data
Consolidated Pro-forma Financial Data7 FY 1Q 2011 Supplemental Earnings Information Pro-forma1Financial 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 Onvoy Voice Services (spun-off March 12, 2010) as a related p
Slide 8: Consolidated Invested Capital Ratio
Consolidated Invested Capital Ratio 8 FY 1Q 2011 Supplemental Earnings Information Invested Capital 1 The increase in member’s interest during the three months ended September 30, 2010 is a result of additional capital contributions from Zayo Group Holdings, Inc. in the amount of $35.5 million, a ta
Slide 9: Consolidating Financial Data
Consolidating Financial Data 9FY 1Q 2011 Supplemental Earnings Information Consolidating Data($ in millions)Zayo BandwidthZayo Enterprise NetworkszColoZFSCorporate / Intercompany EliminationZayo GroupRevenue$47.2$8.2$7.2$7.5($1.5)$68.6Gross profit34.14.33.67.4(0.6)48.7 Gross profit %72%53%50%98%42%7
Slide 10: Invested Capital Ratio by Business Unit
Invested Capital Ratio by Business Unit 10FY 1Q 2011 Supplemental Earnings Information Invested Capital 1Certain assets and liabilities are not allocated to the business units (e.g. debt issuance costs, deferred income taxes, corporate stock based compensation accrual, etc.), as such, $56.5 million
Slide 11: Stratification of Revenue
Stratification of Revenue 11 $58.8 $59.7 $66.1 $0.4 $0.4 $0.5 $0.6 $0.6 $1.3 $0.1 $0.6 $0.7 $59.9 $61.4 $68.6 $0$10 $20 $30 $40 $50 $60 $70 Mar-10 Jun-10Sep-10 Revenue Stratification MRR and Usage Revenue excluding Amortization of Deferred Revenue Amortization of Deferred Revenue -Installs Amortizat
Slide 12: Stratification of Adjusted EBITDA
Stratification of Adjusted EBITDA 12 $21.0 $21.7 $24.4 $0 $5$10 $15 $20 $25 Mar-10 Jun-10 Sep-10 millions millions $0.8 $1.1 $1.3-$1 $0 $1 $2 Mar-10 Jun-10 Sep-10 Capitalized Labor FY 1Q 2011 Supplemental Earnings Information millions Adjusted EBITDA excluding Amortization of Deferred Revenue and EB
Slide 13: Stratification of Gross New Sales
Stratification of Gross New Sales 14FY 1Q 2011 Supplemental Earnings Information Gross New Sales StratificationMarch 31,June 30,September 30,2010201020101.Network capacityGross New Sales ($ in thousands)$0$0$0Estimated Capital Expenditures on Gross New Sales ($ in millions)1.90.50.84%2.<12 Month Pay
Slide 14: Stratification of Speculative Projects
Stratification of Speculative Projects FY 1Q 2011 Supplemental Earnings Information 15 Speculative Capital Expenditure Commitments($ in millions)March 31,June 30,September 30,201020102010Estimated Success Based Capital2.6$ -$2.9$ Estimated Speculative Capital4.1 0.9 2.9 Estimated Total Capital for S
Slide 15: Quota Bearing Headcount (QBHC)
Quota Bearing Headcount (QBHC) FY 1Q 2011 Supplemental Earnings Information 16 Quota Bearing Headcount 37 36 43 0 10 20 30 40 50 Mar-10 Jun-10 Sep-10 $14$13 $14 $0 $5 $10 $15 Mar-10 Jun-10 Sep-10 Quota Bearing Headcount Monthly Average Gross New Salesper QBHC thousands Headcount Gross New Sales MRR
Slide 16: Installation and Churn
Installation and Churn 17 FY 1Q 2011 Supplemental Earnings Information Installation and Churn $1,032 $1,287 $1,580 $0 $400 $800 $1,200 $1,600 Mar-10 Jun-10 Sep-10 ($901) ($692) ($864) ($1,600) ($1,200) ($800) ($400) $0 Mar-10 Jun-10 Sep-10 Gross Profit = 79% $131 $595 $716 $0 $400 $800 $1,200 $1,600
Slide 17: Breakdown of Installations and Churn
Breakdown of Installations and Churn Installs and Churn 18 FY 1Q 2011 Supplemental Earnings Information $935 $1,030 $1,422 $38 $184 $106 $59 $73 $52 $1,032 $1,287 $1,580 $0 $200 $400 $600 $800 $1,000 $1,200 $1,400 $1,600 $1,800 Mar-10 Jun-10 Sep-10 Installations from New Serivce Installations from P
Slide 18: 8% 5% 83% 6% 11% MRR MRR 100% 100% 100% 100% 90% 3% 7%
8% 5% 83% 6% 11% MRR MRR 100% 100% 100% 100% 90% 3% 7% 100% 82% 14% 4% 100% Churn = -1.6% Churn = -1.2% Churn = -1.3%
Slide 19: Price Changes
Price Changes Price Changes $38 $184 $106 $0 $50 $100 $150 $200 Mar-10 Jun-10 Sep-10 $1.5 $1.8 $5.7 $5.7 $1.5 $4.5 $7.1 $3.3 $10.2 $0 $2 $4 $6 $8 $10 $12 Mar-10 Jun-10 Sep-10 CV associated with Price Increases CV associated with Price Decreases ($76) ($44) ($120) ($200) ($150) ($100) ($50) $0 Mar-10
Slide 20: Price Changes Net of Price Increases and Price Decreases
Price Changes Net of Price Increases and Price Decreases thousands MRR 19 FY 1Q 2011 Supplemental Earnings Information
Slide 21: Upgrades
Upgrades Upgrades $59 $73 $52 $0 $20 $40 $60 $80 Mar-10 Jun-10 Sep-10 ($44) ($73) ($37) ($80) ($60) ($40) ($20) $0 Mar-10 Jun-10 Sep-10 $15 $1 $16 $0 $20 $40 $60 $80 Mar-10 Jun-10 Sep-10 36% 1% 44% 0% 10% 20% 30% 40% 50% Mar-10 Jun-10 Sep-10 Gross Installations Associated with Upgrades Average % Inc
Slide 22: Revenue Under Contract
Gross Profit = 102% Gross Profit = 65% Gross Profit = 66% Gross Profit = 101% Gross Profit = 101% Revenue Under Contract 22 FY 1Q 2011 Supplemental Earnings Information Revenue Under Contract $390 $400 $577 $80 $95 $153 $57 $56 $65 $528 $552 $795 $0 $200 $400 $600 $800 $1,000 Mar-10 Jun-10 Sep-10 Em
Slide 23: Employee Data
Employee Data FY 1Q 2011 Supplemental Earnings Information 23 Employee Data 339 347 393 0 100 200 300 400 500 Mar-10 Jun-10 Sep-10 $706 $708 $698 $0 $200 $400 $600 $800 Mar-10 Jun-10 Sep-10 $10.7 $11.2 $12.4 $0 $2 $4 $6 $8 $10 $12 $14 Mar-10 Jun-10 Sep-10 $126 $129 $126 $0 $200 $400 $600 $800 Mar-10
Slide 24: Customer Verticals and Product Mix
Customer Verticals and Product Mix 24 FY 1Q 2011 Supplemental Earnings Information Customer Verticals and Product MixZayo Group Customer VerticalsMarch 31,June 30,September 30,% of MRR201020102010Wireless27%28%29%National Carrier/ISP24%24%24%Public Sector/Enterprises16%15%14%PTT11%11%10%Regional Car
Slide 25: Customer Concentration
Customer Concentration 25 FY 1Q 2011 Supplemental Earnings Information Customer Concentration
Slide 26: Customer and Unit Metrics
56% 55% 56% 0% 10% 20% 30% 40% 50% 60% 70% 80% 44% 44% 43% 34% 35% 34% 12% 12% 11% 9% 9% 9% 6% 7% 7% Mar-10 Jun-10 Sep-10 % of MRR 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 — 500 1,000 1,500 2,000 2,500 Mar-10 Jun-10
Slide 27: Pricing Trends - Waves
Pricing Trends —Waves1 FY 1Q 2011 Supplemental Earnings Information 27 1Pricing trends for waves are Zayo Bandwidth only $931 $1,037 $1,287 $0 $1,000 $2,000 $3,000 Mar-10 Jun-10 Sep-10 10G Waves -MRR 108 122 137 0 40 80 120 160 Mar-10 Jun-10 Sep-10 10G Waves -Units $8.6 $8.5 $9.4 $0 $20 $40 $60 $80
Slide 28: Pricing Trends - Ethernet
Pricing Trends -Ethernet 1,3 FY 1Q 2011 Supplemental Earnings Information 28 $567 $574 $698 $0 $500 $1,000 $1,500 $2,000 $2,500 Pro-formaMar-10 Jun-10 Sep-10 101-1000Mb Ethernet—MRR 182 176 200 0 500 1,000 1,500 2,000 Pro-forma Mar-10 Jun-10 Sep-10 101-1000Mb Ethernet—Units $3.1 $3.3 $3.5 $0 $1 $2 $
Slide 29: Pricing Trends - OC3, OC12, and OC48
Pricing Trends —OC3, OC12, and OC481 FY 1Q 2011 Supplemental Earnings Information 29 $1,089 $1,081 $1,106 $0 $500 $1,000 $1,500 $2,000 $2,500 Mar-10 Jun-10 Sep-10 OC48 -MRR 80 76 78 0 100 200 300 400 Mar-10 Jun-10 Sep-10 OC48 -Units $13.6 $14.2 $14.2 $0 $5 $10 $15 Mar-10 Jun-10 Sep-10 OC48 —MRR/Unit
Slide 30: Pricing Trends - DS1 and DS3
Pricing Trends —DS1 and DS31 FY 1Q 2011 Supplemental Earnings Information 30 $3,969 $4,004 $3,963 $0 $1,000 $2,000 $3,000 $4,000 $5,000 Pro-forma Mar-10 Jun-10 Sep-10 DS3—MRR 3,410 3,440 3,359 0 2,000 4,000 6,000 8,000 10,000 Pro-forma Mar-10 Jun-10 Sep-10 DS3—Units $1.2 $1.2 $1.2 $0.0 $0.5 $1.0 $1.
Slide 31: Purchases of Property and Equipment
2 2 2 2 2 2 3 3 3 3 3 3 millions Purchases of Property and Equipment Purchases of Property and Equipment by Driver $15.1 $19.5 $20.4 $0.4 $0.4 $0.2 $0.8 $0.6 $0.4 $0.3 $1.1 $0.4 $16.7 $21.6 $21.4 $0 $5 $10 $15 $20 $25 Mar-10 Jun-10 Sep-10 Growth Maintenance Integration Other 31 FY 1Q 2011 Supplement
Slide 32: Capital Expenditures and Network Metrics
Integration $13.5 $17.3 $19.2 $1.6 $2.2 $1.2 $15.1 $19.5 $20.4 $0 $5 $10 $15 $20 $25 Mar-10 Jun-10 Sep-10 Success Based Infrastructure Growth Capital Expenditures Capital Expenditures Capital Expenditures millions millions millions Network Metrics 32 FY 1Q 2011 Supplemental Earnings Information Netw
Slide 33: Network Metrics - On-Net Buildings
Network Metrics 33 FY 1Q 2011 Supplemental Earnings Information On-Net BuildingsMarch 31,June 30,September 30,201020102010On-Net Building TypeCell Site9131,0451,346Enterprise8638771,152Local Serving Office (“LSO”)107116153Carrier Point of Presence (“PoP”)119120151Carrier Hotel/Data Center7476100Wire
Slide 34: Network Metrics - Colocation Cabinet Utilization
Network Metrics 34 FY 1Q 2011 Supplemental Earnings Information Colocation Cabinet Utilization 39,949 41,091 50,091 — 10,000 20,000 30,000 40,000 50,000 60,000 Mar-10 Jun-10 Sep-10 1,598 1,642 2,004 0 500 1,000 1,500 2,000 2,500 Mar-10 Jun-10 Sep-10 1,330 1,327 1,361 — 500 1,000 1,500 Mar-10 Jun-10
Slide 35: Fiber to the Tower
FY 1Q 2011 Supplemental Earnings Information 35 Fiber to the Tower
Slide 36: FTT Sites/Customer Metrics
1Bandwidth / Site excludes Dark Fiber Sites FTT Sites/Customer Metrics FTT Sites and Customer Metrics 856 913 1,045 1,346 487 552 564 872 1,343 1,465 1,609 2,218 — 500 1,000 1,500 2,000 2,500 Dec-09 Mar-10 Jun-10 Sep-10 In Service Under Construction 19 23 27 0 5 10 15 20 25 30 Dec-09 Mar-10 Jun-10 S
Slide 37: Fiber to the Tower (FTT)
$1.2 $1.2 $1.3 $1.3 Towers Sites MRR Mbs Customers/ Site = 1.5 Customers/ Site = 1.6 Not available Revenue/Tower Revenue/Site Total FTT sites Customers/ Site = 1.5 % of Zayo Group’s Wireless Carrier MRR1 34% 38% 41% 0% 10% 20% 30% 40% 50% Mar-10 Jun-10 Sep-10 Fiber to the Tower (FTT) Fiber to the To
Slide 38: 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 38 FY 1Q 2011 Suppl
Slide 39: Financial Data by Business Unit
FY 1Q 2011 Supplemental Earnings Information 39 Financial Data by Business Unit
Slide 40: Zayo Bandwidth Financial Data
Zayo Bandwidth Financial Data 40 Financial Data1The three months ended September 30, 2010 amounts include the transfer of $1.4 Revenue and $1.1 EBITDA from Zayo Bandwidth to Zayo Fiber Solutions in conjunction with the launch of Zayo Fiber Solutions (“ZFS”) on July 1, 2010. Excluding the effect of t
Slide 41: ZEN Financial Data
ZEN Financial Data 41 FY 1Q 2011 Supplemental Earnings Information1The three months ended September 30, 2010 amounts include the transfer of $0.7M Revenue and $0.3M EBITDA from Zayo Enterprise Networks to Zayo Fiber Solutions, (“ZFS”) in conjunction with the launch of ZFS on July 1, 2010 ($ in milli
Slide 42: zColo Financial Data
zColo Financial Data FY 1Q 2011 Supplemental Earnings Information 42 Financial Data($ in millions)March 31,June 30,September 30,201020102010Revenue$6.9 $7.1 $7.2 Annualized revenue growth11%5%Gross profit3.6 3.7 3.6 Gross profit %52%52%50%Operating income/(loss)$1.0 $1.3 $1.0 Adjusted EBITDA$2.4 $2.
Slide 43: ZFS Financial Data
ZFS Financial Data FY 1Q 2011 Supplemental Earnings Information43 Financial Data($ in millions)June 30,September 30,20102010Revenue$ — $7.5 Annualized revenue growth-Gross profit-7.4 Gross profit %-98%Operating income/(loss)-$2.0 Adjusted EBITDA-$4.3 Purchases of property and equipment-1.5 Unlevered
Slide 44: Historical Financial Data & Reconciliations
FY 1Q 2011 Supplemental Earnings Information 44 HistoricalFinancial Data & Reconciliations
Slide 45: Consolidated Historical Financial Data
Consolidated Historical Financial Data 45 FY 1Q 2011 Supplemental Earnings Information($ in millions)Fiscal Year 2009Fiscal Year 2011September 30,December 31,March 31,June 30,September 30,Total2009200920102010Total2010Revenue$150.8 $45.5 $58.2 $58.9 $61.4 $224.0 $68.6 Annualized revenue growth50%112
Slide 46: Consolidated Historical Reconciliations
Consolidated Historical Reconciliations 46 FY 1Q 2011 Supplemental Earnings Information($ in millions)Fiscal Year 2009Fiscal Year 2011September 30,December 31,March 31,June 30,September 30,Total2009200920102010Total2010Earnings/(loss) from continuing operations($9.3)$0.1 $2.9 ($11.4)$5.4 ($3.0)($0.3
Slide 47: Financial Data Reconciliation
47 FY 1Q 2011 Supplemental Earnings Information Financial DataReconciliationZayo BandwidthZayo Enterprise NetworkszColoZFSCorporate / Interco EliminationZayo GroupEarnings/(loss) from continuing operations$8.5 $0.0 $0.9 $2.0 ($11.7)($0.3)Depreciation and amortization8.2 1.0 1.3 1.9 0.0 12.4 Interest