Stock Market Data Analysis

This assignment involves analyzing a dataset of stock market data for multiple companies over time. The data includes daily closing prices and percentage changes. Students are expected to examine the trends and fluctuations in these prices, potentially identifying patterns or correlations.

Running head: BUSINESS ECONOMICS
Business Economics
Name of Student:
Name of University:
Author’s Note:

1
BUSINESS ECONOMICS
Executive Summary
The report aims to analyse the different types of the aspects which has been taken into
consideration with the overall economy of U.K. The report has been further able to consider the
different types of the aspects for the global economy. The various considerations for the report
have been also able to depict the industry analysis of automobile sector. Some of the various
types of the other consideration of the report have been seen with the use of technological based
industry in U.K. The investment portfolio has been further seen to be based on the various types
of the consideration taken with the rationale of demand and supply being elastic or inelastic. The
latter section of the report has been further included a recommendation precisely stating that
whether it is worth to invest a £3-8 million on the selected company. The global opportunities
have been evident with increasing trade prices and larger amount of FDI in 2010 in international
foreign direct investment and international trade has been seen to be associated to the various
types of the depiction which has been further considered with the strengthening of financial
control and risk management strategies. The various types of the global threats have been further
seen to be discerned in terms of global macroeconomic policy caught in dilemma and increased
form of the requirement of the proportion of the capital. The opportunities in the UK economy
have been further discerned in terms of emerging in nature of non-EU markets and significantly
faster growth for the foreseeable future. UK markets will be further able to set its own tariff for
better protection in global economy. As per the application of CAPM it can be discerned that the
investment of £3-8 million on Rolls-Royce Holdings is not recommended due to significantly
lower rate of return as per the market depiction of last five years. If the same amount of money is
invested in government bond of U.K. or UK Gilt for a total period of 10 year then an investor
will be able to earn returns as per the risk free rate of 1.34% as against the stock of Rolls-Royce
Holdings which is only 1.224%.

2
BUSINESS ECONOMICS
Table of Contents
Introduction......................................................................................................................................3
Analysis of the global economy and UK Economy.........................................................................4
Global economy...........................................................................................................................4
UK Economy...............................................................................................................................5
Large vertical market.......................................................................................................................5
Industry analysis..............................................................................................................................6
Investment portfolio.........................................................................................................................7
Asserting the nature of Demand and Supply...............................................................................7
Effect of Brexit in the Business.......................................................................................................8
Strategy will be impacted by Brexit................................................................................................8
Importing from EU countries...........................................................................................................9
Conclusion.......................................................................................................................................9
Recommendation...........................................................................................................................10
References......................................................................................................................................12
List of Appendix............................................................................................................................14

3
BUSINESS ECONOMICS
Introduction
Rolls-Royce Holdings plc is identified as a British multinational public limited company
which has been incorporated in the year 2011. The main business was seen to be initiated in the
year 1904. The primary operations of the company have been further seen to be related to
manufacturing power distribution systems for aviation and second largest in terms of the aircraft
engines in the energy sectors and marine propulsion. As per the main depictions of the company
it has been further identified that the company has been 16th largest in terms of the defence
contractor in 2011 and 2012. The main listing of the company has been further seen to be based
in terms of London Stock Exchange listing.
The study has been seen to analysis the different types of the aspects which has been
taken into consideration with the overall economy of U.K. The report has been further able to
consider the different types of the aspects for the global economy. The various considerations for
the report have been also able to depict the industry analsysis of automobile sector. Some of the
various types of the other consideration of the report have been seen with the use of
technological based industry in U.K. The investment portfolio has been further seen to be based
on the various types of the consideration taken with the rationale of demand and supply being
elastic or inelastic. The latter section of the report has been further included a recommendation
precisely stating that whether it is worth to invest a £3-8 million on the selected company (Alston
and Pardey, 2014).

4
BUSINESS ECONOMICS
Analysis of the global economy and UK Economy
Global economy
Opportunities
 The present standings of the world economy have been able to get rid of the various types
of the negative impact of the global financial crisis. Therefore, the emerging economies
have been able to be considered as the centre of the global economic development.
 The international foreign direct investment and international trade has been seen to be
associated to the various types of the depiction which has been considered with the
increasing trade prices and larger amount of FDI in 2010 (Arvis et al., 2016).
 The different types of the financial control and risk management strategies has been seen
to be strengthened (Goel and Saunoris, 2014).
 The G20 platform has been identified to become an significant platform for International
economy cooperation (EdinburghGroup, 2014).
Threats
 Based on the present analysis US dollar is dominated with the various types of the
international monetary system which has led to several instance of global imbalance
instances
 The increased form of the requirement of the proportion of the capital has been further
seen to be based on the several type the consideration which has been able to state on the
significant aspects on the commercial banks which will be able to affect the world
economy (Seabrooke and Wigan, 2014)

5
BUSINESS ECONOMICS
 The world trade protectionism has been seen to impede on the free movement of the
goods in the development of the economic globalization (WRAP, 2015).
UK Economy
Opportunities
 The non-EU markets are discerned to be emerging in nature and significantly faster
growth for the foreseeable future.
 U.K. votes will be further considered as per the different types of the consideration for
trade deals with the main non-EU markets (WRAP, 2015)
 UK markets will be further able to set its own tariff for better protection in global
economy (Gibbs and O’Neill, 2015)
Threats
 The decision of UK to remain in the EU has been seen to be identified as the main form
of the threat (Tyler, 2017)
 The favouring of the removal of the social and the employment regulation has been
further seen to be considered with removing of the employment protection in the country
Large vertical market
Competition
Some of the main competition of the company has been identified with “GE Aviation
Systems LLC, SAFRAN and Pratt & Whitney Engine Services Inc.
Major Customer

6
BUSINESS ECONOMICS
“Singapore Airlines (SIA)” is considered as one of the key customer of Rolls Royce.
Other important regional customers have been seen with “Malaysian Airlines, for its A380 fleet,
powered by Rolls-Royce Trent 900 engines and supported by TotalCare services’. Some of the
other customers of the company has been further discerned with “Republic of Singapore Air
Force (RSAF)”. The company has been further discerned with significant Marine presence in
Singapore along with carrying out the sales and after market activities for the vessel design.
Rolls Royce has been further seen with customers such as “ExxonMobil and Petronas in
Malaysia”.
Comparison with another PE firm
The comparison of the Rolls Royce with Bentley has shown that due to higher price of
the models Rolls Royce is having lesser sale of units in compared to Bentley in 2016. It has been
further discerned that Rolls Royce has been able to sell 4011 cars delivered to the customers.
Bentley has been further able to sell 11,023 cars in 2016.
Industry analysis
The automotive sector in UK has been seen to be best known for the inclusion of
premium sports car including Jaguar, Lagonda, Land Rover, Mini, Morgan and Rolls-Royce. It
has been further considered that the various types of the consideration for the automotive
manufacturing sector has been able to include the different type of the turnover of £52.5 billion
and generated as per £26.6 billion of exports and produced with a total number of customer base
of 1.45 million passengers with production of more than 203000 commercial vehicles (Drezner
and McNamara, 2013). The major centre for the manufacturing aspect of the company has been
further seen to be based on the various types of the important consideration including major

7
BUSINESS ECONOMICS
manufacturing sector in 2008 and 3.16 million engines. In addition to this, U.K. is seen to be
having a significant position in the auto racing and the UK motorsport industry, consisting of a
total of 38500 people and including a total of 4500 companies (Chowla, Quaglietti and Rachel,
2014).
Investment portfolio
It has been discerned that the revenue of the company before taxation in 2016 has been
£14955m and £113725m. The net loss before taxation has been further seen as £ 160m in 2015.
The potential scope for reducing the cost has been discerned with Warren East, chief executive
of Rolls-Royce. He has declared to cut down the total cost by £1bn, in addition to this also
proposed to barely pass break even in the first half of 2016. The scope of increasing EBITDA
has been discerned with strategy to abandon the strategy of diversification.
Asserting the nature of Demand and Supply
It has been seen that the in the year 2016, Rolls Royce revised its price from $ 1240000
to $ 1209000. The main rationale for the decrease in the price has been seen with elastic nature
of demand. Due the Brexit, there was a significant decrease in the Rolls Royce cars. However,
the company was able to increase the sales in the same year. It has been further seen to be
discerned that the of Rolls Royce has been further seen to be based on Elastic supply. This has
been seen with the main reason for the increase in the supply of Rolls Royce cars in the same
year.
The investment portfolio has been taken into consideration based on the application of
“Capital Asset Pricing Model (CAPM)”. The adoption of this model has been able to be
considered with the inclusion of the various types of the factors which has been seen to be

8
BUSINESS ECONOMICS
associated to the value of the portfolio. Some of the important aspect has been further seen to be
based on the evaluation as per the expected market return of Rolls Royce Holdings and required
rate of return. The main formula for depicting the rate of return of the Rolls Royce Holdings has
been seen with
βa 0.123
Risk Free Rate (Rf) 1.34%
Expected market return of
Rolls-Royce Holdings
(Rm1) 0.39%
Required rate of return 1.224%
Effect of Brexit in the Business
Rolls Royce has called for "as little change as possible" which can be made to reduce the
impact except for the European Union. The company has been further able to include good
amount of profit excluding the sterling’s decline and the SFO penalty.

9
BUSINESS ECONOMICS
Strategy will be impacted by Brexit
Rolls Royce has been trying to overhaul the engine maker by replacing the chief
executive of the company. The main form of the inherited for the long term success of the
company has been seen with the cutting down of the underlying profit which has been seen with
the cutting down of the dividend with the payout of the shareholders for the first time in the
decade and cutting down of the dividend payout.
Importing from EU countries
Importing from the EU countries has been further seen to be considered with the to be
risky venture especially with Rolls-Royce and the wider BMW Group which may adversely
affect Brexit. The free trade is seen to be important internationally with the import of Rolls-
Royce Motor Cars. The significant increase in the tariff barrier has been identified with higher
amount of cost along with higher prices for Rolls Royce.
Conclusion
As per the industry analysis it has been discerned that automotive sector in UK has been
seen to be best known for the inclusion of premium sports car including Jaguar, Lagonda, Land
Rover, Mini, Morgan and Rolls-Royce. It has been further considered that the various types of
the consideration for the automotive manufacturing sector has been able to include the different
type of the turnover of £52.5 billion and generated as per £26.6 billion of exports and produced
with a total number of customer base of 1.45 million passengers. The various types of the global
opportunities have been identified with increasing trade prices and larger amount of FDI in 2010
in international foreign direct investment and international trade has been seen to be associated to
the various types of the depiction which has been further considered with the strengthening of

10
BUSINESS ECONOMICS
financial control and risk management strategies. In addition to this, the G20 platform has been
identified to become a significant platform for International economy cooperation. The various
types of the global threats has been further seen to be discerned in terms of global
macroeconomic policy has been seen to be caught in dilemma and increased form of the
requirement of the proportion of the capital has been further seen to be based on the several type
the consideration which has been able to state on the significant aspects on the commercial banks
which will be able to affect the world economy. The investment portfolio has been taken into
consideration based on the application of “Capital Asset Pricing Model (CAPM)” and as per the
assessment UK government bond will allow the investor to earn an excess risk free yield of
0.116% over a period of 10 years. Henceforth, the investment of £3-8 million on Rolls-Royce
Holdings is not recommended due to significantly lower rate of return of 1.224% as per the
market depiction of last five years.
Recommendation
The different recommendations for the company have been based on the main rationale
whether to invest £3-8 million on Rolls-Royce Holdings. The various types of the other depiction
of the study has been further able to provide the main rational which has been related with the
present analysis of global and economy in U.K.. This has been further seen to be based on the
various types of the analysis as per the Investment portfolio plan prepared with the CAPM
model. In order to find the required rate of return and the total stock of Rolls-Royce Holdings has
been evaluated with the closing price of London stock exchange for tenure of five years taken on
monthly basis. As per the applied technique it can be discerned that the investment of £3-8
million on Rolls-Royce Holdings is not recommended due to significantly lower rate of return as
per the market depiction of last five years. If the same amount of money is invested in

11
BUSINESS ECONOMICS
government bond of U.K. or UK Gilt for a total period of 10 years then an investor will be able
to earn returns as per the risk free rate of 1.34% as against the stock of Rolls-Royce Holdings
which is only 1.224%. Henceforth, the investment in UK government bond will allow the
investor to earn an excess yield of 0.116% over a period of 10 years. It has been further
discerned that due to several types of existing threats in the economy of UK such as decision of
UK to remain in the EU and favouring of the removal of the social and the employment
regulation has been further seen to be considered with removing of the employment protection in
the country will pose significant amount of risk to the investor with the investment in shares.

12
BUSINESS ECONOMICS
References
Alston, J. M. and Pardey, P. G. (2014) ‘Agriculture in the Global Economy’, Journal of
Economic Perspectives, 28(1), pp. 121–146. doi: 10.1257/jep.28.1.121.
Arvis, J. et al. (2016) ‘Connecting to Compete: Trade Logistics in the Global Economy’, World
Bank, pp. 1–76. Available at: http://lpi.worldbank.org/international/global.
Chowla, S., Quaglietti, L. and Rachel, L. (2014) ‘How have world shocks affected the {UK}
economy?’, Bank of England Quarterly Bulletin, 54(2), pp. 167–179.
Drezner, D. W. and McNamara, K. R. (2013) ‘International Political Economy, Global Financial
Orders and the 2008 Financial Crisis’, Perspectives on Politics, 11(1), pp. 155–166. doi:
10.1017/S1537592712003660.
EdinburghGroup (2014) ‘Growing the global economy through SMEs’, The Edinburgh Group,
pp. 1–40. Available at:
http://www.edinburgh-group.org/media/2776/edinburgh_group_research_-
_growing_the_global_economy_through_smes.pdf.
Gibbs, D. and O’Neill, K. (2015) ‘Building a green economy? Sustainability transitions in the
UK building sector’, Geoforum, 59, pp. 133–141. doi: 10.1016/j.geoforum.2014.12.004.
Goel, R. K. and Saunoris, J. W. (2014) ‘Global corruption and the shadow economy: Spatial
aspects’, Public Choice, 161(1–2), pp. 119–139. doi: 10.1007/s11127-013-0135-1.
Seabrooke, L. and Wigan, D. (2014) ‘Global wealth chains in the international political
economy’, Review of International Political Economy, pp. 257–263. doi:

13
BUSINESS ECONOMICS
10.1080/09692290.2013.872691.
Tyler, G. (2017) Financial services: contribution to the UK economy, Commons Briefing papers.
Available at: http://researchbriefings.parliament.uk/ResearchBriefing/Summary/SN06193.
WRAP (2015) ‘Employment and the Circular Economy | WRAP UK’, WRAP, 2. October, p. 3.
Available at: http://www.wrap.org.uk/content/employment-and-circular-economy%5Cnhttp://
www.wrap.org.uk/content/wrap-and-circular-economy?
utm_source=WRAP+Newsletters&utm_campaign=0167891419-
Re_use_News_September_2015_DRAFT8_25_2015&utm_medium=email&utm_term=0_165af
891aa.

14
BUSINESS ECONOMICS
List of Appendix
Calculation of required rate of return of Rolls-Royce Holdings
Date
Closing
Price of
Rolls-
Royce
Holdings
Percentage
Monthly
change Date
Closing
Price Of
LSE
Percentage
monthly change
closing price of
LSE
9/30/2012 0 0 9/30/2012 0 0
11/1/2012 890.5 0.000% 11/1/2012 900.420 0.000%
12/1/2012 873.5 -1.909% 12/1/2012 1002.210 11.305%
1/1/2013 946 8.300% 1/1/2013 1109.060 10.661%
2/1/2013 1028 8.668% 2/1/2013 1228.810 10.797%
3/1/2013 1130 9.922% 3/1/2013 1203.020 -2.099%
3/31/2013 1130 0.000% 3/31/2013 1235.260 2.680%
4/30/2013 1205 6.637% 4/30/2013 1295.130 4.847%
5/31/2013 1134 -5.892% 5/31/2013 1231.570 -4.908%
6/30/2013 1175 3.616% 6/30/2013 1449.880 17.726%
7/31/2013 1112 -5.362% 7/31/2013 1436.990 -0.889%
8/31/2013 1112 0.000% 8/31/2013 1415.800 -1.475%
9/30/2013 1150 3.417% 9/30/2013 1512.520 6.831%
11/1/2013 1235 7.391% 11/1/2013 1498.700 -0.914%
12/1/2013 1275 3.239% 12/1/2013 1596.350 6.516%
1/1/2014 1187 -6.902% 1/1/2014 1694.910 6.174%
2/1/2014 999 -15.838% 2/1/2014 1867.160 10.163%
3/1/2014 1074 7.508% 3/1/2014 1814.660 -2.812%
3/31/2014 1050 -2.235% 3/31/2014 1669.120 -8.020%
4/30/2014 1040 -0.952% 4/30/2014 1803.600 8.057%
5/31/2014 1069 2.788% 5/31/2014 1848.740

15
BUSINESS ECONOMICS
2.503%
6/30/2014 1040 -2.713% 6/30/2014 1785.180 -3.438%
7/31/2014 1021 -1.827% 7/31/2014 1881.900 5.418%
8/31/2014 964.5 -5.534% 8/31/2014 1868 -0.739%
9/30/2014 843 -12.597% 9/30/2014 2015 7.869%
11/1/2014 842.5 -0.059% 11/1/2014 2255 11.911%
12/1/2014 870 3.264% 12/1/2014 2221 -1.508%
1/1/2015 891.5 2.471% 1/1/2015 2365 6.484%
2/1/2015 949 6.450% 2/1/2015 2480 4.863%
3/1/2015 953 0.421% 3/1/2015 2459 -0.847%
3/31/2015 1046 9.759% 3/31/2015 2549 3.660%
4/30/2015 998 -4.589% 4/30/2015 2457 -3.609%
5/31/2015 870 -12.826% 5/31/2015 2370 -3.541%
6/30/2015 794 -8.736% 6/30/2015 2611 10.169%
7/31/2015 743.5 -6.360% 7/31/2015 2512 -3.792%
8/31/2015 677 -8.944% 8/31/2015 2419 -3.702%
9/30/2015 687.5 1.551% 9/30/2015 2545 5.209%
11/1/2015 606.5 -11.782% 11/1/2015 2650 4.126%
12/1/2015 575 -5.194% 12/1/2015 2744 3.547%
1/1/2016 555 -3.478% 1/1/2016 2474 -9.840%
2/1/2016 679 22.342% 2/1/2016 2678 8.246%

16
BUSINESS ECONOMICS
3/1/2016 682 0.442% 3/1/2016 2820 5.302%
3/31/2016 669.5 -1.833% 3/31/2016 2713 -3.794%
4/30/2016 619 -7.543% 4/30/2016 2735 0.811%
5/31/2016 711.5 14.943% 5/31/2016 2531 -7.459%
6/30/2016 791 11.174% 6/30/2016 2775 9.640%
7/31/2016 770 -2.655% 7/31/2016 2755 -0.721%
8/31/2016 720 -6.494% 8/31/2016 2800 1.633%
9/30/2016 726.5 0.903% 9/30/2016 2810 0.357%
11/1/2016 676.5 -6.882% 11/1/2016 2748 -2.206%
12/1/2016 668 -1.256% 12/1/2016 2914 6.041%
1/1/2017 667.5 -0.075% 1/1/2017 3171 8.819%
2/1/2017 787 17.903% 2/1/2017 3078 -2.933%
3/1/2017 754 -4.193% 3/1/2017 3171 3.021%
3/31/2017 812 7.692% 3/31/2017 3383 6.686%
4/30/2017 867.5 6.835% 4/30/2017 3425 1.242%
5/31/2017 891 2.709% 5/31/2017 3646 6.453%
6/30/2017 888 -0.337% 6/30/2017 3748 2.798%
7/31/2017 914 2.928% 7/31/2017 3950 5.390%
8/31/2017 887 -2.954% 8/31/2017 3830 -3.038%
9/30/2017 964.5 8.737% 9/30/2017 3794 -0.940%