Discounted Cash Flow (DCF) Analysis Unlevered

Tyler Technologies, Inc. (TYL)

$394.08

-4.14 (-1.04%)
All numbers are in Millions, Currency in USD
Stock DCF: 263.46 | 394.08 | overvalue

Operating Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 1,086.431,116.661,592.291,850.202,229.952,687.653,239.283,904.134,705.455,671.23
Revenue (%)
EBITDA 236.51256.70317.90375.04473.83571.08688.29829.56999.831,205.04
EBITDA (%)
EBIT 159.84175.04182.28215.97298.30359.53433.32522.26629.45758.64
EBIT (%)
Depreciation 76.6781.66135.62159.07175.52211.55254.97307.30370.38446.40
Depreciation (%)

Balance Sheet Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Total Cash 272.08675.81361.47210.89159.66681.71821.63990.271,193.521,438.49
Total Cash (%)
Account Receivables 380.57403.92539.20577.26508.68855.081,030.581,242.101,497.041,804.31
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 14.9814.01119.99104.8188.27106.39128.23154.54186.26224.49
Accounts Payable (%)
Capital Expenditure -42.04-28.47-55.61-22.53-62.04-74.78-90.12-108.62-130.92-157.79
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 394.08
Beta 0.838
Diluted Shares Outstanding 42.40
Cost of Debt
Tax Rate 12.45
After-tax Cost of Debt 4.38%
Risk-Free Rate
Market Risk Premium
Cost of Equity 7.674
Total Debt 682.89
Total Equity 16,708.60
Total Capital 17,391.49
Debt Weighting 3.93
Equity Weighting 96.07
Wacc

Build Up Free Cash

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 1,086.431,116.661,592.291,850.202,229.952,687.653,239.283,904.134,705.455,671.23
EBITDA 236.51256.70317.90375.04473.83571.08688.29829.56999.831,205.04
EBIT 159.84175.04182.28215.97298.30359.53433.32522.26629.45758.64
Tax Rate 8.33%-11.30%-1.56%12.45%1.98%1.98%1.98%1.98%1.98%1.98%
EBIAT 146.53194.82185.12189.09292.40352.41424.74511.92616.99743.62
Depreciation 76.6781.66135.62159.07175.52211.55254.97307.30370.38446.40
Accounts Receivable --23.35-135.28-38.0668.57-346.39-175.50-211.52-254.94-307.26
Inventories ----------
Accounts Payable --0.97105.98-15.17-16.5418.1221.8426.3231.7238.23
Capital Expenditure -42.04-28.47-55.61-22.53-62.04-74.78-90.12-108.62-130.92-157.79
UFCF 181.16223.70235.83272.39457.91160.91435.92525.39633.23763.20
WACC
PV UFCF 457.91149.63376.94422.45473.46530.62
SUM PV UFCF 1,953.09

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 7.54
Free cash flow (t + 1) 778.46
Terminal Value 14,051.65
Present Value of Terminal Value 9,769.61

Intrinsic Value

Enterprise Value 11,722.70
Net Debt 552.05
Equity Value 11,170.65
Shares Outstanding 42.40
Equity Value Per Share 263.46