18 Jun COMPUTE EXCESS RETURNS FOR TESLA’S COMMON AN
COMPUTE EXCESS RETURNS FOR TESLA’S COMMON AND ORDINARY STOCK AND FOR THE S&P500 INDEX.
September 20, 2018Posted by: kajo No Comments
Use the space below to identify all the terms in the equation:
The single index model may be interpreted as a single-variable regression equation of Ri on the market excess return RM. Identify the intercept, slope and error term in the space below:
2. Use the Excel spreadsheet provided in Isidore’s resource section labeled “Calculation of beta – Tesla Motors.xls” to estimate the CAPM parameters for Tesla’s stock. For this you will do the following:
Compute excess returns for Tesla’s common and ordinary stock and for the S&P500 index.
Plot in a chart the S&P500 excess returns (horizontal axis) and Tesla excess returns (vertical axis). Using a ruler draw a line that best fits the relation between the S&P500 and Tesla excess returns.
Estimate CAPM parameters:
Estimate CAPM’s beta for Tesla using the formula. By definition beta is the covariance between the asset and the market excess returns divided by the variance of the market excess returns.
Estimate CAPM’s beta for Tesla using the =SLOPE function in Excel
Regress excess market returns on excess Tesla returns using the Data Analysis Toolpack in Excel. Request test statistics at the 95% significance and model residuals
Write the regression equation for Tesla’s excess returns (include t-statistics for each coefficient in parentheses) and make a prediction for Tesla’s return next month if the S&P500 returns increase by 1%. Express your answer in annualized terms (EARs).
Repeat this exercise for GM’s stock.
Using Tesla’s regression equation, draw Tesla’s Security Characteristic Line. Plot Tesla’s most recent monthly return in the chart, calculate alpha for that month and determine whether the stock is over or underpriced.
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.