Discounted Cash Flow (DCF) Analysis Unlevered
Chuy's Holdings, Inc. (CHUY)
$23.18
-0.76 (-3.17%)
All numbers are in Millions, Currency in USD
Operating Data
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
| Revenue | 369.59 | 398.20 | 426.36 | 320.95 | 396.47 | 409.97 | 423.92 | 438.36 | 453.28 | 468.71 |
|---|---|---|---|---|---|---|---|---|---|---|
| Revenue (%) | ||||||||||
| EBITDA | 41.08 | 23.07 | 25.19 | 20.21 | 64.17 | 37.14 | 38.41 | 39.71 | 41.07 | 42.47 |
| EBITDA (%) | ||||||||||
| EBIT | 23.52 | 3.27 | 3.44 | -9.06 | 34.40 | 11.35 | 11.74 | 12.14 | 12.55 | 12.98 |
| EBIT (%) | ||||||||||
| Depreciation | 17.56 | 19.80 | 21.76 | 29.26 | 29.77 | 25.79 | 26.67 | 27.58 | 28.52 | 29.49 |
| Depreciation (%) |
Balance Sheet Data
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
| Total Cash | 8.79 | 8.20 | 10.07 | 86.82 | 106.62 | 49.80 | 51.50 | 53.25 | 55.07 | 56.94 |
|---|---|---|---|---|---|---|---|---|---|---|
| Total Cash (%) | ||||||||||
| Account Receivables | 10.27 | 4.25 | 1.68 | 1.51 | 2.89 | 4.46 | 4.61 | 4.77 | 4.93 | 5.10 |
| Account Receivables (%) | ||||||||||
| Inventories | 1.60 | 1.54 | 1.66 | 1.45 | 1.68 | 1.71 | 1.77 | 1.83 | 1.89 | 1.95 |
| Inventories (%) | ||||||||||
| Accounts Payable | 6.40 | 6.46 | 4.25 | 2.98 | 4.13 | 5.18 | 5.36 | 5.54 | 5.73 | 5.92 |
| Accounts Payable (%) | ||||||||||
| Capital Expenditure | -49.19 | -44.09 | -32.87 | -12.15 | -16.41 | -32.81 | -33.93 | -35.08 | -36.28 | -37.51 |
| Capital Expenditure (%) |
Weighted Average Cost Of Capital
| Share price | $ 23.18 |
|---|---|
| Beta | 1.730 |
| Diluted Shares Outstanding | 20.10 |
| Cost of Debt | |
| Tax Rate | 11.92 |
| After-tax Cost of Debt | 0.06% |
| Risk-Free Rate | |
| Market Risk Premium | |
| Cost of Equity | 11.967 |
| Total Debt | 201.74 |
| Total Equity | 465.94 |
| Total Capital | 667.67 |
| Debt Weighting | 30.22 |
| Equity Weighting | 69.78 |
| Wacc |
Build Up Free Cash
Year A/P | 2017 Actual | 2018 Actual | 2019 Actual | 2020 Actual | 2021 Actual | 2022 Projected | 2023 Projected | 2024 Projected | 2025 Projected | 2026 Projected |
| Revenue | 369.59 | 398.20 | 426.36 | 320.95 | 396.47 | 409.97 | 423.92 | 438.36 | 453.28 | 468.71 |
|---|---|---|---|---|---|---|---|---|---|---|
| EBITDA | 41.08 | 23.07 | 25.19 | 20.21 | 64.17 | 37.14 | 38.41 | 39.71 | 41.07 | 42.47 |
| EBIT | 23.52 | 3.27 | 3.44 | -9.06 | 34.40 | 11.35 | 11.74 | 12.14 | 12.55 | 12.98 |
| Tax Rate | -23.45% | -73.91% | -87.54% | 0.00% | 11.92% | -34.60% | -34.60% | -34.60% | -34.60% | -34.60% |
| EBIAT | 29.04 | 5.68 | 6.44 | -9.06 | 30.30 | 15.28 | 15.80 | 16.34 | 16.89 | 17.47 |
| Depreciation | 17.56 | 19.80 | 21.76 | 29.26 | 29.77 | 25.79 | 26.67 | 27.58 | 28.52 | 29.49 |
| Accounts Receivable | - | 6.02 | 2.58 | 0.17 | -1.39 | -1.57 | -0.15 | -0.16 | -0.16 | -0.17 |
| Inventories | - | 0.06 | -0.12 | 0.21 | -0.23 | -0.03 | -0.06 | -0.06 | -0.06 | -0.06 |
| Accounts Payable | - | 0.07 | -2.21 | -1.28 | 1.15 | 1.05 | 0.18 | 0.18 | 0.19 | 0.20 |
| Capital Expenditure | -49.19 | -44.09 | -32.87 | -12.15 | -16.41 | -32.81 | -33.93 | -35.08 | -36.28 | -37.51 |
| UFCF | -2.59 | -12.45 | -4.42 | 7.16 | 43.20 | 7.72 | 8.51 | 8.80 | 9.10 | 9.41 |
| WACC | ||||||||||
| PV UFCF | 7.12 | 7.25 | 6.91 | 6.60 | 6.29 | |||||
| SUM PV UFCF | 34.17 |
Terminal Value
| Growth in perpetuity method: | |
|---|---|
| Long-term growth rate | |
| WACC (%) | 8.37 |
| Free cash flow (t + 1) | 9.60 |
| Terminal Value | 150.65 |
| Present Value of Terminal Value | 100.79 |
Intrinsic Value
| Enterprise Value | 134.96 |
|---|---|
| Net Debt | 95.12 |
| Equity Value | 39.84 |
| Shares Outstanding | 20.10 |
| Equity Value Per Share | 1.98 |