Automatic Data Processing Financial Model

Employer Services This segment provides payroll, benefits administration, and human capital management software. The revenue driver formula is (Pays per Control x Pricing x Retention) + (Average Client Funds Balance x Average Yield). Historical growth ranges from 5 to 7% annually. Key growth levers include overall employment levels, interest rate environments driving client funds yield, and new business bookings. Pricing dynamics are a mix of contractual subscription fees and volume based processing fees. Revenue is recognised over time as services are performed. Seasonality is highly pronounced in the third fiscal quarter (January to March) due to year end tax reporting and W-2 processing fees.

Professional Employer Organization Services This segment provides comprehensive employment administration outsourcing where the company acts as a co-employer. The revenue driver formula is Average Worksite Employees x Revenue per Worksite Employee. Historical growth ranges from 5 to 8% annually. Key growth levers include the adoption of co-employment models by small and mid sized businesses and the pricing of benefits. Pricing dynamics are unique because revenues are reported net of direct pass through costs (payroll wages and taxes) but include workers compensation and state unemployment taxes. Revenue is recognised as services are provided during the payroll period. Seasonality is relatively stable, though the first and third fiscal quarters can see slight variations from benefits enrollment and tax resets.

Total assets are approximately $50 billion, heavily inflated by the client funds model. "Funds held for clients" is the largest and most critical asset, representing money collected from employers before it is remitted to employees or tax authorities. Goodwill and intangible assets represent approximately 10 to 15% of total assets, reflecting a history of strategic bolt on acquisitions. Working capital profile: Days Sales Outstanding typically ranges from 45 to 55 days. Days Payable Outstanding typically ranges from 30 to 40 days. Net working capital as a percentage of revenue is negative when excluding client funds, as deferred revenue provides a structural funding advantage. Property, plant, and equipment is relatively light, consisting mainly of data centres and capitalised software development costs. Right of use assets are material but manageable, representing leased office space across global operations.

Capital expenditure as a percentage of revenue typically runs between 1.0 and 1.5%. Maintenance capex is minimal, with the majority of spending directed towards growth initiatives and capitalised software development. Major programmes currently underway include investments in global payroll infrastructure and generative artificial intelligence integration. The company is a serial bolt on acquirer, focusing on technology tuck ins rather than transformational mega deals. Acquisition multiples vary but typically reflect premium software valuations for high quality assets like WorkForce Software.

Total debt is approximately $3.5 to $4.0 billion, resulting in a very low net debt position when excluding client funds. The Debt to EBITDA ratio is consistently below 1.0x. The company holds an AA- credit rating from Standard & Poor's, reflecting exceptional financial strength. Key debt instruments include senior unsecured notes and an active commercial paper programme for short term liquidity. The maturity profile is well laddered with a mix of near term commercial paper and long term fixed rate bonds. The interest rate profile is predominantly fixed for long term debt, with a weighted average cost of debt around 3.5 to 4.5%. The company operates an active share repurchase programme, buying back approximately $1.3 billion in stock during fiscal 2025. The dividend policy is highly shareholder friendly, targeting a payout ratio of 55 to 60% with a long history of consecutive annual increases.

Operating cash flow conversion is consistently strong, typically exceeding 1.0x net income. The free cash flow margin typically ranges from 15 to 18% of revenue. Major non cash items bridging net income to operating cash flow include depreciation, amortisation, and stock based compensation. Deferred revenue growth acts as a consistent source of cash, funding operations before services are fully rendered. Capex intensity is very low, highlighting the highly cash generative nature of the software and services model. The cash tax rate closely mirrors the GAAP effective tax rate of approximately 23%.

1. Assumptions: Hardcoded drivers for worksite employees, pays per control, interest yields, and margin targets.
2. Revenue Build: Detailed buildup of Employer Services (pays per control, retention, client funds interest) and Professional Employer Organization Services (worksite employees, revenue per employee).
3. Income Statement: Consolidated profit and loss mirroring company reporting (Revenues, Operating Expenses, SG&A, Systems Development, D&A).
4. Balance Sheet: Assets and liabilities, strictly separating corporate cash from "Funds held for clients" and "Client funds obligations".
5. Cash Flow Statement: Operating, investing, and financing cash flows, ensuring client funds movements are correctly classified and isolated.
6. Debt Schedule: Tranches of senior notes, commercial paper balances, and interest expense calculations.
7. Working Capital & Capex: Schedules for receivables, deferred revenue, and capitalised software additions.
8. DCF Valuation: Unlevered free cash flow calculation, weighted average cost of capital, and terminal value computation.

1. Employer Services Revenue = Prior Year Employer Services Revenue x (1 + Pays per Control Growth + Pricing and Retention Impact) + Client Funds Interest
2. Client Funds Interest = Average Client Funds Balance x Average Yield
3. Professional Employer Organization Revenue = Average Worksite Employees x Revenue per Worksite Employee
4. Total Revenue = Employer Services Revenue + Professional Employer Organization Revenue
5. Operating Expenses = Total Revenue x Operating Expense Margin
6. SG&A = Total Revenue x SG&A Margin
7. Systems Development Costs = Total Revenue x Systems Development Margin
8. Adjusted EBIT = Total Revenue - Operating Expenses - SG&A - Systems Development - D&A
9. Client Funds Obligations = Funds Held for Clients
10. Free Cash Flow = Net Income + D&A + Stock Based Compensation - Changes in Net Working Capital - Capex

The Assumptions sheet feeds the Revenue Build, which dictates the top line on the Income Statement. The Revenue Build also requires the Average Client Funds Balance from the Balance Sheet to calculate Client Funds Interest. This creates a critical chain where the model must strictly isolate client funds from corporate cash flows to prevent circularity. The Income Statement generates Net Income, which drives the Cash Flow Statement. The Cash Flow Statement then updates the Balance Sheet corporate cash and debt balances.

Revenues and assets are entered as positive numbers. Expenses, capital expenditures, and liabilities are entered as positive numbers in their respective schedules but subtracted in aggregation formulas. On the Cash Flow Statement, cash inflows are positive and cash outflows are negative.

1. Treating client funds as corporate cash inflates enterprise value and distorts return on capital metrics.
2. Misclassifying client funds interest as below the line interest income rather than operating revenue understates EBIT.
3. Failing to account for the net revenue accounting in the Professional Employer Organization segment overstates the true economic size of the business.
4. Ignoring the fiscal third quarter seasonality spike leads to inaccurate quarterly forecasting and working capital assumptions.
5. Linking client funds obligations to standard accounts payable breaks the balance sheet mechanics.
6. Excluding stock based compensation from operating expenses artificially flatters the adjusted EBIT margin.
7. Overestimating capex by applying industrial benchmarks to an asset light software business depresses free cash flow.
8. Mismodelling the dividend payout ratio causes corporate cash to build up unrealistically in the forecast period.

1. Adjusted EBIT margin should remain in the 25 to 27% range based on historical performance.
2. Capex as a percentage of revenue must not exceed 2.0%.
3. Funds held for clients must exactly equal client funds obligations in every period.
4. Effective tax rate should be approximately 23.0 to 23.5%.
5. Debt to EBITDA should remain below 1.0x.
6. Operating cash flow to net income conversion should be greater than 1.0x.
7. Dividend payout ratio should remain between 55 and 60%.
8. Total Assets must equal Total Liabilities plus Equity in every period.

• SEC EDGAR for Automatic Data Processing 10-K and 10-Q filings.
• Automatic Data Processing Investor Relations website for quarterly earnings presentations and client funds metrics.
• Key peers for benchmarking include Paychex (PAYX), Workday (WDAY), and UKG.
• Federal Reserve economic data for interest rate trends impacting client funds yields.
• Bureau of Labor Statistics for United States employment trends driving pays per control.

• Automatic Data Processing, Inc. Fiscal 2025 Form 10-K (SEC EDGAR).
• Automatic Data Processing, Inc. Fourth Quarter Fiscal 2025 Earnings Release and Investor Presentation.
• TradingView and Moomoo financial summaries for Automatic Data Processing Fiscal 2025 results.