User Account

All Pages

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

  Calculate the net present value npv of this equipment if

betty derose manufacturing vice-president of atlantic industries has been anxious for some time to purchase a piece of

  Compute the overhead controllable variance

Pine Company reports 19,100 actual direct labor hours, and it incurs $167,200 of manufacturing overhead costs. Compute the overhead controllable variance.

  Prepare the journal entry to record pension expense

ABC Co. sponsors a defined benefit pension plan, providing the following info: Prepare the journal entry to record pension expense and plan contributions

  Carleton service center just purchased an automobile hoist

carleton service center just purchased an automobile hoist for 15000.the hoist has a 5-year life and an estimated

  Prepare a classified balance sheet for Lazuris Enterprises

You are provided with the following information for Lazuris Enterprises, effective as of its April 30, 2017, year-end.

  Prepare journal entries to record the disposal transactions

Prepare journal entries to record each of the disposal transactions. Assume that depreciation expense on each asset has been recorded up to the date of disposal

  Give the journal entry that will be recorded on april

On April 10, Fashion received the payment for the sale. Give the journal entry that will be recorded on April 10 by Fashion

  Prepare the journal entries to account for the following

Assume that in 2015 the estimates changed to reflect only 20,000 tons of gold ore remaining. Prepare the depletion journal entry in 2015 to account for the extraction of 10,000 tons of gold ore.

  Discuss audit objectives for auditing income tax accounts

Discuss the audit objectives for auditing income tax accounts. Examine sales returns for approval by an authorized official

  Construct a graphic representation of the data using six

to compare commuting times in various locations independent random samples were obtained from the six cities presented

  Discuss date of issue of a note to the date of its maturity

Which of the following consists of the days or months from the date of issue of a note to the date of its maturity

  Compute the price and quantity variances for the month

Peter s Pretty PJs makes and sells children s pajamas. The standard cost of one unit of this product is:

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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