User Account

All Pages

Calculate a range of descriptive statistics for your stocks

Assignment Help Finance Basics
Reference no: EM13840033

Statistics for Business and Finance

Assignment

The members of the teaching staff are NOT allowed to help you in any aspect of the project. So we will not answer any questions directly related to the project, except for those related to the clarification of the content.

Your report need not take a formal report format. You can answer each question below, with supporting Excel outputs (where applicable) included in your report. Your answers should be clear and concise: unclear and unnecessarily long answers may be penalized.
In this assignment, you will analyse stock return of an Australian stock, in comparison with the return of a market portfolio (ASX 200, ^AXJO). The main purpose of the analysis is

• to understand the mean (profit) and variance (risk) profiles of a particular stock, in comparison with those of a comprehensive and well-diversified market portfolio; and • to understand how the stock's return is linearly related with the market portfolio return.

The following table lists the top 11 stocks of the Australian market:

Nu mber Code Name Market Weight (%)

N A CBA Commonwealth Bank 8.88

1 BHP BHP Billiton (Mining) 7.42

2 WBC Westpac Bank 7.36

3 ANZ ANZ Bank 6.28

4 NAB NAB Bank 5.63

5 TLS Telstra (Telecommunication) 4.68

6 WES Westfarmers (Retail) 3.43

7 WOW Woolworth (Retail) 3.09

8 CSL CSL (Pharmaceutical) 2.59

9 WPL Woodside Petroleum 2.25

0 RIO Rio Tinto (Mining) 1.79

You will be assigned with one stock for this assignment. It is the one with the number in the above table that matches the last digit of your student ID number. For example, if your ID number ends with 5, your stock to investigate in this assignment is TSL. The CBA stock is covered in the lecture and tutorials, so you can use the case of CBA as an example in completing this assignment.

If you are using the stock which does not match your student ID, you will get zero mark for the assignment.

Download the price data for your stock and ASX200 index from yahoo finance, monthly from 2009 and 2013. The yahoo finance can be accessed at https://au.finance.yahoo.com/. Calculate monthly holding period returns from price data using Excel. Instructions are given at the end of this document as to how you can download the price data and obtain holdingperiod returns.

For all hypothesis testing questions, state clearly the null hypothesis; alternative hypothesis; level of significance you choose; distribution you use; critical values; and decision rule.

Answer all five questions.

Question 1:

• Calculate a range of descriptive statistics for your stock's return and market portfolio return.

• Compare the profitability and risk of your stock with those of the market portfolio using these statistics, paying attention to the centre, variability, and the shape of the return distributions.

Question 2:

• Test the null hypothesis that the mean of your stock return is equal to that of the market return, against an appropriate alternative hypothesis.

• State under what assumptions the test is valid.

• Based on the outcome of the test, explain whether your stock is more or less profitable than the market portfolio; or whether they are equally profitable.

Question 3:

• Produce a scatter plot between the stock return and market return, and briefly comment on the nature of the linear relationship (direction and strength) between the two.

• Calculate and interpret the correlation coefficient.

• Test the null hypothesis that the correlation is statistically zero against an appropriate alternative hypothesis.

• State under what assumptions the test is valid.
Run the simple regression between the stock return (dependent variable) and market portfolio return (independent variable).

Question 4:

• Explain the relationship between the two by commenting on the coefficient estimates (both intercept and slope).

• Interpret the value of R2.

• Test the null hypothesis that regression slope coefficient is equal to one, against an appropriate alternative hypothesis.

• Suppose the market return in the next month is -5%, what is the expected return of your stock?

Question 5

Write a non-technical summary (no more than 100 words) of your findings.

Instructions on how to get the price data from yahoo finance

Visit Yahoo Finance (https://au.finance.yahoo.com/)

Click Get Prices, and you will see the data appear in the screen.

Go down to the bottom of the page.

You will notice that the date is in the reverse order.

We will use monthly Closing Price as a proxy for monthly price; so you may wish to delete.t

Reference no: EM13840033

Questions Cloud

The signature t-shirts company : The signature T-shirts Company
Which type of legal system exists in north korea : Which type of legal system exists in North Korea? Which of these differentiates an arbitration proceeding from a trial
In which stage of the industry life cycle would you place : In which stage of the industry life cycle would you place the following industries? Oil well equipment Computer hardware Computer software Genetic engineering Railroad
In the short story proofs by richard rodriguez : In the short story Proofs by Richard Rodriguez, what kind of  lifestyle was it for a Mexican man living in the US as a migrant worker? Also, give one direct quote that supports your answer.
Calculate a range of descriptive statistics for your stocks : Calculate a range of descriptive statistics for your stock's return and market portfolio return. Compare the profitability and risk of your stock with those of the market portfolio using these statistics, paying attention to the centre, variability..
What happens to the price level : the short-run version of the AD/AS model, what happens to the price level, output, and employment when AD shifts to the left
What role does your forecast of future interest rates play : You have $5,000 to invest for the next year and are considering three alternatives: A money market fund with an average maturity of 30 days offering a current annualized yield of 3%. A one-year savings deposit at a bank offering an interest rate of 4..
Journalize the transactions and prepare a trial balance : Journalize the transactions - Post to the ledger T-accounts and prepare a trial balance on April 30, 2014.
Relationship between keat young and erfle : relationship between Keat Young and Erfle

Reviews

Write a Review

Finance Basics Questions & Answers

  Gus games stock currently sells for 50 per share there are

1. the three possible outcomes of an investemtn are listed below. all outcomes are equally likely. calculate the

  Write a paper in no more than 1050 words that focuses on

the ongko furniture store scenario or your own organization with approval from your instructor for this assignment

  Sell new shares of stock to the general public

material information related to this issue of stock and what is the name associated with this

  International aspects of a business decision

As a business owner making a final decision regarding the international aspects of a business decision, you may decide to set up a table with the risks and weigh their relative importance against the rate of return you foresee. You also need to pu..

  What is penn trucking cost of retained earnings

Analysts expect Penn Trucking's dividends to grow by 6% per year for the foreseeable future. Using the capital asset pricing model, what is Penn Trucking's cost of retained earnings?

  Taxable income-current income tax expense

Calculate taxable income, current income tax expense, deferred income tax expense, and the ending balances in the deferred tax accounts and valuation allowances.

  Necessity of attending the conference

Suppose that the corporation has as an integral funding strategy to their strategic plan that they will participate in an IPO in approximately twenty four months.

  Caroline weslin needs to decide whether to accept a bonus

caroline weslin needs to decide whether to accept a bonus of 1820 today or wait two years and receive 2100 then. she

  Determine what kuhn company wacc will be for this project

The company is expected to grow at a constant rate of 9.2% and they face a tax rate of 40%. Determine what Kuhn Company's WACC will be for this project.

  The term structure theory which predicts long-term interest

The term structure theory which predicts long-term interest rates will, on average, be higher than short-term interest rates is called

  What is the aftertax cost of debt

Ae, Inc., is trying to determine its cost of debt. The firm has a debt issue outstanding with 8 years to maturity that is quoted at 106 percent of face value. The issue makes semiannual payments and has a coupon rate of 8 percent annually.

  Due diligence and evaluation process

How can the founders prepare for the due diligence and evaluation process?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd