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 126.8 M, Cost of Revenue of 1.8 B or Earning Before Interest and Taxes EBIT of 564.4 M, but also many exotic indicators such as Interest Coverage of 1.5075, Long Term Debt to Equity of 1.5096 or Calculated Tax Rate of 28.4319. 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(949.1 M)(509.1 M)(288.7 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 Current11.1 B7.1 B5.2 B
Increasing
Slightly volatile
Cash and Equivalents41.2 M748.5 M481.7 M
Increasing
Slightly volatile
Cash and Equivalents USD748.5 M2.2 B540.7 M
Increasing
Slightly volatile
Total Debt155 M6.8 B2.9 B
Increasing
Slightly volatile
Debt Current169 M956.5 M171.3 M
Increasing
Slightly volatile
Debt Non Current6.6 B5.6 B3.3 B
Increasing
Slightly volatile
Total Debt USD6.8 B6.5 B3.4 B
Increasing
Slightly volatile
Shareholders Equity4.4 B2.7 B2.1 B
Increasing
Slightly volatile
Shareholders Equity USD4.4 B2.7 B2.1 B
Increasing
Slightly volatile
Goodwill and Intangible Assets3.7 B1.3 B1.3 B
Increasing
Slightly volatile
Investments28.5 M496.9 M300.6 M
Increasing
Stable
Investments Current18.5 M492.3 M230.3 M
Increasing
Stable
Investments Non Current10 M4.6 M70.3 M
Increasing
Very volatile
Total Liabilities8.2 B7.6 B4.1 B
Increasing
Slightly volatile
Current Liabilities46.2 M1 B531.2 M
Increasing
Slightly volatile
Liabilities Non Current7.2 B6 B3.5 B
Increasing
Slightly volatile
Trade and Non Trade Payables581.7 M400.9 M250.7 M
Increasing
Slightly volatile
Property Plant and Equipment Net7.2 B5.6 B3.7 B
Increasing
Slightly volatile
Trade and Non Trade Receivables396.2 M292 M179.1 M
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit(2 B)(1.6 B)(725.1 M)
Decreasing
Slightly volatile
Tax Assets101.2 M101.2 M101.2 M
Steady
Stable

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income126.8 M187.8 M44.1 M
Increasing
Slightly volatile
Cost of Revenue1.8 B1.3 B906.5 M
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT564.4 M510.1 M283.4 M
Increasing
Slightly volatile
Earning Before Interest and Taxes USD564.4 M510.1 M283.4 M
Increasing
Slightly volatile
Gross Profit(26.9 M)1.8 B714.1 M
Increasing
Slightly volatile
Interest Expense392.2 M299.1 M194.7 M
Increasing
Slightly volatile
Net Income(21.6 M)126.8 M31.6 M
Increasing
Stable
Net Income Common Stock126.8 M187.8 M43.9 M
Increasing
Slightly volatile
Net Income Common Stock USD126.8 M187.8 M43.9 M
Increasing
Slightly volatile
Net Income from Discontinued Operations(12.4 M)(12.4 M)(12.8 M)
Increasing
Slightly volatile
Net Income to Non Controlling Interests(1.2 M)(1.2 M)(710.5 K)
Increasing
Stable
Operating Expenses1.2 B867 M550.9 M
Increasing
Slightly volatile
Operating Income618.7 M567.3 M314.7 M
Increasing
Slightly volatile
Revenues77.2 M3.6 B1.5 B
Increasing
Slightly volatile
Revenues USD3.6 B2.7 B1.8 B
Increasing
Slightly volatile
Selling General and Administrative Expense1.1 B825.3 M532.3 M
Increasing
Slightly volatile
Weighted Average Shares3 M70.1 M40.2 M
Increasing
Slightly volatile
Weighted Average Shares Diluted70.1 M57.8 M45.8 M
Increasing
Slightly volatile
Income Tax Expense45.5 M23.2 M44.7 M
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(1.1 B)(868.1 M)(642.2 M)
Decreasing
Slightly volatile
Depreciation Amortization and Accretion837.2 M525.6 M383.6 M
Increasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents(1.5 B)1.6 B(77.5 M)
Decreasing
Stable
Net Cash Flow Business Acquisitions and Disposals(915.3 M)(245.6 M)(290.2 M)
Decreasing
Slightly volatile
Issuance Purchase of Equity Shares34.2 M859.5 M93.2 M
Increasing
Very volatile
Issuance Repayment of Debt Securities (431.8 M)1.5 B330.1 M
Decreasing
Very volatile
Payment of Dividends and Other Cash Distributions (499.5 M)(521.5 M)(189.1 M)
Decreasing
Slightly volatile
Net Cash Flow from Financing(894.3 M)1.9 B277 M
Decreasing
Stable
Net Cash Flow from Investing(1.6 B)(1.1 B)(892.6 M)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals10.8 M514.1 M6.2 M
Increasing
Stable
Net Cash Flow from Operations(27.5 M)1 B455.4 M
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (10.5 M)(15.1 M)(4.3 M)
Decreasing
Slightly volatile
Share Based Compensation152.8 M132.4 M76.6 M
Increasing
Slightly volatile
Cash Beginning of Year2.2 B610.9 M610.5 M
Increasing
Slightly volatile
Cash End of Year748.5 M2.2 B560 M
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.2750.3240.2789
Increasing
Slightly volatile
Book Value per Share61.14545.39545.3412
Increasing
Stable
Current Ratio1.111.4271.7698
Decreasing
Stable
Debt to Equity Ratio1.51.8881.852
Increasing
Slightly volatile
Share Dilution Ratio1.00911.01.0173
Decreasing
Stable
Dividend Yield0.020.0590.033
Decreasing
Very volatile
Dividends per Basic Common Share7.017.718.32
Increasing
Stable
EBITDA Margin18.430.3881.7227
Increasing
Slightly volatile
Earnings per Basic Share1.813.25(5.2258)
Increasing
Slightly volatile
Earnings per Diluted Share1.111.79(5.3175)
Increasing
Slightly volatile
EPS Diluted Growth(1.2802)(1.6472)(2.4284)
Increasing
Stable
EPS Growth(1.2873)(1.6552)(2.5697)
Increasing
Stable
Earnings per Basic Share USD1.813.25(5.2258)
Increasing
Slightly volatile
Enterprise Value over EBIT55.042.047.25
Decreasing
Very volatile
Enterprise Value over EBITDA22.43820.8816.4787
Increasing
Slightly volatile
Free Cash Flow per Share13.84(1.38)(8.3198)
Increasing
Slightly volatile
Gross Margin0.4960.5260.3914
Increasing
Slightly volatile
Financial Leverage0.17960.41370.1355
Increasing
Slightly volatile
Leverage Ratio3.25813.90962.8457
Increasing
Slightly volatile
NCFO Growth(0.0363)0.29790.2313
Decreasing
Stable
Net Income Growth(1.3712)(1.7235)(2.588)
Increasing
Stable
Profit Margin0.02230.035(0.2111)
Increasing
Slightly volatile
Payout Ratio3.8675.449(0.0459)
Increasing
Slightly volatile
Price to Book Value5.05.8433.8471
Increasing
Slightly volatile
Price to Earnings Ratio31619726.8178
Increasing
Slightly volatile
Price to Sales Ratio7.446.9384.9885
Increasing
Slightly volatile
Revenue Growth0.23150.11540.3042
Decreasing
Slightly volatile
Return on Average Assets0.03770.01(0.0097)
Increasing
Slightly volatile
Return on Average Equity0.02010.027(0.0271)
Increasing
Slightly volatile
Return on Invested Capital0.040.0490.0236
Increasing
Slightly volatile
Return on Sales0.1560.187(0.0433)
Increasing
Slightly volatile
Weighted Average Share Growth0.22470.10370.2836
Decreasing
Slightly volatile
Sales per Share51.51447.16835.0825
Increasing
Slightly volatile
Tax Efficiency0.83750.88990.8452
Decreasing
Slightly volatile
Tangible Assets Book Value per Share125150110
Increasing
Stable
Total Assets Per Share177167118
Increasing
Slightly volatile
Cash Flow Per Share14.23614.408910.3367
Increasing
Slightly volatile
Return on Investment5.74676.99735.5578
Increasing
Slightly volatile
Operating Margin18.4316.221615.7539
Increasing
Slightly volatile
Calculated Tax Rate28.431911.0067(45.3409)
Increasing
Slightly volatile
Receivables Turnover9.77589.756411.0955
Decreasing
Stable
PPandE Turnover0.56260.51410.5271
Increasing
Slightly volatile
Cash and Equivalents Turnover2.41971.91983.8137
Increasing
Stable
Accounts Payable Turnover65.431868.050665.7594
Increasing
Slightly volatile
Accrued Expenses Turnover6.28536.47145.8618
Increasing
Slightly volatile
Interest Coverage1.50751.92011.6168
Increasing
Slightly volatile
Long Term Debt to Equity1.50962.02691.471
Increasing
Slightly volatile
Quick Ratio1.16161.53081.6562
Decreasing
Slightly volatile
Net Current Assets as percentage of Total Assets3.480515.47728.1204
Decreasing
Stable
Revenue to Assets0.28650.26320.2717
Increasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets13.1 B8.4 B6 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA1.5 B1.4 B675.1 M
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD1.4 B1 B666.9 M
Increasing
Slightly volatile
Earnings before Tax172.3 M211 M88.7 M
Increasing
Slightly volatile
Average Equity4.6 B2.1 B2.1 B
Increasing
Slightly volatile
Enterprise Value256.4 M31.4 B10 B
Increasing
Slightly volatile
Free Cash Flow(96.8 M)26.7 M(99.9 M)
Increasing
Slightly volatile
Invested Capital14.2 B11.7 B7.3 B
Increasing
Slightly volatile
Invested Capital Average14 B10.4 B6.9 B
Increasing
Slightly volatile
Market Capitalization17.6 M25.5 B7.7 B
Increasing
Slightly volatile
Tangible Asset Value8.9 B9.1 B5 B
Increasing
Slightly volatile
Working Capital17.3 M438.8 M423.9 M
Increasing
Slightly volatile
Revenue Per Employee601.1 K540.6 K587.3 K
Increasing
Slightly volatile
Net Income Per Employee21.1 K37.2 K24.9 K
Decreasing
Stable