Compute excess returns for teslas common and ordinary stock

Assignment Help Corporate Finance

Reference no: EM131454036

Assignment

1. The single-index model goes as follows:

R_i=β_i*R_M+ e_i+ α_i

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.

Using security analysis with the single-index model:

Let's assume that the only asset we can do fundamental analysis on is Tesla. You can find the optimal portfolio produced by combining Tesla with the market. This is, finding the investment opportunities set that produces the highest Sharpe Ratio.

Therefore, the risky portfolio would have two components, an active part (i.e. Tesla) and a passive part (i.e. the S&P500 ETF). The Sharpe ratio of an optimal portfolio with active and passive components exceeds the Sharpe ratio of the passive portfolio. In other words, it lies outside of the Efficient Frontier.

The Information Ratio measures by how much this portfolio exceeds the passive portfolio, a positive information ratio indicates that an active component benefits the investor's portfolio. Measure Tesla's information ratio using the single index regression output as follows:

S^2_0- S^2_M=(α_ACTIVE/σ(e_ACTIVE ) )^2

Attachment:- Calculation_of_Beta_Tesla_Motors_Solution.xlsx

Reference no: EM131454036

Questions Cloud

Explain the goals and restrictions on the prosecutor : What parallels can be drawn between the modern criminal trail and these "legal battle" of the Middle Ages?

Develop the house of quality in qed : Consider some existing product with which you arc familiar. If you work for a manufacturing company, consider a product that is manufactured by your company.

How a police agency can effectively engage : prepare a three to five page report analyzing how a police agency can effectively engage the community in community policing

Training objectives so critical to effective training : Topic #1: Why are training objectives so critical to effective training? to course design?

Compute excess returns for teslas common and ordinary stock : Compute excess returns for Tesla's common and ordinary stock and for the S&P500 index. Estimate CAPM's beta for Tesla using the formula.

Write a paper on autism spectrum disorder : Write a paper on autism spectrum disorder, social delays and impairments in play with children between the ages of 2 and 4.

Eliminate the steady state error : ME 655 - Special Problem Set - Suggest an approach to reduce or eliminate the steady state error caused by a step disturbance by using a step input and describe

Would the merger have violated antitrust laws : If AT&T had merged with T-Mobile, would the merger have violated antitrust laws? Why, or why not? Do not be unduly influenced

Explain fcfs and least slack time : It is currently day 10 in the production calendar of the XYZ Machine Shop. Three orders (A, B, and C) are to be processed at a particular machine tool.

User Account

All Pages