Question 1
Oil Infrastructures plc is a public company that specialises in the provision of oilfield services to the international oil and gas industry. It has operational centres in major oil and gas producing regions, including Saudi Arabia, Indonesia, Scotland and the Arab states of the Persian Gulf. The company and its subsidiaries offer support services for petroleum and natural gas extraction. Its main business is the design of onshore and offshore greenfield and brownfield upstream or downstream facilities, including engineering, procurement and commissioning. The firm operates and maintains oil and gas assets for clients under commercial contracts tailored to suit its clients.
The oil and gas sector has recently come under pressure due to decreasing oil prices, which has forced some high-cost firms out of business, and led to substantial layoffs and other cost reductions across the industry. Oil Infrastructures plc is planning to profit from this downturn by consolidating the oil and gas service sector, thus reducing its costs and improving its market power. An investment bank that has been advising Oil Infrastructures plc in the past has suggested Crude Plumbing Ltd. as a valuable addition to Oil Infrastructures' portfolio.
Crude Plumbing Ltd. operates in the same industry sector as Oil Infrastructures. Although it provides similar design, construction and maintenance services to oil and gas producers, it has a limited geographical overlap with Oil Infrastructures. Initial talks between senior management of both firms have indicated a potential for cost savings in procurement and other centralised functions (e.g. design, administration) as well as operational savings in overlapping geographical regions. In addition, there would be an opportunity for Oil Infrastructures plc to gain access to additional markets currently served by Crude Plumbing Ltd. To a limited extent, both firms would also engage in the sharing of technology.
You work in Oil Infrastructures' finance department and are asked to evaluate this merger opportunity, which would be implemented in the current year 2016 if deemed profitable. Oil Infrastructures' finance department has already compiled the stand-alone DCF valuation of Crude Plumbing shown in Table 1.
Table 1. Stand-alone DCF valuation of Crude Plumbing Ltd.
|
Base year
|
Forecast years
|
|
£m
|
£m
|
£m
|
£m
|
£m
|
£m
|
Year
|
2016
|
2017
|
2018
|
2019
|
2020
|
2021
|
Period
|
0
|
1
|
2
|
3
|
4
|
5
|
Revenue
|
680.00
|
680.00
|
714.00
|
749.70
|
779.69
|
810.88
|
Cost of sales (excl. depreciation)
|
-557.60
|
-557.60
|
-549.78
|
-577.27
|
-600.36
|
-624.37
|
Depreciation
|
-20.00
|
-20.00
|
-20.00
|
-20.80
|
-21.60
|
-22.40
|
Gross profit
|
102.40
|
102.40
|
144.22
|
151.63
|
157.73
|
164.10
|
Operating expenses
|
-95.20
|
-108.80
|
-71.40
|
-74.97
|
-77.97
|
-81.09
|
Operating profit
|
7.20
|
-6.40
|
72.82
|
76.66
|
79.76
|
83.01
|
Depreciation &Amortisation
|
20.00
|
20.00
|
20.00
|
20.80
|
21.60
|
22.40
|
EBITDA
|
27.20
|
13.60
|
92.82
|
97.46
|
101.36
|
105.41
|
Current liabilities change
|
-11.64
|
4.47
|
-14.87
|
10.47
|
8.84
|
9.18
|
Current assets change
|
9.81
|
0.00
|
-9.32
|
-9.78
|
-8.22
|
-8.54
|
Cash flow from operating activities
|
25.36
|
18.07
|
68.64
|
98.15
|
101.98
|
106.05
|
|
|
|
|
|
|
|
Investments in tangible assets
|
-20.00
|
-20.00
|
-30.00
|
-30.80
|
-31.60
|
-32.40
|
Net cash used in investing activities
|
-20.00
|
-20.00
|
-30.00
|
-30.80
|
-31.60
|
-32.40
|
|
|
|
|
|
|
|
Taxes
|
-1.44
|
1.28
|
-14.56
|
-15.33
|
-15.95
|
-16.60
|
Free cash flow to the firm
|
3.92
|
-0.65
|
24.07
|
52.02
|
54.43
|
57.05
|
|
|
|
|
|
|
|
Discount factors
|
|
0.926
|
0.857
|
0.794
|
0.735
|
0.681
|
Present value
|
|
-0.60
|
20.64
|
41.30
|
40.01
|
38.83
|
|
|
|
|
|
|
|
Present value of cash flows
|
140.17
|
|
|
|
|
|
Residual value (perpetual growth)
|
660.06
|
|
|
|
|
969.85
|
Enterprise value
|
800.24
|
|
|
|
|
|
This valuation is based on a number of assumptions for the case that the acquisition does not commence and Crude Plumbing remains independent (see Table 2).
Table 2. Stand-alone valuation assumptions
Year
|
2016 (Base)
|
2017
|
2018
|
2019
|
2020
|
2021
|
Revenue growth
|
-5.00%
|
0.00%
|
5.00%
|
5.00%
|
4.00%
|
4.00%
|
Cost of sales in % of revenue (excl. depreciation)
|
82.00%
|
82.00%
|
77.00%
|
77.00%
|
77.00%
|
77.00%
|
Operating expenses in % of revenue
|
14.00%
|
16.00%
|
10.00%
|
10.00%
|
10.00%
|
10.00%
|
Non-current (tangible) assets in £m
|
250.00
|
250.00
|
260.00
|
270.00
|
280.00
|
290.00
|
Depreciation of tangible assets in %
|
8.00%
|
8.00%
|
8.00%
|
8.00%
|
8.00%
|
8.00%
|
Current liability days
|
120.00
|
120.00
|
120.00
|
120.00
|
120.00
|
120.00
|
Current asset days
|
100.00
|
100.00
|
100.00
|
100.00
|
100.00
|
100.00
|
Corporate tax rate %
|
20.00%
|
20.00%
|
20.00%
|
20.00%
|
20.00%
|
20.00%
|
Revenue growth in perpetuity from year 2022
|
2.00%
|
|
|
|
|
|
WACC
|
8.00%
|
|
|
|
|
|
The acquisition will have several effects on the target. Management estimates higher revenue due to increased market power and the broader range of services that can be offered after the merger. Growth will also be slightly higher due to the sharing of technology between both firms. Small cost savings will come from shared administration and marketing and a small reduction of head count in administrative departments. The relative amount of working capital (i.e., relative to revenue) required to run the business will be unchanged.
Crude Plumbing would also invest £60m in new and more efficient production facilities at its main operational centres, which are expected to be depreciated in line with all other non-current tangible assets at 8% of the remaining book value per year (i.e., geometric depreciation), beginning in the year following the construction of the facilities. The restructuring of Crude Plumbing's business and integration with Oil Infrastructures will render £40m worth (book value) of equipment useless, which will be written off completely in 2017.
Table 3 shows the changes to Crude Plumbing's business expected by management.
Table 3. Assumptions for acquisition
Forecasting inputs
|
2017
|
2018
|
2019
|
2020
|
2021
|
Revenue growth
|
5.00%
|
10.00%
|
8.00%
|
6.00%
|
5.00%
|
Cost of sales as % of revenue (excl. depreciation)
|
82.00%
|
77.00%
|
77.00%
|
77.00%
|
77.00%
|
Operating expenses in % of revenue (excl. merger expenses)
|
12.00%
|
10.00%
|
10.00%
|
10.00%
|
10.00%
|
Non-current (tangible) assets (£m)
|
270.00
|
278.40
|
286.93
|
295.57
|
304.33
|
Extraordinary write-off (£m)
|
40.00
|
|
|
|
|
Investment in new plant (£m)
|
60.00
|
|
|
|
|
Implementation costs (£m)
|
|
|
|
|
|
Fees for investment bank, lawyers
|
8.00
|
|
|
|
|
Severance, redundancy payments
|
2.00
|
1.00
|
|
|
|
Retention bonuses
|
1.50
|
|
|
|
|
Integration of production processes
|
10.00
|
5.00
|
1.00
|
|
|
For the calculation of the target's terminal value it is assumed that the target's cost structure as well as the relative size of all other items will remain constant from the year 2021 onwards. To simplify the calculation, is it further assumed that depreciation will be matched exactly by replacement investments from the year 2021. Hence, no detailed calculation is needed beyond 2021.
Your colleagues at the finance department have compiled a list of public firms that may be comparable to Crude Plumbing in Table 4.
Table 4. Comparable firms as at 31 December 2015
Market value and net debt are for the financial year-end 2015, while net income, EBITDA and revenue are expected values for 2016.
|
Firm name
|
Industry (SIC 2007 sector codes)
|
Market value of equity (£m)
|
Net debt (£m)
|
Net income (£m)
|
EBITDA (£m)
|
Revenue (£m)
|
FBM Technologies Inc
|
09.10 Support activities for petroleum and natural gas extraction
|
317.44
|
201.96
|
-4.21
|
21.25
|
359.03
|
Mining Support Corp
|
09.90 Support activities for other mining and quarrying
|
267.80
|
104.96
|
-4.96
|
13.55
|
250.48
|
Spillnomoreplc
|
19.20 Manufacture of refined petroleum products
|
125.56
|
107.22
|
10.28
|
15.57
|
312.92
|
Gulf Island Structures Corp
|
09.10 Support activities for petroleum and natural gas extraction
|
1131.20
|
1262.23
|
22.73
|
67.31
|
1687.87
|
Shelf Drilling NV
|
06.10 Extraction of crude petroleum
|
180.84
|
121.01
|
-4.44
|
10.21
|
266.55
|
International OilwellInc
|
09.10 Support activities for petroleum and natural gas extraction
|
1368.79
|
581.72
|
19.29
|
41.85
|
1512.53
|
Freshwater Horizons plc
|
09.90 Support activities for other mining and quarrying
|
311.24
|
211.72
|
1.64
|
15.24
|
547.21
|
GulfMark Refineries Inc
|
19.20 Manufacture of refined petroleum products
|
686.40
|
888.82
|
18.06
|
28.07
|
1135.84
|
Total Offshore NV
|
06.10 Extraction of crude petroleum
|
1942.72
|
1667.22
|
266.71
|
270.62
|
3427.00
|
HalliburpInc
|
09.10 Support activities for petroleum and natural gas extraction
|
76.17
|
66.63
|
0.46
|
4.05
|
134.84
|
ConnectTech Ltd
|
09.10 Support activities for petroleum and natural gas extraction
|
424.44
|
470.74
|
0.92
|
40.40
|
744.41
|
Dril-Nom Inc
|
06.10 Extraction of crude petroleum
|
192.83
|
151.62
|
3.56
|
14.67
|
256.36
|
Baker Grant SA
|
19.20 Manufacture of refined petroleum products
|
1060.06
|
351.25
|
37.95
|
51.00
|
1342.55
|
Although the management's plan was to keep the merger plans a secret until negotiations with Crude Plumbing are completed, the press has learned about Oil Infrastructures' intent to acquire Crude Plumbing. Rumours of the acquisition were made public on 9 June 2016. Table 5 shows the share price for Oil Infrastructures plc.
Table 5. Share price of Oil Infrastructures plc
This table shows share prices for two months around the event day. The column "FTSE250" is the index value of the FTSE 250 stock index.
|
Date
|
Oil Infra- structures plc
|
FTSE250
|
|
Date
|
Oil Infra- structures plc
|
FTSE250
|
20/04/2016
|
62.00
|
17018.00
|
|
20/05/2016
|
65.87
|
16922.10
|
21/04/2016
|
62.90
|
16979.40
|
|
23/05/2016
|
65.16
|
17031.70
|
22/04/2016
|
64.43
|
16871.50
|
|
24/05/2016
|
66.18
|
17135.70
|
25/04/2016
|
63.04
|
16965.70
|
|
25/05/2016
|
66.70
|
17232.60
|
26/04/2016
|
63.24
|
16945.50
|
|
26/05/2016
|
67.96
|
17192.80
|
27/04/2016
|
64.02
|
17083.70
|
|
27/05/2016
|
67.20
|
17232.30
|
28/04/2016
|
64.93
|
17066.40
|
|
31/05/2016
|
68.37
|
17184.70
|
29/04/2016
|
65.14
|
16801.60
|
|
02/06/2016
|
67.77
|
17076.30
|
03/05/2016
|
65.83
|
16730.10
|
|
03/06/2016
|
69.41
|
17067.90
|
04/05/2016
|
64.91
|
16659.40
|
|
06/06/2016
|
69.45
|
17181.80
|
05/05/2016
|
65.65
|
16661.70
|
|
07/06/2016
|
69.64
|
17195.40
|
06/05/2016
|
65.35
|
16648.80
|
|
08/06/2016
|
68.63
|
17177.80
|
09/05/2016
|
65.10
|
16687.10
|
|
09/06/2016
|
72.08
|
17111.60
|
10/05/2016
|
66.08
|
16724.40
|
|
10/06/2016
|
74.19
|
16827.50
|
11/05/2016
|
65.56
|
16720.70
|
|
13/06/2016
|
75.30
|
16574.20
|
12/05/2016
|
64.32
|
16659.90
|
|
14/06/2016
|
75.90
|
16232.30
|
13/05/2016
|
63.54
|
16650.30
|
|
15/06/2016
|
77.49
|
16298.30
|
16/05/2016
|
64.65
|
16699.30
|
|
16/06/2016
|
77.07
|
16032.00
|
17/05/2016
|
65.41
|
16845.10
|
|
17/06/2016
|
77.20
|
16422.00
|
18/05/2016
|
65.80
|
16881.20
|
|
20/06/2016
|
79.11
|
16959.10
|
19/05/2016
|
66.27
|
16730.10
|
|
|
|
|
Task
Your task is to recommend an enterprise value of Crude Plumbing Ltd. under the assumption that the firm is bought by Oil Infrastructures plc. In other words, you are asked to estimate a fair purchase price for Crude Plumbing Ltd. Briefly explain how you arrived at the answer for each of the following questions.
- a.Calculate the enterprise value of Crude Plumbing as at 1 January 2016 (treating 2016 as year ‘0'). This valuation should include all synergies and other costs and benefits caused by the merger.
- b.Calculate an enterprise value based on the set of comparable firms in Table 4.
- c.Recommend a purchase price for Crude Plumbing and discuss your choice.
- d.Calculate the cumulative abnormal return on Oil Infrastructures' shares for an event window of two days before and two days after the merger announcement in the press.
Guidelines
This TMA is not just testing your ability to perform the required calculations; it is also assessing your understanding of how to select relevant financial information and make considered decisions about whether and how to deploy them. This is reflected in the allocation of marks for the question (see above).
There is no set format for the analysis in Question 3. However, your solution should consist of a short report documenting your answers to the questions and a spreadsheet showing all calculations that led to these answers. Remember to show all your calculations in detail, including all assumptions you make. Submit a spreadsheet showing your analysis and calculations, as this will help your tutor to give feedback on your calculations. The main results and tables should be included within the body of the report. The spreadsheet should be combined with your report in a ZIP file when uploading to the eTMA system.
You should be able to answer this question using B859 unit materials only. For additional explanations and ideas of how to estimate firm value, see DePamphilis (2011) which is available through the OU Library (see link below). In particular, chapter 8 (sections "The Comparable Companies Method" and "Recent Comparable Transactions Method") and chapter 9 (section "The model-building process") may be helpful.
DePamphilis, D. (2011), Mergers, Acquisitions, and Other Restructuring Activities: An Integrated Approach to Process, Tools, Cases, and Solutions, Elsevier, available through the OU library