Create a histogram using daily returns for the past years

Assignment Help Financial Management
Reference no: EM131993769

If I have stata and an excel file, how would I calculate these problems with a porfolio of stocks where one stock is 50% and the other two are 25%.

Could you give me step by step how to go about solving that.  I have the stocks on a spreadsheet but I can't post it on here unless you give me a way to do that.

(a) Create a histogram using daily returns for the past 10 years for each of your stocks AND for your portfolio. Do they look like a normal distributions? (Hint: Try small bins-length 0.1 percentage points.)

(b) Create a histogram using daily returns for the past 10 years for the S&P 500. Does it look like a normal distribution?

Reference no: EM131993769

Questions Cloud

Maintain an output power of 450 w : At this output power, how long would it take an 85kg cyclist (including the mass of his bike) to climb the famed 1100-m-high Alpe d'Huez mountain stage?
Calculate the required return on stars : Stars, Inc. Company's common stock has a beta of 1.89. If the risk-free rate is 3.7 percent and the market return is 9.37 percent.
Larger kinetic energy : Just before they hit the ground, which ball, if either, has the larger kinetic energy? Explain.
Why is assumption in b potentially problematic : Would you recommend using the NPV or IRR methodology to evaluate this project? Why?Why is assumption in b potentially problematic?
Create a histogram using daily returns for the past years : If I have stata and an excel file, how would I calculate these problems with a porfolio of stocks where one stock is 50% and the other two are 25%.
What are good ways to learn how to calculate ph : What are good ways to learn how to calculate pH? I know that pH is a measure of acidity, and that it is calculated using hydrogen ion and hydroxide percentages
Calculate GDP using the income method : BUECO5903 BUSINESS ECONOMICS ASSIGNMENT PART - MACROECONOMICS. Calculate GDP using the income method
What is the expected return of the portfolio : Your portfolio is invested 31 percent each in A and C and 38 percent in B. What is the expected return of the portfolio?
What would it actually be worth in dollars to you : The state lottery claims that its grand prize is $1 million. The lucky winner will receive $50,000 upon presentation of the winning ticket plus.

Reviews

Write a Review

Financial Management Questions & Answers

  What is the current market value of the company debt

What is the current market value of the company’s equity? What is the current market value of the company’s debt?

  Differently in implementation of act at executive-federal

According to Lewin’s model, what things did President Obama do well to manage the change? Why do you suppose many people are strongly against the change? Please provide factual support for your point of view. What do you think could have been done di..

  What will be the value of the bond next year

You own a 5 year bond with a face value of $1,000 and a coupon rate of 5 percent with annual payments. The bond is currently worth $810.46. If market interest rates remain unchanged, what will be the value of the bond next year when there are 4 years..

  How are exchange-traded funds-unit investment trusts

How are exchange-traded funds (ETFs) and unit investment trusts (UITs) different from index mutual funds, and from each other? Please list your points.

  Calculate the npv for each of the projects

Using 14% of the cost of capital calculate the NPV for each of the projects shown in the following table and indicate whether or not each is acceptable.

  Retrofitted space-heating system

A retrofitted space-heating system is being considered for a small office building.

  Portfolio consists of two stocks-portoflio weight of stock

Your portoflio consists of two stocks 50 shares of stock A that sell for 42 per share and 115 shares of stock B that sell for 34 per share.

  Treasury securities are yielding

ABC Company has an after-tax cost of debt of 6 percent, beta of .85, tax rate of   35 percent, and a target capital structure of 60 percent equity and 40 percent debt.  Ten year Treasury securities are yielding 4 percent and the risk premium for ABC ..

  What is the future value of annuity payment

What is the future value of a $810 annuity payment over four years if interest rates are 8 percent?

  Calculate the NPV of project is MACRS depreciation is used

White Enterprises just invested in a black light health management system at a cost of $600,000. Calculate the NPV of the project is MACRS depreciation is used.

  Capital budgeting analysisthe sl energy group is planning a

capital budgeting analysisthe sl energy group is planning a new investment project which is expected to yield cash

  How and when development expenditure should be amortised

Explain why expenditure on research is treated differently from expenditure on development.- State the criteria to be demonstrated for expenditure on development to be recognised as an intangible asset.

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