\$20 Bonus + 25% OFF

# Financial Information Management

0 Download10 Pages / 2,409 Words Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

## Question:

Write an essay on Financial Information Management.

### Introduction

The portfolio theory (Markowitz 1952) in his paper "Portfolio Selection,", says that it is possible to create an optimum portfolio which offers the maximum return for the amount of risk taken.

In this assignment we apply the portfolio theory concept to a set of 5 stocks namely Easy Jet, Unilever, Merlin Entertainment, Marks & Spencer, and Royal Mail. By running a Monte Carlo simulation, we select and assign stocks to a hypothetical £100,000 portfolio; followed by an analysis on the individual stocks.

### Portfolio Selection

We ran a Monte Carlo simulation (on Easy Jet, Unilever, Merlin Entertainment, Marks & Spencer, and Royal Mail) with 1000 iterations based on the ROE TTM and Beta of the stock to come up with the optimum portfolio – minimum Beta with maximum returns (Brealey, Myers & Allen 2011). The optimal portfolio in this case comprises Easy Jet - 50% weightage, Unilever – 40% weightage, and Merlin Entertainment 10% weightage (we have used approximations for the sake of simplicity). Marks & Spencer and Royal Mail received a minor weightage, so we choose to leave them out of the portfolio.

Scatter plot for TTM (Trailing Twelve Month) Returns and Beta of the stockSource: Reuters, DigitalLook

### Portfolio

 Cl. Price 8 Jul, '16 in GBp No of shares Investment in GBP Weight Beta ROE TTM EasyJet 1070 4673 50000 50% 0.54 28.3% Marks & Spencer 317.3 0 0 0% 0.91 12.3% Merlin Entertainments 459.5 2176 10000 10% 0.89 20.2% Royal Mail 486.3 0 0 0% 1.01 5.6% Unilever 3651.5 1095 40000 40% 0.62 33.8% Portfolio value 100000 100% 0.61 29.7%

### Easy Jet (Buy, Portfolio weight 50%)

Easy Jet is a British short haul budget airline, operating on approximately 800 routes spanning across 30 countries in Europe, with a fleet of 240 aircrafts. According to Goldman Sachs, in the recent years, European Low Cost Carriers (LCC’s) have and would continue to gain market share for short haul flights from legacy carriers. The major beneficiary of this trend has been low cost carriers such as Easy Jet and Ryanair (Mann 2016).

Further, these airlines continue to benefit from strong European travel trends. According to European Travel Commission, tourist arrivals increased 5% in 2015 in Europe. Air traffic was strong with Revenue Passenger per Kilometre (RPK), increasing 5.2% in 2015 y-o-y and Air capacity increasing by 4% on an avg. in 2015. A key driver of this growth was strong intra-European travel, a category which is a forte of short haul airlines like Easy Jet. For 2016, the report forecasts a 3.2% increase in European inbound travel. For 1H16 ended 31 March, 2016, Easy Jet’s passengers grew 7.4%, continuing the trend from 2015 which marked a 6% growth in passengers (European Travel Commission 2016).

Lower Oil prices also are playing a major role to curtail the costs (Tovey 2015), which are being passed on to customers. According to Easy Jet’s latest half yearly report 31 March, 2016, cost per seat declined 5%, and fares to customers decreased 6% in 1H16 y-o-y, while forward bookings were in line with last year. In 2015, cost per seat decreased 3.4% given favourable oil prices and currency movement.

Financials: Easy jet reported strong set of financials with revenues in 2015 reaching £4.7 bn, up 3.5% from 2014, and the basic EPS growing by 21.5% in 2015. The consensus expects the revenues to grow 2.1% in FY16 ending September 30, despite the impact of terrorism, EU instability and Brexit (Reuters 2016).

Valuation: Easy Jet is trading at a PE ratio of 8.5x vs. industry at 13.5x, according to Reuters. Since the stock is undervalued, it may be good time to buy the stock, given positive outlook and strong fundamentals.

Risks: Brexit could impact travel to and from UK (Bryan 2016), and the company plans to up a company in Europe (Martin 2016). Currency fluctuations could be a drag on profitability. Terrorism attacks and immigration crisis could mute the growth of travel to certain areas. Volatility in commodity prices could impact the profitability of the firm.

Reuters Consensus ratings: Buy (6), outperform (7), Hold (9), Underperform (2) and Sell (1)

### Unilever (Buy, Portfolio Weight 40%)

With a presence in almost 190 countries, Unilever PLC is one of the largest consumer goods company in the world operating in Food, Home Care, Personal care products and Refreshments. The Foods segment includes soups (knorr), snacks, sauces, margarines and spreads. The Homecare segment includes a variety of cleaning products such as Surf. While, the personal care segment has popular skin care and hair brands like Dove, Lux, Axe, etc., the Refreshment segment has ice cream and beverages like Magnum, Lipton, Ben &j Jerry’s under its umbrella. Unilever has close to 400 brands all over the globe.

With majority of revenues coming from developing/ emerging markets, Unilever can prove to be a safe bet after Brexit and EU instability (Wild 2016). For FY15, Unilever reported underlying sales growth of 4.1%, with emerging markets reporting 7.1% growth, while developed markets were flat. Although, pricing increased in emerging markets, we saw a deflationary trend in developed markets which was offset by volume growth. The trend continued in 1Q16 with emerging markets underlying sales growth of +8.3%, vs developed markets which were slightly negative with -0.3% (underlying price growth of -1.3%). The company has shown resilient revenue growth of 3.34% from 2006 to 2015 (including the recession phase), according to company’s financials.

The outlook for Unilever looks promising with exposure to emerging markets and income levels improving in China and India (Stephens 2016). With increasing uncertainty around the EU, Unilever could attract investors as it is a perfect mix of defensive and growth stock. The Brexit impact on Unilever would be largely limited (Trefis 2016) as it has localised its manufacturing plants, in turn reducing the transportation costs, and hedged against FX impact.

Unilever is also working on cost savings program called Zero based budgeting (Neff 2016) which is on track to produce €1bn p.a. savings by 2018. The company will introduce new "functional models" to decrease the costs for internal marketing and other staffing, and better alignment of headcount costs with revenue centres.

Unilever has had a history of giving healthy dividends, which amounted to €3.3 bn in 2015, a 4.5% increase over the previous year. If we compare this with 2006, Unilever has increased its dividend at annualised rate of 6.7% per annum to 2015, according to company’s financials.

Financials: The consensus estimates collected by the company as on July 8 expect the underlying sales growth to increase +4.1% and acquisitions to account for +0.4% for FY16, to be offset by -4.5% FX impact. Although, the revenues are expected to be flat, the core operating margin is expected to improve by 0.4 percentage points, driving an EPS growth of 2.9% for FY16.

Valuation: Unilever trades at PE of 25x and has an ROE of 33.75%, according to Reuter’s data. This compares with Nestle at 26.9x and ROE of 13.7%. We are convinced to add Unilever to the portfolio, as it is a defensive stock with a diversified portfolio, given the economic uncertainty in EU.

Risks: Adverse impact of Brexit could lead to higher import/export tariffs in Europe (Bloom 2016), which could adversely impact the company’s operations and top line. Instability in EU could lead to deflationary trends and negatively impact the pricing of goods sold. Currency fluctuations could also hamper the profitability of the company.

Reuters Consensus rating: Buy (2), outperform (8), Hold (6), Underperform (2) and Sell (1)

### Merlin Entertainment (Buy, Portfolio weight 10%):

Merlin Entertainment was formed in 1999, and is the World’s second biggest visitor attraction operator after Walt Disney. It operates some of the most popular sites like Madame Tussauds, The Eye Brand, LEGOLAND Parks and theme parks like Alton Towers, Heide Park, Chessington World of Adventures, and Warwick Castle to name a few. It has a market cap of c. £4.7 bn and £1.3 bn in revenues in 2015.

Since the Brexit vote, the GBP has been weakening against the Euro. Merlin could stand to gain from Brexit, as a weakening GBP is good for leisure travel and tourism to UK (Farrel 2016). According to Barclay’s analyst Vicki Stern, “We consider Merlin to be one of the least negatively affected Leisure stocks following the ‘leave’ vote”. Further, the Barclays analyst has increased the revenue forecast by 2.5% post the referendum. He also added that the correlation between UK theme park visitation and UK consumer confidence was weak, and should not impact Merlin (Ferguson 2016).

In June 2015, the Smiler tragedy at Alton Towers took place where two visitors lost their legs (BBC 2015). This resulted in closure of the park and reduced number of visitors, impacting the revenues and profitability. Merlin’s total visitor’s growth was flat in 2015 due to the tragedy at Alton Towers, which was also detrimental to the profits as operating profit margin declined to 22.8% from 24.9% in 2014. However, from 2011-15, visitors grew at a CAGR of 7.8% while revenues grew at 10% CAGR on constant currency basis.

Valuation: Merlin trades at a forward PE consensus (DigitalLook 2016) of 22.5 and EPS growth of 15%. This compares fairly to Walt Disney trading at a PE of 20.7 and EPS growth of 13%. We prefer buying the stock and allocating 10% in the portfolio given the depreciation in GBP and its impact on the company.

Risks: Terrorism and recent shooting in Florida could impact the new sites in Orlando. Tragedies like Smiler can pose a threat to visitor numbers to these theme parks. Reduction on leisure spending due to macro uncertainty/Brexit could lead to revenue decline. Unfavourable movement of currency could impact the volume/visitor growth.

Reuter’s consensus rating: Buy (4), Outperform (2), Hold (5), Underperform (0), Sell (0).

### Marks & Spencer

M&S has been struggling with its clothing line, and has been impacted by deteriorating consumer confidence in the UK. The clothing and home goods same store sales for M&S declined 8.9% for 13 weeks to 2 July, vs. analyst estimate of 5% decline (Jarvis 2016). Further, M&S is in the retail industry, which could be adversely impacted by the Brexit. We choose to exclude this stock from the portfolio.

### Royal Mail

Royal Mail is facing a structural decline in letter deliveries given the advent of E-Mail and other forms of communication. Also, the company is cautious due to high transformation costs and a slowdown in continental Europe (Pfanner 2016). Also, if trade agreements are revised post Brexit, we could see a decline in the parcels delivery in and out of the UK.

## Conclusion

As we discussed, the optimum portfolio which diversifies our risks and gives maximum returns consists of EasyJet, Unilever and Merlin out of the 5 Stocks. Although, the Brexit fear surrounds all the companies, we believe that our selected companies could be in a position to sail through these tough and volatile times.

## References:

1. . Markowitz 1952, ‘Portfolio Selection’, Journal of Finance, March, vol. 7, no. 1, pp. 77–91.

Brealey,R, Myers,S, Allen,F 2011, Principles of Corporate Finance, 10th edn, Mc-Graw Hill Irwin, New York.

Tovey, A 2015, ‘Cheaper flights on easyJet as oil price cuts airline's fuel bill’, The Telegraph, 27 January, viewed 14 July 2016, <https://www.telegraph.co.uk/finance/newsbysector/transport/11371657/Cheaper-flights-on-easyJet-as-oil-price-cuts-airlines-fuel-bill.html >

Martin, B 2016, ‘EasyJet presses ahead with plans to set up European company’, The Telegraph, 1 July, viewed 14 July 2016,<https://www.telegraph.co.uk/business/2016/07/01/easyjet-presses-ahead-with-plans-to-set-up-european-company/>

European Travel Commission 2016, ‘European Tourism in 2015: Trends & Prospects’, viewed 14 July, 2016,

<https://www.etc-corporate.org/reports/european-tourism-2015-trends-and-prospects-(q4-2015)>

‘easyJet plc’s (EZJ) “Buy” Rating Reaffirmed at Goldman Sachs’ 2016, American Banking and Market News, 27 June,  viewed 14 July 2016, <https://www.americanbankingnews.com/2016/06/27/easyjet-plc-ezj-stock-rating-reaffirmed-by-goldman-sachs/>

Mann, H 2016, ‘Goldman Sachs names stocks with 60% upside’, Interactive Investor, 13 January, viewed 14 July, <https://www.iii.co.uk/articles/288090/goldman-sachs-names-stocks-60-upside>

Bryan, V 2016, ‘Brexit uncertainty could impact air traffic demand: ACI Europe’, Reuters, 7 July, viewed 14 July 2016, <https://www.reuters.com/article/us-britain-eu-airports-idUSKCN0ZN116?type=companyNews >

Bloom, D 2016, ‘Brexit will make ICE CREAM more expensive warns Unilever boss’, Mirror, 7 June, viewed 14 July 2016, < https://www.mirror.co.uk/news/uk-news/brexit-make-ice-cream-more-8135773>

Wild, R 2016,‘‘Brexit-proof’ your portfolio with Unilever plc, Supergroup plc, Dignity plc and Mediclinic International plc!’, The Motley Fool, 24 June, viewed 15 July 2016, <https://www.fool.co.uk/investing/2016/06/24/brexit-proof-your-portfolio-with-unilever-plc-supergroup-plc-dignity-plc-and-mediclinic-international-plc/>

Neff, J 2016, ‘Unilever Will 'Zero Base' Marketing Budgets in Belt Tightening Move’, Advertising Age, 20 January, viewed 14 July 2016, <https://www.adageindia.in/marketing/cmo-strategy/unilever-will-zero-base-marketing-budgets-in-belt-tightening-move/articleshow/50646630.cms>

Stephens, P 2016, ‘3 stocks with 30% upside: Unilever plc, Sports Direct International plc and WM Morrison Supermarkets plc’, The Motley Fool, 7 July, viewed 14 July, < https://www.fool.co.uk/investing/2016/07/07/3-stocks-with-30-upside-unilever-plc-sports-direct-international-plc-and-wm-morrison-supermarkets-plc/ >

Trefis, 2016, ‘How Might The Brexit Impact Unilever?’, Forbes, 28 June, viewed 14 July 2016, <https://www.forbes.com/sites/greatspeculations/2016/06/28/how-might-the-brexit-impact-unilever/#741cb25f4029>

Pfanner, E 2016, ‘Brexit Pamphlets, Ballots Set to Deliver Boost to Royal Mail’, Bloomberg, 19 May 2016, viewed 13 July 2016, <https://www.bloomberg.com/news/articles/2016-05-19/-brexit-pamphlets-ballots-set-to-deliver-boost-to-royal-mail>

Farrel, S 2016, ‘Brexit business fears overblown, says Merlin chief’, The Guardian, 25 February, viewed 15 July 2016, <https://www.theguardian.com/business/2016/feb/25/brexit-business-fears-overblown-says-merlin-chief >

Ferguson, A 2016,‘Merlin could conjure up some post-Brexit profits’, News.Markets, 28 June 2016, viewed 15 July 2016, <https://news.markets/shares/merlin-conjure-post-brexit-magic-barclays-20593/>

‘Alton Towers rollercoaster crash causes Merlin profit warning’ 2015, BBC News, 27 July, viewed 14 July 2016,<https://www.bbc.com/news/business-33672357>

Jarvis, P 2016, ‘Marks and Spencer sales slumped ahead of Brexit vote’, Independent, 7 July, viewed 14 July, < https://www.independent.co.uk/news/business/news/marks-and-spencer-sales-food-brexit-eu-referendum-marc-bolland-a7124336.html >

Unilever PLC 2016, Reuters, viewed 14 July 2016, <https://in.reuters.com/finance/stocks/analyst?symbol=ULVR.L >

Merlin Entertainments 2016, DigitalLook, viewed 14 July 2016, < https://www.digitallook.com/equity/Merlin_Entertainments >

easyJet PLC 2016, Reuters, viewed 14 July 2016, <https://www.reuters.com/finance/stocks/analyst?symbol=EZJ.L>

Royal Mail PLC 2016, Reuters, viewed 14 July 2016, <https://www.reuters.com/finance/stocks/analyst?symbol=RMG.L >Marks and Spencer Group PLC 2016, Reuters, viewed 14 July 2016,  <https://uk.reuters.com/business/quotes/analyst?symbol=MKS.L >

easyJet plc 2015, ‘Results for the twelve months ended 30 September 2015’, 17 November 2015, viewed 14 July 2016 < https://corporate.easyjet.com/~/media/Files/E/Easyjet-Plc-V2/pdf/investors/results-centre/2015/2015-full-year-results.pdf >

easyJet plc 2016, ‘Results for the six months ended 31 March’, 10 May 2016, viewed 14 July 2016 <https://corporate.easyjet.com/~/media/Files/E/Easyjet-Plc-V2/pdf/investors/results-centre/2016/2016-half-year-results-statement-v2.pdf>

Unilver 2016, ‘Analyst’s consensus’, 8 July 2016, viewed 14 July, < https://www.unilever.com/investor-relations/results-and-publications/analysts-consensus/ >

### Cite This Work

"Financial Information Management." My Assignment Help, 2017, https://myassignmenthelp.com/free-samples/financial-information-management.

My Assignment Help (2017) Financial Information Management [Online]. Available from: https://myassignmenthelp.com/free-samples/financial-information-management
[Accessed 10 August 2020].

My Assignment Help. 'Financial Information Management' (My Assignment Help, 2017) <https://myassignmenthelp.com/free-samples/financial-information-management> accessed 10 August 2020.

My Assignment Help. Financial Information Management [Internet]. My Assignment Help. 2017 [cited 10 August 2020]. Available from: https://myassignmenthelp.com/free-samples/financial-information-management.

### Latest Accounting Samples

#### MACC615 Accounting Theory

Answer: Case 4-4 Research Methodology Several research methodologies help in developing accounting theory. Accounting theory includes the deductive approach, inductive and pragmatic research as the deductive approach includes the development of theory for identifying objectives. The deductive approach is essential for a mental type of research for accounting theory which includes the capability to correctly identifying and relating the variou...

Read More Tags: United States 5 Accounting Theory Minnesota State University

#### ACCT11081 Introductory Financial Accounting

• Course Code: ACCT11081
• University: Central Queensland University
• Country: Australia

Answer: Introducion: As per the requirement I would like to express my viewpoints on recording transactions with parties and also state the importance and requirements of such transaction recording. The maintenance of records is important so that the accountants can have an overall understanding of the financial reporting process. The global financial crisis of 2008 showed that the trust in the business can be a major concern for the business...

#### ACC203 Management Accounting For The Training And Staffing Cost

• Course Code: ACC203
• University: Polytechnic Institute Australia
• Country: Australia

Answer:   Part a Revenue budget  2018     Particulars Amounts   Number of units sold 2000   selling price per unit  \$              800.00   Total Sales Revenue  \$  16,00,000.00       Part b  ...

#### ACCG923 Financial Reporting Disclosures In The Australian Corporate Sector

• Course Code: ACCG923
• University: Macquarie University
• Country: Australia

Answer: Introduction: In the current era, the quality of financial information that the business organisations provide to their users of financial statements is of utmost importance for aiding in the decision-making process of the users. In this report, emphasis would be placed on the impairment write-downs in the Australian corporate sector. For simplification of the report, Wesfarmers Limited is selected as the organisation, which is the le...

#### ACC618 Professional Ethics For The Accountant

Answers: 1. There is a major difference between accrual earnings and cash earnings. Accrual earnings are considered as incomes and other earned revenues during a financial period, but not received until the next of future financial period. On the other hand, cash earnings are considered as the residual profit of a company after subtracting the cash expenses from the case revenues. The calculation of deriving cash earnings does not include any...

Read More Tags: Australia Arlington Management University of New South Wales
Next

### Save Time & improve Grade

Just share Requriment and get customize Solution.

Orders

Overall Rating

Experts

### Our Amazing Features

#### On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

#### Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

#### 24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat.

#### Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

#### Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

### Our Experts

5/5

1692 Order Completed

98% Response Time

### Alfred Dodd

#### Wellington, New Zealand

5/5

93 Order Completed

100% Response Time

### Jackson Mitchell

#### New Jersey, United States

5/5

184 Order Completed

96% Response Time

### Arapera Billing

#### Wellington, New Zealand

5/5

1896 Order Completed

95% Response Time

### FREE Tools

#### Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

#### Essay Typer

Get different kinds of essays typed in minutes with clicks.

#### Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

#### Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

## Refer Just 5 Friends to Earn More than \$2000

1

1

1

### Live Review

Our Mission Client Satisfaction

Awesome work. Awesome response time. Very thorough & clear. Love the results I get with MAH!

#### User Id: 383727 - 31 Jul 2020

Australia

Work was done in a timely manner took it through grammarly checked for plagiarism very well satisfied

#### User Id: 463334 - 31 Jul 2020

Australia

Great work for the short notice given. Thank you for never disappointing and helping out.

#### User Id: 194216 - 31 Jul 2020

Australia

I received a full point on the assignment. Thank you for all the help with the assignment.

Australia