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

Review of financial research report, This assignment is an analysis of a U....

This assignment is an analysis of a U.S. publicly-traded company; its common stock could be a prospective investment. The report is due in Week 10, in needs to be at least 5 pages

Calculate the net present value, NPV and Other Criteria Waddington Inter...

NPV and Other Criteria Waddington International Inc. has $20 million to invest. It is considering whether to build a new factory in Western Canada. The land and the building wil

Calculate the total extra annual cost, Question : (A) The following dat...

Question : (A) The following data for the current year relate to a sterile pack purchased by the Apollo Hospital: Annual demand                        90,000 units Ann

Identification the management risk, Identification the management risk: ...

Identification the management risk: The first and most essential aspect of risk management is recognising what events may occur within a business.  It is only when all the poss

Discuss risk from perspective of capital asset pricing model, Discuss risk ...

Discuss risk from the perspective of the Capital Asset Pricing Model (CAPM). The Capital Asset Pricing Model or CAPM be able to be used to compute the appropriate required rate

Define the meaning of overtrading, Define the meaning of Overtrading Wh...

Define the meaning of Overtrading When  a  company  is  trading  at  a  very  fast  pace,  it  would be  generating  sales  on  credit  with  speed, so have a large volume of t

Coupon interest payment, An investor receives periodic interest...

An investor receives periodic interest payments at specified intervals till the date of holding or maturity. However, the holder of zero coupon

Explain the factors which company should apply, Explain the factors which c...

Explain the factors which company should apply Companies to be the very best must Establish what competition is doing Set the very best standards to exceed Es

NET INCOME APPROACH.., You are required to compute the value of both the fi...

You are required to compute the value of both the firms using Net Income approach.

Wacc based on the president''s preference, Sapp Trucking's balance sheet il...

Sapp Trucking's balance sheet illustrates a total of noncallable $45 million long-term debt with a coupon rate of 7.00% and a yield to maturity of 6.00%.  This debt presently has a

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