Answered step by step
Verified Expert Solution
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
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 providedStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started