Calculate monthly returns for share prices

Assignment Help Corporate Finance
Reference no: EM132289927

Corporate Finance

Choose three companies that operate in different sectors of the economy. The companies must be quoted on the London Stock Exchange (LSE).

1. Using monthly data, calculate the beta values for each company.

Hints
- You will need monthly price data for the companies' shares and monthly data on the FTSE100 index, which should be used as a proxy for the market portfolio. Use data for a four year period from 1st January 2014 to 31st December 2017.

- Data for the companies is available at yahoo finance. Look up the companies in the Look Up box, and choose Equity London for LSE share prices. Then click the link to Historical Data for past share prices.

- Remember that you will need to calculate monthly returns for share prices and the FTSE. Use the adjusted closing prices (Adj close*) column as this includes the effects of share splits, dividends etc.

- Data for the FTSE100 index is available on the module Blackboard site.

2. Interpret the betas you have calculated and suggest why there are differences in the values between the three companies.

3. For the three companies you have selected, find the beta values quoted on the Financial Times website and from at least one other source. Compare the FT and other beta values with those you have calculated and explain why they may differ.

Hint

• Search for the companies
• The page can also be found through the main FT website. From the FT Home Page, select Markets, then Markets Data Home, then Companies. Use Search to find your companies. Remember to use the shares listed on the LSE.

4. Making use of any other data on your chosen companies, explain what other ways there are of measuring the riskiness of the businesses. Discuss the relative merits of beta values and these other ways of assessing risk.

In your assignment you should include all supporting formulae, calculations, spreadsheets and graphs. Any Excel sheets should be copied into your Word document. Such items will NOT count against the word limit.

Explanations of the formulae, calculations and any graphs should be included in the main part of the assignment. All data tables and spreadsheets should be included as an appendix.

Attachment:- Corporate Finance.rar

Verified Expert

This is a completely practical based assignment which ensures that the three companies that operate in different sectors of the economy.The companies must be quoted on the London Stock Exchange (LSE).It explains the Stock analysis concept as well as details as to how the valuation is conducted.

Reference no: EM132289927

Questions Cloud

Determine the utilization and the efficiency : Determine the utilization and the efficiency for each of these situations:
Determine the standard time for this job : A worker-machine operation was found to involve 3.9 minutes of machine time per cycle. Determine the standard time for this job.
What are the central facts of the case : What is the major overriding issue in the case? What major question or issues does this case address that merits study at this point in the course?
Boston consulting group matrix is useful strategic tool : The Boston Consulting Group (BCG) Matrix is a useful strategic tool.
Calculate monthly returns for share prices : Teesside University - Remember that you will need to calculate monthly returns for share prices and the FTSE. Use the adjusted closing prices (Adj close*)
Affects the quality of decisions and interpersonal relations : Discussing how the perception process affects the quality of decisions and interpersonal relationships, possibly including diversity management.
How does the environments affect your health : Think about a health issue that affects your family or you. How does environments affect your health? Again, where you live, work, who you hang out with, etc
Describe how you will apply that learning in your daily life : Assess whether unions are still relevant today. Determine the trade-off between good employee relations and profitability.
Critically evaluate the product portfolio of almarai : Critically evaluate the product portfolio of Almarai with the help of BCG Matrix.

Reviews

len2289927

4/21/2019 11:13:30 PM

Weight 1 Overall structure to include use of English. 10% 2 Appropriate calculations in 1 20% 3 Appropriate interpretation in 2 20% 4 Identification and explanation in 3 20% 5 Discussion of risk measurement in 4 30% 6 Within word limit N/A Assignments to be submitted by: Friday, READ the Assessment Criteria carefully BEFORE starting your assignment. Assessment Criteria

len2289927

4/21/2019 11:13:18 PM

Submission of two copies, one in electronic format at CMS and one of hard copy, are required. Details for the submission of the copies would be provided later. Make sure that you include all the relevant data and spreadsheets in your assignment document.

len2289927

4/21/2019 11:13:04 PM

Choose three companies that operate in different sectors of the economy. The companies must be quoted on the London Stock Exchange (LSE). - do all the questions - 1500 words - for part 3, need to answer in PPT slides like this - please let me know which three companies you choose before starting to work

Write a Review

Corporate Finance Questions & Answers

  What are the difficulties in comparing the ratios

What are the difficulties in comparing the ratios of these companies to one another? As this is such a short writing assignment, you can omit the abstract.

  What factors should a company consider

What factors should a company consider when it decides whether to invest in a project today or to wait until more information becomes available.

  Consider the following scenario john buys a house for

consider the following scenario john buys a house for 135000 and takes out a five year adjustable rate mortgage with a

  How prime emerald inc can hedge current position with italy

Explain how Prime Emerald Inc. can hedge the current position with Italy. Use APA formatting for any citations and reference page.

  Compute post-merger profits

The merger creates a synergy which reduces the marginal cost of the combined firm to a new lower level of 15. The industry now moves to a two firm Cournot equilibrium. Firm 3 has the same marginal cost as before the merger. Compute post-merger pro..

  Calculate maximum percentage premium procureps can afford

Calculate the maximum percentage premium Procureps can afford to pay for V1 and V2 by replacing the question marks in the following table.

  Company has been approached to bid

Company has been approached to bid on a contract to sell 4,400 voice recognition

  Prepare working capital forecasting statement of company

Prepare the Working Capital forecasting statement of the company and Materials are kept in store for 6 weeks, the processing time is 8 weeks and the finished goods are stored in godown for 90 days.

  Who was salvador allende

How did the Peruvian military dictatorship differ from others in South America?

  We have a 400000 30 year 12 mortgage we want to knowathe

we have a 400000 30 year 12 mortgage. we want to knowa.the monthly mortgage payment.b.how much we need to pay the bank

  Levels of equity market capitalization to gdp

Why do some developed countries have high levels of equity market capitalization to GDP while other developed countries have low levels?

  Consider the two assets with the following cash flow

consider the two assets with the following cash flow streamsasset a generates 3 at t1 1 at t2 and 10 at t3. asset b

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd