Compute the mean and standard deviation

Assignment Help Finance Basics
Reference no: EM13883856

 I/. choose  a stock and S& P 500 Index (ETF) and import 1 year of daily stock prices into MS Excel,a. Compute the daily return of the stock and S & P 500,b. Compute the mean and standard deviation of the stock's return and S & P 500,

II/ . Use the Data Analysis ADD-In of Excel to compute the stock's beta coefficient. Regress thestock's return on the return of the S & P 500.

III/ . Using the regression output, determine the stock's systematic and unsystematic risks.Var(R) = β^2Var [S&P 500] + Var [e] = systematic risk and unsystematic risk

IV/ . Provide an explanation.

V/ . Repeat above steps for another stock (not S & P 500, you already have that)

Reference no: EM13883856

Questions Cloud

What is the corporation''s federal tax obligation : What is the corporation's Federal Tax Obligation? Taxable Income: $2,000 Taxable Income: $65,000
Short term investments : The following December 31, 2013, fiscal year end account balance information is available for the Stonebridge Corporation:
Abc golf equipment corporation : You are the CFO (Chief Financial Officer) of ABC Golf Equipment Corporation, a small company that sells golf equipment. Mr. Hillbrandt, the new CEO (Chief Executive Officer) has a marketing background and is trying to learn more about the financial s..
Forecasts for the pet-px margin : Develop forecasts for the PET-PX margin based on contract pricing using data from (a) Jan. 2000-Oct. 2010, (b) Jan. 2006-Oct. 2010, and (c) Oct. 2009-Oct. 2010. In each case, predict the PET-PX margin in Jan. 2020. Which forecast appears to be mos..
Compute the mean and standard deviation : I/. choose  a stock and S& P 500 Index (ETF) and import 1 year of daily stock prices into MS Excel,a. Compute the daily return of the stock and S & P 500,b. Compute the mean and standard deviation of the stock's return and S & P 500,
Influence of organizational culture on positive hrm outcomes : Influence of organizational culture on positive HRM outcomes,Organizational culture and its impact on employee motivation,Organizational culture and its impact on employee engagement,Manner in which outcomes can be improved.
What are the major piece of information : q1.  What are the major piece of information that a company can get by monitoring it's sources and uses of cash? How can that information be used to maximize shareholder wealth?
What is the crossover rate between project : What is the crossover rate between Project A and Project B given the following cash flows:
Chlorination of ethylene to produce dichloromethane : In the chlorination of ethylene to produce dichloromethane (DCE), the conversion of ethylene is reported as 99.0%. If 94 mol of DCE are produced per 100 moll of ethylene reacted, calculate the selectivity and the overall yield based on ethylene. T..

Reviews

Write a Review

Finance Basics Questions & Answers

  How much loss would the company recognize

Randy's tireland makes a product that sells for $62 per unit and has $51 per unit in variable costs. Annual fixed costs are $24,000. If Rambles sells 10 units less than breakeven, how much loss would the company recognize on its income statement?

  Compute the annual rate of return on this machine using

assume that a machine costing 300000 and having a useful life of five years with no salvage value generates a yearly

  Calculate the weighted cost of the capital

Assume the following facts about a firm's financing in the next year. Calculate the weighted cost of the capital of this project.

  How much more money can publisher put into advertising

Assume authors' royalties are reduced and sales remain constant; how much more money can the publisher put into advertising (a fixed cost) and still break even?

  Youre considering a project with initial cash outlay of

you are considering a project with an initial cash outlay of 80000 and expected free cash flows of 20000 at the end of

  Calculate after-tax cost of debt financing

Last year Wei Guan corporation had $350 million of sales, and it had $270 million of fixed assets that were used at 65 percent of capacity. In millions, by how much could Wei Guan's sales raise.

  How much will you have in the account at the end of 20 years

You invest $3,000 annually in no-load mutual fund that has a 5% exit fee. The fund earns 10% annually before fees, and you reinvest all distributions. How much will you have in the account at the end of 20 years?

  A local partnership has assets of cash 130000 and land

a local partnership has assets of cash 130000 and land recorded at 700000. all liabilities have been paid and the

  Alpha stock has a beta of 123 its required return is 1175

alpha stock has a beta of 1.23 its required return is 11.75 and the risk-free rate is4.30. what is the required rate of

  Results or comparison of current results

Which do you think provides a more valid measure of how a company is doing, comparison of current results with historical results or comparison of current results with the current results of another company?

  Yu are able to buy an investment for 1000 that gives you

you are able to buy an investment for 1000 that gives you the right to receive 438 in each of the next three years.

  Why may an analysis that makes even a rough estimate of the

why may an analysis that makes even a rough estimate of the probability distribution of project npv or irr be

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