+44 7400010488 help@instantassignmenthelp.com
Save 51% on Expert-Crafted Assignment Solutions!

Valuation of Securities and Equity Trading

University: University of Chester

  • Unit No: 9
  • Level: Undergraduate/College
  • Pages: 35 / Words 8752
  • Paper Type: Assignment
  • Course Code:
  • Downloads: 966
Question :
This sample assessment consists of:
  • Discuss about the Computing average monthly return.
  • Discuss about the Annualised Rate of return for Burberry
Answer :

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
Students have a lot of academic burdens these days that make them seek online assignment help from experts. Therefore, we have created an exclusive list of sample for almost every subject. Our highly qualified experts curated it for your assignment, essay, and dissertation help. So what are you waiting for? Explore the content written by our professionals and go ahead and seek essay writing services UK from our experts. The best part is they are available 24*7 to provide excellent assistance. So, what are you waiting for? Ask our experts, "Can you do my assignment for me, please?" You will see the magic happening in an instant.
Boost Grades & Leave Stress

Share Your Requirements Now for Customized Solutions.

Lowest Price

SHP4.8

    FOR FIRST ORDER GET EXTRA 25% OFF

    Use Our Seasonal Offers!

    Get Up to 51% OFF

    Coupon Code

    INSTANT25
    Claim Now

    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

    Reggie Cohen
    673 - Completed Orders
    Reggie CohenView Profile Hire Me
    Lissie Franklin
    2797 - Completed Orders
    Lissie FranklinView Profile Hire Me
    Luke Bailey
    168 - Completed Orders
    Luke BaileyView Profile Hire Me
    Freida Federer
    1160 - Completed Orders
    Freida FedererView Profile Hire Me
    View All Writers
     
    IAH whatsapp

    Limited Time Offer

    Exclusive Library Membership + FREE Wallet Balance