Using an unlevered Free Cash Flow to Firm (FCFF) model, we project Automatic Data Processing, Inc.'s cash flows over 5 years with line-by-line expense modeling. Revenue is projected revenue growing from 6.0% to 8.2% annually, with expenses (COGS, SG&A, R&D) held at historical ratios. Depreciation is computed from a vintage matrix based on a 5-year useful life. Working capital is modeled using historical turnover days (DSO 65, DPO 5, DIO 60). At a 8.6% WACC with mid-year discounting, the terminal value (77% of enterprise value) is derived from the Gordon Growth Model on Year 6 FCFF at a 2.5% perpetual rate. After subtracting net debt, the equity value implies a fair price of $149.84 per share, suggesting ADP is overvalued by 26.9% at the current price of $204.86.
Adjust parameters to explore scenarios. Changes are for exploration only and do not affect saved valuations.
| 2026 | 2027 | 2028 | 2029 | 2030 | Terminal | |
|---|---|---|---|---|---|---|
| Profit Before Tax | 5,049 | 5,341 | 5,654 | 6,118 | 6,619 | 6,784 |
| (−) Net Interest | 282 | 299 | 316 | 342 | 370 | 379 |
| (+) D&A | 473 | 490 | 506 | 525 | 556 | 570 |
| EBITDA | 5,804 | 6,130 | 6,476 | 6,984 | 7,545 | 7,734 |
| (−) Tax | 1,156 | 1,223 | 1,294 | 1,400 | 1,515 | 1,553 |
| (−) CapEx | 595 | 630 | 667 | 721 | 780 | 800 |
| (−) ΔWC | 2,160 | 322 | 346 | 511 | 553 | 567 |
| Free Cash Flow (FCFF) | 1,893 | 3,956 | 4,170 | 4,352 | 4,697 | 4,814 |
| Terminal Value | 78,360 | |||||
| WACC / Discount Rate | 8.6% | |||||
| Long-term Growth Rate | 2.5% | |||||
| Timing of FCF (mid year) | 0.5 | 1.5 | 2.5 | 3.5 | 4.5 | 5 |
| Present Value of FCF | 1,816 | 3,493 | 3,389 | 3,256 | 3,234 | 51,769 |
| Enterprise Value | 66,957 | |||||
| Projection Period | 15,188 | 22.7% | ||||
| Terminal Value | 51,769 | 77.3% | ||||
| (−) Current Net Debt | 5,718 | |||||
| Equity Value | 61,239 | |||||
| (/) Outstanding Shares | 409 | |||||
| Fair Price | $149.84 | |||||
| WACC \ Terminal Growth Rate | 1.5% | 2.0% | 2.5% | 3.0% | 3.5% |
|---|---|---|---|---|---|
| 6.6% | $191 | $209 | $231 | $259 | $297 |
| 7.6% | $157 | $169 | $183 | $200 | $221 |
| 8.6% | $132 | $140 | $150 | $161 | $174 |
| 9.6% | $114 | $120 | $126 | $134 | $143 |
| 10.6% | $99 | $104 | $109 | $114 | $121 |
Current price: $204.86. Green = undervalued, Red = overvalued.
This is an unlevered Free Cash Flow to Firm (FCFF) model with a 5-year projection period. Revenue is projected using analyst consensus estimates, while expenses (COGS, SG&A, R&D, Interest) are modeled as individual line items based on historical ratios. Depreciation is calculated from a vintage matrix that tracks each year's CapEx depreciated straight-line over its useful life. Working capital is projected using historical turnover days (DSO, DPO, DIO).
FCFF equals EBITDA minus taxes, capital expenditure, and change in net working capital. The terminal value is calculated using the Gordon Growth Model on the Year 6 FCFF. Cash flows are discounted at the Weighted Average Cost of Capital (WACC) using mid-year convention. Enterprise value is converted to equity value by subtracting net debt (total debt minus cash).