This is a solution of Group Coursework Assignment Help that describes about Developing business

Group Coursework Assignment Help



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 research

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 

i) Calculate each stock’s average monthly return, its return variance and standard deviations throughout the period 01/2007 to 12/

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). Visit Now : BTEC HND in Business Assignment

Task 2: Portfolio Analysis (25%)

  1. 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.
  2. 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%)

  1. i) Is Portfolio B’s average monthly return higher than any of 6 individual stocks’ average monthly return? Why?
  2. 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?

  1. 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%)

  1. i) Construct your own portfolio which includes a different number of stocks from Portfolio A, B, and C.
  2. 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).

  1. 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.

  1. 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.

  1. 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.

Btech HND Assignment provide assignment writing service based on case study requirements in affordable prices and we are providing most flexible online assignment writing help, so book your Assignment with us,  Order Now

Maddox Smith

Greetings for the day !
Hope that you’re well !

We want to introduce ourselves as a team of professionals who are into academic writing for the last 10+ years. We can provide assignment assistance in all subjects. Our experts can provide solutions across all the topics right from Management, HR, Marketing, Finance & Accounts, Statistics, IT, childcare, nursing, law, and general writing. We provide plagiarism free work and also send a ‘Turnitin’ report along with completed work. Our services are available at reasonable cost; we entertain amendment requests from clients without any extra charges.

Our Feature Included

Ø Every assignment includes graphical representation like pie chart, bar graph, smart art and all.
Ø Free 0% plagiarism report
Ø Expert team for technical work as well.
Ø On time delivery
Ø Multiple rework facility
Ø Huge team of expert in each subject
Ø Referencing like: Harvard, APA, MLA, Oscola, automatic referencing all are familiar to our experts.

Subject we cover: Math , finance, economics, accounts, civil engineering, mechanical engineering, IT, Computer science, electrical and electronics engineering, history, geography, political science, sociology, physiology, philosophy, biology, microbiology, biotechnology, biotechnology, B-school assignments, project report, psychology, nursing assignments, medical assignments, Tourists and travelling assignments all kinds of dissertation and so on

Best Regards:
Oz Paper Help
WhatsApp:+1 585-666-2225
1 Step 1