Equinix Financial Statements Trends

This module enables investors to look at Equinix various fundamental indicators over time in order to gain insight into the company future performance. Macroaxis historical fundamental analysis tools allow evaluation of not only typical financial statement drivers such as Consolidated Income of 187.8 M, Cost of Revenue of 1.3 B or Earning Before Interest and Taxes EBIT of 510.1 M, but also many exotic indicators such as Interest Coverage of 1.9201, Long Term Debt to Equity of 2.0269 or Calculated Tax Rate of 11.0067. This module is a perfect complement to use when analyzing Equinix Valuation or Volatility. It can also complement various Equinix Technical models. Additionally see analysis of Equinix Correlation with competitors.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Accumulated Other Comprehensive Income(509.1 M)(509.1 M)(198.4 M)
Decreasing
Slightly volatile
Total Assets13.1 B10.4 B5.7 B
Increasing
Slightly volatile
Current Assets1.7 B3.3 B1.2 B
Increasing
Slightly volatile
Assets Non Current7.1 B7.1 B4.2 B
Increasing
Slightly volatile
Cash and Equivalents987.9 M2.2 B635.3 M
Increasing
Slightly volatile
Cash and Equivalents USD2.2 B2.2 B730.7 M
Increasing
Slightly volatile
Total Debt6.9 B6.5 B3.2 B
Increasing
Slightly volatile
Debt Current956.5 M956.5 M280.1 M
Increasing
Slightly volatile
Debt Non Current5.6 B5.6 B2.9 B
Increasing
Slightly volatile
Total Debt USD6.5 B6.5 B3.1 B
Increasing
Slightly volatile
Shareholders Equity2.7 B2.7 B1.7 B
Increasing
Slightly volatile
Shareholders Equity USD2.7 B2.7 B1.7 B
Increasing
Slightly volatile
Goodwill and Intangible Assets1.3 B1.3 B830.7 M
Increasing
Slightly volatile
Investments496.9 M496.9 M354.4 M
Increasing
Slightly volatile
Investments Current492.3 M492.3 M290.6 M
Increasing
Slightly volatile
Investments Non Current4.6 M4.6 M65.2 M
Increasing
Very volatile
Total Liabilities7.6 B7.6 B3.7 B
Increasing
Slightly volatile
Current Liabilities1.5 B1.7 B654.2 M
Increasing
Slightly volatile
Liabilities Non Current6 B6 B3.1 B
Increasing
Slightly volatile
Trade and Non Trade Payables400.9 M400.9 M206.2 M
Increasing
Slightly volatile
Property Plant and Equipment Net5.6 B5.6 B3.2 B
Increasing
Slightly volatile
Trade and Non Trade Receivables292 M292 M151.6 M
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit(1.6 B)(1.6 B)(662.4 M)
Decreasing
Slightly volatile
Tax Assets101.2 M101.2 M101.2 M
Steady
Stable

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income187.8 M187.8 M57.6 M
Increasing
Slightly volatile
Cost of Revenue1.3 B1.3 B772.4 M
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT510.1 M510.1 M260.1 M
Increasing
Slightly volatile
Earning Before Interest and Taxes USD510.1 M510.1 M260.1 M
Increasing
Slightly volatile
Gross Profit1.4 B1.4 B753 M
Increasing
Slightly volatile
Interest Expense299.1 M299.1 M164.7 M
Increasing
Slightly volatile
Net Income61.5 M187.8 M47.7 M
Increasing
Stable
Net Income Common Stock187.8 M187.8 M57.5 M
Increasing
Slightly volatile
Net Income Common Stock USD187.8 M187.8 M57.5 M
Increasing
Slightly volatile
Net Income from Discontinued Operations(13.1 M)(13.1 M)(13.1 M)
Steady
Stable
Net Income to Non Controlling Interests(1.2 M)(1.2 M)(763.1 K)
Increasing
Stable
Operating Expenses867 M867 M463.6 M
Increasing
Slightly volatile
Operating Income567.3 M567.3 M289.8 M
Increasing
Slightly volatile
Revenues3.4 B2.7 B1.6 B
Increasing
Slightly volatile
Revenues USD2.7 B2.7 B1.5 B
Increasing
Slightly volatile
Selling General and Administrative Expense825.3 M825.3 M450.4 M
Increasing
Slightly volatile
Weighted Average Shares71.4 M57.8 M44.1 M
Increasing
Slightly volatile
Weighted Average Shares Diluted57.8 M57.8 M43.1 M
Increasing
Slightly volatile
Income Tax Expense23.2 M23.2 M37.9 M
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(868.1 M)(868.1 M)(555.9 M)
Decreasing
Slightly volatile
Depreciation Amortization and Accretion525.6 M525.6 M312.6 M
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents1.6 B1.6 B410.1 M
Increasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals(245.6 M)(245.6 M)(165.6 M)
Decreasing
Stable
Issuance Purchase of Equity Shares859.5 M859.5 M224.1 M
Increasing
Slightly volatile
Issuance Repayment of Debt Securities 1.5 B1.5 B595.5 M
Increasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (521.5 M)(521.5 M)(184.4 M)
Decreasing
Slightly volatile
Net Cash Flow from Financing1.9 B1.9 B680.7 M
Increasing
Slightly volatile
Net Cash Flow from Investing(1.1 B)(1.1 B)(757.8 M)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals514.1 M514.1 M79.2 M
Increasing
Slightly volatile
Net Cash Flow from Operations952.4 M894.8 M496.1 M
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (15.1 M)(15.1 M)(4.5 M)
Decreasing
Slightly volatile
Share Based Compensation132.4 M132.4 M69.6 M
Increasing
Slightly volatile
Cash Beginning of Year610.9 M610.9 M326.7 M
Increasing
Slightly volatile
Cash End of Year2.2 B2.2 B735 M
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.3240.3240.309
Increasing
Stable
Book Value per Share45.39545.39536.7633
Increasing
Slightly volatile
Current Ratio1.111.9681.8855
Decreasing
Slightly volatile
Debt to Equity Ratio1.52.7721.7621
Increasing
Slightly volatile
Share Dilution Ratio1.00911.00911.0159
Decreasing
Stable
Dividend Yield0.0590.0590.039
Increasing
Slightly volatile
Dividends per Basic Common Share17.7117.719.91
Increasing
Slightly volatile
EBITDA Margin0.18430.380.3209
Increasing
Slightly volatile
Earnings per Basic Share3.253.250.6008
Increasing
Slightly volatile
Earnings per Diluted Share1.113.210.4038
Increasing
Slightly volatile
EPS Diluted Growth(1.2802)(1.2802)(2.309)
Increasing
Stable
EPS Growth(1.2873)(1.2873)(2.4395)
Increasing
Stable
Earnings per Basic Share USD3.253.250.6008
Increasing
Slightly volatile
Enterprise Value over EBIT42.042.062.6923
Decreasing
Slightly volatile
Enterprise Value over EBITDA20.8820.887.5427
Increasing
Slightly volatile
Free Cash Flow per Share13.840.462(0.8931)
Increasing
Slightly volatile
Gross Margin0.5260.5260.4238
Increasing
Slightly volatile
Financial Leverage0.17960.17960.0737
Increasing
Slightly volatile
Leverage Ratio3.25813.25812.7949
Increasing
Slightly volatile
NCFO Growth(0.0363)(0.0363)0.2224
Decreasing
Stable
Net Income Growth(1.3712)(1.3712)(2.4543)
Increasing
Very volatile
Profit Margin0.02230.069(0.0203)
Increasing
Slightly volatile
Payout Ratio5.4495.4490.0836
Increasing
Slightly volatile
Price to Book Value5.06.314.0412
Increasing
Slightly volatile
Price to Earnings Ratio31693.046(9.8724)
Increasing
Slightly volatile
Price to Sales Ratio7.446.4115.043
Increasing
Stable
Revenue Growth0.23150.23150.3038
Decreasing
Slightly volatile
Return on Average Assets0.03770.022(0.0016)
Increasing
Slightly volatile
Return on Average Equity0.02010.0870.0076
Increasing
Slightly volatile
Return on Invested Capital0.0490.0490.0278
Increasing
Slightly volatile
Return on Sales0.1870.1870.1009
Increasing
Slightly volatile
Weighted Average Share Growth0.22470.22470.2765
Decreasing
Slightly volatile
Sales per Share47.16847.16831.4492
Increasing
Slightly volatile
Tax Efficiency0.83750.83750.8628
Decreasing
Slightly volatile
Tangible Assets Book Value per Share15015093.1286
Increasing
Slightly volatile
Total Assets Per Share167167107
Increasing
Slightly volatile
Cash Flow Per Share14.408914.40899.7087
Increasing
Slightly volatile
Return on Investment6.99736.99735.0709
Increasing
Slightly volatile
Operating Margin18.4320.813314.3196
Increasing
Slightly volatile
Calculated Tax Rate11.006711.0067227919.2 B
Decreasing
Slightly volatile
Receivables Turnover9.75649.756411.4987
Decreasing
Slightly volatile
PPandE Turnover0.51410.51410.531
Decreasing
Slightly volatile
Cash and Equivalents Turnover1.91981.91983.708
Increasing
Stable
Accounts Payable Turnover68.050668.050669.0089
Increasing
Stable
Accrued Expenses Turnover6.47146.47145.9258
Increasing
Slightly volatile
Interest Coverage1.92011.92011.6125
Increasing
Slightly volatile
Long Term Debt to Equity2.02692.02691.4544
Increasing
Slightly volatile
Quick Ratio1.53081.53081.73
Decreasing
Slightly volatile
Net Current Assets as percentage of Total Assets15.477215.477210.264
Increasing
Stable
Revenue to Assets0.26320.26320.2896
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets8.4 B8.4 B4.9 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA1 B1 B572.7 M
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD1 B1 B572.7 M
Increasing
Slightly volatile
Earnings before Tax211 M211 M95.4 M
Increasing
Slightly volatile
Average Equity2.1 B2.1 B1.6 B
Increasing
Slightly volatile
Enterprise Value30.9 B21.6 B11 B
Increasing
Slightly volatile
Free Cash Flow26.7 M26.7 M(64.3 M)
Increasing
Slightly volatile
Invested Capital14.2 B14.2 B6.8 B
Increasing
Slightly volatile
Invested Capital Average10.4 B10.4 B5.8 B
Increasing
Slightly volatile
Market Capitalization25 B17.3 B8.6 B
Increasing
Slightly volatile
Tangible Asset Value9.1 B9.1 B4.7 B
Increasing
Slightly volatile
Working Capital164.9 M1.6 B499.6 M
Increasing
Slightly volatile
Revenue Per Employee540.6 K540.6 K569.1 K
Increasing
Stable
Net Income Per Employee37.2 K37.2 K24.3 K
Increasing
Very volatile