Discounted Cash Flow (DCF) Analysis Unlevered

Jacques Bogart S.A. (JBOG.PA)

7.9 €

0.00 (0.00%)
All numbers are in Millions, Currency in USD
Stock DCF: 246.61 | 7.9 | 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 129.49165.46304.50224.26246.63305.47378.35468.62580.42718.90
Revenue (%)
EBITDA 17.2320.3042.1139.2537.1743.9754.4667.4683.55103.48
EBITDA (%)
EBIT 14.8116.6517.868.755.7820.5425.4331.5039.0248.33
EBIT (%)
Depreciation 2.423.6424.2530.5031.3923.4429.0335.9544.5355.16
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 39.9658.6057.7488.2693.2599.22122.89152.21188.53233.51
Total Cash (%)
Account Receivables ----------
Account Receivables (%)
Inventories 47.6595.52100.6686.88102.62127.03157.34194.88241.38298.97
Inventories (%)
Accounts Payable 16.4368.7768.2749.9973.9778.7897.58120.86149.69185.40
Accounts Payable (%)
Capital Expenditure -2.31-2.76-5.44-3.25-10-6.56-8.13-10.07-12.47-15.45
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 7.9
Beta 0.935
Diluted Shares Outstanding 14.81
Cost of Debt
Tax Rate 55.85
After-tax Cost of Debt 0.79%
Risk-Free Rate
Market Risk Premium
Cost of Equity 7.896
Total Debt 226.63
Total Equity 116.98
Total Capital 343.61
Debt Weighting 65.96
Equity Weighting 34.04
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 129.49165.46304.50224.26246.63305.47378.35468.62580.42718.90
EBITDA 17.2320.3042.1139.2537.1743.9754.4667.4683.55103.48
EBIT 14.8116.6517.868.755.7820.5425.4331.5039.0248.33
Tax Rate 29.14%9.90%21.03%45.37%55.85%32.26%32.26%32.26%32.26%32.26%
EBIAT 10.501514.114.782.5513.9117.2321.3426.4332.74
Depreciation 2.423.6424.2530.5031.3923.4429.0335.9544.5355.16
Accounts Receivable ----------
Inventories --47.86-5.1413.78-15.74-24.41-30.31-37.54-46.50-57.59
Accounts Payable -52.34-0.50-18.2823.974.8118.8023.2828.8335.71
Capital Expenditure -2.31-2.76-5.44-3.25-10-6.56-8.13-10.07-12.47-15.45
UFCF 10.6020.3627.2827.5432.1711.1926.6232.9740.8350.57
WACC
PV UFCF 10.8424.9929.9835.9843.18
SUM PV UFCF 144.97

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 3.21
Free cash flow (t + 1) 51.58
Terminal Value 4,263.04
Present Value of Terminal Value 3,640.08

Intrinsic Value

Enterprise Value 3,785.05
Net Debt 133.38
Equity Value 3,651.67
Shares Outstanding 14.81
Equity Value Per Share 246.61