Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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.
Assume Intel''s stock has an expected return of 26% and a volatility of 50%, while Coca-Cola''s has an expected return of 6% and volatility of 25%. If these two stocks were perfect
Explain how to measure the firm risk of a capital budgeting project. The firm risk of a capital budgeting project calculates the impact of adding a new project to the existing pr
Determine the term- Component Cost and Composite Cost A company may contemplate to raise desired amount of funds by different sources comprising preferred stock, debentures and
Define depreciation expense as it appears on the income statement. How does depreciation affect cash flow? The term accounting depreciation is the allocation of an asset's init
Under this approach of Valuation, all cash flows are discounted using single interest rate (discount rate). For example: Consider the 5-year (7.00 percent) Treas
I need a report on the topic Investment of Surplus Cash. Can you please assist me for Investment of Surplus Cash report for about 2000 words?
Question 1 What is liquidity risk? What are the causes for liquidity risk? Question 2 Explain the powers and functions of SEBI Question 3 Discuss the various categories
Q. How to calculate correlation co-efficient? The correlation co-efficient measures the nature and the extent of relationship between the stock market index return and the stoc
Cascade Water Company (CWC) currently has 30 000 shares of common stock outstanding, trading at a price of R42 per share. CWC also has 500 000 bonds outstanding that are currently
Q. Forms of Bank Finance? A firm can draw funds from a bank within the maximum credit limit sanctioned. It can draw funds in the following forms: 1) Overdraft 2) Cash Cre
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!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd