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

Bond indexation, Bond indexation serves the purpose of replicating th...

Bond indexation serves the purpose of replicating the performance of a predetermined benchmark as closely as possible. These benchmarks are generally very broader

Explain the powers and functions of sebi, Question 1 What is liquidity ris...

Question 1 What is liquidity risk? What are the causes for liquidity risk? Question 2 Explain the powers and functions of SEBI Question 3 Discuss the various categories

Demerits of pay back method, Demerits of Pay Back Method:- (i) It ignor...

Demerits of Pay Back Method:- (i) It ignores the Cash Flows after the Pay Back Period: - The main shortcoming of this method is that it completely ignores all cash inflows subs

Operation management, Select a business with which you are familiar and ide...

Select a business with which you are familiar and identify examples of customers using search, experience, and credence quality to evaluate the good or service

Type of hedge funds, What are the Types of Hedge Funds? Please provide me r...

What are the Types of Hedge Funds? Please provide me report on Types of Hedge Funds.

Future value of an annuity, Will you please give the defination of "Future ...

Will you please give the defination of "Future Value Of An Annuity"?

Interlinkage in the financial markets, Interlinkage in the Financial Market...

Interlinkage in the Financial Markets - Common Features The interlinkage present in the financial markets is essentially due to the fact that all these markets are in the proce

Determine the concept of cash flow to shareholders, Does financial leverage...

Does financial leverage (debt) have any impact on the Free Cash Flow, on the Cash Flow to Shareholders, on the growth of the company and on the value of the shares? Debt has no

Explain the capital market process, Question 1 State the key functions of ...

Question 1 State the key functions of the financial market. Question 2 Define "Bill of exchange". What are its features? Give different types of cheques. Question 3

Financial leverage, paid-up equty 100000 earning of the company 10000 praic...

paid-up equty 100000 earning of the company 10000 praice - earning ratio(PIE) 20 no.of equty share

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