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.
Various bond features largely affect the degree of correlation between the bond's prices and the bond's interest rates. Some of the bond feature
Pay Back Period (PBP) : This is the most popular method employed by industrial practitioners for ranking investment projects. This is described as the "period required for a pr
What are the benefits of the JIT inventory control system? The just-in-time that is abbreviated as JIT inventory control system lowers inventory carrying costs and tends to inc
Types of equaty Securities Equity securities, traditionally, are classified into two types when they are issued. They are: Common Stock, and Preferred Stock. Common Stoc
Inventory is sometimes thought of as a necessary evil. Explain. Inventory ties up funds and these types of funds are not earning an explicit return. A few inventory is often es
How are financing costs generally incorporated into the capital budgeting analysis process? Financing costs are generally captured in the discount or hurdle rate while doing NPV
Why do financial managers calculate the marginal tax rate? Financial managers make use of marginal tax rates to estimate the future after-tax cash flows from investments. As th
How does a preemptive right protect the interests of existing stockholders? A preventive right protects the interests of existing stockholders by giving them the opportunity to
The issuer's right to call back the issue before the maturity date is referred to as a "call provision". In case of asset-backed securities, the trustee is grante
Geographical Classification of Mutual Funds : Nations' boundaries provide territorial restrictions on the sale and purchase of mutual fund units or shares as is the case in com
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