Investment Analysis of FTSE100 Listed Firms.

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

QUESTION
You will draw the necessary data for this coursework from Thomson Reuters Datastream (This software is available on 3 PCs behind the library helpdesk ONLY. You can find the guidance from here). Select any five firms from the FTSE100 index components (you can find the eligible firms from here). Download adjusted monthly closing stock prices for each one of your five firms over the most recent period of five years (your series should end in June 2015; 60 monthly observations in total for each stock). You are free to choose whatever stocks you want, irrespective of their characteristics and historical investment performance; this will not affect your grade. Also, download adjusted monthly closing price levels for a broad stock market index proxy for the UK market portfolio over the same 5-year period.
In order to determine the risk-free rate, use the latest value of the yield for a short term UK government security (you can draw data from here).
Description:
A wealthy German investor (diversified in terms of exposure to different sectors in Germany and Austria, but not diversified in terms of international geographical exposure) is considering the strategic decision of investing in a portfolio of five FTSE100 firms. You are employed by a leading financial institution and have been asked to advise this client. You will prepare an investment report in Microsoft Word for her containing all your work, results and arguments. All the relevant tables and figures should be contained and discussed in the main body of the report, not in some appendix. The report should not exceed 4,000 words in total (without appendices) and should include all of the following five sections. You can also find the suggestions about Tables/Figures you should at least include, and textbook chapters that you could start reading from in each section.
Section 1. Following the scandals and rumours about the LIBOR and FX market in the UK, your client believes that the London Stock Exchange (LSE) may not be perfectly market and is not sure if this is good or bad for her or not as an aspiring passive investor. Discuss your arguments on the validity of her view and the implications of market efficiency for passive investors. Do not perform your own empirical analysis and testing but use the evidence from the literature.
Relevant Chapter: 11 to 13 (20 marks) 800
Section 2. Use your sample data to form the following four portfolios: A) equally weighted portfolio; B) value-weighted portfolio; C) global minimum-variance portfolio; and D) optimal risky portfolio. According to the five stocks and risk-free rate, build the optimal capital allocation line, minimum-variance frontier and the efficient frontier, and identify the positions of those five stocks and four portfolios (A, B, C and D) in a scatterplot of standard deviations against returns. Explain and discuss your results.
Tables: Portfolio weights, returns and standard deviations.
Figure: One scatterplot includes the optimal capital allocation line, minimum-variance frontier and efficient frontier.
Relevant Chapter: 5 and 7. (30 marks) 1200
Section 3. Determine the proportion of the overall complete portfolio in the UK financial market that should be held in the optimal risky portfolio of the five stocks along with the proportion that should be held in the risk-free asset. Assume that your client has the same coefficient of risk aversion as yours and that you should determine this by using the Charles Schwab Investor Profile Questionnaire (you can find the questionnaire from here). Transform the questionnaire risk tolerance scores “x” (0 to 40) into risk aversion coefficients “y” (0 to 2) by using the following transformation: y = 2 – x/20. Thus, a risk tolerance score of 30 becomes a risk aversion parameter of 0.5 (= 2 –30/20). Explain and discuss your results.
Relevant Chapter: 6. (10 marks) L4 31 400
Section 4. On the basis of the single-factor market model CAPM, estimate the beta coefficients for each one of the five stocks you have selected. You are free to use whatever method you prefer in estimating the market model parameters (scatterplot trendline, slope function, or regression). Discuss if the beta values you have estimated are sensible given the nature of the business activities of each firm. Discuss the relationship depicted in a scatterplot between average annualised returns and beta coefficients for the five stocks.
Table: Beta coefficients and returns for the five stocks.
Figure: Scatterplot of expected returns against beta coefficients for the five stocks.
Relevant Chapter: 8 and 9. (15 marks) LB7 600
Section 5. Evaluate in absolute and relative terms the investment performance of each one of the five portfolios A, B, C and D that created in Section 2 and the UK market portfolio over the five-year sample period:
(i) Compare your portfolio performances in terms of return, standard deviation, beta, Sharpe ratio, Treynor measure, Jensen’s alpha, information ratio, and M2 measure. All metric components (e.g., average return and standard deviation) should be annualised as appropriate.
(ii) Determine which portfolio is more favourable for a risk-averse and for a risk-tolerant investor, respectively. Which portfolio would you advise your client to invest in? Which portfolio do you consider the worst choice? Justify and explain your recommendations.
(iii) Compare the best and worst portfolios graphically by using wealth indices.
Table: Performance statistics for the five portfolios.
Figure: Wealth indices (i.e. cumulative return) for the best and worst portfolios.
Relevant Chapter: 24. (25 marks) LB7 1000

Sample Solutions
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Phasellus hendrerit. Pellentesque aliquet nibh nec urna. In nisi neque, aliquet vel, dapibus id, mattis vel, nisi. Sed pretium, ligula sollicitudin laoreet viverra, tortor libero sodales leo, eget blandit nunc tortor eu nibh. Nullam mollis. Ut justo. Suspendisse potenti.

Get sample solution
Order Now

Sed egestas, ante et vulputate volutpat, eros pede semper est, vitae luctus metus libero eu augue. Morbi purus libero, faucibus adipiscing, commodo quis, gravida id, est. Sed lectus. Praesent elementum hendrerit tortor. Sed semper lorem at felis. Vestibulum volutpat, lacus a ultrices sagittis, mi neque euismod dui, eu pulvinar nunc sapien ornare nisl. Phasellus pede arcu, dapibus eu, fermentum et, dapibus sed, urna.

Morbi interdum mollis sapien. Sed ac risus. Phasellus lacinia, magna a ullamcorper laoreet, lectus arcu pulvinar risus, vitae facilisis libero dolor a purus. Sed vel lacus. Mauris nibh felis, adipiscing varius, adipiscing in, lacinia vel, tellus. Suspendisse ac urna. Etiam pellentesque mauris ut lectus. Nunc tellus ante, mattis eget, gravida vitae, ultricies ac, leo. Integer leo pede, ornare a, lacinia eu, vulputate vel, nisl.
Suspendisse mauris. Fusce accumsan mollis eros. Pellentesque a diam sit amet mi ullamcorper vehicula. Integer adipiscing risus a sem. Nullam quis massa sit amet nibh viverra malesuada. Nunc sem lacus, accumsan quis, faucibus non, congue vel, arcu. Ut scelerisque hendrerit tellus. Integer sagittis. Vivamus a mauris eget arcu gravida tristique. Nunc iaculis mi in ante. Vivamus imperdiet nibh feugiat est.
Ut convallis, sem sit amet interdum consectetuer, odio augue aliquam leo, nec dapibus tortor nibh sed augue. Integer eu magna sit amet metus fermentum posuere. Morbi sit amet nulla sed dolor elementum imperdiet. Quisque fermentum. Cum sociis natoque penatibus et magnis xdis parturient montes, nascetur ridiculus mus. Pellentesque adipiscing eros ut libero. Ut condimentum mi vel tellus. Suspendisse laoreet. Fusce ut est sed dolor gravida convallis. Morbi vitae ante. Vivamus ultrices luctus nunc. Suspendisse et dolor. Etiam dignissim. Proin malesuada adipiscing lacus. Donec metus. Curabitur gravida

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services