21 Jul Report (15%)
This assessment must be submitted (print copy-A4 size) between 2 May to 6 May 2016 to your tutor during tutorial time.)
Q1. Collect the data from “Yahoo Finance” and answer the following questions (using the instructions given below):
- 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 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, coefficient of variation and correlation coefficient for and separately (for two sub-period) and comment on the result. (1+ marks, 1 for calculation 2 for the comment)
- Estimate beta for your selected company for the two sub-periods. (2 marks)
- Explain the value of beta that you have calculated. (2 marks).
- Why the estimated value of beta is different for two sub-periods. (4 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:
- On the left 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.
- Click “Historical Prices” icon.
- Next, Click “Monthly data” icon.
- Set Data Range: Start date: February, 2013 and end date: January, 2016.
- Click, “Get Prices”
- In the bottom of the page click, “Download to Spreadsheet”. 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.
- Follow the lecture note and divide the data for two sub-periods: a) Feb, 2013 to July, 2014 and b) Aug, 2014 to January, 2016.
- Risk free rate of interest is given in the assignment.
- Students are allowed to use Microsoft excel or calculator for this assessment.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.