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

What is the significance of working capital, Q. What is the significance of...

Q. What is the significance of Working Capital? Meaning of Working Capital: - Working capital management is an significant aspect of financial management. In business money is

What is capital rationing, What is capital rationing? Should a firm practic...

What is capital rationing? Should a firm practice capital rationing? Why? Capital rationing is the practice of putting dollar limits on what will be invested in new capital bud

Return risk and security market line /net present value .., return risk and...

return risk and security market line /net present value and investment critirea actually iwill be tested in 6 question culculation and 1 question theory about risks

Chi square distribution, Chi Square Distribution If the difference betw...

Chi Square Distribution If the difference between actual and the expected frequencies is zero, the sampling distribution of the chi square statistic c 2  will be identical to a

Elements of financial management, Elements of Financial Management: Fin...

Elements of Financial Management: Financial management is the term given to the overall management of an organisation's finances. It includes a number of elements, or systems,

Negotiation with bidders, N egotiation You can also negotiate with the...

N egotiation You can also negotiate with the bidders based on the requirements as mentioned below. You can negotiate only with the lowest evaluated responsive and qualified

Analysis of collaterals, If normal operating revenues are inadequate ...

If normal operating revenues are inadequate to repay the debt, liquidation of collateral may be necessary. Corporate bonds can be either secured or unsecured by c

What is investment decision, Q. What is Investment Decision ? Investmen...

Q. What is Investment Decision ? Investment Decision: - Investment decision as well known as 'Capital Budgeting' is related to the selection of long-term assets or projects in

Modern / discounting cash flow techniques, Modern / Discounting Cash Flow T...

Modern / Discounting Cash Flow Techniques : These methods generally are of more use to businesses in their investment decisions. They take into account the time value of money and

Explain implications of purchasing power parity, Explain the implications o...

Explain the implications of purchasing power parity for operating exposure. Answer: Determine if the exchange rate changes are matched by the inflation rate differential among

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