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

Underwrite, Under write An arrangement under which the investment b...

Under write An arrangement under which the investment banks agree to purchase a certain amount of privacy of a new issue (typically an IPO) at a given date for a given pric

WACC, Saven Travel Corporation is considering several investment opportunit...

Saven Travel Corporation is considering several investment opportunities in order to diversify its operations. Mr. Saven, president, is trying to determine the firm''''s cost of ca

Types of asset-backed securities, Types ...

Types of asset-backed securities 1.  Auto Loan-Backed Securities (ALBs) 2.  Credit Card Receivab

Why is the coefficient of variation a better risk measure, Why is the coeff...

Why is the coefficient of variation a better risk measure to use than the standard deviation when evaluating the risk of capital budgeting projects? The coefficient of variatio

Caselet, Suggestion regarding credit limit. should it be approved or not, w...

Suggestion regarding credit limit. should it be approved or not, what should be the amount of credit limit that electronics give to booth plastics

Define political risk into the capital budgeting process, How would you inc...

How would you incorporate political risk into the capital budgeting process of foreign investment projects? One method is to adjust the cost of capital upward to imitate politi

Gordon''s dividend equalisation model, If the EPS is Rs.5, dividend pay-out...

If the EPS is Rs.5, dividend pay-out ratio is 50%, cost of equity is 20% and growth rate in the ROI is 15%. What is the value of the stock as per Gordon's Dividend Equalisation Mod

Exchange rate changes decrease risk of foreign investment, Would exchange r...

Would exchange rate changes all time increase the risk of foreign investment? Discuss the condition within which exchange rate changes may actually decrease the risk of foreign inv

Calculate the net investment of the firm, Problem: i) Assume a firm bu...

Problem: i) Assume a firm buys a new tooling machine for Rs 2000,000, installation costs net of taxes are Rs 300,000. An existing asset has a book value of Rs 400,000 and the

Analyze the corporate financial statements, You are currently an Analyst wo...

You are currently an Analyst working for a finance publication firm and as part of your responsibilities; you are required to provide a monthly forecast and analysis of certain com

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