Agilent Technologies Financial Statements Trends

A -- USA Stock  

USD 65.68  1.36  2.11%

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
Accumulated Other Comprehensive Income(591.8 M)(503 M)(256.1 M)
Decreasing
Slightly volatile
Total Assets7.8 B7.8 B8.6 B
Decreasing
Very volatile
Current Assets3.6 B3.6 B4.4 B
Decreasing
Slightly volatile
Assets Non Current4.9 B4.2 B4.3 B
Increasing
Slightly volatile
Cash and Equivalents2.9 B2.3 B2.7 B
Decreasing
Stable
Cash and Equivalents USD2.7 B2.3 B2.7 B
Decreasing
Stable
Total Debt2.1 B1.9 B2.2 B
Decreasing
Stable
Debt Current294.1 M250 M638.5 M
Decreasing
Slightly volatile
Debt Non Current2.2 B1.9 B2 B
Decreasing
Very volatile
Total Debt USD2.2 B1.9 B2.2 B
Decreasing
Stable
Deferred Revenue316.5 M269 M314.7 M
Decreasing
Stable
Shareholders Equity5 B4.2 B4.3 B
Increasing
Stable
Shareholders Equity USD5 B4.2 B4.3 B
Increasing
Stable
Goodwill and Intangible Assets3.4 B2.9 B2.5 B
Increasing
Slightly volatile
Inventory627.1 M533 M748 M
Decreasing
Slightly volatile
Investments158.8 M135 M145.9 M
Decreasing
Slightly volatile
Investments Current16.5 M14 M32.1 M
Decreasing
Slightly volatile
Investments Non Current158.8 M135 M140.6 M
Decreasing
Slightly volatile
Total Liabilities4.2 B3.6 B4.4 B
Decreasing
Stable
Current Liabilities945 M945 M1.5 B
Decreasing
Slightly volatile
Liabilities Non Current3.1 B2.6 B2.9 B
Increasing
Stable
Trade and Non Trade Payables302.4 M257 M348.1 M
Decreasing
Slightly volatile
Property Plant and Equipment Net751.8 M639 M900.4 M
Decreasing
Slightly volatile
Trade and Non Trade Receivables742.4 M631 M750.8 M
Decreasing
Slightly volatile
Accumulated Retained Earnings Deficit7.2 B6.1 B4.9 B
Increasing
Slightly volatile
Tax Assets1.3 B1.1 B1.1 B
Increasing
Slightly volatile
Tax Liabilities150.6 M128 M144.9 M
Decreasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income543.5 M462 M561.4 M
Increasing
Very volatile
Cost of Revenue2.4 B2 B2.5 B
Decreasing
Slightly volatile
Earning Before Interest and Taxes EBIT724.7 M616 M679.4 M
Increasing
Stable
Earning Before Interest and Taxes USD724.7 M616 M679.4 M
Increasing
Stable
Gross Profit2.4 B2.2 B2.6 B
Decreasing
Slightly volatile
Interest Expense84.7 M72 M89.9 M
Decreasing
Slightly volatile
Net Income196 M462 M534.7 M
Decreasing
Very volatile
Net Income Common Stock543.5 M462 M561.4 M
Increasing
Very volatile
Net Income Common Stock USD543.5 M462 M561.4 M
Increasing
Very volatile
Net Income from Discontinued Operations43.5 M37 M(15.5 M)
Increasing
Slightly volatile
Operating Expenses1.9 B1.6 B2.1 B
Decreasing
Slightly volatile
Operating Income723.5 M615 M516.6 M
Increasing
Slightly volatile
Revenues4.6 B4.2 B5.1 B
Decreasing
Slightly volatile
Revenues USD4.9 B4.2 B5.2 B
Decreasing
Slightly volatile
Research and Development Expense387.1 M329 M540.9 M
Decreasing
Slightly volatile
Selling General and Administrative Expense1.5 B1.3 B1.6 B
Decreasing
Slightly volatile
Weighted Average Shares322.5 M326 M347.4 M
Decreasing
Slightly volatile
Weighted Average Shares Diluted387.1 M329 M356 M
Decreasing
Slightly volatile
Income Tax Expense96.5 M82 M35.1 M
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(163.5 M)(139 M)(157.2 M)
Increasing
Stable
Depreciation Amortization and Accretion289.4 M246 M299.2 M
Decreasing
Stable
Net Cash Flow or Change in Cash and Cash Equivalents336.5 M286 M118.9 M
Decreasing
Very volatile
Net Cash Flow Business Acquisitions and Disposals(307.1 M)(261 M)(442 M)
Increasing
Stable
Issuance Purchase of Equity Shares(437.6 M)(372 M)(278.2 M)
Decreasing
Stable
Issuance Repayment of Debt Securities 305.9 M260 M137.1 M
Increasing
Stable
Payment of Dividends and Other Cash Distributions (176.5 M)(150 M)(132 M)
Decreasing
Slightly volatile
Net Cash Flow from Financing(315.3 M)(268 M)(314.5 M)
Decreasing
Stable
Net Cash Flow from Investing(280 M)(238 M)(453.5 M)
Increasing
Stable
Net Cash Flow Investment Acquisitions and Disposals190.6 M162 M144.4 M
Increasing
Very volatile
Net Cash Flow from Operations599.1 M793 M740.7 M
Increasing
Stable
Effect of Exchange Rate Changes on Cash (1.2 M)(1000 K)(2.7 M)
Decreasing
Slightly volatile
Share Based Compensation68.2 M58 M65.2 M
Increasing
Stable
Cash Beginning of Year2.4 B2 B2.2 B
Increasing
Very volatile
Cash End of Year2.7 B2.3 B2.4 B
Increasing
Stable

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.64820.5510.6221
Decreasing
Slightly volatile
Book Value per Share15.311813.01512.4818
Increasing
Slightly volatile
Current Ratio3.233.8473.1314
Increasing
Slightly volatile
Debt to Equity Ratio47.30.8384.6913
Increasing
Slightly volatile
Share Dilution Ratio1.18351.0061.0247
Increasing
Slightly volatile
Dividend Yield0.01290.0110.0132
Decreasing
Slightly volatile
Dividends per Basic Common Share0.54120.460.427
Decreasing
Stable
EBITDA Margin0.24120.2050.1989
Increasing
Slightly volatile
Earnings per Basic Share1.67061.421.6408
Increasing
Very volatile
Earnings per Diluted Share0.61.41.5362
Decreasing
Very volatile
EPS Diluted Growth(0.229)(0.1946)(3.2326)
Increasing
Stable
EPS Growth(0.2415)(0.2053)(3.8767)
Increasing
Stable
Earnings per Basic Share USD1.67061.421.6408
Increasing
Very volatile
Enterprise Value over EBIT25.882422.023.0679
Decreasing
Stable
Enterprise Value over EBITDA18.863516.03412.2275
Increasing
Slightly volatile
Free Cash Flow per Share8.952.0062.3272
Increasing
Slightly volatile
Gross Margin0.61530.5230.5172
Increasing
Slightly volatile
Financial Leverage1.02390.87030.8646
Increasing
Stable
Leverage Ratio2.09391.77982.1515
Decreasing
Slightly volatile
NCFO Growth(0.364)(0.3094)(0.5093)
Increasing
Slightly volatile
Net Income Growth(0.2404)(0.2044)(4.1827)
Increasing
Stable
Profit Margin0.04250.110.1059
Increasing
Stable
Payout Ratio0.38120.3240.2532
Increasing
Very volatile
Price to Book Value4.943.3312.7067
Increasing
Slightly volatile
Price to Earnings Ratio11530.68312.5242
Increasing
Slightly volatile
Price to Sales Ratio4.843.382.4649
Increasing
Slightly volatile
Revenue Growth(0.496)(0.4216)(0.0961)
Decreasing
Slightly volatile
Return on Average Assets0.06910.0610.0655
Increasing
Very volatile
Return on Average Equity0.04440.110.1307
Decreasing
Stable
Return on Invested Capital0.21880.1860.1821
Increasing
Stable
Return on Sales0.17290.1470.1393
Increasing
Slightly volatile
Weighted Average Share Growth(0.007)(0.006)(0.0145)
Increasing
Slightly volatile
Sales per Share15.164712.8914.7064
Decreasing
Slightly volatile
Tax Efficiency1.06490.90520.9319
Decreasing
Stable
Tangible Assets Book Value per Share17.614.9617.937
Decreasing
Slightly volatile
Total Assets Per Share28.376924.120425.8483
Increasing
Stable
Cash Flow Per Share2.88422.45162.5019
Increasing
Very volatile
Return on Investment12.08210.269710.9303
Decreasing
Very volatile
Operating Margin24.3514.635913.5083
Increasing
Slightly volatile
Calculated Tax Rate17.733615.073551.1194
Decreasing
Stable
Receivables Turnover7.97096.77537.1398
Decreasing
Stable
Inventory Turnover4.39263.73373.6207
Decreasing
Very volatile
PPandE Turnover7.93256.74266.4086
Increasing
Stable
Cash and Equivalents Turnover2.17471.84852.1954
Decreasing
Slightly volatile
Accounts Payable Turnover18.395615.636315.1292
Increasing
Very volatile
Accrued Expenses Turnover11.49199.76818.5649
Increasing
Slightly volatile
Interest Coverage11.861110.08220.2105
Decreasing
Slightly volatile
Long Term Debt to Equity0.53010.45060.5754
Decreasing
Slightly volatile
Quick Ratio3.62573.08182.4651
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets40.562834.478333.4711
Increasing
Slightly volatile
Revenue to Assets0.63360.53860.6226
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets9 B7.6 B8.5 B
Increasing
Very volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA1.1 B862 M986.8 M
Increasing
Very volatile
Earnings Before Interest Taxes and Depreciation Amortization USD1 B862 M978.6 M
Increasing
Very volatile
Earnings before Tax640 M544 M596.5 M
Increasing
Stable
Average Equity4.9 B4.2 B4.2 B
Increasing
Stable
Enterprise Value21.2 B13.8 B11 B
Increasing
Slightly volatile
Free Cash Flow769.4 M654 M609.2 M
Increasing
Slightly volatile
Invested Capital3.9 B3.3 B4 B
Decreasing
Slightly volatile
Invested Capital Average3.9 B3.3 B3.9 B
Decreasing
Stable
Market Capitalization22.3 B14.1 B11.4 B
Increasing
Slightly volatile
Tangible Asset Value5.7 B4.9 B6.2 B
Decreasing
Slightly volatile
Working Capital2.7 B2.7 B2.9 B
Increasing
Very volatile
Revenue Per Employee394.4 K335.2 K624.8 K
Decreasing
Slightly volatile
Net Income Per Employee43.4 K36.9 K71.1 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 Analyst Recommendations module to analyst recommendations and target price estimates broken down by several categories.