User Account

All Pages

Compute the mean and standard deviation of the returns

Assignment Help Finance Basics
Reference no: EM1381072

Portfolio Optimization

1. You have decided to invest in a portfolio that includes all companies in the Dow Jones Industrials Index. A list of the companies in the index can be found in Yahoo Finance (go to Market Data, then Stocks, select Dow Jones Industrial Average, and then look for "Index Components"). You should find 30 companies.

2. Compute monthly returns for the last five years for each of the companies in the portfolio. Use the data in Adj Close when you download monthly prices from Yahoo Finance. Your sample of historical returns should have 60 observations.

3. Compute the Mean and Standard Deviation of the Returns.

4. Estimate the variance-covariance matrix using both the covariance.s function in excel and matrix multiplication. Check that you get the same values using either approach.

5. Generate and plot the envelope curve using the following alternative approaches:

5A. Maximize the ratio E(rx - c)/σx for an arbitrary c (use solver)

5B. Minimize the portfolio variance for an arbitrary return (use solver). Assume the same portfolio return you obtained under approach 5A. Check that the portfolios are the same using both approaches.

6. Estimate the Minimum-Variance Portfolio.

7. Estimate the Optimal Portfolio. Use the current value of the 6 month T-bill as a proxy for the risk free rate. Find the expected return and variance for this portfolio.

8. Estimate the Optimal Portfolio assuming that no short sales are allowed. What is the expected return and variance of this portfolio?

9. Estimate the Optimal Portfolio assuming that no short sales are allowed and no more than 20% should be invested in a single stock. What is the expected return and variance of this portfolio?

Reference no: EM1381072

Questions Cloud

Elucidate how would you participate in this debate : the leader of an environmental NGO in the low-cost country in which the MNE invests, elucidate how would you participate in this debate.
Creating a gaming web page : Build a Web page called "game.html" and add a layer to it, which will be treated as an object, with an picture for its contents. Add another picture which will start the game when clicked on.
Why segmentation efforts based on attempts to divide : Illustrate what is the difference among qualifying dimensions also determining dimensions. Explain why segmentation efforts based on attempts to divide the mass market utilizing a few demographic dimensions may be very disappointing.
Attempting to demonstrate knowledge and expertise : How can this be useful to organizations that might be seeking to develop a program that is attempting to demonstrate knowledge and expertise?
Compute the mean and standard deviation of the returns : Estimate the Optimal Portfolio. Use the current value of the 6 month T-bill as a proxy for the risk free rate. Find the expected return and variance for this portfolio.
Explain why have pet supply purchases been relatively : Explain why have pet supply purchases been relatively unaffected by the economic downturn of 2008-2010.
Identified that joe has a high need for achievement : You manage a department of four employees. You have identified that Joe has a high need for achievement. Mary has a high need for power, and Tim has a high need for affiliation
Elucidate how the human resources assistance plan : elucidate how the human resources assistance plan also aids you have been working on for your final project fit into the company's strategic plan.
How can managers and hr departments minimize the likelihood : How can managers and HR departments minimize the likelihood of disputes arising over whether employees are continuing to perform at the same level?

Reviews

Write a Review

Finance Basics Questions & Answers

  Stock price and dividend problem-texas corporation

Texas Corporation stock pays a dividend on every July 15. In 2008: the dividend is $3.00, in 2009 $3.25, in 2010 $3.50, and in 2011 and all the subsequent years it will be $4.00.

  Amortization expense

Dade buy a patent on January 1, 2003 for $120,000. The patent had a remaining useful life of ten years at that date. In January 2004, Dade successfully defends patent at a cost of $54,000,

  Objective type questions on bond investment and interest

Objective type questions on Bond investment and interest rates and Which one of the following rates is the best measure of the increased purchasing power you can realize from a bond investment

  Future competitive success of southwest airlines

Write down the major factors for the future competitive success of southwest airlines.

  Computation of the present value of the contract

Computation of the present value of the contract and what was the present value of this contract in January when Schneider signed it

  Find the market value and cost of capital

The U Corporation and the L Corporation are identical in all aspects except that U Co. is all-equity financed while L Co. has $1,000 debt in 6% perpetual bonds outstanding.

  Future value of annuity exercise

Using the appropriate tabels find out how much will be accumulated in the fund on December 31, 2012 under each of the following situations:

  Money-bond-stock and mortgage markets

The critical importance of money, bond, stock and mortgage markets as potential investment options is highlighted in terms of their impact on financial sector. Describe the linkages between each market, and how investors' choices would be affected.

  Find value of the stock and expected price

A company paid a dividend of 1.80 per share but the dividend is expected to increase to 4 percent per year. The risk free rate is 6% and the market risk premium is 5 percent.

  Find the stock price at the end of three years

Suppose you are planning an investment in the common stock of Crisp's Cookware. The stock is expected to pay a dividend of $2 a share at the end of the year (D1 = $2.00).

  Compute the anticipated value of the dividends

Hunter Petroleum Company paid a $2 dividend last year. The dividend is expected to increase at a constant rate of 5% over the next 3-years. The required rate of return is 12%

  Find the amount of depreciation expense

A factory equipment was purchased for $60,000 on January 1, 2006. It was estimated that it would have a $12,000 salvage value at the end of its five year useful life.

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