Equinix Financial Statements Trends

Equinix Inc -- USA Stock  

USD 471.89  0.48  0.1%

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 165.6 M, Cost of Revenue of 1.6 B or Earning Before Interest and Taxes EBIT of 565.5 M, but also many exotic indicators such as Interest Coverage of 1.804, Long Term Debt to Equity of 1.8613 or Calculated Tax Rate of 20.7572. 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(767.5 M)(949.1 M)(273.5 M)
Decreasing
Slightly volatile
Total Assets492 M12.6 B5.3 B
Increasing
Slightly volatile
Current Assets63.5 M1.5 B955.1 M
Increasing
Slightly volatile
Assets Non Current9.6 B11.1 B5.1 B
Increasing
Slightly volatile
Cash and Equivalents1.1 B748.5 M566.6 M
Increasing
Slightly volatile
Cash and Equivalents USD1.6 B748.5 M608.9 M
Increasing
Slightly volatile
Total Debt9.3 B6.8 B3.6 B
Increasing
Slightly volatile
Debt Current592.3 M169 M206.6 M
Increasing
Slightly volatile
Debt Non Current6.4 B6.6 B3.2 B
Increasing
Slightly volatile
Total Debt USD7 B6.8 B3.4 B
Increasing
Slightly volatile
Shareholders Equity3.7 B4.4 B2.1 B
Increasing
Slightly volatile
Shareholders Equity USD3.7 B4.4 B2.1 B
Increasing
Slightly volatile
Goodwill and Intangible Assets2.6 B3.7 B1.2 B
Increasing
Slightly volatile
Investments276.5 M28.5 M321.3 M
Increasing
Slightly volatile
Investments Current268.8 M18.5 M251.2 M
Increasing
Slightly volatile
Investments Non Current7.7 M10 M70.1 M
Increasing
Very volatile
Total Liabilities8.3 B8.2 B4.2 B
Increasing
Slightly volatile
Current Liabilities46.2 M1 B531.2 M
Increasing
Slightly volatile
Liabilities Non Current6.9 B7.2 B3.5 B
Increasing
Slightly volatile
Trade and Non Trade Payables517.2 M581.7 M245.4 M
Increasing
Slightly volatile
Property Plant and Equipment Net6.7 B7.2 B3.7 B
Increasing
Slightly volatile
Trade and Non Trade Receivables362.2 M396.2 M176.2 M
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit(1.9 B)(2 B)(717.2 M)
Decreasing
Slightly volatile
Tax Assets119 M101.2 M102.7 M
Increasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income165.6 M126.8 M47.3 M
Increasing
Slightly volatile
Cost of Revenue1.6 B1.8 B891.3 M
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT565.5 M564.4 M283.5 M
Increasing
Slightly volatile
Earning Before Interest and Taxes USD565.5 M564.4 M283.5 M
Increasing
Slightly volatile
Gross Profit1.8 B1.8 B865.5 M
Increasing
Slightly volatile
Interest Expense363.8 M392.2 M192.3 M
Increasing
Slightly volatile
Net Income200.3 M126.8 M50.1 M
Increasing
Slightly volatile
Net Income Common Stock165.6 M126.8 M47.2 M
Increasing
Slightly volatile
Net Income Common Stock USD165.6 M126.8 M47.2 M
Increasing
Slightly volatile
Net Income from Discontinued Operations(14.6 M)(12.4 M)(13 M)
Increasing
Very volatile
Net Income to Non Controlling Interests(1.4 M)(1.2 M)(727.8 K)
Increasing
Stable
Operating Expenses1.1 B1.2 B542.7 M
Increasing
Slightly volatile
Operating Income624.3 M618.7 M315.2 M
Increasing
Slightly volatile
Revenues3.9 B3.6 B1.8 B
Increasing
Slightly volatile
Revenues USD3.3 B3.6 B1.7 B
Increasing
Slightly volatile
Selling General and Administrative Expense1 B1.1 B523.8 M
Increasing
Slightly volatile
Weighted Average Shares78.2 M70.1 M46.4 M
Increasing
Slightly volatile
Weighted Average Shares Diluted67.3 M70.1 M45.5 M
Increasing
Slightly volatile
Income Tax Expense36.1 M45.5 M44 M
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(1 B)(1.1 B)(636.4 M)
Decreasing
Slightly volatile
Depreciation Amortization and Accretion717.3 M837.2 M373.6 M
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents72.4 M(1.5 B)51.9 M
Decreasing
Very volatile
Net Cash Flow Business Acquisitions and Disposals(611 M)(915.3 M)(264.9 M)
Decreasing
Slightly volatile
Issuance Purchase of Equity Shares470.4 M34.2 M129.6 M
Increasing
Stable
Issuance Repayment of Debt Securities 580.7 M(431.8 M)414.5 M
Increasing
Stable
Payment of Dividends and Other Cash Distributions (537.3 M)(499.5 M)(192.3 M)
Decreasing
Slightly volatile
Net Cash Flow from Financing515.2 M(894.3 M)394.5 M
Decreasing
Very volatile
Net Cash Flow from Investing(1.4 B)(1.6 B)(879.5 M)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals276.3 M10.8 M28.4 M
Increasing
Stable
Net Cash Flow from Operations1.2 B1 B556.8 M
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (13.5 M)(10.5 M)(4.5 M)
Decreasing
Slightly volatile
Share Based Compensation150.1 M152.8 M76.4 M
Increasing
Slightly volatile
Cash Beginning of Year1.5 B2.2 B549.3 M
Increasing
Slightly volatile
Cash End of Year1.6 B748.5 M628.2 M
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.31530.2750.2823
Increasing
Slightly volatile
Book Value per Share56.073761.14544.9186
Increasing
Stable
Current Ratio1.691.4271.8182
Decreasing
Stable
Debt to Equity Ratio1421.88813.5853
Increasing
Slightly volatile
Share Dilution Ratio1.05741.00911.0213
Decreasing
Stable
Dividend Yield0.04160.020.0348
Increasing
Stable
Dividends per Basic Common Share13.00537.08.8204
Increasing
Slightly volatile
EBITDA Margin0.40420.3880.2205
Increasing
Slightly volatile
Earnings per Basic Share2.66321.81(5.1547)
Increasing
Slightly volatile
Earnings per Diluted Share2.721.79(5.1833)
Increasing
Slightly volatile
EPS Diluted Growth(1.5407)(1.2802)(2.4501)
Increasing
Stable
EPS Growth(1.5487)(1.2873)(2.5915)
Increasing
Stable
Earnings per Basic Share USD2.66321.81(5.1547)
Increasing
Slightly volatile
Enterprise Value over EBIT51.052655.046.9211
Decreasing
Stable
Enterprise Value over EBITDA22.798922.43816.5087
Increasing
Slightly volatile
Free Cash Flow per Share13.65(1.38)(8.3357)
Increasing
Slightly volatile
Gross Margin0.53790.4960.3949
Increasing
Slightly volatile
Financial Leverage0.31230.17960.1466
Increasing
Slightly volatile
Leverage Ratio3.77253.25812.8885
Increasing
Slightly volatile
NCFO Growth0.1377(0.0363)0.2458
Decreasing
Stable
Net Income Growth(1.6288)(1.3712)(2.6094)
Increasing
Stable
Profit Margin0.05180.035(0.2086)
Increasing
Slightly volatile
Payout Ratio4.90323.8670.0404
Increasing
Slightly volatile
Price to Book Value5.655.8433.9012
Increasing
Slightly volatile
Price to Earnings Ratio17419714.9869
Increasing
Slightly volatile
Price to Sales Ratio9.536.9385.1627
Increasing
Slightly volatile
Revenue Growth0.18260.23150.3002
Decreasing
Slightly volatile
Return on Average Assets0.02960.01(0.0104)
Increasing
Slightly volatile
Return on Average Equity0.03570.027(0.0258)
Increasing
Slightly volatile
Return on Invested Capital0.04680.040.0242
Increasing
Slightly volatile
Return on Sales0.18050.156(0.0413)
Increasing
Slightly volatile
Weighted Average Share Growth0.17290.22470.2793
Decreasing
Slightly volatile
Sales per Share51.937951.51435.1178
Increasing
Slightly volatile
Tax Efficiency0.90920.83750.8512
Decreasing
Slightly volatile
Tangible Assets Book Value per Share145125111
Increasing
Stable
Total Assets Per Share181177118
Increasing
Slightly volatile
Cash Flow Per Share15.076314.23610.4067
Increasing
Slightly volatile
Return on Investment6.70745.74675.6379
Increasing
Slightly volatile
Operating Margin18.7516.221615.7805
Increasing
Slightly volatile
Calculated Tax Rate20.757228.4319(45.9805)
Increasing
Slightly volatile
Receivables Turnover10.28029.775811.1375
Decreasing
Stable
PPandE Turnover0.56670.56260.5275
Increasing
Slightly volatile
Cash and Equivalents Turnover2.28392.41973.8024
Increasing
Stable
Accounts Payable Turnover70.253965.431866.1613
Increasing
Slightly volatile
Accrued Expenses Turnover6.7146.28535.8975
Increasing
Slightly volatile
Interest Coverage1.8041.50751.6415
Increasing
Slightly volatile
Long Term Debt to Equity1.86131.50961.5003
Increasing
Slightly volatile
Quick Ratio1.41711.16161.6775
Decreasing
Slightly volatile
Net Current Assets as percentage of Total Assets9.97773.48058.6618
Decreasing
Very volatile
Revenue to Assets0.28930.28650.2719
Increasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets11.3 B13.1 B5.9 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA1.6 B1.4 B686 M
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD1.3 B1.4 B657 M
Increasing
Slightly volatile
Earnings before Tax201.7 M172.3 M91.1 M
Increasing
Slightly volatile
Average Equity3.6 B4.6 B2 B
Increasing
Slightly volatile
Enterprise Value45.3 B31.4 B13.8 B
Increasing
Slightly volatile
Free Cash Flow(36.9 M)(96.8 M)(94.9 M)
Increasing
Slightly volatile
Invested Capital13.7 B14.2 B7.3 B
Increasing
Slightly volatile
Invested Capital Average12.8 B14 B6.8 B
Increasing
Slightly volatile
Market Capitalization37 B25.5 B10.8 B
Increasing
Slightly volatile
Tangible Asset Value9.5 B8.9 B5 B
Increasing
Slightly volatile
Working Capital17.3 M438.8 M423.9 M
Increasing
Slightly volatile
Revenue Per Employee600.9 K601.1 K587.3 K
Increasing
Slightly volatile
Net Income Per Employee30.7 K21.1 K25.7 K
Decreasing
Stable