Showing posts with label ADP. Show all posts
Showing posts with label ADP. Show all posts

14 February 2011

ADP: Financial Gauge Analysis for the December 2010 Quarter

Automatic Data Processing (NASDAQ: ADP) earned $0.62 per diluted share on a GAAP basis in the December-ending second quarter of fiscal 2011, unchanged from the same three months of 2009. 

A previous article examined ADP's Income Statement for the September quarter.  Reported earnings were $0.02 more than our $0.60 EPS estimate.

We have now updated the various financial metrics we use to analyze Cash Management, Growth, Profitability and Value.  This post reports on the metrics for ADP and the associated financial gauge scores.  The metrics were calculated using data from ADP's current and historical financial statements, including those in the latest 10-Q.


Before getting into the details, we will take a step back to introduce the subject of today's analysis.

Automatic Data Processing performs payroll, human resource, data processing, and outsourcing Business Services for well over 500,000 clients, large and small, in the United States and other countries.  ADP pays one of every six private sector employees in the U.S.

ADP is one of four remaining U.S. companies with a AAA bond rating.  An S&P 500 Dividend Aristocrat, ADP recently announced its 36th-consecutive annual dividend increase. 

18 December 2010

ADP: Look Ahead to December 2010 Quarterly Results

This post describes our model of Automatic Data Processing's (NASDAQ: ADP) Income Statement for the December-ending second quarter of fiscal 2011.

The purpose of the model is to establish a baseline for identifying surprises, positive or negative, in the quarterly results the company will report.  Estimates for each line of the Income Statement are derived from management's guidance, the company's historical financial results, and other publicly available data.

First, we present some background information about ADP and the business environment in which it is currently operating.

Automatic Data Processing performs payroll, human resource, data processing, and outsourcing Business Services for well over 500,000 clients, large and small, in the United States and other countries.  ADP pays one of every six private sector employees in the U.S.

ADP is one of four remaining U.S. companies with a AAA bond rating.  An S&P 500 Dividend Aristocrat, ADP recently announced its 36th-consecutive annual dividend increase. 

The company has a market value of about $23 billion.

As the processor of many payrolls across the U.S., ADP quickly senses macroeconomic changes in Employment.  ADP uses the data it collects to issue the monthly ADP National Employment Report on non-farm private employment. 

Fortune Magazine deemed ADP to be Most Admired in the Financial Data Services industry.

In fiscal 2010, which ended 30 June, ADP's earnings fell to $1.21 billion from $1.33 billion in the prior year.  Revenue increased to $8.93 billion from $8.84 billion.  The company's results in fiscal 2010 were weakened by high unemployment, which reduces the demand for payroll services, and low interest rates, which limits the company's interest income.

ADP has three main businesses:  Employer Services, Professional Employer Organization Services, and Dealer Services.  Employer Services processes payrolls, administers benefits, and performs other services to enable firms "to staff, manage, pay and retain their employees."  PEO Services, by establishing co-employment relationships with customers and their employees, enables businesses to outsource various functions.  In this arrangement, an ADP entity becomes the employer of record for the affected employees.  Dealer Services helps companies that sell vehicles and machinery manage their business activities.

The Employer Services business segment contributed 72 percent of total revenue in fiscal 2010.  Competitors include Paychex (NASDAQ:PAYX), the now-private Ceridian, and India's Wipro (NYSE: WIT).

Dealer Services revenue has been adversely affected by the downturn in vehicle sales and the closing of many dealerships.

ADP has recently acquired several other companies, including Italian business software developer Byte Software House, automotive marketing firm Cobalt, human resource solutions provider Workscape, and payroll tax firm MasterTax.
In 2007, ADP divested its Brokerage Services Group business, which became Broadridge Financial Solutions (NYSE: BR).  GCFR articles related to Broadridge can be found here.



Automatic Data Processing earned $0.56 per diluted share on a GAAP basis in the September-ending first quarter of fiscal 2011.  Earnings per share were unchanged from the same three months of last year. 

Readers wanting to take another look at ADP's September 2010 quarter might wish to review our Income Statement and Financial Gauge analyses.


Now, we are ready to look ahead to ADP's results for the December 2010 quarter.

In the press release on 27 October 2010 announcing its results for the September quarter, ADP updated its guidance for fiscal 2011.  Some changes to the guidance reflect the company's better-than-expected performance during the first fiscal quarter, and other adjustments are reactions to recent corporate acquisitions.

Including the results of the newly acquired companies, ADP now believes it can achieve full-year Revenue growth between 7 percent and 8 percent.  Since Revenue in fiscal 2010 was $8.93 billion, the guidance translates into a Revenue range of $9.56 billion to $9.65 billion for the fiscal year that will end in June 2011.  Let's say $9.6 billion.

In the September 2010 quarter, ADP brought in Revenue of $2.23 billion.  This leaves $9.6 billion - $2.23 billion = $7.37 billion for the final nine months of the fiscal year.

December quarters are not typically biggest producers of Revenue for ADP, so we can't simply divide $7.37 billion divided by 3.  Our specific target is $2.36 billion, 32 percent of the nine-month total.

ADP's guidance indicates that pretax operating margin expansion is expected at the company's Employer Services, but margin declines are expected at PEO Services and Dealer Services.  Acquisition costs will put negative pressure on margins.  However, since Employer Services is much bigger than the other units, the company-wide margin may be flat to slightly positive.

In fiscal 2010, the Gross Margin as a percentage of Revenue was 52.1 percent, but it was closer to 50 percent in each of the last two quarters.  Given this information and the seasonal pattern, we are setting our target for the Gross Margin in the December quarter at 51 percent.  When combined with our Revenue estimate, the margin target leads to a forecast for the Cost of Goods Sold -- what ADP calls "Operating Expenses" -- of (1 - 0.51) * $2.36 billion = $1.16 billion. 

Depreciation and amortization expenses have been around $60 million per quarter for nearly three years.  We have no reason to expect a different figure in the December 2010 quarter. 

Research and Development expenses ("Systems Development and Programming Costs") were $135 million in the September 2010 quarter.  We are looking for a similar figure in the current quarter.

Sales, General, and Administrative expenses are more variable.  In the last five fiscal years, the amount per quarter has ranged from $436 million to $697 million.  As a percentage of Revenue, SG&A has varied between 20.7 percent and 32.5 percent.  The percentages have generally been falling from year to year.   Given this data, we are expecting SG&A expenses in the December 2010 quarter will be 24 percent of Revenue, or 0.24 * $2.36 billion =  $566 million.

Rolling up these estimates yields a target for Operating Income, as we define it, of $442 million.  This is 2.4 percent less than Operating Income in the December 2009 quarter.

As for non-operating items (i.e., other income less interest expense), $15 million would seem to be a conservative estimate based on recent history. 

We're assuming the effective Income Tax Rate will match fiscal 2010's 35 percent.  This assumption leads to an estimate for Net Income of $297 million ($0.60 per share, depending on the share count).  In the year-earlier quarter, Net Income from continuing operations was $316 million ($0.62 per share).

Please click here to see a normalized depiction of the projected results next to ADP's quarterly Income Statements for the last couple of years.  Please note that our organization of revenues, expenses, gains, and losses, which we use for all analyses, can and often does differ in material respects from company-used formats.  The standardization facilitates cross-company comparisons.







Full disclosure: Long ADP at time of writing.

03 December 2010

ADP: Financial Gauge Analysis for the September 2010 Quarter

Automatic Data Processing (NASDAQ: ADP) earned $0.56 per diluted share on a GAAP basis in the September-ending first quarter of fiscal 2011.  Earnings per share were unchanged from the same three months of last year. 

A previous article examined ADP's Income Statement for the September quarter.  Reported earnings were $0.02 more than our $0.54 EPS estimate.

We have now updated the various financial metrics we use to analyze Cash Management, Growth, Profitability and Value.  This post reports on the metrics for ADP and the associated financial gauge scores.  The metrics were calculated using data from ADP's current and historical financial statements, including those in the latest 10-Q.


Before getting into the details, we will take a step back to introduce the subject of today's analysis.

Automatic Data Processing performs payroll, human resource, data processing, and outsourcing Business Services for well over 500,000 clients, large and small, in the United States and other countries.  ADP pays one of every six private sector employees in the U.S.

The company's market value is currently about $22.5 billion on a fully diluted basis.

ADP is one of four remaining U.S. companies with a AAA bond rating.  It is also an S&P 500 Dividend Aristocrat, having hiked its dividend for 35 consecutive years.  Fortune Magazine deemed ADP to be Most Admired in the Financial Data Services industry.

In fiscal 2010, which ended 30 June, ADP earned $1.2 billion on Revenue of $8.9 billion. 

ADP has three main businesses:  Employer Services, Professional Employer Organization Services, and Dealer Services.  Employer Services processes payrolls, administers benefits, and performs other services to enable firms "to staff, manage, pay and retain their employees."  PEO Services, by establishing co-employment relationships with customers and their employees, enables businesses to outsource various functions.  In this arrangement, an ADP entity becomes the employer of record for the affected employees.  Dealer Services helps dealers of vehicles and machinery manage their business activities.

In 2007, ADP divested its Brokerage Services Group business, which became Broadridge Financial Solutions (NYSE: BR).  (GCFR articles related to Broadridge can be found here.) 

Additional background information about ADP and the business environment in which it is currently operating can be found in the look-ahead.


In summary, ADP's latest quarterly results produced the following changes to the gauge scores:
  • Overall: 33 of 100 (down from 34)


The current and historical values for the financial metrics that determine the gauge scores are listed below, with some brief commentary.  Readers are encouraged to verify these figures and calculate others as they see fit using the filings available at the SEC's web site and elsewhere.

27 October 2010

ADP: Income Statement Analysis for the September 2010 Quarter

Automatic Data Processing (NASDAQ: ADP) earned $0.56 per diluted share on a GAAP basis in the September-ending first quarter of fiscal 2011.  Earnings per share were unchanged from the same three months of last year. 

This post examines ADP's Income Statement for the latest quarter and compares the entries on each line to our "look-ahead" estimates.  Reported earnings were $0.02 more than our $0.54 EPS estimate.

The principal sources for the income statement analysis were the earnings announcement and the associated webcast presentation [pdf].

In a second article, we will report ADP's scores as measured by the GCFR financial gauges.  The follow-up post will also provide the latest figures for the various financial metrics we use to analyze Cash Management, Growth, Profitability and Value.


Before getting into the details, we will take a step back to introduce the subject of today's analysis.

Automatic Data Processing performs payroll, human resource, data processing, and outsourcing Business Services for well over 500,000 clients, large and small, in the United States and other countries.  ADP pays one of every six private sector employees in the U.S.

19 September 2010

ADP: Look Ahead to September 2010 Quarterly Results

This post describes our model of Automatic Data Processing's (NASDAQ: ADP) Income Statement for the first quarter of fiscal 2011, which will end on 30 September 2010.

The purpose of the model is to establish a baseline for identifying surprises, positive or negative, in the quarterly results the company will report.  Estimates for each line of the Income Statement are derived from management's guidance, the company's historical financial results, and other publicly available data.

First, we present some background information about ADP and the business environment in which it is currently operating.

Automatic Data Processing performs payroll, human resource, data processing, and outsourcing Business Services for well over 500,000 clients, large and small, in the United States and other countries.  ADP pays one of every six private sector employees in the U.S.

ADP is one of four remaining of U.S. companies with a AAA bond rating.  It is also an S&P 500 Dividend Aristocrat, having hiked its dividend for 35 consecutive years.

Fortune Magazine deemed ADP to be Most Admired in the Financial Data Services industry.

According to its latest 10-K, ADP earned $1.2 billion on Revenue of $8.9 billion in fiscal 2010, which ended 30 June.  The company has a market value of about $20 billion.

ADP has three main businesses:  Employer Services, Professional Employer Organization Services, and Dealer Services.  Employer Services processes payrolls, administers benefits, and performs other services to enable firms "to staff, manage, pay and retain their employees."  PEO Services, by establishing co-employment relationships with customers and their employees, enables businesses to outsource various functions.  In this arrangement, an ADP entity becomes the employer of record for the affected employees.  Dealer Services helps dealers of vehicles and machinery manage their business activities.

30 August 2010

ADP: Financial Gauge Analysis for the June 2010 Quarter

Automatic Data Processing (NASDAQ: ADP) earned $0.42 per share in fiscal 2010's fourth quarter, which ended 30 June 2010.  Earnings per share were 41 percent less than the $0.70 ADP made in the same quarter of 2009. 

The prior-year result was boosted by a tax benefit of $0.24 per share.  Excluding this one-time benefit, diluted quarterly earnings from continuing operations declined from $0.45 in June 2009 to $0.42 per share in June 2010.

A previous article examined ADP's Income Statement for the June quarter.  Reported earnings fell $0.01 short of the $0.43 per share we had forecast.

We have now updated the various financial metrics we use to analyze Cash Management, Growth, Profitability and Value.  This post reports on the metrics for ADP and the associated financial gauge scores.  The metrics were calculated using data from ADP's current and historical financial statements, including those in the 10-K for fiscal 2010.


Before getting into the details, we will take a step back to introduce the subject of today's analysis.

Automatic Data Processing performs payroll, human resource, data processing, and outsourcing Business Services for more than 500,000 clients, large and small, in the United States and other countries.  ADP pays one of every six private sector employees in the U.S.  The company is one of four remaining of U.S. firms with a AAA bond rating.  It is also an S&P 500 Dividend Aristocrat, having hiked its dividend for 35 consecutive years.

Fortune Magazine deemed ADP to be Most Admired in the Financial Data Services industry. 

Additional background information about ADP and the business environment in which it is currently operating can be found in the look-ahead.

In summary, ADP's latest quarterly results produced the following changes to the gauge scores:
  • Overall: 34 of 100 (down from 36)



The current and historical values for the financial metrics that determine the gauge scores are listed below, with some brief commentary.  Readers are encouraged to verify these figures and calculate others as they see fit using the filings available at the SEC's web site and elsewhere.

29 July 2010

ADP: Income Statement Analysis for the June 2010 Quarter

Automatic Data Processing (NASDAQ: ADP) earned $0.42 per share in fiscal 2010's fourth quarter, which ended 30 June 2010.  This EPS amount was 41 percent less than the $0.70 ADP made in the same quarter of 2009. 

The prior-year result was boosted by a tax benefit of $0.24 per share.  Excluding this one-time benefit, diluted quarterly earnings from continuing operations declined from $0.45 in June 2009 to $0.42 per share in June 2010.

This post examines ADP's Income Statement for the latest quarter and compares the entries on each line to our "look-ahead" estimates.  Reported earnings fell $0.01 short of the $0.43 per share we had forecast.

The principal sources for the income statement analysis were the earnings announcement and the webcast presentation [pdf].

In a second article, we will report ADP's scores as measured by the GCFR financial gauges.  The follow-up post will also provide the latest figures for the various financial metrics we use to analyze Cash Management, Growth, Profitability and Value.


Before getting into the details, we will take a step back to introduce the subject of today's analysis.

Automatic Data Processing performs payroll, human resource, data processing, and outsourcing Business Services for more than 500,000 clients, large and small, in the United States and other countries.  ADP pays one of every six private sector employees in the U.S.  The company is one of four remaining of U.S. firms with a AAA bond rating.  It is also an S&P 500 Dividend Aristocrat, having hiked its dividend for 35 consecutive years.

Fortune Magazine deemed ADP to be Most Admired in the Financial Data Services industry.  Additional background information about ADP and the business environment in which it is currently operating can be found in the look-ahead.

Please click here to see a full-sized, normalized depiction of the actual and projected results for the just-concluded quarter, as well as the quarterly Income Statements for the last couple of years.  Please note that our organization of revenues, expenses, gains, and losses, which we use for all analyses, can and often does differ in material respects from company-used formats.  The standardization facilitates cross-company comparisons.

11 June 2010

ADP: Look Ahead to June 2010 Quarterly Results

This post describes our model of Automatic Data Processing's (NASDAQ: ADP) Income Statement for the fourth quarter of fiscal 2010, which will end on 30 June 2010.

The purpose of the model is to establish a baseline for identifying surprises, positive or negative, in the quarterly results the company will report.  Estimates for each line of the Income Statement are derived from management's guidance, the company's historical financial results, and other publicly available data.

First, we present some background information about ADP and the business environment in which it is currently operating.

Automatic Data Processing performs payroll, human resource, data processing, and outsourcing Business Services for more than 500,000 clients, large and small, in the United States and other countries.  ADP pays one of every six private sector employees in the U.S.

ADP is one of four remaining of U.S. companies with a AAA bond rating.  It is also an S&P 500 Dividend Aristocrat, having hiked its dividend for 35 consecutive years.

Fortune Magazine deemed ADP to be Most Admired in the Financial Data Services industry.

ADP earned $1.3 billion on revenue of $8.9 billion in fiscal 2009, which ended June 2009.  It has a market capitalization of about $20 billion.

The company, according to its latest 10-K, has three main businesses:  Employer Services, Professional Employer Organization Services, and Dealer Services.  Employer Services processes payrolls, administers benefits, and performs other services to enable firms "to staff, manage, pay and retain their employees."  PEO Services, by establishing co-employment relationships with customers and their employees, enables businesses to outsource various functions.  In this arrangement, an ADP entity becomes the employer of record for the affected employees.  Dealer Services helps dealers of vehicles and machinery manage their business activities.

The Employer Services business segment contributed nearly three-quarters of the total revenue in fiscal 2000.  Competitors include Paychex (NASDAQ:PAYX), the now-private Ceridian, and India's Wipro (NYSE: WIT).

As a payroll processor, ADP is sensitive to changes in Employment.  From the payroll data it collects, the company issues the monthly ADP National Employment Report on non-farm private employment.

Dealer Services revenue has been adversely affected by the downturn in vehicle sales and the closing of many dealerships.

15 May 2010

ADP: Financial Gauge Analysis for the March 2010 Quarter

Automatic Data Processing (NASDAQ: ADP) earned $0.80 per share in the fiscal 2010's third quarter, which ended 31 March 2010.  ADP made the same amount in the third quarter of 2009.

In our earlier review of ADP's Income Statement, we compared the actual results to our "look-ahead" estimates.

We have now updated the various financial metrics we use to analyze Cash Management, Growth, Profitability and Value.  This post reports on the metrics for ADP and the associated financial gauge scores.  The metrics were calculated using data from ADP's current and historical financial statements, including the latest 10-Q report.


Automatic Data Processing performs payroll, tax, and other personnel-related Business Services for over 500,000 clients, large and small.  ADP pays one of every six private sector employees in the United States.  Additional background information about ADP and the business environment in which it is currently operating can be found in the look-ahead.

In summary, ADP's latest quarterly results produced the following changes to the gauge scores:


The current and historical values for the financial metrics that determine the gauge scores are listed below, with some brief commentary.

27 April 2010

ADP: Income Statement Analysis for the March 2010 Quarter

Automatic Data Processing (NASDAQ: ADP) earned $0.80 per share in the third quarter of fiscal 2010, which ended 31 March 2010.  Earnings per share were unchanged from the March 2009 quarter.

Earnings from continuing operations were slightly less than the comparable result in the year-earlier quarter, but overall net earnings were a shade higher.

This post examines ADP's Income Statement for the latest quarter and compares the entries on each line to our "look-ahead" estimates.  Reported earnings exceeded the $0.76 per share we had forecast by $0.04.

The principal sources for the income statement analysis were the earnings announcement, the webcast presentation [pdf], and the transcript (available from Seeking Alpha).

In a second article, we will report ADP's scores as measured by the GCFR financial gauges.  The follow-up post will also provide the latest figures for the various financial metrics we use to analyze Cash Management, Growth, Profitability and Value.


Automatic Data Processing performs payroll, tax, and other personnel-related Business Services for over 500,000 clients, large and small.  ADP pays one of every six private sector employees in the United States.  Additional background information about ADP and the business environment in which it is currently operating can be found in the look-ahead.


Please click here to see a full-sized, normalized depiction of the actual and projected results for the just-concluded quarter, as well as the quarterly Income Statements for the last couple of years.  Please note that our organization of revenues, expenses, gains, and losses, which we use for all analyses, can and often does differ in material respects from company-used formats.  The standardization facilitates cross-company comparisons.

01 April 2010

ADP: Look Ahead to March 2010 Quarterly Results

This post describes our model of Automatic Data Processing's (NASDAQ: ADP) Income Statement for the third quarter of fiscal 2010, which ended on 31 March 2010.

The purpose of the model is to establish a baseline for identifying surprises, positive or negative, in the quarterly results the company will report.  Estimates for each line of the Income Statement are derived from management's guidance, the company's historical financial results, and other publicly available data.

We begin by reviewing background information about ADP and the business environment in which it is currently operating.

06 February 2010

ADP: Income Statement Analysis for the December 2009 Quarter

Automatic Data Processing (NASDAQ: ADP) earned $0.62 per share in the second quarter of fiscal 2010, which ended 31 December 2009.  This amount was 5 percent greater than the $0.59 per share earned one year earlier. 

If a favorable tax item in the latest quarter is excluded, earnings would only have increased $0.01 to $0.60 per share.

This post examines ADP's Income Statement for the quarter and compares the entries on each line to our "look-ahead" estimates.  Our target for Net Income in the latest quarter was $0.59 per share, which ADP exceeded by $0.03.

The principal sources for the income statement analysis were the earnings announcement, the webcast presentation [pdf], and the conference call transcript (available from Seeking Alpha).

23 December 2009

ADP: Look Ahead to December 2009 Quarterly Results

Automatic Data Processing (NASDAQ: ADP) earned $0.56 per share in the first quarter of fiscal 2010, which ended 30 September 2009, up from $0.54 in the same quarter of last year.

In November, we examined ADP's Income Statement for the September quarter and compared the entries on each line to our "look-ahead" estimates.  We later performed a financial gauge analysis of ADP, which determined the GCFR Overall gauge fell from 58 to 52 of the 100 possible points.

We have now modeled ADP's Income Statement for the quarter that will end on 31 December 2009.  The intent of this exercise was to produce a baseline for identifying deviations, positive or negative, in the actual data that the company will announce on 2 February 2010.  GCFR estimates are derived from trends in the historical financial results and guidance provided by company management.

18 November 2009

ADP: Financial Gauge Analysis for the September 2009 Quarter

In a previous article, we examined Automatic Data Processing's (NASDAQ: ADP) Income Statement for the first quarter of fiscal 2010 and compared the figures on each line to our "look-ahead" estimates.  Earnings in this period, which ended 30 September 2009, rose from $0.54 to $0.56 per share.

Using the financial statements in the earnings announcement and the more detailed 10-Q, we have now updated our usual set of Cash Management, Growth, Profitability and Value metrics. This post reports on the metrics and the associated financial gauge scores.

05 November 2009

ADP: Income Statement Analysis for the September 2009 Quarter

Automatic Data Processing (NASDAQ: ADP) earned $0.56 per share in the first quarter of fiscal 2010, which ended 30 September 2009, up from $0.54 in the same quarter of last year.

This post examines the Income Statement for the quarter in the earnings announcement, and it compares the entries on each line to our "look-ahead" estimates.  Our target for ADP's Net Income in the latest quarter was $0.49 per share, which ADP beat by $0.07.

In a second article, we will report ADP's scores as measured by the GCFR financial gauges. The follow-up post will also provide the latest figures for the various financial metrics we use to analyze Cash Management, Growth, Profitability and Value.

23 September 2009

ADP: Look Ahead to September 2009 Quarterly Results

The GCFR Overall Gauge of Automatic Data Processing (NASDAQ: ADP) was unchanged at 59 of the 100 possible points in the June 2009 quarter, which was the fourth quarter of ADP's fiscal year.  Our income statement, financial gauge, and gauge update analyses explained in some detail how the score was attained.

Revenue in the June quarter fell 4.5 percent because of the weak economy and unfavorable currency exchange rates.  However, a $120 million income tax benefit caused quarterly earnings to soar from $0.45 to $0.70 per share.  If this one-time benefit due to favorable settlements had not been realized, earnings per share would have been more or less flat.


We have now modeled ADP's Income Statement for the September 2009 quarter, which is the first of fiscal 2010.  The intent of this exercise was to produce a baseline for identifying deviations, positive or negative, in the actual data the company will announce in early November.  GCFR estimates are derived from trends in the historical financial results and guidance provided by company management.



03 September 2009

ADP: Financial Gauge Analysis for the June 2009 Quarter (Update)

We previously posted Automatic Data Processing's (NASDAQ: ADP) preliminary Financial Gauge scores for the June quarter.

ADP is the largest firm providing payroll and other personnel-related information technology services.   The company is also known for the monthly ADP National Employment Report on non-farm private employment.

Data from ADP's latest earnings announcement were used to calculate the scores posted earlier, but ADP later filed a more complete 10-K report.  For our purposes, Balance Sheet details and a Cash Flow statement, which was not included in the original report, were the most important additions. 


We have now updated the financial metrics that determine our scores to take advantage of the new information in the 10-K.

12 August 2009

ADP: Financial Gauge Analysis for the June 2009 Quarter

In an earlier post, we examined Automatic Data Processing's (NASDAQ: ADP) Income Statement for the June quarter and compared the figures to our "look-ahead" estimates.  Earnings in this period, the fourth quarter of fiscal 2009, rose from $0.45 to $0.70 per share.  If a $120 million tax benefit had not been realized, earnings per share would have been $0.46 in the latest quarter.

We have since mined the financial statements in ADP's earnings announcement to update the metrics we use to assess Cash Management, Growth, Profitability and Value.  This post reports on these metrics and the Financial Gauge scores.


The Balance Sheet included in the earnings announcement was condensed, and a Cash Flow Statement through June has not yet been published.  To compute GCFR gauge scores, we had to estimate some data that the company has not yet made available.

We will adjust the results after ADP files a 10-K report with the SEC.


In the mean time, ADP's preliminary GCFR gauge scores are as follows:

The current and historical values for the financial metrics that determine the gauge scores are listed below, with some brief commentary.
 
Cash ManagementJun 2009Mar 2009Jun 20085-Yr Avg
Current Ratio (1)
1.61.71.71.7
LTD/Equity0.8%0.9%1.0%1.1%
Debt/CFO (years) (2)
0.50.00.00.1
Inventory/CGS (days)N/AN/AN/AN/A
Finished Goods/InventoryN/AN/AN/AN/A
Days of Sales Outstanding (days)44.645.243.249.5
Working Capital/Invested Capital (1)
40.0%37.8%37.7%41.8%
Cash Conversion Cycle Time (days)34.136.431.434.9
Gauge Score (0 to 25)1010914
1. Excludes Funds held for clients and Client funds obligations.
2. CFO in the June 2009 quarter was estimated.



This AAA company has $2.3 billion in Cash and Short-term investments and very little long-term debt.  ADP's Working Capital -- the difference between Current Assets and Current Liabilities  -- is about $1.5 billion.  (We exclude client funds when making this calculation.)

As of 30 June 2009, ADP had a new item on its Balance Sheet: a short-term $730 million "obligation under commercial paper borrowing."  The obligation was met on 1 July 2009.  This is a reminded that the ratios we calculate so diligently can rise or fall based on the calendar.


GrowthJun 2009Mar 2009Jun 20085-Yr Avg
Revenue growth (1)
1.0%4.6%12.5%3.4%
Revenue/Assets (2)
99.6%105.6%106.9%90.8%
Operating Profit growth14.5%9.2%6.3%7.0%
CFO growth (1,3)
-12.6%8.4%36.5%12.9%
Net Income growth (1)
14.4%6.9%13.8%15.0%
Gauge Score (0 to 25)614199
1. Revenue, CFO, and Net Income growth rates compare the last four quarters to the four previous quarters.  The Operating Profit rate is the annualized rate of growth in Operating Profit after Taxes over the last 16 quarters.
2. Assets excludes Funds held for clients
3. CFO in the June 2009 quarter was estimated.


Revenue Growth has continued to decline, which is not surprising during a recession for a company that provides payroll services.  Unfavorable foreign exchange rates have exacerbated this situation.

The upticks in the Net Income and Operating Profit growth rates were the result of large tax settlements in the recent quarter.   The tax benefit went right to the company's bottom line, and it also lowered the effective tax rate used in the Operating Profit calculation.

We await a 10-K with actual Cash Flow data.


ProfitabilityJun 2009Mar 2009Jun 20085-Yr Avg
Operating Expenses/Revenue79.4%79.8%80.3%80.3%
ROIC34.7%30.7%31.9%27.0%
Free Cash Flow/Invested Capital (1)
37.9%38.4%45.8%36.3%
Accrual Ratio (1)
-5.6%-0.3%3.9%-3.2%
Gauge Score (0 to 25)17151515
1. CFO and FCF in the June 2009 quarter were estimated.

Operating Expenses have been stable, perhaps slightly decreasing, when assessed on a trailing four quarters basis.  The high ROIC is comforting, although it received a boost from the one-time tax benefit.  The figures shown for the last two Profitability metrics were calculated with estimated Cash Flow data; they are likely to change.


ValueJun 2009Mar 2009Jun 20085-Yr Avg
P/E13.414.617.620.2
P/E vs. S&P 500 P/E 0.60.81.01.2
PEG0.91.62.83.2
Price/Revenue2.02.02.53.1
Enterprise Value/Cash Flow (EV/CFO) (1)
10.510.111.414.1
Gauge Score (0 to 25)1917147
1. CFO in the June 2009 quarter was estimated.

The price of ADP shares increased only slightly in the June quarter, from $35.16 to $35.44.  The share price was $41.90 on 30 June 2008.

ADP's valuation ratios can be compared with other companies in the Business Software and Services industry.


OverallJun 2009Mar 2009Jun 20085-Yr Avg
Gauge Score (0 to 100)61595744


In summary, ADP's Growth has weakened (no surprise) considerably in the last year.  Improvements by other measures and a lower share price kept the Overall gauge stable with a slight tailwind. 

However, the results would be a little less attractive if the $120 million tax benefit in the June 2009 quarter were to be excluded.  The Overall Gauge score would lose six points to 55.

Because we don't yet have a complete set of financial statements for the June 2009 period, it will be important for us to re-assess the analysis findings when a 10-K is filed.


Full disclosure: Long ADP at time of writing.