Agilent Technologies Financial Statements Trends

Agilent Technologies Inc -- USA Stock  

USD 68.69  0.67  0.97%

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 454.2 M or Cost of Revenue of 2.1 B, but also many exotic indicators such as Interest Coverage of 9.9629 or Long Term Debt to Equity of 0.4462. 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(470.5 M)(503 M)(225.5 M)
Decreasing
Slightly volatile
Total Assets7.8 B7.5 B8.7 B
Increasing
Very volatile
Current Assets3.6 B3.7 B4.4 B
Decreasing
Stable
Assets Non Current4.2 B4.2 B4.2 B
Increasing
Slightly volatile
Cash and Equivalents2.6 B2.3 B2.7 B
Decreasing
Stable
Cash and Equivalents USD2.4 B2.3 B2.7 B
Decreasing
Stable
Total Debt2.1 B1.9 B2.2 B
Decreasing
Stable
Debt Current294.1 M250 M670.9 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 Revenue277.4 M269 M315.3 M
Decreasing
Stable
Shareholders Equity4.4 B4.2 B4.3 B
Increasing
Stable
Shareholders Equity USD4.4 B4.2 B4.3 B
Increasing
Stable
Goodwill and Intangible Assets3 B2.9 B2.5 B
Increasing
Slightly volatile
Inventory565.3 M533 M760.8 M
Decreasing
Slightly volatile
Investments116.3 M135 M143.3 M
Decreasing
Slightly volatile
Investments Current16.5 M14 M33.6 M
Decreasing
Slightly volatile
Investments Non Current116.3 M135 M137.5 M
Decreasing
Slightly volatile
Total Liabilities3.6 B3.6 B4.4 B
Decreasing
Stable
Current Liabilities945 M976 M1.5 B
Decreasing
Slightly volatile
Liabilities Non Current2.6 B2.6 B2.9 B
Increasing
Very volatile
Trade and Non Trade Payables282.1 M257 M354 M
Decreasing
Slightly volatile
Property Plant and Equipment Net654.2 M639 M914 M
Decreasing
Slightly volatile
Trade and Non Trade Receivables651.1 M631 M753.2 M
Decreasing
Slightly volatile
Accumulated Retained Earnings Deficit6.1 B6.1 B4.7 B
Increasing
Slightly volatile
Tax Assets1.3 B1.1 B1.1 B
Increasing
Slightly volatile
Tax Liabilities150.6 M128 M146.3 M
Decreasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income454.2 M462 M562.3 M
Increasing
Very volatile
Cost of Revenue2.1 B2 B2.6 B
Decreasing
Slightly volatile
Earning Before Interest and Taxes EBIT592.1 M616 M673.7 M
Increasing
Very volatile
Earning Before Interest and Taxes USD592.1 M616 M673.7 M
Increasing
Very volatile
Gross Profit2.2 B2.2 B2.6 B
Decreasing
Slightly volatile
Interest Expense72.6 M72 M90.4 M
Decreasing
Slightly volatile
Net Income633 M462 M577.2 M
Increasing
Very volatile
Net Income Common Stock454.2 M462 M562.3 M
Increasing
Very volatile
Net Income Common Stock USD454.2 M462 M562.3 M
Increasing
Very volatile
Net Income from Discontinued Operations43.5 M37 M(19.9 M)
Increasing
Slightly volatile
Operating Expenses1.6 B1.6 B2.1 B
Decreasing
Slightly volatile
Operating Income598.4 M615 M498 M
Increasing
Slightly volatile
Revenues4.4 B4.2 B5.2 B
Decreasing
Slightly volatile
Revenues USD4.3 B4.2 B5.2 B
Decreasing
Slightly volatile
Research and Development Expense346.8 M329 M555.2 M
Decreasing
Slightly volatile
Selling General and Administrative Expense1.3 B1.3 B1.6 B
Decreasing
Slightly volatile
Weighted Average Shares321.8 M326 M349.2 M
Decreasing
Slightly volatile
Weighted Average Shares Diluted349.5 M329 M355.1 M
Decreasing
Slightly volatile
Income Tax Expense65.3 M82 M28.6 M
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(118.4 M)(139 M)(155 M)
Increasing
Slightly volatile
Depreciation Amortization and Accretion262.6 M246 M301.4 M
Decreasing
Stable
Net Cash Flow or Change in Cash and Cash Equivalents(388.9 M)286 M44.5 M
Decreasing
Stable
Net Cash Flow Business Acquisitions and Disposals(175.3 M)(261 M)(446.1 M)
Increasing
Stable
Issuance Purchase of Equity Shares(305.8 M)(372 M)(259.4 M)
Decreasing
Stable
Issuance Repayment of Debt Securities 305.9 M260 M126.8 M
Increasing
Stable
Payment of Dividends and Other Cash Distributions (148.9 M)(150 M)(128.2 M)
Decreasing
Slightly volatile
Net Cash Flow from Financing(714.2 M)(268 M)(351.6 M)
Decreasing
Stable
Net Cash Flow from Investing(335.8 M)(238 M)(476.1 M)
Increasing
Stable
Net Cash Flow Investment Acquisitions and Disposals(42.1 M)162 M123.6 M
Decreasing
Very volatile
Net Cash Flow from Operations835 M793 M756 M
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (25.8 M)(1000 K)(4.9 M)
Decreasing
Slightly volatile
Share Based Compensation58.9 M58 M65.1 M
Increasing
Stable
Cash Beginning of Year2.2 B2 B2.2 B
Increasing
Stable
Cash End of Year2.3 B2.3 B2.4 B
Increasing
Stable

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.57680.5510.6221
Decreasing
Slightly volatile
Book Value per Share13.495813.01512.2861
Increasing
Slightly volatile
Current Ratio3.223.8473.0709
Increasing
Slightly volatile
Debt to Equity Ratio45.10.8384.8291
Increasing
Slightly volatile
Share Dilution Ratio1.05891.0061.0159
Increasing
Stable
Dividend Yield0.01290.0110.0134
Decreasing
Slightly volatile
Dividends per Basic Common Share0.45260.460.4169
Decreasing
Stable
EBITDA Margin0.20740.2050.1955
Increasing
Slightly volatile
Earnings per Basic Share1.37891.421.6349
Increasing
Very volatile
Earnings per Diluted Share1.941.41.6592
Increasing
Stable
EPS Diluted Growth(0.3584)(0.1946)(3.4966)
Increasing
Stable
EPS Growth(0.3616)(0.2053)(4.1926)
Increasing
Stable
Earnings per Basic Share USD1.37891.421.6349
Increasing
Very volatile
Enterprise Value over EBIT23.684222.022.9737
Decreasing
Stable
Enterprise Value over EBITDA16.792116.03411.7377
Increasing
Slightly volatile
Free Cash Flow per Share7.962.0062.2714
Increasing
Slightly volatile
Gross Margin0.54110.5230.5105
Increasing
Slightly volatile
Financial Leverage0.90190.87030.8539
Increasing
Very volatile
Leverage Ratio1.94281.77982.1699
Decreasing
Slightly volatile
NCFO Growth(0.4516)(0.3094)(0.5333)
Increasing
Slightly volatile
Net Income Growth(0.3629)(0.2044)(4.5245)
Increasing
Stable
Profit Margin0.14410.110.114
Increasing
Slightly volatile
Payout Ratio0.34580.3240.2443
Decreasing
Very volatile
Price to Book Value4.83.3312.643
Increasing
Slightly volatile
Price to Earnings Ratio35.4330.6834.351
Increasing
Slightly volatile
Price to Sales Ratio5.033.382.4045
Increasing
Slightly volatile
Revenue Growth(0.257)(0.4216)(0.0491)
Decreasing
Slightly volatile
Return on Average Assets0.06290.0610.0654
Increasing
Very volatile
Return on Average Equity0.14130.110.1405
Decreasing
Very volatile
Return on Invested Capital0.18320.1860.1788
Increasing
Stable
Return on Sales0.14370.1470.1362
Increasing
Slightly volatile
Weighted Average Share Growth0.0016(0.006)(0.0145)
Increasing
Slightly volatile
Sales per Share13.166312.8914.6913
Decreasing
Slightly volatile
Tax Efficiency0.84910.90520.9161
Decreasing
Stable
Tangible Assets Book Value per Share15.318414.9617.995
Decreasing
Slightly volatile
Total Assets Per Share24.570724.120425.6751
Increasing
Stable
Cash Flow Per Share2.072.45162.4382
Decreasing
Very volatile
Return on Investment9.363310.269710.7588
Decreasing
Very volatile
Operating Margin18.3214.635912.9118
Increasing
Slightly volatile
Calculated Tax Rate12.538715.073553.6903
Decreasing
Stable
Receivables Turnover6.24096.77537.026
Decreasing
Slightly volatile
Inventory Turnover3.26833.73373.5176
Decreasing
Slightly volatile
PPandE Turnover6.04176.74266.2233
Decreasing
Stable
Cash and Equivalents Turnover1.7791.84852.1913
Decreasing
Slightly volatile
Accounts Payable Turnover13.866915.636314.7096
Decreasing
Stable
Accrued Expenses Turnover8.5949.76818.2232
Increasing
Slightly volatile
Interest Coverage9.962910.08220.8964
Decreasing
Slightly volatile
Long Term Debt to Equity0.44620.45060.5788
Decreasing
Slightly volatile
Quick Ratio3.15533.08182.3745
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets37.217434.478333.1084
Increasing
Slightly volatile
Revenue to Assets0.56760.53860.6241
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets7.9 B7.6 B8.5 B
Decreasing
Very volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA1 B862 M988.8 M
Increasing
Very volatile
Earnings Before Interest Taxes and Depreciation Amortization USD854.7 M862 M975.1 M
Decreasing
Very volatile
Earnings before Tax519.5 M544 M590.9 M
Increasing
Very volatile
Average Equity4.4 B4.2 B4.2 B
Increasing
Stable
Enterprise Value21.7 B13.8 B10.8 B
Increasing
Slightly volatile
Free Cash Flow568.4 M654 M588.7 M
Increasing
Slightly volatile
Invested Capital3.5 B3.3 B4 B
Decreasing
Slightly volatile
Invested Capital Average3.4 B3.3 B3.9 B
Decreasing
Stable
Market Capitalization22.1 B14.1 B11.2 B
Increasing
Slightly volatile
Tangible Asset Value5 B4.9 B6.2 B
Decreasing
Slightly volatile
Working Capital2.7 B2.7 B2.9 B
Increasing
Very volatile
Revenue Per Employee356.6 K335.2 K645.7 K
Decreasing
Slightly volatile
Net Income Per Employee37.3 K36.9 K73.4 K
Decreasing
Slightly volatile