Agilent Technologies Financial Statements Trends

A -- USA Stock  

Buyout Trend

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 Direct Expenses of 2.9 B or Consolidated Income of 236.4 M, but also many exotic indicators such as Interest Coverage of 17.0632 or Long Term Debt to Equity of 0.5074. 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.
Revenues

Agilent Technologies Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Total Assets7.8 B6.9 B7.6 B
Decreasing
Slightly volatile
Cash and Equivalents1.8 B3.6 B3.6 B
Decreasing
Stable
Investments134.7 M159.3 M161.6 M
Increasing
Stable
Investments Current12.5 M12.6 M13.7 M
Decreasing
Slightly volatile
Investments Non Current127.4 M146.7 M149.6 M
Increasing
Stable
Deferred Revenue273.7 M256.5 M284.9 M
Decreasing
Slightly volatile
Property Plant and Equipment Net761.6 M760.5 M827.6 M
Decreasing
Slightly volatile
Inventory560.7 M496.8 M555.6 M
Decreasing
Slightly volatile
Trade and Non Trade Receivables598 M535.5 M606.3 M
Decreasing
Slightly volatile
Trade and Non Trade Payables299.3 M276.3 M306.5 M
Decreasing
Slightly volatile
Goodwill and Intangible Assets2.1 B945.3 M1.2 B
Decreasing
Stable
Total Liabilities4.4 B4.6 B4.9 B
Increasing
Very volatile
Shareholders EquityB2.9 B2.9 B
Decreasing
Very volatile
Accumulated Retained Earnings DeficitB2.5 B2.5 B
Increasing
Slightly volatile
Accumulated Other Comprehensive Income(178.5 M)(166.5 M)(203 M)
Increasing
Slightly volatile
Current Assets3.6 B3.6 B3.9 B
Decreasing
Slightly volatile
Assets Non Current4.8 B4.2 B3.9 B
Increasing
Stable
Current Liabilities945 MB1.1 B
Decreasing
Slightly volatile
Liabilities Non Current3.2 B3.6 B3.8 B
Increasing
Very volatile
Total Debt1.8 B2.6 B2.7 B
Decreasing
Very volatile
Debt Current187 M900 K36.9 M
Decreasing
Very volatile
Debt Non Current2.2 B2.6 B2.7 B
Increasing
Very volatile
Shareholders Equity USDB2.9 B2.9 B
Decreasing
Very volatile
Cash and Equivalents USD3.1 B3.6 B3.8 B
Increasing
Stable
Total Debt USD2.3 B2.6 B2.7 B
Increasing
Very volatile
Accounts Payable432.2 M391 M394.8 M
Decreasing
Slightly volatile
Receivables937.4 M892.4 M827.3 M
Decreasing
Stable
Inventories839.9 M733.7 M784.2 M
Decreasing
Slightly volatile

Agilent Technologies Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Revenues5.1 BB4.5 B
Decreasing
Very volatile
Cost of RevenueBB2.2 B
Decreasing
Slightly volatile
Selling General and Administrative Expense1.4 B1.4 B1.5 B
Decreasing
Stable
Research and Development Expense499.9 M577.8 M599.9 M
Increasing
Very volatile
Operating Expenses1.9 BB2.1 B
Decreasing
Very volatile
Interest Expense78.7 M79.2 M85.2 M
Decreasing
Very volatile
Income Tax Expense74.8 M43.7 M95.7 M
Decreasing
Slightly volatile
Net Loss Income from Discontinued Operations(460.3 M)(585.4 M)(313 M)
Decreasing
Slightly volatile
Consolidated Income236.4 M(27.9 M)25.1 M
Decreasing
Very volatile
Net Income1.1 B(27.9 M)100.9 M
Increasing
Stable
Net Income Common Stock236.4 M(27.9 M)25.1 M
Decreasing
Very volatile
Weighted Average Shares309.5 M311.4 M337.3 M
Decreasing
Slightly volatile
Weighted Average Shares Diluted307.3 M311.4 M337.4 M
Decreasing
Slightly volatile
Earning Before Interest and Taxes EBIT505.5 M109.2 M217.8 M
Decreasing
Stable
Revenues USD4.2 BB4.5 B
Decreasing
Slightly volatile
Net Income Common Stock USD236.4 M(27.9 M)25.1 M
Decreasing
Very volatile
Earning Before Interest and Taxes USD505.5 M109.2 M217.8 M
Decreasing
Stable
Gross Profit2.7 B2.1 B2.3 B
Decreasing
Stable
Operating Income405.6 M54 M160.3 M
Decreasing
Stable
Direct Expenses2.9 B2.6 B2.7 B
Decreasing
Slightly volatile

Agilent Technologies Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(126.1 M)(114.3 M)(130.2 M)
Increasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals(239.5 M)38 M(41.2 M)
Increasing
Stable
Net Cash Flow Investment Acquisitions and Disposals107.9 M72 M73.4 M
Increasing
Slightly volatile
Net Cash Flow from Financing163.9 M591.3 M474 M
Increasing
Stable
Issuance Repayment of Debt Securities 384.4 M668.7 M617 M
Increasing
Stable
Issuance Purchase of Equity Shares(137.1 M)(77.4 M)(115.3 M)
Increasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (114.2 M)(93.6 M)(127.7 M)
Increasing
Slightly volatile
Net Cash Flow from Investing(191.3 M)(12.6 M)(92.7 M)
Increasing
Slightly volatile
Net Cash Flow from Operations664.5 M469.2 M498.6 M
Decreasing
Stable
Effect of Exchange Rate Changes on Cash 8.7 M20.7 M17.9 M
Increasing
Stable
Net Cash Flow or Change in Cash and Cash Equivalents544.2 M966.6 M879.3 M
Increasing
Stable
Share Based Compensation63.3 M63.9 M69.6 M
Decreasing
Slightly volatile
Depreciation Amortization and Accretion248.3 M186.3 M176.4 M
Increasing
Stable

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share0.6997(0.081)0.0799
Decreasing
Very volatile
Earnings per Diluted Share3.34(0.081)0.319
Increasing
Stable
Earnings per Basic Share USD0.6997(0.081)0.0799
Decreasing
Very volatile
Dividends per Basic Common Share1.74780.3450.5164
Increasing
Stable
Return on Average Equity5.0E-4(0.0108)(0.0034)
Decreasing
Slightly volatile
Return on Average Assets3.0E-4(0.0036)2.0E-4
Decreasing
Slightly volatile
Return on Invested Capital0.12940.02650.057
Decreasing
Stable
Gross Margin0.61030.58770.5303
Increasing
Slightly volatile
Profit Margin6.0E-4(0.008)1.0E-4
Decreasing
Slightly volatile
EBITDA Margin0.1580.06560.0846
Decreasing
Stable
Return on Sales0.10390.02420.0458
Decreasing
Stable
Asset Turnover0.54490.57780.621
Decreasing
Stable
Payout Ratio1.31180.10470.3442
Decreasing
Very volatile
Enterprise Value over EBITDA20.752626.7727.4522
Increasing
Very volatile
Enterprise Value over EBIT48.589572.070.9627
Increasing
Stable
Price to Earnings Ratio23.35(316)(221)
Decreasing
Very volatile
Sales per Share12.252611.6612.9844
Decreasing
Slightly volatile
Price to Sales Ratio4.752.19652.4053
Increasing
Very volatile
Price to Book Value5.093.923.708
Increasing
Stable
Debt to Equity Ratio37.81.83065.1611
Increasing
Slightly volatile
Dividend Yield0.04450.00920.0117
Increasing
Slightly volatile
Current Ratio2.134.063.4265
Decreasing
Stable
Free Cash Flow per Share5.70.93381.4516
Increasing
Stable
Book Value per Share11.91058.338.401
Decreasing
Very volatile
Tangible Assets Book Value per Share17.094717.6618.8693
Decreasing
Very volatile
Total Assets Per Share32.268430.9128.3612
Increasing
Very volatile
Cash Flow Per Share3.67373.932.9604
Increasing
Stable
Return on Investment15.484216.1612.7391
Increasing
Stable
Operating Margin24.1517.015.9304
Increasing
Slightly volatile
Calculated Tax Rate37.884259.9421.2098
Increasing
Slightly volatile
Receivables Turnover7.99477.537.1054
Decreasing
Very volatile
Inventory Turnover4.22114.223.5937
Increasing
Stable
PPandE Turnover7.31587.166.3333
Increasing
Slightly volatile
Cash and Equivalents Turnover2.36512.29492.0591
Increasing
Stable
Accounts Payable Turnover13.289513.7114.2614
Increasing
Very volatile
Accrued Expenses Turnover8.66849.189.0774
Increasing
Stable
Interest Coverage17.063222.5713.6713
Increasing
Slightly volatile
Long Term Debt to Equity0.50740.4530.4674
Decreasing
Slightly volatile
Quick Ratio2.22962.31752.3758
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets38.410536.0434.2456
Increasing
Stable
Revenue to Assets0.6960.66160.6149
Decreasing
Very volatile

Agilent Technologies Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax401.3 M8.1 M128.3 M
Decreasing
Stable
Earnings Before Interest Taxes and Depreciation Amortization EBITDA1.2 B295.6 M437.5 M
Increasing
Very volatile
Earnings Before Interest Taxes and Depreciation Amortization USD753.8 M295.6 M394.2 M
Decreasing
Stable
Market Capitalization24.2 B9.8 B11.2 B
Increasing
Very volatile
Enterprise Value24 B8.8 B10.4 B
Increasing
Very volatile
Invested Capital3.9 B4.1 B4.3 B
Increasing
Very volatile
Average EquityB2.9 B2.9 B
Decreasing
Very volatile
Average Assets9.3 BB7.4 B
Increasing
Stable
Invested Capital Average3.6 B3.7 BB
Decreasing
Stable
Tangible Asset Value5.8 B6.1 B6.5 B
Increasing
Very volatile
Free Cash Flow587.6 M323.1 M370 M
Decreasing
Stable
Working Capital2.7 B2.6 B2.8 B
Decreasing
Stable
Revenue Per Employee625.3 K867.2 K463.8 K
Increasing
Slightly volatile
Net Income Per Employee47.6 K55.8 K44.8 K
Increasing
Stable

Agilent Technologies Fundamental Market Drivers

Short Percent Of Float1.76%
Forward Price Earnings21.31
Shares Short Prior Month4.77M
Average Daily Volume Last 10 Day2.41M
Average Daily Volume In Three Month1.92M
Date Short InterestNovember 15, 2019
Fifty Day Average76.92
Two Hundred Day Average72.92

Agilent Technologies Upcoming Events

Upcoming Quarterly Earning ReportFebruary 19, 2020
Next Earnings ReportMay 12, 2020
Next Fiscal Quarter EndJanuary 31, 2020
Next Fiscal Year EndNovember 23, 2020
Last Quarter Report DateOctober 31, 2019
Last Earning Anouncement DateJanuary 31, 2019
Search macroaxis.com