Answer the following questions: (I NEED ANSWER TO ONLY QUESTION 4 BELOW) El Cap Climbing Company (ECCC) is looking at determining its sensitivity to market fluctuations. Since ECCC isn’t publically traded and can’t look at its own stock history it must evaluate its competitors. Black Diamond Equipment is its closest competitor but the company doesn’t have enough trading volume to make any sound conclusions. Leah identifies Callaway Golf Company (ELY) as ECCC’s closest publicly-traded competitor. Even though ELY sells golf equipment it too is a specialized company selling high-tech sports equipment. Note: This information is also in your textbook. CAPM is one of the most thoroughly researched models in financial economics. When beta is estimated in practice a variation of CAPM called the market model is often used. To derive the market model start with the CAPM: E(Ri) = Rf + Î²[E(RM) âˆ’ Rf] Since CAPM is an equation you can subtract the risk-free rate from both sides which gives you: E(Ri) âˆ’ Rf = Î²[E(RM) âˆ’ Rf] This equation is deterministicâ€”that is exact. In a regression youll realize that there’s some indeterminate error. You need to formally recognize this in the equation by adding epsilon which represents this error: E(Ri) âˆ’ Rf = Î² [E(RM) âˆ’ Rf] + Îµ Finally think of the above equation in a regression. Since there’s no intercept in the equation the intercept is zero. However when you estimate the regression equation you can add an intercept term which is called alpha here: E(Ri) âˆ’ Rf = Î±i + Î²[E(RM) âˆ’ Rf] + Îµ The intercept term is known as Jensen’s alpha and it represents the asexcessâ€ return. If CAPM holds exactly this intercept should be zero. Think of alpha in terms of the SML: If the alpha is positive the stock plots above the SML; if the alpha is negative the stock plots below the SML. You’ll first create a scatter plot and then perform a regression analysis for ELY stock and the mutual fund. Then use those results to compare and analyze the results. A. Scatter Plotting and Regression Analysis Use the following steps to create the scatter plot: EditEdit 3. Move the chart to the side of the data and increase the size of the chart. Click on the Chart Title and change it to Risk Premium Analysis. 4. In the Design tab click on Quick Layout. Select the layout that gives you the y formulas and the R2. Now use the following steps to create a regression analysis for ELY and for the Mutual Fund: If you don’t see Data Analysis you might need to add Analysis Toolpak in Excel. For instructions on how to load the Analysis Toolpak into your version of Excel visit https://support.office.com/en-us/article/Load-the-Analysis-ToolPak-6a63e598-cd6d-42e3-9317-6b40ba1a66b4. Contact Microsoft Support if you have any issues with this add-in. Once youve completed all these steps you can continue with your project. 3. Your regression analysis will open in a new worksheet. Rename the worksheet based on the premium being compared to the S&P premium for example: asELY Regression Analysis.â€ Requirements: as per question requirements | .doc file In this regression Rt is the return on the stock and Rft is the risk-free rate for the same period. RMt is the return on a stock market index such as the S&P 500 index. Î±i is the regression intercept and Î²i is the slope (and the stock’s estimated beta). Îµt represents the residuals for the regression. The intercept Î±i is often called Jensen’s alpha. What does it measure? If an asset has a positive Jensen’s alpha where would it plot with respect to the SML?Rt âˆ’ Rft = Î±i + Î²i [RMt – Rft] + Îµt Is the alpha of either ELY or the mutual fund significantly more or less than zero? (Hint: The alpha is the intercept.) How do you interpret the beta for the stock and the mutual fund? (Hint: The beta is next to the coefficient.) Which of the two regression estimates has the highest R-squared? Is this what you would have expected? Use the scatterplot to explain why. Go to the Part 4 Stock Data tab in your Excel spreadsheet. Highlight column Kâ€“M headings then hold down the Ctrl button and select cells K-3 through M-62. Go to the Insert tab click on Scatter Chart and select the first style. Move the y formulas and the R2 to the bottom right-hand corner of the chart. First check to see that you have the ability to run the analysis. Go to the Data tab in Excel and look for the Data Analysis feature shown in the following image. Click on Data Analysis. A dialog box with a list of analysis tools will open. Select Regression from the list and click OK. Next another dialog box opens for you to select your Inputs and Output for the regression. Select the input data ranges by highlighting S&P Risk Premium numbers (x-axes range) and the number for the asset you’re comparing as the y-axes range. Output to a new worksheet (do not type a name in the text box). Select the checkboxes for Labels Confidence Level and Residuals. Click OK. In this regression Rt is the return on the stock and Rft is the risk-free rate for the same period. RMt is the return on a stock market index such as the S&P 500 index. Î±i is the regression intercept and Î²i is the slope (and the stock’s estimated beta). Îµt represents the residuals for the regression. The intercept Î±i is often called Jensen’s alpha. What does it measure? If an asset has a positive Jensen’s alpha where would it plot with respect to the SML?Rt âˆ’ Rft = Î±i + Î²i [RMt – Rft] + ÎµtIs the alpha of either ELY or the mutual fund significantly more or less than zero? (Hint: The alpha is the intercept.)How do you interpret the beta for the stock and the mutual fund? (Hint: The beta is next to the coefficient.)Which of the two regression estimates has the highest R-squared? Is this what you would have expected? Use the scatterplot to explain why. Go to the Part 4 Stock Data tab in your Excel spreadsheet. Highlight column Kâ€“M headings then hold down the Ctrl button and select cells K-3 through M-62.Go to the Insert tab click on Scatter Chart and select the first style. Move the y formulas and the R2 to the bottom right-hand corner of the chart. First check to see that you have the ability to run the analysis. Go to the Data tab in Excel and look for the Data Analysis feature shown in the following image. Click on Data Analysis. A dialog box with a list of analysis tools will open. Select Regression from the list and click OK.Next another dialog box opens for you to select your Inputs and Output for the regression. Select the input data ranges by highlighting S&P Risk Premium numbers (x-axes range) and the number for the asset you’re comparing as the y-axes range. Output to a new worksheet (do not type a name in the text box). Select the checkboxes for Labels Confidence Level and Residuals. Click OK. ‘

The price is based on these factors:

Academic level

Number of pages

Urgency

Basic features

- Free title page and bibliography
- Unlimited revisions
- Plagiarism-free guarantee
- Money-back guarantee
- 24/7 support

On-demand options

- Writer’s samples
- Part-by-part delivery
- Overnight delivery
- Copies of used sources
- Expert Proofreading

Paper format

- 275 words per page
- 12 pt Arial/Times New Roman
- Double line spacing
- Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Delivering a high-quality product at a reasonable price is not enough anymore.

That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more