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

Under what circumstances is a warrant''s value high, Under what circumstanc...

Under what circumstances is a warrant's value high ?  Explain. A warrant's value would be elevated when the stock price, time to expiration, and/or expected stock price volatil

Debt ratio, Calculate the sustainable growth rate

Calculate the sustainable growth rate

Mushrooming of public private partnerships, Question 1: i) Activity Bas...

Question 1: i) Activity Based Costing is better than the Traditional Product Costing. Discuss, by making use of empirical evidence ii) The replacement of cash-based accounti

How can we calculate the average inventory, Inventory days (Average in...

Inventory days (Average inventory/Cost of sales) x 365days Average inventory can be arrived by taking this year's and last year's inventory values and dividing by 2 - (Ope

How the export promotion trade strategy, Question 1: (i) How are educa...

Question 1: (i) How are education and economic growth connected? (ii) Explain how the export promotion trade strategy may be more growth promoting for developing economies,

Expert , i have Passed all three level of CFA program and i want to join y...

i have Passed all three level of CFA program and i want to join you expert team. will you please tell me will this happen

Auto loan-backed securities (albs), The issuers of ALBS are the finan...

The issuers of ALBS are the financial subsidiaries of automobile manufacturers, commercial banks and other independent finance companies and small financial insti

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

Sensitivity analysis, A division of Saron plc is considering introducing a ...

A division of Saron plc is considering introducing a new product.  The product is the result of work undertaken by the division's research and development department - the expendit

The characteristics of the website development project, P Company manufactu...

P Company manufactures and sells a range of children's clothing through its retail shops and is currently designing a website in order to allow customers to purchase products onlin

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