Compute the beta value for each stock

Assignment Help Accounting Basics
Reference no: EM132291252

Question: You will need to collect the stock price data for any 2 companies of your choice and the S&P 400 index. Choose companies that are in different industries.

Collect the end-of-month prices for the last 21 months of your chosen stocks and the S&P 400 and set them on the spreadsheet.

Taking this raw data, compute the monthly returns for all (there should be 20 returns). Make sure that I am able to see the cell formulas for each computation.

Next, compute the mean rate of return and the standard deviation of returns for both your stocks and the stock market.

Compute the beta value for each stock and plot the characteristic lines of the 2 companies on 2 graphs.

Compute the correlation coefficient for the 2 stocks. Plot the returns of your stocks against each other on a graph within the spreadsheet.

Next, assume that you construct a portfolio where you put equal money in each of your 2 stocks.

Compute the 20 monthly rates of return for the portfolio and the standard deviation of returns of the portfolio and its beta value.

Finally, within the spreadsheet discuss in DETAIL your findings regarding risk/return of your portfolio as compared to the risk/return characteristics of the 2 individual stocks. These comments must be detailed with a complete analysis.

Reference no: EM132291252

Questions Cloud

What other insights can you share to reinforce : Clinton and England (2016) refer to managerial (a.k.a., cost) accounting as a "decision science." Incorporating managerial accounting is thought to focus.
Evaluate the usefulness to investors of the inclusion : Determine the main characteristics of a variable interest entity (VIE). Evaluate the usefulness to investors of the inclusion of VIEs in the company's.
How will the business and customers be impacted : One of the business changes proposed in the chapter is a change from salaried sales positions to compensation based on commissions. As demonstrated.
Write a scope statement for the selected project : Systems Project Management (COMP 30018) - Middle East College - Evaluate business environment and be able to manage and implement change towards strategic
Compute the beta value for each stock : Compute the beta value for each stock and plot the characteristic lines of the 2 companies on 2 graphs. Compute the correlation coefficient for the 2 stocks.
Compare the responsibility of both management and auditor : Compare the responsibility of both management and the auditor for financial reporting, and give your opinion as to which party should have the greater burden.
Discuss the development of mulitiplicative model : In addition to his day job as an engineer, Luis Garcia runs a small ethnic grocery store. The shop stocks food items from southeast Asian countries and caters.
Prepare the financial statements for dickens corp : Dickens Corp.'s fiscal year ends on December 31. It started fiscal year 20X6 with $4,800 retained earnings. Below is its financial information as of December.
Evaluate developments in medical and medical biotechnology : Critically evaluate developments in medical and medical biotechnology in research institutions and the pharmaceutical industry

Reviews

Write a Review

Accounting Basics Questions & Answers

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

Free Assignment Quote

Assured A++ Grade

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd