Agilent Technologies Financial Statements Trends

A -- USA Stock  

USD 64.93  0.46  0.71%

This module enables investors to look at Agilent Technologies 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 543.5 M or Cost of Revenue of 2.4 B, but also many exotic indicators such as Interest Coverage of 11.8611 or Long Term Debt to Equity of 0.5301. This module is a perfect complement to use when analyzing Agilent Technologies Valuation or Volatility. It can also complement various Agilent Technologies Technical models. Check also analysis of Agilent Technologies Correlation with competitors.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Total Assets7.8 B7.8 B8.8 B
Decreasing
Stable
Cash and Equivalents3 B2.3 B2.7 B
Decreasing
Stable
Investments158.8 M135 M138.9 M
Decreasing
Slightly volatile
Investments Current16.5 M14 M32.8 M
Decreasing
Slightly volatile
Investments Non Current158.8 M135 M135.2 M
Decreasing
Slightly volatile
Deferred Revenue316.5 M269 M317.6 M
Decreasing
Stable
Property Plant and Equipment Net751.8 M639 M906.7 M
Decreasing
Slightly volatile
Inventory627.1 M533 M756.5 M
Decreasing
Slightly volatile
Tax Assets1.3 B1.1 B1.1 B
Increasing
Slightly volatile
Trade and Non Trade Receivables742.4 M631 M749.2 M
Decreasing
Slightly volatile
Trade and Non Trade Payables302.4 M257 M351.4 M
Decreasing
Slightly volatile
Goodwill and Intangible Assets3.4 B2.9 B2.7 B
Increasing
Slightly volatile
Total Liabilities4.2 B3.6 B4.4 B
Decreasing
Stable
Shareholders Equity5 B4.2 B4.4 B
Increasing
Stable
Accumulated Retained Earnings Deficit7.2 B6.1 B5.1 B
Increasing
Slightly volatile
Accumulated Other Comprehensive Income(591.8 M)(503 M)(262.6 M)
Decreasing
Slightly volatile
Current Assets3.6 B3.6 B4.5 B
Decreasing
Slightly volatile
Assets Non Current4.9 B4.2 B4.3 B
Increasing
Slightly volatile
Current Liabilities945 M945 M1.5 B
Decreasing
Slightly volatile
Liabilities Non Current3.1 B2.6 B2.9 B
Increasing
Very volatile
Tax Liabilities150.6 M128 M146.3 M
Decreasing
Slightly volatile
Total Debt2.1 B1.9 B2.2 B
Decreasing
Stable
Debt Current294.1 M250 M566.7 M
Decreasing
Slightly volatile
Debt Non Current2.2 B1.9 B2 B
Decreasing
Very volatile
Shareholders Equity USD5 B4.2 B4.4 B
Increasing
Stable
Cash and Equivalents USD2.7 B2.3 B2.7 B
Decreasing
Stable
Total Debt USD2.2 B1.9 B2.2 B
Decreasing
Stable

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Revenues4.7 B4.2 B5.1 B
Decreasing
Slightly volatile
Cost of Revenue2.4 B2 B2.5 B
Decreasing
Slightly volatile
Selling General and Administrative Expense1.5 B1.3 B1.5 B
Decreasing
Slightly volatile
Research and Development Expense387.1 M329 M527.3 M
Decreasing
Slightly volatile
Operating Expenses1.9 B1.6 B2.1 B
Decreasing
Slightly volatile
Interest Expense84.7 M72 M87.1 M
Decreasing
Slightly volatile
Income Tax Expense96.5 M82 M27.9 M
Increasing
Slightly volatile
Net Income from Discontinued Operations43.5 M37 M(19.9 M)
Increasing
Slightly volatile
Consolidated Income543.5 M462 M550.5 M
Increasing
Very volatile
Net Income237 M462 M524.9 M
Decreasing
Very volatile
Net Income Common Stock543.5 M462 M550.5 M
Increasing
Very volatile
Weighted Average Shares319.9 M326 M345.9 M
Decreasing
Slightly volatile
Weighted Average Shares Diluted387.1 M329 M354.8 M
Decreasing
Slightly volatile
Earning Before Interest and Taxes EBIT724.7 M616 M657.9 M
Increasing
Stable
Revenues USD4.9 B4.2 B5.1 B
Decreasing
Slightly volatile
Net Income Common Stock USD543.5 M462 M550.5 M
Increasing
Very volatile
Earning Before Interest and Taxes USD724.7 M616 M657.9 M
Increasing
Stable
Gross Profit2.4 B2.2 B2.5 B
Decreasing
Slightly volatile
Operating Income723.5 M615 M493.4 M
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(163.5 M)(139 M)(158.6 M)
Increasing
Stable
Net Cash Flow Business Acquisitions and Disposals(307.1 M)(261 M)(463.3 M)
Increasing
Stable
Net Cash Flow Investment Acquisitions and Disposals190.6 M162 M162.5 M
Decreasing
Very volatile
Net Cash Flow from Financing(315.3 M)(268 M)(276.2 M)
Decreasing
Stable
Issuance Repayment of Debt Securities 305.9 M260 M147.2 M
Increasing
Stable
Issuance Purchase of Equity Shares(437.6 M)(372 M)(235.6 M)
Decreasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (176.5 M)(150 M)(134.3 M)
Decreasing
Slightly volatile
Net Cash Flow from Investing(280 M)(238 M)(458.1 M)
Increasing
Stable
Net Cash Flow from Operations600.9 M793 M739.6 M
Increasing
Stable
Effect of Exchange Rate Changes on Cash (1.2 M)(1000 K)(2.6 M)
Decreasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents336.5 M286 M163.9 M
Decreasing
Stable
Share Based Compensation68.2 M58 M63.9 M
Increasing
Stable
Depreciation Amortization and Accretion289.4 M246 M307.4 M
Decreasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share1.67061.421.6184
Increasing
Stable
Earnings per Diluted Share0.7291.41.5191
Decreasing
Very volatile
Earnings per Basic Share USD1.67061.421.6184
Increasing
Stable
Dividends per Basic Common Share0.54120.460.4451
Decreasing
Stable
Return on Average Equity0.05270.110.1231
Decreasing
Very volatile
Return on Average Assets0.06970.0610.0633
Increasing
Stable
Return on Invested Capital0.21880.1860.1727
Increasing
Slightly volatile
Gross Margin0.61530.5230.5141
Increasing
Slightly volatile
Profit Margin0.05020.110.1054
Increasing
Stable
EBITDA Margin0.24120.2050.199
Increasing
Slightly volatile
Return on Sales0.17290.1470.1374
Increasing
Slightly volatile
Asset Turnover0.64820.5510.6091
Decreasing
Slightly volatile
Payout Ratio0.38120.3240.269
Increasing
Very volatile
Enterprise Value over EBITDA18.863516.03412.8976
Increasing
Slightly volatile
Enterprise Value over EBIT25.882422.024.5735
Decreasing
Slightly volatile
Price to Earnings Ratio88.6930.68310.6538
Increasing
Slightly volatile
Sales per Share15.164712.8914.6065
Decreasing
Slightly volatile
Price to Sales Ratio4.383.382.5488
Increasing
Slightly volatile
Price to Book Value4.513.3312.7116
Increasing
Slightly volatile
Debt to Equity Ratio45.80.8384.8124
Increasing
Slightly volatile
Dividend Yield0.01290.0110.0137
Decreasing
Slightly volatile
Current Ratio3.323.8473.2005
Increasing
Slightly volatile
Free Cash Flow per Share9.412.0062.418
Increasing
Slightly volatile
Book Value per Share15.311813.01512.9246
Increasing
Slightly volatile
Tangible Assets Book Value per Share17.614.9618.0002
Decreasing
Slightly volatile
Total Assets Per Share28.376924.120426.2308
Increasing
Stable
Cash Flow Per Share2.88422.45162.5303
Increasing
Very volatile
Return on Investment12.08210.269710.5168
Increasing
Stable
Operating Margin24.1714.635913.4716
Increasing
Slightly volatile
Calculated Tax Rate17.733615.073554.1319
Decreasing
Slightly volatile
Receivables Turnover7.97096.77537.0971
Decreasing
Stable
Inventory Turnover4.39263.73373.5891
Increasing
Very volatile
PPandE Turnover7.93256.74266.3521
Increasing
Slightly volatile
Cash and Equivalents Turnover2.17471.84852.0835
Decreasing
Stable
Accounts Payable Turnover18.395615.636314.8691
Increasing
Slightly volatile
Accrued Expenses Turnover11.49199.76818.7537
Increasing
Slightly volatile
Interest Coverage11.861110.08215.2697
Decreasing
Slightly volatile
Long Term Debt to Equity0.53010.45060.5541
Decreasing
Slightly volatile
Quick Ratio3.62573.08182.5327
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets40.562834.478334.1504
Increasing
Slightly volatile
Revenue to Assets0.63360.53860.6098
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax640 M544 M578.3 M
Increasing
Stable
Earnings Before Interest Taxes and Depreciation Amortization EBITDA1.1 B862 M975.8 M
Increasing
Very volatile
Earnings Before Interest Taxes and Depreciation Amortization USD1 B862 M965.3 M
Increasing
Very volatile
Market Capitalization20.7 B14.1 B11.8 B
Increasing
Slightly volatile
Enterprise Value20.7 B13.8 B11.5 B
Increasing
Slightly volatile
Invested Capital3.9 B3.3 B4.1 B
Decreasing
Slightly volatile
Average Equity4.9 B4.2 B4.3 B
Increasing
Stable
Average Assets9 B7.6 B8.6 B
Decreasing
Very volatile
Invested Capital Average3.9 B3.3 B3.9 B
Decreasing
Slightly volatile
Tangible Asset Value5.7 B4.9 B6.2 B
Decreasing
Slightly volatile
Free Cash Flow769.4 M654 M608.6 M
Increasing
Slightly volatile
Working Capital2.7 B2.7 B3 B
Decreasing
Stable
Revenue Per Employee394.4 K335.2 K484.5 K
Decreasing
Slightly volatile
Net Income Per Employee43.4 K36.9 K53.9 K
Decreasing
Slightly volatile

Thematic Opportunities

Explore Investment Opportunities
Build portfolios using Macroaxis predefined set of investing ideas. Many of Macroaxis investing ideas can easily outperform a given market. Ideas can also be optimized per your risk profile before portfolio origination is invoked.
Explore Thematic Ideas
Explore Investing Ideas  

Upcoming Events

Agilent Technologies Upcoming Company Events
Upcoming Quarterly ReportMay 15, 2017
Next Earnings ReportAugust 16, 2017
Check also analysis of Agilent Technologies Correlation with competitors. Please also try Global Markets Map module to get a quick overview of global market snapshot using zoomable world map. drill down to check world indexes.