### Calculate the beta for your company using excel

Assignment Help Finance Basics
##### Reference no: EM131053935

Interserve plc

Company Financial Analysis (1,750 words)

Compare the calculated beta for Interserve plc against that for the published beta on The Financial Times website. Furthermore, differences will be explained regarding the betas and comparisons will be made from the share price performance of the company and of the FTSE 250 index.

FTSE 250 index to undertake this task. Collect the weekly share price data for both your company and the FTSE 250 index from 1st February 2013 until 31st January 2016 from Yahoo Finance (uk.finance.yahoo.com) and undertake the following tasks:

(i) Using the data collected, calculate the beta for your company using Excel. Compare your results with the published beta for your company on Reuters or Morningstar. Explain any differences between the published result and your calculated result. Your explanation should consider academic theories and/or market and sector factors.

(ii) Compare the share price performance of your company with that of the FTSE 250 index. In your comparison, you should analyse your company's performance and provide both academic and practical justifications for your arguments.

(iii) Compare the long-term performance of your company with the short-term share price performance since the 31st January 2016 (i.e. 1st February 2016 - 1st April 2016). You should identify the principal factors that have caused price changes over this three-month period and support your explanations with academic theory.

#### Issues of materiality in your selected annual report

Discuss the problems of materiality in the context of the present AASB / IASB standards and framework using your selected annual report to provide examples. Evaluate the iss

#### Calculate the market capitalisation of blackmores

Calculate the market capitalisation of Blackmores. Do you think Blackmores' stock is under- priced or over-priced? Answer this question with reference to capital asset prici

#### Analyse the latest financial statements

The assignment aims to develop an understanding of financial statements structure and their use in decision-making. The task is to choose a publicly listed company (see list

#### What is the net present value of the project

If RWE uses a 10% discount rate to evaluate investments of this type, what is the net present value of the project? What does this NPV indicate about the potential value RWE

#### A usa today snapshot reports

A USA Today Snapshot reports that among people 35 to 65 years old, nearly two thirds say they are not concerned about being forced into retirement.7 Suppose that we randomly

#### Five applications for two positions

4-A company has five applications for two positions: two women and three men. Suppose that the five applicants are equally qualified and that no preference is given for choo

#### Study comparing the creativity scores of four biology

1)A Loyola University student conducted a study comparing the creativity scores of four biology and four history majors. The results were Can you set up the formula that woul

#### Regardless of the volume of lipstick manufactured

2. A cosmetics manufacturer is deciding between two chemical formulas Fermat Aar Formula B - from which to make a new Itpstsck. Formula A is tors costly to manufacture than