+1-415-670-9189
info@expertsmind.com
What is the predicted value of the excess return
Course:- Finance Basics
Reference No.:- EM132257305




Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Finance Basics

Financial Modelling Assignment -

In this assignment, explore whether the returns on a portfolio of stocks can be explained by the returns on the market portfolio and two other factors. You have to transfer data to e-views and then do things like regression and then answer the questions.

QUESTIONS -

Q1) In your Excel file, column B contains gross monthly returns on a portfolio of US stocks (denoted by rp), column C contains gross monthly returns on the market portfolio (denoted by rm) and column D contains monthly returns on the risk-free asset (denoted by rf). Columns E and F contain values for two further variables denoted by SMB and HML, which are used in Question 6 below. All data span the sample period January 1980 to December 2017.

a) Import these data into EViews with the same variable names as in the Excel file (e.g. rp, rm, etc.).

b) Generate two new series named rp_ex and rm_ex containing the excess returns above the risk-free rate for the industry portfolio and the market portfolio respectively (i.e. the portfolio returns minus the risk-free asset returns).

c) Calculate the following descriptive statistics for rp_ex and rm_ex: mean, median, standard deviation, skewness, kurtosis, min and max in EViews. Insert the values in the box below and use them to answer the following questions, again in the same box: Which return series is more variable, th rp_ex or rm_ex? What is your interpretation of the skewness and kurtosis statistics for the two return series?

Q2. Estimate the following regression model using your dataset in EViews:

rp_ext = β0 + β1rm_ext + εt

where εt is an error term.

Q3) Based on the R-squared value from the estimated model, how successful is this model at explaining the excess returns on the portfolio? Explain and justify your answer.

Q4. What is the predicted value of the excess return on the portfolio when the excess return on the market portfolio is 3.5% (i.e. when rm_ex= 3.5)?

Q5. Test the null hypothesis that β1 = 1 against a two-sided alternative hypothesis at a significance level of 5%. Clearly show your calculation of the test statistic and explain how you reach your conclusion. Make sure that you state the null and alternative hypotheses, the degrees of freedom used and the critical value from the Student's t-distribution. Note: you may use the default EViews coefficient standard errors that are valid for the case of homoscedastic errors.

Q6. We will now examine if including the two additional variables SMB and HML as additional explanatory variables will improve the ability of the model to explain portfolio returns. Estimate the following multiple regression model in EViews:

rp_ext = β0 + β1rm_ext + β2SMBt3HMLt + εt

Q7) Use the F-statistic to test the null hypothesis that the coefficients on the two new explanatory variables (SMB and HML) added in the second model are both equal to zero. You must calculate the F-statistic yourself using the formula from the lecture notes and not use the test function in EViews. Carefully state your null and alternative hypotheses, the numerator and denominator degrees of freedom for the test and the relevant 5% critical value from the F-distribution. Clearly show how you calculate the value of the test statistic and explain what the outcome of the test is.

Q8) Based on your answer to the previous question and any other information from the regression output of the two models that you think is relevant, which of the two models is more suitable for explaining the excess returns on the portfolio? Clearly explain and justify your answer.

Attachment:- Assignment Files.rar




Put your comment
 
View Conversion
Minimize
  1. user image
    len2257305

    You have to transfer data to eviews and then do things like regression and then answer the questions in the document. In this coursework, our goal is to explore whether the returns on a portfolio of stocks can be explained by the returns on the market portfolio and two other factors. On Moodle, under the ‘Coursework’ section, click on the link named ‘Coursework dataset assignments’. Open the Excel file that downloads, locate your student ID number in the list and note your assigned dataset number. This is the dataset you are required to use in your coursework. Note: you will lose marks if you do not use the dataset that is assigned to you.

  2. user image
    len2257305

    Download the Excel file that corresponds to your assigned dataset number. The files are all under ‘Coursework’, and the links are in the form ‘BE314 coursework dataset X’ where X is your assigned dataset number from step 1. You are asked to answer the questions below. Fill in this Word document and submit it as your coursework. Keep the margins of this document and the templates given underneath each question as they are and use a 11 pt. font or larger when writing up your answers. Note: you will lose marks for changing the size of the answer boxes or for badly formatted answers.



Ask Question & Get Answers from Experts
Browse some more (Finance Basics) Materials
What are the effects of an increase in wealth on the demand for money and the demand for bonds? Explain in words. What are the effects of an increase in income on the deman
Identify and compare interest rates, both short-term and long-term, using debt and equity. Analyze the financing mix (short/long) and the cost associated with the recommendati
Your brother, who is 6 years old, just received a trust fund that will be worth $25,000 when he is 21 years old. If the fund earns 0.10 interest compounded annually, what is
Finally, Dr. Jones compared the activity level for the high-sugar group with the activity level for the low-sugar group. Explain why Dr. Jones' study is not an example of th
How is the cost of bond financing typically related to the cost of short-term borrowing? In addition to a bond’s maturity, what other major factors affect its cost to the issu
Canvas Reproductions, Inc., has spent $4,500 dollars researching a new project. The project requires $20,000 worth of new machinery, which would cost $3,000 to install. The co
The Henry Tax Review was released by the Australian Commonwealth Government on May 2, 2010. What is the current company tax rate in Australia and how will the Government cha
Alternative B-The equipment dealer has agreed to finance the equipment with a 1-year loan. The $100,000 loan would require payment of principal and interest totaling $116,30