Discounted Cash Flow (DCF) Analysis Unlevered

HCI Group, Inc. (HCI)

$98.63

+0.42 (+0.43%)
All numbers are in Millions, Currency in USD
Stock DCF: 507.19 | 98.63 | undervalue

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 231.29242.47274.08407.91496.45606.16740.13903.711,103.441,347.30
Revenue (%)
EBITDA 55.9943.1543.824.95-56.6757.9470.7586.38105.47128.78
EBITDA (%)
EBIT 4534.2135.07-0.60-64.6840.2349.1259.9873.2389.42
EBIT (%)
Depreciation 118.948.755.558.0117.7121.6226.4032.2439.36
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 488.66432.55503.06671.53718.761,070.021,306.511,595.251,947.822,378.30
Total Cash (%)
Account Receivables 143.34155.59158.67149.24728.12445.27543.68663.84810.55989.69
Account Receivables (%)
Inventories --326.23-539.44-717.83-537.43-932.88-1,139.05-1,390.79-1,698.16-2,073.47
Inventories (%)
Accounts Payable 0.010.080.094.028.613.384.135.046.157.51
Accounts Payable (%)
Capital Expenditure -2.60-2.89-6.44-3.32-10.14-9.11-11.13-13.59-16.59-20.26
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 98.63
Beta 1.106
Diluted Shares Outstanding 8.58
Cost of Debt
Tax Rate 20.19
After-tax Cost of Debt 3.45%
Risk-Free Rate
Market Risk Premium
Cost of Equity 9.542
Total Debt 212.41
Total Equity 846.25
Total Capital 1,058.65
Debt Weighting 20.06
Equity Weighting 79.94
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 231.29242.47274.08407.91496.45606.16740.13903.711,103.441,347.30
EBITDA 55.9943.1543.824.95-56.6757.9470.7586.38105.47128.78
EBIT 4534.2135.07-0.60-64.6840.2349.1259.9873.2389.42
Tax Rate 34.11%26.37%25.31%35.53%20.19%28.30%28.30%28.30%28.30%28.30%
EBIAT 29.6525.1926.20-0.39-51.6228.8435.224352.5164.11
Depreciation 118.948.755.558.0117.7121.6226.4032.2439.36
Accounts Receivable --12.25-3.089.43-578.87282.84-98.41-120.16-146.71-179.14
Inventories --213.21178.38-180.40395.45206.17251.74307.38375.31
Accounts Payable -0.060.013.934.59-5.230.750.911.111.36
Capital Expenditure -2.60-2.89-6.44-3.32-10.14-9.11-11.13-13.59-16.59-20.26
UFCF 38.0519.06238.65193.58-808.44710.50154.22188.31229.93280.74
WACC
PV UFCF 655.93131.44148.17167.02188.26
SUM PV UFCF 1,290.82

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 8.32
Free cash flow (t + 1) 286.36
Terminal Value 4,531
Present Value of Terminal Value 3,038.44

Intrinsic Value

Enterprise Value 4,329.26
Net Debt -22.45
Equity Value 4,351.71
Shares Outstanding 8.58
Equity Value Per Share 507.19