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

Determine the financial structure of business risk, Determine the Financial...

Determine the Financial structure of business risk Financial structure shifts toward suppliers of funds recognize a more highly levered position increased financial risk associ

Describe the term- investment decision, Describe the term- Investment Decis...

Describe the term- Investment Decision Investment decision, also referred to as the capitalbudgeting decision, simply means decisions to acquire assets or to invest in aproj

WACC, The following is the existing capital structure of Company XYZ Ltd. O...

The following is the existing capital structure of Company XYZ Ltd. Ordinary shares at Shs.10 par 1,000,000 Retained 800,000 12% preference shares Shs.10 par 400,000 16% loan Shs.1

Risk and return, I need report on Risk and Return. Do you provide help in t...

I need report on Risk and Return. Do you provide help in topic Risk and Return? I need expert's assistance to solve my college assignment. Please suggest if it works for me.

Global bonds, These are bonds which are offered within the euro marke...

These are bonds which are offered within the euro market and several other markets simultaneously. Unlike Eurobonds, global bonds can be issued in the same curren

Long-term debt, Long- T er m Debt Long-term debt is a deb...

Long- T er m Debt Long-term debt is a debt obligation that has a maturity from the date the obligation was incurred of more than one year. The debt obligation com

Illustrate the scope of financial management, Q. Illustrate the Scope of Fi...

Q. Illustrate the Scope of Financial Management? Financial management as an educational discipline has undergone notable changes over the years with regard to its scope of func

Do you agree or disagree with this statement, Companies with rapidly growin...

Companies with rapidly growing levels of sales do not need to worry about raising funds from outside the firm.  Do you agree or disagree with this statement?  Explain. Disagree

Financial statement, Telephone service costs the Eggleston Motor Hotel $250...

Telephone service costs the Eggleston Motor Hotel $250 per week. The business pays its phone service bill on the fifteenth day of each month, but it prepares its financial statemen

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