MAN2909M
Group Coursework Assessment
Weighted 30% of the total assessment
Submission date: Friday 18th March 2016 by 3pm
Word limit: 2,500 (excluding tables, graphs, references and appendices)
Guidance on exceeding the word limit can be found in Section 7 of the module handbook.
Description
The group coursework assessment requires you to write up a report based on four tasks. In the report, you need to analyse given stock
data and to make some suggestions on portfolio composition. Your answer for each question should be supported by your group data
analysis. The report’s format requires a professional setting with title, contents, page numbers, sections-subsections and references.
Each member of your group is expected to contribute equally to the whole project.
Group coursework
You have price information on 10 stocks, FTSE All Share Index, and risk-free rate (UK T-bill rate) from 01/2007 to 12/2011. All of the
data information can be found in the excel spread sheet “Group_work” which will be uploaded on the Blackboard. You are required to
finish the following 4 tasks with your group members and write a report based on the 4 tasks.
Task 1: Individual stocks (25%)
i) Calculate each stock’s average monthly return, its return variance and standard deviations throughout the period 01/2007 to 12/2011.
ii) Using the price information of the FTSE All Share Index as a proxy for market portfolio, calculate each stock’s beta value
throughout the period 01/2007 to 12/2011.
iii) Explain why some stocks have beta values greater than 1 while others are below 1 (you may do some research on firm backgrounds and
their business).
Task 2: Portfolio Analysis (25%)
i) Construct three types of portfolios. Portfolio A consists of any of 3 stocks, Portfolio B consists of any of 6 stocks, and Portfolio
C consists of 10 stocks. Assuming that each stock has equal weight in the portfolio, calculate Portfolio A, B, and Cs’ average monthly
returns, return variances and standard deviations, and beta values.
ii) Which of the Portfolios A, B, and C, has the highest return standard deviation? Does this portfolio have the highest average
monthly return? Can you explain why?
iii) In terms of portfolio beta, which portfolio is the most risky one?
iv)Will the three portfolios have a same ranking, if you rank their betas and return variances respectively? Can you provide economic
reasons why the two rankings should be (in)consistent with each other?
Task 3: Comparing individual stock and portfolio (25%)
i) Is Portfolio B’s average monthly return higher than any of 6 individual stocks’ average monthly return? Why?
ii) Is Portfolio B’s return standard deviation higher than any of 6 individual stocks’ return standard deviation? Why?
iii) Is Portfolio B’s beta value higher than any of 6 individual stocks’ betas? Why?
iv) Should investors invest their money in individual stock or in portfolio? Please provide justifications for your answer.
Task 4: Choose your own portfolio (25%)
i) Construct your own portfolio which includes a different number of stocks from Portfolio A, B, and C.
ii) Can you justify why you choose such a portfolio?
iii) Are there any stocks which you should not include in your portfolio? Can you provide your justifications? (You may draw
performance graphs of one stock against the market portfolio).
iv) Can you find out which portfolios (i.e. Portfolio A, B, C and your own portfolio) or stocks (i.e. 10 sample stocks) perform badly
or good in the period of 2009 to 2011.
Note: In the report, you should briefly describe how you obtain numeric results. To save the number of words, you are encouraged to use
graphs and tables to illustrate your ideas if necessary. You can also use the Excel software to help get results. You may need to
select a group leader who can allocate the 4 tasks among group members and can co-ordinate different tasks.
Marks of the four tasks are equally weighted. The following factors will be taken into account when the lecturer marks your report.
1. Numerical accuracy
You are required to show the procedures to get the results.
You need to obtain correct numerical results for each task.
2. Understanding
You need to show the marker that you understand the difference between stock and portfolio performance. Your arguments and conclusions
should be supported by the numerical answers. You need to discuss whether your results are consistent or inconsistent with portfolio
theories.
3. Clarity and structure
Your arguments should be organised in a clear and logical way. Your final mark will reflect whether you have the depth of knowledge in
the report. Attention should be drawn to the University’s policy on plagiarism.
TAKE ADVANTAGE OF OUR PROMOTIONAL DISCOUNT DISPLAYED ON THE WEBSITE AND GET A DISCOUNT FOR YOUR PAPER NOW!