Lowest guaranteed price across the globe. Get upto 50% off ! Book Now

Valuation of Securities and Equity Trading

University: University of Chester

  • Unit No: 9
  • Level: Undergraduate/College
  • Pages: 28 / Words 7043
  • Paper Type: Assignment
  • Course Code:
  • Downloads: 619

INTRODUCTION

Security valuation depends on performance of organisation in the market which enables the managerial professionals in retaining the fruitful gains for the period. Ascertaining the ups and downs in value of share prices will have impacts over valuation of firm. In the present report there will be analysis based on investigating market value of 5 shares such as Tesco, Barclays, BP, Marks and Spencer and Burberry. These share will be analysed as per their rate of return as well as compatibility through portfolio analysis. Moreover, report will have discussion based on impacts of keeping a portfolio in the organisation. Therefore, there will be various advantaged and disadvantages were analyte and discussed as per having suitable determination of all facts.

PART A

1. Computing average monthly return

Ascertaining the average monthly rate of return which will be based on measuring the returns with the influences to the returns a firm in each month. Moreover, in consideration with analysing the average monthly returns made by Tesco, Barclays, BP, Marks and Spencer and Burberry has been analysed in between period of 1stJanuary 2011 to 20thJune 2018. In addition, referring to the below listed appendix there has been analysis of all the share and marketable securities of these organisations. Summing up the rate of return payable by these organisations can be seen as:

Rate of return

Tesco

-24.82%

Barclays

19.46%

BP

55.48%

Marks and Spencer

33.74%

Burberry

112.05%

FTSE

35.76%

Interpretation: On the basis of above mentioned summarized information regarding the rate of return palatable by these organisations and the capital market on which it can be said that Burberry has most favourable outcomes. Along with this, Tesco has comparatively poor performance and which reflects in the negative outcomes. Therefore, many of times firm is have negative outcomes which ascertains that there is needed to have sufficient amount of investments in the firm which will be effective and helpful as per enhancing market value of securities.

2. Measuring average monthly return and risk

Tesco

Marks and Spencer

Barclays

BP Plc

Burberry

FTSE

Rate of return

Rate of Return

Rate of Return

Rate of Return

Rate of return

Rate of Return

0

0

0

0

0

0

0

0

0

0

0

0

2.35%

-2.83%

8.89%

2.11%

11.64%

-0.61%

-7.64%

-2.80%

-12.49%

-8.11%

-2.09%

2.05%

8.32%

15.24%

1.71%

4.53%

10.31%

-1.25%

6.29%

2.81%

-2.00%

0.22%

1.85%

2.85%

-5.77%

-9.40%

-6.95%

-3.31%

9.93%

-1.08%

-3.67%

-1.54%

-13.04%

2.60%

3.03%

-0.78%

-1.43%

-6.93%

-23.43%

-13.31%

-6.88%

-2.28%

-4.41%

-2.36%

-4.93%

-7.54%

-14.74%

-7.45%

9.89%

2.32%

21.04%

22.48%

14.22%

-5.22%

-1.19%

2.58%

-7.71%

-1.43%

-5.29%

7.78%

-1.36%

-4.03%

-1.75%

-0.89%

-6.13%

-0.87%

-18.95%

5.08%

20.73%

7.42%

13.92%

0.78%

-0.46%

11.08%

15.27%

2.72%

5.22%

2.63%

5.20%

4.41%

-2.70%

-3.58%

6.02%

3.78%

-2.69%

-5.80%

-7.23%

-3.53%

-0.80%

-1.35%

-6.50%

-7.17%

-19.22%

-16.01%

-7.95%

-0.60%

3.40%

1.24%

-7.18%

12.53%

-3.07%

-7.29%

2.74%

2.68%

3.16%

-1.58%

-5.36%

4.49%

7.40%

7.22%

9.08%

5.41%

9.37%

1.24%

0.43%

-0.28%

17.95%

1.86%

-26.02%

1.55%

-3.89%

10.37%

5.89%

1.25%

16.48%

0.88%

2.28%

-0.81%

8.13%

-2.63%

10.38%

0.85%

5.81%

-0.52%

7.15%

0.98%

-4.74%

1.35%

2.59%

-0.68%

14.71%

6.92%

11.39%

0.92%

-0.71%

-2.21%

1.99%

-9.25%

1.40%

6.27%

3.43%

5.04%

-4.04%

6.15%

-3.42%

1.89%

0.06%

4.77%

-1.75%

2.95%

0.53%

0.93%

-4.00%

15.25%

12.03%

-1.58%

8.76%

0.28%

-6.64%

-6.45%

-12.78%

-1.52%

-7.02%

2.47%

10.30%

11.79%

3.39%

-0.72%

13.25%

-5.30%

2.85%

-2.04%

-1.58%

-0.34%

1.78%

6.69%

1.50%

5.28%

1.82%

3.10%

6.52%

-2.84%

0.91%

1.39%

-0.72%

10.64%

-6.06%

0.98%

-1.83%

-3.28%

3.07%

1.10%

-0.52%

4.11%

-1.92%

-10.05%

0.50%

4.67%

-0.72%

-1.03%

-6.06%

8.85%

0.20%

-3.54%

-3.91%

1.72%

4.87%

6.92%

-7.49%

7.93%

6.42%

-3.13%

-10.01%

-10.33%

-6.16%

-3.83%

-9.47%

4.87%

-0.87%

-2.30%

8.05%

5.24%

6.45%

-3.03%

6.90%

1.84%

-2.06%

-0.34%

3.23%

1.81%

-4.12%

-3.02%

-13.51%

5.77%

-3.26%

0.97%

-11.33%

1.18%

6.06%

-7.17%

-4.65%

-1.50%

-10.93%

-0.07%

-0.55%

-2.31%

2.10%

-0.40%

-21.43%

-5.89%

1.80%

-7.01%

6.33%

1.50%

-8.69%

0.52%

5.87%

-1.11%

1.32%

-2.90%

5.89%

20.11%

1.81%

-9.53%

7.77%

-0.86%

-0.46%

-0.64%

-0.25%

-1.63%

-0.85%

2.56%

16.90%

1.17%

-3.84%

1.86%

5.68%

-1.69%

11.90%

4.15%

9.72%

6.72%

8.27%

2.52%

-5.89%

6.05%

-5.57%

-4.23%

-7.43%

3.38%

-5.23%

3.46%

6.66%

10.36%

0.63%

-2.15%

-4.04%

5.33%

5.76%

-3.94%

-2.81%

2.63%

2.77%

-6.24%

-3.13%

-2.26%

-7.32%

0.99%

0.40%

1.49%

10.92%

-7.48%

2.42%

-5.97%

-13.43%

-4.14%

-9.12%

-9.28%

-10.88%

2.30%

-4.83%

-3.93%

-6.70%

-7.36%

-3.05%

-5.97%

1.09%

2.40%

-4.98%

16.82%

-2.92%

-2.87%

-9.44%

-2.05%

-3.79%

-3.08%

-6.25%

4.46%

-13.06%

-8.79%

-1.50%

-8.17%

-4.02%

0.22%

14.87%

-6.26%

-15.03%

3.55%

0.85%

-1.37%

0.00%

0.26%

-7.50%

-10.13%

10.46%

-3.15%

9.51%

-4.47%

-12.82%

5.94%

3.41%

0.30%

-9.17%

4.26%

16.76%

11.27%

-12.89%

1.47%

-5.05%

-10.34%

6.36%

-6.49%

-9.67%

0.78%

-1.82%

-16.07%

-24.01%

15.21%

8.01%

0.24%

-12.39%

3.51%

11.51%

-3.13%

13.79%

2.50%

6.34%

7.95%

11.45%

-1.57%

1.11%

3.94%

8.26%

-3.95%

-1.98%

5.74%

5.75%

1.19%

8.47%

2.84%

13.41%

1.11%

6.96%

1.57%

1.30%

-3.47%

13.48%

-1.52%

-3.12%

0.34%

-2.44%

8.67%

3.47%

8.69%

1.12%

-2.01%

-3.16%

-4.14%

-1.79%

-3.75%

14.31%

4.90%

-4.90%

-0.21%

3.21%

-5.73%

5.24%

-0.39%

-0.29%

0.66%

-0.62%

3.55%

-0.12%

2.47%

3.59%

8.78%

-4.89%

-0.58%

-6.38%

0.93%

-1.52%

4.34%

-1.06%

5.33%

12.45%

-0.69%

-5.49%

-12.86%

-3.45%

-2.49%

-8.48%

3.88%

3.42%

-0.23%

0.12%

1.41%

3.01%

-2.77%

2.16%

-0.81%

-5.86%

-1.17%

6.88%

1.10%

7.04%

10.58%

1.66%

12.50%

-2.06%

0.66%

-4.08%

-2.63%

-3.83%

5.83%

8.07%

-0.57%

7.85%

-8.98%

4.06%

-1.48%

-9.78%

1.67%

8.57%

2.78%

4.96%

6.43%

4.43%

-2.04%

4.83%

-4.29%

-1.56%

1.81%

-11.33%

4.66%

-2.70%

-1.89%

6.78%

-9.18%

-2.88%

-1.99%

0.00%

-8.59%

-3.28%

5.90%

10.60%

-3.77%

11.66%

6.48%

1.31%

9.99%

7.52%

-2.20%

0.93%

-1.29%

-4.83%

2.76%

13.46%

6.00%

5.82%

7.69%

-2.15%

-1.04%

0.77%

2.29%

-0.05%

0.00%

0.36%

0.00%

1.53%

-0.44%

 

Tesco

Marks and Spencer

Barclays

BP Plc

Burberry

FTSE

Mean

-0.0027

0.0037

0.0021

0.0060

0.0122

0.0039

Stdev

0.0694

0.0639

0.0876

0.0666

0.0779

0.0298

Variance

0.0048

0.0041

0.0077

0.0044

0.0061

0.0009

Risk free return

1.70%

1.70%

1.70%

1.70%

1.70%

1.70%

Interpretation: In accordance with the mean value of these firms it can be said that Burberry has the most favourable and attainable outcomes than compared with other enrities. On the othre side, Standard deviation of these organisations on which Barclays has most adequate results. Tesco reflected standard deviation as 0.0694, Marks and Spencer as 0.639, Barclays as 0.0876, BP Plc as 0.066, Burberry as 0.0779 and FTSE as 0.0298.

3. Determining annualised return and risks

Annualised rate or return has been analysed as per measuring the monthly rates in the compressed manner. To analyse the annual rate of return which have been offered by an organisation is mainly based on determining the ability of making observation over average rate of return a fir usually made over its securities. It consists of cumulative rate of return, periodicity and number of time period observed diapason etc. therefore, this analysis has been based on time weighted basis which in turn will be effective and have positive impacts valuation of securities. It comprises with the formula such as:

However, analysing Annualise rate of return for all these five entities and FTSE all shares which can be seen in Appendix 2.

Annualised Rate of return for Tesco:

TESCO PLC

Date

Annualised Return

31/12/11

-0.29%

31/12/12

-7.97%

31/12/13

5.71%

31/12/14

-46.21%

31/1215

-24.25%

31/1216

15.17%

31/12/17

12.46%

20/6/18

21.59%

Interpretation: By considering the operational activities of firm which insists In 2011 the annualised rate of return was -0.29, in 2012 it was -7.97%, in 2013 it was 5.71%, in 2014 it was -46.21%, in 2015 it was -24.25%, in 2016 it was 15.17%, in 2017 it was 12.46% and currently in 2018 it is 21.59%. Therefore, in accordance with such outcomes it can be said that in current year firm is making suitable returns than compared to past years.

Annualised Rate of return for Marks and Spencer:

Marks and Spencer

Date

Annualised Return

31/12/11

-8.63%

31/12/12

28.97%

31/12/13

17.19%

31/12/14

14.95%

31/1215

-2.38%

31/1216

-18.43%

31/12/17

-5.08%

20/6/18

-2.85%

Interpretation: On contrary with the above listed table Annualise rate of return has been payable by Marks and Spencer seen which reflect variations in its outcomes. In 2011 the annualised rate of return was -8.63%, in 2012 it was 28.97%, in 2013 it was 17.19%, in 2014 it was 14.95%, in 2015 it was -2.38%, in 2016 it was -18.43%, in 2017 it was -5.08% and currently in 2018 it is -2.85%. Thus, after ascertaining outcomes of Marks and Spencer in relation with Annualised rate of return it can be said that firm is needed to have improvements in capital structure as majority of results are reflecting negative balances.

Annualised Rate of return for Barcalys:

Barclays

Date

Annualised Return

31/12/11

-38.60%

31/12/12

53.36%

31/12/13

19.69%

31/12/14

-8.09%

31/1215

-7.80%

31/1216

4.89%

31/12/17

-7.88%

20/6/18

-3.73%

Interpretation: Above listed analysis is based on Barclays outcomes which are reflecting annualised rate of return in each period. In 2011 the annualised rate of return was -38.6, in 2012 it was 53.36%, in 2013 it was 19.69%, in 2014 it was -8.09%, in 2015 it was -7.80%, in 2016 it was 4.89%, in 2017 it was -7.88% and currently in 2018 it is -3.73%. Comparing outcomes with the past records on which it can be said that there are drastic changes in the rate of returns. Thus, in the current times firm needed to have control over debts and management over operational activities.

Annualised Rate of return for BP plc

BP Plc

Date

Annualised Return

31/12/11

-6.48%

31/12/12

2.04%

31/12/13

22.73%

31/12/14

-17.56%

31/1215

-12.80%

31/1216

28.95%

31/12/17

20.07%

20/6/18

9.51%

Interpretation:On the basis of above report it can be said that there are variation in the annual rate of return of BP Plc. In 2011 the annualised rate of return was -6.48, in 2012 it was 2.04%, in 2013 it was 22.73%, in 2014 it was -17.561%, in 2015 it was -12.80%, in 2016 it was 28.95%, in 2017 it was 20.07% and currently in 2018 it is 9.51%. The final outcome reflect a positive figure which reflects that the firm in having control over its debt utilisation as well as management of various operations.

Annualised Rate of return for Burberry:

Burberry

Date

Annualised Return

31/12/11

12.14%

31/12/12

5.50%

31/12/13

26.33%

31/12/14

10.30%

31/1215

-25.77%

31/1216

24.81%

31/12/17

27.11%

20/6/18

17.08%

Interpretation:By considering outcomes from Burberry as per annualised ate of return it can be said that the firm is reflecting comparatively favourable outcomes ta other entities. In 2011 the annualised rate of return was 12.14, in 2012 it was 5.50%, in 2013 it was 26.33%, in 2014 it was 10.30%, in 2015 it was -25.77%, in 2016 it was 24.81%, in 2017 it was 27.11% and currently in 2018 it is 17.08%. Moreover, it can be said that firm has the most positive outcomes and it will be colourable for the investors in relation with making investments in firm.

Annualised Rate of return for FTSE All shares:

FTSE all shares

Date

Annualised Return

31/12/11

-7.41%

31/12/12

8.09%

31/12/13

15.76%

31/12/14

1.26%

31/1215

-2.82%

31/1216

5.73%

31/12/17

9.25%

20/6/18

4.21%

Interpretation: In accordance with the operational outcomes there has been analysis based on annualised rate or return which reflects in share prices. In 2011 the annualised rate of return was -7.41, in 2012 it was 8.09%, in 2013 it was 15.76%, in 2014 it was 1.26%, in 2015 it was -2.82%, in 2016 it was 5.73%, in 2017 it was 9.25% and currently in 2018 it is 4.21%.

4. Analysing the Beta of each shares

Beta analysis of Tesco:

Slope Beta

-0.2558

Covariance

-0.0002

variance

0.0009

covariance/variance

-0.2530

Adjusted beta

0.1646

Beta analysing of Marks and Spencer:

Slope Beta

-0.1256

Covariance

0.000

variance

0.001

covariance/variance

-0.124

Adjusted beta

0.250

Beta analysing of Barclays:

Slope Beta

0.0198

Covariance

0.000

variance

0.001

covariance/variance

0.020

Adjusted beta

0.346

Beta analysing of BP plc:

Slope Beta

-0.3729

Covariance

0.000

variance

0.001

covariance/variance

-0.369

Adjusted beta

0.087

Beta analysing of FTSE All shares:

Slope Beta

-0.3737

Covariance

0.000

variance

0.001

covariance/variance

-0.370

Adjusted beta

0.087

5. Creating proportion, risk and return of minimum variance portfolio

 

Tesco

Marks and Spencer

Mean

-0.0026983364

0.0036670222

Stdev

0.0694425682

0.0638814199

Variance

0.0048222703

0.0040808358

 

Barclay

BP Plc

Mean

0.0021154775

0.0060304734

Stdev

0.0875674376

0.0665758638

Variance

0.0076680561

0.0044323456

Burberry

Tesco

Mean

0.0121792777

-0.0026983364

Stdev

0.0778899101

0.0694425682

Variance

0.0060668381

0.0048222703

 

Barclay

Marks and Spencer

Mean

0.0021154775

0.0036670222

Stdev

0.0875674376

0.0638814199

Variance

0.0076680561

0.0040808358

6. Measuring combination of shares in portfolios

In relation with ascertaining impacts of various portfolio management which insists that there has been two categories of various shares.

Traditional Portfolio management:

It influences as per ascertaining the non qualitative approach which in turn will be unique and adequate as per analysing the outcomes in required time (Narsoo, 2017).

Modern Portfolio management:

It includes the techniques which in turn will be effective and assistive as per analysing the balance sheet (Modern Portfolio Theory,2017). Thus, such analysis brings the suitable control over having the sufficient standard deviations, average rate of returns as well as several techniques to analyse the outcomes.

Related sample:

Management Theory for Resolving Problem - Imperial Hotel

PART B

Critically analysing portfolio diversification and protecting the investors from unpredictability of capital market

According to Cucchiella, Gastaldi and Trosini, (2017), there have been huge variations in the market value of an organisation. The level of ups and down depended on the purchase and sale incurred in the market during the period. Therefore, analysing the issues which in turn will be effective and helpful as per uplifting ability of firm in meeting its debts. Entity approaches for balancing the debts and assets which enable them to meet the fund requirements in the right time. Therefore, on which managing the portfolio will be an effective and helpful techniques. It has been aimed at the investors will not go to face any downfall in the share value of the firm. Thus, they will have suitable gains in required period. Romejko and Nakano, (2017) stated that, analysing bull and bare in the share prices of an entity which will be estimated by the experts in market. They predict that the in the coming period the market value of firm will be increase or decrease. Therefore, such kinds of estimations will be beneficial to investors in terms of making investing decisions.

According to Dal Pra and et.al., (2018), Ascertaining the impacts of various analysis which insists that there will be profitable analysis over share prices of firm. Thus, valuation of entity is quiet adequate and favourable as per having the satisfactory gains in the capital structure of entity. Thus, in relation with the portfolio analysis it can be said that there are huge variation in the share prices and return payable by these entities. Moreover, on which Burberry is quiet productive and have suitable outcomes which will be effective and helpful as per improving the operational viabilities of the firm.

Get Aerospace Assignment Help from Instant Assignment Help.

CONCLUSION

On the basis of above report, it represents the analysis over 5 shares in the market such as Tesco, Barclays, Marks and Spencer, Burberry and BP Plc. Therefore, there had been preparation of various portfolios and stock price analysis which in turn will be adequate effective as per analysing the outcomes through market. Further, as per making the suitable analysis

REFERENCES

  • Cucchiella, F., Gastaldi, M. and Trosini, M., 2017. Investments and cleaner energy production: a portfolio analysis in the Italian electricity market. Journal of Cleaner Production.
  • Dal Pra, G. and et.al., 2018. Practical Applications of Regime Shifts in Excess Stock Return Predictability: An Out-of-Sample Portfolio Analysis. Practical Applications.
  • Narsoo, J., 2017. Performance Analysis of Portfolio Optimisation Strategies: Evidence from the Exchange Market. International Journal of Economics and Finance.
  • Romejko, K. and Nakano, M., 2017. Portfolio analysis of alternative fuel vehicles considering technological advancement, energy security and policy. Journal of Cleaner Production.
Download Full Sample
Cite This Work To export references to this Sample, select the desired referencing style below:
Copy to Clipboard
Copy to Clipboard
Copy to Clipboard
Copy to Clipboard
Instant Assignment Help. [Internet]. Instant Assignment Help.(2024), Retrieved from: https://www.instantassignmenthelp.com/free-samples/business/valuation-of-securities-and-equity-trading
Copy to Clipboard
Boost Grades & Leave Stress

Share Your Requirements Now for Customized Solutions.

Lowest Price

USD6.27

    FOR FIRST ORDER GET EXTRA 25% OFF

    valentine

    Our unique Features

    24/7 Customer Support

    100% Customer Satisfaction

    No Privacy Infringement

    Quick Services

    Subject Experts

    Innovative Documents

    100+ Qualified Writers

    For Best (Accounting) Assignment Help

    Brad Trump
    2746 - Completed Orders
    Brad TrumpView Profile Hire Me
    Amma Wilson
    538 - Completed Orders
    Amma WilsonView Profile Hire Me
    Graham Robsen
    988 - Completed Orders
    Graham RobsenView Profile Hire Me
    Audrey Peterson
    1021 - Completed Orders
    Audrey PetersonView Profile Hire Me
    View All Writers
     
    IAH whatsapp
    Number successfylly updated