Q1. Collect the data from “Yahoo Finance” and answer the following questions (using the instructions given in the next page): a) Collect the market price index (All Ordinaries), Share price for a company (as per instructions given in page 2) and display the data for two sub-periods (Period 1: February 2014 to February 2016; Period 2: October 2016 to October 2018) separately in two separate tables. (2 marks) b) Calculate the return of share prices and market return (from market price index). Display the calculated returns along with the risk free rate of return (given in a separate excel file) in a table for two sub periods. Calculate and tabulate, and . (2 marks) c) Calculate the mean, standard deviation, variance and correlation coefficient for and separately (for two sub-period in a table-see next page) and comment on the result. (2+2=4 marks, 2 for calculation 2 for the comment) d) Estimate beta for your selected company for the two sub-periods. (1+1=2 marks) e) Explain the value of beta that you have calculated. (1.5+1.5=3 marks-1.5 for each sub-period) f) Provide a brief description of the company. (2 marks) g) Why the estimated value of beta is different for two sub-periods? (2.5+2.5=5 marks) (Note: The assessment should be typed, printed and submitted)

Document Preview:

Assessment 2: Report (20%) This assessment must be submitted (print copy-A4 size between 23 September, 2019 to 29 September, (week 10) to your Lecturer/Tutor during Workshop. In case of illness, apply for special consideration. Only HARD COPY with filled in assignment cover sheet of the assignment will be accepted. Q1. Collect the data from “Yahoo Finance” and answer the following questions (using the instructions given in the next page): Collect the market price index (All Ordinaries), Share price for a company (as per instructions given in page 2) and display the data for two sub-periods (Period 1: February 2014 to February 2016; Period 2: October 2016 to October 2018) separately in two separate tables. (2 marks) Calculate the return of share prices and market return (from market price index). Display the calculated returns along with the risk free rate of return (given in a separate excel file) in a table for two sub periods. Calculate and tabulate, and. (2 marks) Calculate the mean, standard deviation, variance and correlation coefficient for and separately (for two sub-period in a table-see next page) and comment on the result. (2+2=4 marks, 2 for calculation 2 for the comment) Estimate beta for your selected company for the two sub-periods. (1+1=2 marks) Explain the value of beta that you have calculated. (1.5+1.5=3 marks-1.5 for each sub-period) Provide a brief description of the company. (2 marks) Why the estimated value of beta is different for two sub-periods? (2.5+2.5=5 marks) (Note: The assessment should be typed, printed and submitted) Instructions for assessment 2: Data collection from Yahoo Finance: Go to the Yahoo Finance Web page:  HYPERLINK “https://au.finance.yahoo.com/” https://au.finance.yahoo.com/ On the right hand side enter Symbol or type the name of the Company and click “Look up”. For example: Medibank Private. The symbol will come up, otherwise see the list (excel file) of companies…

Published by Andrew Author at Best term paper site, paper writing service and Dissertation writing service

Posted in