Discounted Cash Flow (DCF) Analysis Unlevered

Aspen Technology, Inc. (AZPN)

$198.14

+9.88 (+5.25%)
All numbers are in Millions, Currency in USD
Stock DCF: 238.61 | 198.14 | undervalue

Operating Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 598.35590.18709.38405.301,044.181,392.931,858.172,478.803,306.714,411.15
Revenue (%)
EBITDA 311.92292.23402.25163.38308.35635.72848.051,131.301,509.152,013.20
EBITDA (%)
EBIT 303.78282.68391.9943.45-183.06409.85546.73729.34972.941,297.90
EBIT (%)
Depreciation 8.149.5510.26119.93491.42225.87301.32401.95536.21715.30
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 71.93287.80379.85449.73241.21691.99923.121,231.441,642.742,191.41
Total Cash (%)
Account Receivables 341.98344.90361.11556.80552.70994.031,326.041,768.932,359.753,147.90
Account Receivables (%)
Inventories -2.2814.64-12.3811.421.702.273.034.055.40
Inventories (%)
Accounts Payable 5.893.994.3721.4220.3026.4835.3247.1262.8583.85
Accounts Payable (%)
Capital Expenditure -1.57-1.42-2.37-2.77-6.94-6.09-8.12-10.83-14.45-19.27
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 198.14
Beta 0.795
Diluted Shares Outstanding 64.62
Cost of Debt
Tax Rate 40.32
After-tax Cost of Debt 2.98%
Risk-Free Rate
Market Risk Premium
Cost of Equity 7.908
Total Debt 68.37
Total Equity 12,804
Total Capital 12,872.37
Debt Weighting 0.53
Equity Weighting 99.47
Wacc

Build Up Free Cash

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 598.35590.18709.38405.301,044.181,392.931,858.172,478.803,306.714,411.15
EBITDA 311.92292.23402.25163.38308.35635.72848.051,131.301,509.152,013.20
EBIT 303.78282.68391.9943.45-183.06409.85546.73729.34972.941,297.90
Tax Rate 13.34%16.66%16.88%-32.99%40.32%10.84%10.84%10.84%10.84%10.84%
EBIAT 263.25235.59325.8357.79-109.25365.41487.46650.27867.461,157.19
Depreciation 8.149.5510.26119.93491.42225.87301.32401.95536.21715.30
Accounts Receivable --2.93-16.21-195.694.10-441.33-332-442.89-590.82-788.15
Inventories ---12.3627.02-23.809.72-0.57-0.76-1.01-1.35
Accounts Payable --1.900.3817.05-1.126.188.8411.8015.7420.99
Capital Expenditure -1.57-1.42-2.37-2.77-6.94-6.09-8.12-10.83-14.45-19.27
UFCF 269.82238.90305.5323.32354.40159.77456.93609.54813.121,084.71
WACC
PV UFCF 148.10392.61485.49600.33742.35
SUM PV UFCF 2,368.88

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 7.88
Free cash flow (t + 1) 1,106.40
Terminal Value 18,816.32
Present Value of Terminal Value 12,877.46

Intrinsic Value

Enterprise Value 15,246.34
Net Debt -172.84
Equity Value 15,419.17
Shares Outstanding 64.62
Equity Value Per Share 238.61