Market Price Index - Yahoo Finance Assessment

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: June 2012 to July 2014; Period 2: February 2016 to January 2018) separately in two separate tables.

b. Calculate the return of share prices (r_j)and market return (r_m)(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,(r_j, R_f) and (r_m, R_f).

c. Calculate the mean, standard deviation, variance and correlation coefficient for (r_j, R_f) and (r_m, R_f) separately (for two sub-period in a table-see next page) and comment on the result. 

d. Estimate beta for your selected company for the two sub-periods.

e. Explain the value of beta that you have calculated.

f. Provide a brief description of the company.

g. Why the estimated value of beta is different for two sub-periods?

r= Annual T-Bill rate

P_t= Share Price at time t

Instructions 

1. Data collection from Yahoo Finance: Go to the Yahoo Finance Web page: https://au.finance.yahoo.com/
2. 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.
3. i) Click “Historical Prices” icon. ii) Frequency: “Monthly”; iii) Time period set date, click “YTD”
4. Set Data Range: Start date: May 2012 (to get the return from June you need the data from May) and end date: July 2014. Click, “Apply”
5. In the bottom of the page click, “Download data”. Therefore, download the data and save.
6. 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)
7. Similarly, 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”)
8. Follow the CAPM lecture note and divide the return data for two sub-periods:
   Period 1: June 2012 to July 2014; b) Period 2: February 2016 to January 2018. (Note: to get the market return (rm) for June 2012, students need the All Ordinaries index and the stock price for the chosen company data from May 2012)
9. Risk free monthly rate of interest (already expressed in %) is given in the assignment. (Please do not change this data).
10. Set the date on monthly basis. (For example, type Feb-15, Mar-18 ---------)

Get your Market Price Index - Yahoo Finance assignment solved by our Accounting and Finance Experts from Exam Question Bank . Our Assignment Writing Experts are efficient to provide a fresh solution to all question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing Style. Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered.

You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turn tin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.