Discounted Cash Flow (DCF) Analysis Unlevered

GoPro, Inc. (GPRO)

$4.265

+0.14 (+3.27%)
All numbers are in Millions, Currency in USD
Stock DCF: 0.48 | 4.265 | 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.9326.43-22.6378.1249.2613.6913.7913.901414.11
EBITDA (%)
EBIT -88.990.16-41.7067.1640.69-6.40-6.45-6.50-6.55-6.60
EBIT (%)
Depreciation 35.0626.2719.0710.968.5720.0920.2520.4020.5620.71
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 $ 4.265
Beta 1.379
Diluted Shares Outstanding 178.28
Cost of Debt
Tax Rate 16.27
After-tax Cost of Debt 2.84%
Risk-Free Rate
Market Risk Premium
Cost of Equity 10.200
Total Debt 184.02
Total Equity 760.36
Total Capital 944.38
Debt Weighting 19.49
Equity Weighting 80.51
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.9326.43-22.6378.1249.2613.6913.7913.901414.11
EBIT -88.990.16-41.7067.1640.69-6.40-6.45-6.50-6.55-6.60
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.95276.6734.07-10.01-10.09-10.16-10.24-10.32
Depreciation 35.0626.2719.0710.968.5720.0920.2520.4020.5620.71
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-68.9459.65346.76-44.2111.992.712.732.752.77
WACC
PV UFCF 11.022.292.121.971.82
SUM PV UFCF 19.22

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 8.77
Free cash flow (t + 1) 2.83
Terminal Value 41.79
Present Value of Terminal Value 27.45

Intrinsic Value

Enterprise Value 46.67
Net Debt -39.72
Equity Value 86.39
Shares Outstanding 178.28
Equity Value Per Share 0.48