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.
Evaluate the firm’s financial standing for the past 5 years: • Undertake a financial and strategic analysis of its performance: o Use the Assignment Questions for guidance ON
A friend is looking for advice on one of his investments, KER. KER manufactures stationery supplies, the entity appointed a new Chairman in 2008 and since then has been executed an
Forward market evaluation Net receipt in 1 month = 240000 - 140000 = $100000 Nedwen Co requires to sell dollars at an exchange rate of 1.7829 + 0.003 = $1.7832 per £ Ster
Shareholders Shareholders are usually assumed to be interested in wealth maximisation. This though involves consideration of potential return and risk. Where a company is liste
Securities Exchange Act of 1934 With this Act, the Congress created the Securities and Exchange Commission. The Act empowers the SEC with broad authority over all aspects of th
CORPORATE GOVERNANCE Corporate governance can be stated in different ways, for example: The Private Sector Corporate Governance Trust (PSCGT) defines that corporate governan
The ledger of AISExperts Inc. showed the following balances after adjustment , but before closing, on December 31, 2012, the end of the current year: Accounts payab
Gretz Tool Company is a large U.S based Multinational Corporation with subsidiaries in eight different countries. The parent of Gretz provided initial cash infusion to establish ea
I need a paper on the financial status of the company under armour with ratios using information from yahoo.com finances. & Id like to provide a document with further details
causes for financial innovation
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd