$20 Bonus + 25% OFF +
5
%
Cashback
information
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

Financial Information Management

tag 0 Download10 Pages 2,409 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
Levi Anderson Student Reviews Student Reviews Student Reviews Student Reviews Student Reviews 4.9/5 hire me

Question:

Write an essay on Financial Information Management.

 

Answer:

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/ >

OR

MyAssignmenthelp.com provides guaranteed satisfaction with a commitment to complete the work within time. Combined with our meticulous work ethics and extensive domain experience, MyAssignmenthelp.com is the ideal partner for all your homework/assignment needs. We pledge to provide 24*7 support to dissolve all your academic doubts. We are composed of 3000+ esteemed experts who have been empanelled after extensive research and quality check. MyAssignmenthelp.com provides undivided attention to each assignment order with a methodical approach to solution. Our network span is not restricted to US, UK and Australia rather extends to countries like Singapore, Canada and UAE. Our assignment help services include thesis help, case study help, homework help, coursework help, MBA help and Programming help. Get your work done at the best price in industry.

Most Downloaded Sample Of Accounting

Achievement Of Environmental Goals At Visy

Download : 388 | Pages : 4

Introduction With the increasing awareness among the public conceing the environmental related issues, business organizations are finding it essential to implement certain measures so as to protect the environment from the day to day activities undertaken by them. They have realized that in order to survive in this competitive era, it becomes essential for them to take initiatives that helps them in protecting the environment in a most effective...

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

Accounting And Financial Management: Case Of British Petroleum

Download : 199 | Pages : 20

  Executive Summary Accounting and financial management are the main backgrounds of the report under which the financial evaluation of British Petroleum (BP) is conducted. BP is a leading company that explores produces, refines and markets oil and gas products including fuel, lubricants, energy and petrochemicals product. It deals in different segments including upstream, midstream and downstream to the oil and energy production. It serv...

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

Auditing And Ethical Practice In Australia

Download : 336 | Pages : 11

Ques: Describe the purpose and concepts of analytical procedures based on the applicable auditing standards (ASA) in Australia?   Table of Contents Executive summary Introduction Purpose and concepts of analytical procedures in ASA standards in Australia Analysis of the performance, risk and continuity of three public listed companies Comparison between the three companies Affect of auditor’s judgment on the various analytical ...

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

Report On Managerial Accounting

Download : 292 | Pages : 9

Question-Asked to present the case for a major investment programme. As well as outlining the financial aspects using all the investment techniques and tools you know of, you are also required to assess the qualitative issues especially any environmental and sustainability concerns that may arise. Please choose carefully a company, which would put your case across perfectly?     Table of Contents Introduction Sponsors Ticket sales...

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

Gender Differences In Financial Reporting Decision

Download : 0 | Pages : 9

Questions: 1. Making managerial pay contingent on measures of managerial and/or firm performance motivates them to deliver good performance for shareholders. However, it also burdens them with greater risks than they may like. How do organisations balance these two considerations when choosing managerial pay and performance measures? 2. Obtain the remuneration report for a publicly listed company. Examine the compensation contract for the chi...

Read More arrow
Next
watch

Save Time & improve Grade

Just share Requriment and get customize Solution.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

1,111,142

Orders

4.9/5

Overall Rating

5,043

Experts

Our Amazing Features

delivery

On Time Delivery

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

work

Plagiarism Free Work

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

time

24 X 7 Live Help

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

subject

Services For All Subjects

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

price

Best Price Guarantee

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

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

1265 Order Completed

97% Response Time

James Cook

Masters in Management

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

647 Order Completed

98% Response Time

Adlina Han

Masters in Marketing with Specialization in Branding

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

453 Order Completed

98% Response Time

Howard Asuncion

LLM in Criminal Law

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

416 Order Completed

95% Response Time

Tyler Moore

MBA in Accounting

Washington, United States

Hire Me

FREE Tools

proofreading

Proofreading & Editing

Complete guid on proofreading and editing.

plagiarism

Plagiarism Checker

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

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

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

calculator

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

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

I love this service its affordable and dependable I will definitely recommend this service to all my friends!

flag

User Id: 234644 - 17 Oct 2019

Australia

student rating student rating student rating student rating student rating

well only thing you should work on is your english and originality of the work .

flag

User Id: 302636 - 17 Oct 2019

Australia

student rating student rating student rating student rating student rating

Although not a very good result, but I have passed my assignment. Thank you very much.

flag

User Id: 202550 - 16 Oct 2019

Australia

student rating student rating student rating student rating student rating

Hi There and thank you so much complete my assignment work I am happy with the work and with the reference for this assignment

flag

User Id: 45953 - 16 Oct 2019

Australia

student rating student rating student rating student rating student rating
Have any Query?