Posted: September 17th, 2017
HAND IN/PRESENTATION DATE: 10th August 2015
Learning outcome Assessed by the Coursework:
• Compare the characteristics of the various products available on financial markets and appreciate the different ways in which the markets are organized and operate.
• Identify the potential uses of these markets and be able to apply them to uses in business situations.
• Evaluate the risks and returns involved in using these markets.
This coursework assesses learning outcome 1,2 and 4.
These are not tablets of stone but a marking guide. Students are often original and so something not covered here can still be awarded a grade appropriate to the academic content.
(30% of final marks)
Suppose you are working in an Investment Bank, a client with limited investment knowledge requests you to create a portfolio with a minimum required annual return of 15%. The client claims he is a risk-averse investor and his initial investment is £500,000. Please propose an investment plan for your client based on his expectation and the following requirements.
This project requires you to use 4 years daily adjusted-close prices (from 01 Jan2011 to 31st Dec 2014) of real listed company stocks. These companies could be any companies listed on the stock exchanges around the world.The data can be obtained from the website of Yahoo Finance.Please use MS Excel to perform the calculations.
The risk-free asset is assumed with an annual rate of return of 5%.
Section 1: Choose five different companies’ stocks that potentially can be used to construct a portfolio and make sure that the annual rate of return for some companies is less than 15% and larger than 15% for other companies. You are required to:
a) Briefly introduce each company’s background,such as financial position, explain why you chose these five stocks. (5 marks)
b) Using the data extracted for the companies, calculate the mean return and the standard deviations of each company stock over the sample period, and briefly discuss the results. (10 marks)
c) Calculate the covariance and correlation for each pair of stocks over the sample period and briefly discuss the results. (10 marks)
Section 2: Based on your analysis of the five companies’ stocks in Section 1, construct Portfolio A that comprises of two companies’ stocks from the five.This portfolio should meet the client’s 15% annual return requirement and take into account that your client is risk-averse investor. You are required to:
a) Show the different combinations of risk and return for portfolios comprising these two stocks, and plot a graph showing the relationship between return and risk of various portfolios. (10 marks)
b) Identify the minimum variance portfolio. What is the risk and return of this minimum variance portfolio? Does this minimum variance portfolio meet the requirement of your client? (10 marks)
c) Estimate the Sharpe ratio for minimum variance portfolio, and various portfolios and explain the use of Sharpe ratio to you client. (10 marks)
d) Identify the tangency portfolio based on two stocks you selected from the five stocks and what is the expected return and the risk of this tangency portfolio? Does this tangency portfolio meet the requirement of your client?
e) Identify the Portfolio Aand decide the weighting of each company stock in Portfolio A and explain why you select this portfolio to your client. (10 marks)
Section 3:construct Portfolio B by combining one risk-free asset with Portfolio A (consisting of two company stocks (risky assets)) and make sure that the annual rate of return forPortfolio B is 25%.
a) Decide the weighting of the risk-free asset and each company stock in Portfolio Band what is the standard deviation of Portfolio B? (10 marks)
b) Explain how to construct Portfolio B given that the annual rate of return of Portfolio A is less than the annual rate of return for Portfolio B? (5 marks)
c) Calculate the mean returns and risks of FTSE 100 and S&P500 respectively, compare your Portfolio A’s mean return and risk with those of FTSE100 and S&P500, can you beat the markets? (10 marks)
Remember, your client is not an expert in Finance theory, therefore, please interpret and comment on your technical analysis results so he would be able to understand. You need to provide a report with 2000 words (appendix and reference list are not included). Please include your KEYExcel output or output summaries inside the report and put other relevant output as an appendix.
Total 100 marks
Word Limit: 2,000 words
• Submission Date: 10thAugust2015by 23.55pm (midnight)
• You must submit electronic form via Turnitin on Moodle.
• To obtain a good mark, you must cover all the questions at a depth and width expected of a master level assignment.
Place an order in 3 easy steps. Takes less than 5 mins.