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