Calculating investment statistics and graphing output, Financial Management

Assignment Help:

Step 1) Opportunity Set Graph:Combine 2 of your stocks (Ignore the other 2 stocksfor this step only).  Construct an investment opportunity set (the curved set) between the two risky assets.  Graph the resulting curve and on a Mean-StDev graph. Use the X Y (Scatter) option and allow the lines to cross. On the same graph also graph the capital allocation line for one of your portfolios and the risk-free asset.  The risky asset for thecapital allocation line should be a portfolio consisting of 40% of Stock 1 and 60% of stock 2.

Step 2) Regressions: Use the "data analysis" and "regression" features in Excel to complete a regression equation for each of your four stocks.  Have Excel display the regression statistics on the "Regression Output" page.  Enter the alpha, beta, and R-squared from this in your analysis table.  Also, use the "slope" function in Excel to calculate the slope of your line.  For both the regression analysis and the slope function, specify the data range for the excess return for your stocks from the "Regression Data" page as the y-variable and the data range for the excess return for the S&P index on the "Regression Data" page as your x-variable. 

Step 3) Scatter-Plots: Create a scatter-plot of each of your four stocks where the excess returns for the stock are on the y-axis and the excess returns for the S&P 500 are on the x-axis.  Have Excel display the plot on the "Scatter Plot" page. Add a trend-line line by selecting (highlighting) the data series, then right click and select "add trend-line." Also display the regression equation and the R2 value on the chart by right-clicking on the trend-line and then selecting "format trend-line."  Enter the alpha and beta from this in your analysis table.

Step 4) Complete Table: On the "Analysis" page you will need tocomplete the table of information.  Be sure to use the appropriate cell references where applicable.


Related Discussions:- Calculating investment statistics and graphing output

Objectives of working capital management, Q. Objectives of working capital ...

Q. Objectives of working capital management? The objectives of working capital management are habitually stated to be profitability and liquidity. These objectives are habitual

Historical differences in equity securities, Public Bourses The origin ...

Public Bourses The origin of this type of bourses can be found in the legislative work of Napoleon. These type of bourses are regulated by the government, brokers are appointed

Determine about the call and put option, Determine about the call and put o...

Determine about the call and put option A call/ put option provision allow both issuing company and investor to redeem the bonds at a specified amount before maturity date. Lon

Exam answers, Prepare your recommendation on Agarwal Cast Company

Prepare your recommendation on Agarwal Cast Company

Incremental policy model to the policy making process, Question 1: Poli...

Question 1: Policy implementation is the most critical stage of the policy process. Critically analyse some of the main constraints that hinder the implementation of public pol

Profit & loss account, waht are the basic functions of profit & loss accoun...

waht are the basic functions of profit & loss account

Explain the term phishing, QUESTION (a) (i) Describe briefly two potent...

QUESTION (a) (i) Describe briefly two potential E-Banking risks that may have an adverse impact on banks. (ii) Outline some measures to control these two risks. (b) Outli

Exchange of physicals, Exchange of Physicals: A trader can also complet...

Exchange of Physicals: A trader can also complete the futures contract by engaging in exchange of physicals. In this method, the parties agree to exchange cash and the commodit

Calculate the break-even point, A Video Rental store has two employees. The...

A Video Rental store has two employees. The Supervisor is paid $2,200 per month. The other employee, Mark is paid $1,200 per month. In addition, Mark is paid a commission of 20 cen

What is the ratios based on historic cost accounts, What is the Ratios base...

What is the Ratios based on historic cost accounts Ratios based on historic cost accounts don't give a true picture of trends, due to the effects of inflation and different acc

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd