Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Plz i want the answers with ditals (notes) The following table of information is useful for task 2, task 3 and task 4. (Data only

image text in transcribed

image text in transcribed

image text in transcribed

Plz i want the answers with ditals (notes)

The following table of information is useful for task 2, task 3 and task 4. (Data only for academic & learning purpose only) Company Name Closing Price (Share Value) as on 31st December, 2016 20171 2018 2020 2019 2.3800 Glaxo Pharma 2 Diamond Foods New Line Airlines 4 National Oil Future Constructions 6 Imperial Plastics Royal Cements 8|Pearson Technology 9 Continental Hotels 10 United Utilities 2.0450 2.1530 1.6450 2.7250 2.5900 1.6150 2.8500 3.46901 2.0890 3.69001 1.8150 2.5700 1.82301 1.9810 1.8900 1.4790 2.2050 3.8500 1.8320 2.7930 2.3420 3.9800 1.9990 1.9090 2.4520 2.8210 2.5090 3.8650 1.2450 2.7930 2.0500 3.9800 2.9320 2.6950 2.8050 2.9111 3.9000 1.2240 2.7500 2.74501 3.85001 2.2760 1.9280 3.5800 2.9350 1.4200 3.8500 1.0280 2.34001 Assume: Market Returns (Rm) = 8% Risk Free Rate (rf) = 5% Hypothetical Value to the nearest place taken for academic purpose only (4 Task 2 Marks) Calculate for each stock Average yearly return, (for all 10 companies) arithmetic mean ONLY Its return variance and; (for all 10 companies) Standard deviations throughout the period (for all 10 companies) Comment and analyze on the results calculated above based on the ranking which stock is having the highest yearly returns and standard deviations of individual stocks from 2016 to 2020 Make a table / graph of all the companies in terms of averages and standard deviation and based on that given highest rank to highest average (returns) and highest rank to lowest strandard deviation ( risk) (3 marks for calculations + 2 marks for analysis and comments) (4 Task 2 Marks) Construct three types of portfolios of equal weights Assuming that each stock has equal weight in the portfolio, calculate Portfolio A any combination of any three companies, (1/3, 1/3, 1/3 weights x returns) & (weights x standard deviation) Portfolio B any combination of any five companies, and (1/5, 1/5, 1/5, 1/5, 1/5 (weights x returns) & (weights x standard deviation) Portfolio C any combination of any 7 companies (1/7, 1/7...1/7) average yearly returns, return variances and standard deviations, Make a table / graph of all the companies in terms of averages and standard deviation and based on that given highest rank to highest average (returns) and highest rank to lowest strandard deviation ( risk) Comment and analyze based on the rankings which portfolio has the maximum returns and which portfolio is having the minimum standard deviation. Give the reasons (Economic reasons) (3 marks for calculations + 2 marks for analysis and comments) 4 (4 Task Marks) A. Construct your own portfolio which includes a different number of stocks from Portfolio A, B, and C. - completely different from others B. Can you justify why you choose such a portfolio? Particulars Portfolio A (3 Ranking Portfolio stocks) (5 stocks) B|Portfolio (7 stocks) Clown portfolio your choice to select any number of stocks Maximum 6 stocks Arithmetic Mean Standard Deviation Comparision = standard deviation should be less (Risk), returns should be more. based on the ranking you comments and analyses c. Are there any stocks which you should not include (your judgement or your preference) in your portfolio? Can you provide your justifications? (You may draw performance graphs of one stock against the market portfolio). d. 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 2016 to 2020 COMPARE AND ANALYSE IN TASK 3 WHICH PORTFOLIO IS GIVING YOU THE MAXIMUM RETURNS AND MINIMUM RISK You are expected to refer to text books, academic journals and other relevant academic sources. Your assignment will be assessed for style, demonstration of depth of knowledge, rigor, and clarity. Attention is drawn to the CBFS policy on plagiarism Remember that references should be provided. The following table of information is useful for task 2, task 3 and task 4. (Data only for academic & learning purpose only) Company Name Closing Price (Share Value) as on 31st December, 2016 20171 2018 2020 2019 2.3800 Glaxo Pharma 2 Diamond Foods New Line Airlines 4 National Oil Future Constructions 6 Imperial Plastics Royal Cements 8|Pearson Technology 9 Continental Hotels 10 United Utilities 2.0450 2.1530 1.6450 2.7250 2.5900 1.6150 2.8500 3.46901 2.0890 3.69001 1.8150 2.5700 1.82301 1.9810 1.8900 1.4790 2.2050 3.8500 1.8320 2.7930 2.3420 3.9800 1.9990 1.9090 2.4520 2.8210 2.5090 3.8650 1.2450 2.7930 2.0500 3.9800 2.9320 2.6950 2.8050 2.9111 3.9000 1.2240 2.7500 2.74501 3.85001 2.2760 1.9280 3.5800 2.9350 1.4200 3.8500 1.0280 2.34001 Assume: Market Returns (Rm) = 8% Risk Free Rate (rf) = 5% Hypothetical Value to the nearest place taken for academic purpose only (4 Task 2 Marks) Calculate for each stock Average yearly return, (for all 10 companies) arithmetic mean ONLY Its return variance and; (for all 10 companies) Standard deviations throughout the period (for all 10 companies) Comment and analyze on the results calculated above based on the ranking which stock is having the highest yearly returns and standard deviations of individual stocks from 2016 to 2020 Make a table / graph of all the companies in terms of averages and standard deviation and based on that given highest rank to highest average (returns) and highest rank to lowest strandard deviation ( risk) (3 marks for calculations + 2 marks for analysis and comments) (4 Task 2 Marks) Construct three types of portfolios of equal weights Assuming that each stock has equal weight in the portfolio, calculate Portfolio A any combination of any three companies, (1/3, 1/3, 1/3 weights x returns) & (weights x standard deviation) Portfolio B any combination of any five companies, and (1/5, 1/5, 1/5, 1/5, 1/5 (weights x returns) & (weights x standard deviation) Portfolio C any combination of any 7 companies (1/7, 1/7...1/7) average yearly returns, return variances and standard deviations, Make a table / graph of all the companies in terms of averages and standard deviation and based on that given highest rank to highest average (returns) and highest rank to lowest strandard deviation ( risk) Comment and analyze based on the rankings which portfolio has the maximum returns and which portfolio is having the minimum standard deviation. Give the reasons (Economic reasons) (3 marks for calculations + 2 marks for analysis and comments) 4 (4 Task Marks) A. Construct your own portfolio which includes a different number of stocks from Portfolio A, B, and C. - completely different from others B. Can you justify why you choose such a portfolio? Particulars Portfolio A (3 Ranking Portfolio stocks) (5 stocks) B|Portfolio (7 stocks) Clown portfolio your choice to select any number of stocks Maximum 6 stocks Arithmetic Mean Standard Deviation Comparision = standard deviation should be less (Risk), returns should be more. based on the ranking you comments and analyses c. Are there any stocks which you should not include (your judgement or your preference) in your portfolio? Can you provide your justifications? (You may draw performance graphs of one stock against the market portfolio). d. 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 2016 to 2020 COMPARE AND ANALYSE IN TASK 3 WHICH PORTFOLIO IS GIVING YOU THE MAXIMUM RETURNS AND MINIMUM RISK You are expected to refer to text books, academic journals and other relevant academic sources. Your assignment will be assessed for style, demonstration of depth of knowledge, rigor, and clarity. Attention is drawn to the CBFS policy on plagiarism Remember that references should be provided

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets Instruments And Institutions

Authors: Anthony M. Santomero, David Babbel

2nd Edition

0072358688, 9780072358681

More Books

Students also viewed these Finance questions

Question

What does the following code output

Answered: 1 week ago