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

Callable bonds and puttable bonds, Convertible bonds can be classified into...

Convertible bonds can be classified into different types such as callable bonds and puttable bonds. These bonds are discussed as follows: Basics of Callable Bonds A callabl

Evaluate the revenue and cost, a) TFC = $1,840 (Rent, Salaries, Admin + Pow...

a) TFC = $1,840 (Rent, Salaries, Admin + Power) (b) BEQ = $1,840 / $16 = 115 child places (c) Graph: Title; Axis labels; TR line; TC line and TFC line accurately drawn and la

Example on interest rate movements, Q. Example on interest rate movements? ...

Q. Example on interest rate movements? Cap/floor volatility is consideration to be higher than swaption volatility because the market buys volatility trough swaptions as well a

Quantitative analysis, Your task is to prepare a presentation for a group o...

Your task is to prepare a presentation for a group of board members who are considering an investment of $100 million in your company. Your presentation will consist of three disti

banking in business, a. Talk about the role of banking in business.  b....

a. Talk about the role of banking in business.  b. Set out the precise role played by Investment Banking and the challenges of corporate governance.

Financial systems, Financial Systems: The overall financial management ...

Financial Systems: The overall financial management framework will include a number of elements such as: Financial systems designed to capture the details of each financ

Electronic communications networks, Electronic Communications Networks: ...

Electronic Communications Networks: In traditional stock exchanges, the buying and selling of stocks take place at a physical location only and the members have to conduct tradi

Equity share valuation.., Mount Hutt Ltd. just paid dividend of $2.20 per s...

Mount Hutt Ltd. just paid dividend of $2.20 per share. The dividends are expected to grow at a constant rate of 4% per year, indefinitely. If investors require an 11% return on Mou

Explain the market analysis of events, Question 1 Describe the Cost Vol...

Question 1 Describe the Cost Volume Profit analysis. Explain its features, objectives and elements(CVP analysis) Question 2 Write in detail about the classification of

Show the sales forecasting, A niche market targets a well-defined and speci...

A niche market targets a well-defined and specific market segment. Firms that operate in niche markets will therefore cater for the precise and distinct needs of their customers. D

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