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
Assessment 2: Report (20%)
(This assessment must be submitted (print copy-A4 size) between 5 May 2018 to 11 May 2018 to your Lecturer/Tutor during Workshop. In case of illness, apply for special consideration. Only HARD COPY with 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: April 2014 to December 2015; Period 2: December 2015 to August 2017) separately in a table. (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:
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 and you will find the symbol.
Note: Choose a company from the list provided in the assignment (see the excel file). If your Surname starts with ‘M’, choose a Company whose name starts with ‘M’. e.g. “Myer Holdings”. You may not get the data for the specified periods for some new companies (e.g. for Medibank Private). In that case choose another company.
Click “Historical Prices” icon.
Next, Click “Monthly” icon.
Set Data Range: Start date: April 2014 and end date: August 2017. Click, “Apply”
In the bottom of the page click, “Download data”. Therefore, download the data and save.
Keep only “Date” and the “Adj Close”. This will be the share price for your selected firm. (Please ignore the dividend paid. That is, delete dividend for each period)
Follow the same steps from 1. And collect the data for the same period for “All Ordinaries”. This will be your market index. (convert the data from oldest to newest using “sort” or “filter”)
Follow the CAPM lecture note and divide the return data for two sub-periods:
May 2014 to December 2015 and b) January 2016 to August 2017. (Note: to get the return from May 2014 students need the All Ordinaries and share price data from April 2014)
Risk free monthly rate of interest (already expressed in %) is given in the assignment. (Please do not change this data).
Set the date on monthly basis. (For example, type Feb-15, Mar-18 ---------)
Students are allowed to use Microsoft excel or calculator for this assessment.
You must write the name of the Company you have selected on the first page.
Please read carefully the relevant lecture (CAPM) before you start the assessment.
Please give page number of your assessment. (Final result: 4 decimal places).
For late submission (will be counted from your tutorial time) 5% marks will be deducted for each day unless approved extension.
Use excel for the calculation. If you need help, please see me.
To answer part f) and g) student should read the company report and relevant document.
Note: The data should arrange from oldest to the newest dates. For example: Sept-15 will come before Oct-15. Return data should be in percentage (%). Answer each part of the questions separately starting from (a) to (f).
If you think that you cannot attend tutorial between 5 May 2018 to 11 May 2018, please submit your report one week before. Otherwise please make arrangement with your lecturer/tutor.
Email address:
Girijasankar Mallik: [email protected]
Mamta Chowdhury [email protected]
4
