Strategic, Financial and Business Analysis of Merlin Entertainment for Investment Purposes

1

2017-18 BDM 134
MSc International Accounting
and Finance Project
Candidate Number: 931667
Word Count:
Section 1 – 518 words
Section 2 - 1,793 words – without SWOT
table
Section3 – 3,423 words
Section 4 – 2,843 words – without
Industry median graphs
Section 5 – 1,148 words
Section 6 – 1,057 words
Total words = 10,782 words
2

Context Page Page
Section 1 – Executive Summary 5
Section 2 – Introduction and Strategic Analysis 7
2.1 - Merlin Entertainments Competitors 10
2.2 - Merlin’s Strategy 10
2.3 - SWOT for Merlin Entertainment 13
Section 3 - Literature Review and Introduction 15
3.1 - Methods of financial analysis that can be conducted using
publicly available information.
15
3.2 – Ration analysis 15
3.3 - Advantages of ratio analysis 16
3.4 – Trend analysis 16
3.5 - Advantages and Disadvantages of Trend Analysis: 17
3.6 - Vertical Analysis 17
3.7 – Horizontal Analysis 18
3.8 - Empirical evidence based on Merlin Entertainment: 18
3.9 - Methods and usefulness of business valuation techniques 19
3.10 - Extent to which financial analysis and valuations using
publicly available corporate information that provides a
faithful representation
22
3.11 - Conclusions regarding information and tools that needs to
be used in the completion of financial analysis and
company valuation
23
Section 4 – Financial Analysis 24
4.1 - Profitability 24
4.2 - ROE and ROCE 28
4.3 – Liquidity and Working Capital Efficiencies 29
4.4 - Total and non-current asset efficiency 34
4.5 - Financial Gearing 36
Section 5 – Business Valuation 39
Market Cap, Book Value per share, P/E ratio 39
5.1 - Discounted Free Cash Flow 41
5.2 - Conclusion 41
Section 6 – Conclusion 43
6.1 - Conclusions and Recommendations for Merlin 43
Appendix 1 - 48
1.1 - Balance sheet for DMP and BPB 2015, 2016 and 2017 50
3

1.2 - Income Satatements for Merlin 2015, 2016 and 2017 51
1.3 - Income statements for DMP 2015, 2016 and 2017 51
1.4 - Income statement for Blackpool Pleasure Beach 2015, 2016
and 2017 results
52
1.5 - Cashflow Statements of DMP, BPB and Merlin 52
1.6 - Industry Medians – Reuters 53
Appendix 2 - 54
2.1 - Liquidity, Working Capital Efficiency and Total and Non-Current
Asset Efficiency Calculations
54
Appendix 3 - 55
3.1 - Financial Gearing 55
3.2 - Merlin calculations 55
3.3 - BPB calculations 55
3.4 - DMP calculations 56
Appendix 4 - 57
4.1 - Profitability ratios. Income Satatements extracts for Merlin
2015, 2016 and 2017
57
4.2 - Profitability calculations 58
4.3 - ROCE for Merlin with taxes in 2017 58
4.4 - Income statements for DMP 2015, 2016 and 2017 58
4.5 - Income Statement for Blackpool Pleasure Beach 2015, 2016
and 2017 results
59
4.6 - DMP and Merlin extracts for hotel prices 59
Appendix 5 - 60
5.0 - Business valuation calculations 60
5.1 - Merlin interim 2018 cashflow extracts 61
5.2 - Merlin Interim income statement and balance sheet 2018. 62
5.3 - Interim 2018 revenue growth of Merlin 63
Appendix 6 – 63
Discounted free cash flow calculations 63
6.1 - Extracts for CAPM 64
6.2 - Growth rate calculation for free cash flow 66
6.3 - Second method to ascertain growth rate 67
6.4 - WACC fir Merlin 67
6.5 - DFCF calculation 67
Appendix 7 - 69
7.1 - Book Value calculation of Merlin Entertainment 69
7.2 - P/E ratio calculation 69
References - 71
4

Section 1- Executive Summary
This report was undertaken to understand the strategic, financial and business analysis of
Merlin Entertainment for investment purposes. An overview of the firm and an analysis of the
strategic position was undertaken in section two, which states Merlin has six strategic growth
drivers to achieve by 2020 and this will increase their asset base. Furthermore, Merlin
changed a portion of their strategy mid-term 2018 for better returns to be attained. Due to
the crash at Alton Towers and terrorism scares at London, Merlin had lower visitor numbers
in 2017, however, interim results 2018 state that there is a rise in revenue turnover of 4.5%
from previous results suggesting a small recovery is taking place.
The financial analysis of Merlin is conducted in section four of the report and critically
analyses the profitability, ROE & ROCE, liquidity and working capital efficiency, total and
non-current asset efficiency and financial gearing of Merlin Entertainment alongside Drayton
Manor Park and Blackpool Pleasure Beach. The profitability ratios of Merlin are positive
except for the U.K which stated static results, the reason Merlin changed their strategy
midway 2018 indicating quick reactions from the board.
Overall Merlin are ahead of competitors and industry medians with all the above analysis
except for total and non-current asset efficiency and financial gearing in the industry. Merlin’s
total and non-current assets efficiency revealed investments that are going to be realised in
the future. The firms have a high gearing ratio of around 50% debt to equity which is rising
every year as the firm takes on more debt.
Business valuation of Merlin revealed that there was a fall in the share price in 2017 (£3.63)
and this had recovered in 2018 to £4 per share. The reason the share price reduced in 2017
was because Merlin issued extra ordinary shares as part of their group employee share
incentive scheme and costs increases did not match revenue increases due to static
turnover in the U.K. Merlin’s market capitalisation as at 29/09/2018 is £4.09 billion. 2017
book value of Merlin is £1.53 indicating the market has over valued the share price, and on
that basis Merlin’s market per share is positive and fair as they have intellectual property in
their total assets which are going to be realised to profits moving forward.
However, both valuation methods did not incorporate future earnings of Merlin so a
discounted free cashflow method was used which determined a share price of £11.88 based
on a cashflow growth rate of 6%. The recommendations that were given in the report was to
retain dividend payments for a certain period or even take on extra debt to achieve a share
price close to £11.88.
5

This report concluded that due to the rising share price and the prospects of the company
looking positive moving forward, Merlin is a good candidate for investment. Merlin have a
geographical portfolio and the losses of the firm can be averaged out making Merlin a less
risky firm to invest in. However, returns from certain investments may take longer to realise
into profits while some returns may be realised sooner.
518 words
6

Section 2 – Introduction and Strategic Analysis
Merlin Entertainment are a UK based company that are in business in the leisure industry.
Merlin was incorporated in September 2013, and is headquartered in Poole Dorset, England
and has 3 parent shareholders. Blackstone (NYSE: BX), KIRKBI A/S and CVC Capital
Partners (‘CVC’). Merlin run and own 124 attractions in 25 countries covering four
continents, they also operate 18 hotels, six holiday villages across the four continents. Merlin
is Europe’s Number one entertainer in attractions and they are the second most visited
attraction operator in the world (Merlin Entertainments, 2018).
Merlin is listed on the London stock exchange and is on the FTSE 100. Recently, due to
health and safety issues at Alton Towers, Merlin share price has been declining, and there
was a fall in the FTSE. However, they decided to split the asset-backed theme parks and the
Legoland franchise from Midway (Financial Times, 2017a). By doing so, Merlin has created
value by the split. As Merlin is on the London stock exchange, they need to comply with the
UK Corporate Governance Code, The Disclosure and Transparency Rule and the Listings
rule (Merlin Entertainments, 2018).
Merlin take the responsibility of corporate governance very seriously. They are committed to
high standards of corporate governance across the whole group and their shareholders. The
main board at merlin take the responsibility of the strategy and the management of their
strategy by holding 6 meetings throughout the year, and more if needed, to ensure
objectives are met. Also, the way the chairman and board of directors under each committee
are nominated are in accordance with UK Corporate Governance Code and the Listing Rule.
Merlin is in the theme park industry and have a Health & Safety and Security Committee
along-side the standard committees, Audit, Nomination and Remuneration (Merlin
Entertainments, 2018).
Merlin is required to prepare their group accounts annual financial statements in accordance
with International Financial Reporting Standards (IFRS) that are adopted by the EU
(Adopted IFRS) and all the law that is applicable. The company’s annual financial
statements must be prepared to confer with the UK Accounting Standards and FRS 101
(Reduced Disclosure Framework) (Merlin Annual Report, 2016).
As mentioned above Merlin has many commodities that complement each other. Such as,
the hotels which are located in the theme parks, so visitors stay longer.
7

(Merlin Entertainments, 2018)
Merlin have two products –
 Midway and
 Theme parks.
Their Midway attractions are indoor with a two-hour experience of fun and are located
around city centres and resorts; these are Sea-Life Centre, The Dungeons, Madame
Tussauds, Shrek’s Adventure, Warwick Castle, The Eye Brand and Legoland Discovery
centres. There are 104 Midway attractions spread across Merlin’s global portfolio which has
accounted for 44% of Merlin’s revenue in 2016. Merlin are growing their Midway attractions
across the globe with 100+ locations that they have identified (Introduction to Merlin
Entertainments, 2016).
Merlin has three operating groups, Midway, theme parks and the Legoland parks. Theme
parks have a 1-3-day fun experience that have onsite accommodation for visitors. There are
6 parks, Alton Towers, Thorpe Park, Chessington World of Adventures, Warwick Castle,
Gardaland, and Heide Park that accounted for 22% of revenue for the group in 2016. Merlin
has 7 Legoland Parks across its global portfolio and a 34% revenue stream for the group in
2016 (Introduction to Merlin Entertainments, 2016).
Merlin has many complementary commercial operations that run throughout their three
operating groups. Merlin has restaurants, games, shops that sell trophies and photos of
visitors, so they can cherish their memories. They sell drinks and slush throughout their
theme parks for thirsty visitors and are constantly making updates to their attractions with the
help of their research and development team, Merlin Magic Making (Merlin Entertainments,
2018). Merlin are in the family entertainment industry with strong brands, their market are
adults and children’s off all ages, this gives Merlin an advantage as their market is everyone
who wants to enjoy fun days out and a couple of days break. Merlin has even targeted
8