Discounted Cash Flow (DCF) Analysis Unlevered

GoPro, Inc. (GPRO)

$3.55

+0.01 (+0.28%)
All numbers are in Millions, Currency in USD
Stock DCF: 1.47 | 3.55 | overvalue

Operating Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 1,148.341,194.65891.931,161.081,093.541,101.891,110.301,118.771,127.311,135.92
Revenue (%)
EBITDA -53.9333.42-22.6312449.2623.6923.8724.0524.2324.42
EBITDA (%)
EBIT -88.990.16-41.70113.0440.692.302.322.342.362.38
EBIT (%)
Depreciation 35.0633.2619.0710.968.5721.3821.5521.7121.8822.04
Depreciation (%)

Balance Sheet Data

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Total Cash 197.51165.15325.65538.92367.34325.15327.63330.13332.65335.19
Total Cash (%)
Account Receivables 129.22200.63107.24114.2277.01125.51126.46127.43128.40129.38
Account Receivables (%)
Inventories 116.46144.2497.9186.41127.13115.17116.05116.94117.83118.73
Inventories (%)
Accounts Payable 148.48160.70111.40171.5491.65136.69137.74138.79139.85140.91
Accounts Payable (%)
Capital Expenditure -11-8.35-4.88-5.55-3.45-6.60-6.66-6.71-6.76-6.81
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 3.55
Beta 1.582
Diluted Shares Outstanding 178.28
Cost of Debt
Tax Rate 16.27
After-tax Cost of Debt 3.56%
Risk-Free Rate
Market Risk Premium
Cost of Equity 11.722
Total Debt 184.02
Total Equity 632.89
Total Capital 816.91
Debt Weighting 22.53
Equity Weighting 77.47
Wacc

Build Up Free Cash

Year
A/P
2018
Actual
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Projected
2024
Projected
2025
Projected
2026
Projected
2027
Projected
Revenue 1,148.341,194.65891.931,161.081,093.541,101.891,110.301,118.771,127.311,135.92
EBITDA -53.9333.42-22.6312449.2623.6923.8724.0524.2324.42
EBIT -88.990.16-41.70113.0440.692.302.322.342.362.38
Tax Rate -1.26%23.22%-7.79%-311.95%16.27%-56.30%-56.30%-56.30%-56.30%-56.30%
EBIAT -90.120.12-44.95465.6734.073.603.633.663.683.71
Depreciation 35.0633.2619.0710.968.5721.3821.5521.7121.8822.04
Accounts Receivable --71.4293.39-6.9837.21-48.50-0.96-0.97-0.97-0.98
Inventories --27.7846.3211.51-40.7211.96-0.88-0.89-0.89-0.90
Accounts Payable -12.22-49.3060.15-79.9045.041.041.051.061.07
Capital Expenditure -11-8.35-4.88-5.54-3.45-6.60-6.66-6.71-6.76-6.81
UFCF -66.06-61.9559.65535.76-44.2126.8917.7317.861818.13
WACC
PV UFCF 24.4714.6813.4612.3511.32
SUM PV UFCF 76.28

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 9.88
Free cash flow (t + 1) 18.50
Terminal Value 234.73
Present Value of Terminal Value 146.55

Intrinsic Value

Enterprise Value 222.83
Net Debt -39.72
Equity Value 262.55
Shares Outstanding 178.28
Equity Value Per Share 1.47