Loading...

Discounted Cash Flow (DCF) Analysis Unlevered


McDermott International Inc.

McDermott International Inc. (MDR)

Energy

Operating Data

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Revenue 2,658.932,300.773,070.152,636.032,985.046,705.018,632.0211,112.8714,306.7118,418.4523,711.92
Revenue (%)
EBITDA -376.5098.24202.32238.03411.94-2,045.03-157.97-203.37-261.81-337.06-433.93
EBITDA (%)
EBIT -461.065.0684.12134.96311.04-2,323.95-482.53-621.21-799.74-1,029.59-1,325.50
EBIT (%)
Depreciation 84.5593.18118.20103.07100.89278.93324.56417.84537.93692.53891.57
Depreciation (%)

Balance Sheet Data

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Total Cash 142.25852.90781.66612.35408.06844.831,688.422,173.682,798.393,602.654,638.05
Total Cash (%)
Account Receivables 962.53718.30866.09817.70408.951,168.682,270.222,922.683,762.664,844.056,236.23
Account Receivables (%)
Inventories -----101.25130.34167.80216.03278.12358.05
Inventories (%)
Accounts Payable 398.84219.49279.69173.19279.10594.73840.761,082.391,393.471,793.962,309.54
Accounts Payable (%)
Capital Expenditure -283.97-321.19-102.85-228.02-119.10-85.82-602.52-775.68-998.61-1,285.61-1,655.09
Capital Expenditure (%)

Weighted Average Cost Of Capital

Share price $ 0.82
Diluted Shares Outstanding 150.00
Cost of Debt
Tax Rate -4.03
After-tax Cost of Debt 0.25
Risk-Free Rate
Market Risk Premium
Cost of Equity 24.50
Total Debt 3,459.00
Total Equity 123.00
Total Capital 3,582.00
Debt Weighting 96.57
Equity Weighting 3.43
Wacc

Build Up Free Cash

Year
A/P
2013
Actual
2014
Actual
2015
Actual
2016
Actual
2017
Actual
2018
Actual
2019
Projected
2020
Projected
2021
Projected
2022
Projected
2023
Projected
Revenue 2,658.932,300.773,070.152,636.032,985.046,705.018,632.0211,112.8714,306.7118,418.4523,711.92
EBITDA -376.5098.24202.32238.03411.94-2,045.03-157.97-203.37-261.81-337.06-433.93
EBIT -461.065.0684.12134.96311.04-2,323.95-482.53-621.21-799.74-1,029.59-1,325.50
Tax Rate -10.67%-35.90%152.92%55.26%27.82%-4.03%30.90%30.90%30.90%30.90%30.90%
EBIAT -510.246.88-44.5260.38224.50-2,417.52-333.41-429.24-552.60-711.42-915.88
Depreciation 84.5593.18118.20103.07100.89278.93324.56417.84537.93692.53891.57
Accounts Receivable -244.23-147.7948.39408.75-759.73-1,101.54-652.46-839.98-1,081.39-1,392.18
Inventories -------29.10-37.46-48.23-62.09-79.93
Accounts Payable --179.3560.20-106.50105.91315.63246.03241.63311.08400.48515.58
Capital Expenditure -37.21-218.34125.17-108.91-33.28516.69173.16222.93287.00369.48
UFCF -425.69202.16-232.25230.50731.14-2,615.97-376.77-286.52-368.86-474.87-611.35
WACC
PV UFCF -355.91-255.67-310.93-378.14-459.87
SUM PV UFCF -2,793.80

Terminal Value

Growth in perpetuity method:
Long-term growth rate
WACC (%) 5.86
Free cash flow (t + 1) -635.81
Terminal Value -34,183.18
Present Value of Terminal Value -25,713.02

Intrinsic Value

Enterprise Value -28,506.82
Net Debt 2,614.17
Equity Value -31,120.99
Shares Outstanding 150.00
Equity Value Per Share -207.47