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.
Accounting Period - Accounting Principle Accounting period refers to span of time at the end of that and for which the financial statement are prepared to throw light on the r
#questi Saven Travel Corporation is considering several investment opportunities in order to diversify its operations. Mr. Saven, president, is trying to determine the firm''''s co
paid-up equty 100000 earning of the company 10000 praice - earning ratio(PIE) 20 no.of equty share
You've just won a huge $100 million lottery. You've decided to invest your winnings in the following way: $30 million in real estate, $30 million in corporate bonds and $40 mil
Q. Explain about Invoice discounting? Invoice discounting is a technique which is able to be used to raise finance against receivables. Invoice discounting works as follows:
Q. Credit control - account receivable management? Once credit has been established it is important to review outstanding accounts on a regular basis so overdue accounts can be
Suggestion regarding Credit limit. Should it be approved or not, what should be the amount of credit limit that electronics give to Booth Plastics.
1. Suppose Bank one offers a risk free interest rate of 5.5% on both savings and loans, and Bank Enn offers a risk free interest rate of 6% on both savings and loans. What arbitra
No External Financing for New Proposals: If a firm have sufficient retained earnings with it as required by the new proposal, then the firm may not raise any external finance. In
Q. Define the finance function? Is it a risk-return trade off? What is the basic role of a modern financial manager? What is the basic importance of finance function in the mana
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