Discounted Cash Flow (DCF) Analysis Unlevered

HireQuest, Inc. (HQI)

$24.13

-0.07 (-0.29%)
All numbers are in Millions, Currency in USD
Stock DCF: 6.55 | 24.13 | overvalue

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 97.3915.8813.8122.7630.9531.2731.5931.9132.2432.57
Revenue (%)
EBITDA 1.514.156.2814.2116.2811.7711.8912.0112.1312.26
EBITDA (%)
EBIT 1.183.756.1512.6514.2410.6910.8010.9111.0211.13
EBIT (%)
Depreciation 0.320.400.131.562.041.081.091.101.111.12
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 7.934.1913.671.263.059.319.409.509.609.70
Total Cash (%)
Account Receivables 9.0431.6223.5239.7248.4044.3844.8445.3045.7646.23
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 0.620.250.461.130.450.750.750.760.770.78
Accounts Payable (%)
Capital Expenditure -0.16-0.51-1.76-1.98-0.10-1.57-1.59-1.60-1.62-1.64
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 24.13
Beta 1.063
Diluted Shares Outstanding 13.72
Cost of Debt
Tax Rate 13.66
After-tax Cost of Debt 2.53%
Risk-Free Rate
Market Risk Premium
Cost of Equity 8.711
Total Debt 12.54
Total Equity 331.09
Total Capital 343.63
Debt Weighting 3.65
Equity Weighting 96.35
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 97.3915.8813.8122.7630.9531.2731.5931.9132.2432.57
EBITDA 1.514.156.2814.2116.2811.7711.8912.0112.1312.26
EBIT 1.183.756.1512.6514.2410.6910.8010.9111.0211.13
Tax Rate 17.39%109.75%12.15%5.11%13.66%31.61%31.61%31.61%31.61%31.61%
EBIAT 0.98-0.375.401212.297.317.397.467.547.61
Depreciation 0.320.400.131.562.041.081.091.101.111.12
Accounts Receivable --22.588.10-16.20-8.684.02-0.45-0.46-0.46-0.47
Inventories ----------
Accounts Payable --0.360.200.67-0.680.300.010.010.010.01
Capital Expenditure -0.16-0.51-1.76-1.98-0.10-1.57-1.59-1.60-1.62-1.64
UFCF 1.14-23.4212.07-3.944.8711.146.446.516.576.64
WACC
PV UFCF 10.265.475.104.744.42
SUM PV UFCF 29.99

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 8.49
Free cash flow (t + 1) 6.77
Terminal Value 104.36
Present Value of Terminal Value 69.43

Intrinsic Value

Enterprise Value 99.43
Net Debt 9.49
Equity Value 89.94
Shares Outstanding 13.72
Equity Value Per Share 6.55