Calculate mean-variance and standard deviation of stocks

Assignment Help Financial Management
Reference no: EM132529237

1. Select the stocks of three publicly traded companies from different industries. State the criteria for selecting those securities.

2. Retrieve monthly data on adjusted closing prices of your securities from Yahoo Finance for the past 10 years and calculate the monthly rate of return of the stocks for every month.

3. Calculate the mean, variance, and standard deviation of the stocks' monthly returns.

4. Calculate the correlation coefficient between every possible pair of stocks' returns.

5. Decide what percentage of your money (weights) you want to invest in each stock and state the criteria you used to select those weights.

6. Now calculate your portfolio's mean monthly return, variance, and standard deviation.

7. Assuming your portfolio return follows a normal distribution, calculate the chance that your portfolio loses 10% of its value during any month?

8. Assuming you have invested $100,000 in your portfolio, what is value at risk (VaR) of your portfolio at any particular month at 99% confidence level?

9. Now randomly change your portfolio's weights 100 times (note total weights should always be 100%), for each weight combination calculate the mean and standard deviation of your portfolio, and then draw the efficient frontier.

10. For each item mentioned above explain your rationale and cite peer-reviewed and/or seminal sources.

Reference no: EM132529237

Questions Cloud

Construction of a nuclear power plant : A study is carried out to estimate the proportion of residents of a certain city and its suburbs who are in favor of the construction of a nuclear power plant.
Powerful tools in statistician toolbox : This week covers some of the most powerful tools in the statistician's toolbox, including hypothesis testing and regression.
What is the probability that exactly 7 individuals : what is the probability that exactly 7 individuals will develop drug-induced lupus from the drug?
Calculate the mean sample with which it was obtained : We know that the confidence level is of 97% and a sample of 56. Calculate the mean sample with which it was obtained in that interval
Calculate mean-variance and standard deviation of stocks : Select stocks of three publicly traded companies from different industries. Calculate the mean, variance, and standard deviation of the stocks' monthly returns.
Calculate the lease receivable for Bravo : Collectability of lease payments by Bravo is probable. Calculate the lease receivable for Bravo at the lease inception date. Show all calculations
Journalize the entry to record the transaction on october : On October 1, Bentley Delivery Services acquired a new truck with a list price of $112,000. Journalize the entry to record the transaction on October
Determine the standard error of the proportion : 1) There are 500 employees in a dorm, 45% are female. A sample of 60 employees is selected randomly.
What is the probability a random individual : A researcher wants to know the probability that a random individual's IQ will fall between 107 and 123. If the mean IQ score for the population is 100 and the s

Reviews

Write a Review

Financial Management Questions & Answers

  What is the duration of the bank commercial loan portfolio

The general level of interest rates is 7%. What is the duration of the bank’s commercial loan portfolio?

  What is the company cost of equity capital

The expected return on the market is 11 percent, what is the company’s cost of equity capital?

  Value of each investment based on required rate of return

You have the three following alternatives for investing that money. Calculate the value of each investment based on your required rate of return.

  Difference between data mining and data warehousing

What is the difference between data mining, data warehousing, and data analytics?

  What is the company total book value of debt

The company’s tax rate is 35 percent. What is the company’s total book value of debt?

  Forecasting interest rates based on prevailing conditions

discuss the impact of each of the factors on your opinion. Offer some logic or current reference(s) to support your answer. Which factor do you think will have the biggest impact on interest rates?

  How much would you have for down payment

You want to buy a house within 3 years, and you are currently saving for the down payment. How much would you have for a down payment at the end of Year 3?

  Calculate the beginning-of-year balance for long-term debt

Dogs 4 U Corporation has net cash flow from financing activities for the last year of $43 million. Calculate the beginning-of-year balance for long-term debt.

  What will the family balance be on the mortgage

A family takes out a mortgage for $287,200.00 from the local bank. What will the family’s balance be on the mortgage after 6.00 years?

  What will be flotation-adjusted cost of equity

Suppose that Brown-Murphies’ common shares sell for $16.50 per share, What will be the flotation-adjusted cost of equity?

  Calculate the standard deviation of NPV

Calculate the standard deviation of NPV and the coefficient of variance of the NPV.

  Discussion of the type of accounting and finance software

For the purposes of this curriculum, we will concentrate on the financial and funding request portions of the plan for your small business.

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