Finance: 1192112

Question 2: Valuation of a Company’s Shares

The above figure directly states about the overall P/E ratio of Anglo-American Company for the past 10 years. The above calculations states about the overall P/E ratio, which changes with the earnings per share of the organisation (Sharif, Purohit & Pillai, 2015). There is direct link between the P/E ratio of the company and the FTSE 100, where decline int eh value in the market is witnessed within the organisation. From the relevant analysis, it has been detected that the increment in P/E ratio of the industry and the company is similar in nature, which directly affects the overall share price conditions of the company. Thus, in the similar process the overall share price value of the companies has reacted with the price fluctuations of the Index. The impact of P/E ratio of the organisations are similar, which is mainly altering the share price of the company on yearly basis regardless of the EPS increment. The company’s EPS has lower impact on their share price, where higher income generated by the organisation has minimal impact on its valuation (Arkan, 2016).

There are other factors that have an impact on the share price value of the company, which are depicted as follows.

  • Change in the current capital market trend, which have direct impact on the share valuation of the company.
  • Changes in the dividend declared by the organisation, which crates demand in the capital market (Phan, Sharma & Narayan, 2015).
  • Alterations in debt to equity conditions and beta values directly have impact on valuation of the company.

Question 3: Portfolio Analysis

a) Creating four equally weighted portfolios:

ParticularsStandard deviationVariances
4IMPRINT GROUP0.1007292340.0101464
888 HOLDINGS0.1189570460.0141508
ANTOFAGASTA0.1065666010.0113564
APTITUDE SOFTWARE GROUP0.0930842650.0086647
ASHTEAD GROUP0.1188614420.014128
AVEVA GROUP0.089083440.0079359
AVON RUBBER0.1124300880.0126405
BARRATT DEVELOPMENTS0.1126703060.0126946
BBA AVIATION0.0740770650.0054874
BELLWAY0.0848371510.0071973
BERKELEY GROUP HDG.0.0691088680.004776
BIG YELLOW GROUP0.0749860490.0056229
BODYCOTE0.0916574350.0084011
BOOT (HENRY)0.0697682710.0048676
BURBERRY GROUP0.0869233040.0075557
Portfolio 10.1007292340.0101464
Portfolio 20.0640692620.0041049
Portfolio 30.0554683020.0030767
Portfolio 40.0508009690.0025807
ParticularsStandard deviationVariances Return
Portfolio 10.1007292340.01014640.02592
Portfolio 20.0640692620.00410490.02138
Portfolio 30.0554683020.00307670.02201
Portfolio 40.0508009690.00258070.02012
ParticularsStandard deviationVariances
Portfolio 10.1007292340.010146379
4IMPRINT GROUP0.1007292340.010146379
   
ParticularsStandard deviationVariances
Portfolio 20.1007292340.010146379
4IMPRINT GROUP0.1007292340.010146379
888 HOLDINGS0.1189570460.014150779
ANTOFAGASTA0.1065666010.011356441
APTITUDE SOFTWARE GROUP0.0930842650.00866468
ASHTEAD GROUP0.1188614420.014128042
   
ParticularsStandard deviationVariances
Portfolio 30.1007292340.010146379
4IMPRINT GROUP0.1189570460.014150779
888 HOLDINGS0.1065666010.011356441
ANTOFAGASTA0.0930842650.00866468
APTITUDE SOFTWARE GROUP0.1188614420.014128042
ASHTEAD GROUP0.089083440.007935859
AVEVA GROUP0.1124300880.012640525
AVON RUBBER0.1126703060.012694598
BARRATT DEVELOPMENTS0.0740770650.005487412
BBA AVIATION0.0848371510.007197342
BELLWAY0.0691088680.004776036
ParticularsStandard deviationVariances
Portfolio 40.0508009690.002581
4IMPRINT GROUP0.1007292340.010146
888 HOLDINGS0.1189570460.014151
ANTOFAGASTA0.1065666010.011356
APTITUDE SOFTWARE GROUP0.0930842650.008665
ASHTEAD GROUP0.1188614420.014128
AVEVA GROUP0.089083440.007936
AVON RUBBER0.1124300880.012641
BARRATT DEVELOPMENTS0.1126703060.012695
BBA AVIATION0.0740770650.005487
BELLWAY0.0848371510.007197
BERKELEY GROUP HDG.0.0691088680.004776
BIG YELLOW GROUP0.0749860490.005623
BODYCOTE0.0916574350.008401
BOOT (HENRY)0.0697682710.004868
BURBERRY GROUP0.0869233040.007556
Co-variance4IMPRINT GROUP888 HOLDINGSANTOFAGASTAAPTITUDE SOFTWARE GROUPASHTEAD GROUP
4IMPRINT GROUP0.0101463790.0007557110.0006321690.0011498470.00386227
888 HOLDINGS0.0007557110.0141507790.0025818760.0010161210.003762998
ANTOFAGASTA0.0006321690.0025818760.0113564410.0015534920.004597827
APTITUDE SOFTWARE GROUP0.0011498470.0010161210.0015534920.008664680.002175409
ASHTEAD GROUP0.003862270.0037629980.0045978270.0021754090.014128042

b)  Determining the betas for BP and Ferguson

BP        
SUMMARY OUTPUT        
         
Regression Statistics       
Multiple R0.683602933       
R Square0.46731297       
Adjusted R Square0.462798673       
Standard Error0.054633646       
Observations120       
         
ANOVA        
 dfSSMSFSignificance F   
Regression10.3089854950.308985495103.51844017.72853E-18   
Residual1180.3522105660.002984835     
Total1190.661196061      
         
 CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%
Intercept-0.0046209760.005034128-0.9179298450.360528015-0.014589920.005347968-0.014589920.005347968
FTSE ALL SHARE (Beta)1.4278647320.14033894510.174401227.72853E-181.1499554141.705774051.1499554141.70577405
FERGUSON        
SUMMARY OUTPUT        
         
Regression Statistics       
Multiple R0.526440179       
R Square0.277139262       
Adjusted R Square0.271013323       
Standard Error0.079622367       
Observations120       
         
ANOVA        
 dfSSMSFSignificance F   
Regression10.2868108620.28681086245.240294796.5913E-10   
Residual1180.7480871180.006339721     
Total1191.03489798      
         
 CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%
Intercept0.0074514930.0073366731.015650240.311873944-0.0070771160.021980103-0.0070771160.021980103
FTSE ALL SHARE (Beta)1.3756749150.2045281576.7260906026.5913E-100.9706534811.7806963490.9706534811.780696349

References:

Arkan, T. (2016). The importance of financial ratios in predicting stock price trends: A case study in emerging markets. Finanse, Rynki Finansowe, Ubezpieczenia79(1), 13-26.

Phan, D. H. B., Sharma, S. S., & Narayan, P. K. (2015). Stock return forecasting: some new evidence. International Review of Financial Analysis40, 38-51.

Sharif, T., Purohit, H., & Pillai, R. (2015). Analysis of factors affecting share prices: The case of Bahrain stock exchange. International Journal of Economics and Finance7(3), 207-216.