Agilent Technologies Financial Statements Trends

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 462 M or Cost of Revenue of 2 B, but also many exotic indicators such as Interest Coverage of 10.082 or Long Term Debt to Equity of 0.4506. 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
Accumulated Other Comprehensive Income(503 M)(503 M)(228.2 M)
Decreasing
Slightly volatile
Total Assets7.8 B7.8 B8.7 B
Increasing
Very volatile
Current Assets3.6 B3.6 B4.4 B
Decreasing
Stable
Assets Non Current4.2 B4.2 B4.2 B
Increasing
Slightly volatile
Cash and Equivalents2.3 B2.3 B2.7 B
Decreasing
Stable
Cash and Equivalents USD2.3 B2.3 B2.7 B
Decreasing
Stable
Total Debt1.9 B1.9 B2.2 B
Decreasing
Stable
Debt Current250 M250 M667.2 M
Decreasing
Slightly volatile
Debt Non Current1.9 B1.9 B2 B
Decreasing
Very volatile
Total Debt USD1.9 B1.9 B2.2 B
Decreasing
Stable
Deferred Revenue269 M269 M314.6 M
Decreasing
Stable
Shareholders Equity4.2 B4.2 B4.2 B
Increasing
Stable
Shareholders Equity USD4.2 B4.2 B4.2 B
Increasing
Stable
Goodwill and Intangible Assets2.9 B2.9 B2.5 B
Increasing
Slightly volatile
Inventory533 M533 M758.1 M
Decreasing
Slightly volatile
Investments135 M135 M144.8 M
Decreasing
Slightly volatile
Investments Current14 M14 M33.4 M
Decreasing
Slightly volatile
Investments Non Current135 M135 M139.1 M
Decreasing
Slightly volatile
Total Liabilities3.6 B3.6 B4.4 B
Decreasing
Stable
Current Liabilities945 M945 M1.5 B
Decreasing
Slightly volatile
Liabilities Non Current2.6 B2.6 B2.9 B
Increasing
Very volatile
Trade and Non Trade Payables257 M257 M351.9 M
Decreasing
Slightly volatile
Property Plant and Equipment Net639 M639 M912.8 M
Decreasing
Slightly volatile
Trade and Non Trade Receivables631 M631 M751.5 M
Decreasing
Slightly volatile
Accumulated Retained Earnings Deficit6.1 B6.1 B4.7 B
Increasing
Slightly volatile
Tax Assets1.1 B1.1 B1.1 B
Steady
Stable
Tax Liabilities128 M128 M144.4 M
Decreasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income462 M462 M562.9 M
Increasing
Very volatile
Cost of Revenue2 B2 B2.6 B
Decreasing
Slightly volatile
Earning Before Interest and Taxes EBIT616 M616 M675.7 M
Increasing
Stable
Earning Before Interest and Taxes USD616 M616 M675.7 M
Increasing
Stable
Gross Profit2.2 B2.2 B2.6 B
Decreasing
Slightly volatile
Interest Expense72 M72 M90.3 M
Decreasing
Slightly volatile
Net Income462 M462 M562.9 M
Increasing
Very volatile
Net Income Common Stock462 M462 M562.9 M
Increasing
Very volatile
Net Income Common Stock USD462 M462 M562.9 M
Increasing
Very volatile
Net Income from Discontinued Operations37 M37 M(20.4 M)
Increasing
Slightly volatile
Operating Expenses1.6 B1.6 B2.1 B
Decreasing
Slightly volatile
Operating Income615 M615 M499.3 M
Increasing
Slightly volatile
Revenues4.2 B4.2 B5.2 B
Decreasing
Slightly volatile
Revenues USD4.2 B4.2 B5.2 B
Decreasing
Slightly volatile
Research and Development Expense329 M329 M553.8 M
Decreasing
Slightly volatile
Selling General and Administrative Expense1.3 B1.3 B1.6 B
Decreasing
Slightly volatile
Weighted Average Shares322.3 M326 M349.2 M
Decreasing
Slightly volatile
Weighted Average Shares Diluted329 M329 M353.4 M
Decreasing
Slightly volatile
Income Tax Expense82 M82 M30 M
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(139 M)(139 M)(156.7 M)
Increasing
Slightly volatile
Depreciation Amortization and Accretion246 M246 M300 M
Decreasing
Stable
Net Cash Flow or Change in Cash and Cash Equivalents286 M286 M100.8 M
Decreasing
Very volatile
Net Cash Flow Business Acquisitions and Disposals(261 M)(261 M)(453.2 M)
Increasing
Stable
Issuance Purchase of Equity Shares(372 M)(372 M)(264.9 M)
Decreasing
Stable
Issuance Repayment of Debt Securities 260 M260 M123 M
Increasing
Stable
Payment of Dividends and Other Cash Distributions (150 M)(150 M)(128.2 M)
Decreasing
Slightly volatile
Net Cash Flow from Financing(268 M)(268 M)(314.4 M)
Decreasing
Stable
Net Cash Flow from Investing(238 M)(238 M)(468 M)
Increasing
Stable
Net Cash Flow Investment Acquisitions and Disposals162 M162 M140.6 M
Increasing
Very volatile
Net Cash Flow from Operations793 M793 M752.5 M
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (1000 K)(1000 K)(2.8 M)
Decreasing
Slightly volatile
Share Based Compensation58 M58 M65 M
Increasing
Stable
Cash Beginning of Year2 B2 B2.2 B
Increasing
Very volatile
Cash End of Year2.3 B2.3 B2.4 B
Increasing
Stable

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.5510.5510.6199
Decreasing
Slightly volatile
Book Value per Share13.01513.01512.246
Increasing
Slightly volatile
Current Ratio3.853.8473.1234
Increasing
Slightly volatile
Debt to Equity Ratio0.450.8381.1082
Decreasing
Slightly volatile
Share Dilution Ratio1.0061.0061.0115
Decreasing
Stable
Dividend Yield0.0110.0110.0133
Decreasing
Slightly volatile
Dividends per Basic Common Share0.460.460.4175
Decreasing
Stable
EBITDA Margin0.2050.2050.1953
Increasing
Slightly volatile
Earnings per Basic Share1.421.421.6383
Increasing
Very volatile
Earnings per Diluted Share1.561.41.6275
Increasing
Stable
EPS Diluted Growth(0.1946)(0.1946)(3.4829)
Increasing
Stable
EPS Growth(0.2053)(0.2053)(4.1796)
Increasing
Stable
Earnings per Basic Share USD1.421.421.6383
Increasing
Very volatile
Enterprise Value over EBIT22.022.022.8333
Decreasing
Stable
Enterprise Value over EBITDA16.03416.03411.6745
Increasing
Slightly volatile
Free Cash Flow per Share7.112.0062.2006
Increasing
Slightly volatile
Gross Margin0.5230.5230.509
Increasing
Stable
Financial Leverage0.87030.87030.8513
Increasing
Very volatile
Leverage Ratio1.77981.77982.1563
Decreasing
Slightly volatile
NCFO Growth(0.3094)(0.3094)(0.5214)
Increasing
Slightly volatile
Net Income Growth(0.2044)(0.2044)(4.5113)
Increasing
Stable
Profit Margin0.110.110.1112
Increasing
Slightly volatile
Payout Ratio0.3240.3240.2425
Decreasing
Very volatile
Price to Book Value4.153.3312.5888
Increasing
Slightly volatile
Price to Earnings Ratio35.3130.6834.341
Increasing
Slightly volatile
Price to Sales Ratio4.183.382.3337
Increasing
Slightly volatile
Revenue Growth(0.4216)(0.4216)(0.0628)
Decreasing
Slightly volatile
Return on Average Assets0.050.0610.0643
Increasing
Very volatile
Return on Average Equity5.30.110.5704
Increasing
Slightly volatile
Return on Invested Capital0.1860.1860.179
Increasing
Stable
Return on Sales0.1470.1470.1365
Increasing
Slightly volatile
Weighted Average Share Growth(0.006)(0.006)(0.0151)
Increasing
Stable
Sales per Share12.8912.8914.6682
Decreasing
Slightly volatile
Tax Efficiency0.90520.90520.9208
Decreasing
Stable
Tangible Assets Book Value per Share14.9614.9617.9651
Decreasing
Slightly volatile
Total Assets Per Share24.120424.120425.6375
Increasing
Stable
Cash Flow Per Share2.45162.45162.47
Increasing
Very volatile
Return on Investment10.269710.269710.8343
Decreasing
Very volatile
Operating Margin14.6414.635912.6051
Increasing
Slightly volatile
Calculated Tax Rate15.073515.073553.9015
Decreasing
Stable
Receivables Turnover6.77536.77537.0705
Decreasing
Slightly volatile
Inventory Turnover3.73373.73373.5563
Decreasing
Slightly volatile
PPandE Turnover6.74266.74266.2817
Decreasing
Very volatile
Cash and Equivalents Turnover1.84851.84852.1971
Decreasing
Slightly volatile
Accounts Payable Turnover15.636315.636314.857
Decreasing
Stable
Accrued Expenses Turnover9.76819.76818.321
Increasing
Slightly volatile
Interest Coverage10.08210.08220.9063
Decreasing
Slightly volatile
Long Term Debt to Equity0.45060.45060.5792
Decreasing
Slightly volatile
Quick Ratio3.08183.08182.3683
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets34.478334.478332.8801
Increasing
Slightly volatile
Revenue to Assets0.53860.53860.6217
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets7.6 B7.6 B8.5 B
Decreasing
Very volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA942 M862 M982.3 M
Increasing
Very volatile
Earnings Before Interest Taxes and Depreciation Amortization USD862 M862 M975.7 M
Decreasing
Very volatile
Earnings before Tax544 M544 M592.9 M
Increasing
Stable
Average Equity4.2 B4.2 B4.2 B
Increasing
Stable
Enterprise Value13.8 B13.8 B10.2 B
Increasing
Slightly volatile
Free Cash Flow654 M654 M595.8 M
Increasing
Slightly volatile
Invested Capital3.3 B3.3 B4 B
Decreasing
Slightly volatile
Invested Capital Average3.3 B3.3 B3.9 B
Decreasing
Stable
Market Capitalization17.7 B14.1 B10.8 B
Increasing
Slightly volatile
Tangible Asset Value4.9 B4.9 B6.2 B
Decreasing
Slightly volatile
Working Capital2.7 B2.7 B2.9 B
Increasing
Very volatile
Revenue Per Employee335.2 K335.2 K644 K
Decreasing
Slightly volatile
Net Income Per Employee36.9 K36.9 K73.4 K
Decreasing
Slightly volatile