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.
Ratio Calculation: A 'Financial Ratio' is an index that relates two accounting numbers and is obtained by dividing one number by the other. Various Ratios are - 1. L
Cash management is about managing excess cash also. The response of management must depend on whether the surplus is large and how long it is likely to exist. If the balance is
Business forecasting menaing
As the early 1980s, foreign portfolio investors have purchased an important portion of U.S. treasury bond issues. Discuss the short-term and long-term influences of foreigners’ por
Q. What do you mean by Letter of Credit? A letter of credit is an arrangement whereby a bank helps its customer to obtain credit from its (customer's) suppliers. When a bank op
Placement on career path: The next step of the career planning process is to place an individual on a chosen career path. A career path is the logical possible sequence of pos
Explain about the Internal controls of benchmarking "Comprises control environment and control procedures. It includes all the procedures (internal contr
Roxanne invested $560,000 in a new business 7 years ago. The business was expected to bring in $8,000 each month for the next 26 years (in excess of all costs). The annual cost of
As starting a new business, is it better to leas or buy the business venture?. what factors should be considered. (Knowing that the equity finance is $150,000 and $250,000 could be
The drawbacks of the payback approach are as follows - Payback ignores the overall profitability of a project by ignoring post payback cash flows. In the illustration above the
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