Automatic Data Financial Statements Trends

ADP -- USA Stock  

USD 137.55  0.43  0.31%

This module enables investors to look at Automatic Data 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 1.8 B, Cost of Revenue of 8 B or Earning Before Interest and Taxes EBIT of 2.7 B, but also many exotic indicators such as Long Term Debt to Equity of 0.527, Calculated Tax Rate of 39.0262 or PPandE Turnover of 20.1655. This module is a perfect complement to use when analyzing Automatic Data Valuation or Volatility. It can also complement various Automatic Data Technical models. Check also analysis of Automatic Data Correlation with competitors.

Balance Sheet

Current ValueLast YearHistorical Average 10 Year Trend
Total Assets19.8 B43.7 B32 B
Increasing
Slightly volatile
Cash and Equivalents2.3 B3.2 B2.1 B
Increasing
Slightly volatile
Investments65.3 M55.5 M378.7 M
Decreasing
Stable
Investments Current31.3 M26.6 M236.5 M
Decreasing
Very volatile
Investments Non Current34 M28.9 M142.1 M
Decreasing
Slightly volatile
Deferred Revenue722.7 M614.3 M655.9 M
Increasing
Stable
Trade and Non Trade Receivables2.1 B1.8 B1.6 B
Increasing
Slightly volatile
Trade and Non Trade Payables459.6 M390.7 M353.4 M
Increasing
Slightly volatile
Goodwill and Intangible Assets2.6 B2.2 B2.7 B
Decreasing
Stable
Total Liabilities46.1 B39.2 B29.2 B
Increasing
Slightly volatile
Shareholders Equity5.3 B4.5 B5.3 B
Decreasing
Stable
Accumulated Retained Earnings Deficit16.5 B14 B12.5 B
Increasing
Slightly volatile
Accumulated Other Comprehensive Income(253.1 M)(215.1 M)(19.6 M)
Decreasing
Slightly volatile
Current Assets3.7 B39.5 B25.4 B
Increasing
Slightly volatile
Assets Non Current4.9 B4.2 B5.6 B
Decreasing
Slightly volatile
Current Liabilities2 B35.8 B23 B
Increasing
Slightly volatile
Liabilities Non Current3.9 B3.3 B2.9 B
Decreasing
Stable
Tax Liabilities328.6 M279.3 M325.4 M
Decreasing
Slightly volatile
Total Debt2 B2 B954.3 M
Increasing
Slightly volatile
Debt Current2.6 B2.2 B1.3 B
Increasing
Slightly volatile
Debt Non Current2.4 B2 B722 M
Increasing
Slightly volatile
Shareholders Equity USD5.3 B4.5 B5.3 B
Decreasing
Stable
Cash and Equivalents USD3.8 B3.2 B2.2 B
Increasing
Slightly volatile
Total Debt USD2.4 B2 B984.4 M
Increasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Revenues13.1 B11.7 B10.3 B
Increasing
Slightly volatile
Cost of Revenue8 B6.8 B5.9 B
Increasing
Slightly volatile
Operating Expenses3.1 B2.6 B2.4 B
Increasing
Slightly volatile
Interest Expense66.1 M56.2 M34.1 M
Increasing
Stable
Income Tax Expense871.5 M740.8 M720.9 M
Increasing
Slightly volatile
Net Income from Discontinued Operations1.1 M900 K(114.6 M)
Increasing
Slightly volatile
Consolidated Income1.8 B1.5 B1.4 B
Increasing
Slightly volatile
Net Income1.8 B1.5 B1.4 B
Increasing
Slightly volatile
Net Income Common Stock1.8 B1.5 B1.4 B
Increasing
Slightly volatile
Weighted Average Shares440.5 M457 M524.9 M
Decreasing
Slightly volatile
Weighted Average Shares Diluted540.1 M459.1 M538 M
Decreasing
Slightly volatile
Earning Before Interest and Taxes EBIT2.7 B2.3 B2.1 B
Increasing
Slightly volatile
Revenues USD13.7 B11.7 B10.4 B
Increasing
Slightly volatile
Net Income Common Stock USD1.8 B1.5 B1.4 B
Increasing
Slightly volatile
Earning Before Interest and Taxes USD2.7 B2.3 B2.1 B
Increasing
Slightly volatile
Gross Profit5.3 B4.8 B4.4 B
Increasing
Slightly volatile
Operating Income2.6 B2.2 B2 B
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(435.6 M)(370.3 M)(297 M)
Decreasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals190.8 M162.2 M24.7 M
Increasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals(10.4 B)(8.9 B)(3.9 B)
Decreasing
Slightly volatile
Net Cash Flow from Financing10.3 B8.8 B3 B
Increasing
Slightly volatile
Issuance Repayment of Debt Securities 2.3 B2 B688.5 M
Increasing
Slightly volatile
Issuance Purchase of Equity Shares(1.3 B)(1.1 B)(780.1 M)
Decreasing
Slightly volatile
Payment of Dividends and Other Cash Distributions (1.1 B)(943.6 M)(795 M)
Decreasing
Slightly volatile
Net Cash Flow from Investing(10.7 B)(9.1 B)(4.2 B)
Decreasing
Slightly volatile
Net Cash Flow from Operations1.9 B1.9 B1.8 B
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (12.9 M)(11 M)(15.2 M)
Decreasing
Stable
Net Cash Flow or Change in Cash and Cash Equivalents1.8 B1.6 B604.2 M
Increasing
Slightly volatile
Share Based Compensation117.9 M100.2 M92.3 M
Increasing
Very volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Earnings per Basic Share3.84713.272.7631
Increasing
Slightly volatile
Earnings per Diluted Share3.993.252.7558
Increasing
Slightly volatile
Earnings per Basic Share USD3.84713.272.7631
Increasing
Slightly volatile
Dividends per Basic Common Share2.44712.081.5789
Increasing
Slightly volatile
Return on Average Equity0.43720.3350.2732
Increasing
Slightly volatile
Return on Average Assets0.03440.0350.0401
Decreasing
Slightly volatile
Return on Invested Capital0.59650.5070.6352
Decreasing
Very volatile
Gross Margin0.48710.4140.4384
Decreasing
Slightly volatile
Profit Margin0.1360.1280.1359
Decreasing
Slightly volatile
EBITDA Margin0.260.2210.2407
Decreasing
Slightly volatile
Return on Sales0.23060.1960.2108
Decreasing
Stable
Asset Turnover0.32470.2760.3022
Decreasing
Slightly volatile
Payout Ratio0.74820.6360.5598
Increasing
Slightly volatile
Enterprise Value over EBITDA18.671815.87113.4387
Increasing
Slightly volatile
Enterprise Value over EBIT20.017.014.5833
Increasing
Slightly volatile
Price to Earnings Ratio33.8928.09524.2536
Increasing
Slightly volatile
Sales per Share30.036525.53120.583
Increasing
Slightly volatile
Price to Sales Ratio4.563.5983.2677
Increasing
Slightly volatile
Price to Book Value14.849.3387.0237
Increasing
Slightly volatile
Debt to Equity Ratio49.78.7449.0871
Increasing
Slightly volatile
Dividend Yield0.02710.0230.0252
Decreasing
Very volatile
Current Ratio1.051.1021.1913
Decreasing
Slightly volatile
Free Cash Flow per Share5.213.263.0357
Increasing
Slightly volatile
Book Value per Share11.62829.88410.4212
Increasing
Slightly volatile
Tangible Assets Book Value per Share10891.42964.5408
Increasing
Slightly volatile
Total Assets Per Share11395.830674.4253
Increasing
Slightly volatile
Cash Flow Per Share4.80174.08143.7141
Increasing
Slightly volatile
Return on Investment45.583438.745933.8759
Increasing
Slightly volatile
Operating Margin21.2818.773919.0318
Decreasing
Very volatile
Calculated Tax Rate39.026233.172234.4005
Increasing
Very volatile
Receivables Turnover8.32257.07427.504
Decreasing
Stable
PPandE Turnover20.165517.140615.2379
Increasing
Slightly volatile
Cash and Equivalents Turnover5.6684.81785.6608
Decreasing
Very volatile
Accounts Payable Turnover78.946567.104566.2894
Increasing
Slightly volatile
Accrued Expenses Turnover16.022113.618814.231
Decreasing
Stable
Long Term Debt to Equity0.5270.4480.1591
Increasing
Slightly volatile
Quick Ratio0.16270.13830.2684
Decreasing
Slightly volatile
Net Current Assets as percentage of Total Assets9.84128.3657.0081
Increasing
Slightly volatile
Revenue to Assets0.31430.26720.3156
Decreasing
Slightly volatile

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Earnings before Tax2.6 B2.2 B2.1 B
Increasing
Slightly volatile
Market Capitalization59.6 B41.8 B34.8 B
Increasing
Slightly volatile
Enterprise Value59 B40.9 B33.4 B
Increasing
Slightly volatile
Invested Capital5.3 B4.5 B4.9 B
Decreasing
Stable
Average Equity5.2 B4.5 B5.4 B
Decreasing
Stable
Average Assets49.7 B42.3 B35.3 B
Increasing
Slightly volatile
Invested Capital Average5.3 B4.5 B4.4 B
Decreasing
Stable
Tangible Asset Value48.8 B41.5 B31.9 B
Increasing
Slightly volatile
Free Cash Flow1.8 B1.5 B1.5 B
Increasing
Slightly volatile
Working Capital1.7 B3.7 B2.4 B
Increasing
Slightly volatile
Revenue Per Employee240.2 K204.1 K198.1 K
Increasing
Slightly volatile
Net Income Per Employee30.7 K26.1 K26.1 K
Increasing
Stable

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  

Automatic Data Upcoming Company Events

Upcoming Quarterly ReportApril 27, 2017
Next Earnings ReportJuly 27, 2017
Check also analysis of Automatic Data Correlation with competitors. Please also try Price Transformation module to use price transformation models to analyze depth of different equity instruments across global markets.