Discounted Cash Flow (DCF) Analysis Unlevered

Parrot S.A. (PARRO.PA)

4.56 €

-0.14 (-3.08%)
All numbers are in Millions, Currency in USD
Stock DCF: -1.26 | 4.56 | overvalue

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 151.87109.2476.0657.2754.3142.3232.9725.6920.0215.60
Revenue (%)
EBITDA -30.64-61.67-36.18-34.140.77-15.43-12.03-9.37-7.30-5.69
EBITDA (%)
EBIT -36.76-112.03-28.79-37.87-1.57-19.77-15.41-12-9.35-7.29
EBIT (%)
Depreciation 6.1350.37-7.393.732.344.343.382.632.051.60
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 157.56161.48126.6287.9982.8461.2947.7637.212922.59
Total Cash (%)
Account Receivables 40.2227.6410.305.995.177.225.634.383.422.66
Account Receivables (%)
Inventories 23.2619.4313.3210.174.946.565.113.983.102.42
Inventories (%)
Accounts Payable 37.5927.6316.2611.939.899.357.285.684.423.45
Accounts Payable (%)
Capital Expenditure -2.26-4.21-1.37-2.07-1.57-1.16-0.90-0.70-0.55-0.43
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 4.56
Beta 0.864
Diluted Shares Outstanding 30.22
Cost of Debt
Tax Rate -7.76
After-tax Cost of Debt 2.35%
Risk-Free Rate
Market Risk Premium
Cost of Equity 7.620
Total Debt 10.26
Total Equity 137.80
Total Capital 148.06
Debt Weighting 6.93
Equity Weighting 93.07
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 151.87109.2476.0657.2754.3142.3232.9725.6920.0215.60
EBITDA -30.64-61.67-36.18-34.140.77-15.43-12.03-9.37-7.30-5.69
EBIT -36.76-112.03-28.79-37.87-1.57-19.77-15.41-12-9.35-7.29
Tax Rate 53.00%0.72%-1.45%-0.52%-7.76%8.80%8.80%8.80%8.80%8.80%
EBIAT -17.28-111.23-29.20-38.06-1.70-18.03-14.05-10.95-8.53-6.65
Depreciation 6.1350.37-7.393.732.344.343.382.632.051.60
Accounts Receivable -12.5817.334.310.83-2.051.591.240.970.75
Inventories -3.836.113.145.24-1.621.451.130.880.68
Accounts Payable --9.96-11.37-4.33-2.04-0.54-2.06-1.61-1.25-0.98
Capital Expenditure -2.26-4.21-1.37-2.08-1.57-1.16-0.90-0.70-0.55-0.43
UFCF -13.41-58.61-25.89-33.283.10-19.06-10.59-8.25-6.43-5.01
WACC
PV UFCF -17.78-9.21-6.69-4.86-3.53
SUM PV UFCF -42.07

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 7.25
Free cash flow (t + 1) -5.11
Terminal Value -97.37
Present Value of Terminal Value -68.62

Intrinsic Value

Enterprise Value -110.69
Net Debt -72.58
Equity Value -38.11
Shares Outstanding 30.22
Equity Value Per Share -1.26