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

The standard contribution rate and actuarial liability, Question 1: Giv...

Question 1: Give the formulae for the Standard Contribution Rate (SCR) and Actuarial Liability (AL) for each of the following funding methods: a) Credit Unit Method b)

Sources of funds, What are sources of funds for an assignment?

What are sources of funds for an assignment?

Define the term corporate and financial relations, Question: (a) Define...

Question: (a) Define the term "corporate and financial relations" and clearly state its components. (b) By using one example, identify the steps required to establishing cor

Functions of financial manager, Functions of Financial Manager: - The finan...

Functions of Financial Manager: - The financial manager is a associate of top management. He is intimately associated with the formulation of financial policies as well as financia

Approximating the percentage price change using duration, Let us expr...

Let us express the process of calculating approximate percentage price change for a given change in yield and a given duration using the following formula:

Yield, Yield Yield represents the actual return on the investments. Dif...

Yield Yield represents the actual return on the investments. Different types of yield are discussed below: Coupon Yield: The fixed interest rate on a government security or

Price volatility characteristic of bond with embedded option, The price of ...

The price of the embedded option comprises two components. The first is the value of the same bond assuming it has no embedded option (option-free bond), th

Facts about mortgages, Lenders in the US insist upon ...

Lenders in the US insist upon some kind of mortgage insurance. There are broadly two types of mortgage insurance - one is

Functions of finance financial management, Q. Explain Functions of Finance ...

Q. Explain Functions of Finance Financial Management? Functions of Finance or else Financial Management: - The functions of Financial Management are: (1) Determining the Fin

Explain capital in a money market or capital market, Question 1: (a) Ad...

Question 1: (a) Advise a risk averse individual whether to invest his capital in a money market or capital market. Justify your answer. (b) Explain five types of Money marke

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