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

Investment appraisal , what are the limitations of using projected data

what are the limitations of using projected data

Operating economics, Q Operating economics A number of operating econo...

Q Operating economics A number of operating economies will be available with the merger of two or more companies. Duplicating facilities in accounting purchasing marketing etc

Globalization of the financial markets, Globalization of the Financial Mark...

Globalization of the Financial Markets There are many economies in the world that have opened their gates for foreign participants and companies. Trading takes place not only i

Define decision rule for accepting or rejecting projects, What is the decis...

What is the decision rule for accepting or rejecting proposed projects while using net present value? While using the net present value decision rule any project along with a net

Estimate financing types and requirements, This case provides the opportuni...

This case provides the opportunity to match financing alternatives with the needs of different companies. It allows the reader to demonstrate a familiarity with different types

Corporate bonds, Corporate bonds are debt securities issued by privat...

Corporate bonds are debt securities issued by private and public corporations. These bonds are issued to meet specific requirements like building a new plant, pur

Is depreciation the loss of value of fixed assets, Is depreciation the loss...

Is depreciation the loss of value of fixed assets No. An operative (and not a pseudo-philosophical) explanation of depreciation might be: it is a number that allows us to save

Budget classification on the basis of functions, ON THE BASIS OF FUNCTIONS ...

ON THE BASIS OF FUNCTIONS •Functional / Subsidiary budgets: A subsidiary budget is a budget of income or expenditure appropriate to or the responsibility of functions, like

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