01 Jun Question 1. Q1: Index Models: Download 61 months (February 2009 to Febru
Question
1. Q1: Index Models:
Download 61 months (February 2009 to February 2014) of monthly data for the S&P 500 index (symbol = ^GSPC). Download 61 months (February 2009 to February 2014) of Apple Inc. data and 61 months (February 2009 to February 2014) of Exxon Mobil Corporation data. Download 60 months (March 2009 to February 2014) of the 13 week T-bill rate (symbol = ^IRX). Be sure to use end-of-month data! Construct the following on a spreadsheet:
1. Calculate 60 months of returns for the S&P 500 index, Apple and Exxon. Use March 2009 to February 2014. Note this means you need price data for February 2009. On the answer sheet report the average monthly returns for the S&P 500 index, Apple and Exxon, as well as the average monthly risk-free rate.
2. Calculate excess returns for the S&P 500 index, Apple and Exxon. Note you must divide the annualized risk-free rate (^IRX) by 1200 to approximate the monthly rate in in decimal form. On the answer sheet report the average monthly excess returns for the S&P 500 index, Apple and Exxon.
3. Regress excess Apple returns on the excess S&P 500 index returns and report, on the answer sheet, ?, ?, the r-square and whether ? and ? are different from zero at the 5% level of significance. Briefly explain your inference.
4. Use equation 8.10 to decompose total risk for Apple into systematic risk and firm-specific risk. That is, calculate total risk, systematic risk and firm-specific risk for Apple.
5. Regress excess Exxon returns on the excess S&P 500 index returns and report, on the answer sheet, ?, ?, the r-square and whether ?, ? are different from zero at the 5% level of significance. Briefly explain your inference.
6. Use equation 8.10 to decompose total risk for Exxon into systematic risk and firm-specific risk. That is, calculate tot
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.