Discounted Cash Flow (DCF) Analysis Unlevered

Lions Gate Entertainment Corp. (LGF-B)

$8.435

-0.51 (-5.65%)
All numbers are in Millions, Currency in USD
Stock DCF: 89.90 | 8.435 | undervalue

Operating Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 3,680.503,8903,271.503,604.303,854.803,921.443,989.234,058.204,128.364,199.73
Revenue (%)
EBITDA 1,852.301,980.501,595.701,880.801,9241,977.272,011.452,046.222,081.602,117.58
EBITDA (%)
EBIT 172.407.60144.2042.709.208485.4586.9388.4389.96
EBIT (%)
Depreciation 1,679.901,972.901,451.501,838.101,914.801,893.261,9261,959.291,993.162,027.62
Depreciation (%)

Balance Sheet Data

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Total Cash 184.30318.20528.70371.20272.10366.31372.64379.08385.64392.30
Total Cash (%)
Account Receivables 647.20522383.70442.20582.10549.80559.30568.97578.81588.81
Account Receivables (%)
Inventories 19.9013.4014.3014.1016.5116.8017.0917.3817.6817.99
Inventories (%)
Accounts Payable 531.20526.90545.40536.43573.71583.63593.72603.98614.42625.05
Accounts Payable (%)
Capital Expenditure -43.80-31.10-35-33.10-49-41.17-41.88-42.60-43.34-44.09
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 8.435
Beta 1.310
Diluted Shares Outstanding 227.90
Cost of Debt
Tax Rate -1.07
After-tax Cost of Debt 10.95%
Risk-Free Rate
Market Risk Premium
Cost of Equity 10.498
Total Debt 2,019.60
Total Equity 1,922.34
Total Capital 3,941.94
Debt Weighting 51.23
Equity Weighting 48.77
Wacc

Build Up Free Cash

Year
A/P
2019
Actual
2020
Actual
2021
Actual
2022
Actual
2023
Actual
2024
Projected
2025
Projected
2026
Projected
2027
Projected
2028
Projected
Revenue 3,680.503,8903,271.503,604.303,854.803,921.443,989.234,058.204,128.364,199.73
EBITDA 1,852.301,980.501,595.701,880.801,9241,977.272,011.452,046.222,081.602,117.58
EBIT 172.407.60144.2042.709.208485.4586.9388.4389.96
Tax Rate 7.76%-1.62%-98.28%-16.05%-1.07%-21.85%-21.85%-21.85%-21.85%-21.85%
EBIAT 159.037.72285.9149.559.30102.36104.13105.93107.76109.62
Depreciation 1,679.901,972.901,451.501,838.101,914.801,893.261,9261,959.291,993.162,027.62
Accounts Receivable -125.20138.30-58.50-139.9032.30-9.50-9.67-9.84-10.01
Inventories -6.50-0.900.20-2.41-0.29-0.29-0.30-0.30-0.31
Accounts Payable --4.3018.50-8.9737.289.9210.0910.2610.4410.62
Capital Expenditure -43.80-31.10-35-33.10-49-41.17-41.88-42.60-43.34-44.09
UFCF 1,795.132,076.921,858.311,787.281,770.071,996.391,988.542,022.922,057.892,093.46
WACC
PV UFCF 1,802.941,621.821,489.991,368.861,257.59
SUM PV UFCF 7,541.20

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 10.73
Free cash flow (t + 1) 2,135.33
Terminal Value 24,459.73
Present Value of Terminal Value 14,693.50

Intrinsic Value

Enterprise Value 22,234.69
Net Debt 1,747.50
Equity Value 20,487.19
Shares Outstanding 227.90
Equity Value Per Share 89.90