Discounted Cash Flow (DCF) Analysis Unlevered

NextStage SCA (NEXTS.PA)

105 €

0.00 (0.00%)
All numbers are in Millions, Currency in USD
Stock DCF: 9,911.16 | 105 | undervalue

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 14.371.0216.17-37.4727.1887.03278.69892.482,858.099,152.73
Revenue (%)
EBITDA 13.151414.12-36.4225.72302.43968.523,101.589,932.4931,807.81
EBITDA (%)
EBIT 13.151414.12-39.1727.71308.82988.953,167.0210,142.0632,478.93
EBIT (%)
Depreciation ---2.75-1.99-6.38-20.44-65.44-209.57-671.12
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 94.2249.3320.6135.8639.98983.333,149.0210,084.4332,294.36103,419.44
Total Cash (%)
Account Receivables ---0.020.060.070.230.722.317.39
Account Receivables (%)
Inventories ----------
Inventories (%)
Accounts Payable 0.410.330.490.301.917.6424.4578.31250.78803.08
Accounts Payable (%)
Capital Expenditure ----------
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 105
Beta 0.208
Diluted Shares Outstanding 107.49
Cost of Debt
Tax Rate 0.00
After-tax Cost of Debt 1.74%
Risk-Free Rate
Market Risk Premium
Cost of Equity 4.574
Total Debt 17.11
Total Equity 11,286.03
Total Capital 11,303.14
Debt Weighting 0.15
Equity Weighting 99.85
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 14.371.0216.17-37.4727.1887.03278.69892.482,858.099,152.73
EBITDA 13.151414.12-36.4225.72302.43968.523,101.589,932.4931,807.81
EBIT 13.151414.12-39.1727.71308.82988.953,167.0210,142.0632,478.93
Tax Rate 0.00%-0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%
EBIAT 13.151414.12-39.1727.71308.82988.953,167.0210,142.0632,478.93
Depreciation ---2.75-1.99-6.38-20.44-65.44-209.57-671.12
Accounts Receivable -----0.04-0.01-0.15-0.50-1.59-5.08
Inventories ----------
Accounts Payable --0.090.16-0.191.615.7216.8253.86172.47552.31
Capital Expenditure ----------
UFCF -----308.15985.183,154.9410,103.3732,355.03
WACC
PV UFCF 294.68900.952,759.118,449.6325,876.55
SUM PV UFCF 38,280.93

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 4.57
Free cash flow (t + 1) 33,002.13
Terminal Value 1,284,129.73
Present Value of Terminal Value 1,027,006.89

Intrinsic Value

Enterprise Value 1,065,287.82
Net Debt -22.87
Equity Value 1,065,310.70
Shares Outstanding 107.49
Equity Value Per Share 9,911.16