Automatic Data Financial Statements Trends

Automatic Data Processing Inc -- USA Stock  

USD 116.46  1.73  1.46%

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.6 B, Cost of Revenue of 7 B or Earning Before Interest and Taxes EBIT of 2.4 B, but also many exotic indicators such as Long Term Debt to Equity of 0.2368, Calculated Tax Rate of 35.1038 or PPandE Turnover of 16.9617. 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
Accumulated Other Comprehensive Income(250.4 M)(215.1 M)21.5 M
Decreasing
Slightly volatile
Total Assets19.8 B43.7 B30.3 B
Increasing
Slightly volatile
Current Assets3.7 B39.5 B23.7 B
Increasing
Slightly volatile
Assets Non Current4.5 B4.2 B5.7 B
Decreasing
Slightly volatile
Cash and Equivalents2.5 B3.2 B1.9 B
Increasing
Slightly volatile
Cash and Equivalents USD2.5 B3.2 B1.9 B
Increasing
Slightly volatile
Total Debt2.1 B2 B803.1 M
Increasing
Slightly volatile
Debt Current2.6 B2.2 B1.1 B
Increasing
Slightly volatile
Debt Non Current1.1 B2 B450.7 M
Increasing
Slightly volatile
Total Debt USD1.1 B2 B714.1 M
Increasing
Slightly volatile
Deferred Revenue634.5 M614.3 M668.3 M
Increasing
Very volatile
Shareholders Equity4.9 B4.5 B5.4 B
Decreasing
Stable
Shareholders Equity USD4.9 B4.5 B5.4 B
Decreasing
Stable
Goodwill and Intangible Assets2.4 B2.2 B2.8 B
Decreasing
Stable
Investments65.3 M55.5 M436 M
Decreasing
Stable
Investments Current31.3 M26.6 M289.9 M
Decreasing
Very volatile
Investments Non Current34 M28.9 M146.1 M
Decreasing
Slightly volatile
Total Liabilities35.5 B39.2 B26.7 B
Increasing
Slightly volatile
Current Liabilities2 B35.8 B21.4 B
Increasing
Slightly volatile
Liabilities Non Current2.4 B3.3 B2.6 B
Decreasing
Stable
Trade and Non Trade Payables427.2 M390.7 M340.9 M
Increasing
Slightly volatile
Property Plant and Equipment Net714.6 M685 M695.1 M
Increasing
Very volatile
Trade and Non Trade Receivables1.8 B1.8 B1.5 B
Increasing
Slightly volatile
Accumulated Retained Earnings Deficit14.5 B14 B12 B
Increasing
Slightly volatile
Tax Liabilities251.9 M279.3 M331.4 M
Decreasing
Slightly volatile

Income Statement

Current ValueLast YearHistorical Average 10 Year Trend
Consolidated Income1.6 B1.5 B1.4 B
Increasing
Slightly volatile
Cost of Revenue7 B6.8 B5.7 B
Increasing
Slightly volatile
Earning Before Interest and Taxes EBIT2.4 B2.3 B2.1 B
Increasing
Slightly volatile
Earning Before Interest and Taxes USD2.4 B2.3 B2.1 B
Increasing
Slightly volatile
Gross Profit5.1 B4.8 B4.3 B
Increasing
Slightly volatile
Interest Expense33 M56.2 M33.4 M
Decreasing
Stable
Net Income1.8 B1.5 B1.4 B
Increasing
Slightly volatile
Net Income Common Stock1.6 B1.5 B1.4 B
Increasing
Slightly volatile
Net Income Common Stock USD1.6 B1.5 B1.4 B
Increasing
Slightly volatile
Net Income from Discontinued Operations(39.5 M)900 K(124.7 M)
Increasing
Slightly volatile
Operating Expenses2.7 B2.6 B2.4 B
Increasing
Slightly volatile
Operating Income2.2 B2.2 B1.9 B
Increasing
Slightly volatile
Revenues12.5 B11.7 B10 B
Increasing
Slightly volatile
Revenues USD11.9 B11.7 B10 B
Increasing
Slightly volatile
Selling General and Administrative Expense2.7 B2.6 B2.3 B
Increasing
Slightly volatile
Weighted Average Shares443.5 M457 M536.6 M
Decreasing
Slightly volatile
Weighted Average Shares Diluted492.1 M459.1 M545.8 M
Decreasing
Slightly volatile
Income Tax Expense805.5 M740.8 M707.6 M
Increasing
Slightly volatile

Cash Flow Statement

Trends Matrix
Current ValueLast YearHistorical Average 10 Year Trend
Capital Expenditure(359.1 M)(370.3 M)(282.8 M)
Decreasing
Slightly volatile
Depreciation Amortization and Accretion298.2 M288.6 M296.8 M
Decreasing
Slightly volatile
Net Cash Flow or Change in Cash and Cash Equivalents635.5 M1.6 B305.4 M
Increasing
Slightly volatile
Net Cash Flow Business Acquisitions and Disposals472.5 M162.2 M35.9 M
Increasing
Slightly volatile
Issuance Purchase of Equity Shares(1.3 B)(1.1 B)(800.4 M)
Decreasing
Slightly volatile
Issuance Repayment of Debt Securities (93.9 M)2 B320.5 M
Increasing
Stable
Payment of Dividends and Other Cash Distributions (984.8 M)(943.6 M)(751.7 M)
Decreasing
Slightly volatile
Net Cash Flow from Financing5.5 B8.8 B1.4 B
Increasing
Slightly volatile
Net Cash Flow from Investing(6.8 B)(9.1 B)(2.9 B)
Decreasing
Slightly volatile
Net Cash Flow Investment Acquisitions and Disposals(6.9 B)(8.9 B)(2.6 B)
Decreasing
Slightly volatile
Net Cash Flow from Operations2 B1.9 B1.8 B
Increasing
Slightly volatile
Effect of Exchange Rate Changes on Cash (61.7 M)(11 M)(14.9 M)
Decreasing
Slightly volatile
Share Based Compensation92.1 M100.2 M92 M
Decreasing
Slightly volatile
Cash Beginning of Year1.9 B1.6 B1.7 B
Increasing
Very volatile
Cash End of Year2.5 B3.2 B2 B
Increasing
Slightly volatile

Fundamental Ratios

Current ValueLast YearHistorical Average 10 Year Trend
Asset Turnover0.30530.2760.3041
Decreasing
Slightly volatile
Book Value per Share10.64379.88410.2396
Increasing
Slightly volatile
Current Ratio1.11.1021.1941
Decreasing
Slightly volatile
Debt to Equity Ratio53.98.7449.0139
Increasing
Slightly volatile
Share Dilution Ratio1.05981.00591.0131
Increasing
Slightly volatile
Dividend Yield0.02470.0230.0252
Increasing
Very volatile
Dividends per Basic Common Share2.08952.081.4566
Increasing
Slightly volatile
EBITDA Margin0.23790.2210.2422
Decreasing
Slightly volatile
Earnings per Basic Share3.33683.272.6214
Increasing
Slightly volatile
Earnings per Diluted Share3.943.252.6517
Increasing
Slightly volatile
EPS Diluted Growth0.12680.15880.0443
Increasing
Slightly volatile
EPS Growth0.12750.1530.045
Increasing
Slightly volatile
Earnings per Basic Share USD3.33683.272.6214
Increasing
Slightly volatile
Enterprise Value over EBIT16.842117.013.7368
Increasing
Slightly volatile
Enterprise Value over EBITDA15.825315.87112.6139
Increasing
Slightly volatile
Free Cash Flow per Share5.593.263.0054
Increasing
Slightly volatile
Gross Margin0.43470.4140.4385
Decreasing
Slightly volatile
Financial Leverage1.04550.98930.9941
Increasing
Slightly volatile
Leverage Ratio7.08547.67675.9087
Increasing
Slightly volatile
NCFO Growth0.0469(0.084)0.0013
Increasing
Very volatile
Net Income Growth0.03250.0464(0.0165)
Increasing
Slightly volatile
Profit Margin0.14080.1280.1374
Decreasing
Stable
Payout Ratio0.65890.6360.5382
Increasing
Slightly volatile
Price to Book Value13.149.3386.4597
Increasing
Slightly volatile
Price to Earnings Ratio29.6828.09523.0353
Increasing
Slightly volatile
Price to Sales Ratio4.143.5983.1413
Increasing
Slightly volatile
Revenue Growth(0.0236)(0.0348)0.0014
Increasing
Stable
Return on Average Assets0.04260.0350.0416
Decreasing
Slightly volatile
Return on Average Equity0.43060.3350.2646
Increasing
Slightly volatile
Return on Invested Capital0.68210.5070.6144
Increasing
Stable
Return on Sales0.21160.1960.2116
Decreasing
Slightly volatile
Weighted Average Share Growth(0.087)(0.0399)(0.0472)
Decreasing
Very volatile
Sales per Share25.618925.53119.3125
Increasing
Slightly volatile
Tax Efficiency0.68960.67220.6655
Decreasing
Very volatile
Tangible Assets Book Value per Share82.9991.42957.8162
Increasing
Slightly volatile
Total Assets Per Share87.801295.830668.2369
Increasing
Slightly volatile
Cash Flow Per Share4.29854.08143.6215
Increasing
Slightly volatile
Return on Investment35.898338.745932.6246
Increasing
Slightly volatile
Operating Margin19.0418.773918.9195
Decreasing
Slightly volatile
Calculated Tax Rate35.103833.172234.3
Decreasing
Stable
Receivables Turnover7.16317.07427.5204
Decreasing
Slightly volatile
PPandE Turnover16.961717.140614.5371
Increasing
Slightly volatile
Cash and Equivalents Turnover5.71394.81785.8108
Increasing
Very volatile
Accounts Payable Turnover66.933267.104565.4666
Increasing
Slightly volatile
Accrued Expenses Turnover13.608613.618814.1638
Decreasing
Slightly volatile
Long Term Debt to Equity0.23680.4480.0984
Increasing
Slightly volatile
Quick Ratio0.13520.13830.2671
Decreasing
Slightly volatile
Net Current Assets as percentage of Total Assets7.09788.3656.5975
Increasing
Stable
Revenue to Assets0.31450.26720.3242
Decreasing
Stable

Valuation Data

Current ValueLast YearHistorical Average 10 Year Trend
Average Assets41.2 B42.3 B33.4 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization EBITDA2.7 B2.6 B2.4 B
Increasing
Slightly volatile
Earnings Before Interest Taxes and Depreciation Amortization USD2.7 B2.6 B2.4 B
Increasing
Slightly volatile
Earnings before Tax2.4 B2.2 B2.1 B
Increasing
Slightly volatile
Average Equity5.1 B4.5 B5.4 B
Decreasing
Very volatile
Enterprise Value51.6 B40.9 B31.1 B
Increasing
Slightly volatile
Free Cash Flow1.6 B1.5 B1.5 B
Increasing
Slightly volatile
Invested Capital3.7 B4.5 B6.1 B
Decreasing
Slightly volatile
Invested Capital Average3.9 B4.5 B4.9 B
Decreasing
Slightly volatile
Market Capitalization51.9 B41.8 B32.4 B
Increasing
Slightly volatile
Tangible Asset Value38 B41.5 B29.2 B
Increasing
Slightly volatile
Working Capital1.7 B3.7 B2.2 B
Increasing
Slightly volatile
Revenue Per Employee212.1 K204.1 K194.2 K
Increasing
Slightly volatile
Net Income Per Employee27.6 K26.1 K25.8 K
Increasing
Very volatile