Agilent Technologies Financial Statements Trends

A -- USA Stock  

USD 69.31  0.20  0.29%

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 413.1 M or Cost of Revenue of 2.8 B, but also many exotic indicators such as Interest Coverage of 15.8293 or Long Term Debt to Equity of 0.6229. 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 B7 B8.7 B
Decreasing
Slightly volatile
Cash and Equivalents2.2 B2.1 B2.5 B
Decreasing
Stable
Investments166.7 M155.2 M137.7 M
Decreasing
Stable
Investments Current61.5 M16.1 M36.7 M
Decreasing
Slightly volatile
Investments Non Current158.5 M155.2 M134.5 M
Decreasing
Very volatile
Deferred Revenue249.8 M242.1 M308.5 M
Decreasing
Slightly volatile
Property Plant and Equipment Net969.9 M734.9 M915.7 M
Decreasing
Slightly volatile
Inventory789.4 M613 M775.1 M
Decreasing
Slightly volatile
Tax Assets981.5 M987.3 M1.1 B
Decreasing
Slightly volatile
Trade and Non Trade Receivables847 M725.6 M768.8 M
Decreasing
Slightly volatile
Trade and Non Trade Payables370.2 M295.6 M356.1 M
Decreasing
Slightly volatile
Goodwill and Intangible Assets2.1 B2.6 B2.7 B
Increasing
Stable
Total Liabilities3.5 B3.2 B4.2 B
Decreasing
Slightly volatile
Shareholders Equity3.7 B3.8 B4.4 B
Decreasing
Slightly volatile
Accumulated Retained Earnings Deficit4 B5.5 B5 B
Increasing
Slightly volatile
Accumulated Other Comprehensive Income(350.4 M)(578.5 M)(275.3 M)
Decreasing
Slightly volatile
Current Assets3.6 B3.3 B4.4 B
Decreasing
Slightly volatile
Assets Non Current3.6 B3.8 B4.2 B
Decreasing
Very volatile
Current Liabilities945 M1.1 B1.5 B
Decreasing
Slightly volatile
Liabilities Non Current2.3 B2.3 B2.7 B
Increasing
Very volatile
Tax Liabilities284.5 M147.2 M159.1 M
Decreasing
Very volatile
Total Debt1.8 B1.7 B2.1 B
Decreasing
Slightly volatile
Debt Current538.1 M287.5 M485.9 M
Decreasing
Slightly volatile
Debt Non Current1.7 B1.7 B1.9 B
Decreasing
Very volatile
Shareholders Equity USD3.7 B3.8 B4.4 B
Decreasing
Slightly volatile
Cash and Equivalents USD2.2 B2.1 B2.5 B
Decreasing
Stable
Total Debt USD1.8 B1.7 B2.1 B
Decreasing
Slightly volatile

Agilent Technologies Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Revenues5 B4.8 B5.1 B
Decreasing
Slightly volatile
Cost of Revenue2.8 B2.3 B2.6 B
Decreasing
Slightly volatile
Selling General and Administrative Expense1.7 B1.4 B1.6 B
Decreasing
Slightly volatile
Research and Development Expense582.6 M378.4 M521.7 M
Decreasing
Slightly volatile
Operating Expenses2.3 B1.8 B2.1 B
Decreasing
Slightly volatile
Interest Expense98 M82.8 M87.8 M
Decreasing
Slightly volatile
Income Tax Expense88.8 M94.3 M31.9 M
Increasing
Slightly volatile
Net Loss Income from Discontinued Operations(218.1 M)42.5 M(41.2 M)
Increasing
Stable
Consolidated Income413.1 M415.8 M576.8 M
Decreasing
Slightly volatile
Net Income1.1 B415.8 M635.7 M
Decreasing
Very volatile
Net Income Common Stock413.1 M415.8 M576.8 M
Decreasing
Slightly volatile
Weighted Average Shares317.5 M374.9 M348.1 M
Decreasing
Slightly volatile
Weighted Average Shares Diluted429.2 M378.4 M361 M
Decreasing
Stable
Earning Before Interest and Taxes EBIT539.3 M554.4 M680.7 M
Decreasing
Stable
Revenues USD5.6 B4.8 B5.2 B
Decreasing
Slightly volatile
Net Income Common Stock USD413.1 M415.8 M576.8 M
Decreasing
Slightly volatile
Earning Before Interest and Taxes USD539.3 M554.4 M680.7 M
Decreasing
Stable
Gross Profit2.7 B2.5 B2.6 B
Decreasing
Slightly volatile
Operating Income390.3 M553.5 M507.8 M
Increasing
Stable

Agilent Technologies Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(127.3 M)(125.1 M)(155.4 M)
Increasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals(233.4 M)(300.1 M)(485 M)
Increasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals77.6 M145.8 M158.6 M
Decreasing
Stable
Net Cash Flow from Financing(376.4 M)(308.2 M)(361.7 M)
Decreasing
Very volatile
Issuance Repayment of Debt Securities 280.6 M299 M108.1 M
Increasing
Stable
Issuance Purchase of Equity Shares(371.5 M)(334.8 M)(250.8 M)
Decreasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (174 M)(172.5 M)(139.8 M)
Decreasing
Slightly volatile
Net Cash Flow from Investing(302.8 M)(273.7 M)(481.6 M)
Increasing
Stable
Net Cash Flow from Operations643.2 M713.7 M768.6 M
Increasing
Very volatile
Effect of Exchange Rate Changes on Cash (382.6 K)(1.1 M)(4.5 M)
Decreasing
Stable
Net Cash Flow or Change in Cash and Cash Equivalents219.9 M328.9 M92.1 M
Increasing
Very volatile
Share Based Compensation78.4 M66.7 M64.3 M
Increasing
Stable
Depreciation Amortization and Accretion325.3 M282.9 M320.4 M
Decreasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share1.22421.2781.6952
Decreasing
Stable
Earnings per Diluted Share3.441.261.8575
Increasing
Very volatile
Earnings per Basic Share USD1.22421.2781.6952
Decreasing
Stable
Dividends per Basic Common Share0.5920.5290.4759
Decreasing
Stable
Return on Average Equity0.22930.0990.1471
Decreasing
Stable
Return on Average Assets0.07030.05490.0683
Decreasing
Stable
Return on Invested Capital0.1560.16740.1794
Decreasing
Very volatile
Gross Margin0.45540.47070.4974
Increasing
Very volatile
Profit Margin0.22250.0990.1285
Increasing
Stable
EBITDA Margin0.17120.18450.2038
Increasing
Very volatile
Return on Sales0.11920.13230.1422
Increasing
Stable
Asset Turnover0.71050.63370.6136
Decreasing
Slightly volatile
Payout Ratio0.39010.37260.2956
Increasing
Very volatile
Enterprise Value over EBITDA11.024414.430611.7565
Increasing
Slightly volatile
Enterprise Value over EBIT23.121725.321.9518
Decreasing
Stable
Price to Earnings Ratio20.0727.614723.6225
Increasing
Stable
Sales per Share11.811611.60114.2145
Decreasing
Slightly volatile
Price to Sales Ratio4.373.0422.6877
Increasing
Slightly volatile
Price to Book Value4.272.99792.7383
Increasing
Slightly volatile
Debt to Equity Ratio35.00.75423.8058
Increasing
Slightly volatile
Dividend Yield0.01680.01270.0144
Decreasing
Slightly volatile
Current Ratio3.413.46233.2026
Increasing
Slightly volatile
Free Cash Flow per Share6.81.80542.2833
Increasing
Slightly volatile
Book Value per Share10.633711.713512.9021
Decreasing
Very volatile
Tangible Assets Book Value per Share14.348913.46417.2016
Decreasing
Slightly volatile
Total Assets Per Share22.347921.708325.7048
Decreasing
Slightly volatile
Cash Flow Per Share2.20282.20642.5592
Decreasing
Slightly volatile
Return on Investment12.553711.810111.4627
Decreasing
Stable
Operating Margin24.2513.172314.4885
Increasing
Slightly volatile
Calculated Tax Rate44.825517.334612.596
Increasing
Slightly volatile
Receivables Turnover8.22857.79167.2207
Decreasing
Very volatile
Inventory Turnover4.29834.29383.6345
Increasing
Stable
PPandE Turnover7.66447.7546.5285
Increasing
Slightly volatile
Cash and Equivalents Turnover2.43122.12582.0916
Decreasing
Very volatile
Accounts Payable Turnover17.975317.981715.1181
Increasing
Slightly volatile
Accrued Expenses Turnover8.00878.79138.607
Increasing
Slightly volatile
Interest Coverage15.829311.594316.5002
Decreasing
Slightly volatile
Long Term Debt to Equity0.62290.51820.5085
Decreasing
Stable
Quick Ratio2.39692.77372.4328
Increasing
Slightly volatile
Net Current Assets as percentage of Total Assets30.041531.030532.7526
Increasing
Very volatile
Revenue to Assets0.69550.61940.6175
Decreasing
Slightly volatile

Agilent Technologies Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax480.4 M489.6 M605.3 M
Decreasing
Stable
Earnings Before Interest Taxes and Depreciation Amortization EBITDA1.2 B775.8 M1 B
Decreasing
Stable
Earnings Before Interest Taxes and Depreciation Amortization USD784.1 M775.8 M989.3 M
Decreasing
Slightly volatile
Market Capitalization21.9 B12.7 B12.4 B
Increasing
Slightly volatile
Enterprise Value21.6 B12.4 B12.2 B
Increasing
Slightly volatile
Invested Capital3.3 B3 B3.9 B
Decreasing
Slightly volatile
Average Equity3.7 B3.8 B4.3 B
Decreasing
Stable
Average Assets7 B6.9 B8.4 B
Decreasing
Slightly volatile
Invested Capital Average4.3 B3.8 B3.9 B
Decreasing
Stable
Tangible Asset Value6.8 B5.6 B6.2 B
Decreasing
Slightly volatile
Free Cash Flow508 M588.6 M612.5 M
Increasing
Very volatile
Working Capital2.7 B2.4 B3 B
Decreasing
Slightly volatile
Revenue Per Employee611.5 K385.5 K512.5 K
Decreasing
Slightly volatile
Net Income Per Employee69 K42.4 K59.8 K
Decreasing
Slightly volatile

Agilent Technologies Fundamental Market Drivers

Short Percent Of Float1.02%
Forward Price Earnings20.33
Shares Short Prior Month4.02M
Average Daily Volume Last 10 Day4.22M
Average Daily Volume In Three Month2.12M
Date Short InterestApril 30, 2019
Fifty Day Average77.97
Two Hundred Day Average73.74

Agilent Technologies Upcoming Events

Upcoming Quarterly ReportMay 15, 2017
Next Earnings ReportAugust 16, 2017
Search macroaxis.com