Discounted Cash Flow (DCF) Analysis Unlevered
Paychex, Inc. (PCX.DE)
108.78 €
-1.18 (-1.07%)
All numbers are in Millions, Currency in USD
Operating Data
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 3,380.90 | 3,772.50 | 4,040.50 | 4,056.80 | 4,611.70 | 4,989.50 | 5,398.24 | 5,840.47 | 6,318.93 | 6,836.58 |
---|---|---|---|---|---|---|---|---|---|---|
Revenue (%) | ||||||||||
EBITDA | 1,438 | 1,567.10 | 1,685.60 | 1,662 | 2,016.40 | 2,100.40 | 2,272.47 | 2,458.63 | 2,660.05 | 2,877.96 |
EBITDA (%) | ||||||||||
EBIT | 1,300 | 1,385.60 | 1,475.90 | 1,470 | 1,824.60 | 1,871.14 | 2,024.43 | 2,190.27 | 2,369.70 | 2,563.83 |
EBIT (%) | ||||||||||
Depreciation | 138 | 181.50 | 209.70 | 192 | 191.80 | 229.26 | 248.05 | 268.37 | 290.35 | 314.14 |
Depreciation (%) |
Balance Sheet Data
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Total Cash | 424.20 | 712.60 | 932.40 | 1,031.90 | 1,223.90 | 1,062.64 | 1,149.70 | 1,243.88 | 1,345.78 | 1,456.03 |
---|---|---|---|---|---|---|---|---|---|---|
Total Cash (%) | ||||||||||
Account Receivables | 563.60 | 854.20 | 790.30 | 1,053.60 | 1,318.20 | 1,131.89 | 1,224.62 | 1,324.94 | 1,433.48 | 1,550.91 |
Account Receivables (%) | ||||||||||
Inventories | - | - | - | - | - | - | - | - | - | - |
Inventories (%) | ||||||||||
Accounts Payable | 74.50 | 75.90 | 79.40 | 89 | 105.70 | 106.44 | 115.16 | 124.59 | 134.80 | 145.84 |
Accounts Payable (%) | ||||||||||
Capital Expenditure | -154 | -123.80 | -127 | -114.60 | -132.60 | -166.45 | -180.09 | -194.84 | -210.80 | -228.07 |
Capital Expenditure (%) |
Weighted Average Cost Of Capital
Share price | $ 108.78 |
---|---|
Beta | 0.995 |
Diluted Shares Outstanding | 358.50 |
Cost of Debt | |
Tax Rate | 23.67 |
After-tax Cost of Debt | 3.82% |
Risk-Free Rate | |
Market Risk Premium | |
Cost of Equity | 8.318 |
Total Debt | 881.20 |
Total Equity | 38,997.63 |
Total Capital | 39,878.83 |
Debt Weighting | 2.21 |
Equity Weighting | 97.79 |
Wacc |
Build Up Free Cash
Year A/P | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Actual | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected | 2027 Projected |
Revenue | 3,380.90 | 3,772.50 | 4,040.50 | 4,056.80 | 4,611.70 | 4,989.50 | 5,398.24 | 5,840.47 | 6,318.93 | 6,836.58 |
---|---|---|---|---|---|---|---|---|---|---|
EBITDA | 1,438 | 1,567.10 | 1,685.60 | 1,662 | 2,016.40 | 2,100.40 | 2,272.47 | 2,458.63 | 2,660.05 | 2,877.96 |
EBIT | 1,300 | 1,385.60 | 1,475.90 | 1,470 | 1,824.60 | 1,871.14 | 2,024.43 | 2,190.27 | 2,369.70 | 2,563.83 |
Tax Rate | 27.96% | 24.39% | 23.59% | 23.48% | 23.67% | 24.62% | 24.62% | 24.62% | 24.62% | 24.62% |
EBIAT | 936.51 | 1,047.71 | 1,127.75 | 1,124.90 | 1,392.80 | 1,410.55 | 1,526.10 | 1,651.12 | 1,786.38 | 1,932.73 |
Depreciation | 138 | 181.50 | 209.70 | 192 | 191.80 | 229.26 | 248.05 | 268.37 | 290.35 | 314.14 |
Accounts Receivable | - | -290.60 | 63.90 | -263.30 | -264.60 | 186.31 | -92.73 | -100.32 | -108.54 | -117.43 |
Inventories | - | - | - | - | - | - | - | - | - | - |
Accounts Payable | - | 1.40 | 3.50 | 9.60 | 16.70 | 0.74 | 8.72 | 9.43 | 10.21 | 11.04 |
Capital Expenditure | -154 | -123.80 | -127 | -114.60 | -132.60 | -166.45 | -180.09 | -194.84 | -210.80 | -228.07 |
UFCF | 920.51 | 816.21 | 1,277.85 | 948.60 | 1,204.10 | 1,660.41 | 1,510.06 | 1,633.76 | 1,767.60 | 1,912.40 |
WACC | ||||||||||
PV UFCF | 1,534.29 | 1,289.37 | 1,289.04 | 1,288.71 | 1,288.37 | |||||
SUM PV UFCF | 6,689.78 |
Terminal Value
Growth in perpetuity method: | |
---|---|
Long-term growth rate | |
WACC (%) | 8.22 |
Free cash flow (t + 1) | 1,950.65 |
Terminal Value | 31,360.97 |
Present Value of Terminal Value | 21,127.68 |
Intrinsic Value
Enterprise Value | 27,817.46 |
---|---|
Net Debt | 511.20 |
Equity Value | 27,306.26 |
Shares Outstanding | 358.50 |
Equity Value Per Share | 76.17 |